INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-16 ','08:09:06');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-06-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-15';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-06-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-15' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-06-16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-16 ','08:30:24');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260616-0001','1','CKSE-ZFAE-1-0','1','1.490','TOKO','CKS');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZFAE-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZFAE-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZFAE-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZFAE-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKS';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZFAE-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.490',berat_out_asli='1.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.490',berat_akhir_asli =berat_akhir_asli-'1.490' WHERE kode_barang='CKSE-ZFAE-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260616-0001','2','CKSE-ZFAE-2-0','1','1.170','TOKO','CKS');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZFAE-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZFAE-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZFAE-2-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZFAE-2-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKS';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZFAE-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.170',berat_out_asli='1.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.170',berat_akhir_asli =berat_akhir_asli-'1.170' WHERE kode_barang='CKSE-ZFAE-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260616-0001','3','CKSE-ZFAE-3-0','1','1.070','TOKO','CKS');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZFAE-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZFAE-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZFAE-3-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZFAE-3-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKS';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZFAE-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.070',berat_out_asli='1.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.070',berat_akhir_asli =berat_akhir_asli-'1.070' WHERE kode_barang='CKSE-ZFAE-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260616-0001','4','CKSE-ZFAE-4-0','1','1.660','TOKO','CKS');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZFAE-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZFAE-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZFAE-4-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZFAE-4-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKS';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZFAE-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.660',berat_out_asli='1.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.660',berat_akhir_asli =berat_akhir_asli-'1.660' WHERE kode_barang='CKSE-ZFAE-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260616-0001','5','CKSE-ZFAE-5-0','1','1.660','TOKO','CKS');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZFAE-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZFAE-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZFAE-5-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZFAE-5-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKS';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZFAE-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.660',berat_out_asli='1.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.660',berat_akhir_asli =berat_akhir_asli-'1.660' WHERE kode_barang='CKSE-ZFAE-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260616-0001','6','CKSE-ZFAE-6-0','1','1.720','TOKO','CKS');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZFAE-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZFAE-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZFAE-6-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZFAE-6-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKS';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZFAE-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.720',berat_out_asli='1.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.720',berat_akhir_asli =berat_akhir_asli-'1.720' WHERE kode_barang='CKSE-ZFAE-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260616-0001','7','CKSE-ZFAE-7-0','1','1.630','TOKO','CKS');
DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZFAE-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZFAE-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZFAE-7-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZFAE-7-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKS';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZFAE-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.630',berat_out_asli='1.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.630',berat_akhir_asli =berat_akhir_asli-'1.630' WHERE kode_barang='CKSE-ZFAE-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260616-0001','2026-06-16','2026-06-16','08:30','1.630','input','2026-06-16 08:30:35','ELCO');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-16 ','09:04:41');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260601-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260601-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 ('LBRE-ZFAF-1-0','00044431','LBR0235 ','LIONTIN LBR0235 ','','GR','---','DM','LBRE','TOKO','SEM-BALIK','2743500','2026-06-16','2743500','1.360','83.00','75','0','2430000.00','1','0.14', 'input','2026-06-16 10:00:40','1.360','690000','163.80','18100.00','','TOKO','FREETAG','','10','','','IDB 24 000 000','1','6B4 0626','BE-260601-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZFAF-1-0','00044431');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LBRE-ZFAF-1-0','LBRE','TOKO','SEM-BALIK','83.00','1.360','1.360','1','1.360','1.360','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBR0235 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZFAF-1-0','00044431','RD','39','0.390 ','420','163.8');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260601-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260601-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-ZFAF-2-0','00044432','CBRE-02877 ','CINCIN CBRE-02877 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','6656000','2026-06-16','6656000','3.300','83.00','75.00','0','2430000.00','1','0.04', 'input','2026-06-16 10:02:16','3.300','870000','197.25','18100.00','0','TOKO','FREETAG','','10','','0','IDB 40 000 000','8','RS15 12B4 0626','BE-260601-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZFAF-2-0','00044432');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','CBRE-ZFAF-2-0','CBRE','TOKO','CBRE.BALIK','83.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-02877 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-2-0','00044432','RD','1','0.050 ','480','24');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-2-0','00044432','RD','6','0.150 ','420','63');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-2-0','00044432','RD','16','0.110 ','450','49.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-2-0','00044432','RD','38','0.135 ','450','60.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-260616-0001','1','CBRE-ZFAF-2-0','1','3.300','3.300','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-ZFAF-2-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('2026-06-16','TOKO','SEM-BALIK','CBRE','CBRE-ZFAF-2-0','83.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='2026-06-16' AND kode_barang='CBRE-ZFAF-2-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-260616-0001','2026-06-16','2026-06-16','10:02','3.3','input','2026-06-16 10:02:33');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260601-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260601-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 ('AMP-ZFAF-3-0','00044433','AMPE75-76% ','ANTING MAS PUTIH ','','GR','---','GOLD','AMP','TOKO','SEM-EMAS','2973500','2026-06-16','2973500','1.610','76.00','75','0','2430000.00','1','0.14', 'input','2026-06-16 10:03:47','1.610','0','','18100.00','','TOKO','FREETAG','','2','','','','8','','BE-260601-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'AMP' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('AMP','AMP-ZFAF-3-0','00044433');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','AMP-ZFAF-3-0','AMP','TOKO','SEM-EMAS','76.00','1.610','1.610','1','1.610','1.610','1');
DELETE FROM tp_kode_intern WHERE kode_dept='AMP';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('AMP','AMPE75-76% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260602-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260602-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-ZFAF-4-0','00044434','CBRE-06786 ','CINCIN CBRE-06786 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','5923500','2026-06-16','5923500','3.250','75.00','75','0','2430000.00','1','0.04', 'input','2026-06-16 10:05:25','3.250','0','909.50','18100.00','','TOKO','FREETAG','','10','','0','IDB 77 500 000','2','RS17 20B35 0626','BE-260602-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZFAF-4-0','00044434');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','CBRE-ZFAF-4-0','CBRE','TOKO','CBRE.BALIK','75.00','3.250','3.250','1','3.250','3.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06786 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-4-0','00044434','RD','5','1.070 ','850','909.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-260616-0002','1','CBRE-ZFAF-4-0','1','3.250','3.250','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-ZFAF-4-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('2026-06-16','TOKO','SEM-BALIK','CBRE','CBRE-ZFAF-4-0','75.00','1','3.250','3.250','1','3.250','3.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.250',berat_out_asli=berat_out_asli+'3.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='CBRE-ZFAF-4-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-260616-0002','2026-06-16','2026-06-16','10:05','3.25','input','2026-06-16 10:05:38');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260602-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260602-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 ('AMK-ZFAF-5-0','00044435','AMKE70-71% ','ANTING MAS KUNING ','','GR','---','GOLD','AMK','TOKO','SEM-EMAS','3088500','2026-06-16','3088500','1.790','71.00','70','0','2430000.00','1','0.14', 'input','2026-06-16 10:06:48','1.790','0','','18100.00','','TOKO','FREETAG','','2','','','','2','','BE-260602-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'AMK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('AMK','AMK-ZFAF-5-0','00044435');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','AMK-ZFAF-5-0','AMK','TOKO','SEM-EMAS','71.00','1.790','1.790','1','1.790','1.790','1');
DELETE FROM tp_kode_intern WHERE kode_dept='AMK';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('AMK','AMKE70-71% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260603-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260603-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 ('ABRE-ZFAF-6-0','00044436','ABRE-00802 ','1PS GIWANG ABRE-00802 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','2169000','2026-06-16','2169000','1.190','75.00','75.00','0','2430000.00','1','0.04', 'input','2026-06-16 10:09:04','1.190','0','48.00','18100.00','0','TOKO','FREETAG','','10','','0','IDB 12 000 000','3','2B95 0626','BE-260603-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZFAF-6-0','00044436');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','ABRE-ZFAF-6-0','ABRE','TOKO','ABRE.BALIK','75.00','1.190','1.190','1','1.190','1.190','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00802 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZFAF-6-0','00044436','RD','2','0.100 ','480','48');
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-260616-0003','1','ABRE-ZFAF-6-0','1','1.190','1.190','TOKO','ABRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZFAF-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.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('2026-06-16','TOKO','SEM-BALIK','ABRE','ABRE-ZFAF-6-0','75.00','1','1.190','1.190','1','1.190','1.190');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.190',berat_out_asli=berat_out_asli+'1.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='ABRE-ZFAF-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.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-260616-0003','2026-06-16','2026-06-16','10:09','1.19','input','2026-06-16 10:09:20');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260603-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260603-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 ('CKSE-ZFAF-7-0','00044437','850K-105 ','CINCIN KAWIN SIRKON ','','GR','---','GOLD','CKSE','TOKO','SEM-EMAS','5485500','2026-06-16','5485500','2.970','76.00','75','400000','2430000.00','1','0.14', 'input','2026-06-16 10:11:26','2.970','0','','18100.00','','TOKO','FREETAG','','2','','','','3','','BE-260603-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CKSE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKSE','CKSE-ZFAF-7-0','00044437');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','CKSE-ZFAF-7-0','CKSE','TOKO','SEM-EMAS','76.00','2.970','2.970','1','2.970','2.970','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKSE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKSE','850K-105 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-260603-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-260603-0001';
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 ('TFGKK-ZFAF-8-0','00044438','TFGKK70-71% ','THIFA GELANG KAKU KUNING ','','GR','---','GOLD','TFGKK','TOKO','SEM-EMAS','6625500','2026-06-16','6625500','3.840','71.00','70','0','2430000.00','1','0.14', 'input','2026-06-16 10:13:54','3.840','0','','18100.00','','TOKO','FREETAG','','2','','','','3','','FB-260603-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFGKK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGKK','TFGKK-ZFAF-8-0','00044438');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','TFGKK-ZFAF-8-0','TFGKK','TOKO','SEM-EMAS','71.00','3.840','3.840','1','3.840','3.840','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFGKK';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGKK','TFGKK70-71% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260605-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260605-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 ('KMR-ZFAF-9-0','00044439','KMRE75-76% ','KALUNG MAS ROSE GOLD ','','GR','---','GOLD','KMR','TOKO','SEM-EMAS','5522000','2026-06-16','5522000','2.990','76.00','75','0','2430000.00','1','0.14', 'input','2026-06-16 10:15:28','2.990','0','','18100.00','','TOKO','FREETAG','','2','','','','3','','BE-260605-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'KMR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KMR','KMR-ZFAF-9-0','00044439');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','KMR-ZFAF-9-0','KMR','TOKO','SEM-EMAS','76.00','2.990','2.990','1','2.990','2.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KMR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KMR','KMRE75-76% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260606-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260606-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 ('KLPR-ZFAF-10-0','00044440','KLPRE75-76% ','KALUNG PANJANG ROSEGOLD ELCO ','','GR','---','GOLD','KLPR','TOKO','SEM-EMAS','27610000','2026-06-16','27610000','14.950','76.00','75','0','2430000.00','1','0.14', 'input','2026-06-16 10:20:54','14.950','0','','18100.00','','TOKO','FREETAG','','2','','','','','','BE-260606-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'KLPR' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLPR','KLPR-ZFAF-10-0','00044440');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','KLPR-ZFAF-10-0','KLPR','TOKO','SEM-EMAS','76.00','14.950','14.950','1','14.950','14.950','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLPR';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLPR','KLPRE75-76% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260607-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260607-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-ZFAF-11-0','00044441','ABRE-00875 ','ANTING ABRE-00875 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','4174000','2026-06-16','4174000','2.290','75.00','75.00','0','2430000.00','1','0.04', 'input','2026-06-16 10:25:25','2.290','0','93.60','18100.00','0','TOKO','FREETAG','','10','','0','IDB 22 000 000','6','5B8 0626','BE-260607-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZFAF-11-0','00044441');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','ABRE-ZFAF-11-0','ABRE','TOKO','ABRE.BALIK','75.00','2.290','2.290','1','2.290','2.290','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00875 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZFAF-11-0','00044441','RD','12','0.090 ','450','40.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZFAF-11-0','00044441','RD','2','0.030 ','420','12.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZFAF-11-0','00044441','RD','24','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-260616-0004','1','ABRE-ZFAF-11-0','1','2.290','2.290','TOKO','ABRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZFAF-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.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('2026-06-16','TOKO','SEM-BALIK','ABRE','ABRE-ZFAF-11-0','75.00','1','2.290','2.290','1','2.290','2.290');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.290',berat_out_asli=berat_out_asli+'2.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='ABRE-ZFAF-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.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-260616-0004','2026-06-16','2026-06-16','10:25','2.29','input','2026-06-16 10:25:41');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-260609-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-260609-0001';
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 ('TFG-ZFAF-12-0','00044442','TFG-21057 ','GELANG TFG-21057 ','','GR','---','DM','TFG','TOKO','SEM-BALIK','21150000','2026-06-16','21150000','8.450','103.00','75','0','2430000.00','1','0.14', 'input','2026-06-16 10:27:55','8.450','393000','793.60','18100.00','','TOKO','FREETAG','','10','','','IDB 125 000 000','1','42B4 0626','FB-260609-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFG','TFG-ZFAF-12-0','00044442');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','TFG-ZFAF-12-0','TFG','TOKO','SEM-BALIK','103.00','8.450','8.450','1','8.450','8.450','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFG','TFG-21057 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFG-ZFAF-12-0','00044442','RD','10','1.280 ','620','793.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260610-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260610-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-ZFAF-13-0','00044443','CBRE-03699 ','CINCIN CBRE-03699 ','','GR','---','DM','CBRE','TOKO','CBRE','2679500','2026-06-16','2679500','1.470','75.00','75','0','2430000.00','1','0.04', 'input','2026-06-16 10:29:44','1.470','0','80.00','18100.00','','TOKO','FREETAG','','10','','0','IDB 15 500 000','2','RS15 3B65 0626','BE-260610-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZFAF-13-0','00044443');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','CBRE-ZFAF-13-0','CBRE','TOKO','CBRE','75.00','1.470','1.470','1','1.470','1.470','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03699 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-13-0','00044443','RD','7','0.095 ','320','30.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-13-0','00044443','RD','14','0.155 ','320','49.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-260616-0005','1','CBRE-ZFAF-13-0','1','1.470','1.470','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-ZFAF-13-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('2026-06-16','TOKO','SEM-BALIK','CBRE','CBRE-ZFAF-13-0','75.00','1','1.470','1.470','1','1.470','1.470');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.470',berat_out_asli=berat_out_asli+'1.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='CBRE-ZFAF-13-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-260616-0005','2026-06-16','2026-06-16','10:29','1.47','input','2026-06-16 10:29:58');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260611-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260611-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-ZFAF-14-0','00044444','CBRE-01928 ','CINCIN CBRE-01928 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','5325000','2026-06-16','5325000','2.640','83.00','75.00','0','2430000.00','1','0.04', 'input','2026-06-16 10:32:07','2.640','0','533.40','18100.00','0','TOKO','FREETAG','','10','','0','IDB 54 000 000','3','RS14 15B0 0626','BE-260611-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZFAF-14-0','00044444');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','CBRE-ZFAF-14-0','CBRE','TOKO','CBRE.BALIK','83.00','2.640','2.640','1','2.640','2.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-01928 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-14-0','00044444','RD','58','0.240 ','320','76.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-14-0','00044444','RD','36','0.095 ','320','30.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-14-0','00044444','RD','12','0.160 ','320','51.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZFAF-14-0','00044444','RD','3','0.500 ','750','375');
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-260616-0006','1','CBRE-ZFAF-14-0','1','2.640','2.640','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-ZFAF-14-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('2026-06-16','TOKO','SEM-BALIK','CBRE','CBRE-ZFAF-14-0','83.00','1','2.640','2.640','1','2.640','2.640');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.640',berat_out_asli=berat_out_asli+'2.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='CBRE-ZFAF-14-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-260616-0006','2026-06-16','2026-06-16','10:32','2.64','input','2026-06-16 10:32:20');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260611-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260611-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 ('CMK-ZFAF-15-0','00044445','CMKE70-71% ','CINCIN MAS KUNING ','','GR','---','GOLD','CMK','TOKO','SEM-EMAS','7177500','2026-06-16','7177500','4.160','71.00','70','0','2430000.00','1','0.14', 'input','2026-06-16 10:33:25','4.160','0','','18100.00','','TOKO','FREETAG','','2','','','','3','','BE-260611-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CMK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMK','CMK-ZFAF-15-0','00044445');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','CMK-ZFAF-15-0','CMK','TOKO','SEM-EMAS','71.00','4.160','4.160','1','4.160','4.160','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CMK';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMK','CMKE70-71% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-260611-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-260611-0001';
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 ('TFG-ZFAF-16-0','00044446','TFG-21058 ','GELANG TFG-21058 ','','GR','---','DM','TFG','TOKO','SEM-BALIK','14926500','2026-06-16','14926500','8.190','75.00','75','0','2430000.00','1','0.14', 'input','2026-06-16 10:35:12','8.190','0','105.60','18100.00','','TOKO','FREETAG','','10','','','IDB 58 000 000','1','15B6 0626','FB-260611-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFG','TFG-ZFAF-16-0','00044446');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','TFG-ZFAF-16-0','TFG','TOKO','SEM-BALIK','75.00','8.190','8.190','1','8.190','8.190','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFG','TFG-21058 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFG-ZFAF-16-0','00044446','RD','15','0.105 ','320','33.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFG-ZFAF-16-0','00044446','RD','3','0.150 ','480','72');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-16 ','10:46:49');
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-260616-0007','1','ABRE-ZFAF-6-0','1','1.190','1.190','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZFAF-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.190',berat_in_asli=berat_in_asli+'1.190',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.190',berat_akhir_asli=berat_akhir_asli+'1.190' WHERE tanggal='2026-06-16' AND kode_barang='ABRE-ZFAF-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.190',berat_out_asli=berat_out_asli+'1.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='ABRE-ZFAF-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260616-0007','2','ABRE-ZFAF-11-0','1','2.290','2.290','TOKO','SEM-BALIK','TOKO','ABRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZFAF-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.290',berat_in_asli=berat_in_asli+'2.290',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.290',berat_akhir_asli=berat_akhir_asli+'2.290' WHERE tanggal='2026-06-16' AND kode_barang='ABRE-ZFAF-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.290',berat_out_asli=berat_out_asli+'2.290',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='ABRE-ZFAF-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-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-260616-0007','2026-06-16','2026-06-16','11:11','3.48','input','2026-06-16 11:11:54');
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-260616-0008','1','CBRE-ZFAF-14-0','1','2.640','2.640','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZFAF-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.640',berat_in_asli=berat_in_asli+'2.640',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.640',berat_akhir_asli=berat_akhir_asli+'2.640' WHERE tanggal='2026-06-16' AND kode_barang='CBRE-ZFAF-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.640',berat_out_asli=berat_out_asli+'2.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='CBRE-ZFAF-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260616-0008','2','CBRE-ZFAF-2-0','1','3.300','3.300','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZFAF-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.300',berat_in_asli=berat_in_asli+'3.300',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.300',berat_akhir_asli=berat_akhir_asli+'3.300' WHERE tanggal='2026-06-16' AND kode_barang='CBRE-ZFAF-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
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='2026-06-16' AND kode_barang='CBRE-ZFAF-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260616-0008','3','CBRE-ZFAF-13-0','1','1.470','1.470','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZFAF-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-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('2026-06-16','TOKO','CBRE.BALIK','CBRE','CBRE-ZFAF-13-0','75.00','1','1.470','1.470','1','1.470','1.470');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.470',berat_out_asli=berat_out_asli+'1.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='CBRE-ZFAF-13-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260616-0008','4','CBRE-ZFAF-4-0','1','3.250','3.250','TOKO','SEM-BALIK','TOKO','CBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZFAF-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK';
UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'3.250',berat_in_asli=berat_in_asli+'3.250',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'3.250',berat_akhir_asli=berat_akhir_asli+'3.250' WHERE tanggal='2026-06-16' AND kode_barang='CBRE-ZFAF-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.250',berat_out_asli=berat_out_asli+'3.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='CBRE-ZFAF-4-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-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-260616-0008','2026-06-16','2026-06-16','11:12','10.66','input','2026-06-16 11:12: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-260616-0009','1','LBRE-ZFAF-1-0','1','1.360','1.360','TOKO','SEM-BALIK','TOKO','LBRE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='LBRE.BALIK' WHERE kode_barang='LBRE-ZFAF-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-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('2026-06-16','TOKO','LBRE.BALIK','LBRE','LBRE-ZFAF-1-0','83.00','1','1.360','1.360','1','1.360','1.360');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.360',berat_out_asli=berat_out_asli+'1.360',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='LBRE-ZFAF-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-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-260616-0009','2026-06-16','2026-06-16','11:12','1.36','input','2026-06-16 11:12:48');
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-260616-0010','1','AMK-ZFAF-5-0','1','1.790','1.790','TOKO','SEM-EMAS','TOKO','AMKE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='AMKE.BALIK' WHERE kode_barang='AMK-ZFAF-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-16','TOKO','AMKE.BALIK','AMK','AMK-ZFAF-5-0','71.00','1','1.790','1.790','1','1.790','1.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.790',berat_out_asli=berat_out_asli+'1.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='AMK-ZFAF-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260616-0010','2026-06-16','2026-06-16','11:13','1.79','input','2026-06-16 11:13:23');
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-260616-0011','1','AMP-ZFAF-3-0','1','1.610','1.610','TOKO','SEM-EMAS','TOKO','AMPE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='AMPE.BALIK' WHERE kode_barang='AMP-ZFAF-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-16','TOKO','AMPE.BALIK','AMP','AMP-ZFAF-3-0','76.00','1','1.610','1.610','1','1.610','1.610');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.610',berat_out_asli=berat_out_asli+'1.610',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='AMP-ZFAF-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260616-0011','2026-06-16','2026-06-16','11:13','1.61','input','2026-06-16 11:13:38');
UPDATE tm_lokasi_toko SET deleted_by= 'input',deleted_date = '2026-06-16 11:14:01'  WHERE kode_lokasi_toko='CKS.BALIK';
INSERT INTO tm_lokasi_toko_deleted SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS.BALIK';
DELETE FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS.BALIK';
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-260616-0012','1','CKSE-ZFAF-7-0','1','2.970','2.970','TOKO','SEM-EMAS','TOKO','CKSE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CKSE.BALIK' WHERE kode_barang='CKSE-ZFAF-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-16','TOKO','CKSE.BALIK','CKSE','CKSE-ZFAF-7-0','76.00','1','2.970','2.970','1','2.970','2.970');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.970',berat_out_asli=berat_out_asli+'2.970',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='CKSE-ZFAF-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260616-0012','2026-06-16','2026-06-16','11:14','2.97','input','2026-06-16 11:14:19');
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-260616-0013','1','CMK-ZFAF-15-0','1','4.160','4.160','TOKO','SEM-EMAS','TOKO','CMKE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CMKE.BALIK' WHERE kode_barang='CMK-ZFAF-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-16','TOKO','CMKE.BALIK','CMK','CMK-ZFAF-15-0','71.00','1','4.160','4.160','1','4.160','4.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.160',berat_out_asli=berat_out_asli+'4.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='CMK-ZFAF-15-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260616-0013','2026-06-16','2026-06-16','11:14','4.16','input','2026-06-16 11:14:37');
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-260616-0014','1','KMR-ZFAF-9-0','1','2.990','2.990','TOKO','SEM-EMAS','TOKO','KMPE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='KMPE.BALIK' WHERE kode_barang='KMR-ZFAF-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-16','TOKO','KMPE.BALIK','KMR','KMR-ZFAF-9-0','76.00','1','2.990','2.990','1','2.990','2.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.990',berat_out_asli=berat_out_asli+'2.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='KMR-ZFAF-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260616-0014','2026-06-16','2026-06-16','11:14','2.99','input','2026-06-16 11:14:55');
UPDATE tm_lokasi_toko SET deleted_by= 'input',deleted_date = '2026-06-16 11:15:15'  WHERE kode_lokasi_toko='KLP.BALIK';
INSERT INTO tm_lokasi_toko_deleted SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='KLP.BALIK';
DELETE FROM tm_lokasi_toko WHERE kode_lokasi_toko='KLP.BALIK';
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-260616-0015','1','KLPR-ZFAF-10-0','1','14.950','14.950','TOKO','SEM-EMAS','TOKO','KLPE.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='KLPE.BALIK' WHERE kode_barang='KLPR-ZFAF-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-16','TOKO','KLPE.BALIK','KLPR','KLPR-ZFAF-10-0','76.00','1','14.950','14.950','1','14.950','14.950');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'14.950',berat_out_asli=berat_out_asli+'14.950',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='KLPR-ZFAF-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260616-0015','2026-06-16','2026-06-16','11:15','14.95','input','2026-06-16 11:15:39');
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-260616-0016','1','TFG-ZFAF-12-0','1','8.450','8.450','TOKO','SEM-BALIK','TOKO','TFG.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFG.BALIK' WHERE kode_barang='TFG-ZFAF-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-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('2026-06-16','TOKO','TFG.BALIK','TFG','TFG-ZFAF-12-0','103.00','1','8.450','8.450','1','8.450','8.450');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.450',berat_out_asli=berat_out_asli+'8.450',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='TFG-ZFAF-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260616-0016','2','TFG-ZFAF-16-0','1','8.190','8.190','TOKO','SEM-BALIK','TOKO','TFG.BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFG.BALIK' WHERE kode_barang='TFG-ZFAF-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-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('2026-06-16','TOKO','TFG.BALIK','TFG','TFG-ZFAF-16-0','75.00','1','8.190','8.190','1','8.190','8.190');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.190',berat_out_asli=berat_out_asli+'8.190',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='TFG-ZFAF-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-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-260616-0016','2026-06-16','2026-06-16','11:16','16.64','input','2026-06-16 11:16:37');
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-260616-0017','1','TFGKK-ZFAF-8-0','1','3.840','3.840','TOKO','SEM-EMAS','TOKO','GLKTF');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='GLKTF' WHERE kode_barang='TFGKK-ZFAF-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-06-16','TOKO','GLKTF','TFGKK','TFGKK-ZFAF-8-0','71.00','1','3.840','3.840','1','3.840','3.840');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.840',berat_out_asli=berat_out_asli+'3.840',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-06-16' AND kode_barang='TFGKK-ZFAF-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' 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-260616-0017','2026-06-16','2026-06-16','11:17','3.84','input','2026-06-16 11:17:38');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-17-0','00044447','500K-175-2702 ','CINCIN SILVER 925 YL-01 ','','GR','---','PER','PBDG','TOKO','PBDG','203500','2026-06-16','203500','2.030','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 15:08:41','2.030','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-17-0','00044447');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-17-0','PBDG','TOKO','PBDG','100.00','2.030','2.030','1','2.030','2.030','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-175-2702 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-18-0','00044448','500K-18-2703 ','CINCIN SILVER 925 YL-01 ','','GR','---','PER','PBDG','TOKO','PBDG','203500','2026-06-16','203500','2.030','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 15:09:08','2.030','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-18-0','00044448');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-18-0','PBDG','TOKO','PBDG','100.00','2.030','2.030','1','2.030','2.030','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-18-2703 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-19-0','00044449','750K-18-2704 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','326000','2026-06-16','326000','3.260','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 15:09:50','3.260','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-19-0','00044449');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-19-0','PBDG','TOKO','PBDG','100.00','3.260','3.260','1','3.260','3.260','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-18-2704 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-20-0','00044450','750K-17-2705 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','277000','2026-06-16','277000','2.770','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 15:10:30','2.770','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-20-0','00044450');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-20-0','PBDG','TOKO','PBDG','100.00','2.770','2.770','1','2.770','2.770','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-17-2705 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-21-0','00044451','750K-20-2706 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','306000','2026-06-16','306000','3.060','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 15:11:18','3.060','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-21-0','00044451');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-21-0','PBDG','TOKO','PBDG','100.00','3.060','3.060','1','3.060','3.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-20-2706 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-22-0','00044452','750K-17-2707 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','201500','2026-06-16','201500','2.010','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 15:11:57','2.010','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-22-0','00044452');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-22-0','PBDG','TOKO','PBDG','100.00','2.010','2.010','1','2.010','2.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-17-2707 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-23-0','00044453','750K-12-2708 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','193000','2026-06-16','193000','1.930','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 15:12:34','1.930','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-23-0','00044453');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-23-0','PBDG','TOKO','PBDG','100.00','1.930','1.930','1','1.930','1.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-12-2708 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-24-0','00044454','750K-17-2709 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','241000','2026-06-16','241000','2.410','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 15:13:14','2.410','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-24-0','00044454');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-24-0','PBDG','TOKO','PBDG','100.00','2.410','2.410','1','2.410','2.410','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-17-2709 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-25-0','00044455','750K-21-2710 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','354000','2026-06-16','354000','3.540','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 15:13:53','3.540','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-25-0','00044455');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-25-0','PBDG','TOKO','PBDG','100.00','3.540','3.540','1','3.540','3.540','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-21-2710 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-26-0','00044456','750K-19-2711 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','324000','2026-06-16','324000','3.240','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 15:14:16','3.240','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-26-0','00044456');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-26-0','PBDG','TOKO','PBDG','100.00','3.240','3.240','1','3.240','3.240','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-19-2711 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-27-0','00044457','750K-105-2712 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','209000','2026-06-16','209000','2.090','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 15:14:55','2.090','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-27-0','00044457');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-27-0','PBDG','TOKO','PBDG','100.00','2.090','2.090','1','2.090','2.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-105-2712 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-28-0','00044458','750K-20-2713 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','387000','2026-06-16','387000','3.870','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 15:15:33','3.870','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-28-0','00044458');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-28-0','PBDG','TOKO','PBDG','100.00','3.870','3.870','1','3.870','3.870','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-20-2713 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-29-0','00044459','750K-155-2714 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','283000','2026-06-16','283000','2.830','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 15:16:11','2.830','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-29-0','00044459');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-29-0','PBDG','TOKO','PBDG','100.00','2.830','2.830','1','2.830','2.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-155-2714 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-30-0','00044460','750K-22-2715 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','415500','2026-06-16','415500','4.150','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 15:16:49','4.150','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-30-0','00044460');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-30-0','PBDG','TOKO','PBDG','100.00','4.150','4.150','1','4.150','4.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-22-2715 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-31-0','00044461','750K-175-2716 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','277000','2026-06-16','277000','2.770','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 15:17:26','2.770','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-31-0','00044461');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-31-0','PBDG','TOKO','PBDG','100.00','2.770','2.770','1','2.770','2.770','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-175-2716 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-32-0','00044462','750K-175-2717 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','199000','2026-06-16','199000','1.990','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 15:18:04','1.990','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-32-0','00044462');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-32-0','PBDG','TOKO','PBDG','100.00','1.990','1.990','1','1.990','1.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-175-2717 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-33-0','00044463','750K-20-2718 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','272000','2026-06-16','272000','2.720','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 15:18:40','2.720','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-33-0','00044463');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-33-0','PBDG','TOKO','PBDG','100.00','2.720','2.720','1','2.720','2.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','750K-20-2718 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-34-0','00044464','900K-9-2719 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','177000','2026-06-16','177000','1.770','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-16 15:19:22','1.770','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-34-0','00044464');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-34-0','PBDG','TOKO','PBDG','100.00','1.770','1.770','1','1.770','1.770','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-9-2719 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-35-0','00044465','900K-11-2720 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','144000','2026-06-16','144000','1.440','100.00','925','300000','100000.00','1','0.14', 'input','2026-06-16 15:19:58','1.440','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-35-0','00044465');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-35-0','PBDG','TOKO','PBDG','100.00','1.440','1.440','1','1.440','1.440','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','900K-11-2720 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZFAF-36-0','00044466','950K-12-2721 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','160000','2026-06-16','160000','1.600','100.00','925','430000','100000.00','1','0.14', 'input','2026-06-16 15:20:37','1.600','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZFAF-36-0','00044466');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','PBDG-ZFAF-36-0','PBDG','TOKO','PBDG','100.00','1.600','1.600','1','1.600','1.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','950K-12-2721 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-37-0','00044467','500K-18-00422 ','CINCIN SILVER 925 YL-01 ','','GR','---','PER','LXPER','TOKO','DUPER','197000','2026-06-16','197000','1.970','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 16:04:32','1.970','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-37-0','00044467');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-37-0','LXPER','TOKO','DUPER','100.00','1.970','1.970','1','1.970','1.970','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','500K-18-00422 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-38-0','00044468','500K-18-00423 ','CINCIN SILVER 925 YL-01 ','','GR','---','PER','LXPER','TOKO','DUPER','210000','2026-06-16','210000','2.100','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 16:04:56','2.100','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-38-0','00044468');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-38-0','LXPER','TOKO','DUPER','100.00','2.100','2.100','1','2.100','2.100','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','500K-18-00423 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-39-0','00044469','500K-17-00424 ','CINCIN SILVER 925 YL-01 ','','GR','---','PER','LXPER','TOKO','DUPER','197000','2026-06-16','197000','1.970','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 16:05:20','1.970','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-39-0','00044469');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-39-0','LXPER','TOKO','DUPER','100.00','1.970','1.970','1','1.970','1.970','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','500K-17-00424 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-40-0','00044470','750K-18-00425 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','319000','2026-06-16','319000','3.190','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:06:34','3.190','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-40-0','00044470');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-40-0','LXPER','TOKO','DUPER','100.00','3.190','3.190','1','3.190','3.190','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-18-00425 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-41-0','00044471','750K-16-00426 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','320000','2026-06-16','320000','3.200','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 16:06:57','3.200','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-41-0','00044471');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-41-0','LXPER','TOKO','DUPER','100.00','3.200','3.200','1','3.200','3.200','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-16-00426 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-42-0','00044472','750K-18-00427 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','300000','2026-06-16','300000','3.000','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:07:20','3.000','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-42-0','00044472');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-42-0','LXPER','TOKO','DUPER','100.00','3.000','3.000','1','3.000','3.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-18-00427 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-43-0','00044473','750K-115-00428 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','182000','2026-06-16','182000','1.820','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:08:00','1.820','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-43-0','00044473');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-43-0','LXPER','TOKO','DUPER','100.00','1.820','1.820','1','1.820','1.820','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-115-00428 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-44-0','00044474','750K-17-00429 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','247500','2026-06-16','247500','2.470','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:08:38','2.470','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-44-0','00044474');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-44-0','LXPER','TOKO','DUPER','100.00','2.470','2.470','1','2.470','2.470','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-17-00429 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-45-0','00044475','750K-16-00430 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','180000','2026-06-16','180000','1.800','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:09:23','1.800','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-45-0','00044475');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-45-0','LXPER','TOKO','DUPER','100.00','1.800','1.800','1','1.800','1.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-16-00430 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-46-0','00044476','750K-105-00431 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','170000','2026-06-16','170000','1.700','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:09:45','1.700','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-46-0','00044476');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-46-0','LXPER','TOKO','DUPER','100.00','1.700','1.700','1','1.700','1.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-105-00431 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-47-0','00044477','750K-14-00432 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','234000','2026-06-16','234000','2.340','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:10:07','2.340','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-47-0','00044477');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-47-0','LXPER','TOKO','DUPER','100.00','2.340','2.340','1','2.340','2.340','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-14-00432 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-48-0','00044478','750K-10-00433 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','189000','2026-06-16','189000','1.890','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:10:44','1.890','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-48-0','00044478');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-48-0','LXPER','TOKO','DUPER','100.00','1.890','1.890','1','1.890','1.890','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-10-00433 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-49-0','00044479','750K-185-00434 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','299000','2026-06-16','299000','2.990','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:11:05','2.990','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-49-0','00044479');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-49-0','LXPER','TOKO','DUPER','100.00','2.990','2.990','1','2.990','2.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-185-00434 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-50-0','00044480','750K-105-00435 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','165000','2026-06-16','165000','1.650','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:11:28','1.650','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-50-0','00044480');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-50-0','LXPER','TOKO','DUPER','100.00','1.650','1.650','1','1.650','1.650','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-105-00435 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-51-0','00044481','750K-115-00436 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','191000','2026-06-16','191000','1.910','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-16 16:11:51','1.910','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-51-0','00044481');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-51-0','LXPER','TOKO','DUPER','100.00','1.910','1.910','1','1.910','1.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-115-00436 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-52-0','00044482','750K-175-00437 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','224500','2026-06-16','224500','2.240','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-16 16:12:28','2.240','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-52-0','00044482');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-52-0','LXPER','TOKO','DUPER','100.00','2.240','2.240','1','2.240','2.240','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-175-00437 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-53-0','00044483','850K-15-00438 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','154000','2026-06-16','154000','1.540','100.00','925','370000','100000.00','1','0.14', 'input','2026-06-16 16:13:06','1.540','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-53-0','00044483');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-53-0','LXPER','TOKO','DUPER','100.00','1.540','1.540','1','1.540','1.540','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','850K-15-00438 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-54-0','00044484','900K-14-00439 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','204000','2026-06-16','204000','2.040','100.00','925','370000','100000.00','1','0.14', 'input','2026-06-16 16:13:49','2.040','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-54-0','00044484');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-54-0','LXPER','TOKO','DUPER','100.00','2.040','2.040','1','2.040','2.040','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','900K-14-00439 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-55-0','00044485','900K-105-00440 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','182000','2026-06-16','182000','1.820','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-16 16:14:14','1.820','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-55-0','00044485');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-55-0','LXPER','TOKO','DUPER','100.00','1.820','1.820','1','1.820','1.820','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','900K-105-00440 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZFAF-56-0','00044486','900K-14-00441 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','150000','2026-06-16','150000','1.500','100.00','925','300000','100000.00','1','0.14', 'input','2026-06-16 16:14:36','1.500','0','','18100.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZFAF-56-0','00044486');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-16','LXPER-ZFAF-56-0','LXPER','TOKO','DUPER','100.00','1.500','1.500','1','1.500','1.500','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LXPER';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','900K-14-00441 ');