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-20261009-0001','1','A1G-ZJXF-273-0','1','0.290','0.290','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1G-ZJXF-273-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1G-ZJXF-273-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-09 08:10:54' WHERE kode_barang='A1G-ZJXF-273-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1G-ZJXF-273-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-10-09 08:10:54','TOKO','PM-A','A1G','A1G-ZJXF-273-0','1','0.290','0.290','1','0.290','0.290','100.00');
DELETE FROM tm_dept WHERE kode_dept='A1G' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='A1G' 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='A1G-ZJXF-273-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1G-ZJXF-273-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-20261009-0001','1','A1E-ZJXH-40-0','1','0.550','0.550','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1E-ZJXH-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1E-ZJXH-40-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-10-09 08:10:54' WHERE kode_barang='A1E-ZJXH-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1E-ZJXH-40-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-10-09 08:10:54','TOKO','PM-A','A1E','A1E-ZJXH-40-0','1','0.550','0.550','1','0.550','0.550','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-ZJXH-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1E-ZJXH-40-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261009-0001','2026-10-09','08:10','0.840','admpindah','2026-10-09 08:10:54');
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-20261009-0001','1','B1E-ZJXH-54-0','1','0.760','0.760','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZJXH-54-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJXH-54-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-09 08:11:19' WHERE kode_barang='B1E-ZJXH-54-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJXH-54-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-10-09 08:11:19','TOKO','PM-B','B1E','B1E-ZJXH-54-0','1','0.760','0.760','1','0.760','0.760','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-ZJXH-54-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJXH-54-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-20261009-0001','1','B1E-ZJXH-55-0','1','0.470','0.470','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZJXH-55-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJXH-55-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-09 08:11:19' WHERE kode_barang='B1E-ZJXH-55-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJXH-55-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-10-09 08:11:19','TOKO','PM-B','B1E','B1E-ZJXH-55-0','1','0.470','0.470','1','0.470','0.470','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-ZJXH-55-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJXH-55-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-20261009-0001','1','B1E-ZJXH-62-0','1','0.610','0.610','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1E-ZJXH-62-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1E-ZJXH-62-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-09 08:11:19' WHERE kode_barang='B1E-ZJXH-62-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1E-ZJXH-62-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-10-09 08:11:19','TOKO','PM-B','B1E','B1E-ZJXH-62-0','1','0.610','0.610','1','0.610','0.610','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-ZJXH-62-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1E-ZJXH-62-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-20261009-0001','1','B1D-ZJXH-63-0','1','1.100','1.100','TOKO','PMBK-B','TOKO','PM-B');
DELETE FROM tm_barang WHERE kode_barang='B1D-ZJXH-63-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='B1D-ZJXH-63-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-B',tgl_last_beli='2026-10-09 08:11:19' WHERE kode_barang='B1D-ZJXH-63-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='B1D-ZJXH-63-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-10-09 08:11:19','TOKO','PM-B','B1D','B1D-ZJXH-63-0','1','1.100','1.100','1','1.100','1.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='B1D' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='B1D' 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='B1D-ZJXH-63-0';
DELETE FROM tm_barang_export WHERE kode_barang='B1D-ZJXH-63-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261009-0001','2026-10-09','08:11','2.940','admpindah','2026-10-09 08:11:18');
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-20261009-0001','1','E2E-ZHCA-65-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZHCA-65-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZHCA-65-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E2E-ZHCA-65-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZHCA-65-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-10-09 08:11:41','TOKO','PM-E','E2E','E2E-ZHCA-65-0','1','0.480','0.480','1','0.480','0.480','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-ZHCA-65-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZHCA-65-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-20261009-0001','1','E1D-ZIBE-182-0','1','1.200','1.200','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZIBE-182-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZIBE-182-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E1D-ZIBE-182-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZIBE-182-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-10-09 08:11:41','TOKO','PM-E','E1D','E1D-ZIBE-182-0','1','1.200','1.200','1','1.200','1.200','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-ZIBE-182-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZIBE-182-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-20261009-0001','1','E1D-ZIBE-191-0','1','1.510','1.510','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZIBE-191-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZIBE-191-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E1D-ZIBE-191-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZIBE-191-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-10-09 08:11:41','TOKO','PM-E','E1D','E1D-ZIBE-191-0','1','1.510','1.510','1','1.510','1.510','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-ZIBE-191-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZIBE-191-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-20261009-0001','1','E1F-ZJXF-322-0','1','0.340','0.340','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXF-322-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXF-322-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E1F-ZJXF-322-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXF-322-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-10-09 08:11:41','TOKO','PM-E','E1F','E1F-ZJXF-322-0','1','0.340','0.340','1','0.340','0.340','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' 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='E1F-ZJXF-322-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXF-322-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-20261009-0001','1','E2E-ZJXH-105-0','1','0.480','0.480','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXH-105-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXH-105-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E2E-ZJXH-105-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXH-105-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-10-09 08:11:41','TOKO','PM-E','E2E','E2E-ZJXH-105-0','1','0.480','0.480','1','0.480','0.480','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-ZJXH-105-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXH-105-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-20261009-0001','1','E2D-ZJXH-122-0','1','1.350','1.350','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXH-122-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-122-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E2D-ZJXH-122-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXH-122-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-10-09 08:11:41','TOKO','PM-E','E2D','E2D-ZJXH-122-0','1','1.350','1.350','1','1.350','1.350','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-ZJXH-122-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-122-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-20261009-0001','1','E2D-ZJXH-124-0','1','0.970','0.970','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXH-124-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-124-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E2D-ZJXH-124-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXH-124-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-10-09 08:11:41','TOKO','PM-E','E2D','E2D-ZJXH-124-0','1','0.970','0.970','1','0.970','0.970','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-ZJXH-124-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-124-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-20261009-0001','1','E2E-ZJXH-125-0','1','0.710','0.710','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXH-125-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXH-125-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E2E-ZJXH-125-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXH-125-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-10-09 08:11:41','TOKO','PM-E','E2E','E2E-ZJXH-125-0','1','0.710','0.710','1','0.710','0.710','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-ZJXH-125-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXH-125-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-20261009-0001','1','E2E-ZJXH-130-0','1','0.670','0.670','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2E-ZJXH-130-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2E-ZJXH-130-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E2E-ZJXH-130-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2E-ZJXH-130-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-10-09 08:11:41','TOKO','PM-E','E2E','E2E-ZJXH-130-0','1','0.670','0.670','1','0.670','0.670','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-ZJXH-130-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2E-ZJXH-130-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-20261009-0001','1','E2D-ZJXH-135-0','1','1.020','1.020','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXH-135-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-135-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E2D-ZJXH-135-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXH-135-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-10-09 08:11:41','TOKO','PM-E','E2D','E2D-ZJXH-135-0','1','1.020','1.020','1','1.020','1.020','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-ZJXH-135-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-135-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-20261009-0001','1','E2D-ZJXH-136-0','1','0.900','0.900','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E2D-ZJXH-136-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-136-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E2D-ZJXH-136-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E2D-ZJXH-136-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-10-09 08:11:41','TOKO','PM-E','E2D','E2D-ZJXH-136-0','1','0.900','0.900','1','0.900','0.900','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-ZJXH-136-0';
DELETE FROM tm_barang_export WHERE kode_barang='E2D-ZJXH-136-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-20261009-0001','1','E1E-ZJXH-141-0','1','0.520','0.520','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1E-ZJXH-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1E-ZJXH-141-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E1E-ZJXH-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1E-ZJXH-141-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-10-09 08:11:41','TOKO','PM-E','E1E','E1E-ZJXH-141-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-ZJXH-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1E-ZJXH-141-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-20261009-0001','1','E1D-ZJXH-163-0','1','1.450','1.450','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZJXH-163-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJXH-163-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E1D-ZJXH-163-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJXH-163-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-10-09 08:11:41','TOKO','PM-E','E1D','E1D-ZJXH-163-0','1','1.450','1.450','1','1.450','1.450','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-ZJXH-163-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJXH-163-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-20261009-0001','1','E1D-ZJXH-164-0','1','1.630','1.630','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZJXH-164-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZJXH-164-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E1D-ZJXH-164-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZJXH-164-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-10-09 08:11:41','TOKO','PM-E','E1D','E1D-ZJXH-164-0','1','1.630','1.630','1','1.630','1.630','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-ZJXH-164-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZJXH-164-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-20261009-0001','1','E1F-ZJXH-179-0','1','0.420','0.420','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1F-ZJXH-179-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1F-ZJXH-179-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-10-09 08:11:41' WHERE kode_barang='E1F-ZJXH-179-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1F-ZJXH-179-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-10-09 08:11:41','TOKO','PM-E','E1F','E1F-ZJXH-179-0','1','0.420','0.420','1','0.420','0.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='E1F' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='E1F' 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='E1F-ZJXH-179-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1F-ZJXH-179-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261009-0001','2026-10-09','08:11','13.650','admpindah','2026-10-09 08:11:41');
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-20261009-0001','1','F1E-ZJXF-201-0','1','3.760','3.760','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F1E-ZJXF-201-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F1E-ZJXF-201-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-10-09 08:12:08' WHERE kode_barang='F1E-ZJXF-201-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F1E-ZJXF-201-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-10-09 08:12:08','TOKO','PM-F','F1E','F1E-ZJXF-201-0','1','3.760','3.760','1','3.760','3.760','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-ZJXF-201-0';
DELETE FROM tm_barang_export WHERE kode_barang='F1E-ZJXF-201-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20261009-0001','2026-10-09','08:11','3.760','admpindah','2026-10-09 08:12:08');
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 ('F326090837351','input','1',' MEB1 X HW ','TOKO','PM-B','B1E-ZJXF-283-0','GW X ITALY SLEP HW 8K ','','0.530','1','100.00','554000','0','0','15000','550000','0','0','0','550000','LIS','00428187','B1E','0','0','-','1','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-ZJXF-283-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-10-09' AND kode_barang='B1E-ZJXF-283-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 ('F326090837351','2026-10-09','0.530','2026-10-09','08:37:36','PLG0031742','550000','550000','0','550000','550000','input','2026-10-09 08:37:35','F32609083735');
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-10-09','F326090837351','2026-10-09','08:37:36','LIS','550000','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-261009-0002','D','2026-10-09','08:37:36','input','PENJUALAN','F326090837351','7769110000','550000','7769660000');
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 ('F326090951041','input','1',' MDA1D X LG','TOKO','PM-A','A1D-YKAG-27-0','AT XX BANGKOK KLIP SLEP LG 8K ','','1.050','1','100.00','1066000','0','0','15000','1065000','0','0','0','1065000','LIS','00377603','A1D','0','0','-','1','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1D-YKAG-27-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.050',berat_jual_asli=berat_jual_asli+'1.050',stock_jual='1',berat_akhir=berat_akhir-'1.050',berat_akhir_asli=berat_akhir_asli-'1.050',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='A1D-YKAG-27-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 ('F326090951041','2026-10-09','1.050','2026-10-09','09:51:04','PLG0031743','1065000','1065000','0','1065000','1065000','input','2026-10-09 09:51:04','F32609095104');
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-10-09','F326090951041','2026-10-09','09:51:04','LIS','1065000','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-261009-0003','D','2026-10-09','09:51:04','input','PENJUALAN','F326090951041','7769660000','1065000','7770725000');
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 ('F326090952101','input','1',' MFPE X CM ','TOKO','PM-P','PEF-ZDAC-6-0','CC X WG WEDDING POLOS CM 18 8K ','','1.970','1','100.00','2078000','0','0','15000','2078000','0','0','0','2078000','SIN','00399176','PEF','0','0','-','0','1065000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PEF-ZDAC-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.970',berat_jual_asli=berat_jual_asli+'1.970',stock_jual='1',berat_akhir=berat_akhir-'1.970',berat_akhir_asli=berat_akhir_asli-'1.970',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='PEF-ZDAC-6-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-P' 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 ('F326090952101','2026-10-09','1.970','2026-10-09','09:52:11','PLG0031744','2078000','2078000','0','2078000','2078000','input','2026-10-09 09:52:10','F32609095210');
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-10-09','F326090952101','2026-10-09','09:52:11','SIN','2078000','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-261009-0004','D','2026-10-09','09:52:11','input','PENJUALAN','F326090952101','7770725000','2078000','7772803000');
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 ('F326091009481','input','1',' MEF3E HW ','TOKO','PM-F','F3E-ZJXE-353-0','GL CASTELI SLEP HW 8K ','','2.000','1','100.00','2070000','0','0','15000','2070000','0','0','0','2070000','AAT','00427844','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZJXE-353-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.000',berat_jual_asli=berat_jual_asli+'2.000',stock_jual='1',berat_akhir=berat_akhir-'2.000',berat_akhir_asli=berat_akhir_asli-'2.000',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='F3E-ZJXE-353-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 ('F326091009481','2026-10-09','2.000','2026-10-09','10:09:48','PLG0031745','2070000','2070000','0','2070000','2070000','input','2026-10-09 10:09:48','F32609100948');
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-10-09','F326091009481','2026-10-09','10:09:48','AAT','2070000','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-261009-0005','D','2026-10-09','10:09:48','input','PENJUALAN','F326091009481','7772803000','2070000','7774873000');
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 ('F326091026041','input','1',' MJH2 X UB ','TOKO','PM-H','H2J-ZGCA-44-0','KL X GUCCI UB 44 9K ','','3.920','1','100.00','4449000','0','0','15000','4450000','0','0','0','4450000','SIN','00416130','H2J','0','0','-','0','1135000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H2J-ZGCA-44-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.920',berat_jual_asli=berat_jual_asli+'3.920',stock_jual='1',berat_akhir=berat_akhir-'3.920',berat_akhir_asli=berat_akhir_asli-'3.920',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='H2J-ZGCA-44-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 ('F326091026041','2026-10-09','3.920','2026-10-09','10:26:04','PLG0031746','4450000','4450000','0','4450000','4450000','input','2026-10-09 10:26:04','F32609102604');
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-10-09','F326091026041','2026-10-09','10:26:04','SIN','4450000','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-261009-0006','D','2026-10-09','10:26:04','input','PENJUALAN','F326091026041','7774873000','4450000','7779323000');
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 ('F326091031521','input','1',' MEE1 KH 14','TOKO','PM-E','E1E-ZJXE-401-0','CC MODEL DAUN SLEP KH 14 8K ','','0.400','1','100.00','414000','0','0','15000','415000','0','0','0','415000','AAT','00427892','E1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-ZJXE-401-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.400',berat_jual_asli=berat_jual_asli+'0.400',stock_jual='1',berat_akhir=berat_akhir-'0.400',berat_akhir_asli=berat_akhir_asli-'0.400',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='E1E-ZJXE-401-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 ('F326091031521','2026-10-09','0.400','2026-10-09','10:31:53','PLG0031747','415000','415000','0','415000','415000','input','2026-10-09 10:31:52','F32609103152');
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-10-09','F326091031521','2026-10-09','10:31:53','AAT','415000','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-261009-0007','D','2026-10-09','10:31:53','input','PENJUALAN','F326091031521','7779323000','415000','7779738000');
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 ('F326091035261','input','1',' MGD1 X BG ','TOKO','PM-D','D1G-YJXB-309-0','LT X SLOBOK HURUF BALOK BG E 8K ','OLW','0.380','1','100.00','408000','0','0','15000','410000','0','5000','0','415000','SIN','00371893','D1G','0','0','-','0','1085000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YJXB-309-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.380',berat_jual_asli=berat_jual_asli+'0.380',stock_jual='1',berat_akhir=berat_akhir-'0.380',berat_akhir_asli=berat_akhir_asli-'0.380',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='D1G-YJXB-309-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326091035261','2026-10-09','0.380','2026-10-09','10:35:26','PLG0031748','410000','410000','5000','415000','415000','input','2026-10-09 10:35:26','F32609103526');
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-10-09','F326091035261','2026-10-09','10:35:26','SIN','415000','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-261009-0008','D','2026-10-09','10:35:26','input','PENJUALAN','F326091035261','7779738000','415000','7780153000');
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 ('F326091058131','input','1',' MDE1 CM 16','TOKO','PM-E','E1D-ZGBA-318-0','CC COR VELG POLOS 16 CM 8K ','','1.500','1','100.00','1522000','0','0','15000','1522000','0','0','0','1522000','FIT','00414800','E1D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1D-ZGBA-318-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-10-09' AND kode_barang='E1D-ZGBA-318-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 ('F326091058131','2026-10-09','1.500','2026-10-09','10:58:13','PLG0031749','1522000','1522000','0','1522000','1522000','input','2026-10-09 10:58:13','F32609105813');
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-10-09','F326091058131','2026-10-09','10:58:13','FIT','1522000','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-261009-0009','D','2026-10-09','10:58:13','input','PENJUALAN','F326091058131','7780153000','1522000','7781675000');
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 ('F326091058321','input','1',' MDE2 10K C','TOKO','PM-E','E2D-ZIXI-108-0','CC WEDDING MATA CM 12 8K ','','1.520','1','100.00','1543000','0','0','15000','1543000','0','10000','0','1553000','FIT','00422646','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIXI-108-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='E2D-ZIXI-108-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 ('F326091058321','2026-10-09','1.520','2026-10-09','10:58:33','PLG0031750','1543000','1543000','10000','1553000','1553000','input','2026-10-09 10:58:32','F32609105832');
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-10-09','F326091058321','2026-10-09','10:58:33','FIT','1553000','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-261009-0010','D','2026-10-09','10:58:33','input','PENJUALAN','F326091058321','7781675000','1553000','7783228000');
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 ('F326091058531','input','1',' MDE2 X SG ','TOKO','PM-E','E2D-YCAH-189-0','CC X MODEL MATA SG 12 8K ','','1.110','1','100.00','1127000','0','0','15000','1128000','0','0','0','1128000','FIT','00343638','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YCAH-189-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.110',berat_jual_asli=berat_jual_asli+'1.110',stock_jual='1',berat_akhir=berat_akhir-'1.110',berat_akhir_asli=berat_akhir_asli-'1.110',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='E2D-YCAH-189-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 ('F326091058531','2026-10-09','1.110','2026-10-09','10:58:54','PLG0031751','1128000','1128000','0','1128000','1128000','input','2026-10-09 10:58:53','F32609105853');
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-10-09','F326091058531','2026-10-09','10:58:54','FIT','1128000','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-261009-0011','D','2026-10-09','10:58:54','input','PENJUALAN','F326091058531','7783228000','1128000','7784356000');
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 ('F326091100451','input','1',' MDE2 10K C','TOKO','PM-E','E2D-ZIBA-274-0','CC WEDDING MATA SLEP CM 12 8K ','','1.520','1','100.00','1543000','0','0','15000','1544000','0','10000','0','1554000','LIS','00424818','E2D','0','0','-','0','1025000');
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 ('F326091102261','input','1',' MDE2 10K C','TOKO','PM-E','E2D-ZIBA-274-0','CC WEDDING MATA SLEP CM 12 8K ','','1.520','1','100.00','1543000','0','0','15000','1544000','0','10000','0','1554000','LIS','00424818','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIBA-274-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='E2D-ZIBA-274-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 ('F326091102261','2026-10-09','1.520','2026-10-09','11:02:27','PLG0031753','1544000','1544000','10000','1554000','1554000','input','2026-10-09 11:02:26','F32609110226');
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-10-09','F326091102261','2026-10-09','11:02:27','LIS','1554000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261009-0012','D','2026-10-09','11:02:27','input','PENJUALAN','F326091102261','7784356000','1554000','7785910000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1554000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326091102261' 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 ('F326091102262','input',' 1',' MDE2 10K C','TOKO','PM-E','E2D-ZIBA-275-0','CC WEDDING MATA SLEP CM 18 8K ','','1.510','1','100.00','1533000','0','0','15000','1533000','0','10000','0','1543000','LIS','00424819','E2D','0','0','-','0','1025000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-ZIBA-275-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.510',berat_jual_asli=berat_jual_asli+'1.510',stock_jual='1',berat_akhir=berat_akhir-'1.510',berat_akhir_asli=berat_akhir_asli-'1.510',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='E2D-ZIBA-275-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 ('F326091102262','2026-10-09','1.510','2026-10-09','11:02:27','PLG0031754','1533000','1533000','10000','1543000','1543000','input','2026-10-09 11:02:26','F32609110226');
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-10-09','F326091102262','2026-10-09','11:02:27','LIS','1543000','10000');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KM-261009-0013','D','2026-10-09','11:02:27','input','PENJUALAN','F326091102262','7785910000','1543000','7787453000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1543000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F326091102262' 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-00020464','X-00020464','CC MODEL C CM 18 8K','GR','---','E1D','BELI','BELI001','990000','2026-10-09','1.050','1','kasir','2026-10-09 11:22:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00020464','X-00020464');
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-261009-0001','F326151255311','SIN','1','BELI','BELI001','E1D', 'X-00020464', 'CC MODEL C CM 18 8K','1.050','1.050','100.00','1115000','990000','942857','1025000','1','990000','990000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.050',berat_beli_asli=berat_beli_asli+'1.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.050',berat_akhir_asli=berat_akhir_asli+'1.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-09' 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-261009-0001','2026-10-09','2026-10-09','11:22:30','SIN','---','1.050','990000','990000','990000','990000','990000','kasir','2026-10-09 11:22:30','FB-261009-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261009-0001','EARL','MIJIL KISMANTORO','','','','kasir','2026-10-09 11:22:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-09' 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-261009-0014','K','2026-10-09','11:22:30','kasir','PEMBELIAN UMUM','FB-261009-0001','7787453000','990000','7786463000');
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-00020465','X-00020465','CC X WEDDING MATA MT 18','GR','---','E2TF','BELI','BELI001','5900000','2026-10-09','3.420','1','kasir','2026-10-09 11:22:59');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TF','X-00020465','X-00020465');
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-261009-0002','F325141008011','SIN','1','BELI','BELI001','E2TF', 'X-00020465', 'CC X WEDDING MATA MT 18','3.420','3.420','100.00','6345000','5900000','1725146','1940000','1','5900000','5900000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.420',berat_beli_asli=berat_beli_asli+'3.420',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.420',berat_akhir_asli=berat_akhir_asli+'3.420',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2TF' 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-261009-0002','2026-10-09','2026-10-09','11:22:59','SIN','---','3.420','5900000','5900000','5900000','5900000','5900000','kasir','2026-10-09 11:22:59','FB-261009-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261009-0002','LIKAH','GADUNGAN KISMANTORO','','','','kasir','2026-10-09 11:22:59');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-09' 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-261009-0015','K','2026-10-09','11:22:59','kasir','PEMBELIAN UMUM','FB-261009-0002','7786463000','5900000','7780563000');
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-00020466','X-00020466','CC X WEDDING MATA CM 20 8K','GR','---','E2D','BELI','BELI001','850000','2026-10-09','0.900','1','kasir','2026-10-09 11:23:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00020466','X-00020466');
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-261009-0003','F326011203321','LIS','1','BELI','BELI001','E2D', 'X-00020466', 'CC X WEDDING MATA CM 20 8K','0.900','0.900','100.00','913000','850000','944444','1025000','1','850000','850000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.900',berat_beli_asli=berat_beli_asli+'0.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.900',berat_akhir_asli=berat_akhir_asli+'0.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-09' 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-261009-0003','2026-10-09','2026-10-09','11:23:40','LIS','---','0.900','850000','850000','850000','850000','850000','kasir','2026-10-09 11:23:40','FB-261009-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261009-0003','KRISTIN','KISMANTORO','','','085291009536','kasir','2026-10-09 11:23:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-09' 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-261009-0016','K','2026-10-09','11:23:40','kasir','PEMBELIAN UMUM','FB-261009-0003','7780563000','850000','7779713000');
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-00020467','X-00020467','CC XXX WEDDING MATA CM 12 8K','GR','---','E2E','BELI','BELI001','717000','2026-10-09','0.750','1','kasir','2026-10-09 11:23:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00020467','X-00020467');
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-261009-0004','F326011203322','LIS','2','BELI','BELI001','E2E', 'X-00020467', 'CC XXX WEDDING MATA CM 12 8K','0.750','0.750','100.00','755000','717000','956000','1045000','1','717000','717000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.750',berat_beli_asli=berat_beli_asli+'0.750',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.750',berat_akhir_asli=berat_akhir_asli+'0.750',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-09' 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-261009-0004','2026-10-09','2026-10-09','11:23:40','LIS','---','0.750','717000','717000','717000','717000','717000','kasir','2026-10-09 11:23:40','FB-261009-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261009-0004','KRISTIN','KISMANTORO','','','085291009536','kasir','2026-10-09 11:23:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-09' 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-261009-0017','K','2026-10-09','11:23:40','kasir','PEMBELIAN UMUM','FB-261009-0004','7779713000','717000','7778996000');
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-00020468','X-00020468','KL SANTA KH 42CM','GR','---','H2I','BELI','BELI001','1580000','2026-10-09','2.030','1','kasir','2026-10-09 11:24:24');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00020468','X-00020468');
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-261009-0005','F322111102542','SIN','1','BELI','BELI001','H2I', 'X-00020468', 'KL SANTA KH 42CM','2.060','2.030','100.00','950000','1580000','778325','1125000','1','1580000','1580000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.030',berat_beli_asli=berat_beli_asli+'2.030',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.030',berat_akhir_asli=berat_akhir_asli+'2.030',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-09' 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-261009-0005','2026-10-09','2026-10-09','11:24:24','SIN','---','2.030','1580000','1580000','1580000','1580000','1580000','kasir','2026-10-09 11:24:24','FB-261009-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261009-0005','SEPTIANA','PAKIS BARU','','','083143130375','kasir','2026-10-09 11:24:24');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-09' 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-261009-0018','K','2026-10-09','11:24:24','kasir','PEMBELIAN UMUM','FB-261009-0005','7778996000','1580000','7777416000');
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-00020469','X-00020469','CC X WEDDING MATA CM 12','GR','---','E2TE','BELI','BELI001','3080000','2026-10-09','2.130','1','kasir','2026-10-09 11:25:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2TE','X-00020469','X-00020469');
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-261009-0006','F322111102541','SIN','1','BELI','BELI001','E2TE', 'X-00020469', 'CC X WEDDING MATA CM 12','2.150','2.130','100.00','1570000','3080000','1446009','1930000','1','3080000','3080000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.130',berat_beli_asli=berat_beli_asli+'2.130',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.130',berat_akhir_asli=berat_akhir_asli+'2.130',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-09' 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-261009-0006','2026-10-09','2026-10-09','11:25:21','SIN','---','2.130','3080000','3080000','3080000','3080000','3080000','kasir','2026-10-09 11:25:21','FB-261009-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261009-0006','SEPTIANA','PAKIS BARU','','','083143130375','kasir','2026-10-09 11:25:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-09' 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-261009-0019','K','2026-10-09','11:25:21','kasir','PEMBELIAN UMUM','FB-261009-0006','7777416000','3080000','7774336000');
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 ('F326091131351','kasir','1',' MEH1 LG 42','TOKO','PM-H','H1E-ZIAF-10-0','KL TIFF HATI VAR LG 42 8K ','','0.980','1','100.00','1014000','0','0','15000','1015000','0','0','0','1015000','SIN','00423845','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZIAF-10-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.980',berat_jual_asli=berat_jual_asli+'0.980',stock_jual='1',berat_akhir=berat_akhir-'0.980',berat_akhir_asli=berat_akhir_asli-'0.980',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='H1E-ZIAF-10-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 ('F326091131351','2026-10-09','0.980','2026-10-09','11:31:35','PLG0031755','1015000','1015000','0','1015000','1015000','kasir','2026-10-09 11:31:35','F32609113135');
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-10-09','F326091131351','2026-10-09','11:31:35','SIN','1015000','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-261009-0020','D','2026-10-09','11:31:35','kasir','PENJUALAN','F326091131351','7774336000','1015000','7775351000');
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-00020470','X-00020470','KL X NORY MATA VAR UB 42 8K','GR','---','H1F','BELI','BELI001','2095000','2026-10-09','2.870','1','kasir','2026-10-09 11:45:10');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00020470','X-00020470');
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-261009-0007','F324291000481','SIN','1','BELI','BELI001','H1F', 'X-00020470', 'KL X NORY MATA VAR UB 42 8K','2.870','2.870','100.00','1823000','2095000','729965','1065000','1','2095000','2095000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.870',berat_beli_asli=berat_beli_asli+'2.870',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.870',berat_akhir_asli=berat_akhir_asli+'2.870',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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-261009-0007','2026-10-09','2026-10-09','11:45:10','SIN','---','2.870','2095000','2095000','2095000','2095000','2095000','kasir','2026-10-09 11:45:10','FB-261009-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261009-0007','SELA','PAKIS BARU PACITAN','','','082142424570','kasir','2026-10-09 11:45:10');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-09' 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-261009-0021','K','2026-10-09','11:45:10','kasir','PEMBELIAN UMUM','FB-261009-0007','7775351000','2095000','7773256000');
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 ('F326090102111','kasir','1',' MEA1E 5K L','TOKO','PM-A','A1E-ZIAH-118-0','AT BONEKA ANAK CAT LG 8K ','','0.560','1','100.00','580000','0','0','15000','580000','0','5000','0','585000','AAT','00424216','A1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-10-09', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='A1E-ZIAH-118-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.560',berat_jual_asli=berat_jual_asli+'0.560',stock_jual='1',berat_akhir=berat_akhir-'0.560',berat_akhir_asli=berat_akhir_asli-'0.560',stock_akhir='0' WHERE tanggal='2026-10-09' AND kode_barang='A1E-ZIAH-118-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 ('F326090102111','2026-10-09','0.560','2026-10-09','13:02:11','PLG0031756','580000','580000','5000','585000','585000','kasir','2026-10-09 13:02:11','F32609010211');
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-10-09','F326090102111','2026-10-09','13:02:11','AAT','585000','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-261009-0022','D','2026-10-09','13:02:11','kasir','PENJUALAN','F326090102111','7773256000','585000','7773841000');
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-00020471','X-00020471','KL X RANTAI HOLLOW KH 42 8K','GR','---','H1E','BELI','BELI001','1992000','2026-10-09','2.060','1','kasir','2026-10-09 14:14:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00020471','X-00020471');
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-261009-0008','F326031051271','LIS','1','BELI','BELI001','H1E', 'X-00020471', 'KL X RANTAI HOLLOW KH 42 8K','2.060','2.060','100.00','2143000','1992000','966990','1045000','1','1992000','1992000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.060',berat_beli_asli=berat_beli_asli+'2.060',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.060',berat_akhir_asli=berat_akhir_asli+'2.060',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-10-09' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1E' LIMIT 1;
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group) VALUES ('FB-261009-0008','2026-10-09','2026-10-09','14:14:05','LIS','---','2.060','1992000','1992000','1992000','1992000','1992000','kasir','2026-10-09 14:14:06','FB-261009-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-261009-0008','SRIYANTI','NGROTO KISMANTORO','','','','kasir','2026-10-09 14:14:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-10-09' 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-261009-0023','K','2026-10-09','14:14:05','kasir','PEMBELIAN UMUM','FB-261009-0008','7773841000','1992000','7771849000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090102111' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090102111' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090102111';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090837351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090837351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090837351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090951041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090951041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090951041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326090952101' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326090952101' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326090952101';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091009481' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091009481' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091009481';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091026041' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091026041' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091026041';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091031521' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091031521' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091031521';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091035261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091035261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091035261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091058131' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091058131' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091058131';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091058321' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091058321' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091058321';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091058531' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091058531' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091058531';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091102261' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091102261' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091102261';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091102262' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091102262' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091102262';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326091131351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326091131351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326091131351';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261009-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261009-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261009-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261009-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261009-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261009-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261009-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261009-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261009-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261009-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261009-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261009-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261009-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261009-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-261009-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-261009-0008';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-09';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-09';
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-10-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-09';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09';
UPDATE tt_barang_saldo SET tanggal= '2026-10-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-09' 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-261010-0001','D','2026-10-10','15:09:43','SYSTEM','SALDO AWAL','SALDO AWAL','0','7771849000','7771849000');
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-261010-0001','D','2026-10-10','15:09:43','BCA','SALDO AWAL','SALDO AWAL','0','743627000','743627000');
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-261010-0001','D','2026-10-10','15:09:43','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-261010-0001','D','2026-10-10','15:09:43','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-10-10';