| | |
| | | import com.ruoyi.common.core.domain.AjaxResult; |
| | | import com.ruoyi.common.core.page.TableDataInfo; |
| | | import com.ruoyi.common.enums.BusinessType; |
| | | import com.ruoyi.common.exception.base.BaseException; |
| | | import com.ruoyi.common.utils.poi.ExcelUtil; |
| | | import com.ruoyi.project.domain.FunddetailReqVo; |
| | | import com.ruoyi.project.domain.ServiceFunddetail; |
| | |
| | | @Excel(name = "收益人编号") |
| | | private String beneficiaryno; |
| | | |
| | | /** |
| | | * 收益人编号 |
| | | */ |
| | | @ApiModelProperty("收益人") |
| | | @Excel(name = "收益人") |
| | | private String beneficiaryname; |
| | | /** |
| | | * 收益人编号 |
| | | */ |
| | | @ApiModelProperty("申请金额") |
| | | @Excel(name = "申请金额") |
| | | private double amount; |
| | | |
| | | } |
| | | |
| | |
| | | import io.swagger.annotations.ApiModel; |
| | | import io.swagger.annotations.ApiModelProperty; |
| | | import lombok.Data; |
| | | import org.springframework.lang.NonNull; |
| | | |
| | | /** |
| | | * SP_STAT_BONUS |
| | |
| | | * pabegtime |
| | | */ |
| | | @ApiModelProperty("pabegtime") |
| | | private String pabegtime; |
| | | private String pabegtime = ""; |
| | | |
| | | /** |
| | | * deppaendtimetid |
| | | */ |
| | | @ApiModelProperty("paendtime") |
| | | private String paendtime; |
| | | private String paendtime = ""; |
| | | |
| | | /** |
| | | * padeptno |
| | | */ |
| | | @ApiModelProperty("padeptno") |
| | | private String padeptno; |
| | | private String padeptno = ""; |
| | | |
| | | /** |
| | | * pauserno |
| | | */ |
| | | @ApiModelProperty("pauserno") |
| | | private String pauserno; |
| | | private String pauserno = ""; |
| | | |
| | | /** |
| | | * pabonustype |
| | | * 绩效类型:1、月度、2、季度、3、年度 |
| | | */ |
| | | @ApiModelProperty("pabonustype") |
| | | private Integer pabonustype; |
| | | @ApiModelProperty("绩效类型:1、月度、2、季度、3、年度") |
| | | private String pabonustype = ""; |
| | | |
| | | } |
| | | |
| | |
| | | @ApiModelProperty("deptname") |
| | | private String deptname; |
| | | |
| | | /** |
| | | * reporterno |
| | | */ |
| | | @ApiModelProperty("reporterno") |
| | | private String reporterno; |
| | | |
| | | /** |
| | | * reportername |
| | | */ |
| | | @ApiModelProperty("reportername") |
| | | private String reportername; |
| | | // /** |
| | | // * reporterno |
| | | // */ |
| | | // @ApiModelProperty("reporterno") |
| | | // private String reporterno; |
| | | // |
| | | // /** |
| | | // * reportername |
| | | // */ |
| | | // @ApiModelProperty("reportername") |
| | | // private String reportername; |
| | | |
| | | /** |
| | | * casesum |
| | |
| | | * pabegtime |
| | | */ |
| | | @ApiModelProperty("pabegtime") |
| | | private String pabegtime; |
| | | private String pabegtime = ""; |
| | | |
| | | /** |
| | | * paendtime |
| | | */ |
| | | @ApiModelProperty("paendtime") |
| | | private String paendtime; |
| | | private String paendtime = ""; |
| | | |
| | | /** |
| | | * padeptno |
| | | */ |
| | | @ApiModelProperty("padeptno") |
| | | private String padeptno; |
| | | private String padeptno = ""; |
| | | |
| | | /** |
| | | * pauserno |
| | | */ |
| | | @ApiModelProperty("pauserno") |
| | | private String pauserno; |
| | | private String pauserno = ""; |
| | | |
| | | /** |
| | | * pacasestate |
| | | */ |
| | | @ApiModelProperty("pacasestate") |
| | | private String pacasestate; |
| | | private String pacasestate = ""; |
| | | |
| | | |
| | | } |
| | |
| | | private String hospitalno; |
| | | |
| | | /** |
| | | * 医院名称 |
| | | */ |
| | | @ApiModelProperty("医院名称") |
| | | private String hospitalname; |
| | | |
| | | /** |
| | | * 接收月份 |
| | | */ |
| | | // @ApiModelProperty("接收月份") |
| | |
| | | * 医院编号 |
| | | */ |
| | | @ApiModelProperty("医院编号") |
| | | private String pahospitalno; |
| | | private String pahospitalno = ""; |
| | | |
| | | /** |
| | | * 0:未收款情况 1:已收款统计 |
| | |
| | | public class SpStatExpense { |
| | | private static final long serialVersionUID = 1L; |
| | | |
| | | /** |
| | | * 绩效日期 |
| | | */ |
| | | @ApiModelProperty("绩效日期") |
| | | private String pabegtime; |
| | | |
| | | /** |
| | | * 部门id |
| | | */ |
| | | @ApiModelProperty("部门id") |
| | | private String paendtime; |
| | | |
| | | /** |
| | | * 部门名称 |
| | | */ |
| | | @ApiModelProperty("部门名称") |
| | | private String padeptno; |
| | | |
| | | /** |
| | | * 收益人编号 |
| | | */ |
| | | @ApiModelProperty("收益人编号") |
| | | @Excel(name = "收益人编号") |
| | | private String pauserno; |
| | | |
| | | /** |
| | | * 收益人编号 |
| | | */ |
| | | @ApiModelProperty("收益人编号") |
| | | @Excel(name = "收益人编号") |
| | | private String paexpensetype; |
| | | |
| | | /** |
| | | * 收益人编号 |
| | |
| | | /** |
| | | * 收益人编号 |
| | | */ |
| | | @ApiModelProperty("收益人编号") |
| | | @Excel(name = "收益人编号") |
| | | @ApiModelProperty("收益人") |
| | | @Excel(name = "收益人") |
| | | private String deptmentName; |
| | | |
| | | /** |
| | |
| | | @Excel(name = "收益人编号") |
| | | private String amount; |
| | | |
| | | /** |
| | | * 收益人编号 |
| | | */ |
| | | @ApiModelProperty("收益人编号") |
| | | @Excel(name = "收益人编号") |
| | | private String applyType; |
| | | |
| | | } |
| | | |
| | |
| | | * pabegtime |
| | | */ |
| | | @ApiModelProperty("pabegtime") |
| | | private String pabegtime; |
| | | private String pabegtime = ""; |
| | | |
| | | /** |
| | | * paendtime |
| | | */ |
| | | @ApiModelProperty("paendtime") |
| | | private String paendtime; |
| | | private String paendtime = ""; |
| | | |
| | | /** |
| | | * padeptno |
| | | */ |
| | | @ApiModelProperty("padeptno") |
| | | private String padeptno; |
| | | private String padeptno = ""; |
| | | |
| | | /** |
| | | * pauserno |
| | | */ |
| | | @ApiModelProperty("pauserno") |
| | | private String pauserno; |
| | | private String pauserno = ""; |
| | | |
| | | /** |
| | | * pacasestate |
| | | */ |
| | | @ApiModelProperty("paexpensetype") |
| | | private String paexpensetype; |
| | | private String paexpensetype = ""; |
| | | |
| | | |
| | | } |
| | |
| | | @Mapper |
| | | public interface SpStatBonusMapper extends BaseMapper<SpStatBonus> { |
| | | |
| | | List<SpStatBonus> getListBySpStatBonus(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") String PAUSERNO, @Param("PABONUSTYPE") Integer PABONUSTYPE); |
| | | List<SpStatBonus> getListBySpStatBonus(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") String PAUSERNO, @Param("PABONUSTYPE") String PABONUSTYPE); |
| | | |
| | | } |
| | |
| | | |
| | | <select id="getListBySpStatBonus" statementType="CALLABLE" |
| | | resultType="com.ruoyi.project.domain.SpStatBonus"> |
| | | call `SP_STAT_BONUS`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=VARCHAR},#{PABONUSTYPE,mode=IN,jdbcType=INTEGER}) |
| | | call `SP_STAT_BONUS`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=VARCHAR},#{PABONUSTYPE,mode=IN,jdbcType=VARCHAR |
| | | }) |
| | | </select> |
| | | |
| | | </mapper> |