📄 add.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/check_type.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\r\n";
$CUR_DATE = date( "Y-m-d", time( ) );
if ( $BEGIN_DATE != "" )
{
$TIME_OK = is_date( $BEGIN_DATE );
if ( !$TIME_OK )
{
message( "错误", "上报起始日期格式不对，应形如 1999-1-2" );
button_back( );
exit( );
}
}
if ( $END_DATE != "" )
{
$TIME_OK = is_date( $END_DATE );
if ( !$TIME_OK )
{
message( "错误", "上报截止日期格式不对，应形如 1999-1-2" );
button_back( );
exit( );
}
}
if ( compare_date( $BEGIN_DATE, $CUR_DATE ) < 0 )
{
message( "错误", "上报起始日期不能早于今日" );
button_back( );
exit( );
}
if ( compare_date( $BEGIN_DATE, $END_DATE ) == 1 )
{
message( "错误", "上报起始日期不能晚于上报截止日期" );
button_back( );
exit( );
}
$CONTENT1 = $CONTENT;
$SEND_TIME = date( "Y-m-d H:i:s", time( ) );
$connection = openconnection( );
$query = "insert into SAL_FLOW(BEGIN_DATE,END_DATE,CONTENT,SEND_TIME) values ('{$BEGIN_DATE}','{$END_DATE}','{$CONTENT}','{$SEND_TIME}')";
exequery( $connection, $query );
if ( $SMS_REMIND == "on" )
{
$SMS_CONTENT = "请进行工资上报！\n备注：".csubstr( $CONTENT1, 0, 100 );
if ( compare_date( $BEGIN_DATE, $CUR_DATE ) != 0 )
{
$SEND_TIME = $BEGIN_DATE;
}
$query = "select * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and FUNC_ID_STR like '%,19,%'";
$cursor = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor ) )
{
$USER_ID = $ROW['USER_ID'];
$query1 = "insert into SMS(FROM_ID,TO_ID,SMS_TYPE,CONTENT,SEND_TIME,REMIND_FLAG) values ('{$LOGIN_USER_ID}','{$USER_ID}','4','{$SMS_CONTENT}','{$SEND_TIME}','1')";
exequery( $connection, $query1 );
}
}
header( "location: index.php" );
echo "\r\n</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -