test.txt
12.9 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.18.1</version>
<configuration>
<skipTests>true</skipTests>
</configuration>
</plugin>
currentpolicyaddress
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
select
rpsi.POLICY_NO policyNo,rpsi.service_no servicerNo,po.BRANCH_CODE branchCode,si.EMP_NAME empName,
po.CHANNEL_TYPE AS channelType,bi.BRANCH_NAME branchName,ppi.PREM_DUE_DATE premDate,ctl.DESCRIPTION AS description
from policy po
inner join rn_policy_service_info rpsi on rpsi.policy_no=po.policy_no
inner join branch_code_relation bcr on bcr.branch_code=po.branch_code
inner join policy_prem_info ppi on ppi.policy_no =po.policy_no
left join staff_info si on si.emp_no = rpsi.service_no
inner join CHANNEL_TYPE_TBL CTL on CTL.CHANNEL_TYPE = PO.CHANNEL_TYPE
inner join branch_info bi on bi.branch_code = po.branch_code
left join gras_assign_failed_record gfr on gfr.policy_no=rpsi.policy_no
where
bcr.relative_grade>-1
and gfr.policy_no is null
and bcr.relative_branch_code = '864200'
AND ppi.PREM_DUE_DATE >= "TO_DATE"('2018-12-01 00:00:00','yyyy-MM-dd hh24:mi:ss')
AND ppi.PREM_DUE_DATE <= "TO_DATE"('2018-12-30 00:00:00','yyyy-MM-dd hh24:mi:ss')
and po.CHANNEL_TYPE in('01','02','03','04','05','07','09');
select
count(*)
from policy po
inner join rn_policy_service_info rpsi on rpsi.policy_no=po.policy_no
inner join branch_code_relation bcr on bcr.branch_code=po.branch_code
inner join policy_product pp on pp.policy_no=po.policy_no and pp.prod_seq='1'
inner join policy_prem_info ppi on ppi.policy_no =po.policy_no
inner join staff_info si on si.emp_no = rpsi.service_no
inner join CHANNEL_TYPE_TBL CTL on CTL.CHANNEL_TYPE = PO.CHANNEL_TYPE
inner join branch_info bi on bi.branch_code = po.branch_code
left join gras_assign_failed_record gfr on gfr.policy_no=rpsi.policy_no
where
bcr.relative_grade>-1
and gfr.policy_no is null
and ppi.prem_status='1'
and ppi.prem_source='1'
and pp.prod_seq='1'
and(rpsi.assign_rule IN ('01', '02') OR rpsi.assign_rule IS NULL)
and pp.product_code not in('CBAN_TN1','CBAN_UN1','CBAN_VN1')
and bcr.relative_branch_code = '865104'
AND ppi.PREM_DUE_DATE >= "TO_DATE"('2018-12-01 00:00:00','yyyy-MM-dd hh24:mi:ss')
AND ppi.PREM_DUE_DATE < "TO_DATE"('2019-01-01 00:00:00','yyyy-MM-dd hh24:mi:ss')
and po.CHANNEL_TYPE in('01','02','03','04','05','07','09');
P000000001352005-H000000000005697
from policy po
inner join rn_policy_service_info rpsi on rpsi.policy_no=po.policy_no
inner join policy_product pp on pp.policy_no=po.policy_no and pp.prod_seq='1'
inner join policy_prem_info ppi on ppi.policy_no =po.policy_no
inner join branch_code_relation bcr on bcr.branch_code=po.branch_code
inner join CHANNEL_TYPE_TBL CTL on CTL.CHANNEL_TYPE = PO.CHANNEL_TYPE
--inner join staff_info si on si.emp_no = rpsi.service_no
inner join branch_info bi on bi.branch_code = po.branch_code
left join gras_assign_failed_record gfr on gfr.policy_no=rpsi.policy_no and gfr.is_valid='Y'
where
bcr.relative_grade>-1
and bcr.relative_branch_code = '864200'
and gfr.policy_no is null
and ppi.prem_status='1'
and ppi.prem_source='1'
and pp.prod_seq='1'
and rpsi.ASSIGN_BRANCH_CODE is null
and(rpsi.assign_rule IN ('01', '02') OR rpsi.assign_rule IS NULL)
and pp.product_code not in('CBAN_TN1','CBAN_UN1','CBAN_VN1')
and ppi.PREM_DUE_DATE >= "TO_DATE"('2018-12-01 00:00:00','yyyy-MM-dd hh24:mi:ss')
AND ppi.PREM_DUE_DATE < "TO_DATE"('2019-01-01 00:00:00','yyyy-MM-dd hh24:mi:ss')
AND po.CHANNEL_TYPE not in('06','08','11');
分单结果批量调整满足条件
1.失效件：
（1）保单进入失效月次月至失效日起两年内；
（2）失效原因满足下列其中一项：
保全：未在规定宽限期内缴纳续期保费；
保全：借款本金和利息和超过保单现金价值；
保全：保单的现金价值不足以垫缴保费；
（3）保单渠道与收展服务人员岗位相匹配。
2.缓缴件
（1）保单有效状态的长险（万能险）；
（2）保单渠道与收展服务人员岗位相匹配。
自定义查询保单落图：gras/falling/queryPageData----》FallingMapService.queryPageDatas()
获取分区区域列表：gras/branchGeo/getBranchGeoInfoPageByCode----》grasBranchGeoService.selectBranchGeoInfoPageByCode()
获取区域点面数据：gras/branch/getBranchGeoByBranchCode---》branchInfoService.getBranchGeoByBranchCode()
根据机构代码获取渠道：/gras/branchRegion.getBranchRegion--》grasBranchGeoService.getBranchRegion()
根据机构号查询保单:/gras/resultCheck/selectByBranchCode----》ResultCheckService.selectByBranchCode()
根据传入条件查询保单信息:/gras/resultCheck/queryPolicy--》ResultCheckService.queryPolicy()
FallingMapService.outInResult()
FallingMapService.resultput()
ElasticSearchServiceImpl类
ElasticSearchPolicyServiceImpl类
/gras/menu/updateMenus---》menuService.updateByRoleIdAndMenus()
/gras/resultCheck/getDatasExportToExcel----》ResultCheckService.selectForExcel()
批量调整：gras/resultCheck/adjustEmp----》ResultCheckService.adjustEmp
1：目前系统中删除操作涉及的表有：GRAS_BRANCH_GEO、GRAS_BRANCH_STYLE、GRAS_AREA_STAFF、GRAS_SYS_ROLE_MENU、GRAS_SYS_MENU、GRAS_ASSIGN_FAILED_RECORD
内部错误: "org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'list' not found. Available parameters are
[isValid, policyList, param1, param2]↵org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter 'list' not found.
Available parameters are [isValid, policyList, param1, param2]↵ at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible
(MyBatisExceptionTranslator.java:77)↵ at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)↵
at com.sun.proxy.$Proxy64.update(Unknown Source)↵ at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)↵
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)↵ at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)↵
at com.sun.proxy.$Proxy96.updateList(Unknown Source)↵ at com.funde.gras.oracle.service.impl.OracleGrasAssignFailedRecordServiceImpl.updateList
(OracleGrasAssignFailedRecordServiceImpl.java:57)↵ at com.funde.gras.oracle.service.impl.OracleGrasAssignFailedRecordServiceImpl$$FastClassBySpringCGLIB$$cb0d0382.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)↵
.at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)↵ at org.springframework.aop.framework.ReflectiveMethodInvocation
.proceed(ReflectiveMethodInvocation.java:157)↵ at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)↵
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282)
↵ at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
↵ at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)↵
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)↵
at com.funde.gras.oracle.service.impl.OracleGrasAssignFailedRecordServiceImpl$$EnhancerBySpringCGLIB$$84b75c9e.updateList(<generated>)
↵ at com.alibaba.dubbo.common.bytecode.Wrapper15.invokeMethod(Wrapper15.java)↵
at com.alibaba.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:46)
↵ at com.alibaba.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:72)
↵ at com.alibaba.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:53)↵
at com.alibaba.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:64)
↵ at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
↵ at com.alibaba.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:75)↵
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
↵ at com.alibaba.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:42)↵
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
↵ at com.alibaba.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:78)
↵ at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
↵ at com.alibaba.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:60)↵
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)↵
at com.alibaba.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:112)↵
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)
↵ at com.alibaba.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:38)↵
at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)↵
at com.alibaba.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:38)↵ at com.alibaba.dubbo.rpc.protocol.ProtocolFilterWrapper$1.invoke(ProtocolFilterWrapper.java:91)↵
at com.alibaba.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:108)↵ at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:84)
↵ at com.alibaba.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:170)↵
at com.alibaba.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:52)↵ at com.alibaba.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:82)↵
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)↵ at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)↵
at java.lang.Thread.run(Thread.java:748)↵Caused by: org.apache.ibatis.binding.BindingException: Parameter 'list' not found. Available parameters are [isValid, policyList,
param1, param2]↵ at org.apache.ibatis.binding.MapperMethod$ParamMap.get(MapperMethod.java:202)↵ at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextAccessor
.getProperty(DynamicContext.java:115)↵ at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:2671)↵ at org.apache.ibatis.ognl.ASTProperty.getValueBody(A
STProperty.java:114)↵ at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212)↵ at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258)↵
at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:470)↵ at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:434)↵ at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(
OgnlCache.java:44)↵ at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateIterable(ExpressionEvaluator.java:43)↵ at org.apache.ibatis.scripting.xmltags.For
EachSqlNode.apply(ForEachSqlNode.java:55)↵ at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:33)↵ at org.apache.ibatis.scripting.xmltags.Dynamic
SqlSource.getBoundSql(DynamicSqlSource.java:41)↵ at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:292)↵ at org.apache.ibatis.executor.statemen
t.BaseStatementHandler.<init>(BaseStatementHandler.java:64)↵ at org.apache.ibatis.executor.statement.PreparedStatementHandler.<init>(PreparedStatementHandler.java:40)↵ at
org.apache.ibatis.executor.statement.RoutingStatementHandler.<init>(RoutingStatementHandler.java:46)↵ at org.apache.ibatis.session.Configuration.newStatementHandler(Configu
ration.java:558)↵ at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:48)↵ at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)↵ at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)↵ at
sun.reflect.GeneratedMethodAccessor417.invoke(Unknown Source)↵ at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)↵ at java.lang.refle
ct.Method.invoke(Method.java:498)↵ at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)↵ ... 44 more↵"
]863605用户，调整保单号：P000000042641127，收展服务人员：H000000000005697，保单渠道为银代，收展服务人员岗位为银代收展专员