⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 list.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％ 源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
     else $urlstr=$urlstr."&LINKMANUSERDEF1=".$LINKMANUSERDEF1;
	 if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF1 like '%".$LINKMANUSERDEF1."%'";
	 else
		 $WHERE_STR.=" and d.USERDEF1 like '%".$LINKMANUSERDEF1."%'";
  }
if($LINKMANUSERDEF2!="")
	 {
	 	 if($urlstr=="")$urlstr="LINKMANUSERDEF2=".$LINKMANUSERDEF2;
     else $urlstr=$urlstr."&LINKMANUSERDEF2=".$LINKMANUSERDEF2;
	 	if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF2 like '%".$LINKMANUSERDEF2."%'";
	 else
		 $WHERE_STR.=" and d.USERDEF2 like '%".$LINKMANUSERDEF2."%'";
		}

if($LINKMANUSERDEF3!="")
	{
		if($urlstr=="")$urlstr="LINKMANUSERDEF3=".$LINKMANUSERDEF3;
    else $urlstr=$urlstr."&LINKMANUSERDEF3=".$LINKMANUSERDEF3;
		if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF3 like '%".$LINKMANUSERDEF3."%'";
	 else
		 $WHERE_STR.=" and d.USERDEF3 like '%".$LINKMANUSERDEF3."%'";
		}
if($LINKMANUSERDEF4!="")
	 {
	 	if($urlstr=="")$urlstr="LINKMANUSERDEF4=".$LINKMANUSERDEF4;
    else $urlstr=$urlstr."&LINKMANUSERDEF4=".$LINKMANUSERDEF4;
	 	if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF4 like '%".$LINKMANUSERDEF4."%'";
	 else
		 $WHERE_STR.=" and d.USERDEF4 like '%".$LINKMANUSERDEF4."%'";
		}
if($LINKMANUSERDEF5!="")
	{
	  if($urlstr=="")$urlstr="LINKMANUSERDEF5=".$LINKMANUSERDEF5;
    else $urlstr=$urlstr."&LINKMANUSERDEF5=".$LINKMANUSERDEF5;
	  if($WHERE_STR=="")
		 $WHERE_STR.=" where d.USERDEF5 like '%".$LINKMANUSERDEF5."%'";
	 else
		 $WHERE_STR.=" and d.USERDEF5 like '%".$LINKMANUSERDEF5."%'";
	 }


if($ORDERFIELD!="")
   {
   	 if($ORDERSIGN=="DOWN")
   	  {
   	  	$ORDERTYPE="ASC";
   	  }
     if($ORDERSIGN=="UP")
   	  {
   	  	$ORDERTYPE="DESC";
   	  }
    $OREDERBY=" ORDER BY a.".$ORDERFIELD." ".$ORDERTYPE;
   }

$PROVIDER_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 
         LEFT OUTER JOIN PROVIDER_LINKMAN d ON  a.PROVIDER_ID = d.PROVIDER_ID 
         ".$WHERE_STR.$OREDERBY;
$cursor= exequery($connection, $query);
while($ROW=mysql_fetch_array($cursor))
{
	$PROVIDER_COUNT++;
}

 $PER_PAGE=10;
 $PAGE_COUNT=ceil($PROVIDER_COUNT/$PER_PAGE);
 if($CUR_PAGE<=0 || $CUR_PAGE=="")
    $CUR_PAGE=1;
 if($CUR_PAGE>$PAGE_COUNT)
    $CUR_PAGE=$PAGE_COUNT;
$query1="SELECT a.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 
         LEFT OUTER JOIN PROVIDER_LINKMAN d ON  a.PROVIDER_ID = d.PROVIDER_ID 
         ".$WHERE_STR.$OREDERBY;
$offest=($CUR_PAGE-1)*10;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
  if($PROVIDER_COUNT==0)
  {
     Message("<br>提示","没有符合条件的供应商");
     exit;
  }
  else
  {
?>
<body class="bodycolor" topmargin="5">
<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/infofind.gif" WIDTH="22" HEIGHT="22" align="absmiddle"><span class="big3">&nbsp;&nbsp;综合查询结果</span><br>
    </td>
  </tr>
</table>
<br>

<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="list.php?<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=1"><img src='/images/first02.gif' width='24' border='0' height='15' alt='首页'></a>
        <a href="list.php?<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE-1?>"><img src='/images/first01.gif' width='24' border='0' height='15' alt='上一页'></a>
        <a href="list.php?<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE+1?>"><img src='/images/last01.gif' width='24' border='0' height='15' alt='下一页' style="cursor:hand"></a>
        <a href="list.php?<?=$urlstr?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$PAGE_COUNT?>"><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('<?=$urlstr?>')" border="0" WIDTH="19" HEIGHT="17" style="cursor:hand" alt="转到相应页面">
    </td>
    <td align="right">
      <?=$CUR_PAGE?>/<?=$PAGE_COUNT?>页&nbsp;共&nbsp;<?=$PROVIDER_COUNT?>&nbsp;条
    </td>
  </tr>
</table>

<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&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?>">供应商编码&nbsp;<? 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="list.php?<?=$urlstr?>&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?>">供应商名称&nbsp;<? 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="list.php?<?=$urlstr?>&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?>">地址&nbsp;<? 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"><a href="list.php?<?=$urlstr?>&ORDERFIELD=TEL_NO&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?>">电话&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="TEL_NO"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="TEL_NO"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=FAX_NO&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?>">传真&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="FAX_NO"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="FAX_NO"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&ORDERFIELD=EMAIL&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?>">电子邮件&nbsp;<? if($ORDERTYPE=="DESC" and $ORDERFIELD=="EMAIL"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="EMAIL"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="list.php?<?=$urlstr?>&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?>">记录员&nbsp;<? 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>

<?
  $PROVIDER_COUNT=0;
  while($ROW=mysql_fetch_array($cursor1))
  {
    $PROVIDER_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($PROVIDER_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>
    <tr class="<?=$TableLine?>">
       <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>    	
	  </td>
    </tr>

<?
}
  }
?>
</table>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onclick="location='index.php'">
</div>
</body>
</html>
12

⌨️ 快捷键说明

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