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);
    }


    /**
     * 查询数据列表
     * @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);
    }
}