-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathselect.php
More file actions
181 lines (172 loc) · 7.4 KB
/
select.php
File metadata and controls
181 lines (172 loc) · 7.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
<html>
<head>
<?php
session_start();
include 'inc/conn.inc.php';//mysql数据库
include 'inc/page.class.php';//分页
?>
<link rel="stylesheet" type="text/css" href="css/main.css" />
<script language="javascript" type="text/javascript" src="My97DatePicker/WdatePicker.js"></script>
</head>
<body>
<form action="select.php" method="get">
<font color=black>机顶盒号（注意空格）<input type="text", name="stb">
<font color=black>起始日期:</font><input class="Wdate" type="text" onClick="WdatePicker()", name="datebegin">
<font color=black>结束日期:</font><input class="Wdate" type="text" onClick="WdatePicker()", name="dateend">
<!-- 结束日期（格式：120101）:<input type="input", name="dateend">-->
<!-- <input type="submit" name="sub" value="查询充值记录">
<input type="submit" name="subpoint" value="查询游戏点变化记录">-->
<select name="select_type">
<option value="sub">充值记录</option>
<option value="subpoint">游戏点记录</option>
<option value="login">登录记录</option>
<input type="submit" name="sub" value="查询">
<br>
</select>
</form>
<?php
$sub=$_GET['sub'];
//$subpoint=$_GET['subpoint'];
$stb=$_GET['stb'];
$datebegin=$_GET['datebegin'];
$dateend=$_GET['dateend'];
$select_type=$_GET['select_type'];
//echo $select_type;
//确认表单提交查询充值记录
function show_select_data($head_msg,$stb,$sql,$subtype){
$result=mysql_query($sql);
$_SESSION["excel"]=$sql;
$_SESSION["stb"]=$stb;
$total=mysql_num_rows($result);
//echo $total."<br>-------total";
$num=30;
$page=new Page($total, $num, "&cid=99");
$sql=$sql." {$page->limit};";
// echo $sql;
$_SESSION["subtype"]=$subtype;
//echo $_SESSION["excel"]." 11</br>";
$result=mysql_query($sql);
$cols=mysql_num_fields($result);
$sql_user="select vc_stb_id,member_id,member_status,game_points,vip_level,create_date,done_date,region_code,city_id from gp_user_info
where
vc_stb_id='".$stb."'";
$result_user=mysql_query($sql_user);
$col_user=mysql_num_fields($result_user);
$num_u=mysql_num_rows($result);
if($num_u > 0){
echo '<font size="3" color="red"><br>用户基本信息:</br></font>';
echo '<table border="1" style="margin-top:20px;width:80%">';
echo '<tr>';
for($i=0; $i<$col_user; $i++){
echo '<th>'.mysql_field_name($result_user, $i).'</th>';
}
echo '</tr>';
while ($row_user=mysql_fetch_assoc($result_user)){
echo '<tr>';
foreach ($row_user as $col){
echo '<td>'.$col.'</td>';
}
echo '</tr>';
}
if(!empty($result)){
echo '<table align="center" border="1" width="800" style="margin-top:20px;width:80%">';
echo $head_msg;
echo '<thead>';
echo '<tr>';
for($i=0; $i<$cols; $i++){
echo '<th>'.mysql_field_name($result, $i).'</th>';
}
echo '</tr>';
echo '</thead>';
echo '<tbody class="">';
while($row=mysql_fetch_assoc($result)){
echo '<tr onMouseOver=this.style.backgroundColor="#cccccc" onMouseOut=this.style.backgroundColor="#FFFFFF">';
foreach($row as $col){
echo '<td>'.$col.'</td>';
}
echo '</tr>';
}
echo '<input name="button" type="button" value="导出数据excel" onclick="excel()" />';
echo '<tr><td colspan="5" align="right">'.$page->fpage(array(8,3,4,5,6,7,0,1,2)).'</td></tr>';
echo '</tbody>';
mysql_free_result($result);
mysql_close($link);
}else{
echo "没有相关记录！！！！" ;
}
echo '</table>';
}else {
echo "无机顶盒信息</br>";
}
}
if(isset($sub)){
if(!empty($select_type) && $select_type == 'sub'){
if(!empty($stb) && !empty($datebegin) && !empty($dateend)){
//echo "begin date: ".date('ymd',strtotime($datebegin))." date end : ".date('ymd',strtotime($dateend))."----</br>";
$datebegin=date('ymd',strtotime($datebegin));
$dateend=date('ymd',strtotime($dateend));
$head_msg="<caption>机顶盒 ".$stb." 于 ".$datebegin."--".$dateend." 期间充值记录：</caption>";
//echo "stb: ".$stb." datebegin :".$datebegin." dateend :".$dateend." ";
//$sql="select * from gp_recharge_his where vc_stb_id='".$stb."' and l_date between '".$datebegin."' and '".$dateend."' order by l_date desc,l_time desc {$page->limit};";
$sql="SELECT t1.vc_stb_id, t1.member_id, t1.l_money, t1.l_date, t1.l_time, t2.name
FROM gp_recharge_his t1, gp_recharge_cp t2
WHERE
t1.l_type = t2.l_type
AND t1.vc_stb_id ='".$stb."'
AND t1.l_date BETWEEN '".$datebegin."' AND '".$dateend."'
order by t2.name,t1.l_date desc,t1.l_time desc ";
show_select_data($head_msg,$stb,$sql,"chongzhi");
}else {
//有内容为空时提示
echo "机顶盒号、起始时间、结束时间都不能为空 ！<br>";
}
}elseif(!empty($select_type) && $select_type == 'subpoint' ){
if(!empty($stb) && !empty($datebegin) && !empty($dateend)){
//echo "begin date: ".date('ymd',strtotime($datebegin))." date end : ".date('ymd',strtotime($dateend))."----</br>";
$datebegin=date('Y/m/d',strtotime($datebegin));
$dateend=date('Y/m/d',strtotime($dateend));
//echo "stb: ".$stb." datebegin :".$datebegin." dateend :".$dateend." ";
$sql="select * from
(SELECT t2.vc_stb_id,t1.member_id,t1.before_points_busi,t1.chg_game_points,t1.game_points,t1.done_date,t3.l_game_name
FROM `point_history` t1,`gp_user_info` t2, `gp_game_info` t3
WHERE t1.member_id=t2.member_id
and substr(t1.notes,8,3)=t3.l_game_id
and t1.done_date between date_format('".$datebegin."','%Y/%m/%d 00:00:00') and date_format('".$dateend."','%Y/%m/%d 00:00:00')
and t2.vc_stb_id='".$stb."'
UNION
SELECT t2.vc_stb_id,t1.member_id,t1.before_points_busi,t1.chg_game_points,t1.game_points,t1.done_date,t3.l_game_name
FROM `point` t1,`gp_user_info` t2 , `gp_game_info` t3
WHERE t1.member_id=t2.member_id
and substr(t1.notes,8,3)=t3.l_game_id
and t1.done_date between date_format('".$datebegin."','%Y/%m/%d 00:00:00') and date_format('".$dateend."','%Y/%m/%d 00:00:00')
and t2.vc_stb_id='".$stb."')as g
order by g.done_date desc ";
$head_msg="<caption>机顶盒 ".$stb." 于 ".$datebegin."--".$dateend." 期间游戏点变化记录：</caption>";
show_select_data($head_msg,$stb,$sql,"point");
}else {
//有内容为空时提示
echo "机顶盒号、起始时间、结束时间都不能为空 ！<br>";
}
}elseif(!empty($select_type) && $select_type == 'login' ){
if(!empty($stb) && !empty($datebegin) && !empty($dateend)){
$datebegin=date('Y-m-d 00:00:00',strtotime($datebegin));
$dateend=date('Y-m-d 00:00:00',strtotime($dateend));
$sql="select v_stbid,v_source,v_time,v_code,v_city from z_visit_log where v_stbid='".$stb."' and v_time between '".$datebegin."' and '".$dateend."' order by v_time desc ";
$head_msg="<caption>机顶盒 ".$stb." 于 ".$datebegin."--".$dateend." 期间登录游戏记录：</caption>";
show_select_data($head_msg,$stb, $sql, "login");
}else {
//有内容为空时提示
echo "机顶盒号、起始时间、结束时间都不能为空 ！<br>";
}
}
}
//print_r($_SESSION);
?>
<script type="text/javascript">
function excel()
{
window.location.href="download_excel.php";
}
</script>
</body>
</html>