📄 checkup.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_sms1.php" );
include_once( "inc/utility_all.php" );
echo "\r\n<html>\r\n<head>\r\n<title></title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$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 USER_NAME 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 USER_NAME 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 USER_NAME 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 PARA_VALUE 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',DEPT_REASON='{$DEPT_REASON}'";
$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 );
if ( $DMER_STATUS == 3 )
{
message( "提示", "操作成功" );
echo "<br>\r\n<script>\r\n opener.location.reload();\r\n</script>\r\n<center>\r\n\t<input type=\"button\" class=\"BigButton\" value=\"关闭\" onClick=\"window.close();\" title=\"关闭窗口\">\r\n</center>\r\n";
}
else
{
header( "location: query.php?DMER_STATUS=".$DMER_STATUS1 );
}
echo "</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -