解决资金记录bug

admin

2019-01-09 cd7bc1847f0533b6cfe3bfe6ed4750ee97507b84

解决资金记录bug

 fanli/src/main/java/com/yeshi/fanli/mapping/money/UserMoneyDetailMapper.xml

@@ -97,9 +97,14 @@
            separator="UNION ALL">
            <trim prefix="(" suffix=")">
                SELECT
                a.time as dateFormate , if(a.money is null,0,a.money) as
                c.time as dateFormate , if(a.money is null,0,a.money) as
                income ,if(b.money is null,0,b.money) as expend
                FROM

                (select #{item} as `time`) c

                left join

                (
                SELECT
                DATE_FORMAT(
@@ -115,6 +120,9 @@
                d.`umd_createtime`,'%Y-%m')=#{item} GROUP BY DATE_FORMAT(
                d.`umd_createtime`,'%Y-%m')
                ) a

                on a.time=c.time

                LEFT JOIN
                (
                SELECT DATE_FORMAT(
@@ -122,13 +130,14 @@
                `time`,SUM(d.`umd_money`) AS money
                FROM
                `yeshi_ec_user_money_detail`
                d WHERE d.`umd_uid`=#{uid} AND
                d
                WHERE d.`umd_uid`=#{uid} AND
                d.`umd_money` <![CDATA[<0]]>
                AND DATE_FORMAT(
                d.`umd_createtime`,'%Y-%m')=#{item} GROUP BY
                DATE_FORMAT(
                d.`umd_createtime`,'%Y-%m')
                ) b ON a.time=b.time
                ) b ON c.time=b.time
            </trim>
        </foreach>
    </select>