| | |
| | | private int oweDay; |
| | | private String deadlineTime; |
| | | |
| | | private String curMaxTime; |
| | | private String importFeeName; |
| | | |
| | | private String oId; |
| | |
| | | public void setoId(String oId) { |
| | | this.oId = oId; |
| | | } |
| | | |
| | | public String getCurMaxTime() { |
| | | return curMaxTime; |
| | | } |
| | | |
| | | public void setCurMaxTime(String curMaxTime) { |
| | | this.curMaxTime = curMaxTime; |
| | | } |
| | | } |
| | |
| | | private String feeCreateTime; |
| | | private String objType; |
| | | private String deadlineTime; |
| | | private String curMaxTime; |
| | | |
| | | public String getReceivableAmount() { |
| | | return receivableAmount; |
| | |
| | | public void setDeadlineTime(String deadlineTime) { |
| | | this.deadlineTime = deadlineTime; |
| | | } |
| | | |
| | | public String getCurMaxTime() { |
| | | return curMaxTime; |
| | | } |
| | | |
| | | public void setCurMaxTime(String curMaxTime) { |
| | | this.curMaxTime = curMaxTime; |
| | | } |
| | | } |
| | |
| | | <insert id="saveReportFeeMonthStatisticsInfo" parameterType="Map"> |
| | | insert into report_fee_month_statistics( |
| | | receivable_amount,statistics_id,update_time,remark,obj_name,received_amount,fee_year,fee_month,fee_id,config_id, |
| | | obj_id,fee_name,owe_amount,community_id,fee_create_time,obj_type,deadline_time |
| | | obj_id,fee_name,owe_amount,community_id,fee_create_time,obj_type,deadline_time,cur_max_time |
| | | ) values ( |
| | | #{receivableAmount},#{statisticsId},#{updateTime},#{remark},#{objName},#{receivedAmount},#{feeYear},#{feeMonth}, |
| | | #{feeId},#{configId},#{objId},#{feeName},#{oweAmount},#{communityId},#{feeCreateTime},#{objType},#{deadlineTime} |
| | | #{feeId},#{configId},#{objId},#{feeName},#{oweAmount},#{communityId},#{feeCreateTime},#{objType},#{deadlineTime},#{curMaxTime} |
| | | ) |
| | | </insert> |
| | | |
| | |
| | | feeYear,t.fee_month,t.fee_month feeMonth,t.fee_id,t.fee_id feeId,t.config_id,t.config_id |
| | | configId,t.obj_id,t.obj_id objId,t.fee_name,t.fee_name feeName,t.owe_amount,t.owe_amount |
| | | oweAmount,t.community_id,t.community_id communityId,t.fee_create_time,t.fee_create_time |
| | | feeCreateTime,t.obj_type,t.obj_type objType |
| | | feeCreateTime,t.obj_type,t.obj_type objType,t.cur_max_time curMaxTime |
| | | from report_fee_month_statistics t |
| | | inner join pay_fee pf on t.fee_id = pf.fee_id and pf.community_id = t.community_id and pf.status_cd = '0' |
| | | where 1 =1 |
| | |
| | | <if test="statisticsId !=null and statisticsId != ''"> |
| | | and t.statistics_id= #{statisticsId} |
| | | </if> |
| | | <if test="feeYear !=null "> |
| | | and t.fee_year <= #{feeYear} |
| | | </if> |
| | | <if test="feeMonth !=null "> |
| | | and t.fee_month <= #{feeMonth} |
| | | <if test="curMaxTime !=null "> |
| | | and t.cur_max_time <= #{curMaxTime} |
| | | </if> |
| | | <if test="feeId !=null and feeId != ''"> |
| | | and t.fee_id= #{feeId} |
| | |
| | | reportFeeMonthStatisticsPo.setFeeId(tmpReportFeeDto.getFeeId()); |
| | | reportFeeMonthStatisticsPo.setFeeMonth(DateUtil.getMonth() + ""); |
| | | reportFeeMonthStatisticsPo.setFeeYear(DateUtil.getYear() + ""); |
| | | reportFeeMonthStatisticsPo.setCurMaxTime(DateUtil.getNextMonthFirstDay(DateUtil.DATE_FORMATE_STRING_A)); |
| | | reportFeeMonthStatisticsPo.setObjId(tmpReportCarDto.getCarId()); |
| | | reportFeeMonthStatisticsPo.setObjType(FeeDto.PAYER_OBJ_TYPE_CAR); |
| | | reportFeeMonthStatisticsPo.setFeeName(tmpReportFeeDto.getFeeName()); |
| | |
| | | |
| | | ReportFeeMonthStatisticsPo tmpReportFeeMonthStatisticsPo = new ReportFeeMonthStatisticsPo(); |
| | | tmpReportFeeMonthStatisticsPo.setFeeId(tmpReportFeeDto.getFeeId()); |
| | | tmpReportFeeMonthStatisticsPo.setFeeYear(year + ""); |
| | | tmpReportFeeMonthStatisticsPo.setFeeMonth(month + ""); |
| | | tmpReportFeeMonthStatisticsPo.setCurMaxTime(DateUtil.getFormatTimeString(endTime,DateUtil.DATE_FORMATE_STRING_A)); |
| | | tmpReportFeeMonthStatisticsPo.setOweAmount("0"); |
| | | reportFeeMonthStatisticsServiceDaoImpl.updateReportFeeMonthStatisticsOwe(BeanConvertUtil.beanCovertMap(tmpReportFeeMonthStatisticsPo)); |
| | | } |
| | |
| | | reportFeeMonthStatisticsPo.setFeeId(tmpReportFeeDto.getFeeId()); |
| | | reportFeeMonthStatisticsPo.setFeeMonth((preMonthDate.get(Calendar.MONTH) + 1) + ""); |
| | | reportFeeMonthStatisticsPo.setFeeYear(preMonthDate.get(Calendar.YEAR) + ""); |
| | | reportFeeMonthStatisticsPo.setCurMaxTime(DateUtil.getFormatTimeString(DateUtil.getFirstDate(),DateUtil.DATE_FORMATE_STRING_A)); |
| | | reportFeeMonthStatisticsPo.setObjId(tmpReportCarDto.getCarId()); |
| | | reportFeeMonthStatisticsPo.setObjType(FeeDto.PAYER_OBJ_TYPE_CAR); |
| | | reportFeeMonthStatisticsPo.setFeeName(tmpReportFeeDto.getFeeName()); |
| | |
| | | reportFeeMonthStatisticsPo.setFeeId(tmpReportFeeDto.getFeeId()); |
| | | reportFeeMonthStatisticsPo.setFeeMonth(DateUtil.getMonth() + ""); |
| | | reportFeeMonthStatisticsPo.setFeeYear(DateUtil.getYear() + ""); |
| | | reportFeeMonthStatisticsPo.setCurMaxTime(DateUtil.getNextMonthFirstDay(DateUtil.DATE_FORMATE_STRING_A)); |
| | | reportFeeMonthStatisticsPo.setObjId(reportRoomDto.getRoomId()); |
| | | reportFeeMonthStatisticsPo.setObjType(FeeDto.PAYER_OBJ_TYPE_ROOM); |
| | | reportFeeMonthStatisticsPo.setFeeName(StringUtil.isEmpty(tmpReportFeeDto.getImportFeeName()) ? tmpReportFeeDto.getFeeName() : tmpReportFeeDto.getImportFeeName()); |
| | |
| | | //将缴费 到期时间之前得欠费刷为0 |
| | | Date endTime = tmpReportFeeDto.getEndTime(); |
| | | |
| | | Calendar calender = Calendar.getInstance(); |
| | | calender.setTime(endTime); |
| | | int year = calender.get(Calendar.YEAR); |
| | | int month = calender.get(Calendar.MONTH); |
| | | |
| | | ReportFeeMonthStatisticsPo tmpReportFeeMonthStatisticsPo = new ReportFeeMonthStatisticsPo(); |
| | | tmpReportFeeMonthStatisticsPo.setFeeId(tmpReportFeeDto.getFeeId()); |
| | | tmpReportFeeMonthStatisticsPo.setFeeYear(year + ""); |
| | | tmpReportFeeMonthStatisticsPo.setFeeMonth(month + ""); |
| | | tmpReportFeeMonthStatisticsPo.setCurMaxTime(DateUtil.getFormatTimeString(endTime,DateUtil.DATE_FORMATE_STRING_A)); |
| | | tmpReportFeeMonthStatisticsPo.setOweAmount("0"); |
| | | reportFeeMonthStatisticsServiceDaoImpl.updateReportFeeMonthStatisticsOwe(BeanConvertUtil.beanCovertMap(tmpReportFeeMonthStatisticsPo)); |
| | | } |
| | |
| | | reportFeeMonthStatisticsPo.setFeeId(tmpReportFeeDto.getFeeId()); |
| | | reportFeeMonthStatisticsPo.setFeeMonth((preMonthDate.get(Calendar.MONTH) + 1) + ""); |
| | | reportFeeMonthStatisticsPo.setFeeYear(preMonthDate.get(Calendar.YEAR) + ""); |
| | | reportFeeMonthStatisticsPo.setCurMaxTime(DateUtil.getFormatTimeString(DateUtil.getFirstDate(),DateUtil.DATE_FORMATE_STRING_A)); |
| | | |
| | | reportFeeMonthStatisticsPo.setObjId(reportRoomDto.getRoomId()); |
| | | reportFeeMonthStatisticsPo.setObjType(FeeDto.PAYER_OBJ_TYPE_ROOM); |
| | | reportFeeMonthStatisticsPo.setFeeName(StringUtil.isEmpty(tmpReportFeeDto.getImportFeeName()) ? tmpReportFeeDto.getFeeName() : tmpReportFeeDto.getImportFeeName()); |