如何处理使用useTable钩子而不是useMany从API的两个或多个表中获取多条记录?在幕后,useTable使用useList.假设我有来自供应商的客户和订单表.有没有办法告诉useTable从这两个表中获取记录?
type Customers = {
id: number;
customer_name: string;
customer_contact: string;
};
type ServiceType = "Wash" | "Dry" | "Fold" | "Full";
type ServiceStatus = "Undone" | "Washing" | "Drying" | "Folding" | "Done";
type Orders = {
id: number;
customerId: number;
orderDate: Date;
orderLoad: number;
orderWeight: number;
serviceType: ServiceType;
orderSoap: number;
orderFabcon: number;
orderBleach: number;
orderNote: string;
orderStatus: ServiceStatus;
orderIsClaimed: boolean;
inventoryId: number | null;
payableId: number | null;
};
const {
refineCore: {
tableQueryResult: { data: orders },
},
previousPage,
nextPage,
getCanPreviousPage,
getCanNextPage,
getHeaderGroups,
getRowModel,
getColumn,
getAllColumns,
} = useTable({
columns,
onSortingChange: setSorting,
onColumnFiltersChange: setColumnFilters,
getCoreRowModel: getCoreRowModel(),
getPaginationRowModel: getPaginationRowModel(),
getSortedRowModel: getSortedRowModel(),
getFilteredRowModel: getFilteredRowModel(),
onColumnVisibilityChange: setColumnVisibility,
onRowSelectionChange: setRowSelection,
state: {
sorting,
columnFilters,
columnVisibility,
rowSelection,
},
});
以下是供应商:
<Refine
dataProvider={dataProvider(supabaseClient)}
liveProvider={liveProvider(supabaseClient)}
authProvider={authProvider}
routerProvider={routerBindings}
resources={[
{
name: "orders",
list: "/orders",
create: "/orders/create",
edit: "/orders/edit/:id",
show: "/orders/show/:id",
meta: {
canDelete: true,
},
},
{
name: "customers",
list: "/customers",
create: "/customers/create",
edit: "/customers/edit/:id",
show: "/customers/show/:id",
meta: {
canDelete: true,
},
},
{
name: "inventory",
list: "/inventory",
show: "/inventory/show/:id",
meta: {
canDelete: true,
},
},
]}
options={{
syncWithLocation: true,
warnWhenUnsavedChanges: true,
useNewQueryKeys: true,
projectId: "GmM62Q-BMA8wv-2ddnfk",
}}
>
</Refine>