public function execute()
{
$pictureId = isset($_REQUEST['picture_id']) ? $_REQUEST['picture_id'] : null;
$listingId = isset($_REQUEST['listing_id']) ? $_REQUEST['listing_id'] : null;
$tp = SJB_System::getTemplateProcessor();
if ($pictureId && $listingId) {
$gallery = new SJB_ListingGallery();
$pictureInfo = $gallery->getPictureInfoBySID($pictureId);
$pictureCaption = SJB_Request::getVar('picture_caption', false);
if ($pictureCaption) {
$pictureInfo['caption'] = $pictureCaption;
$gallery->updatePictureCaption($pictureId, $pictureCaption);
}
$tp->assign('picture', $pictureInfo);
$tp->assign('listing_id', $listingId);
$tp->assign('picture_id', $pictureId);
$tp->display('edit_picture.tpl');
}
}
public static function copyFilesAndPicturesFromListing($srcListingSid, $dstListingSid, $tmpListingSid)
{
$listing = SJB_ListingManager::getObjectBySID($srcListingSid);
if ($listing) {
foreach ($listing->getProperties() as $listingProperty) {
if ($listingProperty->getType() == 'complex') {
self::copyComplexFiles($dstListingSid, $listingProperty);
} elseif (in_array($listingProperty->getType(), array('file', 'video'))) {
self::copyFiles($dstListingSid, $listingProperty);
}
}
}
if ($tmpListingSid) {
$gallery = new SJB_ListingGallery();
$gallery->setListingSID($tmpListingSid);
$numberOfPictures = $gallery->getPicturesAmount();
if ($numberOfPictures != 0) {
$picturesInfo = $gallery->getPicturesInfo();
$gallery->setListingSID($dstListingSid);
$gallery->deleteImages();
foreach ($picturesInfo as $pictureInfo) {
$gallery->uploadImage($pictureInfo['picture_url'], $pictureInfo['caption']);
}
}
}
SJB_Session::unsetValue('tmp_file_storage');
SJB_ListingDBManager::setListingExpirationDateBySid($dstListingSid);
}
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");
}
function getValue()
{
$gallery = new SJB_ListingGallery();
$gallery->setListingSID($this->object_sid);
return $gallery->getPicturesInfo();
}
private function fillGallery($listingSid, $pictures)
{
$gallery = new SJB_ListingGallery();
$gallery->setListingSID($listingSid);
$isImportSuccessful = true;
if (!empty($pictures)) {
foreach ($pictures as $picture) {
$picturePath = SJB_System::getSystemSettings("IMPORT_FILES_DIRECTORY") . '/' . $picture;
if (file_exists($picturePath)) {
if (!$gallery->uploadImage($picturePath, '')) {
$isImportSuccessful = false;
}
}
}
}
return $isImportSuccessful;
}
private function FillGallery($listing, $listing_info)
{
$gallery = new SJB_ListingGallery();
$gallery->setListingSID($listing->getSID());
if (!empty($listing_info['pictures'])) {
foreach ($listing_info['pictures'] as $picture) {
$gallery->uploadImage($picture, '');
}
}
}
private static function changePicturesProperties(&$exportProperties, &$exportData)
{
if (isset($exportProperties['pictures'])) {
// listings walkthrough
foreach ($exportData as $listing_sid => $property) {
$pictures =& $exportData[$listing_sid]['pictures'];
$pictures = null;
$gallery = new SJB_ListingGallery();
$gallery->setListingSID($listing_sid);
$pictures_info = $gallery->getPicturesInfo();
foreach ($pictures_info as $picture_info) {
$picture_export_url = SJB_ExportController::_getPictureExportURL($picture_info);
$uploaded_picture_url = SJB_ExportController::_getUploadedPictureURL($picture_info);
if (!@copy($uploaded_picture_url, $picture_export_url)) {
continue;
}
$export_files_dir = SJB_System::getSystemSettings("EXPORT_FILES_DIRECTORY");
$picture_export_url = str_replace($export_files_dir, '', $picture_export_url);
$pictures .= ltrim($picture_export_url, '/') . ";";
}
}
}
}
public static function gc($maxLifeTime)
{
$expirationTime = time();
//deleting pictures with temporary listings sids after 1 hour of storage
$unloaded_pictures_sids = SJB_DB::query('SELECT * FROM `listings_pictures` WHERE LENGTH(`listing_sid`) >= ?n', strlen($expirationTime) - 1);
if (!empty($unloaded_pictures_sids)) {
$gallery = new SJB_ListingGallery();
foreach ($unloaded_pictures_sids as $k => $v) {
if ($v['listing_sid'] + 60 * 60 * 1 < $expirationTime) {
$gallery->deleteImageBySID($v['sid']);
}
}
}
SJB_DB::query("delete from `session` where `time` + {$maxLifeTime} < {$expirationTime}");
return true;
}
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');
}
}