📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
📖 第 1 页 / 共 2 页
字号:
上一页 12
 	&nbsp;<input value="快速查询" type="submit" class="SmallButton" title="快速查询" name="button">
  </td>
 </tr>
</form>
</table>
</fieldset>
</div>
<br>
<?
//-----------先组织SQL语句-----------

 $WHERE_STR.=" where a.SALESMAN='$LOGIN_USER_ID' and a.CONTRACT_ID='-1' and a.LINE_ID='-1' ";
 if($CUSTOMER_NAME!="")
		 $WHERE_STR.=" and b.CUSTOMER_NAME like '%".$CUSTOMER_NAME."%'";
 if($CUSTOMER_CODE!="")
		 $WHERE_STR.=" and b.CUSTOMER_CODE like '%".$CUSTOMER_CODE."%'";
 if($CUSTOMER_SHORT!="")
		 $WHERE_STR.=" and b.CUSTOMER_SHORT like '%".$CUSTOMER_SHORT."%'";
 if($ARE!="")
		 $WHERE_STR.=" and b.CUSTOMER_AREA= '$ARE'";
 if($KIND!="")
		 $WHERE_STR.=" and b.KIND= '$KIND'";
 if($SELLMODE!="")
		 $WHERE_STR.=" and b.SELLMODE= '$SELLMODE'";
 if($ATTRIBUTE!="")
		 $WHERE_STR.=" and b.ATTRIBUTE= '$ATTRIBUTE'";
 if($ENTERTYPE!="")
		 $WHERE_STR.=" and b.ENTERTYPE= '$ENTERTYPE'";
 if($PRODUCT_NAME!="")
     $WHERE_STR.=" and c.PRODUCT_NAME like '%".$PRODUCT_NAME."%'";
 if($PRODUCT_MODE!="")
      $WHERE_STR.=" and c.PRODUCT_MODE ='$PRODUCT_MODE'";
 if($PRODUCT_TYPE!="")
      $WHERE_STR.=" and c.PRODUCT_TYPE like '%".$PRODUCT_TYPE."%'";
 if($SERVICE_NAME!="")
    $WHERE_STR.=" and d.SERVICE_NAME like '%".$SERVICE_NAME."%'";
 if($SERVICE_DESC!="")
    $WHERE_STR.=" and d.SERVICE_DESC like '%".$SERVICE_DESC."%'";

if($DATE1!="")
    $WHERE_STR.="  and a.DATE>='$DATE1'";
if($DATE2!="")
    $WHERE_STR.="  and a.DATE<='$DATE2'";

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

$CUSTOMER_COUNT=0;
$query="SELECT count(*) from SALE_HISTORY a
        LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
        LEFT OUTER JOIN PRODUCT  c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'
        LEFT OUTER JOIN SERVICE  d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'
        LEFT OUTER JOIN USER  e ON a.SALESMAN=e.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 || $CUR_PAGE=="")
    $CUR_PAGE=1;
 if($CUR_PAGE>$PAGE_COUNT)
    $CUR_PAGE=$PAGE_COUNT;
$query1="SELECT c.PRODUCT_NAME as PRODUCT_NAME,d.SERVICE_NAME as SERVICE_NAME,a.PRICE as PRICE,a.AMT as AMT,a.TOTAL_PRICE as TOTAL_PRICE,a.DATE as DATE,e.USER_NAME as SELLER,b.CUSTOMER_NAME as CUSTOMER_NAME,a.HISTORY_ID as HISTORY_ID,a.TYPE as TYPE
         from SALE_HISTORY a
         LEFT OUTER JOIN CUSTOMER b ON a.CUSTOMER_ID=b.CUSTOMER_ID
         LEFT OUTER JOIN PRODUCT  c ON a.PRODUCT_ID=c.PRODUCT_ID and a.TYPE='PRO'
         LEFT OUTER JOIN SERVICE  d ON a.SERVICE_ID=d.SERVICE_ID and a.TYPE='SER'
         LEFT OUTER JOIN USER  e ON a.SALESMAN=e.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
  {
?>

<table border="0" cellspacing="1" width="95%" class="small"  cellpadding="3">
  <tr>
    <td align="left">
        <a href="index.php?CUR_PAGE=1&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&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?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&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?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&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?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&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;<?=$CUSTOMER_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">选择</td>
      <td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&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?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&ORDERFIELD=SERVICE_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=="SERVICE_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SERVICE_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&ORDERFIELD=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=="PRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="PRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&ORDERFIELD=AMT&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=="AMT"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="AMT"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&ORDERFIELD=TOTAL_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=="TOTAL_PRICE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="TOTAL_PRICE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&ORDERFIELD=DATE&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=="DATE"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="DATE"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE=<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&ORDERFIELD=CUSTOMER_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=="CUSTOMER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CUSTOMER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center">销售员</td>
      <td nowrap align="center">操作</td>
  </tr>

<?
  $CUSTOMER_COUNT=0;
  while($ROW=mysql_fetch_array($cursor1))
  {
    $CUSTOMER_COUNT++;
    $PRODUCT_NAME1=$ROW["PRODUCT_NAME"];
    $SERVICE_NAME1=$ROW["SERVICE_NAME"];
    $PRICE1=$ROW["PRICE"];
    $AMT1=$ROW["AMT"];
    $TOTAL_PRICE1=$ROW["TOTAL_PRICE"];
    $CREAT_DATE=$ROW["DATE"];
    $SELLER1=$ROW["SELLER"];
    $CUSTOMER_NAME1=$ROW["CUSTOMER_NAME"];
    $TYPE1=$ROW["TYPE"];
    $HISTORY_ID1=$ROW["HISTORY_ID"];
    if($CUSTOMER_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>
    <tr class="<?=$TableLine?>">
    	<td>&nbsp;<input type="checkbox" name="email_select" value="<?=$HISTORY_ID1?>" onClick="check_one(self);"></td>
      <td nowrap align="center"><?=$PRODUCT_NAME1?></td>
       <td nowrap align="center"><?=$SERVICE_NAME1?></td>
       <td nowrap align="center"><?=$PRICE1?></td>
      <td nowrap align="center"><?=$AMT1?></td>
      <td nowrap align="center"><?=$TOTAL_PRICE1?></td>
      <td nowrap align="center"><?=$CREAT_DATE?></td>

      <td nowrap align="center"><?=$CUSTOMER_NAME1?></td>
      <td nowrap align="center"><?=$SELLER1?></td>
      <td nowrap align="center">
     <a href="edit.php?HISTORY_ID=<?=$HISTORY_ID1?>&CUSTOMER_NAME=<?=$CUSTOMER_NAME?>&CUSTOMER_CODE =<?=$CUSTOMER_CODE?>&CUSTOMER_SHORT=<?=$CUSTOMER_SHORT?>&ARE=<?=$ARE?>&KIND=<?=$KIND?>&SELLMODE=<?=$SELLMODE?>&ATTRIBUTE=<?=$ATTRIBUTE?>&ENTERTYPE=<?=$ENTERTYPE?>&PRODUCT_NAME=<?=$PRODUCT_NAME?>&PRODUCT_MODE=<?=$PRODUCT_MODE?>&PRODUCT_TYPE=<?=$PRODUCT_TYPE?>&SERVICE_NAME=<?=$SERVICE_NAME?>&SERVICE_DESC=<?=$SERVICE_DESC?>&DATE1=<?=$DATE1?>&DATE2=<?=$DATE2?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"> 编辑</a>&nbsp;&nbsp;
     <a href="javascript:delete_customer(<?=$HISTORY_ID1?>);"> 删除 </a>
      </td>
    </tr>

<?
}
  }
?>
<tr class="TableControl">
 <td colspan="10">
 	   &nbsp;<input type="checkbox" name="allbox" id="allbox_for" onClick="check_all();">
      <label for="allbox_for">全选</label> &nbsp;
      <input type="button"  value="批量删除" class="SmallButton" onClick="delete_mail();" title="删除所选客户"> &nbsp;
 </td>
</tr>
</table>



</body>
</html>

<?
 function GETALLDATE($CODE,$GETVALUE)
{
  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 ($CODE_NO==$GETVALUE)
   {echo "<option value=".$CODE_NO."  selected>".$CODE_NAME."</option>";}
   else
   {echo "<option value=".$CODE_NO." >".$CODE_NAME."</option>";}
  }

}
?>
上一页 12
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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