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