java/xizang.git

			@@ -157,28 +157,28 @@
			</select>

			<select id="statisticsAllRent" resultType="java.math.BigDecimal">
			SELECT ifnull(sum(payable_fees_money),0) as amount FROM t_bill
			SELECT ifnull(sum(payable_fees_money),0) as amount FROM t_bill where pay_fees_status!='5'
			<if test='busDeptId != null and busDeptId != "" and busDeptId!="0"'>
			where business_dept_id = #{busDeptId}
			and business_dept_id = #{busDeptId}
			</if>
			</select>

			<select id="statisticsNoPay" resultType="java.math.BigDecimal">
			SELECT ifnull(sum(outstanding_money),0) as amount FROM t_bill where pay_fees_status!=3
			SELECT ifnull(sum(outstanding_money),0) as amount FROM t_bill where pay_fees_status!='3' and pay_fees_status!='5'
			<if test='busDeptId != null and busDeptId != "" and busDeptId!="0"'>
			and business_dept_id = #{busDeptId}
			</if>
			</select>

			<select id="statisticsPayed" resultType="java.math.BigDecimal">
			SELECT ifnull(sum(pay_fees_money),0) as amount FROM t_bill
			SELECT ifnull(sum(pay_fees_money),0) as amount FROM t_bill where pay_fees_status!='5'
			<if test='busDeptId != null and busDeptId != "" and busDeptId!="0"'>
			where business_dept_id = #{busDeptId}
			and business_dept_id = #{busDeptId}
			</if>
			</select>

			<select id="statisticsOverdue" resultType="java.math.BigDecimal">
			SELECT ifnull(sum(outstanding_money),0) as amount FROM t_bill where pay_fees_status=4
			SELECT ifnull(sum(outstanding_money),0) as amount FROM t_bill where pay_fees_status='4'
			<if test='busDeptId != null and busDeptId != "" and busDeptId!="0"'>
			and business_dept_id = #{busDeptId}
			</if>

	ruoyi-system/src/main/java/com/ruoyi/system/service/impl/TBillServiceImpl.java	1 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	ruoyi-system/src/main/resources/mapper/system/TBillMapper.xml	12 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

			@@ -329,6 +329,7 @@
			save.setPayType(3);
			save.setPayer(dto.getPayer());
			save.setPayTime(billSave.getPayFeesTime());
			save.setBusinessDeptId(bill.getBusinessDeptId());
			save.setSysSerialNumber(OrderNos.getDid(30));
			save.setFlowType(1);
			save.setPaymentBillId(back.getId());