package com.hb.proj.base.service;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Map;

import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.hb.proj.model.ParamDefinePO;
import com.hb.xframework.dao.core.SpringJdbcDAO;
import com.hb.xframework.dao.util.PageModel;
import com.hb.xframework.dao.util.UUIDHexGenerator;

@Service
public class ParamMgrService {

	@Autowired
	private SpringJdbcDAO  dao;
	
	
	public List<Map<String,Object>>  loadAll(){
		return dao.queryForList("select param_name,param_code from tzl_param_define  where del_if=false order by param_code");
	}
	
	
	public PageModel<Map<String,Object>> query(Map<String,Object> args,int pageNo,int pageSize){
		List<Object> sqlParams=new ArrayList<Object>();
		StringBuilder sql=new StringBuilder(100);
		sql.append("select pd.*,ifnull(u.real_name,pd.modify_by) modify_by_name ");
		sql.append(" from tzl_param_define pd ");
		sql.append(" left join tsys_user u on pd.modify_by=u.user_id");
		sql.append(" where pd.del_if=false ");
		
		if(args!=null&&StringUtils.isNotBlank((String)args.get("paramName"))) {
			sql.append(" and (param_name like ? or param_code like ?)");
			sqlParams.add("%"+args.get("paramName")+"%");
			sqlParams.add("%"+args.get("paramName")+"%");
		}
		
		sql.append(" order by param_name");
		
		Object[] sqlArgs=sqlParams.size()>0?sqlParams.toArray():null;
		return dao.queryForPagedData(sql.toString(),pageNo, pageSize,sqlArgs);
	}
	
	public String add(ParamDefinePO param) {
		UUIDHexGenerator uuid=UUIDHexGenerator.getInstance();
		param.setId(uuid.generate());
		param.setModifyTime(new Date());
		param.setDelIf(false);
		dao.insert(param,"tzl_param_define");
		return param.getId();
	}
	
	public boolean delete(String id) {
		String sql="update  tzl_param_define set del_if=true where id=?";
		dao.exeUpdate(sql,id);
		return true;
	}
	
	public ParamDefinePO get(String id) {
		return dao.queryForPojo("select * from tzl_param_define  where del_if=false and id=?",ParamDefinePO.class,id);
	}
	
	public ParamDefinePO getByCode(String paramCode) {
		return dao.queryForPojo("select * from tzl_param_define  where del_if=false and param_code=?",ParamDefinePO.class,paramCode);
	}
	
	public boolean update(ParamDefinePO param) {
		param.setModifyTime(new Date());
		return dao.update(param, "tzl_param_define", "id")>0;
	}
	
}