-- Impor data BRAMBO lama. Jalankan SEKALI di database yang jurnalnya masih kosong (phpMyAdmin > Import). -- Prasyarat: schema.sql sudah diimpor dan `php tools/seed.php` sudah dijalankan (akun pic01/pic02 ada). SET NAMES utf8mb4; START TRANSACTION; INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Vara', 'VARA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('OJ', 'KAOS ORANG JOGJA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Nur Cahyo', 'NUR CAHYO', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Ulya', 'ULYA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Daster234', 'DASTER 234', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Sobo Jaya', 'SOBO JAYA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Putri Salsa', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Putri Tanjung', 'PUTRI TANJUNG', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Ulfa Shop', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Jogja Handmade', 'TAS JOGJA HANDMADE', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Suminto', 'TAS SUMINTO', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Pak Hasan', 'PAK HASAN', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Batik Riry', 'BATIK RIRY', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Prima Jaya', 'TAS PRIMA JAYA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Joist', 'JOIST', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Handicraft', 'TAS HANDICRAFT', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Sitinggil', 'BATIK SITINGGIL', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Ibu Solo', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Batik MR', 'BATIK MR', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Batik Lima', 'BATIK LIMA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Pak Damiri', 'PAK DAMIRI', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Pak Ari', 'PAK ARY ENZO BATIK', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Bintang Firdaus', 'BINTANG FIRDAUS', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Alesha', 'ALESHA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Daster SS Paradise', 'DASTER SS PARADISE', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Nadika Batik', 'NADIKA BATIK', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Azra/Daster Melva', 'BATIK AZRA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Udeng Pak Rozak', 'PAK ROZAK', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Batik Kinjeng', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Pak Mustofa / Nadifa', 'PAK MUSTOFA MUKENA NADIFA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Batik Mangkunagari', 'MANGKUNAGARI', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Sinar Rejo Sari', 'SINAR REJO SARI', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Jehan Arum / Pak Adib', 'JEHAN ARUM', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Aneka', 'ANEKA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Indah Craft', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Aksesoris Madura Dream Catcher', 'AKSESORIS MADURA Dream Catcher', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Mbak Siti Klewer', 'MBA SITI KLEWER', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Pak Husen Sarung', 'PAK HUSEN SARUNG GOYOR', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Pamor', 'PAMOR', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Mukena Sogan Pak Saiful', 'MUKENA SOGAN PAK SAIFUL', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Material P Widodo', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Aksesoris Padang', 'AKSESORIS PADANG', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Kaos Oblong Istimewa', 'KAOS OBLONG ISTIMEWA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Batik Fatma', 'BATIK FATMA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Tas Rajut Kulon Progo', 'TAS RAJUT KULON PROGO', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Catering', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Virenda', 'BATIK VIRENDA', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Tas Bandung', 'TAS BELANJA BANDUNG', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Rajut Bandung', 'TAS RAJUT BANDUNG', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Gmp Tas Rajut', 'TAS RAJUT GMP', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Tas Prima', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Ulfa Accessories', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Ulfa Shop Topi', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Tas Kang Basir', 'TAS BELACU PAK BASIR', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('HJ Atik', NULL, 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Tas Belacu Hitam Aisyah', 'TAS HITAM AISYAH PAK ROSYID', 1); INSERT IGNORE INTO suppliers (nama, tab_lama, aktif) VALUES ('Aksesoris Ucok', NULL, 1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('697e1682-12ba-4f0d-aceb-053c43382afe',1,'2026-07-21','2026-07-24 08:00:08.527','Masuk',43200000,'Setoran Toko',NULL,'Setoran Toko',(SELECT id FROM users WHERE nik='pic02'),43200000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e29e068d-f1d6-41d3-9e8e-be87657871bb',1,'2026-07-22','2026-07-24 08:00:43.788','Masuk',45500000,'Setoran Toko',NULL,'Setoran Toko',(SELECT id FROM users WHERE nik='pic02'),88700000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7a4a957b-3aec-49a6-9181-9c025e0b1848',1,'2026-07-23','2026-07-24 08:01:33.737','Masuk',37450000,'Setoran Toko',NULL,'Setoran Toko',(SELECT id FROM users WHERE nik='pic02'),126150000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f0560aa7-c223-42ee-8838-63090d03b89d',1,'2026-07-24','2026-07-25 01:00:56.795','Masuk',63050000,'Setoran Toko',NULL,'Setoran harian toko',(SELECT id FROM users WHERE nik='pic02'),189200000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4d371450-f2d8-4832-a5af-17a188a9eb58',1,'2026-07-25','2026-07-26 00:51:35.210','Masuk',98100000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),287300000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e5f1ac38-b0e6-4c59-838f-af87e0238b94',1,'2026-07-26','2026-07-27 00:53:56.949','Masuk',78650000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),365950000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2a9fd16f-cc8f-469d-8fc2-83d30fff96a5',1,'2026-07-27','2026-07-28 00:21:22.003','Masuk',48200000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),414150000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('21a3f704-ecd7-4dc4-bc69-d01bc4525fb1',1,'2026-07-28','2026-07-29 00:35:01.292','Masuk',46200000,'Setoran Toko',NULL,'',(SELECT id FROM users WHERE nik='pic02'),460350000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b7012749-d10e-491b-be6d-624a595fe191',1,'2026-07-29','2026-07-29 15:06:28.310','Keluar',127265000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'Cash via Bsi',(SELECT id FROM users WHERE nik='pic01'),333085000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2568d980-43d2-454a-9d6c-25d7988a7cb1',1,'2026-07-29','2026-07-29 15:07:20.960','Keluar',69053500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),264031500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('bf7ded69-fe88-4002-865c-9a5266c0c96c',1,'2026-07-29','2026-07-29 15:08:29.216','Keluar',34324000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),229707500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9587930c-8476-417a-af5c-b9d154961897',1,'2026-07-29','2026-07-29 15:09:15.587','Keluar',26460000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),203247500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ded71910-e86d-46db-a1eb-3e12aee5756c',1,'2026-07-29','2026-07-29 15:09:41.618','Keluar',203247500,'Setor ke Bank',NULL,'',(SELECT id FROM users WHERE nik='pic01'),0,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9c3a2243-69e0-4c80-b213-72200500202c',1,'2026-07-29','2026-07-30 00:43:47.432','Masuk',55500000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),55500000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('acb951ee-fc46-474f-9ffe-a7c92674b548',1,'2026-07-30','2026-07-30 14:19:56.616','Keluar',16316000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'',(SELECT id FROM users WHERE nik='pic01'),39184000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('81ffbd14-0b20-49a3-8cc8-9a65c0b34333',1,'2026-07-30','2026-07-31 00:38:06.703','Masuk',58800000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),97984000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('11bca6ed-4821-4a83-92f1-e60f5cee20ca',1,'2026-07-31','2026-08-01 02:36:18.002','Masuk',53600000,'Setoran Toko',NULL,'Setoran toko',(SELECT id FROM users WHERE nik='pic01'),151584000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4ecdf0b0-e53a-4489-8665-58a350bedcaf',1,'2026-08-01','2026-08-01 13:09:09.154','Keluar',13000000,'Gaji',NULL,'Gaji Tukang',(SELECT id FROM users WHERE nik='pic01'),138584000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('76cd8c45-f425-4685-969c-da0443ed7d37',1,'2026-08-01','2026-08-02 00:52:46.702','Masuk',107550000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),246134000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('963f275b-be96-40db-b912-9d3ceaabfb0a',1,'2026-08-02','2026-08-02 11:38:58.895','Keluar',48363000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jogja Handmade'),'Bayar Cash',(SELECT id FROM users WHERE nik='pic01'),197771000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('62baf4f6-75fe-455e-9710-dc1c41db2699',1,'2026-08-02','2026-08-03 00:48:00.278','Masuk',77950000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),275721000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f772cfdf-19b7-468c-8065-4164ab92be44',1,'2026-08-03','2026-08-04 00:39:58.225','Masuk',50600000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),326321000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('86e78f27-c508-4a1b-9c24-5744bd93d7c8',1,'2026-08-04','2026-08-05 01:00:53.733','Masuk',45850000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),372171000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a9f7d303-79b3-4447-b607-46db75c7a698',1,'2026-08-05','2026-08-05 20:19:59.051','Keluar',24679000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'Cash via bsi',(SELECT id FROM users WHERE nik='pic01'),347492000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ae474595-1fee-4e83-8ddc-953143add359',1,'2026-08-05','2026-08-05 20:20:36.945','Keluar',108792500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'Cash via bsi',(SELECT id FROM users WHERE nik='pic01'),238699500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d94b55c0-fb30-439f-ba5a-bd8aebf0e6ad',1,'2026-08-05','2026-08-05 20:21:25.580','Keluar',14472000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),224227500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('999273f0-0541-4509-9a18-46f46bedd1c1',1,'2026-08-05','2026-08-05 20:22:13.636','Keluar',55260000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'Cash via bsi',(SELECT id FROM users WHERE nik='pic01'),168967500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c22e66db-f8e4-431c-83c6-4c6cd6303886',1,'2026-08-05','2026-08-05 20:22:56.863','Keluar',31296500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),137671000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('fb2c0cf5-990b-4e65-ab12-d393655bccf3',1,'2026-08-05','2026-08-06 00:28:11.523','Masuk',57700000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),195371000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('028466ab-d8a0-482c-b9df-104edb53720e',1,'2026-08-06','2026-08-07 00:33:12.678','Masuk',58950000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),254321000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9e77ae96-103b-49eb-b6dd-8fca6c4dd53c',1,'2026-08-07','2026-08-07 09:05:38.636','Keluar',159788000,'Gaji',NULL,'Payrol gaji via bsi',(SELECT id FROM users WHERE nik='pic01'),94533000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('78ff5522-9f76-4337-8727-86a493b4ac12',1,'2026-08-07','2026-08-07 16:31:46.052','Keluar',8320000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Suminto'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),86213000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6f2c112a-e0f5-4691-8d12-6614ef94a8e8',1,'2026-08-07','2026-08-08 00:46:13.265','Masuk',59350000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),145563000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('79f4e284-88ab-4ce7-b146-8a4e53c4ccbc',1,'2026-08-08','2026-08-08 10:04:00.660','Keluar',18720000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Damiri'),'Bayar cash',(SELECT id FROM users WHERE nik='pic01'),126843000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f55515ed-d797-498d-b13a-195f0af9e1f0',1,'2026-08-08','2026-08-08 17:52:54.272','Keluar',23873000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'Material',(SELECT id FROM users WHERE nik='pic01'),102970000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('458a3392-f2f9-4d6b-980e-0023a14658a2',1,'2026-08-08','2026-08-08 17:53:31.990','Keluar',10387500,'Gaji',NULL,'Gaji Tukang',(SELECT id FROM users WHERE nik='pic01'),92582500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a6aff076-9b02-41eb-acb0-027512a7749f',1,'2026-08-08','2026-08-09 01:05:58.055','Masuk',105600000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),198182500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8849d460-a801-4ed2-9556-653db70c1216',1,'2026-08-09','2026-08-10 00:55:25.454','Masuk',86700000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),284882500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('5c888bdd-fd00-423f-b78b-3c49cce3a013',1,'2026-08-10','2026-08-11 00:35:06.005','Masuk',45500000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),330382500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('964e134d-a22e-4a23-8f33-20e4db3b5da2',1,'2026-08-11','2026-08-12 00:38:00.034','Masuk',49850000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),380232500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e0529b9d-c3f2-496f-b887-5a56d122081a',1,'2026-08-12','2026-08-13 01:10:40.552','Masuk',62650000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),442882500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('24e56aea-5b24-4ec6-94f4-81fcf02e7934',1,'2026-08-12','2026-08-12 00:00:00.000','Keluar',31317000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),411565500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3a7d2a53-c58d-42b9-acfc-b7b560740fe6',1,'2026-08-12','2026-08-12 00:00:00.000','Keluar',27150000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),384415500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4832049b-bb5e-4123-a9bd-55af2b1434c2',1,'2026-08-12','2026-08-13 23:19:29.957','Keluar',16519000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),367896500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('44e2377d-d38f-4d33-adaa-07617c2b7aae',1,'2026-08-12','2026-08-13 23:20:10.013','Keluar',106692500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),261204000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('667c431d-3006-468d-89d7-6fde256c6362',1,'2026-08-12','2026-08-13 23:21:23.265','Keluar',52520000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),208684000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('cdaee679-0c28-4ea6-aba6-b9451ddbcefe',1,'2026-08-12','2026-08-13 23:22:59.869','Keluar',33358000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'Cash Via BSI',(SELECT id FROM users WHERE nik='pic01'),175326000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('23c5fdfa-8b9a-4210-9ba1-f7c7a98fc4e6',1,'2026-08-12','2026-08-13 23:30:24.648','Keluar',10460000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Ari'),'Cash Via BSI',(SELECT id FROM users WHERE nik='pic01'),164866000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('273bbf6c-e758-4f56-a30d-3e1c5920d40e',1,'2026-08-12','2026-08-13 23:31:08.758','Keluar',13020000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Hasan'),'Cash Via BSI',(SELECT id FROM users WHERE nik='pic01'),151846000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('82d0c657-b5db-40d7-80e7-1a7fe6fd93ea',1,'2026-08-12','2026-08-13 23:32:03.381','Keluar',8900000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Joist'),'Cash Via BSI',(SELECT id FROM users WHERE nik='pic01'),142946000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('79d76ace-eceb-410b-b9f8-6ac3de4a536b',1,'2026-08-13','2026-08-14 01:16:06.753','Masuk',45950000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),188896000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c1e152e4-9ba9-4209-a3a7-adaf5898b8c7',1,'2026-08-14','2026-08-14 14:45:29.693','Keluar',55347500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulfa Shop'),'Cash di toko suplier',(SELECT id FROM users WHERE nik='pic01'),133548500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f92d06ab-b34d-4355-9a40-27382a052978',1,'2026-08-14','2026-08-15 00:32:56.911','Masuk',57550000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),191098500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('bc17600e-2963-4e5c-93f0-fd996480000d',1,'2026-08-15','2026-08-15 18:18:11.698','Keluar',56866000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'Material',(SELECT id FROM users WHERE nik='pic01'),134232500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c350259b-85fa-48da-ab46-fa8ecfb82698',1,'2026-08-15','2026-08-15 18:18:55.291','Keluar',29835000,'Gaji',NULL,'',(SELECT id FROM users WHERE nik='pic01'),104397500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7605722c-72e7-49f5-ac95-ca4d56d3faa8',1,'2026-08-15','2026-08-16 00:47:38.047','Masuk',114400000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),218797500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a81b99a1-5651-4754-8810-65a427dd6ca7',1,'2026-08-16','2026-08-17 00:52:18.015','Masuk',191600000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),410397500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6235ccf4-7aff-479d-beaa-ac105757f574',1,'2026-08-17','2026-08-18 00:16:36.624','Masuk',96750000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),507147500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4a43aa72-f7b3-4fbb-ac7d-48fc6b31c77b',1,'2026-08-18','2026-08-18 21:43:09.056','Keluar',64612500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),442535000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('77d95821-194f-4783-b095-517541873d8e',1,'2026-08-18','2026-08-18 21:56:55.499','Keluar',8160000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Hasan'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),434375000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e4aa4b24-23b9-4bd3-8e58-0d8674475869',1,'2026-08-18','2026-08-18 21:58:44.040','Keluar',22370000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'Cash via BSI',(SELECT id FROM users WHERE nik='pic01'),412005000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d86aae1f-f0b8-4dc3-9fb9-f3a29f820b64',1,'2026-08-18','2026-08-18 22:12:16.469','Keluar',36587000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'Cash Via BSI',(SELECT id FROM users WHERE nik='pic01'),375418000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('936898c9-3959-4b68-9687-dd6c6e822fac',1,'2026-08-18','2026-08-18 22:13:08.542','Keluar',57820000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'Cash Via BSI',(SELECT id FROM users WHERE nik='pic01'),317598000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6b0f28bf-da70-4cd4-afb5-519648de3af1',1,'2026-08-18','2026-08-18 22:14:07.121','Keluar',39374000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'Cash Via BSI',(SELECT id FROM users WHERE nik='pic01'),278224000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7138f79c-8a56-4512-8918-8e9a2847f083',1,'2026-08-18','2026-08-18 22:14:42.282','Keluar',278224000,'Setor ke Bank',NULL,'Setoran ke Rek Bapak',(SELECT id FROM users WHERE nik='pic01'),0,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('227cde8d-edfc-4ff6-9c74-d21fa29b1045',1,'2026-08-18','2026-08-19 00:35:44.840','Masuk',55350000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),55350000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7f20a47c-5cc2-40db-8250-7ed5802faf32',1,'2026-08-19','2026-08-19 22:34:46.404','Keluar',53370000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jogja Handmade'),'Cash di toko',(SELECT id FROM users WHERE nik='pic01'),1980000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('762d576b-2314-45f0-a8a4-ee94616cebb9',1,'2026-08-19','2026-08-20 00:19:08.977','Masuk',45400000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),47380000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8e07d33a-e375-4218-b9c7-d008f4282088',1,'2026-08-20','2026-08-21 00:13:21.124','Masuk',48100000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),95480000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('61368c4d-5d47-4a1c-b390-f9b0648be865',1,'2026-08-21','2026-08-22 00:43:42.045','Masuk',55300000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),150780000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a8338b29-3c65-4955-804b-81fe43540587',1,'2026-08-22','2026-08-23 09:34:22.727','Keluar',22327000,'Gaji',NULL,'Gaji Tukang',(SELECT id FROM users WHERE nik='pic01'),128453000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7ea4b31e-6212-4590-a0b8-69ac518d2f54',1,'2026-08-22','2026-08-23 09:35:15.167','Keluar',24059000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'cash di toko pa widodo',(SELECT id FROM users WHERE nik='pic01'),104394000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('df4e5ad5-71fd-47b9-8ab7-f36e87e8280c',1,'2026-08-22','2026-08-23 09:35:57.933','Masuk',118050000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),222444000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('53aa1526-e125-45d0-82e6-1c79c1f7e7bb',1,'2026-08-23','2026-08-24 00:43:53.003','Masuk',133600000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),356044000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('19958a17-823c-46e5-8e28-50e9716a074e',1,'2026-08-24','2026-08-25 00:50:25.791','Masuk',96050000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),452094000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('900de980-5cb0-4244-8c59-d29b7c498b1a',1,'2026-08-25','2026-08-26 00:41:58.175','Masuk',84800000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),536894000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('af3965f0-6dd7-41f2-aaa5-bf908fb0245a',1,'2026-08-26','2026-08-28 01:05:44.207','Keluar',41620000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Damiri'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),495274000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('47e1b28d-219a-47bf-a98c-86e1ba544796',1,'2026-08-26','2026-08-28 01:06:17.263','Keluar',42295000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),452979000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8622b54c-d98d-4a90-8cb8-e024d879e467',1,'2026-08-26','2026-08-28 01:06:55.637','Keluar',137929500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),315049500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e9578894-fdb7-4526-81de-9fd4fd630ded',1,'2026-08-26','2026-08-28 01:07:57.179','Keluar',14913500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Hasan'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),300136000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('145c8c51-8742-495f-8763-17e6db7d657f',1,'2026-08-26','2026-08-28 01:09:11.746','Keluar',30156000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),269980000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7cd4a222-35bd-4121-bda3-1b7d30d59fb9',1,'2026-08-26','2026-08-28 01:11:58.307','Keluar',58380000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),211600000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('509d2f6f-0a8c-431c-ae4e-6e3c12b65036',1,'2026-08-26','2026-08-28 01:13:03.795','Keluar',39653000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),171947000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('75e28a01-8272-4a85-a458-dda633440cfc',1,'2026-08-26','2026-08-28 01:14:37.534','Keluar',8580000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ibu Solo'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),163367000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2d415213-84cc-4b71-85e3-2c0de8986bb8',1,'2026-08-26','2026-08-28 01:15:24.422','Keluar',12670000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Joist'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),150697000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('71b8c649-599b-4fa2-9d13-308dc37330e8',1,'2026-08-26','2026-08-28 01:18:29.205','Keluar',16500000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Alesha'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),134197000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('84544388-51ab-46ef-8630-ca012376edf9',1,'2026-08-26','2026-08-28 01:19:10.961','Keluar',15280000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Bintang Firdaus'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),118917000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('36b2eb1b-2f91-40e6-97e2-ce8c5074e219',1,'2026-08-27','2026-08-28 01:22:05.290','Keluar',1170000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nadika Batik'),'cash toko via febri',(SELECT id FROM users WHERE nik='pic01'),117747000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('915da560-4417-47a5-abde-eebb0665aef3',1,'2026-08-27','2026-08-28 01:23:03.547','Keluar',13078000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jogja Handmade'),'cash toko',(SELECT id FROM users WHERE nik='pic01'),104669000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2ce3013e-dccd-4f03-b020-1cfb90d39197',1,'2026-08-27','2026-08-28 01:26:10.678','Keluar',5290000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Udeng Pak Rozak'),'bsi',(SELECT id FROM users WHERE nik='pic01'),99379000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a01405a9-bdfb-4843-99da-4d9f0d395d53',1,'2026-08-27','2026-08-28 01:26:56.169','Keluar',4800000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sinar Rejo Sari'),'stor bsi',(SELECT id FROM users WHERE nik='pic01'),94579000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a3d85925-e2cf-47a0-ad07-2d4de64e7f93',1,'2026-08-27','2026-08-28 01:27:57.659','Keluar',12600000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Daster SS Paradise'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),81979000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('835d0ad0-e687-41ab-b63d-fb5b558beb49',1,'2026-08-27','2026-08-28 01:28:48.712','Keluar',10880000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Azra/Daster Melva'),'cash di toko',(SELECT id FROM users WHERE nik='pic01'),71099000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('aab57878-7a2c-4f8c-888d-f3f3104a1a35',1,'2026-08-27','2026-08-28 01:29:33.131','Keluar',59229000,'Setor ke Bank',NULL,'setor bsi',(SELECT id FROM users WHERE nik='pic01'),11870000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('47200dc1-caf2-4537-82f5-df5fadd2131c',1,'2026-08-26','2026-08-28 18:16:11.201','Masuk',52850000,'Setoran Toko',NULL,'setoran toko',(SELECT id FROM users WHERE nik='pic01'),64720000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b979f1a1-d344-4de8-aac8-f1bfcb2d600a',1,'2026-08-27','2026-08-28 18:16:59.273','Masuk',59850000,'Setoran Toko',NULL,'setoran cash',(SELECT id FROM users WHERE nik='pic01'),124570000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('cc04402d-da9b-42be-b759-77a7dbd34be4',1,'2026-08-28','2026-08-29 12:54:52.750','Masuk',59800000,'Setoran Toko',NULL,'Setoran toko',(SELECT id FROM users WHERE nik='pic01'),184370000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c557f4f8-246b-4dfa-a87e-407da594c193',1,'2026-08-29','2026-09-01 09:46:19.739','Keluar',50643000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'Cash di toko',(SELECT id FROM users WHERE nik='pic01'),133727000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('57904d03-c0ad-4ae6-93ed-a175a192ff17',1,'2026-08-29','2026-09-01 09:46:56.891','Keluar',26770000,'Gaji',NULL,'Gaji tukang',(SELECT id FROM users WHERE nik='pic01'),106957000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8771b435-8b55-4087-9e04-211f89863abb',1,'2026-08-29','2026-09-01 09:47:40.258','Masuk',103950000,'Setoran Toko',NULL,'Setoran toko',(SELECT id FROM users WHERE nik='pic01'),210907000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('32d1b65a-24cd-4adc-937c-e13ca3265441',1,'2026-08-30','2026-09-01 09:48:15.756','Masuk',95450000,'Setoran Toko',NULL,'Setoran toko',(SELECT id FROM users WHERE nik='pic01'),306357000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c71937a3-c640-4d22-8721-5bc9203b025e',1,'2026-08-31','2026-09-01 09:48:53.864','Masuk',41300000,'Setoran Toko',NULL,'Setoran toko',(SELECT id FROM users WHERE nik='pic01'),347657000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9d9c5de3-d587-402d-a873-7d3d017b0850',1,'2026-09-01','2026-09-01 19:22:06.883','Masuk',40000000,'Setoran Toko',NULL,'Bapak TF',(SELECT id FROM users WHERE nik='pic01'),387657000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('86b6efa3-8c36-442b-b9b7-b8a8762491cf',1,'2026-09-01','2026-09-01 19:23:31.391','Keluar',16935000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jogja Handmade'),'Cash di toko',(SELECT id FROM users WHERE nik='pic01'),370722000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('0637aa6e-1ea9-4ec5-a293-4abdc23fbaa3',1,'2026-09-01','2026-09-01 19:24:09.291','Keluar',76020000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'Setor BSI',(SELECT id FROM users WHERE nik='pic01'),294702000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('90c26fb0-476c-4088-b511-0b0580a912e0',1,'2026-09-01','2026-09-01 19:27:29.478','Keluar',3690000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Kinjeng'),'Setor BSI',(SELECT id FROM users WHERE nik='pic01'),291012000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2dd7da72-6aa5-4717-9ea9-4aa48be22994',1,'2026-09-01','2026-09-01 19:28:36.570','Keluar',12900000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Mangkunagari'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),278112000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('78e2833e-aff7-4eb0-aaef-709d25fb7094',1,'2026-09-01','2026-09-01 19:29:11.474','Keluar',11530000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Joist'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),266582000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f87c44d5-4972-474a-9718-ae143a1d0cb6',1,'2026-09-01','2026-09-01 19:29:45.394','Keluar',29660000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),236922000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('76ab889a-4e10-475d-8d60-bb6c44923f47',1,'2026-09-01','2026-09-01 19:30:23.678','Keluar',29494000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'Setor BSI',(SELECT id FROM users WHERE nik='pic01'),207428000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b9f76ce7-9656-40f1-9a83-c88079301513',1,'2026-09-01','2026-09-01 19:31:11.599','Keluar',41045000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),166383000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d542d8eb-1ef6-4953-988b-6d68b1c4b9a8',1,'2026-09-01','2026-09-01 19:32:03.655','Keluar',8970000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Suminto'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),157413000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('53bc1f17-e496-4a45-b79a-4062cdeeb211',1,'2026-09-01','2026-09-01 19:32:57.903','Keluar',11655000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Mustofa / Nadifa'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),145758000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a33bc80f-a741-47f7-ad4f-3291229436eb',1,'2026-09-01','2026-09-01 19:33:44.330','Keluar',50915000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),94843000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b4c38c5f-359d-480e-858d-bd609907d568',1,'2026-09-01','2026-09-01 19:34:21.694','Keluar',3590000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ibu Solo'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),91253000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c261ad4f-f4f4-4c85-b008-1c511cc78a16',1,'2026-09-01','2026-09-01 19:35:08.511','Keluar',38512000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),52741000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a3680be5-837a-4441-958d-220f539a0459',1,'2026-09-01','2026-09-01 19:35:36.428','Keluar',9932000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Hasan'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),42809000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('03ab8107-535d-4d57-9587-c7fccd1196db',1,'2026-09-01','2026-09-01 19:46:00.565','Keluar',3760000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jehan Arum / Pak Adib'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),39049000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6cc3ddf7-db98-4b83-ae88-538652cb2adc',1,'2026-09-01','2026-09-01 19:47:48.936','Keluar',12139500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Lima'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),26909500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2c53edc9-09c1-415a-9e03-f506c331c779',1,'2026-09-01','2026-09-02 00:21:35.834','Masuk',43550000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),70459500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f0d392c3-55f9-49da-8d55-86862117b4cc',1,'2026-09-02','2026-09-03 00:27:11.961','Masuk',50850000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),121309500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('59803f91-eea6-48d3-b89a-8d5b0cc967b1',1,'2026-09-03','2026-09-04 00:34:53.261','Masuk',49550000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),170859500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e916393a-e7c8-4bd6-8c27-b33cdc00af7a',1,'2026-09-04','2026-09-05 00:31:10.955','Masuk',61100000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),231959500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f3377e54-4f40-47ef-9669-ed6ef7dd46ff',1,'2026-09-02','2026-09-05 07:48:59.303','Keluar',13881000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aneka'),'Cash di toko',(SELECT id FROM users WHERE nik='pic01'),218078500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('da38a2a9-c4ff-4e8b-bbac-85e0b743011f',1,'2026-09-02','2026-09-05 07:52:04.654','Keluar',13010000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Indah Craft'),'Cash di toko',(SELECT id FROM users WHERE nik='pic01'),205068500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7e1ba5e1-1158-4385-9197-1d9b32d981a6',1,'2026-09-05','2026-09-05 13:40:27.204','Keluar',28060000,'Gaji',NULL,'Gaji tukang',(SELECT id FROM users WHERE nik='pic01'),177008500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9a04fc28-eb9e-41b4-a3ae-6a0d30c4164a',1,'2026-09-05','2026-09-05 13:41:05.771','Keluar',12845000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'Cash di toko',(SELECT id FROM users WHERE nik='pic01'),164163500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('fcb29b2c-0059-4ebf-b2e2-0d0866ffb120',1,'2026-09-05','2026-09-06 00:32:25.531','Masuk',107850000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),272013500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e7dd47f6-fd13-4e6a-8127-b65000bc7973',1,'2026-09-06','2026-09-07 00:27:59.763','Masuk',89150000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),361163500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('47eccc29-8e3c-4c88-831d-46a13193c452',1,'2026-09-07','2026-09-07 14:39:11.834','Keluar',202745000,'Gaji',NULL,'Payrol ambo',(SELECT id FROM users WHERE nik='pic01'),158418500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('5cacbd42-59cc-4aed-8a79-6518c8f20ff3',1,'2026-09-07','2026-09-08 00:25:37.673','Masuk',39850000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),198268500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2f69b753-eaa0-43ca-b6a1-32d707226b37',1,'2026-09-08','2026-09-08 22:49:29.155','Masuk',229006500,'Setoran Toko',NULL,'bapak TF',(SELECT id FROM users WHERE nik='pic01'),427275000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e7ef863f-ca99-4b5e-a4ab-5307885c844e',1,'2026-09-08','2026-09-08 22:50:43.994','Keluar',88582500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'Setor BSI',(SELECT id FROM users WHERE nik='pic01'),338692500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('5750fdb5-d393-45ee-b7eb-7f5607effaaa',1,'2026-09-08','2026-09-08 22:54:29.344','Keluar',8300000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aksesoris Madura Dream Catcher'),'cash di toko',(SELECT id FROM users WHERE nik='pic01'),330392500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('1682a6c5-e6d1-4115-976a-a864a6da9f88',1,'2026-09-08','2026-09-08 22:55:40.773','Keluar',25800000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sitinggil'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),304592500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('42c1ce8a-3ca8-41d9-9eb3-ed2d9e88bb9a',1,'2026-09-08','2026-09-08 22:56:33.972','Keluar',8220000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Handicraft'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),296372500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('82be76bf-8888-499d-88ff-b5da9320a428',1,'2026-09-08','2026-09-08 22:57:12.873','Keluar',1935000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jehan Arum / Pak Adib'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),294437500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('41920cca-1e0e-4b9f-8bea-99b06e61bafd',1,'2026-09-08','2026-09-08 22:57:58.879','Keluar',7150000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Mustofa / Nadifa'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),287287500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c049b28b-a695-40dc-895d-db72f574f59b',1,'2026-09-08','2026-09-08 22:58:42.712','Keluar',6300000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Ari'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),280987500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e156e6b7-afe3-4807-ab34-4f994cb11740',1,'2026-09-08','2026-09-08 22:59:16.138','Keluar',20640000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jogja Handmade'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),260347500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3e1bef60-b03e-4ed7-859e-bb6339527eb4',1,'2026-09-08','2026-09-08 23:00:08.415','Keluar',12392500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Hasan'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),247955000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('de7e69ce-7551-4cfb-910f-4b3c46fab00a',1,'2026-09-08','2026-09-08 23:00:48.055','Keluar',21630000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Damiri'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),226325000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('5389bff3-26a8-4fd2-9051-928642c8fcb4',1,'2026-09-08','2026-09-08 23:01:15.261','Keluar',50260000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),176065000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7048061b-2458-44e9-ac98-7d8f6b300d6e',1,'2026-09-08','2026-09-08 23:01:59.926','Keluar',25604000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),150461000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('dd8d037f-1aa5-4959-b571-2f3cd806b0bc',1,'2026-09-08','2026-09-08 23:03:02.084','Keluar',10340000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Joist'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),140121000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7936f755-5e22-4299-be36-cd994fe7103a',1,'2026-09-08','2026-09-08 23:06:16.362','Keluar',43915000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Mbak Siti Klewer'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),96206000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('21da59f3-8d23-4f07-9d0f-93a1a155f362',1,'2026-09-08','2026-09-08 23:06:54.760','Keluar',2390000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nadika Batik'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),93816000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('07d8550f-d30c-433e-bc6f-5a97fe765880',1,'2026-09-08','2026-09-08 23:08:24.269','Keluar',5210000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Suminto'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),88606000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ba1d6244-8aab-4699-9d72-540ff5f8329b',1,'2026-09-08','2026-09-08 23:09:41.216','Keluar',24727000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),63879000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6a7fbf12-48a1-4e25-88f4-86fb0acd8fa0',1,'2026-09-08','2026-09-08 23:10:13.493','Keluar',11802000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),52077000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('360ad6a0-2782-409b-8a5a-dc59cbf37d2a',1,'2026-09-08','2026-09-08 23:10:59.081','Keluar',5420000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ibu Solo'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),46657000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('673fd9ec-ed78-4548-b3ee-cfa326399557',1,'2026-09-08','2026-09-08 23:12:32.507','Keluar',4450000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Husen Sarung'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),42207000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8a758559-ed48-41cc-91c2-817e9125afce',1,'2026-09-08','2026-09-08 23:13:10.757','Keluar',17845000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),24362000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('88ae52d6-9c72-426f-b975-ce649f006f83',1,'2026-09-08','2026-09-08 23:14:04.639','Keluar',8600000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Riry'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),15762000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c4d94866-6182-4ed8-a2fa-578eac4173a6',1,'2026-09-08','2026-09-08 23:14:42.314','Keluar',1350000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Azra/Daster Melva'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),14412000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('416ade02-7715-4af7-95e9-32bb30686b2f',1,'2026-09-08','2026-09-08 23:18:08.882','Keluar',14412000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aneka'),'cash di toko',(SELECT id FROM users WHERE nik='pic01'),0,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8f0e0b8a-f536-4edd-bb69-406400f2851b',1,'2026-09-08','2026-09-09 00:27:31.512','Masuk',44700000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),44700000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('bc443c3d-3846-4184-a585-ad5d52088150',1,'2026-09-09','2026-09-10 00:31:46.056','Masuk',45650000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),90350000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('fad10726-eb06-49c6-9fb9-f18c9c757a97',1,'2026-09-10','2026-09-11 00:29:12.607','Masuk',45800000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),136150000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2e7f4b33-a023-4482-b571-a4a37d63115d',1,'2026-09-11','2026-09-12 01:26:36.386','Masuk',55550000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),191700000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('fe13d379-8941-4dc3-891d-881228a29a6f',1,'2026-09-12','2026-09-12 21:20:08.021','Keluar',26260000,'Gaji',NULL,'Gaji tukang',(SELECT id FROM users WHERE nik='pic01'),165440000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8e588bcf-eda2-401e-bc33-bba765fb83bd',1,'2026-09-12','2026-09-12 21:21:11.606','Keluar',30237000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'Material',(SELECT id FROM users WHERE nik='pic01'),135203000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('127b2288-a4b4-494b-be8a-66086df91e2f',1,'2026-09-12','2026-09-13 00:54:30.424','Masuk',86500000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),221703000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('73a4a13f-5cc8-45d7-b671-f1293f0e23df',1,'2026-09-13','2026-09-14 00:29:00.090','Masuk',81900000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),303603000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3383b3fe-8ef9-4f8a-903e-905148c51768',1,'2026-09-14','2026-09-14 09:24:13.510','Keluar',122340000,'Setor ke Bank',NULL,'Setor BCA',(SELECT id FROM users WHERE nik='pic01'),181263000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6c281c70-df10-48a6-8b68-5f0e2da2b8a3',1,'2026-09-14','2026-09-15 00:51:04.867','Masuk',38550000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),219813000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c411da86-f1c4-49a0-941e-f3d362d339a3',1,'2026-09-15','2026-09-15 19:57:38.694','Masuk',122340000,'Setoran Toko',NULL,'bapak tf',(SELECT id FROM users WHERE nik='pic01'),342153000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e7526288-ed74-4d9b-8f58-bb04b7021a66',1,'2026-09-15','2026-09-15 19:58:49.505','Keluar',9615000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aneka'),'bayar di toko',(SELECT id FROM users WHERE nik='pic01'),332538000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('0b3dc2e7-80fa-4944-8bce-5288ad0f8a59',1,'2026-09-15','2026-09-15 19:59:50.050','Keluar',2580000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Riry'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),329958000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f9d3ec54-7285-480d-a27c-f02222ee57b0',1,'2026-09-15','2026-09-15 20:00:23.346','Keluar',5100000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jehan Arum / Pak Adib'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),324858000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('97524e55-3ee0-4a29-aef1-71dc640b23b5',1,'2026-09-15','2026-09-15 20:01:16.645','Keluar',6980000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Joist'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),317878000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('250a016c-0caf-470e-b658-b6969c86829a',1,'2026-09-15','2026-09-15 20:02:24.741','Keluar',10225000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ibu Solo'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),307653000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3173c3c2-d08c-4275-b281-2d28cbff13f2',1,'2026-09-15','2026-09-15 20:03:08.670','Keluar',12900000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Mangkunagari'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),294753000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e16085e8-eb86-43ac-a843-10e44fb17a11',1,'2026-09-15','2026-09-15 20:04:00.939','Keluar',29130000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),265623000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('83beb14b-e3d0-4ebd-bd89-7520785bee20',1,'2026-09-15','2026-09-15 20:04:47.806','Keluar',25740000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Damiri'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),239883000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('25f38bf1-4458-4ff7-a0b5-6531a9ca9b5a',1,'2026-09-15','2026-09-15 20:05:28.032','Keluar',2195000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Mustofa / Nadifa'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),237688000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('505093a9-c2a4-4a46-b8f1-718d867b2814',1,'2026-09-15','2026-09-15 20:06:16.360','Keluar',6210000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Udeng Pak Rozak'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),231478000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e8f200b5-55b8-4c72-ad4c-305cd7885a34',1,'2026-09-15','2026-09-15 20:10:19.999','Keluar',12494500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pamor'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),218983500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4a203a5b-8648-4672-bc82-8e312bb43c98',1,'2026-09-15','2026-09-15 20:14:06.533','Keluar',26110000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'Setor BSI',(SELECT id FROM users WHERE nik='pic01'),192873500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('5bf42983-f1c0-44c1-89bf-6fce97f351a3',1,'2026-09-15','2026-09-15 20:15:30.428','Keluar',8140000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Suminto'),'Setor BSI',(SELECT id FROM users WHERE nik='pic01'),184733500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('82f231be-3c13-4101-951d-9a093786b3d0',1,'2026-09-15','2026-09-15 20:16:26.448','Keluar',27255000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'Setor BSI',(SELECT id FROM users WHERE nik='pic01'),157478500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('570578f4-3458-47fd-8a22-27aa3f285579',1,'2026-09-15','2026-09-15 20:16:58.587','Keluar',133475000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'Setor BSI',(SELECT id FROM users WHERE nik='pic01'),24003500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ae02f6bb-c3ef-4df7-87af-2f0d9be41a62',1,'2026-09-15','2026-09-15 20:17:42.295','Keluar',15922000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Mukena Sogan Pak Saiful'),'',(SELECT id FROM users WHERE nik='pic01'),8081500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('5f3ddea6-a103-4873-9841-47ebdf45a6ef',1,'2026-09-16','2026-09-17 00:41:48.057','Masuk',40300000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),48381500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4d113be8-6f5a-417f-9633-94aa4d583b15',1,'2026-09-17','2026-09-18 00:28:35.037','Masuk',51900000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),100281500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('85b686ce-d566-4eba-ad7c-3a36dc9c4bc7',1,'2026-09-17','2026-09-18 00:29:13.189','Masuk',51900000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),152181500,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('0705c5f8-5824-41e6-b90e-3a70b1069aa9',1,'2026-09-17','2026-09-18 00:29:36.990','Masuk',51900000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),204081500,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('0bc3fa8a-3d4c-417d-b564-092f24ba163e',1,'2026-09-17','2026-09-18 00:30:45.410','Masuk',51900000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),255981500,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('548244f7-29b9-4e5e-8438-54a90ec68527',1,'2026-09-18','2026-09-18 00:34:37.830','Keluar',51900000,'Koreksi',NULL,'Koreksi pembatalan transaksi #0bc3fa8a — trouble sistem',(SELECT id FROM users WHERE nik='pic02'),204081500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('baa1f3d5-7962-4fed-a8e8-7eb068f0b241',1,'2026-09-18','2026-09-18 00:34:55.814','Keluar',51900000,'Koreksi',NULL,'Koreksi pembatalan transaksi #0705c5f8 — trouble sistem',(SELECT id FROM users WHERE nik='pic02'),152181500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('741c4a40-e829-4859-93cf-c6ef4f852949',1,'2026-09-18','2026-09-18 00:35:19.419','Keluar',51900000,'Koreksi',NULL,'Koreksi pembatalan transaksi #85b686ce — trouble sistem',(SELECT id FROM users WHERE nik='pic02'),100281500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('beb6d3c2-726e-4ea5-b3c5-7d7cdd8eda57',1,'2026-09-18','2026-09-19 00:35:36.177','Masuk',43800000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),144081500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ef4c4176-4784-4a74-81dd-ba3e943d94bf',1,'2026-09-15','2026-09-19 07:34:30.876','Masuk',44750000,'Setoran Toko',NULL,'Setoran toko',(SELECT id FROM users WHERE nik='pic01'),188831500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f44568d0-cc74-4909-87d8-ca54a0b41089',1,'2026-09-19','2026-09-19 14:27:13.335','Keluar',36100000,'Gaji',NULL,'Gajit tukang',(SELECT id FROM users WHERE nik='pic01'),152731500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('09c13934-3518-41e6-ac0c-5c9211265620',1,'2026-09-19','2026-09-19 14:27:55.692','Keluar',43750000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'Material',(SELECT id FROM users WHERE nik='pic01'),108981500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('598023da-b904-48e5-a7e3-5b035c4b8497',1,'2026-09-19','2026-09-20 00:23:45.232','Masuk',96400000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),205381500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3248d747-2d3d-494e-89c1-8e80dca02e1c',1,'2026-09-20','2026-09-21 00:23:08.685','Masuk',92100000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),297481500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('dcbc5722-c321-4046-a981-99ff82f17aae',1,'2026-09-21','2026-09-22 00:33:16.136','Masuk',54100000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),351581500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7884eea5-145e-4234-ba1b-3216d0a4b99a',1,'2026-09-22','2026-09-22 14:56:45.952','Keluar',2968000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),348613500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('aa6f5c60-f1ee-4d03-b8c2-b5aebf8cd616',1,'2026-09-22','2026-09-22 14:57:26.019','Keluar',1600000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Kinjeng'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),347013500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c4d4798a-76e7-4fa7-9c7b-e0df5e980464',1,'2026-09-22','2026-09-22 15:02:14.202','Keluar',2580000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Riry'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),344433500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('cf50ef7e-112e-425b-bcda-e6fac99cb935',1,'2026-09-22','2026-09-22 15:02:54.389','Keluar',2580000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Riry'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),341853500,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ff76aed6-cabb-4c7a-a667-c607fd6fc825',1,'2026-09-22','2026-09-22 19:33:00.894','Masuk',2580000,'Koreksi',NULL,'Koreksi pembatalan transaksi #cf50ef7e',(SELECT id FROM users WHERE nik='pic01'),344433500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c8f07a1c-7b36-43ab-8e77-d4832d77f8e9',1,'2026-09-22','2026-09-22 19:38:24.595','Keluar',5580000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ibu Solo'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),338853500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('66750f1e-557f-48af-8746-a1a0e8adcb92',1,'2026-09-22','2026-09-22 19:40:58.714','Keluar',44967500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),293886000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7cd38f6e-d49b-409c-aaa9-65c696b01ffe',1,'2026-09-22','2026-09-22 19:41:42.560','Keluar',44967500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),248918500,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d8f4e742-4660-40d6-8605-2b6d10fcda5e',1,'2026-09-22','2026-09-22 19:42:41.007','Keluar',44967500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),203951000,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('29456a06-8064-4b0b-8606-aa75c8cac7fc',1,'2026-09-22','2026-09-22 20:56:18.116','Masuk',44967500,'Koreksi',NULL,'Koreksi pembatalan transaksi #d8f4e742',(SELECT id FROM users WHERE nik='pic01'),248918500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b6d44eb4-e517-4a6f-8fb9-43405bd257b8',1,'2026-09-22','2026-09-22 21:38:14.619','Masuk',44967500,'Koreksi',NULL,'Koreksi pembatalan transaksi #7cd38f6e',(SELECT id FROM users WHERE nik='pic01'),293886000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('56dae68b-01d7-4ac3-b76e-b5c39376514c',1,'2026-09-22','2026-09-22 21:49:11.607','Keluar',41020000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aksesoris Padang'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),252866000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('bace1ab0-a701-429d-ada7-1123dc8629fa',1,'2026-09-22','2026-09-22 21:52:09.279','Keluar',10496500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Hasan'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),242369500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('bc62e480-27c6-44da-88e3-5d3f5dd07a85',1,'2026-09-22','2026-09-22 21:54:03.178','Keluar',42862500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),199507000,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('054a7dbf-b863-475b-920d-abd501730d0f',1,'2026-09-22','2026-09-22 21:59:31.146','Masuk',42862500,'Koreksi',NULL,'Koreksi pembatalan transaksi #bc62e480',(SELECT id FROM users WHERE nik='pic01'),242369500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b0654af0-f462-4d66-ac52-ea8a62dbe7a2',1,'2026-09-22','2026-09-22 22:01:19.756','Keluar',42865000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),199504500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d9d3182b-f509-4661-827d-85e8756835dd',1,'2026-09-22','2026-09-22 22:05:31.492','Keluar',14280000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),185224500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d5030c7b-bedd-406d-a041-eae287120424',1,'2026-09-22','2026-09-22 22:09:36.175','Keluar',73200000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),112024500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6aa658e5-c4bc-4a26-b4a1-7af1852ea410',1,'2026-09-22','2026-09-22 22:12:57.961','Keluar',11655000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),100369500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c4e4928f-2c3e-4ce1-aeb8-330177e15dd2',1,'2026-09-22','2026-09-22 22:13:25.439','Keluar',11655000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),88714500,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ac0ee50e-0575-4035-9c05-1a40f3e08342',1,'2026-09-22','2026-09-22 22:21:24.899','Masuk',11655000,'Koreksi',NULL,'Koreksi pembatalan transaksi #c4e4928f',(SELECT id FROM users WHERE nik='pic01'),100369500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4d6a2688-3ef1-4da3-b509-b0d591421a7c',1,'2026-09-22','2026-09-22 22:29:11.234','Keluar',28797000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik MR'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),71572500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('67f48029-358b-4a6c-9933-6eb689626a4e',1,'2026-09-22','2026-09-22 22:30:50.910','Keluar',22490000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jogja Handmade'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),49082500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('25be1144-c980-447b-9efa-2576d237f059',1,'2026-09-22','2026-09-22 22:32:05.656','Keluar',8270000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Kaos Oblong Istimewa'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),40812500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('fceec572-1fbc-4354-bedb-78edf6d58001',1,'2026-09-22','2026-09-23 00:37:20.448','Masuk',46500000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),87312500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d8cad44d-8f27-4a0a-99c9-c360c42b3746',1,'2026-09-23','2026-09-23 13:45:16.525','Keluar',13905000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Fatma'),'cash di toko',(SELECT id FROM users WHERE nik='pic01'),73407500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('07659fcd-fbac-4244-8e16-f48adbefaa2d',1,'2026-09-23','2026-09-24 00:30:23.700','Masuk',36250000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),109657500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c9e7b6bb-bc70-4684-97db-350b72aef188',1,'2026-09-24','2026-09-25 00:13:14.558','Masuk',47300000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),156957500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('24c41b48-a3c0-4bc9-8be9-7630f3019994',1,'2026-09-25','2026-09-25 19:57:41.488','Keluar',24480000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Tas Rajut Kulon Progo'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),132477500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('50d3c396-22f1-4449-b22c-184b20348c0c',1,'2026-09-25','2026-09-26 00:20:15.575','Masuk',46400000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),178877500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f52b3776-80b9-4beb-bee5-54f5857585b2',1,'2026-09-26','2026-09-27 00:49:29.208','Masuk',92750000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),271627500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c5620ff7-bb59-4c2b-88f6-4a86748d3a6d',1,'2026-09-27','2026-09-28 00:16:59.406','Masuk',80850000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),352477500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a9e72b64-d560-432f-b6db-a6372bbfbc22',1,'2026-09-26','2026-09-28 10:45:49.317','Keluar',30550000,'Gaji',NULL,'Gaji tukang',(SELECT id FROM users WHERE nik='pic01'),321927500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e083fb9e-1a4d-4280-a17a-aca05d2bd0df',1,'2026-09-26','2026-09-28 10:46:22.957','Keluar',18917000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'',(SELECT id FROM users WHERE nik='pic01'),303010500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('90fede5e-65a1-42b2-b4b5-bb340594d9ab',1,'2026-09-28','2026-09-28 14:30:25.514','Keluar',10177000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Catering'),'',(SELECT id FROM users WHERE nik='pic01'),292833500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('91a86dcc-e84b-414c-9368-10159776b30e',1,'2026-09-28','2026-09-29 00:26:27.560','Masuk',42600000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),335433500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('60474022-59b0-4a8f-82a8-39719561e504',1,'2026-09-29','2026-09-30 00:31:51.502','Masuk',43500000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),378933500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8c1f4e0c-bd65-4a6a-ab84-2aa475a6599e',1,'2026-10-01','2026-10-02 00:31:12.869','Masuk',64500000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),443433500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('03ebfafa-3b43-44e2-b682-f33c7869f28e',1,'2026-10-02','2026-10-03 00:27:10.275','Masuk',65450000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),508883500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7778d29d-2125-49e7-b6cb-8e161ce36184',1,'2026-09-29','2026-10-03 09:19:08.050','Keluar',292833500,'Setor ke Bank',NULL,'Setor BSI',(SELECT id FROM users WHERE nik='pic01'),216050000,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b4d42925-bc4b-4a11-a83b-586b2d271d6e',1,'2026-10-03','2026-10-03 09:37:28.827','Masuk',292833500,'Koreksi',NULL,'Koreksi pembatalan transaksi #7778d29d — revisi',(SELECT id FROM users WHERE nik='pic01'),508883500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f30376f8-74ac-434e-8de4-dd6b2aefb385',1,'2026-10-03','2026-10-03 09:38:08.449','Keluar',335433500,'Setor ke Bank',NULL,'Setor ke bank',(SELECT id FROM users WHERE nik='pic01'),173450000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9baa5841-0de3-4e0e-aa29-a8f9e97048ac',1,'2026-09-30','2026-10-03 09:39:55.039','Masuk',48100000,'Setoran Toko',NULL,'Setoran toko',(SELECT id FROM users WHERE nik='pic01'),221550000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('66d9e819-2ea9-449c-a6ff-1bf47ba6d61d',1,'2026-10-03','2026-10-03 12:10:29.248','Keluar',50990000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'Cash di toko',(SELECT id FROM users WHERE nik='pic01'),170560000,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8a7f95a5-a895-48df-9ba6-6e329cd2d666',1,'2026-10-03','2026-10-03 12:10:56.310','Keluar',51792000,'Gaji',NULL,'Gaji tukang',(SELECT id FROM users WHERE nik='pic01'),118768000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a54ef772-8da8-450e-a15e-6bce8d6608b7',1,'2026-10-03','2026-10-03 12:11:49.240','Masuk',50990000,'Koreksi',NULL,'Koreksi pembatalan transaksi #66d9e819 — salah',(SELECT id FROM users WHERE nik='pic01'),169758000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8a6c5c72-a1fa-4bd4-9edf-a2bc75ab3951',1,'2026-10-03','2026-10-03 12:12:14.929','Keluar',50299000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'Cash di toko',(SELECT id FROM users WHERE nik='pic01'),119459000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('bfa6361a-9f20-48e8-920d-dc70cf2fa982',1,'2026-10-03','2026-10-04 00:55:40.432','Masuk',120600000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),240059000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('885ceec8-7080-4d81-946c-1a528f107940',1,'2026-10-04','2026-10-05 00:27:02.451','Masuk',109850000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),349909000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('bf95abd9-da90-4404-916f-22308e42f286',1,'2026-10-05','2026-10-06 00:39:52.850','Masuk',47700000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),397609000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3bad29e4-2451-4f4a-ab3a-8a813608e949',1,'2026-10-06','2026-10-06 20:34:22.343','Masuk',64000000,'Setoran Toko',NULL,'bapak tf',(SELECT id FROM users WHERE nik='pic01'),461609000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('5957ecb1-a45e-461f-a336-a2591278400c',1,'2026-10-06','2026-10-06 20:36:05.943','Keluar',5020000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aksesoris Padang'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),456589000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('01186504-5177-4fda-8e61-4850114c3f88',1,'2026-10-06','2026-10-06 20:49:06.249','Keluar',22227000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),434362000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('12e44b1f-028b-40fb-8f74-e983ae3c8507',1,'2026-10-06','2026-10-06 20:49:45.126','Keluar',96937500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),337424500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3432702c-f4a4-4ae4-bfdb-6bd265ccf48c',1,'2026-10-06','2026-10-06 20:50:24.873','Keluar',64665000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),272759500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('665a9e20-666e-4b79-b770-4bf90eb46963',1,'2026-10-06','2026-10-06 21:02:12.317','Keluar',31603000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Rajut Bandung'),'setor bi fast rek mandiri',(SELECT id FROM users WHERE nik='pic01'),241156500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('289c43fa-8e55-459d-beae-155555daec3a',1,'2026-10-06','2026-10-06 21:02:49.559','Keluar',12512000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),228644500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('559695fe-454b-43f2-aab4-85f364a02da8',1,'2026-10-06','2026-10-06 21:03:29.240','Keluar',25508000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),203136500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d527c72d-42a6-4c17-b3ae-1f1ed6be2760',1,'2026-10-06','2026-10-06 21:04:23.545','Keluar',11900000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Tas Bandung'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),191236500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('851a347d-ff2f-4bdd-9ac7-e300948675d0',1,'2026-10-06','2026-10-06 21:05:07.600','Keluar',2580000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Riry'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),188656500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4f3a845c-11fc-4338-a418-1399a1e9a57e',1,'2026-10-06','2026-10-06 21:05:55.671','Keluar',3150000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Lima'),'setoran bsi',(SELECT id FROM users WHERE nik='pic01'),185506500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('516cad1b-8b02-4dde-9e5a-24917e337636',1,'2026-10-06','2026-10-06 21:06:38.145','Keluar',12900000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Damiri'),'setor bsi',(SELECT id FROM users WHERE nik='pic01'),172606500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7e544da8-bffa-4e2b-b36f-657e5c7702d5',1,'2026-10-06','2026-10-06 21:07:28.018','Keluar',5440000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Kinjeng'),'setoran bsi',(SELECT id FROM users WHERE nik='pic01'),167166500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('efe7ca60-0d9e-43e2-b1d1-09f79001ac71',1,'2026-10-06','2026-10-06 21:08:01.137','Keluar',6960000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Virenda'),'cash di toko',(SELECT id FROM users WHERE nik='pic01'),160206500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e04d823b-acac-4729-84ce-f5a35980021e',1,'2026-10-06','2026-10-06 21:09:18.295','Keluar',7495000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Gmp Tas Rajut'),'cash di toko',(SELECT id FROM users WHERE nik='pic01'),152711500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('bb711fc9-8019-4ac9-83d4-03e6429a1bff',1,'2026-10-06','2026-10-06 21:10:05.303','Keluar',25661000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jogja Handmade'),'cash di toko',(SELECT id FROM users WHERE nik='pic01'),127050500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6391c44e-64c0-4ad5-a14b-b17d00e00e06',1,'2026-10-06','2026-10-06 21:10:51.125','Keluar',5400000,'Gaji',NULL,'bapak ambil cash',(SELECT id FROM users WHERE nik='pic01'),121650500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('1c14fb00-057b-4e0d-881b-8907a983dad2',1,'2026-10-06','2026-10-06 21:14:09.175','Keluar',5800,'Setor ke Bank',NULL,'biaya bi fast',(SELECT id FROM users WHERE nik='pic01'),121644700,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9e586965-2d9a-4f13-a7d3-31b90a293e73',1,'2026-10-06','2026-10-06 21:14:38.440','Keluar',121644700,'Setor ke Bank',NULL,'rek bapak',(SELECT id FROM users WHERE nik='pic01'),0,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7b8653cf-d1dd-403b-81ee-4407ddc293e3',1,'2026-10-06','2026-10-07 00:24:15.110','Masuk',56850000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),56850000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('5323b679-2254-41d6-9946-7f1fa7a9aa26',1,'2026-10-07','2026-10-08 01:16:45.024','Masuk',61200000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),118050000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8156cbde-2c91-4c64-ab6b-df676488fce9',1,'2026-10-08','2026-10-09 00:22:16.598','Masuk',49200000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),167250000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d3f7fd8a-4cc9-43bf-9a98-61689a2ddb6a',1,'2026-10-09','2026-10-10 00:24:08.792','Masuk',74200000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),241450000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4750d192-b70a-4cdc-a6a0-f2962dacea06',1,'2026-10-10','2026-10-10 20:03:03.116','Keluar',51129000,'Gaji',NULL,'gaji tukang',(SELECT id FROM users WHERE nik='pic01'),190321000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4b01e318-7cbb-41d5-a4b1-c3f734837524',1,'2026-10-10','2026-10-10 20:06:06.332','Keluar',29862000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'material proyek',(SELECT id FROM users WHERE nik='pic01'),160459000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f10d1f6a-bbff-493e-94e0-e01a7952dc6d',1,'2026-10-10','2026-10-11 00:35:43.119','Masuk',96300000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),256759000,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('37e9bb99-8d82-49fb-ba0e-d18804e09918',1,'2026-10-11','2026-10-12 00:23:18.148','Masuk',96350000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),353109000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('eab4dbc4-d72e-4041-bac7-a04e022ec340',1,'2026-10-12','2026-10-13 00:22:11.396','Masuk',36850000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),389959000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9ecfb400-1b3a-44d1-8d46-00b40a559e3d',1,'2026-10-13','2026-10-13 08:09:37.815','Keluar',96300000,'Koreksi',NULL,'Koreksi pembatalan transaksi #f10d1f6a — salah nominal',(SELECT id FROM users WHERE nik='pic02'),293659000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a15b8b77-1c31-4c31-9361-3bc4c7f16b4a',1,'2026-10-11','2026-10-13 08:10:07.385','Masuk',95300000,'Setoran Toko',NULL,'Setoran',(SELECT id FROM users WHERE nik='pic01'),388959000,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ce14e827-ef24-42a1-bf77-9c860f6a6e5b',1,'2026-10-13','2026-10-13 08:10:28.148','Keluar',95300000,'Koreksi',NULL,'Koreksi pembatalan transaksi #a15b8b77',(SELECT id FROM users WHERE nik='pic01'),293659000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3e00e44f-0c65-4293-bf64-ad94f9d87cf9',1,'2026-10-10','2026-10-13 08:10:58.463','Masuk',95300000,'Setoran Toko',NULL,'Setoran',(SELECT id FROM users WHERE nik='pic01'),388959000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('de7d8894-de67-46e1-838e-cc0757ab8542',1,'2026-10-13','2026-10-14 00:35:37.921','Masuk',53200000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),442159000,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('98deab8f-da4a-4efd-9548-f7a8202a5ccf',1,'2026-10-14','2026-10-14 20:21:15.915','Keluar',53200000,'Koreksi',NULL,'Koreksi pembatalan transaksi #de7d8894',(SELECT id FROM users WHERE nik='pic02'),388959000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4e448ea2-70f3-47fc-b87b-4747f49204fc',1,'2026-10-14','2026-10-14 20:23:15.474','Keluar',41300000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'setor BSI',(SELECT id FROM users WHERE nik='pic01'),347659000,1); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c4da9953-00ea-4656-8feb-b1459620a43c',1,'2026-10-14','2026-10-14 20:23:29.029','Masuk',41300000,'Koreksi',NULL,'Koreksi pembatalan transaksi #4e448ea2',(SELECT id FROM users WHERE nik='pic01'),388959000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3c6842f2-adff-435a-af89-f82eb48037f2',1,'2026-10-14','2026-10-14 20:23:56.279','Masuk',60000000,'Setoran Toko',NULL,'bapak tf',(SELECT id FROM users WHERE nik='pic01'),448959000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('39f188ae-b56a-4900-a432-fa6c033e1899',1,'2026-10-14','2026-10-14 20:24:23.867','Keluar',41300000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'',(SELECT id FROM users WHERE nik='pic01'),407659000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a955b288-d876-40f3-95a1-00cc13936edc',1,'2026-10-14','2026-10-14 21:06:01.656','Keluar',8190000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Tas Prima'),'',(SELECT id FROM users WHERE nik='pic01'),399469000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4e644cd2-280e-4829-8615-4a82b0421607',1,'2026-10-14','2026-10-14 21:08:14.583','Keluar',6750000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Mustofa / Nadifa'),'',(SELECT id FROM users WHERE nik='pic01'),392719000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8bfcc4c5-6f62-462f-92e6-6dfbf16e69b3',1,'2026-10-14','2026-10-14 21:08:46.908','Keluar',19950000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'',(SELECT id FROM users WHERE nik='pic01'),372769000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('32a00c4c-f16d-423d-871b-a167bcff90f7',1,'2026-10-14','2026-10-14 21:09:13.158','Keluar',6609000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Hasan'),'',(SELECT id FROM users WHERE nik='pic01'),366160000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2b115479-a74e-47f5-ab80-c07b052f9ce8',1,'2026-10-14','2026-10-14 21:09:26.415','Keluar',83239000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Daster234'),'',(SELECT id FROM users WHERE nik='pic01'),282921000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('cae74dd3-1ad0-453d-a227-711a34f221af',1,'2026-10-14','2026-10-14 21:10:11.337','Keluar',35467000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'',(SELECT id FROM users WHERE nik='pic01'),247454000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('492bab99-3c51-428d-a9c9-9efa67fbc497',1,'2026-10-14','2026-10-14 21:10:33.901','Keluar',21725000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'',(SELECT id FROM users WHERE nik='pic01'),225729000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('68d470ce-f7ee-409e-8cf5-a1190db3dd64',1,'2026-10-14','2026-10-14 21:10:48.786','Keluar',29851000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'',(SELECT id FROM users WHERE nik='pic01'),195878000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e40673a1-86fa-4bbc-9236-8643f3962b61',1,'2026-10-14','2026-10-14 21:11:06.955','Keluar',13120000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Joist'),'',(SELECT id FROM users WHERE nik='pic01'),182758000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ac011738-04a3-4b55-9e72-4b311c1207e8',1,'2026-10-14','2026-10-14 21:11:34.564','Keluar',3800000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nadika Batik'),'',(SELECT id FROM users WHERE nik='pic01'),178958000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4c6b32db-cac9-4585-93ce-a9298bf21964',1,'2026-10-14','2026-10-14 21:11:57.889','Keluar',10872000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aneka'),'',(SELECT id FROM users WHERE nik='pic01'),168086000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('13e6e36d-d5d2-48b9-8e1d-3de0fdda3bae',1,'2026-10-14','2026-10-14 21:12:18.259','Keluar',16490000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Handicraft'),'',(SELECT id FROM users WHERE nik='pic01'),151596000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('21594b13-7f06-494e-8db4-686b98e8b492',1,'2026-10-14','2026-10-14 21:12:37.062','Keluar',95781000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulfa Accessories'),'',(SELECT id FROM users WHERE nik='pic01'),55815000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('711cb5ae-7ff7-400d-8fca-3560c2c7b8fc',1,'2026-10-14','2026-10-14 21:12:47.495','Keluar',17855000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulfa Shop Topi'),'',(SELECT id FROM users WHERE nik='pic01'),37960000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('87094e52-57ff-4fc4-bc28-776d9b992c22',1,'2026-10-14','2026-10-14 21:20:49.264','Keluar',16330000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Suminto'),'',(SELECT id FROM users WHERE nik='pic01'),21630000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ea088dc9-5c2e-48cb-b812-1db34746ce07',1,'2026-10-14','2026-10-14 21:21:52.445','Keluar',17500000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ibu Solo'),'',(SELECT id FROM users WHERE nik='pic01'),4130000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('cf601bdf-f6d4-412e-af66-ef2fc22c676f',1,'2026-10-14','2026-10-14 21:22:34.474','Keluar',3680000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Udeng Pak Rozak'),'',(SELECT id FROM users WHERE nik='pic01'),450000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3355f38a-1230-4709-9daf-74340ba6908e',1,'2026-10-14','2026-10-14 21:25:34.867','Keluar',8700,'Setor ke Bank',NULL,'',(SELECT id FROM users WHERE nik='pic01'),441300,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('47166961-3c0a-42dd-9e5b-d2a9be618aa8',1,'2026-10-14','2026-10-14 21:25:56.448','Keluar',441300,'Setor ke Bank',NULL,'rek bapak',(SELECT id FROM users WHERE nik='pic01'),0,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7f2e344f-2ce8-4204-91cb-875807fa5287',1,'2026-10-14','2026-10-14 00:23:45.000','Masuk',53200000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),53200000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('583779ab-457a-4f8f-b77d-2149bf1e241a',1,'2026-10-14','2026-10-15 00:17:09.153','Masuk',48750000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),101950000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f8bceafc-c438-4107-84f9-f431a2fc160a',1,'2026-10-15','2026-10-16 00:21:14.411','Masuk',64750000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),166700000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('41b30b8c-9515-4d8c-b83f-930e24dad2ed',1,'2026-10-17','2026-10-17 07:55:44.850','Masuk',52900000,'Setoran Toko',NULL,'',(SELECT id FROM users WHERE nik='pic02'),219600000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('07353011-349b-43fd-9780-b211d512d42b',1,'2026-10-17','2026-10-17 11:18:49.972','Keluar',39149000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'Cash ditoko',(SELECT id FROM users WHERE nik='pic01'),180451000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('50ba0648-a460-4bf9-987c-6d92951fa26a',1,'2026-10-17','2026-10-17 11:19:28.833','Keluar',51815000,'Gaji',NULL,'Cash di proyek',(SELECT id FROM users WHERE nik='pic01'),128636000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('bdb5b81d-9d92-4cc2-8588-410d0a9b66a2',1,'2026-10-17','2026-10-18 00:32:08.927','Masuk',101550000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),230186000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ec93a0d8-e6a6-43e6-a992-1a8b08b80d6f',1,'2026-10-18','2026-10-19 00:21:31.622','Masuk',97200000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),327386000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6256f00c-54c5-4fea-a79e-5f1408c385d7',1,'2026-10-19','2026-10-20 00:28:37.536','Masuk',38250000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),365636000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3d107e60-2f5c-41da-bcb9-de49acb61bf9',1,'2026-10-20','2026-10-21 12:18:27.244','Masuk',53200000,'Setoran Toko',NULL,'bapak TF',(SELECT id FROM users WHERE nik='pic01'),418836000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('447d3d68-ad41-4188-a5ad-3cd23e3208cb',1,'2026-10-20','2026-10-21 12:26:12.809','Keluar',49059500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'',(SELECT id FROM users WHERE nik='pic01'),369776500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b87b71a7-e558-4d92-9eb6-39af1233bdf2',1,'2026-10-20','2026-10-21 12:26:48.674','Keluar',920000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Udeng Pak Rozak'),'',(SELECT id FROM users WHERE nik='pic01'),368856500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e25ef7ca-eb9b-429d-a6ab-f274c3e06c67',1,'2026-10-20','2026-10-21 12:28:06.695','Keluar',35802000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'',(SELECT id FROM users WHERE nik='pic01'),333054500,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('96c1d1d9-2e33-4b1a-b16e-4b99deee2f84',1,'2026-10-20','2026-10-21 12:28:52.718','Keluar',6620500,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Hasan'),'',(SELECT id FROM users WHERE nik='pic01'),326434000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('df47b7f5-597d-45e6-ac39-ea472e9c3ea8',1,'2026-10-20','2026-10-21 12:29:20.949','Keluar',22860000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Damiri'),'',(SELECT id FROM users WHERE nik='pic01'),303574000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('abb4f813-fe87-456e-94db-5a5a02c84f30',1,'2026-10-20','2026-10-21 12:29:49.963','Keluar',36282000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'',(SELECT id FROM users WHERE nik='pic01'),267292000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8b931a1a-fc36-497f-9ac9-6cb3dc090055',1,'2026-10-20','2026-10-21 12:30:31.449','Keluar',31123000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'',(SELECT id FROM users WHERE nik='pic01'),236169000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('fac6a7a5-8d6b-48cd-bc96-e0c76d910981',1,'2026-10-20','2026-10-21 12:30:59.852','Keluar',24600000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Joist'),'',(SELECT id FROM users WHERE nik='pic01'),211569000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('31524690-1269-478e-bed2-48742d127e74',1,'2026-10-20','2026-10-21 12:31:51.073','Keluar',12069000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aneka'),'',(SELECT id FROM users WHERE nik='pic01'),199500000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d68c52bb-ccbb-4da0-8d98-280a3e0e1aa8',1,'2026-10-20','2026-10-21 12:33:36.435','Keluar',34672000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jogja Handmade'),'',(SELECT id FROM users WHERE nik='pic01'),164828000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e8715fea-6284-4a11-9b2d-312af9990c45',1,'2026-10-20','2026-10-21 12:34:16.337','Keluar',11102000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pamor'),'',(SELECT id FROM users WHERE nik='pic01'),153726000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f999a924-a79f-44dc-8aa2-721522595425',1,'2026-10-20','2026-10-21 12:34:44.139','Keluar',32400000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'',(SELECT id FROM users WHERE nik='pic01'),121326000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('436e2449-441a-45aa-a4d6-be764de2bc08',1,'2026-10-20','2026-10-21 12:35:27.578','Keluar',8130000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Handicraft'),'',(SELECT id FROM users WHERE nik='pic01'),113196000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('27df0c63-be84-4b54-975f-d659af4362bf',1,'2026-10-20','2026-10-21 12:35:48.057','Keluar',60784000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'',(SELECT id FROM users WHERE nik='pic01'),52412000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3665362f-962b-4f2a-a653-f3df726babdc',1,'2026-10-20','2026-10-21 12:36:25.063','Keluar',4500000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Lima'),'',(SELECT id FROM users WHERE nik='pic01'),47912000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('226a712c-7fe1-402c-ab88-bb73d3aa5641',1,'2026-10-20','2026-10-21 12:36:57.462','Keluar',5484000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Riry'),'',(SELECT id FROM users WHERE nik='pic01'),42428000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d45b73f2-bdd2-4d56-807c-5a77f23700bd',1,'2026-10-20','2026-10-21 12:38:07.896','Keluar',12900000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Mangkunagari'),'',(SELECT id FROM users WHERE nik='pic01'),29528000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('13941265-4038-481d-86b6-1e97d8401a1b',1,'2026-10-20','2026-10-21 12:39:14.502','Keluar',2240000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Kinjeng'),'',(SELECT id FROM users WHERE nik='pic01'),27288000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d1a9b58f-6b3d-470f-8496-4925cc6052d2',1,'2026-10-20','2026-10-21 12:40:24.733','Keluar',4700000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jehan Arum / Pak Adib'),'',(SELECT id FROM users WHERE nik='pic01'),22588000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('d16092ab-7b5b-4e44-8655-443813f6a870',1,'2026-10-20','2026-10-21 12:41:25.115','Keluar',11440000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Ari'),'',(SELECT id FROM users WHERE nik='pic01'),11148000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b76095f4-d004-40d4-a9f2-23698441c5d5',1,'2026-10-21','2026-10-21 12:42:52.192','Keluar',6056000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='HJ Atik'),'',(SELECT id FROM users WHERE nik='pic01'),5092000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('1f55ff6d-709e-4dde-a014-dbb5557628d5',1,'2026-10-21','2026-10-21 12:43:17.205','Keluar',4700000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Tas Kang Basir'),'',(SELECT id FROM users WHERE nik='pic01'),392000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e09e8283-fc16-4294-b59a-8cc537f1e3dd',1,'2026-10-21','2026-10-21 12:45:05.421','Keluar',200000,'Setor ke Bank',NULL,'salah nominal tf 53.200.000 harusnya53.000.000',(SELECT id FROM users WHERE nik='pic01'),192000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ed20b41a-ee75-4296-9d7b-dc19bc8ec7e6',1,'2026-10-21','2026-10-21 12:46:05.861','Keluar',186700,'Gaji',NULL,'Tf ke bapak',(SELECT id FROM users WHERE nik='pic01'),5300,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('3a5d68d8-f804-465b-813b-e33f1f1842d9',1,'2026-10-21','2026-10-21 12:46:34.591','Keluar',5300,'Setor ke Bank',NULL,'setor via bi fast bsi',(SELECT id FROM users WHERE nik='pic01'),0,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('1cdcf6db-9991-47ba-8514-4b0d5ff0d990',1,'2026-10-20','2026-10-21 12:47:09.652','Masuk',36800000,'Setoran Toko',NULL,'',(SELECT id FROM users WHERE nik='pic02'),36800000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8abc6cdf-17f4-4784-871e-f014cf488362',1,'2026-10-21','2026-10-22 00:25:26.581','Masuk',45950000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),82750000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4296d586-9996-451c-b79a-77afd66788dd',1,'2026-10-22','2026-10-23 00:17:00.835','Masuk',60100000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),142850000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('24aad104-b704-4269-b888-26deebcfc4aa',1,'2026-10-23','2026-10-24 00:27:47.930','Masuk',77500000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),220350000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('7fbc6e38-090b-4288-83ca-5b04b5913791',1,'2026-10-24','2026-10-24 12:14:55.809','Keluar',48567000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Material P Widodo'),'',(SELECT id FROM users WHERE nik='pic01'),171783000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6e746679-3e41-427f-b3d3-48ee1c1f62d1',1,'2026-10-24','2026-10-24 12:15:18.057','Keluar',54265000,'Gaji',NULL,'Gaji tukang',(SELECT id FROM users WHERE nik='pic01'),117518000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('8101c75c-5710-4504-bead-71e539118637',1,'2026-10-24','2026-10-25 00:41:10.801','Masuk',96150000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),213668000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e7d54bc4-dfbb-481b-8ce5-e90ce04b2646',1,'2026-10-25','2026-10-26 00:47:11.217','Masuk',88900000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),302568000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('74bc665e-0877-47b3-b151-db05fd43bbd8',1,'2026-10-26','2026-10-27 00:22:07.234','Masuk',56350000,'Setoran Toko',NULL,'Setor harian',(SELECT id FROM users WHERE nik='pic02'),358918000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('fe7870cf-cd1c-4c15-bf55-1ae6ebf0d0d6',1,'2026-10-27','2026-10-27 00:00:00.000','Keluar',61505000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Vara'),'',(SELECT id FROM users WHERE nik='pic01'),297413000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ac62888a-60d6-43ba-8235-7e0ca3c8433b',1,'2026-10-27','2026-10-27 00:00:00.000','Keluar',9920000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Prima Jaya'),'',(SELECT id FROM users WHERE nik='pic01'),287493000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('f9a3c920-c3ec-466a-b9ad-eeaeeba0fe43',1,'2026-10-27','2026-10-27 00:00:00.000','Keluar',2400000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Tas Belacu Hitam Aisyah'),'',(SELECT id FROM users WHERE nik='pic01'),285093000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('852e8993-bb43-4712-b726-3197a7e12bd4',1,'2026-10-27','2026-10-27 00:00:00.000','Keluar',15030000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Ulya'),'',(SELECT id FROM users WHERE nik='pic01'),270063000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('560b8f5f-f399-43d2-ad28-d8c93348c3d5',1,'2026-10-27','2026-10-27 00:00:00.000','Keluar',18601000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Jogja Handmade'),'',(SELECT id FROM users WHERE nik='pic01'),251462000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('412baa6c-33e5-4110-8131-d2f52c2de5be',1,'2026-10-27','2026-10-27 00:00:00.000','Keluar',930000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nadika Batik'),'',(SELECT id FROM users WHERE nik='pic01'),250532000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('e7941b1a-117d-4375-8cb1-54b24122d729',1,'2026-10-27','2026-10-28 09:21:30.725','Keluar',18200000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Batik Fatma'),'',(SELECT id FROM users WHERE nik='pic01'),232332000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ea6efb95-5380-4b0e-91f3-d1c0f653fa42',1,'2026-10-27','2026-10-28 09:22:11.590','Keluar',6990000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Pak Hasan'),'',(SELECT id FROM users WHERE nik='pic01'),225342000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9856eb1d-878b-434e-a85d-25bd4c804cb2',1,'2026-10-27','2026-10-28 09:23:05.266','Keluar',20192000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Sobo Jaya'),'',(SELECT id FROM users WHERE nik='pic01'),205150000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('fdc153e0-59c6-4423-bb48-23544f21bf2f',1,'2026-10-27','2026-10-28 09:23:56.448','Keluar',16760000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Alesha'),'',(SELECT id FROM users WHERE nik='pic01'),188390000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ff391c57-f285-4343-9e47-effbb242a526',1,'2026-10-27','2026-10-28 09:24:30.663','Keluar',10499000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aneka'),'',(SELECT id FROM users WHERE nik='pic01'),177891000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('ad9155f0-95c5-4985-b864-9a51b6c4ce00',1,'2026-10-27','2026-10-28 09:25:03.439','Keluar',16270000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Suminto'),'',(SELECT id FROM users WHERE nik='pic01'),161621000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('2018a004-074d-4d82-98e5-6abe556776c0',1,'2026-10-27','2026-10-28 09:26:42.925','Keluar',2535000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aksesoris Ucok'),'',(SELECT id FROM users WHERE nik='pic01'),159086000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('4965f6bd-fa9c-440d-8359-7689aa8e92c5',1,'2026-10-27','2026-10-28 09:27:10.668','Keluar',31163000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='OJ'),'',(SELECT id FROM users WHERE nik='pic01'),127923000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('dfd16f31-6c84-48a1-a84d-82f0c6e43294',1,'2026-10-27','2026-10-28 09:27:57.538','Keluar',4950000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Aksesoris Madura Dream Catcher'),'',(SELECT id FROM users WHERE nik='pic01'),122973000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('b897551a-4888-4ead-a37c-89eb3103f2db',1,'2026-10-27','2026-10-28 09:28:20.533','Keluar',9730000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Joist'),'',(SELECT id FROM users WHERE nik='pic01'),113243000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('6c52403c-2363-4049-93a7-83317b000d5d',1,'2026-10-27','2026-10-28 09:28:44.068','Keluar',25020000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Putri Tanjung'),'',(SELECT id FROM users WHERE nik='pic01'),88223000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('a4aac9c5-e2d4-42f2-8830-6b9cc6a0b772',1,'2026-10-27','2026-10-28 09:29:13.326','Keluar',10547000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Azra/Daster Melva'),'',(SELECT id FROM users WHERE nik='pic01'),77676000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('025831d0-9803-4f83-a9a9-0e195ed08e1c',1,'2026-10-27','2026-10-28 09:29:36.382','Keluar',41440000,'Bayar Supplier',(SELECT id FROM suppliers WHERE nama='Nur Cahyo'),'',(SELECT id FROM users WHERE nik='pic01'),36236000,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('c2cc4faf-edf6-40a1-954c-df2280734d50',1,'2026-10-27','2026-10-28 09:30:40.916','Keluar',36227300,'Setor ke Bank',NULL,'',(SELECT id FROM users WHERE nik='pic01'),8700,0); INSERT IGNORE INTO jurnal (kode,brangkas_id,tanggal,created_at,jenis,nominal,kategori,supplier_id,keterangan,pic_user_id,saldo_setelah,dibatalkan) VALUES ('9dc8387d-0e63-4927-a36e-712ce0a2cb3d',1,'2026-10-27','2026-10-28 09:31:11.893','Keluar',8700,'Setor ke Bank',NULL,'',(SELECT id FROM users WHERE nik='pic01'),0,0); UPDATE jurnal k JOIN jurnal o ON o.kode='0bc3fa8a-3d4c-417d-b564-092f24ba163e' SET k.ref_koreksi_id=o.id WHERE k.kode='548244f7-29b9-4e5e-8438-54a90ec68527'; UPDATE jurnal k JOIN jurnal o ON o.kode='0705c5f8-5824-41e6-b90e-3a70b1069aa9' SET k.ref_koreksi_id=o.id WHERE k.kode='baa1f3d5-7962-4fed-a8e8-7eb068f0b241'; UPDATE jurnal k JOIN jurnal o ON o.kode='85b686ce-d566-4eba-ad7c-3a36dc9c4bc7' SET k.ref_koreksi_id=o.id WHERE k.kode='741c4a40-e829-4859-93cf-c6ef4f852949'; UPDATE jurnal k JOIN jurnal o ON o.kode='cf50ef7e-112e-425b-bcda-e6fac99cb935' SET k.ref_koreksi_id=o.id WHERE k.kode='ff76aed6-cabb-4c7a-a667-c607fd6fc825'; UPDATE jurnal k JOIN jurnal o ON o.kode='d8f4e742-4660-40d6-8605-2b6d10fcda5e' SET k.ref_koreksi_id=o.id WHERE k.kode='29456a06-8064-4b0b-8606-aa75c8cac7fc'; UPDATE jurnal k JOIN jurnal o ON o.kode='7cd38f6e-d49b-409c-aaa9-65c696b01ffe' SET k.ref_koreksi_id=o.id WHERE k.kode='b6d44eb4-e517-4a6f-8fb9-43405bd257b8'; UPDATE jurnal k JOIN jurnal o ON o.kode='bc62e480-27c6-44da-88e3-5d3f5dd07a85' SET k.ref_koreksi_id=o.id WHERE k.kode='054a7dbf-b863-475b-920d-abd501730d0f'; UPDATE jurnal k JOIN jurnal o ON o.kode='c4e4928f-2c3e-4ce1-aeb8-330177e15dd2' SET k.ref_koreksi_id=o.id WHERE k.kode='ac0ee50e-0575-4035-9c05-1a40f3e08342'; UPDATE jurnal k JOIN jurnal o ON o.kode='7778d29d-2125-49e7-b6cb-8e161ce36184' SET k.ref_koreksi_id=o.id WHERE k.kode='b4d42925-bc4b-4a11-a83b-586b2d271d6e'; UPDATE jurnal k JOIN jurnal o ON o.kode='66d9e819-2ea9-449c-a6ff-1bf47ba6d61d' SET k.ref_koreksi_id=o.id WHERE k.kode='a54ef772-8da8-450e-a15e-6bce8d6608b7'; UPDATE jurnal k JOIN jurnal o ON o.kode='f10d1f6a-bbff-493e-94e0-e01a7952dc6d' SET k.ref_koreksi_id=o.id WHERE k.kode='9ecfb400-1b3a-44d1-8d46-00b40a559e3d'; UPDATE jurnal k JOIN jurnal o ON o.kode='a15b8b77-1c31-4c31-9361-3bc4c7f16b4a' SET k.ref_koreksi_id=o.id WHERE k.kode='ce14e827-ef24-42a1-bf77-9c860f6a6e5b'; UPDATE jurnal k JOIN jurnal o ON o.kode='de7d8894-de67-46e1-838e-cc0757ab8542' SET k.ref_koreksi_id=o.id WHERE k.kode='98deab8f-da4a-4efd-9548-f7a8202a5ccf'; UPDATE jurnal k JOIN jurnal o ON o.kode='4e448ea2-70f3-47fc-b87b-4747f49204fc' SET k.ref_koreksi_id=o.id WHERE k.kode='c4da9953-00ea-4656-8feb-b1459620a43c'; UPDATE brangkas SET saldo=0 WHERE id=1; COMMIT; -- Cek hasil: harusnya 370 baris jurnal, saldo akhir 0 SELECT COUNT(*) AS baris_jurnal, (SELECT saldo FROM brangkas WHERE id=1) AS saldo_brangkas, (SELECT COUNT(*) FROM suppliers) AS supplier FROM jurnal;