Skip to content

表头过滤器

  1. 配置表头行过滤器
vue
<template>
	<VxeGrid ref="grid" class="config-table" v-bind="gridOptions" v-on="gridEvents" />
</template>

<script setup lang="tsx">
import { onMounted, reactive, useTemplateRef } from 'vue';
import { VxeGrid, mergeGridProps } from '@erp/biz';
import { dayjs } from '@erp/common';
import data from './data.json';
import type { VxeGridInstance, VxeGridListeners } from '@erp/biz';

/**
 * 引用template模板
 */
const gridRef = useTemplateRef<VxeGridInstance>('grid');
const options = [];
/**
 * 表格 grid 配置
 */
const gridOptions = reactive(
	mergeGridProps({
		height: 360,
		columnConfig: {
			width: 160,
		},
		filterConfig: {
			mode: 'header',
		},
		toolbarConfig: {
			buttons: [
				{
					label: '清除筛选条件',
					code: 'clearFilter',
					type: 'primary',
				},
			],
		},
		columns: [
			{ field: 'checkbox', type: 'checkbox', width: 55, align: 'center', headerAlign: 'center', fixed: 'left' },
			{
				type: 'seq',
				title: '#',
				width: 55,
				align: 'center',
				headerAlign: 'center',
				fixed: 'left',
			},
			{
				field: 'id',
				title: '内部订单号',
				sortable: true,
				maxWidth: 200,
				minWidth: 100,
				filterRender: {
					name: 'Input',
					compareOperator: 'in',
					props: {
						type: 'select',
					},
				},
			},
			{
				field: 'payment_fee',
				title: '已付金额',
				filterRender: {
					name: 'Input',
					compareOperator: 'between',
					props: {
						type: 'range-number',
						precision: 2,
						placeholder: ['最低', '最高'],
						hideButton: true,
					},
				},
			},
			{
				field: 'buyer_account',
				title: '买家账号+店铺',
				filterRender: {
					name: 'Input',
					compareOperator: 'include',
					props: {
						type: 'text',
					},
				},
			},
			{
				field: 'order_time',
				title: '订单日期',
				width: 260,
				filterRender: {
					name: 'Input',
					compareOperator: 'between',
					props: {
						type: 'date',
					},
				},
				filterMethod({ cellValue, value }) {
					if (value[0] && value[1]) {
						return dayjs(cellValue).isBetween(value[0], value[1]);
					} else if (value[0]) {
						return dayjs(cellValue).isAfter(value[0]);
					} else if (value[1]) {
						return dayjs(cellValue).isBefore(value[1]);
					}
					return true;
				},
			},
			{
				field: 'order_status',
				title: '状态',
				width: 220,
			},
			{
				field: 'order_tags',
				title: '标记',
			},
			{ field: 'pay_time', title: '付款时间', width: 170 },
			{ field: 'meet', title: '应付+运费' },

			{ field: 'remaining_amount', title: '剩余支付金额' },

			{ field: 'client_remark', title: '客户留言' },
			{ field: 'customer_notes', title: '卖家备注' },
			{ field: 'offline_remark', title: '线下备注' },
			{ field: 'expresses', title: '快递公司' },
			{ field: 'receiver_address', title: '收货地址' },
			{ field: 'plan_ship_time', title: '计划发货日期' },
			{ field: 'order_sale', title: '业务员' },
			{ field: 'confirm_time', title: '确认收货时间' },
			{ field: 'remaining_delivery_time', title: '剩余发货时间' },
			{ field: 'order_source', title: '订单来源' },
		],
		data: [],
	}),
);

/**
 * 监听 grid 事件
 */
const gridEvents: VxeGridListeners = {
	pageChange({ pageSize, current }) {
		gridOptions.pagerConfig!.current = current;
		gridOptions.pagerConfig!.pageSize = pageSize;
		handlePageData();
		console.log('pageChange >>', pageSize, current);
	},
	toolbarButtonClick(event) {
		if (event.code === 'clearFilter') {
			gridRef.value?.clearFilter();
		}
	},
	toolbarToolClick(event) {
		console.log('toolbarFoolClick >>', event);
	},
	currentChange(event) {
		console.log('currentChange >>', event);
	},
	menuClick(event) {
		console.log('menuClick >>', event);
	},
	copy(event) {
		// console.log('event >>', event);
		// debugger;
		// clipboard(JSON.stringify(event.row));
	},
	sortChange(params) {
		console.log('sortChange >>', params);
	},
};

const handlePageData = () => {
	gridOptions.loading = true;
	setTimeout(() => {
		const list = data.data.list;
		gridOptions.data = list;
		gridOptions.loading = false;
		gridOptions.pagerConfig!.total = data.data.total;
		list.forEach(el => {
			options.push({
				label: String(el.id),
				value: el.id,
			});
		});
		/**
		 * 设置数据源
		 */
		gridRef.value.setFilter('id', options);
		gridRef.value.setFilterValue(
			'id',
			options.slice(0, 2).map(v => v.value),
		);
		// selectProps.options = options;
	}, 500);
};

onMounted(() => {
	handlePageData();
});
</script>

<style scoped lang="less">
.config-table {
	:deep(.cell-btns) {
		button + button {
			margin-left: -12px;
		}
	}
}
</style>

基于 MIT 许可发布