<template>
|
<div class="app-container">
|
<!-- 查询条件 -->
|
<div class="search_form">
|
<div>
|
<span class="search_title">车辆编号：</span>
|
<el-input
|
v-model="searchForm.vehicleCode"
|
style="width: 200px"
|
placeholder="请输入车辆编号"
|
clearable
|
@keyup.enter.native="handleQuery"
|
/>
|
|
<span class="search_title ml10">加油时间：</span>
|
<el-date-picker
|
v-model="searchForm.dateRange"
|
type="daterange"
|
range-separator="至"
|
start-placeholder="开始日期"
|
end-placeholder="结束日期"
|
value-format="YYYY-MM-DD"
|
format="YYYY-MM-DD"
|
clearable
|
@change="handleQuery"
|
/>
|
|
<el-button type="primary" @click="handleQuery" style="margin-left: 10px">
|
搜索
|
</el-button>
|
<el-button @click="resetSearch">重置</el-button>
|
</div>
|
<div>
|
<el-button type="primary" icon="Plus" @click="openAdd">
|
新增加油记录
|
</el-button>
|
</div>
|
</div>
|
|
<!-- 表格 -->
|
<div class="table_list">
|
<el-table
|
:data="tableData"
|
border
|
style="width: 100%"
|
height="calc(100vh - 18.5em)"
|
:header-cell-style="{ background: '#F0F1F5', color: '#333333' }"
|
:row-class-name="tableRowClassName"
|
>
|
<el-table-column type="index" label="序号" width="60" align="center" />
|
<el-table-column
|
prop="vehicleCode"
|
label="车辆编号"
|
width="130"
|
show-overflow-tooltip
|
/>
|
<el-table-column
|
prop="plateNumber"
|
label="车牌号码"
|
width="120"
|
show-overflow-tooltip
|
/>
|
<el-table-column
|
prop="fuelDate"
|
label="加油日期"
|
width="120"
|
show-overflow-tooltip
|
/>
|
<el-table-column
|
prop="gunNo"
|
label="油枪号"
|
width="90"
|
align="center"
|
/>
|
<el-table-column
|
prop="amount"
|
label="金额(元)"
|
width="100"
|
align="right"
|
>
|
<template #default="scope">
|
<span>{{ scope.row.amount?.toFixed(2) }}</span>
|
</template>
|
</el-table-column>
|
<el-table-column
|
prop="liters"
|
label="升数(L)"
|
width="90"
|
align="right"
|
>
|
<template #default="scope">
|
<span>{{ scope.row.liters?.toFixed(2) }}</span>
|
</template>
|
</el-table-column>
|
<el-table-column
|
prop="startMileage"
|
label="起始里程(km)"
|
width="120"
|
align="right"
|
/>
|
<el-table-column
|
prop="endMileage"
|
label="结束里程(km)"
|
width="120"
|
align="right"
|
/>
|
<el-table-column
|
prop="distance"
|
label="行驶里程(km)"
|
width="120"
|
align="right"
|
/>
|
<el-table-column
|
prop="fuelConsumption"
|
label="油耗(L/100km)"
|
width="130"
|
align="center"
|
>
|
<template #default="scope">
|
<span
|
:style="scope.row.isAbnormal ? 'color:#F56C6C;font-weight:600;' : ''"
|
>
|
{{ scope.row.fuelConsumption != null ? scope.row.fuelConsumption.toFixed(2) : '-' }}
|
</span>
|
</template>
|
</el-table-column>
|
<el-table-column
|
prop="avgConsumption"
|
label="车辆平均油耗"
|
width="130"
|
align="center"
|
>
|
<template #default="scope">
|
<span>
|
{{ scope.row.avgConsumption != null ? scope.row.avgConsumption.toFixed(2) : '-' }}
|
</span>
|
</template>
|
</el-table-column>
|
<el-table-column label="异常预警" width="100" align="center">
|
<template #default="scope">
|
<el-tag v-if="scope.row.isAbnormal" type="danger" size="small">
|
异常
|
</el-tag>
|
<span v-else>-</span>
|
</template>
|
</el-table-column>
|
<el-table-column label="操作" fixed="right" width="140" align="center">
|
<template #default="scope">
|
<el-button
|
type="primary"
|
link
|
size="small"
|
@click="openEdit(scope.row)"
|
>
|
编辑
|
</el-button>
|
<el-button
|
type="danger"
|
link
|
size="small"
|
@click="removeRow(scope.row)"
|
>
|
删除
|
</el-button>
|
</template>
|
</el-table-column>
|
</el-table>
|
</div>
|
|
<!-- 新增/编辑弹窗 -->
|
<el-dialog
|
v-model="dialogVisible"
|
:title="dialogTitle"
|
width="640px"
|
destroy-on-close
|
>
|
<el-form
|
ref="formRef"
|
:model="form"
|
:rules="rules"
|
label-width="110px"
|
label-position="right"
|
>
|
<el-row :gutter="20">
|
<el-col :span="12">
|
<el-form-item label="车辆编号：" prop="vehicleCode">
|
<el-input
|
v-model="form.vehicleCode"
|
placeholder="请输入车辆编号"
|
/>
|
</el-form-item>
|
</el-col>
|
<el-col :span="12">
|
<el-form-item label="车牌号码：" prop="plateNumber">
|
<el-input
|
v-model="form.plateNumber"
|
placeholder="请输入车牌号码"
|
/>
|
</el-form-item>
|
</el-col>
|
</el-row>
|
<el-row :gutter="20">
|
<el-col :span="12">
|
<el-form-item label="加油日期：" prop="fuelDate">
|
<el-date-picker
|
v-model="form.fuelDate"
|
type="date"
|
value-format="YYYY-MM-DD"
|
format="YYYY-MM-DD"
|
placeholder="请选择加油日期"
|
style="width: 100%"
|
/>
|
</el-form-item>
|
</el-col>
|
<el-col :span="12">
|
<el-form-item label="油枪号：" prop="gunNo">
|
<el-input
|
v-model="form.gunNo"
|
placeholder="请输入油枪号"
|
/>
|
</el-form-item>
|
</el-col>
|
</el-row>
|
<el-row :gutter="20">
|
<el-col :span="12">
|
<el-form-item label="金额(元)：" prop="amount">
|
<el-input-number
|
v-model="form.amount"
|
:min="0"
|
:step="0.01"
|
:precision="2"
|
placeholder="请输入金额"
|
style="width: 100%"
|
/>
|
</el-form-item>
|
</el-col>
|
<el-col :span="12">
|
<el-form-item label="升数(L)：" prop="liters">
|
<el-input-number
|
v-model="form.liters"
|
:min="0"
|
:step="0.01"
|
:precision="2"
|
placeholder="请输入升数"
|
style="width: 100%"
|
/>
|
</el-form-item>
|
</el-col>
|
</el-row>
|
<el-row :gutter="20">
|
<el-col :span="12">
|
<el-form-item label="起始里程(km)：" prop="startMileage">
|
<el-input-number
|
v-model="form.startMileage"
|
:min="0"
|
:step="1"
|
placeholder="请输入起始里程"
|
style="width: 100%"
|
/>
|
</el-form-item>
|
</el-col>
|
<el-col :span="12">
|
<el-form-item label="结束里程(km)：" prop="endMileage">
|
<el-input-number
|
v-model="form.endMileage"
|
:min="0"
|
:step="1"
|
placeholder="请输入结束里程"
|
style="width: 100%"
|
/>
|
</el-form-item>
|
</el-col>
|
</el-row>
|
</el-form>
|
<template #footer>
|
<div class="dialog-footer">
|
<el-button @click="handleCancel">取 消</el-button>
|
<el-button type="primary" @click="handleSubmit">保 存</el-button>
|
</div>
|
</template>
|
</el-dialog>
|
</div>
|
</template>
|
|
<script setup>
|
import { ref, reactive, onMounted } from "vue";
|
import { ElMessage, ElMessageBox } from "element-plus";
|
|
// 模拟加油记录数据
|
const rawRecords = ref([
|
{
|
id: 1,
|
vehicleCode: "CL-202401",
|
plateNumber: "粤A12345",
|
fuelDate: "2024-12-01",
|
gunNo: "01",
|
amount: 500,
|
liters: 70,
|
startMileage: 12000,
|
endMileage: 12600,
|
},
|
{
|
id: 2,
|
vehicleCode: "CL-202401",
|
plateNumber: "粤A12345",
|
fuelDate: "2024-12-15",
|
gunNo: "02",
|
amount: 520,
|
liters: 72,
|
startMileage: 12600,
|
endMileage: 13250,
|
},
|
{
|
id: 3,
|
vehicleCode: "CL-202402",
|
plateNumber: "粤B67890",
|
fuelDate: "2024-12-05",
|
gunNo: "03",
|
amount: 430,
|
liters: 60,
|
startMileage: 8000,
|
endMileage: 8520,
|
},
|
{
|
id: 4,
|
vehicleCode: "CL-202402",
|
plateNumber: "粤B67890",
|
fuelDate: "2024-12-20",
|
gunNo: "01",
|
amount: 450,
|
liters: 63,
|
startMileage: 8520,
|
endMileage: 9000,
|
},
|
{
|
id: 5,
|
vehicleCode: "CL-202401",
|
plateNumber: "粤A12345",
|
fuelDate: "2025-01-05",
|
gunNo: "01",
|
amount: 700,
|
liters: 90,
|
startMileage: 13250,
|
endMileage: 13600, // 明显异常油耗
|
},
|
]);
|
|
// 查询表单
|
const searchForm = reactive({
|
vehicleCode: "",
|
dateRange: [],
|
});
|
|
// 表格数据（包含计算字段）
|
const tableData = ref([]);
|
|
// 弹窗 & 表单
|
const dialogVisible = ref(false);
|
const dialogTitle = ref("新增加油记录");
|
const isEdit = ref(false);
|
const formRef = ref(null);
|
const form = reactive({
|
id: null,
|
vehicleCode: "",
|
plateNumber: "",
|
fuelDate: "",
|
gunNo: "",
|
amount: null,
|
liters: null,
|
startMileage: null,
|
endMileage: null,
|
});
|
|
const rules = {
|
vehicleCode: [{ required: true, message: "请输入车辆编号", trigger: "blur" }],
|
plateNumber: [{ required: true, message: "请输入车牌号码", trigger: "blur" }],
|
fuelDate: [{ required: true, message: "请选择加油日期", trigger: "change" }],
|
gunNo: [{ required: true, message: "请输入油枪号", trigger: "blur" }],
|
amount: [{ required: true, message: "请输入金额", trigger: "blur" }],
|
liters: [{ required: true, message: "请输入升数", trigger: "blur" }],
|
startMileage: [{ required: true, message: "请输入起始里程", trigger: "blur" }],
|
endMileage: [{ required: true, message: "请输入结束里程", trigger: "blur" }],
|
};
|
|
// 重新计算油耗、平均油耗和异常预警
|
const recomputeTable = () => {
|
const records = rawRecords.value;
|
|
// 1. 先按车辆统计平均油耗
|
const stats = {};
|
records.forEach((r) => {
|
const distance = r.endMileage - r.startMileage;
|
if (distance <= 0 || !r.liters) return;
|
const cons = (r.liters / distance) * 100; // L/100km
|
if (!stats[r.vehicleCode]) {
|
stats[r.vehicleCode] = { totalCons: 0, count: 0 };
|
}
|
stats[r.vehicleCode].totalCons += cons;
|
stats[r.vehicleCode].count += 1;
|
});
|
|
const avgMap = {};
|
Object.keys(stats).forEach((key) => {
|
avgMap[key] = stats[key].totalCons / stats[key].count;
|
});
|
|
// 2. 按筛选条件过滤并补充计算字段
|
const filtered = records
|
.filter((r) => {
|
if (
|
searchForm.vehicleCode &&
|
!r.vehicleCode.includes(searchForm.vehicleCode.trim())
|
) {
|
return false;
|
}
|
if (Array.isArray(searchForm.dateRange) && searchForm.dateRange.length === 2) {
|
const [start, end] = searchForm.dateRange;
|
if (r.fuelDate < start || r.fuelDate > end) {
|
return false;
|
}
|
}
|
return true;
|
})
|
.map((r) => {
|
const distance = r.endMileage - r.startMileage;
|
const fuelConsumption =
|
distance > 0 && r.liters
|
? (r.liters / distance) * 100
|
: null;
|
const avgConsumption =
|
avgMap[r.vehicleCode] != null ? avgMap[r.vehicleCode] : null;
|
const isAbnormal =
|
avgConsumption != null &&
|
fuelConsumption != null &&
|
fuelConsumption > avgConsumption * 1.2;
|
|
return {
|
...r,
|
distance,
|
fuelConsumption,
|
avgConsumption,
|
isAbnormal,
|
};
|
});
|
|
tableData.value = filtered;
|
};
|
|
// 查询
|
const handleQuery = () => {
|
recomputeTable();
|
};
|
|
const resetSearch = () => {
|
searchForm.vehicleCode = "";
|
searchForm.dateRange = [];
|
recomputeTable();
|
};
|
|
// 行样式（异常高亮）
|
const tableRowClassName = ({ row }) => {
|
if (row.isAbnormal) {
|
return "row-abnormal";
|
}
|
return "";
|
};
|
|
// 新增
|
const openAdd = () => {
|
dialogTitle.value = "新增加油记录";
|
isEdit.value = false;
|
Object.assign(form, {
|
id: null,
|
vehicleCode: "",
|
plateNumber: "",
|
fuelDate: "",
|
gunNo: "",
|
amount: null,
|
liters: null,
|
startMileage: null,
|
endMileage: null,
|
});
|
dialogVisible.value = true;
|
};
|
|
// 编辑
|
const openEdit = (row) => {
|
dialogTitle.value = "编辑加油记录";
|
isEdit.value = true;
|
Object.assign(form, row);
|
dialogVisible.value = true;
|
};
|
|
// 保存
|
const handleSubmit = () => {
|
if (!formRef.value) return;
|
formRef.value.validate((valid) => {
|
if (!valid) return;
|
|
if (form.endMileage <= form.startMileage) {
|
ElMessage.warning("结束里程必须大于起始里程");
|
return;
|
}
|
|
if (isEdit.value) {
|
const index = rawRecords.value.findIndex((r) => r.id === form.id);
|
if (index !== -1) {
|
rawRecords.value[index] = { ...form };
|
}
|
ElMessage.success("加油记录已更新");
|
} else {
|
const newId = rawRecords.value.length
|
? Math.max(...rawRecords.value.map((r) => r.id)) + 1
|
: 1;
|
rawRecords.value.push({ ...form, id: newId });
|
ElMessage.success("加油记录已新增");
|
}
|
dialogVisible.value = false;
|
recomputeTable();
|
});
|
};
|
|
const handleCancel = () => {
|
dialogVisible.value = false;
|
};
|
|
// 删除
|
const removeRow = (row) => {
|
ElMessageBox.confirm("是否确认删除该加油记录？", "删除提示", {
|
confirmButtonText: "确认",
|
cancelButtonText: "取消",
|
type: "warning",
|
})
|
.then(() => {
|
rawRecords.value = rawRecords.value.filter((r) => r.id !== row.id);
|
recomputeTable();
|
ElMessage.success("删除成功");
|
})
|
.catch(() => {});
|
};
|
|
onMounted(() => {
|
recomputeTable();
|
});
|
</script>
|
|
<style scoped lang="scss">
|
.dialog-footer {
|
text-align: right;
|
}
|
|
::v-deep(.row-abnormal) {
|
background-color: #fff5f5;
|
}
|
</style>
|
