SQLize | PHPize | SQLtest

-- FUNCTION: BusinessBase.F_PR_CardPurchases(integer, integer) -- DROP FUNCTION IF EXISTS "BusinessBase"."F_PR_CardPurchases"(integer, integer); CREATE OR REPLACE FUNCTION "BusinessBase"."F_PR_CardPurchases"( "UserId" integer, -- ID пользователя (для аудита) "CardId" integer -- ID карты лояльности ) RETURNS TABLE ( "Sale.Date" timestamp without time zone, -- Дата покупки (TiSaleDate) "Sale.Amount" numeric(24,4), -- Сумма покупки (TiSaleAmount) "Sale.DiscountedAmount" bigint, -- Сумма со скидкой (TiSaleAmountDiscounted) "Status.Id" integer, -- ID статуса (TiStatusId) "Transaction.Code" text, -- Код транзакции (TiCode) "Contact.Id" text, -- ID контакта (TiContactId) "Store.CityId" integer, -- ID города магазина (TiStoreCityId) "Store.AddressId" integer, -- ID адреса магазина (TiStoreAddressId) "Loyalty.CardId" integer, -- ID карты лояльности (TiLoyaltyCardId) "Store.Id" integer -- ID магазина (TiStoreId) ) LANGUAGE 'plpgsql' COST 100 VOLATILE PARALLEL UNSAFE ROWS 1000 AS $BODY$ BEGIN RETURN QUERY SELECT pur."TiSaleDate", pur."TiSaleAmount", pur."TiSaleAmountDiscounted", pur."TiStatusId", pur."TiCode", pur."TiContactId", pur."TiStoreCityId", pur."TiStoreAddressId", pur."TiLoyaltyCardId", pur."TiStoreId" FROM "BusinessBase"."Pokupki_po_karte" pur WHERE pur."TiLoyaltyCardId" = "F_PR_CardPurchases"."CardId" ORDER BY pur."TiSaleDate" DESC; END; $BODY$; ALTER FUNCTION "BusinessBase"."F_PR_CardPurchases"(integer, integer) OWNER TO postgres; GRANT EXECUTE ON FUNCTION "BusinessBase"."F_PR_CardPurchases"(integer, integer) TO PUBLIC; GRANT EXECUTE ON FUNCTION "BusinessBase"."F_PR_CardPurchases"(integer, integer) TO "a.nosova"; GRANT EXECUTE ON FUNCTION "BusinessBase"."F_PR_CardPurchases"(integer, integer) TO "e.tarnovetskaya";