/**
* 获得权限总列表
* @return array
*
**/
public function AllParterPermissionList($fields, $group_id)
{
$oPartnerApp = new Config_Partner_App();
$oApp = new Config_App();
$oArea = new Config_Area();
//所有游戏信息，游戏id为键值
$AppList = $oApp->getAll("AppId,name");
//所有区域 二维数组 区域id为键值
$TotalArea = $oArea->getAll('AreaId,name');
//每个游戏所在的区域
$AreaList = $oPartnerApp->getAreaList();
//构造新数组，每个区域新添官服和专区
if (isset($TotalArea)) {
foreach ($TotalArea as $AreaId => $value) {
$TotalArea[$AreaId]['partner_type'] = array('1' => array('name' => '官服', 'permission' => 0), '2' => array('name' => '专区', 'permission' => 0));
}
}
//获取所有运营商 二维数组 键值默认排序
$PartnerAppList = $oPartnerApp->getAll($fields);
//构建数组 五维数组 键值依次是 游戏应用id(Appid) 区域id(AreaId) 合作商分类(partner_type) 服务商id(PartnerId) 服务商一维数组
//目的：把构建好的服务商数组赋给下面大循环
$PartnerAppAreaList = array();
foreach ($PartnerAppList as $k => $v) {
$v['permission'] = 0;
if ($v["PartnerId"] == 1) {
$PartnerAppAreaList[$v["AppId"]][$v["AreaId"]][1][] = $v;
} else {
$PartnerAppAreaList[$v["AppId"]][$v["AreaId"]][2][] = $v;
}
//$PartnerAppAreaList[$v["AppId"]][$v["AreaId"]][$v["PartnerId"]][]=$v;
}
$totalPartner = array();
$totalPartner['total'] = $TotalArea;
$partner = array();
if (is_array($PartnerAppList)) {
foreach ($PartnerAppList as $key => $value) {
//if(!isset($totalPartner['list'][$value['AppId']]))
//{
$name = $AppList[$value['AppId']]["name"];
$AppAreaList = array();
$AppAreaList = $TotalArea;
//为了不破坏$TotalArea数组
foreach ($AppAreaList as $AreaId => $Area) {
if (in_array($AreaId, $AreaList[$value["AppId"]])) {
foreach ($Area["partner_type"] as $k => $v) {
//判断游戏在某个区域内是否有运营商以及这个运营商是官服还是专区
//$ParnterType = $oPartnerApp->getPartnerId($value['AppId'],$AreaId);
if ($value["PartnerId"] == 1) {
$partnerList = $PartnerAppAreaList[$value["AppId"]][$AreaId][1];
$AppAreaList[$AreaId]["partner_type"][1]["partner"] = $partnerList;
} else {
$partnerList = $PartnerAppAreaList[$value["AppId"]][$AreaId][2];
$AppAreaList[$AreaId]["partner_type"][2]["partner"] = $partnerList;
}
}
} else {
unset($AppAreaList[$AreaId]);
}
}
$totalPartner['list'][$value['AppId']] = array('name' => $name, 'default' => $AppAreaList);
//}
/*if(!isset($totalPartner['list'][$value['AppId']]['partner'][$value['PartnerId']]))
{
$totalPartner['list'][$value['AppId']]['partner'][$value['PartnerId']] = $value;
}*/
}
}
//目的是删除没有运营商的官服和专区 和判断用户是否有权限
foreach ($totalPartner['list'] as $AppId => &$area_data) {
foreach ($area_data['default'] as $AreaId => &$area_data) {
foreach ($area_data['partner_type'] as $partner_type => &$partner_type_data) {
if ($partner_type_data["partner"] == null) {
unset($totalPartner['list'][$AppId]['default'][$AreaId]['partner_type'][$partner_type]);
} else {
foreach ($partner_type_data['partner'] as $key => &$partner_data) {
//($AppId,$AreaId,$PartnerId,$partner_type,$group_id)_id"
$permission = $this->getPermission($AppId, $AreaId, $partner_data['PartnerId'], $partner_type, $group_id);
$partner_data['permission'] = $permission['permission'];
}
}
}
}
}
return $totalPartner;
}
public function sendStatusAction()
{
$oPermission = new Config_Permission();
$oApp = new Config_App();
$oServer = new Config_Server();
$oPartnerApp = new Config_Partner_App();
$oPartner = new Config_Partner();
$oArea = new Config_Area();
//获取用户可以查看的游戏列表
$permitted_app = $oPermission->getApp($this->manager->data_groups, 'AppId,name');
//预处理地区信息
$AreaList = $oArea->getAll();
//检查当前页面权限
$sign = '?ctl=config/socket.queue&ac=send.status';
$this->manager->checkMenuPermission($sign, Widget_Manager::MENU_PURVIEW_SELECT);
$SocketType = $this->oSocketType->getAll();
//页面输入变量
$AppId = intval($this->request->AppId);
$PartnerId = intval($this->request->PartnerId);
$ServerId = intval($this->request->ServerId);
$AreaId = intval($this->request->AreaId) ? intval($this->request->AreaId) : 0;
$app_type = intval($this->request->app_type);
$partner_type = intval($this->request->partner_type);
$is_abroad = intval($this->request->is_abroad) ? intval($this->request->is_abroad) : 0;
$uType = intval($this->request->uType) ? intval($this->request->uType) : 0;
//时间范围初始化
$Date = $this->request->Date ? $this->request->Date : date("Y-m-d", time());
//初始化图表配置
$divideV = 23;
$Step = 60;
//初始化合作商列表
$permitted_partner = array();
//初始化服务器列表
$permitted_server = array();
//获取当前地区列表
$AreaList = $oArea->getAbroad($is_abroad, $AreaList);
//生成允许的地区id数组
if ($app_type > 0) {
//筛选是否平台产品
$permitted_app = $oApp->getApp($app_type, $permitted_app);
}
if ($AppId > 0) {
//获取可查看的权限总表
$permitted_partner = $oPermission->getPartner($this->manager->data_groups, $AppId, 'PartnerId,name,AreaId');
//根据合作方式筛选
$permitted_partner = $oPartnerApp->getPermittedPartnerByPartnerType($partner_type, $permitted_partner);
//根据所在地区筛选
$permitted_partner = $oPartnerApp->getPermittedPartnerByPartnerArea($AreaList, $permitted_partner);
if ($PartnerId > 0) {
//获取服务器列表
$permitted_server = $oPermission->getServer($this->manager->data_groups, $AppId, $PartnerId, 'ServerId,name');
}
}
//获取用于查询的权限sql语句
$SendStatusArr = $this->oSocketQueue->getSendStatus($Date, $ServerId, $uType);
for ($i = 0; $i < 24 * 60; $i++) {
$H = intval($i / 60);
$m = $i - $H * 60;
if (!isset($SendStatusArr[$i])) {
$SendStatusArr[$i] = array('Time' => sprintf("%02d", $H) . ":" . sprintf("%02d", $m), 'SendCount' => 0);
} else {
$SendStatusArr[$i]['Time'] = sprintf('%02d', $H) . ":" . sprintf('%02d', $m);
}
}
ksort($SendStatusArr);
# Include FusionCharts PHP Class
include 'Third/fusion/Includes/FusionCharts_Gen.php';
# Create Multiseries ColumnD chart object using FusionCharts PHP Class
$FC = new FusionCharts("MsLine", '100%', '500');
# Set the relative path of the swf file
$FC->setSWFPath("../Charts/");
# Store chart attributes in a variable
$strParam = "caption='Socket队列发送情况';animation=0;xAxisName='时间';baseFontSize=12;numberPrefix=;decimalPrecision=0;showValues=0;formatNumberScale=0;labelStep={$Step};numvdivlines={$divideV};rotateNames=1;yAxisMinValue=0;yAxisMaxValue=10;numDivLines=9;showAlternateHGridColor=1;alternateHGridAlpha=5;alternateHGridColor='CC3300'";
# Set chart attributes
$FC->setChartParams($strParam);
foreach ($SendStatusArr as $key => $data) {
$FC->addCategory($data['Time']);
}
$FC->addDataset("发送数量");
foreach ($SendStatusArr as $key => $data) {
$FC->addChartData($data['SendCount']);
}
$page_title = "Socket队列发送情况";
$page_form_action = $sign;
//调取模板
include $this->tpl('Config_SocketQueue_SendStatus');
}
public function getPayDay($StartDate, $EndDate, $PassageId, $oWherePartnerPermission)
{
//查询列
$select_fields = array('PayUser' => 'count(distinct(AcceptUserId))', 'PayCount' => 'count(*)', 'TotalCoin' => 'sum(Coin)', 'TotalAmount' => 'sum(Amount)', 'Date' => "from_unixtime(PayTime,'%Y-%m-%d')", 'AppId', 'PartnerId');
//分类统计列
$group_fields = array('Date', 'AppId', 'PartnerId');
//初始化查询条件
$whereStartDate = $StartDate ? " PayTime >= '" . strtotime($StartDate) . "' " : "";
$whereEndDate = $EndDate ? " PayTime <= '" . (strtotime($EndDate) + 86400 - 1) . "' " : "";
$wherePassage = $PassageId ? " PassageId = " . $PassageId . " " : "";
$whereCondition = array($whereStartDate, $whereEndDate, $oWherePartnerPermission, $wherePassage);
//生成查询列
$fields = Base_common::getSqlFields($select_fields);
//生成分类汇总列
$groups = Base_common::getGroupBy($group_fields);
//生成条件列
$where = Base_common::getSqlWhere($whereCondition);
$date = $StartDate;
//初始化结果数组
$StatArr['TotalData'] = array('TotalCoin' => 0, 'TotalAmount' => 0, 'PayUser' => 0, 'PayCount' => 0, 'ConvertedAmount' => 0);
do {
$StatArr['PayDate'][$date] = array('Total' => array('TotalCoin' => 0, 'TotalAmount' => 0, 'PayUser' => 0, 'PayCount' => 0, 'ConvertedAmount' => 0));
$date = date("Y-m-d", strtotime($date) + 86400);
} while (strtotime($date) <= strtotime($EndDate));
$DateStart = date("Ym", strtotime($StartDate));
$DateEnd = date("Ym", strtotime($EndDate));
$DateList = array();
$Date = $StartDate;
do {
$D = date("Ym", strtotime($Date));
$DateList[] = $D;
$Date = date("Y-m-d", strtotime("{$Date} +1 month"));
} while ($D != $DateEnd);
$oPartnerApp = new Config_Partner_App();
$oArea = new Config_Area();
foreach ($DateList as $key => $value) {
$table_name = Base_Widget::getDbTable($this->table_date) . "_" . $value;
$sql = "SELECT {$fields} FROM {$table_name} as log where 1 " . $where . $groups;
$PayDateArr = $this->db->getAll($sql);
if (is_array($PayDateArr)) {
foreach ($PayDateArr as $key => $Stat) {
if (!isset($PartnerAppList[$Stat['AppId']][$Stat['PartnerId']])) {
$PartnerAppList[$Stat['AppId']][$Stat['PartnerId']] = $oPartnerApp->getRow(array($Stat['PartnerId'], $Stat['AppId']));
}
if (!isset($AreaList[$PartnerAppList[$Stat['AppId']][$Stat['PartnerId']]['AreaId']])) {
$AreaList[$PartnerAppList[$Stat['AppId']][$Stat['PartnerId']]['AreaId']] = $oArea->getRow($PartnerAppList[$Stat['AppId']][$Stat['PartnerId']]['AreaId']);
}
$currency_rate = $AreaList[$PartnerAppList[$Stat['AppId']][$Stat['PartnerId']]['AreaId']]['currency_rate'];
//累加数据
if (isset($StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']])) {
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['PayCount'] += $Stat['PayCount'];
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['PayUser'] += $Stat['PayUser'];
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['TotalCoin'] += $Stat['TotalCoin'];
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['TotalAmount'] += $Stat['TotalAmount'];
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['ConvertedAmount'] += $Stat['TotalAmount'] * $currency_rate;
} else {
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']] = array('TotalCoin' => 0, 'TotalAmount' => 0, 'PayCount' => 0, 'PayUser' => 0, 'ConvertedAmount' => 0);
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['PayCount'] += $Stat['PayCount'];
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['PayUser'] += $Stat['PayUser'];
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['TotalCoin'] += $Stat['TotalCoin'];
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['TotalAmount'] += $Stat['TotalAmount'];
$StatArr['PayDate'][$Stat['Date']]['Detail'][$Stat['AppId']][$Stat['PartnerId']]['ConvertedAmount'] += $Stat['TotalAmount'] * $currency_rate;
}
$StatArr['PayDate'][$Stat['Date']]['Total']['PayCount'] += $Stat['PayCount'];
$StatArr['PayDate'][$Stat['Date']]['Total']['PayUser'] += $Stat['PayUser'];
$StatArr['PayDate'][$Stat['Date']]['Total']['ConvertedAmount'] += $Stat['TotalAmount'] * $currency_rate;
$StatArr['TotalData']['PayCount'] += $Stat['PayCount'];
$StatArr['TotalData']['ConvertedAmount'] += $Stat['TotalAmount'] * $currency_rate;
}
$StatArr['TotalData']['AmountPerPay'] = $StatArr['TotalData']['PayCount'] ? $StatArr['TotalData']['ConvertedAmount'] / $StatArr['TotalData']['PayCount'] : 0;
}
}
return $StatArr;
}
public function productQueueSendDetailAction()
{
$oArea = new Config_Area();
$oPartnerApp = new Config_Partner_App();
$oServer = new Config_Server();
$oPermission = new Config_Permission();
$oUser = new Lm_User();
$ProductSendTypeArr = $this->config->ProductSendTypeArr;
$ProductTypeArr = $this->config->ProductTypeArr;
//获取用户可以查看的游戏列表
$permitted_app = $oPermission->getApp($this->manager->data_groups, 'AppId,name');
$AreaList = $oArea->getAll();
set_time_limit(0);
$page = intval(max($this->request->page, 1));
//检查当前页面权限
$sign = '?ctl=config/product/product&ac=product.queue.send.detail';
$this->manager->checkMenuPermission($sign, Widget_Manager::MENU_PURVIEW_SELECT);
//页面输入变量
$AppId = intval($this->request->AppId);
$PartnerId = intval($this->request->PartnerId);
$PassageId = intval($this->request->PassageId);
$AreaId = intval($this->request->AreaId) ? intval($this->request->AreaId) : 0;
$UserName = $this->request->UserName;
$app_type = intval($this->request->app_type);
$partner_type = intval($this->request->partner_type);
$is_abroad = intval($this->request->is_abroad) ? intval($this->request->is_abroad) : 0;
//页面输入变量
$ProductSendType = $this->request->ProductSendType;
$ProductType = $this->request->ProductType;
//是否导出当前页面表格
$export = $this->request->export ? intval($this->request->export) : 0;
$pagesize = $export ? 0 : 20;
//初始化图表配置
$Input = array('UserName' => urlencode($UserName), 'AppId' => $AppId, 'PartnerId' => $PartnerId, 'ServerId' => $ServerId, 'ProductSendType' => $ProductSendType, 'export' => 1);
$export_var = "<a href =" . Base_Common::getUrl('', 'config/product/product', 'product.queue.send.detail', $Input) . "><导出表格></a>";
//初始化合作商列表
$permitted_partner = array();
//获取当前地区列表
$AreaList = $oArea->getAbroad($is_abroad, $AreaList);
//生成允许的地区id数组
if ($app_type > 0) {
//筛选是否平台产品
$permitted_app = $this->oApp->getApp($app_type, $permitted_app);
}
if ($AppId > 0) {
//获取可查看的权限总表
$permitted_partner = $oPermission->getPartner($this->manager->data_groups, $AppId, 'PartnerId,name,AreaId');
//根据合作方式筛选
$permitted_partner = $oPartnerApp->getPermittedPartnerByPartnerType($partner_type, $permitted_partner);
//根据所在地区筛选
$permitted_partner = $oPartnerApp->getPermittedPartnerByPartnerArea($AreaList, $permitted_partner);
if ($PartnerId > 0) {
//获取服务器列表
$permitted_server = $oPermission->getServer($this->manager->data_groups, $AppId, $PartnerId, 'ServerId,name');
}
}
if ($UserName) {
$UserInfo = $oUser->getUserByName($UserName);
if ($UserInfo['UserId']) {
$UserId = $UserInfo['UserId'];
} else {
$UserId = -1;
}
} else {
$UserId = 0;
}
$ProductSendQueueDetailArr = $this->oProduct->getProductSendQueueDetail($UserId, $ProductSendType, $ProductType, $ServerId, ($page - 1) * $pagesize, $pagesize);
$UserInfoList = array();
if (is_array($ProductSendQueueDetailArr['ProductSendQueueDetail'])) {
foreach ($ProductSendQueueDetailArr['ProductSendQueueDetail'] as $key => $value) {
if ($value['UserId']) {
if (!isset($UserInfoList[$value['UserId']])) {
$UserInfo = $oUser->getUserById($value['UserId']);
$UserInfoList[$value['UserId']] = $UserInfo;
}
}
if (!isset($ServerInfo[$value['ServerId']])) {
$ServerInfo[$value['ServerId']] = $oServer->getRow($value['ServerId']);
}
$Comment = json_decode($value['Comment'], true);
$ProductSendQueueDetailArr['ProductSendQueueDetail'][$key]['UserName'] = $value['UserId'] ? $UserInfoList[$value['UserId']]['UserName'] : "******";
$ProductSendQueueDetailArr['ProductSendQueueDetail'][$key]['ProductSendTypeName'] = $ProductSendTypeArr[$value['SendType']];
$ProductSendQueueDetailArr['ProductSendQueueDetail'][$key]['ProductTypeName'] = $ProductTypeArr[$value['ProductType']];
$ProductSendQueueDetailArr['ProductSendQueueDetail'][$key]['ServerName'] = $ServerInfo[$value['ServerId']]['name'];
}
}
$page_title = "道具发送队列详情";
$page_form_action = $sign;
//调取模板
include $this->tpl('Config_Product_ProductSendQueueDetail');
}
