sms_mon.php

来自「极限网络智能办公系统 Office Automation V3.0官方100％源」· PHP 代码 · 共 50 行

<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
ob_clean();

$CUR_TIME=date("Y-m-d H:i:s",time());
$query = "SELECT * from SMS where TO_ID='$LOGIN_USER_ID' and REMIND_FLAG='1' and SEND_TIME<='$CUR_TIME'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
   $SMS=1;

if($SMS=='1')
{
	 if($I_VER=="2")
	 {
     $query = "SELECT * from SMS where TO_ID='$LOGIN_USER_ID' and REMIND_FLAG='1' and SEND_TIME<='$CUR_TIME' order by SEND_TIME";
     $cursor= exequery($connection,$query);
     if($ROW=mysql_fetch_array($cursor))
     {
        $FROM_ID=$ROW["FROM_ID"];
        $SEND_TIME=$ROW["SEND_TIME"];
        $CONTENT=$ROW["CONTENT"];
        $CONTENT=str_replace("<","&lt",$CONTENT);
        $CONTENT=str_replace(">","&gt",$CONTENT);
        $CONTENT=str_replace("\r\n","<br>",$CONTENT);
        $CONTENT=stripslashes($CONTENT);

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

        $CONTENT="<td nowrap>$SEND_TIME</td><td nowrap>$DEPT_NAME</td><td nowrap>$FROM_NAME</td><td>$CONTENT</td>";
     }

     $query = "SELECT count(*) from SMS where TO_ID='$LOGIN_USER_ID' and REMIND_FLAG='1' and SEND_TIME<='$CUR_TIME'";
     $cursor= exequery($connection,$query);
     if($ROW=mysql_fetch_array($cursor))
        $COUNT=$ROW[0];
     echo $COUNT."\n".$CONTENT;
   }
   else
     echo "S";
}
?>