UID:--080819--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:--080819--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--101913--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:--101913-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202506151019' )
UID:--101913-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='maison individuelle - terrasse - Epinal',`att90`='5kh2iacprjc90ym6',`attf100`='20250527',`att5`='3271',`att8`='2',`att9`='1651.7',`att10`='165.17',`att11`='1816.87',`att13`='chèque ou virement',`att14`='596',`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`='  4 rue des hauts jardins 88000 EPINAL',`att18`='272.53',`att29`='1403.95',`att24`='1544.34',`att25`='4 rue des hauts jardins',`att26`='',`att27`='88000',`att28`='EPINAL',`attdatmod`='202506151019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '816')  AND (id_type = '168')  LIMIT 1 
UID:--101913-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '816')  LIMIT 1 
UID:--101913-- UPDATE  `tier_lig`  SET `lig2`='39',`ligdatmod`='202506151019',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '3')  LIMIT 1 
UID:--101913-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-39',`att3`='',`att2`='maison individuelle - terrasse - Epinal',`att90`='5kh2iacprjc90ym6',`attf100`='20250527',`att5`='3271',`att8`='2',`att9`='1651.7',`att10`='165.17',`att11`='1816.87',`att13`='chèque ou virement',`att14`='596',`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`='  4 rue des hauts jardins 88000 EPINAL',`att18`='272.53',`att29`='1403.95',`att24`='1544.34',`att25`='4 rue des hauts jardins',`att26`='',`att27`='88000',`att28`='EPINAL',`attdatmod`='202506151019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '816')  AND (id_type = '168')  LIMIT 1 
UID:--101913-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','816','202506151019','202506151019' )
UID:--101913-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='113',`lig7`='165.17',`lig9`='113',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (1)</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='83',`lig2`='19.90',`lig5`='10',`lig4`='1651.70',`lig8`='1816.87',`lig10`='pourcentage',`lig11`='15',`lig6`='1544.34',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202506151019',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '816')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1483')  LIMIT 1 
UID:--101913-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('307','1','2','Devis_DV-EPI-77_27_05_2025_11h_26m_signe.pdf','20250615','268','devis_signe','168','816','-2','-1','' )
UID:--101913-- UPDATE  `file`  SET `size`='360548'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '1011')  LIMIT 1 
UID:--101913-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('308','1','2','Attestation_fiscale_DV_EPI_77_27_05_2025_11h_24m_signe.pdf','20250615','656','attestation_signe','168','816','-2','-1','' )
UID:--101913-- UPDATE  `file`  SET `size`='473878'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '1012')  LIMIT 1 
UID:--101913-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250615','','1','contact@exteco.fr','Exteco','philippe.baumann618@orange.fr','','','Merci pour votre commande : Devis N°DV-EPI-77','<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-77)\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 BAUMANN,<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/1011-307-268-1§Devis_DV-EPI-77_27_05_2025_11h_26m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/1012-308-656-1§Attestation_fiscale_DV_EPI_77_27_05_2025_11h_24m_signe.pdf','0','v2017b' )
UID:--101913-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '702')  LIMIT 1 
UID:--101913-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250615','','1','contact@exteco.fr','Exteco','agence-epinal@exteco.fr','','','Devis signé - N° DV-EPI-77','<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-77)\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-77 de monsieur BAUMANN 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:--101913-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '703')  LIMIT 1 
UID:--101914-- UPDATE  `vent_lig`  SET `lig1`='113',`lig7`='165.17',`lig9`='113',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (1)</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='83',`lig2`='19.90',`lig5`='10',`lig4`='1651.70',`lig8`='1816.87',`lig10`='pourcentage',`lig11`='15',`lig6`='1544.34',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202506151019',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '816')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1483')  LIMIT 1 
UID:--101914-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-39',`att3`='',`att2`='maison individuelle - terrasse - Epinal',`att90`='5kh2iacprjc90ym6',`attf100`='20250527',`att5`='3271',`att8`='2',`att9`='1651.7',`att10`='165.17',`att11`='1816.87',`att13`='chèque ou virement',`att14`='596',`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`='  4 rue des hauts jardins 88000 EPINAL',`att18`='272.53',`att29`='1403.95',`att24`='1544.34',`att25`='4 rue des hauts jardins',`att26`='',`att27`='88000',`att28`='EPINAL',`att31`='140.39',`attdatmod`='202506151019',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '816')  AND (id_type = '168')  LIMIT 1 
UID:--101923-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='19',`attdatmod`='202506151019',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '595')  AND (id_type = '148')  LIMIT 1 
UID:--101923-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202506151019',`attdatmod`='202506151019',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '596')  AND (id_type = '165')  LIMIT 1 
UID:--101923-- UPDATE  `tier_att`  SET `id_work`='205',`att26`='',`attdatmod`='202506151019',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3271')  AND (id_type = '80')  LIMIT 1 
UID:--105054--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:--105054--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--114709--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:--114709--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--125002-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506151250' )
UID:--125002-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Laurent',`att1`='Legrand',`att8`='non_défini',`att12`='fan.lolo1@orange.fr',`att14`='11 rue des Crechaudes',`att7`='85440',`att17`='Saint Hilaire La Forêt',`att18`='France',`att5`='0603931947',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250615',`att26`='',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3466')  AND (id_type = '80')  LIMIT 1 
UID:--125002-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3466','202506151250','202506151250' )
UID:--125002-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='11 rue des Crechaudes',`lig4`='85440',`lig5`='Saint Hilaire La Forêt',`lig6`='France',`ligdatmod`='202506151250',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3466')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1743')  LIMIT 1 
UID:--125002-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Laurent',`att1`='Legrand',`att8`='non_défini',`att12`='fan.lolo1@orange.fr',`att14`='11 rue des Crechaudes',`att7`='85440',`att17`='Saint Hilaire La Forêt',`att18`='France',`att5`='0603931947',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250615',`att26`='',`att19`='46.449582',`att20`='-1.518928',`attf100`='1',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3466')  AND (id_type = '80')  LIMIT 1 
UID:--125002-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Laurent',`att1`='Legrand',`att8`='non_défini',`att12`='fan.lolo1@orange.fr',`att14`='11 rue des Crechaudes',`att7`='85440',`att17`='Saint Hilaire La Forêt',`att18`='France',`att5`='0603931947',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250615',`att26`='',`att19`='46.449582',`att20`='-1.518928',`attf100`='1',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3466')  AND (id_type = '80')  LIMIT 1 
UID:--125002-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506151250' )
UID:--125002-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Legrand',`att3`='Laurent',`att5`='0603931947',`att6`='fan.lolo1@orange.fr',`att8`='3466',`att10`='[IDMYUSER]',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3467')  AND (id_type = '149')  LIMIT 1 
UID:--125002-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506151250' )
UID:--125002-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-',`att2`='3466',`att90`='Nettoyage de toiture et imperméabilisant',`attf100`='20250615',`att8`='1743',`att6`='[IDMYUSER]',`att9`='3467',`att3`='§toiture§',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '817')  AND (id_type = '148')  LIMIT 1 
UID:--125002-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Legrand',`att2`='3466',`att90`='Nettoyage de toiture et imperméabilisant',`attf100`='20250615',`att8`='1743',`att6`='[IDMYUSER]',`att9`='3467',`att3`='§toiture§',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '817')  AND (id_type = '148')  LIMIT 1 
UID:--125002-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Legrand',`att2`='3466',`att90`='Nettoyage de toiture et imperméabilisant',`attf100`='20250615',`att8`='1743',`att6`='[IDMYUSER]',`att9`='3467',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '817')  AND (id_type = '148')  LIMIT 1 
UID:--125002-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Legrand',`att2`='3466',`att90`='Nettoyage de toiture et imperméabilisant',`attf100`='20250615',`att8`='1743',`att6`='0',`att9`='3467',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '817')  AND (id_type = '148')  LIMIT 1 
UID:--125002-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250615','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Legrand','<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-Legrand</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 : Legrand</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Laurent</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0603931947</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : fan.lolo1@orange.fr</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 : 11 rue des Crechaudes</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 85440</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Saint Hilaire La Forêt</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Nettoyage de toiture et imperméabilisant</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:--125002-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '704')  LIMIT 1 
UID:--125002--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:--125002-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Legrand',`att3`='Laurent',`att5`='0603931947',`att6`='fan.lolo1@orange.fr',`att8`='3466',`att10`='[IDMYUSER]',`att4`='0603931947',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3467')  AND (id_type = '149')  LIMIT 1 
UID:--125002-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Laurent',`att1`='Legrand',`att8`='non_défini',`att12`='fan.lolo1@orange.fr',`att14`='11 rue des Crechaudes',`att7`='85440',`att17`='Saint Hilaire La Forêt',`att18`='France',`att5`='0603931947',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250615',`att26`='',`att19`='46.449582',`att20`='-1.518928',`attf100`='1',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3466')  AND (id_type = '80')  LIMIT 1 
UID:--125002-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Laurent',`att1`='Legrand',`att8`='non_défini',`att12`='fan.lolo1@orange.fr',`att14`='11 rue des Crechaudes',`att7`='85440',`att17`='Saint Hilaire La Forêt',`att18`='France',`att5`='0603931947',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250615',`att26`='',`att19`='46.449582',`att20`='-1.518928',`attf100`='1',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3466')  AND (id_type = '80')  LIMIT 1 
UID:--125002-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Laurent',`att1`='Legrand',`att8`='non_défini',`att12`='fan.lolo1@orange.fr',`att14`='11 rue des Crechaudes',`att7`='85440',`att17`='Saint Hilaire La Forêt',`att18`='France',`att5`='0603931947',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250615',`att26`='',`att19`='46.449582',`att20`='-1.518928',`attf100`='1',`att6`='0603931947',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3466')  AND (id_type = '80')  LIMIT 1 
UID:--125002-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Legrand',`att2`='3466',`att90`='Nettoyage de toiture et imperméabilisant',`attf100`='20250615',`att8`='1743',`att6`='0',`att9`='3467',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202506151250',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '817')  AND (id_type = '148')  LIMIT 1 
UID:--163535--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:--163535--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--165727--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:--165727-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202506151657' )
UID:--165727-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='maison individuelle - panneaux photovoltaïques - Saint Nicolas de Port',`att90`='zlv92tgu2kqse06f',`attf100`='20250613',`att5`='3444',`att8`='6',`att9`='500',`att10`='50',`att11`='550',`att13`='chèque ou virement',`att14`='785',`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`='  5 rue victor legrand 54210 Saint-Nicolas-de-Port',`att18`='0',`att29`='500',`att24`='550',`att25`='5 rue victor legrand',`att26`='',`att27`='54210',`att28`='Saint-Nicolas-de-Port',`attdatmod`='202506151657',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '818')  AND (id_type = '168')  LIMIT 1 
UID:--165727-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '818')  LIMIT 1 
UID:--165727-- UPDATE  `tier_lig`  SET `lig2`='40',`ligdatmod`='202506151657',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '2')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '3')  LIMIT 1 
UID:--165727-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-40',`att3`='',`att2`='maison individuelle - panneaux photovoltaïques - Saint Nicolas de Port',`att90`='zlv92tgu2kqse06f',`attf100`='20250613',`att5`='3444',`att8`='6',`att9`='500',`att10`='50',`att11`='550',`att13`='chèque ou virement',`att14`='785',`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`='  5 rue victor legrand 54210 Saint-Nicolas-de-Port',`att18`='0',`att29`='500',`att24`='550',`att25`='5 rue victor legrand',`att26`='',`att27`='54210',`att28`='Saint-Nicolas-de-Port',`attdatmod`='202506151657',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '818')  AND (id_type = '168')  LIMIT 1 
UID:--165727-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','818','202506151657','202506151657' )
UID:--165727-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='145',`lig7`='50.00',`lig9`='145',`lig16`='Unite',`lig91`='<b>Nettoyage panneaux photovoltaïques</b><br /><p>Nettoyage des panneaux photovoltaïques</p>',`lig3`='1',`lig2`='500.00',`lig5`='10',`lig4`='500.00',`lig8`='550.00',`lig10`='euro',`lig6`='550.00',`lig90`='&lt;p&gt;Nettoyage des panneaux photovoltaïques&lt;/p&gt;',`ligdatmod`='202506151657',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '818')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1484')  LIMIT 1 
UID:--165727-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('309','1','2','Devis_DV-EPI-102_13_06_2025_08h_38m_signe.pdf','20250615','925','devis_signe','168','818','-2','-1','' )
UID:--165727-- UPDATE  `file`  SET `size`='176663'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '1013')  LIMIT 1 
UID:--165727-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('310','1','2','Attestation_fiscale_DV_EPI_102_13_06_2025_08h_37m_signe.pdf','20250615','98','attestation_signe','168','818','-2','-1','' )
UID:--165727-- UPDATE  `file`  SET `size`='475642'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '1014')  LIMIT 1 
UID:--165727-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250615','','1','contact@exteco.fr','Exteco','francoise.kuntz@orange.fr','','','Merci pour votre commande : Devis N°DV-EPI-102','<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-102)\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 KUNTZ,<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/1013-309-925-1§Devis_DV-EPI-102_13_06_2025_08h_38m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/1014-310-98-1§Attestation_fiscale_DV_EPI_102_13_06_2025_08h_37m_signe.pdf','0','v2017b' )
UID:--165727-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '705')  LIMIT 1 
UID:--165727-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250615','','1','contact@exteco.fr','Exteco','agence-epinal@exteco.fr','','','Devis signé - N° DV-EPI-102','<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-102)\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-102 de monsieur KUNTZ 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:--165727-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '706')  LIMIT 1 
UID:--165727-- UPDATE  `vent_lig`  SET `lig1`='145',`lig7`='50.00',`lig9`='145',`lig16`='Unite',`lig91`='<b>Nettoyage panneaux photovoltaïques</b><br /><p>Nettoyage des panneaux photovoltaïques</p>',`lig3`='1',`lig2`='500.00',`lig5`='10',`lig4`='500.00',`lig8`='550.00',`lig10`='euro',`lig6`='550.00',`lig90`='&lt;p&gt;Nettoyage des panneaux photovoltaïques&lt;/p&gt;',`ligdatmod`='202506151657',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '818')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '1484')  LIMIT 1 
UID:--165727-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-EPI-40',`att3`='',`att2`='maison individuelle - panneaux photovoltaïques - Saint Nicolas de Port',`att90`='zlv92tgu2kqse06f',`attf100`='20250613',`att5`='3444',`att8`='6',`att9`='500',`att10`='50',`att11`='550',`att13`='chèque ou virement',`att14`='785',`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`='  5 rue victor legrand 54210 Saint-Nicolas-de-Port',`att18`='0',`att29`='500',`att24`='550',`att25`='5 rue victor legrand',`att26`='',`att27`='54210',`att28`='Saint-Nicolas-de-Port',`att31`='50',`attdatmod`='202506151657',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '818')  AND (id_type = '168')  LIMIT 1 
UID:--165728-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='2',`attdatmod`='202506151657',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '784')  AND (id_type = '148')  LIMIT 1 
UID:--165728-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202506151657',`attdatmod`='202506151657',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '785')  AND (id_type = '165')  LIMIT 1 
UID:--165728-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202506151657',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3444')  AND (id_type = '80')  LIMIT 1 
UID:--204440-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506152044' )
UID:--204440-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sébastien',`att1`='Jodel',`att8`='non_défini',`att12`='jodel.sebastien@netcourrier.com',`att14`='6 rue des chardonnerets',`att7`='54310',`att17`='Homécourt',`att18`='France',`att5`='0662087108',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250615',`att26`='',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3468')  AND (id_type = '80')  LIMIT 1 
UID:--204440-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3468','202506152044','202506152044' )
UID:--204440-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='6 rue des chardonnerets',`lig4`='54310',`lig5`='Homécourt',`lig6`='France',`ligdatmod`='202506152044',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3468')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1744')  LIMIT 1 
UID:--204440-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sébastien',`att1`='Jodel',`att8`='non_défini',`att12`='jodel.sebastien@netcourrier.com',`att14`='6 rue des chardonnerets',`att7`='54310',`att17`='Homécourt',`att18`='France',`att5`='0662087108',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250615',`att26`='',`att19`='49.211378',`att20`='5.98972',`attf100`='1',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3468')  AND (id_type = '80')  LIMIT 1 
UID:--204440-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sébastien',`att1`='Jodel',`att8`='non_défini',`att12`='jodel.sebastien@netcourrier.com',`att14`='6 rue des chardonnerets',`att7`='54310',`att17`='Homécourt',`att18`='France',`att5`='0662087108',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250615',`att26`='',`att19`='49.211378',`att20`='5.98972',`attf100`='1',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3468')  AND (id_type = '80')  LIMIT 1 
UID:--204440-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506152044' )
UID:--204440-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Jodel',`att3`='Sébastien',`att5`='0662087108',`att6`='jodel.sebastien@netcourrier.com',`att8`='3468',`att10`='[IDMYUSER]',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3469')  AND (id_type = '149')  LIMIT 1 
UID:--204440-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506152044' )
UID:--204440-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3468',`att90`='Nettoyage des allées et de l&#039;entrée de jardin qui sont faites en opus de marbre.\r\nD&#039;autres travaux peut-être également (nettoyage de qqs murets , nettoyage toiture d&#039;une pergola situé dans le jardin) mais cela dépendra de vos tarifs.',`attf100`='20250615',`att8`='1744',`att6`='[IDMYUSER]',`att9`='3469',`att3`='§autres§',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '819')  AND (id_type = '148')  LIMIT 1 
UID:--204440-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Jodel',`att2`='3468',`att90`='Nettoyage des allées et de l&#039;entrée de jardin qui sont faites en opus de marbre.\r\nD&#039;autres travaux peut-être également (nettoyage de qqs murets , nettoyage toiture d&#039;une pergola situé dans le jardin) mais cela dépendra de vos tarifs.',`attf100`='20250615',`att8`='1744',`att6`='[IDMYUSER]',`att9`='3469',`att3`='§autres§',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '819')  AND (id_type = '148')  LIMIT 1 
UID:--204440-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Jodel',`att2`='3468',`att90`='Nettoyage des allées et de l&#039;entrée de jardin qui sont faites en opus de marbre.\r\nD&#039;autres travaux peut-être également (nettoyage de qqs murets , nettoyage toiture d&#039;une pergola situé dans le jardin) mais cela dépendra de vos tarifs.',`attf100`='20250615',`att8`='1744',`att6`='[IDMYUSER]',`att9`='3469',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '819')  AND (id_type = '148')  LIMIT 1 
UID:--204440-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Jodel',`att2`='3468',`att90`='Nettoyage des allées et de l&#039;entrée de jardin qui sont faites en opus de marbre.\r\nD&#039;autres travaux peut-être également (nettoyage de qqs murets , nettoyage toiture d&#039;une pergola situé dans le jardin) mais cela dépendra de vos tarifs.',`attf100`='20250615',`att8`='1744',`att6`='0',`att9`='3469',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '819')  AND (id_type = '148')  LIMIT 1 
UID:--204440-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250615','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Jodel','<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-Jodel</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 : Jodel</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Sébastien</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0662087108</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : jodel.sebastien@netcourrier.com</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Service : autres</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Adresse : 6 rue des chardonnerets</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 54310</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Homécourt</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Nettoyage des allées et de l&#039;entrée de jardin qui sont faites en opus de marbre.\r\nD&#039;autres travaux peut-être également (nettoyage de qqs murets , nettoyage toiture d&#039;une pergola situé dans le jardin) mais cela dépendra de vos tarifs.</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:--204440-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '707')  LIMIT 1 
UID:--204440--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:--204440-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Jodel',`att3`='Sébastien',`att5`='0662087108',`att6`='jodel.sebastien@netcourrier.com',`att8`='3468',`att10`='[IDMYUSER]',`att4`='0662087108',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3469')  AND (id_type = '149')  LIMIT 1 
UID:--204440-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sébastien',`att1`='Jodel',`att8`='non_défini',`att12`='jodel.sebastien@netcourrier.com',`att14`='6 rue des chardonnerets',`att7`='54310',`att17`='Homécourt',`att18`='France',`att5`='0662087108',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250615',`att26`='',`att19`='49.211378',`att20`='5.98972',`attf100`='1',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3468')  AND (id_type = '80')  LIMIT 1 
UID:--204440-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sébastien',`att1`='Jodel',`att8`='non_défini',`att12`='jodel.sebastien@netcourrier.com',`att14`='6 rue des chardonnerets',`att7`='54310',`att17`='Homécourt',`att18`='France',`att5`='0662087108',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250615',`att26`='',`att19`='49.211378',`att20`='5.98972',`attf100`='1',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3468')  AND (id_type = '80')  LIMIT 1 
UID:--204440-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Sébastien',`att1`='Jodel',`att8`='non_défini',`att12`='jodel.sebastien@netcourrier.com',`att14`='6 rue des chardonnerets',`att7`='54310',`att17`='Homécourt',`att18`='France',`att5`='0662087108',`attf102`='20250615',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250615',`att26`='',`att19`='49.211378',`att20`='5.98972',`attf100`='1',`att6`='0662087108',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3468')  AND (id_type = '80')  LIMIT 1 
UID:--204440-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Jodel',`att2`='3468',`att90`='Nettoyage des allées et de l&#039;entrée de jardin qui sont faites en opus de marbre.\r\nD&#039;autres travaux peut-être également (nettoyage de qqs murets , nettoyage toiture d&#039;une pergola situé dans le jardin) mais cela dépendra de vos tarifs.',`attf100`='20250615',`att8`='1744',`att6`='0',`att9`='3469',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202506152044',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '819')  AND (id_type = '148')  LIMIT 1 
UID:--230132--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:--230132--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre