/** * @param int $accountId * @param \DateTime $date * @return array */ public function findOneByAccountAndPeriod($accountId, \DateTime $date) { $period = Util::getPreviousQuarter($date); $query = $this->fpdo->from($this->table)->leftJoin('bill ON bill.id = bill_item.bill_id')->select('bill.year')->where('bill_item.system_account_id', $accountId)->where('bill.year', $period['year'])->where('bill.quarter', $period['quarter']); $result = $query->limit(1)->fetchAll(); return $this->bindCollection($result)->first(); }