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);
|
}
|
