INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','09:11:33');
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-20251126-0001','1','PMM-YKBF-2-0','1','1.690','1.690','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:53' WHERE kode_barang='PMM-YKBF-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-2-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 ('2025-11-26 09:11:53','TOKO','MMPER','PMM','PMM-YKBF-2-0','1','1.690','1.690','1','1.690','1.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-2-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-3-0','1','2.660','2.660','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:53' WHERE kode_barang='PMM-YKBF-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-3-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 ('2025-11-26 09:11:53','TOKO','MMPER','PMM','PMM-YKBF-3-0','1','2.660','2.660','1','2.660','2.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-3-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-4-0','1','4.030','4.030','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-4-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-4-0','1','4.030','4.030','1','4.030','4.030','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-4-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-5-0','1','4.800','4.800','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-5-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-5-0','1','4.800','4.800','1','4.800','4.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-5-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-6-0','1','3.200','3.200','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-6-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-6-0','1','3.200','3.200','1','3.200','3.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-6-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-7-0','1','2.990','2.990','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-7-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-7-0','1','2.990','2.990','1','2.990','2.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-7-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-8-0','1','1.650','1.650','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-8-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-8-0','1','1.650','1.650','1','1.650','1.650','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-8-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-9-0','1','2.210','2.210','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-9-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-9-0','1','2.210','2.210','1','2.210','2.210','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-9-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-10-0','1','2.990','2.990','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-10-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-10-0','1','2.990','2.990','1','2.990','2.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-10-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-11-0','1','2.820','2.820','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-11-0','1','2.820','2.820','1','2.820','2.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-11-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-12-0','1','2.770','2.770','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-12-0','1','2.770','2.770','1','2.770','2.770','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-12-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-13-0','1','1.750','1.750','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-13-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-13-0','1','1.750','1.750','1','1.750','1.750','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-13-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-14-0','1','2.390','2.390','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-14-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-14-0','1','2.390','2.390','1','2.390','2.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-14-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-15-0','1','2.250','2.250','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-15-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-15-0','1','2.250','2.250','1','2.250','2.250','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-15-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-16-0','1','2.500','2.500','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-16-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-16-0','1','2.500','2.500','1','2.500','2.500','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-16-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-17-0','1','2.660','2.660','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-17-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-17-0','1','2.660','2.660','1','2.660','2.660','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-17-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-18-0','1','1.190','1.190','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-18-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-18-0','1','1.190','1.190','1','1.190','1.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-18-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-19-0','1','2.000','2.000','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-19-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-19-0','1','2.000','2.000','1','2.000','2.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-19-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-20-0','1','1.700','1.700','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-20-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-20-0','1','1.700','1.700','1','1.700','1.700','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-20-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0001','1','PMM-YKBF-21-0','1','2.360','2.360','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YKBF-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YKBF-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YKBF-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YKBF-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-11-26 09:11:54' WHERE kode_barang='PMM-YKBF-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YKBF-21-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 ('2025-11-26 09:11:54','TOKO','MMPER','PMM','PMM-YKBF-21-0','1','2.360','2.360','1','2.360','2.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PMM-YKBF-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YKBF-21-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251126-0001','2025-11-26','09:11','50.610','kasir','2025-11-26 09:11:53');
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-20251126-0002','1','PSPLT-YKBE-163-0','1','2.370','2.370','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKBE-163-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKBE-163-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKBE-163-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKBE-163-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2025-11-26 09:12:31' WHERE kode_barang='PSPLT-YKBE-163-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKBE-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 ('2025-11-26 09:12:31','TOKO','MMPSN','PSPLT','PSPLT-YKBE-163-0','1','2.370','2.370','1','2.370','2.370','6.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-YKBE-163-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKBE-163-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251126-0002','2025-11-26','09:12','2.370','kasir','2025-11-26 09:12:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-11-26 ','09:17:01');
DELETE FROM tm_berlian WHERE kode_barang='ABRT-WGXG-20-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-WGXG-20-0','ABRT-WGXG-20-0','00022808','RD','48','0.170','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-WGXG-20-0','00022808','RD','48','0.170','450','76.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-WGXG-20-0','ABRT-WGXG-20-0','00022808','RD','14','0.295','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-WGXG-20-0','00022808','RD','14','0.295','420','123.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-WGXG-20-0','ABRT-WGXG-20-0','00022808','RD','8','0.085','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-WGXG-20-0','00022808','RD','8','0.085','420','35.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-WGXG-20-0','ABRT-WGXG-20-0','00022808','RD','2','0.135','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-WGXG-20-0','00022808','RD','2','0.135','480','64.8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('ABRT-WGXG-20-0','00022808','00022808','ANTING ABRT-00255','ANTING ABRT-00255','','','6474500','6474500',' 0','0','spv','2025-11-26 09:18:34');
UPDATE tm_barang SET nama_barang='ANTING ABRT-00255' ,nama_atribut='' ,kode_intern='ABRT-00255 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 43 500 000',total_usd='300.9' WHERE kode_barang='ABRT-WGXG-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRT-PJXF-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-PJXF-6-0','ABRT-PJXF-6-0','00017662','RD','2','0.170','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-PJXF-6-0','00017662','RD','2','0.170','620','105.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-PJXF-6-0','ABRT-PJXF-6-0','00017662','RD','36','0.150','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-PJXF-6-0','00017662','RD','36','0.150','450','67.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('ABRT-PJXF-6-0','00017662','00017662','ANTING ABRT-00048','ANTING ABRT-00048','','','4659500','4659500',' 0','0','spv','2025-11-26 09:19:46');
UPDATE tm_barang SET nama_barang='ANTING ABRT-00048' ,nama_atribut='' ,kode_intern='ABRT-00048 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT102 1125',total_usd_ext='IDR 30 000 000',total_usd='172.9' WHERE kode_barang='ABRT-PJXF-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFA-WHBC-5-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WHBC-5-0','TFA-WHBC-5-0','00023596','RD','32','0.290','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WHBC-5-0','00023596','RD','32','0.290','450','130.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WHBC-5-0','TFA-WHBC-5-0','00023596','RD','2','0.040','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WHBC-5-0','00023596','RD','2','0.040','420','16.8')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFA-WHBC-5-0','00023596','00023596','GIWANG TFA-21022','GIWANG TFA-21022','','','6438500','6438500',' 0','0','spv','2025-11-26 09:20:53');
UPDATE tm_barang SET nama_barang='GIWANG TFA-21022' ,nama_atribut='' ,kode_intern='TFA-21022 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='GW108 1125',total_usd_ext='IDR 36 000 000',total_usd='147.3' WHERE kode_barang='TFA-WHBC-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFA-XLXI-16-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-XLXI-16-0','TFA-XLXI-16-0','00032505','RD','66','0.405','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-XLXI-16-0','00032505','RD','66','0.405','400','162')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-XLXI-16-0','TFA-XLXI-16-0','00032505','RD','2','0.080','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-XLXI-16-0','00032505','RD','2','0.080','420','33.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-XLXI-16-0','TFA-XLXI-16-0','00032505','RD','2','0.130','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-XLXI-16-0','00032505','RD','2','0.130','450','58.5')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFA-XLXI-16-0','00032505','00032505','ANTING TFA-21095','ANTING TFA-21095','','','12725000','12725000',' 0','0','spv','2025-11-26 09:23:36');
UPDATE tm_barang SET nama_barang='ANTING TFA-21095' ,nama_atribut='' ,kode_intern='TFA-21095 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 60 500 000',total_usd='254.1' WHERE kode_barang='TFA-XLXI-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDA-XJAF-48-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAF-48-0','BDA-XJAF-48-0','00031826','RD','56','0.200','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAF-48-0','00031826','RD','56','0.200','400','80')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAF-48-0','BDA-XJAF-48-0','00031826','RD','2','0.400','800');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAF-48-0','00031826','RD','2','0.400','800','320')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDA-XJAF-48-0','00031826','00031826','GIWANG BDA-00030','GIWANG BDA-00030','','','3559000','3559000',' 0','0','spv','2025-11-26 09:24:42');
UPDATE tm_barang SET nama_barang='GIWANG BDA-00030' ,nama_atribut='' ,kode_intern='BDA-00030 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 39 500 000',total_usd='400' WHERE kode_barang='BDA-XJAF-48-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDA-XJAF-41-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAF-41-0','BDA-XJAF-41-0','00031819','RD','20','0.230','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAF-41-0','00031819','RD','20','0.230','420','96.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAF-41-0','BDA-XJAF-41-0','00031819','RD','10','0.210','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAF-41-0','00031819','RD','10','0.210','400','84')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAF-41-0','BDA-XJAF-41-0','00031819','RD','10','0.100','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAF-41-0','00031819','RD','10','0.100','400','40')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAF-41-0','BDA-XJAF-41-0','00031819','RD','2','0.030','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAF-41-0','00031819','RD','2','0.030','400','12')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDA-XJAF-41-0','00031819','00031819','GIWANG BDA-00023','GIWANG BDA-00023','','','5099500','5099500',' 0','0','spv','2025-11-26 09:26:15');
UPDATE tm_barang SET nama_barang='GIWANG BDA-00023' ,nama_atribut='' ,kode_intern='BDA-00023 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='GW38 1125',total_usd_ext='IDR 36 000 000',total_usd='232.6' WHERE kode_barang='BDA-XJAF-41-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRT-PJXC-3-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-PJXC-3-0','ABRT-PJXC-3-0','00017542','RD','18','0.110','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-PJXC-3-0','00017542','RD','18','0.110','450','49.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-PJXC-3-0','ABRT-PJXC-3-0','00017542','RD','20','0.195','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-PJXC-3-0','00017542','RD','20','0.195','420','81.9')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-PJXC-3-0','ABRT-PJXC-3-0','00017542','RD','2','0.285','800');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-PJXC-3-0','00017542','RD','2','0.285','800','228')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('ABRT-PJXC-3-0','00017542','00017542','GIWANG ABRT-00032','GIWANG ABRT-00032','','','7686000','7686000',' 0','0','spv','2025-11-26 09:27:38');
UPDATE tm_barang SET nama_barang='GIWANG ABRT-00032' ,nama_atribut='' ,kode_intern='ABRT-00032 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='GW95 1125',total_usd_ext='IDR 52 000 000',total_usd='359.4' WHERE kode_barang='ABRT-PJXC-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFA-WHBB-8-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WHBB-8-0','TFA-WHBB-8-0','00023549','RD','4','0.110','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WHBB-8-0','00023549','RD','4','0.110','420','46.2')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFA-WHBB-8-0','00023549','00023549','ANTING TFA-21014','ANTING TFA-21014','','','4127500','4127500',' 0','0','spv','2025-11-26 09:28:29');
UPDATE tm_barang SET nama_barang='ANTING TFA-21014' ,nama_atribut='' ,kode_intern='TFA-21014 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='ANT43 1125',total_usd_ext='IDR 20 000 000',total_usd='46.2' WHERE kode_barang='TFA-WHBB-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFA-WIXF-2-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WIXF-2-0','TFA-WIXF-2-0','00023843','RD','112','0.270','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WIXF-2-0','00023843','RD','112','0.270','450','121.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WIXF-2-0','TFA-WIXF-2-0','00023843','RD','12','0.875','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WIXF-2-0','00023843','RD','12','0.875','480','420')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WIXF-2-0','TFA-WIXF-2-0','00023843','RD','2','0.200','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WIXF-2-0','00023843','RD','2','0.200','620','124')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WIXF-2-0','TFA-WIXF-2-0','00023843','RD','2','0.080','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WIXF-2-0','00023843','RD','2','0.080','420','33.6')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFA-WIXF-2-0','00023843','00023843','ANTING TFA-21032','ANTING TFA-21032','','','10180500','10180500',' 0','0','spv','2025-11-26 10:08:56');
UPDATE tm_barang SET nama_barang='ANTING TFA-21032' ,nama_atribut='' ,kode_intern='TFA-21032 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 80 500 000',total_usd='699.1' WHERE kode_barang='TFA-WIXF-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFA-WIAA-13-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WIAA-13-0','TFA-WIAA-13-0','00023920','RD','43','0.180','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WIAA-13-0','00023920','RD','43','0.180','450','81')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WIAA-13-0','TFA-WIAA-13-0','00023920','RD','2','0.050','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WIAA-13-0','00023920','RD','2','0.050','420','21')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFA-WIAA-13-0','00023920','00023920','GIWANG TFA-21040','GIWANG TFA-21040','','','5622500','5622500',' 0','0','spv','2025-11-26 10:10:01');
UPDATE tm_barang SET nama_barang='GIWANG TFA-21040' ,nama_atribut='' ,kode_intern='TFA-21040 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 29 000 000',total_usd='102' WHERE kode_barang='TFA-WIAA-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFA-WIAD-13-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WIAD-13-0','TFA-WIAD-13-0','00023998','RD','68','0.365','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WIAD-13-0','00023998','RD','68','0.365','450','164.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WIAD-13-0','TFA-WIAD-13-0','00023998','RD','2','0.035','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WIAD-13-0','00023998','RD','2','0.035','420','14.7')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-WIAD-13-0','TFA-WIAD-13-0','00023998','RD','2','0.145','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-WIAD-13-0','00023998','RD','2','0.145','620','89.9')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFA-WIAD-13-0','00023998','00023998','GIWANG TFA-21047','GIWANG TFA-21047','','','6732000','6732000',' 0','0','spv','2025-11-26 10:11:31');
UPDATE tm_barang SET nama_barang='GIWANG TFA-21047' ,nama_atribut='' ,kode_intern='TFA-21047 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='GW90 1125',total_usd_ext='IDR 43 500 000',total_usd='268.85' WHERE kode_barang='TFA-WIAD-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRT-YDAF-13-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-YDAF-13-0','ABRT-YDAF-13-0','00035018','RD','16','0.050','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-YDAF-13-0','00035018','RD','16','0.050','450','22.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-YDAF-13-0','ABRT-YDAF-13-0','00035018','RD','2','0.260','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-YDAF-13-0','00035018','RD','2','0.260','620','161.2')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('ABRT-YDAF-13-0','00035018','00035018','GIWANG ABRT-00264','GIWANG ABRT-00264','','','3619500','3619500',' 0','0','spv','2025-11-26 10:12:45');
UPDATE tm_barang SET nama_barang='GIWANG ABRT-00264' ,nama_atribut='' ,kode_intern='ABRT-00264 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDB 26 000 000',total_usd='183.7' WHERE kode_barang='ABRT-YDAF-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFA-XLXI-20-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-XLXI-20-0','TFA-XLXI-20-0','00032509','RD','40','0.220','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-XLXI-20-0','00032509','RD','40','0.220','400','88')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFA-XLXI-20-0','TFA-XLXI-20-0','00032509','RD','2','0.185','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFA-XLXI-20-0','00032509','RD','2','0.185','600','111')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFA-XLXI-20-0','00032509','00032509','GIWANG TFA-21097','GIWANG TFA-21097','','','7102500','7102500',' 0','0','spv','2025-11-26 10:15:13');
UPDATE tm_barang SET nama_barang='GIWANG TFA-21097' ,nama_atribut='' ,kode_intern='TFA-21097 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 39 000 000',total_usd='199' WHERE kode_barang='TFA-XLXI-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='ABRT-WCAA-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-WCAA-6-0','ABRT-WCAA-6-0','00020846','RD','2','0.080','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-WCAA-6-0','00020846','RD','2','0.080','480','38.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-WCAA-6-0','ABRT-WCAA-6-0','00020846','RD','16','0.075','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-WCAA-6-0','00020846','RD','16','0.075','450','33.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-WCAA-6-0','ABRT-WCAA-6-0','00020846','RD','18','0.215','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-WCAA-6-0','00020846','RD','18','0.215','420','90.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('ABRT-WCAA-6-0','ABRT-WCAA-6-0','00020846','RD','2','0.065','480');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('ABRT-WCAA-6-0','00020846','RD','2','0.065','480','31.2')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('ABRT-WCAA-6-0','00020846','00020846','ANTING ABRT-00211','ANTING ABRT-00211','','','4916000','4916000',' 0','0','spv','2025-11-26 10:16:50');
UPDATE tm_barang SET nama_barang='ANTING ABRT-00211' ,nama_atribut='' ,kode_intern='ABRT-00211 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 34 000 000',total_usd='193.65' WHERE kode_barang='ABRT-WCAA-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDA-XJAH-14-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAH-14-0','BDA-XJAH-14-0','00031857','RD','6','0.065','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAH-14-0','00031857','RD','6','0.065','400','26')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAH-14-0','BDA-XJAH-14-0','00031857','RD','2','0.315','620');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAH-14-0','00031857','RD','2','0.315','620','195.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAH-14-0','BDA-XJAH-14-0','00031857','RD','2','0.025','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAH-14-0','00031857','RD','2','0.025','420','10.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJAH-14-0','BDA-XJAH-14-0','00031857','RD','22','0.095','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJAH-14-0','00031857','RD','22','0.095','400','38')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDA-XJAH-14-0','00031857','00031857','ANTING BDA-00033','ANTING BDA-00033','','','5964000','5964000',' 0','0','spv','2025-11-26 10:18:28');
UPDATE tm_barang SET nama_barang='ANTING BDA-00033' ,nama_atribut='' ,kode_intern='BDA-00033 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='1125',total_usd_ext='IDR 39 000 000',total_usd='269.8' WHERE kode_barang='BDA-XJAH-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='BDA-XJBC-6-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJBC-6-0','BDA-XJBC-6-0','00031911','RD','72','0.305','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJBC-6-0','00031911','RD','72','0.305','400','122')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('BDA-XJBC-6-0','BDA-XJBC-6-0','00031911','RD','8','0.100','400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('BDA-XJBC-6-0','00031911','RD','8','0.100','400','40')
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('BDA-XJBC-6-0','00031911','00031911','GIWANG BDA-00037','GIWANG BDA-00037','','','6237000','6237000',' 0','0','spv','2025-11-26 10:19:28');
UPDATE tm_barang SET nama_barang='GIWANG BDA-00037' ,nama_atribut='' ,kode_intern='BDA-00037 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='GW113 1125',total_usd_ext='IDR 37 000 000',total_usd='162' WHERE kode_barang='BDA-XJBC-6-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','10:27:50');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251126-0003','1','PBDG-YKBE-121-0','1','2.070','2.070','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-121-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-121-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-121-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-121-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-121-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-121-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-121-0','1','2.070','2.070','1','2.070','2.070','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-121-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-121-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-122-0','1','2.200','2.200','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-122-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-122-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-122-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-122-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-122-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-122-0','1','2.200','2.200','1','2.200','2.200','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-122-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-122-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-123-0','1','2.100','2.100','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-123-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-123-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-123-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-123-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-123-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-123-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-123-0','1','2.100','2.100','1','2.100','2.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-123-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-123-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-124-0','1','2.170','2.170','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-124-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-124-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-124-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-124-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-124-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-124-0','1','2.170','2.170','1','2.170','2.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-124-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-124-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-125-0','1','2.400','2.400','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-125-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-125-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-125-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-125-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-125-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-125-0','1','2.400','2.400','1','2.400','2.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-125-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-125-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-126-0','1','2.360','2.360','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-126-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-126-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-126-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-126-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-126-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-126-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-126-0','1','2.360','2.360','1','2.360','2.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-126-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-126-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-127-0','1','2.360','2.360','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-127-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-127-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-127-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-127-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-127-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-127-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-127-0','1','2.360','2.360','1','2.360','2.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-127-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-127-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-128-0','1','2.430','2.430','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-128-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-128-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-128-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-128-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-128-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-128-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-128-0','1','2.430','2.430','1','2.430','2.430','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-128-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-128-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-129-0','1','2.120','2.120','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-129-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-129-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-129-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-129-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-129-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-129-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-129-0','1','2.120','2.120','1','2.120','2.120','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-129-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-129-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-130-0','1','2.110','2.110','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-130-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-130-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-130-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-130-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-130-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-130-0','1','2.110','2.110','1','2.110','2.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-130-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-130-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-131-0','1','2.080','2.080','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-131-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-131-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-131-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-131-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-131-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-131-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-131-0','1','2.080','2.080','1','2.080','2.080','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-131-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-131-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-132-0','1','2.090','2.090','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-132-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-132-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-132-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-132-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-132-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-132-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-132-0','1','2.090','2.090','1','2.090','2.090','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-132-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-132-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-133-0','1','2.390','2.390','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-133-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-133-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-133-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-133-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-133-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-133-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-133-0','1','2.390','2.390','1','2.390','2.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-133-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-133-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-134-0','1','2.390','2.390','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-134-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-134-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-134-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-134-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-134-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-134-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-134-0','1','2.390','2.390','1','2.390','2.390','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-134-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-134-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-135-0','1','1.780','1.780','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-135-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-135-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-135-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-135-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-135-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-135-0','1','1.780','1.780','1','1.780','1.780','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-135-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-135-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-136-0','1','1.630','1.630','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-136-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-136-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-136-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-136-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-136-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-136-0','1','1.630','1.630','1','1.630','1.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-136-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-136-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-137-0','1','2.870','2.870','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-137-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-137-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-137-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-137-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-137-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-137-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-137-0','1','2.870','2.870','1','2.870','2.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-137-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-137-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-138-0','1','2.720','2.720','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-138-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-138-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-138-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-138-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-138-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-138-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-138-0','1','2.720','2.720','1','2.720','2.720','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-138-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-138-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-139-0','1','1.810','1.810','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-139-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-139-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-139-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-139-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-139-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-139-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-139-0','1','1.810','1.810','1','1.810','1.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-139-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-139-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-140-0','1','1.840','1.840','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-140-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-140-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-140-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-140-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-140-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-140-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-140-0','1','1.840','1.840','1','1.840','1.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-140-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-140-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-141-0','1','1.890','1.890','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-141-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-141-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-141-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-141-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-141-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-141-0','1','1.890','1.890','1','1.890','1.890','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-141-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-141-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-142-0','1','1.820','1.820','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-142-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-142-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-142-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-142-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-142-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-142-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-142-0','1','1.820','1.820','1','1.820','1.820','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-142-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-142-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-143-0','1','2.140','2.140','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-143-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-143-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-143-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-143-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-143-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-143-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-143-0','1','2.140','2.140','1','2.140','2.140','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-143-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-143-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-144-0','1','2.690','2.690','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-144-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-144-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-144-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-144-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-144-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-144-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-144-0','1','2.690','2.690','1','2.690','2.690','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-144-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-144-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-145-0','1','1.920','1.920','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-145-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-145-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-145-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-145-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-145-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-145-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-145-0','1','1.920','1.920','1','1.920','1.920','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-145-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-145-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-146-0','1','1.680','1.680','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-146-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-146-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-146-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-146-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-146-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-146-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-146-0','1','1.680','1.680','1','1.680','1.680','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-146-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-146-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-147-0','1','1.460','1.460','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-147-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-147-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-147-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-147-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-147-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-147-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-147-0','1','1.460','1.460','1','1.460','1.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-147-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-147-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-148-0','1','2.520','2.520','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-148-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-148-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-148-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-148-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-148-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-148-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-148-0','1','2.520','2.520','1','2.520','2.520','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-148-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-148-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-149-0','1','2.270','2.270','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-149-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-149-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-149-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-149-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-149-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-149-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-149-0','1','2.270','2.270','1','2.270','2.270','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-149-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-149-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-150-0','1','4.480','4.480','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-150-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-150-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-150-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-150-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-150-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-150-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-150-0','1','4.480','4.480','1','4.480','4.480','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-150-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-150-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-151-0','1','1.510','1.510','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-151-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-151-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-151-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-151-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-151-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-151-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-151-0','1','1.510','1.510','1','1.510','1.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-151-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-151-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-152-0','1','1.530','1.530','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-152-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-152-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-152-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-152-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-152-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-152-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-152-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-152-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-152-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-153-0','1','1.380','1.380','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-153-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-153-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-153-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-153-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-153-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-153-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-153-0','1','1.380','1.380','1','1.380','1.380','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-153-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-153-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-154-0','1','1.640','1.640','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-154-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-154-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-154-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-154-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-154-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-154-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-154-0','1','1.640','1.640','1','1.640','1.640','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-154-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-154-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-155-0','1','1.540','1.540','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-155-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-155-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-155-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-155-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-155-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-155-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-155-0','1','1.540','1.540','1','1.540','1.540','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-155-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-155-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-156-0','1','1.530','1.530','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-156-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-156-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-156-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-156-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-156-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-156-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-156-0','1','1.530','1.530','1','1.530','1.530','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-156-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-156-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-157-0','1','2.280','2.280','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-157-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-157-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-157-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-157-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-157-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-157-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-157-0','1','2.280','2.280','1','2.280','2.280','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-157-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-157-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-158-0','1','4.670','4.670','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-158-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-158-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-158-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-158-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-158-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-158-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-158-0','1','4.670','4.670','1','4.670','4.670','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-158-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-158-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-159-0','1','2.590','2.590','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-159-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-159-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-159-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-159-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-159-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-159-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-159-0','1','2.590','2.590','1','2.590','2.590','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-159-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-159-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-160-0','1','2.600','2.600','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-160-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-160-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-160-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-160-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-160-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-160-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-160-0','1','2.600','2.600','1','2.600','2.600','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-160-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-160-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0003','1','PBDG-YKBE-161-0','1','1.850','1.850','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-YKBE-161-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-161-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-YKBE-161-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-YKBE-161-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2025-11-26 10:28:01' WHERE kode_barang='PBDG-YKBE-161-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-YKBE-161-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 ('2025-11-26 10:28:01','TOKO','BIPPER','PBDG','PBDG-YKBE-161-0','1','1.850','1.850','1','1.850','1.850','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-YKBE-161-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-YKBE-161-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251126-0003','2025-11-26','10:27','89.910','kasir','2025-11-26 10:28:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','10:59:11');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','11:10:10');
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,potong_rp,keterangan) VALUES ('FJ-251126-0001','kasir','1',' 800K-12-58','TOKO','MMPER','PMM-YKBD-19-0','CINCIN SILVER 925 ','','2.320','1','100.00','143000','0','0','16750','599000','0','0','0','599000','NAD','00039791','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKBD-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.320',berat_jual_asli=berat_jual_asli+'2.320',stock_jual='1',berat_akhir=berat_akhir-'2.320',berat_akhir_asli=berat_akhir_asli-'2.320',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PMM-YKBD-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0001','2025-11-26','2.320','2025-11-26','11:14:57','PLG0007833','599000','599000','0','599000','0','kasir','2025-11-26 11:14:57','FJ-251126-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0001','2025-11-26','11:14:57','NAD','599000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0001','2025-11-26','2025-11-26 11:14:57','PENJUALAN : FJ-251126-0001','.','TBC','599000','599000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0002','D','2025-11-26','11:14:57','TBC','PENJUALAN','FJ-251126-0001','18217724614','599000','18218323614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='599000' WHERE no_faktur_jual='FJ-251126-0001' 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,potong_rp,keterangan) VALUES ('FJ-251126-0002','kasir','1',' 700K-20-55','TOKO','MMPER','PMM-YKAD-45-0','CINCIN SILVER 925 ','','2.150','1','100.00','132000','0','0','16750','700000','0','0','0','700000','GEISYA','00039622','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKAD-45-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.150',berat_jual_asli=berat_jual_asli+'2.150',stock_jual='1',berat_akhir=berat_akhir-'2.150',berat_akhir_asli=berat_akhir_asli-'2.150',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PMM-YKAD-45-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0002','2025-11-26','2.150','2025-11-26','11:15:56','PLG0007834','700000','700000','0','700000','0','kasir','2025-11-26 11:15:56','FJ-251126-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0002','2025-11-26','11:15:56','GEISYA','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0002','2025-11-26','2025-11-26 11:15:56','PENJUALAN : FJ-251126-0002','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0003','D','2025-11-26','11:15:56','TBC','PENJUALAN','FJ-251126-0002','18218323614','700000','18219023614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-251126-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0002';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01497','NAD','1','CINCIN NIKAH SILVER','CEWE GRF MAX A ATAPARY COWO RESIZE KE 19 GRF MONICA ANGELINA CRUM FULL PUTIH SEPERTI CTH','4.470','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01497','2025-11-26','2025-11-26','11:21:04','PLG0007835','kasir','2025-11-27','kasir','2025-11-26 11:21:04','4.470','0','0','0','0','0','0','0','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','13:39:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','13:57: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-20251126-0004','1','PSPRT-YKBF-23-0','1','4.190','4.190','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YKBF-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YKBF-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YKBF-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YKBF-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:24' WHERE kode_barang='PSPRT-YKBF-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YKBF-23-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 ('2025-11-26 13:57:24','TOKO','BIPPSN','PSPRT','PSPRT-YKBF-23-0','1','4.190','4.190','1','4.190','4.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-YKBF-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKBF-23-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0004','1','PSPRT-YKBF-24-0','1','4.710','4.710','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YKBF-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YKBF-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YKBF-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YKBF-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:24' WHERE kode_barang='PSPRT-YKBF-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YKBF-24-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 ('2025-11-26 13:57:24','TOKO','BIPPSN','PSPRT','PSPRT-YKBF-24-0','1','4.710','4.710','1','4.710','4.710','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-YKBF-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKBF-24-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0004','1','PSPLT-YKBF-25-0','1','2.050','2.050','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKBF-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKBF-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKBF-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:24' WHERE kode_barang='PSPLT-YKBF-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKBF-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2025-11-26 13:57:24','TOKO','BIPPSN','PSPLT','PSPLT-YKBF-25-0','1','2.050','2.050','1','2.050','2.050','6.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-YKBF-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-25-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0004','1','PSPRT-YKBF-26-0','1','3.180','3.180','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YKBF-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YKBF-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YKBF-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YKBF-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:24' WHERE kode_barang='PSPRT-YKBF-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YKBF-26-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 ('2025-11-26 13:57:24','TOKO','BIPPSN','PSPRT','PSPRT-YKBF-26-0','1','3.180','3.180','1','3.180','3.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPRT-YKBF-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YKBF-26-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0004','1','PSPLT-YKBF-27-0','1','3.470','3.470','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKBF-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKBF-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKBF-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:24' WHERE kode_barang='PSPLT-YKBF-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKBF-27-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 ('2025-11-26 13:57:24','TOKO','BIPPSN','PSPLT','PSPLT-YKBF-27-0','1','3.470','3.470','1','3.470','3.470','6.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-YKBF-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-27-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0004','1','PSPLT-YKBF-28-0','1','4.060','4.060','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKBF-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKBF-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKBF-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:25' WHERE kode_barang='PSPLT-YKBF-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKBF-28-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 ('2025-11-26 13:57:25','TOKO','BIPPSN','PSPLT','PSPLT-YKBF-28-0','1','4.060','4.060','1','4.060','4.060','6.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-YKBF-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-28-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0004','1','PSPLT-YKBF-29-0','1','4.100','4.100','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKBF-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKBF-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKBF-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:25' WHERE kode_barang='PSPLT-YKBF-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKBF-29-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 ('2025-11-26 13:57:25','TOKO','BIPPSN','PSPLT','PSPLT-YKBF-29-0','1','4.100','4.100','1','4.100','4.100','6.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-YKBF-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-29-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0004','1','PSPLT-YKBF-30-0','1','2.480','2.480','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKBF-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKBF-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKBF-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:25' WHERE kode_barang='PSPLT-YKBF-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKBF-30-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 ('2025-11-26 13:57:25','TOKO','BIPPSN','PSPLT','PSPLT-YKBF-30-0','1','2.480','2.480','1','2.480','2.480','6.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-YKBF-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-30-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0004','1','PSPLT-YKBF-31-0','1','3.090','3.090','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YKBF-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YKBF-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YKBF-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:25' WHERE kode_barang='PSPLT-YKBF-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YKBF-31-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 ('2025-11-26 13:57:25','TOKO','BIPPSN','PSPLT','PSPLT-YKBF-31-0','1','3.090','3.090','1','3.090','3.090','6.00');
DELETE FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSPLT-YKBF-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YKBF-31-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' 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-20251126-0004','1','PSGT-YKBF-32-0','1','2.110','2.110','TOKO','PSNB','TOKO','BIPPSN');
DELETE FROM tm_barang WHERE kode_barang='PSGT-YKBF-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSGT-YKBF-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YKBF-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSGT-YKBF-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPSN',tgl_last_beli='2025-11-26 13:57:25' WHERE kode_barang='PSGT-YKBF-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSGT-YKBF-32-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 ('2025-11-26 13:57:25','TOKO','BIPPSN','PSGT','PSGT-YKBF-32-0','1','2.110','2.110','1','2.110','2.110','83.00');
DELETE FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PSGT' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PSGT-YKBF-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-YKBF-32-0';
UPDATE tt_beli_detail SET tgl_terima='2025-11-26' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251126-0004','2025-11-26','13:57','33.440','kasir','2025-11-26 13:57:24');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','14:31:22');
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01498','SULIS','1','CC PLD','SZ 7 JGN DI BUAT TIPIS GRF JGN HILANG FONT VINTAGE ROTTER','2.000','1','50000','50000');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0003','2025-11-26','2025-11-26 14:37:32','SERVICE : SV-01498','.','TBC','50000','50000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0004','D','2025-11-26','14:37:32','TBC','SERVICE','SV-01498','18219023614','50000','18219073614','TRANSFER');
INSERT DELAYED INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01498','2025-11-26','2025-11-26','14:37:32','PLG0007836','kasir','2025-12-05','kasir','2025-11-26 14:37:32','2.000','0','0','0','50000','0','50000','50000','0');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','14:39:05');
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,potong_rp,keterangan) VALUES ('FJ-251126-0003','kasir','1',' 600K-15 ','TOKO','BIPCMP','BDCM-YJXH-41-0','BANDUNG CINCIN EMAS ','','1.040','1','83.00','1947000','0','0','16750','2684000','0','0','0','2684000','HELMI','00039130','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YJXH-41-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='BDCM-YJXH-41-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0003','2025-11-26','1.040','2025-11-26','14:55:47','PLG0007837','2684000','2684000','0','2684000','0','kasir','2025-11-26 14:55:46','FJ-251126-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0003','2025-11-26','14:55:47','HELMI','2684000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0004','2025-11-26','2025-11-26 14:55:46','PENJUALAN : FJ-251126-0003','.','TBC','2684000','2684000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0005','D','2025-11-26','14:55:47','TBC','PENJUALAN','FJ-251126-0003','18219073614','2684000','18221757614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='2684000' WHERE no_faktur_jual='FJ-251126-0003' 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,potong_rp,keterangan) VALUES ('FJ-251126-0004','kasir',' 1',' 600K-12 ','TOKO','BIPCMP','BDCM-YJXH-42-0','BANDUNG CINCIN EMAS ','','1.040','1','83.00','1947000','0','0','16750','2684000','0','0','0','2684000','HELMI','00039131','BDCM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='BDCM-YJXH-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.040',berat_jual_asli=berat_jual_asli+'1.040',stock_jual='1',berat_akhir=berat_akhir-'1.040',berat_akhir_asli=berat_akhir_asli-'1.040',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='BDCM-YJXH-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPCMP' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0004','2025-11-26','1.040','2025-11-26','14:55:47','PLG0007838','2684000','2684000','0','2684000','0','kasir','2025-11-26 14:55:46','FJ-251126-0003','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0004','2025-11-26','14:55:47','HELMI','2684000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0005','2025-11-26','2025-11-26 14:55:46','PENJUALAN : FJ-251126-0004','.','TBC','2684000','2684000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0006','D','2025-11-26','14:55:47','TBC','PENJUALAN','FJ-251126-0004','18221757614','2684000','18224441614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='5368000' WHERE no_faktur_jual='FJ-251126-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0004';
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,potong_rp,keterangan) VALUES ('FJ-251126-0005','kasir','1',' 700K-12-00','TOKO','BIPPER','PBSD-YGCX-19-0','CINCIN SILVER 925 ','','2.600','1','100.00','54000','0','0','16750','650000','0','0','0','650000','SUL','00037758','PBSD','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBSD-YGCX-19-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.600',berat_jual_asli=berat_jual_asli+'2.600',stock_jual='1',berat_akhir=berat_akhir-'2.600',berat_akhir_asli=berat_akhir_asli-'2.600',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PBSD-YGCX-19-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0005','2025-11-26','2.600','2025-11-26','15:41:56','PLG0007839','650000','650000','0','650000','0','kasir','2025-11-26 15:41:55','FJ-251126-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0005','2025-11-26','15:41:56','SUL','650000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0006','2025-11-26','2025-11-26 15:41:55','PENJUALAN : FJ-251126-0005','.','TBC','650000','650000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0007','D','2025-11-26','15:41:56','TBC','PENJUALAN','FJ-251126-0005','18224441614','650000','18225091614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='650000' WHERE no_faktur_jual='FJ-251126-0005' 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,potong_rp,keterangan) VALUES ('FJ-251126-0006','kasir',' 1',' 900K-11-17','TOKO','BIPPER','PBDG-YKBA-5-0','CINCIN SILVER 925 ','','1.460','1','100.00','90000','0','0','16750','850000','0','0','0','850000','SUL','00039751','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBA-5-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PBDG-YKBA-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0006','2025-11-26','1.460','2025-11-26','15:41:56','PLG0007840','850000','850000','0','850000','0','kasir','2025-11-26 15:41:55','FJ-251126-0005','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0006','2025-11-26','15:41:56','SUL','850000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0007','2025-11-26','2025-11-26 15:41:55','PENJUALAN : FJ-251126-0006','.','TBC','850000','850000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0008','D','2025-11-26','15:41:56','TBC','PENJUALAN','FJ-251126-0006','18225091614','850000','18225941614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1500000' WHERE no_faktur_jual='FJ-251126-0006' LIMIT 1;
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01499','SULIS','1','SEPASANG SILVER','CWE PUTIH GLOSY CWO SZ 13 PUTIH DOFF SEMPROT FONT BRUSH SCRIPT','4.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01499','2025-11-26','2025-11-26','15:48:55','PLG0007841','kasir','2025-12-05','kasir','2025-11-26 15:48:55','4.000','0','0','0','0','0','0','0','0');
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,potong_rp,keterangan) VALUES ('FJ-251126-0007','kasir','1',' 700K-20-18','TOKO','BIPPER','PBDG-YKBE-39-0','CINCIN SILVER 925 ','','3.790','1','100.00','233000','0','0','16750','650000','0','0','0','650000','SUL','00039871','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-39-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.790',berat_jual_asli=berat_jual_asli+'3.790',stock_jual='1',berat_akhir=berat_akhir-'3.790',berat_akhir_asli=berat_akhir_asli-'3.790',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PBDG-YKBE-39-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0007','2025-11-26','3.790','2025-11-26','16:15:21','PLG0007842','650000','650000','0','650000','0','kasir','2025-11-26 16:15:20','FJ-251126-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0007','2025-11-26','16:15:21','SUL','650000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0008','2025-11-26','2025-11-26 16:15:20','PENJUALAN : FJ-251126-0007','.','TBC','650000','650000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0009','D','2025-11-26','16:15:21','TBC','PENJUALAN','FJ-251126-0007','18225941614','650000','18226591614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='650000' WHERE no_faktur_jual='FJ-251126-0007' 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,potong_rp,keterangan) VALUES ('FJ-251126-0008','kasir',' 1',' 700K-18-19','TOKO','BIPPER','PBDG-YKBE-104-0','CINCIN SILVER 925 ','','2.860','1','100.00','176000','0','0','16750','650000','0','0','0','650000','SUL','00039936','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-104-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.860',berat_jual_asli=berat_jual_asli+'2.860',stock_jual='1',berat_akhir=berat_akhir-'2.860',berat_akhir_asli=berat_akhir_asli-'2.860',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PBDG-YKBE-104-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0008','2025-11-26','2.860','2025-11-26','16:15:21','PLG0007843','650000','650000','0','650000','0','kasir','2025-11-26 16:15:20','FJ-251126-0007','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0008','2025-11-26','16:15:21','SUL','650000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0009','2025-11-26','2025-11-26 16:15:20','PENJUALAN : FJ-251126-0008','.','TBC','650000','650000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0010','D','2025-11-26','16:15:21','TBC','PENJUALAN','FJ-251126-0008','18226591614','650000','18227241614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1300000' WHERE no_faktur_jual='FJ-251126-0008' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0006';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0007';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0008' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0008';
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,potong_rp,keterangan) VALUES ('FJ-251126-0009','kasir','1',' TFCMR75-87','TOKO','TFCINMAS','TFCMR-YJXH-17-0','THIFA CINCIN MAS RG ','','2.390','1','87.00','4688000','0','0','16750','4750000','0','0','0','4750000','FIR','00039106','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YJXH-17-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.390',berat_jual_asli=berat_jual_asli+'2.390',stock_jual='1',berat_akhir=berat_akhir-'2.390',berat_akhir_asli=berat_akhir_asli-'2.390',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='TFCMR-YJXH-17-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0009','2025-11-26','2.390','2025-11-26','17:09:26','PLG0007844','4750000','4750000','0','4750000','0','kasir','2025-11-26 17:09:25','FJ-251126-0009','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0009','2025-11-26','17:09:26','FIR','4750000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0010','2025-11-26','2025-11-26 17:09:25','PENJUALAN : FJ-251126-0009','.','TBC','4750000','4750000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0011','D','2025-11-26','17:09:26','TBC','PENJUALAN','FJ-251126-0009','18227241614','4750000','18231991614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='4750000' WHERE no_faktur_jual='FJ-251126-0009' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0009' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0009';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01500','HELMI','1','SEPASANG CC EMAS DAN PLD','KRUM ULANG','5.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01500','2025-11-26','2025-11-26','17:51:24','PLG0007845','kasir','2025-11-27','kasir','2025-11-26 17:51:24','5.000','0','0','0','0','0','0','0','0');
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,potong_rp,keterangan) VALUES ('FJ-251126-0010','kasir','1',' 700K-195-1','TOKO','BIPPER','PBDG-YKBE-70-0','CINCIN SILVER 925 ','','3.200','1','100.00','196000','0','0','16750','700000','0','0','0','700000','HELMI','00039902','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBE-70-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.200',berat_jual_asli=berat_jual_asli+'3.200',stock_jual='1',berat_akhir=berat_akhir-'3.200',berat_akhir_asli=berat_akhir_asli-'3.200',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PBDG-YKBE-70-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0010','2025-11-26','3.200','2025-11-26','19:13:08','PLG0007846','700000','700000','0','700000','0','kasir','2025-11-26 19:13:08','FJ-251126-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0010','2025-11-26','19:13:08','HELMI','700000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0011','2025-11-26','2025-11-26 19:13:08','PENJUALAN : FJ-251126-0010','.','TBC','700000','700000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0012','D','2025-11-26','19:13:08','TBC','PENJUALAN','FJ-251126-0010','18231991614','700000','18232691614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='700000' WHERE no_faktur_jual='FJ-251126-0010' 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,potong_rp,keterangan) VALUES ('FJ-251126-0011','kasir',' 1',' 800K-12-17','TOKO','BIPPER','PBDG-YKXF-42-0','CINCIN SILVER 925 ','','2.400','1','100.00','147000','0','0','16750','599000','0','0','0','599000','HELMI','00039519','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKXF-42-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.400',berat_jual_asli=berat_jual_asli+'2.400',stock_jual='1',berat_akhir=berat_akhir-'2.400',berat_akhir_asli=berat_akhir_asli-'2.400',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PBDG-YKXF-42-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0011','2025-11-26','2.400','2025-11-26','19:13:08','PLG0007847','599000','599000','0','599000','0','kasir','2025-11-26 19:13:08','FJ-251126-0010','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0011','2025-11-26','19:13:08','HELMI','599000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0012','2025-11-26','2025-11-26 19:13:08','PENJUALAN : FJ-251126-0011','.','TBC','599000','599000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0013','D','2025-11-26','19:13:08','TBC','PENJUALAN','FJ-251126-0011','18232691614','599000','18233290614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1299000' WHERE no_faktur_jual='FJ-251126-0011' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0010' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0010';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0011';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='';
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,potong_rp,keterangan) VALUES ('FJ-251126-0012','kasir','1',' 700K-17-61','TOKO','MMPER','PMM-YKBF-11-0','CINCIN SILVER 925 ','','2.820','1','100.00','173000','0','0','16750','650000','0','0','0','650000','GEISYA','00040006','PMM','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PMM-YKBF-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.820',berat_jual_asli=berat_jual_asli+'2.820',stock_jual='1',berat_akhir=berat_akhir-'2.820',berat_akhir_asli=berat_akhir_asli-'2.820',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PMM-YKBF-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0012','2025-11-26','2.820','2025-11-26','19:44:15','PLG0007848','650000','650000','0','650000','0','kasir','2025-11-26 19:44:14','FJ-251126-0012','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0012','2025-11-26','19:44:15','GEISYA','650000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0013','2025-11-26','2025-11-26 19:44:14','PENJUALAN : FJ-251126-0012','.','TBC','650000','650000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0014','D','2025-11-26','19:44:15','TBC','PENJUALAN','FJ-251126-0012','18233290614','650000','18233940614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='650000' WHERE no_faktur_jual='FJ-251126-0012' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0012' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0012';
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,potong_rp,keterangan) VALUES ('FJ-251126-0013','kasir','1',' 700K-25-18','TOKO','BIPPER','PBDG-YKBD-9-0','CINCIN SILVER 925 ','','4.330','1','100.00','266000','0','0','16750','650000','0','0','0','650000','SUL','00039781','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-11-26', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YKBD-9-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.330',berat_jual_asli=berat_jual_asli+'4.330',stock_jual='1',berat_akhir=berat_akhir-'4.330',berat_akhir_asli=berat_akhir_asli-'4.330',stock_akhir='0' WHERE tanggal='2025-11-26' AND kode_barang='PBDG-YKBD-9-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' 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,no_persekot,dp_pesanan) VALUES ('FJ-251126-0013','2025-11-26','4.330','2025-11-26','19:45:11','PLG0007849','650000','650000','0','650000','0','kasir','2025-11-26 19:45:10','FJ-251126-0013','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-11-26','FJ-251126-0013','2025-11-26','19:45:11','SUL','650000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-251126-0014','2025-11-26','2025-11-26 19:45:10','PENJUALAN : FJ-251126-0013','.','TBC','650000','650000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-251126-0015','D','2025-11-26','19:45:11','TBC','PENJUALAN','FJ-251126-0013','18233940614','650000','18234590614','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='650000' WHERE no_faktur_jual='FJ-251126-0013' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0013' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251126-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251126-0013';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01501','GEISYA','1','CINCIN NIKAH SILVER','RESIZE KE 16 5 GRF AFRA NEVIAL CRUM FULL PUTIH SEPERTI CTH','2.820','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01501','2025-11-26','2025-11-26','19:46:51','PLG0007850','kasir','2025-11-27','kasir','2025-11-26 19:46:51','2.820','0','0','0','0','0','0','0','0');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-11-27','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-10-27';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-11-26';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-11-26';
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='2025-11-26' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-11-26';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-11-26';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-11-26';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-11-26';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202510 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-10';
UPDATE tt_barang_saldo SET tanggal= '2025-11-27' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-11-26' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-251127-0001','D','2025-11-27','20:05:00','TBC','SALDO AWAL','SALDO AWAL','0','18234590614','18234590614');
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-251127-0001','D','2025-11-27','20:05:00','BCD','SALDO AWAL','SALDO AWAL','0','1342321000','1342321000');
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-251127-0001','D','2025-11-27','20:05:00','KET','SALDO AWAL','SALDO AWAL','0','135063000','135063000');
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-251127-0001','D','2025-11-27','20:05:00','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
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-251127-0001','D','2025-11-27','20:05:00','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
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-251127-0001','D','2025-11-27','20:05:00','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
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-251127-0001','D','2025-11-27','20:05:00','BCK','SALDO AWAL','SALDO AWAL','0','1927708000','1927708000');
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-251127-0001','D','2025-11-27','20:05:00','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
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-251127-0001','D','2025-11-27','20:05:00','TOP','SALDO AWAL','SALDO AWAL','0','253907000','253907000');
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-251127-0001','D','2025-11-27','20:05:00','SHO','SALDO AWAL','SALDO AWAL','0','141465650','141465650');
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-251127-0001','D','2025-11-27','20:05:00','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
UPDATE tp_system SET tgl_system='2025-11-27';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-11-26 ','21:26:57');