package com.ps.visualization.dao.impl;

import java.util.ArrayList;
import java.util.List;

import org.springframework.stereotype.Repository;

import com.ps.visualization.dao.PortsinfoScadaDao;

@Repository(value = "portsinfoScadaDao")
public class PortsinfoScadaDaoImpl extends PortsinfoScadaDao {

	public List getCountryCityHotAboutScada() {
		String sql = "select ia.city,COUNT(ia.city) c FROM ip_address ia, portsinfo ps where ia.id_ip = ps.id_ip and ia.city!='' and ia.country<>'' GROUP BY ia.city";

		List<Object[]> rtsiList = new ArrayList<Object[]>();
		rtsiList = findNativeSqlQuery(sql);
		return rtsiList;
	}
}