protected function prepareAssocArrayForExport()
{
foreach ($this->treeFieldValues as $treeItemSID) {
$treeItemHierarchyDisplayValues = SJB_ListingFieldTreeManager::getTreeDisplayValuesBySIDForExport($treeItemSID);
$this->fillAssocArray($treeItemHierarchyDisplayValues, $this->valuesForXml);
}
}
private function getSortedResults($values)
{
if (!empty($values)) {
$fieldInfo = SJB_ListingFieldManager::getFieldInfoBySID($this->field['sid']);
if (SJB_Array::get($fieldInfo, 'sort_by_alphabet') > 0) {
$i18n = SJB_I18N::getInstance();
$parents = array();
// in this place we have 'caption' with ids of children items, like '300,301,302,305' etc.
// need to get real caption value (for children and parent) and sort by it
foreach ($values as $parent => $items) {
if (!is_array($items)) {
$items = array();
}
$sids = array_keys($items);
$parentSid = SJB_ListingFieldTreeManager::getParentSID($parent);
$parentInfo = SJB_ListingFieldTreeManager::getTreeItemInfoBySID($parentSid);
$parents[] = $i18n->gettext('', $parentInfo['caption']);
// sort children by alphabet
$children = array();
foreach ($sids as $sid) {
$info = SJB_ListingFieldTreeManager::getTreeItemInfoBySID($sid);
$children[] = $i18n->gettext('', $info['caption']);
}
array_multisort($children, SORT_STRING, $sids);
$sids = array_fill_keys($sids, 1);
// set to sorted sids
$values[$parent] = $sids;
}
// sort parent by alphabet
$keys = array_keys($values);
array_multisort($parents, SORT_ASC, SORT_STRING, $keys, $values);
$values = array_combine($keys, $values);
}
}
return $values;
}
public function execute()
{
$field_sid = SJB_Request::getVar('field_sid', null);
$field_info = SJB_ListingFieldManager::getFieldInfoBySID($field_sid);
$node_sid = SJB_Request::getVar('node_sid', 0);
$action = SJB_Request::getVar('action');
$template_processor = SJB_System::getTemplateProcessor();
if (empty($field_info)) {
$errors['INVALID_FIELD_SID'] = 1;
} else {
switch ($action) {
case 'add':
$tree_item_value = $_REQUEST['tree_item_value'];
$order = $_REQUEST['order'];
if ($tree_item_value == '') {
$field_errors['Value'] = 'EMPTY_VALUE';
} else {
if ($order == 'begin') {
SJB_ListingFieldManager::addTreeItemToBeginByParentSID($field_sid, $node_sid, $tree_item_value);
} elseif ($order == 'end') {
SJB_ListingFieldManager::addTreeItemToEndByParentSID($field_sid, $node_sid, $tree_item_value);
} elseif ($order == 'after') {
$after_tree_item_sid = $_REQUEST['after_tree_item_sid'];
SJB_ListingFieldManager::addTreeItemAfterByParentSID($field_sid, $node_sid, $tree_item_value, $after_tree_item_sid);
}
$treeLevelsNumber = SJB_ListingFieldTreeManager::getTreeDepthBySID($field_sid);
SJB_ListingFieldManager::addLevelField($treeLevelsNumber);
}
break;
case 'save':
$tree_item_value = $_REQUEST['tree_item_value'];
if (empty($tree_item_value)) {
$field_errors['Value'] = 'EMPTY_VALUE';
} else {
SJB_ListingFieldManager::updateTreeItemBySID($node_sid, $tree_item_value);
$order = SJB_Request::getVar('order', null);
if ($order == 'begin') {
SJB_ListingFieldManager::moveTreeItemToBeginBySID($node_sid);
} elseif ($order == 'end') {
SJB_ListingFieldManager::moveTreeItemToEndBySID($node_sid);
} elseif ($order == 'after') {
$after_tree_item_sid = $_REQUEST['after_tree_item_sid'];
SJB_ListingFieldManager::moveTreeItemAfterBySID($node_sid, $after_tree_item_sid);
}
}
break;
case 'delete':
$item_sid = SJB_Request::getVar('item_sid');
if (is_array($item_sid)) {
foreach ($item_sid as $sid => $val) {
SJB_ListingFieldManager::deleteTreeItemBySID($sid);
}
} else {
if (isset($item_sid)) {
SJB_ListingFieldManager::deleteTreeItemBySID($item_sid);
}
}
break;
case 'move_up':
$item_sid = SJB_Request::getVar('item_sid');
SJB_ListingFieldManager::moveUpTreeItem($item_sid);
break;
case 'move_down':
$item_sid = SJB_Request::getVar('item_sid');
SJB_ListingFieldManager::moveDownTreeItem($item_sid);
break;
case 'save_order':
$item_order = SJB_Request::getVar('item_order', array());
SJB_ListingFieldManager::saveNewTreeItemsOrder($item_order);
break;
case 'sort':
$node_sid = isset($_REQUEST['node_sid']) ? SJB_Request::getInt('node_sid') : 0;
SJB_ListingFieldManager::sortTreeItems(SJB_Request::getVar('field_sid'), $node_sid, SJB_Request::getVar('sorting_order'));
$template_processor->assign("sorting_order", SJB_Request::getVar('sorting_order'));
break;
case 'add_multiple':
$node_sid = isset($_REQUEST['node_sid']) ? SJB_Request::getInt('node_sid') : 0;
$item_sid = SJB_Request::getVar('field_sid');
$tree_item_value = SJB_Request::getVar('tree_multiItem_value', false);
$after_tree_item_sid = SJB_Request::getVar('after_tree_item_sid', 0);
$order = SJB_Request::getVar('order', false);
if ($tree_item_value == '') {
$field_errors['Value'] = 'EMPTY_VALUE';
}
SJB_ListingFieldTreeManager::addMultupleTreeItem($item_sid, $node_sid, $tree_item_value, $order, $after_tree_item_sid);
break;
}
$tree_items = SJB_ListingFieldManager::getTreeValuesByParentSID($field_sid, $node_sid);
$parent_sid = SJB_ListingFieldManager::getTreeParentSID($node_sid);
$tree_parent_items = SJB_ListingFieldManager::getTreeValuesByParentSID($field_sid, $parent_sid);
}
$template_processor->assign("field_sid", $field_sid);
$template_processor->assign("node_sid", $node_sid);
$template_processor->assign("field_info", $field_info);
$template_processor->assign("tree_parent_items", $tree_parent_items);
$template_processor->assign("tree_items", $tree_items);
$node_info = SJB_ListingFieldManager::getTreeItemInfoBySID($node_sid);
$node_path = SJB_ListingFieldManager::getTreeNodePath($node_sid);
$node_path[0] = array('caption' => 'Root', 'sid' => 0);
$node_info['node_path'] = $node_path;
$template_processor->assign("node_info", $node_info);
$current_level = isset($node_info['level']) ? $node_info['level'] : 0;
$template_processor->assign("current_level", $current_level);
$template_processor->assign("type_sid", $field_info['listing_type_sid']);
$listing_type_info = SJB_ListingTypeManager::getListingTypeInfoBySID($field_info['listing_type_sid']);
$template_processor->assign("type_info", $listing_type_info);
$template_processor->assign("errors", isset($errors) ? $errors : null);
$template_processor->assign("field_errors", isset($field_errors) ? $field_errors : null);
$template_processor->display("edit_tree.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');
}
}
public static function importTreeItem($field_sid, $imported_row)
{
if (!is_array($imported_row)) {
return false;
}
$parent_sid = 0;
$inserted = false;
foreach ($imported_row as $item_caption) {
if (empty($item_caption)) {
break;
}
$item_sid = SJB_DB::queryValue("SELECT sid FROM listing_field_tree WHERE field_sid = ?n AND parent_sid = ?n AND caption = ?s", $field_sid, $parent_sid, $item_caption);
if (!empty($item_sid)) {
} elseif ($item_sid = SJB_ListingFieldTreeManager::addTreeItemToEndByParentSID($field_sid, $parent_sid, $item_caption)) {
$inserted = true;
} else {
break;
}
$parent_sid = $item_sid;
}
return $inserted;
}
public function getTreeValues($sValue, $fieldID)
{
$aFieldInfo = SJB_ListingFieldDBManager::getListingFieldInfoByID($fieldID);
if (!$aFieldInfo) {
return array('tree' => '');
}
$aTreeValues = array();
$tok = strtok($sValue, "\n\r\t");
while ($tok !== false) {
array_push($aTreeValues, $tok);
$tok = strtok("\n\r\t");
}
$aTreeValuesSIDs = array();
foreach ($aTreeValues as $treeCaption) {
$aTreeItemInfo = SJB_ListingFieldTreeManager::getItemInfoByCaption($aFieldInfo['sid'], $treeCaption);
if ($aTreeItemInfo['sid'] > 0) {
array_push($aTreeValuesSIDs, $aTreeItemInfo['sid']);
}
}
if (!empty($aTreeValuesSIDs)) {
return array('tree' => implode(',', $aTreeValuesSIDs));
}
return array('tree' => '');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$listing_field_sid = SJB_Request::getVar('sid', null);
if (!is_null($listing_field_sid)) {
$listingFieldInfo = SJB_ListingFieldManager::getFieldInfoBySID($listing_field_sid);
$old_listing_field_id = $listingFieldInfo['id'];
$listingFieldInfo = array_merge($listingFieldInfo, $_REQUEST);
$listing_field = new SJB_ListingField($listingFieldInfo, $listingFieldInfo['listing_type_sid']);
$listing_field->setSID($listing_field_sid);
$formSubmitted = SJB_Request::getVar('action', '');
if (!in_array($listing_field->field_type, array('video', 'picture', 'file', 'complex'))) {
$profileField = SJB_Request::getVar('profile_field', false);
if ($formSubmitted) {
if ($profileField) {
$listingFieldInfo['default_value'] = '';
} else {
$listingFieldInfo['profile_field_as_dv'] = '';
}
}
$default_value = array('id' => 'default_value', 'sid' => isset($listingFieldInfo['sid']) ? $listingFieldInfo['sid'] : '', 'caption' => 'Default Value', 'value' => isset($listingFieldInfo['default_value']) ? $listingFieldInfo['default_value'] : '', 'type' => $listing_field->field_type, 'length' => '', 'is_required' => false, 'is_system' => true);
$additionalParameters = array();
switch ($listing_field->field_type) {
case 'list':
if (isset($listingFieldInfo['list_values'])) {
$additionalParameters = array('list_values' => $listingFieldInfo['list_values']);
}
break;
case 'multilist':
if (isset($listingFieldInfo['list_values'])) {
$additionalParameters = array('list_values' => $listingFieldInfo['list_values']);
}
if (!is_array($default_value['value'])) {
if (strpos($default_value['value'], ',')) {
$default_value['value'] = explode(',', $default_value['value']);
} else {
$default_value['value'] = array($default_value['value']);
}
}
break;
case 'tree':
if (isset($listingFieldInfo['tree_values'])) {
$additionalParameters = array('tree_values' => $listingFieldInfo['tree_values']);
}
break;
case 'monetary':
if (isset($listingFieldInfo['currency_values'])) {
$default_value['currency_values'] = $listingFieldInfo['currency_values'];
}
break;
}
$default_value = array_merge($default_value, $additionalParameters);
$listing_field->addProperty($default_value);
$user_groups = SJB_UserGroupManager::getAllUserGroupsInfo();
$list_values = array();
foreach ($user_groups as $user_group) {
$list_values = array_merge($list_values, SJB_UserProfileFieldManager::getFieldsInfoByUserGroupSID($user_group['sid']));
}
$profile_field_as_dv = array('id' => 'profile_field_as_dv', 'caption' => 'Default Value', 'value' => isset($listingFieldInfo['profile_field_as_dv']) ? $listingFieldInfo['profile_field_as_dv'] : '', 'type' => 'list', 'list_values' => $list_values, 'length' => '', 'is_required' => false, 'is_system' => true);
$listing_field->addProperty($profile_field_as_dv);
if (in_array($listing_field->field_type, array('tree', 'multilist', 'list'))) {
$sort_by_alphabet = array('id' => 'sort_by_alphabet', 'caption' => 'Sort Values By Alphabet', 'value' => isset($listingFieldInfo['sort_by_alphabet']) ? $listingFieldInfo['sort_by_alphabet'] : '', 'type' => 'boolean', 'lenght' => '', 'is_required' => false, 'is_system' => true);
$listing_field->addProperty($sort_by_alphabet);
}
$tp->assign('profileFieldAsDV', !empty($listingFieldInfo['profile_field_as_dv']));
}
if (in_array($listing_field->field_type, array('multilist', 'list'))) {
$listing_field->addDisplayAsProperty($listingFieldInfo['display_as']);
}
// infil instructions should be the last element in form
if (!in_array($listing_field->getFieldType(), array('complex', 'tree', 'location')) && 'ApplicationSettings' != $listing_field->getPropertyValue('id')) {
if ($formSubmitted) {
$listing_field->addInfillInstructions(SJB_Request::getVar('instructions'));
} else {
$listing_field->addInfillInstructions(isset($listingFieldInfo['instructions']) ? $listingFieldInfo['instructions'] : '');
}
}
/**
* "Display as" options for TREE TYPE
*/
if ('tree' == $listing_field->getFieldType()) {
$listing_field->addProperty(SJB_TreeType::getDisplayAsDetail(isset($listingFieldInfo['display_as_select_boxes']) ? $listingFieldInfo['display_as_select_boxes'] : ''));
$treeLevelsNumber = SJB_ListingFieldTreeManager::getTreeDepthBySID($listing_field_sid);
$tp->assign('tree_levels_number', $treeLevelsNumber);
// treee levels captions
for ($i = 1; $i <= $treeLevelsNumber; $i++) {
$levelID = 'level_' . $i;
$listing_field->addProperty(array('id' => $levelID, 'caption' => $i . ' Level Name', 'value' => isset($listingFieldInfo[$levelID]) ? $listingFieldInfo[$levelID] : '', 'type' => 'string', 'length' => '250', 'is_required' => false, 'is_system' => true));
}
}
/*
* end of ""Display as" options for TREE TYPE"
*/
$edit_form = new SJB_Form($listing_field);
$edit_form->makeDisabled("type");
$errors = array();
if ($formSubmitted && $edit_form->isDataValid($errors)) {
SJB_ListingFieldManager::saveListingField($listing_field);
SJB_ListingFieldManager::changeListingPropertyIDs($listingFieldInfo['id'], $old_listing_field_id);
if ($formSubmitted == 'save_info') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . "/edit-listing-type/?sid=" . $listing_field->getListingTypeSID());
}
}
$edit_form->registerTags($tp);
$tp->assign("form_fields", $edit_form->getFormFieldsInfo());
$tp->assign("errors", $errors);
$tp->assign("listing_type_sid", $listing_field->getListingTypeSID());
$tp->assign("field_type", $listing_field->getFieldType());
$tp->assign("field_sid", $listing_field->getSID());
$listing_type_info = SJB_ListingTypeManager::getListingTypeInfoBySID($listing_field->getListingTypeSID());
$tp->assign("listing_type_info", $listing_type_info);
$tp->assign("listing_field_info", $listingFieldInfo);
$tp->display("edit_listing_type_field.tpl");
}
}
public function execute()
{
$listing_field_sid = SJB_Request::getVar('sid', null);
$tp = SJB_System::getTemplateProcessor();
if (!is_null($listing_field_sid)) {
$listing_field_info = SJB_ListingFieldManager::getFieldInfoBySID($listing_field_sid);
$listing_field_info = array_merge($listing_field_info, $_REQUEST);
$listing_field = new SJB_ListingField($listing_field_info);
$listing_field->setSID($listing_field_sid);
$form_submitted = SJB_Request::getVar('action', '');
if (!in_array($listing_field->field_type, array('video', 'picture', 'file', 'complex'))) {
$profile_field = SJB_Request::getVar('profile_field', false);
if ($form_submitted) {
if ($profile_field) {
$listing_field_info['default_value'] = '';
} else {
$listing_field_info['profile_field_as_dv'] = '';
}
}
$default_value = array();
if ($listing_field->field_type != 'location') {
$default_value = array('id' => 'default_value', 'sid' => isset($listing_field_info['sid']) ? $listing_field_info['sid'] : '', 'caption' => 'Default Value', 'value' => isset($listing_field_info['default_value']) ? $listing_field_info['default_value'] : '', 'type' => $listing_field->field_type, 'length' => '', 'is_required' => false, 'is_system' => true, 'add_parameter' => isset($listing_field_info['add_parameter']) ? $listing_field_info['add_parameter'] : '');
}
switch ($listing_field->field_type) {
case 'list':
if (isset($listing_field_info['list_values'])) {
$default_value['list_values'] = $listing_field_info['list_values'];
}
break;
case 'multilist':
if (isset($listing_field_info['list_values'])) {
$default_value['list_values'] = $listing_field_info['list_values'];
}
if (!is_array($default_value['value'])) {
if (strpos($default_value['value'], ',')) {
$default_value['value'] = explode(',', $default_value['value']);
} else {
$default_value['value'] = array($default_value['value']);
}
}
break;
case 'tree':
if (isset($listing_field_info['tree_values'])) {
$default_value['tree_values'] = $listing_field_info['tree_values'];
}
if (isset($listing_field_info['display_as_select_boxes'])) {
$default_value['display_as_select_boxes'] = $listing_field_info['display_as_select_boxes'];
}
unset($listing_field_info['choiceLimit']);
break;
case 'monetary':
if (isset($listing_field_info['currency_values'])) {
$default_value['currency_values'] = $listing_field_info['currency_values'];
}
break;
}
if ($listing_field->field_type != 'location') {
$listing_field->addProperty($default_value);
$profile_field_as_dv = array('id' => 'profile_field_as_dv', 'caption' => 'Default Value', 'value' => isset($listing_field_info['profile_field_as_dv']) ? $listing_field_info['profile_field_as_dv'] : '', 'type' => 'list', 'list_values' => SJB_UserProfileFieldManager::getAllFieldsInfo(), 'length' => '', 'is_required' => false, 'is_system' => true);
$listing_field->addProperty($profile_field_as_dv);
}
if (in_array($listing_field->field_type, array('tree', 'multilist', 'list'))) {
$sort_by_alphabet = array('id' => 'sort_by_alphabet', 'caption' => 'Sort Values By Alphabet', 'value' => isset($listing_field_info['sort_by_alphabet']) ? $listing_field_info['sort_by_alphabet'] : '', 'type' => 'boolean', 'lenght' => '', 'is_required' => false, 'is_system' => true);
$listing_field->addProperty($sort_by_alphabet);
}
$tp->assign('profileFieldAsDV', !empty($listing_field_info['profile_field_as_dv']));
}
if (in_array($listing_field->field_type, array('multilist', 'list'))) {
$listing_field->addDisplayAsProperty($listing_field_info['display_as']);
}
// infil instructions should be the last element in form
if (!in_array($listing_field->getFieldType(), array('complex', 'tree', 'location'))) {
if ($form_submitted) {
$listing_field->addInfillInstructions(SJB_Request::getVar('instructions'));
} else {
$listing_field->addInfillInstructions(isset($listing_field_info['instructions']) ? $listing_field_info['instructions'] : '');
}
}
if ('tree' == $listing_field->getFieldType()) {
$listing_field->addProperty(SJB_TreeType::getDisplayAsDetail(isset($listing_field_info['display_as_select_boxes']) ? $listing_field_info['display_as_select_boxes'] : ''));
$treeLevelsNumber = SJB_ListingFieldTreeManager::getTreeDepthBySID($listing_field_sid);
$tp->assign('tree_levels_number', $treeLevelsNumber);
// treee levels captions
for ($i = 1; $i <= $treeLevelsNumber; $i++) {
$levelID = 'level_' . $i;
$listing_field->addProperty(array('id' => $levelID, 'caption' => $i . ' Level Name', 'value' => isset($listing_field_info[$levelID]) ? $listing_field_info[$levelID] : '', 'type' => 'string', 'length' => '250', 'is_required' => false, 'is_system' => true));
}
}
$edit_form = new SJB_Form($listing_field);
$errors = array();
if ($form_submitted && $edit_form->isDataValid($errors)) {
$old_listing_field_id = SJB_Request::getVar('old_listing_field_id', null);
SJB_ListingFieldManager::saveListingField($listing_field);
SJB_ListingFieldManager::changeListingPropertyIDs($listing_field_info['id'], $old_listing_field_id);
if ($form_submitted == 'save_info') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/listing-fields/');
}
}
$edit_form->registerTags($tp);
$edit_form->makeDisabled('type');
if ($listing_field_info['id'] == 'Location' && empty($errors['ID'])) {
$edit_form->makeDisabled('id');
}
$tp->assign('object_sid', $listing_field);
$tp->assign('form_fields', $edit_form->getFormFieldsInfo());
$tp->assign('errors', $errors);
$tp->assign('field_type', $listing_field->getFieldType());
$tp->assign('listing_field_info', $listing_field_info);
$tp->assign('field_sid', $listing_field_sid);
$tp->display('edit_listing_field.tpl');
}
}
function _createTreeInfo($tree_column_name, $tree_captions)
{
$tree_sid_searcher = new SJB_TreeInfoSearcher($tree_column_name, array($tree_captions[0]), $this->listing_type);
$tree_info = $tree_sid_searcher->getInfo();
$field_info = SJB_ListingFieldDBManager::getListingFieldInfoByID($tree_column_name);
$field_sid = $field_info['sid'];
if ($tree_info == null) {
SJB_ListingFieldTreeManager::addTreeItemToEndByParentSID($field_sid, 0, $tree_captions[0]);
}
$tree_info = $tree_sid_searcher->getInfo();
SJB_ListingFieldTreeManager::addTreeItemToEndByParentSID($field_sid, $tree_info['sid'], $tree_captions[1]);
$tree_sid_searcher = new SJB_TreeInfoSearcher($tree_column_name, $tree_captions, $this->listing_type);
$tree_info = $tree_sid_searcher->getInfo();
return $tree_info;
}
public static function moveTreeItemAfterBySID($item_sid, $after_tree_item_sid)
{
return SJB_ListingFieldTreeManager::moveItemAfterBySID($item_sid, $after_tree_item_sid);
}
public static function getTreeDepthBySID($field_sid)
{
return SJB_ListingFieldTreeManager::getTreeDepthBySID($field_sid);
}
function getNavigationElements($user_page_uri)
{
$page_uri = $user_page_uri;
$elements = array();
foreach ($this->params as $level => $param) {
$field = $this->_getFieldByLevel($level);
$metadata = $this->_getMetaDataByFieldData($field);
$page_uri = SJB_Path::combineURL($page_uri, $param);
if ($field['type'] == 'tree') {
$fieldInfo = SJB_ListingFieldTreeManager::getTreeItemInfoBySID($param);
$param = isset($fieldInfo['caption']) ? $fieldInfo['caption'] : $param;
}
$element = array('caption' => $param, 'uri' => $page_uri, 'metadata' => $metadata);
$elements[] = $element;
}
return $elements;
}
function setValue($value)
{
// in order to search child items also
if (!empty($value) && !is_array($value) && $this->property && $this->property->type->getDisplayAsSelectBoxes()) {
$values = explode(',', $value);
$valuesWithChild = $values;
foreach ($values as $parentNode) {
$childSIDs = SJB_ListingFieldTreeManager::getChildrenSIDBySID($parentNode);
$valuesWithChild = array_merge($valuesWithChild, $childSIDs);
}
$value = implode(',', $valuesWithChild);
}
$this->value = $value;
}
public function execute()
{
$template_processor = SJB_System::getTemplateProcessor();
$encodingFromCharset = SJB_Request::getVar('encodingFromCharset', 'UTF-8');
$file_info = SJB_Array::get($_FILES, 'imported_tree_file');
$field_sid = isset($_REQUEST['field_sid']) ? $_REQUEST['field_sid'] : null;
$field_info = SJB_ListingFieldManager::getFieldInfoBySID($field_sid);
$template_processor->assign("field", $field_info);
$template_processor->assign("field_sid", $field_sid);
$listing_type_info = SJB_ListingTypeManager::getListingTypeInfoBySID($field_info['listing_type_sid']);
$template_processor->assign("type_info", $listing_type_info);
$template_processor->assign('charSets', SJB_HelperFunctions::getCharSets());
if (!strcasecmp("tree", $field_info['type'])) {
if (empty($_FILES['imported_tree_file']['name'])) {
$errors['File'] = 'EMPTY_VALUE';
}
if (isset($_FILES['imported_tree_file']['error']) && $_FILES['imported_tree_file']['error']) {
$errors[] = SJB_UploadFileManager::getErrorId($_FILES['imported_tree_file']['error']);
}
$start_line = SJB_Request::getVar('start_line', null);
if (empty($start_line)) {
$errors['Start Line'] = 'EMPTY_VALUE';
} elseif (!is_numeric($start_line) || !is_int($start_line + 0)) {
$errors['Start Line'] = 'NOT_INT_VALUE';
}
$form_submitted = $_SERVER['REQUEST_METHOD'] == 'POST';
if ($form_submitted) {
if (!SJB_ImportFile::isValidFileExtensionByFormat($_REQUEST['file_format'], $_FILES['imported_tree_file'])) {
$errors['File'] = 'DO_NOT_MATCH_SELECTED_FILE_FORMAT';
}
}
$is_data_valid = empty($errors);
if ($form_submitted && $is_data_valid) {
if (!strcasecmp($_REQUEST['file_format'], 'excel')) {
$import_file = new SJB_ImportFileXLS($file_info);
} else {
$import_file = new SJB_ImportFileCSV($file_info, ',');
}
$import_file->parse($encodingFromCharset);
$imported_data = $import_file->getData();
$count = 0;
foreach ($imported_data as $key => $importedColumn) {
if (!$importedColumn || $start_line > $key) {
continue;
}
if (SJB_ListingFieldTreeManager::importTreeItem($field_sid, $importedColumn)) {
$count++;
}
}
$template_processor->assign("count", $count);
$template_processor->display("import_tree_data_statistics.tpl");
} else {
if (!$form_submitted) {
$errors = null;
}
$template_processor->assign("errors", isset($errors) ? $errors : null);
$template_processor->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$template_processor->display("import_tree_data.tpl");
}
} else {
echo 'invalid Tree SID is specified';
}
}
