From 2283114d983bb80dcf7edba97600e4c6225d4adb Mon Sep 17 00:00:00 2001 From: yxh <172933527@qq.com> Date: 星期六, 22 四月 2023 10:46:34 +0800 Subject: [PATCH] yxh --- ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementpayeeServiceImpl.java | 76 ++ ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementpayeeSharedController.java | 116 ++++ ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementpayeeMapper.java | 23 ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementpayeeController.java | 116 ++++ ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFunddetailSharedController.java | 116 ++++ ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFunddetailShared.java | 275 ++++++++++ ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementpayeeSharedService.java | 23 ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailSharedMapper.xml | 124 ++++ ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementpayeeSharedMapper.java | 23 ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFunddetailSharedServiceImpl.java | 187 +++++++ ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementpayeeService.java | 23 ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayeeShared.java | 100 +++ ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceFunddetailSharedService.java | 23 ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementpayeeSharedServiceImpl.java | 79 +++ ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayee.java | 95 +++ ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailSharedMapper.java | 23 ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeMapper.xml | 51 + ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeSharedMapper.xml | 53 ++ 18 files changed, 1,526 insertions(+), 0 deletions(-) diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFunddetailSharedController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFunddetailSharedController.java new file mode 100644 index 0000000..b5cd40f --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceFunddetailSharedController.java @@ -0,0 +1,116 @@ +package com.ruoyi.project.controller; + +import java.util.Arrays; +import java.util.List; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.annotation.RepeatSubmit; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.ruoyi.project.domain.ServiceFunddetailShared; +import com.ruoyi.project.service.IServiceFunddetailSharedService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 璐圭敤鐢宠鏄庣粏Controller + * + * @author ruoyi + * @date 2023-04-20 + */ +@Api("璐圭敤鐢宠鏄庣粏") +@RestController +@RequestMapping("/project/funddetailshared") +public class ServiceFunddetailSharedController extends BaseController +{ + @Autowired + private IServiceFunddetailSharedService serviceFunddetailSharedService; + + /** + * 鏌ヨ璐圭敤鐢宠鏄庣粏鍒楄〃 + */ + @ApiOperation("鏌ヨ璐圭敤鐢宠鏄庣粏鍒楄〃") + @PreAuthorize("@ss.hasPermi('project:funddetailshared:list')") + @GetMapping("/list") + public TableDataInfo list(ServiceFunddetailShared serviceFunddetailShared) + { + startPage(); + List<ServiceFunddetailShared> list = serviceFunddetailSharedService.queryList(serviceFunddetailShared); + return getDataTable(list); + } + + /** + * 瀵煎嚭璐圭敤鐢宠鏄庣粏鍒楄〃 + */ + @ApiOperation("瀵煎嚭璐圭敤鐢宠鏄庣粏鍒楄〃") + @PreAuthorize("@ss.hasPermi('project:funddetailshared:export')") + @Log(title = "璐圭敤鐢宠鏄庣粏", businessType = BusinessType.EXPORT) + @GetMapping("/export") + public AjaxResult export(ServiceFunddetailShared serviceFunddetailShared) + { + List<ServiceFunddetailShared> list = serviceFunddetailSharedService.queryList(serviceFunddetailShared); + ExcelUtil<ServiceFunddetailShared> util = new ExcelUtil<ServiceFunddetailShared>(ServiceFunddetailShared.class); + return util.exportExcel(list, "璐圭敤鐢宠鏄庣粏鏁版嵁"); + } + + /** + * 鑾峰彇璐圭敤鐢宠鏄庣粏璇︾粏淇℃伅 + */ + @ApiOperation("鑾峰彇璐圭敤鐢宠鏄庣粏璇︾粏淇℃伅") + @PreAuthorize("@ss.hasPermi('project:funddetailshared:query')") + @GetMapping(value = "/{id}") + public AjaxResult getInfo(@PathVariable("id") Long id) + { + return AjaxResult.success(serviceFunddetailSharedService.getById(id)); + } + + /** + * 鏂板璐圭敤鐢宠鏄庣粏 + */ + @ApiOperation("鏂板璐圭敤鐢宠鏄庣粏") + @PreAuthorize("@ss.hasPermi('project:funddetailshared:add')") + @Log(title = "璐圭敤鐢宠鏄庣粏", businessType = BusinessType.INSERT) + @PostMapping + @RepeatSubmit + public AjaxResult add(@RequestBody ServiceFunddetailShared serviceFunddetailShared) + { + return toAjax(serviceFunddetailSharedService.save(serviceFunddetailShared)); + } + + /** + * 淇敼璐圭敤鐢宠鏄庣粏 + */ + @ApiOperation("淇敼璐圭敤鐢宠鏄庣粏") + @PreAuthorize("@ss.hasPermi('project:funddetailshared:edit')") + @Log(title = "璐圭敤鐢宠鏄庣粏", businessType = BusinessType.UPDATE) + @PutMapping + @RepeatSubmit + public AjaxResult edit(@RequestBody ServiceFunddetailShared serviceFunddetailShared) + { + return toAjax(serviceFunddetailSharedService.updateById(serviceFunddetailShared)); + } + + /** + * 鍒犻櫎璐圭敤鐢宠鏄庣粏 + */ + @ApiOperation("鍒犻櫎璐圭敤鐢宠鏄庣粏") + @PreAuthorize("@ss.hasPermi('project:funddetailshared:remove')") + @Log(title = "璐圭敤鐢宠鏄庣粏", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(serviceFunddetailSharedService.removeByIds(Arrays.asList(ids))); + } +} diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementpayeeController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementpayeeController.java new file mode 100644 index 0000000..9f51e08 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementpayeeController.java @@ -0,0 +1,116 @@ +package com.ruoyi.project.controller; + +import java.util.Arrays; +import java.util.List; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.annotation.RepeatSubmit; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.ruoyi.project.domain.ServiceReimbursementpayee; +import com.ruoyi.project.service.IServiceReimbursementpayeeService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅Controller + * + * @author ruoyi + * @date 2023-04-20 + */ +@Api("宸梾鎶ラ攢浠樻淇℃伅") +@RestController +@RequestMapping("/project/reimbursementpayee") +public class ServiceReimbursementpayeeController extends BaseController +{ + @Autowired + private IServiceReimbursementpayeeService serviceReimbursementpayeeService; + + /** + * 鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + */ + @ApiOperation("鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayee:list')") + @GetMapping("/list") + public TableDataInfo list(ServiceReimbursementpayee serviceReimbursementpayee) + { + startPage(); + List<ServiceReimbursementpayee> list = serviceReimbursementpayeeService.queryList(serviceReimbursementpayee); + return getDataTable(list); + } + + /** + * 瀵煎嚭宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + */ + @ApiOperation("瀵煎嚭宸梾鎶ラ攢浠樻淇℃伅鍒楄〃") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayee:export')") + @Log(title = "宸梾鎶ラ攢浠樻淇℃伅", businessType = BusinessType.EXPORT) + @GetMapping("/export") + public AjaxResult export(ServiceReimbursementpayee serviceReimbursementpayee) + { + List<ServiceReimbursementpayee> list = serviceReimbursementpayeeService.queryList(serviceReimbursementpayee); + ExcelUtil<ServiceReimbursementpayee> util = new ExcelUtil<ServiceReimbursementpayee>(ServiceReimbursementpayee.class); + return util.exportExcel(list, "宸梾鎶ラ攢浠樻淇℃伅鏁版嵁"); + } + + /** + * 鑾峰彇宸梾鎶ラ攢浠樻淇℃伅璇︾粏淇℃伅 + */ + @ApiOperation("鑾峰彇宸梾鎶ラ攢浠樻淇℃伅璇︾粏淇℃伅") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayee:query')") + @GetMapping(value = "/{id}") + public AjaxResult getInfo(@PathVariable("id") Long id) + { + return AjaxResult.success(serviceReimbursementpayeeService.getById(id)); + } + + /** + * 鏂板宸梾鎶ラ攢浠樻淇℃伅 + */ + @ApiOperation("鏂板宸梾鎶ラ攢浠樻淇℃伅") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayee:add')") + @Log(title = "宸梾鎶ラ攢浠樻淇℃伅", businessType = BusinessType.INSERT) + @PostMapping + @RepeatSubmit + public AjaxResult add(@RequestBody ServiceReimbursementpayee serviceReimbursementpayee) + { + return toAjax(serviceReimbursementpayeeService.save(serviceReimbursementpayee)); + } + + /** + * 淇敼宸梾鎶ラ攢浠樻淇℃伅 + */ + @ApiOperation("淇敼宸梾鎶ラ攢浠樻淇℃伅") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayee:edit')") + @Log(title = "宸梾鎶ラ攢浠樻淇℃伅", businessType = BusinessType.UPDATE) + @PutMapping + @RepeatSubmit + public AjaxResult edit(@RequestBody ServiceReimbursementpayee serviceReimbursementpayee) + { + return toAjax(serviceReimbursementpayeeService.updateById(serviceReimbursementpayee)); + } + + /** + * 鍒犻櫎宸梾鎶ラ攢浠樻淇℃伅 + */ + @ApiOperation("鍒犻櫎宸梾鎶ラ攢浠樻淇℃伅") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayee:remove')") + @Log(title = "宸梾鎶ラ攢浠樻淇℃伅", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(serviceReimbursementpayeeService.removeByIds(Arrays.asList(ids))); + } +} diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementpayeeSharedController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementpayeeSharedController.java new file mode 100644 index 0000000..415f643 --- /dev/null +++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/project/ServiceReimbursementpayeeSharedController.java @@ -0,0 +1,116 @@ +package com.ruoyi.project.controller; + +import java.util.Arrays; +import java.util.List; +import io.swagger.annotations.Api; +import io.swagger.annotations.ApiOperation; +import org.springframework.security.access.prepost.PreAuthorize; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.web.bind.annotation.GetMapping; +import org.springframework.web.bind.annotation.PostMapping; +import org.springframework.web.bind.annotation.PutMapping; +import org.springframework.web.bind.annotation.DeleteMapping; +import org.springframework.web.bind.annotation.PathVariable; +import org.springframework.web.bind.annotation.RequestBody; +import org.springframework.web.bind.annotation.RequestMapping; +import org.springframework.web.bind.annotation.RestController; +import com.ruoyi.common.annotation.Log; +import com.ruoyi.common.annotation.RepeatSubmit; +import com.ruoyi.common.core.controller.BaseController; +import com.ruoyi.common.core.domain.AjaxResult; +import com.ruoyi.common.enums.BusinessType; +import com.ruoyi.project.domain.ServiceReimbursementpayeeShared; +import com.ruoyi.project.service.IServiceReimbursementpayeeSharedService; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.common.core.page.TableDataInfo; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅Controller + * + * @author ruoyi + * @date 2023-04-20 + */ +@Api("宸梾鎶ラ攢浠樻淇℃伅") +@RestController +@RequestMapping("/project/reimbursementpayeeshared") +public class ServiceReimbursementpayeeSharedController extends BaseController +{ + @Autowired + private IServiceReimbursementpayeeSharedService serviceReimbursementpayeeSharedService; + + /** + * 鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + */ + @ApiOperation("鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayeeshared:list')") + @GetMapping("/list") + public TableDataInfo list(ServiceReimbursementpayeeShared serviceReimbursementpayeeShared) + { + startPage(); + List<ServiceReimbursementpayeeShared> list = serviceReimbursementpayeeSharedService.queryList(serviceReimbursementpayeeShared); + return getDataTable(list); + } + + /** + * 瀵煎嚭宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + */ + @ApiOperation("瀵煎嚭宸梾鎶ラ攢浠樻淇℃伅鍒楄〃") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayeeshared:export')") + @Log(title = "宸梾鎶ラ攢浠樻淇℃伅", businessType = BusinessType.EXPORT) + @GetMapping("/export") + public AjaxResult export(ServiceReimbursementpayeeShared serviceReimbursementpayeeShared) + { + List<ServiceReimbursementpayeeShared> list = serviceReimbursementpayeeSharedService.queryList(serviceReimbursementpayeeShared); + ExcelUtil<ServiceReimbursementpayeeShared> util = new ExcelUtil<ServiceReimbursementpayeeShared>(ServiceReimbursementpayeeShared.class); + return util.exportExcel(list, "宸梾鎶ラ攢浠樻淇℃伅鏁版嵁"); + } + + /** + * 鑾峰彇宸梾鎶ラ攢浠樻淇℃伅璇︾粏淇℃伅 + */ + @ApiOperation("鑾峰彇宸梾鎶ラ攢浠樻淇℃伅璇︾粏淇℃伅") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayeeshared:query')") + @GetMapping(value = "/{id}") + public AjaxResult getInfo(@PathVariable("id") Long id) + { + return AjaxResult.success(serviceReimbursementpayeeSharedService.getById(id)); + } + + /** + * 鏂板宸梾鎶ラ攢浠樻淇℃伅 + */ + @ApiOperation("鏂板宸梾鎶ラ攢浠樻淇℃伅") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayeeshared:add')") + @Log(title = "宸梾鎶ラ攢浠樻淇℃伅", businessType = BusinessType.INSERT) + @PostMapping + @RepeatSubmit + public AjaxResult add(@RequestBody ServiceReimbursementpayeeShared serviceReimbursementpayeeShared) + { + return toAjax(serviceReimbursementpayeeSharedService.save(serviceReimbursementpayeeShared)); + } + + /** + * 淇敼宸梾鎶ラ攢浠樻淇℃伅 + */ + @ApiOperation("淇敼宸梾鎶ラ攢浠樻淇℃伅") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayeeshared:edit')") + @Log(title = "宸梾鎶ラ攢浠樻淇℃伅", businessType = BusinessType.UPDATE) + @PutMapping + @RepeatSubmit + public AjaxResult edit(@RequestBody ServiceReimbursementpayeeShared serviceReimbursementpayeeShared) + { + return toAjax(serviceReimbursementpayeeSharedService.updateById(serviceReimbursementpayeeShared)); + } + + /** + * 鍒犻櫎宸梾鎶ラ攢浠樻淇℃伅 + */ + @ApiOperation("鍒犻櫎宸梾鎶ラ攢浠樻淇℃伅") + @PreAuthorize("@ss.hasPermi('project:reimbursementpayeeshared:remove')") + @Log(title = "宸梾鎶ラ攢浠樻淇℃伅", businessType = BusinessType.DELETE) + @DeleteMapping("/{ids}") + public AjaxResult remove(@PathVariable Long[] ids) + { + return toAjax(serviceReimbursementpayeeSharedService.removeByIds(Arrays.asList(ids))); + } +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFunddetailShared.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFunddetailShared.java new file mode 100644 index 0000000..f3475d9 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceFunddetailShared.java @@ -0,0 +1,275 @@ +package com.ruoyi.project.domain; + +import java.math.BigDecimal; +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +/** + * 璐圭敤鐢宠鏄庣粏瀵硅薄 service_funddetail_shared + * + * @author ruoyi + * @date 2023-04-20 + */ +@Data +@ApiModel("璐圭敤鐢宠鏄庣粏") +public class ServiceFunddetailShared extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** 涓婚敭ID */ + @ApiModelProperty("涓婚敭ID") + //鏁版嵁搴撹嚜澧炴敼鎴怈TableId(type = IdType.AUTO) + @TableId(type = IdType.AUTO) + private Long id; + + /** 璧勯噾鐢宠涓昏〃ID */ + @ApiModelProperty("璧勯噾鐢宠涓昏〃ID") + @Excel(name = "璧勯噾鐢宠涓昏〃ID") + private Long fundid; + + /** 椤哄簭鍙� */ + @ApiModelProperty("椤哄簭鍙�") + @Excel(name = "椤哄簭鍙�") + private Integer orderno; + + /** 椤圭洰ID */ + @ApiModelProperty("椤圭洰ID") + @Excel(name = "椤圭洰ID") + private Long itemid; + + /** 璐圭敤椤圭洰鏍囧彿 */ + @ApiModelProperty("璐圭敤椤圭洰鏍囧彿") + @Excel(name = "璐圭敤椤圭洰鏍囧彿") + private String itemcode; + + /** 椤圭洰鍚嶇О */ + @ApiModelProperty("椤圭洰鍚嶇О") + @Excel(name = "椤圭洰鍚嶇О") + private String itemname; + + /** 椤圭洰绫诲埆 */ + @ApiModelProperty("椤圭洰绫诲埆") + @Excel(name = "椤圭洰绫诲埆") + private String itemtype; + + /** 璧勯噾绫诲埆 */ + @ApiModelProperty("璧勯噾绫诲埆") + @Excel(name = "璧勯噾绫诲埆") + private String applytype; + + /** 璧勯噾绫诲埆鍚嶇О */ + @ApiModelProperty("璧勯噾绫诲埆鍚嶇О") + @Excel(name = "璧勯噾绫诲埆鍚嶇О") + private String applytypename; + + /** 鏀剁泭浜哄鍚� 瀹跺睘鎴栦笓瀹� */ + @ApiModelProperty("鏀剁泭浜哄鍚� 瀹跺睘鎴栦笓瀹�") + @Excel(name = "鏀剁泭浜哄鍚� 瀹跺睘鎴栦笓瀹�") + private String beneficiaryname; + + /** 鏀剁泭浜虹紪鍙� */ + @ApiModelProperty("鏀剁泭浜虹紪鍙�") + @Excel(name = "鏀剁泭浜虹紪鍙�") + private String beneficiaryno; + + /** 宸ヤ綔鍗曚綅 */ + @ApiModelProperty("宸ヤ綔鍗曚綅") + @Excel(name = "宸ヤ綔鍗曚綅") + private String unitname; + + /** 宸ヤ綔鍗曚綅缂栧彿 */ + @ApiModelProperty("宸ヤ綔鍗曚綅缂栧彿") + @Excel(name = "宸ヤ綔鍗曚綅缂栧彿") + private String unitno; + + /** 宸ヤ綔鍗曚綅鐢ㄦ埛缂栧彿 */ + @ApiModelProperty("宸ヤ綔鍗曚綅鐢ㄦ埛缂栧彿") + @Excel(name = "宸ヤ綔鍗曚綅鐢ㄦ埛缂栧彿") + private String unituserno; + + /** 鑱岀О,瑙佸瓧鍏竤ys_professionaltitle */ + @ApiModelProperty("鑱岀О,瑙佸瓧鍏竤ys_professionaltitle") + @Excel(name = "鑱岀О,瑙佸瓧鍏竤ys_professionaltitle") + private String title; + + /** 璇佷欢绫诲瀷 鏍规嵁瀛楀吀sys_IDType */ + @ApiModelProperty("璇佷欢绫诲瀷 鏍规嵁瀛楀吀sys_IDType") + @Excel(name = "璇佷欢绫诲瀷 鏍规嵁瀛楀吀sys_IDType") + private Long idcardtype; + + /** 璇佷欢鍙风爜 */ + @ApiModelProperty("璇佷欢鍙风爜") + @Excel(name = "璇佷欢鍙风爜") + private String idcardno; + + /** 鎬у埆 鏍规嵁瀛楀吀sys_user_sex */ + @ApiModelProperty("鎬у埆 鏍规嵁瀛楀吀sys_user_sex") + @Excel(name = "鎬у埆 鏍规嵁瀛楀吀sys_user_sex") + private String sex; + + /** 涓庢崘璧犺�呭叧绯� 鏍规嵁瀛楀吀sys_FamilyRelation */ + @ApiModelProperty("涓庢崘璧犺�呭叧绯� 鏍规嵁瀛楀吀sys_FamilyRelation") + @Excel(name = "涓庢崘璧犺�呭叧绯� 鏍规嵁瀛楀吀sys_FamilyRelation") + private String familyrelations; + + /** 鑱旂郴鐢佃瘽 */ + @ApiModelProperty("鑱旂郴鐢佃瘽") + @Excel(name = "鑱旂郴鐢佃瘽") + private String phone; + + /** 寮�鎴烽摱琛� */ + @ApiModelProperty("寮�鎴烽摱琛�") + @Excel(name = "寮�鎴烽摱琛�") + private String depositbank; + + /** 鍗″彿 */ + @ApiModelProperty("鍗″彿") + @Excel(name = "鍗″彿") + private String bankcardno; + + /** 鏀鍚嶇О */ + @ApiModelProperty("鏀鍚嶇О") + @Excel(name = "鏀鍚嶇О") + private String branchbankname; + + /** 閾惰鍗$収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑 */ + @ApiModelProperty("閾惰鍗$収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑") + @Excel(name = "閾惰鍗$収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑") + private String annexbankcard; + + /** 鐧昏琛ㄧ収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑 */ + @ApiModelProperty("鐧昏琛ㄧ収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑") + @Excel(name = "鐧昏琛ㄧ収鐗囪矾寰� 澶氫釜鐢�;鍒嗗紑") + private String annexregistform; + + /** 鏁伴噺 */ + @ApiModelProperty("鏁伴噺") + @Excel(name = "鏁伴噺") + private BigDecimal quantity; + + /** 浠锋牸 */ + @ApiModelProperty("浠锋牸") + @Excel(name = "浠锋牸") + private BigDecimal price; + + /** 鐢宠閲戦 */ + @ApiModelProperty("鐢宠閲戦") + @Excel(name = "鐢宠閲戦") + private BigDecimal amount; + + /** 鎵g◣閲戦 */ + @ApiModelProperty("鎵g◣閲戦") + @Excel(name = "鎵g◣閲戦") + private BigDecimal taxamount; + + /** 绋庡悗閲戦 */ + @ApiModelProperty("绋庡悗閲戦") + @Excel(name = "绋庡悗閲戦") + private BigDecimal taxedamount; + + /** 棰勬敮閲戦 */ + @ApiModelProperty("棰勬敮閲戦") + @Excel(name = "棰勬敮閲戦") + private BigDecimal prepaidamount; + + /** 浠樻閲戦 */ + @ApiModelProperty("浠樻閲戦") + @Excel(name = "浠樻閲戦") + private BigDecimal paidamount; + + /** 浠樻鏃堕棿 */ + @ApiModelProperty("浠樻鏃堕棿") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "浠樻鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date paidtime; + + /** 浠樻鏂瑰紡 */ + @ApiModelProperty("浠樻鏂瑰紡") + @Excel(name = "浠樻鏂瑰紡") + private String payterm; + + /** 鍙戠エ寮犳暟 */ + @ApiModelProperty("鍙戠エ寮犳暟") + @Excel(name = "鍙戠エ寮犳暟") + private Long invoicecount; + + /** 闄勪欢寮犳暟 */ + @ApiModelProperty("闄勪欢寮犳暟") + @Excel(name = "闄勪欢寮犳暟") + private Long attachcount; + + /** 鎹愮尞ID */ + @ApiModelProperty("鎹愮尞ID") + @Excel(name = "鎹愮尞ID") + private Long infoid; + + /** 鎹愮尞缂栧彿 */ + @ApiModelProperty("鎹愮尞缂栧彿") + @Excel(name = "鎹愮尞缂栧彿") + private String donorno; + + /** 鎹愮尞鑰呭鍚� */ + @ApiModelProperty("鎹愮尞鑰呭鍚�") + @Excel(name = "鎹愮尞鑰呭鍚�") + private String donorname; + + /** 璁板綍鐘舵�� */ + @ApiModelProperty("璁板綍鐘舵��") + @Excel(name = "璁板綍鐘舵��") + private String recordstatus; + + /** 涓婁紶鏍囧織 */ + @ApiModelProperty("涓婁紶鏍囧織") + @Excel(name = "涓婁紶鏍囧織") + private String uploadflag; + + /** 涓婁紶鏃堕棿 */ + @ApiModelProperty("涓婁紶鏃堕棿") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "涓婁紶鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date uploadtime; + + /** $column.columnComment */ + @ApiModelProperty("$column.columnComment") + @Excel(name = "涓婁紶鏃堕棿") + private String servicesscope; + + /** $column.columnComment */ + @ApiModelProperty("$column.columnComment") + @Excel(name = "涓婁紶鏃堕棿") + private String servicesscopename; + + /** $column.columnComment */ + @ApiModelProperty("$column.columnComment") + @Excel(name = "涓婁紶鏃堕棿") + private String servicetype; + + /** $column.columnComment */ + @ApiModelProperty("$column.columnComment") + @Excel(name = "涓婁紶鏃堕棿") + private String servicetypename; + + /** $column.columnComment */ + @ApiModelProperty("$column.columnComment") + @Excel(name = "涓婁紶鏃堕棿") + private BigDecimal reimbursementamount; + + /** 閲戦 */ + @ApiModelProperty("閲戦") + @Excel(name = "閲戦") + private String jine; + + /** 鐞嗙敱 */ + @ApiModelProperty("鐞嗙敱") + @Excel(name = "鐞嗙敱") + private String liyou; + +} + diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayee.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayee.java new file mode 100644 index 0000000..bce1b08 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayee.java @@ -0,0 +1,95 @@ +package com.ruoyi.project.domain; + +import java.math.BigDecimal; +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅瀵硅薄 service_reimbursementpayee + * + * @author ruoyi + * @date 2023-04-20 + */ +@Data +@ApiModel("宸梾鎶ラ攢浠樻淇℃伅") +public class ServiceReimbursementpayee extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** 涓婚敭ID */ + @ApiModelProperty("涓婚敭ID") + //鏁版嵁搴撹嚜澧炴敼鎴怈TableId(type = IdType.AUTO) + @TableId(type = IdType.AUTO) + private Long id; + + /** 璧勯噾鐢宠涓昏〃ID */ + @ApiModelProperty("璧勯噾鐢宠涓昏〃ID") + @Excel(name = "璧勯噾鐢宠涓昏〃ID") + private Long rbid; + + /** 椤哄簭鍙� */ + @ApiModelProperty("椤哄簭鍙�") + @Excel(name = "椤哄簭鍙�") + private Long orderno; + + /** 浜哄憳绫诲埆锛堝瓧鍏歌〃锛歴ys_travelexpensebelong锛夛細0锛氬叾浠栦汉鍛橈紱1锛氫笓鑱屼汉鍛橈紱2锛氬崗璋冨憳锛�3锛氫笓瀹讹紱4锛氭崘鐚�呭灞� */ + @ApiModelProperty("浜哄憳绫诲埆锛堝瓧鍏歌〃锛歴ys_travelexpensebelong锛夛細0锛氬叾浠栦汉鍛橈紱1锛氫笓鑱屼汉鍛橈紱2锛氬崗璋冨憳锛�3锛氫笓瀹讹紱4锛氭崘鐚�呭灞�") + @Excel(name = "浜哄憳绫诲埆", readConverterExp = "瀛�=鍏歌〃锛歴ys_travelexpensebelong") + private String persontype; + + /** 鏀剁泭浜哄鍚� 瀹跺睘鎴栦笓瀹� */ + @ApiModelProperty("鏀剁泭浜哄鍚� 瀹跺睘鎴栦笓瀹�") + @Excel(name = "鏀剁泭浜哄鍚� 瀹跺睘鎴栦笓瀹�") + private String personname; + + /** 寮�鎴烽摱琛� */ + @ApiModelProperty("寮�鎴烽摱琛�") + @Excel(name = "寮�鎴烽摱琛�") + private String bankname; + + /** 鍗″彿 */ + @ApiModelProperty("鍗″彿") + @Excel(name = "鍗″彿") + private String bankcardno; + + /** 鐢宠閲戦 */ + @ApiModelProperty("鐢宠閲戦") + @Excel(name = "鐢宠閲戦") + private BigDecimal amount; + + /** 鑱旂郴鐢佃瘽 */ + @ApiModelProperty("鑱旂郴鐢佃瘽") + @Excel(name = "鑱旂郴鐢佃瘽") + private String phone; + + /** 涓庢崘璧犺�呭叧绯� 鏍规嵁瀛楀吀sys_FamilyRelation */ + @ApiModelProperty("涓庢崘璧犺�呭叧绯� 鏍规嵁瀛楀吀sys_FamilyRelation") + @Excel(name = "涓庢崘璧犺�呭叧绯� 鏍规嵁瀛楀吀sys_FamilyRelation") + private String familyrelations; + + /** 浠樻鏃ユ湡 */ + @ApiModelProperty("浠樻鏃ユ湡") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "浠樻鏃ユ湡", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date paiddate; + + /** 涓婁紶鏍囧織 */ + @ApiModelProperty("涓婁紶鏍囧織") + @Excel(name = "涓婁紶鏍囧織") + private String uploadflag; + + /** 涓婁紶鏃堕棿 */ + @ApiModelProperty("涓婁紶鏃堕棿") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "涓婁紶鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date uploadtime; + +} + diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayeeShared.java b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayeeShared.java new file mode 100644 index 0000000..471d389 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/domain/ServiceReimbursementpayeeShared.java @@ -0,0 +1,100 @@ +package com.ruoyi.project.domain; + +import java.math.BigDecimal; +import java.util.Date; +import com.fasterxml.jackson.annotation.JsonFormat; +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.ruoyi.common.annotation.Excel; +import com.ruoyi.common.core.domain.BaseEntity; +import io.swagger.annotations.ApiModel; +import io.swagger.annotations.ApiModelProperty; +import lombok.Data; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅瀵硅薄 service_reimbursementpayee_shared + * + * @author ruoyi + * @date 2023-04-20 + */ +@Data +@ApiModel("宸梾鎶ラ攢浠樻淇℃伅") +public class ServiceReimbursementpayeeShared extends BaseEntity +{ + private static final long serialVersionUID = 1L; + + /** 涓婚敭ID */ + @ApiModelProperty("涓婚敭ID") + //鏁版嵁搴撹嚜澧炴敼鎴怈TableId(type = IdType.AUTO) + @TableId(type = IdType.AUTO) + private Long id; + + /** 璧勯噾浠樻琛↖D */ + @ApiModelProperty("璧勯噾浠樻琛↖D") + @Excel(name = "璧勯噾浠樻琛↖D") + private Long rpid; + + /** 璧勯噾鐢宠涓昏〃ID */ + @ApiModelProperty("璧勯噾鐢宠涓昏〃ID") + @Excel(name = "璧勯噾鐢宠涓昏〃ID") + private Long rbid; + + /** 椤哄簭鍙� */ + @ApiModelProperty("椤哄簭鍙�") + @Excel(name = "椤哄簭鍙�") + private Long orderno; + + /** 浜哄憳绫诲埆锛堝瓧鍏歌〃锛歴ys_travelexpensebelong锛夛細0锛氬叾浠栦汉鍛橈紱1锛氫笓鑱屼汉鍛橈紱2锛氬崗璋冨憳锛�3锛氫笓瀹讹紱4锛氭崘鐚�呭灞� */ + @ApiModelProperty("浜哄憳绫诲埆锛堝瓧鍏歌〃锛歴ys_travelexpensebelong锛夛細0锛氬叾浠栦汉鍛橈紱1锛氫笓鑱屼汉鍛橈紱2锛氬崗璋冨憳锛�3锛氫笓瀹讹紱4锛氭崘鐚�呭灞�") + @Excel(name = "浜哄憳绫诲埆", readConverterExp = "瀛�=鍏歌〃锛歴ys_travelexpensebelong") + private String persontype; + + /** 鏀剁泭浜哄鍚� 瀹跺睘鎴栦笓瀹� */ + @ApiModelProperty("鏀剁泭浜哄鍚� 瀹跺睘鎴栦笓瀹�") + @Excel(name = "鏀剁泭浜哄鍚� 瀹跺睘鎴栦笓瀹�") + private String personname; + + /** 寮�鎴烽摱琛� */ + @ApiModelProperty("寮�鎴烽摱琛�") + @Excel(name = "寮�鎴烽摱琛�") + private String bankname; + + /** 鍗″彿 */ + @ApiModelProperty("鍗″彿") + @Excel(name = "鍗″彿") + private String bankcardno; + + /** 鐢宠閲戦 */ + @ApiModelProperty("鐢宠閲戦") + @Excel(name = "鐢宠閲戦") + private BigDecimal amount; + + /** 鑱旂郴鐢佃瘽 */ + @ApiModelProperty("鑱旂郴鐢佃瘽") + @Excel(name = "鑱旂郴鐢佃瘽") + private String phone; + + /** 涓庢崘璧犺�呭叧绯� 鏍规嵁瀛楀吀sys_FamilyRelation */ + @ApiModelProperty("涓庢崘璧犺�呭叧绯� 鏍规嵁瀛楀吀sys_FamilyRelation") + @Excel(name = "涓庢崘璧犺�呭叧绯� 鏍规嵁瀛楀吀sys_FamilyRelation") + private String familyrelations; + + /** 浠樻鏃ユ湡 */ + @ApiModelProperty("浠樻鏃ユ湡") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "浠樻鏃ユ湡", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date paiddate; + + /** 涓婁紶鏍囧織 */ + @ApiModelProperty("涓婁紶鏍囧織") + @Excel(name = "涓婁紶鏍囧織") + private String uploadflag; + + /** 涓婁紶鏃堕棿 */ + @ApiModelProperty("涓婁紶鏃堕棿") + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + @Excel(name = "涓婁紶鏃堕棿", width = 30, dateFormat = "yyyy-MM-dd HH:mm:ss") + private Date uploadtime; + +} + diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailSharedMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailSharedMapper.java new file mode 100644 index 0000000..7cd54a0 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceFunddetailSharedMapper.java @@ -0,0 +1,23 @@ +package com.ruoyi.project.mapper; + + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import java.util.List; +import com.ruoyi.project.domain.ServiceFunddetailShared; + +/** + * 璐圭敤鐢宠鏄庣粏Mapper鎺ュ彛 + * + * @author ruoyi + * @date 2023-04-20 + */ +public interface ServiceFunddetailSharedMapper extends BaseMapper<ServiceFunddetailShared> +{ + /** + * 鏌ヨ璐圭敤鐢宠鏄庣粏鍒楄〃 + * + * @param serviceFunddetailShared 璐圭敤鐢宠鏄庣粏 + * @return 璐圭敤鐢宠鏄庣粏闆嗗悎 + */ + public List<ServiceFunddetailShared> selectServiceFunddetailSharedList(ServiceFunddetailShared serviceFunddetailShared); +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementpayeeMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementpayeeMapper.java new file mode 100644 index 0000000..9975c0c --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementpayeeMapper.java @@ -0,0 +1,23 @@ +package com.ruoyi.project.mapper; + + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import java.util.List; +import com.ruoyi.project.domain.ServiceReimbursementpayee; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅Mapper鎺ュ彛 + * + * @author ruoyi + * @date 2023-04-20 + */ +public interface ServiceReimbursementpayeeMapper extends BaseMapper<ServiceReimbursementpayee> +{ + /** + * 鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + * + * @param serviceReimbursementpayee 宸梾鎶ラ攢浠樻淇℃伅 + * @return 宸梾鎶ラ攢浠樻淇℃伅闆嗗悎 + */ + public List<ServiceReimbursementpayee> selectServiceReimbursementpayeeList(ServiceReimbursementpayee serviceReimbursementpayee); +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementpayeeSharedMapper.java b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementpayeeSharedMapper.java new file mode 100644 index 0000000..467b0a9 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/mapper/ServiceReimbursementpayeeSharedMapper.java @@ -0,0 +1,23 @@ +package com.ruoyi.project.mapper; + + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import java.util.List; +import com.ruoyi.project.domain.ServiceReimbursementpayeeShared; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅Mapper鎺ュ彛 + * + * @author ruoyi + * @date 2023-04-20 + */ +public interface ServiceReimbursementpayeeSharedMapper extends BaseMapper<ServiceReimbursementpayeeShared> +{ + /** + * 鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + * + * @param serviceReimbursementpayeeShared 宸梾鎶ラ攢浠樻淇℃伅 + * @return 宸梾鎶ラ攢浠樻淇℃伅闆嗗悎 + */ + public List<ServiceReimbursementpayeeShared> selectServiceReimbursementpayeeSharedList(ServiceReimbursementpayeeShared serviceReimbursementpayeeShared); +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceFunddetailSharedService.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceFunddetailSharedService.java new file mode 100644 index 0000000..6616b2f --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceFunddetailSharedService.java @@ -0,0 +1,23 @@ +package com.ruoyi.project.service; + +import java.util.List; +import com.baomidou.mybatisplus.extension.service.IService; +import com.ruoyi.project.domain.ServiceFunddetailShared; + +/** + * 璐圭敤鐢宠鏄庣粏Service鎺ュ彛 + * + * @author ruoyi + * @date 2023-04-20 + */ +public interface IServiceFunddetailSharedService extends IService<ServiceFunddetailShared> +{ + + /** + * 鏌ヨ璐圭敤鐢宠鏄庣粏鍒楄〃 + * + * @param serviceFunddetailShared 璐圭敤鐢宠鏄庣粏 + * @return 璐圭敤鐢宠鏄庣粏闆嗗悎 + */ + public List<ServiceFunddetailShared> queryList(ServiceFunddetailShared serviceFunddetailShared); +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementpayeeService.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementpayeeService.java new file mode 100644 index 0000000..6edea53 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementpayeeService.java @@ -0,0 +1,23 @@ +package com.ruoyi.project.service; + +import java.util.List; +import com.baomidou.mybatisplus.extension.service.IService; +import com.ruoyi.project.domain.ServiceReimbursementpayee; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅Service鎺ュ彛 + * + * @author ruoyi + * @date 2023-04-20 + */ +public interface IServiceReimbursementpayeeService extends IService<ServiceReimbursementpayee> +{ + + /** + * 鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + * + * @param serviceReimbursementpayee 宸梾鎶ラ攢浠樻淇℃伅 + * @return 宸梾鎶ラ攢浠樻淇℃伅闆嗗悎 + */ + public List<ServiceReimbursementpayee> queryList(ServiceReimbursementpayee serviceReimbursementpayee); +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementpayeeSharedService.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementpayeeSharedService.java new file mode 100644 index 0000000..4a25544 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/IServiceReimbursementpayeeSharedService.java @@ -0,0 +1,23 @@ +package com.ruoyi.project.service; + +import java.util.List; +import com.baomidou.mybatisplus.extension.service.IService; +import com.ruoyi.project.domain.ServiceReimbursementpayeeShared; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅Service鎺ュ彛 + * + * @author ruoyi + * @date 2023-04-20 + */ +public interface IServiceReimbursementpayeeSharedService extends IService<ServiceReimbursementpayeeShared> +{ + + /** + * 鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + * + * @param serviceReimbursementpayeeShared 宸梾鎶ラ攢浠樻淇℃伅 + * @return 宸梾鎶ラ攢浠樻淇℃伅闆嗗悎 + */ + public List<ServiceReimbursementpayeeShared> queryList(ServiceReimbursementpayeeShared serviceReimbursementpayeeShared); +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFunddetailSharedServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFunddetailSharedServiceImpl.java new file mode 100644 index 0000000..d529e85 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceFunddetailSharedServiceImpl.java @@ -0,0 +1,187 @@ +package com.ruoyi.project.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import java.util.ArrayList; +import java.util.Map; +import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.project.mapper.ServiceFunddetailSharedMapper; +import com.ruoyi.project.domain.ServiceFunddetailShared; +import com.ruoyi.project.service.IServiceFunddetailSharedService; + +/** + * 璐圭敤鐢宠鏄庣粏Service涓氬姟灞傚鐞� + * + * @author ruoyi + * @date 2023-04-20 + */ +@Service +public class ServiceFunddetailSharedServiceImpl extends ServiceImpl<ServiceFunddetailSharedMapper, ServiceFunddetailShared> implements IServiceFunddetailSharedService +{ + + + /** + * 鏌ヨ璐圭敤鐢宠鏄庣粏鍒楄〃 + * + * @param serviceFunddetailShared 璐圭敤鐢宠鏄庣粏 + * @return 璐圭敤鐢宠鏄庣粏 + */ + @Override + public List<ServiceFunddetailShared> queryList(ServiceFunddetailShared serviceFunddetailShared) { + LambdaQueryWrapper<ServiceFunddetailShared> wrappers = Wrappers.lambdaQuery(); + if (serviceFunddetailShared.getFundid() != null){ + wrappers.eq(ServiceFunddetailShared::getFundid ,serviceFunddetailShared.getFundid()); + } + if (serviceFunddetailShared.getOrderno() != null){ + wrappers.eq(ServiceFunddetailShared::getOrderno ,serviceFunddetailShared.getOrderno()); + } + if (serviceFunddetailShared.getItemid() != null){ + wrappers.eq(ServiceFunddetailShared::getItemid ,serviceFunddetailShared.getItemid()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getItemcode())){ + wrappers.eq(ServiceFunddetailShared::getItemcode ,serviceFunddetailShared.getItemcode()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getItemname())){ + wrappers.like(ServiceFunddetailShared::getItemname ,serviceFunddetailShared.getItemname()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getItemtype())){ + wrappers.eq(ServiceFunddetailShared::getItemtype ,serviceFunddetailShared.getItemtype()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getApplytype())){ + wrappers.eq(ServiceFunddetailShared::getApplytype ,serviceFunddetailShared.getApplytype()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getApplytypename())){ + wrappers.like(ServiceFunddetailShared::getApplytypename ,serviceFunddetailShared.getApplytypename()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getBeneficiaryname())){ + wrappers.like(ServiceFunddetailShared::getBeneficiaryname ,serviceFunddetailShared.getBeneficiaryname()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getBeneficiaryno())){ + wrappers.eq(ServiceFunddetailShared::getBeneficiaryno ,serviceFunddetailShared.getBeneficiaryno()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getUnitname())){ + wrappers.like(ServiceFunddetailShared::getUnitname ,serviceFunddetailShared.getUnitname()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getUnitno())){ + wrappers.eq(ServiceFunddetailShared::getUnitno ,serviceFunddetailShared.getUnitno()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getUnituserno())){ + wrappers.eq(ServiceFunddetailShared::getUnituserno ,serviceFunddetailShared.getUnituserno()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getTitle())){ + wrappers.eq(ServiceFunddetailShared::getTitle ,serviceFunddetailShared.getTitle()); + } + if (serviceFunddetailShared.getIdcardtype() != null){ + wrappers.eq(ServiceFunddetailShared::getIdcardtype ,serviceFunddetailShared.getIdcardtype()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getIdcardno())){ + wrappers.eq(ServiceFunddetailShared::getIdcardno ,serviceFunddetailShared.getIdcardno()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getSex())){ + wrappers.eq(ServiceFunddetailShared::getSex ,serviceFunddetailShared.getSex()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getFamilyrelations())){ + wrappers.eq(ServiceFunddetailShared::getFamilyrelations ,serviceFunddetailShared.getFamilyrelations()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getPhone())){ + wrappers.eq(ServiceFunddetailShared::getPhone ,serviceFunddetailShared.getPhone()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getDepositbank())){ + wrappers.eq(ServiceFunddetailShared::getDepositbank ,serviceFunddetailShared.getDepositbank()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getBankcardno())){ + wrappers.eq(ServiceFunddetailShared::getBankcardno ,serviceFunddetailShared.getBankcardno()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getBranchbankname())){ + wrappers.like(ServiceFunddetailShared::getBranchbankname ,serviceFunddetailShared.getBranchbankname()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getAnnexbankcard())){ + wrappers.eq(ServiceFunddetailShared::getAnnexbankcard ,serviceFunddetailShared.getAnnexbankcard()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getAnnexregistform())){ + wrappers.eq(ServiceFunddetailShared::getAnnexregistform ,serviceFunddetailShared.getAnnexregistform()); + } + if (serviceFunddetailShared.getQuantity() != null){ + wrappers.eq(ServiceFunddetailShared::getQuantity ,serviceFunddetailShared.getQuantity()); + } + if (serviceFunddetailShared.getPrice() != null){ + wrappers.eq(ServiceFunddetailShared::getPrice ,serviceFunddetailShared.getPrice()); + } + if (serviceFunddetailShared.getAmount() != null){ + wrappers.eq(ServiceFunddetailShared::getAmount ,serviceFunddetailShared.getAmount()); + } + if (serviceFunddetailShared.getTaxamount() != null){ + wrappers.eq(ServiceFunddetailShared::getTaxamount ,serviceFunddetailShared.getTaxamount()); + } + if (serviceFunddetailShared.getTaxedamount() != null){ + wrappers.eq(ServiceFunddetailShared::getTaxedamount ,serviceFunddetailShared.getTaxedamount()); + } + if (serviceFunddetailShared.getPrepaidamount() != null){ + wrappers.eq(ServiceFunddetailShared::getPrepaidamount ,serviceFunddetailShared.getPrepaidamount()); + } + if (serviceFunddetailShared.getPaidamount() != null){ + wrappers.eq(ServiceFunddetailShared::getPaidamount ,serviceFunddetailShared.getPaidamount()); + } + if (serviceFunddetailShared.getPaidtime() != null){ + wrappers.eq(ServiceFunddetailShared::getPaidtime ,serviceFunddetailShared.getPaidtime()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getPayterm())){ + wrappers.eq(ServiceFunddetailShared::getPayterm ,serviceFunddetailShared.getPayterm()); + } + if (serviceFunddetailShared.getInvoicecount() != null){ + wrappers.eq(ServiceFunddetailShared::getInvoicecount ,serviceFunddetailShared.getInvoicecount()); + } + if (serviceFunddetailShared.getAttachcount() != null){ + wrappers.eq(ServiceFunddetailShared::getAttachcount ,serviceFunddetailShared.getAttachcount()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getRemark())){ + wrappers.eq(ServiceFunddetailShared::getRemark ,serviceFunddetailShared.getRemark()); + } + if (serviceFunddetailShared.getInfoid() != null){ + wrappers.eq(ServiceFunddetailShared::getInfoid ,serviceFunddetailShared.getInfoid()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getDonorno())){ + wrappers.eq(ServiceFunddetailShared::getDonorno ,serviceFunddetailShared.getDonorno()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getDonorname())){ + wrappers.like(ServiceFunddetailShared::getDonorname ,serviceFunddetailShared.getDonorname()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getRecordstatus())){ + wrappers.eq(ServiceFunddetailShared::getRecordstatus ,serviceFunddetailShared.getRecordstatus()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getUploadflag())){ + wrappers.eq(ServiceFunddetailShared::getUploadflag ,serviceFunddetailShared.getUploadflag()); + } + if (serviceFunddetailShared.getUploadtime() != null){ + wrappers.eq(ServiceFunddetailShared::getUploadtime ,serviceFunddetailShared.getUploadtime()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getServicesscope())){ + wrappers.eq(ServiceFunddetailShared::getServicesscope ,serviceFunddetailShared.getServicesscope()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getServicesscopename())){ + wrappers.like(ServiceFunddetailShared::getServicesscopename ,serviceFunddetailShared.getServicesscopename()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getServicetype())){ + wrappers.eq(ServiceFunddetailShared::getServicetype ,serviceFunddetailShared.getServicetype()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getServicetypename())){ + wrappers.like(ServiceFunddetailShared::getServicetypename ,serviceFunddetailShared.getServicetypename()); + } + if (serviceFunddetailShared.getReimbursementamount() != null){ + wrappers.eq(ServiceFunddetailShared::getReimbursementamount ,serviceFunddetailShared.getReimbursementamount()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getJine())){ + wrappers.eq(ServiceFunddetailShared::getJine ,serviceFunddetailShared.getJine()); + } + if (StringUtils.isNotBlank(serviceFunddetailShared.getLiyou())){ + wrappers.eq(ServiceFunddetailShared::getLiyou ,serviceFunddetailShared.getLiyou()); + } + return this.list(wrappers); + } + +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementpayeeServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementpayeeServiceImpl.java new file mode 100644 index 0000000..a14dde6 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementpayeeServiceImpl.java @@ -0,0 +1,76 @@ +package com.ruoyi.project.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import java.util.ArrayList; +import java.util.Map; +import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.project.mapper.ServiceReimbursementpayeeMapper; +import com.ruoyi.project.domain.ServiceReimbursementpayee; +import com.ruoyi.project.service.IServiceReimbursementpayeeService; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅Service涓氬姟灞傚鐞� + * + * @author ruoyi + * @date 2023-04-20 + */ +@Service +public class ServiceReimbursementpayeeServiceImpl extends ServiceImpl<ServiceReimbursementpayeeMapper, ServiceReimbursementpayee> implements IServiceReimbursementpayeeService +{ + + + /** + * 鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + * + * @param serviceReimbursementpayee 宸梾鎶ラ攢浠樻淇℃伅 + * @return 宸梾鎶ラ攢浠樻淇℃伅 + */ + @Override + public List<ServiceReimbursementpayee> queryList(ServiceReimbursementpayee serviceReimbursementpayee) { + LambdaQueryWrapper<ServiceReimbursementpayee> wrappers = Wrappers.lambdaQuery(); + if (serviceReimbursementpayee.getRbid() != null){ + wrappers.eq(ServiceReimbursementpayee::getRbid ,serviceReimbursementpayee.getRbid()); + } + if (serviceReimbursementpayee.getOrderno() != null){ + wrappers.eq(ServiceReimbursementpayee::getOrderno ,serviceReimbursementpayee.getOrderno()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayee.getPersontype())){ + wrappers.eq(ServiceReimbursementpayee::getPersontype ,serviceReimbursementpayee.getPersontype()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayee.getPersonname())){ + wrappers.like(ServiceReimbursementpayee::getPersonname ,serviceReimbursementpayee.getPersonname()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayee.getBankname())){ + wrappers.like(ServiceReimbursementpayee::getBankname ,serviceReimbursementpayee.getBankname()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayee.getBankcardno())){ + wrappers.eq(ServiceReimbursementpayee::getBankcardno ,serviceReimbursementpayee.getBankcardno()); + } + if (serviceReimbursementpayee.getAmount() != null){ + wrappers.eq(ServiceReimbursementpayee::getAmount ,serviceReimbursementpayee.getAmount()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayee.getPhone())){ + wrappers.eq(ServiceReimbursementpayee::getPhone ,serviceReimbursementpayee.getPhone()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayee.getFamilyrelations())){ + wrappers.eq(ServiceReimbursementpayee::getFamilyrelations ,serviceReimbursementpayee.getFamilyrelations()); + } + if (serviceReimbursementpayee.getPaiddate() != null){ + wrappers.eq(ServiceReimbursementpayee::getPaiddate ,serviceReimbursementpayee.getPaiddate()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayee.getUploadflag())){ + wrappers.eq(ServiceReimbursementpayee::getUploadflag ,serviceReimbursementpayee.getUploadflag()); + } + if (serviceReimbursementpayee.getUploadtime() != null){ + wrappers.eq(ServiceReimbursementpayee::getUploadtime ,serviceReimbursementpayee.getUploadtime()); + } + return this.list(wrappers); + } + +} diff --git a/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementpayeeSharedServiceImpl.java b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementpayeeSharedServiceImpl.java new file mode 100644 index 0000000..86c6913 --- /dev/null +++ b/ruoyi-project/src/main/java/com/ruoyi/project/service/impl/ServiceReimbursementpayeeSharedServiceImpl.java @@ -0,0 +1,79 @@ +package com.ruoyi.project.service.impl; + +import java.util.List; +import com.ruoyi.common.utils.DateUtils; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.toolkit.Wrappers; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import java.util.ArrayList; +import java.util.Map; +import com.ruoyi.common.utils.StringUtils; +import com.ruoyi.project.mapper.ServiceReimbursementpayeeSharedMapper; +import com.ruoyi.project.domain.ServiceReimbursementpayeeShared; +import com.ruoyi.project.service.IServiceReimbursementpayeeSharedService; + +/** + * 宸梾鎶ラ攢浠樻淇℃伅Service涓氬姟灞傚鐞� + * + * @author ruoyi + * @date 2023-04-20 + */ +@Service +public class ServiceReimbursementpayeeSharedServiceImpl extends ServiceImpl<ServiceReimbursementpayeeSharedMapper, ServiceReimbursementpayeeShared> implements IServiceReimbursementpayeeSharedService +{ + + + /** + * 鏌ヨ宸梾鎶ラ攢浠樻淇℃伅鍒楄〃 + * + * @param serviceReimbursementpayeeShared 宸梾鎶ラ攢浠樻淇℃伅 + * @return 宸梾鎶ラ攢浠樻淇℃伅 + */ + @Override + public List<ServiceReimbursementpayeeShared> queryList(ServiceReimbursementpayeeShared serviceReimbursementpayeeShared) { + LambdaQueryWrapper<ServiceReimbursementpayeeShared> wrappers = Wrappers.lambdaQuery(); + if (serviceReimbursementpayeeShared.getRpid() != null){ + wrappers.eq(ServiceReimbursementpayeeShared::getRpid ,serviceReimbursementpayeeShared.getRpid()); + } + if (serviceReimbursementpayeeShared.getRbid() != null){ + wrappers.eq(ServiceReimbursementpayeeShared::getRbid ,serviceReimbursementpayeeShared.getRbid()); + } + if (serviceReimbursementpayeeShared.getOrderno() != null){ + wrappers.eq(ServiceReimbursementpayeeShared::getOrderno ,serviceReimbursementpayeeShared.getOrderno()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayeeShared.getPersontype())){ + wrappers.eq(ServiceReimbursementpayeeShared::getPersontype ,serviceReimbursementpayeeShared.getPersontype()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayeeShared.getPersonname())){ + wrappers.like(ServiceReimbursementpayeeShared::getPersonname ,serviceReimbursementpayeeShared.getPersonname()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayeeShared.getBankname())){ + wrappers.like(ServiceReimbursementpayeeShared::getBankname ,serviceReimbursementpayeeShared.getBankname()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayeeShared.getBankcardno())){ + wrappers.eq(ServiceReimbursementpayeeShared::getBankcardno ,serviceReimbursementpayeeShared.getBankcardno()); + } + if (serviceReimbursementpayeeShared.getAmount() != null){ + wrappers.eq(ServiceReimbursementpayeeShared::getAmount ,serviceReimbursementpayeeShared.getAmount()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayeeShared.getPhone())){ + wrappers.eq(ServiceReimbursementpayeeShared::getPhone ,serviceReimbursementpayeeShared.getPhone()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayeeShared.getFamilyrelations())){ + wrappers.eq(ServiceReimbursementpayeeShared::getFamilyrelations ,serviceReimbursementpayeeShared.getFamilyrelations()); + } + if (serviceReimbursementpayeeShared.getPaiddate() != null){ + wrappers.eq(ServiceReimbursementpayeeShared::getPaiddate ,serviceReimbursementpayeeShared.getPaiddate()); + } + if (StringUtils.isNotBlank(serviceReimbursementpayeeShared.getUploadflag())){ + wrappers.eq(ServiceReimbursementpayeeShared::getUploadflag ,serviceReimbursementpayeeShared.getUploadflag()); + } + if (serviceReimbursementpayeeShared.getUploadtime() != null){ + wrappers.eq(ServiceReimbursementpayeeShared::getUploadtime ,serviceReimbursementpayeeShared.getUploadtime()); + } + return this.list(wrappers); + } + +} diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailSharedMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailSharedMapper.xml new file mode 100644 index 0000000..b0276bc --- /dev/null +++ b/ruoyi-project/src/main/resources/mapper/project/ServiceFunddetailSharedMapper.xml @@ -0,0 +1,124 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.ruoyi.project.mapper.ServiceFunddetailSharedMapper"> + + <resultMap type="ServiceFunddetailShared" id="ServiceFunddetailSharedResult"> + <result property="id" column="ID" /> + <result property="fundid" column="fundID" /> + <result property="orderno" column="OrderNo" /> + <result property="itemid" column="ItemID" /> + <result property="itemcode" column="ItemCode" /> + <result property="itemname" column="ItemName" /> + <result property="itemtype" column="ItemType" /> + <result property="applytype" column="ApplyType" /> + <result property="applytypename" column="ApplyTypeName" /> + <result property="beneficiaryname" column="BeneficiaryName" /> + <result property="beneficiaryno" column="BeneficiaryNo" /> + <result property="unitname" column="UnitName" /> + <result property="unitno" column="UnitNo" /> + <result property="unituserno" column="UnitUserNo" /> + <result property="title" column="Title" /> + <result property="idcardtype" column="IDCardType" /> + <result property="idcardno" column="IDCardNo" /> + <result property="sex" column="Sex" /> + <result property="familyrelations" column="FamilyRelations" /> + <result property="phone" column="Phone" /> + <result property="depositbank" column="DepositBank" /> + <result property="bankcardno" column="BankCardNo" /> + <result property="branchbankname" column="BranchBankName" /> + <result property="annexbankcard" column="AnnexBankCard" /> + <result property="annexregistform" column="AnnexRegistForm" /> + <result property="quantity" column="Quantity" /> + <result property="price" column="Price" /> + <result property="amount" column="Amount" /> + <result property="taxamount" column="TaxAmount" /> + <result property="taxedamount" column="TaxedAmount" /> + <result property="prepaidamount" column="PrepaidAmount" /> + <result property="paidamount" column="paidAmount" /> + <result property="paidtime" column="paidTime" /> + <result property="payterm" column="payTerm" /> + <result property="invoicecount" column="InvoiceCount" /> + <result property="attachcount" column="AttachCount" /> + <result property="remark" column="Remark" /> + <result property="infoid" column="InfoId" /> + <result property="donorno" column="DonorNo" /> + <result property="donorname" column="DonorName" /> + <result property="recordstatus" column="RecordStatus" /> + <result property="delFlag" column="del_flag" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="uploadflag" column="uploadflag" /> + <result property="uploadtime" column="uploadtime" /> + <result property="servicesscope" column="SERVICESSCOPE" /> + <result property="servicesscopename" column="SERVICESSCOPENAME" /> + <result property="servicetype" column="SERVICETYPE" /> + <result property="servicetypename" column="SERVICETYPENAME" /> + <result property="reimbursementamount" column="REIMBURSEMENTAMOUNT" /> + <result property="jine" column="jine" /> + <result property="liyou" column="liyou" /> + </resultMap> + + <sql id="selectServiceFunddetailSharedVo"> + select ID, fundID, OrderNo, ItemID, ItemCode, ItemName, ItemType, ApplyType, ApplyTypeName, BeneficiaryName, BeneficiaryNo, UnitName, UnitNo, UnitUserNo, Title, IDCardType, IDCardNo, Sex, FamilyRelations, Phone, DepositBank, BankCardNo, BranchBankName, AnnexBankCard, AnnexRegistForm, Quantity, Price, Amount, TaxAmount, TaxedAmount, PrepaidAmount, paidAmount, paidTime, payTerm, InvoiceCount, AttachCount, Remark, InfoId, DonorNo, DonorName, RecordStatus, del_flag, create_by, create_time, update_by, update_time, uploadflag, uploadtime, SERVICESSCOPE, SERVICESSCOPENAME, SERVICETYPE, SERVICETYPENAME, REIMBURSEMENTAMOUNT, jine, liyou from service_funddetail_shared + </sql> + + <select id="selectServiceFunddetailSharedList" parameterType="ServiceFunddetailShared" resultMap="ServiceFunddetailSharedResult"> + <include refid="selectServiceFunddetailSharedVo"/> + <where> + <if test="fundid != null "> and fundID = #{fundid}</if> + <if test="orderno != null "> and OrderNo = #{orderno}</if> + <if test="itemid != null "> and ItemID = #{itemid}</if> + <if test="itemcode != null and itemcode != ''"> and ItemCode = #{itemcode}</if> + <if test="itemname != null and itemname != ''"> and ItemName like concat('%', #{itemname}, '%')</if> + <if test="itemtype != null and itemtype != ''"> and ItemType = #{itemtype}</if> + <if test="applytype != null and applytype != ''"> and ApplyType = #{applytype}</if> + <if test="applytypename != null and applytypename != ''"> and ApplyTypeName like concat('%', #{applytypename}, '%')</if> + <if test="beneficiaryname != null and beneficiaryname != ''"> and BeneficiaryName like concat('%', #{beneficiaryname}, '%')</if> + <if test="beneficiaryno != null and beneficiaryno != ''"> and BeneficiaryNo = #{beneficiaryno}</if> + <if test="unitname != null and unitname != ''"> and UnitName like concat('%', #{unitname}, '%')</if> + <if test="unitno != null and unitno != ''"> and UnitNo = #{unitno}</if> + <if test="unituserno != null and unituserno != ''"> and UnitUserNo = #{unituserno}</if> + <if test="title != null and title != ''"> and Title = #{title}</if> + <if test="idcardtype != null "> and IDCardType = #{idcardtype}</if> + <if test="idcardno != null and idcardno != ''"> and IDCardNo = #{idcardno}</if> + <if test="sex != null and sex != ''"> and Sex = #{sex}</if> + <if test="familyrelations != null and familyrelations != ''"> and FamilyRelations = #{familyrelations}</if> + <if test="phone != null and phone != ''"> and Phone = #{phone}</if> + <if test="depositbank != null and depositbank != ''"> and DepositBank = #{depositbank}</if> + <if test="bankcardno != null and bankcardno != ''"> and BankCardNo = #{bankcardno}</if> + <if test="branchbankname != null and branchbankname != ''"> and BranchBankName like concat('%', #{branchbankname}, '%')</if> + <if test="annexbankcard != null and annexbankcard != ''"> and AnnexBankCard = #{annexbankcard}</if> + <if test="annexregistform != null and annexregistform != ''"> and AnnexRegistForm = #{annexregistform}</if> + <if test="quantity != null "> and Quantity = #{quantity}</if> + <if test="price != null "> and Price = #{price}</if> + <if test="amount != null "> and Amount = #{amount}</if> + <if test="taxamount != null "> and TaxAmount = #{taxamount}</if> + <if test="taxedamount != null "> and TaxedAmount = #{taxedamount}</if> + <if test="prepaidamount != null "> and PrepaidAmount = #{prepaidamount}</if> + <if test="paidamount != null "> and paidAmount = #{paidamount}</if> + <if test="paidtime != null "> and paidTime = #{paidtime}</if> + <if test="payterm != null and payterm != ''"> and payTerm = #{payterm}</if> + <if test="invoicecount != null "> and InvoiceCount = #{invoicecount}</if> + <if test="attachcount != null "> and AttachCount = #{attachcount}</if> + <if test="remark != null and remark != ''"> and Remark = #{remark}</if> + <if test="infoid != null "> and InfoId = #{infoid}</if> + <if test="donorno != null and donorno != ''"> and DonorNo = #{donorno}</if> + <if test="donorname != null and donorname != ''"> and DonorName like concat('%', #{donorname}, '%')</if> + <if test="recordstatus != null and recordstatus != ''"> and RecordStatus = #{recordstatus}</if> + <if test="uploadflag != null and uploadflag != ''"> and uploadflag = #{uploadflag}</if> + <if test="uploadtime != null "> and uploadtime = #{uploadtime}</if> + <if test="servicesscope != null and servicesscope != ''"> and SERVICESSCOPE = #{servicesscope}</if> + <if test="servicesscopename != null and servicesscopename != ''"> and SERVICESSCOPENAME like concat('%', #{servicesscopename}, '%')</if> + <if test="servicetype != null and servicetype != ''"> and SERVICETYPE = #{servicetype}</if> + <if test="servicetypename != null and servicetypename != ''"> and SERVICETYPENAME like concat('%', #{servicetypename}, '%')</if> + <if test="reimbursementamount != null "> and REIMBURSEMENTAMOUNT = #{reimbursementamount}</if> + <if test="jine != null and jine != ''"> and jine = #{jine}</if> + <if test="liyou != null and liyou != ''"> and liyou = #{liyou}</if> + </where> + </select> + +</mapper> \ No newline at end of file diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeMapper.xml new file mode 100644 index 0000000..5eb8512 --- /dev/null +++ b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeMapper.xml @@ -0,0 +1,51 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.ruoyi.project.mapper.ServiceReimbursementpayeeMapper"> + + <resultMap type="ServiceReimbursementpayee" id="ServiceReimbursementpayeeResult"> + <result property="id" column="id" /> + <result property="rbid" column="rbid" /> + <result property="orderno" column="orderno" /> + <result property="persontype" column="persontype" /> + <result property="personname" column="personname" /> + <result property="bankname" column="bankname" /> + <result property="bankcardno" column="bankcardno" /> + <result property="amount" column="amount" /> + <result property="phone" column="phone" /> + <result property="familyrelations" column="familyrelations" /> + <result property="paiddate" column="paiddate" /> + <result property="remark" column="remark" /> + <result property="delFlag" column="del_flag" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="uploadflag" column="uploadflag" /> + <result property="uploadtime" column="uploadtime" /> + </resultMap> + + <sql id="selectServiceReimbursementpayeeVo"> + select id, rbid, orderno, persontype, personname, bankname, bankcardno, amount, phone, familyrelations, paiddate, remark, del_flag, create_by, create_time, update_by, update_time, uploadflag, uploadtime from service_reimbursementpayee + </sql> + + <select id="selectServiceReimbursementpayeeList" parameterType="ServiceReimbursementpayee" resultMap="ServiceReimbursementpayeeResult"> + <include refid="selectServiceReimbursementpayeeVo"/> + <where> + <if test="rbid != null "> and rbid = #{rbid}</if> + <if test="orderno != null "> and orderno = #{orderno}</if> + <if test="persontype != null and persontype != ''"> and persontype = #{persontype}</if> + <if test="personname != null and personname != ''"> and personname like concat('%', #{personname}, '%')</if> + <if test="bankname != null and bankname != ''"> and bankname like concat('%', #{bankname}, '%')</if> + <if test="bankcardno != null and bankcardno != ''"> and bankcardno = #{bankcardno}</if> + <if test="amount != null "> and amount = #{amount}</if> + <if test="phone != null and phone != ''"> and phone = #{phone}</if> + <if test="familyrelations != null and familyrelations != ''"> and familyrelations = #{familyrelations}</if> + <if test="paiddate != null "> and paiddate = #{paiddate}</if> + <if test="uploadflag != null and uploadflag != ''"> and uploadflag = #{uploadflag}</if> + <if test="uploadtime != null "> and uploadtime = #{uploadtime}</if> + </where> + </select> + +</mapper> \ No newline at end of file diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeSharedMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeSharedMapper.xml new file mode 100644 index 0000000..bf3dcc6 --- /dev/null +++ b/ruoyi-project/src/main/resources/mapper/project/ServiceReimbursementpayeeSharedMapper.xml @@ -0,0 +1,53 @@ +<?xml version="1.0" encoding="UTF-8" ?> +<!DOCTYPE mapper +PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" +"http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.ruoyi.project.mapper.ServiceReimbursementpayeeSharedMapper"> + + <resultMap type="ServiceReimbursementpayeeShared" id="ServiceReimbursementpayeeSharedResult"> + <result property="id" column="id" /> + <result property="rpid" column="rpid" /> + <result property="rbid" column="rbid" /> + <result property="orderno" column="orderno" /> + <result property="persontype" column="persontype" /> + <result property="personname" column="personname" /> + <result property="bankname" column="bankname" /> + <result property="bankcardno" column="bankcardno" /> + <result property="amount" column="amount" /> + <result property="phone" column="phone" /> + <result property="familyrelations" column="familyrelations" /> + <result property="paiddate" column="paiddate" /> + <result property="remark" column="remark" /> + <result property="delFlag" column="del_flag" /> + <result property="createBy" column="create_by" /> + <result property="createTime" column="create_time" /> + <result property="updateBy" column="update_by" /> + <result property="updateTime" column="update_time" /> + <result property="uploadflag" column="uploadflag" /> + <result property="uploadtime" column="uploadtime" /> + </resultMap> + + <sql id="selectServiceReimbursementpayeeSharedVo"> + select id, rpid, rbid, orderno, persontype, personname, bankname, bankcardno, amount, phone, familyrelations, paiddate, remark, del_flag, create_by, create_time, update_by, update_time, uploadflag, uploadtime from service_reimbursementpayee_shared + </sql> + + <select id="selectServiceReimbursementpayeeSharedList" parameterType="ServiceReimbursementpayeeShared" resultMap="ServiceReimbursementpayeeSharedResult"> + <include refid="selectServiceReimbursementpayeeSharedVo"/> + <where> + <if test="rpid != null "> and rpid = #{rpid}</if> + <if test="rbid != null "> and rbid = #{rbid}</if> + <if test="orderno != null "> and orderno = #{orderno}</if> + <if test="persontype != null and persontype != ''"> and persontype = #{persontype}</if> + <if test="personname != null and personname != ''"> and personname like concat('%', #{personname}, '%')</if> + <if test="bankname != null and bankname != ''"> and bankname like concat('%', #{bankname}, '%')</if> + <if test="bankcardno != null and bankcardno != ''"> and bankcardno = #{bankcardno}</if> + <if test="amount != null "> and amount = #{amount}</if> + <if test="phone != null and phone != ''"> and phone = #{phone}</if> + <if test="familyrelations != null and familyrelations != ''"> and familyrelations = #{familyrelations}</if> + <if test="paiddate != null "> and paiddate = #{paiddate}</if> + <if test="uploadflag != null and uploadflag != ''"> and uploadflag = #{uploadflag}</if> + <if test="uploadtime != null "> and uploadtime = #{uploadtime}</if> + </where> + </select> + +</mapper> \ No newline at end of file -- Gitblit v1.9.3