parent: 5ebd818a | patch | commit | ignore whitespace
935090232@qq.com
2021-07-10 0374ff12e640761353a1f280e2691deaaa620a6c 
bug修复
1 files modified
6 ■■■■■ changed files
zq-erp/src/main/resources/mybatis/mapper/hive/SysProjUseDao.xml 6 ●●●●● patch | view | raw | blame | history 
 zq-erp/src/main/resources/mybatis/mapper/hive/SysProjUseDao.xml


@@ -856,7 +856,11 @@




    <update id="updateInvalidProjUse"  >


        update   sys_proj_use set STATUS='无效'


        where date_format(now(), '%Y-%m-%d') > date_format(FAIL_TIME, '%Y-%m-%d') and STATUS='有效'


        where


            (    date_format(now(), '%Y-%m-%d') > date_format(FAIL_TIME, '%Y-%m-%d')


                or SURPLUS_COUNT=0


                or balance =0 )


          and STATUS='有效'


    </update>




    <resultMap type="SysProjUse" id="TaoCanWithProjMap">