| | |
| | | <result property="logisticsCompany" column="logistics_company"/> |
| | | <result property="logisticsNum" column="logistics_num"/> |
| | | <result property="playIntegral" column="play_integral"/> |
| | | <result property="pickUpMethod" column="pick_up_method"/> |
| | | </resultMap> |
| | | |
| | | <sql id="base_sql"> |
| | | id, |
| | | order_num, |
| | | user_id, |
| | | pick_up_method, |
| | | (select su.name from union_user as su where su.id=union_exchange_record.user_id) as userName, |
| | | (select su.phone from union_user as su where su.id=union_exchange_record.user_id) as phone, |
| | | goods_id, |
| | |
| | | <if test="item.playIntegral != null"> |
| | | play_integral, |
| | | </if> |
| | | <if test="item.pickUpMethod != null"> |
| | | pick_up_method, |
| | | </if> |
| | | create_time |
| | | </trim> |
| | | values |
| | |
| | | </if> |
| | | <if test="item.playIntegral != null"> |
| | | #{item.playIntegral}, |
| | | </if> |
| | | <if test="item.pickUpMethod != null"> |
| | | #{item.pickUpMethod}, |
| | | </if> |
| | | sysdate() |
| | | </trim> |
| | |
| | | <if test="item.playIntegral != null"> |
| | | play_integral=#{item.playIntegral}, |
| | | </if> |
| | | <if test="item.pickUpMethod != null"> |
| | | pick_up_method=#{item.pickUpMethod}, |
| | | </if> |
| | | update_time=sysdate() |
| | | </set> |
| | | where id = #{item.id} |