|
Server IP : 192.185.129.71 / Your IP : 3.135.213.128 Web Server : Apache System : Linux bh-ht-3.webhostbox.net 4.19.286-203.ELK.el7.x86_64 #1 SMP Wed Jun 14 04:33:55 CDT 2023 x86_64 User : svymadmin ( 4072) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0755) : /home4/svymadmin/public_html/vivekaexcel.edu.in/bkp/school/application/controllers/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
if (!defined('BASEPATH'))
exit('No direct script access allowed');
class Mobile extends CI_Controller
{
function __construct()
{
parent::__construct();
$this->load->database();
//Authenticate data manipulation with the user level security key
if ($this->validate_auth_key() != 'success')
die;
}
// response of class list
function get_class()
{
$response = array();
$classes = $this->db->get('class')->result_array();
foreach ($classes as $row) {
$data['class_id'] = $row['class_id'];
$data['name'] = $row['name'];
$data['name_numeric'] = $row['name_numeric'];
$data['teacher_id'] = $row['teacher_id'];
$sections = $this->db->get_where('section', array(
'class_id' => $row['class_id']
))->result_array();
$data['sections'] = $sections;
array_push($response, $data);
}
//$response=["called"];
echo json_encode($response);
}
// returns image of user, returns blank image if not found.
function get_image_url($type = '', $id = '')
{
$type = $this->input->post('user_type');
$id = $this->input->post('user_id');
$response = array();
if (file_exists('uploads/' . $type . '_image/' . $id . '.jpg'))
$response['image_url'] = base_url() . 'uploads/' . $type . '_image/' . $id . '.jpg';
else
$response['image_url'] = base_url() . 'uploads/user.jpg';
echo json_encode($response);
}
// returns system name and logo as public call
function get_system_info()
{
$response['system_name'] = $this->db->get_where('settings', array(
'type' => 'system_name'
))->row()->description;
echo json_encode($response);
}
// returns the students of a specific class according to requested class_id
// ** class_id, year required to get students from enroll table
function get_students_of_class()
{
$response = array();
$class_id = $this->input->post('class_id');
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$students = $this->db->get_where('enroll', array(
'class_id' => $class_id,
'year' => $running_year
))->result_array();
foreach ($students as $row) {
$data['student_id'] = $row['student_id'];
$data['roll'] = $row['roll'];
$data['name'] = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->name;
$data['birthday'] = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->birthday;
$data['gender'] = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->sex;
$data['address'] = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->address;
$data['phone'] = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->phone;
$data['email'] = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->email;
$data['class'] = $this->db->get_where('class', array(
'class_id' => $row['class_id']
))->row()->name;
$data['section'] = $this->db->get_where('section', array(
'section_id' => $row['section_id']
))->row()->name;
$parent_id = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->parent_id;
$data['parent_name'] = $this->db->get_where('parent', array(
'parent_id' => $parent_id
))->row()->name;
$data['image_url'] = $this->crud_model->get_image_url('student', $row['student_id']);
array_push($response, $data);
}
echo json_encode($response);
}
// get students basic info
function get_student_profile_information()
{
$response = array();
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$student_id = $this->input->post('student_id');
$roll = $this->db->get_where('enroll', array(
'student_id' => $student_id,
'year' => $running_year
))->row()->roll;
$class_id = $this->db->get_where('enroll', array(
'student_id' => $student_id,
'year' => $running_year
))->row()->class_id;
$section_id = $this->db->get_where('enroll', array(
'student_id' => $student_id,
'year' => $running_year
))->row()->section_id;
$student_profile = $this->db->get_where('student', array(
'student_id' => $student_id
))->result_array();
foreach ($student_profile as $row) {
$data['student_id'] = $row['student_id'];
$data['name'] = $row['name'];
$data['birthday'] = $row['birthday'];
$data['gender'] = $row['sex'];
$data['address'] = $row['address'];
$data['phone'] = $row['phone'];
$data['email'] = $row['email'];
$data['roll'] = $roll;
$data['class'] = $class_id;
$data['section'] = $section_id;
$parent = $this->db->get_where('parent', array(
'parent_id' => $row['parent_id']
))->result_array();
if($parent != NULL){
foreach($parent as $row1){
$data['father_name'] = $row['name'];
$data['mother_name'] = $row['motherName'];
}
}else{
$data['father_name'] = "No father Name";
$data['mother_name'] = "No mother Name";
}
$data['image_url'] = $this->crud_model->get_image_url('student', $row['student_id']);
array_push($response, $data);
}
echo json_encode($response);
}
// get student's mark info
// ** exam_id, student_id, year required to get students from mark table
function get_student_mark_information()
{
$response = array();
$mark_array = array();
$exam_id = $this->input->post('exam_id');
$student_id = $this->input->post('student_id');
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$student_marks = $this->db->get_where('mark', array(
'exam_id' => $exam_id,
'student_id' => $student_id,
'year' => $running_year
))->result_array();
$response['exam_id'] = $exam_id;
foreach ($student_marks as $row) {
$data['mark_obtained'] = $row['mark_obtained'];
$data['subject'] = $this->db->get_where('subject', array(
'subject_id' => $row['subject_id'],
'year' => $running_year
))->row()->name;
$grade = $this->crud_model->get_grade($row['mark_obtained']);
$data['grade'] = $grade['name'];
array_push($mark_array, $data);
}
$response['marks'] = $mark_array;
echo json_encode($response);
}
// teacher list of the school
function get_teachers()
{
$response = array();
$teachers = $this->db->get('teacher')->result_array();
foreach ($teachers as $row) {
$data['teacher_id'] = $row['teacher_id'];
$data['name'] = $row['name'];
$data['birthday'] = $row['birthday'];
$data['gender'] = $row['sex'];
$data['address'] = $row['address'];
$data['phone'] = $row['phone'];
$data['email'] = $row['email'];
$data['image_url'] = $this->crud_model->get_image_url('teacher', $row['teacher_id']);
array_push($response, $data);
}
echo json_encode($response);
}
// teacher profile information
function get_teacher_profile()
{
$response = array();
$teacher_id = $this->input->post('teacher_id');
$teacher = $this->db->get_where('teacher', array(
'teacher_id' => $teacher_id
))->result_array();
foreach ($teacher as $row) {
$data['teacher_id'] = $row['teacher_id'];
$data['name'] = $row['name'];
$data['birthday'] = $row['birthday'];
$data['gender'] = $row['sex'];
$data['religion'] = $row['religion'];
$data['blood_group'] = $row['blood_group'];
$data['address'] = $row['address'];
$data['password'] = $row['password'];
$data['phone'] = $row['phone'];
$data['email'] = $row['email'];
$data['authentication_key'] = $row['authentication_key'];
$data['designation'] = $row['designation'];
$data['social_links'] = $row['social_links'];
$data['show_on_website'] = $row['show_on_website'];
$data['teacher_code'] = $row['teacher_code'];
$data['shortcut_name'] = $row['shortcut_name'];
$data['roll'] = $roll;
$data['class'] = $class_id;
$data['section'] = $section_id;
$parent = $this->db->get_where('parent', array(
'parent_id' => $row['parent_id']
))->result_array();
if($parent != NULL){
foreach($parent as $row1){
$data['father_name'] = $row['name'];
$data['mother_name'] = $row['motherName'];
}
}else{
$data['father_name'] = "No father Name";
$data['mother_name'] = "No mother Name";
}
$data['image_url'] = $this->crud_model->get_image_url('teacher', $row['student_id']);
array_push($response, $data);
}
echo json_encode($response);
}
// get parent list
function get_parents()
{
$response = array();
$parents = $this->db->get('parent')->result_array();
foreach ($parents as $row) {
$data['parent_id'] = $row['parent_id'];
$data['name'] = $row['name'];
$data['profession'] = $row['profession'];
$data['address'] = $row['address'];
$data['phone'] = $row['phone'];
$data['email'] = $row['email'];
$data['image_url'] = $this->crud_model->get_image_url('parent', $row['parent_id']);
array_push($response, $data);
}
echo json_encode($response);
}
// get single parent profile
function get_parent_profile()
{
$response = array();
$parent_id = $this->input->post('parent_id');
$response = $this->db->get_where('parent', array(
'parent_id' => $parent_id
))->row();
echo json_encode($response);
}
// income or expense history of school of submitted month
function get_accounting()
{
$response = array();
$month = $this->input->post('month');
$year = $this->input->post('year');
$type = $this->input->post('type');
$start_timestamp = strtotime("1-" . $month . "-" . $year);
$end_timestamp = strtotime("30-" . $month . "-" . $year);
$this->db->where("timestamp >=", $start_timestamp);
$this->db->where("timestamp <=", $end_timestamp);
$this->db->where("payment_type", $type);
$response = $this->db->get('payment')->result_array();
echo json_encode($response);
}
// attendance data response
// ** timestamp, year, class_id, section_id, student_id to get attendance from attendance table
function get_attendance_class()
{
$response = array();
$response = $this->db->get('class')->result_array();
echo json_encode($response);
}
function get_attendance_section()
{
$response = array();
$class_id = $this->input->post('class_id');
$response = $this->db->get_where('section',array('class_id' => $class_id))->result_array();
echo json_encode($response);
}
function get_student_attendance_list()
{
$response = array();
$class_id = $this->input->post('class_id');
$year = $this->input->post('year');
$timestamp = date("Y-m-d",strtotime($this->input->post('timestamp')));
$section_id = $this->input->post('section_id');
$teacher_id = $this->input->post('teacher_id');
$session = $this->input->post('session');
$query = $this->db->get_where('attendance' ,array(
'class_id'=>$class_id,
'section_id'=>$section_id,
'year'=>$year,
'timestamp'=>$timestamp
));
if($query->num_rows() < 1) {
$students = $this->db->get_where('enroll' , array(
'class_id' => $class_id , 'section_id' => $section_id , 'year' => $year
))->result_array();
foreach($students as $row) {
$attn_data['class_id'] = $class_id;
$attn_data['year'] = $year;
$attn_data['timestamp'] = $timestamp;
$attn_data['section_id'] = $section_id;
$attn_data['student_id'] = $row['student_id'];
$attn_data['teacher_id'] = $teacher_id;
$this->db->insert('attendance' , $attn_data);
}
}
$attendance_list = $this->db->get_where('attendance' ,array(
'class_id'=>$class_id,
'section_id'=>$section_id,
'year'=>$year,
'timestamp'=>$timestamp
))->result_array();
foreach ($attendance_list as $row) {
$data['student_id'] = $row['student_id'];
$data['name'] = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->name;
$data['attendance_id'] = $row['attendance_id'];
if($session == '1'){
if($row['status'] !=''){
$data['status'] = $row['status'];
}else{
$data['status'] = '0';
}
}
if($session == '2'){
$data['status'] = $row['status1'];
}
// $data['session'] = $session;
array_push($response, $data);
}
echo json_encode($response);
}
function set_attendance()
{
$response = array();
$total_student = $this->input->post('total_student');
$teacher_id = $this->input->post('teacher_id');
$session = $this->input->post('session');
$running_year = $this->db->get_where('settings' , array('type' => 'running_year'))->row()->description;
$active_sms_service = $this->db->get_where('settings' , array('type' => 'active_sms_service'))->row()->description;
for($i=0;$i<count($total_student);$i++)
{
$attendance_status = $this->input->post('status')[$i];
$attendance_id = $this->input->post('attendance_id')[$i];
if($session == 1){
$this->db->update('attendance' , array('status' => $attendance_status ,'attendance_id' => $attendance_id, 'teacher_id'=> $this->session->userdata('teacher_id') ));
}else{
$this->db->update('attendance' , array('status1' => $attendance_status,'attendance_id' => $attendance_id, 'e_teacher_id'=> $this->session->userdata('teacher_id') ));
}
if ($attendance_status == 2) {
if ($active_sms_service != '' || $active_sms_service != 'disabled') {
$student_name = $this->db->get_where('student' , array('student_id' => $this->input->post('student_id')[$i]))->row()->name;
$parent_id = $this->db->get_where('student' , array('student_id' => $this->input->post('student_id')[$i]))->row()->parent_id;
$message = 'Your child' . ' ' . $student_name . 'is absent today.';
if($parent_id != null && $parent_id != 0){
$receiver_phone = $this->db->get_where('parent' , array('parent_id' => $parent_id))->row()->phone;
if($receiver_phone != '' || $receiver_phone != null){
$this->sms_model->send_sms($message,$receiver_phone);
}
}
}
}
}
$data = 'success';
array_push($response, $data);
echo json_encode($response);
}
function get_attendance()
{
$response = array();
$date = $this->input->post('date');
$month = $this->input->post('month');
$year = $this->input->post('year');
$class_id = $this->input->post('class_id');
$section_id = $this->input->post('section_id');
$timestamp = strtotime($date . '-' . $month . '-' . $year);
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$students = $this->db->get_where('enroll', array(
'class_id' => $class_id, 'section_id' => $section_id,
'year' => $running_year
))->result_array();
foreach ($students as $row) {
$data['student_id'] = $row['student_id'];
$data['roll'] = $row['roll'];
$data['name'] = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->name;
$attendance_query = $this->db->get_where('attendance', array(
'timestamp' => $timestamp,
'student_id' => $row['student_id']
));
if ($attendance_query->num_rows() > 0) {
$attendance_result_row = $attendance_query->row();
$data['morning'] = $attendance_result_row->status;
$data['afternoon'] = $attendance_result_row->status1;
} else {
$data['morning'] = '0';
$data['afternoon'] = '0';
}
array_push($response, $data);
}
echo json_encode($response);
}
// function get_attendance()
// {
// $response = array();
// $date = $this->input->post('date');
// $month = $this->input->post('month');
// $year = $this->input->post('year');
// $class_id = $this->input->post('class_id');
// $section_id = $this->input->post('section_id');
// $timestamp = strtotime($date . '-' . $month . '-' . $year);
// $running_year = $this->db->get_where('settings', array(
// 'type' => 'running_year'
// ))->row()->description;
// $students = $this->db->get_where('enroll', array(
// 'class_id' => $class_id, 'section_id' => $section_id,
// 'year' => $running_year
// ))->result_array();
// foreach ($students as $row) {
// $data['student_id'] = $row['student_id'];
// $data['roll'] = $row['roll'];
// $data['name'] = $this->db->get_where('student', array(
// 'student_id' => $row['student_id']
// ))->row()->name;
// $attendance_query = $this->db->get_where('attendance', array(
// 'timestamp' => $timestamp,
// 'student_id' => $row['student_id']
// ));
// if ($attendance_query->num_rows() > 0) {
// $attendance_result_row = $attendance_query->row();
// $data['status'] = $attendance_result_row->status;
// $data['status1'] = $attendance_result_row->status1;
// } else {
// $data['status'] = '0';
// $data['status1'] = '0';
// }
// array_push($response, $data);
// }
// echo json_encode($response);
// }
// class routine : class and weekly day wise
// ** class_id, section_id, subject_id, year to get section wise class routine from class_routine table
function get_class_routine()
{
$response = array();
$class_id = $this->input->post('class_id');
$section_id = $this->input->post('section_id');
$day = $this->input->post('day');
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$class_routines = $this->db->get_where('class_routine', array(
'class_id' => $class_id,
'section_id' => $section_id,
'day' => $day,
'year' => $running_year
))->result_array();
foreach ($class_routines as $row) {
$subject = $this->db->get_where('subject', array(
'subject_id' => $row['subject_id'],
'year' => $running_year
))->row();
if(!empty($subject->name)){
$teacher_id = $this->db->get_where('subject',array('subject_id'=>$row['subject_id']))->row();
if(!empty($teacher_id->teacher_id)){
$teacher_name = $this->db->get_where('teacher',array('teacher_id'=>$teacher_id->teacher_id))->row();
}
if(!empty($teacher_name->name)){
$data['teacher_name'] = $teacher_name->name;
$data['subject'] = $subject->name;
}
}else{
$data['teacher_name'] = "No teacher";
$data['subject'] = "No subject";
}
$data['class_id'] = $row['class_id'];
$data['subject'] = $this->db->get_where('subject', array(
'subject_id' => $row['subject_id'],
'year' => $running_year
))->row()->name;
$data['time_start'] = date('h:i',strtotime($row['time_start']));
$data['time_end'] = date('h:i',strtotime($row['time_end']));
$data['time_start_min'] = $row['time_start_min'];
$data['time_end_min'] = $row['time_end_min'];
$data['day'] = $row['day'];
array_push($response, $data);
}
echo json_encode($response);
}
// get subject name of subject_id
function get_subject_name()
{
$response = array();
$subject_id = $this->input->post('subject_id');
$response = $this->db->get_where('subject', array(
'subject_id' => $subject_id
))->row();
echo json_encode($response);
}
// event calendar or noticeboard event list
function get_event_calendar()
{
$response = array();
$response = $this->db->get('noticeboard')->result_array();
echo json_encode($response);
}
// exam list
// ** year required to get exam list from exam table
function get_exam_list()
{
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$response = array();
$response = $this->db->get_where('exam', array(
'year' => $running_year
))->result_array();
echo json_encode($response);
}
// get subjects of a class
// ** class_id, year required to get subjects of a class from subject table
function get_subject_of_class()
{
$response = array();
$class_id = $this->input->post('class_id');
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$subjects = $this->db->get_where('subject', array(
'class_id' => $class_id,
'year' => $running_year
))->result_array();
foreach ($subjects as $row) {
$data['subject_id'] = $row['subject_id'];
$data['name'] = $row['name'];
$teacher_query = $this->db->get_where('teacher', array(
'teacher_id' => $row['teacher_id']
));
if ($teacher_query->num_rows() > 0) {
$teacher_query_row = $teacher_query->row();
$data['teacher_name'] = $teacher_query_row->name;
} else {
$data['teacher_name'] = '';
}
array_push($response, $data);
}
echo json_encode($response);
}
// student mark list, subject, class, exam wise
// ** exam_id, class_id, subject_id, year required to get student wise marks
function get_marks()
{
$response = array();
$exam_id = $this->input->post('exam_id');
$class_id = $this->input->post('class_id');
$subject_id = $this->input->post('subject_id');
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$marks = $this->db->get_where('mark', array(
'exam_id' => $exam_id,
'class_id' => $class_id,
'subject_id' => $subject_id,
'year' => $running_year
))->result_array();
foreach ($marks as $row) {
$data['class_id'] = $row['class_id'];
$data['student_id'] = $row['student_id'];
$data['student_name'] = $this->db->get_where('student', array(
'student_id' => $row['student_id']
))->row()->name;
$data['student_roll'] = $this->db->get_where('enroll', array(
'student_id' => $row['student_id'],
'year' => $running_year
))->row()->roll;
$data['exam_id'] = $row['exam_id'];
$data['mark_obtained'] = $row['mark_obtained'];
array_push($response, $data);
}
echo json_encode($response);
}
//student study material class,section,subject
//**class_id, section_id,subject_id required to get study material
function get_study_material()
{
$response = array();
$class_id = $this->input->post('class_id');
$subject_id = $this->input->post('subject_id');
$study_material = $this->db->order_by("timestamp","DESC")->get_where("document",array(
"class_id"=>$class_id,"subject_id"=>$subject_id))->result_array();
foreach($study_material as $row){
$data["document_id"] = $row['document_id'];
$data["title"] = $row['title'];
$data["description"] = $row['description'];
$data["class_id"] = $row['class_id'];
$data["subject_id"] = $row['subject_id'];
array_push($response, $data);
}
echo json_encode($response);
}
//student study material View class,section,subject
//**document_id required to get study material view document
function get_study_material_document(){
$response = array();
$document_id = $this->input->post('document_id');
$sm_document = $this->db->get_where("document",array(
'document_id' => $document_id))->result_array();
foreach($sm_document as $row){
if(file_exists('uploads/document/'.$row['file_name'])){
$data['image_url'] = base_url('uploads/document/'.$row['file_name']);
}else{
$data['image_url'] = "No data";
}
array_push($response, $data);
}
echo json_encode($response);
}
function get_loggedin_user_profile()
{
$response = array();
$login_type = $this->input->post('login_type');
$login_user_id = $this->input->post('login_user_id');
$user_profile = $this->db->get_where($login_type, array(
$login_type . '_id' => $login_user_id
))->result_array();
foreach ($user_profile as $row) {
$data['name'] = $row['name'];
$data['email'] = $row['email'];
$data['image_url'] = $this->crud_model->get_image_url($login_type, $login_user_id);
break;
}
array_push($response, $data);
echo json_encode($response);
}
function update_user_image()
{
$response = array();
$user_type = $this->input->post('login_type');
$user_id = $this->input->post('login_user_id');
$directory = 'uploads/' . $user_type . '_image/' . $user_id . '.jpg';
move_uploaded_file($_FILES['user_image']['tmp_name'], $directory);
$response = array(
'update_status' => 'success'
);
echo json_encode($response);
}
function update_user_info()
{
$response = array();
$user_type = $this->input->post('login_type');
$user_id = $this->input->post('login_user_id');
$data['name'] = $this->input->post('name');
$data['email'] = $this->input->post('email');
$this->db->where($user_type . '_id', $user_id);
$this->db->update($user_type, $data);
$response = array(
'update_status' => 'success'
);
echo json_encode($response);
}
function update_user_password()
{
$response = array();
$user_type = $this->input->post('login_type');
$user_id = $this->input->post('login_user_id');
$old_password = sha1($this->input->post('old_password'));
$data['password'] = sha1($this->input->post('new_password'));
// verify if old password matches
$this->db->where($user_type . '_id', $user_id);
$this->db->where('password', $old_password);
$verify_query = $this->db->get($user_type);
if ($verify_query->num_rows() > 0) {
$this->db->where($user_type . '_id', $user_id);
$this->db->update($user_type, $data);
$response = array(
'update_status' => 'success'
);
} else {
$response = array(
'update_status' => 'failed'
);
}
echo json_encode($response);
}
// total number of students
// ** year required to get total student from enrollment table
// ** timestamp, status required to get todays present students from student table
function get_total_summary()
{
$response = array();
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$this->db->where('year', $running_year);
$this->db->from('enroll');
$response['total_student'] = $this->db->count_all_results();
$response['total_teacher'] = $this->db->count_all('teacher');
$response['total_parent'] = $this->db->count_all('parent');
// student present today
$check = array(
'timestamp' => strtotime(date('d-m-Y')),
'status' => '1'
);
$query = $this->db->get_where('attendance', $check);
$present_today = $query->num_rows();
$response['total_present_today'] = $present_today;
echo json_encode($response);
}
// dummy function
function getdata()
{
$response = array();
$postvar = $this->input->post('postvar');
$response = $this->db->get_where('table', array(
'postvar' => $postvar
))->result_array();
echo json_encode($response);
}
// Parents functions : own child list, class routine, exam marks of child, invoice of child, event schedule
function get_children_of_parent()
{
$response = array();
$parent_id = $this->input->post('parent_id');
$response['children'] = $this->db->get_where('student', array(
'parent_id' => $parent_id
))->result_array();
echo json_encode($response);
}
function get_child_class_routine()
{
}
function get_child_exam_marks()
{
}
function get_child_accounting()
{
}
// Students functions : own child list, class routine, exam marks of child, invoice of child, event schedule
function get_own_subjects()
{
}
function get_own_class_routine()
{
}
function get_own_marks()
{
}
function get_single_student_accounting()
{
$response = array();
$student_id = $this->input->post("student_id");
$this->db->where("student_id", $student_id);
$response = $this->db->get('invoice')->result_array();
echo json_encode($response);
}
// user login matching with db
function login()
{
$response = array();
$email = $this->input->post("email");
$password = sha1($this->input->post("password"));
// Checking login credential for admin
$query = $this->db->get_where('admin', array(
'email' => $email,
'password' => $password
));
if ($query->num_rows() > 0) {
$row = $query->row();
$authentication_key = md5(rand(10000, 1000000));
$response['status'] = 'success';
$response['login_type'] = 'admin';
$response['login_user_id'] = $row->admin_id;
$response['name'] = $row->name;
$response['year'] = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$response['authentication_key'] = $authentication_key;
// update the new authentication key into user table
$this->db->where('admin_id', $row->admin_id);
$this->db->update('admin', array(
'authentication_key' => $authentication_key
));
echo json_encode($response);
return;
}
// Checking login credential for teacher
$query = $this->db->get_where('teacher', array(
'email' => $email,
'password' => $password
));
if ($query->num_rows() > 0) {
$row = $query->row();
$authentication_key = md5(rand(10000, 1000000));
$response['status'] = 'success';
$response['login_type'] = 'teacher';
$response['login_user_id'] = $row->teacher_id;
$response['name'] = $row->name;
$response['year'] = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$response['authentication_key'] = $authentication_key;
// update the new authentication key into user table
$this->db->where('teacher_id', $row->teacher_id);
$this->db->update('teacher', array(
'authentication_key' => $authentication_key
));
echo json_encode($response);
return;
}
// Checking login credential for student
$query = $this->db->get_where('student', array(
'email' => $email,
'password' => $password
));
if ($query->num_rows() > 0) {
$running_year = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
$row = $query->row();
$authentication_key = md5(rand(10000, 1000000));
$response['status'] = 'success';
$response['login_type'] = 'student';
$response['login_user_id'] = $row->student_id;
$response['name'] = $row->name;
$response['authentication_key'] = $authentication_key;
$response['class_id'] = $this->db->get_where('enroll', array(
'student_id' => $row->student_id,
'year' => $running_year
))->row()->class_id;
$response['section_id'] = $this->db->get_where('enroll', array(
'student_id' => $row->student_id,
'year' => $running_year
))->row()->section_id;
$response['year'] = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
// update the new authentication key into user table
$this->db->where('student_id', $row->student_id);
$this->db->update('student', array(
'authentication_key' => $authentication_key
));
echo json_encode($response);
return;
}
// Checking login credential for parent
$query = $this->db->get_where('parent', array(
'email' => $email,
'password' => $password
));
if ($query->num_rows() > 0) {
$row = $query->row();
$authentication_key = md5(rand(10000, 1000000));
$response['status'] = 'success';
$response['login_type'] = 'parent';
$response['login_user_id'] = $row->parent_id;
$response['name'] = $row->name;
$response['authentication_key'] = $authentication_key;
$response['children'] = $this->db->get_where('student', array(
'parent_id' => $row->parent_id
))->result_array();
$response['year'] = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
// update the new authentication key into user table
$this->db->where('parent_id', $row->parent_id);
$this->db->update('parent', array(
'authentication_key' => $authentication_key
));
echo json_encode($response);
return;
}
// Checking login credential for transport
$query = $this->db->get_where('transference', array(
'email' => $email,
'password' => $password
));
if ($query->num_rows() > 0) {
$row = $query->row();
$authentication_key = md5(rand(10000, 1000000));
$response['status'] = 'success';
$response['login_type'] = 'transport';
$response['login_user_id'] = $row->transference_id;
$response['name'] = $row->name;
$response['authentication_key'] = $authentication_key;
$response['year'] = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
// update the new authentication key into user table
$this->db->where('transference_id', $row->transference_id);
$this->db->update('transference', array(
'authentication_key' => $authentication_key
));
echo json_encode($response);
return;
}
// Checking login credential for librarian
$query = $this->db->get_where('librarian', array(
'email' => $email,
'password' => $password
));
if ($query->num_rows() > 0) {
$row = $query->row();
$authentication_key = md5(rand(10000, 1000000));
$response['status'] = 'success';
$response['login_type'] = 'librarian';
$response['login_user_id'] = $row->librarian_id;
$response['name'] = $row->name;
$response['authentication_key'] = $authentication_key;
$response['year'] = $this->db->get_where('settings', array(
'type' => 'running_year'
))->row()->description;
// update the new authentication key into user table
$this->db->where('librarian_id', $row->librarian_id);
$this->db->update('librarian', array(
'authentication_key' => $authentication_key
));
echo json_encode($response);
return;
}else {
$response['status'] = 'failed';
}
echo json_encode($response);
}
// forgot password link
function reset_password()
{
$response = array();
$response['status'] = 'false';
$email = $_POST["email"];
$reset_account_type = '';
//resetting user password here
$new_password = substr(rand(100000000, 20000000000), 0, 7);
// Checking credential for admin
$query = $this->db->get_where('admin', array(
'email' => $email
));
if ($query->num_rows() > 0) {
$reset_account_type = 'admin';
$this->db->where('email', $email);
$this->db->update('admin', array(
'password' => sha1($new_password)
));
$response['status'] = 'true';
}
// Checking credential for student
$query = $this->db->get_where('student', array(
'email' => $email
));
if ($query->num_rows() > 0) {
$reset_account_type = 'student';
$this->db->where('email', $email);
$this->db->update('student', array(
'password' => sha1($new_password)
));
$response['status'] = 'true';
}
// Checking credential for teacher
$query = $this->db->get_where('teacher', array(
'email' => $email
));
if ($query->num_rows() > 0) {
$reset_account_type = 'teacher';
$this->db->where('email', $email);
$this->db->update('teacher', array(
'password' => sha1($new_password)
));
$response['status'] = 'true';
}
// Checking credential for parent
$query = $this->db->get_where('parent', array(
'email' => $email
));
if ($query->num_rows() > 0) {
$reset_account_type = 'parent';
$this->db->where('email', $email);
$this->db->update('parent', array(
'password' => sha1($new_password)
));
$response['status'] = 'true';
}
// Checking credential for transport
$query = $this->db->get_where('transference', array(
'email' => $email
));
if ($query->num_rows() > 0) {
$reset_account_type = 'transference';
$this->db->where('email', $email);
$this->db->update('transference', array(
'password' => sha1($new_password)
));
$response['status'] = 'true';
}
// Checking credential for librarian
$query = $this->db->get_where('librarian', array(
'email' => $email
));
if ($query->num_rows() > 0) {
$reset_account_type = 'librarian';
$this->db->where('email', $email);
$this->db->update('librarian', array(
'password' => sha1($new_password)
));
$response['status'] = 'true';
}
// send new password to user email
$this->email_model->password_reset_email($new_password, $reset_account_type, $email);
echo json_encode($response);
}
function get_notices()
{
$response = array();
$query = $this->db->get("noticeboard")->result_array();
foreach ($query as $row) {
$data['notice_id'] = $row['notice_id'];
$data['notice_title'] = $row['notice_title'];
$data['notice'] = $row['notice'];
$data['date'] = date('d-M-Y', $row['create_timestamp']);
array_push($response, $data);
}
echo json_encode($response);
}
// private messaging
// @ $user -> user_type-user_id -> admin-1
function get_message_threads() {
$response = array();
$user = $this->input->post('user');
$this->db->where('sender', $user);
$this->db->or_where('reciever', $user);
$threads = $this->db->get('message_thread')->result_array();
foreach ($threads as $row) {
$sender = explode('-', $row['sender']);
$receiver = explode('-', $row['reciever']);
$sender_name = $this->db->get_where($sender[0], array($sender[0].'_id' => $sender[1]))->row()->name;
$receiver_name = $this->db->get_where($receiver[0], array($receiver[0].'_id' => $receiver[1]))->row()->name;
$user_type = ($user == $row['sender']) ? $receiver[0] : $sender[0];
$user_name = ($user == $row['sender']) ? $receiver_name : $sender_name;
$user_id = ($user == $row['sender']) ? $receiver[1] : $sender[1];
if (file_exists('uploads/'.$user_type.'_image/'.$user_id.'.jpg'))
$image_url = base_url('uploads/'.$user_type.'_image/'.$user_id.'.jpg');
else
$image_url = base_url('uploads/user.jpg');
$data['message_thread_code'] = $row['message_thread_code'];
$data['user_type'] = $user_type;
$data['user_name'] = $user_name;
$data['image_url'] = $image_url;
array_push($response, $data);
}
echo json_encode($response);
}
function get_messages() {
$response = array();
$message_thread_code = $this->input->post('message_thread_code');
$this->db->where('message_thread_code', $message_thread_code);
$this->db->order_by('timestamp', 'asc');
$messages = $this->db->get('message')->result_array();
foreach ($messages as $row) {
$sender = explode('-', $row['sender']);
$sender_name = $this->db->get_where($sender[0], array($sender[0].'_id' => $sender[1]))->row()->name;
$data['sender'] = $row['sender'];
$data['sender_type'] = $sender[0];
$data['sender_id'] = $sender[1];
$data['sender_name'] = $sender_name;
$data['message'] = $row['message'];
$data['date'] = date('d M, Y', $row['timestamp']);
array_push($response, $data);
}
echo json_encode($response);
}
function get_receivers() {
$student_array = array();
$teacher_array = array();
$parent_array = array();
$admin_array = array();
$response = array();
$for_user = $this->input->post('for_user');
$for_user = explode('-', $for_user);
$type = $for_user[0];
// students
$this->db->order_by('name', 'asc');
$students = $this->db->get('student')->result_array();
foreach ($students as $row) {
$data['id'] = $row['student_id'];
$data['type'] = 'student';
$data['name'] = $row['name'];
array_push($student_array, $data);
}
// teachers
$this->db->order_by('name', 'asc');
$teachers = $this->db->get('teacher')->result_array();
foreach ($teachers as $row) {
$data['id'] = $row['teacher_id'];
$data['type'] = 'teacher';
$data['name'] = $row['name'];
array_push($teacher_array, $data);
}
// parents
$this->db->order_by('name', 'asc');
$parents = $this->db->get('parent')->result_array();
foreach ($parents as $row) {
$data['id'] = $row['parent_id'];
$data['type'] = 'parent';
$data['name'] = $row['name'];
array_push($parent_array, $data);
}
// admins
$this->db->order_by('name', 'asc');
$admins = $this->db->get('admin')->result_array();
foreach ($admins as $row) {
$data['id'] = $row['admin_id'];
$data['type'] = 'admin';
$data['name'] = $row['name'];
array_push($admin_array, $data);
}
if ($type == 'admin') {
$response = array_merge($teacher_array, $parent_array, $student_array);
echo json_encode($response);
} else if ($type == 'teacher') {
$response = array_merge($admin_array, $parent_array, $student_array);
echo json_encode($response);
} else if ($type == 'student') {
$response = array_merge($admin_array, $teacher_array);
echo json_encode($response);
} else {
$response = array_merge($admin_array, $teacher_array);
echo json_encode($response);
}
}
function send_new_message() {
$response = array();
$message = $this->input->post('message');
$receiver = $this->input->post('receiver');
$sender = $this->input->post('sender');
$timestamp = strtotime(date("Y-m-d H:i:s"));
//check if the thread between those 2 users exists, if not create new thread
$num1 = $this->db->get_where('message_thread', array('sender' => $sender, 'reciever' => $receiver))->num_rows();
$num2 = $this->db->get_where('message_thread', array('sender' => $receiver, 'reciever' => $sender))->num_rows();
if ($num1 == 0 && $num2 == 0) {
$message_thread_code = substr(md5(rand(100000000, 20000000000)), 0, 15);
$data_message_thread['message_thread_code'] = $message_thread_code;
$data_message_thread['sender'] = $sender;
$data_message_thread['reciever'] = $receiver;
$this->db->insert('message_thread', $data_message_thread);
}
if ($num1 > 0)
$message_thread_code = $this->db->get_where('message_thread', array('sender' => $sender, 'reciever' => $receiver))->row()->message_thread_code;
if ($num2 > 0)
$message_thread_code = $this->db->get_where('message_thread', array('sender' => $receiver, 'reciever' => $sender))->row()->message_thread_code;
$data_message['message_thread_code'] = $message_thread_code;
$data_message['message'] = $message;
$data_message['sender'] = $sender;
$data_message['timestamp'] = $timestamp;
$this->db->insert('message', $data_message);
$data['message_thread_code'] = $message_thread_code;
array_push($response, $data);
echo json_encode($response);
}
function send_reply() {
$message_thread_code = $this->input->post('message_thread_code');
$message = $this->input->post('message');
$timestamp = strtotime(date("Y-m-d H:i:s"));
$sender = $this->input->post('sender');
$data_message['message_thread_code'] = $message_thread_code;
$data_message['message'] = $message;
$data_message['sender'] = $sender;
$data_message['timestamp'] = $timestamp;
$this->db->insert('message', $data_message);
$data['message_thread_code'] = $message_thread_code;
echo 'success';
}
//=================================Library Issue and Return=========================================//
function library_user_details(){
$type_name = $this->input->post("type_name");
if($type_name == "student"){
$user_details= $this->db->get_where($type_name,array($type_name.'_code'=> $this->input->post("user_id")))->result_array();
}else{
$user_details= $this->db->get_where($type_name,array($type_name.'_id'=> $this->input->post("user_id")))->result_array();
}
$user_data['type_name'] = $this->input->post("type_name");
$user_data['type_name_id'] = $user_details[0][$type_name.'_id'];
$response = $user_data;
echo json_encode($response);
}
function issue_book()
{
$type_name = $this->input->post("type_name");
$type_name_id = $this->input->post("user_id");
$max_book = $this->db->get_where("library_settings",array("user_type" => $type_name))->row()->number_of_book;
$issued_books= count ( $this->db->get_where("library_register",array("user_type" => $type_name,"user_id" => $type_name_id , "status" => "issued"))->result_array());
if($issued_books < $max_book ){
$book = $this->db->query("SELECT * FROM `book` WHERE `book_id`= '".$this->input->post('book_id')."'")->result_array();
if($book[0]['remaining_book'] = "1"){
$data =array(
'user_id' => $type_name_id,
'user_type' => $type_name,
'book_id' =>$this->input->post("book_id"),
'status' => "issued",
'register_date' => date("Y-m-d")
);
$this->db->insert("library_register",$data);
$this->db->query("UPDATE `book` SET `book_issued`= book_issued + 1 , `remaining_book`=(total_copies-book_issued) WHERE book_id=".$this->input->post("book_id"));
$response = "success";
}else{
$response = "fail";
}
}else{
$response = "fail";
}
echo $response;
}
function book_return_fine()
{
$type_name = $this->input->post("type_name");
$type_name_id = $this->input->post("user_id");
$book_id = $this->input->post("book_id");
$setting=$this->db->get_where("library_settings",array("user_type" => $type_name))->result_array();
$book_issed=$this->db->get_where("library_register",array("user_type" => $type_name , "user_id" => $type_name_id,'status' => "issued"))->result_array();
if($setting != NULL && $book_issed !=NULL){
$max_day=$setting[0]['maximum_date'];
$cost=$setting[0]['per_day_cost'];
$temp=$book_issed[0]['register_date'];
$rem_date=strtotime($temp);
$per_day = time();
$day_diff = $per_day - $rem_date;
$numdays = floor($day_diff/(60*60*24));
// $data=array("return_date" => $day, 'status' =>"returned" );
$fine= $cost * ( $numdays - $max_day );
if($fine > "0"){
$response = $fine;
echo json_encode($response);
}else{
$response = "0";
echo json_encode($response);
}
}
}
function book_return()
{
$type_name = $this->input->post("type_name");
$type_name_id = $this->input->post("user_id");
$book_id = $this->input->post("book_id");
$fine_amount = $this->input->post('fine');
$day = date('Y-m-d');
$data=array("return_date" => $day, 'status' =>"returned" );
if($fine_amount > "0") {
$this->db->update("library_register",$data,array("user_type" => $type_name , "user_id" => $type_name_id,'status' =>"issued","book_id" => $book_id));
$this->db->query("UPDATE `book` SET `book_issued`= book_issued - 1 , `remaining_book`=(total_copies-book_issued) WHERE book_id=".$book_id);
$this->db->insert("due_amount",array("user_type" => $type_name , "user_id" => $type_name_id,'book_id' => $book_id , 'fine_amount' =>$fine_amount ,"fine_date" => $day));
$response = "success";
echo json_encode($response);
}else{
$this->db->update("library_register",$data,array("user_type" => $type_name , "user_id" => $type_name_id,'status' =>"issued","book_id" => $book_id));
$this->db->query("UPDATE `book` SET `book_issued`= book_issued - 1 , `remaining_book`=(total_copies-book_issued) WHERE book_id=".$book_id);
$response = "success";
echo json_encode($response);
}
}
//**************************************Transport Route************************************//
function transport_route()
{
$response = array();
$transports = $this->db->get_where("transport")->result_array();
if($transports != NULL)
{
$response = $transports;
echo json_encode($response);
echo "success";
}else{
echo "fail";
}
}
//************************************Transport Route Point************************************//
function transport_route_point()
{
$response = array();
$transports = $this->db->query("SELECT route_point.route_point_id, route_point.transport_id,route_point.`from_point_name`,route_point.`route_point_fare`,transport.route_name FROM `route_point` JOIN transport on route_point.transport_id = transport.transport_id WHERE route_point.from_point_name != ''")->result_array();
foreach($transports as $row){
if($row['from_point_name'] != NULL){
$data['route_point_id'] = $row['route_point_id'];
$data['transport_id'] = $row['transport_id'];
$data['route_point_fare'] = $row['route_point_fare'];
$data['from_point_name'] = $row['from_point_name'];
$data['route_name'] = $row['route_name'];
$transport = $this->db->get_where('transport', array(
'transport_id' => $row['transport_id']
))->result_array();
$data['transport'] = $transport;
array_push($response,$data);
}
}
echo "success";
echo json_encode($response);
}
//************************************Transport Route Point************************************//
function update_route_point()
{
$response = array();
if($this->input->post("route_point_id") != NULL)
{
$data['latitude'] = $this->input->post("latitude");
$data['longitude'] = $this->input->post("longitude");
}
}
// authentication_key validation
function validate_auth_key()
{
/*
* Ignore the authentication and returns success by default to constructor
* For pubic calls: login, forget password.
* Pass post parameter 'authenticate' = 'false' to ignore the user level authentication
*/
if ($this->input->post('authenticate') == 'false')
return 'success';
$response = array();
$authentication_key = $this->input->post("authentication_key");
$user_type = $this->input->post("user_type");
//echo $authentication_key;exit();
$query = $this->db->get_where($user_type, array(
'authentication_key' => $authentication_key
));
if ($query->num_rows() > 0) {
$row = $query->row();
$response['status'] = 'success';
$response['login_type'] = 'admin';
if ($user_type == 'admin')
$response['login_user_id'] = $row->admin_id;
if ($user_type == 'teacher')
$response['login_user_id'] = $row->teacher_id;
if ($user_type == 'student')
$response['login_user_id'] = $row->student_id;
if ($user_type == 'parent')
$response['login_user_id'] = $row->parent_id;
if ($user_type == 'transference')
$response['login_user_id'] = $row->transport_id;
if ($user_type == 'librarian')
$response['login_user_id'] = $row->librarian_id;
$response['authentication_key'] = $authentication_key;
} else {
$response['status'] = 'failed';
}
//return json_encode($response);
return $response['status'];
}
}