2021-04-22 11:51:58 正常:11:51:58 pool-1-thread-1 INFO [root] 关闭Session:46062 2021-04-22 11:52:07 正常:11:52:07 pool-1-thread-1 INFO [root] columnIndex:1[12]<--->columnValue:export_ppm_purchase_payment_contractInfo1.cpt[java.lang.String] 2021-04-22 11:52:07 正常:11:52:07 pool-1-thread-1 INFO [root] 开始计算报表 2021-04-22 11:52:07 正常:11:52:07 pool-1-thread-1 INFO [root] SQL: SELECT * FROM (SELECT ORDER_ID, CREATE_EMP, CREATE_EMP_DESC, DEPT_ID, CREATE_DATE, CONTRACT_TYPE, CONTRACT_NAME, ORDER_STATE, ORDER_STATE_DESC, ORDER_CODE, FACTORY_CODE, FACTORY_CODE_DESC, FACTORY_FULL_NAME, FROM_CONTRACT_CODE, FACTORY_NAME, FLOW_ID, MODIFIED_EMP, MODIFIED_EMP_DESC, MODIFIED_DATE, PROJECT_ID, PROJECT_NAME, HIGH_LEVEL_ORDER_ID, SUPPLIERNUM, SUPPLIERNAME, CONTRACT_CODE, CONTRACT_COMPANY, CONTRACT_COMPANY_DESC, CONTRACT_MONEY_RMB, FEE_TYPE, FEE_TYPE_NAME, REMARK, PAYMENT_MONEY_RMB, IF_END_CONTRACT, CONTRACT_CONTENT, CONTRACT_MONEY, PAYMENT_MONEY, FIRST_SUPPLIER_MONEY, INVOICE_TYPE, INVOICE_TYPE_DESC, TAX_RATE, TAX_RATE_DESC, IN_MONEY_SUM, TRANSPORT_TYPE, TRANSPORT_TYPE_DESC, PAYMENT_TYPE, PAYMENT_TYPE_DESC, AFFIX_TO_DATE, FACT_FINISH_DATE, CONFIRM_SUPPLIER_ID, DELIVERY_DATE, DELIVERY_DAYS, OVERREACH_DAYS, UNIT_PRICE_CONTRACT, CURRENCY, CURRENCY_DESC, EXE_EMP_CODE, EXE_EMP_CODE_DESC, CONTRACT_FLAG, CONTRACT_FLAG_DESC, IN_ORDER_CODE, IN_ORDER_ID, TEC_EMP_CODE, TEC_EMP_CODE_DESC, STATE_COLOR, CORP_CONTRACT_CODE, SUPPLIER_LINKMAN, COMPANY_ADDRESS, RESPONSIBLE_PERSON, RESPONSIBLE_PERSON_DESC, COMPANY_TEL, COMPANY_FAX, FACTORY_EMP_CODE, FACTORY_TEL, FACTORY_MOBILE, FACTORY_ADDRESS, INVOICE_COMPANY_NAME, INVOICE_COMPANY_ADDRESS, SUPPLIER_BANK_NAME, COMPANY_BANK_NAME, SUPPLIER_ACCOUNT, COMPANY_ACCOUNT, SUPPLIER_TAX_NUM, COMPANY_TAX_NUM, SUPPLIER_TEL, INVOICE_COMPANY_TEL, INVOICE_COMPANY_POSTCODE, SUPPLIER_FAX, BUDGET_YEAR, BUDGET_CODE, IF_INCLUDE_TAX, IF_TRANS_FEE, IF_NO_INCLUDE, IF_END_PAY, EXCHANGE_RATE, CONTRACT_CODE_ALL, IF_SUPPLEMENT, MODE_FLAG, CONTRACT_TYPE_ALL, CONTRACT_TYPE_ALL_DESC, IF_UNITPRICE_CONTRACT, IF_HAVE_SECOND_SUPPLIER, F_HASZHAOTOUBIAO, F_ZHAOTOUBIAOURL, F_HASSHIQIAN, F_SHIQIANURL, IF_MAIN_CONTRACT, GHQ_VALUE, IF_MAIN_CONTRACT_DESC, MAIN_CONTRACT_ID, NEXT_LEVEL_CODE, MAIN_LEADER, MAIN_LEADER_DESC, IF_RECEIVABLES, ADJ_MONEY, TYPE_ID, TYPE_ID_DESC, RELATED_CONTRACT, MALL_NUM, FACTORY_ACCOUNT_NAME, FACTORY_INVOICE_ADDRESS, IF_PLAN_FLAG, QUERY_COLUMN, USE_TYPE, PERFORMANCE_BOND, PERFORMANCE_BOND_DATE, LINK_TEL, IF_MATERIAL_BUY, MAT_PAYMENT_CODE, IF_COMPARE_PRICE FROM V_MAT_PURCHASE_CONTRACT T WHERE CONTRACT_TYPE not in ('J', 'F') AND ORDER_STATE in ('11', '12', '13', '14', '15', '17') AND ORDER_TYPE in ('03', '5Y') ) WHERE 1 = 1 AND QUERY_COLUMN like '%%' AND CREATE_DATE >= TO_DATE('2020-10-22', 'yyyy/MM/dd') AND CREATE_DATE < TO_DATE('2021-04-22', 'yyyy/MM/dd') +1 2021-04-22 11:52:20 正常:11:52:20 pool-1-thread-1 INFO [root] SQL TIME:13105ms! 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] 完成报表计算 :13890ms! 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:1[12]<--->columnValue:export_ppm_purchase_payment_contractInfo1.cpt[java.lang.String] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:2[-6]<--->columnValue:0[java.lang.Short] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:3[12]<--->columnValue:__FIT__ : true[java.lang.Boolean], __LOCALE__ : zh_CN[java.util.Locale], __STREAMCLOSED__ : [java.lang.String], CONTRACTSTATE : %[java.lang.String], CREATE_EMP : %[java.lang.String], END_DATE : 2021-04-22[java.lang.String], FACTORYCODE : %[java.lang.String], FORMAT : excel[java.lang.String], OP : export[java.lang.String], ORDER_STATE : %[java.lang.String], QUERY_COLUMNS : [java.lang.String], REPORTLET : export_ppm_purchase_payment_contractInfo1.cpt[java.lang.String], REPORTNAME : export_ppm_purchase_payment_contractInfo1.cpt[java.lang.String], START_DATE : 2020-10-22[java.lang.String][java.lang.String] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:4[12]<--->columnValue:localhost[java.lang.String] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:5[12]<--->columnValue:未登录用户[java.lang.String] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:6[12]<--->columnValue:未知角色[java.lang.String] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:7[93]<--->columnValue:2021-04-22 11:52:21[java.util.Date] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:8[4]<--->columnValue:13891[java.lang.Long] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:9[-1]<--->columnValue:[ sql : SELECT * FROM (SELECT ORDER_ID, CREATE_EMP, CREATE_EMP_DESC, DEPT_ID, CREATE_DATE, CONTRACT_TYPE, CONTRACT_NAME, ORDER_STATE, ORDER_STATE_DESC, ORDER_CODE, FACTORY_CODE, FACTORY_CODE_DESC, FACTORY_FULL_NAME, FROM_CONTRACT_CODE, FACTORY_NAME, FLOW_ID, MODIFIED_EMP, MODIFIED_EMP_DESC, MODIFIED_DATE, PROJECT_ID, PROJECT_NAME, HIGH_LEVEL_ORDER_ID, SUPPLIERNUM, SUPPLIERNAME, CONTRACT_CODE, CONTRACT_COMPANY, CONTRACT_COMPANY_DESC, CONTRACT_MONEY_RMB, FEE_TYPE, FEE_TYPE_NAME, REMARK, PAYMENT_MONEY_RMB, IF_END_CONTRACT, CONTRACT_CONTENT, CONTRACT_MONEY, PAYMENT_MONEY, FIRST_SUPPLIER_MONEY, INVOICE_TYPE, INVOICE_TYPE_DESC, TAX_RATE, TAX_RATE_DESC, IN_MONEY_SUM, TRANSPORT_TYPE, TRANSPORT_TYPE_DESC, PAYMENT_TYPE, PAYMENT_TYPE_DESC, AFFIX_TO_DATE, FACT_FINISH_DATE, CONFIRM_SUPPLIER_ID, DELIVERY_DATE, DELIVERY_DAYS, OVERREACH_DAYS, UNIT_PRICE_CONTRACT, CURRENCY, CURRENCY_DESC, EXE_EMP_CODE, EXE_EMP_CODE_DESC, CONTRACT_FLAG, CONTRACT_FLAG_DESC, IN_ORDER_CODE, IN_ORDER_ID, TEC_EMP_CODE, TEC_EMP_CODE_DESC, STATE_COLOR, CORP_CONTRACT_CODE, SUPPLIER_LINKMAN, COMPANY_ADDRESS, RESPONSIBLE_PERSON, RESPONSIBLE_PERSON_DESC, COMPANY_TEL, COMPANY_FAX, FACTORY_EMP_CODE, FACTORY_TEL, FACTORY_MOBILE, FACTORY_ADDRESS, INVOICE_COMPANY_NAME, INVOICE_COMPANY_ADDRESS, SUPPLIER_BANK_NAME, COMPANY_BANK_NAME, SUPPLIER_ACCOUNT, COMPANY_ACCOUNT, SUPPLIER_TAX_NUM, COMPANY_TAX_NUM, SUPPLIER_TEL, INVOICE_COMPANY_TEL, INVOICE_COMPANY_POSTCODE, SUPPLIER_FAX, BUDGET_YEAR, BUDGET_CODE, IF_INCLUDE_TAX, IF_TRANS_FEE, IF_NO_INCLUDE, IF_END_PAY, EXCHANGE_RATE, CONTRACT_CODE_ALL, IF_SUPPLEMENT, MODE_FLAG, CONTRACT_TYPE_ALL, CONTRACT_TYPE_ALL_DESC, IF_UNITPRICE_CONTRACT, IF_HAVE_SECOND_SUPPLIER, F_HASZHAOTOUBIAO, F_ZHAOTOUBIAOURL, F_HASSHIQIAN, F_SHIQIANURL, IF_MAIN_CONTRACT, GHQ_VALUE, IF_MAIN_CONTRACT_DESC, MAIN_CONTRACT_ID, NEXT_LEVEL_CODE, MAIN_LEADER, MAIN_LEADER_DESC, IF_RECEIVABLES, ADJ_MONEY, TYPE_ID, TYPE_ID_DESC, RELATED_CONTRACT, MALL_NUM, FACTORY_ACCOUNT_NAME, FACTORY_INVOICE_ADDRESS, IF_PLAN_FLAG, QUERY_COLUMN, USE_TYPE, PERFORMANCE_BOND, PERFORMANCE_BOND_DATE, LINK_TEL, IF_MATERIAL_BUY, MAT_PAYMENT_CODE, IF_COMPARE_PRICE FROM V_MAT_PURCHASE_CONTRACT T WHERE CONTRACT_TYPE not in ('J', 'F') AND ORDER_STATE in ('11', '12', '13', '14', '15', '17') AND ORDER_TYPE in ('03', '5Y') ) WHERE 1 = 1 AND QUERY_COLUMN like '%%' AND CREATE_DATE >= TO_DATE('2020-10-22', 'yyyy/MM/dd') AND CREATE_DATE < TO_DATE('2021-04-22', 'yyyy/MM/dd') +1 ; rowcount : 1396 ; time : 2021-04-22 11:52:20 ;] [java.lang.String] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:10[2]<--->columnValue:6710400[java.lang.Long] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] columnIndex:11[12]<--->columnValue:{"Agent":"mozilla/5.0 (windows nt 6.1; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/88.0.4324.182 safari/537.36","Version":"537.36","BoxModel":true,"terminal":{},"Browser":"webkit"}[java.lang.String] 2021-04-22 11:52:21 正常:11:52:21 pool-1-thread-1 INFO [root] 页面已生成 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] 导出完毕 耗时:568毫秒 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] 关闭Session:54770 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:1[12]<--->columnValue:export_ppm_purchase_payment_contractInfo1.cpt[java.lang.String] 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:2[-6]<--->columnValue:10[java.lang.Short] 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:3[12]<--->columnValue:__LOCALE__ : zh_CN[java.util.Locale], __STREAMCLOSED__ : [java.lang.String], CONTRACTSTATE : %[java.lang.String], CREATE_EMP : %[java.lang.String], END_DATE : 2021-04-22[java.lang.String], FACTORYCODE : %[java.lang.String], FORMAT : excel[java.lang.String], OP : export[java.lang.String], ORDER_STATE : %[java.lang.String], QUERY_COLUMNS : [java.lang.String], REPORTLET : export_ppm_purchase_payment_contractInfo1.cpt[java.lang.String], REPORTNAME : export_ppm_purchase_payment_contractInfo1.cpt[java.lang.String], START_DATE : 2020-10-22[java.lang.String][java.lang.String] 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:4[12]<--->columnValue:localhost[java.lang.String] 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:5[12]<--->columnValue:未登录用户[java.lang.String] 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:6[12]<--->columnValue:未知角色[java.lang.String] 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:7[93]<--->columnValue:2021-04-22 11:52:22[java.util.Date] 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:8[4]<--->columnValue:568[java.lang.Long] 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:9[2]<--->columnValue:0[java.lang.Long] 2021-04-22 11:52:22 正常:11:52:22 pool-1-thread-1 INFO [root] columnIndex:10[12]<--->columnValue:{"Agent":"mozilla/5.0 (windows nt 6.1; win64; x64) applewebkit/537.36 (khtml, like gecko) chrome/88.0.4324.182 safari/537.36","Version":"537.36","BoxModel":true,"terminal":{},"Browser":"webkit"}[java.lang.String] 2021-04-22 11:52:29 正常:11:52:29 pool-1-thread-1 INFO [root] 关闭Session:54427 2021-04-22 11:53:18 正常:11:53:18 pool-1-thread-1 INFO [root] 关闭Session:27206 2021-04-22 11:57:22 正常:11:57:22 pool-1-thread-1 INFO [root] columnIndex:1[-1]<--->columnValue:{"840665474":4,"465995181":1,"315823103":6,"281291819":1}[java.lang.String] 2021-04-22 11:57:22 正常:11:57:22 pool-1-thread-1 INFO [root] columnIndex:2[93]<--->columnValue:2021-04-22 11:57:22[java.util.Date]