public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$listingTypeSID = 0;
$listingTypeID = 0;
if (isset($_REQUEST['passed_parameters_via_uri'])) {
$params = SJB_FixedUrlParamProvider::getParams($_REQUEST);
if ($params) {
$listingTypeID = array_pop($params);
$listingTypeSID = SJB_ListingTypeManager::getListingTypeSIDByID($listingTypeID);
}
}
if (!$listingTypeSID) {
$errors['WRONG_LISTING_TYPE_ID_SPECIFIED'] = true;
}
$listing = new SJB_Listing(array(), $listingTypeSID);
$listing->addIDProperty();
$listing->addActivationDateProperty();
$listing->addUsernameProperty();
$listing->addKeywordsProperty();
$listing->addPicturesProperty();
$listing->addListingTypeIDProperty();
$listing->addPostedWithinProperty();
$search_form_builder = new SJB_SearchFormBuilder($listing);
$search_form_builder->registerTags($tp);
$form_fields = $search_form_builder->getFormFieldsInfo();
$tp->assign('form_fields', $form_fields);
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_SEARCH, $listingTypeID);
$formBuilder->setChargedTemplateProcessor($tp);
$tp->assign('listingTypeInfo', SJB_ListingTypeManager::getListingTypeInfoBySID($listingTypeSID));
$tp->assign('builderMode', true);
$tp->assign('currentTheme', SJB_TemplateSupplier::getUserCurrentTheme());
SJB_System::getTemplateProcessor();
$tp->display('bf_searchform.tpl');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
if (SJB_UserManager::isUserLoggedIn()) {
$current_user = SJB_UserManager::getCurrentUser();
if ($current_user->isSubuser()) {
// У саб-юзера должны быть свои алерты
$current_user = $current_user->getSubuserInfo();
} else {
$current_user = SJB_UserManager::getCurrentUserInfo();
}
$listing_type_id = '';
/************************************************************/
$tp = SJB_System::getTemplateProcessor();
$tp->assign('action', 'list');
$errors = array();
$redirectUri = '/saved-searches/';
if (isset($_REQUEST['is_alert'])) {
if (isset($_REQUEST['listing_type_id'])) {
$listing_type_id = $_REQUEST['listing_type_id'];
SJB_Session::setValue('listing_type_id', $listing_type_id);
} elseif (isset($_REQUEST['restore'])) {
$listing_type_id = SJB_Session::getValue('listing_type_id');
} else {
SJB_Session::setValue('listing_type_id', null);
}
if (!SJB_Acl::getInstance()->isAllowed("use_{$listing_type_id}_alerts")) {
$errors = array('NOT_SUBSCRIBE' => true);
$tp->assign('ERRORS', $errors);
$tp->display('error.tpl');
return;
} else {
$redirectUri = '/' . strtolower($listing_type_id) . '-alerts/';
}
} else {
if (isset($_REQUEST['listing_type_id'])) {
$listing_type_id = $_REQUEST['listing_type_id'];
}
if (!SJB_Acl::getInstance()->isAllowed('save_searches')) {
$errors = array('NOT_SUBSCRIBE' => true);
$tp->assign('ERRORS', $errors);
$tp->display('error.tpl');
return;
}
}
$isSubmittedForm = SJB_Request::getVar('submit', false);
$listing_type_sid = !empty($listing_type_id) ? SJB_ListingTypeManager::getListingTypeSIDByID($listing_type_id) : 0;
if (!isset($_REQUEST['listing_type']['equal']) && isset($listing_type_id)) {
$_REQUEST['listing_type']['equal'] = $listing_type_id;
}
$action = SJB_Request::getVar('action', 'list');
switch ($action) {
case 'save':
if ($isSubmittedForm) {
$search_name = SJB_Request::getVar('name');
$emailFrequency = SJB_Request::getVar('email_frequency');
if (empty($search_name['equal'])) {
$errors['EMPTY_VALUE'] = 1;
$tp->assign('action', 'save');
} else {
unset($_REQUEST['name']);
unset($_REQUEST['email_frequency']);
if ($emailFrequency) {
$emailFrequency = array_pop($emailFrequency);
$emailFrequency = '&email_frequency=' . array_pop($emailFrequency);
} else {
$emailFrequency = '';
}
$search_name = $search_name['equal'];
$searchResultsTP = new SJB_SearchResultsTP($_REQUEST, $listing_type_id);
$tp = $searchResultsTP->getChargedTemplateProcessor();
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/save-search/?alert=true&url=' . $redirectUri . '&action=save&search_name=' . $search_name . '&searchId=' . $searchResultsTP->searchId . $emailFrequency);
}
} else {
$tp->assign('action', 'save');
}
break;
case 'edit':
if (isset($_REQUEST['id_saved'])) {
if ($isSubmittedForm) {
$id_saved = $_REQUEST['id_saved'];
$name = $_REQUEST['name'];
$search_name = SJB_Request::getVar('name');
$emailFrequency = SJB_Request::getVar('email_frequency');
if (empty($search_name['equal'])) {
$errors['EMPTY_VALUE'] = 1;
} else {
unset($_REQUEST['name']);
unset($_REQUEST['email_frequency']);
if ($emailFrequency) {
$emailFrequency = array_pop($emailFrequency);
$emailFrequency = array_pop($emailFrequency);
} else {
$emailFrequency = 'daily';
}
$searchResultsTP = new SJB_SearchResultsTP($_REQUEST, $listing_type_id);
$tp = $searchResultsTP->getChargedTemplateProcessor();
$criteria_saver = new SJB_ListingCriteriaSaver($searchResultsTP->searchId);
$requested_data = $criteria_saver->getCriteria();
SJB_SavedSearches::updateSearchOnDB($requested_data, $id_saved, $current_user['sid'], $name['equal'], $emailFrequency);
}
if (!empty($errors)) {
$tp->assign('action', 'edit');
$tp->assign('id_saved', $_REQUEST['id_saved']);
} else {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . $redirectUri . '?alert=is_update');
}
} else {
$tp->assign('action', 'edit');
$tp->assign('id_saved', $_REQUEST['id_saved']);
}
}
break;
case 'edit_alert':
$tp->assign('action', 'edit');
$tp->assign('id_saved', $_REQUEST['id_saved']);
break;
case 'edit_search':
$tp->assign('action', 'edit');
$tp->assign('id_saved', $_REQUEST['id_saved']);
$_REQUEST['form_template'] = SJB_Request::getVar('formTemplateNem');
break;
case 'new':
$tp->assign('action', 'save');
break;
case 'delete':
if (isset($_REQUEST['search_id'])) {
$search_id = $_REQUEST['search_id'];
SJB_SavedSearches::deleteSearchFromDBBySID($search_id);
}
break;
case 'disable_notify':
if (isset($_REQUEST['search_id'])) {
SJB_SavedSearches::disableSearchAutoNotify($current_user['sid'], $_REQUEST['search_id']);
}
break;
case 'enable_notify':
if (isset($_REQUEST['search_id'])) {
SJB_SavedSearches::enableSearchAutoNotify($current_user['sid'], $_REQUEST['search_id']);
}
break;
}
if ($action != 'new' && $action != 'edit_alert') {
$saved_searches = SJB_SavedSearches::getSavedSearchesFromDB($current_user['sid']);
if (isset($_REQUEST['is_alert'])) {
$saved_searches = SJB_SavedSearches::getSavedJobAlertFromDB($current_user['sid']);
}
foreach ($saved_searches as $key => $saved_search) {
$saved_searches[$key]['data'] = SJB_SavedSearches::buildCriteriaFields($saved_search['data']);
if (isset($saved_search['data']['listing_type']['equal'])) {
$saved_searches[$key]['listing_type'] = $saved_search['data']['listing_type']['equal'];
}
}
$tp->assign('saved_searches', $saved_searches);
}
$listing = new SJB_Listing(array(), $listing_type_sid);
$listing->addIDProperty();
$listing->addActivationDateProperty();
$listing->addUsernameProperty();
$listing->addKeywordsProperty();
$listing->addPicturesProperty();
$listing->addEmailFrequencyProperty();
$listing->addListingTypeIDProperty();
$listing->addPostedWithinProperty();
$search_form_builder = new SJB_SearchFormBuilder($listing);
$criteria = SJB_SearchFormBuilder::extractCriteriaFromRequestData($_REQUEST);
$search_form_builder->setCriteria($criteria);
$search_form_builder->registerTags($tp);
$form_fields = $search_form_builder->getFormFieldsInfo();
$tp->assign('form_fields', $form_fields);
if (!empty($_REQUEST['name'])) {
$tp->assign('search_name', $_REQUEST['name']);
}
if (!empty($_REQUEST['email_frequency'])) {
$tp->assign('email_frequency', $_REQUEST['email_frequency']);
}
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$form_template = SJB_Request::getVar('form_template', 'search_form.tpl');
switch (SJB_Request::getVar('alert')) {
case 'added':
$tp->assign('alert_added', 'added');
break;
case 'is_update':
$tp->assign('alert_update', 'update');
break;
}
if (!$listing_type_id && isset($saved_search['data']['listing_type']['equal'])) {
$listing_type_id = $saved_search['data']['listing_type']['equal'];
}
$tp->assign('errors', $errors);
$tp->assign('user_logged_in', true);
$tp->assign('listing_type_id', $listing_type_id);
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_SEARCH, $listing_type_id);
$formBuilder->setChargedTemplateProcessor($tp);
$tp->display($form_template);
} else {
$tp->assign("ERROR", "NOT_LOGIN");
$tp->display("../miscellaneous/error.tpl");
return;
}
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
if (isset($_REQUEST['listing_type_id'])) {
$listing_type_id = $_REQUEST['listing_type_id'];
SJB_Session::setValue('listing_type_id', $listing_type_id);
} elseif (isset($_REQUEST['restore'])) {
$listing_type_id = SJB_Session::getValue('listing_type_id');
} else {
SJB_Session::setValue('listing_type_id', null);
}
$listing_type_sid = 0;
if (!empty($listing_type_id)) {
$listing_type_sid = SJB_ListingTypeManager::getListingTypeSIDByID($listing_type_id);
}
if (!isset($_REQUEST['listing_type']['equal']) && isset($listing_type_id)) {
$_REQUEST['listing_type']['equal'] = $listing_type_id;
}
if (isset($_REQUEST['searchId'])) {
$criteria_saver = new SJB_ListingCriteriaSaver($_REQUEST['searchId']);
$_REQUEST = array_merge($_REQUEST, $criteria_saver->getCriteria());
}
$empty_listing = new SJB_Listing(array(), $listing_type_sid);
$empty_listing->addIDProperty();
$empty_listing->addActivationDateProperty();
$empty_listing->addUsernameProperty();
$empty_listing->addKeywordsProperty();
$empty_listing->addPicturesProperty();
$empty_listing->addListingTypeIDProperty();
$empty_listing->addPostedWithinProperty();
$search_form_builder = new SJB_SearchFormBuilder($empty_listing);
$criteria = SJB_SearchFormBuilder::extractCriteriaFromRequestData($_REQUEST);
$properties = $empty_listing->getProperties();
foreach ($properties as $propertyName => $property) {
if ($property->getType() == 'location') {
$propertyInfo = $property->type->property_info;
if ($propertyInfo['enable_search_by_radius'] == 1) {
if (!isset($criteria['system'][$propertyName])) {
$value = array('value' => '', 'radius' => '10');
$criterion = SJB_SearchCriterion::getCriterionByType('location');
$criterion->setProperty($property);
$criterion->setPropertyName($propertyName);
$criterion->setValue($value);
$criteria['system'][$propertyName][] = $criterion;
}
}
}
}
$search_form_builder->setCriteria($criteria);
$search_form_builder->registerTags($tp);
$form_fields = $search_form_builder->getFormFieldsInfo();
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$template = SJB_Request::getVar('form_template', 'search_form.tpl');
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_SEARCH, $listing_type_id);
$formBuilder->setChargedTemplateProcessor($tp);
if ($template == 'quick_search.tpl') {
$fieldSID = SJB_ListingFieldManager::getListingFieldSIDByID('Location');
if ($fieldSID) {
$fields = SJB_ListingFieldManager::getFieldInfoBySID($fieldSID);
if (!empty($fields['fields'])) {
foreach ($fields['fields'] as $field) {
$form_fields[$fields['id'] . '_' . $field['id']] = $field;
}
}
$tp->assign('locationFields', array($fields));
}
}
$tp->assign('form_fields', $form_fields);
$tp->assign('METADATA', array('form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$tp->display($template);
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$template = SJB_Request::getVar('display_template');
$page = 1;
$searchId = strip_tags(SJB_Request::getVar('searchId', time()));
if (!empty($_REQUEST["page"])) {
$page = intval($_REQUEST["page"]);
}
$items_per_page = SJB_Request::getVar('companies_per_page', false);
$listing_type_sid = SJB_ListingTypeManager::getListingTypeSIDByID($_REQUEST["listing_type_id"]);
$alphabets = SJB_AlphabetManager::getAlphabetsForDisplay();
$abArr = array();
foreach ($alphabets as $alphabet) {
$abArr[] = explode(' ', $alphabet['value']);
}
$action = SJB_Request::getVar('action', 'search_form');
if (SJB_Request::getVar('first_char')) {
$action = 'search';
$_REQUEST['CompanyName']['first_char_like'] = SJB_Request::getVar('first_char');
} elseif (!isset($_REQUEST['CompanyName']) || $_REQUEST['CompanyName']['like'] == '') {
$_REQUEST['CompanyName']['not_empty'] = true;
}
$userGroupSid = SJB_UserGroupManager::getUserGroupSIDByID('Employer');
$userGroupFields = SJB_UserProfileFieldManager::getFieldsInfoByUserGroupSID($userGroupSid);
foreach ($userGroupFields as $key => $userGroupField) {
if ($userGroupField['type'] == 'location') {
$userGroupFields[$key]['fields'] = array();
$userGroupFields[$key]['fields'][$userGroupField['sid']] = $userGroupField;
}
}
$user = new SJB_User(array(), $userGroupSid);
$_REQUEST['active']['equal'] = 1;
$search_form_builder = new SJB_SearchFormBuilder($user);
$criteria_saver = new SJB_UserCriteriaSaver($searchId);
$criteria_saver->setSessionForOrderInfo($_REQUEST);
if (isset($_REQUEST['searchId'])) {
$action = 'search';
$criteria = $criteria_saver->getCriteria();
if (!empty($_REQUEST['sorting_field'])) {
unset($criteria['sorting_field']);
} else {
$orderInfo = $criteria_saver->getOrderInfo();
if (!empty($orderInfo['sorting_order'])) {
$criteria['sorting_order'] = $orderInfo['sorting_order'];
}
}
$_REQUEST = array_merge($_REQUEST, $criteria);
if (!$items_per_page) {
$items_per_page = $criteria_saver->listings_per_page;
}
}
$items_per_page = $items_per_page ? $items_per_page : 10;
$criteria = $search_form_builder->extractCriteriaFromRequestData(array_merge($_REQUEST, array('username' => array('not_equal' => 'jobg8'))), $user);
if ($items_per_page) {
$criteria_saver->setSessionForListingsPerPage($items_per_page);
}
$search_form_builder->setCriteria($criteria);
$search_form_builder->registerTags($tp);
$form_fields = $search_form_builder->getFormFieldsInfo();
$tp->assign('form_fields', $form_fields);
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$tp->assign('userGroupFields', $userGroupFields);
$tp->assign('action', $action);
$tp->assign('alphabets', $abArr);
if ($action == 'search') {
$sorting_field = SJB_Request::getVar('sorting_field', false);
$sorting_order = SJB_Request::getVar('sorting_order', false);
if (isset($_REQUEST['searchId']) && !$sorting_field) {
$order_info = $criteria_saver->order_info;
if ($order_info) {
$sorting_field = $order_info['sorting_field'];
$sorting_order = $order_info['sorting_order'];
}
}
if (!$sorting_field) {
$sorting_field = 'CompanyName';
$sorting_order = 'ASC';
}
$inner_join = array();
if ($sorting_field == 'number_of_jobs') {
if (SJB_ListingTypeManager::getWaitApproveSettingByListingType($listing_type_sid) == 1) {
$count = "sum( if( `listings`.`status` = 'approved', `listings`.`active`, 0 ) )";
} else {
$count = "sum(`listings`.`active`)";
}
$inner_join = array('listings' => array('sort_field' => $count, 'noPresix' => true, 'join_field' => 'user_sid', 'join_field2' => 'sid', 'join' => 'LEFT JOIN', 'groupBy' => '`users`.`sid`'));
} elseif ($sorting_field == 'Location_State') {
$inner_join = array('states' => array('sort_field' => 'state_name', 'noPresix' => true, 'join_field' => 'sid', 'join_field2' => 'Location_State', 'join' => 'LEFT JOIN'));
}
$searcher = new SJB_UserSearcher(false, $sorting_field, $sorting_order, $inner_join, array('limit' => ($page - 1) * $items_per_page, 'num_rows' => $items_per_page));
$found_users = array();
$found_users_sids = array();
$found_users_by_criteria = $searcher->getObjectsByCriteria($criteria, null, array(), true);
$foundObjectSIDs = $searcher->getFoundObjectSIDs();
// display search form
$tp->display($template);
$criteria_saver->setSession($_REQUEST, $foundObjectSIDs);
if (count($foundObjectSIDs) > 0) {
$listingType = SJB_ListingTypeManager::getListingTypeInfoBySID($listing_type_sid);
$countListings = SJB_ListingDBManager::getActiveAndApproveJobsNumberForUsers($foundObjectSIDs, $listingType);
}
foreach ($found_users_by_criteria as $id => $user) {
$listingsNumber = isset($countListings[$id]) ? $countListings[$id] : 0;
$user->addProperty(array('id' => 'countListings', 'type' => 'string', 'value' => $listingsNumber));
if ($user->getProperty('CompanyName')) {
$found_users_sids[$user->getSID()] = $user->getSID();
$found_users[$id] = $user;
}
}
$usersCount = $searcher->getAffectedRows();
$form_collection = new SJB_FormCollection($found_users);
$form_collection->registerTags($tp);
$pages = array();
for ($i = $page - 3; $i < $page + 3; $i++) {
if ($i > 0) {
$pages[] = $i;
}
if ($i * $items_per_page > $usersCount) {
break;
}
}
$totalPages = ceil($usersCount / $items_per_page);
if (empty($totalPages)) {
$totalPages = 1;
}
if (array_search(1, $pages) === false) {
array_unshift($pages, 1);
}
if (array_search($totalPages, $pages) === false) {
array_push($pages, $totalPages);
}
$tp->assign("sorting_order", $sorting_order);
$tp->assign("sorting_field", $sorting_field);
$tp->assign("found_users_sids", $found_users_sids);
$tp->assign("companies_per_page", $items_per_page);
$tp->assign("searchId", $searchId);
$tp->assign("usersCount", $usersCount);
$tp->assign("current_page", $page);
$tp->assign("pages_number", $totalPages);
$tp->display('search_result_company.tpl');
} else {
// display search form
$tp->display($template);
}
}
