INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-06 ','08:05:12');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-04','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-03';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-03';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-03';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-10-03' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-03';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-03';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-03';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-03';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-04' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-03' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-04';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-06 ','08:05:38');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-05','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-04';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-04';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-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='2025-10-04' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-04';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-04';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-04';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-04';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-05' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-04' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-05';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-06 ','08:05:55');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-10-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-09-05';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-10-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-10-05';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2025-10-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-10-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-10-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-10-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-10-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202509 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-09';
UPDATE tt_barang_saldo SET tanggal= '2025-10-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-10-05' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2025-10-06';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-06 ','08:06:12');
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 ('CKPRE-YJXF-1-0','00039007','700K-16-834 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','41000','2025-10-06','41000','1.630','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:50:17','1.630','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-1-0','00039007');
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 ('2025-10-06','CKPRE-YJXF-1-0','CKPRE','TOKO','PER','100.00','1.630','1.630','1','1.630','1.630','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-16-834 ');
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 ('CKPRE-YJXF-2-0','00039008','700K-12-835 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','33500','2025-10-06','33500','1.330','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:51:04','1.330','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-2-0','00039008');
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 ('2025-10-06','CKPRE-YJXF-2-0','CKPRE','TOKO','PER','100.00','1.330','1.330','1','1.330','1.330','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-12-835 ');
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 ('CKPRE-YJXF-3-0','00039009','700K-12-836 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','91000','2025-10-06','91000','3.640','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:51:51','3.640','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-3-0','00039009');
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 ('2025-10-06','CKPRE-YJXF-3-0','CKPRE','TOKO','PER','100.00','3.640','3.640','1','3.640','3.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-12-836 ');
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 ('CKPRE-YJXF-4-0','00039010','700K-14-837 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','35500','2025-10-06','35500','1.420','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:52:31','1.420','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-4-0','00039010');
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 ('2025-10-06','CKPRE-YJXF-4-0','CKPRE','TOKO','PER','100.00','1.420','1.420','1','1.420','1.420','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-14-837 ');
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 ('CKPRE-YJXF-5-0','00039011','1.0K-125-838 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','107000','2025-10-06','107000','4.280','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:53:17','4.280','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-5-0','00039011');
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 ('2025-10-06','CKPRE-YJXF-5-0','CKPRE','TOKO','PER','100.00','4.280','4.280','1','4.280','4.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','1.0K-125-838 ');
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 ('CKPRE-YJXF-6-0','00039012','850K-12-839 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','33500','2025-10-06','33500','1.330','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:54:01','1.330','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-6-0','00039012');
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 ('2025-10-06','CKPRE-YJXF-6-0','CKPRE','TOKO','PER','100.00','1.330','1.330','1','1.330','1.330','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','850K-12-839 ');
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 ('CKPRE-YJXF-7-0','00039013','700K-155-840 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','35500','2025-10-06','35500','1.410','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:54:44','1.410','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-7-0','00039013');
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 ('2025-10-06','CKPRE-YJXF-7-0','CKPRE','TOKO','PER','100.00','1.410','1.410','1','1.410','1.410','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-155-840 ');
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 ('CKPRE-YJXF-8-0','00039014','800K-11-841 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','62000','2025-10-06','62000','2.470','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:55:27','2.470','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-8-0','00039014');
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 ('2025-10-06','CKPRE-YJXF-8-0','CKPRE','TOKO','PER','100.00','2.470','2.470','1','2.470','2.470','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','800K-11-841 ');
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 ('CKPRE-YJXF-9-0','00039015','850K-12-842 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','46000','2025-10-06','46000','1.840','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:56:05','1.840','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-9-0','00039015');
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 ('2025-10-06','CKPRE-YJXF-9-0','CKPRE','TOKO','PER','100.00','1.840','1.840','1','1.840','1.840','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','850K-12-842 ');
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 ('CKPRE-YJXF-10-0','00039016','1.0K-19-843 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','101000','2025-10-06','101000','4.030','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:56:52','4.030','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-10-0','00039016');
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 ('2025-10-06','CKPRE-YJXF-10-0','CKPRE','TOKO','PER','100.00','4.030','4.030','1','4.030','4.030','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','1.0K-19-843 ');
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 ('CKPRE-YJXF-11-0','00039017','850K-105-844 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','60000','2025-10-06','60000','2.390','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:57:34','2.390','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-11-0','00039017');
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 ('2025-10-06','CKPRE-YJXF-11-0','CKPRE','TOKO','PER','100.00','2.390','2.390','1','2.390','2.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','850K-105-844 ');
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 ('CKPRE-YJXF-12-0','00039018','700K-12-845 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','51000','2025-10-06','51000','2.030','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:58:14','2.030','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-12-0','00039018');
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 ('2025-10-06','CKPRE-YJXF-12-0','CKPRE','TOKO','PER','100.00','2.030','2.030','1','2.030','2.030','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-12-845 ');
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 ('CKPRE-YJXF-13-0','00039019','700K-14-846 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','50500','2025-10-06','50500','2.020','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 10:58:55','2.020','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-13-0','00039019');
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 ('2025-10-06','CKPRE-YJXF-13-0','CKPRE','TOKO','PER','100.00','2.020','2.020','1','2.020','2.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-14-846 ');
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 ('CKPRE-YJXF-14-0','00039020','700K-12-847 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','48500','2025-10-06','48500','1.940','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 11:00:13','1.940','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-14-0','00039020');
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 ('2025-10-06','CKPRE-YJXF-14-0','CKPRE','TOKO','PER','100.00','1.940','1.940','1','1.940','1.940','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-12-847 ');
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 ('CKPRE-YJXF-15-0','00039021','700K-13-848 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','30500','2025-10-06','30500','1.220','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 11:00:50','1.220','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-15-0','00039021');
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 ('2025-10-06','CKPRE-YJXF-15-0','CKPRE','TOKO','PER','100.00','1.220','1.220','1','1.220','1.220','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-13-848 ');
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 ('CKPRE-YJXF-16-0','00039022','700K-14-849 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','35000','2025-10-06','35000','1.400','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 11:01:30','1.400','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-16-0','00039022');
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 ('2025-10-06','CKPRE-YJXF-16-0','CKPRE','TOKO','PER','100.00','1.400','1.400','1','1.400','1.400','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-14-849 ');
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 ('CKPRE-YJXF-17-0','00039023','850K-11-850 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','39500','2025-10-06','39500','1.570','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 11:02:10','1.570','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-17-0','00039023');
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 ('2025-10-06','CKPRE-YJXF-17-0','CKPRE','TOKO','PER','100.00','1.570','1.570','1','1.570','1.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','850K-11-850 ');
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 ('CKPRE-YJXF-18-0','00039024','850K-18-851 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','73500','2025-10-06','73500','2.930','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 11:02:56','2.930','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-18-0','00039024');
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 ('2025-10-06','CKPRE-YJXF-18-0','CKPRE','TOKO','PER','100.00','2.930','2.930','1','2.930','2.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','850K-18-851 ');
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 ('CKPRE-YJXF-19-0','00039025','700K-15-851 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','64500','2025-10-06','64500','2.570','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 11:03:35','2.570','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-19-0','00039025');
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 ('2025-10-06','CKPRE-YJXF-19-0','CKPRE','TOKO','PER','100.00','2.570','2.570','1','2.570','2.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-15-851 ');
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 ('CKPRE-YJXF-20-0','00039026','700K-12-851 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','35500','2025-10-06','35500','1.410','100.00','925','150000','25000.00','1','0.04', 'input','2025-10-06 11:04:12','1.410','0','','16700.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-YJXF-20-0','00039026');
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 ('2025-10-06','CKPRE-YJXF-20-0','CKPRE','TOKO','PER','100.00','1.410','1.410','1','1.410','1.410','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-12-851 ');
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-YJXF-19-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CKPRE-YJXF-19-0','00039025','00039025','CINCIN SILVER 925 ','CINCIN SILVER 925','','','64500','64500',' 150000','150000','input','2025-10-06 11:04:38');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-15-852 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='CKPRE-YJXF-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-YJXF-20-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CKPRE-YJXF-20-0','00039026','00039026','CINCIN SILVER 925 ','CINCIN SILVER 925','','','35500','35500',' 150000','150000','input','2025-10-06 11:04:54');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='700K-12-853', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='CKPRE-YJXF-20-0' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2025-10-06 ','13:04:44');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250907-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250907-0001';
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 ('ABRE-YJXF-21-0','00039027','ABRE-02092 ','GIWANG ABRE-02092 ','','GR','---','DM','ABRE','TOKO','SEM-BALIK','2790000','2025-10-06','2790000','1.810','75.00','75','0','2055000.00','1','0.14', 'input','2025-10-06 15:20:34','1.810','0','92.80','16700.00','','TOKO','FREETAG','','10','','','IDB 17 000 000','1','0925 1B2','BE-250907-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YJXF-21-0','00039027');
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 ('2025-10-06','ABRE-YJXF-21-0','ABRE','TOKO','SEM-BALIK','75.00','1.810','1.810','1','1.810','1.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02092 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YJXF-21-0','00039027','RD','2','0.060 ','320','19.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YJXF-21-0','00039027','RD','12','0.230 ','320','73.6');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-250915-0002';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-250915-0002';
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 ('TFA-YJXF-22-0','00039028','TFA-21070 ','ANTING TFA-21070 ','','GR','---','DM','TFA','TOKO','TFA','1356500','2025-10-06','1356500','0.880','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 15:23:52','0.880','0','17.60','16700.00','','TOKO','FREETAG','','10','','0','IDB 9 500 000','2','ANT75 0925','FB-250915-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'TFA' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFA','TFA-YJXF-22-0','00039028');
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 ('2025-10-06','TFA-YJXF-22-0','TFA','TOKO','TFA','75.00','0.880','0.880','1','0.880','0.880','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFA';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFA','TFA-21070 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFA-YJXF-22-0','00039028','RD','16','0.055 ','320','17.6');
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-251006-0001','1','TFA-YJXF-22-0','1','0.880','0.880','TOKO','TFA','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='TFA-YJXF-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFA';
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('2025-10-06','TOKO','SEM-BALIK','TFA','TFA-YJXF-22-0','75.00','1','0.880','0.880','1','0.880','0.880');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.880',berat_out_asli=berat_out_asli+'0.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='TFA-YJXF-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFA' 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-251006-0001','2025-10-06','2025-10-06','15:24','0.88','input','2025-10-06 15:24:09');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250915-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250915-0002';
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-YJXF-23-0','00039029','CBRE-03308 ','CINCIN CBRE-03308 ','','GR','---','DM','CBRE','TOKO','CBRE','11821500','2025-10-06','11821500','7.670','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 15:28:02','7.670','0','518.40','16700.00','','TOKO','FREETAG','','10','','0','IDB 71 000 000','2','C1126 0925 17B6','BE-250915-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-23-0','00039029');
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 ('2025-10-06','CBRE-YJXF-23-0','CBRE','TOKO','CBRE','75.00','7.670','7.670','1','7.670','7.670','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03308 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-23-0','00039029','RD','13','0.720 ','320','230.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-23-0','00039029','RD','36','0.900 ','320','288');
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-251006-0002','1','CBRE-YJXF-23-0','1','7.670','7.670','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-23-0','75.00','1','7.670','7.670','1','7.670','7.670');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'7.670',berat_out_asli=berat_out_asli+'7.670',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' 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-251006-0002','2025-10-06','2025-10-06','15:28','7.67','input','2025-10-06 15:28:17');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250919-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250919-0004';
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 ('ABRE-YJXF-24-0','00039030','ABRE-02093 ','ANTING ABRE-02093 ','','GR','---','DM','ABRE','TOKO','SEM-BALIK','1910500','2025-10-06','1910500','1.120','83.00','75','0','2055000.00','1','0.14', 'input','2025-10-06 15:31:52','1.120','100000','29.25','16700.00','','TOKO','FREETAG','','10','','','IDB 9 500 000','1','ANT75 0925 2B4','BE-250919-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YJXF-24-0','00039030');
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 ('2025-10-06','ABRE-YJXF-24-0','ABRE','TOKO','SEM-BALIK','83.00','1.120','1.120','1','1.120','1.120','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-02093 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YJXF-24-0','00039030','RD','16','0.065 ','450','29.25');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250919-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250919-0001';
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-YJXF-25-0','00039031','CBRE-03993 ','CINCIN CBRE-03993 ','','GR','---','DM','CBRE','TOKO','CBRE','3792000','2025-10-06','3792000','2.460','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 15:34:51','2.460','0','208.00','16700.00','','TOKO','FREETAG','','10','','0','IDB 27 000 000','2','16 0925 7B1','BE-250919-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-25-0','00039031');
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 ('2025-10-06','CBRE-YJXF-25-0','CBRE','TOKO','CBRE','75.00','2.460','2.460','1','2.460','2.460','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03993 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-25-0','00039031','RD','7','0.520 ','400','208');
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-251006-0003','1','CBRE-YJXF-25-0','1','2.460','2.460','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-25-0','75.00','1','2.460','2.460','1','2.460','2.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.460',berat_out_asli=berat_out_asli+'2.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' 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-251006-0003','2025-10-06','2025-10-06','15:34','2.46','input','2025-10-06 15:35:04');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250919-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250919-0002';
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-YJXF-26-0','00039032','CBRE-02504 ','CINCIN CBRE-02504 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','9535500','2025-10-06','9535500','5.800','80.00','75.00','0','2055000.00','1','0.04', 'input','2025-10-06 15:39:21','5.800','0','560.40','16700.00','0','TOKO','FREETAG','','10','','0','IDB 65 500 000','3','RS16 0925 18B9','BE-250919-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-26-0','00039032');
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 ('2025-10-06','CBRE-YJXF-26-0','CBRE','TOKO','CBRE.BALIK','80.00','5.800','5.800','1','5.800','5.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02504 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-26-0','00039032','RD','72','0.370 ','360','133.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-26-0','00039032','RD','22','0.650 ','360','234');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-26-0','00039032','RD','1','0.210 ','920','193.2');
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-251006-0004','1','CBRE-YJXF-26-0','1','5.800','5.800','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-26-0','80.00','1','5.800','5.800','1','5.800','5.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.800',berat_out_asli=berat_out_asli+'5.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251006-0004','2025-10-06','2025-10-06','15:39','5.8','input','2025-10-06 15:39:35');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250919-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250919-0005';
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-YJXF-27-0','00039033','CBR2315 ','CINCIN CBR2315 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','1772500','2025-10-06','1772500','1.150','75.00','75','0','2055000.00','1','0.14', 'input','2025-10-06 15:41:05','1.150','0','16.00','16700.00','','TOKO','FREETAG','','10','','','IDB 7 500 000','1','135 0925 1B6','BE-250919-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-27-0','00039033');
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 ('2025-10-06','CBRE-YJXF-27-0','CBRE','TOKO','SEM-BALIK','75.00','1.150','1.150','1','1.150','1.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBR2315 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-27-0','00039033','RD','10','0.050 ','320','16');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250919-0006';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250919-0006';
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-YJXF-28-0','00039034','CBR2352 ','CINCIN CBR2352 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','2821000','2025-10-06','2821000','1.830','75.00','75','0','2055000.00','1','0.14', 'input','2025-10-06 15:42:40','1.830','0','38.40','16700.00','','TOKO','FREETAG','','10','','','IDB 13 500 000','1','14 0925 2B4','BE-250919-0006','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-28-0','00039034');
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 ('2025-10-06','CBRE-YJXF-28-0','CBRE','TOKO','SEM-BALIK','75.00','1.830','1.830','1','1.830','1.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBR2352 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-28-0','00039034','RD','7','0.120 ','320','38.4');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250919-0007';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250919-0007';
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-YJXF-29-0','00039035','CBRE-03304 ','CINCIN CBRE-03304 ','','GR','---','DM','CBRE','TOKO','CBRE','5086500','2025-10-06','5086500','3.300','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 15:44:44','3.300','0','128.00','16700.00','','TOKO','FREETAG','','10','','0','IDB 27 000 000','2','15 0925 6B4','BE-250919-0007','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-29-0','00039035');
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 ('2025-10-06','CBRE-YJXF-29-0','CBRE','TOKO','CBRE','75.00','3.300','3.300','1','3.300','3.300','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03304 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-29-0','00039035','RD','1','0.015 ','320','4.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-29-0','00039035','RD','4','0.195 ','320','62.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-29-0','00039035','RD','20','0.070 ','320','22.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-29-0','00039035','RD','24','0.120 ','320','38.4');
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-251006-0005','1','CBRE-YJXF-29-0','1','3.300','3.300','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-29-0','75.00','1','3.300','3.300','1','3.300','3.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.300',berat_out_asli=berat_out_asli+'3.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' 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-251006-0005','2025-10-06','2025-10-06','15:44','3.3','input','2025-10-06 15:44:57');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250919-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250919-0003';
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 ('ABRE-YJXF-30-0','00039036','ABRE-00517 ','GIWANG ABRE-00517 ','','GR','---','DM','ABRE','TOKO','ABRE','1803500','2025-10-06','1803500','1.170','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 15:47:06','1.170','0','32.00','16700.00','','TOKO','FREETAG','','10','','0','IDB 8 500 000','2','0925','BE-250919-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YJXF-30-0','00039036');
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 ('2025-10-06','ABRE-YJXF-30-0','ABRE','TOKO','ABRE','75.00','1.170','1.170','1','1.170','1.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00517 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YJXF-30-0','00039036','RD','2','0.100 ','320','32');
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-251006-0006','1','ABRE-YJXF-30-0','1','1.170','1.170','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-YJXF-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
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('2025-10-06','TOKO','SEM-BALIK','ABRE','ABRE-YJXF-30-0','75.00','1','1.170','1.170','1','1.170','1.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.170',berat_out_asli=berat_out_asli+'1.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='ABRE-YJXF-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' 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-251006-0006','2025-10-06','2025-10-06','15:47','1.17','input','2025-10-06 15:47:20');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250913-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250913-0004';
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-YJXF-31-0','00039037','CBRE-01757 ','CINCIN CBRE-01757 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','1262500','2025-10-06','1262500','0.740','83.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 15:52:23','0.740','490000','42.75','16700.00','','TOKO','FREETAG','','10','','0','IDB 9 000 000','2','19 0925 2B4','BE-250913-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-31-0','00039037');
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 ('2025-10-06','CBRE-YJXF-31-0','CBRE','TOKO','CBRE.BALIK','83.00','0.740','0.740','1','0.740','0.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-01757 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-31-0','00039037','RD','19','0.095 ','450','42.75');
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-251006-0007','1','CBRE-YJXF-31-0','1','0.740','0.740','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-31-0','83.00','1','0.740','0.740','1','0.740','0.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.740',berat_out_asli=berat_out_asli+'0.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251006-0007','2025-10-06','2025-10-06','15:52','0.74','input','2025-10-06 15:52:36');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250920-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250920-0001';
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-YJXF-32-0','00039038','CBRE-06914 ','CINCIN CBRE-06914 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','3699000','2025-10-06','3699000','2.000','90.00','75','0','2055000.00','1','0.14', 'input','2025-10-06 15:55:25','2.000','0','125.80','16700.00','','TOKO','FREETAG','','10','','','IDB 21 500 000','1','15 0925 5B6','BE-250920-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-32-0','00039038');
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 ('2025-10-06','CBRE-YJXF-32-0','CBRE','TOKO','SEM-BALIK','90.00','2.000','2.000','1','2.000','2.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06914 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-32-0','00039038','RD','7','0.340 ','370','125.8');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250920-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250920-0004';
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-YJXF-33-0','00039039','CBRE-06179 ','CBRE-06179 GIA 7462778880 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4485500','2025-10-06','4485500','2.910','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 15:58:06','2.910','0','459.40','16700.00','','TOKO','FREETAG','','10','','0','GIE 43 500 000','3','135 0925 12B0','BE-250920-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-33-0','00039039');
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 ('2025-10-06','CBRE-YJXF-33-0','CBRE','TOKO','CBRE.BALIK','75.00','2.910','2.910','1','2.910','2.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06179 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-33-0','00039039','RD','16','0.170 ','320','54.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-33-0','00039039','EMR','1','0.300 ','1350','405');
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-251006-0008','1','CBRE-YJXF-33-0','1','2.910','2.910','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-33-0','75.00','1','2.910','2.910','1','2.910','2.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.910',berat_out_asli=berat_out_asli+'2.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251006-0008','2025-10-06','2025-10-06','15:58','2.91','input','2025-10-06 15:58:20');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250920-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250920-0005';
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-YJXF-34-0','00039040','CBRE-01127 ','CBRE-01127 GIA 6355679175 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4208000','2025-10-06','4208000','2.730','75.00','75.00','0','2055000.00','1','0.04', 'input','2025-10-06 16:01:21','2.730','0','324.40','16700.00','0','TOKO','FREETAG','','10','','0','GIE 36 000 000','5','15 0925 9B1','BE-250920-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-34-0','00039040');
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 ('2025-10-06','CBRE-YJXF-34-0','CBRE','TOKO','CBRE.BALIK','75.00','2.730','2.730','1','2.730','2.730','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-01127 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-34-0','00039040','RD','1','0.180 ','1500','270');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-34-0','00039040','RD','36','0.170 ','320','54.4');
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-251006-0009','1','CBRE-YJXF-34-0','1','2.730','2.730','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-34-0','75.00','1','2.730','2.730','1','2.730','2.730');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.730',berat_out_asli=berat_out_asli+'2.730',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251006-0009','2025-10-06','2025-10-06','16:01','2.73','input','2025-10-06 16:01:34');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250920-0006';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250920-0006';
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-YJXF-35-0','00039041','CBRE-05300 ','CBRE-05300 GIA 2426640950 ','','GR','---','DM','CBRE','TOKO','CBRE','7799000','2025-10-06','7799000','5.060','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 16:03:37','5.060','0','1525.20','16700.00','','TOKO','FREETAG','','10','','0','GIE 115 000 000','2','15 0925 29B6','BE-250920-0006','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-35-0','00039041');
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 ('2025-10-06','CBRE-YJXF-35-0','CBRE','TOKO','CBRE','75.00','5.060','5.060','1','5.060','5.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-05300 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-35-0','00039041','RD','1','0.500 ','2500','1250');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-35-0','00039041','RD','14','0.370 ','320','118.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-35-0','00039041','RD','34','0.490 ','320','156.8');
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-251006-0010','1','CBRE-YJXF-35-0','1','5.060','5.060','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-35-0','75.00','1','5.060','5.060','1','5.060','5.060');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.060',berat_out_asli=berat_out_asli+'5.060',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' 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-251006-0010','2025-10-06','2025-10-06','16:03','5.06','input','2025-10-06 16:03:54');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250920-0008';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250920-0008';
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 ('GBRE-YJXF-36-0','00039042','GBRE-00565 ','GELANG GBRE-00565 ','','GR','---','DM','GBRE','TOKO','GBRE','8708500','2025-10-06','8708500','5.650','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 16:05:44','5.650','0','182.40','16700.00','','TOKO','FREETAG','','10','','0','IDB 42 000 000','2','0925 8B8','BE-250920-0008','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-YJXF-36-0','00039042');
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 ('2025-10-06','GBRE-YJXF-36-0','GBRE','TOKO','GBRE','75.00','5.650','5.650','1','5.650','5.650','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-00565 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-YJXF-36-0','00039042','RD','19','0.570 ','320','182.4');
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-251006-0011','1','GBRE-YJXF-36-0','1','5.650','5.650','TOKO','GBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-YJXF-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE';
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('2025-10-06','TOKO','SEM-BALIK','GBRE','GBRE-YJXF-36-0','75.00','1','5.650','5.650','1','5.650','5.650');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.650',berat_out_asli=berat_out_asli+'5.650',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='GBRE-YJXF-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE' 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-251006-0011','2025-10-06','2025-10-06','16:05','5.65','input','2025-10-06 16:05:57');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250920-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250920-0003';
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 ('LBRE-YJXF-37-0','00039043','LBRE-00540 ','LIONTIN LBRE-00540 ','','GR','---','DM','LBRE','TOKO','LBRE','1803500','2025-10-06','1803500','1.170','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 16:08:04','1.170','0','77.00','16700.00','','TOKO','FREETAG','','10','','0','IDB 12 000 000','2','L63 0925 2B6','BE-250920-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-YJXF-37-0','00039043');
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 ('2025-10-06','LBRE-YJXF-37-0','LBRE','TOKO','LBRE','75.00','1.170','1.170','1','1.170','1.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00540 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-YJXF-37-0','00039043','SP','1','0.420 ','50','21');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-YJXF-37-0','00039043','RD','12','0.175 ','320','56');
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-251006-0012','1','LBRE-YJXF-37-0','1','1.170','1.170','TOKO','LBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-YJXF-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE';
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('2025-10-06','TOKO','SEM-BALIK','LBRE','LBRE-YJXF-37-0','75.00','1','1.170','1.170','1','1.170','1.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.170',berat_out_asli=berat_out_asli+'1.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='LBRE-YJXF-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE' 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-251006-0012','2025-10-06','2025-10-06','16:08','1.17','input','2025-10-06 16:08:17');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250920-0007';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250920-0007';
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-YJXF-38-0','00039044','CBRE-02312 ','CBRE-02312 GIA 6401082202 ','','GR','---','DM','CBRE','TOKO','CBRE','4362000','2025-10-06','4362000','2.830','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 16:10:38','2.830','0','276.40','16700.00','','TOKO','FREETAG','','10','','0','GIE 34 000 000','2','135 0925 7B9','BE-250920-0007','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-38-0','00039044');
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 ('2025-10-06','CBRE-YJXF-38-0','CBRE','TOKO','CBRE','75.00','2.830','2.830','1','2.830','2.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02312 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-38-0','00039044','RD','1','0.170 ','1400','238');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-38-0','00039044','RD','17','0.090 ','320','28.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-38-0','00039044','RD','8','0.030 ','320','9.6');
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-251006-0013','1','CBRE-YJXF-38-0','1','2.830','2.830','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-38-0','75.00','1','2.830','2.830','1','2.830','2.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.830',berat_out_asli=berat_out_asli+'2.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' 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-251006-0013','2025-10-06','2025-10-06','16:10','2.83','input','2025-10-06 16:10:51');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250920-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250920-0002';
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-YJXF-39-0','00039045','CBRE-01479 ','CBRE-01479 GIA 6382417792 ','','GR','---','DM','CBRE','TOKO','CBRE','2851500','2025-10-06','2851500','1.850','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 16:12:56','1.850','0','275.80','16700.00','','TOKO','FREETAG','','10','','0','GIE 28 000 000','2','14 0925 6B9','BE-250920-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-39-0','00039045');
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 ('2025-10-06','CBRE-YJXF-39-0','CBRE','TOKO','CBRE','75.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-01479 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-39-0','00039045','RD','1','0.190 ','1300','247');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-39-0','00039045','RD','14','0.060 ','320','19.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-39-0','00039045','RD','8','0.030 ','320','9.6');
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-251006-0014','1','CBRE-YJXF-39-0','1','1.850','1.850','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-39-0','75.00','1','1.850','1.850','1','1.850','1.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.850',berat_out_asli=berat_out_asli+'1.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE' 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-251006-0014','2025-10-06','2025-10-06','16:13','1.85','input','2025-10-06 16:13:10');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250921-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250921-0004';
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-YJXF-40-0','00039046','CBRE-05849 ','CBRE-05849 GIA 7466625407 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2605000','2025-10-06','2605000','1.690','75.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 16:21:31','1.690','0','267.75','16700.00','','TOKO','FREETAG','','10','','0','GIE 26 000 000','3','14 0925 6B6','BE-250921-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-40-0','00039046');
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 ('2025-10-06','CBRE-YJXF-40-0','CBRE','TOKO','CBRE.BALIK','75.00','1.690','1.690','1','1.690','1.690','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-05849 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-40-0','00039046','RD','1','0.170 ','1575','267.75');
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-251006-0015','1','CBRE-YJXF-40-0','1','1.690','1.690','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-40-0','75.00','1','1.690','1.690','1','1.690','1.690');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.690',berat_out_asli=berat_out_asli+'1.690',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251006-0015','2025-10-06','2025-10-06','16:21','1.69','input','2025-10-06 16:21:45');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250921-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250921-0003';
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-YJXF-41-0','00039047','CBRE-03748 ','CINCIN CBRE-03748 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2269000','2025-10-06','2269000','1.330','83.00','75','0','2055000.00','1','0.04', 'input','2025-10-06 16:23:55','1.330','0','159.60','16700.00','','TOKO','FREETAG','','10','','0','IDB 20 000 000','3','14 0925 4B9','BE-250921-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-41-0','00039047');
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 ('2025-10-06','CBRE-YJXF-41-0','CBRE','TOKO','CBRE.BALIK','83.00','1.330','1.330','1','1.330','1.330','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03748 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-41-0','00039047','RD','15','0.380 ','420','159.6');
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-251006-0016','1','CBRE-YJXF-41-0','1','1.330','1.330','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-41-0','83.00','1','1.330','1.330','1','1.330','1.330');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.330',berat_out_asli=berat_out_asli+'1.330',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251006-0016','2025-10-06','2025-10-06','16:24','1.33','input','2025-10-06 16:24:07');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250921-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250921-0002';
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-YJXF-42-0','00039048','CBRE-01203 ','CINCIN CBRE-01203 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4547000','2025-10-06','4547000','2.950','75.00','75.00','0','2055000.00','1','0.04', 'input','2025-10-06 16:25:49','2.950','0','86.95','16700.00','0','TOKO','FREETAG','','10','','0','IDB 22 000 000','4','14 0925 5B9','BE-250921-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-YJXF-42-0','00039048');
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 ('2025-10-06','CBRE-YJXF-42-0','CBRE','TOKO','CBRE.BALIK','75.00','2.950','2.950','1','2.950','2.950','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-01203 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-42-0','00039048','RD','40','0.060 ','370','22.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-YJXF-42-0','00039048','RD','5','0.175 ','370','64.75');
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-251006-0017','1','CBRE-YJXF-42-0','1','2.950','2.950','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-YJXF-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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('2025-10-06','TOKO','SEM-BALIK','CBRE','CBRE-YJXF-42-0','75.00','1','2.950','2.950','1','2.950','2.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.950',berat_out_asli=berat_out_asli+'2.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='CBRE-YJXF-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' 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-251006-0017','2025-10-06','2025-10-06','16:25','2.95','input','2025-10-06 16:26:01');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250921-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250921-0001';
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 ('ABRE-YJXF-43-0','00039049','ABRE-01711 ','ANTING ABRE-01711 ','','GR','---','DM','ABRE','TOKO','ABRE','7250500','2025-10-06','7250500','3.600','98.00','75.00','0','2055000.00','1','0.04', 'input','2025-10-06 16:27:48','3.600','0','168.30','16700.00','0','TOKO','FREETAG','','10','','0','IDB 36 000 000','2','0925 10B0','BE-250921-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-YJXF-43-0','00039049');
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 ('2025-10-06','ABRE-YJXF-43-0','ABRE','TOKO','ABRE','98.00','3.600','3.600','1','3.600','3.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01711 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YJXF-43-0','00039049','RD','8','0.060 ','450','27');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YJXF-43-0','00039049','RD','8','0.090 ','420','37.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-YJXF-43-0','00039049','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('ABRE-YJXF-43-0','00039049','RD','36','0.090 ','450','40.5');
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-251006-0018','1','ABRE-YJXF-43-0','1','3.600','3.600','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-YJXF-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
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('2025-10-06','TOKO','SEM-BALIK','ABRE','ABRE-YJXF-43-0','98.00','1','3.600','3.600','1','3.600','3.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.600',berat_out_asli=berat_out_asli+'3.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-10-06' AND kode_barang='ABRE-YJXF-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' 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-251006-0018','2025-10-06','2025-10-06','16:27','3.6','input','2025-10-06 16:28:01');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-250921-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-250921-0005';
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 ('CMR-YJXF-44-0','00039050','CMRE75-76% ','CINCIN MAS ROSE GOLD ','','GR','---','GOLD','CMR','TOKO','SEM-EMAS','2468000','2025-10-06','2468000','1.580','76.00','75','0','2055000.00','1','0.14', 'input','2025-10-06 16:29:10','1.580','0','','16700.00','','TOKO','FREETAG','','2','','','','2','','BE-250921-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'CMR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMR','CMR-YJXF-44-0','00039050');
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 ('2025-10-06','CMR-YJXF-44-0','CMR','TOKO','SEM-EMAS','76.00','1.580','1.580','1','1.580','1.580','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CMR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMR','CMRE75-76% ');