UID:1608--104901-- INSERT INTO  `vent_lig`  (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','72','202411011049','202411011049' )
UID:1608--104901-- UPDATE  `vent_lig`  SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411011049',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--104912-- UPDATE  `vent_lig`  SET `lig10`='2875',`ligdatmod`='202411011049',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--104912-- UPDATE  `vent_lig`  SET `lig10`='2875',`lig6`='0.00',`lig13`='0.00',`lig16`='0',`lig17`='0',`lig18`='0',`lig19`='0.00',`lig2`='0.00',`lig5`='10',`lig4`='0.00',`lig7`='0.00',`lig9`='',`lig14`='0',`lig15`='0.00',`lig90`='<p><b>Réalisation d\'un épandage <font color="#000000" style="background-color: rgb(255, 255, 0);">(EH à renseigner)</font> :</b></p><p><b><br></b></p><p>- Fourniture d\'une fosse toutes eaux PE dimensionnée conformément à l\'étude de filière.</p><p>- Fournitures des pièces diverses PVC.</p><p>- Mise en place de la fosse toutes eaux avec graviers déclassés.</p><p>- Raccordement des sorties maison à la FTE en tuyau PVC 100.</p><p>- Raccordement de la FTE vers regard de répartition.</p><p>- Création d\'une zone d\'épandage conformément aux recommandations du bureau d\'études.</p><p>- Mise en place de la ventilation secondaire en pied de mur (prévoir la remontée de la ventilation en toiture à la charge du client).</p><p><br></p><p>- Réception de chantier avec le SPANC contacté par nos soins.</p><p><br></p><p>- La prestation comprend le remblaiement de l\'ancien système et l\'évacuation des</p><p>terres excédentaires.</p>',`ligdatmod`='202411011049',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105140-- UPDATE  `vent_lig`  SET `lig10`='',`ligdatmod`='202411011051',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '189')  LIMIT 1 
UID:1608--105140-- UPDATE  `vent_lig`  SET `lig10`='',`lig6`='0.00',`lig13`='0.00',`lig16`='0',`lig17`='0',`lig18`='0',`lig2`='0.00',`lig5`='0',`lig4`='0.00',`lig7`='0.00',`lig9`='',`lig14`='0',`lig15`='0.00',`lig90`='',`ligdatmod`='202411011051',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '189')  LIMIT 1 
UID:1608--105141-- UPDATE  `vent_att`  SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411011051',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105147-- UPDATE  `vent_lig`  SET `actif`='0'  WHERE 1=1  AND (id_vent = '72')  AND (id_type = '165')  AND (id_tlig = '162')  AND (id_lig = '189') 
UID:1608--105147-- UPDATE  `vent_att`  SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411011051',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105508-- UPDATE  `vent_lig`  SET `lig90`='<p><b>Réalisation d\'un épandage <font color=\"#000000\" style=\"background-color: rgb(255, 255, 0);\">(5 EH)</font> :</b></p><p><b><br></b></p><p>- Fourniture d\'une fosse toutes eaux PE dimensionnée conformément à l\'étude de filière.</p><p>- Fournitures des pièces diverses PVC.</p><p>- Mise en place de la fosse toutes eaux avec graviers déclassés.</p><p>- Raccordement des sorties maison à la FTE en tuyau PVC 100.</p><p>- Raccordement de la FTE vers regard de répartition.</p><p>- Création d\'une zone d\'épandage conformément aux recommandations du bureau d\'études.</p><p>- Mise en place de la ventilation secondaire en pied de mur (prévoir la remontée de la ventilation en toiture à la charge du client).</p><p><br></p><p>- Réception de chantier avec le SPANC contacté par nos soins.</p><p><br></p><p>- La prestation comprend le remblaiement et le régalage des terres excédentaires sur site.</p><p>Option: évacuation des terres excédentaires: 600 €HT compris droits de décharge.</p>',`ligdatmod`='202411011055',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105508-- UPDATE  `vent_att`  SET `att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411011055',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105702-- UPDATE  `vent_att`  SET `att91`='&lt;p&gt;Station de relevage prévue mais non indiquée, à installer si besoin.&lt;/p&gt;',`attdatmod`='202411011057',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105702-- UPDATE  `vent_lig`  SET `lig2`='9700.00',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105702-- UPDATE  `vent_lig`  SET `lig2`='9700.00',`lig6`='970.00',`lig17`='9700',`lig18`='970',`lig4`='9700.00',`lig7`='10670.00',`lig15`='10670.00',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105702-- UPDATE  `vent_att`  SET `att91`='&lt;p&gt;Station de relevage prévue mais non indiquée, à installer si besoin.&lt;/p&gt;',`att7`='9700',`att8`='970',`att21`='10670',`att9`='10670',`att27`='0',`att29`='0',`att28`='9700',`att30`='970',`attdatmod`='202411011057',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105704-- UPDATE  `vent_lig`  SET `lig5`='20',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105704-- UPDATE  `vent_lig`  SET `lig5`='20',`lig6`='1940.00',`lig18`='1940',`lig7`='11640.00',`lig15`='11640.00',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105705-- UPDATE  `vent_att`  SET `att8`='1940',`att21`='11640',`att9`='11640',`att27`='0',`att29`='0',`att30`='1940',`attdatmod`='202411011057',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105718-- UPDATE  `vent_lig`  SET `lig9`='euro',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105718-- UPDATE  `vent_lig`  SET `lig9`='euro',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105718-- UPDATE  `vent_att`  SET `att27`='0',`att29`='0',`attdatmod`='202411011057',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105722-- UPDATE  `vent_lig`  SET `lig14`='640',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105722-- UPDATE  `vent_lig`  SET `lig14`='640',`lig13`='512.00',`lig16`='640',`lig17`='9166.67',`lig18`='1833.33',`lig15`='11000.00',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105722-- UPDATE  `vent_att`  SET `att21`='11000',`att27`='640',`att29`='512',`att28`='9166.67',`att30`='1833.33',`attdatmod`='202411011057',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105753-- UPDATE  `vent_lig`  SET `lig2`='9705.00',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105753-- UPDATE  `vent_lig`  SET `lig2`='9705.00',`lig6`='1941.00',`lig17`='9171.67',`lig18`='1834.33',`lig4`='9705.00',`lig7`='11646.00',`lig15`='11006.00',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105753-- UPDATE  `vent_att`  SET `att7`='9705',`att8`='1941',`att21`='11006',`att9`='11646',`att28`='9171.67',`att30`='1834.33',`attdatmod`='202411011057',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105758-- UPDATE  `vent_lig`  SET `lig14`='646',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105758-- UPDATE  `vent_lig`  SET `lig14`='646',`lig13`='516.80',`lig16`='646',`lig17`='9166.67',`lig18`='1833.33',`lig15`='11000.00',`ligdatmod`='202411011057',`ligusermod`='1608'  WHERE 1=1  AND ( id_vent = '72')  AND ( id_type = '165')  AND ( id_tlig = '162')  AND ( id_lig = '218')  LIMIT 1 
UID:1608--105758-- UPDATE  `vent_att`  SET `att21`='11000',`att27`='646',`att29`='516.8',`att28`='9166.67',`att30`='1833.33',`attdatmod`='202411011057',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105901-- UPDATE  `vent_att`  SET `attf105`='20241130',`attdatmod`='202411011059',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--105905-- UPDATE  `vent_att`  SET `attf105`='20241201',`attdatmod`='202411011059',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--110048-- INSERT INTO  `email`  (`date`,`id_user`,`id_base`,`from`,`from_name`,`to`,`to_name`,`cc`,`objet`,`body`,`attachements`,`traite`,`version` ) VALUES ('20241101','1608','1','smarnesud@rainea.fr','Rainea','sylvainmambrun7@gmail.com','sylvainmambrun7@gmail.com','','Nouvelle proposition de RAINEA : Devis N° DEV--1','<meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\">\r\n<title>Nouveau Devis RAINEA</title>\r\n\r\n\r\n\r\n<table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"text-align: center; border-collapse: collapse; background-color: rgb(255, 255, 255); width: 100%; max-width: 1200px; margin: 0px auto;\" width=\"100%\" bgcolor=\"#ffffff\">\r\n    <tbody><tr>\r\n        <td style=\"padding: 0;\">\r\n\r\n            <div style=\"box-sizing: border-box; max-width: 1000px; padding: 0; margin: 0 auto;\">\r\n\r\n                <!-- START CENTERED WHITE CONTAINER -->\r\n                <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; background: #ffffff; border: 1px solid #eaebed; border-radius: 16px; width: 100%;\" width=\"100%\">\r\n\r\n                    <!-- START MAIN CONTENT AREA -->\r\n                    <tbody><tr>\r\n                        <td style=\"font-family: Helvetica, sans-serif; font-size: 16px; vertical-align: top; box-sizing: border-box; padding: 24px;text-align: left\" valign=\"top\">\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                <a href=\"https://rainea.fr/\">\r\n                                    <img src=\"https://rainea.toosmart.app/data/TOOSMART_RAINEA/logo_1.png\" alt=\"Rainea_logo\" width=\"150\" border=\"0\" style=\"border:0; outline:none; text-decoration:none; display:block; margin: 0 auto;\">\r\n                                </a>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 20px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Proposition pour votre installation (Devis N° DEV--1)\r\n                            </p>\r\n\r\n                            <p style=\"line-height: 20px; font-family: Helvetica, sans-serif; font-size: 16px; font-weight: normal; margin: 0 0 16px;\">\r\n                                Bonjour monsieur MAMBRUN,<br><br>\r\n                                Comme convenu, vous trouverez en pièce jointe le devis correspondant à votre projet. Nous avons pris soin de bien détailler chaque élément afin de vous offrir une vue d\'ensemble claire et précise.<br><br>\r\n                                N\'hésitez pas à me contacter si vous avez la moindre question ou besoin de clarification sur certains points.<br><br>\r\n\r\n                                Afin de valider cette proposition nous vous invitons à cliquer sur le bouton \"Afficher votre devis\".<br><br>\r\n                                Nous vous remercions de votre confiance et restons à votre disposition pour toute information complémentaire.<br><br>\r\n                                Dans l\'attente de votre retour, nous vous souhaitons une excellente journée.<br><br>\r\n                                Cordialement, <br>\r\n                            </p>\r\n\r\n                            <p style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; margin: 0 0 16px;text-align: center\">\r\n                                Votre équipe RAINEA - Rainéa Seine & Marne sud\r\n                            </p>\r\n\r\n                            <!-- Button -->\r\n                            <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: 100%; margin: 0 auto;\" width=\"100%\">\r\n                                <tbody><tr>\r\n                                    <td align=\"center\" style=\"padding-bottom: 16px;\">\r\n                                        <table role=\"presentation\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"border-collapse: collapse; width: auto; margin: 0 auto;\">\r\n                                            <tbody><tr>\r\n                                                <td align=\"center\" valign=\"top\" bgcolor=\"#005c7d\" style=\"border-radius: 4px; background-color: #005c7d; padding: 12px 24px;\">\r\n                                                    <a href=\"https://rainea.toosmart.app/site/SITE1/DEVIS/-7fberuuwrb0scpv\" target=\"_blank\" style=\"font-family: Helvetica, sans-serif; font-size: 16px; font-weight: bold; text-decoration: none; color: #ffffff; display: inline-block;\">\r\n                                                        Afficher votre devis\r\n                                                    </a>\r\n                                                </td>\r\n                                            </tr>\r\n                                            </tbody></table>\r\n                                    </td>\r\n                                </tr>\r\n                                </tbody></table>\r\n                            <div style=\"display: flex; flex-direction: column; justify-content: center; align-items: center; text-align: center;\">\r\n                                <img style=\"margin-top: 24px;border-radius: 4px;width: 100%;\" src=\"https://object-storage.toosmart.app/signaturerainea/raineaseineetmarnesud.png\" alt=\"Bannière\">\r\n                            </div>\r\n                        </td>\r\n                    </tr>\r\n                    <!-- END MAIN CONTENT AREA -->\r\n\r\n                    </tbody></table>\r\n                <!-- END CENTERED WHITE CONTAINER -->\r\n\r\n            </div>\r\n        </td>\r\n    </tr>\r\n    </tbody></table>\r\n','/mnt/big/prod/toosmart_rainea/soft/v2017b/../../data/doc/1/14-12-789-1§FT-PTE-1-38993-1.pdf;/mnt/big/prod/toosmart_rainea/data/tmp/Devis_DEV--1.pdf§Devis_DEV--1.pdf','0','v2017b' )
UID:1608--110048-- UPDATE  `email`  SET `type`='',`bcc`=''  WHERE 1=1  AND (id_email = '153')  LIMIT 1 
UID:1608--110048-- UPDATE  `vent_att`  SET `attf104`='20241101',`id_work`='411',`attdatmod`='202411011100',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1 
UID:1608--110048-- UPDATE  `vent_att`  SET `attf104`='20241101',`id_work`='411',`attf106`='20241101',`attdatmod`='202411011100',`attusermod`='1608',`attflagmod`='0'  WHERE 1=1  AND ( id_vent = '72')  AND (id_type = '165')  LIMIT 1