|
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/public_html/crm/modules/com_vtiger_workflow/ |
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.
************************************************************************************/
/**
* Time based Queue of tasks ready for execution.
*
*/
class VTTaskQueue{
public function __construct($adb){
$this->adb = $adb;
}
/**
* Queue a task for execution.
*
* @param $taskId The id of the task to queue
* @param $entityId The id of the crm entity the task is assiciated with.
* @param $when The time after which the task should be executed. This is
* an optional value with a default value of 0.
*/
public function queueTask($taskId, $entityId, $when=0, $taskContents = false, $relatedInfo = array()){
$adb = $this->adb;
//Mention all related info for the given $entityId
$relatedInfo = json_encode($relatedInfo);
if ($entityId) {
$adb->pquery('INSERT INTO com_vtiger_workflowtask_queue (task_id, entity_id, do_after, task_contents,relatedinfo) VALUES(?, ?, ?, ?,?)', array($taskId, $entityId, $when, $taskContents, $relatedInfo));
}
return true;
}
/**
* Get a list of taskId/entityId pairs ready for execution.
*
* The method fetches task id/entity id where the when timestamp
* is less than the current time when the method was called.
*
* @return A list of pairs of the form array(taskId, entityId)
*/
public function getReadyTasks(){
$adb = $this->adb;
$time = time();
$result = $adb->pquery('SELECT task_id, entity_id, task_contents,relatedinfo FROM com_vtiger_workflowtask_queue WHERE do_after<?', array($time));
$it = new SqlResultIterator($adb, $result);
$arr = array();
foreach($it as $row){
if($this->checkEntityExists($row->entity_id)) {
$arr[]=array($row->task_id, $row->entity_id, $row->task_contents,$row->relatedinfo);
}
}
$adb->pquery("delete from com_vtiger_workflowtask_queue where do_after<?", array($time));
return $arr;
}
public function checkEntityExists($id) {
$idParts = explode('x', $id);
$recordId = $idParts[1];
$status = Vtiger_Util_Helper::checkRecordExistance($recordId);
if ($status == 0) {
$db = PearDatabase::getInstance();
$webServiceObject = VtigerWebserviceObject::fromId($db, $idParts[0]);
if ($webServiceObject->getEntityName() == 'Leads' && isLeadConverted($recordId)) {
return false;
}
return true;
}
return false;
}
}
?>