package org.jeecg.modules.eam.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.eam.entity.EquipmentChangeDetail;
import org.jeecg.modules.eam.entity.EquipmentSealDetail;
import org.jeecg.modules.eam.entity.EquipmentTransferOutDetail;
import org.jeecg.modules.eam.model.DepartVo;
import org.jeecg.modules.eam.model.UserVo;

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

/**
 * @Description: 设备变动明细
 * @Author: jeecg-boot
 * @Date: 2023-04-23
 * @Version: V1.0
 */
public interface EquipmentChangeDetailMapper extends BaseMapper<EquipmentChangeDetail> {
    List<Map<String, Object>> getEquipmentChangeDetailList(@Param("equipmentChangeId") String equipmentChangeId);

    IPage<Map<String, Object>> getEquipmentChangeDetailById(IPage<Map> pageData, @Param("params") Map<String, Object> params);


    @Select("select t1.id as value,t1.realname  as text,realname  as title from sys_user t1  where t1.del_flag = '0' ")
    List<UserVo> getUser();


    @Select("select t1.id as value,t1.depart_name  as text,depart_name  as title from sys_depart t1  where t1.del_flag = '0'")
    List<DepartVo> getDepart();

    @Select("SELECT t1.item_value  as   value,  t1.item_text  as   title,t1.item_text  as text FROM v_sys_dict t1 WHERE t1.dict_code = 'technology_status'")
    List<UserVo> getTechnologyStatus();


    @Select("SELECT t1.item_value  as   value,  t1.item_text  as   title,t1.item_text  as text FROM v_sys_dict t1 WHERE t1.dict_code = 'equipment_status'")
    List<UserVo> getEquipmentStatus();


    @Select("SELECT t1.item_value  as   value,  t1.item_text  as   title,t1.item_text  as text FROM v_sys_dict t1 WHERE t1.dict_code = 'change_Type'")
    List<UserVo> getChangeType();

    /**
     * 通过主表id查询子表数据
     *
     * @param mainId 主表id
     * @return List<EquipmentSealDetail>
     */
    public List<EquipmentChangeDetail> selectByMainId(@Param("mainId") String mainId);
}