📄 search.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>

<html>
<head>
<title>短信查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script>
function delete_all()
{
 msg='确认要删除所有查询出来的短信么？';
 if(window.confirm(msg))
 {
  URL="delete.php";
  window.location=URL;
 }
}
function check_all()
{
 for (i=0;i<document.all("email_select").length;i++) {
   if(document.all("allbox").checked)
      document.all("email_select").item(i).checked=true;
   else
      document.all("email_select").item(i).checked=false;
 }

 if(i==0)
 {
   if(document.all("allbox").checked)
      document.all("email_select").checked=true;
   else
      document.all("email_select").checked=false;
 }
}

function check_one(el)
{
   if(!el.checked)
      document.all("allbox").checked=false;
}

function delete_mail()
{
  delete_str="";
  for(i=0;i<document.all("email_select").length;i++)
  {

      el=document.all("email_select").item(i);
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }

  if(i==0)
  {
      el=document.all("email_select");
      if(el.checked)
      {  val=el.value;
         delete_str+=val + ",";
      }
  }

  if(delete_str=="")
  {
     alert("要删除短消息，请至少选择其中一条。");
     return;
  }

  msg='确认要删除所选短消息么？';
  if(window.confirm(msg))
  {
    url="../delete.php?DELETE_STR="+ delete_str +"&CUR_PAGE=<?=$CUR_PAGE?>";
    location=url;
  }
}
</script>
</head>

<body class="bodycolor" topmargin="5">

<?

  //----------- 合法性校验 ---------
  if($BEGIN_DATE!="")
  {
    $TIME_OK=is_date_time($BEGIN_DATE);

    if(!$TIME_OK)
    { Message("错误","起始日期格式不对，应形如 1999-1-2 14:55:20");
      Button_Back();
      exit;
    }
  }

  if($END_DATE!="")
  {
    $TIME_OK=is_date_time($END_DATE);

    if(!$TIME_OK)
    { Message("错误","截止日期格式不对，应形如 1999-1-2 14:55:20");
      Button_Back();
      exit;
    }
  }

if($END_DATE!=""&&$BEGIN_DATE!=""&&$BEGIN_DATE> $END_DATE)
{
   Message("错误","截止时间不能晚于起始时间!");
   Button_Back();
   exit;
}

if($TO_ID!="")
   $TO_ID="'".str_replace(",","','",substr($TO_ID,0,-1))."'";

if($TO_ID!="")
   $query1.=" and $TYPE in ($TO_ID)";
if($BEGIN_DATE!="")
   $query1.=" and SEND_TIME>='$BEGIN_DATE'";
if($END_DATE!="")
   $query1.=" and SEND_TIME<='$END_DATE'";

if($TYPE=="TO_ID")
{
   $TYPE_OTHER="FROM_ID";
   $TITLE="收信人";
}
else
{
   $TYPE_OTHER="TO_ID";
   $TITLE="发送人";
}

if($ORDER_BY=="FROM_TO")
   $ORDER_BY=$TYPE;

$query="select count(*) from SMS where $TYPE_OTHER='$LOGIN_USER_ID'".$query1." order by $ORDER_BY $SEQ";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
   $SMS_COUNT=$ROW[0];

$query="select * from SMS where $TYPE_OTHER='$LOGIN_USER_ID'".$query1." order by $ORDER_BY $SEQ";
session_start();
$QUERY_SMS=$query;
session_register("QUERY_SMS");
?>

<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/system.gif" WIDTH="22" HEIGHT="20" align="absmiddle"><span class="big3"> 查询结果 （最多显示200记录）</span>
    </td>
  </tr>
</table>

<?
if($SMS_COUNT==0)
{
   Message("","无符合条件的查询结果");
   Button_Back();
   exit;
}
?>
<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"><?=$TITLE?></td>
      <td nowrap align="center">内容</td>
      <td nowrap align="center">发送时间 <img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td nowrap align="center">提醒</td>
      <td nowrap align="center">操作</td>
    </tr>
<?
 //============================ 显示短信息 =======================================
 $cursor= exequery($connection,$query);
 $SMS_COUNT=0;
 while($ROW=mysql_fetch_array($cursor))
 {
    $SMS_COUNT++;
    if($SMS_COUNT>200)
       break;
    $SMS_ID=$ROW["SMS_ID"];
    $FROM_ID=$ROW["FROM_ID"];
    $TO_ID=$ROW["TO_ID"];
    $SEND_TIME=$ROW["SEND_TIME"];

    $SMS_TYPE=$ROW["SMS_TYPE"];
    $CONTENT=$ROW["CONTENT"];

    $CONTENT=htmlspecialchars($CONTENT);


    $REMIND_FLAG=$ROW["REMIND_FLAG"];

    if($REMIND_FLAG=="0")
       $REMIND_FLAG_DESC="否";
    else
       $REMIND_FLAG_DESC="是";

    $query1 = "SELECT * from USER where USER_ID='$FROM_ID'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $FROM_NAME=$ROW["USER_NAME"];
       $FROM_AVATAR=$ROW["AVATAR"];
    }

    $query1 = "SELECT * from USER where USER_ID='$TO_ID'";
    $cursor1= exequery($connection,$query1);
    if($ROW=mysql_fetch_array($cursor1))
    {
       $TO_NAME=$ROW["USER_NAME"];
       $TO_AVATAR=$ROW["AVATAR"];
    }
    
    $SMS_TYPE_NAME=get_code_name($SMS_TYPE,"SMS_REMIND");

    if($SMS_COUNT%2==1)
       $TableLine="TableLine1";
    else
       $TableLine="TableLine2";
    
    if($TYPE=="TO_ID")
       $AVATAR=$TO_AVATAR;
    else
       $AVATAR=$FROM_AVATAR;

?>
    <tr class="<?=$TableLine?>">
      <td>&nbsp;<input type="checkbox" name="email_select" value="<?=$SMS_ID?>" onClick="check_one(self);"></td>
      <td align="center">
<?
      if($SMS_TYPE=="0")
      {
?>
       <img src="/images/avatar/<?=$AVATAR?>.gif" <?=avatar_size($AVATAR)?> alt="<?=$SMS_TYPE_NAME?>">
<?
      }
      else
      {
?>
       <img src="/images/sms_type<?=$SMS_TYPE?>.gif" width=20 height=20 alt="<?=$SMS_TYPE_NAME?>">
<?
      }
?>
      </td>
      <td nowrap align="center"><?if($TYPE=="TO_ID") echo $TO_NAME;else echo $FROM_NAME;?></td>
      <td><?=$CONTENT?></td>
      <td align="center"><?=$SEND_TIME?></td>
      <td nowrap align="center"><?=$REMIND_FLAG_DESC?></td>
      <td nowrap align="center">
<?
      if($REMIND_FLAG==0)
      {
?>
      <a href="../send/resend.php?SMS_ID=<?=$SMS_ID?>"> 重发</a>
<?
      }
?>
      </td>
    </tr>
<?
 }
?>

<tr class="TableControl">
<td colspan="5">&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 colspan="2" align="right">
    <input type="button"  value="全部删除" class="SmallButton" onClick="delete_all();" title="删除所有已发送的短信息">&nbsp;
</td>
</tr>
</table>

<div align="center">
  <input type="button"  value="返回" class="BigButton" onClick="location='index.php'">
</div>
</body>
</html>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

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

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