public function getAllOfficesLocationsJson() { $query = new QueryObject(); $query->addAndCondition(QueryCriteria::equal("Active", true)); list($list, $size) = $this->consultant_repository->getAll($query, 0, 100); $res = array(); foreach ($list as $consultant) { $color = strtoupper(dechex(rand(0, 10000000))); $office_index = 1; foreach ($consultant->getOffices() as $office) { $data_office = array(); $data_office['color'] = is_null($consultant->getCompany()->Color) ? $color : $consultant->getCompany()->Color; $address = $office->getAddress(); $data_office['address'] = ''; if (!empty($address)) { $data_office['address'] = trim($address . ' ' . $office->getAddress1()); } $state = $office->getState(); if (!empty($state)) { $data_office['address'] .= ', ' . $state; } $data_office['address'] .= (empty($data_office['address']) ? '' : ', ') . $office->getCity(); $data_office['address'] .= ', ' . $office->getCountry(); $data_office['lat'] = $office->getLat(); $data_office['lng'] = $office->getLng(); $data_office['owner'] = $consultant->getName(); $data_office['name'] = sprintf('Office #%s', $office_index); ++$office_index; array_push($res, $data_office); } } return json_encode($res); }
public function DateSortedJobs() { $query = new QueryObject(new JobPage()); $request = Controller::curr()->getRequest(); if ($request->requestVar('foundation')) { $query->addAndCondition(QueryCriteria::equal('FoundationJob', 1)); } $now = new DateTime(); $query->addAndCondition(QueryCriteria::equal('Active', 1)); $post_date = $now->sub(new DateInterval('P6M')); $query->addAndCondition(QueryCriteria::greaterOrEqual('JobPostedDate', $post_date->format('Y-m-d'))); $query->addAndCondition(QueryCriteria::greaterOrEqual('ExpirationDate', $now->format('Y-m-d'))); $query->addOrder(QueryOrder::desc('JobPostedDate')); $query->addOrder(QueryOrder::desc('ID')); list($jobs, $size) = $this->repository->getAll($query, 0, 1000); return new ArrayList($jobs); }
public function getLanguages() { $term = Convert::raw2sql($this->request->getVar('term')); $query = new QueryObject(); $query->addAndCondition(QueryCriteria::like('Name', $term)); list($list, $size) = $this->languages_repository->getAll($query, 0, 20); $res = array(); foreach ($list as $lang) { array_push($res, array('label' => $lang->getName(), 'value' => $lang->getName())); } return $this->ok($res); }
public function getPackagesPurchaseOrder() { $query = new QueryObject(new SummitPackagePurchaseOrder()); $status = $this->getFilterParamStatus(); switch ($status) { case 'pending': $query->addAndCondition(QueryCriteria::equal('Approved', 0)); $query->addAndCondition(QueryCriteria::equal('Rejected', 0)); break; case 'approved': $query->addAndCondition(QueryCriteria::equal('Approved', 1)); $query->addAndCondition(QueryCriteria::equal('Rejected', 0)); break; case 'rejected': $query->addAndCondition(QueryCriteria::equal('Approved', 0)); $query->addAndCondition(QueryCriteria::equal('Rejected', 1)); break; } $query->addOrder(QueryOrder::asc('Created')); list($list, $count) = $this->packages_repository->getAll($query, 0, 999999); return new ArrayList($list); }
public function getAllSponsorshipPackagesBySummit() { try { $query = new QueryObject(new SummitPackage()); $summit_id = (int) $this->request->param('SUMMIT_ID'); $query->addAndCondition(QueryCriteria::equal('SummitSponsorPageID', $summit_id)); $query->addOrder(QueryOrder::asc("Order")); list($list, $count) = $this->sponsorship_package_repository->getAll($query, 0, 999999); $res = array(); foreach ($list as $package) { array_push($res, SummitPackageAssembler::toArray($package)); } return $this->ok($res); } catch (Exception $ex) { SS_Log::log($ex, SS_Log::WARN); return $this->serverError(); } }
/** * @return ArrayList */ public function getPrivateClouds() { $product_name = trim(Convert::raw2sql($this->request->getVar('name'))); $company_id = intval($this->request->getVar('company_id')); $sort = $this->request->getVar('sort'); $query = new QueryObject(new CompanyService()); $query_draft = new QueryObject(new CompanyServiceDraft()); $query_draft->addAndCondition(QueryCriteria::equal('LiveServiceID', 0)); if (!empty($product_name)) { $query->addAndCondition(QueryCriteria::like('Name', $product_name)); $query_draft->addAndCondition(QueryCriteria::like('Name', $product_name)); } if ($company_id > 0) { $query->addAndCondition(QueryCriteria::equal('Company.ID', $company_id)); $query_draft->addAndCondition(QueryCriteria::equal('Company.ID', $company_id)); } //set sorting if (!empty($sort)) { $dir = $this->getSortDir('private.clouds'); $this->sortCompanyService($query, $sort, $dir); $this->sortCompanyService($query_draft, $sort, $dir); } //get public clouds list($list1, $size1) = $this->private_clouds_repository->getAll($query, 0, 1000); list($list2, $size2) = $this->private_clouds_draft_repository->getAll($query_draft, 0, 1000); //return on view model return new ArrayList(array_merge($list1, $list2)); }
/** * @param QueryObject $query * @param int $offset * @param int $limit * @return array */ public function getAll(QueryObject $query, $offset = 1, $limit = 10) { return $this->repository->getAll($query, $offset, $limit); }