/** * 获取指定用户组允许查看游戏的合作商 * @param integer $data_groups * @param integer $AppId * @return array */ public function getPartner($data_groups, $AppId, $fields) { $returnArr = array(); //声明需要调取的partner_app类 $oPartnerAppData = new Config_Partner_App(); $AppId = abs(intval($AppId)); $data_groups = trim($data_groups); //查找指定data_groups的数据 $table_to_process = $this->getDbTable($this->table); $sql = "SELECT * from {$table_to_process} where group_id in ({$data_groups}) and (AppId = ? or AppId = 0) group by PartnerId,partner_type,AreaId,partner_type"; $level_partner = $this->db->getAll($sql, $AppId); if ($level_partner) { foreach ($level_partner as $key => $value) { $whereType = $oPartnerAppData->getWherePartnerType($value['partner_type']); $partner_data = $oPartnerAppData->getPartnerAppbyType($fields, $AppId, $value['PartnerId'], $value['AreaId'], $whereType); if (isset($partner_data)) { foreach ($partner_data as $k => $v) { if (!isset($returnArr[$v['PartnerId']])) { $returnArr[$v['PartnerId']] = $v; } } } } } return $returnArr; }