Merge branch 'score-shop' of http://120.27.238.55:7000/r/xzx into score-shop
| | |
| | | FROM |
| | | xzx_jhy_order a |
| | | left join xzx_user_info b on b.user_id = a.user_id |
| | | left join xzx_jhy_info d on d.id = a.jhy_id |
| | | left join xzx_jhy_info d on d.user_id = a.jhy_id |
| | | WHERE 1 = 1 |
| | | <if test="record.orderNo != null and record.orderNo != ''"> |
| | | and a.order_no like concat('%',#{record.orderNo},'%') |
| | |
| | | FROM |
| | | xzx_jhy_order a |
| | | left join xzx_user_info b on b.user_id = a.user_id |
| | | left join xzx_jhy_info d on d.id = a.jhy_id |
| | | left join xzx_jhy_info d on d.user_id = a.jhy_id |
| | | WHERE a.id=#{id} |
| | | </select> |
| | | |