UID:--072439--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--072439--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--072500--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:--072500--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--074052--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--074052--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--083631--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--083631--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--085113--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--085113-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202512110851' )
UID:--085113-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Nettoyage des pavés et dalles',`att90`='m2soewpiocizt7ph',`attf100`='20251211',`att5`='4521',`att8`='7',`att9`='995',`att10`='99.5',`att11`='1094.5',`att13`='chèque ou virement',`att14`='2747',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  3 rue des Cors 57140 WOIPPY',`att18`='0',`att29`='995',`att24`='1094.5',`att25`='3 rue des Cors',`att26`='',`att27`='57140',`att28`='WOIPPY',`att41`='',`att42`='',`attdatmod`='202512110851',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2880')  AND (id_type = '168')  LIMIT 1 
UID:--085113-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '2880')  LIMIT 1 
UID:--085113-- UPDATE  `tier_lig`  SET `lig2`='146',`ligdatmod`='202512110851',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '8')  LIMIT 1 
UID:--085113-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-146',`att3`='',`att2`='Nettoyage des pavés et dalles',`att90`='m2soewpiocizt7ph',`attf100`='20251211',`att5`='4521',`att8`='7',`att9`='995',`att10`='99.5',`att11`='1094.5',`att13`='chèque ou virement',`att14`='2747',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  3 rue des Cors 57140 WOIPPY',`att18`='0',`att29`='995',`att24`='1094.5',`att25`='3 rue des Cors',`att26`='',`att27`='57140',`att28`='WOIPPY',`att41`='',`att42`='',`attdatmod`='202512110851',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2880')  AND (id_type = '168')  LIMIT 1 
UID:--085113-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2880','202512110851','202512110851' )
UID:--085113-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='99.50',`lig9`='122',`lig16`='m2',`lig91`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='50',`lig2`='19.90',`lig5`='10',`lig4`='995.00',`lig8`='1094.50',`lig10`='euro',`lig6`='1094.50',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202512110851',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2880')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6120')  LIMIT 1 
UID:--085113-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1170','1','2','Devis_DV-METZ-302_28_11_2025_15h_21m_signe.pdf','20251211','125','devis_signe','168','2880','-2','-1','' )
UID:--085113-- UPDATE  `file`  SET `size`='513885'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5762')  LIMIT 1 
UID:--085114-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1171','1','2','Attestation_fiscale_DV_METZ_302_28_11_2025_15h_20m_signe.pdf','20251211','542','attestation_signe','168','2880','-2','-1','' )
UID:--085114-- UPDATE  `file`  SET `size`='727477'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5763')  LIMIT 1 
UID:--085114-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251211','','1','contact@exteco.fr','Exteco','laetitia.petit57@gmail.com','','','Merci pour votre commande : Devis N°DV-METZ-302','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouveau Devis EXTECO</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Merci pour votre commande (Devis N° DV-METZ-302)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour madame PETIT,<br><br>Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.<br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nous prendrons contact avec vous rapidement pour programmer l\'intervention. En attendant, n\'hésitez pas à nous contacter si vous avez la moindre question ou besoin de clarification sur certains points.<br><br>\r\n                                Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.<br><br>\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>\r\n','/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5762-1170-125-1§Devis_DV-METZ-302_28_11_2025_15h_21m_signe.pdf;/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5763-1171-542-1§Attestation_fiscale_DV_METZ_302_28_11_2025_15h_20m_signe.pdf','0','v2017b' )
UID:--085114-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3834')  LIMIT 1 
UID:--085114-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251211','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-302','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Devis signé</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Devis signé (Devis N° DV-METZ-302)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour,<br><br>Le devis n°DV-METZ-302 de madame PETIT a été signé électroniquement.</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--085114-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3835')  LIMIT 1 
UID:--085114-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-146',`att3`='',`att2`='Nettoyage des pavés et dalles',`att90`='m2soewpiocizt7ph',`attf100`='20251211',`att5`='4521',`att8`='7',`att9`='995',`att10`='99.5',`att11`='1094.5',`att13`='chèque ou virement',`att14`='2747',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  3 rue des Cors 57140 WOIPPY',`att18`='0',`att29`='995',`att24`='1094.5',`att25`='3 rue des Cors',`att26`='',`att27`='57140',`att28`='WOIPPY',`att41`='',`att42`='',`att39`='',`attdatmod`='202512110851',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2880')  AND (id_type = '168')  LIMIT 1 
UID:--085114-- UPDATE  `vent_lig`  SET `lig1`='122',`lig7`='99.50',`lig9`='122',`lig16`='122',`lig91`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='50',`lig2`='19.90',`lig5`='10',`lig4`='995.00',`lig8`='1094.50',`lig10`='euro',`lig6`='1094.50',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202512110851',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2880')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6120')  LIMIT 1 
UID:--085114-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-146',`att3`='',`att2`='Nettoyage des pavés et dalles',`att90`='m2soewpiocizt7ph',`attf100`='20251211',`att5`='4521',`att8`='7',`att9`='995',`att10`='99.5',`att11`='1094.5',`att13`='chèque ou virement',`att14`='2747',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  3 rue des Cors 57140 WOIPPY',`att18`='-2.2737367544323E-13',`att29`='995',`att24`='1094.5',`att25`='3 rue des Cors',`att26`='',`att27`='57140',`att28`='WOIPPY',`att41`='',`att42`='',`att39`='',`att31`='99.5',`attdatmod`='202512110851',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2880')  AND (id_type = '168')  LIMIT 1 
UID:--085121-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='13',`attdatmod`='202512110851',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2748')  AND (id_type = '148')  LIMIT 1 
UID:--085121-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202512110851',`attdatmod`='202512110851',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2747')  AND (id_type = '165')  LIMIT 1 
UID:--085815--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--085815--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--090314--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--090314--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--090936--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--090936--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--091936--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--091936-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202512110919' )
UID:--091936-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle - Sols - OGY MONTOY FLANVILLE',`att90`='8l7ewhqau96msxjt',`attf100`='20251211',`att5`='4891',`att8`='8',`att9`='1014.9',`att10`='101.49',`att11`='1116.39',`att13`='chèque ou virement',`att14`='2867',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  13 Rue du Cugnot 57645 MONTOY-FLANVILLE',`att18`='0',`att29`='1014.9',`att24`='1116.39',`att25`='13 Rue du Cugnot',`att26`='',`att27`='57645',`att28`='MONTOY-FLANVILLE',`att41`='',`att42`='',`attdatmod`='202512110919',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2881')  AND (id_type = '168')  LIMIT 1 
UID:--091936-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '2881')  LIMIT 1 
UID:--091936-- UPDATE  `tier_lig`  SET `lig2`='147',`ligdatmod`='202512110919',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '8')  LIMIT 1 
UID:--091936-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-147',`att3`='',`att2`='Maison individuelle - Sols - OGY MONTOY FLANVILLE',`att90`='8l7ewhqau96msxjt',`attf100`='20251211',`att5`='4891',`att8`='8',`att9`='1014.9',`att10`='101.49',`att11`='1116.39',`att13`='chèque ou virement',`att14`='2867',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  13 Rue du Cugnot 57645 MONTOY-FLANVILLE',`att18`='0',`att29`='1014.9',`att24`='1116.39',`att25`='13 Rue du Cugnot',`att26`='',`att27`='57645',`att28`='MONTOY-FLANVILLE',`att41`='',`att42`='',`attdatmod`='202512110919',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2881')  AND (id_type = '168')  LIMIT 1 
UID:--091936-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2881','202512110919','202512110919' )
UID:--091936-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='114',`lig7`='101.49',`lig9`='114',`lig16`='m2',`lig91`='<b>Nettoyage de la terrasse (1)</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='51',`lig2`='19.90',`lig5`='10',`lig4`='1014.90',`lig8`='1116.39',`lig10`='euro',`lig6`='1116.39',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202512110919',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2881')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6121')  LIMIT 1 
UID:--091936-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1172','1','2','Devis_DV-METZ-310_10_12_2025_13h_12m_signe.pdf','20251211','800','devis_signe','168','2881','-2','-1','' )
UID:--091936-- UPDATE  `file`  SET `size`='571279'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5770')  LIMIT 1 
UID:--091937-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1173','1','2','Attestation_fiscale_DV_METZ_310_10_12_2025_13h_12m_signe.pdf','20251211','163','attestation_signe','168','2881','-2','-1','' )
UID:--091937-- UPDATE  `file`  SET `size`='730056'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5771')  LIMIT 1 
UID:--091937-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251211','','1','contact@exteco.fr','Exteco','patrick.rougetet@orange.fr','','','Merci pour votre commande : Devis N°DV-METZ-310','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouveau Devis EXTECO</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Merci pour votre commande (Devis N° DV-METZ-310)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour monsieur ROUGETET,<br><br>Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.<br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nous prendrons contact avec vous rapidement pour programmer l\'intervention. En attendant, n\'hésitez pas à nous contacter si vous avez la moindre question ou besoin de clarification sur certains points.<br><br>\r\n                                Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.<br><br>\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>\r\n','/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5770-1172-800-1§Devis_DV-METZ-310_10_12_2025_13h_12m_signe.pdf;/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5771-1173-163-1§Attestation_fiscale_DV_METZ_310_10_12_2025_13h_12m_signe.pdf','0','v2017b' )
UID:--091937-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3836')  LIMIT 1 
UID:--091937-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251211','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-310','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Devis signé</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Devis signé (Devis N° DV-METZ-310)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour,<br><br>Le devis n°DV-METZ-310 de monsieur ROUGETET a été signé électroniquement.</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--091937-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3837')  LIMIT 1 
UID:--091937-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-147',`att3`='',`att2`='Maison individuelle - Sols - OGY MONTOY FLANVILLE',`att90`='8l7ewhqau96msxjt',`attf100`='20251211',`att5`='4891',`att8`='8',`att9`='1014.9',`att10`='101.49',`att11`='1116.39',`att13`='chèque ou virement',`att14`='2867',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  13 Rue du Cugnot 57645 MONTOY-FLANVILLE',`att18`='0',`att29`='1014.9',`att24`='1116.39',`att25`='13 Rue du Cugnot',`att26`='',`att27`='57645',`att28`='MONTOY-FLANVILLE',`att41`='',`att42`='',`att39`='',`attdatmod`='202512110919',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2881')  AND (id_type = '168')  LIMIT 1 
UID:--091937-- UPDATE  `vent_lig`  SET `lig1`='114',`lig7`='101.49',`lig9`='114',`lig16`='114',`lig91`='<b>Nettoyage de la terrasse (1)</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='51',`lig2`='19.90',`lig5`='10',`lig4`='1014.90',`lig8`='1116.39',`lig10`='euro',`lig6`='1116.39',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202512110919',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2881')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6121')  LIMIT 1 
UID:--091937-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-147',`att3`='',`att2`='Maison individuelle - Sols - OGY MONTOY FLANVILLE',`att90`='8l7ewhqau96msxjt',`attf100`='20251211',`att5`='4891',`att8`='8',`att9`='1014.9',`att10`='101.49',`att11`='1116.39',`att13`='chèque ou virement',`att14`='2867',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  13 Rue du Cugnot 57645 MONTOY-FLANVILLE',`att18`='-2.2737367544323E-13',`att29`='1014.9',`att24`='1116.39',`att25`='13 Rue du Cugnot',`att26`='',`att27`='57645',`att28`='MONTOY-FLANVILLE',`att41`='',`att42`='',`att39`='',`att31`='101.49',`attdatmod`='202512110919',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2881')  AND (id_type = '168')  LIMIT 1 
UID:--091937-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='1',`attdatmod`='202512110919',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2868')  AND (id_type = '148')  LIMIT 1 
UID:--091937-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202512110919',`attdatmod`='202512110919',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2867')  AND (id_type = '165')  LIMIT 1 
UID:--091937-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202512110919',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4891')  AND (id_type = '80')  LIMIT 1 
UID:--092037--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--092037--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--092059--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--092059-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202512110920' )
UID:--092059-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle - Façades - OGY MONTOY FLANVILLE',`att90`='ve4qij5hdqjiduab',`attf100`='20251211',`att5`='4891',`att8`='8',`att9`='2196.56',`att10`='219.66',`att11`='2416.22',`att13`='chèque ou virement',`att14`='2866',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  13 Rue du Cugnot 57645 MONTOY-FLANVILLE',`att18`='483.24',`att29`='1757.25',`att24`='1932.98',`att25`='13 Rue du Cugnot',`att26`='',`att27`='57645',`att28`='MONTOY-FLANVILLE',`att41`='pourcentage',`att42`='20',`attdatmod`='202512110920',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2882')  AND (id_type = '168')  LIMIT 1 
UID:--092059-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '2882')  LIMIT 1 
UID:--092059-- UPDATE  `tier_lig`  SET `lig2`='148',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '8')  LIMIT 1 
UID:--092059-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-148',`att3`='',`att2`='Maison individuelle - Façades - OGY MONTOY FLANVILLE',`att90`='ve4qij5hdqjiduab',`attf100`='20251211',`att5`='4891',`att8`='8',`att9`='2196.56',`att10`='219.66',`att11`='2416.22',`att13`='chèque ou virement',`att14`='2866',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  13 Rue du Cugnot 57645 MONTOY-FLANVILLE',`att18`='483.24',`att29`='1757.25',`att24`='1932.98',`att25`='13 Rue du Cugnot',`att26`='',`att27`='57645',`att28`='MONTOY-FLANVILLE',`att41`='pourcentage',`att42`='20',`attdatmod`='202512110920',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2882')  AND (id_type = '168')  LIMIT 1 
UID:--092059-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2882','202512110920','202512110920' )
UID:--092059-- UPDATE  `vent_lig`  SET `actif`='1',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='<p>FACADE LATERALE DROITE</p>',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6122')  LIMIT 1 
UID:--092059-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2882','202512110920','202512110920' )
UID:--092059-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='18',`lig7`='40.56',`lig9`='18',`lig16`='m2',`lig91`='<b>Nettoyage et désinfection</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)</p>',`lig3`='31.2',`lig2`='13.00',`lig5`='10',`lig4`='405.60',`lig8`='446.16',`lig10`='pourcentage',`lig11`='20',`lig6`='356.93',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)&lt;/p&gt;',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6123')  LIMIT 1 
UID:--092059-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2882','202512110920','202512110920' )
UID:--092059-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='26',`lig7`='21.53',`lig9`='26',`lig16`='m2',`lig91`='<b>Imperméabilisation</b><br /><p>ImperGuard® Ultra </p><p>Protège les matériaux poreux contre la pénétration des eaux pluviales et supprime ainsi les effets néfastes dus aux infiltrations, pluies acides, érosion, cycle gel/dégel, formation de mousses, dépôts verts et lichens...</p><p>• Propriétés anti-taches qui limitent de façon durable la pénétration de tous types de salissures même grasses.</p><p>• Effet reminéralisant renforçant la pierre contre les infiltrations.</p><p>• Produit d’imprégnation non filmogène de nouvelle génération. Il est incolore après application, il ne modifie pas la nature du support traité. Très bonne résistance aux U.V, il ne jaunit pas.<br>Respectueux de l’environnement et écologique:</p><p>• Sans solvants pétroliers.</p><p>• Non dangereux.</p><p>• Biodégradable à plus de 90%.</p><p>• COV < 2 g/l</p><p><br></p>',`lig3`='31.2',`lig2`='6.90',`lig5`='10',`lig4`='215.28',`lig8`='236.81',`lig10`='pourcentage',`lig11`='20',`lig6`='189.45',`lig90`='&lt;p&gt;ImperGuard® Ultra &lt;/p&gt;&lt;p&gt;Protège les matériaux poreux contre la pénétration des eaux pluviales et supprime ainsi les effets néfastes dus aux infiltrations, pluies acides, érosion, cycle gel/dégel, formation de mousses, dépôts verts et lichens...&lt;/p&gt;&lt;p&gt;• Propriétés anti-taches qui limitent de façon durable la pénétration de tous types de salissures même grasses.&lt;/p&gt;&lt;p&gt;• Effet reminéralisant renforçant la pierre contre les infiltrations.&lt;/p&gt;&lt;p&gt;• Produit d’imprégnation non filmogène de nouvelle génération. Il est incolore après application, il ne modifie pas la nature du support traité. Très bonne résistance aux U.V, il ne jaunit pas.&lt;br&gt;Respectueux de l’environnement et écologique:&lt;/p&gt;&lt;p&gt;• Sans solvants pétroliers.&lt;/p&gt;&lt;p&gt;• Non dangereux.&lt;/p&gt;&lt;p&gt;• Biodégradable à plus de 90%.&lt;/p&gt;&lt;p&gt;• COV &lt; 2 g/l&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6124')  LIMIT 1 
UID:--092059-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2882','202512110920','202512110920' )
UID:--092059-- UPDATE  `vent_lig`  SET `actif`='1',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='<p>FACADE + ANGLE DROIT</p>',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6125')  LIMIT 1 
UID:--092059-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2882','202512110920','202512110920' )
UID:--092059-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='18',`lig7`='57.72',`lig9`='18',`lig16`='m2',`lig91`='<b>Nettoyage et désinfection</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)</p>',`lig3`='44.4',`lig2`='13.00',`lig5`='10',`lig4`='577.20',`lig8`='634.92',`lig10`='pourcentage',`lig11`='20',`lig6`='507.94',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)&lt;/p&gt;',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6126')  LIMIT 1 
UID:--092059-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2882','202512110920','202512110920' )
UID:--092059-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='26',`lig7`='30.64',`lig9`='26',`lig16`='m2',`lig91`='<b>Imperméabilisation</b><br /><p>ImperGuard® Ultra </p><p>Protège les matériaux poreux contre la pénétration des eaux pluviales et supprime ainsi les effets néfastes dus aux infiltrations, pluies acides, érosion, cycle gel/dégel, formation de mousses, dépôts verts et lichens...</p><p>• Propriétés anti-taches qui limitent de façon durable la pénétration de tous types de salissures même grasses.</p><p>• Effet reminéralisant renforçant la pierre contre les infiltrations.</p><p>• Produit d’imprégnation non filmogène de nouvelle génération. Il est incolore après application, il ne modifie pas la nature du support traité. Très bonne résistance aux U.V, il ne jaunit pas.<br>Respectueux de l’environnement et écologique:</p><p>• Sans solvants pétroliers.</p><p>• Non dangereux.</p><p>• Biodégradable à plus de 90%.</p><p>• COV < 2 g/l</p><p><br></p>',`lig3`='44.4',`lig2`='6.90',`lig5`='10',`lig4`='306.36',`lig8`='337.00',`lig10`='pourcentage',`lig11`='20',`lig6`='269.60',`lig90`='&lt;p&gt;ImperGuard® Ultra &lt;/p&gt;&lt;p&gt;Protège les matériaux poreux contre la pénétration des eaux pluviales et supprime ainsi les effets néfastes dus aux infiltrations, pluies acides, érosion, cycle gel/dégel, formation de mousses, dépôts verts et lichens...&lt;/p&gt;&lt;p&gt;• Propriétés anti-taches qui limitent de façon durable la pénétration de tous types de salissures même grasses.&lt;/p&gt;&lt;p&gt;• Effet reminéralisant renforçant la pierre contre les infiltrations.&lt;/p&gt;&lt;p&gt;• Produit d’imprégnation non filmogène de nouvelle génération. Il est incolore après application, il ne modifie pas la nature du support traité. Très bonne résistance aux U.V, il ne jaunit pas.&lt;br&gt;Respectueux de l’environnement et écologique:&lt;/p&gt;&lt;p&gt;• Sans solvants pétroliers.&lt;/p&gt;&lt;p&gt;• Non dangereux.&lt;/p&gt;&lt;p&gt;• Biodégradable à plus de 90%.&lt;/p&gt;&lt;p&gt;• COV &lt; 2 g/l&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6127')  LIMIT 1 
UID:--092059-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2882','202512110920','202512110920' )
UID:--092059-- UPDATE  `vent_lig`  SET `actif`='1',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='<p>FACADE ARRIERE</p>',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6128')  LIMIT 1 
UID:--092059-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2882','202512110920','202512110920' )
UID:--092059-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='18',`lig7`='45.21',`lig9`='18',`lig16`='m2',`lig91`='<b>Nettoyage et désinfection</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)</p>',`lig3`='34.78',`lig2`='13.00',`lig5`='10',`lig4`='452.14',`lig8`='497.35',`lig10`='pourcentage',`lig11`='20',`lig6`='397.88',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)&lt;/p&gt;',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6129')  LIMIT 1 
UID:--092059-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2882','202512110920','202512110920' )
UID:--092059-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='26',`lig7`='24.00',`lig9`='26',`lig16`='m2',`lig91`='<b>Imperméabilisation</b><br /><p>ImperGuard® Ultra </p><p>Protège les matériaux poreux contre la pénétration des eaux pluviales et supprime ainsi les effets néfastes dus aux infiltrations, pluies acides, érosion, cycle gel/dégel, formation de mousses, dépôts verts et lichens...</p><p>• Propriétés anti-taches qui limitent de façon durable la pénétration de tous types de salissures même grasses.</p><p>• Effet reminéralisant renforçant la pierre contre les infiltrations.</p><p>• Produit d’imprégnation non filmogène de nouvelle génération. Il est incolore après application, il ne modifie pas la nature du support traité. Très bonne résistance aux U.V, il ne jaunit pas.<br>Respectueux de l’environnement et écologique:</p><p>• Sans solvants pétroliers.</p><p>• Non dangereux.</p><p>• Biodégradable à plus de 90%.</p><p>• COV < 2 g/l</p><p><br></p>',`lig3`='34.78',`lig2`='6.90',`lig5`='10',`lig4`='239.98',`lig8`='263.98',`lig10`='pourcentage',`lig11`='20',`lig6`='211.18',`lig90`='&lt;p&gt;ImperGuard® Ultra &lt;/p&gt;&lt;p&gt;Protège les matériaux poreux contre la pénétration des eaux pluviales et supprime ainsi les effets néfastes dus aux infiltrations, pluies acides, érosion, cycle gel/dégel, formation de mousses, dépôts verts et lichens...&lt;/p&gt;&lt;p&gt;• Propriétés anti-taches qui limitent de façon durable la pénétration de tous types de salissures même grasses.&lt;/p&gt;&lt;p&gt;• Effet reminéralisant renforçant la pierre contre les infiltrations.&lt;/p&gt;&lt;p&gt;• Produit d’imprégnation non filmogène de nouvelle génération. Il est incolore après application, il ne modifie pas la nature du support traité. Très bonne résistance aux U.V, il ne jaunit pas.&lt;br&gt;Respectueux de l’environnement et écologique:&lt;/p&gt;&lt;p&gt;• Sans solvants pétroliers.&lt;/p&gt;&lt;p&gt;• Non dangereux.&lt;/p&gt;&lt;p&gt;• Biodégradable à plus de 90%.&lt;/p&gt;&lt;p&gt;• COV &lt; 2 g/l&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;',`ligdatmod`='202512110920',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6130')  LIMIT 1 
UID:--092100-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1174','1','2','Devis_DV-METZ-309_10_12_2025_13h_10m_signe.pdf','20251211','661','devis_signe','168','2882','-2','-1','' )
UID:--092100-- UPDATE  `file`  SET `size`='741334'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5772')  LIMIT 1 
UID:--092100-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1175','1','2','Attestation_fiscale_DV_METZ_309_10_12_2025_13h_08m_signe.pdf','20251211','219','attestation_signe','168','2882','-2','-1','' )
UID:--092100-- UPDATE  `file`  SET `size`='730048'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5773')  LIMIT 1 
UID:--092100-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251211','','1','contact@exteco.fr','Exteco','patrick.rougetet@orange.fr','','','Merci pour votre commande : Devis N°DV-METZ-309','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouveau Devis EXTECO</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Merci pour votre commande (Devis N° DV-METZ-309)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour monsieur ROUGETET,<br><br>Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.<br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nous prendrons contact avec vous rapidement pour programmer l\'intervention. En attendant, n\'hésitez pas à nous contacter si vous avez la moindre question ou besoin de clarification sur certains points.<br><br>\r\n                                Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.<br><br>\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>\r\n','/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5772-1174-661-1§Devis_DV-METZ-309_10_12_2025_13h_10m_signe.pdf;/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5773-1175-219-1§Attestation_fiscale_DV_METZ_309_10_12_2025_13h_08m_signe.pdf','0','v2017b' )
UID:--092100-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3838')  LIMIT 1 
UID:--092100-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251211','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-309','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Devis signé</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Devis signé (Devis N° DV-METZ-309)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour,<br><br>Le devis n°DV-METZ-309 de monsieur ROUGETET a été signé électroniquement.</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--092100-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3839')  LIMIT 1 
UID:--092100-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-148',`att3`='',`att2`='Maison individuelle - Façades - OGY MONTOY FLANVILLE',`att90`='ve4qij5hdqjiduab',`attf100`='20251211',`att5`='4891',`att8`='8',`att9`='2196.56',`att10`='219.66',`att11`='2416.22',`att13`='chèque ou virement',`att14`='2866',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  13 Rue du Cugnot 57645 MONTOY-FLANVILLE',`att18`='483.24',`att29`='1757.25',`att24`='1932.98',`att25`='13 Rue du Cugnot',`att26`='',`att27`='57645',`att28`='MONTOY-FLANVILLE',`att41`='pourcentage',`att42`='20',`att39`='',`attdatmod`='202512110921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2882')  AND (id_type = '168')  LIMIT 1 
UID:--092100-- UPDATE  `vent_lig`  SET `lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='<p>FACADE LATERALE DROITE</p>',`lig3`='1',`lig4`='0.00',`lig8`='0.00',`lig6`='0.00',`ligdatmod`='202512110921',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2882')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6122')  LIMIT 1 
UID:--092100-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-148',`att3`='',`att2`='Maison individuelle - Façades - OGY MONTOY FLANVILLE',`att90`='ve4qij5hdqjiduab',`attf100`='20251211',`att5`='4891',`att8`='8',`att9`='2196.562',`att10`='219.6562',`att11`='2416.2182',`att13`='chèque ou virement',`att14`='2866',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  13 Rue du Cugnot 57645 MONTOY-FLANVILLE',`att18`='483.2382',`att29`='1757.25',`att24`='1932.98',`att25`='13 Rue du Cugnot',`att26`='',`att27`='57645',`att28`='MONTOY-FLANVILLE',`att41`='pourcentage',`att42`='20',`att39`='',`att31`='175.73',`attdatmod`='202512110921',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2882')  AND (id_type = '168')  LIMIT 1 
UID:--092100-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='6',`attdatmod`='202512110921',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2832')  AND (id_type = '148')  LIMIT 1 
UID:--092100-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202512110921',`attdatmod`='202512110921',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2866')  AND (id_type = '165')  LIMIT 1 
UID:--094704--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:--094704--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--095634--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--095634--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--100115--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--100115--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--100115-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('2','1','','a:4:{s:4:\"cate\";s:3:\"P06\";s:4:\"page\";s:2:\"20\";s:7:\"id_type\";i:80;s:7:\"id_obje\";s:4:\"3802\";}','s:0:\"\";','20251211','1001' )
UID:2--100115-- UPDATE  `nav_link`  SET `rand`='OTMtbG5rLTE3OTE2LTc4'  WHERE 1=1  AND (id_link = '17916')  LIMIT 1 
UID:2--100116--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--100116--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--100618--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--100618--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--101625--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--101625--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--101957--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--101957--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--102352--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--102352--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--102543--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--102543--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--102802--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--102802--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--103359--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--103359--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--103536--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--103536--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--103756--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--103756--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--104019--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:2--104019--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--113615--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--113615--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--113710--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--113710--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:4--113849--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:4--113849--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--114050--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--114050--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--121140--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--121140--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--131623--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--131623--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--131642--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--131642--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:7--131721--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('4601','1','2','Attestation_fiscale_Aubertin.pdf','20251211','751','7','-3','-2')
UID:7--131721--UPDATE `file` SET `last`='1' , `size`='245077' , `fol_id`='2' , `esp_id`='1' WHERE file_id=5778
UID:7--131721--UPDATE `file` SET `id_type`='168' , `id_obje`='2883' , `specif`='attestation_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=5778
UID:7--131721--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=5778
UID:7--131721--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:7--131721--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','7','2','5778','4601','Attestation_fiscale_Aubertin.pdf','1','20251211','13:17:21','upload')
UID:7--131800--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('4602','1','2','Devis Aubertin.pdf','20251211','963','7','-3','-2')
UID:7--131800--UPDATE `file` SET `last`='1' , `size`='1646139' , `fol_id`='2' , `esp_id`='1' WHERE file_id=5779
UID:7--131800--UPDATE `file` SET `id_type`='168' , `id_obje`='2883' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=5779
UID:7--131800--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=5779
UID:7--131800--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:7--131800--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','7','2','5779','4602','Devis Aubertin.pdf','1','20251211','13:18:00','upload')
UID:7--131812--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:7--131812--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:7--131812-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('7','1','','a:4:{s:4:\"cate\";s:3:\"P06\";s:4:\"page\";s:2:\"20\";s:7:\"id_type\";i:80;s:7:\"id_obje\";s:4:\"4901\";}','s:0:\"\";','20251211','1318' )
UID:7--131812-- UPDATE  `nav_link`  SET `rand`='Mi1sbmstMTc5NjItMzQ='  WHERE 1=1  AND (id_link = '17962')  LIMIT 1 
UID:7--131812-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('7','1','','a:4:{s:4:\"cate\";s:3:\"P06\";s:4:\"page\";s:2:\"20\";s:7:\"id_type\";i:165;s:7:\"id_obje\";s:4:\"2841\";}','s:0:\"\";','20251211','1318' )
UID:7--131812-- UPDATE  `nav_link`  SET `rand`='OTgtbG5rLTE3OTYzLTM4'  WHERE 1=1  AND (id_link = '17963')  LIMIT 1 
UID:--133215--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--133215--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--140352--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--140352--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--141755--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--141755--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--143114--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--143114--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--143814--SELECT mu.* FROM my_user mu, my_base_right mbr WHERE mbr.base_id=1 AND mbr.user_id=mu.user_id AND mbr.droit>0 
UID:--143814-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202512111438' )
UID:--143814-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='NETTOYAGE FACADES',`att90`='5zt5ypx83qg3xn6t',`attf100`='20251211',`att5`='4815',`att8`='10',`att9`='696.5',`att10`='69.65',`att11`='766.15',`att13`='chèque ou virement',`att14`='2715',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Sables d\'Olonnes</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>ZI les Plesses, 21 Rue Henri Farman<br>\n                    85180 Les Sab',`att16`='  Lotissement de la Chapelle 85230 Bouin',`att18`='0',`att29`='696.5',`att24`='766.15',`att25`='Lotissement de la Chapelle',`att26`='',`att27`='85230',`att28`='Bouin',`att41`='',`att42`='',`attdatmod`='202512111438',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2884')  AND (id_type = '168')  LIMIT 1 
UID:--143814-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '2884')  LIMIT 1 
UID:--143814-- UPDATE  `tier_lig`  SET `lig2`='55',`ligdatmod`='202512111438',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '4')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '13')  LIMIT 1 
UID:--143814-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-LSDO-55',`att3`='',`att2`='NETTOYAGE FACADES',`att90`='5zt5ypx83qg3xn6t',`attf100`='20251211',`att5`='4815',`att8`='10',`att9`='696.5',`att10`='69.65',`att11`='766.15',`att13`='chèque ou virement',`att14`='2715',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Sables d\'Olonnes</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>ZI les Plesses, 21 Rue Henri Farman<br>\n                    85180 Les Sab',`att16`='  Lotissement de la Chapelle 85230 Bouin',`att18`='0',`att29`='696.5',`att24`='766.15',`att25`='Lotissement de la Chapelle',`att26`='',`att27`='85230',`att28`='Bouin',`att41`='',`att42`='',`attdatmod`='202512111438',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2884')  AND (id_type = '168')  LIMIT 1 
UID:--143814-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2884','202512111438','202512111438' )
UID:--143814-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='19',`lig7`='45.50',`lig9`='19',`lig16`='m2',`lig91`='<b>Nettoyage et désinfection</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)</p>',`lig3`='35',`lig2`='13.00',`lig5`='10',`lig4`='455.00',`lig8`='500.50',`lig10`='euro',`lig6`='500.50',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)&lt;/p&gt;',`ligdatmod`='202512111438',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2884')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6144')  LIMIT 1 
UID:--143814-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2884','202512111438','202512111438' )
UID:--143814-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='27',`lig7`='24.15',`lig9`='27',`lig16`='m2',`lig91`='<b>Imperméabilisation</b><br /><p>ImperGuard® Ultra </p><p>Protège les matériaux poreux contre la pénétration des eaux pluviales et supprime ainsi les effets néfastes dus aux infiltrations, pluies acides, érosion, cycle gel/dégel, formation de mousses, dépôts verts et lichens...</p><p>• Propriétés anti-taches qui limitent de façon durable la pénétration de tous types de salissures même grasses.</p><p>• Effet reminéralisant renforçant la pierre contre les infiltrations.</p><p>• Produit d’imprégnation non filmogène de nouvelle génération. Il est incolore après application, il ne modifie pas la nature du support traité. Très bonne résistance aux U.V, il ne jaunit pas.<br>Respectueux de l’environnement et écologique:</p><p>• Sans solvants pétroliers.</p><p>• Non dangereux.</p><p>• Biodégradable à plus de 90%.</p><p>• COV < 2 g/l</p><p><br></p>',`lig3`='35',`lig2`='6.90',`lig5`='10',`lig4`='241.50',`lig8`='265.65',`lig10`='euro',`lig6`='265.65',`lig90`='&lt;p&gt;ImperGuard® Ultra &lt;/p&gt;&lt;p&gt;Protège les matériaux poreux contre la pénétration des eaux pluviales et supprime ainsi les effets néfastes dus aux infiltrations, pluies acides, érosion, cycle gel/dégel, formation de mousses, dépôts verts et lichens...&lt;/p&gt;&lt;p&gt;• Propriétés anti-taches qui limitent de façon durable la pénétration de tous types de salissures même grasses.&lt;/p&gt;&lt;p&gt;• Effet reminéralisant renforçant la pierre contre les infiltrations.&lt;/p&gt;&lt;p&gt;• Produit d’imprégnation non filmogène de nouvelle génération. Il est incolore après application, il ne modifie pas la nature du support traité. Très bonne résistance aux U.V, il ne jaunit pas.&lt;br&gt;Respectueux de l’environnement et écologique:&lt;/p&gt;&lt;p&gt;• Sans solvants pétroliers.&lt;/p&gt;&lt;p&gt;• Non dangereux.&lt;/p&gt;&lt;p&gt;• Biodégradable à plus de 90%.&lt;/p&gt;&lt;p&gt;• COV &lt; 2 g/l&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;',`ligdatmod`='202512111438',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2884')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6145')  LIMIT 1 
UID:--143814-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1178','1','2','Devis_DV-LSDO-181_28_11_2025_10h_23m_signe.pdf','20251211','969','devis_signe','168','2884','-2','-1','' )
UID:--143814-- UPDATE  `file`  SET `size`='1375779'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5790')  LIMIT 1 
UID:--143815-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1179','1','2','Attestation_fiscale_DV_LSDO_181_28_11_2025_10h_20m_signe.pdf','20251211','76','attestation_signe','168','2884','-2','-1','' )
UID:--143815-- UPDATE  `file`  SET `size`='810909'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5791')  LIMIT 1 
UID:--143815-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251211','','1','contact@exteco.fr','Exteco','johannadruaultaubin@gmail.com','','','Merci pour votre commande : Devis N°DV-LSDO-181','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouveau Devis EXTECO</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Merci pour votre commande (Devis N° DV-LSDO-181)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour madame DRUAULT AUBIN,<br><br>Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.<br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nous prendrons contact avec vous rapidement pour programmer l\'intervention. En attendant, n\'hésitez pas à nous contacter si vous avez la moindre question ou besoin de clarification sur certains points.<br><br>\r\n                                Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.<br><br>\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>\r\n','/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5790-1178-969-1§Devis_DV-LSDO-181_28_11_2025_10h_23m_signe.pdf;/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5791-1179-76-1§Attestation_fiscale_DV_LSDO_181_28_11_2025_10h_20m_signe.pdf','0','v2017b' )
UID:--143815-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3849')  LIMIT 1 
UID:--143815-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251211','','1','contact@exteco.fr','Exteco','agence-sablesdolonne@exteco.fr','','','Devis signé - N° DV-LSDO-181','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Devis signé</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Devis signé (Devis N° DV-LSDO-181)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour,<br><br>Le devis n°DV-LSDO-181 de madame DRUAULT AUBIN a été signé électroniquement.</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>','','0','v2017b' )
UID:--143815-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3850')  LIMIT 1 
UID:--143815-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-LSDO-55',`att3`='',`att2`='NETTOYAGE FACADES',`att90`='5zt5ypx83qg3xn6t',`attf100`='20251211',`att5`='4815',`att8`='10',`att9`='696.5',`att10`='69.65',`att11`='766.15',`att13`='chèque ou virement',`att14`='2715',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Sables d\'Olonnes</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>ZI les Plesses, 21 Rue Henri Farman<br>\n                    85180 Les Sab',`att16`='  Lotissement de la Chapelle 85230 Bouin',`att18`='0',`att29`='696.5',`att24`='766.15',`att25`='Lotissement de la Chapelle',`att26`='',`att27`='85230',`att28`='Bouin',`att41`='',`att42`='',`att39`='',`attdatmod`='202512111438',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2884')  AND (id_type = '168')  LIMIT 1 
UID:--143815-- UPDATE  `vent_lig`  SET `lig1`='19',`lig7`='45.50',`lig9`='19',`lig16`='19',`lig91`='<b>Nettoyage et désinfection</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)</p>',`lig3`='35',`lig2`='13.00',`lig5`='10',`lig4`='455.00',`lig8`='500.50',`lig10`='euro',`lig6`='500.50',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression  (de 30 à 60 bars maximum)&lt;/p&gt;',`ligdatmod`='202512111438',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2884')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '6144')  LIMIT 1 
UID:--143815-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-LSDO-55',`att3`='',`att2`='NETTOYAGE FACADES',`att90`='5zt5ypx83qg3xn6t',`attf100`='20251211',`att5`='4815',`att8`='10',`att9`='696.5',`att10`='69.65',`att11`='766.15',`att13`='chèque ou virement',`att14`='2715',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Sables d\'Olonnes</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>ZI les Plesses, 21 Rue Henri Farman<br>\n                    85180 Les Sab',`att16`='  Lotissement de la Chapelle 85230 Bouin',`att18`='0',`att29`='696.5',`att24`='766.15',`att25`='Lotissement de la Chapelle',`att26`='',`att27`='85230',`att28`='Bouin',`att41`='',`att42`='',`att39`='',`att31`='69.65',`attdatmod`='202512111438',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2884')  AND (id_type = '168')  LIMIT 1 
UID:--143816-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='15',`attdatmod`='202512111438',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2689')  AND (id_type = '148')  LIMIT 1 
UID:--143816-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202512111438',`attdatmod`='202512111438',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2715')  AND (id_type = '165')  LIMIT 1 
UID:--143816-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202512111438',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4815')  AND (id_type = '80')  LIMIT 1 
UID:--144615--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--144615--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--151256--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--151256--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--154713--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--154713--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--154808--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--154808--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--161903--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--161903--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--163604--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (58,59,88)
        ORDER BY pm.ordre
UID:--163604--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--170551--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--170551--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--171520--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90)
        ORDER BY pm.ordre
UID:--171520--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--171546--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (90)
        ORDER BY pm.ordre
UID:1--171546--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--172542--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--172542--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--180125--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--180125--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--180758--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:--180758--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre