20200813

xiaoyong931011

2020-08-13 8b413750e2a5a5d6fb5b5d12bb4671e5609161d8

20200813

 src/main/resources/mapper/modules/DataMonitoringMapper.xml

@@ -60,7 +60,7 @@
        FROM

            contract_order s

        LEFT JOIN member m ON m.id = s.member_id 

        where s.create_time >= #{createTime} and (TIMESTAMPDIFF(MINUTE,s.opening_time,s.closing_time) <![CDATA[ <= ]]>  3)

        where s.create_time >= #{createTime}  and (TIMESTAMPDIFF(MINUTE,s.opening_time,s.closing_time) <![CDATA[ <= ]]>  3)

    </select>

    

    <select id="selectContractOrderListLessThreeCountInToday" resultType="java.lang.String">

@@ -69,7 +69,8 @@
        FROM

            contract_order s

        LEFT JOIN member m ON m.id = s.member_id 

        where s.create_time >= #{createTime} 
        where s.create_time >= #{createTime}

        and  s.member_id = #{memberId}  
        and TIMESTAMPDIFF(

        MINUTE,

        s.opening_time,