private function createFilterQueryBuilder(FilterBag $filter) { $builder = $this->createQueryBuilder("g")->where('g.deletedAt IS NULL'); if ($filter->has('name')) { $builder->where("g.name = :name")->setParameter("name", $filter->get('name')); } return $builder; }
protected function getUsersWithExpiredPasswordToken() { $date = new \DateTime(); $date->modify("-" . $this->passwordExpire . " day"); $this->writeln(""); $this->writeln("# Reseting token for users older than (updatedAt): " . $date->format('d-m-Y H:i:s')); $filter = new FilterBag(); $filter->set('updatedAt', $date); $filter->set('hasPasswordToken', true); return $this->getUserRepository()->findByFilter($filter); }
private function createFilterQueryBuilder(FilterBag $filter) { $builder = $this->createQueryBuilder("u")->where('u.deletedAt IS NULL')->leftJoin("u.groups", "g"); if ($filter->has('firstname')) { $builder->where("u.firstname = :firstname")->setParameter("firstname", $filter->get('firstname')); } if ($filter->has('lastname')) { $builder->andWhere("u.lastname = :lastname")->setParameter("lastname", $filter->get('lastname')); } if ($filter->has('username')) { $builder->andWhere("u.username = :username")->setParameter("username", $filter->get('username')); } if ($filter->has('personnelNumber')) { $builder->andWhere("u.personnelNumber = :personnelNumber")->setParameter("personnelNumber", $filter->get('personnelNumber')); } if ($filter->has('active')) { $builder->andWhere("u.active = :active")->setParameter("active", $filter->get('active')); } if ($filter->has('hasPasswordToken')) { if ($filter->get('hasPasswordToken')) { $builder->andWhere("u.passwordToken IS NOT NULL"); } else { $builder->andWhere("u.passwordToken IS NULL"); } } if ($filter->has('hasRegistrationToken')) { if ($filter->get('hasRegistrationToken')) { $builder->andWhere("u.registrationToken IS NOT NULL"); } else { $builder->andWhere("u.registrationToken IS NULL"); } } if ($filter->has('createdAt')) { $builder->andWhere("u.createdAt <= :date")->setParameter("date", $filter->get('createdAt')); } if ($filter->has('updatedAt')) { $builder->andWhere("u.updatedAt <= :date")->setParameter("date", $filter->get('updatedAt')); } return $builder; }