The Postgres development platform. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.
TypeScript aialternativeauthdatabasedenoembeddingsexamplefirebasenextjsoauth2pgvectorpostgispostgrespostgresqlpostgrestrealtimesupabasevectorswebsockets
import { ArrowDownNarrowWideIcon, ArrowDownWideNarrowIcon } from 'lucide-react'
import {
Button,
DropdownMenu,
DropdownMenuContent,
DropdownMenuRadioGroup,
DropdownMenuRadioItem,
DropdownMenuSub,
DropdownMenuSubContent,
DropdownMenuSubTrigger,
DropdownMenuTrigger,
} from 'ui'
import { ButtonTooltip } from '@/components/ui/ButtonTooltip'
interface SortDropdownProps {
specificFilterColumn: string
sortColumn: string
sortOrder: string
sortByValue: string
showSortByEmail: boolean
showSortByPhone: boolean
setSortByValue: (value: string) => void
improvedSearchEnabled: boolean
}
/** [Joshen] To refactor to use the SortDropdown component in components/ui */
export const SortDropdown = ({
specificFilterColumn,
sortColumn,
sortOrder,
sortByValue,
showSortByEmail,
showSortByPhone,
setSortByValue,
improvedSearchEnabled = false,
}: SortDropdownProps) => {
if (specificFilterColumn !== 'freeform' && !improvedSearchEnabled) {
return (
<ButtonTooltip
disabled
variant="default"
icon={<ArrowDownNarrowWideIcon />}
tooltip={{
content: {
side: 'bottom',
className: 'w-80 text-center',
text: (
<>
Sorting cannot be changed when searching on a specific column. If you'd like to sort
on other columns, change the search to{' '}
<span className="text-warning">unified search</span> from the search dropdown.
</>
),
},
}}
>
Sorted by user ID
</ButtonTooltip>
)
}
return (
<DropdownMenu>
<DropdownMenuTrigger asChild>
<Button
icon={sortOrder === 'desc' ? <ArrowDownWideNarrowIcon /> : <ArrowDownNarrowWideIcon />}
>
Sorted by {sortColumn === 'id' ? 'user ID' : sortColumn.replaceAll('_', ' ')}
</Button>
</DropdownMenuTrigger>
<DropdownMenuContent className="w-44" align="start">
<DropdownMenuRadioGroup value={sortByValue} onValueChange={setSortByValue}>
<DropdownMenuSub>
<DropdownMenuSubTrigger>Sort by user ID</DropdownMenuSubTrigger>
<DropdownMenuSubContent>
<DropdownMenuRadioItem value="id:asc">Ascending</DropdownMenuRadioItem>
<DropdownMenuRadioItem value="id:desc">Descending</DropdownMenuRadioItem>
</DropdownMenuSubContent>
</DropdownMenuSub>
<DropdownMenuSub>
<DropdownMenuSubTrigger>Sort by created at</DropdownMenuSubTrigger>
<DropdownMenuSubContent>
<DropdownMenuRadioItem value="created_at:asc">Ascending</DropdownMenuRadioItem>
<DropdownMenuRadioItem value="created_at:desc">Descending</DropdownMenuRadioItem>
</DropdownMenuSubContent>
</DropdownMenuSub>
<DropdownMenuSub>
<DropdownMenuSubTrigger>Sort by last sign in at</DropdownMenuSubTrigger>
<DropdownMenuSubContent>
<DropdownMenuRadioItem value="last_sign_in_at:asc">Ascending</DropdownMenuRadioItem>
<DropdownMenuRadioItem value="last_sign_in_at:desc">Descending</DropdownMenuRadioItem>
</DropdownMenuSubContent>
</DropdownMenuSub>
{showSortByEmail && (
<DropdownMenuSub>
<DropdownMenuSubTrigger>Sort by email</DropdownMenuSubTrigger>
<DropdownMenuSubContent>
<DropdownMenuRadioItem value="email:asc">Ascending</DropdownMenuRadioItem>
<DropdownMenuRadioItem value="email:desc">Descending</DropdownMenuRadioItem>
</DropdownMenuSubContent>
</DropdownMenuSub>
)}
{showSortByPhone && (
<DropdownMenuSub>
<DropdownMenuSubTrigger>Sort by phone</DropdownMenuSubTrigger>
<DropdownMenuSubContent>
<DropdownMenuRadioItem value="phone:asc">Ascending</DropdownMenuRadioItem>
<DropdownMenuRadioItem value="phone:desc">Descending</DropdownMenuRadioItem>
</DropdownMenuSubContent>
</DropdownMenuSub>
)}
</DropdownMenuRadioGroup>
</DropdownMenuContent>
</DropdownMenu>
)
}