static final常量变量的正确书写规范_sql语句

AccountConstants.java类
命名:常量类以Constants单词命名结尾
package com.paic.pacz.core.salesmanage.util;
import java.util.ArrayList;

import java.util.List;
public class AccountConstants {

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 保单号 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String POLICY_NO = <span style="color: #800000;">"</span><span style="color: #800000;">policyNo</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 批单号 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String ENDORSE_NO = <span style="color: #800000;">"</span><span style="color: #800000;">endorseNo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 缴费方式 见费出单:1 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String IS_FEE_1 = <span style="color: #800000;">"</span><span style="color: #800000;">1</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 缴费方式 非费出单:2 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String IS_FEE_2 = <span style="color: #800000;">"</span><span style="color: #800000;">2</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 缴费方式 见费出单:见费出单 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String IS_FEE_NAME_1 = <span style="color: #800000;">"</span><span style="color: #800000;">见费出单</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 缴费方式 非见费出单:非见费出单 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String IS_FEE_NAME_2 = <span style="color: #800000;">"</span><span style="color: #800000;">非见费出单</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 缴费方式 其他默认:非见费出单 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String IS_FEE_NAME_OTHER_DEFAULT = <span style="color: #800000;">"</span><span style="color: #800000;">非见费出单</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 佣金支付状态 0:未提取 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String REWARD_PAY_STATUS_1 = <span style="color: #800000;">"</span><span style="color: #800000;">未提取</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 佣金支付状态 1:支付中 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String REWARD_PAY_STATUS_2 = <span style="color: #800000;">"</span><span style="color: #800000;">支付中</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 佣金支付状态 2支付完成 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String REWARD_PAY_STATUS_3 = <span style="color: #800000;">"</span><span style="color: #800000;">支付完成</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 平安产险 :1 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String INSURANCE_CODE_1 = <span style="color: #800000;">"</span><span style="color: #800000;">1</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 平安寿险 :2 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String INSURANCE_CODE_2 = <span style="color: #800000;">"</span><span style="color: #800000;">2</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 平安产险 :平安产险 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String INSURANCE_NAME_1 = <span style="color: #800000;">"</span><span style="color: #800000;">平安产险</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 平安寿险 :平安寿险 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String INSURANCE_NAME_2 = <span style="color: #800000;">"</span><span style="color: #800000;">平安寿险</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 其他默认:平安寿险 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String INSURANCE_NAME_OTHER_DEFAULT = <span style="color: #800000;">"</span><span style="color: #800000;">平安寿险</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 01币种值:01 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String CURRENCY_TYPE_01 = <span style="color: #800000;">"</span><span style="color: #800000;">01</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 01币种名:人民币 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String CURRENCY_TYPE_NAME_01 = <span style="color: #800000;">"</span><span style="color: #800000;">人民币</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 02币种值:02 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String CURRENCY_TYPE_02 = <span style="color: #800000;">"</span><span style="color: #800000;">02</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 02币种名:港币 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String CURRENCY_TYPE_NAME_02 = <span style="color: #800000;">"</span><span style="color: #800000;">港币</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 03币种值:03 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String CURRENCY_TYPE_03 = <span style="color: #800000;">"</span><span style="color: #800000;">03</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 03币种名:美元 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String CURRENCY_TYPE_NAME_03 = <span style="color: #800000;">"</span><span style="color: #800000;">美元</span><span style="color: #800000;">"</span><span style="color: #000000;">;
</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 其他币种名:其他币种 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String CURRENCY_TYPE_NAME_OTHER_DEFAULT = <span style="color: #800000;">"</span><span style="color: #800000;">其他币种</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 根据查询参数 需要导出台帐明细的sql语句的id </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String ACCOUNT_DETAIL_SQL_ID_BY_PARAM = <span style="color: #800000;">"</span><span style="color: #800000;">account.exportExcelAccountDetailInfoByQueryParam</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 根据复习框 需要导出台帐明细的sql语句的id </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String ACCOUNT_DETAIL_SQL_ID_BY_CHECK = <span style="color: #800000;">"</span><span style="color: #800000;">account.exportExcelAccountDetailInfoByChecked</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 需要导出台帐明细的sql语句的id </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String ACCOUNT_SQL_ID_BY_PARAM = <span style="color: #800000;">"</span><span style="color: #800000;">account.exportExcelAccountInfoByQueryParam</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 需要导出台帐明细的sql语句的id </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String ACCOUNT_SQL_ID_BY_CHECK = <span style="color: #800000;">"</span><span style="color: #800000;">account.exportExcelAccountInfoByChecked</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 需要导出手续费信息的sql语句的id </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String COMMISSION_SQL_ID = <span style="color: #800000;">"</span><span style="color: #800000;">commission.exporCommissionInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 业绩统计信息的sql语句的id </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String PERFORMANCE_SQL_ID = <span style="color: #800000;">"</span><span style="color: #800000;">performance.exporPerformanceInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 需要导出销售申报信息的sql语句的id ,ex-liuxin002</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String SALESREPORT_SQL_ID = <span style="color: #800000;">"</span><span style="color: #800000;">sales_manager.exporSalesReportInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 需要导出销售申报批量SQL语句的id,EX-XIEBING002</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String ALLSALESREPORT_SQL_ID = <span style="color: #800000;">"</span><span style="color: #800000;">sales_manager.exporAllSalesReportInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 需要导出代理人SQL语句的id,YAODEZHI061</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String AGENTINFOEXPORT_SQL_ID = <span style="color: #800000;">"</span><span style="color: #800000;">querycenter.excelAgentInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 需要导出会员SQL语句的id,YAODEZHI061</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String MEMBERINFOEXPORT_SQL_ID = <span style="color: #800000;">"</span><span style="color: #800000;">querycenter.excelMemberInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 需要导出税金明细SQL语句的id,ex-liuyalong001 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String TAXREPORT_SQL_ID = <span style="color: #800000;">"</span><span style="color: #800000;">taxRateManagement.exportTaxDetail</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 需要导出税金制证明细SQL语句的id,ex-xiebing002 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String TAXCERTIFICATE_SQL_ID = <span style="color: #800000;">"</span><span style="color: #800000;">taxRateManagement.exportTaxCertificateDetail</span><span style="color: #800000;">"</span><span style="color: #000000;">;


</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出台帐明细的Excel 文件名 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXCEL_ACCOUNT_DETAIL_NAME = <span style="color: #800000;">"</span><span style="color: #800000;">台帐明细</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出台帐明细的Excel 文件名 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXCEL_ACCOUNT_NAME = <span style="color: #800000;">"</span><span style="color: #800000;">台帐</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出手续费的Excel 文件名 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXCEL_COMMISSION_NAME = <span style="color: #800000;">"</span><span style="color: #800000;">手续费信息</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出销售申报来批量修改的Excel 文件名 ,ex-liuxin002 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXCEL_SALESREPORT_NAME = <span style="color: #800000;">"</span><span style="color: #800000;">销售申报信息</span><span style="color: #800000;">"</span><span style="color: #000000;">;


</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出业绩统计的Excel 文件名 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXCEL_PERFORMANCE_NAME = <span style="color: #800000;">"</span><span style="color: #800000;">业绩统计信息</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出销售清单的Excel 文件名 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXCEL_SALES_INFO = <span style="color: #800000;">"</span><span style="color: #800000;">销售清单信息</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出业绩清单的Excel 文件名 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXCEL_ACHIEVEINVENTORY_NAME = <span style="color: #800000;">"</span><span style="color: #800000;">业绩清单信息</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出税金明细的Excel 文件名 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXCEL_TAXREPORT_NAME = <span style="color: #800000;">"</span><span style="color: #800000;">税金明细信息</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出台帐明细的表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> accountDetailHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出台帐的表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> accountHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出手续费信息表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> commissionHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出业绩统计信息表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> performanceHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出销售申报表头信息 ,ex-liuxin002 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> salesReportHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 销售申报批量导出模板 ,EX-XIEBING002 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> salesAllReportHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出销售清单信息表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> salesInfoHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出业绩统计信息表头信息-监管专用角色 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> performanceSuperviserHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出业绩清单信息表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> achieveHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出税金明细表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> taxReportHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出税金制证明细表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> taxCertificateHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出代理人表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> agentInfoHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出会员表头信息 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final List<String> memberInfoHeaders = <span style="color: #0000ff;">new</span> ArrayList<String><span style="color: #000000;">();

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出返回数据结果集的Map Key </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXPORT_EXCEL_RESULT = <span style="color: #800000;">"</span><span style="color: #800000;">EXPORT_EXCEL_RESULT_kEY</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 导出Excel的参数对象 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXPORT_EXCEL = <span style="color: #800000;">"</span><span style="color: #800000;">EXPORT_EXCEL_KEY</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 获取导出数据的APP端的action方法 的URL </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXPORT_EXCEL_APP_URL = <span style="color: #800000;">"</span><span style="color: #800000;">/app/exportInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 获取导出数据的APP端的action方法 的URL </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXPORT_EXCEL_APP_URL_002 = <span style="color: #800000;">"</span><span style="color: #800000;">/app/exportAccountDataInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 获取导出数据的APP端的action方法 的URL </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXPORT_EXCEL_APP_URL_003 = <span style="color: #800000;">"</span><span style="color: #800000;">/app/exportSalesReportInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 获取导出数据的APP端的action方法 的URL EX-XIEBING002</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXPORT_EXCEL_APP_URL_004 = <span style="color: #800000;">"</span><span style="color: #800000;">/app/exportAllSalesReportInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">*获取导出数据的APP端的action方法的URL YAODEZHI061</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXPORT_EXCEL_APP_URL_005 =<span style="color: #800000;">"</span><span style="color: #800000;">/app/excelAgentInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">*获取导出数据的APP端的action方法的URL YAODEZHI061</span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String EXPORT_EXCEL_APP_URL_006 =<span style="color: #800000;">"</span><span style="color: #800000;">/app/excelMemberInfo</span><span style="color: #800000;">"</span><span style="color: #000000;">;

</span><span style="color: #008000;">/*</span><span style="color: #008000;">* 操作成功 </span><span style="color: #008000;">*/</span>
<span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> final String RETURN_SUCCESS = <span style="color: #800000;">"</span><span style="color: #800000;">SUCCESS</span><span style="color: #800000;">"</span><span style="color: #000000;">;


</span><span style="color: #0000ff;">static</span><span style="color: #000000;"> {

accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构代码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">出单时间</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">批单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">投保人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">被保人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">代理保险产品代码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">代理保险产品名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险金额</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保额币种</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保费币种</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务员</span><span style="color: #800000;">"</span><span style="color: #000000;">);

commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构代码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">批单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">期次</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">投保人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">被保险人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">代理保险产品编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">代理保险产品名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保额</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保额币种</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保费币种</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">缴费方式</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">手续费比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">应收手续费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">实收手续费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方佣金</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">佣金支付状态</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务员</span><span style="color: #800000;">"</span><span style="color: #000000;">);
commissionHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">到账时间</span><span style="color: #800000;">"</span><span style="color: #000000;">);

performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">批单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">期次</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">产品代码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">产品名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险金额</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">币种</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">应收手续费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">实收手续费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">出单时间</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">支付申请号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">实收时间</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方佣金</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务员</span><span style="color: #800000;">"</span><span style="color: #000000;">);
</span><span style="color: #008000;">/*</span><span style="color: #008000;">performanceHeaders.add("产险机构编码");
performanceHeaders.add("产险机构名称");</span><span style="color: #008000;">*/</span><span style="color: #000000;">
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保单来源</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险起期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">会员ID</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">会员名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
</span><span style="color: #008000;">//</span><span style="color: #008000;">performanceHeaders.add("产品大类");
</span><span style="color: #008000;">//</span><span style="color: #008000;">performanceHeaders.add("渠道来源");</span>


accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">批单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">期次</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险起期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险止期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">缴费方式</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">手续费比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">手续费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">手续费汇率</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方代码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">佣金</span><span style="color: #800000;">"</span><span style="color: #000000;">);
accountDetailHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">佣金汇率</span><span style="color: #800000;">"</span><span style="color: #000000;">);


achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">机构号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">被保险人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">签单日期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险起期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险止期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">二维码名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">二维码产品名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">渠道来源</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">实收保费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务员编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务员名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">车商编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">车商名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">代理人编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">代理人名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">经纪人编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">经纪人名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">主介绍人编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
achieveHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">主介绍人名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);


salesInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构代码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">分类信息</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">联系人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">电话</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">资格证号码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">资格证到期日</span><span style="color: #800000;">"</span><span style="color: #000000;">);

performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">被保险人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">投保人名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险人名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保单号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险起期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">产品名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险金额</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">保险费</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">缴费方式</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">手续费比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
performanceSuperviserHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">实收手续费</span><span style="color: #800000;">"</span><span style="color: #000000;">);

</span><span style="color: #008000;">/*</span><span style="color: #008000;">姓名、身份证号码、手机号、所属机构、申报人、申报日期、状态、创展业务员UM-姓名
商业险间接佣金比例、交强险间接佣金比例、商业险佣金比例、
交强险佣金比例、其他险种间接佣金比例、其他险种佣金比例 ,ex-liuxin002 </span><span style="color: #008000;">*/</span><span style="color: #000000;">
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">姓名</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">身份证号码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">手机号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">机构编号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">所属机构</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">序列号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">申报人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">申报日期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">状态</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">创展业务员</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">商业险间接佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">交强险间接佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">商业险佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">交强险佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">其他险种间接佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">其他险种佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);



</span><span style="color: #008000;">/*</span><span style="color: #008000;"> 产险个代转移创展批量导出模板 :EX-XIEBING002
*
* 创展销售所属机构代码,创展销售所属机构名称,增员人,创展业务员,创展销售姓名,身份证号码,手机号码,执业证号
* 执业证有效期,是否签订代理协议(是—1,否-0),代理协议有效期,入司时间,销售方等级,商业险间接佣金比例,
* 商业险佣金比例,交强险间接佣金比例,交强险佣金比例,其他险种间接佣金比例,其他险种佣金比例,销售方编码,
* 销售方类型,销售方属性,申报日期,生效时间,申报人
</span><span style="color: #008000;">*/</span><span style="color: #000000;">
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">创展销售所属机构代码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">创展销售所属机构名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">增员人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">创展业务员</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">创展销售姓名</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">身份证号码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">手机号码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">执业证号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">执业证有效期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">是否签订代理协议</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">代理协议有效期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">入司时间</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方等级</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">商业险佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">商业险间接佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">交强险佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">交强险间接佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">其他险种佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">其他险种间接佣金比例</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方编码</span><span style="color: #800000;">"</span>);<span style="color: #008000;">//</span><span style="color: #008000;">销售方编码</span>
salesAllReportHeaders.add(<span style="color: #800000;">"</span><span style="color: #800000;">销售方类型</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方属性</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">申报日期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">申报人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">下线数量</span><span style="color: #800000;">"</span><span style="color: #000000;">);
salesAllReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">生效时间</span><span style="color: #800000;">"</span>);<span style="color: #008000;">//</span><span style="color: #008000;">生效时间</span>
salesAllReportHeaders.add(<span style="color: #800000;">"</span><span style="color: #800000;">备注</span><span style="color: #800000;">"</span><span style="color: #000000;">);


</span><span style="color: #008000;">/*</span><span style="color: #008000;">税金明细导出模板 :ex-liuyalong001
业务机构、业务机构名称、财务机构、财务机构名称、交易流水号、收款人姓名、身份证号码、出生年月、性别、提现金额、税金、提现时间,凭证月份</span><span style="color: #008000;">*/</span><span style="color: #000000;">
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构代码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">财务机构代码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">财务机构名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">交易流水号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">收款人姓名</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">身份证号码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">出生年月</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">性别</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">提现金额</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">税金</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">提现时间</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxReportHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">凭证日期</span><span style="color: #800000;">"</span><span style="color: #000000;">);

</span><span style="color: #008000;">/*</span><span style="color: #008000;">
* 导出税金制证明细模板:EX-XIEBING002
* 财务机构, 科目,凭证号, 批次号,凭证日期,金额
</span><span style="color: #008000;">*/</span><span style="color: #000000;">

taxCertificateHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">财务机构</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxCertificateHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">科目</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxCertificateHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">凭证号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxCertificateHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">批次号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxCertificateHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">凭证日期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
taxCertificateHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">金额</span><span style="color: #800000;">"</span><span style="color: #000000;">);

</span><span style="color: #008000;">/*</span><span style="color: #008000;">*
* 导出代理人信息模板:YAODEZHI061
</span><span style="color: #008000;">*/</span><span style="color: #000000;">
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">机构名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">创展销售码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">姓名</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">身份证号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">手机号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">增员人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">下线数量</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">执业证号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">执业证有效期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">销售方等级</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务员编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务员姓名</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">申报渠道</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">申报日期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">入司时间</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">生效日期</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">申报人</span><span style="color: #800000;">"</span><span style="color: #000000;">);
agentInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">备注</span><span style="color: #800000;">"</span><span style="color: #000000;">);

</span><span style="color: #008000;">/*</span><span style="color: #008000;">*
* 导出会员信息模板
</span><span style="color: #008000;">*/</span><span style="color: #000000;">
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务机构</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">机构名称</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">会员ID</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">会员姓名</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">会员手机号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">会员注册时间</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">会员身份证号</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">是否个代</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">个代编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">会员等级</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务员编码</span><span style="color: #800000;">"</span><span style="color: #000000;">);
memberInfoHeaders.add(</span><span style="color: #800000;">"</span><span style="color: #800000;">业务员姓名</span><span style="color: #800000;">"</span><span style="color: #000000;">);

}

}


static final常量变量的正确书写规范_JDK_02