Application->getModule('configuration'); $appCfg = $cfg->getApplicationConfig(); if($cfg->isPostgreSQLType($appCfg['db']['type'])) { $order = strtolower($order); } $criteria->OrdersBy[$order] = 'desc'; if(is_int($limit) && $limit > 0) { $criteria->Limit = $limit; } return JobRecord::finder()->findAll($criteria); } public function getJobById($id) { return JobRecord::finder()->findByjobid($id); } public function getJobByName($name) { return JobRecord::finder()->findByname($name); } public function deleteJobById($id) { return JobRecord::finder()->deleteByjobid($id); } public function getRecentJobids($jobname, $clientid) { $sql = "name='$jobname' AND clientid='$clientid' AND jobstatus IN ('T', 'W') AND level IN ('F', 'I', 'D') ORDER BY endtime DESC"; $finder = JobRecord::finder(); $jobs = $finder->findAll($sql); $jobids = array(); $waitForFull = false; if(!is_null($jobs)) { foreach($jobs as $job) { if($job->level == 'F') { $jobids[] = $job->jobid; break; } elseif($job->level == 'D' && $waitForFull === false) { $jobids[] = $job->jobid; $waitForFull = true; } elseif($job->level == 'I' && $waitForFull === false) { $jobids[] = $job->jobid; } } } return $jobids; } } ?>