UID:--085602-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202506210856' )
UID:--085602-- UPDATE `tier_att` SET `id_work`='259',`att3`='Kemal',`att1`='ALIOGLU',`att8`='non_défini',`att12`='kemal61_erdem@hotmail.com',`att14`='1 Rue Louis Majorelle, Saulxures-lès-Nancy, France',`att7`='54420',`att17`='Saulxures-lès-Nancy',`att18`='France',`att5`='0681085212',`attf102`='20250621',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250621',`att26`='',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3535') AND (id_type = '80') LIMIT 1
UID:--085602-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3535','202506210856','202506210856' )
UID:--085602-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='1 Rue Louis Majorelle, Saulxures-lès-Nancy, France',`lig4`='54420',`lig5`='Saulxures-lès-Nancy',`lig6`='France',`ligdatmod`='202506210856',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3535') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1776') LIMIT 1
UID:--085602-- UPDATE `tier_att` SET `id_work`='259',`att3`='Kemal',`att1`='ALIOGLU',`att8`='non_défini',`att12`='kemal61_erdem@hotmail.com',`att14`='1 Rue Louis Majorelle, Saulxures-lès-Nancy, France',`att7`='54420',`att17`='Saulxures-lès-Nancy',`att18`='France',`att5`='0681085212',`attf102`='20250621',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250621',`att26`='',`att19`='48.677049',`att20`='6.246312',`attf100`='1',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3535') AND (id_type = '80') LIMIT 1
UID:--085603-- UPDATE `tier_att` SET `id_work`='259',`att3`='Kemal',`att1`='ALIOGLU',`att8`='non_défini',`att12`='kemal61_erdem@hotmail.com',`att14`='1 Rue Louis Majorelle, Saulxures-lès-Nancy, France',`att7`='54420',`att17`='Saulxures-lès-Nancy',`att18`='France',`att5`='0681085212',`attf102`='20250621',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250621',`att26`='',`att19`='48.677049',`att20`='6.246312',`attf100`='1',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3535') AND (id_type = '80') LIMIT 1
UID:--085603-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202506210856' )
UID:--085603-- UPDATE `tier_att` SET `id_work`='367',`att2`='ALIOGLU',`att3`='Kemal',`att5`='0681085212',`att6`='kemal61_erdem@hotmail.com',`att8`='3535',`att10`='[IDMYUSER]',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3536') AND (id_type = '149') LIMIT 1
UID:--085603-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202506210856' )
UID:--085603-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-',`att2`='3535',`attf100`='20250621',`att8`='1776',`att6`='[IDMYUSER]',`att9`='3536',`att3`='§terrasse§',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '919') AND (id_type = '148') LIMIT 1
UID:--085603-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-ALIOGLU',`att2`='3535',`attf100`='20250621',`att8`='1776',`att6`='[IDMYUSER]',`att9`='3536',`att3`='§terrasse§',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '919') AND (id_type = '148') LIMIT 1
UID:--085603-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-ALIOGLU',`att2`='3535',`attf100`='20250621',`att8`='1776',`att6`='[IDMYUSER]',`att9`='3536',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '919') AND (id_type = '148') LIMIT 1
UID:--085603-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-ALIOGLU',`att2`='3535',`attf100`='20250621',`att8`='1776',`att6`='0',`att9`='3536',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '919') AND (id_type = '148') LIMIT 1
UID:--085603-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250621','','1','','Exteco','contact@exteco.fr','','','Exteco - Nouvelle opportunité - OPP-ALIOGLU','\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-ALIOGLU \r\n\r\n \r\n Bonjour, Vous avez reçu une nouvelle demande de contact.
Coordonnées du contact : Nom : ALIOGLU Prénom : Kemal Téléphone : 0681085212 Mail : kemal61_erdem@hotmail.com Service : terrasse Adresse : 1 Rue Louis Majorelle, Saulxures-lès-Nancy, France Code Postal : 54420 Ville : Saulxures-lès-Nancy Message :
Bonne prise de contact !
\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
','','0','v2017b' )
UID:--085603-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '802') LIMIT 1
UID:--085603--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:--085603-- UPDATE `tier_att` SET `id_work`='367',`att2`='ALIOGLU',`att3`='Kemal',`att5`='0681085212',`att6`='kemal61_erdem@hotmail.com',`att8`='3535',`att10`='[IDMYUSER]',`att4`='0681085212',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3536') AND (id_type = '149') LIMIT 1
UID:--085603-- UPDATE `tier_att` SET `id_work`='259',`att3`='Kemal',`att1`='ALIOGLU',`att8`='non_défini',`att12`='kemal61_erdem@hotmail.com',`att14`='1 Rue Louis Majorelle, Saulxures-lès-Nancy, France',`att7`='54420',`att17`='Saulxures-lès-Nancy',`att18`='France',`att5`='0681085212',`attf102`='20250621',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250621',`att26`='',`att19`='48.677049',`att20`='6.246312',`attf100`='1',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3535') AND (id_type = '80') LIMIT 1
UID:--085603-- UPDATE `tier_att` SET `id_work`='259',`att3`='Kemal',`att1`='ALIOGLU',`att8`='non_défini',`att12`='kemal61_erdem@hotmail.com',`att14`='1 Rue Louis Majorelle, Saulxures-lès-Nancy, France',`att7`='54420',`att17`='Saulxures-lès-Nancy',`att18`='France',`att5`='0681085212',`attf102`='20250621',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250621',`att26`='',`att19`='48.677049',`att20`='6.246312',`attf100`='1',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3535') AND (id_type = '80') LIMIT 1
UID:--085603-- UPDATE `tier_att` SET `id_work`='259',`att3`='Kemal',`att1`='ALIOGLU',`att8`='non_défini',`att12`='kemal61_erdem@hotmail.com',`att14`='1 Rue Louis Majorelle, Saulxures-lès-Nancy, France',`att7`='54420',`att17`='Saulxures-lès-Nancy',`att18`='France',`att5`='0681085212',`attf102`='20250621',`attf103`='1',`attf104`='1',`att11`='facebook_conversion_ads',`attf105`='20250621',`att26`='',`att19`='48.677049',`att20`='6.246312',`attf100`='1',`att6`='0681085212',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3535') AND (id_type = '80') LIMIT 1
UID:--085603-- UPDATE `vent_att` SET `att7`='facebook_conversion_ads',`att1`='OPP-ALIOGLU',`att2`='3535',`attf100`='20250621',`att8`='1776',`att6`='0',`att9`='3536',`att3`='§terrasse§',`att5`='',`att10`='non_défini',`attdatmod`='202506210856',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '919') AND (id_type = '148') LIMIT 1
UID:--133015--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:--133015--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--153534--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:--153534--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre
UID:--182426--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:--182426-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202506211824' )
UID:--182426-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Maison individuelle - Veranda-Px Photo-Pergolas - Beyren lès Sierck',`att90`='r8t4kioprvx0wnvk',`attf100`='20250621',`att5`='3450',`att8`='8',`att91`='<p>Petite machine</p>',`att9`='680',`att10`='68',`att11`='748',`att13`='',`att14`='847',`att15`='\n Rainea Exteco Metz
\n
\n 10 Rue Rochambeau
\n 57000 Metz
\n
<',`att16`=' 38 Rue de Sierck 57570 Beyren-lès-Sierck',`att18`='0',`att29`='680',`att24`='748',`att25`='38 Rue de Sierck',`att26`='',`att27`='57570',`att28`='Beyren-lès-Sierck',`attdatmod`='202506211824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '920') AND (id_type = '168') LIMIT 1
UID:--182426-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '920') LIMIT 1
UID:--182426-- UPDATE `tier_lig` SET `lig2`='25',`ligdatmod`='202506211824',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '8') LIMIT 1
UID:--182426-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-25',`att3`='',`att2`='Maison individuelle - Veranda-Px Photo-Pergolas - Beyren lès Sierck',`att90`='r8t4kioprvx0wnvk',`attf100`='20250621',`att5`='3450',`att8`='8',`att91`='<p>Petite machine</p>',`att9`='680',`att10`='68',`att11`='748',`att13`='',`att14`='847',`att15`='\n Rainea Exteco Metz
\n
\n 10 Rue Rochambeau
\n 57000 Metz
\n
<',`att16`=' 38 Rue de Sierck 57570 Beyren-lès-Sierck',`att18`='0',`att29`='680',`att24`='748',`att25`='38 Rue de Sierck',`att26`='',`att27`='57570',`att28`='Beyren-lès-Sierck',`attdatmod`='202506211824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '920') AND (id_type = '168') LIMIT 1
UID:--182426-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','920','202506211824','202506211824' )
UID:--182426-- UPDATE `vent_lig` SET `actif`='1',`lig1`='154',`lig7`='39.00',`lig9`='154',`lig16`='Unite',`lig22`='Partie Veranda',`lig91`='Partie Veranda
Nettoyage des vitres
',`lig3`='1',`lig2`='390.00',`lig5`='10',`lig4`='390.00',`lig8`='429.00',`lig10`='euro',`lig6`='429.00',`lig90`='<p>Nettoyage des vitres</p>',`ligdatmod`='202506211824',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '920') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '1671') LIMIT 1
UID:--182426-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','920','202506211824','202506211824' )
UID:--182426-- UPDATE `vent_lig` SET `actif`='1',`lig1`='138',`lig7`='29.00',`lig9`='138',`lig16`='Unite',`lig22`='Partie Pergolas',`lig91`='Partie Pergolas
Nettoyage de la pergola
',`lig3`='1',`lig2`='290.00',`lig5`='10',`lig4`='290.00',`lig8`='319.00',`lig10`='euro',`lig6`='319.00',`lig90`='<p>Nettoyage de la pergola</p>',`ligdatmod`='202506211824',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '920') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '1672') LIMIT 1
UID:--182427-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('355','1','2','Devis_DV-METZ-81_19_06_2025_15h_58m_signe.pdf','20250621','706','devis_signe','168','920','-2','-1','' )
UID:--182427-- UPDATE `file` SET `size`='249962' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '1253') LIMIT 1
UID:--182427-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('356','1','2','Attestation_fiscale_DV_METZ_81_19_06_2025_20h_46m_signe.pdf','20250621','853','attestation_signe','168','920','-2','-1','' )
UID:--182427-- UPDATE `file` SET `size`='856396' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '1254') LIMIT 1
UID:--182427-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250621','','1','contact@exteco.fr','Exteco','isaverna@gmail.com','','','Merci pour votre commande : Devis N°DV-METZ-81','\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 Merci pour votre commande (Devis N° DV-METZ-81)\r\n \r\n\r\n \r\n Bonjour monsieur OGER,
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
\r\n','/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/1253-355-706-1§Devis_DV-METZ-81_19_06_2025_15h_58m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/1254-356-853-1§Attestation_fiscale_DV_METZ_81_19_06_2025_20h_46m_signe.pdf','0','v2017b' )
UID:--182427-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '805') LIMIT 1
UID:--182427-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250621','','1','contact@exteco.fr','Exteco','agence-metz@exteco.fr','','','Devis signé - N° DV-METZ-81','\r\n\r\nDevis signé\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 Devis signé (Devis N° DV-METZ-81)\r\n \r\n\r\n \r\n Bonjour,
Le devis n°DV-METZ-81 de monsieur OGER a été signé électroniquement.
\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
','','0','v2017b' )
UID:--182427-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '806') LIMIT 1
UID:--182427-- UPDATE `vent_lig` SET `lig1`='154',`lig7`='39.00',`lig9`='154',`lig16`='Unite',`lig22`='Partie Veranda',`lig91`='Partie Veranda
Nettoyage des vitres
',`lig3`='1',`lig2`='390.00',`lig5`='10',`lig4`='390.00',`lig8`='429.00',`lig10`='euro',`lig6`='429.00',`lig90`='<p>Nettoyage des vitres</p>',`ligdatmod`='202506211824',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '920') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '1671') LIMIT 1
UID:--182427-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-METZ-25',`att3`='',`att2`='Maison individuelle - Veranda-Px Photo-Pergolas - Beyren lès Sierck',`att90`='r8t4kioprvx0wnvk',`attf100`='20250621',`att5`='3450',`att8`='8',`att91`='<p>Petite machine</p>',`att9`='680',`att10`='68',`att11`='748',`att13`='',`att14`='847',`att15`='\n Rainea Exteco Metz
\n
\n 10 Rue Rochambeau
\n 57000 Metz
\n
<',`att16`=' 38 Rue de Sierck 57570 Beyren-lès-Sierck',`att18`='0',`att29`='680',`att24`='748',`att25`='38 Rue de Sierck',`att26`='',`att27`='57570',`att28`='Beyren-lès-Sierck',`att31`='68',`attdatmod`='202506211824',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '920') AND (id_type = '168') LIMIT 1
UID:--182427-- UPDATE `vent_att` SET `id_work`='417',`att4`='8',`attdatmod`='202506211824',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '792') AND (id_type = '148') LIMIT 1
UID:--182427-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202506211824',`attdatmod`='202506211824',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '847') AND (id_type = '165') LIMIT 1
UID:--182427-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202506211824',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3450') AND (id_type = '80') LIMIT 1