📄 index.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
$PAGE_SIZE=10;
$query = "select * from SALE_MANAGER where MANAGER_ID=1";
$cursor=exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
{
$MANAGER_ID=$ROW["MANAGER_ID"];
$MANAGERS=$ROW["MANAGERS"];
$DELETE_FLAG=$ROW["DELETE_FLAG"];
}
?>
<html>
<head>
<title>采购订单快速搜索 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function show_detail(ORDER_ID)
{
URL="show_detail.php?ORDER_ID="+ORDER_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 print_form(ORDER_ID,ITEM_ID)
{
URL="print?ORDER_ID="+ORDER_ID+"&ITEM_ID="+ITEM_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_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
function delete_customer(ORDER_ID,urlstr)
{
msg='确认要删除该订单？这也将删除相关的订单明细和接货记录。';
if(window.confirm(msg))
{
URL="delete.php?ORDER_ID=" + ORDER_ID+"&"+urlstr+"&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
window.location=URL;
}
}
function ad_query()
{
URL="ad_query";
window.location=URL;
}
function td_calendar(fieldname)
{
myleft=document.body.scrollLeft+event.clientX-event.offsetX-80;
mytop=document.body.scrollTop+event.clientY-event.offsetY+140;
window.showModalDialog("/inc/calendar.php?FIELDNAME="+fieldname,self,"edge:raised;scroll:0;status:0;help:0;resizable:1;dialogWidth:280px;dialogHeight:205px;dialogTop:"+mytop+"px;dialogLeft:"+myleft+"px");
}
function set_page(urlstr)
{
PAGE_START=PAGE_NUM.value;
location="index.php?CUR_PAGE="+PAGE_START+"&"+urlstr;
}
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(urlstr)
{
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?delete_str="+delete_str+"&"+urlstr+"&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
window.location=URL;
}
}
</script>
</head>
<body topmargin="5" class="bodycolor">
<div align="left">
<fieldset style="width:95%;padding-bottom:5px;">
<legend class="small" align=left>
<b>快速查询</b>
</legend>
<table class="TableList" align="left" width="100%">
<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"> 订单类型： </td>
<td nowrap class="TableData" >
<select name="ORDER_TYPE" class="SmallSelect">
<?
GETALLDATE("ORDER_TYPE");
?>
</select>
</td>
<td nowrap class="TableData">订单编号： </td>
<td nowrap class="TableData">
<input type="text" name="ORDER_NO" class="SmallInput" size="15" maxlength="100" value="<?=$ORDER_NO?>">
</td>
<td nowrap class="TableData">订单名称： </td>
<td nowrap class="TableData">
<input type="text" name="ORDER_NAME" class="SmallInput" size="15" maxlength="100" value="<?=$ORDER_NAME?>">
</td>
<td nowrap class="TableData">负责人： </td>
<td nowrap class="TableData">
<input type="text" name="RECIVER" class="SmallInput" size="10" maxlength="100" value="<?=$RECIVER?>">
</td>
</tr>
<tr>
<td nowrap class="TableData">
<select name="DATE_TYPE" class="SmallSelect">
<option value="BEGIN">接货日期</option>
<option value="CREATE">创建日期</option>
</select>
</td>
<td nowrap class="TableData" colspan="3">
<input type="text" name="DATE1" size="15" maxlength="10" class="SmallStatic" readonly value="<?=$BEGIN_DATE?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.DATE1');">
至<input type="text" name="DATE2" size="15" maxlength="10" class="SmallStatic" readonly value="<?=$BEGIN_DATE?>">
<img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.DATE2');">
</td>
<td nowrap class="TableData">创建人： </td>
<td nowrap class="TableData" colspan="3">
<input type="text" name="CREATOR" class="SmallInput" size="15" maxlength="100" value="<?=$CREATOR?>">
</td>
</tr>
<tr>
<td nowrap class="TableData" colspan="8" >
<input value="快速查询" type="submit" class="SmallButton" title="快速查询" name="button">
<input value="高级查询" type="button" class="SmallButton" title="模糊查询" name="button1" onClick="ad_query();">
</td>
</tr>
</form>
</table>
</fieldset>
</div>
<br>
<br>
<?
//-----------先组织SQL语句-----------
if($PROVIDER_NAME!="")
{
if($urlstr=="")$urlstr="PROVIDER_NAME=".$PROVIDER_NAME;
else $urlstr=$urlstr."&PROVIDER_NAME=".$PROVIDER_NAME;
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
else
$WHERE_STR.=" and d.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
if($PROVIDER_CODE!="")
{
if($urlstr=="")$urlstr="PROVIDER_CODE=".$PROVIDER_CODE;
else $urlstr=$urlstr."&PROVIDER_CODE=".$PROVIDER_CODE;
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
else
$WHERE_STR.=" and d.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
if($PROVIDER_SHORT!="")
{
if($urlstr=="")$urlstr="PROVIDER_SHORT=".$PROVIDER_SHORT;
else $urlstr=$urlstr."&PROVIDER_SHORT=".$PROVIDER_SHORT;
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
else
$WHERE_STR.=" and d.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
}
if($PROVIDER_AREA!="")
{
if($urlstr=="")$urlstr="PROVIDER_AREA=".$PROVIDER_AREA;
else $urlstr=$urlstr."&PROVIDER_AREA=".$PROVIDER_AREA;
if($WHERE_STR=="")
$WHERE_STR.=" where d.PROVIDER_AREA ='$PROVIDER_AREA'";
else
$WHERE_STR.=" and d.PROVIDER_AREA ='$PROVIDER_AREA'";
}
if($ORDER_TYPE!="")
{
if($urlstr=="")$urlstr="ORDER_TYPE=".$ORDER_TYPE;
else $urlstr=$urlstr."&ORDER_TYPE=".$ORDER_TYPE;
if($WHERE_STR=="")
$WHERE_STR.=" where a.ORDER_TYPE ='$ORDER_TYPE'";
else
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -