潘钊 / bsth_control · Files

package com.bsth.repository;

import com.bsth.entity.LineRegion;
import com.bsth.entity.LsStationRoute;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @Author Hill
 */
@Repository
public interface LineRegionRepository extends BaseRepository<LineRegion, Integer> {

	/**
	 * 获取线路区间的站点路由
	 * @param regionId
	 * @return
	 */
	@Query(value = "SELECT b.* FROM bsth_c_line_region_stationroute a LEFT JOIN bsth_c_ls_stationroute b ON a.station_route_id = b.id WHERE a.region_id = ?1", nativeQuery = true)
	List<LsStationRoute> findStationRoutes(Integer regionId);

	/**
	 * 获取线路版本最大线路区间序号
	 * @param lineId
	 * @param version
	 * @return
	 */
	@Query(value = "SELECT IFNULL(MAX(seq), 0) FROM bsth_c_line_region lr where lr.line = ?1 and lr.version = ?2", nativeQuery = true)
	Integer getLatestSeq(Integer lineId, Integer version);
}