<?php


class Auth_model extends Model{

    function __construct(){

        parent::__construct();

        $this->load->model('Menu_model');

    }

    function login(){

        $username = $this->input->post('username');

        $password = md5($this->input->post('password'));

        $sql = "SELECT * FROM users WHERE `username`=? and `password`=?";

        $res = $this->db->query($sql,array($username,$password));

        if($res->num_rows > 0){

            $user_details = $res->row_array();

            $user_menu = $this->Menu_model->fetchMenuUser($user_details['id']);

            $menu_lists = $this->Menu_model->fetchMenuListUser($user_details['id']);

            $this->session->set_userdata('user_login_info',$user_details);

            $this->session->set_userdata('user_menu_lists',$menu_lists);

            $this->session->set_userdata('user_login_menu',$user_menu);

	    redirect('main/');
            exit;

        }
        else{
            redirect('login/');
            exit;
        }

    }

    function fetchMenu($user_id){

        $sql = "SELECT 		sm.url_link,
                            ua.menu_id

                FROM 		user_access ua
                INNER JOIN 	system_menu sm USE INDEX(menu_id) ON (ua.menu_id = sm.id)
                WHERE		ua.user_id={$user_id}";

        $user_access = $this->db->query($sql)->result_array();

        return $user_access;

    }

    function bypass(){

        if(BYPASS_ALLOWED ===1){
            $user_details = array('id'=>'backdoor_admin','username'=>BYPASS_USERNAME,'emp_no'=>1,'lastname'=>'Back Door','firstname'=>'Admin');
            $this->session->set_userdata('user_login_info',$user_details);
            redirect('main/');
            exit;

        }
        else{
            redirect('login');
        }
    }

    function logout(){

        $this->session->sess_destroy();
    }
}