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);
}
