INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-13 ','08:43:02');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-13','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-13';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-12';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-12';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-12' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-12';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-12';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-12';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-12';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202600 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-00';
UPDATE tt_barang_saldo SET tanggal= '2026-01-13' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-12' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-01-13';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-13 ','08:43:22');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-13 ','08:43:36');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251211-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251211-0004';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('GBRE-ZAAC-1-0','00040839','GBRE-01031 ','GELANG GBRE-01031 ','','GR','---','DM','GBRE','TOKO','GBRE.BALIK','21471000','2026-01-13','21471000','10.550','83.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 08:47:55','10.550','0','658.80','16950.00','0','TOKO','FREETAG','','10','','0','IDB 113 000 000','3','0126 20B850','BE-251211-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-ZAAC-1-0','00040839');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','GBRE-ZAAC-1-0','GBRE','TOKO','GBRE.BALIK','83.00','10.550','10.550','1','10.550','10.550','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-01031 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZAAC-1-0','00040839','RD','3','0.235 ','480','112.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZAAC-1-0','00040839','RD','10','0.910 ','600','546');
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-260113-0001','1','GBRE-ZAAC-1-0','1','10.550','10.550','TOKO','GBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-ZAAC-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-01-13','TOKO','SEM-BALIK','GBRE','GBRE-ZAAC-1-0','83.00','1','10.550','10.550','1','10.550','10.550');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'10.550',berat_out_asli=berat_out_asli+'10.550',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='GBRE-ZAAC-1-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-260113-0001','2026-01-13','2026-01-13','08:48','10.55','input','2026-01-13 08:48:18');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251211-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251211-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LBRE-ZAAC-2-0','00040840','LBRE-00120 ','LIONTIN LBRE-00120 ','','GR','---','DM','LBRE','TOKO','LBRE.BALIK','1730000','2026-01-13','1730000','0.850','83.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 08:51:11','0.850','0','59.55','16950.00','0','TOKO','FREETAG','','10','','0','IDB 11 000 000','3','0126 2B6','BE-251211-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZAAC-2-0','00040840');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','LBRE-ZAAC-2-0','LBRE','TOKO','LBRE.BALIK','83.00','0.850','0.850','1','0.850','0.850','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00120 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-2-0','00040840','RD','13','0.095 ','450','42.75');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-2-0','00040840','RD','3','0.040 ','420','16.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0002','1','LBRE-ZAAC-2-0','1','0.850','0.850','TOKO','LBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZAAC-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE.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-01-13','TOKO','SEM-BALIK','LBRE','LBRE-ZAAC-2-0','83.00','1','0.850','0.850','1','0.850','0.850');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.850',berat_out_asli=berat_out_asli+'0.850',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='LBRE-ZAAC-2-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE.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-260113-0002','2026-01-13','2026-01-13','08:51','0.85','input','2026-01-13 08:51:25');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251211-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251211-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 ('GBRE-ZAAC-3-0','00040841','GBRE-00504 ','GELANG GBRE-00504 ','','GR','---','DM','GBRE','TOKO','GBRE.BALIK','15999500','2026-01-13','15999500','8.700','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 08:53:43','8.700','0','697.20','16950.00','0','TOKO','FREETAG','','10','','0','IDB 96 000 000','4','0126 26B4','BE-251211-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-ZAAC-3-0','00040841');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','GBRE-ZAAC-3-0','GBRE','TOKO','GBRE.BALIK','75.00','8.700','8.700','1','8.700','8.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-00504 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZAAC-3-0','00040841','RD','5','0.290 ','420','121.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZAAC-3-0','00040841','RD','35','1.370 ','420','575.4');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0003','1','GBRE-ZAAC-3-0','1','8.700','8.700','TOKO','GBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-ZAAC-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-01-13','TOKO','SEM-BALIK','GBRE','GBRE-ZAAC-3-0','75.00','1','8.700','8.700','1','8.700','8.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'8.700',berat_out_asli=berat_out_asli+'8.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='GBRE-ZAAC-3-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-260113-0003','2026-01-13','2026-01-13','08:53','8.7','input','2026-01-13 08:53:57');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251211-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251211-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-ZAAC-4-0','00040842','CBRE-03108 ','CINCIN CBRE-03108 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2218500','2026-01-13','2218500','1.090','83.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 08:55:41','1.090','0','40.50','16950.00','','TOKO','FREETAG','','10','','0','IDB 11 500 000','3','RS16 0126 2B750','BE-251211-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-4-0','00040842');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-4-0','CBRE','TOKO','CBRE.BALIK','83.00','1.090','1.090','1','1.090','1.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03108 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-4-0','00040842','RD','27','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-260113-0004','1','CBRE-ZAAC-4-0','1','1.090','1.090','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-ZAAC-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-4-0','83.00','1','1.090','1.090','1','1.090','1.090');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.090',berat_out_asli=berat_out_asli+'1.090',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-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-260113-0004','2026-01-13','2026-01-13','08:55','1.09','input','2026-01-13 08:55:55');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-13 ','09:00:00');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251206-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251206-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 ('KLBE-ZAAC-5-0','00040843','KLBE-00864 ','KALUNG KLBE-00864 ','','GR','---','DM','KLBE','TOKO','SEM-BALIK','10850500','2026-01-13','10850500','5.900','75.00','75','0','2452000.00','1','0.14', 'input','2026-01-13 09:00:10','5.900','0','185.60','16950.00','','TOKO','FREETAG','','10','','','IDB 50 000 000','1','0126 10B4','BE-251206-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-ZAAC-5-0','00040843');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','KLBE-ZAAC-5-0','KLBE','TOKO','SEM-BALIK','75.00','5.900','5.900','1','5.900','5.900','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00864 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-5-0','00040843','RD','1','0.060 ','320','19.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-5-0','00040843','RD','16','0.290 ','320','92.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-5-0','00040843','RD','34','0.230 ','320','73.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251207-0007';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251207-0007';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LBRE-ZAAC-6-0','00040844','LBRE-00776 ','LIONTIN LBRE-00776 ','','GR','---','DM','LBRE','TOKO','LBRE','3053000','2026-01-13','3053000','1.660','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 09:05:25','1.660','0','57.60','16950.00','','TOKO','FREETAG','','10','','0','IDB 15 500 000','2','0126 3B650','BE-251207-0007','');
DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZAAC-6-0','00040844');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','LBRE-ZAAC-6-0','LBRE','TOKO','LBRE','75.00','1.660','1.660','1','1.660','1.660','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00776 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-6-0','00040844','RD','1','0.030 ','320','9.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-6-0','00040844','RD','27','0.150 ','320','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-260113-0005','1','LBRE-ZAAC-6-0','1','1.660','1.660','TOKO','LBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZAAC-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','LBRE','LBRE-ZAAC-6-0','75.00','1','1.660','1.660','1','1.660','1.660');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.660',berat_out_asli=berat_out_asli+'1.660',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='LBRE-ZAAC-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260113-0005','2026-01-13','2026-01-13','09:05','1.66','input','2026-01-13 09:05:38');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251207-0006';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251207-0006';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-7-0','00040845','CBRE-05534 ','CINCIN CBRE-05534 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','7393000','2026-01-13','7393000','4.020','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 09:14:11','4.020','0','82.40','16950.00','0','TOKO','FREETAG','','10','','0','IDB 35 500 000','3','RS14 0126 5B1','BE-251207-0006','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-7-0','00040845');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-7-0','CBRE','TOKO','CBRE.BALIK','75.00','4.020','4.020','1','4.020','4.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-05534 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-7-0','00040845','RD','1','0.040 ','320','12.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-7-0','00040845','RD','18','0.140 ','320','44.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-7-0','00040845','BD','46','0.310 ','80','24.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0006','1','CBRE-ZAAC-7-0','1','4.020','4.020','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-ZAAC-7-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-7-0','75.00','1','4.020','4.020','1','4.020','4.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.020',berat_out_asli=berat_out_asli+'4.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-7-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-260113-0006','2026-01-13','2026-01-13','09:14','4.02','input','2026-01-13 09:14:26');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251212-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251212-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-8-0','00040846','CBRE-05252 ','CBRE-05252 GIA 3455117703 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','6106000','2026-01-13','6106000','3.320','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 09:17:45','3.320','0','637.00','16950.00','0','TOKO','FREETAG','','10','','0','GIE 58 500 000','4','EVVS2 0126 16B0','BE-251212-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-8-0','00040846');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-8-0','CBRE','TOKO','CBRE.BALIK','75.00','3.320','3.320','1','3.320','3.320','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-05252 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-8-0','00040846','RD','68','0.360 ','400','144');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-8-0','00040846','RD','1','0.230 ','1700','391');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-8-0','00040846','RD','12','0.215 ','400','86');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-8-0','00040846','RD','12','0.040 ','400','16');
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-260113-0007','1','CBRE-ZAAC-8-0','1','3.320','3.320','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-ZAAC-8-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-8-0','75.00','1','3.320','3.320','1','3.320','3.320');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.320',berat_out_asli=berat_out_asli+'3.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-8-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-260113-0007','2026-01-13','2026-01-13','09:17','3.32','input','2026-01-13 09:17:59');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251212-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251212-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-ZAAC-9-0','00040847','CBRE-06602 ','CBRE-06602 GIA 7463549318 ','','GR','---','DM','CBRE','TOKO','CBRE','7761000','2026-01-13','7761000','4.220','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 09:20:36','4.220','0','884.80','16950.00','','TOKO','FREETAG','','10','','0','GIE 79 000 000','2','DVS1 0126 20B0','BE-251212-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-9-0','00040847');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-9-0','CBRE','TOKO','CBRE','75.00','4.220','4.220','1','4.220','4.220','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06602 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-9-0','00040847','RD','1','0.500 ','1600','800');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-9-0','00040847','RD','12','0.090 ','320','28.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-9-0','00040847','RD','14','0.175 ','320','56');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0008','1','CBRE-ZAAC-9-0','1','4.220','4.220','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-ZAAC-9-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-9-0','75.00','1','4.220','4.220','1','4.220','4.220');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.220',berat_out_asli=berat_out_asli+'4.220',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-9-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-260113-0008','2026-01-13','2026-01-13','09:20','4.22','input','2026-01-13 09:20:51');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251213-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251213-0005';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-10-0','00040848','CBRE-06208 ','CINCIN CBRE-06208 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','9692000','2026-01-13','9692000','5.270','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 10:49:44','5.270','0','273.60','16950.00','','TOKO','FREETAG','','10','','0','IDB 51 500 000','2','RS15 0126 13B2','BE-251213-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-10-0','00040848');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-10-0','CBRE','TOKO','CBRE.BALIK','75.00','5.270','5.270','1','5.270','5.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06208 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-10-0','00040848','RD','1','0.050 ','320','16');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-10-0','00040848','RD','6','0.145 ','320','46.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-10-0','00040848','RD','6','0.170 ','320','54.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-10-0','00040848','RD','122','0.490 ','320','156.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0009','1','CBRE-ZAAC-10-0','1','5.270','5.270','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-ZAAC-10-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-10-0','75.00','1','5.270','5.270','1','5.270','5.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.270',berat_out_asli=berat_out_asli+'5.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-10-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-260113-0009','2026-01-13','2026-01-13','10:49','5.27','input','2026-01-13 10:49:57');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251213-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251213-0004';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-11-0','00040849','CBRE-02196 ','CINCIN BERLIAN GIA 2294209290 ','','GR','---','DM','CBRE','TOKO','CBRE','5830000','2026-01-13','5830000','3.170','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 10:52:15','3.170','0','439.60','16950.00','0','TOKO','FREETAG','','10','','0','GIE 47 500 000','2','EVVS2 0126 11B2','BE-251213-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-11-0','00040849');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-11-0','CBRE','TOKO','CBRE','75.00','3.170','3.170','1','3.170','3.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02196 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-11-0','00040849','RD','2','0.130 ','320','41.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-11-0','00040849','RD','1','0.230 ','1480','340.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-11-0','00040849','RD','35','0.180 ','320','57.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-260113-0010','1','CBRE-ZAAC-11-0','1','3.170','3.170','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-ZAAC-11-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-11-0','75.00','1','3.170','3.170','1','3.170','3.170');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.170',berat_out_asli=berat_out_asli+'3.170',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-11-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-260113-0010','2026-01-13','2026-01-13','10:52','3.17','input','2026-01-13 10:52:29');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251213-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251213-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 ('KLBE-ZAAC-12-0','00040850','KLBE-00822 ','KALUNG KLBE-00822 ','','GR','---','DM','KLBE','TOKO','KLBE.BALIK','9434500','2026-01-13','9434500','5.130','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 10:55:34','5.130','0','222.00','16950.00','','TOKO','FREETAG','','10','','0','IDB 47 500 000','3','0126 12B2','BE-251213-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-ZAAC-12-0','00040850');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','KLBE-ZAAC-12-0','KLBE','TOKO','KLBE.BALIK','75.00','5.130','5.130','1','5.130','5.130','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00822 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-12-0','00040850','RD','3','0.025 ','400','10');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-12-0','00040850','RD','13','0.315 ','400','126');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-12-0','00040850','RD','16','0.080 ','400','32');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-12-0','00040850','RD','22','0.135 ','400','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-260113-0011','1','KLBE-ZAAC-12-0','1','5.130','5.130','TOKO','KLBE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='KLBE-ZAAC-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.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-01-13','TOKO','SEM-BALIK','KLBE','KLBE-ZAAC-12-0','75.00','1','5.130','5.130','1','5.130','5.130');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'5.130',berat_out_asli=berat_out_asli+'5.130',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='KLBE-ZAAC-12-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.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-260113-0011','2026-01-13','2026-01-13','10:55','5.13','input','2026-01-13 10:55:47');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251213-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251213-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-13-0','00040851','CBRE-02110 ','CINCIN CBRE-02110 ','','GR','---','DM','CBRE','TOKO','CBRE','4064500','2026-01-13','4064500','2.210','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 10:58:13','2.210','0','118.40','16950.00','','TOKO','FREETAG','','10','','0','IDB 22 500 000','2','125 0126 4B850','BE-251213-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-13-0','00040851');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-13-0','CBRE','TOKO','CBRE','75.00','2.210','2.210','1','2.210','2.210','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02110 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-13-0','00040851','RD','1','0.010 ','320','3.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-13-0','00040851','RD','4','0.180 ','320','57.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-13-0','00040851','RD','20','0.090 ','320','28.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-13-0','00040851','RD','26','0.090 ','320','28.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0012','1','CBRE-ZAAC-13-0','1','2.210','2.210','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-ZAAC-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-13-0','75.00','1','2.210','2.210','1','2.210','2.210');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.210',berat_out_asli=berat_out_asli+'2.210',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-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-260113-0012','2026-01-13','2026-01-13','10:58','2.21','input','2026-01-13 10:58:25');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251213-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251213-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 ('GBRE-ZAAC-14-0','00040852','GBRE-01198 ','GELANG GBRE-01198 ','','GR','---','DM','GBRE','TOKO','GBRE.BALIK','6878000','2026-01-13','6878000','3.740','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:00:50','3.740','0','132.00','16950.00','','TOKO','FREETAG','','10','','0','IDB 34 000 000','3','0126 8B4','BE-251213-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-ZAAC-14-0','00040852');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','GBRE-ZAAC-14-0','GBRE','TOKO','GBRE.BALIK','75.00','3.740','3.740','1','3.740','3.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-01198 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZAAC-14-0','00040852','RD','15','0.330 ','400','132');
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-260113-0013','1','GBRE-ZAAC-14-0','1','3.740','3.740','TOKO','GBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-ZAAC-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-01-13','TOKO','SEM-BALIK','GBRE','GBRE-ZAAC-14-0','75.00','1','3.740','3.740','1','3.740','3.740');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.740',berat_out_asli=berat_out_asli+'3.740',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='GBRE-ZAAC-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-260113-0013','2026-01-13','2026-01-13','11:00','3.74','input','2026-01-13 11:01:03');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251214-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251214-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-15-0','00040853','CBRE-06004 ','CBRE-06004 GIA 7478252865 ','','GR','---','DM','CBRE','TOKO','CBRE','2299000','2026-01-13','2299000','1.250','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:04:09','1.250','0','255.00','16950.00','','TOKO','FREETAG','','10','','0','GIE 24 500 000','2','DVVS2 0126 6B4','BE-251214-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-15-0','00040853');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-15-0','CBRE','TOKO','CBRE','75.00','1.250','1.250','1','1.250','1.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06004 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-15-0','00040853','RD','1','0.170 ','1500','255');
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-260113-0014','1','CBRE-ZAAC-15-0','1','1.250','1.250','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-ZAAC-15-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-15-0','75.00','1','1.250','1.250','1','1.250','1.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.250',berat_out_asli=berat_out_asli+'1.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-15-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-260113-0014','2026-01-13','2026-01-13','11:04','1.25','input','2026-01-13 11:04:21');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251214-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251214-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 ('LBRE-ZAAC-16-0','00040854','LBRE-00348 ','LIONTIN LBRE-00348 ','','GR','---','DM','LBRE','TOKO','LBRE','3715000','2026-01-13','3715000','2.020','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:06:44','2.020','0','193.20','16950.00','','TOKO','FREETAG','','10','','0','IDB 26 000 000','2','0126 5B4','BE-251214-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZAAC-16-0','00040854');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','LBRE-ZAAC-16-0','LBRE','TOKO','LBRE','75.00','2.020','2.020','1','2.020','2.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00348 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-16-0','00040854','BG','6','0.280 ','450','126');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-16-0','00040854','RD','1','0.030 ','320','9.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-16-0','00040854','RD','4','0.050 ','320','16');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-16-0','00040854','RD','24','0.130 ','320','41.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-260113-0015','1','LBRE-ZAAC-16-0','1','2.020','2.020','TOKO','LBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZAAC-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','LBRE','LBRE-ZAAC-16-0','75.00','1','2.020','2.020','1','2.020','2.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.020',berat_out_asli=berat_out_asli+'2.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='LBRE-ZAAC-16-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260113-0015','2026-01-13','2026-01-13','11:06','2.02','input','2026-01-13 11:06:57');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251215-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251215-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-17-0','00040855','CBRE-06942 ','CBRE-06942 GIA 2456093726 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','6547000','2026-01-13','6547000','3.560','75.00','75','0','2452000.00','1','0.14', 'input','2026-01-13 11:09:43','3.560','0','375.30','16950.00','','TOKO','FREETAG','','10','','','GIE 46 500 000','1','FVVS2 0126 10B4','BE-251215-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-17-0','00040855');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-17-0','CBRE','TOKO','SEM-BALIK','75.00','3.560','3.560','1','3.560','3.560','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06942 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-17-0','00040855','RD','1','0.210 ','1650','346.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-17-0','00040855','RD','24','0.090 ','320','28.8');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251215-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251215-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 ('CKBE-ZAAC-18-0','00040856','CKBE-00997 ','CINCIN KAWIN CKBE-00997 ','','GR','---','DM','CKBE','TOKO','CKBE','3126500','2026-01-13','3126500','1.700','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:12:01','1.700','0','52.80','16950.00','','TOKO','FREETAG','','10','','0','IDB 17 000 000','2','RS10 0126 2B750','BE-251215-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CKBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKBE','CKBE-ZAAC-18-0','00040856');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CKBE-ZAAC-18-0','CKBE','TOKO','CKBE','75.00','1.700','1.700','1','1.700','1.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKBE','CKBE-00997 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-ZAAC-18-0','00040856','RD','1','0.015 ','320','4.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CKBE-ZAAC-18-0','00040856','RD','28','0.150 ','320','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-260113-0016','1','CKBE-ZAAC-18-0','1','1.700','1.700','TOKO','CKBE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CKBE-ZAAC-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CKBE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','CKBE','CKBE-ZAAC-18-0','75.00','1','1.700','1.700','1','1.700','1.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.700',berat_out_asli=berat_out_asli+'1.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CKBE-ZAAC-18-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CKBE' 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-260113-0016','2026-01-13','2026-01-13','11:12','1.7','input','2026-01-13 11:12:15');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251216-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251216-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-19-0','00040857','CBRE-00046 ','CINCIN CBRE-00046 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4193000','2026-01-13','4193000','2.280','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 11:17:50','2.280','0','152.00','16950.00','','TOKO','FREETAG','','10','','0','IDB 25 000 000','5','RS15 0126 6B1','BE-251216-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-19-0','00040857');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-19-0','CBRE','TOKO','CBRE.BALIK','75.00','2.280','2.280','1','2.280','2.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00046 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-19-0','00040857','RD','14','0.360 ','400','144');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-19-0','00040857','RD','6','0.020 ','400','8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0017','1','CBRE-ZAAC-19-0','1','2.280','2.280','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-ZAAC-19-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-19-0','75.00','1','2.280','2.280','1','2.280','2.280');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.280',berat_out_asli=berat_out_asli+'2.280',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-19-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-260113-0017','2026-01-13','2026-01-13','11:18','2.28','input','2026-01-13 11:18:17');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251216-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251216-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-ZAAC-20-0','00040858','CBRE-06895 ','CINCIN CBRE-06895 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','5129000','2026-01-13','5129000','2.520','83.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:20:36','2.520','535000','68.85','16950.00','','TOKO','FREETAG','','10','','0','IDB 25 500 000','2','RS13 0126 6B8','BE-251216-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-20-0','00040858');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-20-0','CBRE','TOKO','CBRE.BALIK','83.00','2.520','2.520','1','2.520','2.520','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06895 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-20-0','00040858','RD','23','0.125 ','450','56.25');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-20-0','00040858','RD','3','0.030 ','420','12.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-260113-0018','1','CBRE-ZAAC-20-0','1','2.520','2.520','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-ZAAC-20-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-20-0','83.00','1','2.520','2.520','1','2.520','2.520');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.520',berat_out_asli=berat_out_asli+'2.520',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-20-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-260113-0018','2026-01-13','2026-01-13','11:20','2.52','input','2026-01-13 11:20:50');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251217-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251217-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-ZAAC-21-0','00040859','ABRE-00921 ','ANTING ABRE-00921 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','6014000','2026-01-13','6014000','3.270','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 11:23:10','3.270','0','100.80','16950.00','0','TOKO','FREETAG','','10','','0','IDB 29 000 000','3','0126 7B150','BE-251217-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZAAC-21-0','00040859');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','ABRE-ZAAC-21-0','ABRE','TOKO','ABRE.BALIK','75.00','3.270','3.270','1','3.270','3.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00921 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-21-0','00040859','RD','2','0.045 ','420','18.9');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-21-0','00040859','RD','12','0.195 ','420','81.9');
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-260113-0019','1','ABRE-ZAAC-21-0','1','3.270','3.270','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-ZAAC-21-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-01-13','TOKO','SEM-BALIK','ABRE','ABRE-ZAAC-21-0','75.00','1','3.270','3.270','1','3.270','3.270');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.270',berat_out_asli=berat_out_asli+'3.270',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='ABRE-ZAAC-21-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-260113-0019','2026-01-13','2026-01-13','11:23','3.27','input','2026-01-13 11:23:27');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251222-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251222-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-ZAAC-22-0','00040860','CBRE-06943 ','CINCIN CBRE-06943 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','1674000','2026-01-13','1674000','0.910','75.00','75','0','2452000.00','1','0.14', 'input','2026-01-13 11:25:53','0.910','0','41.60','16950.00','','TOKO','FREETAG','','10','','','IDB 9 000 000','1','RS12 0126 2B150','BE-251222-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-22-0','00040860');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-22-0','CBRE','TOKO','SEM-BALIK','75.00','0.910','0.910','1','0.910','0.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06943 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-22-0','00040860','RD','25','0.130 ','320','41.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251220-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251220-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-23-0','00040861','CBRE-00104 ','CINCIN CBRE-00104 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','11512500','2026-01-13','11512500','6.260','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 11:29:18','6.260','0','395.70','16950.00','0','TOKO','FREETAG','','10','','0','IDB 63 000 000','4','RS13 0126 17B1','BE-251220-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-23-0','00040861');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-23-0','CBRE','TOKO','CBRE.BALIK','75.00','6.260','6.260','1','6.260','6.260','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00104 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-23-0','00040861','RD','19','0.610 ','420','256.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-23-0','00040861','RD','40','0.310 ','450','139.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-260113-0020','1','CBRE-ZAAC-23-0','1','6.260','6.260','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-ZAAC-23-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-23-0','75.00','1','6.260','6.260','1','6.260','6.260');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.260',berat_out_asli=berat_out_asli+'6.260',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-23-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-260113-0020','2026-01-13','2026-01-13','11:29','6.26','input','2026-01-13 11:29:31');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251220-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251220-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 ('KLBE-ZAAC-24-0','00040862','KLBE-00857 ','KLBE-00857 GIA 7403853205 ','','GR','---','DM','KLBE','TOKO','KLBE','8220500','2026-01-13','8220500','4.470','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:32:44','4.470','0','564.70','16950.00','','TOKO','FREETAG','','10','','0','GIE 62 000 000','2','DVVS2012617B850','BE-251220-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-ZAAC-24-0','00040862');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','KLBE-ZAAC-24-0','KLBE','TOKO','KLBE','75.00','4.470','4.470','1','4.470','4.470','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00857 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-24-0','00040862','RD','1','0.310 ','1450','449.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-24-0','00040862','RD','20','0.100 ','320','32');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-24-0','00040862','RD','40','0.260 ','320','83.2');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0021','1','KLBE-ZAAC-24-0','1','4.470','4.470','TOKO','KLBE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='KLBE-ZAAC-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','KLBE','KLBE-ZAAC-24-0','75.00','1','4.470','4.470','1','4.470','4.470');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.470',berat_out_asli=berat_out_asli+'4.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='KLBE-ZAAC-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE' 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-260113-0021','2026-01-13','2026-01-13','11:32','4.47','input','2026-01-13 11:32:58');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251221-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251221-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-25-0','00040863','CBRE-06757 ','CINCIN CBRE-06757 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2402000','2026-01-13','2402000','1.180','83.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:35:49','1.180','200000','45.00','16950.00','','TOKO','FREETAG','','10','','0','IDB 12 500 000','2','RS105 0126 3B2','BE-251221-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-25-0','00040863');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-25-0','CBRE','TOKO','CBRE.BALIK','83.00','1.180','1.180','1','1.180','1.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06757 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-25-0','00040863','RD','22','0.100 ','450','45');
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-260113-0022','1','CBRE-ZAAC-25-0','1','1.180','1.180','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-ZAAC-25-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-25-0','83.00','1','1.180','1.180','1','1.180','1.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.180',berat_out_asli=berat_out_asli+'1.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-25-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-260113-0022','2026-01-13','2026-01-13','11:35','1.18','input','2026-01-13 11:36:05');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251221-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251221-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-26-0','00040864','CBRE-06689 ','CBRE-06689 GIA 2454189228 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','7963000','2026-01-13','7963000','4.330','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:38:29','4.330','0','597.90','16950.00','','TOKO','FREETAG','','10','','0','GIE 62 500 000','2','FVVS2012617B250','BE-251221-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-26-0','00040864');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-26-0','CBRE','TOKO','CBRE.BALIK','75.00','4.330','4.330','1','4.330','4.330','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06689 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-26-0','00040864','RD','34','0.500 ','420','210');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-26-0','00040864','RD','14','0.295 ','420','123.9');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-26-0','00040864','RD','8','0.020 ','450','9');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-26-0','00040864','RD','1','0.170 ','1500','255');
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-260113-0023','1','CBRE-ZAAC-26-0','1','4.330','4.330','TOKO','CBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZAAC-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-26-0','75.00','1','4.330','4.330','1','4.330','4.330');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.330',berat_out_asli=berat_out_asli+'4.330',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260113-0023','2026-01-13','2026-01-13','11:38','4.33','input','2026-01-13 11:38:42');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251221-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251221-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-ZAAC-27-0','00040865','CBRE-06314 ','CINCIN CBRE-06314 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','3715000','2026-01-13','3715000','2.020','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 11:40:22','2.020','0','110.40','16950.00','0','TOKO','FREETAG','','10','','0','IDB 20 000 000','2','RS14 0126 5B4','BE-251221-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-27-0','00040865');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-27-0','CBRE','TOKO','CBRE.BALIK','75.00','2.020','2.020','1','2.020','2.020','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06314 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-27-0','00040865','RD','8','0.020 ','320','6.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-27-0','00040865','RD','1','0.160 ','650','104');
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-260113-0024','1','CBRE-ZAAC-27-0','1','2.020','2.020','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-ZAAC-27-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-27-0','75.00','1','2.020','2.020','1','2.020','2.020');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.020',berat_out_asli=berat_out_asli+'2.020',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-27-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-260113-0024','2026-01-13','2026-01-13','11:40','2.02','input','2026-01-13 11:40:38');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251223-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251223-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-28-0','00040866','CBRE-01801 ','CINCIN CBRE-01801 ','','GR','---','DM','CBRE','TOKO','CBRE','3237000','2026-01-13','3237000','1.760','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 11:42:50','1.760','0','64.00','16950.00','0','TOKO','FREETAG','','10','','0','IDB 17 000 000','2','RS14 0126 4B0','BE-251223-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-28-0','00040866');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-28-0','CBRE','TOKO','CBRE','75.00','1.760','1.760','1','1.760','1.760','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-01801 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-28-0','00040866','RD','9','0.105 ','320','33.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-28-0','00040866','RD','18','0.095 ','320','30.4');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0025','1','CBRE-ZAAC-28-0','1','1.760','1.760','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-ZAAC-28-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-28-0','75.00','1','1.760','1.760','1','1.760','1.760');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.760',berat_out_asli=berat_out_asli+'1.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-28-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-260113-0025','2026-01-13','2026-01-13','11:42','1.76','input','2026-01-13 11:43:03');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251223-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251223-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 ('KLBE-ZAAC-29-0','00040867','KLBE-00224 ','KALUNG KLBE-00224 ','','GR','---','DM','KLBE','TOKO','KLBE','7319500','2026-01-13','7319500','3.980','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:45:19','3.980','0','131.20','16950.00','','TOKO','FREETAG','','10','','0','IDB 35 500 000','2','0126 7B2','BE-251223-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-ZAAC-29-0','00040867');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','KLBE-ZAAC-29-0','KLBE','TOKO','KLBE','75.00','3.980','3.980','1','3.980','3.980','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00224 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-29-0','00040867','RD','34','0.205 ','320','65.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-29-0','00040867','RD','16','0.180 ','320','57.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-29-0','00040867','RD','1','0.025 ','320','8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0026','1','KLBE-ZAAC-29-0','1','3.980','3.980','TOKO','KLBE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='KLBE-ZAAC-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','KLBE','KLBE-ZAAC-29-0','75.00','1','3.980','3.980','1','3.980','3.980');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.980',berat_out_asli=berat_out_asli+'3.980',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='KLBE-ZAAC-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE' 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-260113-0026','2026-01-13','2026-01-13','11:45','3.98','input','2026-01-13 11:45:32');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251223-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251223-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 ('KLBE-ZAAC-30-0','00040868','KLBE-00826 ','KALUNG KLBE-00826 ','','GR','---','DM','KLBE','TOKO','KLBE.BALIK','4965500','2026-01-13','4965500','2.700','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:47:31','2.700','0','150.42','16950.00','','TOKO','FREETAG','','10','','0','IDB 28 000 000','3','0126 6B650','BE-251223-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-ZAAC-30-0','00040868');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','KLBE-ZAAC-30-0','KLBE','TOKO','KLBE.BALIK','75.00','2.700','2.700','1','2.700','2.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00826 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-30-0','00040868','RD','1','0.111 ','620','68.82');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZAAC-30-0','00040868','RD','8','0.255 ','320','81.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-260113-0027','1','KLBE-ZAAC-30-0','1','2.700','2.700','TOKO','KLBE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='KLBE-ZAAC-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.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-01-13','TOKO','SEM-BALIK','KLBE','KLBE-ZAAC-30-0','75.00','1','2.700','2.700','1','2.700','2.700');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.700',berat_out_asli=berat_out_asli+'2.700',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='KLBE-ZAAC-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='KLBE.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-260113-0027','2026-01-13','2026-01-13','11:47','2.7','input','2026-01-13 11:47:44');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-251223-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-251223-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-ZAAC-31-0','00040869','TFG-21039 ','GELANG TFG-21039 ','','GR','---','DM','TFG','TOKO','TFG','11494000','2026-01-13','11494000','6.250','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 11:50:13','6.250','0','163.20','16950.00','','TOKO','FREETAG','','10','','0','IDB 51 000 000','2','0126 10B8','FB-251223-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFG','TFG-ZAAC-31-0','00040869');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','TFG-ZAAC-31-0','TFG','TOKO','TFG','75.00','6.250','6.250','1','6.250','6.250','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFG','TFG-21039 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFG-ZAAC-31-0','00040869','RD','50','0.510 ','320','163.2');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0028','1','TFG-ZAAC-31-0','1','6.250','6.250','TOKO','TFG','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='TFG-ZAAC-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFG';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','TFG','TFG-ZAAC-31-0','75.00','1','6.250','6.250','1','6.250','6.250');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'6.250',berat_out_asli=berat_out_asli+'6.250',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='TFG-ZAAC-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='TFG' 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-260113-0028','2026-01-13','2026-01-13','11:50','6.25','input','2026-01-13 11:50:33');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251224-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251224-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 ('CMK-ZAAC-32-0','00040870','CMKE70-71% ','CINCIN MAS KUNING ','','GR','---','GOLD','CMK','TOKO','SEM-EMAS','3830500','2026-01-13','3830500','2.200','71.00','70','0','2452000.00','1','0.14', 'input','2026-01-13 14:00:46','2.200','0','','16950.00','','TOKO','FREETAG','','2','','','','','','BE-251224-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CMK' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMK','CMK-ZAAC-32-0','00040870');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CMK-ZAAC-32-0','CMK','TOKO','SEM-EMAS','71.00','2.200','2.200','1','2.200','2.200','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-251224-0001';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-251224-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 ('TFC-ZAAC-33-0','00040871','TFC-21490 ','CINCIN TFC-21490 ','','GR','---','DM','TFC','TOKO','SEM-BALIK','5168000','2026-01-13','5168000','2.810','75.00','75','0','2452000.00','1','0.14', 'input','2026-01-13 14:03:51','2.810','0','270.00','16950.00','','TOKO','FREETAG','','10','','','IDB 36 000 000','1','RS1450126 7B650','FB-251224-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZAAC-33-0','00040871');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','TFC-ZAAC-33-0','TFC','TOKO','SEM-BALIK','75.00','2.810','2.810','1','2.810','2.810','1');
DELETE FROM tp_kode_intern WHERE kode_dept='TFC';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21490 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZAAC-33-0','00040871','RD','1','0.100 ','620','62');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZAAC-33-0','00040871','RD','20','0.100 ','320','32');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZAAC-33-0','00040871','RD','30','0.550 ','320','176');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251225-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251225-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-34-0','00040872','CBR1805 ','CINCIN CBR1805 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','1821000','2026-01-13','1821000','0.990','75.00','75','0','2452000.00','1','0.14', 'input','2026-01-13 14:06:03','0.990','0','68.20','16950.00','','TOKO','FREETAG','','10','','','IDB 11 000 000','1','RS13 0126 2B8','BE-251225-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-34-0','00040872');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-34-0','CBRE','TOKO','SEM-BALIK','75.00','0.990','0.990','1','0.990','0.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBR1805 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-34-0','00040872','RD','1','0.110 ','620','68.2');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251225-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251225-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-35-0','00040873','CBR1720 ','CINCIN CBR1720 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','1506500','2026-01-13','1506500','0.740','83.00','75','0','2452000.00','1','0.14', 'input','2026-01-13 14:07:43','0.740','0','45.00','16950.00','','TOKO','FREETAG','','10','','','IDB 8 500 000','1','RS11 0126 2B050','BE-251225-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-35-0','00040873');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-35-0','CBRE','TOKO','SEM-BALIK','83.00','0.740','0.740','1','0.740','0.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBR1720 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-35-0','00040873','RD','21','0.100 ','450','45');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251225-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251225-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-ZAAC-36-0','00040874','CBRE-00554 ','CINCIN CBRE-00554 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','1771000','2026-01-13','1771000','0.870','83.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 14:09:19','0.870','500000','40.50','16950.00','','TOKO','FREETAG','','10','','0','IDB 11 000 000','3','RS12 0126 2B8','BE-251225-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-36-0','00040874');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-36-0','CBRE','TOKO','CBRE.BALIK','83.00','0.870','0.870','1','0.870','0.870','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00554 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-36-0','00040874','RD','21','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-260113-0029','1','CBRE-ZAAC-36-0','1','0.870','0.870','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-ZAAC-36-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-36-0','83.00','1','0.870','0.870','1','0.870','0.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.870',berat_out_asli=berat_out_asli+'0.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-36-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-260113-0029','2026-01-13','2026-01-13','14:09','0.87','input','2026-01-13 14:09:32');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251226-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251226-0005';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-37-0','00040875','CBRE-05393 ','CINCIN CBRE-05393 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','10441500','2026-01-13','10441500','4.390','97.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 14:12:15','4.390','0','254.40','16950.00','0','TOKO','FREETAG','','10','','0','IDB 53 000 000','3','RS135 0126 14B2','BE-251226-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-37-0','00040875');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-37-0','CBRE','TOKO','CBRE.BALIK','97.00','4.390','4.390','1','4.390','4.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-05393 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-37-0','00040875','RD','5','0.055 ','420','23.1');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-37-0','00040875','RD','76','0.315 ','420','132.3');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-37-0','00040875','RD','5','0.150 ','420','63');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-37-0','00040875','RD','1','0.075 ','480','36');
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-260113-0030','1','CBRE-ZAAC-37-0','1','4.390','4.390','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-ZAAC-37-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-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-37-0','97.00','1','4.390','4.390','1','4.390','4.390');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.390',berat_out_asli=berat_out_asli+'4.390',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-37-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-260113-0030','2026-01-13','2026-01-13','14:12','4.39','input','2026-01-13 14:12:31');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251226-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251226-0004';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('ABRE-ZAAC-38-0','00040876','ABRE-01279 ','ANTING ABRE-01279 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','4855000','2026-01-13','4855000','2.640','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 14:14:41','2.640','0','164.80','16950.00','0','TOKO','FREETAG','','10','','0','IDB 28 500 000','3','0126 6B950','BE-251226-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZAAC-38-0','00040876');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','ABRE-ZAAC-38-0','ABRE','TOKO','ABRE.BALIK','75.00','2.640','2.640','1','2.640','2.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01279 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-38-0','00040876','RD','22','0.310 ','320','99.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-38-0','00040876','RD','4','0.100 ','320','32');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-38-0','00040876','RD','4','0.085 ','320','27.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-38-0','00040876','RD','2','0.020 ','320','6.4');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0031','1','ABRE-ZAAC-38-0','1','2.640','2.640','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-ZAAC-38-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-01-13','TOKO','SEM-BALIK','ABRE','ABRE-ZAAC-38-0','75.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-01-13' AND kode_barang='ABRE-ZAAC-38-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-260113-0031','2026-01-13','2026-01-13','14:14','2.64','input','2026-01-13 14:14:54');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251226-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251226-0003';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LBRE-ZAAC-39-0','00040877','LBRE-00431 ','LIONTIN LBRE-00431 ','','GR','---','DM','LBRE','TOKO','LBRE.BALIK','4855000','2026-01-13','4855000','2.640','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 14:16:49','2.640','0','144.00','16950.00','','TOKO','FREETAG','','10','','0','IDB 27 000 000','2','0126 6B350','BE-251226-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZAAC-39-0','00040877');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','LBRE-ZAAC-39-0','LBRE','TOKO','LBRE.BALIK','75.00','2.640','2.640','1','2.640','2.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00431 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-39-0','00040877','RD','75','0.450 ','320','144');
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-260113-0032','1','LBRE-ZAAC-39-0','1','2.640','2.640','TOKO','LBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZAAC-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE.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-01-13','TOKO','SEM-BALIK','LBRE','LBRE-ZAAC-39-0','75.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-01-13' AND kode_barang='LBRE-ZAAC-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE.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-260113-0032','2026-01-13','2026-01-13','14:16','2.64','input','2026-01-13 14:17:02');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251226-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251226-0002';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAC-40-0','00040878','CBRE-02812 ','CBRE-02812 GIA 5406635975 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','2483000','2026-01-13','2483000','1.350','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 14:19:37','1.350','0','302.50','16950.00','','TOKO','FREETAG','','10','','0','GIE 29 000 000','3','DVVS201267B250','BE-251226-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-40-0','00040878');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-40-0','CBRE','TOKO','CBRE.BALIK','75.00','1.350','1.350','1','1.350','1.350','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02812 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-40-0','00040878','RD','1','0.160 ','1300','208');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-40-0','00040878','RD','28','0.180 ','450','81');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-40-0','00040878','RD','8','0.030 ','450','13.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-260113-0033','1','CBRE-ZAAC-40-0','1','1.350','1.350','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-ZAAC-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','CBRE','CBRE-ZAAC-40-0','75.00','1','1.350','1.350','1','1.350','1.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.350',berat_out_asli=berat_out_asli+'1.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='CBRE-ZAAC-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260113-0033','2026-01-13','2026-01-13','14:19','1.35','input','2026-01-13 14:19:50');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251226-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251226-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-ZAAC-41-0','00040879','CBRE-06944 ','CINCIN CBRE-06944 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','4781500','2026-01-13','4781500','2.600','75.00','75','0','2452000.00','1','0.14', 'input','2026-01-13 14:22:14','2.600','0','138.40','16950.00','','TOKO','FREETAG','','10','','','IDB 26 500 000','1','RS145 0126 6B6','BE-251226-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-41-0','00040879');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-41-0','CBRE','TOKO','SEM-BALIK','75.00','2.600','2.600','1','2.600','2.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06944 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-41-0','00040879','RD','1','0.120 ','620','74.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-41-0','00040879','RD','22','0.170 ','320','54.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-41-0','00040879','RD','8','0.030 ','320','9.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251227-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251227-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-ZAAC-42-0','00040880','ABRE-01970 ','ANTING ABRE-01970 ','','GR','---','DM','ABRE','TOKO','ABRE','6431500','2026-01-13','6431500','3.160','83.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 14:24:40','3.160','0','163.20','16950.00','','TOKO','FREETAG','','10','','0','IDB 34 000 000','2','0126 8B5','BE-251227-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZAAC-42-0','00040880');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','ABRE-ZAAC-42-0','ABRE','TOKO','ABRE','83.00','3.160','3.160','1','3.160','3.160','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01970 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-42-0','00040880','RD','28','0.100 ','450','45');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-42-0','00040880','RD','10','0.090 ','420','37.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-42-0','00040880','RD','8','0.040 ','450','18');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-42-0','00040880','RD','2','0.130 ','480','62.4');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0034','1','ABRE-ZAAC-42-0','1','3.160','3.160','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZAAC-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','ABRE','ABRE-ZAAC-42-0','83.00','1','3.160','3.160','1','3.160','3.160');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.160',berat_out_asli=berat_out_asli+'3.160',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='ABRE-ZAAC-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260113-0034','2026-01-13','2026-01-13','14:24','3.16','input','2026-01-13 14:24:59');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251227-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251227-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-ZAAC-43-0','00040881','CBRE-06945 ','CINCIN CBRE-06945 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','4395500','2026-01-13','4395500','2.390','75.00','75','0','2452000.00','1','0.14', 'input','2026-01-13 14:26:46','2.390','0','28.80','16950.00','','TOKO','FREETAG','','10','','','IDB 17 500 000','1','RS135 0126 4B4','BE-251227-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAC-43-0','00040881');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','CBRE-ZAAC-43-0','CBRE','TOKO','SEM-BALIK','75.00','2.390','2.390','1','2.390','2.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06945 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-43-0','00040881','RD','1','0.060 ','320','19.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAC-43-0','00040881','RD','8','0.030 ','320','9.6');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251229-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251229-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 ('GBRE-ZAAC-44-0','00040882','GBRE-00550 ','GELANG GBRE-00550 ','','GR','---','DM','GBRE','TOKO','GBRE.BALIK','18225000','2026-01-13','18225000','9.910','75.00','75.00','0','2452000.00','1','0.04', 'input','2026-01-13 14:28:53','9.910','0','524.80','16950.00','0','TOKO','FREETAG','','10','','0','IDB 94 000 000','4','0126 21B6','BE-251229-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-ZAAC-44-0','00040882');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','GBRE-ZAAC-44-0','GBRE','TOKO','GBRE.BALIK','75.00','9.910','9.910','1','9.910','9.910','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-00550 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZAAC-44-0','00040882','RD','57','1.640 ','320','524.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0035','1','GBRE-ZAAC-44-0','1','9.910','9.910','TOKO','GBRE.BALIK','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='GBRE-ZAAC-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-01-13','TOKO','SEM-BALIK','GBRE','GBRE-ZAAC-44-0','75.00','1','9.910','9.910','1','9.910','9.910');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'9.910',berat_out_asli=berat_out_asli+'9.910',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='GBRE-ZAAC-44-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='GBRE.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-260113-0035','2026-01-13','2026-01-13','14:29','9.91','input','2026-01-13 14:29:08');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251230-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251230-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-ZAAC-45-0','00040883','ABRE-01059 ','GIWANG ABRE-01059 ','','GR','---','DM','ABRE','TOKO','ABRE','5370000','2026-01-13','5370000','2.920','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 14:31:22','2.920','0','389.50','16950.00','','TOKO','FREETAG','','10','','0','IDB 43 000 000','2','0126 8B350','BE-251230-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZAAC-45-0','00040883');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','ABRE-ZAAC-45-0','ABRE','TOKO','ABRE','75.00','2.920','2.920','1','2.920','2.920','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01059 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAC-45-0','00040883','RD','2','0.410 ','950','389.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-260113-0036','1','ABRE-ZAAC-45-0','1','2.920','2.920','TOKO','ABRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZAAC-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','ABRE','ABRE-ZAAC-45-0','75.00','1','2.920','2.920','1','2.920','2.920');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.920',berat_out_asli=berat_out_asli+'2.920',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='ABRE-ZAAC-45-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260113-0036','2026-01-13','2026-01-13','14:31','2.92','input','2026-01-13 14:31:35');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-251230-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-251230-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 ('LBRE-ZAAC-46-0','00040884','LBRE-00741 ','LIONTIN LBRE-00741 ','','GR','---','DM','LBRE','TOKO','LBRE','3310500','2026-01-13','3310500','1.800','75.00','75','0','2452000.00','1','0.04', 'input','2026-01-13 14:33:20','1.800','0','99.20','16950.00','','TOKO','FREETAG','','10','','0','IDB 19 500 000','2','0126 4B8','BE-251230-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'LBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LBRE','LBRE-ZAAC-46-0','00040884');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','LBRE-ZAAC-46-0','LBRE','TOKO','LBRE','75.00','1.800','1.800','1','1.800','1.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LBRE','LBRE-00741 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-46-0','00040884','RD','5','0.085 ','320','27.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-46-0','00040884','RD','11','0.110 ','320','35.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('LBRE-ZAAC-46-0','00040884','RD','25','0.115 ','320','36.8');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260113-0037','1','LBRE-ZAAC-46-0','1','1.800','1.800','TOKO','LBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='LBRE-ZAAC-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-13','TOKO','SEM-BALIK','LBRE','LBRE-ZAAC-46-0','75.00','1','1.800','1.800','1','1.800','1.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.800',berat_out_asli=berat_out_asli+'1.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-13' AND kode_barang='LBRE-ZAAC-46-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='LBRE' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260113-0037','2026-01-13','2026-01-13','14:33','1.8','input','2026-01-13 14:33:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-13 ','14:39:14');
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2540500',harga_beli ='2540500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5146000',harga_beli ='5146000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='200500',harga_beli ='200500' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2911500',harga_beli ='2911500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6445500',harga_beli ='6445500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2414500',harga_beli ='2414500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2309500',harga_beli ='2309500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2351500',harga_beli ='2351500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5606000',harga_beli ='5606000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='20701500',harga_beli ='20701500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2880500',harga_beli ='2880500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2854000',harga_beli ='2854000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2697000',harga_beli ='2697000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2801500',harga_beli ='2801500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2775500',harga_beli ='2775500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7790500',harga_beli ='7790500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2983000',harga_beli ='2983000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10685500',harga_beli ='10685500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3854500',harga_beli ='3854500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4531000',harga_beli ='4531000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4654000',harga_beli ='4654000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5474000',harga_beli ='5474000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4428500',harga_beli ='4428500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6335000',harga_beli ='6335000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7565000',harga_beli ='7565000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9123000',harga_beli ='9123000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7380500',harga_beli ='7380500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1538000',harga_beli ='1538000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2850000',harga_beli ='2850000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4346500',harga_beli ='4346500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3936500',harga_beli ='3936500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2255500',harga_beli ='2255500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6663000',harga_beli ='6663000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7995500',harga_beli ='7995500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3567500',harga_beli ='3567500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7073000',harga_beli ='7073000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5617500',harga_beli ='5617500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2727000',harga_beli ='2727000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2317000',harga_beli ='2317000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3690500',harga_beli ='3690500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5470000',harga_beli ='5470000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7052500',harga_beli ='7052500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10681500',harga_beli ='10681500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9635500',harga_beli ='9635500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3526500',harga_beli ='3526500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5494500',harga_beli ='5494500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7667500',harga_beli ='7667500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6991000',harga_beli ='6991000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7196000',harga_beli ='7196000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8262000',harga_beli ='8262000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='16483000',harga_beli ='16483000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1681500',harga_beli ='1681500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1681500',harga_beli ='1681500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1599500',harga_beli ='1599500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1538000',harga_beli ='1538000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5084500',harga_beli ='5084500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8733500',harga_beli ='8733500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9984500',harga_beli ='9984500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8487500',harga_beli ='8487500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7954500',harga_beli ='7954500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8713000',harga_beli ='8713000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7770000',harga_beli ='7770000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4633500',harga_beli ='4633500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='55619500',harga_beli ='55619500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8651500',harga_beli ='8651500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7995500',harga_beli ='7995500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5925000',harga_beli ='5925000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11378500',harga_beli ='11378500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13204000',harga_beli ='13204000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7585500',harga_beli ='7585500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6130000',harga_beli ='6130000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6724500',harga_beli ='6724500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='21629000',harga_beli ='21629000' WHERE kode_barcode='00040839' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1743000',harga_beli ='1743000' WHERE kode_barcode='00040840' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='16117000',harga_beli ='16117000' WHERE kode_barcode='00040841' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2235000',harga_beli ='2235000' WHERE kode_barcode='00040842' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10930000',harga_beli ='10930000' WHERE kode_barcode='00040843' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3075500',harga_beli ='3075500' WHERE kode_barcode='00040844' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7447500',harga_beli ='7447500' WHERE kode_barcode='00040845' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6150500',harga_beli ='6150500' WHERE kode_barcode='00040846' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7818000',harga_beli ='7818000' WHERE kode_barcode='00040847' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9763000',harga_beli ='9763000' WHERE kode_barcode='00040848' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5872500',harga_beli ='5872500' WHERE kode_barcode='00040849' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9503500',harga_beli ='9503500' WHERE kode_barcode='00040850' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4094500',harga_beli ='4094500' WHERE kode_barcode='00040851' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6928500',harga_beli ='6928500' WHERE kode_barcode='00040852' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2316000',harga_beli ='2316000' WHERE kode_barcode='00040853' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3742500',harga_beli ='3742500' WHERE kode_barcode='00040854' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6595000',harga_beli ='6595000' WHERE kode_barcode='00040855' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3149500',harga_beli ='3149500' WHERE kode_barcode='00040856' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4224000',harga_beli ='4224000' WHERE kode_barcode='00040857' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5166500',harga_beli ='5166500' WHERE kode_barcode='00040858' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6058000',harga_beli ='6058000' WHERE kode_barcode='00040859' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1686000',harga_beli ='1686000' WHERE kode_barcode='00040860' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11597000',harga_beli ='11597000' WHERE kode_barcode='00040861' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8281000',harga_beli ='8281000' WHERE kode_barcode='00040862' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2419500',harga_beli ='2419500' WHERE kode_barcode='00040863' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8021500',harga_beli ='8021500' WHERE kode_barcode='00040864' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3742500',harga_beli ='3742500' WHERE kode_barcode='00040865' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3260500',harga_beli ='3260500' WHERE kode_barcode='00040866' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7373000',harga_beli ='7373000' WHERE kode_barcode='00040867' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5002000',harga_beli ='5002000' WHERE kode_barcode='00040868' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11578500',harga_beli ='11578500' WHERE kode_barcode='00040869' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5206000',harga_beli ='5206000' WHERE kode_barcode='00040871' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1834500',harga_beli ='1834500' WHERE kode_barcode='00040872' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1517500',harga_beli ='1517500' WHERE kode_barcode='00040873' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1784000',harga_beli ='1784000' WHERE kode_barcode='00040874' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10518500',harga_beli ='10518500' WHERE kode_barcode='00040875' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4891000',harga_beli ='4891000' WHERE kode_barcode='00040876' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4891000',harga_beli ='4891000' WHERE kode_barcode='00040877' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2501000',harga_beli ='2501000' WHERE kode_barcode='00040878' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4816500',harga_beli ='4816500' WHERE kode_barcode='00040879' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6478500',harga_beli ='6478500' WHERE kode_barcode='00040880' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4428000',harga_beli ='4428000' WHERE kode_barcode='00040881' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='18358500',harga_beli ='18358500' WHERE kode_barcode='00040882' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5409500',harga_beli ='5409500' WHERE kode_barcode='00040883' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3334500',harga_beli ='3334500' WHERE kode_barcode='00040884' LIMIT 1;
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2470000','input','2026-01-13 15:56:06');
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='17321000',harga_beli ='17321000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10162000',harga_beli ='10162000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5354000',harga_beli ='5354000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5396000',harga_beli ='5396000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6261500',harga_beli ='6261500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4753000',harga_beli ='4753000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11804500',harga_beli ='11804500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3623500',harga_beli ='3623500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13585000',harga_beli ='13585000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6458000',harga_beli ='6458000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3858500',harga_beli ='3858500' WHERE kode_barcode='00040870' LIMIT 1;
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2470000','input','2026-01-13 15:56:13');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2470000','input','2026-01-13 16:03:26');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2470000','input','2026-01-13 16:03:31');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2470000','input','2026-01-13 16:03:35');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2470000','input','2026-01-13 16:03:38');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2470000','input','2026-01-13 16:03:43');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2470000','input','2026-01-13 16:03:47');
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3731500',harga_beli ='3731500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2470000','input','2026-01-13 16:03:51');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2470000','input','2026-01-13 16:03:57');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2470000','input','2026-01-13 16:04:01');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2470000','input','2026-01-13 16:04:07');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-02930';
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 ('PSBRE-ZAAC-47-0','00040885','DP-02930 ','KALUNG BERLIAN GIA 6532137047 ','','GR','---','PSBRE','PSBRE','TOKO','PSN','5535500','2026-01-13','5535500','2.700','83.00','75','0','2470000.00','1','0.04', 'input','2026-01-13 16:07:41','2.700','645000','1980.00','16950.00','','TOKO','FREETAG','','10','','','PSN02930','1','DVS1','','DP-02930');
DELETE FROM tp_barang WHERE kode_dept = 'PSBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSBRE','PSBRE-ZAAC-47-0','00040885');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-01-13','PSBRE-ZAAC-47-0','PSBRE','TOKO','PSN','83.00','2.700','2.700','1','2.700','2.700','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSBRE','DP-02930 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('PSBRE-ZAAC-47-0','00040885','OVAL','1','0.900 ','2200','1980');