function _getListingSidCollectionFromRequest() { $listing = new SJB_Listing(array(), $this->listing_type_sid); $id_alias_info = $listing->addIDProperty(); $listing->addActivationDateProperty(); $listing->addFeaturedProperty(); $listing->addFeaturedLastShowedProperty(); $username_alias_info = $listing->addUsernameProperty(); $listing_type_id_info = $listing->addListingTypeIDProperty(); $listing->addCompanyNameProperty(); // select only accessible listings by user sid // see SearchCriterion.php, AccessibleCriterion class if ($this->listing_type_id == 'Resume') { $this->requested_data['access_type'] = array('accessible' => SJB_UserManager::getCurrentUserSID()); } $criteria = $this->criteria_saver->getCriteria(); if (isset($this->requested_data['PostedWithin']['multi_like'][0]) || isset($criteria['PostedWithin']['multi_like'][0])) { $within_period = ''; if (isset($this->requested_data['PostedWithin']['multi_like'][0])) { $within_period = $this->requested_data['PostedWithin']['multi_like'][0]; unset($this->requested_data['PostedWithin']['multi_like']); } if (isset($criteria['PostedWithin']['multi_like'][0])) { $within_period = $criteria['PostedWithin']['multi_like'][0]; unset($criteria['PostedWithin']); } $i18n = SJB_I18N::getInstance(); $this->requested_data['activation_date']['not_less'] = $i18n->getDate(date('Y-m-d', strtotime("- {$within_period} days"))); } if (isset($this->requested_data['CompanyName']['multi_like_and'][0]) || isset($criteria['CompanyName']['multi_like_and'][0])) { if (isset($this->requested_data['CompanyName']['multi_like_and'][0])) { $companyName = $this->requested_data['CompanyName']['multi_like_and'][0]; unset($this->requested_data['CompanyName']); } if (isset($criteria['CompanyName']['multi_like_and'][0])) { $companyName = $criteria['CompanyName']['multi_like_and'][0]; unset($criteria['CompanyName']); } $userName = SJB_UserManager::getUserNameByCompanyName($companyName); if ($userName) { $this->requested_data['username']['equal'] = $userName; } } $criteria = SJB_SearchFormBuilder::extractCriteriaFromRequestData(array_merge($criteria, $this->requested_data), $listing); $aliases = new SJB_PropertyAliases(); $aliases->addAlias($id_alias_info); $aliases->addAlias($username_alias_info); $aliases->addAlias($listing_type_id_info); $sortingFields = array(); if ($this->usePriority) { $sortingFields['priority'] = 'DESC'; } $innerJoin = array(); $orderInfo = $this->criteria_saver->getOrderInfo(); if (is_array($orderInfo['sorting_field'])) { $requestedSortingField = array(); foreach ($orderInfo['sorting_field'] as $orderInfoProperty) { $fieldName = strstr($orderInfoProperty, '_', true); $id = $this->getLocationProperty($fieldName, $listing, $orderInfoProperty); if (!empty($id)) { switch ($orderInfoProperty) { case 'Location_State': $innerJoin['states'] = array('stateName' => '`states`.`state_code`', 'join' => 'LEFT JOIN', 'join_field' => 'sid', 'join_field2' => $orderInfoProperty, 'main_table' => 'listings'); break; case 'Location_Country': $innerJoin['countries'] = array('countryName' => '`countries`.`country_name`', 'join' => 'LEFT JOIN', 'join_field' => 'sid', 'join_field2' => $orderInfoProperty, 'main_table' => 'listings'); break; default: break; } $sortingFields[$orderInfoProperty] = $orderInfo['sorting_order']; $requestedSortingField[] = $orderInfoProperty; } $this->requested_data['sorting_field'] = $requestedSortingField; $this->requested_data['sorting_order'] = $orderInfo['sorting_order']; } } else { $property = $listing->getProperty($orderInfo['sorting_field']); if (!empty($property) && $property->isSystem()) { $sortingFields[$orderInfo['sorting_field']] = $orderInfo['sorting_order']; if ($property->getID() == 'CompanyName') { $innerJoin['users'] = array('join' => 'INNER JOIN', 'join_field' => 'sid', 'join_field2' => 'user_sid', 'main_table' => 'listings'); } $this->requested_data['sorting_field'] = $orderInfo['sorting_field']; $this->requested_data['sorting_order'] = $orderInfo['sorting_order']; } else { $sortingFields['activation_date'] = 'DESC'; $this->requested_data['sorting_field'] = 'activation_date'; $this->requested_data['sorting_order'] = 'DESC'; } } $searcher = new SJB_ListingSearcher(); if ($this->listingsLimit) { $searcher->setLimit($this->listingsLimit); } $this->listing_search_structure['sorting_field'] = $this->requested_data['sorting_field']; $this->listing_search_structure['sorting_order'] = $this->requested_data['sorting_order']; return $searcher->getObjectsSIDsByCriteria($criteria, $aliases, $sortingFields, $innerJoin, $this->relevance); }
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']; } } }