public function findOnlyWithBranchOffice(\FabricaDeBolo\Domain\Specifications\ISpecification $specification) { $options = array('joins' => array('INNER JOIN states ON (addresses.state_id = states.state_id)', 'INNER JOIN branchoffices ON (addresses.address_id = branchoffices.address_id)'), 'group' => 'addresses.neighborhood', 'order' => 'states.priority asc', 'conditions' => ''); if (isset($specification)) { $options['conditions'] = $specification->SatisfiedBy(); } return Address::all($options); }
public function find(\FabricaDeBolo\Domain\Specifications\ISpecification $specification, \FabricaDeBolo\Infrastructure\SortingCollection $sorting = null) { $options = array('joins' => array('INNER JOIN addresses ON (addresses.address_id = branchoffices.address_id)', 'INNER JOIN states ON (addresses.state_id = states.state_id)'), 'order' => 'states.priority', 'conditions' => ''); if (isset($specification)) { $options['conditions'] = $specification->SatisfiedBy(); } return BranchOffice::find('all', $options); }
public function find(ISpecification $specification, SortingCollection $sorting = null) { $options = array('order' => 'name asc', 'conditions' => ''); if (!isset($sorting)) { $options['order'] = 'name asc'; } else { foreach ($sorting as $k => $s) { if ($k > 0) { $options['order'] .= ", "; } $options['order'] .= $s->ColumnName . " " . ($s->Ascending ? "asc" : "desc"); } } if (isset($specification)) { $options['conditions'] = $specification->SatisfiedBy(); } return State::find('all', $options); }