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;
}
