📄 index.php
字号:
<?
function getalldate ($CODE, $GETVALUE)
{
global $connection;
$query = (((''.'SELECT * from SYS_CODE where PARENT_NO=\'').$CODE).'\'');
$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>');
continue;
}
else
{
echo (((('<option value='.$CODE_NO).' >').$CODE_NAME).'</option>');
continue;
}
}
}
include_once 'inc/auth.php';
include_once 'inc/utility_all.php';
$PAGE_SIZE = 10;
echo '<html>
<head>
<title>供应商快速搜索 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
echo '<s';
echo 'cript Language="JavaScript">
function delete_customer(CUSTOMER_ID)
{
msg=\'确认要删除该供应商么？这也将删除相关的联系人、采购记录。\';
if(window.confirm(msg))
{
URL="delete.php?PROVIDER_NAME=';
echo $PROVIDER_NAME;
echo '&PROVIDER_CODE=';
echo $PROVIDER_CODE;
echo '&MEMO=';
echo $MEMO;
echo '&PROVIDER_SHORT=';
echo $PROVIDER_SHORT;
echo '&PROVIDER_AREA=';
echo $PROVIDER_AREA;
echo '&PROVIDER_DETAILID=';
echo $PROVIDER_DETAILID;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&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=';
echo $PROVIDER_NAME;
echo '&PROVIDER_CODE=';
echo $PROVIDER_CODE;
echo '&MEMO=';
echo $MEMO;
echo '&PROVIDER_SHORT=';
echo $PROVIDER_SHORT;
echo '&PROVIDER_AREA=';
echo $PROVIDER_AREA;
echo '&PROVIDER_DETAILID=';
echo $PROVIDER_DETAILID;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&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++)
';
echo ' {
if(document.all("allbox").checked)
if(!document.all("email_select").item(i).disabled)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;
}
}
funct';
echo 'ion 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(';
echo 'delete_str=="")
{
alert("请至少选择其中一个供应商。");
return;
}
msg=\'确认要删除所选供应商？\';
if(window.confirm(msg))
{
URL="delete.php?PROVIDER_NAME=';
echo $PROVIDER_NAME;
echo '&PROVIDER_CODE=';
echo $PROVIDER_CODE;
echo '&MEMO=';
echo $MEMO;
echo '&PROVIDER_SHORT=';
echo $PROVIDER_SHORT;
echo '&PROVIDER_AREA=';
echo $PROVIDER_AREA;
echo '&PROVIDER_DETAILID=';
echo $PROVIDER_DETAILID;
echo '&CUR_PAGE=';
echo $CUR_PAGE;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '&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"> 供应商名';
echo '称： </td>
<td nowrap class="TableData">
<input type="text" name="PROVIDER_NAME" class="SmallInput" size="15" maxlength="100" value="';
echo $PROVIDER_NAME;
echo '">
</td>
<td nowrap class="TableData">供应商编码： </td>
<td nowrap class="TableData">
<input type="text" name="PROVIDER_CODE" class="SmallInput" size="15" maxlength="100" value="';
echo $PROVIDER_CODE;
echo '">
</td>
<td nowrap class="TableData">供应商简称： </td>
<td nowrap class="TableData">
<input type="text" name="PROVIDER_SHORT" class="SmallInput" size="15" maxlength="100" value="';
echo $PROVIDER_SHORT;
echo '">
</td>
<td nowrap class="TableData"> 地区： </td>
<td nowrap class="TableData" >
';
echo '<s';
echo 'elect name="PROVIDER_AREA" class="SmallSelect">
';
getalldate ('AREA', $PROVIDER_AREA);
echo ' </select>
</td>
</tr>
<tr>
<td nowrap class="TableData"> 地区： </td>
<td nowrap class="TableData" >
';
echo '<s';
echo 'elect name="PROVIDER_AREA" class="SmallSelect">
';
getalldate ('AREA', $PROVIDER_AREA);
echo ' </select>
</td>
<td nowrap class="TableData">备注： </td>
<td nowrap class="TableData">
<input type="text" name="MEMO" class="SmallInput" size="15" maxlength="100" value="';
echo $MEMO;
echo '">
</td>
<td nowrap class="TableData" colspan="8" align="right">
<input value="查询" type="submit" class="SmallButton" title="模糊查询" name="button">
</td>
</tr>
</form>
</table>
</fieldset>
</div>
<br>
';
$query1 = 'select DEPT_ID from DEPARTMENT';
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$DEPT_ID = $ROW['DEPT_ID'];
if ((is_dept_priv ($DEPT_ID) == 1))
{
$TO_ID = (($TO_ID.$DEPT_ID).',');
continue;
}
}
$TO_ID = (('\''.str_replace (',', '\',\'', substr ($TO_ID, 0, -1))).'\'');
($WHERE_STR .= (((''.' where c.DEPT_ID in (').$TO_ID).')'));
$query1 = (((''.'select PRIV_NO from USER_PRIV where USER_PRIV=\'').$LOGIN_USER_PRIV).'\'');
$cursor1 = exequery ($connection, $query1);
if ($ROW = mysql_fetch_array ($cursor1))
{
$LOGIN_PRIVNO = $ROW['PRIV_NO'];
}
$query1 = 'select USER_PRIV,PRIV_NO from USER_PRIV';
$cursor1 = exequery ($connection, $query1);
while ($ROW = mysql_fetch_array ($cursor1))
{
$PRIV_NO = $ROW['PRIV_NO'];
$USER_PRIV = $ROW['USER_PRIV'];
if (($LOGIN_PRIVNO < $PRIV_NO))
{
$TO_PRIV = (($TO_PRIV.$USER_PRIV).',');
continue;
}
}
$TO_PRIV = (('\''.str_replace (',', '\',\'', substr ($TO_PRIV, 0, -1))).'\'');
($WHERE_STR .= (((((''.' and (c.USER_PRIV in (').$TO_PRIV).') or a.PROVIDER_RECORDER=\'').$LOGIN_USER_ID).'\')'));
if (($PROVIDER_NAME != ''))
{
($WHERE_STR .= ((' and PROVIDER_NAME like \'%'.$PROVIDER_NAME).'%\''));
}
if (($PROVIDER_CODE != ''))
{
($WHERE_STR .= ((' and PROVIDER_CODE like \'%'.$PROVIDER_CODE).'%\''));
}
if (($PROVIDER_SHORT != ''))
{
($WHERE_STR .= ((' and PROVIDER_SHORT like \'%'.$PROVIDER_SHORT).'%\''));
}
if (($PROVIDER_AREA != ''))
{
($WHERE_STR .= (((''.' and PROVIDER_AREA= \'').$PROVIDER_AREA).'\''));
}
if (($MEMO != ''))
{
($WHERE_STR .= ((' and MEMO like \'%'.$MEMO).'%\''));
}
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\'
LEFT OUTER JOIN USER c ON a.PROVIDER_RECORDER=c.USER_ID
'.$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) OR ($CUR_PAGE == '')))
{
$CUR_PAGE = 1;
}
if (($PAGE_COUNT < $CUR_PAGE))
{
$CUR_PAGE = $PAGE_COUNT;
}
$query1 = (('SELECT a.PROVIDER_RECORDER as PROVIDER_RECORDERID,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
{
echo '<table border="0" cellspacing="1" width="95%" class="small" cellpadding="3">
<tr>
<td align="left">
<a href="index.php?CUR_PAGE=1&PROVIDER_NAME=';
echo $PROVIDER_NAME;
echo '&MEMO=';
echo $MEMO;
echo '&PROVIDER_CODE=';
echo $PROVIDER_CODE;
echo '&PROVIDER_SHORT=';
echo $PROVIDER_SHORT;
echo '&PROVIDER_AREA=';
echo $PROVIDER_AREA;
echo '&PROVIDER_DETAILID=';
echo $PROVIDER_DETAILID;
echo '&ORDERFIELD=';
echo $ORDERFIELD;
echo '&ORDERTYPE=';
echo $ORDERTYPE;
echo '"><img src=\'/images/first02.gif\' width=\'24\' border=\'0\' height=\'15\' alt=\'首页\'></a>
<a href="index.php?CUR_PAGE=';
echo ($CUR_PAGE - 1);
echo '&PROVIDER_NAME=';
echo $PROVIDER_NAME;
echo '&MEMO=';
echo $MEMO;
echo '&PROVIDER_CODE=';
echo $PROVIDER_CODE;
echo '&PROVIDER_SHORT=';
echo $PROVIDER_SHORT;
echo '&PROVIDER_AREA=';
echo $PROVIDER_AREA;
echo '&PROVIDER_DETAILID=';
echo $PROVIDER_DETAILID;
echo '&ORDERFIELD=';
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -