public function send__sms_student()
{
$data = array();
$filterColumns = array();
$offset = NULL;
$limit = NULL;
$sort = array();
$session_Id = NULL;
$class_section_Id = NULL;
$this->template->getHeader();
$this->template->getLeftbar();
$data['session'] = retrieve_records($filterColumns = NULL, $offset = NULL, $limit = NULL, $sort = NULL, "ems_session");
$data['classSecton'] = getClass_section();
if ($this->input->post('session_id')) {
$session_Id = (int) $this->input->post('session_id');
$filterColumns['session_id'] = $session_Id;
}
if ($this->input->post('class_section_id')) {
$class_section_Id = (int) $this->input->post('class_section_id');
$filterColumns['class_section_id'] = $class_section_Id;
}
if ($session_Id == 0 && $class_section_Id == 0) {
$data['studentListForSendSms'] = getStudentBySessionId_ClassSectionId($filterColumns, $offset, $limit, $sort);
} else {
$data['studentListForSendSms'] = getStudentBySessionId_ClassSectionId($filterColumns, $offset, $limit, $sort);
}
$this->load->view('student/sms/studentlist_for_sms', $data);
$this->template->getFooter();
}
public function student_list($class_section_id = "", $session_id = "")
{
$data = array();
$filterColumns = array();
$offset = NULL;
$limit = NULL;
$sort = array();
$session_Id = NULL;
$class_section_Id = NULL;
$this->template->getScript();
$this->template->getAdminHeader();
$this->template->getAdminLeftBar();
$data['session'] = retrieve_records($filterColumns = NULL, $offset = NULL, $limit = NULL, $sort = NULL, "ems_session");
$data['classSecton'] = getClass_section();
$data['session_id'] = 0;
$data['class_section_id'] = 0;
$data['approvemsg'] = "";
$data['apprrove'] = 0;
$data['StudentAttendance'] = array();
$data['studentListForSendSms'] = array();
if ($this->input->post('session_id') > 0) {
$session_Id = (int) $this->input->post('session_id');
$filterColumns['session_id'] = $session_Id;
$data['session_id'] = $session_Id;
}
if ($this->input->post('class_section_id') > 0) {
$class_section_id = (int) $this->input->post('class_section_id');
$filterColumns['class_section_id'] = $class_section_id;
$data['class_section_id'] = $class_section_id;
}
if ($session_Id > 0 and $class_section_id > 0) {
$recordsFound = getStudentBySessionId_ClassSectionId($filterColumns, $offset, $limit, $sort);
$data['studentListForSendSms'] = $recordsFound;
}
$this->load->view('student_menu/student_list', $data);
$this->template->getFooter();
}
public function teachertimetable()
{
$teacgerDetail = $this->session->userdata('teacher');
$data = array();
$this->template->getScript();
$this->template->getTeacherHeader();
$this->template->getTeacherLeftBar();
$currentSession = $this->sessionModel->getCurrent_Session();
$data['session_id'] = $currentSession[0]->session_id;
$currentSeason = $this->seasonModel->getCurrent_season($currentSession[0]->session_id);
$data['season_id'] = $currentSeason[0]->season_id;
$periodfilterColumns = array('session_id' => $data['session_id'], 'season_id' => $data['season_id']);
$period = retrieve_records($periodfilterColumns, $offset = NULL, $limit = NULL, $sort = NULL, "ems_period_time");
$periodArray = array();
if (!isset($period['status'])) {
foreach ($period as $period) {
$filterColumns = array('period_id' => $period->period_id, 'session_id' => $data['session_id'], 'season_id' => $data['season_id'], 'teacher_id' => $teacgerDetail['staff_id']);
$dailtTimeTable = retrieve_records($filterColumns, $offset = NULL, $limit = NULL, $sort = NULL, "ems_daily_timetable");
$weekDayArray = array();
if (!isset($dailtTimeTable['status'])) {
$weekDayArray = array();
foreach ($dailtTimeTable as $dailyRow) {
$TfilterColumns = array('school_user_type_id' => 1, 'staff_id' => $dailyRow->teacher_id);
$teachetData = retrieve_records($TfilterColumns, $offset = NULL, $limit = NULL, $sort = NULL, "ems_staff");
$teacherName = "";
$teacherName = $teachetData[0]->first_name;
if ($teachetData[0]->first_name) {
$teacherName = $teacherName . " " . $teachetData[0]->middle_name;
}
if ($teachetData[0]->first_name) {
$teacherName = $teacherName . " " . $teachetData[0]->last_name;
}
$PfilterColumns = array('paper_id' => $dailyRow->paper_id);
$paperData = retrieve_records($PfilterColumns, $offset = NULL, $limit = NULL, $sort = NULL, "ems_paper");
$paperName = "";
$paperName = $paperData[0]->paper_name;
$ClassSection = getClass_section($dailyRow->class_section_id);
$weekDayArray[$dailyRow->week_day] = array('class_section' => $ClassSection[0]->class_name . '-' . $ClassSection[0]->section_name, 'start_time' => $period->start_time, 'end_time' => $period->end_time, 'teacherName' => $teacherName, 'teacher_id' => $dailyRow->teacher_id, 'paperName' => $paperName, 'paper_id' => $paperData[0]->paper_id, 'daily_timetable_id' => $dailyRow->daily_timetable_id);
}
}
$periodArray[$period->period_num . '-' . $period->period_id . '-' . $period->start_time . '-' . $period->end_time] = $weekDayArray;
}
}
$data['period'] = $periodArray;
$this->load->view('timetable/student_daily_timetable', $data);
$this->template->getFooter();
}
public function approve_attendance()
{
$data = array();
$filterColumns = array();
$offset = NULL;
$limit = NULL;
$sort = array();
$session_Id = NULL;
$class_section_Id = NULL;
$this->template->getScript();
$this->template->getAdminHeader();
$this->template->getAdminLeftBar();
$data['session'] = retrieve_records($filterColumns = NULL, $offset = NULL, $limit = NULL, $sort = NULL, "ems_session");
$data['classSecton'] = getClass_section();
$data['session_id'] = 0;
$data['class_section_id'] = 0;
$data['approvemsg'] = "";
$data['apprrove'] = 0;
$data['StudentAttendance'] = array();
$data['studentListForSendSms'] = array();
if ($this->input->post('session_id')) {
$session_Id = (int) $this->input->post('session_id');
$filterColumns['session_id'] = $session_Id;
$data['session_id'] = $session_Id;
}
if ($this->input->post('class_section_id')) {
$class_section_Id = (int) $this->input->post('class_section_id');
$filterColumns['class_section_id'] = $class_section_Id;
$data['class_section_id'] = $class_section_Id;
}
if ($this->input->post('session_id') > 0 and $this->input->post('class_section_id') > 0) {
$recordsFound = getStudentBySessionId_ClassSectionId($filterColumns, $offset, $limit, $sort);
$data['studentListForSendSms'] = $recordsFound;
if (isset($recordsFound['result'])) {
} else {
$studentListForSendSms = $data['studentListForSendSms'];
$student_teacher_class_id = array();
for ($i = 0; $i < count($studentListForSendSms); $i++) {
$student_teacher_class_id[] = $studentListForSendSms[$i]->student_teacher_class_id;
}
$totalApprove = $this->attendanceModel->checkStudentAttendanceApprove($student_teacher_class_id, date('Y-m-d'));
if ($totalApprove > 0) {
$data['approvemsg'] = "Attendance already approved";
$data['apprrove'] = 1;
}
$data['StudentAttendance'] = $this->attendanceModel->getStudentAttendance($student_teacher_class_id, date('Y-m-d'));
}
}
$this->load->view('attendance/student_attendance_approve', $data);
$this->template->getFooter();
}
