📄 index.php
字号:
<?
include_once("inc/auth.php");
?>
<html>
<head>
<title>供应商联系人管理 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function set_page()
{
PAGE_START=PAGE_NUM.value;
location="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE="+PAGE_START;
}
function delete_linkman(LINKMAN_ID)
{
msg='确认要删除该联系人？';
if(window.confirm(msg))
{
URL="delete.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&LINKMAN_ID=" + LINKMAN_ID;
window.location=URL;
}
}
function check_one(el)
{
if(!el.checked)
document.all("allbox").checked=false;
}
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?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE =<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&delete_str=" + delete_str;
window.location=URL;
}
}
function mobile_sms(MOBIL_NO_STR)
{
URL="/general/mobile_sms/new/?TO_ID1="+MOBIL_NO_STR;
myleft=(screen.availWidth-650)/2;
window.open(URL,"mobile_sms","height=350,width=650,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function show_detail(LINKMAN_ID)
{
URL="showdetail.php?LINKMAN_ID="+LINKMAN_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");
}
</script>
</head>
<body>
<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">
</td>
<td nowrap class="TableData">供应商编码： </td>
<td nowrap class="TableData">
<input type="text" name="PROVIDER_CODE" class="SmallInput" size="15" maxlength="100">
</td>
<td nowrap class="TableData">供应商简称： </td>
<td nowrap class="TableData">
<input type="text" name="PROVIDER_SHORT" class="SmallInput" size="15" maxlength="100">
</td>
</tr>
<tr>
<td nowrap class="TableData"> 联系人姓名： </td>
<td nowrap class="TableData">
<input type="text" name="LINKMAN_NAME" class="SmallInput" size="15" maxlength="100">
</td>
<td nowrap class="TableData">地址： </td>
<td nowrap class="TableData">
<input type="text" name="ADD_HOME" class="SmallInput" size="15" maxlength="100" >
</td>
<td nowrap class="TableData">性别： </td>
<td nowrap class="TableData">
<select name="SEX" class="SmallSelect">
<option value="" ></option>
<option value="0" <? if($SEX=="0") echo "selected";?>>男</option>
<option value="1" <? if($SEX=="1") echo "selected";?>>女</option>
</select>
<input type="checkbox" name="MAIN_LINKMAN" id="MAIN_LINKMAN" value="1"><label for="MAIN_LINKMAN">主联系人</label>
<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_NAME!="")
{
if($WHERE_STR=="")
$WHERE_STR.=" where b.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
else
$WHERE_STR.=" and b.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
}
if($PROVIDER_CODE!="")
{
if($WHERE_STR=="")
$WHERE_STR.=" where b.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
else
$WHERE_STR.=" and b.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
}
if($PROVIDER_SHORT!="")
{
if($WHERE_STR=="")
$WHERE_STR.=" where b.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -