/** * for people * following parameter are relevant * by => 'all', 'me', 'guest' * status => Status::CREATED, 'all' * user => User::ROLE_RECRUITER, User::ROLE_ADMIN, User::ROLE_USER * * @param $params * @param $queryBuilder * @return mixed */ public function createQuery($params, $queryBuilder) { $this->value = $params->toArray(); $this->user = $this->auth->getUser(); $isRecruiter = $this->user->getRole() == User::ROLE_RECRUITER || $this->acl->inheritsRole($this->user, User::ROLE_RECRUITER); if ($isRecruiter && (!isset($this->value['by']) || $this->value['by'] != 'guest')) { /* * a recruiter can see his jobs and jobs from users who gave permissions to do so */ if (isset($this->value['params']['by']) && 'me' == $this->value['params']['by']) { $queryBuilder->field('user')->equals($this->user->id); } else { $queryBuilder->field('permissions.view')->equals($this->user->id); } if (isset($this->value['params']['status']) && !empty($this->value['params']['status']) && $this->value['params']['status'] != 'all') { $queryBuilder->field('status.name')->equals((string) $this->value['params']['status']); } } else { /* * an applicants or guests can see all active jobs */ $queryBuilder->field('status.name')->equals(Status::ACTIVE); } /* * search jobs by keywords */ if (isset($this->value['params']['search']) && !empty($this->value['params']['search'])) { $search = strtolower($this->value['params']['search']); $searchPatterns = array(); foreach (explode(' ', $search) as $searchItem) { $searchPatterns[] = new \MongoRegex('/^' . $searchItem . '/'); } $queryBuilder->field('keywords')->all($searchPatterns); } if (isset($this->value['location'])) { $loc = $this->value['location']; $queryBuilder->field('locations.coordinates')->near($loc->getCoordinates())->maxDistance($this->value['d'] * 1000); } if (isset($this->value['sort'])) { foreach (explode(",", $this->value['sort']) as $sort) { $queryBuilder->sort($this->filterSort($sort)); } } return $queryBuilder; }
/** * for people * following parameter are relevant * by => 'all', 'me', 'guest' * status => Status::CREATED, 'all' * user => User::ROLE_RECRUITER, User::ROLE_ADMIN, User::ROLE_USER * * @param $params Parameters * @param $queryBuilder \Doctrine\ODM\MongoDB\Query\Builder * @return mixed */ public function createQuery($params, $queryBuilder) { $this->value = $params; /* * search jobs by keywords */ if (isset($params['search']) && !empty($params['search'])) { $search = strtolower($params['search']); $expression = $queryBuilder->expr()->operator('$text', ['$search' => $search]); $queryBuilder->field(null)->equals($expression->getQuery()); } if (isset($this->value['location']->coordinates)) { $coordinates = $this->value['location']->coordinates->getCoordinates(); $queryBuilder->field('locations.coordinates')->geoWithinCenter($coordinates[0], $coordinates[1], (double) $this->value['d'] / 100); } if (isset($params['channel']) && !empty($params['channel']) && $params['channel'] != "default") { $queryBuilder->field('portals')->equals($params['channel']); } $this->user = $this->auth->getUser(); $isRecruiter = $this->user->getRole() == User::ROLE_RECRUITER || $this->acl->inheritsRole($this->user, User::ROLE_RECRUITER); if ($isRecruiter && (!isset($this->value['by']) || $this->value['by'] != 'guest')) { /* * a recruiter can see his jobs and jobs from users who gave permissions to do so */ if (isset($params['by']) && 'me' == $params['by']) { $queryBuilder->field('user')->equals($this->user->id); } else { $queryBuilder->field('permissions.view')->equals($this->user->id); } if (isset($params['status']) && !empty($params['status']) && $params['status'] != 'all') { $queryBuilder->field('status.name')->equals((string) $params['status']); } } else { /* * an applicants or guests can see all active jobs */ $queryBuilder->field('status.name')->equals(Status::ACTIVE); } if (isset($this->value['sort'])) { foreach (explode(",", $this->value['sort']) as $sort) { $queryBuilder->sort($this->filterSort($sort)); } } return $queryBuilder; }