2 namespace Company\Service;
10 class Group extends \Company\DataBin\Group
15 * Contract for custom select list.
16 * @param object|null $jobRecord
18 * @return \Workspace\Contract\Recurring
20 public function contractJoinedSelectList($jobRecord, array $input = array())
23 $options = new \Workspace\UseCase\Options();
24 $requirement = new \Workspace\UseCase\Requirement();
25 $requirement->addRequiredInput(array(
30 return new \Workspace\Contract\Recurring($options, $requirement);
34 * A custom select list.
35 * @param object|null $jobRecord
36 * @param \Workspace\Utility\ServiceInputParams $contract
39 public function executeJoinedSelectList($jobRecord, \Workspace\Utility\ServiceInputParams $contract)
41 $items = $this->em->createQuery(
42 'SELECT partial companyGroup.{id,name} '
43 . 'FROM Company\Entity\Group companyGroup '
44 . 'JOIN companyGroup.divisions divisions '
45 . 'JOIN divisions.companies company '
46 . 'WHERE IDENTITY(company.region) = :regionId '
47 . 'ORDER BY companyGroup.name ASC'
49 ->setParameter('regionId', $contract->data->Filter['region'])
53 foreach ($items as $item)
55 if (isset($ids[$item['id']]))
59 $ids[$item['id']] = true;
61 'value' => $item['id'],
62 'label' => $item['name']
65 return $contract->success(