unset($_REQUEST['modfunc']);
}
}
}
}
unset($_SESSION['_REQUEST_vars']['modfunc']);
}
if (!$_REQUEST['modfunc'] && $course_id) {
// ASSIGNMENT TYPES
$sql = ' SELECT ASSIGNMENT_TYPE_ID,TITLE
FROM (
( select gat.ASSIGNMENT_TYPE_ID,gat.TITLE FROM gradebook_assignment_types gat where gat.COURSE_PERIOD_ID=\'' . $course_period_id . '\' )
UNION
(SELECT gat.ASSIGNMENT_TYPE_ID as ASSIGNMENT_TYPE_ID,concat(gat.TITLE,\' (\',cp.title,\')\') as TITLE FROM gradebook_assignment_types gat , gradebook_assignments ga, course_periods cp
where cp.course_period_id =gat.course_period_id and gat.ASSIGNMENT_TYPE_ID=ga.ASSIGNMENT_TYPE_ID AND ga.COURSE_ID IS NOT NULL
AND ga.COURSE_PERIOD_ID IS NULL AND ga.COURSE_ID=\'' . UserCourse() . '\' AND ga.STAFF_ID=\'' . UserID() . '\' )
)as t
GROUP BY ASSIGNMENT_TYPE_ID';
$QI = DBQuery($sql);
$types_RET = DBGet($QI);
if ($_REQUEST['assignment_id'] != 'new' && $_REQUEST['assignment_type_id'] != 'new') {
$delete_button = "<INPUT type=button value=" . _('Delete') . " onClick='javascript:window.location=\"Modules.php?modname={$_REQUEST['modname']}&modfunc=delete&assignment_type_id={$_REQUEST['assignment_type_id']}&assignment_id={$_REQUEST['assignment_id']}\"'>";
}
// ADDING & EDITING FORM
if ($_REQUEST['assignment_id'] && $_REQUEST['assignment_id'] != 'new') {
$sql = 'SELECT ASSIGNMENT_TYPE_ID,TITLE,ASSIGNED_DATE,DUE_DATE,POINTS,COURSE_ID,DESCRIPTION,
CASE WHEN DUE_DATE<ASSIGNED_DATE THEN \'Y\' ELSE NULL END AS DATE_ERROR
FROM gradebook_assignments
WHERE ASSIGNMENT_ID=\'' . $_REQUEST['assignment_id'] . '\'';
$QI = DBQuery($sql);
$RET = DBGet($QI);
if (!UserCourse()) {
$_SESSION['UserCourse'] = $RET[1]['COURSE_ID'];
}
echo "<SELECT name=course onChange='this.form.submit();'>";
if (count($RET) > 0) {
foreach ($RET as $course) {
echo "<OPTION id={$course['COURSE_ID']} value={$course['COURSE_ID']}" . (UserCourse() == $course['COURSE_ID'] ? ' SELECTED' : '') . ">" . $course['COURSE_TITLE'] . "</OPTION>";
}
} else {
echo '<OPTION value="">n/a</OPTION>';
}
echo "</SELECT>";
//===================================================================================================
echo "</FORM></td><td></td>";
echo "<td><FORM name=head_frm id=head_frm action=Side.php?modfunc=update&btnn={$btn}&nsc={$ns}&act=period method=POST><INPUT type=hidden name=modcat value='' id=modcat_input>";
$QI = DBQuery("SELECT cpv.ID,cp.COURSE_PERIOD_ID,cp.MARKING_PERIOD_ID,cp.COURSE_ID,cp.TITLE,cp.SCHOOL_ID,cpv.PERIOD_ID FROM course_periods cp,course_period_var cpv WHERE cp.SYEAR='" . UserSyear() . "' AND cp.COURSE_PERIOD_ID=cpv.COURSE_PERIOD_ID AND cp.SCHOOL_ID='" . UserSchool() . "' AND cp.COURSE_ID='" . UserCourse() . "' AND (TEACHER_ID='" . User('STAFF_ID') . "' OR SECONDARY_TEACHER_ID='" . User('STAFF_ID') . "') AND (MARKING_PERIOD_ID IN (" . GetAllMP($allMP, UserMP()) . ") OR (MARKING_PERIOD_ID IS NULL)) group by (cp.COURSE_PERIOD_ID)");
$RET = DBGet($QI);
$user_profile_ret = DBGet(DBQuery(" SELECT PROFILE FROM staff WHERE STAFF_ID=" . UserID()));
if (!CpvId()) {
$_SESSION['CpvId'] = $RET[1]['ID'];
}
$fy_id = DBGet(DBQuery("SELECT MARKING_PERIOD_ID FROM school_years WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'"));
$fy_id = $fy_id[1]['MARKING_PERIOD_ID'];
if (!UserCoursePeriod()) {
$_SESSION['UserCoursePeriod'] = $RET[1]['COURSE_PERIOD_ID'];
}
echo "<SELECT name=period onChange='this.form.submit();'>";
if (count($RET) > 0) {
$flag = 0;
foreach ($RET as $period) {
$x_sel = "";
echo "<OPTION id={$course['COURSE_ID']} value={$course['COURSE_ID']}" . (UserCourse() == $course['COURSE_ID'] ? ' SELECTED' : '') . ">" . $course['COURSE_TITLE'] . "</OPTION>";
if (UserCourse() == $course['COURSE_ID']) {
//$_SESSION['UserSchool'] = $period2['SCHOOL_ID'];
//$_SESSION['UserSubject'] = $period2['SUBJECT_ID'];
$_SESSION['UserCourse'] = $course['COURSE_ID'];
//$_SESSION['UserPeriod'] = $period2['PERIOD_ID'];
//unset($_SESSION['UserCoursePeriod']);
}
}
echo "</SELECT>";
//===================================================================================================
echo "</FORM></td><td></td>";
echo "<td><FORM name=head_frm id=head_frm action=Side.php?modfunc=update&btnn={$btn}&nsc={$ns}&act=period method=POST><INPUT type=hidden name=modcat value='' id=modcat_input>";
//echo "SELECT DISTINCT cp.PERIOD_ID,cp.COURSE_PERIOD_ID,sp.TITLE,sp.SHORT_NAME,cp.MARKING_PERIOD_ID,cp.DAYS,sp.SORT_ORDER,c.TITLE AS COURSE_TITLE FROM COURSE_PERIODS cp, SCHOOL_PERIODS sp,COURSES c WHERE c.COURSE_ID=cp.COURSE_ID AND cp.PERIOD_ID=sp.PERIOD_ID AND cp.SYEAR='".UserSyear()."' AND cp.SCHOOL_ID='".UserSchool()."' AND cp.TEACHER_ID='".UserStaffID()."' ORDER BY sp.SORT_ORDER ";
//$QI = DBQuery("SELECT DISTINCT cp.PERIOD_ID,cp.COURSE_PERIOD_ID,sp.TITLE,sp.SHORT_NAME,c.SUBJECT_ID,cp.MARKING_PERIOD_ID,cp.DAYS,cp.SCHOOL_ID,sp.SORT_ORDER,c.TITLE AS COURSE_TITLE FROM COURSE_PERIODS cp, SCHOOL_PERIODS sp,COURSES c WHERE c.COURSE_ID=cp.COURSE_ID AND cp.PERIOD_ID=sp.PERIOD_ID AND cp.SYEAR='".UserSyear()."' AND cp.TEACHER_ID='".User('STAFF_ID')."' AND cp.SCHOOL_ID='".UserSchool()."' AND c.SUBJECT_ID='".UserSubject()."' AND cp.COURSE_ID='".UserCourse()."' ORDER BY sp.SORT_ORDER ");
$QI = DBQuery("SELECT COURSE_PERIOD_ID,COURSE_ID,TITLE,SCHOOL_ID,PERIOD_ID FROM COURSE_PERIODS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "' AND COURSE_ID='" . UserCourse() . "' AND (TEACHER_ID='" . User('STAFF_ID') . "' OR SECONDARY_TEACHER_ID='" . User('STAFF_ID') . "') AND MARKING_PERIOD_ID IN (" . GetAllMP($allMP, UserMP()) . ")");
$RET = DBGet($QI);
$fy_id = DBGet(DBQuery("SELECT MARKING_PERIOD_ID FROM SCHOOL_YEARS WHERE SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'"));
$fy_id = $fy_id[1]['MARKING_PERIOD_ID'];
//if(!UserPeriod())
//$_SESSION['UserPeriod'] = $RET[1]['PERIOD_ID'];
if (!UserCoursePeriod()) {
//echo "hello";
//echo $RET[1]['COURSE_PERIOD_ID'];
$_SESSION['UserCoursePeriod'] = $RET[1]['COURSE_PERIOD_ID'];
}
echo "<SELECT name=period onChange='this.form.submit();' style='width:150;'>";
foreach ($RET as $period) {
// echo "<OPTION id=$period[COURSE_PERIOD_ID] value=$period[COURSE_PERIOD_ID]".((UserCoursePeriod()==$period['COURSE_PERIOD_ID'])?' SELECTED':'').">".$period['SHORT_NAME'].($period['MARKING_PERIOD_ID']!=$fy_id?' '.GetMP($period['MARKING_PERIOD_ID'],'SHORT_NAME'):'').(strlen($period['DAYS'])<5?' '.$period['DAYS']:'').' - '.$period['COURSE_TITLE']."</OPTION>";
echo "<OPTION id={$period['COURSE_PERIOD_ID']} value={$period['COURSE_PERIOD_ID']}" . (UserCoursePeriod() == $period['COURSE_PERIOD_ID'] ? ' SELECTED' : '') . ">" . $period['TITLE'] . "</OPTION>";
if (UserCoursePeriod() == $period['COURSE_PERIOD_ID']) {
