﻿DELETE FROM yactionexport WHERE numaction = '311' AND cle = '3';
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1480', '5', 'client.nomclientenlevement', '$_PARAM[679.nomclientlivraison]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1480', '6', 'client.adresseenlevement', '$_PARAM[679.adresselivraison]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1480', '7', 'client.codepostalenlevement', '$_PARAM[679.codepostallivraison]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1480', '8', 'client.villeenlevement', '$_PARAM[679.villelivraison]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '807', '9', 'client.nomclientenlevement', 'nomclientenlevement', NULL);
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '807', '10', 'client.adresseenlevement', 'adresseenlevement', NULL);
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '807', '11', 'client.codepostalenlevement', 'codepostalenlevement', NULL);
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '807', '12', 'client.villeenlevement', 'villeenlevement', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '262', '31', 'dossier.nomclientenlevement', '$_PARAM[20.nomclientenlevement]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '262', '32', 'dossier.adresseenlevement', '$_PARAM[20.adresseenlevement]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '262', '33', 'dossier.codepostalenlevement', '$_PARAM[20.codepostalenlevement]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '262', '34', 'dossier.villeenlevement', '$_PARAM[20.villeenlevement]', NULL, NULL, 0, 'Toujours');
UPDATE yactionupdate SET `right` = '$_PARAM[807.nomclientenlevement]' WHERE numaction = '262' AND cle = '31';
UPDATE yactionupdate SET `right` = '$_PARAM[807.adresseenlevement]' WHERE numaction = '262' AND cle = '32';
UPDATE yactionupdate SET `right` = '$_PARAM[807.codepostalenlevement]' WHERE numaction = '262' AND cle = '33';
UPDATE yactionupdate SET `right` = '$_PARAM[807.villeenlevement]' WHERE numaction = '262' AND cle = '34';
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '224', '20', 'client.nomclientenlevement', 'nomclientenlevement', NULL);
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '224', '21', 'client.adresseenlevement', 'adresseenlevement', NULL);
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '224', '22', 'client.codepostalenlevement', 'codepostalenlevement', NULL);
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '224', '23', 'client.villeenlevement', 'villeenlevement', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1279', '26', 'dossier.nomclientenlevement', '$_PARAM[224.nomclientenlevement]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1279', '27', 'dossier.adresseenlevement', '$_PARAM[224.adresseenlevement]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1279', '28', 'dossier.codepostalenlevement', '$_PARAM[224.codepostalenlevement]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1279', '29', 'dossier.villeenlevement', '$_PARAM[224.villeenlevement]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '289', '6', 'article.reparable', 'reparable', NULL);
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '289', '7', 'article.poids', 'poids', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1288', '7', 'dossier.reparable', '$_PARAM[289.reparable]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1288', '8', 'dossier.poidstotal', '$_PARAM[289.poids]', NULL, NULL, 0, 'Toujours');
DELETE FROM yactionexport WHERE numaction = '289' AND cle = '6';
DELETE FROM yactionupdate WHERE numaction = '1288' AND cle = '7';
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '289', '8', 'article.process', 'process', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1288', '9', 'dossier.process', '$_PARAM[289.process]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '806', '6', 'client.codegestion', 'codegestion', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1482', '6', 'client.codegestion', '$_PARAM[806.codegestion]', NULL, NULL, 0, 'Toujours');
DELETE FROM yactionexport WHERE numaction = '806' AND cle = '6';
DELETE FROM yactionupdate WHERE numaction = '1482' AND cle = '6';
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '302', '25', 'dossier.codegestion', 'codegestion', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1296', '27', 'devis.codegestion', '$_PARAM[302.codegestion]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '224', '20', 'client.codegestion', 'codegestion', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1279', '26', 'dossier.codegestion', '$_PARAM[224.codegestion]', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '287', '4', 'article.refconstructeur', 'refconstructeur', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1383', '10', 'commandeligne.reffournisseur', '$_PARAM[287.refconstructeur]', NULL, NULL, 0, 'Toujours');
INSERT INTO yaction (numaction) VALUES (1923);
UPDATE yaction SET action = 'tous' WHERE numaction = '1923';
UPDATE yaction SET liste = 'xoriginedossier' WHERE numaction = '1923';
UPDATE yaction SET orderdefault = 'xoriginedossier.originedossier' WHERE numaction = '1923';
UPDATE yaction SET caption = 'xoriginedossier' WHERE numaction = '1923';
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '1923', '1', 'bbmindex', 'xoriginedossier', NULL);
INSERT INTO yaction (numaction) VALUES (1924);
INSERT INTO yactionlink (numaction, cle, next, nextif, child) VALUES ('1923', '1', '1924', NULL, NULL);
UPDATE yactionlink SET icone = 'style/common/icones/actiondeleteok.gif' WHERE numaction = '1923' AND cle = '1';
UPDATE yaction SET type = 'DELETE' WHERE numaction = '1924';
UPDATE yaction SET liste = 'xoriginedossier' WHERE numaction = '1924';
INSERT INTO ycontrainte (`numcontrainte`, `numaction`, `cle`, `champwhere`, `champcomp`, `champvalue`, `left`, `op`, `right`) VALUES (NULL, '1924', '1', NULL, NULL, NULL, 'xoriginedossier.bbmindex', '=', '$_POST[xoriginedossier]');
INSERT INTO yaction (numaction) VALUES (1925);
INSERT INTO yactionlink (numaction, cle, next, nextif, child) VALUES ('1924', '1', '1925', NULL, NULL);
UPDATE yaction SET type = 'TAB' WHERE numaction = '1925';
INSERT INTO ylientable (bbmindex, numaction, cle, nomtable1, nomchamp1, nomtable2, nomchamp2, typelien) VALUES (NULL, '1923', '1', 'xoriginedossier', NULL, NULL, NULL, 'INNER');
INSERT INTO yaction (numaction) VALUES (1926);
UPDATE yaction SET type = 'INSERT' WHERE numaction = '1926';
UPDATE yaction SET liste = 'xoriginedossier' WHERE numaction = '1926';
INSERT INTO yaction (numaction) VALUES (1927);
INSERT INTO yactionlink (numaction, cle, next, nextif, child) VALUES ('1926', '1', '1927', NULL, NULL);
UPDATE yaction SET type = 'TAB' WHERE numaction = '1927';
UPDATE yaction SET action = 'Fermer' WHERE numaction = '1925';
UPDATE yaction SET action = 'Recharger' WHERE numaction = '1925';
UPDATE yaction SET action = 'Fermer' WHERE numaction = '1925';
UPDATE yaction SET action = 'Recharger' WHERE numaction = '1925';
UPDATE yaction SET action = 'Fermer' WHERE numaction = '1927';
UPDATE yaction SET action = 'Recharger' WHERE numaction = '1927';
UPDATE yactionupdate SET `right` = '$_PARAM[761.nomclientlivraison] / $_FUNC|loginTech]' WHERE numaction = '762' AND cle = '19';
UPDATE yactionupdate SET `right` = '$_PARAM[761.nomclientlivraison] / $_FUNC[loginTech]' WHERE numaction = '762' AND cle = '19';
INSERT INTO ylientable (bbmindex, numaction, cle, nomtable1, nomchamp1, nomtable2, nomchamp2, typelien) VALUES (NULL, '763', '5', 'interarticle', 'codearticle', 'article', 'codearticle', 'INNER');
UPDATE yactionexport SET nomchamp = 'article.refconstructeur' WHERE numaction = '763' AND cle = '6';
INSERT INTO ylientable (bbmindex, numaction, cle, nomtable1, nomchamp1, nomtable2, nomchamp2, typelien) VALUES (NULL, '771', '1', 'interarticle', 'codearticle', 'article', 'codearticle', 'LEFT');
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '771', '11', 'article.refconstructeur', 'reconstructeur', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1684', '12', 'commandeligne.reffournisseur', '$_PARAM[771.refconstructeur]', NULL, NULL, 0, 'Toujours');
UPDATE yactionexport SET alias = 'refconstructeur' WHERE numaction = '771' AND cle = '11';
UPDATE yactionupdate SET `right` = '411000' WHERE numaction = '968' AND cle = '3';
UPDATE yactionupdate SET `right` = 'X$_PARAM[967.codecomptable]' WHERE numaction = '968' AND cle = '2';
UPDATE yactionupdate SET `right` = 'VTE' WHERE numaction = '968' AND cle = '1';
UPDATE yactionupdate SET `right` = 'VTE' WHERE numaction = '1783' AND cle = '1';

-- 25/06
UPDATE yactionexport SET nomchamp = 'dossier.nomic' WHERE numaction = '302' AND cle = '23';
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '10162', '26', 'devis.nomic', 'nomic', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '313', '34', 'facture.commercial', '$_PARAM[10162.nomic]', NULL, NULL, 0, 'Toujours');
DELETE FROM yactionlink WHERE numaction = '726' AND cle = '1';
INSERT INTO yactionlink (numaction, cle, next, nextif, child) VALUES ('726', '1', '10160', NULL, NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1418', '8', 'facturefournisseur.numpiece', '$_FUNC[compteur,facturefournisseur,numpiece,numpiece]', NULL, NULL, 0, 'Toujours');
DELETE FROM yactionlink WHERE numaction = '726' AND cle = '1';
INSERT INTO yactionlink (numaction, cle, next, nextif, child) VALUES ('726', '1', '60070', NULL, NULL);
INSERT INTO yaction (numaction) VALUES (3013);
UPDATE yaction SET type = 'PLANNING' WHERE numaction = '3013';
UPDATE yaction SET type = 'PRINT' WHERE numaction = '3013';
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '10159', '29', 'facture.numdossier', '$_PARAM[721.numdossier]', NULL, NULL, 0, 'Toujours');
DELETE FROM yactionupdate WHERE numaction = '1279' AND cle = '24';
UPDATE yactionexport SET nomchamp = 'devis.numdossier' WHERE numaction = '721' AND cle = '23';
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1296', '29', 'devis.pieddevis', '$_VAL[40% à la commande. 
Le solde à réception de chantier]', NULL, NULL, 0, 'Toujours');
UPDATE yaction SET orderdefault = 'facturefournisseur.numpiece DESC' WHERE numaction = '124';
DELETE FROM yactionif WHERE numaction = '1252' AND cle = '7';
DELETE FROM yactionif WHERE numaction = '1252' AND cle = '2';
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '223', '15', 'client.codegestion', 'codegestion', NULL);
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '1342', '18', 'facture.codegestion', NULL, NULL, NULL, 0, 'Toujours');
UPDATE yactionupdate SET `right` = '$_PARAM[223.codegestion]' WHERE numaction = '1342' AND cle = '18';
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '4137', '6', 'reglementfourfact.bbmindex', 'numpiece', NULL);
UPDATE yactionupdate SET `right` = '$_PARAM[4137.numpiece]' WHERE numaction = '4138' AND cle = '10';
UPDATE ycontrainte SET `left` = 'reglementfourfact.exporte' WHERE numaction = '4140' AND cle = '1';
INSERT INTO ylientable (bbmindex, numaction, cle, nomtable1, nomchamp1, nomtable2, nomchamp2, typelien) VALUES (NULL, '4140', '1', 'reglementfourfact', 'idxreglement', 'reglementfour', 'bbmindex', 'INNER');
INSERT INTO ycontrainte (`numcontrainte`, `numaction`, `cle`, `champwhere`, `champcomp`, `champvalue`, `left`, `op`, `right`) VALUES (NULL, '4140', '2', NULL, NULL, NULL, 'reglementfour.datereglement', '>=', '$_POST[datereglement]');
INSERT INTO ycontrainte (`numcontrainte`, `numaction`, `cle`, `champwhere`, `champcomp`, `champvalue`, `left`, `op`, `right`) VALUES (NULL, '4140', '3', NULL, NULL, NULL, 'reglementfour.datereglement', '<=', '$_POST[datereglement]');
UPDATE ycontrainte SET `right` = '$_POST[datereglementfin]' WHERE numaction = '4140' AND cle = '3';
UPDATE ycontrainte SET `actif` = 'SiNonVide' WHERE numaction = '4140' AND cle = '2';
UPDATE ycontrainte SET `actif` = 'SiNonVide' WHERE numaction = '4140' AND cle = '3';
INSERT INTO ycontrainte (`numcontrainte`, `numaction`, `cle`, `champwhere`, `champcomp`, `champvalue`, `left`, `op`, `right`) VALUES (NULL, '4141', '1', NULL, NULL, NULL, 'reglementfourfact.bbmindex', '=', '$_PARAM[4140.reglement]');
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '4137', '6', 'reglementfour.codebanque', 'codebanque', NULL);
UPDATE yactionupdate SET `right` = '$_PARAM[4137.codebanque]' WHERE numaction = '4138' AND cle = '1';
UPDATE yactionupdate SET `right` = '$_PARAM[4137.codebanque]' WHERE numaction = '4139' AND cle = '1';
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '4137', '6', 'reglementfour.codebanque', 'codebanque', NULL);
UPDATE yactionupdate SET `right` = '$_PARAM[4137.codebanque]' WHERE numaction = '4138' AND cle = '1';
UPDATE yactionupdate SET `right` = '$_PRAM[4137.codebanque]' WHERE numaction = '4139' AND cle = '1';
UPDATE yactionupdate SET `right` = '$_PARAM[4137.codebanque]' WHERE numaction = '4139' AND cle = '1';
INSERT INTO ylientable (bbmindex, numaction, cle, nomtable1, nomchamp1, nomtable2, nomchamp2, typelien) VALUES (NULL, '4137', '3', 'reglementfour', 'codebanque', 'xbanque', 'codebanque', 'INNER');
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '4137', '7', 'xbanque.comptebanque', 'comptebanque', NULL);
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '4137', '8', 'reglementfour.dateecheance', 'dateecheance', NULL);
UPDATE yactionupdate SET `right` = 'RF' WHERE numaction = '4138' AND cle = '8';
UPDATE yactionupdate SET `right` = '-1' WHERE numaction = '4138' AND cle = '6';
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '4138', '11', 'export.comptegeneral', '401000', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '4138', '12', 'export.dateecheance', '$_PARAM[4137.dateecheance]', NULL, NULL, 0, 'Toujours');
UPDATE yactionupdate SET `right` = 'RF' WHERE numaction = '4139' AND cle = '3';
UPDATE yactionupdate SET `right` = '$_PARAM[4137.comptebanque]' WHERE numaction = '4139' AND cle = '4';
UPDATE yactionupdate SET `right` = '$_PARAM[4137.codecomptable] $_PARAM[4137.typereglement]' WHERE numaction = '4139' AND cle = '6';
UPDATE yactionupdate SET `right` = '1' WHERE numaction = '4139' AND cle = '8';
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '4139', '11', 'export.dateecheance', '$_PARAM[4137.dateecheance]', NULL, NULL, 0, 'Toujours');
INSERT INTO ylientable (bbmindex, numaction, cle, nomtable1, nomchamp1, nomtable2, nomchamp2, typelien) VALUES (NULL, '4137', '3', 'reglementfour', 'codebanque', 'xbanque', 'codebanque', 'INNER');
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '4137', '7', 'xbanque.comptebanque', 'comptebanque', NULL);
INSERT INTO yactionexport (bbmindex, numaction, cle, nomchamp, alias, fonctionsql) VALUES (NULL, '4137', '8', 'reglementfour.dateecheance', 'dateecheance', NULL);
UPDATE yactionupdate SET `right` = 'RF' WHERE numaction = '4138' AND cle = '8';
UPDATE yactionupdate SET `right` = '-1' WHERE numaction = '4138' AND cle = '6';
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '4138', '11', 'export.comptegeneral', '401000', NULL, NULL, 0, 'Toujours');
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '4138', '12', 'export.dateecheance', '$_PARAM[4137.dateecheance]', NULL, NULL, 0, 'Toujours');
UPDATE yactionupdate SET `right` = 'RF' WHERE numaction = '4139' AND cle = '3';
UPDATE yactionupdate SET `right` = '$_PARAM[4137.comptebanque]' WHERE numaction = '4139' AND cle = '4';
UPDATE yactionupdate SET `right` = '$_PARAM[4137.codecomptable] $_PARAM[4137.typereglement]' WHERE numaction = '4139' AND cle = '6';
UPDATE yactionupdate SET `right` = '1' WHERE numaction = '4139' AND cle = '8';
INSERT INTO yactionupdate (bbmindex, numaction, cle, `left`, `right`, `fonctionphp`, `paramphp`, `isvar`, `actif`) VALUES (NULL, '4139', '11', 'export.dateecheance', '$_PARAM[4137.dateecheance]', NULL, NULL, 0, 'Toujours');
INSERT INTO ycontrainte (`numcontrainte`, `numaction`, `cle`, `champwhere`, `champcomp`, `champvalue`, `left`, `op`, `right`) VALUES (NULL, '4137', '2', NULL, NULL, NULL, 'reglementfour', '>=', '$_POST[datereglement]');
UPDATE ycontrainte SET `actif` = 'SiNonVide' WHERE numaction = '4137' AND cle = '1';
UPDATE ycontrainte SET `actif` = 'Toujours' WHERE numaction = '4137' AND cle = '1';
UPDATE ycontrainte SET `actif` = 'SiNonVide' WHERE numaction = '4137' AND cle = '2';
UPDATE ycontrainte SET `left` = 'reglementfour.datereglement' WHERE numaction = '4137' AND cle = '2';
INSERT INTO ycontrainte (`numcontrainte`, `numaction`, `cle`, `champwhere`, `champcomp`, `champvalue`, `left`, `op`, `right`) VALUES (NULL, '4137', '3', NULL, NULL, NULL, 'reglementfour.datereglement', '<=', '$_POST[datereglementfin]');
UPDATE ycontrainte SET `actif` = 'SiNonVide' WHERE numaction = '4137' AND cle = '3';
INSERT INTO ycontrainte (`numcontrainte`, `numaction`, `cle`, `champwhere`, `champcomp`, `champvalue`, `left`, `op`, `right`) VALUES (NULL, '4137', '2', NULL, NULL, NULL, 'reglementfour.datereglement', '>=', '$_POST[datereglement]');
UPDATE ycontrainte SET `actif` = 'SiNonVide' WHERE numaction = '4137' AND cle = '2';
INSERT INTO ycontrainte (`numcontrainte`, `numaction`, `cle`, `champwhere`, `champcomp`, `champvalue`, `left`, `op`, `right`) VALUES (NULL, '4137', '3', NULL, NULL, NULL, 'reglementfour.datereglement', '<=', '$_POST[datereglementfin]');
UPDATE ycontrainte SET `actif` = 'SiNonVide' WHERE numaction = '4137' AND cle = '3';
UPDATE yactionupdate SET `right` = 'X$_PARAM[4137.codecomptable]' WHERE numaction = '4138' AND cle = '2';
UPDATE yactionupdate SET `right` = 'X$_PARAM[4137.codecomptable]' WHERE numaction = '4138' AND cle = '2';

-- 17/9 BGI