include 'etc/global_vars.php'; include 'functions/database_functions.php'; include 'functions/global_functions.php'; include 'functions/views_output_functions.php'; include 'functions/editable_grid_conf.php'; include 'html_head.php'; //TODO: set the default POST value to disable the php notice. //Load the file name for post $FILE_NAME = $_SERVER['PHP_SELF']; //QUERY the $semesterListArray $SEMESTER_TABLE_NAME = $PAGE_INFO_ARRAY[$SEMESTER_PAGE_SWITCH]['TABLE_NAME']; $SEMESTER_TABLE_KEY_NAMES_ARRAY = $TABLE_KEY_NAMES_ARRAY[$SEMESTER_PAGE_SWITCH]; $semesterListArray = table_data_query($SEMESTER_TABLE_NAME, $SEMESTER_TABLE_KEY_NAMES_ARRAY); $semesterTargetArray = $_POST['semesterList']; //QUERY the $classlistArray $CLASS_TABLE_NAME = table_name_form($PAGE_INFO_ARRAY, $CLASS_PAGE_SWITCH, $semesterListArray, $semesterTargetArray); $CLASS_TABLE_KEY_NAMES_ARRAY = table_key_names_array_get($CLASS_TABLE_NAME); $classListArray = table_data_query($CLASS_TABLE_NAME, $CLASS_TABLE_KEY_NAMES_ARRAY); //Load in session for global table name load. $_SESSION['targetTableName'] = $CLASS_TABLE_NAME; $_SESSION['targetPageSwitch'] = $PAGE_SWITCH; //------ -[ Views Functions ]- ------ div_head_output_with_class_option("mainMiddle"); //Print Main Title main_title_output($PAGE_INFO_ARRAY, $PAGE_SWITCH); //Print main form div_head_output_with_class_option("form"); //Print form Block form_head_output($FILE_NAME, "post"); //Print semesterList Block div_head_output_with_class_option("mainMiddleBlockLeft");
//Load $courseListArray $COURSE_TABLE_NAME = table_name_form($PAGE_INFO_ARRAY, $COURSE_PAGE_SWITCH, $semesterListArray, $semesterTargetArray); $COURSE_TABLE_KEY_NAMES_ARRAY = $TABLE_KEY_NAMES_ARRAY[$COURSE_PAGE_SWITCH]; $courseListArray = table_data_query($COURSE_TABLE_NAME, $COURSE_TABLE_KEY_NAMES_ARRAY); //Load the course key-name union array $courseKeyNameUnionArray = course_key_name_union_array_get($courseListArray); //Load $totalScheduleArray $TOTAL_SCHEDULE_TABLE_NAME = table_name_form($PAGE_INFO_ARRAY, $TOTAL_SCHEDULE_PAGE_SWITCH, $semesterListArray, $semesterTargetArray); $TOTAL_SCHEDULE_TABLE_KEY_NAMES_ARRAY = table_key_names_array_get($TOTAL_SCHEDULE_TABLE_NAME); //$totalScheduleArray = table_data_query($TOTAL_SCHEDULE_TABLE_NAME, $TOTAL_SCHEDULE_TABLE_KEY_NAMES_ARRAY, "SEMESTER_WEEK = $SEMESTER_WEEK_SET"); //Load $classroomScheduleArray $CLASSROOM_SCHEDULE_TABLE_NAME = table_name_form($PAGE_INFO_ARRAY, $CLASSROOM_SCHEDULE_PAGE_SWITCH, $semesterListArray, $semesterTargetArray); $CLASSROOM_SCHEDULE_TABLE_KEY_NAMES_ARRAY = $TABLE_KEY_NAMES_ARRAY[$CLASSROOM_SCHEDULE_PAGE_SWITCH]; //$classroomScheduleArray = table_data_query($CLASSROOM_SCHEDULE_TABLE_NAME, $CLASSROOM_SCHEDULE_TABLE_KEY_NAMES_ARRAY, "SEMESTER_WEEK = $SEMESTER_WEEK_SET"); //Load $studentsScheduleArray $STUDENTS_SCHEDULE_TABLE_NAME = table_name_form($PAGE_INFO_ARRAY, $STUDENTS_SCHEDULE_PAGE_SWITCH, $semesterListArray, $semesterTargetArray); $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY = $TABLE_KEY_NAMES_ARRAY[$STUDENTS_SCHEDULE_PAGE_SWITCH]; $STUDENTS_SCHEDULE_TABLE_KEY_TYPES_ARRAY = $TABLE_KEY_TYPES_ARRAY[$STUDENTS_SCHEDULE_PAGE_SWITCH]; //Database Query menthod if ($_POST['classListQuery']) { $studentsScheduleArray = table_data_query($STUDENTS_TABLE_NAME, $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY); } //Database Delete method //TODO: Test this method. if ($_POST['classListDelete']) { $studentsScheduleArray = table_data_query($STUDENTS_TABLE_NAME, $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY); $studentsScheduleArrayCount0 = count($studentsScheduleArray); for ($i = 0; $i < $studentsScheduleArrayCount0; $i++) { $targetDeleteId = $studentsScheduleArray[$i]['id']; table_data_delete_by_id($STUDENTS_SCHEDULE_TABLE_NAME, $targetDeleteId); }