<?php

/**
 * Copyright 2013 Catabatic Automation Technology Pvt Ltd.
 * All rights reserved
 *
 * @description: Travel_Model_TblUser.php, User Model. 2016/07/01 13:29
 * @author: Shakti Rana <shakti@catpl.co.in>
 */
include_once 'BaseModel.php';

class Travel_Model_TblUser extends BaseModel {

    public function getRecords($sql) {
        $sql = @$sql ? $sql : "SELECT * FROM TB_Admin_user";
        return $this->db->query($sql)->fetchAll();
    }

    public function getAdminUserDetail($userName) {
        $sql = "SELECT * FROM TB_Admin_User WHERE UserName='$userName'";
        return $this->db->query($sql)->fetch();
    }

    public function getAgencyUserDetail($userName, $userrole = 0, $getAgencySysIdFromIni = NULL) {
        if ($getAgencySysIdFromIni && (int) $userrole > 0) {
            $sql = "SELECT * FROM TB_Agency_User WHERE EmailId='$userName' AND IsB2BAgent=$userrole AND CreatedByUserSysId = $getAgencySysIdFromIni";
        } else {
            $sql = "SELECT * FROM TB_Agency_User WHERE EmailId='$userName' AND IsB2BAgent=0";
        }
        return $this->db->query($sql)->fetch();
    }

    public function getAgencyUserDetailBYAgencyId($AgencySysId) {
        $sql = "SELECT * FROM TB_Agency_User WHERE AgencySysId='$AgencySysId' AND IsB2BAgent=0";
        return $this->db->query($sql)->fetch();
    }

    public function getTrxCurrency($intAgencySysId) {
        $sql = " SELECT TrxCurrency FROM TB_Agency WHERE AgencySysId = " . $intAgencySysId;
        return $this->db->query($sql)->fetch();
    }

    public function getAgencyGroup($intAgencySysId) {
        $sql = " SELECT GrSysId FROM TB_Agency_User_Group WHERE AgencySysId = " . $intAgencySysId;
        return $this->db->query($sql)->fetch();
    }

    public function ispasswordExists($password, $userRole, $userId) {
        $table = ($userRole == 1) ? 'TB_Agency_User' : 'TB_Agency_User';
        $whereCondition = "Password = '$password'";
        if ($userId) {
            $whereCondition .= " AND UserSysId = " . $userId;
        }
        $select = $this->db->select()
                ->from($table, array('count(*) AS totalRecords'))
                ->where($whereCondition);
//echo $select; exit;
        $count = $this->db->fetchOne($select);
        if ($count > 0) {
            return true;
        }
        return false;
    }

    public function getUserDetails($userRole = NULL, $userId = NULL) {
        $tableName = ($userRole == 1) ? 'TB_Agency_User' : 'TB_Agency_User';
        $condition = ($userRole == 1) ? "WHERE UserSysId = " . $userId : "WHERE UserSysId = " . $userId . " AND IsB2BAgent=0";
        return $this->getAllRecords($tableName, $condition);
    }

    public function getUserSignature($userRole = NULL, $userId = NULL) {
        $tableName = ($userRole == 1) ? 'TB_Admin_User' : 'TB_Agency_User';
        $whereCondition = ($userRole == 1) ? " UserSysId = " . $userId : " UserSysId = " . $userId . " AND IsB2BAgent=0";
        $select = $this->db->select()
                ->from($tableName)
                ->where($whereCondition);
        $result = $this->db->fetchRow($select);
        return !empty($result['Signature']) ? $result['Signature'] : '';
    }

    public function updateChangePassword($userRole = NULL, $userId = NULL, $password, $IsB2BAgent = 0) {
        $tableName = ($userRole == 1) ? 'TB_Agency_User' : 'TB_Agency_User';
        if ($userRole != 1) {
            $updatePass['RandStr'] = $password; //update password for agency  
        }
        $updatePass['password'] = md5($password);
//        echo '<pre>'.$userRole;print_r($updatePass);
        if ($userRole == 1) {
            $where = array('UserSysId =?' => $userId);
        } else {
            $where = array('UserSysId =?' => $userId);
        }
        return $this->db->update($tableName, $updatePass, $where);
    }
    public function UpdateAgencyUser(array $data, $where=NULL){
       return $this->db->update('TB_Agency_User', $data, $where);
    }

}