| | |
|---|
| | | </select> |
|---|
| | | |
|---|
| | | <select id="countValidOrderByDate" resultType="Long"> |
|---|
| | | SELECT IFNULL(COUNT(co.`co_id`),0) FROM yeshi_ec_common_order co |
|---|
| | | LEFT JOIN yeshi_ec_hongbao_order ho ON co.`co_id`=ho.`ho_order_id` |
|---|
| | | LEFT JOIN yeshi_ec_hongbao_v2 v2 ON v2.hb_id=ho.`ho_hongbao_id` |
|---|
| | | WHERE co.`co_uid` = #{uid} AND v2.`hb_type` = 1 AND v2.`hb_state` = 3 |
|---|
| | | AND co.`co_third_create_time` > #{dateTime} |
|---|
| | | SELECT IFNULL(COUNT(co_order_no),0) FROM |
|---|
| | | (SELECT DISTINCT co.co_order_no FROM yeshi_ec_common_order co |
|---|
| | | LEFT JOIN yeshi_ec_hongbao_order ho ON co.`co_id`=ho.`ho_order_id` |
|---|
| | | LEFT JOIN yeshi_ec_hongbao_v2 v2 ON v2.hb_id=ho.`ho_hongbao_id` |
|---|
| | | WHERE co.`co_uid` = #{uid} AND v2.`hb_type` = 1 |
|---|
| | | AND v2.`hb_state` = 3 AND AND co.`co_third_create_time` <![CDATA[>]]> #{dateTime})A |
|---|
| | | </select> |
|---|
| | | </mapper> |
|---|
