| | |
|---|
| | | endTime,t.community_id,t.community_id communityId,t.b_id,t.b_id bId,t.fee_id,t.fee_id feeId,t.user_id,t.user_id |
|---|
| | | userId,t.payer_obj_id,t.payer_obj_id payerObjId,pfc.square_price squarePrice,pfc.additional_amount |
|---|
| | | additionalAmount,t.fee_flag,t.fee_flag feeFlag,t.state,t.config_id,t.config_id configId, |
|---|
| | | pfc.fee_name feeName,td1.name feeTypeCdName,td2.name stateName,td3.name feeFlagName,pfc.computing_formula,pfc.bill_type billType |
|---|
| | | computingFormula, |
|---|
| | | t.payer_obj_type,t.payer_obj_type payerObjType,pfc.is_default isDefault,pfc.start_time |
|---|
| | | pfc.fee_name feeName,td1.name feeTypeCdName,td2.name stateName,td3.name feeFlagName,pfc.computing_formula computingFormula, |
|---|
| | | pfc.bill_type billType,t.payer_obj_type,t.payer_obj_type payerObjType,pfc.is_default isDefault,pfc.start_time |
|---|
| | | configStartTime,pfc.end_time configEndTime,pfc.payment_cd paymentCd,pfc.payment_cycle paymentCycle |
|---|
| | | from pay_fee t,pay_fee_config pfc,t_dict td1,t_dict td2,t_dict td3 |
|---|
| | | where 1 =1 |
|---|
| | |
|---|
| | | import com.java110.intf.community.IRoomInnerServiceSMO; |
|---|
| | | import com.java110.intf.fee.IFeeConfigInnerServiceSMO; |
|---|
| | | import com.java110.intf.fee.IFeeInnerServiceSMO; |
|---|
| | | import com.java110.utils.util.DateUtil; |
|---|
| | | import com.java110.vo.ResultVo; |
|---|
| | | import org.springframework.beans.factory.annotation.Autowired; |
|---|
| | | import org.springframework.http.ResponseEntity; |
|---|
| | |
|---|
| | | @Override |
|---|
| | | public ResponseEntity<String> query(FeeDto feeDto) { |
|---|
| | | |
|---|
| | | //查询费用信息 |
|---|
| | | //查询费用信息arrearsEndTime |
|---|
| | | feeDto.setArrearsEndTime(DateUtil.getCurrentDate()); |
|---|
| | | feeDto.setState(FeeDto.STATE_DOING); |
|---|
| | | List<FeeDto> feeDtos = feeInnerServiceSMOImpl.queryFees(feeDto); |
|---|
| | | |
|---|
| | | if (feeDtos == null || feeDtos.size() < 1) { |
|---|
| | | feeDtos = new ArrayList<>(); |
|---|
| | | return ResultVo.createResponseEntity(feeDtos); |
|---|
| | | } |
|---|
| | | |
|---|
| | | List<FeeDto> tmpFeeDtos = new ArrayList<>(); |
|---|
| | | for (FeeDto tmpFeeDto : feeDtos) { |
|---|
| | | computeOweFee(tmpFeeDto);//计算欠费金额 |
|---|
| | | |
|---|
| | | //如果金额为0 就排除 |
|---|
| | | if (tmpFeeDto.getFeePrice() > 0) { |
|---|
| | | tmpFeeDtos.add(tmpFeeDto); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | |
|---|
| | | return ResultVo.createResponseEntity(feeDtos); |
|---|
| | | |
|---|
| | | return ResultVo.createResponseEntity(tmpFeeDtos); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
