<?php
defined('BASEPATH') or exit('No direct script access allowed');

use Nilambar\NepaliDate\NepaliDate;

require_once 'vendor/autoload.php';

class Student_model extends CI_Model
{
    private $nepaliDateObject;
    private $nepali_current_date;

    public function __construct()
    {
        $this->load->database();
        $this->load->library('Ciqrcode');
        $this->load->helper('common_helper');
        date_default_timezone_set("Asia/Kolkata");

        $this->nepaliDateObject = new NepaliDate();
        $this->nepali_current_date = cuurentNepaliDate($this->nepaliDateObject);
    }

    public function login($uname, $pwd)
    {
        $pwd = md5($pwd);
        $sql = $this->db->query("SELECT * FROM students WHERE studentId='$uname' AND password='$pwd'");
        //	echo $this->db->last_query($sql); 
        if ($sql->num_rows() > 0) {

            if ($sql->row()->is_active == 'yes') {
                return $sql->row_object();
            } else {
                return false;
            }
        } else {
            return false;
        }
    }

    public function get_studentMenus()
    {
        $this->db->select('*');
        $this->db->from('student_menu');
        $this->db->where('is_active', 'yes');
        $this->db->order_by('id', 'ASC');
        $query = $this->db->get();
        return $query->result_array();
    }

    public function get_courses()
    {
        $this->db->select('*');
        $this->db->from('course');
        $this->db->where('is_active', 'yes');
        $this->db->order_by('course_name', 'ASC');
        $query = $this->db->get();
        return $query->result_array();
    }

    //shankar code 
    public function get_batch()
    {
        $this->db->select('*');
        $this->db->from('batch');
        $this->db->order_by('id', 'DESC');
        $query = $this->db->get();
        return $query->result_array();
    }
    //end shankar code

    public function add_applicationinfo($data)
    {
        $inf = $data['sinfo'];

        $photo = $data['photo'];
        $medical = $data['medical'];
        $school = $data['school'];
        $exam = $data['exam'];

        $this->db->select_max('id');
        $query  = $this->db->get('applications');
        $res = $query->row_array();

        $pid = $res['id'] + 1;

        // if (strlen($pid) == 1)
        //     $pid = "000" . $pid;
        // else if (strlen($pid) == 2)
        //     $pid = "00" . $pid;
        // else if (strlen($pid) == 3)
        //     $pid = "0" . $pid;
        $school_info = $this->get_logo_from_setting();
        $school_prefix = (!empty($school_info['school_prefix_id'])) ? $school_info['school_prefix_id'] : 'BB';
        $applicationid = $school_prefix . STUDENT_APPLICATION_PREFIX . date('Y', strtotime($this->nepali_current_date)) . '0' . $pid;

        $indata =  array(
            'name'   => $inf['sfname'] . ' ' . $inf['ssname'],
            'applicationid' => $applicationid,
            'email'  => $inf['semail'],
            'mobile' => $inf['scontact'],
            'password' => md5($inf['spaswd']),
            'gender' => $inf['sgender'],
            'dob' =>   $inf['sdob'],
            'course'   => $inf['scourse'],
            'batch_id' => $inf['sbatch'],
            'emergency_contact_name'  => $inf['lgfullname'],
            'emergency_contact_number' => $inf['lgcontact'],
            'emergency_contact_address' => $inf['lgaddress'],
            'birth_certificate'  => $inf['sbirth-certificate'],
            'caste' => $inf['scaste'],
            'religion' => $inf['sreligion'],
            'previous_school' => $inf['sprevious-school'],
            'father_name' => $inf['sfathername'],
            'father_citizenship' => $inf['fcitizenship-number'],
            'father_mobile' => $inf['fcontact'],
            'mother_name' => $inf['mfathername'],
            'mother_citizenship' => $inf['mcitizenship-number'],
            'mother_mobile' => $inf['mcontact'],
            'country' => $inf['scountry'],
            'state' => $inf['sprovince'],
            'address1' =>   $inf['saddress'],
            'address2' =>   '',
            'zipcode' =>   '',
            'school_certificate' => $school,
            'exam_result' => $exam,
            'photo' => $photo,
            'medical_cerificate' => $medical,
            'payment_method' => 'cash',
            'description' => '',
            'registered_on' => $this->nepali_current_date
        );

        $insert = $this->db->insert('applications', $indata);
        $newId =  $this->db->insert_id();
        $result = (!empty($newId)) ? $newId : 0;
        return $result;
    }


    public function storeTransaction($data)
    {
        $result = $this->db->insert('student_online_transactions', $data);
        return $result;
    }

    public function storefeeTransaction($data)
    {
        $result = $this->db->insert('student_fee_online_transactions', $data);
        return $result;
    }
    public function applications_get($data, $feestyId)
    {
        $courseId = (isset($data['course']) && !empty($data['course'])) ? $data['course'] : 0;
        $batchId = (isset($data['batch_id']) && !empty($data['batch_id'])) ? $data['batch_id'] : 0;
        $this->db->select('*');
        $this->db->from('course_fees');
        $this->db->where('course_id', $courseId);
        $this->db->where('batch_id', $batchId);
        $this->db->where('fees_type', $feestyId);
        $query = $this->db->get();
        return $query->row_array();
    }


    public function installment_get($course)
    {
        $this->db->select('*');
        $this->db->from('installment');
        $this->db->where('course_id', $course);
        $query = $this->db->get();
        //echo $this->db->last_query();
        return $query->result_array();
    }

    public function install_get($install_type_id)
    {
        $this->db->select('*');
        $this->db->from('installment');
        $this->db->where('id', $install_type_id);
        $query = $this->db->get();
        //echo $this->db->last_query();
        return $query->row_array();
    }

    public function updateapplication($data)
    {
        $update = array(
            'payment_status' => $data['payment_status'],
        );
        $this->db->where('id',  $data['product_id']);
        $update = $this->db->update('applications', $update);
        //	echo $this->db->last_query();
    }

    // Moving application info to students -start - by shivakumar
    public function applicationinfo_movingto_students($applicationId)
    {
        $this->db->select('*');
        $this->db->from('applications');
        $this->db->where('id', $applicationId);
        $query = $this->db->get();
        $res = $query->row_array();
        $appdata = (!empty($res)) ? $res : 0;
        if ($appdata != 0) {
            if ($appdata['status'] == 'moved') {
                return -1;
            } else {
                $this->db->select_max('id');
                $query  = $this->db->get('students');
                $resid = $query->row_array();
                $resid = (isset($resid['id']) && !empty($resid['id'])) ? $resid['id'] : 0;
                $studentMaxId = $resid + 1;


                // if (strlen($studentMaxId) == 1)
                //     $pid = "00000" . $studentMaxId;
                // else if (strlen($studentMaxId) == 2)
                //     $pid = "0000" . $studentMaxId;
                // else if (strlen($studentMaxId) == 3)
                //     $pid = "000" . $studentMaxId;
                // else if (strlen($studentMaxId) == 4)
                //     $pid = "00" . $studentMaxId;
                // else if (strlen($studentMaxId) == 5)
                //     $pid = "00" . $studentMaxId;
                $pid = date('Y', strtotime($this->nepali_current_date)) . '0' . $studentMaxId;
                $school_info = $this->get_logo_from_setting();
                $school_prefix = (!empty($school_info['school_prefix_id'])) ? $school_info['school_prefix_id'] : 'BB';

                $studentid = $school_prefix . STUDENT_PREFIX . $pid;
                $parent_id = $school_prefix . STUDENT_PARENT_PREFIX . $pid;

                $qr_path = $this->generate_qrcode($studentid);

                $insertdata = array(
                    'id' => $studentMaxId,
                    'name' => $appdata['name'],
                    'studentId' => $studentid,
                    'course' => $appdata['course'],
                    'batch_id' => $appdata['batch_id'],
                    'email' => $appdata['email'],
                    'password' => $appdata['password'],
                    'mobile' => $appdata['mobile'],
                    'gender' => $appdata['gender'],
                    'dob' => $appdata['dob'],
                    'emergency_contact_name' => $appdata['emergency_contact_name'],
                    'emergency_contact_number' => $appdata['emergency_contact_number'],
                    'country' => $appdata['country'],
                    'state' => $appdata['state'],
                    'address1' => $appdata['address1'],
                    'address2' => $appdata['address2'],
                    'zipcode' => $appdata['zipcode'],
                    'photo' => $appdata['photo'],
                    'school_certificate' => $appdata['school_certificate'],
                    'exam_result' => $appdata['exam_result'],
                    'medical_cerificate' => $appdata['medical_cerificate'],
                    'payment_status' => $appdata['payment_status'],
                    'registered_on' => date('Y-m-d H:i:s', strtotime($this->nepali_current_date)),
                    'assign_status' => 'no',
                    'qr_code' => $qr_path,
                    'parent_username' => $parent_id,
                    'parent_password' => md5($parent_id),
                    'is_active' => 'yes'
                );

                $insert = $this->db->insert('students', $insertdata);
                if ($insert) {
                    $update = array(
                        'status' => 'moved',
                    );
                    $this->db->where('id',  $applicationId);
                    $this->db->update('applications', $update);
                    return $studentMaxId;
                } else {
                    return "failed";
                }
            }
        }
    }

    public function generate_qrcode($studentID)
    {
        $hex_data   = date('YmdHis', strtotime($this->nepali_current_date)) . '-' . $studentID;
        $save_name  = $hex_data . '.png';
        $dir = 'assets_student/studentqrcode/';
        if (!file_exists($dir)) {
            mkdir($dir, 0775, true);
        }
        /* QR Configuration  */
        $config['cacheable']    = true;
        $config['imagedir']     = $dir;
        $config['quality']      = true;
        $config['size']         = '1024';
        $config['black']        = array(255, 255, 255);
        $config['white']        = array(255, 255, 255);
        $this->ciqrcode->initialize($config);
        /* QR Data  */
        $params['data']     = $studentID;
        $params['level']    = 'L';
        $params['size']     = 10;
        $params['savename'] = $config['imagedir'] . $save_name;
        $result = $this->ciqrcode->generate($params);
        return $result;
    }


    // Moving application info to students -end - by shivakuamr 


    public function move_applicationinfo($appid)
    {
        $this->db->select('*');
        $this->db->from('applications');
        $this->db->where('id', $appid);
        $query = $this->db->get();
        $res = $query->result_array();
        // echo $this->db->last_query();
        foreach ($res as $r) {
            $appStatus = $r['status'];
        }

        if ($r['status'] == "moved") {
            return -1;
        } else {
            $this->db->select_max('id');
            $query  = $this->db->get('students');
            $resid = $query->row_array();

            $pid = $resid['id'] + 1;

            if (strlen($pid) == 1)
                $pid = "00000" . $pid;
            else if (strlen($pid) == 2)
                $pid = "0000" . $pid;
            else if (strlen($pid) == 3)
                $pid = "000" . $pid;
            else if (strlen($pid) == 4)
                $pid = "00" . $pid;
            else if (strlen($pid) == 5)
                $pid = "00" . $pid;

            $studentid = "ECS" . date('Y', strtotime($this->nepali_current_date)) . $pid;

            // print_r($res);
            foreach ($res as $r) {

                $name   = $r['name'];
                $applicationid = $r['applicationid'];
                $email =  $r['email'];
                $mobile = $r['mobile'];
                $password = $r['password'];
                $gender = $r['gender'];
                $dob =   $r['dob'];
                $course = $r['course'];
                $emergency_contact_name = $r['emergency_contact_name'];
                $emergency_contact_number = $r['emergency_contact_number'];
                $country = $r['country'];
                $state = $r['state'];
                $address1 =   $r['address1'];
                $address2 =   $r['address2'];
                $zipcode =   $r['zipcode'];
                $school_certificate = $r['school_certificate'];
                $exam_result = $r['exam_result'];
                $photo = $r['photo'];
                $medical_cerificate = $r['medical_cerificate'];
                $registered_on = $r['registered_on'];
                $payment_status  = "Success";
            }

            $s = array(
                'name'   => $name,
                'studentId' => $studentid,
                'email'  => $email,
                'mobile' => $mobile,
                'password' => $password,
                'gender' => $gender,
                'dob' =>   $dob,
                'course'   => $course,
                'emergency_contact_name'  => $emergency_contact_name,
                'emergency_contact_number' => $emergency_contact_number,
                'country' => $country,
                'state' => $state,
                'address1' =>   $address1,
                'address2' =>   $address2,
                'zipcode' =>   $zipcode,
                'school_certificate' => $school_certificate,
                'exam_result' => $exam_result,
                'photo' => $photo,
                'medical_cerificate' => $medical_cerificate,
                'registered_on' => $registered_on,
                'payment_status' => $payment_status
            );

            // print_r($s);

            $insert = $this->db->insert('students', $s);
            $newId =  $this->db->insert_id();

            $update = array(
                'status' => 'moved',
            );
            $this->db->where('id',  $appid);
            $update = $this->db->update('applications', $update);
            //	echo $this->db->last_query();
            return $studentid;
        }
    }

    public function get_myClasses($id)
    {
        $nowMonth = date('m', strtotime($this->nepali_current_date));
        $nowYear = date('Y', strtotime($this->nepali_current_date));
        $nowDay = date('d', strtotime($this->nepali_current_date));

        $obj = new NepaliDate();

        // Convert BS to AD.
        $nowArr = $obj->convertBsToAd($nowYear, $nowMonth, $nowDay);
        $currConvDate = $nowArr['year'] . '-' . $nowArr['month'] . '-' . $nowArr['day'];
        $pday = strtolower(date('l', strtotime($currConvDate)));

        $query = "select classroom.id,classroom_name,classroom_session.id,session_details.subject_id,subject_name,start,join_link, classroom.classroom_name,day,duration
        from 
        students
        left join classroom on students.classroom = classroom.id 
        left join classroom_session on classroom_session.classroom_id = classroom.id 
        left join session_details on session_details.session_id = classroom_session.id
        left join subject on subject.id = session_details.subject_id
        where 
        students.id = " . $id . " and day = '" . $pday . "'";

        $q = $this->db->query($query);
        //   echo $this->db->last_query();
        return $q->result_array();
    }


    public function get_mydayClasses($id, $pday)
    {

        $query = "select classroom.id,classroom_name,classroom_session.id,session_details.subject_id,subject_name,subject_icon,start,join_link, classroom.classroom_name,day,duration
        from 
        students
        left join classroom on students.classroom = classroom.id 
        left join classroom_session on classroom_session.classroom_id = classroom.id 
        left join session_details on session_details.session_id = classroom_session.id
        left join subject on subject.id = session_details.subject_id
        where 
        students.id= " . $id . " and day = '" . $pday . "' order by day,start asc";

        $q = $this->db->query($query);
        //echo $this->db->last_query();
        return $q->result_array();
    }

    public function get_teacher($sid, $cname)
    {

        $query = "select teacher_name,photo  from classroom,teacher where classroom.subject_id = " . $sid . " and classroom_name =  '" . $cname . "' and classroom.teacher_id =teacher.id";
        $q = $this->db->query($query);
        // echo $this->db->last_query();
        return $q->result_array();
    }


    /*********************************/
    //-----shankar code of assignment starts from here---//
    /******************************* */

    public function get_assignment_list($student_id, $asgn_id = '', $month = '', $year = '')
    {
        if ($asgn_id == 0 || empty($asgn_id)) {

            $this->db->select('a.id as assignment_id, a.classroom_id, a.teacher_id, a.subject_id, a.title, a.remark, a.due_date, t.teacher_name, s.subject_name,s.subject_icon');

            $this->db->from('assignment a, subject s, teacher t, students stu, student_batch sb');
            $this->db->where('stu.id', $student_id);
            $this->db->where('stu.id = sb.student_id');
            $this->db->where('stu.batch_id = sb.batch_id');
            $this->db->where('sb.classroom_id = a.classroom_id');
            // $this->db->where('a.subject_id', $val);
            $this->db->where('a.subject_id = s.id');
            $this->db->where('a.teacher_id = t.id');
            if ($month != 00 || $year != 0) {
                $this->db->where("DATE_FORMAT(due_date,'%m')", $month);
                $this->db->where("DATE_FORMAT(due_date,'%Y')", $year);
            }
            $this->db->order_by('a.id desc');
            $query = $this->db->get();
            return $query->result_array();
        } else {
            $this->db->select('a.id as assignment_id, a.classroom_id, a.teacher_id, a.subject_id, a.title, a.remark, a.due_date, t.teacher_name, s.subject_name, s.subject_icon');
            $this->db->from('assignment a, subject s, teacher t');
            $this->db->where('a.id', $asgn_id);
            $this->db->where('a.subject_id = s.id');
            $this->db->where('a.teacher_id = t.id');
            if ($month != 00 || $year != 0) {
                $this->db->where("DATE_FORMAT(due_date,'%m')", $month);
                $this->db->where("DATE_FORMAT(due_date,'%Y')", $year);
            }
            $query = $this->db->get();
            return $query->result_array();
        }
    }


    public function upload_assignment($data)
    {
        $check = $this->db->query('select id from assignments_uploaded where Path= "' . $data['Path'] . '"');
        $res = $check->result_array();
        if ($res) {
            $data['modified'] = $this->nepali_current_date;
            $this->db->where('id', $res[0]['id']);
            $this->db->update('assignments_uploaded', $data);
            return true;
        } else {
            $data['created'] = $this->nepali_current_date;
            $this->db->insert('assignments_uploaded', $data);
            return true;
        }
    }

    public function uploaded_assignent($student_id, $asgn_id)
    {
        $this->db->select('*');
        $this->db->from('assignments_uploaded');
        $this->db->where('student_id', $student_id);
        $this->db->where('assignment_id', $asgn_id);
        $query = $this->db->get();
        return $query->result_array();
    }

    public function upload_assignment_submit($data)
    {

        $this->db->where('assignment_id', $data['assignment_id']);
        $this->db->where('student_id', $data['student_id']);
        $this->db->update('assignments_uploaded', $data);
        return true;
    }

    public function upload_assignment_cancel($asgn_id, $student_id)
    {

        $this->db->where('assignment_id', $asgn_id);
        $this->db->where('student_id', $student_id);
        $this->db->delete('assignments_uploaded');
        return true;
    }


    /**********************************************/
    //-----shankar code of assignment end  ---//
    /**********************************************/

    // Notification models - 13-10-2021

    public function getStudentNotification($id, $date)
    {
        $query = "SELECT students.name, students.email,classroom.id as classroom_id, classroom.classroom_name, classroom.course_id 
        FROM students 
        INNER JOIN student_batch sb ON students.id = sb.student_id 
        AND sb.batch_id = students.batch_id 
        INNER JOIN classroom ON sb.classroom_id = classroom.id 
        WHERE students.id = $id";

        $res = $this->db->query($query);

        if ($res->num_rows() > 0) {
            $month = $date['month'];
            $year = $date['year'];

            $classRoomId = $res->row()->classroom_id;

            $notRes = $this->db->query("Select * from notifications where (notification_to = 'student' OR notification_to = 'both') AND ((month(created_at)= '$month') AND (year(created_at) = '$year')) AND student_classroom = '$classRoomId' ORDER BY notification_id DESC");
            if ($notRes->num_rows() > 0) {
                return $notRes->result_array();
            } else {
                return false;
            }
        } else {
            return false;
        }
    }

    public function getAllStudentNotification($id, $notif_id = '')
    {

        $query = "SELECT students.name, students.email,classroom.id as classroom_id, classroom.classroom_name, classroom.course_id FROM students INNER JOIN student_batch sb ON students.id = sb.student_id AND students.batch_id = sb.batch_id INNER JOIN classroom ON sb.classroom_id = classroom.id WHERE students.id = $id";
        $res = $this->db->query($query);

        if ($res->num_rows() > 0) {
            $classRoomName = $res->row()->classroom_id;

            if ($notif_id != '') {
                $where = "n.notification_id = $notif_id";
            } else {
                $where = "n.student_classroom = '$classRoomName'";
            }

            $notRes = $this->db->query("Select n.*, t.teacher_name from notifications n left join teacher t on n.teacher_id = t.id where  $where ORDER BY n.notification_id DESC");
            if ($notRes->num_rows() > 0) {
                $notRes = $notRes->result_array();

                foreach ($notRes as $key => $value) {
                    $notRes[$key]['teacher_id'] = $value['teacher_id'] ? $value['teacher_id'] : '';
                }
                return $notRes;
            } else {
                return false;
            }
        } else {
            return false;
        }
    }

    public function getSingleNotification($id)
    {
        $query = $this->db->query('SELECT * FROM notifications WHERE notification_id = ' . $id);
        if ($query->num_rows() > 0) {
            $result = $query->row();
            return $result;
        } else {
            return 'failed';
        }
    }

    // Notification Models End - 13-10-2021

    //shankar code of Student Syllybus Models start - 29-10-2021
    public function get_student_syllabus($student_id)
    {
        $this->db->select('student_id, subject_id, subject_name, classroom.course_id, syllabus,subject_icon, subject_syllabus.id as subject_syllabus_id');
        $this->db->from('students , classroom, subject_syllabus, student_batch, subject');
        $this->db->where('students.id', $student_id);
        $this->db->where('student_batch.batch_id = students.batch_id');
        $this->db->where('students.id = student_batch.student_id');
        $this->db->where('student_batch.classroom_id = classroom.id');
        $this->db->where('subject_syllabus.course_id = classroom.course_id');
        $this->db->where('subject.id = subject_syllabus.subject_id');
        $this->db->group_by('subject_syllabus.subject_id');
        $query = $this->db->get();
        return $query->result_array();
    }
    //shankar code of Student Syllybus Models end - 29-10-2021

    // Student Attendance - 03-11-21 Afras Khan

    public function get_table_info($table_name, $where = '', $sqlQry = '', $order = 'DESC', $limit = FALSE, $offset = FALSE)
    {

        if ($limit)
            $this->db->limit($limit, $offset);

        if ($where != '')
            $this->db->where($where);

        $this->db->order_by($table_name . '.id', $order);
        $query = $this->db->get($table_name);

        if ($sqlQry != '')
            $query = $this->db->query($sqlQry);

        return $query->result_array();
    }

    public function get_student_attendance($where)
    {
        $this->db->select('student_id, classroom_id, subject_id, DATE_FORMAT(attendence_date, "%d/%m/%Y") as date, status, attendence_date, DATE_FORMAT(attendence_date,"%r") as time');
        $this->db->where($where);
        $this->db->order_by('DAY(attendence_date)', 'ASC');
        $query = $this->db->get('student_attendence');

        return $query->result_array();
    }

    // Student Attendance End - 03-11-21 Afras Khan

    //Start code of Up- Coming Test/Exams 08-11-21 - Shankar

    public function upcoming_Test_or_Exams($student_id, $exam_que_id = '')
    {
        $this->db->select('questions.id as question_id, exam_id, e_name, classroom_id, classroom_name, subject_id, subject_name, exam_date, exam_starttime, exam_endtime, total_marks ');
        $this->db->from('classroom, student_batch,students, subject, questions,exam');

        if ($exam_que_id == '' || empty($exam_que_id)) {

            $this->db->where('students.id', $student_id);
            $this->db->where('students.id = student_batch.student_id');
            $this->db->where('students.batch_id = student_batch.batch_id');
            $this->db->where('student_batch.classroom_id = classroom.id');
            $this->db->where('exam_date >=', date('Y-m-d', strtotime($this->nepali_current_date)));
        } else {

            $this->db->where('questions.id', $exam_que_id);
        }

        $this->db->where('classroom.course_id = questions.course_id');
        $this->db->where('questions.exam_id = exam.id');
        $this->db->where('subject.id = questions.subject_id');
        $this->db->group_by('questions.id');
        $query = $this->db->get();
        // echo $this->db->last_query();
        return $query->result_array();
    }


    public function get_allQuestions($que_exam_id)
    {


        $query = 'SELECT option_a , option_b , option_c , option_d , question_type_id , question_name, exam_questions.id as id , questions.course_id, questions.exam_date, questions.exam_starttime,question_name, questions.exam_endtime,exam_questions.image,subject_name, e_name, questions.id as test_id, exam_questions.question_mark as marks  from exam_questions
        LEFT JOIN questions ON questions.id = exam_questions.exam_id 
        LEFT JOIN subject ON exam_questions.subject_id = subject.id
        LEFT JOIN exam ON exam.id = questions.exam_id
        where exam_questions.exam_id = ' . $que_exam_id . ' order by exam_questions.id asc';

        $q = $this->db->query($query);
        // echo $this->db->last_query();
        return $q->result_array();
    }


    public function storeAnswer($ans_array_json, $student_id)
    {
        $ans_array = json_decode($ans_array_json, true);
        $length = count($ans_array);
        $i = 0;
        $response = 0;
        for ($i = 0; $i < $length; $i++) {
            $ans_array[$i]['created'] = $this->nepali_current_date;
            $this->db->insert('exam_answers', $ans_array[$i]);
            $res = $this->db->insert_id();

            $query = $this->db->query('select ea.answer, eq.correct_answer, eq.question_mark from exam_questions eq, exam_answers ea where ea.id=' . $res . ' and ea.exam_questions_id = eq.id');
            $data = $query->row_array();


            if ($data['answer'] == $data['correct_answer']) {
                $this->db->set('review', $data['question_mark']);
            } else if ($data['correct_answer'] == '') {

                $this->db->set('review', '');
            } else {

                $this->db->set('review', 0);
            }
            $this->db->set('modified', $this->nepali_current_date);
            $this->db->where('id', $res);
            $this->db->update('exam_answers');
            $updated_status = $this->db->affected_rows();
            if ($updated_status) {
                $response = 1;
            }
        }
        return $response;
    }

    //End code of Up- Coming Test/Exams 10-11-21 - Shankar

    // to get application fee by shivu -start

    public function get_query_result($sqlQry)
    {
        if ($sqlQry != '')
            $query = $this->db->query($sqlQry);
        return $query->result_array();
    }
    public function get_query_row($sqlQry)
    {
        if ($sqlQry != '')
            $query = $this->db->query($sqlQry);
        return $query->row_array();
    }

    public function get_general_row_details($table_name, $where = '', $sqlQry = '', $order_by = 'ASC', $limit = FALSE, $offset = FALSE)
    {
        if ($limit)
            $this->db->limit($limit, $offset);

        if ($where != '')
            $this->db->where($where);

        $this->db->order_by($table_name . '.id', $order_by);
        $query = $this->db->get($table_name);

        if ($sqlQry != '')
            $query = $this->db->query($sqlQry);

        return $query->row_array();
    }

    // to get application fee by shivu -end

    // Hostel Afras Khan

    function add_edit_table($table, $id, $data, $update_where = '')
    {
        if ($id == 0) {
            $this->db->insert($table, $data);
            if ($this->db->affected_rows() > 0)
                return  $insert_id = $this->db->insert_id();
            else
                return 0;
        } else {

            if ($update_where != '')
                $this->db->where($update_where);
            else
                $this->db->where('id', $id);

            $this->db->update($table, $data);
            if ($this->db->trans_status() === FALSE)
                return 0;

            return true;
        }
    }

    // Hostel End

    //getStudent_id from user_api 
    public function getStudentId($id)
    {
        $result = $this->db->query('select id,studentId from students where studentId = "' . $id . '"')->row_array();
        return $result;
    }

    public function get_logo_from_setting()
    {
        $this->db->select('*');
        $this->db->from('school_settings');
        $query = $this->db->get();
        return $query->row_array();
    }
}