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');
}
}
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()
{
$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');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$listingTypeID = SJB_Request::getVar('listing_type_id', null);
$listingTypeSID = SJB_ListingTypeManager::getListingTypeSIDByID($listingTypeID);
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listingTypeSID);
$productSID = SJB_Request::getVar('product_sid', false);
$editUser = SJB_Request::getVar('edit_user', false);
$action = SJB_Request::getVar('action', false);
$username = SJB_Request::getVar('username', false);
$errors = array();
if ($username && ($userSID = SJB_UserManager::getUserSIDbyUsername($username))) {
$userInfo = SJB_UserManager::getUserInfoBySID($userSID);
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($userInfo['user_group_sid']);
if (!$productSID) {
$products = SJB_ProductsManager::getProductsInfoByUserGroupSID($userGroupInfo['sid']);
foreach ($products as $key => $product) {
if (empty($product['listing_type_sid']) || $product['listing_type_sid'] != $listingTypeSID) {
unset($products[$key]);
}
}
if ($action == 'productVerify') {
$errors['PRODUCT_NOT_SELECTED'] = 1;
}
$tp->assign('errors', $errors);
$tp->assign('username', $username);
$tp->assign('products', $products);
$tp->assign('edit_user', $editUser);
$tp->assign('userSID', $userSID);
$tp->assign('userGroupInfo', $userGroupInfo);
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->display('select_product.tpl');
} else {
$form_submitted = SJB_Request::getVar('action', '') == 'add';
$tmp_listing_id_from_request = SJB_Request::getVar('listing_id', false, 'default', 'int');
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();
}
$productInfo = SJB_ProductsManager::getProductInfoBySID($productSID);
$extraInfo = is_null($productInfo['serialized_extra_info']) ? null : unserialize($productInfo['serialized_extra_info']);
if (!empty($extraInfo)) {
$extraInfo['product_sid'] = $productSID;
}
$_REQUEST['featured'] = !empty($_REQUEST['featured']) ? $_REQUEST['featured'] : $productInfo['featured'];
$_REQUEST['priority'] = !empty($_REQUEST['priority']) ? $_REQUEST['priority'] : $productInfo['priority'];
$listing = new SJB_Listing($_REQUEST, $listingTypeSID);
$properties = $listing->getPropertyList();
foreach ($properties as $property) {
$propertyInfo = $listing->getPropertyInfo($property);
$propertyInfo['user_sid'] = $userSID;
if ($propertyInfo['type'] == 'location') {
$child = $listing->getChild($property);
$childProperties = $child->getPropertyList();
foreach ($childProperties as $childProperty) {
$childPropertyInfo = $child->getPropertyInfo($childProperty);
$childPropertyInfo['user_sid'] = $userSID;
$child->setPropertyInfo($childProperty, $childPropertyInfo);
}
}
$listing->setPropertyInfo($property, $propertyInfo);
}
$listing->deleteProperty('status');
$listing->deleteProperty('reject_reason');
$access_type = $listing->getProperty('access_type');
if ($form_submitted) {
if (!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($userSID);
if (SJB_Acl::getInstance()->isAllowed('use_screening_questionnaires') && $screening_questionnaires) {
$issetQuestionnairyField = $listing->getProperty('screening_questionnaire');
if ($issetQuestionnairyField) {
$value = SJB_Request::getVar("screening_questionnaire");
$listing_info = $_REQUEST;
$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($userSID), 'is_system' => true));
}
} else {
$listing->deleteProperty('screening_questionnaire');
}
if ($listing->getProperty('captcha')) {
$listing->deleteProperty('captcha');
}
$add_listing_form = new SJB_Form($listing);
$add_listing_form->registerTags($tp);
$field_errors = array();
if ($form_submitted && $add_listing_form->isDataValid($field_errors)) {
$listing->addProperty(array('id' => 'complete', 'type' => 'integer', 'value' => 1, 'is_system' => true));
$listing->setUserSID($userSID);
$listing->setProductInfo($extraInfo);
if (empty($access_type->value)) {
$listing->setPropertyValue('access_type', 'everyone');
}
SJB_ListingManager::saveListing($listing);
SJB_Statistics::addStatistics('addListing', $listing->getListingTypeSID(), $listing->getSID(), false, $_REQUEST['featured'], $_REQUEST['priority'], $userSID);
if (isset($_SESSION['tmp_file_storage'])) {
foreach ($_SESSION['tmp_file_storage'] as $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');
}
$formToken = SJB_Request::getVar('form_token');
$sessionFilesStorage = SJB_Session::getValue('tmp_uploads_storage');
$uploadedFields = SJB_Array::getPath($sessionFilesStorage, $formToken);
if (!empty($uploadedFields)) {
foreach ($uploadedFields as $fieldId => $fieldValue) {
// get field of listing
$isComplex = false;
if (strpos($fieldId, ':') !== false) {
$isComplex = true;
}
$tmpUploadedFileId = $fieldValue['file_id'];
// rename it to real listing field value
$newFileId = $fieldId . "_" . $listing->getSID();
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` =?s", $newFileId, $tmpUploadedFileId);
if ($isComplex) {
list($parentField, $subField, $complexStep) = explode(':', $fieldId);
$parentProp = $listing->getProperty($parentField);
$parentValue = $parentProp->getValue();
// look for complex property with current $fieldID and set it to new value of property
if (!empty($parentValue)) {
foreach ($parentValue as $id => $value) {
if ($id == $subField) {
$parentValue[$id][$complexStep] = $newFileId;
}
}
$listing->setPropertyValue($parentField, $parentValue);
}
} else {
$listing->setPropertyValue($fieldId, $newFileId);
}
// unset value from session temporary storage
$sessionFilesStorage = SJB_Array::unsetValueByPath($sessionFilesStorage, "{$formToken}/{$fieldId}");
}
//and remove token key from temporary storage
$sessionFilesStorage = SJB_Array::unsetValueByPath($sessionFilesStorage, "{$formToken}");
SJB_Session::setValue('tmp_uploads_storage', $sessionFilesStorage);
SJB_ListingManager::saveListing($listing);
}
SJB_ListingManager::activateListingBySID($listing->getSID());
SJB_ProductsManager::incrementPostingsNumber($productSID);
$listingSid = $listing->getSID();
SJB_Event::dispatch('listingSaved', $listingSid);
if ($editUser) {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/edit-user/?user_sid=" . $userSID);
} else {
if ($listingTypeID == 'resume' || $listingTypeID == 'job') {
$link = "manage-" . strtolower($listingTypeID) . "s";
} else {
$link = "manage-" . strtolower($listingTypeID) . "-listings";
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/{$link}/?action=search&listing_type_sid=" . $listingTypeSID);
}
} else {
$listing->deleteProperty('access_list');
$listing->deleteProperty('contract_id');
$add_listing_form = new SJB_Form($listing);
if ($form_submitted) {
$add_listing_form->isDataValid($field_errors);
}
$add_listing_form->registerTags($tp);
$form_fields = $add_listing_form->getFormFieldsInfo();
$pages = SJB_PostingPagesManager::getPagesByListingTypeSID($listingTypeSID);
$formFieldsSorted = array();
$formFieldsSorted['featured'] = $form_fields['featured'];
$formFieldsSorted['priority'] = $form_fields['priority'];
foreach ($pages as $page) {
$listing_fields = SJB_PostingPagesManager::getAllFieldsByPageSIDForForm($page['sid']);
foreach (array_keys($listing_fields) as $field) {
if ($listing->propertyIsSet($field)) {
$formFieldsSorted[$field] = $form_fields[$field];
}
}
}
$form_fields = $formFieldsSorted;
//SJB_HelperFunctions::d($form_fields);
$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);
}
$numberOfPictures = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$tp->assign("pic_limit", $numberOfPictures);
$tp->assign("listing_id", $tmp_listing_sid);
$tp->assign("listing_access_list", $employers);
$tp->assign("errors", $field_errors);
$tp->assign("form_fields", $form_fields);
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign("METADATA", array("form_fields" => $metaDataProvider->getFormFieldsMetadata($form_fields)));
}
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->assign('edit_user', $editUser);
$tp->assign('productInfo', $productInfo);
$tp->assign('username', $username);
$tp->assign('product_sid', $productSID);
$tp->assign('userSID', $userSID);
$tp->assign('userGroupInfo', $userGroupInfo);
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->display('input_form.tpl');
}
} else {
if ($username && !$userSID) {
$errors['USER_NOT_FOUND'] = 1;
} elseif ($action == 'userVerify') {
$errors['USER_NOT_SELECTED'] = 1;
}
$tp->assign('errors', $errors);
$tp->assign('username', $username);
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->display('select_user.tpl');
}
}
/**
* @param $listingSID
* @param $contractID
* @param $productSID
*/
public function addListing($listingSID, $contractID = false, $productSID = false)
{
if ($productSID != false) {
$extraInfo = SJB_ProductsManager::getProductExtraInfoBySID($productSID);
$extraInfo['product_sid'] = (string) $extraInfo['product_sid'];
} else {
$contract = new SJB_Contract(array('contract_id' => $contractID));
$extraInfo = $contract->extra_info;
}
$numberOfPictures = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$this->tp->assign("pic_limit", $numberOfPictures);
$listingTypesInfo = SJB_ListingTypeManager::getAllListingTypesInfo();
if (!$this->listingTypeID && count($listingTypesInfo) == 1) {
$listingTypeInfo = array_pop($listingTypesInfo);
$this->listingTypeID = $listingTypeInfo['id'];
}
$listingTypeSID = SJB_ListingTypeManager::getListingTypeSIDByID($this->listingTypeID);
$pages = SJB_PostingPagesManager::getPagesByListingTypeSID($listingTypeSID);
$pageSID = $this->getPageSID($pages, $listingTypeSID);
$isPageLast = SJB_PostingPagesManager::isLastPageByID($pageSID, $listingTypeSID);
$isPreviewListingRequested = SJB_Request::getVar('preview_listing', false, 'POST');
if (($contractID || !empty($this->buttonPressedPostToProceed)) && $this->listingTypeID) {
$formSubmitted = isset($_REQUEST['action_add']) || isset($_REQUEST['action_add_pictures']) || $isPreviewListingRequested;
/*
* social plugin
* complete listing of data from an array of social data
* if is allowed
*/
$aAutoFillData = array('formSubmitted' => &$formSubmitted, 'listingTypeID' => &$this->listingTypeID);
SJB_Event::dispatch('SocialSynchronization', $aAutoFillData);
/*
* end of "social plugin"
*/
$listing = new SJB_Listing($_REQUEST, $listingTypeSID, $pageSID);
$listing->deleteProperty('featured');
$listing->deleteProperty('priority');
$listing->deleteProperty('status');
$listing->deleteProperty('reject_reason');
$listing->deleteProperty('ListingLogo');
$access_type = $listing->getProperty('access_type');
if ($formSubmitted) {
if (!empty($access_type)) {
$listing->addProperty(array('id' => 'access_list', 'type' => 'multilist', 'value' => SJB_Request::getVar("list_emp_ids"), 'is_system' => true));
}
$listing->addProperty(array('id' => 'contract_id', 'type' => 'id', 'value' => $contractID, 'is_system' => true));
}
$currentUser = SJB_UserManager::getCurrentUser();
$screeningQuestionnaires = SJB_ScreeningQuestionnaires::getList($currentUser->getSID());
if (SJB_Acl::getInstance()->isAllowed('use_screening_questionnaires') && $screeningQuestionnaires) {
$issetQuestionnairyField = $listing->getProperty('screening_questionnaire');
if ($issetQuestionnairyField) {
$value = SJB_Request::getVar("screening_questionnaire");
$listingInfo = $_REQUEST;
$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 if sync is turned off in admin part
*/
$aAutoFillData = array('oListing' => &$listing, 'userSID' => $currentUser->getSID(), 'listingTypeID' => $this->listingTypeID, 'listing_info' => $_REQUEST);
SJB_Event::dispatch('SocialSynchronizationFields', $aAutoFillData);
/*
* end of social plugin "sync"
*/
$listingFormAdd = new SJB_Form($listing);
$listingFormAdd->registerTags($this->tp);
$fieldErrors = array();
if ($formSubmitted && ($this->formSubmittedFromPreview || $listingFormAdd->isDataValid($fieldErrors))) {
if ($isPageLast) {
$listing->addProperty(array('id' => 'complete', 'type' => 'integer', 'value' => 1, 'is_system' => true));
}
$listing->setUserSID($currentUser->getSID());
$listing->setProductInfo($extraInfo);
if (empty($access_type->value)) {
$listing->setPropertyValue('access_type', 'everyone');
}
if ($currentUser->isSubuser()) {
$subuserInfo = $currentUser->getSubuserInfo();
$listing->addSubuserProperty($subuserInfo['sid']);
}
/**
* >>>>> listing preview @author still
*/
if (!empty($listingSID)) {
$listing->setSID($listingSID);
}
/*
* <<<<< listing preview
*/
SJB_ListingManager::saveListing($listing);
if (!empty($this->buttonPressedPostToProceed)) {
SJB_ListingManager::unmakeCheckoutedBySID($listing->getSID());
}
SJB_Statistics::addStatistics('addListing', $listing->getListingTypeSID(), $listing->getSID(), false, $extraInfo['featured'], $extraInfo['priority']);
if ($contractID) {
$contract = new SJB_Contract(array('contract_id' => $contractID));
$contract->incrementPostingsNumber();
SJB_ProductsManager::incrementPostingsNumber($contract->product_sid);
}
if (SJB_Session::getValue('tmp_file_storage')) {
foreach ($_SESSION['tmp_file_storage'] as $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_ListingManager::saveListing($listing);
$keywords = $listing->getKeywords();
SJB_ListingManager::updateKeywords($keywords, $listing->getSID());
}
// <<< SJB-1197
if ($isPageLast && !$isPreviewListingRequested) {
/* delete temp preview listing sid */
SJB_Session::unsetValue('preview_listing_sid_for_add');
// Start Event
$listingSid = $listing->getSID();
SJB_Event::dispatch('listingSaved', $listingSid);
if ($extraInfo['featured']) {
SJB_ListingManager::makeFeaturedBySID($listing->getSID());
}
if ($extraInfo['priority']) {
SJB_ListingManager::makePriorityBySID($listing->getSID());
}
if (!empty($this->buttonPressedPostToProceed)) {
$this->proceedToCheckout($currentUser->getSID(), $productSID);
} else {
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($this->listingTypeID) . '/?listing_id=' . $listing->getSID());
}
}
} elseif ($isPageLast && $isPreviewListingRequested) {
// for listing preview
SJB_Session::setValue('preview_listing_sid_for_add', $listing->getSID());
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/' . strtolower($this->listingTypeID) . '-preview/' . $listing->getSID() . '/');
} else {
// listing steps (pages)
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/add-listing/{$this->listingTypeID}/" . SJB_PostingPagesManager::getNextPage($pageSID) . "/" . $listing->getSID());
}
} else {
$listing->deleteProperty('access_list');
$listing->deleteProperty('contract_id');
$listingFormAdd = new SJB_Form($listing);
if ($formSubmitted) {
$listingFormAdd->isDataValid($fieldErrors);
}
$listingFormAdd->registerTags($this->tp);
$template = isset($_REQUEST['input_template']) ? $_REQUEST['input_template'] : "input_form.tpl";
$formFields = $listingFormAdd->getFormFieldsInfo();
$employersList = SJB_Request::getVar('list_emp_ids', false);
$employers = array();
if (is_array($employersList)) {
foreach ($employersList as $emp) {
$currEmp = SJB_UserManager::getUserInfoBySID($emp);
$employers[] = array('user_id' => $emp, 'value' => $currEmp['CompanyName']);
}
sort($employers);
}
$this->tp->assign('form_token', SJB_Request::getVar('form_token'));
$this->tp->assign("account_activated", SJB_Request::getVar('account_activated', ''));
$this->tp->assign("contract_id", $contractID);
$this->tp->assign("listing_access_list", $employers);
$this->tp->assign("listingTypeID", $this->listingTypeID);
$this->tp->assign('listingTypeStructure', SJB_ListingTypeManager::createTemplateStructure(SJB_ListingTypeManager::getListingTypeInfoBySID($listing->listing_type_sid)));
$this->tp->assign("field_errors", $fieldErrors);
$this->tp->assign("form_fields", $formFields);
$this->tp->assign("pages", $pages);
$this->tp->assign("pageSID", $pageSID);
$this->tp->assign("extraInfo", $extraInfo);
$this->tp->assign("currentPage", SJB_PostingPagesManager::getPageInfoBySID($pageSID));
$this->tp->assign("isPageLast", $isPageLast);
$this->tp->assign("nextPage", SJB_PostingPagesManager::getNextPage($pageSID));
$this->tp->assign("prevPage", SJB_PostingPagesManager::getPrevPage($pageSID));
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$this->tp->assign("METADATA", array("form_fields" => $metaDataProvider->getFormFieldsMetadata($formFields)));
/*
* social plugin
* only for Resume listing types
*/
$aAutoFillData = array('tp' => &$this->tp, 'listingTypeID' => &$this->listingTypeID, 'userSID' => $currentUser->getSID());
SJB_Event::dispatch('SocialSynchronizationForm', $aAutoFillData);
/*
* social plugin
*/
$this->tp->display($template);
}
}
}
public function execute()
{
$listingTypeSid = SJB_Request::getVar('listing_type_sid', false);
$template_processor = SJB_System::getTemplateProcessor();
if (isset($_REQUEST['restore']) && isset($listingSearcher['criteria_values']['listing_type_sid'])) {
$listingSearcher = SJB_Session::getValue('ListingSearcher', null);
$listingTypeSid = $listingSearcher['criteria_values']['listing_type_sid']['equal'];
}
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listingTypeSid);
$template_processor->assign('showApprovalStatusField', $listingTypeInfo['waitApprove']);
$template_processor->assign('listingsType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$show_search_form = true;
if (empty($_REQUEST['action']) && empty($_REQUEST['restore'])) {
$show_search_form = false;
}
$template_processor->assign('show_search_form', $show_search_form);
/**************** S E A R C H F O R M ****************/
$listing = SJB_ObjectMother::createListing(array(), $listingTypeSid);
$id_alias_info = $listing->addIDProperty();
$username_alias_info = $listing->addUsernameProperty();
$productAliasInfo = $listing->addProductProperty($listingTypeSid);
$listing->addCompanyNameProperty();
$listing->addActivationDateProperty();
$listing->addExpirationDateProperty();
$listing->addActiveProperty();
$listing->addKeywordsProperty();
$listing->addDataSourceProperty();
$listing->addPriorityProperty();
$aliases = new SJB_PropertyAliases();
$aliases->addAlias($username_alias_info);
$aliases->addAlias($id_alias_info);
$aliases->addAlias($productAliasInfo);
$search_form_builder = new SJB_SearchFormBuilder($listing);
$criteria_saver = SJB_ObjectMother::createListingCriteriaSaver();
$keywords = NULL;
if (isset($_REQUEST['restore'])) {
$_REQUEST = array_merge($_REQUEST, $criteria_saver->getCriteria());
$criteria = $criteria_saver->getCriteria();
$listingSid = SJB_Array::getPath($criteria, 'sid') ? $criteria['sid']['equal'] : '';
$keywords = SJB_Array::getPath($criteria, 'keywords') ? $criteria['keywords']['like'] : $listingSid;
}
if ($listingTypeSid) {
$_REQUEST['listing_type_sid'] = array('equal' => $listingTypeSid);
}
$template_processor->assign('companyName', isset($_REQUEST['company_name']['like']) ? $_REQUEST['company_name']['like'] : '');
$template_processor->assign('idKeyword', isset($_REQUEST['idKeyword']) ? $_REQUEST['idKeyword'] : $keywords);
$this->prepareRequestedCriteria();
$criteria = SJB_SearchFormBuilder::extractCriteriaFromRequestData($_REQUEST, $listing);
$search_form_builder->setCriteria($criteria);
$search_form_builder->registerTags($template_processor);
$template_processor->display("manage_listings.tpl");
/************* S E A R C H F O R M R E S U L T S *************/
$paginator = new SJB_ListingPagination($listingTypeInfo);
$searcher = SJB_ObjectMother::createListingSearcher();
$inner_join = array();
if (SJB_Request::getVar('action', '') == 'search' || isset($_REQUEST['restore'])) {
if (!isset($_REQUEST['restore'])) {
$criteria_saver->resetSearchResultsDisplay();
}
if (isset($_REQUEST['company_name']['like']) && $_REQUEST['company_name']['like'] != '') {
$inner_join = array('users' => array('join_field' => 'sid', 'join_field2' => 'user_sid', 'main_table' => 'listings', 'join' => 'INNER JOIN'));
}
$foundListingsSIDs = $searcher->getObjectsSIDsByCriteria($criteria, $aliases, array(), $inner_join);
//get found listing sids
if (empty($foundListingsSIDs) && $paginator->currentPage != 1) {
if ($listingTypeInfo['id'] == 'Job' || $listingTypeInfo['id'] == 'Resume') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-' . strtolower($listingTypeInfo['id']) . 's/?page=1&restore=1');
} else {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-' . strtolower($listingTypeInfo['id']) . '-listings/?page=1&restore=1');
}
}
$criteria_saver->setSessionForListingsPerPage($paginator->itemsPerPage);
$criteria_saver->setSessionForCurrentPage($paginator->currentPage);
$criteria_saver->setSessionForCriteria($_REQUEST);
$orderInfo = array('sorting_field' => $paginator->sortingField, 'sorting_order' => $paginator->sortingOrder);
$criteria_saver->setSessionForOrderInfo($orderInfo);
} else {
$criteria_saver->resetSearchResultsDisplay();
return;
}
$criteria_saver->setSessionForObjectSIDs($foundListingsSIDs);
$listing_search_structure = $criteria_saver->createTemplateStructureForSearch();
/**************** S O R T I N G *****************/
$empty_listing = SJB_ObjectMother::createListing(array(), $listingTypeSid);
$empty_listing->addPicturesProperty();
$empty_listing->addIDProperty();
$empty_listing->addListingTypeIDProperty();
$empty_listing->addActivationDateProperty();
$empty_listing->addExpirationDateProperty();
$empty_listing->addUsernameProperty();
$empty_listing->addPicturesProperty();
$empty_listing->addNumberOfViewsProperty();
$empty_listing->addActiveProperty();
$empty_listing->addKeywordsProperty();
$empty_listing->addDataSourceProperty();
$listing->addRejectReasonProperty();
if ($empty_listing->propertyIsSet($listing_search_structure['sorting_field']) && !empty($foundListingsSIDs)) {
$sorting_field = $listing_search_structure['sorting_field'];
$sorting_order = $listing_search_structure['sorting_order'];
switch ($sorting_field) {
case 'username':
$ids = join(", ", $foundListingsSIDs);
$sql = "\tSELECT\t\tlistings.*\n\t\t\t\t\t\tFROM \t\tlistings\n\t\t\t\t\t\tLEFT JOIN\tusers on listings.user_sid = users.sid\n\t\t\t\t\t\tWHERE \t\tlistings.sid IN ({$ids})\n\t\t\t\t\t\tORDER BY users.username {$sorting_order}";
$listings_info = SJB_DB::query($sql);
break;
case 'listing_type':
$ids = join(", ", $foundListingsSIDs);
$sql = "\tSELECT\t\tlistings.*\n\t\t\t\t\t\tFROM \t\tlistings\n\t\t\t\t\t\tLEFT JOIN\tlisting_types on listings.listing_type_sid = listing_types.sid\n\t\t\t\t\t\tWHERE \t\tlistings.sid IN ({$ids})\n\t\t\t\t\t\tORDER BY listing_types.id {$sorting_order}";
$listings_info = SJB_DB::query($sql);
break;
case 'id':
$ids = join(", ", $foundListingsSIDs);
$sql = "\tSELECT\t\tlistings.*\n\t\t\t\t\t\tFROM \t\tlistings\n\t\t\t\t\t\tWHERE\t\tlistings.sid IN ({$ids})\n\t\t\t\t\t\tORDER BY sid {$sorting_order}";
$listings_info = SJB_DB::query($sql);
break;
default:
$property = $empty_listing->getProperty($sorting_field);
$listing_request_creator = new SJB_ListingRequestCreator($foundListingsSIDs, array('property' => $property, 'sorting_order' => $sorting_order));
$listings_info = SJB_DB::query($listing_request_creator->getRequest());
break;
}
$listings_sids = array();
foreach ($listings_info as $listing_info) {
$listings_sids[$listing_info['sid']] = $listing_info['sid'];
}
$sortedFoundListingsSIDs = array_keys($listings_sids);
$criteria_saver->setSessionForObjectSIDs($sortedFoundListingsSIDs);
} else {
$sortedFoundListingsSIDs = $foundListingsSIDs;
$criteria_saver->setSessionForObjectSIDs($foundListingsSIDs);
}
/**************** P A G I N G *****************/
$sortedFoundListingsSIDsByPages = array_chunk($sortedFoundListingsSIDs, $paginator->itemsPerPage, true);
$paginator->setItemsCount(count($sortedFoundListingsSIDs));
/************* S T R U C T U R E **************/
$listings_structure = array();
if (isset($sortedFoundListingsSIDsByPages[$paginator->currentPage - 1])) {
foreach ($sortedFoundListingsSIDsByPages[$paginator->currentPage - 1] as $sid) {
$listing = SJB_ListingManager::getObjectBySID($sid);
$listing->addPicturesProperty();
$listings_structure[$listing->getID()] = SJB_ListingManager::createTemplateStructureForListing($listing);
}
}
/*************** D I S P L A Y ****************/
$template_processor->assign("search_criteria", $criteria_saver->createTemplateStructureForCriteria());
$template_processor->assign('paginationInfo', $paginator->getPaginationInfo());
$template_processor->assign('listings', $listings_structure);
$template_processor->display('display_results.tpl');
}
public function execute()
{
$listing_id = SJB_Request::getVar('listing_id', null);
$listing_info = SJB_ListingManager::getListingInfoBySID($listing_id);
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listing_info['listing_type_sid']);
if (!is_null($listing_info)) {
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$file = SJB_UploadFileManager::openFile($filename, $listing_id);
$errors['NO_SUCH_FILE'] = true;
}
if (isset($_REQUEST['Occupations']) && isset($_REQUEST['Occupations']['tree']) && !$_REQUEST['Occupations']['tree']) {
unset($_REQUEST['Occupations']['tree']);
}
$listing_info = array_merge($listing_info, $_REQUEST);
if (isset($_REQUEST['Occupations']) && isset($_REQUEST['Occupations']['tree']) && $_REQUEST['Occupations']['tree']) {
$listing_info['Occupations'] = $_REQUEST['Occupations']['tree'];
}
$listing = new SJB_Listing($listing_info, $listing_info['listing_type_sid']);
$listing->setSID($listing_id);
$listing_edit_form = new SJB_Form($listing);
$form_is_submitted = SJB_Request::getVar('action');
$errors = array();
if ($form_is_submitted) {
$listing->addProperty(array('id' => 'access_list', 'type' => 'multilist', 'value' => SJB_Request::getVar('list_emp_ids'), 'is_system' => true));
}
if ($form_is_submitted && $listing_edit_form->isDataValid($errors)) {
$listingSid = $listing->getID();
SJB_BrowseDBManager::deleteListings($listingSid);
SJB_ListingManager::saveListing($listing);
SJB_BrowseDBManager::addListings($listingSid);
$formToken = SJB_Request::getVar('form_token');
$sessionFilesStorage = SJB_Session::getValue('tmp_uploads_storage');
$uploadedFields = SJB_Array::getPath($sessionFilesStorage, $formToken);
if (!empty($uploadedFields)) {
foreach ($uploadedFields as $fieldId => $fieldValue) {
// get field of listing
$isComplex = false;
if (strpos($fieldId, ':') !== false) {
$isComplex = true;
}
$tmpUploadedFileId = $fieldValue['file_id'];
// rename it to real listing field value
$newFileId = $fieldId . "_" . $listing->getSID();
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` =?s", $newFileId, $tmpUploadedFileId);
if ($isComplex) {
list($parentField, $subField, $complexStep) = explode(':', $fieldId);
$parentProp = $listing->getProperty($parentField);
$parentValue = $parentProp->getValue();
// look for complex property with current $fieldID and set it to new value of property
if (!empty($parentValue)) {
foreach ($parentValue as $id => $value) {
if ($id == $subField) {
$parentValue[$id][$complexStep] = $newFileId;
}
}
$listing->setPropertyValue($parentField, $parentValue);
}
} else {
$listing->setPropertyValue($fieldId, $newFileId);
}
// unset value from session temporary storage
$sessionFilesStorage = SJB_Array::unsetValueByPath($sessionFilesStorage, "{$formToken}/{$fieldId}");
}
//and remove token key from temporary storage
$sessionFilesStorage = SJB_Array::unsetValueByPath($sessionFilesStorage, "{$formToken}");
SJB_Session::setValue('tmp_uploads_storage', $sessionFilesStorage);
SJB_ListingManager::saveListing($listing);
}
SJB_Event::dispatch('listingEdited', $listingSid);
if (SJB_Request::isAjax()) {
echo '<p class="green">Listing Saved</p>';
exit;
}
if ($form_is_submitted == 'save_info') {
$listingTypeId = SJB_ListingTypeManager::getListingTypeIDBySID($listing_info['listing_type_sid']);
$listingType = $listingTypeId != 'Job' && $listingTypeId != 'Resume' ? $listingTypeId . '-listings' : $listingTypeId . 's';
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . "/manage-" . strtolower($listingType) . "/?restore=1");
}
}
$listing->deleteProperty('access_list');
$comments = SJB_CommentManager::getEnabledCommentsToListing($listing_id);
$comments_total = count($comments);
$rate = SJB_Rating::getRatingNumToListing($listing_id);
$form_fields = $listing_edit_form->getFormFieldsInfo();
$pages = SJB_PostingPagesManager::getPagesByListingTypeSID($listing->getListingTypeSID());
$realFormFields = array();
foreach ($pages as $page) {
$listingFields = SJB_PostingPagesManager::getAllFieldsByPageSIDForForm($page['sid']);
foreach ($listingFields as $fieldID => $listingField) {
if (isset($form_fields[$fieldID])) {
$realFormFields[$fieldID] = $form_fields[$fieldID];
}
}
}
$adminFields = array();
foreach ($form_fields as $fieldName => $field) {
if (!isset($realFormFields[$fieldName])) {
$adminFields[$fieldName] = $field;
}
}
$realFormFields = array_merge($adminFields, $realFormFields);
$tp = SJB_System::getTemplateProcessor();
$listing_edit_form->registerTags($tp);
$extraInfo = $listing_info['product_info'];
if ($extraInfo) {
$extraInfo = unserialize($extraInfo);
$numberOfPictures = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$tp->assign("listing_duration", $extraInfo['listing_duration']);
$tp->assign("pic_limit", $numberOfPictures);
}
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
if (!isset($listing_structure['access_type'])) {
$listing_structure['access_type'] = 'everyone';
}
$listing_access_list = SJB_ListingManager::getListingAccessList($listing_id, $listing->getPropertyValue('access_type'));
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->assign('form_fields', $realFormFields);
$tp->assign('listing', $listing_structure);
$tp->assign('errors', $errors);
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->assign('listing_access_list', $listing_access_list);
$tp->assign('comments_total', $comments_total);
$tp->assign('rate', $rate);
$tp->assign('expired', SJB_ListingManager::getIfListingHasExpiredBySID($listing->getSID()));
SJB_System::setGlobalTemplateVariable('wikiExtraParam', $listingTypeInfo['id']);
$tp->display('edit_listing.tpl');
}
}
