package com.hx.mybatisTool;

import com.hx.exception.TipsException;
import com.hx.util.SimpleTool;
import com.hx.util.StringUtils;

import java.util.Map;

/**
 * mybatis 自定义处理sql语句
 * @author chenjiahe
 * @Data: 2020-06-08
 */
public class SqlSentence {

	/**执行语句*/
	private String sqlSentence;

	/**新增存在查询判断*/
	private String whereExist;

	private Map<String,Object> m;
    /**排序*/
	private String orderBy;
    /**开始页数*/
	private Integer startPage = 0;
    /**每页数量*/
	private Integer pageNum = 0;

	//////////////////////////////////////////////////////////////

	/********************mother****************************/

	public SqlSentence()
	{

	}

	public SqlSentence(Class c, String where, Map<String, Object> values)
	{
		if(StringUtils.isEmpty(where))
		{
			throw new TipsException("sql is null");
		}

		if(values == null)
		{
			throw new TipsException("values is null");
		}

		sqlSentence = "select * from " + c.getSimpleName()+ " where " + where;
		m = values;
	}

	public SqlSentence(String where, Map<String, Object> values)
	{
		if(StringUtils.isEmpty(where))
		{
			throw new TipsException("sql is null");
		}

		if(values == null)
		{
			throw new TipsException("values is null");
		}

		sqlSentence = where;
		m = values;
	}


	/**
	 * sql整条语句
	 * @param sql 如：select * from user Where name = #{m.userName} order by age desc
	 * @param values 存放的值如：values.put("userName","ChenJiaHe")
	 */
	public void sqlSentence(String sql,Map<String,Object> values) {
		if(StringUtils.isEmpty(sql))
		{
			throw new TipsException("sql is null");
		}

		if(values == null)
		{
			throw new TipsException("values is null");
		}

		sqlSentence = sql;
		m = values;
	}

	/**
	 * 查询的语句
	 * @param sql 如：id = #{m.userId} order by age DESC
	 * @param values 存放的值如：values.put("userId","123456")
	 */
	public void sqlWhere(String sql,Map<String,Object> values) {
		if(!SimpleTool.checkNotNull(values)){
			throw new TipsException("values is null");
		}
		if(!SimpleTool.checkNotNull(sql)) {
			sql = "1=1";
		}
		sqlSentence = sql;
		m = values;
	}

	/**
	 * 更新语句的语句
	 * @param sql 如：name = #{m.name},age = ? WHERE id = #{m.id}
	 * @param values 存放的值
	 */
	public void sqlUpdate(String sql,Map<String,Object> values) {
		if(!SimpleTool.checkNotNull(values)){
			throw new TipsException("values is null");
		}
		m = values;
		sqlSentence = sql;
	}

	
	/************************************************************************/

	public Map<String, Object> getM() {
		return m;
	}

	public void setM(Map<String, Object> m) {
		this.m = m;
	}

	public String getSqlSentence() {
		return sqlSentence;
	}

	public void setSqlSentence(String sqlSentence) {
		this.sqlSentence = sqlSentence;
	}

    public String getOrderBy() {
        return orderBy;
    }

    public void setOrderBy(String orderBy) {
        this.orderBy = orderBy;
    }

    public Integer getStartPage() {
        return startPage;
    }

    public void setStartPage(Integer startPage) {
        this.startPage = startPage;
    }

    public Integer getPageNum() {
        return pageNum;
    }

    public void setPageNum(Integer pageNum) {
        this.pageNum = pageNum;
    }

    public Integer getStartIndex()
    {
        return (startPage - 1) * pageNum;
    }

	public String getWhereExist() {
		return whereExist;
	}

	public void setWhereExist(String whereExist) {
		if(StringUtils.isNull(whereExist)){
			whereExist = null;
		}
		this.whereExist = whereExist;
	}
}