Esempio n. 1
0
 /**
  * 获取指定用户组允许查看游戏的合作商
  * @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;
 }