Re: [Phpcompta-contrib] Re: enleve la variable globale g_jrn, remplace par param HTTP p_jrn partout

[Stan Pinte]

Dany De Bontridder wrote:

> On Thursday 07 July 2005 10:44, Stan Pinte wrote:
>
>  
>
> > super faisons des essais...envoie moi ton SQL.
> >    
>
> Done :-)
>  
corrigé ton SQL:

INSERT INTO formdef (fr_id, fr_label) VALUES (30000, 'TVA déclaration');
--
-- Data for TOC entry 2 (OID 315304)
-- Name: formdef; Type: TABLE DATA; Schema: public; Owner: dany
--

INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100170, 30000, 1, 'Prestation [ case 03 ]', '[700%]-[7000005]');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100171, 30000, 2, 'Prestation intra [ case 47 ]', '[7000005]');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100172, 30000, 3, 'Tva due à 6 %  [case 54]', '[4513] FROM=01.2005');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100173, 30000, 4, 'Tva due a 12% [case 54]', '[4512] FROM=01.2005');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100174, 30000, 5, 'Tva due a 21% [case 54]', '[4511] FROM=01.2005');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100175, 30000, 6, 'Exempté intracomm [case 47]', '[4514] FROM=01.2005');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100176, 30000, 7, 'Service et bien divers [case 82]', '[61%]');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100177, 30000, 8, 'bien d''invest [ case 83 ]', '[2400%]');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100178, 30000, 9, 'TVA déductible [ case 59 ]', 'abs([4117]-[411%])');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100179, 30000, 10, '(TVA non ded -> voiture) Total frais voiture (faire 
* 0.21/2) et le soustraire', '[610022]*0.21/2');
INSERT INTO form (fo_id, fo_fr_id, fo_pos, fo_label, fo_formula) VALUES 
(100180, 30000, 11, 'Acompte TVA', '[4117]');