public function execute()
{
$count_listing = SJB_Request::getVar('count_listing', 10);
$listings_structure = array();
$listing_structure_meta_data = array();
$tp = SJB_System::getTemplateProcessor();
if (SJB_UserManager::isUserLoggedIn()) {
$user_sid = SJB_UserManager::getCurrentUserSID();
$viewed_listings = SJB_UserManager::getRecentlyViewedListingsByUserSid($user_sid, $count_listing);
if (count($viewed_listings)) {
foreach ($viewed_listings as $viewed_listing) {
$listing = SJB_ListingManager::getObjectBySID($viewed_listing['listing_sid']);
if (empty($listing)) {
continue;
}
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
$listings_structure[] = $listing_structure;
if (isset($listing_structure['METADATA'])) {
$listing_structure_meta_data = array_merge($listing_structure_meta_data, $listing_structure['METADATA']);
}
}
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign("METADATA", array("listing" => $metaDataProvider->getMetaData($listing_structure_meta_data)));
$tp->assign("listings", $listings_structure);
}
$tp->display('recently_viewed_listings.tpl');
}
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$listingTypeID = SJB_Request::getVar('listing_type_id', '');
if (SJB_UserManager::isUserLoggedIn()) {
if (!SJB_Acl::getInstance()->isAllowed('save_' . trim($listingTypeID))) {
$errors[] = 'DENIED_VIEW_SAVED_LISTING';
}
if (!$errors) {
$userSid = SJB_UserManager::getCurrentUserSID();
if (SJB_Request::getVar('action', '') == 'delete') {
$listing_id = SJB_Request::getVar('listing_id', null);
if (!is_null($listing_id)) {
foreach ($listing_id as $key => $value) {
SJB_SavedListings::deleteListingFromDBBySID($key, $userSid);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . SJB_Navigator::getURI());
}
}
$saved_listings_id = SJB_SavedListings::getSavedListingsFromDB($userSid);
$listings_structure = array();
$listing_structure_meta_data = array();
foreach ($saved_listings_id as $saved_listing) {
$saved_listing_id = $saved_listing['listing_sid'];
$listing = SJB_ListingManager::getObjectBySID($saved_listing_id);
if (is_null($listing)) {
continue;
}
$listing->addPicturesProperty();
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
$listings_structure[$listing->getID()] = $listing_structure;
$listings_structure[$listing->getID()]['saved_listing'] = $saved_listing;
if (isset($listing_structure['METADATA'])) {
$listing_structure_meta_data = array_merge($listing_structure_meta_data, $listing_structure['METADATA']);
}
}
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign("METADATA", array("listing" => $metaDataProvider->getMetaData($listing_structure_meta_data)));
$tp->assign("listings", $listings_structure);
$tp->assign("listing_type_id", $listingTypeID);
$tp->display("saved_listings.tpl");
} else {
$tp->assign("errors", $errors);
$tp->display("save_search_failed.tpl");
}
} else {
$url = base64_encode(SJB_System::getSystemSettings("SITE_URL") . "/system/classifieds" . SJB_System::getURI());
switch ($listingTypeID) {
case 'job':
$url = base64_encode(SJB_System::getSystemSettings("SITE_URL") . "/saved-jobs/");
break;
case 'resume':
$url = base64_encode(SJB_System::getSystemSettings("SITE_URL") . "/saved-resumes/");
break;
}
$tp->assign("return_url", $url);
$tp->display("../users/login.tpl");
}
}
/**
* @param int $listingSID
* @return bool
*/
public function postListing($listingSID)
{
$linkedIn = new SJB_LinkedIn();
$linkedIn->_getAccessToken(unserialize($this->feedInfo['access_token']));
$listing = SJB_ListingManager::getObjectBySID($listingSID);
if (!$listing instanceof SJB_Listing) {
$params = array($listingSID);
$message = 'Listing #$param_0 does not exist in system';
throw new SJB_FeedException($message, $params);
}
$listingStructure = SJB_ListingManager::createTemplateStructureForListing($listing);
$link = SJB_ListingManager::getListingUrlBySID($listingSID);
$userInfo = SJB_Array::get($listingStructure, 'user');
$this->tp->assign('post_template', $this->feedInfo['post_template']);
$this->tp->assign('listing', $listingStructure);
$this->tp->assign('user', $userInfo);
$title = $this->tp->fetch($this->template);
if ($this->feedInfo['post_to_updates']) {
$post['content'] = self::getContentToPostToUpdates($title, $listingStructure['Title'], $link, $userInfo['Logo']['file_url']);
$linkedIn->postToUpdates($post);
}
if (!empty($this->feedInfo['post_to_groups']) && !empty($this->feedInfo['groups'])) {
$post['content'] = self::getContentToPostToGroup($title, $listingStructure['Title'], $link, $userInfo['Logo']['file_url']);
$post['groups'] = explode(',', $this->feedInfo['groups']);
$linkedIn->postToGroups($post);
}
return true;
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$listing_id = SJB_Request::getVar('listing_id', null);
$listingInfo = SJB_ListingManager::getListingInfoBySID($listing_id);
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listingInfo['listing_type_sid']);
$display_form = new SJB_Form();
$display_form->registerTags($tp);
if (is_null($listing_id)) {
$errors['LISTING_ID_DOESNOT_SPECIFIED'] = $listing_id;
} else {
$listing = SJB_ListingManager::getObjectBySID($listing_id);
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$file = SJB_UploadFileManager::openFile($filename, $listing_id);
$errors['NO_SUCH_FILE'] = true;
}
if (!empty($listing)) {
$listing->addPicturesProperty();
if ($listing->listing_type_sid == 6) {
$listing->deleteProperty('access_type');
$listing->deleteProperty('anonymous');
}
$access_type_properties = $listing->getProperty('access_type');
$tp->assign('access_type_properties', $access_type_properties);
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
$tp->assign("listing", $listing_structure);
$display_form = new SJB_Form($listing);
$display_form->registerTags($tp);
$form_fields = $display_form->getFormFieldsInfo();
$tp->assign("form_fields", $form_fields);
$waitApprove = SJB_ListingTypeManager::getWaitApproveSettingByListingType($listing->listing_type_sid);
$tp->assign('wait_approve', $waitApprove);
} else {
$errors['LISTING_DOESNOT_EXIST'] = $listing_id;
}
}
$comments = SJB_CommentManager::getEnabledCommentsToListing($listing_id);
$comments_total = count($comments);
$rate = SJB_Rating::getRatingNumToListing($listing_id);
$displayTemplate = SJB_Request::getVar('display_template', 'display_listing.tpl');
$videoFileId = SJB_Request::getVar('videoFileId', false);
if ($videoFileId) {
$videoFileLink = SJB_UploadFileManager::getUploadedFileLink($videoFileId);
$tp->assign('videoFileLink', $videoFileLink);
}
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->assign('errors', $errors);
$tp->assign('comments_total', $comments_total);
$tp->assign('rate', $rate);
SJB_System::setGlobalTemplateVariable('wikiExtraParam', $listingTypeInfo['id']);
$tp->display($displayTemplate);
}
function SJB_SendListingInfoController($input_data)
{
$listingId = isset($input_data['listing_id']) ? $input_data['listing_id'] : null;
if (!empty($listingId)) {
if (!is_numeric($listingId)) {
throw new Exception("Invalid listing ID is specified");
}
$this->listing = SJB_ListingManager::getObjectBySID($listingId);
if (!empty($this->listing)) {
$this->listing = SJB_ListingManager::createTemplateStructureForListing($this->listing);
$this->submitted_data = $input_data;
}
}
return false;
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$listingSID = SJB_Request::getVar('listing_id');
$template = 'flag_listing.tpl';
$errors = array();
if ($listingSID) {
// Flag listing
$reason = SJB_Request::getVar('reason');
$comment = SJB_Request::getVar('comment');
$formSubmitted = SJB_Request::getVar('action');
if ($formSubmitted) {
SJB_Captcha::getInstance($tp, $_REQUEST)->isValid($errors);
}
$listing = SJB_ListingManager::getObjectBySID($listingSID);
if (!empty($listing)) {
$listingInfo = SJB_ListingManager::createTemplateStructureForListing($listing);
} else {
$errors['WRONG_LISTING_ID_SPECIFIED'] = 'Listing does not exist';
}
if ($formSubmitted == 'flag' && empty($errors)) {
SJB_ListingManager::flagListingBySID($listingSID, $reason, $comment);
// notify admin
SJB_AdminNotifications::sendAdminListingFlaggedLetter($listing);
$template = 'flag_listing_sended.tpl';
} elseif (!empty($listing)) {
// Show form to reason
$reasons = array();
if (is_numeric($listingSID) && is_numeric($listing->getListingTypeSID())) {
$reasons = SJB_DB::query("SELECT * FROM `flag_listing_settings` WHERE FIND_IN_SET(?n, `listing_type_sid`)", $listing->getListingTypeSID());
}
$tp->assign('flag_types', $reasons);
}
$tp->assign('listing_id', $listingSID);
if (!empty($listingInfo)) {
$tp->assign('listing_type_id', strtolower($listingInfo['type']['id']));
}
if (!empty($errors)) {
$tp->assign('errors', $errors);
$tp->assign('reason', $reason);
$tp->assign('comment', $comment);
}
}
$tp->display($template);
}
/**
* @param $listingSID
* @return mixed
* @throws Exception
*/
public function postListing($listingSID)
{
$listing = SJB_ListingManager::getObjectBySID($listingSID);
if (!$listing instanceof SJB_Listing) {
$params = array($listingSID);
$message = 'Listing #$param_0 does not exist in system';
throw new SJB_FeedException($message, $params);
}
$listingInfo = SJB_ListingManager::createTemplateStructureForListing($listing);
$listingUrl = SJB_ListingManager::getListingUrlBySID($listingSID);
$link = " {$listingUrl} {$this->feedInfo['hash_tags']}";
$userInfo = SJB_Array::get($listingInfo, 'user');
$this->tp->assign('post_template', $this->feedInfo['post_template']);
$this->tp->assign('listing', $listingInfo);
$this->tp->assign('user', $userInfo);
$text = $this->tp->fetch($this->template);
$picture = $userInfo['Logo']['file_url'] == null ? SJB_System::getSystemSettings('SITE_URL') . '/' . SJB_TemplatePathManager::getAbsoluteImagePath(SJB_TemplateSupplier::getUserCurrentTheme(), 'main', 'logo.png') : $userInfo['Logo']['file_url'];
return $this->postToWall($listingSID, $text . $link, $listingUrl, $picture);
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$listingTypeSID = 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;
} else {
$listing = new SJB_Listing(array(), $listingTypeSID);
$listing->addIDProperty();
$listing->addActivationDateProperty();
$listing->addUsernameProperty();
$listing->addKeywordsProperty();
$listing->addPicturesProperty();
$listing->addListingTypeIDProperty();
$listing->addPostedWithinProperty();
$listingTypeID = SJB_ListingTypeManager::getListingTypeIDBySID($listing->listing_type_sid);
$display_form = new SJB_Form($listing);
$display_form->registerTags($tp);
$form_fields = $display_form->getFormFieldsInfo();
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('listing' => $metaDataProvider->getMetaData($listing_structure['METADATA']), 'form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$tp->assign('form_fields', $form_fields);
$tp->filterThenAssign('listing', $listing_structure);
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_DISPLAY, $listingTypeID);
$formBuilder->setChargedTemplateProcessor($tp);
$tp->assign('listingTypeInfo', SJB_ListingTypeManager::getListingTypeInfoBySID($listingTypeSID));
$tp->assign('currentTheme', SJB_TemplateSupplier::getUserCurrentTheme());
}
$tp->assign('errors', $errors);
$tp->display('bf_displaylisting.tpl');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$fatal_errors = array();
$isDataSubmitted = false;
try {
$controller = new SJB_SendListingInfoController($_REQUEST);
} catch (Exception $e) {
$controller = false;
}
if (empty($controller)) {
$fatal_errors['LISTING_ID_IS_NOT_NUMERIC'] = $e->getMessage();
} elseif ($controller->isListingSpecified()) {
if ($controller->isDataSubmitted()) {
SJB_Captcha::getInstance($tp, $_REQUEST)->isValid($errors);
if (!preg_match('^[a-zA-Z0-9\\._-]+@[a-zA-Z0-9\\._-]+\\.[a-zA-Z]{2,}$^', $_REQUEST['friend_email'])) {
$errors['NOT_VALID_EMAIL_FORMAT'] = true;
}
if (empty($errors)) {
$data_to_send = $controller->getData();
if (!SJB_Notifications::sendTellFriendLetter($data_to_send)) {
$errors['SEND_ERROR'] = true;
}
$isDataSubmitted = true;
}
}
$tp->assign('listing_info', SJB_ListingManager::createTemplateStructureForListing(SJB_ListingManager::getObjectBySID($controller->getListingID())));
} else {
$fatal_errors['UNDEFINED_LISTING_ID'] = true;
}
$tp->assign('fatal_errors', $fatal_errors);
$tp->assign('errors', $errors);
$tp->assign('info', SJB_Request::get());
$tp->assign('is_data_submitted', $isDataSubmitted);
$tp->display('tell_friend.tpl');
}
public function getMessageByListingSIDToPost($listingSID)
{
$listing = SJB_ListingManager::getObjectBySID($listingSID);
if (!$listing instanceof SJB_Listing) {
$params = array($listingSID);
$message = 'Listing #$param_0 does not exist in system';
throw new SJB_FeedException($message, $params);
}
$listingInfo = SJB_ListingManager::createTemplateStructureForListing($listing);
$link = SJB_BitlyManager::getBitlyShortenUrlByListingSid($listingSID);
$link = " {$link} {$this->feedInfo['hash_tags']}";
$userInfo = SJB_Array::get($listingInfo, 'user');
$this->tp->assign('post_template', $this->feedInfo['post_template']);
$this->tp->assign('listing', $listingInfo);
$this->tp->assign('user', $userInfo);
$text = $this->tp->fetch($this->template);
$post = $text . $link;
if (mb_strlen($post) > 138) {
$countStrCut = 138 - mb_strlen($post) - 3;
$text = mb_substr($text, 0, $countStrCut) . '...';
$post = $text . $link;
}
return $post;
}
/**
* @param array $listingsSIDs
* @param array $guestAlertInfo
* @param int $listingTypeSID
* @return array|bool|null
*/
public static function sendGuestAlertNewListingsFoundLetter(array $listingsSIDs, array $guestAlertInfo, $listingTypeSID)
{
$emailTplSID = SJB_ListingTypeManager::getListingTypeEmailTemplateForGuestAlert($listingTypeSID);
$listings = array();
foreach ($listingsSIDs as $listingSID) {
$listing = SJB_ListingManager::getObjectBySID($listingSID);
if ($listing instanceof SJB_Listing) {
$listing = SJB_ListingManager::createTemplateStructureForListing($listing);
array_push($listings, $listing);
}
}
try {
$guestAlert = SJB_GuestAlertManager::getObjectBySID($guestAlertInfo['sid']);
} catch (Exception $e) {
}
$data = array('listings' => $listings, 'key' => $guestAlert->getVerificationKeyForEmail());
$email = SJB_EmailTemplateEditor::getEmail($guestAlertInfo['email'], $emailTplSID, $data);
return $email->send('Guest Alert New Listings Found');
}
public function current()
{
$listing_structure = array();
$info = current($this->array);
if (is_numeric($info)) {
$sid = $info;
$cache = SJB_Cache::getInstance();
$cacheID = md5('ListingIterator::SJB_ListingManager::getObjectBySID' . $sid);
if ($cache->test($cacheID)) {
$listing = $cache->load($cacheID);
} else {
$listing = SJB_ListingManager::getObjectBySID($sid);
$cache->save($listing, $cacheID, array(SJB_Cache::TAG_LISTINGS));
}
$listing->addPicturesProperty();
$cacheId = md5('SJB_ListingTypeManager::getListingTypeIDBySID' . $listing->getListingTypeSID());
if (SJB_MemoryCache::has($cacheId)) {
$listing_type = SJB_MemoryCache::get($cacheId);
} else {
$listing_type = SJB_ListingTypeManager::getListingTypeIDBySID($listing->getListingTypeSID());
SJB_MemoryCache::set($cacheId, $listing_type);
}
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
$listing_structure = SJB_ListingManager::newValueFromSearchCriteria($listing_structure, $this->criteria);
if ($this->user_logged_in) {
$listing_structure['saved_listing'] = SJB_SavedListings::getSavedListingsByUserAndListingSid($this->current_user_sid, $listing->getID());
}
$listing_structure['activation_date'] = date('Y-m-d H:i:s', strtotime($listing_structure['activation_date']));
$listing_structure['expiration_date'] = date('Y-m-d H:i:s', strtotime($listing_structure['expiration_date']));
$listing_structure['listing_url'] = SJB_System::getSystemSettings('SITE_URL') . "/display-" . strtolower($listing_type) . "/" . $listing->getSID() . "/";
if (isset($listing->details->properties['EmploymentType'])) {
$employmentInfo = $listing->details->properties['EmploymentType']->type->property_info;
$employmentTypes = array();
$employment = explode(",", $employmentInfo['value']);
foreach ($employmentInfo['list_values'] as $type) {
$empType = str_replace(" ", "", $type['caption']);
$employmentTypes[$empType] = 0;
if (in_array($type['id'], $employment)) {
$employmentTypes[$empType] = 1;
}
}
$listing_structure['myEmploymentType'] = $employmentTypes;
}
// GOOGLE MAP SEARCH RESULTS CUSTOMIZATION
if ($this->view == 'map') {
$zipCode = $listing_structure['Location']['ZipCode'];
// get 'latitude' and 'longitude' from zipCode field, if it not set
$latitude = isset($listing_structure['latitude']) ? $listing_structure['latitude'] : '';
$longitude = isset($listing_structure['longitude']) ? $listing_structure['longitude'] : '';
if (!empty($zipCode) && empty($latitude) && empty($longitude)) {
$result = SJB_DB::query("SELECT * FROM `locations` WHERE `name` = ?s LIMIT 1", $zipCode);
if ($result) {
$current_coordinates = array($result[0]['latitude'], $result[0]['longitude']);
if (in_array($current_coordinates, self::$coordinates)) {
self::$index += 0.0001;
}
$listing_structure['latitude'] = $result[0]['latitude'] + self::$index;
$listing_structure['longitude'] = $result[0]['longitude'] + self::$index;
self::$coordinates = array_merge(self::$coordinates, array($current_coordinates));
}
} elseif (!empty($listing_structure['Location']['City']) && !empty($listing_structure['Location']['State']) && !empty($listing_structure['Location']['Country'])) {
$address = $listing_structure['Location']['City'] . ', ' . $listing_structure['Location']['State'] . ', ' . $listing_structure['Location']['Country'];
$address = urlencode($address);
$cache = SJB_Cache::getInstance();
$parameters = array('City' => $listing_structure['Location']['City'], 'State' => $listing_structure['Location']['State'], 'Country' => $listing_structure['Location']['Country']);
$hash = md5('google_map' . serialize($parameters));
$data = $cache->load($hash);
if (!$data) {
try {
$geoCod = SJB_HelperFunctions::getUrlContentByCurl("http://maps.googleapis.com/maps/api/geocode/json?address={$address}&sensor=false");
$geoCod = json_decode($geoCod);
if ($geoCod->status == 'OK') {
$cache->save($geoCod, $hash);
}
} catch (Exception $e) {
$backtrace = SJB_Logger::getBackTrace();
SJB_Error::writeToLog(array(array('level' => 'E_USER_WARNING', 'message' => $e->getMessage(), 'file' => $e->getFile(), 'line' => $e->getLine(), 'backtrace' => sprintf("BACKTRACE:\n [%s]", join("<br/>\n", $backtrace)))));
}
} else {
$geoCod = $data;
}
try {
if (!is_object($geoCod)) {
throw new Exception("Map object nave not been Created");
}
if ($geoCod->status != 'OK') {
throw new Exception("Status is not OK");
}
$location = $geoCod->results[0]->geometry->location;
$current_coordinates = array($location->lat, $location->lng);
if (in_array($current_coordinates, self::$coordinates)) {
self::$index += 0.0001;
}
$listing_structure['latitude'] = $location->lat + self::$index;
$listing_structure['longitude'] = $location->lng + self::$index;
self::$coordinates = array_merge(self::$coordinates, array($current_coordinates));
} catch (Exception $e) {
$backtrace = SJB_Logger::getBackTrace();
SJB_Error::writeToLog(array(array('level' => 'E_USER_WARNING', 'message' => $e->getMessage(), 'file' => $e->getFile(), 'line' => $e->getLine(), 'backtrace' => sprintf("BACKTRACE:\n [%s]", join("<br/>\n", $backtrace)))));
}
}
}
} elseif ($info) {
$listing_structure = $info;
}
return $listing_structure;
}
/**
* @param $listingSID
*/
public static function setMetaOpenGraph($listingSID)
{
if (!empty($listingSID)) {
$listing = SJB_ListingManager::getObjectBySID($listingSID);
$listingStructure = SJB_ListingManager::createTemplateStructureForListing($listing);
$siteUrl = SJB_System::getSystemSettings("SITE_URL");
$location = SJB_LocationManager::locationFormat(array("location" => $listingStructure['Location']));
$locationFormatted = !empty($location) ? " (" . $location . ")" : '';
$title = htmlspecialchars(strip_tags(trim($listingStructure['Title']))) . $locationFormatted;
$logoImage = !empty($listingStructure['user']['Logo']['file_url']) ? $listingStructure['user']['Logo']['file_url'] : '';
$description = self::getListingDescriptionPreparedForSharer($listingStructure);
$listingUrl = SJB_ListingManager::getListingUrlBySID($listingSID);
$openGraphMetaBlock = "<meta property=\"og:type\" content=\"website\" />\n\t" . "<meta property=\"og:url\" content=\"{$listingUrl}\" />\n\t" . "<meta property=\"og:title\" content=\"{$title}\" />\n\t" . "<meta property=\"og:description\" content=\"{$description}\" />\n\t" . "<meta property=\"og:site_name\" content=\"{$siteUrl}\" />\n\t" . "<meta property=\"og:image\" content=\"{$logoImage}\" />";
$head = SJB_System::getPageHead();
SJB_System::setPageHead($head . ' ' . $openGraphMetaBlock);
}
}
public function execute()
{
$formToken = SJB_Request::getVar('form_token');
$tp = SJB_System::getTemplateProcessor();
$tp->assign('form_token', $formToken);
$post_max_size_orig = ini_get('post_max_size');
$server_content_length = isset($_SERVER['CONTENT_LENGTH']) ? $_SERVER['CONTENT_LENGTH'] : null;
// get post_max_size in bytes
$val = trim($post_max_size_orig);
$tmp = substr($val, strlen($val) - 1);
$tmp = strtolower($tmp);
switch ($tmp) {
case 'g':
$val *= 1024;
break;
case 'm':
$val *= 1024;
break;
case 'k':
$val *= 1024;
break;
}
$post_max_size = $val;
$errors = array();
if (SJB_Request::getVar('from-preview', false, 'POST') && !SJB_Request::getVar('action_add', false, 'POST')) {
$listingId = SJB_Request::getVar('listing_id', null, 'GET', 'int');
$previewListingId = SJB_Session::getValue('preview_listing_sid');
if ($previewListingId && SJB_ListingManager::isListingExists($previewListingId)) {
$listingId = $previewListingId;
}
} else {
$listingId = SJB_Request::getVar('listing_id', null, 'default', 'int');
}
$template = SJB_Request::getVar('edit_template', 'edit_listing.tpl');
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
SJB_UploadFileManager::openFile($filename, $listingId);
// if file not found - set error here
$errors['NO_SUCH_FILE'] = true;
}
if (empty($_POST) && $server_content_length > $post_max_size) {
$errors['MAX_FILE_SIZE_EXCEEDED'] = 1;
$listingId = SJB_Request::getVar('listing_id', null, 'GET', 'int');
$tp->assign('post_max_size', $post_max_size_orig);
}
$current_user = SJB_UserManager::getCurrentUser();
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingId);
// for listing preview
$formSubmittedFromPreview = false;
if (empty($listingInfo)) {
$listingId = SJB_Session::getValue('preview_listing_sid');
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingId);
if (!empty($listingInfo)) {
// if on preview page 'POST' button was pressed
$formSubmittedFromPreview = SJB_Request::getVar('action_add', false, 'POST') && SJB_Request::getVar('from-preview', false, 'POST');
if ($formSubmittedFromPreview) {
$listing = new SJB_Listing($listingInfo, $listingInfo['listing_type_sid']);
$properties = $listing->getProperties();
foreach ($properties as $fieldID => $property) {
switch ($property->getType()) {
case 'date':
if (!empty($listingInfo[$fieldID])) {
$listingInfo[$fieldID] = SJB_I18N::getInstance()->getDate($listingInfo[$fieldID]);
}
break;
case 'complex':
$complex = $property->type->complex;
$complexProperties = $complex->getProperties();
foreach ($complexProperties as $complexfieldID => $complexProperty) {
if ($complexProperty->getType() == 'date') {
$values = $complexProperty->getValue();
foreach ($values as $index => $value) {
if (!empty($listingInfo[$fieldID][$complexfieldID][$index])) {
$listingInfo[$fieldID][$complexfieldID][$index] = SJB_I18N::getInstance()->getDate($listingInfo[$fieldID][$complexfieldID][$index]);
}
}
}
}
break;
}
}
}
} else {
$listingId = null;
SJB_Session::unsetValue('preview_listing_sid');
}
}
// if preview button was pressed
$isPreviewListingRequested = SJB_Request::getVar('preview_listing', false, 'POST');
if (SJB_UserManager::isUserLoggedIn()) {
if ($listingInfo['user_sid'] != $current_user->getID()) {
$errors['NOT_OWNER_OF_LISTING'] = $listingId;
} elseif (!is_null($listingInfo)) {
$pages = SJB_PostingPagesManager::getPagesByListingTypeSID($listingInfo['listing_type_sid']);
$form_is_submitted = SJB_Request::getVar('action', '') == 'save_info' || SJB_Request::getVar('action', '') == 'add' || $isPreviewListingRequested || $formSubmittedFromPreview;
if (!$form_is_submitted && !SJB_Request::getVar('from-preview', false, 'POST')) {
SJB_Session::unsetValue('previewListingId');
SJB_Session::unsetValue('preview_listing_sid_or');
}
// fill listing from an array of social data if allowed
$listing_type_info = SJB_ListingTypeManager::getListingTypeInfoBySID($listingInfo['listing_type_sid']);
$listingTypeID = $listing_type_info['id'];
$aAutoFillData = array('formSubmitted' => $form_is_submitted, 'listingTypeID' => $listingTypeID);
SJB_Event::dispatch('SocialSynchronization', $aAutoFillData);
$listingInfo = array_merge($listingInfo, $_REQUEST);
$listing = new SJB_Listing($listingInfo, $listingInfo['listing_type_sid']);
$listing->deleteProperty('ListingLogo');
$listing->deleteProperty('featured');
$listing->deleteProperty('priority');
$listing->deleteProperty('reject_reason');
$listing->deleteProperty('status');
$list_emp_ids = SJB_Request::getVar('list_emp_ids');
$listing->setSID($listingId);
$screening_questionnaires = SJB_ScreeningQuestionnaires::getList($current_user->getSID());
if (SJB_Acl::getInstance()->isAllowed('use_screening_questionnaires') && $screening_questionnaires) {
$value = SJB_Request::getVar('screening_questionnaire');
$value = $value ? $value : isset($listingInfo['screening_questionnaire']) ? $listingInfo['screening_questionnaire'] : '';
$listing->addProperty(array('id' => 'screening_questionnaire', 'type' => 'list', 'caption' => 'Screening Questionnaire', 'value' => $value, 'list_values' => SJB_ScreeningQuestionnaires::getListSIDsAndCaptions($current_user->getSID()), 'is_system' => true));
} else {
$listing->deleteProperty('screening_questionnaire');
}
//--->CLT-2637
$properties = $listing->getProperties();
$listing_fields_by_page = array();
foreach ($pages as $page) {
$listing_fields_by_page = array_merge(SJB_PostingPagesManager::getAllFieldsByPageSIDForForm($page['sid']), $listing_fields_by_page);
}
foreach ($properties as $property) {
if (!in_array($property->getID(), array_keys($listing_fields_by_page))) {
$listing->deleteProperty($property->getID());
}
}
//--->CLT-2637
// if user is not registered using linkedin , delete linkedin sync property, also if sync is turned off in admin part
$aAutoFillData = array('oListing' => &$listing, 'userSID' => $current_user->getSID(), 'listingTypeID' => $listingTypeID, 'listing_info' => $listingInfo);
SJB_Event::dispatch('SocialSynchronizationFields', $aAutoFillData);
$listing_edit_form = new SJB_Form($listing);
$listing_edit_form->registerTags($tp);
$extraInfo = $listingInfo['product_info'];
if ($extraInfo) {
$extraInfo = unserialize($extraInfo);
$numberOfPictures = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$listingSidForPictures = SJB_Session::getValue('preview_listing_sid_or') ? SJB_Session::getValue('preview_listing_sid_or') : $listingId;
$tp->assign('pic_limit', $numberOfPictures);
$tp->assign('listingSidForPictures', $listingSidForPictures);
}
if ($form_is_submitted) {
$listing->addProperty(array('id' => 'access_list', 'type' => 'multilist', 'value' => SJB_Request::getVar('list_emp_ids'), 'is_system' => true));
}
$field_errors = array();
if ($form_is_submitted && ($formSubmittedFromPreview || $listing_edit_form->isDataValid($field_errors))) {
$or_listing_id = SJB_Session::getValue('preview_listing_sid_or');
/* preview listing */
if ($isPreviewListingRequested && SJB_Session::getValue('preview_listing_sid') != $listing->getSID()) {
SJB_Session::setValue('preview_listing_sid_or', $listing->getSID());
$listing->setSID(null);
} elseif (!$isPreviewListingRequested && SJB_Session::getValue('preview_listing_sid') == $listing->getSID() && $or_listing_id && $or_listing_id != $listingId) {
$listing->setSID($or_listing_id);
}
if ($isPreviewListingRequested) {
$listing->addProperty(array('id' => 'preview', 'type' => 'integer', 'value' => 1, 'is_system' => true));
} else {
$listing->addProperty(array('id' => 'complete', 'type' => 'integer', 'value' => 1, 'is_system' => true));
}
if ($isPreviewListingRequested) {
$listing->product_info = $extraInfo;
if (SJB_Session::getValue('previewListingId')) {
$listing->setSID(SJB_Session::getValue('previewListingId'));
}
} else {
SJB_BrowseDBManager::deleteListings($listing->getID());
}
$listingSidsForCopy = array('filesFrom' => $listingId, 'picturesFrom' => $isPreviewListingRequested && (!$or_listing_id || $or_listing_id === $listingId) ? $listingId : null);
SJB_ListingManager::saveListing($listing, $listingSidsForCopy);
if (!$isPreviewListingRequested && SJB_Session::getValue('preview_listing_sid') == $listingId && $or_listing_id && $or_listing_id != $listingId) {
SJB_Session::unsetValue('preview_listing_sid');
SJB_ListingManager::deleteListingBySID($listingId);
}
$listingInfo = SJB_ListingManager::getListingInfoBySID($listing->getSID());
if ($listingInfo['active']) {
SJB_ListingManager::activateListingKeywordsBySID($listing->getSID());
SJB_BrowseDBManager::addListings($listing->getID());
}
// >>> SJB-1197
// SET VALUES FROM TEMPORARY SESSION STORAGE
$formToken = SJB_Request::getVar('form_token');
$sessionFileStorage = SJB_Session::getValue('tmp_uploads_storage');
$tempFieldsData = SJB_Array::getPath($sessionFileStorage, $formToken);
if (is_array($tempFieldsData)) {
foreach ($tempFieldsData as $fieldId => $fieldData) {
$isComplex = false;
if (strpos($fieldId, ':') !== false) {
$isComplex = true;
}
$tmpUploadedFileId = $fieldData['file_id'];
// rename it to real listing field value
$newFileId = $fieldId . "_" . $listing->getSID();
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` =?s", $newFileId, $tmpUploadedFileId);
if ($isComplex) {
list($parentField, $subField, $complexStep) = explode(':', $fieldId);
$parentProp = $listing->getProperty($parentField);
$parentValue = $parentProp->getValue();
// look for complex property with current $fieldID and set it to new value of property
if (!empty($parentValue)) {
foreach ($parentValue as $id => $value) {
if ($id == $subField) {
$parentValue[$id][$complexStep] = $newFileId;
}
}
$listing->setPropertyValue($parentField, $parentValue);
}
} else {
$listing->setPropertyValue($fieldId, $newFileId);
}
}
SJB_ListingManager::saveListing($listing);
// recreate form object for saved listing
// it fix display of complex file fields
$listing = SJB_ListingManager::getObjectBySID($listing->getSID());
$listing->deleteProperty('featured');
$listing->deleteProperty('priority');
$listing->deleteProperty('reject_reason');
$listing->deleteProperty('status');
$listing_edit_form = new SJB_Form($listing);
$listing_edit_form->registerTags($tp);
}
// <<< SJB-1197
if ($isPreviewListingRequested) {
SJB_Session::setValue('previewListingId', $listing->getSID());
}
/* preview listing */
if ($isPreviewListingRequested) {
$listing->setUserSID($current_user->getSID());
SJB_Session::setValue('preview_listing_sid', $listing->getSID());
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/' . strtolower($listingTypeID) . '-preview/' . $listing->getSID() . '/');
} else {
/* normal */
$listingSid = $listing->getSID();
SJB_Event::dispatch('listingEdited', $listingSid);
$tp->assign('display_preview', 1);
SJB_Session::unsetValue('preview_listing_sid');
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/my-' . strtolower($listingTypeID) . '-details/' . $listing->getSID() . '/');
}
}
$listing->deleteProperty('access_list');
$tp->assign('form_is_submitted', $form_is_submitted);
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
$form_fields = $listing_edit_form->getFormFieldsInfo();
$listing_fields_by_page = array();
foreach ($pages as $page) {
$listing_fields_by_page[$page['page_name']] = SJB_PostingPagesManager::getAllFieldsByPageSIDForForm($page['sid']);
foreach (array_keys($listing_fields_by_page[$page['page_name']]) as $field) {
if (!$listing->propertyIsSet($field)) {
unset($listing_fields_by_page[$page['page_name']][$field]);
}
}
}
// delete sync fields from posting pages that are not in array $form_fields
$aAutoFillData = array('listing_fields_by_page' => &$listing_fields_by_page, 'pages' => &$pages, 'form_fields' => $form_fields);
SJB_Event::dispatch('SocialSynchronizationFieldsOnPostingPages', $aAutoFillData);
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('listing' => $metaDataProvider->getMetaData($listing_structure['METADATA']), 'form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
if (!isset($listing_structure['access_type'])) {
$listing_structure['access_type'] = 'everyone';
}
$listing_access_list = SJB_ListingManager::getListingAccessList($listingId, $listing->getPropertyValue('access_type'));
$tp->assign('contract_id', $listingInfo['contract_id']);
$tp->assign('extraInfo', $extraInfo);
$tp->assign('listing', $listing_structure);
$tp->assign('pages', $listing_fields_by_page);
$tp->assign('countPages', count($listing_fields_by_page));
$tp->assign('field_errors', $field_errors);
$tp->assign('listing_access_list', $listing_access_list);
$tp->assign('listingTypeID', $listingTypeID);
$tp->assign('expired', SJB_ListingManager::getIfListingHasExpiredBySID($listing->getSID()));
// only for Resume listing types
$aAutoFillData = array('tp' => &$tp, 'listingTypeID' => $listingTypeID, 'userSID' => $current_user->getSID());
SJB_Event::dispatch('SocialSynchronizationForm', $aAutoFillData);
}
} else {
$errors['NOT_LOGGED_IN'] = 1;
}
$tp->assign('errors', $errors);
$tp->display($template);
}
public function execute()
{
if (!function_exists('_filter_data')) {
function _filter_data(&$array, $key, $pattern)
{
if (isset($array[$key])) {
if (!preg_match($pattern, $array[$key])) {
unset($array[$key]);
}
}
}
}
_filter_data($_REQUEST, 'sorting_field', "/^[_\\w\\d]+\$/");
_filter_data($_REQUEST, 'sorting_order', "/(^DESC\$)|(^ASC\$)/i");
_filter_data($_REQUEST, 'default_sorting_field', "/^[_\\w\\d]+\$/");
_filter_data($_REQUEST, 'default_sorting_order', "/(^DESC\$)|(^ASC\$)/i");
$tp = SJB_System::getTemplateProcessor();
if (!SJB_UserManager::isUserLoggedIn()) {
$errors['NOT_LOGGED_IN'] = true;
$tp->assign("ERRORS", $errors);
$tp->display("error.tpl");
return;
}
$this->defineRequestedListingTypeID();
if (!$this->listingTypeID) {
$tp->assign('listingTypes', SJB_ListingTypeManager::getAllListingTypesInfo());
$tp->display('my_available_listing_types.tpl');
return;
}
$this->listingTypeSID = SJB_ListingTypeManager::getListingTypeSIDByID($this->listingTypeID);
if (!$this->listingTypeSID) {
SJB_HelperFunctions::redirect(SJB_HelperFunctions::getSiteUrl() . '/my-listings/');
return;
}
$currentUser = SJB_UserManager::getCurrentUser();
$userSID = $currentUser->getSID();
$this->requestCriteria = array('user_sid' => array('equal' => $userSID), 'listing_type_sid' => array('equal' => $this->listingTypeSID));
$acl = SJB_Acl::getInstance();
if ($currentUser->isSubuser()) {
$subUserInfo = $currentUser->getSubuserInfo();
if (!$acl->isAllowed('subuser_manage_listings', $subUserInfo['sid'])) {
$this->requestCriteria['subuser_sid'] = array('equal' => $subUserInfo['sid']);
}
}
SJB_ListingManager::deletePreviewListingsByUserSID($userSID);
$searcher = new SJB_ListingSearcher();
// to save criteria in the session different from search_results
$criteriaSaver = new SJB_ListingCriteriaSaver('MyListings');
if (isset($_REQUEST['restore'])) {
$_REQUEST = array_merge($_REQUEST, $criteriaSaver->getCriteria());
}
if (isset($_REQUEST['listings'])) {
$listingsSIDs = $_REQUEST['listings'];
if (isset($_REQUEST['action_deactivate'])) {
$this->executeAction($listingsSIDs, 'deactivate');
} elseif (isset($_REQUEST['action_activate'])) {
$redirectToShoppingCard = false;
$activatedListings = array();
foreach ($listingsSIDs as $listingSID => $value) {
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingSID);
$productInfo = !empty($listingInfo['product_info']) ? unserialize($listingInfo['product_info']) : array();
if ($listingInfo['active']) {
continue;
} else {
if (SJB_ListingManager::getIfListingHasExpiredBySID($listingSID) && isset($productInfo['renewal_price']) && $productInfo['renewal_price'] > 0) {
$redirectToShoppingCard = true;
$listingTypeId = SJB_ListingTypeManager::getListingTypeIDBySID($listingInfo['listing_type_sid']);
$newProductName = "Reactivation of \"{$listingInfo['Title']}\" {$listingTypeId}";
$newProductInfo = SJB_ShoppingCart::createInfoForCustomProduct($userSID, $productInfo['product_sid'], $listingSID, $productInfo['renewal_price'], $newProductName, 'activateListing');
SJB_ShoppingCart::createCustomProduct($newProductInfo, $userSID);
} else {
if ($listingInfo['checkouted'] == 0) {
$redirectToShoppingCard = true;
} else {
if (SJB_ListingManager::activateListingBySID($listingSID, false)) {
$listing = SJB_ListingManager::getObjectBySID($listingSID);
SJB_Notifications::sendUserListingActivatedLetter($listing, $listing->getUserSID());
$activatedListings[] = $listingSID;
}
}
}
}
}
SJB_BrowseDBManager::addListings($activatedListings);
if ($redirectToShoppingCard) {
$shoppingUrl = SJB_System::getSystemSettings('SITE_URL') . '/shopping-cart/';
SJB_HelperFunctions::redirect($shoppingUrl);
}
} else {
if (isset($_REQUEST['action_delete'])) {
$this->executeAction($listingsSIDs, 'delete');
$allowedPostBeforeCheckout = SJB_Settings::getSettingByName('allow_to_post_before_checkout');
foreach ($listingsSIDs as $listingSID => $value) {
if ($allowedPostBeforeCheckout == true) {
$this->deleteCheckoutedListingFromShopCart($listingSID, $userSID);
}
}
} elseif (isset($_REQUEST['action_sendToApprove'])) {
$processListingsIds = array();
foreach ($listingsSIDs as $listingSID => $value) {
$processListingsIds[] = $listingSID;
}
SJB_ListingManager::setListingApprovalStatus($processListingsIds, 'pending');
}
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/my-listings/{$this->listingTypeID}/");
}
$listing = new SJB_Listing(array(), $this->listingTypeSID);
$idAliasInfo = $listing->addIDProperty();
$listing->addActivationDateProperty();
$listing->addKeywordsProperty();
$listing->addPicturesProperty();
$listingTypeIdAliasInfo = $listing->addListingTypeIDProperty();
$sortingFields = array();
$innerJoin = array();
$sortingField = SJB_Request::getVar("sorting_field", null);
$sortingOrder = SJB_Request::getVar("sorting_order", null);
if (isset($sortingField, $sortingOrder)) {
$orderInfo = array('sorting_field' => $sortingField, 'sorting_order' => $sortingOrder);
} else {
$orderInfo = $criteriaSaver->getOrderInfo();
}
if ($orderInfo['sorting_field'] == 'applications') {
$innerJoin['applications'] = array('count' => 'count(`applications`.id) as appCount', 'join' => 'LEFT JOIN', 'join_field' => 'listing_id', 'join_field2' => 'sid', 'main_table' => 'listings');
$sortingFields['appCount'] = $orderInfo['sorting_order'];
$searcher->setGroupByField(array('listings' => 'sid'));
} else {
if ($orderInfo['sorting_field'] == 'id') {
$sortingFields['sid'] = $orderInfo['sorting_order'];
} else {
if ($orderInfo['sorting_field'] == 'subuser_sid') {
$innerJoin['users'] = array('join' => 'LEFT JOIN', 'join_field' => 'sid', 'join_field2' => 'subuser_sid', 'main_table' => 'listings');
$sortingFields['username'] = $orderInfo['sorting_order'];
} else {
$property = $listing->getProperty($sortingField);
if (!empty($property) && $property->isSystem()) {
$sortingFields[$orderInfo['sorting_field']] = $orderInfo['sorting_order'];
} else {
$sortingFields['activation_date'] = 'DESC';
}
}
}
}
$this->requestCriteria['sorting_field'] = $orderInfo['sorting_field'];
$this->requestCriteria['sorting_order'] = $orderInfo['sorting_order'];
$criteria = SJB_SearchFormBuilder::extractCriteriaFromRequestData(array_merge($_REQUEST, $this->requestCriteria), $listing);
$aliases = new SJB_PropertyAliases();
$aliases->addAlias($idAliasInfo);
$aliases->addAlias($listingTypeIdAliasInfo);
$foundListingsSIDs = $searcher->getObjectsSIDsByCriteria($criteria, $aliases, $sortingFields, $innerJoin);
$searchFormBuilder = new SJB_SearchFormBuilder($listing);
$searchFormBuilder->registerTags($tp);
$searchFormBuilder->setCriteria($criteria);
// получим информацию о имеющихся листингах
$listingsInfo = array();
$currentUserInfo = SJB_UserManager::getCurrentUserInfo();
$contractInfo['extra_info']['listing_amount'] = 0;
if ($acl->isAllowed('post_' . $this->listingTypeID)) {
$permissionParam = $acl->getPermissionParams('post_' . $this->listingTypeID);
if (empty($permissionParam)) {
$contractInfo['extra_info']['listing_amount'] = 'unlimited';
} else {
$contractInfo['extra_info']['listing_amount'] = $permissionParam;
}
}
$currentUser = SJB_UserManager::getCurrentUser();
$contractsSIDs = $currentUser->getContractID();
$listingsInfo['listingsNum'] = SJB_ContractManager::getListingsNumberByContractSIDsListingType($contractsSIDs, $this->listingTypeID);
$listingsInfo['listingsMax'] = $contractInfo['extra_info']['listing_amount'];
if ($listingsInfo['listingsMax'] === 'unlimited') {
$listingsInfo['listingsLeft'] = 'unlimited';
} else {
$listingsInfo['listingsLeft'] = $listingsInfo['listingsMax'] - $listingsInfo['listingsNum'];
$listingsInfo['listingsLeft'] = $listingsInfo['listingsLeft'] < 0 ? 0 : $listingsInfo['listingsLeft'];
}
$tp->assign('listingTypeID', $this->listingTypeID);
$tp->assign('listingTypeName', SJB_ListingTypeManager::getListingTypeNameBySID($this->listingTypeSID));
$tp->assign('listingsInfo', $listingsInfo);
$tp->display('my_listings_form.tpl');
$page = SJB_Request::getVar('page', 1);
$listingsPerPage = $criteriaSaver->getListingsPerPage();
//save 'listings per page' in the session
if (empty($listingsPerPage)) {
$listingsPerPage = 10;
}
$listingsPerPage = SJB_Request::getVar('listings_per_page', $listingsPerPage);
$criteriaSaver->setSessionForListingsPerPage($listingsPerPage);
$criteriaSaver->setSessionForCurrentPage($page);
$criteriaSaver->setSessionForCriteria($_REQUEST);
$criteriaSaver->setSessionForOrderInfo($orderInfo);
$criteriaSaver->setSessionForObjectSIDs($foundListingsSIDs);
// get Applications
$appsGroups = SJB_Applications::getAppGroupsByEmployer($currentUserInfo['sid']);
$apps = array();
foreach ($appsGroups as $group) {
$apps[$group['listing_id']] = $group['count'];
}
$searchCriteriaStructure = $criteriaSaver->createTemplateStructureForCriteria();
$listingSearchStructure = $criteriaSaver->createTemplateStructureForSearch();
/**************** P A G I N G *****************/
if ($listingSearchStructure['current_page'] > $listingSearchStructure['pages_number']) {
$listingSearchStructure['current_page'] = $listingSearchStructure['pages_number'];
}
if ($listingSearchStructure['current_page'] < 1) {
$listingSearchStructure['current_page'] = 1;
}
$sortedFoundListingsSIDsByPages = array_chunk($foundListingsSIDs, $listingSearchStructure['listings_per_page'], true);
/************* S T R U C T U R E **************/
$listingsStructure = array();
$listingStructureMetaData = array();
if (isset($sortedFoundListingsSIDsByPages[$listingSearchStructure['current_page'] - 1])) {
foreach ($sortedFoundListingsSIDsByPages[$listingSearchStructure['current_page'] - 1] as $sid) {
$listing = SJB_ListingManager::getObjectBySID($sid);
$listing->addPicturesProperty();
$listingStructure = SJB_ListingManager::createTemplateStructureForListing($listing);
$listingsStructure[$listing->getID()] = $listingStructure;
if (isset($listingStructure['METADATA'])) {
$listingStructureMetaData = array_merge($listingStructureMetaData, $listingStructure['METADATA']);
}
}
}
/*************** D I S P L A Y ****************/
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$metadata = array();
$metadata['listing'] = $metaDataProvider->getMetaData($listingStructureMetaData);
$waitApprove = SJB_ListingTypeManager::getWaitApproveSettingByListingType($this->listingTypeSID);
$tp->assign('show_rates', SJB_Settings::getSettingByName('show_rates'));
$tp->assign('show_comments', SJB_Settings::getSettingByName('show_comments'));
$tp->assign('METADATA', $metadata);
$tp->assign('sorting_field', $listingSearchStructure['sorting_field']);
$tp->assign('sorting_order', $listingSearchStructure['sorting_order']);
$tp->assign('property', $this->getSortableProperties());
$tp->assign('listing_search', $listingSearchStructure);
$tp->assign('search_criteria', $searchCriteriaStructure);
$tp->assign('listings', $listingsStructure);
$tp->assign('waitApprove', $waitApprove);
$tp->assign('apps', $apps);
$hasSubusersWithListings = false;
$subusers = SJB_UserManager::getSubusers($currentUserInfo['sid']);
foreach ($subusers as $subuser) {
if ($acl->isAllowed('subuser_add_listings', $subuser['sid']) || $acl->isAllowed('subuser_manage_listings', $subuser['sid'])) {
$hasSubusersWithListings = true;
break;
}
}
$tp->assign('hasSubusersWithListings', $hasSubusersWithListings);
$tp->display('my_listings.tpl');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$display_form = new SJB_Form();
$display_form->registerTags($tp);
$errors = array();
$criteria_saver = new SJB_ListingCriteriaSaver('MyListings');
$listingSID = SJB_Request::getVar("listing_id");
if (isset($_REQUEST['passed_parameters_via_uri'])) {
$passed_parameters_via_uri = SJB_UrlParamProvider::getParams();
$listingSID = isset($passed_parameters_via_uri[0]) ? $passed_parameters_via_uri[0] : null;
}
$template = SJB_Request::getVar('display_template', 'display_listing.tpl');
if (is_null($listingSID)) {
$errors['UNDEFINED_LISTING_ID'] = true;
} elseif (is_null($listing = SJB_ListingManager::getObjectBySID($listingSID))) {
$errors['WRONG_LISTING_ID_SPECIFIED'] = true;
} elseif (!$listing->isActive() && $listing->getUserSID() != SJB_UserManager::getCurrentUserSID()) {
$errors['LISTING_IS_NOT_ACTIVE'] = true;
} else {
$listing->addPicturesProperty();
if ($listing->getUserSID() != SJB_UserManager::getCurrentUserSID()) {
$errors['NOT_OWNER'] = true;
}
$display_form = new SJB_Form($listing);
$display_form->registerTags($tp);
$form_fields = $display_form->getFormFieldsInfo();
$listingOwner = SJB_UserManager::getObjectBySID($listing->user_sid);
// listing preview @author still
$listingTypeSID = $listing->getListingTypeSID();
$listingTypeID = SJB_ListingTypeManager::getListingTypeIDBySID($listingTypeSID);
if (SJB_Request::getInstance()->page_config->uri == '/' . strtolower($listingTypeID) . '-preview/') {
if (!empty($_SERVER['HTTP_REFERER']) && (stristr($_SERVER['HTTP_REFERER'], 'edit-' . $listingTypeID) || stristr($_SERVER['HTTP_REFERER'], 'clone-job'))) {
$tp->assign('referer', $_SERVER['HTTP_REFERER']);
} else {
$lastPage = SJB_PostingPagesManager::getPagesByListingTypeSID($listingTypeSID);
$lastPage = array_pop($lastPage);
$tp->assign('referer', SJB_System::getSystemSettings('SITE_URL') . '/add-listing/' . $listingTypeID . '/' . $lastPage['page_id'] . '/' . $listing->getSID());
}
$tp->assign('checkouted', SJB_ListingManager::isListingCheckOuted($listing->getSID()));
$tp->assign('contract_id', $listing->contractID);
}
$listingStructure = SJB_ListingManager::createTemplateStructureForListing($listing, array('comments', 'ratings'));
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
SJB_UploadFileManager::openFile($filename, $listingSID);
$errors['NO_SUCH_FILE'] = true;
}
$prev_and_next_listing_id = $criteria_saver->getPreviousAndNextObjectID($listingSID);
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('listing' => $metaDataProvider->getMetaData($listingStructure['METADATA']), 'form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$comments = '';
$comments_total = '';
if (SJB_Settings::getSettingByName('show_comments') == '1') {
$comments = SJB_CommentManager::getEnabledCommentsToListing($listingSID);
$comments_total = count($comments);
}
$tp->assign('show_rates', SJB_Settings::getSettingByName('show_rates'));
$tp->assign('show_comments', SJB_Settings::getSettingByName('show_comments'));
$tp->assign('comments', $comments);
$tp->assign('comments_total', $comments_total);
$tp->assign('listing_id', $listingSID);
$tp->assign('form_fields', $form_fields);
$tp->assign('video_fields', SJB_HelperFunctions::takeMediaFields($form_fields));
$tp->filterThenAssign("listing", $listingStructure);
$tp->assign('prev_next_ids', $prev_and_next_listing_id);
$tp->assign('preview_listing_sid', SJB_Request::getVar('preview_listing_sid'));
$tp->assign('listingOwner', $listingOwner);
if (SJB_Request::getVar('action', false) == 'download_pdf_version') {
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_PDF, SJB_Array::getPath($listingStructure, 'type/id'));
$formBuilder->setChargedTemplateProcessor($tp);
$tpl = 'resume_to_pdf.tpl';
$filename = $listingStructure['user']['FirstName'] . ' ' . $listingStructure['user']['LastName'] . '_' . $listingStructure['Title'] . '.pdf';
try {
$tp->assign('myListing', 1);
$html = $tp->fetch($tpl);
$html = preg_replace('/<div[^>]*>/', '', $html);
$html = str_replace('</div>', '', $html);
SJB_HelperFunctions::html2pdf($html, $filename, str_replace('http://', '', SJB_HelperFunctions::getSiteUrl()));
exit;
} catch (Exception $e) {
SJB_Error::writeToLog($e->getMessage());
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . '/my-resume-details/' . $listingSID . '/?error=TCPDF_ERROR');
}
} else {
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_DISPLAY, SJB_Array::getPath($listingStructure, 'type/id'));
$formBuilder->setChargedTemplateProcessor($tp);
}
}
$search_criteria_structure = $criteria_saver->createTemplateStructureForCriteria();
$tp->filterThenAssign('search_criteria', $search_criteria_structure);
$tp->assign('errors', $errors);
$tp->assign('myListing', true);
$tp->display($template);
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$display_form = new SJB_Form();
$display_form->registerTags($tp);
$current_user = SJB_UserManager::getCurrentUser();
$errors = array();
$template = SJB_Request::getVar('display_template', 'display_listing.tpl');
$tcpdfError = SJB_Request::getVar('error', false);
$action = substr($template, 0, -4);
$listing_id = SJB_Request::getVar("listing_id");
if (isset($_REQUEST['passed_parameters_via_uri'])) {
$passed_parameters_via_uri = SJB_UrlParamProvider::getParams();
$listing_id = isset($passed_parameters_via_uri[0]) ? $passed_parameters_via_uri[0] : null;
}
if (is_null($listing_id) && SJB_FormBuilderManager::getIfBuilderModeIsSet()) {
$listing_type_id = SJB_Request::getVar('listing_type_id');
$listing_id = SJB_ListingManager::getListingIDByListingTypeID($listing_type_id);
}
if (is_null($listing_id)) {
$errors['UNDEFINED_LISTING_ID'] = true;
} elseif (is_null($listing = SJB_ListingManager::getObjectBySID($listing_id)) || !SJB_ListingManager::isListingAccessableByUser($listing_id, SJB_UserManager::getCurrentUserSID())) {
$errors['WRONG_LISTING_ID_SPECIFIED'] = true;
} elseif (!$listing->isActive() && $listing->getUserSID() != SJB_UserManager::getCurrentUserSID()) {
$errors['LISTING_IS_NOT_ACTIVE'] = true;
} elseif (($listingStatus = SJB_ListingManager::getListingApprovalStatusBySID($listing_id)) != 'approved' && SJB_ListingTypeManager::getWaitApproveSettingByListingType($listing->listing_type_sid) == 1 && $listing->getUserSID() != SJB_UserManager::getCurrentUserSID()) {
$errors['LISTING_IS_NOT_APPROVED'] = true;
} elseif (SJB_ListingTypeManager::getListingTypeIDBySID($listing->listing_type_sid) == 'Resume' && ($template == 'display_job.tpl' or SJB_System::getURI() == '/print-job/') || SJB_ListingTypeManager::getListingTypeIDBySID($listing->listing_type_sid) == 'Job' && ($template == 'display_resume.tpl' or SJB_System::getURI() == '/print-resume/')) {
$errors['WRONG_DISPLAY_TEMPLATE'] = true;
} else {
$listing_type_id = SJB_ListingTypeManager::getListingTypeIDBySID($listing->listing_type_sid);
if (SJB_System::getURI() == '/print-listing/') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/print-' . strtolower($listing_type_id) . '/?listing_id=' . $listing_id);
exit;
}
$listing->addPicturesProperty();
$display_form = new SJB_Form($listing);
$display_form->registerTags($tp);
$form_fields = $display_form->getFormFieldsInfo();
$listingOwner = SJB_UserManager::getObjectBySID($listing->user_sid);
if ($action !== 'print_listing') {
SJB_ListingManager::incrementViewsCounterForListing($listing_id, $listing);
}
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing, array('comments', 'ratings'));
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$file = SJB_UploadFileManager::openFile($filename, $listing_id);
$errors['NO_SUCH_FILE'] = true;
}
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign("METADATA", array("listing" => $metaDataProvider->getMetaData($listing_structure['METADATA']), "form_fields" => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$comments = array();
$comments_total = '';
if (SJB_Settings::getSettingByName('show_comments') == '1') {
$comments = SJB_CommentManager::getEnabledCommentsToListing($listing_id);
$comments_total = count($comments);
}
$searchId = SJB_Request::getVar("searchId", "");
$page = SJB_Request::getVar("page", "");
$criteria_saver = new SJB_ListingCriteriaSaver($searchId);
$searchCriteria = $criteria_saver->getCriteria();
$keywordsHighlight = '';
if (isset($searchCriteria['keywords']) && SJB_System::getSettingByName('use_highlight_for_keywords')) {
foreach ($searchCriteria['keywords'] as $type => $keywords) {
switch ($type) {
case 'like':
case 'exact_phrase':
$keywordsHighlight = json_encode($keywords);
break;
case 'all_words':
case 'any_words':
$keywordsHighlight = json_encode(explode(' ', $keywords));
break;
case 'boolean':
$keywordsHighlight = json_encode(SJB_BooleanEvaluator::parse($keywords, true));
break;
}
}
}
$prevNextIds = $criteria_saver->getPreviousAndNextObjectID($listing_id);
$search_criteria_structure = $criteria_saver->createTemplateStructureForCriteria();
//permissions contact info
$acl = SJB_Acl::getInstance();
$permission = 'view_' . $listing_type_id . '_contact_info';
$allowViewContactInfo = false;
if (SJB_UserManager::isUserLoggedIn()) {
if (SJB_ContractManager::isPageViewed($current_user->getSID(), $permission, $listing_id) || $acl->isAllowed($permission) && in_array($acl->getPermissionParams($permission), array('', '0'))) {
$allowViewContactInfo = true;
} elseif ($acl->isAllowed($permission)) {
$viewContactInfo['count_views'] = 0;
$contractIDs = $current_user->getContractID();
$numberOfContactViewed = SJB_ContractManager::getNumbeOfPagesViewed($current_user->getSID(), $contractIDs, $permission);
foreach ($contractIDs as $contractID) {
if ($acl->getPermissionParams($permission, $contractID, 'contract')) {
$params = $acl->getPermissionParams($permission, $contractID, 'contract');
$viewsLeft = SJB_ContractManager::getNumbeOfPagesViewed($current_user->getSID(), array($contractID), $permission);
if (isset($viewContactInfo['count_views']) && is_numeric($params)) {
$viewContactInfo['count_views'] += $params;
if ($params > $viewsLeft) {
$viewContactInfo['contract_id'] = $contractID;
}
}
}
}
if ($viewContactInfo && $viewContactInfo['count_views'] > $numberOfContactViewed) {
$allowViewContactInfo = true;
SJB_ContractManager::addViewPage($current_user->getSID(), $permission, $listing_id, $viewContactInfo['contract_id'], $listing->getListingTypeSID());
}
}
$user_group_id = SJB_UserGroupManager::getUserGroupIDBySID($current_user->getUserGroupSID());
if ($allowViewContactInfo && $user_group_id == 'JobSeeker' && $listing_type_id == 'Job') {
SJB_UserManager::saveRecentlyViewedListings($current_user->getSID(), $listing_id);
}
} elseif ($acl->isAllowed($permission)) {
$allowViewContactInfo = true;
}
$tp->assign("keywordsHighlight", $keywordsHighlight);
$tp->assign('allowViewContactInfo', $allowViewContactInfo);
$tp->assign('show_rates', SJB_Settings::getSettingByName('show_rates'));
$tp->assign("isApplied", SJB_Applications::isApplied($listing_id, SJB_UserManager::getCurrentUserSID()));
$tp->assign('show_rates', SJB_Settings::getSettingByName('show_rates'));
$tp->assign('show_comments', SJB_Settings::getSettingByName('show_comments'));
$tp->assign('comments', $comments);
$tp->assign('comments_total', $comments_total);
$tp->assign('listing_id', $listing_id);
$tp->assign("form_fields", $form_fields);
$tp->assign('video_fields', SJB_HelperFunctions::takeMediaFields($form_fields));
$tp->assign('uri', base64_encode(SJB_Navigator::getURIThis()));
$tp->assign('listingOwner', $listingOwner);
$listing_structure = SJB_ListingManager::newValueFromSearchCriteria($listing_structure, $criteria_saver->criteria);
// SJB-1197: ajax autoupload.
// Fix to view video from temporary uploaded storage.
$sessionFilesStorage = SJB_Session::getValue('tmp_uploads_storage');
// NEED TO CHECK FOR COMPLEX PARENT AND COMPLEX STEP PARAMETERS!
$complexParent = SJB_Request::getVar('complexParent');
$complexStep = SJB_Request::getVar('complexEnum');
$fieldId = SJB_Request::getVar('field_id');
$isComplex = false;
if ($complexParent && $complexStep) {
$fieldId = $complexParent . ":" . $fieldId . ":" . $complexStep;
$isComplex = true;
}
$tempFileValue = SJB_Array::getPath($sessionFilesStorage, "listings/{$listing_id}/{$fieldId}");
if ($isComplex) {
$uploadFileManager = new SJB_UploadFileManager();
$fileLink = $uploadFileManager->getUploadedFileLink($tempFileValue['file_id']);
$tp->assign('videoFileLink', $fileLink);
} else {
if (!empty($tempFileValue)) {
$fileUniqueId = isset($tempFileValue['file_id']) ? $tempFileValue['file_id'] : '';
if (!empty($fileUniqueId)) {
$upload_manager = new SJB_UploadFileManager();
// file structure for videoplayer
$fileInfo = array('file_url' => $upload_manager->getUploadedFileLink($fileUniqueId), 'file_name' => $upload_manager->getUploadedFileName($fileUniqueId), 'saved_file_name' => $upload_manager->getUploadedSavedFileName($fileUniqueId), 'file_id' => $fileUniqueId);
$listing_structure[$fieldId] = $fileInfo;
}
}
}
// SJB-1197
// GOOGLE MAP SEARCH RESULTS CUSTOMIZATION
$zipCode = '';
if (!empty($listing_structure['Location']['ZipCode'])) {
$zipCode = $listing_structure['Location']['ZipCode'];
}
// get 'latitude' and 'longitude' from zipCode field, if it not set
$latitude = isset($listing_structure['latitude']) ? $listing_structure['latitude'] : '';
$longitude = isset($listing_structure['longitude']) ? $listing_structure['longitude'] : '';
if (!empty($zipCode) && empty($latitude) && empty($longitude)) {
$result = SJB_DB::query("SELECT * FROM `locations` WHERE `name` = ?s LIMIT 1", $zipCode);
if ($result) {
$listing_structure['latitude'] = $result[0]['latitude'];
$listing_structure['longitude'] = $result[0]['longitude'];
}
} elseif (!empty($listing_structure['Location']['City']) && !empty($listing_structure['Location']['State']) && !empty($listing_structure['Location']['Country'])) {
$address = $listing_structure['Location']['City'] . ', ' . $listing_structure['Location']['State'] . ', ' . $listing_structure['Location']['Country'];
$address = urlencode($address);
$cache = SJB_Cache::getInstance();
$parameters = array('City' => $listing_structure['Location']['City'], 'State' => $listing_structure['Location']['State'], 'Country' => $listing_structure['Location']['Country']);
$hash = md5('google_map' . serialize($parameters));
$data = $cache->load($hash);
$geoCod = '';
if (!$data) {
try {
$geoCod = SJB_HelperFunctions::getUrlContentByCurl("http://maps.googleapis.com/maps/api/geocode/json?address={$address}&sensor=false");
$geoCod = json_decode($geoCod);
if ($geoCod->status == 'OK') {
$cache->save($geoCod, $hash);
}
} catch (Exception $e) {
$backtrace = SJB_Logger::getBackTrace();
SJB_Error::writeToLog(array(array('level' => 'E_USER_WARNING', 'message' => $e->getMessage(), 'file' => $e->getFile(), 'line' => $e->getLine(), 'backtrace' => sprintf("BACKTRACE:\n [%s]", join("<br/>\n", $backtrace)))));
}
} else {
$geoCod = $data;
}
try {
if (!is_object($geoCod)) {
throw new Exception("Map object nave not been Created");
}
if ($geoCod->status !== 'OK') {
throw new Exception("Status is not OK");
}
$location = $geoCod->results[0]->geometry->location;
$listing_structure['latitude'] = $location->lat;
$listing_structure['longitude'] = $location->lng;
} catch (Exception $e) {
$backtrace = SJB_Logger::getBackTrace();
SJB_Error::writeToLog(array(array('level' => 'E_USER_WARNING', 'message' => $e->getMessage(), 'file' => $e->getFile(), 'line' => $e->getLine(), 'backtrace' => sprintf("BACKTRACE:\n [%s]", join("<br/>\n", $backtrace)))));
}
}
if (SJB_Request::getVar('view')) {
$tp->assign('listings', array($listing_structure));
}
$tp->filterThenAssign("listing", $listing_structure);
$tp->assign("prev_next_ids", $prevNextIds);
$tp->assign("searchId", $searchId);
$tp->assign("page", $page);
$tp->filterThenAssign("search_criteria", $search_criteria_structure);
$tp->filterThenAssign("search_uri", $criteria_saver->getUri());
if ($field_id = SJB_Request::getVar('field_id')) {
// SJB-825
$complexEnum = SJB_Request::getVar('complexEnum', null, 'GET');
$complexFieldID = SJB_Request::getVar('complexParent', null, 'GET');
if (!is_null($complexEnum) && !is_null($complexFieldID)) {
$videoFileID = $complexFieldID . ':' . $field_id . ':' . $complexEnum . '_' . $listing_id;
$videoFileLink = SJB_UploadFileManager::getUploadedFileLink($videoFileID);
if ($videoFileLink) {
$tp->assign('videoFileLink', $videoFileLink);
}
}
// SJB-825
$tp->assign('field_id', $field_id);
} else {
if (SJB_Request::getVar('action', false) == 'download_pdf_version') {
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_PDF, $listing_type_id);
$formBuilder->setChargedTemplateProcessor($tp);
$tpl = 'resume_to_pdf.tpl';
if ($listing_structure['anonymous'] == '1') {
$filename = 'Anonymous User_' . $listing_structure['Title'] . '.pdf';
} else {
$filename = $listing_structure['user']['FirstName'] . ' ' . $listing_structure['user']['LastName'] . '_' . $listing_structure['Title'] . '.pdf';
}
try {
$html = $tp->fetch($tpl);
$html = preg_replace('/<div[^>]*>/', '', $html);
$html = str_replace('</div>', '', $html);
SJB_HelperFunctions::html2pdf($html, $filename, str_replace('http://', '', SJB_HelperFunctions::getSiteUrl()));
exit;
} catch (Exception $e) {
SJB_Error::writeToLog($e->getMessage());
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . '/display-resume/' . $listing_id . '/?error=TCPDF_ERROR');
}
} else {
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_DISPLAY, $listing_type_id);
$formBuilder->setChargedTemplateProcessor($tp);
}
}
}
if ($errors) {
foreach ($errors as $k => $v) {
switch ($k) {
case 'TCPDF_ERROR':
case 'UNDEFINED_LISTING_ID':
case 'WRONG_LISTING_ID_SPECIFIED':
case 'LISTING_IS_NOT_ACTIVE':
case 'LISTING_IS_NOT_APPROVED':
$header = $_SERVER['SERVER_PROTOCOL'] . ' 404 Not Found';
$header_status = "Status: 404 Not Found";
header($header_status);
header($header);
SJB_System::setGlobalTemplateVariable('page_not_found', true);
break;
}
}
}
$tp->assign('errors', $errors);
$tp->assign('tcpdfError', $tcpdfError);
$tp->display($template);
}
function getListingCollectionStructure($sorted_found_listings_sids_for_current_page)
{
$listings_structure = array();
$currentUserSID = SJB_UserManager::getCurrentUserSID();
$isUserLoggedIn = SJB_UserManager::isUserLoggedIn();
foreach ($sorted_found_listings_sids_for_current_page as $sid) {
$listing = SJB_ListingManager::getObjectBySID($sid);
$listing->addPicturesProperty();
$listings_structure[$listing->getID()] = SJB_ListingManager::createTemplateStructureForListing($listing);
$listings_structure[$listing->getID()] = SJB_ListingManager::newValueFromSearchCriteria($listings_structure[$listing->getID()], $this->criteria_saver->criteria);
if ($isUserLoggedIn) {
$listings_structure[$listing->getID()]['saved_listing'] = SJB_SavedListings::getSavedListingsByUserAndListingSid($currentUserSID, $listing->getID());
}
}
return $listings_structure;
}
public function execute()
{
$listing_id = SJB_Request::getVar('listing_id', null);
$listing_info = SJB_ListingManager::getListingInfoBySID($listing_id);
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listing_info['listing_type_sid']);
if (!is_null($listing_info)) {
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$file = SJB_UploadFileManager::openFile($filename, $listing_id);
$errors['NO_SUCH_FILE'] = true;
}
if (isset($_REQUEST['Occupations']) && isset($_REQUEST['Occupations']['tree']) && !$_REQUEST['Occupations']['tree']) {
unset($_REQUEST['Occupations']['tree']);
}
$listing_info = array_merge($listing_info, $_REQUEST);
if (isset($_REQUEST['Occupations']) && isset($_REQUEST['Occupations']['tree']) && $_REQUEST['Occupations']['tree']) {
$listing_info['Occupations'] = $_REQUEST['Occupations']['tree'];
}
$listing = new SJB_Listing($listing_info, $listing_info['listing_type_sid']);
$listing->setSID($listing_id);
$listing_edit_form = new SJB_Form($listing);
$form_is_submitted = SJB_Request::getVar('action');
$errors = array();
if ($form_is_submitted) {
$listing->addProperty(array('id' => 'access_list', 'type' => 'multilist', 'value' => SJB_Request::getVar('list_emp_ids'), 'is_system' => true));
}
if ($form_is_submitted && $listing_edit_form->isDataValid($errors)) {
$listingSid = $listing->getID();
SJB_BrowseDBManager::deleteListings($listingSid);
SJB_ListingManager::saveListing($listing);
SJB_BrowseDBManager::addListings($listingSid);
$formToken = SJB_Request::getVar('form_token');
$sessionFilesStorage = SJB_Session::getValue('tmp_uploads_storage');
$uploadedFields = SJB_Array::getPath($sessionFilesStorage, $formToken);
if (!empty($uploadedFields)) {
foreach ($uploadedFields as $fieldId => $fieldValue) {
// get field of listing
$isComplex = false;
if (strpos($fieldId, ':') !== false) {
$isComplex = true;
}
$tmpUploadedFileId = $fieldValue['file_id'];
// rename it to real listing field value
$newFileId = $fieldId . "_" . $listing->getSID();
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` =?s", $newFileId, $tmpUploadedFileId);
if ($isComplex) {
list($parentField, $subField, $complexStep) = explode(':', $fieldId);
$parentProp = $listing->getProperty($parentField);
$parentValue = $parentProp->getValue();
// look for complex property with current $fieldID and set it to new value of property
if (!empty($parentValue)) {
foreach ($parentValue as $id => $value) {
if ($id == $subField) {
$parentValue[$id][$complexStep] = $newFileId;
}
}
$listing->setPropertyValue($parentField, $parentValue);
}
} else {
$listing->setPropertyValue($fieldId, $newFileId);
}
// unset value from session temporary storage
$sessionFilesStorage = SJB_Array::unsetValueByPath($sessionFilesStorage, "{$formToken}/{$fieldId}");
}
//and remove token key from temporary storage
$sessionFilesStorage = SJB_Array::unsetValueByPath($sessionFilesStorage, "{$formToken}");
SJB_Session::setValue('tmp_uploads_storage', $sessionFilesStorage);
SJB_ListingManager::saveListing($listing);
}
SJB_Event::dispatch('listingEdited', $listingSid);
if (SJB_Request::isAjax()) {
echo '<p class="green">Listing Saved</p>';
exit;
}
if ($form_is_submitted == 'save_info') {
$listingTypeId = SJB_ListingTypeManager::getListingTypeIDBySID($listing_info['listing_type_sid']);
$listingType = $listingTypeId != 'Job' && $listingTypeId != 'Resume' ? $listingTypeId . '-listings' : $listingTypeId . 's';
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . "/manage-" . strtolower($listingType) . "/?restore=1");
}
}
$listing->deleteProperty('access_list');
$comments = SJB_CommentManager::getEnabledCommentsToListing($listing_id);
$comments_total = count($comments);
$rate = SJB_Rating::getRatingNumToListing($listing_id);
$form_fields = $listing_edit_form->getFormFieldsInfo();
$pages = SJB_PostingPagesManager::getPagesByListingTypeSID($listing->getListingTypeSID());
$realFormFields = array();
foreach ($pages as $page) {
$listingFields = SJB_PostingPagesManager::getAllFieldsByPageSIDForForm($page['sid']);
foreach ($listingFields as $fieldID => $listingField) {
if (isset($form_fields[$fieldID])) {
$realFormFields[$fieldID] = $form_fields[$fieldID];
}
}
}
$adminFields = array();
foreach ($form_fields as $fieldName => $field) {
if (!isset($realFormFields[$fieldName])) {
$adminFields[$fieldName] = $field;
}
}
$realFormFields = array_merge($adminFields, $realFormFields);
$tp = SJB_System::getTemplateProcessor();
$listing_edit_form->registerTags($tp);
$extraInfo = $listing_info['product_info'];
if ($extraInfo) {
$extraInfo = unserialize($extraInfo);
$numberOfPictures = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$tp->assign("listing_duration", $extraInfo['listing_duration']);
$tp->assign("pic_limit", $numberOfPictures);
}
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
if (!isset($listing_structure['access_type'])) {
$listing_structure['access_type'] = 'everyone';
}
$listing_access_list = SJB_ListingManager::getListingAccessList($listing_id, $listing->getPropertyValue('access_type'));
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->assign('form_fields', $realFormFields);
$tp->assign('listing', $listing_structure);
$tp->assign('errors', $errors);
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->assign('listing_access_list', $listing_access_list);
$tp->assign('comments_total', $comments_total);
$tp->assign('rate', $rate);
$tp->assign('expired', SJB_ListingManager::getIfListingHasExpiredBySID($listing->getSID()));
SJB_System::setGlobalTemplateVariable('wikiExtraParam', $listingTypeInfo['id']);
$tp->display('edit_listing.tpl');
}
}
/**
* @param SJB_Listing $listing
* @return bool|null
*/
public static function sendAdminListingFlaggedLetter(SJB_Listing $listing)
{
$emailTplSID = SJB_Settings::getSettingByName('notify_admin_on_listing_flagged');
if ($emailTplSID) {
$listing = SJB_ListingManager::createTemplateStructureForListing($listing);
$user = SJB_Array::get($listing, 'user');
$params = array('listing' => $listing, 'user' => $user);
$admin_email = SJB_Settings::getSettingByName('notification_email');
$email = SJB_EmailTemplateEditor::getEmail($admin_email, $emailTplSID, $params);
if ($email) {
// notify subadmins
$subAdminsToNotify = self::isSubAdminNotifiedOnListingFlagged();
if (is_array($subAdminsToNotify)) {
foreach ($subAdminsToNotify as $subAdminEmail) {
$email->addCC($subAdminEmail);
}
}
return $email->send();
}
}
return null;
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$current_user = SJB_UserManager::getCurrentUser();
$currentUserInfo = SJB_UserManager::getCurrentUserInfo();
$tp->assign('current_user', $currentUserInfo);
$errors = array();
$error = '';
$listing_id = SJB_Request::getVar('listing_id', null, 'default', 'int');
if (SJB_UserGroupManager::getUserGroupIDBySID($current_user->user_group_sid) == 'Employer') {
$template = SJB_Request::getVar('input_template', 'copy_listing.tpl');
} else {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/my-listings/Job/');
}
//getting $tmp_listing_id from request
$tmp_listing_id_from_request = SJB_Request::getVar('tmp_listing_id', false, 'default', 'int');
$listing_info = SJB_ListingManager::getListingInfoBySID($listing_id);
$listing_type_id = SJB_ListingTypeManager::getListingTypeIDBySID($listing_info['listing_type_sid']);
if ($productsInfo = $this->canCurrentUserAddListing($error, $listing_type_id)) {
$pages = SJB_PostingPagesManager::getPagesByListingTypeSID($listing_info['listing_type_sid']);
if (!empty($tmp_listing_id_from_request)) {
$tmp_listing_sid = $tmp_listing_id_from_request;
} elseif (!$tmp_listing_id_from_request) {
$tmp_listing_sid = time();
}
$gallery = new SJB_ListingGallery();
$gallery->setListingSID($listing_info['sid']);
$pictures_info = $gallery->getPicturesInfo();
$gallery->setListingSID($tmp_listing_sid);
$pictures_info_new = $gallery->getPicturesInfo();
//reuploading pictures
if (!$pictures_info_new) {
foreach ($pictures_info as $v) {
if (!$gallery->uploadImage($v['picture_url'], $v['caption'])) {
$field_errors['Picture'] = $gallery->getError();
}
}
}
$contractID = SJB_Request::getVar('contract_id', false, 'default', 'int');
if ($contractID) {
$contract = new SJB_Contract(array('contract_id' => $contractID));
} elseif (count($productsInfo) == 1) {
$productInfo = array_pop($productsInfo);
$contractID = $productInfo['contract_id'];
$contract = new SJB_Contract(array('contract_id' => $contractID));
} else {
$tp->assign('listing_id', $listing_id);
$tp->assign("products_info", $productsInfo);
$tp->assign("listing_type_id", $listing_type_id);
$tp->display("listing_product_choice.tpl");
}
if ($contractID) {
$tp->assign('tmp_listing_id', $tmp_listing_sid);
$extraInfo = $contract->extra_info;
$numberOfPictures = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$tp->assign("pic_limit", $numberOfPictures);
$tp->assign('contractID', $contractID);
if ($listing_info['user_sid'] != SJB_UserManager::getCurrentUserSID()) {
$errors['NOT_OWNER_OF_LISTING'] = $listing_id;
} elseif (!is_null($listing_info)) {
$listing_info = array_merge($listing_info, $_REQUEST);
$listing = new SJB_Listing($listing_info, $listing_info['listing_type_sid']);
$listing->deleteProperty('featured');
$listing->deleteProperty('priority');
$listing->deleteProperty('status');
$listing->deleteProperty('reject_reason');
$listing->setSID($listing_id);
$screening_questionnaires = SJB_ScreeningQuestionnaires::getList($current_user->getSID());
if (SJB_Acl::getInstance()->isAllowed('use_screening_questionnaires') && $screening_questionnaires) {
$issetQuestionnairyField = $listing->getProperty('screening_questionnaire');
if ($issetQuestionnairyField) {
$value = SJB_Request::getVar('screening_questionnaire');
$value = $value ? $value : isset($listing_info['screening_questionnaire']) ? $listing_info['screening_questionnaire'] : '';
$listing->addProperty(array('id' => 'screening_questionnaire', 'type' => 'list', 'caption' => 'Screening Questionnaire', 'value' => $value, 'list_values' => SJB_ScreeningQuestionnaires::getListSIDsAndCaptions($current_user->getSID()), 'is_system' => true));
}
} else {
$listing->deleteProperty('screening_questionnaire');
}
$listing_edit_form = new SJB_Form($listing);
$listing_edit_form->registerTags($tp);
$extraInfo = $listing_info['product_info'];
if ($extraInfo) {
$extraInfo = unserialize($extraInfo);
$numberOfPictures = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$tp->assign("pic_limit", $numberOfPictures);
}
$form_is_submitted = isset($_REQUEST['action']) && $_REQUEST['action'] == 'save_info' || isset($_REQUEST['action']) && $_REQUEST['action'] == 'add';
$listing->addProperty(array('id' => 'contract_id', 'type' => 'id', 'value' => $contractID, 'is_system' => true));
$delete = SJB_Request::getVar('action', '') == 'delete';
$field_errors = null;
if ($delete && isset($_REQUEST['field_id'])) {
$field_id = $_REQUEST['field_id'];
$listing->details->properties[$field_id]->type->property_info['value'] = null;
} elseif ($form_is_submitted && $listing_edit_form->isDataValid($field_errors)) {
$listing->addProperty(array('id' => 'complete', 'type' => 'integer', 'value' => 1, 'is_system' => true));
$listing->setUserSID($current_user->getSID());
$extraInfo = $contract->extra_info;
$listing->setProductInfo($extraInfo);
$listing->sid = null;
if (!empty($listing_info['subuser_sid'])) {
$listing->addSubuserProperty($listing_info['subuser_sid']);
}
$listingSidsForCopy = array('filesFrom' => $listing_id, 'picturesFrom' => $tmp_listing_sid);
SJB_ListingManager::saveListing($listing, $listingSidsForCopy);
// >>> SJB-1197
// SET VALUES FROM TEMPORARY SESSION STORAGE
$formToken = SJB_Request::getVar('form_token');
$sessionFileStorage = SJB_Session::getValue('tmp_uploads_storage');
$tempFieldsData = SJB_Array::getPath($sessionFileStorage, $formToken);
if (is_array($tempFieldsData)) {
foreach ($tempFieldsData as $fieldId => $fieldData) {
$isComplex = false;
if (strpos($fieldId, ':') !== false) {
$isComplex = true;
}
$tmpUploadedFileId = $fieldData['file_id'];
// rename it to real listing field value
$newFileId = $fieldId . "_" . $listing->getSID();
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` =?s", $newFileId, $tmpUploadedFileId);
if ($isComplex) {
list($parentField, $subField, $complexStep) = explode(':', $fieldId);
$parentProp = $listing->getProperty($parentField);
$parentValue = $parentProp->getValue();
// look for complex property with current $fieldID and set it to new value of property
if (!empty($parentValue)) {
foreach ($parentValue as $id => $value) {
if ($id == $subField) {
$parentValue[$id][$complexStep] = $newFileId;
}
}
$listing->setPropertyValue($parentField, $parentValue);
}
} else {
$listing->setPropertyValue($fieldId, $newFileId);
}
// clean temporary field storage
$sessionFileStorage = SJB_Array::unsetValueByPath($sessionFileStorage, "{$formToken}/{$fieldId}");
}
//and remove token key from temporary storage
$sessionFileStorage = SJB_Array::unsetValueByPath($sessionFileStorage, "{$formToken}");
// clear temporary data in session storage
SJB_Session::setValue('tmp_uploads_storage', $sessionFileStorage);
$listingSidsForCopy = array('filesFrom' => $listing_id, 'picturesFrom' => $listing_id);
SJB_ListingManager::saveListing($listing, $listingSidsForCopy);
}
// <<< SJB-1197
SJB_Statistics::addStatistics('addListing', $listing->getListingTypeSID(), $listing->getSID(), false, $extraInfo['featured'], $extraInfo['priority']);
$contract->incrementPostingsNumber();
SJB_ProductsManager::incrementPostingsNumber($contract->product_sid);
// is listing featured by default
if ($extraInfo['featured']) {
SJB_ListingManager::makeFeaturedBySID($listing->getSID());
}
if ($extraInfo['priority']) {
SJB_ListingManager::makePriorityBySID($listing->getSID());
}
SJB_ListingManager::activateListingBySID($listing->getSID());
SJB_AdminNotifications::sendAdminListingAddedLetter($listing);
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-' . strtolower($listing_type_id) . '/?listing_id=' . $listing->getSID());
} elseif ($form_is_submitted) {
$field_id = 'video';
if (!isset($_REQUEST['video_hidden']) && $listing->getPropertyValue($field_id)) {
$listing->details->properties[$field_id]->type->property_info['value'] = null;
}
}
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
$form_fields = $listing_edit_form->getFormFieldsInfo();
$listing_fields_by_page = array();
$countPages = count($pages);
$i = 1;
foreach ($pages as $page) {
$listing_fields_by_page[$page['page_name']] = SJB_PostingPagesManager::getAllFieldsByPageSIDForForm($page['sid']);
if ($i == $countPages && isset($form_fields['screening_questionnaire'])) {
$listing_fields_by_page[$page['page_name']]['screening_questionnaire'] = $form_fields['screening_questionnaire'];
}
foreach (array_keys($listing_fields_by_page[$page['page_name']]) as $field) {
if (!$listing->propertyIsSet($field)) {
unset($listing_fields_by_page[$page['page_name']][$field]);
}
}
$i++;
}
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('listing' => $metaDataProvider->getMetaData($listing_structure['METADATA']), 'form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$contract_id = $listing_info['contract_id'];
$contract = new SJB_Contract(array('contract_id' => $contract_id));
$tp->assign('contract_id', $contract_id);
$tp->assign('contract', $contract->extra_info);
$tp->assign('countPages', count($listing_fields_by_page));
$tp->assign('copy_listing', 1);
$tp->assign('tmp_listing_id', $tmp_listing_sid);
$tp->assign('listing_id', $listing_id);
$tp->assign('contractID', $contractID);
$tp->assign('listing', $listing_structure);
$tp->assign('pages', $listing_fields_by_page);
$tp->assign('field_errors', $field_errors);
}
$tp->assign('errors', $errors);
$tp->display($template);
}
} else {
$listing_type_id = isset($listing_info['listing_type_sid']) ? $listing_info['listing_type_sid'] : false;
if ($error == 'NO_CONTRACT') {
if ($_GET) {
$getParam = '?';
foreach ($_GET as $key => $val) {
$getParam .= $key . '=' . $val . '&';
}
$getParam = substr($getParam, 0, -1);
}
$page = base64_encode(SJB_System::getURI() . $getParam);
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/my-products/?page=' . $page);
}
$tp->assign('clone_job', 1);
$tp->assign('listing_type_id', $listing_type_id);
$tp->assign('error', $error);
$tp->display('add_listing_error.tpl');
}
}
private function runTaskScheduler()
{
// Deactivate Expired Listings & Send Notifications
$listingsExpiredID = SJB_ListingManager::getExpiredListingsSID();
foreach ($listingsExpiredID as $listingExpiredID) {
SJB_ListingManager::deactivateListingBySID($listingExpiredID, true);
$listing = SJB_ListingManager::getObjectBySID($listingExpiredID);
$listingInfo = SJB_ListingManager::createTemplateStructureForListing($listing);
if (SJB_UserNotificationsManager::isUserNotifiedOnListingExpiration($listing->getUserSID())) {
SJB_Notifications::sendUserListingExpiredLetter($listingInfo);
}
// notify admin
SJB_AdminNotifications::sendAdminListingExpiredLetter($listingInfo);
}
$listingsDeactivatedID = array();
if (SJB_Settings::getSettingByName('automatically_delete_expired_listings')) {
$listingsDeactivatedID = SJB_ListingManager::getDeactivatedListingsSID();
foreach ($listingsDeactivatedID as $listingID) {
SJB_ListingManager::deleteListingBySID($listingID);
}
}
SJB_ListingManager::unFeaturedListings();
SJB_ListingManager::unPriorityListings();
SJB_Cache::getInstance()->clean('matchingAnyTag', array(SJB_Cache::TAG_LISTINGS));
/////////////////////////// Send remind notifications about expiration of LISTINGS
// 1. get user sids and days count of 'remind listing notification' setting = 1 from user_notifications table
// 2. foreach user:
// - get listings with that expiration remind date
// - check every listing sid in DB table of sended. If sended - remove from send list
// - send notification with listings to user
// - write listings sid in DB table of sended notifications
$notificationData = SJB_UserNotificationsManager::getUsersAndDaysOnListingExpirationRemind();
foreach ($notificationData as $elem) {
$userSID = $elem['user_sid'];
$days = $elem['days'];
$listingSIDs = SJB_ListingManager::getListingsIDByDaysLeftToExpired($userSID, $days);
if (empty($listingSIDs)) {
continue;
}
$listingsInfo = array();
// check listings remind sended
foreach ($listingSIDs as $key => $sid) {
if (SJB_ListingManager::isListingNotificationSended($sid)) {
unset($listingSIDs[$key]);
continue;
}
$info = SJB_ListingManager::getListingInfoBySID($sid);
$listingsInfo[$sid] = $info;
}
if (!empty($listingsInfo)) {
// now only unsended listings we have in array
// send listing notification
foreach ($listingSIDs as $sid) {
SJB_Notifications::sendRemindListingExpirationLetter($userSID, $sid, $days);
}
// write listing id in DB table of sended notifications
SJB_ListingManager::saveListingIDAsSendedNotificationsTable($listingSIDs);
}
}
// Send Notifications for Expired Contracts
$contractsExpiredID = SJB_ContractManager::getExpiredContractsID();
foreach ($contractsExpiredID as $contractExpiredID) {
$contractInfo = SJB_ContractManager::getInfo($contractExpiredID);
$productInfo = SJB_ProductsManager::getProductInfoBySID($contractInfo['product_sid']);
$userInfo = SJB_UserManager::getUserInfoBySID($contractInfo['user_sid']);
$serializedExtraInfo = unserialize($contractInfo['serialized_extra_info']);
if (!empty($serializedExtraInfo['featured_profile']) && !empty($userInfo['featured'])) {
$contracts = SJB_ContractManager::getAllContractsInfoByUserSID($userInfo['sid']);
$isFeatured = 0;
foreach ($contracts as $contract) {
if ($contract['id'] != $contractExpiredID) {
$serializedExtraInfo = unserialize($contract['serialized_extra_info']);
if (!empty($serializedExtraInfo['featured'])) {
$isFeatured = 1;
}
}
}
if (!$isFeatured) {
SJB_UserManager::removeFromFeaturedBySID($userInfo['sid']);
}
}
if (SJB_UserNotificationsManager::isUserNotifiedOnContractExpiration($contractInfo['user_sid'])) {
SJB_Notifications::sendUserContractExpiredLetter($userInfo, $contractInfo, $productInfo);
}
// notify admin
SJB_AdminNotifications::sendAdminUserContractExpiredLetter($userInfo['sid'], $contractInfo, $productInfo);
SJB_ContractManager::deleteContract($contractExpiredID, $contractInfo['user_sid']);
}
//////////////////////// Send remind notifications about expiration of contracts
// 1. get user sids and days count of 'remind subscription notification' setting = 1 from user_notifications table
// 2. foreach user:
// - get contracts with that expiration remind date
// - check every contract sid in DB table of sended. If sended - remove from send list
// - send notification with contracts to user
// - write contract sid in DB table of sended contract notifications
$notificationData = SJB_UserNotificationsManager::getUsersAndDaysOnSubscriptionExpirationRemind();
foreach ($notificationData as $elem) {
$userSID = $elem['user_sid'];
$days = $elem['days'];
$contractSIDs = SJB_ContractManager::getContractsIDByDaysLeftToExpired($userSID, $days);
if (empty($contractSIDs)) {
continue;
}
$contractsInfo = array();
// check contracts sended
foreach ($contractSIDs as $key => $sid) {
if (SJB_ContractManager::isContractNotificationSended($sid)) {
unset($contractSIDs[$key]);
continue;
}
$info = SJB_ContractManager::getInfo($sid);
$info['extra_info'] = !empty($info['serialized_extra_info']) ? unserialize($info['serialized_extra_info']) : '';
$contractsInfo[$sid] = $info;
}
if (!empty($contractsInfo)) {
// now only unsended contracts we have in array
// send contract notification
foreach ($contractSIDs as $sid) {
SJB_Notifications::sendRemindSubscriptionExpirationLetter($userSID, $contractsInfo[$sid], $days);
}
// write contract id in DB table of sended contract notifications
SJB_ContractManager::saveContractIDAsSendedNotificationsTable($contractSIDs);
}
}
// delete applications with no employer and job seeker
$emptyApplications = SJB_DB::query('SELECT `id` FROM `applications` WHERE `show_js` = 0 AND `show_emp` = 0');
foreach ($emptyApplications as $application) {
SJB_Applications::remove($application['id']);
}
// NEWS
$expiredNews = SJB_NewsManager::getExpiredNews();
foreach ($expiredNews as $article) {
SJB_NewsManager::deactivateItemBySID($article['sid']);
}
// LISTING XML IMPORT
SJB_XmlImport::runImport();
// UPDATE PAGES WITH FUNCTION EQUAL BROWSE(e.g. /browse-by-city/)
SJB_BrowseDBManager::rebuildBrowses();
//-------------------sitemap generator--------------------//
SJB_System::executeFunction('miscellaneous', 'sitemap_generator');
// CLEAR `error_log` TABLE
$errorLogLifetime = SJB_System::getSettingByName('error_log_lifetime');
$lifeTime = strtotime("-{$errorLogLifetime} days");
if ($lifeTime > 0) {
SJB_DB::query('DELETE FROM `error_log` WHERE `date` < ?t', $lifeTime);
}
SJB_Settings::updateSetting('task_scheduler_last_executed_date', $this->currentDate);
$this->tp->assign('expired_listings_id', $listingsExpiredID);
$this->tp->assign('deactivated_listings_id', $listingsDeactivatedID);
$this->tp->assign('expired_contracts_id', $contractsExpiredID);
$this->tp->assign('notified_saved_searches_id', $this->notifiedSavedSearchesSID);
$schedulerLog = $this->tp->fetch('task_scheduler_log.tpl');
SJB_HelperFunctions::writeCronLogFile('task_scheduler.log', $schedulerLog);
SJB_DB::query('INSERT INTO `task_scheduler_log`
(`last_executed_date`, `notifieds_sent`, `expired_listings`, `expired_contracts`, `log_text`)
VALUES ( NOW(), ?n, ?n, ?n, ?s)', count($this->notifiedSavedSearchesSID), count($listingsExpiredID), count($contractsExpiredID), $schedulerLog);
SJB_System::getModuleManager()->executeFunction('social', 'linkedin');
SJB_System::getModuleManager()->executeFunction('social', 'facebook');
SJB_System::getModuleManager()->executeFunction('classifieds', 'linkedin');
SJB_System::getModuleManager()->executeFunction('classifieds', 'facebook');
SJB_System::getModuleManager()->executeFunction('classifieds', 'twitter');
SJB_Event::dispatch('task_scheduler_run');
}
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);
}
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');
}
