/**
* post process to determine if the parent job.
* as well as the mailing is complete after the run
* @param null $mode
*/
public static function runJobs_post($mode = NULL)
{
$job = new CRM_Mailing_BAO_MailingJob();
$mailing = new CRM_Mailing_BAO_Mailing();
$config = CRM_Core_Config::singleton();
$jobTable = CRM_Mailing_DAO_MailingJob::getTableName();
$mailingTable = CRM_Mailing_DAO_Mailing::getTableName();
$currentTime = date('YmdHis');
$mailingACL = CRM_Mailing_BAO_Mailing::mailingACL('m');
$domainID = CRM_Core_Config::domainID();
$query = "\n SELECT j.*\n FROM {$jobTable} j,\n {$mailingTable} m\n WHERE m.id = j.mailing_id AND m.domain_id = {$domainID}\n AND j.is_test = 0\n AND j.scheduled_date <= {$currentTime}\n AND j.status = 'Running'\n AND j.end_date IS null\n AND (j.job_type != 'child' OR j.job_type is NULL)\n ORDER BY j.scheduled_date,\n j.start_date";
$job->query($query);
// For each parent job that is running, let's look at their child jobs
while ($job->fetch()) {
$child_job = new CRM_Mailing_BAO_MailingJob();
$child_job_sql = "\n SELECT count(j.id)\n FROM civicrm_mailing_job j, civicrm_mailing m\n WHERE m.id = j.mailing_id\n AND j.job_type = 'child'\n AND j.parent_id = %1\n AND j.status <> 'Complete'";
$params = array(1 => array($job->id, 'Integer'));
$anyChildLeft = CRM_Core_DAO::singleValueQuery($child_job_sql, $params);
// all of the child jobs are complete, update
// the parent job as well as the mailing status
if (!$anyChildLeft) {
$transaction = new CRM_Core_Transaction();
$saveJob = new CRM_Mailing_DAO_MailingJob();
$saveJob->id = $job->id;
$saveJob->end_date = date('YmdHis');
$saveJob->status = 'Complete';
$saveJob->save();
$mailing->reset();
$mailing->id = $job->mailing_id;
$mailing->is_completed = TRUE;
$mailing->save();
$transaction->commit();
}
}
}
