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

📄 list.php

📁 通达OA28 部分程序源码
💻 PHP
字号:
🔍 
<?
include_once("inc/auth.php");
$PAGE_SIZE=10;
?>

<html>
<head>
<title>联系人查询 </title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script Language="JavaScript">
function delete_linkman(LINKMAN_ID)
{
 msg='确认要删除该联系人么？';
 if(window.confirm(msg))
 {
  URL="delete.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&SEX=<?=$SEX?>&BIRTHDAY=<?=$BIRTHDAY?>&POST_PRIV=<?=$POST_PRIV?>&HOBBY=<?=$HOBBY?>&ADD_HOME=<?=$ADD_HOME?>&POSTALCODE_HOME=<?=$POSTALCODE_HOME?>&TEL_NO_WORK=<?=$TEL_NO_WORK?>&TEL_NO_HOME=<?=$TEL_NO_HOME?>&MOBILE=<?=$MOBILE?>&EMAIL=<?=$EMAIL?>&OICQ=<?=$OICQ?>&ICQ=<?=$ICQ?>&MEMO=<?=$MEMO?>&PAGE_START=<?=$PAGE_START?>&LINKMAN_ID=" + LINKMAN_ID;
  window.location=URL;
 }
}

function set_page()
{
 PAGE_START=(PAGE_NUM.value-1)*<?=$PAGE_SIZE?>+1;
 location="list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&SEX=<?=$SEX?>&BIRTHDAY=<?=$BIRTHDAY?>&POST_PRIV=<?=$POST_PRIV?>&HOBBY=<?=$HOBBY?>&ADD_HOME=<?=$ADD_HOME?>&POSTALCODE_HOME=<?=$POSTALCODE_HOME?>&TEL_NO_WORK=<?=$TEL_NO_WORK?>&TEL_NO_HOME=<?=$TEL_NO_HOME?>&MOBILE=<?=$MOBILE?>&EMAIL=<?=$EMAIL?>&OICQ=<?=$OICQ?>&ICQ=<?=$ICQ?>&MEMO=<?=$MEMO?>&PAGE_START="+PAGE_START;
}

function detail(LINKMAN_ID)
{
 URL="detail.php?LINKMAN_ID="+LINKMAN_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=400,width=500,status=1,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>

<body class="bodycolor" topmargin="5" >
<?
//-----------先组织SQL语句-----------


 if($CUSTOMER_ID!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where CUSTOMER_ID='".$CUSTOMER_ID."'";
     else
         $WHERE_STR.=" and CUSTOMER_ID='".$CUSTOMER_ID."'";

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

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

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

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

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

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

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

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

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

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

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

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

 if($WHERE_STR!="")
     $query="SELECT count(*) from LINKMAN ".$WHERE_STR;
 else
     $query="SELECT count(*) from LINKMAN";

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


 $PAGE_TOTAL=$LINKMAN_COUNT/$PAGE_SIZE;
 $PAGE_TOTAL=ceil($PAGE_TOTAL);

 //--- 计算,末页 ---
 if($LINKMAN_COUNT<=$PAGE_SIZE)
    $LAST_PAGE_START=1;
 else if($LINKMAN_COUNT%$PAGE_SIZE==0)
    $LAST_PAGE_START=$LINKMAN_COUNT-$PAGE_SIZE+1;
 else
    $LAST_PAGE_START=$LINKMAN_COUNT-$LINKMAN_COUNT%$PAGE_SIZE+1;

 //--- 智能分页 ---
 //-- 页首 --
 if($PAGE_START=="")
    $PAGE_START=1;

 if($PAGE_START>$LINKMAN_COUNT)
    $PAGE_START=$LAST_PAGE_START;

 if($PAGE_START<1)
    $PAGE_START=1;

 //-- 页尾 --
 $PAGE_END=$PAGE_START+$PAGE_SIZE-1;

 if($PAGE_END>$LINKMAN_COUNT)
    $PAGE_END=$LINKMAN_COUNT;

 //--- 计算当前页 ---
 $PAGE_NUM=($PAGE_START-1)/$PAGE_SIZE+1;

    $query1=str_replace("count(*)","*",$query);
  $cursor1 = exequery($connection, $query1);

  if($LINKMAN_COUNT==0)
  {
     Message("<br>提示","没有符合条件的联系人");
     exit;
  }

?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/notify_open.gif" align="absmiddle"><span class="big3"> 联系人查询结果 </span>
    </td>
    <td valign="bottom">
    <span class="small1">当前为第<b><?=$PAGE_START?></b>至<b><?=$PAGE_END?></b>条 (第<?=$PAGE_NUM?>页，共<?=$PAGE_TOTAL?>页，每页最多<?=$PAGE_SIZE?>条)</small>
    </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++;

    if($LINKMAN_COUNT<$PAGE_START)
       continue;
    else if($LINKMAN_COUNT>$PAGE_END)
       break;

    $LINKMAN_ID=$ROW["LINKMAN_ID"];
    $CUSTOMER_ID1=$ROW["CUSTOMER_ID"];
    $LINKMAN_NAME1=$ROW["LINKMAN_NAME"];
    $SEX1=$ROW["SEX"];
    $BIRTHDAY1=$ROW["BIRTHDAY"];
    $BIRTHDAY1=strtok($BIRTHDAY1," ");
    $POST_PRIV1=$ROW["POST_PRIV"];
    $HOBBY1=$ROW["HOBBY"];
    $ADD_HOME1=$ROW["ADD_HOME"];
    $POSTALCODE_HOME1=$ROW["POSTALCODE_HOME"];
    $TEL_NO_WORK1=$ROW["TEL_NO_WORK"];
    $TEL_NO_HOME1=$ROW["TEL_NO_HOME"];
    $MOBILE1=$ROW["MOBILE"];
    $EMAIL1=$ROW["EMAIL"];
    $OICQ1=$ROW["OICQ"];
    $ICQ1=$ROW["ICQ"];

    if($SEX1=="0")
        $SEX_DESC="男";
    else
        $SEX_DESC="女";

    if($MOBILE1!="")
       $MOBIL_NO_STR.=$MOBILE1.",";

   $query="SELECT CUSTOMER_NAME from CUSTOMER where CUSTOMER_ID=$CUSTOMER_ID1";
   $cursor= exequery($connection,$query);
   if($ROW=mysql_fetch_array($cursor))
   {
        $CUSTOMER_NAME=$ROW["CUSTOMER_NAME"];
      }
   if($LINKMAN_COUNT%2==1)
     $TableLine="TableLine1";
   else
     $TableLine="TableLine2";

?>

    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$LINKMAN_NAME1?></td>
      <td nowrap align="center"><?=$SEX_DESC?></td>
      <td nowrap align="center"><?=$BIRTHDAY1?></td>
      <td nowrap align="center" width="150"><?=$CUSTOMER_NAME?></td>
      <td nowrap align="center"><?=$TEL_NO_WORK1?></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" width="80">
        <a href="javascript:detail('<?=$LINKMAN_ID?>');">详情 </a>
      </td>
    </tr>
<?
  }
?>
  <tr class="TableControl">
  <td colspan="10" align="right">
     <input type="button"  value="首页" class="SmallButton"  <?if($PAGE_START==1)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&SEX=<?=$SEX?>&BIRTHDAY=<?=$BIRTHDAY?>&POST_PRIV=<?=$POST_PRIV?>&HOBBY=<?=$HOBBY?>&ADD_HOME=<?=$ADD_HOME?>&POSTALCODE_HOME=<?=$POSTALCODE_HOME?>&TEL_NO_WORK=<?=$TEL_NO_WORK?>&TEL_NO_HOME=<?=$TEL_NO_HOME?>&MOBILE=<?=$MOBILE?>&EMAIL=<?=$EMAIL?>&OICQ=<?=$OICQ?>&ICQ=<?=$ICQ?>&MEMO=<?=$MEMO?>'"> &nbsp;&nbsp;
     <input type="button"  value="上一页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&SEX=<?=$SEX?>&BIRTHDAY=<?=$BIRTHDAY?>&POST_PRIV=<?=$POST_PRIV?>&HOBBY=<?=$HOBBY?>&ADD_HOME=<?=$ADD_HOME?>&POSTALCODE_HOME=<?=$POSTALCODE_HOME?>&TEL_NO_WORK=<?=$TEL_NO_WORK?>&TEL_NO_HOME=<?=$TEL_NO_HOME?>&MOBILE=<?=$MOBILE?>&EMAIL=<?=$EMAIL?>&OICQ=<?=$OICQ?>&ICQ=<?=$ICQ?>&MEMO=<?=$MEMO?>&PAGE_START=<?=($PAGE_START-$PAGE_SIZE)?>'"> &nbsp;&nbsp;
     <input type="button"  value="下一页" class="SmallButton" <?if($PAGE_END>=$LINKMAN_COUNT)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&SEX=<?=$SEX?>&BIRTHDAY=<?=$BIRTHDAY?>&POST_PRIV=<?=$POST_PRIV?>&HOBBY=<?=$HOBBY?>&ADD_HOME=<?=$ADD_HOME?>&POSTALCODE_HOME=<?=$POSTALCODE_HOME?>&TEL_NO_WORK=<?=$TEL_NO_WORK?>&TEL_NO_HOME=<?=$TEL_NO_HOME?>&MOBILE=<?=$MOBILE?>&EMAIL=<?=$EMAIL?>&OICQ=<?=$OICQ?>&ICQ=<?=$ICQ?>&MEMO=<?=$MEMO?>&PAGE_START=<?=($PAGE_END+1)?>'"> &nbsp;&nbsp;
     <input type="button"  value="末页" class="SmallButton"  <?if($PAGE_END>=$LINKMAN_COUNT)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&SEX=<?=$SEX?>&BIRTHDAY=<?=$BIRTHDAY?>&POST_PRIV=<?=$POST_PRIV?>&HOBBY=<?=$HOBBY?>&ADD_HOME=<?=$ADD_HOME?>&POSTALCODE_HOME=<?=$POSTALCODE_HOME?>&TEL_NO_WORK=<?=$TEL_NO_WORK?>&TEL_NO_HOME=<?=$TEL_NO_HOME?>&MOBILE=<?=$MOBILE?>&EMAIL=<?=$EMAIL?>&OICQ=<?=$OICQ?>&ICQ=<?=$ICQ?>&MEMO=<?=$MEMO?>&PAGE_START=<?=$LAST_PAGE_START?>'"> &nbsp;&nbsp;
     页数
     <input type="text" name="PAGE_NUM" value="<?=$PAGE_NUM?>" class="SmallInput" size="2"> <input type="button"  value="转到" class="SmallButton" onclick="set_page();" title="转到指定的页面">&nbsp;&nbsp;
  </td>
  </tr>
  <thead class="TableHeader">
      <td nowrap align="center">姓名</td>
      <td nowrap align="center">性别</td>
      <td nowrap align="center">生日</td>
      <td nowrap align="center">客户单位</td>
      <td nowrap align="center">工作电话</td>
      <td nowrap align="center">手机  <a href="/general/mobile_sms?TO_ID1=<?=$MOBIL_NO_STR?>">群发</a></td>
      <td nowrap align="center">电子邮件</td>
      <td nowrap align="center">操作</td>
  </thead>
</table>

<br>
<div align="center">
  <input type="button" value="关闭" class="BigButton" onClick="javascript:window.close();">
</div>

</body>
</html>

⌨️ 快捷键说明

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