📄 add.php
字号:
<?
include_once 'inc/auth.php';
include_once 'inc/utility_sms1.php';
include_once 'inc/check_type.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">
';
$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 ());
$query = (((((((((''.'insert into SAL_FLOW(BEGIN_DATE,END_DATE,CONTENT,SEND_TIME) values (\'').$BEGIN_DATE).'\',\'').$END_DATE).'\',\'').$CONTENT).'\',\'').$SEND_TIME).'\')');
exequery ($connection, $query);
$ROW_ID = mysql_insert_id ();
if (($SMS_REMIND == 'on'))
{
$SMS_CONTENT = ('请进行工资上报!
备注:'.csubstr ($CONTENT1, 0, 100));
if ((compare_date ($BEGIN_DATE, $CUR_DATE) != 0))
{
$SEND_TIME = $BEGIN_DATE;
}
$query = 'select USER_ID from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and (FUNC_ID_STR like \'%,28,%\' or FUNC_ID_STR like \'28,%\' or FUNC_ID_STR like \'%,129,%\'or FUNC_ID_STR like \'129,%\')';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$USER_ID = $ROW['USER_ID'];
send_sms ($SEND_TIME, $LOGIN_USER_ID, $USER_ID, 4, $SMS_CONTENT, $REMIND_URL);
}
}
if (($SMS2_REMIND == 'on'))
{
$SMS_CONTENT = ('请进行工资上报!
备注:'.csubstr ($CONTENT1, 0, 100));
if ((compare_date ($BEGIN_DATE, $CUR_DATE) != 0))
{
$SEND_TIME = $BEGIN_DATE;
}
$query = 'select USER_ID from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and (FUNC_ID_STR like \'%,28,%\' or FUNC_ID_STR like \'28,%\' or FUNC_ID_STR like \'%,129,%\'or FUNC_ID_STR like \'129,%\')';
$cursor = exequery ($connection, $query);
while ($ROW = mysql_fetch_array ($cursor))
{
$USER_ID = $ROW['USER_ID'];
send_mobile_sms_user ('', $LOGIN_USER_ID, $USER_ID, $SMS_CONTENT, 4);
}
}
header ('location: index.php');
echo '
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -