| | |
| | | |
| | | /** |
| | | * 对方收款单位接口 |
| | | * 适配 payee_receive_info 表 |
| | | * 适配 payee_receiveInfo 表 |
| | | * @author dev |
| | | * @date 2025-12-24 |
| | | */ |
| | |
| | | @RequestMapping(value = "/savePayeeReceiveInfo", method = RequestMethod.POST) |
| | | public ResponseEntity<String> savePayeeReceiveInfo(@RequestBody JSONObject reqJson) { |
| | | // 核心参数校验(可根据业务补充必传校验) |
| | | Assert.hasKeyAndValue(reqJson, "owner_id", "请求报文中未包含业主编号owner_id"); |
| | | Assert.hasKeyAndValue(reqJson, "ownerId", "请求报文中未包含业主编号ownerId"); |
| | | |
| | | // 转换为POJO |
| | | PayeeReceiveInfoPo po = BeanConvertUtil.covertBean(reqJson, PayeeReceiveInfoPo.class); |
| | |
| | | /** |
| | | * 分页查询对方收款单位信息列表 |
| | | * |
| | | * @param owner_id 业主编号(必传) |
| | | * @param ownerId 业主编号(必传) |
| | | * @param page 页码(默认1) |
| | | * @param row 每页条数(默认10) |
| | | * @param id 主键ID(可选) |
| | | * @param room_id 房屋Id(可选) |
| | | * @param roomId 房屋Id(可选) |
| | | * @return 响应结果 |
| | | * @serviceCode /payeeReceiveInfo/queryPayeeReceiveInfo |
| | | * @path /app/payeeReceiveInfo/queryPayeeReceiveInfo |
| | | */ |
| | | @RequestMapping(value = "/queryPayeeReceiveInfo", method = RequestMethod.GET) |
| | | public ResponseEntity<String> queryPayeeReceiveInfo( |
| | | @RequestParam(value = "owner_id") String owner_id, |
| | | @RequestParam(value = "ownerId") String ownerId, |
| | | @RequestParam(value = "page", defaultValue = "1") int page, |
| | | @RequestParam(value = "row", defaultValue = "10") int row, |
| | | @RequestParam(value = "id", required = false) String id, |
| | | @RequestParam(value = "room_id", required = false) String room_id) { |
| | | @RequestParam(value = "roomId", required = false) String roomId) { |
| | | |
| | | // 封装查询参数 |
| | | PayeeReceiveInfoPo queryPo = new PayeeReceiveInfoPo(); |
| | | queryPo.setOwner_id(owner_id); |
| | | queryPo.setOwnerId(ownerId); |
| | | queryPo.setPage((page - 1) * row); // 转换为MySQL分页偏移量 |
| | | queryPo.setRow(row); |
| | | |
| | | if (id != null && !id.isEmpty()) { |
| | | queryPo.setId(Integer.parseInt(id)); |
| | | } |
| | | if (room_id != null && !room_id.isEmpty()) { |
| | | queryPo.setRoom_id(room_id); |
| | | if (roomId != null && !roomId.isEmpty()) { |
| | | queryPo.setRoomId(roomId); |
| | | } |
| | | |
| | | // 查询列表数据 |
| | |
| | | } |
| | | |
| | | /** |
| | | * 根据owner_id查询对方收款单位信息 |
| | | * 根据ownerId查询对方收款单位信息 |
| | | * |
| | | * @param owner_id 业主编号 |
| | | * @param ownerId 业主编号 |
| | | * @return 响应结果 |
| | | * @serviceCode /payeeReceiveInfo/getPayeeReceiveInfoByOwnerId |
| | | * @path /app/payeeReceiveInfo/getPayeeReceiveInfoByOwnerId |
| | | */ |
| | | @RequestMapping(value = "/getPayeeReceiveInfoByOwnerId", method = RequestMethod.GET) |
| | | public ResponseEntity<String> getPayeeReceiveInfoByOwnerId(@RequestParam(value = "owner_id") String owner_id) { |
| | | Assert.notNull(owner_id, "业主编号owner_id不能为空"); |
| | | public ResponseEntity<String> getPayeeReceiveInfoByOwnerId(@RequestParam(value = "ownerId") String ownerId) { |
| | | Assert.notNull(ownerId, "业主编号ownerId不能为空"); |
| | | |
| | | PayeeReceiveInfoPo queryPo = new PayeeReceiveInfoPo(); |
| | | queryPo.setOwner_id(owner_id); |
| | | queryPo.setOwnerId(ownerId); |
| | | |
| | | List<Map<String, Object>> result = sqlSessionTemplate.selectList( |
| | | "payeeReceiveInfoServiceDaoImpl.getPayeeReceiveInfo", |
| | |
| | | /** |
| | | * 统计对方收款单位信息 |
| | | * |
| | | * @param owner_id 业主编号(可选) |
| | | * @param room_id 房屋Id(可选) |
| | | * @param ownerId 业主编号(可选) |
| | | * @param roomId 房屋Id(可选) |
| | | * @param startCreateTime 开始创建时间(可选,格式:yyyy-MM-dd HH:mm:ss) |
| | | * @param endCreateTime 结束创建时间(可选) |
| | | * @return 响应结果 |
| | |
| | | */ |
| | | @RequestMapping(value = "/queryPayeeReceiveInfoStatistics", method = RequestMethod.GET) |
| | | public ResponseEntity<String> queryPayeeReceiveInfoStatistics( |
| | | @RequestParam(value = "owner_id", required = false) String owner_id, |
| | | @RequestParam(value = "room_id", required = false) String room_id, |
| | | @RequestParam(value = "ownerId", required = false) String ownerId, |
| | | @RequestParam(value = "roomId", required = false) String roomId, |
| | | @RequestParam(value = "startCreateTime", required = false) String startCreateTime, |
| | | @RequestParam(value = "endCreateTime", required = false) String endCreateTime) { |
| | | |
| | | PayeeReceiveInfoPo queryPo = new PayeeReceiveInfoPo(); |
| | | queryPo.setOwner_id(owner_id); |
| | | queryPo.setRoom_id(room_id); |
| | | queryPo.setOwnerId(ownerId); |
| | | queryPo.setRoomId(roomId); |
| | | queryPo.setStartCreateTime(startCreateTime); |
| | | queryPo.setEndCreateTime(endCreateTime); |
| | | |
| | |
| | | */ |
| | | public static class PayeeReceiveInfoPo { |
| | | private Integer id; |
| | | private String caller_name; |
| | | private String contact_info; |
| | | private String payee_info; |
| | | private String invoice_no; |
| | | private String invoice_date; |
| | | private String receipt_no; |
| | | private String receipt_date; |
| | | private String receipt_note; |
| | | private String receipt_note_date; |
| | | private String image_file; |
| | | private String our_company_receive_date; |
| | | private String attachment_file; |
| | | private String create_time; |
| | | private String update_time; |
| | | private String owner_id; |
| | | private String room_id; |
| | | private String callerName; |
| | | private String contactInfo; |
| | | private String payeeInfo; |
| | | private String invoiceNo; |
| | | private String invoiceDate; |
| | | private String receiptNo; |
| | | private String receiptDate; |
| | | private String receiptNote; |
| | | private String receiptNoteDate; |
| | | private String imageFile; |
| | | private String ourCompanyReceiveDate; |
| | | private String attachmentFile; |
| | | private String createTime; |
| | | private String updateTime; |
| | | private String ownerId; |
| | | private String roomId; |
| | | // 分页参数 |
| | | private int page; |
| | | private int row; |
| | |
| | | this.id = id; |
| | | } |
| | | |
| | | public String getCaller_name() { |
| | | return caller_name; |
| | | public String getCallerName() { |
| | | return callerName; |
| | | } |
| | | |
| | | public void setCaller_name(String caller_name) { |
| | | this.caller_name = caller_name; |
| | | public void setCallerName(String callerName) { |
| | | this.callerName = callerName; |
| | | } |
| | | |
| | | public String getContact_info() { |
| | | return contact_info; |
| | | public String getContactInfo() { |
| | | return contactInfo; |
| | | } |
| | | |
| | | public void setContact_info(String contact_info) { |
| | | this.contact_info = contact_info; |
| | | public void setContactInfo(String contactInfo) { |
| | | this.contactInfo = contactInfo; |
| | | } |
| | | |
| | | public String getPayee_info() { |
| | | return payee_info; |
| | | public String getPayeeInfo() { |
| | | return payeeInfo; |
| | | } |
| | | |
| | | public void setPayee_info(String payee_info) { |
| | | this.payee_info = payee_info; |
| | | public void setPayeeInfo(String payeeInfo) { |
| | | this.payeeInfo = payeeInfo; |
| | | } |
| | | |
| | | public String getInvoice_no() { |
| | | return invoice_no; |
| | | public String getInvoiceNo() { |
| | | return invoiceNo; |
| | | } |
| | | |
| | | public void setInvoice_no(String invoice_no) { |
| | | this.invoice_no = invoice_no; |
| | | public void setInvoiceNo(String invoiceNo) { |
| | | this.invoiceNo = invoiceNo; |
| | | } |
| | | |
| | | public String getInvoice_date() { |
| | | return invoice_date; |
| | | public String getInvoiceDate() { |
| | | return invoiceDate; |
| | | } |
| | | |
| | | public void setInvoice_date(String invoice_date) { |
| | | this.invoice_date = invoice_date; |
| | | public void setInvoiceDate(String invoiceDate) { |
| | | this.invoiceDate = invoiceDate; |
| | | } |
| | | |
| | | public String getReceipt_no() { |
| | | return receipt_no; |
| | | public String getReceiptNo() { |
| | | return receiptNo; |
| | | } |
| | | |
| | | public void setReceipt_no(String receipt_no) { |
| | | this.receipt_no = receipt_no; |
| | | public void setReceiptNo(String receiptNo) { |
| | | this.receiptNo = receiptNo; |
| | | } |
| | | |
| | | public String getReceipt_date() { |
| | | return receipt_date; |
| | | public String getReceiptDate() { |
| | | return receiptDate; |
| | | } |
| | | |
| | | public void setReceipt_date(String receipt_date) { |
| | | this.receipt_date = receipt_date; |
| | | public void setReceiptDate(String receiptDate) { |
| | | this.receiptDate = receiptDate; |
| | | } |
| | | |
| | | public String getReceipt_note() { |
| | | return receipt_note; |
| | | public String getReceiptNote() { |
| | | return receiptNote; |
| | | } |
| | | |
| | | public void setReceipt_note(String receipt_note) { |
| | | this.receipt_note = receipt_note; |
| | | public void setReceiptNote(String receiptNote) { |
| | | this.receiptNote = receiptNote; |
| | | } |
| | | |
| | | public String getReceipt_note_date() { |
| | | return receipt_note_date; |
| | | public String getReceiptNoteDate() { |
| | | return receiptNoteDate; |
| | | } |
| | | |
| | | public void setReceipt_note_date(String receipt_note_date) { |
| | | this.receipt_note_date = receipt_note_date; |
| | | public void setReceiptNoteDate(String receiptNoteDate) { |
| | | this.receiptNoteDate = receiptNoteDate; |
| | | } |
| | | |
| | | public String getImage_file() { |
| | | return image_file; |
| | | public String getImageFile() { |
| | | return imageFile; |
| | | } |
| | | |
| | | public void setImage_file(String image_file) { |
| | | this.image_file = image_file; |
| | | public void setImageFile(String imageFile) { |
| | | this.imageFile = imageFile; |
| | | } |
| | | |
| | | public String getOur_company_receive_date() { |
| | | return our_company_receive_date; |
| | | public String getOurCompanyReceiveDate() { |
| | | return ourCompanyReceiveDate; |
| | | } |
| | | |
| | | public void setOur_company_receive_date(String our_company_receive_date) { |
| | | this.our_company_receive_date = our_company_receive_date; |
| | | public void setOurCompanyReceiveDate(String ourCompanyReceiveDate) { |
| | | this.ourCompanyReceiveDate = ourCompanyReceiveDate; |
| | | } |
| | | |
| | | public String getAttachment_file() { |
| | | return attachment_file; |
| | | public String getAttachmentFile() { |
| | | return attachmentFile; |
| | | } |
| | | |
| | | public void setAttachment_file(String attachment_file) { |
| | | this.attachment_file = attachment_file; |
| | | public void setAttachmentFile(String attachmentFile) { |
| | | this.attachmentFile = attachmentFile; |
| | | } |
| | | |
| | | public String getCreate_time() { |
| | | return create_time; |
| | | public String getCreateTime() { |
| | | return createTime; |
| | | } |
| | | |
| | | public void setCreate_time(String create_time) { |
| | | this.create_time = create_time; |
| | | public void setCreateTime(String createTime) { |
| | | this.createTime = createTime; |
| | | } |
| | | |
| | | public String getUpdate_time() { |
| | | return update_time; |
| | | public String getUpdateTime() { |
| | | return updateTime; |
| | | } |
| | | |
| | | public void setUpdate_time(String update_time) { |
| | | this.update_time = update_time; |
| | | public void setUpdateTime(String updateTime) { |
| | | this.updateTime = updateTime; |
| | | } |
| | | |
| | | public String getOwner_id() { |
| | | return owner_id; |
| | | public String getOwnerId() { |
| | | return ownerId; |
| | | } |
| | | |
| | | public void setOwner_id(String owner_id) { |
| | | this.owner_id = owner_id; |
| | | public void setOwnerId(String ownerId) { |
| | | this.ownerId = ownerId; |
| | | } |
| | | |
| | | public String getRoom_id() { |
| | | return room_id; |
| | | public String getRoomId() { |
| | | return roomId; |
| | | } |
| | | |
| | | public void setRoom_id(String room_id) { |
| | | this.room_id = room_id; |
| | | public void setRoomId(String roomId) { |
| | | this.roomId = roomId; |
| | | } |
| | | |
| | | public int getPage() { |