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
<?php
namespace app\em\model;
class Useage extends Base
{
protected $table = 'em_useage';
public function getLastDateAttr($val){
return date('Y-m-d',$val);
}
public function setLastDateAttr($val){
return strtotime($val);
}
public function getCurrentDateAttr($val){
return date('Y-m-d',$val);
}
public function setCurrentDateAttr($val){
return strtotime($val);
}
//首页列表
public function getList($page = 0){
$config = !empty($config) ?: [
'list_rows'=>30,
'page'=> $page,
'type' => '\app\extend\PageLayUi',
'var_page' => 'page'
];
$data = self::alias('ue')
->field('ue.*')
->field('station.station_name')
->field('em.em_numb')
->leftJoin(['em'],'em.id=ue.em_id')
->leftJoin(['station_info'=>'station'],'station.station_id=em.station_id')
->paginate($config);
return $data;
}
//首页列表+search
public function getCopyList($map,$Nowpage,$limits){
$data = self::alias('ue')
->field('ue.*')
->field('station.station_name')
->field('em.em_numb,em.rate')
->join(['em'],'em.id=ue.em_id')
->join(['station_info'=>'station'],'station.station_id=em.station_id')
->where($map)
->page($Nowpage, $limits)
->order('ue.id desc')
->select()
->toarray();
foreach ($data as $k => $v){
$data[$k]['repo_numb'] = round(round($v['current_sum_numb'] - $v['last_sum_numb'],2)*$v['rate'],2);
}
return $data;
}
public function getCopyListCount($map){
$data = self::alias('ue')
->field('ue.*')
->field('station.station_name')
->field('em.em_numb')
->leftJoin(['em'],'em.id=ue.em_id')
->leftJoin(['station_info'=>'station'],'station.station_id=em.station_id')
->where($map)
->count();
return $data;
}
//获取抄表单列表,并组合电表信息与电表规则信息
public function getListUseageInfo(){
$data = self::alias('ue')
->field('*')
->field('em.em_numb,em.em_type_id,em.rate')
->field('er.charge_type,er.pay_price,
er.cycle_start_time,er.cycle_amount,er.cycle_finish_time,
er.settle_price,er.settle_type,er.pricing_type
')
->leftJoin(['em'],'em.id=ue.em_id')
->leftJoin(['em_rule'=>'er'],'er.em_id=em.id')
->where('ue.status=1 and ue.photo_id!=""')
->select()
->toArray();
return $data;
}
public function getEmInfoByUseageId($useage_id){
$data = self::alias('ue')
->field('*')
->field('em.em_numb,em.em_type_id,em.rate')
->field('er.charge_type,er.pay_price,
er.cycle_start_time,er.cycle_amount,er.cycle_finish_time,
er.settle_price,er.settle_type,er.pricing_type
')
->leftJoin(['em'],'em.id=ue.em_id')
->leftJoin(['em_rule'=>'er'],'er.em_id=em.id')
->where('ue.status=1')
->where(['useage_id'=>$useage_id])
->find();
return $data;
}
public function photo(){
return $this->belongsTo('Receipt','photo_id','id');
}
public function em(){
return $this->belongsTo('Em','em_id','id');
}
}