尚硅谷学苑项目-统计模块

最新推荐文章于 2024-09-27 11:31:35 发布

217y_418

最新推荐文章于 2024-09-27 11:31:35 发布

阅读量81

点赞数

文章标签： sql 数据库 java

本文链接：https://blog.csdn.net/m0_63218762/article/details/133770639

版权

上次未完成的,实现购买识别

在order中添加接口

    //根据用户信息和课程信息查询是否购买
    @GetMapping("IsBuyCourse/{courseId}/{ucenterId}")
    public boolean IsBuyCourse(@PathVariable("courseId") String courseId, @PathVariable("ucenterId") String ucenterId) {
        QueryWrapper<Order> wrapper = new QueryWrapper<>();
        wrapper.eq("course_id", courseId);
        wrapper.eq("member_id", ucenterId);
        int count = orderService.count(wrapper);
        return (count > 0);
    }

再使用远程服务调用该方法,其中orderClient就是注册到nacos中的服务

@FeignClient("service-order")
@Component
public interface ServiceOrderClient {

    @GetMapping("/orderservice/order/IsBuyCourse/{courseId}/{ucenterId}")
    boolean IsBuyCourse(@PathVariable("courseId") String courseId, @PathVariable("ucenterId") String ucenterId);

}

    @GetMapping("getCourseWebVo/{id}")
    public ResultVo getCourseWebVoById(@PathVariable String id, HttpServletRequest request) {
        CourseWebVo webVo = courseService.getCourseWebVoById(id);
        List<ChapterVo> chapterVideoList = chapterService.allChapter(id);
        //判断是否购买该课程
        boolean b = orderClient.IsBuyCourse(id, JwtUtils.getMemberIdByJwtToken(request));
        
        return ResultVo.ok().data("courseWebVo", webVo).data("chapterVideoList", chapterVideoList).data("isBuy", b);
    }

结束?没有

  asyncData({ params, error })

asyncData 是异步的,也就是说异步的方法会被等待,不安全说是,这是我的理解,在课程视频中老师并没有详细的说

所以我们要改成Vue的钩子函数,这里又用到我们created() 懒的复制了

this.isBuy=res.data.data.isBuy

数据库中创建

Create Table

CREATE TABLE `statistics_daily` (
  `id` char(19) NOT NULL COMMENT '主键',
  `date_calculated` varchar(20) NOT NULL COMMENT '统计日期',
  `register_num` int(11) NOT NULL DEFAULT '0' COMMENT '注册人数',
  `login_num` int(11) NOT NULL DEFAULT '0' COMMENT '登录人数',
  `video_view_num` int(11) NOT NULL DEFAULT '0' COMMENT '每日播放视频数',
  `course_num` int(11) NOT NULL DEFAULT '0' COMMENT '每日新增课程数',
  `gmt_create` datetime NOT NULL COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `statistics_day` (`date_calculated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='网站统计日数据'

先解决前面发生的问题 :MySQL数据库插入中文出现???
解决办法:
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character_set_server=utf8
collation-server=utf8_general_ci
修改my.ini文件
然后重启MySQL服务

然后再recourse中创建配置文件

# 服务端口
server.port=8008
# 服务名
spring.application.name=service-statistics

# mysql数据库连接
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/guli?serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=123456

#返回json的全局时间格式
spring.jackson.date-format=yyyy-MM-dd HH:mm:ss
spring.jackson.time-zone=GMT+8

#配置mapper xml文件的路径
mybatis-plus.mapper-locations=classpath:com/zhy/staservice/mapper/xml/*.xml

#mybatis日志
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

# nacos服务地址
spring.cloud.nacos.discovery.server-addr=127.0.0.1:8848

#开启熔断机制
#feign.hystrix.enabled=true
# 设置hystrix超时时间，默认1000ms
#hystrix.command.default.execution.isolation.thread.timeoutInMilliseconds=3000

可别忘记Nginx

location ~ /staservice/ { proxy_pass http://localhost:8887; }

配置完成,写接口

也就是说需要在ucenter服务中写一个查询人数的接口

    //统计人数数据接口
    @GetMapping("countRegister/{day}")
    public ResultVo countRegister(@PathVariable("day") String day) {
        Integer count = service.getcountRegister(day);
        return ResultVo.ok().data("count", count);
    }

    <select
            id="getcountRegister"
            resultType="java.lang.Integer">

        select count(1)
        from ucenter_member um
        where DATE(um.gmt_create)=#{day};

    </select>

swagger测试一下

把数据放进统计表中

random是为了数据填充,可用真实数据代替

    @GetMapping("QueryCount/{day}")
    public ResultVo QueryCount(@PathVariable("day") String day) {
        Integer countRegister = countClient.countRegister(day);
        QueryWrapper<StatisticsDaily> wrapper = new QueryWrapper<>();
        wrapper.eq("date_calculated", day);
        dailyService.remove(wrapper);
        StatisticsDaily statisticsDaily = new StatisticsDaily();
        statisticsDaily.setRegisterNum(countRegister);
        statisticsDaily.setDateCalculated(day);
        statisticsDaily.setCourseNum(RandomUtils.nextInt(100, 200));
        statisticsDaily.setLoginNum(RandomUtils.nextInt(100, 200));
        statisticsDaily.setVideoViewNum(RandomUtils.nextInt(100, 200));
        dailyService.save(statisticsDaily);
        return ResultVo.ok().success(true);
    }

controller应该尽可能保持整洁的我错了

统计表数据生成完毕~

使用echarts生成柱状图

npm install --save echarts@4.1.0

<template>
  <div class="app-container">
    <!--表单-->
    <el-form :inline="true" class="demo-form-inline">

      <el-form-item>
        <el-select v-model="searchObj.type" clearable placeholder="请选择">
          <el-option label="学员登录数统计" value="login_num"/>
          <el-option label="学员注册数统计" value="register_num"/>
          <el-option label="课程播放数统计" value="video_view_num"/>
          <el-option label="每日课程数统计" value="course_num"/>
        </el-select>
      </el-form-item>

      <el-form-item>
        <el-date-picker
          v-model="searchObj.begin"
          type="date"
          placeholder="选择开始日期"
          value-format="yyyy-MM-dd" />
      </el-form-item>
      <el-form-item>
        <el-date-picker
          v-model="searchObj.end"
          type="date"
          placeholder="选择截止日期"
          value-format="yyyy-MM-dd" />
      </el-form-item>
      <el-button
        :disabled="btnDisabled"
        type="primary"
        icon="el-icon-search"
        @click="showChart()">查询</el-button>
    </el-form>

    <div class="chart-container">
      <div id="chart" class="chart" style="height:500px;width:100%" />
    </div>
  </div>
</template>
<script>
import echarts from 'echarts'

export default {
    data() {
        return {
            searchObj:{},
            btnDisabled:false,
            xData:[],
            yData:[]
        }
    },
    methods:{
    	// 准备图表数据
        showChart() {
            //调用下面生成图表的方法，改变值
            this.setChart()
        },
        // 设置图标参数
        setChart() {
            // 基于准备好的dom，初始化echarts实例
            this.chart = echarts.init(document.getElementById('chart'))
            // console.log(this.chart)

            // 指定图表的配置项和数据
            var option = {
                // x轴是类目轴（离散数据）,必须通过data设置类目数据
                xAxis: {
                    type: 'category',
                    data:  ['Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun']
                },
                // y轴是数据轴（连续数据）
                yAxis: {
                    type: 'value'
                },
                // 系列列表。每个系列通过 type 决定自己的图表类型
                series: [{
                    // 系列中的数据内容数组
                    data: [820, 932, 901, 934, 1290, 1330, 1320],
                    // 折线图
                    type: 'line'
                }]
            }

            this.chart.setOption(option)
        }
    }
}
</script>

其实就是两个数组,xdata 和ydata GET IT 写接口

    @PostMapping("QueryData/{type}/{begin}/{end}")
    public ResultVo QueryData(@PathVariable String type, @PathVariable String begin, @PathVariable String end) {
        Map map = dailyService.QueryData(type, begin, end);
        return ResultVo.ok().data(map);
    }

@Override
    public Map QueryData(String type, String begin, String end) {
        QueryWrapper<StatisticsDaily> wrapper = new QueryWrapper<>();
        wrapper.between("date_calculated", begin, end);
        List<StatisticsDaily> statisticsDailies = baseMapper.selectList(wrapper);
        List<String> date_calculatedList = new ArrayList<>();
        List<Integer> numDataList = new ArrayList<>();

        for (StatisticsDaily daily : statisticsDailies) {
            date_calculatedList.add(daily.getDateCalculated());
            switch (type) {
                case "login_num":
                    numDataList.add(daily.getLoginNum());
                    break;
                case "register_num":
                    numDataList.add(daily.getRegisterNum());
                    break;
                case "video_view_num":
                    numDataList.add(daily.getVideoViewNum());
                    break;
                case "course_num":
                    numDataList.add(daily.getCourseNum());
                    break;
                default:
                    break;
            }
        }
        Map<String, Object> map =new HashMap<>();
        map.put("date_calculatedList",date_calculatedList);
        map.put("numDataList",numDataList);
        return map;
    }

写一个API封装调用接口方法,并传值XY数据

这里不写了,学到这里肯定也会了

搞定!

css样式

dataZoom: [{
   show: true,
   height: 30,
   xAxisIndex: [
       0
   ],
   bottom: 30,
   start: 10,
   end: 80,
   handleIcon: 'path://M306.1,413c0,2.2-1.8,4-4,4h-59.8c-2.2,0-4-1.8-4-4V200.8c0-2.2,1.8-4,4-4h59.8c2.2,0,4,1.8,4,4V413z',
   handleSize: '110%',
   handleStyle: {
       color: '#d3dee5'

   },
   textStyle: {
       color: '#fff'
   },
   borderColor: '#90979c'
   },
   {
   type: 'inside',
   show: true,
   height: 15,
   start: 1,
   end: 35
}],