From 27d341342925f11c19fb7a31da7050f5e9041319 Mon Sep 17 00:00:00 2001
From: feiyu02 <risaku@163.com>
Date: 星期四, 19 十月 2023 17:52:29 +0800
Subject: [PATCH] 新增数据分析模块
---
src/main/java/com/flightfeather/monitor/service/impl/SqlServiceImpl.java | 66 +++++++++++++++++++++++++++++++++
1 files changed, 66 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/flightfeather/monitor/service/impl/SqlServiceImpl.java b/src/main/java/com/flightfeather/monitor/service/impl/SqlServiceImpl.java
new file mode 100644
index 0000000..7539e20
--- /dev/null
+++ b/src/main/java/com/flightfeather/monitor/service/impl/SqlServiceImpl.java
@@ -0,0 +1,66 @@
+package com.flightfeather.monitor.service.impl;
+
+import com.flightfeather.monitor.mapper.SqlMapper;
+import com.flightfeather.monitor.pojo.OriginalData;
+import com.flightfeather.monitor.pojo.PageBean;
+import com.flightfeather.monitor.service.SqlService;
+import com.github.pagehelper.Page;
+import com.github.pagehelper.PageHelper;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+
+import java.time.LocalDate;
+import java.util.List;
+
+
+@Service
+public class SqlServiceImpl implements SqlService {
+ @Autowired
+ private SqlMapper sqlMapper;
+
+ @Override
+ public PageBean page(Integer page, Integer pageSize, String shopname, LocalDate begin, LocalDate end) {
+ /* //鑾峰彇鎬昏褰曟暟
+ Long count=empMapper.count();
+ //鑾峰彇鍒嗛〉鏌ヨ缁撴灉鍒楄〃
+ Integer start =(page-1)*pageSize;
+ List<Emp> list=empMapper.list(start,pageSize);*/
+ //璁剧疆鍒嗛〉鍙傛暟
+ PageHelper.startPage(page, pageSize);
+ //鎵ц鏌ヨ
+ List<OriginalData> infoList = sqlMapper.list(shopname, begin, end);
+ //鑾峰彇鏌ヨ缁撴灉
+ Page<OriginalData> p1 = (Page<OriginalData>) infoList;
+
+ //灏佽PageBean瀵硅薄*/
+ PageBean pageBean = new PageBean(p1.getTotal(), p1.getResult());
+ return pageBean;
+
+ }
+
+ @Override
+ public List<OriginalData> show_all() {
+ List<OriginalData> list_sql = sqlMapper.show_all();
+ return list_sql;
+ }
+
+ @Override
+ public List<OriginalData> findShop(String shopname) {
+ List<OriginalData> shops = sqlMapper.findShop(shopname);
+ return shops;
+ }
+
+ @Override
+ public List<OriginalData> findDate(LocalDate begin, LocalDate end) {
+ List<OriginalData> dates = sqlMapper.findDate(begin, end);
+ return dates;
+ }
+
+ @Override
+ public List<OriginalData> findByForm(String name, String number, String dname, String begin, String end) {
+ List<OriginalData> form = sqlMapper.findByForm(name, number, dname, begin, end);
+ return form;
+ }
+
+
+}
--
Gitblit v1.9.3