package org.jeecg.modules.eam.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.eam.entity.ProjectMaintenanceOrder;
import org.jeecg.modules.eam.model.DepartVo;
import org.jeecg.modules.eam.model.SupplierVo;

import java.util.List;

/**
 * @Description: 项目性维修
 * @Author: jeecg-boot
 * @Date:   2023-05-06
 * @Version: V1.0
 */
public interface ProjectMaintenanceOrderMapper extends BaseMapper<ProjectMaintenanceOrder> {


    @Select("select t1.id as value,t1.name  as text,  t1.name  as title from mom_base_supplier t1  where t1.del_flag = '0'  GROUP by t1.name ORDER BY t1.create_time desc")
    List<SupplierVo> getSupplier();

    @Select("select t1.id as value,t1.name  as text,  t1.name  as title from mom_base_team t1  where t1.del_flag = '0'   ORDER BY t1.create_time desc")
    List<SupplierVo> getTeam();

    @Select("select t1.id as value,t1.realname  as text,  t1.realname  as title from sys_user t1  where t1.del_flag = '0'  ORDER BY t1.create_time desc")
    List<SupplierVo> getUser();
}