public function update() { $update = new Gpf_SqlBuilder_UpdateBuilder(); $update->from->add(Pap_Db_Table_UserPayoutOptions::getName()); $update->set->add(Pap_Db_Table_UserPayoutOptions::VALUE, $this->get(Pap_Db_Table_UserPayoutOptions::VALUE)); $update->where->add(Pap_Db_Table_Users::ID, "=", $this->get(Pap_Db_Table_Users::ID)); $update->where->add(Gpf_Db_Table_FormFields::ID, "=", $this->get(Gpf_Db_Table_FormFields::ID)); $update->updateOne(); }
protected function buildData(Gpf_Data_RecordSet $fields, Gpf_Rpc_Params $params) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add("name", "payoutFieldName", "ff"); $select->select->add(Pap_Db_Table_UserPayoutOptions::VALUE, Pap_Db_Table_UserPayoutOptions::VALUE, "upo"); $select->select->add(Pap_Db_Table_UserPayoutOptions::FORMFIELDID, Pap_Db_Table_UserPayoutOptions::FORMFIELDID, "upo"); $select->from->add(Pap_Db_Table_Users::getName(), "pu"); $select->from->addInnerJoin(Gpf_Db_Table_FormFields::getName(), "ff", "(ff.formid = CONCAT('payout_option_', pu.payoutoptionid))"); $select->from->addInnerJoin(Pap_Db_Table_UserPayoutOptions::getName(), "upo", "(pu.userid = upo.userid AND ff.formfieldid = upo.formfieldid)"); $select->where->add("pu.userid", "=", $params->get('userid')); $i = 1; foreach ($select->getAllRowsIterator() as $payoutField) { $fields->add(array($payoutField->get(Pap_Db_Table_UserPayoutOptions::FORMFIELDID), 'data' . $i, $this->_($payoutField->get('payoutFieldName')), 'T', 'M', null, '')); $this->fieldValues['data' . $i++] = $payoutField->get(Pap_Db_Table_UserPayoutOptions::VALUE); } }
private function deletePayoutOptions() { $deleteBuilder = new Gpf_SqlBuilder_DeleteBuilder(); $deleteBuilder->from->add(Pap_Db_Table_UserPayoutOptions::getName()); $deleteBuilder->execute(); }
/** * @param Gpf_Data_Row $row * @return Gpf_SqlBuilder_SelectBuilder */ private function buildUserPayoutOptions(Gpf_Data_Row $row) { $select = new Gpf_SqlBuilder_SelectBuilder(); $select->select->add("userid", Pap_Db_Table_UserPayoutOptions::USERID, "pu"); $select->select->add("name", "payoutFieldName", "ff"); $select->select->add(Pap_Db_Table_UserPayoutOptions::VALUE, Pap_Db_Table_UserPayoutOptions::VALUE, "upo"); $select->select->add(Pap_Db_Table_UserPayoutOptions::FORMFIELDID, Pap_Db_Table_UserPayoutOptions::FORMFIELDID, "upo"); $select->from->add(Pap_Db_Table_Users::getName(), "pu"); $select->from->addInnerJoin(Gpf_Db_Table_FormFields::getName(), "ff", "(ff.formid = CONCAT('payout_option_', pu.payoutoptionid))"); $select->from->addInnerJoin(Pap_Db_Table_UserPayoutOptions::getName(), "upo", "(pu.userid = upo.userid AND ff.formfieldid = upo.formfieldid)"); $select->where->add("pu.userid", "=", $row->get('userid')); return $select; }