📄 index.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
📖 第 1 页 / 共 2 页
字号:
上一页 12
     else
         $WHERE_STR.=" and b.PROVIDER_SHORT like '%".$PROVIDER_SHORT."%'";
  }

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

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

 if($SEX!="")
  {
  	   if($WHERE_STR=="")
         $WHERE_STR.=" where a.SEX='".$SEX."'";
     else
  	      $WHERE_STR.=" and a.SEX='".$SEX."'";
  	}
 
  if($MAIN_LINKMAN!="")
  {
  	   if($WHERE_STR=="")
         $WHERE_STR.=" where a.MAIN_LINKMAN='".$MAIN_LINKMAN."'";
     else
  	      $WHERE_STR.=" and a.MAIN_LINKMAN='".$MAIN_LINKMAN."'";
  	} 	

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

 $query="SELECT count(*) FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID` ";

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

$query="SELECT a.MOBILE  FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID` ".$WHERE_STR.$OREDERBY;
$cursor= exequery($connection,$query);
while($ROW=mysql_fetch_array($cursor))
{
	 $MOBILE1=$ROW["MOBILE"];
	 if($MOBILE1!="")
   $MOBIL_NO_STR.=$MOBILE1.",";
}
 $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 MAIN_LINKMAN,a.LINKMAN_ID,b.PROVIDER_ID,LINKMAN_NAME,SEX,a.TEL_NO_WORK,a.MOBILE,a.EMAIL as EMAIL,a.OICQ,a.ICQ,b.PROVIDER_NAME  FROM `PROVIDER_LINKMAN` a LEFT OUTER JOIN PROVIDER b ON a.`PROVIDER_ID` = b.`PROVIDER_ID`  ".$WHERE_STR.$OREDERBY;
$offest=($CUR_PAGE-1)*10;
$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&PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&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?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&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?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&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?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&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++;
    $LINKMAN_ID1=$ROW["LINKMAN_ID"];
    $PROVIDER_ID1=$ROW["PROVIDER_ID"];
    $LINKMAN_NAME1=$ROW["LINKMAN_NAME"];
    $MAIN_LINKMAN1=$ROW["MAIN_LINKMAN"];
    $SEX1=$ROW["SEX"];
    $TEL_NO_WORK1=$ROW["TEL_NO_WORK"];
    $EMAIL1=$ROW["EMAIL"];
    $OICQ1=$ROW["OICQ"];
    $ICQ1=$ROW["ICQ"];
     $MOBILE1=$ROW["MOBILE"];
    $PROVIDER_NAME1=$ROW["PROVIDER_NAME"];
    if($SEX1=="0")
        $SEX_DESC="男";
    else
        $SEX_DESC="女";
   if($LINKMAN_COUNT%2==1)
     $TableLine="TableLine1";
   else
     $TableLine="TableLine2";

?>

    <tr class="<?=$TableLine?>">
    	<td>&nbsp;<input type="checkbox" name="email_select" value="<?=$LINKMAN_ID1?>" onClick="check_one(self);"></td>
    	 <td nowrap align="center"><?=$PROVIDER_NAME1?></td>
      <td nowrap align="center"><?=$LINKMAN_NAME1?></td>
       <td nowrap align="center"> <input type="checkbox" name="MAIN_LINKMAN" value="1" <? if($MAIN_LINKMAN1=="1") echo "checked"?>  disabled></td>
      <td nowrap align="center"><?=$SEX_DESC?></td>
      <td nowrap align="center"><a href="/general/mobile_sms?TO_ID1=<?=$MOBILE1?>"><?=$MOBILE1?></a></td>
      <td nowrap align="center"><?=$EMAIL1?></td>
      <td nowrap align="center" >
        <a href="javascript:show_detail(<?=$LINKMAN_ID1?>);"> 详细信息 </a>    	
        <a href="edit.php?LINKMAN_ID=<?=$LINKMAN_ID1?>&PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&CUR_PAGE=<?=$CUR_PAGE?>&ORDERFIELD=<?=$ORDERFIELD?>&ORDERTYPE=<?=$ORDERTYPE?>"> 编辑</a>&nbsp;&nbsp;
        <a href="javascript:delete_linkman(<?=$LINKMAN_ID1?>);"> 删除 </a>
      </td>
    </tr>
<?
  }
}
?>
 <tr class="TableControl">
 <td colspan="9">
 	   &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>
  <thead class="TableHeader">
      <td nowrap align="center">选择</td>
      <td nowrap align="center"><a href="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&&ORDERFIELD=b.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=="b.PROVIDER_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="b.PROVIDER_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&&ORDERFIELD=LINKMAN_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=="LINKMAN_NAME"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="LINKMAN_NAME"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&&ORDERFIELD=MAIN_LINKMAN&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=="MAIN_LINKMAN"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="MAIN_LINKMAN"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center"><a href="index.php?PROVIDER_NAME=<?=$PROVIDER_NAME?>&MAIN_LINKMAN=<?=$MAIN_LINKMAN?>&PROVIDER_CODE=<?=$PROVIDER_CODE?>&PROVIDER_SHORT=<?=$PROVIDER_SHORT?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&ADD_HOME=<?=$ADD_HOME?>&SEX=<?=$SEX?>&&ORDERFIELD=SEX&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=="SEX"){?><img src="/images/arrow_down.gif" align="absmiddle" border=0><?}if($ORDERTYPE=="ASC" and $ORDERFIELD=="SEX"){?><img src="/images/arrow_up.gif" align="absmiddle" border=0><?}?></a></td>
      <td nowrap align="center">手机 <a href="javascript:mobile_sms('<?=$MOBIL_NO_STR?>');">群发</a></td>
      <td nowrap align="center">电子邮件</td>
      <td nowrap align="center">操作</td>
  </thead>
</table>
</body>
</html>
上一页 12
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

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

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