UID:--082649--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:--082649--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--094445--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:--094445--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--142652--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:--142652-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202506071426' )
UID:--142652-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle - Sols - Beuvillers',`att90`='di28f-a9d-0mclzx',`attf100`='20250513',`att5`='2775',`att8`='8',`att9`='4001.4',`att10`='400.14',`att11`='4401.54',`att13`='',`att14`='383',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  7 Rue de Bellevue 54560 BEUVILLERS',`att18`='0',`att29`='4001.4',`att24`='4401.54',`att25`='7 Rue de Bellevue',`att26`='en face du cimetière',`att27`='54560',`att28`='BEUVILLERS',`attdatmod`='202506071426',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '734')  AND (id_type = '168')  LIMIT 1 
UID:--142652-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '734')  LIMIT 1 
UID:--142652-- UPDATE  `tier_lig`  SET `lig2`='16',`ligdatmod`='202506071426',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '8')  LIMIT 1 
UID:--142652-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-16',`att3`='',`att2`='Maison individuelle - Sols - Beuvillers',`att90`='di28f-a9d-0mclzx',`attf100`='20250513',`att5`='2775',`att8`='8',`att9`='4001.4',`att10`='400.14',`att11`='4401.54',`att13`='',`att14`='383',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  7 Rue de Bellevue 54560 BEUVILLERS',`att18`='0',`att29`='4001.4',`att24`='4401.54',`att25`='7 Rue de Bellevue',`att26`='en face du cimetière',`att27`='54560',`att28`='BEUVILLERS',`attdatmod`='202506071426',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '734')  AND (id_type = '168')  LIMIT 1 
UID:--142652-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','734','202506071426','202506071426' )
UID:--142652-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='155.80',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Terrasse Rosace</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='82',`lig2`='19.00',`lig5`='10',`lig4`='1558.00',`lig8`='1713.80',`lig10`='euro',`lig6`='1713.80',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Terrasse Rosace</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071426',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '734')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1348')  LIMIT 1 
UID:--142652-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','734','202506071426','202506071426' )
UID:--142652-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='10.64',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Escaliers Jardins :</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='5.6',`lig2`='19.00',`lig5`='10',`lig4`='106.40',`lig8`='117.04',`lig10`='euro',`lig6`='117.04',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Escaliers Jardins :</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071426',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '734')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1349')  LIMIT 1 
UID:--142652-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','734','202506071426','202506071426' )
UID:--142652-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='13.30',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Allée Jardin Supérieur</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='7',`lig2`='19.00',`lig5`='10',`lig4`='133.00',`lig8`='146.30',`lig10`='euro',`lig6`='146.30',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Allée Jardin Supérieur</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071426',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '734')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1350')  LIMIT 1 
UID:--142652-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','734','202506071426','202506071426' )
UID:--142652-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='79.80',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Descente allée de Jardin</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='42',`lig2`='19.00',`lig5`='10',`lig4`='798.00',`lig8`='877.80',`lig10`='euro',`lig6`='877.80',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Descente allée de Jardin</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071426',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '734')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1351')  LIMIT 1 
UID:--142652-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','734','202506071426','202506071426' )
UID:--142652-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='12.35',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Muret sol extérieure </font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='6.5',`lig2`='19.00',`lig5`='10',`lig4`='123.50',`lig8`='135.85',`lig10`='euro',`lig6`='135.85',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Muret sol extérieure </font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071426',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '734')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1352')  LIMIT 1 
UID:--142652-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','734','202506071426','202506071426' )
UID:--142652-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='111.15',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Allée avant garage </font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='58.5',`lig2`='19.00',`lig5`='10',`lig4`='1111.50',`lig8`='1222.65',`lig10`='euro',`lig6`='1222.65',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Allée avant garage </font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071426',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '734')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1353')  LIMIT 1 
UID:--142652-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','734','202506071426','202506071426' )
UID:--142652-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='17.10',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Allée Dalle</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='9',`lig2`='19.00',`lig5`='10',`lig4`='171.00',`lig8`='188.10',`lig10`='euro',`lig6`='188.10',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Allée Dalle</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071426',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '734')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1354')  LIMIT 1 
UID:--142652-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('272','1','2','Devis_DV-METZ-31_13_05_2025_18h_14m_signe.pdf','20250607','426','devis_signe','168','734','-2','-1','' )
UID:--142652-- UPDATE  `file`  SET `size`='427840'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '850')  LIMIT 1 
UID:--142652-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('273','1','2','Attestation_fiscale_DV_METZ_31_13_05_2025_18h_12m_signe.pdf','20250607','404','attestation_signe','168','734','-2','-1','' )
UID:--142652-- UPDATE  `file`  SET `size`='472335'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '851')  LIMIT 1 
UID:--142652-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250607','','1','contact@exteco.fr','Exteco','fredbello54@gmail.com','','','Merci pour votre commande : Devis N°DV-METZ-31','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouveau Devis EXTECO</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Merci pour votre commande (Devis N° DV-METZ-31)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour madame BOUR,<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/850-272-426-1§Devis_DV-METZ-31_13_05_2025_18h_14m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/851-273-404-1§Attestation_fiscale_DV_METZ_31_13_05_2025_18h_12m_signe.pdf','0','v2017b' )
UID:--142652-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '615')  LIMIT 1 
UID:--142652-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250607','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-31','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Devis signé</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Devis signé (Devis N° DV-METZ-31)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour,<br><br>Le devis n°DV-METZ-31 de   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:--142652-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '616')  LIMIT 1 
UID:--142653-- UPDATE  `vent_lig`  SET `lig1`='122',`lig7`='155.80',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Terrasse Rosace</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='82',`lig2`='19.00',`lig5`='10',`lig4`='1558.00',`lig8`='1713.80',`lig10`='euro',`lig6`='1713.80',`lig90`='<p><font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">Terrasse Rosace</font></p><p><br></p><p>Nettoyage et désinfection du support via un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071426',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '734')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1348')  LIMIT 1 
UID:--142653-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-16',`att3`='',`att2`='Maison individuelle - Sols - Beuvillers',`att90`='di28f-a9d-0mclzx',`attf100`='20250513',`att5`='2775',`att8`='8',`att9`='4001.4',`att10`='400.14',`att11`='4401.54',`att13`='',`att14`='383',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  7 Rue de Bellevue 54560 BEUVILLERS',`att18`='0',`att29`='4001.4',`att24`='4401.54',`att25`='7 Rue de Bellevue',`att26`='en face du cimetière',`att27`='54560',`att28`='BEUVILLERS',`att31`='400.14',`attdatmod`='202506071426',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '734')  AND (id_type = '168')  LIMIT 1 
UID:--142653-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='45',`attdatmod`='202506071426',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '19')  AND (id_type = '148')  LIMIT 1 
UID:--142653-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202506071426',`attdatmod`='202506071426',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '383')  AND (id_type = '165')  LIMIT 1 
UID:--142653-- UPDATE  `tier_att`  SET `id_work`='205',`att26`='',`attdatmod`='202506071426',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '2775')  AND (id_type = '80')  LIMIT 1 
UID:--154518-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506071545' )
UID:--154518-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Solange',`att1`='Le Nours',`att8`='non_défini',`att12`='solange.lenours@gmail.com',`att14`='8 allée Helene boucher',`att7`='57280',`att17`='Maizières les Metz',`att18`='France',`att5`='0676411887',`attf102`='20250607',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250607',`att26`='',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3398')  AND (id_type = '80')  LIMIT 1 
UID:--154518-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3398','202506071545','202506071545' )
UID:--154518-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='8 allée Helene boucher',`lig4`='57280',`lig5`='Maizières les Metz',`lig6`='France',`ligdatmod`='202506071545',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3398')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1706')  LIMIT 1 
UID:--154518-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Solange',`att1`='Le Nours',`att8`='non_défini',`att12`='solange.lenours@gmail.com',`att14`='8 allée Helene boucher',`att7`='57280',`att17`='Maizières les Metz',`att18`='France',`att5`='0676411887',`attf102`='20250607',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250607',`att26`='',`att19`='49.219719',`att20`='6.157326',`attf100`='1',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3398')  AND (id_type = '80')  LIMIT 1 
UID:--154518-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Solange',`att1`='Le Nours',`att8`='non_défini',`att12`='solange.lenours@gmail.com',`att14`='8 allée Helene boucher',`att7`='57280',`att17`='Maizières les Metz',`att18`='France',`att5`='0676411887',`attf102`='20250607',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250607',`att26`='',`att19`='49.219719',`att20`='6.157326',`attf100`='1',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3398')  AND (id_type = '80')  LIMIT 1 
UID:--154518-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506071545' )
UID:--154518-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Le Nours',`att3`='Solange',`att5`='0676411887',`att6`='solange.lenours@gmail.com',`att8`='3398',`att10`='[IDMYUSER]',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3399')  AND (id_type = '149')  LIMIT 1 
UID:--154518-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506071545' )
UID:--154518-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-',`att2`='3398',`att90`='Nettoyage et demoussage de la toiture',`attf100`='20250607',`att8`='1706',`att6`='[IDMYUSER]',`att9`='3399',`att3`='§toiture§',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '735')  AND (id_type = '148')  LIMIT 1 
UID:--154518-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Le Nours',`att2`='3398',`att90`='Nettoyage et demoussage de la toiture',`attf100`='20250607',`att8`='1706',`att6`='[IDMYUSER]',`att9`='3399',`att3`='§toiture§',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '735')  AND (id_type = '148')  LIMIT 1 
UID:--154518-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Le Nours',`att2`='3398',`att90`='Nettoyage et demoussage de la toiture',`attf100`='20250607',`att8`='1706',`att6`='[IDMYUSER]',`att9`='3399',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '735')  AND (id_type = '148')  LIMIT 1 
UID:--154518-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Le Nours',`att2`='3398',`att90`='Nettoyage et demoussage de la toiture',`attf100`='20250607',`att8`='1706',`att6`='0',`att9`='3399',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '735')  AND (id_type = '148')  LIMIT 1 
UID:--154518-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250607','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Le Nours','<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-Le Nours</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 Exteco,</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 : Le Nours</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Solange</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0676411887</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : solange.lenours@gmail.com</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 : 8 allée Helene boucher</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 57280</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Maizières les Metz</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Nettoyage et demoussage de la toiture</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:--154518-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '617')  LIMIT 1 
UID:--154518--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:--154518-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Le Nours',`att3`='Solange',`att5`='0676411887',`att6`='solange.lenours@gmail.com',`att8`='3398',`att10`='[IDMYUSER]',`att4`='0676411887',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3399')  AND (id_type = '149')  LIMIT 1 
UID:--154518-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Solange',`att1`='Le Nours',`att8`='non_défini',`att12`='solange.lenours@gmail.com',`att14`='8 allée Helene boucher',`att7`='57280',`att17`='Maizières les Metz',`att18`='France',`att5`='0676411887',`attf102`='20250607',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250607',`att26`='',`att19`='49.219719',`att20`='6.157326',`attf100`='1',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3398')  AND (id_type = '80')  LIMIT 1 
UID:--154518-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Solange',`att1`='Le Nours',`att8`='non_défini',`att12`='solange.lenours@gmail.com',`att14`='8 allée Helene boucher',`att7`='57280',`att17`='Maizières les Metz',`att18`='France',`att5`='0676411887',`attf102`='20250607',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250607',`att26`='',`att19`='49.219719',`att20`='6.157326',`attf100`='1',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3398')  AND (id_type = '80')  LIMIT 1 
UID:--154518-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Solange',`att1`='Le Nours',`att8`='non_défini',`att12`='solange.lenours@gmail.com',`att14`='8 allée Helene boucher',`att7`='57280',`att17`='Maizières les Metz',`att18`='France',`att5`='0676411887',`attf102`='20250607',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250607',`att26`='',`att19`='49.219719',`att20`='6.157326',`attf100`='1',`att6`='0676411887',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3398')  AND (id_type = '80')  LIMIT 1 
UID:--154518-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Le Nours',`att2`='3398',`att90`='Nettoyage et demoussage de la toiture',`attf100`='20250607',`att8`='1706',`att6`='0',`att9`='3399',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506071545',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '735')  AND (id_type = '148')  LIMIT 1 
UID:--154721--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:--154721-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202506071547' )
UID:--154721-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle - Terrasse - Hagondange',`att90`='45hbbp9e5x3z4ugi',`attf100`='20250603',`att5`='3285',`att8`='8',`att91`='&lt;p&gt;Prendre la petite machine&lt;/p&gt;',`att9`='600',`att10`='60',`att11`='660',`att13`='',`att14`='684',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  17 rue du Maréchal Joffre 57300 Hagondange',`att18`='0',`att29`='600',`att24`='660',`att25`='17 rue du Maréchal Joffre',`att26`='',`att27`='57300',`att28`='Hagondange',`attdatmod`='202506071547',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '736')  AND (id_type = '168')  LIMIT 1 
UID:--154721-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '736')  LIMIT 1 
UID:--154721-- UPDATE  `tier_lig`  SET `lig2`='17',`ligdatmod`='202506071547',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '8')  LIMIT 1 
UID:--154721-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-17',`att3`='',`att2`='Maison individuelle - Terrasse - Hagondange',`att90`='45hbbp9e5x3z4ugi',`attf100`='20250603',`att5`='3285',`att8`='8',`att91`='&lt;p&gt;Prendre la petite machine&lt;/p&gt;',`att9`='600',`att10`='60',`att11`='660',`att13`='',`att14`='684',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  17 rue du Maréchal Joffre 57300 Hagondange',`att18`='0',`att29`='600',`att24`='660',`att25`='17 rue du Maréchal Joffre',`att26`='',`att27`='57300',`att28`='Hagondange',`attdatmod`='202506071547',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '736')  AND (id_type = '168')  LIMIT 1 
UID:--154721-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','736','202506071547','202506071547' )
UID:--154721-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='158',`lig7`='60.00',`lig9`='158',`lig22`='Terrasse',`lig91`='<b>Terrasse</b><br /><p>Forfait nettoyage de votre terrasse avec un procédé vapeur basse pression </p>',`lig3`='1',`lig2`='600.00',`lig5`='10',`lig4`='600.00',`lig8`='660.00',`lig10`='euro',`lig6`='660.00',`lig90`='<p>Forfait nettoyage de votre terrasse avec un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071547',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '736')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1355')  LIMIT 1 
UID:--154722-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('274','1','2','Devis_DV-METZ-66_03_06_2025_18h_33m_signe.pdf','20250607','475','devis_signe','168','736','-2','-1','' )
UID:--154722-- UPDATE  `file`  SET `size`='505742'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '852')  LIMIT 1 
UID:--154722-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('275','1','2','Attestation_fiscale_DV_METZ_66_03_06_2025_18h_30m_signe.pdf','20250607','88','attestation_signe','168','736','-2','-1','' )
UID:--154722-- UPDATE  `file`  SET `size`='734420'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '853')  LIMIT 1 
UID:--154722-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250607','','1','contact@exteco.fr','Exteco','benjamin.lob@gmail.com','','','Merci pour votre commande : Devis N°DV-METZ-66','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouveau Devis EXTECO</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Merci pour votre commande (Devis N° DV-METZ-66)\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 LOB,<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/852-274-475-1§Devis_DV-METZ-66_03_06_2025_18h_33m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/853-275-88-1§Attestation_fiscale_DV_METZ_66_03_06_2025_18h_30m_signe.pdf','0','v2017b' )
UID:--154722-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '618')  LIMIT 1 
UID:--154722-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250607','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-66','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Devis signé</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Devis signé (Devis N° DV-METZ-66)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour,<br><br>Le devis n°DV-METZ-66 de   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:--154722-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '619')  LIMIT 1 
UID:--154722-- UPDATE  `vent_lig`  SET `lig1`='158',`lig7`='60.00',`lig9`='158',`lig22`='Terrasse',`lig91`='<b>Terrasse</b><br /><p>Forfait nettoyage de votre terrasse avec un procédé vapeur basse pression </p>',`lig3`='1',`lig2`='600.00',`lig5`='10',`lig4`='600.00',`lig8`='660.00',`lig10`='euro',`lig6`='660.00',`lig90`='<p>Forfait nettoyage de votre terrasse avec un procédé vapeur basse pression&nbsp;</p>',`ligdatmod`='202506071547',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '736')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1355')  LIMIT 1 
UID:--154722-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-17',`att3`='',`att2`='Maison individuelle - Terrasse - Hagondange',`att90`='45hbbp9e5x3z4ugi',`attf100`='20250603',`att5`='3285',`att8`='8',`att91`='&lt;p&gt;Prendre la petite machine&lt;/p&gt;',`att9`='600',`att10`='60',`att11`='660',`att13`='',`att14`='684',`att15`='<span style=\'line-height: 15px\'>\n                    <p><strong>Rainea Exteco Metz</strong></p>\n                    <br style=\'line-height: 9px;\'>\n                    <p>10 Rue Rochambeau<br>\n                    57000 Metz</p>\n                    <br><p><',`att16`='  17 rue du Maréchal Joffre 57300 Hagondange',`att18`='0',`att29`='600',`att24`='660',`att25`='17 rue du Maréchal Joffre',`att26`='',`att27`='57300',`att28`='Hagondange',`att31`='60',`attdatmod`='202506071547',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '736')  AND (id_type = '168')  LIMIT 1 
UID:--154723-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='9',`attdatmod`='202506071547',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '621')  AND (id_type = '148')  LIMIT 1 
UID:--154723-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202506071547',`attdatmod`='202506071547',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '684')  AND (id_type = '165')  LIMIT 1 
UID:--154723-- UPDATE  `tier_att`  SET `id_work`='205',`att26`='',`attdatmod`='202506071547',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3285')  AND (id_type = '80')  LIMIT 1 
UID:--161125--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:--161125--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--163634--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:10--163634--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--234808--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:--234808--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre