r2

SELECT * FROM fn_ganancias_por_anio(2,2023)

SELECT * FROM ganancias_floristeria(2, '2023-01-01');

DESDE una floristeria:

SELECT * FROM fn_ganancias_por_usuario_actual( '2023-01-01');

SELECT * FROM fn_ganancias_por_anio_usuario_actual(2023);

consultas:

SELECT facturaid, idafiliacionfloristeria, idafiliacionsubastadora, fechaemision, montototal, numeroenvio FROM public.factura where idafiliacionfloristeria = CAST(substring(current_user FROM length(current_user) FOR 1) AS INTEGER);

SELECT facturaid, idafiliacionfloristeria, fechaemision, montototal FROM public.factura where idafiliacionfloristeria = CAST(substring(current_user FROM length(current_user) FOR 1) AS INTEGER);

SELECT idfloristeria, numfactura, fechaemision, montototal, idclientenatural, idclientejuridico FROM public.factura_final where idfloristeria = CAST(substring(current_user FROM length(current_user) FOR 1) AS INTEGER);

SELECT idfloristeria, numfactura, fechaemision, montototal FROM public.factura_final where idfloristeria = CAST(substring(current_user FROM length(current_user) FOR 1) AS INTEGER);