checkup.php

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

PHP
78
字号
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_sms1.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
</body>
</html>
';
  $query = (((''.'select * from VEHICLE_USAGE where VU_ID=\'').$VU_ID).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $VU_OPERATOR = $ROW['VU_OPERATOR'];
    $DEPT_MANAGER = $ROW['DEPT_MANAGER'];
    $VU_PROPOSER = $ROW['VU_PROPOSER'];
    $DMER_STATUS1 = $ROW['DMER_STATUS'];
  }
  $query = (((''.'SELECT * from USER where USER_ID=\'').$VU_OPERATOR).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $VU_OPERATOR_NAME = $ROW['USER_NAME'];
  }
  $query = (((''.'SELECT * from USER where USER_ID=\'').$DEPT_MANAGER).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $DEPT_MANAGER_NAME = $ROW['USER_NAME'];
  }
  $query = (((''.'SELECT * from USER where USER_ID=\'').$VU_PROPOSER).'\'');
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $VU_PROPOSER_NAME = $ROW['USER_NAME'];
  }
  $query = 'select * from SYS_PARA where PARA_NAME=\'SMS_REMIND\'';
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $PARA_VALUE = $ROW['PARA_VALUE'];
  }
  $SMS_REMIND = substr ($PARA_VALUE, 0, strpos ($PARA_VALUE, '|'));
  $SMS2_REMIND = substr ($PARA_VALUE, (strpos ($PARA_VALUE, '|') + 1));
  if (($DMER_STATUS == 0))
  {
    $VALUE_STR = (((''.'DMER_STATUS=\'').$DMER_STATUS).'\',SHOW_FLAG=\'0\'');
  }
  if (($DMER_STATUS == 1))
  {
    $VALUE_STR = (((''.'DMER_STATUS=\'').$DMER_STATUS).'\',SHOW_FLAG=\'1\'');
    $SMS_CONTENT = (('部门领导'.$DEPT_MANAGER_NAME).'批准了车辆申请!');
    $REMIND_URL1 = 'vehicle/checkup';
    if (find_id ($SMS_REMIND, 9))
    {
      send_sms ('', $VU_PROPOSER, $VU_OPERATOR, 9, $SMS_CONTENT, $REMIND_URL1);
    }
  }
  if (($DMER_STATUS == 3))
  {
    $VALUE_STR = (((''.'DMER_STATUS=\'').$DMER_STATUS).'\'');
    $SMS_CONTENT = (('部门领导'.$DEPT_MANAGER_NAME).'未批准车辆申请!');
    $REMIND_URL = 'general/vehicle';
    if (find_id ($SMS_REMIND, 9))
    {
      send_sms ('', $DEPT_MANAGER, $VU_PROPOSER, 9, $SMS_CONTENT, $REMIND_URL);
    }
  }
  $query = (('update VEHICLE_USAGE set '.$VALUE_STR).(((''.' where VU_ID=\'').$VU_ID).'\''));
  exequery ($connection, $query);
  header (((''.'location: query.php?DMER_STATUS=').$DMER_STATUS1));
?>

⌨️ 快捷键说明

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