File: /volume1/@appstore/SynologyPhotos/etc/sql/47.sql
CREATE OR REPLACE FUNCTION public.display_item_type_order (item_type integer)
RETURNS integer
LANGUAGE plpgsql
IMMUTABLE
CALLED ON NULL INPUT
SECURITY INVOKER
COST 1
AS $$
DECLARE
display_order integer;
order_map integer[];
BEGIN
-- kPhoto = 0, order 0
-- kVideo = 1, order 4
-- kBurst = 2, order 6
-- kLive = 3, order 1
-- kPhoto360 = 4, order 3
-- kVideo360 = 5, order 5
-- kMotionPhoto = 6, order 2
SELECT ARRAY[0, 4, 6, 1, 3, 5, 2] INTO order_map;
display_order = order_map[item_type + 1];
RETURN display_order;
END
$$;