package com.nq.service.impl;

import cn.hutool.core.date.DateTime;
import cn.hutool.core.date.DateUtil;
import cn.hutool.http.HttpUtil;
import com.alibaba.fastjson2.JSONArray;
import com.alibaba.fastjson2.JSONObject;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.google.common.collect.Lists;
import com.google.common.collect.Maps;
import com.google.gson.Gson;
import com.google.gson.reflect.TypeToken;
import com.nq.common.ServerResponse;
import com.nq.dao.*;
import com.nq.enums.EConfigKey;
import com.nq.enums.EStockType;
import com.nq.pojo.*;
import com.nq.pojo.reponse.RPageInfo;
import com.nq.service.*;
import com.nq.utils.http.HttpClientRequest;
import com.nq.utils.PropertiesUtil;
import com.nq.utils.http.HttpRequest;
import com.nq.utils.redis.RedisKeyUtil;
import com.nq.utils.redis.RedisShardedPoolUtils;
import com.nq.utils.stock.pinyin.GetPyByChinese;
import com.nq.utils.stock.qq.QqStockApi;
import com.nq.utils.stock.sina.StockApi;
import com.nq.vo.stock.*;
import com.nq.vo.stock.k.MinDataVO;
import com.nq.vo.stock.k.echarts.EchartsDataVO;

import java.lang.reflect.Type;
import java.math.BigDecimal;
import java.math.RoundingMode;
import java.util.*;
import javax.annotation.Resource;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import lombok.Data;
import org.apache.commons.lang3.StringUtils;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import static com.nq.utils.timeutil.DateTimeUtil.getWeekDay;

@Service("iStockService")
public class StockServiceImpl implements IStockService {
    private static final Logger log = LoggerFactory.getLogger(StockServiceImpl.class);

    @Autowired
    StockMapper stockMapper;

    @Autowired
    IStockMarketsDayService iStockMarketsDayService;

    @Resource
    StockFuturesMapper stockFuturesMapper;

    @Resource
    StockIndexMapper stockIndexMapper;

    @Autowired
    IUserService iUserService;

    @Autowired
    ISiteSettingService iSiteSettingService;

    @Resource
    StockDzMapper stockDzMapper;

    @Autowired
    IPriceServices iPriceServices;

    @Autowired
    SiteNewsMapper siteNewsMapper;

    @Autowired
    StockConfigMapper stockConfigMapper;

    @Resource
    StockSettingMapper stockSettingMapper;

    public ServerResponse getMarket() {
        String market_url = PropertiesUtil.getProperty("sina.market.url");
        String result = null;
        try {
            result = HttpClientRequest.doGet(market_url);
        } catch (Exception e) {
            log.error("e = {}", e);
        }
        String[] marketArray = result.split(";");
        List<MarketVO> marketVOS = Lists.newArrayList();
        for (int i = 0; i < marketArray.length; i++) {
            String hqstr = marketArray[i];
            try {
                if (StringUtils.isNotBlank(hqstr)) {
                    hqstr = hqstr.substring(hqstr.indexOf("\"") + 1, hqstr.lastIndexOf("\""));
                    MarketVO marketVO = new MarketVO();
                    String[] sh01_arr = hqstr.split(",");
                    marketVO.setName(sh01_arr[0]);
                    marketVO.setNowPrice(sh01_arr[1]);
                    marketVO.setIncrease(sh01_arr[2]);
                    marketVO.setIncreaseRate(sh01_arr[3]);
                    marketVOS.add(marketVO);
                }
            } catch (Exception e) {
                log.error("str = {} ,  e = {}", hqstr, e);
            }
        }
        MarketVOResult marketVOResult = new MarketVOResult();
        marketVOResult.setMarket(marketVOS);
        return ServerResponse.createBySuccess(marketVOResult);
    }

    public ServerResponse getStock(int pageNum, int pageSize, String keyWords, String stockPlate, String stockType, HttpServletRequest request) {
        List<Stock> stockList = new ArrayList<>();
        if (stockType.equals("99")) {
            PageHelper.startPage(pageNum, pageSize);
            stockList.addAll(stockMapper.findZtStockListByKeyWords(keyWords, stockPlate, "MEX", Integer.valueOf(0)));
        } else if (stockType.equals("100")) {
            User user = iUserService.getCurrentRefreshUser(request);
            if (user == null) {
                return ServerResponse.createByErrorMsg("Please log in");
            }
            PageHelper.startPage(pageNum, pageSize);
            stockList.addAll(stockMapper.findOptions(user.getId() + ""));
        } else if (stockType.equals("qh")) {
            PageHelper.startPage(pageNum, pageSize);
            List<StockDz> stockDzs = stockDzMapper.findStockListByKeyWords(keyWords);
            for (int i = 0; i < stockDzs.size(); i++) {
                Stock dzStock = new Stock();
                StockDz stockDz = stockDzs.get(i);
                dzStock.setStockName(stockDz.getStockName());
                dzStock.setStockCode(stockDz.getStockCode());
                dzStock.setStockGid(stockDz.getStockGid());
                dzStock.setStockType(stockDz.getStockType());
                stockList.add(dzStock);
            }
        } else {
            PageHelper.startPage(pageNum, pageSize);
            stockList.addAll(stockMapper.findStockListByKeyWords(keyWords, stockPlate, stockType, Integer.valueOf(0), pageNum - 1, pageSize));
        }

        List<StockListVO> stockListVOS = Lists.newArrayList();
        if (stockList.size() > 0){
            stockListVOS.addAll(StockApi.getStockReailTimes(stockList));
        }
        PageInfo pageInfo = new PageInfo(stockList);
        pageInfo.setList(stockListVOS);
        return ServerResponse.createBySuccess(pageInfo);
    }

    @Override
    public ServerResponse getStockByType(int pageNum, int pageSize, String orderBy, String keyWords, String stockType, HttpServletRequest request) {
        PageHelper.startPage(pageNum, pageSize);
        List<Stock> stockList = stockMapper.findStockByType(orderBy, stockType, keyWords);
        // 获取分页信息
        PageInfo<Stock> pageInfo = new PageInfo<>(stockList);

        List<StockListVO> stockListVOS = Lists.newArrayList();
        if (stockList.size() > 0) {
            stockListVOS.addAll(Objects.requireNonNull(StockApi.getStockReailTimes(stockList)));
        }

        RPageInfo resultPageInfo = new RPageInfo();
        resultPageInfo.setList(stockListVOS);
        resultPageInfo.setStockType(stockType);
        // 设置分页信息
        resultPageInfo.setTotal(pageInfo.getTotal());
        resultPageInfo.setPageNum(pageInfo.getPageNum());
        resultPageInfo.setPageSize(pageInfo.getPageSize());
        resultPageInfo.setPages(pageInfo.getPages());
        resultPageInfo.setHasNextPage(pageInfo.isHasNextPage());
        return ServerResponse.createBySuccess(resultPageInfo);
    }

    @Override
    public ServerResponse getDateline(HttpServletResponse paramHttpServletResponse, String paramString) {
        return null;
    }


    public ServerResponse getSingleStock(String code, HttpServletRequest request) {
        if (StringUtils.isBlank(code))
            return ServerResponse.createByErrorMsg("");
        Stock stock = stockMapper.findStockByCode(code);
        DataStockBean cacheBaseStock = RedisKeyUtil.getCacheBaseStock(stock.getStockType(), stock.getStockCode());
        Integer depositAmt = 0;
        String introduction = null;
        StockVO   stockVO = StockApi.assembleInStockVO(stock);
        stockVO.setDepositAmt(depositAmt);
        stockVO.setNowPrice(iPriceServices.getNowPrice(stock.getStockCode()).toString());
        stockVO.setType(stock.getStockType());
        stockVO.setId(stock.getId().intValue());
        stockVO.setCode(stock.getStockCode());
        stockVO.setName(stock.getStockName());
        stockVO.setSpell(stock.getStockSpell());
        stockVO.setGid(stock.getStockGid().toUpperCase());
        Map<String, Object> newStock = iPriceServices.getNewStock(stock.getStockCode());
        stockVO.setHcrate(newStock.get("ChgPct").toString().replaceAll("%", ""));
        stockVO.setToday_max(newStock.get("High").toString());
        stockVO.setToday_min(newStock.get("Low").toString());
        if(null != cacheBaseStock){
            stockVO.setOpen_px(cacheBaseStock.getOpen());
            stockVO.setPreclose_px(cacheBaseStock.getPrevClose());
        }
        Map map = Maps.newHashMap();
        map.put("introduction", introduction);
        map.put("stock", stockVO);
        return ServerResponse.createBySuccess(map);
    }

    public Map getSingleStock(String code) {
        if (StringUtils.isBlank(code))
            return null;
        Stock stock = stockMapper.findStockByCode(code);
        DataStockBean cacheBaseStock = RedisKeyUtil.getCacheBaseStock(stock.getStockType(), stock.getStockCode());
        Integer depositAmt = 0;
        String introduction = null;
        StockVO   stockVO = StockApi.assembleInStockVO(stock);
        stockVO.setDepositAmt(depositAmt);
        stockVO.setNowPrice(iPriceServices.getNowPrice(stock.getStockCode()).toString());
        stockVO.setType(stock.getStockType());
        stockVO.setId(stock.getId().intValue());
        stockVO.setCode(stock.getStockCode());
        stockVO.setName(stock.getStockName());
        stockVO.setSpell(stock.getStockSpell());
        stockVO.setGid(stock.getStockGid().toUpperCase());
        if(null != cacheBaseStock){
            stockVO.setOpen_px(cacheBaseStock.getOpen());
            stockVO.setPreclose_px(cacheBaseStock.getPrevClose());
        }
        Map map = Maps.newHashMap();
        map.put("introduction", introduction);
        map.put("stock", stockVO);
        return map;
    }


    //美股
    public ServerResponse getSingleStockByCode(String code) {
        if (StringUtils.isBlank(code))
            return ServerResponse.createByErrorMsg("");
        Stock stock = new Stock();
        Integer depositAmt = 0;
        String introduction = null;
        String result = null;
        JSONObject json = null;
        //期货
        String url = null;
        if (code.contains("sh") || code.contains("sz")) { //指数
            StockIndex model = stockIndexMapper.selectIndexByCode(code.replace("sh", "").replace("sz", ""));
            stock.setStockGid(model.getIndexGid());
            stock.setStockCode(model.getIndexCode());
            stock.setStockName(model.getIndexName());
            stock.setAddTime(model.getAddTime());
            stock.setId(model.getId());
            stock.setStockSpell("0");
            depositAmt = model.getDepositAmt();
            introduction = model.getIntroduction();
        } else {//股票

            stock = this.stockMapper.findStockByCode(code);
            if (stock == null)
                return ServerResponse.createByErrorMsg("");
        }
        String gid = stock.getStockGid();
        StockUsVO stockVO = new StockUsVO();
        if (gid.contains("us")) {
            String us = RedisShardedPoolUtils.get(stock.getStockGid(), 2);
            stockVO = StockApi.otherUsStockVO(us);
            String type = "105".equals(stockVO.getType()) ? ".O" : ".N";
            url = (PropertiesUtil.getProperty("us.stock.introduction.url") + stock.getStockCode() + type);
            result = HttpClientRequest.doGet(url);
            if (result.contains("msg")) {
                introduction = "暂无数据";
            } else {
                json = JSONObject.parseObject(result);
                if (json.getJSONObject("data").getJSONArray("gszl").size() > 0) {
                    introduction = json.getJSONObject("data").getJSONArray("gszl").getJSONObject(0).getString("COMPPROFILE");
                } else {
                    introduction = "暂无数据";
                }

            }
        }
        /**
         * 105.UCL&ut=fa5fd1943c7b386f172d6893dbfba10b&wbp2u=%7C0%7C0%7C0%7Cweb&_=时间戳
         */
        long now = System.currentTimeMillis();
        JSONObject buyjson = null;
        String buyresult = null;
        try {
            String buyurl = PropertiesUtil.getProperty("us.stock.buy.url") + stockVO.getType() + "." + stock.getStockCode() + "&ut=fa5fd1943c7b386f172d6893dbfba10b&wbp2u=%7C0%7C0%7C0%7Cweb&_=" + now;
            buyresult = HttpClientRequest.doGet(buyurl);
            buyjson = JSONObject.parseObject(buyresult);
        } catch (Exception e) {
            log.error("获取分时交易数据失败", e);
            buyjson.put("data", "暂无数据");
        }


        stockVO.setDepositAmt(depositAmt);
        stockVO.setId(stock.getId().intValue());
        stockVO.setCode(stock.getStockCode());
        stockVO.setSpell(stock.getStockSpell());
        stockVO.setGid(stock.getStockGid());
        Map map = Maps.newHashMap();
        map.put("timedata", buyjson);
        map.put("introduction", introduction);
        map.put("stock", stockVO);
        return ServerResponse.createBySuccess(map);
    }


    public ServerResponse getMinK(String code, Integer time, Integer ma, Integer size) {
        if (StringUtils.isBlank(code) || time == null || ma == null || size == null)
            return ServerResponse.createByErrorMsg("");
        Stock stock = this.stockMapper.findStockByCode(code);
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        return StockApi.getStockMinK(stock, time.intValue(), ma.intValue(), size.intValue());
    }

    public ServerResponse getMinK_Echarts(String code, Integer time, Integer ma, Integer size) {
        if (StringUtils.isBlank(code) || time == null || ma == null || size == null)
            return ServerResponse.createByErrorMsg("");
        Stock stock = this.stockMapper.findStockByCode(code);
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        ServerResponse<MinDataVO> serverResponse = StockApi.getStockMinK(stock, time.intValue(), ma.intValue(), size.intValue());
        MinDataVO minDataVO = (MinDataVO) serverResponse.getData();
        EchartsDataVO echartsDataVO = StockApi.assembleEchartsDataVO(minDataVO);
        return ServerResponse.createBySuccess(echartsDataVO);
    }

    /*期货分时-k线*/
    public ServerResponse getFuturesMinK_Echarts(String code, Integer time, Integer size) {
        if (StringUtils.isBlank(code) || time == null)
            return ServerResponse.createByErrorMsg("");
        StockFutures stock = this.stockFuturesMapper.selectFuturesByCode(code.split("_")[1]);
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        ServerResponse<MinDataVO> serverResponse = StockApi.getFuturesMinK(stock, time.intValue(), size.intValue());
        MinDataVO minDataVO = (MinDataVO) serverResponse.getData();
        EchartsDataVO echartsDataVO = StockApi.assembleEchartsDataVO(minDataVO);
        return ServerResponse.createBySuccess(echartsDataVO);
    }

    /*指数分时-k线*/
    public ServerResponse getIndexMinK_Echarts(String code, Integer time, Integer size) {
        if (StringUtils.isBlank(code) || time == null)
            return ServerResponse.createByErrorMsg("");
        StockIndex stock = this.stockIndexMapper.selectIndexByCode(code.replace("sh", "").replace("sz", ""));
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        ServerResponse<MinDataVO> serverResponse = StockApi.getIndexMinK(stock, time.intValue(), size.intValue());
        MinDataVO minDataVO = (MinDataVO) serverResponse.getData();
        EchartsDataVO echartsDataVO = StockApi.assembleEchartsDataVO(minDataVO);
        return ServerResponse.createBySuccess(echartsDataVO);
    }

    /*股票日线-K线*/
    public ServerResponse getDayK_Echarts(String code) {
        if (StringUtils.isBlank(code))
            return ServerResponse.createByErrorMsg("");
        Stock stock = this.stockMapper.findStockByCode(code);
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        ServerResponse<MinDataVO> serverResponse = QqStockApi.getGpStockMonthK(stock, "day");
        MinDataVO minDataVO = (MinDataVO) serverResponse.getData();
        EchartsDataVO echartsDataVO = StockApi.assembleEchartsDataVO(minDataVO);
        return ServerResponse.createBySuccess(echartsDataVO);
    }

    /*期货日线-K线*/
    public ServerResponse getFuturesDayK(String code) {
        if (StringUtils.isBlank(code))
            return ServerResponse.createByErrorMsg("");
        StockFutures stock = this.stockFuturesMapper.selectFuturesByCode(code);
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        ServerResponse<MinDataVO> serverResponse = QqStockApi.getQqStockDayK(stock);
        MinDataVO minDataVO = (MinDataVO) serverResponse.getData();
        EchartsDataVO echartsDataVO = StockApi.assembleEchartsDataVO(minDataVO);
        return ServerResponse.createBySuccess(echartsDataVO);
    }

    /*指数日线-K线*/
    public ServerResponse getIndexDayK(String code) {
        if (StringUtils.isBlank(code))
            return ServerResponse.createByErrorMsg("");
        StockIndex stock = this.stockIndexMapper.selectIndexByCode(code.replace("sh", "").replace("sz", ""));
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        ServerResponse<MinDataVO> serverResponse = QqStockApi.getQqIndexDayK(stock);
        MinDataVO minDataVO = (MinDataVO) serverResponse.getData();
        EchartsDataVO echartsDataVO = StockApi.assembleEchartsDataVO(minDataVO);
        return ServerResponse.createBySuccess(echartsDataVO);
    }

    /*股票日线-k线*/
    public ServerResponse getStockDayK(String code) {
        if (StringUtils.isBlank(code))
            return ServerResponse.createByErrorMsg("");
        Stock stock = this.stockMapper.findStockByCode(code);
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        ServerResponse<MinDataVO> serverResponse = QqStockApi.getGpStockMonthK(stock, "day");
        MinDataVO minDataVO = serverResponse.getData();
        EchartsDataVO echartsDataVO = StockApi.assembleEchartsDataVO(minDataVO);
        return ServerResponse.createBySuccess(echartsDataVO);
    }
    @Data
    class kData {
        long t;
        String c;
        String o;
        String h;
        String l;
        String v;
        String vo;
    }


        /*股票日线-K线*/
    @Override
    public Object getKData(String pid, String interval, String stockType) {
        EStockType eStockType = EStockType.getEStockTypeByCode(stockType);
        Object object = HttpUtil.get(eStockType.stockUrl + "kline?pid=" + pid + "&interval=" + interval + "&key=" + eStockType.stockKey);
        Gson gson = new Gson();
        List<kData> dataList = gson.fromJson(object.toString(), new TypeToken<List<kData>>(){}.getType());

        Stock stock = stockMapper.selectOne(new LambdaQueryWrapper<Stock>().eq(Stock::getStockCode, pid).eq(Stock::getStockType, stockType));
        BigDecimal nowPrice = iPriceServices.getNowPrice(stock.getStockCode());
        Map singleStock = getSingleStock(stock.getStockCode());
        StockVO stockVO = (StockVO)singleStock.get("stock");
        // 修改 List 中的最后一条数据
        kData lastData = dataList.get(dataList.size() - 1);
        lastData.setC(nowPrice.toString());
        lastData.setO(stockVO.getOpen_px());
        lastData.setH(stockVO.getToday_max());
        lastData.setL(stockVO.getToday_min());
        return gson.toJson(dataList);
    }

    @Override
    public ServerResponse getOptionStock(HttpServletRequest request) {
        User user = iUserService.getCurrentRefreshUser(request);
        if (user == null) {
            return ServerResponse.createByErrorMsg("Please log in");
        }
        return ServerResponse.createBySuccess();
    }

    public ServerResponse<Stock> findStockByName(String name) {
        return ServerResponse.createBySuccess(this.stockMapper.findStockByName(name));
    }

    public ServerResponse<Stock> findStockByCode(String code) {
        return ServerResponse.createBySuccess(this.stockMapper.findStockByCode(code));
    }

    public ServerResponse<Stock> findStockById(Integer stockId) {
        return ServerResponse.createBySuccess(this.stockMapper.selectByPrimaryKey(stockId));
    }

    public ServerResponse<PageInfo> listByAdmin(String stockGid,Integer showState, Integer lockState, String code, String name, String stockPlate, String stockType, int pageNum, int pageSize, HttpServletRequest request) {
        PageHelper.startPage(pageNum, pageSize);
        List<Stock> stockList = this.stockMapper.listByAdmin(stockGid,showState, lockState, code, name, stockPlate, stockType);
        List<StockAdminListVO> stockAdminListVOS = Lists.newArrayList();
        for (Stock stock : stockList) {
            StockAdminListVO stockAdminListVO = assembleStockAdminListVO(stock);
            stockAdminListVOS.add(stockAdminListVO);
        }
        PageInfo pageInfo = new PageInfo(stockList);
        pageInfo.setList(stockAdminListVOS);
        return ServerResponse.createBySuccess(pageInfo);
    }

    private StockAdminListVO assembleStockAdminListVO(Stock stock) {
        StockAdminListVO stockAdminListVO = new StockAdminListVO();
        stockAdminListVO.setId(stock.getId());
        stockAdminListVO.setStockName(stock.getStockName());
        stockAdminListVO.setStockCode(stock.getStockCode());
        stockAdminListVO.setStockSpell(stock.getStockSpell());
        stockAdminListVO.setStockType(stock.getStockType());
        stockAdminListVO.setStockGid(stock.getStockGid());
        stockAdminListVO.setStockPlate(stock.getStockPlate());
        stockAdminListVO.setIsLock(stock.getIsLock());
        stockAdminListVO.setIsShow(stock.getIsShow());
        stockAdminListVO.setAddTime(stock.getAddTime());
        stockAdminListVO.setDataBase(stock.getDataBase());
        StockListVO stockListVO;
        if ("hk".equals(stock.getStockType())) {
            String hkStock = RedisShardedPoolUtils.get(stock.getStockGid(), 1);
            stockListVO = StockApi.otherStockListVO(hkStock);
        } else if ("us".equals(stock.getStockType())) {
            String usStock = RedisShardedPoolUtils.get(stock.getStockGid(), 2);
            stockListVO = StockApi.otherStockListVO(usStock);
        } else {
            stockListVO = StockApi.getStockRealTime(stock);
        }

//      String stockOther = RedisShardedPoolUtils.get(stock.getStockName(), 8);
//      if (stock.getDataBase()!=0){
//
//         String date = getCurrentTimeMiaoZero();
//        String result = HttpClientRequest.doGet(PropertiesUtil.getProperty("changePrice.url")+"?cat_time="+date+"&stock_gid="+stock.getStockGid()+"&price="+stockListVO.getNowPrice());
//        JSONObject jsonObject = JSONObject.fromObject(result);
//        String nowPrice = jsonObject.getJSONObject("data").getString("new_price");
//        if (nowPrice!=null){
//          stockListVO.setNowPrice(nowPrice);
//        }else {
//          stockListVO.setNowPrice(stockListVO.getNowPrice());
//        }
//      }
        if (stockListVO != null) {
            stockAdminListVO.setNowPrice(stockListVO.getNowPrice());
            stockAdminListVO.setHcrate(stockListVO.getHcrate());
        }
        stockAdminListVO.setSpreadRate(stock.getSpreadRate());
        ServerResponse serverResponse = selectRateByDaysAndStockCode(stock.getStockCode(), 3);
        BigDecimal day3Rate = new BigDecimal("0");
        if (serverResponse.isSuccess())
            day3Rate = (BigDecimal) serverResponse.getData();
        stockAdminListVO.setDay3Rate(day3Rate);
        return stockAdminListVO;
    }

    public ServerResponse updateLock(Integer stockId) {
        Stock stock = this.stockMapper.selectByPrimaryKey(stockId);
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        if (stock.getIsLock().intValue() == 1) {
            stock.setIsLock(Integer.valueOf(0));
        } else {
            stock.setIsLock(Integer.valueOf(1));
        }
        int updateCount = this.stockMapper.updateByPrimaryKeySelective(stock);
        if (updateCount > 0)
            return ServerResponse.createBySuccessMsg("成功");
        return ServerResponse.createByErrorMsg("失败");
    }

    public ServerResponse updateShow(Integer stockId) {
        Stock stock = this.stockMapper.selectByPrimaryKey(stockId);
        if (stock == null)
            return ServerResponse.createByErrorMsg("");
        if (stock.getIsShow().intValue() == 0) {
            stock.setIsShow(Integer.valueOf(1));
        } else {
            stock.setIsShow(Integer.valueOf(0));
        }
        int updateCount = this.stockMapper.updateByPrimaryKeySelective(stock);
        if (updateCount > 0)
            return ServerResponse.createBySuccessMsg("成功");
        return ServerResponse.createByErrorMsg("失败");
    }

    public ServerResponse addStock(String stockName, String stockCode, String stockType, String stockPlate, Integer isLock, Integer isShow) {
        if (StringUtils.isBlank(stockName) || StringUtils.isBlank(stockCode) || StringUtils.isBlank(stockType) || isLock == null || isShow == null)
            return ServerResponse.createByErrorMsg("所填信息有误");
        Stock cstock = (Stock) findStockByCode(stockCode).getData();
        if (cstock != null)
            return ServerResponse.createByErrorMsg("已有该股票代码");
        Stock nstock = (Stock) findStockByName(stockName).getData();
        if (nstock != null)
            return ServerResponse.createByErrorMsg("已有该股票名称");
        Stock stock = new Stock();
        stock.setStockName(stockName);
        stock.setStockCode(stockCode);
        stock.setStockSpell(GetPyByChinese.converterToFirstSpell(stockName));
        stock.setStockType(stockType);
        stock.setStockGid(stockType + stockCode);
        stock.setIsLock(isLock);
        stock.setIsShow(isShow);
        stock.setAddTime(new Date());
        int insertCount = this.stockMapper.insert(stock);
        if (insertCount > 0)
            return ServerResponse.createBySuccessMsg("添加成功");
        return ServerResponse.createByErrorMsg("添加失败");
    }

    public int CountStockNum() {
        return this.stockMapper.CountStockNum();
    }

    public int CountShowNum(Integer showState) {
        return this.stockMapper.CountShowNum(showState);
    }

    public int CountUnLockNum(Integer lockState) {
        return this.stockMapper.CountUnLockNum(lockState);
    }

    public List findStockList() {
        return this.stockMapper.findStockList();
    }

    public ServerResponse selectRateByDaysAndStockCode(String stockCode, int days) {
        Stock stock = this.stockMapper.findStockByCode(stockCode);
        if (stock == null)
            return ServerResponse.createByErrorMsg("没有该股票");
        BigDecimal daysRate = this.iStockMarketsDayService.selectRateByDaysAndStockCode(stock.getId(), days);
        return ServerResponse.createBySuccess(daysRate);
    }

    public ServerResponse updateStock(Stock model) {
        if (StringUtils.isBlank(model.getId().toString()) || StringUtils.isBlank(model.getStockName()))
            return ServerResponse.createByErrorMsg("修改信息有误");
        Stock stock = this.stockMapper.selectByPrimaryKey(model.getId());
        if (stock == null)
            return ServerResponse.createByErrorMsg("股票不存在");
        stock.setStockName(model.getStockName());
        if (model.getSpreadRate() != null)
            stock.setSpreadRate(model.getSpreadRate());

        int updateCount = this.stockMapper.updateByPrimaryKeySelective(stock);
        if (updateCount > 0)
            return ServerResponse.createBySuccessMsg("修改成功");
        return ServerResponse.createByErrorMsg("修改失败");
    }

    public ServerResponse deleteByPrimaryKey(Integer id) {
        int updateCount = this.stockMapper.deleteByPrimaryKey(id);
        if (updateCount > 0) {
            return ServerResponse.createBySuccessMsg("操作成功");
        }
        return ServerResponse.createByErrorMsg("操作失败");
    }

    public ServerResponse stockDataBase() {
        //mybatisplus查询所有database 不是0的
        List<Stock> stockList = this.stockMapper.selectList(new QueryWrapper<Stock>().ne("data_base", 0));
        return ServerResponse.createBySuccess(stockList);
    }

    /**
     * 涨停板
     *
     * @return
     */
    @Override
    public ServerResponse ztb(String password) {


        SiteSetting siteSetting = this.iSiteSettingService.getSiteSetting();
        if (siteSetting == null) {
            log.error("出错，网站设置表不存在");
            return ServerResponse.createByErrorMsg("失败，系统设置错误");
        }
        //判断密码
        if (StringUtils.isBlank(password) || !siteSetting.getVipPassword().equals(password)) {
            return ServerResponse.createByErrorMsg("获取失败，密码错误");
        }

        String day = getWeekDay();
        String url = PropertiesUtil.getProperty("ztb.url");
        //当前时间戳
//    log.info("当前时间戳：{}",day);
        //day去掉-
        String day1 = day.replace("-", "");
        long time = System.currentTimeMillis();
        if (url != null) {
            url = url.replace("20221202", day1) + time;
        }
        log.info("涨停板接口：{}", url);
        String res = HttpClientRequest.doGet(url);

        JSONObject json = JSONObject.parseObject(res);
        JSONArray pool = null;
        if (json.getJSONObject("data") != null) {
            pool = json.getJSONObject("data").getJSONArray("pool");
        }
        return ServerResponse.createBySuccess(pool);
    }

    @Override
    public ServerResponse getVipByCode(String code) {
        String day = getWeekDay();
        String url = PropertiesUtil.getProperty("ztb.url");
        String day1 = day.replace("-", "");
        long time = System.currentTimeMillis();
        url = url.replace("20221202", day1) + time;
//    log.info("涨停板接口：{}",url);
        String res = HttpClientRequest.doGet(url);
        JSONObject json = JSONObject.parseObject(res);
        JSONArray pool = null;
        if (json.getJSONObject("data") != null) {
            pool = json.getJSONObject("data").getJSONArray("pool");
            if (pool != null) {
                for (int i = 0; i < pool.size(); i++) {
                    JSONObject jsonObject = pool.getJSONObject(i);
                    String c = jsonObject.getString("c");
                    if (c.equals(code)) {
                        pool.removeAll(pool);
                        pool.add(jsonObject);
                        return ServerResponse.createBySuccess(pool);
                    }
                }
            }
        }
        return ServerResponse.createBySuccess(pool);
    }

    @Override
    public ServerResponse getIndicesIndexListAndNews(Integer pageSize) {
        try {
            //新闻列表
            List<SiteNews> newsList = this.siteNewsMapper.getTopNewsList(pageSize);

            /*String usCodeList = PropertiesUtil.getProperty("us_home_indices_code");
            String hkCodeList = PropertiesUtil.getProperty("hk_home_indices_code");
            String inCodeList = PropertiesUtil.getProperty("in_home_indices_code");
            String twCodeList = PropertiesUtil.getProperty("tw_home_indices_code");*/

            List<StockConfig> stockConfigList = stockConfigMapper.selectList
                    (new LambdaQueryWrapper<StockConfig>()
                            .like(StockConfig::getCKey, EConfigKey.INDICES.getCode()));

            List<DataStockBean> usDataStockBeans = Lists.newArrayList();
            List<DataStockBean> jpDataStockBeans = Lists.newArrayList();
            // 创建Gson对象（全局复用，避免重复创建）
            Gson gson = new Gson();

            // 统一处理各地区股票数据
            processStockData(stockConfigList, EStockType.US.getCode(), usDataStockBeans, gson);
            processStockData(stockConfigList, EStockType.JP.getCode(), jpDataStockBeans, gson);

            // 组装返回结果
            Map<String, Object> resultMap = new HashMap<>();
            resultMap.put("newsList", newsList);                //新闻列表
            resultMap.put("usDataStockBeans", usDataStockBeans);//美国指数
            resultMap.put("jpDataStockBeans", jpDataStockBeans);//日本指数
            return ServerResponse.createBySuccess(resultMap);
        } catch (Exception e){
            e.printStackTrace();
        }
        return ServerResponse.createByError();
    }

    // 提取的通用处理方法
    private void processStockData(List<StockConfig> stockConfigList, String stockType,
                                  List<DataStockBean> targetList, Gson gson) throws Exception {
        String key = EConfigKey.getEConfigKeyByStockType(stockType).getCode();
        StockConfig stockConfig = stockConfigList.stream()
                .filter(x -> x.getCKey().equals(key)).findFirst().orElse(null);
        if (stockConfig == null) {
            return;
        }
        String stockCodes = stockConfig.getCValue();
        String[] stockCodeList = stockCodes.split(",");
        //实时获取数据
        //String result = RedisKeyUtil.doPost(stockCodes, stockType);
        EStockType eStockType = EStockType.getEStockTypeByCode(stockType);
        String result = HttpRequest.doGrabGet(eStockType.stockUrl + "indices?key=" + eStockType.getStockKey() + "&country_id=" + eStockType.getContryId());
        // 把JSON数据解析为List<DataStockBean>
        Type listType = new TypeToken<List<DataStockBean>>(){}.getType();
        List<DataStockBean> list = new Gson().fromJson(result, listType);

        for (String stockCode : stockCodeList) {  // 增强for循环简化代码
            // 获取基础股票数据
            //DataStockBean cacheBaseStock = RedisKeyUtil.getCacheBaseStock(stockType, stockCode);
            DataStockBean cacheBaseStock = list.stream()
                    .filter(x -> stockCode.equals(x.getId()))
                    .findFirst().orElse(null);
            if (cacheBaseStock == null) {  // 增加空指针防护（可选，根据实际业务）
                continue;
            }

            // 获取K线数据（缓存优先）
            Object kData = RedisKeyUtil.getCaCheStockKData(stockType, stockCode);
            if (kData == null) {
                // 缓存未命中时重新获取并缓存
                kData = getKData(stockCode, "D", stockType);
                RedisKeyUtil.setCaCheStockKData(stockType, stockCode, kData);
            }

            // 解析K线数据并设置到对象
            List<kData> dataList = gson.fromJson(kData.toString(), new TypeToken<List<kData>>(){}.getType());
            cacheBaseStock.setKData(dataList);
            cacheBaseStock.setStockType(stockType);

            // 添加到目标集合
            targetList.add(cacheBaseStock);
        }
    }

    @Override
    public ServerResponse getIndicesList(String stockType) {
        try {
            /*String codeList;
            if(stockType.equals(EStockType.US.getCode())) {
                codeList = PropertiesUtil.getProperty("us_home_indices_code");
            } else if(stockType.equals(EStockType.HK.getCode())) {
                codeList = PropertiesUtil.getProperty("hk_home_indices_code");
            } else if(stockType.equals(EStockType.IN.getCode())) {
                codeList = PropertiesUtil.getProperty("in_home_indices_code");
            } else if(stockType.equals(EStockType.TW.getCode())) {
                codeList = PropertiesUtil.getProperty("tw_home_indices_code");
            } else
                codeList = PropertiesUtil.getProperty("us_home_indices_code");*/

            String key = EConfigKey.getEConfigKeyByStockType(stockType).getCode();
            StockConfig stockConfig = stockConfigMapper.selectOne(new LambdaQueryWrapper<StockConfig>()
                            .eq(StockConfig::getCKey, key));
            if (stockConfig == null) {
                return ServerResponse.createByErrorMsg("stockConfig [" + key + "] is null");
            }
            List<String> stockCodeList = Arrays.asList(stockConfig.getCValue().split(","));

            Map<Integer, Object> resultMap = new HashMap<>();
            for (int i = 0; i < stockCodeList.size(); i++) {
                String stockCode = stockCodeList.get(i);
                DataStockBean cacheBaseStock = RedisKeyUtil.getCacheBaseStock(stockType, stockCode);
                Map<String, Object> stockInfo = new HashMap<>();
                stockInfo.put("pid", cacheBaseStock.getId());
                stockInfo.put("name", cacheBaseStock.getName());
                stockInfo.put("stockType", stockType);
                resultMap.put(i+1, stockInfo);
            }
            return ServerResponse.createBySuccess(resultMap);
        } catch (Exception e){
            e.printStackTrace();
        }
        return ServerResponse.createByError();
    }

    @Override
    public ServerResponse getIndicesAndKData(String pid, String stockType) {
        try {
            Stock stock = stockMapper.selectOne(new QueryWrapper<Stock>().eq("stock_code", pid));
            if (stock == null) {
                return ServerResponse.createByErrorMsg("无股票信息");
            }
            stockType = stock.getStockType();
            Map<String, Object> resultMap = new HashMap<>();

            //实时获取数据
            String s = RedisKeyUtil.doPost(pid, stockType);
            Map<String, Object> stringObjectMap = RedisKeyUtil.jsonToMap(s);
            resultMap.put("id", pid);
            resultMap.put("stockType", stockType);
            resultMap.put("name", stock.getStockName());
            resultMap.put("last", stringObjectMap.get("Last").toString());
            resultMap.put("chg", stringObjectMap.get("Chg").toString());
            resultMap.put("chgPct", stringObjectMap.get("ChgPct").toString());
            // 获取K线数据
            Object kData = getKData(pid, "D", stockType);
            Gson gson = new Gson();
            List<kData> dataList = gson.fromJson(kData.toString(), new TypeToken<List<kData>>(){}.getType());
            resultMap.put("kData", dataList);
            return ServerResponse.createBySuccess(resultMap);

            /*DataStockBean cacheBaseStock = RedisKeyUtil.getCacheBaseStock(stockType, pid);
            if (cacheBaseStock != null) {
                resultMap.put("id", cacheBaseStock.getId());
                resultMap.put("stockType", stockType);
                resultMap.put("name", cacheBaseStock.getName());
                resultMap.put("last", cacheBaseStock.getLast());
                resultMap.put("chg", cacheBaseStock.getChg());
                resultMap.put("chgPct", cacheBaseStock.getChgPct());
                resultMap.put("kData", cacheBaseStock.getChg());
                // 获取K线数据
                Object kData = RedisKeyUtil.getCaCheStockKData(stockType, pid);
                if (kData == null) {
                    //重新获取并缓存redis
                    kData = getKData(pid, "D", stockType);
                    RedisKeyUtil.setCaCheStockKData(stockType, pid, kData);
                }
                Gson gson = new Gson();
                List<kData> dataList = gson.fromJson(kData.toString(), new TypeToken<List<kData>>(){}.getType());
                resultMap.put("kData", dataList);
                return ServerResponse.createBySuccess(resultMap);
            }*/
        } catch (Exception e){
            e.printStackTrace();
        }
        return ServerResponse.createByError();
    }

    /**
     * 搜索
     * @param pageNum
     * @param pageSize
     * @param keyWords
     * @return
     */
    @Override
    public ServerResponse getStocksByKeyWords(int pageNum, int pageSize, String keyWords) {
        try {
            PageHelper.startPage(pageNum, pageSize);
            List<StockVOQuery> stocks = stockMapper.findStocksQuery(keyWords);
            // 获取分页信息
            PageInfo<StockVOQuery> pageInfo = new PageInfo<>(stocks);
            if (!pageInfo.getList().isEmpty()) {
                pageInfo.getList().forEach(stock -> {
                    stock.setNowPrice(iPriceServices.getNowPrice(stock.getStockCode()));
                });
            }
            return ServerResponse.createBySuccess(pageInfo);
        } catch (Exception e) {
            log.error("StockAiService getStocksByKeyWords error", e);
        }
        return ServerResponse.createByError();
    }

    @Override
    public ServerResponse getPremarketStock() {
        try {
            List<StockSetting> stockSettings = stockSettingMapper.selectList(new QueryWrapper<>());
            List<PremarketStockVO> resultList = new ArrayList<>();
            
            Date now = new Date();
            
            for (StockSetting setting : stockSettings) {
                String startTime = setting.getStartTime();
                String endTime = setting.getEndTime();
                
                // 判断当前时间是否在交易时间内（startTime和endTime是完整的日期时间格式）
                if (isTimeInRange(now, startTime, endTime)) {
                    Stock stock = stockMapper.selectOne(new QueryWrapper<Stock>().eq("stock_code", setting.getStockCode()));
                    if (stock == null) {
                        continue; // 股票不存在，跳过
                    }
                    
                    // 先获取真实价格（从Redis获取，不经过StockSetting计算）
                    String s = RedisKeyUtil.doPost(stock.getStockCode(), stock.getStockType());
                    if (s == null) {
                        continue; // 无法获取真实价格，跳过
                    }
                    
                    Map<String, Object> stringObjectMap = RedisKeyUtil.jsonToMap(s);
                    BigDecimal realPrice = new BigDecimal(stringObjectMap.get("Last").toString());
                    
                    // 计算盘前价格
                    BigDecimal premarketPrice;
                    if ("0".equals(setting.getType())) {
                        // type=0: 直接指定价格
                        premarketPrice = new BigDecimal(setting.getPrice());
                    } else {
                        // type=1: 百分比调价格，基于真实价格计算
                        premarketPrice = realPrice.multiply(new BigDecimal(setting.getPrice()));
                    }
                    
                    // 计算涨跌幅 = (盘前价格 - 真实价格) / 真实价格
                    BigDecimal hcrate = BigDecimal.ZERO;
                    if (realPrice.compareTo(BigDecimal.ZERO) > 0) {
                        hcrate = premarketPrice.subtract(realPrice)
                                .divide(realPrice, 4, RoundingMode.HALF_UP);
                    }
                    
                    // 格式化涨跌幅为带百分号的字符串
                    String hcrateP = hcrate.multiply(new BigDecimal("100"))
                            .setScale(2, RoundingMode.HALF_UP) + "%";
                    
                    PremarketStockVO vo = new PremarketStockVO();
                    vo.setCode(setting.getStockCode());
                    vo.setPrice(premarketPrice);
                    vo.setHcrate(hcrate);
                    vo.setHcrateP(hcrateP);
                    resultList.add(vo);
                }
            }
            
            return ServerResponse.createBySuccess(resultList);
        } catch (Exception e) {
            log.error("getPremarketStock error", e);
            return ServerResponse.createByErrorMsg("查询盘前交易数据失败");
        }
    }

    /**
     * 判断当前时间是否在指定时间范围内
     * @param now 当前时间
     * @param startTime 开始时间，完整的日期时间格式
     * @param endTime 结束时间，完整的日期时间格式
     * @return
     */
    private boolean isTimeInRange(Date now, String startTime, String endTime) {
        try {
            DateTime start = DateUtil.parseDateTime(startTime);
            DateTime end = DateUtil.parseDateTime(endTime);
            
            // 判断当前时间是否在开始时间和结束时间之间
            return now.after(start) && now.before(end);
        } catch (Exception e) {
            log.error("isTimeInRange error", e);
            return false;
        }
    }
}