Ldc
2024-04-07 0652600959e5e3b5796fb6e8da129704ca95347a
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
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
/**
 * 公式编辑器
 * @author wangting
 * @date 2022-2-15
 */
layui.define(['layer','element','form','table','dynamicCondition' ,'tree'],function(exports){
    var webUtil = $webUtil;
    var Class = function(){
        this.MODELNAME = "formulaEditor";
        this.moduleKey = "formulaEditor";
        this.id = "formulaEditor";
        this.backPath =  configData.compatibility? path:configData.objectServicePath;
        this.getContent=function(){
            var that = this;
            var filter = "compuse_" + that.id;
            var html=[
                '<div class="easyui-layout UIContentLayout"  id="easyuiLayout_',filter,'" data-options="fit:true" style="display:block;overflow-y: hidden;">',
                '<div data-options="region:\'center\',split:true" style="border:0;">',
                    '<div id="easyuiLayoutCenter_',filter,'" class="easyui-layout" data-options="fit:true">',
                        '<div data-options="region:\'center\',split:true" title="公式内容" style="padding: 5px;">',
                            '<div>',
                                '<form id="form_' + filter + '" lay-filter="' + filter + '" class="layui-form" style="margin-top:5px" ></form>',
                                '<div layui-filter="toolbar_',filter,'" class="layui-btn-container layui-buttons" style="margin-left:110px">',
                                    // '<button class="layui-btn layui-btn-sm toolbar_',filter,'_verify">验证公式</button>',
                                    '<button class="layui-btn layui-btn-sm toolbar_',filter,'_chear">清空内容</button>',
                                    '<button class="layui-btn layui-btn-sm toolbar_',filter,'_add">&nbsp;确定&nbsp;</button>',
                                '</div>',
                            '</div>',
                        '</div>',
                        '<div data-options="region:\'east\',split:true" title="运算符" style="width:350px;padding: 2px 5px 5px 25px;">',
                            that.getOperatorHtml(),
                        '</div>',
                    '</div>',
                '</div>',
                '<div data-options="region:\'south\',split:true" title="公式选择" style="height:360px;">',
                    '<div id="easyuiLayoutSouth_',filter,'" class="easyui-layout" data-options="fit:true">',
                        '<div data-options="region:\'center\',split:true" style="border-bottom:0;border-left:0;border-top: 0;padding: 5px;">',
                            '<div style="">',
                                '<div class="layui-layout-border layui-tab" style="display:block;margin:0px;">',
                                    '<ul class="layui-tab-title tabTitle" lay-allowClose="false">',
                                        '<li class="layui-this">常用</li>',
                                        '<li>财务</li>',
                                        '<li>日期</li>',
                                        '<li>数学</li>',
                                        '<li>其他</li>',
                                    '</ul>',
                                    '<ul class="layui-tab-content tabContent">',
                                        '<li class="layui-tab-item formula-div layui-show">',
                                            that.getFormulaFaHtml(),
                                        '</li>',
                                        '<li class="layui-tab-item formula-div">',
                                            that.getFormulaSiHtml(),
                                        '</li>',
                                        '<li class="layui-tab-item formula-div">',
                                            that.getFormulaDateHtml(),
                                        '</li>',
                                        '<li class="layui-tab-item formula-div">',
                                            that.getFormulaMathHtml(),
                                        '</li>',
                                        '<li class="layui-tab-item formula-div">',
                                            that.getFormulaOtherHtml(),
                                        '</li>',
                                    '</ul>',
                                '</div>',
                            '</div>',
                        '</div>',
                        '<div data-options="region:\'east\',split:true" style="width:350px;border-bottom:0;border-right:0;border-top: 0;padding: 5px;">',
                            '<div style="">',
                                '<div class="layui-layout-border layui-tab" style="display:block;margin:0px;">',
                                    '<ul class="layui-tab-title tabTitle" lay-allowClose="false">',
                                        '<li class="layui-this">本场景变量</li>',
                                        '<li>系统变量</li>',
                                    '</ul>',
                                    '<ul class="layui-tab-content tabContent">',
                                        '<li class="layui-tab-item layui-show">',
                                            that.getThisVarHtml(),
                                        '</li>',
                                        '<li class="layui-tab-item formula-div">',
                                            that.getSysVarHtml(),
                                        '</li>',
                                    '</ul>',
                                '</div>',
                            '</div>',
                        '</div>',
                    '</div>',
                '</div>',
                '</div>'
            ]
            return html.join('');
        };
        this.getOperatorHtml = function(){
            var that=this;
            var filter ="compuse_" + that.id;
            var html=['<div style="">',
                    '<style type="text/css">',
                    '.operator_',filter,' .layui-btn{width:60px;}',
                    '</style>',
                    '<div layui-filter="operator_',filter,'" class="layui-btn-container layui-buttons operator_',filter,'" style="">',
                        '<button class="layui-btn layui-btn-sm">7</button>',
                        '<button class="layui-btn layui-btn-sm">8</button>',
                        '<button class="layui-btn layui-btn-sm">9</button>',
                        '<button class="layui-btn layui-btn-sm">/</button><br/>',
                        '<button class="layui-btn layui-btn-sm">4</button>',
                        '<button class="layui-btn layui-btn-sm">5</button>',
                        '<button class="layui-btn layui-btn-sm">6</button>',
                        '<button class="layui-btn layui-btn-sm">*</button><br/>',
                        '<button class="layui-btn layui-btn-sm">1</button>',
                        '<button class="layui-btn layui-btn-sm">2</button>',
                        '<button class="layui-btn layui-btn-sm">3</button>',
                        '<button class="layui-btn layui-btn-sm">-</button><br/>',
                        '<button class="layui-btn layui-btn-sm">0</button>',
                        '<button class="layui-btn layui-btn-sm">00</button>',
                        '<button class="layui-btn layui-btn-sm">.</button>',
                        '<button class="layui-btn layui-btn-sm">+</button><br/>',
                        '<button class="layui-btn layui-btn-sm">-></button>',
                        '<button class="layui-btn layui-btn-sm">==</button>',
                        '<button class="layui-btn layui-btn-sm">(</button>',
                        '<button class="layui-btn layui-btn-sm">)</button><br/>',
                        '<button class="layui-btn layui-btn-sm"><</button>',
                        '<button class="layui-btn layui-btn-sm">></button>',
                        '<button class="layui-btn layui-btn-sm"><=</button>',
                        '<button class="layui-btn layui-btn-sm">>=</button>',
                    '</div>',
                '</div>']
            return html.join('')
        }
        this.getFormulaMathHtml = function() {
            var that = this;
            var filter = "compuse_" + that.id;
            var html = ['<table lay-filter="formula-table-math">',
                '   <thead>',
                '    <tr><th lay-data="{field:\'id\', width:257}">公式</th><th lay-data="{field:\'name\', width:355}">描述</th></tr>',
                '   </thead>',
                '   <tbody>',
                '    <tr><td>abs(value)</td><td>求参数value的绝对值,value必须为数字格式</td></tr>',
                '    <tr><td>acos(value)</td><td>求参数value的反余弦,value必须为数字格式</td></tr>',
                '    <tr><td>asin(value)</td><td>求参数value的反正弦,value必须为数字格式</td></tr>',
                '    <tr><td>atan(value)</td><td>求参数value的反正切,value必须为数字格式</td></tr>',
                '    <tr><td>cbrt(value)</td><td>求参数value的立方根,value必须为数字格式</td></tr>',
                '    <tr><td>ceil(value)</td><td>返回不大于参数value的最小整数,例如ceil(1.7)就等于2,value必须为数字格式</td></tr>',
                '    <tr><td>cos(value)</td><td>求参数value的余弦值,value必须为数字格式</td></tr>',
                '    <tr><td>cosh(value)</td><td>求参数value的双曲余弦值,value必须为数字格式</td></tr>',
                '    <tr><td>exp(n)</td><td>欧拉数 e 的n次幂,n必须为数字格式</td></tr>',
                '    <tr><td>expm1(n)</td><td>欧拉数 e 的n次幂减1,n必须为数字格式</td></tr>',
                '    <tr><td>floor(n)</td><td>返回不小于参数value的最大整数,例如floor(1.7)等于1,n必须为数字格式</td></tr>',
                '    <tr><td>log(value)</td><td>自然对数,value必须为数字格式</td></tr>',
                '    <tr><td>log10(value)</td><td>计算底数为 10 的对数,value必须为数字格式</td></tr>',
                '    <tr><td>log1p(value)</td><td>返回参数与 1 之和的自然对数,value必须为数字格式</td></tr>',
                '    <tr><td>random()</td><td>返回一个伪随机数,该值大于等于 0.0 且小于 1.0</td></tr>',
                '    <tr><td>rint(value)</td><td>返回其值最接近参数并且是整数的 double 值。如果两个整数的 double 值都同样接近,那么结果取偶数。特殊情况是:如果参数值是整数,那么结果就是该参数。如果参数是 NaN 或无穷大或正零或负零,那么结果与参数相同</td></tr>',
                '    <tr><td>round(value)</td><td>四舍五入取整数</td></tr>',
                '    <tr><td>signum(value)</td><td>符号函数;如果参数为 0,则返回 0;如果参数大于 0, 则返回 1.0;如果参数小于 0,则返回 -1.0</td></tr>',
                '    <tr><td>sin(value)</td><td>求参数value的正弦值,value必须为数字格式</td></tr>',
                '    <tr><td>sinh(value)</td><td>求参数value的双曲正弦值,value必须为数字格式</td></tr>',
                '    <tr><td>tan(value)</td><td>求参数value的正切值,value必须为数字格式</td></tr>',
                '    <tr><td>tanh(value)</td><td>求参数value的双曲正切值,value必须为数字格式</td></tr>',
                '    <tr><td>max(v1,v2)</td><td>求两个数中的较大的值,v1,v2都必须为数字格式,例如max(3.2,3)就等于3.2</td></tr>',
                '    <tr><td>min(v1,v2)</td><td>求两个数中的较小的值,v1,v2都必须为数字格式,例如max(3.2,3)就等于3</td></tr>',
                '    <tr><td>sqrt(value)</td><td>求平方根</td></tr>',
                '   </tbody>',
                '</table>']
            return html.join('')
        }
        this.getFormulaSiHtml = function() {
            var that = this;
            var filter = "compuse_" + that.id;
            var html = ['<table lay-filter="formula-table-si">',
                '   <thead>',
                '    <tr><th lay-data="{field:\'id\', width:257}">公式</th><th lay-data="{field:\'name\', width:355}">描述</th></tr>',
                '   </thead>',
                '   <tbody>',
                '    <tr><td>toChinese(value)</td><td>将阿拉伯数字转为为汉字大写方式</td></tr>',
                '    <tr><td>getChineseCurrency(value)</td><td>将阿拉伯数字转为为汉字金额大写方式,与tochiness的区别是这个会显示元、角、分</td></tr>',
                '    <tr><td>setThmark(value)</td><td>为参数value设置千分位</td></tr>',
                '   </tbody>',
                '</table>']
            return html.join('')
        }
        this.getFormulaDateHtml = function() {
            var that = this;
            var filter = "compuse_" + that.id;
            var html = ['<table lay-filter="formula-table-date">',
                '   <thead>',
                '    <tr><th lay-data="{field:\'id\', width:257}">公式</th><th lay-data="{field:\'name\', width:355}">描述</th></tr>',
                '   </thead>',
                '   <tbody>',
                '    <tr><td>compareDate(d1,d2)</td><td>对比参数d1,d2的大小。d1,d2为yyyy-MM-dd格式的日期字符串</td></tr>',
                '    <tr><td>nowDate()</td><td>获取当前日期</td></tr>',
                '    <tr><td>chinaDate(d1)</td><td>将时间转换为农历,d1是yyyy-MM-dd格式的日期字符串</td></tr>',
                '    <tr><td>dateAdd(d1,count)</td><td>在d1的基础上添加count天,d1为yyyy-MM-dd HH:mm:ss格式的时间字符串</td></tr>',
                '    <tr><td>dateBalanceYear(sourceDate,targetDate,false)</td><td>计算相差的年份,比如计算年龄,targetDate为""表示当前时间,第三个参数为true表示有多余的月份或者天数时,就加1;</td></tr>',
                '    <tr><td>dateBalanceDay(sourceDate,targetDate)</td><td>计算相差的天数,targetDate为""表示当前时间</td></tr>',
                '    <tr><td>dateformat(d1,format)</td><td>将当前的日期(时间)字符串转为指定的字符串,如果format的内容有空格,请使用&代替</td></tr>',
                '    <tr><td>nowDatetime()</td><td>获取当前日期和时间。格式为yyyy-MM-dd HH:mm:ss</td></tr>',
                '    <tr><td>dayOf(d1)</td><td>获取格式为yyyy-MM-dd的日期的天数</td></tr>',
                '    <tr><td>nowMon()</td><td>获取当前的月份,格式为MM</td></tr>',
                '    <tr><td>monOf(d1)</td><td>获取日期d1的月份数</td></tr>',
                '    <tr><td>nowTime()</td><td>获取当前时间,格式为HH:mm:ss</td></tr>',
                '    <tr><td>nowYear()</td><td>获取年份,格式为yyyy</td></tr>',
                '    <tr><td>yearOf()</td><td>获取时间d1的年份</td></tr>',
                '   </tbody>',
                '</table>']
            return html.join('')
        }
        this.getFormulaFaHtml = function() {
            var that = this;
            var filter = "compuse_" + that.id;
            var html = ['<table lay-filter="formula-table-fa">',
                '   <thead>',
                '    <tr><th lay-data="{field:\'id\', width:297}">公式</th><th lay-data="{field:\'name\', width:315}">描述</th></tr>',
                '   </thead>',
                '   <tbody>',
                '    <tr><td>if(compare,trueResult,falseResult)</td><td>如果compare的表达式为true,则执行trueResult的表达式,否则执行flaseResult.例如if(3>2,2*(3+2),3/(2-4)),值等于10</td></tr>',
                '    <tr><td>sum(douber1,douber2)</td><td>两个格式为douber的参数求和</td></tr>',
                '    <tr><td>sub(douber1,douber2)</td><td>格式为douber的参数douber1减去格式为douber的参数douber2</td></tr>',
                '    <tr><td>mul(douber1,douber2)</td><td>两个格式为douber的参数相乘</td></tr>',
                '    <tr><td>div(douber1,douber2)</td><td>格式为douber的参数douber1除以格式为douber的参数douber2.当douber2等于0的时候,返回0;如果除不尽的时候保留10位小数</td></tr>',
                '    <tr><td>mod(int,int)</td><td>求余数</td></tr>',
                '    <tr><td>toInt(string)</td><td>转换为int格式</td></tr>',
                '    <tr><td>doubleRound(string,count)</td><td>处理douber的小数位数,count表示小数位数</td></tr>',
                '    <tr><td>zeroIfNull(value)</td><td>如果参数的值为null或者"",将返回0</td></tr>',
                '    <tr><td>endsWith(string,str1)</td><td>字符串string是不是以str1结尾</td></tr>',
                '    <tr><td>startsWith(string,str1)</td><td>字符串string是否以str1开头</td></tr>',
                '    <tr><td>charAt(string,index)</td><td>获取字符串string中第index位置的字符,如果长度小于index,则返回"";</td></tr>',
                '    <tr><td>equalsIgnoreCase(str1,str2)</td><td>字符串str1和字符串str2是否相等</td></tr>',
                '    <tr><td>indexOf(str1,str2)</td><td>字符串str2在字符串str1中首次出现的位置</td></tr>',
                '    <tr><td>isEmpty(str1)</td><td>参数str1是否为空,其中null这个字符串也表示为空</td></tr>',
                '    <tr><td>lastIndexOf(str1,str2)</td><td>字符串str2在字符串str1中最后出现的位置</td></tr>',
                '    <tr><td>leftStr(str1,index)</td><td>获取index位置左侧的所有字符</td></tr>',
                '    <tr><td>rightStr(str1,str2)</td><td>获取index位置右侧的所有字符</td></tr>',
                '    <tr><td>length(str1)</td><td>参数str1的长度</td></tr>',
                '    <tr><td>mid(str1,start,end)</td><td>获取str1的从start到end直接的字符串,出现异常时返回""</td></tr>',
                '    <tr><td>tolowercase(str1)</td><td>将字符串str1转为小写</td></tr>',
                '    <tr><td>touppercase(str1)</td><td>将字符串str1转为大写</td></tr>',
                '    <tr><td>trimzero(str1)</td><td>去除字符串str1中的0</td></tr>',
                '    <tr><td>MD5(str1)</td><td>将字符串进行MD5加密</td></tr>',
                // '    <tr><td>getValueByMethod(serviceName,method,paramJsonString)</td><td>从方法中获取值</td></tr>',
                '   </tbody>',
                '</table>']
            return html.join('')
        }
        this.getFormulaOtherHtml = function() {
            var that = this;
            var filter = "compuse_" + that.id;
            var html = ['<table lay-filter="formula-table-other">',
                '   <thead>',
                '    <tr><th lay-data="{field:\'id\', width:395}">公式</th><th lay-data="{field:\'name\', width:235}">描述</th></tr>',
                '   </thead>',
                '   <tbody>',
                '    <tr><td>getcolvalue(servername,tablename,fieldname,pkField,pkValue)</td><td>查询servername中tablename数据库表中fieldname字段的值,pkfield表示主键的字段名称,pkValue表示主键的值,serverName现在默认为localServer</td></tr>',
                '   </tbody>',
                '</table>']
            return html.join('')
        }
        this.getSysVarHtml = function() {
            var that = this;
            var filter = "compuse_" + that.id;
            var html = ['<table lay-filter="sysvar-table">',
                '   <thead>',
                '    <tr><th lay-data="{field:\'id\', width:170}">变量</th><th lay-data="{field:\'name\', width:140}">描述</th></tr>',
                '   </thead>',
                '   <tbody>',
                '    <tr><td>#CURRENTUSER.OID#</td><td>当前用户的主键</td></tr>',
                '    <tr><td>#CURRENTUSER.ID#</td><td>当前用户的账户</td></tr>',
                '    <tr><td>#CURRENTTIME#</td><td>当前时间</td></tr>',
                '    <tr><td>#CURRENTDATE#</td><td>当前日期</td></tr>',
                '    <tr><td>#CURRENTDATETIME#</td><td>当前日期时间</td></tr>',
                '    <tr><td>#CURRENTUSER_NAME#</td><td>当前用户的姓名</td></tr>',
                '    <tr><td>#CURRENTUSER.SECRETGRADE#</td><td>当前用户密级</td></tr>',
                '    <tr><td>#CURRENTUSER.IPSECRET#</td><td>当前用户的IP密级</td></tr>',
                '    <tr><td>#CURRENTUSER.BUSINESSUNIT#</td><td>当前用户所属业务单元</td></tr>',
                '    <tr><td>#CURRENTUSER.BUSINESSUNITNAME#</td><td>当前用户所属业务单元名称</td></tr>',
                '    <tr><td>#CURRENTUSER.GROUPOID#</td><td>当前用户的部门主键</td></tr>',
                '    <tr><td>#CURRENTUSER.GROUPNAME#</td><td>当前用户所属部门名称</td></tr>',
                '    <tr><td>#CURRENTUSER.EMAIL#</td><td>当前用户邮件地址</td></tr>',
                '    <tr><td>#CURRENTUSER.ROLENAME#</td><td>当前用户所属角色名称</td></tr>',
                '   </tbody>',
                '</table>']
            return html.join('')
        }
        this.getThisVarHtml = function() {
            var that = this;
            var html = ['<table lay-filter="thisvar-table">',
                '   <thead>',
                '    <tr><th lay-data="{field:\'id\', width:170}">变量</th><th lay-data="{field:\'name\', width:140}">描述</th></tr>',
                '   </thead>',
                '   <tbody>',
                '   </tbody>',
                '</table>']
            return html.join('')
        }
        this.init=function(){
        };
 
        this.showReferDialog=function (options){
            var that=this;
            var form = layui.form;
            var table = layui.table;
            if(!options){
                options={}
            }
            if(options.id){
                that.id=options.id
            }
            var target = options.target;
            var filter ="compuse_" + that.id;
            var compuseIndex =webUtil.dialog({
                title:'公式编辑框',
                content:that.getContent(),
                resizing:function(layero){
                    form.doResize(filter);
                },
                success:function(layero,layerIndex,classP) {
                    var easyuiLayout = $('#easyuiLayout_' + filter)
                    easyuiLayout.css({height: 600, width: 1000})
                    easyuiLayout.parent().parent().css({margin: '5px'})
                    $('#easyuiLayoutCenter_' + filter).layout()
                    $('#easyuiLayoutSouth_' + filter).layout()
                    easyuiLayout.layout();
                    form.addItems(filter, [{
                            field: 'formulacontext',
                            title: '公式内容',
                            required: true,
                            type: 'textarea',
                            textWidth: 500,
                            textStyle:'height:120px;'
                        }],
                        function () {
                            form.setValues({formulacontext: options.value}, filter)
                            webUtil.relocationOpen(classP)
                        }, {}, {labelWidth: 110});
                    var tableOptions={
                        limit:-1,
                        height:255,
                        done:function(res,cur,total) {
                            $('.formula-div .layui-table-header').hide();
                            $('.formula-div .layui-table-body').height(253)
                        },
                        rowDBLClick:function (thisTableFilter, record) {
                            var formulacontext=form.getValues(filter).formulacontext;
                            formulacontext+=record.id
                            form.setValues({formulacontext:formulacontext},filter);
                        }
                    }
                    //数学公式
                    table.init('formula-table-math', tableOptions);
                    //财务公式
                    table.init('formula-table-si', tableOptions);
                    //日期公式
                    table.init('formula-table-date', tableOptions);
                    //常用公式
                    table.init('formula-table-fa', tableOptions);
                    //其它公式
                    table.init('formula-table-other', tableOptions);
                    //系统变量
                    table.init('sysvar-table', tableOptions);
                    //本场景变量
                    if(options.currentVars){
                        //说明传递了
                        var thisVarOptions=$.extend(tableOptions,{data:options.currentVars})
                        table.init('thisvar-table', thisVarOptions);
                    }else if(options.useFormKey && options.textFormKey){
                        //获取使用的表单上的字段
                        var id = options.formValues[options.useFormKey];
                        var text = options.formValues[options.textFormKey];
                        var data = [{id:"${" + id + "}",name:text}];
                        var thisVarOptions = $.extend(tableOptions, {data: data})
                        table.init('thisvar-table', thisVarOptions);
                    }else if(options.currentVarsUrl){
                        debugger;
                        var submitParams = options.currentVarsParams;
                        if(!submitParams){
                            submitParams = {};
                        }
                        var formKey = "${formValues.";
                        for(var key in submitParams){
                            var value = submitParams[key];
                            try {
                                if ($webUtil.isNotNull(value) && value.indexOf(formKey) > -1) {
                                    while (value.indexOf(formKey) > -1) {
                                        var temp = value.substring(value.lastIndexOf(formKey) + formKey.length, value.indexOf("}"));
                                        var thisKeyValue = options.formValues[temp];
                                        if (!thisKeyValue || thisKeyValue == null) {
                                            thisKeyValue = '';
                                        }
                                        value = value.replace(formKey + temp + "}", thisKeyValue);
                                    }
                                }
                            }catch (e){
 
                            }
                            submitParams[key] = value;
                        }
                        submitParams['page'] = 1;
                        submitParams['limit'] = -1;
                        $webUtil.ajax(options.currentVarsMethod||'get', options.currentVarsUrl, submitParams, function (res) {
                            layui.each(res.data, function (i, item) {
                                res.data[i].id = '${' + item.id + '}'
                            })
                            var thisVarOptions = $.extend(tableOptions, {data: res.data})
                            table.init('thisvar-table', thisVarOptions);
                        }, function (e, msg) {
                        }, that.backPath, true);
                    }
 
                    //运算符
                    $('.operator_'+filter+' .layui-btn').click(function (){
                        var formulacontext=form.getValues(filter).formulacontext;
                        formulacontext+=$(this).text()
                        form.setValues({formulacontext:formulacontext},filter);
                    })
 
                    function checkFormula(formulacontext){
                        if(formulacontext){
                            return true;
                        }else {
                            webUtil.showErrorMsg('验证不通过');
                            return false;
                        }
                        return true;
                    }
                    //验证公式
                    $('.toolbar_'+filter+'_verify').click(function (){
                        var formulacontext=form.getValues(filter).formulacontext;
                        if(checkFormula(formulacontext)) {
                            webUtil.showMsg('验证通过')
                        }
                    })
                    //清除内容
                    $('.toolbar_'+filter+'_chear').click(function (){
                        form.setValues({formulacontext:''},filter);
                    })
                    //确定
                    $('.toolbar_'+filter+'_add').click(function (){
                        var formulacontext=form.getValues(filter).formulacontext;
                        if(formulacontext=='' || checkFormula(formulacontext)) {
                            target.setValue(options.filter,options.name,formulacontext,formulacontext,true);
                            layer.close(compuseIndex)
                        }
                    })
                }
            });
        }
        this.refresh = function (buttonid,ele) {
        };
        this.ADVQUERY = function () {
            var that = this;
            if(!that.serinorQueryInstance) {
                var dynamicCondition = layui.dynamicCondition;
                $('[layui-filter="toolbar_' + that.id + '"]').append('<div  id="toolbar' + that.id + '" class="layui-inline"></div>');
                that.checkColumns();
                that.serinorQueryInstance = dynamicCondition.create({
                    fields: that.dataFields//查询字段
                    , tableId: "table_" + that.id//需要查询的表格
                    , type: "complex"  //type:"simple"/"complex"  查询的方法  暂时写死为 complex
                    , queryCallBack: function (requestData) {//查询之后的callback
 
                    }
                });
            }
            that.serinorQueryInstance.open();
        };
    };
    var cs = new Class();
    exports(cs.MODELNAME,cs);
});