public function details()
{
// details combines seeing with editing
$id = $_GET['id'];
$columns = array('nom, prenom, nom_khmer, prenom_khmer, sex_id, active_id');
$neat_columns = array('Last Name', 'First Name', 'Last Name Khmer', 'First Name Khmer', 'Genre', 'Active', 'Update', 'Delete');
$form = array('action' => '?controller=teachers&action=update&id=' . $id, 'div' => "class='solitary_input'", 'div_button' => "class='submit_button1'", 'action_links' => array(1 => array('delete', '?controller=teachers&action=delete&id=')), 'method' => 'post', 'id' => 'top_form', 'elements' => array(1 => array('text' => 'nom'), 2 => array('text' => 'prenom'), 3 => array('text' => 'nom_khmer'), 4 => array('text' => 'prenom_khmer'), 5 => array('drop_down' => 'sex_id'), 6 => array('drop_down' => 'active_id'), 7 => array('submit' => 'update')));
$connection = new database();
$table = new simple_table_ops();
$sql = 'SELECT sex_id, sex FROM sexes';
$sex_result = $connection->query($sql);
$sql2 = 'SELECT active_id, active FROM actives';
$active_result = $connection->query($sql2);
$drop_down = array('sex_id' => array('sex' => $sex_result), 'active_id' => array('active' => $active_result));
$table->set_table_name('teachers');
$table->set_id_column('teacher_id');
$table->set_table_column_names($columns);
$table->set_html_table_column_names($neat_columns);
$table->set_values_form();
// set values found in database into form elements when building top_form
$table->set_drop_down($drop_down);
$table->set_form_array($form);
$content = '<table>';
$content .= $table->details();
$content .= '</table>';
$output['content'] = $content;
return $output;
}
public function details()
{
// TODO: details on timetable2 controller
$id = $_GET['id'];
$columns = array('nom, date_from, date_to');
$neat_columns = array('Timetable Name', 'Start Date', 'End Date', 'Action', 'Delete');
$form = array('action' => '?controller=timetable2&action=update&id=' . $id, 'div' => "class='solitary_input'", 'div_button' => "class='submit_button1'", 'action_links' => array(1 => array('delete', '?controller=timetable2&action=delete&id=')), 'method' => 'post', 'id' => 'top_form', 'elements' => array(1 => array('text' => 'nom'), 2 => array('date' => 'date_from'), 3 => array('date' => 'date_to'), 4 => array('submit' => 'update')));
$table = new simple_table_ops();
$table->set_id_column('timetable_period_id');
$table->set_table_column_names($columns);
$table->set_html_table_column_names($neat_columns);
$table->set_form_array($form);
$table->set_table_name('timetable_periods');
$table->set_values_form();
$content = '<table>';
$content .= $table->details();
$content .= '</table>';
$output['content'] = $content;
return $output;
}
public function details()
{
// details combines seeing with editing
$id = $_GET['id'];
$columns = array('weekday');
$neat_columns = array('Week Day', 'Action');
$form = array('action' => '?controller=weekdays&action=update&id=' . $id, 'div' => "class='solitary_input'", 'method' => 'post', 'id' => 'top_form', 'elements' => array(1 => array('text' => 'weekday'), 2 => array('submit' => 'update')));
$table = new simple_table_ops();
$table->set_id_column('weekday_id');
$table->set_table_column_names($columns);
$table->set_html_table_column_names($neat_columns);
$table->set_form_array($form);
$table->set_table_name('weekdays');
$table->set_values_form();
$content = '<table>';
$content .= $table->details();
$content .= '</table>';
$output['content'] = $content;
return $output;
}
public function details()
{
// details combines seeing with editing
$id = $_GET['id'];
$columns = array('level_id');
$neat_columns = array('Level', 'Action');
$form = array('action' => '?controller=courses&action=update&id=' . $id, 'div' => "class='solitary_input'", 'method' => 'post', 'id' => 'top_form', 'elements' => array(1 => array('drop_down' => 'level_id'), 2 => array('submit' => 'update')));
$connection = new database();
$table = new simple_table_ops();
$sql = 'SELECT level_id, level FROM levels ORDER BY level_id ASC';
$levels_result = $connection->query($sql);
$drop_down = array('level_id' => array('level' => $levels_result));
$table->set_id_column('course_id');
$table->set_table_column_names($columns);
$table->set_html_table_column_names($neat_columns);
$table->set_form_array($form);
$table->set_table_name('courses');
$table->set_values_form();
// set values found in database into form elements when building top_form
$table->set_drop_down($drop_down);
$content = '<table>';
$content .= $table->details();
$content .= '</table>';
$output['content'] = $content;
return $output;
}
public function details()
{
//TODO: details in timetable
$connection = new database();
$table = new simple_table_ops();
$id = $_GET['id'];
// timetable_id
$content = "<div class='link_button'>\n <a href='?controller=teachers&action=export'>Export to EXCEL</a>\n <a href='?controller=curricula&action=index'>Curricula</a>\n </div>";
$content .= "<div class='third_left'>";
$content .= '<p>You can configure the timetable for the following course:<p>';
$sql = "SELECT curricula.curriculum_id, CONCAT (teachers.nom, ' ', teachers.prenom, ' | ', teachers.nom_khmer, ' ', teachers.prenom_khmer, ' | ', sexes.sex) as teacher, subjects.subject, levels.level\n FROM curricula\n JOIN courses ON curricula.course_id = courses.course_id\n JOIN subjects ON curricula.subject_id = subjects.subject_id\n JOIN teachers ON teachers.teacher_id = curricula.teacher_id\n JOIN sexes ON teachers.sex_id = sexes.sex_id\n JOIN levels ON courses.level_id = levels.level_id\n JOIN timetables ON timetables.curriculum_id = curricula.curriculum_id\n WHERE timetables.timetable_id = {$_GET['id']}";
$curricula_data = $connection->query($sql);
if ($connection->get_row_num() == 0) {
header("Location: http://" . WEBSITE_URL . "/index.php?controller=curricula&action=index");
}
$curricula_data = $curricula_data[0];
$content .= 'Teacher: ' . $curricula_data['teacher'] . '<br>';
$content .= 'Subject: ' . $curricula_data['subject'] . '<br>';
$content .= 'Level: ' . $curricula_data['level'] . '<br>';
$columns = array('start_time_id, end_time_id, weekday_id, classroom_id, timetable_period_id');
$neat_columns = array('Start Time', 'End Time', 'Week Day', 'Classroom', 'Time Period', 'Update', 'Delete');
// create curriculum_id array
$sql = "SELECT curriculum_id FROM timetables WHERE timetable_id = {$id}";
$curriculum_id_result = $connection->query($sql);
$curriculum_id_array = $curriculum_id_result[0];
// time_id, weekday_id, curriculum_id, classroom_id,
$sql = 'SELECT time_id as start_time_id, time_class as time1 FROM time ORDER BY time_id ASC';
$time1_result = $connection->query($sql);
$sql = 'SELECT time_id as end_time_id, time_class as time2 FROM time ORDER BY time_id ASC';
$time2_result = $connection->query($sql);
$sql = 'SELECT weekday_id, weekday FROM weekdays ORDER BY weekday_id';
$weekdays_result = $connection->query($sql);
$sql = "SELECT timetable_period_id, CONCAT(nom, ', from ', date_from, ' to ', date_to) as timetable_period FROM timetable_periods ORDER BY date_from";
$timetable_periods_result = $connection->query($sql);
$sql = 'SELECT classroom_id, classroom FROM classrooms ORDER BY classroom ASC';
$classrooms_result = $connection->query($sql);
$drop_down = array('start_time_id' => array('start_time' => $time1_result), 'end_time_id' => array('end_time' => $time2_result), 'weekday_id' => array('weekday' => $weekdays_result), 'timetable_period_id' => array('timetable_period' => $timetable_periods_result), 'classroom_id' => array('classroom' => $classrooms_result));
/********************************************************************/
/* CONFIGURES Form structure */
$form = array('action' => '?controller=timetable&action=update&id=' . $id, 'div' => "class='solitary_input'", 'div_button' => "class='submit_button1'", 'method' => 'post', 'action_links' => array(1 => array('delete', '?controller=timetable&action=delete&id=')), 'id' => 'top_form', 'elements' => array(1 => array('hidden' => $curriculum_id_array), 3 => array('drop_down' => 'start_time_id'), 4 => array('drop_down' => 'end_time_id'), 5 => array('drop_down' => 'weekday_id'), 6 => array('drop_down' => 'classroom_id'), 7 => array('drop_down' => 'timetable_period_id'), 10 => array('submit' => 'update')));
$table->set_top_form($form);
$table->set_table_name('timetables');
$table->set_id_column('timetable_id');
$table->set_table_column_names($columns);
$table->set_html_table_column_names($neat_columns);
$table->set_values_form();
// set values found in database into form elements when building top_form
$table->set_drop_down($drop_down);
$table->set_form_array($form);
$content .= "</div>";
$content .= " <div class='two_thirds_right'><table>" . $table->details() . '</table></div>';
$output['content'] = $content;
return $output;
}
public function details2()
{
// details combines seeing with editing
$id = $_GET['id'];
$columns = array('nom, prenom, nom_khmer, prenom_khmer, matricule, dob, program_id, sex_id, active_id');
$neat_columns = array('Last Name', 'First Name', 'Last Name Khmer', 'First Name Khmer', 'Matricule', 'Date of Birth', 'Program', 'Genre', 'Active', 'Update', 'Delete');
$form = array('action' => '?controller=students&action=update&id=' . $id, 'div' => "class='solitary_input'", 'div_button' => "class='submit_button1'", 'action_links' => array(1 => array('delete', '?controller=students&action=delete&id=')), 'method' => 'post', 'id' => 'top_form', 'elements' => array(1 => array('text' => 'nom'), 2 => array('text' => 'prenom'), 3 => array('text' => 'nom_khmer'), 4 => array('text' => 'prenom_khmer'), 5 => array('text' => 'matricule'), 6 => array('text' => 'dob'), 7 => array('drop_down' => 'program_id'), 8 => array('drop_down' => 'sex_id'), 9 => array('drop_down' => 'active_id'), 10 => array('submit' => 'update')));
$connection = new database();
$table = new simple_table_ops();
$sql = 'SELECT sex_id, sex FROM sexes';
$sex_result = $connection->query($sql);
$sql2 = 'SELECT active_id, active FROM actives';
$active_result = $connection->query($sql2);
$sql3 = 'SELECT program_id, program FROM programs';
$programs_result = $connection->query($sql3);
$drop_down = array('sex_id' => array('sex' => $sex_result), 'active_id' => array('active' => $active_result), 'program_id' => array('program' => $programs_result));
$table->set_table_name('students');
$table->set_id_column('student_id');
$table->set_table_column_names($columns);
$table->set_html_table_column_names($neat_columns);
$table->set_values_form();
// set values found in database into form elements when building top_form
$table->set_drop_down($drop_down);
$table->set_form_array($form);
$content = '<table>';
$content .= $table->details();
$content .= '</table>';
//require_once 'models/studentsModel.php'; // needless to add require
$studentsModel_handler = new studentsModel();
$studentsModel_handler->set_student_id($id);
$content .= $studentsModel_handler->get_timetable_html();
$content .= $studentsModel_handler->get_attendance() . "<br>";
$content .= $studentsModel_handler->get_results() . "<br>";
$output['content'] = $content;
return $output;
}
public function details()
{
// details combines seeing with editing
$id = $_GET['id'];
$connection = new database();
$table = new simple_table_ops();
/* Drop down menus */
$sql = "SELECT courses.course_id, levels.level AS level\n FROM courses\n JOIN levels ON courses.level_id = levels.level_id\n WHERE courses.school_year_id = {$_SESSION['current_school_year_id']}\n ORDER BY levels.level_id ASC";
$levels_result = $connection->query($sql);
$sql_teachers = "SELECT teachers.teacher_id, CONCAT (teachers.nom, ' ', teachers.prenom, ' | ', teachers.nom_khmer, ' ', teachers.prenom_khmer, ' | ', sexes.sex) as teacher\n FROM teachers\n JOIN sexes ON teachers.sex_id = sexes.sex_id\n WHERE teachers.active_id=1";
$teachers_result = $connection->query($sql_teachers);
$sql = "SELECT subject_id, subject FROM subjects ORDER BY subject";
$subjects_result = $connection->query($sql);
$drop_down = array('course_id' => array('level' => $levels_result), 'teacher_id' => array('teacher' => $teachers_result), 'subject_id' => array('subject' => $subjects_result));
/* end of drop down menus definition */
$columns = array('course_id, teacher_id, subject_id');
$neat_columns = array('Course', 'Teacher', 'Subject', 'Update', 'Action');
$form = array('action' => '?controller=curricula&action=update&id=' . $id, 'div' => "class='solitary_input'", 'div_button' => "class='submit_button1'", 'action_links' => array(1 => array('delete', '?controller=curricula&action=delete&id=')), 'method' => 'post', 'id' => 'top_form', 'elements' => array(1 => array('drop_down' => 'course_id'), 2 => array('drop_down' => 'teacher_id'), 3 => array('drop_down' => 'subject_id'), 4 => array('submit' => 'update')));
$sql = "SELECT curricula.course_id as course_id, curricula.teacher_id as teacher_id, curricula.subject_id as subject_id\n FROM curricula\n JOIN teachers ON curricula.teacher_id = teachers.teacher_id\n JOIN subjects ON curricula.subject_id = subjects.subject_id\n JOIN courses ON curricula.course_id = courses.course_id\n WHERE curricula.curriculum_id={$_GET['id']}\n ";
$courses_teachers_result = $connection->query($sql);
$courses_teachers_result = $courses_teachers_result[0];
$table->set_table_name('curricula');
$table->set_id_column('curriculum_id');
$table->set_table_column_names($columns);
$table->set_html_table_column_names($neat_columns);
$table->set_values_form_manually($courses_teachers_result);
// set values found in database into form elements when building top_for
$table->set_drop_down($drop_down);
$table->set_form_array($form);
$content = "<div class='link_button'>\n <a href='?controller=curricula&action=export'>Export to EXCEL</a>\n <a href='?controller=timetable&action=show'>Timetable</a>\n <a href='?controller=teachers&action=index'>Teachers</a>\n </div>";
$content .= '<table>';
$content .= $table->details();
$content .= '</table>';
$output['content'] = $content;
return $output;
}
public function details()
{
// details combines seeing with editing
$id = $_GET['id'];
$connection = new database();
$table = new simple_table_ops();
/* Drop down menu */
$sql = "SELECT courses.course_id, levels.level AS level\n FROM courses\n JOIN levels ON courses.level_id = levels.level_id\n WHERE courses.school_year_id = {$_SESSION['current_school_year_id']}\n ORDER BY levels.level_id ASC";
$levels_result = $connection->query($sql);
$drop_down = array('course_id' => array('level' => $levels_result));
/* end of drop down menus definition */
$columns = array('course_id');
// only columns to be updated
$neat_columns = array('Student', 'Genre', 'Program', 'Course', 'Update', 'Remove');
$form = array('action' => '?controller=classes&action=update&id=' . $id, 'div' => "class='solitary_input'", 'div_button' => "class='submit_button1'", 'action_links' => array(1 => array('remove', '?controller=classes&action=remove&id=')), 'method' => 'post', 'id' => 'top_form', 'elements' => array(1 => array('label' => 'student'), 3 => array('label' => 'sex'), 4 => array('label' => 'program'), 6 => array('drop_down' => 'course_id'), 7 => array('submit' => 'update')));
// select row based on id value
$sql = "SELECT classes.course_id as course_id, CONCAT (students.nom, ' ', students.prenom, ', ', students.nom_khmer, ' ', students.prenom_khmer) as student, sexes.sex as sex, programs.program as program\n FROM classes\n JOIN courses ON classes.course_id = courses.course_id\n JOIN students ON classes.student_id = students.student_id\n JOIN sexes ON students.sex_id = sexes.sex_id\n JOIN programs ON students.program_id = programs.program_id\n WHERE classes.classe_id={$_GET['id']}\n ";
$result = $connection->query($sql);
$result = $result[0];
$table->set_table_name('classes');
$table->set_table_column_names($columns);
$table->set_html_table_column_names($neat_columns);
$table->set_values_form_manually($result);
// set values found in database into form elements when building top_for
$table->set_drop_down($drop_down);
$table->set_form_array($form);
$content = '<table>';
$content .= $table->details();
$content .= '</table>';
$output['content'] = $content;
return $output;
}
public function profiles_details()
{
// details combines seeing with editing
$id = $_GET['id'];
$columns = array('profile');
$neat_columns = array('Profile', 'Update', 'Delete');
$form = array('action' => '?controller=admin&action=profiles_update&id=' . $id, 'div' => "class='solitary_input'", 'div_button' => "class='submit_button1'", 'action_links' => array(1 => array('delete', '?controller=admin&action=profiles_delete&id=')), 'method' => 'post', 'id' => 'top_form', 'elements' => array(1 => array('text' => 'profile'), 2 => array('submit' => 'update')));
$table = new simple_table_ops();
$table->set_id_column('profile_id');
$table->set_table_column_names($columns);
$table->set_html_table_column_names($neat_columns);
$table->set_form_array($form);
$table->set_table_name('profiles');
$table->set_values_form();
$content = '<table>';
$content .= $table->details();
$content .= '</table>';
$output['content'] = $content;
return $output;
}
