public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$location = new SJB_Location($_REQUEST);
if (SJB_Request::getVar('state', false)) {
$location->state_code = SJB_StatesManager::getStateCodeByStateName(SJB_Request::getVar('state', ''));
} else {
$location->state_code = '';
}
$formSubmitted = 'add' == SJB_Request::getVar('action', false);
$locationAdded = false;
if ($formSubmitted) {
if ($location->isDataValid($errors)) {
if (SJB_LocationManager::saveLocation($location)) {
$location = new SJB_Location();
$locationAdded = true;
} else {
$errors['Name'] = 'NOT_UNIQUE_VALUE';
}
}
}
$countries = SJB_CountriesManager::getAllCountriesCodesAndNames();
$locationInfo = $location->getInfo();
$tp->assign('locationAdded', $locationAdded);
$tp->assign('countries', $countries);
$tp->assign('errors', $errors);
$tp->assign('location_info', $locationInfo);
$tp->display('add_location.tpl');
}
public function execute()
{
$template_processor = SJB_System::getTemplateProcessor();
$location_sid = SJB_Request::getVar('sid', null);
$errors = null;
$field_errors = null;
$location_info = SJB_LocationManager::getLocationInfoBySID($location_sid);
if (!is_null($location_info)) {
$form_is_submitted = SJB_Request::getVar('action');
$location_info = array_merge($location_info, $_REQUEST);
$location = new SJB_Location($location_info);
$location->setSID($location_sid);
if (SJB_Request::getVar('state', false)) {
$location->state_code = SJB_StatesManager::getStateCodeByStateName(SJB_Request::getVar('state', ''));
} else {
$location->state_code = '';
}
if ($form_is_submitted && $location->isDataValid($field_errors)) {
if (SJB_LocationManager::saveLocation($location)) {
if ($form_is_submitted == 'save_info') {
$redirect_url = SJB_System::getSystemSettings('SITE_URL') . '/geographic-data/';
SJB_HelperFunctions::redirect($redirect_url);
}
} else {
$field_errors['Name'] = 'NOT_UNIQUE_VALUE';
}
}
} elseif (is_null($location_sid)) {
$errors['LOCATION_SID_IS_NOT_SPECIFIED'] = 1;
} else {
$errors['WORNG_LOCATION_SID_IS_SPECIFIED'] = 1;
}
$countries = SJB_CountriesManager::getAllCountriesCodesAndNames();
$template_processor->assign("location_info", $location_info);
$template_processor->assign("countries", $countries);
$template_processor->assign("errors", $errors);
$template_processor->assign("field_errors", $field_errors);
$template_processor->assign("location_sid", $location_sid);
$template_processor->display("edit_location.tpl");
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$form_submitted = SJB_Request::getVar('action');
$page = SJB_Request::getVar('page');
if ($form_submitted) {
if (SJB_System::getSystemSettings("isDemo")) {
$errors[] = "You don't have permissions for it. This is a Demo version of the software.";
} else {
if (!empty($_REQUEST['bad_words'])) {
$_REQUEST['bad_words'] = trim($_REQUEST['bad_words']);
}
SJB_Settings::updateSettings($_REQUEST);
}
if ($form_submitted == 'apply_settings') {
$tp->assign("page", $page);
}
}
$i18n = SJB_I18N::getInstance();
$tp->assign("settings", SJB_Settings::getSettings());
$ds = DIRECTORY_SEPARATOR;
$path = SJB_BASE_DIR . "system{$ds}cache{$ds}agents_bots.txt";
$disable_bots = file_get_contents($path);
$tp->assign("disable_bots", $disable_bots);
$tp->assign("timezones", timezone_identifiers_list());
if (!SJB_SubAdmin::getSubAdminSID()) {
$tp->assign("subadmins", SJB_SubAdminManager::getAllSubAdminsInfo());
}
$tp->assign("errors", $errors);
$tp->assign("i18n_domains", $i18n->getDomainsData());
$tp->assign("i18n_languages", $i18n->getActiveLanguagesData());
$tp->assign("countries", SJB_CountriesManager::getAllCountriesCodesAndNames());
$tp->assign('listingEmailTemplates', SJB_EmailTemplateEditor::getEmailTemplatesByGroup(SJB_NotificationGroups::GROUP_ID_LISTING));
$tp->assign('productEmailTemplates', SJB_EmailTemplateEditor::getEmailTemplatesByGroup(SJB_NotificationGroups::GROUP_ID_PRODUCT));
$tp->assign('userEmailTemplates', SJB_EmailTemplateEditor::getEmailTemplatesByGroup(SJB_NotificationGroups::GROUP_ID_USER));
$tp->assign('otherEmailTemplates', SJB_EmailTemplateEditor::getEmailTemplatesByGroup(SJB_NotificationGroups::GROUP_ID_OTHER));
$tp->display("settings.tpl");
}
public static function getUserProfileFieldInfoBySID($user_profile_field_sid)
{
$field_info = parent::getObjectInfo("user_profile_fields", $user_profile_field_sid);
if (in_array($field_info['type'], array('list', 'multilist'))) {
if (!empty($field_info['parent_sid'])) {
if ($field_info['id'] == 'Country') {
$displayAS = !empty($field_info['display_as']) ? $field_info['display_as'] : 'country_name';
$field_info['list_values'] = SJB_CountriesManager::getAllCountriesCodesAndNames(true, $displayAS);
}
} else {
$field_info['list_values'] = SJB_UserProfileFieldDBManager::getListValuesBySID($user_profile_field_sid);
}
} elseif ($field_info['type'] == 'tree') {
$field_info['tree_values'] = SJB_UserProfileFieldTreeManager::getTreeValuesBySID($user_profile_field_sid);
$field_info['tree_depth'] = SJB_UserProfileFieldTreeManager::getTreeDepthBySID($user_profile_field_sid);
} elseif ($field_info['type'] == 'monetary') {
$field_info['currency_values'] = SJB_CurrencyManager::getActiveCurrencyList();
} elseif ($field_info['type'] == 'location') {
$field_info['fields'] = SJB_UserProfileFieldManager::getUserProfileFieldsInfoByParentSID($user_profile_field_sid);
}
return $field_info;
}
public function execute()
{
ini_set('max_execution_time', 0);
$encodingFromCharset = SJB_Request::getVar('encodingFromCharset', 'UTF-8');
$preview = SJB_Request::getVar('preview', false);
$importedDataForPreview = array();
$template_processor = SJB_System::getTemplateProcessor();
$errors = null;
$start_line = SJB_Request::getVar('start_line', null);
$name_column = SJB_Request::getVar('name_column', null);
$longitude_column = SJB_Request::getVar('longitude_column', null);
$latitude_column = SJB_Request::getVar('latitude_column', null);
$city_column = SJB_Request::getVar('city_column', null);
$state_column = SJB_Request::getVar('state_column', null);
$state_code_column = SJB_Request::getVar('state_code_column', null);
$country_sid = SJB_Request::getVar('country_sid', null);
$file_format = SJB_Request::getVar('file_format', null);
$fields_delimiter = SJB_Request::getVar('fields_delimiter', null);
$imported_file_config['start_line'] = $start_line;
$imported_file_config['name_column'] = $name_column;
$imported_file_config['longitude_column'] = $longitude_column;
$imported_file_config['latitude_column'] = $latitude_column;
$imported_file_config['city_column'] = $city_column;
$imported_file_config['state_column'] = $state_column;
$imported_file_config['state_code_column'] = $state_code_column;
$imported_file_config['file_format'] = $file_format;
$imported_file_config['fields_delimiter'] = $fields_delimiter;
$imported_location_count = null;
if (isset($_FILES['imported_geo_file']) && !$_FILES['imported_geo_file']['error']) {
$fileInfo = $_FILES['imported_geo_file'];
$fileFormats = array('csv', 'xls', 'xlsx');
$pathInfo = pathinfo($fileInfo['name']);
$fileExtension = isset($pathInfo['extension']) ? strtolower($pathInfo['extension']) : '';
if (!in_array(strtolower($fileExtension), $fileFormats)) {
$errors['File'] = 'WRONG_FORMAT';
}
if (empty($_FILES['imported_geo_file']['name'])) {
$errors['File'] = 'EMPTY_VALUE';
}
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';
}
if (empty($name_column)) {
$errors['Name Column'] = 'EMPTY_VALUE';
} elseif (!is_numeric($name_column) || !is_int($name_column + 0)) {
$errors['Name Column'] = 'NOT_INT_VALUE';
}
if (empty($longitude_column)) {
$errors['Longitude Column'] = 'EMPTY_VALUE';
} elseif (!is_numeric($longitude_column) || !is_int($longitude_column + 0)) {
$errors['Longitude Column'] = 'NOT_INT_VALUE';
}
if (empty($latitude_column)) {
$errors['Latitude Column'] = 'EMPTY_VALUE';
} elseif (!is_numeric($latitude_column) || !is_int($latitude_column + 0)) {
$errors['Latitude Column'] = 'NOT_INT_VALUE';
}
if (empty($country_sid)) {
$errors['Country'] = 'EMPTY_VALUE';
}
if (!SJB_ImportFile::isValidFileExtensionByFormat($file_format, $_FILES['imported_geo_file'])) {
$errors['File'] = 'DO_NOT_MATCH_SELECTED_FILE_FORMAT';
}
if (!SJB_ImportFile::isValidFileCharset($_FILES['imported_geo_file'], $encodingFromCharset)) {
$errors['Charset'] = 'CHARSET_INCORRECT';
}
if (is_null($errors)) {
set_time_limit(0);
$file_info = SJB_Array::get($_FILES, 'imported_geo_file');
if (!strcasecmp($file_format, 'excel')) {
$import_file = new SJB_ImportFileXLS($file_info);
} else {
if ($fields_delimiter == 'semicolon') {
$fields_delimiter = ';';
} elseif ($fields_delimiter == 'tab') {
$fields_delimiter = "\t";
} else {
$fields_delimiter = ',';
}
$import_file = new SJB_ImportFileCSV($file_info, $fields_delimiter);
}
$import_file->parse($encodingFromCharset);
$imported_data = $import_file->getData();
$imported_location_count = 0;
$countryInfo = SJB_CountriesManager::getCountryInfoBySID($country_sid);
foreach ($imported_data as $key => $importedColumn) {
if (empty($importedColumn[$name_column - 1]) || empty($importedColumn[$longitude_column - 1]) || empty($importedColumn[$latitude_column - 1]) || $start_line > $key) {
continue;
}
$name = $importedColumn[$name_column - 1];
$longitude = $importedColumn[$longitude_column - 1];
$latitude = $importedColumn[$latitude_column - 1];
$city = isset($importedColumn[$city_column - 1]) ? $importedColumn[$city_column - 1] : null;
$state = isset($importedColumn[$state_column - 1]) ? $importedColumn[$state_column - 1] : null;
$state_code = isset($importedColumn[$state_code_column - 1]) ? $importedColumn[$state_code_column - 1] : null;
if ($preview) {
if (count($importedDataForPreview) >= 10) {
break;
}
$importedDataForPreview[] = array('name' => $name, 'longitude' => $longitude, 'latitude' => $latitude, 'city' => $city, 'state' => $state, 'stateCode' => $state_code, 'country' => $countryInfo['country_name']);
} else {
$imported_location_count += SJB_LocationManager::addLocation($name, $longitude, $latitude, $city, $state, $state_code, $country_sid, $countryInfo);
}
}
}
} elseif ($_SERVER['REQUEST_METHOD'] == 'POST') {
$errorSid = isset($_FILES['imported_geo_file']['error']) ? $_FILES['imported_geo_file']['error'] : 0;
$errors['File'] = SJB_UploadFileManager::getErrorId($errorSid);
}
$countries = SJB_CountriesManager::getAllCountriesCodesAndNames();
$template_processor->assign("charSets", SJB_HelperFunctions::getCharSets());
$template_processor->assign("importedGeographicData", $importedDataForPreview);
$template_processor->assign("countries", $countries);
$template_processor->assign("country_sid", $country_sid);
$template_processor->assign("errors", $errors);
$template_processor->assign("imported_location_count", $imported_location_count);
$template_processor->assign("imported_file_config", $imported_file_config);
$template_processor->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
if ($preview) {
$template_processor->display("import_geographic_data_preview.tpl");
} else {
$template_processor->display("import_geographic_data_form.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()
{
$tp = SJB_System::getTemplateProcessor();
$action = SJB_Request::getVar('action', 'list');
$fieldSID = SJB_Request::getVar('field_sid', false);
$parentSID = SJB_Request::getVar('sid', false);
$errors = null;
if ($fieldSID) {
$tp->assign('field_sid', $fieldSID);
$field_info = SJB_ListingFieldManager::getFieldInfoBySID($fieldSID);
$listing_type_info = SJB_ListingTypeManager::getListingTypeInfoBySID($field_info['listing_type_sid']);
$tp->assign("field_info", $field_info);
$tp->assign("type_info", $listing_type_info);
$tp->assign("type_sid", isset($listing_type_info['sid']) ? $listing_type_info['sid'] : false);
switch ($action) {
case 'edit':
$form_submitted = SJB_Request::getVar('submit_form', false);
$sid = SJB_Request::getVar('sid', 0);
$listingFieldInfo = SJB_ListingFieldDBManager::getListingFieldInfoBySID($sid);
$listingFieldInfo = array_merge($listingFieldInfo, $_REQUEST);
$listingField = new SJB_ListingField($listingFieldInfo);
$listingField->deleteProperty('type');
$listingField->addProperty(array('id' => 'hidden', 'caption' => 'Hidden', 'type' => 'boolean', 'value' => isset($listingFieldInfo['hidden']) ? $listingFieldInfo['hidden'] : '', 'is_system' => true));
$profileField = SJB_Request::getVar('profile_field', false);
if ($form_submitted) {
if ($profileField) {
$listingFieldInfo['default_value'] = '';
$listingFieldInfo['profile_field_as_dv'] = $listingFieldInfo['id'];
} else {
$listingFieldInfo['profile_field_as_dv'] = '';
}
}
if (!empty($listingFieldInfo['default_value_setting'])) {
if ($listingFieldInfo['default_value_setting'] == 'default_country') {
$listingFieldInfo['default_value'] = $listingFieldInfo['default_value_setting'];
$listingFieldInfo['profile_field_as_dv'] = '';
} elseif ($listingFieldInfo['default_value_setting'] == 'profile_field') {
$listingFieldInfo['default_value'] = '';
$listingFieldInfo['profile_field_as_dv'] = $listingFieldInfo['id'];
}
}
$additionalParameters = array();
if ($listingFieldInfo['id'] == 'Country') {
$additionalParameters = array('list_values' => SJB_CountriesManager::getAllCountriesCodesAndNames());
$display_as = array('id' => 'display_as', 'caption' => 'Display Country as', 'type' => 'list', 'value' => isset($listingFieldInfo['display_as']) ? $listingFieldInfo['display_as'] : '', 'list_values' => array(array('id' => 'country_name', 'caption' => 'Country Name'), array('id' => 'country_code', 'caption' => 'Country Code')), 'is_system' => true, 'is_required' => true);
} elseif ($listingFieldInfo['id'] == 'State') {
$defaultCountry = SJB_ListingFieldManager::getDefaultCountryByParentSID($fieldSID);
$additionalParameters['list_values'] = array();
if (is_numeric($defaultCountry)) {
$additionalParameters['list_values'] = SJB_StatesManager::getStatesNamesByCountry($defaultCountry);
} elseif (!empty($defaultCountry)) {
$listingFieldInfo['profile_field_as_dv'] = $listingFieldInfo['id'];
$tp->assign('disableField', 1);
} else {
$additionalParameters['comment'] = 'Please select default country first to select default State';
}
$display_as = array('id' => 'display_as', 'caption' => 'Display State as', 'type' => 'list', 'value' => isset($listingFieldInfo['display_as']) ? $listingFieldInfo['display_as'] : '', 'list_values' => array(array('id' => 'state_name', 'caption' => 'State Name'), array('id' => 'state_code', 'caption' => 'State Code')), 'is_system' => true, 'is_required' => true);
}
$default_value = array('id' => 'default_value', 'sid' => isset($listingFieldInfo['sid']) ? $listingFieldInfo['sid'] : '', 'caption' => 'Default Value', 'value' => isset($listingFieldInfo['default_value']) ? $listingFieldInfo['default_value'] : '', 'type' => $listingField->field_type, 'length' => '', 'is_required' => false, 'is_system' => true, 'add_parameter' => isset($listingFieldInfo['add_parameter']) ? $listingFieldInfo['add_parameter'] : '');
$default_value = array_merge($default_value, $additionalParameters);
$listingField->addProperty($default_value);
$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', 'length' => '', 'is_required' => false, 'is_system' => true);
$listingField->addProperty($profile_field_as_dv);
if (isset($display_as)) {
$listingField->addProperty($display_as);
}
if ($form_submitted) {
$listingField->addInfillInstructions(SJB_Request::getVar('instructions'));
} else {
$listingField->addInfillInstructions(isset($listingFieldInfo['instructions']) ? $listingFieldInfo['instructions'] : '');
}
$ListingFieldForm = new SJB_Form($listingField);
$ListingFieldForm->registerTags($tp);
$listingField->setSID($sid);
$addValidParam = array('field' => 'parent_sid', 'value' => $parentSID);
if ($form_submitted && $ListingFieldForm->isDataValid($errors, $addValidParam)) {
SJB_ListingFieldManager::saveListingField($listingField);
if ($listingFieldInfo['id'] == 'Country') {
$profileFieldAsDv = $listingField->getPropertyValue('profile_field_as_dv');
if ($profileFieldAsDv) {
$listingFieldsInfo = SJB_ListingFieldManager::getListingFieldsInfoByParentSID($fieldSID);
foreach ($listingFieldsInfo as $fieldInfo) {
if ($fieldInfo['id'] == 'State') {
$listingField = new SJB_ListingField($fieldInfo);
$listingField->setSID($fieldInfo['sid']);
$default_value = array('id' => 'default_value', 'sid' => isset($fieldInfo['sid']) ? $fieldInfo['sid'] : '', 'caption' => 'Default Value', 'value' => '', 'type' => $listingField->field_type, 'length' => '', 'is_required' => false, 'is_system' => true, 'add_parameter' => isset($fieldInfo['add_parameter']) ? $fieldInfo['add_parameter'] : '');
$listingField->addProperty($default_value);
$profile_field_as_dv = array('id' => 'profile_field_as_dv', 'caption' => 'Default Value', 'value' => 'State', 'type' => 'list', 'length' => '', 'is_required' => false, 'is_system' => true);
$listingField->addProperty($profile_field_as_dv);
SJB_ListingFieldManager::saveListingField($listingField);
}
}
}
}
if (SJB_Request::getVar('apply') == 'no' && empty($errors)) {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . "/edit-listing-field/edit-location-fields/?field_sid=" . $fieldSID);
}
}
$ListingFieldForm->makeDisabled('id');
$tp->assign('profileFieldAsDV', !empty($listingFieldInfo['profile_field_as_dv']));
$tp->assign('listingFieldInfo', $listingFieldInfo);
$tp->assign("field_type", $listingField->getFieldType());
$tp->assign("sid", $sid);
$tp->assign("form_fields", $ListingFieldForm->getFormFieldsInfo());
$tp->assign("errors", $errors);
$tp->display("edit_location_field.tpl");
break;
case 'move_up':
SJB_ListingFieldManager::moveUpFieldBySID($fieldSID);
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/edit-listing-field/edit-location-fields/?field_sid=" . $parentSID);
break;
case 'move_down':
SJB_ListingFieldManager::moveDownFieldBySID($fieldSID);
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/edit-listing-field/edit-location-fields/?field_sid=" . $parentSID);
break;
}
if ($action == 'list') {
$listingFieldsInfo = SJB_ListingFieldManager::getListingFieldsInfoByParentSID($fieldSID);
$listingFields = array();
$listingFieldSids = array();
foreach ($listingFieldsInfo as $listingFieldInfo) {
$listingField = new SJB_ListingField($listingFieldInfo);
$listingField->addProperty(array('id' => 'hidden', 'caption' => 'Hidden', 'type' => 'boolean', 'value' => isset($listingFieldInfo['hidden']) ? $listingFieldInfo['hidden'] : '', 'is_system' => true));
$listingField->setSID($listingFieldInfo['sid']);
$listingFields[] = $listingField;
$listingFieldSids[] = $listingFieldInfo['sid'];
}
$form_collection = new SJB_FormCollection($listingFields);
$form_collection->registerTags($tp);
$tp->assign("listing_field_sids", $listingFieldSids);
$tp->display("listing_location_fields.tpl");
}
}
}
public static function getDetails()
{
return array(array('id' => 'tax_name', 'caption' => 'Tax Name', 'type' => 'unique_string', 'length' => '20', 'table_name' => 'taxes', 'is_required' => true, 'is_system' => true, 'validators' => array('SJB_StringWithoutTagsValidator')), array('id' => 'Country', 'caption' => 'Country', 'type' => 'list', 'list_values' => SJB_CountriesManager::getAllCountriesCodesAndNames(), 'table_name' => 'taxes', 'is_required' => false, 'is_system' => true), array('id' => 'State', 'caption' => 'State', 'type' => 'list', 'table_name' => 'taxes', 'list_values' => array(), 'is_required' => false, 'is_system' => true), array('id' => 'tax_rate', 'caption' => 'Tax Rate', 'type' => 'float', 'table_name' => 'taxes', 'length' => '10', 'is_required' => true, 'is_system' => true, 'minimum' => '0', 'maximum' => '100'), array('id' => 'active', 'caption' => 'Active', 'type' => 'boolean', 'table_name' => 'taxes', 'is_required' => false, 'is_system' => true), array('id' => 'price_includes_tax', 'caption' => 'Price Includes Tax', 'type' => 'boolean', 'table_name' => 'taxes', 'is_required' => false, 'is_system' => true));
}
public static function setComplexFields(&$listing_field_info)
{
switch ($listing_field_info['type']) {
case 'list':
case 'multilist':
if (!empty($listing_field_info['parent_sid'])) {
if ($listing_field_info['id'] == 'Country') {
$displayAS = !empty($listing_field_info['display_as']) ? $listing_field_info['display_as'] : 'country_name';
$listing_field_info['list_values'] = SJB_CountriesManager::getAllCountriesCodesAndNames(true, $displayAS);
}
} else {
$listing_field_info['list_values'] = SJB_ListingFieldDBManager::getListValuesBySID($listing_field_info['sid']);
}
break;
case 'tree':
$listing_field_info['tree_values'] = SJB_ListingFieldDBManager::getTreeValuesBySID($listing_field_info['sid']);
$listing_field_info['tree_depth'] = SJB_ListingFieldDBManager::getTreeDepthBySID($listing_field_info['sid']);
break;
case 'monetary':
$listing_field_info['currency_values'] = SJB_CurrencyManager::getActiveCurrencyList();
break;
case 'complex':
$listing_field_info['fields'] = SJB_ListingFieldDBManager::getListingFieldsInfoByParentSID($listing_field_info['sid']);
$listing_field_info['table_name'] = 'listings';
break;
case 'location':
$listing_field_info['fields'] = SJB_ListingFieldManager::getListingFieldsInfoByParentSID($listing_field_info['sid']);
break;
case 'geo':
if (isset($listing_field_info['parent_sid'])) {
$parentID = SJB_DB::queryValue("SELECT `id` FROM `listing_fields` WHERE `sid` = ?n", $listing_field_info['parent_sid']);
$listing_field_info['parentID'] = $parentID;
}
break;
}
$listing_field_info['is_classifieds'] = 1;
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$location = new SJB_Location($_REQUEST);
$action_name = SJB_Request::getVar('action_name', false);
$action = SJB_Request::getVar('action', false);
$action = $action_name ? $action_name : $action;
$paginator = new SJB_GeographicDataPagination();
$search = '';
$params = array();
$locationAdded = false;
switch ($action) {
case 'add':
if ($location->isDataValid($errors)) {
if (SJB_LocationManager::saveLocation($location)) {
$location = new SJB_Location();
$locationAdded = true;
} else {
$errors['Name'] = 'NOT_UNIQUE_VALUE';
}
}
break;
case 'delete':
$location_sid = SJB_Request::getVar('location_sid', false);
if (!$location_sid) {
$locations_sids = SJB_Request::getVar('locations', false);
if ($locations_sids) {
foreach ($locations_sids as $l_sid => $value) {
SJB_LocationManager::deleteLocationBySID($l_sid);
}
}
} else {
SJB_LocationManager::deleteLocationBySID($location_sid);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . '/geographic-data/');
break;
case 'clear_data':
SJB_LocationManager::deleteAllLocations();
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . '/geographic-data/');
break;
case 'search':
$searchParams = SJB_Request::getVar('search', false);
$search .= 'WHERE 1 ';
if (!empty($searchParams['name'])) {
$search .= "AND l.`name` LIKE ?s";
$params[] = "%{$searchParams['name']}%";
}
if (!empty($searchParams['longitude'])) {
$search .= " AND l.`longitude` LIKE ?s";
$params[] = "%{$searchParams['longitude']}%";
}
if (!empty($searchParams['latitude'])) {
$search .= " AND l.`latitude` LIKE ?s";
$params[] = "%{$searchParams['latitude']}%";
}
if (!empty($searchParams['city'])) {
$search .= " AND l.`city` LIKE ?s";
$params[] = "%{$searchParams['city']}%";
}
if (!empty($searchParams['state'])) {
$search .= " AND l.`state` LIKE ?s";
$params[] = "%{$searchParams['state']}%";
}
if (!empty($searchParams['state_code'])) {
$search .= " AND l.`state_code` LIKE ?s";
$params[] = "%{$searchParams['state_code']}%";
}
if (!empty($searchParams['country_sid'])) {
$search .= " AND l.`country_sid` = ?n";
$params[] = "{$searchParams['country_sid']}";
}
$tp->assign('search', $searchParams);
$searchQuery['action'] = 'search';
$searchQuery['search'] = $searchParams;
$paginator->setUniqueUrlParam(trim(http_build_query($searchQuery)));
break;
}
$countries = SJB_CountriesManager::getAllCountriesCodesAndNames();
$location_info = $location->getInfo();
$paginator->setItemsCount(SJB_LocationManager::getLocationNumber($search, $params));
$location_collection = SJB_LocationManager::getLocationsInfoWithLimit(($paginator->currentPage - 1) * $paginator->itemsPerPage, $paginator->itemsPerPage, $search, $paginator->sortingField, $paginator->sortingOrder, $params);
unset($_REQUEST['zip_codes_per_page']);
$tp->assign('paginationInfo', $paginator->getPaginationInfo());
$tp->assign('locationAdded', $locationAdded);
$tp->assign('countries', $countries);
$tp->assign('query', http_build_query($_REQUEST));
$tp->assign('errors', $errors);
$tp->assign('location_info', $location_info);
$tp->assign('location_collection', $location_collection);
$tp->display('geographic_data.tpl');
}
