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-20260716-0001','1','A1G-ZGAE-76-0','1','0.230','0.230','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1G-ZGAE-76-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1G-ZGAE-76-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-07-16 07:56:38' WHERE kode_barang='A1G-ZGAE-76-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1G-ZGAE-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-07-16 07:56:38','TOKO','PM-A','A1G','A1G-ZGAE-76-0','1','0.230','0.230','1','0.230','0.230','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-ZGAE-76-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1G-ZGAE-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-20260716-0001','1','A1G-ZGAE-77-0','1','0.250','0.250','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1G-ZGAE-77-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1G-ZGAE-77-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-07-16 07:56:38' WHERE kode_barang='A1G-ZGAE-77-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1G-ZGAE-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-07-16 07:56:38','TOKO','PM-A','A1G','A1G-ZGAE-77-0','1','0.250','0.250','1','0.250','0.250','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-ZGAE-77-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1G-ZGAE-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-20260716-0001','1','A1G-ZGAE-78-0','1','0.250','0.250','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1G-ZGAE-78-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1G-ZGAE-78-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-07-16 07:56:38' WHERE kode_barang='A1G-ZGAE-78-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1G-ZGAE-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-07-16 07:56:38','TOKO','PM-A','A1G','A1G-ZGAE-78-0','1','0.250','0.250','1','0.250','0.250','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-ZGAE-78-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1G-ZGAE-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-20260716-0001','1','A1G-ZGAE-79-0','1','0.260','0.260','TOKO','PMBK-A','TOKO','PM-A');
DELETE FROM tm_barang WHERE kode_barang='A1G-ZGAE-79-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='A1G-ZGAE-79-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-A',tgl_last_beli='2026-07-16 07:56:38' WHERE kode_barang='A1G-ZGAE-79-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='A1G-ZGAE-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-07-16 07:56:38','TOKO','PM-A','A1G','A1G-ZGAE-79-0','1','0.260','0.260','1','0.260','0.260','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-ZGAE-79-0';
DELETE FROM tm_barang_export WHERE kode_barang='A1G-ZGAE-79-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260716-0001','2026-07-16','07:56','0.990','admpindah','2026-07-16 07:56:38');
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-20260716-0001','1','E1D-ZGXG-88-0','1','1.100','1.100','TOKO','PMBK-E','TOKO','PM-E');
DELETE FROM tm_barang WHERE kode_barang='E1D-ZGXG-88-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='E1D-ZGXG-88-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-E',tgl_last_beli='2026-07-16 07:56:59' WHERE kode_barang='E1D-ZGXG-88-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='E1D-ZGXG-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-07-16 07:56:59','TOKO','PM-E','E1D','E1D-ZGXG-88-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-ZGXG-88-0';
DELETE FROM tm_barang_export WHERE kode_barang='E1D-ZGXG-88-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260716-0001','2026-07-16','07:56','1.100','admpindah','2026-07-16 07:56:58');
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-20260716-0001','1','F3E-ZGXI-92-0','1','3.100','3.100','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGXI-92-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGXI-92-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-16 07:57:15' WHERE kode_barang='F3E-ZGXI-92-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGXI-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-07-16 07:57:15','TOKO','PM-F','F3E','F3E-ZGXI-92-0','1','3.100','3.100','1','3.100','3.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-ZGXI-92-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGXI-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-20260716-0001','1','F3E-ZGAE-83-0','1','1.580','1.580','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGAE-83-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGAE-83-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-16 07:57:15' WHERE kode_barang='F3E-ZGAE-83-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGAE-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-07-16 07:57:15','TOKO','PM-F','F3E','F3E-ZGAE-83-0','1','1.580','1.580','1','1.580','1.580','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-ZGAE-83-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGAE-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-20260716-0001','1','F3E-ZGAE-84-0','1','1.640','1.640','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGAE-84-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGAE-84-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-16 07:57:15' WHERE kode_barang='F3E-ZGAE-84-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGAE-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-07-16 07:57:15','TOKO','PM-F','F3E','F3E-ZGAE-84-0','1','1.640','1.640','1','1.640','1.640','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-ZGAE-84-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGAE-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-20260716-0001','1','F3E-ZGAE-85-0','1','1.100','1.100','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGAE-85-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGAE-85-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-16 07:57:15' WHERE kode_barang='F3E-ZGAE-85-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGAE-85-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-07-16 07:57:15','TOKO','PM-F','F3E','F3E-ZGAE-85-0','1','1.100','1.100','1','1.100','1.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-ZGAE-85-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGAE-85-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-20260716-0001','1','F3E-ZGAE-86-0','1','1.680','1.680','TOKO','PMBK-F','TOKO','PM-F');
DELETE FROM tm_barang WHERE kode_barang='F3E-ZGAE-86-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='F3E-ZGAE-86-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-F',tgl_last_beli='2026-07-16 07:57:15' WHERE kode_barang='F3E-ZGAE-86-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='F3E-ZGAE-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-07-16 07:57:15','TOKO','PM-F','F3E','F3E-ZGAE-86-0','1','1.680','1.680','1','1.680','1.680','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-ZGAE-86-0';
DELETE FROM tm_barang_export WHERE kode_barang='F3E-ZGAE-86-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260716-0001','2026-07-16','07:57','9.100','admpindah','2026-07-16 07:57:15');
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-20260716-0001','1','H1E-ZGAE-80-0','1','2.030','2.030','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGAE-80-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGAE-80-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-16 07:57:36' WHERE kode_barang='H1E-ZGAE-80-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGAE-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-07-16 07:57:36','TOKO','PM-H','H1E','H1E-ZGAE-80-0','1','2.030','2.030','1','2.030','2.030','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-ZGAE-80-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGAE-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-20260716-0001','1','H1E-ZGAE-81-0','1','1.520','1.520','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGAE-81-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGAE-81-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-16 07:57:36' WHERE kode_barang='H1E-ZGAE-81-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGAE-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-07-16 07:57:36','TOKO','PM-H','H1E','H1E-ZGAE-81-0','1','1.520','1.520','1','1.520','1.520','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-ZGAE-81-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGAE-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-20260716-0001','1','H1E-ZGAE-82-0','1','1.560','1.560','TOKO','PMBK-H','TOKO','PM-H');
DELETE FROM tm_barang WHERE kode_barang='H1E-ZGAE-82-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='H1E-ZGAE-82-0' LIMIT 1;
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PM-H',tgl_last_beli='2026-07-16 07:57:36' WHERE kode_barang='H1E-ZGAE-82-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='H1E-ZGAE-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-07-16 07:57:36','TOKO','PM-H','H1E','H1E-ZGAE-82-0','1','1.560','1.560','1','1.560','1.560','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-ZGAE-82-0';
DELETE FROM tm_barang_export WHERE kode_barang='H1E-ZGAE-82-0';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260716-0001','2026-07-16','07:57','5.110','admpindah','2026-07-16 07:57:36');
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 ('F326161026151','input','1',' MEH1 X UB ','TOKO','PM-H','H1E-ZCCX-358-0','KL X MILANO ANAK UB 34 8K','','3.030','1','100.00','3136000','0','0','15000','3136000','0','0','0','3136000','LIS','00397012','H1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1E-ZCCX-358-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.030',berat_jual_asli=berat_jual_asli+'3.030',stock_jual='1',berat_akhir=berat_akhir-'3.030',berat_akhir_asli=berat_akhir_asli-'3.030',stock_akhir='0' WHERE tanggal='2026-07-16' AND kode_barang='H1E-ZCCX-358-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 ('F326161026151','2026-07-16','3.030','2026-07-16','10:26:15','PLG0030332','3136000','3136000','0','3136000','3136000','input','2026-07-16 10:26:15','F32616102615');
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-07-16','F326161026151','2026-07-16','10:26:15','LIS','3136000','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-260716-0002','D','2026-07-16','10:26:15','input','PENJUALAN','F326161026151','6353907000','3136000','6357043000');
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 ('F326161029391','input','1',' MEF1 X 30K','TOKO','PM-F','F1E-ZFXE-277-0','GL X BANGKOK HOLLOW SLEP PM 60 8K ','','9.860','1','100.00','10205000','0','0','15000','10205000','0','30000','0','10235000','SIN','00407529','F1E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F1E-ZFXE-277-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'9.860',berat_jual_asli=berat_jual_asli+'9.860',stock_jual='1',berat_akhir=berat_akhir-'9.860',berat_akhir_asli=berat_akhir_asli-'9.860',stock_akhir='0' WHERE tanggal='2026-07-16' AND kode_barang='F1E-ZFXE-277-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 ('F326161029391','2026-07-16','9.860','2026-07-16','10:29:40','PLG0030333','10205000','10205000','30000','10235000','10235000','input','2026-07-16 10:29:39','F32616102939');
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-07-16','F326161029391','2026-07-16','10:29:40','SIN','10235000','30000');
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-260716-0003','D','2026-07-16','10:29:40','input','PENJUALAN','F326161029391','6357043000','10235000','6367278000');
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-00019653','X-00019653','GL COR T 8K','GR','---','F1E','BELI','BELI001','9780000','2026-07-16','9.850','1','kasir','2026-07-16 12:41:21');
DELETE FROM tp_barang WHERE kode_dept = 'X-F1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F1E','X-00019653','X-00019653');
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-260716-0001','00408662','SIN','1','BELI','BELI001','F1E', 'X-00019653', 'GL COR T 8K','9.850','9.850','100.00','10440000','9780000','992893','1045000','1','9780000','9780000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'9.850',berat_beli_asli=berat_beli_asli+'9.850',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'9.850',berat_akhir_asli=berat_akhir_asli+'9.850',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F1E' 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-260716-0001','2026-07-16','2026-07-16','12:41:21','SIN','---','9.850','9780000','9780000','9780000','9780000','9780000','kasir','2026-07-16 12:41:21','FB-260716-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260716-0001','BU TARTIN','BULUKERTO','','','','kasir','2026-07-16 12:41:21');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-16' 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-260716-0004','K','2026-07-16','12:41:21','kasir','PEMBELIAN UMUM','FB-260716-0001','6367278000','9780000','6357498000');
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-00019654','X-00019654','KL X NORI SEMI KH 48 8K','GR','---','H1E','BELI','BELI001','5665000','2026-07-16','5.830','1','kasir','2026-07-16 12:43:55');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1E','X-00019654','X-00019654');
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-260716-0002','F326260110111','FIT','1','BELI','BELI001','H1E', 'X-00019654', 'KL X NORI SEMI KH 48 8K','5.830','5.830','100.00','7288000','5665000','971698','1045000','1','5665000','5665000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'5.830',berat_beli_asli=berat_beli_asli+'5.830',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'5.830',berat_akhir_asli=berat_akhir_asli+'5.830',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-16' 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-260716-0002','2026-07-16','2026-07-16','12:43:55','FIT','---','5.830','5665000','5665000','5665000','5665000','5665000','kasir','2026-07-16 12:43:55','FB-260716-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260716-0002','MAMA ALIYA','BULUKERTO','','','','kasir','2026-07-16 12:43:55');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-16' 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-260716-0005','K','2026-07-16','12:43:55','kasir','PEMBELIAN UMUM','FB-260716-0002','6357498000','5665000','6351833000');
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-00019655','X-00019655','KL X NORY MATA VAR UB 42 8K','GR','---','H1F','BELI','BELI001','2200000','2026-07-16','3.050','1','kasir','2026-07-16 12:45:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00019655','X-00019655');
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-260716-0003','F325160312171','FIT','1','BELI','BELI001','H1F', 'X-00019655', 'KL X NORY MATA VAR UB 42 8K','3.050','3.050','100.00','2585000','2200000','721311','1055000','1','2200000','2200000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.050',berat_beli_asli=berat_beli_asli+'3.050',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.050',berat_akhir_asli=berat_akhir_asli+'3.050',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-16' 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-260716-0003','2026-07-16','2026-07-16','12:45:11','FIT','---','3.050','2200000','2200000','2200000','2200000','2200000','kasir','2026-07-16 12:45:12','FB-260716-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260716-0003','SUCI ANTIKA','NJERUK BANDAR','','','','kasir','2026-07-16 12:45:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-16' 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-260716-0006','K','2026-07-16','12:45:11','kasir','PEMBELIAN UMUM','FB-260716-0003','6351833000','2200000','6349633000');
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-00019656','X-00019656','CC X MODEL MATA CM 18 8K','GR','---','E2D','BELI','BELI001','1135000','2026-07-16','1.190','1','kasir','2026-07-16 12:45:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00019656','X-00019656');
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-260716-0004','F326251101391','LIS','1','BELI','BELI001','E2D', 'X-00019656', 'CC X MODEL MATA CM 18 8K','1.190','1.190','100.00','1345000','1135000','953782','1025000','1','1135000','1135000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.190',berat_beli_asli=berat_beli_asli+'1.190',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.190',berat_akhir_asli=berat_akhir_asli+'1.190',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-07-16' 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-260716-0004','2026-07-16','2026-07-16','12:45:37','LIS','---','1.190','1135000','1135000','1135000','1135000','1135000','kasir','2026-07-16 12:45:38','FB-260716-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260716-0004','DEWI LESTARI','KANTHI DOMAS BULUKERTO','','','','kasir','2026-07-16 12:45:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-16' 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-260716-0007','K','2026-07-16','12:45:37','kasir','PEMBELIAN UMUM','FB-260716-0004','6349633000','1135000','6348498000');
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-00019657','X-00019657','CC MODEL SLEP VAR HW 13 8K','GR','---','E1E','BELI','BELI001','432000','2026-07-16','0.450','1','kasir','2026-07-16 13:18:00');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1E','X-00019657','X-00019657');
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-260716-0005','F326230858361','AAT','1','BELI','BELI001','E1E', 'X-00019657', 'CC MODEL SLEP VAR HW 13 8K','0.450','0.450','100.00','518000','432000','960000','1045000','1','432000','432000','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-07-16' 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-260716-0005','2026-07-16','2026-07-16','13:17:59','AAT','---','0.450','432000','432000','432000','432000','432000','kasir','2026-07-16 13:18:00','FB-260716-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260716-0005','TANIA','BUGELAN KISMANTORO','','','','kasir','2026-07-16 13:18:00');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-16' 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-260716-0008','K','2026-07-16','13:17:59','kasir','PEMBELIAN UMUM','FB-260716-0005','6348498000','432000','6348066000');
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 ('F326160207461','kasir','1',' MEF3 YT ','TOKO','PM-F','F3E-YLXI-8-T','GL RANTE MODEL CD YT 8K ','','3.530','1','100.00','3654000','0','0','15000','3655000','0','0','0','3655000','FIT','T0075579','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXI-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.530',berat_jual_asli=berat_jual_asli+'3.530',stock_jual='1',berat_akhir=berat_akhir-'3.530',berat_akhir_asli=berat_akhir_asli-'3.530',stock_akhir='0' WHERE tanggal='2026-07-16' AND kode_barang='F3E-YLXI-8-T' 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 ('F326160207461','2026-07-16','3.530','2026-07-16','14:07:46','PLG0030334','3655000','3655000','0','3655000','3655000','kasir','2026-07-16 14:07:46','F32616020746');
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-07-16','F326160207461','2026-07-16','14:07:46','FIT','3655000','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-260716-0009','D','2026-07-16','14:07:46','kasir','PENJUALAN','F326160207461','6348066000','3655000','6351721000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160207461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160207461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160207461';
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 ('F326160210551','kasir','1',' MEF3 YT ','TOKO','PM-F','F3E-YLXI-8-T','GL RANTE MODEL CD YT 8K ','','3.530','1','100.00','3654000','0','0','15000','3655000','0','0','0','3655000','FIT','T0075579','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXI-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.530',berat_jual_asli=berat_jual_asli+'3.530',stock_jual='1',berat_akhir=berat_akhir-'3.530',berat_akhir_asli=berat_akhir_asli-'3.530',stock_akhir='0' WHERE tanggal='2026-07-16' AND kode_barang='F3E-YLXI-8-T' 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 ('F326160210551','2026-07-16','3.530','2026-07-16','14:10:56','PLG0030335','3655000','3655000','0','3655000','3655000','kasir','2026-07-16 14:10:55','F32616021055');
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-07-16','F326160210551','2026-07-16','14:10:56','FIT','3655000','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-260716-0011','D','2026-07-16','14:10:56','kasir','PENJUALAN','F326160210551','6348066000','3655000','6351721000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160210551' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160210551' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160210551';
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 ('F326160213541','kasir','1',' MEF3 YT ','TOKO','PM-F','F3E-YLXI-8-T','GL RANTE MODEL CD YT 8K ','','3.530','1','100.00','3654000','0','0','15000','3655000','0','0','0','3655000','FIT','T0075579','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YLXI-8-T' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.530',berat_jual_asli=berat_jual_asli+'3.530',stock_jual='1',berat_akhir=berat_akhir-'3.530',berat_akhir_asli=berat_akhir_asli-'3.530',stock_akhir='0' WHERE tanggal='2026-07-16' AND kode_barang='F3E-YLXI-8-T' 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 ('F326160213541','2026-07-16','3.530','2026-07-16','14:13:55','PLG0030336','3655000','3655000','0','3655000','3655000','kasir','2026-07-16 14:13:54','F32616021354');
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-07-16','F326160213541','2026-07-16','14:13:55','FIT','3655000','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-260716-0013','D','2026-07-16','14:13:55','kasir','PENJUALAN','F326160213541','6348066000','3655000','6351721000');
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 ('F326160247351','kasir','1',' TAE0TA DW ','TOKO','PT-E','E0TA-UCBH-11-T','CC BANGKOK POLOS DW 17 ','','0.500','1','100.00','910000','0','0','15000','910000','0','0','0','910000','AAT','T0002370','E0TA','0','0','-','0','1820000');
UPDATE tm_barang SET tgl_last_jual='2026-07-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E0TA-UCBH-11-T' 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-07-16' AND kode_barang='E0TA-UCBH-11-T' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PT-E' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group) VALUES ('F326160247351','2026-07-16','0.500','2026-07-16','14:47:36','PLG0030337','910000','910000','0','910000','910000','kasir','2026-07-16 14:47:35','F32616024735');
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-07-16','F326160247351','2026-07-16','14:47:36','AAT','910000','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-260716-0014','D','2026-07-16','14:47:36','kasir','PENJUALAN','F326160247351','6351721000','910000','6352631000');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160247351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160247351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160247351';
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 ('F326160258331','kasir','1',' MEF3E X YT','TOKO','PM-F','F3E-ZFCX-190-0','GL X TIFF CAPELLA SLEP YT 8K ','','1.810','1','100.00','1873000','0','0','15000','1873000','0','0','0','1873000','LIS','00411397','F3E','0','0','-','0','1045000');
UPDATE tm_barang SET tgl_last_jual='2026-07-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-ZFCX-190-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.810',berat_jual_asli=berat_jual_asli+'1.810',stock_jual='1',berat_akhir=berat_akhir-'1.810',berat_akhir_asli=berat_akhir_asli-'1.810',stock_akhir='0' WHERE tanggal='2026-07-16' AND kode_barang='F3E-ZFCX-190-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 ('F326160258331','2026-07-16','1.810','2026-07-16','14:58:34','PLG0030338','1873000','1873000','0','1873000','1873000','kasir','2026-07-16 14:58:33','F32616025833');
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-07-16','F326160258331','2026-07-16','14:58:34','LIS','1873000','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-260716-0016','D','2026-07-16','14:58:34','kasir','PENJUALAN','F326160258331','6351721000','1873000','6353594000');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260716-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260716-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260716-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260716-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260716-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260716-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260716-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260716-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260716-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260716-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160213541' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160213541' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160213541';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326160258331' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326160258331' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326160258331';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161026151' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161026151' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161026151';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F326161029391' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F326161029391' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F326161029391';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-17','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-16';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-16';
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-07-16' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-16';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-16';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-16';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-16';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-17' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-16' 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-260717-0001','D','2026-07-17','15:15:01','SYSTEM','SALDO AWAL','SALDO AWAL','0','6353594000','6353594000');
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-260717-0001','D','2026-07-17','15:15:01','BCA','SALDO AWAL','SALDO AWAL','0','738685000','738685000');
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-260717-0001','D','2026-07-17','15:15:01','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-260717-0001','D','2026-07-17','15:15:01','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-17';