report.php

来自「通达OA2007SE源代码 非常好的」· PHP 代码 · 共 201 行

PHP
201 行
字号 
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.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;
  }
  echo '
<html>
<head>
<title>工资报表 - ';
  echo $CONTENT;
  echo '</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'tyle type="text/css">
.small {  font-size: 9pt;}
</style>
</head>
<body>
';
  $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 ();
  }
  echo '
<table  bordercolor="#000000" style=\'border-collapse:collapse\' border=1 cellspacing=0 cellpadding=2 bordercolor=\'#000000\' class="small" align="center">
    <tr bgcolor="#D3E5FA">
      <td nowrap align="center"><b>部门</b></td>
      <td nowrap align="center"><b>姓名</b></td>
      <td nowrap align="center"><b>角色</b></td>
';
  $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 = $ROW['ITEM_NAME'];
      $ITEM_ID[$COUNT] = $ROW['ITEM_ID'];
    }
    ++$COUNT;
    echo '      <td nowrap align="center"><b>';
    echo $ITEM_NAME;
    echo '</b></td>
';
  }
  echo '    </tr>
';
  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).')'));
  }
  if ((($TOID != '') AND ($TOID != 'ALL_DEPT')))
  {
    $TOID = (('\''.str_replace (',', '\',\'', substr ($TOID, 0, -1))).'\'');
    ($WHERE_STR .= (((''.' and DEPARTMENT.DEPT_ID in (').$TOID).')'));
  }
  if (($DEPT_FLAG != 1))
  {
    $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');
  }
  else
  {
    $query = 'SELECT * from USER,USER_PRIV where USER.USER_PRIV=USER_PRIV.USER_PRIV and DEPT_ID=0';
  }
  $cursor = exequery ($connection, $query);
  $USER_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$USER_COUNT;
    $USER_ID = $ROW['USER_ID'];
    $USER_NAME = $ROW['USER_NAME'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $USER_PRIV = $ROW['USER_PRIV'];
    if (($DEPT_ID == 0))
    {
      $DEPT_NAME = '离职人员/外部人员';
    }
    else
    {
      $query1 = ((''.'select * from DEPARTMENT where DEPT_ID=').$DEPT_ID);
      $cursor1 = exequery ($connection, $query1);
      if ($ROW = mysql_fetch_array ($cursor1))
      {
        $DEPT_NAME = $ROW['DEPT_NAME'];
      }
    }
    $query1 = (((''.'SELECT * from USER_PRIV where USER_PRIV=\'').$USER_PRIV).'\'');
    $cursor1 = exequery ($connection, $query1);
    if ($ROW = mysql_fetch_array ($cursor1))
    {
      $USER_PRIV = $ROW['PRIV_NAME'];
    }
    echo '    <tr>
      <td nowrap align="center">';
    echo $DEPT_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $USER_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $USER_PRIV;
    echo '</td>
';
    $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 = '&nbsp;';
      }
      echo '      <td nowrap align="right">';
      echo $$STR;
      echo '</td>
';
    }
    echo '    </tr>
';
  }
  if (($USER_COUNT == 0))
  {
    echo '  <div align="center"><b>尚未定义用户</b></div><br>
';
  }
  else
  {
    echo '  <tr bgcolor="#EEEEEE">
   <td nowrap align="center" colspan="3"><b>合计</b></td>
';
    for ($I = 0; ($I < $COUNT); ++$I)
    {
      $STR = ('S'.$ITEM_ID[$I]);
      $STR_COUNT = ($STR.'_COUNT');
      $DATA = format_money ($$STR_COUNT);
      if (($DATA == ''))
      {
        $DATA = '&nbsp;';
      }
      echo '   <td nowrap align="right"><b>';
      echo $DATA;
      echo '</b></td>
';
    }
    echo '  </tr>
';
  }
  echo '</table>
</div>
</body>
</html>';
?>

report.php - 源码说明

本页面展示了「通达OA2007SE源代码 非常好的」中的 report.php 源码文件，采用 PHP 编程语言编写，共 201 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与2007相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?