Beispiel #1
0
 protected function execJob($name, $data)
 {
     require_once 'include/SugarQueue/SugarJobQueue.php';
     $job = new SchedulersJob();
     $job->name = "Bug56573Test Alert Job - '{$name}'";
     $job->target = "class::Bug56573TestJob";
     $job->data = $data;
     $job->assigned_user_id = $GLOBALS['current_user']->id;
     // Add the Job the the job Queue
     $jq = new SugarJobQueue();
     $jq->submitJob($job);
     // Run the job
     $job->runJob();
     // Save id for cleaning
     $this->id = $job->id;
     return $job;
 }
function aorRunScheduledReports()
{
    require_once 'include/SugarQueue/SugarJobQueue.php';
    $date = new DateTime();
    //Ensure we check all schedules at the same instant
    foreach (BeanFactory::getBean('AOR_Scheduled_Reports')->get_full_list() as $scheduledReport) {
        if ($scheduledReport->shouldRun($date)) {
            if (empty($scheduledReport->aor_report_id)) {
                continue;
            }
            $job = new SchedulersJob();
            $job->name = "Scheduled report - {$scheduledReport->name} on {$date->format('c')}";
            $job->data = $scheduledReport->id;
            $job->target = "class::AORScheduledReportJob";
            $job->assigned_user_id = 1;
            $jq = new SugarJobQueue();
            $jq->submitJob($job);
        }
    }
}
Beispiel #3
0
 /**
  * handle creating or updating a currency record
  *
  */
 function handleAdd()
 {
     global $current_user;
     if ($current_user->is_admin) {
         if (isset($_POST['edit']) && $_POST['edit'] == 'true' && isset($_POST['name']) && !empty($_POST['name']) && isset($_POST['conversion_rate']) && !empty($_POST['conversion_rate']) && isset($_POST['symbol']) && !empty($_POST['symbol'])) {
             $currency = BeanFactory::getBean('Currencies');
             $isUpdate = false;
             if (isset($_POST['record']) && !empty($_POST['record'])) {
                 $isUpdate = true;
                 $currency->retrieve($_POST['record']);
             }
             $currency->name = $_POST['name'];
             $currency->status = $_POST['status'];
             $currency->symbol = $_POST['symbol'];
             $currency->iso4217 = $_POST['iso4217'];
             $previousConversionRate = $currency->conversion_rate;
             $currency->conversion_rate = (string) unformat_number($_POST['conversion_rate']);
             $currency->save();
             $this->focus = $currency;
             // Used to tell calling code that a change was made
             $this->recordSaved = true;
             //Check if the conversion rates changed and, if so, update the rates with a scheduler job
             if ($isUpdate && $previousConversionRate != $currency->conversion_rate) {
                 global $timedate;
                 // use bean factory here
                 $job = BeanFactory::getBean('SchedulersJobs');
                 $job->name = "SugarJobUpdateCurrencyRates: " . $timedate->getNow()->asDb();
                 $job->target = "class::SugarJobUpdateCurrencyRates";
                 $job->data = $currency->id;
                 $job->retry_count = 0;
                 $job->assigned_user_id = $current_user->id;
                 $jobQueue = new SugarJobQueue();
                 $jobQueue->submitJob($job);
             }
         }
     }
 }
 /**
  * @param array $data The data for the Job
  * @param bool $returnJob When `true` the job will be returned, otherwise the job id will be returned
  * @param string|null $job_group The Group that this job belongs to
  * @return SchedulersJob|String
  */
 public static function createJob(array $data, $returnJob = false, $job_group = null)
 {
     global $current_user;
     /* @var $job SchedulersJob */
     $job = BeanFactory::getBean('SchedulersJobs');
     $job->name = "Update Old Opportunities";
     $job->target = "class::SugarJobUpdateOpportunities";
     $job->data = json_encode($data);
     $job->retry_count = 0;
     $job->assigned_user_id = $current_user->id;
     if (!is_null($job_group)) {
         $job->job_group = $job_group;
     }
     require_once 'include/SugarQueue/SugarJobQueue.php';
     $job_queue = new SugarJobQueue();
     $job_queue->submitJob($job);
     if ($returnJob === true) {
         return $job;
     }
     return $job->id;
 }
 /**
  * Create a job for the backend to process records on.
  *
  * @param string $forecast_by
  * @param array $data
  * @param string $user_id
  */
 protected function createUpdateForecastWorksheetJob($forecast_by, array $data, $user_id)
 {
     /* @var $job SchedulersJob */
     $job = BeanFactory::getBean('SchedulersJobs');
     $job->name = "Update ForecastWorksheets";
     $job->target = "class::SugarJobUpdateForecastWorksheets";
     $job->data = json_encode(array('forecast_by' => $forecast_by, 'data' => $data));
     $job->retry_count = 0;
     $job->assigned_user_id = $user_id;
     require_once 'include/SugarQueue/SugarJobQueue.php';
     $jq = new SugarJobQueue();
     $jq->submitJob($job);
 }
Beispiel #6
0
 */
$modListHeader = array();
require_once 'modules/Reports/schedule/ReportSchedule.php';
require_once 'modules/Reports/utils.php';
require_once 'include/modules.php';
require_once 'config.php';
/** @var Localization $locale */
global $sugar_config, $current_language, $app_list_strings, $app_strings, $locale, $timedate;
$language = $sugar_config['default_language'];
// here we'd better use English, because pdf coding problem.
$app_list_strings = return_app_list_strings_language($language);
$app_strings = return_application_language($language);
$reportSchedule = new ReportSchedule();
$reportSchedule->handleFailedReports();
$reportsToEmail = $reportSchedule->get_reports_to_email();
//Process Enterprise Schedule reports via CSV
//bug: 23934 - enable Advanced reports
require_once 'modules/ReportMaker/process_scheduled.php';
global $report_modules, $modListHeader, $current_user;
$queue = new SugarJobQueue();
foreach ($reportsToEmail as $scheduleInfo) {
    $job = BeanFactory::getBean('SchedulersJobs');
    $job->name = 'Send Scheduled Report ' . $scheduleInfo['report_id'];
    $job->assigned_user_id = $scheduleInfo['user_id'];
    $job->target = 'class::SugarJobSendScheduledReport';
    $job->data = $scheduleInfo['id'];
    $job->job_group = $scheduleInfo['report_id'];
    $queue->submitJob($job);
}
sugar_cleanup(false);
// continue script execution so that if run from Scheduler, job status will be set back to "Active"
Beispiel #7
0
 /**
  * Helper for processing subscriptions on a bean-related activity.
  *
  * @param  SugarBean $bean
  * @param  Activity  $act
  * @param  array     $args
  * @param  array     $params
  */
 public static function processSubscriptions(SugarBean $bean, Activity $act, array $args, $params = array())
 {
     $userPartials = self::getSubscribedUsers($bean, 'array', $params);
     $data = array('act_id' => $act->id, 'args' => $args, 'user_partials' => $userPartials);
     if (count($userPartials) < 5) {
         self::addActivitySubscriptions($data);
     } else {
         $job = BeanFactory::getBean('SchedulersJobs');
         $job->requeue = 1;
         $job->name = "ActivityStream add";
         $job->data = serialize($data);
         $job->target = "class::SugarJobAddActivitySubscriptions";
         $job->assigned_user_id = $GLOBALS['current_user']->id;
         $queue = new SugarJobQueue();
         $queue->submitJob($job);
     }
 }
 /**
  * Create a job queue FTS consumer for a specific module
  *
  * @param string $module
  * @param bool   $runNow Run job immediately instead of placing in job queue
  * @return string Id of newly created job
  */
 public function createJobQueueConsumerForModule($module, $runNow = false)
 {
     $jobBean = BeanFactory::getBean('SchedulersJobs');
     $q = sprintf("SELECT name FROM %s\n             WHERE name = 'FTSConsumer %s' AND deleted = 0 AND status != '%s'", $jobBean->table_name, $module, SchedulersJob::JOB_STATUS_DONE);
     $res = $jobBean->db->query($q);
     if ($row = $GLOBALS['db']->fetchByAssoc($res)) {
         $GLOBALS['log']->info("Job queue already exists for: FTSConsumer {$module}");
         return;
     }
     $GLOBALS['log']->info("Creating FTS Job queue consumer for: {$module} ");
     $job = new SchedulersJob();
     $job->data = $module;
     $job->name = "FTSConsumer {$module}";
     $job->target = "class::SugarSearchEngineFullIndexer";
     $job->assigned_user_id = 1;
     if ($runNow) {
         $job->runJob();
     } else {
         $queue = new SugarJobQueue();
         $queue->submitJob($job);
     }
     return $job->id;
 }
Beispiel #9
0
 public function getJob($jobId)
 {
     return parent::getJob($jobId);
 }
 private function scheduleOpportunityRevenueLineItemNoteCreate(array $labels, array $chunk, $job_group)
 {
     /* @var $job SchedulersJob */
     $job = BeanFactory::getBean('SchedulersJobs');
     $job->name = "Create Revenue Line Items Note On Opportunities";
     $job->target = "class::SugarJobCreateRevenueLineItemNotes";
     $job->data = json_encode(array('chunk' => $chunk, 'labels' => $labels));
     $job->retry_count = 0;
     $job->assigned_user_id = $GLOBALS['current_user']->id;
     $job->job_group = $job_group;
     require_once 'include/SugarQueue/SugarJobQueue.php';
     $jq = new SugarJobQueue();
     $jq->submitJob($job);
 }
Beispiel #11
0
 public function submitJob($job)
 {
     $this->jobs[] = $job;
     parent::submitJob($job);
 }
 /**
  * Create a job for the Scheduler to create the RLI's for.
  *
  * @param array $data
  * @param string $job_group
  */
 protected function createRevenueLineItemJob(array $data, $job_group)
 {
     /* @var $job SchedulersJob */
     $job = BeanFactory::getBean('SchedulersJobs');
     $job->name = "Create RevenueLineItems for Opportunities";
     $job->target = "class::SugarJobCreateRevenueLineItems";
     $job->data = json_encode(array('data' => $data));
     $job->retry_count = 0;
     $job->assigned_user_id = $GLOBALS['current_user']->id;
     $job->job_group = $job_group;
     require_once 'include/SugarQueue/SugarJobQueue.php';
     $jq = new SugarJobQueue();
     $jq->submitJob($job);
 }
 /**
  * do post update process to update the opportunity RLIs, ENT only
  */
 public function doPostUpdateAction()
 {
     $sql = "SELECT opportunity_id               AS opp_id,\n                          Sum(likely_case)             AS likely,\n                          Sum(worst_case)              AS worst,\n                          Sum(best_case)               AS best\n                   FROM   (SELECT rli.opportunity_id,\n                                  (rli.likely_case/rli.base_rate) as likely_case,\n                                  (rli.worst_case/rli.base_rate) as worst_case,\n                                  (rli.best_case/rli.base_rate) as best_case\n                           FROM   revenue_line_items AS rli\n                           WHERE  rli.deleted = 0) AS T\n                   GROUP  BY opp_id";
     $results = $this->db->query($sql);
     $stages = $this->getClosedStages();
     $queries = array();
     // skip closed opps
     $sql_tpl = "UPDATE opportunities SET amount = '%s', best_case = '%s', worst_case = '%s' WHERE id = '%s' AND sales_status NOT IN ('%s')";
     while ($row = $this->db->fetchRow($results)) {
         $queries[] = sprintf($sql_tpl, $row['likely'], $row['best'], $row['worst'], $row['opp_id'], implode("','", $stages));
     }
     if (count($queries) < self::CHUNK_SIZE) {
         // do queries in this process
         foreach ($queries as $query) {
             $this->db->query($query);
         }
     } else {
         // schedule queries to SQLRunner job scheduler
         $chunks = array_chunk($queries, self::CHUNK_SIZE);
         global $timedate, $current_user;
         foreach ($chunks as $chunk) {
             $job = BeanFactory::getBean('SchedulersJobs');
             $job->name = "SugarJobSQLRunner: " . $timedate->getNow()->asDb();
             $job->target = "class::SugarJobSQLRunner";
             $job->data = serialize($chunk);
             $job->retry_count = 0;
             $job->assigned_user_id = $current_user->id;
             $jobQueue = new SugarJobQueue();
             $jobQueue->submitJob($job);
         }
     }
     return true;
 }
Beispiel #14
0
 /**
  * Checks if any jobs qualify to run at this moment
  * @param SugarJobQueue $queue
  */
 public function checkPendingJobs($queue)
 {
     $allSchedulers = $this->get_full_list('', "schedulers.status='Active' AND NOT EXISTS(SELECT id FROM {$this->job_queue_table} WHERE scheduler_id=schedulers.id AND status!='" . SchedulersJob::JOB_STATUS_DONE . "')");
     $GLOBALS['log']->info('-----> Scheduler found [ ' . count($allSchedulers) . ' ] ACTIVE jobs');
     if (!empty($allSchedulers)) {
         foreach ($allSchedulers as $focus) {
             if ($focus->fireQualified()) {
                 $job = $focus->createJob();
                 $queue->submitJob($job, $this->getUser());
             }
         }
     } else {
         $GLOBALS['log']->debug('----->No Schedulers found');
     }
 }
 /**
  * Create a job queue consumer for mass update
  *
  * @param Mixed $data job queue data
  * @param String $jobType job type - 'init' for parent job, 'work' for child job
  * @return String id of the created job
  */
 public function createJobQueueConsumer($data, $jobType = "init")
 {
     $job = new SchedulersJob();
     $job->name = 'MassUpdate_' . $jobType;
     $job->target = "class::SugarJobMassUpdate";
     $data['_jobType_'] = $jobType;
     $job->data = json_encode($data);
     $job->assigned_user_id = $GLOBALS['current_user']->id;
     $queue = new SugarJobQueue();
     $queue->submitJob($job);
     return $job->id;
 }
 /**
  * Run cleanup and schedule
  * @param string $session
  * @param string $clientid
  */
 public function job_queue_cycle($session, $clientid)
 {
     $GLOBALS['log']->info('Begin: SugarWebServiceImpl->job_queue_cycle');
     $error = new SoapError();
     if (!self::$helperObject->checkSessionAndModuleAccess($session, 'invalid_session', '', 'read', 'no_access', $error)) {
         $GLOBALS['log']->info('End: SugarWebServiceImpl->job_queue_cycle denied.');
         return;
     }
     require_once 'include/SugarQueue/SugarJobQueue.php';
     $queue = new SugarJobQueue();
     $queue->cleanup();
     $queue->runSchedulers();
     $GLOBALS['log']->info('End: SugarWebServiceImpl->job_queue_cycle');
     return array("results" => "ok");
 }
 /**
  * Create the job in the job_queue
  *
  * @param $data
  * @return String
  */
 public static function createJob($data)
 {
     global $current_user;
     //Create an entry in the job queue to run UpdateOppsJob which handles updating all opportunities
     /* @var $job SchedulersJob */
     $job = BeanFactory::getBean('SchedulersJobs');
     $job->name = "Resave All RevenueLineItems";
     $job->target = "class::SugarJobUpdateRevenueLineItems";
     $job->data = json_encode($data);
     $job->retry_count = 0;
     $job->assigned_user_id = $current_user->id;
     require_once 'include/SugarQueue/SugarJobQueue.php';
     $job_queue = new SugarJobQueue();
     return $job_queue->submitJob($job);
 }