📄 list.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<?
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 set_page(urlstr)
{
 PAGE_START=PAGE_NUM.value;
 location="list.php?"+urlstr+"&CUR_PAGE="+PAGE_START+"&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>";
}

function show_detail(PROVIDER_ID)
{
 URL="showdetail.php?PROVIDER_ID="+PROVIDER_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=350,width=650,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>

<?
//-----------先组织SQL语句-----------
$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_ID1=$TO_ID1.$DEPT_ID.",";
	}
}
$TO_ID1="'".str_replace(",","','",substr($TO_ID1,0,-1))."'";
$WHERE_STR=" where (c.DEPT_ID in ($TO_ID1) or a.PROVIDER_RECORDER='$LOGIN_USER_ID') ";

 if($PROVIDER_NAME!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";
     else
         $WHERE_STR.=" and a.PROVIDER_NAME like '%".$PROVIDER_NAME."%'";

 if($PROVIDER_CODE!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";
     else
         $WHERE_STR.=" and a.PROVIDER_CODE like '%".$PROVIDER_CODE."%'";

 if($PROVIDER_SHORT!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
     else
         $WHERE_STR.=" and a.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";

 if($PROVIDER_AREA!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.PROVIDER_AREA = '".$PROVIDER_AREA."'";
     else
         $WHERE_STR.=" and a.PROVIDER_AREA = '".$PROVIDER_AREA."'";

 if($TEL_NO!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.TEL_NO like '%".$TEL_NO."%'";
     else
         $WHERE_STR.=" and a.TEL_NO like '%".$TEL_NO."%'";
         
 if($PROVIDER_ADD!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.PROVIDER_ADD like '%".$PROVIDER_ADD."%'";
     else
         $WHERE_STR.=" and a.PROVIDER_ADD like '%".$PROVIDER_ADD."%'";

 if($MEMO!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.MEMO like '%".$MEMO."%'";
     else
         $WHERE_STR.=" and a.MEMO like '%".$MEMO."%'";

 if($ACCOUNT!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.ACCOUNT like '%".$ACCOUNT."%'";
     else
         $WHERE_STR.=" and a.ACCOUNT like '%".$ACCOUNT."%'";

 if($BANK!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where a.BANK like '%".$BANK."%'";
     else
         $WHERE_STR.=" and a.BANK like '%".$BANK."%'";

if($PROVIDERUSERDEF1!="")
	 {
	 		if($urlstr=="")$urlstr="PROVIDERUSERDEF1=".$PROVIDERUSERDEF1;
      else $urlstr=$urlstr."&PROVIDERUSERDEF1=".$PROVIDERUSERDEF1;
	 	if($WHERE_STR=="")
		 $WHERE_STR.=" where a.USERDEF1 like '%".$PROVIDERUSERDEF1."%'";
	  else
		 $WHERE_STR.=" and a.USERDEF1 like '%".$PROVIDERUSERDEF1."%'";
    }
 if($PROVIDERUSERDEF2!="")
	{
		if($urlstr=="")$urlstr="PROVIDERUSERDEF2=".$PROVIDERUSERDEF2;
      else $urlstr=$urlstr."&PROVIDERUSERDEF2=".$PROVIDERUSERDEF2;
	  if($WHERE_STR=="")
		 $WHERE_STR.=" where a.USERDEF2 like '%".$PROVIDERUSERDEF2."%'";
	  else
		 $WHERE_STR.=" and a.USERDEF2 like '%".$PROVIDERUSERDEF2."%'";
  }
  if($PROVIDERUSERDEF3!="")
	 {
	 		if($urlstr=="")$urlstr="PROVIDERUSERDEF3=".$PROVIDERUSERDEF3;
      else $urlstr=$urlstr."&PROVIDERUSERDEF3=".$PROVIDERUSERDEF3;
	 	if($WHERE_STR=="")
		 $WHERE_STR.=" where a.USERDEF3 like '%".$PROVIDERUSERDEF3."%'";
	 else
		 $WHERE_STR.=" and a.USERDEF3 like '%".$PROVIDERUSERDEF3."%'";
   }
	if($PROVIDERUSERDEF4!="")
	 {
	  if($urlstr=="")$urlstr="PROVIDERUSERDEF4=".$PROVIDERUSERDEF4;
    else $urlstr=$urlstr."&PROVIDERUSERDEF4=".$PROVIDERUSERDEF4;
	  if($WHERE_STR=="")
		 $WHERE_STR.=" where a.USERDEF4 like '%".$PROVIDERUSERDEF4."%'";
	  else
		 $WHERE_STR.=" and a.USERDEF4 like '%".$PROVIDERUSERDEF4."%'";
    }
 if($PROVIDERUSERDEF5!="")
	{
		 if($urlstr=="")$urlstr="PROVIDERUSERDEF5=".$PROVIDERUSERDEF5;
    else $urlstr=$urlstr."&PROVIDERUSERDEF5=".$PROVIDERUSERDEF5;
		if($WHERE_STR=="")
		 $WHERE_STR.=" where a.USERDEF5 like '%".$PROVIDERUSERDEF5."%'";
	 else
		 $WHERE_STR.=" and a.USERDEF5 like '%".$PROVIDERUSERDEF5."%'";
   }

 if($LINKMAN_NAME!="")
   {
      if($urlstr=="")$urlstr="LINKMAN_NAME=".$LINKMAN_NAME;
     else $urlstr=$urlstr."&LINKMAN_NAME=".$LINKMAN_NAME;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
     else
         $WHERE_STR.=" and d.LINKMAN_NAME like '%".$LINKMAN_NAME."%'";
   }
if($SEX!="")
   {
   	 if($urlstr=="")$urlstr="SEX=".$SEX;
     else $urlstr=$urlstr."&SEX=".$SEX;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.SEX ='$SEX'";
     else
         $WHERE_STR.=" and d.SEX ='$SEX'";
   }
if($HOBBY!="")
   {
   	 if($urlstr=="")$urlstr="HOBBY=".$HOBBY;
     else $urlstr=$urlstr."&HOBBY=".$HOBBY;
     if($WHERE_STR=="")
         $WHERE_STR.=" where d.HOBBY like '%".$HOBBY."%'";
     else
         $WHERE_STR.=" and d.HOBBY like '%".$HOBBY."%'";
   }
 
if($MAIN_LINKMAN!="")
{
   if($WHERE_STR=="")
	 $WHERE_STR.=" where d.MAIN_LINKMAN='".$MAIN_LINKMAN."'";
 else
	  $WHERE_STR.=" and d.MAIN_LINKMAN='".$MAIN_LINKMAN."'";
} 	

if($LINKMANUSERDEF1!="")
	{
	  if($urlstr=="")$urlstr="LINKMANUSERDEF1=".$LINKMANUSERDEF1;
12 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -