|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/akaindir/www/crm/modules/Settings/LoginHistory/models/ |
Upload File : |
<?php
/*+***********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
*************************************************************************************/
class Settings_LoginHistory_ListView_Model extends Settings_Vtiger_ListView_Model {
/**
* Funtion to get the Login history basic query
* @return type
*/
public function getBasicListQuery() {
$module = $this->getModule();
$userNameSql = getSqlForNameInDisplayFormat(array('first_name'=>'vtiger_users.first_name', 'last_name' => 'vtiger_users.last_name'), 'Users');
$query = "SELECT login_id, $userNameSql AS user_name, user_ip, logout_time, login_time, vtiger_loginhistory.status FROM $module->baseTable
INNER JOIN vtiger_users ON vtiger_users.user_name = $module->baseTable.user_name";
$search_key = $this->get('search_key');
$value = Vtiger_Functions::realEscapeString($this->get('search_value'));
if(!empty($search_key) && !empty($value)) {
$query .= " WHERE $module->baseTable.$search_key = '$value'";
}
$query .= " ORDER BY login_time DESC";
return $query;
}
public function getListViewLinks() {
return array();
}
/**
* Function which will get the list view count
* @return - number of records
*/
public function getListViewCount() {
$db = PearDatabase::getInstance();
$module = $this->getModule();
$listQuery = "SELECT count(*) AS count FROM $module->baseTable INNER JOIN vtiger_users ON vtiger_users.user_name = $module->baseTable.user_name";
$search_key = $this->get('search_key');
$value = $this->get('search_value');
if(!empty($search_key) && !empty($value)) {
$listQuery .= " WHERE $module->baseTable.$search_key = '$value'";
}
$listResult = $db->pquery($listQuery, array());
return $db->query_result($listResult, 0, 'count');
}
}