package com.skua.modules.equipment.mapper;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.skua.modules.equipment.entity.EquipmentIn;
import com.skua.modules.equipment.vo.EquipmentInExcel;
import com.skua.modules.equipment.vo.EquipmentInVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 入库
 */
public interface EquipmentInMapper extends BaseMapper<EquipmentIn> {

    @Select("SELECT\n" +
            "\tei.in_order inOrder,\n" +
            "\tei.in_type inType,\n" +
            "\tGROUP_CONCAT( es.sparepart_name ) sparepartName,\n" +
            "\tei.use_by useBy,\n" +
            "\tei.choose_time chooseTime,\n" +
            "\tei.in_date inDate,\n" +
            "\tei.remark ," +
            "ei.supplies_warehouse_id suppliesWarehouseId \n" +
            "FROM\n" +
            "\tequipment_in ei\n" +
            "\tLEFT JOIN equipment_in_child eic ON eic.in_id = ei.id\n" +
            "\tLEFT JOIN equipment_sparepart_supplies es ON es.id = eic.sparepart_id ${ew.customSqlSegment}")
    List<EquipmentInExcel> queryExport(@Param(Constants.WRAPPER) QueryWrapper<EquipmentIn> queryWrapper);
}