sms_mon.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 62 行

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  ob_clean ();
  $CUR_TIME = date ('Y-m-d H:i:s', time ());
  if (($SMS_ID_NOT_REF == ''))
  {
    $SMS_ID_NOT_REF = 0;
  }
  else
  {
    $SMS_ID_NOT_REF = substr ($SMS_ID_NOT_REF, 0, -1);
  }
  $query = (((((((''.'SELECT SMS_ID from SMS where TO_ID=\'').$LOGIN_USER_ID).'\' and REMIND_FLAG=\'1\' and SEND_TIME<=\'').$CUR_TIME).'\' and SMS_ID not in (').$SMS_ID_NOT_REF).') order by SEND_TIME');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $SMS_ID = $ROW['SMS_ID'];
    $SMS = 1;
    $SMS_REF_NUM = intval ($_COOKIE[(('SMS_'.$SMS_ID).'_REF_NUM')]);
    setcookie ((('SMS_'.$SMS_ID).'_REF_NUM'), ++$SMS_REF_NUM, (time () + 86400000));
    if (($SMS_REF_MAX <= $SMS_REF_NUM))
    {
      setcookie ('SMS_ID_NOT_REF', (($_COOKIE['SMS_ID_NOT_REF'].$SMS_ID).','), (time () + 86400000));
    }
  }
  if (($SMS == '1'))
  {
    if (($I_VER == '2'))
    {
      $query = (((((''.'SELECT FROM_ID,SEND_TIME,CONTENT,USER_NAME,DEPT_ID from SMS,USER where USER.USER_ID=SMS.FROM_ID and 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'];
        $FROM_NAME = $ROW['USER_NAME'];
        $DEPT_ID = $ROW['DEPT_ID'];
        $DEPT_NAME = dept_long_name ($DEPT_ID);
        $CONTENT = htmlspecialchars ($CONTENT);
        $CONTENT = str_replace ('
', '<br>', $CONTENT);
        $CONTENT = stripslashes ($CONTENT);
        $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.'
').$CONTENT);
    }
    else
    {
      echo 'S';
    }
  }
?>