INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','A1E-ZHBG-211-0','1','0.530','0.530','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBG-211-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-211-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-28 07:54:51' WHERE kode_barang='A1E-ZHBG-211-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBG-211-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:54:51','TOKO','PM-A','A1E','A1E-ZHBG-211-0','1','0.530','0.530','1','0.530','0.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZHBG-211-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-211-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','A1E-ZHBG-212-0','1','0.520','0.520','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBG-212-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-212-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-28 07:54:51' WHERE kode_barang='A1E-ZHBG-212-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBG-212-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:54:51','TOKO','PM-A','A1E','A1E-ZHBG-212-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZHBG-212-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-212-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','A1E-ZHBG-213-0','1','0.480','0.480','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBG-213-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-213-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-28 07:54:51' WHERE kode_barang='A1E-ZHBG-213-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBG-213-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:54:51','TOKO','PM-A','A1E','A1E-ZHBG-213-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZHBG-213-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-213-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','A1E-ZHBG-214-0','1','0.480','0.480','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBG-214-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-214-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-28 07:54:51' WHERE kode_barang='A1E-ZHBG-214-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBG-214-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:54:51','TOKO','PM-A','A1E','A1E-ZHBG-214-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZHBG-214-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-214-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','A1E-ZHBG-215-0','1','0.520','0.520','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBG-215-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-215-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-28 07:54:51' WHERE kode_barang='A1E-ZHBG-215-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBG-215-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:54:51','TOKO','PM-A','A1E','A1E-ZHBG-215-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZHBG-215-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-215-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','A1E-ZHBG-216-0','1','0.520','0.520','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZHBG-216-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-216-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-08-28 07:54:51' WHERE kode_barang='A1E-ZHBG-216-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZHBG-216-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:54:51','TOKO','PM-A','A1E','A1E-ZHBG-216-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='A1E-ZHBG-216-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZHBG-216-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0001','2026-08-28','07:54','3.050','admpindah','2026-08-28 07:54:50');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','B1E-ZHBG-207-0','1','0.500','0.500','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHBG-207-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHBG-207-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-08-28 07:55:11' WHERE kode_barang='B1E-ZHBG-207-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHBG-207-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:55:11','TOKO','PM-B','B1E','B1E-ZHBG-207-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZHBG-207-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHBG-207-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','B1E-ZHBG-208-0','1','0.570','0.570','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHBG-208-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHBG-208-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-08-28 07:55:11' WHERE kode_barang='B1E-ZHBG-208-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHBG-208-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:55:11','TOKO','PM-B','B1E','B1E-ZHBG-208-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZHBG-208-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHBG-208-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','B1E-ZHBG-209-0','1','0.480','0.480','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHBG-209-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHBG-209-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-08-28 07:55:11' WHERE kode_barang='B1E-ZHBG-209-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHBG-209-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:55:11','TOKO','PM-B','B1E','B1E-ZHBG-209-0','1','0.480','0.480','1','0.480','0.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZHBG-209-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHBG-209-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','B1E-ZHBG-210-0','1','0.500','0.500','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZHBG-210-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZHBG-210-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-08-28 07:55:11' WHERE kode_barang='B1E-ZHBG-210-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZHBG-210-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:55:11','TOKO','PM-B','B1E','B1E-ZHBG-210-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='B1E-ZHBG-210-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZHBG-210-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0001','2026-08-28','07:55','2.050','admpindah','2026-08-28 07:55:11');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','E2D-ZHXC-61-0','1','2.070','2.070','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZHXC-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZHXC-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-08-28 07:55:28' WHERE kode_barang='E2D-ZHXC-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZHXC-61-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:55:28','TOKO','PM-E','E2D','E2D-ZHXC-61-0','1','2.070','2.070','1','2.070','2.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZHXC-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZHXC-61-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','E2D-ZHBF-140-0','1','1.150','1.150','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZHBF-140-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZHBF-140-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-08-28 07:55:28' WHERE kode_barang='E2D-ZHBF-140-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZHBF-140-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:55:28','TOKO','PM-E','E2D','E2D-ZHBF-140-0','1','1.150','1.150','1','1.150','1.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E2D-ZHBF-140-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZHBF-140-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','E1D-ZHBF-232-0','1','2.210','2.210','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZHBF-232-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZHBF-232-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-08-28 07:55:28' WHERE kode_barang='E1D-ZHBF-232-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZHBF-232-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:55:28','TOKO','PM-E','E1D','E1D-ZHBF-232-0','1','2.210','2.210','1','2.210','2.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1D' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MD' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MD' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='E1D-ZHBF-232-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZHBF-232-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0001','2026-08-28','07:55','5.430','admpindah','2026-08-28 07:55:28');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','F2E-ZHAI-73-0','1','7.060','7.060','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F2E-ZHAI-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F2E-ZHAI-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-08-28 07:55:45' WHERE kode_barang='F2E-ZHAI-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F2E-ZHAI-73-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:55:45','TOKO','PM-F','F2E','F2E-ZHAI-73-0','1','7.060','7.060','1','7.060','7.060','100.00');
DELETE FROM tm_dept WHERE kode_dept='F2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F2E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F2E-ZHAI-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='F2E-ZHAI-73-0';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','F3E-ZHBG-217-0','1','3.850','3.850','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZHBG-217-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZHBG-217-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-08-28 07:55:45' WHERE kode_barang='F3E-ZHBG-217-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZHBG-217-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:55:45','TOKO','PM-F','F3E','F3E-ZHBG-217-0','1','3.850','3.850','1','3.850','3.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='F3E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F3E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='F3E-ZHBG-217-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZHBG-217-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0001','2026-08-28','07:55','10.910','admpindah','2026-08-28 07:55:45');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260828-0001','1','H1E-ZHBE-43-0','1','2.150','2.150','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZHBE-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZHBE-43-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-08-28 07:56:02' WHERE kode_barang='H1E-ZHBE-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZHBE-43-0' LIMIT 1;
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-28 07:56:02','TOKO','PM-H','H1E','H1E-ZHBE-43-0','1','2.150','2.150','1','2.150','2.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='H1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='H1E' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='ME' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='ME' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='H1E-ZHBE-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZHBE-43-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260828-0001','2026-08-28','07:55','2.150','admpindah','2026-08-28 07:56:02');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326280837061','input','1',' MDE1 X CM ','TOKO','PM-E','E1D-ZDBA-188-0','CC X BANGKOK SLEP CM 10 8K ','','0.870','1','100.00','900000','0','0','15000','900000','0','0','0','900000','LIS','00400471','E1D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZDBA-188-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='E1D-ZDBA-188-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280837061','2026-08-28','0.870','2026-08-28','08:37:07','PLG0031012','900000','900000','0','900000','900000','input','2026-08-28 08:37:06','F32628083706');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326280837061','2026-08-28','08:37:07','LIS','900000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260828-0002','D','2026-08-28','08:37:07','input','PENJUALAN','F326280837061','7062817000','900000','7063717000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326280925351','input','1',' MDE2X 10K ','TOKO','PM-E','E2D-ZDBA-63-0','CC X WEDDING MATA CM 14 8K ','','1.650','1','100.00','1708000','0','0','15000','1708000','0','10000','0','1718000','LIS','00400346','E2D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDBA-63-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.650',berat_jual_asli=berat_jual_asli+'1.650',stock_jual='1',berat_akhir=berat_akhir-'1.650',berat_akhir_asli=berat_akhir_asli-'1.650',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='E2D-ZDBA-63-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280925351','2026-08-28','1.650','2026-08-28','09:25:35','PLG0031013','1708000','1708000','10000','1718000','1718000','input','2026-08-28 09:25:35','F32628092535');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326280925351','2026-08-28','09:25:35','LIS','1718000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260828-0003','D','2026-08-28','09:25:35','input','PENJUALAN','F326280925351','7063717000','1718000','7065435000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1718000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280925351' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326280925352','input',' 1',' MFE1F KH 1','TOKO','PM-E','E1F-ZHBE-314-0','CC MODEL SPECTRA SLEP KH 14 8K ','','0.350','1','100.00','376000','0','0','15000','377000','0','0','0','377000','LIS','00420356','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHBE-314-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='E1F-ZHBE-314-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280925352','2026-08-28','0.350','2026-08-28','09:25:35','PLG0031014','377000','377000','0','377000','377000','input','2026-08-28 09:25:35','F32628092535');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326280925352','2026-08-28','09:25:35','LIS','377000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260828-0004','D','2026-08-28','09:25:35','input','PENJUALAN','F326280925352','7065435000','377000','7065812000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='377000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326280925352' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281002011','input','1',' MIH2 XXX U','TOKO','PM-H','H2I-ZGAG-187-0','KL XXX KOREA UB 46 8K','','0.870','1','100.00','987000','0','0','15000','960000','0','0','0','960000','LIS','00414023','H2I','0','0','-','1','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-ZGAG-187-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.870',berat_jual_asli=berat_jual_asli+'0.870',stock_jual='1',berat_akhir=berat_akhir-'0.870',berat_akhir_asli=berat_akhir_asli-'0.870',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='H2I-ZGAG-187-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281002011','2026-08-28','0.870','2026-08-28','10:02:02','PLG0031015','960000','960000','0','960000','960000','input','2026-08-28 10:02:01','F32628100201');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281002011','2026-08-28','10:02:02','LIS','960000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260828-0005','D','2026-08-28','10:02:02','input','PENJUALAN','F326281002011','7065812000','960000','7066772000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281002481','input','1',' TEE1 X CM ','TOKO','PT-E','E1TE-VGBA-68-T','CC X WEDDING SLEP CM 12 ','','1.550','1','100.00','3022000','0','0','15000','3023000','0','0','0','3023000','FIT','T0036259','E1TE','0','0','-','0','1950000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1TE-VGBA-68-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.550',berat_jual_asli=berat_jual_asli+'1.550',stock_jual='1',berat_akhir=berat_akhir-'1.550',berat_akhir_asli=berat_akhir_asli-'1.550',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='E1TE-VGBA-68-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281002481','2026-08-28','1.550','2026-08-28','10:02:49','PLG0031016','3023000','3023000','0','3023000','3023000','input','2026-08-28 10:02:48','F32628100248');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281002481','2026-08-28','10:02:49','FIT','3023000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260828-0006','D','2026-08-28','10:02:49','input','PENJUALAN','F326281002481','7066772000','3023000','7069795000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020033','X-00020033','KL GUCI ANAK 34 CM UB 8K','GR','---','H1E','BELI','BELI001','1027000','2026-08-28','1.050','1','kasir','2026-08-28 10:08:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020033','X-00020033');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260828-0001','F326251053521','LIS','1','BELI','BELI001','H1E', 'X-00020033', 'KL GUCI ANAK 34 CM UB 8K','1.050','1.050','100.00','1165000','1027000','978095','1065000','1','1027000','1027000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260828-0001','2026-08-28','2026-08-28','10:08:56','LIS','---','1.050','1027000','1027000','1027000','1027000','1027000','kasir','2026-08-28 10:08:57','FB-260828-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260828-0001','ANNA','BUGELAN KISMANTORO','','','','kasir','2026-08-28 10:08:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-28' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260828-0007','K','2026-08-28','10:08:56','kasir','PEMBELIAN UMUM','FB-260828-0001','7069795000','1027000','7068768000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020034','X-00020034','CC WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','1802000','2026-08-28','1.970','1','kasir','2026-08-28 10:10:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020034','X-00020034');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260828-0002','F325280943152','LIS','1','BELI','BELI001','E2D', 'X-00020034', 'CC WEDDING MATA CM 20 8K','1.970','1.970','100.00','1960000','1802000','914721','1045000','1','1802000','1802000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.970',berat_beli_asli=berat_beli_asli+'1.970',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.970',berat_akhir_asli=berat_akhir_asli+'1.970',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260828-0002','2026-08-28','2026-08-28','10:10:29','LIS','---','1.970','1802000','1802000','1802000','1802000','1802000','kasir','2026-08-28 10:10:29','FB-260828-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260828-0002','KARINA','BADEGAN PONOROGO','','','','kasir','2026-08-28 10:10:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-28' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260828-0008','K','2026-08-28','10:10:29','kasir','PEMBELIAN UMUM','FB-260828-0002','7068768000','1802000','7066966000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020035','X-00020035','CC X GELOMBANG C SLEP YT 12 8K','GR','---','E1D','BELI','BELI001','1330000','2026-08-28','1.450','1','kasir','2026-08-28 10:10:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020035','X-00020035');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260828-0003','F325221000161','LIS','2','BELI','BELI001','E1D', 'X-00020035', 'CC X GELOMBANG C SLEP YT 12 8K','1.450','1.450','100.00','1430000','1330000','917241','1045000','1','1330000','1330000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.450',berat_beli_asli=berat_beli_asli+'1.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.450',berat_akhir_asli=berat_akhir_asli+'1.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260828-0003','2026-08-28','2026-08-28','10:10:29','LIS','---','1.450','1330000','1330000','1330000','1330000','1330000','kasir','2026-08-28 10:10:29','FB-260828-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260828-0003','RIDWAN','BADEGAN','','','','kasir','2026-08-28 10:10:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-28' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260828-0009','K','2026-08-28','10:10:29','kasir','PEMBELIAN UMUM','FB-260828-0003','7066966000','1330000','7065636000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281013091','kasir','1',' MIH2 X KH ','TOKO','PM-H','H2I-YDXB-165-0','KL X SANTA KH 44CM 9K ','','9.900','1','100.00','11236000','0','0','15000','11236000','0','0','0','11236000','SIN','00347698','H2I','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2I-YDXB-165-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.900',berat_jual_asli=berat_jual_asli+'9.900',stock_jual='1',berat_akhir=berat_akhir-'9.900',berat_akhir_asli=berat_akhir_asli-'9.900',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='H2I-YDXB-165-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281013091','2026-08-28','9.900','2026-08-28','10:13:09','PLG0031017','11236000','11236000','0','11236000','11236000','kasir','2026-08-28 10:13:09','F32628101309');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281013091','2026-08-28','10:13:09','SIN','11236000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260828-0010','D','2026-08-28','10:13:09','kasir','PENJUALAN','F326281013091','7065636000','11236000','7076872000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020036','X-00020036','LT COR M 8K','GR','---','D2F','BELI','BELI001','235000','2026-08-28','0.460','1','kasir','2026-08-28 10:17:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00020036','X-00020036');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260828-0004','F321210946552','SIN','1','BELI','BELI001','D2F', 'X-00020036', 'LT COR M 8K','0.460','0.460','100.00','196000','235000','510870','1075000','1','235000','235000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.460',berat_beli_asli=berat_beli_asli+'0.460',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260828-0004','2026-08-28','2026-08-28','10:17:31','SIN','---','0.460','235000','235000','235000','235000','235000','kasir','2026-08-28 10:17:31','FB-260828-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260828-0004','HARSI','TUMPUK MIRI KISMANTORO','','','','kasir','2026-08-28 10:17:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-28' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260828-0011','K','2026-08-28','10:17:31','kasir','PEMBELIAN UMUM','FB-260828-0004','7076872000','235000','7076637000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020037','X-00020037','KL POLOS 9K','GR','---','H2I','BELI','BELI001','1347000','2026-08-28','1.750','1','kasir','2026-08-28 10:17:31');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020037','X-00020037');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260828-0005','F321210946551','SIN','2','BELI','BELI001','H2I', 'X-00020037', 'KL POLOS 9K','2.070','1.750','100.00','944000','1347000','769714','1135000','1','1347000','1347000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.750',berat_beli_asli=berat_beli_asli+'1.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.750',berat_akhir_asli=berat_akhir_asli+'1.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260828-0005','2026-08-28','2026-08-28','10:17:31','SIN','---','1.750','1347000','1347000','1347000','1347000','1347000','kasir','2026-08-28 10:17:31','FB-260828-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260828-0005','HARSI','TUMPUK MIRI KISMANTORO','','','','kasir','2026-08-28 10:17:31');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-28' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260828-0012','K','2026-08-28','10:17:31','kasir','PEMBELIAN UMUM','FB-260828-0005','7076637000','1347000','7075290000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020038','X-00020038','CC MODEL SPECTRA SLEP KH 13 8K','GR','---','E1F','BELI','BELI001','332000','2026-08-28','0.350','1','kasir','2026-08-28 10:17:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1F','X-00020038','X-00020038');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260828-0006','F326271103111','AAT','1','BELI','BELI001','E1F', 'X-00020038', 'CC MODEL SPECTRA SLEP KH 13 8K','0.350','0.350','100.00','370000','332000','948571','1075000','1','332000','332000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.350',berat_beli_asli=berat_beli_asli+'0.350',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.350',berat_akhir_asli=berat_akhir_asli+'0.350',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1F' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260828-0006','2026-08-28','2026-08-28','10:17:51','AAT','---','0.350','332000','332000','332000','332000','332000','kasir','2026-08-28 10:17:51','FB-260828-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260828-0006','KESYA','BAKALAN PURWANTORO','','','','kasir','2026-08-28 10:17:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-28' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260828-0013','K','2026-08-28','10:17:51','kasir','PEMBELIAN UMUM','FB-260828-0006','7075290000','332000','7074958000');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020039','X-00020039','GW X MODEL SLEP YT 8K','GR','---','B1E','BELI','BELI001','370000','2026-08-28','0.480','1','kasir','2026-08-28 10:25:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00020039','X-00020039');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260828-0007','F325260144231','AAT','1','BELI','BELI001','B1E', 'X-00020039', 'GW X MODEL SLEP YT 8K','0.480','0.480','100.00','395000','370000','770833','1065000','1','370000','370000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.480',berat_beli_asli=berat_beli_asli+'0.480',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.480',berat_akhir_asli=berat_akhir_asli+'0.480',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260828-0007','2026-08-28','2026-08-28','10:25:35','AAT','---','0.480','370000','370000','370000','370000','370000','kasir','2026-08-28 10:25:35','FB-260828-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260828-0007','NARMI','SANGGRONG','','','','kasir','2026-08-28 10:25:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-28' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260828-0014','K','2026-08-28','10:25:35','kasir','PEMBELIAN UMUM','FB-260828-0007','7074958000','370000','7074588000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281028291','kasir','1',' MDA1 XXX U','TOKO','PM-A','A1D-ZFXH-32-0','AT XXX ITALY SLEP VAR UB 8K ','','0.930','1','100.00','963000','0','0','15000','935000','0','0','0','935000','SIN','00407893','A1D','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-ZFXH-32-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.930',berat_jual_asli=berat_jual_asli+'0.930',stock_jual='1',berat_akhir=berat_akhir-'0.930',berat_akhir_asli=berat_akhir_asli-'0.930',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='A1D-ZFXH-32-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-A' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281028291','2026-08-28','0.930','2026-08-28','10:28:30','PLG0031018','935000','935000','0','935000','935000','kasir','2026-08-28 10:28:29','F32628102829');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281028291','2026-08-28','10:28:30','SIN','935000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260828-0015','D','2026-08-28','10:28:30','kasir','PENJUALAN','F326281028291','7074588000','935000','7075523000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281150211','kasir','1',' MDE2 X 5K ','TOKO','PM-E','E2D-ZGAD-16-0','CC X BONEKA ANAK OSROT CAT SLEP LG 8K ','','1.100','1','100.00','1138000','0','0','15000','1138000','0','5000','0','1143000','SIN','00413463','E2D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAD-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='E2D-ZGAD-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281150211','2026-08-28','1.100','2026-08-28','11:50:21','PLG0031019','1138000','1138000','5000','1143000','1143000','kasir','2026-08-28 11:50:21','F32628115021');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281150211','2026-08-28','11:50:21','SIN','1143000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260828-0016','D','2026-08-28','11:50:21','kasir','PENJUALAN','F326281150211','7075523000','1143000','7076666000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1143000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281150211' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281150212','kasir',' 1',' MFD1F X BG','TOKO','PM-D','D1F-YKAC-22-0','LT X SLOBOK HURUF BALOK BG Y 8K ','GT','0.460','1','100.00','494000','0','0','15000','495000','0','30000','0','525000','SIN','00377331','D1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1F-YKAC-22-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.460',berat_jual_asli=berat_jual_asli+'0.460',stock_jual='1',berat_akhir=berat_akhir-'0.460',berat_akhir_asli=berat_akhir_asli-'0.460',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='D1F-YKAC-22-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281150212','2026-08-28','0.460','2026-08-28','11:50:21','PLG0031020','495000','495000','30000','525000','525000','kasir','2026-08-28 11:50:21','F32628115021');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281150212','2026-08-28','11:50:21','SIN','525000','30000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260828-0017','D','2026-08-28','11:50:21','kasir','PENJUALAN','F326281150212','7076666000','525000','7077191000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='525000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281150212' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281150211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281150211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281150211';
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281152531','kasir','1',' MDE2 X 5K ','TOKO','PM-E','E2D-ZGAD-16-0','CC X BONEKA ANAK OSROT CAT SLEP LG 8K ','','1.100','1','100.00','1138000','0','0','15000','1138000','0','5000','0','1143000','SIN','00413463','E2D','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZGAD-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.100',berat_jual_asli=berat_jual_asli+'1.100',stock_jual='1',berat_akhir=berat_akhir-'1.100',berat_akhir_asli=berat_akhir_asli-'1.100',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='E2D-ZGAD-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281152531','2026-08-28','1.100','2026-08-28','11:52:54','PLG0031021','1138000','1138000','5000','1143000','1143000','kasir','2026-08-28 11:52:53','F32628115253');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281152531','2026-08-28','11:52:54','SIN','1143000','5000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260828-0019','D','2026-08-28','11:52:54','kasir','PENJUALAN','F326281152531','7076048000','1143000','7077191000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281228451','kasir','1',' MGS1G DG ','TOKO','PM-S','S1G-ZHAX-324-0','AS EXTENTION DG 8K ','','0.200','1','100.00','219000','0','0','15000','220000','0','0','0','220000','SIN','00418469','S1G','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='S1G-ZHAX-324-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.200',berat_jual_asli=berat_jual_asli+'0.200',stock_jual='1',berat_akhir=berat_akhir-'0.200',berat_akhir_asli=berat_akhir_asli-'0.200',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='S1G-ZHAX-324-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-S' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281228451','2026-08-28','0.200','2026-08-28','12:28:46','PLG0031022','220000','220000','0','220000','220000','kasir','2026-08-28 12:28:45','F32628122845');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281228451','2026-08-28','12:28:46','SIN','220000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260828-0020','D','2026-08-28','12:28:46','kasir','PENJUALAN','F326281228451','7077191000','220000','7077411000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281234131','kasir','1',' MEE2E KH 1','TOKO','PM-E','E2E-ZHBA-199-0','CC MODEL PAKU MATA SLEP KH 16 8K ','','0.410','1','100.00','433000','0','0','15000','433000','0','0','0','433000','SIN','00419778','E2E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZHBA-199-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.410',berat_jual_asli=berat_jual_asli+'0.410',stock_jual='1',berat_akhir=berat_akhir-'0.410',berat_akhir_asli=berat_akhir_asli-'0.410',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='E2E-ZHBA-199-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281234131','2026-08-28','0.410','2026-08-28','12:34:14','PLG0031023','433000','433000','0','433000','433000','kasir','2026-08-28 12:34:13','F32628123413');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281234131','2026-08-28','12:34:14','SIN','433000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260828-0021','D','2026-08-28','12:34:14','kasir','PENJUALAN','F326281234131','7077411000','433000','7077844000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='433000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281234131' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326281234132','kasir',' 1',' MEF3E X UB','TOKO','PM-F','F3E-ZGXG-147-0','GL X BRONET UB 8K ','','0.700','1','100.00','738000','0','0','15000','738000','0','0','0','738000','SIN','00412548','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZGXG-147-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.700',berat_jual_asli=berat_jual_asli+'0.700',stock_jual='1',berat_akhir=berat_akhir-'0.700',berat_akhir_asli=berat_akhir_asli-'0.700',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='F3E-ZGXG-147-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326281234132','2026-08-28','0.700','2026-08-28','12:34:14','PLG0031024','738000','738000','0','738000','738000','kasir','2026-08-28 12:34:13','F32628123413');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326281234132','2026-08-28','12:34:14','SIN','738000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-260828-0022','D','2026-08-28','12:34:14','kasir','PENJUALAN','F326281234132','7077844000','738000','7078582000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='738000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326281234132' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326280123101','kasir','1',' MFE1 KH 12','TOKO','PM-E','E1F-ZHXF-333-0','CC MODEL SLEP KH 12 8K ','OLW','0.360','1','100.00','387000','0','0','15000','391000','0','5000','0','396000','SIN','00417391','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHXF-333-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.360',berat_jual_asli=berat_jual_asli+'0.360',stock_jual='1',berat_akhir=berat_akhir-'0.360',berat_akhir_asli=berat_akhir_asli-'0.360',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='E1F-ZHXF-333-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280123101','2026-08-28','0.360','2026-08-28','13:23:10','PLG0031025','391000','391000','5000','396000','0','kasir','2026-08-28 13:23:10','F32628012310');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326280123101','2026-08-28','13:23:10','SIN','396000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260828-0001','2026-08-28','2026-08-28 13:23:10','PENJUALAN : F326280123101','87654365','BCA','396000','396000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260828-0002','D','2026-08-28','13:23:10','BCA','PENJUALAN','F326280123101','738685000','396000','739081000','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('87654365','8765458765');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='396000' WHERE no_faktur_jual='F326280123101' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326280124021','kasir','1',' MFE1F KH 1','TOKO','PM-E','E1F-ZHBE-312-0','CC MODEL SPECTRA SLEP KH 10 8K ','OLW','0.350','1','100.00','376000','0','0','15000','380000','0','5000','0','385000','SIN','00420354','E1F','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZHBE-312-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.350',berat_jual_asli=berat_jual_asli+'0.350',stock_jual='1',berat_akhir=berat_akhir-'0.350',berat_akhir_asli=berat_akhir_asli-'0.350',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='E1F-ZHBE-312-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280124021','2026-08-28','0.350','2026-08-28','13:24:03','PLG0031026','380000','380000','5000','385000','0','kasir','2026-08-28 13:24:02','F32628012402');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326280124021','2026-08-28','13:24:03','SIN','385000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260828-0002','2026-08-28','2026-08-28 13:24:02','PENJUALAN : F326280124021','87654765','BCA','385000','385000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260828-0003','D','2026-08-28','13:24:03','BCA','PENJUALAN','F326280124021','739081000','385000','739466000','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('87654765','875576');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='385000' WHERE no_faktur_jual='F326280124021' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326280135481','kasir','1',' MEB1 X LG ','TOKO','PM-B','B1E-YLXF-186-0','GW X MODEL MATA LG PE 8K ','','0.550','1','100.00','580000','0','0','15000','580000','0','0','0','580000','FIT','00380002','B1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-YLXF-186-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.550',berat_jual_asli=berat_jual_asli+'0.550',stock_jual='1',berat_akhir=berat_akhir-'0.550',berat_akhir_asli=berat_akhir_asli-'0.550',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='B1E-YLXF-186-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280135481','2026-08-28','0.550','2026-08-28','13:35:49','PLG0031027','580000','580000','0','580000','580000','kasir','2026-08-28 13:35:48','F32628013548');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326280135481','2026-08-28','13:35:49','FIT','580000','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260828-0023','D','2026-08-28','13:35:49','kasir','PENJUALAN','F326280135481','7078582000','580000','7079162000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326280142561','kasir','1',' MEF3 X 20K','TOKO','PM-F','F3E-YLAH-112-0','GL X PREMIER ARESO SLEP UB 8K ','','5.000','1','100.00','5275000','0','0','15000','5275000','0','20000','0','5295000','FIT','00381773','F3E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLAH-112-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.000',berat_jual_asli=berat_jual_asli+'5.000',stock_jual='1',berat_akhir=berat_akhir-'5.000',berat_akhir_asli=berat_akhir_asli-'5.000',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='F3E-YLAH-112-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280142561','2026-08-28','5.000','2026-08-28','13:42:57','PLG0031028','5275000','5275000','20000','5295000','5295000','kasir','2026-08-28 13:42:56','F32628014256');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326280142561','2026-08-28','13:42:57','FIT','5295000','20000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260828-0024','D','2026-08-28','13:42:57','kasir','PENJUALAN','F326280142561','7079162000','5295000','7084457000');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326280157461','input','1',' MEB1E X LG','TOKO','PM-B','B1E-ZGXI-40-0','GW X TIFF MATA VAR LG 8K ','OLW','0.500','1','100.00','527000','0','0','15000','533000','0','5000','0','538000','SIN','00412759','B1E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZGXI-40-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.500',berat_jual_asli=berat_jual_asli+'0.500',stock_jual='1',berat_akhir=berat_akhir-'0.500',berat_akhir_asli=berat_akhir_asli-'0.500',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='B1E-ZGXI-40-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280157461','2026-08-28','0.500','2026-08-28','13:57:47','PLG0031029','533000','533000','5000','538000','0','input','2026-08-28 13:57:46','F32628015746');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326280157461','2026-08-28','13:57:47','SIN','538000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260828-0003','2026-08-28','2026-08-28 13:57:46','PENJUALAN : F326280157461','986565','BCA','538000','538000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260828-0004','D','2026-08-28','13:57:47','BCA','PENJUALAN','F326280157461','739466000','538000','740004000','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('986565','');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='538000' WHERE no_faktur_jual='F326280157461' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,status_otorisasi,harga_skrg) VALUES ('F326280159381','kasir','1',' MED2E X LG','TOKO','PM-D','D2E-ZGAG-77-0','LT X MODEL HURUF MATA LG D 8K ','OLW','0.610','1','100.00','644000','0','0','15000','650000','0','5000','0','655000','SIN','00413913','D2E','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-08-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D2E-ZGAG-77-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.610',berat_jual_asli=berat_jual_asli+'0.610',stock_jual='1',berat_akhir=berat_akhir-'0.610',berat_akhir_asli=berat_akhir_asli-'0.610',stock_akhir='0' WHERE tanggal='2026-08-28' AND kode_barang='D2E-ZGAG-77-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326280159381','2026-08-28','0.610','2026-08-28','13:59:39','PLG0031030','650000','650000','5000','655000','0','kasir','2026-08-28 13:59:38','F32628015938');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-08-28','F326280159381','2026-08-28','13:59:39','SIN','655000','5000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260828-0004','2026-08-28','2026-08-28 13:59:38','PENJUALAN : F326280159381','773589','BCA','655000','655000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260828-0005','D','2026-08-28','13:59:39','BCA','PENJUALAN','F326280159381','740004000','655000','740659000','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('773589','876351571');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='655000' WHERE no_faktur_jual='F326280159381' LIMIT 1;
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00020040','X-00020040','GL SANTA RIBBON SLEP VAR HW 8K','GR','---','F3E','BELI','BELI001','975000','2026-08-28','1.300','1','kasir','2026-08-28 14:06:29');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00020040','X-00020040');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260828-0008','F325180154541','LIS','1','BELI','BELI001','F3E', 'X-00020040', 'GL SANTA RIBBON SLEP VAR HW 8K','1.580','1.300','100.00','1280000','975000','750000','1065000','1','975000','975000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.300',berat_beli_asli=berat_beli_asli+'1.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.300',berat_akhir_asli=berat_akhir_asli+'1.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-08-28' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-260828-0008','2026-08-28','2026-08-28','14:06:29','LIS','---','1.300','975000','975000','975000','975000','975000','kasir','2026-08-28 14:06:29','FB-260828-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260828-0008','DILA','NGROMO NAWANGAN','','','','kasir','2026-08-28 14:06:29');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-08-28' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260828-0025','K','2026-08-28','14:06:29','kasir','PEMBELIAN UMUM','FB-260828-0008','7084457000','975000','7083482000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260828-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260828-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260828-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260828-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260828-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260828-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260828-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260828-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260828-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260828-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260828-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260828-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260828-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260828-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260828-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260828-0008';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280123101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280123101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280123101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280124021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280124021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280124021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280135481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280135481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280135481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280142561' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280142561' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280142561';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280157461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280157461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280157461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280159381' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280159381' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280159381';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280837061' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280837061' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280837061';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280925351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280925351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280925351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326280925352' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326280925352' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326280925352';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281002011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281002011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281002011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281002481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281002481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281002481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281013091' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281013091' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281013091';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281028291' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281028291' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281028291';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281150212' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281150212' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281150212';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281152531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281152531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281152531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281228451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281228451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281228451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281234131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281234131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281234131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326281234132' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326281234132' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326281234132';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-08-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-07-29';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-08-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-08-28';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-08-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-08-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-08-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-08-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-08-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202607 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-07';
UPDATE tt_barang_saldo SET tanggal= '2026-08-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-08-28' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260829-0001','D','2026-08-29','15:10:51','SYSTEM','SALDO AWAL','SALDO AWAL','0','7083482000','7083482000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260829-0001','D','2026-08-29','15:10:51','BCA','SALDO AWAL','SALDO AWAL','0','740659000','740659000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260829-0001','D','2026-08-29','15:10:51','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260829-0001','D','2026-08-29','15:10:51','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-08-29';