package com.nq.service.impl;
|
|
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.github.pagehelper.PageHelper;
|
import com.github.pagehelper.PageInfo;
|
import com.google.common.collect.Lists;
|
import com.nq.common.ServerResponse;
|
import com.nq.pojo.Stock;
|
import com.nq.pojo.StockSubscribe;
|
import com.nq.service.IStockSubscribeService;
|
import com.nq.dao.StockSubscribeMapper;
|
import com.nq.utils.DateTimeUtil;
|
import com.nq.utils.stock.sina.SinaStockApi;
|
import com.nq.vo.stock.StockAdminListVO;
|
import lombok.extern.slf4j.Slf4j;
|
import org.junit.Test;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
|
import javax.servlet.http.HttpServletRequest;
|
import java.util.ArrayList;
|
import java.util.Date;
|
import java.util.List;
|
|
/**
|
* @author 11527
|
* @description 针对表【stock_subscribe(新股)】的数据库操作Service实现
|
* @createDate 2022-10-24 23:27:27
|
*/
|
@Service
|
@Slf4j
|
public class StockSubscribeServiceImpl extends ServiceImpl<StockSubscribeMapper, StockSubscribe>
|
implements IStockSubscribeService {
|
@Autowired
|
StockSubscribeMapper stockSubscribeMapper;
|
|
/**
|
* @Description: 用户新股列表
|
* @Param:
|
* @return:
|
* @Author: tf
|
* @Date: 2022/10/25
|
*/
|
@Override
|
public ServerResponse<PageInfo> list( int pageNum, int pageSize,String name,String code,Integer zt,Integer isLock,Integer type, HttpServletRequest request) {
|
PageHelper.startPage(pageNum, pageSize);
|
//name和code模糊查询
|
QueryWrapper<StockSubscribe> queryWrapper = new QueryWrapper();
|
if (name != null && !name.equals("")) {
|
queryWrapper.like("name", name);
|
}
|
if (code != null && !code.equals("")) {
|
queryWrapper.like("code", code);
|
}
|
if (zt != null && !zt.equals("")) {
|
queryWrapper.eq("zt", zt);
|
}
|
if(isLock!=null && !isLock.equals("")){
|
queryWrapper.eq("is_lock",isLock);
|
}
|
if (type != null && !type.equals("")) {
|
queryWrapper.eq("type", type);
|
}
|
String s = DateTimeUtil.dateToStr(new Date());
|
//subscribe_time大于当前时间
|
queryWrapper.le("subscribe_time", DateTimeUtil.dateToStr1(new Date())).orderByAsc("subscribe_time");
|
queryWrapper.ge("subscription_time", DateTimeUtil.dateToStr1(new Date())).orderByAsc("subscribe_time");
|
List<StockSubscribe> stockSubscribeList = this.stockSubscribeMapper.selectList(queryWrapper);
|
|
// List<StockAdminListVO> stockAdminListVOS = Lists.newArrayList();
|
PageInfo pageInfo = new PageInfo(stockSubscribeList);
|
pageInfo.setList(stockSubscribeList);
|
return ServerResponse.createBySuccess(pageInfo);
|
}
|
|
|
@Override
|
public ServerResponse<PageInfo> listbyadmin(int pageNum, int pageSize,String name,String code,Integer zt,Integer isLock,Integer type, HttpServletRequest request) {
|
PageHelper.startPage(pageNum, pageSize);
|
//name和code模糊查询
|
QueryWrapper<StockSubscribe> queryWrapper = new QueryWrapper();
|
if (name != null && !name.equals("")) {
|
queryWrapper.like("name", name);
|
}
|
if (code != null && !code.equals("")) {
|
queryWrapper.like("code", code);
|
}
|
if (zt != null && !zt.equals("")) {
|
queryWrapper.eq("zt", zt);
|
}
|
if(isLock!=null && !isLock.equals("")){
|
queryWrapper.eq("is_lock",isLock);
|
}
|
if (type != null && !type.equals("")) {
|
queryWrapper.eq("type", type);
|
}
|
String s = DateTimeUtil.dateToStr(new Date());
|
//subscribe_time大于当前时间
|
queryWrapper.orderByAsc("subscribe_time");
|
List<StockSubscribe> stockSubscribeList = this.stockSubscribeMapper.selectList(queryWrapper);
|
|
// List<StockAdminListVO> stockAdminListVOS = Lists.newArrayList();
|
PageInfo pageInfo = new PageInfo(stockSubscribeList);
|
pageInfo.setList(stockSubscribeList);
|
return ServerResponse.createBySuccess(pageInfo);
|
}
|
|
/**
|
* @Description: 新增新股
|
* @Param:
|
* @return:
|
* @Author: tf
|
* @Date: 2022/10/25
|
*/
|
@Override
|
public ServerResponse add(StockSubscribe model, HttpServletRequest request) {
|
//判断是否已经存在
|
log.info("model:{}",model);
|
List<StockSubscribe> stockSubscribeList = this.stockSubscribeMapper.selectList(new QueryWrapper<StockSubscribe>().eq("code", model.getCode()));
|
if (stockSubscribeList != null && stockSubscribeList.size()>0) {
|
return ServerResponse.createByErrorMsg("新股已经存在，不要重复添加");
|
}
|
// String sinaStock = SinaStockApi.getSinaStock(model.getStockType()+model.getCode());
|
// String[] arrayOfString = sinaStock.split(",");
|
// if (arrayOfString.length < 10)
|
// return ServerResponse.createByErrorMsg("数据源无该新股");
|
//添加新股
|
int resultCount = this.stockSubscribeMapper.insert(model);
|
if (resultCount > 0) {
|
return ServerResponse.createBySuccessMsg("添加新股成功");
|
}
|
return ServerResponse.createByErrorMsg("添加新股失败");
|
}
|
/**
|
* @Description: 修改新股
|
* @Param:
|
* @return:
|
* @Author: tf
|
* @Date: 2022/10/25
|
*/
|
@Override
|
public ServerResponse update(StockSubscribe model, HttpServletRequest request) {
|
StockSubscribe stockSubscribe = this.stockSubscribeMapper.selectById(model.getNewlistId());
|
if (stockSubscribe == null) {
|
return ServerResponse.createByErrorMsg("新股不存在");
|
}
|
//修改新股
|
int resultCount = this.stockSubscribeMapper.updateById(model);
|
if (resultCount > 0) {
|
return ServerResponse.createBySuccessMsg("修改新股成功");
|
}
|
return ServerResponse.createByErrorMsg("修改新股失败");
|
}
|
/**
|
* @Description: 删除新股
|
* @Param:
|
* @return:
|
* @Author: tf
|
* @Date: 2022/10/25
|
*/
|
@Override
|
public ServerResponse del(Integer id, HttpServletRequest request) {
|
StockSubscribe stockSubscribe = this.stockSubscribeMapper.selectById(id);
|
if (stockSubscribe == null) {
|
return ServerResponse.createByErrorMsg("新股不存在");
|
}
|
//删除新股
|
int resultCount = this.stockSubscribeMapper.deleteById(id);
|
if (resultCount > 0) {
|
return ServerResponse.createBySuccessMsg("删除新股成功");
|
}
|
return ServerResponse.createByErrorMsg("删除新股失败");
|
}
|
|
|
/**
|
* @Description: 新股抢筹列表
|
*/
|
@Override
|
public ServerResponse newStockQc(HttpServletRequest request) {
|
String nowDate = DateTimeUtil.stampToDate(String.valueOf(System.currentTimeMillis()));
|
List<StockSubscribe> stockSubscribeListQc = this.stockSubscribeMapper.selectList(new QueryWrapper<StockSubscribe>().eq("list_date",nowDate));
|
return ServerResponse.createBySuccess(stockSubscribeListQc);
|
}
|
|
|
|
}
|
