UID:--061808--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:--061808--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:10--064943--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--064943--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--084322--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:--084322--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--085526-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505200855' ) UID:--085526-- UPDATE `tier_att` SET `id_work`='259',`att3`='Morgan',`att1`='Lamiable',`att8`='non_défini',`att12`='momo5406@hotmail.fr',`att14`='1 Rue Jean-Marie Pelt, Metzervisse, France',`att7`='57940',`att17`='Metzervisse',`att18`='France',`att5`='0635225647',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250520',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3198') AND (id_type = '80') LIMIT 1 UID:--085526-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3198','202505200855','202505200855' ) UID:--085526-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='1 Rue Jean-Marie Pelt, Metzervisse, France',`lig4`='57940',`lig5`='Metzervisse',`lig6`='France',`ligdatmod`='202505200855',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3198') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1611') LIMIT 1 UID:--085526-- UPDATE `tier_att` SET `id_work`='259',`att3`='Morgan',`att1`='Lamiable',`att8`='non_défini',`att12`='momo5406@hotmail.fr',`att14`='1 Rue Jean-Marie Pelt, Metzervisse, France',`att7`='57940',`att17`='Metzervisse',`att18`='France',`att5`='0635225647',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250520',`att19`='49.3107',`att20`='6.284126',`attf100`='1',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3198') AND (id_type = '80') LIMIT 1 UID:--085526-- UPDATE `tier_att` SET `id_work`='259',`att3`='Morgan',`att1`='Lamiable',`att8`='non_défini',`att12`='momo5406@hotmail.fr',`att14`='1 Rue Jean-Marie Pelt, Metzervisse, France',`att7`='57940',`att17`='Metzervisse',`att18`='France',`att5`='0635225647',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250520',`att19`='49.3107',`att20`='6.284126',`attf100`='1',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3198') AND (id_type = '80') LIMIT 1 UID:--085526-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505200855' ) UID:--085526-- UPDATE `tier_att` SET `id_work`='367',`att2`='Lamiable',`att3`='Morgan',`att5`='0635225647',`att6`='momo5406@hotmail.fr',`att8`='3198',`att10`='[IDMYUSER]',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3199') AND (id_type = '149') LIMIT 1 UID:--085526-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505200855' ) UID:--085526-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3198',`att90`='Nettoyage/demoussage toiture',`attf100`='20250520',`att8`='1611',`att6`='[IDMYUSER]',`att9`='3199',`att3`='§toiture§',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '498') AND (id_type = '148') LIMIT 1 UID:--085527-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Lamiable',`att2`='3198',`att90`='Nettoyage/demoussage toiture',`attf100`='20250520',`att8`='1611',`att6`='[IDMYUSER]',`att9`='3199',`att3`='§toiture§',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '498') AND (id_type = '148') LIMIT 1 UID:--085527-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Lamiable',`att2`='3198',`att90`='Nettoyage/demoussage toiture',`attf100`='20250520',`att8`='1611',`att6`='[IDMYUSER]',`att9`='3199',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '498') AND (id_type = '148') LIMIT 1 UID:--085527-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Lamiable',`att2`='3198',`att90`='Nettoyage/demoussage toiture',`attf100`='20250520',`att8`='1611',`att6`='0',`att9`='3199',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '498') AND (id_type = '148') LIMIT 1 UID:--085527-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250520','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Lamiable','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-Lamiable

\r\n\r\n

\r\n Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)

\r\n Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--085527-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '376') LIMIT 1 UID:--085527--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:--085527-- UPDATE `tier_att` SET `id_work`='367',`att2`='Lamiable',`att3`='Morgan',`att5`='0635225647',`att6`='momo5406@hotmail.fr',`att8`='3198',`att10`='[IDMYUSER]',`att4`='0635225647',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3199') AND (id_type = '149') LIMIT 1 UID:--085527-- UPDATE `tier_att` SET `id_work`='259',`att3`='Morgan',`att1`='Lamiable',`att8`='non_défini',`att12`='momo5406@hotmail.fr',`att14`='1 Rue Jean-Marie Pelt, Metzervisse, France',`att7`='57940',`att17`='Metzervisse',`att18`='France',`att5`='0635225647',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250520',`att19`='49.3107',`att20`='6.284126',`attf100`='1',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3198') AND (id_type = '80') LIMIT 1 UID:--085527-- UPDATE `tier_att` SET `id_work`='259',`att3`='Morgan',`att1`='Lamiable',`att8`='non_défini',`att12`='momo5406@hotmail.fr',`att14`='1 Rue Jean-Marie Pelt, Metzervisse, France',`att7`='57940',`att17`='Metzervisse',`att18`='France',`att5`='0635225647',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250520',`att19`='49.3107',`att20`='6.284126',`attf100`='1',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3198') AND (id_type = '80') LIMIT 1 UID:--085527-- UPDATE `tier_att` SET `id_work`='259',`att3`='Morgan',`att1`='Lamiable',`att8`='non_défini',`att12`='momo5406@hotmail.fr',`att14`='1 Rue Jean-Marie Pelt, Metzervisse, France',`att7`='57940',`att17`='Metzervisse',`att18`='France',`att5`='0635225647',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250520',`att19`='49.3107',`att20`='6.284126',`attf100`='1',`att6`='0635225647',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3198') AND (id_type = '80') LIMIT 1 UID:--085527-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Lamiable',`att2`='3198',`att90`='Nettoyage/demoussage toiture',`attf100`='20250520',`att8`='1611',`att6`='0',`att9`='3199',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505200855',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '498') AND (id_type = '148') LIMIT 1 UID:--090250--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:--090250--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--091921--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:--091921--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--092423--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:--092423--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093051--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:--093051--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093143--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:--093143--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093401--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 (90,88) ORDER BY pm.ordre UID:--093401--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093535--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:--093535--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093659--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:--093659--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093740--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 (90,88) ORDER BY pm.ordre UID:--093740--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--093819--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:--093819--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:10--093854--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--093854--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094101--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:--094101--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094445--SELECT DISTINCT pm.* FROM param_menu pm, param_drt_menu pdm WHERE pm.id_base=1 AND pm.id_base=pdm.id_base AND pm.id_menu=pdm.id_menu AND pdm.droit>0 AND pdm.id_role IN (89) ORDER BY pm.ordre UID:--094445--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094608-- UPDATE `my_user` SET `token`='lqk6nof3p.--.8m2v3b0' WHERE 1=1 AND (user_id = '7') LIMIT 1 UID:--094608-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250520','-1','','','','thomas.blaise1@gmail.com','Thomas BLAISE','','Renouvellement de votre mot de passe','\nNous avons reçu une demande de changement de mot de passe sur votre compte thomas.blaise1@gmail.com
\nCliquez sur ce lien pour pouvoir le changer :
\n
Changer le mot de passe
\n
\nSi vous n\'avez pas demandé de renouvellement de mot de passe, vous pouvez supprimer ce mail.
\nVotre mot de passe ne sera pas changé tant que vous n\'aurez pas utiliser le lien ci dessus.\n

https://exteco.toosmart.app/index.php?f=Mi1pZDoxOmlkLS1sb2dpbnBhZ2U6RF9yZXNldHBhc3M6bG9naW5wYWdlLS10b2tlbjpscWs2bm9mM3AuLS0uOG0ydjNiMDp0b2tlbi0y&logout=1','','0','v2017b' ) UID:--094608-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '377') LIMIT 1 UID:--094737--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:--094737--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094808--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 (90,88) ORDER BY pm.ordre UID:--094808--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--095048--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:--095048--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--095606--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 (90,88) ORDER BY pm.ordre UID:--095606--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--100646--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:--100646--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--104034--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 (90,88) ORDER BY pm.ordre UID:--104034--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:1--104810--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 (90,88) ORDER BY pm.ordre UID:1--104810--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--120421--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:--120421--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--121954--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 (90,88) ORDER BY pm.ordre UID:--121954--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--130726--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:--130726--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--131731--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:--131731--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--132128--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:--132128--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--140922--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:--140922--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141159--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 (90,88) ORDER BY pm.ordre UID:--141159--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141230--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:--141230--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--141410--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:--141410--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--141433--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--141433--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--155039--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:--155039--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--155513--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:--155513--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--162207--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:--162207--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--170141--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:--170141--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:2--170612--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('325','1','2','Adobe Scan 20 mai 2025.pdf','20250520','273','2','-3','-2') UID:2--170612--UPDATE `file` SET `last`='1' , `size`='1331729' , `fol_id`='2' , `esp_id`='1' WHERE file_id=495 UID:2--170612--UPDATE `file` SET `id_type`='168' , `id_obje`='511' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=495 UID:2--170612--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=495 UID:2--170612--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--170612--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','495','325','Adobe Scan 20 mai 2025.pdf','1','20250520','17:06:12','upload') UID:2--170644--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('326','1','2','Adobe Scan 20 mai 2025.pdf','20250520','123','2','-3','-2') UID:2--170644--UPDATE `file` SET `last`='1' , `size`='1331729' , `fol_id`='2' , `esp_id`='1' WHERE file_id=496 UID:2--170644--UPDATE `file` SET `id_type`='168' , `id_obje`='512' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=496 UID:2--170644--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=496 UID:2--170644--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--170644--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','496','326','Adobe Scan 20 mai 2025.pdf','1','20250520','17:06:44','upload') UID:2--170704--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('327','1','2','Adobe Scan 20 mai 2025.pdf','20250520','179','2','-3','-2') UID:2--170704--UPDATE `file` SET `last`='1' , `size`='1331729' , `fol_id`='2' , `esp_id`='1' WHERE file_id=497 UID:2--170704--UPDATE `file` SET `id_type`='168' , `id_obje`='513' , `specif`='attestation_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=497 UID:2--170704--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=497 UID:2--170704--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--170704--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','497','327','Adobe Scan 20 mai 2025.pdf','1','20250520','17:07:04','upload') UID:2--170712--INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`owner_id`,`fol_id`,`esp_id`) VALUES ('328','1','2','Adobe Scan 20 mai 2025.pdf','20250520','775','2','-3','-2') UID:2--170712--UPDATE `file` SET `last`='1' , `size`='1331729' , `fol_id`='2' , `esp_id`='1' WHERE file_id=498 UID:2--170712--UPDATE `file` SET `id_type`='168' , `id_obje`='513' , `specif`='devis_signe' , `file1`='' , `file2`='' , `id_data`='' WHERE file_id=498 UID:2--170712--UPDATE `file` SET `file3`='' , `file4`='' , `file5`='' WHERE file_id=498 UID:2--170712--UPDATE `folder` SET `count`='0' WHERE fol_id=2 and esp_id=1 UID:2--170712--INSERT INTO `down_history` (`esp_id`,`user_id`,`fol_id`,`file_id`,`name`,`filename`,`revision`,`date`,`heure`,`quoi`) VALUES ('1','2','2','498','328','Adobe Scan 20 mai 2025.pdf','1','20250520','17:07:12','upload') UID:2--170717--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:2--170717--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--170810--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 (90,88) ORDER BY pm.ordre UID:--170810--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--171819--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:--171819--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--184129--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:--184129-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505201841' ) UID:--184129-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='maison individuelle - toiture - Eloyes',`att90`='mdd35e9s6ee49f3u',`attf100`='20250507',`att5`='3039',`att8`='2',`att9`='4202.2',`att10`='420.22',`att11`='4622.42',`att13`='chèque ou virement',`att14`='295',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 11 Les Bruyères 88510 ELOYES',`att18`='637.6',`att24`='3984.82',`att25`='11 Les Bruyères',`att26`='',`att27`='88510',`att28`='ELOYES',`attdatmod`='202505201841',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '514') AND (id_type = '168') LIMIT 1 UID:--184129-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '514') LIMIT 1 UID:--184129-- UPDATE `tier_lig` SET `lig2`='23',`ligdatmod`='202505201841',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '2') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '3') LIMIT 1 UID:--184129-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-23',`att3`='',`att2`='maison individuelle - toiture - Eloyes',`att90`='mdd35e9s6ee49f3u',`attf100`='20250507',`att5`='3039',`att8`='2',`att9`='4202.2',`att10`='420.22',`att11`='4622.42',`att13`='chèque ou virement',`att14`='295',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 11 Les Bruyères 88510 ELOYES',`att18`='637.6',`att24`='3984.82',`att25`='11 Les Bruyères',`att26`='',`att27`='88510',`att28`='ELOYES',`attdatmod`='202505201841',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '514') AND (id_type = '168') LIMIT 1 UID:--184129-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','514','202505201841','202505201841' ) UID:--184129-- UPDATE `vent_lig` SET `actif`='1',`lig1`='65',`lig7`='28.00',`lig9`='65',`lig16`='Unite',`lig3`='1',`lig2`='280.00',`lig5`='10',`lig4`='280.00',`lig8`='308.00',`lig10`='euro',`lig6`='308.00',`lig90`='<p><br></p>',`ligdatmod`='202505201841',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '514') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '911') LIMIT 1 UID:--184129-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','514','202505201841','202505201841' ) UID:--184129-- UPDATE `vent_lig` SET `actif`='1',`lig1`='9',`lig7`='231.40',`lig9`='9',`lig16`='M2',`lig3`='178,6',`lig2`='13.00',`lig5`='10',`lig4`='2314.00',`lig8`='2545.40',`lig10`='pourcentage',`lig11`='11',`lig6`='2265.41',`lig90`='<p>\r\n</p><div>Nettoyage et démoussage du support via un procédé vapeur basse pression (de 30 à 60 bars maximum)</div>',`ligdatmod`='202505201841',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '514') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '912') LIMIT 1 UID:--184129-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','514','202505201841','202505201841' ) UID:--184129-- UPDATE `vent_lig` SET `actif`='1',`lig1`='25',`lig7`='122.82',`lig9`='25',`lig16`='M2',`lig3`='178,6',`lig2`='6.90',`lig5`='10',`lig4`='1228.20',`lig8`='1351.02',`lig10`='pourcentage',`lig11`='11',`lig6`='1202.41',`lig90`='<p>HydroGuard® Pro Formule Végétale protège durablement tous les matériaux minéraux poreux et permet de prévenir les principales causes de dégradations comme les infiltrations, érosion, cycle gel/dégel, formation de mousses et lichens... Il retarde le vieillissement du support et garde son aspect neuf plus longtemps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit d’imprégnation incolore qui laisse respirer le matériau. Le support reste ainsi perméable à l’air et à la vapeur d’eau. De plus, il résiste parfaitement aux UV et ne jaunit pas dans le temps.</p><p><br></p><p>HydroGuard® Pro Formule Végétale est un produit biosourcé issu de la biomasse. Il a été formulé à base d’ingrédients d’origine végétale (colza, tournesol, canola, soja). L’utilisation de molécules végétales représente une alternative éco-responsable aux ressources fossiles dommageables à l’environnement.</p>',`ligdatmod`='202505201841',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '514') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '913') LIMIT 1 UID:--184129-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','514','202505201841','202505201841' ) UID:--184129-- UPDATE `vent_lig` SET `actif`='1',`lig1`='49',`lig7`='19.00',`lig9`='49',`lig16`='Unite',`lig3`='1',`lig2`='190.00',`lig5`='10',`lig4`='190.00',`lig8`='209.00',`lig10`='euro',`lig6`='209.00',`lig90`='<p>Nettoyage des tuiles de rive via un procédé vapeur basse pression (de 30 à 60 bars maximum)</p>',`ligdatmod`='202505201841',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '514') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '914') LIMIT 1 UID:--184129-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','514','202505201841','202505201841' ) UID:--184129-- UPDATE `vent_lig` SET `actif`='1',`lig1`='41',`lig7`='19.00',`lig9`='41',`lig16`='Unite',`lig3`='1',`lig2`='190.00',`lig5`='10',`lig4`='190.00',`lig8`='209.00',`lig10`='pourcentage',`lig11`='100',`lig6`='0.00',`lig90`='<p>Nettoyage intérieur et extérieur des gouttières </p>',`ligdatmod`='202505201841',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '514') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '915') LIMIT 1 UID:--184129-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('169','1','2','Devis_DV-EPI-37_07_05_2025_10h_44m_signe.pdf','20250520','560','devis_signe','168','514','-2','-1','' ) UID:--184129-- UPDATE `file` SET `size`='605331' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '499') LIMIT 1 UID:--184129-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('170','1','2','Attestation_fiscale_DV_EPI_37_07_05_2025_10h_43m_signe.pdf','20250520','264','attestation_signe','168','514','-2','-1','' ) UID:--184129-- UPDATE `file` SET `size`='735975' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '500') LIMIT 1 UID:--184129-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250520','','1','tete_de_reseau@toosmart.fr','Exteco','frederic.savadoux@wanadoo.fr','','','Merci pour votre commande : Devis N°DV-EPI-37','\r\n\r\nNouveau Devis EXTECO\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Merci pour votre commande (Devis N° DV-EPI-37)\r\n

\r\n\r\n

\r\n Bonjour madame SAVADOUX,

Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.

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.

\r\n Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.

\r\n Cordialement,
\r\n

\r\n\r\n

\r\n Votre équipe Exteco

\r\n

\r\n
\r\n \r\n\r\n
\r\n
\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/499-169-560-1§Devis_DV-EPI-37_07_05_2025_10h_44m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/500-170-264-1§Attestation_fiscale_DV_EPI_37_07_05_2025_10h_43m_signe.pdf','0','v2017b' ) UID:--184129-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '386') LIMIT 1 UID:--184129-- UPDATE `vent_lig` SET `lig1`='65',`lig7`='28.00',`lig9`='65',`lig16`='Unite',`lig3`='1',`lig2`='280.00',`lig5`='10',`lig4`='280.00',`lig8`='308.00',`lig10`='euro',`lig6`='308.00',`lig90`='<p><br></p>',`ligdatmod`='202505201841',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '514') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '911') LIMIT 1 UID:--184129-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-23',`att3`='',`att2`='maison individuelle - toiture - Eloyes',`att90`='mdd35e9s6ee49f3u',`attf100`='20250507',`att5`='3039',`att8`='2',`att9`='4202.2',`att10`='420.22',`att11`='4622.42',`att13`='chèque ou virement',`att14`='295',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 11 Les Bruyères 88510 ELOYES',`att18`='490.63',`att24`='4131.79',`att25`='11 Les Bruyères',`att26`='',`att27`='88510',`att28`='ELOYES',`att31`='375.62',`att29`='3756.17',`attdatmod`='202505201841',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '514') AND (id_type = '168') LIMIT 1 UID:--184130-- UPDATE `vent_att` SET `id_work`='417',`att4`='15',`attdatmod`='202505201841',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '259') AND (id_type = '148') LIMIT 1 UID:--184130-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505201841',`attdatmod`='202505201841',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '295') AND (id_type = '165') LIMIT 1 UID:--184130-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202505201841',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3039') AND (id_type = '80') LIMIT 1 UID:--184359--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:--184359-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505201843' ) UID:--184359-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='maison individuelle - terrasse - Eloyes',`att90`='evj4i9fvnkc0mlxa',`attf100`='20250507',`att5`='3039',`att8`='2',`att9`='855',`att10`='85.5',`att11`='940.5',`att13`='chèque ou virement',`att14`='292',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 11 Les Bruyères 88510 ELOYES',`att18`='0',`att24`='940.5',`att25`='11 Les Bruyères',`att26`='',`att27`='88510',`att28`='ELOYES',`attdatmod`='202505201843',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '515') AND (id_type = '168') LIMIT 1 UID:--184359-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '515') LIMIT 1 UID:--184359-- UPDATE `tier_lig` SET `lig2`='24',`ligdatmod`='202505201843',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '2') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '3') LIMIT 1 UID:--184359-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-24',`att3`='',`att2`='maison individuelle - terrasse - Eloyes',`att90`='evj4i9fvnkc0mlxa',`attf100`='20250507',`att5`='3039',`att8`='2',`att9`='855',`att10`='85.5',`att11`='940.5',`att13`='chèque ou virement',`att14`='292',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 11 Les Bruyères 88510 ELOYES',`att18`='0',`att24`='940.5',`att25`='11 Les Bruyères',`att26`='',`att27`='88510',`att28`='ELOYES',`attdatmod`='202505201843',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '515') AND (id_type = '168') LIMIT 1 UID:--184359-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','515','202505201843','202505201843' ) UID:--184359-- UPDATE `vent_lig` SET `actif`='1',`lig1`='121',`lig7`='85.50',`lig9`='121',`lig16`='M2',`lig3`='57,50',`lig2`='15.00',`lig5`='10',`lig4`='855.00',`lig8`='940.50',`lig10`='euro',`lig6`='940.50',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202505201843',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '515') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '916') LIMIT 1 UID:--184359-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('171','1','2','Devis_DV-EPI-36_19_05_2025_19h_00m_signe.pdf','20250520','318','devis_signe','168','515','-2','-1','' ) UID:--184359-- UPDATE `file` SET `size`='507508' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '501') LIMIT 1 UID:--184359-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('172','1','2','Attestation_fiscale_DV_EPI_36_07_05_2025_10h_31m_signe.pdf','20250520','964','attestation_signe','168','515','-2','-1','' ) UID:--184359-- UPDATE `file` SET `size`='735979' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '502') LIMIT 1 UID:--184359-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250520','','1','tete_de_reseau@toosmart.fr','Exteco','frederic.savadoux@wanadoo.fr','','','Merci pour votre commande : Devis N°DV-EPI-36','\r\n\r\nNouveau Devis EXTECO\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Merci pour votre commande (Devis N° DV-EPI-36)\r\n

\r\n\r\n

\r\n Bonjour madame SAVADOUX,

Nous vous remercions pour votre commande. Vous trouverez ci-joint le devis que vous avez signé.

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.

\r\n Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.

\r\n Cordialement,
\r\n

\r\n\r\n

\r\n Votre équipe Exteco

\r\n

\r\n
\r\n \r\n\r\n
\r\n
\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/501-171-318-1§Devis_DV-EPI-36_19_05_2025_19h_00m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/502-172-964-1§Attestation_fiscale_DV_EPI_36_07_05_2025_10h_31m_signe.pdf','0','v2017b' ) UID:--184359-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '387') LIMIT 1 UID:--184359-- UPDATE `vent_lig` SET `lig1`='121',`lig7`='85.50',`lig9`='121',`lig16`='M2',`lig3`='57,50',`lig2`='15.00',`lig5`='10',`lig4`='855.00',`lig8`='940.50',`lig10`='euro',`lig6`='940.50',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202505201843',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '515') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '916') LIMIT 1 UID:--184359-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-EPI-24',`att3`='',`att2`='maison individuelle - terrasse - Eloyes',`att90`='evj4i9fvnkc0mlxa',`attf100`='20250507',`att5`='3039',`att8`='2',`att9`='855',`att10`='85.5',`att11`='940.5',`att13`='chèque ou virement',`att14`='292',`att15`='\n

Rainea Exteco Epinal

\n
\n

2 rue de la Ballastière
\n 88190 GOLBEY

\n ',`att16`=' 11 Les Bruyères 88510 ELOYES',`att18`='0',`att24`='940.5',`att25`='11 Les Bruyères',`att26`='',`att27`='88510',`att28`='ELOYES',`att31`='85.5',`att29`='855',`attdatmod`='202505201843',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '515') AND (id_type = '168') LIMIT 1 UID:--184400-- UPDATE `vent_att` SET `id_work`='417',`att4`='13',`attdatmod`='202505201844',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '291') AND (id_type = '148') LIMIT 1 UID:--184400-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505201844',`attdatmod`='202505201844',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '292') AND (id_type = '165') LIMIT 1 UID:--184906--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:--184906--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--201938--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:--201938--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:9--205821--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--205821--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--214436--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:--214436--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--215443--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:--215443--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:10--220346--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--220346--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--223949-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505202239' ) UID:--223949-- UPDATE `tier_att` SET `id_work`='259',`att3`='Francoise',`att1`='Vagner',`att8`='non_défini',`att12`='framboisev@hotmail.fr',`att14`='1 Impasse de la Prairie, 57220 Obervisse, France',`att7`='57220',`att17`='Obervisse',`att18`='France',`att5`='0612524070',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250520',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3208') AND (id_type = '80') LIMIT 1 UID:--223949-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3208','202505202239','202505202239' ) UID:--223949-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='1 Impasse de la Prairie, 57220 Obervisse, France',`lig4`='57220',`lig5`='Obervisse',`lig6`='France',`ligdatmod`='202505202239',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3208') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1615') LIMIT 1 UID:--223949-- UPDATE `tier_att` SET `id_work`='259',`att3`='Francoise',`att1`='Vagner',`att8`='non_défini',`att12`='framboisev@hotmail.fr',`att14`='1 Impasse de la Prairie, 57220 Obervisse, France',`att7`='57220',`att17`='Obervisse',`att18`='France',`att5`='0612524070',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250520',`att19`='49.151118',`att20`='6.589602',`attf100`='1',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3208') AND (id_type = '80') LIMIT 1 UID:--223949-- UPDATE `tier_att` SET `id_work`='259',`att3`='Francoise',`att1`='Vagner',`att8`='non_défini',`att12`='framboisev@hotmail.fr',`att14`='1 Impasse de la Prairie, 57220 Obervisse, France',`att7`='57220',`att17`='Obervisse',`att18`='France',`att5`='0612524070',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250520',`att19`='49.151118',`att20`='6.589602',`attf100`='1',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3208') AND (id_type = '80') LIMIT 1 UID:--223949-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505202239' ) UID:--223949-- UPDATE `tier_att` SET `id_work`='367',`att2`='Vagner',`att3`='Francoise',`att5`='0612524070',`att6`='framboisev@hotmail.fr',`att8`='3208',`att10`='[IDMYUSER]',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3209') AND (id_type = '149') LIMIT 1 UID:--223949-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505202239' ) UID:--223949-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3208',`att90`='Nettoyer un mur (côté pluie) longueur dumu 10 m',`attf100`='20250520',`att8`='1615',`att6`='[IDMYUSER]',`att9`='3209',`att3`='§façade§',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '516') AND (id_type = '148') LIMIT 1 UID:--223949-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Vagner',`att2`='3208',`att90`='Nettoyer un mur (côté pluie) longueur dumu 10 m',`attf100`='20250520',`att8`='1615',`att6`='[IDMYUSER]',`att9`='3209',`att3`='§façade§',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '516') AND (id_type = '148') LIMIT 1 UID:--223949-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Vagner',`att2`='3208',`att90`='Nettoyer un mur (côté pluie) longueur dumu 10 m',`attf100`='20250520',`att8`='1615',`att6`='[IDMYUSER]',`att9`='3209',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '516') AND (id_type = '148') LIMIT 1 UID:--223949-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Vagner',`att2`='3208',`att90`='Nettoyer un mur (côté pluie) longueur dumu 10 m',`attf100`='20250520',`att8`='1615',`att6`='0',`att9`='3209',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '516') AND (id_type = '148') LIMIT 1 UID:--223949-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250520','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Vagner','\r\n\r\nNouvelle opportunite\r\n\r\n\r\n\r\n\r\n \r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n\r\n
\r\n\r\n

\r\n Nouvelle opportunité - OPP-Vagner

\r\n\r\n

\r\n Bonjour Exteco, (Mail envoyé au franchiseur lors d\'une création de nouvelle opportunité depuis l\'api lead)

\r\n Une nouvelle opportunité a été enregistrée, vous pouvez aller la consulter avec le bouton ci-dessous.

\r\n Cordialement,


\r\n\r\n \r\n \r\n \r\n \r\n \r\n
\r\n \r\n \r\n \r\n \r\n
\r\n Consulter l\'opportunité\r\n
\r\n
\r\n
\r\n \r\n
\r\n
\r\n \r\n\r\n
\r\n
','','0','v2017b' ) UID:--223949-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '388') LIMIT 1 UID:--223949--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:--223950-- UPDATE `tier_att` SET `id_work`='367',`att2`='Vagner',`att3`='Francoise',`att5`='0612524070',`att6`='framboisev@hotmail.fr',`att8`='3208',`att10`='[IDMYUSER]',`att4`='0612524070',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3209') AND (id_type = '149') LIMIT 1 UID:--223950-- UPDATE `tier_att` SET `id_work`='259',`att3`='Francoise',`att1`='Vagner',`att8`='non_défini',`att12`='framboisev@hotmail.fr',`att14`='1 Impasse de la Prairie, 57220 Obervisse, France',`att7`='57220',`att17`='Obervisse',`att18`='France',`att5`='0612524070',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250520',`att19`='49.151118',`att20`='6.589602',`attf100`='1',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3208') AND (id_type = '80') LIMIT 1 UID:--223950-- UPDATE `tier_att` SET `id_work`='259',`att3`='Francoise',`att1`='Vagner',`att8`='non_défini',`att12`='framboisev@hotmail.fr',`att14`='1 Impasse de la Prairie, 57220 Obervisse, France',`att7`='57220',`att17`='Obervisse',`att18`='France',`att5`='0612524070',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250520',`att19`='49.151118',`att20`='6.589602',`attf100`='1',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3208') AND (id_type = '80') LIMIT 1 UID:--223950-- UPDATE `tier_att` SET `id_work`='259',`att3`='Francoise',`att1`='Vagner',`att8`='non_défini',`att12`='framboisev@hotmail.fr',`att14`='1 Impasse de la Prairie, 57220 Obervisse, France',`att7`='57220',`att17`='Obervisse',`att18`='France',`att5`='0612524070',`attf102`='20250520',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250520',`att19`='49.151118',`att20`='6.589602',`attf100`='1',`att6`='0612524070',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3208') AND (id_type = '80') LIMIT 1 UID:--223950-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Vagner',`att2`='3208',`att90`='Nettoyer un mur (côté pluie) longueur dumu 10 m',`attf100`='20250520',`att8`='1615',`att6`='0',`att9`='3209',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505202239',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '516') AND (id_type = '148') LIMIT 1