package cn.ksource.web.facade.knowledge.knowintegral;

import java.util.List;
import java.util.Map;
import java.util.Set;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.dao.SqlParameter;
import cn.ksource.core.util.StringUtil;

@Service("knowIntegralFacade")
@SuppressWarnings("unchecked")
public class KnowIntegralFacadeImpl implements KnowIntegralFacade {
	
	@Autowired
	private BaseDao baseDao;
	
	/**
	 * 批量添加方法
	 * */
	private void plInsert(Map<String, String> params,String sql) {
		Set<String> keys = params.keySet();
		for (String key : keys) {
			String id = StringUtil.getUUID();
			baseDao.execute(sql,new SqlParameter("id",id).addValue("type", key).addValue("score", params.get(key)));
		}
	}

	@Override
	public void saveIntegralRule(Map<String, String> params) {
		//先清除表信息
		String sql = new String("DELETE FROM KM_SCORE_RULE");
		baseDao.execute(sql, new SqlParameter());
		//添加数据
		plInsert(params,new String("INSERT INTO KM_SCORE_RULE VALUES(:id,:type,:score)"));
	}



	@Override
	public void saveZjDjRule(Map<String, String> params) {
		//先清除表信息
		String sql = new String("DELETE FROM KM_EXPERT_LEVEL_RULE");
		baseDao.execute(sql, new SqlParameter());
		//添加数据
		plInsert(params,new String("INSERT INTO KM_EXPERT_LEVEL_RULE VALUES(:id,:type,:score)"));
	}

	@Override
	public List<Map> getIntegralRules() {
		String sql = new String("SELECT * FROM KM_SCORE_RULE ORDER BY TYPE");
		return baseDao.queryForList(sql);
	}

	@Override
	public List<Map> getZjDjRules() {
		String sql = new String("SELECT * FROM KM_EXPERT_LEVEL_RULE ORDER BY TYPE");
		return baseDao.queryForList(sql);
	}

}