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
{extend name="public:form" /}
{block name="body"}
<style type="text/css">
.layui-table-page{
text-align: right;
}
</style>
<div class="layui-fluid">
<div class="layui-row layui-col-space15">
<div class="layui-col-md12">
<div class="layui-card">
<div class="layui-card-body">
<form class="layui-form">
<div class="layui-input-inline layui-show-xs-block" style="width:130px;">
<select name="search_type" id="search_type" width='40px;' >
<option value="1" {if $search_type eq 1 } selected {/if}>站名</option>
<option value="2" {if $search_type eq 2 } selected {/if}>站号</option>
<option value="3" {if $search_type eq 3 } selected {/if}>项目编号</option>
<option value="4" {if $search_type eq 4 } selected {/if}>合同编号</option>
<option value="5" {if $search_type eq 5 } selected {/if}>支票号</option>
<option value="6" {if $search_type eq 6 } selected {/if}>缴费员</option>
<option value="7" {if $search_type eq 7 } selected {/if}>税点</option>
<option value="8" {if $search_type eq 8 } selected {/if}>回款次数</option>
<option value="9" {if $search_type eq 9 } selected {/if}>电表识别号</option>
</select>
</div>
<div class="layui-input-inline layui-show-xs-block">
<input type="text" name="search_text" style="width:150px;" placeholder="搜索内容" autocomplete="off" id="search_text" value="{$search_text}" class="layui-input">
</div>
<div class="layui-input-inline layui-show-xs-block" style="width:135px;">
<select name="settlement" id="settlement">
<option value="0" >和移动结算情况</option>
<option value="1" {if $settlement eq 1 } selected {/if} >已结算</option>
<option value="2" {if $settlement eq 2 } selected {/if} >未结算</option>
</select>
</div>
<div class="layui-input-inline layui-show-xs-block" style="width:135px;">
<select name="subordinate" id="subordinate">
<option value="0">所属移动分公司</option>
<option value="1" {if $subordinate eq 1 } selected {/if} >第一分公司</option>
<option value="2" {if $subordinate eq 2 } selected {/if}>第二分公司</option>
<option value="3" {if $subordinate eq 3 } selected {/if}>第三分公司</option>
<option value="4" {if $subordinate eq 4 } selected {/if}>大兴分公司</option>
<option value="5" {if $subordinate eq 5 } selected {/if}>城中铁塔</option>
<option value="6" {if $subordinate eq 6 } selected {/if}>城西铁塔</option>
<option value="7" {if $subordinate eq 7 } selected {/if}>大兴</option>
<option value="8" {if $subordinate eq 8 } selected {/if}>城东铁塔</option>
<option value="9" {if $subordinate eq 9 } selected {/if}>昌平</option>
<option value="10" {if $subordinate eq 10 } selected {/if}>昌平分公司</option>
<option value="11" {if $subordinate eq 11 } selected {/if}>顺义分公司</option>
<option value="12" {if $subordinate eq 12 } selected {/if}>怀柔</option>
<option value="13" {if $subordinate eq 13 } selected {/if}>顺义分公司-广厦</option>
<option value="14" {if $subordinate eq 14 } selected {/if}>顺义</option>
</select>
</div>
<div class="layui-input-inline layui-show-xs-block" style="width:135px;">
<select name="invoice_type" id="invoice_type">
<option value="0">发票类型</option>
<option value="1" {if $invoice_type eq 1 } selected {/if}>增值税专用发票</option>
<option value="2" {if $invoice_type eq 2 } selected {/if}>增值税普通发票</option>
<option value="3" {if $invoice_type eq 3 } selected {/if}>其它</option>
</select>
</div>
<div class="layui-input-inline layui-show-xs-block" >
<input type="text" class="layui-input" id="update_time" style="width:130px;" placeholder="点击选择更新日期" name="update_time" value="{$update_time}">
</div>
<div class="layui-input-inline layui-show-xs-block">
<input type="text" class="layui-input" id="income_time" style="width:130px;" placeholder="点击选择确收时间" name="income_time" value="{$income_time}">
</div>
<div class="layui-input-inline layui-show-xs-block">
<button class="layui-btn" >
<i class="layui-icon"></i></button>
</div>
</form>
</div>
<div class="layui-card-body">
<table class="layui-table" lay-data="{ url:'/meter_list', page:true, id:'idTest',where:{search_type:document.getElementById('search_type').value,search_text:document.getElementById('search_text').value,settlement:document.getElementById('settlement').value,subordinate:document.getElementById('subordinate').value,invoice_type:document.getElementById('invoice_type').value,update_time:document.getElementById('update_time').value,income_time:document.getElementById('income_time').value} }" lay-filter="demo">
<thead>
<tr>
<th lay-data="{field:'id', width:150}">ID</th>
<th lay-data="{field:'cheque_number', width:150}">支票号</th>
<th lay-data="{field:'payment_clerk', width:150}">缴费员</th>
<th lay-data="{field:'update_time', width:150}">更新日期</th>
<th lay-data="{field:'proj_number', width:150}">项目编号</th>
<th lay-data="{field:'payment_number', width:150}">缴费号</th>
<th lay-data="{field:'meters_number', width:150}">电表数</th>
<th lay-data="{field:'payments_umber', width:150}">缴费次数</th>
<th lay-data="{field:'settlement', width:150}">和移动结算情况</th>
<th lay-data="{field:'base_type', width:150}">基站类型</th>
<th lay-data="{field:'is_protocol', width:150}">是否协议价</th>
<th lay-data="{field:'region', width:150}">区域</th>
<th lay-data="{field:'network_identity', width:150}">网络标识</th>
<th lay-data="{field:'station_number', width:150}">站号</th>
<th lay-data="{field:'station_name', width:150}">站名</th>
<th lay-data="{field:'qrcode', width:150}">机房二维码</th>
<th lay-data="{field:'payment_cycle', width:150}">缴费周期</th>
<th lay-data="{field:'advance_pay_time', width:150}">预交费日期</th>
<th lay-data="{field:'last_number', width:150}">上期表数</th>
<th lay-data="{field:'current_number', width:150}">本期表数</th>
<th lay-data="{field:'report_electric', width:150}">实际报移动用电量</th>
<th lay-data="{field:'last_date', width:150}">上期查表日期</th>
<th lay-data="{field:'current_date', width:150}">本期查表日期</th>
<th lay-data="{field:'multiple', width:150}">倍率</th>
<th lay-data="{field:'unit_price', width:150}">抄表单单价</th>
<th lay-data="{field:'finance_unit', width:150}">财务单价</th>
<th lay-data="{field:'finance_pay', width:150}">实际从财务支出金额</th>
<th lay-data="{field:'electricone', width:150}">用电量(1.05元/度)</th>
<th lay-data="{field:'度)electrictwo', width:150}">用电量(1.09元/度)</th>
<th lay-data="{field:'electricthree', width:150}">用电量(1.123元/度)</th>
<th lay-data="{field:'electricity_consumption', width:150}">用电量(协议价)</th>
<th lay-data="{field:'agreed_price', width:150}">协议价</th>
<th lay-data="{field:'settlement_amount', width:150}">移动结算金额</th>
<th lay-data="{field:'back_number', width:150}">回款次数</th>
<th lay-data="{field:'gross_profit', width:150}">毛利</th>
<th lay-data="{field:'meter_type', width:150}">电表类型</th>
<th lay-data="{field:'meter_number', width:150}">电表识别号</th>
<th lay-data="{field:'meter_problem', width:150}">电表问题</th>
<th lay-data="{field:'base_problem', width:150}">基站问题</th>
<th lay-data="{field:'address', width:150}">地址</th>
<th lay-data="{field:'subordinate', width:150}">所属移动分公司</th>
<th lay-data="{field:'rental_name', width:150}">出租单位名称</th>
<th lay-data="{field:'contacts', width:150}">甲方联系人</th>
<th lay-data="{field:'receiving_unit', width:150}">实际收款单位</th>
<th lay-data="{field:'contact_information', width:150}">联系方式</th>
<th lay-data="{field:'room_location', width:150}">机房位置</th>
<th lay-data="{field:'property_location', width:150}">物业位置</th>
<th lay-data="{field:'remarks', width:150}">备注</th>
<th lay-data="{field:'apply_contract_amount', width:150}">申请确认合同额</th>
<th lay-data="{field:'settlement_date', width:150}">结算日期</th>
<th lay-data="{field:'confirmation_time', width:150}">确认合同时间</th>
<th lay-data="{field:'income_time', width:150}">确认收入时间</th>
<th lay-data="{field:'is_invoice', width:150}">是否有发票</th>
<th lay-data="{field:'contract_number', width:150}">合同编号</th>
<th lay-data="{field:'invoice_type', width:150}">发票类型</th>
<th lay-data="{field:'tax_point', width:150}">税点</th>
<th lay-data="{fixed: 'right', width:200, align:'center', toolbar: '#barDemo'}">操作</th>
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
</div>
</body>
<script type="text/html" id="barDemo">
{{# if(d.identity == 5){ }}
{{# if(d.income_time ){ }}
<a class="layui-btn layui-btn-xs layui-btn-disabled" >已确收</a>
{{# }else{ }}
{{# if(d.status == 2){ }}
<a class="layui-btn layui-btn-xs" lay-event="queshou">确收</a>
<a class="layui-btn layui-btn-danger layui-btn-xs" lay-event="bohui" >驳回</a>
{{# }else { }}
<a class="layui-btn layui-btn-xs layui-btn-disabled"" >暂无操作</a>
{{# } }}
{{# } }}
{{# }else if(d.identity == 1 || d.identity == 2){ }}
{{# if(d.income_time ){ }}
<a class="layui-btn layui-btn-xs layui-btn-disabled" >已确收</a>
{{# }else{ }}
{{# if(d.status == 0){ }}
<a class="layui-btn layui-btn-xs" onclick="xadmin.open('电费信息','/meter_edit?id={{d.id}}')">编辑</a>
<a class="layui-btn layui-btn-xs" lay-event="edit" >申请确收</a>
{{# }else { }}
<a class="layui-btn layui-btn-xs layui-btn-disabled"" lay-event="edit" >正在确收</a>
{{# } }}
{{# } }}
{{# } }}
</script>
<script>
layui.use(['table','laydate'], function(){
var table = layui.table;
var laydate = layui.laydate;
//日期范围
laydate.render({
elem: '#update_time'
,range: true
,theme: 'molv'
});
laydate.render({
elem: '#income_time'
,range: true
,theme: 'molv'
});
//监听表格复选框选择
table.on('checkbox(demo)', function(obj){
console.log(obj)
});
//监听工具条
table.on('tool(demo)', function(obj){
var data = obj.data;
if(obj.event === 'detail'){
layer.msg('ID:'+ data.id + ' 的查看操作');
} else if(obj.event === 'del'){
layer.confirm('真的删除行么', function(index){
obj.del();
layer.close(index);
});
} else if(obj.event === 'edit'){
layer.open({
content: "真的提交申请确收吗",
btn: ['确定'],
icon: 6,
yes: function() {
$.ajax({
url: '/editque',
method: "POST",
data: {id:JSON.stringify(data.id)},
success: function (data) {
if (data.status == 1) {
layer.msg(data.message,{icon: 6,time: 1000 },
function(){
window.location.href="/meter_list"
});
} else {
layer.msg(data.message,{icon: 5,time: 1000 })
}
}
});
}
});
}else if(obj.event === 'queshou'){
layer.open({
content: "真的提交确收吗",
btn: ['确定'],
icon: 6,
yes: function() {
$.ajax({
url: '/editqueshou',
method: "POST",
data: {id:JSON.stringify(data.id)},
success: function (data) {
if (data.status == 1) {
layer.msg(data.message,{icon: 6,time: 1000 },
function(){
window.location.href="/meter_list"
});
} else {
layer.msg(data.message,{icon: 5,time: 1000 })
}
}
});
}
});
}else if(obj.event === 'bohui'){
layer.open({
content: "真的提交驳回吗",
btn: ['确定'],
icon: 5,
yes: function() {
$.ajax({
url: '/editbohui',
method: "POST",
data: {id:JSON.stringify(data.id)},
success: function (data) {
if (data.status == 1) {
layer.msg(data.message,{icon: 6,time: 1000 },
function(){
window.location.href="/meter_list"
});
} else {
layer.msg(data.message,{icon: 5,time: 1000 })
}
}
});
}
});
}
});
var $ = layui.$, active = {
getCheckData: function(){ //获取选中数据
var checkStatus = table.checkStatus('idTest')
,data = checkStatus.data;
layer.alert(JSON.stringify(data));
}
,getCheckLength: function(){ //获取选中数目
var checkStatus = table.checkStatus('idTest')
,data = checkStatus.data;
layer.msg('选中了:'+ data.length + ' 个');
}
,isAll: function(){ //验证是否全选
var checkStatus = table.checkStatus('idTest');
layer.msg(checkStatus.isAll ? '全选': '未全选')
}
};
$('.demoTable .layui-btn').on('click', function(){
var type = $(this).data('type');
active[type] ? active[type].call(this) : '';
});
});
</script>
{/block}