\n Rainea Exteco Metz
\n
\n 10 Rue Rochambeau
\n 57000 Metz
\n
<',`att16`=' 3 rue des Acacias 57970 Stuckange',`att18`='0',`att24`='1754.37',`att25`='3 rue des Acacias',`att26`='',`att27`='57970',`att28`='Stuckange',`attdatmod`='202505062301',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '284') AND (id_type = '168') LIMIT 1
UID:--230118-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '284') LIMIT 1
UID:--230118-- UPDATE `tier_lig` SET `lig2`='3',`ligdatmod`='202505062301',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '8') LIMIT 1
UID:--230118-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-3',`att3`='',`att2`='Maison individuelle - Nettoyage des pavés',`att90`='uourmhnmoqwqzfmm',`attf100`='20250430',`att5`='2971',`att8`='7',`att9`='1594.88',`att10`='159.49',`att11`='1754.37',`att13`='',`att14`='199',`att15`='\n Rainea Exteco Metz
\n
\n 10 Rue Rochambeau
\n 57000 Metz
\n
<',`att16`=' 3 rue des Acacias 57970 Stuckange',`att18`='0',`att24`='1754.37',`att25`='3 rue des Acacias',`att26`='',`att27`='57970',`att28`='Stuckange',`attdatmod`='202505062301',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '284') AND (id_type = '168') LIMIT 1
UID:--230118-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','284','202505062301','202505062301' )
UID:--230118-- UPDATE `vent_lig` SET `actif`='1',`lig1`='114',`lig7`='159.49',`lig9`='114',`lig16`='M2',`lig3`='89,3',`lig2`='17.92',`lig5`='10',`lig4`='1594.88',`lig8`='1754.37',`lig10`='euro',`lig6`='1754.37',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202505062301',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '284') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '403') LIMIT 1
UID:--230118-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('69','1','2','Devis_DV-METZ-7_30_04_2025_12h_45m_signe.pdf','20250506','405','devis_signe','168','284','-2','-1','' )
UID:--230118-- UPDATE `file` SET `size`='533807' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '227') LIMIT 1
UID:--230119-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('70','1','2','Attestation_fiscale_DV_METZ_7_30_04_2025_12h_41m_signe.pdf','20250506','271','attestation_signe','168','284','-2','-1','' )
UID:--230119-- UPDATE `file` SET `size`='815294' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '228') LIMIT 1
UID:--230119-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250506','','1','tete_de_reseau@toosmart.fr','Exteco','franck.thiriat@orange.fr','','','Merci pour votre commande : Devis N°DV-METZ-7','\r\n\r\n
Nouveau 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 Merci pour votre commande (Devis N° DV-METZ-7)\r\n \r\n\r\n \r\n Bonjour monsieur THIRIAT,
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 \r\n\r\n | \r\n
\r\n
\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/227-69-405-1§Devis_DV-METZ-7_30_04_2025_12h_45m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/228-70-271-1§Attestation_fiscale_DV_METZ_7_30_04_2025_12h_41m_signe.pdf','0','v2017b' )
UID:--230119-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '181') LIMIT 1
UID:--230119-- UPDATE `vent_lig` SET `lig1`='114',`lig7`='159.49',`lig9`='114',`lig16`='M2',`lig3`='89,3',`lig2`='17.92',`lig5`='10',`lig4`='1594.88',`lig8`='1754.37',`lig10`='euro',`lig6`='1754.37',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression </p>',`ligdatmod`='202505062301',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '284') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '403') LIMIT 1
UID:--230119-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-3',`att3`='',`att2`='Maison individuelle - Nettoyage des pavés',`att90`='uourmhnmoqwqzfmm',`attf100`='20250430',`att5`='2971',`att8`='7',`att9`='1594.88',`att10`='159.488',`att11`='1754.368',`att13`='',`att14`='199',`att15`='\n Rainea Exteco Metz
\n
\n 10 Rue Rochambeau
\n 57000 Metz
\n
<',`att16`=' 3 rue des Acacias 57970 Stuckange',`att18`='-0.0019999999997253',`att24`='1754.37',`att25`='3 rue des Acacias',`att26`='',`att27`='57970',`att28`='Stuckange',`att31`='159.49',`att29`='1594.88',`attdatmod`='202505062301',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '284') AND (id_type = '168') LIMIT 1
UID:--230119-- UPDATE `vent_att` SET `id_work`='417',`att4`='6',`attdatmod`='202505062301',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '197') AND (id_type = '148') LIMIT 1
UID:--230119-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505062301',`attdatmod`='202505062301',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '199') AND (id_type = '165') LIMIT 1
UID:--230119-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202505062301',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2971') AND (id_type = '80') LIMIT 1
UID:--231550-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505062315' )
UID:--231550-- UPDATE `tier_att` SET `id_work`='259',`att3`='Delphine',`att1`='Cam',`att8`='non_défini',`att12`='chenuetcam@free.fr',`att21`='10',`att14`='22 rue des frênes',`att7`='85600',`att17`='Boufféré',`att18`='France',`att5`='0680948714',`attf102`='20250506',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250506',`att24`='4',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3059') AND (id_type = '80') LIMIT 1
UID:--231550-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3059','202505062315','202505062315' )
UID:--231550-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='22 rue des frênes',`lig4`='85600',`lig5`='Boufféré',`lig6`='France',`ligdatmod`='202505062315',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3059') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1541') LIMIT 1
UID:--231550-- UPDATE `tier_lig` SET `lig2`='61',`ligdatmod`='202505062315',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '4') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '11') LIMIT 1
UID:--231550-- UPDATE `tier_att` SET `id_work`='259',`att3`='Delphine',`att1`='Cam',`att8`='non_défini',`att12`='chenuetcam@free.fr',`att21`='10',`att14`='22 rue des frênes',`att7`='85600',`att17`='Boufféré',`att18`='France',`att5`='0680948714',`attf102`='20250506',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250506',`att24`='4',`att19`='46.965759',`att20`='-1.340841',`att22`='CL-LSDO-61',`attf100`='1',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3059') AND (id_type = '80') LIMIT 1
UID:--231550-- UPDATE `tier_att` SET `id_work`='259',`att3`='Delphine',`att1`='Cam',`att8`='non_défini',`att12`='chenuetcam@free.fr',`att21`='10',`att14`='22 rue des frênes',`att7`='85600',`att17`='Boufféré',`att18`='France',`att5`='0680948714',`attf102`='20250506',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250506',`att24`='4',`att19`='46.965759',`att20`='-1.340841',`att22`='-1',`attf100`='1',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3059') AND (id_type = '80') LIMIT 1
UID:--231550-- UPDATE `tier_att` SET `id_work`='259',`att3`='Delphine',`att1`='Cam',`att8`='non_défini',`att12`='chenuetcam@free.fr',`att21`='10',`att14`='22 rue des frênes',`att7`='85600',`att17`='Boufféré',`att18`='France',`att5`='0680948714',`attf102`='20250506',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250506',`att24`='4',`att19`='46.965759',`att20`='-1.340841',`att22`='-1',`attf100`='1',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3059') AND (id_type = '80') LIMIT 1
UID:--231550-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505062315' )
UID:--231550-- UPDATE `tier_att` SET `id_work`='367',`att2`='Cam',`att3`='Delphine',`att5`='0680948714',`att6`='chenuetcam@free.fr',`att8`='3059',`att10`='[IDMYUSER]',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3060') AND (id_type = '149') LIMIT 1
UID:--231550-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505062315' )
UID:--231550-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3059',`attf100`='20250506',`att8`='1541',`att6`='[IDMYUSER]',`att9`='3060',`att3`='§toiture§',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '285') AND (id_type = '148') LIMIT 1
UID:--231550-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Cam',`att2`='3059',`attf100`='20250506',`att8`='1541',`att6`='[IDMYUSER]',`att9`='3060',`att3`='§toiture§',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '285') AND (id_type = '148') LIMIT 1
UID:--231550-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Cam',`att2`='3059',`attf100`='20250506',`att8`='1541',`att6`='[IDMYUSER]',`att9`='3060',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '285') AND (id_type = '148') LIMIT 1
UID:--231550-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Cam',`att2`='3059',`attf100`='20250506',`att8`='1541',`att6`='0',`att9`='3060',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '285') AND (id_type = '148') LIMIT 1
UID:--231550-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250506','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Cam','\r\n\r\n
Nouvelle 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 Nouvelle opportunité - OPP-Cam \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 | \r\n \r\n \r\n\r\n \r\n \r\n\r\n | \r\n
\r\n
','','0','v2017b' )
UID:--231550-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '182') LIMIT 1
UID:--231550--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:--231550-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250506','','1','','Exteco','mathieutheo@yahoo.fr','','','Exteco - Nouvelle opportunité - OPP-Cam','\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 Nouvelle opportunité - OPP-Cam \r\n\r\n \r\n Bonjour MATHIEU, (mail envoyé à la personne qui gère le client si le client existe déjà et qu\'il a déjà été affecté)
\r\n Une nouvelle opportunité vous a été affecté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 | \r\n \r\n \r\n\r\n \r\n \r\n\r\n | \r\n
\r\n
','','0','v2017b' )
UID:--231550-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '183') LIMIT 1
UID:--231550-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Cam',`att2`='3059',`attf100`='20250506',`att8`='1541',`att6`='10',`att9`='3060',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '285') AND (id_type = '148') LIMIT 1
UID:--231550-- UPDATE `tier_lig` SET `lig2`='62',`ligdatmod`='202505062315',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '4') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '11') LIMIT 1
UID:--231550-- UPDATE `tier_att` SET `id_work`='367',`att2`='Cam',`att3`='Delphine',`att5`='0680948714',`att6`='chenuetcam@free.fr',`att8`='3059',`att10`='[IDMYUSER]',`att4`='0680948714',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3060') AND (id_type = '149') LIMIT 1
UID:--231550-- UPDATE `tier_att` SET `id_work`='259',`att3`='Delphine',`att1`='Cam',`att8`='non_défini',`att12`='chenuetcam@free.fr',`att21`='10',`att14`='22 rue des frênes',`att7`='85600',`att17`='Boufféré',`att18`='France',`att5`='0680948714',`attf102`='20250506',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250506',`att24`='4',`att19`='46.965759',`att20`='-1.340841',`att22`='CL-LSDO-62',`attf100`='1',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3059') AND (id_type = '80') LIMIT 1
UID:--231550-- UPDATE `tier_att` SET `id_work`='259',`att3`='Delphine',`att1`='Cam',`att8`='non_défini',`att12`='chenuetcam@free.fr',`att21`='10',`att14`='22 rue des frênes',`att7`='85600',`att17`='Boufféré',`att18`='France',`att5`='0680948714',`attf102`='20250506',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250506',`att24`='4',`att19`='46.965759',`att20`='-1.340841',`att22`='CL-EPI-2616',`attf100`='1',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3059') AND (id_type = '80') LIMIT 1
UID:--231550-- UPDATE `tier_att` SET `id_work`='259',`att3`='Delphine',`att1`='Cam',`att8`='non_défini',`att12`='chenuetcam@free.fr',`att21`='10',`att14`='22 rue des frênes',`att7`='85600',`att17`='Boufféré',`att18`='France',`att5`='0680948714',`attf102`='20250506',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250506',`att24`='4',`att19`='46.965759',`att20`='-1.340841',`att22`='CL-EPI-2616',`attf100`='1',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3059') AND (id_type = '80') LIMIT 1
UID:--231550-- UPDATE `tier_att` SET `id_work`='259',`att3`='Delphine',`att1`='Cam',`att8`='non_défini',`att12`='chenuetcam@free.fr',`att21`='10',`att14`='22 rue des frênes',`att7`='85600',`att17`='Boufféré',`att18`='France',`att5`='0680948714',`attf102`='20250506',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250506',`att24`='4',`att19`='46.965759',`att20`='-1.340841',`att22`='CL-EPI-2616',`attf100`='1',`att6`='0680948714',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3059') AND (id_type = '80') LIMIT 1
UID:--231550-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-Cam',`att2`='3059',`attf100`='20250506',`att8`='1541',`att6`='10',`att9`='3060',`att3`='§toiture§',`att5`='',`att10`='non_défini',`attdatmod`='202505062315',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '285') AND (id_type = '148') LIMIT 1
UID:--233354--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:--233354--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre