📄 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");
?>
<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());
$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 '%,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);
}
}
if($SMS2_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 '%,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");
?>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -