📄 list.php
字号:
<?
include_once("inc/auth.php");
$PAGE_SIZE=10;
?>
<html>
<head>
<title>产品信息查询 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function delete_PRODUCT(PRODUCT_ID)
{
msg='确认要删除该产品么？';
if(window.confirm(msg))
{
URL="delete.php?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&MEASURE_UNIT=<?=$MEASURE_UNIT?>&COST_PRICE=<?=$COST_PRICE?>&STANDARD_PRICE=<?=$STANDARD_PRICE?>&PROVIDER_ID=<?=$PROVIDER_ID?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PAGE_START=<?=$PAGE_START?>&PRODUCT_ID=" + PRODUCT_ID;
window.location=URL;
}
}
function set_page()
{
PAGE_START=(PAGE_NUM.value-1)*<?=$PAGE_SIZE?>+1;
location="list.php?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&MEASURE_UNIT=<?=$MEASURE_UNIT?>&COST_PRICE=<?=$COST_PRICE?>&STANDARD_PRICE=<?=$STANDARD_PRICE?>&PROVIDER_ID=<?=$PROVIDER_ID?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PAGE_START="+PAGE_START;
}
function detail(PRODUCT_ID)
{
URL="detail.php?PRODUCT_ID="+PRODUCT_ID;
myleft=(screen.availWidth-500)/2;
window.open(URL,"read_notify","height=240,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function provider_detail(PROVIDER_ID)
{
URL="provider_detail.php?PROVIDER_ID="+PROVIDER_ID;
myleft=(screen.availWidth-500)/2;
window.open(URL,"read_notify","height=300,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5" >
<?
//-----------先组织SQL语句-----------
if($PRODUCT_NAME!="")
if($WHERE_STR=="")
$WHERE_STR.=" where PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
else
$WHERE_STR.=" and PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
if($PRODUCT_TYPE!="")
if($WHERE_STR=="")
$WHERE_STR.=" where PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
else
$WHERE_STR.=" and PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
if($MEASURE_UNIT!="")
if($WHERE_STR=="")
$WHERE_STR.=" where MEASURE_UNIT like '%".$MEASURE_UNIT."%'";
else
$WHERE_STR.=" and MEASURE_UNIT like '%".$MEASURE_UNIT."%'";
if($COST_PRICE!="")
if($WHERE_STR=="")
$WHERE_STR.=" where COST_PRICE='$COST_PRICE'";
else
$WHERE_STR.=" and COST_PRICE='$COST_PRICE'";
if($STANDARD_PRICE!="")
if($WHERE_STR=="")
$WHERE_STR.=" where STANDARD_PRICE='$STANDARD_PRICE'";
else
$WHERE_STR.=" and STANDARD_PRICE='$STANDARD_PRICE'";
if($PROVIDER_ID!="")
if($WHERE_STR=="")
$WHERE_STR.=" where PROVIDER_ID='".$PROVIDER_ID."'";
else
$WHERE_STR.=" and PROVIDER_ID='".$PROVIDER_ID."'";
if($PRODUCT_DESC!="")
if($WHERE_STR=="")
$WHERE_STR.=" where PRODUCT_DESC like '%".$PRODUCT_DESC."%'";
else
$WHERE_STR.=" and PRODUCT_DESC like '%".$PRODUCT_DESC."%'";
if($WHERE_STR!="")
$query="SELECT count(*) from PRODUCT ".$WHERE_STR;
else
$query="SELECT count(*) from PRODUCT";
//echo $query;
$cursor= exequery($connection,$query);
$PRODUCT_COUNT=0;
if($ROW=mysql_fetch_array($cursor))
$PRODUCT_COUNT=$ROW[0];
$PAGE_TOTAL=$PRODUCT_COUNT/$PAGE_SIZE;
$PAGE_TOTAL=ceil($PAGE_TOTAL);
//--- 计算,末页 ---
if($PRODUCT_COUNT<=$PAGE_SIZE)
$LAST_PAGE_START=1;
else if($PRODUCT_COUNT%$PAGE_SIZE==0)
$LAST_PAGE_START=$PRODUCT_COUNT-$PAGE_SIZE+1;
else
$LAST_PAGE_START=$PRODUCT_COUNT-$PRODUCT_COUNT%$PAGE_SIZE+1;
//--- 智能分页 ---
//-- 页首 --
if($PAGE_START=="")
$PAGE_START=1;
if($PAGE_START>$PRODUCT_COUNT)
$PAGE_START=$LAST_PAGE_START;
if($PAGE_START<1)
$PAGE_START=1;
//-- 页尾 --
$PAGE_END=$PAGE_START+$PAGE_SIZE-1;
if($PAGE_END>$PRODUCT_COUNT)
$PAGE_END=$PRODUCT_COUNT;
//--- 计算当前页 ---
$PAGE_NUM=($PAGE_START-1)/$PAGE_SIZE+1;
$query1=str_replace("count(*)","*",$query);
$cursor1 = exequery($connection, $query1);
if($PRODUCT_COUNT==0)
{
Message("<br>提示","没有符合条件的产品");
Button_Back();
exit;
}
?>
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
<tr>
<td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 产品查询结果 </span>
</td>
<td valign="bottom">
<span class="small1">当前为第<b><?=$PAGE_START?></b>至<b><?=$PAGE_END?></b>条 (第<?=$PAGE_NUM?>页，共<?=$PAGE_TOTAL?>页，每页最多<?=$PAGE_SIZE?>条)</small>
</td>
</tr>
</table>
<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
<tr class="TableHeader">
<td nowrap align="center">产品名称</td>
<td nowrap align="center">产品型号</td>
<td nowrap align="center">计量单位</td>
<td nowrap align="center">成本价</td>
<td nowrap align="center">出售价</td>
<td nowrap align="center">供应商</td>
<td nowrap align="center">产品描述</td>
<td nowrap align="center">操作</td>
</tr>
<?
$PRODUCT_COUNT = 0;
while($ROW=mysql_fetch_array($cursor1))
{
$PRODUCT_COUNT++;
if($PRODUCT_COUNT<$PAGE_START)
continue;
else if($PRODUCT_COUNT>$PAGE_END)
break;
$PRODUCT_ID=$ROW["PRODUCT_ID"];
$PRODUCT_NAME1=$ROW["PRODUCT_NAME"];
$PRODUCT_TYPE1=$ROW["PRODUCT_TYPE"];
$MEASURE_UNIT1=$ROW["MEASURE_UNIT"];
$COST_PRICE1=$ROW["COST_PRICE"];
$STANDARD_PRICE1=$ROW["STANDARD_PRICE"];
$PROVIDER_ID1=$ROW["PROVIDER_ID"];
$PRODUCT_DESC1=$ROW["PRODUCT_DESC"];
$query = "SELECT PROVIDER_NAME from PROVIDER where PROVIDER_ID='$PROVIDER_ID1'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$PROVIDER_NAME=$ROW["PROVIDER_NAME"];
}
if($PRODUCT_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td nowrap align="center" width="150"><?=$PRODUCT_NAME1?></td>
<td nowrap align="center"><?=$PRODUCT_TYPE1?></td>
<td nowrap align="center"><?=$MEASURE_UNIT1?></td>
<td nowrap align="center"><?=$COST_PRICE1?></td>
<td nowrap align="center"><?=$STANDARD_PRICE1?>
<td nowrap align="center">
<a href="javascript:provider_detail('<?=$PROVIDER_ID1?>');"><?=$PROVIDER_NAME?></a>
</td>
<td align="center""><?=$PRODUCT_DESC1?></td>
<td nowrap align="center" width="80">
<a href="javascript:detail('<?=$PRODUCT_ID?>');">详情 </a>
</td>
</tr>
<?
}
?>
<tr class="TableControl">
<td colspan="8" align="right">
<input type="button" value="首页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='list.php?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&MEASURE_UNIT=<?=$MEASURE_UNIT?>&COST_PRICE=<?=$COST_PRICE?>&STANDARD_PRICE=<?=$STANDARD_PRICE?>&PROVIDER_ID=<?=$PROVIDER_ID?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>'">
<input type="button" value="上一页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='list.php?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&MEASURE_UNIT=<?=$MEASURE_UNIT?>&COST_PRICE=<?=$COST_PRICE?>&STANDARD_PRICE=<?=$STANDARD_PRICE?>&PROVIDER_ID=<?=$PROVIDER_ID?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PAGE_START=<?=($PAGE_START-$PAGE_SIZE)?>'">
<input type="button" value="下一页" class="SmallButton" <?if($PAGE_END>=$PRODUCT_COUNT)echo "disabled";?> onclick="location='list.php?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&MEASURE_UNIT=<?=$MEASURE_UNIT?>&COST_PRICE=<?=$COST_PRICE?>&STANDARD_PRICE=<?=$STANDARD_PRICE?>&PROVIDER_ID=<?=$PROVIDER_ID?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PAGE_START=<?=($PAGE_END+1)?>'">
<input type="button" value="末页" class="SmallButton" <?if($PAGE_END>=$PRODUCT_COUNT)echo "disabled";?> onclick="location='list.php?PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&MEASURE_UNIT=<?=$MEASURE_UNIT?>&COST_PRICE=<?=$COST_PRICE?>&STANDARD_PRICE=<?=$STANDARD_PRICE?>&PROVIDER_ID=<?=$PROVIDER_ID?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PAGE_START=<?=$LAST_PAGE_START?>'">
页数
<input type="text" name="PAGE_NUM" value="<?=$PAGE_NUM?>" class="SmallInput" size="2"> <input type="button" value="转到" class="SmallButton" onclick="set_page();" title="转到指定的页面">
</td>
</tr>
</table>
<?
if($BE_CALLED=="YES")
{
?>
<br>
<div align="center">
<input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
</div>
<?
}
else
{
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='index.php';">
</div>
<?
}
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -