INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-28 ','08:49:38');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20251028-0001','1','PMM-YJBH-1-0','1','1.880','1.880','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-1-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-1-0','1','1.880','1.880','1','1.880','1.880','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-YJBH-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-1-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-2-0','1','1.940','1.940','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-2-0','1','1.940','1.940','1','1.940','1.940','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-YJBH-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-2-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-3-0','1','1.950','1.950','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-3-0','1','1.950','1.950','1','1.950','1.950','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-YJBH-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-3-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-4-0','1','1.960','1.960','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-4-0','1','1.960','1.960','1','1.960','1.960','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-YJBH-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-4-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-5-0','1','1.880','1.880','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-5-0','1','1.880','1.880','1','1.880','1.880','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-YJBH-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-5-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-6-0','1','1.840','1.840','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-6-0','1','1.840','1.840','1','1.840','1.840','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-YJBH-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-6-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-7-0','1','1.850','1.850','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-7-0','1','1.850','1.850','1','1.850','1.850','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-YJBH-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-7-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-8-0','1','1.210','1.210','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-8-0','1','1.210','1.210','1','1.210','1.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-YJBH-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-8-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-9-0','1','1.240','1.240','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-9-0','1','1.240','1.240','1','1.240','1.240','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-YJBH-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-9-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-10-0','1','1.190','1.190','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-10-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-YJBH-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-10-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-11-0','1','2.520','2.520','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-11-0','1','2.520','2.520','1','2.520','2.520','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-YJBH-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-11-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-12-0','1','2.430','2.430','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-12-0','1','2.430','2.430','1','2.430','2.430','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-YJBH-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-12-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0001','1','PMM-YJBH-13-0','1','2.380','2.380','TOKO','MMPER','TOKO','MMPER');
DELETE FROM tm_barang WHERE kode_barang='PMM-YJBH-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PMM-YJBH-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PMM-YJBH-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PMM-YJBH-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPER',tgl_last_beli='2025-10-28 08:49:50' WHERE kode_barang='PMM-YJBH-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PMM-YJBH-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-10-28 08:49:50','TOKO','MMPER','PMM','PMM-YJBH-13-0','1','2.380','2.380','1','2.380','2.380','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-YJBH-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PMM-YJBH-13-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251028-0001','2025-10-28','08:49','24.270','kasir','2025-10-28 08:49: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-20251028-0002','1','PSPLT-YJBH-14-0','1','1.680','1.680','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPLT-YJBH-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPLT-YJBH-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-YJBH-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPLT-YJBH-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2025-10-28 08:50:14' WHERE kode_barang='PSPLT-YJBH-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPLT-YJBH-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-10-28 08:50:14','TOKO','MMPSN','PSPLT','PSPLT-YJBH-14-0','1','1.680','1.680','1','1.680','1.680','5.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-YJBH-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-YJBH-14-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' 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-20251028-0002','1','PSPRT-YJBH-15-0','1','3.060','3.060','TOKO','MMPSN','TOKO','MMPSN');
DELETE FROM tm_barang WHERE kode_barang='PSPRT-YJBH-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PSPRT-YJBH-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPRT-YJBH-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PSPRT-YJBH-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='MMPSN',tgl_last_beli='2025-10-28 08:50:14' WHERE kode_barang='PSPRT-YJBH-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PSPRT-YJBH-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-10-28 08:50:14','TOKO','MMPSN','PSPRT','PSPRT-YJBH-15-0','1','3.060','3.060','1','3.060','3.060','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-YJBH-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-YJBH-15-0';
UPDATE tt_beli_detail SET tgl_terima='2025-10-28' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20251028-0002','2025-10-28','08:50','4.740','kasir','2025-10-28 08:50:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-28 ','10:30:41');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-28 ','11:33:40');
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7548500',harga_beli ='7548500' WHERE kode_barcode='00017312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6817000',harga_beli ='6817000' WHERE kode_barcode='00017383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7477500',harga_beli ='7477500' WHERE kode_barcode='00017542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5050500',harga_beli ='5050500' WHERE kode_barcode='00017624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8102000',harga_beli ='8102000' WHERE kode_barcode='00017626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7941500',harga_beli ='7941500' WHERE kode_barcode='00017628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6424500',harga_beli ='6424500' WHERE kode_barcode='00017636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4533000',harga_beli ='4533000' WHERE kode_barcode='00017662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5478500',harga_beli ='5478500' WHERE kode_barcode='00017663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10689500',harga_beli ='10689500' WHERE kode_barcode='00017681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10529000',harga_beli ='10529000' WHERE kode_barcode='00017697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4979000',harga_beli ='4979000' WHERE kode_barcode='00017698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5139500',harga_beli ='5139500' WHERE kode_barcode='00017717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2623500',harga_beli ='2623500' WHERE kode_barcode='00017759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2588000',harga_beli ='2588000' WHERE kode_barcode='00017760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10903500',harga_beli ='10903500' WHERE kode_barcode='00017900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='42150000',harga_beli ='42150000' WHERE kode_barcode='00017913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3658500',harga_beli ='3658500' WHERE kode_barcode='00017959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7138000',harga_beli ='7138000' WHERE kode_barcode='00017982' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10814500',harga_beli ='10814500' WHERE kode_barcode='00018019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7450000',harga_beli ='7450000' WHERE kode_barcode='00018036' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5514500',harga_beli ='5514500' WHERE kode_barcode='00018073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16524500',harga_beli ='16524500' WHERE kode_barcode='00018112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6032000',harga_beli ='6032000' WHERE kode_barcode='00018284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6103500',harga_beli ='6103500' WHERE kode_barcode='00018285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4907500',harga_beli ='4907500' WHERE kode_barcode='00018302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2427000',harga_beli ='2427000' WHERE kode_barcode='00018312' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2391500',harga_beli ='2391500' WHERE kode_barcode='00018337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7941500',harga_beli ='7941500' WHERE kode_barcode='00018371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8351500',harga_beli ='8351500' WHERE kode_barcode='00018463' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11617500',harga_beli ='11617500' WHERE kode_barcode='00018491' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4729000',harga_beli ='4729000' WHERE kode_barcode='00018517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5157500',harga_beli ='5157500' WHERE kode_barcode='00018519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6411500',harga_beli ='6411500' WHERE kode_barcode='00018718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3623000',harga_beli ='3623000' WHERE kode_barcode='00018891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4319000',harga_beli ='4319000' WHERE kode_barcode='00018924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3391000',harga_beli ='3391000' WHERE kode_barcode='00018925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4265000',harga_beli ='4265000' WHERE kode_barcode='00018927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3587000',harga_beli ='3587000' WHERE kode_barcode='00018937' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3640500',harga_beli ='3640500' WHERE kode_barcode='00019018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8851500',harga_beli ='8851500' WHERE kode_barcode='00019120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3337500',harga_beli ='3337500' WHERE kode_barcode='00019123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3480000',harga_beli ='3480000' WHERE kode_barcode='00019148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4408000',harga_beli ='4408000' WHERE kode_barcode='00019153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6210500',harga_beli ='6210500' WHERE kode_barcode='00019234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4693500',harga_beli ='4693500' WHERE kode_barcode='00019236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6228000',harga_beli ='6228000' WHERE kode_barcode='00019283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7673500',harga_beli ='7673500' WHERE kode_barcode='00019360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3908500',harga_beli ='3908500' WHERE kode_barcode='00019451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4533000',harga_beli ='4533000' WHERE kode_barcode='00019510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5889000',harga_beli ='5889000' WHERE kode_barcode='00019562' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5586000',harga_beli ='5586000' WHERE kode_barcode='00019563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5336000',harga_beli ='5336000' WHERE kode_barcode='00019564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7245500',harga_beli ='7245500' WHERE kode_barcode='00019652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5657000',harga_beli ='5657000' WHERE kode_barcode='00019655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3944000',harga_beli ='3944000' WHERE kode_barcode='00019656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8387500',harga_beli ='8387500' WHERE kode_barcode='00019742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3551500',harga_beli ='3551500' WHERE kode_barcode='00019840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5104000',harga_beli ='5104000' WHERE kode_barcode='00019911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5407500',harga_beli ='5407500' WHERE kode_barcode='00020018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6353000',harga_beli ='6353000' WHERE kode_barcode='00020068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5996000',harga_beli ='5996000' WHERE kode_barcode='00020069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6192500',harga_beli ='6192500' WHERE kode_barcode='00020070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5675000',harga_beli ='5675000' WHERE kode_barcode='00020071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6781500',harga_beli ='6781500' WHERE kode_barcode='00020074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5960500',harga_beli ='5960500' WHERE kode_barcode='00020075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6139000',harga_beli ='6139000' WHERE kode_barcode='00020076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4907500',harga_beli ='4907500' WHERE kode_barcode='00020077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5889000',harga_beli ='5889000' WHERE kode_barcode='00020080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8441000',harga_beli ='8441000' WHERE kode_barcode='00020156' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5782000',harga_beli ='5782000' WHERE kode_barcode='00020166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7067000',harga_beli ='7067000' WHERE kode_barcode='00020168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9618500',harga_beli ='9618500' WHERE kode_barcode='00020174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5122000',harga_beli ='5122000' WHERE kode_barcode='00020179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5229000',harga_beli ='5229000' WHERE kode_barcode='00020186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8780000',harga_beli ='8780000' WHERE kode_barcode='00020190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7084500',harga_beli ='7084500' WHERE kode_barcode='00020191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5193000',harga_beli ='5193000' WHERE kode_barcode='00020200' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='41086500',harga_beli ='41086500' WHERE kode_barcode='00020223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5675000',harga_beli ='5675000' WHERE kode_barcode='00020259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6192500',harga_beli ='6192500' WHERE kode_barcode='00020365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4247500',harga_beli ='4247500' WHERE kode_barcode='00020492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5068500',harga_beli ='5068500' WHERE kode_barcode='00020616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4675500',harga_beli ='4675500' WHERE kode_barcode='00020834' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4782500',harga_beli ='4782500' WHERE kode_barcode='00020846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6853000',harga_beli ='6853000' WHERE kode_barcode='00021113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7727000',harga_beli ='7727000' WHERE kode_barcode='00021253' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5639500',harga_beli ='5639500' WHERE kode_barcode='00021254' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5425000',harga_beli ='5425000' WHERE kode_barcode='00021280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7977000',harga_beli ='7977000' WHERE kode_barcode='00021405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4628000',harga_beli ='4628000' WHERE kode_barcode='00021475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3725000',harga_beli ='3725000' WHERE kode_barcode='00021503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='21446500',harga_beli ='21446500' WHERE kode_barcode='00021505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11874500',harga_beli ='11874500' WHERE kode_barcode='00021506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8533500',harga_beli ='8533500' WHERE kode_barcode='00021585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3431500',harga_beli ='3431500' WHERE kode_barcode='00021609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9820500',harga_beli ='9820500' WHERE kode_barcode='00021630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7314500',harga_beli ='7314500' WHERE kode_barcode='00021635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5478500',harga_beli ='5478500' WHERE kode_barcode='00021755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7495000',harga_beli ='7495000' WHERE kode_barcode='00021756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5817500',harga_beli ='5817500' WHERE kode_barcode='00021758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7727000',harga_beli ='7727000' WHERE kode_barcode='00021759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4800500',harga_beli ='4800500' WHERE kode_barcode='00021781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8387500',harga_beli ='8387500' WHERE kode_barcode='00021782' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6942000',harga_beli ='6942000' WHERE kode_barcode='00021783' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13883500',harga_beli ='13883500' WHERE kode_barcode='00021815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9922000',harga_beli ='9922000' WHERE kode_barcode='00021835' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10975000',harga_beli ='10975000' WHERE kode_barcode='00021844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3635000',harga_beli ='3635000' WHERE kode_barcode='00021867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3635000',harga_beli ='3635000' WHERE kode_barcode='00021876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4244500',harga_beli ='4244500' WHERE kode_barcode='00021878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13009500',harga_beli ='13009500' WHERE kode_barcode='00021882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9922000',harga_beli ='9922000' WHERE kode_barcode='00021905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3141000',harga_beli ='3141000' WHERE kode_barcode='00021950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4354500',harga_beli ='4354500' WHERE kode_barcode='00021976' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5300000',harga_beli ='5300000' WHERE kode_barcode='00021977' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4907500',harga_beli ='4907500' WHERE kode_barcode='00021979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4658000',harga_beli ='4658000' WHERE kode_barcode='00021980' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5925000',harga_beli ='5925000' WHERE kode_barcode='00022044' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5193000',harga_beli ='5193000' WHERE kode_barcode='00022045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6692000',harga_beli ='6692000' WHERE kode_barcode='00022046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4782500',harga_beli ='4782500' WHERE kode_barcode='00022071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5478500',harga_beli ='5478500' WHERE kode_barcode='00022114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6674500',harga_beli ='6674500' WHERE kode_barcode='00022140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5175500',harga_beli ='5175500' WHERE kode_barcode='00022141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4890000',harga_beli ='4890000' WHERE kode_barcode='00022142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4836500',harga_beli ='4836500' WHERE kode_barcode='00022143' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9279500',harga_beli ='9279500' WHERE kode_barcode='00022144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6186000',harga_beli ='6186000' WHERE kode_barcode='00022173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8104500',harga_beli ='8104500' WHERE kode_barcode='00022174' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8849500',harga_beli ='8849500' WHERE kode_barcode='00022176' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6411500',harga_beli ='6411500' WHERE kode_barcode='00022180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6366500',harga_beli ='6366500' WHERE kode_barcode='00022227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9119000',harga_beli ='9119000' WHERE kode_barcode='00022322' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11920000',harga_beli ='11920000' WHERE kode_barcode='00022356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6549500',harga_beli ='6549500' WHERE kode_barcode='00022433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6389000',harga_beli ='6389000' WHERE kode_barcode='00022442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4497000',harga_beli ='4497000' WHERE kode_barcode='00022450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4836500',harga_beli ='4836500' WHERE kode_barcode='00022468' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7299000',harga_beli ='7299000' WHERE kode_barcode='00022517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16615500',harga_beli ='16615500' WHERE kode_barcode='00022649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9654500',harga_beli ='9654500' WHERE kode_barcode='00022659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5125000',harga_beli ='5125000' WHERE kode_barcode='00022758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6434000',harga_beli ='6434000' WHERE kode_barcode='00022759' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4711500',harga_beli ='4711500' WHERE kode_barcode='00022763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6885500',harga_beli ='6885500' WHERE kode_barcode='00022765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10362000',harga_beli ='10362000' WHERE kode_barcode='00022774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9527000',harga_beli ='9527000' WHERE kode_barcode='00022806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6298500',harga_beli ='6298500' WHERE kode_barcode='00022808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8466000',harga_beli ='8466000' WHERE kode_barcode='00022809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4515000',harga_beli ='4515000' WHERE kode_barcode='00022822' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8059500',harga_beli ='8059500' WHERE kode_barcode='00022867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6276000',harga_beli ='6276000' WHERE kode_barcode='00022883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3373000',harga_beli ='3373000' WHERE kode_barcode='00022912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4818500',harga_beli ='4818500' WHERE kode_barcode='00022950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6460000',harga_beli ='6460000' WHERE kode_barcode='00023060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8172500',harga_beli ='8172500' WHERE kode_barcode='00023123' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4497000',harga_beli ='4497000' WHERE kode_barcode='00023126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8459000',harga_beli ='8459000' WHERE kode_barcode='00023146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5782000',harga_beli ='5782000' WHERE kode_barcode='00023437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6976000',harga_beli ='6976000' WHERE kode_barcode='00023488' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9690000',harga_beli ='9690000' WHERE kode_barcode='00023490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='39595500',harga_beli ='39595500' WHERE kode_barcode='00023493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='20263000',harga_beli ='20263000' WHERE kode_barcode='00023537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4015500',harga_beli ='4015500' WHERE kode_barcode='00023549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5318000',harga_beli ='5318000' WHERE kode_barcode='00023563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6567000',harga_beli ='6567000' WHERE kode_barcode='00023572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6335500',harga_beli ='6335500' WHERE kode_barcode='00023573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9047500',harga_beli ='9047500' WHERE kode_barcode='00023585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3480000',harga_beli ='3480000' WHERE kode_barcode='00023590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5736000',harga_beli ='5736000' WHERE kode_barcode='00023593' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5669500',harga_beli ='5669500' WHERE kode_barcode='00023594' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5625000',harga_beli ='5625000' WHERE kode_barcode='00023595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6264000',harga_beli ='6264000' WHERE kode_barcode='00023596' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8991000',harga_beli ='8991000' WHERE kode_barcode='00023600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8947000',harga_beli ='8947000' WHERE kode_barcode='00023602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6400000',harga_beli ='6400000' WHERE kode_barcode='00023604' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6954000',harga_beli ='6954000' WHERE kode_barcode='00023605' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11360500',harga_beli ='11360500' WHERE kode_barcode='00023606' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7419000',harga_beli ='7419000' WHERE kode_barcode='00023607' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9035500',harga_beli ='9035500' WHERE kode_barcode='00023608' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6422500',harga_beli ='6422500' WHERE kode_barcode='00023609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10054000',harga_beli ='10054000' WHERE kode_barcode='00023611' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9390000',harga_beli ='9390000' WHERE kode_barcode='00023612' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7485500',harga_beli ='7485500' WHERE kode_barcode='00023613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9412000',harga_beli ='9412000' WHERE kode_barcode='00023614' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5691500',harga_beli ='5691500' WHERE kode_barcode='00023617' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4854000',harga_beli ='4854000' WHERE kode_barcode='00023622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4429000',harga_beli ='4429000' WHERE kode_barcode='00023623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12063500',harga_beli ='12063500' WHERE kode_barcode='00023626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6103500',harga_beli ='6103500' WHERE kode_barcode='00023629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2712500',harga_beli ='2712500' WHERE kode_barcode='00023632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3587000',harga_beli ='3587000' WHERE kode_barcode='00023666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2052500',harga_beli ='2052500' WHERE kode_barcode='00023679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4729000',harga_beli ='4729000' WHERE kode_barcode='00023691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6460000',harga_beli ='6460000' WHERE kode_barcode='00023692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7656000',harga_beli ='7656000' WHERE kode_barcode='00023693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7656000',harga_beli ='7656000' WHERE kode_barcode='00023697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15944500',harga_beli ='15944500' WHERE kode_barcode='00023704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8708500',harga_beli ='8708500' WHERE kode_barcode='00023760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10807000',harga_beli ='10807000' WHERE kode_barcode='00023815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3730000',harga_beli ='3730000' WHERE kode_barcode='00023830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9904500',harga_beli ='9904500' WHERE kode_barcode='00023843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3986500',harga_beli ='3986500' WHERE kode_barcode='00023848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5264500',harga_beli ='5264500' WHERE kode_barcode='00023857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5782000',harga_beli ='5782000' WHERE kode_barcode='00023907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5603500',harga_beli ='5603500' WHERE kode_barcode='00023913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4872000',harga_beli ='4872000' WHERE kode_barcode='00023917' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5470000',harga_beli ='5470000' WHERE kode_barcode='00023920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5710500',harga_beli ='5710500' WHERE kode_barcode='00023934' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2766500',harga_beli ='2766500' WHERE kode_barcode='00023964' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7084500',harga_beli ='7084500' WHERE kode_barcode='00023965' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7839500',harga_beli ='7839500' WHERE kode_barcode='00023979' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4800500',harga_beli ='4800500' WHERE kode_barcode='00023985' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8102000',harga_beli ='8102000' WHERE kode_barcode='00023991' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5996000',harga_beli ='5996000' WHERE kode_barcode='00023997' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6549500',harga_beli ='6549500' WHERE kode_barcode='00023998' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6299500',harga_beli ='6299500' WHERE kode_barcode='00024000' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8334000',harga_beli ='8334000' WHERE kode_barcode='00024004' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4800500',harga_beli ='4800500' WHERE kode_barcode='00024013' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7662500',harga_beli ='7662500' WHERE kode_barcode='00024038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4675500',harga_beli ='4675500' WHERE kode_barcode='00024062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6728000',harga_beli ='6728000' WHERE kode_barcode='00024069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2909000',harga_beli ='2909000' WHERE kode_barcode='00024077' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3623000',harga_beli ='3623000' WHERE kode_barcode='00024082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4765000',harga_beli ='4765000' WHERE kode_barcode='00024085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4640000',harga_beli ='4640000' WHERE kode_barcode='00024086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3787000',harga_beli ='3787000' WHERE kode_barcode='00024095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6870500',harga_beli ='6870500' WHERE kode_barcode='00024096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6210500',harga_beli ='6210500' WHERE kode_barcode='00024104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7156000',harga_beli ='7156000' WHERE kode_barcode='00024148' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5532000',harga_beli ='5532000' WHERE kode_barcode='00024186' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5443000',harga_beli ='5443000' WHERE kode_barcode='00024189' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10261000',harga_beli ='10261000' WHERE kode_barcode='00024193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3962000',harga_beli ='3962000' WHERE kode_barcode='00024194' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5586000',harga_beli ='5586000' WHERE kode_barcode='00024363' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6424500',harga_beli ='6424500' WHERE kode_barcode='00025284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6853000',harga_beli ='6853000' WHERE kode_barcode='00025286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13009500',harga_beli ='13009500' WHERE kode_barcode='00025510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16560500',harga_beli ='16560500' WHERE kode_barcode='00026215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14195000',harga_beli ='14195000' WHERE kode_barcode='00026302' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7441500',harga_beli ='7441500' WHERE kode_barcode='00026725' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4533000',harga_beli ='4533000' WHERE kode_barcode='00026882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4961000',harga_beli ='4961000' WHERE kode_barcode='00026884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2837500',harga_beli ='2837500' WHERE kode_barcode='00026926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5068500',harga_beli ='5068500' WHERE kode_barcode='00026927' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8780000',harga_beli ='8780000' WHERE kode_barcode='00026952' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4907500',harga_beli ='4907500' WHERE kode_barcode='00027033' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9833000',harga_beli ='9833000' WHERE kode_barcode='00027034' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5139500',harga_beli ='5139500' WHERE kode_barcode='00027038' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4765000',harga_beli ='4765000' WHERE kode_barcode='00027050' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4568500',harga_beli ='4568500' WHERE kode_barcode='00027104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3176500',harga_beli ='3176500' WHERE kode_barcode='00027149' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15489500',harga_beli ='15489500' WHERE kode_barcode='00027177' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4158000',harga_beli ='4158000' WHERE kode_barcode='00027229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4693500',harga_beli ='4693500' WHERE kode_barcode='00027334' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4008500',harga_beli ='4008500' WHERE kode_barcode='00027480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11635000',harga_beli ='11635000' WHERE kode_barcode='00027482' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5913000',harga_beli ='5913000' WHERE kode_barcode='00027620' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1892000',harga_beli ='1892000' WHERE kode_barcode='00027795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5568000',harga_beli ='5568000' WHERE kode_barcode='00027901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7334500',harga_beli ='7334500' WHERE kode_barcode='00027945' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5935000',harga_beli ='5935000' WHERE kode_barcode='00028046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7495000',harga_beli ='7495000' WHERE kode_barcode='00028061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4461500',harga_beli ='4461500' WHERE kode_barcode='00028107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10778500',harga_beli ='10778500' WHERE kode_barcode='00028220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10652000',harga_beli ='10652000' WHERE kode_barcode='00028368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7264000',harga_beli ='7264000' WHERE kode_barcode='00028381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9743500',harga_beli ='9743500' WHERE kode_barcode='00028442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3233500',harga_beli ='3233500' WHERE kode_barcode='00028566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6995500',harga_beli ='6995500' WHERE kode_barcode='00028582' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5907000',harga_beli ='5907000' WHERE kode_barcode='00028682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4943500',harga_beli ='4943500' WHERE kode_barcode='00028692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8349000',harga_beli ='8349000' WHERE kode_barcode='00028772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4604500',harga_beli ='4604500' WHERE kode_barcode='00029136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3898000',harga_beli ='3898000' WHERE kode_barcode='00029506' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9030000',harga_beli ='9030000' WHERE kode_barcode='00029526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4872000',harga_beli ='4872000' WHERE kode_barcode='00029662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11604500',harga_beli ='11604500' WHERE kode_barcode='00030349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4265000',harga_beli ='4265000' WHERE kode_barcode='00030671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6555000',harga_beli ='6555000' WHERE kode_barcode='00030672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5536500',harga_beli ='5536500' WHERE kode_barcode='00030674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3277500',harga_beli ='3277500' WHERE kode_barcode='00030709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3322000',harga_beli ='3322000' WHERE kode_barcode='00030712' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3255500',harga_beli ='3255500' WHERE kode_barcode='00030714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3986500',harga_beli ='3986500' WHERE kode_barcode='00030716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3875500',harga_beli ='3875500' WHERE kode_barcode='00030719' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3610000',harga_beli ='3610000' WHERE kode_barcode='00030721' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5691500',harga_beli ='5691500' WHERE kode_barcode='00030821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4194000',harga_beli ='4194000' WHERE kode_barcode='00030827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1874000',harga_beli ='1874000' WHERE kode_barcode='00031061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1856000',harga_beli ='1856000' WHERE kode_barcode='00031062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1784500',harga_beli ='1784500' WHERE kode_barcode='00031064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2980500',harga_beli ='2980500' WHERE kode_barcode='00031066' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3587000',harga_beli ='3587000' WHERE kode_barcode='00031069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3284000',harga_beli ='3284000' WHERE kode_barcode='00031070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3248000',harga_beli ='3248000' WHERE kode_barcode='00031071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2746500',harga_beli ='2746500' WHERE kode_barcode='00031074' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5371500',harga_beli ='5371500' WHERE kode_barcode='00031112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7513000',harga_beli ='7513000' WHERE kode_barcode='00031113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5675000',harga_beli ='5675000' WHERE kode_barcode='00031114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3176500',harga_beli ='3176500' WHERE kode_barcode='00031115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2855500',harga_beli ='2855500' WHERE kode_barcode='00031116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7773000',harga_beli ='7773000' WHERE kode_barcode='00031117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='19201500',harga_beli ='19201500' WHERE kode_barcode='00031126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='17756000',harga_beli ='17756000' WHERE kode_barcode='00031175' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6174500',harga_beli ='6174500' WHERE kode_barcode='00031182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6865000',harga_beli ='6865000' WHERE kode_barcode='00031184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6090000',harga_beli ='6090000' WHERE kode_barcode='00031187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11139000',harga_beli ='11139000' WHERE kode_barcode='00031190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5248500',harga_beli ='5248500' WHERE kode_barcode='00031191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='30782000',harga_beli ='30782000' WHERE kode_barcode='00031203' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16277000',harga_beli ='16277000' WHERE kode_barcode='00031204' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5389500',harga_beli ='5389500' WHERE kode_barcode='00031267' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4640000',harga_beli ='4640000' WHERE kode_barcode='00031268' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7013500',harga_beli ='7013500' WHERE kode_barcode='00031269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6870500',harga_beli ='6870500' WHERE kode_barcode='00031270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4069000',harga_beli ='4069000' WHERE kode_barcode='00031272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4693500',harga_beli ='4693500' WHERE kode_barcode='00031274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5014500',harga_beli ='5014500' WHERE kode_barcode='00031276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6121000',harga_beli ='6121000' WHERE kode_barcode='00031277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4586500',harga_beli ='4586500' WHERE kode_barcode='00031278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4640000',harga_beli ='4640000' WHERE kode_barcode='00031279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4336500',harga_beli ='4336500' WHERE kode_barcode='00031280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5889000',harga_beli ='5889000' WHERE kode_barcode='00031282' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5800000',harga_beli ='5800000' WHERE kode_barcode='00031283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6139000',harga_beli ='6139000' WHERE kode_barcode='00031284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4176000',harga_beli ='4176000' WHERE kode_barcode='00031285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2909000',harga_beli ='2909000' WHERE kode_barcode='00031286' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3212500',harga_beli ='3212500' WHERE kode_barcode='00031287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5907000',harga_beli ='5907000' WHERE kode_barcode='00031332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5907000',harga_beli ='5907000' WHERE kode_barcode='00031333' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6638500',harga_beli ='6638500' WHERE kode_barcode='00031335' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3533500',harga_beli ='3533500' WHERE kode_barcode='00031337' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5300000',harga_beli ='5300000' WHERE kode_barcode='00031382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4890000',harga_beli ='4890000' WHERE kode_barcode='00031383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3783500',harga_beli ='3783500' WHERE kode_barcode='00031385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3765500',harga_beli ='3765500' WHERE kode_barcode='00031386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2498500',harga_beli ='2498500' WHERE kode_barcode='00031387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6246000',harga_beli ='6246000' WHERE kode_barcode='00031390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4533000',harga_beli ='4533000' WHERE kode_barcode='00031391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2927000',harga_beli ='2927000' WHERE kode_barcode='00031392' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4479500',harga_beli ='4479500' WHERE kode_barcode='00031394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6478000',harga_beli ='6478000' WHERE kode_barcode='00031396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5371500',harga_beli ='5371500' WHERE kode_barcode='00031397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5925000',harga_beli ='5925000' WHERE kode_barcode='00031399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6567000',harga_beli ='6567000' WHERE kode_barcode='00031400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7602000',harga_beli ='7602000' WHERE kode_barcode='00031401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5817500',harga_beli ='5817500' WHERE kode_barcode='00031402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4265000',harga_beli ='4265000' WHERE kode_barcode='00031404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4693500',harga_beli ='4693500' WHERE kode_barcode='00031406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4675500',harga_beli ='4675500' WHERE kode_barcode='00031407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5942500',harga_beli ='5942500' WHERE kode_barcode='00031409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5443000',harga_beli ='5443000' WHERE kode_barcode='00031410' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6638500',harga_beli ='6638500' WHERE kode_barcode='00031411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4836500',harga_beli ='4836500' WHERE kode_barcode='00031413' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3194500',harga_beli ='3194500' WHERE kode_barcode='00031414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6995500',harga_beli ='6995500' WHERE kode_barcode='00031415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4782500',harga_beli ='4782500' WHERE kode_barcode='00031416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7013500',harga_beli ='7013500' WHERE kode_barcode='00031454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5318000',harga_beli ='5318000' WHERE kode_barcode='00031455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7352500',harga_beli ='7352500' WHERE kode_barcode='00031457' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8102000',harga_beli ='8102000' WHERE kode_barcode='00031459' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6389000',harga_beli ='6389000' WHERE kode_barcode='00031461' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2427000',harga_beli ='2427000' WHERE kode_barcode='00031477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7751000',harga_beli ='7751000' WHERE kode_barcode='00031492' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6178500',harga_beli ='6178500' WHERE kode_barcode='00031493' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4979000',harga_beli ='4979000' WHERE kode_barcode='00031494' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3926000',harga_beli ='3926000' WHERE kode_barcode='00031495' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4479500',harga_beli ='4479500' WHERE kode_barcode='00031496' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6067500',harga_beli ='6067500' WHERE kode_barcode='00031498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5871500',harga_beli ='5871500' WHERE kode_barcode='00031502' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7299000',harga_beli ='7299000' WHERE kode_barcode='00031503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5853500',harga_beli ='5853500' WHERE kode_barcode='00031504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4426000',harga_beli ='4426000' WHERE kode_barcode='00031514' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6567000',harga_beli ='6567000' WHERE kode_barcode='00031515' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5780000',harga_beli ='5780000' WHERE kode_barcode='00031516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3942000',harga_beli ='3942000' WHERE kode_barcode='00031517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1550500',harga_beli ='1550500' WHERE kode_barcode='00031518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6267500',harga_beli ='6267500' WHERE kode_barcode='00031521' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5492000',harga_beli ='5492000' WHERE kode_barcode='00031522' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8327000',harga_beli ='8327000' WHERE kode_barcode='00031523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2677000',harga_beli ='2677000' WHERE kode_barcode='00031533' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2659000',harga_beli ='2659000' WHERE kode_barcode='00031534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13176500',harga_beli ='13176500' WHERE kode_barcode='00031558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4363000',harga_beli ='4363000' WHERE kode_barcode='00031563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1550500',harga_beli ='1550500' WHERE kode_barcode='00031564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5647500',harga_beli ='5647500' WHERE kode_barcode='00031565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4894500',harga_beli ='4894500' WHERE kode_barcode='00031566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3676500',harga_beli ='3676500' WHERE kode_barcode='00031568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5675000',harga_beli ='5675000' WHERE kode_barcode='00031584' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00031585' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6688000',harga_beli ='6688000' WHERE kode_barcode='00031588' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2962500',harga_beli ='2962500' WHERE kode_barcode='00031590' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3658500',harga_beli ='3658500' WHERE kode_barcode='00031591' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5568000',harga_beli ='5568000' WHERE kode_barcode='00031595' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3189000',harga_beli ='3189000' WHERE kode_barcode='00031599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2923500',harga_beli ='2923500' WHERE kode_barcode='00031600' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9146000',harga_beli ='9146000' WHERE kode_barcode='00031613' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8227000',harga_beli ='8227000' WHERE kode_barcode='00031616' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2052500',harga_beli ='2052500' WHERE kode_barcode='00031618' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4872000',harga_beli ='4872000' WHERE kode_barcode='00031619' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3319500',harga_beli ='3319500' WHERE kode_barcode='00031633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3391000',harga_beli ='3391000' WHERE kode_barcode='00031634' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15590500',harga_beli ='15590500' WHERE kode_barcode='00031636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2680000',harga_beli ='2680000' WHERE kode_barcode='00031637' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4568500',harga_beli ='4568500' WHERE kode_barcode='00031658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6909500',harga_beli ='6909500' WHERE kode_barcode='00031747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5728500',harga_beli ='5728500' WHERE kode_barcode='00031754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14901000',harga_beli ='14901000' WHERE kode_barcode='00031755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2998000',harga_beli ='2998000' WHERE kode_barcode='00031756' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6112500',harga_beli ='6112500' WHERE kode_barcode='00031818' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4961000',harga_beli ='4961000' WHERE kode_barcode='00031819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5160000',harga_beli ='5160000' WHERE kode_barcode='00031820' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7751000',harga_beli ='7751000' WHERE kode_barcode='00031821' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2820000',harga_beli ='2820000' WHERE kode_barcode='00031823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7042500',harga_beli ='7042500' WHERE kode_barcode='00031824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6246000',harga_beli ='6246000' WHERE kode_barcode='00031825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00031826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2259000',harga_beli ='2259000' WHERE kode_barcode='00031829' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3373000',harga_beli ='3373000' WHERE kode_barcode='00031855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3819000',harga_beli ='3819000' WHERE kode_barcode='00031856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5802500',harga_beli ='5802500' WHERE kode_barcode='00031857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9057500',harga_beli ='9057500' WHERE kode_barcode='00031895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6585000',harga_beli ='6585000' WHERE kode_barcode='00031896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6371000',harga_beli ='6371000' WHERE kode_barcode='00031897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5425000',harga_beli ='5425000' WHERE kode_barcode='00031905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6067500',harga_beli ='6067500' WHERE kode_barcode='00031911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3962000',harga_beli ='3962000' WHERE kode_barcode='00031913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='19130000',harga_beli ='19130000' WHERE kode_barcode='00031914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2766500',harga_beli ='2766500' WHERE kode_barcode='00031968' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15204000',harga_beli ='15204000' WHERE kode_barcode='00031969' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00032093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5817500',harga_beli ='5817500' WHERE kode_barcode='00032094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2356000',harga_beli ='2356000' WHERE kode_barcode='00032198' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2248500',harga_beli ='2248500' WHERE kode_barcode='00032209' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1838500',harga_beli ='1838500' WHERE kode_barcode='00032211' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3319500',harga_beli ='3319500' WHERE kode_barcode='00032213' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1927500',harga_beli ='1927500' WHERE kode_barcode='00032215' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='22039000',harga_beli ='22039000' WHERE kode_barcode='00032356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15115000',harga_beli ='15115000' WHERE kode_barcode='00032357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2373500',harga_beli ='2373500' WHERE kode_barcode='00032358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4408000',harga_beli ='4408000' WHERE kode_barcode='00032360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3194500',harga_beli ='3194500' WHERE kode_barcode='00032361' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3926000',harga_beli ='3926000' WHERE kode_barcode='00032362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4015500',harga_beli ='4015500' WHERE kode_barcode='00032364' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1874000',harga_beli ='1874000' WHERE kode_barcode='00032365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5461000',harga_beli ='5461000' WHERE kode_barcode='00032370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2730500',harga_beli ='2730500' WHERE kode_barcode='00032372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14669000',harga_beli ='14669000' WHERE kode_barcode='00032375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3433000',harga_beli ='3433000' WHERE kode_barcode='00032376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1981000',harga_beli ='1981000' WHERE kode_barcode='00032377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3016000',harga_beli ='3016000' WHERE kode_barcode='00032379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8869000',harga_beli ='8869000' WHERE kode_barcode='00032381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2712500',harga_beli ='2712500' WHERE kode_barcode='00032479' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5996000',harga_beli ='5996000' WHERE kode_barcode='00032498' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7067000',harga_beli ='7067000' WHERE kode_barcode='00032499' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10136000',harga_beli ='10136000' WHERE kode_barcode='00032501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5448000',harga_beli ='5448000' WHERE kode_barcode='00032504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12379500',harga_beli ='12379500' WHERE kode_barcode='00032505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5669500',harga_beli ='5669500' WHERE kode_barcode='00032507' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6909500',harga_beli ='6909500' WHERE kode_barcode='00032509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6422500',harga_beli ='6422500' WHERE kode_barcode='00032513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='26375000',harga_beli ='26375000' WHERE kode_barcode='00032523' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4051000',harga_beli ='4051000' WHERE kode_barcode='00032602' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3248000',harga_beli ='3248000' WHERE kode_barcode='00032648' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10261000',harga_beli ='10261000' WHERE kode_barcode='00032649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6954000',harga_beli ='6954000' WHERE kode_barcode='00032667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1838500',harga_beli ='1838500' WHERE kode_barcode='00032668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8476500',harga_beli ='8476500' WHERE kode_barcode='00032670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14439000',harga_beli ='14439000' WHERE kode_barcode='00033184' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5996000',harga_beli ='5996000' WHERE kode_barcode='00033220' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4925500',harga_beli ='4925500' WHERE kode_barcode='00033261' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2320000',harga_beli ='2320000' WHERE kode_barcode='00033262' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2373500',harga_beli ='2373500' WHERE kode_barcode='00033263' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2177500',harga_beli ='2177500' WHERE kode_barcode='00033264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6909500',harga_beli ='6909500' WHERE kode_barcode='00033289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1981000',harga_beli ='1981000' WHERE kode_barcode='00033347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='19558500',harga_beli ='19558500' WHERE kode_barcode='00033485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4461500',harga_beli ='4461500' WHERE kode_barcode='00033537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3515500',harga_beli ='3515500' WHERE kode_barcode='00034068' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3176500',harga_beli ='3176500' WHERE kode_barcode='00034069' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4301000',harga_beli ='4301000' WHERE kode_barcode='00034070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00034071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2909000',harga_beli ='2909000' WHERE kode_barcode='00034073' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3052000',harga_beli ='3052000' WHERE kode_barcode='00034075' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1660000',harga_beli ='1660000' WHERE kode_barcode='00034076' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3176500',harga_beli ='3176500' WHERE kode_barcode='00034080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4551000',harga_beli ='4551000' WHERE kode_barcode='00034142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6567000',harga_beli ='6567000' WHERE kode_barcode='00034164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00034166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3391000',harga_beli ='3391000' WHERE kode_barcode='00034167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='20718500',harga_beli ='20718500' WHERE kode_barcode='00034249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2677000',harga_beli ='2677000' WHERE kode_barcode='00034338' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2677000',harga_beli ='2677000' WHERE kode_barcode='00034343' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4765000',harga_beli ='4765000' WHERE kode_barcode='00034347' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2802000',harga_beli ='2802000' WHERE kode_barcode='00034348' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4854000',harga_beli ='4854000' WHERE kode_barcode='00034349' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1963000',harga_beli ='1963000' WHERE kode_barcode='00034351' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7370500',harga_beli ='7370500' WHERE kode_barcode='00034354' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2748500',harga_beli ='2748500' WHERE kode_barcode='00034355' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4515000',harga_beli ='4515000' WHERE kode_barcode='00034356' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3997500',harga_beli ='3997500' WHERE kode_barcode='00034357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2427000',harga_beli ='2427000' WHERE kode_barcode='00034365' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1981000',harga_beli ='1981000' WHERE kode_barcode='00034368' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1820500',harga_beli ='1820500' WHERE kode_barcode='00034369' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1981000',harga_beli ='1981000' WHERE kode_barcode='00034370' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2106000',harga_beli ='2106000' WHERE kode_barcode='00034371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3872500',harga_beli ='3872500' WHERE kode_barcode='00034372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2820000',harga_beli ='2820000' WHERE kode_barcode='00034373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2784000',harga_beli ='2784000' WHERE kode_barcode='00034374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8316000',harga_beli ='8316000' WHERE kode_barcode='00034381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10761000',harga_beli ='10761000' WHERE kode_barcode='00034490' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3853500',harga_beli ='3853500' WHERE kode_barcode='00034661' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5403500',harga_beli ='5403500' WHERE kode_barcode='00034679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1802500',harga_beli ='1802500' WHERE kode_barcode='00034780' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2124000',harga_beli ='2124000' WHERE kode_barcode='00034781' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3521500',harga_beli ='3521500' WHERE kode_barcode='00035018' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2480500',harga_beli ='2480500' WHERE kode_barcode='00035045' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6638500',harga_beli ='6638500' WHERE kode_barcode='00035046' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3230000',harga_beli ='3230000' WHERE kode_barcode='00035171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9815000',harga_beli ='9815000' WHERE kode_barcode='00035278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5353500',harga_beli ='5353500' WHERE kode_barcode='00035477' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3944000',harga_beli ='3944000' WHERE kode_barcode='00035519' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1017500',harga_beli ='1017500' WHERE kode_barcode='00035951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1035500',harga_beli ='1035500' WHERE kode_barcode='00036006' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9390000',harga_beli ='9390000' WHERE kode_barcode='00036172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='821000',harga_beli ='821000' WHERE kode_barcode='00036243' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='803500',harga_beli ='803500' WHERE kode_barcode='00036244' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='750000',harga_beli ='750000' WHERE kode_barcode='00036245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1784500',harga_beli ='1784500' WHERE kode_barcode='00036432' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2855500',harga_beli ='2855500' WHERE kode_barcode='00036686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00036809' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4586500',harga_beli ='4586500' WHERE kode_barcode='00036823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5407500',harga_beli ='5407500' WHERE kode_barcode='00036824' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4211500',harga_beli ='4211500' WHERE kode_barcode='00036825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4604500',harga_beli ='4604500' WHERE kode_barcode='00036826' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00036827' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2320000',harga_beli ='2320000' WHERE kode_barcode='00036828' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00036830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00036831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3801500',harga_beli ='3801500' WHERE kode_barcode='00036832' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1927000',harga_beli ='1927000' WHERE kode_barcode='00036947' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4051000',harga_beli ='4051000' WHERE kode_barcode='00036992' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1784500',harga_beli ='1784500' WHERE kode_barcode='00036993' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3730000',harga_beli ='3730000' WHERE kode_barcode='00037325' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5371500',harga_beli ='5371500' WHERE kode_barcode='00037332' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5835500',harga_beli ='5835500' WHERE kode_barcode='00037825' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3194500',harga_beli ='3194500' WHERE kode_barcode='00037907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3765000',harga_beli ='3765000' WHERE kode_barcode='00038024' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4890000',harga_beli ='4890000' WHERE kode_barcode='00038455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2806000',harga_beli ='2806000' WHERE kode_barcode='00038609' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4693500',harga_beli ='4693500' WHERE kode_barcode='00038671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2623500',harga_beli ='2623500' WHERE kode_barcode='00038672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2284500',harga_beli ='2284500' WHERE kode_barcode='00038673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2498500',harga_beli ='2498500' WHERE kode_barcode='00038674' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5425000',harga_beli ='5425000' WHERE kode_barcode='00038716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5869500',harga_beli ='5869500' WHERE kode_barcode='00038720' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8244500',harga_beli ='8244500' WHERE kode_barcode='00038819' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3462000',harga_beli ='3462000' WHERE kode_barcode='00038823' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4586500',harga_beli ='4586500' WHERE kode_barcode='00038843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3211500',harga_beli ='3211500' WHERE kode_barcode='00038862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7031000',harga_beli ='7031000' WHERE kode_barcode='00038959' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1419000',harga_beli ='1419000' WHERE kode_barcode='00039028' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4563500',harga_beli ='4563500' WHERE kode_barcode='00039058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3052000',harga_beli ='3052000' WHERE kode_barcode='00039178' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2891000',harga_beli ='2891000' WHERE kode_barcode='00039179' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2338000',harga_beli ='2338000' WHERE kode_barcode='00039180' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1856000',harga_beli ='1856000' WHERE kode_barcode='00039181' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2052500',harga_beli ='2052500' WHERE kode_barcode='00039182' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5461000',harga_beli ='5461000' WHERE kode_barcode='00039192' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4907500',harga_beli ='4907500' WHERE kode_barcode='00039193' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3034000',harga_beli ='3034000' WHERE kode_barcode='00039194' LIMIT 1;
UPDATE tm_barang_titip SET harga_skrg ='2150000',harga_jual='4015500',harga_beli ='4015500' WHERE kode_barcode='00021123' LIMIT 1;
UPDATE tm_barang_titip SET harga_skrg ='2150000',harga_jual='9414000',harga_beli ='9414000' WHERE kode_barcode='00023133' LIMIT 1;
UPDATE tm_barang_titip SET harga_skrg ='2150000',harga_jual='4818500',harga_beli ='4818500' WHERE kode_barcode='00027940' LIMIT 1;
UPDATE tm_group SET harga='2150000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2150000','kasir','2025-10-28 11:36:22');
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2083500',harga_beli ='2083500' WHERE kode_barcode='00019926' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2193000',harga_beli ='2193000' WHERE kode_barcode='00019929' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2193000',harga_beli ='2193000' WHERE kode_barcode='00019933' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6707000',harga_beli ='6707000' WHERE kode_barcode='00024887' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6871500',harga_beli ='6871500' WHERE kode_barcode='00024889' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5574000',harga_beli ='5574000' WHERE kode_barcode='00024890' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5537500',harga_beli ='5537500' WHERE kode_barcode='00024891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5537500',harga_beli ='5537500' WHERE kode_barcode='00024892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5519500',harga_beli ='5519500' WHERE kode_barcode='00024893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5519500',harga_beli ='5519500' WHERE kode_barcode='00024895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5556000',harga_beli ='5556000' WHERE kode_barcode='00024896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5537500',harga_beli ='5537500' WHERE kode_barcode='00024897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5464500',harga_beli ='5464500' WHERE kode_barcode='00024898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5482500',harga_beli ='5482500' WHERE kode_barcode='00024899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5556000',harga_beli ='5556000' WHERE kode_barcode='00024900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5537500',harga_beli ='5537500' WHERE kode_barcode='00024901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5537500',harga_beli ='5537500' WHERE kode_barcode='00024902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5501000',harga_beli ='5501000' WHERE kode_barcode='00024903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5519500',harga_beli ='5519500' WHERE kode_barcode='00024904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5519500',harga_beli ='5519500' WHERE kode_barcode='00024905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3911000',harga_beli ='3911000' WHERE kode_barcode='00024909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4021000',harga_beli ='4021000' WHERE kode_barcode='00024912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3929500',harga_beli ='3929500' WHERE kode_barcode='00024919' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3929500',harga_beli ='3929500' WHERE kode_barcode='00024920' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3984000',harga_beli ='3984000' WHERE kode_barcode='00024922' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3911000',harga_beli ='3911000' WHERE kode_barcode='00024923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15944500',harga_beli ='15944500' WHERE kode_barcode='00025675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16650000',harga_beli ='16650000' WHERE kode_barcode='00025676' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='17145000',harga_beli ='17145000' WHERE kode_barcode='00025677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14696000',harga_beli ='14696000' WHERE kode_barcode='00025678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14896500',harga_beli ='14896500' WHERE kode_barcode='00025679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='25591500',harga_beli ='25591500' WHERE kode_barcode='00025682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15848000',harga_beli ='15848000' WHERE kode_barcode='00025683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='18695500',harga_beli ='18695500' WHERE kode_barcode='00025684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8237000',harga_beli ='8237000' WHERE kode_barcode='00025687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15625000',harga_beli ='15625000' WHERE kode_barcode='00025697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6026500',harga_beli ='6026500' WHERE kode_barcode='00025699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10291500',harga_beli ='10291500' WHERE kode_barcode='00025701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10272000',harga_beli ='10272000' WHERE kode_barcode='00025702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3424000',harga_beli ='3424000' WHERE kode_barcode='00025706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3796000',harga_beli ='3796000' WHERE kode_barcode='00025711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4050000',harga_beli ='4050000' WHERE kode_barcode='00025714' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12052500',harga_beli ='12052500' WHERE kode_barcode='00025716' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6065500',harga_beli ='6065500' WHERE kode_barcode='00025717' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4383000',harga_beli ='4383000' WHERE kode_barcode='00025718' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5439500',harga_beli ='5439500' WHERE kode_barcode='00025723' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3600000',harga_beli ='3600000' WHERE kode_barcode='00025724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1448000',harga_beli ='1448000' WHERE kode_barcode='00025726' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1428500',harga_beli ='1428500' WHERE kode_barcode='00025727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4658000',harga_beli ='4658000' WHERE kode_barcode='00025730' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3330000',harga_beli ='3330000' WHERE kode_barcode='00025734' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6135500',harga_beli ='6135500' WHERE kode_barcode='00025735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3236000',harga_beli ='3236000' WHERE kode_barcode='00025737' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1945500',harga_beli ='1945500' WHERE kode_barcode='00025739' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9398000',harga_beli ='9398000' WHERE kode_barcode='00025740' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4695000',harga_beli ='4695000' WHERE kode_barcode='00025742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5686500',harga_beli ='5686500' WHERE kode_barcode='00025743' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4732500',harga_beli ='4732500' WHERE kode_barcode='00025744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2469500',harga_beli ='2469500' WHERE kode_barcode='00025745' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='17874500',harga_beli ='17874500' WHERE kode_barcode='00025747' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='45079000',harga_beli ='45079000' WHERE kode_barcode='00025795' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='19989000',harga_beli ='19989000' WHERE kode_barcode='00025796' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='41676500',harga_beli ='41676500' WHERE kode_barcode='00025797' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14925500',harga_beli ='14925500' WHERE kode_barcode='00025798' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='18255500',harga_beli ='18255500' WHERE kode_barcode='00025799' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14543000',harga_beli ='14543000' WHERE kode_barcode='00025800' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5428000',harga_beli ='5428000' WHERE kode_barcode='00025877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5282000',harga_beli ='5282000' WHERE kode_barcode='00025880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3911000',harga_beli ='3911000' WHERE kode_barcode='00025882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4587500',harga_beli ='4587500' WHERE kode_barcode='00025883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4863500',harga_beli ='4863500' WHERE kode_barcode='00025888' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='25682000',harga_beli ='25682000' WHERE kode_barcode='00025892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11568500',harga_beli ='11568500' WHERE kode_barcode='00025893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9284000',harga_beli ='9284000' WHERE kode_barcode='00025894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11787500',harga_beli ='11787500' WHERE kode_barcode='00025896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4408000',harga_beli ='4408000' WHERE kode_barcode='00026055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00026056' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3069500',harga_beli ='3069500' WHERE kode_barcode='00026058' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4015500',harga_beli ='4015500' WHERE kode_barcode='00026059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3480000',harga_beli ='3480000' WHERE kode_barcode='00026060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5190500',harga_beli ='5190500' WHERE kode_barcode='00026061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3618500',harga_beli ='3618500' WHERE kode_barcode='00026062' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3472500',harga_beli ='3472500' WHERE kode_barcode='00026064' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3436000',harga_beli ='3436000' WHERE kode_barcode='00026065' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2723500',harga_beli ='2723500' WHERE kode_barcode='00026070' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2705000',harga_beli ='2705000' WHERE kode_barcode='00026071' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4715000',harga_beli ='4715000' WHERE kode_barcode='00026072' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7146000',harga_beli ='7146000' WHERE kode_barcode='00026078' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10910500',harga_beli ='10910500' WHERE kode_barcode='00026079' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='00026080' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2120000',harga_beli ='2120000' WHERE kode_barcode='00026081' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4587500',harga_beli ='4587500' WHERE kode_barcode='00026082' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3479500',harga_beli ='3479500' WHERE kode_barcode='00026085' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14346000',harga_beli ='14346000' WHERE kode_barcode='00026086' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12939000',harga_beli ='12939000' WHERE kode_barcode='00026087' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='52066000',harga_beli ='52066000' WHERE kode_barcode='00026090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='54569500',harga_beli ='54569500' WHERE kode_barcode='00026091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10417000',harga_beli ='10417000' WHERE kode_barcode='00026093' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='20029500',harga_beli ='20029500' WHERE kode_barcode='00026095' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16356500',harga_beli ='16356500' WHERE kode_barcode='00026096' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11458500',harga_beli ='11458500' WHERE kode_barcode='00026097' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4569000',harga_beli ='4569000' WHERE kode_barcode='00026099' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3414500',harga_beli ='3414500' WHERE kode_barcode='00026104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5113000',harga_beli ='5113000' WHERE kode_barcode='00026105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3414500',harga_beli ='3414500' WHERE kode_barcode='00026106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3516000',harga_beli ='3516000' WHERE kode_barcode='00026107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4579500',harga_beli ='4579500' WHERE kode_barcode='00026108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3380500',harga_beli ='3380500' WHERE kode_barcode='00026109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3145000',harga_beli ='3145000' WHERE kode_barcode='00026110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3431000',harga_beli ='3431000' WHERE kode_barcode='00026111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4503500',harga_beli ='4503500' WHERE kode_barcode='00026112' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5163500',harga_beli ='5163500' WHERE kode_barcode='00026113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5062000',harga_beli ='5062000' WHERE kode_barcode='00026114' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3397000',harga_beli ='3397000' WHERE kode_barcode='00026115' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3740000',harga_beli ='3740000' WHERE kode_barcode='00026117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3790500',harga_beli ='3790500' WHERE kode_barcode='00026118' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2985500',harga_beli ='2985500' WHERE kode_barcode='00026119' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2549500',harga_beli ='2549500' WHERE kode_barcode='00026120' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2566000',harga_beli ='2566000' WHERE kode_barcode='00026121' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='46702000',harga_beli ='46702000' WHERE kode_barcode='00026125' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7304000',harga_beli ='7304000' WHERE kode_barcode='00026126' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5920000',harga_beli ='5920000' WHERE kode_barcode='00026127' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6825500',harga_beli ='6825500' WHERE kode_barcode='00026132' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8887000',harga_beli ='8887000' WHERE kode_barcode='00026140' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4845000',harga_beli ='4845000' WHERE kode_barcode='00026141' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4863500',harga_beli ='4863500' WHERE kode_barcode='00026142' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3765000',harga_beli ='3765000' WHERE kode_barcode='00026145' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2339500',harga_beli ='2339500' WHERE kode_barcode='00026146' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4863500',harga_beli ='4863500' WHERE kode_barcode='00026147' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9030000',harga_beli ='9030000' WHERE kode_barcode='00026152' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12214500',harga_beli ='12214500' WHERE kode_barcode='00026469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6659500',harga_beli ='6659500' WHERE kode_barcode='00026471' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3236000',harga_beli ='3236000' WHERE kode_barcode='00026472' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3535500',harga_beli ='3535500' WHERE kode_barcode='00026475' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='23699500',harga_beli ='23699500' WHERE kode_barcode='00026480' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='25009000',harga_beli ='25009000' WHERE kode_barcode='00026481' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8679500',harga_beli ='8679500' WHERE kode_barcode='00026484' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3666500',harga_beli ='3666500' WHERE kode_barcode='00026485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3891000',harga_beli ='3891000' WHERE kode_barcode='00026486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3853500',harga_beli ='3853500' WHERE kode_barcode='00026487' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5705500',harga_beli ='5705500' WHERE kode_barcode='00026525' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6696500',harga_beli ='6696500' WHERE kode_barcode='00026526' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3236000',harga_beli ='3236000' WHERE kode_barcode='00026527' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3778500',harga_beli ='3778500' WHERE kode_barcode='00026529' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3199000',harga_beli ='3199000' WHERE kode_barcode='00026534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12439000',harga_beli ='12439000' WHERE kode_barcode='00026537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8380000',harga_beli ='8380000' WHERE kode_barcode='00026538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14141500',harga_beli ='14141500' WHERE kode_barcode='00026553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8754000',harga_beli ='8754000' WHERE kode_barcode='00026557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13542500',harga_beli ='13542500' WHERE kode_barcode='00026560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3778500',harga_beli ='3778500' WHERE kode_barcode='00026561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3816000',harga_beli ='3816000' WHERE kode_barcode='00026563' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7456500',harga_beli ='7456500' WHERE kode_barcode='00026653' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2047000',harga_beli ='2047000' WHERE kode_barcode='00026654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3052000',harga_beli ='3052000' WHERE kode_barcode='00026655' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3143500',harga_beli ='3143500' WHERE kode_barcode='00026656' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3618500',harga_beli ='3618500' WHERE kode_barcode='00026658' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2083500',harga_beli ='2083500' WHERE kode_barcode='00026659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4258500',harga_beli ='4258500' WHERE kode_barcode='00026660' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2997500',harga_beli ='2997500' WHERE kode_barcode='00026662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3947500',harga_beli ='3947500' WHERE kode_barcode='00026665' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4678500',harga_beli ='4678500' WHERE kode_barcode='00026666' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3783000',harga_beli ='3783000' WHERE kode_barcode='00026668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4158000',harga_beli ='4158000' WHERE kode_barcode='00026669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8637500',harga_beli ='8637500' WHERE kode_barcode='00026671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3587000',harga_beli ='3587000' WHERE kode_barcode='00026672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3301500',harga_beli ='3301500' WHERE kode_barcode='00026677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5193000',harga_beli ='5193000' WHERE kode_barcode='00026678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4751500',harga_beli ='4751500' WHERE kode_barcode='00026679' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2522000',harga_beli ='2522000' WHERE kode_barcode='00026680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4331500',harga_beli ='4331500' WHERE kode_barcode='00026681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3034000',harga_beli ='3034000' WHERE kode_barcode='00026683' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2686500',harga_beli ='2686500' WHERE kode_barcode='00026684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2924000',harga_beli ='2924000' WHERE kode_barcode='00026686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3966000',harga_beli ='3966000' WHERE kode_barcode='00026689' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4313000',harga_beli ='4313000' WHERE kode_barcode='00026691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8918500',harga_beli ='8918500' WHERE kode_barcode='00026693' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5117000',harga_beli ='5117000' WHERE kode_barcode='00026697' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4021000',harga_beli ='4021000' WHERE kode_barcode='00026699' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3746500',harga_beli ='3746500' WHERE kode_barcode='00026702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4825000',harga_beli ='4825000' WHERE kode_barcode='00026708' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3820000',harga_beli ='3820000' WHERE kode_barcode='00026709' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4331500',harga_beli ='4331500' WHERE kode_barcode='00026710' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2558500',harga_beli ='2558500' WHERE kode_barcode='00026711' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3928500',harga_beli ='3928500' WHERE kode_barcode='00027627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11429000',harga_beli ='11429000' WHERE kode_barcode='00027630' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14122500',harga_beli ='14122500' WHERE kode_barcode='00027632' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13000500',harga_beli ='13000500' WHERE kode_barcode='00027633' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='21099500',harga_beli ='21099500' WHERE kode_barcode='00027635' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='22801500',harga_beli ='22801500' WHERE kode_barcode='00027636' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13748500',harga_beli ='13748500' WHERE kode_barcode='00027638' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8642000',harga_beli ='8642000' WHERE kode_barcode='00027643' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9858000',harga_beli ='9858000' WHERE kode_barcode='00027645' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13093500',harga_beli ='13093500' WHERE kode_barcode='00027646' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10288000',harga_beli ='10288000' WHERE kode_barcode='00027647' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7108000',harga_beli ='7108000' WHERE kode_barcode='00027649' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5799000',harga_beli ='5799000' WHERE kode_barcode='00027650' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16460500',harga_beli ='16460500' WHERE kode_barcode='00027652' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='20108000',harga_beli ='20108000' WHERE kode_barcode='00027654' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6913000',harga_beli ='6913000' WHERE kode_barcode='00027657' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3122000',harga_beli ='3122000' WHERE kode_barcode='00027659' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4541000',harga_beli ='4541000' WHERE kode_barcode='00027662' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4995000',harga_beli ='4995000' WHERE kode_barcode='00027663' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5090000',harga_beli ='5090000' WHERE kode_barcode='00027664' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3587000',harga_beli ='3587000' WHERE kode_barcode='00027667' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10669000',harga_beli ='10669000' WHERE kode_barcode='00027668' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5251500',harga_beli ='5251500' WHERE kode_barcode='00027669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14533500',harga_beli ='14533500' WHERE kode_barcode='00027671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15180500',harga_beli ='15180500' WHERE kode_barcode='00027672' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8324000',harga_beli ='8324000' WHERE kode_barcode='00027678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4770000',harga_beli ='4770000' WHERE kode_barcode='00027680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11864000',harga_beli ='11864000' WHERE kode_barcode='00027681' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4879500',harga_beli ='4879500' WHERE kode_barcode='00027682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2814500',harga_beli ='2814500' WHERE kode_barcode='00027687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3655000',harga_beli ='3655000' WHERE kode_barcode='00027688' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14332500',harga_beli ='14332500' WHERE kode_barcode='00027690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12763500',harga_beli ='12763500' WHERE kode_barcode='00027691' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13528500',harga_beli ='13528500' WHERE kode_barcode='00027692' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16915500',harga_beli ='16915500' WHERE kode_barcode='00027694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3367000',harga_beli ='3367000' WHERE kode_barcode='00029700' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6982000',harga_beli ='6982000' WHERE kode_barcode='00029701' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5506000',harga_beli ='5506000' WHERE kode_barcode='00029702' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12128000',harga_beli ='12128000' WHERE kode_barcode='00029703' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4749000',harga_beli ='4749000' WHERE kode_barcode='00029704' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14058000',harga_beli ='14058000' WHERE kode_barcode='00029705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8438500',harga_beli ='8438500' WHERE kode_barcode='00029706' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9220500',harga_beli ='9220500' WHERE kode_barcode='00030416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='35837500',harga_beli ='35837500' WHERE kode_barcode='00030724' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6067500',harga_beli ='6067500' WHERE kode_barcode='00030727' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='24504000',harga_beli ='24504000' WHERE kode_barcode='00030732' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12214500',harga_beli ='12214500' WHERE kode_barcode='00030733' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9084500',harga_beli ='9084500' WHERE kode_barcode='00030735' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='20763000',harga_beli ='20763000' WHERE kode_barcode='00030741' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10512500',harga_beli ='10512500' WHERE kode_barcode='00030742' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12794500',harga_beli ='12794500' WHERE kode_barcode='00030744' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2833000',harga_beli ='2833000' WHERE kode_barcode='00030753' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3363000',harga_beli ='3363000' WHERE kode_barcode='00030754' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8898000',harga_beli ='8898000' WHERE kode_barcode='00030755' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7856500',harga_beli ='7856500' WHERE kode_barcode='00030758' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8286500',harga_beli ='8286500' WHERE kode_barcode='00030760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2918500',harga_beli ='2918500' WHERE kode_barcode='00030761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2993000',harga_beli ='2993000' WHERE kode_barcode='00030763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='18032000',harga_beli ='18032000' WHERE kode_barcode='00030764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5163000',harga_beli ='5163000' WHERE kode_barcode='00030766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4901000',harga_beli ='4901000' WHERE kode_barcode='00030767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5237500',harga_beli ='5237500' WHERE kode_barcode='00030768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5163000',harga_beli ='5163000' WHERE kode_barcode='00030769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='20388500',harga_beli ='20388500' WHERE kode_barcode='00030773' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='47716500',harga_beli ='47716500' WHERE kode_barcode='00030774' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2102000',harga_beli ='2102000' WHERE kode_barcode='00030784' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4624000',harga_beli ='4624000' WHERE kode_barcode='00030785' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4112000',harga_beli ='4112000' WHERE kode_barcode='00030786' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3454500',harga_beli ='3454500' WHERE kode_barcode='00030787' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6728000',harga_beli ='6728000' WHERE kode_barcode='00031469' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7931500',harga_beli ='7931500' WHERE kode_barcode='00031682' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3454500',harga_beli ='3454500' WHERE kode_barcode='00031684' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1553500',harga_beli ='1553500' WHERE kode_barcode='00031686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1663500',harga_beli ='1663500' WHERE kode_barcode='00031687' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7420000',harga_beli ='7420000' WHERE kode_barcode='00031690' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3170000',harga_beli ='3170000' WHERE kode_barcode='00032055' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1471000',harga_beli ='1471000' WHERE kode_barcode='00033190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4608000',harga_beli ='4608000' WHERE kode_barcode='00033455' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1731000',harga_beli ='1731000' WHERE kode_barcode='00033501' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6067500',harga_beli ='6067500' WHERE kode_barcode='00033504' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1927500',harga_beli ='1927500' WHERE kode_barcode='00033505' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2124000',harga_beli ='2124000' WHERE kode_barcode='00033509' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2088000',harga_beli ='2088000' WHERE kode_barcode='00033510' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12628500',harga_beli ='12628500' WHERE kode_barcode='00033511' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12920500',harga_beli ='12920500' WHERE kode_barcode='00033512' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='19189000',harga_beli ='19189000' WHERE kode_barcode='00033513' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='14967500',harga_beli ='14967500' WHERE kode_barcode='00033516' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10709500',harga_beli ='10709500' WHERE kode_barcode='00033517' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4861500',harga_beli ='4861500' WHERE kode_barcode='00033518' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2124500',harga_beli ='2124500' WHERE kode_barcode='00033881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5246500',harga_beli ='5246500' WHERE kode_barcode='00034640' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5871500',harga_beli ='5871500' WHERE kode_barcode='00034760' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6228000',harga_beli ='6228000' WHERE kode_barcode='00034761' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4604500',harga_beli ='4604500' WHERE kode_barcode='00034762' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4354500',harga_beli ='4354500' WHERE kode_barcode='00034763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5835500',harga_beli ='5835500' WHERE kode_barcode='00034766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4104500',harga_beli ='4104500' WHERE kode_barcode='00034768' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2677000',harga_beli ='2677000' WHERE kode_barcode='00034769' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4568500',harga_beli ='4568500' WHERE kode_barcode='00034776' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3498000',harga_beli ='3498000' WHERE kode_barcode='00034779' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2552000',harga_beli ='2552000' WHERE kode_barcode='00035830' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2741500',harga_beli ='2741500' WHERE kode_barcode='00035831' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5407500',harga_beli ='5407500' WHERE kode_barcode='00036170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5139500',harga_beli ='5139500' WHERE kode_barcode='00036357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2873500',harga_beli ='2873500' WHERE kode_barcode='00036358' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2677000',harga_beli ='2677000' WHERE kode_barcode='00036359' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2623500',harga_beli ='2623500' WHERE kode_barcode='00036360' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4586500',harga_beli ='4586500' WHERE kode_barcode='00036412' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2909000',harga_beli ='2909000' WHERE kode_barcode='00036416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4354500',harga_beli ='4354500' WHERE kode_barcode='00036621' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4854000',harga_beli ='4854000' WHERE kode_barcode='00036622' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4211500',harga_beli ='4211500' WHERE kode_barcode='00036623' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4479500',harga_beli ='4479500' WHERE kode_barcode='00036624' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4158000',harga_beli ='4158000' WHERE kode_barcode='00036625' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3962000',harga_beli ='3962000' WHERE kode_barcode='00036626' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4818500',harga_beli ='4818500' WHERE kode_barcode='00036627' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4265000',harga_beli ='4265000' WHERE kode_barcode='00036628' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4800500',harga_beli ='4800500' WHERE kode_barcode='00036629' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2472500',harga_beli ='2472500' WHERE kode_barcode='00036705' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2472500',harga_beli ='2472500' WHERE kode_barcode='00036707' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5684000',harga_beli ='5684000' WHERE kode_barcode='00036763' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5610500',harga_beli ='5610500' WHERE kode_barcode='00036764' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5574000',harga_beli ='5574000' WHERE kode_barcode='00036765' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5556000',harga_beli ='5556000' WHERE kode_barcode='00036766' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5446000',harga_beli ='5446000' WHERE kode_barcode='00036767' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2391500',harga_beli ='2391500' WHERE kode_barcode='00036790' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2980500',harga_beli ='2980500' WHERE kode_barcode='00036806' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3301500',harga_beli ='3301500' WHERE kode_barcode='00036808' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2409500',harga_beli ='2409500' WHERE kode_barcode='00036842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2570000',harga_beli ='2570000' WHERE kode_barcode='00036844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4033000',harga_beli ='4033000' WHERE kode_barcode='00036848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3301500',harga_beli ='3301500' WHERE kode_barcode='00036850' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4015500',harga_beli ='4015500' WHERE kode_barcode='00036851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3498000',harga_beli ='3498000' WHERE kode_barcode='00036852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3944000',harga_beli ='3944000' WHERE kode_barcode='00036853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3391000',harga_beli ='3391000' WHERE kode_barcode='00036855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12847500',harga_beli ='12847500' WHERE kode_barcode='00036906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15881500',harga_beli ='15881500' WHERE kode_barcode='00036907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9357000',harga_beli ='9357000' WHERE kode_barcode='00036908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6067500',harga_beli ='6067500' WHERE kode_barcode='00036909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9722500',harga_beli ='9722500' WHERE kode_barcode='00036912' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6670500',harga_beli ='6670500' WHERE kode_barcode='00036913' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16411000',harga_beli ='16411000' WHERE kode_barcode='00036914' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12994000',harga_beli ='12994000' WHERE kode_barcode='00036915' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10782500',harga_beli ='10782500' WHERE kode_barcode='00036916' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='18330000',harga_beli ='18330000' WHERE kode_barcode='00036918' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3944000',harga_beli ='3944000' WHERE kode_barcode='00037019' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5907000',harga_beli ='5907000' WHERE kode_barcode='00037245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5300000',harga_beli ='5300000' WHERE kode_barcode='00037246' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2909000',harga_beli ='2909000' WHERE kode_barcode='00037249' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4247500',harga_beli ='4247500' WHERE kode_barcode='00037250' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4551000',harga_beli ='4551000' WHERE kode_barcode='00037252' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6353000',harga_beli ='6353000' WHERE kode_barcode='00037256' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5407500',harga_beli ='5407500' WHERE kode_barcode='00037269' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4568500',harga_beli ='4568500' WHERE kode_barcode='00037270' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4747000',harga_beli ='4747000' WHERE kode_barcode='00037272' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4872000',harga_beli ='4872000' WHERE kode_barcode='00037273' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4586500',harga_beli ='4586500' WHERE kode_barcode='00037274' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4461500',harga_beli ='4461500' WHERE kode_barcode='00037276' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3337500',harga_beli ='3337500' WHERE kode_barcode='00037278' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4265000',harga_beli ='4265000' WHERE kode_barcode='00037279' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2748500',harga_beli ='2748500' WHERE kode_barcode='00037280' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4586500',harga_beli ='4586500' WHERE kode_barcode='00037281' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4782500',harga_beli ='4782500' WHERE kode_barcode='00037283' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3426500',harga_beli ='3426500' WHERE kode_barcode='00037284' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3747500',harga_beli ='3747500' WHERE kode_barcode='00037285' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6406500',harga_beli ='6406500' WHERE kode_barcode='00037288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4426000',harga_beli ='4426000' WHERE kode_barcode='00037289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4622000',harga_beli ='4622000' WHERE kode_barcode='00037813' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3835000',harga_beli ='3835000' WHERE kode_barcode='00038371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3835000',harga_beli ='3835000' WHERE kode_barcode='00038372' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3816000',harga_beli ='3816000' WHERE kode_barcode='00038373' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3816000',harga_beli ='3816000' WHERE kode_barcode='00038374' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3853500',harga_beli ='3853500' WHERE kode_barcode='00038375' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3255000',harga_beli ='3255000' WHERE kode_barcode='00038376' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3255000',harga_beli ='3255000' WHERE kode_barcode='00038377' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6696500',harga_beli ='6696500' WHERE kode_barcode='00038378' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10363000',harga_beli ='10363000' WHERE kode_barcode='00038379' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8698000',harga_beli ='8698000' WHERE kode_barcode='00038380' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11822000',harga_beli ='11822000' WHERE kode_barcode='00038381' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6360000',harga_beli ='6360000' WHERE kode_barcode='00038382' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3124000',harga_beli ='3124000' WHERE kode_barcode='00038383' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3199000',harga_beli ='3199000' WHERE kode_barcode='00038384' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8043500',harga_beli ='8043500' WHERE kode_barcode='00038385' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8249000',harga_beli ='8249000' WHERE kode_barcode='00038386' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8286500',harga_beli ='8286500' WHERE kode_barcode='00038387' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2709000',harga_beli ='2709000' WHERE kode_barcode='00038388' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2745500',harga_beli ='2745500' WHERE kode_barcode='00038389' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2962000',harga_beli ='2962000' WHERE kode_barcode='00038390' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3034500',harga_beli ='3034500' WHERE kode_barcode='00038391' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2944000',harga_beli ='2944000' WHERE kode_barcode='00038393' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2998000',harga_beli ='2998000' WHERE kode_barcode='00038394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1607500',harga_beli ='1607500' WHERE kode_barcode='00038396' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1571500',harga_beli ='1571500' WHERE kode_barcode='00038397' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2023000',harga_beli ='2023000' WHERE kode_barcode='00038399' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2294000',harga_beli ='2294000' WHERE kode_barcode='00038400' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2348000',harga_beli ='2348000' WHERE kode_barcode='00038401' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1896500',harga_beli ='1896500' WHERE kode_barcode='00038402' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1914500',harga_beli ='1914500' WHERE kode_barcode='00038403' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2438500',harga_beli ='2438500' WHERE kode_barcode='00038404' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1553500',harga_beli ='1553500' WHERE kode_barcode='00038405' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1535500',harga_beli ='1535500' WHERE kode_barcode='00038406' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2221500',harga_beli ='2221500' WHERE kode_barcode='00038407' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2221500',harga_beli ='2221500' WHERE kode_barcode='00038408' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2203500',harga_beli ='2203500' WHERE kode_barcode='00038409' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1969000',harga_beli ='1969000' WHERE kode_barcode='00038411' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2420500',harga_beli ='2420500' WHERE kode_barcode='00038414' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2944000',harga_beli ='2944000' WHERE kode_barcode='00038415' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7206000',harga_beli ='7206000' WHERE kode_barcode='00038416' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2565000',harga_beli ='2565000' WHERE kode_barcode='00038417' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4190000',harga_beli ='4190000' WHERE kode_barcode='00038419' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4190000',harga_beli ='4190000' WHERE kode_barcode='00038420' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4280500',harga_beli ='4280500' WHERE kode_barcode='00038421' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4190000',harga_beli ='4190000' WHERE kode_barcode='00038422' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3955500',harga_beli ='3955500' WHERE kode_barcode='00038423' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5219500',harga_beli ='5219500' WHERE kode_barcode='00038424' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5544500',harga_beli ='5544500' WHERE kode_barcode='00038425' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5526500',harga_beli ='5526500' WHERE kode_barcode='00038426' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4389000',harga_beli ='4389000' WHERE kode_barcode='00038427' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4118000',harga_beli ='4118000' WHERE kode_barcode='00038428' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3919500',harga_beli ='3919500' WHERE kode_barcode='00038429' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4389000',harga_beli ='4389000' WHERE kode_barcode='00038430' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3919500',harga_beli ='3919500' WHERE kode_barcode='00038431' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10818000',harga_beli ='10818000' WHERE kode_barcode='00038433' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10872500',harga_beli ='10872500' WHERE kode_barcode='00038434' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9119500',harga_beli ='9119500' WHERE kode_barcode='00038435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9339000',harga_beli ='9339000' WHERE kode_barcode='00038436' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2193000',harga_beli ='2193000' WHERE kode_barcode='00038437' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2230000',harga_beli ='2230000' WHERE kode_barcode='00038438' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2248000',harga_beli ='2248000' WHERE kode_barcode='00038439' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6250500',harga_beli ='6250500' WHERE kode_barcode='00038441' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2156500',harga_beli ='2156500' WHERE kode_barcode='00038442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2558500',harga_beli ='2558500' WHERE kode_barcode='00038444' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9613000',harga_beli ='9613000' WHERE kode_barcode='00038445' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7164000',harga_beli ='7164000' WHERE kode_barcode='00038446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7036000',harga_beli ='7036000' WHERE kode_barcode='00038447' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7712500',harga_beli ='7712500' WHERE kode_barcode='00038449' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6981500',harga_beli ='6981500' WHERE kode_barcode='00038450' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7164000',harga_beli ='7164000' WHERE kode_barcode='00038451' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12189500',harga_beli ='12189500' WHERE kode_barcode='00038452' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11879000',harga_beli ='11879000' WHERE kode_barcode='00038453' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='15040500',harga_beli ='15040500' WHERE kode_barcode='00038454' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4136000',harga_beli ='4136000' WHERE kode_barcode='00038534' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3757000',harga_beli ='3757000' WHERE kode_barcode='00038535' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1716000',harga_beli ='1716000' WHERE kode_barcode='00038536' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2185500',harga_beli ='2185500' WHERE kode_barcode='00038537' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2312000',harga_beli ='2312000' WHERE kode_barcode='00038538' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3106500',harga_beli ='3106500' WHERE kode_barcode='00038540' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4804000',harga_beli ='4804000' WHERE kode_barcode='00038541' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2221500',harga_beli ='2221500' WHERE kode_barcode='00038542' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1625500',harga_beli ='1625500' WHERE kode_barcode='00038543' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1951000',harga_beli ='1951000' WHERE kode_barcode='00038544' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1625500',harga_beli ='1625500' WHERE kode_barcode='00038545' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1806000',harga_beli ='1806000' WHERE kode_barcode='00038547' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1752000',harga_beli ='1752000' WHERE kode_barcode='00038548' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2348000',harga_beli ='2348000' WHERE kode_barcode='00038549' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3377500',harga_beli ='3377500' WHERE kode_barcode='00038550' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3486000',harga_beli ='3486000' WHERE kode_barcode='00038551' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3919500',harga_beli ='3919500' WHERE kode_barcode='00038552' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5245000',harga_beli ='5245000' WHERE kode_barcode='00038553' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5007500',harga_beli ='5007500' WHERE kode_barcode='00038554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2540500',harga_beli ='2540500' WHERE kode_barcode='00038555' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='20505000',harga_beli ='20505000' WHERE kode_barcode='00038556' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3685000',harga_beli ='3685000' WHERE kode_barcode='00038557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5724000',harga_beli ='5724000' WHERE kode_barcode='00038558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8679500',harga_beli ='8679500' WHERE kode_barcode='00038559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2656500',harga_beli ='2656500' WHERE kode_barcode='00038561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1104000',harga_beli ='1104000' WHERE kode_barcode='00038564' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1104000',harga_beli ='1104000' WHERE kode_barcode='00038565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1104000',harga_beli ='1104000' WHERE kode_barcode='00038566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5724000',harga_beli ='5724000' WHERE kode_barcode='00038567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3853500',harga_beli ='3853500' WHERE kode_barcode='00038568' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5593000',harga_beli ='5593000' WHERE kode_barcode='00038569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3872000',harga_beli ='3872000' WHERE kode_barcode='00038570' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3835000',harga_beli ='3835000' WHERE kode_barcode='00038571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6846500',harga_beli ='6846500' WHERE kode_barcode='00038572' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10232000',harga_beli ='10232000' WHERE kode_barcode='00038573' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9577000',harga_beli ='9577000' WHERE kode_barcode='00038575' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16853500',harga_beli ='16853500' WHERE kode_barcode='00038576' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2891000',harga_beli ='2891000' WHERE kode_barcode='00038670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2096500',harga_beli ='2096500' WHERE kode_barcode='00038772' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11825000',harga_beli ='11825000' WHERE kode_barcode='00038872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11825000',harga_beli ='11825000' WHERE kode_barcode='00038873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11825000',harga_beli ='11825000' WHERE kode_barcode='00038875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11825000',harga_beli ='11825000' WHERE kode_barcode='00038876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='110725000',harga_beli ='110725000' WHERE kode_barcode='00038877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='42778500',harga_beli ='42778500' WHERE kode_barcode='00038891' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='39853500',harga_beli ='39853500' WHERE kode_barcode='00038892' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='34758500',harga_beli ='34758500' WHERE kode_barcode='00038893' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4199500',harga_beli ='4199500' WHERE kode_barcode='00038894' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5262000',harga_beli ='5262000' WHERE kode_barcode='00038895' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='10294500',harga_beli ='10294500' WHERE kode_barcode='00038896' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7052500',harga_beli ='7052500' WHERE kode_barcode='00038897' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3175500',harga_beli ='3175500' WHERE kode_barcode='00038898' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9248500',harga_beli ='9248500' WHERE kode_barcode='00038899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7206000',harga_beli ='7206000' WHERE kode_barcode='00038900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4951500',harga_beli ='4951500' WHERE kode_barcode='00038901' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3170000',harga_beli ='3170000' WHERE kode_barcode='00038902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='8072000',harga_beli ='8072000' WHERE kode_barcode='00038903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4624500',harga_beli ='4624500' WHERE kode_barcode='00038904' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11079000',harga_beli ='11079000' WHERE kode_barcode='00038905' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='12762000',harga_beli ='12762000' WHERE kode_barcode='00038906' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='7092000',harga_beli ='7092000' WHERE kode_barcode='00038907' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9575500',harga_beli ='9575500' WHERE kode_barcode='00038908' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4918500',harga_beli ='4918500' WHERE kode_barcode='00038923' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='25000500',harga_beli ='25000500' WHERE kode_barcode='00038924' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='19869500',harga_beli ='19869500' WHERE kode_barcode='00038925' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2120000',harga_beli ='2120000' WHERE kode_barcode='00038950' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5232500',harga_beli ='5232500' WHERE kode_barcode='00038951' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2472500',harga_beli ='2472500' WHERE kode_barcode='00039101' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2472500',harga_beli ='2472500' WHERE kode_barcode='00039102' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='13919500',harga_beli ='13919500' WHERE kode_barcode='00039103' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3472500',harga_beli ='3472500' WHERE kode_barcode='00039104' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4620500',harga_beli ='4620500' WHERE kode_barcode='00039105' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4471000',harga_beli ='4471000' WHERE kode_barcode='00039106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='16199000',harga_beli ='16199000' WHERE kode_barcode='00039107' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11167000',harga_beli ='11167000' WHERE kode_barcode='00039108' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3442000',harga_beli ='3442000' WHERE kode_barcode='00039109' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3199000',harga_beli ='3199000' WHERE kode_barcode='00039110' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3909500',harga_beli ='3909500' WHERE kode_barcode='00039111' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5986000',harga_beli ='5986000' WHERE kode_barcode='00039113' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1856000',harga_beli ='1856000' WHERE kode_barcode='00039130' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1856000',harga_beli ='1856000' WHERE kode_barcode='00039131' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='22575000',harga_beli ='22575000' WHERE kode_barcode='00039153' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4194000',harga_beli ='4194000' WHERE kode_barcode='00039163' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3551500',harga_beli ='3551500' WHERE kode_barcode='00039164' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2748500',harga_beli ='2748500' WHERE kode_barcode='00039165' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3676500',harga_beli ='3676500' WHERE kode_barcode='00039166' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3373000',harga_beli ='3373000' WHERE kode_barcode='00039167' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3212500',harga_beli ='3212500' WHERE kode_barcode='00039168' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2998000',harga_beli ='2998000' WHERE kode_barcode='00039169' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2766500',harga_beli ='2766500' WHERE kode_barcode='00039170' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2712500',harga_beli ='2712500' WHERE kode_barcode='00039171' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='1660000',harga_beli ='1660000' WHERE kode_barcode='00039172' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='22729000',harga_beli ='22729000' WHERE kode_barcode='00039222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='11599500',harga_beli ='11599500' WHERE kode_barcode='00039223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4543000',harga_beli ='4543000' WHERE kode_barcode='00039224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4085000',harga_beli ='4085000' WHERE kode_barcode='00039225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2961500',harga_beli ='2961500' WHERE kode_barcode='00039226' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6900000',harga_beli ='6900000' WHERE kode_barcode='00039227' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='9853500',harga_beli ='9853500' WHERE kode_barcode='00039228' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6618000',harga_beli ='6618000' WHERE kode_barcode='00039229' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='6503500',harga_beli ='6503500' WHERE kode_barcode='00039230' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='5948000',harga_beli ='5948000' WHERE kode_barcode='00039231' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4967500',harga_beli ='4967500' WHERE kode_barcode='00039232' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4575500',harga_beli ='4575500' WHERE kode_barcode='00039233' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2974000',harga_beli ='2974000' WHERE kode_barcode='00039234' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2892500',harga_beli ='2892500' WHERE kode_barcode='00039235' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='3725000',harga_beli ='3725000' WHERE kode_barcode='00039236' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2152500',harga_beli ='2152500' WHERE kode_barcode='00039237' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='2122000',harga_beli ='2122000' WHERE kode_barcode='00039238' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2150000',harga_jual='4782500',harga_beli ='4782500' WHERE kode_barcode='00039278' LIMIT 1;
UPDATE tm_group SET harga='2150000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2150000','kasir','2025-10-28 11:36:42');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-10-28 ','13:02:34');
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-251028-0001','kasir','1',' 850K-145-1','TOKO','BIPPER','PBDG-YHBI-6-0','CINCIN SILVER 925 ','','2.410','1','100.00','62000','0','0','16600','599000','0','0','0','599000','NITA','00038357','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YHBI-6-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.410',berat_jual_asli=berat_jual_asli+'2.410',stock_jual='1',berat_akhir=berat_akhir-'2.410',berat_akhir_asli=berat_akhir_asli-'2.410',stock_akhir='0' WHERE tanggal='2025-10-28' AND kode_barang='PBDG-YHBI-6-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-251028-0001','2025-10-28','2.410','2025-10-28','13:19:55','PLG0007220','599000','599000','0','599000','0','kasir','2025-10-28 13:19:55','FJ-251028-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-10-28','FJ-251028-0001','2025-10-28','13:19:55','NITA','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-251028-0001','2025-10-28','2025-10-28 13:19:55','PENJUALAN : FJ-251028-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-251028-0002','D','2025-10-28','13:19:55','TBC','PENJUALAN','FJ-251028-0001','17621981914','599000','17622580914','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-251028-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-251028-0002','kasir','1',' 700K-18-16','TOKO','BIPPER','PBDG-YJXC-15-0','CINCIN SILVER 925 ','','4.440','1','100.00','114000','0','0','16600','700000','0','0','0','700000','SUL','00038986','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-YJXC-15-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.440',berat_jual_asli=berat_jual_asli+'4.440',stock_jual='1',berat_akhir=berat_akhir-'4.440',berat_akhir_asli=berat_akhir_asli-'4.440',stock_akhir='0' WHERE tanggal='2025-10-28' AND kode_barang='PBDG-YJXC-15-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-251028-0002','2025-10-28','4.440','2025-10-28','13:33:08','PLG0007221','700000','700000','0','700000','0','kasir','2025-10-28 13:33:08','FJ-251028-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-10-28','FJ-251028-0002','2025-10-28','13:33:08','SUL','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-251028-0002','2025-10-28','2025-10-28 13:33:08','PENJUALAN : FJ-251028-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-251028-0003','D','2025-10-28','13:33:08','TBC','PENJUALAN','FJ-251028-0002','17622580914','700000','17623280914','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-251028-0002' 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-251028-0003','kasir','1',' DP-01213BI','TOKO','BIPPSN','PSGT-YJBB-3-0','CINCIN EMAS ','','1.280','1','83.00','2461000','0','0','16600','3208000','0','0','0','3208000','SUL','00039252','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YJBB-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.280',berat_jual_asli=berat_jual_asli+'1.280',stock_jual='1',berat_akhir=berat_akhir-'1.280',berat_akhir_asli=berat_akhir_asli-'1.280',stock_akhir='0' WHERE tanggal='2025-10-28' AND kode_barang='PSGT-YJBB-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-251028-0003','2025-10-28','1.280','2025-10-28','13:34:35','PLG0007222','3208000','3208000','0','3208000','0','kasir','2025-10-28 13:34:35','FJ-251028-0003','DP-01213','2892000');
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-10-28','FJ-251028-0003','2025-10-28','13:34:35','SUL','3208000','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-251028-0003','2025-10-28','2025-10-28 13:34:35','PENJUALAN : FJ-251028-0003','.','TBC','316000','316000','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-251028-0004','D','2025-10-28','13:34:35','TBC','PENJUALAN','FJ-251028-0003','17623280914','316000','17623596914','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='316000' WHERE no_faktur_jual='FJ-251028-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-251028-0004','kasir',' 1',' DP-01214BI','TOKO','BIPPSN','PSPLT-YJAX-16-0','CINCIN PALADIUM ','','5.150','1','6.00','718000','0','0','16600','1787500','0','0','0','1787500','SUL','00039162','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJAX-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'5.150',berat_jual_asli=berat_jual_asli+'5.150',stock_jual='1',berat_akhir=berat_akhir-'5.150',berat_akhir_asli=berat_akhir_asli-'5.150',stock_akhir='0' WHERE tanggal='2025-10-28' AND kode_barang='PSPLT-YJAX-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-251028-0004','2025-10-28','5.150','2025-10-28','13:34:35','PLG0007223','1787500','1787500','0','1787500','0','kasir','2025-10-28 13:34:35','FJ-251028-0003','DP-01214','875000');
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-10-28','FJ-251028-0004','2025-10-28','13:34:35','SUL','1787500','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-251028-0004','2025-10-28','2025-10-28 13:34:35','PENJUALAN : FJ-251028-0004','.','TBC','912500','912500','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-251028-0005','D','2025-10-28','13:34:35','TBC','PENJUALAN','FJ-251028-0004','17623596914','912500','17624509414','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='1228500' WHERE no_faktur_jual='FJ-251028-0004' 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-01388','SULIS','1','CC SILVER','CROM FULL PUTIH GLOSY FONT VLADIMIR','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-01388','2025-10-28','2025-10-28','13:57:25','PLG0007224','kasir','2025-10-10','kasir','2025-10-28 13:57:25','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-251028-0005','kasir','1',' DP-01268BI','TOKO','BIPPSN','PSPRT-YJBD-16-0','CINCIN PERAK ','','4.560','1','100.00','280000','0','0','16600','700000','0','0','0','700000','SUL','00039298','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJBD-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.560',berat_jual_asli=berat_jual_asli+'4.560',stock_jual='1',berat_akhir=berat_akhir-'4.560',berat_akhir_asli=berat_akhir_asli-'4.560',stock_akhir='0' WHERE tanggal='2025-10-28' AND kode_barang='PSPRT-YJBD-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-251028-0005','2025-10-28','4.560','2025-10-28','15:02:22','PLG0007225','700000','700000','0','700000','0','kasir','2025-10-28 15:02:21','FJ-251028-0005','DP-01268','700000');
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-10-28','FJ-251028-0005','2025-10-28','15:02:22','SUL','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251028-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-251028-0006','kasir',' 1',' DP-01267BI','TOKO','BIPPSN','PSPRT-YJBD-14-0','CINCIN PERAK ','','1.700','1','100.00','105000','0','0','16600','700000','0','0','0','700000','SUL','00039296','PSPRT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPRT-YJBD-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.700',berat_jual_asli=berat_jual_asli+'1.700',stock_jual='1',berat_akhir=berat_akhir-'1.700',berat_akhir_asli=berat_akhir_asli-'1.700',stock_akhir='0' WHERE tanggal='2025-10-28' AND kode_barang='PSPRT-YJBD-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPSN' 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-251028-0006','2025-10-28','1.700','2025-10-28','15:02:22','PLG0007226','700000','700000','0','700000','0','kasir','2025-10-28 15:02:21','FJ-251028-0005','DP-01267','700000');
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-10-28','FJ-251028-0006','2025-10-28','15:02:22','SUL','700000','0');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-251028-0006' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251028-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251028-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251028-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251028-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251028-0005';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0006' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251028-0006';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2025-10-28 ','15:57:59');
DELETE FROM tm_berlian WHERE kode_barang='TFC-XBBF-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 ('TFC-XBBF-13-0','TFC-XBBF-13-0','00026884','RD','1','0.230','1400');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XBBF-13-0','00026884','RD','1','0.230','1400','322')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XBBF-13-0','TFC-XBBF-13-0','00026884','RD','2','0.135','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XBBF-13-0','00026884','RD','2','0.135','450','60.75')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XBBF-13-0','TFC-XBBF-13-0','00026884','RD','14','0.065','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XBBF-13-0','00026884','RD','14','0.065','420','27.3')
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 ('TFC-XBBF-13-0','00026884','00026884','TFC-21305 GIA 2397921919','TFC-21305 GIA 2397921919','','','4961000','4961000',' 0','0','spv','2025-10-28 16:00:26');
UPDATE tm_barang SET nama_barang='TFC-21305 GIA 2397921919' ,nama_atribut='' ,kode_intern='TFC-21305 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1267 15 1025',total_usd_ext='GIA 44 000 000',total_usd='410.05' WHERE kode_barang='TFC-XBBF-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-YJXB-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 ('TFC-YJXB-3-0','TFC-YJXB-3-0','00038959','RD','1','0.230','1120');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-YJXB-3-0','00038959','RD','1','0.230','1120','257.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 ('TFC-YJXB-3-0','00038959','00038959','TFC-21485 GIA 6491960394 ','TFC-21485 GIA 6491960394','','','7031000','7031000',' 0','0','spv','2025-10-28 16:02:02');
UPDATE tm_barang SET nama_barang='TFC-21485 GIA 6491960394' ,nama_atribut='' ,kode_intern='TFC-21485 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='EVVS2 1025',total_usd_ext='GIA 42 500 000',total_usd='257.6' WHERE kode_barang='TFC-YJXB-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-XCXE-15-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XCXE-15-0','TFC-XCXE-15-0','00027104','RD','1','0.230','1450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XCXE-15-0','00027104','RD','1','0.230','1450','333.5')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XCXE-15-0','TFC-XCXE-15-0','00027104','RD','14','0.080','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XCXE-15-0','00027104','RD','14','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 ('TFC-XCXE-15-0','TFC-XCXE-15-0','00027104','RD','2','0.165','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XCXE-15-0','00027104','RD','2','0.165','600','99')
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 ('TFC-XCXE-15-0','00027104','00027104','TFC-21328 GIA 6465238716','TFC-21328 GIA 6465238716','','','4568500','4568500',' 0','0','spv','2025-10-28 16:04:07');
UPDATE tm_barang SET nama_barang='TFC-21328 GIA 6465238716' ,nama_atribut='' ,kode_intern='TFC-21328 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1267 13 5 1025',total_usd_ext='GIA 46 000 000',total_usd='466.1' WHERE kode_barang='TFC-XCXE-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CBRT-WIAI-25-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIAI-25-0','CBRT-WIAI-25-0','00024095','RD','20','0.060','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIAI-25-0','00024095','RD','20','0.060','420','25.2')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIAI-25-0','CBRT-WIAI-25-0','00024095','RD','12','0.030','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIAI-25-0','00024095','RD','12','0.030','420','12.6')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('CBRT-WIAI-25-0','CBRT-WIAI-25-0','00024095','RD','1','0.160','1500');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('CBRT-WIAI-25-0','00024095','RD','1','0.160','1500','240')
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 ('CBRT-WIAI-25-0','00024095','00024095','CBRT-00182 GIA 2437646008','CBRT-00182 GIA 2437646008','','','3787000','3787000',' 0','0','spv','2025-10-28 16:05:57');
UPDATE tm_barang SET nama_barang='CBRT-00182 GIA 2437646008' ,nama_atribut='' ,kode_intern='CBRT-00182 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 13 5 1025',total_usd_ext='GIE 32 500 000',total_usd='277.8' WHERE kode_barang='CBRT-WIAI-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-YHXG-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 ('TFC-YHXG-16-0','TFC-YHXG-16-0','00037907','RD','1','0.160','1500');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-YHXG-16-0','00037907','RD','1','0.160','1500','240')
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 ('TFC-YHXG-16-0','00037907','00037907','TFC-21242 GIA 7478252629 ','TFC-21242 GIA 7478252629','','','3194500','3194500',' 0','0','spv','2025-10-28 16:07:24');
UPDATE tm_barang SET nama_barang='TFC-21242 GIA 7478252629' ,nama_atribut='' ,kode_intern='TFC-21242 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='FVVS1 S09 1025',total_usd_ext='GIE 26 000 000',total_usd='240' WHERE kode_barang='TFC-YHXG-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='TFC-XEBH-15-0';
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XEBH-15-0','TFC-XEBH-15-0','00028692','RD','2','0.035','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XEBH-15-0','00028692','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 ('TFC-XEBH-15-0','TFC-XEBH-15-0','00028692','RD','42','0.220','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XEBH-15-0','00028692','RD','42','0.220','420','92.4')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-XEBH-15-0','TFC-XEBH-15-0','00028692','RD','1','0.300','1800');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-XEBH-15-0','00028692','RD','1','0.300','1800','540')
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 ('TFC-XEBH-15-0','00028692','00028692','TFC-21255 GIA 5181081114','TFC-21255 GIA 5181081114','','','4943500','4943500',' 0','0','spv','2025-10-28 16:09:15');
UPDATE tm_barang SET nama_barang='TFC-21255 GIA 5181081114' ,nama_atribut='' ,kode_intern='TFC-21255 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1436 125 1025',total_usd_ext='GIE 57 000 000',total_usd='647.1' WHERE kode_barang='TFC-XEBH-15-0' 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-251028-0007','kasir','1',' TFGRR75-87','TOKO','TFGLR','TFGRR-YIXA-14-0','THIFA GELANG RANTAI RG ','','1.710','1','87.00','3263000','0','0','16600','3330000','0','0','0','3330000','ILU','00038384','TFGRR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-28', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFGRR-YIXA-14-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.710',berat_jual_asli=berat_jual_asli+'1.710',stock_jual='1',berat_akhir=berat_akhir-'1.710',berat_akhir_asli=berat_akhir_asli-'1.710',stock_akhir='0' WHERE tanggal='2025-10-28' AND kode_barang='TFGRR-YIXA-14-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFGLR' 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-251028-0007','2025-10-28','1.710','2025-10-28','16:23:05','PLG0007227','3330000','3330000','0','3330000','0','kasir','2025-10-28 16:23:04','FJ-251028-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-10-28','FJ-251028-0007','2025-10-28','16:23:05','ILU','3330000','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-251028-0005','2025-10-28','2025-10-28 16:23:04','PENJUALAN : FJ-251028-0007','.','TBC','3330000','3330000','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-251028-0006','D','2025-10-28','16:23:05','TBC','PENJUALAN','FJ-251028-0007','17624509414','3330000','17627839414','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='3330000' WHERE no_faktur_jual='FJ-251028-0007' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0007' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-251028-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-251028-0007';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-29','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-28';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-28';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-28';
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-10-28' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-28';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-28';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-28';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-28';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-29' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-28' 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-251029-0001','D','2025-10-29','20:04:34','TBC','SALDO AWAL','SALDO AWAL','0','17627839414','17627839414');
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-251029-0001','D','2025-10-29','20:04:34','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
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-251029-0001','D','2025-10-29','20:04:34','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-251029-0001','D','2025-10-29','20:04:34','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-251029-0001','D','2025-10-29','20:04:34','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-251029-0001','D','2025-10-29','20:04:34','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-251029-0001','D','2025-10-29','20:04:34','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-251029-0001','D','2025-10-29','20:04:34','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-251029-0001','D','2025-10-29','20:04:34','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-251029-0001','D','2025-10-29','20:04:34','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-251029-0001','D','2025-10-29','20:04:34','BCD','SALDO AWAL','SALDO AWAL','0','1334821000','1334821000');
UPDATE tp_system SET tgl_system='2025-10-29';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-28 ','20:21:08');
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YJBG-5-0';
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 ('PSGT-YJBG-5-0','00039308','00039308','CINCIN EMAS ','CINCIN EMAS','','','4877500','4877500',' 300000','300000','kasir','2025-10-28 20:24:17');
UPDATE tm_barang SET nama_barang='CINCIN EMAS' ,nama_atribut='' ,kode_intern='DP-01262MM ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 18',total_usd_ext='PSN01262MM',total_usd='0' WHERE kode_barang='PSGT-YJBG-5-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-28 ','20:24:25');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-28 ','20:24:36');
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YJBG-5-0';
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 ('PSGT-YJBG-5-0','00039308','00039308','CINCIN EMAS','CINCIN EMAS','','','4877500','4877500',' 300000','300000','kasir','2025-10-28 20:25:07');
UPDATE tm_barang SET nama_barang='CINCIN EMAS' ,nama_atribut='' ,kode_intern='DP-01262MM ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 18',total_usd_ext='PSN01262MM',total_usd='0' WHERE kode_barang='PSGT-YJBG-5-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-28 ','20:26:44');
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YJBG-5-0';
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 ('PSGT-YJBG-5-0','00039308','00039308','CINCIN EMAS','CINCIN EMAS','','','4877500','4877500',' 300000','300000','kasir','2025-10-28 20:27:26');
UPDATE tm_barang SET nama_barang='CINCIN EMAS' ,nama_atribut='' ,kode_intern='DP-01262MM ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 18',total_usd_ext='PSN01262MM',total_usd='0' WHERE kode_barang='PSGT-YJBG-5-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-28 ','20:30:02');
DELETE FROM tm_berlian WHERE kode_barang='PSGT-YJBG-5-0';
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 ('PSGT-YJBG-5-0','00039308','00039308','CINCIN EMAS','CINCIN EMAS','','','4877500','4877500',' 300000','300000','kasir','2025-10-28 20:31:24');
UPDATE tm_barang SET nama_barang='CINCIN EMAS' ,nama_atribut='' ,kode_intern='DP-01262MM ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 18',total_usd_ext='PSN01262MM',total_usd='0' WHERE kode_barang='PSGT-YJBG-5-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2025-10-28 ','20:39:21');
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-251028-0008','kasir','1',' DP-01262MM','TOKO','MMPSN','PSGT-YJBG-5-0','CINCIN EMAS','','2.600','1','83.00','4976000','0','0','16600','6410000','0','0','0','6410000','NIS','00039308','PSGT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSGT-YJBG-5-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-10-29' AND kode_barang='PSGT-YJBG-5-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-251028-0008','2025-10-29','2.600','2025-10-28','20:40:44','PLG0007228','6410000','6410000','0','6410000','0','kasir','2025-10-28 20:40:43','FJ-251028-0008','DP-01262','5064000');
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-10-29','FJ-251028-0008','2025-10-28','20:40:44','NIS','6410000','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-251029-0001','2025-10-29','2025-10-28 20:40:43','PENJUALAN : FJ-251028-0008','.','TBC','1346000','1346000','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-251029-0002','D','2025-10-29','20:40:44','TBC','PENJUALAN','FJ-251028-0008','17627839414','1346000','17629185414','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='1346000' WHERE no_faktur_jual='FJ-251028-0008' 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-251028-0009','kasir','1',' DP-01263MM','TOKO','MMPSN','PSPLT-YJBC-2-0','CINCIN PALADIUM ','','4.180','1','13.00','1358000','0','0','16600','2581000','0','0','0','2581000','NAD','00039280','PSPLT','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2025-10-29', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PSPLT-YJBC-2-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'4.180',berat_jual_asli=berat_jual_asli+'4.180',stock_jual='1',berat_akhir=berat_akhir-'4.180',berat_akhir_asli=berat_akhir_asli-'4.180',stock_akhir='0' WHERE tanggal='2025-10-29' AND kode_barang='PSPLT-YJBC-2-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='MMPSN' 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-251028-0009','2025-10-29','4.180','2025-10-28','20:41:17','PLG0007229','2581000','2581000','0','2581000','0','kasir','2025-10-28 20:41:16','FJ-251028-0009','DP-01263','2208000');
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-10-29','FJ-251028-0009','2025-10-28','20:41:17','NAD','2581000','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-251029-0002','2025-10-29','2025-10-28 20:41:16','PENJUALAN : FJ-251028-0009','.','TBC','373000','373000','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-251029-0003','D','2025-10-29','20:41:17','TBC','PENJUALAN','FJ-251028-0009','17629185414','373000','17629558414','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='373000' WHERE no_faktur_jual='FJ-251028-0009' LIMIT 1;