| | |
| | | |
| | | <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=INT},#{PABONUSTYPE,mode=IN,jdbcType=VARCHAR}) |
| | | call `SP_STAT_BONUS`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=INTEGER},#{PABONUSTYPE,mode=IN,jdbcType=VARCHAR}) |
| | | </select> |
| | | |
| | | </mapper> |
| | |
| | | |
| | | <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=INT},#{PACASESTATE,mode=IN,jdbcType=VARCHAR}) |
| | | call `SP_STAT_CASE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=INTEGER},#{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=INT},#{PAEXPENSETYPE,mode=IN,jdbcType=VARCHAR}) |
| | | call `SP_STAT_EXPENSE`(#{PABEGTIME,mode=IN,jdbcType=VARCHAR},#{PAENDTIME,mode=IN,jdbcType=VARCHAR},#{PADEPTNO,mode=IN,jdbcType=VARCHAR},#{PAUSERNO,mode=IN,jdbcType=INTEGER},#{PAEXPENSETYPE,mode=IN,jdbcType=VARCHAR}) |
| | | </select> |
| | | </mapper> |