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-20260620-0001','1','A1E-ZFXC-61-0','1','0.430','0.430','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFXC-61-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFXC-61-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-20 07:55:07' WHERE kode_barang='A1E-ZFXC-61-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFXC-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-06-20 07:55:07','TOKO','PM-A','A1E','A1E-ZFXC-61-0','1','0.430','0.430','1','0.430','0.430','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-ZFXC-61-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFXC-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-20260620-0001','1','A1E-ZFAI-106-0','1','0.750','0.750','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFAI-106-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFAI-106-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-20 07:55:08' WHERE kode_barang='A1E-ZFAI-106-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFAI-106-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-06-20 07:55:08','TOKO','PM-A','A1E','A1E-ZFAI-106-0','1','0.750','0.750','1','0.750','0.750','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-ZFAI-106-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFAI-106-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-20260620-0001','1','A1E-ZFAI-107-0','1','0.520','0.520','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFAI-107-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFAI-107-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-20 07:55:08' WHERE kode_barang='A1E-ZFAI-107-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFAI-107-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-06-20 07:55:08','TOKO','PM-A','A1E','A1E-ZFAI-107-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-ZFAI-107-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFAI-107-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-20260620-0001','1','A1D-ZFAI-108-0','1','0.910','0.910','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZFAI-108-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZFAI-108-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-20 07:55:08' WHERE kode_barang='A1D-ZFAI-108-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZFAI-108-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-06-20 07:55:08','TOKO','PM-A','A1D','A1D-ZFAI-108-0','1','0.910','0.910','1','0.910','0.910','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-ZFAI-108-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZFAI-108-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-20260620-0001','1','A1D-ZFAI-109-0','1','0.970','0.970','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZFAI-109-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZFAI-109-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-20 07:55:08' WHERE kode_barang='A1D-ZFAI-109-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZFAI-109-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-06-20 07:55:08','TOKO','PM-A','A1D','A1D-ZFAI-109-0','1','0.970','0.970','1','0.970','0.970','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-ZFAI-109-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZFAI-109-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260620-0001','2026-06-20','07:55','3.580','admpindah','2026-06-20 07:55:07');
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-20260620-0001','1','B1E-ZFAI-101-0','1','0.530','0.530','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZFAI-101-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZFAI-101-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-06-20 07:55:25' WHERE kode_barang='B1E-ZFAI-101-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZFAI-101-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-06-20 07:55:25','TOKO','PM-B','B1E','B1E-ZFAI-101-0','1','0.530','0.530','1','0.530','0.530','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-ZFAI-101-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZFAI-101-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-20260620-0001','1','B1E-ZFAI-102-0','1','0.520','0.520','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZFAI-102-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZFAI-102-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-06-20 07:55:25' WHERE kode_barang='B1E-ZFAI-102-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZFAI-102-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-06-20 07:55:25','TOKO','PM-B','B1E','B1E-ZFAI-102-0','1','0.520','0.520','1','0.520','0.520','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-ZFAI-102-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZFAI-102-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260620-0001','2026-06-20','07:55','1.050','admpindah','2026-06-20 07:55:24');
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-20260620-0001','1','D1F-ZFAH-25-0','1','0.350','0.350','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1F-ZFAH-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1F-ZFAH-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-06-20 07:55:43' WHERE kode_barang='D1F-ZFAH-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1F-ZFAH-25-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-06-20 07:55:43','TOKO','PM-D','D1F','D1F-ZFAH-25-0','1','0.350','0.350','1','0.350','0.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1F' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MF' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MF' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='D1F-ZFAH-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1F-ZFAH-25-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-20260620-0001','1','D1E-ZFAI-69-0','1','0.610','0.610','TOKO','PMBK-D','TOKO','PM-D');
DELETE FROM tm_barang WHERE kode_barang='D1E-ZFAI-69-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='D1E-ZFAI-69-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-D',tgl_last_beli='2026-06-20 07:55:43' WHERE kode_barang='D1E-ZFAI-69-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='D1E-ZFAI-69-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-06-20 07:55:43','TOKO','PM-D','D1E','D1E-ZFAI-69-0','1','0.610','0.610','1','0.610','0.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='D1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='D1E' 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='D1E-ZFAI-69-0';
DELETE FROM tm_barang_export WHERE kode_barang='D1E-ZFAI-69-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260620-0001','2026-06-20','07:55','0.960','admpindah','2026-06-20 07:55:43');
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-20260620-0001','1','E2E-ZFXI-83-0','1','0.720','0.720','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZFXI-83-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZFXI-83-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E2E-ZFXI-83-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZFXI-83-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-06-20 07:56:01','TOKO','PM-E','E2E','E2E-ZFXI-83-0','1','0.720','0.720','1','0.720','0.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZFXI-83-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZFXI-83-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-20260620-0001','1','E2D-ZFAB-183-0','1','2.150','2.150','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZFAB-183-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZFAB-183-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E2D-ZFAB-183-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZFAB-183-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-06-20 07:56:01','TOKO','PM-E','E2D','E2D-ZFAB-183-0','1','2.150','2.150','1','2.150','2.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-ZFAB-183-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZFAB-183-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-20260620-0001','1','E1E-ZFAI-74-0','1','0.660','0.660','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-74-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-74-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-74-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-74-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-74-0','1','0.660','0.660','1','0.660','0.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-74-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-74-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-20260620-0001','1','E1E-ZFAI-76-0','1','0.670','0.670','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-76-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-76-0','1','0.670','0.670','1','0.670','0.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-76-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-20260620-0001','1','E1E-ZFAI-77-0','1','0.580','0.580','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-77-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-77-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-77-0','1','0.580','0.580','1','0.580','0.580','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-77-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-20260620-0001','1','E1E-ZFAI-78-0','1','0.600','0.600','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-78-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-78-0','1','0.600','0.600','1','0.600','0.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-78-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-20260620-0001','1','E1E-ZFAI-79-0','1','0.570','0.570','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-79-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-79-0','1','0.570','0.570','1','0.570','0.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-79-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-20260620-0001','1','E1E-ZFAI-80-0','1','0.560','0.560','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-80-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-80-0','1','0.560','0.560','1','0.560','0.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-80-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-20260620-0001','1','E1E-ZFAI-81-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-81-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-81-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-81-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-81-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-20260620-0001','1','E1E-ZFAI-82-0','1','0.470','0.470','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-82-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-82-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-82-0','1','0.470','0.470','1','0.470','0.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-82-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-20260620-0001','1','E1E-ZFAI-84-0','1','0.500','0.500','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-84-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-84-0','1','0.500','0.500','1','0.500','0.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-84-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-20260620-0001','1','E1E-ZFAI-86-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-86-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-86-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-86-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-86-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-86-0','1','0.520','0.520','1','0.520','0.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-86-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-86-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-20260620-0001','1','E1E-ZFAI-87-0','1','0.620','0.620','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-87-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-87-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-87-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-87-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-87-0','1','0.620','0.620','1','0.620','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-87-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-87-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-20260620-0001','1','E1E-ZFAI-88-0','1','0.620','0.620','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-88-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-88-0','1','0.620','0.620','1','0.620','0.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-88-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-20260620-0001','1','E1E-ZFAI-90-0','1','0.650','0.650','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-90-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-90-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1E-ZFAI-90-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-90-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-06-20 07:56:01','TOKO','PM-E','E1E','E1E-ZFAI-90-0','1','0.650','0.650','1','0.650','0.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-90-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-90-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-20260620-0001','1','E1D-ZFAI-92-0','1','1.030','1.030','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFAI-92-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFAI-92-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1D-ZFAI-92-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFAI-92-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-06-20 07:56:01','TOKO','PM-E','E1D','E1D-ZFAI-92-0','1','1.030','1.030','1','1.030','1.030','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-ZFAI-92-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFAI-92-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-20260620-0001','1','E1D-ZFAI-94-0','1','1.050','1.050','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFAI-94-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFAI-94-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1D-ZFAI-94-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFAI-94-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-06-20 07:56:01','TOKO','PM-E','E1D','E1D-ZFAI-94-0','1','1.050','1.050','1','1.050','1.050','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-ZFAI-94-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFAI-94-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-20260620-0001','1','E1D-ZFAI-95-0','1','1.100','1.100','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFAI-95-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFAI-95-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E1D-ZFAI-95-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFAI-95-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-06-20 07:56:01','TOKO','PM-E','E1D','E1D-ZFAI-95-0','1','1.100','1.100','1','1.100','1.100','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-ZFAI-95-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFAI-95-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-20260620-0001','1','E2D-ZFAI-98-0','1','0.850','0.850','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZFAI-98-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZFAI-98-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E2D-ZFAI-98-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZFAI-98-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-06-20 07:56:01','TOKO','PM-E','E2D','E2D-ZFAI-98-0','1','0.850','0.850','1','0.850','0.850','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-ZFAI-98-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZFAI-98-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-20260620-0001','1','E2E-ZFAI-99-0','1','0.770','0.770','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZFAI-99-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZFAI-99-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-20 07:56:01' WHERE kode_barang='E2E-ZFAI-99-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZFAI-99-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-06-20 07:56:01','TOKO','PM-E','E2E','E2E-ZFAI-99-0','1','0.770','0.770','1','0.770','0.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='E2E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E2E' 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='E2E-ZFAI-99-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZFAI-99-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260620-0001','2026-06-20','07:55','15.190','admpindah','2026-06-20 07:56:01');
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-20260620-0001','1','F3E-ZDAX-152-0','1','2.220','2.220','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZDAX-152-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZDAX-152-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-20 07:56:29' WHERE kode_barang='F3E-ZDAX-152-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZDAX-152-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-06-20 07:56:29','TOKO','PM-F','F3E','F3E-ZDAX-152-0','1','2.220','2.220','1','2.220','2.220','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-ZDAX-152-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZDAX-152-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-20260620-0001','1','F3E-ZFAB-219-0','1','2.100','2.100','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAB-219-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAB-219-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-20 07:56:29' WHERE kode_barang='F3E-ZFAB-219-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAB-219-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-06-20 07:56:29','TOKO','PM-F','F3E','F3E-ZFAB-219-0','1','2.100','2.100','1','2.100','2.100','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-ZFAB-219-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAB-219-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-20260620-0001','1','F3E-ZFAB-224-0','1','0.620','0.620','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAB-224-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAB-224-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-20 07:56:29' WHERE kode_barang='F3E-ZFAB-224-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAB-224-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-06-20 07:56:29','TOKO','PM-F','F3E','F3E-ZFAB-224-0','1','0.620','0.620','1','0.620','0.620','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-ZFAB-224-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAB-224-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-20260620-0001','1','F3E-ZFAG-119-0','1','1.430','1.430','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-119-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-119-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-20 07:56:29' WHERE kode_barang='F3E-ZFAG-119-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-119-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-06-20 07:56:29','TOKO','PM-F','F3E','F3E-ZFAG-119-0','1','1.430','1.430','1','1.430','1.430','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-ZFAG-119-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-119-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-20260620-0001','1','F3E-ZFAG-149-0','1','1.180','1.180','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAG-149-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-149-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-20 07:56:29' WHERE kode_barang='F3E-ZFAG-149-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAG-149-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-06-20 07:56:29','TOKO','PM-F','F3E','F3E-ZFAG-149-0','1','1.180','1.180','1','1.180','1.180','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-ZFAG-149-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAG-149-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-20260620-0001','1','F3E-ZFAI-116-0','1','1.760','1.760','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAI-116-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAI-116-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-20 07:56:29' WHERE kode_barang='F3E-ZFAI-116-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAI-116-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-06-20 07:56:29','TOKO','PM-F','F3E','F3E-ZFAI-116-0','1','1.760','1.760','1','1.760','1.760','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-ZFAI-116-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAI-116-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-20260620-0001','1','F3E-ZFAI-117-0','1','2.290','2.290','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAI-117-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAI-117-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-20 07:56:29' WHERE kode_barang='F3E-ZFAI-117-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAI-117-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-06-20 07:56:29','TOKO','PM-F','F3E','F3E-ZFAI-117-0','1','2.290','2.290','1','2.290','2.290','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-ZFAI-117-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAI-117-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-20260620-0001','1','F3E-ZFAI-118-0','1','2.090','2.090','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFAI-118-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFAI-118-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-20 07:56:29' WHERE kode_barang='F3E-ZFAI-118-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFAI-118-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-06-20 07:56:29','TOKO','PM-F','F3E','F3E-ZFAI-118-0','1','2.090','2.090','1','2.090','2.090','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-ZFAI-118-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFAI-118-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260620-0001','2026-06-20','07:56','13.690','admpindah','2026-06-20 07:56:29');
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-20260620-0001','1','H1E-ZDBI-180-0','1','1.620','1.620','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZDBI-180-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZDBI-180-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZDBI-180-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZDBI-180-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZDBI-180-0','1','1.620','1.620','1','1.620','1.620','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-ZDBI-180-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZDBI-180-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-20260620-0001','1','H1E-ZFXH-193-0','1','1.020','1.020','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFXH-193-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFXH-193-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZFXH-193-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFXH-193-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZFXH-193-0','1','1.020','1.020','1','1.020','1.020','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-ZFXH-193-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFXH-193-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-20260620-0001','1','H1E-ZFAG-73-0','1','2.050','2.050','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAG-73-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-73-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZFAG-73-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAG-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZFAG-73-0','1','2.050','2.050','1','2.050','2.050','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-ZFAG-73-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-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-20260620-0001','1','H1E-ZFAG-80-0','1','5.010','5.010','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAG-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZFAG-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAG-80-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZFAG-80-0','1','5.010','5.010','1','5.010','5.010','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-ZFAG-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAG-80-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-20260620-0001','1','H1E-ZFAI-110-0','1','1.530','1.530','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAI-110-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-110-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZFAI-110-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAI-110-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZFAI-110-0','1','1.530','1.530','1','1.530','1.530','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-ZFAI-110-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-110-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-20260620-0001','1','H1E-ZFAI-111-0','1','1.550','1.550','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAI-111-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-111-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZFAI-111-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAI-111-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZFAI-111-0','1','1.550','1.550','1','1.550','1.550','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-ZFAI-111-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-111-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-20260620-0001','1','H1E-ZFAI-112-0','1','2.080','2.080','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAI-112-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-112-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZFAI-112-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAI-112-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZFAI-112-0','1','2.080','2.080','1','2.080','2.080','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-ZFAI-112-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-112-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-20260620-0001','1','H1E-ZFAI-113-0','1','2.110','2.110','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAI-113-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-113-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZFAI-113-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAI-113-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZFAI-113-0','1','2.110','2.110','1','2.110','2.110','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-ZFAI-113-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-113-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-20260620-0001','1','H1E-ZFAI-114-0','1','1.860','1.860','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAI-114-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-114-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZFAI-114-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAI-114-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZFAI-114-0','1','1.860','1.860','1','1.860','1.860','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-ZFAI-114-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-114-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-20260620-0001','1','H1E-ZFAI-115-0','1','1.900','1.900','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZFAI-115-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-115-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-06-20 07:56:53' WHERE kode_barang='H1E-ZFAI-115-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZFAI-115-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-06-20 07:56:53','TOKO','PM-H','H1E','H1E-ZFAI-115-0','1','1.900','1.900','1','1.900','1.900','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-ZFAI-115-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZFAI-115-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260620-0001','2026-06-20','07:56','20.730','admpindah','2026-06-20 07:56:53');
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 ('F326200828141','input','1',' TAA0 X DW ','TOKO','PT-A','A0TA-YLBF-57-T','AT X JERSY MRICAN DW 17K ','','1.020','1','100.00','1938000','0','0','15000','1938000','0','0','0','1938000','LIS','T0076227','A0TA','0','0','-','0','1900000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A0TA-YLBF-57-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='A0TA-YLBF-57-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-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 ('F326200828141','2026-06-20','1.020','2026-06-20','08:28:14','PLG0029866','1938000','1938000','0','1938000','1938000','input','2026-06-20 08:28:14','F32620082814');
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-06-20','F326200828141','2026-06-20','08:28:14','LIS','1938000','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-260620-0002','D','2026-06-20','08:28:14','input','PENJUALAN','F326200828141','5762262000','1938000','5764200000');
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 ('F326201013551','kasir','1',' MEE1E LG 1','TOKO','PM-E','E1E-ZFXD-357-0','CC MODEL ISYANA SLEP LG 18 8K ','','0.630','1','100.00','684000','0','0','15000','685000','0','0','0','685000','AAT','00407237','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXD-357-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.630',berat_jual_asli=berat_jual_asli+'0.630',stock_jual='1',berat_akhir=berat_akhir-'0.630',berat_akhir_asli=berat_akhir_asli-'0.630',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E1E-ZFXD-357-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 ('F326201013551','2026-06-20','0.630','2026-06-20','10:13:56','PLG0029867','685000','685000','0','685000','685000','kasir','2026-06-20 10:13:55','F32620101355');
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-06-20','F326201013551','2026-06-20','10:13:56','AAT','685000','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-260620-0003','D','2026-06-20','10:13:56','kasir','PENJUALAN','F326201013551','5764200000','685000','5764885000');
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 ('F326201016571','kasir','1',' MDB1 X HW ','TOKO','PM-B','B1D-ZFXC-70-0','GW X MODE SPECTRA SLEP HW PE 8K ','','1.060','1','100.00','1129000','0','0','15000','1130000','0','0','0','1130000','FIT','00406613','B1D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1D-ZFXC-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.060',berat_jual_asli=berat_jual_asli+'1.060',stock_jual='1',berat_akhir=berat_akhir-'1.060',berat_akhir_asli=berat_akhir_asli-'1.060',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='B1D-ZFXC-70-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 ('F326201016571','2026-06-20','1.060','2026-06-20','10:16:58','PLG0029868','1130000','1130000','0','1130000','1130000','kasir','2026-06-20 10:16:57','F32620101657');
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-06-20','F326201016571','2026-06-20','10:16:58','FIT','1130000','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-260620-0004','D','2026-06-20','10:16:58','kasir','PENJUALAN','F326201016571','5764885000','1130000','5766015000');
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 ('F326201020211','kasir','1',' MEE1E LG 1','TOKO','PM-E','E1E-ZFXD-351-0','CC MODEL ISYANA SLEP LG 14 8K ','','0.530','1','100.00','575000','0','0','15000','575000','0','0','0','575000','SIN','00407231','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZFXD-351-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E1E-ZFXD-351-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 ('F326201020211','2026-06-20','0.530','2026-06-20','10:20:21','PLG0029869','575000','575000','0','575000','575000','kasir','2026-06-20 10:20:21','F32620102021');
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-06-20','F326201020211','2026-06-20','10:20:21','SIN','575000','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-260620-0005','D','2026-06-20','10:20:21','kasir','PENJUALAN','F326201020211','5766015000','575000','5766590000');
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 ('F326201024391','kasir','1',' MEE1 X HK ','TOKO','PM-E','E1E-ZEBE-103-0','CC X MODEL GELOMBANG SLEP HK 10 8K ','','0.550','1','100.00','597000','0','0','15000','598000','0','0','0','598000','LIS','00404802','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZEBE-103-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-06-20' AND kode_barang='E1E-ZEBE-103-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 ('F326201024391','2026-06-20','0.550','2026-06-20','10:24:39','PLG0029870','598000','598000','0','598000','598000','kasir','2026-06-20 10:24:39','F32620102439');
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-06-20','F326201024391','2026-06-20','10:24:39','LIS','598000','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-260620-0006','D','2026-06-20','10:24:39','kasir','PENJUALAN','F326201024391','5766590000','598000','5767188000');
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 ('F326201038551','kasir','1',' MEF3 X HW ','TOKO','PM-F','F3E-ZFXE-270-0','GL X CAPELLA SLEP HW 8K ','','1.550','1','100.00','1682000','0','0','15000','1680000','0','0','0','1680000','AAT','00407522','F3E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFXE-270-0' 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-06-20' AND kode_barang='F3E-ZFXE-270-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 ('F326201038551','2026-06-20','1.550','2026-06-20','10:38:56','PLG0029871','1680000','1680000','0','1680000','1680000','kasir','2026-06-20 10:38:55','F32620103855');
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-06-20','F326201038551','2026-06-20','10:38:56','AAT','1680000','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-260620-0007','D','2026-06-20','10:38:56','kasir','PENJUALAN','F326201038551','5767188000','1680000','5768868000');
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 ('F326201041181','kasir','1',' MEF3 XXX U','TOKO','PM-F','F3E-ZFAG-149-0','GL XXX RANTAI HOLLOW P3 SLEP UB 8K','','1.180','1','100.00','1292000','0','0','15000','1245000','0','0','0','1245000','SIN','00408972','F3E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAG-149-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.180',berat_jual_asli=berat_jual_asli+'1.180',stock_jual='1',berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F3E-ZFAG-149-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 ('F326201041181','2026-06-20','1.180','2026-06-20','10:41:18','PLG0029872','1245000','1245000','0','1245000','1245000','kasir','2026-06-20 10:41:18','F32620104118');
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-06-20','F326201041181','2026-06-20','10:41:18','SIN','1245000','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-260620-0008','D','2026-06-20','10:41:18','kasir','PENJUALAN','F326201041181','5768868000','1245000','5770113000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1245000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201041181' 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 ('F326201041182','kasir',' 1',' MEE1 X LG ','TOKO','PM-E','E1E-ZDBI-106-0','CC X MODEL DAUN SLEP LG 18 8K ','','0.500','1','100.00','542000','0','0','15000','543000','0','0','0','543000','SIN','00401752','E1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZDBI-106-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-06-20' AND kode_barang='E1E-ZDBI-106-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 ('F326201041182','2026-06-20','0.500','2026-06-20','10:41:19','PLG0029873','543000','543000','0','543000','543000','kasir','2026-06-20 10:41:18','F32620104118');
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-06-20','F326201041182','2026-06-20','10:41:19','SIN','543000','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-260620-0009','D','2026-06-20','10:41:19','kasir','PENJUALAN','F326201041182','5770113000','543000','5770656000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201041182' 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-00019430','X-00019430','LT MODEL DAUN SLEP VAR LG 8K','GR','---','D1G','BELI','BELI001','305000','2026-06-20','0.300','1','kasir','2026-06-20 10:48:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1G';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1G','X-00019430','X-00019430');
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-260620-0001','F326271021531','AAT','1','BELI','BELI001','D1G', 'X-00019430', 'LT MODEL DAUN SLEP VAR LG 8K','0.300','0.300','100.00','385000','305000','1016667','1125000','1','305000','305000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.300',berat_beli_asli=berat_beli_asli+'0.300',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.300',berat_akhir_asli=berat_akhir_asli+'0.300',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1G' 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-260620-0001','2026-06-20','2026-06-20','10:48:51','AAT','---','0.300','305000','305000','305000','305000','305000','kasir','2026-06-20 10:48:52','FB-260620-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0001','IIN CINTAMI','MALANG JAWA TIMUR','','','','kasir','2026-06-20 10:48:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0010','K','2026-06-20','10:48:51','kasir','PEMBELIAN UMUM','FB-260620-0001','5770656000','305000','5770351000');
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-00019431','X-00019431','CC X SOLITAIRE MATA LT 14 8K','GR','---','E2D','BELI','BELI001','1160000','2026-06-20','1.490','1','kasir','2026-06-20 10:50:33');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019431','X-00019431');
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-260620-0002','F325060140434','AAT','1','BELI','BELI001','E2D', 'X-00019431', 'CC X SOLITAIRE MATA LT 14 8K','1.490','1.490','100.00','1235000','1160000','778523','1075000','1','1160000','1160000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.490',berat_beli_asli=berat_beli_asli+'1.490',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.490',berat_akhir_asli=berat_akhir_asli+'1.490',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' 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-260620-0002','2026-06-20','2026-06-20','10:50:33','AAT','---','1.490','1160000','1160000','1160000','1160000','1160000','kasir','2026-06-20 10:50:33','FB-260620-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0002','ESTA','BULUKERTO','','','085171119120','kasir','2026-06-20 10:50:33');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0011','K','2026-06-20','10:50:33','kasir','PEMBELIAN UMUM','FB-260620-0002','5770351000','1160000','5769191000');
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-00019432','X-00019432','GW TOGE MRICAN POLOS LG 8K','GR','---','B1H','BELI','BELI001','270000','2026-06-20','0.260','1','kasir','2026-06-20 10:50:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1H','X-00019432','X-00019432');
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-260620-0003','F326231105521','SIN','1','BELI','BELI001','B1H', 'X-00019432', 'GW TOGE MRICAN POLOS LG 8K','0.260','0.260','100.00','315000','270000','1038462','1145000','1','270000','270000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.260',berat_beli_asli=berat_beli_asli+'0.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.260',berat_akhir_asli=berat_akhir_asli+'0.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1H' 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-260620-0003','2026-06-20','2026-06-20','10:50:49','SIN','---','0.260','270000','270000','270000','270000','270000','kasir','2026-06-20 10:50:50','FB-260620-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0003','KLARISA','JAGIR SLOGOHIMO','','','','kasir','2026-06-20 10:50:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0012','K','2026-06-20','10:50:49','kasir','PEMBELIAN UMUM','FB-260620-0003','5769191000','270000','5768921000');
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-00019433','X-00019433','AT X MODEL MATA VAR LG 8K','GR','---','A1E','BELI','BELI001','510000','2026-06-20','0.500','1','kasir','2026-06-20 10:51:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00019433','X-00019433');
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-260620-0004','F326101217581','FIT','1','BELI','BELI001','A1E', 'X-00019433', 'AT X MODEL MATA VAR LG 8K','0.500','0.500','100.00','550000','510000','1020000','1095000','1','510000','510000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.500',berat_beli_asli=berat_beli_asli+'0.500',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.500',berat_akhir_asli=berat_akhir_asli+'0.500',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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-260620-0004','2026-06-20','2026-06-20','10:51:09','FIT','---','0.500','510000','510000','510000','510000','510000','kasir','2026-06-20 10:51:10','FB-260620-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0004','DWI SUSANTI','PLOSO','','','','kasir','2026-06-20 10:51:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0013','K','2026-06-20','10:51:09','kasir','PEMBELIAN UMUM','FB-260620-0004','5768921000','510000','5768411000');
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-00019434','X-00019434','GW TUSUK MRICAN SLEP HK 8K','GR','---','B1H','BELI','BELI001','220000','2026-06-20','0.260','1','kasir','2026-06-20 10:51:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1H';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1H','X-00019434','X-00019434');
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-260620-0005','F325070210092','AAT','1','BELI','BELI001','B1H', 'X-00019434', 'GW TUSUK MRICAN SLEP HK 8K','0.260','0.260','100.00','233000','220000','846154','1145000','1','220000','220000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.260',berat_beli_asli=berat_beli_asli+'0.260',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.260',berat_akhir_asli=berat_akhir_asli+'0.260',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='B1H' 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-260620-0005','2026-06-20','2026-06-20','10:51:23','AAT','---','0.260','220000','220000','220000','220000','220000','kasir','2026-06-20 10:51:24','FB-260620-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0005','WULAN SRI PALUPI','PLOSO PUHPELEM','','','','kasir','2026-06-20 10:51:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0014','K','2026-06-20','10:51:23','kasir','PEMBELIAN UMUM','FB-260620-0005','5768411000','220000','5768191000');
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-00019435','X-00019435','CC MODEL MATA VAR UB 18 8K','GR','---','E2E','BELI','BELI001','547000','2026-06-20','0.700','1','kasir','2026-06-20 10:51:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019435','X-00019435');
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-260620-0006','F325090221381','AAT','1','BELI','BELI001','E2E', 'X-00019435', 'CC MODEL MATA VAR UB 18 8K','0.700','0.700','100.00','590000','547000','781429','1095000','1','547000','547000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260620-0006','2026-06-20','2026-06-20','10:51:39','AAT','---','0.700','547000','547000','547000','547000','547000','kasir','2026-06-20 10:51:40','FB-260620-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0006','WULAN','PLOSO PUHPELEM','','','','kasir','2026-06-20 10:51:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0015','K','2026-06-20','10:51:39','kasir','PEMBELIAN UMUM','FB-260620-0006','5768191000','547000','5767644000');
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-00019436','X-00019436','LT X MODEL MATA UB 8K','GR','---','D2D','BELI','BELI001','1070000','2026-06-20','1.070','1','kasir','2026-06-20 10:52:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2D','X-00019436','X-00019436');
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-260620-0007','F326241038462','FIT','1','BELI','BELI001','D2D', 'X-00019436', 'LT X MODEL MATA UB 8K','1.070','1.070','100.00','1150000','1070000','1000000','1075000','1','1070000','1070000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.070',berat_beli_asli=berat_beli_asli+'1.070',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.070',berat_akhir_asli=berat_akhir_asli+'1.070',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2D' 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-260620-0007','2026-06-20','2026-06-20','10:52:34','FIT','---','1.070','1070000','1070000','1070000','1070000','1070000','kasir','2026-06-20 10:52:35','FB-260620-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0007','ZULFATUN','MIRI KISMANTORO','','','','kasir','2026-06-20 10:52:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0016','K','2026-06-20','10:52:34','kasir','PEMBELIAN UMUM','FB-260620-0007','5767644000','1070000','5766574000');
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-00019437','X-00019437','KL X SANTA KH 44 9K','GR','---','H2I','BELI','BELI001','3235000','2026-06-20','2.960','1','kasir','2026-06-20 10:52:35');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00019437','X-00019437');
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-260620-0008','F326241038461','FIT','2','BELI','BELI001','H2I', 'X-00019437', 'KL X SANTA KH 44 9K','2.960','2.960','100.00','3478000','3235000','1092905','1165000','1','3235000','3235000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.960',berat_beli_asli=berat_beli_asli+'2.960',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.960',berat_akhir_asli=berat_akhir_asli+'2.960',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' 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-260620-0008','2026-06-20','2026-06-20','10:52:34','FIT','---','2.960','3235000','3235000','3235000','3235000','3235000','kasir','2026-06-20 10:52:35','FB-260620-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0008','ZULFATUN','MIRI KISMANTORO','','','','kasir','2026-06-20 10:52:35');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0017','K','2026-06-20','10:52:34','kasir','PEMBELIAN UMUM','FB-260620-0008','5766574000','3235000','5763339000');
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-00019438','X-00019438','GL MODEL FLIK VAR LT 8K','GR','---','F3E','BELI','BELI001','977000','2026-06-20','1.050','1','kasir','2026-06-20 10:53:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019438','X-00019438');
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-260620-0009','F326151219001','SIN','1','BELI','BELI001','F3E', 'X-00019438', 'GL MODEL FLIK VAR LT 8K','1.050','1.050','100.00','1193000','977000','930476','1095000','1','977000','977000','RUSAK');
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-06-20' 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-260620-0009','2026-06-20','2026-06-20','10:53:03','SIN','---','1.050','977000','977000','977000','977000','977000','kasir','2026-06-20 10:53:03','FB-260620-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0009','SILVIA','SUMBER NGUNENG','','','085725121798','kasir','2026-06-20 10:53:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0018','K','2026-06-20','10:53:03','kasir','PEMBELIAN UMUM','FB-260620-0009','5763339000','977000','5762362000');
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-00019439','X-00019439','CC MODEL LINEA SLEP LG 15 8K','GR','---','E1D','BELI','BELI001','450000','2026-06-20','0.450','1','kasir','2026-06-20 10:53:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019439','X-00019439');
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-260620-0010','F326180145531','AAT','1','BELI','BELI001','E1D', 'X-00019439', 'CC MODEL LINEA SLEP LG 15 8K','0.450','0.450','100.00','490000','450000','1000000','1075000','1','450000','450000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.450',berat_beli_asli=berat_beli_asli+'0.450',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.450',berat_akhir_asli=berat_akhir_asli+'0.450',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' 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-260620-0010','2026-06-20','2026-06-20','10:53:21','AAT','---','0.450','450000','450000','450000','450000','450000','kasir','2026-06-20 10:53:21','FB-260620-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0010','SRI WAHYUNI','PUHPELEM','','','','kasir','2026-06-20 10:53:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0019','K','2026-06-20','10:53:21','kasir','PEMBELIAN UMUM','FB-260620-0010','5762362000','450000','5761912000');
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-00019440','X-00019440','CC X MODEL MATA AY 18 8K','GR','---','E2E','BELI','BELI001','720000','2026-06-20','0.770','1','kasir','2026-06-20 10:53:45');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00019440','X-00019440');
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-260620-0011','F325120828051','SIN','1','BELI','BELI001','E2E', 'X-00019440', 'CC X MODEL MATA AY 18 8K','0.770','0.770','100.00','775000','720000','935065','1095000','1','720000','720000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.770',berat_beli_asli=berat_beli_asli+'0.770',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.770',berat_akhir_asli=berat_akhir_asli+'0.770',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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-260620-0011','2026-06-20','2026-06-20','10:53:45','SIN','---','0.770','720000','720000','720000','720000','720000','kasir','2026-06-20 10:53:45','FB-260620-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0011','ANA','TALESAN','','','','kasir','2026-06-20 10:53:45');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0020','K','2026-06-20','10:53:45','kasir','PEMBELIAN UMUM','FB-260620-0011','5761912000','720000','5761192000');
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 ('F326201059331','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZFXI-33-0','CC X METRO MATA LG 20 8K ','','1.020','1','100.00','1086000','0','0','15000','1085000','0','0','0','1085000','LIS','00408100','E2D','0','0','-','1','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXI-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.020',berat_jual_asli=berat_jual_asli+'1.020',stock_jual='1',berat_akhir=berat_akhir-'1.020',berat_akhir_asli=berat_akhir_asli-'1.020',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E2D-ZFXI-33-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 ('F326201059331','2026-06-20','1.020','2026-06-20','10:59:34','PLG0029874','1085000','1085000','0','1085000','1085000','kasir','2026-06-20 10:59:33','F32620105933');
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-06-20','F326201059331','2026-06-20','10:59:34','LIS','1085000','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-260620-0021','D','2026-06-20','10:59:34','kasir','PENJUALAN','F326201059331','5761192000','1085000','5762277000');
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 ('F326201101171','kasir','1',' MEF3E X HW','TOKO','PM-F','F3E-ZEBE-166-0','GL X CAPELLA SLEP HW 8K ','','1.350','1','100.00','1465000','0','0','15000','1465000','0','0','0','1465000','AAT','00404865','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEBE-166-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.350',berat_jual_asli=berat_jual_asli+'1.350',stock_jual='1',berat_akhir=berat_akhir-'1.350',berat_akhir_asli=berat_akhir_asli-'1.350',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F3E-ZEBE-166-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 ('F326201101171','2026-06-20','1.350','2026-06-20','11:01:18','PLG0029875','1465000','1465000','0','1465000','1465000','kasir','2026-06-20 11:01:17','F32620110117');
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-06-20','F326201101171','2026-06-20','11:01:18','AAT','1465000','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-260620-0022','D','2026-06-20','11:01:18','kasir','PENJUALAN','F326201101171','5762277000','1465000','5763742000');
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 ('F326201117471','kasir','1',' MEF2 10K L','TOKO','PM-F','F2E-ZFXA-117-0','GL BONEKA ANAK CAT MATA LG 40 8K ','','2.020','1','100.00','2192000','0','0','15000','2192000','0','10000','0','2202000','AAT','00406285','F2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F2E-ZFXA-117-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.020',berat_jual_asli=berat_jual_asli+'2.020',stock_jual='1',berat_akhir=berat_akhir-'2.020',berat_akhir_asli=berat_akhir_asli-'2.020',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F2E-ZFXA-117-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 ('F326201117471','2026-06-20','2.020','2026-06-20','11:17:47','PLG0029876','2192000','2192000','10000','2202000','2202000','kasir','2026-06-20 11:17:47','F32620111747');
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-06-20','F326201117471','2026-06-20','11:17:47','AAT','2202000','10000');
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-260620-0023','D','2026-06-20','11:17:47','kasir','PENJUALAN','F326201117471','5763742000','2202000','5765944000');
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 ('F326201121451','kasir','1',' MEF1E PM 5','TOKO','PM-F','F1E-ZFXE-194-0','GL OVAL DAUN SLEP PM 54 8K ','','3.060','1','100.00','3320000','0','0','15000','3320000','0','0','0','3320000','SIN','00407446','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXE-194-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F1E-ZFXE-194-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 ('F326201121451','2026-06-20','3.060','2026-06-20','11:21:45','PLG0029877','3320000','3320000','0','3320000','3320000','kasir','2026-06-20 11:21:45','F32620112145');
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-06-20','F326201121451','2026-06-20','11:21:45','SIN','3320000','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-260620-0024','D','2026-06-20','11:21:45','kasir','PENJUALAN','F326201121451','5765944000','3320000','5769264000');
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-00019441','X-00019441','GW TUSUK MODEL MATA VAR LG PE 8K','GR','---','B1E','BELI','BELI001','532000','2026-06-20','0.530','1','kasir','2026-06-20 11:24:01');
DELETE FROM tp_barang WHERE kode_dept = 'X-B1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-B1E','X-00019441','X-00019441');
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-260620-0012','F326010206281','AAT','1','BELI','BELI001','B1E', 'X-00019441', 'GW TUSUK MODEL MATA VAR LG PE 8K','0.530','0.530','100.00','657000','532000','1003774','1095000','1','532000','532000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' 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-260620-0012','2026-06-20','2026-06-20','11:24:01','AAT','---','0.530','532000','532000','532000','532000','532000','kasir','2026-06-20 11:24:01','FB-260620-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0012','SELINA','TENGGER PUHPELEM','','','088983769876','kasir','2026-06-20 11:24:01');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0025','K','2026-06-20','11:24:01','kasir','PEMBELIAN UMUM','FB-260620-0012','5769264000','532000','5768732000');
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-00019442','X-00019442','CC BANGKOK POLOS CM 18','GR','---','E1E','BELI','BELI001','768000','2026-06-20','1.060','1','kasir','2026-06-20 11:29:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019442','X-00019442');
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-260620-0013','F322291051441','SIN','1','BELI','BELI001','E1E', 'X-00019442', 'CC BANGKOK POLOS CM 18','1.060','1.060','100.00','455000','768000','724528','1095000','1','768000','768000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.060',berat_beli_asli=berat_beli_asli+'1.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.060',berat_akhir_asli=berat_akhir_asli+'1.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260620-0013','2026-06-20','2026-06-20','11:29:03','SIN','---','1.060','768000','768000','768000','768000','768000','kasir','2026-06-20 11:29:03','FB-260620-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0013','KINAH','WOTGALIH BAKALAN','','','','kasir','2026-06-20 11:29:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0026','K','2026-06-20','11:29:03','kasir','PEMBELIAN UMUM','FB-260620-0013','5768732000','768000','5767964000');
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-00019443','X-00019443','CC X PIPA MODEL MATA VAR CM 22','GR','---','E2TE','BELI','BELI001','1312000','2026-06-20','1.000','1','kasir','2026-06-20 11:29:03');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00019443','X-00019443');
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-260620-0014','F324270921151','SIN','2','BELI','BELI001','E2TE', 'X-00019443', 'CC X PIPA MODEL MATA VAR CM 22','1.000','1.000','100.00','1020000','1312000','1312000','2000000','1','1312000','1312000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TE' 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-260620-0014','2026-06-20','2026-06-20','11:29:03','SIN','---','1.000','1312000','1312000','1312000','1312000','1312000','kasir','2026-06-20 11:29:03','FB-260620-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0014','WANTI','WOTGALIH','','','','kasir','2026-06-20 11:29:03');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0027','K','2026-06-20','11:29:03','kasir','PEMBELIAN UMUM','FB-260620-0014','5767964000','1312000','5766652000');
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 ('F326201132371','kasir','1',' MEA1E LG ','TOKO','PM-A','A1E-ZFXD-323-0','AT TINDIK BABY LG 8K ','','0.500','1','100.00','542000','0','0','15000','543000','0','0','0','543000','SIN','00407202','A1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZFXD-323-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-06-20' AND kode_barang='A1E-ZFXD-323-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 ('F326201132371','2026-06-20','0.500','2026-06-20','11:32:38','PLG0029878','543000','543000','0','543000','543000','kasir','2026-06-20 11:32:37','F32620113237');
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-06-20','F326201132371','2026-06-20','11:32:38','SIN','543000','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-260620-0028','D','2026-06-20','11:32:38','kasir','PENJUALAN','F326201132371','5766652000','543000','5767195000');
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 ('F326201142181','kasir','1',' MEF1 X YT','TOKO','PM-F','F1E-YECA-12-0','GL X OVAL CD SLEP YT 56 8K ','','6.030','1','100.00','6543000','0','0','15000','6543000','0','0','0','6543000','FIT','00355872','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-YECA-12-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'6.030',berat_jual_asli=berat_jual_asli+'6.030',stock_jual='1',berat_akhir=berat_akhir-'6.030',berat_akhir_asli=berat_akhir_asli-'6.030',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F1E-YECA-12-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 ('F326201142181','2026-06-20','6.030','2026-06-20','11:42:18','PLG0029879','6543000','6543000','0','6543000','6543000','kasir','2026-06-20 11:42:18','F32620114218');
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-06-20','F326201142181','2026-06-20','11:42:18','FIT','6543000','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-260620-0029','D','2026-06-20','11:42:18','kasir','PENJUALAN','F326201142181','5767195000','6543000','5773738000');
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 ('F326201146241','kasir','1',' MFE1 X BG ','TOKO','PM-E','E1F-ZEBH-291-0','CC X MODEL SLEP BG 14 8K ','','0.690','1','100.00','762000','0','0','15000','762000','0','0','0','762000','FIT','00405509','E1F','0','0','-','0','1115000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1F-ZEBH-291-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.690',berat_jual_asli=berat_jual_asli+'0.690',stock_jual='1',berat_akhir=berat_akhir-'0.690',berat_akhir_asli=berat_akhir_asli-'0.690',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E1F-ZEBH-291-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 ('F326201146241','2026-06-20','0.690','2026-06-20','11:46:25','PLG0029880','762000','762000','0','762000','762000','kasir','2026-06-20 11:46:24','F32620114624');
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-06-20','F326201146241','2026-06-20','11:46:25','FIT','762000','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-260620-0030','D','2026-06-20','11:46:25','kasir','PENJUALAN','F326201146241','5773738000','762000','5774500000');
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 ('F326201159021','kasir','1',' MDE2 X LG ','TOKO','PM-E','E2D-ZDAX-225-0','CC X METRO MATA BIRU LG 20 8K ','','1.160','1','100.00','1235000','0','0','15000','1235000','0','10000','0','1245000','LIS','00398995','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZDAX-225-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.160',berat_jual_asli=berat_jual_asli+'1.160',stock_jual='1',berat_akhir=berat_akhir-'1.160',berat_akhir_asli=berat_akhir_asli-'1.160',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E2D-ZDAX-225-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 ('F326201159021','2026-06-20','1.160','2026-06-20','11:59:03','PLG0029881','1235000','1235000','10000','1245000','1245000','kasir','2026-06-20 11:59:02','F32620115902');
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-06-20','F326201159021','2026-06-20','11:59:03','LIS','1245000','10000');
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-260620-0031','D','2026-06-20','11:59:03','kasir','PENJUALAN','F326201159021','5774500000','1245000','5775745000');
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-00019444','X-00019444','AT COR 8K','GR','---','A1F','BELI','BELI001','320000','2026-06-20','0.530','1','kasir','2026-06-20 12:11:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1F','X-00019444','X-00019444');
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-260620-0015','F323030220581','SIN','1','BELI','BELI001','A1F', 'X-00019444', 'AT COR 8K','0.530','0.530','100.00','268000','320000','603774','1115000','1','320000','320000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.530',berat_beli_asli=berat_beli_asli+'0.530',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.530',berat_akhir_asli=berat_akhir_asli+'0.530',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1F' 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-260620-0015','2026-06-20','2026-06-20','12:11:02','SIN','---','0.530','320000','320000','320000','320000','320000','kasir','2026-06-20 12:11:02','FB-260620-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0015','ASIH','KEPYAR','','','','kasir','2026-06-20 12:11:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0032','K','2026-06-20','12:11:02','kasir','PEMBELIAN UMUM','FB-260620-0015','5775745000','320000','5775425000');
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-00019445','X-00019445','GL MODEL FLIK VAR HW 8K','GR','---','F3E','BELI','BELI001','1442000','2026-06-20','1.550','1','kasir','2026-06-20 12:11:23');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00019445','X-00019445');
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-260620-0016','F326190226561','SIN','1','BELI','BELI001','F3E', 'X-00019445', 'GL MODEL FLIK VAR HW 8K','1.550','1.550','100.00','1830000','1442000','930323','1095000','1','1442000','1442000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.550',berat_beli_asli=berat_beli_asli+'1.550',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.550',berat_akhir_asli=berat_akhir_asli+'1.550',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' 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-260620-0016','2026-06-20','2026-06-20','12:11:23','SIN','---','1.550','1442000','1442000','1442000','1442000','1442000','kasir','2026-06-20 12:11:23','FB-260620-0016');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0016','RIRA','JERUK','','','','kasir','2026-06-20 12:11:23');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0033','K','2026-06-20','12:11:23','kasir','PEMBELIAN UMUM','FB-260620-0016','5775425000','1442000','5773983000');
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-00019446','X-00019446','CC BANGKOK SLEP LG 21 8K','GR','---','E1E','BELI','BELI001','415000','2026-06-20','0.460','1','kasir','2026-06-20 12:11:54');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019446','X-00019446');
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-260620-0017','F326160215221','LIS','1','BELI','BELI001','E1E', 'X-00019446', 'CC BANGKOK SLEP LG 21 8K','0.460','0.460','100.00','500000','415000','902174','1095000','1','415000','415000','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-06-20' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1E' 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-260620-0017','2026-06-20','2026-06-20','12:11:54','LIS','---','0.460','415000','415000','415000','415000','415000','kasir','2026-06-20 12:11:54','FB-260620-0017');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0017','ANIK','GAMBIRANOM','','','','kasir','2026-06-20 12:11:54');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0034','K','2026-06-20','12:11:54','kasir','PEMBELIAN UMUM','FB-260620-0017','5773983000','415000','5773568000');
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 ('F326201219371','kasir','1',' MEH1E KH 4','TOKO','PM-H','H1E-ZFXE-245-0','KL KOREA KH 42 8K ','','2.070','1','100.00','2246000','0','0','15000','2245000','0','0','0','2245000','AAT','00407497','H1E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZFXE-245-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.070',berat_jual_asli=berat_jual_asli+'2.070',stock_jual='1',berat_akhir=berat_akhir-'2.070',berat_akhir_asli=berat_akhir_asli-'2.070',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='H1E-ZFXE-245-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 ('F326201219371','2026-06-20','2.070','2026-06-20','12:19:38','PLG0029882','2245000','2245000','0','2245000','2245000','kasir','2026-06-20 12:19:37','F32620121937');
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-06-20','F326201219371','2026-06-20','12:19:38','AAT','2245000','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-260620-0035','D','2026-06-20','12:19:38','kasir','PENJUALAN','F326201219371','5773568000','2245000','5775813000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2245000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201219371' 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 ('F326201219372','kasir',' 1',' MEF3E X UB','TOKO','PM-F','F3E-ZFAB-220-0','GL X LONG LINK UB 8K ','','0.950','1','100.00','1031000','0','0','15000','1030000','0','0','0','1030000','AAT','00408689','F3E','0','0','-','1','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFAB-220-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.950',berat_jual_asli=berat_jual_asli+'0.950',stock_jual='1',berat_akhir=berat_akhir-'0.950',berat_akhir_asli=berat_akhir_asli-'0.950',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F3E-ZFAB-220-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 ('F326201219372','2026-06-20','0.950','2026-06-20','12:19:38','PLG0029883','1030000','1030000','0','1030000','1030000','kasir','2026-06-20 12:19:37','F32620121937');
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-06-20','F326201219372','2026-06-20','12:19:38','AAT','1030000','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-260620-0036','D','2026-06-20','12:19:38','kasir','PENJUALAN','F326201219372','5775813000','1030000','5776843000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1030000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326201219372' 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 ('F326200113261','kasir','1',' MEE2 LG 12','TOKO','PM-E','E2E-ZEBI-68-0','CC MODEL ISYANA SLEP LG 12 8K ','OLW','0.410','1','100.00','445000','0','0','15000','450000','0','5000','0','455000','SIN','00405725','E2E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2E-ZEBI-68-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-06-20' AND kode_barang='E2E-ZEBI-68-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 ('F326200113261','2026-06-20','0.410','2026-06-20','13:13:27','PLG0029884','450000','450000','5000','455000','455000','kasir','2026-06-20 13:13:26','F32620011326');
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-06-20','F326200113261','2026-06-20','13:13:27','SIN','455000','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-260620-0037','D','2026-06-20','13:13:27','kasir','PENJUALAN','F326200113261','5776843000','455000','5777298000');
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 ('F326200151221','kasir','1',' MDE2 CM 16','TOKO','PM-E','E2D-ZFXF-79-0','CC WEDDING MATA CM 16 8K ','','0.830','1','100.00','884000','0','0','15000','885000','0','10000','0','895000','LIS','00407608','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZFXF-79-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.830',berat_jual_asli=berat_jual_asli+'0.830',stock_jual='1',berat_akhir=berat_akhir-'0.830',berat_akhir_asli=berat_akhir_asli-'0.830',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E2D-ZFXF-79-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 ('F326200151221','2026-06-20','0.830','2026-06-20','13:51:22','PLG0029885','885000','885000','10000','895000','895000','kasir','2026-06-20 13:51:22','F32620015122');
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-06-20','F326200151221','2026-06-20','13:51:22','LIS','895000','10000');
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-260620-0038','D','2026-06-20','13:51:22','kasir','PENJUALAN','F326200151221','5777298000','895000','5778193000');
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 ('F326200155331','kasir','1',' MDE2 X YT ','TOKO','PM-E','E2D-ZABH-252-0','CC X MODEL MATA YT 10 8K ','','0.840','1','100.00','895000','0','0','15000','895000','0','0','0','895000','AAT','00387110','E2D','0','0','-','0','1075000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZABH-252-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.840',berat_jual_asli=berat_jual_asli+'0.840',stock_jual='1',berat_akhir=berat_akhir-'0.840',berat_akhir_asli=berat_akhir_asli-'0.840',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='E2D-ZABH-252-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 ('F326200155331','2026-06-20','0.840','2026-06-20','13:55:33','PLG0029886','895000','895000','0','895000','895000','kasir','2026-06-20 13:55:33','F32620015533');
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-06-20','F326200155331','2026-06-20','13:55:33','AAT','895000','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-260620-0039','D','2026-06-20','13:55:33','kasir','PENJUALAN','F326200155331','5778193000','895000','5779088000');
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-00019447','X-00019447','CC X WEDDING POLOS CM 22 8K','GR','---','E1D','BELI','BELI001','2020000','2026-06-20','2.020','1','kasir','2026-06-20 14:00:25');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00019447','X-00019447');
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-260620-0018','F326251156351','AAT','1','BELI','BELI001','E1D', 'X-00019447', 'CC X WEDDING POLOS CM 22 8K','2.020','2.020','100.00','2200000','2020000','1000000','1075000','1','2020000','2020000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.020',berat_beli_asli=berat_beli_asli+'2.020',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.020',berat_akhir_asli=berat_akhir_asli+'2.020',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-06-20' 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-260620-0018','2026-06-20','2026-06-20','14:00:25','AAT','---','2.020','2020000','2020000','2020000','2020000','2020000','kasir','2026-06-20 14:00:25','FB-260620-0018');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260620-0018','SUPARNO','BANGSRI','','','','kasir','2026-06-20 14:00:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-06-20' 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-260620-0040','K','2026-06-20','14:00:25','kasir','PEMBELIAN UMUM','FB-260620-0018','5779088000','2020000','5777068000');
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 ('F326200246471','kasir','1',' MEF1E UB 5','TOKO','PM-F','F1E-ZFXD-347-0','GL OVAL C SLEP UB 52 8K ','','2.220','1','100.00','2409000','0','0','15000','2410000','0','0','0','2410000','AAT','00407227','F1E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXD-347-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.220',berat_jual_asli=berat_jual_asli+'2.220',stock_jual='1',berat_akhir=berat_akhir-'2.220',berat_akhir_asli=berat_akhir_asli-'2.220',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F1E-ZFXD-347-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 ('F326200246471','2026-06-20','2.220','2026-06-20','14:46:47','PLG0029887','2410000','2410000','0','2410000','2410000','kasir','2026-06-20 14:46:47','F32620024647');
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-06-20','F326200246471','2026-06-20','14:46:47','AAT','2410000','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-260620-0041','D','2026-06-20','14:46:47','kasir','PENJUALAN','F326200246471','5777068000','2410000','5779478000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='2410000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326200246471' 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 ('F326200246472','kasir',' 1',' MEF3E X LT','TOKO','PM-F','F3E-ZEXI-148-0','GL X TIFF SPECTRA VAR LT 8K ','','1.500','1','100.00','1627000','0','0','15000','1628000','0','0','0','1628000','AAT','00402969','F3E','0','0','-','0','1095000');
UPDATE tm_barang SET tgl_last_jual='2026-06-20', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZEXI-148-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.500',berat_jual_asli=berat_jual_asli+'1.500',stock_jual='1',berat_akhir=berat_akhir-'1.500',berat_akhir_asli=berat_akhir_asli-'1.500',stock_akhir='0' WHERE tanggal='2026-06-20' AND kode_barang='F3E-ZEXI-148-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 ('F326200246472','2026-06-20','1.500','2026-06-20','14:46:47','PLG0029888','1628000','1628000','0','1628000','1628000','kasir','2026-06-20 14:46:47','F32620024647');
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-06-20','F326200246472','2026-06-20','14:46:47','AAT','1628000','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-260620-0042','D','2026-06-20','14:46:47','kasir','PENJUALAN','F326200246472','5779478000','1628000','5781106000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1628000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326200246472' LIMIT 1;
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0015';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0016';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0017' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0017';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260620-0018' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260620-0018';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200113261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200113261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200113261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200151221' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200151221' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200151221';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200155331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200155331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200155331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200246471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200246471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200246471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200246472' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200246472' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200246472';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326200828141' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326200828141' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326200828141';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201013551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201013551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201013551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201016571' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201016571' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201016571';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201020211' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201020211' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201020211';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201024391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201024391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201024391';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201038551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201038551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201038551';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201041181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201041181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201041181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201041182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201041182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201041182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201059331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201059331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201059331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201101171' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201101171' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201101171';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201117471' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201117471' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201117471';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201121451' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201121451' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201121451';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201132371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201132371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201132371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201142181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201142181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201142181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201146241' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201146241' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201146241';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201159021' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201159021' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201159021';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201219371' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201219371' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201219371';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326201219372' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326201219372' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326201219372';
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260620-0001','1','F3E-ZEXA-9-0','1','1.930','1.930','TOKO','PM-F','TOKO','SBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBK-F' WHERE kode_barang='F3E-ZEXA-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-20','TOKO','SBK-F','F3E','F3E-ZEXA-9-0','100.00','1','1.930','1.930','1','1.930','1.930');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.930',berat_out_asli=berat_out_asli+'1.930',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-20' AND kode_barang='F3E-ZEXA-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260620-0001','2026-06-20','2026-06-20','15:03','1.93','input','2026-06-20 15:03:55');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-20';
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-06-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-20' 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-260621-0001','D','2026-06-21','15:15:36','SYSTEM','SALDO AWAL','SALDO AWAL','0','5781106000','5781106000');
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-260621-0001','D','2026-06-21','15:15:36','BCA','SALDO AWAL','SALDO AWAL','0','732522000','732522000');
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-260621-0001','D','2026-06-21','15:15:36','DLL','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-260621-0001','D','2026-06-21','15:15:36','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-06-21';
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-20260621-0001','1','A1E-ZFBX-516-0','1','0.650','0.650','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFBX-516-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-516-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-21 16:45:02' WHERE kode_barang='A1E-ZFBX-516-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFBX-516-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-06-21 16:45:02','TOKO','PM-A','A1E','A1E-ZFBX-516-0','1','0.650','0.650','1','0.650','0.650','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-ZFBX-516-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-516-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-20260621-0001','1','A1E-ZFBX-517-0','1','0.520','0.520','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFBX-517-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-517-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-21 16:45:02' WHERE kode_barang='A1E-ZFBX-517-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFBX-517-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-06-21 16:45:02','TOKO','PM-A','A1E','A1E-ZFBX-517-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-ZFBX-517-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-517-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-20260621-0001','1','A1E-ZFBX-518-0','1','0.600','0.600','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFBX-518-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-518-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-21 16:45:02' WHERE kode_barang='A1E-ZFBX-518-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFBX-518-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-06-21 16:45:02','TOKO','PM-A','A1E','A1E-ZFBX-518-0','1','0.600','0.600','1','0.600','0.600','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-ZFBX-518-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-518-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-20260621-0001','1','A1D-ZFBX-519-0','1','0.830','0.830','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1D-ZFBX-519-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1D-ZFBX-519-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-21 16:45:02' WHERE kode_barang='A1D-ZFBX-519-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1D-ZFBX-519-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-06-21 16:45:02','TOKO','PM-A','A1D','A1D-ZFBX-519-0','1','0.830','0.830','1','0.830','0.830','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1D' 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='A1D-ZFBX-519-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1D-ZFBX-519-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-20260621-0001','1','A1E-ZFBX-520-0','1','0.480','0.480','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFBX-520-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-520-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-21 16:45:02' WHERE kode_barang='A1E-ZFBX-520-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFBX-520-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-06-21 16:45:02','TOKO','PM-A','A1E','A1E-ZFBX-520-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-ZFBX-520-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-520-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-20260621-0001','1','A1E-ZFBX-521-0','1','0.570','0.570','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZFBX-521-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-521-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-06-21 16:45:02' WHERE kode_barang='A1E-ZFBX-521-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZFBX-521-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-06-21 16:45:02','TOKO','PM-A','A1E','A1E-ZFBX-521-0','1','0.570','0.570','1','0.570','0.570','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-ZFBX-521-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZFBX-521-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260621-0001','2026-06-21','16:44','3.650','admpindah','2026-06-20 16:45:01');
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-20260621-0001','1','E1D-ZFAH-154-0','1','0.950','0.950','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZFAH-154-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZFAH-154-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-21 16:45:19' WHERE kode_barang='E1D-ZFAH-154-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZFAH-154-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-06-21 16:45:19','TOKO','PM-E','E1D','E1D-ZFAH-154-0','1','0.950','0.950','1','0.950','0.950','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-ZFAH-154-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZFAH-154-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-20260621-0001','1','E1E-ZFAH-171-0','1','0.410','0.410','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAH-171-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAH-171-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-21 16:45:19' WHERE kode_barang='E1E-ZFAH-171-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAH-171-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-06-21 16:45:19','TOKO','PM-E','E1E','E1E-ZFAH-171-0','1','0.410','0.410','1','0.410','0.410','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAH-171-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAH-171-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-20260621-0001','1','E1E-ZFAI-20-0','1','0.630','0.630','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-20-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-21 16:45:19' WHERE kode_barang='E1E-ZFAI-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-20-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-06-21 16:45:19','TOKO','PM-E','E1E','E1E-ZFAI-20-0','1','0.630','0.630','1','0.630','0.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-20-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-20260621-0001','1','E1E-ZFAI-25-0','1','0.550','0.550','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZFAI-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-25-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-06-21 16:45:19' WHERE kode_barang='E1E-ZFAI-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZFAI-25-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-06-21 16:45:19','TOKO','PM-E','E1E','E1E-ZFAI-25-0','1','0.550','0.550','1','0.550','0.550','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1E' 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='E1E-ZFAI-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZFAI-25-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260621-0001','2026-06-21','16:45','2.540','admpindah','2026-06-20 16:45:19');
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-20260621-0001','1','F3E-ZFXH-159-0','1','1.370','1.370','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZFXH-159-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZFXH-159-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-21 16:45:35' WHERE kode_barang='F3E-ZFXH-159-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZFXH-159-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-06-21 16:45:35','TOKO','PM-F','F3E','F3E-ZFXH-159-0','1','1.370','1.370','1','1.370','1.370','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-ZFXH-159-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZFXH-159-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-20260621-0001','1','F1E-ZFAB-199-0','1','1.800','1.800','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZFAB-199-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZFAB-199-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-06-21 16:45:35' WHERE kode_barang='F1E-ZFAB-199-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZFAB-199-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-06-21 16:45:35','TOKO','PM-F','F1E','F1E-ZFAB-199-0','1','1.800','1.800','1','1.800','1.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='F1E' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='F1E' 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='F1E-ZFAB-199-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZFAB-199-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260621-0001','2026-06-21','16:45','3.170','admpindah','2026-06-20 16:45:35');
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-20260621-0001','1','S1G-ZFBX-522-0','1','0.200','0.200','TOKO','PMBK-S','TOKO','PM-S');
DELETE FROM tm_barang WHERE kode_barang='S1G-ZFBX-522-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='S1G-ZFBX-522-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-S',tgl_last_beli='2026-06-21 16:45:51' WHERE kode_barang='S1G-ZFBX-522-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='S1G-ZFBX-522-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-06-21 16:45:51','TOKO','PM-S','S1G','S1G-ZFBX-522-0','1','0.200','0.200','1','0.200','0.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='S1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='S1G' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='MG' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='MG' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='S1G-ZFBX-522-0';
DELETE FROM tm_barang_export WHERE kode_barang='S1G-ZFBX-522-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260621-0001','2026-06-21','16:45','0.200','admpindah','2026-06-20 16:45:51');