INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-16 ','08:05:02');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-01-16','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-12-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-01-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-01-15';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-01-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-01-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-01-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-01-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-01-15';
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-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-01-15' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-01-16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-16 ','08:11:41');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-1-0','00040938','700K-11-2149 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','83500','2026-01-16','83500','1.390','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:22:21','1.390','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-1-0','00040938');
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-16','PBDG-ZAAF-1-0','PBDG','TOKO','PBDG','100.00','1.390','1.390','1','1.390','1.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-11-2149 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-2-0','00040939','700K-21-2150 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','134000','2026-01-16','134000','2.230','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:23:02','2.230','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-2-0','00040939');
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-16','PBDG-ZAAF-2-0','PBDG','TOKO','PBDG','100.00','2.230','2.230','1','2.230','2.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-21-2150 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-3-0','00040940','800K-125-2151 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','147000','2026-01-16','147000','2.450','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:23:40','2.450','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-3-0','00040940');
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-16','PBDG-ZAAF-3-0','PBDG','TOKO','PBDG','100.00','2.450','2.450','1','2.450','2.450','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','800K-125-2151 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-4-0','00040941','700K-12-2152 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','143500','2026-01-16','143500','2.390','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:24:18','2.390','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-4-0','00040941');
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-16','PBDG-ZAAF-4-0','PBDG','TOKO','PBDG','100.00','2.390','2.390','1','2.390','2.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-12-2152 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-5-0','00040942','700K-11-2153 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','185500','2026-01-16','185500','3.090','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:24:53','3.090','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-5-0','00040942');
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-16','PBDG-ZAAF-5-0','PBDG','TOKO','PBDG','100.00','3.090','3.090','1','3.090','3.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-11-2153 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-6-0','00040943','700K-16-2154 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','164500','2026-01-16','164500','2.740','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:25:29','2.740','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-6-0','00040943');
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-16','PBDG-ZAAF-6-0','PBDG','TOKO','PBDG','100.00','2.740','2.740','1','2.740','2.740','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-16-2154 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-7-0','00040944','500K-20-2155 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','157500','2026-01-16','157500','2.620','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:26:03','2.620','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-7-0','00040944');
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-16','PBDG-ZAAF-7-0','PBDG','TOKO','PBDG','100.00','2.620','2.620','1','2.620','2.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','500K-20-2155 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-8-0','00040945','700K-18-2156 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','283500','2026-01-16','283500','4.720','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:26:38','4.720','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-8-0','00040945');
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-16','PBDG-ZAAF-8-0','PBDG','TOKO','PBDG','100.00','4.720','4.720','1','4.720','4.720','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-18-2156 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-9-0','00040946','700K-20-2157 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','275000','2026-01-16','275000','4.580','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:26:58','4.580','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-9-0','00040946');
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-16','PBDG-ZAAF-9-0','PBDG','TOKO','PBDG','100.00','4.580','4.580','1','4.580','4.580','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-20-2157 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-10-0','00040947','950K-12-2158 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','203500','2026-01-16','203500','3.390','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:27:30','3.390','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-10-0','00040947');
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-16','PBDG-ZAAF-10-0','PBDG','TOKO','PBDG','100.00','3.390','3.390','1','3.390','3.390','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','950K-12-2158 ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PBDG-ZAAF-11-0','00040948','700K-18-2159 ','CINCIN SILVER 925 ','','GR','---','PER','PBDG','TOKO','PBDG','223000','2026-01-16','223000','3.710','100.00','925','150000','60000.00','1','0.14', 'input','2026-01-16 08:28:07','3.710','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'PBDG' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PBDG','PBDG-ZAAF-11-0','00040948');
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-16','PBDG-ZAAF-11-0','PBDG','TOKO','PBDG','100.00','3.710','3.710','1','3.710','3.710','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PBDG';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PBDG','700K-18-2159 ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','1','PLDMM-ZAAE-34-0','1','2.080','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-34-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-34-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-34-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-34-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-34-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.080',berat_out_asli='2.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.080',berat_akhir_asli =berat_akhir_asli-'2.080' WHERE kode_barang='PLDMM-ZAAE-34-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','2','PLDMM-ZAAE-35-0','1','1.980','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-35-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-35-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-35-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-35-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.980',berat_out_asli='1.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.980',berat_akhir_asli =berat_akhir_asli-'1.980' WHERE kode_barang='PLDMM-ZAAE-35-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','3','PLDMM-ZAAE-36-0','1','2.110','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-36-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-36-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-36-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-36-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='PLDMM-ZAAE-36-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','4','PLDMM-ZAAE-37-0','1','1.970','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-37-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-37-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-37-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-37-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='PLDMM-ZAAE-37-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','5','PLDMM-ZAAE-38-0','1','1.860','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-38-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-38-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-38-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-38-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.860',berat_out_asli='1.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.860',berat_akhir_asli =berat_akhir_asli-'1.860' WHERE kode_barang='PLDMM-ZAAE-38-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','6','PLDMM-ZAAE-39-0','1','2.040','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-39-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-39-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-39-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-39-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-39-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.040',berat_out_asli='2.040', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.040',berat_akhir_asli =berat_akhir_asli-'2.040' WHERE kode_barang='PLDMM-ZAAE-39-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','7','PLDMM-ZAAE-40-0','1','2.660','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-40-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-40-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-40-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-40-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-40-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.660',berat_out_asli='2.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.660',berat_akhir_asli =berat_akhir_asli-'2.660' WHERE kode_barang='PLDMM-ZAAE-40-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','8','PLDMM-ZAAE-41-0','1','2.750','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-41-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-41-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-41-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-41-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.750',berat_out_asli='2.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.750',berat_akhir_asli =berat_akhir_asli-'2.750' WHERE kode_barang='PLDMM-ZAAE-41-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','9','PLDMM-ZAAE-42-0','1','2.770','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-42-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-42-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-42-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-42-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.770',berat_out_asli='2.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.770',berat_akhir_asli =berat_akhir_asli-'2.770' WHERE kode_barang='PLDMM-ZAAE-42-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','10','PLDMM-ZAAE-43-0','1','3.360','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-43-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-43-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-43-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-43-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-43-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.360',berat_out_asli='3.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.360',berat_akhir_asli =berat_akhir_asli-'3.360' WHERE kode_barang='PLDMM-ZAAE-43-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0001','11','PLDMM-ZAAE-44-0','1','3.390','TOKO','MMPLD');
DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZAAE-44-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZAAE-44-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZAAE-44-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZAAE-44-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZAAE-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.390',berat_out_asli='3.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.390',berat_akhir_asli =berat_akhir_asli-'3.390' WHERE kode_barang='PLDMM-ZAAE-44-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260116-0001','2026-01-16','2026-01-16','08:34','3.390','input','2026-01-16 08:34:20','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0002','1','PSPRT-ZAAE-19-0','1','1.390','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZAAE-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZAAE-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZAAE-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZAAE-19-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZAAE-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.390',berat_out_asli='1.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.390',berat_akhir_asli =berat_akhir_asli-'1.390' WHERE kode_barang='PSPRT-ZAAE-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0002','2','PSPRT-ZAAE-20-0','1','3.360','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZAAE-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZAAE-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZAAE-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZAAE-20-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZAAE-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.360',berat_out_asli='3.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.360',berat_akhir_asli =berat_akhir_asli-'3.360' WHERE kode_barang='PSPRT-ZAAE-20-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0002','3','PSGT-ZAAE-21-0','1','2.100','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZAAE-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZAAE-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZAAE-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZAAE-21-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZAAE-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.100',berat_out_asli='2.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.100',berat_akhir_asli =berat_akhir_asli-'2.100' WHERE kode_barang='PSGT-ZAAE-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0002','4','PSPRT-ZAAE-52-0','1','4.300','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZAAE-52-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZAAE-52-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZAAE-52-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZAAE-52-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZAAE-52-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.300',berat_out_asli='4.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.300',berat_akhir_asli =berat_akhir_asli-'4.300' WHERE kode_barang='PSPRT-ZAAE-52-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260116-0002','2026-01-16','2026-01-16','08:34','4.300','input','2026-01-16 08:34:33','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','1','PBDG-ZAAF-1-0','1','1.390','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-1-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.390',berat_out_asli='1.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.390',berat_akhir_asli =berat_akhir_asli-'1.390' WHERE kode_barang='PBDG-ZAAF-1-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','2','PBDG-ZAAF-2-0','1','2.230','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-2-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.230',berat_out_asli='2.230', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.230',berat_akhir_asli =berat_akhir_asli-'2.230' WHERE kode_barang='PBDG-ZAAF-2-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','3','PBDG-ZAAF-3-0','1','2.450','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-3-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.450',berat_out_asli='2.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.450',berat_akhir_asli =berat_akhir_asli-'2.450' WHERE kode_barang='PBDG-ZAAF-3-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','4','PBDG-ZAAF-4-0','1','2.390','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-4-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.390',berat_out_asli='2.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.390',berat_akhir_asli =berat_akhir_asli-'2.390' WHERE kode_barang='PBDG-ZAAF-4-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','5','PBDG-ZAAF-5-0','1','3.090','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-5-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.090',berat_out_asli='3.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.090',berat_akhir_asli =berat_akhir_asli-'3.090' WHERE kode_barang='PBDG-ZAAF-5-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','6','PBDG-ZAAF-6-0','1','2.740','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.740',berat_out_asli='2.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.740',berat_akhir_asli =berat_akhir_asli-'2.740' WHERE kode_barang='PBDG-ZAAF-6-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','7','PBDG-ZAAF-7-0','1','2.620','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-7-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.620',berat_out_asli='2.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.620',berat_akhir_asli =berat_akhir_asli-'2.620' WHERE kode_barang='PBDG-ZAAF-7-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','8','PBDG-ZAAF-8-0','1','4.720','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.720',berat_out_asli='4.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.720',berat_akhir_asli =berat_akhir_asli-'4.720' WHERE kode_barang='PBDG-ZAAF-8-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','9','PBDG-ZAAF-9-0','1','4.580','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-9-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.580',berat_out_asli='4.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.580',berat_akhir_asli =berat_akhir_asli-'4.580' WHERE kode_barang='PBDG-ZAAF-9-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','10','PBDG-ZAAF-10-0','1','3.390','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-10-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.390',berat_out_asli='3.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.390',berat_akhir_asli =berat_akhir_asli-'3.390' WHERE kode_barang='PBDG-ZAAF-10-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0003','11','PBDG-ZAAF-11-0','1','3.710','TOKO','PBDG');
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZAAF-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PBDG-ZAAF-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PBDG-ZAAF-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PBDG-ZAAF-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PBDG';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PBDG';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PBDG-ZAAF-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.710',berat_out_asli='3.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.710',berat_akhir_asli =berat_akhir_asli-'3.710' WHERE kode_barang='PBDG-ZAAF-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260116-0003','2026-01-16','2026-01-16','08:56','3.710','input','2026-01-16 08:56:21','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-16 ','08:56:57');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-01582';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLT-ZAAF-12-0','00040949','DP-01582BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','286000','2026-01-16','286000','2.310','5.00','10','300000','2473000.00','1','0.14', 'input','2026-01-16 09:20:53','2.310','0','','16950.00','','TOKO','FREETAG','','10','','','PSN01582BIP','1','RS 16','','DP-01582');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZAAF-12-0','00040949');
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-16','PSPLT-ZAAF-12-0','PSPLT','TOKO','PSNB','5.00','2.310','2.310','1','2.310','2.310','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-01582BIP ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0004','1','PSPLT-ZAAE-45-0','1','3.050','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZAAE-45-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZAAE-45-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZAAE-45-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZAAE-45-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZAAE-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.050',berat_out_asli='3.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.050',berat_akhir_asli =berat_akhir_asli-'3.050' WHERE kode_barang='PSPLT-ZAAE-45-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0004','2','PSPLT-ZAAE-46-0','1','5.090','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZAAE-46-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZAAE-46-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZAAE-46-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZAAE-46-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZAAE-46-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.090',berat_out_asli='5.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.090',berat_akhir_asli =berat_akhir_asli-'5.090' WHERE kode_barang='PSPLT-ZAAE-46-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0004','3','PSPLT-ZAAE-47-0','1','2.540','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZAAE-47-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZAAE-47-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZAAE-47-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZAAE-47-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZAAE-47-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.540',berat_out_asli='2.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.540',berat_akhir_asli =berat_akhir_asli-'2.540' WHERE kode_barang='PSPLT-ZAAE-47-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0004','4','PSPLT-ZAAE-48-0','1','3.540','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZAAE-48-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZAAE-48-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZAAE-48-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZAAE-48-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZAAE-48-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.540',berat_out_asli='3.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.540',berat_akhir_asli =berat_akhir_asli-'3.540' WHERE kode_barang='PSPLT-ZAAE-48-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0004','5','PSPLT-ZAAE-49-0','1','1.450','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZAAE-49-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZAAE-49-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZAAE-49-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZAAE-49-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZAAE-49-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.450',berat_out_asli='1.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.450',berat_akhir_asli =berat_akhir_asli-'1.450' WHERE kode_barang='PSPLT-ZAAE-49-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0004','6','PSPLT-ZAAE-50-0','1','2.720','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZAAE-50-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZAAE-50-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZAAE-50-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZAAE-50-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZAAE-50-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.720',berat_out_asli='2.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.720',berat_akhir_asli =berat_akhir_asli-'2.720' WHERE kode_barang='PSPLT-ZAAE-50-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0004','7','PSPLT-ZAAE-51-0','1','1.540','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZAAE-51-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZAAE-51-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZAAE-51-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZAAE-51-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZAAE-51-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.540',berat_out_asli='1.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.540',berat_akhir_asli =berat_akhir_asli-'1.540' WHERE kode_barang='PSPLT-ZAAE-51-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0004','8','PSPLT-ZAAF-12-0','1','2.310','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZAAF-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZAAF-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZAAF-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZAAF-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZAAF-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.310',berat_out_asli='2.310', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.310',berat_akhir_asli =berat_akhir_asli-'2.310' WHERE kode_barang='PSPLT-ZAAF-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260116-0004','2026-01-16','2026-01-16','09:22','2.310','input','2026-01-16 09:22:17','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-01-16 ','13:08:18');
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2563500',harga_beli ='2563500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5192000',harga_beli ='5192000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='202000',harga_beli ='202000' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2937500',harga_beli ='2937500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='6503000',harga_beli ='6503000' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2436000',harga_beli ='2436000' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2330500',harga_beli ='2330500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2372500',harga_beli ='2372500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5656000',harga_beli ='5656000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='20885500',harga_beli ='20885500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2906000',harga_beli ='2906000' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2879500',harga_beli ='2879500' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2721000',harga_beli ='2721000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2826500',harga_beli ='2826500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2800500',harga_beli ='2800500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7860000',harga_beli ='7860000' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='3009500',harga_beli ='3009500' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='10780500',harga_beli ='10780500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='3889000',harga_beli ='3889000' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='4571500',harga_beli ='4571500' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='4695500',harga_beli ='4695500' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5523000',harga_beli ='5523000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='4468000',harga_beli ='4468000' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='6391500',harga_beli ='6391500' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7632500',harga_beli ='7632500' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='9204500',harga_beli ='9204500' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7446500',harga_beli ='7446500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='1551500',harga_beli ='1551500' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2875500',harga_beli ='2875500' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='4385000',harga_beli ='4385000' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='3971500',harga_beli ='3971500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2275500',harga_beli ='2275500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2192500',harga_beli ='2192500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='6722500',harga_beli ='6722500' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='8067000',harga_beli ='8067000' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='3599000',harga_beli ='3599000' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7136000',harga_beli ='7136000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5667500',harga_beli ='5667500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2751000',harga_beli ='2751000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='2337500',harga_beli ='2337500' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5316000',harga_beli ='5316000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='3723500',harga_beli ='3723500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5519000',harga_beli ='5519000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7115500',harga_beli ='7115500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='10776500',harga_beli ='10776500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='9721500',harga_beli ='9721500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='3558000',harga_beli ='3558000' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5543500',harga_beli ='5543500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7736000',harga_beli ='7736000' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7053500',harga_beli ='7053500' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7260000',harga_beli ='7260000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='8336000',harga_beli ='8336000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='16630000',harga_beli ='16630000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='1696500',harga_beli ='1696500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='1696500',harga_beli ='1696500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='1613500',harga_beli ='1613500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='1551500',harga_beli ='1551500' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5130000',harga_beli ='5130000' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='8811500',harga_beli ='8811500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='10073000',harga_beli ='10073000' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='8563500',harga_beli ='8563500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='8025500',harga_beli ='8025500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='8791000',harga_beli ='8791000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7839500',harga_beli ='7839500' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='4675000',harga_beli ='4675000' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='56115000',harga_beli ='56115000' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='8729000',harga_beli ='8729000' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='8067000',harga_beli ='8067000' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5978000',harga_beli ='5978000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='11479500',harga_beli ='11479500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='13322000',harga_beli ='13322000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='7653000',harga_beli ='7653000' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='6184500',harga_beli ='6184500' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='6784500',harga_beli ='6784500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5316000',harga_beli ='5316000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2492000','input','2026-01-16 13:57:03');
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='17475500',harga_beli ='17475500' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='10252500',harga_beli ='10252500' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5401500',harga_beli ='5401500' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='5444000',harga_beli ='5444000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='6317500',harga_beli ='6317500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='4795000',harga_beli ='4795000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='11909500',harga_beli ='11909500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='3655500',harga_beli ='3655500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='13706000',harga_beli ='13706000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='6515500',harga_beli ='6515500' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2492000','input','2026-01-16 13:57:19');
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PLD','2492000','input','2026-01-16 13:57:23');
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2492000','input','2026-01-16 13:57:26');
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2492000','input','2026-01-16 13:57:29');
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2492000','input','2026-01-16 13:57:33');
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2492000','input','2026-01-16 13:57:37');
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2492000','input','2026-01-16 13:57:41');
UPDATE tm_barang SET harga_skrg ='2492000',harga_jual='3764500',harga_beli ='3764500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2492000','input','2026-01-16 13:57:44');
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PSPLE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLE','2492000','input','2026-01-16 13:57:49');
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PSPLL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLL','2492000','input','2026-01-16 13:57:53');
UPDATE tm_group SET harga='2492000' WHERE kode_group = 'PSPLT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSPLT','2492000','input','2026-01-16 13:57:58');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260103-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260103-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-ZAAF-13-0','00040950','GBRE-01295 ','GELANG GBRE-01295 ','','GR','---','DM','GBRE','TOKO','GBRE.BALIK','9186000','2026-01-16','9186000','3.800','97.00','75','0','2492000.00','1','0.04', 'input','2026-01-16 14:59:53','3.800','0','265.50','16950.00','','TOKO','FREETAG','','10','','0','IDB 49 000 000','2','0126 13B2','BE-260103-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'GBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('GBRE','GBRE-ZAAF-13-0','00040950');
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-16','GBRE-ZAAF-13-0','GBRE','TOKO','GBRE.BALIK','97.00','3.800','3.800','1','3.800','3.800','1');
DELETE FROM tp_kode_intern WHERE kode_dept='GBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('GBRE','GBRE-01295 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('GBRE-ZAAF-13-0','00040950','RD','104','0.590 ','450','265.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-260116-0001','1','GBRE-ZAAF-13-0','1','3.800','3.800','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-ZAAF-13-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-16','TOKO','SEM-BALIK','GBRE','GBRE-ZAAF-13-0','97.00','1','3.800','3.800','1','3.800','3.800');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.800',berat_out_asli=berat_out_asli+'3.800',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-16' AND kode_barang='GBRE-ZAAF-13-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-260116-0001','2026-01-16','2026-01-16','15:00','3.8','input','2026-01-16 15:00:17');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260103-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260103-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-ZAAF-14-0','00040951','CBRE-03868 ','CBRE-03868 GIA 5423175713 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','5215000','2026-01-16','5215000','2.790','75.00','75','0','2492000.00','1','0.04', 'input','2026-01-16 15:04:42','2.790','0','468.10','16950.00','','TOKO','FREETAG','','10','','0','GIE 47 000 000','3','FVVS2 0126 10B8','BE-260103-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAF-14-0','00040951');
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-16','CBRE-ZAAF-14-0','CBRE','TOKO','CBRE.BALIK','75.00','2.790','2.790','1','2.790','2.790','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03868 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-14-0','00040951','RD','1','0.230 ','1750','402.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-14-0','00040951','RD','44','0.175 ','320','56');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-14-0','00040951','RD','8','0.030 ','320','9.6');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260116-0002','1','CBRE-ZAAF-14-0','1','2.790','2.790','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-ZAAF-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-16','TOKO','SEM-BALIK','CBRE','CBRE-ZAAF-14-0','75.00','1','2.790','2.790','1','2.790','2.790');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.790',berat_out_asli=berat_out_asli+'2.790',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-16' AND kode_barang='CBRE-ZAAF-14-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260116-0002','2026-01-16','2026-01-16','15:04','2.79','input','2026-01-16 15:04:54');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260103-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260103-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-ZAAF-15-0','00040952','CBRE-02834 ','CINCIN CBRE-02834 ','','GR','---','DM','CBRE','TOKO','CBRE','4299000','2026-01-16','4299000','2.300','75.00','75','0','2492000.00','1','0.04', 'input','2026-01-16 15:07:01','2.300','0','64.55','16950.00','','TOKO','FREETAG','','10','','0','IDB 21 000 000','2','RS13 0126 3B950','BE-260103-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAF-15-0','00040952');
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-16','CBRE-ZAAF-15-0','CBRE','TOKO','CBRE','75.00','2.300','2.300','1','2.300','2.300','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-02834 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-15-0','00040952','SP','1','0.395 ','50','19.75');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-15-0','00040952','SP','12','0.140 ','320','44.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-260116-0003','1','CBRE-ZAAF-15-0','1','2.300','2.300','TOKO','CBRE','TOKO','SEM-BALIK');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZAAF-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-16','TOKO','SEM-BALIK','CBRE','CBRE-ZAAF-15-0','75.00','1','2.300','2.300','1','2.300','2.300');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.300',berat_out_asli=berat_out_asli+'2.300',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-16' AND kode_barang='CBRE-ZAAF-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-260116-0003','2026-01-16','2026-01-16','15:07','2.3','input','2026-01-16 15:07:16');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260103-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260103-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-ZAAF-16-0','00040953','CBRE-06501 ','CINCIN CBRE-06501 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','6598000','2026-01-16','6598000','3.530','75.00','75','0','2492000.00','1','0.04', 'input','2026-01-16 15:09:28','3.530','0','304.50','16950.00','','TOKO','FREETAG','','10','','0','IDB 42 000 000','2','RS150126 11B250','BE-260103-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAF-16-0','00040953');
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-16','CBRE-ZAAF-16-0','CBRE','TOKO','CBRE.BALIK','75.00','3.530','3.530','1','3.530','3.530','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06501 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-16-0','00040953','RD','68','0.255 ','400','102');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-16-0','00040953','RD','5','0.405 ','500','202.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-260116-0004','1','CBRE-ZAAF-16-0','1','3.530','3.530','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-ZAAF-16-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-16','TOKO','SEM-BALIK','CBRE','CBRE-ZAAF-16-0','75.00','1','3.530','3.530','1','3.530','3.530');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.530',berat_out_asli=berat_out_asli+'3.530',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-16' AND kode_barang='CBRE-ZAAF-16-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-260116-0004','2026-01-16','2026-01-16','15:09','3.53','input','2026-01-16 15:09:40');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260103-0005';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260103-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 ('CMP-ZAAF-17-0','00040954','CMPE75-76% ','CINCIN MAS PUTIH ','','GR','---','GOLD','CMP','TOKO','SEM-EMAS','3655500','2026-01-16','3655500','1.930','76.00','75','0','2492000.00','1','0.14', 'input','2026-01-16 15:13:00','1.930','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','BE-260103-0005','');
DELETE FROM tp_barang WHERE kode_dept = 'CMP' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMP','CMP-ZAAF-17-0','00040954');
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-16','CMP-ZAAF-17-0','CMP','TOKO','SEM-EMAS','76.00','1.930','1.930','1','1.930','1.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CMP';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMP','CMPE75-76% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260104-0004';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260104-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-ZAAF-18-0','00040955','CBRE-04401 ','CINCIN CBRE-04401 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','8896500','2026-01-16','8896500','4.760','75.00','75','0','2492000.00','1','0.04', 'input','2026-01-16 15:19:21','4.760','0','169.60','16950.00','','TOKO','FREETAG','','10','','0','IDB 42 000 000','2','RS15 0126 8B8','BE-260104-0004','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAF-18-0','00040955');
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-16','CBRE-ZAAF-18-0','CBRE','TOKO','CBRE.BALIK','75.00','4.760','4.760','1','4.760','4.760','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04401 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-18-0','00040955','RD','74','0.530 ','320','169.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-260116-0005','1','CBRE-ZAAF-18-0','1','4.760','4.760','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-ZAAF-18-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-16','TOKO','SEM-BALIK','CBRE','CBRE-ZAAF-18-0','75.00','1','4.760','4.760','1','4.760','4.760');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.760',berat_out_asli=berat_out_asli+'4.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-16' AND kode_barang='CBRE-ZAAF-18-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-260116-0005','2026-01-16','2026-01-16','15:19','4.76','input','2026-01-16 15:19:34');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260104-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260104-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-ZAAF-19-0','00040956','CBRE-04054 ','CINCIN CBRE-04054 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','7158500','2026-01-16','7158500','3.830','75.00','75.00','0','2492000.00','1','0.04', 'input','2026-01-16 15:22:58','3.830','0','245.80','16950.00','0','TOKO','FREETAG','','10','','0','IDB 40 500 000','4','RS13 0126 10B4','BE-260104-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAF-19-0','00040956');
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-16','CBRE-ZAAF-19-0','CBRE','TOKO','CBRE.BALIK','75.00','3.830','3.830','1','3.830','3.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-04054 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-19-0','00040956','RD','44','0.200 ','320','64');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-19-0','00040956','RD','8','0.220 ','320','70.4');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-19-0','00040956','RD','20','0.135 ','320','43.2');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-19-0','00040956','RD','1','0.110 ','620','68.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-260116-0006','1','CBRE-ZAAF-19-0','1','3.830','3.830','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-ZAAF-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-16','TOKO','SEM-BALIK','CBRE','CBRE-ZAAF-19-0','75.00','1','3.830','3.830','1','3.830','3.830');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.830',berat_out_asli=berat_out_asli+'3.830',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-16' AND kode_barang='CBRE-ZAAF-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-260116-0006','2026-01-16','2026-01-16','15:23','3.83','input','2026-01-16 15:23:12');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260104-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260104-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-ZAAF-20-0','00040957','ABRE-00104 ','GIWANG ABRE-00104 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','3227000','2026-01-16','3227000','1.560','83.00','75.00','0','2492000.00','1','0.04', 'input','2026-01-16 15:25:38','1.560','0','192.00','16950.00','0','TOKO','FREETAG','','10','','0','IDB 24 000 000','3','0126 6B1','BE-260104-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZAAF-20-0','00040957');
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-16','ABRE-ZAAF-20-0','ABRE','TOKO','ABRE.BALIK','83.00','1.560','1.560','1','1.560','1.560','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00104 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAF-20-0','00040957','RD','20','0.480 ','400','192');
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-260116-0007','1','ABRE-ZAAF-20-0','1','1.560','1.560','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-ZAAF-20-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-16','TOKO','SEM-BALIK','ABRE','ABRE-ZAAF-20-0','83.00','1','1.560','1.560','1','1.560','1.560');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.560',berat_out_asli=berat_out_asli+'1.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-16' AND kode_barang='ABRE-ZAAF-20-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-260116-0007','2026-01-16','2026-01-16','15:25','1.56','input','2026-01-16 15:25:51');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260104-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260104-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-ZAAF-21-0','00040958','ABRE-00872 ','GIWANG ABRE-00872 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','4672500','2026-01-16','4672500','2.500','75.00','75','0','2492000.00','1','0.04', 'input','2026-01-16 15:31:04','2.500','0','334.40','16950.00','','TOKO','FREETAG','','10','','0','IDB 37 000 000','2','0126 8B4','BE-260104-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZAAF-21-0','00040958');
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-16','ABRE-ZAAF-21-0','ABRE','TOKO','ABRE.BALIK','75.00','2.500','2.500','1','2.500','2.500','1');
DELETE FROM tp_kode_intern WHERE kode_dept='ABRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-00872 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAF-21-0','00040958','RD','2','0.280 ','600','168');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZAAF-21-0','00040958','RD','38','0.520 ','320','166.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-260116-0008','1','ABRE-ZAAF-21-0','1','2.500','2.500','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-ZAAF-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-16','TOKO','SEM-BALIK','ABRE','ABRE-ZAAF-21-0','75.00','1','2.500','2.500','1','2.500','2.500');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.500',berat_out_asli=berat_out_asli+'2.500',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-16' AND kode_barang='ABRE-ZAAF-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-260116-0008','2026-01-16','2026-01-16','15:31','2.5','input','2026-01-16 15:31:20');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT5-ZAAF-22-0','00040959','LMT5-110% ','LM ANTAM 5 GR H75355197 ','','GR','---','GOLD','LMT5','TOKO','LMT','13706000','2026-01-16','13706000','5.000','110.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:35:28','5.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT5','LMT5-ZAAF-22-0','00040959');
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-16','LMT5-ZAAF-22-0','LMT5','TOKO','LMT','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT5','LMT5-110% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT5-ZAAF-23-0','00040960','LMT5-110% ','LM ANTAM 5 GR H75355198 ','','GR','---','GOLD','LMT5','TOKO','LMT','13706000','2026-01-16','13706000','5.000','110.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:35:56','5.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT5','LMT5-ZAAF-23-0','00040960');
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-16','LMT5-ZAAF-23-0','LMT5','TOKO','LMT','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT5','LMT5-110% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT5-ZAAF-24-0','00040961','LMT5-110% ','LM ANTAM 5 GR H75355199 ','','GR','---','GOLD','LMT5','TOKO','LMT','13706000','2026-01-16','13706000','5.000','110.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:36:22','5.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT5','LMT5-ZAAF-24-0','00040961');
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-16','LMT5-ZAAF-24-0','LMT5','TOKO','LMT','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT5','LMT5-110% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT5-ZAAF-25-0','00040962','LMT5-110% ','LM ANTAM 5 GR H75355173 ','','GR','---','GOLD','LMT5','TOKO','LMT','13706000','2026-01-16','13706000','5.000','110.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:36:46','5.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT5','LMT5-ZAAF-25-0','00040962');
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-16','LMT5-ZAAF-25-0','LMT5','TOKO','LMT','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT5','LMT5-110% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT5-ZAAF-26-0','00040963','LMT5-110% ','LM ANTAM 5 GR H75355174 ','','GR','---','GOLD','LMT5','TOKO','LMT','13706000','2026-01-16','13706000','5.000','110.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:37:10','5.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT5' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT5','LMT5-ZAAF-26-0','00040963');
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-16','LMT5-ZAAF-26-0','LMT5','TOKO','LMT','110.00','5.000','5.000','1','5.000','5.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT5';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT5','LMT5-110% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT1-ZAAF-27-0','00040964','LMT1-115% ','LM ANTAM 1 GR K74443571 ','','GR','---','GOLD','LMT1','TOKO','LMT','2866000','2026-01-16','2866000','1.000','115.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:38:19','1.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT1','LMT1-ZAAF-27-0','00040964');
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-16','LMT1-ZAAF-27-0','LMT1','TOKO','LMT','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT1','LMT1-115% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT1-ZAAF-28-0','00040965','LMT1-115% ','LM ANTAM 1 GR K74443572 ','','GR','---','GOLD','LMT1','TOKO','LMT','2866000','2026-01-16','2866000','1.000','115.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:38:46','1.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT1','LMT1-ZAAF-28-0','00040965');
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-16','LMT1-ZAAF-28-0','LMT1','TOKO','LMT','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT1','LMT1-115% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT1-ZAAF-29-0','00040966','LMT1-115% ','LM ANTAM 1 GR K74443602 ','','GR','---','GOLD','LMT1','TOKO','LMT','2866000','2026-01-16','2866000','1.000','115.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:39:10','1.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT1','LMT1-ZAAF-29-0','00040966');
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-16','LMT1-ZAAF-29-0','LMT1','TOKO','LMT','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT1','LMT1-115% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT1-ZAAF-30-0','00040967','LMT1-115% ','LM ANTAM 1 GR K74443603 ','','GR','---','GOLD','LMT1','TOKO','LMT','2866000','2026-01-16','2866000','1.000','115.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:39:35','1.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT1','LMT1-ZAAF-30-0','00040967');
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-16','LMT1-ZAAF-30-0','LMT1','TOKO','LMT','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT1','LMT1-115% ');
UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LMT1-ZAAF-31-0','00040968','LMT1-115% ','LM ANTAM 1 GR K74443570 ','','GR','---','GOLD','LMT1','TOKO','LMT','2866000','2026-01-16','2866000','1.000','115.00','9999','0','2492000.00','1','0.14', 'input','2026-01-16 15:40:31','1.000','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'LMT1' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LMT1','LMT1-ZAAF-31-0','00040968');
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-16','LMT1-ZAAF-31-0','LMT1','TOKO','LMT','115.00','1.000','1.000','1','1.000','1.000','1');
DELETE FROM tp_kode_intern WHERE kode_dept='LMT1';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LMT1','LMT1-115% ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260105-0003';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260105-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-ZAAF-32-0','00040969','CBRE-06946 ','CBRE-06946 GIA 6335162772 ','','GR','---','DM','CBRE','TOKO','SEM-BALIK','6429500','2026-01-16','6429500','3.440','75.00','75','0','2492000.00','1','0.14', 'input','2026-01-16 16:20:09','3.440','500000','644.80','16950.00','','TOKO','FREETAG','','10','','','GIE 62 000 000','1','DVS1 0126 17B8','BE-260105-0003','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAF-32-0','00040969');
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-16','CBRE-ZAAF-32-0','CBRE','TOKO','SEM-BALIK','75.00','3.440','3.440','1','3.440','3.440','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06946 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-32-0','00040969','RD','1','0.500 ','1200','600');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-32-0','00040969','RD','18','0.080 ','320','25.6');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-32-0','00040969','RD','12','0.060 ','320','19.2');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260105-0002';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260105-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-ZAAF-33-0','00040970','CBRE-01169 ','CINCIN CBRE-01169 ','','GR','---','DM','CBRE','TOKO','CBRE','6803500','2026-01-16','6803500','3.640','75.00','75.00','0','2492000.00','1','0.04', 'input','2026-01-16 16:22:17','3.640','0','176.80','16950.00','','TOKO','FREETAG','','10','','0','IDB 36 500 000','2','RS1450126 7B450','BE-260105-0002','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAF-33-0','00040970');
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-16','CBRE-ZAAF-33-0','CBRE','TOKO','CBRE','75.00','3.640','3.640','1','3.640','3.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-01169 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-33-0','00040970','RD','1','0.180 ','600','108');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-33-0','00040970','RD','14','0.175 ','320','56');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-33-0','00040970','RD','8','0.040 ','320','12.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-260116-0009','1','CBRE-ZAAF-33-0','1','3.640','3.640','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-ZAAF-33-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-16','TOKO','SEM-BALIK','CBRE','CBRE-ZAAF-33-0','75.00','1','3.640','3.640','1','3.640','3.640');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.640',berat_out_asli=berat_out_asli+'3.640',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-01-16' AND kode_barang='CBRE-ZAAF-33-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-260116-0009','2026-01-16','2026-01-16','16:22','3.64','input','2026-01-16 16:22:30');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-260105-0001';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-260105-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-ZAAF-34-0','00040971','CBRE-06499 ','CINCIN CBRE-06499 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4710000','2026-01-16','4710000','2.520','75.00','75.00','0','2492000.00','1','0.04', 'input','2026-01-16 16:27:21','2.520','0','156.30','16950.00','0','TOKO','FREETAG','','10','','0','IDB 27 500 000','2','RS14 0126 7B0','BE-260105-0001','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAF-34-0','00040971');
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-16','CBRE-ZAAF-34-0','CBRE','TOKO','CBRE.BALIK','75.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-06499 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-34-0','00040971','RD','4','0.040 ','420','16.8');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-34-0','00040971','RD','4','0.075 ','420','31.5');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-34-0','00040971','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('CBRE-ZAAF-34-0','00040971','RD','20','0.115 ','400','46');
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-260116-0010','1','CBRE-ZAAF-34-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-ZAAF-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-01-16','TOKO','SEM-BALIK','CBRE','CBRE-ZAAF-34-0','75.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-16' AND kode_barang='CBRE-ZAAF-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260116-0010','2026-01-16','2026-01-16','16:27','2.52','input','2026-01-16 16:27:34');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CBRE-ZAAF-35-0','00040972','CBRE-06947 ','CBRE-06947 GIA 1499287578 ','','GR','---','DM','CBRE','TOKO','CBRE','7032500','2026-01-16','7032500','3.400','83.00','75','0','2492000.00','1','0.04', 'input','2026-01-16 16:38:09','3.400','635000','1015.00','16950.00','','TOKO','FREETAG','','10','','','GIA 87 500 000','1','ESI1 RS 14','','');
DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZAAF-35-0','00040972');
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-16','CBRE-ZAAF-35-0','CBRE','TOKO','CBRE','83.00','3.400','3.400','1','3.400','3.400','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CBRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-06947 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZAAF-35-0','00040972','RD','1','0.700 ','1450','1015');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-36-0','00040973','700K-15-913 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','257000','2026-01-16','257000','4.280','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:47:53','4.280','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-36-0','00040973');
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-16','CKPRE-ZAAF-36-0','CKPRE','TOKO','PER','100.00','4.280','4.280','1','4.280','4.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-15-913 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-37-0','00040974','700K-14-914 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','254500','2026-01-16','254500','4.240','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:48:18','4.240','0','','16950.00','','TOKO','FREETAG','','2','','','','2','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-37-0','00040974');
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-16','CKPRE-ZAAF-37-0','CKPRE','TOKO','PER','100.00','4.240','4.240','1','4.240','4.240','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-14-914 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-38-0','00040975','700K-15-915 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','249500','2026-01-16','249500','4.150','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:48:35','4.150','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-38-0','00040975');
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-16','CKPRE-ZAAF-38-0','CKPRE','TOKO','PER','100.00','4.150','4.150','1','4.150','4.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-15-915 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-39-0','00040976','700K-16-916 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','256000','2026-01-16','256000','4.260','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:48:52','4.260','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-39-0','00040976');
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-16','CKPRE-ZAAF-39-0','CKPRE','TOKO','PER','100.00','4.260','4.260','1','4.260','4.260','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-16-916 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-40-0','00040977','700K-17-917 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','280000','2026-01-16','280000','4.660','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:49:12','4.660','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-40-0','00040977');
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-16','CKPRE-ZAAF-40-0','CKPRE','TOKO','PER','100.00','4.660','4.660','1','4.660','4.660','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-17-917 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-41-0','00040978','500K-19-918 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','116500','2026-01-16','116500','1.940','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:49:37','1.940','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-41-0','00040978');
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-16','CKPRE-ZAAF-41-0','CKPRE','TOKO','PER','100.00','1.940','1.940','1','1.940','1.940','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','500K-19-918 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-42-0','00040979','700K-17-919 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','121000','2026-01-16','121000','2.010','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:49:55','2.010','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-42-0','00040979');
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-16','CKPRE-ZAAF-42-0','CKPRE','TOKO','PER','100.00','2.010','2.010','1','2.010','2.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-17-919 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-43-0','00040980','700K-19-920 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','128500','2026-01-16','128500','2.140','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:50:14','2.140','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-43-0','00040980');
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-16','CKPRE-ZAAF-43-0','CKPRE','TOKO','PER','100.00','2.140','2.140','1','2.140','2.140','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-19-920 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-44-0','00040981','700K-22-921 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','128000','2026-01-16','128000','2.130','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:50:33','2.130','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-44-0','00040981');
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-16','CKPRE-ZAAF-44-0','CKPRE','TOKO','PER','100.00','2.130','2.130','1','2.130','2.130','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-22-921 ');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPRE-ZAAF-45-0','00040982','700K-20-922 ','CINCIN SILVER 925 ','','GR','---','PER','CKPRE','TOKO','PER','130000','2026-01-16','130000','2.160','100.00','925','150000','60000.00','1','0.04', 'input','2026-01-16 16:50:52','2.160','0','','16950.00','','TOKO','FREETAG','','2','','','','1','','','');
DELETE FROM tp_barang WHERE kode_dept = 'CKPRE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPRE','CKPRE-ZAAF-45-0','00040982');
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-16','CKPRE-ZAAF-45-0','CKPRE','TOKO','PER','100.00','2.160','2.160','1','2.160','2.160','1');
DELETE FROM tp_kode_intern WHERE kode_dept='CKPRE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPRE','700K-20-922 ');
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-42-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CKPRE-ZAAF-42-0','00040979','00040979','CINCIN SILVER 925 ','CINCIN SILVER 925','','','121000','121000',' 150000','150000','input','2026-01-16 16:51:28');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='500K-17-919 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='CKPRE-ZAAF-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-43-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CKPRE-ZAAF-43-0','00040980','00040980','CINCIN SILVER 925 ','CINCIN SILVER 925','','','128500','128500',' 150000','150000','input','2026-01-16 16:51:38');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='500K-19-920 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='CKPRE-ZAAF-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-44-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CKPRE-ZAAF-44-0','00040981','00040981','CINCIN SILVER 925 ','CINCIN SILVER 925','','','128000','128000',' 150000','150000','input','2026-01-16 16:51:45');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='500K-22-921 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='CKPRE-ZAAF-44-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-45-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('CKPRE-ZAAF-45-0','00040982','00040982','CINCIN SILVER 925 ','CINCIN SILVER 925','','','130000','130000',' 150000','150000','input','2026-01-16 16:51:51');
UPDATE tm_barang SET nama_barang='CINCIN SILVER 925' ,nama_atribut='' ,kode_intern='500K-20-922 ', kadar_cetak='925.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='CKPRE-ZAAF-45-0' LIMIT 1;
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0005','1','CBRE-ZAAF-35-0','1','3.400','TOKO','CBRE');
DELETE FROM tm_barang_export WHERE kode_barang='CBRE-ZAAF-35-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CBRE-ZAAF-35-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CBRE-ZAAF-35-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CBRE-ZAAF-35-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='DM' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='DM' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CBRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CBRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CBRE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CBRE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CBRE-ZAAF-35-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.400',berat_out_asli='3.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.400',berat_akhir_asli =berat_akhir_asli-'3.400' WHERE kode_barang='CBRE-ZAAF-35-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260116-0005','2026-01-16','2026-01-16','16:56','3.400','input','2026-01-16 16:56:00','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','1','CKPRE-ZAAF-36-0','1','4.280','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-36-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-36-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-36-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-36-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-36-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.280',berat_out_asli='4.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.280',berat_akhir_asli =berat_akhir_asli-'4.280' WHERE kode_barang='CKPRE-ZAAF-36-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','2','CKPRE-ZAAF-37-0','1','4.240','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-37-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-37-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-37-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-37-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-37-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.240',berat_out_asli='4.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.240',berat_akhir_asli =berat_akhir_asli-'4.240' WHERE kode_barang='CKPRE-ZAAF-37-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','3','CKPRE-ZAAF-38-0','1','4.150','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-38-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-38-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-38-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-38-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-38-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.150',berat_out_asli='4.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.150',berat_akhir_asli =berat_akhir_asli-'4.150' WHERE kode_barang='CKPRE-ZAAF-38-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','4','CKPRE-ZAAF-39-0','1','4.260','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-39-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-39-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-39-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-39-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-39-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.260',berat_out_asli='4.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.260',berat_akhir_asli =berat_akhir_asli-'4.260' WHERE kode_barang='CKPRE-ZAAF-39-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','5','CKPRE-ZAAF-40-0','1','4.660','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-40-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-40-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-40-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-40-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-40-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.660',berat_out_asli='4.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.660',berat_akhir_asli =berat_akhir_asli-'4.660' WHERE kode_barang='CKPRE-ZAAF-40-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','6','CKPRE-ZAAF-41-0','1','1.940','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-41-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-41-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-41-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-41-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-41-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.940',berat_out_asli='1.940', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.940',berat_akhir_asli =berat_akhir_asli-'1.940' WHERE kode_barang='CKPRE-ZAAF-41-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','7','CKPRE-ZAAF-42-0','1','2.010','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-42-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-42-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-42-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-42-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-42-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.010' WHERE kode_barang='CKPRE-ZAAF-42-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','8','CKPRE-ZAAF-43-0','1','2.140','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-43-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-43-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-43-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-43-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-43-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.140',berat_out_asli='2.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.140',berat_akhir_asli =berat_akhir_asli-'2.140' WHERE kode_barang='CKPRE-ZAAF-43-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','9','CKPRE-ZAAF-44-0','1','2.130','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-44-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-44-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-44-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-44-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-44-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.130',berat_out_asli='2.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.130',berat_akhir_asli =berat_akhir_asli-'2.130' WHERE kode_barang='CKPRE-ZAAF-44-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0006','10','CKPRE-ZAAF-45-0','1','2.160','TOKO','PER');
DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZAAF-45-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZAAF-45-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZAAF-45-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZAAF-45-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZAAF-45-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.160',berat_out_asli='2.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.160',berat_akhir_asli =berat_akhir_asli-'2.160' WHERE kode_barang='CKPRE-ZAAF-45-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260116-0006','2026-01-16','2026-01-16','16:56','2.160','input','2026-01-16 16:56:12','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','1','LMT5-ZAAF-22-0','1','5.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT5-ZAAF-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT5-ZAAF-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT5-ZAAF-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT5-ZAAF-22-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT5' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT5' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT5-ZAAF-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LMT5-ZAAF-22-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','2','LMT5-ZAAF-23-0','1','5.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT5-ZAAF-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT5-ZAAF-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT5-ZAAF-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT5-ZAAF-23-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT5' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT5' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT5-ZAAF-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LMT5-ZAAF-23-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','3','LMT5-ZAAF-24-0','1','5.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT5-ZAAF-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT5-ZAAF-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT5-ZAAF-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT5-ZAAF-24-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT5' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT5' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT5-ZAAF-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LMT5-ZAAF-24-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','4','LMT5-ZAAF-25-0','1','5.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT5-ZAAF-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT5-ZAAF-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT5-ZAAF-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT5-ZAAF-25-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT5' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT5' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT5-ZAAF-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LMT5-ZAAF-25-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','5','LMT5-ZAAF-26-0','1','5.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT5-ZAAF-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT5-ZAAF-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT5-ZAAF-26-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT5-ZAAF-26-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT5' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT5' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT5-ZAAF-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.000',berat_out_asli='5.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.000',berat_akhir_asli =berat_akhir_asli-'5.000' WHERE kode_barang='LMT5-ZAAF-26-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','6','LMT1-ZAAF-27-0','1','1.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZAAF-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT1-ZAAF-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT1-ZAAF-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT1-ZAAF-27-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT1-ZAAF-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='LMT1-ZAAF-27-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','7','LMT1-ZAAF-28-0','1','1.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZAAF-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT1-ZAAF-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT1-ZAAF-28-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT1-ZAAF-28-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT1-ZAAF-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='LMT1-ZAAF-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','8','LMT1-ZAAF-29-0','1','1.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZAAF-29-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT1-ZAAF-29-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT1-ZAAF-29-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT1-ZAAF-29-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT1-ZAAF-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='LMT1-ZAAF-29-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','9','LMT1-ZAAF-30-0','1','1.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZAAF-30-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT1-ZAAF-30-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT1-ZAAF-30-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT1-ZAAF-30-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT1-ZAAF-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='LMT1-ZAAF-30-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260116-0007','10','LMT1-ZAAF-31-0','1','1.000','TOKO','LMT');
DELETE FROM tm_barang_export WHERE kode_barang='LMT1-ZAAF-31-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LMT1-ZAAF-31-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='LMT1-ZAAF-31-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LMT1-ZAAF-31-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LMT1' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LMT1' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='LMT';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='LMT';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LMT1-ZAAF-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.000',berat_out_asli='1.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.000',berat_akhir_asli =berat_akhir_asli-'1.000' WHERE kode_barang='LMT1-ZAAF-31-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260116-0007','2026-01-16','2026-01-16','16:56','1.000','input','2026-01-16 16:56:26','THIFA');