Skip to content

Commit 3d7a491

Browse files
928255095928255095
committed
优化加入报表基础生成表
1 parent f0d0058 commit 3d7a491

14 files changed

Lines changed: 1061 additions & 206 deletions

‎java110-bean/src/main/java/com/java110/dto/report/ReportCarDto.java‎

Lines changed: 171 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,171 @@
1+
package com.java110.dto.report;
2+
3+
import com.java110.dto.PageDto;
4+
5+
import java.io.Serializable;
6+
7+
/**
8+
* @ClassName ReportRoomDto
9+
* @Description TODO
10+
* @Author wuxw
11+
* @Date 2020/10/15 22:20
12+
* @Version 1.0
13+
* add by wuxw 2020/10/15
14+
**/
15+
public class ReportCarDto extends PageDto implements Serializable {
16+
17+
private String carId;
18+
private String ownerId;
19+
private String carNum;
20+
private String carBrand;
21+
private String carType;
22+
private String carColor;
23+
private String ownerName;
24+
private String idCard;
25+
private String link;
26+
private String state;
27+
private String stateName;
28+
private String unitNum;
29+
private String num;
30+
private String psId;
31+
private String paId;
32+
private String areaNum;
33+
private String communityId;
34+
35+
36+
public String getCarId() {
37+
return carId;
38+
}
39+
40+
public void setCarId(String carId) {
41+
this.carId = carId;
42+
}
43+
44+
public String getOwnerId() {
45+
return ownerId;
46+
}
47+
48+
public void setOwnerId(String ownerId) {
49+
this.ownerId = ownerId;
50+
}
51+
52+
public String getCarNum() {
53+
return carNum;
54+
}
55+
56+
public void setCarNum(String carNum) {
57+
this.carNum = carNum;
58+
}
59+
60+
public String getCarBrand() {
61+
return carBrand;
62+
}
63+
64+
public void setCarBrand(String carBrand) {
65+
this.carBrand = carBrand;
66+
}
67+
68+
public String getCarType() {
69+
return carType;
70+
}
71+
72+
public void setCarType(String carType) {
73+
this.carType = carType;
74+
}
75+
76+
public String getCarColor() {
77+
return carColor;
78+
}
79+
80+
public void setCarColor(String carColor) {
81+
this.carColor = carColor;
82+
}
83+
84+
public String getOwnerName() {
85+
return ownerName;
86+
}
87+
88+
public void setOwnerName(String ownerName) {
89+
this.ownerName = ownerName;
90+
}
91+
92+
public String getIdCard() {
93+
return idCard;
94+
}
95+
96+
public void setIdCard(String idCard) {
97+
this.idCard = idCard;
98+
}
99+
100+
public String getLink() {
101+
return link;
102+
}
103+
104+
public void setLink(String link) {
105+
this.link = link;
106+
}
107+
108+
public String getState() {
109+
return state;
110+
}
111+
112+
public void setState(String state) {
113+
this.state = state;
114+
}
115+
116+
public String getStateName() {
117+
return stateName;
118+
}
119+
120+
public void setStateName(String stateName) {
121+
this.stateName = stateName;
122+
}
123+
124+
public String getUnitNum() {
125+
return unitNum;
126+
}
127+
128+
public void setUnitNum(String unitNum) {
129+
this.unitNum = unitNum;
130+
}
131+
132+
public String getNum() {
133+
return num;
134+
}
135+
136+
public void setNum(String num) {
137+
this.num = num;
138+
}
139+
140+
public String getPsId() {
141+
return psId;
142+
}
143+
144+
public void setPsId(String psId) {
145+
this.psId = psId;
146+
}
147+
148+
public String getPaId() {
149+
return paId;
150+
}
151+
152+
public void setPaId(String paId) {
153+
this.paId = paId;
154+
}
155+
156+
public String getAreaNum() {
157+
return areaNum;
158+
}
159+
160+
public void setAreaNum(String areaNum) {
161+
this.areaNum = areaNum;
162+
}
163+
164+
public String getCommunityId() {
165+
return communityId;
166+
}
167+
168+
public void setCommunityId(String communityId) {
169+
this.communityId = communityId;
170+
}
171+
}

‎java110-bean/src/main/java/com/java110/dto/report/ReportFeeDetailDto.java‎

Lines changed: 124 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,124 @@
1+
package com.java110.dto.report;
2+
3+
import com.java110.dto.PageDto;
4+
5+
import java.io.Serializable;
6+
7+
/**
8+
* @ClassName ReportRoomDto
9+
* @Description TODO
10+
* @Author wuxw
11+
* @Date 2020/10/15 22:20
12+
* @Version 1.0
13+
* add by wuxw 2020/10/15
14+
**/
15+
public class ReportFeeDetailDto extends PageDto implements Serializable {
16+
private String detailId;
17+
private String feeId;
18+
private String communityId;
19+
private String cycles;
20+
private String receivableAmount;
21+
private String receivedAmount;
22+
private String primeRate;
23+
private String remark;
24+
private String startTime;
25+
private String endTime;
26+
private String createTime;
27+
private String state;
28+
29+
public String getDetailId() {
30+
return detailId;
31+
}
32+
33+
public void setDetailId(String detailId) {
34+
this.detailId = detailId;
35+
}
36+
37+
public String getFeeId() {
38+
return feeId;
39+
}
40+
41+
public void setFeeId(String feeId) {
42+
this.feeId = feeId;
43+
}
44+
45+
public String getCommunityId() {
46+
return communityId;
47+
}
48+
49+
public void setCommunityId(String communityId) {
50+
this.communityId = communityId;
51+
}
52+
53+
public String getCycles() {
54+
return cycles;
55+
}
56+
57+
public void setCycles(String cycles) {
58+
this.cycles = cycles;
59+
}
60+
61+
public String getReceivableAmount() {
62+
return receivableAmount;
63+
}
64+
65+
public void setReceivableAmount(String receivableAmount) {
66+
this.receivableAmount = receivableAmount;
67+
}
68+
69+
public String getReceivedAmount() {
70+
return receivedAmount;
71+
}
72+
73+
public void setReceivedAmount(String receivedAmount) {
74+
this.receivedAmount = receivedAmount;
75+
}
76+
77+
public String getPrimeRate() {
78+
return primeRate;
79+
}
80+
81+
public void setPrimeRate(String primeRate) {
82+
this.primeRate = primeRate;
83+
}
84+
85+
public String getRemark() {
86+
return remark;
87+
}
88+
89+
public void setRemark(String remark) {
90+
this.remark = remark;
91+
}
92+
93+
public String getStartTime() {
94+
return startTime;
95+
}
96+
97+
public void setStartTime(String startTime) {
98+
this.startTime = startTime;
99+
}
100+
101+
public String getEndTime() {
102+
return endTime;
103+
}
104+
105+
public void setEndTime(String endTime) {
106+
this.endTime = endTime;
107+
}
108+
109+
public String getCreateTime() {
110+
return createTime;
111+
}
112+
113+
public void setCreateTime(String createTime) {
114+
this.createTime = createTime;
115+
}
116+
117+
public String getState() {
118+
return state;
119+
}
120+
121+
public void setState(String state) {
122+
this.state = state;
123+
}
124+
}

‎java110-db/src/main/resources/mapper/report/ReportCommunityServiceDaoImplMapper.xml‎

Lines changed: 37 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -42,4 +42,41 @@
4242
</select>
4343

4444

45+
<!-- 查询房屋个数 add by wuxw 2018-07-03 -->
46+
<select id="getCarCount" parameterType="com.java110.dto.report.ReportCarDto" resultType="Map">
47+
select count(1) count
48+
from owner_car t
49+
where t.status_cd = '0'
50+
<if test="state !=null and state != ''">
51+
and t.state= #{state}
52+
</if>
53+
<if test="communityId !=null and communityId != ''">
54+
and t.community_id= #{communityId}
55+
</if>
56+
</select>
57+
58+
59+
<!-- 查询 房屋 楼栋 单元 业主 -->
60+
<select id="getCarParkingSpace" parameterType="com.java110.dto.report.ReportCarDto"
61+
resultType="com.java110.dto.report.ReportCarDto">
62+
select t.car_brand carBrand,t.car_color carColor,t.car_id carId,t.car_num carNum,t.car_type carType,
63+
t.community_id communityId,bo.`name` ownerName,bo.id_card idCard,bo.link,bo.owner_id ownerId,ps.ps_id psId,
64+
ps.num,pa.pa_id paId,pa.num areaNum,ps.state
65+
from owner_car t
66+
INNER JOIN building_owner bo on t.owner_id = bo.member_id and t.status_cd = '0'
67+
left join parking_space ps on t.ps_id = t.ps_id and ps.status_cd = '0'
68+
left join parking_area pa on ps.pa_id = pa.pa_id and pa.status_cd = '0'
69+
where t.status_cd = '0'
70+
<if test="state !=null and state != ''">
71+
and t.state= #{state}
72+
</if>
73+
<if test="communityId !=null and communityId != ''">
74+
and t.community_id= #{communityId}
75+
</if>
76+
<if test="page != -1 and page != null ">
77+
limit #{page}, #{row}
78+
</if>
79+
</select>
80+
81+
4582
</mapper>

0 commit comments

Comments
 (0)