<?php

/* * *************************************************************
 * Catabatic Technology Pvt. Ltd.
 * File Name : Faq.php
 * File Description : Faq Model
 * Created By : Prashant Kumar
 * Created Date: 05-September-2014
 * ************************************************************* */

class Admin_Model_User extends Zend_Db_Table_Abstract {

    function __construct() {
        
    }

    /**
     * checkUsernameExistsOrNot() method is used to get check username exists or not
     * @param email string
     * @return object 
     */
    public function checkUsernameExistsOrNot($content) {
        $dbtable = Zend_Db_Table::getDefaultAdapter();
        $select = $dbtable->select()
                ->from("tbl_user", array('count(*) AS total_records'))
                ->where("username =?", $content);
        $result = $dbtable->fetchOne($select);
        return $result;
    }

    public function getUserDetail($userName) {
        $dbtable = Zend_Db_Table::getDefaultAdapter();
        $select = $dbtable->select()
                ->from("tbl_user", array('isPasswordDisable', 'username', 'IsLoggedIn', 'USERAGENT', 'LastActiveOn'))
                ->where("username =?", $userName);
        $result = $dbtable->fetchRow($select);
        return $result;
    }

    public function otpdata() {
//        $dbtable = Zend_Db_Table::getDefaultAdapter(); 
//        $select = $dbtable->select()
//                          ->from("tbl_setting",array('isotpEnabled','id'))
//                          ->where("id =?",1);
//        $result = $dbtable->fetchRow($select);
        $result = array("isotpEnabled" => false, "id" => 1);
        return $result;
    }

    /**
     * add() method is used to add state name
     * @param array
     * @return true 
     */
    public function add($addData = array()) {
        $dbtable = new Zend_Db_Table('tbl_user');
        $dbtable->insert($addData);
    }

    /**
     * checkEditUsernameExistsOrNot() method is used to get check faq queation exists or not
     * @param email string
     * @return object 
     */
    public function checkEditUsernameExistsOrNot($user_id, $username) {
        $dbtable = Zend_Db_Table::getDefaultAdapter();
        $select = $dbtable->select()
                ->from("tbl_user", array('count(*) AS total_records'))
                ->where("username =?", $username)
                ->where('md5(concat("DCBUSER",id))!=?', $user_id);
        $result = $dbtable->fetchOne($select);
        return $result;
    }

    /**
     * edit() method is used to add menu
     * @param array
     * @return true 
     */
    public function edit($editData, $where) {
        $dbtable = new Zend_Db_Table('tbl_user');
        $dbtable->update($editData, $where);
    }

    /**
     * getAllUsersList() method is used to get all users list
     * @param email string
     * @return object 
     */
    public function getAllUsersList() {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from(array("tbl_user"), array('*'))
                ->where('type !=?', 'superadmin')
                ->order('username');
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getSomeUsersList() method is used to get all users list
     * @param email string
     * @return object 
     */
    public function getSomeUsersList() {
        $db = Zend_Db_Table::getDefaultAdapter();
        $select = $db->select()
                ->from(array("tbl_user"), array('*'))
                ->where('type !=?', 'superadmin')
                ->order('username')
                ->limit(5, 0);
        $result = $db->fetchAll($select);
        return $result;
    }

    /**
     * getUserDetailsById() method is used to get all menus details by hierarchy menu id
     * @param email string
     * @return object 
     */
    public function getUserDetailsById($usrId) {
        $dbtable = new Zend_Db_Table('tbl_user');
        $select = $dbtable->select()
                ->where('md5(concat("DCBUSER",id))= ?', $usrId);
        $result = $dbtable->fetchRow($select);
        return $result;
    }

    /**
     * delete() method is used to delete user
     * @param array
     * @return true 
     */
    public function delete($usrId) {
        $dbtable = new Zend_Db_Table('tbl_user');
        $where = array('md5(concat("DCBUSER",id))=?' => $usrId);
        $dbtable->delete($where);
    }

    public function addlog($logData = array()) {
        $dbtable = new Zend_Db_Table('tbl_dcb_log');
        $dbtable->insert($logData);
    }

    /**
     * updatePassword() method is used to edit password
     * @param array
     * @return true 
     */
    public function updatePassword($updateData, $where) {
        $dbtable = new Zend_Db_Table('tbl_user');
        $dbtable->update($updateData, $where);
    }

    /**
     * get_rand_id() method is used to generate random string
     * @param string
     * @return True 
     */
    public function get_random_string($length) {
        if ($length > 0) {
            $rand_id = "";
            for ($i = 1; $i <= $length; $i++) {
                mt_srand((double) microtime() * 1000000);
                $num = mt_rand(1, 36);
                $rand_id .= $this->assign_rand_value($num);
            }
        }
        return $rand_id;
    }

    public function assign_rand_value($num) {
        // accepts 1 - 36
        switch ($num) {
            case "1":
                $rand_value = "a";
                break;
            case "2":
                $rand_value = "b";
                break;
            case "3":
                $rand_value = "c";
                break;
            case "4":
                $rand_value = "d";
                break;
            case "5":
                $rand_value = "e";
                break;
            case "6":
                $rand_value = "f";
                break;
            case "7":
                $rand_value = "g";
                break;
            case "8":
                $rand_value = "h";
                break;
            case "9":
                $rand_value = "i";
                break;
            case "10":
                $rand_value = "j";
                break;
            case "11":
                $rand_value = "k";
                break;
            case "12":
                $rand_value = "l";
                break;
            case "13":
                $rand_value = "m";
                break;
            case "14":
                $rand_value = "n";
                break;
            case "15":
                $rand_value = "o";
                break;
            case "16":
                $rand_value = "p";
                break;
            case "17":
                $rand_value = "q";
                break;
            case "18":
                $rand_value = "r";
                break;
            case "19":
                $rand_value = "s";
                break;
            case "20":
                $rand_value = "t";
                break;
            case "21":
                $rand_value = "u";
                break;
            case "22":
                $rand_value = "v";
                break;
            case "23":
                $rand_value = "w";
                break;
            case "24":
                $rand_value = "x";
                break;
            case "25":
                $rand_value = "y";
                break;
            case "26":
                $rand_value = "z";
                break;
            case "27":
                $rand_value = "0";
                break;
            case "28":
                $rand_value = "1";
                break;
            case "29":
                $rand_value = "2";
                break;
            case "30":
                $rand_value = "3";
                break;
            case "31":
                $rand_value = "4";
                break;
            case "32":
                $rand_value = "5";
                break;
            case "33":
                $rand_value = "6";
                break;
            case "34":
                $rand_value = "7";
                break;
            case "35":
                $rand_value = "8";
                break;
            case "36":
                $rand_value = "9";
                break;
        }
        return $rand_value;
    }

    public function addLogs($addData = array()) {
        $dbtable = new Zend_Db_Table('tbl_user_loggedin_log');
        $dbtable->insert($addData);
    }

}