嘿嘿嘿嘿和

package cn.changeHappy.exchange.controller;

import cn.changeHappy.exchange.pojo.SearchGoodsEntity;
import cn.changeHappy.exchange.servcie.ExchangeService;
import cn.changeHappy.exchange.utils.R;
import cn.changeHappy.exchange.utils.ValidatorUtils;
import com.alibaba.fastjson.JSON;
import lombok.Data;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.text.ParseException;
import java.util.List;
import java.util.Map;

import static cn.changeHappy.exchange.utils.R.success;


@RestController
@RequestMapping("/exchangeHomePage")
public class ExchangeHomepageController {

    @Autowired
    ExchangeService exchangeService;


    
    @GetMapping("/selectExchangeHomepage")
    public R>> selectChangeHappyBzdmAllType() throws Exception {
        List> exchangeList = exchangeService.selectChangeHappyBzdmAllType();
        return  success(exchangeList);
    }

    @Data
    public static class SearchBzdmAllTypeEntity{
        private String bzdm;
    }


    
    @GetMapping("/selectChangeHappyBzdmImg")
    public List> selectChangeHappyBzdmImg() throws Exception {
        List> exchangeList = exchangeService.selectChangeHappyBzdmImg();
        return  exchangeList;
    }

    @Data
    public static class SelectChangeHappyBzdmImgEntity{
        private String bzdm;
    }

    
    //TODO: 2021/10/16 暂停使用
    @PostMapping("/selectExchangeHomepageByGoodsType")
    public List> selectExchangeHomepageByGoodsType(@RequestBody  SearchHomePageByGoodsAllTypeEntity searchHomePageByGoodsAllTypeEntity)  throws Exception {
        ValidatorUtils.validateEntity(searchHomePageByGoodsAllTypeEntity);
        Map map = JSON.parseObject(JSON.toJSonString(searchHomePageByGoodsAllTypeEntity), Map.class);
        List> exchangeList = exchangeService.selectExchangeHomepageByGoodsType(map);
        return  exchangeList;
    }

    @Data
    public static class SearchHomePageByGoodsAllTypeEntity{
        private Integer goodsType;
    }


    
    @PostMapping("/selectExchangeGoods")
    public List> selectExchangeGoods(@RequestBody SearchGoodsEntity searchGoodsEntity)  throws Exception {
        ValidatorUtils.validateEntity(searchGoodsEntity);
        Map map = JSON.parseObject(JSON.toJSonString(searchGoodsEntity), Map.class);
        List> exchangeList = exchangeService.selectExchangeGoods(searchGoodsEntity);
        return  exchangeList;
    }



    
    @PostMapping("/selectExchangeIndex")
    public List> selectExchangeIndex()  throws Exception {
        List> exchangeList = exchangeService.selectExchangeIndex();
        return  exchangeList;
    }


    
    @PostMapping("/selectExchangeIndexHotGoods")
    public List> selectExchangeIndexHotGoods()  throws Exception {
        List> exchangeHotGoodsList = exchangeService.selectExchangeIndexHotGoods();
        return  exchangeHotGoodsList;
    }


    
    @PostMapping("/selectExchangeCollectGoods")
    public Map selectExchangeCollectGoods(@RequestBody SearchCollectGoodsEntity searchCollectGoodsEntity) throws Exception {
        ValidatorUtils.validateEntity(searchCollectGoodsEntity);
        Map map = JSON.parseObject(JSON.toJSonString(searchCollectGoodsEntity), Map.class);
        Map exchangeHotGoodsList = exchangeService.selectExchangeCollectGoods(map);
        return  exchangeHotGoodsList;
    }

    @Data
    public static class SearchCollectGoodsEntity{
        private String userId;
    }


    
    @PostMapping("/insertGoodsByUserId")
    public Map insertCollectGoods(@RequestBody InsertCollectGoodsEntity insertUserGoodsEntity) throws Exception {
        ValidatorUtils.validateEntity(insertUserGoodsEntity);
        Map map = JSON.parseObject(JSON.toJSonString(insertUserGoodsEntity), Map.class);
        Map stringObjectMap = exchangeService.insertCollectGoods(map);
        return stringObjectMap;
    }

    @Data
    public static class InsertCollectGoodsEntity {
        private String userId;
        private String goodsId;
    }

    
    @PostMapping("/deleteGoodsByUserId")
    public Map deleteGoodsByUserId(@RequestBody DeleteCollectGoodsEntity deleteCollectGoodsEntity) throws Exception {
        ValidatorUtils.validateEntity(deleteCollectGoodsEntity);
        Map map = JSON.parseObject(JSON.toJSonString(deleteCollectGoodsEntity), Map.class);
        Map stringObjectMap = exchangeService.deleteGoodsByUserId(map);
        return stringObjectMap;
    }

    @Data
    public static class DeleteCollectGoodsEntity {
        private String userId;
        private String goodsId;
    }


    
    @PostMapping("/selectExchangeInform")
    public Map selectExchangeInform(String headlineType) throws Exception {
        Map exchangeInformMap = exchangeService.selectExchangeInform(headlineType);
        return  exchangeInformMap;
    }


    
    @GetMapping("selectHomepageSlideshow")
    public List> selectHomepageSlideshow() throws Exception{
        return exchangeService.selectHomepageSlideshow();
    }


    
    @PostMapping("queryTimeShopping")
    public List> queryTimeShopping() throws Exception{
        return exchangeService.queryTimeShopping();
    }


    
    @PostMapping("/queryPeopleVip")
    public List> queryPeopleVip(@RequestBody SearchGoodsEntity searchGoodsEntity)  throws Exception {
        ValidatorUtils.validateEntity(searchGoodsEntity);
        Map map = JSON.parseObject(JSON.toJSonString(searchGoodsEntity), Map.class);
        List> exchangeList = exchangeService.queryPeopleVip(searchGoodsEntity);
        return  exchangeList;
    }
}

package cn.changeHappy.exchange.mapper;

import cn.changeHappy.exchange.pojo.SearchGoodsEntity;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;


@Mapper
public interface ExchangeMapper {

    List> selectChangeHappyBzdmAllType();

    List> selectExchangeHomepageByGoodsType(Map map);


    List> selectExchangeIndex();

    List> selectExchangeIndexHotGoods();

    int selectExchangeCollectGoodsCount(Map map);

    List> selectExchangeCollectGoodsList(Map map);

    Map selectGoodsByGoodsId(String stringObjectMap);

    int insertCollectGoods(Map map);

    List> selectExchangeInform(String headlineType);

    List> selectHomepageSlideshow();

    List> selectChangeHappyBzdmImg();

    List> selectFileByGoodsId(String id);

    int deleteGoodsByUserId(Map map);

    int selectUserAttention(Map map);

    List> selectExchangeGoods(SearchGoodsEntity searchGoodsEntity);

    List> queryTimeShopping();

    List> queryPeopleVip(SearchGoodsEntity searchGoodsEntity);
}

package cn.changeHappy.exchange.servcie.impl;

import cn.changeHappy.exchange.mapper.ExchangeMapper;
import cn.changeHappy.exchange.mapper.ExchangeOrderMapper;
import cn.changeHappy.exchange.mapper.ExchangeUserGoodsMapper;
import cn.changeHappy.exchange.pojo.SearchGoodsEntity;
import cn.changeHappy.exchange.servcie.ExchangeService;
import cn.changeHappy.exchange.utils.R;
import cn.changeHappy.exchange.utils.TimeUtil;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.text.ParseException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;


@Service
public class ExchangeServiceImpl implements ExchangeService {

    @Autowired
    ExchangeOrderMapper exchangeOrderMapper;

    @Autowired
    ExchangeMapper exchangeMapper;

    @Autowired
    ExchangeUserGoodsMapper exchangeUserGoodsMapper;


    @Override
    public List> selectChangeHappyBzdmAllType() throws Exception {
        return exchangeMapper.selectChangeHappyBzdmAllType();
    }

    @Override
    public List> selectExchangeHomepageByGoodsType(Map map) {
        return exchangeMapper.selectExchangeHomepageByGoodsType(map);
    }

    @Override
    public List> selectExchangeGoods(SearchGoodsEntity searchGoodsEntity) throws ParseException {
        List> list = exchangeMapper.selectExchangeGoods(searchGoodsEntity);

        Map map=new HashMap();
        map.put("userId",searchGoodsEntity.getUserId());
        for (Map goodsMap : list) {
            List> fileList = exchangeMapper.selectFileByGoodsId(String.valueOf(goodsMap.get("id")));
            goodsMap.put("fileList", fileList);
            String crderTime = TimeUtil.QQFormatTime(goodsMap.get("crderTime").toString());
            goodsMap.put("crderTime",crderTime);
            //查询此商品是否收藏 collectionYes:1 收藏 2:没有收藏
            map.put("goodsId",String.valueOf(goodsMap.get("id")));
            int goodsCollectCount = exchangeUserGoodsMapper.selectGoodsByUserIdCnt(map);
            if (goodsCollectCount > 0) {
                goodsMap.put("collectionYes", true);
            } else {
                goodsMap.put("collectionYes", false);
            }

        }
        return list;
    }

    @Override
    public List> queryTimeShopping() {
        List> list = exchangeMapper.queryTimeShopping();

        for (Map goodsMap : list) {
            List> fileList = exchangeMapper.selectFileByGoodsId(String.valueOf(goodsMap.get("id")));
            goodsMap.put("fileList", fileList);
        }
        return list;
    }

    @Override
    public List> queryPeopleVip(SearchGoodsEntity searchGoodsEntity) {
        List> list = exchangeMapper.queryPeopleVip(searchGoodsEntity);

        Map map=new HashMap();
        map.put("userId",searchGoodsEntity.getUserId());
        for (Map goodsMap : list) {
            List> fileList = exchangeMapper.selectFileByGoodsId(String.valueOf(goodsMap.get("id")));
            goodsMap.put("fileList", fileList);
            //用户id和商品id 查询订单里是否参与活动
            map.put("goodsId",goodsMap.get("goodsId"));
            List> activityList = exchangeOrderMapper.selectActivityOrderByUserIdGoodsId(map);
            if (activityList.size() == 0) {
                goodsMap.put("isPurchase", true);
            } else {
                goodsMap.put("isPurchase", false);
            }

        }
        return list;
    }

    @Override
    public List> selectExchangeIndex() {
        List> list = exchangeMapper.selectExchangeIndex();
        return list;
    }

    @Override
    public List> selectExchangeIndexHotGoods() {
        return exchangeMapper.selectExchangeIndexHotGoods();
    }

    @Override
    public Map selectExchangeCollectGoods(Map map) {
        Map returnMap = new HashMap<>();
        List> objects = new ArrayList<>();
        int count = exchangeMapper.selectExchangeCollectGoodsCount(map);

        returnMap.put("collectCount", count);
        if (count > 0) {
            List> goodsIdList = exchangeMapper.selectExchangeCollectGoodsList(map);
            for (Map stringObjectMap : goodsIdList) {
                String goodsId = String.valueOf(stringObjectMap.get("goodsId"));
                Map goodsMap = exchangeMapper.selectGoodsByGoodsId(goodsId);
                if (null != goodsMap) {
                    List> fileList = exchangeMapper.selectFileByGoodsId(String.valueOf(goodsMap.get("id")));
                    if (fileList.size() > 0 && null != fileList) {
                        goodsMap.put("fileList", fileList);
                    } else {
                        goodsMap.put("fileList", new ArrayList<>());
                    }
                    objects.add(goodsMap);
                }
            }
        }
        returnMap.put("goodsList", objects);
        returnMap.put("code",R.SUCCESS);
        returnMap.put("msg","");
        return returnMap;
    }

    @Override
    public Map insertCollectGoods(Map map) throws Exception {
        Map returnMap = new HashMap<>();
        int count = exchangeMapper.insertCollectGoods(map);
        if (count != 1) {
            returnMap.put("code", R.ERROR);
            returnMap.put("msg", "");
        }
        returnMap.put("code", R.SUCCESS);
        returnMap.put("msg", "");
        return returnMap;
    }

    @Override
    public Map selectExchangeInform(String headlineType) throws Exception {
        Map returnMap = new HashMap<>();
        List> informList = exchangeMapper.selectExchangeInform(headlineType);
        returnMap.put("informList", informList);
        return returnMap;
    }

    @Override
    public List> selectHomepageSlideshow() {
        return exchangeMapper.selectHomepageSlideshow();
    }

    @Override
    public List> selectChangeHappyBzdmImg() throws Exception{
        return exchangeMapper.selectChangeHappyBzdmImg();
    }

    @Override
    public Map deleteGoodsByUserId(Map map) throws Exception{
        Map returnMap = new HashMap<>();
        int count = exchangeMapper.deleteGoodsByUserId(map);
        if(count <=0){
            returnMap.put("code", R.ERROR);
            returnMap.put("msg", "");
        }
        returnMap.put("code", R.SUCCESS);
        returnMap.put("msg", "");
        return returnMap;
    }
}

  
    select b.id,b.name,b.img,b.status from changehappy_type b where b.status='1'
  

  
    select * from changehappy_goods where goods_type=#{goodsType,jdbcType=INTEGER}
  
  
    select
    a.id,a.goods_id goodsId,
    a.goods_name goodsName,
    a.user_id userId ,a.goods_price goodsPrice,
    a.goods_type goodsType,
    a.crder_time crderTime,
    a.sales,
    b.name goodsTypeName,
    b.img typeImg,
    c.userImg userImg,
    a.order_type_id orderTypeId,
    a.page_view pageView,
    a.goods_postage goodsPostage,
    c.user_name userName,
    a.goods_original_price goodsOriginalPrice

    from changehappy_goods a
    left join changehappy_type b on  a.goods_type=b.id
    left join changehappy_user c on  a.user_id = c.user_id
    where a.stand_up_and_down='1'
    
      and a.goods_type = #{goodsType,jdbcType=INTEGER}
    
    
      and a.sftj = #{sftj,jdbcType=VARCHAR}
    
    
      and a.goods_name like CONCAt('%',#{goodsName,jdbcType=VARCHAR}, '%')
    
    
      and a.order_type_id = #{orderTypeId}
    
    
      and state_id =#{nearbyGoods}
    
    and a.goods_status='1'
    and b.status ='1'
    group by DATE_FORMAT(a.goods_time_recommend, '%Y/%m/%d %H:%i:%s'),a.id
    order by DATE_FORMAT(a.crder_time, '%Y/%m/%d %H:%i:%s') desc
    
      , a.goods_price+0 desc
    
    
      , a.goods_price+0
    
    
      , DATE_FORMAT(a.crder_time, '%Y/%m/%d %H:%i:%s') desc
    
    
      , page_view desc
    

    LIMIT #{currPage}, #{pageSize}
  

  

    select a.id,a.navigation_name name,a.navigation_img img from changehappy_navigation a where  a.navigation_status='1'
  
  
    select id,goods_name goodsName,goods_id goodsId
    from changehappy_hot_goods
  
  
    select count(*) userCount from changehappy_collect_goods where user_id = #{userId,jdbcType=VARCHAR}
  
  
    select goods_id goodsId from changehappy_collect_goods where user_id = #{userId,jdbcType=VARCHAR}
  
  
    select
    a.id,a.goods_id goodsId,
    a.goods_name goodsName,
    a.user_id userId ,a.goods_price goodsPrice,
    a.goods_type goodsType,
    a.sales,
    b.name goodsTypeName,
    b.img typeImg,
    u.user_name userName,
    u.userImg
    from changehappy_goods a
    left join changehappy_user u on a.user_id = u.user_id
    left join changehappy_type b on  a.goods_type=b.id
    where a.id =#{goodsId}
  
  
    insert into changehappy_collect_goods(user_id,goods_id)
    values
    (#{userId,jdbcType=VARCHAR},#{goodsId})
  
  
    select id,headline_name headlineName,content_txt  contentTxt,goods_id goodsId,headline_type headlineType
    from changehappy_inform where headline_type=#{headlineType}
  
  
    select id,banner_url bannerUrl,banner_type bannerType,banner_status bannerStatus,banner_jump_address bannerJumpAddress from changehappy_banner where banner_status='1'
  
  
    select BZDM bzdm,DM dm,BZ bz,DICT_TYPE dtctType from changehappy_bzdm where BZDM='homeImg'
  
  
    select id,file_url goodsImg ,goods_id goodsId from changehappy_file where goods_id=#{id}
  
  
    delete  from changehappy_collect_goods where user_id = #{userId} and goods_id =#{goodsId}
  
  
    select count(*) from changehappy_attention where user_id =#{userId} and attention_id=#{attentionId} and status ='1'
  

  
    select
    a.id,a.goods_id goodsId,
    a.goods_name goodsName,
    a.user_id userId ,a.goods_price goodsPrice,
    a.goods_type goodsType,
    a.crder_time crderTime,
    a.sales,
    a.order_type_id orderTypeId,
    a.page_view pageView,
    a.goods_postage goodsPostage,
    a.goods_original_price goodsOriginalPrice
    from changehappy_goods a
    where a.stand_up_and_down='1'
    and a.goods_status='1'
    and is_timeShopping = '1'
  

  
    select
    a.id,a.goods_id goodsId,
    a.goods_name goodsName,
    a.user_id userId ,a.goods_price goodsPrice,
    a.goods_type goodsType,
    a.crder_time crderTime,
    a.sales,
    a.order_type_id orderTypeId,
    a.page_view pageView,
    a.goods_postage goodsPostage,
    a.goods_original_price goodsOriginalPrice,
    a.activity_status activityStatus
    from changehappy_goods a
    where a.stand_up_and_down='1'
    and a.goods_status='1'
    and a.order_type_id='4'
  
 
 





    
        SELECT
        a.order_status orderStatus,
        a.seller_user_id sellerUserId,
        a.order_type orderType,
        a.order_id orderId,
        b.user_name userName,
        b.user_id userId,
        c.goods_name goodsName,
        d.user_name orderUserName,
        c.goods_price goodsPrice,
        a.date_time orderTime,
        a.payment_type paymentType,
        a.goods_id goodsId,
        e.refuse_reason refuseReason,
        a.wx_order_id wxOrderId,
        a.user_site_id userSiteId,
        c.goods_postage goodsPostage,
        a.seller_goods_name sellerGoodsName,
        a.express_status expressStatus,
        a.update_time updateTime
        FROM
        changehappy_order a
        LEFT JOIN changehappy_user b ON a.user_id = b.user_id
        LEFT JOIN changehappy_goods c ON a.goods_id = c.id
        LEFT JOIN changehappy_user d ON c.user_id = d.user_id
        LEFT JOIN changehappy_sales_return e ON a.order_id = e.order_id
        WHERe
        a.user_id = #{userId,jdbcType=VARCHAR} and a.sfky='1'
        
            and a.order_status in ('4','5','6')
        
        
            and a.order_status=#{orderStatus,jdbcType=VARCHAR}
        
        
            and a.order_type =#{orderType}
        
        
            and a.order_status !='1'
        
        order by DATE_FORMAT(a.date_time, '%Y/%m/%d %H:%i:%s') desc
        LIMIT #{currPage}, #{pageSize}
    



    
        SELECT
        a.order_status orderStatus,
        a.seller_user_id sellerUserId,
        a.order_type orderType,
        a.order_id orderId,
        b.user_name userName,
        b.user_id userId,
        c.goods_name goodsName,
        d.user_name orderUserName,
        c.goods_price goodsPrice,
        a.date_time orderTime,
        a.payment_type paymentType,
        a.goods_id goodsId,
        e.refuse_reason refuseReason,
        a.wx_order_id wxOrderId,
        a.user_site_id userSiteId,
        c.goods_postage goodsPostage,
        a.seller_goods_name sellerGoodsName,
        a.express_status expressStatus
        FROM
        changehappy_order a
        LEFT JOIN changehappy_user b ON a.user_id = b.user_id
        LEFT JOIN changehappy_goods c ON a.goods_id = c.id
        LEFT JOIN changehappy_user d ON c.user_id = d.user_id
        LEFT JOIN changehappy_sales_return e ON a.order_id = e.order_id
        WHERe
        a.seller_user_id = #{sellerUserId,jdbcType=VARCHAR} and a.sfky='1'
        
            and a.order_status in ('4','5','6')
        
        
            and a.order_status=#{orderStatus,jdbcType=VARCHAR}
        
        
            and a.order_type =#{orderType}
        
        
            and a.order_status !='1'
        
        order by DATE_FORMAT(a.date_time, '%Y/%m/%d %H:%i:%s') desc
        LIMIT #{currPage}, #{pageSize}
    

    
        select a.order_status orderStatus,
        a.order_type orderType,
        a.order_id orderId,
        a.user_site_id userSiteId,
        b.user_id userId,
        b.user_name userName,
        c.goods_name goodsName,
        d.user_name orderUserName,
        c.goods_price goodsPrice,
        a.date_time orderTime,
        a.payment_type paymentType,
        a.goods_id goodsId,
        e.return_reason returnReason,
        e.return_info returnInfo,
        a.wx_order_id wxOrderId,
        a.express_status expressStatus
        from changehappy_order a
        left join changehappy_user b on a.user_id =b.user_id
        left join changehappy_goods c on a.goods_id = c.id
        left join changehappy_user d on c.user_id = d.user_id
        left join changehappy_sales_return e on a.order_id = e.order_id
        where  a.seller_user_id=#{sellerUserId,jdbcType=VARCHAR}
        
            and a.order_status in ('4','5','6')
        
        
            and a.order_status=#{orderStatus,jdbcType=VARCHAR}
        
        
            and a.order_type =#{orderType,jdbcType=VARCHAR}
        
        LIMIT #{currPage}, #{pageSize}
    
    
    select id,file_url goodsImg ,goods_id goodsId from changehappy_file where goods_id=#{id}
    

    
        insert into changehappy_order
        (user_id,goods_id,date_time,remark,order_status,order_type,order_id,
         seller_user_id,goods_name,goods_price,user_site_id,payment_type,exchange_goods_id,site_exchange_user,seller_goods_name)
         values
         (#{userId,jdbcType=VARCHAR},
         #{goodsId},
         now(),
         #{remark,jdbcType=VARCHAR},
         #{orderStatus},
         #{orderType,jdbcType=VARCHAR},
         #{orderId,jdbcType=VARCHAR},
         #{sellerUserId,jdbcType=VARCHAR},
         #{goodsName,jdbcType=VARCHAR},
         #{goodsPrice,jdbcType=VARCHAR},
         #{userSiteId,jdbcType=VARCHAR},
         #{paymentType},
         #{exchangeGoodsId},
         #{siteExchangeUser},
         #{sellerGoodsName})
    

    
    
        insert into changehappy_order
        (user_id,goods_id,date_time,remark,order_status,order_type,order_id,
         seller_user_id,goods_name,goods_price,user_site_id,payment_type,exchange_goods_id,site_exchange_user,seller_goods_name)
         values
         (#{sellerUserId,jdbcType=VARCHAR},
         #{goodsId},
         now(),
         #{remark,jdbcType=VARCHAR},
         #{orderStatus},
         #{orderType,jdbcType=VARCHAR},
         #{orderId,jdbcType=VARCHAR},
         #{userId,jdbcType=VARCHAR},
         #{goodsName,jdbcType=VARCHAR},
         #{goodsPrice,jdbcType=VARCHAR},
         #{userSiteId,jdbcType=VARCHAR},
         #{paymentType},
         #{exchangeGoodsId},
         #{siteExchangeUser},
         #{sellerGoodsName})
    
    
      update changehappy_order
      set order_status =#{orderStatus} ,
       update_time =#{updateTime} ,
       wx_order_id =#{wxOrderId}
       where order_id =#{orderId}
    
    
    select a.id goodsId,a.goods_name goodsName,a.user_id userId,a.goods_brief goodsBrief,
    b.user_name userName,b.userImg userImg,a.goods_price goodsPrice,
    a.sales,
    c.MC goodsTypeName,
    a.order_type_id orderTypeId,
    a.page_view pageView,
    a.activity_status activityStatus

    from changeHappy_goods a
    left join changehappy_user b on a.user_id = b.user_id
	left join changehappy_bzdm c on a.goods_type =c.ID
	left join changehappy_file f on a.goods_id = f.goods_id
    where a.id=#{goodsId}
    
    
    update changeHappy_goods
    set
    goods_name=#{goodsName,jdbcType=VARCHAR},user_id=#{userId},
    goods_type=#{goodsType,jdbcType=INTEGER},
    crder_time=#{crderTime},
    goods_status=#{goodsStatus},
    order_type_id=#{orderTypeId}
    where id=#{goodsId}
  
    
        insert into changehappy_order_info
        (id,user_id,exchange_id,status,crder_time,apply_count,goods_id,exchange_goods_id,sfky)
        values
        (#{id},#{userId},#{exchangeId},#{status},#{crderTime},#{applyCount},#{goodsId},#{exchangeGoodsId},'1')

        
    
        update changehappy_order_info set
        user_id=#{userId},
        exchange_id=#{exchangeId},
        status=#{status},
        apply_count=#{applyCount},
        goods_id=#{goods_id},
        exchange_goods_id=#{exchangeGoodsId}
        where id =#{id}
        
    
        select id,user_id,exchange_id,status,crder_time,apply_count,goods_id,exchange_goods_id
        from changehappy_order_info
        where sfky='1'
        
            and user_id =#{userId}
        
        
            and exchange_id =#{userId}
        
        order by DATE_FORMAT(crder_time, '%Y/%m/%d %H:%i:%s') desc
    
    
        select a.seller_user_id sellerUserId,a.order_status orderStatus,a.order_type orderType,a.order_count orderCount,a.order_id orderId,
        b.user_name userName,c.goods_name goodsName,d.user_name orderUserName,b.user_id userId,
        c.goods_price goodsPrice,a.date_time orderTime,a.payment_type paymentType,a.goods_id goodsId,
        a.site_exchange_user siteExchangeUser,a.date_time crderTime,a.user_site_id userSiteId
        from changehappy_order a
        left join changehappy_user b on a.user_id =b.user_id
        left join changehappy_goods c on a.goods_id = c.id
        left join changehappy_user d on c.user_id = d.user_id
        where  a.order_id=#{outTradeNo,jdbcType=VARCHAR}
       

    
    
        select a.seller_user_id sellerUserId,a.order_status orderStatus,a.order_type orderType,a.order_count orderCount,a.order_id orderId,
        b.user_name userName,c.goods_name goodsName,d.user_name orderUserName,b.user_id userId,
        c.goods_price goodsPrice,a.date_time orderTime,a.payment_type paymentType,a.goods_id goodsId,
        a.site_exchange_user siteExchangeUser,a.date_time crderTime,a.user_site_id userSiteId
        from changehappy_order a
        left join changehappy_user b on a.user_id =b.user_id
        left join changehappy_goods c on a.goods_id = c.id
        left join changehappy_user d on c.user_id = d.user_id
        where  a.order_id=#{outTradeNo,jdbcType=VARCHAR} and a.user_id=#{userId,jdbcType=VARCHAR}
       


    
        insert into changehappy_order_log
        (id,order_id,wx_order_id,payment_type,goods_id,user_id,crder_time,log_type,user_money,user_reeze_money)
        values
        (#{id},#{orderId},#{wxOrderId},#{paymentType},#{goodsId},#{userId},#{crderTime},#{logType},#{userMoney},#{userReezeMoney})
    
    
        select user_name userName from changehappy_user where user_id =#{userId}
    
    
      insert  into changehappy_activity
      (id,user_id,goods_id)
      values
      (#{id},#{userId},#{goodsId})
    
    
        select id,order_id
        from  changehappy_order
        where user_id=#{userId}
        and   goods_id =#{goodsId}
    
    
        insert into changehappy_sales_return
        (id,whether_goods,return_reason,return_info,order_id,return_status)
        values
        (#{id},#{whetherGoods},#{returnReason},#{returnInfo},#{orderId},#{returnStatus})
    
    
        update changehappy_sales_return
        set
        refuse_reason=#{refuseReason},
        return_status=#{returnStatus}
        where order_id=#{orderId}
    
    
      update  changehappy_order
      set order_status=#{orderStatus},
      update_time =#{updateTime}
      where order_id =#{orderId} and user_id =#{userId}
    

    
      update  changehappy_order
      set order_status=#{orderStatus},
      update_time =#{updateTime}
      where order_id =#{orderId} and user_id =#{sellerUserId}
    
    
        update changehappy_order
        set order_status='0',
        update_time =#{updateTime}
        where order_id =#{orderId}
    
    
        SELECT
        a.order_status orderStatus,
        a.seller_user_id sellerUserId,
        a.order_type orderType,
        a.order_id orderId,
        b.user_id userId,
        c.goods_name goodsName,
        c.goods_price goodsPrice,
        a.date_time orderTime,
        a.payment_type paymentType,
        a.goods_id goodsId,
        e.refuse_reason refuseReason,
        a.wx_order_id wxOrderId,
        a.user_site_id userSiteId,
        c.goods_postage goodsPostage,
        a.seller_goods_name sellerGoodsName,
        a.express_status expressStatus,
        a.update_time updateTime
        FROM
        changehappy_order a
        LEFT JOIN changehappy_user b ON a.user_id = b.user_id
        LEFT JOIN changehappy_goods c ON a.goods_id = c.id
        LEFT JOIN changehappy_user d ON c.user_id = d.user_id
        LEFT JOIN changehappy_sales_return e ON a.order_id = e.order_id
        WHERe
        a.seller_user_id = #{userId,jdbcType=VARCHAR} and a.sfky='1'
        and a.order_status ='3'