| | |
| | | import com.java110.intf.report.IQueryPayFeeDetailInnerServiceSMO; |
| | | import com.java110.job.export.IExportDataAdapt; |
| | | import com.java110.utils.util.BeanConvertUtil; |
| | | import com.java110.utils.util.DateUtil; |
| | | import com.java110.utils.util.StringUtil; |
| | | import com.java110.vo.ResultVo; |
| | | import org.apache.poi.ss.usermodel.Row; |
| | |
| | | row.createCell(17).setCellValue("空置房减免金额"); |
| | | row.createCell(18).setCellValue("面积"); |
| | | row.createCell(19).setCellValue("车位"); |
| | | |
| | | row.createCell(20).setCellValue("账户抵扣"); |
| | | |
| | | JSONObject reqJson = exportDataDto.getReqJson(); |
| | | ReportFeeMonthStatisticsDto reportFeeMonthStatisticsDto = BeanConvertUtil.covertBean(reqJson,ReportFeeMonthStatisticsDto.class); |
| | |
| | | row.createCell(6).setCellValue(dataObj.getString("primeRate")); |
| | | row.createCell(7).setCellValue(dataObj.getString("startTime")); |
| | | row.createCell(8).setCellValue(dataObj.getString("endTime")); |
| | | row.createCell(9).setCellValue(dataObj.getString("createTime")); |
| | | row.createCell(9).setCellValue(DateUtil.getFormatTimeString(dataObj.getDate("createTime"),DateUtil.DATE_FORMATE_STRING_A)); |
| | | row.createCell(10).setCellValue(dataObj.getDouble("receivableAmount")); |
| | | row.createCell(11).setCellValue(dataObj.getDouble("receivedAmount")); |
| | | row.createCell(12).setCellValue(dataObj.getDouble("preferentialAmount")); |
| | |
| | | row.createCell(17).setCellValue(dataObj.getDouble("vacantHousingReduction")); |
| | | row.createCell(18).setCellValue(dataObj.getString("builtUpArea")); |
| | | row.createCell(19).setCellValue(dataObj.getString("psName")); |
| | | row.createCell(20).setCellValue(dataObj.getString("withholdAmount")); |
| | | |
| | | } |
| | | } |
| | | } |