package com.northglass.repository;
|
|
import java.util.Date;
|
import java.util.List;
|
|
import org.springframework.data.jpa.repository.JpaRepository;
|
import org.springframework.data.jpa.repository.Modifying;
|
import org.springframework.data.jpa.repository.Query;
|
|
import com.northglass.entity.GalssTaskDetails;
|
import com.northglass.entity.GalssTaskHollow;
|
import com.northglass.entity.GalssTaskShelf;
|
import com.northglass.entity.GalssTaskShelf;
|
|
public interface GalssTaskHollowDao extends JpaRepository<GalssTaskHollow, Long>{
|
|
|
|
@Query("select t.processcardId from GalssTaskHollow t group by t.processcardId ")
|
public List<GalssTaskHollow> findDroplist();
|
|
|
@Query(nativeQuery=true,value="select * from gmms_galss_task_hollow where processcard_id like CONCAT('%',?1,'%') order by stop_rank desc,processcard_id desc;")
|
public List<GalssTaskHollow> findbyprocesscardid(String processcardid);
|
|
@Modifying
|
@Query("delete from GalssTaskHollow t where t.processcardId like CONCAT('%',?1,'%')")
|
public void deleteprocesscardid(String processcardid);
|
|
|
|
}
|
