<?php
include_once("../../../inc/admin.inc.php");
include_once("../../../inc/class.php");
include_once("../../../inc/admin.smarty.php");
include_once("../../../inc/admin.power.php");
$lottery_game = 200;//超出200不累计
if($GG['js']){
	echo date('Y-m-d H:i:s')."<br>";
$where = " where a.Bj='0' ";
$table = "QPTreasureDB.dbo.PrivateGameRecordChild";
$sql = "SELECT top 100 RecordChildID,UserScore,convert(char,InsertTime,120) as Date,RecordID,Bj,
(SELECT b.UserID FROM QPTreasureDB.dbo.PrivateGameRecordUserRecordID as b WHERE b.RecordID=a.RecordID order by b.InsertTime asc FOR XML PATH('')) AS StuList 
,(SELECT top 1 b.KindID FROM QPTreasureDB.dbo.PrivateGameRecordUserRecordID as b WHERE b.RecordID=a.RecordID) AS KindID 
FROM QPTreasureDB.dbo.PrivateGameRecordChild a ".$where." group by RecordChildID,RecordID,Bj,UserScore,InsertTime order by InsertTime asc";
$count = "select count(*) from ".$table." ".str_ireplace("a.","",$where);
$data = $db->fetch_all($sql);
if($data){
	$zhit = 0;
	foreach($data as $k => $v){
		$info[$k]['data'] = $v;
		$info[$k]['Score'] = explode(",",$v['UserScore']);
		if($v['StuList']){
			$userstr = str_replace('<UserID>','',$v['StuList']);
	    $info[$k]['users'] = $user_arr = array_filter(explode("</UserID>",$userstr));
	    foreach($user_arr as $ku => $vu){
	    	//是否记录
	    	$is_cday = $db->fetch_one("select * from CountUserJf where UserID='".$vu."' and Days='".date('Y-m-d',strtotime($v['Date']))."'");
	    	if($is_cday){
	    		$save = ['Hit'=>($is_cday['Hit']+1),'Jf'=>($is_cday['Jf']+$info[$k]['Score'][$ku])];
	    		if($info[$k]['Score'][$ku]>0){
	    			$save['Jfz'] = $is_cday['Jfz']+$info[$k]['Score'][$ku];
	    		}else{
	    			$save['Jfs'] = $is_cday['Jfs']+$info[$k]['Score'][$ku];
	    		}
	    		if($v['KindID'] == '558'){
	    			$save['Mj'] = $is_cday['Mj']+1;
	    		}else{
	    			if($v['KindID'] == '200'){
	    				$save['Ddz'] = $is_cday['Ddz']+1;
	    			}elseif($v['KindID'] == '502'){
	    				$save['Ss'] = $is_cday['Ss']+1;
	    			}elseif($v['KindID'] == '2'){
	    				$save['Niu'] = $is_cday['Niu']+1;
	    			}elseif($v['KindID'] == '6'){
	    				$save['Zjh'] = $is_cday['Zjh']+1;
	    			}elseif($v['KindID'] == '430'){
	    				$save['Dz'] = $is_cday['Dz']+1;
	    			}
	    			$save['Pk'] = $is_cday['Pk']+1;
	    		}
	    		$db->update('CountUserJf',$save,"CujID='".$is_cday['CujID']."'");
	      }else{
	    		$save = ['UserID'=>$vu,'Days'=>date('Y-m-d',strtotime($v['Date'])),'Hit'=>1,'Jf'=>$info[$k]['Score'][$ku]];
	    		if($info[$k]['Score'][$ku]>0){
	    			$save['Jfz'] = $info[$k]['Score'][$ku];
	    		}else{
	    			$save['Jfs'] = $info[$k]['Score'][$ku];
	    		}
	    		if($v['KindID'] == '558'){
	    			$save['Mj'] = 1;
	    		}else{
	    			if($v['KindID'] == '200'){
	    				$save['Ddz'] = 1;
	    			}elseif($v['KindID'] == '502'){
	    				$save['Ss'] = 1;
	    			}elseif($v['KindID'] == '430'){
	    				$save['Dz'] = 1;
	    			}elseif($v['KindID'] == '2'){
	    				$save['Niu'] = 1;
	    			}elseif($v['KindID'] == '6'){
	    				$save['Zjh'] = 1;
	    			}
	    			$save['Pk'] = 1;
	    		}
	    		$db->insert("CountUserJf",$save);
	    	}
	    	$zjf = $db->fetch_abc("select Zjf from QPTreasureDB.dbo.GameScoreInfo where UserID='".$vu."'");
	    	$db->update('QPTreasureDB.dbo.GameScoreInfo',['Zjf'=>($zjf+$info[$k]['Score'][$ku])],"UserID='".$vu."'");
	    	$save = [];
	    	$zjf = 0;
	    	//记录月数据
	    	$is_cmonth = $db->fetch_one("select * from CountJf where UserID='".$vu."' and Month='".date('Y-m',strtotime($v['Date']))."'");
	    	if($is_cmonth){
	    		$save = ['Hit'=>($is_cmonth['Hit']+1),'Jf'=>($is_cmonth['Jf']+$info[$k]['Score'][$ku])];
	    		if($info[$k]['Score'][$ku]>0){
	    			$save['Jfz'] = $is_cmonth['Jfz']+$info[$k]['Score'][$ku];
	    		}else{
	    			$save['Jfs'] = $is_cmonth['Jfs']+$info[$k]['Score'][$ku];
	    		}
	    		if($v['KindID'] == '558'){
	    			$save['Mj'] = $is_cmonth['Mj']+1;
	    		}else{
	    			if($v['KindID'] == '200'){
	    				$save['Ddz'] = $is_cmonth['Ddz']+1;
	    			}elseif($v['KindID'] == '502'){
	    				$save['Ss'] = $is_cmonth['Ss']+1;
	    			}elseif($v['KindID'] == '430'){
	    				$save['Dz'] = $is_cmonth['Dz']+1;
	    			}elseif($v['KindID'] == '2'){
	    				$save['Niu'] = $is_cmonth['Niu']+1;
	    			}elseif($v['KindID'] == '6'){
	    				$save['Zjh'] = $is_cmonth['Zjh']+1;
	    			}
	    			$save['Pk'] = $is_cmonth['Pk']+1;
	    		}
	    		$db->update('CountJf',$save,"CjID='".$is_cmonth['CjID']."'");
	    	}else{
	    		$save = ['UserID'=>$vu,'Month'=>date('Y-m',strtotime($v['Date'])),'Hit'=>1,'Jf'=>$info[$k]['Score'][$ku]];
	    		if($info[$k]['Score'][$ku]>0){
	    			$save['Jfz'] = $info[$k]['Score'][$ku];
	    		}else{
	    			$save['Jfs'] = $info[$k]['Score'][$ku];
	    		}
	    		if($v['KindID'] == '558'){
	    			$save['Mj'] = 1;
	    		}else{
	    			if($v['KindID'] == '200'){
	    				$save['Ddz'] = 1;
	    			}elseif($v['KindID'] == '502'){
	    				$save['Ss'] = 1;
	    			}elseif($v['KindID'] == '430'){
	    				$save['Dz'] = 1;
	    			}elseif($v['KindID'] == '2'){
	    				$save['Niu'] = 1;
	    			}elseif($v['KindID'] == '6'){
	    				$save['Zjh'] = 1;
	    			}
	    			$save['Pk'] = 1;
	    		}
	    		$db->insert("CountJf",$save);
	    	}
	    	//添加抽奖局数
	    	$is_game = $db->fetch_one("select * from QPTreasureDB.dbo.GameScoreInfo where UserID='".$vu."'");
	    	if($is_game['LotteryGame'] < $lottery_game){
	    		 $db->update('QPTreasureDB.dbo.GameScoreInfo',['LotteryGame'=>($is_game['LotteryGame']+1)],"UserID='".$vu."'");
	    	}
	  	}
	  	//添加标记
	  	$db->update('QPTreasureDB.dbo.PrivateGameRecordChild',['Bj'=>1],"RecordChildID='".$v['RecordChildID']."'");
	  	$zhit++;
	  	//删除日志上上月数据
	  	echo $zhit."、".$v['RecordChildID']."<br>";
	  }else{
	  	$info[$k]['users'] = [];
	  }
	}
}
exit;
}
$ppxq -> assign('GG',$GG);
$ppxq -> display('user/zx.tpl');
$db->close();
unset($GG,$ppxq,$db);
?>