package cn.ksource.web.service.device;

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

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("deviceService")
public class DeviceServiceImpl implements DeviceService {

	@Autowired
	private BaseDao baseDao;

	@Override
	public boolean saveLinkDevices(String flowId, String[] deviceId) {
		if(null!=deviceId && deviceId.length!=0) {
			List<SqlParameter> list = new ArrayList<SqlParameter>();
			for(String  device : deviceId) {
				SqlParameter sqlParameter = new SqlParameter();
				sqlParameter.put("id", StringUtil.getUUID());
				sqlParameter.put("ciId", device);
				sqlParameter.put("flow_id", flowId);
				list.add(sqlParameter);
			}
			
			String insertCmdb_ci_ref_orderSql = "INSERT CMDB_CI_REF_ORDER(ID,FLOW_ID,CI_ID) VALUES (:id,:flow_id,:ciId)";
			baseDao.executeBatch(insertCmdb_ci_ref_orderSql,list);
			return true;
		}
		return false;
	}

	@Override
	public List queryLinkDevices(String flowId) {
		String selectSql = "SELECT B.*,A.ID AS LINK_ID,(SELECT C.NAME FROM CMDB_CI_CATEGORY C WHERE C.ID = B.LV1_ID ) AS FIRST_NAME,(SELECT D.NAME FROM CMDB_CI_CATEGORY D WHERE D.ID = B.LV2_ID ) AS SECOND_NAME,(SELECT E.NAME FROM CMDB_CI_CATEGORY E WHERE E.ID = B.LV3_ID ) AS THIRD_NAME FROM CMDB_CI_REF_ORDER A,CMDB_CI_BASE B WHERE A.CI_ID = B.ID AND B.STATE = 1 AND A.FLOW_ID = :flowId";
		return baseDao.queryForList(selectSql,new SqlParameter("flowId",flowId));
	}

	@Override
	public boolean deleteLinkDevice(String id) {
		String deleteCMDB_CI_REF_ORDERSql = "DELETE FROM CMDB_CI_REF_ORDER WHERE ID = :id ";
		baseDao.execute(deleteCMDB_CI_REF_ORDERSql, new SqlParameter("id",id));
		return true;
	}
}