1、首先配置左侧菜单栏children、路由、添加components里面的文件夹和页面noise.vue略）
2、安装插件vue vscode vbase
3、按UI设计图编写页面的div排版
4、前提：先简单写了一些静态的数据到静态页面上，包括getNoiseList函数和setCharts函数，然后再问编写询问GPT的语句，尽量包含上下文
一、有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点的数据，那折线图就只有这两个点；如果当天没有任何时间点的数据，则没有折线数据。我改如何改写上面的代码使其满足要求。最后得到修改后的代码如下：
最后前台显示如图：
现在已经有一些AI能直接通过传入UI设计图自动生成静态页面，但是感觉不太友好（比如CSS的命名是XX1到XX1000，无法人工修改），能够部分节约开发者的时间也是一件好事儿。
标签：03,00,vue,代码,NULL,2024,GPT,null,data From： https://www.cnblogs.com/CarlJohnson9527/p/18095938