package com.northglass.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.northglass.entity.MachineType;
import com.northglass.entity.Machines;

public interface MachineDao extends JpaRepository<Machines, Long>{
	/*@Query("select t from Machine t where t.flag=?1")
	public List<Machines> SelectMinchineFlag(String flag);
	
	@Query("select t from Machine t where t.number=?1")
	public Machines SelectMinchineNumber(String number);
	
	@Query("select t from Machine t where t.machineType.id=?1")
	public List<Machines> SelectMinchineTypeid(Long typeid);
	

	@Query(nativeQuery=true,value="SELECT * FROM `gmms_machine` order by id desc limit 1")
    public Machines selectid();*/
	
	@Query("select t from Machines t where t.machineName = '上片机1' and t.machineType.id=1 and t.ipAddress = '192.168.10.120' and t.port = 502 and t.state = '正常' and t.connectState = '未连接' and t.workState = '暂停' and t.workId = 1 and t.flag = '1' and t.remarks = '1'  ")
    public List<Machines> findMachineDispose();
	
	@Query("select t from Machines t where t.machineType.id = 1")
    public List<Machines> findload();
	//有用
	@Query("select t from Machines t where t.machineType.id = ?1")
    public List<Machines> findLoadMachineRacksByLoadMachineId(long id);
}