UID:--081515--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:--081515-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202510190815' )
UID:--081515-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='maison individuelle - façade - Epinal',`att90`='fc4s6jnsuql0mhwu',`attf100`='20251019',`att5`='4342',`att8`='2',`att9`='1297.48',`att10`='129.75',`att11`='1427.23',`att13`='chèque ou virement',`att14`='1987',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='7 rue du point de vue 88000 EPINAL',`att18`='142.73',`att29`='1167.73',`att24`='1284.5',`att25`='7 rue du point de vue',`att26`='',`att27`='88000',`att28`='EPINAL',`att41`='pourcentage',`att42`='10',`attdatmod`='202510190815',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2250')  AND (id_type = '168')  LIMIT 1 
UID:--081515-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '2250')  LIMIT 1 
UID:--081515-- UPDATE  `tier_lig`  SET `lig2`='151',`ligdatmod`='202510190815',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '3')  LIMIT 1 
UID:--081515-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-151',`att3`='',`att2`='maison individuelle - façade - Epinal',`att90`='fc4s6jnsuql0mhwu',`attf100`='20251019',`att5`='4342',`att8`='2',`att9`='1297.48',`att10`='129.75',`att11`='1427.23',`att13`='chèque ou virement',`att14`='1987',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='7 rue du point de vue 88000 EPINAL',`att18`='142.73',`att29`='1167.73',`att24`='1284.5',`att25`='7 rue du point de vue',`att26`='',`att27`='88000',`att28`='EPINAL',`att41`='pourcentage',`att42`='10',`attdatmod`='202510190815',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2250')  AND (id_type = '168')  LIMIT 1 
UID:--081515-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2250','202510190815','202510190815' )
UID:--081515-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='17',`lig7`='84.76',`lig9`='17',`lig16`='m2',`lig91`='<b>Nettoyage et désinfection</b><br />',`lig3`='65.2',`lig2`='13.00',`lig5`='10',`lig4`='847.60',`lig8`='932.36',`lig10`='pourcentage',`lig11`='10',`lig6`='839.12',`ligdatmod`='202510190815',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2250')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '4668')  LIMIT 1 
UID:--081515-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2250','202510190815','202510190815' )
UID:--081515-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='25',`lig7`='44.99',`lig9`='25',`lig16`='m2',`lig91`='<p>HydroGuard® Pro Formule Végétale protège durablement tous les matériaux minéraux poreux et permet de prévenir les principales causes de dégradations comme les infiltrations, érosion, cycle gel/dégel, formation de mousses et lichens... Il retarde le vieillissement du support et garde son aspect neuf plus longtemps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit d’imprégnation incolore qui laisse respirer le matériau. Le support reste ainsi perméable à l’air et à la vapeur d’eau. De plus, il résiste parfaitement aux UV et ne jaunit pas dans le temps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit biosourcé issu de la biomasse. Il a été formulé à base d’ingrédients d’origine végétale (colza, tournesol, canola, soja). L’utilisation de molécules végétales représente une alternative éco-responsable aux ressources fossiles dommageables à l’environnement.</p>',`lig3`='65.2',`lig2`='6.90',`lig5`='10',`lig4`='449.88',`lig8`='494.87',`lig10`='pourcentage',`lig11`='10',`lig6`='445.38',`lig90`='&lt;p&gt;HydroGuard® Pro Formule Végétale protège durablement tous les matériaux minéraux poreux et permet de prévenir les principales causes de dégradations comme les infiltrations, érosion, cycle gel/dégel, formation de mousses et lichens... Il retarde le vieillissement du support et garde son aspect neuf plus longtemps.&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;HydroGuard® Pro Formule Végétale est un produit d’imprégnation incolore qui laisse respirer le matériau. Le support reste ainsi perméable à l’air et à la vapeur d’eau. De plus, il résiste parfaitement aux UV et ne jaunit pas dans le temps.&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;HydroGuard® Pro Formule Végétale est un produit biosourcé issu de la biomasse. Il a été formulé à base d’ingrédients d’origine végétale (colza, tournesol, canola, soja). L’utilisation de molécules végétales représente une alternative éco-responsable aux ressources fossiles dommageables à l’environnement.&lt;/p&gt;',`ligdatmod`='202510190815',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2250')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '4669')  LIMIT 1 
UID:--081515-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('905','1','2','Devis_DV-EPI-305_01_10_2025_09h_50m_signe.pdf','20251019','289','devis_signe','168','2250','-2','-1','' )
UID:--081515-- UPDATE  `file`  SET `size`='677764'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '4157')  LIMIT 1 
UID:--081515-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('906','1','2','Attestation_fiscale_DV_EPI_305_01_10_2025_09h_49m_signe.pdf','20251019','723','attestation_signe','168','2250','-2','-1','' )
UID:--081515-- UPDATE  `file`  SET `size`='834118'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '4158')  LIMIT 1 
UID:--081515-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251019','','1','contact@exteco.fr','Exteco','benoitchauvin@hotmail.com','','','Merci pour votre commande : Devis N°DV-EPI-305','<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-EPI-305)\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 CHAUVIN,<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','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/4157-905-289-1§Devis_DV-EPI-305_01_10_2025_09h_50m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/4158-906-723-1§Attestation_fiscale_DV_EPI_305_01_10_2025_09h_49m_signe.pdf','0','v2017b' )
UID:--081515-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '2433')  LIMIT 1 
UID:--081515-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251019','','1','contact@exteco.fr','Exteco','agence-epinal@exteco.fr','','','Devis signé - N° DV-EPI-305','<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-EPI-305)\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-EPI-305 de monsieur CHAUVIN 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:--081515-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '2434')  LIMIT 1 
UID:--081515-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-151',`att3`='',`att2`='maison individuelle - façade - Epinal',`att90`='fc4s6jnsuql0mhwu',`attf100`='20251019',`att5`='4342',`att8`='2',`att9`='1297.48',`att10`='129.75',`att11`='1427.23',`att13`='chèque ou virement',`att14`='1987',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='7 rue du point de vue 88000 EPINAL',`att18`='142.73',`att29`='1167.73',`att24`='1284.5',`att25`='7 rue du point de vue',`att26`='',`att27`='88000',`att28`='EPINAL',`att41`='pourcentage',`att42`='10',`att39`='',`attdatmod`='202510190815',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2250')  AND (id_type = '168')  LIMIT 1 
UID:--081515-- UPDATE  `vent_lig`  SET `lig1`='17',`lig7`='84.76',`lig9`='17',`lig16`='m2',`lig91`='<b>Nettoyage et désinfection</b><br />',`lig3`='65.2',`lig2`='13.00',`lig5`='10',`lig4`='847.60',`lig8`='932.36',`lig10`='pourcentage',`lig11`='10',`lig6`='839.12',`ligdatmod`='202510190815',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2250')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '4668')  LIMIT 1 
UID:--081515-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-151',`att3`='',`att2`='maison individuelle - façade - Epinal',`att90`='fc4s6jnsuql0mhwu',`attf100`='20251019',`att5`='4342',`att8`='2',`att9`='1297.48',`att10`='129.748',`att11`='1427.228',`att13`='chèque ou virement',`att14`='1987',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='7 rue du point de vue 88000 EPINAL',`att18`='142.728',`att29`='1167.73',`att24`='1284.5',`att25`='7 rue du point de vue',`att26`='',`att27`='88000',`att28`='EPINAL',`att41`='pourcentage',`att42`='10',`att39`='',`att31`='116.77',`attdatmod`='202510190815',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2250')  AND (id_type = '168')  LIMIT 1 
UID:--081516-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='18',`attdatmod`='202510190815',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1986')  AND (id_type = '148')  LIMIT 1 
UID:--081516-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202510190815',`attdatmod`='202510190815',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1987')  AND (id_type = '165')  LIMIT 1 
UID:--081516-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202510190815',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4342')  AND (id_type = '80')  LIMIT 1 
UID:--185351-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202510191853' )
UID:--185351-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Mathieu',`att1`='Moyon',`att8`='non_défini',`att12`='sandrinecoutand@lilo.org',`att14`='2 rue Jacques-Yves Cousteau',`att7`='85150',`att17`='LES ACHARDS',`att18`='France',`att5`='0618025184',`attf102`='20251019',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251019',`att26`='',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4511')  AND (id_type = '80')  LIMIT 1 
UID:--185351-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','4511','202510191853','202510191853' )
UID:--185351-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='2 rue Jacques-Yves Cousteau',`lig4`='85150',`lig5`='LES ACHARDS',`lig6`='France',`ligdatmod`='202510191853',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '4511')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '2272')  LIMIT 1 
UID:--185351-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Mathieu',`att1`='Moyon',`att8`='non_défini',`att12`='sandrinecoutand@lilo.org',`att14`='2 rue Jacques-Yves Cousteau',`att7`='85150',`att17`='LES ACHARDS',`att18`='France',`att5`='0618025184',`attf102`='20251019',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251019',`att26`='',`att19`='46.609887',`att20`='-1.66175',`attf100`='1',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4511')  AND (id_type = '80')  LIMIT 1 
UID:--185351-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Mathieu',`att1`='Moyon',`att8`='non_défini',`att12`='sandrinecoutand@lilo.org',`att14`='2 rue Jacques-Yves Cousteau',`att7`='85150',`att17`='LES ACHARDS',`att18`='France',`att5`='0618025184',`attf102`='20251019',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251019',`att26`='',`att19`='46.609887',`att20`='-1.66175',`attf100`='1',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4511')  AND (id_type = '80')  LIMIT 1 
UID:--185351-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202510191853' )
UID:--185351-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Moyon',`att3`='Mathieu',`att5`='0618025184',`att6`='sandrinecoutand@lilo.org',`att8`='4511',`att10`='[IDMYUSER]',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4512')  AND (id_type = '149')  LIMIT 1 
UID:--185351-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202510191853' )
UID:--185351-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-',`att2`='4511',`att90`='Bonjour,\r\nNous envisageons de faire nettoyer notre toiture (environ 100 m²) en tuiles, équipée de 9 panneaux solaires.\r\nPouvez-vous nous donner une idée de coût pour ce type d&#039;intervention ?\r\nMerci par avance.\r\nMr et Mme COUTAND-MOYON',`attf100`='20251019',`att8`='2272',`att6`='[IDMYUSER]',`att9`='4512',`att3`='§toiture§',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2251')  AND (id_type = '148')  LIMIT 1 
UID:--185351-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Moyon',`att2`='4511',`att90`='Bonjour,\r\nNous envisageons de faire nettoyer notre toiture (environ 100 m²) en tuiles, équipée de 9 panneaux solaires.\r\nPouvez-vous nous donner une idée de coût pour ce type d&#039;intervention ?\r\nMerci par avance.\r\nMr et Mme COUTAND-MOYON',`attf100`='20251019',`att8`='2272',`att6`='[IDMYUSER]',`att9`='4512',`att3`='§toiture§',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2251')  AND (id_type = '148')  LIMIT 1 
UID:--185351-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Moyon',`att2`='4511',`att90`='Bonjour,\r\nNous envisageons de faire nettoyer notre toiture (environ 100 m²) en tuiles, équipée de 9 panneaux solaires.\r\nPouvez-vous nous donner une idée de coût pour ce type d&#039;intervention ?\r\nMerci par avance.\r\nMr et Mme COUTAND-MOYON',`attf100`='20251019',`att8`='2272',`att6`='[IDMYUSER]',`att9`='4512',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2251')  AND (id_type = '148')  LIMIT 1 
UID:--185351-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Moyon',`att2`='4511',`att90`='Bonjour,\r\nNous envisageons de faire nettoyer notre toiture (environ 100 m²) en tuiles, équipée de 9 panneaux solaires.\r\nPouvez-vous nous donner une idée de coût pour ce type d&#039;intervention ?\r\nMerci par avance.\r\nMr et Mme COUTAND-MOYON',`attf100`='20251019',`att8`='2272',`att6`='0',`att9`='4512',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2251')  AND (id_type = '148')  LIMIT 1 
UID:--185351-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251019','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Moyon','<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>Nouvelle opportunite</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                                Nouvelle opportunité - OPP-Moyon</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,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Vous avez reçu une nouvelle demande de contact.<br><br>Coordonnées du contact :</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nom : Moyon</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Mathieu</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0618025184</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : sandrinecoutand@lilo.org</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Service : toiture</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Adresse : 2 rue Jacques-Yves Cousteau</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 85150</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : LES ACHARDS</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Bonjour,\r\nNous envisageons de faire nettoyer notre toiture (environ 100 m²) en tuiles, équipée de 9 panneaux solaires.\r\nPouvez-vous nous donner une idée de coût pour ce type d&#039;intervention ?\r\nMerci par avance.\r\nMr et Mme COUTAND-MOYON</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;\">Bonne prise de contact !&nbsp;&nbsp;</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\"><br></p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\"><font color=\"#ffffff\"><a href=\"https://exteco.toosmart.app/\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Consulter l\'opportunité\r\n                                                    </a></font></td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                \r\n                            </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:--185351-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '2435')  LIMIT 1 
UID:--185351--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:--185351-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Moyon',`att3`='Mathieu',`att5`='0618025184',`att6`='sandrinecoutand@lilo.org',`att8`='4511',`att10`='[IDMYUSER]',`att4`='0618025184',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4512')  AND (id_type = '149')  LIMIT 1 
UID:--185351-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Mathieu',`att1`='Moyon',`att8`='non_défini',`att12`='sandrinecoutand@lilo.org',`att14`='2 rue Jacques-Yves Cousteau',`att7`='85150',`att17`='LES ACHARDS',`att18`='France',`att5`='0618025184',`attf102`='20251019',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251019',`att26`='',`att19`='46.609887',`att20`='-1.66175',`attf100`='1',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4511')  AND (id_type = '80')  LIMIT 1 
UID:--185351-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Mathieu',`att1`='Moyon',`att8`='non_défini',`att12`='sandrinecoutand@lilo.org',`att14`='2 rue Jacques-Yves Cousteau',`att7`='85150',`att17`='LES ACHARDS',`att18`='France',`att5`='0618025184',`attf102`='20251019',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251019',`att26`='',`att19`='46.609887',`att20`='-1.66175',`attf100`='1',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4511')  AND (id_type = '80')  LIMIT 1 
UID:--185351-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Mathieu',`att1`='Moyon',`att8`='non_défini',`att12`='sandrinecoutand@lilo.org',`att14`='2 rue Jacques-Yves Cousteau',`att7`='85150',`att17`='LES ACHARDS',`att18`='France',`att5`='0618025184',`attf102`='20251019',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251019',`att26`='',`att19`='46.609887',`att20`='-1.66175',`attf100`='1',`att6`='0618025184',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4511')  AND (id_type = '80')  LIMIT 1 
UID:--185351-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Moyon',`att2`='4511',`att90`='Bonjour,\r\nNous envisageons de faire nettoyer notre toiture (environ 100 m²) en tuiles, équipée de 9 panneaux solaires.\r\nPouvez-vous nous donner une idée de coût pour ce type d&#039;intervention ?\r\nMerci par avance.\r\nMr et Mme COUTAND-MOYON',`attf100`='20251019',`att8`='2272',`att6`='0',`att9`='4512',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202510191853',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2251')  AND (id_type = '148')  LIMIT 1 
UID:--194053--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:--194053--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--194118--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--194118--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--195342--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--195342--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--195342-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('1','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:\"3196\";}','s:0:\"\";','20251019','1953' )
UID:1--195342-- UPDATE  `nav_link`  SET `rand`='Ny1sbmstMTA3NzItMzk='  WHERE 1=1  AND (id_link = '10772')  LIMIT 1 
UID:1--195342-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('1','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:\"1901\";}','s:0:\"\";','20251019','1953' )
UID:1--195342-- UPDATE  `nav_link`  SET `rand`='MzItbG5rLTEwNzczLTcy'  WHERE 1=1  AND (id_link = '10773')  LIMIT 1 
UID:1--195640--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--195640--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--200051--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--200051--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--200228--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--200228--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--200309--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:--200309--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--200310--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--200310--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--200320--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:--200320-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202510192003' )
UID:--200320-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='maison individuelle - toiture - Golbey',`att90`='ffouhbe0m8ufzvby',`attf100`='20251019',`att5`='4459',`att8`='2',`att9`='6629.05',`att10`='662.91',`att11`='7291.96',`att13`='chèque ou virement',`att14`='2248',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='2 rue de la Plaine 88190 GOLBEY',`att18`='1458.4',`att29`='5303.24',`att24`='5833.56',`att25`='2 rue de la Plaine',`att26`='',`att27`='88190',`att28`='GOLBEY',`att41`='pourcentage',`att42`='20',`attdatmod`='202510192003',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2252')  AND (id_type = '168')  LIMIT 1 
UID:--200320-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '2252')  LIMIT 1 
UID:--200320-- UPDATE  `tier_lig`  SET `lig2`='152',`ligdatmod`='202510192003',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '3')  LIMIT 1 
UID:--200320-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-152',`att3`='',`att2`='maison individuelle - toiture - Golbey',`att90`='ffouhbe0m8ufzvby',`attf100`='20251019',`att5`='4459',`att8`='2',`att9`='6629.05',`att10`='662.91',`att11`='7291.96',`att13`='chèque ou virement',`att14`='2248',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='2 rue de la Plaine 88190 GOLBEY',`att18`='1458.4',`att29`='5303.24',`att24`='5833.56',`att25`='2 rue de la Plaine',`att26`='',`att27`='88190',`att28`='GOLBEY',`att41`='pourcentage',`att42`='20',`attdatmod`='202510192003',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2252')  AND (id_type = '168')  LIMIT 1 
UID:--200320-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2252','202510192003','202510192003' )
UID:--200320-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='65',`lig7`='28.00',`lig9`='65',`lig16`='unite',`lig91`='<b>Forfait travail en hauteur (1)</b><br /><p><br></p>',`lig3`='1',`lig2`='280.00',`lig5`='10',`lig4`='280.00',`lig8`='308.00',`lig10`='pourcentage',`lig11`='20',`lig6`='246.40',`lig90`='&lt;p&gt;&lt;br&gt;&lt;/p&gt;',`ligdatmod`='202510192003',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2252')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '4670')  LIMIT 1 
UID:--200320-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2252','202510192003','202510192003' )
UID:--200320-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='9',`lig7`='402.35',`lig9`='9',`lig16`='m2',`lig91`='<b>Nettoyage et démoussage</b><br /><p>\r\n</p><div>Nettoyage et démoussage du support via un procédé vapeur basse pression (de 30 à 60 bars maximum)</div>',`lig3`='309.5',`lig2`='13.00',`lig5`='10',`lig4`='4023.50',`lig8`='4425.85',`lig10`='pourcentage',`lig11`='20',`lig6`='3540.68',`lig90`='&lt;p&gt;\r\n&lt;/p&gt;&lt;div&gt;Nettoyage et démoussage du support via un procédé vapeur basse pression (de 30 à 60 bars maximum)&lt;/div&gt;',`ligdatmod`='202510192003',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2252')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '4671')  LIMIT 1 
UID:--200320-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2252','202510192003','202510192003' )
UID:--200320-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='25',`lig7`='213.56',`lig9`='25',`lig16`='m2',`lig91`='<p>HydroGuard® Pro Formule Végétale protège durablement tous les matériaux minéraux poreux et permet de prévenir les principales causes de dégradations comme les infiltrations, érosion, cycle gel/dégel, formation de mousses et lichens... Il retarde le vieillissement du support et garde son aspect neuf plus longtemps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit d’imprégnation incolore qui laisse respirer le matériau. Le support reste ainsi perméable à l’air et à la vapeur d’eau. De plus, il résiste parfaitement aux UV et ne jaunit pas dans le temps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit biosourcé issu de la biomasse. Il a été formulé à base d’ingrédients d’origine végétale (colza, tournesol, canola, soja). L’utilisation de molécules végétales représente une alternative éco-responsable aux ressources fossiles dommageables à l’environnement.</p>',`lig3`='309.5',`lig2`='6.90',`lig5`='10',`lig4`='2135.55',`lig8`='2349.11',`lig10`='pourcentage',`lig11`='20',`lig6`='1879.28',`lig90`='&lt;p&gt;HydroGuard® Pro Formule Végétale protège durablement tous les matériaux minéraux poreux et permet de prévenir les principales causes de dégradations comme les infiltrations, érosion, cycle gel/dégel, formation de mousses et lichens... Il retarde le vieillissement du support et garde son aspect neuf plus longtemps.&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;HydroGuard® Pro Formule Végétale est un produit d’imprégnation incolore qui laisse respirer le matériau. Le support reste ainsi perméable à l’air et à la vapeur d’eau. De plus, il résiste parfaitement aux UV et ne jaunit pas dans le temps.&lt;/p&gt;&lt;p&gt;&lt;br&gt;&lt;/p&gt;&lt;p&gt;HydroGuard® Pro Formule Végétale est un produit biosourcé issu de la biomasse. Il a été formulé à base d’ingrédients d’origine végétale (colza, tournesol, canola, soja). L’utilisation de molécules végétales représente une alternative éco-responsable aux ressources fossiles dommageables à l’environnement.&lt;/p&gt;',`ligdatmod`='202510192003',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2252')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '4672')  LIMIT 1 
UID:--200320-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2252','202510192003','202510192003' )
UID:--200320-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='41',`lig7`='19.00',`lig9`='41',`lig16`='unite',`lig91`='<p>Nettoyage intérieur et extérieur des gouttières </p>',`lig3`='1',`lig2`='190.00',`lig5`='10',`lig4`='190.00',`lig8`='209.00',`lig10`='pourcentage',`lig11`='20',`lig6`='167.20',`lig90`='&lt;p&gt;Nettoyage intérieur et extérieur des gouttières&nbsp;&lt;/p&gt;',`ligdatmod`='202510192003',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2252')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '4673')  LIMIT 1 
UID:--200320-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('907','1','2','Devis_DV-EPI-348_17_10_2025_19h_09m_signe.pdf','20251019','654','devis_signe','168','2252','-2','-1','' )
UID:--200320-- UPDATE  `file`  SET `size`='407948'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '4159')  LIMIT 1 
UID:--200320-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('908','1','2','Attestation_fiscale_DV_EPI_348_17_10_2025_19h_07m_signe.pdf','20251019','916','attestation_signe','168','2252','-2','-1','' )
UID:--200320-- UPDATE  `file`  SET `size`='471942'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '4160')  LIMIT 1 
UID:--200320-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251019','','1','contact@exteco.fr','Exteco','djeanco@hotmail.com','','','Merci pour votre commande : Devis N°DV-EPI-348','<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-EPI-348)\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 JEANCOLAS,<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','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/4159-907-654-1§Devis_DV-EPI-348_17_10_2025_19h_09m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/4160-908-916-1§Attestation_fiscale_DV_EPI_348_17_10_2025_19h_07m_signe.pdf','0','v2017b' )
UID:--200320-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '2436')  LIMIT 1 
UID:--200320-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251019','','1','contact@exteco.fr','Exteco','agence-epinal@exteco.fr','','','Devis signé - N° DV-EPI-348','<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-EPI-348)\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-EPI-348 de monsieur JEANCOLAS 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:--200320-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '2437')  LIMIT 1 
UID:--200320-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-152',`att3`='',`att2`='maison individuelle - toiture - Golbey',`att90`='ffouhbe0m8ufzvby',`attf100`='20251019',`att5`='4459',`att8`='2',`att9`='6629.05',`att10`='662.91',`att11`='7291.96',`att13`='chèque ou virement',`att14`='2248',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='2 rue de la Plaine 88190 GOLBEY',`att18`='1458.4',`att29`='5303.24',`att24`='5833.56',`att25`='2 rue de la Plaine',`att26`='',`att27`='88190',`att28`='GOLBEY',`att41`='pourcentage',`att42`='20',`att39`='',`attdatmod`='202510192003',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2252')  AND (id_type = '168')  LIMIT 1 
UID:--200320-- UPDATE  `vent_lig`  SET `lig1`='65',`lig7`='28.00',`lig9`='65',`lig16`='unite',`lig91`='<b>Forfait travail en hauteur (1)</b><br /><p><br></p>',`lig3`='1',`lig2`='280.00',`lig5`='10',`lig4`='280.00',`lig8`='308.00',`lig10`='pourcentage',`lig11`='20',`lig6`='246.40',`lig90`='&lt;p&gt;&lt;br&gt;&lt;/p&gt;',`ligdatmod`='202510192003',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2252')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '4670')  LIMIT 1 
UID:--200321-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-152',`att3`='',`att2`='maison individuelle - toiture - Golbey',`att90`='ffouhbe0m8ufzvby',`attf100`='20251019',`att5`='4459',`att8`='2',`att9`='6629.05',`att10`='662.905',`att11`='7291.955',`att13`='chèque ou virement',`att14`='2248',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Epinal</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>2 rue de la Ballastière<br>\n                    88190 GOLBEY</p>\n                  ',`att16`='2 rue de la Plaine 88190 GOLBEY',`att18`='1458.395',`att29`='5303.24',`att24`='5833.56',`att25`='2 rue de la Plaine',`att26`='',`att27`='88190',`att28`='GOLBEY',`att41`='pourcentage',`att42`='20',`att39`='',`att31`='530.32',`attdatmod`='202510192003',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2252')  AND (id_type = '168')  LIMIT 1 
UID:--200321-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='8',`attdatmod`='202510192003',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2171')  AND (id_type = '148')  LIMIT 1 
UID:--200321-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202510192003',`attdatmod`='202510192003',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2248')  AND (id_type = '165')  LIMIT 1 
UID:--200321-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202510192003',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4459')  AND (id_type = '80')  LIMIT 1 
UID:--200345--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:--200345--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--200348--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--200348--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--200546--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--200546--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--200546-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('1','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:\"3196\";}','s:0:\"\";','20251019','2005' )
UID:1--200546-- UPDATE  `nav_link`  SET `rand`='ODItbG5rLTEwNzg0LTk='  WHERE 1=1  AND (id_link = '10784')  LIMIT 1 
UID:1--200546-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('1','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:\"1901\";}','s:0:\"\";','20251019','2005' )
UID:1--200546-- UPDATE  `nav_link`  SET `rand`='MTUtbG5rLTEwNzg1LTc1'  WHERE 1=1  AND (id_link = '10785')  LIMIT 1 
UID:1--200650--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--200650--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--200650-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('1','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:\"3196\";}','s:0:\"\";','20251019','2006' )
UID:1--200650-- UPDATE  `nav_link`  SET `rand`='MS1sbmstMTA3ODYtNTI='  WHERE 1=1  AND (id_link = '10786')  LIMIT 1 
UID:1--200650-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('1','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:\"1901\";}','s:0:\"\";','20251019','2006' )
UID:1--200650-- UPDATE  `nav_link`  SET `rand`='MS1sbmstMTA3ODctMTM='  WHERE 1=1  AND (id_link = '10787')  LIMIT 1 
UID:1--200743--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--200743--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:1--200743-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('1','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:\"3196\";}','s:0:\"\";','20251019','2007' )
UID:1--200743-- UPDATE  `nav_link`  SET `rand`='NTQtbG5rLTEwNzg5LTI='  WHERE 1=1  AND (id_link = '10789')  LIMIT 1 
UID:1--200743-- INSERT INTO  `nav_link`  (`id_user`,`id_base`,`titre`,`post`,`get`,`datee`,`heure` ) VALUES ('1','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:\"1901\";}','s:0:\"\";','20251019','2007' )
UID:1--200743-- UPDATE  `nav_link`  SET `rand`='ODQtbG5rLTEwNzkwLTgw'  WHERE 1=1  AND (id_link = '10790')  LIMIT 1 
UID:2--200830--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('3251','1','2','IMG_0466.jpeg','20251019','787','2','-3','-2')
UID:2--200830--UPDATE `file` SET `last`='1' , `size`='2040866' , `fol_id`='2' , `esp_id`='1' WHERE file_id=4161
UID:2--200830--UPDATE `file` SET `id_type`='168' , `id_obje`='2253' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=4161
UID:2--200830--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=4161
UID:2--200830--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:2--200830--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','4161','3251','IMG_0466.jpeg','1','20251019','20:08:30','upload')
UID:2--200840--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('3252','1','2','attestation (1).pdf','20251019','271','2','-3','-2')
UID:2--200840--UPDATE `file` SET `last`='1' , `size`='2293437' , `fol_id`='2' , `esp_id`='1' WHERE file_id=4162
UID:2--200840--UPDATE `file` SET `id_type`='168' , `id_obje`='2253' , `specif`='attestation_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=4162
UID:2--200840--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=4162
UID:2--200840--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:2--200840--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','4162','3252','attestation (1).pdf','1','20251019','20:08:40','upload')
UID:2--200846--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--200846--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:2--200846-- 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:\"4032\";}','s:0:\"\";','20251019','2008' )
UID:2--200846-- UPDATE  `nav_link`  SET `rand`='MTYtbG5rLTEwNzkyLTIy'  WHERE 1=1  AND (id_link = '10792')  LIMIT 1 
UID:2--200846-- 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:165;s:7:\"id_obje\";s:4:\"1710\";}','s:0:\"\";','20251019','2008' )
UID:2--200846-- UPDATE  `nav_link`  SET `rand`='MjktbG5rLTEwNzkzLTYz'  WHERE 1=1  AND (id_link = '10793')  LIMIT 1 
UID:--203945--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:--203945--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre