/**
* returns recordset with setting values for given setting names (array) and given account
*
* @param settingNamesArray array
* @param accountId
* @return Gpf_Data_RecordSet
*/
public function getSettings($settingNames, $accountId)
{
if (!is_array($settingNames) || count($settingNames) <= 0) {
throw new Gpf_Exception("getSettings(): parameter settingNames is empty or not an array!");
}
$result = new Gpf_Data_IndexedRecordSet('name');
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('name', 'name');
$selectBuilder->select->add('value', 'value');
$selectBuilder->from->add(self::getName());
$selectBuilder->where->add("accountid", "=", $accountId);
$names = "";
foreach ($settingNames as $name) {
$names .= ($names != "" ? "," : '') . "'" . $name . "'";
}
$names = "(" . $names . ")";
$selectBuilder->where->add("name", 'in', $settingNames);
$result->load($selectBuilder);
return $result;
}
/**
*
* @param $userID
* @return Gpf_Data_IndexedRecordSet
*/
private function getPap3UserPayoutData($userID) {
$selectBuilder = new Gpf_SqlBuilder_SelectBuilder();
$selectBuilder->select->add('code', 'code');
$selectBuilder->select->add('value', 'value');
$selectBuilder->from->add('wd_g_settings');
$selectBuilder->where->add('userid', '=', $userID);
$selectBuilder->where->add('id2', '=', null);
$condition = new Gpf_SqlBuilder_CompoundWhereCondition();
$condition->add('code', 'LIKE', 'Aff_payoptionfield_%', 'OR');
$condition->add('code', '=', 'Aff_payout_type', 'OR');
$selectBuilder->where->addCondition($condition);
$pap3PayoutSettings = new Gpf_Data_IndexedRecordSet('code');
$pap3PayoutSettings->load($selectBuilder);
return $pap3PayoutSettings;
}
