public function execute()
{
$profiler = SJB_Profiler::getInstance();
if ($profiler->isProfilerEnable() && !SJB_Request::isAjax()) {
$memory = $profiler->getMemoryUsage();
$time = $profiler->getTimeElapsed();
$queries = $profiler->getQueries();
$functions = $profiler->getFunctions();
$countOfQueries = count($queries);
for ($i = 0; $i < $countOfQueries; $i++) {
$debugCount = count($queries[$i]['debug']);
for ($j = 0; $j <= $debugCount; $j++) {
if (isset($queries[$i]['debug'][$j]['args'])) {
unset($queries[$i]['debug'][$j]['args']);
}
if (isset($queries[$i]['debug'][$j]['object'])) {
unset($queries[$i]['debug'][$j]['object']);
}
}
}
$tp = SJB_System::getTemplateProcessor();
$tp->assign('functionCount', count($functions));
$tp->assign('queryCount', count($queries));
$tp->assign('functionInfo', $functions);
$tp->assign('queryInfo', $queries);
$tp->assign('memory', $memory);
$tp->assign('time', $time);
$tp->display('profiler.tpl');
}
}
/**
* @param SJB_TemplateProcessor $tp
* @param array $info
* @return SJB_Captcha
*/
public static function getInstance(SJB_TemplateProcessor $tp, $info = array())
{
if (self::$instance === null) {
$windowType = SJB_Request::isAjax() ? 'modal' : '';
self::$instance = new self($info, $windowType);
self::$instance->createCaptchaForm();
}
self::$instance->init($tp);
return self::$instance;
}
/**
*
* @param int $subAdminSID
* @param string $name
* @param string $value
*/
public static function SaveSubAdminNotifications($subAdminSID, $name, $value)
{
if (SJB_Request::isAjax() && $name && $value) {
$perm = 'true' === $value ? 'allow' : 'deny';
if (SJB_SubAdminAcl::setSubAdminNotificationByPermName($subAdminSID, $name, $perm)) {
exit('saved');
}
exit('failed');
}
return false;
}
public function execute()
{
$cachePath = SJB_BASE_DIR . "system/cache/markers";
if (SJB_Request::isAjax()) {
$fileSystem = new SJB_Filesystem();
$markers = $fileSystem->getFileNames($cachePath);
$response = count($markers) ? json_encode($markers) : '';
exit($response);
}
$grayImage = SJB_BASE_DIR . "templates/_system/main/images/marker_gray.gif";
$greenImage = SJB_BASE_DIR . "templates/_system/main/images/marker_green.gif";
$orangeImage = SJB_BASE_DIR . "templates/_system/main/images/marker_orange.gif";
$blueImage = SJB_BASE_DIR . "templates/_system/main/images/marker_blue.gif";
$pinkImage = SJB_BASE_DIR . "templates/_system/main/images/marker_pink.gif";
$type = SJB_Request::getVar('type', 'Job');
$text = SJB_Request::getVar('text', '');
$filename = '';
$assets = array('Job' => $orangeImage, 'priority' => $orangeImage, 'indeed' => $blueImage, 'simplyHired' => $greenImage, 'beyond' => $grayImage, 'Resume' => $orangeImage);
if (array_key_exists($type, $assets)) {
$filename = $assets[$type];
} else {
$filename = $grayImage;
}
$cacheFilename = $cachePath . "/marker_" . $type . '_' . $text . ".gif";
$img = null;
if (!file_exists($cacheFilename)) {
if ($filename == $pinkImage || !empty($text) && is_string($text) && !empty($filename)) {
$img = imagecreatefromgif($filename);
$imageSx = imagesx($img);
$imageSy = imagesy($img);
$fontSize = 8;
$textLen = strlen($text);
$black = imageColorAllocate($img, 0, 0, 0);
$white = imageColorAllocate($img, 255, 255, 255);
if (!empty($text)) {
imagettftext($img, $fontSize, 0, $imageSx / 2 - floor($fontSize / 2 * $textLen) + 2, 13, $black, SJB_BASE_DIR . "templates/_system/main/images/arial.ttf", $text);
}
if (!file_exists($cachePath)) {
mkdir($cachePath, 0777);
}
imagegif($img, $cachePath . "/marker_" . $type . '_' . $text . ".gif");
}
} else {
$img = imagecreatefromgif($cacheFilename);
}
if (!is_null($img)) {
header("Content-type: image/gif");
imagegif($img);
}
exit;
}
public function execute()
{
if (SJB_Request::isAjax()) {
die(json_encode($this->getPayPalStateList()));
}
$getInvoiceId = SJB_Request::getInt('payment_id', 0, 'GET');
$this->invoice = SJB_InvoiceManager::getObjectBySID($getInvoiceId);
if ($this->invoiceValidation($this->invoice)) {
if ($this->isPayNowButtonPressed()) {
$this->processPayNowButtonClick();
} else {
$this->displayForm();
}
}
}
/**
*
* @param SJB_PageConfig $page_config
*/
public static function getPage($page_config)
{
SJB_System::setPageTitle($page_config->getPageTitle());
SJB_System::setGlobalTemplateVariable('user_page_uri', $page_config->getPageUri());
SJB_System::setPageKeywords($page_config->getPageKeywords());
SJB_System::setPageDescription($page_config->getPageDescription());
if ($page_config->getMainContentFunction() == 'add_listing') {
$passed_parameters_via_uri = SJB_Request::getVar('passed_parameters_via_uri', false);
if ($passed_parameters_via_uri) {
$passed_parameters_via_uri = SJB_UrlParamProvider::getParams();
if (isset($passed_parameters_via_uri[2])) {
$page_config->setMainContentFunction('add_listing_step');
}
}
}
$maincontent = SJB_System::executeFunction($page_config->getMainContentModule(), $page_config->getMainContentFunction(), $page_config->getParameters(), $page_config->getPageUri());
if ($page_config->hasRawOutput()) {
return $maincontent;
}
$page_templates_set_name = SJB_System::getSystemSettings('PAGE_TEMPLATES_MODULE_NAME');
$template_supplier = new SJB_TemplateSupplier($page_templates_set_name);
$tp = new SJB_TemplateProcessor($template_supplier);
// assign 'highlight_templates' variable to main or index template
if (SJB_Settings::getSettingByName('highlight_templates') == 1 && SJB_Request::getVar('admin_mode', false, 'COOKIE')) {
$tp->assign('highlight_templates', true);
}
if ($errors = SJB_Error::getErrorContent()) {
SJB_FlashMessages::getInstance()->addWarning($errors);
}
$tp->assign('MAIN_CONTENT', $maincontent);
$tp->registerGlobalVariables();
$tp->assign('sjb_version', SJB_System::getSystemSettings('SJB_VERSION'));
$template = $page_config->getPageTemplate();
$template_supplier->addContainerTemplate($template);
if (SJB_Request::isAjax()) {
$template = SJB_System::getSettingByName('default_page_template_by_http');
} elseif (SJB_FormBuilderManager::getIfBuilderModeIsSet()) {
$template = 'index_b.tpl';
} else {
if (empty($template)) {
$template = SJB_Settings::getSettingByName('DEFAULT_PAGE_TEMPLATE');
}
}
return $tp->fetch($template);
}
public function execute()
{
$bannersObj = new SJB_Banners();
$params = $_REQUEST;
$bannerId = $params['bannerId'];
if (SJB_Request::isAjax()) {
$response = array('success' => $bannersObj->deleteBannerImage($bannerId), 'error' => SJB_I18N::getInstance()->gettext('Backend', $bannersObj->bannersError));
die(json_encode($response));
}
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$banner = array_merge($bannersObj->getBannerProperties($bannerId), $params);
$form_submitted = SJB_Request::getVar('submit');
$filesDir = SJB_System::getSystemSettings('FILES_DIR');
if (isset($_REQUEST['action'])) {
$action_name = $_REQUEST['action'];
switch ($action_name) {
case 'edit':
// ERRORS
if ($params['title'] == '') {
$errors[] = 'Banner Title is empty.';
}
if ($params['link'] == '' && $params['bannerType'] != 'code') {
$errors[] = 'Banner link mismatched!';
}
if ($params['bannerType'] == 'code' && $params['code'] == '') {
$errors[] = 'Banner code is empty.';
}
if ($params['bannerType'] == 'file' && $_FILES['image']['name'] == '' && empty($params['imagePath'])) {
$errors[] = 'No image attached!';
}
if ($_FILES['image']['name'] && $_FILES['image']['error']) {
$errors[SJB_UploadFileManager::getErrorId($_FILES['image']['error'])] = 1;
}
if ($errors) {
break;
}
// if image changed - save it
if ($_FILES['image']['name'] != '' && $_FILES['image']['tmp_name'] != '') {
$hashName = md5(time() * $_FILES['image']['size'] . "_" . $_FILES['image']['name']);
$ext = preg_match("|\\.(\\w{3})\\b|", $_FILES['image']['name'], $arr);
$bannerFilePath = $filesDir . "banners/" . $hashName . "." . $arr[1];
// move file from temporary folder, and fill banner info to DB
$copy = copy($_FILES['image']['tmp_name'], $bannerFilePath);
if (!$copy) {
$errors = 'Cannot copy file from TMP dir to Banners Dir';
break;
}
if ($_FILES['image']['type'] != 'application/x-shockwave-flash') {
// array of bannerInfo
// [0] - width
// [1] - height
// [2] - ??
// [3] - width & height in next view: width="104" height="150"
// [bits] - bit size of image
// [channels]
// [mime] - type, (image/jpeg, image/gif, image/png )
$bannerInfo = getimagesize($bannerFilePath);
if ($params['width'] != '' && $params['height'] != '') {
$sx = $params['width'];
$sy = $params['height'];
} else {
$sx = $bannerInfo[0];
$sy = $bannerInfo[1];
}
$type = $bannerInfo['mime'];
} else {
if ($params['width'] == '' || $params['height'] == '') {
$errors[] = 'SIZE_PARAMETER_MISMATCHED';
break;
}
$sx = $params['width'];
$sy = $params['height'];
$type = $_FILES['image']['type'];
}
$bannerFilePath = "/" . str_replace("../", "/", str_replace(SJB_BASE_DIR, '', $bannerFilePath));
// now delete old banner image
$bannersObj->deleteBannerImage($bannerId);
} else {
// if image not changed - leave it as is
$bannerOldInfo = $bannersObj->getBannerProperties($params['bannerId']);
$sx = $bannerOldInfo['width'];
$sy = $bannerOldInfo['height'];
if ($params['width'] != '' && $params['height'] != '') {
if ($params['width'] != $sx || $params['height'] != $sy) {
$sx = $params['width'];
$sy = $params['height'];
}
}
$type = $bannerOldInfo['type'];
$bannerFilePath = $bannerOldInfo['image_path'];
}
$title = $params['title'];
$link = $params['link'];
$active = $params['active'];
$group = $params['groupSID'];
// check 'link' for correct. If it hasn't 'http://' or 'https://' - add them
$expr = preg_match("/^(https?:\\/\\/)/", $link);
if ($expr != true && $params['bannerType'] != 'code') {
$link = "http://" . $link;
}
if ($params['bannerType'] == 'code') {
$bannersObj->deleteBannerImage($bannerId);
}
$result = $bannersObj->updateBanner($params['bannerId'], $title, $link, $bannerFilePath, $sx, $sy, $type, $active, $group, $params);
if ($form_submitted == 'save_banner') {
$site_url = SJB_System::getSystemsettings('SITE_URL') . "/edit-banner-group/?groupSID={$group}";
} else {
$site_url = SJB_System::getSystemsettings('SITE_URL') . "/edit-banner/?bannerId=" . $bannerId;
}
SJB_HelperFunctions::redirect($site_url);
break;
}
}
$banner_fields = $bannersObj->getBannersMeta();
$tp->assign("banner_fields", $banner_fields);
$tp->assign("banner", $banner);
$tp->assign('errors', $errors);
$tp->assign('bannersPath', SJB_Banners::getSiteUrl());
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->display("edit_banner.tpl");
}
public function execute()
{
set_time_limit(0);
ini_set('memory_limit', -1);
$tp = SJB_System::getTemplateProcessor();
$user_groups_info = SJB_UserGroupManager::getAllUserGroupsInfo();
$user_group_info = reset($user_groups_info);
$user_group_sid = $user_group_info['sid'];
$fields_info = SJB_UserProfileFieldManager::getFieldsInfoByUserGroupSID($user_group_sid);
$fields = array();
$tp->assign('test_message', SJB_Request::getVar('test_message', false));
$tp->assign('undeliveredMailingsForTest', SJB_Request::getVar('undeliveredMailingsForTest', false));
foreach ($fields_info as $key => $val) {
if ($val['id'] == 'Location') {
foreach ($val['fields'] as $field) {
if ($field['id'] == 'Country') {
$fields['country'] = SJB_CountriesManager::getAllCountriesCodesAndNames();
} elseif ($field['id'] == 'State') {
$fields['state'] = SJB_StatesManager::getStatesNamesByCountry();
}
}
}
}
$tp->assign('fields', $fields);
$errors = array();
$errorId = SJB_Request::getVar('error', null, 'GET');
if ($errorId) {
$errors[$errorId] = 1;
}
if (isset($_REQUEST['submit']) && $_FILES['file_mail']['name'] && $_FILES['file_mail']['error']) {
$errorId = SJB_UploadFileManager::getErrorId($_FILES['file_mail']['error']);
if ($_REQUEST['submit'] != 'save') {
$mailID = SJB_Request::getVar('mail_id', 0);
$parameter = $mailID ? '?edit=' . $mailID : '';
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/mailing/' . $parameter . '&error=' . $errorId);
}
$errors[$errorId] = 1;
} else {
if (isset($_REQUEST['submit'])) {
SJB_DB::query("DELETE FROM uploaded_files WHERE id = 'file_mail'");
$upload_manager = new SJB_UploadFileManager();
$upload_manager->setFileGroup('files');
$upload_manager->setUploadedFileID('file_mail');
$upload_manager->uploadFile('file_mail');
$file_name = '';
if (!isset($_REQUEST['delete_file']) && isset($_REQUEST['old_file']) && !$upload_manager->getUploadedFileName('file_mail')) {
$file_name = $_REQUEST['old_file'];
} elseif ($upload_manager->getUploadedFileName('file_mail')) {
$file_name = "files/files/" . $upload_manager->getUploadedSavedFileName('file_mail');
}
$language = SJB_Request::getVar('language', 'any');
$users = SJB_Request::getVar('users', 'any');
$without_cv = SJB_Request::getVar('without_cv', false);
$country = SJB_Request::getVar('country', '');
$state = SJB_Request::getVar('state', '');
$city = SJB_Request::getVar('city', '');
$products = SJB_Request::getVar('products', array());
$user_status = SJB_Request::getVar('user_status', '');
$registration_date = SJB_Request::getVar('registration_date', array());
$param = serialize(array('language' => $language, 'users' => $users, 'without_cv' => $without_cv, 'products' => $products, 'country' => $country, 'state' => $state, 'city' => $city, 'status' => $user_status, 'registration' => $registration_date));
$email = '';
$mailSubject = SJB_Request::getVar('subject', '');
$mailText = stripcslashes(SJB_Request::getVar('text', ''));
$mailID = SJB_Request::getVar('mail_id', 0);
if ($mailID) {
SJB_DB::query('UPDATE `mailing` SET
`subject` = ?s,
`text` = ?s,
`email` = ?s,
`file` = ?s,
`param` = ?s
WHERE `id` = ?s', $mailSubject, $mailText, $email, $file_name, $param, $mailID);
} else {
$query = "INSERT INTO mailing ( email , subject , text , file, param) VALUES ( ?s, ?s, ?s, ?s, ?s)";
SJB_DB::query($query, $email, $mailSubject, $mailText, $file_name, $param);
}
if ($_REQUEST['submit'] == 'save') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/mailing/');
} else {
$parameter = $mailID ? '?edit=' . $mailID : '';
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/mailing/' . $parameter);
}
}
}
if (SJB_Request::getVar('delete')) {
$mailings = SJB_Request::getVar('mailing');
if (is_array($mailings)) {
foreach ($mailings as $id => $value) {
SJB_DB::query('DELETE FROM `mailing` WHERE `id` = ?n', $id);
SJB_DB::query('DELETE FROM `mailing_info` WHERE `mailing_id` = ?n', $id);
}
} else {
$idToDelete = SJB_Request::getInt('delete', 0);
SJB_DB::query('DELETE FROM `mailing` WHERE `id` = ?n', $idToDelete);
SJB_DB::query('DELETE FROM `mailing_info` WHERE `mailing_id` = ?n', $idToDelete);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/mailing/');
}
if (isset($_REQUEST['edit'])) {
$idToEdit = SJB_Request::getInt('edit', 0);
$mail_arr = SJB_DB::query('SELECT * FROM mailing WHERE id = ?n', $idToEdit);
$tp->assign("mail_id", $mail_arr[0]['id']);
$tp->assign("subject", $mail_arr[0]['subject']);
$tp->assign("text", $mail_arr[0]['text']);
$tp->assign("file", $mail_arr[0]['file']);
$tp->assign("file_url", $mail_arr[0]['file']);
$tp->assign("param", unserialize($mail_arr[0]['param']));
}
// get products by UserGroup ID
if (SJB_Request::isAjax()) {
$userGroupID = SJB_Request::getVar('usergr', 0);
if ($userGroupID > 0) {
$products = SJB_ProductsManager::getProductsInfoByUserGroupSID($userGroupID);
} else {
$products = SJB_ProductsManager::getAllProductsInfo();
}
$tp->assign("products", $products);
$tp->display("mailing_products.tpl");
exit;
}
$mail_list = SJB_DB::query('SELECT * FROM mailing');
foreach ($mail_list as $key => $var) {
$param = unserialize($mail_list[$key]['param']);
$where = '';
$join = '';
$numSentEmails = SJB_DB::queryValue('SELECT count(*) FROM `mailing_info` WHERE `mailing_id` = ?n AND `status`=0', $var['id']);
if ($param["language"] != 'any') {
$where .= " and language='{$param['language']}'";
}
if ($param["users"] != '0') {
$where .= ' and u.user_group_sid=' . $param['users'];
}
if ($param["without_cv"]) {
$join = "left join listings l on l.user_sid = u.sid";
$where .= " and l.sid is null";
}
// user status
if (!empty($param['status'])) {
$where .= ' and `u`.`active`=' . (int) $param['status'];
}
// registration date
if (!empty($param['registration']) && is_array($param['registration'])) {
$i18n = SJB_I18N::getInstance();
if (!empty($param['registration']['not_less'])) {
$where .= ' AND `u`.`registration_date` > \'' . $i18n->getInput('date', $param['registration']['not_less']) . '\'';
}
if (!empty($param['registration']['not_more'])) {
$where .= ' AND `u`.`registration_date` < \'' . $i18n->getInput('date', $param['registration']['not_more']) . '\'';
}
}
// products
if (!empty($param['products'])) {
$join .= "\n LEFT JOIN contracts ON u.sid = contracts.user_sid\n LEFT JOIN products ON products.sid = contracts.product_sid\n ";
$whereProduct = array();
foreach ($param['products'] as $theProduct) {
$theProduct = (int) $theProduct;
if (!empty($theProduct)) {
$whereProduct[] .= "products.sid = '{$theProduct}'";
} else {
$whereProduct[] .= 'products.sid IS NULL';
}
}
if (!empty($whereProduct)) {
$where .= ' AND (' . implode(' OR ', $whereProduct) . ')';
}
}
/// products
if (!empty($param['country']) || !empty($param['state'])) {
if (!empty($param['country'])) {
$where_country = array();
foreach ($param['country'] as $the_country) {
if (!empty($the_country)) {
$where_country[] .= "`u`.`Location_Country` = '{$the_country}'";
} else {
$where_country[] .= "`u`.`Location_Country` IS NULL";
}
}
if (!empty($where_country)) {
$where .= ' AND (' . implode(' OR ', $where_country) . ')';
}
}
if (!empty($param['state'])) {
$where_state = array();
foreach ($param['state'] as $the_state) {
if (!empty($the_state)) {
$where_state[] .= "`u`.`Location_State` = '{$the_state}'";
} else {
$where_state[] .= "`u`.`Location_State` IS NULL";
}
}
}
if (!empty($where_state)) {
$where .= ' AND (' . implode(' OR ', $where_state) . ')';
}
if (!empty($param['city'])) {
$where .= " AND `u`.`Location_City` = '{$param['city']}'";
}
}
$mail_list[$key]['not_send'] = $numSentEmails;
$mail_list[$key]['mail_arr'] = SJB_DB::query("\n SELECT u.sid as sid, u.username, u.user_group_sid, u.language\n FROM users u\n {$join}\n WHERE u.sendmail = 0\n {$where}\n GROUP BY `u`.`sid`");
$mail_list[$key]['count'] = count($mail_list[$key]['mail_arr']);
}
/*
* test sending
*/
$testMailingID = SJB_Request::getVar('test_send', 0);
if ($testMailingID) {
if ($this->isTestEmailValid()) {
$testSendResult = false;
$oMailing = new SJB_Mailing($testMailingID);
$mailings = SJB_Request::getVar('mailing');
if (is_array($mailings)) {
foreach ($mailings as $id => $value) {
$oMailing->setMailingID($id);
$oMailing->setMailingList($mail_list);
if ($oMailing->testSend()) {
$testSendResult = true;
}
}
} else {
$oMailing->setMailingList($mail_list);
$testSendResult = $oMailing->testSend();
}
if ($testSendResult) {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/mailing/?test_message=1');
} else {
$email = urlencode(SJB_Request::getString('email', false));
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/mailing/?undeliveredMailingsForTest={$email}");
}
} else {
$tp->assign('testEmailNotValid', true);
}
}
// general sending
$sendToMailingID = SJB_Request::getVar('sending', 0);
$sendResult = false;
if ($sendToMailingID) {
$oMailing = new SJB_Mailing($sendToMailingID);
$mailings = SJB_Request::getVar('mailing');
$undeliveredMailingsInfo = array();
if (is_array($mailings)) {
foreach ($mailings as $id => $value) {
$oMailing->setMailingID($id);
$oMailing->setMailingList($mail_list);
$countOfSendMailings = $oMailing->send();
if ($countOfSendMailings != 0) {
$sendResult = true;
}
$undeliveredMailingsInfo = array_merge($oMailing->getUndeliveredMailingsInfo(), $undeliveredMailingsInfo);
}
} else {
$oMailing->setMailingList($mail_list);
$countOfSendMailings = $oMailing->send();
if ($countOfSendMailings != 0) {
$sendResult = true;
}
$undeliveredMailingsInfo = $oMailing->getUndeliveredMailingsInfo();
}
if ($sendResult) {
$tp->assign('send_result', $sendResult);
}
if (count($undeliveredMailingsInfo)) {
$tp->assign("UndeliveredMailings", $oMailing->getUndeliveredMailingsInfo());
}
}
// send mailing to undelivered
$sendToUndeliveredMailingID = SJB_Request::getVar('sendToUndeliveredEmails', 0);
if (!empty($sendToUndeliveredMailingID)) {
$oMailing = new SJB_Mailing($sendToUndeliveredMailingID);
$oMailing->setMailingList($mail_list);
$oMailing->sendToUndelivered();
if ($oMailing->getUndeliveredMailingsInfo()) {
$tp->assign("UndeliveredMailings", $oMailing->getUndeliveredMailingsInfo());
}
}
$groups = SJB_DB::query("SELECT * FROM `user_groups`");
$products = SJB_ProductsManager::getAllProductsInfo();
$testEmail = SJB_Settings::getSettingByName('test_email');
$tp->assign('test_email', $testEmail);
$tp->assign("products", $products);
$tp->assign("groups", $groups);
$tp->assign("mail_list", $mail_list);
$tp->assign('errors', $errors);
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->display("mailing.tpl");
}
public function execute()
{
$errors = array();
if (SJB_Request::isAjax()) {
$response = null;
if ($logoId = SJB_Request::getVar('logo_id')) {
SJB_UploadFileManager::deleteUploadedFileByID($logoId, 'logo');
$parsersId = SJB_Request::getVar('id');
SJB_DB::query("UPDATE `parsers` SET `xml_logo` = NULL WHERE id = ?n", $parsersId);
} elseif ($userName = SJB_Request::getVar('parser_user')) {
$userType = SJB_Request::getVar('user_type');
$products = SJB_XmlImport::getProducts($userType, $userName, $errors);
$response = array('products' => empty($products) ? '' : SJB_XmlImport::translateProductsName($products), 'error' => empty($errors) ? '' : array_pop($errors));
$response = json_encode($response);
}
die($response);
}
$tp = SJB_System::getTemplateProcessor();
$original_xml = !empty($_REQUEST['xml']) ? $_REQUEST['xml'] : '';
$xml = $original_xml;
$tree = '';
$listing_fields = array();
$parsing_name = isset($_REQUEST['parser_name']) ? $_REQUEST['parser_name'] : '';
$usr_name = isset($_REQUEST['parser_user']) ? $_REQUEST['parser_user'] : '';
$pars_url = isset($_REQUEST['parser_url']) ? $_REQUEST['parser_url'] : '';
$form_description = isset($_POST['form_description']) ? $_POST['form_description'] : "";
$type_id = isset($_POST['type_id']) ? intval($_POST['type_id']) : "";
$custom_script = SJB_Request::getVar('custom_script', '');
$custom_script_users = SJB_Request::getVar('custom_script_users', '');
$add_new_user = isset($_POST['add_new_user']) ? intval($_POST['add_new_user']) : 0;
$username = SJB_Request::getVar('username', '');
$external_id = SJB_Request::getVar('external_id', '');
$defaultValue = array();
$logo_options_array = array('not_logo' => 'Do Not Import Logo', 'import_logo' => 'Import Logo with Listings', 'upload_logo' => 'Upload Logo for Imported Listings');
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
$selected = array();
$a_selected = array();
$selectedLogoOption = null;
$selectedLogoField = null;
$xml_logo = null;
$selectedProduct = SJB_Request::getVar('postUnderProduct');
$save_error = SJB_Request::getVar('save_error');
if ($save_error) {
$errors[] = base64_decode($save_error);
}
if (!empty($_REQUEST['xml']) || $id > 0) {
// step 2 OR edit exist
if ($id > 0) {
// load exist parser
$parser_from_id = SJB_XmlImport::getSystemParsers($id);
if (isset($parser_from_id[0]['name'])) {
$parser_from_id = $parser_from_id[0];
}
$parsing_name = $parser_from_id['name'];
$usr_id = $parser_from_id['usr_id'];
$usr_name = $parser_from_id['usr_name'];
$form_description = $parser_from_id['description'];
$pars_url = $parser_from_id['url'];
$type_id = $parser_from_id['type_id'];
$custom_script = $parser_from_id['custom_script'];
$custom_script_users = $parser_from_id['custom_script_users'];
$add_new_user = $parser_from_id['add_new_user'];
$importType = $parser_from_id['import_type'];
$xml = $parser_from_id['xml'];
$xml_logo = $parser_from_id['xml_logo'];
$xml = SJB_XmlImport::cleanXmlFromImport($xml);
$defaultValue = $parser_from_id['default_value'] != '' ? unserialize($parser_from_id['default_value']) : array();
$username = $parser_from_id['username'];
$map = unserialize($parser_from_id['maper']);
$external_id = str_replace('@', '_dog_', $parser_from_id['external_id']);
$selected_logo_options = unserialize($parser_from_id['logo_options']);
$selectedLogoOption = $selected_logo_options['option'];
$selectedLogoField = $selected_logo_options['field'];
if ($selected_logo_options['option'] == 'upload_logo') {
$upload_manager = new SJB_UploadPictureManager();
$upload_manager->getUploadedPictureInfo($xml_logo . '_thumb');
$logo_link = $upload_manager->getUploadedFileLink($xml_logo . '_thumb');
$tp->assign('logo_link', $logo_link);
}
foreach ($map as $key => $val) {
unset($map[$key]);
$key = SJB_XmlImport::encodeSpecialEntities($key);
$map[$key] = $val;
}
$selected = array_values($map);
$a_selected = array_keys($map);
$selectedProduct = $parser_from_id['product_sid'];
} else {
$xml = SJB_XmlImport::cleanXmlFromImport($_REQUEST['xml']);
}
$sxml = new simplexml();
$xml = stripslashes($xml);
$tree = $sxml->xml_load_file($xml, 'array');
if (isset($tree['@content'])) {
$tree = $tree[0];
}
if (is_array($tree)) {
$tree = SJB_XmlImport::convertArray($tree);
foreach ($tree as $key => $val) {
unset($tree[$key]);
$key = SJB_XmlImport::encodeSpecialEntities($key);
$tree[$key]['val'] = $val;
$tree[$key]['key'] = $key;
}
$field_types = array(0, $type_id);
$listing_fields = array();
$i = 0;
foreach ($field_types as $type) {
$listing_fields_info = SJB_ListingFieldManager::getListingFieldsInfoByListingType($type);
foreach ($listing_fields_info as $listing_field_info) {
if ($listing_field_info['type'] == 'location') {
foreach ($listing_field_info['fields'] as $fieldInfo) {
$listing_field = new SJB_ListingField($fieldInfo);
$listing_field->setSID($fieldInfo['sid']);
$listing_fields[$i]['id'] = $listing_field_info['id'] . '_' . $listing_field->details->properties['id']->value;
$listing_fields[$i]['caption'] = $listing_field->details->properties['id']->value;
$i++;
}
} else {
$listing_field = new SJB_ListingField($listing_field_info);
$listing_field->setSID($listing_field_info['sid']);
$listing_fields[$i]['id'] = $listing_field->details->properties['id']->value;
$listing_fields[$i]['caption'] = $listing_field->details->properties['id']->value;
$i++;
}
}
}
$listing_fields[$i]['id'] = $listing_fields[$i]['caption'] = "date";
$i++;
$listing_fields[$i]['id'] = $listing_fields[$i]['caption'] = "url";
$i++;
$listing_fields[$i]['id'] = $listing_fields[$i]['caption'] = "external_id";
} else {
$errors[] = 'XML syntaxis error.';
}
} else {
$errors[] = 'Please input correct xml';
}
if (empty($selectedProduct)) {
$errors[] = 'Please select a product';
}
if (!filter_var($pars_url, FILTER_VALIDATE_URL)) {
$errors[] = 'Please input correct URL';
}
$error = SJB_Request::getVar('error', false, 'GET');
if ($error) {
$errors[$error] = true;
}
$userType = empty($add_new_user) ? 'username' : 'group';
if ($userType == 'group') {
$userName = SJB_UserGroupManager::getUserGroupSIDByID($usr_name);
} else {
$userName = $usr_name;
}
$products = SJB_XmlImport::getProducts($userType, $userName, $errors);
$tp->assign('id', $id);
$tp->assign('selected', $selected);
$tp->assign('a_selected', $a_selected);
$tp->assign('xml', htmlspecialchars($xml));
$tp->assign('xml_logo', $xml_logo);
$tp->assign('xmlToUser', $xml);
$tp->assign('default_value', $defaultValue);
$tp->assign('form_name', $parsing_name);
$tp->assign('form_user', $usr_name);
$tp->assign('form_user_sid', $usr_id);
$tp->assign('form_url', $pars_url);
$tp->assign('form_description', $form_description);
$tp->assign('custom_script', $custom_script);
$tp->assign('custom_script_users', $custom_script_users);
$tp->assign('username', $username);
$tp->assign('external_id', $external_id);
$tp->assign('import_type', $importType);
$tp->assign('user_groups', SJB_UserGroupManager::getAllUserGroupsInfo());
$type_name = SJB_ListingTypeManager::getListingTypeIDBySID($type_id);
$tp->assign('add_new_user', $add_new_user);
$tp->assign('type_id', $type_id);
$tp->assign('type_name', $type_name);
$tp->assign('errors', $errors);
$tp->assign('tree', $tree);
$tp->assign("fields", $listing_fields);
$tp->assign('logo_options', $logo_options_array);
$tp->assign('selectedLogoOption', $selectedLogoOption);
$tp->assign('selectedLogoField', $selectedLogoField);
$tp->assign('selectedProduct', $selectedProduct);
$tp->assign('products', $products);
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->display('add_step_two.tpl');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$registration_form_template = 'registration_form.tpl';
if (SJB_Authorization::isUserLoggedIn()) {
$tp->display('already_logged_in.tpl');
return;
}
$tp->assign('terms_of_use_check', SJB_System::getSettingByName('terms_of_use_check'));
$user_group_id = SJB_Request::getVar('user_group_id', null);
if (!is_null($user_group_id)) {
$user_group_sid = SJB_UserGroupManager::getUserGroupSIDByID($user_group_id);
if (empty($user_group_sid)) {
$errors['NO_SUCH_USER_GROUP_IN_THE_SYSTEM'] = 1;
}
}
$this->setSessionValueForRedirectAfterRegister();
if (!is_null($user_group_id) && empty($errors)) {
$user_group_info = SJB_UserGroupManager::getUserGroupInfoBySID($user_group_sid);
$user = SJB_ObjectMother::createUser($_REQUEST, $user_group_sid);
if (SJB_Request::isAjax() || 'true' == SJB_Request::getVar('isajaxrequest')) {
$field = SJB_Request::getVar('type');
if ('email' == $field) {
$user->getProperty($field)->type->disableEmailConfirmation();
}
echo $user->getProperty($field)->isValid();
exit;
}
$user->deleteProperty('active');
$user->deleteProperty('featured');
$form_submitted = SJB_Request::getVar('action', false) == 'register';
if (class_exists('MobilePlugin') && MobilePlugin::isMobileThemeOn()) {
$user->prepareRegistrationFields();
}
$registration_form = SJB_ObjectMother::createForm($user);
$registration_form->registerTags($tp);
if (SJB_UserGroupManager::isUserEmailAsUsernameInUserGroup($user_group_sid) && $form_submitted) {
$email = $user->getPropertyValue('email');
if (is_array($email)) {
$email = $email['original'];
}
$user->setPropertyValue('username', $email);
}
if ($form_submitted && $registration_form->isDataValid($errors)) {
$user->deleteProperty('captcha');
$defaultProduct = SJB_UserGroupManager::getDefaultProduct($user_group_sid);
SJB_UserManager::saveUser($user);
SJB_Statistics::addStatistics('addUser', $user->getUserGroupSID(), $user->getSID());
$availableProductIDs = SJB_ProductsManager::getProductsIDsByUserGroupSID($user_group_sid);
if ($defaultProduct && in_array($defaultProduct, $availableProductIDs)) {
$contract = new SJB_Contract(array('product_sid' => $defaultProduct));
$contract->setUserSID($user->getSID());
$contract->saveInDB();
}
// >>> SJB-1197
// needs to check session for ajax-uploaded files, and set it to user profile
$formToken = SJB_Request::getVar('form_token');
$tmpUploadsStorage = SJB_Session::getValue('tmp_uploads_storage');
if (!empty($formToken)) {
$tmpUploadedFields = SJB_Array::getPath($tmpUploadsStorage, $formToken);
if (!is_null($tmpUploadsStorage) && is_array($tmpUploadedFields)) {
// prepare user profile fields array
$userProfileFieldsInfo = SJB_UserProfileFieldManager::getAllFieldsInfo();
$userProfileFields = array();
foreach ($userProfileFieldsInfo as $field) {
$userProfileFields[$field['id']] = $field;
}
// look for temporary values
foreach ($tmpUploadedFields as $fieldId => $fieldInfo) {
// check field ID for valid ID in user profile fields
if (!array_key_exists($fieldId, $userProfileFields) || empty($fieldInfo)) {
continue;
}
$fieldType = $userProfileFields[$fieldId]['type'];
$profilePropertyId = $fieldId . '_' . $user->getSID();
switch (strtolower($fieldType)) {
case 'video':
case 'file':
// change temporary file ID
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` = ?s", $profilePropertyId, $fieldInfo['file_id']);
// set value of user property to new uploaded file
$user->setPropertyValue($fieldId, $profilePropertyId);
break;
case 'logo':
// change temporary file ID and thumb ID
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` = ?s", $profilePropertyId, $fieldInfo['file_id']);
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` = ?s", $profilePropertyId . '_thumb', $fieldInfo['file_id'] . '_thumb');
// set value of user property to new uploaded file
$user->setPropertyValue($fieldId, $profilePropertyId);
break;
default:
break;
}
$tmpUploadsStorage = SJB_Array::unsetValueByPath($tmpUploadsStorage, "{$formToken}/{$fieldId}");
}
// save user with new values
SJB_UserManager::saveUser($user);
// clean temporary storage
$tmpUploadsStorage = SJB_Array::unsetValueByPath($tmpUploadsStorage, "{$formToken}");
// CLEAR TEMPORARY SESSION STORAGE
SJB_Session::setValue('tmp_uploads_storage', $tmpUploadsStorage);
}
}
// <<< SJB-1197
// notifying administrator
SJB_AdminNotifications::sendAdminUserRegistrationLetter($user);
// Activation
$isSendActivationEmail = SJB_UserGroupManager::isSendActivationEmail($user_group_sid);
$isApproveByAdmin = SJB_UserGroupManager::isApproveByAdmin($user_group_sid);
if ($isApproveByAdmin) {
SJB_UserManager::setApprovalStatusByUserName($user->getUserName(), 'Pending');
}
if ($isSendActivationEmail) {
$fromAnonymousShoppingCart = SJB_Session::getValue('fromAnonymousShoppingCart');
SJB_Session::unsetValue('fromAnonymousShoppingCart');
$isSent = SJB_Notifications::sendUserActivationLetter($user->getSID(), $fromAnonymousShoppingCart ? true : false);
if ($isSent) {
$registration_form_template = 'registration_confirm.tpl';
} else {
SJB_FlashMessages::getInstance()->addWarning('ERROR_SEND_ACTIVATION_EMAIL');
$registration_form_template = 'registration_failed_to_send_activation_email.tpl';
}
} else {
if (!$isSendActivationEmail && $isApproveByAdmin) {
SJB_UserManager::setApprovalStatusByUserName($user->getUserName(), 'Pending');
$registration_form_template = 'registration_pending.tpl';
} else {
SJB_UserManager::activateUserByUserName($user->getUserName());
if (!SJB_SocialPlugin::getProfileSocialID($user->getSID())) {
SJB_Notifications::sendUserWelcomeLetter($user->getSID());
}
SJB_Authorization::login($user->getUserName(), $_REQUEST['password']['original'], false, $errors);
$proceedToPosting = SJB_Session::getValue('proceed_to_posting');
if ($proceedToPosting) {
$redirectUrl = SJB_HelperFunctions::getSiteUrl() . '/add-listing/?listing_type_id=' . SJB_Session::getValue('listing_type_id') . '&proceed_to_posting=' . $proceedToPosting . '&productSID=' . SJB_Session::getValue('productSID');
} else {
$pageId = !empty($user_group_info['after_registration_redirect_to']) ? $user_group_info['after_registration_redirect_to'] : '';
$redirectUrl = SJB_UserGroupManager::getRedirectUrlByPageID($pageId);
}
SJB_HelperFunctions::redirect($redirectUrl);
}
}
} else {
if (SJB_UserGroupManager::isUserEmailAsUsernameInUserGroup($user_group_sid)) {
$user->deleteProperty('username');
}
$registration_form = SJB_ObjectMother::createForm($user);
$registration_form->registerTags($tp);
$registration_form_template = 'registration_form.tpl';
if (isset($_REQUEST['reg_form_template'])) {
$registration_form_template = $_REQUEST['reg_form_template'];
} elseif (!empty($user_group_info['reg_form_template'])) {
$registration_form_template = $user_group_info['reg_form_template'];
}
$form_fields = $registration_form->getFormFieldsInfo();
// define default template with ajax checking
$registration_form->setDefaultTemplateByFieldName('email', 'email_ajaxchecking.tpl');
$registration_form->setDefaultTemplateByFieldName('username', 'unique_string.tpl');
// use specific template for user profile video
$registration_form->setDefaultTemplateByFieldName('video', 'video_profile.tpl');
$user_group_info = SJB_UserGroupManager::getUserGroupInfoBySID($user_group_sid);
$tp->assign('user_group_info', $user_group_info);
$tp->assign('errors', $errors);
$tp->assign('form_fields', $form_fields);
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
}
} else {
$registration_form_template = 'registration_choose_user_group.tpl';
$user_groups_info = SJB_UserGroupManager::getAllUserGroupsInfo();
$tp->assign('user_groups_info', $user_groups_info);
}
$tp->assign('userTree', true);
$tp->assign('errors', $errors);
$tp->display($registration_form_template);
}
public static function init()
{
SJB_DB::init(SJB_System::getSystemSettings('DBHOST'), SJB_System::getSystemSettings('DBUSER'), SJB_System::getSystemSettings('DBPASSWORD'), SJB_System::getSystemSettings('DBNAME'));
ini_set('zlib.output_compression', SJB_System::getSettingByName('gzip_compression'));
$GLOBALS['fatal_error_reserve_buffer'] = str_repeat('x', 1024 * 200);
ob_start(array('SJB_Error', 'fatalErrorHandler'));
SJB_Session::init(SJB_System::getSystemSettings('SITE_URL'));
$sessionId = SJB_DB::queryValue("SELECT `session_id` FROM `user_session_data_storage` WHERE `session_id` = ?s", SJB_Session::getSessionId());
// if not updated (row not exists) - insert that value
if (empty($sessionId)) {
SJB_DB::query("INSERT INTO `user_session_data_storage` SET `last_activity` = NOW(), `session_id` = ?s", SJB_Session::getSessionId());
} else {
SJB_DB::query("UPDATE `user_session_data_storage` SET `last_activity` = NOW() WHERE `session_id` = ?s", $sessionId);
}
//set timezone
if (SJB_Settings::getSettingByName('timezone')) {
ini_set('date.timezone', SJB_Settings::getSettingByName('timezone'));
}
// Set Error Handler and Shutdown function
set_error_handler(array('SJB_Error', 'errorHandler'));
register_shutdown_function(array('SJB_System', 'shutdownFunction'));
SJB_System::prepareGlobalArrays();
SJB_System::setGlobalTemplateVariable('is_ajax', SJB_Request::isAjax());
SJB_System::setGlobalTemplateVariable('site_url', SJB_System::getSystemSettings('SITE_URL'));
SJB_System::setGlobalTemplateVariable('user_site_url', SJB_System::getSystemSettings('USER_SITE_URL'));
SJB_System::setGlobalTemplateVariable('admin_site_url', SJB_System::getSystemSettings('ADMIN_SITE_URL'));
SJB_System::setGlobalTemplateVariable('radius_search_unit', SJB_System::getSettingByName('radius_search_unit'));
SJB_System::setGlobalTemplateVariable('settings', SJB_Settings::getSettings());
ThemeManager::getCurrentTheme();
SJB_PluginManager::loadPlugins(SJB_System::getSystemSettings('PLUGINS_DIR'));
SJB_System::setGlobalTemplateVariable('plugins', SJB_PluginManager::getAllPluginsList());
$GLOBALS['System']['MODULE_MANAGER'] = new SJB_ModuleManager();
SJB_Event::dispatch('moduleManagerCreated');
$GLOBALS['System']['MODULE_MANAGER']->executeModulesStartupFunctions();
// define if subadmin loged in and set subamdinmode for templates
if (SJB_System::getSystemSettings('SYSTEM_ACCESS_TYPE') == SJB_System::getSystemSettings('ADMIN_ACCESS_TYPE') && SJB_SubAdmin::getSubAdminSID()) {
SJB_System::setGlobalTemplateVariable('subAdminSID', SJB_SubAdmin::getSubAdminSID());
}
$GLOBALS['uri'] = SJB_Navigator::getURI();
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$parent_name = null;
$user_sid = SJB_Request::getVar('user_sid', false);
if (!is_null($user_sid)) {
$user_info = SJB_UserManager::getUserInfoBySID($user_sid);
$user_info = array_merge($user_info, $_REQUEST);
$form_submitted = SJB_Request::getVar('action_name');
$user = new SJB_User($user_info, $user_info['user_group_sid']);
if (!empty($user_info['parent_sid'])) {
$props = $user->getProperties();
$allowedProperties = array('username', 'email', 'password');
foreach ($props as $prop) {
if (!in_array($prop->getID(), $allowedProperties)) {
$user->deleteProperty($prop->getID());
}
}
$parent_name = SJB_UserManager::getUserNameByUserSID($user_info['parent_sid']);
}
$user->setSID($user_info['sid']);
$user->getProperty('email')->type->disableEmailConfirmation();
$user->deleteProperty("active");
$user->makePropertyNotRequired("password");
if (SJB_UserGroupManager::isUserEmailAsUsernameInUserGroup($user_info['user_group_sid'])) {
if ($form_submitted) {
$email = $user->getPropertyValue('email');
if (is_array($email)) {
$email = $email['original'];
}
$user->setPropertyValue('username', $email);
}
}
$user->addExtUserIDProperty($user_info['extUserID']);
$edit_user_form = new SJB_Form($user);
$errors = array();
if ($form_submitted && $edit_user_form->isDataValid($errors)) {
$password_value = $user->getPropertyValue('password');
$properties = null;
if (empty($password_value['original'])) {
$properties = $user->getProperties();
$user->deleteProperty('password');
}
SJB_UserManager::saveUser($user);
// >>> SJB-1197
// needs to check session for ajax-uploaded files, and set it to user profile
$tmpUploadsStorage = SJB_Session::getValue('tmp_uploads_storage');
$formToken = SJB_Request::getVar('form_token');
if (!empty($formToken)) {
$tmpUploadedFields = SJB_Array::getPath($tmpUploadsStorage, $formToken);
if (!is_null($tmpUploadsStorage) && is_array($tmpUploadedFields)) {
// prepare user profile fields array
$userProfileFieldsInfo = SJB_UserProfileFieldManager::getAllFieldsInfo();
$userProfileFields = array();
foreach ($userProfileFieldsInfo as $field) {
$userProfileFields[$field['id']] = $field;
}
// look for temporary values
foreach ($tmpUploadedFields as $fieldId => $fieldInfo) {
// check field ID for valid ID in user profile fields
if (!array_key_exists($fieldId, $userProfileFields) || empty($fieldInfo)) {
continue;
}
$fieldType = $userProfileFields[$fieldId]['type'];
$profilePropertyId = $fieldId . '_' . $user->getSID();
switch (strtolower($fieldType)) {
case 'video':
case 'file':
// change temporary file ID
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` = ?s", $profilePropertyId, $fieldInfo['file_id']);
// set value of user property to new uploaded file
$user->setPropertyValue($fieldId, $profilePropertyId);
break;
case 'logo':
// change temporary file ID and thumb ID
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` = ?s", $profilePropertyId, $fieldInfo['file_id']);
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` = ?s", $profilePropertyId . '_thumb', $fieldInfo['file_id'] . '_thumb');
// set value of user property to new uploaded file
$user->setPropertyValue($fieldId, $profilePropertyId);
break;
default:
break;
}
$tmpUploadsStorage = SJB_Array::unsetValueByPath($tmpUploadsStorage, "{$formToken}/{$fieldId}");
}
// and save user with new fields data
SJB_UserManager::saveUser($user);
SJB_Authorization::updateCurrentUserSession();
// clean temporary storage
$tmpUploadsStorage = SJB_Array::unsetValueByPath($tmpUploadsStorage, "{$formToken}");
// CLEAR TEMPORARY SESSION STORAGE
SJB_Session::setValue('tmp_uploads_storage', $tmpUploadsStorage);
}
}
// <<< SJB-1197
if (SJB_Request::isAjax()) {
echo "<p class=\"green\">User Saved</p>";
exit;
}
if ($form_submitted == 'save_info') {
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($user_info['user_group_sid']);
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/manage-users/" . mb_strtolower($userGroupInfo['id'], 'utf8'));
}
if (!empty($properties)) {
$user->details->properties = $properties;
}
}
if (SJB_UserGroupManager::isUserEmailAsUsernameInUserGroup($user_info['user_group_sid'])) {
$user->deleteProperty("username");
}
$listingTypes = SJB_ListingTypeManager::getAllListingTypesInfo();
$products = SJB_ProductsManager::getProductsInfoByUserGroupSID($user_info['user_group_sid']);
$allowedListingTypes = array();
foreach ($products as $product) {
if (!empty($product['listing_type_sid']) && empty($allowedListingTypes[$product['listing_type_sid']])) {
foreach ($listingTypes as $listingType) {
if ($product['listing_type_sid'] == $listingType['sid']) {
$allowedListingTypes[$product['listing_type_sid']] = $listingType;
}
}
}
}
$edit_user_form = SJB_ObjectMother::createForm($user);
$edit_user_form->registerTags($tp);
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($user_info['user_group_sid']);
if (SJB_UserManager::checkBan($errors, $user_info['ip'])) {
$user_info['ip_is_banned'] = 1;
}
$tp->assign("form_fields", $edit_user_form->getFormFieldsInfo());
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->assign("errors", $errors);
$tp->assign("listingTypes", $allowedListingTypes);
$tp->assign("user_info", $user_info);
$tp->assign("user_group_info", $userGroupInfo);
$tp->assign('userTree', true);
$tp->assign("parent_name", $parent_name);
$tp->assign("restore", preg_match('/manage-(jobseekers)|(employers)|([a-z0-9\\_]-users)/', SJB_Request::getVar('HTTP_REFERER', '', 'SERVER')));
SJB_System::setGlobalTemplateVariable('wikiExtraParam', $userGroupInfo['id']);
$tp->display("edit_user.tpl");
}
}
public function execute()
{
$errors = array();
if (SJB_Request::isAjax()) {
$response = null;
$user_type = SJB_Request::getVar('user_type');
$user_name = SJB_Request::getVar('parser_user');
$products = SJB_XmlImport::getProducts($user_type, $user_name, $errors);
$response = array('products' => empty($products) ? '' : SJB_XmlImport::translateProductsName($products), 'error' => empty($errors) ? '' : array_pop($errors));
die(json_encode($response));
}
$tp = SJB_System::getTemplateProcessor();
$add_level = SJB_Request::getVar('add_level', 1);
// check for errors
if ($add_level == '3') {
$selectUserType = SJB_Request::getVar('selectUserType');
$addNewUser = 0;
if ($selectUserType == 'username') {
$usr_name = isset($_REQUEST['parser_user']) ? SJB_DB::quote($_REQUEST['parser_user']) : '';
$usr_id = SJB_UserManager::getUserSIDbyUsername($usr_name);
if (empty($usr_name)) {
$errors[] = 'Please enter user name of existing user to the "User Name" field';
$usr_name = '';
} else {
$user_sid_exists = SJB_UserManager::getUserSIDbyUsername($usr_name);
if (empty($user_sid_exists)) {
$errors[] = 'User "' . $usr_name . '" not exists. Please enter user name of existing user to the "User Name" field';
$usr_name = '';
}
}
} elseif ($selectUserType == 'group') {
$userGroupSid = isset($_REQUEST['parser_user']) ? $_REQUEST['parser_user'] : 0;
$usr_id = $userGroupSid;
$usr_name = SJB_UserGroupManager::getUserGroupIDBySID($usr_id);
$addNewUser = 1;
}
if ($errors) {
$add_level = 2;
}
}
$listings_type = SJB_ListingTypeManager::getAllListingTypesInfo();
$types = array();
foreach ($listings_type as $one) {
$types[$one['sid']] = $one['id'];
}
$tp->assign('types', $types);
$selected_logo_options = null;
switch ($add_level) {
case '1':
$template = 'add_step_one.tpl';
/*
$types = array();
foreach ( $listings_type as $one ) {
$types[$one['sid']] = $one['id'];
}
$tp->assign('types', $types);
*/
$tp->display('add_step_one.tpl');
break;
case '2':
$template = 'add_step_two.tpl';
$original_xml = SJB_Request::getVar('xml');
$xml = $original_xml;
$tree = '';
$listing_fields = array();
$logo_options_array = array('not_logo' => 'Do Not Import Logo', 'import_logo' => 'Import Logo with Listings', 'upload_logo' => 'Upload Logo for Imported Listings');
$parsing_name = SJB_Request::getVar('parser_name');
$usr_name = SJB_Request::getVar('parser_user');
$pars_url = SJB_Request::getVar('parser_url');
$form_description = SJB_Request::getVar('form_description', '', 'POST');
$type_id = SJB_Request::getVar('type_id', '', 'POST');
$selectedLogoOption = SJB_Request::getVar('logo_options');
$selectedLogoField = SJB_Request::getVar('import_logo_field');
$selectedProduct = SJB_Request::getVar('postUnderProduct');
$id = SJB_Request::getVar('id', 0, 'GET');
$selected = array();
$a_selected = array();
if (!empty($_REQUEST['xml']) || $id > 0) {
// step 2 OR edit exist
if ($id > 0) {
// load exist parser
$parser_from_id = SJB_XmlImport::getSystemParsers($id);
if (isset($parser_from_id[0]['name'])) {
$parser_from_id = $parser_from_id[0];
}
$parsing_name = $parser_from_id['name'];
$usr_id = $parser_from_id['usr_id'];
$usr_name = $parser_from_id['usr_name'];
$form_description = $parser_from_id['description'];
$pars_url = $parser_from_id['url'];
$type_id = $parser_from_id['type_id'];
$selected_logo_options = unserialize($parser_from_id['logo_options']);
$selectedLogoOption = $selected_logo_options['option'];
$selectedLogoField = $selected_logo_options['field'];
$selectedProduct = $parser_from_id['product_sid'];
$xml = $parser_from_id['xml'];
$xml = SJB_XmlImport::cleanXmlFromImport($xml);
$map = unserialize($parser_from_id['maper']);
$selected = array_values($map);
$a_selected = array_keys($map);
} else {
$xml = SJB_XmlImport::cleanXmlFromImport($_REQUEST['xml']);
}
$sxml = new simplexml();
$tree = $sxml->xml_load_file($xml, 'array');
if (isset($tree['@content'])) {
$tree = $tree[0];
}
if (is_array($tree)) {
$tree = SJB_XmlImport::convertArray($tree);
foreach ($tree as $key => $val) {
unset($tree[$key]);
// replace '@' and ':'
$key = SJB_XmlImport::encodeSpecialEntities($key);
$tree[$key]['val'] = $val;
$tree[$key]['key'] = $key;
}
$field_types = array(0, $type_id);
$listing_fields = array();
$i = 0;
foreach ($field_types as $type) {
$listing_fields_info = SJB_ListingFieldManager::getListingFieldsInfoByListingType($type);
foreach ($listing_fields_info as $listing_field_info) {
if ($listing_field_info['type'] == 'location') {
foreach ($listing_field_info['fields'] as $fieldInfo) {
$listing_field = new SJB_ListingField($fieldInfo);
$listing_field->setSID($fieldInfo['sid']);
$listing_fields[$i]['id'] = $listing_field_info['id'] . '_' . $listing_field->details->properties['id']->value;
$listing_fields[$i]['caption'] = $listing_field->details->properties['id']->value;
$i++;
}
} else {
$listing_field = new SJB_ListingField($listing_field_info);
$listing_field->setSID($listing_field_info['sid']);
$listing_fields[$i]['id'] = $listing_field->details->properties['id']->value;
$listing_fields[$i]['caption'] = $listing_field->details->properties['id']->value;
$i++;
}
}
}
$listing_fields[$i]['id'] = $listing_fields[$i]['caption'] = "date";
$i++;
$listing_fields[$i]['id'] = $listing_fields[$i]['caption'] = "url";
$i++;
$listing_fields[$i]['id'] = $listing_fields[$i]['caption'] = "external_id";
} else {
$errors[] = 'XML syntaxis error.';
$template = 'add_step_one.tpl';
}
} else {
$errors[] = 'Please input correct xml';
$template = 'add_step_one.tpl';
}
$tp->assign('id', $id);
$tp->assign('selected', $selected);
$tp->assign('a_selected', $a_selected);
$tp->assign('xml', htmlspecialchars($xml));
$tp->assign('xmlToUser', $xml);
$tp->assign('user_groups', SJB_UserGroupManager::getAllUserGroupsInfo());
$tp->assign('form_name', $parsing_name);
$tp->assign('form_user', $usr_name);
$tp->assign('form_url', $pars_url);
$tp->assign('form_description', $form_description);
$type_name = SJB_ListingTypeManager::getListingTypeIDBySID($type_id);
$tp->assign('type_id', $type_id);
$tp->assign('type_name', $type_name);
$tp->assign('errors', $errors);
$tp->assign('tree', $tree);
$tp->assign("fields", $listing_fields);
$tp->assign('logo_options', $logo_options_array);
$tp->assign('selectedLogoOption', $selectedLogoOption);
$tp->assign('selectedLogoField', $selectedLogoField);
$tp->assign('selectedProduct', $selectedProduct);
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->display($template);
break;
case '3':
$parsing_name = isset($_REQUEST['parser_name']) ? SJB_DB::quote($_REQUEST['parser_name']) : '';
$pars_url = isset($_POST['parser_url']) ? SJB_DB::quote($_POST['parser_url']) : '';
$selectedLogoOption = isset($_POST['logo_options']) ? $_POST['logo_options'] : '';
$selectedLogoField = isset($_POST['import_logo_field']) ? $_POST['import_logo_field'] : '';
$form_description = isset($_REQUEST['form_description']) ? SJB_DB::quote($_REQUEST['form_description']) : "";
$type_id = isset($_POST['type_id']) ? intval($_POST['type_id']) : "";
$script = isset($_POST['custom_script']) && !empty($_POST['custom_script']) ? SJB_DB::quote($_POST['custom_script']) : "";
$script_users = SJB_DB::quote(SJB_Request::getVar('custom_script_users', '', SJB_Request::METHOD_POST));
$defaultValue = SJB_Request::getVar('default_value', false);
$defaultValueUser = SJB_Request::getVar('user_default_value', false);
$selectedProduct = SJB_Request::getVar('postUnderProduct');
$importType = SJB_Request::getVar('import_type', 'increment');
if ($defaultValue) {
foreach ($defaultValue as $key => $val) {
$defaultValue[$key] = htmlspecialchars($val, ENT_QUOTES, 'UTF-8');
}
}
if ($defaultValueUser) {
foreach ($defaultValueUser as $key => $val) {
$defaultValueUser[$key] = htmlspecialchars($val, ENT_QUOTES, 'UTF-8');
}
}
$original_xml = !empty($_POST['xml']) ? SJB_DB::quote($_POST['xml']) : '';
$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
$addQuery = '';
$username = SJB_XmlImport::decodeSpecialEntities(SJB_Request::getVar('username', ''));
$external_id = str_replace('_dog_', '@', SJB_Request::getVar('external_id', ''));
$site_url = SJB_System::getSystemSettings("SITE_URL");
if ($addNewUser == 1 && empty($_REQUEST['mapped_user'])) {
$error = 'Required user profile fields are not mapped';
SJB_HelperFunctions::redirect($site_url . '/edit-import/?id=' . $id . '&save_error=' . base64_encode($error));
}
if (!empty($_REQUEST['mapped']) && is_array($_REQUEST['mapped']) && !empty($original_xml) && empty($errors)) {
// make map
$map1 = array();
$map2 = array();
$serUserMap = '';
foreach ($_REQUEST['mapped'] as $one) {
$tmp = explode(':', $one);
$map1[] = $tmp[0];
$map2[] = $tmp[1];
}
if ($addNewUser == 1 && !empty($_REQUEST['mapped_user']) && is_array($_REQUEST['mapped_user'])) {
// make map
$mapUser1 = array();
$mapUser2 = array();
foreach ($_REQUEST['mapped_user'] as $one) {
$tmp = explode(':', $one);
$mapUser1[] = str_replace('user_', '', $tmp[0]);
$mapUser2[] = $tmp[1];
}
foreach ($mapUser1 as $key => $val) {
$val = SJB_XmlImport::decodeSpecialEntities($val);
$mapUser[$val] = $mapUser2[$key];
}
$serUserMap = serialize($mapUser);
}
//$map = array_combine($map1, $map2); // PHP5
foreach ($map1 as $key => $val) {
$val = SJB_XmlImport::decodeSpecialEntities($val);
$map[$val] = $map2[$key];
}
if ($selectedLogoOption && $selectedLogoOption != 'not_logo') {
//get real data without any cache
if (!SJB_ListingFieldDBManager::getListingFieldInfoByID('ListingLogo')) {
$listing_field_info = array('id' => 'ListingLogo', 'type' => 'logo', 'is_system' => false, 'is_required' => false, 'caption' => 'Listing Logo');
$listing_field = new SJB_ListingField($listing_field_info, $type_id);
$pages = SJB_PostingPagesManager::getFirstPageEachListingType();
SJB_ListingFieldManager::saveListingField($listing_field, $pages);
}
if ($key = array_search('ListingLogo', $map) !== false) {
unset($map[$key]);
}
}
if ($defaultValue) {
foreach ($defaultValue as $key => $val) {
if ($val == '') {
unset($defaultValue[$key]);
}
}
$defaultValue = SJB_db::quote(serialize($defaultValue));
$addQuery .= ", default_value = '" . $defaultValue . "'";
}
if ($defaultValueUser) {
foreach ($defaultValueUser as $keyuser => $valuser) {
if ($valuser == '') {
unset($defaultValueUser[$keyuser]);
}
}
$defaultValueUser = SJB_db::quote(serialize($defaultValueUser));
$addQuery .= ", default_value_user = '******'";
}
$queryParsUrl = SJB_DB::quote($pars_url);
$queryImportType = SJB_DB::quote($importType);
$queryId = intval($id);
$query = "SET\n\t\t\t\t\t\t\t`custom_script_users` = ?s,\n\t\t\t\t\t\t\t`custom_script` = ?s,\n\t\t\t\t\t\t\t`type_id` = ?n,\n\t\t\t\t\t\t\t`name` = ?s,\n\t\t\t\t\t\t\t`description` = ?s,\n\t\t\t\t\t\t\t`url` = ?s,\n\t\t\t\t\t\t\t`usr_id` = ?n,\n\t\t\t\t\t\t\t`usr_name` = ?s,\n\t\t\t\t\t\t\t`maper_user` = ?s,\n\t\t\t\t\t\t\t`xml` = ?s,\n\t\t\t\t\t\t\t`add_new_user` = ?n,\n\t\t\t\t\t\t\t`username` = ?s,\n\t\t\t\t\t\t\t`external_id` = ?s,\n\t\t\t\t\t\t\t`product_sid` = ?n,\n\t\t\t\t\t\t\t`import_type` = ?s\n\t\t\t\t\t\t\t{$addQuery}";
if ($id > 0) {
SJB_DB::query("UPDATE `parsers` {$query} WHERE id = ?n", $script_users, $script, $type_id, $parsing_name, $form_description, $queryParsUrl, $usr_id, $usr_name, $serUserMap, $original_xml, $addNewUser, $username, $external_id, $selectedProduct, $queryImportType, $queryId);
} else {
$id = SJB_DB::query("INSERT INTO `parsers` {$query}", $script_users, $script, $type_id, $parsing_name, $form_description, $queryParsUrl, $usr_id, $usr_name, $serUserMap, $original_xml, $addNewUser, $username, $external_id, $selectedProduct, $queryImportType);
}
$errorFile = '';
$xml_logo = null;
switch ($selectedLogoOption) {
case 'import_logo':
$map[$selectedLogoField] = 'ListingLogo';
break;
case 'upload_logo':
if (!empty($_FILES['upload_logo_file'])) {
if ($_FILES['upload_logo_file']['error']) {
$errorFile = SJB_UploadFileManager::getErrorId($_FILES['upload_logo_file']['error']);
} else {
$width = SJB_Settings::getSettingByName('listing_picture_width');
$height = SJB_Settings::getSettingByName('listing_picture_height');
$property_info['second_width'] = SJB_Settings::getSettingByName('listing_thumbnail_width');
$property_info['second_height'] = SJB_Settings::getSettingByName('listing_thumbnail_height');
$picture = new SJB_UploadPictureManager();
$picture->setWidth($width);
$picture->setHeight($height);
if ($picture->isValidUploadedPictureFile('upload_logo_file')) {
$xml_logo = "XMLImportLogo_{$id}";
$picture->setUploadedFileID($xml_logo);
$picture->uploadPicture('upload_logo_file', $property_info);
}
}
}
break;
}
$logo_options = serialize(array('option' => $selectedLogoOption, 'field' => $selectedLogoField));
$serMap = serialize($map);
if ($xml_logo) {
SJB_DB::query("UPDATE `parsers` SET maper = ?s, `xml_logo` = ?s, logo_options = ?s WHERE id = ?n", $serMap, $xml_logo, $logo_options, $id);
} else {
SJB_DB::query("UPDATE `parsers` SET maper = ?s, logo_options = ?s WHERE id = ?n", $serMap, $logo_options, $id);
}
$form_submitted = SJB_Request::getVar('form_action');
if ($form_submitted == 'save_info') {
SJB_HelperFunctions::redirect($site_url . '/show-import/');
} elseif ($form_submitted == 'apply_info') {
$getterParameters = '?id=' . $id;
if ($errorFile) {
$getterParameters .= '&error=' . $errorFile;
}
SJB_HelperFunctions::redirect($site_url . '/edit-import/' . $getterParameters);
}
} else {
if (empty($errors)) {
$errors[] = 'No data to save';
}
$tp->assign('errors', $errors);
$tp->assign('xml', htmlspecialchars($original_xml));
$tp->assign('xmlToUser', $original_xml);
$tp->assign('form_name', $parsing_name);
$tp->assign('form_user', $usr_name);
$tp->assign('form_url', $pars_url);
$tp->assign('form_description', $form_description);
$tp->display('add_step_three.tpl');
}
break;
}
}
public function execute()
{
$listing_id = SJB_Request::getVar('listing_id', null);
$listing_info = SJB_ListingManager::getListingInfoBySID($listing_id);
$listingTypeInfo = SJB_ListingTypeManager::getListingTypeInfoBySID($listing_info['listing_type_sid']);
if (!is_null($listing_info)) {
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$file = SJB_UploadFileManager::openFile($filename, $listing_id);
$errors['NO_SUCH_FILE'] = true;
}
if (isset($_REQUEST['Occupations']) && isset($_REQUEST['Occupations']['tree']) && !$_REQUEST['Occupations']['tree']) {
unset($_REQUEST['Occupations']['tree']);
}
$listing_info = array_merge($listing_info, $_REQUEST);
if (isset($_REQUEST['Occupations']) && isset($_REQUEST['Occupations']['tree']) && $_REQUEST['Occupations']['tree']) {
$listing_info['Occupations'] = $_REQUEST['Occupations']['tree'];
}
$listing = new SJB_Listing($listing_info, $listing_info['listing_type_sid']);
$listing->setSID($listing_id);
$listing_edit_form = new SJB_Form($listing);
$form_is_submitted = SJB_Request::getVar('action');
$errors = array();
if ($form_is_submitted) {
$listing->addProperty(array('id' => 'access_list', 'type' => 'multilist', 'value' => SJB_Request::getVar('list_emp_ids'), 'is_system' => true));
}
if ($form_is_submitted && $listing_edit_form->isDataValid($errors)) {
$listingSid = $listing->getID();
SJB_BrowseDBManager::deleteListings($listingSid);
SJB_ListingManager::saveListing($listing);
SJB_BrowseDBManager::addListings($listingSid);
$formToken = SJB_Request::getVar('form_token');
$sessionFilesStorage = SJB_Session::getValue('tmp_uploads_storage');
$uploadedFields = SJB_Array::getPath($sessionFilesStorage, $formToken);
if (!empty($uploadedFields)) {
foreach ($uploadedFields as $fieldId => $fieldValue) {
// get field of listing
$isComplex = false;
if (strpos($fieldId, ':') !== false) {
$isComplex = true;
}
$tmpUploadedFileId = $fieldValue['file_id'];
// rename it to real listing field value
$newFileId = $fieldId . "_" . $listing->getSID();
SJB_DB::query("UPDATE `uploaded_files` SET `id` = ?s WHERE `id` =?s", $newFileId, $tmpUploadedFileId);
if ($isComplex) {
list($parentField, $subField, $complexStep) = explode(':', $fieldId);
$parentProp = $listing->getProperty($parentField);
$parentValue = $parentProp->getValue();
// look for complex property with current $fieldID and set it to new value of property
if (!empty($parentValue)) {
foreach ($parentValue as $id => $value) {
if ($id == $subField) {
$parentValue[$id][$complexStep] = $newFileId;
}
}
$listing->setPropertyValue($parentField, $parentValue);
}
} else {
$listing->setPropertyValue($fieldId, $newFileId);
}
// unset value from session temporary storage
$sessionFilesStorage = SJB_Array::unsetValueByPath($sessionFilesStorage, "{$formToken}/{$fieldId}");
}
//and remove token key from temporary storage
$sessionFilesStorage = SJB_Array::unsetValueByPath($sessionFilesStorage, "{$formToken}");
SJB_Session::setValue('tmp_uploads_storage', $sessionFilesStorage);
SJB_ListingManager::saveListing($listing);
}
SJB_Event::dispatch('listingEdited', $listingSid);
if (SJB_Request::isAjax()) {
echo '<p class="green">Listing Saved</p>';
exit;
}
if ($form_is_submitted == 'save_info') {
$listingTypeId = SJB_ListingTypeManager::getListingTypeIDBySID($listing_info['listing_type_sid']);
$listingType = $listingTypeId != 'Job' && $listingTypeId != 'Resume' ? $listingTypeId . '-listings' : $listingTypeId . 's';
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . "/manage-" . strtolower($listingType) . "/?restore=1");
}
}
$listing->deleteProperty('access_list');
$comments = SJB_CommentManager::getEnabledCommentsToListing($listing_id);
$comments_total = count($comments);
$rate = SJB_Rating::getRatingNumToListing($listing_id);
$form_fields = $listing_edit_form->getFormFieldsInfo();
$pages = SJB_PostingPagesManager::getPagesByListingTypeSID($listing->getListingTypeSID());
$realFormFields = array();
foreach ($pages as $page) {
$listingFields = SJB_PostingPagesManager::getAllFieldsByPageSIDForForm($page['sid']);
foreach ($listingFields as $fieldID => $listingField) {
if (isset($form_fields[$fieldID])) {
$realFormFields[$fieldID] = $form_fields[$fieldID];
}
}
}
$adminFields = array();
foreach ($form_fields as $fieldName => $field) {
if (!isset($realFormFields[$fieldName])) {
$adminFields[$fieldName] = $field;
}
}
$realFormFields = array_merge($adminFields, $realFormFields);
$tp = SJB_System::getTemplateProcessor();
$listing_edit_form->registerTags($tp);
$extraInfo = $listing_info['product_info'];
if ($extraInfo) {
$extraInfo = unserialize($extraInfo);
$numberOfPictures = isset($extraInfo['number_of_pictures']) ? $extraInfo['number_of_pictures'] : 0;
$tp->assign("listing_duration", $extraInfo['listing_duration']);
$tp->assign("pic_limit", $numberOfPictures);
}
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing);
if (!isset($listing_structure['access_type'])) {
$listing_structure['access_type'] = 'everyone';
}
$listing_access_list = SJB_ListingManager::getListingAccessList($listing_id, $listing->getPropertyValue('access_type'));
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->assign('form_fields', $realFormFields);
$tp->assign('listing', $listing_structure);
$tp->assign('errors', $errors);
$tp->assign('listingType', SJB_ListingTypeManager::createTemplateStructure($listingTypeInfo));
$tp->assign('listing_access_list', $listing_access_list);
$tp->assign('comments_total', $comments_total);
$tp->assign('rate', $rate);
$tp->assign('expired', SJB_ListingManager::getIfListingHasExpiredBySID($listing->getSID()));
SJB_System::setGlobalTemplateVariable('wikiExtraParam', $listingTypeInfo['id']);
$tp->display('edit_listing.tpl');
}
}
