INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-08-27 ','08:40:14');
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-20260827-0001','1','PSPLE-ZHBG-11-0','1','3.250','3.250','TOKO','PSN','TOKO','PSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLE-ZHBG-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLE-ZHBG-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLE-ZHBG-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLE-ZHBG-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-08-27 08:40:25' WHERE kode_barang='PSPLE-ZHBG-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLE-ZHBG-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-27 08:40:25','TOKO','PSN','PSPLE','PSPLE-ZHBG-11-0','1','3.250','3.250','1','3.250','3.250','17.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLE-ZHBG-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-ZHBG-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-27' WHERE no_faktur_beli='';
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-20260827-0001','1','PSGE-ZHBG-12-0','1','2.490','2.490','TOKO','PSN','TOKO','PSN');
DELETE FROM tm_barang WHERE kode_barang='PSGE-ZHBG-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGE-ZHBG-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGE-ZHBG-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGE-ZHBG-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='PSN',tgl_last_beli='2026-08-27 08:40:25' WHERE kode_barang='PSGE-ZHBG-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGE-ZHBG-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-08-27 08:40:25','TOKO','PSN','PSGE','PSGE-ZHBG-12-0','1','2.490','2.490','1','2.490','2.490','57.00');
DELETE FROM tm_dept WHERE kode_dept='PSGE' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGE' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGE' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGE' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGE-ZHBG-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGE-ZHBG-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-08-27' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260827-0001','2026-08-27','08:40','5.740','kasir','2026-08-27 08:40:25');