package com.ps.visualization.dao.impl;

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

import org.springframework.stereotype.Repository;

import com.ps.base.dao.impl.BaseDaoImpl;
import com.ps.visualization.dao.RegnameProgressDao;
import com.ps.visualization.vo.RegnameProgress;

@Repository(value = "regnameProgressDao")
public class RegnameProgressDaoImpl extends
		BaseDaoImpl<RegnameProgress, Integer> implements RegnameProgressDao {

	@Override
	public List getRegnameTopKey(String regname) {
		// TODO Auto-generated method stub
		Integer num = 10;
		String sql = "";
		if (regname.equalsIgnoreCase("all")) {
			sql = "select regname,ip_num_exist b from regname_progress where rounds='"
					+ getScanRounds() + "' order by b desc limit " + num;
		} else {
			sql = "select regname,ip_num_exist b from regname_progress where regname = \""
					+ regname
					+ "\" and rounds='"
					+ getScanRounds()
					+ "' order by b desc limit " + num;
		}
		List<Object[]> stList = new ArrayList<Object[]>();
		stList = findNativeSqlQuery(sql);
		return stList;
	}

	@Override
	public List getScanProgress(String regName) {
		// TODO Auto-generated method stub
		String sql = "";
		if (regName.equalsIgnoreCase("all")) {
			sql = "select regname,ip_num_done/ip_num_total b from regname_progress where rounds='"
					+ getScanRounds() + "'order by regname asc";
		} else {
			sql = "select regname,ip_num_done/ip_num_total b from regname_progress where regname =\""
					+ regName
					+ "\" and rounds='"
					+ getScanRounds()
					+ "' order by regname asc";
		}
		List<Object[]> spList = new ArrayList<Object[]>();
		spList = findNativeSqlQuery(sql);
		return spList;
	}

}