📄 mobile_result.php
字号:
<?
include_once("inc/auth.php");
include_once("inc/utility_all.php");
include_once("inc/utility_sms2.php");
if($fld_str=="")
{
$query = "SELECT ITEM_ID from SAL_ITEM";
$cursor= exequery($connection,$query);
$FLOW_COUNT=0;
while($ROW=mysql_fetch_array($cursor))
{
$STYLE=$STYLE.$ROW["ITEM_ID"].",";
}
}
else
{
$STYLE=$fld_str;
}
$query = "SELECT CONTENT from SAL_FLOW where FLOW_ID='$FLOW_ID'";
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))$CONTENT=$ROW["CONTENT"];
?>
<html>
<head>
<title>手机工资条 - <?=$CONTENT?></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5" >
<?
$query = "SELECT count(*) from SAL_ITEM";
$ITEM_COUNT=0;
$cursor= exequery($connection,$query);
if($ROW=mysql_fetch_array($cursor))
$ITEM_COUNT=$ROW[0];
if($ITEM_COUNT==0)
{
Message("提示","尚未定义工资项目");
Button_back();
exit;
}
$STYLE_ARRAY=explode(",",$STYLE);
$ARRAY_COUNT=sizeof($STYLE_ARRAY);
$COUNT=0;
if($STYLE_ARRAY[$ARRAY_COUNT-1]=="")$ARRAY_COUNT--;
for($I=0;$I<$ARRAY_COUNT;$I++)
{
$query1 = "select ITEM_ID,ITEM_NAME from SAL_ITEM where ITEM_ID='$STYLE_ARRAY[$I]'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
{
$ITEM_NAME[$COUNT]=$ROW["ITEM_NAME"];
$ITEM_ID[$COUNT]=$ROW["ITEM_ID"];
}
$COUNT++;
}
if($COPY_TO_ID!="")
{
$COPY_TO_ID="'".str_replace(",","','",substr($COPY_TO_ID,0,-1))."'";
$WHERE_STR.=" and USER.USER_ID in ($COPY_TO_ID)";
}
$query = "SELECT * from USER,USER_PRIV,DEPARTMENT where DEPARTMENT.DEPT_ID=USER.DEPT_ID and USER.USER_PRIV=USER_PRIV.USER_PRIV".$WHERE_STR." order by DEPT_NO,PRIV_NO,USER_NAME";
$cursor= exequery($connection,$query);
$USER_COUNT=0;
$MOBILE_MESSAGE;
echo "已发送工资条："."<br>";
while($ROW=mysql_fetch_array($cursor))
{
$USER_COUNT++;
$MOBILE_MESSAGE="";
$MOBILE_MESSAGE=$MOBILE_MESSAGE.$CONTENT.":";
$USER_ID=$ROW["USER_ID"];
$USER_NAME=$ROW["USER_NAME"];
$MOBILE_MESSAGE=$MOBILE_MESSAGE.$USER_NAME."：";
$query1="select * from SAL_DATA where FLOW_ID=$FLOW_ID and USER_ID='$USER_ID'";
$cursor1= exequery($connection,$query1);
if($ROW=mysql_fetch_array($cursor1))
{
for($I=0;$I< $COUNT;$I++)
{
$STR="S".$ITEM_ID[$I];
$$STR=format_money($ROW["$STR"]);
}
}
else
{
for($I=0;$I< $COUNT;$I++)
{
$STR="S".$ITEM_ID[$I];
$$STR="";
}
}
for($I=0;$I< $COUNT;$I++)
{
$STR="S".$ITEM_ID[$I];
$STR_COUNT=$STR."_COUNT";
$$STR_COUNT+=$$STR;
if($$STR=="")$$STR=0;
$MOBILE_MESSAGE=$MOBILE_MESSAGE.$ITEM_NAME[$I].":".$$STR." ";
}
echo $MOBILE_MESSAGE."<br>";
send_mobile_sms_user("",$LOGIN_USER_ID,$USER_ID,$MOBILE_MESSAGE,"19");
}
?>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location='index.php';">
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -