------ permissions ------
$permissions = new Permissions;
$permissions = unserialize($_SESSION['permissions']);
$myPerm = $permissions->sections['admin']['dates']->permission;
BEGIN
DECLARE master_id INT;
DECLARE new_course_id INT;
SELECT course_master_id INTO master_id FROM `vw_course_link` where class = o_class and course_id = o_course_id;
SELECT case EXISTS(SELECT * FROM `vw_course_link` where class = 111 and course_master_id = master_id) when false THEN o_course_id ELSE (SELECT course_id FROM `vw_course_link` where class = n_class and course_master_id = master_id) END INTO new_course_id;
RETURN new_course_id;
END
BEGIN
DECLARE n_student_id INT;
DECLARE student_class INT;
DECLARE student_status INT;
SELECT `class` INTO `student_class` FROM `students` WHERE `id` = o_student_id;
SELECT `status` INTO `student_status` FROM `students` WHERE `id` = o_student_id;
UPDATE `students` SET `status` = '3', `updated_at` = today_date WHERE `id` = o_student_id;
IF `student_status` = 1 THEN INSERT INTO `withdrawals` (`student_id`, `date`, `from_class`, `created_at`, `updated_at`) VALUES (o_student_id, update_date, student_class, today_date, today_date); END IF;
INSERT INTO `students` (`status`, `class`, `ssn`, `last_name`, `first_name`, `middle_name`, `maiden_name`, `address_1`, `address_2`, `city`, `state`, `zip`, `phone`, `email`, `created_at`, `updated_at`, `dob`) SELECT '1', n_class, `ssn`, `last_name`, `first_name`, `middle_name`, `maiden_name`, `address_1`, `address_2`, `city`, `state`, `zip`, `phone`, `email`, today_date, today_date, `dob` FROM `students` WHERE `id`= o_student_id;
SELECT LAST_INSERT_ID() INTO n_student_id;
UPDATE current_students SET `student_id` = n_student_id WHERE `student_id` = o_student_id;
UPDATE `grades` SET course_id = udf_get_course_class_link (course_id, student_class, n_class), class_id = n_class, student_id = n_student_id, is_transfer=1, transfer_from_class=student_class, `updated_at` = today_date WHERE student_id = o_student_id and class_id = student_class and find_in_set(course_id, t_courses);
INSERT INTO `transfers2` (`old_student_id`, `new_student_id`, `old_class_id`, `new_class_id`, `levels_transfered`, `reentry_date`, `create_date`) VALUES (o_student_id, n_student_id, student_class, n_class, t_courses, r_date, today_date);
SELECT n_student_id AS new_student_id;
END
select
`com`.`id` AS `course_master_id`,
`cl`.`course_id` AS `course_id`,
`cm`.`level` AS `level`,
`cm`.`has_children` AS `has_children`,
(case when (`cm`.`parent_course_master_id` is not null) then 1 else 0 end) AS `is_child`,
`cw`.`weight` AS `weight`,
`cm`.`class` AS `class`,
`cm`.`student_id` AS `student_id`
from
`curricula_master` `cm`
join `course_link` `cl` on `cm`.`id` = `cl`.`curricula_master_id`
join `course_master` `com` on `cm`.`course_master_id` = `com`.`id`
left join `course_weight` `cw` on `cm`.`id` = `cw`.`curricula_master_id`
left join `course_other_data` `cod` on `cl`.`course_id` = `cod`.`course_id` and `cm`.`class` = `cod`.`class`
union select NULL AS `course_master_id`,68 AS `course_id`,1 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,68 AS `course_id`,2 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,68 AS `course_id`,3 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,68 AS `course_id`,4 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,69 AS `course_id`,1 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,69 AS `course_id`,2 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,69 AS `course_id`,3 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,69 AS `course_id`,4 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,85 AS `course_id`,1 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,85 AS `course_id`,2 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,85 AS `course_id`,3 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
union select NULL AS `course_master_id`,85 AS `course_id`,4 AS `level`,0 AS `has_children`,0 AS `is_child`,0 AS `weight`,NULL AS `class`, NULL AS `student_id`
UPDATE `grades`
SET course_id = udf_get_course_class_link (course_id, 110, 111),
class_id = 111,
student_id = 8725,
is_transfer=1,
`updated_at` = '2015-04-22'
WHERE
student_id = 7894
and class_id = 110 and find_in_set(course_id, '43,25,22,24,21,23,9,11,10,14,15,67,66,64,65,63,62,13')
select
CASE WHEN `ggo`.`id` IS NULL THEN `gg`.`id` ELSE `ggo`.`id` END AS `id`,
CASE WHEN `ggo`.`id` IS NULL THEN `gg`.`course_id` ELSE `ggo`.`course_id` END AS `course_id`,
CASE WHEN `ggo`.`id` IS NULL THEN `gg`.`class` ELSE `ggo`.class END AS `class`,
CASE WHEN `ggo`.`id` IS NULL THEN `gg`.`student_id` ELSE `ggo`.student_id END AS `student_id`,
CASE WHEN `ggo`.`id` IS NULL THEN `gg`.`grade` ELSE `ggo`.grade END AS `grade`,
CASE WHEN `ggo`.`id` IS NULL THEN `gg`.`is_transfer` ELSE `ggo`.is_transfer END AS `is_transfer`,
CASE WHEN `ggo`.`id` IS NULL THEN `gg`.`transfer_from_class` ELSE `ggo`.transfer_from_class END AS `transfer_from_class`,
CASE WHEN `ggo`.`id` IS NULL THEN `gg`.`permanent` ELSE `ggo`.`permanent` END AS `permanent`,
CASE WHEN `ggo`.`id` IS NULL THEN 0 ELSE 1 END AS `is_override`
from
`grades_generated` `gg`
LEFT JOIN `grades_generated_override` `ggo` ON `gg`.`class` = `ggo`.`class` AND `gg`.`course_id` = `ggo`.`course_id` AND `gg`.`student_id` = `ggo`.`student_id`
WHERE `ggo`.`id` IS NULL
union
select
`grades_generated_override`.`id` AS `id`,
`grades_generated_override`.`course_id` AS `course_id`,
`grades_generated_override`.`class` AS `class`,
`grades_generated_override`.`student_id` AS `student_id`,
`grades_generated_override`.`grade` AS `grade`,
`grades_generated_override`.`is_transfer` AS `is_transfer`,
`grades_generated_override`.`transfer_from_class` AS `transfer_from_class`,
`grades_generated_override`.`permanent` AS `permanent`,
1 AS `is_override`
from `grades_generated_override`
$pTitle = "Student Search: " . $actualfind;
fixes
-------------
1) Grades on student page now show which class they were transfered from
2) Faculty is now hidden on the Student Curriculum page when finalized
3) Clinical Hours are now showing for each course
4) New permission: Grade Override
5) Moved Attendance Override permission to the Student section
phone: data-parsley-pattern="\b\d{3}[-.]?\d{3}[-.]?\d{4}\b"
date: data-parsley-pattern="[01]\d?\/[0123]?\d\/\d{4}"
ssn: data-parsley-pattern="\d{3}[-]?\d{2}[-]?\d{4}"