blame | history | patch | commit | commitdiff | ignore whitespace
zyy
2025-07-21 f25b39e0d5fcae415a8824fc03d42fe681e96bf8 
 src/main/java/com/nq/service/impl/StockServiceImpl.java


@@ -1,42 +1,37 @@


package com.nq.service.impl;




import cn.hutool.http.HttpUtil;


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.config.StockPoll;


import com.nq.dao.*;


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.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.utils.translate.GoogleTranslateUtil;


import com.nq.vo.stock.*;


import com.nq.vo.stock.k.MinDataVO;


import com.nq.vo.stock.k.echarts.EchartsDataVO;




import java.io.BufferedReader;


import java.io.IOException;


import java.io.InputStreamReader;


import java.math.BigDecimal;


import java.net.HttpURLConnection;


import java.net.URL;


import java.text.SimpleDateFormat;


import java.util.*;


import javax.annotation.Resource;


import javax.servlet.http.HttpServletRequest;


import javax.servlet.http.HttpServletResponse;




import net.sf.json.JSONArray;


import net.sf.json.JSONObject;


import org.apache.commons.lang3.StringUtils;


import org.slf4j.Logger;


import org.slf4j.LoggerFactory;


@@ -52,14 +47,8 @@


    @Autowired


    StockMapper stockMapper;




    @Resource


    RealTimeMapper realTimeMapper;




    @Autowired


    IStockMarketsDayService iStockMarketsDayService;




    @Autowired


    StockPoll stockPoll;




    @Resource


    StockFuturesMapper stockFuturesMapper;


@@ -71,16 +60,17 @@


    IUserService iUserService;




    @Autowired


    IStockOptionService iStockOptionService;


    @Autowired


    ISiteSettingService iSiteSettingService;






    @Autowired


    InStockMapper inStockMapper;




    @Resource


    StockDzMapper stockDzMapper;




    @Autowired


    IPriceServices iPriceServices;




    @Autowired


    SiteNewsMapper siteNewsMapper;






    public ServerResponse getMarket() {


        String market_url = PropertiesUtil.getProperty("sina.market.url");


@@ -118,7 +108,7 @@


        List<Stock> stockList = new ArrayList<>();


        if (stockType.equals("99")) {


            PageHelper.startPage(pageNum, pageSize);


            stockList.addAll(stockMapper.findZtStockListByKeyWords(keyWords, stockPlate, "IN", Integer.valueOf(0)));


            stockList.addAll(stockMapper.findZtStockListByKeyWords(keyWords, stockPlate, "MEX", Integer.valueOf(0)));


        } else if (stockType.equals("100")) {


            User user = iUserService.getCurrentRefreshUser(request);


            if (user == null) {


@@ -154,112 +144,88 @@




    @Override


    public ServerResponse getStockByType(int pageNum, int pageSize, String orderBy, String keyWords, String stockType, HttpServletRequest request) {


        List<Stock> stockList = new ArrayList<>();


        PageHelper.startPage(pageNum, pageSize);


        stockList.addAll(stockMapper.findStockByType(orderBy,stockType,keyWords));


        List<Stock> stockList = stockMapper.findStockByType(orderBy, stockType, keyWords);


        // 获取分页信息


        PageInfo<Stock> pageInfo = new PageInfo<>(stockList);




        List<StockListVO> stockListVOS = Lists.newArrayList();


        if (stockList.size() > 0){


        if (stockList.size() > 0) {


            stockListVOS.addAll(Objects.requireNonNull(StockApi.getStockReailTimes(stockList)));


        }


        PageInfo pageInfo = new PageInfo(stockList);


        pageInfo.setList(stockListVOS);


        return ServerResponse.createBySuccess(pageInfo);




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


    }




    public ServerResponse getDateline(HttpServletResponse response, String code) {


        if (StringUtils.isBlank(code))


            return ServerResponse.createByErrorMsg("");


        Stock stock = this.stockMapper.findStockByCode(code);


        if (stock == null)


            return ServerResponse.createByErrorMsg("");


        response.setHeader("Access-Control-Allow-Origin", "*");


        Date time = new Date();


        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");


        String end = sdf.format(time);


        Calendar c = Calendar.getInstance();


        c.setTime(new Date());


        c.add(2, -3);


        Date m = c.getTime();


        String mon = sdf.format(m);


        String methodUrl = "http://q.stock.sohu.com/hisHq?code=cn_" + code + "+&start=" + mon + "&end=" + end + "&stat=1&order=D";


        HttpURLConnection connection = null;


        BufferedReader reader = null;


        String line = null;


        EchartsDataVO echartsDataVO = new EchartsDataVO();


        try {


            URL url = new URL(methodUrl);


            connection = (HttpURLConnection) url.openConnection();


            connection.setRequestMethod("GET");


            connection.connect();


            if (connection.getResponseCode() == 200) {


                reader = new BufferedReader(new InputStreamReader(connection.getInputStream(), "gbk"));


                StringBuilder result = new StringBuilder();


                while ((line = reader.readLine()) != null)


                    result.append(line).append(System.getProperty("line.separator"));


                JSONArray jsonArray = JSONArray.fromObject(result.toString());


                JSONObject json = jsonArray.getJSONObject(0);


                JSONArray jsonArray1 = JSONArray.fromObject(json.get("hq"));


                Collections.reverse((List<?>) jsonArray1);


                double[][] values = (double[][]) null;


                Object[][] volumes = (Object[][]) null;


                String[] date = null;


                values = new double[jsonArray1.size()][5];


                volumes = new Object[jsonArray1.size()][3];


                date = new String[jsonArray1.size()];


                for (int i = 0; i < jsonArray1.size(); i++) {


                    JSONArray js = JSONArray.fromObject(jsonArray1.get(i));


                    date[i] = js.get(0).toString();


                    values[i][0] = Double.valueOf(js.get(1).toString()).doubleValue();


                    values[i][1] = Double.valueOf(js.get(2).toString()).doubleValue();


                    values[i][2] = Double.valueOf(js.get(5).toString()).doubleValue();


                    values[i][3] = Double.valueOf(js.get(6).toString()).doubleValue();


                    values[i][4] = Double.valueOf(js.get(7).toString()).doubleValue();


                    volumes[i][0] = Integer.valueOf(i);


                    volumes[i][1] = Double.valueOf(js.get(7).toString());


                    volumes[i][2] = Integer.valueOf((Double.valueOf(js.get(3).toString()).doubleValue() > 0.0D) ? 1 : -1);


                }


                echartsDataVO.setDate(date);


                echartsDataVO.setValues(values);


                echartsDataVO.setVolumes(volumes);


                echartsDataVO.setStockCode(stock.getStockCode());


                echartsDataVO.setStockName(stock.getStockName());


                ServerResponse.createBySuccess(echartsDataVO);


            }


        } catch (IOException e) {


            e.printStackTrace();


        } finally {


            try {


                reader.close();


            } catch (IOException e) {


                e.printStackTrace();


            }


            connection.disconnect();


        }


        return ServerResponse.createBySuccess(echartsDataVO);


    @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;


        String result = null;


        com.alibaba.fastjson2.JSONObject json = null;




        String gid = stock.getStockGid();




        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;


    }






@@ -437,29 +403,37 @@


        EchartsDataVO echartsDataVO = StockApi.assembleEchartsDataVO(minDataVO);


        return ServerResponse.createBySuccess(echartsDataVO);


    }


    @lombok.Data


    class kData {


        long t;


        String c;


        String o;


        String h;


        String l;


        String v;


        String vo;


    }




    /*股票日线-K线*/




        /*股票日线-K线*/


    @Override


    public Object getKData(String pid, String interval, String stockType) {


        EStockType eStockType = EStockType.getEStockTypeByCode(stockType);


        String string;


        if(eStockType == EStockType.SZHB){


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




            if(interval.equals("D")){


                interval = "1day";


            }else if(interval.equals("W")) {


                interval = "1week";


            }else if(interval.equals("M")){


                interval = "1mon";


            }else{


                interval =interval+ "min";


            }


            string   = HttpUtil.get(eStockType.stockUrl + "market/history/kline?period="+interval+"&size=600&symbol="+pid);




        }else{


            string   = HttpUtil.get(eStockType.stockUrl + "kline?pid=" + pid + "&interval=" + interval + "&key=" + eStockType.stockKey);


        }


        return string;


        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


@@ -468,41 +442,7 @@


        if (user == null) {


            return ServerResponse.createByErrorMsg("Please log in");


        }




        return ServerResponse.createBySuccess();


//        List<Stock> stockList = stockMapper.findOptions(user.getId() + "");


////    List<Stock> stockList = stockMapper.findOptions("485");


//        List<StockListVO> stockListVOS = Lists.newArrayList();


//        if (stockList.size() > 0)


//            for (Stock stock : stockList) {


//                StockListVO stockListVO = new StockListVO();


//                QueryWrapper<InStockBean> queryWrapper = new QueryWrapper<>();


//                queryWrapper.eq("id", stock.getStockCode());


//                InStockBean inStockBean = inStockMapper.selectOne(queryWrapper);


//                if (inStockBean == null) {


//                    continue;


//                }


//                stockListVO.setNowPrice(inStockBean.getLast());


//                stockListVO.setToday_max(inStockBean.getHigh());


//                stockListVO.setToday_min(inStockBean.getLow());


//                stockListVO.setHcrate(BigDecimal.valueOf(Double.parseDouble(inStockBean.getChgPct())));


//                stockListVO.setBusiness_amount(inStockBean.getVolume());


//                stockListVO.setBusiness_balance(inStockBean.getAvgVolume());


//                stockListVO.setPreclose_px(inStockBean.getPrevClose());


//                stockListVO.setOpen_px(inStockBean.getOpen());


//                stockListVO.setName(stock.getStockName());


//                stockListVO.setCode(stock.getStockCode());


//                stockListVO.setSpell(stock.getStockSpell());


//                stockListVO.setGid(stock.getStockGid());


//                BigDecimal day3Rate = (BigDecimal) selectRateByDaysAndStockCode(stock.getStockCode(), 3).getData();


//                stockListVO.setDay3Rate(day3Rate);


//                stockListVO.setStock_plate(stock.getStockPlate());


//                stockListVO.setStock_type(stock.getStockType());


//                stockListVOS.add(stockListVO);


//            }


//        PageInfo pageInfo = new PageInfo(stockList);


//        pageInfo.setList(stockListVOS);




    }




    public ServerResponse<Stock> findStockByName(String name) {


@@ -517,9 +457,9 @@


        return ServerResponse.createBySuccess(this.stockMapper.selectByPrimaryKey(stockId));


    }




    public ServerResponse<PageInfo> listByAdmin(Integer showState, Integer lockState, String code, String name, String stockPlate, String stockType, int pageNum, int pageSize, HttpServletRequest request) {


    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(showState, lockState, code, name, stockPlate, stockType);


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


@@ -754,4 +694,151 @@


        }


        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 mxCodeList = PropertiesUtil.getProperty("mx_home_indices_code");


            List<String> usStockCodeList = Arrays.asList(usCodeList.split(","));


            List<String> mxStockCodeList = Arrays.asList(mxCodeList.split(","));


            List<DataStockBean> usDataStockBeans = Lists.newArrayList();


            List<DataStockBean> mxDataStockBeans = Lists.newArrayList();


            for (int i = 0; i < usStockCodeList.size(); i++) {


                String stockCode = usStockCodeList.get(i);


                String stockType = EStockType.US.getCode();


                DataStockBean cacheBaseStock = RedisKeyUtil.getCacheBaseStock(stockType, stockCode);


                // 获取K线数据


                Object kData = RedisKeyUtil.getCaCheStockKData(stockType, stockCode);


                if (kData == null) {


                    //重新获取并缓存redis


                    kData = getKData(stockCode, "D", stockType);


                    RedisKeyUtil.setCaCheStockKData(stockType, stockCode, kData);


                }


                Gson gson = new Gson();


                List<kData> dataList = gson.fromJson(kData.toString(), new TypeToken<List<kData>>(){}.getType());


                cacheBaseStock.setKData(dataList);


                cacheBaseStock.setStockType(stockType);


                usDataStockBeans.add(cacheBaseStock);


            }


            for (int i = 0; i < mxStockCodeList.size(); i++) {


                String stockCode = mxStockCodeList.get(i);


                String stockType = EStockType.MX.getCode();


                DataStockBean cacheBaseStock = RedisKeyUtil.getCacheBaseStock(stockType, stockCode);


                // 获取K线数据


                Object kData = RedisKeyUtil.getCaCheStockKData(stockType, stockCode);


                if (kData == null) {


                    //重新获取并缓存redis


                    kData = getKData(stockCode, "D", stockType);


                    RedisKeyUtil.setCaCheStockKData(stockType, stockCode, kData);


                }


                Gson gson = new Gson();


                List<kData> dataList = gson.fromJson(kData.toString(), new TypeToken<List<kData>>(){}.getType());


                cacheBaseStock.setKData(dataList);


                cacheBaseStock.setStockType(stockType);


                mxDataStockBeans.add(cacheBaseStock);


            }


            Map<String, Object> resultMap = new HashMap<>();


            resultMap.put("newsList", newsList);                //新闻列表


            resultMap.put("usDataStockBeans", usDataStockBeans);//美国指数


            resultMap.put("mxDataStockBeans", mxDataStockBeans);//墨西哥指数


            return ServerResponse.createBySuccess(resultMap);


        } catch (Exception e){


            e.printStackTrace();


        }


        return ServerResponse.createByError();


    }




    @Override


    public ServerResponse getIndicesList(String stockType) {


        try {


            String codeList;


            if(stockType.equals(EStockType.MX.getCode()) || stockType.equals("MX")) {


                codeList = PropertiesUtil.getProperty("mx_home_indices_code");


            } else {


                codeList = PropertiesUtil.getProperty("us_home_indices_code");


            }


            List<String> stockCodeList = Arrays.asList(codeList.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<>();


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


    }


}