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