public function execute()
{
ini_set('max_execution_time', 0);
$tp = SJB_System::getTemplateProcessor();
$file_info = isset($_FILES['import_file']) ? $_FILES['import_file'] : null;
$encodingFromCharset = SJB_Request::getVar('encodingFromCharset', 'UTF-8');
$listingTypeID = SJB_Request::getVar('listing_type_id', null);
$productSID = SJB_Request::getVar('product_sid', 0);
$errors = array();
if ($listingTypeID && $productSID) {
$acl = SJB_Acl::getInstance();
$resource = 'post_' . strtolower($listingTypeID);
if (!$acl->isAllowed($resource, $productSID, 'product')) {
$errors[] = 'You cannot import listings of this type under the selected product';
}
}
if (!empty($file_info)) {
$extension = SJB_Request::getVar('file_type');
if (!SJB_ImportFile::isValidFileExtensionByFormat($extension, $file_info)) {
$errors['DO_NOT_MATCH_SELECTED_FILE_FORMAT'] = true;
}
}
if (empty($file_info) || $file_info['error'] || $errors) {
if (isset($file_info['error']) && $file_info['error'] > 0) {
$errors[SJB_UploadFileManager::getErrorId($file_info['error'])] = 1;
}
$listing_types = SJB_ListingTypeManager::getAllListingTypesInfo();
$products = SJB_ProductsManager::getProductsByProductType('post_listings');
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->assign('listing_types', $listing_types);
$tp->assign('products', $products);
$tp->assign('errors', $errors);
$tp->assign('charSets', SJB_HelperFunctions::getCharSets());
$tp->display('import_listings.tpl');
} else {
$i18n = SJB_I18N::getInstance();
$csv_delimiter = SJB_Request::getVar('csv_delimiter', null);
$activeStatus = SJB_Request::getVar('active', 0);
$activationDate = SJB_Request::getVar('activation_date', date('Y-m-d'));
$activationDate = $i18n->getInput('date', $activationDate);
$non_existed_values_flag = SJB_Request::getVar('non_existed_values', null);
$productInfo = SJB_ProductsManager::getProductInfoBySID($productSID);
if (empty($productInfo['listing_duration'])) {
$expirationDate = '';
} else {
$timestamp = strtotime($activationDate . ' + ' . $productInfo['listing_duration'] . ' days');
$expirationDate = $i18n->getDate(date('Y-m-d', $timestamp));
}
$extension = $_REQUEST['file_type'];
if ($extension == 'xls') {
$import_file = new SJB_ImportFileXLS($file_info);
} elseif ($extension == 'csv') {
$import_file = new SJB_ImportFileCSV($file_info, $csv_delimiter);
}
$import_file->parse($encodingFromCharset);
$listing = $this->CreateListing(array(), $listingTypeID);
$imported_data = $import_file->getData();
$isFileImported = true;
$count = 0;
$addedListingsSids = array();
$nonExistentUsers = array();
foreach ($imported_data as $key => $importedColumn) {
if ($key == 1) {
$imported_data_processor = new SJB_ImportedDataProcessor($importedColumn, $listing);
continue;
}
if (!$importedColumn) {
continue;
}
$count++;
$listingInfo = $imported_data_processor->getData($non_existed_values_flag, $importedColumn);
$doc = new DOMDocument();
foreach ($listing->getProperties() as $property) {
if ($property->getType() == 'complex' && !empty($listingInfo[$property->id])) {
$childFields = SJB_ListingComplexFieldManager::getListingFieldsInfoByParentSID($property->sid);
$doc->loadXML($listingInfo[$property->id]);
$results = $doc->getElementsByTagName($property->id . 's');
$listingInfo[$property->id] = array();
foreach ($results as $complexparent) {
$i = 1;
foreach ($complexparent->getElementsByTagName($property->id) as $result) {
$resultXML = simplexml_import_dom($result);
foreach ($childFields as $childField) {
if (isset($resultXML->{$childField}['id'])) {
$listingInfo[$property->id][$childField['id']][$i] = XML_Util::reverseEntities((string) $resultXML->{$childField}['id']);
}
}
$i++;
}
}
} elseif ($property->getType() == 'monetary' && !empty($listingInfo[$property->id])) {
$value = $listingInfo[$property->id];
$listingInfo[$property->id] = array();
$listingInfo[$property->id]['value'] = $value;
$defaultCurrency = SJB_CurrencyManager::getDefaultCurrency();
$currencyCode = !empty($listingInfo[$property->id . "Currency"]) ? $listingInfo[$property->id . "Currency"] : $defaultCurrency['currency_code'];
$currency = SJB_CurrencyManager::getCurrencyByCurrCode($currencyCode);
$listingInfo[$property->id]['add_parameter'] = !empty($currency['sid']) ? $currency['sid'] : '';
if (isset($listingInfo[$property->id . "Currency"])) {
unset($listingInfo[$property->id . "Currency"]);
}
} elseif ($property->getType() == 'location') {
$locationFields = array($property->id . '.Country', $property->id . '.State', $property->id . '.City', $property->id . '.ZipCode');
$locationFieldAdded = array();
foreach ($locationFields as $locationField) {
if (array_key_exists($locationField, $listingInfo)) {
switch ($locationField) {
case $property->id . '.Country':
$value = SJB_CountriesManager::getCountrySIDByCountryName($listingInfo[$locationField]);
if (!$value) {
$value = SJB_CountriesManager::getCountrySIDByCountryCode($listingInfo[$locationField]);
}
break;
case $property->id . '.State':
$value = SJB_StatesManager::getStateSIDByStateName($listingInfo[$locationField]);
if (!$value) {
$value = SJB_StatesManager::getStateSIDByStateCode($listingInfo[$locationField]);
}
break;
default:
$value = $listingInfo[$locationField];
break;
}
$listingInfo[$property->id][str_replace($property->id . '.', '', $locationField)] = $value;
$locationFieldAdded[] = str_replace($property->id . '.', '', $locationField);
}
}
if ($property->id == 'Location') {
$locationFields = array('Country', 'State', 'City', 'ZipCode');
foreach ($locationFields as $locationField) {
if (array_key_exists($locationField, $listingInfo) && !in_array($locationField, $locationFieldAdded) && !$listing->getProperty($locationField)) {
switch ($locationField) {
case 'Country':
$value = SJB_CountriesManager::getCountrySIDByCountryName($listingInfo[$locationField]);
if (!$value) {
$value = SJB_CountriesManager::getCountrySIDByCountryCode($listingInfo[$locationField]);
}
break;
case 'State':
$value = SJB_StatesManager::getStateSIDByStateName($listingInfo[$locationField]);
if (!$value) {
$value = SJB_StatesManager::getStateSIDByStateCode($listingInfo[$locationField]);
}
break;
default:
$value = $listingInfo[$locationField];
break;
}
$listingInfo[$property->id][$locationField] = $value;
}
}
}
}
}
$listing = $this->CreateListing($listingInfo, $listingTypeID);
$pictures = array();
if (isset($listingInfo['pictures'])) {
$listing->addPicturesProperty();
$explodedPictures = explode(';', $listingInfo['pictures']);
foreach ($explodedPictures as $picture) {
if (!empty($picture)) {
$pictures[] = $picture;
}
}
$listing->setPropertyValue('pictures', count($pictures));
}
$listing->addActiveProperty($activeStatus);
$listing->addActivationDateProperty($activationDate);
$listing->addExpirationDateProperty($expirationDate);
SJB_ListingDBManager::setListingExpirationDateBySid($listing->sid);
$listing->setProductInfo(SJB_ProductsManager::getProductExtraInfoBySID($productSID));
$listing->setPropertyValue('access_type', 'everyone');
$listing->setPropertyValue('status', 'approved');
foreach ($listing->getProperties() as $property) {
if ($property->getType() == 'tree' && $property->value !== '') {
try {
$treeImportHelper = new SJB_FieldTreeImportHelper($property->value);
$treeValues = $treeImportHelper->parseAndGetValues();
$listing->setPropertyValue($property->id, $treeValues);
$listing->details->properties[$property->id]->type->property_info['value'] = $treeValues;
} catch (Exception $e) {
$listing->setPropertyValue($property->id, '');
$listing->details->properties[$property->id]->type->property_info['value'] = '';
SJB_Error::writeToLog('Listing Import. Tree Field Value Error: ' . $e->getMessage());
}
} elseif ($property->id == 'ApplicationSettings' && !empty($listingInfo['ApplicationSettings'])) {
if (preg_match("^[a-z0-9\\._-]+@[a-z0-9\\._-]+\\.[a-z]{2,}\$^iu", $listingInfo['ApplicationSettings'])) {
$listingInfo['ApplicationSettings'] = array('value' => $listingInfo['ApplicationSettings'], 'add_parameter' => 1);
} elseif (preg_match("^(https?:\\/\\/)^", $listingInfo['ApplicationSettings'])) {
$listingInfo['ApplicationSettings'] = array('value' => $listingInfo['ApplicationSettings'], 'add_parameter' => 2);
} else {
$listingInfo['ApplicationSettings'] = array('value' => '', 'add_parameter' => '');
}
//put empty if not valid email or url
$listing->details->properties[$property->id]->type->property_info['value'] = $listingInfo['ApplicationSettings'];
} elseif ($property->getType() == 'complex') {
$childFields = SJB_ListingComplexFieldManager::getListingFieldsInfoByParentSID($property->sid);
$complexChildValues = $property->value;
foreach ($childFields as $childField) {
if ($childField['type'] == 'complexfile' && !empty($complexChildValues[$childField['id']])) {
$fieldInfo = SJB_ListingComplexFieldManager::getFieldInfoBySID($childField['sid']);
if (!SJB_UploadFileManager::fileImport($listingInfo, $fieldInfo, $property->id)) {
$isFileImported = false;
}
}
if ($property->type->complex->details->properties[$childField['id']]->value == null) {
$property->type->complex->details->properties[$childField['id']]->value = array(1 => '');
$property->type->complex->details->properties[$childField['id']]->type->property_info['value'] = array(1 => '');
}
}
}
// The import of files at import of listings
if (in_array($property->getType(), array('file', 'logo', 'video')) && $property->value !== '') {
$fieldInfo = SJB_ListingFieldDBManager::getListingFieldInfoByID($property->id);
if (!SJB_UploadFileManager::fileImport($listingInfo, $fieldInfo)) {
$isFileImported = false;
}
}
}
if ($non_existed_values_flag == 'add') {
$this->UpdateListValues($listing);
}
if ($listing->getUserSID()) {
SJB_ListingManager::saveListing($listing);
$listingSid = $listing->getSID();
SJB_Statistics::addStatistics('addListing', $listing->getListingTypeSID(), $listingSid);
SJB_ListingManager::activateListingBySID($listingSid, false);
if (!$this->fillGallery($listingSid, $pictures)) {
$isFileImported = false;
}
$addedListingsSids[] = $listingSid;
} else {
$nonExistentUsers[] = $listingInfo['username'];
$count--;
}
}
SJB_BrowseDBManager::addListings($addedListingsSids);
SJB_ProductsManager::incrementPostingsNumber($productSID, count($addedListingsSids));
if ($isFileImported && file_exists(SJB_System::getSystemSettings('IMPORT_FILES_DIRECTORY'))) {
SJB_Filesystem::delete(SJB_System::getSystemSettings('IMPORT_FILES_DIRECTORY'));
}
$tp->assign('imported_listings_count', $count);
$tp->assign('nonExistentUsers', $nonExistentUsers);
$tp->display('import_listings_result.tpl');
}
}
/**
* @param int $userSID
* @param int $productSID
* @param int $contractID
* @param int $listingNumber
*/
public static function activateListingsAfterPaid($userSID, $productSID, $contractID, $listingNumber)
{
$limit = '';
if ($listingNumber != null) {
$limit = 'LIMIT 0,' . $listingNumber;
}
$serializedProductSID = SJB_ProductsManager::generateQueryBySID($productSID);
$listingsSIDsToProceed = SJB_DB::query("SELECT `sid` FROM `listings` WHERE `checkouted` = 0 AND `complete` = 1 AND `contract_id` = 0 AND `user_sid` = ?n AND `product_info` REGEXP '({$serializedProductSID})' ORDER BY `sid` DESC {$limit}", $userSID);
if (!empty($listingsSIDsToProceed)) {
foreach ($listingsSIDsToProceed as $listingSIDToProceed) {
SJB_DB::query('UPDATE `listings` SET `contract_id` = ?n, `checkouted` = 1 WHERE `sid` = ?n', $contractID, $listingSIDToProceed['sid']);
self::activateListingBySID($listingSIDToProceed['sid']);
}
SJB_ProductsManager::incrementPostingsNumber($productSID, count($listingsSIDsToProceed));
SJB_ContractSql::updatePostingsNumber($contractID, count($listingsSIDsToProceed));
}
}
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');
}
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$listing_type_id = SJB_Request::getVar('listing_type_id', false);
$action = SJB_Request::getVar('action', false);
$type = SJB_Request::getVar('type', false);
$encodingFromCharset = SJB_Request::getVar('encodingFromCharset', 'UTF-8');
$supportedFormats = array('xlsx', 'xls', 'csv');
$warning = false;
$error = '';
if ($action == 'example' && $type) {
$listing_type_sid = SJB_ListingTypeManager::getListingTypeSIDByID($listing_type_id);
$listing_field_manager = new SJB_ListingFieldManager();
$common_details = $listing_field_manager->getCommonListingFieldsInfo();
$extra_details = $listing_field_manager->getListingFieldsInfoByListingType($listing_type_sid);
$listing_fields = array_merge($common_details, $extra_details);
$directory_to_export = SJB_System::getSystemSettings('EXPORT_FILES_DIRECTORY');
$export_properties = array();
$export_data = array();
foreach ($listing_fields as $listing_field) {
$export_properties[$listing_field['id']] = $listing_field['id'];
$export_data[0][$listing_field['id']] = '';
}
SJB_ExportController::createExportDirectoriesForExample();
switch ($type) {
case 'exl':
SJB_ExportController::makeExportFile($export_data, 'example.xls');
$export_files_dir = SJB_Path::combine($directory_to_export, 'example.xls');
for ($i = 0; $i < ob_get_level(); $i++) {
ob_end_clean();
}
header('Content-type: application/vnd.ms-excel');
header('Content-disposition: attachment; filename=example.xls');
header('Content-Length: ' . filesize($export_files_dir));
readfile($export_files_dir);
break;
case 'csv':
$export_files_dir = SJB_Path::combine($directory_to_export, 'example.csv');
$fp = fopen($export_files_dir, 'w');
fputcsv($fp, explode(',', implode(',', $export_properties)));
fclose($fp);
for ($i = 0; $i < ob_get_level(); $i++) {
ob_end_clean();
}
header('Content-type: application/vnd.ms-excel');
header('Content-disposition: attachment; filename=example.csv');
header('Content-Length: ' . filesize($export_files_dir));
readfile($export_files_dir);
break;
}
SJB_Filesystem::delete($directory_to_export);
exit;
}
if ($productsInfo = $this->canCurrentUserAddListing($error)) {
$acl = SJB_Acl::getInstance();
if ($acl->isAllowed('bulk_job_import') == true) {
$fileInfo = null;
if (isset($_FILES['import_file'])) {
$extension = strtolower(substr(strrchr($_FILES['import_file']['name'], '.'), 1));
if (empty($_FILES['import_file']['name']) || !in_array($extension, $supportedFormats)) {
$warning = 'Please choose Excel or csv file';
} else {
$fileInfo = $_FILES['import_file'];
}
}
$contractID = SJB_Request::getVar('contract_id', false);
$current_user = SJB_UserManager::getCurrentUser();
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("products_info", $productsInfo);
$tp->assign("listing_type_id", $listing_type_id);
$tp->display("listing_product_choice.tpl");
}
if ($contractID && $listing_type_id) {
$listing_type_sid = SJB_ListingTypeManager::getListingTypeSIDByID($listing_type_id);
if ($fileInfo) {
switch ($extension) {
case 'xls':
case 'xlsx':
$import_file = new SJB_ImportFileXLS($fileInfo);
break;
case 'csv':
$import_file = new SJB_ImportFileCSV($fileInfo, ',');
break;
}
$import_file->parse($encodingFromCharset);
$bulkPermissionParam = $this->acl->getPermissionParams('post_' . $listing_type_id, $contract->getID(), 'contract');
$imported_data = $import_file->getData();
$countData = 0;
foreach ($imported_data as $val) {
if ($val) {
$countData++;
}
}
if (empty($bulkPermissionParam) || $bulkPermissionParam - $contract->getPostingsNumber() - ($countData - 1) >= 0) {
$listing = new SJB_Listing(array(), $listing_type_sid);
$count = 0;
$listingSIDs = array();
foreach ($imported_data as $key => $importedColumn) {
if ($key == 1) {
$imported_data_processor = new SJB_ImportedDataProcessor($importedColumn, $listing);
continue;
}
if (!$importedColumn) {
continue;
}
$count++;
$listing_info = $imported_data_processor->getData('ignore', $importedColumn);
$doc = new DOMDocument();
foreach ($listing->getProperties() as $property) {
if ($property->getType() == 'complex' && !empty($listing_info[$property->id])) {
$childFields = SJB_ListingComplexFieldManager::getListingFieldsInfoByParentSID($property->sid);
$doc->loadXML($listing_info[$property->id]);
$results = $doc->getElementsByTagName($property->id . 's');
$listing_info[$property->id] = array();
foreach ($results as $complexparent) {
$i = 0;
foreach ($complexparent->getElementsByTagName($property->id) as $result) {
$resultXML = simplexml_import_dom($result);
foreach ($childFields as $childField) {
if (isset($resultXML->{$childField}['id'])) {
$listing_info[$property->id][$childField['id']][$i] = (string) $resultXML->{$childField}['id'];
}
}
$i++;
}
}
} elseif ($property->getType() == 'location') {
$locationFields = array($property->id . '.Country', $property->id . '.State', $property->id . '.City', $property->id . '.ZipCode');
$locationFieldAdded = array();
foreach ($locationFields as $locationField) {
if (array_key_exists($locationField, $listing_info)) {
switch ($locationField) {
case $property->id . '.Country':
$value = SJB_CountriesManager::getCountrySIDByCountryName($listing_info[$locationField]);
if (!$value) {
$value = SJB_CountriesManager::getCountrySIDByCountryCode($listing_info[$locationField]);
}
break;
case $property->id . '.State':
$value = SJB_StatesManager::getStateSIDByStateName($listing_info[$locationField]);
if (!$value) {
$value = SJB_StatesManager::getStateSIDByStateCode($listing_info[$locationField]);
}
break;
default:
$value = $listing_info[$locationField];
break;
}
$listing_info[$property->id][str_replace($property->id . '.', '', $locationField)] = $value;
$locationFieldAdded[] = str_replace($property->id . '.', '', $locationField);
}
}
if ($property->id == 'Location') {
$locationFields = array('Country', 'State', 'City', 'ZipCode');
foreach ($locationFields as $locationField) {
if (array_key_exists($locationField, $listing_info) && !in_array($locationField, $locationFieldAdded) && !$listing->getProperty($locationField)) {
switch ($locationField) {
case 'Country':
$value = SJB_CountriesManager::getCountrySIDByCountryName($listing_info[$locationField]);
if (!$value) {
$value = SJB_CountriesManager::getCountrySIDByCountryCode($listing_info[$locationField]);
}
break;
case 'State':
$value = SJB_StatesManager::getStateSIDByStateName($listing_info[$locationField]);
if (!$value) {
$value = SJB_StatesManager::getStateSIDByStateCode($listing_info[$locationField]);
}
break;
default:
$value = $listing_info[$locationField];
break;
}
$listing_info[$property->id][$locationField] = $value;
}
}
}
}
}
$field_info = null;
$listing = new SJB_Listing($listing_info, $listing_type_sid);
foreach ($listing->getProperties() as $property) {
if ($property->getType() == 'tree' && $property->value !== '') {
$treeValues = explode(',', $property->value);
$treeSIDs = array();
foreach ($treeValues as $treeValue) {
$info = SJB_ListingFieldTreeManager::getItemInfoByCaption($property->sid, trim($treeValue));
$treeSIDs[] = $info['sid'];
}
$listing->setPropertyValue($property->id, implode(',', $treeSIDs));
$listing->details->properties[$property->id]->type->property_info['value'] = implode(',', $treeSIDs);
} elseif ($property->getType() == 'monetary') {
$currency = SJB_CurrencyManager::getDefaultCurrency();
$listing->details->properties[$property->id]->type->property_info['value']['add_parameter'] = $currency['sid'];
} elseif ($property->id == 'ApplicationSettings' && !empty($listing_info['ApplicationSettings'])) {
if (preg_match("^[a-z0-9\\._-]+@[a-z0-9\\._-]+\\.[a-z]{2,}\$^iu", $listing_info['ApplicationSettings'])) {
$listing_info['ApplicationSettings'] = array('value' => $listing_info['ApplicationSettings'], 'add_parameter' => 1);
} elseif (preg_match("^(https?:\\/\\/)^iu", $listing_info['ApplicationSettings'])) {
$listing_info['ApplicationSettings'] = array('value' => $listing_info['ApplicationSettings'], 'add_parameter' => 2);
} else {
$listing_info['ApplicationSettings'] = array('value' => '', 'add_parameter' => '');
}
$listing->details->properties[$property->id]->type->property_info['value'] = $listing_info['ApplicationSettings'];
} elseif ($property->getType() == 'complex' && is_array($property->value)) {
$childFields = SJB_ListingComplexFieldManager::getListingFieldsInfoByParentSID($property->sid);
$complexChildValues = $property->value;
foreach ($childFields as $childField) {
if ($childField['type'] == 'complexfile' && !empty($complexChildValues[$childField['id']])) {
$field_info = SJB_ListingComplexFieldManager::getFieldInfoBySID($childField['sid']);
if (isset($listing_info[$property->id][$field_info['id']]) && file_exists($listing_info[$property->id][$field_info['id']])) {
SJB_UploadFileManager::fileImport($listing_info, $field_info, $property->id);
}
}
}
}
// The import of files at import of listings
if (in_array($property->getType(), array('file', 'logo', 'picture', 'video')) && $property->value !== '') {
$field_info = SJB_ListingFieldDBManager::getListingFieldInfoByID($property->id);
if (isset($listing_info[$field_info['id']]) && file_exists($listing_info[$field_info['id']])) {
SJB_UploadFileManager::fileImport($listing_info, $field_info);
}
}
}
$listing->deleteProperty('featured');
$listing->deleteProperty('priority');
$listing->deleteProperty('status');
$listing->deleteProperty('reject_reason');
$listing->addProperty(array('id' => 'contract_id', 'type' => 'id', 'value' => $contract->getID(), 'is_system' => true));
$extraInfo = $contract->extra_info;
$listing->setProductInfo($extraInfo);
$listing->setPropertyValue('access_type', 'everyone');
$listing->setUserSID($current_user->sid);
if ($current_user->isSubuser()) {
$subuserInfo = $current_user->getSubuserInfo();
$listing->addSubuserProperty($subuserInfo['sid']);
}
SJB_ListingManager::saveListing($listing);
SJB_Statistics::addStatistics('addListing', $listing->getListingTypeSID(), $listing->getSID(), false, $extraInfo['featured'], $extraInfo['priority']);
$contract->incrementPostingsNumber();
SJB_ProductsManager::incrementPostingsNumber($contract->product_sid);
if (!empty($extraInfo['featured'])) {
SJB_ListingManager::makeFeaturedBySID($listing->getSID());
}
if (!empty($extraInfo['priority'])) {
SJB_ListingManager::makePriorityBySID($listing->getSID());
}
$this->FillGallery($listing, $listing_info);
$listingSIDs[] = $listing->getSID();
}
SJB_ListingManager::activateListingBySID($listingSIDs);
$tp->assign('listingsNum', count($listingSIDs));
$tp->display('job_import_complete.tpl');
} else {
$tp->assign('charSets', SJB_HelperFunctions::getCharSets());
$error = 'LISTINGS_NUMBER_LIMIT_EXCEEDED';
$tp->assign('listing_type_id', $listing_type_id);
$tp->assign('error', $error);
$tp->display('job_import.tpl');
}
} else {
$tp->assign('charSets', SJB_HelperFunctions::getCharSets());
$tp->assign('warning', $warning);
$tp->assign('contract_id', $contractID);
$tp->assign('listing_type_id', $listing_type_id);
$tp->display('job_import.tpl');
}
}
} else {
$error = $acl->getPermissionMessage('bulk_job_import');
if (empty($error)) {
$error = 'This action is not allowed within your current product';
}
$tp->assign('error', $error);
$tp->assign('charSets', SJB_HelperFunctions::getCharSets());
$tp->assign('listing_type_id', $listing_type_id);
$tp->display('job_import.tpl');
}
} else {
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('charSets', SJB_HelperFunctions::getCharSets());
$tp->assign('listing_type_id', $listing_type_id);
$tp->assign('error', $error);
$tp->display('job_import.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);
}
}
}
private function extraProperties($user, $userInfo, &$usersID)
{
$savedProperties = array('user_group' => 1, 'pictures' => 1);
foreach ($user->getProperties() as $property) {
if (!in_array($property->id, array('file', 'Logo', 'video'))) {
$savedProperties[$property->id] = 1;
}
}
$queryFields = '';
foreach (array_diff_key($userInfo, $savedProperties) as $key => $value) {
if ($key == 'id') {
$usersID[$value] = $user->getSID();
continue;
}
if ($key == 'product') {
$products = $value ? explode(',', $value) : array();
$i = sizeof($products);
while (--$i != -1) {
$productProperties = @unserialize($products[$i]);
if (!$productProperties) {
continue;
}
$productSid = SJB_ProductsManager::getProductSidByName($productProperties['name']);
if (!$productSid) {
continue;
}
$contract = new SJB_Contract(array('product_sid' => $productSid, 'numberOfListings' => $productProperties['number_of_listings']));
$contract->setPrice($productProperties['price']);
$contract->setCreationDate($productProperties['creation_date']);
$contract->setExpiredDate($productProperties['expired_date']);
$contract->setStatus($productProperties['status']);
$contract->setUserSID($user->getSID());
$contract->saveInDB();
SJB_ContractSQL::updatePostingsNumber($contract->id, $productProperties['number_of_postings']);
SJB_ProductsManager::incrementPostingsNumber($productSid, $productProperties['number_of_postings']);
}
continue;
}
if (in_array($key, array('file', 'Logo', 'video')) && !empty($value)) {
$property = $user->getProperty($key);
if (!$property) {
continue;
}
$fileProperties = @unserialize($value);
if (!$fileProperties) {
continue;
}
$fieldInfo = SJB_UserProfileFieldManager::getFieldInfoBySID($property->sid);
switch ($key) {
case 'file':
$value = 'Resume_' . $user->getSID();
$this->databaseFileRegister('file', $value, $fileProperties['name'] . '.' . $fileProperties['extension'], $fileProperties['mimeType']);
break;
case 'Logo':
$value = 'Logo_' . $user->getSID();
$this->databaseFileRegister('pictures', $value, $fileProperties['name'] . '.' . $fileProperties['extension'], $fileProperties['mimeType']);
$this->databaseFileRegister('pictures', 'Logo_' . $user->getSID() . '_thumb', $fileProperties['name'] . '_thumb.' . $fileProperties['extension'], $fileProperties['mimeType']);
break;
case 'video':
$value = 'video_' . $user->getSID();
$this->databaseFileRegister('video', 'video_' . $user->getSID(), $fileProperties['name'] . '.' . $fileProperties['extension'], $fileProperties['mimeType']);
break;
}
}
if ($key == 'registration_date') {
$isValid = SJB_UserRegistrationDateValidator::isValid($userInfo['registration_date']);
if ($isValid !== true) {
if (!isset($errors['registrationDate'])) {
$errors['registrationDate'][] = $isValid;
}
if (isset($userInfo['username'])) {
$errors['registrationDate'][] = $userInfo['username'] . ', ';
}
continue;
}
}
if (!empty($value)) {
$queryFields .= $queryFields ? ", `" . SJB_DB::quote($key) . "` = '" . SJB_DB::quote($value) . "'" : "`" . SJB_DB::quote($key) . "` = '" . SJB_DB::quote($value) . "'";
}
}
if (!empty($queryFields)) {
SJB_DB::queryExec("UPDATE ?w SET " . $queryFields . " WHERE `sid` = ?n", 'users', $user->getSID());
}
}
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');
}
}