[Noalyss-commit] [noalyss] 83/107: Task#1734 New : Add PRINTTVA to have a summary of VAT by ledger

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit f18c02671a105533370c54d26fee30d2943793a2
Author: Dany De Bontridder <address@hidden>
Date:   Sat Aug 10 15:17:03 2019 +0200

    Task#1734 New : Add PRINTTVA to have a summary of VAT by ledger
---
 sql/upgrade.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index e69de29..20feb0a 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -0,0 +1,18 @@
+insert into menu_ref 
(me_code,me_menu,me_file,me_description,me_type,me_description_etendue)
+values('PRINTTVA','Résumé TVA','tax_summary.inc.php','totaux  par TVA et par 
journal','ME','Calcul des totaux  par TVA et par journal');
+
+insert into profile_menu 
(me_code,me_code_dep,p_id,p_order,p_type_display,pm_default,pm_id_dep)
+select me_code,'PRINT',1,250,'E',0,6 from menu_ref where me_code='PRINTTVA'
+union
+select me_code,'PRINT',1,250,'E',0,35 from menu_ref where me_code='PRINTTVA'
+union
+select me_code,'PRINT',2,250,'E',0,719 from menu_ref where me_code='PRINTTVA'
+union
+select me_code,'PRINT',2,250,'E',0,716 from menu_ref where me_code='PRINTTVA'
+;
+insert into menu_ref (me_code,me_menu,me_file,me_type)
+values ('CSV:printtva','Export Résumé TVA','export_printtva_csv.php','PR'),
+       ('PDF:printtva','Export Résumé TVA','export_printtva_pdf.php','PR')
+;
+
+insert into profile_menu(me_code,p_id,p_type_display) values 
('CSV:printtva',1,'P'),('PDF:printtva',1,'P'),('CSV:printtva',2,'P'),('PDF:printtva',2,'P');