UID:--072959--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:--072959--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--073946--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:--073946--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:9--074120--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:9--074120--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--090039--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:--090039--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--090838--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:--090838--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:4--091512--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('1385','1','2','Devis Exteco_06.2025-1-2 (1).pdf','20250718','955','4','-3','-2')
UID:4--091512--UPDATE `file` SET `last`='1' , `size`='1451954' , `fol_id`='2' , `esp_id`='1' WHERE file_id=1868
UID:4--091512--UPDATE `file` SET `id_type`='169' , `id_obje`='317' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=1868
UID:4--091512--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=1868
UID:4--091512--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:4--091512--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','4','2','1868','1385','Devis Exteco_06.2025-1-2 (1).pdf','1','20250718','09:15:12','upload')
UID:4--091954--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('1387','1','2','devisExteco.pdf','20250718','791','4','-3','-2')
UID:4--091954--UPDATE `file` SET `last`='1' , `size`='259830' , `fol_id`='2' , `esp_id`='1' WHERE file_id=1870
UID:4--091954--UPDATE `file` SET `id_type`='169' , `id_obje`='318' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=1870
UID:4--091954--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=1870
UID:4--091954--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:4--091954--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','4','2','1870','1387','devisExteco.pdf','1','20250718','09:19:54','upload')
UID:--092701--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:--092701--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--102654--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:--102654--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--102732--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--102732--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--103558--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--103558--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:10--103624--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm
        WHERE pm.id_base=1 AND pm.id_base=pdm.id_base
        AND pm.id_menu=pdm.id_menu  AND pdm.droit>0 
        AND pdm.id_role IN (89)
        ORDER BY pm.ordre
UID:10--103624--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--105746--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:--105746--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:9--110111--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:9--110111--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:3--112144--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:3--112144--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--134716-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202507181347' )
UID:--134716-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Lucie',`att1`='Lepand',`att8`='non_défini',`att12`='lucielepand@hotmail.fr',`att14`='13 rue du 8 mai 1945',`att7`='54270',`att17`='Essey Les Nancy',`att18`='France',`att5`='0664543013',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3762')  AND (id_type = '80')  LIMIT 1 
UID:--134716-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3762','202507181347','202507181347' )
UID:--134716-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='13 rue du 8 mai 1945',`lig4`='54270',`lig5`='Essey Les Nancy',`lig6`='France',`ligdatmod`='202507181347',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3762')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1890')  LIMIT 1 
UID:--134716-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Lucie',`att1`='Lepand',`att8`='non_défini',`att12`='lucielepand@hotmail.fr',`att14`='13 rue du 8 mai 1945',`att7`='54270',`att17`='Essey Les Nancy',`att18`='France',`att5`='0664543013',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='48.701125',`att20`='6.226972',`attf100`='1',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3762')  AND (id_type = '80')  LIMIT 1 
UID:--134716-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Lucie',`att1`='Lepand',`att8`='non_défini',`att12`='lucielepand@hotmail.fr',`att14`='13 rue du 8 mai 1945',`att7`='54270',`att17`='Essey Les Nancy',`att18`='France',`att5`='0664543013',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='48.701125',`att20`='6.226972',`attf100`='1',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3762')  AND (id_type = '80')  LIMIT 1 
UID:--134716-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202507181347' )
UID:--134716-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Lepand',`att3`='Lucie',`att5`='0664543013',`att6`='lucielepand@hotmail.fr',`att8`='3762',`att10`='[IDMYUSER]',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3763')  AND (id_type = '149')  LIMIT 1 
UID:--134716-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202507181347' )
UID:--134716-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3762',`attf100`='20250718',`att8`='1890',`att6`='[IDMYUSER]',`att9`='3763',`att3`='§terrasse§',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1205')  AND (id_type = '148')  LIMIT 1 
UID:--134716-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Lepand',`att2`='3762',`attf100`='20250718',`att8`='1890',`att6`='[IDMYUSER]',`att9`='3763',`att3`='§terrasse§',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1205')  AND (id_type = '148')  LIMIT 1 
UID:--134716-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Lepand',`att2`='3762',`attf100`='20250718',`att8`='1890',`att6`='[IDMYUSER]',`att9`='3763',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1205')  AND (id_type = '148')  LIMIT 1 
UID:--134716-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Lepand',`att2`='3762',`attf100`='20250718',`att8`='1890',`att6`='0',`att9`='3763',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1205')  AND (id_type = '148')  LIMIT 1 
UID:--134716-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250718','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Lepand','<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-Lepand</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 : Lepand</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Lucie</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0664543013</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : lucielepand@hotmail.fr</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 : 13 rue du 8 mai 1945</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 54270</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Essey Les Nancy</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:--134716-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '1144')  LIMIT 1 
UID:--134716--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:--134718-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Lepand',`att3`='Lucie',`att5`='0664543013',`att6`='lucielepand@hotmail.fr',`att8`='3762',`att10`='[IDMYUSER]',`att4`='0664543013',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3763')  AND (id_type = '149')  LIMIT 1 
UID:--134718-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Lucie',`att1`='Lepand',`att8`='non_défini',`att12`='lucielepand@hotmail.fr',`att14`='13 rue du 8 mai 1945',`att7`='54270',`att17`='Essey Les Nancy',`att18`='France',`att5`='0664543013',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='48.701125',`att20`='6.226972',`attf100`='1',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3762')  AND (id_type = '80')  LIMIT 1 
UID:--134718-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Lucie',`att1`='Lepand',`att8`='non_défini',`att12`='lucielepand@hotmail.fr',`att14`='13 rue du 8 mai 1945',`att7`='54270',`att17`='Essey Les Nancy',`att18`='France',`att5`='0664543013',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='48.701125',`att20`='6.226972',`attf100`='1',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3762')  AND (id_type = '80')  LIMIT 1 
UID:--134718-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Lucie',`att1`='Lepand',`att8`='non_défini',`att12`='lucielepand@hotmail.fr',`att14`='13 rue du 8 mai 1945',`att7`='54270',`att17`='Essey Les Nancy',`att18`='France',`att5`='0664543013',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='48.701125',`att20`='6.226972',`attf100`='1',`att6`='0664543013',`attdatmod`='202507181347',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3762')  AND (id_type = '80')  LIMIT 1 
UID:--140334--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:--140334--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--141908--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:--141908--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:8--143052--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('1393','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250718','125','8','-3','-2')
UID:8--143052--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=1878
UID:8--143052--UPDATE `file` SET `id_type`='165' , `id_obje`='1207' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=1878
UID:8--143052--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=1878
UID:8--143052--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:8--143052--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','1878','1393','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250718','14:30:52','upload')
UID:8--143613--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('1396','1','2','Inscription au service Avance Immédiate-587 - METZ.pdf','20250718','563','8','-3','-2')
UID:8--143613--UPDATE `file` SET `last`='1' , `size`='593071' , `fol_id`='2' , `esp_id`='1' WHERE file_id=1882
UID:8--143613--UPDATE `file` SET `id_type`='165' , `id_obje`='1208' , `specif`='' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=1882
UID:8--143613--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=1882
UID:8--143613--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1
UID:8--143613--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','8','2','1882','1396','Inscription au service Avance Immédiate-587 - METZ.pdf','1','20250718','14:36:13','upload')
UID:--144811--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:--144811--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--150022--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:--150022--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--150156--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:--150156-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202507181501' )
UID:--150156-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Entreprise - Bardage - Norroy',`att90`='ewmgo-vvblo4m9ch',`attf100`='20250718',`att5`='3764',`att8`='8',`att9`='900',`att10`='180',`att11`='1080',`att13`='chèque ou virement',`att14`='1209',`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`='rue devant Beuheuil 57140 Norroy-le-Veneur',`att18`='0',`att29`='900',`att24`='1080',`att25`='rue devant Beuheuil',`att26`='',`att27`='57140',`att28`='Norroy-le-Veneur',`attdatmod`='202507181501',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1211')  AND (id_type = '168')  LIMIT 1 
UID:--150156-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '1211')  LIMIT 1 
UID:--150156-- UPDATE  `tier_lig`  SET `lig2`='39',`ligdatmod`='202507181501',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '8')  LIMIT 1 
UID:--150156-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-39',`att3`='',`att2`='Entreprise - Bardage - Norroy',`att90`='ewmgo-vvblo4m9ch',`attf100`='20250718',`att5`='3764',`att8`='8',`att9`='900',`att10`='180',`att11`='1080',`att13`='chèque ou virement',`att14`='1209',`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`='rue devant Beuheuil 57140 Norroy-le-Veneur',`att18`='0',`att29`='900',`att24`='1080',`att25`='rue devant Beuheuil',`att26`='',`att27`='57140',`att28`='Norroy-le-Veneur',`attdatmod`='202507181501',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1211')  AND (id_type = '168')  LIMIT 1 
UID:--150156-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','1211','202507181501','202507181501' )
UID:--150156-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='158',`lig7`='180.00',`lig9`='158',`lig22`='BARDAGE',`lig91`='<b>BARDAGE</b><br /><p>Nettoyage avec un procédé vapeur basse pression du bardage des 3 côtés du magasin ( hors coté rack ) </p><p><br></p>',`lig3`='1',`lig2`='900.00',`lig5`='20',`lig4`='900.00',`lig8`='1080.00',`lig10`='euro',`lig6`='1080.00',`lig90`='<p>Nettoyage avec un procédé vapeur basse pression du bardage des 3 côtés du magasin ( hors coté rack )&nbsp;</p><p><br></p>',`ligdatmod`='202507181501',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '1211')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '2266')  LIMIT 1 
UID:--150156-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('485','1','2','Devis_DV-METZ-117_18_07_2025_14h_42m_signe.pdf','20250718','580','devis_signe','168','1211','-2','-1','' )
UID:--150156-- UPDATE  `file`  SET `size`='293983'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '1888')  LIMIT 1 
UID:--150156-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250718','','1','contact@exteco.fr','Exteco','cbrichet@hydralians.com','','','Merci pour votre commande : Devis N°DV-METZ-117','<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-117)\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 BRICHET,<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/1888-485-580-1§Devis_DV-METZ-117_18_07_2025_14h_42m_signe.pdf','0','v2017b' )
UID:--150156-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '1149')  LIMIT 1 
UID:--150156-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250718','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-117','<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-117)\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-117 de monsieur BRICHET 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:--150156-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '1150')  LIMIT 1 
UID:--150156-- UPDATE  `vent_lig`  SET `lig1`='158',`lig7`='180.00',`lig9`='158',`lig22`='BARDAGE',`lig91`='<b>BARDAGE</b><br /><p>Nettoyage avec un procédé vapeur basse pression du bardage des 3 côtés du magasin ( hors coté rack ) </p><p><br></p>',`lig3`='1',`lig2`='900.00',`lig5`='20',`lig4`='900.00',`lig8`='1080.00',`lig10`='euro',`lig6`='1080.00',`lig90`='<p>Nettoyage avec un procédé vapeur basse pression du bardage des 3 côtés du magasin ( hors coté rack )&nbsp;</p><p><br></p>',`ligdatmod`='202507181501',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '1211')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '2266')  LIMIT 1 
UID:--150156-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-39',`att3`='',`att2`='Entreprise - Bardage - Norroy',`att90`='ewmgo-vvblo4m9ch',`attf100`='20250718',`att5`='3764',`att8`='8',`att9`='900',`att10`='180',`att11`='1080',`att13`='chèque ou virement',`att14`='1209',`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`='rue devant Beuheuil 57140 Norroy-le-Veneur',`att18`='0',`att29`='900',`att24`='1080',`att25`='rue devant Beuheuil',`att26`='',`att27`='57140',`att28`='Norroy-le-Veneur',`att31`='180',`attdatmod`='202507181501',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1211')  AND (id_type = '168')  LIMIT 1 
UID:--150157-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='0',`attdatmod`='202507181501',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1210')  AND (id_type = '148')  LIMIT 1 
UID:--150157-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202507181501',`attdatmod`='202507181501',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1209')  AND (id_type = '165')  LIMIT 1 
UID:--150157-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202507181501',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3764')  AND (id_type = '80')  LIMIT 1 
UID:--163151--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:--163151--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:8--163402--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:8--163402--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--170921-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202507181709' )
UID:--170921-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Dupont',`att1`='Loic',`att8`='non_défini',`att12`='loic85.ld@gmail.com',`att14`='32 rue de fameck',`att7`='57190',`att17`='Florange',`att18`='France',`att5`='0625866521',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3768')  AND (id_type = '80')  LIMIT 1 
UID:--170921-- INSERT INTO  `tier_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3768','202507181709','202507181709' )
UID:--170921-- UPDATE  `tier_lig`  SET `actif`='1',`lig7`='Adresse principale',`lig2`='32 rue de fameck',`lig4`='57190',`lig5`='Florange',`lig6`='France',`ligdatmod`='202507181709',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3768')  AND ( id_type = '80')  AND ( id_tlig = '147')  AND ( id_lig = '1893')  LIMIT 1 
UID:--170921-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Dupont',`att1`='Loic',`att8`='non_défini',`att12`='loic85.ld@gmail.com',`att14`='32 rue de fameck',`att7`='57190',`att17`='Florange',`att18`='France',`att5`='0625866521',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='49.315769',`att20`='6.111793',`attf100`='1',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3768')  AND (id_type = '80')  LIMIT 1 
UID:--170921-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Dupont',`att1`='Loic',`att8`='non_défini',`att12`='loic85.ld@gmail.com',`att14`='32 rue de fameck',`att7`='57190',`att17`='Florange',`att18`='France',`att5`='0625866521',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='49.315769',`att20`='6.111793',`attf100`='1',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3768')  AND (id_type = '80')  LIMIT 1 
UID:--170921-- INSERT INTO  `tier_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202507181709' )
UID:--170921-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Loic',`att3`='Dupont',`att5`='0625866521',`att6`='loic85.ld@gmail.com',`att8`='3768',`att10`='[IDMYUSER]',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3769')  AND (id_type = '149')  LIMIT 1 
UID:--170921-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202507181709' )
UID:--170921-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3768',`att90`='Nettoyage allée de garage',`attf100`='20250718',`att8`='1893',`att6`='[IDMYUSER]',`att9`='3769',`att3`='§autres§',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1216')  AND (id_type = '148')  LIMIT 1 
UID:--170921-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Loic',`att2`='3768',`att90`='Nettoyage allée de garage',`attf100`='20250718',`att8`='1893',`att6`='[IDMYUSER]',`att9`='3769',`att3`='§autres§',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1216')  AND (id_type = '148')  LIMIT 1 
UID:--170921-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Loic',`att2`='3768',`att90`='Nettoyage allée de garage',`attf100`='20250718',`att8`='1893',`att6`='[IDMYUSER]',`att9`='3769',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1216')  AND (id_type = '148')  LIMIT 1 
UID:--170921-- UPDATE  `vent_att`  SET `att7`='facebook_conversion_ads',`att1`='OPP-Loic',`att2`='3768',`att90`='Nettoyage allée de garage',`attf100`='20250718',`att8`='1893',`att6`='0',`att9`='3769',`att3`='§autres§',`att5`='',`att10`='non_défini',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1216')  AND (id_type = '148')  LIMIT 1 
UID:--170921-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250718','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-Loic','<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-Loic</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 : Loic</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Prénom : Dupont</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Téléphone : 0625866521</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Mail : loic85.ld@gmail.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 : 32 rue de fameck</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Code Postal : 57190</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Ville : Florange</p><p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">Message : Nettoyage allée de garage</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:--170921-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '1154')  LIMIT 1 
UID:--170921--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:--170921-- UPDATE  `tier_att`  SET `id_work`='367',`att2`='Loic',`att3`='Dupont',`att5`='0625866521',`att6`='loic85.ld@gmail.com',`att8`='3768',`att10`='[IDMYUSER]',`att4`='0625866521',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3769')  AND (id_type = '149')  LIMIT 1 
UID:--170921-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Dupont',`att1`='Loic',`att8`='non_défini',`att12`='loic85.ld@gmail.com',`att14`='32 rue de fameck',`att7`='57190',`att17`='Florange',`att18`='France',`att5`='0625866521',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='49.315769',`att20`='6.111793',`attf100`='1',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3768')  AND (id_type = '80')  LIMIT 1 
UID:--170921-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Dupont',`att1`='Loic',`att8`='non_défini',`att12`='loic85.ld@gmail.com',`att14`='32 rue de fameck',`att7`='57190',`att17`='Florange',`att18`='France',`att5`='0625866521',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='49.315769',`att20`='6.111793',`attf100`='1',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3768')  AND (id_type = '80')  LIMIT 1 
UID:--170921-- UPDATE  `tier_att`  SET `id_work`='259',`att3`='Dupont',`att1`='Loic',`att8`='non_défini',`att12`='loic85.ld@gmail.com',`att14`='32 rue de fameck',`att7`='57190',`att17`='Florange',`att18`='France',`att5`='0625866521',`attf102`='20250718',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250718',`att26`='',`att19`='49.315769',`att20`='6.111793',`attf100`='1',`att6`='0625866521',`attdatmod`='202507181709',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3768')  AND (id_type = '80')  LIMIT 1 
UID:--182842--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:--182842-- INSERT INTO  `vent_att`  (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202507181828' )
UID:--182842-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle - Terrasse - Saulny',`att90`='fblexja0v225vokv',`attf100`='20250718',`att5`='3675',`att8`='8',`att9`='1409.4',`att10`='140.94',`att11`='1550.34',`att13`='chèque ou virement',`att14`='1151',`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`='8 rue de Metz 57140 SAULNY',`att18`='0',`att29`='1409.4',`att24`='1550.34',`att25`='8 rue de Metz',`att26`='',`att27`='57140',`att28`='SAULNY',`attdatmod`='202507181828',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1217')  AND (id_type = '168')  LIMIT 1 
UID:--182842-- UPDATE  `vent_att`  SET `newobj`='new'  WHERE 1=1  AND (id_type = '168')  AND (id_vent = '1217')  LIMIT 1 
UID:--182842-- UPDATE  `tier_lig`  SET `lig2`='40',`ligdatmod`='202507181828',`ligusermod`= NULL   WHERE 1=1  AND ( id_tier = '3')  AND ( id_type = '152')  AND ( id_tlig = '163')  AND ( id_lig = '8')  LIMIT 1 
UID:--182842-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-40',`att3`='',`att2`='Maison individuelle - Terrasse - Saulny',`att90`='fblexja0v225vokv',`attf100`='20250718',`att5`='3675',`att8`='8',`att9`='1409.4',`att10`='140.94',`att11`='1550.34',`att13`='chèque ou virement',`att14`='1151',`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`='8 rue de Metz 57140 SAULNY',`att18`='0',`att29`='1409.4',`att24`='1550.34',`att25`='8 rue de Metz',`att26`='',`att27`='57140',`att28`='SAULNY',`attdatmod`='202507181828',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1217')  AND (id_type = '168')  LIMIT 1 
UID:--182842-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','1217','202507181828','202507181828' )
UID:--182842-- UPDATE  `vent_lig`  SET `actif`='1',`lig1`='122',`lig7`='140.94',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='81',`lig2`='17.40',`lig5`='10',`lig4`='1409.40',`lig8`='1550.34',`lig10`='euro',`lig6`='1550.34',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202507181828',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '1217')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '2274')  LIMIT 1 
UID:--182842-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('488','1','2','Devis_DV-METZ-111_11_07_2025_17h_25m_signe.pdf','20250718','576','devis_signe','168','1217','-2','-1','' )
UID:--182842-- UPDATE  `file`  SET `size`='511847'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '1897')  LIMIT 1 
UID:--182842-- INSERT INTO  `file`  (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('489','1','2','Attestation_fiscale_DV_METZ_111_11_07_2025_17h_23m_signe.pdf','20250718','112','attestation_signe','168','1217','-2','-1','' )
UID:--182842-- UPDATE  `file`  SET `size`='732573'  WHERE 1=1  AND (esp_id = '-1')  AND (file_id = '1898')  LIMIT 1 
UID:--182842-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250718','','1','contact@exteco.fr','Exteco','fatimabettahar78@gmail.com','','','Merci pour votre commande : Devis N°DV-METZ-111','<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-111)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour madame BETTAHAR,<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/1897-488-576-1§Devis_DV-METZ-111_11_07_2025_17h_25m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/1898-489-112-1§Attestation_fiscale_DV_METZ_111_11_07_2025_17h_23m_signe.pdf','0','v2017b' )
UID:--182842-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '1155')  LIMIT 1 
UID:--182842-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250718','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-111','<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-111)\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-111 de madame BETTAHAR 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:--182842-- UPDATE  `email`  SET `type`='',`bcc`='',`replyto`=''  WHERE 1=1  AND (id_email = '1156')  LIMIT 1 
UID:--182843-- UPDATE  `vent_lig`  SET `lig1`='122',`lig7`='140.94',`lig9`='122',`lig16`='M2',`lig91`='<b>Nettoyage de la terrasse (2)</b><br /><p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`lig3`='81',`lig2`='17.40',`lig5`='10',`lig4`='1409.40',`lig8`='1550.34',`lig10`='euro',`lig6`='1550.34',`lig90`='&lt;p&gt;Nettoyage et désinfection du support via un procédé vapeur basse pression &lt;/p&gt;',`ligdatmod`='202507181828',`ligusermod`= NULL   WHERE 1=1  AND ( id_vent = '1217')  AND ( id_type = '168')  AND ( id_tlig = '166')  AND ( id_lig = '2274')  LIMIT 1 
UID:--182843-- UPDATE  `vent_att`  SET `id_work`='419',`att4`='CH-METZ-40',`att3`='',`att2`='Maison individuelle - Terrasse - Saulny',`att90`='fblexja0v225vokv',`attf100`='20250718',`att5`='3675',`att8`='8',`att9`='1409.4',`att10`='140.94',`att11`='1550.34',`att13`='chèque ou virement',`att14`='1151',`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`='8 rue de Metz 57140 SAULNY',`att18`='0',`att29`='1409.4',`att24`='1550.34',`att25`='8 rue de Metz',`att26`='',`att27`='57140',`att28`='SAULNY',`att31`='140.94',`attdatmod`='202507181828',`attusermod`= NULL ,`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1217')  AND (id_type = '168')  LIMIT 1 
UID:--182845-- UPDATE  `vent_att`  SET `id_work`='417',`att4`='11',`attdatmod`='202507181828',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1083')  AND (id_type = '148')  LIMIT 1 
UID:--182845-- UPDATE  `vent_att`  SET `id_work`='412',`attf107`='202507181828',`attdatmod`='202507181828',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '1151')  AND (id_type = '165')  LIMIT 1 
UID:--182845-- UPDATE  `tier_att`  SET `id_work`='205',`attdatmod`='202507181828',`attusermod`='1586',`attflagmod`='0'  WHERE 1=1  AND ( id_tier = '3675')  AND (id_type = '80')  LIMIT 1