コード例 #1
0
 public function getPredicate($degreesOfKinship = self::SIBLINGS)
 {
     $siblingCondition = new Where();
     $personaId = $this->personaId;
     $fatherId = $this->fatherId;
     $motherId = $this->motherId;
     if ($this->isFlagSet($degreesOfKinship, self::BROTHER)) {
         $where = (new Where())->equalTo('father_id', $fatherId)->equalTo('mother_id', $motherId)->equalTo('gender', self::GENDER_MALE)->notEqualTo('id', $personaId);
         $siblingCondition->orPredicate($where);
     }
     if ($this->isFlagSet($degreesOfKinship, self::SISTER)) {
         $where = (new Where())->equalTo('father_id', $fatherId)->equalTo('mother_id', $motherId)->equalTo('gender', self::GENDER_FEMALE)->notEqualTo('id', $personaId);
         $siblingCondition->orPredicate($where);
     }
     if ($this->isFlagSet($degreesOfKinship, self::HALF_BROTHER_PATERNAL)) {
         $where = (new Where())->equalTo('father_id', $fatherId)->equalTo('gender', self::GENDER_MALE)->notEqualTo('id', $personaId);
         $where->andPredicate((new Where())->notEqualTo('mother_id', $motherId)->orPredicate((new Where())->isNull('mother_id')));
         $siblingCondition->orPredicate($where);
     }
     if ($this->isFlagSet($degreesOfKinship, self::HALF_BROTHER_MATERNAL)) {
         $where = (new Where())->equalTo('mother_id', $motherId)->equalTo('gender', self::GENDER_MALE)->notEqualTo('id', $personaId);
         $where->andPredicate((new Where())->notEqualTo('father_id', $fatherId)->orPredicate((new Where())->isNull('father_id')));
         $siblingCondition->orPredicate($where);
     }
     if ($this->isFlagSet($degreesOfKinship, self::HALF_SISTER_PATERNAL)) {
         $where = (new Where())->equalTo('father_id', $fatherId)->equalTo('gender', self::GENDER_FEMALE)->notEqualTo('id', $personaId);
         $where->andPredicate((new Where())->notEqualTo('mother_id', $motherId)->orPredicate((new Where())->isNull('mother_id')));
         $siblingCondition->orPredicate($where);
     }
     if ($this->isFlagSet($degreesOfKinship, self::HALF_SISTER_MATERNAL)) {
         $where = (new Where())->equalTo('mother_id', $motherId)->equalTo('gender', self::GENDER_FEMALE)->notEqualTo('id', $personaId);
         $where->andPredicate((new Where())->notEqualTo('father_id', $fatherId)->orPredicate((new Where())->isNull('father_id')));
         $siblingCondition->orPredicate($where);
     }
     return $siblingCondition;
 }
コード例 #2
0
 /**
  * Fetch all or a subset of resources
  *
  * @param  array $params
  * @return ApiProblem|mixed
  */
 public function fetchAll($params = array())
 {
     $where = new Where();
     if (isset($params['nome']) && $params['nome'] != '') {
         $likeSpec = new Where();
         $likeSpec->like('nome', '%' . $params['nome'] . '%');
         $where->addPredicate($likeSpec);
         $likeSpec = new Where();
         $likeSpec->like('sobrenome', '%' . $params['nome'] . '%');
         $where->orPredicate($likeSpec);
     }
     $sort = null;
     if (in_array($params['sort'], array_keys((new ClienteEntity())->getArrayCopy()))) {
         $sort = $params['sort'];
     }
     $dbTableGatewayAdapter = new DbTableGateway($this->tableGateway, $where, $sort);
     return new ClienteCollection($dbTableGatewayAdapter);
 }