21,886
社区成员
发帖
与我相关
我的任务
分享
<?php
session_start();
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>统计页面</title>
</head>
<body>
<?php
include('conn.php');
$officename=$_POST['officename'];
$date=$_POST['riqi'];
$sql1="select * from record where officename='$officename' and searchtime like '%$riqi%' order by name";
$result1=mysql_query($sql1);
if(mysql_num_rows($result1)!=0){
$row=mysql_fetch_assoc($result1) ;
$officecode=$row['officecode'];
$_SESSION["riqi"]=$_POST['riqi'];
$_SESSION["officename"]=$_POST['officename'];
$_SESSION["officecode"]=$officecode;
}
else{
echo "没有这样的记录,正在返回确认页面";
echo "<meta http-equiv='refresh' content='2;url=confirm.php'>";
}
?>
日期:<?php echo $date; ?>——NO:<?php echo $officecode; ?>——名称:<?php echo $officename; ?>
<form name="form3">
<div align="center">
<table width="1230" height="103" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<!-- 将要列出的内容-->
<th width="5%" height="38" bgcolor="#E3E3E3" scope="col">编号</th>
<th width="10%" bgcolor="#E3E3E3" scope="col">姓名</th>
<th width="5%" bgcolor="#E3E3E3" scope="col">NO.</th>
<th width="20%" bgcolor="#E3E3E3" scope="col">物件名称</th>
<th width="10%" bgcolor="#E3E3E3" scope="col">行驶距离km</th>
<th width="10%" bgcolor="#E3E3E3" scope="col">行驶时间min</th>
<th width="10%" bgcolor="#E3E3E3" scope="col">作业时间min</th>
<th width="10%" bgcolor="#E3E3E3" scope="col">行驶速度km/h</th>
<th width="10%" bgcolor="#E3E3E3" scope="col">到达时间</th>
<th width="15%" bgcolor="#E3E3E3" scope="col">出发时间</th>
</tr>
<?php
$link=mysql_connect('localhost','root','mysql'); //数据库用户名及数据库密码
mysql_select_db('berecord'); //数据库名称
mysql_query('set names utf8');
$Page_size=10; //设置每页显示个数
$result=mysql_query("select * from record where officecode='$officecode' and searchtime like '%$riqi%' order by name"); //record为表名
$count = mysql_num_rows($result);
$page_count = ceil($count/$Page_size);
$init = 1;
$page_len = 7;
$max_p=$page_count;
$pages=$page_count;
//判断当前页码
if(empty($_GET['page'])||$_GET['page']<0){
$page=1;
}
else{
$page=$_GET['page'];
}
$offset=$Page_size*($page-1);
$sql="select * from record where officecode='$officecode' and searchtime like '%$riqi%' order by mencode limit $offset,$Page_size" ;
$result=mysql_query($sql,$link);
$last=array();
while($row=mysql_fetch_array($result)){
if($last){
$row['xingshi'] = (strtotime($row['arrivetime'])-strtotime($last['gotime']))/60;
if($row['name'] == $last['name']) { //还是同一组
$distance += $row['distance'];
$xingshi += $row['xingshi'];
}
else {
$row['xingshi'] = 0;
//echo "合计\t" . $distance . "\t\t\t" . $xingshi . 'min' . PHP_EOL;
?>
<td colspan="4" bgcolor="#E0EEE">合计</td>
<td><div align="center">
<?php echo $distance."km"; ?>
</div></td>
<td><div align="center"><?php echo $xingshi."min"; ?></div></td>
<?php
//合计完成后,重置行驶距离和行驶时间
$distance = $row['distance'];
$xingshi = 0;
}
}
else {
$distance = $row['distance'];
$xingshi = 0;
}
$last=$row;
?>
<tr>
<td bgcolor="#E0EEE0" height="25px"><div align="center">
<?php echo $row['mencode']?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php echo $row['name']?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php echo $row['record']?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php echo $row['buildname']?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php echo $row['distance']?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php
echo $row['xingshi'];
?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php echo $dotime=(strtotime($row['gotime'])-strtotime($row['arrivetime']))/60 ; ?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php //echo $row['distance']/($dotime/60);
//if($xingshi!=0)
if($row['xingshi']!=0){
echo round($row['distance']/($row['xingshi']/60),2);
}
else{
echo "0";
}
?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php echo $row['arrivetime']?>
</div></td>
<td bgcolor="#E0EEE"><div align="center">
<?php echo $row['gotime']?>
</div></td>
</tr>
<?php
}
?>
<td colspan="4" bgcolor="#E0EEE">合计</td>
<td><div align="center">
<?php echo $distance."km"; ?>
</div></td>
<td><div align="center"><?php echo $xingshi."min"; ?></div></td>
<?php
$page_len=($page_len%2)?$page_len:$pagelen+1;//页码个数
$pageoffset = ($page_len-1)/2; //页码个数左右偏移量
$key='<div class="page">';
$key.="<span>$page/$pages</span>"; //第几页,共几页
if($page!=1){
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=1\">第一页</a>";//第一页
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".($page-1)."\">上一页</a>"; //上一页
}
else{
$key.="第一页";//第一页
$key.="上一页";//上一页
}
if($pages>$page_len){
//如果当前页小于等于左偏移
if($page<=$pageoffset){
$init=1;
$max_p = $page_len;
}
else{
//如果当前页大于左偏移
//如果当前页码右偏移超出最大分页数
if($page+$pageoffset>=$pages+1){
$init = $pages-$page_len+1;
}
else{
//左右偏移都存在时的计算
$init = $page-$pageoffset;
$max_p =$page+$pageoffset;
}
}
}
for($i=$init;$i<=$max_p;$i++){
if($i==$page){
$key.='<span>'.$i.'</span>';
}
else{
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a>";
}
}
if($page!=$pages){
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page=".($page+1)."\">下一页</a>"; //下一页
$key.="<a href=\"".$_SERVER['PHP_SELF']."?page={$pages}\">最后一页</a>"; //最后一页
}
else{
$key.="下一页"; //下一页
$key.="最后一页";//最后一页
}
$key.='</div>';
//echo $sql;
?>
<tr>
<td colspan="13" bgcolor="#E0EEE0"><div align="center"><?php echo $key ?></div></td>
</tr>
</table>
</div>
<!--
<div align="center"><?php echo $key ?> 第<input type="text" name="page" style="width:25px;" />页
<input type="button" value="go" onClick="tijiao()">
</div>
-->
<br><br><br><br><br><br>
</table>
<div align="center">
<br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<input type="button" value="返回输入页面" onClick="location.href='write.php'" />
</div>
</form>
</body>
</html>