package base.page.controller;

import base.Util.BaseController;
import base.Util.BaseUtil;
import base.Util.Controller;
import base.page.model.TempletModel;
import base.sys.model.IdGenModel;
import base.sys.model.LogModel;
import com.jfinal.plugin.activerecord.Db;
import com.jfinal.plugin.activerecord.Page;
import com.jfinal.plugin.activerecord.Record;

import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 控制类
 */
@Controller("/page/templet")
public class TempletController extends BaseController {
    Map<String, Object> map = new HashMap<String, Object>();
    String status= BaseUtil.ERROR;

    /**
     * 默认访问
     *
     */
    public void index(){
        String sql=" select NOW() as today FROM  DUAL ";
        Record record= Db.findFirst(sql);
        renderJson(record.get("today"));
    }

    /**
     * 添加
     */
    public void add(){
        map=new HashMap<String, Object>();
        status= BaseUtil.ERROR;
        if(TempletModel.dao.set("id", IdGenModel.dao.getNewId(TempletModel.table_name))
                .save())
         status= BaseUtil.SUCCESS ;
        map.put("status",status);
        LogModel.saveLog("templet"
                ,Thread.currentThread() .getStackTrace()[1].getClassName()
                        +"."+Thread.currentThread() .getStackTrace()[1].getMethodName()
                ,"添加",map,getRequest());
        renderJson(map);
    }

    /**
     * 修改
     */
    public void update(){
        map=new HashMap<String, Object>();
        status= BaseUtil.ERROR;
        if(TempletModel.dao.set("id",getPara("id"))
                .update())
            status= BaseUtil.SUCCESS ;
        map.put("status",status);
        LogModel.saveLog("templet"
                ,Thread.currentThread() .getStackTrace()[1].getClassName()
                        +"."+Thread.currentThread() .getStackTrace()[1].getMethodName()
                ,"修改",map,getRequest());
        renderJson(map);
    }

    /**
     * 删除
     */
    public void delete(){
        map=new HashMap<String, Object>();
        status= BaseUtil.ERROR;
        if(TempletModel.dao.set("id",getPara("id")).delete())
        status= BaseUtil.SUCCESS ;
        map.put("status",status);
        LogModel.saveLog("templet"
                ,Thread.currentThread() .getStackTrace()[1].getClassName()
                        +"."+Thread.currentThread() .getStackTrace()[1].getMethodName()
                ,"删除",map,getRequest());
        renderJson(map);
    }

    /**
     * 单查
     */
    public void one(){
        map=new HashMap<String, Object>();
        status= BaseUtil.ERROR;
        String id=getPara("id","");
        if(!"".equals(id)){
            map.put("info",Db.findFirst(" select * from "+TempletModel.table_name+" where id="+id));
            status= BaseUtil.SUCCESS ;
        }
        map.put("status",status);
        renderJson(map);
    }

    /**
     * 查询
     */
    public void list(){
        map=new HashMap<String, Object>();
        status= BaseUtil.SUCCESS ;
        String sql="select * ";
        String sqlWhere=" from "+TempletModel.table_name+" where 1=1 ";

        if(getPara("pageNo")!=null&&getPara("pageSize")!=null){//分页
            Page<Record> recordPage=Db.paginate(getParaToInt("pageNo",1),getParaToInt("pageSize",10),sql,sqlWhere);
            map.put("list",recordPage.getList());
            map.put("pageNumber",recordPage.getPageNumber());
            map.put("pageCount",recordPage.getTotalPage());
            map.put("rowCount",recordPage.getTotalRow());
        }else{
            List<Record> list=Db.find(sql+sqlWhere);
            map.put("list",list);
        }
        map.put("status",status);
        renderJson(map);
    }

}