一、有mysql表和数据如下：
CREATE TABLE `meteorological_data` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`date` date NOT NULL COMMENT '日期',
`pm25` decimal(10,2) DEFAULT NULL COMMENT 'PM2.5',
`pm25_standard` decimal(10,2) DEFAULT NULL COMMENT 'PM2.5国控值',
`pm10` decimal(10,2) DEFAULT NULL COMMENT 'PM10',
`pm10_standard` decimal(10,2) DEFAULT NULL COMMENT 'PM10国控值',
`tsp` decimal(10,2) DEFAULT NULL COMMENT 'TSP',
`noise` decimal(10,2) DEFAULT NULL COMMENT '噪音',
`noise_threshold` decimal(10,2) DEFAULT NULL COMMENT '噪音阈值',
`warning_status` varchar(255) DEFAULT NULL COMMENT '预警状态',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='噪音实况监测表';
INSERT INTO `meteorological_data` VALUES (45, '2024-03-23 00:00:00', 65.41, NULL, 116.74, NULL, 45.63, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (46, '2024-03-22 23:00:00', 66.54, NULL, 124.00, NULL, 50.79, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (47, '2024-03-26 22:00:00', 57.34, NULL, 106.82, NULL, 51.02, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (48, '2024-03-26 21:00:00', 55.14, NULL, 101.47, NULL, 51.95, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (49, '2024-03-22 20:00:00', 61.35, NULL, 93.82, NULL, 52.08, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (50, '2024-03-22 19:00:00', 58.92, NULL, 89.12, NULL, 54.42, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (51, '2024-03-22 18:00:00', 57.17, NULL, 85.24, NULL, 56.77, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (52, '2024-03-22 17:00:00', 57.59, NULL, 90.16, NULL, 57.32, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (53, '2024-03-22 16:00:00', 56.78, NULL, 84.98, NULL, 57.72, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (54, '2024-03-22 15:00:00', 57.22, NULL, 82.46, NULL, 58.06, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (55, '2024-03-26 14:00:00', 55.11, NULL, 80.07, NULL, 57.25, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (56, '2024-03-22 13:00:00', 55.64, NULL, 82.66, NULL, 54.98, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (57, '2024-03-22 12:00:00', 52.81, NULL, 80.69, NULL, 54.89, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (58, '2024-03-26 11:00:00', 62.68, NULL, 97.51, NULL, 57.75, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (59, '2024-03-22 09:00:00', 79.89, NULL, 129.67, NULL, 58.35, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (60, '2024-03-22 08:00:00', 86.17, NULL, 145.80, NULL, 59.20, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (61, '2024-03-22 07:00:00', 102.47, NULL, 157.71, NULL, 53.09, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (62, '2024-03-22 06:00:00', 109.46, NULL, 165.56, NULL, 47.72, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (63, '2024-03-22 05:00:00', 105.12, NULL, 159.32, NULL, 44.76, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (64, '2024-03-22 04:00:00', 95.14, NULL, 149.62, NULL, 43.61, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (65, '2024-03-26 03:00:00', 92.45, NULL, 148.59, NULL, 43.31, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (66, '2024-03-22 02:00:00', 89.08, NULL, 146.72, NULL, 42.86, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (67, '2024-03-22 01:00:00', 81.92, NULL, 139.78, NULL, 43.08, NULL, NULL, NULL);
INSERT INTO `meteorological_data` VALUES (68, '2024-03-26 00:00:00', 76.01, NULL, 128.69, NULL, 44.23, NULL, NULL, NULL);
二、有vue代码如下：
<template>
<div>
<div>
<div class="header flex jb" style="height: 1.67vw">
<bluetitle name="噪音实况分析" />
<div style="gap: 0.52vw" class="flex">
<bluetabs :tabList="tablist" :active="activeTab" @tabchange="tabchange" />
<bluetabs :tabList="tablists" :active="activeTabSub" @tabchange="tabchanges" />
</div>
</div>
<div id="main" style="
width: 60.63vw;
height: 22.29vw;
margin-top: 1.04vw;
width: 100%;
background: #282828;
margin-bottom: 1.04vw;
"></div>
<div class="flex jb">
<bluetitle name="噪音实况记录" />
</div>
<t-table rowKey="index" :data="tableDatas" :columns="tableheaders" table-layout="fixed" :pagination="pagination"
@page-change="onPageChange">
</t-table>
</div>
</div>
</template>
<script>
import * as echarts from "echarts";
export default {
name: "indexenviron",
data() {
return {
pagination: {
current: 1,
pageSize: 10,
total: 0,
showJumper: true,
},
timevalue: "",
tablist: [
{ label: "PM2.5", value: 1 },
{ label: "PM10", value: 2 },
{ label: "TSP", value: 3 },
{ label: "噪音", value: 4 },
],
tablists: [
{ label: "当天", value: 1 },
{ label: "近七日", value: 2 },
{ label: "近一月", value: 3 },
{ label: "近一年", value: 4 },
],
activeTab: 1, // 默认选中"PM2.5"
activeTabSub: 1, // 默认选中"当天"
tableheaders: [],
tableDatas: [],
};
},
mounted() {
this.setCharts(this.data);
// this.get();
this.getNoiseList();
},
methods: {
async onPageChange(e) {
this.pagination = e;
let str = `?pageNum=${e.current}&pageSize=${e.pageSize}`;
},
tabchange(value) {
this.activeTab = value;
this.getNoiseList();
},
tabchanges(e) {
this.pagination.current = 1;
this.getNoiseList();
},
//噪音实况表
async getNoiseList() {
let params = {
primaryTab: this.activeTab,
secondaryTab: this.activeTabSub,
pageNum: this.pagination.current,
pageSize: this.pagination.pageSize,
};
let res = await this.$https.post(this.$url.environ.noise.list, params);
if (res.code == 200) {
const processedRows = res.rows.map(row => {
// 假设row.date格式为"2024-02-27 10:30:12"
const regex = /(\d{4}-\d{2}-\d{2}) (\d{2}:\d{2}:\d{2})/;
const match = row.date.match(regex);
if (match) {
return {
...row,
dateOnly: match[1], // 匹配到的日期部分
timeOnly: match[2] // 匹配到的时间部分
};
}
return row; // 如果没有匹配到，则返回原始行
});
(this.tableheaders = [
{ title: "序号", colKey: "id" },
{ title: "日期", colKey: "dateOnly" },
{ title: "时间", colKey: "timeOnly" },
{ title: "PM2.5", colKey: "pm25" },
{ title: "PM2.5国控值", colKey: "pm25Standard" },
{ title: "PM10", colKey: "pm10" },
{ title: "PM10国控值", colKey: "pm10Standard" },
{ title: "TSP", colKey: "tsp" },
{ title: "噪音", colKey: "noise" },
{ title: "噪音阈值", colKey: "noiseThreshold" },
{ title: "预警状态", colKey: "warningStatus" },
]),
this.tableDatas = processedRows; // 使用处理后的数据
this.pagination.total = res.total;
} else {
this.tableDatas = [];
}
},
async setCharts(data) {
var myChart = echarts.init(document.getElementById("main"));
// 生成横坐标数组，表示0点到23点
const hours = Array.from({ length: 24 }, (_, index) => `${index}:00`);
let params = {
primaryTab: this.activeTab,
secondaryTab: this.activeTabSub,
pageNum: this.pagination.current,
pageSize: this.pagination.pageSize,
};
let res = await this.$https.post(this.$url.environ.noise.list, params);
console.log("res"+res);
let option = {
tooltip: {
trigger: "axis",
axisPointer: {
type: "cross",
label: {
backgroundColor: "#6a7985",
},
},
},
xAxis: {
type: "category",
boundaryGap: false,
data: hours,
},
yAxis: {
type: "value",
},
series: [
{
data: [820, 932, 901, 934, 1290, 1330, 1320],
type: "line",
areaStyle: {},
},
],
};
myChart.setOption(option);
},
},
};
</script>
<style lang="scss" scoped>
</style>
三、查询后端接口this.$https.post(this.$url.environ.noise.list, params)时返回obj的res如下：
{
"total": 24,
"rows": [
{
"id": 45,
"date": "2024-03-23 00:00:00",
"pm25": 65.41,
"pm25Standard": null,
"pm10": 116.74,
"pm10Standard": null,
"tsp": 45.63,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
},
{
"id": 46,
"date": "2024-03-22 23:00:00",
"pm25": 66.54,
"pm25Standard": null,
"pm10": 124.0,
"pm10Standard": null,
"tsp": 50.79,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
},
{
"id": 47,
"date": "2024-03-26 22:00:00",
"pm25": 57.34,
"pm25Standard": null,
"pm10": 106.82,
"pm10Standard": null,
"tsp": 51.02,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
},
{
"id": 48,
"date": "2024-03-26 21:00:00",
"pm25": 55.14,
"pm25Standard": null,
"pm10": 101.47,
"pm10Standard": null,
"tsp": 51.95,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
},
{
"id": 49,
"date": "2024-03-22 20:00:00",
"pm25": 61.35,
"pm25Standard": null,
"pm10": 93.82,
"pm10Standard": null,
"tsp": 52.08,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
},
{
"id": 50,
"date": "2024-03-22 19:00:00",
"pm25": 58.92,
"pm25Standard": null,
"pm10": 89.12,
"pm10Standard": null,
"tsp": 54.42,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
},
{
"id": 51,
"date": "2024-03-22 18:00:00",
"pm25": 57.17,
"pm25Standard": null,
"pm10": 85.24,
"pm10Standard": null,
"tsp": 56.77,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
},
{
"id": 52,
"date": "2024-03-22 17:00:00",
"pm25": 57.59,
"pm25Standard": null,
"pm10": 90.16,
"pm10Standard": null,
"tsp": 57.32,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
},
{
"id": 53,
"date": "2024-03-22 16:00:00",
"pm25": 56.78,
"pm25Standard": null,
"pm10": 84.98,
"pm10Standard": null,
"tsp": 57.72,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
},
{
"id": 54,
"date": "2024-03-22 15:00:00",
"pm25": 57.22,
"pm25Standard": null,
"pm10": 82.46,
"pm10Standard": null,
"tsp": 58.06,
"noise": null,
"noiseThreshold": null,
"warningStatus": null
}
],
"code": 200,
"msg": "查询成功"
}
四、问：根据后端返回数据生成列表和折线图，折线图中如果后端返回的date不是系统的日期，则没有折线数据，有整点的数据就标上折线，比如：如果有3点、11点的数据，那折线图就只有这两个点；如果当天没有任何时间点的数据，则没有折线数据。我改如何改写上面的代码使其满足要求。最后得到修改后的代码如下：
最后前台显示如图：
总结：现在GPT对CSS支持还没那么好，但是已经对JS支持非常完善，在自己写静态页面后，去和后端调测接口并修改页面显示完全可以用上GPT，当然用GPT的原则是用新不用旧。
现在已经有一些AI能直接通过传入UI设计图自动生成静态页面，但是感觉不太友好（比如CSS的命名是XX1到XX1000，无法人工修改），能够部分节约开发者的时间也是一件好事儿。
