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


class Login_model extends CI_Model {

	function __construct()
    {
        parent::__construct();
    }

    function loginFunctionForAllUsers (){

        $email = html_escape($this->input->post('email'));
        $password = html_escape($this->input->post('password'));
        $credential = array('email' => $email, 'password' => sha1($password));


        $exhibition_admin_email = html_escape($this->input->post('exhibition_admin_email'));
        $exhibition_admin_password = html_escape($this->input->post('password'));
        $exhibition_credential = array('exhibition_admin_email' => $exhibition_admin_email, 'password' => sha1($exhibition_admin_password));

/* Super Admin */
        $query = $this->db->get_where('superadmin', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();
            $this->session->set_userdata('login_type', 'superadmin');
            $this->session->set_userdata('superadmin_login', '1');
            $this->session->set_userdata('superadmin_id', $row->superadmin_id);
            $this->session->set_userdata('login_user_id', $row->superadmin_id);
            return  $this->db->set('login_status', ('1'))
                    ->where('superadmin_id', $this->session->userdata('superadmin_id'))
                    ->update('superadmin');
        }


/* Admin */

        $query = $this->db->get_where('admin', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();
            $this->session->set_userdata('login_type', 'admin');
            $this->session->set_userdata('admin_login', '1');
            $this->session->set_userdata('admin_id', $row->admin_id);
            $this->session->set_userdata('login_user_id', $row->admin_id);
            $this->session->set_userdata('name', $row->name);
            $this->session->set_userdata('exhibition_id', $row->exhibition_id);
            // $this->session->set_userdata('clinic_id', $row->clinic_id);
            return  $this->db->set('login_status', ('1'))
                    ->where('admin_id', $this->session->userdata('admin_id'))
                    ->update('admin');
        }
// exhibition admin
        $query = $this->db->get_where('exhibition', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();
            $this->session->set_userdata('login_type', 'admin');
            $this->session->set_userdata('admin_login', '1');
            $this->session->set_userdata('admin_id', $row->exhibition_id);
            $this->session->set_userdata('login_user_id', $row->exhibition_id);
            $this->session->set_userdata('name', $row->exhibition_name);
            $this->session->set_userdata('exhibition_id', $row->exhibition_id);
            return
            $this->db->set('login_status', ('1'))
                    ->where('exhibition_id', $this->session->userdata('exhibition_id'))
                    ->update('exhibition');
        }

        $query = $this->db->get_where('hrm', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();

            $this->session->set_userdata('login_type', 'hrm');
            $this->session->set_userdata('hrm_login', '1');
            $this->session->set_userdata('hrm_id', $row->hrm_id);
            $this->session->set_userdata('login_user_id', $row->hrm_id);
            $this->session->set_userdata('name', $row->name);

            return  $this->db->set('login_status', ('1'))
                    ->where('hrm_id', $this->session->userdata('hrm_id'))
                    ->update('hrm');
        }

        $query = $this->db->get_where('hostel', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();

            $this->session->set_userdata('login_type', 'hostel');
            $this->session->set_userdata('hostel_login', '1');
            $this->session->set_userdata('hostel_id', $row->hostel_id);
            $this->session->set_userdata('login_user_id', $row->hostel_id);
            $this->session->set_userdata('name', $row->name);

            return  $this->db->set('login_status', ('1'))
                    ->where('hostel_id', $this->session->userdata('hostel_id'))
                    ->update('hostel');
        }

        $query = $this->db->get_where('accountant', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();

            $this->session->set_userdata('login_type', 'accountant');
            $this->session->set_userdata('accountant_login', '1');
            $this->session->set_userdata('accountant_id', $row->accountant_id);
            $this->session->set_userdata('login_user_id', $row->accountant_id);
            $this->session->set_userdata('name', $row->name);

            return  $this->db->set('login_status', ('1'))
                    ->where('accountant_id', $this->session->userdata('accountant_id'))
                    ->update('accountant');
        }

        $query = $this->db->get_where('librarian', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();

            $this->session->set_userdata('login_type', 'librarian');
            $this->session->set_userdata('librarian_login', '1');
            $this->session->set_userdata('librarian_id', $row->librarian_id);
            $this->session->set_userdata('login_user_id', $row->librarian_id);
            $this->session->set_userdata('name', $row->name);

            return  $this->db->set('login_status', ('1'))
                    ->where('librarian_id', $this->session->userdata('librarian_id'))
                    ->update('librarian');
        }

        $query = $this->db->get_where('parent', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();

            $this->session->set_userdata('login_type', 'parent');
            $this->session->set_userdata('parent_login', '1');
            $this->session->set_userdata('parent_id', $row->parent_id);
            $this->session->set_userdata('login_user_id', $row->parent_id);
            $this->session->set_userdata('name', $row->name);

            return  $this->db->set('login_status', ('1'))
                    ->where('parent_id', $this->session->userdata('parent_id'))
                    ->update('parent');
        }

        $query = $this->db->get_where('student', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();

            $this->session->set_userdata('login_type', 'student');
            $this->session->set_userdata('student_login', '1');
            $this->session->set_userdata('student_id', $row->student_id);
            $this->session->set_userdata('login_user_id', $row->student_id);
            $this->session->set_userdata('name', $row->name);

            return  $this->db->set('login_status', ('1'))
                    ->where('student_id', $this->session->userdata('student_id'))
                    ->update('student');
        }

        $query = $this->db->get_where('teacher', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();

            $this->session->set_userdata('login_type', 'teacher');
            $this->session->set_userdata('teacher_login', '1');
            $this->session->set_userdata('teacher_id', $row->teacher_id);
            $this->session->set_userdata('login_user_id', $row->teacher_id);
            $this->session->set_userdata('name', $row->name);

            return  $this->db->set('login_status', ('1'))
                    ->where('teacher_id', $this->session->userdata('teacher_id'))
                    ->update('teacher');
        }

        $query = $this->db->get_where('doctor', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();

            $this->session->set_userdata('login_type', 'doctor');
            $this->session->set_userdata('doctor_login', '1');
            $this->session->set_userdata('doctor_id', $row->doctor_id);
            $this->session->set_userdata('login_user_id', $row->doctor_id);
            $this->session->set_userdata('name', $row->name);

            return  $this->db->set('login_status', ('1'))
                    ->where('doctor_id', $this->session->userdata('doctor_id'))
                    ->update('doctor');
        }
        $query = $this->db->get_where('exhibitor', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();

            $this->session->set_userdata('login_type', 'exhibitor');
            $this->session->set_userdata('exhibitor_login', '1');
            $this->session->set_userdata('exhibitor_id', $row->exhibitor_id);
            $this->session->set_userdata('exhibition_id', $row->exhibition_id);
            $this->session->set_userdata('login_user_id', $row->exhibitor_id);
            $this->session->set_userdata('name', $row->name);

            return  $this->db->set('login_status', ('1'))
                    ->where('exhibitor_id', $this->session->userdata('exhibitor_id'))
                    ->update('exhibitor');
        }


        $query = $this->db->get_where('visitor', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();
            $this->session->set_userdata('login_type', 'visitor');
            $this->session->set_userdata('visitor_login', '1');
            $this->session->set_userdata('visitor_id', $row->visitor_id);
            $this->session->set_userdata('exhibition_id', $row->exhibition_id);
            $this->session->set_userdata('login_user_id', $row->visitor_id);
            $this->session->set_userdata('name', $row->name);
            return  $this->db->set('login_status', ('1'))
                    ->where('visitor_id', $this->session->userdata('visitor_id'))
                    ->update('visitor');
        }

        $query = $this->db->get_where('patient', $credential);
        if ($query->num_rows() > 0) {
            $row = $query->row();
            $this->session->set_userdata('login_type', 'patient');
            $this->session->set_userdata('patient_login', '1');
            $this->session->set_userdata('patient_id', $row->patient_id);
            $this->session->set_userdata('login_user_id', $row->patient_id);
            $this->session->set_userdata('name', $row->name);
            return  $this->db->set('login_status', ('1'))
                    ->where('patient_id', $this->session->userdata('patient_id'))
                    ->update('patient');
        }
    }

    function logout_model_for_super_admin(){
        return  $this->db->set('login_status', ('0'))
            ->where('superadmin_id', $this->session->userdata('superadmin_id'))
            ->update('superadmin');
    }
    function logout_model_for_admin(){
        return  $this->db->set('login_status', ('0'))
                ->where('admin_id', $this->session->userdata('admin_id'))
                ->update('admin');
    }
    function logout_model_for_exhibition_admin(){
        return  $this->db->set('login_status', ('0'))
                ->where('exhibition_id', $this->session->userdata('exhibition_id'))
                ->update('exhibition');
    }

    function logout_model_for_hrm(){
        return  $this->db->set('login_status', ('0'))
                    ->where('hrm_id', $this->session->userdata('hrm_id'))
                    ->update('hrm');
    }

    function logout_model_for_hostel(){
        return  $this->db->set('login_status', ('0'))
                    ->where('hostel_id', $this->session->userdata('hostel_id'))
                    ->update('hostel');
    }

    function logout_model_for_accountant(){
        return  $this->db->set('login_status', ('0'))
                    ->where('accountant_id', $this->session->userdata('accountant_id'))
                    ->update('accountant');
    }

    function logout_model_for_librarian(){
        return  $this->db->set('login_status', ('0'))
                    ->where('librarian_id', $this->session->userdata('librarian_id'))
                    ->update('librarian');
    }

    function logout_model_for_parent(){
        return  $this->db->set('login_status', ('0'))
                    ->where('parent_id', $this->session->userdata('parent_id'))
                    ->update('parent');
    }

    function logout_model_for_teacher(){
        return  $this->db->set('login_status', ('0'))
                    ->where('teacher_id', $this->session->userdata('teacher_id'))
                    ->update('teacher');
    }
    function logout_model_for_doctor(){
        return  $this->db->set('login_status', ('0'))
                    ->where('doctor_id', $this->session->userdata('doctor_id'))
                    ->update('doctor');
    }
    function logout_model_for_exhibitor(){
        return  $this->db->set('login_status', ('0'))
                    ->where('exhibitor_id', $this->session->userdata('exhibitor_id'))
                    ->update('exhibitor');
    }
    function logout_model_for_visitor(){
        return  $this->db->set('login_status', ('0'))
                    ->where('visitor_id', $this->session->userdata('visitor_id'))
                    ->update('visitor');
    }
    function logout_model_for_patient(){
        return  $this->db->set('login_status', ('0'))
                    ->where('patient_id', $this->session->userdata('patient_id'))
                    ->update('patient');
    }
    function logout_model_for_student(){
        return  $this->db->set('login_status', ('0'))
                    ->where('student_id', $this->session->userdata('student_id'))
                    ->update('student');
    }
}