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 retrive_student_list()
{
$data = array();
if ($this->input->post('class_section_id')) {
$filterColumns['class_section_id'] = $this->input->post('class_section_id');
$filterColumns['session_id'] = 1;
$data = getStudentBySessionId_ClassSectionId($filterColumns, $offset = NULL, $limit = NULL, $sort = NULL);
// echo $this->db->last_query();echo '<pre>'; print_r($data); die;
if (isset($data['result']) && $data['result'] == 0) {
$studentlist_body = "<div class='alert-box warning'>\n\t\t\t\t\t\t\t\t\t\tRecords Not Found !\n\t\t\t\t\t\t\t\t\t\t<a href='javascript:void(0)' class='close'>×</a>\n\t\t\t\t\t\t\t\t\t</div>";
} else {
$student_list = array();
$count = 0;
foreach ($data as $studentlist) {
$student_data = array();
$student_data['student_id'] = $studentlist->student_id;
$student_data['student_name'] = ucfirst($studentlist->first_name) . ' ' . ucfirst($studentlist->middle_name) . ' ' . ucfirst($studentlist->last_name);
$student_data['father_name'] = ucfirst($studentlist->father_first_name) . ' ' . ucfirst($studentlist->father_middle_name) . ' ' . ucfirst($studentlist->father_last_name);
$student_data['class_section_id'] = $studentlist->class_section_id;
$student_data['mobile'] = $studentlist->parent_mobile;
$student_list[$count] = $student_data;
$count++;
}
$studentlist_body = "<table class='display' id='content_table'>\n\t\t\t\t\t\t\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th><input type='checkbox' onclick='checkedAllStudent()'></th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th>Student Name</th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th>Father Name</th>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<th>Mobile No.</th>\n\t\t\t\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t\t\t</thead>\n\t\t\t\t\t\t\t\t\t\t\t<tbody>";
foreach ($student_list as $studentlistData) {
$studentlist_body .= "<tr>\n\t\t\t\t\t\t\t\t\t\t\t<td class='essential'><input type='checkbox' id='chk_" . $studentlistData['student_id'] . "' name='sms_student_list[" . $studentlistData['student_id'] . "]'></td>\n\t\t\t\t\t\t\t\t\t\t\t<td>" . $studentlistData['student_name'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t<td>" . $studentlistData['father_name'] . "</td>\n\t\t\t\t\t\t\t\t\t\t\t<td>" . $studentlistData['mobile'] . "</td>\n\t\t\t\t\t\t\t\t\t\t</tr>";
}
$studentlist_body .= "</tbody></table>";
}
echo $studentlist_body;
}
}
public function add_optional_paper()
{
$data = array();
$optional_paper = array();
$this->template->getScript();
$this->template->getAdminHeader();
$this->template->getAdminLeftBar();
$data['session'] = retrieve_records($filterColumns = NULL, $offset = NULL, $limit = NULL, $sort = NULL, "ems_session");
$data['paper'] = retrieve_records($filterColumns = NULL, $offset = NULL, $limit = NULL, $sort = NULL, "ems_paper");
$data['class_section'] = $this->classSection->getClass_section();
$data['student'] = getStudentBySessionId_ClassSectionId($filterColumns, $offset = NULL, $limit = NULL, $sort = NULL);
//$data['fee_setting'] = $this->feeModel->getfee_settings();
//$this->retrive_student_name(19);
$this->load->view('paper/add_optional_paper', $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 student_list($class_section_Id = "", $session_Id = "")
{
$data = array();
$filterColumns = array();
$offset = NULL;
$limit = NULL;
$sort = array();
$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'] = $this->classSection->getClass_section();
$data['selected_session'] = $session_Id;
$data['selected_classsecton'] = $class_section_Id;
$filterColumns['session_id'] = $session_Id;
$filterColumns['class_section_id'] = $class_section_Id;
if ($this->input->post('session_id')) {
$session_Id = addslashes((int) $this->input->post('session_id'));
$filterColumns['session_id'] = $session_Id;
$data['selected_session'] = $session_Id;
}
if ($this->input->post('class_section_id')) {
$class_section_Id = addslashes((int) $this->input->post('class_section_id'));
$filterColumns['class_section_id'] = $class_section_Id;
$data['selected_classsecton'] = $class_section_Id;
}
$data['studentlist'] = getStudentBySessionId_ClassSectionId($filterColumns, $offset, $limit, $sort);
$this->load->view('student/student_list', $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();
}
public function insert_exam_marks($session_id = "", $class_section_id = "", $exam_period_id = "")
{
$data = array();
if ($this->input->post('exam_id')) {
$data['exam_id'] = addslashes($this->input->post('exam_id'));
} else {
$data['exam_id'] = addslashes($exam_period_id);
}
if ($this->input->post('session_id')) {
$data['session_id'] = addslashes($this->input->post('session_id'));
} else {
$data['session_id'] = addslashes($session_id);
}
if ($this->input->post('class_section_id')) {
$data['class_section_id'] = addslashes($this->input->post('class_section_id'));
} else {
$data['class_section_id'] = addslashes($class_section_id);
}
if ($data['class_section_id'] != -1 && $data['session_id'] != -1) {
$filterColumns['class_section_id'] = $data['class_section_id'];
$filterColumns['session_id'] = $data['session_id'];
$data['studentlist'] = getStudentBySessionId_ClassSectionId($filterColumns, $offset = NULL, $limit = NULL, $sort = NULL);
}
$this->template->getScript();
$this->template->getAdminHeader();
$this->template->getAdminLeftBar();
$data['exam'] = retrieve_records($filterColumns = NULL, $offset = NULL, $limit = NULL, $sort = NULL, "ems_exam");
$data['session'] = retrieve_records($filterColumns = NULL, $offset = NULL, $limit = NULL, $sort = NULL, "ems_session");
$data['class_section'] = $this->classSection->getClass_section();
$data['exam_id'] = $data['exam_id'];
$data['session_id'] = $data['session_id'];
$data['class_section_id'] = $data['class_section_id'];
$this->load->view('exam/student_list_for_marks', $data);
$this->template->getFooter();
}
