/** * @param $bannerID * @return Iterator */ protected function getCoupons($bannerID, $userID) { $selectBuilder = new Gpf_SqlBuilder_SelectBuilder(); $selectBuilder->select->addAll(Pap_Db_Table_Coupons::getInstance()); $selectBuilder->from->add(Pap_Db_Table_Coupons::getName()); $selectBuilder->where->add(Pap_Db_Table_Coupons::BANNERID, '=', $bannerID); $selectBuilder->where->add(Pap_Db_Table_Coupons::USERID, '=', $userID); $selectBuilder->limit->set(0, 1); return $selectBuilder->getAllRowsIterator(); }
/** * If userID is set, then return valid user coupons count, else unused valid coupons count * @param $userID * @return $count */ public function getValidCouponsCount($userID = null) { $select = $this->createCouponsSelect($userID); $select->select->addAll(Pap_Db_Table_Coupons::getInstance()); $coupon = new Pap_Db_Coupon(); $coupons = $coupon->loadCollectionFromRecordset($select->getAllRows()); $validCouponsCount = 0; foreach ($coupons as $coupon) { if($coupon->isValid()) { $validCouponsCount++; } } return $validCouponsCount; }
function init() { $this->setTable(Pap_Db_Table_Coupons::getInstance()); parent::init(); }