tandem
/
numerus
2
0
Fork 0
Code Issues 39 Pull Requests Packages Projects 1 Releases 1 Wiki Activity
numerus/verify/available_quote_status.sql

25 lines
1.7 KiB
MySQL
Raw Permalink Normal View History

Add relations for sales quotations and their products They are mostly the same as invoices, but the contact and payment method are optional, thus, like other optionals fields, i created relations to link these that have payment method or contact, to avoid NULL columns in quote. Still missing functions to add and edit quotations, and views to compute their tax and total amount.
2023-06-06 19:08:31 +00:00
-- Verify numerus:available_quote_status on pg
begin;
set search_path to numerus;
select 1 / count(*) from quote_status where quote_status = 'created' and name ='Created';
select 1 / count(*) from quote_status where quote_status = 'sent' and name ='Sent';
select 1 / count(*) from quote_status where quote_status = 'accepted' and name ='Accepted';
select 1 / count(*) from quote_status where quote_status = 'rejected' and name ='Rejected';
Add the “invoiced” quote status This is for people to mark quotes that are already invoiced and filter them out in the list.
2023-06-11 20:19:43 +00:00
select 1 / count(*) from quote_status where quote_status = 'invoiced' and name ='Invoiced';
Add relations for sales quotations and their products They are mostly the same as invoices, but the contact and payment method are optional, thus, like other optionals fields, i created relations to link these that have payment method or contact, to avoid NULL columns in quote. Still missing functions to add and edit quotations, and views to compute their tax and total amount.
2023-06-06 19:08:31 +00:00
select 1 / count(*) from quote_status_i18n where quote_status = 'created' and name ='Creat' and lang_tag = 'ca';
select 1 / count(*) from quote_status_i18n where quote_status = 'created' and name ='Creado' and lang_tag = 'es';
select 1 / count(*) from quote_status_i18n where quote_status = 'sent' and name ='Enviat' and lang_tag= 'ca';
select 1 / count(*) from quote_status_i18n where quote_status = 'sent' and name ='Enviado' and lang_tag= 'es';
select 1 / count(*) from quote_status_i18n where quote_status = 'accepted' and name ='Acceptat' and lang_tag= 'ca';
select 1 / count(*) from quote_status_i18n where quote_status = 'accepted' and name ='Aceptado' and lang_tag= 'es';
select 1 / count(*) from quote_status_i18n where quote_status = 'rejected' and name ='Rebutjat' and lang_tag= 'ca';
select 1 / count(*) from quote_status_i18n where quote_status = 'rejected' and name ='Rechazado' and lang_tag= 'es';
Add the “invoiced” quote status This is for people to mark quotes that are already invoiced and filter them out in the list.
2023-06-11 20:19:43 +00:00
select 1 / count(*) from quote_status_i18n where quote_status = 'invoiced' and name ='Facturat' and lang_tag = 'ca';
select 1 / count(*) from quote_status_i18n where quote_status = 'invoiced' and name ='Facturado' and lang_tag = 'es';
Add relations for sales quotations and their products They are mostly the same as invoices, but the contact and payment method are optional, thus, like other optionals fields, i created relations to link these that have payment method or contact, to avoid NULL columns in quote. Still missing functions to add and edit quotations, and views to compute their tax and total amount.
2023-06-06 19:08:31 +00:00
rollback;