private function sendSearchedNotifications()
{
$savedSearches = SJB_SavedSearches::getAutoNotifySavedSearches();
$listing = new SJB_Listing();
$this->notifiedSavedSearchesSID = array();
$notificationsLimit = (int) SJB_Settings::getSettingByName('num_of_listings_sent_in_email_alerts');
foreach ($savedSearches as $savedSearch) {
$searcher = new SJB_ListingSearcher();
$listing->addActivationDateProperty();
$dataSearch = unserialize($savedSearch['data']);
$dataSearch['active']['equal'] = 1;
$dateArray = explode('-', $savedSearch['last_send']);
$savedSearch['last_send'] = strftime($this->lang['date_format'], mktime(0, 0, 0, $dateArray[1], $dateArray[2], $dateArray[0]));
$dataSearch['activation_date']['not_less'] = $savedSearch['last_send'];
$dataSearch['activation_date']['not_more'] = $this->currentDate;
$listingTypeSID = 0;
if ($dataSearch['listing_type']['equal']) {
$listingTypeID = $dataSearch['listing_type']['equal'];
$listingTypeSID = SJB_ListingTypeManager::getListingTypeSIDByID($listingTypeID);
if (SJB_ListingTypeManager::getWaitApproveSettingByListingType($listingTypeSID)) {
$dataSearch['status']['equal'] = 'approved';
}
}
$idAliasInfo = $listing->addIDProperty();
$usernameAliasInfo = $listing->addUsernameProperty();
$listingTypeIDInfo = $listing->addListingTypeIDProperty();
$aliases = new SJB_PropertyAliases();
$aliases->addAlias($idAliasInfo);
$aliases->addAlias($usernameAliasInfo);
$aliases->addAlias($listingTypeIDInfo);
$dataSearch['access_type'] = array('accessible' => $savedSearch['user_sid']);
$criteria = SJB_SearchFormBuilder::extractCriteriaFromRequestData($dataSearch, $listing);
$searcher->found_object_sids = array();
$searcher->setLimit($notificationsLimit);
$foundListingsIDs = $searcher->getObjectsSIDsByCriteria($criteria, $aliases);
if (count($foundListingsIDs)) {
$savedSearch['activation_date'] = $savedSearch['last_send'];
if (SJB_Notifications::sendUserNewListingsFoundLetter($foundListingsIDs, $savedSearch['user_sid'], $savedSearch, $listingTypeSID)) {
SJB_Statistics::addStatistics('sentAlert', $listingTypeSID, $savedSearch['sid']);
SJB_DB::query('UPDATE `saved_searches` SET `last_send` = CURDATE() WHERE `sid` = ?n', $savedSearch['sid']);
}
$this->notifiedSavedSearchesSID[] = $savedSearch['sid'];
}
}
}
