public function sync()
{
$listingInfo = SJB_ListingManager::getListingInfoBySID($this->listingSID);
$oCurListing = SJB_ObjectMother::createListing($listingInfo, SJB_ListingTypeManager::getListingTypeSIDByID('Resume'));
$this->facebookSocialPlugin->fillObjectOutSocialData($oCurListing);
$oCurListing->setSID($this->listingSID);
SJB_ListingManager::saveListing($oCurListing);
}
public function execute()
{
$listingTypeSid = SJB_Request::getVar('listing_type_sid', false);
$template_processor = SJB_System::getTemplateProcessor();
if (isset($_REQUEST['restore']) && isset($listingSearcher['criteria_values']['listing_type_sid'])) {
$listingSearcher = SJB_Session::getValue('ListingSearcher', null);
$listingTypeSid = $listingSearcher['criteria_values']['listing_type_sid']['equal'];
}
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listingTypeSid);
$template_processor->assign('showApprovalStatusField', $listingTypeInfo['waitApprove']);
$template_processor->assign('listingsType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$show_search_form = true;
if (empty($_REQUEST['action']) && empty($_REQUEST['restore'])) {
$show_search_form = false;
}
$template_processor->assign('show_search_form', $show_search_form);
/**************** S E A R C H F O R M ****************/
$listing = SJB_ObjectMother::createListing(array(), $listingTypeSid);
$id_alias_info = $listing->addIDProperty();
$username_alias_info = $listing->addUsernameProperty();
$productAliasInfo = $listing->addProductProperty($listingTypeSid);
$listing->addCompanyNameProperty();
$listing->addActivationDateProperty();
$listing->addExpirationDateProperty();
$listing->addActiveProperty();
$listing->addKeywordsProperty();
$listing->addDataSourceProperty();
$listing->addPriorityProperty();
$aliases = new SJB_PropertyAliases();
$aliases->addAlias($username_alias_info);
$aliases->addAlias($id_alias_info);
$aliases->addAlias($productAliasInfo);
$search_form_builder = new SJB_SearchFormBuilder($listing);
$criteria_saver = SJB_ObjectMother::createListingCriteriaSaver();
$keywords = NULL;
if (isset($_REQUEST['restore'])) {
$_REQUEST = array_merge($_REQUEST, $criteria_saver->getCriteria());
$criteria = $criteria_saver->getCriteria();
$listingSid = SJB_Array::getPath($criteria, 'sid') ? $criteria['sid']['equal'] : '';
$keywords = SJB_Array::getPath($criteria, 'keywords') ? $criteria['keywords']['like'] : $listingSid;
}
if ($listingTypeSid) {
$_REQUEST['listing_type_sid'] = array('equal' => $listingTypeSid);
}
$template_processor->assign('companyName', isset($_REQUEST['company_name']['like']) ? $_REQUEST['company_name']['like'] : '');
$template_processor->assign('idKeyword', isset($_REQUEST['idKeyword']) ? $_REQUEST['idKeyword'] : $keywords);
$this->prepareRequestedCriteria();
$criteria = SJB_SearchFormBuilder::extractCriteriaFromRequestData($_REQUEST, $listing);
$search_form_builder->setCriteria($criteria);
$search_form_builder->registerTags($template_processor);
$template_processor->display("manage_listings.tpl");
/************* S E A R C H F O R M R E S U L T S *************/
$paginator = new SJB_ListingPagination($listingTypeInfo);
$searcher = SJB_ObjectMother::createListingSearcher();
$inner_join = array();
if (SJB_Request::getVar('action', '') == 'search' || isset($_REQUEST['restore'])) {
if (!isset($_REQUEST['restore'])) {
$criteria_saver->resetSearchResultsDisplay();
}
if (isset($_REQUEST['company_name']['like']) && $_REQUEST['company_name']['like'] != '') {
$inner_join = array('users' => array('join_field' => 'sid', 'join_field2' => 'user_sid', 'main_table' => 'listings', 'join' => 'INNER JOIN'));
}
$foundListingsSIDs = $searcher->getObjectsSIDsByCriteria($criteria, $aliases, array(), $inner_join);
//get found listing sids
if (empty($foundListingsSIDs) && $paginator->currentPage != 1) {
if ($listingTypeInfo['id'] == 'Job' || $listingTypeInfo['id'] == 'Resume') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-' . strtolower($listingTypeInfo['id']) . 's/?page=1&restore=1');
} else {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-' . strtolower($listingTypeInfo['id']) . '-listings/?page=1&restore=1');
}
}
$criteria_saver->setSessionForListingsPerPage($paginator->itemsPerPage);
$criteria_saver->setSessionForCurrentPage($paginator->currentPage);
$criteria_saver->setSessionForCriteria($_REQUEST);
$orderInfo = array('sorting_field' => $paginator->sortingField, 'sorting_order' => $paginator->sortingOrder);
$criteria_saver->setSessionForOrderInfo($orderInfo);
} else {
$criteria_saver->resetSearchResultsDisplay();
return;
}
$criteria_saver->setSessionForObjectSIDs($foundListingsSIDs);
$listing_search_structure = $criteria_saver->createTemplateStructureForSearch();
/**************** S O R T I N G *****************/
$empty_listing = SJB_ObjectMother::createListing(array(), $listingTypeSid);
$empty_listing->addPicturesProperty();
$empty_listing->addIDProperty();
$empty_listing->addListingTypeIDProperty();
$empty_listing->addActivationDateProperty();
$empty_listing->addExpirationDateProperty();
$empty_listing->addUsernameProperty();
$empty_listing->addPicturesProperty();
$empty_listing->addNumberOfViewsProperty();
$empty_listing->addActiveProperty();
$empty_listing->addKeywordsProperty();
$empty_listing->addDataSourceProperty();
$listing->addRejectReasonProperty();
if ($empty_listing->propertyIsSet($listing_search_structure['sorting_field']) && !empty($foundListingsSIDs)) {
$sorting_field = $listing_search_structure['sorting_field'];
$sorting_order = $listing_search_structure['sorting_order'];
switch ($sorting_field) {
case 'username':
$ids = join(", ", $foundListingsSIDs);
$sql = "\tSELECT\t\tlistings.*\n\t\t\t\t\t\tFROM \t\tlistings\n\t\t\t\t\t\tLEFT JOIN\tusers on listings.user_sid = users.sid\n\t\t\t\t\t\tWHERE \t\tlistings.sid IN ({$ids})\n\t\t\t\t\t\tORDER BY users.username {$sorting_order}";
$listings_info = SJB_DB::query($sql);
break;
case 'listing_type':
$ids = join(", ", $foundListingsSIDs);
$sql = "\tSELECT\t\tlistings.*\n\t\t\t\t\t\tFROM \t\tlistings\n\t\t\t\t\t\tLEFT JOIN\tlisting_types on listings.listing_type_sid = listing_types.sid\n\t\t\t\t\t\tWHERE \t\tlistings.sid IN ({$ids})\n\t\t\t\t\t\tORDER BY listing_types.id {$sorting_order}";
$listings_info = SJB_DB::query($sql);
break;
case 'id':
$ids = join(", ", $foundListingsSIDs);
$sql = "\tSELECT\t\tlistings.*\n\t\t\t\t\t\tFROM \t\tlistings\n\t\t\t\t\t\tWHERE\t\tlistings.sid IN ({$ids})\n\t\t\t\t\t\tORDER BY sid {$sorting_order}";
$listings_info = SJB_DB::query($sql);
break;
default:
$property = $empty_listing->getProperty($sorting_field);
$listing_request_creator = new SJB_ListingRequestCreator($foundListingsSIDs, array('property' => $property, 'sorting_order' => $sorting_order));
$listings_info = SJB_DB::query($listing_request_creator->getRequest());
break;
}
$listings_sids = array();
foreach ($listings_info as $listing_info) {
$listings_sids[$listing_info['sid']] = $listing_info['sid'];
}
$sortedFoundListingsSIDs = array_keys($listings_sids);
$criteria_saver->setSessionForObjectSIDs($sortedFoundListingsSIDs);
} else {
$sortedFoundListingsSIDs = $foundListingsSIDs;
$criteria_saver->setSessionForObjectSIDs($foundListingsSIDs);
}
/**************** P A G I N G *****************/
$sortedFoundListingsSIDsByPages = array_chunk($sortedFoundListingsSIDs, $paginator->itemsPerPage, true);
$paginator->setItemsCount(count($sortedFoundListingsSIDs));
/************* S T R U C T U R E **************/
$listings_structure = array();
if (isset($sortedFoundListingsSIDsByPages[$paginator->currentPage - 1])) {
foreach ($sortedFoundListingsSIDsByPages[$paginator->currentPage - 1] as $sid) {
$listing = SJB_ListingManager::getObjectBySID($sid);
$listing->addPicturesProperty();
$listings_structure[$listing->getID()] = SJB_ListingManager::createTemplateStructureForListing($listing);
}
}
/*************** D I S P L A Y ****************/
$template_processor->assign("search_criteria", $criteria_saver->createTemplateStructureForCriteria());
$template_processor->assign('paginationInfo', $paginator->getPaginationInfo());
$template_processor->assign('listings', $listings_structure);
$template_processor->display('display_results.tpl');
}
/**
* @param SJB_User $user
* @return SJB_User
*/
public static function addListingFieldsIntoRegistration(SJB_User $user)
{
if (self::getProfileObject() && !empty(self::$aListingFields)) {
if ('JobSeeker' == SJB_Request::getVar(self::REQUEST_USER_GROUP_ID_KEY)) {
$listing_type_id = 'Resume';
$listing = SJB_ObjectMother::createListing($_REQUEST, SJB_ListingTypeManager::getListingTypeSIDByID($listing_type_id));
foreach (self::$aListingFields as $field) {
$user->addProperty($listing->getProperty($field));
}
}
}
return $user;
}
private function prepareTplVarsForListing()
{
$listingTypes = SJB_ListingTypeManager::getAllListingTypesInfo();
foreach ($listingTypes as &$listingType) {
$listing = SJB_ObjectMother::createListing(array(), $listingType['sid']);
$fields = SJB_ListingManager::createTemplateStructureForListing($listing);
unset($fields['METADATA']);
unset($fields['user']);
$listingType['fields'] = $this->echoVars($fields);
}
$this->tp->assign('listingTypes', $listingTypes);
}
