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

📄 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_contact(CONTACT_ID)
{
 msg='确认要删除该交往记录么？';
 if(window.confirm(msg))
 {
  URL="delete.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&CONTACT_DATE=<?=$CONTACT_DATE?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&MEMO=<?=$MEMO?>&PAGE_START=<?=$PAGE_START?>&CONTACT_ID=" + CONTACT_ID;
  window.location=URL;
 }
}

function set_page()
{
 PAGE_START=(PAGE_NUM.value-1)*<?=$PAGE_SIZE?>+1;
 location="list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&CONTACT_DATE=<?=$CONTACT_DATE?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&MEMO=<?=$MEMO?>&PAGE_START="+PAGE_START;
}

function detail(CONTACT_ID)
{
 URL="detail.php?CONTACT_ID="+CONTACT_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=190,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($CONTACT_CONTENT!="")
     if($WHERE_STR=="")
         $WHERE_STR.=" where CONTACT_CONTENT like '%".$CONTACT_CONTENT."%'";
     else
         $WHERE_STR.=" and CONTACT_CONTENT like '%".$CONTACT_CONTENT."%'";

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

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

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

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

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


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

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

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

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

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

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

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

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

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

  if($CONTACT_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">
  <tr 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">操作</td>
  </tr>

<?
  $CONTACT_COUNT = 0;
  while($ROW=mysql_fetch_array($cursor1))
  {
    $CONTACT_COUNT++;

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

    $CONTACT_ID=$ROW["CONTACT_ID"];
    $CUSTOMER_ID1=$ROW["CUSTOMER_ID"];
    $CONTACT_DATE1=$ROW["CONTACT_DATE"];
    $CONTACT_DATE1=strtok($CONTACT_DATE1," ");
    $CONTACT_CONTENT1=$ROW["CONTACT_CONTENT"];
    $LINKMAN_NAME1=$ROW["LINKMAN_NAME"];
    $MEMO1=$ROW["MEMO"];

        $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($CONTACT_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";

?>

    <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$CUSTOMER_NAME?></td>
      <td nowrap align="center"><?=$CONTACT_DATE1?></td>
      <td align="center"><?=$CONTACT_CONTENT1?></td>
      <td nowrap align="center"><?=$LINKMAN_NAME1?></td>
      <td align="center"><?=$MEMO1?></td>
      <td nowrap align="center" width="80">
        <a href="javascript:detail('<?=$CONTACT_ID?>');">详情 </a>
      </td>
    </tr>

<?
    $CUSTOMER_ID1="";
    $CONTACT_DATE1="";
    $CONTACT_CONTENT1="";
    $LINKMAN_NAME1="";
    $MEMO1="";
    $CUSTOMER_NAME="";
  }
?>
  <tr class="TableControl">
  <td colspan="9" align="right">
     <input type="button"  value="首页" class="SmallButton"  <?if($PAGE_START==1)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&CONTACT_DATE=<?=$CONTACT_DATE?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&MEMO=<?=$MEMO?>'"> &nbsp;&nbsp;
     <input type="button"  value="上一页" class="SmallButton" <?if($PAGE_START==1)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&CONTACT_DATE=<?=$CONTACT_DATE?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&MEMO=<?=$MEMO?>&PAGE_START=<?=($PAGE_START-$PAGE_SIZE)?>'"> &nbsp;&nbsp;
     <input type="button"  value="下一页" class="SmallButton" <?if($PAGE_END>=$CONTACT_COUNT)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&CONTACT_DATE=<?=$CONTACT_DATE?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&MEMO=<?=$MEMO?>&PAGE_START=<?=($PAGE_END+1)?>'"> &nbsp;&nbsp;
     <input type="button"  value="末页" class="SmallButton"  <?if($PAGE_END>=$CONTACT_COUNT)echo "disabled";?> onclick="location='list.php?CUSTOMER_ID=<?=$CUSTOMER_ID?>&CONTACT_CONTENT=<?=$CONTACT_CONTENT?>&CONTACT_DATE=<?=$CONTACT_DATE?>&LINKMAN_NAME=<?=$LINKMAN_NAME?>&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>
</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 + -