📄 query.php

📁 极限网络智能办公系统 Office Automation V3.0官方100％源代码.
💻 PHP
字号:
<?
include_once("inc/auth.php");
include_once("inc/check_type.php");
include_once("inc/utility_all.php");
?>

<html>
<head>
<title>固定资产查询</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">

<script>
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.open(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">

<?
 $connection=OpenConnection();
 $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."%'";
?>

<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"><span 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)
   {
?>
<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 nowrap 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";
?>
 <tr class="<?=$TableLine?>">
      <td nowrap align="center"><?=$DEPT_NAME?></td>
      <td nowrap align="center"><?=$CPTL_NO?></td>
      <td>
      <a href="javascript:cptl_detail('<?=$CPTL_ID?>');"><?=$CPTL_NAME?></a>
      </td>
      <td nowrap align="center"><?=$CPTL_VAL?></a></td>
      <td nowrap align="center"><?=$CPTL_KIND_DESC?></td>
      <td nowrap align="left"><?=$PRCS_LONG_DESC?></td>
      <td nowrap align="center"><?=$CREATE_DATE?></td>
      <td nowrap align="center">
      <a href="javascript:cptl_detail('<?=$CPTL_ID?>');"> 详情</a>
      <a href="javascript:dpct_detail('<?=$CPTL_ID?>');"> 折旧记录</a>
      </td>
    </tr>
<?
}

if($CPTL_COUNT==0)
{
   Message("","无符合条件的固定资产信息");
   Button_Back();
   exit;
}
else
{
?>
    <tr class="TableControl">
      <td nowrap align="center">合计：</td>
      <td nowrap colspan="2"></td>
      <td nowrap align="center"><?=$CPTL_VAL_COUNT?></a></td>
      <td nowrap colspan="4"</td>
    </tr>
</table>

<?
Button_Back();
}
?>
</body>

</html>
💿 文件大小 24085 K
👤 上传用户 happy_christina
📂 所属分类 OA系统
🏷️ 相关标签

#Automation #Office #3.0 #100
⌨️ 快捷键说明

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