| | |
|---|
| | | IPage<ComShopOrderSearchVO> pageOrderBy(Page page, @Param("pageComShopOrderSearchDTO") PageComShopOrderSearchDTO pageComShopOrderSearchDTO); |
|---|
| | | |
|---|
| | | @Select("<script> " + |
|---|
| | | "SELECT sr.total_amount AS goods_total, GROUP_CONCAT(og.goods_name) AS goods_name , sum(og.amount) AS goods_count, " + |
|---|
| | | "SELECT sr.total_amount AS goods_total, GROUP_CONCAT(og.goods_name separator '\n') AS goods_name , sum(og.amount) AS goods_count, " + |
|---|
| | | " su.phone AS account, uad.name AS receiver, uad.phone AS receiverPhone, \n" + |
|---|
| | | " concat(uad.province_name, uad.city_name, uad.district_name, uad.detail_address) AS receiver_address, ss.name AS storeName, sr.remark," + |
|---|
| | | " CASE\n" + |
|---|
