chukujilu_list2.php
(开头部分) 6KB这里只显示每个文件的开头 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="shangpinbianhao" type="text" id="shangpinbianhao" style='border:solid 1px #000000; color:#666666;width:80px' /> 商品名称:<input name="shangpinmingcheng" type="text" id="shangpinmingcheng" style='border:solid 1px #000000; color:#666666;width:80px' /> 商品类别:<input name="shangpinleibie" type="text" id="shangpinleibie" style='border:solid 1px #000000; color:#666666;width:80px' /> 仓库:<input name="cangku" type="text" id="cangku" style='border:solid 1px #000000; color:#666666;width:80px' /> 日期:<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='kehu' id='kehu' style='border:solid 1px #000000; color:#666666;'><option value="">所有</option><?php getoption("kehu","kehu")?></select></select> 操作人:<input name="caozuoren" type="text" id="caozuoren" 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'>日期</td>
<td bgcolor='#CCFFFF'>客户</td>
<td bgcolor='#CCFFFF'>数量</td>
<td bgcolor='#CCFFFF'>金额</td>
<td bgcolor='#CCFFFF'>操作人</td>
<td width="120" align="center" bgcolor="#CCFFFF">添加时间</td>
<td width="70" align="center" bgcolor="#CCFFFF">操作</td>
</tr>
<?php
$sql="select * from chukujilu where cangku='".$_SESSION['ck']."'";
if ($_POST["shangpinbianhao"]!=""){$nreqshangpinbianhao=$_POST["shangpinbianhao"];$sql=$sql." and shangpinbianhao like '%$nreqshangpinbianhao%'";}
if ($_POST["shangpinmingcheng"]!=""){$nreqshangpinmingcheng=$_POST["shangpinmingcheng"];$sql=$sql." and shangpinmingcheng like '%$nreqshangpinmingcheng%'";}
if ($_POST["shangpinleibie"]!=""){$nreqshangpinleibie=$_POST["shangpinleibie"];$sql=$sql." and shangpinleibie like '%$nreqshangpinleibie%'";}
if ($_POST["cangku"]!=""){$nreqcangku=$_POST["cangku"];$sql=$sql." and cangku like '%$nreqcangku%'";}
if ($_POST["riqi1"]!=""){$nreqriqi1=$_POST["riqi1"];$sql=$sql." and riqi >= '$nreqriqi1'";}
if ($_POST["riqi2"]!=""){$nreqriqi2=$_POST["riqi2"];$sql=$sql." and riqi <= '$nreqriqi2'";}
if ($_POST["kehu"]!=""){$nreqkehu=$_POST["kehu"];$sql=$sql." and kehu like '%$nreqkehu%'";}
if ($_POST["caozuoren"]!=""){$nreqcaozuoren=$_POST["caozuoren"];$sql=$sql." and caozuoren like '%$nreqcaozuoren%'";}
$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)
后面还有 67 行代码,购买后查看完整代码
24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明
AI 解读 AI
登录后可用,每次 10 算力,解读结果公开显示在下面。
还没有人解读过这个文件。