public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$user = SJB_UserManager::getCurrentUser();
if ($user) {
$userNotificationsManager = new SJB_UserNotificationsManager($user);
$userNotificationsInfo = $userNotificationsManager->getUserNotificationsInfo();
$userNotificationsInfo = array_merge($userNotificationsInfo, $_REQUEST);
$userNotifications = new SJB_UserNotifications($userNotificationsInfo);
$userNotificationsForm = new SJB_Form($userNotifications);
$userNotificationsForm->registerTags($tp);
$userNotificationsFields = $userNotificationsForm->getFormFieldsInfo();
$tp->assign('form_fields', $userNotificationsFields);
if (SJB_Request::getVar('action') === 'save') {
$errors = array();
if ($userNotificationsForm->isDataValid($errors)) {
$userNotifications->update();
$tp->assign('isSaved', true);
}
$tp->assign('errors', $errors);
}
$tp->assign('userNotificationGroups', $userNotificationsManager->getNotificationGroups()->getGroups());
$tp->assign('userNotifications', $userNotificationsManager->getEnabledForGroupUserNotifications());
$listingTypes = SJB_ListingTypeManager::getListingTypeByUserSID($user->getSID());
$approveSetting = SJB_ListingTypeManager::getWaitApproveSettingByListingType($listingTypes);
$tp->assign('approve_setting', $approveSetting);
$tp->display('user_notifications.tpl');
} else {
$tp->display('login.tpl');
}
}
/**
* @static
* @param SJB_User $user
* @return bool
*/
public static function saveUser(SJB_User $user)
{
$newUserInDB = !$user->isSavedInDB();
if ($newUserInDB) {
$user->createActivationKey();
$user->createVerificationKey();
}
SJB_UserDBManager::saveUser($user);
SJB_Cache::getInstance()->clean('matchingAnyTag', array(SJB_Cache::TAG_USERS));
if ($newUserInDB) {
SJB_Event::dispatch('onAfterUserCreated', $user);
if (!$user->isSubuser()) {
//add default user notifications
$userNotifications = new SJB_UserNotificationsManager($user);
$userNotifications->addDefaultUserNotifications();
}
}
if (SJB_Authorization::isUserLoggedIn()) {
SJB_Authorization::updateCurrentUserSession();
}
return true;
}
public function createContract($userSID, $invoiceID, $reactivation, $status = 'active')
{
$listingNumber = !empty($this->product['qty']) ? $this->product['qty'] : null;
if ($this->recurringID) {
$contract = new SJB_Contract(array('product_sid' => $this->product['sid'], 'recurring_id' => $this->recurringID, 'gateway_id' => $this->gatewayID, 'invoice_id' => $invoiceID, 'numberOfListings' => $listingNumber));
$contractSID = SJB_ContractManager::getContractSIDByRecurringId($this->recurringID);
SJB_ContractManager::deleteAllContractsByRecurringId($this->recurringID);
} else {
$contract = new SJB_Contract(array('product_sid' => $this->product['sid'], 'gateway_id' => $this->gatewayID, 'invoice_id' => $invoiceID, 'numberOfListings' => $listingNumber));
if ($invoiceID) {
SJB_ContractManager::deletePendingContractByInvoiceID($invoiceID, $userSID, $this->product['sid']);
}
}
$contract->setUserSID($userSID);
$contract->setPrice($this->product['amount']);
$contract->setStatus($status);
if ($contract->saveInDB()) {
SJB_ShoppingCart::deleteItemFromCartBySID($this->product['shoppingCartRecord'], $userSID);
$bannerInfo = $this->product['banner_info'];
if ($this->product['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, $userSID, $contract->getID());
$bannerGroup = $bannersObj->getBannerGroupBySID($bannerInfo['banner_group_sid']);
SJB_AdminNotifications::sendAdminBannerAddedLetter($userSID, $bannerGroup);
}
}
if ($contract->isFeaturedProfile()) {
SJB_UserManager::makeFeaturedBySID($userSID);
}
SJB_Statistics::addStatistics('payment', 'product', $this->product['sid'], false, 0, 0, $userSID, $this->product['amount']);
if (SJB_UserNotificationsManager::isUserNotifiedOnSubscriptionActivation($userSID)) {
SJB_Notifications::sendSubscriptionActivationLetter($userSID, $this->product, $reactivation);
}
}
}
public static function notifyOnUserDeactivated($username)
{
$userSID = SJB_UserManager::getUserSIDbyUsername($username);
if (SJB_UserNotificationsManager::isUserNotifiedOnProfileDeactivation($userSID)) {
$user = SJB_UserManager::getObjectBySID($userSID);
$userGroupSID = $user->getUserGroupSID();
$emailTplSID = SJB_UserGroupManager::getEmailTemplateSIDByUserGroupAndField($userGroupSID, 'notify_user_on_deactivation');
$user = SJB_UserManager::createTemplateStructureForUser($user);
$data = array('user' => $user);
$email = SJB_EmailTemplateEditor::getEmail($user['email'], $emailTplSID, $data);
return $email->send('User Deactivated');
}
return null;
}
/**
* Send private message
*
* @param integer $from
* @param integer $to
* @param string $subject
* @param string $message
* @param boolean $copy Save copy in outbox
* @param boolean $reply_id if we reply to message with $reply_id, mark it as replied
*/
public static function sendMessage($from, $to, $subject, $message, $copy = true, $reply_id = false, $cc = false, $anonym = 0)
{
$date = date('Y-m-d H:i:s');
// to anonymous resume
$anonym = $anonym ? $anonym : 0;
$query = 'INSERT INTO `private_message` SET `from_id`=?n, `to_id`=?n, `data`=?s, `subject`=?s, `message`=?s, `anonym` = ?n';
$mess_id = SJB_DB::query($query, $from, $to, $date, $subject, $message, $anonym);
if ($mess_id) {
if (SJB_UserNotificationsManager::isUserNotifiedOnNewPersonalMessage($to)) {
$message_for_notification = SJB_PrivateMessage::readMessage($mess_id, true);
SJB_Notifications::sendNewPrivateMessageLetter($to, $from, $message_for_notification, $cc);
}
if ($copy) {
SJB_DB::query('INSERT INTO `private_message`
SET `from_id`=?n, `to_id`=?n, `data`=?s, `subject`=?s, `message`=?s, `outbox`=1, `anonym` = ?n', $from, $to, $date, $subject, $message, $anonym);
}
if ($reply_id) {
SJB_DB::query('UPDATE `private_message` SET `status`=?n WHERE id = ?n', PM_STATUS_REPLIED, $reply_id);
}
}
}
/**
* 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 function execute()
{
$tp = SJB_System::getTemplateProcessor();
$invoice_sid = SJB_Request::getVar('invoice_sid', null, false, 'int');
$invoice = SJB_InvoiceManager::getObjectBySID($invoice_sid);
$user = null;
$errors = null;
$userHasContract = false;
if (!is_null($invoice)) {
$status = $invoice->getStatus();
if ($status == SJB_Invoice::INVOICE_STATUS_VERIFIED) {
$userSID = $invoice->getPropertyValue('user_sid');
$items = $invoice->getPropertyValue('items');
$products = $items['products'];
$user = SJB_UserManager::getObjectBySID($userSID);
$userHasContract = $user->hasContract();
$paymentStatus = false;
foreach ($products as $key => $productSID) {
if ($productSID != -1) {
$product_info = $invoice->getItemValue($key);
$products[$key] = $product_info;
if (!empty($product_info['listing_type_sid'])) {
$listingTypeID = SJB_ListingTypeDBManager::getListingTypeIDBySID($product_info['listing_type_sid']);
$listingTypeName = SJB_ListingTypeManager::getListingTypeNameBySID($product_info['listing_type_sid']);
if (!in_array($listingTypeID, array('Job', 'Resume'))) {
$listingTypeName .= ' Listing';
}
$listingTypes[] = array('ID' => $listingTypeID, 'name' => $listingTypeName);
}
$listingNumber = $product_info['qty'];
$contract = new SJB_Contract(array('product_sid' => $productSID, 'numberOfListings' => $listingNumber, 'is_recurring' => $invoice->isRecurring()));
$contract->setUserSID($userSID);
$contract->setPrice($items['amount'][$key]);
if ($contract->saveInDB()) {
SJB_ListingManager::activateListingsAfterPaid($userSID, $productSID, $contract->getID(), $listingNumber);
SJB_ShoppingCart::deleteItemFromCartBySID($product_info['shoppingCartRecord'], $userSID);
$bannerInfo = $product_info['banner_info'];
$paymentStatus = true;
if ($product_info['product_type'] == 'banners' && !empty($bannerInfo)) {
$bannersObj = new SJB_Banners();
$bannersObj->addBanner($bannerInfo['title'], $bannerInfo['link'], $bannerInfo['bannerFilePath'], $bannerInfo['sx'], $bannerInfo['sy'], $bannerInfo['type'], 0, $bannerInfo['banner_group_sid'], $bannerInfo, $userSID, $contract->getID());
$bannerGroup = $bannersObj->getBannerGroupBySID($bannerInfo['banner_group_sid']);
SJB_AdminNotifications::sendAdminBannerAddedLetter($userSID, $bannerGroup);
}
if ($contract->isFeaturedProfile()) {
SJB_UserManager::makeFeaturedBySID($userSID);
}
if (SJB_UserNotificationsManager::isUserNotifiedOnSubscriptionActivation($userSID)) {
SJB_Notifications::sendSubscriptionActivationLetter($userSID, $product_info);
}
}
} else {
if (isset($items['custom_info'][$key]['type'])) {
$products[$key] = $this->updateListing($items['custom_info'][$key]['type'], $key, $items, $userSID);
} else {
$products[$key] = array('name' => $items['custom_item'][$key]);
}
$paymentStatus = true;
}
}
if ($paymentStatus) {
$invoice->setStatus(SJB_Invoice::INVOICE_STATUS_PAID);
SJB_InvoiceManager::saveInvoice($invoice);
SJB_PromotionsManager::markPromotionAsPaidByInvoiceSID($invoice->getSID());
}
if (isset($listingTypes)) {
$tp->assign('listingTypes', $listingTypes);
}
$tp->assign('products', $products);
} else {
$errors['INVOICE_IS_NOT_VERIFIED'] = 1;
}
} else {
$errors['INVALID_INVOICE_ID'] = 1;
}
if (!$errors) {
$subTotal = $invoice->getPropertyValue('sub_total');
if (empty($subTotal)) {
SJB_Statistics::addStatisticsFromInvoice($invoice);
}
$isUserJustRegistered = SJB_UserManager::isCurrentUserJustRegistered();
if (isset($items['products']) && count($items['products']) == 1 && $isUserJustRegistered && !$userHasContract) {
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($user->getUserGroupSID());
$pageId = !empty($userGroupInfo['after_registration_redirect_to']) ? $userGroupInfo['after_registration_redirect_to'] : '';
$redirectUrl = SJB_UserGroupManager::getRedirectUrlByPageID($pageId);
SJB_HelperFunctions::redirect($redirectUrl);
}
}
$tp->assign('errors', $errors);
$tp->display('create_contract.tpl');
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$template = SJB_Request::getVar('template', 'manage_invoices.tpl');
$searchTemplate = SJB_Request::getVar('search_template', 'invoice_search_form.tpl');
$action = SJB_Request::getVar('action_name');
if (!empty($action)) {
$invoicesSIDs = SJB_Request::getVar('invoices', array());
$_REQUEST['restore'] = 1;
switch ($action) {
case 'paid':
foreach (array_keys($invoicesSIDs) as $invoiceSID) {
$invoice = SJB_InvoiceManager::getObjectBySID($invoiceSID);
$userSID = $invoice->getPropertyValue('user_sid');
if (SJB_UserManager::isUserExistsByUserSid($userSID)) {
$items = $invoice->getPropertyValue('items');
$productSIDs = $items['products'];
foreach ($productSIDs as $key => $productSID) {
if ($productSID != -1) {
if (SJB_ProductsManager::isProductExists($productSID)) {
$productInfo = $invoice->getItemValue($key);
$listingNumber = $productInfo['qty'];
$contract = new SJB_Contract(array('product_sid' => $productSID, 'numberOfListings' => $listingNumber, 'is_recurring' => $invoice->isRecurring()));
$contract->setUserSID($userSID);
$contract->setPrice($items['amount'][$key]);
if ($contract->saveInDB()) {
SJB_ListingManager::activateListingsAfterPaid($userSID, $productSID, $contract->getID(), $listingNumber);
SJB_ShoppingCart::deleteItemFromCartBySID($productInfo['shoppingCartRecord'], $userSID);
$bannerInfo = $productInfo['banner_info'];
if ($productInfo['product_type'] == 'banners' && !empty($bannerInfo)) {
$bannersObj = new SJB_Banners();
$bannersObj->addBanner($bannerInfo['title'], $bannerInfo['link'], $bannerInfo['bannerFilePath'], $bannerInfo['sx'], $bannerInfo['sy'], $bannerInfo['type'], 0, $bannerInfo['banner_group_sid'], $bannerInfo, $userSID, $contract->getID());
$bannerGroup = $bannersObj->getBannerGroupBySID($bannerInfo['banner_group_sid']);
SJB_AdminNotifications::sendAdminBannerAddedLetter($userSID, $bannerGroup);
}
if ($contract->isFeaturedProfile()) {
SJB_UserManager::makeFeaturedBySID($userSID);
}
if (SJB_UserNotificationsManager::isUserNotifiedOnSubscriptionActivation($userSID)) {
SJB_Notifications::sendSubscriptionActivationLetter($userSID, $productInfo);
}
}
}
} else {
$type = SJB_Array::getPath($items, 'custom_info/' . $key . '/type');
switch ($type) {
case 'featuredListing':
$listingId = SJB_Array::getPath($items, 'custom_info/' . $key . '/listing_id');
SJB_ListingManager::makeFeaturedBySID($listingId);
break;
case 'priorityListing':
$listingId = SJB_Array::getPath($items, 'custom_info/' . $key . '/listing_id');
SJB_ListingManager::makePriorityBySID($listingId);
break;
case 'activateListing':
$listingsIds = explode(",", SJB_Array::getPath($items, 'custom_info/' . $key . '/listings_ids'));
foreach ($listingsIds as $listingId) {
SJB_ListingManager::activateListingBySID($listingId);
}
break;
}
}
}
SJB_Statistics::addStatisticsFromInvoice($invoice);
}
$total = $invoice->getPropertyValue('total');
if ($total > 0) {
$gatewayID = $invoice->getPropertyValue('payment_method');
$gatewayID = isset($gatewayID) ? $gatewayID : 'cash_payment';
$transactionId = md5($invoiceSID . $gatewayID);
$transactionInfo = array('transaction_id' => $transactionId, 'invoice_sid' => $invoiceSID, 'amount' => $total, 'payment_method' => $gatewayID, 'user_sid' => $invoice->getPropertyValue('user_sid'));
$transaction = new SJB_Transaction($transactionInfo);
SJB_TransactionManager::saveTransaction($transaction);
}
SJB_InvoiceManager::markPaidInvoiceBySID($invoiceSID);
SJB_PromotionsManager::markPromotionAsPaidByInvoiceSID($invoiceSID);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . "/manage-invoices/");
break;
case 'unpaid':
foreach (array_keys($invoicesSIDs) as $invoiceSID) {
SJB_InvoiceManager::markUnPaidInvoiceBySID($invoiceSID);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-invoices/');
break;
case 'delete':
foreach (array_keys($invoicesSIDs) as $invoiceSID) {
SJB_InvoiceManager::deleteInvoiceBySID($invoiceSID);
}
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-invoices/');
break;
default:
unset($_REQUEST['restore']);
break;
}
}
/***************************************************************/
$_REQUEST['action'] = 'search';
$invoice = new SJB_Invoice(array());
$invoice->addProperty(array('id' => 'username', 'type' => 'string', 'value' => '', 'is_system' => true));
$aliases = new SJB_PropertyAliases();
$aliases->addAlias(array('id' => 'username', 'real_id' => 'user_sid', 'transform_function' => 'SJB_UserDBManager::getUserSIDsLikeSearchString'));
$searchFormBuilder = new SJB_SearchFormBuilder($invoice);
$criteriaSaver = new SJB_InvoiceCriteriaSaver();
if (isset($_REQUEST['restore'])) {
$_REQUEST = array_merge($_REQUEST, $criteriaSaver->getCriteria());
}
$criteria = $searchFormBuilder->extractCriteriaFromRequestData($_REQUEST, $invoice);
$searchFormBuilder->setCriteria($criteria);
$searchFormBuilder->registerTags($tp);
$tp->display($searchTemplate);
/********************** S O R T I N G *********************/
$paginator = new SJB_InvoicePagination();
$innerJoin = false;
if ($paginator->sortingField == 'username') {
$innerJoin = array('users' => array('sort_field' => array(36 => array('FirstName', 'LastName'), 41 => 'CompanyName'), 'join_field' => 'sid', 'join_field2' => 'user_sid', 'main_table' => 'invoices', 'join' => 'LEFT JOIN'));
}
$searcher = new SJB_InvoiceSearcher(array('limit' => ($paginator->currentPage - 1) * $paginator->itemsPerPage, 'num_rows' => $paginator->itemsPerPage), $paginator->sortingField, $paginator->sortingOrder, $innerJoin);
$foundInvoices = array();
$foundInvoicesInfo = array();
if (SJB_Request::getVar('action', '') == 'search') {
$foundInvoices = $searcher->getObjectsByCriteria($criteria, $aliases);
if (empty($foundInvoices) && $paginator->currentPage != 1) {
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-invoices/?page=1');
}
$criteriaSaver->setSession($_REQUEST, $searcher->getFoundObjectSIDs());
} elseif (isset($_REQUEST['restore'])) {
$foundInvoices = $criteriaSaver->getObjectsFromSession();
}
foreach ($foundInvoices as $id => $invoice) {
$subUserSID = $invoice->getPropertyValue('subuser_sid');
if ($subUserSID) {
$subUserInfo = SJB_UserManager::getUserInfoBySID($subUserSID);
$parentInfo = SJB_UserManager::getUserInfoBySID($subUserInfo['parent_sid']);
$username = $parentInfo['CompanyName'];
} else {
$userSID = $invoice->getPropertyValue('user_sid');
$userInfo = SJB_UserManager::getUserInfoBySID($userSID);
if (SJB_UserGroupManager::getUserGroupIDBySID($userInfo['user_group_sid']) == 'Employer') {
$username = $userInfo['CompanyName'];
} else {
if (SJB_UserGroupManager::getUserGroupIDBySID($userInfo['user_group_sid']) == 'JobSeeker') {
$username = $userInfo['FirstName'] . ' ' . $userInfo['LastName'];
} else {
$username = $userInfo['username'];
}
}
}
$invoice->addProperty(array('id' => 'sid', 'type' => 'string', 'value' => $invoice->getSID()));
$invoice->addProperty(array('id' => 'username', 'type' => 'string', 'value' => $username));
$foundInvoices[$id] = $invoice;
$foundInvoicesInfo[$invoice->getSID()] = SJB_InvoiceManager::getInvoiceInfoBySID($invoice->getSID());
$foundInvoicesInfo[$invoice->getSID()]['userExists'] = !empty($username) ? 1 : 0;
}
/****************************************************************/
$paginator->setItemsCount($searcher->getAffectedRows());
$form_collection = new SJB_FormCollection($foundInvoices);
$form_collection->registerTags($tp);
$tp->assign('paginationInfo', $paginator->getPaginationInfo());
$tp->assign("found_invoices", $foundInvoicesInfo);
$tp->display($template);
}
function createSubscription($payment_data)
{
$validation_result = $this->validatePayment($payment_data);
if ($validation_result !== true) {
return $validation_result;
}
$properties = $this->details->getProperties();
$api_login_id = $properties['authnet_api_login_id']->getValue();
$transaction_key = $properties['authnet_api_transaction_key']->getValue();
$use_test_account = $properties['authnet_use_test_account']->getValue();
$invoice = SJB_InvoiceManager::getObjectBySID($payment_data['item_number']);
if (empty($invoice)) {
return;
}
$items = $invoice->getPropertyValue('items');
$taxInfo = $invoice->getPropertyValue('tax_info');
if (!empty($items['products'])) {
foreach ($items['products'] as $key => $product) {
if ($product != -1) {
$product_info = $invoice->getItemValue($key);
$payment_data['item_number'] = $invoice->getSID();
$payment_data['item_name'] = 'Payment for product ' . $product_info['name'];
$payment_data['x_description'] = 'Payment for product ' . $product_info['name'];
$payment_data['x_amount'] = $product_info['amount'];
if ($taxInfo && !$taxInfo['price_includes_tax']) {
$payment_data['x_amount'] += SJB_TaxesManager::getTaxAmount($payment_data['x_amount'], $taxInfo['tax_rate'], $taxInfo['price_includes_tax']);
}
$aimProcessor = new AuthnetAIMProcessor($api_login_id, $transaction_key, $use_test_account);
$aimProcessor->setTransactionType('AUTH_CAPTURE');
$aimProcessor->setParameter('x_login', $api_login_id);
$aimProcessor->setParameter('x_tran_key', $transaction_key);
$aimProcessor->setParameter('x_card_num', $payment_data['x_card_num']);
$aimProcessor->setParameter('x_amount', $payment_data['x_amount']);
$aimProcessor->setParameter('x_exp_date', $payment_data['x_exp_date']);
$aimProcessor->process();
if (!$aimProcessor->isApproved()) {
return array($aimProcessor->getResponseMessage());
}
$recurringID = null;
if (!empty($product_info['recurring'])) {
$product = new SJB_Product($product_info, $product_info['product_type']);
$expiration_period = $product->getExpirationPeriod();
$arbProcessor = new AuthnetARBProcessor($api_login_id, $transaction_key, $use_test_account);
$arbProcessor->setParameter('refID', $payment_data['item_number']);
$arbProcessor->setParameter('subscrName', $payment_data['x_description']);
$arbProcessor->setParameter('interval_length', $expiration_period);
$arbProcessor->setParameter('interval_unit', 'days');
$arbProcessor->setParameter('startDate', date("Y-m-d", strtotime("+ {$expiration_period} days")));
$arbProcessor->setParameter('totalOccurrences', 9999);
$arbProcessor->setParameter('trialOccurrences', 0);
$arbProcessor->setParameter('amount', $payment_data['x_amount']);
$arbProcessor->setParameter('trialAmount', 0.0);
$arbProcessor->setParameter('cardNumber', $payment_data['x_card_num']);
$arbProcessor->setParameter('expirationDate', $payment_data['x_exp_date']);
$arbProcessor->setParameter('orderInvoiceNumber', $payment_data['item_number']);
$arbProcessor->setParameter('orderDescription', $payment_data['x_description']);
$arbProcessor->setParameter('firstName', $payment_data['x_first_name']);
$arbProcessor->setParameter('lastName', $payment_data['x_last_name']);
$arbProcessor->setParameter('company', $payment_data['x_company']);
$arbProcessor->setParameter('address', $payment_data['x_address']);
$arbProcessor->setParameter('city', $payment_data['x_city']);
$arbProcessor->setParameter('state', $payment_data['x_state']);
$arbProcessor->setParameter('zip', $payment_data['x_zip']);
$arbProcessor->createAccount();
if (!$arbProcessor->isSuccessful()) {
return array($arbProcessor->getResponse());
}
$recurringID = $arbProcessor->getSubscriberID();
}
$user_sid = $invoice->getUserSID();
$listingNumber = $product_info['qty'];
$contract = new SJB_Contract(array('product_sid' => $product, 'recurring_id' => $recurringID, 'gateway_id' => 'authnet_sim', 'numberOfListings' => $listingNumber));
$contract->setUserSID($user_sid);
$contract->setPrice($product_info['amount']);
if ($contract->saveInDB()) {
SJB_ShoppingCart::deleteItemFromCartBySID($product_info['shoppingCartRecord'], $user_sid);
$bannerInfo = $product_info['banner_info'];
if ($product_info['product_type'] == 'banners' && !empty($bannerInfo)) {
$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);
}
if (SJB_UserNotificationsManager::isUserNotifiedOnSubscriptionActivation($user_sid)) {
SJB_Notifications::sendSubscriptionActivationLetter($user_sid, $product_info);
}
}
}
}
$invoice->setCallbackData($payment_data);
$invoice->setStatus(SJB_Invoice::INVOICE_STATUS_PAID);
SJB_InvoiceManager::saveInvoice($invoice);
SJB_PromotionsManager::markPromotionAsPaidByInvoiceSID($invoice->getSID());
}
return true;
}
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');
}
public static function isUserNotifiedOnProfileDeletion($user_sid)
{
return SJB_UserNotificationsManager::getSettingByName('notify_user_on_deletion', $user_sid);
}
public function execute()
{
$restore = 'restore=';
if (isset($_REQUEST['action_name'], $_REQUEST['listings'])) {
$listings_ids = $_REQUEST['listings'];
switch (strtolower($_REQUEST['action_name'])) {
case 'activate':
$activatedListings = array();
foreach ($listings_ids as $listingId => $value) {
if (SJB_ListingManager::activateListingBySID($listingId, false)) {
$activatedListings[] = $listingId;
}
$listing = SJB_ListingManager::getObjectBySID($listingId);
if (SJB_UserNotificationsManager::isUserNotifiedOnListingActivation($listing->getUserSID())) {
SJB_Notifications::sendUserListingActivatedLetter($listing, $listing->getUserSID());
}
}
SJB_BrowseDBManager::addListings($activatedListings);
break;
case 'deactivate':
$this->executeAction($listings_ids, 'deactivate');
break;
case 'delete':
$this->executeAction($listings_ids, 'delete');
break;
case 'datemodify':
if (isset($_REQUEST['date_to_change'])) {
$dateToUpdate = $_REQUEST['date_to_change'];
$date = SJB_I18N::getInstance()->getInput('date', $dateToUpdate);
foreach ($listings_ids as $listing_id => $value) {
$listingInfo = SJB_ListingManager::getListingInfoBySID($listing_id);
$result = SJB_DB::query('UPDATE `listings` SET `expiration_date` = ?s WHERE `sid` = ?n', $date, $listingInfo['sid']);
}
}
break;
case 'approve':
$this->executeAction($listings_ids, 'approve');
foreach ($listings_ids as $listing_id => $value) {
$user_sid = SJB_ListingManager::getUserSIDByListingSID($listing_id);
if (SJB_UserNotificationsManager::isUserNotifiedOnListingApprove($user_sid)) {
SJB_Notifications::sendUserListingApproveOrRejectLetter($listing_id, $user_sid, 'approve');
}
}
break;
case 'reject':
$this->executeAction($listings_ids, 'reject');
foreach ($listings_ids as $listing_id => $value) {
$user_sid = SJB_ListingManager::getUserSIDByListingSID($listing_id);
if (SJB_UserNotificationsManager::isUserNotifiedOnListingReject($user_sid)) {
SJB_Notifications::sendUserListingApproveOrRejectLetter($listing_id, $user_sid, 'reject');
}
}
break;
default:
$restore = '';
break;
}
}
$listingTypeId = SJB_Request::getVar('listingTypeId', null);
$listingType = $listingTypeId != 'Job' && $listingTypeId != 'Resume' ? $listingTypeId . '-listings' : $listingTypeId . 's';
SJB_HelperFunctions::redirect(SJB_System::getSystemSettings('SITE_URL') . '/manage-' . strtolower($listingType) . '/?action=search&' . $restore);
}
/**
* @param $applicationID
*/
private function approveApplication($applicationID)
{
$applicationInfo = SJB_Applications::getBySID($applicationID);
$jobseekerSID = $applicationInfo['jobseeker_id'];
SJB_Applications::accept($applicationID);
if (SJB_UserNotificationsManager::isUserNotifiedOnApplicationsApproval($jobseekerSID)) {
SJB_Notifications::sendUserApplicationApproveOrRejectLetter($applicationID, 'approved');
}
$statisticSID = SJB_Statistics::getStatisticsByObjectSID($applicationID, 'apply');
if ($statisticSID) {
SJB_Statistics::updateStatistics($statisticSID, array('approve' => 1, 'reject' => 0));
}
}
