20222223

xiaoyong931011

2022-03-01 167e8a6c8909624c0a6016d2839ff871b9f0c3d4

20222223

 src/main/resources/mapper/walletCoinOrder/ZhiYaRecordDao.xml

@@ -61,7 +61,7 @@


    <select id="selectZhiyaTeamRecordByMemberIdAndOrderNo" resultType="com.xcong.excoin.modules.coin.entity.ZhiyaRewardEntity">
        <![CDATA[ SELECT a.*  FROM zhiya_reward a where a.member_id= #{memberId} and type = 1
        <![CDATA[ SELECT a.*  FROM zhiya_reward a where a.member_id= #{memberId} and a.type = 1 and a.record_no = #{orderNo}
                                   and DATE_FORMAT(a.create_time, '%Y-%m-%d') = DATE_FORMAT(#{now}, '%Y-%m-%d')]]>
    </select>