CREATE OR REPLACE FUNCTION "public"."GetAllActualFundings" (sortby integer) RETURNS SETOF "public"."ReturnFullActualFundings" AS
$body$
DECLARE rec RECORD;
DECLARE sortByLocal INTEGER;

BEGIN

IF (sortby <=  0 ) THEN sortByLocal :=  4 ; ELSE sortByLocal := sortby; END IF;

FOR rec IN SELECT

  AF."ActualFundingID",
  AF."FundSourceID",
  FC."Name",
  AF."StartDate",
  AF."Quantity",
  AF."EndDate",
  AF."ProjectID",
  P."Name",
  P."Description",
  P."CustomerID",
  P."StartDate",
  P."Identifier",
  P."Custom1",
  P."Custom2",
  P."Custom3",
  P."Custom4",
  AF."Description",
  AF."Name"
  
                 FROM "ActualFundings" AF
JOIN "FundSources" FC ON AF."FundSourceID" = FC."FundSourceID"
JOIN "Projects" P ON AF."ProjectID" = P."ProjectID"
ORDER BY sortByLocal ASC

LOOP
RETURN NEXT rec;
END LOOP;
RETURN;

END;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;

PREPARE usrrptplan (int, date) AS
    SELECT * FROM users u, logs l WHERE u.usrid=$ 1  AND u.usrid=l.usrid
    AND l.date = $ 2 ;
EXECUTE usrrptplan( 1 , current_date);