INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-05 ','08:06:55');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-02-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-01-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-02-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-02-04';
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-02-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-02-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-02-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-02-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-02-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202601 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-01';
UPDATE tt_barang_saldo SET tanggal= '2026-02-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-02-04' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-02-05';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-02-05 ','08:25:48');
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-ZBXE-1-0','00041324','700K-23-2197 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','491000','2026-02-05','491000','4.910','100.00','925','200000','100000.00','1','0.14', 'input','2026-02-05 10:16:37','4.910','0','','17000.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-ZBXE-1-0','00041324');
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-02-05','PBDG-ZBXE-1-0','PBDG','TOKO','PBDG','100.00','4.910','4.910','1','4.910','4.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-23-2197 ');
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-ZBXE-2-0','00041325','900K-115-2198 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','127000','2026-02-05','127000','1.270','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:17:17','1.270','0','','17000.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-ZBXE-2-0','00041325');
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-02-05','PBDG-ZBXE-2-0','PBDG','TOKO','PBDG','100.00','1.270','1.270','1','1.270','1.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-115-2198 ');
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-ZBXE-3-0','00041326','750K-14-2199 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','351000','2026-02-05','351000','3.510','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:18:16','3.510','0','','17000.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-ZBXE-3-0','00041326');
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-02-05','PBDG-ZBXE-3-0','PBDG','TOKO','PBDG','100.00','3.510','3.510','1','3.510','3.510','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-14-2199 ');
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-ZBXE-4-0','00041327','750K-19-2200 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','375000','2026-02-05','375000','3.750','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:18:53','3.750','0','','17000.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-ZBXE-4-0','00041327');
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-02-05','PBDG-ZBXE-4-0','PBDG','TOKO','PBDG','100.00','3.750','3.750','1','3.750','3.750','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-19-2200 ');
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-ZBXE-5-0','00041328','750K-22-2201 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','379000','2026-02-05','379000','3.790','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:19:13','3.790','0','','17000.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-ZBXE-5-0','00041328');
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-02-05','PBDG-ZBXE-5-0','PBDG','TOKO','PBDG','100.00','3.790','3.790','1','3.790','3.790','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-22-2201 ');
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-ZBXE-6-0','00041329','750K-20-2202 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','402500','2026-02-05','402500','4.020','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:20:14','4.020','0','','17000.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-ZBXE-6-0','00041329');
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-02-05','PBDG-ZBXE-6-0','PBDG','TOKO','PBDG','100.00','4.020','4.020','1','4.020','4.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-20-2202 ');
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-ZBXE-7-0','00041330','750K-21-2203 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','412000','2026-02-05','412000','4.120','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:20:53','4.120','0','','17000.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-ZBXE-7-0','00041330');
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-02-05','PBDG-ZBXE-7-0','PBDG','TOKO','PBDG','100.00','4.120','4.120','1','4.120','4.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-21-2203 ');
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-ZBXE-8-0','00041331','750K-24-2204 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','424000','2026-02-05','424000','4.240','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:21:17','4.240','0','','17000.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-ZBXE-8-0','00041331');
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-02-05','PBDG-ZBXE-8-0','PBDG','TOKO','PBDG','100.00','4.240','4.240','1','4.240','4.240','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-24-2204 ');
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-ZBXE-9-0','00041332','900K-15-2205 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','153000','2026-02-05','153000','1.530','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:22:33','1.530','0','','17000.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-ZBXE-9-0','00041332');
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-02-05','PBDG-ZBXE-9-0','PBDG','TOKO','PBDG','100.00','1.530','1.530','1','1.530','1.530','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-15-2205 ');
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-ZBXE-10-0','00041333','900K-7-2206 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','145000','2026-02-05','145000','1.450','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:23:13','1.450','0','','17000.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-ZBXE-10-0','00041333');
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-02-05','PBDG-ZBXE-10-0','PBDG','TOKO','PBDG','100.00','1.450','1.450','1','1.450','1.450','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-7-2206 ');
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-ZBXE-11-0','00041334','900K-8-2207 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','146000','2026-02-05','146000','1.460','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:23:31','1.460','0','','17000.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-ZBXE-11-0','00041334');
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-02-05','PBDG-ZBXE-11-0','PBDG','TOKO','PBDG','100.00','1.460','1.460','1','1.460','1.460','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-8-2207 ');
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-ZBXE-12-0','00041335','750K-15-2208 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','280000','2026-02-05','280000','2.800','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:24:13','2.800','0','','17000.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-ZBXE-12-0','00041335');
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-02-05','PBDG-ZBXE-12-0','PBDG','TOKO','PBDG','100.00','2.800','2.800','1','2.800','2.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-15-2208 ');
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-ZBXE-13-0','00041336','750K-22-2209 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','302000','2026-02-05','302000','3.020','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:24:48','3.020','0','','17000.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-ZBXE-13-0','00041336');
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-02-05','PBDG-ZBXE-13-0','PBDG','TOKO','PBDG','100.00','3.020','3.020','1','3.020','3.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-22-2209 ');
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-ZBXE-14-0','00041337','1.0K-8-2210 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','210000','2026-02-05','210000','2.100','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:25:31','2.100','0','','17000.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-ZBXE-14-0','00041337');
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-02-05','PBDG-ZBXE-14-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','1.0K-8-2210 ');
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-ZBXE-15-0','00041338','1.0K-16-2211 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','225000','2026-02-05','225000','2.250','100.00','925','250000','100000.00','1','0.14', 'input','2026-02-05 10:25:52','2.250','0','','17000.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-ZBXE-15-0','00041338');
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-02-05','PBDG-ZBXE-15-0','PBDG','TOKO','PBDG','100.00','2.250','2.250','1','2.250','2.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','1.0K-16-2211 ');
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-01610';
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-ZBXE-16-0','00041339','DP-01610BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','467500','2026-02-05','467500','2.290','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-05 11:11:46','2.290','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01610BIP','1','RS 15 5','','DP-01610');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXE-16-0','00041339');
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-02-05','PSPLT-ZBXE-16-0','PSPLT','TOKO','PSNB','17.00','2.290','2.290','1','2.290','2.290','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01610BIP ');
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-01653';
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-ZBXE-17-0','00041340','DP-01653BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','412500','2026-02-05','412500','2.020','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-05 11:13:08','2.020','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01653BIP','1','RS 16','','DP-01653');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXE-17-0','00041340');
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-02-05','PSPLT-ZBXE-17-0','PSPLT','TOKO','PSNB','17.00','2.020','2.020','1','2.020','2.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01653BIP ');
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-01640';
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-ZBXE-18-0','00041341','DP-01640BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','683500','2026-02-05','683500','3.350','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-05 11:14:54','3.350','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01640BIP','1','RS 18','','DP-01640');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXE-18-0','00041341');
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-02-05','PSPLT-ZBXE-18-0','PSPLT','TOKO','PSNB','17.00','3.350','3.350','1','3.350','3.350','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01640BIP ');
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-01631';
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 ('PSPRT-ZBXE-19-0','00041342','DP-01631BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','231000','2026-02-05','231000','2.310','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-05 11:16:08','2.310','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01631BIP','1','RS 18 5','','DP-01631');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXE-19-0','00041342');
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-02-05','PSPRT-ZBXE-19-0','PSPRT','TOKO','PSNB','100.00','2.310','2.310','1','2.310','2.310','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01631BIP ');
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-01636';
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 ('PSPRT-ZBXE-20-0','00041343','DP-01636BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','339000','2026-02-05','339000','3.390','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-05 11:17:22','3.390','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01636BIP','1','RS 27','','DP-01636');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXE-20-0','00041343');
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-02-05','PSPRT-ZBXE-20-0','PSPRT','TOKO','PSNB','100.00','3.390','3.390','1','3.390','3.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01636BIP ');
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-01630';
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 ('PSPRT-ZBXE-21-0','00041344','DP-01630BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','157000','2026-02-05','157000','1.570','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-05 11:18:30','1.570','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01630BIP','1','RS 10 5','','DP-01630');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXE-21-0','00041344');
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-02-05','PSPRT-ZBXE-21-0','PSPRT','TOKO','PSNB','100.00','1.570','1.570','1','1.570','1.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01630BIP ');
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-01643';
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 ('PSPRT-ZBXE-22-0','00041345','DP-01643BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','218500','2026-02-05','218500','2.180','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-05 11:20:05','2.180','0','','17000.00','','TOKO','FREETAG','','2','','','','1','RS 14 5','','DP-01643');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXE-22-0','00041345');
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-02-05','PSPRT-ZBXE-22-0','PSPRT','TOKO','PSNB','100.00','2.180','2.180','1','2.180','2.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01643BIP ');
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-01644';
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 ('PSPRT-ZBXE-23-0','00041346','DP-01644BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','183000','2026-02-05','183000','1.830','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-05 11:21:20','1.830','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01644BIP','1','RS 17','','DP-01644');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXE-23-0','00041346');
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-02-05','PSPRT-ZBXE-23-0','PSPRT','TOKO','PSNB','100.00','1.830','1.830','1','1.830','1.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01644BIP ');
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-01656';
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 ('PSPRT-ZBXE-24-0','00041347','DP-01656BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','224500','2026-02-05','224500','2.240','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-05 11:22:32','2.240','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01656BIP','1','RS 16 5','','DP-01656');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXE-24-0','00041347');
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-02-05','PSPRT-ZBXE-24-0','PSPRT','TOKO','PSNB','100.00','2.240','2.240','1','2.240','2.240','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01656BIP ');
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-01635';
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-ZBXE-25-0','00041348','DP-01635BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','384000','2026-02-05','384000','1.880','17.00','10','300000','1200000.00','1','0.14', 'input','2026-02-05 11:23:56','1.880','0','','17000.00','','TOKO','FREETAG','','10','','','PSN01635BIP','1','RS 16','','DP-01635');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZBXE-25-0','00041348');
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-02-05','PSPLT-ZBXE-25-0','PSPLT','TOKO','PSNB','17.00','1.880','1.880','1','1.880','1.880','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01635BIP ');
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-01613';
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 ('PSPRT-ZBXE-26-0','00041349','DP-01613BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','335000','2026-02-05','335000','3.350','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-05 11:25:10','3.350','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01613BIP','1','RS 16','','DP-01613');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXE-26-0','00041349');
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-02-05','PSPRT-ZBXE-26-0','PSPRT','TOKO','PSNB','100.00','3.350','3.350','1','3.350','3.350','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01613BIP ');
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-01629';
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 ('PSPRT-ZBXE-27-0','00041350','DP-01629BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','481500','2026-02-05','481500','4.810','100.00','925','400000','100000.00','1','0.14', 'input','2026-02-05 11:26:48','4.810','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01629BIP','1','RS 16','','DP-01629');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXE-27-0','00041350');
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-02-05','PSPRT-ZBXE-27-0','PSPRT','TOKO','PSNB','100.00','4.810','4.810','1','4.810','4.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01629BIP ');
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-01650';
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 ('PSPRT-ZBXE-28-0','00041351','DP-01650BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','206000','2026-02-05','206000','2.060','100.00','925','350000','100000.00','1','0.14', 'input','2026-02-05 11:27:58','2.060','0','','17000.00','','TOKO','FREETAG','','2','','','PSN01650BIP','1','RS 17 5','','DP-01650');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZBXE-28-0','00041351');
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-02-05','PSPRT-ZBXE-28-0','PSPRT','TOKO','PSNB','100.00','2.060','2.060','1','2.060','2.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-01650BIP ');
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='2777000',harga_beli ='2777000' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5625000',harga_beli ='5625000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='219000',harga_beli ='219000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3182500',harga_beli ='3182500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='7046000',harga_beli ='7046000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='2639500',harga_beli ='2639500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='2524500',harga_beli ='2524500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='2570500',harga_beli ='2570500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='6128000',harga_beli ='6128000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='22629000',harga_beli ='22629000' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3148500',harga_beli ='3148500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3120000',harga_beli ='3120000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='2948000',harga_beli ='2948000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3062500',harga_beli ='3062500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3034000',harga_beli ='3034000' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='8516000',harga_beli ='8516000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3260500',harga_beli ='3260500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='11680500',harga_beli ='11680500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='4213500',harga_beli ='4213500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='4953000',harga_beli ='4953000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5087500',harga_beli ='5087500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5983500',harga_beli ='5983500' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='4841000',harga_beli ='4841000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='6925000',harga_beli ='6925000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='8269500',harga_beli ='8269500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='9972500',harga_beli ='9972500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='8068000',harga_beli ='8068000' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='1681000',harga_beli ='1681000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3115500',harga_beli ='3115500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='4751000',harga_beli ='4751000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='4303000',harga_beli ='4303000' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='2465500',harga_beli ='2465500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='2375500',harga_beli ='2375500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='7283500',harga_beli ='7283500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='8740000',harga_beli ='8740000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3899500',harga_beli ='3899500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='7731500',harga_beli ='7731500' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='6140500',harga_beli ='6140500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='2981000',harga_beli ='2981000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='2532500',harga_beli ='2532500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5759500',harga_beli ='5759500' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='4034000',harga_beli ='4034000' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5979500',harga_beli ='5979500' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='7709500',harga_beli ='7709500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='11676000',harga_beli ='11676000' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='10533000',harga_beli ='10533000' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3855000',harga_beli ='3855000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='6006000',harga_beli ='6006000' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='8381500',harga_beli ='8381500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='7642000',harga_beli ='7642000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='7866000',harga_beli ='7866000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='9031500',harga_beli ='9031500' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='18018000',harga_beli ='18018000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='1838000',harga_beli ='1838000' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='1838000',harga_beli ='1838000' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='1748500',harga_beli ='1748500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='1681000',harga_beli ='1681000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5558000',harga_beli ='5558000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='9547000',harga_beli ='9547000' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='10914000',harga_beli ='10914000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='9278000',harga_beli ='9278000' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='8695500',harga_beli ='8695500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='9524500',harga_beli ='9524500' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='8493500',harga_beli ='8493500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5065000',harga_beli ='5065000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='60798500',harga_beli ='60798500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='9457500',harga_beli ='9457500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='8740000',harga_beli ='8740000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='6477000',harga_beli ='6477000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='12438000',harga_beli ='12438000' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='14433500',harga_beli ='14433500' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='8292000',harga_beli ='8292000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='6701000',harga_beli ='6701000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='7351000',harga_beli ='7351000' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5759500',harga_beli ='5759500' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2700000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2700000','input','2026-02-05 13:14:55');
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='18934000',harga_beli ='18934000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='11108000',harga_beli ='11108000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5852500',harga_beli ='5852500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5898500',harga_beli ='5898500' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='6844500',harga_beli ='6844500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='5195500',harga_beli ='5195500' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='12903500',harga_beli ='12903500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='3960500',harga_beli ='3960500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='14850500',harga_beli ='14850500' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='7059500',harga_beli ='7059500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2700000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2700000','input','2026-02-05 13:15:02');
UPDATE tm_group SET harga='2700000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2700000','input','2026-02-05 13:15:06');
UPDATE tm_group SET harga='2700000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2700000','input','2026-02-05 13:15:10');
UPDATE tm_group SET harga='2700000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2700000','input','2026-02-05 13:15:13');
UPDATE tm_group SET harga='2700000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2700000','input','2026-02-05 13:15:17');
UPDATE tm_group SET harga='2700000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2700000','input','2026-02-05 13:15:21');
UPDATE tm_barang SET harga_skrg ='2700000',harga_jual='4079000',harga_beli ='4079000' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2700000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2700000','input','2026-02-05 13:15:24');
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-ZBXE-29-0','00041352','CBRE-06988 ','CBRE-06988 GIA 2223286628 ','','GR','---','DM','CBRE','TOKO','CBRE','9233000','2026-02-05','9233000','4.120','83.00','75','0','2700000.00','1','0.04', 'input','2026-02-05 13:27:39','4.120','975000','3118.50','17000.00','','TOKO','FREETAG','','10','','','GIE 218 000 000','1','JVS2 0226','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZBXE-29-0','00041352');
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-02-05','CBRE-ZBXE-29-0','CBRE','TOKO','CBRE','83.00','4.120','4.120','1','4.120','4.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06988 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXE-29-0','00041352','RD','1','0.900 ','3300','2970');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXE-29-0','00041352','RD','34','0.230 ','450','103.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZBXE-29-0','00041352','RD','28','0.100 ','450','45');