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 + -
显示快捷键?