📄 dpct_detail.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>固定资产折旧记录</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body class="bodycolor" topmargin="5">
';
  $query = ((''.'select * from CP_CPTL_INFO where CPTL_ID=').$CPTL_ID);
  $cursor = exequery ($connection, $query);
  if ($ROW = mysql_fetch_array ($cursor))
  {
    $CPTL_NO = $ROW['CPTL_NO'];
    $CPTL_NAME = $ROW['CPTL_NAME'];
  }
  echo '<table border="0" width="100%" cellspacing="0" cellpadding="3" class="small">
  <tr>
    <td class="Big"><img src="/images/menu/asset.gif"  width="24" height="24">';
  echo '<s';
  echo 'pan class="big3"> 固定资产折旧记录 - ';
  echo $CPTL_NAME;
  echo '</span><br>
    </td>
    </tr>
</table>
<hr width="100%" height="1" align="left" color="#FFFFFF">
';
  $CUR_DATE = date ('Y-m-d', time ());
  $COUNT = 0;
  $query = (((''.'select * from CP_DPCT_SUB where CPTL_ID=').$CPTL_ID).' order by PEPRE_DATE asc');
  $cursor = exequery ($connection, $query);
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$COUNT;
    $PEPRE_DATE = $ROW['PEPRE_DATE'];
    $FROM_YYMM = $ROW['FROM_YYMM'];
    $TO_YYMM = $ROW['TO_YYMM'];
    $DEPRE_AMT = $ROW['DEPRE_AMT'];
    if (($COUNT == 1))
    {
      if ((($COUNT % 2) == 1))
      {
        $TableLine = 'TableLine1';
      }
      else
      {
        $TableLine = 'TableLine2';
      }
      echo '<table border="0" cellspacing="1" width="95%" class="small" bgcolor="#000000" cellpadding="3">
  <tr class="TableHeader">
      <td nowrap align="center">发生时间</td>
      <td nowrap align="center">起始时间</td>
      <td nowrap align="center">结束时间</td>
      <td nowrap align="center">折旧金额</td>
  </tr>
';
    }
    echo ' <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $PEPRE_DATE;
    echo '</td>
      <td nowrap align="center">';
    echo $FROM_YYMM;
    echo '</td>
      <td nowrap align="center">';
    echo $TO_YYMM;
    echo '</a></td>
      <td nowrap align="right">';
    echo $DEPRE_AMT;
    echo '</td>
</tr>
';
  }
  if ((0 < $COUNT))
  {
    echo '<tr class="TableControl">
      <td colspan="9" align="center">
           <input type="button" value="打印" class="BigButton" onclick="document.execCommand(\'Print\');" title="直接打印表格页面">&nbsp;&nbsp;&nbsp;&nbsp;
           <input type="button" value="关闭" class="BigButton" onClick="window.close();" title="关闭窗口">
      </td>
  </tr>
</table>
';
  }
  else
  {
    message ('', '未找到相应记录！');
  }
  echo '
</body>
</html>';
?>
⌨️ 快捷键说明

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