INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-21 ','08:14:16');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-21','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-20';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-20';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-20' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-20';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-20';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-20';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-20';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-21' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-20' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-01-21';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-21 ','08:19:00');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','1','PMM-ZABX-12-0','1','2.030','2.030','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-12-0','100.00','1','2.030','2.030','1','2.030','2.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.030',berat_out_asli=berat_out_asli+'2.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','2','PMM-ZABX-13-0','1','2.030','2.030','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-13-0','100.00','1','2.030','2.030','1','2.030','2.030');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.030',berat_out_asli=berat_out_asli+'2.030',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','3','PMM-ZABX-14-0','1','2.100','2.100','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-14-0','100.00','1','2.100','2.100','1','2.100','2.100');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.100',berat_out_asli=berat_out_asli+'2.100',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','4','PMM-ZABX-15-0','1','2.130','2.130','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-15-0','100.00','1','2.130','2.130','1','2.130','2.130');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.130',berat_out_asli=berat_out_asli+'2.130',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','5','PMM-ZABX-16-0','1','1.940','1.940','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-16-0','100.00','1','1.940','1.940','1','1.940','1.940');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.940',berat_out_asli=berat_out_asli+'1.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','6','PMM-ZABX-17-0','1','4.390','4.390','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-17-0','100.00','1','4.390','4.390','1','4.390','4.390');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.390',berat_out_asli=berat_out_asli+'4.390',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-17-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','7','PMM-ZABX-18-0','1','4.530','4.530','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-18-0','100.00','1','4.530','4.530','1','4.530','4.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.530',berat_out_asli=berat_out_asli+'4.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','8','PMM-ZABX-19-0','1','4.450','4.450','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-19-0','100.00','1','4.450','4.450','1','4.450','4.450');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.450',berat_out_asli=berat_out_asli+'4.450',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-19-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','9','PMM-ZABX-20-0','1','4.440','4.440','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-20-0','100.00','1','4.440','4.440','1','4.440','4.440');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.440',berat_out_asli=berat_out_asli+'4.440',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-20-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260121-0001','10','PMM-ZABX-21-0','1','4.350','4.350','TOKO','SEM-PERAK','TOKO','MMPER');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MMPER' WHERE kode_barang='PMM-ZABX-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-21','TOKO','MMPER','PMM','PMM-ZABX-21-0','100.00','1','4.350','4.350','1','4.350','4.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.350',berat_out_asli=berat_out_asli+'4.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-21' AND kode_barang='PMM-ZABX-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-PERAK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260121-0001','2026-01-21','2026-01-21','08:23','32.39','input','2026-01-21 08:24:38');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0001','1','CKPRE-ZABX-2-0','1','2.180','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZABX-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZABX-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZABX-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZABX-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZABX-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.180',berat_out_asli='2.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.180',berat_akhir_asli =berat_akhir_asli-'2.180' WHERE kode_barang='CKPRE-ZABX-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0001','2','CKPRE-ZABX-3-0','1','2.220','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZABX-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZABX-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZABX-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZABX-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZABX-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.220',berat_out_asli='2.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.220',berat_akhir_asli =berat_akhir_asli-'2.220' WHERE kode_barang='CKPRE-ZABX-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0001','3','CKPRE-ZABX-4-0','1','1.930','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZABX-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZABX-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZABX-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZABX-4-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZABX-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.930',berat_out_asli='1.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.930',berat_akhir_asli =berat_akhir_asli-'1.930' WHERE kode_barang='CKPRE-ZABX-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0001','4','CKPRE-ZABX-5-0','1','1.840','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZABX-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZABX-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZABX-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZABX-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZABX-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.840',berat_out_asli='1.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.840',berat_akhir_asli =berat_akhir_asli-'1.840' WHERE kode_barang='CKPRE-ZABX-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0001','5','CKPRE-ZABX-6-0','1','1.730','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZABX-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZABX-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZABX-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZABX-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZABX-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.730',berat_out_asli='1.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.730',berat_akhir_asli =berat_akhir_asli-'1.730' WHERE kode_barang='CKPRE-ZABX-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260121-0001','2026-01-21','2026-01-21','08:24','1.730','input','2026-01-21 08:24:51','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','1','PMM-ZABX-7-0','1','2.090','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-7-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.090',berat_out_asli='2.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.090',berat_akhir_asli =berat_akhir_asli-'2.090' WHERE kode_barang='PMM-ZABX-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','2','PMM-ZABX-8-0','1','2.150','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.150',berat_out_asli='2.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.150',berat_akhir_asli =berat_akhir_asli-'2.150' WHERE kode_barang='PMM-ZABX-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','3','PMM-ZABX-9-0','1','1.960','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-9-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.960',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.960',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='PMM-ZABX-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','4','PMM-ZABX-10-0','1','1.930','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-10-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.930',berat_out_asli='1.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.930',berat_akhir_asli =berat_akhir_asli-'1.930' WHERE kode_barang='PMM-ZABX-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','5','PMM-ZABX-11-0','1','1.970','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='PMM-ZABX-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','6','PMM-ZABX-12-0','1','2.030','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='PMM-ZABX-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','7','PMM-ZABX-13-0','1','2.030','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-13-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.030',berat_out_asli='2.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.030',berat_akhir_asli =berat_akhir_asli-'2.030' WHERE kode_barang='PMM-ZABX-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','8','PMM-ZABX-14-0','1','2.100','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.100',berat_out_asli='2.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.100',berat_akhir_asli =berat_akhir_asli-'2.100' WHERE kode_barang='PMM-ZABX-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','9','PMM-ZABX-15-0','1','2.130','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-15-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.130',berat_out_asli='2.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.130',berat_akhir_asli =berat_akhir_asli-'2.130' WHERE kode_barang='PMM-ZABX-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','10','PMM-ZABX-16-0','1','1.940','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-16-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.940',berat_out_asli='1.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.940',berat_akhir_asli =berat_akhir_asli-'1.940' WHERE kode_barang='PMM-ZABX-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','11','PMM-ZABX-17-0','1','4.390','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-17-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.390',berat_out_asli='4.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.390',berat_akhir_asli =berat_akhir_asli-'4.390' WHERE kode_barang='PMM-ZABX-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','12','PMM-ZABX-18-0','1','4.530','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-18-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-18-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.530',berat_out_asli='4.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.530',berat_akhir_asli =berat_akhir_asli-'4.530' WHERE kode_barang='PMM-ZABX-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','13','PMM-ZABX-19-0','1','4.450','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-19-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.450',berat_out_asli='4.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.450',berat_akhir_asli =berat_akhir_asli-'4.450' WHERE kode_barang='PMM-ZABX-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','14','PMM-ZABX-20-0','1','4.440','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-20-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.440',berat_out_asli='4.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.440',berat_akhir_asli =berat_akhir_asli-'4.440' WHERE kode_barang='PMM-ZABX-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260121-0002','15','PMM-ZABX-21-0','1','4.350','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZABX-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZABX-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZABX-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZABX-21-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZABX-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.350',berat_out_asli='4.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.350',berat_akhir_asli =berat_akhir_asli-'4.350' WHERE kode_barang='PMM-ZABX-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260121-0002','2026-01-21','2026-01-21','08:25','4.350','input','2026-01-21 08:25:01','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-21 ','08:25:38');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-1-0','00041048','500K-17-2170 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','122000','2026-01-21','122000','2.030','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 09:56:57','2.030','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-1-0','00041048');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-1-0','PBDG','TOKO','PBDG','100.00','2.030','2.030','1','2.030','2.030','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-17-2170 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-2-0','00041049','500K-20-2171 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','131000','2026-01-21','131000','2.180','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 09:57:20','2.180','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-2-0','00041049');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-2-0','PBDG','TOKO','PBDG','100.00','2.180','2.180','1','2.180','2.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-20-2171 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-3-0','00041050','500K-17-2172 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','124000','2026-01-21','124000','2.060','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 09:57:42','2.060','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-3-0','00041050');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-3-0','PBDG','TOKO','PBDG','100.00','2.060','2.060','1','2.060','2.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-17-2172 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-4-0','00041051','500K-21-2173 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','126000','2026-01-21','126000','2.100','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 09:58:07','2.100','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-4-0','00041051');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-4-0','PBDG','TOKO','PBDG','100.00','2.100','2.100','1','2.100','2.100','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-21-2173 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-5-0','00041052','500K-22-2174 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','128500','2026-01-21','128500','2.140','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 09:58:26','2.140','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-5-0','00041052');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-5-0','PBDG','TOKO','PBDG','100.00','2.140','2.140','1','2.140','2.140','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-22-2174 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-6-0','00041053','700K-15-2175 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','248500','2026-01-21','248500','4.140','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 09:59:21','4.140','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-6-0','00041053');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-6-0','PBDG','TOKO','PBDG','100.00','4.140','4.140','1','4.140','4.140','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-15-2175 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-7-0','00041054','700K-18-2176 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','280000','2026-01-21','280000','4.660','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 09:59:41','4.660','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-7-0','00041054');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-7-0','PBDG','TOKO','PBDG','100.00','4.660','4.660','1','4.660','4.660','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-18-2176 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-8-0','00041055','700K-16-2177 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','255000','2026-01-21','255000','4.250','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 10:00:01','4.250','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-8-0','00041055');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-8-0','PBDG','TOKO','PBDG','100.00','4.250','4.250','1','4.250','4.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-16-2177 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-9-0','00041056','700K-16-2178 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','273000','2026-01-21','273000','4.550','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 10:00:27','4.550','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-9-0','00041056');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-9-0','PBDG','TOKO','PBDG','100.00','4.550','4.550','1','4.550','4.550','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-16-2178 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZABA-10-0','00041057','700K-16-2179 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','257500','2026-01-21','257500','4.290','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-21 10:00:48','4.290','0','','17100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZABA-10-0','00041057');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PBDG-ZABA-10-0','PBDG','TOKO','PBDG','100.00','4.290','4.290','1','4.290','4.290','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-16-2179 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01569';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZABA-11-0','00041058','DP-01569BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','342000','2026-01-21','342000','2.700','5.00','10','300000','2530000.00','1','0.14', 'input','2026-01-21 10:12:19','2.700','0','','17100.00','','TOKO','FREETAG','','10','','','PSN01569BIP','1','RS 17','','DP-01569');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZABA-11-0','00041058');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','PSPLT-ZABA-11-0','PSPLT','TOKO','PSNB','5.00','2.700','2.700','1','2.700','2.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01569BIP ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMMM-ZABA-12-0','00041059','900K-14 ','CINCIN MAS MM ','','GR','---','GOLD','CMMM','TOKO','MMCM','4368000','2026-01-21','4368000','2.080','83.00','75','100000','2530000.00','1','0.14', 'input','2026-01-21 10:16:38','2.080','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-ZABA-12-0','00041059');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CMMM-ZABA-12-0','CMMM','TOKO','MMCM','83.00','2.080','2.080','1','2.080','2.080','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CMMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','900K-14 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMMM-ZABA-13-0','00041060','900K-165 ','CINCIN MAS MM ','','GR','---','GOLD','CMMM','TOKO','MMCM','5670000','2026-01-21','5670000','2.700','83.00','75','100000','2530000.00','1','0.14', 'input','2026-01-21 10:17:33','2.700','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-ZABA-13-0','00041060');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CMMM-ZABA-13-0','CMMM','TOKO','MMCM','83.00','2.700','2.700','1','2.700','2.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CMMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','900K-165 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMMM-ZABA-14-0','00041061','900K-14 ','CINCIN MAS MM ','','GR','---','GOLD','CMMM','TOKO','MMCM','5061000','2026-01-21','5061000','2.410','83.00','75','100000','2530000.00','1','0.14', 'input','2026-01-21 10:18:19','2.410','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-ZABA-14-0','00041061');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CMMM-ZABA-14-0','CMMM','TOKO','MMCM','83.00','2.410','2.410','1','2.410','2.410','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CMMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','900K-14 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CMMM-ZABA-15-0','00041062','900K-18 ','CINCIN MAS MM ','','GR','---','GOLD','CMMM','TOKO','MMCM','5250000','2026-01-21','5250000','2.500','83.00','75','100000','2530000.00','1','0.14', 'input','2026-01-21 10:18:57','2.500','0','','17100.00','','TOKO','FREETAG','','2','','','','','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-ZABA-15-0','00041062');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CMMM-ZABA-15-0','CMMM','TOKO','MMCM','83.00','2.500','2.500','1','2.500','2.500','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CMMM';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','900K-18 ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-21 ','10:24:33');
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2623000',harga_beli ='2623000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5312500',harga_beli ='5312500' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='207000',harga_beli ='207000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='3005500',harga_beli ='3005500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='6654500',harga_beli ='6654500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2493000',harga_beli ='2493000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2384500',harga_beli ='2384500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2428000',harga_beli ='2428000' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5787500',harga_beli ='5787500' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='21372000',harga_beli ='21372000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2973500',harga_beli ='2973500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2946500',harga_beli ='2946500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2784500',harga_beli ='2784500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2892500',harga_beli ='2892500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2865500',harga_beli ='2865500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='8043000',harga_beli ='8043000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='3079500',harga_beli ='3079500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='11031500',harga_beli ='11031500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='3979500',harga_beli ='3979500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='4677500',harga_beli ='4677500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='4804500',harga_beli ='4804500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5651500',harga_beli ='5651500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='4572000',harga_beli ='4572000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='6540500',harga_beli ='6540500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='7810000',harga_beli ='7810000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='9418500',harga_beli ='9418500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='7619500',harga_beli ='7619500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='1587500',harga_beli ='1587500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2942000',harga_beli ='2942000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='4487500',harga_beli ='4487500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='4064000',harga_beli ='4064000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2328500',harga_beli ='2328500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2244000',harga_beli ='2244000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='6879000',harga_beli ='6879000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='8254500',harga_beli ='8254500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='3683000',harga_beli ='3683000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='7302000',harga_beli ='7302000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5799500',harga_beli ='5799500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2815000',harga_beli ='2815000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='2392000',harga_beli ='2392000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5439500',harga_beli ='5439500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='3810000',harga_beli ='3810000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5647500',harga_beli ='5647500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='7281000',harga_beli ='7281000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='11027000',harga_beli ='11027000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='9948000',harga_beli ='9948000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='3640500',harga_beli ='3640500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5672500',harga_beli ='5672500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='7916000',harga_beli ='7916000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='7217500',harga_beli ='7217500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='7429000',harga_beli ='7429000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='8530000',harga_beli ='8530000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='17017000',harga_beli ='17017000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='1736000',harga_beli ='1736000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='1736000',harga_beli ='1736000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='1651000',harga_beli ='1651000' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='1587500',harga_beli ='1587500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5249000',harga_beli ='5249000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='9016500',harga_beli ='9016500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='10307500',harga_beli ='10307500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='8762500',harga_beli ='8762500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='8212500',harga_beli ='8212500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='8995500',harga_beli ='8995500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='8022000',harga_beli ='8022000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='4783500',harga_beli ='4783500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='57421000',harga_beli ='57421000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='8932000',harga_beli ='8932000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='8254500',harga_beli ='8254500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='6117000',harga_beli ='6117000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='11747000',harga_beli ='11747000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='13632000',harga_beli ='13632000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='7831500',harga_beli ='7831500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='6328500',harga_beli ='6328500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='6942500',harga_beli ='6942500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5439500',harga_beli ='5439500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2550000','input','2026-01-21 10:53:10');
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='17882000',harga_beli ='17882000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='10491000',harga_beli ='10491000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5527500',harga_beli ='5527500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5571000',harga_beli ='5571000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='6464500',harga_beli ='6464500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='4906500',harga_beli ='4906500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='12186500',harga_beli ='12186500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='3740500',harga_beli ='3740500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='14025000',harga_beli ='14025000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='6667500',harga_beli ='6667500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='4402500',harga_beli ='4402500' WHERE kode_barcode='00041059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5715000',harga_beli ='5715000' WHERE kode_barcode='00041060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5101000',harga_beli ='5101000' WHERE kode_barcode='00041061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='5291500',harga_beli ='5291500' WHERE kode_barcode='00041062' LIMIT 1;
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2550000','input','2026-01-21 10:53:17');
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2550000','input','2026-01-21 10:53:20');
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2550000','input','2026-01-21 10:53:24');
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2550000','input','2026-01-21 10:53:27');
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2550000','input','2026-01-21 10:53:31');
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2550000','input','2026-01-21 10:53:35');
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2550000','input','2026-01-21 10:53:39');
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='3852500',harga_beli ='3852500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2550000','input','2026-01-21 10:53:43');
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2550000','input','2026-01-21 10:53:48');
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2550000','input','2026-01-21 10:53:52');
UPDATE tm_barang SET harga_skrg ='2550000',harga_jual='344500',harga_beli ='344500' WHERE kode_barcode='00041058' LIMIT 1;
UPDATE tm_group SET harga='2550000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2550000','input','2026-01-21 10:53:55');
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2715500',harga_beli ='2715500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5500000',harga_beli ='5500000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='214000',harga_beli ='214000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3112000',harga_beli ='3112000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6889500',harga_beli ='6889500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2468500',harga_beli ='2468500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2513500',harga_beli ='2513500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5992000',harga_beli ='5992000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='22126000',harga_beli ='22126000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3078500',harga_beli ='3078500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3050500',harga_beli ='3050500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2882500',harga_beli ='2882500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2994500',harga_beli ='2994500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2966500',harga_beli ='2966500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8327000',harga_beli ='8327000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3188000',harga_beli ='3188000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='11421000',harga_beli ='11421000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4119500',harga_beli ='4119500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4843000',harga_beli ='4843000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4974500',harga_beli ='4974500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5851000',harga_beli ='5851000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4733500',harga_beli ='4733500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6771000',harga_beli ='6771000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8086000',harga_beli ='8086000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9751000',harga_beli ='9751000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7888500',harga_beli ='7888500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3046000',harga_beli ='3046000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4645500',harga_beli ='4645500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4207500',harga_beli ='4207500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2410500',harga_beli ='2410500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2323000',harga_beli ='2323000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7121500',harga_beli ='7121500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8546000',harga_beli ='8546000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3813000',harga_beli ='3813000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7560000',harga_beli ='7560000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6004000',harga_beli ='6004000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2476500',harga_beli ='2476500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5631500',harga_beli ='5631500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3944500',harga_beli ='3944500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5846500',harga_beli ='5846500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7538000',harga_beli ='7538000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='11416500',harga_beli ='11416500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='10299000',harga_beli ='10299000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3769000',harga_beli ='3769000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5872500',harga_beli ='5872500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8195500',harga_beli ='8195500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7472500',harga_beli ='7472500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7691500',harga_beli ='7691500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8831000',harga_beli ='8831000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='17617500',harga_beli ='17617500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1797000',harga_beli ='1797000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1797000',harga_beli ='1797000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1709500',harga_beli ='1709500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5434500',harga_beli ='5434500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9335000',harga_beli ='9335000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='10671500',harga_beli ='10671500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9072000',harga_beli ='9072000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8502000',harga_beli ='8502000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9313000',harga_beli ='9313000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8305000',harga_beli ='8305000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4952500',harga_beli ='4952500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='59447500',harga_beli ='59447500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9247000',harga_beli ='9247000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8546000',harga_beli ='8546000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6333000',harga_beli ='6333000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='12161500',harga_beli ='12161500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='14113000',harga_beli ='14113000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8107500',harga_beli ='8107500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6552000',harga_beli ='6552000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7187500',harga_beli ='7187500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5631500',harga_beli ='5631500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2640000','input','2026-01-21 13:06:34');
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='18513000',harga_beli ='18513000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='10861000',harga_beli ='10861000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5722500',harga_beli ='5722500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5767500',harga_beli ='5767500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6692500',harga_beli ='6692500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5080000',harga_beli ='5080000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='12617000',harga_beli ='12617000' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3872500',harga_beli ='3872500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='14520500',harga_beli ='14520500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6902500',harga_beli ='6902500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4558000',harga_beli ='4558000' WHERE kode_barcode='00041059' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5916500',harga_beli ='5916500' WHERE kode_barcode='00041060' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5281000',harga_beli ='5281000' WHERE kode_barcode='00041061' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5478000',harga_beli ='5478000' WHERE kode_barcode='00041062' LIMIT 1;
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2640000','input','2026-01-21 13:06:43');
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2640000','input','2026-01-21 13:06:48');
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2640000','input','2026-01-21 13:06:51');
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2640000','input','2026-01-21 13:06:55');
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2640000','input','2026-01-21 13:06:59');
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2640000','input','2026-01-21 13:07:13');
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2640000','input','2026-01-21 13:07:17');
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3988500',harga_beli ='3988500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2640000','input','2026-01-21 13:07:21');
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2640000','input','2026-01-21 13:07:25');
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2640000','input','2026-01-21 13:07:29');
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='356500',harga_beli ='356500' WHERE kode_barcode='00041058' LIMIT 1;
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2640000','input','2026-01-21 13:07:34');
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2715500',harga_beli ='2715500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5500000',harga_beli ='5500000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='214000',harga_beli ='214000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3112000',harga_beli ='3112000' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6889500',harga_beli ='6889500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2581000',harga_beli ='2581000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2468500',harga_beli ='2468500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2513500',harga_beli ='2513500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5992000',harga_beli ='5992000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='22126000',harga_beli ='22126000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3078500',harga_beli ='3078500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3050500',harga_beli ='3050500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2882500',harga_beli ='2882500' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2994500',harga_beli ='2994500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2966500',harga_beli ='2966500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8327000',harga_beli ='8327000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3188000',harga_beli ='3188000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='11421000',harga_beli ='11421000' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4119500',harga_beli ='4119500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4843000',harga_beli ='4843000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4974500',harga_beli ='4974500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5851000',harga_beli ='5851000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4733500',harga_beli ='4733500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6771000',harga_beli ='6771000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8086000',harga_beli ='8086000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9751000',harga_beli ='9751000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7888500',harga_beli ='7888500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3046000',harga_beli ='3046000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4645500',harga_beli ='4645500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4207500',harga_beli ='4207500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2410500',harga_beli ='2410500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2323000',harga_beli ='2323000' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7121500',harga_beli ='7121500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8546000',harga_beli ='8546000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3813000',harga_beli ='3813000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7560000',harga_beli ='7560000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6004000',harga_beli ='6004000' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2914500',harga_beli ='2914500' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='2476500',harga_beli ='2476500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5631500',harga_beli ='5631500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3944500',harga_beli ='3944500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5846500',harga_beli ='5846500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7538000',harga_beli ='7538000' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='11416500',harga_beli ='11416500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='10299000',harga_beli ='10299000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='3769000',harga_beli ='3769000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5872500',harga_beli ='5872500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8195500',harga_beli ='8195500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7472500',harga_beli ='7472500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7691500',harga_beli ='7691500' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8831000',harga_beli ='8831000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='17617500',harga_beli ='17617500' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1797000',harga_beli ='1797000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1797000',harga_beli ='1797000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1709500',harga_beli ='1709500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='1643500',harga_beli ='1643500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5434500',harga_beli ='5434500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9335000',harga_beli ='9335000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='10671500',harga_beli ='10671500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9072000',harga_beli ='9072000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8502000',harga_beli ='8502000' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9313000',harga_beli ='9313000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8305000',harga_beli ='8305000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='4952500',harga_beli ='4952500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='59447500',harga_beli ='59447500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='9247000',harga_beli ='9247000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8546000',harga_beli ='8546000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6333000',harga_beli ='6333000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='12161500',harga_beli ='12161500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='14113000',harga_beli ='14113000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='8107500',harga_beli ='8107500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='6552000',harga_beli ='6552000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='7187500',harga_beli ='7187500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2640000',harga_jual='5631500',harga_beli ='5631500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2640000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2640000','input','2026-01-21 13:16:58');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-16-0','00041063','CBRE-06951 ','CINCIN CBRE-06951 ','','GR','---','DM','CBRE','TOKO','CBRE','7713500','2026-01-21','7713500','3.520','83.00','75','0','2640000.00','1','0.04', 'input','2026-01-21 13:20:11','3.520','695000','277.00','17100.00','','TOKO','FREETAG','','10','','','IDR 51 000 000','1','RS 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-16-0','00041063');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-16-0','CBRE','TOKO','CBRE','83.00','3.520','3.520','1','3.520','3.520','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06951 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-16-0','00041063','SP','1','2.940 ','50','147');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-16-0','00041063','RD','16','0.325 ','400','130');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-17-0','00041064','CBRE-06952 ','CINCIN CBRE-06952 ','','GR','---','DM','CBRE','TOKO','CBRE','8392500','2026-01-21','8392500','3.830','83.00','75','0','2640000.00','1','0.04', 'input','2026-01-21 13:22:39','3.830','730000','115.85','17100.00','','TOKO','FREETAG','','10','','','','1','RS 13','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-17-0','00041064');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-17-0','CBRE','TOKO','CBRE','83.00','3.830','3.830','1','3.830','3.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06952 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-17-0','00041064','BD','1','1.655 ','70','115.85');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-18-0','00041065','CBRE-06953 ','CINCIN CBRE-06953 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','7121500','2026-01-21','7121500','3.250','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:32:06','3.250','749500','275.25','17100.00','','TOKO','FREETAG','','10','','','IDR 45 000 000','1','RS125 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-18-0','00041065');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-18-0','CBRE','TOKO','SEM-ELCO','83.00','3.250','3.250','1','3.250','3.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06953 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-18-0','00041065','RD','33','0.200 ','450','90');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-18-0','00041065','RD','1','0.195 ','950','185.25');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-19-0','00041066','CBRE-06954 ','CINCIN CBRE-06954 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','3046000','2026-01-21','3046000','1.390','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:34:13','1.390','505000','58.50','17100.00','','TOKO','FREETAG','','10','','','IDR 17 500 000','1','C1155 RS14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-19-0','00041066');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-19-0','CBRE','TOKO','SEM-ELCO','83.00','1.390','1.390','1','1.390','1.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06954 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-19-0','00041066','RD','22','0.130 ','450','58.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-20-0','00041067','CBRE-06955 ','CINCIN CBRE-06955 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','8129500','2026-01-21','8129500','3.710','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:36:55','3.710','840000','177.30','17100.00','','TOKO','FREETAG','','10','','','IDR 43 000 000','1','C1376 RS17 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-20-0','00041067');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-20-0','CBRE','TOKO','SEM-ELCO','83.00','3.710','3.710','1','3.710','3.710','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06955 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-20-0','00041067','RD','41','0.240 ','450','108');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-20-0','00041067','RD','10','0.095 ','420','39.9');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-20-0','00041067','RD','4','0.070 ','420','29.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-21-0','00041068','CBRE-06956 ','CINCIN CBRE-06956 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4840500','2026-01-21','4840500','1.780','103.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:39:33','1.780','370000','135.00','17100.00','','TOKO','FREETAG','','10','','','IDR 28 000 000','1','RS13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-21-0','00041068');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-21-0','CBRE','TOKO','SEM-ELCO','103.00','1.780','1.780','1','1.780','1.780','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06956 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-21-0','00041068','RD','34','0.220 ','450','99');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-21-0','00041068','RD','1','0.075 ','480','36');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-22-0','00041069','CBRE-06957 ','CINCIN CBRE-06957 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','1578000','2026-01-21','1578000','0.720','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:41:28','0.720','400000','8.40','17100.00','','TOKO','FREETAG','','10','','','IDR 8 000 000','1','C1502 115 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-22-0','00041069');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-22-0','CBRE','TOKO','SEM-ELCO','83.00','0.720','0.720','1','0.720','0.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06957 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-22-0','00041069','RD','1','0.020 ','420','8.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-23-0','00041070','CBRE-06958 ','CINCIN CBRE-06958 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','7910500','2026-01-21','7910500','3.610','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:43:42','3.610','787000','225.30','17100.00','','TOKO','FREETAG','','10','','','IDR 45 000 000','1','C1435 RS15 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-23-0','00041070');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-23-0','CBRE','TOKO','SEM-ELCO','83.00','3.610','3.610','1','3.610','3.610','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06958 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-23-0','00041070','RD','28','0.130 ','450','58.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-23-0','00041070','RD','14','0.220 ','420','92.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-23-0','00041070','RD','1','0.120 ','620','74.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-24-0','00041071','CBRE-06959 ','CINCIN CBRE-06959 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4361000','2026-01-21','4361000','1.990','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:45:56','1.990','418000','241.50','17100.00','','TOKO','FREETAG','','10','','','IDR 32 000 000','1','RS125 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-24-0','00041071');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-24-0','CBRE','TOKO','SEM-ELCO','83.00','1.990','1.990','1','1.990','1.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06959 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-24-0','00041071','RD','1','0.230 ','1050','241.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-25-0','00041072','CBRE-06960 ','CINCIN CBRE-06960 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','3988500','2026-01-21','3988500','1.820','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:48:16','1.820','460000','147.00','17100.00','','TOKO','FREETAG','','10','','','IDR 26 000 000','1','C996 RS13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-25-0','00041072');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-25-0','CBRE','TOKO','SEM-ELCO','83.00','1.820','1.820','1','1.820','1.820','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06960 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-25-0','00041072','RD','13','0.350 ','420','147');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-26-0','00041073','CBRE-06961 ','CINCIN CBRE-06961 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','5018000','2026-01-21','5018000','2.290','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:50:04','2.290','505000','54.00','17100.00','','TOKO','FREETAG','','10','','','IDR 24 000 000','1','RS14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-26-0','00041073');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-26-0','CBRE','TOKO','SEM-ELCO','83.00','2.290','2.290','1','2.290','2.290','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06961 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-26-0','00041073','RD','20','0.120 ','450','54');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-27-0','00041074','CBRE-06962 ','CINCIN CBRE-06962 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4273000','2026-01-21','4273000','1.950','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:51:55','1.950','530000','154.05','17100.00','','TOKO','FREETAG','','10','','','IDR 28 000 000','1','RS13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-27-0','00041074');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-27-0','CBRE','TOKO','SEM-ELCO','83.00','1.950','1.950','1','1.950','1.950','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06962 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-27-0','00041074','RD','20','0.085 ','450','38.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-27-0','00041074','RD','6','0.190 ','420','79.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-27-0','00041074','RD','1','0.075 ','480','36');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-28-0','00041075','CBRE-06963 ','CINCIN CBRE-06963 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','1074000','2026-01-21','1074000','0.490','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:54:22','0.490','400000','12.60','17100.00','','TOKO','FREETAG','','10','','','IDR 6 000 000','1','C1502 12 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-28-0','00041075');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-28-0','CBRE','TOKO','SEM-ELCO','83.00','0.490','0.490','1','0.490','0.490','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06963 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-28-0','00041075','RD','1','0.030 ','420','12.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-29-0','00041076','CBRE-06964 ','CINCIN CBRE-06964 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4677500','2026-01-21','4677500','1.720','103.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:56:16','1.720','396000','117.70','17100.00','','TOKO','FREETAG','','10','','','IDR 26 500 000','1','RS13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-29-0','00041076');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-29-0','CBRE','TOKO','SEM-ELCO','103.00','1.720','1.720','1','1.720','1.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06964 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-29-0','00041076','RD','38','0.110 ','450','49.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-29-0','00041076','RD','1','0.110 ','620','68.2');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-30-0','00041077','CBRE-06965 ','CINCIN CBRE-06965 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','3199500','2026-01-21','3199500','1.460','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 14:58:26','1.460','470000','142.80','17100.00','','TOKO','FREETAG','','10','','','IDR 23 000 000','1','C997 RS11 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-30-0','00041077');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-30-0','CBRE','TOKO','SEM-ELCO','83.00','1.460','1.460','1','1.460','1.460','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06965 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-30-0','00041077','RD','15','0.340 ','420','142.8');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-31-0','00041078','CBRE-06966 ','CINCIN CBRE-06966 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','1205500','2026-01-21','1205500','0.550','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:00:12','0.550','400000','8.40','17100.00','','TOKO','FREETAG','','10','','','IDR 6 000 000','1','C1502 RS12 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-31-0','00041078');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-31-0','CBRE','TOKO','SEM-ELCO','83.00','0.550','0.550','1','0.550','0.550','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06966 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-31-0','00041078','RD','1','0.020 ','420','8.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-32-0','00041079','CBRE-06967 ','CINCIN CBRE-06967 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4361000','2026-01-21','4361000','1.990','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:01:59','1.990','450000','71.40','17100.00','','TOKO','FREETAG','','10','','','IDR 22 500 000','1','RS14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-32-0','00041079');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-32-0','CBRE','TOKO','SEM-ELCO','83.00','1.990','1.990','1','1.990','1.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06967 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-32-0','00041079','RD','11','0.170 ','420','71.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-33-0','00041080','CBRE-06968 ','CINCIN CBRE-06968 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','5741000','2026-01-21','5741000','2.620','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:03:54','2.620','540000','151.50','17100.00','','TOKO','FREETAG','','10','','','IDR 33 000 000','1','RS15 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-33-0','00041080');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-33-0','CBRE','TOKO','SEM-ELCO','83.00','2.620','2.620','1','2.620','2.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06968 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-33-0','00041080','RD','1','0.065 ','480','31.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-33-0','00041080','RD','6','0.190 ','420','79.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-33-0','00041080','RD','20','0.090 ','450','40.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-34-0','00041081','CBRE-06969 ','CINCIN CBRE-06969 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4106500','2026-01-21','4106500','1.510','103.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:05:52','1.510','367000','110.40','17100.00','','TOKO','FREETAG','','10','','','IDR 24 000 000','1','RS13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-34-0','00041081');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-34-0','CBRE','TOKO','SEM-ELCO','103.00','1.510','1.510','1','1.510','1.510','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06969 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-34-0','00041081','RD','32','0.080 ','450','36');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-34-0','00041081','RD','1','0.120 ','620','74.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-35-0','00041082','CBRE-06970 ','CINCIN CBRE-06970 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','2498000','2026-01-21','2498000','1.140','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:07:38','1.140','480000','63.90','17100.00','','TOKO','FREETAG','','10','','','IDR 16 000 000','1','C1548 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-35-0','00041082');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-35-0','CBRE','TOKO','SEM-ELCO','83.00','1.140','1.140','1','1.140','1.140','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06970 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-35-0','00041082','RD','14','0.100 ','450','45');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-35-0','00041082','RD','3','0.045 ','420','18.9');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-36-0','00041083','CBRE-06971 ','CINCIN CBRE-06971 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','2695500','2026-01-21','2695500','1.230','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:09:20','1.230','440000','65.25','17100.00','','TOKO','FREETAG','','10','','','IDR 16 500 000','1','C1563 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-36-0','00041083');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-36-0','CBRE','TOKO','SEM-ELCO','83.00','1.230','1.230','1','1.230','1.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06971 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-36-0','00041083','RD','1','0.075 ','480','36');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-36-0','00041083','RD','8','0.065 ','450','29.25');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-37-0','00041084','CBRE-06972 ','CINCIN CBRE-06972 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4295000','2026-01-21','4295000','1.960','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:11:32','1.960','478000','173.25','17100.00','','TOKO','FREETAG','','10','','','IDR 29 000 000','1','C1362 13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-37-0','00041084');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-37-0','CBRE','TOKO','SEM-ELCO','83.00','1.960','1.960','1','1.960','1.960','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06972 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-37-0','00041084','RD','13','0.085 ','450','38.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-37-0','00041084','RD','1','0.180 ','750','135');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-38-0','00041085','CBRE-06973 ','CINCIN CBRE-06973 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','1797000','2026-01-21','1797000','0.820','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:14:04','0.820','470000','38.25','17100.00','','TOKO','FREETAG','','10','','','IDR 11 000 000','1','RS145 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-38-0','00041085');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-38-0','CBRE','TOKO','SEM-ELCO','83.00','0.820','0.820','1','0.820','0.820','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06973 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-38-0','00041085','RD','15','0.085 ','450','38.25');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-39-0','00041086','CBRE-06974 ','CINCIN CBRE-06974 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4273000','2026-01-21','4273000','1.950','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:15:45','1.950','450000','201.60','17100.00','','TOKO','FREETAG','','10','','','IDR 30 500 000','1','C205 15 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-39-0','00041086');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-39-0','CBRE','TOKO','SEM-ELCO','83.00','1.950','1.950','1','1.950','1.950','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06974 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-39-0','00041086','RD','11','0.480 ','420','201.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-40-0','00041087','CBRE-06975 ','CINCIN CBRE-06975 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','2502000','2026-01-21','2502000','0.920','103.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:17:30','0.920','220000','17.10','17100.00','','TOKO','FREETAG','','10','','','IDR 11 000 000','1','RS115 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-40-0','00041087');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-40-0','CBRE','TOKO','SEM-ELCO','103.00','0.920','0.920','1','0.920','0.920','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06975 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-40-0','00041087','RD','4','0.010 ','450','4.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-40-0','00041087','RD','1','0.030 ','420','12.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-41-0','00041088','CBRE-06976 ','CINCIN CBRE-06976 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','3353000','2026-01-21','3353000','1.530','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:19:17','1.530','425000','52.50','17100.00','','TOKO','FREETAG','','10','','','IDR 18 000 000','1','C1582 12 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-41-0','00041088');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-41-0','CBRE','TOKO','SEM-ELCO','83.00','1.530','1.530','1','1.530','1.530','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06976 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-41-0','00041088','RD','6','0.125 ','420','52.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-42-0','00041089','CBRE-06977 ','CINCIN CBRE-06977 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','2739000','2026-01-21','2739000','1.250','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:21:21','1.250','450000','65.25','17100.00','','TOKO','FREETAG','','10','','','IDR 16 500 000','1','RS12 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-42-0','00041089');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-42-0','CBRE','TOKO','SEM-ELCO','83.00','1.250','1.250','1','1.250','1.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06977 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-42-0','00041089','RD','10','0.065 ','450','29.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-42-0','00041089','RD','1','0.075 ','480','36');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-43-0','00041090','CBRE-06978 ','CINCIN CBRE-06978 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','3900500','2026-01-21','3900500','1.780','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:23:11','1.780','487000','152.10','17100.00','','TOKO','FREETAG','','10','','','IDR 26 000 000','1','S60 12 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-43-0','00041090');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-43-0','CBRE','TOKO','SEM-ELCO','83.00','1.780','1.780','1','1.780','1.780','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06978 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-43-0','00041090','RD','16','0.185 ','420','77.7');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-43-0','00041090','RD','1','0.120 ','620','74.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-44-0','00041091','CBRE-06979 ','CINCIN CBRE-06979 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4054000','2026-01-21','4054000','1.850','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:25:18','1.850','505000','62.85','17100.00','','TOKO','FREETAG','','10','','','IDR 21 000 000','1','C1462 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-44-0','00041091');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-44-0','CBRE','TOKO','SEM-ELCO','83.00','1.850','1.850','1','1.850','1.850','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06979 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-44-0','00041091','RD','15','0.065 ','450','29.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-44-0','00041091','RD','6','0.055 ','420','23.1');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-44-0','00041091','RD','1','0.025 ','420','10.5');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-45-0','00041092','CBRE-06980 ','CINCIN CBRE-06980 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','4119500','2026-01-21','4119500','1.880','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:27:07','1.880','480000','117.60','17100.00','','TOKO','FREETAG','','10','','','IDR 24 500 000','1','RS13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-45-0','00041092');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-45-0','CBRE','TOKO','SEM-ELCO','83.00','1.880','1.880','1','1.880','1.880','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06980 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-45-0','00041092','RD','9','0.185 ','420','77.7');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-45-0','00041092','RD','8','0.095 ','420','39.9');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-46-0','00041093','CBRE-06981 ','CINCIN CBRE-06981 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','3594000','2026-01-21','3594000','1.640','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:28:53','1.640','480000','153.30','17100.00','','TOKO','FREETAG','','10','','','IDR 25 000 000','1','C125 13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-46-0','00041093');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-46-0','CBRE','TOKO','SEM-ELCO','83.00','1.640','1.640','1','1.640','1.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06981 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-46-0','00041093','RD','17','0.365 ','420','153.3');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZABA-47-0','00041094','CBRE-06982 ','CINCIN CBRE-06982 ','','GR','---','DM','CBRE','TOKO','SEM-ELCO','3637500','2026-01-21','3637500','1.660','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:30:29','1.660','480000','142.80','17100.00','','TOKO','FREETAG','','10','','','IDR 25 000 000','1','C125 12 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZABA-47-0','00041094');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','CBRE-ZABA-47-0','CBRE','TOKO','SEM-ELCO','83.00','1.660','1.660','1','1.660','1.660','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06982 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZABA-47-0','00041094','RD','17','0.340 ','420','142.8');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-48-0','00041095','TFC-21491 ','CINCIN TFC-21491 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','4079000','2026-01-21','4079000','1.500','103.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:56:41','1.500','225000','86.10','17100.00','','TOKO','FREETAG','','10','','','IDR 21 500 000','1','RS15 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-48-0','00041095');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-48-0','TFC','TOKO','SEM-THIFA','103.00','1.500','1.500','1','1.500','1.500','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21491 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-48-0','00041095','RD','6','0.205 ','420','86.1');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-49-0','00041096','TFC-21492 ','CINCIN TFC-21492 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','5040000','2026-01-21','5040000','2.300','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 15:58:51','2.300','456000','106.00','17100.00','','TOKO','FREETAG','','10','','','IDR 27 000 000','1','C1545 135 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-49-0','00041096');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-49-0','TFC','TOKO','SEM-THIFA','83.00','2.300','2.300','1','2.300','2.300','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21492 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-49-0','00041096','RD','6','0.050 ','420','21');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-49-0','00041096','RD','2','0.040 ','420','16.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-49-0','00041096','RD','1','0.110 ','620','68.2');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-50-0','00041097','TFC-21493 ','CINCIN TFC-21493 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','3857000','2026-01-21','3857000','1.760','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:01:02','1.760','489000','283.50','17100.00','','TOKO','FREETAG','','10','','','IDR 33 000 000','1','S33 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-50-0','00041097');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-50-0','TFC','TOKO','SEM-THIFA','83.00','1.760','1.760','1','1.760','1.760','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21493 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-50-0','00041097','RD','8','0.035 ','450','15.75');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-50-0','00041097','RD','6','0.035 ','450','15.75');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-50-0','00041097','RD','1','0.240 ','1050','252');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-51-0','00041098','TFC-21494 ','CINCIN TFC-21494 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','4119500','2026-01-21','4119500','1.880','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:03:39','1.880','460000','147.00','17100.00','','TOKO','FREETAG','','10','','','IDR 26 000 000','1','C996 15 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-51-0','00041098');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-51-0','TFC','TOKO','SEM-THIFA','83.00','1.880','1.880','1','1.880','1.880','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21494 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-51-0','00041098','RD','13','0.350 ','420','147');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-52-0','00041099','TFC-21495 ','CINCIN TFC-21495 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','7121500','2026-01-21','7121500','3.250','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:05:46','3.250','770000','171.15','17100.00','','TOKO','FREETAG','','10','','','IDR 39 000 000','1','RS14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-52-0','00041099');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-52-0','TFC','TOKO','SEM-THIFA','83.00','3.250','3.250','1','3.250','3.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21495 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-52-0','00041099','RD','1','0.030 ','420','12.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-52-0','00041099','RD','6','0.075 ','420','31.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-52-0','00041099','RD','12','0.190 ','420','79.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-52-0','00041099','RD','22','0.105 ','450','47.25');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-53-0','00041100','TFC-21496 ','CINCIN TFC-21496 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','8283000','2026-01-21','8283000','3.780','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:08:00','3.780','750000','122.40','17100.00','','TOKO','FREETAG','','10','','','IDR 40 000 000','1','RS15 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-53-0','00041100');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-53-0','TFC','TOKO','SEM-THIFA','83.00','3.780','3.780','1','3.780','3.780','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21496 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-53-0','00041100','RD','28','0.160 ','450','72');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-53-0','00041100','RD','7','0.095 ','420','39.9');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-53-0','00041100','RD','2','0.025 ','420','10.5');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-54-0','00041101','TFC-21497 ','CINCIN TFC-21497 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','3922500','2026-01-21','3922500','1.790','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:09:36','1.790','460000','161.70','17100.00','','TOKO','FREETAG','','10','','','IDR 26 000 000','1','C996 11 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-54-0','00041101');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-54-0','TFC','TOKO','SEM-THIFA','83.00','1.790','1.790','1','1.790','1.790','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21497 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-54-0','00041101','RD','13','0.385 ','420','161.7');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-55-0','00041102','TFC-21498 ','CINCIN TFC-21498 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','5566000','2026-01-21','5566000','2.540','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:11:50','2.540','565000','92.70','17100.00','','TOKO','FREETAG','','10','','','IDR 29 000 000','1','C697675 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-55-0','00041102');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-55-0','TFC','TOKO','SEM-THIFA','83.00','2.540','2.540','1','2.540','2.540','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21498 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-55-0','00041102','RD','24','0.080 ','450','36');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-55-0','00041102','RD','4','0.060 ','420','25.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-55-0','00041102','RD','3','0.060 ','420','25.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-55-0','00041102','RD','1','0.015 ','420','6.3');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-56-0','00041103','TFC-21499 ','CINCIN TFC-21499 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','7695500','2026-01-21','7695500','2.830','103.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:14:31','2.830','336000','228.55','17100.00','','TOKO','FREETAG','','10','','','IDR 43 000 000','1','RS135 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-56-0','00041103');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-56-0','TFC','TOKO','SEM-THIFA','103.00','2.830','2.830','1','2.830','2.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21499 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-56-0','00041103','RD','8','0.025 ','450','11.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-56-0','00041103','RD','16','0.355 ','420','149.1');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-56-0','00041103','RD','1','0.110 ','620','68.2');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-57-0','00041104','TFC-21500 ','CINCIN TFC-21500 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','3966500','2026-01-21','3966500','1.810','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:16:14','1.810','470000','136.50','17100.00','','TOKO','FREETAG','','10','','','IDR 25 000 000','1','C997 11 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-57-0','00041104');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-57-0','TFC','TOKO','SEM-THIFA','83.00','1.810','1.810','1','1.810','1.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21500 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-57-0','00041104','RD','15','0.325 ','420','136.5');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-58-0','00041105','TFC-21501 ','CINCIN TFC-21501 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','3068000','2026-01-21','3068000','1.400','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:18:24','1.400','505000','67.50','17100.00','','TOKO','FREETAG','','10','','','IDR 18 500 000','1','C1162 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-58-0','00041105');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-58-0','TFC','TOKO','SEM-THIFA','83.00','1.400','1.400','1','1.400','1.400','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21501 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-58-0','00041105','RD','22','0.150 ','450','67.5');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-59-0','00041106','TFC-21502 ','CINCIN TFC-21502 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','1731500','2026-01-21','1731500','0.790','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:20:06','0.790','465000','31.50','17100.00','','TOKO','FREETAG','','10','','','IDR 10 500 000','1','RS135 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-59-0','00041106');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-59-0','TFC','TOKO','SEM-THIFA','83.00','0.790','0.790','1','0.790','0.790','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21502 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-59-0','00041106','RD','14','0.070 ','450','31.5');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-60-0','00041107','TFC-21503 ','CINCIN TFC-21503 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','3900500','2026-01-21','3900500','1.780','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:22:12','1.780','505000','67.50','17100.00','','TOKO','FREETAG','','10','','','IDR 21 000 000','1','C1462 13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-60-0','00041107');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-60-0','TFC','TOKO','SEM-THIFA','83.00','1.780','1.780','1','1.780','1.780','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21503 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-60-0','00041107','RD','15','0.080 ','450','36');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-60-0','00041107','RD','6','0.055 ','420','23.1');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-60-0','00041107','RD','1','0.020 ','420','8.4');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-61-0','00041108','TFC-21504 ','CINCIN TFC-21504 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','7406500','2026-01-21','7406500','3.380','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:24:05','3.380','784000','372.30','17100.00','','TOKO','FREETAG','','10','','','IDR 52 000 000','1','C1120 15 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-61-0','00041108');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-61-0','TFC','TOKO','SEM-THIFA','83.00','3.380','3.380','1','3.380','3.380','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21504 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-61-0','00041108','RD','1','0.190 ','900','171');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-61-0','00041108','RD','12','0.340 ','420','142.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-61-0','00041108','RD','16','0.090 ','450','40.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-61-0','00041108','RD','12','0.040 ','450','18');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-62-0','00041109','TFC-21505 ','CINCIN TFC-21505 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','4076000','2026-01-21','4076000','1.860','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:25:46','1.860','460000','147.00','17100.00','','TOKO','FREETAG','','10','','','IDR 26 000 000','1','C996 145 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-62-0','00041109');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-62-0','TFC','TOKO','SEM-THIFA','83.00','1.860','1.860','1','1.860','1.860','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21505 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-62-0','00041109','RD','13','0.350 ','420','147');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-63-0','00041110','TFC-21506 ','CINCIN TFC-21506 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','8787000','2026-01-21','8787000','4.010','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:27:37','4.010','840000','218.70','17100.00','','TOKO','FREETAG','','10','','','IDR 48 000 000','1','C1394 16 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-63-0','00041110');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-63-0','TFC','TOKO','SEM-THIFA','83.00','4.010','4.010','1','4.010','4.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21506 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-63-0','00041110','RD','34','0.150 ','450','67.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-63-0','00041110','RD','18','0.330 ','420','138.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-63-0','00041110','RD','1','0.030 ','420','12.6');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-64-0','00041111','TFC-21507 ','CINCIN TFC-21507 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','8918500','2026-01-21','8918500','4.070','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:31:08','4.070','1040000','282.30','17100.00','','TOKO','FREETAG','','10','','','IDR 53 000 000','1','C1389 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-64-0','00041111');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-64-0','TFC','TOKO','SEM-THIFA','83.00','4.070','4.070','1','4.070','4.070','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21507 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-64-0','00041111','RD','74','0.310 ','450','139.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-64-0','00041111','RD','18','0.320 ','420','134.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-64-0','00041111','RD','1','0.020 ','420','8.4');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-65-0','00041112','TFC-21508 ','CINCIN TFC-21508 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','8677500','2026-01-21','8677500','3.960','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:33:24','3.960','810000','258.15','17100.00','','TOKO','FREETAG','','10','','','IDR 50 000 000','1','C1264 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-65-0','00041112');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-65-0','TFC','TOKO','SEM-THIFA','83.00','3.960','3.960','1','3.960','3.960','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21508 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-65-0','00041112','RD','30','0.205 ','450','92.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-65-0','00041112','RD','8','0.150 ','420','63');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-65-0','00041112','RD','7','0.195 ','420','81.9');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-65-0','00041112','RD','4','0.050 ','420','21');
DELETE FROM tm_berlian WHERE kode_barang='TFC-ZABA-64-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-ZABA-64-0','TFC-ZABA-64-0','00041111','RD','74','0.305','450');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-ZABA-64-0','00041111','RD','74','0.305','450','137.25')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-ZABA-64-0','TFC-ZABA-64-0','00041111','RD','18','0.315','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-ZABA-64-0','00041111','RD','18','0.315','420','132.3')
INSERT INTO th_berlian_update(kode_barang,jenis_batu,jml_batu,krt_batu,old_jenis_batu,old_jml_batu,old_krt_batu) VALUES ('TFC-ZABA-64-0','TFC-ZABA-64-0','00041111','RD','1','0.020','420');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES ('TFC-ZABA-64-0','00041111','RD','1','0.020','420','8.4')
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-ZABA-64-0','00041111','00041111','CINCIN TFC-21507 ','CINCIN TFC-21507','','','8918500','8918500',' 0','0','input','2026-01-21 16:37:36');
UPDATE tm_barang SET nama_barang='CINCIN TFC-21507' ,nama_atribut='' ,kode_intern='TFC-21507 ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='C1389 14 0126',total_usd_ext='IDR 53 000 000',total_usd='277.95' WHERE kode_barang='TFC-ZABA-64-0' LIMIT 1;
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-66-0','00041113','TFC-21509 ','CINCIN TFC-21509 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','8743000','2026-01-21','8743000','3.990','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:40:05','3.990','1030000','281.25','17100.00','','TOKO','FREETAG','','10','','','IDR 52 000 000','1','C1389 13 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-66-0','00041113');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-66-0','TFC','TOKO','SEM-THIFA','83.00','3.990','3.990','1','3.990','3.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21509 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-66-0','00041113','RD','74','0.275 ','450','123.75');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-66-0','00041113','RD','12','0.250 ','420','105');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-66-0','00041113','RD','6','0.100 ','420','42');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-66-0','00041113','RD','1','0.025 ','420','10.5');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('TFC-ZABA-67-0','00041114','TFC-21510 ','CINCIN TFC-21510 ','','GR','---','DM','TFC','TOKO','SEM-THIFA','8195500','2026-01-21','8195500','3.740','83.00','75','0','2640000.00','1','0.14', 'input','2026-01-21 16:42:10','3.740','956000','296.50','17100.00','','TOKO','FREETAG','','10','','','IDR 51 000 000','1','C1494 14 0126','','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZABA-67-0','00041114');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-21','TFC-ZABA-67-0','TFC','TOKO','SEM-THIFA','83.00','3.740','3.740','1','3.740','3.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21510 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-67-0','00041114','RD','6','0.115 ','420','48.3');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-67-0','00041114','RD','6','0.030 ','450','13.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-67-0','00041114','RD','64','0.370 ','450','166.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZABA-67-0','00041114','RD','1','0.110 ','620','68.2');