slambert/Thanasoft-H2F
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Thanasoft-H2F/gestion/tests/datasetpgsql.sql
Tiavina 50ca1bb3e8 h2f release (source is from h2f code, add only features needed without changing existing code not related) 
Push only :
- calendar features (create agenda and create devis automatically)
- gestion feature (listener to create devis automatically when creating calendar, export thanato statistic, export client statistic)
2025-01-05 12:49:33 +03:00

940 lines
45 KiB
SQL
Raw Permalink Blame History

INSERT INTO "oc_gestion_client" ("nom","prenom","legal_one","entreprise","telephone","mail","adresse","id_nextcloud")
VALUES
('Giacomo','Preston','322843667874IGR','Ipsum Donec Sollicitudin LLP','1-897-636-5129','eget@yahoo.org','P.O. Box 667, 4464 Ut, Road','nextcloud'),
('Deirdre','Puckett','058034458584QFN','Urna Justo Associates','1-373-358-5748','consectetuer.rhoncus.nullam@google.edu','457-2543 Quis Rd.','nextcloud'),
('Amanda','Espinoza','531157120828FYM','Auctor Odio A Industries','1-944-437-1312','turpis.nulla@google.couk','917-3650 Lorem, St.','nextcloud'),
('Odette','Dawson','466143582715TCR','Donec Foundation','1-365-885-2143','dictum.cursus@yahoo.edu','Ap #698-3925 Sociis St.','nextcloud'),
('Justine','Butler','526822069123MHR','Dolor Vitae Dolor Industries','(424) 534-2571','faucibus.morbi.vehicula@yahoo.ca','Ap #820-507 Lorem Street','nextcloud');
INSERT INTO "oc_gestion_client" ("nom","prenom","legal_one","entreprise","telephone","mail","adresse","id_nextcloud")
VALUES
('Owen','Stout','912464592077ZKP','Ante Industries','1-530-735-0277','mollis.duis.sit@yahoo.edu','514-6230 Sem Avenue','nextcloud'),
('Zachery','Mcfarland','827163659628HRB','Massa Incorporated','1-863-996-4857','quam.vel@aol.org','Ap #872-6344 Litora Road','nextcloud'),
('Linda','Flynn','518483623376JAS','Enim Curabitur Institute','(645) 110-1423','sit.amet.metus@hotmail.edu','Ap #742-9122 Lobortis Street','nextcloud'),
('Warren','Terrell','673851558811NPK','Dis Parturient Associates','(364) 168-2366','id.blandit.at@outlook.org','Ap #998-8076 Etiam St.','nextcloud'),
('Kim','Garza','267174262241SWP','Mus Institute','(494) 484-7126','leo.morbi@outlook.couk','2681 Ultrices St.','nextcloud'),
('Orli','Jarvis','788252588553TDO','Enim Consequat Inc.','(658) 335-8743','mattis.integer@hotmail.net','8215 Massa Ave','nextcloud'),
('Henry','Simpson','353883158548DIP','Arcu Et Foundation','(224) 449-8748','pede.suspendisse@aol.couk','2195 Vitae St.','nextcloud'),
('Moana','Terry','439716935068YPS','Eleifend Nunc Risus LLP','1-958-299-5225','vitae@google.edu','P.O. Box 126, 3952 Ipsum. Av.','nextcloud'),
('Benedict','Waters','135856242832JBJ','Aliquam Iaculis Consulting','1-339-270-0330','non.lorem@protonmail.net','Ap #200-2780 Diam Av.','nextcloud'),
('Camilla','Carroll','175171361712MNT','Arcu Vestibulum Ut PC','(687) 554-3946','ullamcorper.velit@icloud.com','P.O. Box 313, 5902 Felis. Road','nextcloud');
INSERT INTO "oc_gestion_client" ("nom","prenom","legal_one","entreprise","telephone","mail","adresse","id_nextcloud")
VALUES
('Henry','Mccoy','788465240241EJR','Lobortis Augue Ltd','(893) 253-7757','ligula.elit@hotmail.ca','676-6920 Iaculis St.','nextcloud'),
('Alexa','Pennington','548870623359YBM','A Odio Semper Corp.','1-217-589-5248','luctus@hotmail.org','804-8229 Sapien Av.','nextcloud'),
('Naida','Floyd','024429578775OYQ','Sagittis Limited','1-959-367-1733','magna.malesuada.vel@aol.edu','884-481 Ultrices St.','nextcloud'),
('Jescie','Weeks','338670582848OVD','Bibendum Fermentum Metus Limited','(334) 715-0517','rutrum.non@yahoo.net','P.O. Box 677, 3225 Tempor St.','nextcloud'),
('Judith','Mccarthy','929753454775NIY','Ut Quam Ltd','(263) 173-0411','sit.amet@aol.com','Ap #352-5918 Lacus. St.','nextcloud'),
('Barbara','Alston','287875701943MEL','Maecenas Mi Industries','1-252-302-7586','sociis.natoque.penatibus@hotmail.ca','Ap #328-1540 Dignissim St.','nextcloud'),
('Whoopi','Fowler','683884472857DOF','Amet Foundation','(761) 296-1344','imperdiet.erat.nonummy@hotmail.org','4219 Cursus Street','nextcloud'),
('Simon','Lancaster','628132960861DEJ','Per Conubia Institute','1-645-426-3261','dapibus.quam@aol.net','169-896 Vel St.','nextcloud'),
('Alec','Donaldson','138565369159CCY','Pede Nonummy Company','(858) 472-6554','nullam.nisl@hotmail.ca','P.O. Box 162, 9059 Nonummy St.','nextcloud'),
('Giselle','Simmons','973851578138KSR','Molestie In Industries','1-545-252-4772','fringilla.donec@hotmail.couk','Ap #775-6084 Nunc Rd.','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('XGW22BSY1EB','sit amet ultricies sem magna','13.71','nextcloud'),
('UWF46NXU3BN','nec quam. Curabitur vel lectus.','84.63','nextcloud'),
('NDT49RKS7LN','dolor. Donec fringilla. Donec feugiat','16.47','nextcloud'),
('QOY48XMS6CO','sem magna nec quam. Curabitur','08.53','nextcloud'),
('ATH98SIK3YD','Phasellus dolor elit, pellentesque a,','58.81','nextcloud'),
('DJY63OUW5YW','magna nec quam. Curabitur vel','81.92','nextcloud'),
('MBM41QFE5FP','purus. Duis elementum, dui quis','57.37','nextcloud'),
('FEM69UDR4WY','auctor, velit eget laoreet posuere,','38.98','nextcloud'),
('QVL95KIT5YG','sagittis placerat. Cras dictum ultricies','52.09','nextcloud'),
('SRI53CVN7IR','eleifend non, dapibus rutrum, justo.','97.41','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('WSS45IFH1LF','Etiam gravida molestie arcu. Sed','52.01','nextcloud'),
('DYD31XXY4DZ','eu, ultrices sit amet, risus.','39.22','nextcloud'),
('MTC22RXA5BQ','nec, cursus a, enim. Suspendisse','71.24','nextcloud'),
('WSM34NSL7VW','tellus. Aenean egestas hendrerit neque.','66.28','nextcloud'),
('IOP40FUQ4HV','gravida non, sollicitudin a, malesuada','61.65','nextcloud'),
('BDP75JXB1PH','magna. Duis dignissim tempor arcu.','61.72','nextcloud'),
('REX39OZF7EB','dictum eu, eleifend nec, malesuada','56.84','nextcloud'),
('VPU37RSU2TP','ipsum cursus vestibulum. Mauris magna.','18.74','nextcloud'),
('GXJ39YPK1WX','pede nec ante blandit viverra.','57.75','nextcloud'),
('NOC47VCF4FG','metus. Aliquam erat volutpat. Nulla','79.66','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('EHV36EKX5NL','facilisis lorem tristique aliquet. Phasellus','64.16','nextcloud'),
('NGX85DLG6HM','nulla vulputate dui, nec tempus','92.83','nextcloud'),
('EFX25TQL5CE','molestie sodales. Mauris blandit enim','24.96','nextcloud'),
('ELW37CHC4DI','libero lacus, varius et, euismod','75.60','nextcloud'),
('SEY85KXD5SX','turpis egestas. Fusce aliquet magna','37.35','nextcloud'),
('JMB09VJT4ND','a feugiat tellus lorem eu','91.23','nextcloud'),
('UVH55XHD9DO','tincidunt aliquam arcu. Aliquam ultrices','65.24','nextcloud'),
('FUG88RCA8VU','elit, pretium et, rutrum non,','58.16','nextcloud'),
('RNT33WQU9TI','Proin nisl sem, consequat nec,','90.81','nextcloud'),
('MLE42HQX5BR','Quisque fringilla euismod enim. Etiam','48.35','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('SFP61IRL1EO','lobortis quam a felis ullamcorper','44.35','nextcloud'),
('CYG70BBG5XR','faucibus. Morbi vehicula. Pellentesque tincidunt','88.25','nextcloud'),
('GNX09RNJ8NH','ac mi eleifend egestas. Sed','65.15','nextcloud'),
('CGE85KYR1FB','consectetuer adipiscing elit. Curabitur sed','97.96','nextcloud'),
('UWQ47WPN8PS','sapien imperdiet ornare. In faucibus.','51.30','nextcloud'),
('TWC92UNT5EQ','lectus justo eu arcu. Morbi','31.12','nextcloud'),
('BJU94ZVQ8TV','felis, adipiscing fringilla, porttitor vulputate,','30.95','nextcloud'),
('FMO19TKP1PM','diam at pretium aliquet, metus','96.59','nextcloud'),
('MMW92SET7HF','massa lobortis ultrices. Vivamus rhoncus.','26.40','nextcloud'),
('HRI35FSQ3CO','molestie pharetra nibh. Aliquam ornare,','21.04','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('KRX11FFY4QK','semper auctor. Mauris vel turpis.','30.61','nextcloud'),
('UBI75MVC3HB','non quam. Pellentesque habitant morbi','08.52','nextcloud'),
('EJU66BKX1NS','amet, dapibus id, blandit at,','31.28','nextcloud'),
('DTZ76ETN7LE','ultrices sit amet, risus. Donec','35.24','nextcloud'),
('DKL33KGW5BJ','pharetra ut, pharetra sed, hendrerit','61.87','nextcloud'),
('RLN65SQG0EZ','Aliquam rutrum lorem ac risus.','71.86','nextcloud'),
('XSC11SJX6JV','Sed pharetra, felis eget varius','27.01','nextcloud'),
('KQT66XHR2DJ','est. Mauris eu turpis. Nulla','13.51','nextcloud'),
('HVC65JZR4KF','risus. Nulla eget metus eu','15.27','nextcloud'),
('OXF22HXJ8XR','purus mauris a nunc. In','99.08','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('WUO82CDH9ZO','orci lobortis augue scelerisque mollis.','12.51','nextcloud'),
('DLG66BWS8MO','Cras eget nisi dictum augue','45.22','nextcloud'),
('FLB51OUU4RF','dis parturient montes, nascetur ridiculus','34.23','nextcloud'),
('VFM68YTT7OD','Quisque ac libero nec ligula','10.52','nextcloud'),
('ZLH94EZJ9XP','urna et arcu imperdiet ullamcorper.','41.19','nextcloud'),
('BWM89JYQ0FY','vel est tempor bibendum. Donec','82.54','nextcloud'),
('ETZ72QJO9MU','gravida sagittis. Duis gravida. Praesent','72.22','nextcloud'),
('JQQ43UBR7FC','ultricies dignissim lacus. Aliquam rutrum','00.74','nextcloud'),
('XJI86QQG2ON','tellus non magna. Nam ligula','12.35','nextcloud'),
('DOH91FXU8SS','massa lobortis ultrices. Vivamus rhoncus.','11.08','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('JDB47RGY5QM','Integer aliquam adipiscing lacus. Ut','29.73','nextcloud'),
('MLL18IMB4TE','fringilla. Donec feugiat metus sit','93.89','nextcloud'),
('SPL25RUT4ET','enim nec tempus scelerisque, lorem','57.62','nextcloud'),
('AGH83WQQ2RS','dolor. Quisque tincidunt pede ac','37.82','nextcloud'),
('BDH33CNT2ZT','fringilla purus mauris a nunc.','66.37','nextcloud'),
('SID83GDS7PY','dui, nec tempus mauris erat','10.49','nextcloud'),
('SSJ28TPG7VN','arcu imperdiet ullamcorper. Duis at','01.29','nextcloud'),
('HDP43CGX1MI','convallis est, vitae sodales nisi','83.54','nextcloud'),
('OTK82LGD8NL','Nunc commodo auctor velit. Aliquam','92.82','nextcloud'),
('LIK40SHH6KS','lorem, eget mollis lectus pede','49.67','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('LEK02HEW5PX','fermentum convallis ligula. Donec luctus','64.19','nextcloud'),
('XBR04NCA5CM','non, dapibus rutrum, justo. Praesent','11.87','nextcloud'),
('RWG37VOB0RY','montes, nascetur ridiculus mus. Aenean','81.37','nextcloud'),
('UBW64WEN8VN','vitae mauris sit amet lorem','65.18','nextcloud'),
('LCU73UVK5ZK','adipiscing lacus. Ut nec urna','47.09','nextcloud'),
('ZJM37VZV6LR','Phasellus ornare. Fusce mollis. Duis','54.08','nextcloud'),
('YPT38GUN1QU','ante dictum mi, ac mattis','17.13','nextcloud'),
('LYY77NSM8BN','sodales. Mauris blandit enim consequat','43.26','nextcloud'),
('RHP57YSY3JB','id sapien. Cras dolor dolor,','12.48','nextcloud'),
('VQP58LMH2NQ','Sed neque. Sed eget lacus.','89.86','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('DCE69HSM6UF','ornare placerat, orci lacus vestibulum','68.29','nextcloud'),
('VUT91LSI0IW','non quam. Pellentesque habitant morbi','48.73','nextcloud'),
('YYI86RRK3MN','Nulla eu neque pellentesque massa','48.31','nextcloud'),
('VLY72MSO2LN','Morbi vehicula. Pellentesque tincidunt tempus','81.30','nextcloud'),
('IHW72RVM4HJ','risus. Nunc ac sem ut','72.08','nextcloud'),
('ADY61JVU3QD','pede et risus. Quisque libero','16.78','nextcloud'),
('OVP21ECX6HX','Aliquam ultrices iaculis odio. Nam','59.98','nextcloud'),
('WXI62QDT3HI','Aenean massa. Integer vitae nibh.','55.40','nextcloud'),
('PFF57MHR6HK','Donec consectetuer mauris id sapien.','58.68','nextcloud'),
('UTP35CRF7NW','morbi tristique senectus et netus','68.54','nextcloud');
INSERT INTO "oc_gestion_produit" ("reference","description","prix_unitaire","id_nextcloud")
VALUES
('ZJP75KLO4BL','auctor odio a purus. Duis','62.42','nextcloud'),
('CMU06ZGV4GI','enim diam vel arcu. Curabitur','88.73','nextcloud'),
('YLF82TSB7GR','euismod est arcu ac orci.','28.25','nextcloud'),
('MMU35LNQ9BW','venenatis vel, faucibus id, libero.','74.72','nextcloud'),
('WWM41INX5QT','adipiscing. Mauris molestie pharetra nibh.','87.64','nextcloud'),
('UUA87PPC8TQ','convallis erat, eget tincidunt dui','13.34','nextcloud'),
('TWL44JPE3JP','Sed eu nibh vulputate mauris','58.49','nextcloud'),
('NJV12GLF4OG','cubilia Curae Phasellus ornare. Fusce','16.92','nextcloud'),
('AWT62CNG8YL','sed leo. Cras vehicula aliquet','55.71','nextcloud'),
('LIJ93VMT8VS','blandit mattis. Cras eget nisi','32.44','nextcloud');
INSERT INTO "oc_gestion_devis" ("date","num","comment","id_nextcloud","version","mentions","id_client")
VALUES
('2021-03-05','QUOTE-1','Nullam lobortis quam a felis ullamcorper viverra.','nextcloud','0.9','auctor,',13),
('2022-01-25','QUOTE-2','Donec fringilla. Donec feugiat metus sit amet ante.','nextcloud','8.5','enim',25),
('2021-09-02','QUOTE-3','facilisis eget, ipsum. Donec','nextcloud','7.1','urna.',11),
('2021-08-01','QUOTE-4','In ornare sagittis felis. Donec','nextcloud','5.0','vitae',22),
('2022-02-16','QUOTE-5','mattis','nextcloud','8.8','Proin',12),
('2022-05-09','QUOTE-6','In','nextcloud','3.8','a',33),
('2022-06-25','QUOTE-7','aliquet magna a neque. Nullam ut nisi a','nextcloud','2.4','consectetuer',29),
('2021-11-20','QUOTE-8','quis urna.','nextcloud','4.3','rutrum',13),
('2022-12-24','QUOTE-9','tincidunt vehicula risus. Nulla eget metus eu','nextcloud','5.0','blandit',16),
('2021-07-10','QUOTE-10','neque sed dictum eleifend, nunc risus varius','nextcloud','1.1','Cum',15);
INSERT INTO "oc_gestion_devis" ("date","num","comment","id_nextcloud","version","mentions","id_client")
VALUES
('2022-12-01','QUOTE-11','nunc, ullamcorper eu, euismod ac, fermentum vel,','nextcloud','9.5','a,',11),
('2022-09-19','QUOTE-12','mauris eu elit.','nextcloud','1.1','faucibus.',12),
('2021-10-30','QUOTE-13','nisl. Quisque fringilla euismod enim. Etiam gravida molestie','nextcloud','8.3','tellus',11),
('2021-02-08','QUOTE-14','fringilla, porttitor vulputate, posuere vulputate, lacus. Cras interdum. Nunc','nextcloud','1.4','Vivamus',12),
('2021-05-25','QUOTE-15','sem. Nulla interdum. Curabitur dictum.','nextcloud','6.8','massa',11),
('2023-01-15','QUOTE-16','tincidunt, neque vitae semper egestas, urna','nextcloud','1.9','sed',12),
('2022-12-13','QUOTE-17','ipsum dolor sit amet, consectetuer adipiscing elit. Aliquam auctor,','nextcloud','6.0','sit',12),
('2022-08-11','QUOTE-18','augue, eu tempor erat neque non quam.','nextcloud','6.5','morbi',26),
('2022-10-02','QUOTE-19','dictum mi,','nextcloud','5.1','gravida',31),
('2021-09-29','QUOTE-20','sed pede. Cum sociis','nextcloud','7.6','pede',19);
INSERT INTO "oc_gestion_devis" ("date","num","comment","id_nextcloud","version","mentions","id_client")
VALUES
('2022-05-11','QUOTE-21','sem ut cursus luctus, ipsum leo elementum sem, vitae aliquam','nextcloud','9.7','iaculis',19),
('2022-08-02','QUOTE-22','est. Nunc ullamcorper, velit in aliquet lobortis, nisi nibh lacinia','nextcloud','2.3','sit',27),
('2021-05-19','QUOTE-23','est.','nextcloud','7.9','arcu.',25),
('2021-08-30','QUOTE-24','blandit mattis. Cras eget nisi dictum augue malesuada malesuada.','nextcloud','4.9','molestie',14),
('2022-08-25','QUOTE-25','Nullam ut nisi','nextcloud','3.6','Curae',31),
('2022-06-01','QUOTE-26','nec, mollis vitae, posuere at, velit. Cras','nextcloud','8.5','nisi.',25),
('2022-04-23','QUOTE-27','rutrum magna.','nextcloud','7.9','in',31),
('2022-12-17','QUOTE-28','eu, eleifend nec,','nextcloud','4.2','mauris',27),
('2021-05-15','QUOTE-29','mauris sit amet lorem semper auctor. Mauris','nextcloud','2.4','arcu.',24),
('2022-06-02','QUOTE-30','aliquet. Phasellus fermentum convallis ligula. Donec','nextcloud','3.7','commodo',27);
INSERT INTO "oc_gestion_devis" ("date","num","comment","id_nextcloud","version","mentions","id_client")
VALUES
('2022-05-31','QUOTE-31','lacus. Ut nec urna et','nextcloud','3.5','ac',29),
('2022-07-04','QUOTE-32','id, blandit','nextcloud','5.0','erat',19),
('2021-04-29','QUOTE-33','penatibus et','nextcloud','6.2','Aliquam',11),
('2022-11-15','QUOTE-34','faucibus ut, nulla. Cras eu tellus eu augue porttitor','nextcloud','3.6','amet',34),
('2022-09-03','QUOTE-35','Donec luctus aliquet odio. Etiam ligula tortor,','nextcloud','8.4','et',22),
('2022-12-30','QUOTE-36','aliquam eros turpis non','nextcloud','5.6','lorem',23),
('2022-01-11','QUOTE-37','nisi dictum augue malesuada malesuada. Integer id','nextcloud','5.2','tincidunt',20),
('2022-03-08','QUOTE-38','eget, volutpat','nextcloud','3.2','gravida.',27),
('2021-11-18','QUOTE-39','Morbi vehicula. Pellentesque tincidunt tempus risus. Donec egestas. Duis ac','nextcloud','5.9','penatibus',11),
('2021-08-17','QUOTE-40','porttitor scelerisque neque. Nullam nisl. Maecenas malesuada fringilla','nextcloud','1.5','molestie',20);
INSERT INTO "oc_gestion_devis" ("date","num","comment","id_nextcloud","version","mentions","id_client")
VALUES
('2022-02-28','QUOTE-41','vel, convallis in, cursus et, eros.','nextcloud','7.7','vulputate',11),
('2022-12-18','QUOTE-42','facilisis lorem tristique aliquet.','nextcloud','7.6','tincidunt',19),
('2021-12-16','QUOTE-43','Suspendisse non leo. Vivamus nibh dolor, nonummy','nextcloud','8.3','Nunc',22),
('2022-12-22','QUOTE-44','ipsum porta elit, a feugiat tellus lorem eu metus.','nextcloud','2.0','et',21),
('2021-02-16','QUOTE-45','et magnis','nextcloud','5.7','neque',27),
('2021-10-23','QUOTE-46','Integer id magna','nextcloud','9.3','non',25),
('2022-04-08','QUOTE-47','neque. Nullam ut nisi a odio semper','nextcloud','4.6','vitae',33),
('2021-06-27','QUOTE-48','bibendum fermentum metus. Aenean sed pede nec','nextcloud','1.5','dictum',24),
('2022-05-13','QUOTE-49','Ut sagittis lobortis mauris. Suspendisse aliquet molestie tellus.','nextcloud','4.1','eros',12),
('2021-09-13','QUOTE-50','adipiscing lacus. Ut','nextcloud','4.2','ultricies',12);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',53,80,3),
('nextcloud',40,53,2),
('nextcloud',45,20,9),
('nextcloud',36,90,10),
('nextcloud',27,23,10),
('nextcloud',26,41,5),
('nextcloud',57,22,9),
('nextcloud',22,42,3),
('nextcloud',41,43,7),
('nextcloud',28,105,10);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',44,79,7),
('nextcloud',18,25,6),
('nextcloud',28,16,3),
('nextcloud',22,68,8),
('nextcloud',43,49,7),
('nextcloud',29,55,7),
('nextcloud',53,62,5),
('nextcloud',38,48,4),
('nextcloud',56,71,8),
('nextcloud',15,9,1);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',16,57,8),
('nextcloud',22,69,3),
('nextcloud',43,82,8),
('nextcloud',37,62,9),
('nextcloud',42,88,4),
('nextcloud',9,69,7),
('nextcloud',23,47,3),
('nextcloud',52,100,10),
('nextcloud',35,40,9),
('nextcloud',57,79,3);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',47,60,1),
('nextcloud',14,54,3),
('nextcloud',24,64,4),
('nextcloud',27,95,8),
('nextcloud',34,56,3),
('nextcloud',22,84,8),
('nextcloud',58,48,3),
('nextcloud',24,65,3),
('nextcloud',39,19,3),
('nextcloud',10,56,4);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',34,23,9),
('nextcloud',39,44,2),
('nextcloud',9,79,7),
('nextcloud',26,10,1),
('nextcloud',9,93,7),
('nextcloud',27,104,9),
('nextcloud',32,64,4),
('nextcloud',32,29,4),
('nextcloud',47,93,8),
('nextcloud',22,25,6);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',53,11,6),
('nextcloud',45,99,4),
('nextcloud',25,95,9),
('nextcloud',57,40,5),
('nextcloud',42,46,9),
('nextcloud',24,96,5),
('nextcloud',10,12,8),
('nextcloud',51,43,3),
('nextcloud',44,56,8),
('nextcloud',16,34,3);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',22,85,7),
('nextcloud',27,32,5),
('nextcloud',20,44,3),
('nextcloud',19,48,5),
('nextcloud',45,94,5),
('nextcloud',43,79,4),
('nextcloud',39,12,2),
('nextcloud',12,8,4),
('nextcloud',26,14,7),
('nextcloud',25,70,6);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',31,45,7),
('nextcloud',29,24,2),
('nextcloud',17,17,5),
('nextcloud',43,67,6),
('nextcloud',15,102,5),
('nextcloud',39,51,8),
('nextcloud',26,20,2),
('nextcloud',25,39,5),
('nextcloud',19,59,1),
('nextcloud',23,45,5);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',14,37,6),
('nextcloud',11,87,7),
('nextcloud',9,69,4),
('nextcloud',32,24,6),
('nextcloud',45,26,7),
('nextcloud',32,32,1),
('nextcloud',57,56,4),
('nextcloud',54,62,9),
('nextcloud',18,55,1),
('nextcloud',49,92,4);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',14,85,4),
('nextcloud',17,61,4),
('nextcloud',19,51,7),
('nextcloud',29,24,7),
('nextcloud',47,13,3),
('nextcloud',31,93,2),
('nextcloud',16,22,1),
('nextcloud',38,73,4),
('nextcloud',11,60,4),
('nextcloud',12,55,8);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',50,71,2),
('nextcloud',37,37,7),
('nextcloud',44,63,9),
('nextcloud',43,85,1),
('nextcloud',38,28,6),
('nextcloud',15,67,2),
('nextcloud',11,39,7),
('nextcloud',28,8,10),
('nextcloud',31,41,10),
('nextcloud',53,53,3);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',40,37,4),
('nextcloud',57,93,2),
('nextcloud',10,100,5),
('nextcloud',17,26,10),
('nextcloud',45,36,9),
('nextcloud',14,98,3),
('nextcloud',25,71,9),
('nextcloud',34,14,2),
('nextcloud',26,81,4),
('nextcloud',56,45,8);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',10,40,5),
('nextcloud',56,67,10),
('nextcloud',30,42,2),
('nextcloud',35,23,4),
('nextcloud',57,52,10),
('nextcloud',35,27,7),
('nextcloud',57,106,2),
('nextcloud',47,37,4),
('nextcloud',57,86,8),
('nextcloud',46,50,9);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',56,63,4),
('nextcloud',34,40,4),
('nextcloud',13,34,6),
('nextcloud',42,50,7),
('nextcloud',50,102,8),
('nextcloud',18,45,8),
('nextcloud',17,103,5),
('nextcloud',21,31,6),
('nextcloud',11,19,4),
('nextcloud',38,100,6);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',22,97,3),
('nextcloud',30,87,7),
('nextcloud',24,92,3),
('nextcloud',32,73,3),
('nextcloud',38,106,8),
('nextcloud',44,77,8),
('nextcloud',55,79,6),
('nextcloud',49,78,7),
('nextcloud',22,34,4),
('nextcloud',38,72,4);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',24,105,4),
('nextcloud',17,37,4),
('nextcloud',10,92,3),
('nextcloud',46,52,7),
('nextcloud',52,30,1),
('nextcloud',39,53,6),
('nextcloud',22,25,5),
('nextcloud',30,23,4),
('nextcloud',30,36,10),
('nextcloud',34,90,4);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',17,104,4),
('nextcloud',10,91,3),
('nextcloud',42,97,6),
('nextcloud',9,84,3),
('nextcloud',17,79,7),
('nextcloud',32,52,5),
('nextcloud',17,44,9),
('nextcloud',43,23,7),
('nextcloud',26,46,6),
('nextcloud',30,15,4);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',28,85,7),
('nextcloud',11,95,9),
('nextcloud',40,99,3),
('nextcloud',45,74,2),
('nextcloud',24,37,7),
('nextcloud',28,103,6),
('nextcloud',26,98,2),
('nextcloud',47,37,6),
('nextcloud',26,88,2),
('nextcloud',28,75,2);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',30,17,2),
('nextcloud',10,84,9),
('nextcloud',46,105,9),
('nextcloud',56,94,9),
('nextcloud',16,43,8),
('nextcloud',48,99,2),
('nextcloud',54,33,2),
('nextcloud',49,88,10),
('nextcloud',11,58,4),
('nextcloud',37,42,1);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',38,21,8),
('nextcloud',49,23,4),
('nextcloud',49,81,6),
('nextcloud',39,89,6),
('nextcloud',18,58,3),
('nextcloud',10,96,6),
('nextcloud',38,74,9),
('nextcloud',53,14,2),
('nextcloud',53,87,1),
('nextcloud',41,105,7);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',45,34,9),
('nextcloud',39,86,10),
('nextcloud',49,70,5),
('nextcloud',35,75,4),
('nextcloud',20,104,5),
('nextcloud',40,19,8),
('nextcloud',41,78,8),
('nextcloud',27,41,1),
('nextcloud',40,65,1),
('nextcloud',55,24,7);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',21,10,10),
('nextcloud',13,106,4),
('nextcloud',56,51,3),
('nextcloud',18,91,9),
('nextcloud',51,23,2),
('nextcloud',23,64,6),
('nextcloud',39,86,5),
('nextcloud',54,45,6),
('nextcloud',17,80,4),
('nextcloud',26,27,2);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',13,16,8),
('nextcloud',42,91,9),
('nextcloud',52,92,9),
('nextcloud',39,12,4),
('nextcloud',20,43,5),
('nextcloud',11,56,7),
('nextcloud',12,95,6),
('nextcloud',49,26,7),
('nextcloud',48,18,7),
('nextcloud',37,88,6);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',44,51,9),
('nextcloud',41,86,4),
('nextcloud',28,33,2),
('nextcloud',43,17,5),
('nextcloud',28,51,3),
('nextcloud',54,89,7),
('nextcloud',36,98,1),
('nextcloud',30,29,10),
('nextcloud',17,90,8),
('nextcloud',13,47,3);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',48,90,4),
('nextcloud',42,89,1),
('nextcloud',25,10,5),
('nextcloud',13,104,1),
('nextcloud',49,34,4),
('nextcloud',42,70,6),
('nextcloud',10,97,2),
('nextcloud',36,22,10),
('nextcloud',54,107,3),
('nextcloud',14,9,9);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',52,96,1),
('nextcloud',54,76,4),
('nextcloud',16,94,9),
('nextcloud',38,43,8),
('nextcloud',25,81,7),
('nextcloud',35,35,3),
('nextcloud',11,66,2),
('nextcloud',35,91,3),
('nextcloud',49,71,1),
('nextcloud',44,62,2);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',41,38,1),
('nextcloud',27,66,4),
('nextcloud',51,54,2),
('nextcloud',51,30,1),
('nextcloud',27,96,9),
('nextcloud',24,96,9),
('nextcloud',33,40,7),
('nextcloud',53,21,4),
('nextcloud',26,46,7),
('nextcloud',41,58,2);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',42,98,3),
('nextcloud',9,27,9),
('nextcloud',38,85,8),
('nextcloud',50,26,9),
('nextcloud',21,16,5),
('nextcloud',54,100,2),
('nextcloud',23,28,4),
('nextcloud',43,31,4),
('nextcloud',9,19,4),
('nextcloud',48,19,1);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',48,98,3),
('nextcloud',14,69,8),
('nextcloud',55,34,8),
('nextcloud',38,13,7),
('nextcloud',26,86,2),
('nextcloud',43,30,5),
('nextcloud',44,16,1),
('nextcloud',26,81,5),
('nextcloud',49,87,9),
('nextcloud',28,92,4);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',33,55,5),
('nextcloud',22,65,5),
('nextcloud',16,83,4),
('nextcloud',13,25,4),
('nextcloud',29,41,3),
('nextcloud',29,41,3),
('nextcloud',20,63,1),
('nextcloud',19,57,9),
('nextcloud',17,12,2),
('nextcloud',47,40,2);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',26,38,5),
('nextcloud',16,26,7),
('nextcloud',11,55,7),
('nextcloud',53,105,8),
('nextcloud',52,11,8),
('nextcloud',47,34,5),
('nextcloud',30,28,1),
('nextcloud',42,16,9),
('nextcloud',55,85,6),
('nextcloud',35,10,6);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',41,30,9),
('nextcloud',18,47,4),
('nextcloud',23,89,3),
('nextcloud',16,56,6),
('nextcloud',27,51,4),
('nextcloud',50,53,9),
('nextcloud',48,84,8),
('nextcloud',33,95,8),
('nextcloud',13,30,2),
('nextcloud',53,16,6);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',36,52,2),
('nextcloud',28,47,4),
('nextcloud',13,81,7),
('nextcloud',45,102,7),
('nextcloud',39,73,9),
('nextcloud',35,65,5),
('nextcloud',40,82,8),
('nextcloud',22,91,6),
('nextcloud',50,43,3),
('nextcloud',25,102,4);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',40,95,9),
('nextcloud',48,28,9),
('nextcloud',15,60,3),
('nextcloud',16,54,5),
('nextcloud',48,107,5),
('nextcloud',38,96,8),
('nextcloud',28,18,4),
('nextcloud',45,15,7),
('nextcloud',39,81,2),
('nextcloud',28,95,2);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',48,48,1),
('nextcloud',39,50,4),
('nextcloud',11,21,7),
('nextcloud',29,11,6),
('nextcloud',31,103,9),
('nextcloud',12,79,7),
('nextcloud',57,45,8),
('nextcloud',32,85,2),
('nextcloud',50,68,9),
('nextcloud',19,101,2);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',40,77,2),
('nextcloud',49,12,10),
('nextcloud',15,98,5),
('nextcloud',49,76,9),
('nextcloud',38,91,2),
('nextcloud',28,29,3),
('nextcloud',50,24,4),
('nextcloud',35,106,4),
('nextcloud',12,78,5),
('nextcloud',49,60,8);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',52,62,2),
('nextcloud',26,50,6),
('nextcloud',54,62,9),
('nextcloud',23,37,6),
('nextcloud',41,40,7),
('nextcloud',56,22,4),
('nextcloud',56,46,10),
('nextcloud',36,85,4),
('nextcloud',19,13,6),
('nextcloud',42,82,3);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',47,54,10),
('nextcloud',26,12,6),
('nextcloud',34,29,2),
('nextcloud',10,49,7),
('nextcloud',57,102,6),
('nextcloud',29,16,1),
('nextcloud',28,24,5),
('nextcloud',25,40,9),
('nextcloud',15,92,7),
('nextcloud',56,13,8);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',40,57,4),
('nextcloud',28,63,4),
('nextcloud',26,75,8),
('nextcloud',45,101,2),
('nextcloud',29,79,1),
('nextcloud',50,17,5),
('nextcloud',48,89,6),
('nextcloud',44,62,3),
('nextcloud',36,26,9),
('nextcloud',54,84,6);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',21,78,9),
('nextcloud',40,100,3),
('nextcloud',25,38,6),
('nextcloud',27,50,7),
('nextcloud',49,49,6),
('nextcloud',16,52,6),
('nextcloud',45,84,7),
('nextcloud',26,44,10),
('nextcloud',26,22,7),
('nextcloud',31,51,3);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',44,77,2),
('nextcloud',55,64,2),
('nextcloud',45,98,5),
('nextcloud',14,74,3),
('nextcloud',13,32,9),
('nextcloud',40,61,7),
('nextcloud',48,96,4),
('nextcloud',35,35,3),
('nextcloud',13,21,7),
('nextcloud',10,78,8);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',55,69,7),
('nextcloud',16,77,9),
('nextcloud',45,50,8),
('nextcloud',41,93,5),
('nextcloud',43,103,2),
('nextcloud',34,102,3),
('nextcloud',56,85,3),
('nextcloud',44,53,9),
('nextcloud',49,105,4),
('nextcloud',27,29,6);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',38,97,7),
('nextcloud',12,66,9),
('nextcloud',10,103,6),
('nextcloud',43,97,2),
('nextcloud',27,88,2),
('nextcloud',41,77,6),
('nextcloud',36,26,5),
('nextcloud',17,12,9),
('nextcloud',53,97,7),
('nextcloud',12,63,8);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',33,30,4),
('nextcloud',49,65,9),
('nextcloud',21,12,9),
('nextcloud',22,94,9),
('nextcloud',55,34,10),
('nextcloud',17,46,4),
('nextcloud',42,39,2),
('nextcloud',13,56,3),
('nextcloud',22,19,9),
('nextcloud',40,10,4);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',50,84,7),
('nextcloud',33,101,3),
('nextcloud',49,18,2),
('nextcloud',56,57,9),
('nextcloud',56,105,7),
('nextcloud',46,49,5),
('nextcloud',25,44,4),
('nextcloud',19,91,5),
('nextcloud',11,22,8),
('nextcloud',49,101,1);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',15,27,3),
('nextcloud',40,41,2),
('nextcloud',48,64,4),
('nextcloud',41,18,9),
('nextcloud',18,70,9),
('nextcloud',16,43,2),
('nextcloud',51,70,1),
('nextcloud',34,72,8),
('nextcloud',38,86,6),
('nextcloud',51,56,9);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',51,41,7),
('nextcloud',47,87,9),
('nextcloud',47,85,7),
('nextcloud',34,104,3),
('nextcloud',58,95,7),
('nextcloud',23,27,7),
('nextcloud',45,30,6),
('nextcloud',43,76,6),
('nextcloud',42,11,2),
('nextcloud',35,44,6);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',50,98,8),
('nextcloud',17,49,9),
('nextcloud',50,90,7),
('nextcloud',34,97,7),
('nextcloud',32,93,8),
('nextcloud',48,19,7),
('nextcloud',48,78,2),
('nextcloud',17,31,8),
('nextcloud',17,23,5),
('nextcloud',17,60,7);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',37,71,2),
('nextcloud',17,96,5),
('nextcloud',14,93,3),
('nextcloud',29,67,6),
('nextcloud',47,38,5),
('nextcloud',19,11,7),
('nextcloud',56,55,8),
('nextcloud',44,107,6),
('nextcloud',48,37,2),
('nextcloud',31,22,10);
INSERT INTO "oc_gestion_produit_devis" ("id_nextcloud","devis_id","produit_id","quantite")
VALUES
('nextcloud',30,31,6),
('nextcloud',27,14,8),
('nextcloud',47,74,9),
('nextcloud',55,76,3),
('nextcloud',23,91,10),
('nextcloud',42,90,1),
('nextcloud',46,92,4),
('nextcloud',10,21,5),
('nextcloud',43,80,7),
('nextcloud',22,16,1);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-1','October 10th, 2022','2022-01-19','Credit CARD','PAID','5.7',42),
('nextcloud','INVOICE-2','October 9th, 2021','2022-04-05','BITCOIN','CANCELLED','7.4',43),
('nextcloud','INVOICE-3','May 15th, 2022','2022-03-12','BITCOIN','CANCELLED','3.1',13),
('nextcloud','INVOICE-4','February 2nd, 2021','2021-07-07','Credit CARD','OK','7.5',33),
('nextcloud','INVOICE-5','May 24th, 2021','2022-05-16','Credit CARD','WAIT','1.0',36),
('nextcloud','INVOICE-6','July 30th, 2022','2021-03-01','Transfert','CANCELLED','7.5',32),
('nextcloud','INVOICE-7','October 10th, 2021','2021-11-17','Credit CARD','WAIT','1.5',57),
('nextcloud','INVOICE-8','February 23rd, 2022','2021-05-25','BITCOIN','OK','0.9',31),
('nextcloud','INVOICE-9','March 3rd, 2022','2022-03-04','Credit CARD','RECEIVED','4.2',43),
('nextcloud','INVOICE-10','March 15th, 2021','2023-01-09','Transfert','REFUSED','8.3',24);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-11','June 13th, 2022','2022-01-19','BITCOIN','WAIT','2.1',30),
('nextcloud','INVOICE-12','September 24th, 2021','2022-05-20','BITCOIN','CANCELLED','2.0',57),
('nextcloud','INVOICE-13','November 7th, 2021','2022-09-08','Transfert','WAIT','6.5',26),
('nextcloud','INVOICE-14','April 14th, 2022','2021-05-29','Transfert','REFUNDED','1.3',22),
('nextcloud','INVOICE-15','November 23rd, 2022','2021-10-16','Transfert','CANCELLED','8.8',33),
('nextcloud','INVOICE-16','November 27th, 2021','2022-02-16','Credit CARD','RECEIVED','3.1',30),
('nextcloud','INVOICE-17','July 16th, 2021','2022-05-04','Credit CARD','REFUNDED','8.1',21),
('nextcloud','INVOICE-18','November 22nd, 2022','2021-10-05','BITCOIN','RECEIVED','8.8',30),
('nextcloud','INVOICE-19','October 28th, 2021','2022-03-28','Transfert','REFUNDED','3.2',43),
('nextcloud','INVOICE-20','November 21st, 2022','2022-08-29','Transfert','REFUSED','6.6',27);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-21','December 23rd, 2022','2022-03-29','Credit CARD','RECEIVED','8.2',11),
('nextcloud','INVOICE-22','November 26th, 2022','2021-07-02','BITCOIN','CANCELLED','8.5',29),
('nextcloud','INVOICE-23','June 4th, 2022','2021-05-10','Credit CARD','WAIT','6.5',27),
('nextcloud','INVOICE-24','December 17th, 2022','2022-05-17','BITCOIN','REFUNDED','9.0',58),
('nextcloud','INVOICE-25','December 25th, 2022','2021-09-16','BITCOIN','RECEIVED','6.1',42),
('nextcloud','INVOICE-26','March 21st, 2021','2021-12-03','BITCOIN','WAIT','5.8',30),
('nextcloud','INVOICE-27','January 2nd, 2022','2021-05-22','Transfert','RECEIVED','7.8',38),
('nextcloud','INVOICE-28','November 25th, 2022','2022-07-19','Credit CARD','REFUNDED','1.1',57),
('nextcloud','INVOICE-29','December 29th, 2022','2022-10-22','BITCOIN','PAID','5.2',24),
('nextcloud','INVOICE-30','May 1st, 2021','2022-08-28','Transfert','WAIT','6.5',44);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-31','February 24th, 2021','2021-10-01','BITCOIN','PAID','5.7',38),
('nextcloud','INVOICE-32','May 29th, 2022','2022-07-19','Credit CARD','RECEIVED','8.2',23),
('nextcloud','INVOICE-33','August 23rd, 2021','2021-12-10','Credit CARD','REFUNDED','2.4',17),
('nextcloud','INVOICE-34','May 27th, 2021','2022-03-11','BITCOIN','CANCELLED','3.1',47),
('nextcloud','INVOICE-35','July 28th, 2021','2023-01-20','BITCOIN','REFUSED','3.4',19),
('nextcloud','INVOICE-36','February 7th, 2022','2021-11-24','Transfert','REFUSED','1.8',17),
('nextcloud','INVOICE-37','January 14th, 2023','2021-08-30','Transfert','WAIT','2.6',15),
('nextcloud','INVOICE-38','January 22nd, 2023','2021-10-07','Credit CARD','REFUSED','7.5',35),
('nextcloud','INVOICE-39','September 29th, 2021','2022-08-09','Credit CARD','OK','4.5',28),
('nextcloud','INVOICE-40','September 4th, 2021','2022-07-23','Transfert','REFUNDED','6.7',21);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-41','July 25th, 2021','2022-01-23','Transfert','PAID','2.5',32),
('nextcloud','INVOICE-42','May 25th, 2021','2022-02-18','Credit CARD','WAIT','6.2',56),
('nextcloud','INVOICE-43','January 5th, 2022','2022-10-03','Transfert','REFUSED','5.4',31),
('nextcloud','INVOICE-44','April 1st, 2021','2022-12-14','BITCOIN','RECEIVED','3.1',56),
('nextcloud','INVOICE-45','October 9th, 2022','2023-01-25','BITCOIN','CANCELLED','3.0',37),
('nextcloud','INVOICE-46','September 20th, 2022','2021-02-05','Credit CARD','WAIT','1.5',48),
('nextcloud','INVOICE-47','June 7th, 2021','2022-06-15','Transfert','REFUNDED','4.7',52),
('nextcloud','INVOICE-48','November 15th, 2022','2021-08-15','BITCOIN','PAID','4.1',45),
('nextcloud','INVOICE-49','July 9th, 2022','2022-02-08','Transfert','RECEIVED','0.5',49),
('nextcloud','INVOICE-50','June 19th, 2022','2021-06-17','Credit CARD','OK','3.3',43);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-51','June 19th, 2021','2022-08-19','Credit CARD','WAIT','7.2',22),
('nextcloud','INVOICE-52','October 20th, 2022','2022-10-31','Transfert','PAID','1.9',30),
('nextcloud','INVOICE-53','September 13th, 2021','2022-09-25','Credit CARD','PAID','6.4',12),
('nextcloud','INVOICE-54','February 18th, 2021','2021-08-28','Transfert','REFUSED','7.2',52),
('nextcloud','INVOICE-55','January 17th, 2023','2022-10-18','Credit CARD','PAID','7.6',38),
('nextcloud','INVOICE-56','December 9th, 2021','2022-02-28','Credit CARD','REFUNDED','5.2',22),
('nextcloud','INVOICE-57','September 24th, 2021','2022-04-01','Credit CARD','CANCELLED','6.6',17),
('nextcloud','INVOICE-58','April 9th, 2022','2021-03-13','Transfert','PAID','3.3',29),
('nextcloud','INVOICE-59','January 21st, 2022','2022-03-15','Credit CARD','PAID','6.2',32),
('nextcloud','INVOICE-60','June 23rd, 2021','2022-08-19','Transfert','WAIT','8.1',31);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-61','October 18th, 2021','2021-09-18','Transfert','WAIT','2.9',31),
('nextcloud','INVOICE-62','January 11th, 2022','2021-04-09','Transfert','CANCELLED','7.3',11),
('nextcloud','INVOICE-63','December 21st, 2021','2021-12-14','Transfert','RECEIVED','6.5',20),
('nextcloud','INVOICE-64','March 16th, 2021','2021-10-25','Credit CARD','RECEIVED','5.8',11),
('nextcloud','INVOICE-65','September 16th, 2021','2021-12-11','BITCOIN','REFUSED','1.5',15),
('nextcloud','INVOICE-66','February 11th, 2021','2022-02-02','Credit CARD','RECEIVED','3.5',23),
('nextcloud','INVOICE-67','September 13th, 2022','2023-01-09','Transfert','WAIT','0.4',29),
('nextcloud','INVOICE-68','November 24th, 2022','2021-06-29','Credit CARD','REFUNDED','9.0',32),
('nextcloud','INVOICE-69','July 20th, 2022','2022-06-22','BITCOIN','WAIT','7.0',17),
('nextcloud','INVOICE-70','August 29th, 2022','2022-10-28','Credit CARD','RECEIVED','6.3',12);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-71','July 20th, 2021','2021-08-09','Credit CARD','CANCELLED','2.5',14),
('nextcloud','INVOICE-72','October 30th, 2022','2021-05-22','BITCOIN','REFUSED','6.2',53),
('nextcloud','INVOICE-73','December 20th, 2021','2022-11-30','Credit CARD','RECEIVED','8.8',26),
('nextcloud','INVOICE-74','December 7th, 2022','2022-11-09','Credit CARD','REFUNDED','4.4',41),
('nextcloud','INVOICE-75','February 19th, 2021','2021-06-29','Transfert','OK','1.7',19),
('nextcloud','INVOICE-76','October 27th, 2021','2021-08-01','BITCOIN','OK','0.0',43),
('nextcloud','INVOICE-77','November 28th, 2021','2021-05-18','Credit CARD','WAIT','6.5',16),
('nextcloud','INVOICE-78','April 19th, 2022','2022-11-05','Transfert','PAID','6.7',57),
('nextcloud','INVOICE-79','October 21st, 2022','2022-04-06','Transfert','REFUSED','4.8',54),
('nextcloud','INVOICE-80','May 24th, 2022','2022-05-02','Credit CARD','REFUSED','3.7',34);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-81','July 30th, 2021','2022-12-29','BITCOIN','REFUNDED','0.7',27),
('nextcloud','INVOICE-82','December 24th, 2022','2022-07-29','Credit CARD','CANCELLED','1.1',55),
('nextcloud','INVOICE-83','April 2nd, 2022','2022-04-07','Credit CARD','REFUNDED','6.4',17),
('nextcloud','INVOICE-84','June 27th, 2022','2021-05-03','Transfert','RECEIVED','6.6',35),
('nextcloud','INVOICE-85','September 12th, 2022','2021-11-27','Transfert','WAIT','5.3',12),
('nextcloud','INVOICE-86','February 13th, 2021','2022-04-07','Credit CARD','WAIT','6.3',54),
('nextcloud','INVOICE-87','October 18th, 2021','2021-03-20','Transfert','PAID','1.2',17),
('nextcloud','INVOICE-88','March 3rd, 2021','2021-06-15','Transfert','PAID','8.1',43),
('nextcloud','INVOICE-89','August 23rd, 2021','2022-12-23','Credit CARD','RECEIVED','0.4',34),
('nextcloud','INVOICE-90','March 27th, 2022','2021-02-18','Credit CARD','OK','3.2',38);
INSERT INTO "oc_gestion_facture" ("id_nextcloud","num","date","date_paiement","type_paiement","status_paiement","version","id_devis")
VALUES
('nextcloud','INVOICE-91','June 5th, 2021','2021-04-26','Transfert','REFUNDED','4.7',10),
('nextcloud','INVOICE-92','June 30th, 2022','2021-10-12','Transfert','OK','3.3',27),
('nextcloud','INVOICE-93','August 3rd, 2022','2022-07-14','Transfert','RECEIVED','0.2',22),
('nextcloud','INVOICE-94','August 11th, 2022','2022-12-06','BITCOIN','REFUNDED','1.4',16),
('nextcloud','INVOICE-95','September 18th, 2021','2021-12-13','BITCOIN','CANCELLED','4.6',43),
('nextcloud','INVOICE-96','December 10th, 2021','2021-11-29','Transfert','RECEIVED','9.3',55),
('nextcloud','INVOICE-97','June 11th, 2021','2021-03-17','BITCOIN','REFUSED','6.4',53),
('nextcloud','INVOICE-98','July 22nd, 2021','2022-04-27','Transfert','REFUSED','5.7',55),
('nextcloud','INVOICE-99','May 3rd, 2022','2021-09-13','Transfert','CANCELLED','9.6',55),
('nextcloud','INVOICE-100','December 12th, 2022','2021-02-02','Transfert','REFUNDED','2.4',41);
Reference in New Issue View Git Blame Copy Permalink