📄 index.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
?>
<html>
<head>
<title>供应商快速搜索 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function delete_customer(CUSTOMER_ID)
{
msg='确认要删除该供应商么？这也将删除相关的联系人、采购记录。';
if(window.confirm(msg))
{
URL="delete.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&PROVIDER_ID=" + CUSTOMER_ID;
window.location=URL;
}
}
function ad_query()
{
URL="ad_query";
window.location=URL;
}
function check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function set_page()
{
PAGE_START=PAGE_NUM.value;
location="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE="+PAGE_START;
}
function show_detail(PROVIDER_ID)
{
URL="showdetail.php?PROVIDER_ID="+PROVIDER_ID;
myleft=(screen.availWidth-650)/2;
window.open(URL,"formul_edit","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function check_all()
{
for (i=0;i<document.all("email_select").length;i++)
{
if(document.all("allbox").checked)
document.all("email_select").item(i).checked=true;
else
document.all("email_select").item(i).checked=false;
}
if(i==0)
{
if(document.all("allbox").checked)
document.all("email_select").checked=true;
else
document.all("email_select").checked=false;
}
}
function delete_mail()
{
delete_str="";
for(i=0;i<document.all("email_select").length;i++)
{
el=document.all("email_select").item(i);
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(i==0)
{
el=document.all("email_select");
if(el.checked)
{ val=el.value;
delete_str+=val + ",";
}
}
if(delete_str=="")
{
alert("请至少选择其中一个供应商。");
return;
}
msg='确认要删除所选供应商？';
if(window.confirm(msg))
{
URL="delete.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&delete_str="+delete_str;
window.location=URL;
}
}
</script>
</head>
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
<legend class="small" align=left>
<b>快速查询</b>
</legend>
<table cellspacing="1" class="small" align="left" cellpadding="3">
<form action="index.php" method="post" name="form1">
<tr>
<td nowrap class="TableData"> 供应商名称： </td>
<td nowrap class="TableData">
<input type="text" name="PROVIDER_NAME" class="SmallInput" size="15" maxlength="100" value="<?=$PROVIDER_NAME?>">
</td>
<td nowrap class="TableData">供应商编码： </td>
<td nowrap class="TableData">
<input type="text" name="PROVIDER_CODE" class="SmallInput" size="15" maxlength="100" value="<?=$PROVIDER_CODE?>">
</td>
<td nowrap class="TableData">供应商简称： </td>
<td nowrap class="TableData">
<input type="text" name="PROVIDER_SHORT" class="SmallInput" size="15" maxlength="100" value="<?=$PROVIDER_SHORT?>">
</td>
<td nowrap class="TableData"> 地区： </td>
<td nowrap class="TableData" >
<select name="PROVIDER_AREA" class="SmallSelect">
<?
GETALLDATE("AREA",$PROVIDER_AREA);
?>
</select>
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="8" align="right">
<input value="查询" type="submit" class="SmallButton" title="模糊查询" name="button">
</td>
</tr>
</form>
</table>
</fieldset>
</div>
<br>
<?
//-----------先组织SQL语句-----------
if($PROVIDER_NAME!="")
{
if($WHERE_STR=="")
$WHERE_STR.=" where PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
else
$WHERE_STR.=" and PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
if($PROVIDER_CODE!="")
{
if($WHERE_STR=="")
$WHERE_STR.=" where PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
else
$WHERE_STR.=" and PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
if($PROVIDER_SHORT!="")
{
if($WHERE_STR=="")
$WHERE_STR.=" where PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
else
$WHERE_STR.=" and PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
}
if($PROVIDER_AREA!="")
{
if($WHERE_STR=="")
$WHERE_STR.=" where PROVIDER_AREA= '$PROVIDER_AREA'";
else
$WHERE_STR.=" and PROVIDER_AREA= '$PROVIDER_AREA'";
}
if($ORDERFIELD!="")
{
if($ORDERSIGN=="DOWN")
{
$ORDERTYPE="ASC";
}
if($ORDERSIGN=="UP")
{
$ORDERTYPE="DESC";
}
$OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
}
$CUSTOMER_COUNT=0;
$query="SELECT count(*) from PROVIDER a
LEFT OUTER JOIN SYS_CODE b ON a.PROVIDER_AREA=b.CODE_NO AND b.PARENT_NO = 'AREA'
".$WHERE_STR;
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$CUSTOMER_COUNT=$ROW[0];
$PER_PAGE=10;
$PAGE_COUNT=ceil($CUSTOMER_COUNT/$PER_PAGE);
if($CUR_PAGE<=0 || $CUR_PAGE=="")
$CUR_PAGE=1;
if($CUR_PAGE>$PAGE_COUNT)
$CUR_PAGE=$PAGE_COUNT;
$query1="SELECT PROVIDER_ID,PROVIDER_NAME,TEL_NO,FAX_NO,a.EMAIL as EMAIL,b.CODE_NAME as PROVIDER_AREA,BANK,ACCOUNT,PROVIDER_CODE,USER_NAME as PROVIDER_RECORDER from PROVIDER a
LEFT OUTER JOIN SYS_CODE b ON a.PROVIDER_AREA=b.CODE_NO AND b.PARENT_NO = 'AREA'
LEFT OUTER JOIN USER c ON a.PROVIDER_RECORDER=c.USER_ID
".$WHERE_STR.$OREDERBY;
$offest=($CUR_PAGE-1)*10;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
if($CUSTOMER_COUNT==0)
{
Message("<br>提示","没有符合条件的供应商");
exit;
}
else
{
?>
<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="index.php?CUR_PAGE=1&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
<a href="index.php?CUR_PAGE=<?=$CUR_PAGE-1?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
<a href="index.php?CUR_PAGE=<?=$CUR_PAGE+1?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
<a href="index.php?CUR_PAGE=<?=$PAGE_COUNT?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"><img src='/images/last02.gif' width='24' border='0' height='15' alt='末页' style="cursor:hand"></a>
到
<input type="text" name="PAGE_NUM" size="3" maxlength="4" class="SmallInput">
页
<img id="btnGotoPage" src="/images/menu/book.gif" onclick="set_page()" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
</td>
<td align="right">
<?=$CUR_PAGE?>/<?=$PAGE_COUNT?>页 共 <?=$CUSTOMER_COUNT?> 条
</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"><a href="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=PROVIDER_CODE&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">供应商编码 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="PROVIDER_CODE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PROVIDER_CODE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=PROVIDER_NAME&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">供应商名称 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="PROVIDER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PROVIDER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center"><a href="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=PROVIDER_AREA&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">地区 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="PROVIDER_AREA"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PROVIDER_AREA"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center">电话</td>
<td nowrap align="center">传真</td>
<td nowrap align="center">电子邮件</td>
<td nowrap align="center"><a href="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=PROVIDER_RECORDER&ORDERSIGN=<? if($ORDERSIGN=="DOWN"){echo "UP";}if($ORDERSIGN=="UP"){echo "DOWN";} if($ORDERSIGN==""){if($ORDERTYPE=="ASC"){echo "UP";}else echo "DOWN";}?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">记录员 <? if($ORDERTYPE=="DESC" and $ORDERFIELD=="PROVIDER_RECORDER"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PROVIDER_RECORDER"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
<td nowrap align="center">操作</td>
</tr>
<?
$CUSTOMER_COUNT=0;
while($ROW=mysql_fetch_array($cursor1))
{
$CUSTOMER_COUNT++;
$PROVIDER_ID1=$ROW["PROVIDER_ID"];
$PROVIDER_AREA1=$ROW["PROVIDER_AREA"];
$PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
$PROVIDER_CODE1=$ROW["PROVIDER_CODE"];
$PROVIDER_RECORDER1=$ROW["PROVIDER_RECORDER"];
$TEL_NO1=$ROW["TEL_NO"];
$FAX_NO1=$ROW["FAX_NO"];
$EMAIL1=$ROW["EMAIL"];
$BANK1=$ROW["BANK"];
$ACCOUNT1=$ROW["ACCOUNT"];
if($CUSTOMER_COUNT%2==1)
$TableLine="TableLine1";
else
$TableLine="TableLine2";
?>
<tr class="<?=$TableLine?>">
<td> <input type="checkbox" name="email_select" value="<?=$PROVIDER_ID1?>" <? if($SIGN=="1") echo "disabled"; ?> onClick="check_one(self);"></td>
<td nowrap align="center"><?=$PROVIDER_CODE1?></td>
<td nowrap align="center"><?=$PROVIDER_NAME1?></td>
<td nowrap align="center"><?=$PROVIDER_AREA1?></td>
<td nowrap align="center"><?=$TEL_NO1?></td>
<td nowrap align="center"><?=$FAX_NO1?></td>
<td nowrap align="center"><?=$EMAIL1?></td>
<td nowrap align="center"><?=$PROVIDER_RECORDER1?></td>
<td nowrap align="center">
<a href="javascript:show_detail(<?=$PROVIDER_ID1?>);"> 详细信息 </a>
<a href="edit.php?PROVIDER_ID=<?=$PROVIDER_ID1?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&PROVIDER_AREA=<?=$PROVIDER_AREA?>&PROVIDER_DETAILID=<?=$PROVIDER_DETAILID?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>"> 编辑</a>
<a href="javascript:delete_customer(<?=$PROVIDER_ID1?>);"> 删除 </a>
</td>
</tr>
<?
}
}
?>
<tr class="TableControl">
<td colspan="10">
<input type="checkbox" name="allbox" id="allbox_for" <? if($SIGN=="1") echo "disabled"; ?> onClick="check_all();">
<label for="allbox_for">全选</label>
<input type="button" value="批量删除" class="SmallButton" onClick="delete_mail();" title="删除所选供应商">
</td>
</tr>
</table>
</body>
</html>
<?
function GETALLDATE($CODE,$GETVALUE)
{
global $connection;
$query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
$connection=OpenConnection();
$cursor= exequery($connection,$query);
echo "<option value= ".">".""."</option>";
while($ROW=mysql_fetch_array($cursor))
{
$CODE_NO=$ROW["CODE_NO"];
$CODE_NAME=$ROW["CODE_NAME"];
if ($CODE_NO==$GETVALUE)
{echo "<option value=".$CODE_NO." selected>".$CODE_NAME."</option>";}
else
{echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";}
}
}
?>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -