yxh

yxh

2023-04-22 2283114d983bb80dcf7edba97600e4c6225d4adb

yxh

 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)));
    }
}

 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)));
    }
}

 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)));
    }
}

 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;

    /** èŒç§°,见字典sys_professionaltitle */
    @ApiModelProperty("职称,见字典sys_professionaltitle")
    @Excel(name = "职称,见字典sys_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;

    /** æ‰£ç¨Žé‡‘额 */
    @ApiModelProperty("扣税金额")
    @Excel(name = "扣税金额")
    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;

}


 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;

    /** äººå‘˜ç±»åˆ«ï¼ˆå­—典表：sys_travelexpensebelong）：0：其他人员；1：专职人员；2：协调员；3：专家；4：捐献者家属 */
    @ApiModelProperty("人员类别（字典表：sys_travelexpensebelong）：0：其他人员；1：专职人员；2：协调员；3：专家；4：捐献者家属")
    @Excel(name = "人员类别", readConverterExp = "字=典表：sys_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;

}


 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;

    /** èµ„金付款表ID */
    @ApiModelProperty("资金付款表ID")
    @Excel(name = "资金付款表ID")
    private Long rpid;

    /** èµ„金申请主表ID */
    @ApiModelProperty("资金申请主表ID")
    @Excel(name = "资金申请主表ID")
    private Long rbid;

    /** é¡ºåºå· */
    @ApiModelProperty("顺序号")
    @Excel(name = "顺序号")
    private Long orderno;

    /** äººå‘˜ç±»åˆ«ï¼ˆå­—典表：sys_travelexpensebelong）：0：其他人员；1：专职人员；2：协调员；3：专家；4：捐献者家属 */
    @ApiModelProperty("人员类别（字典表：sys_travelexpensebelong）：0：其他人员；1：专职人员；2：协调员；3：专家；4：捐献者家属")
    @Excel(name = "人员类别", readConverterExp = "字=典表：sys_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;

}


 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);
}

 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);
}

 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);
}

 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);
}

 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);
}

 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);
}

 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);
    }

}

 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);
    }

}

 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);
    }

}

 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>

 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>

 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>