<?php
include_once("../../../inc/admin.inc.php");
include_once("../../../inc/class.php");
include_once("../../../inc/admin.smarty.php");
include_once("../../../inc/admin.power.php");
$db->links();


//删除重起开房
//$delday = date('Y-m-d H:i:s',time()-86400*4);
$delday = "2023-02-04 05:20:00";
echo $delday;

$cs = $db->fetch_all("select * from QPTreasureDB.dbo.GameUnionConsumer where GameOk='1' and convert(varchar(19),InsertTime,120) < '".$delday."' order by InsertTime desc");

//$db->deldate("QPTreasureDB.dbo.GameUnionConsumer","GameOk='1' and convert(varchar(19),InsertTime,120) < '".$delday."'");
print_r($cs);

exit;


exit;
$delday = date('Y-m-d H:i:s',time()-86400*4);
echo $delday;

$cs = $db->fetch_all("select * from QPTreasureDB.dbo.PrivateGameRecordChild where convert(varchar(19),InsertTime,120) < '".$delday."'");


print_r($cs);

exit;
//$db->query("update QPTreasureDB.dbo.GameUnionMonth set FGold=0 where FGold!='0'");
//$db->query("update QPTreasureDB.dbo.GameUnionConsumer set Bj='1' where Bj='2'");
$csa = $db->fetch_all("
select a.UnionID,a.KindID,a.RoomID,a.GameRule,c.UnionName,c.UnionGoldOpen,a.* 
from QPTreasureDB.dbo.GameUnionConsumer as a 
LEFT JOIN QPTreasureDB.dbo.GameUnionMember as b ON(a.UnionID=b.UnionID) 
LEFT JOIN QPTreasureDB.dbo.GameUnion as c ON(a.UnionID=c.UnionID) 
where a.GameOK='1' and b.UserID='3983' 
order by UnionConsumerID asc");
print_r($csa);


$cs = $db->fetch_all("
select a.UnionID,a.KindID,a.RoomID,a.GameRule,c.UnionName,c.UnionGoldOpen,a.*
from QPTreasureDB.dbo.GameUnionConsumer as a 
LEFT JOIN QPTreasureDB.dbo.GameUnionMember as b ON(a.UnionID=b.UnionID) 
LEFT JOIN QPTreasureDB.dbo.GameUnion as c ON(a.UnionID=c.UnionID) 
where a.GameOK='1' and b.UserID='3983' and DateDiff(hh,InsertTime,getDate())<=1
order by UnionConsumerID asc");

print_r($cs);
exit;
$sql = "SELECT top 50 a.RecordChildID,a.UserScore,convert(char,a.InsertTime,120) as Date,a.RecordID,a.Bj,k.KindID,
(SELECT b.UserID,c.GameID,c.NickName,y.UnionName,d.HeadHttp FROM QPTreasureDB.dbo.PrivateGameRecordUserRecordID as b LEFT JOIN AccountsInfo as c ON(b.UserID=c.UserID) LEFT JOIN IndividualDatum as d ON(d.UserID=b.UserID) LEFT JOIN QPTreasureDB.dbo.GameScoreInfo AS x ON(b.UserID=x.UserID) LEFT JOIN QPTreasureDB.dbo.GameUnion As y ON(x.UnionID=y.UnionID) WHERE b.RecordID=a.RecordID order by b.InsertTime asc FOR XML PATH('')) AS StuList
FROM QPTreasureDB.dbo.PrivateGameRecordChild as a 
LEFT JOIN QPTreasureDB.dbo.PrivateGameRecordUserRecordID as k ON(a.RecordID=k.RecordID) where k.KindID='2' 
group by a.RecordChildID,a.RecordID,a.UserScore,a.Bj,a.InsertTime,k.KindID order by a.InsertTime desc";

$cs = $db->fetch_all($sql);

/*
$cs = $db->fetch_all("SELECT top 50 RecordChildID,UserScore,convert(char,InsertTime,120) as Date,RecordID,Bj,
(SELECT b.KindID,b.UserID,c.GameID,c.NickName,y.UnionName,d.HeadHttp FROM QPTreasureDB.dbo.PrivateGameRecordUserRecordID as b LEFT JOIN AccountsInfo as c ON(b.UserID=c.UserID) LEFT JOIN IndividualDatum as d ON(d.UserID=b.UserID) LEFT JOIN QPTreasureDB.dbo.GameScoreInfo AS x ON(b.UserID=x.UserID) LEFT JOIN QPTreasureDB.dbo.GameUnion As y ON(x.UnionID=y.UnionID) 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,UserScore,Bj,InsertTime order by InsertTime desc");
*/
print_r($cs);

//$count = $db->fetch_abc("SELECT count(*) from QPTreasureDB.dbo.PrivateGameRecordChild where convert(varchar(10),InsertTime,120) = '2017-08-25' and convert(varchar(19),InsertTime,120) < '2017-08-25 15:21:30'");
//$count2 = $db->fetch_abc("SELECT count(*) from QPTreasureDB.dbo.PrivateGameRecordChild where convert(varchar(10),InsertTime,120) = '2017-08-26' and convert(varchar(19),InsertTime,120) < '2017-08-26 15:21:30'");
//$count3 = $db->fetch_abc("SELECT count(*) from QPTreasureDB.dbo.PrivateGameRecordChild where convert(varchar(10),InsertTime,120) = '2017-08-27' and convert(varchar(19),InsertTime,120) < '2017-08-27 15:21:30'");
//echo ceil($count/8)."/".ceil($count2/8)."/".ceil($count3/8);

exit;
//$cs = $db->fetch_all("SELECT top 20 RecordID,
//(SELECT b.UserID,c.RecordChildID,c.UserScore,convert(char,c.InsertTime,120) as Date FROM QPTreasureDB.dbo.PrivateGameRecordUserRecordID as b LEFT JOIN QPTreasureDB.dbo.PrivateGameRecordChild as c ON(c.RecordID=b.RecordID) WHERE b.RecordID=a.RecordID FOR XML PATH('')) AS StuList 
//FROM QPTreasureDB.dbo.PrivateGameRecord a GROUP BY RecordID");

//$where = "where RecordID ='18922' ";

$wheres = "where UserID ='1017'";

$data = $db->fetch_all("SELECT top 50 RecordChildID,UserScore,convert(char,InsertTime,120) as Date,RecordID,
(SELECT b.UserID,c.GameID,c.NickName,d.HeadHttp FROM QPTreasureDB.dbo.PrivateGameRecordUserRecordID as b LEFT JOIN AccountsInfo as c ON(b.UserID=c.UserID) LEFT JOIN IndividualDatum as d ON(d.UserID=b.UserID) WHERE b.RecordID=a.RecordID FOR XML PATH('')) AS StuList 
FROM QPTreasureDB.dbo.PrivateGameRecordChild a ".$where." GROUP BY RecordChildID,RecordID,UserScore,InsertTime order by InsertTime desc");


if($data){
	foreach($data as $k => $v){
		$info[$k]['data'] = $v;
		$info[$k]['data']['Score'] = explode(",",$v['UserScore']);
		if($v['StuList']){
			$userstr = [];
			$arr = explode("</HeadHttp>",$v['StuList']);
			foreach($arr as $ka => $va){
				if($va){
					$userstr[] = str_replace(['</UserID>','</GameID>','</NickName>','<GameID>','<UserID>','<NickName>','<HeadHttp>'],['</>','</>','</>','','','',''],$va);
				}
			}
	    $info[$k]['user'] = $userstr;
	  }else{
	  	$info[$k]['user'] = [];
	  }
	}
}
print_r($info);
exit;


$db->close();
unset($GG,$ppxq,$db);
?>