128 lines
4.0 KiB
PHP
128 lines
4.0 KiB
PHP
|
<?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.
|
||
|
|
*
|
||
|
|
********************************************************************************/
|
||
|
|
|
||
|
|
include_once('config.php');
|
||
|
|
require_once('include/logging.php');
|
||
|
|
require_once('include/logging.php');
|
||
|
|
require_once('include/ListView/ListView.php');
|
||
|
|
require_once('include/database/PearDatabase.php');
|
||
|
|
|
||
|
|
/** This class is used to track all the operations done by the particular User while using vtiger crm.
|
||
|
|
* It is intended to be called when the check for audit trail is enabled.
|
||
|
|
**/
|
||
|
|
class AuditTrail{
|
||
|
|
|
||
|
|
var $log;
|
||
|
|
var $db;
|
||
|
|
|
||
|
|
var $auditid;
|
||
|
|
var $userid;
|
||
|
|
var $module;
|
||
|
|
var $action;
|
||
|
|
var $recordid;
|
||
|
|
var $actiondate;
|
||
|
|
|
||
|
|
var $module_name = "Settings";
|
||
|
|
var $table_name = "vtiger_audit_trial";
|
||
|
|
|
||
|
|
var $object_name = "AuditTrail";
|
||
|
|
|
||
|
|
var $new_schema = true;
|
||
|
|
|
||
|
|
function AuditTrail() {
|
||
|
|
$this->log = LoggerManager::getLogger('audit_trial');
|
||
|
|
$this->db = PearDatabase::getInstance();
|
||
|
|
}
|
||
|
|
|
||
|
|
var $sortby_fields = Array('module', 'action', 'actiondate', 'recordid');
|
||
|
|
|
||
|
|
// This is the list of vtiger_fields that are in the lists.
|
||
|
|
var $list_fields = Array(
|
||
|
|
'Module'=>Array('vtiger_audit_trial'=>'module'),
|
||
|
|
'Action'=>Array('vtiger_audit_trial'=>'action'),
|
||
|
|
'Record'=>Array('vtiger_audit_trial'=>'recordid'),
|
||
|
|
'Action Date'=>Array('vtiger_audit_trial'=>'actiondate'),
|
||
|
|
);
|
||
|
|
|
||
|
|
var $list_fields_name = Array(
|
||
|
|
'Module'=>'module',
|
||
|
|
'Action'=>'action',
|
||
|
|
'Record'=>'recordid',
|
||
|
|
'Action Date'=>'actiondate',
|
||
|
|
);
|
||
|
|
|
||
|
|
var $default_order_by = "actiondate";
|
||
|
|
var $default_sort_order = 'DESC';
|
||
|
|
/**
|
||
|
|
* Function to get the Headers of Audit Trail Information like Module, Action, RecordID, ActionDate.
|
||
|
|
* Returns Header Values like Module, Action etc in an array format.
|
||
|
|
**/
|
||
|
|
|
||
|
|
function getAuditTrailHeader()
|
||
|
|
{
|
||
|
|
global $log;
|
||
|
|
$log->debug("Entering getAuditTrailHeader() method ...");
|
||
|
|
global $app_strings;
|
||
|
|
|
||
|
|
$header_array = array($app_strings['LBL_MODULE'], $app_strings['LBL_ACTION'], $app_strings['LBL_RECORD_ID'], $app_strings['LBL_ACTION_DATE']);
|
||
|
|
|
||
|
|
$log->debug("Exiting getAuditTrailHeader() method ...");
|
||
|
|
return $header_array;
|
||
|
|
|
||
|
|
}
|
||
|
|
|
||
|
|
/**
|
||
|
|
* Function to get the Audit Trail Information values of the actions performed by a particular User.
|
||
|
|
* @param integer $userid - User's ID
|
||
|
|
* @param $navigation_array - Array values to navigate through the number of entries.
|
||
|
|
* @param $sortorder - DESC
|
||
|
|
* @param $orderby - actiondate
|
||
|
|
* Returns the audit trail entries in an array format.
|
||
|
|
**/
|
||
|
|
function getAuditTrailEntries($userid, $navigation_array, $sorder='', $orderby='')
|
||
|
|
{
|
||
|
|
global $log;
|
||
|
|
$log->debug("Entering getAuditTrailEntries(".$userid.") method ...");
|
||
|
|
global $adb, $current_user;
|
||
|
|
|
||
|
|
if($sorder != '' && $order_by != '')
|
||
|
|
$list_query = "Select * from vtiger_audit_trial where userid =? order by ".$order_by." ".$sorder;
|
||
|
|
else
|
||
|
|
$list_query = "Select * from vtiger_audit_trial where userid =? order by ".$this->default_order_by." ".$this->default_sort_order;
|
||
|
|
|
||
|
|
$result = $adb->pquery($list_query, array($userid));
|
||
|
|
$entries_list = array();
|
||
|
|
|
||
|
|
if($navigation_array['end_val'] != 0)
|
||
|
|
{
|
||
|
|
for($i = $navigation_array['start']; $i <= $navigation_array['end_val']; $i++)
|
||
|
|
{
|
||
|
|
$entries = array();
|
||
|
|
$userid = $adb->query_result($result, $i-1, 'userid');
|
||
|
|
|
||
|
|
$entries[] = getTranslatedString($adb->query_result($result, $i-1, 'module'));
|
||
|
|
$entries[] = $adb->query_result($result, $i-1, 'action');
|
||
|
|
$entries[] = $adb->query_result($result, $i-1, 'recordid');
|
||
|
|
$date = new DateTimeField($adb->query_result($result, $i-1, 'actiondate'));
|
||
|
|
$entries[] = $date->getDBInsertDateValue();
|
||
|
|
|
||
|
|
$entries_list[] = $entries;
|
||
|
|
}
|
||
|
|
$log->debug("Exiting getAuditTrailEntries() method ...");
|
||
|
|
return $entries_list;
|
||
|
|
}
|
||
|
|
}
|
||
|
|
}
|
||
|
|
|
||
|
|
|
||
|
|
?>
|