Olá,
Pagamentos em um estado pendente não podem ser faturados e são excluídos da
sessão "invoice runs section"....
Não consigo localizar o erro para corrigi-lo...
Podem dar uma luz? Se precisar de alguma info a mais posso fornecer.
Obrigado!
*Function:*
> CREATE OR REPLACE FUNCTION "public"."g_status_types_jobs" ("client_id"
> bigint DEFAULT NULL::bigint, "output_order" character varying DEFAULT
> '-START_TIME'::character varying, "start_time" timestamp without time zone
> DEFAULT NULL::timestamp without time zone, "end_time" timestamp without
> time zone DEFAULT NULL::timestamp without time zone, "statuses" "text"
> DEFAULT NULL::"text", "status_types" "text" DEFAULT NULL::"text",
> "customer_id" bigint DEFAULT NULL::bigint, "user_id" bigint DEFAULT
> NULL::bigint, "recurrence_id" bigint DEFAULT NULL::bigint, "search_str"
> "text" DEFAULT NULL::"text", "unscheduled_is_desired" boolean DEFAULT
> false, "unassigned_is_desired" boolean DEFAULT false, "templated_status"
> boolean DEFAULT false, "by_job_ref" boolean DEFAULT false,
> "by_job_description" boolean DEFAULT false, "by_job_address" boolean
> DEFAULT false, "by_title" boolean DEFAULT false, "by_status" boolean
> DEFAULT false, "by_order_number" boolean DEFAULT false, "by_client" boolean
> DEFAULT false, "by_client_notes" boolean DEFAULT false, "by_billing_client"
> boolean DEFAULT false, "by_staff" boolean DEFAULT false,
> "by_notes_description" boolean DEFAULT false, "invoiceable_notes_only"
> boolean DEFAULT false) RETURNS TABLE("status_type_id" bigint, "jobs_count"
> bigint, "job_ids" "text", "status_type_data" "text")
> STABLE
> AS $dbvis$
> SELECT
> COALESCE(s.status_type_id, -1) AS status_type_id,
> CAST(ROUND(SUM(s.jobs_count)) AS BIGINT) AS jobs_count,
> -- we concatenate the lists from all the status labels. some
> nullif/substring trickery is required here
> CONCAT('{', STRING_AGG(NULLIF(SUBSTRING(s.job_ids FROM 2 FOR
> (CHAR_LENGTH(s.job_ids) - 2)), ''), (CASE WHEN (s.job_ids != '{}') THEN ','
> ELSE '' END)), '}') AS job_ids,
> (CASE
> WHEN (COALESCE(s.status_type_id, -1) != -1) THEN
> STRING_AGG(CONCAT(
> CAST(s.status_id AS TEXT),
> E'\t', REPLACE(REPLACE(s.status_label, E'\t', '<tab>'), E'\n', '<lf>'),
> E'\t', CAST(s.status_is_default AS TEXT),
> E'\t', CAST(s.jobs_count AS TEXT),
> E'\t', CAST(s.job_ids AS TEXT)
> ), E'\n')
> ELSE
> null
> END) AS status_type_data
> FROM
> public.g_statuses_jobs($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12,
> $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25) AS s
> GROUP BY
> s.status_type_id
> ;
> $dbvis$ LANGUAGE sql
_______________________________________________
pgbr-geral mailing list
pgbr-geral@listas.postgresql.org.br
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
