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

📄 index.php

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

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


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

 $query="SELECT count(*) FROM `PRODUCT` a LEFT OUTER JOIN SYS_CODE b
        ON a.PRODUCT_MODE = b.CODE_NO AND b.PARENT_NO = 'PRODUCT_MODE'
        LEFT OUTER JOIN PROVIDER c
        ON a.PROVIDER_ID = c.PROVIDER_ID";

 $query.=$WHERE_STR;
 //echo  $query;
 $cursor= exequery($connection,$query);
 $LINKMAN_COUNT=0;
 if($ROW=mysql_fetch_array($cursor))
    $LINKMAN_COUNT=$ROW[0];

 $PER_PAGE=10;
 $PAGE_COUNT=ceil($LINKMAN_COUNT/$PER_PAGE);
 if($CUR_PAGE<=0 || $CUR_PAGE=="")
    $CUR_PAGE=1;
 if($CUR_PAGE>$PAGE_COUNT)
    $CUR_PAGE=$PAGE_COUNT;
$query1="SELECT * FROM PRODUCT a LEFT OUTER JOIN SYS_CODE b
        ON a.PRODUCT_MODE = b.CODE_NO AND b.PARENT_NO = 'PRODUCT_MODE'
        LEFT OUTER JOIN PROVIDER c
        ON a.PROVIDER_ID = c.PROVIDER_ID".$WHERE_STR.$OREDERBY;
$offest=($CUR_PAGE-1)*10;
if($offest<0)$offest=0;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;

$cursor1 = exequery($connection, $query1);

  if($LINKMAN_COUNT==0)
  {
     Message("<br>提示","没有符合条件的产品");
?>
<br>

<?
     exit;
  }
  else
  {
?>

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


<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">

<?
  $LINKMAN_COUNT = 0;
  while($ROW=mysql_fetch_array($cursor1))
  {
    $LINKMAN_COUNT++;
    $PRODUCT_ID1=$ROW["PRODUCT_ID"];
    $PRODUCT_NAME1=$ROW["PRODUCT_NAME"];
    $PRODUCT_CODE1=$ROW["PRODUCT_CODE"];
    $PRODUCT_TYPE1=$ROW["PRODUCT_TYPE"];
    $CODE_NAME1=$ROW["CODE_NAME"];
    $MEASURE_UNIT1=$ROW["MEASURE_UNIT"];
    $COST_PRICE1=$ROW["COST_PRICE"];
    $STANDARD_PRICE3=$ROW["STANDARD_PRICE"];
    $PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
    $PHOTO1=$ROW["PHOTO"];
   if($LINKMAN_COUNT%2==1)
     $TableLine="TableLine1";
   else
     $TableLine="TableLine2";

?>

    <tr class="<?=$TableLine?>">
    	 <td nowrap align="center"><a href=#this onclick="show_detail(<?=$PRODUCT_ID1?>);"><?=$PRODUCT_NAME1?></a></td>
    	 <td nowrap align="center"><?=$PRODUCT_CODE1?></td>
      <td nowrap align="center"><?=$PRODUCT_TYPE1?></td>
       <td nowrap align="center"><?=$CODE_NAME1?></td>
      <td nowrap align="center"><?=$MEASURE_UNIT1?></td>
      <td nowrap align="center"><?=$PROVIDER_NAME1?></td>
      <td nowrap align="center"><?=$STANDARD_PRICE3?></td>
	  <?
    if(find_id($MANAGERS,$LOGIN_USER_ID))
    {
		?>
      <td nowrap align="center" width="80">
    <a href="edit.php?PRODUCT_ID=<?=$PRODUCT_ID1?>&STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>&CUR_PAGE=<?=$CUR_PAGE?>">编辑</a>
      </td>
	  <?
	}
		?>
    </tr>
<?
  }
}
?>
  <thead class="TableHeader">
      <td nowrap align="center"><a href="index.php?STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=PRODUCT_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=="PRODUCT_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PRODUCT_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=PRODUCT_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=="PRODUCT_CODE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PRODUCT_CODE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=PRODUCT_TYPE&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=="PRODUCT_TYPE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PRODUCT_TYPE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=CODE_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=="CODE_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CODE_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=MEASURE_UNIT&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=="MEASURE_UNIT"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="MEASURE_UNIT"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&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="index.php?STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&STANDARD_PRICE2=<?=$STANDARD_PRICE2?>&STANDARD_PRICE1=<?=$STANDARD_PRICE1?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&PRODUCT_DESC=<?=$PRODUCT_DESC?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&ORDERFIELD=STANDARD_PRICE&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=="STANDARD_PRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="STANDARD_PRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
	  <?
    if(find_id($MANAGERS,$LOGIN_USER_ID))
    {
		?>
      <td nowrap align="center">操作</td>
	  <?
	}
		?>
  </thead>
</table>



</body>
</html>
<?
 function GETALLDATE($CODE,$SELSETED)
{
  global $connection;
  $query = "SELECT * from SYS_CODE where PARENT_NO='$CODE'";
  $connection=OpenConnection();
  $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($SELSETED==$CODE_NO)
	   echo "<option value=".$CODE_NO." selected>".$CODE_NAME."</option>";
   else
	   echo "<option value=".$CODE_NO.">".$CODE_NAME."</option>";
  }

}
?>
12

⌨️ 快捷键说明

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