UID:--102310--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:--102310--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--102332--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:--102332--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--145059-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202512071450' )
UID:--145059-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Marchetti',`att1`='Corinne',`att8`='non_défini',`att12`='corinne1604@hotmail.com',`att14`='Place calvaire 4',`att7`='57480',`att17`='Rustroff',`att18`='France',`att5`='00352661212439',`attf102`='20251207',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251207',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4897')  AND (id_type = '80')  LIMIT 1 
UID:--145059-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','4897','202512071450','202512071450' )
UID:--145059-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='Place calvaire 4',`lig4`='57480',`lig5`='Rustroff',`lig6`='France',`ligdatmod`='202512071450',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '4897')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '2475')  LIMIT 1 
UID:--145059-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Marchetti',`att1`='Corinne',`att8`='non_défini',`att12`='corinne1604@hotmail.com',`att14`='Place calvaire 4',`att7`='57480',`att17`='Rustroff',`att18`='France',`att5`='00352661212439',`attf102`='20251207',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251207',`att19`='49.443182',`att20`='6.372352',`attf100`='1',`att26`='',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4897')  AND (id_type = '80')  LIMIT 1 
UID:--145059-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Marchetti',`att1`='Corinne',`att8`='non_défini',`att12`='corinne1604@hotmail.com',`att14`='Place calvaire 4',`att7`='57480',`att17`='Rustroff',`att18`='France',`att5`='00352661212439',`attf102`='20251207',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251207',`att19`='49.443182',`att20`='6.372352',`attf100`='1',`att26`='',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4897')  AND (id_type = '80')  LIMIT 1 
UID:--145059-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202512071450' )
UID:--145059-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Corinne',`att3`='Marchetti',`att5`='00352661212439',`att6`='corinne1604@hotmail.com',`att8`='4897',`att10`='[IDMYUSER]',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4898')  AND (id_type = '149')  LIMIT 1 
UID:--145059-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202512071450' )
UID:--145059-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-',`att2`='4897',`att90`='Nettoyage terrasse',`attf100`='20251207',`att8`='2475',`att6`='[IDMYUSER]',`att9`='4898',`att3`='§terrasse§',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2835')  AND (id_type = '148')  LIMIT 1 
UID:--145059-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Corinne',`att2`='4897',`att90`='Nettoyage terrasse',`attf100`='20251207',`att8`='2475',`att6`='[IDMYUSER]',`att9`='4898',`att3`='§terrasse§',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2835')  AND (id_type = '148')  LIMIT 1 
UID:--145059-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Corinne',`att2`='4897',`att90`='Nettoyage terrasse',`attf100`='20251207',`att8`='2475',`att6`='[IDMYUSER]',`att9`='4898',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2835')  AND (id_type = '148')  LIMIT 1 
UID:--145059-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Corinne',`att2`='4897',`att90`='Nettoyage terrasse',`attf100`='20251207',`att8`='2475',`att6`='0',`att9`='4898',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2835')  AND (id_type = '148')  LIMIT 1 
UID:--145059-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251207','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Corinne','<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-Corinne</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Vous avez reçu une nouvelle demande de contact.<br><br>Coordonnées du contact :</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nom : Corinne</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Marchetti</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 00352661212439</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : corinne1604@hotmail.com</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Service : terrasse</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Adresse : Place calvaire 4</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 57480</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Rustroff</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Nettoyage terrasse</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:--145059-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3793')  LIMIT 1 
UID:--145059--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:--145059-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Corinne',`att3`='Marchetti',`att5`='00352661212439',`att6`='corinne1604@hotmail.com',`att8`='4897',`att10`='[IDMYUSER]',`att4`='00352661212439',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4898')  AND (id_type = '149')  LIMIT 1 
UID:--145059-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Marchetti',`att1`='Corinne',`att8`='non_défini',`att12`='corinne1604@hotmail.com',`att14`='Place calvaire 4',`att7`='57480',`att17`='Rustroff',`att18`='France',`att5`='00352661212439',`attf102`='20251207',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251207',`att19`='49.443182',`att20`='6.372352',`attf100`='1',`att26`='',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4897')  AND (id_type = '80')  LIMIT 1 
UID:--145059-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Marchetti',`att1`='Corinne',`att8`='non_défini',`att12`='corinne1604@hotmail.com',`att14`='Place calvaire 4',`att7`='57480',`att17`='Rustroff',`att18`='France',`att5`='00352661212439',`attf102`='20251207',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251207',`att19`='49.443182',`att20`='6.372352',`attf100`='1',`att26`='',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4897')  AND (id_type = '80')  LIMIT 1 
UID:--145059-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Marchetti',`att1`='Corinne',`att8`='non_défini',`att12`='corinne1604@hotmail.com',`att14`='Place calvaire 4',`att7`='57480',`att17`='Rustroff',`att18`='France',`att5`='00352661212439',`attf102`='20251207',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20251207',`att19`='49.443182',`att20`='6.372352',`attf100`='1',`att26`='',`att6`='00352661212439',`attdatmod`='202512071450',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4897')  AND (id_type = '80')  LIMIT 1 
UID:--145100-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Corinne',`att2`='4897',`att90`='Nettoyage terrasse',`attf100`='20251207',`att8`='2475',`att6`='0',`att9`='4898',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202512071451',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2835')  AND (id_type = '148')  LIMIT 1 
UID:--170629--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:--170629-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202512071706' )
UID:--170629-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle - Sols - Longwy',`att90`='t42g2d40lmkippfk',`attf100`='20251207',`att5`='4813',`att8`='8',`att9`='1951',`att10`='195.1',`att11`='2146.1',`att13`='virement',`att14`='2745',`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`='  18 Rue du Tivoli 54400 Longwy',`att18`='0',`att29`='1951',`att24`='2146.1',`att25`='18 Rue du Tivoli',`att26`='',`att27`='54400',`att28`='Longwy',`att41`='',`att42`='',`attdatmod`='202512071706',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2836')  AND (id_type = '168')  LIMIT 1 
UID:--170629-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '2836')  LIMIT 1 
UID:--170629-- UPDATE  `tier_lig`  SET `lig2`='142',`ligdatmod`='202512071706',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '8')  LIMIT 1 
UID:--170629-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-142',`att3`='',`att2`='Maison individuelle - Sols - Longwy',`att90`='t42g2d40lmkippfk',`attf100`='20251207',`att5`='4813',`att8`='8',`att9`='1951',`att10`='195.1',`att11`='2146.1',`att13`='virement',`att14`='2745',`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`='  18 Rue du Tivoli 54400 Longwy',`att18`='0',`att29`='1951',`att24`='2146.1',`att25`='18 Rue du Tivoli',`att26`='',`att27`='54400',`att28`='Longwy',`att41`='',`att42`='',`attdatmod`='202512071706',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2836')  AND (id_type = '168')  LIMIT 1 
UID:--170629-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2836','202512071706','202512071706' )
UID:--170629-- UPDATE  `vent_lig`  SET `actif`='1',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='<p>Partie Terrasse Bois</p>',`ligdatmod`='202512071706',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2836')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '5964')  LIMIT 1 
UID:--170629-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2836','202512071706','202512071706' )
UID:--170629-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='45.00',`lig9`='122',`lig16`='m2',`lig91`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='30',`lig2`='15.00',`lig5`='10',`lig4`='450.00',`lig8`='495.00',`lig10`='euro',`lig6`='495.00',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202512071706',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2836')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '5965')  LIMIT 1 
UID:--170629-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2836','202512071706','202512071706' )
UID:--170629-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='114',`lig7`='1.99',`lig16`='m2',`lig23`='1',`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`='1',`lig2`='19.90',`lig5`='10',`lig4`='19.90',`lig8`='21.89',`lig10`='euro',`lig6`='21.89',`lig90`='<p>Partie Terrasse Dalle</p>',`ligdatmod`='202512071706',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2836')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '5966')  LIMIT 1 
UID:--170629-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2836','202512071706','202512071706' )
UID:--170629-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='133.00',`lig9`='122',`lig16`='m2',`lig91`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='70',`lig2`='19.00',`lig5`='10',`lig4`='1330.00',`lig8`='1463.00',`lig10`='euro',`lig6`='1463.00',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202512071706',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2836')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '5967')  LIMIT 1 
UID:--170629-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2836','202512071706','202512071706' )
UID:--170629-- UPDATE  `vent_lig`  SET `actif`='1',`lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='<p>Partie Terrasse devant Garage + Partie terrasse devant Porte d\'entrée&nbsp;</p>',`ligdatmod`='202512071706',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2836')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '5968')  LIMIT 1 
UID:--170629-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','2836','202512071706','202512071706' )
UID:--170629-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='17.10',`lig9`='122',`lig16`='m2',`lig91`='<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`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202512071706',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2836')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '5969')  LIMIT 1 
UID:--170630-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1154','1','2','Devis_DV-METZ-301_01_12_2025_17h_49m_signe.pdf','20251207','819','devis_signe','168','2836','-2','-1','' )
UID:--170630-- UPDATE  `file`  SET `size`='644351'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5636')  LIMIT 1 
UID:--170630-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('1155','1','2','Attestation_fiscale_DV_METZ_301_28_11_2025_12h_18m_signe.pdf','20251207','52','attestation_signe','168','2836','-2','-1','' )
UID:--170630-- UPDATE  `file`  SET `size`='849916'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '5637')  LIMIT 1 
UID:--170630-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251207','','1','contact@exteco.fr','Exteco','julien@strelzyk.fr','','','Merci pour votre commande : Devis N°DV-METZ-301','<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-301)\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 STRELZYK,<br><br>Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.<br></p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nous prendrons contact avec vous rapidement pour programmer l\'intervention. En attendant, n\'hésitez pas à nous contacter si vous avez la moindre question ou besoin de clarification sur certains points.<br><br>\r\n                                Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.<br><br>\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe Exteco</p>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\"><br></div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>\r\n','/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5636-1154-819-1§Devis_DV-METZ-301_01_12_2025_17h_49m_signe.pdf;/home/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/5637-1155-52-1§Attestation_fiscale_DV_METZ_301_28_11_2025_12h_18m_signe.pdf','0','v2017b' )
UID:--170630-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3794')  LIMIT 1 
UID:--170630-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251207','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-301','<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-301)\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-301 de monsieur STRELZYK 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:--170630-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3795')  LIMIT 1 
UID:--170630-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-142',`att3`='',`att2`='Maison individuelle - Sols - Longwy',`att90`='t42g2d40lmkippfk',`attf100`='20251207',`att5`='4813',`att8`='8',`att9`='1951',`att10`='195.1',`att11`='2146.1',`att13`='virement',`att14`='2745',`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`='  18 Rue du Tivoli 54400 Longwy',`att18`='0',`att29`='1951',`att24`='2146.1',`att25`='18 Rue du Tivoli',`att26`='',`att27`='54400',`att28`='Longwy',`att41`='',`att42`='',`att39`='',`attdatmod`='202512071706',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2836')  AND (id_type = '168')  LIMIT 1 
UID:--170630-- UPDATE  `vent_lig`  SET `lig23`='1',`lig5`='10',`lig10`='euro',`lig90`='<p>Partie Terrasse Bois</p>',`lig3`='1',`lig4`='0.00',`lig8`='0.00',`lig6`='0.00',`ligdatmod`='202512071706',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '2836')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '5964')  LIMIT 1 
UID:--170630-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-142',`att3`='',`att2`='Maison individuelle - Sols - Longwy',`att90`='t42g2d40lmkippfk',`attf100`='20251207',`att5`='4813',`att8`='8',`att9`='1970.9',`att10`='197.09',`att11`='2167.99',`att13`='virement',`att14`='2745',`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`='  18 Rue du Tivoli 54400 Longwy',`att18`='0',`att29`='1970.9',`att24`='2167.99',`att25`='18 Rue du Tivoli',`att26`='',`att27`='54400',`att28`='Longwy',`att41`='',`att42`='',`att39`='',`att31`='197.09',`attdatmod`='202512071706',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2836')  AND (id_type = '168')  LIMIT 1 
UID:--170630-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='12',`attdatmod`='202512071706',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2686')  AND (id_type = '148')  LIMIT 1 
UID:--170630-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202512071706',`attdatmod`='202512071706',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2745')  AND (id_type = '165')  LIMIT 1 
UID:--170630-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202512071706',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '4813')  AND (id_type = '80')  LIMIT 1 
UID:--185755--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:--185755--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--190333--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:--190333--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--194011-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202512071940' )
UID:--194011-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-',`att2`='4881',`attf100`='20251207',`att8`='2467',`att6`='[IDMYUSER]',`att9`='4882',`att3`='§terrasse§',`attdatmod`='202512071940',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2837')  AND (id_type = '148')  LIMIT 1 
UID:--194011-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Ayad Nancy',`att2`='4881',`attf100`='20251207',`att8`='2467',`att6`='[IDMYUSER]',`att9`='4882',`att3`='§terrasse§',`attdatmod`='202512071940',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2837')  AND (id_type = '148')  LIMIT 1 
UID:--194011-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Ayad Nancy',`att2`='4881',`attf100`='20251207',`att8`='2467',`att6`='[IDMYUSER]',`att9`='4882',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202512071940',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2837')  AND (id_type = '148')  LIMIT 1 
UID:--194011-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Ayad Nancy',`att2`='4881',`attf100`='20251207',`att8`='2467',`att6`='0',`att9`='4882',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202512071940',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2837')  AND (id_type = '148')  LIMIT 1 
UID:--194011-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20251207','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Ayad Nancy','<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-Ayad Nancy</p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour,</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Vous avez reçu une nouvelle demande de contact.<br><br>Coordonnées du contact :</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Nom : Ayad Nancy</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Augustin Nancy</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0606060606</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : augustinNancy@gmail.com</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Service : terrasse</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Adresse : 30 boulevard vaugirard</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 75015</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Paris</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : </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:--194011-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '3796')  LIMIT 1 
UID:--194011--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:--194011-- UPDATE  `vent_att`  SET `att7`='lp_organic',`att1`='OPP-Ayad Nancy',`att2`='4881',`attf100`='20251207',`att8`='2467',`att6`='0',`att9`='4882',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202512071940',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '2837')  AND (id_type = '148')  LIMIT 1