public static function deletePendingContractByInvoiceID($invoiceID, $userSID, $productSID)
{
$contracts = SJB_DB::query("SELECT id FROM `contracts` WHERE `invoice_id` = ?s AND `user_sid` = ?s AND `product_sid` = ?n AND `status` = 'pending'", $invoiceID, $userSID, $productSID);
foreach ($contracts as $contract) {
SJB_ContractManager::deleteContractIDFromNotificationSended($contract['id']);
}
return SJB_DB::query("DELETE FROM `contracts` WHERE `invoice_id` = ?s AND `user_sid` = ?s AND `product_sid` = ?n AND `status` = 'pending'", $invoiceID, $userSID, $productSID);
}
public function deleteContract($invoiceID, $productSID, $userSID)
{
$contractID = SJB_ContractManager::getContractIDByInvoiceID($invoiceID, $productSID, $userSID);
if ($contractID) {
SJB_ContractManager::deleteContract($contractID, $userSID);
SJB_Statistics::deleteStatistics('payment', 'product', $this->product['sid'], $userSID, $this->product['amount']);
}
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$gateway = SJB_PaymentGatewayManager::getObjectByID(SJB_Request::getVar('gateway'), true);
if (!empty($gateway)) {
$invoiceID = SJB_Request::getVar('invoiceID', false);
$cancelSubscriptionResult = $gateway->cancelSubscription(SJB_Request::getVar('subscriptionId'), $invoiceID);
$errors = array();
if ($cancelSubscriptionResult !== true) {
$errors = $cancelSubscriptionResult;
} else {
SJB_ContractManager::removeSubscriptionId(SJB_Request::getVar('subscriptionId'));
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/my-products/?cancelRecurringContract=' . SJB_Request::getVar('contractId'));
}
$tp->assign('errors', $errors);
$tp->display('cancel_recurring.tpl');
}
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$action = SJB_Request::getVar('action', false);
$sid = SJB_Request::getVar('sid', 0);
$errors = array();
switch ($action) {
case 'activate':
SJB_ProductsManager::activateProductBySID($sid);
break;
case 'deactivate':
SJB_ProductsManager::deactivateProductBySID($sid);
break;
case 'delete':
if (SJB_ContractManager::getContractQuantityByProductSID($sid) || SJB_InvoiceManager::getInvoiceQuantityByProductSID($sid)) {
$errors['PRODUCT_IS_IN_USE'] = 1;
} else {
SJB_ProductsManager::deleteProductBySID($sid);
}
break;
}
$products = SJB_ProductsManager::getAllProductsInfo();
foreach ($products as $key => $productInfo) {
$product = new SJB_Product($productInfo, $productInfo['product_type']);
$product->setNumberOfListings(1);
if ($productInfo['product_type'] != 'post_listings' && $productInfo['product_type'] != 'mixed_product') {
$products[$key]['number_of_postings'] = '-';
}
$products[$key]['price'] = $product->getPrice();
$products[$key]['user_group'] = SJB_UserGroupManager::getUserGroupInfoBySID($productInfo['user_group_sid']);
$products[$key]['product_type'] = SJB_ProductsManager::getProductTypeByID($productInfo['product_type']);
$products[$key]['subscribed_users'] = SJB_ContractManager::getContractQuantityByProductSID($productInfo['sid']);
$products[$key]['invoices'] = SJB_InvoiceManager::getInvoiceQuantityByProductSID($productInfo['sid']);
if (!empty($productInfo['availability_to']) && $productInfo['availability_to'] <= date('Y-m-d')) {
$products[$key]['expired'] = 1;
}
}
$tp->assign('errors', $errors);
$tp->assign('products', $products);
$tp->display('products.tpl');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$action = SJB_Request::getVar('action');
$template = 'task_scheduler_settings.tpl';
$isPseudoCronEnabled = intval(SJB_Settings::getSettingByName('isPseudoCronEnabled')) == 1;
if (SJB_Request::getVar('command', null, 'post') == 'manage-pseudo-cron') {
SJB_Settings::updateSetting('isPseudoCronEnabled', SJB_Request::getVar('isEnabled', 'off', 'post') == 'on' ? '1' : '0');
SJB_Settings::updateSetting('numberOfPageViewsToExecCronIfExceeded', SJB_Request::getVar('numberOfPageViewsToExecCronIfExceeded', null, 'post'));
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/task-scheduler-settings');
}
$tp->assign('isPseudoCronEnabled', $isPseudoCronEnabled);
$numberOfPageViewsToExecCronIfExceeded = intval(SJB_Settings::getSettingByName('numberOfPageViewsToExecCronIfExceeded'));
$tp->assign('cronPath', SJB_BASE_DIR . 'cron/index.php');
$tp->assign('numberOfPageViewsToExecCronIfExceeded', $numberOfPageViewsToExecCronIfExceeded);
if ($action != 'log_view') {
$last_executed_date = SJB_System::getSettingByName('task_scheduler_last_executed_date');
$expired_listings_id = SJB_ListingManager::getExpiredListingsSID();
$count_expired_listings = count($expired_listings_id);
$expired_contracts_id = SJB_ContractManager::getExpiredContractsID();
$count_expired_contracts = count($expired_contracts_id);
$res = SJB_DB::query("SELECT * FROM `task_scheduler_log` ORDER BY `sid` DESC LIMIT 1");
$tp->assign('last_executed_date', $last_executed_date);
$tp->assign('task_scheduler_log', array_pop($res));
} else {
$log_file = array();
$res = SJB_DB::query("SELECT `log_text` FROM `task_scheduler_log` ORDER BY `sid` DESC LIMIT 30");
foreach ($res as $record) {
$text = $record['log_text'];
if ($text) {
$log_file[] = $text;
}
}
$tp->assign('log_content', $log_file);
$template = 'task_scheduler_log_view.tpl';
}
$tp->display($template);
}
function handleRecurringNotification($notification_data)
{
//набор полей такой же как и при callback с Authorize.NET
//плюс два поля x_subscription_id и x_subscription_paynum
if (!$this->isNotificationFromGateway($notification_data)) {
return;
//уведомление не от Authorize.NET
} else {
if ($this->isNotificationSuccessfull($notification_data)) {
$invoice_sid = null;
if (isset($notification_data['x_invoice_num'])) {
$invoice_sid = $notification_data['x_invoice_num'];
}
if (is_null($invoice_sid)) {
return;
}
$invoice = SJB_InvoiceManager::getObjectBySID($invoice_sid);
if (is_null($invoice)) {
return null;
}
$reactivation = false;
if ($invoice->getStatus() == SJB_Invoice::INVOICE_STATUS_PAID) {
// Пришёл рекьюринг платёж
$invoice->setSID(null);
$invoice->setDate(null);
$invoice->setStatus(SJB_Invoice::INVOICE_STATUS_UNPAID);
$reactivation = true;
}
$invoice->setCallbackData($notification_data);
if (!$this->checkPaymentAmount($invoice)) {
return null;
}
$invoice->setStatus(SJB_Invoice::INVOICE_STATUS_PAID);
SJB_PromotionsManager::markPromotionAsPaidByInvoiceSID($invoice->getSID());
$user_sid = $invoice->getPropertyValue('user_sid');
$items = $invoice->getPropertyValue('items');
if (!empty($items['products'])) {
$recurringProductsInfo = array();
foreach ($items['products'] as $key => $product) {
if ($product != -1) {
$productInfo = $invoice->getItemValue($key);
$listingNumber = $productInfo['qty'];
$contract = new SJB_Contract(array('product_sid' => $product, 'recurring_id' => $notification_data['x_subscription_id'], 'gateway_id' => 'authnet_sim', 'numberOfListings' => $listingNumber));
if (isset($contract)) {
$contract->setUserSID($user_sid);
$contractSID = SJB_ContractManager::getContractSIDByRecurringId($notification_data['x_subscription_id']);
SJB_ContractManager::deleteAllContractsByRecurringId($notification_data['x_subscription_id']);
$contract->setPrice($productInfo['amount']);
if ($contract->saveInDB()) {
SJB_ShoppingCart::deleteItemFromCartBySID($productInfo['shoppingCartRecord'], $user_sid);
$bannerInfo = $productInfo['banner_info'];
if ($productInfo['product_type'] == 'banners' && !empty($bannerInfo) && $contractSID) {
$bannersObj = new SJB_Banners();
$bannerID = $bannersObj->getBannerIDByContract($contractSID);
if ($bannerID) {
$bannersObj->updateBannerContract($contract->getID(), $bannerID);
}
}
SJB_Statistics::addStatistics('payment', 'product', $product, false, 0, 0, $user_sid, $productInfo['amount']);
if (SJB_UserNotificationsManager::isUserNotifiedOnSubscriptionActivation($user_sid)) {
SJB_Notifications::sendSubscriptionActivationLetter($user_sid, $productInfo, $reactivation);
}
}
}
if (isset($productInfo['recurring'])) {
$recurringProductsInfo[$key] = $productInfo;
}
}
}
if ($reactivation) {
$invoice->setNewPropertiesToInvoice($recurringProductsInfo);
}
SJB_InvoiceManager::saveInvoice($invoice);
if (isset($notification_data['x_trans_id'])) {
$transactionId = $notification_data['x_trans_id'];
$transactionInfo = array('transaction_id' => $transactionId, 'invoice_sid' => $invoice->getSID(), 'amount' => $invoice->getPropertyValue('total'), 'payment_method' => $invoice->getPropertyValue('payment_method'), 'user_sid' => $invoice->getPropertyValue('user_sid'));
$transaction = new SJB_Transaction($transactionInfo);
SJB_TransactionManager::saveTransaction($transaction);
}
}
} else {
//уведомление о неуспешном платеже
}
}
}
/**
* Recurring notification handlign function
* @param array|null $callback_data Notification data
*/
function handleRecurringNotification($callback_data)
{
if (SJB_Array::get($callback_data, 'txn_type') == 'subscr_cancel' || SJB_Array::get($callback_data, 'txn_type') == 'subscr_eot') {
SJB_ContractManager::removeSubscriptionId(SJB_Array::get($callback_data, 'subscr_id'));
return;
}
if (SJB_Array::get($callback_data, 'txn_type') != 'subscr_payment') {
return;
}
$invoice_sid = isset($callback_data['item_number']) ? $callback_data['item_number'] : null;
if (is_null($invoice_sid)) {
return;
}
$invoice = SJB_InvoiceManager::getObjectBySID($invoice_sid);
if (is_null($invoice)) {
return null;
}
$reactivation = false;
$status = $invoice->getStatus();
if ($invoice->getStatus() == SJB_Invoice::INVOICE_STATUS_PAID) {
// Пришёл рекьюринг платёж
$invoice->setSID(null);
$invoice->setDate(null);
$invoice->setStatus(SJB_Invoice::INVOICE_STATUS_UNPAID);
$reactivation = true;
}
$invoice->setCallbackData($callback_data);
if ($this->isPaymentVerified($invoice) && in_array($callback_data['payment_status'], array('Completed', 'Processed'))) {
$items = $invoice->getPropertyValue('items');
$user_sid = $invoice->getUserSID();
$subscriptionSID = $callback_data['custom'];
if (!empty($items['products'])) {
$recurringProductsInfo = array();
foreach ($items['products'] as $key => $product) {
if ($product != -1) {
$productInfo = $invoice->getItemValue($key);
if ($status == SJB_Invoice::INVOICE_STATUS_PAID && $subscriptionSID == $product) {
$listingNumber = $productInfo['qty'];
$contract = new SJB_Contract(array('product_sid' => $product, 'recurring_id' => $callback_data['subscr_id'], 'gateway_id' => 'paypal_standard', 'numberOfListings' => $listingNumber));
$contract->setUserSID($user_sid);
$contractSID = SJB_ContractManager::getContractSIDByRecurringId($callback_data['subscr_id']);
SJB_ContractManager::deleteAllContractsByRecurringId($callback_data['subscr_id']);
$contract->setPrice($productInfo['amount']);
if ($contract->saveInDB()) {
SJB_ShoppingCart::deleteItemFromCartBySID($productInfo['shoppingCartRecord'], $user_sid);
$bannerInfo = $productInfo['banner_info'];
if ($productInfo['product_type'] == 'banners' && !empty($bannerInfo)) {
$bannersObj = new SJB_Banners();
if (isset($contractSID)) {
$bannerID = $bannersObj->getBannerIDByContract($contractSID);
if ($bannerID) {
$bannersObj->updateBannerContract($contract->getID(), $bannerID);
}
} else {
$bannersObj->addBanner($bannerInfo['title'], $bannerInfo['link'], $bannerInfo['bannerFilePath'], $bannerInfo['sx'], $bannerInfo['sy'], $bannerInfo['type'], 0, $bannerInfo['banner_group_sid'], $bannerInfo, $user_sid, $contract->getID());
$bannerGroup = $bannersObj->getBannerGroupBySID($bannerInfo['banner_group_sid']);
SJB_AdminNotifications::sendAdminBannerAddedLetter($user_sid, $bannerGroup);
}
}
if ($contract->isFeaturedProfile()) {
SJB_UserManager::makeFeaturedBySID($user_sid);
}
SJB_Statistics::addStatistics('payment', 'product', $product, false, 0, 0, $user_sid, $productInfo['amount']);
if (SJB_UserNotificationsManager::isUserNotifiedOnSubscriptionActivation($user_sid)) {
SJB_Notifications::sendSubscriptionActivationLetter($user_sid, $productInfo, $reactivation);
}
}
$recurringProductsInfo[$key] = $productInfo;
} elseif ($status != SJB_Invoice::INVOICE_STATUS_PAID) {
$listingNumber = $productInfo['qty'];
if ($subscriptionSID == $product) {
$contract = new SJB_Contract(array('product_sid' => $product, 'recurring_id' => $callback_data['subscr_id'], 'gateway_id' => 'paypal_standard', 'numberOfListings' => $listingNumber));
} else {
$contract = new SJB_Contract(array('product_sid' => $product, 'gateway_id' => 'paypal_standard', 'numberOfListings' => $listingNumber));
}
$contract->setUserSID($user_sid);
$contract->setPrice($productInfo['amount']);
if ($contract->saveInDB()) {
SJB_ShoppingCart::deleteItemFromCartBySID($productInfo['shoppingCartRecord'], $user_sid);
$bannerInfo = $productInfo['banner_info'];
if ($productInfo['product_type'] == 'banners' && !empty($bannerInfo) && $contractSID) {
$bannersObj = new SJB_Banners();
$bannersObj->addBanner($bannerInfo['title'], $bannerInfo['link'], $bannerInfo['bannerFilePath'], $bannerInfo['sx'], $bannerInfo['sy'], $bannerInfo['type'], 0, $bannerInfo['banner_group_sid'], $bannerInfo, $user_sid, $contract->getID());
$bannerGroup = $bannersObj->getBannerGroupBySID($bannerInfo['banner_group_sid']);
SJB_AdminNotifications::sendAdminBannerAddedLetter($user_sid, $bannerGroup);
}
if ($contract->isFeaturedProfile()) {
SJB_UserManager::makeFeaturedBySID($user_sid);
}
SJB_Statistics::addStatistics('payment', 'product', $product, false, 0, 0, $user_sid, $productInfo['amount']);
if (SJB_UserNotificationsManager::isUserNotifiedOnSubscriptionActivation($user_sid)) {
SJB_Notifications::sendSubscriptionActivationLetter($user_sid, $productInfo);
}
}
}
}
}
if ($reactivation) {
$invoice->setNewPropertiesToInvoice($recurringProductsInfo);
}
$price = isset($callback_data['payment_gross']) ? $callback_data['payment_gross'] : $invoice->getPropertyValue('total');
$invoice->setStatus(SJB_Invoice::INVOICE_STATUS_PAID);
$id = $this->details->getProperty('id');
$invoice->setPropertyValue('payment_method', $id->getValue());
SJB_InvoiceManager::saveInvoice($invoice);
SJB_PromotionsManager::markPromotionAsPaidByInvoiceSID($invoice->getSID());
$transactionID = $callback_data['txn_id'];
$transactionInfo = array('transaction_id' => $transactionID, 'invoice_sid' => $invoice->getSID(), 'amount' => $price, 'payment_method' => $invoice->getPropertyValue('payment_method'), 'user_sid' => $invoice->getPropertyValue('user_sid'));
$transaction = new SJB_Transaction($transactionInfo);
SJB_TransactionManager::saveTransaction($transaction);
}
} else {
$invoice->setStatus(SJB_Invoice::INVOICE_STATUS_UNPAID);
SJB_InvoiceManager::saveInvoice($invoice);
}
}
public static function deleteUserById($id)
{
$user = SJB_UserManager::getObjectBySID($id);
if (empty($user)) {
SJB_UserDBManager::deleteEmptyUsers();
return true;
}
SJB_Event::dispatch('onBeforeUserDelete', $user);
$listings = SJB_ListingDBManager::getListingsSIDByUserSID($id);
SJB_ListingManager::deleteListingBySID($listings);
$subusers = self::getSubusers($id);
foreach ($subusers as $subuser) {
self::deleteUserById($subuser['sid']);
}
// delete user logo file
$pictProp = $user->getProperty('Logo');
if ($pictProp) {
SJB_UploadFileManager::deleteUploadedFileByID($pictProp->value);
}
$videoProp = $user->getProperty('video');
if ($videoProp) {
SJB_UploadFileManager::deleteUploadedFileByID($videoProp->value);
}
// delete social info
$socialReference = SJB_SocialPlugin::getProfileSocialID($user->getSID());
if ($socialReference) {
SJB_SocialPlugin::deleteProfileSocialInfoByReference($socialReference);
}
$result = SJB_UserDBManager::deleteUserById($id) && SJB_ContractManager::deleteAllContractsByUserSID($id) && SJB_Rating::deleteRatingByUserSID($id);
SJB_Cache::getInstance()->clean('matchingAnyTag', array(SJB_Cache::TAG_USERS));
return $result && SJB_SavedSearches::deleteUserSearchesFromDB($id);
}
public function execute()
{
$acl = SJB_Acl::getInstance();
$type = SJB_Request::getVar('type', '');
$role = SJB_Request::getVar('role', '');
$tp = SJB_System::getTemplateProcessor();
$resources = $acl->getResources();
$form_submitted = SJB_Request::getVar('action');
if ($form_submitted) {
SJB_Acl::clearPermissions($type, $role);
foreach ($resources as $name => $resource) {
$params = SJB_Request::getVar($name . '_params');
$message = '';
if (SJB_Request::getVar($name) == 'deny') {
$params = SJB_Request::getVar($name . '_params1');
if ($params == 'message') {
$message = SJB_Request::getVar($name . '_message');
}
}
SJB_Acl::allow($name, $type, $role, SJB_Request::getVar($name, ''), $params, SJB_Request::getVar($name . '_message'));
}
if ($type == 'plan' && SJB_Request::getVar('update_users', 0) == 1) {
$contracts = SJB_ContractManager::getAllContractsByMemebershipPlanSID($role);
foreach ($contracts as $contract_id) {
SJB_Acl::clearPermissions('contract', $contract_id['id']);
SJB_DB::query("insert into `permissions` (`type`, `role`, `name`, `value`, `params`, `message`)" . " select 'contract', ?s, `name`, `value`, `params`, `message` from `permissions` " . " where `type` = 'plan' and `role` = ?s", $contract_id['id'], $role);
}
}
if ($form_submitted == 'save') {
switch ($type) {
case 'group':
$parameter = "/edit-user-group/?sid=" . $role;
break;
case 'guest':
$parameter = "/user-groups/";
break;
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . $parameter);
}
}
$acl = SJB_Acl::getInstance(true);
$resources = $acl->getResources($type);
$perms = SJB_DB::query('select * from `permissions` where `type` = ?s and `role` = ?s', $type, $role);
foreach ($resources as $key => $resource) {
$resources[$key]['value'] = 'inherit';
$resources[$key]['name'] = $key;
foreach ($perms as $perm) {
if ($key == $perm['name']) {
$resources[$key]['value'] = $perm['value'];
$resources[$key]['params'] = $perm['params'];
$resources[$key]['message'] = $perm['message'];
break;
}
}
}
$tp->assign('resources', $resources);
$tp->assign('type', $type);
$tp->assign('listingTypes', SJB_ListingTypeManager::getAllListingTypesInfo());
$tp->assign('role', $role);
switch ($type) {
case 'group':
$tp->assign('userGroupInfo', SJB_UserGroupManager::getUserGroupInfoBySID($role));
break;
case 'user':
$userInfo = SJB_UserManager::getUserInfoBySID($role);
$tp->assign('userGroupInfo', SJB_UserGroupManager::getUserGroupInfoBySID($userInfo['user_group_sid']));
break;
}
$tp->display('acl.tpl');
}
public function execute()
{
if (!function_exists('_filter_data')) {
function _filter_data(&$array, $key, $pattern)
{
if (isset($array[$key])) {
if (!preg_match($pattern, $array[$key])) {
unset($array[$key]);
}
}
}
}
_filter_data($_REQUEST, 'sorting_field', "/^[_\\w\\d]+\$/");
_filter_data($_REQUEST, 'sorting_order', "/(^DESC\$)|(^ASC\$)/i");
_filter_data($_REQUEST, 'default_sorting_field', "/^[_\\w\\d]+\$/");
_filter_data($_REQUEST, 'default_sorting_order', "/(^DESC\$)|(^ASC\$)/i");
$tp = SJB_System::getTemplateProcessor();
if (!SJB_UserManager::isUserLoggedIn()) {
$errors['NOT_LOGGED_IN'] = true;
$tp->assign("ERRORS", $errors);
$tp->display("error.tpl");
return;
}
$this->defineRequestedListingTypeID();
if (!$this->listingTypeID) {
$tp->assign('listingTypes', SJB_ListingTypeManager::getAllListingTypesInfo());
$tp->display('my_available_listing_types.tpl');
return;
}
$this->listingTypeSID = SJB_ListingTypeManager::getListingTypeSIDByID($this->listingTypeID);
if (!$this->listingTypeSID) {
SJB_HelperFunctions::redirect(SJB_HelperFunctions::getSiteUrl() . '/my-listings/');
return;
}
$currentUser = SJB_UserManager::getCurrentUser();
$userSID = $currentUser->getSID();
$this->requestCriteria = array('user_sid' => array('equal' => $userSID), 'listing_type_sid' => array('equal' => $this->listingTypeSID));
$acl = SJB_Acl::getInstance();
if ($currentUser->isSubuser()) {
$subUserInfo = $currentUser->getSubuserInfo();
if (!$acl->isAllowed('subuser_manage_listings', $subUserInfo['sid'])) {
$this->requestCriteria['subuser_sid'] = array('equal' => $subUserInfo['sid']);
}
}
SJB_ListingManager::deletePreviewListingsByUserSID($userSID);
$searcher = new SJB_ListingSearcher();
// to save criteria in the session different from search_results
$criteriaSaver = new SJB_ListingCriteriaSaver('MyListings');
if (isset($_REQUEST['restore'])) {
$_REQUEST = array_merge($_REQUEST, $criteriaSaver->getCriteria());
}
if (isset($_REQUEST['listings'])) {
$listingsSIDs = $_REQUEST['listings'];
if (isset($_REQUEST['action_deactivate'])) {
$this->executeAction($listingsSIDs, 'deactivate');
} elseif (isset($_REQUEST['action_activate'])) {
$redirectToShoppingCard = false;
$activatedListings = array();
foreach ($listingsSIDs as $listingSID => $value) {
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingSID);
$productInfo = !empty($listingInfo['product_info']) ? unserialize($listingInfo['product_info']) : array();
if ($listingInfo['active']) {
continue;
} else {
if (SJB_ListingManager::getIfListingHasExpiredBySID($listingSID) && isset($productInfo['renewal_price']) && $productInfo['renewal_price'] > 0) {
$redirectToShoppingCard = true;
$listingTypeId = SJB_ListingTypeManager::getListingTypeIDBySID($listingInfo['listing_type_sid']);
$newProductName = "Reactivation of \"{$listingInfo['Title']}\" {$listingTypeId}";
$newProductInfo = SJB_ShoppingCart::createInfoForCustomProduct($userSID, $productInfo['product_sid'], $listingSID, $productInfo['renewal_price'], $newProductName, 'activateListing');
SJB_ShoppingCart::createCustomProduct($newProductInfo, $userSID);
} else {
if ($listingInfo['checkouted'] == 0) {
$redirectToShoppingCard = true;
} else {
if (SJB_ListingManager::activateListingBySID($listingSID, false)) {
$listing = SJB_ListingManager::getObjectBySID($listingSID);
SJB_Notifications::sendUserListingActivatedLetter($listing, $listing->getUserSID());
$activatedListings[] = $listingSID;
}
}
}
}
}
SJB_BrowseDBManager::addListings($activatedListings);
if ($redirectToShoppingCard) {
$shoppingUrl = SJB_System::getSystemSettings('SITE_URL') . '/shopping-cart/';
SJB_HelperFunctions::redirect($shoppingUrl);
}
} else {
if (isset($_REQUEST['action_delete'])) {
$this->executeAction($listingsSIDs, 'delete');
$allowedPostBeforeCheckout = SJB_Settings::getSettingByName('allow_to_post_before_checkout');
foreach ($listingsSIDs as $listingSID => $value) {
if ($allowedPostBeforeCheckout == true) {
$this->deleteCheckoutedListingFromShopCart($listingSID, $userSID);
}
}
} elseif (isset($_REQUEST['action_sendToApprove'])) {
$processListingsIds = array();
foreach ($listingsSIDs as $listingSID => $value) {
$processListingsIds[] = $listingSID;
}
SJB_ListingManager::setListingApprovalStatus($processListingsIds, 'pending');
}
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/my-listings/{$this->listingTypeID}/");
}
$listing = new SJB_Listing(array(), $this->listingTypeSID);
$idAliasInfo = $listing->addIDProperty();
$listing->addActivationDateProperty();
$listing->addKeywordsProperty();
$listing->addPicturesProperty();
$listingTypeIdAliasInfo = $listing->addListingTypeIDProperty();
$sortingFields = array();
$innerJoin = array();
$sortingField = SJB_Request::getVar("sorting_field", null);
$sortingOrder = SJB_Request::getVar("sorting_order", null);
if (isset($sortingField, $sortingOrder)) {
$orderInfo = array('sorting_field' => $sortingField, 'sorting_order' => $sortingOrder);
} else {
$orderInfo = $criteriaSaver->getOrderInfo();
}
if ($orderInfo['sorting_field'] == 'applications') {
$innerJoin['applications'] = array('count' => 'count(`applications`.id) as appCount', 'join' => 'LEFT JOIN', 'join_field' => 'listing_id', 'join_field2' => 'sid', 'main_table' => 'listings');
$sortingFields['appCount'] = $orderInfo['sorting_order'];
$searcher->setGroupByField(array('listings' => 'sid'));
} else {
if ($orderInfo['sorting_field'] == 'id') {
$sortingFields['sid'] = $orderInfo['sorting_order'];
} else {
if ($orderInfo['sorting_field'] == 'subuser_sid') {
$innerJoin['users'] = array('join' => 'LEFT JOIN', 'join_field' => 'sid', 'join_field2' => 'subuser_sid', 'main_table' => 'listings');
$sortingFields['username'] = $orderInfo['sorting_order'];
} else {
$property = $listing->getProperty($sortingField);
if (!empty($property) && $property->isSystem()) {
$sortingFields[$orderInfo['sorting_field']] = $orderInfo['sorting_order'];
} else {
$sortingFields['activation_date'] = 'DESC';
}
}
}
}
$this->requestCriteria['sorting_field'] = $orderInfo['sorting_field'];
$this->requestCriteria['sorting_order'] = $orderInfo['sorting_order'];
$criteria = SJB_SearchFormBuilder::extractCriteriaFromRequestData(array_merge($_REQUEST, $this->requestCriteria), $listing);
$aliases = new SJB_PropertyAliases();
$aliases->addAlias($idAliasInfo);
$aliases->addAlias($listingTypeIdAliasInfo);
$foundListingsSIDs = $searcher->getObjectsSIDsByCriteria($criteria, $aliases, $sortingFields, $innerJoin);
$searchFormBuilder = new SJB_SearchFormBuilder($listing);
$searchFormBuilder->registerTags($tp);
$searchFormBuilder->setCriteria($criteria);
// получим информацию о имеющихся листингах
$listingsInfo = array();
$currentUserInfo = SJB_UserManager::getCurrentUserInfo();
$contractInfo['extra_info']['listing_amount'] = 0;
if ($acl->isAllowed('post_' . $this->listingTypeID)) {
$permissionParam = $acl->getPermissionParams('post_' . $this->listingTypeID);
if (empty($permissionParam)) {
$contractInfo['extra_info']['listing_amount'] = 'unlimited';
} else {
$contractInfo['extra_info']['listing_amount'] = $permissionParam;
}
}
$currentUser = SJB_UserManager::getCurrentUser();
$contractsSIDs = $currentUser->getContractID();
$listingsInfo['listingsNum'] = SJB_ContractManager::getListingsNumberByContractSIDsListingType($contractsSIDs, $this->listingTypeID);
$listingsInfo['listingsMax'] = $contractInfo['extra_info']['listing_amount'];
if ($listingsInfo['listingsMax'] === 'unlimited') {
$listingsInfo['listingsLeft'] = 'unlimited';
} else {
$listingsInfo['listingsLeft'] = $listingsInfo['listingsMax'] - $listingsInfo['listingsNum'];
$listingsInfo['listingsLeft'] = $listingsInfo['listingsLeft'] < 0 ? 0 : $listingsInfo['listingsLeft'];
}
$tp->assign('listingTypeID', $this->listingTypeID);
$tp->assign('listingTypeName', SJB_ListingTypeManager::getListingTypeNameBySID($this->listingTypeSID));
$tp->assign('listingsInfo', $listingsInfo);
$tp->display('my_listings_form.tpl');
$page = SJB_Request::getVar('page', 1);
$listingsPerPage = $criteriaSaver->getListingsPerPage();
//save 'listings per page' in the session
if (empty($listingsPerPage)) {
$listingsPerPage = 10;
}
$listingsPerPage = SJB_Request::getVar('listings_per_page', $listingsPerPage);
$criteriaSaver->setSessionForListingsPerPage($listingsPerPage);
$criteriaSaver->setSessionForCurrentPage($page);
$criteriaSaver->setSessionForCriteria($_REQUEST);
$criteriaSaver->setSessionForOrderInfo($orderInfo);
$criteriaSaver->setSessionForObjectSIDs($foundListingsSIDs);
// get Applications
$appsGroups = SJB_Applications::getAppGroupsByEmployer($currentUserInfo['sid']);
$apps = array();
foreach ($appsGroups as $group) {
$apps[$group['listing_id']] = $group['count'];
}
$searchCriteriaStructure = $criteriaSaver->createTemplateStructureForCriteria();
$listingSearchStructure = $criteriaSaver->createTemplateStructureForSearch();
/**************** P A G I N G *****************/
if ($listingSearchStructure['current_page'] > $listingSearchStructure['pages_number']) {
$listingSearchStructure['current_page'] = $listingSearchStructure['pages_number'];
}
if ($listingSearchStructure['current_page'] < 1) {
$listingSearchStructure['current_page'] = 1;
}
$sortedFoundListingsSIDsByPages = array_chunk($foundListingsSIDs, $listingSearchStructure['listings_per_page'], true);
/************* S T R U C T U R E **************/
$listingsStructure = array();
$listingStructureMetaData = array();
if (isset($sortedFoundListingsSIDsByPages[$listingSearchStructure['current_page'] - 1])) {
foreach ($sortedFoundListingsSIDsByPages[$listingSearchStructure['current_page'] - 1] as $sid) {
$listing = SJB_ListingManager::getObjectBySID($sid);
$listing->addPicturesProperty();
$listingStructure = SJB_ListingManager::createTemplateStructureForListing($listing);
$listingsStructure[$listing->getID()] = $listingStructure;
if (isset($listingStructure['METADATA'])) {
$listingStructureMetaData = array_merge($listingStructureMetaData, $listingStructure['METADATA']);
}
}
}
/*************** D I S P L A Y ****************/
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$metadata = array();
$metadata['listing'] = $metaDataProvider->getMetaData($listingStructureMetaData);
$waitApprove = SJB_ListingTypeManager::getWaitApproveSettingByListingType($this->listingTypeSID);
$tp->assign('show_rates', SJB_Settings::getSettingByName('show_rates'));
$tp->assign('show_comments', SJB_Settings::getSettingByName('show_comments'));
$tp->assign('METADATA', $metadata);
$tp->assign('sorting_field', $listingSearchStructure['sorting_field']);
$tp->assign('sorting_order', $listingSearchStructure['sorting_order']);
$tp->assign('property', $this->getSortableProperties());
$tp->assign('listing_search', $listingSearchStructure);
$tp->assign('search_criteria', $searchCriteriaStructure);
$tp->assign('listings', $listingsStructure);
$tp->assign('waitApprove', $waitApprove);
$tp->assign('apps', $apps);
$hasSubusersWithListings = false;
$subusers = SJB_UserManager::getSubusers($currentUserInfo['sid']);
foreach ($subusers as $subuser) {
if ($acl->isAllowed('subuser_add_listings', $subuser['sid']) || $acl->isAllowed('subuser_manage_listings', $subuser['sid'])) {
$hasSubusersWithListings = true;
break;
}
}
$tp->assign('hasSubusersWithListings', $hasSubusersWithListings);
$tp->display('my_listings.tpl');
}
function hasContract()
{
$contract_info = SJB_ContractManager::getAllContractsInfoByUserSID($this->sid);
return !empty($contract_info);
}
public function execute()
{
$this->redirectToListingByKeywords();
// SEO friendly URL for company profile
$m = array();
$isCompanyProfilePage = false;
if (preg_match('#/company/([0-9]+)/.*#', SJB_Navigator::getURI(), $m)) {
$isCompanyProfilePage = true;
$params = SJB_FixedUrlParamProvider::getParams($_REQUEST);
if (!empty($params)) {
$aliasUsername = SJB_UserManager::getUserNameByUserSID($m[1]);
if (!empty($aliasUsername)) {
$_REQUEST['username']['equal'] = $aliasUsername;
$_REQUEST['anonymous']['equal'] = 0;
}
}
}
if (!empty($_REQUEST['username']['equal']) && is_int($_REQUEST['username']['equal'])) {
$aliasUsername = SJB_UserManager::getUserNameByUserSID(intval($_REQUEST['username']['equal']));
if (!empty($aliasUsername)) {
$_REQUEST['username']['equal'] = $aliasUsername;
}
}
$listingTypeId = SJB_Request::getVar('listing_type_id', 0);
if (!$listingTypeId) {
$listingTypeId = isset($_REQUEST['listing_type']['equal']) ? $_REQUEST['listing_type']['equal'] : SJB_Session::getValue('listing_type_id');
}
if ($listingTypeId) {
$_REQUEST['listing_type']['equal'] = $listingTypeId;
}
$action = SJB_Request::getVar('action', 'search');
//XSS defense
$searchId = SJB_Request::getVar('searchId', false);
if ($searchId && !is_numeric($searchId)) {
$_REQUEST['searchId'] = false;
}
$request = $_REQUEST;
if (SJB_System::getSettingByName('turn_on_refine_search_' . $listingTypeId)) {
switch ($action) {
case 'refine':
$searchID = SJB_Request::getVar('searchId', false);
unset($request['searchId']);
$criteria_saver = new SJB_ListingCriteriaSaver($searchID);
$request = SJB_RefineSearch::mergeCriteria($criteria_saver->getCriteria(), $request);
break;
case 'undo':
$param = SJB_Request::getVar('param', false);
$field_type = SJB_Request::getVar('type', false);
$value = SJB_Request::getVar('value', false);
if ($param && $field_type && $value) {
$searchID = SJB_Request::getVar('searchId', false);
unset($request['searchId']);
$criteria_saver = new SJB_ListingCriteriaSaver($searchID);
$criteria = $criteria_saver->criteria;
if (isset($criteria[$param][$field_type])) {
switch ($field_type) {
case 'geo':
if ($criteria[$param][$field_type]['location'] == $value) {
unset($criteria[$param]);
}
break;
case 'monetary':
if ($criteria[$param][$field_type]['not_less'] == $value) {
$criteria[$param][$field_type]['not_less'] = "";
}
if ($criteria[$param][$field_type]['not_more'] == $value) {
$criteria[$param][$field_type]['not_more'] = "";
}
break;
case 'tree':
// search params incoming as string, where params separated by ','
// we need to undo one of them
$params = explode(',', $criteria[$param][$field_type]);
$params = array_flip($params);
unset($params[$value]);
$params = array_flip($params);
$criteria[$param][$field_type] = implode(',', $params);
break;
default:
if (is_array($criteria[$param][$field_type])) {
foreach ($criteria[$param][$field_type] as $key => $val) {
if ($val == $value) {
unset($criteria[$param][$field_type][$key]);
}
}
} else {
unset($criteria[$param]);
}
break;
}
}
$criteria['default_sorting_field'] = $request['default_sorting_field'];
$criteria['default_sorting_order'] = $request['default_sorting_order'];
$criteria['default_listings_per_page'] = $request['default_listings_per_page'];
$criteria['results_template'] = $request['results_template'];
$request = array_merge($criteria, $request);
}
break;
}
}
$searchResultsTP = new SJB_SearchResultsTP($request, $listingTypeId, false, true);
$searchResultsTP->usePriority(true);
$template = SJB_Request::getVar("results_template", "search_results.tpl");
$allowViewContactInfo = false;
if (!empty($_REQUEST['username']['equal'])) {
$pageID = 'contact_info';
$username = $_REQUEST['username']['equal'];
if (SJB_UserManager::isUserLoggedIn()) {
$current_user = SJB_UserManager::getCurrentUser();
if (SJB_ContractManager::isPageViewed($current_user->getSID(), $pageID, $username) || $this->acl->isAllowed('view_' . $listingTypeId . '_contact_info') && in_array($this->acl->getPermissionParams('view_' . $listingTypeId . '_contact_info'), array('', '0'))) {
$allowViewContactInfo = true;
} elseif ($this->acl->isAllowed('view_' . $listingTypeId . '_contact_info')) {
$viewContactInfo['count_views'] = 0;
$contractIDs = $current_user->getContractID();
$numberOfContactViewed = SJB_ContractManager::getNumbeOfPagesViewed($current_user->getSID(), $contractIDs, $pageID);
foreach ($contractIDs as $contractID) {
if ($this->acl->getPermissionParams('view_' . $listingTypeId . '_contact_info', $contractID, 'contract')) {
$params = $this->acl->getPermissionParams('view_' . $listingTypeId . '_contact_info', $contractID, 'contract');
if (isset($viewContactInfo['count_views'])) {
$viewContactInfo['count_views'] += $params;
$viewContactInfo['contract_id'] = $contractID;
}
}
}
if ($viewContactInfo && $viewContactInfo['count_views'] > $numberOfContactViewed) {
$allowViewContactInfo = true;
SJB_ContractManager::addViewPage($current_user->getSID(), $pageID, $username, $viewContactInfo['contract_id']);
}
}
} elseif ($this->acl->isAllowed('view_' . $listingTypeId . '_contact_info')) {
$allowViewContactInfo = true;
}
}
$tp = $searchResultsTP->getChargedTemplateProcessor();
SJB_Statistics::addSearchStatistics($searchResultsTP->getListingSidCollectionForCurrentPage(), $listingTypeId);
$userForm = null;
if ($isCompanyProfilePage) {
$user = SJB_UserManager::getObjectBySID(intval($m[1]));
$userForm = new SJB_Form($user);
$userForm->registerTags($tp);
}
$errors = array();
if (!empty($searchResultsTP->pluginErrors)) {
foreach ($searchResultsTP->pluginErrors as $err) {
$errors[] = $err;
}
}
$tp->assign('errors', $errors);
$tp->assign('is_company_profile_page', $isCompanyProfilePage);
$tp->assign("listing_type_id", $listingTypeId);
$tp->assign('allowViewContactInfo', $allowViewContactInfo);
if ($userForm) {
$tp->assign('form_fields', $userForm->getFormFieldsInfo());
}
$tp->display($template);
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$bannersObj = new SJB_Banners();
$errors = array();
$groupSID = SJB_Request::getVar('groupSID', false);
$form_submitted = SJB_Request::getVar('submit');
if (isset($_REQUEST['action'])) {
$action_name = $_REQUEST['action'];
$params = $_REQUEST;
switch ($action_name) {
case 'edit':
if ($params['groupID'] == '') {
$errors[] = 'GROUP_ID_MISMATCHED';
}
if ($groupSID === false) {
$errors[] = 'BANNER_GROUP_SID_NOT_DEFINED';
}
if ($errors) {
break;
}
$result = $bannersObj->updateBannerGroup($params['groupSID'], $params['groupID'], $params['number_banners_display_at_once']);
if ($result === false) {
$errors[] = 'ERROR_UPDATE_BANNER_GROUP';
break;
}
if ($form_submitted == 'save_banner') {
$site_url = SJB_System::getSystemsettings('SITE_URL') . '/manage-banner-groups/';
SJB_HelperFunctions::redirect($site_url);
}
break;
case 'delete_banner':
if (!isset($params['bannerId'])) {
$banners_sids = SJB_Request::getVar('banners', false);
if (count($banners_sids) > 0) {
$keys = array_keys($banners_sids);
$groupSID = $bannersObj->getBannerGroupSIDByBannerSID($keys[0]);
foreach ($banners_sids as $b_sid => $keys) {
$deleteBanner = $bannersObj->deleteBanner($b_sid);
if ($deleteBanner === false) {
$errors[] = $bannersObj->bannersError;
}
}
}
} else {
$groupSID = $bannersObj->getBannerGroupSIDByBannerSID($params['bannerId']);
$deleteBanner = $bannersObj->deleteBanner($params['bannerId']);
if ($deleteBanner === false) {
$errors[] = $bannersObj->bannersError;
break;
}
}
$site_url = SJB_System::getSystemsettings('SITE_URL') . '/edit-banner-group/?groupSID=' . $groupSID;
SJB_HelperFunctions::redirect($site_url);
break;
case 'activate':
$banners_sids = SJB_Request::getVar('banners', false);
if ($banners_sids) {
$keys = array_keys($banners_sids);
$groupSID = $bannersObj->getBannerGroupSIDByBannerSID($keys[0]);
foreach ($banners_sids as $b_sid => $keys) {
$deleteBanner = $bannersObj->updateActiveStatus($b_sid, true);
if ($deleteBanner === false) {
$errors[] = 'Can\'t activate banner. ID: ' . $b_sid;
}
}
}
break;
case 'deactivate':
$banners_sids = SJB_Request::getVar('banners', false);
if ($banners_sids) {
$keys = array_keys($banners_sids);
$groupSID = $bannersObj->getBannerGroupSIDByBannerSID($keys[0]);
foreach ($banners_sids as $b_sid => $keys) {
$deleteBanner = $bannersObj->updateActiveStatus($b_sid, false);
if ($deleteBanner === false) {
$errors[] = 'Can\'t deactivate banner. ID: ' . $b_sid;
}
}
}
break;
case 'approve':
$banners_sids = SJB_Request::getVar('banners', false);
if ($banners_sids) {
$keys = array_keys($banners_sids);
$groupSID = $bannersObj->getBannerGroupSIDByBannerSID($keys[0]);
foreach ($banners_sids as $b_sid => $keys) {
$bannerInfo = $bannersObj->getBannerProperties($b_sid);
$contractSID = !empty($bannerInfo['contract_sid']) ? $bannerInfo['contract_sid'] : false;
$approveBanner = $bannersObj->updateStatus($b_sid, 'approved');
if ($approveBanner === false) {
$errors[] = 'Can\'t approved banner. ID: ' . $b_sid;
} else {
$bannersObj->updateActiveStatus($b_sid, true);
if ($contractSID) {
SJB_ContractManager::updateExpirationPeriod($contractSID);
}
}
}
}
break;
case 'reject':
$banners_sids = SJB_Request::getVar('banners', false);
if ($banners_sids) {
$keys = array_keys($banners_sids);
$groupSID = $bannersObj->getBannerGroupSIDByBannerSID($keys[0]);
$reject = SJB_Request::getVar('rejection_reason', '');
foreach ($banners_sids as $b_sid => $keys) {
$approveBanner = $bannersObj->updateStatus($b_sid, 'rejected');
if ($approveBanner === false) {
$errors[] = 'Can\'t rejected banner. ID: ' . $b_sid;
} else {
$bannersObj->updateActiveStatus($b_sid, false);
if ($bannersObj->getBannerUserSID($b_sid)) {
$bannerInfo = $bannersObj->getBannerProperties($b_sid);
SJB_Notifications::sendBannerRejectedLetter($bannerInfo, $bannersObj->getBannerUserSID($b_sid), $reject);
}
}
}
}
break;
}
}
$bannerGroup = $bannersObj->getBannerGroupBySID($groupSID);
$banners = $bannersObj->getBannersByGroupSID($groupSID);
$tp->assign('form_submitted', $form_submitted);
$tp->assign('bannerGroup', $bannerGroup);
$tp->assign('errors', $errors);
$tp->display('edit_banner_group.tpl');
$tp->assign('banners', $banners);
$tp->assign('bannersPath', SJB_Banners::getSiteUrl());
$tp->display('manage_banners.tpl');
}
private function runTaskScheduler()
{
// Deactivate Expired Listings & Send Notifications
$listingsExpiredID = SJB_ListingManager::getExpiredListingsSID();
foreach ($listingsExpiredID as $listingExpiredID) {
SJB_ListingManager::deactivateListingBySID($listingExpiredID, true);
$listing = SJB_ListingManager::getObjectBySID($listingExpiredID);
$listingInfo = SJB_ListingManager::createTemplateStructureForListing($listing);
if (SJB_UserNotificationsManager::isUserNotifiedOnListingExpiration($listing->getUserSID())) {
SJB_Notifications::sendUserListingExpiredLetter($listingInfo);
}
// notify admin
SJB_AdminNotifications::sendAdminListingExpiredLetter($listingInfo);
}
$listingsDeactivatedID = array();
if (SJB_Settings::getSettingByName('automatically_delete_expired_listings')) {
$listingsDeactivatedID = SJB_ListingManager::getDeactivatedListingsSID();
foreach ($listingsDeactivatedID as $listingID) {
SJB_ListingManager::deleteListingBySID($listingID);
}
}
SJB_ListingManager::unFeaturedListings();
SJB_ListingManager::unPriorityListings();
SJB_Cache::getInstance()->clean('matchingAnyTag', array(SJB_Cache::TAG_LISTINGS));
/////////////////////////// Send remind notifications about expiration of LISTINGS
// 1. get user sids and days count of 'remind listing notification' setting = 1 from user_notifications table
// 2. foreach user:
// - get listings with that expiration remind date
// - check every listing sid in DB table of sended. If sended - remove from send list
// - send notification with listings to user
// - write listings sid in DB table of sended notifications
$notificationData = SJB_UserNotificationsManager::getUsersAndDaysOnListingExpirationRemind();
foreach ($notificationData as $elem) {
$userSID = $elem['user_sid'];
$days = $elem['days'];
$listingSIDs = SJB_ListingManager::getListingsIDByDaysLeftToExpired($userSID, $days);
if (empty($listingSIDs)) {
continue;
}
$listingsInfo = array();
// check listings remind sended
foreach ($listingSIDs as $key => $sid) {
if (SJB_ListingManager::isListingNotificationSended($sid)) {
unset($listingSIDs[$key]);
continue;
}
$info = SJB_ListingManager::getListingInfoBySID($sid);
$listingsInfo[$sid] = $info;
}
if (!empty($listingsInfo)) {
// now only unsended listings we have in array
// send listing notification
foreach ($listingSIDs as $sid) {
SJB_Notifications::sendRemindListingExpirationLetter($userSID, $sid, $days);
}
// write listing id in DB table of sended notifications
SJB_ListingManager::saveListingIDAsSendedNotificationsTable($listingSIDs);
}
}
// Send Notifications for Expired Contracts
$contractsExpiredID = SJB_ContractManager::getExpiredContractsID();
foreach ($contractsExpiredID as $contractExpiredID) {
$contractInfo = SJB_ContractManager::getInfo($contractExpiredID);
$productInfo = SJB_ProductsManager::getProductInfoBySID($contractInfo['product_sid']);
$userInfo = SJB_UserManager::getUserInfoBySID($contractInfo['user_sid']);
$serializedExtraInfo = unserialize($contractInfo['serialized_extra_info']);
if (!empty($serializedExtraInfo['featured_profile']) && !empty($userInfo['featured'])) {
$contracts = SJB_ContractManager::getAllContractsInfoByUserSID($userInfo['sid']);
$isFeatured = 0;
foreach ($contracts as $contract) {
if ($contract['id'] != $contractExpiredID) {
$serializedExtraInfo = unserialize($contract['serialized_extra_info']);
if (!empty($serializedExtraInfo['featured'])) {
$isFeatured = 1;
}
}
}
if (!$isFeatured) {
SJB_UserManager::removeFromFeaturedBySID($userInfo['sid']);
}
}
if (SJB_UserNotificationsManager::isUserNotifiedOnContractExpiration($contractInfo['user_sid'])) {
SJB_Notifications::sendUserContractExpiredLetter($userInfo, $contractInfo, $productInfo);
}
// notify admin
SJB_AdminNotifications::sendAdminUserContractExpiredLetter($userInfo['sid'], $contractInfo, $productInfo);
SJB_ContractManager::deleteContract($contractExpiredID, $contractInfo['user_sid']);
}
//////////////////////// Send remind notifications about expiration of contracts
// 1. get user sids and days count of 'remind subscription notification' setting = 1 from user_notifications table
// 2. foreach user:
// - get contracts with that expiration remind date
// - check every contract sid in DB table of sended. If sended - remove from send list
// - send notification with contracts to user
// - write contract sid in DB table of sended contract notifications
$notificationData = SJB_UserNotificationsManager::getUsersAndDaysOnSubscriptionExpirationRemind();
foreach ($notificationData as $elem) {
$userSID = $elem['user_sid'];
$days = $elem['days'];
$contractSIDs = SJB_ContractManager::getContractsIDByDaysLeftToExpired($userSID, $days);
if (empty($contractSIDs)) {
continue;
}
$contractsInfo = array();
// check contracts sended
foreach ($contractSIDs as $key => $sid) {
if (SJB_ContractManager::isContractNotificationSended($sid)) {
unset($contractSIDs[$key]);
continue;
}
$info = SJB_ContractManager::getInfo($sid);
$info['extra_info'] = !empty($info['serialized_extra_info']) ? unserialize($info['serialized_extra_info']) : '';
$contractsInfo[$sid] = $info;
}
if (!empty($contractsInfo)) {
// now only unsended contracts we have in array
// send contract notification
foreach ($contractSIDs as $sid) {
SJB_Notifications::sendRemindSubscriptionExpirationLetter($userSID, $contractsInfo[$sid], $days);
}
// write contract id in DB table of sended contract notifications
SJB_ContractManager::saveContractIDAsSendedNotificationsTable($contractSIDs);
}
}
// delete applications with no employer and job seeker
$emptyApplications = SJB_DB::query('SELECT `id` FROM `applications` WHERE `show_js` = 0 AND `show_emp` = 0');
foreach ($emptyApplications as $application) {
SJB_Applications::remove($application['id']);
}
// NEWS
$expiredNews = SJB_NewsManager::getExpiredNews();
foreach ($expiredNews as $article) {
SJB_NewsManager::deactivateItemBySID($article['sid']);
}
// LISTING XML IMPORT
SJB_XmlImport::runImport();
// UPDATE PAGES WITH FUNCTION EQUAL BROWSE(e.g. /browse-by-city/)
SJB_BrowseDBManager::rebuildBrowses();
//-------------------sitemap generator--------------------//
SJB_System::executeFunction('miscellaneous', 'sitemap_generator');
// CLEAR `error_log` TABLE
$errorLogLifetime = SJB_System::getSettingByName('error_log_lifetime');
$lifeTime = strtotime("-{$errorLogLifetime} days");
if ($lifeTime > 0) {
SJB_DB::query('DELETE FROM `error_log` WHERE `date` < ?t', $lifeTime);
}
SJB_Settings::updateSetting('task_scheduler_last_executed_date', $this->currentDate);
$this->tp->assign('expired_listings_id', $listingsExpiredID);
$this->tp->assign('deactivated_listings_id', $listingsDeactivatedID);
$this->tp->assign('expired_contracts_id', $contractsExpiredID);
$this->tp->assign('notified_saved_searches_id', $this->notifiedSavedSearchesSID);
$schedulerLog = $this->tp->fetch('task_scheduler_log.tpl');
SJB_HelperFunctions::writeCronLogFile('task_scheduler.log', $schedulerLog);
SJB_DB::query('INSERT INTO `task_scheduler_log`
(`last_executed_date`, `notifieds_sent`, `expired_listings`, `expired_contracts`, `log_text`)
VALUES ( NOW(), ?n, ?n, ?n, ?s)', count($this->notifiedSavedSearchesSID), count($listingsExpiredID), count($contractsExpiredID), $schedulerLog);
SJB_System::getModuleManager()->executeFunction('social', 'linkedin');
SJB_System::getModuleManager()->executeFunction('social', 'facebook');
SJB_System::getModuleManager()->executeFunction('classifieds', 'linkedin');
SJB_System::getModuleManager()->executeFunction('classifieds', 'facebook');
SJB_System::getModuleManager()->executeFunction('classifieds', 'twitter');
SJB_Event::dispatch('task_scheduler_run');
}
/**
* Можно ли?
* @param $resource
* @param $roleId
*/
public function isAllowed($resource, $roleId = null, $type = 'user', $returnParams = false, $returnMessage = false)
{
$resource = strtolower($resource);
$userInfo = array();
if (null === $roleId) {
// если не задан пользователь, то попробуем использовать текущего
$userInfo = SJB_UserManager::getCurrentUserInfo();
if (!empty($userInfo)) {
$roleId = $userInfo['sid'];
}
if (null === $roleId) {
if (SJB_Admin::admin_authed() && SJB_System::getSystemSettings('SYSTEM_ACCESS_TYPE') == 'admin') {
if ($returnParams) {
return '';
}
if ($returnMessage) {
return '';
}
return true;
}
$roleId = 'guest';
}
} else {
$cacheId = 'SJB_Acl::SJB_UserManager::getUserInfoBySID' . $roleId;
if (SJB_MemoryCache::has($cacheId)) {
$userInfo = SJB_MemoryCache::get($cacheId);
} else {
$userInfo = SJB_UserManager::getUserInfoBySID($roleId);
SJB_MemoryCache::set($cacheId, $userInfo);
}
}
$role = $type . '_' . $roleId;
if ($resource == 'use_screening_questionnaires' && intval($userInfo['parent_sid']) > 0) {
if ($this->isAllowed($resource, $userInfo['parent_sid'])) {
return $this->isAllowed('subuser_use_screening_questionnaires', $userInfo['sid']);
}
return false;
}
if (!isset($this->permissions[$role])) {
switch ($type) {
case 'user':
case 'guest':
if ($roleId == 'guest' || $type == 'guest') {
$role = 'user_guest';
if (empty($this->permissions[$role])) {
$this->permissions[$role] = $this->getPermissions('guest', 'guest');
}
} else {
$permissions = $this->getPermissions('user', $roleId);
$groupPermissions = $this->getPermissions('group', $userInfo['user_group_sid']);
$this->permissions['group_' . $userInfo['user_group_sid']] = $groupPermissions;
$contracts = SJB_ContractManager::getAllContractsSIDsByUserSID($roleId);
if (!empty($contracts)) {
foreach ($contracts as $contract) {
$contractPermissions = $this->mergePermissionsWithGroup($this->getPermissions('contract', $contract), $groupPermissions);
$this->permissions['contract_' . $contract] = $contractPermissions;
$permissions = $this->mergePermissions($contractPermissions, $permissions);
}
} else {
$permissions = $this->mergePermissionsWithGroup($permissions, $groupPermissions);
}
$this->permissions[$role] = $permissions;
}
break;
case 'group':
$this->permissions[$role] = $this->getPermissions($type, $roleId);
break;
case 'product':
$productInfo = SJB_ProductsManager::getProductInfoBySID($roleId);
if (!empty($productInfo['user_group_sid'])) {
$groupRole = 'group_' . $productInfo['user_group_sid'];
if (empty($this->permissions[$groupRole])) {
$this->permissions[$groupRole] = $this->getPermissions('group', $productInfo['user_group_sid']);
}
$this->permissions[$role] = $this->mergePermissionsWithGroup($this->getPermissions('product', $roleId), $this->permissions[$groupRole]);
} else {
$this->permissions[$role] = $this->getPermissions('product', $roleId);
}
break;
case 'contract':
$this->permissions[$role] = $this->getPermissions('contract', $roleId);
break;
}
}
if (!isset($userInfo)) {
$userInfo = SJB_UserManager::getCurrentUserInfo();
}
$is_display_resume = !preg_match_all("/.*\\/(?:display_resume|display_job)\\/(\\d*)/i", $_SERVER['REQUEST_URI'], $match) ? isset($_SERVER['REDIRECT_URL']) ? preg_match_all("/.*\\/(?:display_resume|display_job)\\/(\\d*)/i", $_SERVER['REDIRECT_URL'], $match) : false : true;
// Allow access to Resume/Job Details page if an employer has an application linked to the resume
if (isset($userInfo) && $is_display_resume) {
$apps = SJB_DB::query("SELECT `a`.resume FROM `applications` `a`\n\t\t\t\t\t\t INNER JOIN `listings` l ON\n\t\t\t\t\t\t `l`.`sid` = `a`.`listing_id`\n\t\t\t\t\t\t WHERE `l`.`user_sid` = ?n AND `a`.`show_emp` = 1 ORDER BY a.`date` DESC", $userInfo['sid']);
if (isset($match[1]) && in_array(array("resume" => array_pop($match[1])), $apps)) {
$this->permissions[$role][$resource]['value'] = 'allow';
$this->permissions[$role][$resource]['params'] = '';
}
}
if ($returnParams) {
return empty($this->permissions[$role][$resource]['params']) ? '' : $this->permissions[$role][$resource]['params'];
} elseif ($returnMessage) {
$message = empty($this->permissions[$role][$resource]['message']) ? '' : $this->permissions[$role][$resource]['message'];
if (!$message) {
if (!empty($userInfo)) {
$groupRole = 'group_' . $userInfo['user_group_sid'];
$message = empty($this->permissions[$groupRole][$resource]['message']) ? '' : $this->permissions[$groupRole][$resource]['message'];
}
}
return $message;
}
return isset($this->permissions[$role][$resource]['value']) && $this->permissions[$role][$resource]['value'] == 'allow';
}
public static function isUserAccessThisPage()
{
$pageID = SJB_PageManager::getPageParentURI(SJB_Navigator::getURI(), SJB_System::getSystemSettings('SYSTEM_ACCESS_TYPE'), false);
$access = true;
$currentUser = SJB_UserManager::getCurrentUser();
if (!is_null($currentUser)) {
$access = false;
$queryParam = '';
$listingId = SJB_Request::getVar("listing_id", false);
$passedParametersViaUri = SJB_Request::getVar("passed_parameters_via_uri", false);
if (!$listingId && $passedParametersViaUri) {
$passedParametersViaUri = SJB_UrlParamProvider::getParams();
$listingId = isset($passedParametersViaUri[0]) ? $passedParametersViaUri[0] : '';
}
if ($listingId) {
$queryParam = " AND `param` = '" . SJB_DB::quote($listingId) . "' ";
}
$pageHasBeenVisited = SJB_DB::query("SELECT `param` FROM `page_view` WHERE `id_user` = ?s AND `id_pages` = ?s {$queryParam}", $currentUser->getSID(), $pageID);
if (!empty($queryParam) && $pageHasBeenVisited || strpos($pageID, 'print') !== false) {
$access = true;
} else {
$contractsId = $currentUser->getContractID();
$pageAccess = SJB_ContractManager::getPageAccessByUserContracts($contractsId, $pageID);
$numberOfPagesViewed = SJB_ContractManager::getNumbeOfPagesViewed($currentUser->getSID(), $contractsId, $pageID);
if (isset($pageAccess[$pageID]) && $pageAccess[$pageID]['count_views'] != '') {
if ($numberOfPagesViewed < $pageAccess[$pageID]['count_views']) {
$access = true;
}
if ($access === true) {
$listingTypeSID = null;
if (is_numeric($listingId)) {
$listingInfo = SJB_ListingManager::getListingInfoBySID($listingId);
if ($listingInfo) {
$listingTypeSID = $listingInfo['listing_type_sid'];
}
}
$availableContractId = '';
foreach ($contractsId as $contractId) {
$pageAccessByContract = SJB_ContractManager::getPageAccessByUserContracts(array($contractId), $pageID);
$viewsLeft = SJB_ContractManager::getNumbeOfPagesViewed($currentUser->getSID(), array($contractId), false, $listingTypeSID);
if (!empty($pageAccessByContract[$pageID]['count_views']) && $pageAccessByContract[$pageID]['count_views'] > $viewsLeft) {
$availableContractId = $contractId;
}
}
if (!empty($availableContractId)) {
SJB_DB::query("INSERT INTO page_view (`id_user` ,`id_pages`, `param`, `contract_id`, `listing_type_sid`) VALUES ( ?n, ?s, ?s, ?n, ?n)", $currentUser->getSID(), $pageID, $listingId, $availableContractId, $listingTypeSID);
} else {
$access = false;
}
}
} else {
$access = true;
}
}
}
return $access;
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
if (!SJB_UserManager::isUserLoggedIn()) {
$errors['NOT_LOGGED_IN'] = true;
$tp->assign("ERRORS", $errors);
$tp->display("../classifieds/error.tpl");
return;
}
if (SJB_Request::getVar('subscriptionComplete') == 'false') {
$this->errors['SUBSCRIPTION_IS_FAIL'] = 1;
}
$currentUser = SJB_UserManager::getCurrentUser();
$contractsInfo = SJB_ContractManager::getAllContractsInfoByUserSID($currentUser->getSID());
$cancelRecurringContract = SJB_Request::getVar('cancelRecurringContract', false);
if ($cancelRecurringContract) {
$tp->assign('cancelRecurringContractId', $cancelRecurringContract);
}
$listingTypes = SJB_ListingTypeManager::getAllListingTypesInfo();
$contractSIDs = array();
foreach ($contractsInfo as $key => $contractInfo) {
$contractInfo['extra_info'] = unserialize($contractInfo['serialized_extra_info']);
$contractInfo['avalaibleViews'] = array();
$contractInfo['avalaibleContactViews'] = array();
$contractInfo['listingAmount'] = array();
foreach ($listingTypes as $listingType) {
$listingTypeID = $listingType['id'];
if ($this->acl->isAllowed('view_' . $listingTypeID . '_details', $contractInfo['id'], 'contract')) {
$contractInfo['avalaibleViews'][$listingTypeID]['name'] = $listingType['name'];
$permissionParam = $this->acl->getPermissionParams('view_' . $listingTypeID . '_details', $contractInfo['id'], 'contract');
$contractInfo['avalaibleViews'][$listingTypeID]['numOfViews'] = SJB_ContractManager::getNumbeOfPagesViewed($currentUser->getSID(), array($contractInfo['id']), false, $listingType['sid']);
if (empty($permissionParam)) {
$contractInfo['avalaibleViews'][$listingTypeID]['count'] = 'unlimited';
$contractInfo['avalaibleViews'][$listingTypeID]['viewsLeft'] = 'unlimited';
} else {
$contractInfo['avalaibleViews'][$listingTypeID]['count'] = $permissionParam;
$contractInfo['avalaibleViews'][$listingTypeID]['viewsLeft'] = $permissionParam - $contractInfo['avalaibleViews'][$listingTypeID]['numOfViews'];
}
}
if ($this->acl->isAllowed('post_' . $listingTypeID, $contractInfo['id'], 'contract')) {
$contractInfo['listingAmount'][$listingTypeID]['name'] = $listingType['name'];
$permissionParam = $this->acl->getPermissionParams('post_' . $listingTypeID, $contractInfo['id'], 'contract');
$contractInfo['listingAmount'][$listingTypeID]['numPostings'] = $contractInfo['number_of_postings'];
if (empty($permissionParam)) {
$contractInfo['listingAmount'][$listingTypeID]['count'] = 'unlimited';
$contractInfo['listingAmount'][$listingTypeID]['listingsLeft'] = 'unlimited';
} else {
$contractInfo['listingAmount'][$listingTypeID]['count'] = $permissionParam;
$contractInfo['listingAmount'][$listingTypeID]['listingsLeft'] = max($contractInfo['listingAmount'][$listingTypeID]['count'] - $contractInfo['listingAmount'][$listingTypeID]['numPostings'], 0);
}
}
if ($this->acl->isAllowed('view_' . $listingTypeID . '_contact_info', $contractInfo['id'], 'contract')) {
$permissionParam = $this->acl->getPermissionParams('view_' . $listingTypeID . '_contact_info', $contractInfo['id'], 'contract');
$contractInfo['avalaibleContactViews'][$listingTypeID]['name'] = $listingType['name'];
$contractInfo['avalaibleContactViews'][$listingTypeID]['numOfViews'] = SJB_ContractManager::getNumbeOfPagesViewed($currentUser->getSID(), array($contractInfo['id']), 'view_' . $listingTypeID . '_contact_info');
if (empty($permissionParam)) {
$contractInfo['avalaibleContactViews'][$listingTypeID]['count'] = 'unlimited';
$contractInfo['avalaibleContactViews'][$listingTypeID]['viewsLeft'] = 'unlimited';
} else {
$contractInfo['avalaibleContactViews'][$listingTypeID]['count'] = $permissionParam;
$contractInfo['avalaibleContactViews'][$listingTypeID]['viewsLeft'] = $contractInfo['avalaibleContactViews'][$listingTypeID]['count'] - $contractInfo['avalaibleContactViews'][$listingTypeID]['numOfViews'];
}
}
}
$contractsInfo[$key] = $contractInfo;
$contractsInfo[$key]['product_info'] = SJB_ProductsManager::getProductInfoBySID($contractInfo['extra_info']['product_sid']);
$contractSIDs[] = $contractInfo['id'];
}
$statistics = array();
foreach ($listingTypes as $listingType) {
$listingTypeID = $listingType['id'];
if ($this->acl->isAllowed('view_' . $listingTypeID . '_details')) {
$statistics['avalaibleViews'][$listingTypeID]['name'] = $listingType['name'];
$permissionParam = $this->acl->getPermissionParams('view_' . $listingTypeID . '_details');
$statistics['avalaibleViews'][$listingTypeID]['numOfViews'] = SJB_ContractManager::getNumbeOfPagesViewed($currentUser->getSID(), $contractSIDs, false, $listingType['sid']);
if (empty($permissionParam)) {
$statistics['avalaibleViews'][$listingTypeID]['count'] = 'unlimited';
$statistics['avalaibleViews'][$listingTypeID]['viewsLeft'] = 'unlimited';
} else {
$statistics['avalaibleViews'][$listingTypeID]['count'] = $permissionParam;
$statistics['avalaibleViews'][$listingTypeID]['viewsLeft'] = $statistics['avalaibleViews'][$listingTypeID]['count'] - $statistics['avalaibleViews'][$listingTypeID]['numOfViews'];
}
}
if ($this->acl->isAllowed('post_' . $listingTypeID)) {
$statistics['listingAmount'][$listingTypeID]['name'] = $listingType['name'];
$permissionParam = $this->acl->getPermissionParams('post_' . $listingTypeID);
$statistics['listingAmount'][$listingTypeID]['numPostings'] = SJB_ContractManager::getListingsNumberByContractSIDsListingType($contractSIDs, $listingTypeID);
if (empty($permissionParam)) {
$statistics['listingAmount'][$listingTypeID]['count'] = 'unlimited';
$statistics['listingAmount'][$listingTypeID]['listingsLeft'] = 'unlimited';
} else {
$statistics['listingAmount'][$listingTypeID]['count'] = $permissionParam;
$statistics['listingAmount'][$listingTypeID]['listingsLeft'] = $statistics['listingAmount'][$listingTypeID]['count'] - $statistics['listingAmount'][$listingTypeID]['numPostings'];
}
}
if ($this->acl->isAllowed('view_' . $listingTypeID . '_contact_info')) {
$permissionParam = $this->acl->getPermissionParams('view_' . $listingTypeID . '_contact_info');
$statistics['avalaibleContactViews'][$listingTypeID]['name'] = $listingType['name'];
$statistics['avalaibleContactViews'][$listingTypeID]['numOfViews'] = SJB_ContractManager::getNumbeOfPagesViewed($currentUser->getSID(), $contractSIDs, 'view_' . $listingTypeID . '_contact_info');
if (empty($permissionParam)) {
$statistics['avalaibleContactViews'][$listingTypeID]['count'] = 'unlimited';
$statistics['avalaibleContactViews'][$listingTypeID]['viewsLeft'] = 'unlimited';
} else {
$statistics['avalaibleContactViews'][$listingTypeID]['count'] = $this->acl->getPermissionParams('view_' . $listingTypeID . '_contact_info');
$statistics['avalaibleContactViews'][$listingTypeID]['viewsLeft'] = $statistics['avalaibleContactViews'][$listingTypeID]['count'] - $statistics['avalaibleContactViews'][$listingTypeID]['numOfViews'];
}
}
}
$productsFailedList = urldecode(SJB_Request::getVar('failedProducts'));
if ($productsFailedList != '') {
$productsFailedArray = explode(',', $productsFailedList);
if (!empty($productsFailedArray)) {
$tp->assign('productsFailed', $productsFailedArray);
}
}
$tp->assign('statistics', $statistics);
$tp->assign("contracts_info", $contractsInfo);
$tp->assign('errors', $this->errors);
$tp->display("my_products.tpl");
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$display_form = new SJB_Form();
$display_form->registerTags($tp);
$current_user = SJB_UserManager::getCurrentUser();
$errors = array();
$template = SJB_Request::getVar('display_template', 'display_listing.tpl');
$tcpdfError = SJB_Request::getVar('error', false);
$action = substr($template, 0, -4);
$listing_id = SJB_Request::getVar("listing_id");
if (isset($_REQUEST['passed_parameters_via_uri'])) {
$passed_parameters_via_uri = SJB_UrlParamProvider::getParams();
$listing_id = isset($passed_parameters_via_uri[0]) ? $passed_parameters_via_uri[0] : null;
}
if (is_null($listing_id) && SJB_FormBuilderManager::getIfBuilderModeIsSet()) {
$listing_type_id = SJB_Request::getVar('listing_type_id');
$listing_id = SJB_ListingManager::getListingIDByListingTypeID($listing_type_id);
}
if (is_null($listing_id)) {
$errors['UNDEFINED_LISTING_ID'] = true;
} elseif (is_null($listing = SJB_ListingManager::getObjectBySID($listing_id)) || !SJB_ListingManager::isListingAccessableByUser($listing_id, SJB_UserManager::getCurrentUserSID())) {
$errors['WRONG_LISTING_ID_SPECIFIED'] = true;
} elseif (!$listing->isActive() && $listing->getUserSID() != SJB_UserManager::getCurrentUserSID()) {
$errors['LISTING_IS_NOT_ACTIVE'] = true;
} elseif (($listingStatus = SJB_ListingManager::getListingApprovalStatusBySID($listing_id)) != 'approved' && SJB_ListingTypeManager::getWaitApproveSettingByListingType($listing->listing_type_sid) == 1 && $listing->getUserSID() != SJB_UserManager::getCurrentUserSID()) {
$errors['LISTING_IS_NOT_APPROVED'] = true;
} elseif (SJB_ListingTypeManager::getListingTypeIDBySID($listing->listing_type_sid) == 'Resume' && ($template == 'display_job.tpl' or SJB_System::getURI() == '/print-job/') || SJB_ListingTypeManager::getListingTypeIDBySID($listing->listing_type_sid) == 'Job' && ($template == 'display_resume.tpl' or SJB_System::getURI() == '/print-resume/')) {
$errors['WRONG_DISPLAY_TEMPLATE'] = true;
} else {
$listing_type_id = SJB_ListingTypeManager::getListingTypeIDBySID($listing->listing_type_sid);
if (SJB_System::getURI() == '/print-listing/') {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/print-' . strtolower($listing_type_id) . '/?listing_id=' . $listing_id);
exit;
}
$listing->addPicturesProperty();
$display_form = new SJB_Form($listing);
$display_form->registerTags($tp);
$form_fields = $display_form->getFormFieldsInfo();
$listingOwner = SJB_UserManager::getObjectBySID($listing->user_sid);
if ($action !== 'print_listing') {
SJB_ListingManager::incrementViewsCounterForListing($listing_id, $listing);
}
$listing_structure = SJB_ListingManager::createTemplateStructureForListing($listing, array('comments', 'ratings'));
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$file = SJB_UploadFileManager::openFile($filename, $listing_id);
$errors['NO_SUCH_FILE'] = true;
}
$metaDataProvider = SJB_ObjectMother::getMetaDataProvider();
$tp->assign("METADATA", array("listing" => $metaDataProvider->getMetaData($listing_structure['METADATA']), "form_fields" => $metaDataProvider->getFormFieldsMetadata($form_fields)));
$comments = array();
$comments_total = '';
if (SJB_Settings::getSettingByName('show_comments') == '1') {
$comments = SJB_CommentManager::getEnabledCommentsToListing($listing_id);
$comments_total = count($comments);
}
$searchId = SJB_Request::getVar("searchId", "");
$page = SJB_Request::getVar("page", "");
$criteria_saver = new SJB_ListingCriteriaSaver($searchId);
$searchCriteria = $criteria_saver->getCriteria();
$keywordsHighlight = '';
if (isset($searchCriteria['keywords']) && SJB_System::getSettingByName('use_highlight_for_keywords')) {
foreach ($searchCriteria['keywords'] as $type => $keywords) {
switch ($type) {
case 'like':
case 'exact_phrase':
$keywordsHighlight = json_encode($keywords);
break;
case 'all_words':
case 'any_words':
$keywordsHighlight = json_encode(explode(' ', $keywords));
break;
case 'boolean':
$keywordsHighlight = json_encode(SJB_BooleanEvaluator::parse($keywords, true));
break;
}
}
}
$prevNextIds = $criteria_saver->getPreviousAndNextObjectID($listing_id);
$search_criteria_structure = $criteria_saver->createTemplateStructureForCriteria();
//permissions contact info
$acl = SJB_Acl::getInstance();
$permission = 'view_' . $listing_type_id . '_contact_info';
$allowViewContactInfo = false;
if (SJB_UserManager::isUserLoggedIn()) {
if (SJB_ContractManager::isPageViewed($current_user->getSID(), $permission, $listing_id) || $acl->isAllowed($permission) && in_array($acl->getPermissionParams($permission), array('', '0'))) {
$allowViewContactInfo = true;
} elseif ($acl->isAllowed($permission)) {
$viewContactInfo['count_views'] = 0;
$contractIDs = $current_user->getContractID();
$numberOfContactViewed = SJB_ContractManager::getNumbeOfPagesViewed($current_user->getSID(), $contractIDs, $permission);
foreach ($contractIDs as $contractID) {
if ($acl->getPermissionParams($permission, $contractID, 'contract')) {
$params = $acl->getPermissionParams($permission, $contractID, 'contract');
$viewsLeft = SJB_ContractManager::getNumbeOfPagesViewed($current_user->getSID(), array($contractID), $permission);
if (isset($viewContactInfo['count_views']) && is_numeric($params)) {
$viewContactInfo['count_views'] += $params;
if ($params > $viewsLeft) {
$viewContactInfo['contract_id'] = $contractID;
}
}
}
}
if ($viewContactInfo && $viewContactInfo['count_views'] > $numberOfContactViewed) {
$allowViewContactInfo = true;
SJB_ContractManager::addViewPage($current_user->getSID(), $permission, $listing_id, $viewContactInfo['contract_id'], $listing->getListingTypeSID());
}
}
$user_group_id = SJB_UserGroupManager::getUserGroupIDBySID($current_user->getUserGroupSID());
if ($allowViewContactInfo && $user_group_id == 'JobSeeker' && $listing_type_id == 'Job') {
SJB_UserManager::saveRecentlyViewedListings($current_user->getSID(), $listing_id);
}
} elseif ($acl->isAllowed($permission)) {
$allowViewContactInfo = true;
}
$tp->assign("keywordsHighlight", $keywordsHighlight);
$tp->assign('allowViewContactInfo', $allowViewContactInfo);
$tp->assign('show_rates', SJB_Settings::getSettingByName('show_rates'));
$tp->assign("isApplied", SJB_Applications::isApplied($listing_id, SJB_UserManager::getCurrentUserSID()));
$tp->assign('show_rates', SJB_Settings::getSettingByName('show_rates'));
$tp->assign('show_comments', SJB_Settings::getSettingByName('show_comments'));
$tp->assign('comments', $comments);
$tp->assign('comments_total', $comments_total);
$tp->assign('listing_id', $listing_id);
$tp->assign("form_fields", $form_fields);
$tp->assign('video_fields', SJB_HelperFunctions::takeMediaFields($form_fields));
$tp->assign('uri', base64_encode(SJB_Navigator::getURIThis()));
$tp->assign('listingOwner', $listingOwner);
$listing_structure = SJB_ListingManager::newValueFromSearchCriteria($listing_structure, $criteria_saver->criteria);
// SJB-1197: ajax autoupload.
// Fix to view video from temporary uploaded storage.
$sessionFilesStorage = SJB_Session::getValue('tmp_uploads_storage');
// NEED TO CHECK FOR COMPLEX PARENT AND COMPLEX STEP PARAMETERS!
$complexParent = SJB_Request::getVar('complexParent');
$complexStep = SJB_Request::getVar('complexEnum');
$fieldId = SJB_Request::getVar('field_id');
$isComplex = false;
if ($complexParent && $complexStep) {
$fieldId = $complexParent . ":" . $fieldId . ":" . $complexStep;
$isComplex = true;
}
$tempFileValue = SJB_Array::getPath($sessionFilesStorage, "listings/{$listing_id}/{$fieldId}");
if ($isComplex) {
$uploadFileManager = new SJB_UploadFileManager();
$fileLink = $uploadFileManager->getUploadedFileLink($tempFileValue['file_id']);
$tp->assign('videoFileLink', $fileLink);
} else {
if (!empty($tempFileValue)) {
$fileUniqueId = isset($tempFileValue['file_id']) ? $tempFileValue['file_id'] : '';
if (!empty($fileUniqueId)) {
$upload_manager = new SJB_UploadFileManager();
// file structure for videoplayer
$fileInfo = array('file_url' => $upload_manager->getUploadedFileLink($fileUniqueId), 'file_name' => $upload_manager->getUploadedFileName($fileUniqueId), 'saved_file_name' => $upload_manager->getUploadedSavedFileName($fileUniqueId), 'file_id' => $fileUniqueId);
$listing_structure[$fieldId] = $fileInfo;
}
}
}
// SJB-1197
// GOOGLE MAP SEARCH RESULTS CUSTOMIZATION
$zipCode = '';
if (!empty($listing_structure['Location']['ZipCode'])) {
$zipCode = $listing_structure['Location']['ZipCode'];
}
// get 'latitude' and 'longitude' from zipCode field, if it not set
$latitude = isset($listing_structure['latitude']) ? $listing_structure['latitude'] : '';
$longitude = isset($listing_structure['longitude']) ? $listing_structure['longitude'] : '';
if (!empty($zipCode) && empty($latitude) && empty($longitude)) {
$result = SJB_DB::query("SELECT * FROM `locations` WHERE `name` = ?s LIMIT 1", $zipCode);
if ($result) {
$listing_structure['latitude'] = $result[0]['latitude'];
$listing_structure['longitude'] = $result[0]['longitude'];
}
} elseif (!empty($listing_structure['Location']['City']) && !empty($listing_structure['Location']['State']) && !empty($listing_structure['Location']['Country'])) {
$address = $listing_structure['Location']['City'] . ', ' . $listing_structure['Location']['State'] . ', ' . $listing_structure['Location']['Country'];
$address = urlencode($address);
$cache = SJB_Cache::getInstance();
$parameters = array('City' => $listing_structure['Location']['City'], 'State' => $listing_structure['Location']['State'], 'Country' => $listing_structure['Location']['Country']);
$hash = md5('google_map' . serialize($parameters));
$data = $cache->load($hash);
$geoCod = '';
if (!$data) {
try {
$geoCod = SJB_HelperFunctions::getUrlContentByCurl("http://maps.googleapis.com/maps/api/geocode/json?address={$address}&sensor=false");
$geoCod = json_decode($geoCod);
if ($geoCod->status == 'OK') {
$cache->save($geoCod, $hash);
}
} catch (Exception $e) {
$backtrace = SJB_Logger::getBackTrace();
SJB_Error::writeToLog(array(array('level' => 'E_USER_WARNING', 'message' => $e->getMessage(), 'file' => $e->getFile(), 'line' => $e->getLine(), 'backtrace' => sprintf("BACKTRACE:\n [%s]", join("<br/>\n", $backtrace)))));
}
} else {
$geoCod = $data;
}
try {
if (!is_object($geoCod)) {
throw new Exception("Map object nave not been Created");
}
if ($geoCod->status !== 'OK') {
throw new Exception("Status is not OK");
}
$location = $geoCod->results[0]->geometry->location;
$listing_structure['latitude'] = $location->lat;
$listing_structure['longitude'] = $location->lng;
} catch (Exception $e) {
$backtrace = SJB_Logger::getBackTrace();
SJB_Error::writeToLog(array(array('level' => 'E_USER_WARNING', 'message' => $e->getMessage(), 'file' => $e->getFile(), 'line' => $e->getLine(), 'backtrace' => sprintf("BACKTRACE:\n [%s]", join("<br/>\n", $backtrace)))));
}
}
if (SJB_Request::getVar('view')) {
$tp->assign('listings', array($listing_structure));
}
$tp->filterThenAssign("listing", $listing_structure);
$tp->assign("prev_next_ids", $prevNextIds);
$tp->assign("searchId", $searchId);
$tp->assign("page", $page);
$tp->filterThenAssign("search_criteria", $search_criteria_structure);
$tp->filterThenAssign("search_uri", $criteria_saver->getUri());
if ($field_id = SJB_Request::getVar('field_id')) {
// SJB-825
$complexEnum = SJB_Request::getVar('complexEnum', null, 'GET');
$complexFieldID = SJB_Request::getVar('complexParent', null, 'GET');
if (!is_null($complexEnum) && !is_null($complexFieldID)) {
$videoFileID = $complexFieldID . ':' . $field_id . ':' . $complexEnum . '_' . $listing_id;
$videoFileLink = SJB_UploadFileManager::getUploadedFileLink($videoFileID);
if ($videoFileLink) {
$tp->assign('videoFileLink', $videoFileLink);
}
}
// SJB-825
$tp->assign('field_id', $field_id);
} else {
if (SJB_Request::getVar('action', false) == 'download_pdf_version') {
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_PDF, $listing_type_id);
$formBuilder->setChargedTemplateProcessor($tp);
$tpl = 'resume_to_pdf.tpl';
if ($listing_structure['anonymous'] == '1') {
$filename = 'Anonymous User_' . $listing_structure['Title'] . '.pdf';
} else {
$filename = $listing_structure['user']['FirstName'] . ' ' . $listing_structure['user']['LastName'] . '_' . $listing_structure['Title'] . '.pdf';
}
try {
$html = $tp->fetch($tpl);
$html = preg_replace('/<div[^>]*>/', '', $html);
$html = str_replace('</div>', '', $html);
SJB_HelperFunctions::html2pdf($html, $filename, str_replace('http://', '', SJB_HelperFunctions::getSiteUrl()));
exit;
} catch (Exception $e) {
SJB_Error::writeToLog($e->getMessage());
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings("SITE_URL") . '/display-resume/' . $listing_id . '/?error=TCPDF_ERROR');
}
} else {
$formBuilder = SJB_FormBuilderManager::getFormBuilder(SJB_FormBuilderManager::FORM_BUILDER_TYPE_DISPLAY, $listing_type_id);
$formBuilder->setChargedTemplateProcessor($tp);
}
}
}
if ($errors) {
foreach ($errors as $k => $v) {
switch ($k) {
case 'TCPDF_ERROR':
case 'UNDEFINED_LISTING_ID':
case 'WRONG_LISTING_ID_SPECIFIED':
case 'LISTING_IS_NOT_ACTIVE':
case 'LISTING_IS_NOT_APPROVED':
$header = $_SERVER['SERVER_PROTOCOL'] . ' 404 Not Found';
$header_status = "Status: 404 Not Found";
header($header_status);
header($header);
SJB_System::setGlobalTemplateVariable('page_not_found', true);
break;
}
}
}
$tp->assign('errors', $errors);
$tp->assign('tcpdfError', $tcpdfError);
$tp->display($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()
{
$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');
}
}
/**
* @param $bannerInfo
* @param $user_sid
* @param $reject
* @return bool
*/
public static function sendBannerRejectedLetter($bannerInfo, $user_sid, $reject)
{
$admin_email = SJB_Settings::getSettingByName('notification_email');
$user = SJB_UserManager::getObjectBySID($user_sid);
$user_info = SJB_UserManager::createTemplateStructureForUser($user);
if (!empty($bannerInfo['contract_sid']) && $user_info) {
$contract = SJB_ContractManager::getInfo($bannerInfo['contract_sid']);
$productInfo = SJB_ProductsManager::getProductInfoBySID($contract['product_sid']);
$productExtraInfo = SJB_ProductsManager::getProductExtraInfoBySID($productInfo['sid']);
$productInfo = array_merge($productInfo, $productExtraInfo);
$product = SJB_ProductsManager::createTemplateStructureForProductForEmailTpl($productInfo);
$data = array('user' => $user_info, 'banner' => $bannerInfo, 'reason' => $reject, 'admin_email' => $admin_email, 'product' => $product);
$email = SJB_EmailTemplateEditor::getEmail($user_info['email'], self::SEND_BANNER_REJECTED_LTR_SID, $data);
return $email->send('Banner Rejected');
}
return null;
}
public static function getListingsNumberByUserSID($user_sid)
{
$userContractsSIDs = SJB_ContractManager::getAllContractsSIDsByUserSID($user_sid);
$userContractsSIDs = $userContractsSIDs ? implode(',', $userContractsSIDs) : 0;
return SJB_DB::queryValue("SELECT COUNT(*) FROM `listings` WHERE `user_sid` = ?n AND `contract_id` in ({$userContractsSIDs})", $user_sid);
}
