重要原则: 所有管理页面应保持一致的样式规范,确保用户体验的统一性。
参考页面: 用户管理(UserManagement.vue)是样式规范的参考标准。
一致性要求:
参考用户管理和调度录入的布局方式,页面应包含以下区域:
<template>
<div class="page-container">
<!-- 页面标题 -->
<h2>页面名称</h2>
<!-- 查询条件区域 -->
<div class="search-section">
<h3>查询条件</h3>
<el-form :model="queryForm" class="search-form">
<div class="search-row">
<el-form-item label="字段名">
<el-input v-model="queryForm.field" placeholder="请输入..." clearable></el-input>
</el-form-item>
<!-- 更多查询条件 -->
<div class="search-actions">
<el-button type="primary" @click="query">查询</el-button>
<el-button @click="reset">重置</el-button>
</div>
</div>
</el-form>
</div>
<!-- 操作按钮区域 -->
<div class="action-section">
<el-button type="primary" @click="add">新增</el-button>
<el-button type="danger" @click="deleteSelected" :disabled="selectedIds.length === 0">删除</el-button>
</div>
<!-- 表格区域 -->
<div class="table-container">
<el-table>...</el-table>
</div>
</div>
</template>
.page-container {
padding: 15px;
height: 100vh;
overflow-y: auto;
}
.page-container h2 {
margin: 0 0 15px 0;
font-size: 18px;
color: #303133;
}
.search-section {
background: #fff;
padding: 15px;
margin-bottom: 15px;
border-radius: 4px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
}
.search-section h3 {
margin: 0 0 12px 0;
font-size: 15px;
color: #606266;
}
.search-form {
display: flex;
flex-direction: column;
gap: 12px;
}
.search-row {
display: flex;
flex-wrap: wrap;
gap: 12px;
align-items: center;
}
.search-row .el-form-item {
margin-bottom: 0;
min-width: 200px;
}
.search-actions {
display: flex;
gap: 8px;
margin-left: auto;
}
.action-section {
margin-bottom: 15px;
display: flex;
gap: 8px;
}
.table-container {
background: #fff;
padding: 15px;
border-radius: 4px;
box-shadow: 0 2px 4px rgba(0, 0, 0, 0.1);
flex: 1;
display: flex;
flex-direction: column;
}
.pagination {
margin-top: 15px;
display: flex;
justify-content: center;
}
.dialog-footer {
display: flex;
justify-content: flex-end;
gap: 8px;
}
关键样式说明:
注意: 所有间距都应保持紧凑,避免过大的空白区域,确保界面紧凑、专业。
<el-table
:data="tableData"
stripe
border
size="default"
:header-cell-style="{ background: '#f5f7fa', color: '#303133', fontWeight: 'bold' }"
style="width: calc(100vw - 331px); height: calc(100vh - 395px);">
说明:
calc(100vw - 331px),确保表格宽度适应视口宽度,减去侧边栏和边距calc(100vh - 395px),确保表格高度适应视口高度,减去标题、查询条件、操作按钮和分页的高度size="default"确保表格使用紧凑模式计算公式:
const loading = ref(false)
const deleteLoading = ref(false)
const getUsers = async () => {
if (loading.value) return
loading.value = true
try {
const response = await request.get('/user/list', {
params: {
...queryForm,
page: currentPage.value,
pageSize: pageSize.value,
sortBy: sortMap.value.sortBy,
sortOrder: sortMap.value.sortOrder
}
})
userList.value = response.data.content
total.value = response.data.totalElements
} catch (error) {
console.error('获取用户列表失败:', error)
ElMessage.error('获取用户列表失败')
} finally {
loading.value = false
}
}
Loading状态应用:
<el-button type="primary" @click="getUsers" :loading="loading">查询</el-button>
<el-button @click="resetSearchForm" :loading="loading">重置</el-button>
<el-button type="danger" @click="deleteSelectedUsers" :disabled="selectedIds.length === 0" :loading="deleteLoading">删除</el-button>
<el-table v-loading="loading" :data="userList">...</el-table>
注意:
loading状态deleteLoading状态loading状态loading.value,防止重复点击try-finally确保loading状态一定会被恢复<el-table
:data="tableData"
stripe
border
size="default"
:header-cell-style="{ background: '#f5f7fa', color: '#303133', fontWeight: 'bold' }"
:height="tableHeight"
@selection-change="handleSelectionChange"
@sort-change="handleSortChange">
<el-table-column type="selection" width="55" fixed align="center"></el-table-column>
<el-table-column label="序号" width="60" fixed align="center">
<template #default="{ $index }">
{{ (currentPage - 1) * pageSize + $index + 1 }}
</template>
</el-table-column>
<el-table-column prop="name" label="用户名" width="100" sortable show-overflow-tooltip></el-table-column>
<el-table-column prop="loginId" label="账号" width="100" sortable show-overflow-tooltip></el-table-column>
<el-table-column prop="roleName" label="用户角色" width="150" sortable show-overflow-tooltip></el-table-column>
<el-table-column prop="weChatUserId" label="企业微信账号" width="120" sortable show-overflow-tooltip></el-table-column>
<el-table-column prop="recordStatusName" label="状态" width="80" sortable align="center">
<template #default="scope">
<el-tag :type="scope.row.recordStatus === 1 ? 'success' : 'info'" size="small">
{{ scope.row.recordStatusName }}
</el-tag>
</template>
</el-table-column>
<el-table-column prop="createTime" label="创建时间" width="160" sortable align="center" show-overflow-tooltip>
<template #default="scope">
{{ formatDateTime(scope.row.createTime) }}
</template>
</el-table-column>
<el-table-column prop="modifyTime" label="修改时间" width="160" sortable align="center" show-overflow-tooltip>
<template #default="scope">
{{ formatDateTime(scope.row.modifyTime) }}
</template>
</el-table-column>
<el-table-column label="操作" width="180" align="center" fixed="right">
<template #default="{ row }">
<el-tooltip content="编辑" placement="top">
<el-button type="primary" :icon="Edit" circle size="small" @click="edit(row)"></el-button>
</el-tooltip>
<el-tooltip content="删除" placement="top">
<el-button type="danger" :icon="Delete" circle size="small" @click="delete(row.id)"></el-button>
</el-tooltip>
</template>
</el-table-column>
重要说明:
(currentPage - 1) * pageSize + $index + 1,确保分页时序号连续操作列应使用图标按钮,而不是文字按钮,使界面更加简洁美观。
<el-table-column label="操作" width="180" align="center" fixed="right">
<template #default="{ row }">
<el-tooltip content="编辑" placement="top">
<el-button type="primary" :icon="Edit" circle size="small" @click="edit(row)"></el-button>
</el-tooltip>
<el-tooltip content="删除" placement="top">
<el-button type="danger" :icon="Delete" circle size="small" @click="delete(row.id)"></el-button>
</el-tooltip>
</template>
</el-table-column>
import { Edit, Delete, User, Lock, Search } from '@element-plus/icons-vue'
export default {
components: {
Edit,
Delete,
User,
Lock,
Search
}
}
| 图标 | 名称 | 用途 |
|---|---|---|
Edit |
编辑 | 修改数据 |
Delete |
删除 | 删除数据 |
User |
用户 | 用户/人员管理 |
Lock |
锁定 | 锁定/重置密码 |
Search |
搜索 | 搜索/查询 |
Plus |
加号 | 新增 |
View |
查看 | 查看详情 |
Download |
下载 | 下载文件 |
Upload |
上传 | 上传文件 |
Refresh |
刷新 | 刷新数据 |
type:按钮类型,如primary、success、warning、danger、info:icon:图标组件,如:icon="Edit"circle:圆形按钮size:按钮尺寸,推荐使用small@click:点击事件使用el-tooltip为图标按钮提供功能提示:
<el-tooltip content="编辑" placement="top">
<el-button type="primary" :icon="Edit" circle size="small" @click="edit(row)"></el-button>
</el-tooltip>
Tooltip属性:
content:提示文本placement:提示位置,可选值:top、bottom、left、rightconst formatDateTime = (dateStr) => {
if (!dateStr) return ''
const date = new Date(dateStr)
const year = date.getFullYear()
const month = String(date.getMonth() + 1).padStart(2, '0')
const day = String(date.getDate()).padStart(2, '0')
const hours = String(date.getHours()).padStart(2, '0')
const minutes = String(date.getMinutes()).padStart(2, '0')
const seconds = String(date.getSeconds()).padStart(2, '0')
return `${year}-${month}-${day} ${hours}:${minutes}:${seconds}`
}
所有删除操作都必须显示确认对话框,防止误操作。
const deleteUser = async (id) => {
try {
await ElMessageBox.confirm(
'确定要删除该用户吗?删除后用户及其角色关联将被永久删除,不可恢复。',
'删除确认',
{
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}
)
await request.delete(`/user/delete/${id}`)
ElMessage.success('删除成功')
getUsers()
} catch (error) {
if (error !== 'cancel') {
console.error('删除用户失败:', error)
ElMessage.error('删除用户失败')
}
}
}
const deleteSelectedUsers = async () => {
if (selectedUserIds.value.length === 0) {
return
}
try {
await ElMessageBox.confirm(
`确定要删除选中的 ${selectedUserIds.value.length} 个用户吗?删除后用户及其角色关联将被永久删除,不可恢复。`,
'删除确认',
{
confirmButtonText: '确定',
cancelButtonText: '取消',
type: 'warning'
}
)
await request.delete('/user/delete', {
data: selectedUserIds.value
})
ElMessage.success('删除成功')
selectedUserIds.value = []
getUsers()
} catch (error) {
if (error !== 'cancel') {
console.error('删除用户失败:', error)
ElMessage.error('删除用户失败')
}
}
}
删除主表数据时,必须先删除关联表数据。
@Transactional
public void deleteUsers(List<String> userIds) {
for (String userId : userIds) {
// 先删除关联表数据
sysUserRoleRepository.deleteByUserId(userId);
// 再删除主表数据
userRepository.deleteById(userId);
}
}
const handleSortChange = ({ prop, order }) => {
if (order) {
queryForm.value.sortBy = prop
queryForm.value.sortOrder = order === 'ascending' ? 'asc' : 'desc'
} else {
queryForm.value.sortBy = null
queryForm.value.sortOrder = null
}
getUsers()
}
public Page<User> queryUsers(UserQuery query, Pageable pageable) {
Sort sort = pageable.getSort();
if (query.getSortBy() != null && query.getSortOrder() != null) {
sort = Sort.by(
"asc".equalsIgnoreCase(query.getSortOrder()) ? Sort.Direction.ASC : Sort.Direction.DESC,
query.getSortBy()
);
}
return userRepository.findAll(pageable.withSort(sort));
}
重要原则: 所有API请求必须统一处理验证失败,确保用户在token失效或权限不足时能够及时跳转到登录页面。
在src/utils/request.js中配置axios请求和响应拦截器,统一处理认证和错误。
import axios from 'axios'
/**
* 创建axios实例
*/
const request = axios.create({
baseURL: '/api',
timeout: 30000
})
/**
* 请求拦截器 - 自动添加token
*/
request.interceptors.request.use(
config => {
const token = localStorage.getItem('token')
if (token) {
config.headers['Authorization'] = `Bearer ${token}`
}
return config
},
error => {
console.error('请求错误:', error)
return Promise.reject(error)
}
)
/**
* 响应拦截器 - 处理token过期和验证失败
*/
request.interceptors.response.use(
response => {
return response
},
error => {
if (error.response) {
switch (error.response.status) {
case 401:
console.error('未授权,请重新登录')
localStorage.removeItem('token')
localStorage.removeItem('userInfo')
window.location.href = '/login'
break
case 403:
console.error('没有权限访问,请重新登录')
localStorage.removeItem('token')
localStorage.removeItem('userInfo')
window.location.href = '/login'
break
case 404:
console.error('请求的资源不存在')
break
case 500:
console.error('服务器错误')
break
default:
console.error('请求失败:', error.response.status)
}
} else if (error.request) {
console.error('网络错误,请检查网络连接')
} else {
console.error('请求配置错误:', error.message)
}
return Promise.reject(error)
}
)
export default request
关键说明:
在src/router/index.js中配置路由守卫,在路由跳转前检查登录状态。
// 路由守卫,检查登录状态
router.beforeEach((to, from, next) => {
// 登录页面不需要验证
if (to.name === 'login') {
next()
return
}
// 检查是否有登录令牌
const token = localStorage.getItem('token')
if (!token) {
// 未登录,重定向到登录页面
localStorage.removeItem('userInfo')
next({ name: 'login' })
return
}
// 已登录,继续访问
next()
})
关键说明:
完整的验证失败处理流程如下:
用户访问需要认证的页面
↓
路由守卫检查token
↓
没有token? → 清除userInfo,跳转到登录页面
↓
有token? → 继续访问
↓
发送API请求(自动添加token)
↓
服务器验证失败(401/403)
↓
响应拦截器捕获错误
↓
清除token和userInfo
↓
跳转到登录页面
↓
用户重新登录
↓
获取新的token
↓
正常访问系统
window.location.href而不是router.push,确保页面强制刷新所有API请求都应该使用统一的request工具,自动处理认证和错误。
import request from '@/utils/request'
export const getUsers = (params) => {
return request.get('/user/list', { params })
}
export const createUser = (data) => {
return request.post('/user/create', data)
}
export const deleteUser = (data) => {
return request.delete('/user/delete', { data })
}
所有查询DTO必须继承BaseQueryDTO,以统一管理分页和排序参数。
package com.lianda.backend.dto;
import lombok.Data;
import lombok.EqualsAndHashCode;
import lombok.ToString;
/**
* 调度录入查询条件DTO
*/
@Data
@EqualsAndHashCode(callSuper = true)
@ToString(callSuper = true)
public class DispatcherQueryDTO extends BaseQueryDTO {
/**
* 计划时间-开始
*/
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
private Date workTimeStart;
/**
* 计划时间-结束
*/
@JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
private Date workTimeEnd;
/**
* 调度单号(模糊查询)
*/
private String no;
// 其他查询条件...
}
BaseQueryDTO基类定义:
package com.lianda.backend.dto;
/**
* 查询DTO基类,包含通用的分页和排序属性
*/
public class BaseQueryDTO {
private Integer page = 1; // 页码,默认第一页
private Integer pageSize = 20; // 每页大小,默认20条
private String sortBy; // 排序列名
private String sortOrder; // 排序方向,ASC或DESC
// getters and setters...
}
Controller接口应接收完整的查询DTO对象,而不是单独的分页参数。
错误示例:
@PostMapping("/list")
public PageResponse<DispatcherListDTO> list(
@RequestBody DispatcherQueryDTO query,
@RequestParam(defaultValue = "1") int page,
@RequestParam(defaultValue = "20") int pageSize,
@RequestParam(required = false) String sortBy,
@RequestParam(required = false) String sortOrder) {
// ...
}
正确示例:
@PostMapping("/list")
public PageResponse<DispatcherListDTO> list(@RequestBody DispatcherQueryDTO query) {
Sort sort = Sort.by(Sort.Direction.DESC, "workTime");
if (query.getSortBy() != null && !query.getSortBy().isEmpty()) {
sort = Sort.by(
"asc".equalsIgnoreCase(query.getSortOrder()) ? Sort.Direction.ASC : Sort.Direction.DESC,
query.getSortBy()
);
}
Pageable pageable = PageRequest.of(query.getPage() - 1, query.getPageSize(), sort);
Page<DispatcherListDTO> result = dispatcherService.queryDispatcherList(query, pageable);
return new PageResponse<>(
result.getContent(),
result.getTotalElements(),
result.getNumber() + 1,
result.getSize()
);
}
前端需要维护分页和排序状态,并在查询时传递给后端。
export default {
data() {
return {
// 分页参数
currentPage: 1,
pageSize: 20,
total: 0,
// 排序参数
sortMap: {
sortBy: '',
sortOrder: ''
},
// 查询条件
searchForm: {
// ...
},
// 数据列表
dataList: []
}
},
methods: {
/**
* 获取数据列表
*/
async getDataList() {
this.loading = true
try {
const params = {
page: this.currentPage,
pageSize: this.pageSize,
sortBy: this.sortMap.sortBy,
sortOrder: this.sortMap.sortOrder,
...this.searchForm // 展开查询条件
}
const response = await request.post('/api/list', params)
this.dataList = response.data.content || []
this.total = response.data.totalElements || 0
} catch (error) {
console.error('查询失败:', error)
this.$message.error('查询失败')
} finally {
this.loading = false
}
},
/**
* 处理排序变化
*/
handleSortChange({ prop, order }) {
if (prop && order) {
this.sortMap = {
sortBy: prop,
sortOrder: order === 'ascending' ? 'ASC' : (order === 'descending' ? 'DESC' : null)
}
} else {
this.sortMap = {
sortBy: '',
sortOrder: ''
}
}
this.getDataList()
},
/**
* 处理页码变化
*/
handleCurrentChange(page) {
this.currentPage = page
this.getDataList()
},
/**
* 处理每页大小变化
*/
handleSizeChange(size) {
this.pageSize = size
this.currentPage = 1
this.getDataList()
}
}
}
<el-table
:data="dataList"
v-loading="loading"
@sort-change="handleSortChange"
border
stripe
size="small">
<el-table-column
prop="no"
label="调度单号"
width="150"
sortable>
</el-table-column>
<!-- 其他列 -->
</el-table>
<el-pagination
@current-change="handleCurrentChange"
@size-change="handleSizeChange"
:current-page="currentPage"
:page-sizes="[10, 20, 50, 100]"
:page-size="pageSize"
:total="total"
layout="total, sizes, prev, pager, next, jumper">
</el-pagination>
try {
await request.post('/api/endpoint', data)
ElMessage.success('操作成功')
} catch (error) {
console.error('操作失败:', error)
ElMessage.error('操作失败,请稍后重试')
}
<el-form :model="form" :rules="rules" ref="formRef">
<el-form-item label="用户名" prop="name">
<el-input v-model="form.name" placeholder="请输入用户名"></el-input>
</el-form-item>
</el-form>
<script>
const rules = {
name: [
{ required: true, message: '请输入用户名', trigger: 'blur' },
{ min: 2, max: 50, message: '长度在 2 到 50 个字符', trigger: 'blur' }
]
}
</script>
public class UserCreateDTO {
@NotBlank(message = "用户名不能为空")
@Size(min = 2, max = 50, message = "用户名长度必须在2-50之间")
private String name;
@NotBlank(message = "账号不能为空")
private String loginId;
@NotBlank(message = "密码不能为空")
@Size(min = 6, message = "密码长度不能少于6位")
private String password;
}
UserManagement.vuegetUsers、handleSortChangeuserList、selectedIdsMAX_PAGE_SIZE/**
* 获取用户列表
*/
const getUsers = async () => {
// 实现代码
}
/**
* 处理排序变化
* @param {Object} param - 排序参数
* @param {String} param.prop - 排序字段
* @param {String} param.order - 排序方向
*/
const handleSortChange = ({ prop, order }) => {
// 实现代码
}
import { debounce } from 'lodash-es'
const search = debounce(() => {
getUsers()
}, 300)
对于大量数据,使用虚拟滚动提高性能。
<el-table
:data="tableData"
height="600"
v-loading="loading">
</el-table>
使用Vue的插值表达式,避免直接使用v-html。
<!-- 正确 -->
<div>{{ user.name }}</div>
<!-- 错误 -->
<div v-html="user.name"></div>
所有POST、PUT、DELETE请求都应该携带CSRF token。
import request from '@/utils/request'
request.interceptors.request.use(config => {
const token = localStorage.getItem('csrf_token')
if (token) {
config.headers['X-CSRF-TOKEN'] = token
}
return config
})
<nav>...</nav>
<main>
<h1>页面标题</h1>
<section class="search-section">...</section>
<section class="table-section">...</section>
</main>
<footer>...</footer>
确保所有交互元素都可以通过键盘访问。
<el-button @click="handleClick" @keyup.enter="handleClick">
点击
</el-button>
对于选项数量较多的下拉选择框(如船公司、代理公司、港口等),应使用可搜索的下拉框,并实现远程搜索和分页加载功能。
<el-form-item label="船公司">
<el-select
v-model="searchForm.shipownerId"
placeholder="请选择"
style="width: 180px"
clearable
filterable
:loading="shipCompanyLoading"
@visible-change="handleShipCompanyVisibleChange"
popper-class="ship-company-select-dropdown"
>
<el-option
v-for="company in shipCompanyList"
:key="company.companyId"
:label="company.companyName"
:value="company.companyId">
</el-option>
</el-select>
</el-form-item>
/* 船公司下拉框样式 */
.ship-company-select-dropdown {
max-height: 300px;
overflow-y: auto;
}
.ship-company-select-dropdown .el-select-dropdown__wrap {
max-height: 300px;
overflow-y: auto;
}
data() {
return {
searchForm: {
shipownerId: ''
},
shipCompanyList: [],
shipCompanyPage: 1,
shipCompanyPageSize: 10,
shipCompanyTotal: 0,
shipCompanyLoading: false,
shipCompanyHasMore: true
}
}
methods: {
getShipCompanyList(isLoadMore = false) {
this.shipCompanyLoading = true;
this.$axios.get('/api/ship-company/list', {
params: {
page: this.shipCompanyPage,
pageSize: this.shipCompanyPageSize
}
})
.then(response => {
const newCompanies = response.data.content || [];
if (isLoadMore) {
this.shipCompanyList = [...this.shipCompanyList, ...newCompanies];
} else {
this.shipCompanyList = newCompanies;
}
this.shipCompanyTotal = response.data.totalElements || 0;
this.shipCompanyHasMore = this.shipCompanyList.length < this.shipCompanyTotal;
})
.catch(error => {
console.error('获取船公司列表失败:', error);
this.$message.error('获取船公司列表失败,请稍后重试');
})
.finally(() => {
this.shipCompanyLoading = false;
});
},
handleShipCompanyVisibleChange(visible) {
if (visible) {
this.shipCompanyPage = 1;
this.getShipCompanyList();
this.addShipCompanyScrollListener();
} else {
this.removeShipCompanyScrollListener();
}
},
handleShipCompanyScroll(event) {
const { target } = event;
const scrollBottom = target.scrollHeight - target.scrollTop - target.clientHeight;
if (scrollBottom < 10 && this.shipCompanyHasMore && !this.shipCompanyLoading) {
this.shipCompanyPage++;
this.getShipCompanyList(true);
}
},
addShipCompanyScrollListener() {
this.$nextTick(() => {
const dropdown = document.querySelector('.ship-company-select-dropdown');
if (dropdown) {
const dropdownWrap = dropdown.querySelector('.el-select-dropdown__wrap');
if (dropdownWrap) {
dropdownWrap.addEventListener('scroll', this.handleShipCompanyScroll);
}
}
});
},
removeShipCompanyScrollListener() {
const dropdown = document.querySelector('.ship-company-select-dropdown');
if (dropdown) {
const dropdownWrap = dropdown.querySelector('.el-select-dropdown__wrap');
if (dropdownWrap) {
dropdownWrap.removeEventListener('scroll', this.handleShipCompanyScroll);
}
}
}
}
beforeUnmount() {
this.removeShipCompanyScrollListener();
}
### 11.3 后端API规范
#### 11.3.1 Controller实现
```java
@GetMapping("/list")
public Page<ShippingCompanyDTO> list(
@RequestParam(required = false) String companyName,
@RequestParam(defaultValue = "1") int page,
@RequestParam(defaultValue = "10") int pageSize
) {
Pageable pageable = PageRequest.of(page - 1, pageSize);
return commonDataService.searchShippingCompanies(companyName, pageable);
}
@Service
public class CommonDataService {
@Autowired
private BusCustomerCompanyRepository busCustomerCompanyRepository;
@Autowired
private BusCustomerCustomerTypeRepository busCustomerCustomerTypeRepository;
public Page<ShippingCompanyDTO> searchShippingCompanies(String companyName, Pageable pageable) {
// 查询CustomerType=2的所有客户ID
List<BusCustomerCustomerType> customerTypeRecords = busCustomerCustomerTypeRepository.findByCustomerType(2);
Set<String> shippingCompanyCustomerIds = customerTypeRecords.stream()
.map(BusCustomerCustomerType::getCustomerId)
.collect(Collectors.toSet());
// 查询对应的客户公司信息(支持模糊搜索和分页)
Page<BusCustomerCompany> companyPage;
if (companyName != null && !companyName.isEmpty()) {
companyPage = busCustomerCompanyRepository.findByNameContainingAndRecordStatus(
companyName, 1, pageable);
} else {
Sort sort = Sort.by(Sort.Direction.ASC, "name");
Pageable sortedPageable = PageRequest.of(pageable.getPageNumber(), pageable.getPageSize(), sort);
companyPage = busCustomerCompanyRepository.findByRecordStatus(1, sortedPageable);
}
// 过滤出船公司类型的数据并转换为DTO
List<ShippingCompanyDTO> filteredCompanies = companyPage.getContent().stream()
.filter(company -> shippingCompanyCustomerIds.contains(company.getCustomerCompanyId()))
.map(company -> new ShippingCompanyDTO(
company.getCustomerCompanyId(),
company.getName(),
company.getContact(),
company.getTel(),
company.getMobile()))
.collect(Collectors.toList());
// 创建新的Page对象
return new PageImpl<>(
filteredCompanies,
pageable,
companyPage.getTotalElements()
);
}
}
@Repository
public interface BusCustomerCompanyRepository extends JpaRepository<BusCustomerCompany, String> {
/**
* 根据名称和记录状态查找客户公司(分页)
*/
Page<BusCustomerCompany> findByNameContainingAndRecordStatus(String name, Integer recordStatus, Pageable pageable);
/**
* 根据记录状态查找客户公司(分页)
*/
Page<BusCustomerCompany> findByRecordStatus(Integer recordStatus, Pageable pageable);
}
@Repository
public interface BusCustomerCustomerTypeRepository extends JpaRepository<BusCustomerCustomerType, String> {
/**
* 根据客户类型查找记录
*/
List<BusCustomerCustomerType> findByCustomerType(Integer customerType);
}
Bus_CustomerCompany表:客户公司表
Bus_Customer_CustomerType表:客户类型关联表
船公司查询需要关联两个表:
| 属性 | 说明 |
|---|---|
| filterable | 启用本地过滤功能 |
| remote | 启用远程搜索 |
| remote-method | 远程搜索方法,当用户输入时触发 |
| loading | 加载状态,用于显示加载动画 |
| visible-change | 下拉框显示/隐藏时触发 |
| scroll | 下拉列表滚动时触发,用于实现瀑布加载 |
?.)和默认值处理可能的字段缺失重要:船公司下拉框必须显示BusinessCode字段,而非Name字段。
Bus_CustomerCompanyBusiness表:客户公司业务表
Bus_CustomerCompany表:客户公司表
<el-option
v-for="company in shipCompanyList"
:key="company.companyId"
:label="company.businessCode"
:value="company.companyId">
</el-option>
注意:
:label必须绑定到company.businessCodecompany.companyName作为显示字段public class ShippingCompanyDTO {
private String companyId;
private String companyName;
private String businessCode; // 必须包含此字段
private String contact;
private String tel;
private String mobile;
public String getBusinessCode() {
return businessCode;
}
public void setBusinessCode(String businessCode) {
this.businessCode = businessCode;
}
}
// 查询时必须包含BusinessCode字段
shippingCompanies = jdbcTemplate.query(sql.toString(),
(rs, rowNum) -> new ShippingCompanyDTO(
rs.getString("CustomerCompanyBusinessId"),
rs.getString("Name"),
rs.getString("BusinessCode"), // 必须包含BusinessCode
null,
null
));