Proyectos de Subversion LeadersLinked - Services

<?php

/**

 *

 * Controlador: Mis Perfiles

 *

 */

declare(strict_types=1);

namespace LeadersLinked\Controller;

use Laminas\Db\Adapter\AdapterInterface;

use Laminas\Mvc\Controller\AbstractActionController;

use Laminas\Log\LoggerInterface;

use Laminas\View\Model\ViewModel;

use Laminas\View\Model\JsonModel;

use LeadersLinked\Library\Functions;

use LeadersLinked\Mapper\CompanyUserMapper;

use LeadersLinked\Model\Job;

use LeadersLinked\Mapper\LocationMapper;

use LeadersLinked\Mapper\JobMapper;

use LeadersLinked\Mapper\CompanyMapper;

use LeadersLinked\Mapper\JobCategoryMapper;

use LeadersLinked\Mapper\JobSkillMapper;

use LeadersLinked\Mapper\JobDegreeMapper;

use LeadersLinked\Mapper\JobLanguageMapper;

use LeadersLinked\Mapper\DegreeMapper;

use LeadersLinked\Mapper\LanguageMapper;

use LeadersLinked\Mapper\SkillMapper;

use LeadersLinked\Mapper\IndustryMapper;

use LeadersLinked\Mapper\CompanySizeMapper;

use LeadersLinked\Mapper\CompanyLocationMapper;

use LeadersLinked\Mapper\JobApplicationMapper;

use LeadersLinked\Form\Job\ApplyForm;

use LeadersLinked\Model\JobApplication;

use LeadersLinked\Mapper\JobSaveMapper;

use LeadersLinked\Model\JobSave;

use LeadersLinked\Mapper\QueryMapper;

use LeadersLinked\Mapper\UserProfileMapper;

class JobController extends AbstractActionController

{

    /**

     *

     * @var \Laminas\Db\Adapter\AdapterInterface

     */

    private $adapter;

    /**

     *

     * @var \LeadersLinked\Cache\CacheInterface

     */

    private $cache;

    /**

     *

     * @var \Laminas\Log\LoggerInterface

     */

    private $logger;

    /**

     *

     * @var array

     */

    private $config;

    /**

     *

     * @var \Laminas\Mvc\I18n\Translator

     */

    private $translator;

    /**

     *

     * @param \Laminas\Db\Adapter\AdapterInterface $adapter

     * @param \LeadersLinked\Cache\CacheInterface $cache

     * @param \Laminas\Log\LoggerInterface LoggerInterface $logger

     * @param array $config

     * @param \Laminas\Mvc\I18n\Translator $translator

     */

    public function __construct($adapter, $cache, $logger, $config, $translator)

    {

        $this->adapter      = $adapter;

        $this->cache        = $cache;

        $this->logger       = $logger;

        $this->config       = $config;

        $this->translator   = $translator;

    }

    /**

     *

     * Generación del listado de perfiles

     * {@inheritDoc}

     * @see \Laminas\Mvc\Controller\AbstractActionController::indexAction()

     */

    public function indexAction()

    {

        return new JsonModel([

            'success' => false,

            'data' => 'ERROR_METHOD_NOT_ALLOWED'

        ]);

    }

    public function viewAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $flashMessenger = $this->plugin('FlashMessenger');

        $request = $this->getRequest();

        $id = $this->params()->fromRoute('id');

        if(!$id) {

            $flashMessenger->addErrorMessage('ERROR_INVALID_PARAMETER');

            return $this->redirect()->toRoute('dashboard');

        }

        $jobMapper = JobMapper::getInstance($this->adapter);

        $job = $jobMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);

        if(!$job) {

            $flashMessenger->addErrorMessage('ERROR_RECORD_NOT_FOUND');

            return $this->redirect()->toRoute('dashboard');

        }

        if($job->status != Job::STATUS_ACTIVE) {

            $flashMessenger->addErrorMessage('ERROR_UNAUTHORIZED');

            return $this->redirect()->toRoute('dashboard');

        }

        $companyMapper = CompanyMapper::getInstance($this->adapter);

        $company = $companyMapper->fetchOne($job->company_id);

        if(!$company) {

            $flashMessenger->addErrorMessage('ERROR_RECORD_NOT_FOUND');

            return $this->redirect()->toRoute('dashboard');

        }

        if($request->isGet()) {

            $currentUserPlugin = $this->plugin('currentUserPlugin');

            $currentUser = $currentUserPlugin->getUser();

            $companyUserMapper = CompanyUserMapper::getInstance($this->adapter);

            $now = $companyUserMapper->getDatebaseNow();

            $companyUser = $companyUserMapper->fetchOneByCompanyIdAndUserId($company->id, $currentUser->id);

            $jobApplicationMapper = JobApplicationMapper::getInstance($this->adapter);

            $total_applications = $jobApplicationMapper->fetchTotalApplicationsByJobId($job->id);

            $job->visits++;

            $jobMapper->updateVisits($job);

            //if($companyUser) {

            //   $job_apply_operation = '';

            //} else {

                $jobApplication = $jobApplicationMapper->fetchOneByJobIdAndUserId($job->id, $currentUser->id);

                if($jobApplication) {

                    $job_apply_operation = 'remove-apply';

                } else {

                    $job_apply_operation = 'apply';

                }

            //}

            $jobSaveMapper = JobSaveMapper::getInstance($this->adapter);

            $jobSave = $jobSaveMapper->fetchOneByJobIdAndUserId($job->id, $currentUser->id);

            if($jobSave) {

                $job_save_operation = 'remove-job-saved';

            } else {

                $job_save_operation = 'job-save';

            }

            $months = [

                1 => 'LABEL_MONTH_JANUARY',

                2 => 'LABEL_MONTH_FEBRUARY',

                3 => 'LABEL_MONTH_MARCH',

                4 => 'LABEL_MONTH_APRIL',

                5 => 'LABEL_MONTH_MAY',

                6 => 'LABEL_MONTH_JUNE',

                7 => 'LABEL_MONTH_JULY',

                8 => 'LABEL_MONTH_AUGUST',

                9 => 'LABEL_MONTH_SEPTEMBER',

                10 => 'LABEL_MONTH_OCTOBER',

                11 => 'LABEL_MONTH_NOVEMBER',

                12 => 'LABEL_MONTH_DECEMBER',

            ];

            $dt = \dateTime::createFromFormat('Y-m-d', $job->last_date_of_application);

            $last_date_of_application = $dt->format('d') . ' de ' . $months[$dt->format('n')] . ' de ' . $dt->format('Y');

            $locationMapper = LocationMapper::getInstance($this->adapter);

            $location = $locationMapper->fetchOne($job->location_id);

            $jobCategoryMapper = JobCategoryMapper::getInstance($this->adapter);

            $jobCategory = $jobCategoryMapper->fetchOne($job->job_category_id);

            switch($job->employment_type)

            {

                case Job::EMPLOYMENT_TYPE_FULL_TIME :

                    $employment_type = 'LABEL_EMPLOYMENT_TYPE_FULL_TIME';

                    break;

                case Job::EMPLOYMENT_TYPE_PART_TIME :

                    $employment_type = 'LABEL_EMPLOYMENT_TYPE_PART_TIME';

                    break;

                case Job::EMPLOYMENT_TYPE_CONTRACT :

                    $employment_type = 'LABEL_EMPLOYMENT_TYPE_CONTRACT';

                    break;

                case Job::EMPLOYMENT_TYPE_TEMPORARY :

                    $employment_type = 'LABEL_EMPLOYMENT_TYPE_TEMPORARY';

                    break;

                default :

                    $employment_type = '';

                    break;

            }

            $degrees = [];

            $degreeMapper = DegreeMapper::getInstance($this->adapter);

            $records = $degreeMapper->fetchAllActive();

            foreach($records as $record)

            {

                $degrees[$record->uuid] = $record->name;

            }

            $jobDegreeMapper = JobDegreeMapper::getInstance($this->adapter);

            $records = $jobDegreeMapper->fetchAllByJobId($job->id);

            $job_degrees = [];

            foreach($records as $record)

            {

                $degree = $degreeMapper->fetchOne($record->degree_id);

                array_push($job_degrees, $degree->name);

            }

            $languages = [];

            $languageMapper = LanguageMapper::getInstance($this->adapter);

            $records = $languageMapper->fetchAllActive();

            foreach($records as $record)

            {

                $languages[$record->id] = $record->name;

            }

            $jobLanguageMapper = JobLanguageMapper::getInstance($this->adapter);

            $records = $jobLanguageMapper->fetchAllByJobId($job->id);

            $job_languages = [];

            foreach($records as $record)

            {

                $language = $languageMapper->fetchOne($record->language_id);

                array_push($job_languages, $language->name);

            }

            $skills = [];

            $skillMapper = SkillMapper::getInstance($this->adapter);

            $records = $skillMapper->fetchAllActive();

            foreach($records as $record)

            {

                $skills[$record->uuid] = $record->name;

            }

            $jobSkillMapper = JobSkillMapper::getInstance($this->adapter);

            $records = $jobSkillMapper->fetchAllByJobId($job->id);

            $job_skills = [];

            foreach($records as $record)

            {

                $skill = $skillMapper->fetchOne($record->skill_id);

                array_push($job_skills, $skill->name);

            }

            $industryMapper = IndustryMapper::getInstance($this->adapter);

            $industry = $industryMapper->fetchOne($company->industry_id);

            $companySizeMapper = CompanySizeMapper::getInstance($this->adapter);

            $companySize = $companySizeMapper->fetchOne($company->company_size_id);

            $companyLocationMapper = CompanyLocationMapper::getInstance($this->adapter);

            $companyLocation = $companyLocationMapper->fetchOneMainLocationByCompanyId($company->id);

            $company_address = '';

            if($companyLocation) {

                $mainLocation = $locationMapper->fetchOne($companyLocation->location_id);

                if($mainLocation) {

                    $company_address = $mainLocation->formatted_address;

                }

            }

            $user_profiles = [];

            $userProfileMapper = UserProfileMapper::getInstance($this->adapter);

            $records = $userProfileMapper->fetchAllByUserId($currentUser->id);

            foreach($records as $record)

            {

                $user_profiles[$record->uuid] = $record->name;

            }

            $timeElapsed = Functions::timeAgo($job->updated_on, $now);

                return new JsonModel([

                    'company_uuid'  => $company->uuid,

                    'company_image'         => $company->image,

                    'job_uuid'              => $job->uuid,

                    'job_title'             => $job->title,

                    'job_description'       => $job->description,

                    'total_applications'    => $total_applications,

                    'location'              => $location->formatted_address,

                    'employment_type'       => $employment_type,

                    'last_date_of_application'  => $last_date_of_application,

                    'job_category'              => $jobCategory->name,

                    'timeElapsed'               => $timeElapsed,

                    'experience'                => $job->experience_visible ? $job->experience_min . '-' . $job->experience_max : '',

                    'salary'                    => $job->salary_visible ? $job->salary_min . '-' . $job->salary_max . ' (' . $job->salary_currency . ')' : '',

                    'job_degrees'               => $job_degrees,

                    'job_languages'             => $job_languages,

                    'job_skills'                => $job_skills,

                    'job_visits'                => $job->visits,

                    'job_apply_operation'       => $job_apply_operation,

                    'job_save_operation'        => $job_save_operation,

                    'company_name'              => $company->name,

                    'company_foundation_year'   => $company->foundation_year,

                    'company_website'           => $company->website,

                    'company_industry'          => $industry->name,

                    'company_size'              => $companySize->minimum_no_of_employee . '-' . $companySize->maximum_no_of_employee,

                    'company_address'           => $company_address,

                    'user_profiles'             => $user_profiles,

                    'skills'                    => $skills,

                    'languages'                 => $languages,

                    'degrees'                   => $degrees,

                ]);

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

        return new JsonModel($data);

    }

    public function applyJobAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        $id = $this->params()->fromRoute('id');

        if(!$id) {

            $data = [

                'success' => false,

                'data' => 'ERROR_INVALID_PARAMETER'

            ];

            return new JsonModel($data);

        }

        $jobMapper = JobMapper::getInstance($this->adapter);

        $job = $jobMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);

        if(!$job) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($job->status != Job::STATUS_ACTIVE) {

            $data = [

                'success' => false,

                'data' => 'ERROR_UNAUTHORIZED'

            ];

            return new JsonModel($data);

        }

        $companyMapper = CompanyMapper::getInstance($this->adapter);

        $company = $companyMapper->fetchOne($job->company_id);

        if(!$company) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($request->isPost()) {

            $form = new ApplyForm($this->adapter, $currentUser->id);

            $dataPost = $request->getPost()->toArray();

            $form->setData($dataPost);

            if($form->isValid()) {

                $dataPost = (array) $form->getData();

                $userProfileMapper = UserProfileMapper::getInstance($this->adapter);

                $userProfile = $userProfileMapper->fetchOneByUuid($dataPost['user_profile_id']);

                $jobApplicationMapper = JobApplicationMapper::getInstance($this->adapter);

                $jobApplication = $jobApplicationMapper->fetchOneByJobIdAndUserId($job->id, $currentUser->id);

                $result = true;

                if(!$jobApplication) {

                    $jobApplication = new JobApplication();

                    $jobApplication->job_id = $job->id;

                    $jobApplication->user_id = $currentUser->id;

                    $jobApplication->user_profile_id = $userProfile->id;

                    $result = $jobApplicationMapper->insert($jobApplication);

                    if($result) {

                        $this->logger->info('El usuario  ' . $currentUser->first_name .  ' ' . $currentUser->last_name . ' aplico al trabajo ' . $job->title, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                    }

                }

                if($result) {

                    $total = $jobApplicationMapper->fetchTotalApplicationsByJobId($job->id);

                    $data = [

                        'success'   => true,

                        'data'      => 'LABEL_SUCCESSFUL_APPLICATION',

                        'total'     => $total

                    ];

                } else {

                    $data = [

                        'success'   => false,

                        'data'      => $jobApplicationMapper->getError()

                    ];

                }

                return new JsonModel($data);

            } else {

                $messages = [];

                $form_messages = (array) $form->getMessages();

                foreach($form_messages  as $fieldname => $field_messages)

                {

                    $messages[$fieldname] = array_values($field_messages);

                }

                return new JsonModel([

                    'success'   => false,

                    'data'   => $messages

                ]);

            }

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

    }

    public function removeApplyJobAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        $id = $this->params()->fromRoute('id');

        if(!$id) {

            $data = [

                'success' => false,

                'data' => 'ERROR_INVALID_PARAMETER'

            ];

            return new JsonModel($data);

        }

        $jobMapper = JobMapper::getInstance($this->adapter);

        $job = $jobMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);

        if(!$job) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($job->status != Job::STATUS_ACTIVE) {

            $data = [

                'success' => false,

                'data' => 'ERROR_UNAUTHORIZED'

            ];

            return new JsonModel($data);

        }

        $companyMapper = CompanyMapper::getInstance($this->adapter);

        $company = $companyMapper->fetchOne($job->company_id);

        if(!$company) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($request->isPost()) {

            $jobApplicationMapper = JobApplicationMapper::getInstance($this->adapter);

            $result = $jobApplicationMapper->deleteByJobIdAndUserId($job->id, $currentUser->id);

            if($result) {

                $this->logger->info('El usuario  ' . $currentUser->first_name .  ' ' . $currentUser->last_name . ' removio su aplicación al trabajo ' . $job->title, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                $total = $jobApplicationMapper->fetchTotalApplicationsByJobId($job->id);

                $data = [

                    'success'   => true,

                    'data'      => 'LABEL_APPLICATION_WAS_REMOVED',

                    'total'     => $total

                ];

            } else {

                $data = [

                    'success'   => false,

                    'data'      => $jobApplicationMapper->getError()

                ];

            }

            return new JsonModel($data);

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

    }

    public function removeSaveJobAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        $id = $this->params()->fromRoute('id');

        if(!$id) {

            $data = [

                'success' => false,

                'data' => 'ERROR_INVALID_PARAMETER'

            ];

            return new JsonModel($data);

        }

        $jobMapper = JobMapper::getInstance($this->adapter);

        $job = $jobMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);

        if(!$job) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($job->status != Job::STATUS_ACTIVE) {

            $data = [

                'success' => false,

                'data' => 'ERROR_UNAUTHORIZED'

            ];

            return new JsonModel($data);

        }

        $companyMapper = CompanyMapper::getInstance($this->adapter);

        $company = $companyMapper->fetchOne($job->company_id);

        if(!$company) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($request->isPost()) {

            $jobSaveMapper = JobSaveMapper::getInstance($this->adapter);

            $result = $jobSaveMapper->deleteByJobIdAndUserId($job->id, $currentUser->id);

            if($result) {

                $this->logger->info('El usuario  ' . $currentUser->first_name .  ' ' . $currentUser->last_name . ' removio este trabajo salvado ' . $job->title, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                $data = [

                    'success'   => true,

                    ''

                ];

            } else {

                $data = [

                    'success'   => false,

                    'data'      => $jobSaveMapper->getError()

                ];

            }

            return new JsonModel($data);

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

    }

    public function saveJobAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        $id = $this->params()->fromRoute('id');

        if(!$id) {

            $data = [

                'success' => false,

                'data' => 'ERROR_INVALID_PARAMETER'

            ];

            return new JsonModel($data);

        }

        $jobMapper = JobMapper::getInstance($this->adapter);

        $job = $jobMapper->fetchOneByUuidAndNetworkId($id, $currentUser->network_id);

        if(!$job) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($job->status != Job::STATUS_ACTIVE) {

            $data = [

                'success' => false,

                'data' => 'ERROR_UNAUTHORIZED'

            ];

            return new JsonModel($data);

        }

        $companyMapper = CompanyMapper::getInstance($this->adapter);

        $company = $companyMapper->fetchOne($job->company_id);

        if(!$company) {

            $data = [

                'success' => false,

                'data' => 'ERROR_RECORD_NOT_FOUND'

            ];

            return new JsonModel($data);

        }

        if($request->isPost()) {

            $jobSaveMapper = JobSaveMapper::getInstance($this->adapter);

            $jobSave = $jobSaveMapper->fetchOneByJobIdAndUserId($job->id, $currentUser->id);

            if($jobSave) {

                $result = true;

            } else {

                $jobSave = new JobSave();

                $jobSave->job_id = $job->id;

                $jobSave->user_id = $currentUser->id;

                $result = $jobSaveMapper->insert($jobSave);

            }

            if($result) {

                $this->logger->info('El usuario  ' . $currentUser->first_name .  ' ' . $currentUser->last_name . ' salvo este trabajo ' . $job->title, ['user_id' => $currentUser->id, 'ip' => Functions::getUserIP()]);

                $data = [

                    'success'   => true,

                ];

            } else {

                $data = [

                    'success'   => false,

                    'data'      => $jobSaveMapper->getError()

                ];

            }

            return new JsonModel($data);

        } else {

            $data = [

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ];

            return new JsonModel($data);

        }

    }

    public function appliedJobsAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        if($request->isGet()) {

                $employment_types = [

                    job::EMPLOYMENT_TYPE_FULL_TIME => 'LABEL_EMPLOYMENT_TYPE_FULL_TIME',

                    Job::EMPLOYMENT_TYPE_PART_TIME  => 'LABEL_EMPLOYMENT_TYPE_PART_TIME',

                    Job::EMPLOYMENT_TYPE_TEMPORARY => 'LABEL_EMPLOYMENT_TYPE_TEMPORARY',

                    Job::EMPLOYMENT_TYPE_CONTRACT =>  'LABEL_EMPLOYMENT_TYPE_CONTRACT',

                ];

                $search = Functions::sanitizeFilterString($this->params()->fromQuery('search', ''));

                $queryMapper = QueryMapper::getInstance($this->adapter);

                $select = $queryMapper->getSql()->select();

                $select->columns(['id', 'uuid', 'title', 'employment_type', 'last_date_of_application']);

                $select->from(['j' => JobMapper::_TABLE]);

                $select->join(['ja' => JobApplicationMapper::_TABLE], 'j.id = ja.job_id');

                $select->where->equalTo('j.network_id', $currentUser->network_id);

                $select->where->equalTo('j.status', Job::STATUS_ACTIVE);

                $select->where->equalTo('ja.user_id', $currentUser->id);

                if($search) {

                    $select->where->like('title', '%' . $search . '%');

                }

                $select->order('last_date_of_application DESC');

                $records = $queryMapper->fetchAll($select);

                $items = [];

                foreach($records as $record)

                {

                    $item = [

                        'id' => $record['uuid'],

                        'title' => $record['title'],

                        'employment_type' => $employment_types[$record['employment_type']],

                        'last_date_of_application' => $record['last_date_of_application'],

                        'link_remove' => $this->url()->fromRoute('job/remove-apply-job', ['id' => $record['uuid']  ]),

                        'link_view' => $this->url()->fromRoute('job/view', ['id' => $record['uuid'] ]),

                    ];

                    array_push($items, $item);

                }

                $response = [

                    'success' => true,

                    'data' => $items

                ];

                return new JsonModel($response);

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);

        }

    }

    public function savedJobsAction()

    {

        $currentUserPlugin = $this->plugin('currentUserPlugin');

        $currentUser = $currentUserPlugin->getUser();

        $request = $this->getRequest();

        if($request->isGet()) {

                $employment_types = [

                    job::EMPLOYMENT_TYPE_FULL_TIME => 'LABEL_EMPLOYMENT_TYPE_FULL_TIME',

                    Job::EMPLOYMENT_TYPE_PART_TIME  => 'LABEL_EMPLOYMENT_TYPE_PART_TIME',

                    Job::EMPLOYMENT_TYPE_TEMPORARY => 'LABEL_EMPLOYMENT_TYPE_TEMPORARY',

                ];

                $search = Functions::sanitizeFilterString($this->params()->fromQuery('search', ''));

                $queryMapper = QueryMapper::getInstance($this->adapter);

                $select = $queryMapper->getSql()->select();

                $select->columns(['id', 'uuid', 'title', 'employment_type', 'last_date_of_application']);

                $select->from(['j' => JobMapper::_TABLE]);

                $select->join(['js' => JobSaveMapper::_TABLE], 'j.id = js.job_id');

                $select->join(['c' => CompanyMapper::_TABLE], 'j.company_id = c.id',['image', 'comp_uuid'=>'uuid']);

                $select->where->equalTo('j.network_id', $currentUser->network_id);

                $select->where->equalTo('j.status', Job::STATUS_ACTIVE);

                $select->where->equalTo('js.user_id', $currentUser->id);

                if($search) {

                    $select->where->like('title', '%' . $search . '%');

                }

                $select->order('last_date_of_application DESC');

                // $selectString = $queryMapper->getSql()->buildSqlString($select);

                // print_r(

                //     $selectString

                // );

                $records = $queryMapper->fetchAll($select);

                // print_r($records);

                $items = [];

                foreach($records as $record)

                {

                    $item = [

                        'id' => $record['uuid'],

                        'title' => $record['title'],

                        'employment_type' => $employment_types[$record['employment_type']],

                        'last_date_of_application' => $record['last_date_of_application'],

                        'image' => $this->url()->fromRoute('storage', ['type' => 'company', 'code' => $record['comp_uuid'], 'filename' => $record['image']]),

                        'link_remove' => $this->url()->fromRoute('job/remove-save-job', ['id' => $record['uuid']  ]),

                        'link_view' => $this->url()->fromRoute('job/view', ['id' => $record['uuid'] ]),

                    ];

                    array_push($items, $item);

                }

                $response = [

                    'success' => true,

                    'data' => $items

                ];

                return new JsonModel($response);

        } else {

            return new JsonModel([

                'success' => false,

                'data' => 'ERROR_METHOD_NOT_ALLOWED'

            ]);

        }

    }

}