<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<form name="form2" action="" method="post">
<table align="center" border="1" width="300" cellspacing ="0">
<tr>
<td colspan="5" align="center">需要查询的内容:</td></tr><tr>
<td> <input type="checkbox" name="check[]" value="nam"/>姓名<input type="text" name="nam"/></td>
<td><input type="checkbox" name="check[]" value="pho"/>电话<input type="text" name="pho"/></td>
<td><input type="checkbox" name="check[]"value="tim"/>入网时间<input type="text" name="tim"/></td>
</tr>
<tr>
<td><input type="checkbox" name="check[]"value="act"/>角色<input type="text" name="act"/></td>
<td><input type="checkbox" name="check[]"value="sch"/>所属学校<input type="text" name="sch"/></td>
<td><input type="checkbox" name="check[]"value="are"/>区局<input type="text" name="are"/></td>
<!--<td><input type="checkbox" name="check[]"value="lim"/>时间段限制<input type="text" name="lim"/></td>-->
</tr>
</table>
<h2 align="center"><input name="submit1" type="submit" value="提交" ></h2>
<?php
session_start();
set_time_limit(0);
if($_POST["submit1"]=='提交')
{
session_destroy();
session_start();
$_SESSION['page']=0;
$_SESSION['sql']="";
}
if($_POST["submit1"]=='下一页')
{$_SESSION['page']=(int)$_SESSION['page']+40;}
if($_POST["submit1"]=='上一页'&&(int)$_SESSION['page']>39)
{$_SESSION['page']=(int)$_SESSION['page']-40;}
if($_POST)
{
//echo implode($_POST['check'])."</br>";
//echo $_POST['check'][0];
$con=mysql_connect('',' ',' ') ;
if(!$con)
{
echo "connect error</br>";
die('Could not connect:'.mysql_error());
}
mysql_select_db("jxt",$con);
$sql="select u.uname as '姓名',u.mobile as '电话',FROM_UNIXTIME(u.ctime) AS '入网时间',
(select group_concat(ts_group.name) from ts_group,ts_group_member where ts_group_member.gid=ts_group.id and ts_group_member.uid=u.uid and ts_group.cid0=1) as '所属学校',
(select group_concat(ts_group.name) from ts_group,ts_group_member where ts_group_member.gid=ts_group.id and ts_group_member.uid=u.uid and ts_group.cid0=6) as '所属班级',
(select count(1) from ts_login_record where uid=u.uid) as '登录次数',
(select group_concat(ts_user_group_link.user_group_title) from ts_user_group_link where ts_user_group_link.uid=u.uid) as '角色',
u.company as '区局' from ts_user u where 1=1 ";
$count = count($_POST['check']);
//echo $count;
for($i=0;$i<$count;$i++)
{
//if($i!=0)
// $sql=$sql." and ";
if($_POST['check'][$i]=="nam")
{
//echo "-------------";
$sql=$sql." and u.uname like '%$_POST[nam]%'";
}else if($_POST['check'][$i]=="pho")
{$sql=$sql." and u.mobile='$_POST[pho]'";}
else if($_POST['check'][$i]=="tim")
{$sql=$sql." and ctime=UNIX_TIMESTAMP('$_POST[tim]')";}
else if($_POST['check'][$i]=="act")
{
if($_POST[act]=="用户") $act="1";
elseif($_POST[act]=="机构") $act="2";
elseif($_POST[act]=="客服") $act="3";
elseif($_POST[act]=="校园指挥长") $act="4";
elseif($_POST[act]=="校园管理经理") $act="5";
elseif($_POST[act]=="校园总协调") $act="6";
elseif($_POST[act]=="兼职客户经理") $act="7";
elseif($_POST[act]=="网络支援经理") $act="8";
elseif($_POST[act]=="系统功能使用反馈班") $act="784";
$sql=$sql." and u.uid IN (SELECT uid from ts_user_group_link where ts_user_group_link.user_group_id='".$act."')";
}
else if($_POST['check'][$i]=="sch")
{$sql=$sql." and u.uid IN (SELECT uid FROM ts_group_member WHERE gid in (SELECT id FROM ts_group WHERE `name` LIKE ('%%$_POST[sch]%%')))";}
else if($_POST['check'][$i]=="are")
{$sql=$sql." and u.company LIKE '%%$_POST[are]%%'";}
/*
switch($_POST['check'][$i])
{
case nam:$sql=$sql."tu.uname like '%$_POST[nam]%'";break;
case pho:$sql=$sql."tu.uname like '%$_POST[pho]%'";break;
case tim:$sql=$sql."tu.uname like '%$_POST[tim]%'";break;
case cou:;
case act:$sql=$sql."tu.uname like '%$_POST[act]%'";break;
case sch:$sql=$sql."tu.uname like '%$_POST[sch]%'";break;
case cla:;
case sum:;
case are:$sql=$sql."tu.uname like '%$_POST[are]%'";break;
case lim:;
}*/
}
if($_SESSION['sql']=="")
{
$_SESSION['sql']=$sql;
}
$sql=$_SESSION['sql']." limit ".$_SESSION['page'].",20";
echo $sql;
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
$result = mysql_query($sql);
echo "<table border='1'>
<tr>
<th>姓名</th>
<th>电话</th>
<th>入网时间</th>
<th>所属学校</th>
<th>所属班机</th>
<th>登陆次数</th>
<th>角色</th>
<th>区局</th>
</tr>";
if(is_resource($result)){
while($row= mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['姓名'] . "</td>";
echo "<td>" . $row['电话'] . "</td>";
echo "<td>" . $row['入网时间'] . "</td>";
echo "<td>" . $row['所属学校'] . "</td>";
echo "<td>" . $row['所属班级'] . "</td>";
echo "<td>" . $row['登录次数'] . "</td>";
echo "<td>" . $row['角色'] . "</td>";
echo "<td>" . $row['区局'] . "</td>";
echo "</tr>";
}
}
else
{
echo "</br>------------无数据----------------";
}
echo "</table>";
$res = mysql_query($_SESSION['sql']);
$num=mysql_num_rows($res);
//$num=count($rs);
echo "查出共".$num."条数据";
mysql_close($con);
}else
{
echo "<h2 align='center'>请先选择 需要添加的字段</h2>";
}
//echo "<a href="s2.php">登陆</a>"
//$_SESSION['page']=(int)$_SESSION['page']+20;
//echo $_SESSION['page'];
//session_destroy()
?>
<input type= "submit" name="submit1" " value="上一页"/>
<input type= "submit" name="submit1" " value="下一页"/>
<a href="0.php">导出excel</a>
<!--<button οnclick="<?php nextpage() ?>" value="nextpage">下一页</button>-->
</form>
</body>
</html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
</head>
<body>
<form name="form2" action="" method="post">
<table align="center" border="1" width="300" cellspacing ="0">
<tr>
<td colspan="5" align="center">需要查询的内容:</td></tr><tr>
<td> <input type="checkbox" name="check[]" value="nam"/>姓名<input type="text" name="nam"/></td>
<td><input type="checkbox" name="check[]" value="pho"/>电话<input type="text" name="pho"/></td>
<td><input type="checkbox" name="check[]"value="tim"/>入网时间<input type="text" name="tim"/></td>
</tr>
<tr>
<td><input type="checkbox" name="check[]"value="act"/>角色<input type="text" name="act"/></td>
<td><input type="checkbox" name="check[]"value="sch"/>所属学校<input type="text" name="sch"/></td>
<td><input type="checkbox" name="check[]"value="are"/>区局<input type="text" name="are"/></td>
<!--<td><input type="checkbox" name="check[]"value="lim"/>时间段限制<input type="text" name="lim"/></td>-->
</tr>
</table>
<h2 align="center"><input name="submit1" type="submit" value="提交" ></h2>
<?php
session_start();
set_time_limit(0);
if($_POST["submit1"]=='提交')
{
session_destroy();
session_start();
$_SESSION['page']=0;
$_SESSION['sql']="";
}
if($_POST["submit1"]=='下一页')
{$_SESSION['page']=(int)$_SESSION['page']+40;}
if($_POST["submit1"]=='上一页'&&(int)$_SESSION['page']>39)
{$_SESSION['page']=(int)$_SESSION['page']-40;}
if($_POST)
{
//echo implode($_POST['check'])."</br>";
//echo $_POST['check'][0];
$con=mysql_connect('',' ',' ') ;
if(!$con)
{
echo "connect error</br>";
die('Could not connect:'.mysql_error());
}
mysql_select_db("jxt",$con);
$sql="select u.uname as '姓名',u.mobile as '电话',FROM_UNIXTIME(u.ctime) AS '入网时间',
(select group_concat(ts_group.name) from ts_group,ts_group_member where ts_group_member.gid=ts_group.id and ts_group_member.uid=u.uid and ts_group.cid0=1) as '所属学校',
(select group_concat(ts_group.name) from ts_group,ts_group_member where ts_group_member.gid=ts_group.id and ts_group_member.uid=u.uid and ts_group.cid0=6) as '所属班级',
(select count(1) from ts_login_record where uid=u.uid) as '登录次数',
(select group_concat(ts_user_group_link.user_group_title) from ts_user_group_link where ts_user_group_link.uid=u.uid) as '角色',
u.company as '区局' from ts_user u where 1=1 ";
$count = count($_POST['check']);
//echo $count;
for($i=0;$i<$count;$i++)
{
//if($i!=0)
// $sql=$sql." and ";
if($_POST['check'][$i]=="nam")
{
//echo "-------------";
$sql=$sql." and u.uname like '%$_POST[nam]%'";
}else if($_POST['check'][$i]=="pho")
{$sql=$sql." and u.mobile='$_POST[pho]'";}
else if($_POST['check'][$i]=="tim")
{$sql=$sql." and ctime=UNIX_TIMESTAMP('$_POST[tim]')";}
else if($_POST['check'][$i]=="act")
{
if($_POST[act]=="用户") $act="1";
elseif($_POST[act]=="机构") $act="2";
elseif($_POST[act]=="客服") $act="3";
elseif($_POST[act]=="校园指挥长") $act="4";
elseif($_POST[act]=="校园管理经理") $act="5";
elseif($_POST[act]=="校园总协调") $act="6";
elseif($_POST[act]=="兼职客户经理") $act="7";
elseif($_POST[act]=="网络支援经理") $act="8";
elseif($_POST[act]=="系统功能使用反馈班") $act="784";
$sql=$sql." and u.uid IN (SELECT uid from ts_user_group_link where ts_user_group_link.user_group_id='".$act."')";
}
else if($_POST['check'][$i]=="sch")
{$sql=$sql." and u.uid IN (SELECT uid FROM ts_group_member WHERE gid in (SELECT id FROM ts_group WHERE `name` LIKE ('%%$_POST[sch]%%')))";}
else if($_POST['check'][$i]=="are")
{$sql=$sql." and u.company LIKE '%%$_POST[are]%%'";}
/*
switch($_POST['check'][$i])
{
case nam:$sql=$sql."tu.uname like '%$_POST[nam]%'";break;
case pho:$sql=$sql."tu.uname like '%$_POST[pho]%'";break;
case tim:$sql=$sql."tu.uname like '%$_POST[tim]%'";break;
case cou:;
case act:$sql=$sql."tu.uname like '%$_POST[act]%'";break;
case sch:$sql=$sql."tu.uname like '%$_POST[sch]%'";break;
case cla:;
case sum:;
case are:$sql=$sql."tu.uname like '%$_POST[are]%'";break;
case lim:;
}*/
}
if($_SESSION['sql']=="")
{
$_SESSION['sql']=$sql;
}
$sql=$_SESSION['sql']." limit ".$_SESSION['page'].",20";
echo $sql;
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
$result = mysql_query($sql);
echo "<table border='1'>
<tr>
<th>姓名</th>
<th>电话</th>
<th>入网时间</th>
<th>所属学校</th>
<th>所属班机</th>
<th>登陆次数</th>
<th>角色</th>
<th>区局</th>
</tr>";
if(is_resource($result)){
while($row= mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['姓名'] . "</td>";
echo "<td>" . $row['电话'] . "</td>";
echo "<td>" . $row['入网时间'] . "</td>";
echo "<td>" . $row['所属学校'] . "</td>";
echo "<td>" . $row['所属班级'] . "</td>";
echo "<td>" . $row['登录次数'] . "</td>";
echo "<td>" . $row['角色'] . "</td>";
echo "<td>" . $row['区局'] . "</td>";
echo "</tr>";
}
}
else
{
echo "</br>------------无数据----------------";
}
echo "</table>";
$res = mysql_query($_SESSION['sql']);
$num=mysql_num_rows($res);
//$num=count($rs);
echo "查出共".$num."条数据";
mysql_close($con);
}else
{
echo "<h2 align='center'>请先选择 需要添加的字段</h2>";
}
//echo "<a href="s2.php">登陆</a>"
//$_SESSION['page']=(int)$_SESSION['page']+20;
//echo $_SESSION['page'];
//session_destroy()
?>
<input type= "submit" name="submit1" " value="上一页"/>
<input type= "submit" name="submit1" " value="下一页"/>
<a href="0.php">导出excel</a>
<!--<button οnclick="<?php nextpage() ?>" value="nextpage">下一页</button>-->
</form>
</body>
</html>