/**
* @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();
}
