UID:--092602--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:--092602--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--094655--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:--094655--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--111930--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:--111930--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--114840--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:--114840--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--124425-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','80','259','1','202505091244' ) UID:--124425-- UPDATE `tier_att` SET `id_work`='259',`att3`='Bruno',`att1`='Buttice',`att8`='non_défini',`att12`='brunobuttice@icloud.com',`att14`='56 rue du poncel',`att7`='54180',`att17`='Houdemont',`att18`='France',`att5`='0616988924',`attf102`='20250509',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250509',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3075') AND (id_type = '80') LIMIT 1 UID:--124425-- INSERT INTO `tier_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_tier`,`ligdatcre`,`ligdatmod` ) VALUES ('1','80','147','1','3075','202505091244','202505091244' ) UID:--124425-- UPDATE `tier_lig` SET `actif`='1',`lig7`='Adresse principale',`lig2`='56 rue du poncel',`lig4`='54180',`lig5`='Houdemont',`lig6`='France',`ligdatmod`='202505091244',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '3075') AND ( id_type = '80') AND ( id_tlig = '147') AND ( id_lig = '1549') LIMIT 1 UID:--124425-- UPDATE `tier_att` SET `id_work`='259',`att3`='Bruno',`att1`='Buttice',`att8`='non_défini',`att12`='brunobuttice@icloud.com',`att14`='56 rue du poncel',`att7`='54180',`att17`='Houdemont',`att18`='France',`att5`='0616988924',`attf102`='20250509',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250509',`att19`='48.637994',`att20`='6.177783',`attf100`='1',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3075') AND (id_type = '80') LIMIT 1 UID:--124425-- UPDATE `tier_att` SET `id_work`='259',`att3`='Bruno',`att1`='Buttice',`att8`='non_défini',`att12`='brunobuttice@icloud.com',`att14`='56 rue du poncel',`att7`='54180',`att17`='Houdemont',`att18`='France',`att5`='0616988924',`attf102`='20250509',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250509',`att19`='48.637994',`att20`='6.177783',`attf100`='1',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3075') AND (id_type = '80') LIMIT 1 UID:--124425-- INSERT INTO `tier_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','149','367','1','202505091244' ) UID:--124425-- UPDATE `tier_att` SET `id_work`='367',`att2`='Buttice',`att3`='Bruno',`att5`='0616988924',`att6`='brunobuttice@icloud.com',`att8`='3075',`att10`='[IDMYUSER]',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3076') AND (id_type = '149') LIMIT 1 UID:--124425-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202505091244' ) UID:--124425-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-',`att2`='3075',`attf100`='20250509',`att8`='1549',`att6`='[IDMYUSER]',`att9`='3076',`att3`='§façade§',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '318') AND (id_type = '148') LIMIT 1 UID:--124425-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Buttice',`att2`='3075',`attf100`='20250509',`att8`='1549',`att6`='[IDMYUSER]',`att9`='3076',`att3`='§façade§',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '318') AND (id_type = '148') LIMIT 1 UID:--124425-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Buttice',`att2`='3075',`attf100`='20250509',`att8`='1549',`att6`='[IDMYUSER]',`att9`='3076',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '318') AND (id_type = '148') LIMIT 1 UID:--124425-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Buttice',`att2`='3075',`attf100`='20250509',`att8`='1549',`att6`='0',`att9`='3076',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '318') AND (id_type = '148') LIMIT 1 UID:--124425-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250509','','1','','Exteco','tete_de_reseau@toosmart.fr','','','Exteco - Nouvelle opportunité - OPP-Buttice','\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-Buttice

\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:--124425-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '211') LIMIT 1 UID:--124425--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:--124425-- UPDATE `tier_att` SET `id_work`='367',`att2`='Buttice',`att3`='Bruno',`att5`='0616988924',`att6`='brunobuttice@icloud.com',`att8`='3075',`att10`='[IDMYUSER]',`att4`='0616988924',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3076') AND (id_type = '149') LIMIT 1 UID:--124425-- UPDATE `tier_att` SET `id_work`='259',`att3`='Bruno',`att1`='Buttice',`att8`='non_défini',`att12`='brunobuttice@icloud.com',`att14`='56 rue du poncel',`att7`='54180',`att17`='Houdemont',`att18`='France',`att5`='0616988924',`attf102`='20250509',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250509',`att19`='48.637994',`att20`='6.177783',`attf100`='1',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3075') AND (id_type = '80') LIMIT 1 UID:--124425-- UPDATE `tier_att` SET `id_work`='259',`att3`='Bruno',`att1`='Buttice',`att8`='non_défini',`att12`='brunobuttice@icloud.com',`att14`='56 rue du poncel',`att7`='54180',`att17`='Houdemont',`att18`='France',`att5`='0616988924',`attf102`='20250509',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250509',`att19`='48.637994',`att20`='6.177783',`attf100`='1',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3075') AND (id_type = '80') LIMIT 1 UID:--124425-- UPDATE `tier_att` SET `id_work`='259',`att3`='Bruno',`att1`='Buttice',`att8`='non_défini',`att12`='brunobuttice@icloud.com',`att14`='56 rue du poncel',`att7`='54180',`att17`='Houdemont',`att18`='France',`att5`='0616988924',`attf102`='20250509',`attf103`='1',`attf104`='1',`att11`='lp_organic',`attf105`='20250509',`att19`='48.637994',`att20`='6.177783',`attf100`='1',`att6`='0616988924',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_tier = '3075') AND (id_type = '80') LIMIT 1 UID:--124425-- UPDATE `vent_att` SET `att7`='lp_organic',`att1`='OPP-Buttice',`att2`='3075',`attf100`='20250509',`att8`='1549',`att6`='0',`att9`='3076',`att3`='§façade§',`att5`='',`att10`='non_défini',`attdatmod`='202505091244',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '318') AND (id_type = '148') LIMIT 1 UID:--131750--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:--131750--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--135823--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:--135823--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--142521--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:--142521--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--152533--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:--152533-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505091525' ) UID:--152533-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Nettoyage Façade',`att90`='f2qv4fztga462ewa',`attf100`='20250429',`att5`='2804',`att8`='9',`att91`='<p>Remise possible de 15% sur le total des deux devis si validation de l\'ensemble du chantier. </p>',`att9`='1797.5',`att10`='179.75',`att11`='1977.25',`att13`='chèque ou virement',`att14`='153',`att15`='\n

Rainea Exteco Sables d\'Olonnes

\n
\n

ZI les Plesses, 21 Rue Henri Farman
\n 85180 Les Sab',`att16`=' ',`att18`='0',`att24`='1977.25',`att25`='15 rue Camille Praud',`att26`='',`attdatmod`='202505091525',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '321') AND (id_type = '168') LIMIT 1 UID:--152533-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '321') LIMIT 1 UID:--152533-- UPDATE `tier_lig` SET `lig2`='6',`ligdatmod`='202505091525',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '4') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '13') LIMIT 1 UID:--152533-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-LSDO-6',`att3`='',`att2`='Nettoyage Façade',`att90`='f2qv4fztga462ewa',`attf100`='20250429',`att5`='2804',`att8`='9',`att91`='<p>Remise possible de 15% sur le total des deux devis si validation de l\'ensemble du chantier. </p>',`att9`='1797.5',`att10`='179.75',`att11`='1977.25',`att13`='chèque ou virement',`att14`='153',`att15`='\n

Rainea Exteco Sables d\'Olonnes

\n
\n

ZI les Plesses, 21 Rue Henri Farman
\n 85180 Les Sab',`att16`=' ',`att18`='0',`att24`='1977.25',`att25`='15 rue Camille Praud',`att26`='',`attdatmod`='202505091525',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '321') AND (id_type = '168') LIMIT 1 UID:--152533-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','321','202505091525','202505091525' ) UID:--152533-- UPDATE `vent_lig` SET `actif`='1',`lig1`='19',`lig7`='84.50',`lig9`='19',`lig16`='M2',`lig3`='65',`lig2`='13.00',`lig5`='10',`lig4`='845.00',`lig8`='929.50',`lig10`='euro',`lig6`='929.50',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression (de 30 à 60 bars maximum)</p>',`ligdatmod`='202505091525',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '321') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '492') LIMIT 1 UID:--152533-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','321','202505091525','202505091525' ) UID:--152533-- UPDATE `vent_lig` SET `actif`='1',`lig1`='27',`lig7`='86.25',`lig9`='27',`lig16`='M2',`lig3`='125',`lig2`='6.90',`lig5`='10',`lig4`='862.50',`lig8`='948.75',`lig10`='euro',`lig6`='948.75',`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`='202505091525',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '321') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '493') LIMIT 1 UID:--152533-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','321','202505091525','202505091525' ) UID:--152533-- UPDATE `vent_lig` SET `actif`='1',`lig1`='91',`lig7`='9.00',`lig9`='91',`lig16`='Unite',`lig3`='1',`lig2`='90.00',`lig5`='10',`lig4`='90.00',`lig8`='99.00',`lig10`='euro',`lig6`='99.00',`lig90`='<p>Nettoyage fin de chantier (incluant vitrerie extérieure de la zone nettoyée) (1)</p>',`ligdatmod`='202505091525',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '321') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '494') LIMIT 1 UID:--152533-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('89','1','2','Devis_DV-LSDO-15_05_05_2025_14h_38m_signe.pdf','20250509','418','devis_signe','168','321','-2','-1','' ) UID:--152533-- UPDATE `file` SET `size`='1428921' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '279') LIMIT 1 UID:--152533-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('90','1','2','Attestation_fiscale_DV_LSDO_15_29_04_2025_13h_30m_signe.pdf','20250509','177','attestation_signe','168','321','-2','-1','' ) UID:--152533-- UPDATE `file` SET `size`='759094' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '280') LIMIT 1 UID:--152533-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250509','','1','tete_de_reseau@toosmart.fr','Exteco','jb-roy@orange.fr','','','Merci pour votre commande : Devis N°DV-LSDO-15','\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-LSDO-15)\r\n

\r\n\r\n

\r\n Bonjour monsieur ROY,

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/279-89-418-1§Devis_DV-LSDO-15_05_05_2025_14h_38m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/280-90-177-1§Attestation_fiscale_DV_LSDO_15_29_04_2025_13h_30m_signe.pdf','0','v2017b' ) UID:--152533-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '213') LIMIT 1 UID:--152533-- UPDATE `vent_lig` SET `lig1`='19',`lig7`='84.50',`lig9`='19',`lig16`='M2',`lig3`='65',`lig2`='13.00',`lig5`='10',`lig4`='845.00',`lig8`='929.50',`lig10`='euro',`lig6`='929.50',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression (de 30 à 60 bars maximum)</p>',`ligdatmod`='202505091525',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '321') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '492') LIMIT 1 UID:--152533-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-LSDO-6',`att3`='',`att2`='Nettoyage Façade',`att90`='f2qv4fztga462ewa',`attf100`='20250429',`att5`='2804',`att8`='9',`att91`='<p>Remise possible de 15% sur le total des deux devis si validation de l\'ensemble du chantier. </p>',`att9`='1797.5',`att10`='179.75',`att11`='1977.25',`att13`='chèque ou virement',`att14`='153',`att15`='\n

Rainea Exteco Sables d\'Olonnes

\n
\n

ZI les Plesses, 21 Rue Henri Farman
\n 85180 Les Sab',`att16`=' ',`att18`='0',`att24`='1977.25',`att25`='15 rue Camille Praud',`att26`='',`att31`='179.75',`att29`='1797.5',`attdatmod`='202505091525',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '321') AND (id_type = '168') LIMIT 1 UID:--152534-- UPDATE `vent_att` SET `id_work`='417',`att4`='15',`attdatmod`='202505091525',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '47') AND (id_type = '148') LIMIT 1 UID:--152534-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505091525',`attdatmod`='202505091525',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '153') AND (id_type = '165') LIMIT 1 UID:--152534-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202505091525',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2804') AND (id_type = '80') LIMIT 1 UID:--171130--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:--171130--SELECT * FROM param_menu_lien WHERE id_base=1 AND ordre>0 ORDER BY ordre UID:--211843--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:--211843-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','168','419','1','202505092118' ) UID:--211843-- UPDATE `vent_att` SET `id_work`='419',`att4`='TEMPNUM',`att3`='',`att2`='Nettoyage toiture',`att90`='9kibagu0qiaa3gh8',`attf100`='20250502',`att5`='2865',`att8`='10',`att91`='<p><br></p>',`att9`='4392.7',`att10`='439.27',`att11`='4831.97',`att13`='chèque ou virement',`att14`='233',`att15`='\n

Rainea Exteco Sables d\'Olonnes

\n
\n

ZI les Plesses, 21 Rue Henri Farman
\n 85180 Les Sab',`att16`=' 18bis rue de la cantine 85680 Guérinière',`att18`='616',`att24`='4215.97',`att25`='18bis rue de la cantine',`att26`='',`att27`='85680',`att28`='Guérinière',`attdatmod`='202505092118',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '324') AND (id_type = '168') LIMIT 1 UID:--211843-- UPDATE `vent_att` SET `newobj`='new' WHERE 1=1 AND (id_type = '168') AND (id_vent = '324') LIMIT 1 UID:--211843-- UPDATE `tier_lig` SET `lig2`='7',`ligdatmod`='202505092118',`ligusermod`= NULL WHERE 1=1 AND ( id_tier = '4') AND ( id_type = '152') AND ( id_tlig = '163') AND ( id_lig = '13') LIMIT 1 UID:--211843-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-LSDO-7',`att3`='',`att2`='Nettoyage toiture',`att90`='9kibagu0qiaa3gh8',`attf100`='20250502',`att5`='2865',`att8`='10',`att91`='<p><br></p>',`att9`='4392.7',`att10`='439.27',`att11`='4831.97',`att13`='chèque ou virement',`att14`='233',`att15`='\n

Rainea Exteco Sables d\'Olonnes

\n
\n

ZI les Plesses, 21 Rue Henri Farman
\n 85180 Les Sab',`att16`=' 18bis rue de la cantine 85680 Guérinière',`att18`='616',`att24`='4215.97',`att25`='18bis rue de la cantine',`att26`='',`att27`='85680',`att28`='Guérinière',`attdatmod`='202505092118',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '324') AND (id_type = '168') LIMIT 1 UID:--211843-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','324','202505092118','202505092118' ) UID:--211843-- UPDATE `vent_lig` SET `actif`='1',`lig1`='67',`lig7`='28.00',`lig9`='67',`lig16`='Unite',`lig3`='1',`lig2`='280.00',`lig5`='10',`lig4`='280.00',`lig8`='308.00',`lig10`='pourcentage',`lig11`='100',`lig6`='0.00',`lig90`='<p><br></p>',`ligdatmod`='202505092118',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '324') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '499') LIMIT 1 UID:--211843-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','324','202505092118','202505092118' ) UID:--211843-- UPDATE `vent_lig` SET `actif`='1',`lig1`='19',`lig7`='224.90',`lig9`='19',`lig16`='M2',`lig3`='173',`lig2`='13.00',`lig5`='10',`lig4`='2249.00',`lig8`='2473.90',`lig10`='euro',`lig6`='2473.90',`lig90`='<p>Nettoyage et désinfection du support via un procédé vapeur basse pression (de 30 à 60 bars maximum)</p>',`ligdatmod`='202505092118',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '324') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '500') LIMIT 1 UID:--211843-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','324','202505092118','202505092118' ) UID:--211843-- UPDATE `vent_lig` SET `actif`='1',`lig1`='27',`lig7`='119.37',`lig9`='27',`lig16`='M2',`lig3`='173',`lig2`='6.90',`lig5`='10',`lig4`='1193.70',`lig8`='1313.07',`lig10`='euro',`lig6`='1313.07',`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`='202505092118',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '324') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '501') LIMIT 1 UID:--211843-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','324','202505092118','202505092118' ) UID:--211843-- UPDATE `vent_lig` SET `actif`='1',`lig1`='43',`lig7`='19.00',`lig9`='43',`lig16`='Unite',`lig3`='1',`lig2`='190.00',`lig5`='10',`lig4`='190.00',`lig8`='209.00',`lig10`='pourcentage',`lig11`='100',`lig6`='0.00',`lig90`='<p>Forfait nettoyage des gouttières</p>',`ligdatmod`='202505092118',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '324') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '502') LIMIT 1 UID:--211843-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','324','202505092118','202505092118' ) UID:--211843-- UPDATE `vent_lig` SET `actif`='1',`lig1`='91',`lig7`='9.00',`lig9`='91',`lig16`='Unite',`lig3`='1',`lig2`='90.00',`lig5`='10',`lig4`='90.00',`lig8`='99.00',`lig10`='pourcentage',`lig11`='100',`lig6`='0.00',`lig90`='<p>Nettoyage fin de chantier (incluant vitrerie extérieure de la zone nettoyée) (1)</p>',`ligdatmod`='202505092118',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '324') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '503') LIMIT 1 UID:--211843-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','324','202505092118','202505092118' ) UID:--211843-- UPDATE `vent_lig` SET `actif`='1',`lig16`='Unité',`lig5`='10',`lig10`='euro',`lig90`='

Véranda

',`ligdatmod`='202505092118',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '324') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '504') LIMIT 1 UID:--211843-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','168','166','1','324','202505092118','202505092118' ) UID:--211843-- UPDATE `vent_lig` SET `actif`='1',`lig1`='155',`lig7`='39.00',`lig9`='155',`lig16`='Unite',`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`='202505092118',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '324') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '505') LIMIT 1 UID:--211844-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('92','1','2','Devis_DV-LSDO-20_05_05_2025_14h_14m_signe.pdf','20250509','177','devis_signe','168','324','-2','-1','' ) UID:--211844-- UPDATE `file` SET `size`='1321465' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '283') LIMIT 1 UID:--211844-- INSERT INTO `file` (`name`,`revision`,`last`,`filename`,`date`,`random`,`specif`,`id_type`,`id_obje`,`fol_id`,`esp_id`,`owner_id` ) VALUES ('93','1','2','Attestation_fiscale_DV_LSDO_20_02_05_2025_16h_07m_signe.pdf','20250509','810','attestation_signe','168','324','-2','-1','' ) UID:--211844-- UPDATE `file` SET `size`='770491' WHERE 1=1 AND (esp_id = '-1') AND (file_id = '284') LIMIT 1 UID:--211844-- INSERT INTO `email` (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20250509','','1','tete_de_reseau@toosmart.fr','Exteco','aubernonpatrice@gmail.com','','','Merci pour votre commande : Devis N°DV-LSDO-20','\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-LSDO-20)\r\n

\r\n\r\n

\r\n Bonjour monsieur Aubernon,

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/283-92-177-1§Devis_DV-LSDO-20_05_05_2025_14h_14m_signe.pdf;/mnt/big/prod/toosmart_exteco/soft/v2017b/../../data/doc/-1/284-93-810-1§Attestation_fiscale_DV_LSDO_20_02_05_2025_16h_07m_signe.pdf','0','v2017b' ) UID:--211844-- UPDATE `email` SET `type`='',`bcc`='',`replyto`='' WHERE 1=1 AND (id_email = '215') LIMIT 1 UID:--211844-- UPDATE `vent_lig` SET `lig1`='67',`lig7`='28.00',`lig9`='67',`lig16`='Unite',`lig3`='1',`lig2`='280.00',`lig5`='10',`lig4`='280.00',`lig8`='308.00',`lig10`='pourcentage',`lig11`='100',`lig6`='154.00',`lig90`='<p><br></p>',`ligdatmod`='202505092118',`ligusermod`= NULL WHERE 1=1 AND ( id_vent = '324') AND ( id_type = '168') AND ( id_tlig = '166') AND ( id_lig = '499') LIMIT 1 UID:--211844-- UPDATE `vent_att` SET `id_work`='419',`att4`='CH-LSDO-7',`att3`='',`att2`='Nettoyage toiture',`att90`='9kibagu0qiaa3gh8',`attf100`='20250502',`att5`='2865',`att8`='10',`att91`='<p><br></p>',`att9`='4392.7',`att10`='439.27',`att11`='4831.97',`att13`='chèque ou virement',`att14`='233',`att15`='\n

Rainea Exteco Sables d\'Olonnes

\n
\n

ZI les Plesses, 21 Rue Henri Farman
\n 85180 Les Sab',`att16`=' 18bis rue de la cantine 85680 Guérinière',`att18`='308',`att24`='4523.97',`att25`='18bis rue de la cantine',`att26`='',`att27`='85680',`att28`='Guérinière',`att31`='411.27',`att29`='4112.7',`attdatmod`='202505092118',`attusermod`= NULL ,`attflagmod`='0' WHERE 1=1 AND ( id_vent = '324') AND (id_type = '168') LIMIT 1 UID:--211846-- UPDATE `vent_att` SET `id_work`='417',`att4`='11',`attdatmod`='202505092118',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '112') AND (id_type = '148') LIMIT 1 UID:--211846-- UPDATE `vent_att` SET `id_work`='412',`attf107`='202505092118',`attdatmod`='202505092118',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '233') AND (id_type = '165') LIMIT 1 UID:--211846-- UPDATE `tier_att` SET `id_work`='205',`attdatmod`='202505092118',`attusermod`='1586',`attflagmod`='0' WHERE 1=1 AND ( id_tier = '2865') AND (id_type = '80') LIMIT 1