UID:1609--075213-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','165','410','1','202411270752' )
UID:1609--075213-- UPDATE `vent_att` SET `att1`='169',`attf100`='20241127',`attf101`='1',`att11`='1609',`attf105`='20241127',`att43`='Remise TTC',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075213-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '165') AND (id_vent = '173') LIMIT 1
UID:1609--075214-- UPDATE `vent_att` SET `att1`='169',`attf100`='20241127',`attf101`='1',`att11`='1609',`attf105`='20241127',`att43`='Remise TTC',`att2`='302',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075214-- UPDATE `vent_att` SET `att1`='169',`attf100`='20241127',`attf101`='1',`att11`='1609',`attf105`='20241227',`att43`='Remise TTC',`att2`='302',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075214-- UPDATE `vent_att` SET `att1`='169',`attf100`='20241127',`attf101`='1',`att11`='1609',`attf105`='20241227',`att43`='Remise TTC',`att2`='302',`att13`='9daqb9rluiuh7pg2',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/9daqb9rluiuh7pg2',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075214-- UPDATE `vent_att` SET `att1`='169',`attf100`='20241127',`attf101`='1',`att11`='1609',`attf105`='20241227',`att43`='Remise TTC',`att2`='302',`att13`='9daqb9rluiuh7pg2',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/9daqb9rluiuh7pg2',`att4`='DEV--18',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075214-- UPDATE `vent_att` SET `att1`='169',`attf100`='20241127',`attf101`='1',`att11`='1609',`attf105`='20241227',`att43`='Remise TTC',`att2`='302',`att13`='9daqb9rluiuh7pg2',`att14`='https://rainea.toosmart.app/site/SITE1/DEVIS/9daqb9rluiuh7pg2',`att4`='DEV--18',`att18`='Rainea Rainéa Oust et Vilaine
11 Berthé
56220 PLUHERLIN
oustetvilaine@rainea.fr
www.rainea.fr',`att19`=' 7 rue des bougards 44530 GUENROUET',`att20`=' 7 rue des bougards 44530 GUENROUET',`att22`=' Rainea Rainéa Oust et Vilaine
SAS au captial de 5000€ - SIREN 931567663 - RCS : Vannes\n
TVA : FR 14931567663
IBAN : FR76 1380 7109 6533 7219 1638 260 - BIC : CCBPFRPPNAN',`att31`='7 rue des bougards',`att33`='44530',`att34`='GUENROUET',`att35`='France',`att38`='7 rue des bougards',`att40`='44530',`att41`='GUENROUET',`att42`='France',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075218-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','173','202411270752','202411270752' )
UID:1609--075218-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411270752',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '173') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '328') LIMIT 1
UID:1609--075218-- UPDATE `vent_att` SET `att15`='',`att45`='',`att26`='',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075219-- UPDATE `vent_att` SET `att15`='',`att45`='',`att26`='',`att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075224-- UPDATE `vent_lig` SET `lig10`='2472',`ligdatmod`='202411270752',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '173') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '328') LIMIT 1
UID:1609--075224-- UPDATE `vent_lig` SET `lig10`='2472',`lig6`='598.00',`lig13`='0.00',`lig16`='0',`lig17`='5980',`lig18`='598',`lig19`='0.00',`lig2`='5980.00',`lig5`='10',`lig4`='5980.00',`lig7`='6578.00',`lig9`='',`lig14`='0',`lig15`='6578.00',`lig90`='<p><b>Fourniture d\'un filtre ENVIROSEPTIC drainé 6EH comprenant:</b></p><p><u>(NB: filtre à associer à une fosse toutes eaux 3m3 non fournie)</u></p><p><br></p><p>- livraison du matériel.</p><p>- Les Conduites Advanced Enviroseptic.</p><p>- Regard de répartition.</p><p>- Pack étanchéité.</p><p>- Clarinette, raccords pour la répartition et la ventilation.</p><p><br></p><p>- Mise en service, réglage des égalisateurs.</p><p><br></p><p>- Garantie 20 ans.</p><p><br></p><p>- Filière disposant d\'un agrément Ministériel n° 2012-011-mod03 et conforme à la Norme NF-EN 12566-3+A1 et à l\'arrêté du 7 septembre 2009.</p><p><br></p><p>Le Système Enviroseptic est une technologie passive qui facilite la prolifération de bactéries permettant le traitement des eaux usées.</p><p>Il comporte deux composantes principales indissociables : les rangées de conduites Advanced Enviroseptic et une couche de sable filtrant.</p>',`ligdatmod`='202411270752',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '173') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '328') LIMIT 1
UID:1609--075224-- UPDATE `vent_att` SET `att7`='5980',`att8`='598',`att21`='6578',`att9`='6578',`att27`='0',`att29`='0',`att28`='5980',`att30`='598',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075231-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','173','202411270752','202411270752' )
UID:1609--075231-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411270752',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '173') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '329') LIMIT 1
UID:1609--075231-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075243-- UPDATE `vent_lig` SET `lig10`='2475',`ligdatmod`='202411270752',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '173') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '329') LIMIT 1
UID:1609--075243-- UPDATE `vent_lig` SET `lig10`='2475',`lig6`='385.00',`lig13`='0.00',`lig16`='0',`lig17`='3850',`lig18`='385',`lig19`='0.00',`lig2`='3850.00',`lig5`='10',`lig4`='3850.00',`lig7`='4235.00',`lig9`='',`lig14`='0',`lig15`='4235.00',`lig90`='<p><b><span style="font-size: 14px;">Pose d\'un filtre à sable nouvelle génération enviro))septic® drainé, comprenant :</span></b></p><p><b><span style="font-size: 14px;"><br></span>\r\n</b></p><p>- l\'apport et le repli de matériel\r\n</p><p>- les prises de niveaux au laser et l\'implantation des ouvrages\r\n</p><p>- le terrassement en terrain non rocheux\r\n</p><p>- la pose de tuyaux PVC Ø100 et accessoires PVC (dont Tés de visite)\r\n</p><p>- le raccordement des sorties maison à la fosse toutes eaux\r\n</p><p>- le raccordement à la ventilation secondaire\r\n</p><p>- l\'implantation du dispositif enviro))septic comprenant le regard de répartition avec les égalisateurs, les conduites Advanced Enviro-Septic, le sable filtrant, l\'évent et les piézomètres, le regard de bouclage, le pack d\'étanchéité\r\n</p><p>- le repiquage en sortie du filtre vers l\'exutoire (fossé communal)\r\n</p><p>- le transport et l\'évacuation des déblais\r\n</p><p>- le comblement de l\'ancienne fosse septique\r\n</p><p>- les matériaux de calage (graviers déclassés)\r\n</p><p>- la réception de chantier avec le SPANC contacté par nos soins</p><p><br></p><p>\r\n</p><p>Travaux à prévoir par le client :\r\n</p><p>- l\'installation d\'une ventilation secondaire en toiture jusqu\'au pied du mur de l\'habitation</p><p>\r\n</p>',`ligdatmod`='202411270752',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '173') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '329') LIMIT 1
UID:1609--075244-- UPDATE `vent_att` SET `att7`='9830',`att8`='983',`att21`='10813',`att9`='10813',`att27`='0',`att29`='0',`att28`='9830',`att30`='983',`attdatmod`='202411270752',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075327-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','173','202411270753','202411270753' )
UID:1609--075327-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411270753',`ligusermod`='1609' WHERE 1=1 AND ( id_vent = '173') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '330') LIMIT 1
UID:1609--075327-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411270753',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075701-- UPDATE `vent_att` SET `actif`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1609--075701-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '173') AND (id_type = '165')
UID:1609--075702-- UPDATE `vent_att` SET `attX`='',`actif`='0',`att7`='0',`att8`='0',`att21`='0',`att9`='0',`att27`='0',`att29`='0',`att28`='0',`att30`='0',`attdatmod`='202411270757',`attusermod`='1609',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '173') AND (id_type = '165') LIMIT 1
UID:1607--112351-- INSERT INTO `vent_att` (`id_base`,`id_type`,`id_work`,`actif`,`attdatcre` ) VALUES ('1','148','366','1','202411271123' )
UID:1607--112351-- UPDATE `vent_att` SET `att1`='OPP-',`att2`='262',`attf100`='20241127',`att6`='1607',`attdatmod`='202411271123',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '174') AND (id_type = '148') LIMIT 1
UID:1607--112351-- UPDATE `vent_att` SET `newobj`='1' WHERE 1=1 AND (id_type = '148') AND (id_vent = '174') LIMIT 1
UID:1607--112351-- UPDATE `vent_att` SET `att1`='OPP-Derrou',`att2`='262',`attf100`='20241127',`att6`='1607',`attdatmod`='202411271123',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '174') AND (id_type = '148') LIMIT 1
UID:1607--112351-- UPDATE `vent_att` SET `att1`='OPP-Derrou',`att2`='262',`attf100`='20241127',`att6`='1607',`att5`='',`att10`='particulier',`attdatmod`='202411271123',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '174') AND (id_type = '148') LIMIT 1
UID:1607--112405-- UPDATE `vent_att` SET `actif`='0' WHERE 1=1 AND ( id_vent = '174') AND (id_type = '148') LIMIT 1
UID:1607--112405-- UPDATE `vent_lig` SET `actif`='0' WHERE 1=1 AND (id_vent = '174') AND (id_type = '148')
UID:1607--112521-- INSERT INTO `vent_lig` (`id_base`,`id_type`,`id_tlig`,`actif`,`id_vent`,`ligdatcre`,`ligdatmod` ) VALUES ('1','165','162','1','108','202411271125','202411271125' )
UID:1607--112521-- UPDATE `vent_lig` SET `actif`='1',`lig3`='1',`lig9`='Euro',`ligdatmod`='202411271125',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '108') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '331') LIMIT 1
UID:1607--112522-- UPDATE `vent_att` SET `att27`='0',`att29`='0',`attdatmod`='202411271125',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '108') AND (id_type = '165') LIMIT 1
UID:1607--112538-- UPDATE `vent_lig` SET `lig10`='6975',`ligdatmod`='202411271125',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '108') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '331') LIMIT 1
UID:1607--112539-- UPDATE `vent_lig` SET `lig10`='6975',`lig6`='120.00',`lig13`='0.00',`lig16`='0',`lig17`='1200',`lig18`='120',`lig19`='0.00',`lig2`='1200.00',`lig5`='10',`lig4`='1200.00',`lig7`='1320.00',`lig9`='',`lig14`='0',`lig15`='1320.00',`lig90`='<p><b>Pose d\'un séparateur à graisse comprenant :</b></p><p><br></p><p>- L\'apport et les replis de matériels.</p><p>- L\'implantation de l\'ouvrages.</p><p>- Le terrassement en terrain non rocheux.</p><p>- Le raccordement des sorties au séparateur à graisse.</p><p>- Le raccordement du séparateur vers l\'exutoire</p><p>- Le transport et l\'évacuation des déblais.</p><p>- Les matériaux de calage (graviers déclassés).</p><p><br></p>',`ligdatmod`='202411271125',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '108') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '331') LIMIT 1
UID:1607--112539-- UPDATE `vent_att` SET `att7`='11467',`att8`='1146.7',`att21`='12613.7',`att9`='12613.7',`att27`='0',`att29`='0',`att28`='11467',`att30`='1146.7',`attdatmod`='202411271125',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '108') AND (id_type = '165') LIMIT 1
UID:1607--112559-- UPDATE `vent_lig` SET `lig10`='',`ligdatmod`='202411271125',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '108') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '331') LIMIT 1
UID:1607--112559-- UPDATE `vent_lig` SET `lig10`='',`lig6`='0.00',`lig17`='0',`lig18`='0',`lig2`='0.00',`lig5`='0',`lig4`='0.00',`lig7`='0.00',`lig15`='0.00',`lig90`='',`ligdatmod`='202411271125',`ligusermod`='1607' WHERE 1=1 AND ( id_vent = '108') AND ( id_type = '165') AND ( id_tlig = '162') AND ( id_lig = '331') LIMIT 1
UID:1607--112559-- UPDATE `vent_att` SET `att7`='10267',`att8`='1026.7',`att21`='11293.7',`att9`='11293.7',`att27`='0',`att29`='0',`att28`='10267',`att30`='1026.7',`attdatmod`='202411271125',`attusermod`='1607',`attflagmod`='0' WHERE 1=1 AND ( id_vent = '108') AND (id_type = '165') LIMIT 1