487 lines
21 KiB
PHP
487 lines
21 KiB
PHP
<?php
|
||
include_once("../../../inc/admin.inc.php");
|
||
include_once("../../../inc/class.php");
|
||
include_once("../../../inc/admin.smarty.php");
|
||
include_once("../../../inc/admin.power.php");
|
||
|
||
//房卡统计3种 会员统计
|
||
$GG['day'] = is_numeric($GG['day']) ? $GG['day'] : 30;
|
||
if($GG['type']=='on' && $GG['date']){
|
||
$where = " where InsertDateTime <= '".$GG['date']."' ";
|
||
}elseif($GG['type']=='yb' && $GG['date']){
|
||
$where = " where Day <= '".$GG['date']."' ";
|
||
}elseif($GG['date']){
|
||
$where = " where CollectDate <= '".$GG['date']."' ";
|
||
}
|
||
if($GG['type'] == 'on'){
|
||
$GG['date'] = $GG['date'] ? $GG['date'] : date('Y-m-d H:i:s');
|
||
//今天
|
||
$data = $db->fetch_all("select top ".$GG['day']." *,convert(char,InsertDateTime,120) as Date from QPPlatformDB.dbo.OnLineStreamInfo ".$where." order by ID desc");
|
||
if($data){
|
||
foreach($data as $k=>$v){
|
||
$info['rq'][] = date('H:i',strtotime($v['Date']));
|
||
$info['zx'][] = intval($v['OnLineCountSum']);
|
||
}
|
||
}
|
||
//昨天
|
||
$zt = date('Y-m-d H:i:s',strtotime($GG['date'])-86400);
|
||
$count_zt = $db->fetch_abc("select ConsumeScore from SystemStreamInfo where convert(varchar(10),CollectDate,120) = '".date('Y-m-d',strtotime($zt))."'");
|
||
$data_zt = $db->fetch_all("select top ".$GG['day']." *,convert(char,InsertDateTime,120) as Date from QPPlatformDB.dbo.OnLineStreamInfo where InsertDateTime <= '".$zt."' order by ID desc");
|
||
if($data_zt){
|
||
foreach($data_zt as $k=>$v){
|
||
$info_zt['zx'][] = intval($v['OnLineCountSum']);
|
||
}
|
||
}
|
||
//上周
|
||
$sz = date('Y-m-d H:i:s',strtotime($GG['date'])-86400*7);
|
||
$count_sz = $db->fetch_abc("select ConsumeScore from SystemStreamInfo where convert(varchar(10),CollectDate,120) = '".date('Y-m-d',strtotime($sz))."'");
|
||
$data_sz = $db->fetch_all("select top ".$GG['day']." *,convert(char,InsertDateTime,120) as Date from QPPlatformDB.dbo.OnLineStreamInfo where InsertDateTime <= '".$sz."' order by ID desc");
|
||
if($data_sz){
|
||
foreach($data_sz as $k=>$v){
|
||
$info_sz['zx'][] = intval($v['OnLineCountSum']);
|
||
}
|
||
}
|
||
//历史最高
|
||
$zdc = $db->fetch_one("select ConsumeScore,convert(varchar(10),CollectDate,120) as Date from SystemStreamInfo order by ConsumeScore desc");
|
||
$zd = $zdc['Date']." ".date('H:i:s',strtotime($GG['date']));
|
||
//echo $sz."|".$zd;
|
||
$count_zd = $zdc['ConsumeScore'];
|
||
$data_zd = $db->fetch_all("select top ".$GG['day']." *,convert(char,InsertDateTime,120) as Date from QPPlatformDB.dbo.OnLineStreamInfo where InsertDateTime <= '".$zd."' order by ID desc");
|
||
if($data_zd){
|
||
foreach($data_zd as $k=>$v){
|
||
$info_zd['zx'][] = intval($v['OnLineCountSum']);
|
||
}
|
||
}
|
||
//输出
|
||
$count = $db->fetch_abc("select ConsumeScore from SystemStreamInfo where convert(varchar(10),CollectDate,120) = '".date('Y-m-d',strtotime($GG['date']))."'");
|
||
$dat = ["date" => json_encode(array_reverse($info['rq']))];
|
||
$dat["title"] = "会员在线";
|
||
$dat["txt"] = [
|
||
date('Y-m-d',strtotime($GG['date'])).'（'.$count.'）',
|
||
date('Y-m-d',strtotime($zt)).'（'.$count_zt.'）',
|
||
date('Y-m-d',strtotime($sz)).'（'.$count_sz.'）',
|
||
date('Y-m-d',strtotime($zd)).'（'.$count_zd.'）'
|
||
];
|
||
$dat["data"] = [
|
||
[json_encode(array_reverse($info['zx']))],
|
||
[json_encode(array_reverse($info_zt['zx']))],
|
||
[json_encode(array_reverse($info_sz['zx']))],
|
||
[json_encode(array_reverse($info_zd['zx']))],
|
||
];
|
||
}elseif($GG['type'] == 'fang'){
|
||
if($GG['date']){
|
||
$day = date('Y-m-d',strtotime($GG['date'])-30*86400);
|
||
}else{
|
||
$day = date('Y-m-d',strtotime("-".$GG['day']." day"));
|
||
}
|
||
//公会房卡
|
||
$gh = $db->fetch_all("select top 30 UnionDay as Date,count(*) as num,sum(FCount) as card from QPTreasureDB.dbo.GameUnionDay where UnionDay>'".$day."' group by UnionDay order by Date asc");
|
||
if($gh){
|
||
foreach($gh as $k=>$v){
|
||
$ghs[$v['Date']] = $v['card'];
|
||
}
|
||
}
|
||
//普通房卡
|
||
$pt = $db->fetch_all("select top 30 convert(char(10),CostTime,120) as Date,count(*) as num,sum(CostScore) as card from QPTreasureDB.dbo.GameScoreLog where convert(char(10),CostTime,120)>'".$day."' and CostScore<0 group by convert(char(10),CostTime,120) order by Date asc");
|
||
if($pt){
|
||
foreach($pt as $k=>$v){
|
||
$ptkf[] = abs($v['card']);
|
||
$date[] = $v['Date'];
|
||
$ghkf[] = intval($ghs[$v['Date']]);
|
||
$count[] = intval(abs($v['card'])+intval($ghs[$v['Date']]));
|
||
}
|
||
}
|
||
$dat = ["date" => json_encode($date)];
|
||
$dat["title"] = "房卡统计";
|
||
$dat["txt"] = ['总房卡','普通房卡','公会房卡'];
|
||
$dat["data"] = [
|
||
[json_encode($count)],
|
||
[json_encode($ptkf)],
|
||
[json_encode($ghkf)],
|
||
];
|
||
|
||
}elseif($GG['type'] == 'yuebao'){
|
||
for($y=0;$y<12;$y++){
|
||
$ye = date("Y-m",strtotime('-'.$y.' month'));
|
||
if($ye > '2017-02'){
|
||
$info['rq'][] = $ye;
|
||
$data = $db->fetch_one("select sum(ConsumeScore) as fk,sum(GameLogonSuccess) as dl,sum(ActiveUserNum) as hy from SystemStreamInfo where convert(varchar(7),CollectDate,120)='".$ye."'");
|
||
if($ye == date('Y-m')){
|
||
$day = intval(date("d"));
|
||
}else{
|
||
$day = date("t",strtotime($ye));
|
||
}
|
||
$info['fk'][] = intval($data['fk']/$day);
|
||
$info['dl'][] = intval($data['dl']/$day);
|
||
$info['hy'][] = intval($data['hy']/$day);
|
||
$info['zc'][] = intval($db->fetch_abc("select count(*) from AccountsInfo where convert(varchar(7),RegisterDate,120)='".$ye."'"));
|
||
}
|
||
}
|
||
//print_r($info);exit;
|
||
$dat = ["date" => json_encode(array_reverse($info['rq']))];
|
||
$dat["title"] = "月报平均值";
|
||
$dat["txt"] = ['平均每日房卡','平均每日活跃人数','平均每日登录次数','当月注册人数'];
|
||
$dat["data"] = [
|
||
[json_encode(array_reverse($info['fk']))],
|
||
[json_encode(array_reverse($info['hy']))],
|
||
[json_encode(array_reverse($info['dl']))],
|
||
[json_encode(array_reverse($info['zc']))],
|
||
];
|
||
}elseif($GG['type'] == 'cw'){
|
||
for($y=0;$y<12;$y++){
|
||
$ye = date("Y-m",strtotime('-'.$y.' month'));
|
||
if($ye > '2018-12'){
|
||
$info['rq'][] = $ye;
|
||
$info['sr'][] = intval($db->fetch_abc("select sum(PayMoney) from AgentRecharge where convert(varchar(7),AddDate,120)='".$ye."' and PayMoney>0"));
|
||
$info['kx'][] = intval(abs($db->fetch_abc("select sum(PayMoney) from AgentRecharge where convert(varchar(7),AddDate,120)='".$ye."' and PayMoney<0")));
|
||
$info['fk'][] = intval(abs($db->fetch_abc("select sum(OperCount) from AgentRecharge where convert(varchar(7),AddDate,120)='".$ye."'")));
|
||
//$info['dl'][] = intval(abs($db->fetch_abc("select sum(OperNum) from QPTreasureDB.dbo.PayToPlayerLog where convert(varchar(7),InsertTime,120)='".$ye."'")));
|
||
$info['xf'][] = intval(abs($db->fetch_abc("select sum(ConsumeScore) from SystemStreamInfo where convert(varchar(7),CollectDate,120)='".$ye."'")));
|
||
}
|
||
}
|
||
$dat = ["date" => json_encode(array_reverse($info['rq']))];
|
||
$dat["title"] = "财务统计";
|
||
$dat["txt"] = ['充值金额','卖出房卡','消费房卡','开支金额'];
|
||
$dat["data"] = [
|
||
[json_encode(array_reverse($info['sr']))],
|
||
[json_encode(array_reverse($info['fk']))],
|
||
[json_encode(array_reverse($info['xf']))],
|
||
[json_encode(array_reverse($info['kx']))],
|
||
//[json_encode(array_reverse($info['dl']))],
|
||
];
|
||
//print_r($dat);$exit;
|
||
}elseif($GG['type'] == 'yb'){
|
||
$data = $db->fetch_all("select top ".$GG['day']." * from YuanBaoDay ".$where." order by YbdID desc");
|
||
if($data){
|
||
foreach($data as $k=>$v){
|
||
$info['rq'][] = $v['Day'];
|
||
$info['cj'][] = intval($v['Lottery']);
|
||
$info['rhd'][] = intval($v['Days']);
|
||
$info['xf'][] = intval($v['XYuanBao']);
|
||
}
|
||
}
|
||
$dat = ["date" => json_encode(array_reverse($info['rq']))];
|
||
$dat["title"] = "元宝统计";
|
||
$dat["txt"] = ['抽奖','日活动','消费'];
|
||
$dat["data"] = [
|
||
[json_encode(array_reverse($info['cj']))],
|
||
[json_encode(array_reverse($info['rhd']))],
|
||
[json_encode(array_reverse($info['xf']))],
|
||
];
|
||
}elseif($GG['type'] == 'yby'){
|
||
for($y=0;$y<12;$y++){
|
||
$ye = date("Y-m",strtotime('-'.$y.' month'));
|
||
if($ye > '2017-05'){
|
||
$info['rq'][] = $ye;
|
||
$info['cj'][] = intval($db->fetch_abc("select sum(Lottery) from YuanBaoDay where convert(varchar(7),Day,120)='".$ye."'"));
|
||
$info['hd'][] = intval($db->fetch_abc("select sum(Days+Month) from YuanBaoDay where convert(varchar(7),Day,120)='".$ye."'"));
|
||
$info['xf'][] = intval($db->fetch_abc("select sum(XYuanBao) from YuanBaoDay where convert(varchar(7),Day,120)='".$ye."'"));
|
||
}
|
||
}
|
||
$dat = ["date" => json_encode(array_reverse($info['rq']))];
|
||
$dat["title"] = "元宝月统计";
|
||
$dat["txt"] = ['抽奖','活动','消费'];
|
||
$dat["data"] = [
|
||
[json_encode(array_reverse($info['cj']))],
|
||
[json_encode(array_reverse($info['hd']))],
|
||
[json_encode(array_reverse($info['xf']))],
|
||
];
|
||
}elseif($GG['type'] == 'fky'){
|
||
for($y=0;$y<12;$y++){
|
||
$ye = date("Y-m",strtotime('-'.$y.' month'));
|
||
if($ye > '2017-04'){
|
||
$info['rq'][] = $ye;
|
||
$data = $db->fetch_one("select sum(GameRule0Num) as yh,sum(GameRule1Num) as ybd,sum(GameRule2Num) as hz,sum(GameRule3Num) as ddz,sum(GameRule4Num) as nna,sum(GameRule5Num) as nnb,sum(GameRule6Num) as nnc,sum(GameRule7Num) as dza,sum(GameRule8Num) as dzb,sum(GameRule9Num) as ssa,sum(GameRule10Num) as ssb,sum(GameRule11Num) as ssc,sum(GameRule12Num) as ssd,sum(GameRule13Num) as zjh,sum(GameRule14Num) as pdka,sum(GameRule15Num) as pdkb from SystemStreamInfo where convert(varchar(7),CollectDate,120)='".$ye."'");
|
||
|
||
$info['mj'][] = intval($data['yh']+$data['ybd']+$data['hz']);
|
||
$info['ddz'][] = intval($data['ddz']);
|
||
$info['nn'][] = intval($data['nna']+$data['nnb']+$data['nnc']);
|
||
$info['dz'][] = intval($data['dza']+$data['dzb']);
|
||
$info['ss'][] = intval($data['ssa']+$data['ssb']+$data['ssc']+$data['ssd']);
|
||
$info['zjh'][] = intval($data['zjh']);
|
||
$info['pdk'][] = intval($data['pdka']+$data['pdkb']);
|
||
}
|
||
}
|
||
$bd_mj = intval(end(array_reverse($info['mj']))*0.65);
|
||
$bd_ddz = intval(end(array_reverse($info['ddz']))*0.65);
|
||
$bd_nn = intval(end(array_reverse($info['nn']))*0.65);
|
||
$bd_dz = intval(end(array_reverse($info['dz']))*0.65);
|
||
$bd_ss = intval(end(array_reverse($info['ss']))*0.65);
|
||
$bd_zjh = intval(end(array_reverse($info['zjh']))*0.65);
|
||
$bd_pdk = intval(end(array_reverse($info['pdk']))*0.65);
|
||
$ppxq -> assign('qb_data',[
|
||
'day'=>intval($bd_mj+$bd_ddz+$bd_nn+$bd_dz+$bd_ss+$bd_zjh+$bd_pdk),
|
||
'days'=>intval(current(array_slice(array_reverse($info['mj']),-2))+current(array_slice(array_reverse($info['ddz']),-2))+current(array_slice(array_reverse($info['pdk']),-2))+current(array_slice(array_reverse($info['nn']),-2))+current(array_slice(array_reverse($info['dz']),-2))+current(array_slice(array_reverse($info['ss']),-2)))*0.65,
|
||
'mj'=>intval(array_sum(array_reverse($info['mj']))*0.65),
|
||
'ddz'=>intval(array_sum(array_reverse($info['ddz']))*0.65),
|
||
'pdk'=>intval(array_sum(array_reverse($info['pdk']))*0.65),
|
||
'nn'=>intval(array_sum(array_reverse($info['nn']))*0.65),
|
||
'dz'=>intval(array_sum(array_reverse($info['dz']))*0.65),
|
||
'ss'=>intval(array_sum(array_reverse($info['ss']))*0.65),
|
||
'zjh'=>intval(array_sum(array_reverse($info['zjh']))*0.65)]);
|
||
|
||
$dat = ["date" => json_encode(array_reverse($info['rq']))];
|
||
$dat["title"] = "游戏月报";
|
||
$dat["txt"] = ['麻将'.number_format($bd_mj).'元',
|
||
'斗地主'.number_format($bd_ddz).'元',
|
||
'牛牛'.number_format($bd_nn).'元',
|
||
'打炸'.number_format($bd_dz).'元',
|
||
'十三张'.number_format($bd_ss).'元',
|
||
'炸金花'.number_format($bd_zjh).'元',
|
||
'跑得快'.number_format($bd_pdk).'元'];
|
||
$dat["data"] = [
|
||
[json_encode(array_reverse($info['mj']))],
|
||
[json_encode(array_reverse($info['ddz']))],
|
||
[json_encode(array_reverse($info['nn']))],
|
||
[json_encode(array_reverse($info['dz']))],
|
||
[json_encode(array_reverse($info['ss']))],
|
||
[json_encode(array_reverse($info['zjh']))],
|
||
[json_encode(array_reverse($info['pdk']))],
|
||
];
|
||
$ppxq -> assign('b_day',date("t"));//本月天数
|
||
$ppxq -> assign('d_day',intval(date("d")));//当月天数
|
||
$ppxq -> assign('s_day',date("t",strtotime('-1 month')));//上月天数
|
||
|
||
}elseif($GG['type'] == 'fkr'){
|
||
for($y=0;$y<=12;$y++){
|
||
$ye = date("Y-m",strtotime('-'.$y.' month'));
|
||
if($ye > '2017-04'){
|
||
$info['rq'][] = $ye;
|
||
$data = $db->fetch_one("select sum(GameRule0Num) as yh,sum(GameRule1Num) as ybd,sum(GameRule2Num) as hz,sum(GameRule3Num) as ddz,sum(GameRule4Num) as nna,sum(GameRule5Num) as nnb,sum(GameRule6Num) as nnc,sum(GameRule7Num) as dza,sum(GameRule8Num) as dzb,sum(GameRule9Num) as ssa,sum(GameRule10Num) as ssb,sum(GameRule11Num) as ssc,sum(GameRule12Num) as ssd,sum(GameRule13Num) as zjh,sum(GameRule14Num) as pdka,sum(GameRule15Num) as pdkb from SystemStreamInfo where convert(varchar(7),CollectDate,120)='".$ye."'");
|
||
if($ye == date('Y-m')){
|
||
$day = intval(date("d"));
|
||
}else{
|
||
$day = date("t",strtotime($ye));
|
||
}
|
||
$info['mj'][] = intval(($data['yh']+$data['ybd']+$data['hz'])/$day);
|
||
$info['ddz'][] = intval($data['ddz']/$day);
|
||
$info['nn'][] = intval(($data['nna']+$data['nnb']+$data['nnc'])/$day);
|
||
$info['dz'][] = intval(($data['dza']+$data['dzb'])/$day);
|
||
$info['ss'][] = intval(($data['ssa']+$data['ssb']+$data['ssc']+$data['ssd'])/$day);
|
||
$info['zjh'][] = intval(($data['zjh'])/$day);
|
||
$info['pdk'][] = intval(($data['pdka']+$data['pdkb'])/$day);
|
||
}
|
||
}
|
||
$bd_mj = end(array_reverse($info['mj']));
|
||
$bd_ddz = end(array_reverse($info['ddz']));
|
||
$bd_nn = end(array_reverse($info['nn']));
|
||
$bd_dz = end(array_reverse($info['dz']));
|
||
$bd_ss = end(array_reverse($info['ss']));
|
||
$bd_zjh = end(array_reverse($info['zjh']));
|
||
$bd_pdk = end(array_reverse($info['pdk']));
|
||
$bd_zh = intval($bd_mj+$bd_ddz+$bd_nn+$bd_dz+$bd_ss+$bd_zjh+$bd_pdk);
|
||
$dat = ["date" => json_encode(array_reverse($info['rq']))];
|
||
$dat["title"] = "游戏日报";
|
||
$dat["txt"] = ['麻将'.number_format($bd_mj/$bd_zh*100,2).'%',
|
||
'斗地主'.number_format($bd_ddz/$bd_zh*100,2).'%',
|
||
'牛牛'.number_format($bd_nn/$bd_zh*100,2).'%',
|
||
'打炸'.number_format($bd_dz/$bd_zh*100,2).'%',
|
||
'十三张'.number_format($bd_ss/$bd_zh*100,2).'%',
|
||
'炸金花'.number_format($bd_zjh/$bd_zh*100,2).'%',
|
||
'跑得快'.number_format($bd_pdk/$bd_zh*100,2).'%'];
|
||
$dat["data"] = [
|
||
[json_encode(array_reverse($info['mj']))],
|
||
[json_encode(array_reverse($info['ddz']))],
|
||
[json_encode(array_reverse($info['nn']))],
|
||
[json_encode(array_reverse($info['dz']))],
|
||
[json_encode(array_reverse($info['ss']))],
|
||
[json_encode(array_reverse($info['zjh']))],
|
||
[json_encode(array_reverse($info['pdk']))],
|
||
];
|
||
$ppxq -> assign('qbr_data',[
|
||
'mj' => number_format($bd_mj*0.65),
|
||
'ddz' => number_format($bd_ddz*0.65),
|
||
'nn' => number_format($bd_nn*0.65),
|
||
'dz' => number_format($bd_dz*0.65),
|
||
'ss' => number_format($bd_ss*0.65),
|
||
'zjh' => number_format($bd_zjh*0.65),
|
||
'pdk' => number_format($bd_pdk*0.65),
|
||
'zh' => $bd_zh*0.65
|
||
]);
|
||
}else{
|
||
$data = $db->fetch_all("select top ".$GG['day']." *,convert(char,CollectDate,120) as Date from SystemStreamInfo ".$where." order by DateID desc");
|
||
if($data){
|
||
foreach($data as $k=>$v){
|
||
$info['rq'][] = date('m-d',strtotime($v['Date']));
|
||
$info['dl'][] = $v['GameLogonSuccess'];
|
||
$info['hy'][] = $v['ActiveUserNum'];
|
||
$info['zc'][] = $v['GameRegisterSuccess'];
|
||
$info['fk'][] = intval($v['ConsumeScore']);
|
||
$info['fk0'][] = intval($v['GameRule0Num']);
|
||
$info['fk1'][] = intval($v['GameRule1Num']);
|
||
$info['fk2'][] = intval($v['GameRule2Num']);
|
||
$info['fk3'][] = intval($v['GameRule3Num']);
|
||
$info['fk4'][] = intval($v['GameRule4Num']);
|
||
$info['fk5'][] = intval($v['GameRule5Num']);
|
||
$info['fk6'][] = intval($v['GameRule6Num']);
|
||
$info['fk7'][] = intval($v['GameRule7Num']);
|
||
$info['fk8'][] = intval($v['GameRule8Num']);
|
||
$info['fk9'][] = intval($v['GameRule9Num']);
|
||
$info['fk10'][] = intval($v['GameRule10Num']);
|
||
$info['fk11'][] = intval($v['GameRule11Num']);
|
||
$info['fk12'][] = intval($v['GameRule12Num']);
|
||
$info['fk13'][] = intval($v['GameRule13Num']);
|
||
$info['fk14'][] = intval($v['GameRule14Num']);
|
||
$info['fk15'][] = intval($v['GameRule15Num']);
|
||
}
|
||
}
|
||
//print_r($data);
|
||
//exit;
|
||
$dat = ["date" => json_encode(array_reverse($info['rq']))];
|
||
if($GG['type']){
|
||
$dat["title"] = "会员".$GG['day']."天统计";
|
||
if($GG['data']){
|
||
$gg_data = explode(",",$GG['data']);
|
||
foreach($gg_data as $k => $v){
|
||
if($v == 'dl'){
|
||
$dat["txt"][] = '会员登录';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['dl']));
|
||
}elseif($v == 'zc'){
|
||
$dat["txt"][] = '会员注册';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['zc']));
|
||
}elseif($v == 'hy'){
|
||
$dat["txt"][] = '会员活跃';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['hy']));
|
||
}
|
||
}
|
||
}
|
||
if(!$dat["txt"]){
|
||
$dat["txt"][] = '会员活跃';
|
||
$dat["url"][] = 'hy';
|
||
$dat["data"][] = json_encode(array_reverse($info['hy']));
|
||
}
|
||
}else{
|
||
$dat["title"] = "房卡".$GG['day']."天统计";
|
||
if($GG['data']){
|
||
$gg_data = explode(",",$GG['data']);
|
||
foreach($gg_data as $k => $v){
|
||
if($v == 'fk-hz'){
|
||
$dat["txt"][] = '万年混子';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk2']));
|
||
}elseif($v == 'fk-ybd'){
|
||
$dat["txt"][] = '一边倒';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk1']));
|
||
}elseif($v == 'fk-yh'){
|
||
$dat["txt"][] = '硬胡';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk0']));
|
||
}elseif($v == 'fk-ddz'){
|
||
$dat["txt"][] = '斗地主';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk3']));
|
||
}elseif($v == 'fk-bwz'){
|
||
$dat["txt"][] = '霸王庄';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk4']));
|
||
}elseif($v == 'fk-qz'){
|
||
$dat["txt"][] = '抢庄';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk5']));
|
||
}elseif($v == 'fk-pcd'){
|
||
$dat["txt"][] = '拼刺刀';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk6']));
|
||
}elseif($v == 'fk-dz'){
|
||
$dat["txt"][] = '不带王打炸';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk7']));
|
||
}elseif($v == 'fk-dzw'){
|
||
$dat["txt"][] = '带王打炸';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk8']));
|
||
}elseif($v == 'fk-ssqz'){
|
||
$dat["txt"][] = '抢庄';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk9']));
|
||
}elseif($v == 'fk-sslz'){
|
||
$dat["txt"][] = '轮庄';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk10']));
|
||
}elseif($v == 'fk-ssbw'){
|
||
$dat["txt"][] = '霸王庄';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk11']));
|
||
}elseif($v == 'fk-ssjd'){
|
||
$dat["txt"][] = '经典';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk12']));
|
||
}elseif($v == 'fk-zjh'){
|
||
$dat["txt"][] = '炸金花';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk13']));
|
||
}elseif($v == 'fk-pdk15'){
|
||
$dat["txt"][] = '跑得快15张';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk14']));
|
||
}elseif($v == 'fk-pdk16'){
|
||
$dat["txt"][] = '跑得快16张';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk15']));
|
||
}elseif($v == 'fk'){
|
||
$dat["txt"][] = '房卡消耗';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk']));
|
||
}
|
||
}
|
||
}
|
||
if(!$dat["txt"]){
|
||
$dat["txt"][] = '房卡消耗';
|
||
$dat["url"][] = $v;
|
||
$dat["data"][] = json_encode(array_reverse($info['fk']));
|
||
}
|
||
if($GG['data'] == 'fk' || !$GG['data']){
|
||
//$day = date('Y-m-d');
|
||
//$shi = date('Y-m-d H:i:s');
|
||
$zday = date('Y-m-d',time()-86400);
|
||
$zshi = date('Y-m-d H:i:s',time()-86400);
|
||
$qday = date('Y-m-d',time()-172800);
|
||
$qshi = date('Y-m-d H:i:s',time()-172800);
|
||
//echo $zday." - ".$zshi;
|
||
//$day_count = $db->fetch_abc("SELECT count(*) from QPTreasureDB.dbo.PrivateGameRecordChild where convert(varchar(10),InsertTime,120) = '".$day."' and convert(varchar(19),InsertTime,120) < '".$shi."'");
|
||
$zday_count = $db->fetch_abc("SELECT count(*) from QPTreasureDB.dbo.PrivateGameRecordChild where convert(varchar(10),InsertTime,120) = '".$zday."' and convert(varchar(19),InsertTime,120) < '".$zshi."'");
|
||
$qday_count = $db->fetch_abc("SELECT count(*) from QPTreasureDB.dbo.PrivateGameRecordChild where convert(varchar(10),InsertTime,120) = '".$qday."' and convert(varchar(19),InsertTime,120) < '".$qshi."'");
|
||
//echo $zday_count;
|
||
//今天预计计算
|
||
if(intval(date('H')) > 5){
|
||
$jshk = $info['fk'][0]-ceil($zday_count/8)+$info['fk'][1];
|
||
//$jshks = $info['fk'][0]-ceil($qday_count/8)+$info['fk'][2];
|
||
//if($jshk > $jshks){
|
||
$dat["txt"][0] = "今日预计（".$jshk."）";
|
||
//}else{
|
||
// $dat["txt"][0] = "今日预计（".$jshks."）";
|
||
//}
|
||
}else{
|
||
$dat["txt"][0] = "今日耗卡（计算）";
|
||
}
|
||
//$dat["txt"][1] = '今日';
|
||
//for($i=0;$i<30;$i++){
|
||
// $day_data[] = ceil($day_count/8);
|
||
//}
|
||
//$dat["data"][1] = json_encode($day_data);
|
||
$dat["txt"][] = '昨日当时耗卡';
|
||
for($i=0;$i<29;$i++){
|
||
$zday_data[] = ceil($zday_count/8);
|
||
}
|
||
$dat["data"][] = json_encode($zday_data);
|
||
$dat["txt"][] = '前日当时耗卡';
|
||
for($i=0;$i<28;$i++){
|
||
$qday_data[] = ceil($qday_count/8);
|
||
}
|
||
$dat["data"][] = json_encode($qday_data);
|
||
}
|
||
}
|
||
}
|
||
//print_r($dat);
|
||
//$ppxq -> assign('color',['#ad6bae','#25a6f7','#ff6600','#f3950d']);
|
||
$ppxq -> assign('color',['#993300','#ff6600','#6666ff','#cc00ff','#009900','#cc6666','#00ccff']);
|
||
$ppxq -> assign('data',$dat);
|
||
$ppxq -> assign('GG',$GG);
|
||
$ppxq -> display('user/count-chart.tpl');
|
||
$db->close();
|
||
unset($GG,$ppxq,$db);
|
||
?>
|