HEX
Server: Apache/2.4.63 (Unix)
System: Linux Synopilou92 4.4.302+ #72806 SMP Mon Jul 21 23:16:00 CST 2025 x86_64
User: pilou92 (1026)
PHP: 8.0.30
Disabled: NONE
Upload Files
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
$$;