mobile_result.php
来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 123 行
PHP
123 行
<?
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'];
}
echo '
<html>
<head>
<title>手机工资条 - ';
echo $CONTENT;
echo '</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;
echo '<div align=center class=big1><b>已发送工资条:</b><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');
}
echo '</div>
<br>
<div align="center">
<input type="button" value="返回" class="BigButton" onClick="location=\'index.php\';">
</div>
</body>
</html>';
?>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?