package cn.ksource.web.facade.sys;

import java.util.Map;

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

import cn.ksource.beans.LARKS_PLATFORM_VERSION;
import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.page.PageInfo;
import cn.ksource.core.util.DateUtil;
import cn.ksource.core.util.StringUtil;

@Service("sysPtVersionFacade")
public class SysPtVersionFacadeImpl implements SysPtVersionFacade {
	
	@Autowired
	private BaseDao baseDao;

	@Override
	public Integer queryPtVersionCount(Map<String, String> params) {
		StringBuilder sql = new StringBuilder("SELECT COUNT(DISTINCT A.ID) FROM LARKS_PLATFORM_VERSION A ");
		queryPtVersionIf(params,sql);
		return baseDao.queryForInteger(sql.toString(), params);
	}

	@Override
	public PageInfo queryPtVersionData(PageInfo pageInfo,
			Map<String, String> params) {
		StringBuilder sql = new StringBuilder("SELECT * FROM LARKS_PLATFORM_VERSION A");
		queryPtVersionIf(params, sql);
		sql.append(" ORDER BY A.CREATE_TIME DESC");
		return baseDao.queryforSplitPageInfo(pageInfo, sql.toString(), params);
	}

	private void queryPtVersionIf(Map<String, String> params, StringBuilder sql) {
		sql.append(" WHERE 1=1");
		//版本号
		if(StringUtil.isNotBlank(String.valueOf(params.get("code")))){
			sql.append(" AND A.VERSION_CODE LIKE :code");
			String code = String.valueOf(params.get("code"));
			params.put("code", "%"+code+"%");
		}
		//申请时间
		if(StringUtil.notEmpty(String.valueOf(params.get("beginTime")))){
			String beginTime = String.valueOf(params.get("beginTime"));
			params.put("beginTime", beginTime+"000000");
			sql.append(" AND A.CREATE_TIME >:beginTime ");
		}
		if(StringUtil.notEmpty(String.valueOf(params.get("endTime")))){
			String endTime = String.valueOf(params.get("endTime"));
			params.put("endTime", endTime+"235959");
			sql.append(" AND A.CREATE_TIME < :endTime");
		}
	}

	@Override
	public Map getPtVersionById(String id) {
		return new LARKS_PLATFORM_VERSION(id).getBeanMapById();
	}

	@Override
	public Integer savePtVersion(Map<String, String> params) {
		params.put("id", StringUtil.getUUID());
		params.put("createTime", DateUtil.getCurrentDate14().toString());
		String sql = new String("INSERT INTO LARKS_PLATFORM_VERSION VALUES(:id,:code,:createTime,:userId,:userName,:content,2)");
		return baseDao.execute(sql, params);
	}

	@Override
	public void updatePtVersion(Map<String, String> params) {
		new LARKS_PLATFORM_VERSION(params.get("id")).setVersion_code(params.get("code")).setContent(params.get("content")).update();
	}

	@Override
	public void updateVersionState(Map<String, String> params) {
		baseDao.execute(new String("UPDATE LARKS_PLATFORM_VERSION SET STATUS = 2"), params);
		new LARKS_PLATFORM_VERSION(params.get("id")).setStatus(1).update();
	}

	@Override
	public Map getCurrentVersion() {
		String sql = new String("SELECT * FROM LARKS_PLATFORM_VERSION WHERE STATUS = 1");
		return baseDao.queryForMap(sql);
	}

}