1#@!#!123s

: / home / ksclnmuac / public_html / cas / application / models / admin /
Filename : UserAuthenticator.php
back
<?php

/**
 * Model For Handling All DB Operations Related To User Authentication
 *
 * @author Softpro India Pvt. Ltd.
 */
defined('BASEPATH') OR exit('No direct script access allowed');

class UserAuthenticator extends CI_Model {

    function __construct() {
        parent::__construct();
        $this->load->library("user_agent");
        $this->load->model("admin/AccessLog");
        $this->load->model("admin/MenuManagement");
    }

    function authLogin($signinId, $password) {
        $sql = "SELECT TLD.tld_id,TLD.tld_signinid, TLD.tld_is_head,TLD.tld_login_status, TPRFL.tprfl_id,TPRFL.tprfl_firstname, TPRFL.tprfl_lastname,"
                . "TPRFL.tprfl_gender,TPRFL.tprfl_mobile_no,TPRFL.tprfl_email,TPRFL.tprfl_dob,TLD.tld_is_first_login,"
                . "SMEMBER.smember_id,SMEMBER.role_id, TRM.role_name,TRM.role_code, TDM.desig_name,TSBM.branch_id,"
                . "TSBM.branch_name,TSBM.branch_short_name,TSBM.branch_email,TSBM.branch_website_url,TSBM.branch_tel_no,"
                . "TSBM.branch_fax,TSBM.branch_mobile_no,TDEPM.dept_id, TDEPM.dept_name,TSDEPM.sub_dept_name, "
                . "TDDI.tddi_doc_file_path from tbl_logindetails TLD, tbl_profile TPRFL,tbl_staff_members SMEMBER, "
                . "tbl_role_master TRM, tbl_designation_master TDM, tbl_sms_branch_master TSBM, tbl_department_master TDEPM, "
                . "tbl_sub_departments_master TSDEPM, tbl_document_document_info TDDI where TLD.tld_signinid='" . $signinId . "' and "
                . "TLD.tld_password='" . $password . "' and TLD.tld_working_status != 'L' and SMEMBER.tprfl_id = TPRFL.tprfl_id and "
                . "SMEMBER.tld_id = TLD.tld_id and SMEMBER.role_id = TRM.role_id and TPRFL.desig_id = TDM.desig_id and "
                . "TLD.branch_id = TSBM.branch_id and TLD.sub_dept_id = TSDEPM.sub_dept_id and TSDEPM.dept_id = TDEPM.dept_id"
                . " and SMEMBER.smember_id = TDDI.tddi_mapping_id and (TDDI.tddi_doc_id = '1' OR TDDI.tddi_code = '001')";
        $query = $this->db->query($sql);
        if ($query->num_rows() == 1) {
            $empInfo = $query->result()[0];
            if ($empInfo->tld_login_status == 'T') {
                foreach ($query->result() as $rows) {
                    $access_id = $this->AccessLog->createAccessLog($rows->smember_id, 'T', $this->input->ip_address(), "Browser:" . $this->agent->browser() . "--Version:" . $this->agent->version() . "--Mobile:" . $this->agent->mobile() . "--Platform:" . $this->agent->platform());
                    /* Making Allotted Menus And Sub-Menus Data */
                    $menuData = array();
                    $slugArray = array();
                    $assignedMainMenusInfo = $this->MenuManagement->getAllAssignedMainMenusByStaffMemeberId($rows->smember_id)->result();
                    for ($i = 0; $i < sizeof($assignedMainMenusInfo); $i++) {
                        $subMenuData = array();
                        $subMenuInfo = $this->MenuManagement->getAllAssignedSubMenusBy($assignedMainMenusInfo[$i]->group_id, $rows->smember_id)->result();
                        if (sizeof($subMenuInfo)) {
                            for ($j = 0; $j < sizeof($subMenuInfo); $j++) {
                                array_push($subMenuData, array(
                                    'sub_menu_available' => 1,
                                    'sub_menu_id' => $subMenuInfo[$j]->oprtn_id,
                                    'sub_menu_name' => stripslashes($subMenuInfo[$j]->oprtn_name),
                                    'sub_menu_title' => stripslashes($subMenuInfo[$j]->oprtn_title),
                                    'sub_menu_tooltip' => stripslashes($subMenuInfo[$j]->oprtn_tooltip),
                                    'sub_menu_slug_url' => $subMenuInfo[$j]->oprtn_slug_url,
                                    'is_hidden' => $subMenuInfo[$j]->oprtn_hidden_status
                                ));
                                array_push($slugArray, $subMenuInfo[$j]->oprtn_slug_url);
                            }
                        } else {
                            array_push($subMenuData, array(
                                'sub_menu_available' => 0,
                                'sub_menu_id' => '',
                                'sub_menu_name' => '',
                                'sub_menu_title' => '',
                                'sub_menu_tooltip' => '',
                                'sub_menu_slug_url' => '',
                                'is_hidden' => ''
                            ));
                        }
                        $isIsolatedMainMenu = 1;
                        if ($assignedMainMenusInfo[$i]->group_slug_url == "NA" || $assignedMainMenusInfo[$i]->group_slug_url == NULL) {
                            $isIsolatedMainMenu = 0;
                        }
                        array_push($menuData, array(
                            'main_menu_id' => $assignedMainMenusInfo[$i]->group_id,
                            'main_menu_name' => stripslashes($assignedMainMenusInfo[$i]->main_menu_name),
                            'main_menu_title' => stripslashes($assignedMainMenusInfo[$i]->group_title),
                            'main_menu_tooltip' => stripslashes($assignedMainMenusInfo[$i]->group_tooltip),
                            'main_menu_icon_class' => $assignedMainMenusInfo[$i]->group_icon,
                            'main_menu_slug_url' => $assignedMainMenusInfo[$i]->group_slug_url,
                            'is_isolated_main_menu' => $isIsolatedMainMenu,
                            'sub_menu_data' => $subMenuData
                        ));
                        array_push($slugArray, $assignedMainMenusInfo[$i]->group_slug_url);
                    }
                    /* Making Allotted Menus And Sub-Menus Data */
                    $admindata = array(
                        'login_detail_id' => $rows->tld_id,
                        'login_signin_id' => $rows->tld_signinid,
                        'is_head' => $rows->tld_is_head,
                        'is_first_login' => $rows->tld_is_first_login,
                        'profile_id' => $rows->tprfl_id,
                        'first_name' => $rows->tprfl_firstname,
                        'last_name' => $rows->tprfl_lastname,
                        'gender' => $rows->tprfl_gender,
                        'email' => $rows->tprfl_email,
                        'mobile' => $rows->tprfl_mobile_no,
                        'dob' => $rows->tprfl_dob,
                        'smember_id' => $rows->smember_id,
                        'role' => $rows->role_name,
                        'role_id' => $rows->role_id,
                        'role_code' => $rows->role_code,
                        'designation' => $rows->desig_name,
                        'branch_id' => $rows->branch_id,
                        'branch_name' => $rows->branch_name,
                        'branch_short_name' => $rows->branch_short_name,
                        'branch_email' => $rows->branch_email,
                        'branch_mobile' => $rows->branch_mobile_no,
                        'branch_tel' => $rows->branch_tel_no,
                        'branch_fax' => $rows->branch_fax,
                        'branch_website' => $rows->branch_website_url,
                        'dept_id' => $rows->dept_id,
                        'dept_name' => $rows->dept_name,
                        'sub_dept_name' => $rows->sub_dept_name,
                        'image' => $rows->tddi_doc_file_path,
                        'access_grant_id' => $access_id,
                        'logged_in' => TRUE
                    );
                }
                $this->session->set_userdata("adminData", $admindata);
                $this->session->set_userdata("menuData", $menuData);
                $this->session->set_userdata("slugData", $slugArray);
                return 1;
            } else {
                return 'Your Login Is Temporarily Blocked.';
            }
        } else {
            return 0;
        }
    }

    function authLogout() {
        $this->AccessLog->updateAccessLog($this->session->userdata("adminData")['access_grant_id'], 'F');
        $this->session->sess_destroy();
        $this->session->set_userdata("adminData", array('logged_in' => FALSE));
        $this->session->set_userdata("menuData", "");
        $this->session->set_userdata("slugData", "");
        return true;
    }

    function authenticateUserByLoginIdAndPassword($tld_id, $encryptedPassword) {
        $this->db->select("*");
        $this->db->from('tbl_logindetails');
        $this->db->where('tld_id', $tld_id);
        $this->db->where('tld_password', $encryptedPassword);
        $query = $this->db->get();
        if (sizeof($query->result()) == 1) {
            return true;
        } else {
            return false;
        }
    }

    function updateNewPassword($passwordUpdateData) {
        $this->db->where('tld_id', $passwordUpdateData['tld_id']);
        $this->db->update('tbl_logindetails', $passwordUpdateData);
        return true;
    }

}