1
zj
2025-11-25 fec33ad92aa4a92aaa657a6f17339bfd98c5969d
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
package com.nq.service.impl;
 
import cn.hutool.core.collection.CollectionUtil;
import cn.hutool.core.date.DatePattern;
import cn.hutool.core.date.DateUtil;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.github.pagehelper.PageHelper;
import com.google.common.collect.Lists;
import com.nq.common.ServerResponse;
import com.nq.dao.StockDzMapper;
import com.nq.dao.StockMapper;
import com.nq.dao.UserPositionMapper;
import com.nq.pojo.Stock;
import com.nq.pojo.StockDz;
import com.nq.pojo.UserPosition;
import com.nq.pojo.reponse.RPageInfo;
import com.nq.service.StockDzService;
import com.nq.utils.stock.sina.StockApi;
import com.nq.utils.timeutil.DateTimeUtil;
import com.nq.vo.stock.StockDzVo;
import com.nq.vo.stock.StockListVO;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.bind.annotation.RequestParam;
 
import javax.servlet.http.HttpServletRequest;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import java.util.Objects;
import java.util.concurrent.CompletableFuture;
 
/**
* @author Administrator
* @description 针对表【stock_dz】的数据库操作Service实现
* @createDate 2022-12-03 17:09:01
*/
@Service
@Slf4j
public class StockDzServiceImpl extends ServiceImpl<StockDzMapper, StockDz>
    implements StockDzService{
    @Autowired
    private StockDzMapper stockDzMapper;
    @Autowired
    private SiteSettingServiceImpl siteSettingService;
    @Autowired
    private StockMapper stockMapper;
    @Autowired
    private UserPositionMapper userPositionMapper;
 
    @Override
    public ServerResponse getDzList(int pageNum, int pageSize, String orderBy, String keyWords,  HttpServletRequest request) {
        PageHelper.startPage(pageNum, pageSize);
        if (keyWords == null || keyWords.trim().isEmpty()) {
            // 如果 keyWords 为空,则直接返回空分页结果
            return ServerResponse.createBySuccess(new RPageInfo());
        }
        String formatDate = DateUtil.format(new Date(), DatePattern.NORM_DATETIME_PATTERN);
        List<StockDz> stockTypeDz = stockMapper.findStockTypeDz(orderBy, keyWords,formatDate);
        RPageInfo pageInfo = new RPageInfo();
        pageInfo.setList(stockTypeDz);
        return ServerResponse.createBySuccess(pageInfo);
    }
 
    @Override
    public ServerResponse addByAdmin(String stockCode, String stockNum, String password, String startTime, String endTime, String discount,Integer period,String nowPrice,Integer switchType) {
        if (stockCode == null || stockCode.equals("")||stockNum == null || stockNum.equals("")|| startTime == null || startTime.equals("")||endTime == null || endTime.equals("") || period == null || nowPrice == null){
            return ServerResponse.createByErrorMsg("参数不能为空");
        }
 
        Long count = stockDzMapper.selectCount(new LambdaQueryWrapper<StockDz>()
                .eq(StockDz::getStockCode,stockCode));
        if(count > 0){
            return ServerResponse.createByErrorMsg("股票代码已存在");
        }
 
        QueryWrapper queryWrapper = new QueryWrapper();
        queryWrapper.eq("stock_code",stockCode);
 
        Stock stock = stockMapper.selectOne(queryWrapper);
        if (stock == null){
            return ServerResponse.createByErrorMsg("股票代码不存在");
        }
 
        StockDz stockDz = new StockDz();
        stockDz.setStockName(stock.getStockName());
        stockDz.setStockCode(stock.getStockCode());
        stockDz.setStockType(stock.getStockType());
        stockDz.setStockGid(stock.getStockGid());
        stockDz.setStockSpell(stock.getStockSpell());
        stockDz.setIsLock(stock.getIsLock());
        stockDz.setIsShow(1);
        stockDz.setAddTime(new Date());
        stockDz.setSpreadRate(stock.getSpreadRate());
        stockDz.setIncreaseRatio(BigDecimal.ZERO);
        stockDz.setStockNum(Integer.valueOf(stockNum));
        stockDz.setPassword(password);
        stockDz.setStartTime(DateTimeUtil.strToDate(startTime));
        stockDz.setEndTime(DateTimeUtil.strToDate(endTime));
//        stockDz.setDiscount(new BigDecimal(discount));
        stockDz.setPeriod(period);
        stockDz.setSwitchType(switchType);
        stockDz.setNowPrice(new BigDecimal(nowPrice));
        int res = stockDzMapper.insert(stockDz);
        if (res > 0) {
            return ServerResponse.createBySuccessMsg("添加成功");
        }
        return ServerResponse.createByErrorMsg("添加失败");
    }
 
    @Override
    public ServerResponse getDzListByAdmin(String Keywords) {
        List<StockDz> list = null;
//        log.info("Keywords:{}",Keywords);
        if (Keywords != null && !"".equals(Keywords)){
            list = stockDzMapper.selectList(new QueryWrapper<StockDz>().like("stock_name", Keywords).or().like("stock_code", Keywords).or().like("stock_type", Keywords));
        }else {
            list = stockDzMapper.selectList(new QueryWrapper<StockDz>().orderByDesc("id"));
        }
        log.info("list:{}",list);
        return ServerResponse.createBySuccess(list);
    }
 
    @Override
    public ServerResponse updByAdmin(StockDz model) {
        Long count = stockDzMapper.selectCount(new LambdaQueryWrapper<StockDz>()
                .eq(StockDz::getStockCode, model.getStockCode())
                .ne(StockDz::getId,model.getId()));
        if(count > 0){
            return ServerResponse.createByErrorMsg("股票代码已存在");
        }
        return stockDzMapper.updateById(model) > 0 ? ServerResponse.createBySuccess("修改成功") : ServerResponse.createByErrorMsg("修改失败");
    }
 
    @Override
    public ServerResponse deleteByAdmin(String id) {
        List<UserPosition> userPositions = userPositionMapper.selectList(new LambdaQueryWrapper<>(UserPosition.class).eq(UserPosition::getDzId, id).isNull(UserPosition::getSellOrderId));
        if(CollectionUtil.isNotEmpty(userPositions)){
            return ServerResponse.createByErrorMsg("删除失败,当前大宗还有用户持有仓位");
        }
        int res =  stockDzMapper.deleteById(id);
        if (res > 0) {
            return ServerResponse.createBySuccess("删除成功");
        }
        return ServerResponse.createByErrorMsg("删除失败");
    }
}