public function execute()
{
$listing_id = isset($_REQUEST['listing_id']) ? $_REQUEST['listing_id'] : null;
$listing = SJB_ListingManager::getObjectBySID($listing_id);
$current_user = SJB_UserManager::getCurrentUser();
$template_processor = SJB_System::getTemplateProcessor();
if (is_null($listing_id)) {
$errors['PARAMETERS_MISSED'] = 1;
} elseif (empty($current_user)) {
$errors['NOT_LOGGED_IN'] = 1;
} elseif (is_null($listing)) {
$errors['WRONG_PARAMETERS_SPECIFIED'] = 1;
} elseif ($listing->getUserSID() != $current_user->getSID()) {
$errors['NOT_OWNER'] = 1;
} else {
$productInfo = $listing->getProductInfo();
$listing_info = SJB_ListingManager::getListingInfoBySID($listing_id);
$listing_type_info = SJB_ListingTypeManager::getListingTypeInfoBySID($listing_info['listing_type_sid']);
$waitApprove = $listing_type_info['waitApprove'];
$listing_info['type'] = array('id' => $listing_type_info['id'], 'caption' => $listing_type_info['name']);
$listing_info['product'] = $productInfo;
$template_processor->assign("listing", $listing_info);
$contract_id = $listing_info['contract_id'];
$template_processor->assign("waitApprove", $waitApprove);
}
$template_processor->assign("errors", isset($errors) ? $errors : null);
$template_processor->display("manage_listing.tpl");
}
public function execute()
{
$list_of_pages = SJB_PageManager::get_pages('user');
$scriptPath = explode(SJB_System::getSystemSettings("SYSTEM_URL_BASE"), __FILE__);
$scriptPath = array_shift($scriptPath);
$handle = fopen($scriptPath . "sitemap.xml", "w");
$text = '<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
fwrite($handle, $text);
foreach ($list_of_pages as $page) {
if ($page['uri'] == '/display-job/') {
$request['action'] = 'search';
$request['listing_type']['equal'] = 'Job';
$found_listings_sids = $this->searchListings($request, 'Job');
foreach ($found_listings_sids as $sid) {
$listing_info = SJB_ListingManager::getListingInfoBySID($sid);
$title = htmlspecialchars($listing_info['Title']);
$title = $sid . "/" . preg_replace("/[\\/\\\\:*?\"<>|%#\$\\s]/", "_", $title) . ".html";
$text = '
<url>
<loc>' . SJB_System::getSystemSettings("SITE_URL") . $page['uri'] . $title . '</loc>
<lastmod>' . date('Y-m-d') . '</lastmod>
<changefreq>daily</changefreq>
<priority>1</priority>
</url>';
fwrite($handle, $text);
}
} elseif ($page['uri'] == '/display-resume/') {
$request['action'] = 'search';
$request['listing_type']['equal'] = 'Resume';
$found_listings_sids = $this->searchListings($request, 'Resume');
foreach ($found_listings_sids as $sid) {
$listing_info = SJB_ListingManager::getListingInfoBySID($sid);
$title = htmlspecialchars($listing_info['Title']);
$title = $sid . "/" . preg_replace("/[\\/\\\\:*?\"<>|%#\$\\s]/", "_", $title) . ".html";
$text = '
<url>
<loc>' . SJB_System::getSystemSettings("SITE_URL") . $page['uri'] . $title . '</loc>
<lastmod>' . date('Y-m-d') . '</lastmod>
<changefreq>daily</changefreq>
<priority>1</priority>
</url>';
fwrite($handle, $text);
}
} elseif ($page['uri'] != '/callback/') {
$text = '
<url>
<loc>' . SJB_System::getSystemSettings("SITE_URL") . $page['uri'] . '</loc>
<lastmod>' . date('Y-m-d') . '</lastmod>
<changefreq>daily</changefreq>
<priority>1</priority>
</url>';
fwrite($handle, $text);
}
}
$text = '
</urlset>';
fwrite($handle, $text);
fclose($handle);
}
public function execute()
{
$listing_id = SJB_Request::getVar('listing_id', null);
$tp = SJB_System::getTemplateProcessor();
if (isset($_REQUEST['action'])) {
$action = strtolower($_REQUEST['action']);
$comment_id = SJB_Request::getVar('comment_id', null);
if (is_null($listing_id) && !is_null($comment_id)) {
$listing_id = SJB_CommentManager::getListingSIDByCommentSID($comment_id);
}
$comment_ids = array();
if (isset($_REQUEST['comment']) && is_array($_REQUEST['comment'])) {
$comment_ids = array_keys($_REQUEST['comment']);
} else {
$comment_ids = array($comment_id);
}
switch ($action) {
case 'delete':
foreach ($comment_ids as $comment_id) {
SJB_CommentManager::deleteComment($comment_id);
}
break;
case 'disable':
foreach ($comment_ids as $comment_id) {
SJB_CommentManager::disableComment($comment_id);
}
break;
case 'enable':
foreach ($comment_ids as $comment_id) {
SJB_CommentManager::enableComment($comment_id);
}
break;
case 'edit':
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
SJB_DB::query("UPDATE `comments` SET `message` = ?s WHERE `sid` = ?n", $_REQUEST['message'], $comment_id);
} else {
$listingInfo = SJB_ListingManager::getListingInfoBySID($listing_id);
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listingInfo['listing_type_sid']);
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->assign('comment', SJB_CommentManager::getObjectInfoBySID('comments', $comment_id));
$tp->display('edit_comment.tpl');
return;
}
break;
}
header('Location: ' . SJB_System::getSystemSettings('SITE_URL') . '/listing-comments/?listing_id=' . $listing_id);
exit;
}
if (!is_null($listing_id)) {
$comments = SJB_CommentManager::getCommentsToListing($listing_id);
$listingInfo = SJB_ListingManager::getListingInfoBySID($listing_id);
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listingInfo['listing_type_sid']);
$tp->assign('comments', $comments);
$tp->assign('comments_num', count($comments));
$tp->assign('listing_id', $listing_id);
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->display('listing_comments.tpl');
}
}
/**
* @param $listingSID
* @return array|bool
*/
private static function getButtonDetailsStructureByListingSID($listingSID)
{
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingSID);
if (!empty($listingInfo)) {
return array('link' => SJB_ListingManager::getListingUrlBySID($listingSID), 'shorten_url' => SJB_BitlyManager::getBitlyShortenUrlByListingSid($listingSID), 'title' => $listingInfo['Title']);
}
return false;
}
public function sync()
{
$listingInfo = SJB_ListingManager::getListingInfoBySID($this->listingSID);
$oCurListing = SJB_ObjectMother::createListing($listingInfo, SJB_ListingTypeManager::getListingTypeSIDByID('Resume'));
$this->facebookSocialPlugin->fillObjectOutSocialData($oCurListing);
$oCurListing->setSID($this->listingSID);
SJB_ListingManager::saveListing($oCurListing);
}
public function execute()
{
$templateProcessor = SJB_System::getTemplateProcessor();
$listingSid = isset($_REQUEST['listing_id']) ? $_REQUEST['listing_id'] : null;
$listing = SJB_ListingManager::getObjectBySID($listingSid);
if (!is_null($listing) && !$listing->isActive()) {
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingSid);
$productInfo = !empty($listingInfo['product_info']) ? unserialize($listingInfo['product_info']) : array();
if (isset($listingInfo['complete']) && $listingInfo['complete'] == 1 && $listingInfo['checkouted'] == 1) {
$subTotalPrice = 0;
// проверить истек ли листинг, если истек , прайс прировнять к renewal_price
if (SJB_ListingManager::getIfListingHasExpiredBySID($listing->getID()) && isset($productInfo['renewal_price'])) {
$subTotalPrice = $productInfo['renewal_price'];
}
$userSid = $listing->getUserSID();
$productSid = $productInfo['product_sid'];
$listingTitle = $listing->getProperty('Title')->getValue();
$listingTypeSid = $listing->getListingTypeSID();
$listingTypeId = SJB_ListingTypeManager::getListingTypeIDBySID($listingTypeSid);
$newProductName = "Reactivation of \"{$listingTitle}\" {$listingTypeId}";
$newProductInfo = SJB_ShoppingCart::createInfoForCustomProduct($userSid, $productSid, $listingSid, $subTotalPrice, $newProductName, 'activateListing');
if ($subTotalPrice <= 0) {
if (SJB_ListingManager::activateListingBySID($listing->getSID())) {
SJB_Notifications::sendUserListingActivatedLetter($listing, $listing->getUserSID());
}
} else {
SJB_ShoppingCart::createCustomProduct($newProductInfo, $userSid);
$shoppingUrl = SJB_System::getSystemSettings('SITE_URL') . '/shopping-cart/';
SJB_HelperFunctions::redirect($shoppingUrl);
}
$templateProcessor->assign('listingTypeID', SJB_ListingTypeManager::getListingTypeIDBySID($listingTypeSid));
} elseif ($listingInfo['checkouted'] == 0) {
$productsInfoFromShopppingCart = SJB_ShoppingCart::getProductsInfoFromCartByProductSID($productInfo['product_sid'], $listing->getUserSID());
if (empty($productsInfoFromShopppingCart)) {
$productInfoToShopCart = SJB_ProductsManager::getProductInfoBySID($productInfo['product_sid']);
$productInfo['number_of_listings'] = 1;
$productObj = new SJB_Product($productInfoToShopCart, $productInfoToShopCart['product_type']);
$productObj->setNumberOfListings($productInfoToShopCart['number_of_listings']);
$productInfoToShopCart['price'] = $productObj->getPrice();
SJB_ShoppingCart::addToShoppingCart($productInfoToShopCart, $listing->getUserSID());
}
SJB_HelperFunctions::redirect(SJB_System::getSystemsettings('SITE_URL') . '/shopping-cart/');
} else {
$errors['LISTING_IS_NOT_COMPLETE'] = 1;
}
} elseif (is_null($listingSid)) {
$errors['INVALID_LISTING_ID'] = 1;
} elseif (!is_null($listing) && $listing->isActive()) {
$errors['LISTING_ALREADY_ACTIVE'] = 1;
} else {
$errors['WRONG_LISTING_ID_SPECIFIED'] = 1;
}
$templateProcessor->assign("errors", isset($errors) ? $errors : null);
$templateProcessor->display("pay_for_listing.tpl");
}
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);
}
public function execute()
{
$template_processor = SJB_System::getTemplateProcessor();
$listingId = SJB_Request::getVar('listing_id', null, 'default', 'int');
$listingType = SJB_Request::getVar('listing_type', null);
if (!$listingType) {
if ($listingId) {
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingId);
$listingType = SJB_ListingTypeManager::getListingTypeIDBySID($listingInfo['listing_type_sid']);
} else {
$listingType = 'job';
}
}
$displayForm = SJB_Request::getVar('displayForm', false);
$error = null;
if (!SJB_Acl::getInstance()->isAllowed('save_' . trim($listingType))) {
$error = 'DENIED_SAVE_LISTING';
}
if (SJB_UserManager::isUserLoggedIn()) {
if (!$error) {
if (!is_null($listingId)) {
if (SJB_UserManager::isUserLoggedIn()) {
SJB_SavedListings::saveListingOnDB($listingId, SJB_UserManager::getCurrentUserSID());
SJB_Statistics::addStatistics('saveListing', SJB_ListingTypeManager::getListingTypeSIDByID($listingType), $listingId);
} else {
SJB_SavedListings::saveListingInCookie($listingId);
}
$template_processor->assign('saved_listing', SJB_SavedListings::getSavedListingsByUserAndListingSid(SJB_UserManager::getCurrentUserSID(), $listingId));
} else {
$error = 'LISTING_ID_NOT_SPECIFIED';
}
}
$params = SJB_Request::getVar('params', false);
$searchId = SJB_Request::getVar('searchId', false);
$page = SJB_Request::getVar('page', false);
$template_processor->assign("params", $params);
$template_processor->assign("searchId", $searchId);
$template_processor->assign("page", $page);
$template_processor->assign("listing_type", $listingType);
$template_processor->assign("listing_sid", $listingId);
$template_processor->assign("from_login", SJB_Request::getVar("from_login", false));
$template_processor->assign("error", $error);
$template_processor->assign("displayForm", $displayForm);
$template_processor->assign("view", SJB_Request::getVar('view'));
$template_processor->display("save_listing.tpl");
} else {
$template_processor->assign("return_url", base64_encode(SJB_Navigator::getURIThis() . "&from_login=1"));
$template_processor->assign("ajaxRelocate", true);
$template_processor->display("../users/login.tpl");
}
}
public function execute()
{
$listing_id = SJB_Request::getVar('listing_id', null);
$listing_info = SJB_ListingManager::getListingInfoBySID($listing_id);
$field_id = SJB_Request::getVar('field_id', null);
$current_user_sid = SJB_UserManager::getCurrentUserSID();
$owner_sid = SJB_ListingManager::getUserSIDByListingSID($listing_id);
$errors = array();
$complexEmun = SJB_Request::getVar('complexEnum', null, 'GET');
$complexFieldID = SJB_Request::getVar('complexParent', null, 'GET');
if (!is_null($complexEmun) && !is_null($complexFieldID)) {
$fieldArr = array();
array_push($fieldArr, $complexFieldID);
array_push($fieldArr, $field_id);
array_push($fieldArr, $complexEmun);
$field_id = $complexFieldID . ':' . $field_id . $complexEmun . '_' . $listing_id;
} else {
$fieldArr = explode(':', $field_id);
$complexEmun = isset($fieldArr[2]) ? explode('_', $fieldArr[2]) : false;
$complexEmun = $complexEmun ? $complexEmun[0] : false;
}
if (is_null($listing_id) || is_null($field_id)) {
$errors['PARAMETERS_MISSED'] = 1;
} else {
if (is_null($listing_info) || $complexEmun === false || !isset($listing_info[$fieldArr[0]][$fieldArr[1]][$complexEmun])) {
$errors['WRONG_PARAMETERS_SPECIFIED'] = 1;
} else {
if ($owner_sid != $current_user_sid) {
$errors['NOT_OWNER'] = 1;
} else {
$uploaded_file_id = $listing_info[$fieldArr[0]][$fieldArr[1]][$complexEmun];
SJB_UploadFileManager::deleteUploadedFileByID($uploaded_file_id);
$listing_info[$field_id] = '';
$listing = new SJB_Listing($listing_info, $listing_info['listing_type_sid']);
$props = $listing->getProperties();
foreach ($props as $prop) {
if ($prop->getID() !== $field_id) {
$listing->deleteProperty($prop->getID());
}
}
$listing->setSID($listing_id);
SJB_ListingManager::saveListing($listing);
}
}
}
$tp = SJB_System::getTemplateProcessor();
$tp->assign('errors', $errors);
$tp->assign('listing_id', $listing_id);
$tp->display('delete_uploaded_file.tpl');
}
/**
* @param $listingSid
* @return string
*/
public static function getBitlyShortenUrlByListingSid($listingSid)
{
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingSid);
$listingType = strtolower(SJB_ListingTypeManager::getListingTypeIDBySID($listingInfo["listing_type_sid"]));
$listingLongUrl = SJB_System::getSystemSettings("USER_SITE_URL") . "/display-{$listingType}/{$listingSid}/";
self::$_shortenUrl = self::getListingBitlyShortedUrlBySid($listingSid);
if (empty(self::$_shortenUrl)) {
$oAuthUrl = self::$_bitlyOauthApi . "shorten?access_token=" . self::getBitlyTokenId() . "&longUrl=" . urlencode($listingLongUrl);
$output = json_decode(self::bitlyCurl($oAuthUrl));
if (isset($output->{"data"}->{"hash"})) {
self::$_shortenUrl = $output->{"data"}->{"url"};
self::saveBitlyShortenUrlByListingSid($listingSid);
} else {
return $listingLongUrl;
}
}
return self::$_shortenUrl;
}
public function execute()
{
$listing_id = SJB_Request::getVar('listing_id', null);
$listing_info = SJB_ListingManager::getListingInfoBySID($listing_id);
$listingTypeSID = SJB_ListingTypeManager::getListingTypeIDBySID($listing_info['listing_type_sid']);
$field_id = SJB_Request::getVar('field_id', null);
$current_user_sid = SJB_UserManager::getCurrentUserSID();
$owner_sid = SJB_ListingManager::getUserSIDByListingSID($listing_id);
$errors = array();
if (is_null($listing_id) || is_null($field_id)) {
$errors['PARAMETERS_MISSED'] = 1;
} else {
if (is_null($listing_info) || !isset($listing_info[$field_id])) {
$errors['WRONG_PARAMETERS_SPECIFIED'] = 1;
} else {
if ($owner_sid != $current_user_sid) {
$errors['NOT_OWNER'] = 1;
} else {
$uploaded_file_id = $listing_info[$field_id];
SJB_UploadFileManager::deleteUploadedFileByID($uploaded_file_id);
$listing_info[$field_id] = '';
$listing = new SJB_Listing($listing_info, $listing_info['listing_type_sid']);
$props = $listing->getProperties();
foreach ($props as $prop) {
if ($prop->getID() !== $field_id) {
$listing->deleteProperty($prop->getID());
}
}
$listing->setSID($listing_id);
SJB_ListingManager::saveListing($listing);
}
}
}
$tp = SJB_System::getTemplateProcessor();
$tp->assign('errors', $errors);
$tp->assign('listing_id', $listing_id);
$tp->assign('listingTypeSID', $listingTypeSID);
$tp->display('delete_uploaded_file.tpl');
}
public function execute()
{
$listing_id = isset($_REQUEST['listing_id']) ? $_REQUEST['listing_id'] : null;
$template_processor = SJB_System::getTemplateProcessor();
if (isset($_REQUEST['action'])) {
$action = strtolower($_REQUEST['action']);
$rating_id = isset($_REQUEST['rating_id']) ? $_REQUEST['rating_id'] : null;
$comment_ids = array();
if (isset($_REQUEST['rating']) && is_array($_REQUEST['rating'])) {
$rating_ids = array_keys($_REQUEST['rating']);
} else {
$rating_ids = array($rating_id);
}
$listing_id = SJB_Rating::getListingSIDByRatingSID($rating_ids[0]);
$listing_id = $listing_id[0]['listing_id'];
switch ($action) {
case 'delete':
foreach ($rating_ids as $rating_id) {
SJB_Rating::deleteRating($rating_id);
}
break;
}
header('Location: ' . SJB_System::getSystemSettings('SITE_URL') . '/listing-rating/?listing_id=' . $listing_id);
exit;
}
if (!is_null($listing_id) && SJB_Settings::getSettingByName('show_rates') == 1) {
$rating = SJB_Rating::getRatingListing($listing_id);
$listingInfo = SJB_ListingManager::getListingInfoBySID($listing_id);
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listingInfo['listing_type_sid']);
$template_processor->assign('rating', $rating);
$template_processor->assign('listing_id', $listing_id);
$template_processor->assign('rating_num', count($rating));
$template_processor->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$template_processor->display('listing_rating.tpl');
}
}
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']);
$field_id = SJB_Request::getVar('field_id', null);
if (is_null($listing_id) || is_null($field_id)) {
$errors['PARAMETERS_MISSED'] = 1;
} elseif (is_null($listing_info) || !isset($listing_info[$field_id])) {
$errors['WRONG_PARAMETERS_SPECIFIED'] = 1;
} else {
$uploaded_file_id = $listing_info[$field_id];
SJB_UploadFileManager::deleteUploadedFileByID($uploaded_file_id);
$listing_info[$field_id] = '';
$listing = new SJB_Listing($listing_info, $listing_info['listing_type_sid']);
$listing->setSID($listing_id);
SJB_ListingManager::saveListing($listing);
}
$tp = SJB_System::getTemplateProcessor();
$tp->assign('errors', isset($errors) ? $errors : null);
$tp->assign('listing_id', $listing_id);
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->display('delete_uploaded_file.tpl');
}
/**
* @param array $menu
* @param $item
* @param $menuKey
* @param $itemKey
*/
private function removeSimilarHighlight(array &$menu, $item, $menuKey, $itemKey)
{
if (in_array(SJB_System::getSystemSettings('SITE_URL') . $this->pageID, $item['highlight'])) {
$highlight = '';
$highlightPrefix = '/manage-';
$userSid = SJB_Request::getVar('user_sid', 0);
switch ($menuKey) {
case 'Listing Configuration':
$fieldSID = SJB_Request::getVar('field_sid', false);
if ($fieldSID) {
$fieldInfo = SJB_ListingFieldManager::getFieldInfoBySID($fieldSID);
//remove unwanted highlights
if ($fieldInfo['listing_type_sid'] == 0 && $item['title'] == 'Listing Types' || $fieldInfo['listing_type_sid'] != 0 && $item['title'] == 'Common Fields') {
$highlight = $this->pageID;
}
}
break;
case 'Listing Management':
if (preg_match('/manage-resume|job|[a-zA-Z0-9]+-listings/', $item['reference']) && !preg_match('/import|export|flagged-listings/', $item['reference'])) {
if (!($listingTypeId = SJB_Request::getVar('listing_type_id', null))) {
$listingId = SJB_Request::getVar('listing_id', null);
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingId);
$listingTypeId = SJB_ListingTypeManager::getListingTypeIDBySID($listingInfo['listing_type_sid']);
}
$highlight = strtolower($listingTypeId);
}
break;
case 'Users':
$highlightPrefix = '/manage-users/';
if ($userSid) {
$userGroupSid = SJB_UserManager::getUserGroupByUserSid($userSid);
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($userGroupSid);
if (preg_match($highlightPrefix, $item['reference'])) {
$highlight = strtolower($userGroupInfo['id']);
}
} else {
if ($role = SJB_Request::getVar('role', null)) {
$type = SJB_Request::getVar('type', null);
// for user permissions
if ($type == 'user') {
$role = SJB_UserManager::getUserGroupByUserSid($role);
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($role);
$highlight = strtolower($userGroupInfo['id']);
} else {
if (in_array($type, array('group', 'guest'))) {
$highlightPrefix = 'user-';
$highlight = 'group';
}
}
} else {
//retrieve user group from uri
if (preg_match('|./(\\w*)/?|u', urldecode(SJB_Navigator::getURI()), $userGroupHub)) {
$highlight = array_pop($userGroupHub);
}
//remove unwanted highlights
if ($this->pageID == '/email-log/') {
$highlight = $this->pageID;
}
}
}
break;
case 'System Configuration':
//remove unwanted highlights
if ($this->pageID == '/email-log/' && $userSid) {
$highlight = $this->pageID;
}
break;
default:
}
if (!$highlight || strpos($item['reference'], $highlightPrefix . $highlight) !== false) {
if (!isset($this->handledHighlightGroups[$highlightPrefix])) {
$this->handledHighlightGroups[$highlightPrefix] = true;
$handledHighlightGroups[$highlightPrefix] = true;
$menu[$menuKey][$itemKey]['active'] = true;
$menu[$menuKey]['active'] = true;
}
}
}
}
public function execute()
{
$template_processor = SJB_System::getTemplateProcessor();
$listing_id = SJB_Request::getVar('listing_sid', SJB_Request::getVar('listing_id', null));
$listingInfo = SJB_ListingManager::getListingInfoBySID($listing_id);
$productSID = SJB_Request::getVar('product_sid' . null);
$errors = null;
$field_errors = null;
$extraInfo = array();
if (empty($listing_id)) {
$errors['WRONG_PARAMETERS_SPECIFIED'] = 1;
} elseif (!empty($listing_id) && strlen($listing_id) == strlen(time())) {
if ($productSID) {
SJB_Session::setValue('product_sid', $productSID);
} else {
$productSID = SJB_Session::getValue('product_sid');
}
if (empty($_SESSION['tmp_file_storage'])) {
SJB_Session::setValue('tmp_file_storage', array());
}
$productInfo = SJB_ProductsManager::getProductInfoBySID($productSID);
$contract = new SJB_Contract(array('contract_id' => $productSID));
$gallery = new SJB_ListingGallery();
$gallery->setListingSID($listing_id);
$template_processor->assign("contract", $contract);
if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'add') {
if (!isset($_FILES['picture'])) {
$field_errors['Picture'] = 'FILE_NOT_SPECIFIED';
} elseif ($_FILES['picture']['error']) {
switch ($_FILES['picture']['error']) {
case '1':
$field_errors['Picture'] = 'UPLOAD_ERR_INI_SIZE';
break;
case '2':
$field_errors['Picture'] = 'UPLOAD_ERR_FORM_SIZE';
break;
case '3':
$field_errors['Picture'] = 'UPLOAD_ERR_PARTIAL';
break;
case '4':
$field_errors['Picture'] = 'UPLOAD_ERR_NO_FILE';
break;
default:
break;
}
} else {
$image_caption = isset($_REQUEST['caption']) ? $_REQUEST['caption'] : '';
$_FILES['picture']['caption'] = $image_caption;
if (!$gallery->uploadImage($_FILES['picture']['tmp_name'], $image_caption)) {
$field_errors['Picture'] = $gallery->getError();
}
}
} elseif (isset($_REQUEST['action']) && $_REQUEST['action'] == 'delete') {
if (isset($_REQUEST['picture_id'])) {
$picture_id = $_REQUEST['picture_id'];
$gallery->deleteImageBySID($picture_id);
}
}
if ($listingInfo) {
$extraInfo = !empty($listingInfo['product_info']) ? unserialize($listingInfo['product_info']) : array();
} elseif ($contract && $contract->extra_info) {
$extraInfo = $contract->extra_info;
} elseif ($productInfo) {
$extraInfo = !empty($productInfo['serialized_extra_info']) ? unserialize($productInfo['serialized_extra_info']) : array();
}
$number_of_picture_allowed = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$number_of_picture = $gallery->getPicturesAmount();
$pictures_info = $gallery->getPicturesInfo();
$_SESSION['tmp_file_storage'] = $pictures_info;
$template_processor->assign("listing", array('id' => "{$listing_id}"));
$template_processor->assign("number_of_picture_allowed", $number_of_picture_allowed);
$template_processor->assign("number_of_picture", $number_of_picture);
$template_processor->assign('pictures', $_SESSION['tmp_file_storage']);
} else {
$listing = SJB_ListingManager::getObjectBySID($listing_id);
if (is_null($listing)) {
$errors['WRONG_PARAMETERS_SPECIFIED'] = 1;
} else {
$gallery = new SJB_ListingGallery();
$gallery->setListingSID($listing_id);
$contract = new SJB_Contract(array('contract_id' => $productSID));
if (isset($_REQUEST['action']) && $_REQUEST['action'] == 'add') {
if (!isset($_FILES['picture'])) {
$field_errors['Picture'] = 'FILE_NOT_SPECIFIED';
} elseif ($_FILES['picture']['error']) {
switch ($_FILES['picture']['error']) {
case '1':
$field_errors['Picture'] = 'UPLOAD_ERR_INI_SIZE';
break;
case '2':
$field_errors['Picture'] = 'UPLOAD_ERR_FORM_SIZE';
break;
case '3':
$field_errors['Picture'] = 'UPLOAD_ERR_PARTIAL';
break;
case '4':
$field_errors['Picture'] = 'UPLOAD_ERR_NO_FILE';
break;
default:
break;
}
} else {
$image_caption = isset($_REQUEST['caption']) ? $_REQUEST['caption'] : '';
if (!$gallery->uploadImage($_FILES['picture']['tmp_name'], $image_caption)) {
$field_errors['Picture'] = $gallery->getError();
}
}
} elseif (isset($_REQUEST['action']) && $_REQUEST['action'] == 'delete') {
if (isset($_REQUEST['picture_id'])) {
$gallery->deleteImageBySID($_REQUEST['picture_id']);
}
} elseif (isset($_REQUEST['action']) && $_REQUEST['action'] == 'move_up') {
if (isset($_REQUEST['picture_id'])) {
$gallery->moveUpImageBySID($_REQUEST['picture_id']);
}
} elseif (isset($_REQUEST['action']) && $_REQUEST['action'] == 'move_down') {
if (isset($_REQUEST['picture_id'])) {
$gallery->moveDownImageBySID($_REQUEST['picture_id']);
}
}
if ($listingInfo) {
$extraInfo = !empty($listingInfo['product_info']) ? unserialize($listingInfo['product_info']) : array();
} elseif ($contract && $contract->extra_info) {
$extraInfo = $contract->extra_info;
}
$number_of_picture_allowed = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$number_of_picture = $gallery->getPicturesAmount();
$listing_info['id'] = $listing_id;
$template_processor->assign("listing", $listing_info);
$pictures_info = $gallery->getPicturesInfo();
$template_processor->assign("pictures", $pictures_info);
$template_processor->assign("number_of_picture", $number_of_picture);
$template_processor->assign("number_of_picture_allowed", $number_of_picture_allowed);
}
}
$template_processor->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$template_processor->assign("errors", $errors);
$template_processor->assign("field_errors", $field_errors);
$template_processor->display("manage_pictures.tpl");
}
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 static function isUserAccessThisPage()
{
$pageID = SJB_PageManager::getPageParentURI(SJB_Navigator::getURI(), SJB_System::getSystemSettings('SYSTEM_ACCESS_TYPE'), false);
$access = true;
$currentUser = SJB_UserManager::getCurrentUser();
if (!is_null($currentUser)) {
$access = false;
$queryParam = '';
$listingId = SJB_Request::getVar("listing_id", false);
$passedParametersViaUri = SJB_Request::getVar("passed_parameters_via_uri", false);
if (!$listingId && $passedParametersViaUri) {
$passedParametersViaUri = SJB_UrlParamProvider::getParams();
$listingId = isset($passedParametersViaUri[0]) ? $passedParametersViaUri[0] : '';
}
if ($listingId) {
$queryParam = " AND `param` = '" . SJB_DB::quote($listingId) . "' ";
}
$pageHasBeenVisited = SJB_DB::query("SELECT `param` FROM `page_view` WHERE `id_user` = ?s AND `id_pages` = ?s {$queryParam}", $currentUser->getSID(), $pageID);
if (!empty($queryParam) && $pageHasBeenVisited || strpos($pageID, 'print') !== false) {
$access = true;
} else {
$contractsId = $currentUser->getContractID();
$pageAccess = SJB_ContractManager::getPageAccessByUserContracts($contractsId, $pageID);
$numberOfPagesViewed = SJB_ContractManager::getNumbeOfPagesViewed($currentUser->getSID(), $contractsId, $pageID);
if (isset($pageAccess[$pageID]) && $pageAccess[$pageID]['count_views'] != '') {
if ($numberOfPagesViewed < $pageAccess[$pageID]['count_views']) {
$access = true;
}
if ($access === true) {
$listingTypeSID = null;
if (is_numeric($listingId)) {
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingId);
if ($listingInfo) {
$listingTypeSID = $listingInfo['listing_type_sid'];
}
}
$availableContractId = '';
foreach ($contractsId as $contractId) {
$pageAccessByContract = SJB_ContractManager::getPageAccessByUserContracts(array($contractId), $pageID);
$viewsLeft = SJB_ContractManager::getNumbeOfPagesViewed($currentUser->getSID(), array($contractId), false, $listingTypeSID);
if (!empty($pageAccessByContract[$pageID]['count_views']) && $pageAccessByContract[$pageID]['count_views'] > $viewsLeft) {
$availableContractId = $contractId;
}
}
if (!empty($availableContractId)) {
SJB_DB::query("INSERT INTO page_view (`id_user` ,`id_pages`, `param`, `contract_id`, `listing_type_sid`) VALUES ( ?n, ?s, ?s, ?n, ?n)", $currentUser->getSID(), $pageID, $listingId, $availableContractId, $listingTypeSID);
} else {
$access = false;
}
}
} else {
$access = true;
}
}
}
return $access;
}
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();
$template = SJB_Request::getVar('input_template', 'input_form.tpl');
$error = null;
$listingTypeID = SJB_Request::getVar('listing_type_id', false);
$passed_parameters_via_uri = SJB_Request::getVar('passed_parameters_via_uri', false);
$pageID = false;
if ($passed_parameters_via_uri) {
$passed_parameters_via_uri = SJB_UrlParamProvider::getParams();
$listingTypeID = isset($passed_parameters_via_uri[0]) ? $passed_parameters_via_uri[0] : $listingTypeID;
$pageID = isset($passed_parameters_via_uri[1]) ? $passed_parameters_via_uri[1] : false;
$listing_id = isset($passed_parameters_via_uri[2]) ? $passed_parameters_via_uri[2] : false;
}
if (SJB_UserManager::isUserLoggedIn()) {
$post_max_size_orig = ini_get('post_max_size');
$server_content_length = isset($_SERVER['CONTENT_LENGTH']) ? $_SERVER['CONTENT_LENGTH'] : null;
$fromPreview = SJB_Request::getVar('from-preview', false);
// get post_max_size in bytes
$val = trim($post_max_size_orig);
$tmp = substr($val, strlen($val) - 1);
$tmp = strtolower($tmp);
/* if ini value is K - then multiply to 1024
* if ini value is M - then multiply twice: in case 'm', and case 'k'
* if ini value is G - then multiply tree times: in 'g', 'm', 'k'
* out value - in bytes!
*/
switch ($tmp) {
case 'g':
$val *= 1024;
case 'm':
$val *= 1024;
case 'k':
$val *= 1024;
}
$post_max_size = $val;
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$file = SJB_UploadFileManager::openFile($filename, $listing_id);
$errors['NO_SUCH_FILE'] = true;
}
if (empty($_POST) && $server_content_length > $post_max_size) {
$errors['MAX_FILE_SIZE_EXCEEDED'] = 1;
$tp->assign('post_max_size', $post_max_size_orig);
}
$listingInfo = SJB_ListingManager::getListingInfoBySID($listing_id);
$currentUser = SJB_UserManager::getCurrentUser();
$contractID = $listingInfo['contract_id'];
if ($contractID == 0) {
$extraInfo = unserialize($listingInfo['product_info']);
$productSID = $extraInfo['product_sid'];
} else {
$contract = new SJB_Contract(array('contract_id' => $contractID));
$extraInfo = $contract->extra_info;
}
if ($listingInfo['user_sid'] != SJB_UserManager::getCurrentUserSID()) {
$errors['NOT_OWNER_OF_LISTING'] = $listing_id;
} else {
$listing_type_sid = SJB_ListingTypeManager::getListingTypeSIDByID($listingTypeID);
$pages = SJB_PostingPagesManager::getPagesByListingTypeSID($listing_type_sid);
if (!$pageID) {
$pageID = $pages[0]['page_id'];
}
$pageSID = SJB_PostingPagesManager::getPostingPageSIDByID($pageID, $listing_type_sid);
$isPageLast = SJB_PostingPagesManager::isLastPageByID($pageSID, $listing_type_sid);
// preview listing
$isPreviewListingRequested = SJB_Request::getVar('preview_listing', false, 'POST');
$form_submitted = isset($_REQUEST['action_add']) || isset($_REQUEST['action_add_pictures']) || $isPreviewListingRequested;
// fill listing from an array of social data if allowed
$aAutoFillData = array('formSubmitted' => &$form_submitted, 'listingTypeID' => &$listingTypeID);
SJB_Event::dispatch('SocialSynchronization', $aAutoFillData);
$listingInfo = array_merge($listingInfo, $_REQUEST);
$listing = new SJB_Listing($listingInfo, $listing_type_sid, $pageSID);
if ($fromPreview) {
if ($form_submitted) {
$properties = $listing->getProperties();
foreach ($properties as $fieldID => $property) {
switch ($property->getType()) {
case 'date':
if (!empty($listing_info[$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;
}
}
$listing = new SJB_Listing($listingInfo, $listing_type_sid, $pageSID);
}
}
$previousComplexFields = $this->processComplexFields($listing, $listingInfo);
$listing->deleteProperty('featured');
$listing->deleteProperty('priority');
$listing->deleteProperty('status');
$listing->deleteProperty('reject_reason');
$listing->deleteProperty('ListingLogo');
$listing->setSID($listing_id);
$access_type = $listing->getProperty('access_type');
if ($form_submitted && !empty($access_type)) {
$listing->addProperty(array('id' => 'access_list', 'type' => 'multilist', 'value' => SJB_Request::getVar('list_emp_ids'), 'is_system' => true));
}
$screening_questionnaires = SJB_ScreeningQuestionnaires::getList($currentUser->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($listingInfo['screening_questionnaire']) ? $listingInfo['screening_questionnaire'] : '';
$listing->addProperty(array('id' => 'screening_questionnaire', 'type' => 'list', 'caption' => 'Screening Questionnaire', 'value' => $value, 'list_values' => SJB_ScreeningQuestionnaires::getListSIDsAndCaptions($currentUser->getSID()), 'is_system' => true));
}
} else {
$listing->deleteProperty('screening_questionnaire');
}
/* social plugin
* "synchronization"
* if user is not registered using linkedin , delete linkedin sync property
* also deletes it if sync is turned off in admin part
*/
if ($pages[0]['page_id'] == $pageID) {
$aAutoFillData = array('oListing' => &$listing, 'userSID' => $currentUser->getSID(), 'listingTypeID' => $listingTypeID, 'listing_info' => $listingInfo);
SJB_Event::dispatch('SocialSynchronizationFields', $aAutoFillData);
}
$add_listing_form = new SJB_Form($listing);
$add_listing_form->registerTags($tp);
$field_errors = array();
if ($form_submitted && (SJB_Session::getValue(self::PREVIEW_LISTING_SID) == $listing_id || $add_listing_form->isDataValid($field_errors))) {
/* delete temp preview listing sid */
SJB_Session::unsetValue(self::PREVIEW_LISTING_SID);
if ($isPageLast) {
$listing->addProperty(array('id' => 'complete', 'type' => 'integer', 'value' => 1, 'is_system' => true));
}
$listing->setUserSID($currentUser->getSID());
if (empty($access_type->value)) {
$listing->setPropertyValue('access_type', 'everyone');
}
if (isset($_SESSION['tmp_file_storage'])) {
foreach ($_SESSION['tmp_file_storage'] as $k => $v) {
SJB_DB::query('UPDATE `listings_pictures` SET `listing_sid` = ?n WHERE `picture_saved_name` = ?s', $listing->getSID(), $v['picture_saved_name']);
SJB_DB::query('UPDATE `listings_pictures` SET `listing_sid` = ?n WHERE `thumb_saved_name` = ?s', $listing->getSID(), $v['thumb_saved_name']);
}
SJB_Session::unsetValue('tmp_file_storage');
}
// >>> SJB-1197
// check temporary uploaded storage for listing uploads and assign it to saved listing
$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-1197
SJB_ListingManager::saveListing($listing);
foreach ($previousComplexFields as $propertyId) {
$listing->deleteProperty($propertyId);
}
if ($isPageLast && !$isPreviewListingRequested) {
$listingSID = $listing->getSID();
$listing = SJB_ListingManager::getObjectBySID($listingSID);
$listing->setSID($listingSID);
$keywords = $listing->getKeywords();
SJB_ListingManager::updateKeywords($keywords, $listing->getSID());
// Start Event
$listingSid = $listing->getSID();
SJB_Event::dispatch('listingSaved', $listingSid);
// is listing featured by default
if ($extraInfo['featured']) {
SJB_ListingManager::makeFeaturedBySID($listing->getSID());
}
if ($extraInfo['priority']) {
SJB_ListingManager::makePriorityBySID($listing->getSID());
}
if ($contractID) {
if (SJB_ListingManager::activateListingBySID($listing->getSID())) {
SJB_Notifications::sendUserListingActivatedLetter($listing, $listing->getUserSID());
}
// notify administrator
SJB_AdminNotifications::sendAdminListingAddedLetter($listing);
if (isset($_REQUEST['action_add_pictures'])) {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/manage-pictures/?listing_id=" . $listing->getSID());
} else {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-' . strtolower($listingTypeID) . '/?listing_id=' . $listing->getSID());
}
} else {
SJB_ListingManager::unmakeCheckoutedBySID($listing->getSID());
$this->proceedToCheckout($currentUser->getSID(), $productSID);
}
} elseif ($isPageLast && $isPreviewListingRequested) {
// for listing preview
SJB_Session::setValue(self::PREVIEW_LISTING_SID, $listing->getSID());
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/' . strtolower($listingTypeID) . '-preview/' . $listing->getSID() . '/');
} else {
// listing steps (pages)
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/add-listing/{$listingTypeID}/" . SJB_PostingPagesManager::getNextPage($pageSID) . '/' . $listing->getSID());
}
} else {
foreach ($previousComplexFields as $propertyId) {
$listing->deleteProperty($propertyId);
}
$listing->deleteProperty('access_list');
$listing->deleteProperty('contract_id');
$add_listing_form = new SJB_Form($listing);
if (SJB_Request::get('action_add') == 'Next') {
$add_listing_form->setUseDefaultValues();
}
if ($form_submitted) {
$add_listing_form->isDataValid($field_errors);
}
$add_listing_form->registerTags($tp);
$form_fields = $add_listing_form->getFormFieldsInfo();
$employers_list = SJB_Request::getVar('list_emp_ids', false);
$employers = array();
if (is_array($employers_list)) {
foreach ($employers_list as $emp) {
$currEmp = SJB_UserManager::getUserInfoBySID($emp);
$employers[] = array('user_id' => $emp, 'value' => $currEmp['CompanyName']);
}
sort($employers);
} else {
$access_type = $listing->getPropertyValue('access_type');
$employers = SJB_ListingManager::getListingAccessList($listing_id, $access_type);
}
$numberOfPictures = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$tp->assign('pic_limit', $numberOfPictures);
$tp->assign('listing_sid', $listing_id);
$tp->assign('listing_id', $listing_id);
$tp->assign('listingSID', $listing->getSID());
$tp->assign('listing_access_list', $employers);
$tp->assign('listingTypeID', $listingTypeID);
$tp->assign('contract_id', $contractID);
$tp->assign('field_errors', $field_errors);
$tp->assign('form_fields', $form_fields);
$tp->assign("extraInfo", $extraInfo);
$tp->assign('pages', $pages);
$tp->assign('pageSID', $pageSID);
$tp->assign('currentPage', SJB_PostingPagesManager::getPageInfoBySID($pageSID));
$tp->assign('isPageLast', $isPageLast);
$tp->assign('nextPage', SJB_PostingPagesManager::getNextPage($pageSID));
$tp->assign('prevPage', SJB_PostingPagesManager::getPrevPage($pageSID));
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
// social plugin only for Resume listing types
$aAutoFillData = array('tp' => &$tp, 'listingTypeID' => $listingTypeID, 'userSID' => $currentUser->getSID());
SJB_Event::dispatch('SocialSynchronizationForm', $aAutoFillData);
SJB_Session::unsetValue(self::PREVIEW_LISTING_SID);
$tp->display($template);
}
}
} else {
$tp->assign('listingTypeID', $listingTypeID);
$tp->assign('error', 'NOT_LOGGED_IN');
$tp->display('add_listing_error.tpl');
}
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$listingTypeID = SJB_Request::getVar('listing_type_id');
$listingTypeSID = SJB_Request::getVar('listing_type');
if ($listingTypeID !== null) {
$listingTypeSID = SJB_ListingTypeManager::getListingTypeSIDByID($listingTypeID);
}
// SET PAGINATION AND SORTING VALUES
$restore = SJB_Request::getVar('restore', false);
$paginator = new SJB_FlaggedListingsPagination();
// FILTERS
$filters = array();
$filters['title'] = SJB_Request::getVar('filter_title');
$filters['username'] = SJB_Request::getVar('filter_user');
$filters['flag'] = SJB_Request::getVar('filter_flag');
// check session for pagination settings
$sessionFlaggedSettings = !is_null(SJB_Session::getValue('flagged_settings')) ? SJB_Session::getValue('flagged_settings') : false;
if ($sessionFlaggedSettings !== false) {
if (!$restore) {
SJB_Session::setValue('flagged_settings', array('filters' => $filters));
} else {
if (!$listingTypeSID && !empty($sessionFlaggedSettings['listing_type_sid'])) {
$listingTypeSID = $sessionFlaggedSettings['listing_type_sid'];
}
$filters = $sessionFlaggedSettings['filters'];
}
} else {
SJB_Session::setValue('flagged_settings', array('filters' => $filters));
}
// DEFAULT SORTING
// resolve flag to it text value for search
$filterFlag = $filters['flag'];
if (!empty($filterFlag) && is_numeric($filterFlag)) {
$result = SJB_DB::query('SELECT * FROM `flag_listing_settings` WHERE `sid` = ?n LIMIT 1', $filterFlag);
if (!empty($result)) {
$filters['flag_reason'] = $result[0]['value'];
}
}
////////////////////// ACTIONS
$action = SJB_Request::getVar('action_name');
$flagSIDs = SJB_Request::getVar('flagged');
if (!empty($flagSIDs)) {
switch ($action) {
case 'remove':
foreach ($flagSIDs as $sid => $val) {
SJB_ListingManager::removeFlagBySID($sid);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/flagged-listings/?page=1');
break;
case 'deactivate':
foreach ($flagSIDs as $sid => $val) {
SJB_ListingManager::deactivateListingByFlagSID($sid);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/flagged-listings/?page=1');
break;
case 'delete':
foreach ($flagSIDs as $sid => $val) {
SJB_ListingManager::deleteListingByFlagSID($sid);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/flagged-listings/?page=1');
break;
}
}
//////////////////////// OUTPUT
$allListingTypes = SJB_ListingTypeManager::getAllListingTypesInfo();
$allFlags = SJB_ListingManager::getAllFlags();
$countFlaggedListings = SJB_ListingManager::getFlagsNumberByListingTypeSID($listingTypeSID, $filters);
$paginator->setItemsCount($countFlaggedListings);
$flaggedListings = SJB_ListingManager::getFlaggedListings($listingTypeSID, $paginator->currentPage, $paginator->itemsPerPage, $paginator->sortingField, $paginator->sortingOrder, $filters);
if (empty($flaggedListings) && $paginator->currentPage != 1) {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/flagged-listings/?page=1');
}
foreach ($flaggedListings as $key => $val) {
$listingInfo = SJB_ListingManager::getListingInfoBySID($val['listing_sid']);
$listingUser = SJB_UserManager::getUserInfoBySID($listingInfo['user_sid']);
$flaggedUser = SJB_UserManager::getUserInfoBySID($val['user_sid']);
$flaggedListings[$key]['listing_info'] = $listingInfo;
$flaggedListings[$key]['user_info'] = $listingUser;
$flaggedListings[$key]['flagged_user'] = $flaggedUser;
}
$tp->assign('paginationInfo', $paginator->getPaginationInfo());
$tp->assign('listing_types', $allListingTypes);
$tp->assign('listings', $flaggedListings);
$tp->assign('listing_type_sid', $listingTypeSID);
$tp->assign('all_flags', $allFlags);
$tp->assign('filters', $filters);
$tp->display('flagged_listings.tpl');
}
public function execute()
{
$restore = 'restore=';
if (isset($_REQUEST['action_name'], $_REQUEST['listings'])) {
$listings_ids = $_REQUEST['listings'];
switch (strtolower($_REQUEST['action_name'])) {
case 'activate':
$activatedListings = array();
foreach ($listings_ids as $listingId => $value) {
if (SJB_ListingManager::activateListingBySID($listingId, false)) {
$activatedListings[] = $listingId;
}
$listing = SJB_ListingManager::getObjectBySID($listingId);
if (SJB_UserNotificationsManager::isUserNotifiedOnListingActivation($listing->getUserSID())) {
SJB_Notifications::sendUserListingActivatedLetter($listing, $listing->getUserSID());
}
}
SJB_BrowseDBManager::addListings($activatedListings);
break;
case 'deactivate':
$this->executeAction($listings_ids, 'deactivate');
break;
case 'delete':
$this->executeAction($listings_ids, 'delete');
break;
case 'datemodify':
if (isset($_REQUEST['date_to_change'])) {
$dateToUpdate = $_REQUEST['date_to_change'];
$date = SJB_I18N::getInstance()->getInput('date', $dateToUpdate);
foreach ($listings_ids as $listing_id => $value) {
$listingInfo = SJB_ListingManager::getListingInfoBySID($listing_id);
$result = SJB_DB::query('UPDATE `listings` SET `expiration_date` = ?s WHERE `sid` = ?n', $date, $listingInfo['sid']);
}
}
break;
case 'approve':
$this->executeAction($listings_ids, 'approve');
foreach ($listings_ids as $listing_id => $value) {
$user_sid = SJB_ListingManager::getUserSIDByListingSID($listing_id);
if (SJB_UserNotificationsManager::isUserNotifiedOnListingApprove($user_sid)) {
SJB_Notifications::sendUserListingApproveOrRejectLetter($listing_id, $user_sid, 'approve');
}
}
break;
case 'reject':
$this->executeAction($listings_ids, 'reject');
foreach ($listings_ids as $listing_id => $value) {
$user_sid = SJB_ListingManager::getUserSIDByListingSID($listing_id);
if (SJB_UserNotificationsManager::isUserNotifiedOnListingReject($user_sid)) {
SJB_Notifications::sendUserListingApproveOrRejectLetter($listing_id, $user_sid, 'reject');
}
}
break;
default:
$restore = '';
break;
}
}
$listingTypeId = SJB_Request::getVar('listingTypeId', null);
$listingType = $listingTypeId != 'Job' && $listingTypeId != 'Resume' ? $listingTypeId . '-listings' : $listingTypeId . 's';
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-' . strtolower($listingType) . '/?action=search&' . $restore);
}
private function updateListing($type, $key, $items, $userSid)
{
$listingSid = $items['custom_info'][$key]['listing_id'];
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingSid);
$products = array('name' => $items['custom_item'][$key], 'type' => $type, 'listingSid' => $listingSid);
if ($listingInfo) {
if ($type == 'featuredListing') {
if (!$listingInfo['featured']) {
SJB_ListingManager::makeFeaturedBySID($listingSid);
} else {
$products['error'] = 'LISTING_ALREADY_FEATURED';
}
} else {
if ($type == 'priorityListing') {
if (!$listingInfo['priority']) {
SJB_ListingManager::makePriorityBySID($listingSid);
} else {
$products['error'] = 'LISTING_ALREADY_PRIORITY';
}
} else {
if ($type == 'activateListing') {
if (!$listingInfo['active']) {
SJB_ListingManager::activateListingBySID($listingSid);
} else {
$products['error'] = 'LISTING_ALREADY_ACTIVE';
}
}
}
}
} else {
$products['error'] = 'INVALID_LISTING_ID';
}
SJB_ShoppingCart::deleteCustomItemFromCart($userSid, $items['custom_item'][$key]);
return $products;
}
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');
}
public function execute()
{
$this->tp = SJB_System::getTemplateProcessor();
$error = null;
$post_max_size_orig = ini_get("post_max_size");
$session_maxlifetime = ini_get("session.gc_maxlifetime");
$server_content_length = isset($_SERVER['CONTENT_LENGTH']) ? $_SERVER['CONTENT_LENGTH'] : null;
$this->listingTypeID = SJB_Request::getVar('listing_type_id', false);
/**
* >>>>> for listing preview @author still
*/
$this->formSubmittedFromPreview = SJB_Request::getVar('action_add', false, 'POST') && SJB_Request::getVar('from-preview', false, 'POST');
$editTempListing = SJB_Request::getVar('edit_temp_listing', false, 'POST');
if ($this->formSubmittedFromPreview || $editTempListing) {
$listingSID = SJB_Session::getValue('preview_listing_sid_for_add');
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingSID);
if (empty($this->listingTypeID) && !empty($listingInfo)) {
// if on preview page "POST" button was pressed
if ($this->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;
}
}
}
if ($editTempListing || $this->formSubmittedFromPreview) {
$current_user = SJB_UserManager::getCurrentUser();
$this->listingTypeID = SJB_ListingTypeManager::getListingTypeIDBySID($listingInfo['listing_type_sid']);
// check wether user is owner of the temp listing
if ($listingInfo['user_sid'] != $current_user->getID()) {
$error['NOT_OWNER_OF_LISTING'] = $listingSID;
}
// set listing info and listing type id
$_REQUEST = array_merge($_REQUEST, $listingInfo);
$_REQUEST['listing_type_id'] = $this->listingTypeID;
}
}
if (empty($listingInfo)) {
$listingSID = null;
SJB_Session::unsetValue('preview_listing_sid_for_add');
}
} else {
$listingSID = null;
SJB_Session::unsetValue('preview_listing_sid_for_add');
}
/*
* <<<<< for listing preview
*/
// get post_max_size in bytes
$val = trim($post_max_size_orig);
$tmp = substr($val, strlen($val) - 1);
$tmp = strtolower($tmp);
/*
* if ini value is K - then multiply to 1024
* if ini value is M - then multiply twice: in case 'm', and case 'k'
* if ini value is G - then multiply tree times: in 'g', 'm', 'k'
*
* out value - in bytes!
*/
switch ($tmp) {
case 'g':
$val *= 1024;
case 'm':
$val *= 1024;
case 'k':
$val *= 1024;
}
$post_max_size = $val;
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$listing_id = SJB_Request::getVar('listing_id', '', 'default', 'int');
$file = SJB_UploadFileManager::openFile($filename, $listing_id);
$errors['NO_SUCH_FILE'] = true;
}
if (empty($_POST) && $server_content_length > $post_max_size) {
$errors['MAX_FILE_SIZE_EXCEEDED'] = 1;
$listing_id = SJB_Request::getVar('listing_id', null, 'GET', 'int');
$this->tp->assign('post_max_size', $post_max_size_orig);
}
$tmpListingIDFromRequest = SJB_Request::getVar('listing_id', false, 'default', 'int');
if (!empty($tmpListingIDFromRequest)) {
$tmpListingSID = $tmpListingIDFromRequest;
} elseif (!$tmpListingIDFromRequest) {
$tmpListingSID = time();
}
$this->buttonPressedPostToProceed = SJB_Request::getVar('proceed_to_posting');
if (SJB_UserManager::isUserLoggedIn()) {
SJB_Session::unsetValue('proceed_to_posting');
SJB_Session::unsetValue('productSID');
SJB_Session::unsetValue('listing_type_id');
if (!is_null($this->buttonPressedPostToProceed)) {
$productSID = SJB_Request::getVar('productSID', false, 'default', 'int');
$productInfo = SJB_ProductsManager::getProductInfoBySID($productSID);
$userInfo = SJB_UserManager::getCurrentUserInfo();
if ($userInfo['user_group_sid'] == $productInfo['user_group_sid']) {
$this->tp->assign('productSID', $productSID);
$this->tp->assign('proceed_to_posting', $productSID);
$this->tp->assign("listing_id", $tmpListingSID);
$this->addListing($listingSID, 0, $productSID);
} else {
$this->displayErrorTpl('DO_NOT_MATCH_POST_THIS_TYPE_LISTING');
}
} else {
if ($productsInfo = SJB_ListingManager::canCurrentUserAddListing($error, $this->listingTypeID)) {
if ($contractID = SJB_Request::getVar('contract_id', false, 'POST')) {
$this->tp->assign("listing_id", $tmpListingSID);
$this->addListing($listingSID, $contractID, false);
} elseif (count($productsInfo) == 1) {
$productInfo = array_pop($productsInfo);
$contractID = $productInfo['contract_id'];
$this->tp->assign("listing_id", $tmpListingSID);
$this->addListing($listingSID, $contractID, false);
} else {
$this->tp->assign('listing_id', $tmpListingSID);
$this->tp->assign('products_info', $productsInfo);
$this->tp->assign('listingTypeID', $this->listingTypeID);
$this->tp->display('listing_product_choice.tpl');
}
} else {
if ($error == 'NO_CONTRACT') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/products/?postingProductsOnly=1&page=');
}
$this->displayErrorTpl($error);
}
}
} else {
if ($this->buttonPressedPostToProceed != false) {
SJB_Session::setValue('proceed_to_posting', true);
SJB_Session::setValue('productSID', SJB_Request::getVar('productSID', '', 'default', 'int'));
SJB_Session::setValue('listing_type_id', $this->listingTypeID);
}
$this->displayErrorTpl('NOT_LOGGED_IN');
}
}
/**
* @param $listingSID
* @return string
*/
public static function getListingUrlBySID($listingSID)
{
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingSID);
$lowerListingTypeID = strtolower(SJB_ListingTypeManager::getListingTypeIDBySID($listingInfo['listing_type_sid']));
return SJB_System::getSystemSettings('USER_SITE_URL') . "/display-{$lowerListingTypeID}/{$listingInfo['id']}/";
}
public static function notifyOnUserListingDeleted($listingId)
{
$listing = SJB_ListingManager::getObjectBySID($listingId);
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingId);
$userSID = $listing->getUserSID();
if (SJB_UserNotificationsManager::isUserNotifiedOnListingDeletion($userSID) && (!isset($listingInfo['preview']) || $listingInfo['preview'] != 1)) {
$listing = SJB_ListingManager::createTemplateStructureForListing($listing);
$user = SJB_Array::get($listing, 'user');
$userGroupSID = SJB_Array::get($user, 'user_group_sid');
$emailTplSID = SJB_UserGroupManager::getEmailTemplateSIDByUserGroupAndField($userGroupSID, 'notify_user_on_listing_deletion');
$data = array('user' => $user, 'listing' => $listing);
$email = SJB_EmailTemplateEditor::getEmail($user['email'], $emailTplSID, $data);
return $email->send('User Listing Deleted');
}
return null;
}
private static function changeComplexFileProperties(&$exportProperties, &$exportData, $file_type)
{
$file_properties_info = SJB_ListingComplexFieldManager::getFieldsInfoByType($file_type);
foreach ($file_properties_info as $property_info) {
$parent_property_info = SJB_ListingFieldManager::getFieldInfoBySID($property_info['field_sid']);
if (isset($exportProperties[$parent_property_info['id']])) {
// listings walkthrough
foreach ($exportData as $listing_sid => $property) {
$listing_info = SJB_ListingManager::getListingInfoBySID($listing_sid);
if (!isset($listing_info[$parent_property_info['id']][$property_info['id']]) || !is_array($listing_info[$parent_property_info['id']])) {
continue;
}
$file_values = $listing_info[$parent_property_info['id']][$property_info['id']];
if (!empty($file_values)) {
foreach ($file_values as $file_value) {
if ($file_value) {
$file_name = SJB_UploadFileManager::getUploadedSavedFileName($file_value);
$file_group = SJB_UploadFileManager::getUploadedFileGroup($file_value);
$file_path = SJB_ExportController::_getUploadedFileURL($file_name, $file_group);
$file_export_path = SJB_ExportController::_getFileExportURL($file_name, $file_group, $listing_sid, $file_name);
@copy($file_path, $file_export_path);
}
}
}
}
}
}
}
public function execute()
{
$errors = array();
$field_errors = array();
$tp = SJB_System::getTemplateProcessor();
$loggedIn = SJB_UserManager::isUserLoggedIn();
$current_user_sid = SJB_UserManager::getCurrentUserSID();
$controller = new SJB_SendListingInfoController($_REQUEST);
$isDataSubmitted = false;
$jobInfo = SJB_ListingManager::getListingInfoBySID($controller->getListingID());
if ($controller->isListingSpecified()) {
if ($controller->isDataSubmitted()) {
if (SJB_Captcha::getInstance($tp, $_REQUEST)->isValid($errors)) {
// получим уникальный id для файла в uploaded_files
$file_id_current = 'application_' . md5(microtime());
$upload_manager = new SJB_UploadFileManager();
$upload_manager->setFileGroup('files');
$upload_manager->setUploadedFileID($file_id_current);
$file_name = $upload_manager->uploadFile('file_tmp');
$id_file = $upload_manager->fileId;
$post = $controller->getData();
$listingId = 0;
$post['submitted_data']['questionnaire'] = '';
if (isset($post['submitted_data']['id_resume'])) {
$listingId = $post['submitted_data']['id_resume'];
}
$mimeType = isset($_FILES['file_tmp']['type']) ? $_FILES['file_tmp']['type'] : '';
if (isset($_FILES['file_tmp']['size']) && $file_name != '' && $_FILES['file_tmp']['size'] == 0) {
$errors['FILE_IS_EMPTY'] = 'The uploaded file should not be blank';
}
if (!empty($_FILES['file_tmp']['name'])) {
$fileFormats = explode(',', SJB_System::getSettingByName('file_valid_types'));
$fileInfo = pathinfo($_FILES['file_tmp']['name']);
if (!isset($fileInfo['extension']) || !in_array(strtolower($fileInfo['extension']), $fileFormats)) {
$errors['NOT_SUPPORTED_FILE_FORMAT'] = strtolower($fileInfo['extension']) . ' ' . SJB_I18N::getInstance()->gettext(null, 'is not in an acceptable file format');
}
}
if ($file_name == '' && $listingId == 0) {
$canAppplyWithoutResume = false;
SJB_Event::dispatch('CanApplyWithoutResume', $canAppplyWithoutResume);
if (!$canAppplyWithoutResume) {
$errors['APPLY_INPUT_ERROR'] = 'Please select file or resume';
}
} else {
if (SJB_Applications::isApplied($post['submitted_data']['listing_id'], $current_user_sid) && !is_null($current_user_sid)) {
$errors['APPLY_APPLIED_ERROR'] = 'You already applied';
}
}
$res = false;
$listing_info = '';
$notRegisterUserData = $_POST;
$score = 0;
// для зарегестрированного пользователя получим поля email и name
// для незарегестрированных - поля name и email приходят с формы
if ($loggedIn === true) {
$userData = SJB_UserManager::getCurrentUserInfo();
$post['submitted_data']['username'] = isset($userData['username']) ? $userData['username'] : '';
$post['submitted_data']['LastName'] = isset($userData['LastName']) ? $userData['LastName'] : '';
$post['submitted_data']['FirstName'] = isset($userData['FirstName']) ? $userData['FirstName'] : '';
$post['submitted_data']['name'] = $post['submitted_data']['FirstName'] . ' ' . $post['submitted_data']['LastName'];
$post['submitted_data']['email'] = $userData['email'];
}
if (!empty($jobInfo['screening_questionnaire'])) {
$questions = new SJB_Questions($_REQUEST, $jobInfo['screening_questionnaire']);
$add_form = new SJB_Form($questions);
$add_form->registerTags($tp);
$add_form->isDataValid($field_errors);
$tp->assign('field_errors', $field_errors);
if (!$field_errors) {
$result = array();
$properties = $questions->getProperties();
$countAnswers = 0;
foreach ($properties as $key => $val) {
if ($val->type->property_info['type'] == 'boolean') {
switch ($val->value) {
case 0:
$val->value = 'No';
break;
case 1:
$val->value = 'Yes';
break;
}
}
$result[$val->caption] = $val->value;
if (isset($val->type->property_info['list_values'])) {
foreach ($val->type->property_info['list_values'] as $list_values) {
if (is_array($val->value)) {
foreach ($val->value as $value) {
if ($value == $list_values['id'] && $list_values['score'] != 'no') {
$score += $list_values['score'];
$countAnswers++;
}
}
} else {
if ($val->value == $list_values['id'] && $list_values['score'] != 'no') {
$score += $list_values['score'];
$countAnswers++;
}
}
}
}
}
if ($countAnswers === 0) {
$score = 0.0;
} else {
$score = round($score / $countAnswers, 2);
}
$post['submitted_data']['questionnaire'] = serialize($result);
}
}
if (count($errors) == 0 && count($field_errors) == 0) {
$res = SJB_Applications::create($post['submitted_data']['listing_id'], $current_user_sid, isset($post['submitted_data']['id_resume']) ? $post['submitted_data']['id_resume'] : '', $post['submitted_data']['comments'], $file_name, $mimeType, $id_file, isset($post['submitted_data']['anonymous']) ? $post['submitted_data']['anonymous'] : '0', $notRegisterUserData, $post['submitted_data']['questionnaire'], $score);
if ($res) {
SJB_Statistics::addStatistics('apply', $post['submitted_data']['listing_id'], $res);
}
if (isset($post['submitted_data']['id_resume']) && $post['submitted_data']['id_resume'] != 0) {
$listing_info = SJB_ListingManager::getListingInfoBySID($post['submitted_data']['id_resume']);
$emp_sid = SJB_ListingManager::getUserSIDByListingSID($post['submitted_data']['listing_id']);
$accessible = SJB_ListingManager::isListingAccessableByUser($post['submitted_data']['id_resume'], $emp_sid);
if (!$accessible) {
SJB_ListingManager::setListingAccessibleToUser($post['submitted_data']['id_resume'], $emp_sid);
}
}
if (!empty($file_name)) {
$file_name = 'files/files/' . $file_name;
}
SJB_Notifications::sendApplyNow($post, $file_name, $listing_info, $current_user_sid, $notRegisterUserData, $score);
if (!empty($jobInfo['screening_questionnaire'])) {
$questionnaire = SJB_ScreeningQuestionnaires::getInfoBySID($jobInfo['screening_questionnaire']);
if ($questionnaire) {
$passing_score = 0;
switch ($questionnaire['passing_score']) {
case 'acceptable':
$passing_score = 1;
break;
case 'good':
$passing_score = 2;
break;
case 'very_good':
$passing_score = 3;
break;
case 'excellent':
$passing_score = 4;
break;
}
}
if ($score >= $passing_score && $questionnaire['send_auto_reply_more'] == 1) {
if (!empty($questionnaire['email_text_more'])) {
SJB_Notifications::userAutoReply($jobInfo, $current_user_sid, $questionnaire['email_text_more'], $notRegisterUserData);
}
} elseif ($score < $passing_score && $questionnaire['send_auto_reply_less'] == 1) {
if (!empty($questionnaire['email_text_less'])) {
SJB_Notifications::userAutoReply($jobInfo, $current_user_sid, $questionnaire['email_text_less'], $notRegisterUserData);
}
}
}
}
if ($res === false) {
$errors['APPLY_ERROR'] = 'Cannot apply';
}
$isDataSubmitted = true;
}
}
if (!empty($jobInfo['screening_questionnaire'])) {
$questions = new SJB_Questions($_REQUEST, $jobInfo['screening_questionnaire']);
$add_form = new SJB_Form($questions);
$add_form->registerTags($tp);
$form_fields = $add_form->getFormFieldsInfo();
$tp->assign('form_fields', $form_fields);
$tp->assign('questionsObject', $questions);
}
if ($loggedIn) {
$listing_type_sid = SJB_ListingTypeManager::getListingTypeSIDByID('Resume');
$wait_approve = SJB_ListingTypeManager::getWaitApproveSettingByListingType($listing_type_sid);
$approve_status = '';
if ($wait_approve) {
$approve_status = "AND `l`.`status` = 'approved'";
}
$result = SJB_DB::query("SELECT `l`.`sid` , `l`.`Title` FROM `listings` as `l`\n\t\t\t\tLEFT JOIN `listing_types` as `lt` ON (`lt`.`sid` = `l`.`listing_type_sid`)\n\t\t\t\tWHERE `lt`.`id` = 'Resume' {$approve_status} AND `l`.`user_sid` = {$current_user_sid} AND `l`.`active`");
$resume = array();
foreach ($result as $val) {
$resume[$val['sid']] = $val['Title'];
}
$tp->assign('resume', $resume);
}
$tp->assign('listing', $jobInfo);
} else {
$errors['UNDEFINED_LISTING_ID'] = true;
}
$tp->assign('request', $_REQUEST);
$tp->assign('errors', $errors);
$tp->assign('listing_id', $controller->getListingID());
$tp->assign('is_data_submitted', $isDataSubmitted);
$tp->display('apply_now.tpl');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$displayTemplate = 'view.tpl';
$errors = array();
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$appsID = SJB_Request::getVar('appsID', false);
if ($appsID) {
$file = SJB_UploadFileManager::openApplicationFile($filename, $appsID);
if (!$file) {
$errors['NO_SUCH_FILE'] = true;
}
} else {
$errors['NO_SUCH_APPS'] = true;
}
}
$cu = SJB_UserManager::getUserInfoBySID(SJB_Request::getVar('user_sid', null));
$tp->assign('user_sid', $cu['sid']);
$tp->assign('username', $cu['username']);
$appJobId = SJB_Request::getVar('appJobId', false);
// посортируем чего-нибуть
$orderBy = SJB_Request::getVar('orderBy', 'date');
$order = SJB_Request::getVar('order', 'desc');
$tp->assign('orderBy', $orderBy);
$tp->assign('order', $order);
if (!empty($orderBy) && isset($order)) {
switch ($orderBy) {
case 'date':
$orderInfo = array('sorting_field' => 'date', 'sorting_order' => $order);
break;
case 'title':
$orderInfo = array('sorting_field' => 'Title', 'sorting_order' => $order, 'inner_join' => array('table' => 'listings', 'field1' => 'sid', 'field2' => 'listing_id'));
break;
case 'applicant':
$orderInfo = false;
$sortByUsername = true;
break;
case 'status':
$orderInfo = array('sorting_field' => 'status', 'sorting_order' => $order);
break;
case 'company':
$orderInfo = array('sorting_field' => 'CompanyName', 'sorting_order' => $order, 'inner_join' => array('table' => 'listings', 'field1' => 'sid', 'field2' => 'listing_id'), 'inner_join2' => array('table1' => 'users', 'table2' => 'listings', 'field1' => 'sid', 'field2' => 'user_sid'));
break;
}
}
if ($cu['user_group_sid'] == 41) {
// Работадатель
if (isset($_REQUEST['action'])) {
switch ($_REQUEST['action']) {
case 'approve':
if (isset($_POST['applications'])) {
foreach ($_POST['applications'] as $key => $value) {
SJB_Applications::accept($key);
}
}
break;
case 'reject':
if (isset($_POST['applications'])) {
foreach ($_POST['applications'] as $key => $value) {
SJB_Applications::reject($key);
}
}
break;
case 'delete':
if (isset($_POST['applications'])) {
foreach ($_POST['applications'] as $key => $value) {
SJB_Applications::hideEmp($key);
}
}
break;
}
}
if ($appJobId) {
$apps = SJB_Applications::getByJob($appJobId, $orderInfo);
} else {
$apps = SJB_Applications::getByEmployer($cu['sid'], $orderInfo);
}
for ($i = 0; $i < count($apps); ++$i) {
$apps[$i]['job'] = SJB_ListingManager::getListingInfoBySID($apps[$i]['listing_id']);
if (isset($apps[$i]['resume']) && !empty($apps[$i]['resume'])) {
$apps[$i]['resumeInfo'] = SJB_ListingManager::getListingInfoBySID($apps[$i]['resume']);
}
if ($apps[$i]['jobseeker_id'] == 0) {
$apps[$i]['user']['FirstName'] = $apps[$i]['username'];
} else {
$apps[$i]['user'] = SJB_UserManager::getUserInfoBySID($apps[$i]['jobseeker_id']);
}
}
$jobs = SJB_ListingManager::getListingsByUserSID($cu['sid']);
$appJobs = array();
foreach ($jobs as $job) {
$appJobs[] = array('title' => $job->details->properties['Title']->value, 'id' => $job->sid);
}
$tp->assign('appJobs', $appJobs);
$tp->assign('current_filter', $appJobId);
} else {
// Соискатель
if (SJB_Request::getVar('action', '', SJB_Request::METHOD_POST) == 'Delete selected') {
if (isset($_POST['applications'])) {
foreach ($_POST['applications'] as $key => $value) {
SJB_Applications::hideJS($key);
}
}
}
$apps = SJB_Applications::getByJobseeker($cu['sid'], $orderInfo);
for ($i = 0; $i < count($apps); ++$i) {
$apps[$i]['job'] = SJB_ListingManager::getListingInfoBySID($apps[$i]['listing_id']);
$apps[$i]['company'] = SJB_UserManager::getUserInfoBySID($apps[$i]['job']['user_sid']);
}
$displayTemplate = 'view_seeker.tpl';
}
if (isset($sortByUsername)) {
$order = $order == 'desc' ? SORT_DESC : SORT_ASC;
foreach ($apps as $key => $value) {
if (!isset($apps[$key]['user']['FirstName'])) {
$apps[$key]['user']['FirstName'] = '';
}
if (!isset($apps[$key]['user']['LastName'])) {
$apps[$key]['user']['LastName'] = '';
}
$sortKeys[$key] = $apps[$key]['user']['FirstName'] . ' ' . $apps[$key]['user']['LastName'];
}
if ($apps) {
array_multisort($sortKeys, $order, SORT_REGULAR, $apps);
}
}
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($cu['user_group_sid']);
SJB_System::setGlobalTemplateVariable('wikiExtraParam', $userGroupInfo['id']);
$tp->assign('METADATA', SJB_Application::getApplicationMeta());
$tp->assign("user_group_info", $userGroupInfo);
$tp->assign('applications', $apps);
$tp->assign('errors', $errors);
$tp->display($displayTemplate);
}
