| | |
| | | private String padeptno = ""; |
| | | |
| | | /** |
| | | * pauserno |
| | | * pausername |
| | | */ |
| | | @ApiModelProperty("pauserno") |
| | | private String pauserno = ""; |
| | | @ApiModelProperty("pausername") |
| | | private String pausername = ""; |
| | | |
| | | /** |
| | | * 绩效类型:1、月度、2、季度、3、年度 |
| | |
| | | * pauserno |
| | | */ |
| | | @ApiModelProperty("pauserno") |
| | | private String pauserno = ""; |
| | | private String pausername = ""; |
| | | |
| | | /** |
| | | * pacasestate |
| | |
| | | @ApiModelProperty("padeptno") |
| | | private String padeptno = ""; |
| | | |
| | | |
| | | /** |
| | | * pauserno |
| | | * pausername |
| | | */ |
| | | @ApiModelProperty("pauserno") |
| | | private String pauserno = ""; |
| | | @ApiModelProperty("pausername") |
| | | private String pausername = ""; |
| | | |
| | | /** |
| | | * pacasestate |
| | |
| | | @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") String PABONUSTYPE); |
| | | List<SpStatBonus> getListBySpStatBonus(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNAME") String PAUSERNAME, @Param("PABONUSTYPE") String PABONUSTYPE); |
| | | |
| | | } |
| | |
| | | @Mapper |
| | | public interface SpstatCaseMapper extends BaseMapper<SpStatCase> { |
| | | |
| | | List<SpStatCase> getListBypower(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") String PAUSERNO, @Param("PACASESTATE") String PACASESTATE); |
| | | List<SpStatCase> getListBypower(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNAME") String PAUSERNAME, @Param("PACASESTATE") String PACASESTATE); |
| | | |
| | | } |
| | |
| | | @Mapper |
| | | public interface SpstatExpenseMapper extends BaseMapper<SpStatExpense> { |
| | | |
| | | List<SpStatExpense> getListBySpstatExpense(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNO") String PAUSERNO, @Param("PAEXPENSETYPE") String PAEXPENSETYPE); |
| | | List<SpStatExpense> getListBySpstatExpense(@Param("PABEGTIME") String PABEGTIME, @Param("PAENDTIME") String PAENDTIME, @Param("PADEPTNO") String PADEPTNO, @Param("PAUSERNAME") String PAUSERNAME, @Param("PAEXPENSETYPE") String PAEXPENSETYPE); |
| | | |
| | | } |
| | |
| | | |
| | | @Override |
| | | public List<SpStatBonus> getListBySpStatBonus(SpStatBonusReq spStatBonusReq) { |
| | | return spStatBonusMapper.getListBySpStatBonus(spStatBonusReq.getPabegtime(), spStatBonusReq.getPaendtime(), spStatBonusReq.getPadeptno(), spStatBonusReq.getPauserno(), spStatBonusReq.getPabonustype()); |
| | | return spStatBonusMapper.getListBySpStatBonus(spStatBonusReq.getPabegtime(), spStatBonusReq.getPaendtime(), spStatBonusReq.getPadeptno(), spStatBonusReq.getPausername(), spStatBonusReq.getPabonustype()); |
| | | } |
| | | } |
| | |
| | | |
| | | @Override |
| | | public List<SpStatCase> getListBypower(SpStatCaseReq spStatCaseReq) { |
| | | return spstatCaseMapper.getListBypower(spStatCaseReq.getPabegtime(), spStatCaseReq.getPaendtime(), spStatCaseReq.getPadeptno(), spStatCaseReq.getPauserno(), spStatCaseReq.getPacasestate()); |
| | | return spstatCaseMapper.getListBypower(spStatCaseReq.getPabegtime(), spStatCaseReq.getPaendtime(), spStatCaseReq.getPadeptno(), spStatCaseReq.getPausername(), spStatCaseReq.getPacasestate()); |
| | | } |
| | | |
| | | } |
| | |
| | | |
| | | @Override |
| | | public List<SpStatExpense> getListBySpstatExpense(SpStatExpenseReq spStatExpenseReq) { |
| | | return spstatExpenseMapper.getListBySpstatExpense(spStatExpenseReq.getPabegtime(), spStatExpenseReq.getPaendtime(), spStatExpenseReq.getPadeptno(), spStatExpenseReq.getPauserno(), spStatExpenseReq.getPaexpensetype()); |
| | | return spstatExpenseMapper.getListBySpstatExpense(spStatExpenseReq.getPabegtime(), spStatExpenseReq.getPaendtime(), spStatExpenseReq.getPadeptno(), spStatExpenseReq.getPausername(), spStatExpenseReq.getPaexpensetype()); |
| | | } |
| | | |
| | | } |
| | |
| | | |
| | | <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=VARCHAR |
| | | call `SP_STAT_BONUS`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNAME,mode=IN,jdbcType=VARCHAR},#{PABONUSTYPE,mode=IN,jdbcType=VARCHAR |
| | | }) |
| | | </select> |
| | | |
| | |
| | | |
| | | <select id="getListBypower" statementType="CALLABLE" |
| | | resultType="com.ruoyi.project.domain.SpStatCase"> |
| | | call `SP_STAT_CASE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=VARCHAR |
| | | call `SP_STAT_CASE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNAME,mode=IN,jdbcType=VARCHAR |
| | | },#{PACASESTATE,mode=IN,jdbcType=VARCHAR}) |
| | | </select> |
| | | </mapper> |
| | |
| | | |
| | | <select id="getListBySpstatExpense" statementType="CALLABLE" |
| | | resultType="com.ruoyi.project.domain.SpStatExpense"> |
| | | call `SP_STAT_EXPENSE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=VARCHAR},#{PAEXPENSETYPE,mode=IN,jdbcType=VARCHAR}) |
| | | call `SP_STAT_EXPENSE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNAME,mode=IN,jdbcType=VARCHAR},#{PAEXPENSETYPE,mode=IN,jdbcType=VARCHAR}) |
| | | </select> |
| | | </mapper> |