public static function createUser($userGroupSID)
{
$userGroupSID = SJB_UserGroupManager::getUserGroupSIDByID($userGroupSID);
$user = new SJB_User(array(), $userGroupSID);
$user->addUserGroupProperty();
$user->addRegistrationDateProperty();
$user->addProductProperty(null, $userGroupSID);
return $user;
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$productType = SJB_Request::getVar('product_type', false);
$action = SJB_Request::getVar('action', false);
$errors = array();
$productErrors = array();
if ($productType) {
if ($productType == 'featured_user') {
$_REQUEST['user_group_sid'] = SJB_UserGroupManager::getUserGroupSIDByID('Employer');
}
$product = new SJB_Product($_REQUEST, $productType);
$pages = $product->getProductPages();
$addProductForm = new SJB_Form($product);
$addProductForm->registerTags($tp);
$form_submitted = SJB_Request::getVar('action', '') == 'save';
if ($form_submitted) {
$productErrors = $product->isValid($product);
if (in_array($productType, array('access_listings', 'featured_user', 'banners', 'custom_product'))) {
$periodName = $product->getPropertyValue('period_name');
if ($periodName == 'unlimited') {
$product->makePropertyNotRequired('period');
}
}
}
if ($form_submitted && $addProductForm->isDataValid($errors) && !$productErrors) {
$product->addProperty(array('id' => 'product_type', 'type' => 'string', 'value' => $productType, 'is_system' => true));
$product->saveProduct($product, $_REQUEST);
$product->savePermissions($_REQUEST);
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . '/products/');
}
$errors = array_merge($errors, $productErrors);
$formFieldsInfo = $addProductForm->getFormFieldsInfo();
$formFields = array();
foreach ($pages as $pageID => $page) {
foreach ($formFieldsInfo as $formFieldInfo) {
if (in_array($formFieldInfo['id'], $page['fields'])) {
$formFields[$pageID][] = $formFieldInfo;
}
}
if (!isset($formFields[$pageID])) {
$formFields[$pageID] = array();
}
}
$tp->assign('form_fields', $formFields);
$tp->assign('product_type', $productType);
$tp->assign('request', $_REQUEST);
$tp->assign('params', http_build_query($_REQUEST));
$tp->assign('pages', $pages);
$tp->assign('pageTab', SJB_Request::getVar('page', false));
$tp->assign("errors", $errors);
$tp->display('add_product.tpl');
} else {
$tp->display('select_product_type.tpl');
}
}
public function execute()
{
$access_type = SJB_Request::getVar('access_type');
$listing_id = SJB_Request::getVar('listing_id');
$user_group_id = SJB_Request::getVar('user_group_id');
$employersGroupSID = SJB_UserGroupManager::getUserGroupSIDByID($user_group_id);
$employersSIDs = SJB_UserManager::getUserSIDsByUserGroupSID($employersGroupSID);
$employers = array();
foreach ($employersSIDs as $emp) {
$currEmp = SJB_UserManager::getUserInfoBySID($emp);
if (isset($currEmp['CompanyName']) && $currEmp['CompanyName'] != '') {
$employers[] = array('name' => $currEmp['CompanyName'], 'sid' => $emp);
}
}
sort($employers);
$tp = SJB_System::getTemplateProcessor();
$listing_access_list = SJB_ListingManager::getListingAccessList($listing_id, $access_type);
$tp->assign('listing_access_list', $listing_access_list);
$tp->assign('employers', $employers);
$tp->display('employers_list.tpl');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$tp->assign('terms_of_use_check', SJB_System::getSettingByName('terms_of_use_check'));
$user_group_id = SJB_Request::getVar('user_group_id', null);
$form_submitted = isset($_REQUEST['action']) && $_REQUEST['action'] == 'register';
if (!is_null($user_group_id)) {
$user_group_sid = SJB_UserGroupManager::getUserGroupSIDByID($user_group_id);
/**
* check if registration is allowed for this UserGroup
*/
if (!SJB_SocialPlugin::ifRegistrationIsAllowedByUserGroupSID($user_group_sid)) {
return null;
}
$user_group_info = SJB_UserGroupManager::getUserGroupInfoBySID($user_group_sid);
$user = SJB_ObjectMother::createUser($_REQUEST, $user_group_sid);
$user->deleteProperty('active');
$user->deleteProperty('featured');
$errors = array();
// social plugin
if ($form_submitted) {
SJB_Event::dispatch('SocialPlugin_AddListingFieldsIntoRegistration', $user, true);
SJB_Event::dispatch('MakeRegistrationFieldsNotRequired_SocialPlugin', $user, true);
} else {
SJB_Event::dispatch('PrepareRegistrationFields_SocialPlugin', $user, true);
SJB_Event::dispatch('SocialPlugin_AddListingFieldsIntoRegistration', $user, true);
SJB_Event::dispatch('FillRegistrationData_Plugin', $user, true);
}
$registration_form = SJB_ObjectMother::createForm($user);
$registration_form->registerTags($tp);
if ($form_submitted && $registration_form->isDataValid($errors)) {
SJB_Event::dispatch('FillRegistrationData_Plugin', $user, true);
SJB_Event::dispatch('AddReferencePluginDetails', $user, true);
$user->deleteProperty('captcha');
$user->deleteProperty('active');
$user->deleteProperty('featured');
SJB_UserManager::saveUser($user);
SJB_Statistics::addStatistics('addUser', $user->getUserGroupSID(), $user->getSID(), false, 0, 0, false, 0, SJB_SocialPlugin::getNetwork());
SJB_Statistics::addStatistics('addUser' . SJB_SocialPlugin::getNetwork(), $user->getUserGroupSID(), $user->getSID(), false, 0, 0, false, 0, SJB_SocialPlugin::getNetwork());
// subscribe user on default product
$defaultProduct = SJB_UserGroupManager::getDefaultProduct($user_group_sid);
$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_SocialPlugin::sendUserSocialRegistrationLetter($user);
// notify 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) {
$isSent = SJB_Notifications::sendUserActivationLetter($user->getSID());
if ($isSent) {
$tp->display('../users/registration_confirm.tpl');
} else {
$tp->display('../users/registration_failed_to_send_activation_email.tpl');
}
} else {
if (!$isSendActivationEmail && $isApproveByAdmin) {
SJB_UserManager::setApprovalStatusByUserName($user->getUserName(), 'Pending');
$tp->display('../users/registration_pending.tpl');
} else {
SJB_UserManager::activateUserByUserName($user->getUserName());
$errors = array();
SJB_Authorization::login($user->getUserName(), $user->getPropertyValue('password'), false, $errors, false);
// save access token, profile info for synchronization
SJB_SocialPlugin::postRegistration();
$tp->assign('socialNetwork', SJB_SocialPlugin::getNetwork());
$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 {
// social plugin
SJB_Event::dispatch('PrepareRegistrationFields_SocialPlugin', $user, true);
if (SJB_UserGroupManager::isUserEmailAsUsernameInUserGroup($user_group_sid)) {
$user->deleteProperty('username');
}
$registration_form = SJB_ObjectMother::createForm($user);
if ($form_submitted) {
$registration_form->isDataValid($errors);
}
$registration_form->registerTags($tp);
$registration_form_template = '../users/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();
$user_group_info = SJB_UserGroupManager::getUserGroupInfoBySID($user_group_sid);
$tp->assign('user_group_info', $user_group_info);
$tp->assign('errors', $errors);
$tp->assign('user_group_id', $user_group_id);
$tp->assign('form_fields', $form_fields);
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$tp->assign('socialRegistration', true);
$tp->assign('userTree', true);
$tp->display($registration_form_template);
}
} else {
$userGroupsSIDs = SJB_SocialPlugin::getResolvedUserGroupsByNetwork();
$user_groups_info = array();
foreach ($userGroupsSIDs as $groupSID) {
array_push($user_groups_info, SJB_UserGroupManager::getUserGroupInfoBySID($groupSID));
}
/*
* if there is only one group available for registration
* redirect user directly on Registration Fields page
*/
if (count($user_groups_info) === 1 && !empty($user_groups_info[0]['id'])) {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/registration-social/?user_group_id=' . $user_groups_info[0]['id']);
}
$tp->assign('user_groups_info', $user_groups_info);
$tp->display('registration_choose_user_group_social.tpl');
}
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$action = SJB_Request::getVar('action', false);
$updateUsers = SJB_Request::getVar('update_users', 0);
$sid = SJB_Request::getVar('sid', 0);
$errors = array();
$productErrors = array();
$productInfo = SJB_ProductsManager::getProductInfoBySID($sid);
if ($productInfo) {
if ($productInfo['product_type'] == 'featured_user') {
$_REQUEST['user_group_sid'] = SJB_UserGroupManager::getUserGroupSIDByID('Employer');
}
$productInfo = array_merge($productInfo, $_REQUEST);
$product = new SJB_Product($productInfo, $productInfo['product_type']);
$product->setSID($sid);
$pages = $product->getProductPages();
$editProductForm = new SJB_Form($product);
$editProductForm->registerTags($tp);
$form_submitted = $action == 'save' || $action == 'apply_product';
$activeError = array();
if ($form_submitted && ($productInfo['active'] = 1)) {
if (!empty($productInfo['availability_to']) && SJB_I18N::getInstance()->getInput('date', $productInfo['availability_to']) <= date('Y-m-d')) {
$activeError['INVALID_ACTIVATION'] = 'The product cannot be activated. Please change the availability date.';
}
}
if ($form_submitted) {
$productErrors = $product->isValid($product);
$activeError = array_merge($activeError, $productErrors);
if (in_array($productInfo['product_type'], array('access_listings', 'featured_user', 'banners', 'custom_product'))) {
$periodName = $product->getPropertyValue('period_name');
if ($periodName == 'unlimited') {
$product->makePropertyNotRequired('period');
}
}
}
if ($form_submitted && $editProductForm->isDataValid($errors) && !$activeError) {
$product->saveProduct($product);
$product->savePermissions($_REQUEST);
if ($updateUsers) {
$contracts = SJB_ContractManager::getAllContractsByProductSID($product->getSID());
if ($contracts) {
$contractsSIDs = array();
foreach ($contracts as $contract) {
$contractsSIDs[] = $contract['id'];
}
$contractsSIDs = implode(',', $contractsSIDs);
SJB_ContractSQL::updateAllContractsExtraInfoByProductSID($contractsSIDs, $product->getSID());
}
}
if ($action == 'save') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/products/');
}
} else {
$product->setFloatNumbersIntoValidFormat();
}
$errors = array_merge($errors, $activeError);
$formFieldsInfo = $editProductForm->getFormFieldsInfo();
$formFields = array();
foreach ($pages as $pageID => $page) {
foreach ($formFieldsInfo as $formFieldInfo) {
if (in_array($formFieldInfo['id'], $page['fields'])) {
$formFields[$pageID][] = $formFieldInfo;
}
}
if (!isset($formFields[$pageID])) {
$formFields[$pageID] = array();
}
}
$tp->assign('form_fields', $formFields);
$tp->assign('product_info', $productInfo);
$tp->assign('product_type', $productInfo['product_type']);
$tp->assign('params', http_build_query($_REQUEST));
$tp->assign('pageTab', SJB_Request::getVar('page', false));
$tp->assign('pages', $pages);
$tp->assign("errors", $errors);
$tp->display('edit_product.tpl');
}
}
public function createUser()
{
$user_group_id = SJB_Request::getVar('user_group_id');
if (!is_null($user_group_id)) {
$user_group_sid = SJB_UserGroupManager::getUserGroupSIDByID($user_group_id);
$user = SJB_ObjectMother::createUser($_REQUEST, $user_group_sid);
$user->deleteProperty('active');
$user->deleteProperty('featured');
$this->fillRegistrationDataWithUser($user);
self::addReferenceDetails($user);
$user->deleteProperty('captcha');
SJB_UserManager::saveUser($user);
// subscribe user on default product
$defaultProduct = SJB_UserGroupManager::getDefaultProduct($user_group_sid);
$available_products_ids = SJB_ProductsManager::getProductsByUserGroupSID($user_group_sid, $user->getSID());
if ($defaultProduct && in_array($defaultProduct, $available_products_ids)) {
$contract = new SJB_Contract(array('product_sid' => $defaultProduct));
$contract->setUserSID($user->getSID());
$contract->saveInDB();
}
$this->sendUserSocialRegistrationLetter($user);
// notifying administrator
SJB_AdminNotifications::sendAdminUserRegistrationLetter($user);
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/my-account/');
}
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$template = SJB_Request::getVar('template', 'users.tpl');
$searchTemplate = SJB_Request::getVar('search_template', 'user_search_form.tpl');
$passedParametersViaUri = SJB_UrlParamProvider::getParams();
$userGroupID = $passedParametersViaUri ? array_shift($passedParametersViaUri) : false;
$userGroupSID = $userGroupID ? SJB_UserGroupManager::getUserGroupSIDByID($userGroupID) : null;
$errors = array();
/********** A C T I O N S W I T H U S E R S **********/
$action = SJB_Request::getVar('action_name');
if (!empty($action)) {
$users_sids = SJB_Request::getVar('users', array());
$_REQUEST['restore'] = 1;
switch ($action) {
case 'approve':
foreach ($users_sids as $user_sid => $value) {
$username = SJB_UserManager::getUserNameByUserSID($user_sid);
SJB_UserManager::setApprovalStatusByUserName($username, 'Approved');
SJB_UserManager::activateUserByUserName($username);
SJB_UserDBManager::deleteActivationKeyByUsername($username);
if (!SJB_SocialPlugin::getProfileSocialID($user_sid)) {
SJB_Notifications::sendUserWelcomeLetter($user_sid);
} else {
SJB_Notifications::sendUserApprovedLetter($user_sid);
}
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
break;
case 'reject':
$rejection_reason = SJB_Request::getVar('rejection_reason', '');
foreach ($users_sids as $user_sid => $value) {
$username = SJB_UserManager::getUserNameByUserSID($user_sid);
SJB_UserManager::setApprovalStatusByUserName($username, 'Rejected', $rejection_reason);
SJB_UserManager::deactivateUserByUserName($username);
SJB_Notifications::sendUserRejectedLetter($user_sid);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
break;
case 'activate':
foreach ($users_sids as $user_sid => $value) {
$username = SJB_UserManager::getUserNameByUserSID($user_sid);
$userinfo = SJB_UserManager::getUserInfoByUserName($username);
SJB_UserManager::activateUserByUserName($username);
if ($userinfo['approval'] == 'Approved') {
SJB_UserDBManager::deleteActivationKeyByUsername($username);
SJB_Notifications::sendUserApprovedLetter($user_sid);
}
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
break;
case 'deactivate':
foreach ($users_sids as $user_sid => $value) {
$username = SJB_UserManager::getUserNameByUserSID($user_sid);
SJB_UserManager::deactivateUserByUserName($username);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
break;
case 'delete':
foreach (array_keys($users_sids) as $user_sid) {
try {
SJB_UserManager::deleteUserById($user_sid);
} catch (Exception $e) {
$errors[] = $e->getMessage();
}
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
break;
case 'send_activation_letter':
foreach ($users_sids as $user_sid => $value) {
SJB_Notifications::sendUserActivationLetter($user_sid);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
break;
case 'change_product':
$productToChange = SJB_Request::getVar('product_to_change');
if (empty($productToChange)) {
$productToChange = 0;
}
foreach ($users_sids as $user_sid => $value) {
$user = SJB_UserManager::getObjectBySID($user_sid);
// UNSUBSCRIBE selected
if ($productToChange == 0) {
SJB_ContractManager::deleteAllContractsByUserSID($user_sid);
} else {
$productInfo = SJB_ProductsManager::getProductInfoBySID($productToChange);
$listingNumber = SJB_Request::getVar('number_of_listings', null);
if (is_null($listingNumber) && !empty($productInfo['number_of_listings'])) {
$listingNumber = $productInfo['number_of_listings'];
}
$contract = new SJB_Contract(array('product_sid' => $productToChange, 'numberOfListings' => $listingNumber, 'is_recurring' => 0));
$contract->setUserSID($user_sid);
$contract->saveInDB();
if ($contract->isFeaturedProfile()) {
SJB_UserManager::makeFeaturedBySID($user_sid);
}
}
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
break;
case 'ban_ip':
$cantBanUsers = array();
foreach ($users_sids as $user_sid => $value) {
$user = SJB_UserManager::getUserInfoBySID($user_sid);
if ($user['ip'] && !SJB_IPManager::getBannedIPByValue($user['ip'])) {
SJB_IPManager::makeIPBanned($user['ip']);
} else {
$cantBanUsers[] = $user['username'];
}
}
if ($cantBanUsers) {
$tp->assign('cantBanUsers', $cantBanUsers);
} else {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
}
break;
case 'unban_ip':
$cantUnbanIPs = array();
foreach ($users_sids as $user_sid => $value) {
$user = SJB_UserManager::getUserInfoBySID($user_sid);
if ($user['ip'] !== '') {
if (SJB_IPManager::getBannedIPByValue($user['ip'])) {
SJB_IPManager::makeIPEnabledByValue($user['ip']);
} elseif (SJB_UserManager::checkBan($errors, $user['ip'])) {
$cantUnbanIPs[] = $user['ip'];
}
}
}
if ($cantUnbanIPs) {
$tp->assign('rangeIPs', $cantUnbanIPs);
} else {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
}
break;
default:
unset($_REQUEST['restore']);
break;
}
if (empty($errors)) {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . SJB_Navigator::getURI());
}
}
/***************************************************************/
$_REQUEST['action'] = 'search';
$user = new SJB_User(array(), $userGroupSID);
$user->addProperty(array('id' => 'user_group', 'type' => 'list', 'value' => '', 'is_system' => true, 'list_values' => SJB_UserGroupManager::getAllUserGroupsIDsAndCaptions()));
$user->addProperty(array('id' => 'registration_date', 'type' => 'date', 'value' => '', 'is_system' => true));
$user->addProperty(array('id' => 'approval', 'caption' => 'Approval', 'type' => 'list', 'list_values' => array(array('id' => 'Pending', 'caption' => 'Pending'), array('id' => 'Approved', 'caption' => 'Approved'), array('id' => 'Rejected', 'caption' => 'Rejected')), 'length' => '10', 'is_required' => false, 'is_system' => true));
// get array of accessible products
$productsSIDs = SJB_ProductsManager::getProductsIDsByUserGroupSID($userGroupSID);
$products = array();
foreach ($productsSIDs as $key => $productSID) {
$product = SJB_ProductsManager::getProductInfoBySID($productSID);
$products[$key] = $product;
if (!empty($product['pricing_type']) && $product['pricing_type'] == 'volume_based' && !empty($product['volume_based_pricing'])) {
$volumeBasedPricing = $product['volume_based_pricing'];
$minListings = min($volumeBasedPricing['listings_range_from']);
$maxListings = max($volumeBasedPricing['listings_range_to']);
$countListings = array();
for ($i = $minListings; $i <= $maxListings; $i++) {
$countListings[] = $i;
}
$products[$key]['count_listings'] = $countListings;
}
}
$user->addProperty(array('id' => 'product', 'type' => 'list', 'value' => '', 'list_values' => $products, 'is_system' => true));
$aliases = new SJB_PropertyAliases();
$aliases->addAlias(array('id' => 'user_group', 'real_id' => 'user_group_sid', 'transform_function' => 'SJB_UserGroupManager::getUserGroupSIDByID'));
$aliases->addAlias(array('id' => 'product', 'real_id' => 'product_sid'));
$_REQUEST['user_group']['equal'] = $userGroupSID;
$search_form_builder = new SJB_SearchFormBuilder($user);
$criteria_saver = new SJB_UserCriteriaSaver();
if (isset($_REQUEST['restore'])) {
$_REQUEST = array_merge($_REQUEST, $criteria_saver->getCriteria());
}
$criteria = $search_form_builder->extractCriteriaFromRequestData($_REQUEST, $user);
$search_form_builder->setCriteria($criteria);
$search_form_builder->registerTags($tp);
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($userGroupSID);
if (SJB_Request::getVar('online', '') == '1') {
$tp->assign("online", true);
}
$tp->assign('userGroupInfo', $userGroupInfo);
$tp->assign('products', $products);
$tp->assign('selectedProduct', isset($_REQUEST['product']['simple_equal']) ? $_REQUEST['product']['simple_equal'] : '');
$tp->display($searchTemplate);
/********************** S O R T I N G *********************/
$paginator = new SJB_UsersPagination($userGroupInfo, SJB_Request::getVar('online', ''), $template);
$firstLastName = '';
if (!empty($_REQUEST['FirstName']['equal'])) {
$name['FirstName']['any_words'] = $name['LastName']['any_words'] = $_REQUEST['FirstName']['equal'];
$firstLastName = $_REQUEST['FirstName'];
unset($_REQUEST['FirstName']);
$_REQUEST['FirstName']['fields_or'] = $name;
}
$criteria = $search_form_builder->extractCriteriaFromRequestData($_REQUEST, $user);
$inner_join = false;
// if search by product field
if (isset($_REQUEST['product']['simple_equal']) && $_REQUEST['product']['simple_equal'] != '') {
$inner_join = array('contracts' => array('join_field' => 'user_sid', 'join_field2' => 'sid', 'join' => 'INNER JOIN'));
}
if (SJB_Request::getVar('online', '') == '1') {
$maxLifeTime = ini_get("session.gc_maxlifetime");
$currentTime = time();
$innerJoinOnline = array('user_session_data_storage' => array('join_field' => 'user_sid', 'join_field2' => 'sid', 'select_field' => 'session_id', 'join' => 'INNER JOIN', 'where' => "AND unix_timestamp(`user_session_data_storage`.`last_activity`) + {$maxLifeTime} > {$currentTime}"));
if ($inner_join) {
$inner_join = array_merge($inner_join, $innerJoinOnline);
} else {
$inner_join = $innerJoinOnline;
}
}
$searcher = new SJB_UserSearcher(array('limit' => ($paginator->currentPage - 1) * $paginator->itemsPerPage, 'num_rows' => $paginator->itemsPerPage), $paginator->sortingField, $paginator->sortingOrder, $inner_join);
$found_users = array();
$found_users_sids = array();
if (SJB_Request::getVar('action', '') == 'search') {
$found_users = $searcher->getObjectsSIDsByCriteria($criteria, $aliases);
$criteria_saver->setSession($_REQUEST, $searcher->getFoundObjectSIDs());
} elseif (isset($_REQUEST['restore'])) {
$found_users = $criteria_saver->getObjectsFromSession();
}
foreach ($found_users as $id => $userID) {
$user_info = SJB_UserManager::getUserInfoBySID($userID);
$contractInfo = SJB_ContractManager::getAllContractsInfoByUserSID($user_info['sid']);
$user_info['products'] = count($contractInfo);
$found_users[$id] = $user_info;
}
$paginator->setItemsCount($searcher->getAffectedRows());
$sorted_found_users_sids = $found_users_sids;
/****************************************************************/
$tp->assign("userGroupInfo", $userGroupInfo);
$tp->assign("found_users", $found_users);
$searchFields = '';
foreach ($_REQUEST as $key => $val) {
if (is_array($val)) {
foreach ($val as $fieldName => $fieldValue) {
if (is_array($fieldValue)) {
foreach ($fieldValue as $fieldSubName => $fieldSubValue) {
$searchFields .= "&{$key}[{$fieldSubName}]=" . array_pop($fieldSubValue);
}
} else {
$searchFields .= "&{$key}[{$fieldName}]={$fieldValue}";
}
}
}
}
$tp->assign('paginationInfo', $paginator->getPaginationInfo());
$tp->assign("searchFields", $searchFields);
$tp->assign("found_users_sids", $sorted_found_users_sids);
$tp->assign('errors', $errors);
$tp->display($template);
}
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();
$current_user = SJB_UserManager::getCurrentUser();
$action = SJB_Request::getVar('action', 'productList');
$productSID = SJB_Request::getVar('product_sid', 0, 'default', 'int');
$template = 'products.tpl';
$availableProducts = array();
$errors = array();
switch ($action) {
case 'productList':
if (SJB_UserManager::isUserLoggedIn()) {
$postingProductsOnly = SJB_Request::getVar('postingProductsOnly', false);
$availableProducts = SJB_ProductsManager::getProductsByUserGroupSID($current_user->getUserGroupSID(), $current_user->getSID());
$trialProduncts = $current_user->getTrialProductSIDByUserSID();
foreach ($availableProducts as $key => $availableProduct) {
if (in_array($availableProduct['sid'], $trialProduncts) || $postingProductsOnly && $availableProduct['product_type'] != "post_listings" && $availableProduct['product_type'] != "mixed_product") {
unset($availableProducts[$key]);
}
}
if ($postingProductsOnly) {
$tp->assign('postingProductsOnly', $postingProductsOnly);
}
} elseif ($userGroupID = SJB_Request::getVar('userGroupID', false)) {
$userGroupSID = SJB_UserGroupManager::getUserGroupSIDByID($userGroupID);
$availableProducts = SJB_ProductsManager::getProductsByUserGroupSID($userGroupSID, 0);
} else {
$availableProducts = SJB_ProductsManager::getAllActiveProducts();
}
foreach ($availableProducts as $key => $availableProductInfo) {
if (SJB_ProductsManager::isProductTrialAndAlreadyInCart($availableProductInfo, $current_user)) {
unset($availableProducts[$key]);
continue;
}
$availableProduct = new SJB_Product($availableProductInfo, $availableProductInfo['product_type']);
$availableProduct->setNumberOfListings(1);
$availableProducts[$key]['price'] = $availableProduct->getPrice();
if (isset($availableProducts[$key]['listing_type_sid'])) {
$availableProducts[$key]['listing_type_id'] = SJB_ListingTypeDBManager::getListingTypeIDBySID($availableProducts[$key]['listing_type_sid']);
}
}
SJB_Event::dispatch('RedefineTemplateName', $template, true);
SJB_Event::dispatch('RedefineProductsDisplayInfo', $availableProducts, true);
$tp->assign("account_activated", SJB_Request::getVar('account_activated', ''));
$tp->assign("availableProducts", $availableProducts);
break;
case 'view_product_detail':
$template = 'view_product_detail.tpl';
if (!SJB_UserManager::isUserLoggedIn() || $current_user->mayChooseProduct($productSID, $errors)) {
$productInfo = SJB_ProductsManager::getProductInfoBySID($productSID);
if (in_array($productInfo['product_type'], array('post_listings', 'mixed_product'))) {
$productInfo['listingTypeID'] = SJB_ListingTypeManager::getListingTypeIDBySID($productInfo['listing_type_sid']);
}
$event = SJB_Request::getVar('event', false);
if ($event) {
if ($productInfo) {
switch ($productInfo['product_type']) {
case 'banners':
$params = $_REQUEST;
if (empty($params['title'])) {
$errors[] = "Banner Title is empty.";
}
if (empty($params['link'])) {
$errors[] = "Banner link mismatched!";
}
if (empty($_FILES['image']['name'])) {
$errors[] = "No file attached!";
} elseif ($_FILES['image']['error']) {
switch ($_FILES['image']['error']) {
case '1':
$errors[] = 'UPLOAD_ERR_INI_SIZE';
break;
case '2':
$errors[] = 'UPLOAD_ERR_FORM_SIZE';
break;
case '3':
$errors[] = 'UPLOAD_ERR_PARTIAL';
break;
case '4':
$errors[] = 'UPLOAD_ERR_NO_FILE';
break;
default:
$errors[] = 'NOT_UPLOAD_FILE';
break;
}
} else {
$imageInfo = @getimagesize($_FILES['image']['tmp_name']);
if (!$imageInfo || $imageInfo['2'] < 1 && $imageInfo['2'] > 3) {
$errors[] = 'Image format is not supported';
} elseif (!empty($productInfo['width']) && $imageInfo[0] != $productInfo['width']) {
$errors[] = "Your banner dimensions exceed the required size. Please upload an appropriate banner.";
} elseif (!empty($productInfo['height']) && $imageInfo[1] != $productInfo['height']) {
$errors[] = "Your banner dimensions exceed the required size. Please upload an appropriate banner.";
}
}
if ($errors) {
break;
}
//add banner
$title = $params['title'];
$link = $params['link'];
$expr = preg_match("/(http:\\/\\/)/", $link, $matches);
if ($expr != true) {
$link = "http://" . $link;
}
$filesDir = SJB_System::getSystemSettings('FILES_DIR');
$ext = preg_match("|\\.(\\w{3})\\b|u", $_FILES['image']['name'], $arr);
$fileName = preg_replace("|\\.(\\w{3})\\b|u", "", $_FILES['image']['name']);
$hashName = md5(time() * $_FILES['image']['size']) . "_" . $fileName;
$bannerFilePath = $filesDir . "banners/" . $hashName . "." . $arr[1];
$copy = move_uploaded_file($_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') {
$bannerInfo = getimagesize($bannerFilePath);
if ($productInfo['width'] != '' && $productInfo['height'] != '') {
$sx = $productInfo['width'];
$sy = $productInfo['height'];
} else {
$sx = $bannerInfo[0];
$sy = $bannerInfo[1];
}
$type = $bannerInfo['mime'];
} else {
if ($productInfo['width'] == '' || $productInfo['height'] == '') {
$errors[] = 'Your banner dimensions exceed the required size. Please upload an appropriate banner.';
break;
}
$sx = $productInfo['width'];
$sy = $productInfo['height'];
$type = $_FILES['image']['type'];
}
$active = 0;
$group = $productInfo['banner_group_sid'];
$params['bannerFilePath'] = "/" . str_replace("../", "/", str_replace(SJB_BASE_DIR, '', $bannerFilePath));
$params['openBannerIn'] = '';
$params['bannerType'] = 'file';
$params['code'] = '';
$params['title'] = $title;
$params['link'] = $link;
$params['type'] = $type;
$params['sx'] = $sx;
$params['sy'] = $sy;
$params['banner_group_sid'] = $group;
$productInfo['banner_info'] = $params;
break;
}
if (!$errors) {
$numberOfListings = SJB_Request::getVar('number_of_listings');
$extraInfo = SJB_ProductsManager::getProductExtraInfoBySID($productSID);
if (!empty($extraInfo['pricing_type']) && $extraInfo['pricing_type'] == 'volume_based' && $numberOfListings) {
$productInfo['number_of_listings'] = $numberOfListings;
$productObj = new SJB_Product($productInfo, $productInfo['product_type']);
$number_of_listings = !empty($productInfo['number_of_listings']) ? $productInfo['number_of_listings'] : 1;
$productObj->setNumberOfListings($number_of_listings);
$productInfo['price'] = $productObj->getPrice();
}
if (SJB_UserManager::isUserLoggedIn()) {
SJB_ShoppingCart::addToShoppingCart($productInfo, $current_user->getSID());
} else {
if (isset($_SESSION['products'])) {
foreach ($_SESSION['products'] as $addedProduct) {
$addedProductInfo = unserialize($addedProduct['product_info']);
if ($addedProductInfo['user_group_sid'] != $productInfo['user_group_sid']) {
$errors[] = 'You are trying to add products of different User Groups in your Shopping Cart. You сan add only products belonging to one User Group. If you want to add this product in the Shopping Cart please go back to the Shopping Cart and remove products of other User Groups.';
break;
}
}
}
if (!$errors) {
$id = time();
$_SESSION['products'][$id]['product_info'] = serialize($productInfo);
$_SESSION['products'][$id]['sid'] = $id;
$_SESSION['products'][$id]['user_sid'] = 0;
}
}
if (!$errors) {
SJB_HelperFunctions::redirect(SJB_System::getSystemsettings('SITE_URL') . '/shopping-cart/');
}
}
}
}
if (!empty($productInfo['expiration_period']) && !is_numeric($productInfo['expiration_period'])) {
$productInfo['period'] = ucwords($productInfo['expiration_period']);
} elseif (!empty($productInfo['pricing_type']) && $productInfo['pricing_type'] == 'volume_based' && !empty($productInfo['volume_based_pricing'])) {
$volumeBasedPricing = $productInfo['volume_based_pricing'];
$price = array();
$firstPrice = 0;
if (!empty($volumeBasedPricing['listings_range_from'])) {
for ($i = 1; $i <= count($volumeBasedPricing['listings_range_from']); $i++) {
if ($volumeBasedPricing['listings_range_from'][$i] == $volumeBasedPricing['listings_range_to'][$i]) {
$price[$i]['range']['from'] = $volumeBasedPricing['listings_range_from'][$i];
} else {
$price[$i]['range']['from'] = $volumeBasedPricing['listings_range_from'][$i];
$price[$i]['range']['to'] = $volumeBasedPricing['listings_range_to'][$i];
}
$price[$i]['price'] = $volumeBasedPricing['price_per_unit'][$i];
if ($i > 1 && $firstPrice > $volumeBasedPricing['price_per_unit'][$i]) {
$price[$i]['savings'] = round(100 - 100 / $firstPrice * $volumeBasedPricing['price_per_unit'][$i]);
} else {
$firstPrice = $volumeBasedPricing['price_per_unit'][$i];
}
}
}
$productInfo['volume_based_pricing'] = $price;
$minListings = min($volumeBasedPricing['listings_range_from']);
$maxListings = max($volumeBasedPricing['listings_range_to']);
$countListings = array();
for ($i = $minListings; $i <= $maxListings; $i++) {
$countListings[] = $i;
}
$productInfo['count_listings'] = $countListings;
} elseif (!empty($productInfo['pricing_type']) && $productInfo['pricing_type'] == 'fixed') {
$productInfo['fixed_period'] = 1;
}
if ($productInfo['product_type'] == 'banners') {
$params = $_REQUEST;
$bannersObj = new SJB_Banners();
$banner_fields = $bannersObj->getBannersMeta();
foreach ($banner_fields as $key => $banner_field) {
$banner_fields[$banner_field['id']] = $banner_field;
if (!empty($params[$banner_field['id']])) {
$banner_fields[$banner_field['id']]['value'] = $params[$banner_field['id']];
}
unset($banner_fields[$key]);
}
if (!empty($params['errors'])) {
$tp->assign("errors", $params['errors']);
}
$tp->assign("banner_fields", $banner_fields);
}
$userGroupID = SJB_UserGroupDBManager::getUserGroupIDBySID($productInfo['user_group_sid']);
$tp->assign('productInfo', $productInfo);
$tp->assign('userGroupID', $userGroupID);
$tp->assign('productSID', $productSID);
$tp->assign('mayChooseProduct', true);
}
$tp->assign('errors', $errors);
break;
}
$tp->display($template);
}
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 function execute()
{
$tp = SJB_System::getTemplateProcessor();
$action = SJB_Request::getVar('action', false);
$sid = SJB_Request::getVar('sid', 0);
$errors = array();
$productErrors = array();
$productInfo = SJB_ProductsManager::getProductInfoBySID($sid);
if ($productInfo) {
if ($productInfo['product_type'] == 'featured_user') {
$_REQUEST['user_group_sid'] = SJB_UserGroupManager::getUserGroupSIDByID('Employer');
}
$productInfo = array_merge($productInfo, $_REQUEST);
$product = new SJB_Product($productInfo, $productInfo['product_type']);
$pages = $product->getProductPages();
$editProductForm = new SJB_Form($product);
$editProductForm->registerTags($tp);
$form_submitted = SJB_Request::getVar('action', '') == 'save';
if ($form_submitted && in_array($productInfo['product_type'], array('access_listings', 'featured_user', 'banners', 'custom_product'))) {
$periodName = $product->getPropertyValue('period_name');
if ($periodName == 'unlimited') {
$product->makePropertyNotRequired('period');
}
}
$activeError = array();
if ($form_submitted && ($productInfo['active'] = 1)) {
if (!empty($productInfo['availability_to']) && SJB_I18N::getInstance()->getInput('date', $productInfo['availability_to']) <= date('Y-m-d')) {
$activeError['INVALID_ACTIVATION'] = 'The product cannot be activated. Please change the availability date.';
}
}
if ($form_submitted) {
$productErrors = $product->isValid($product);
$activeError = array_merge($activeError, $productErrors);
}
if ($form_submitted && $editProductForm->isDataValid($errors) && !$activeError) {
$product->addProperty(array('id' => 'product_type', 'type' => 'string', 'value' => $productInfo['product_type'], 'is_system' => true));
$product->saveProduct($product, $_REQUEST);
$product->savePermissions($_REQUEST);
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . '/edit-product/?sid=' . $product->getSID());
}
$errors = array_merge($errors, $activeError);
$formFieldsInfo = $editProductForm->getFormFieldsInfo();
$formFields = array();
foreach ($pages as $pageID => $page) {
foreach ($formFieldsInfo as $formFieldInfo) {
if (in_array($formFieldInfo['id'], $page['fields'])) {
$formFields[$pageID][] = $formFieldInfo;
}
}
if (!isset($formFields[$pageID])) {
$formFields[$pageID] = array();
}
}
$tp->assign('form_fields', $formFields);
$tp->assign('product_info', $productInfo);
$tp->assign('product_type', $productInfo['product_type']);
$tp->assign('pages', $pages);
$tp->assign('pageTab', SJB_Request::getVar('page', false));
$tp->assign("errors", $errors);
$tp->display('clone_product.tpl');
}
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$template = SJB_Request::getVar('display_template');
$page = 1;
$searchId = strip_tags(SJB_Request::getVar('searchId', time()));
if (!empty($_REQUEST["page"])) {
$page = intval($_REQUEST["page"]);
}
$items_per_page = SJB_Request::getVar('companies_per_page', false);
$listing_type_sid = SJB_ListingTypeManager::getListingTypeSIDByID($_REQUEST["listing_type_id"]);
$alphabets = SJB_AlphabetManager::getAlphabetsForDisplay();
$abArr = array();
foreach ($alphabets as $alphabet) {
$abArr[] = explode(' ', $alphabet['value']);
}
$action = SJB_Request::getVar('action', 'search_form');
if (SJB_Request::getVar('first_char')) {
$action = 'search';
$_REQUEST['CompanyName']['first_char_like'] = SJB_Request::getVar('first_char');
} elseif (!isset($_REQUEST['CompanyName']) || $_REQUEST['CompanyName']['like'] == '') {
$_REQUEST['CompanyName']['not_empty'] = true;
}
$userGroupSid = SJB_UserGroupManager::getUserGroupSIDByID('Employer');
$userGroupFields = SJB_UserProfileFieldManager::getFieldsInfoByUserGroupSID($userGroupSid);
foreach ($userGroupFields as $key => $userGroupField) {
if ($userGroupField['type'] == 'location') {
$userGroupFields[$key]['fields'] = array();
$userGroupFields[$key]['fields'][$userGroupField['sid']] = $userGroupField;
}
}
$user = new SJB_User(array(), $userGroupSid);
$_REQUEST['active']['equal'] = 1;
$search_form_builder = new SJB_SearchFormBuilder($user);
$criteria_saver = new SJB_UserCriteriaSaver($searchId);
$criteria_saver->setSessionForOrderInfo($_REQUEST);
if (isset($_REQUEST['searchId'])) {
$action = 'search';
$criteria = $criteria_saver->getCriteria();
if (!empty($_REQUEST['sorting_field'])) {
unset($criteria['sorting_field']);
} else {
$orderInfo = $criteria_saver->getOrderInfo();
if (!empty($orderInfo['sorting_order'])) {
$criteria['sorting_order'] = $orderInfo['sorting_order'];
}
}
$_REQUEST = array_merge($_REQUEST, $criteria);
if (!$items_per_page) {
$items_per_page = $criteria_saver->listings_per_page;
}
}
$items_per_page = $items_per_page ? $items_per_page : 10;
$criteria = $search_form_builder->extractCriteriaFromRequestData(array_merge($_REQUEST, array('username' => array('not_equal' => 'jobg8'))), $user);
if ($items_per_page) {
$criteria_saver->setSessionForListingsPerPage($items_per_page);
}
$search_form_builder->setCriteria($criteria);
$search_form_builder->registerTags($tp);
$form_fields = $search_form_builder->getFormFieldsInfo();
$tp->assign('form_fields', $form_fields);
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign('METADATA', array('form_fields' => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$tp->assign('userGroupFields', $userGroupFields);
$tp->assign('action', $action);
$tp->assign('alphabets', $abArr);
if ($action == 'search') {
$sorting_field = SJB_Request::getVar('sorting_field', false);
$sorting_order = SJB_Request::getVar('sorting_order', false);
if (isset($_REQUEST['searchId']) && !$sorting_field) {
$order_info = $criteria_saver->order_info;
if ($order_info) {
$sorting_field = $order_info['sorting_field'];
$sorting_order = $order_info['sorting_order'];
}
}
if (!$sorting_field) {
$sorting_field = 'CompanyName';
$sorting_order = 'ASC';
}
$inner_join = array();
if ($sorting_field == 'number_of_jobs') {
if (SJB_ListingTypeManager::getWaitApproveSettingByListingType($listing_type_sid) == 1) {
$count = "sum( if( `listings`.`status` = 'approved', `listings`.`active`, 0 ) )";
} else {
$count = "sum(`listings`.`active`)";
}
$inner_join = array('listings' => array('sort_field' => $count, 'noPresix' => true, 'join_field' => 'user_sid', 'join_field2' => 'sid', 'join' => 'LEFT JOIN', 'groupBy' => '`users`.`sid`'));
} elseif ($sorting_field == 'Location_State') {
$inner_join = array('states' => array('sort_field' => 'state_name', 'noPresix' => true, 'join_field' => 'sid', 'join_field2' => 'Location_State', 'join' => 'LEFT JOIN'));
}
$searcher = new SJB_UserSearcher(false, $sorting_field, $sorting_order, $inner_join, array('limit' => ($page - 1) * $items_per_page, 'num_rows' => $items_per_page));
$found_users = array();
$found_users_sids = array();
$found_users_by_criteria = $searcher->getObjectsByCriteria($criteria, null, array(), true);
$foundObjectSIDs = $searcher->getFoundObjectSIDs();
// display search form
$tp->display($template);
$criteria_saver->setSession($_REQUEST, $foundObjectSIDs);
if (count($foundObjectSIDs) > 0) {
$listingType = SJB_ListingTypeManager::getListingTypeInfoBySID($listing_type_sid);
$countListings = SJB_ListingDBManager::getActiveAndApproveJobsNumberForUsers($foundObjectSIDs, $listingType);
}
foreach ($found_users_by_criteria as $id => $user) {
$listingsNumber = isset($countListings[$id]) ? $countListings[$id] : 0;
$user->addProperty(array('id' => 'countListings', 'type' => 'string', 'value' => $listingsNumber));
if ($user->getProperty('CompanyName')) {
$found_users_sids[$user->getSID()] = $user->getSID();
$found_users[$id] = $user;
}
}
$usersCount = $searcher->getAffectedRows();
$form_collection = new SJB_FormCollection($found_users);
$form_collection->registerTags($tp);
$pages = array();
for ($i = $page - 3; $i < $page + 3; $i++) {
if ($i > 0) {
$pages[] = $i;
}
if ($i * $items_per_page > $usersCount) {
break;
}
}
$totalPages = ceil($usersCount / $items_per_page);
if (empty($totalPages)) {
$totalPages = 1;
}
if (array_search(1, $pages) === false) {
array_unshift($pages, 1);
}
if (array_search($totalPages, $pages) === false) {
array_push($pages, $totalPages);
}
$tp->assign("sorting_order", $sorting_order);
$tp->assign("sorting_field", $sorting_field);
$tp->assign("found_users_sids", $found_users_sids);
$tp->assign("companies_per_page", $items_per_page);
$tp->assign("searchId", $searchId);
$tp->assign("usersCount", $usersCount);
$tp->assign("current_page", $page);
$tp->assign("pages_number", $totalPages);
$tp->display('search_result_company.tpl');
} else {
// display search form
$tp->display($template);
}
}
private function CreateUser($user_info, $user_group_id)
{
$user_group_sid = SJB_UserGroupManager::getUserGroupSIDByID($user_group_id);
return new SJB_User($user_info, $user_group_sid);
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$extUserID = SJB_Request::getVar('extUserID', null);
$passedParametersViaUri = SJB_UrlParamProvider::getParams();
$userGroupID = $passedParametersViaUri ? array_shift($passedParametersViaUri) : false;
if (!$userGroupID) {
$userGroupsInfo = SJB_UserGroupManager::getAllUserGroupsInfo();
$tp->assign('user_groups_info', $userGroupsInfo);
$tp->display('add_user_choose_user_group.tpl');
} else {
$userGroupSID = SJB_UserGroupManager::getUserGroupSIDByID($userGroupID);
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($userGroupSID);
$user = SJB_ObjectMother::createUser($_REQUEST, $userGroupSID);
$user->deleteProperty('active');
$user->addExtUserIDProperty($extUserID);
$registration_form = SJB_ObjectMother::createForm($user);
$registration_form->registerTags($tp);
$form_submitted = SJB_Request::getVar('action', '') == 'add';
$errors = array();
if (SJB_UserGroupManager::isUserEmailAsUsernameInUserGroup($userGroupSID) && $form_submitted) {
$email = $user->getPropertyValue('email');
if (is_array($email)) {
$email = $email['original'];
}
$user->setPropertyValue('username', $email);
}
if ($form_submitted && $registration_form->isDataValid($errors)) {
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);
// clean temporary storage
$tmpUploadsStorage = SJB_Array::unsetValueByPath($tmpUploadsStorage, "{$formToken}");
// CLEAR TEMPORARY SESSION STORAGE
SJB_Session::setValue('tmp_uploads_storage', $tmpUploadsStorage);
}
}
// <<< SJB-1197
SJB_UserManager::activateUserByUserName($user->getUserName());
$defaultProduct = SJB_UserGroupManager::getDefaultProduct($userGroupSID);
$availableProductIDs = SJB_ProductsManager::getProductsIDsByUserGroupSID($userGroupSID);
if ($defaultProduct && in_array($defaultProduct, $availableProductIDs)) {
$contract = new SJB_Contract(array('product_sid' => $defaultProduct));
$contract->setUserSID($user->getSID());
$contract->saveInDB();
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/manage-users/" . mb_strtolower($userGroupInfo['id'], 'utf8'));
} else {
if (SJB_UserGroupManager::isUserEmailAsUsernameInUserGroup($userGroupSID)) {
$user->deleteProperty('username');
}
$registration_form = SJB_ObjectMother::createForm($user);
$registration_form->registerTags($tp);
$tp->assign("errors", $errors);
$tp->assign("user_group", $userGroupInfo);
$tp->assign('userTree', true);
$tp->assign("form_fields", $registration_form->getFormFieldsInfo());
$tp->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$tp->display("add_user.tpl");
}
}
}
