public function getTaxSeason(Season $s, SportGroup $sg) { try { $id = "{$this->getEntityClassName()}\\{$s->getId()}-{$sg->getId()}"; $cache = $this->getEntityCache(); $data = $cache->load($id); if (empty($data)) { $data = $this->taxDao->createQueryBuilder("t")->where("t.season = :season")->setParameter("season", $s->getId())->andWhere("t.sportGroup = :group")->setParameter("group", $sg->getId())->getQuery()->getSingleResult(); $opts = [Cache::TAGS => [self::ENTITY_COLLECTION, $id]]; $cache->save($id, $data, $opts); } return $data; } catch (\Exception $ex) { $this->logError($ex->getMessage()); throw new Exceptions\DataErrorException($ex->getMessage(), $ex->getCode(), $ex->getPrevious()); } }
public function getOutboxDatasource($user) { $model = new Doctrine($this->mailboxDao->createQueryBuilder("mb")->where("mb.owner = :owner")->andWhere("mb.sender = :owner")->andWhere("mb.type != :type")->setParameter("owner", $this->getMixId($user))->setParameter("type", MailBoxEntryType::DELETED)); return $model; }