📄 query.php

📁 通达OA2007SE源代码非常好的
💻 PHP
字号:
<?
  include_once 'inc/auth.php';
  include_once 'inc/check_type.php';
  include_once 'inc/utility_all.php';
  echo '
<html>
<head>
<title>固定资产查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
';
  echo '<s';
  echo 'cript>
function cptl_detail(CPTL_ID)
{
 URL="cptl_detail.php?CPTL_ID="+CPTL_ID;
 myleft=(screen.availWidth-500)/2;
 window.open(URL,"read_notify","height=470,width=400,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
function dpct_detail(CPTL_ID)
{
 URL="dpct_detail.php?CPTL_ID="+CPTL_ID;
 myleft=(screen.availWidth-500)/2;
 window.op';
  echo 'en(URL,"read_notify","height=400,width=400,status=0,toolbar=no,menubar=no,location=no,scrollbars=yes,top=150,left="+myleft+",resizable=yes");
}
</script>
</head>
<body class="bodycolor" topmargin="5">
';
  $CUR_DATE = date ('Y-m-d', time ());
  if (($CREATE_DATE_MIN != ''))
  {
    $TIME_OK = is_date ($CREATE_DATE_MIN);
    if (!$TIME_OK)
    {
      message ('错误', ('"增加日期"的"开始日期"格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  if (($CREATE_DATE_MAX != ''))
  {
    $TIME_OK = is_date ($CREATE_DATE_MAX);
    if (!$TIME_OK)
    {
      message ('错误', ('"增加日期"的"结束日期"格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  if (($DCR_DATE_MIN != ''))
  {
    $TIME_OK = is_date ($DCR_DATE_MIN);
    if (!$TIME_OK)
    {
      message ('错误', ('"减少日期"的"开始日期"格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  if (($DCR_DATE_MAX != ''))
  {
    $TIME_OK = is_date ($DCR_DATE_MAX);
    if (!$TIME_OK)
    {
      message ('错误', ('"减少日期"的"结束日期"格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  if (($FROM_YYMM_MIN != ''))
  {
    $TIME_OK = is_date ($FROM_YYMM_MIN);
    if (!$TIME_OK)
    {
      message ('错误', ('"启用日期"的"开始日期"格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  if (($FROM_YYMM_MAX != ''))
  {
    $TIME_OK = is_date ($FROM_YYMM_MAX);
    if (!$TIME_OK)
    {
      message ('错误', ('"启用日期"的"结束日期"格式不对，应形如 '.$CUR_DATE));
      button_back ();
      exit ();
    }
  }
  $CONDITION_STR = '';
  if (($CPTL_NO != ''))
  {
    ($CONDITION_STR .= ((' and CPTL_NO like \'%'.$CPTL_NO).'%\''));
  }
  if (($CPTL_NAME != ''))
  {
    ($CONDITION_STR .= ((' and CPTL_NAME like \'%'.$CPTL_NAME).'%\''));
  }
  if (($TYPE_ID != ''))
  {
    ($CONDITION_STR .= ((''.' and TYPE_ID=').$TYPE_ID));
  }
  if (($DEPT_ID != ''))
  {
    ($CONDITION_STR .= ((''.' and CP_CPTL_INFO.DEPT_ID=').$DEPT_ID));
  }
  if (($CPTL_KIND != ''))
  {
    ($CONDITION_STR .= ((''.' and CPTL_KIND=').$CPTL_KIND));
  }
  if (($PRCS_ID != ''))
  {
    ($CONDITION_STR .= ((''.' and PRCS_ID=').$PRCS_ID));
  }
  if (($DCR_PRCS_ID != ''))
  {
    ($CONDITION_STR .= ((''.' and DCR_PRCS_ID=').$DCR_PRCS_ID));
  }
  if (($FINISH_FLAG != ''))
  {
    ($CONDITION_STR .= ((''.' and FINISH_FLAG=').$FINISH_FLAG));
  }
  if (($CPTL_VAL_MIN != ''))
  {
    ($CONDITION_STR .= ((''.' and CPTL_VAL>=').$CPTL_VAL_MIN));
  }
  if (($CPTL_VAL_MAX != ''))
  {
    ($CONDITION_STR .= ((''.' and CPTL_VAL<=').$CPTL_VAL_MAX));
  }
  if (($CPTL_BAL_MIN != ''))
  {
    ($CONDITION_STR .= ((''.' and CPTL_BAL>=').$CPTL_BAL_MIN));
  }
  if (($CPTL_BAL_MAX != ''))
  {
    ($CONDITION_STR .= ((''.' and CPTL_BAL<=').$CPTL_BAL_MAX));
  }
  if (($CREATE_DATE_MIN != ''))
  {
    ($CONDITION_STR .= (((''.' and CREATE_DATE>=\'').$CREATE_DATE_MIN).'\''));
  }
  if (($CREATE_DATE_MAX != ''))
  {
    ($CONDITION_STR .= (((''.' and CREATE_DATE<=\'').$CREATE_DATE_MAX).'\''));
  }
  if (($DCR_DATE_MIN != ''))
  {
    ($CONDITION_STR .= (((''.' and DCR_DATE>=\'').$DCR_DATE_MIN).'\''));
  }
  if (($DCR_DATE_MAX != ''))
  {
    ($CONDITION_STR .= (((''.' and DCR_DATE<=\'').$DCR_DATE_MAX).'\''));
  }
  if (($FROM_YYMM_MIN != ''))
  {
    ($CONDITION_STR .= (((''.' and FROM_YYMM>=\'').$FROM_YYMM_MIN).'\''));
  }
  if (($FROM_YYMM_MAX != ''))
  {
    ($CONDITION_STR .= (((''.' and FROM_YYMM<=\'').$FROM_YYMM_MAX).'\''));
  }
  if (($KEEPER != ''))
  {
    ($CONDITION_STR .= ((' and KEEPER like \'%'.$KEEPER).'%\''));
  }
  if (($REMARK != ''))
  {
    ($CONDITION_STR .= ((' and REMARK like \'%'.$REMARK).'%\''));
  }
  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"> 固定资产查询结果</span><br>
    </td>
  </tr>
</table>
';
  $query = (('select * from CP_CPTL_INFO where 1=1 '.$CONDITION_STR).' order by DEPT_ID,CREATE_DATE,CPTL_NO');
  $cursor = exequery ($connection, $query);
  $CPTL_COUNT = 0;
  $CPTL_VAL_COUNT = 0;
  while ($ROW = mysql_fetch_array ($cursor))
  {
    ++$CPTL_COUNT;
    $CPTL_ID = $ROW['CPTL_ID'];
    $CPTL_NO = $ROW['CPTL_NO'];
    $CPTL_NAME = $ROW['CPTL_NAME'];
    $DEPT_ID = $ROW['DEPT_ID'];
    $CPTL_VAL = $ROW['CPTL_VAL'];
    $CPTL_BAL = $ROW['CPTL_BAL'];
    $DPCT_YY = $ROW['DPCT_YY'];
    $MON_DPCT = $ROW['MON_DPCT'];
    $SUM_DPCT = $ROW['SUM_DPCT'];
    $CPTL_KIND = $ROW['CPTL_KIND'];
    $PRCS_ID = $ROW['PRCS_ID'];
    $FINISH_FLAG = $ROW['FINISH_FLAG'];
    $CREATE_DATE = $ROW['CREATE_DATE'];
    $FROM_YYMM = $ROW['FROM_YYMM'];
    ($CPTL_VAL_COUNT += $CPTL_VAL);
    if (($CPTL_KIND == '01'))
    {
      $CPTL_KIND_DESC = '资产';
    }
    else
    {
      if (($CPTL_KIND == '02'))
      {
        $CPTL_KIND_DESC = '费用';
      }
    }
    $query1 = ((''.'select * from CP_PRCS_PROP where PRCS_ID=').$PRCS_ID);
    $cursor1 = exequery ($connection, $query1);
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $PRCS_LONG_DESC = $ROW1['PRCS_LONG_DESC'];
    }
    $query1 = ((''.'select * from DEPARTMENT where DEPT_ID=').$DEPT_ID);
    $cursor1 = exequery ($connection, $query1);
    if ($ROW1 = mysql_fetch_array ($cursor1))
    {
      $DEPT_NAME = $ROW1['DEPT_NAME'];
    }
    if (($CPTL_COUNT == 1))
    {
      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>
      <td nowrap align="center">资产性质</td>
      <td nowrap align="center">增加类型</td>
      <td now';
      echo 'rap align="center">增加日期<img border=0 src="/images/arrow_down.gif" width="11" height="10"></td>
      <td nowrap align="center">操作</td>
    </tr>
';
    }
    if ((($CPTL_COUNT % 2) == 1))
    {
      $TableLine = 'TableLine1';
    }
    else
    {
      $TableLine = 'TableLine2';
    }
    echo ' <tr class="';
    echo $TableLine;
    echo '">
      <td nowrap align="center">';
    echo $DEPT_NAME;
    echo '</td>
      <td nowrap align="center">';
    echo $CPTL_NO;
    echo '</td>
      <td>
      <a href="javascript:cptl_detail(\'';
    echo $CPTL_ID;
    echo '\');">';
    echo $CPTL_NAME;
    echo '</a>
      </td>
      <td nowrap align="center">';
    echo $CPTL_VAL;
    echo '</a></td>
      <td nowrap align="center">';
    echo $CPTL_KIND_DESC;
    echo '</td>
      <td nowrap align="left">';
    echo $PRCS_LONG_DESC;
    echo '</td>
      <td nowrap align="center">';
    echo $CREATE_DATE;
    echo '</td>
      <td nowrap align="center">
      <a href="javascript:cptl_detail(\'';
    echo $CPTL_ID;
    echo '\');"> 详情</a>
      <a href="javascript:dpct_detail(\'';
    echo $CPTL_ID;
    echo '\');"> 折旧记录</a>
      </td>
    </tr>
';
  }
  if (($CPTL_COUNT == 0))
  {
    message ('', '无符合条件的固定资产信息');
    button_back ();
    exit ();
  }
  else
  {
    echo '    <tr class="TableControl">
      <td nowrap align="center">合计：</td>
      <td nowrap colspan="2"></td>
      <td nowrap align="center">';
    echo $CPTL_VAL_COUNT;
    echo '</a></td>
      <td nowrap colspan="4"</td>
    </tr>
</table>
';
    button_back ();
  }
  echo '</body>
</html>
';
?>
⌨️ 快捷键说明

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