outputFormatting = $enable ? true : false;
}
/**
* Get format for output status
*
* @return boolean
*/
public function getOutputFormatting()
{
return $this->outputFormatting;
}
public function prune()
{
$whmcs = WHMCS_Application::getinstance();
$activitylimit = (int) $whmcs->get_config('ActivityLimit');
$result = select_query('tblactivitylog', '', "userid=0", 'id', 'DESC', $activitylimit . ',9999');
while( $data = mysql_fetch_array($result) )
{
delete_query('tblactivitylog', array( 'id' => $data['id'] ));
}
return true;
}
public function setCriteria($where)
{
if( is_array($where) )
{
$this->criteria = $where;
return true;
}
return false;
}
public function getCriteria($key)
{
return array_key_exists($key, $this->criteria) ? $this->criteria[$key] : '';
}
protected function buildCriteria()
{
$userid = $this->getCriteria('userid');
$date = $this->getCriteria('date');
$description = $this->getCriteria('description');
$username = $this->getCriteria('username');
$ipaddress = $this->getCriteria('ipaddress');
$where = array( );
if( $userid )
{
$where[] = "userid='" . (int) $userid . "'";
}
if( $date )
{
$where[] = "date>'" . toMySQLDate($date) . "' AND date<='" . toMySQLDate($date) . "235959'";
}
if( $description )
{
$where[] = "description LIKE '%" . db_escape_string($description) . "%'";
}
if( $username )
{
$where[] = "user='" . db_escape_string($username) . "'";
}
if( $ipaddress )
{
$where[] = " ipaddr='" . db_escape_string($ipaddress) . "'";
}
return implode(" AND ", $where);
}
public function getTotalCount()
{
$result = select_query('tblactivitylog', "COUNT(id)", $this->buildCriteria());
$data = mysql_fetch_array($result);
return (int) $data[0];
}
public function getLogEntries($page = 0, $limit = 0)
{
$page = (int) $page;
$limit = (int) $limit;
if( !$limit )
{
$whmcs = WHMCS_Application::getinstance();
$limit = (int) $whmcs->get_config('NumRecordstoDisplay');
}
$logs = array( );
$result = select_query('tblactivitylog', '', $this->buildCriteria(), 'id', 'DESC', $page * $limit . ',' . $limit);
while( $data = mysql_fetch_array($result) )
{
$id = $data['id'];
$userid = $data['userid'];
$date = $data['date'];
$description = $data['description'];
$username = $data['user'];
$ipaddress = $data['ipaddr'];
if( $this->getOutputFormatting() )
{
$date = fromMySQLDate($date, true);
$description = WHMCS_Input_Sanitize::makesafeforoutput($description);
$username = WHMCS_Input_Sanitize::makesafeforoutput($username);
$ipaddress = WHMCS_Input_Sanitize::makesafeforoutput($ipaddress);
$description = $this->autoLink($description);
}
$logs[] = array( 'id' => (int) $id, 'userid' => (int) $userid, 'date' => $date, 'description' => $description, 'username' => $username, 'ipaddress' => $ipaddress );
}
return $logs;
}
protected function autoLink($description)
{
$patterns = $replacements = array( );
$patterns[] = "/User ID: (.*?) /";
$patterns[] = "/Service ID: (.*?) /";
$patterns[] = "/Domain ID: (.*?) /";
$patterns[] = "/Invoice ID: (.*?) /";
$patterns[] = "/Quote ID: (.*?) /";
$patterns[] = "/Order ID: (.*?) /";
$patterns[] = "/Transaction ID: (.*?) /";
$replacements[] = "User ID: \$1 ";
$replacements[] = "Service ID: \$1 ";
$replacements[] = "Domain ID: \$1 ";
$replacements[] = "Invoice ID: \$1 ";
$replacements[] = "Quote ID: \$1 ";
$replacements[] = "Order ID: \$1 ";
$replacements[] = "Transaction ID: \$1 ";
$description = preg_replace($patterns, $replacements, $description . " ");
return trim($description);
}
}