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();
$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();
$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()
{
ini_set('max_execution_time', 0);
$template_processor = SJB_System::getTemplateProcessor();
$errors = array();
$encodingFromCharset = SJB_Request::getVar('encodingFromCharset', 'UTF-8');
$file_info = isset($_FILES['import_file']) ? $_FILES['import_file'] : null;
if (!empty($file_info)) {
$extension = $_REQUEST['file_type'];
if (!SJB_ImportFile::isValidFileExtensionByFormat($extension, $file_info)) {
$errors['DO_NOT_MATCH_SELECTED_FILE_FORMAT'] = true;
}
}
if (empty($file_info) || $file_info['error'] || !empty($errors)) {
if (isset($file_info['error']) && $file_info['error'] > 0) {
$errors[SJB_UploadFileManager::getErrorId($file_info['error'])] = 1;
}
$user_groups = SJB_UserGroupManager::getAllUserGroupsInfo();
$template_processor->assign("uploadMaxFilesize", SJB_UploadFileManager::getIniUploadMaxFilesize());
$template_processor->assign('user_groups', $user_groups);
$template_processor->assign('errors', $errors);
$template_processor->assign('charSets', SJB_HelperFunctions::getCharSets());
$template_processor->display('import_users.tpl');
} else {
$csv_delimiter = SJB_Request::getVar('csv_delimiter', null);
$user_group_id = SJB_Request::getVar('user_group_id', null);
$user_group_sid = SJB_UserGroupManager::getUserGroupSIDByID($user_group_id);
if ($extension == 'xls') {
$import_file = new SJB_ImportFileXLS($file_info);
} elseif ($extension == 'csv') {
$import_file = new SJB_ImportFileCSV($file_info, $csv_delimiter);
}
$import_file->parse($encodingFromCharset);
$user = $this->CreateUser(array(), $user_group_id);
$imported_data = $import_file->getData();
$count = 0;
$import_file_url = false;
$usersID = array();
foreach ($imported_data as $key => $importedColumn) {
if ($key == 1) {
$imported_user_processor = new SJB_ImportedUserProcessor($importedColumn, $user);
continue;
}
if (!$importedColumn) {
continue;
}
$userInfo = $imported_user_processor->getData($importedColumn);
$extUserID = isset($userInfo['extUserID']) ? $userInfo['extUserID'] : '';
$user = $this->CreateUser(array(), $user_group_id);
$user->addExtUserIDProperty();
$doc = new DOMDocument();
foreach ($user->getProperties() as $property) {
if ($property->id == 'active') {
$property->type->property_info['value'] = $property->value;
} elseif ($property->getType() == 'location') {
$locationFields = array($property->id . '.Country', $property->id . '.State', $property->id . '.City', $property->id . '.ZipCode', $property->id . '.Address');
$locationFieldAdded = array();
foreach ($locationFields as $locationField) {
if (array_key_exists($locationField, $userInfo)) {
switch ($locationField) {
case $property->id . '.Country':
$value = SJB_CountriesManager::getCountrySIDByCountryName($userInfo[$locationField]);
if (!$value) {
$value = SJB_CountriesManager::getCountrySIDByCountryCode($userInfo[$locationField]);
}
break;
case $property->id . '.State':
$value = SJB_StatesManager::getStateSIDByStateName($userInfo[$locationField]);
if (!$value) {
$value = SJB_StatesManager::getStateSIDByStateCode($userInfo[$locationField]);
}
break;
default:
$value = $userInfo[$locationField];
break;
}
unset($userInfo[$locationField]);
$userInfo[$property->id][str_replace($property->id . '.', '', $locationField)] = $value;
$locationFieldAdded[] = str_replace($property->id . '.', '', $locationField);
}
}
if ($property->id == 'Location') {
$locationFields = array('Country', 'State', 'City', 'ZipCode', 'Address');
foreach ($locationFields as $locationField) {
if (array_key_exists($locationField, $userInfo) && !in_array($locationField, $locationFieldAdded) && !$user->getProperty($locationField)) {
switch ($locationField) {
case 'Country':
$value = SJB_CountriesManager::getCountrySIDByCountryName($userInfo[$locationField]);
if (!$value) {
$value = SJB_CountriesManager::getCountrySIDByCountryCode($userInfo[$locationField]);
}
break;
case 'State':
$value = SJB_StatesManager::getStateSIDByStateName($userInfo[$locationField]);
if (!$value) {
$value = SJB_StatesManager::getStateSIDByStateCode($userInfo[$locationField]);
}
break;
default:
$value = $userInfo[$locationField];
break;
}
$userInfo[$property->id][$locationField] = $value;
unset($userInfo[$locationField]);
}
}
}
}
}
$user = $this->CreateUser($userInfo, $user_group_id);
$user->addExtUserIDProperty($extUserID);
$username = SJB_Array::get($userInfo, 'username');
if (empty($username)) {
$errors[] = 'Empty username is not allowed, record ignored.';
} elseif (!is_null(SJB_UserManager::getUserSIDbyUsername($username))) {
$errors[] = '\'' . $userInfo['username'] . '\' - this user name already exists, record ignored.';
} else {
$originalMd5Password = $user->getPropertyValue('password');
SJB_UserManager::saveUser($user);
$this->extraProperties($user, $userInfo, $usersID);
if (!empty($originalMd5Password)) {
SJB_UserManager::saveUserPassword($user->getSID(), $originalMd5Password);
}
$isApproveByAdmin = SJB_UserGroupManager::isApproveByAdmin($user_group_sid);
if ($isApproveByAdmin) {
SJB_UserManager::setApprovalStatusByUserName($user->getUserName(), 'Pending');
}
$count++;
}
}
if ($import_file_url) {
SJB_Filesystem::delete(SJB_System::getSystemSettings("IMPORT_FILES_DIRECTORY"));
}
$template_processor->assign('imported_users_count', $count);
$template_processor->assign('errors', $errors);
$template_processor->display('import_users_result.tpl');
}
}
