27 lines
1.1 KiB
PHP
27 lines
1.1 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 dirname(__FILE__) . '/PendingTicketsOfMine.php';
|
||
|
|
|
||
|
|
/** Idle Ticket Alert */
|
||
|
|
class Mobile_WS_AlertModel_IdleTicketsOfMine extends Mobile_WS_AlertModel_PendingTicketsOfMine {
|
||
|
|
function __construct() {
|
||
|
|
parent::__construct();
|
||
|
|
$this->name = 'Idle Ticket Alert';
|
||
|
|
$this->moduleName = 'HelpDesk';
|
||
|
|
$this->refreshRate= 1 * (60 * 60); // 1 hour
|
||
|
|
$this->description='Alert sent when ticket has not been updated in 24 hours';
|
||
|
|
}
|
||
|
|
|
||
|
|
function query() {
|
||
|
|
$sql = parent::query();
|
||
|
|
$sql .= " AND DATEDIFF(CURDATE(), vtiger_crmentity.modifiedtime) > 1";
|
||
|
|
return $sql;
|
||
|
|
}
|
||
|
|
}
|