feiyong_list2.php

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?php
session_start();
include_once 'conn.php';

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>费用</title>
<script type="text/javascript" src="js/My97DatePicker/WdatePicker.js" charset="gb2312"></script>
<link rel="stylesheet" href="css.css" type="text/css">
</head>
<!--hxsglxiangdxongjxs-->
<body>

<p>已有费用列表：</p>
<form id="form1" name="form1" method="post" action="">
  搜索: 日期：<input name="riqi1" type="text" id="riqi1"  value='' onclick="WdatePicker({'dateFmt':'yyyy-MM-dd'})"  style='border:solid 1px #000000; color:#666666; width:80px;' />-<input name="riqi2" type="text" id="riqi2"  value='' onclick="WdatePicker({'dateFmt':'yyyy-MM-dd'})"  style='border:solid 1px #000000; color:#666666; width:80px;' /> 类型：<select name='leixing' id='leixing' style='border:solid 1px #000000; color:#666666;'><option value="">所有</option><option value="水费">水费</option><option value="电费">电费</option><option value="物业费">物业费</option><option value="其他">其他</option></select> 单位号：<select name='danweihao' id='danweihao' style='border:solid 1px #000000; color:#666666;'><option value="">所有</option><?php getoption("danweixinxi","danweihao")?></select></select> 登记人：<input name="dengjiren" type="text" id="dengjiren" style='border:solid 1px #000000; color:#666666;width:80px' />
  <input type="submit" name="Submit" value="查找" style='border:solid 1px #000000; color:#666666' />
</form>
<table width="100%" border="1" align="center" cellpadding="3" cellspacing="1" bordercolor="#00FFFF" style="border-collapse:collapse">  
  <tr>
    <td width="25" bgcolor="#CCFFFF">序号</td>
    <td bgcolor='#CCFFFF'>日期</td>
    <td bgcolor='#CCFFFF'>类型</td>
    <td bgcolor='#CCFFFF'>金额</td>
    <td bgcolor='#CCFFFF'>单位号</td>
    <td bgcolor='#CCFFFF'>登记人</td>
    <td bgcolor='#CCFFFF' width='80' align='center'>是否支付</td>
    <td bgcolor='#CCFFFF' width='80' align='center'>是否审核</td>
    
    <td width="70" align="center" bgcolor="#CCFFFF">操作</td>
  </tr>
  <?php 
    $sql="select * from feiyong where danweihao='".$_SESSION['dwh']."'";
  
if ($_POST["riqi1"]!=""){$nreqriqi1=$_POST["riqi1"];$sql=$sql." and riqi >= '$nreqriqi1'";}
if ($_POST["riqi2"]!=""){$nreqriqi2=$_POST["riqi2"];$sql=$sql." and riqi <= '$nreqriqi2'";}
if ($_POST["leixing"]!=""){$nreqleixing=$_POST["leixing"];$sql=$sql." and leixing like '%$nreqleixing%'";}
if ($_POST["danweihao"]!=""){$nreqdanweihao=$_POST["danweihao"];$sql=$sql." and danweihao like '%$nreqdanweihao%'";}
if ($_POST["dengjiren"]!=""){$nreqdengjiren=$_POST["dengjiren"];$sql=$sql." and dengjiren like '%$nreqdengjiren%'";}
  $sql=$sql." order by id desc";
  
$query=mysql_query($sql);
  $rowscount=mysql_num_rows($query);
  if($rowscount==0)
  {}
  else
  {
  $pagelarge=10;//每页行数；
  $pagecurrent=$_GET["pagecurrent"];
  if($rowscount%$pagelarge==0)
  {
		$pagecount=$rowscount/$pagelarge;
  }
  else
  {
   		$pagecount=intval($rowscount/$pagelarge)+1;
  }