/**
* @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();
}
protected function buildFrom() {
$this->_selectBuilder->from->add(Pap_Db_Table_Coupons::getName(), 'c');
$this->_selectBuilder->from->addInnerJoin(Pap_Db_Table_Users::getName(),
'pu', 'pu.'.Pap_Db_Table_Users::ID.'=c.'.Pap_Db_Table_Coupons::USERID);
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_Users::getName(),
'gu', 'pu.'.Pap_Db_Table_Users::ACCOUNTUSERID.'=gu.'.Gpf_Db_Table_Users::ID);
$this->_selectBuilder->from->addInnerJoin(Gpf_Db_Table_AuthUsers::getName(),
'au', 'au.'.Gpf_Db_Table_AuthUsers::ID.'=gu.'.Gpf_Db_Table_Users::AUTHID);
}
/**
* @service coupon write
* @param ids, status
* @return Gpf_Rpc_Action
*/
public function changeStatus(Gpf_Rpc_Params $params) {
$action = new Gpf_Rpc_Action($params);
$action->setInfoMessage($this->_("Status successfully set to selected coupon(s)"));
$action->setErrorMessage($this->_("Failed to set status selected coupon(s)"));
$update = new Gpf_SqlBuilder_UpdateBuilder();
$update->from->add(Pap_Db_Table_Coupons::getName());
$update->set->add(Pap_Db_Table_Coupons::STATUS, $action->getParam("status"));
foreach ($action->getIds() as $id){
$update->where->add(Pap_Db_Table_Coupons::ID, "=", $id, "OR");
}
try {
$update->execute();
$action->addOk();
} catch(Gpf_DbEngine_NoRowException $e) {
$action->addError();
}
return $action;
}
/**
* @param $userID
* @return Gpf_SqlBuilder_SelectBuilder
*/
private function createCouponsSelect($userID = null) {
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->from->add(Pap_Db_Table_Coupons::getName());
$select->where->add(Pap_Db_Table_Coupons::BANNERID, '=', $this->getId());
$select->where->add(Pap_Db_Table_Coupons::USERID, '=', $userID);
return $select;
}
private function deleteAllCoupons() {
$delete = new Gpf_SqlBuilder_DeleteBuilder();
$delete->from->add(Pap_Db_Table_Coupons::getName());
$delete->execute();
}
