package com.ui.ctrl;

import com.ui.contants.HttpUriContants;
import com.ui.http.HttpRestClient;
import com.ui.model.BaseResponse;
import com.ui.model.domain.SqlOperateModel;
import com.ui.model.req.PageRequest;
import com.ui.model.req.SqlOpLogsReq;
import com.ui.model.req.User;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.core.ParameterizedTypeReference;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.servlet.ModelAndView;

import javax.servlet.http.HttpSession;
import java.util.List;

/**
 * Created by craig.qin on 2017/6/26.
 * SQL通用操作-查询
 */
@RestController
@RequestMapping("/sqlOperate")
public class SqlOperateCtrl {
    Logger log = LoggerFactory.getLogger(SqlOperateCtrl.class);
    @Autowired
    private HttpRestClient httpClient;

    /*
    跳转到sql通用查询界面
     */
    @RequestMapping("/toSqlOperate")
    public ModelAndView toSqlOperate(){
        return new ModelAndView("sqloperate/sqloperate");
    }

    /*
    查询
     */
    @RequestMapping("/queryDbList")
    @ResponseBody
    public BaseResponse queryDbList( HttpSession session,SqlOperateModel sqlOperateModel){
        BaseResponse res = httpClient.defaultPost(HttpUriContants.SQLOPERATE_QUERY_DBLIST, sqlOperateModel, BaseResponse.class);
        return res;
    }

    /*
    查询
     */
    @RequestMapping("/query")
    @ResponseBody
    public BaseResponse query( HttpSession session,SqlOperateModel sqlOperateModel){
        User u = (User) session.getAttribute("user");
        sqlOperateModel.setUserId(u.getId());
        sqlOperateModel.setUserName(u.getName());
        BaseResponse res = httpClient.defaultPost(HttpUriContants.SQLOPERATE_QUERY, sqlOperateModel, BaseResponse.class);
        return res;
    }

    @RequestMapping("/sqlLogs")
    public ModelAndView sqlOperateLogs(){
        ModelAndView mv = new ModelAndView("sqloperate/sqlOperateLogs");
        BaseResponse<List<User>> resp = httpClient.defaultPost(HttpUriContants.GET_All_USER,null, BaseResponse.class);
        mv.addObject("users",resp.getData());
        return mv;
    }

    @RequestMapping("/querySqlLogs")
    @ResponseBody
    public BaseResponse querySqlLogs(SqlOpLogsReq req){
        BaseResponse resp = httpClient.defaultPost(HttpUriContants.SQLOPERATE_LOGS_QUERY, req, BaseResponse.class);
        return resp;

    }


}