📄 mobile_result.php

📁 通达网络办公 - Office Anywhere 2008 增强版100％源码(3.4.081216) 内含通达OA2008增強版接近完美破解补丁20081216集及最新通达OA2008ADV(

💻 PHP

字号:

<?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'];
}
echo "\r\n<html>\r\n<head>\r\n<title>手机工资条 - ";
echo $CONTENT;
echo "</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n</head>\r\n<body class=\"bodycolor\" topmargin=\"5\" >\r\n";
$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;
}
$I = 0;
for ( ;	$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 ) )
	{
		$I = 0;
		for ( ;	do
	{
	$I < $COUNT;	++$I,	)
			{
				$STR = "S".$ITEM_ID[$I];
				$$STR = format_money( $ROW["{$STR}"] );
				break;
			}
		} while ( 1 );
	}
	else
	{
		$I = 0;
		for ( ;	$I < $COUNT;	++$I	)
		{
			$STR = "S".$ITEM_ID[$I];
			$$STR = "";
		}
	}
	$I = 0;
	for ( ;	$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>\r\n<br>\r\n<div align=\"center\">\r\n <input type=\"button\"  value=\"返回\" class=\"BigButton\" onClick=\"location='index.php';\">\r\n</div>\r\n</body>\r\n</html>";
?>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -