前台显示页面:
然后点击展开按钮:
勾选展开或者收起里的复选框,或者勾选序号里的复选框,点击翻译后还会记住之前的勾选,点击excel导出,可以导出你任意勾选的复选框的数据,下面是对应的前台jsp,后台java处理代码。
前台jsp:
<%@ page contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="com.sunline.jraf.util.*"%>
<%@ page import="com.sunline.jraf.web.*"%>
<%@ taglib uri="http://www.sunline.cn/jsp/common" prefix="sc"%>
<%@ include file="/jui_tag.jsp"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<style>
.butshow {
background-color: #97CBFF;
border: none;
color: white;
padding: 2px 2px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 13px;
margin: 4px 2px;
cursor: pointer;
}
.buthid {
background-color: #97CBFF;
border: none;
color: white;
padding: 2px 2px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 13px;
margin: 4px,2px;
cursor: pointer;
margin-left:45px;
}
</style>
<!--财务回收冲成本明细表(确认日期)-->
<div class="pageHeader">
<form id="pagerForm" οnsubmit="return navTabSearch(this);"
action="/httpprocesserservlet" method="post">
<sc:hidden name="pageNum" value="1" />
<input type="hidden" name="sysName"
value="<%=Crypto.encode(request, "gdfamc")%>" /> <input
type="hidden" name="oprID"
value="<%=Crypto.encode(request, "AssetturnoverStatisticalAction")%>" /> <input
type="hidden" name="actions"
value="<%=Crypto.encode(request, "queryAssetturnoverStatisticallist")%>" />
<input type="hidden" name="forward"
value="<sc:fmt value='/gdfamc/statisticalQuery/turnoverDetaillist.jsp' type='crypto'/>" />
<sc:hidden name="jraf_initsubmit" />
<sc:hidden name="checktextsum" id="checktextsum" value="${jrafrpu.rspPkg.rspRcdDataMapsResults4[0].checktextsum}"/>
<sc:hidden name="checkbool" id="checkbool" value="${jrafrpu.rspPkg.rspRcdDataMapsResults4[0].checkbool}"/>
<sc:hidden name="assetidval" id="assetidval" value="${jrafrpu.rspPkg.rspRcdDataMapsResults4[0].assetidval}"/>
<div class="searchBar">
<table class="searchContent" cellpadding="0" cellspacing="0">
<!-- <tr>
<td class="form-label">产品</td>
<td>
<sc:hidden id="asset_detail_type" name="asset_detail_type" />
<sc:text id="asset_detail_name" name="asset_detail_name" readonly="true" />
<a class="btnLook" title="选择-产品" lookupGroup="" width="900" height="520"
href="/gdfamc/public/productClassifySelectList.jsp?lookupcd=asset_detail_type&lookupname=asset_detail_name&lookuptype=prodtype&lookupinttype=interest_type&lookuptradobj=deal_purpose"></a>
</td>
</td>
<td class="form-label">资产状态</td>
<td>
<sc:select name="asset_status" id="asset_status" nullOption="-----请选择-----"
type="knp" key="ast,gdfamc_ast_aststatus" excludes="%"/>
</td>
<td align="right"><input type="submit" class="button"
jraf_initsubmit value="查询" /> <input type="reset" class="button"
value="清空" /></td>
</tr> -->
<tr name="spanpublic">
<td>
<input type="checkbox" name="checktext" class="" value="document_number" traget="document_number" οnclick="checkboxshow()"/><span>项目台账编号</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" value="project_name" traget="project_name" οnclick="checkboxshow()"/><span>项目名称</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" value="fin_date" traget="fin_date" οnclick="checkboxshow()"/><span>业务发生日</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="term" value="term" οnclick="checkboxshow()"/><span>期限</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="owner_name" value="owner_name" οnclick="checkboxshow()"/><span>经办人</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="owning_business_unit_name" style="margin-left:45px;" value="owning_business_unit_name" οnclick="checkboxshow()"/><span>部门</span>
</td>
</tr>
<tr name="spanpublic">
<td>
<input type="checkbox" name="checktext" class="" traget="asset_main_type" value="asset_main_type" οnclick="checkboxshow()"/><span>业务类型</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="asset_detail_name" style="margin-left:45px;" value="asset_detail_name" οnclick="checkboxshow()"/><span>产品</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="prodtype" value="prodtype" οnclick="checkboxshow()"/><span>产品类型</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="investment_type" style="margin-left:45px;" value="investment_type" οnclick="checkboxshow()"/><span>投资产品分类</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="deal_purpose" value="deal_purpose" οnclick="checkboxshow()"/><span>交易目的</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="asset_type" value="asset_type" οnclick="checkboxshow()"/><span>持有方式</span>
</td>
</tr>
<tr name="spanpublic">
<td>
<input type="checkbox" name="checktext" class="" traget="share_assets" value="share_assets" οnclick="checkboxshow()"/><span>资产占有份额(%)</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="initial_investment" style="margin-left:45px;" value="initial_investment" οnclick="checkboxshow()"/><span>首次付款金额(原币)</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="cost" value="cost" οnclick="checkboxshow()"/><span>成本(原币)</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="interest_receivable" style="margin-left:45px;" value="interest_receivable" οnclick="checkboxshow()"/><span>应收利息(原币)</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="transaction_expense" class="" value="transaction_expense" οnclick="checkboxshow()"/><span>交易费用(原币)</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="contract_loan_amt" style="margin-left:45px;" value="contract_loan_amt" οnclick="checkboxshow()"/><span>合同金额(原币)</span>
</td>
</tr>
<tr name="spanpublic">
<td>
<input type="checkbox" name="checktext" traget="accumulated_amount" class="" value="accumulated_amount" οnclick="checkboxshow()"/><span>累计投放金额(原币)</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="contract_effective_date" style="margin-left:45px;" value="contract_effective_date" οnclick="checkboxshow()"/><span>合同开始日期</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="contract_due_date" class="" value="contract_due_date" οnclick="checkboxshow()"/><span>合同结束日期</span>
</td>
<td>
<input type="checkbox" name="checktext" traget="payment_day" style="margin-left:45px;" value="payment_day" οnclick="checkboxshow()"/><span>期间赎回日</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="deal_date" value="deal_date" οnclick="checkboxshow()"/><span>交易日期</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="liquidity" value="liquidity" οnclick="checkboxshow()"/><span>流动性</span>
</td>
</tr>
<tr name="spanpublic">
<td>
<input type="checkbox" name="checktext" class="" traget="security" value="security" οnclick="checkboxshow()"/><span>安全性</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="interest_type" value="interest_type" οnclick="checkboxshow()"/><span>计息类型</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="interest_method" value="interest_method" οnclick="checkboxshow()"/><span>计息方式</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="interest_start_date" value="interest_start_date" οnclick="checkboxshow()"/><span>起息日</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="interest_end_date" value="interest_end_date" οnclick="checkboxshow()"/><span>到期日</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="latest_interest_day" value="latest_interest_day" οnclick="checkboxshow()"/><span>最新计息日</span>
</td>
</tr>
<tr name="spanpublic">
<td>
<input type="checkbox" name="checktext" class="" traget="income_type" value="income_type" οnclick="checkboxshow()"/><span>收益类型</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="share_way" value="share_way" οnclick="checkboxshow()"/><span>付息方式/分红方式</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="share_frequency" value="share_frequency" οnclick="checkboxshow()"/><span>付息频率/分红频率</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="share_frequency_remark" value="share_frequency_remark" οnclick="checkboxshow()"/><span>付息说明</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="tax_yield" value="tax_yield" οnclick="checkboxshow()"/><span>税前收益率(%)</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="annual_rate" value="annual_rate" οnclick="checkboxshow()"/><span>税后收益率(%)</span>
</td>
</tr>
<tr name="spanpublic">
<td>
<input type="checkbox" name="checktext" class="" traget="correspondingamount_back" value="correspondingamount_back" οnclick="checkboxshow()"/><span>收回原始投资成本(原币)</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="correspondingamount_close" value="correspondingamount_close" οnclick="checkboxshow()"/><span>收投资收益金额(原币)</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="correspondingamount_total" value="correspondingamount_total" οnclick="checkboxshow()"/><span>合计</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="asset_status" value="asset_status" οnclick="checkboxshow()"/><span>资产状态</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="counterparty" value="counterparty" οnclick="checkboxshow()"/><span>合作机构</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="basic_financiers" value="basic_financiers" οnclick="checkboxshow()"/><span>基础资产融资人</span>
</td>
</tr>
<tr name="spanpublic">
<td>
<input type="checkbox" name="checktext" class="" traget="industry_of_financiers" value="industry_of_financiers" οnclick="checkboxshow()"/><span>基础资产所属行业</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="gb_trade" value="gb_trade" οnclick="checkboxshow()"/><span>国标行业</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="number_bal_orig1" value="number_bal_orig1" οnclick="checkboxshow()"/><span>本金余额</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="number_bal_orig5" value="number_bal_orig5" οnclick="checkboxshow()"/><span>应计利息余额</span>
</td>
<td>
<input type="checkbox" name="checktext" class="" traget="number_bal_orig7" value="number_bal_orig7" οnclick="checkboxshow()"/><span>投资收益余额(原币)</span>
</td>
<td>
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="number_bal_orig9" value="number_bal_orig9" οnclick="checkboxshow()"/><span>其他资本公积余额(原币)</span>
</td>
</tr>
<tr>
<td name="spanpublic">
<input type="checkbox" name="checktext" class="" traget="number_bal_orig11" value="number_bal_orig11" οnclick="checkboxshow()"/><span>销项税余额(原币)</span>
</td>
<td name="spanpublic">
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="number_bal_orig2" value="number_bal_orig2" οnclick="checkboxshow()"/><span>资金往来余额</span>
</td>
<td name="spanpublic">
<input type="checkbox" name="checktext" class="" traget="number_bal_orig3" value="number_bal_orig3" οnclick="checkboxshow()"/><span>公允价值变动余额(原币)</span>
</td>
<td name="spanpublic">
<input type="checkbox" name="checktext" style="margin-left:45px;" traget="number_bal_orig4" value="number_bal_orig4" οnclick="checkboxshow()"/><span>公允价值变动损益余额(原币)</span>
</td>
<td name="spanpublic">
<input type="checkbox" name="checktext" traget="number_bal_orig19" value="number_bal_orig19" οnclick="checkboxshow()"/><span>应收利息余额(原币)</span>
</td>
<!--
<td name="checkshow">
<input type="button" class="butshow" οnclick="checkshow1()" value="《展开更多》"/>
</td>
<td name="checkedshow">
<input type="button" class="buthid" οnclick="checkedshow1()" value="《收起更多》" />
</td> -->
</tr>
<tr>
<td align="right">产品</td>
<td>
<sc:hidden id="asset_detail_type" name="asset_detail_type" />
<sc:text id="asset_detail_name" name="asset_detail_name" readonly="true" />
<a class="btnLook" title="选择-产品" lookupGroup="" width="900" height="520"
href="/gdfamc/public/productClassifySelectList.jsp?lookupcd=asset_detail_type&lookupname=asset_detail_name&lookuptype=prodtype&lookupinttype=interest_type&lookuptradobj=deal_purpose"></a>
</td>
<td align="right">项目名称</td>
<td>
<sc:text name="project_name" id="project_name"/>
</td>
<td align="right">投资产品类型</td>
<td>
<sc:select name="investment_type" id="investment_type" type="knp" key="ast,ast_investment_type"
nullOption="---请选择----"/>
</td>
</tr>
<tr>
<td align="right">业务发生日</td>
<td>
<sc:date name="fin_date" id="fin_date" dateFmt="yyyy-MM-dd" readonly="true"/> --
<sc:date name="fin_date_end" id="fin_date_end" dateFmt="yyyy-MM-dd" readonly="true"/>
</td>
<td align="right">实际到期日</td>
<td>
<sc:date name="interest_end_date" id="interest_end_date" dateFmt="yyyy-MM-dd" readonly="true"/> --
<sc:date name="interest_end_date_end" id="interest_end_date_end" dateFmt="yyyy-MM-dd" readon