Merge branch 'master' into div1
| | |
| | | <select id="listOrderGoodsInfo" resultMap="ResultMap" parameterType="java.util.List"> |
| | | <!-- 查询用户订单商品信息 --> |
| | | SELECT COALESCE(SUM(tc.`co_payment`),0)AS totalPayment,COALESCE(SUM(tc.`co_settlement`),0)AS totalSettlement, |
| | | COALESCE(SUM(tc.`co_count`),0)AS totalCount,tc.`co_source_type`,tc.`co_order_no`,tg.* |
| | | COALESCE(SUM(tc.`co_count`),0)AS totalCount,tc.`co_source_type`,tc.`co_order_no`,tg.*,tc.co_id |
| | | FROM |
| | | yeshi_ec_common_order_goods tg |
| | | LEFT JOIN yeshi_ec_common_order tc ON tc.`co_order_goods_id` = tg.`cog_id` |