submit.php

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

<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_sms1.php';
  $CUR_DATE = date ('Y-m-d', time ());
  $query = (((''.'select * from OA_SOURCE where SOURCEID=\'').$SOURCEID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $SOURCENAME = $ROW['SOURCENAME'];
    $DAY_LIMIT = $ROW['DAY_LIMIT'];
    $WEEKDAY_SET = $ROW['WEEKDAY_SET'];
    $TIME_TITLE = $ROW['TIME_TITLE'];
    $MANAGE_USER = $ROW['MANAGE_USER'];
  }
  $TIME_ARRAY = explode (',', $TIME_TITLE);
  $ARRAY_COUNT = sizeof ($TIME_ARRAY);
  if (($TIME_ARRAY[($ARRAY_COUNT - 1)] == ''))
  {
    --$ARRAY_COUNT;
  }
  for ($I = 0; ($I < $DAY_LIMIT); ++$I)
  {
    $APPLY_DATE = (time () + (($I * 24) * 3600));
    if (!find_id ($WEEKDAY_SET, date ('w', $APPLY_DATE)))
    {
      ++$DAY_LIMIT;
      continue;
    }
    else
    {
      $APPLY_DATE = date ('Y-m-d', $APPLY_DATE);
      $USER_ID = '';
      for ($J = 0; ($J < $ARRAY_COUNT); ++$J)
      {
        $STR = (($APPLY_DATE.'_').$J);
        $STR_VALUE = $$STR;
        if (($STR_VALUE < 0))
        {
          $STR_VALUE = '0';
        }
        else
        {
          if (($STR_VALUE == 1))
          {
            $STR_VALUE = $LOGIN_USER_ID;
          }
        }
        ($USER_ID .= ($STR_VALUE.','));
      }
      $query = (((((''.'select * from OA_SOURCE_USED where SOURCEID=\'').$SOURCEID).'\' and APPLY_DATE=\'').$APPLY_DATE).'\'');
      $cursor = exequery ($connection, $query);
      if ($ROW = mysql_fetch_array ($cursor))
      {
        $query = (((((((''.'update OA_SOURCE_USED set USER_ID=\'').$USER_ID).'\' where SOURCEID=\'').$SOURCEID).'\' and APPLY_DATE=\'').$APPLY_DATE).'\'');
        exequery ($connection, $query);
      }
      else
      {
        $query = (((((((''.'insert into OA_SOURCE_USED values(\'').$SOURCEID).'\',\'').$APPLY_DATE).'\',\'').$USER_ID).'\')');
        exequery ($connection, $query);
      }
      $SMS_CONTENT = ('资源申请：'.$SOURCENAME);
      $CUR_DATE_READ = 0;
      if (($APPLY_DATE == $CUR_DATE))
      {
        $query = (((((((''.'select * from SMS where FROM_ID=\'').$LOGIN_USER_ID).'\' and CONTENT=\'').$SMS_CONTENT).'\' and to_days(SEND_TIME)=to_days(\'').$APPLY_DATE).'\') and REMIND_FLAG=0');
        $cursor = exequery ($connection, $query);
        if ($ROW = mysql_fetch_array ($cursor))
        {
          $CUR_DATE_READ = 1;
        }
      }
      $query = (((((((''.'delete from SMS where FROM_ID=\'').$LOGIN_USER_ID).'\' and CONTENT=\'').$SMS_CONTENT).'\' and to_days(SEND_TIME)=to_days(\'').$APPLY_DATE).'\') and REMIND_FLAG=1');
      exequery ($connection, $query);
      if (find_id ($USER_ID, $LOGIN_USER_ID))
      {
        if (($APPLY_DATE == $CUR_DATE))
        {
          if (!$CUR_DATE_READ)
          {
            send_sms ('', $LOGIN_USER_ID, $MANAGE_USER, 0, $SMS_CONTENT, $REMIND_URL);
            continue;
          }
          continue;
        }
        send_sms ($APPLY_DATE, $LOGIN_USER_ID, $MANAGE_USER, 0, $SMS_CONTENT, $REMIND_URL);
        continue;
      }
      continue;
    }
  }
  header (((''.'location:apply.php?SOURCEID=').$SOURCEID));
?>