package com.ruoyi.project.service.impl;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ruoyi.project.domain.GiApi;
import com.ruoyi.project.domain.dto.ApiDTO;
import com.ruoyi.project.mapper.ApiMapper;
import com.ruoyi.project.service.IApiService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.servlet.http.HttpServletRequest;
import java.util.ArrayList;
import java.util.List;
import java.util.Map;

@Service
public class ApiServiceImpl  extends ServiceImpl<ApiMapper, GiApi> implements IApiService {
    @Autowired
      ApiMapper mapper;
    /**
     * 主键查询详细
     * @param code
     * @return
     */
    public GiApi getCode(String code){
        QueryWrapper <GiApi> wrapper=new QueryWrapper<>();
        wrapper.eq("api_Code",code);
        return mapper.selectOne(wrapper);
    }

    public String buildSql(HttpServletRequest request, String sql) {

//        JSONArray requestParams = JSON.parseArray(config.getParams());
//        for (int i = 0; i < requestParams.size(); i++) {
//            JSONObject jo = requestParams.getJSONObject(i);
//            String name = jo.getString("name");
//            String type = jo.getString("type");
//            String old = '$' + name;
//
//            String value = request.getParameter(name);
//
//            //不是数字类型的值要加单引号
//            if (!"number".equals(type)) {
//                value = String.format("'%s'", value);
//            }
//
//            sql = sql.replace(old, value);
//        }

        return sql;
    }

    /**
     * 查询数据列表
     * @param DTO
     * @return
     */
    public List<Map<String,Object>> getListSql(String sql, ApiDTO DTO) {
        if(DTO.getParams()!=null) {
            for (String key : DTO.getParams().keySet()) {
                sql = sql.replace("@" + key, DTO.getParams().get(key) + "");
            }
        }
        return mapper.executeSql(sql);
    }

    /**
     * 查询数据列表
     * @param DTO
     * @return
     */
    public String getStringSql(String sql, ApiDTO DTO) {
        if(DTO.getParams()!=null) {
            for (String key : DTO.getParams().keySet()) {
                sql = sql.replace("@" + key, DTO.getParams().get(key) + "");
            }
        }
        return mapper.getClob(sql);
    }
}