UID:7--145741-- 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:\"3026\";}','s:0:\"\";','20250814','1457' )
UID:7--145741-- UPDATE  `nav_link`  SET `rand`='ODQtbG5rLTI3MzEtOA=='  WHERE 1=1  AND (id_link = '2731')  LIMIT 1 
UID:7--145800-- 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:\"3026\";}','s:0:\"\";','20250814','1458' )
UID:7--145800-- UPDATE  `nav_link`  SET `rand`='MTktbG5rLTI3MzItMzU='  WHERE 1=1  AND (id_link = '2732')  LIMIT 1 
UID:7--145800-- 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:\"1207\";}','s:0:\"\";','20250814','1458' )
UID:7--145800-- UPDATE  `nav_link`  SET `rand`='NDAtbG5rLTI3MzMtOTQ='  WHERE 1=1  AND (id_link = '2733')  LIMIT 1 
UID:7--150116-- 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:\"3930\";}','s:0:\"\";','20250814','1501' )
UID:7--150116-- UPDATE  `nav_link`  SET `rand`='NzEtbG5rLTI3MzUtOTQ='  WHERE 1=1  AND (id_link = '2735')  LIMIT 1 
UID:7--153841-- UPDATE  `vent_lig`  SET `lig90`='Remise de 15% si validation de l\'ensemble des prestations soit 1014€ TTC',`ligdatmod`='202508141538',`ligusermod`='7'  WHERE 1=1  AND ( id_vent = '1419')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '2760')  LIMIT 1 
UID:7--153841-- UPDATE  `vent_lig`  SET `lig90`='Remise de 15% si validation de l\'ensemble des prestations soit 1014€ TTC',`lig91`='<b>REMISE</b><br />Remise de 15% si validation de l\'ensemble des prestations soit 1014€ TTC',`ligdatmod`='202508141538',`ligusermod`='7'  WHERE 1=1  AND ( id_vent = '1419')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '2760')  LIMIT 1 
UID:7--153841-- UPDATE  `vent_lig`  SET `lig90`='Remise de 15% si validation de l\'ensemble des prestations soit 1014€ TTC',`lig91`='<b>REMISE</b><br />Remise de 15% si validation de l\'ensemble des prestations soit 1014€ TTC',`ligdatmod`='202508141538',`ligusermod`='7'  WHERE 1=1  AND ( id_vent = '1419')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '2760')  LIMIT 1 
UID:7--153841-- UPDATE  `vent_att`  SET `att7`='6250',`att8`='625',`att9`='6875',`att21`='5861',`att27`='1014',`att28`='5328.18',`att29`='921.82',`att30`='532.82',`attdatmod`='202508141538',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1419')  AND (id_type = '165')  LIMIT 1 
UID:7--153841-- UPDATE  `vent_att`  SET `att7`='6250',`att8`='625',`att9`='6875',`att21`='5861',`att27`='1014',`att28`='5328.18',`att29`='921.82',`att30`='532.82',`att18`='<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></p>\n                    <br><p>agence-metz@exteco.fr</p>\n                    <br><span>www.rainea.fr</span>\n                </span>',`attdatmod`='202508141538',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1419')  AND (id_type = '165')  LIMIT 1 
UID:7--153856-- UPDATE  `vent_att`  SET `attf103`= NULL ,`attdatmod`='202508141538',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1419')  AND (id_type = '165')  LIMIT 1 
UID:7--153856-- UPDATE  `vent_att`  SET `attf103`= NULL ,`att7`='6250',`att8`='625',`att9`='6875',`att21`='5861',`att27`='1014',`att28`='5328.18',`att29`='921.82',`att30`='532.82',`attdatmod`='202508141538',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1419')  AND (id_type = '165')  LIMIT 1 
UID:7--153856-- UPDATE  `vent_att`  SET `attf103`= NULL ,`att7`='6250',`att8`='625',`att9`='6875',`att21`='5861',`att27`='1014',`att28`='5328.18',`att29`='921.82',`att30`='532.82',`att18`='<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></p>\n                    <br><p>agence-metz@exteco.fr</p>\n                    <br><span>www.rainea.fr</span>\n                </span>',`attdatmod`='202508141538',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1419')  AND (id_type = '165')  LIMIT 1 
UID:7--153856-- 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:\"3930\";}','s:0:\"\";','20250814','1538' )
UID:7--153856-- UPDATE  `nav_link`  SET `rand`='NjAtbG5rLTI3MzctMjY='  WHERE 1=1  AND (id_link = '2737')  LIMIT 1 
UID:7--153947-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1696','1','2','Devis_DV-METZ-135_14_08_2025_15h_39m.pdf','20250814','210','import','165','1419','-2','1','7' )
UID:7--153947-- UPDATE  `file`  SET `size`=''  WHERE 1=1  AND (esp_id = '1')  AND (file_id = '2277')  LIMIT 1 
UID:7--153947-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1697','1','2','Devis_DV-METZ-135_14_08_2025_15h_39m.pdf','20250814','842','devis','165','1419','-2','1','' )
UID:7--153947-- UPDATE  `file`  SET `size`='1508669'  WHERE 1=1  AND (esp_id = '1')  AND (file_id = '2278')  LIMIT 1 
UID:7--153947-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250814','7','1','agence-metz@exteco.fr','Exteco','jr.menot@hotmail.fr','jr.menot@hotmail.fr','agence-metz@exteco.fr','Nouvelle proposition d\'EXTECO : Devis N° DV-METZ-135','<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<style type=\"text/css\">\r\n\r\n        /* Table reset */\r\n        table {\r\n            border-collapse: collapse !important;\r\n            mso-table-lspace: 0pt !important;\r\n            mso-table-rspace: 0pt !important;\r\n        }\r\n        \r\n        p, a, li, td, blockquote {\r\n            mso-line-height-rule: exactly;\r\n        }\r\n        \r\n        /* Links */\r\n        a {\r\n            color: #005c7d;\r\n            text-decoration: underline;\r\n        }\r\n        .email-container {\r\n            max-width: 600px !important;\r\n            margin: 0 auto !important;\r\n            padding: 0 !important;\r\n        }\r\n        \r\n        .signature-container {\r\n            border-top: 2px solid #d0d0d0;\r\n            margin-top: 20px;\r\n            padding-top: 20px;\r\n            text-align: center;\r\n        }\r\n        \r\n        .signature-table {\r\n            width: 100%;\r\n            max-width: 600px;\r\n            margin: 0 auto;\r\n        }\r\n        \r\n        .logo-cell {\r\n            padding: 0 25px 15px 10px;\r\n            text-align: center;\r\n            vertical-align: top;\r\n        }\r\n        \r\n        .info-cell {\r\n            padding: 0 10px 15px 25px;\r\n            text-align: left;\r\n            vertical-align: top;\r\n        }\r\n        \r\n        .signature-logo {\r\n            width: 175px;\r\n            height: auto;\r\n            margin-bottom: 10px;\r\n        }\r\n        \r\n        .signature-name {\r\n            font-weight: bold;\r\n            margin: 0 0 5px 0;\r\n        }\r\n        \r\n        .signature-title {\r\n            font-style: italic;\r\n            margin: 0 0 5px 0;\r\n        }\r\n        \r\n        .signature-contact {\r\n            margin: 0 0 5px 0;\r\n        }\r\n        \r\n        .signature-address {\r\n            font-size: 14px;\r\n            margin: 0 0 10px 0;\r\n        }\r\n        \r\n        /* Responsive */\r\n        @media screen and (max-width: 600px) {\r\n            .email-container {\r\n                width: 100% !important;\r\n            }\r\n            \r\n            .signature-table {\r\n                max-width: 100% !important;\r\n            }\r\n            \r\n            .signature-logo {\r\n                width: 150px !important;\r\n            }\r\n        }\r\n        \r\n        @media screen and (max-width: 480px) {\r\n            .logo-cell, .info-cell {\r\n                display: block !important;\r\n                width: 100% !important;\r\n                padding: 0 0 15px 0 !important;\r\n                text-align: center !important;\r\n            }\r\n        }\r\n    </style>\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                                Proposition d\'intervention (Devis N° DV-METZ-135)\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 M. MENOT,<br><br>\r\n                                Comme convenu suite à notre rendez-vous, vous trouverez ci-joint votre devis n°DV-METZ-135. <br><br>Nous vous remercions pour votre confiance et restons disponibles pour tout complément d\'information.<br><br>Bien cordialement,</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 - Exteco Metz\r\n                            </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;\">\r\n                                                    <a href=\"https://exteco.toosmart.app/site/SITE1/DEVIS/2yoarczuvdm47i2u?file=2261\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Afficher et signer votre devis\r\n                                                    </a>\r\n                                                </td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            \r\n      <!-- Signature Section --><div style=\"text-align: center;\"><table style=\"border-top: 2px solid gray; width: 600px; padding: 10px; margin-top: 20px; margin-left: auto; margin-right: auto; border-collapse: collapse;\"><tr><td style=\"width: 200px; text-align: center; vertical-align: middle; padding: 10px 10px 10px 70px;\"><a href=\"https://www.exteco.fr/\" target=\"_blank\"><img src=\"https://object-storage.toosmart.app/nooa/logoExteco.png\" alt=\"Exteco\" style=\"height: auto; width: 175px;\"></a></td><td style=\"vertical-align: top; font-family: Arial, sans-serif; text-align: left; padding: 10px; width: 275px; height: 210px;\"><p style=\"font-weight: bold; line-height: 1.2; margin-top: 10px;\">Thomas BLAISE</p><p style=\"font-style: italic; margin-top: 10px;\">Gérant</p><a style=\"font-weight: bold; text-decoration: underline; display: block; margin-top: 10px;\" href=\"https://www.exteco.fr/agence-metz\">Exteco </a><p style=\"text-decoration: underline; margin-top: 10px;\">06.03.92.19.19 - 03.72.73.50.05</p><p style=\"font-size: 14px; margin-top: 10px;\">10 Rue Rochambeau, 57000 Metz</p><div style=\"margin-top: 10px;\"><div style=\"display: flex; align-items: center; margin-top: 10px; height: 35px;\"><a href=\"https://www.facebook.com/exteco.metz\" target=\"_blank\">\r\n            <img src=\"https://upload.wikimedia.org/wikipedia/commons/c/cd/Facebook_logo_%28square%29.png\" alt=\"Facebook\" style=\"width: 29px; height: 29px; margin-right: 7px;\">\r\n         </a><a href=\"https://www.instagram.com/exteco.metz/\" target=\"_blank\">\r\n            <img src=\"https://upload.wikimedia.org/wikipedia/commons/a/a5/Instagram_icon.png\" alt=\"Instagram\" style=\"width: 30px; height: 30px; margin-right: 7px;\">\r\n         </a><a href=\"https://www.linkedin.com/company/exteco-fr/\" target=\"_blank\">\r\n            <img src=\"https://cdn-icons-png.flaticon.com/256/174/174857.png\" alt=\"LinkedIn\" style=\"width: 30px; height: 30px;\">\r\n         </a></div></div></td></tr></table></div></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>','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/2261-574-85-1§Attestation_fiscale_DV_METZ_135_12_08_2025_19h_19m.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/1/2275-1694-766-1§Devis_DV-METZ-135_14_08_2025_15h_34m.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/1/2276-1695-599-1§Devis_DV-METZ-135_14_08_2025_15h_39m.pdf;/mnt/big/prod/toosmart_exteco/data/tmp/Devis_DV-METZ-135_14_08_2025_15h_39m.pdf§Devis_DV-METZ-135_14_08_2025_15h_39m.pdf','0','v2017b' )
UID:7--153947-- UPDATE  `email`  SET `type`='',`bcc`= NULL ,`replyto`=''  WHERE 1=1  AND (id_email = '1377')  LIMIT 1 
UID:7--153947-- UPDATE  `vent_att`  SET `attf104`='202508141539',`id_work`='411',`attdatmod`='202508141539',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1419')  AND (id_type = '165')  LIMIT 1 
UID:7--153947-- UPDATE  `vent_att`  SET `attf104`='202508141539',`id_work`='411',`att7`='6250',`att8`='625',`att9`='6875',`att21`='5861',`att27`='1014',`att28`='5328.18',`att29`='921.82',`att30`='532.82',`attdatmod`='202508141539',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1419')  AND (id_type = '165')  LIMIT 1 
UID:7--153947-- UPDATE  `vent_att`  SET `attf104`='202508141539',`id_work`='411',`att7`='6250',`att8`='625',`att9`='6875',`att21`='5861',`att27`='1014',`att28`='5328.18',`att29`='921.82',`att30`='532.82',`att18`='<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></p>\n                    <br><p>agence-metz@exteco.fr</p>\n                    <br><span>www.rainea.fr</span>\n                </span>',`attdatmod`='202508141539',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1419')  AND (id_type = '165')  LIMIT 1 
UID:7--153947-- UPDATE  `vent_att`  SET `attf104`='202508141539',`id_work`='411',`att7`='6250',`att8`='625',`att9`='6875',`att21`='5861',`att27`='1014',`att28`='5328.18',`att29`='921.82',`att30`='532.82',`att18`='<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></p>\n                    <br><p>agence-metz@exteco.fr</p>\n                    <br><span>www.rainea.fr</span>\n                </span>',`attf106`='20250814',`attdatmod`='202508141539',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1419')  AND (id_type = '165')  LIMIT 1 
UID:7--153947-- 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:\"3930\";}','s:0:\"\";','20250814','1539' )
UID:7--153947-- UPDATE  `nav_link`  SET `rand`='MTUtbG5rLTI3MzgtMTc='  WHERE 1=1  AND (id_link = '2738')  LIMIT 1 
UID:7--153958-- 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:3:\"160\";}','s:0:\"\";','20250814','1539' )
UID:7--153958-- UPDATE  `nav_link`  SET `rand`='NzctbG5rLTI3MzktNTA='  WHERE 1=1  AND (id_link = '2739')  LIMIT 1 
UID:7--154131-- UPDATE  `vent_lig`  SET `lig90`='<p>Remise commerciale de 20% effectuée&nbsp;</p>',`ligdatmod`='202508141541',`ligusermod`='7'  WHERE 1=1  AND ( id_vent = '1421')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '2763')  LIMIT 1 
UID:7--154131-- UPDATE  `vent_lig`  SET `lig90`='<p>Remise commerciale de 20% effectuée&nbsp;</p>',`lig91`='<b>REMISE</b><br /><p>Remise commerciale de 20% effectuée </p>',`ligdatmod`='202508141541',`ligusermod`='7'  WHERE 1=1  AND ( id_vent = '1421')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '2763')  LIMIT 1 
UID:7--154131-- UPDATE  `vent_lig`  SET `lig90`='<p>Remise commerciale de 20% effectuée&nbsp;</p>',`lig91`='<b>REMISE</b><br /><p>Remise commerciale de 20% effectuée </p>',`ligdatmod`='202508141541',`ligusermod`='7'  WHERE 1=1  AND ( id_vent = '1421')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '2763')  LIMIT 1 
UID:7--154131-- UPDATE  `vent_att`  SET `att7`='2268.6',`att8`='226.86',`att9`='2495.46',`att21`='1996.46',`att27`='499',`att28`='1814.96',`att29`='453.64',`att30`='181.5',`attdatmod`='202508141541',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154131-- UPDATE  `vent_att`  SET `att7`='2268.6',`att8`='226.86',`att9`='2495.46',`att21`='1996.46',`att27`='499',`att28`='1814.96',`att29`='453.64',`att30`='181.5',`att18`='<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></p>\n                    <br><p>agence-metz@exteco.fr</p>\n                    <br><span>www.rainea.fr</span>\n                </span>',`attdatmod`='202508141541',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154154-- UPDATE  `vent_lig`  SET `lig90`='<p>Remise commerciale de 20% effectuée soit 499 € TTC</p>',`ligdatmod`='202508141541',`ligusermod`='7'  WHERE 1=1  AND ( id_vent = '1421')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '2763')  LIMIT 1 
UID:7--154154-- UPDATE  `vent_lig`  SET `lig90`='<p>Remise commerciale de 20% effectuée soit 499 € TTC</p>',`lig91`='<b>REMISE</b><br /><p>Remise commerciale de 20% effectuée soit 499 € TTC</p>',`ligdatmod`='202508141541',`ligusermod`='7'  WHERE 1=1  AND ( id_vent = '1421')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '2763')  LIMIT 1 
UID:7--154154-- UPDATE  `vent_lig`  SET `lig90`='<p>Remise commerciale de 20% effectuée soit 499 € TTC</p>',`lig91`='<b>REMISE</b><br /><p>Remise commerciale de 20% effectuée soit 499 € TTC</p>',`ligdatmod`='202508141541',`ligusermod`='7'  WHERE 1=1  AND ( id_vent = '1421')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '2763')  LIMIT 1 
UID:7--154154-- UPDATE  `vent_att`  SET `att7`='2268.6',`att8`='226.86',`att9`='2495.46',`att21`='1996.46',`att27`='499',`att28`='1814.96',`att29`='453.64',`att30`='181.5',`attdatmod`='202508141541',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154154-- UPDATE  `vent_att`  SET `att7`='2268.6',`att8`='226.86',`att9`='2495.46',`att21`='1996.46',`att27`='499',`att28`='1814.96',`att29`='453.64',`att30`='181.5',`att18`='<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></p>\n                    <br><p>agence-metz@exteco.fr</p>\n                    <br><span>www.rainea.fr</span>\n                </span>',`attdatmod`='202508141541',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154158-- UPDATE  `vent_att`  SET `attf103`= NULL ,`attdatmod`='202508141541',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154158-- UPDATE  `vent_att`  SET `attf103`= NULL ,`att7`='2268.6',`att8`='226.86',`att9`='2495.46',`att21`='1996.46',`att27`='499',`att28`='1814.96',`att29`='453.64',`att30`='181.5',`attdatmod`='202508141541',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154158-- UPDATE  `vent_att`  SET `attf103`= NULL ,`att7`='2268.6',`att8`='226.86',`att9`='2495.46',`att21`='1996.46',`att27`='499',`att28`='1814.96',`att29`='453.64',`att30`='181.5',`att18`='<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></p>\n                    <br><p>agence-metz@exteco.fr</p>\n                    <br><span>www.rainea.fr</span>\n                </span>',`attdatmod`='202508141541',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154158-- 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:3:\"160\";}','s:0:\"\";','20250814','1541' )
UID:7--154158-- UPDATE  `nav_link`  SET `rand`='MzctbG5rLTI3NDAtMzg='  WHERE 1=1  AND (id_link = '2740')  LIMIT 1 
UID:7--154312-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1700','1','2','Devis_DV-METZ-136_14_08_2025_15h_43m.pdf','20250814','49','import','165','1421','-2','1','7' )
UID:7--154312-- UPDATE  `file`  SET `size`=''  WHERE 1=1  AND (esp_id = '1')  AND (file_id = '2281')  LIMIT 1 
UID:7--154312-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1701','1','2','Devis_DV-METZ-136_14_08_2025_15h_43m.pdf','20250814','51','devis','165','1421','-2','1','' )
UID:7--154312-- UPDATE  `file`  SET `size`='1208716'  WHERE 1=1  AND (esp_id = '1')  AND (file_id = '2282')  LIMIT 1 
UID:7--154312-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250814','7','1','agence-metz@exteco.fr','Exteco','lilo.aquilina@free.fr','lilo.aquilina@free.fr','agence-metz@exteco.fr','Nouvelle proposition d\'EXTECO : Devis N° DV-METZ-136','<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<style type=\"text/css\">\r\n\r\n        /* Table reset */\r\n        table {\r\n            border-collapse: collapse !important;\r\n            mso-table-lspace: 0pt !important;\r\n            mso-table-rspace: 0pt !important;\r\n        }\r\n        \r\n        p, a, li, td, blockquote {\r\n            mso-line-height-rule: exactly;\r\n        }\r\n        \r\n        /* Links */\r\n        a {\r\n            color: #005c7d;\r\n            text-decoration: underline;\r\n        }\r\n        .email-container {\r\n            max-width: 600px !important;\r\n            margin: 0 auto !important;\r\n            padding: 0 !important;\r\n        }\r\n        \r\n        .signature-container {\r\n            border-top: 2px solid #d0d0d0;\r\n            margin-top: 20px;\r\n            padding-top: 20px;\r\n            text-align: center;\r\n        }\r\n        \r\n        .signature-table {\r\n            width: 100%;\r\n            max-width: 600px;\r\n            margin: 0 auto;\r\n        }\r\n        \r\n        .logo-cell {\r\n            padding: 0 25px 15px 10px;\r\n            text-align: center;\r\n            vertical-align: top;\r\n        }\r\n        \r\n        .info-cell {\r\n            padding: 0 10px 15px 25px;\r\n            text-align: left;\r\n            vertical-align: top;\r\n        }\r\n        \r\n        .signature-logo {\r\n            width: 175px;\r\n            height: auto;\r\n            margin-bottom: 10px;\r\n        }\r\n        \r\n        .signature-name {\r\n            font-weight: bold;\r\n            margin: 0 0 5px 0;\r\n        }\r\n        \r\n        .signature-title {\r\n            font-style: italic;\r\n            margin: 0 0 5px 0;\r\n        }\r\n        \r\n        .signature-contact {\r\n            margin: 0 0 5px 0;\r\n        }\r\n        \r\n        .signature-address {\r\n            font-size: 14px;\r\n            margin: 0 0 10px 0;\r\n        }\r\n        \r\n        /* Responsive */\r\n        @media screen and (max-width: 600px) {\r\n            .email-container {\r\n                width: 100% !important;\r\n            }\r\n            \r\n            .signature-table {\r\n                max-width: 100% !important;\r\n            }\r\n            \r\n            .signature-logo {\r\n                width: 150px !important;\r\n            }\r\n        }\r\n        \r\n        @media screen and (max-width: 480px) {\r\n            .logo-cell, .info-cell {\r\n                display: block !important;\r\n                width: 100% !important;\r\n                padding: 0 0 15px 0 !important;\r\n                text-align: center !important;\r\n            }\r\n        }\r\n    </style>\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                                Proposition d\'intervention (Devis N° DV-METZ-136)\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 M. AQUILINA,<br><br>\r\n                                Comme convenu suite à notre rendez-vous, vous trouverez ci-joint votre devis n°DV-METZ-136. <br><br>Nous vous remercions pour votre confiance et restons disponibles pour tout complément d\'information.<br><br>Bien cordialement,</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 - Exteco Metz\r\n                            </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;\">\r\n                                                    <a href=\"https://exteco.toosmart.app/site/SITE1/DEVIS/0as7dvhwn94e4d3a?file=2262\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Afficher et signer votre devis\r\n                                                    </a>\r\n                                                </td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            \r\n      <!-- Signature Section --><div style=\"text-align: center;\"><table style=\"border-top: 2px solid gray; width: 600px; padding: 10px; margin-top: 20px; margin-left: auto; margin-right: auto; border-collapse: collapse;\"><tr><td style=\"width: 200px; text-align: center; vertical-align: middle; padding: 10px 10px 10px 70px;\"><a href=\"https://www.exteco.fr/\" target=\"_blank\"><img src=\"https://object-storage.toosmart.app/nooa/logoExteco.png\" alt=\"Exteco\" style=\"height: auto; width: 175px;\"></a></td><td style=\"vertical-align: top; font-family: Arial, sans-serif; text-align: left; padding: 10px; width: 275px; height: 210px;\"><p style=\"font-weight: bold; line-height: 1.2; margin-top: 10px;\">Thomas BLAISE</p><p style=\"font-style: italic; margin-top: 10px;\">Gérant</p><a style=\"font-weight: bold; text-decoration: underline; display: block; margin-top: 10px;\" href=\"https://www.exteco.fr/agence-metz\">Exteco </a><p style=\"text-decoration: underline; margin-top: 10px;\">06.03.92.19.19 - 03.72.73.50.05</p><p style=\"font-size: 14px; margin-top: 10px;\">10 Rue Rochambeau, 57000 Metz</p><div style=\"margin-top: 10px;\"><div style=\"display: flex; align-items: center; margin-top: 10px; height: 35px;\"><a href=\"https://www.facebook.com/exteco.metz\" target=\"_blank\">\r\n            <img src=\"https://upload.wikimedia.org/wikipedia/commons/c/cd/Facebook_logo_%28square%29.png\" alt=\"Facebook\" style=\"width: 29px; height: 29px; margin-right: 7px;\">\r\n         </a><a href=\"https://www.instagram.com/exteco.metz/\" target=\"_blank\">\r\n            <img src=\"https://upload.wikimedia.org/wikipedia/commons/a/a5/Instagram_icon.png\" alt=\"Instagram\" style=\"width: 30px; height: 30px; margin-right: 7px;\">\r\n         </a><a href=\"https://www.linkedin.com/company/exteco-fr/\" target=\"_blank\">\r\n            <img src=\"https://cdn-icons-png.flaticon.com/256/174/174857.png\" alt=\"LinkedIn\" style=\"width: 30px; height: 30px;\">\r\n         </a></div></div></td></tr></table></div></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>','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/2262-575-804-1§Attestation_fiscale_DV_METZ_136_12_08_2025_19h_27m.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/1/2279-1698-558-1§Devis_DV-METZ-136_14_08_2025_15h_40m.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/1/2280-1699-97-1§Devis_DV-METZ-136_14_08_2025_15h_42m.pdf;/mnt/big/prod/toosmart_exteco/data/tmp/Devis_DV-METZ-136_14_08_2025_15h_43m.pdf§Devis_DV-METZ-136_14_08_2025_15h_43m.pdf','0','v2017b' )
UID:7--154312-- UPDATE  `email`  SET `type`='',`bcc`= NULL ,`replyto`=''  WHERE 1=1  AND (id_email = '1378')  LIMIT 1 
UID:7--154312-- UPDATE  `vent_att`  SET `attf104`='202508141543',`id_work`='411',`attdatmod`='202508141543',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154312-- UPDATE  `vent_att`  SET `attf104`='202508141543',`id_work`='411',`att7`='2268.6',`att8`='226.86',`att9`='2495.46',`att21`='1996.46',`att27`='499',`att28`='1814.96',`att29`='453.64',`att30`='181.5',`attdatmod`='202508141543',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154312-- UPDATE  `vent_att`  SET `attf104`='202508141543',`id_work`='411',`att7`='2268.6',`att8`='226.86',`att9`='2495.46',`att21`='1996.46',`att27`='499',`att28`='1814.96',`att29`='453.64',`att30`='181.5',`att18`='<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></p>\n                    <br><p>agence-metz@exteco.fr</p>\n                    <br><span>www.rainea.fr</span>\n                </span>',`attdatmod`='202508141543',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154312-- UPDATE  `vent_att`  SET `attf104`='202508141543',`id_work`='411',`att7`='2268.6',`att8`='226.86',`att9`='2495.46',`att21`='1996.46',`att27`='499',`att28`='1814.96',`att29`='453.64',`att30`='181.5',`att18`='<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></p>\n                    <br><p>agence-metz@exteco.fr</p>\n                    <br><span>www.rainea.fr</span>\n                </span>',`attf106`='20250814',`attdatmod`='202508141543',`attusermod`='7',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1421')  AND (id_type = '165')  LIMIT 1 
UID:7--154312-- 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:3:\"160\";}','s:0:\"\";','20250814','1543' )
UID:7--154312-- UPDATE  `nav_link`  SET `rand`='NDctbG5rLTI3NDEtMjU='  WHERE 1=1  AND (id_link = '2741')  LIMIT 1