public static function sendJob($jobId)
{
global $db;
$job = new Job($jobId);
$subscribers = self::getCategorySubscribers($job->mCategoryId);
$postman = new Postman();
foreach ($subscribers as $subscriber) {
if (!empty($subscriber['keywords'])) {
$keywords = '/\\b(' . str_replace(',', '|', preg_quote($subscriber['keywords'])) . ')\\b/i';
if (!(preg_match($keywords, $job->mTitle) || preg_match($keywords, $job->mSummary) || preg_match($keywords, strip_tags($job->mDescription)))) {
continue;
}
}
$postman->MailSubscriptionJobPosted($subscriber['email'], $subscriber['auth'], $job);
$sql = 'INSERT INTO ' . DB_PREFIX . 'subscriber_mail_log (email, job_id, job_title, job_summary, date)
VALUES ("' . $subscriber['email'] . '", ' . $jobId . ', "' . $job->mTitle . '", "' . $job->mSummary . '", NOW())';
$db->Execute($sql);
}
}
