public function execute()
{
$tp = SJB_System::getTemplateProcessor();
if (SJB_UserManager::isUserLoggedIn() === false) {
$tp->assign('ERROR', 'NOT_LOGIN');
$tp->display('../miscellaneous/error.tpl');
return;
}
$appsSID = 0;
if (isset($_REQUEST['passed_parameters_via_uri'])) {
$passed_parameters_via_uri = SJB_UrlParamProvider::getParams();
$appsSID = isset($passed_parameters_via_uri[0]) ? $passed_parameters_via_uri[0] : null;
}
if (SJB_Applications::isUserOwnerApps(SJB_UserManager::getCurrentUserSID(), $appsSID)) {
$apps_info = SJB_Applications::getBySID($appsSID);
if (!empty($apps_info['questionnaire'])) {
$questions = unserialize($apps_info['questionnaire']);
$tp->assign('questions', $questions);
}
$tp->assign('apps_info', $apps_info);
$tp->display('view_questionaire.tpl');
}
}
public function execute()
{
$errors = array();
$field_errors = array();
$tp = SJB_System::getTemplateProcessor();
$loggedIn = SJB_UserManager::isUserLoggedIn();
$current_user_sid = SJB_UserManager::getCurrentUserSID();
$controller = new SJB_SendListingInfoController($_REQUEST);
$isDataSubmitted = false;
$jobInfo = SJB_ListingManager::getListingInfoBySID($controller->getListingID());
if ($controller->isListingSpecified()) {
if ($controller->isDataSubmitted()) {
if (SJB_Captcha::getInstance($tp, $_REQUEST)->isValid($errors)) {
// получим уникальный id для файла в uploaded_files
$file_id_current = 'application_' . md5(microtime());
$upload_manager = new SJB_UploadFileManager();
$upload_manager->setFileGroup('files');
$upload_manager->setUploadedFileID($file_id_current);
$file_name = $upload_manager->uploadFile('file_tmp');
$id_file = $upload_manager->fileId;
$post = $controller->getData();
$listingId = 0;
$post['submitted_data']['questionnaire'] = '';
if (isset($post['submitted_data']['id_resume'])) {
$listingId = $post['submitted_data']['id_resume'];
}
$mimeType = isset($_FILES['file_tmp']['type']) ? $_FILES['file_tmp']['type'] : '';
if (isset($_FILES['file_tmp']['size']) && $file_name != '' && $_FILES['file_tmp']['size'] == 0) {
$errors['FILE_IS_EMPTY'] = 'The uploaded file should not be blank';
}
if (!empty($_FILES['file_tmp']['name'])) {
$fileFormats = explode(',', SJB_System::getSettingByName('file_valid_types'));
$fileInfo = pathinfo($_FILES['file_tmp']['name']);
if (!isset($fileInfo['extension']) || !in_array(strtolower($fileInfo['extension']), $fileFormats)) {
$errors['NOT_SUPPORTED_FILE_FORMAT'] = strtolower($fileInfo['extension']) . ' ' . SJB_I18N::getInstance()->gettext(null, 'is not in an acceptable file format');
}
}
if ($file_name == '' && $listingId == 0) {
$canAppplyWithoutResume = false;
SJB_Event::dispatch('CanApplyWithoutResume', $canAppplyWithoutResume);
if (!$canAppplyWithoutResume) {
$errors['APPLY_INPUT_ERROR'] = 'Please select file or resume';
}
} else {
if (SJB_Applications::isApplied($post['submitted_data']['listing_id'], $current_user_sid) && !is_null($current_user_sid)) {
$errors['APPLY_APPLIED_ERROR'] = 'You already applied';
}
}
$res = false;
$listing_info = '';
$notRegisterUserData = $_POST;
$score = 0;
// для зарегестрированного пользователя получим поля email и name
// для незарегестрированных - поля name и email приходят с формы
if ($loggedIn === true) {
$userData = SJB_UserManager::getCurrentUserInfo();
$post['submitted_data']['username'] = isset($userData['username']) ? $userData['username'] : '';
$post['submitted_data']['LastName'] = isset($userData['LastName']) ? $userData['LastName'] : '';
$post['submitted_data']['FirstName'] = isset($userData['FirstName']) ? $userData['FirstName'] : '';
$post['submitted_data']['name'] = $post['submitted_data']['FirstName'] . ' ' . $post['submitted_data']['LastName'];
$post['submitted_data']['email'] = $userData['email'];
}
if (!empty($jobInfo['screening_questionnaire'])) {
$questions = new SJB_Questions($_REQUEST, $jobInfo['screening_questionnaire']);
$add_form = new SJB_Form($questions);
$add_form->registerTags($tp);
$add_form->isDataValid($field_errors);
$tp->assign('field_errors', $field_errors);
if (!$field_errors) {
$result = array();
$properties = $questions->getProperties();
$countAnswers = 0;
foreach ($properties as $key => $val) {
if ($val->type->property_info['type'] == 'boolean') {
switch ($val->value) {
case 0:
$val->value = 'No';
break;
case 1:
$val->value = 'Yes';
break;
}
}
$result[$val->caption] = $val->value;
if (isset($val->type->property_info['list_values'])) {
foreach ($val->type->property_info['list_values'] as $list_values) {
if (is_array($val->value)) {
foreach ($val->value as $value) {
if ($value == $list_values['id'] && $list_values['score'] != 'no') {
$score += $list_values['score'];
$countAnswers++;
}
}
} else {
if ($val->value == $list_values['id'] && $list_values['score'] != 'no') {
$score += $list_values['score'];
$countAnswers++;
}
}
}
}
}
if ($countAnswers === 0) {
$score = 0.0;
} else {
$score = round($score / $countAnswers, 2);
}
$post['submitted_data']['questionnaire'] = serialize($result);
}
}
if (count($errors) == 0 && count($field_errors) == 0) {
$res = SJB_Applications::create($post['submitted_data']['listing_id'], $current_user_sid, isset($post['submitted_data']['id_resume']) ? $post['submitted_data']['id_resume'] : '', $post['submitted_data']['comments'], $file_name, $mimeType, $id_file, isset($post['submitted_data']['anonymous']) ? $post['submitted_data']['anonymous'] : '0', $notRegisterUserData, $post['submitted_data']['questionnaire'], $score);
if ($res) {
SJB_Statistics::addStatistics('apply', $post['submitted_data']['listing_id'], $res);
}
if (isset($post['submitted_data']['id_resume']) && $post['submitted_data']['id_resume'] != 0) {
$listing_info = SJB_ListingManager::getListingInfoBySID($post['submitted_data']['id_resume']);
$emp_sid = SJB_ListingManager::getUserSIDByListingSID($post['submitted_data']['listing_id']);
$accessible = SJB_ListingManager::isListingAccessableByUser($post['submitted_data']['id_resume'], $emp_sid);
if (!$accessible) {
SJB_ListingManager::setListingAccessibleToUser($post['submitted_data']['id_resume'], $emp_sid);
}
}
if (!empty($file_name)) {
$file_name = 'files/files/' . $file_name;
}
SJB_Notifications::sendApplyNow($post, $file_name, $listing_info, $current_user_sid, $notRegisterUserData, $score);
if (!empty($jobInfo['screening_questionnaire'])) {
$questionnaire = SJB_ScreeningQuestionnaires::getInfoBySID($jobInfo['screening_questionnaire']);
if ($questionnaire) {
$passing_score = 0;
switch ($questionnaire['passing_score']) {
case 'acceptable':
$passing_score = 1;
break;
case 'good':
$passing_score = 2;
break;
case 'very_good':
$passing_score = 3;
break;
case 'excellent':
$passing_score = 4;
break;
}
}
if ($score >= $passing_score && $questionnaire['send_auto_reply_more'] == 1) {
if (!empty($questionnaire['email_text_more'])) {
SJB_Notifications::userAutoReply($jobInfo, $current_user_sid, $questionnaire['email_text_more'], $notRegisterUserData);
}
} elseif ($score < $passing_score && $questionnaire['send_auto_reply_less'] == 1) {
if (!empty($questionnaire['email_text_less'])) {
SJB_Notifications::userAutoReply($jobInfo, $current_user_sid, $questionnaire['email_text_less'], $notRegisterUserData);
}
}
}
}
if ($res === false) {
$errors['APPLY_ERROR'] = 'Cannot apply';
}
$isDataSubmitted = true;
}
}
if (!empty($jobInfo['screening_questionnaire'])) {
$questions = new SJB_Questions($_REQUEST, $jobInfo['screening_questionnaire']);
$add_form = new SJB_Form($questions);
$add_form->registerTags($tp);
$form_fields = $add_form->getFormFieldsInfo();
$tp->assign('form_fields', $form_fields);
$tp->assign('questionsObject', $questions);
}
if ($loggedIn) {
$listing_type_sid = SJB_ListingTypeManager::getListingTypeSIDByID('Resume');
$wait_approve = SJB_ListingTypeManager::getWaitApproveSettingByListingType($listing_type_sid);
$approve_status = '';
if ($wait_approve) {
$approve_status = "AND `l`.`status` = 'approved'";
}
$result = SJB_DB::query("SELECT `l`.`sid` , `l`.`Title` FROM `listings` as `l`\n\t\t\t\tLEFT JOIN `listing_types` as `lt` ON (`lt`.`sid` = `l`.`listing_type_sid`)\n\t\t\t\tWHERE `lt`.`id` = 'Resume' {$approve_status} AND `l`.`user_sid` = {$current_user_sid} AND `l`.`active`");
$resume = array();
foreach ($result as $val) {
$resume[$val['sid']] = $val['Title'];
}
$tp->assign('resume', $resume);
}
$tp->assign('listing', $jobInfo);
} else {
$errors['UNDEFINED_LISTING_ID'] = true;
}
$tp->assign('request', $_REQUEST);
$tp->assign('errors', $errors);
$tp->assign('listing_id', $controller->getListingID());
$tp->assign('is_data_submitted', $isDataSubmitted);
$tp->display('apply_now.tpl');
}
public static function sendUserApplicationApproveOrRejectLetter($application_id, $mode = 'approved')
{
$application_info = SJB_Applications::getBySID($application_id);
$user = SJB_UserManager::getObjectBySID($application_info['jobseeker_id']);
$userGroupSID = $user->getUserGroupSID();
switch ($mode) {
case 'rejected':
$emailTemplate = 'notify_on_application_reject';
break;
case 'approved':
default:
$emailTemplate = 'notify_on_application_approve';
break;
}
$emailTplSID = SJB_UserGroupManager::getEmailTemplateSIDByUserGroupAndField($userGroupSID, $emailTemplate);
$user = SJB_UserManager::createTemplateStructureForUser($user);
$listing = SJB_ListingManager::getObjectBySID($application_info['listing_id']);
$listing = SJB_ListingManager::createTemplateStructureForListing($listing);
$data = array('user' => $user, 'listing' => $listing);
$email = SJB_EmailTemplateEditor::getEmail($user['email'], $emailTplSID, $data);
return $email->send('User Application ' . $mode);
}
public function execute()
{
$tp = SJB_System::getTemplateProcessor();
$errors = array();
$actionPage = SJB_Request::getVar('action');
$page = SJB_Request::getVar('page', false);
$action = SJB_Request::getVar('actionNew');
$close = SJB_Request::getVar('close', false);
$closeWindow = SJB_Request::getVar('closeWindow', false);
$action = $action ? $action : $actionPage;
$action = isset($close) && $close != '' ? 'close' : $action;
if (!$page) {
$sid = SJB_Request::getVar('listing_sid');
$tp->assign("listing_sid", $sid);
} elseif ($page == 'apps') {
$sid = SJB_Request::getVar('apps_id');
$action = $action != 'add' ? $action . '_apps' : $action;
$tp->assign("page", $page);
$tp->assign("apps_id", $sid);
$tp->assign("listing_sid", $sid);
}
if ($sid) {
switch ($action) {
case 'add':
$action = 'edit';
$tp->assign("saved_listing", false);
break;
case 'save':
$noteSaved = false;
$note = SJB_Request::getVar('note');
if (SJB_SavedListings::saveNoteOnDB(SJB_UserManager::getCurrentUserSID(), $sid, $note)) {
$noteSaved = true;
}
$tp->assign("noteText", $note);
$tp->assign("noteSaved", $noteSaved);
break;
case 'edit':
$saved_listing = SJB_SavedListings::getSavedListingsByUserAndListingSid(SJB_UserManager::getCurrentUserSID(), $sid);
$tp->assign("saved_listing", $saved_listing);
break;
case 'save_apps':
$noteSaved = false;
$note = SJB_Request::getVar('note');
if (SJB_Applications::saveNoteOnDB($note, $sid)) {
$noteSaved = true;
}
$action = 'save';
$tp->assign("noteSaved", $noteSaved);
break;
case 'edit_apps':
$apps = SJB_Applications::getById($sid);
$action = 'edit';
$tp->assign("saved_listing", $apps);
break;
case 'close_apps':
$apps = SJB_Applications::getById($sid);
$action = 'close';
$tp->assign("saved_listing", $apps);
break;
case 'close':
$saved_listing = SJB_SavedListings::getSavedListingsByUserAndListingSid(SJB_UserManager::getCurrentUserSID(), $sid);
$tp->assign("saved_listing", $saved_listing);
break;
}
} else {
if (!$page) {
$errors['UNDEFINED_LISTING_ID'] = true;
} else {
$errors['UNDEFINED_APPS_ID'] = true;
}
}
$tp->assign('view', SJB_Request::getVar('view'));
$tp->assign("closeWindow", $closeWindow);
$tp->assign("action", $action);
$tp->assign("errors", $errors);
$tp->display('notes.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');
}
public static function hideEmp($applicationId)
{
SJB_DB::query("update applications set `show_emp` = 0 where id = ?s", $applicationId);
SJB_Applications::deleteEmptyApplication($applicationId);
}
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 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();
$displayTemplate = 'view.tpl';
$errors = array();
$filename = SJB_Request::getVar('filename', false);
if ($filename) {
$appsID = SJB_Request::getVar('appsID', false);
if ($appsID) {
$file = SJB_UploadFileManager::openApplicationFile($filename, $appsID);
if (!$file) {
$errors['NO_SUCH_FILE'] = true;
}
} else {
$errors['NO_SUCH_APPS'] = true;
}
}
$cu = SJB_UserManager::getUserInfoBySID(SJB_Request::getVar('user_sid', null));
$tp->assign('user_sid', $cu['sid']);
$tp->assign('username', $cu['username']);
$appJobId = SJB_Request::getVar('appJobId', false);
// посортируем чего-нибуть
$orderBy = SJB_Request::getVar('orderBy', 'date');
$order = SJB_Request::getVar('order', 'desc');
$tp->assign('orderBy', $orderBy);
$tp->assign('order', $order);
if (!empty($orderBy) && isset($order)) {
switch ($orderBy) {
case 'date':
$orderInfo = array('sorting_field' => 'date', 'sorting_order' => $order);
break;
case 'title':
$orderInfo = array('sorting_field' => 'Title', 'sorting_order' => $order, 'inner_join' => array('table' => 'listings', 'field1' => 'sid', 'field2' => 'listing_id'));
break;
case 'applicant':
$orderInfo = false;
$sortByUsername = true;
break;
case 'status':
$orderInfo = array('sorting_field' => 'status', 'sorting_order' => $order);
break;
case 'company':
$orderInfo = array('sorting_field' => 'CompanyName', 'sorting_order' => $order, 'inner_join' => array('table' => 'listings', 'field1' => 'sid', 'field2' => 'listing_id'), 'inner_join2' => array('table1' => 'users', 'table2' => 'listings', 'field1' => 'sid', 'field2' => 'user_sid'));
break;
}
}
if ($cu['user_group_sid'] == 41) {
// Работадатель
if (isset($_REQUEST['action'])) {
switch ($_REQUEST['action']) {
case 'approve':
if (isset($_POST['applications'])) {
foreach ($_POST['applications'] as $key => $value) {
SJB_Applications::accept($key);
}
}
break;
case 'reject':
if (isset($_POST['applications'])) {
foreach ($_POST['applications'] as $key => $value) {
SJB_Applications::reject($key);
}
}
break;
case 'delete':
if (isset($_POST['applications'])) {
foreach ($_POST['applications'] as $key => $value) {
SJB_Applications::hideEmp($key);
}
}
break;
}
}
if ($appJobId) {
$apps = SJB_Applications::getByJob($appJobId, $orderInfo);
} else {
$apps = SJB_Applications::getByEmployer($cu['sid'], $orderInfo);
}
for ($i = 0; $i < count($apps); ++$i) {
$apps[$i]['job'] = SJB_ListingManager::getListingInfoBySID($apps[$i]['listing_id']);
if (isset($apps[$i]['resume']) && !empty($apps[$i]['resume'])) {
$apps[$i]['resumeInfo'] = SJB_ListingManager::getListingInfoBySID($apps[$i]['resume']);
}
if ($apps[$i]['jobseeker_id'] == 0) {
$apps[$i]['user']['FirstName'] = $apps[$i]['username'];
} else {
$apps[$i]['user'] = SJB_UserManager::getUserInfoBySID($apps[$i]['jobseeker_id']);
}
}
$jobs = SJB_ListingManager::getListingsByUserSID($cu['sid']);
$appJobs = array();
foreach ($jobs as $job) {
$appJobs[] = array('title' => $job->details->properties['Title']->value, 'id' => $job->sid);
}
$tp->assign('appJobs', $appJobs);
$tp->assign('current_filter', $appJobId);
} else {
// Соискатель
if (SJB_Request::getVar('action', '', SJB_Request::METHOD_POST) == 'Delete selected') {
if (isset($_POST['applications'])) {
foreach ($_POST['applications'] as $key => $value) {
SJB_Applications::hideJS($key);
}
}
}
$apps = SJB_Applications::getByJobseeker($cu['sid'], $orderInfo);
for ($i = 0; $i < count($apps); ++$i) {
$apps[$i]['job'] = SJB_ListingManager::getListingInfoBySID($apps[$i]['listing_id']);
$apps[$i]['company'] = SJB_UserManager::getUserInfoBySID($apps[$i]['job']['user_sid']);
}
$displayTemplate = 'view_seeker.tpl';
}
if (isset($sortByUsername)) {
$order = $order == 'desc' ? SORT_DESC : SORT_ASC;
foreach ($apps as $key => $value) {
if (!isset($apps[$key]['user']['FirstName'])) {
$apps[$key]['user']['FirstName'] = '';
}
if (!isset($apps[$key]['user']['LastName'])) {
$apps[$key]['user']['LastName'] = '';
}
$sortKeys[$key] = $apps[$key]['user']['FirstName'] . ' ' . $apps[$key]['user']['LastName'];
}
if ($apps) {
array_multisort($sortKeys, $order, SORT_REGULAR, $apps);
}
}
$userGroupInfo = SJB_UserGroupManager::getUserGroupInfoBySID($cu['user_group_sid']);
SJB_System::setGlobalTemplateVariable('wikiExtraParam', $userGroupInfo['id']);
$tp->assign('METADATA', SJB_Application::getApplicationMeta());
$tp->assign("user_group_info", $userGroupInfo);
$tp->assign('applications', $apps);
$tp->assign('errors', $errors);
$tp->display($displayTemplate);
}
private function executeApplicationsForEmployer($appsPerPage, $appJobId, SJB_User $currentUser, $score, $orderInfo, $listingTitle)
{
$limit['countRows'] = $appsPerPage;
$limit['startRow'] = $this->currentPage * $appsPerPage - $appsPerPage;
$subuser = false;
if ($appJobId) {
$isUserOwnerApps = SJB_Applications::isUserOwnsAppsByAppJobId($currentUser->getID(), $appJobId);
if (!$isUserOwnerApps) {
SJB_FlashMessages::getInstance()->addWarning('NOT_OWNER_OF_APPLICATIONS', array('listingTitle' => $listingTitle));
}
$allAppsCountByJobID = SJB_Applications::getCountAppsByJob($appJobId, $score);
$this->setPaginationInfo($appsPerPage, $allAppsCountByJobID);
$apps = SJB_Applications::getByJob($appJobId, $orderInfo, $score, $limit);
} else {
if ($currentUser->isSubuser()) {
$subuserInfo = $currentUser->getSubuserInfo();
if (!SJB_Acl::getInstance()->isAllowed('subuser_manage_listings', $subuserInfo['sid'])) {
$subuser = $subuserInfo['sid'];
}
}
$allAppsCount = SJB_Applications::getCountApplicationsByEmployer($currentUser->getSID(), $score, $subuser);
$this->setPaginationInfo($appsPerPage, $allAppsCount);
$apps = SJB_Applications::getByEmployer($currentUser->getSID(), $orderInfo, $score, $subuser, $limit);
}
return $apps;
}