package cn.lili.modules.order.order.mapper;

import cn.hutool.core.date.DateTime;
import cn.lili.modules.order.order.entity.dos.OrderItem;
import cn.lili.modules.order.order.entity.vo.OrderSimpleVO;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;

/**
 * 子订单数据处理层
 *
 * @author Chopper
 * @since 2020/11/17 7:34 下午
 */
public interface OrderItemMapper extends BaseMapper<OrderItem> {

    /**
     * 获取等待操作订单子项目
     *
     * @param queryWrapper 查询条件
     * @return 订单子项列表
     */
    @Select("SELECT * FROM li_order_item AS oi INNER JOIN li_order AS o ON oi.order_sn=o.sn ${ew.customSqlSegment}")
    List<OrderItem> waitOperationOrderItem(@Param(Constants.WRAPPER) Wrapper<OrderSimpleVO> queryWrapper);

    /**
     * 未申请售后的订单，进行售后过期标识
     *
     * @param expiredTime 过期时间
     */
    @Update("update li_order_item  oi INNER JOIN li_order AS o ON oi.order_sn=o.sn  set after_sale_status = 'EXPIRED' where after_sale_status = " +
            "'NOT_APPLIED' and o.complete_time < #{expiredTime}")
    void expiredAfterSaleStatus(DateTime expiredTime);

    /**
     * 检查售后表，根据售后表中的业务判定是否需要更新售后状态
     *
     * @param expiredTime 过期时间
     */
    @Update(" UPDATE li_order_item AS oi " +
            "INNER JOIN li_order AS o ON oi.order_sn = o.sn " +
            "INNER JOIN li_after_sale AS af ON af.order_item_sn = oi.sn " +
            "SET oi.after_sale_status = 'EXPIRED' " +
            "WHERE " +
            "oi.after_sale_status in ('ALREADY_APPLIED','PART_AFTER_SALE') " +
            "AND af.service_status in ('COMPLETE','REFUSE','SELLER_TERMINATION','BUYER_CANCEL') " +
            "AND o.complete_time <  #{expiredTime} ")
    void expiredAfterSaleStatusExecuteByAfterSale(DateTime expiredTime);
}