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

📄 index.php

📁 极限网络智能办公系统 - Office Automation 2008 官方100％ 源码
💻 PHP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
    <td nowrap class="TableData">
        <input type="text" name="REMARK0" class="SmallInput" size="15" maxlength="100" value="<?=$REMARK0?>">
    </td>
 	<td nowrap class="TableData">登记时间： </td>
    <td nowrap class="TableData">
        <input type="text" name="ADD_TIME0" class="SmallInput" size="15" maxlength="50" value="<?=$ADD_TIME0?>">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.ADD_TIME0');">
        -
		<input type="text" name="ADD_TIME1" class="SmallInput" size="15" maxlength="50" value="<?=$ADD_TIME1?>">
        <img src="/images/menu/calendar.gif" border="0" style="cursor:hand" onclick="td_calendar('form1.ADD_TIME1');">
    </td>
 </tr>
 <tr>
 	<td nowrap class="TableData"  colspan="3" >
 	&nbsp;&nbsp;<input value="查询" type="submit" class="SmallButton" title="快速查询" name="button">
  </td>
 </tr>
</form>
</table>
</fieldset>
</div>
<br>
<br>
<?
//-----------先组织SQL语句-----------

 $WHERE_STR=" where 1=1";		 
 if($CHANCE_NAME0!="")
		 $WHERE_STR.=" and CHANCE_NAME like '%".$CHANCE_NAME0."%'";		 
 if($CUSTOMER_NAME0!="")
		 $WHERE_STR.=" and d.CUSTOMER_NAME like '%$CUSTOMER_NAME0%'";
 if($SELLER_NAME0!="")
		 $WHERE_STR.=" and e.USER_NAME like '%$SELLER_NAME0%'";
 if($CHANCE_RANK0!="")
		 $WHERE_STR.=" and CHANCE_RANK= '$CHANCE_RANK0'";
 if($CHANCE_STATUS0!="")
		 $WHERE_STR.=" and CHANCE_STATUS= '$CHANCE_STATUS0'";
 if($BARGAIN_DATE0!="")
		 $WHERE_STR.=" and BARGAIN_DATE>= '$BARGAIN_DATE0'";
 if($BARGAIN_DATE1!="")
		 $WHERE_STR.=" and BARGAIN_DATE<= '$BARGAIN_DATE1'";
 if($BARGAIN_MONEY0!="")
		 $WHERE_STR.=" and BARGAIN_MONEY>= '$BARGAIN_MONEY0'";
 if($BARGAIN_MONEY1!="")
		 $WHERE_STR.=" and BARGAIN_MONEY<= '$BARGAIN_MONEY1'";
 if($DESC0!="")
		 $WHERE_STR.=" and `DESC` like '%$DESC0%'";
 if($REMARK0!="")
		 $WHERE_STR.=" and REMARK like '%$REMARK0%'";
 if($ADD_TIME0!="")
		 $WHERE_STR.=" and ADD_TIME>= '$ADD_TIME0 00:00:00'";
 if($ADD_TIME1!="")
		 $WHERE_STR.=" and ADD_TIME<= '$ADD_TIME1 23:59:59'";

 if($ORDERFIELD!="")
 {
   	 if($ORDERSIGN=="DOWN")
   	  {
   	  	$ORDERTYPE="ASC";
   	  }
     if($ORDERSIGN=="UP")
   	  {
   	  	$ORDERTYPE="DESC";
   	  }
    $OREDERBY=" ORDER BY ".$ORDERFIELD." ".$ORDERTYPE;
 }
$CHANCE_COUNT=0;
$query="SELECT count(*) from SALE_CHANCE a LEFT OUTER JOIN SYS_CODE b ON a.CHANCE_RANK = b.CODE_NO AND b.PARENT_NO = 'CHANCE_RANK' LEFT OUTER JOIN SYS_CODE c ON a.CHANCE_STATUS = c.CODE_NO AND c.PARENT_NO = 'CHANCE_STATUS' LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID LEFT OUTER JOIN USER e ON a.SELLER = e.USER_ID ".$WHERE_STR;
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
  $CHANCE_COUNT=$ROW[0];

 $PER_PAGE=10;
 $PAGE_COUNT=ceil($CHANCE_COUNT/$PER_PAGE);
 if($CUR_PAGE<=0 || $CUR_PAGE=="")
    $CUR_PAGE=1;
 if($CUR_PAGE>$PAGE_COUNT)
    $CUR_PAGE=$PAGE_COUNT;
$query1="SELECT a.*,b.CODE_NAME CHANCE_RANK,c.CODE_NAME CHANCE_STATUS,d.CUSTOMER_NAME,e.USER_NAME SELLER_NAME from SALE_CHANCE a LEFT OUTER JOIN SYS_CODE b ON a.CHANCE_RANK = b.CODE_NO AND b.PARENT_NO = 'CHANCE_RANK' LEFT OUTER JOIN SYS_CODE c ON a.CHANCE_STATUS = c.CODE_NO AND c.PARENT_NO = 'CHANCE_STATUS' LEFT OUTER JOIN CUSTOMER d ON a.CUSTOMER_ID = d.CUSTOMER_ID LEFT OUTER JOIN USER e ON a.SELLER = e.USER_ID ".$WHERE_STR.$OREDERBY;
$offest=($CUR_PAGE-1)*10;
$query1=$query1." LIMIT ". $offest." ,".$PER_PAGE;
$cursor1 = exequery($connection, $query1);
  if($CHANCE_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&CHANCE_NAME0=<?=$CHANCE_NAME0?>&CUSTOMER_NAME0=<?=$CUSTOMER_NAME0?>&SELLER_NAME0=<?=$SELLER_NAME0?>&CHANCE_RANK0=<?=$CHANCE_RANK0?>&BARGAIN_MONEY0=<?=$BARGAIN_MONEY0?>&BARGAIN_MONEY1=<?=$BARGAIN_MONEY1?>&CHANCE_STATUS0=<?=$CHANCE_STATUS0?>&BARGAIN_DATE0=<?=$BARGAIN_DATE0?>&BARGAIN_DATE1=<?=$BARGAIN_DATE1?>&DESC0=<?=$DESC0?>&REMARK0=<?=$REMARK0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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?>&CHANCE_NAME0=<?=$CHANCE_NAME0?>&CUSTOMER_NAME0=<?=$CUSTOMER_NAME0?>&SELLER_NAME0=<?=$SELLER_NAME0?>&CHANCE_RANK0=<?=$CHANCE_RANK0?>&BARGAIN_MONEY0=<?=$BARGAIN_MONEY0?>&BARGAIN_MONEY1=<?=$BARGAIN_MONEY1?>&CHANCE_STATUS0=<?=$CHANCE_STATUS0?>&BARGAIN_DATE0=<?=$BARGAIN_DATE0?>&BARGAIN_DATE1=<?=$BARGAIN_DATE1?>&DESC0=<?=$DESC0?>&REMARK0=<?=$REMARK0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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?>&CHANCE_NAME0=<?=$CHANCE_NAME0?>&CUSTOMER_NAME0=<?=$CUSTOMER_NAME0?>&SELLER_NAME0=<?=$SELLER_NAME0?>&CHANCE_RANK0=<?=$CHANCE_RANK0?>&BARGAIN_MONEY0=<?=$BARGAIN_MONEY0?>&BARGAIN_MONEY1=<?=$BARGAIN_MONEY1?>&CHANCE_STATUS0=<?=$CHANCE_STATUS0?>&BARGAIN_DATE0=<?=$BARGAIN_DATE0?>&BARGAIN_DATE1=<?=$BARGAIN_DATE1?>&DESC0=<?=$DESC0?>&REMARK0=<?=$REMARK0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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?>&CHANCE_NAME0=<?=$CHANCE_NAME0?>&CUSTOMER_NAME0=<?=$CUSTOMER_NAME0?>&SELLER_NAME0=<?=$SELLER_NAME0?>&CHANCE_RANK0=<?=$CHANCE_RANK0?>&BARGAIN_MONEY0=<?=$BARGAIN_MONEY0?>&BARGAIN_MONEY1=<?=$BARGAIN_MONEY1?>&CHANCE_STATUS0=<?=$CHANCE_STATUS0?>&BARGAIN_DATE0=<?=$BARGAIN_DATE0?>&BARGAIN_DATE1=<?=$BARGAIN_DATE1?>&DESC0=<?=$DESC0?>&REMARK0=<?=$REMARK0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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;<?=$CHANCE_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="index.php?CHANCE_NAME0=<?=$CHANCE_NAME0?>&CUSTOMER_NAME0=<?=$CUSTOMER_NAME0?>&SELLER_NAME0=<?=$SELLER_NAME0?>&CHANCE_RANK0=<?=$CHANCE_RANK0?>&BARGAIN_MONEY0=<?=$BARGAIN_MONEY0?>&BARGAIN_MONEY1=<?=$BARGAIN_MONEY1?>&CHANCE_STATUS0=<?=$CHANCE_STATUS0?>&BARGAIN_DATE0=<?=$BARGAIN_DATE0?>&BARGAIN_DATE1=<?=$BARGAIN_DATE1?>&DESC0=<?=$DESC0?>&REMARK0=<?=$REMARK0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&ORDERFIELD=CHANCE_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=="CHANCE_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="CHANCE_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?CHANCE_NAME0=<?=$CHANCE_NAME0?>&CUSTOMER_NAME0=<?=$CUSTOMER_NAME0?>&SELLER_NAME0=<?=$SELLER_NAME0?>&CHANCE_RANK0=<?=$CHANCE_RANK0?>&BARGAIN_MONEY0=<?=$BARGAIN_MONEY0?>&BARGAIN_MONEY1=<?=$BARGAIN_MONEY1?>&CHANCE_STATUS0=<?=$CHANCE_STATUS0?>&BARGAIN_DATE0=<?=$BARGAIN_DATE0?>&BARGAIN_DATE1=<?=$BARGAIN_DATE1?>&DESC0=<?=$DESC0?>&REMARK0=<?=$REMARK0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&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"><a href="index.php?CHANCE_NAME0=<?=$CHANCE_NAME0?>&CUSTOMER_NAME0=<?=$CUSTOMER_NAME0?>&SELLER_NAME0=<?=$SELLER_NAME0?>&CHANCE_RANK0=<?=$CHANCE_RANK0?>&BARGAIN_MONEY0=<?=$BARGAIN_MONEY0?>&BARGAIN_MONEY1=<?=$BARGAIN_MONEY1?>&CHANCE_STATUS0=<?=$CHANCE_STATUS0?>&BARGAIN_DATE0=<?=$BARGAIN_DATE0?>&BARGAIN_DATE1=<?=$BARGAIN_DATE1?>&DESC0=<?=$DESC0?>&REMARK0=<?=$REMARK0?>&ADD_TIME0=<?=$ADD_TIME0?>&ADD_TIME1=<?=$ADD_TIME1?>&ORDERFIELD=SELLER&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=="SELLER"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SELLER"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center">预计成交日期</td>
      <td nowrap align="center">机会状态</td>
      <td nowrap align="center">登记时间</td>
      <td nowrap align="center">操作</td>
	  
  </tr>
<?
  $CHANCE_COUNT=0;
  while($ROW=mysql_fetch_array($cursor1))
  {
    $CHANCE_COUNT++;
    $CHANCE_ID=$ROW["CHANCE_ID"];
    $CHANCE_NAME=$ROW["CHANCE_NAME"];
    $CUSTOMER_NAME=$ROW["CUSTOMER_NAME"];
    $SELLER_NAME=$ROW["SELLER_NAME"];
    $BARGAIN_MONEY=$ROW["BARGAIN_MONEY"];
    $BARGAIN_DATE=$ROW["BARGAIN_DATE"];
    $CHANCE_STATUS=$ROW["CHANCE_STATUS"];
    $ADD_TIME=$ROW["ADD_TIME"];

    if($CHANCE_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>
    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$CHANCE_NAME?></td>
       <td nowrap align="center"><?=$CUSTOMER_NAME?></td>
       <td nowrap align="center"><?=$SELLER_NAME?></td>
      <td nowrap align="center"><?=$BARGAIN_DATE?></td>
      <td nowrap align="center"><?=$CHANCE_STATUS?></td>
      <td nowrap align="center"><?=$ADD_TIME?></td>
      <td nowrap align="center">
   <a href="javascript:show_detail(<?=$CHANCE_ID?>);"> 详细信息 </a>
      </td>
    </tr>

<?


}
  }
?>
</table>
</body>
</html>
12

⌨️ 快捷键说明

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