INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-19 ','08:27:54');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-06-19 ','16:17:57');
UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='';
UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='';
UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-03035';
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 ('PSGE-ZFAI-1-0','00044589','DP-03035 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','5748500','2026-06-19','5748500','2.850','83.00','75','580000','2430000.00','1','0.04', 'input','2026-06-19 16:24:01','2.850','0','','18100.00','','TOKO','FREETAG','','2','','','PSN03035','1','RS 8','','DP-03035');
DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-ZFAI-1-0','00044589');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSGE-ZFAI-1-0','PSGE','TOKO','PSN','83.00','2.850','2.850','1','2.850','2.850','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-03035 ');
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-02325';
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-ZFAI-2-0','00044590','DP-02325BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','463500','2026-06-19','463500','2.270','17.00','10','480000','1200000.00','1','0.14', 'input','2026-06-19 16:26:01','2.270','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02325BIP','1','RS 11','','DP-02325');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-2-0','00044590');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-2-0','PSPLT','TOKO','PSNB','17.00','2.270','2.270','1','2.270','2.270','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02325BIP ');
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-02491';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-3-0','00044591','DP-02491BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','277000','2026-06-19','277000','2.770','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-19 16:27:35','2.770','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02491BIP','1','RS 26','','DP-02491');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-3-0','00044591');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-3-0','PSPRT','TOKO','PSNB','100.00','2.770','2.770','1','2.770','2.770','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02491BIP ');
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-02504';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-4-0','00044592','DP-02504BIP ','CINCIN PERAK YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','317000','2026-06-19','317000','3.170','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-19 16:29:51','3.170','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02504BIP','1','RS 11 RS 23','','DP-02504');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-4-0','00044592');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-4-0','PSPRT','TOKO','PSNB','100.00','3.170','3.170','1','3.170','3.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02504BIP ');
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-02331';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-5-0','00044593','DP-02331DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','248000','2026-06-19','248000','2.480','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-19 16:32:07','2.480','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02331DU','1','RS 13','','DP-02331');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-5-0','00044593');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-5-0','PSPRT','TOKO','DUPSN','100.00','2.480','2.480','1','2.480','2.480','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02331DU ');
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-02332';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-6-0','00044594','DP-02332DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','265000','2026-06-19','265000','2.650','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-19 16:33:33','2.650','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02332DU','1','RS 14 5','','DP-02332');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-6-0','00044594');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-6-0','PSPRT','TOKO','DUPSN','100.00','2.650','2.650','1','2.650','2.650','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02332DU ');
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-02411';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-7-0','00044595','DP-02411DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','158000','2026-06-19','158000','1.580','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-19 16:35:11','1.580','','','18100.00','','TOKO','FREETAG','','2','','','PSN02411DU','1','RS 10','','DP-02411');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-7-0','00044595');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-7-0','PSPRT','TOKO','DUPSN','100.00','1.580','1.580','1','1.580','1.580','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02411DU ');
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-02412';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-8-0','00044596','DP-02412DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','451000','2026-06-19','451000','4.510','100.00','925','200000','100000.00','1','0.14', 'input','2026-06-19 16:36:29','4.510','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02412DU','1','RS 17','','DP-02412');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-8-0','00044596');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-8-0','PSPRT','TOKO','DUPSN','100.00','4.510','4.510','1','4.510','4.510','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02412DU ');
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-02498';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-9-0','00044597','DP-02498DU ','CINCIN PERAK SR-04 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','315000','2026-06-19','315000','3.150','100.00','925','410000','100000.00','1','0.14', 'input','2026-06-19 16:38:10','3.150','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02498DU','1','RS 11 RS 21 5','','DP-02498');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-9-0','00044597');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-9-0','PSPRT','TOKO','DUPSN','100.00','3.150','3.150','1','3.150','3.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02498DU ');
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-02242';
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-ZFAI-10-0','00044598','DP-02242SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1774500','2026-06-19','1774500','4.620','32.00','25','250000','1200000.00','1','0.014', 'input','2026-06-19 16:45:49','4.620','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02242SBY','1','RS 25 5','','DP-02242');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-10-0','00044598');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-10-0','PSPLT','TOKO','SBYPSN','32.00','4.620','4.620','1','4.620','4.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02242SBY ');
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-02296';
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-ZFAI-11-0','00044599','DP-02296SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','710000','2026-06-19','710000','3.480','17.00','10','250000','1200000.00','1','0.014', 'input','2026-06-19 16:47:23','3.480','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02296SBY','1','RS 28 5','','DP-02296');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-11-0','00044599');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-11-0','PSPLT','TOKO','SBYPSN','17.00','3.480','3.480','1','3.480','3.480','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02296SBY ');
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-02315';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-12-0','00044600','DP-02315SBY ','CINCIN PERAK SR-04 ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','336000','2026-06-19','336000','3.360','100.00','925','420000','100000.00','1','0.014', 'input','2026-06-19 16:49:53','3.360','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02315SBY','1','RS 14 RS 17','','DP-02315');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-12-0','00044600');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-12-0','PSPRT','TOKO','SBYPSN','100.00','3.360','3.360','1','3.360','3.360','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02315SBY ');
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-02336';
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-ZFAI-13-0','00044601','DP-02336SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','494000','2026-06-19','494000','2.420','17.00','10','250000','1200000.00','1','0.014', 'input','2026-06-19 16:51:29','2.420','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02336SBY','1','RS 18','','DP-02336');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-13-0','00044601');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-13-0','PSPLT','TOKO','SBYPSN','17.00','2.420','2.420','1','2.420','2.420','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02336SBY ');
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-02418';
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-ZFAI-14-0','00044602','DP-02418BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','353000','2026-06-19','353000','1.730','17.00','10','340000','1200000.00','1','0.14', 'input','2026-06-19 17:04:21','1.730','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02418BIP','1','RS 10 5','','DP-02418');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-14-0','00044602');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-14-0','PSPLT','TOKO','PSNB','17.00','1.730','1.730','1','1.730','1.730','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02418BIP ');
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-02391';
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-ZFAI-15-0','00044603','DP-02391BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','630500','2026-06-19','630500','3.090','17.00','10','260000','1200000.00','1','0.14', 'input','2026-06-19 17:05:50','3.090','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02391BIP','1','RS 17','','DP-02391');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-15-0','00044603');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-15-0','PSPLT','TOKO','PSNB','17.00','3.090','3.090','1','3.090','3.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02391BIP ');
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-02392';
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-ZFAI-16-0','00044604','DP-02392BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','649000','2026-06-19','649000','3.180','17.00','10','260000','1200000.00','1','0.14', 'input','2026-06-19 17:07:16','3.180','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02392BIP','1','RS 18','','DP-02392');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-16-0','00044604');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-16-0','PSPLT','TOKO','PSNB','17.00','3.180','3.180','1','3.180','3.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02392BIP ');
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-02470';
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-ZFAI-17-0','00044605','DP-02470BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','655000','2026-06-19','655000','3.210','17.00','10','260000','1200000.00','1','0.14', 'input','2026-06-19 17:08:42','3.210','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02470BIP','1','RS 24','','DP-02470');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-17-0','00044605');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-17-0','PSPLT','TOKO','PSNB','17.00','3.210','3.210','1','3.210','3.210','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02470BIP ');
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-02382';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-18-0','00044606','DP-02382BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','244000','2026-06-19','244000','2.440','100.00','925','210000','100000.00','1','0.14', 'input','2026-06-19 17:10:11','2.440','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02382BIP','1','RS 28','','DP-02382');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-18-0','00044606');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-18-0','PSPRT','TOKO','PSNB','100.00','2.440','2.440','1','2.440','2.440','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02382BIP ');
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-02381';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-19-0','00044607','DP-02381BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','149000','2026-06-19','149000','1.490','100.00','925','300000','100000.00','1','0.14', 'input','2026-06-19 17:11:29','1.490','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02381BIP','1','RS 15 5','','DP-02381');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-19-0','00044607');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-19-0','PSPRT','TOKO','PSNB','100.00','1.490','1.490','1','1.490','1.490','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02381BIP ');
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-02318';
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-ZFAI-20-0','00044608','DP-02318DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','465500','2026-06-19','465500','2.280','17.00','10','340000','1200000.00','1','0.14', 'input','2026-06-19 17:20:12','2.280','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02318DU','1','RS 9','','DP-02318');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-20-0','00044608');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-20-0','PSPLT','TOKO','DUPSN','17.00','2.280','2.280','1','2.280','2.280','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02318DU ');
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-02517';
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-ZFAI-21-0','00044609','DP-02517DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','1336500','2026-06-19','1336500','3.480','32.00','25','250000','1200000.00','1','0.14', 'input','2026-06-19 17:21:41','3.480','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02517DU','1','RS 21 5','','DP-02517');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-21-0','00044609');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-21-0','PSPLT','TOKO','DUPSN','32.00','3.480','3.480','1','3.480','3.480','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02517DU ');
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-02298';
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-ZFAI-22-0','00044610','DP-02298SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','853000','2026-06-19','853000','4.180','17.00','10','280000','1200000.00','1','0.014', 'input','2026-06-19 17:23:32','4.180','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02298SBY','1','RS 17','','DP-02298');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZFAI-22-0','00044610');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPLT-ZFAI-22-0','PSPLT','TOKO','SBYPSN','17.00','4.180','4.180','1','4.180','4.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02298SBY ');
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-02324';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-23-0','00044611','DP-02324SBY ','CINCIN PERAK YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','393000','2026-06-19','393000','3.930','100.00','925','200000','100000.00','1','0.014', 'input','2026-06-19 17:25:13','3.930','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02324SBY','1','RS 22','','DP-02324');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-23-0','00044611');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-23-0','PSPRT','TOKO','SBYPSN','100.00','3.930','3.930','1','3.930','3.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02324SBY ');
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-02364';
INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRT-ZFAI-24-0','00044612','DP-02364SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','223000','2026-06-19','223000','2.230','100.00','925','200000','100000.00','1','0.014', 'input','2026-06-19 17:27:50','2.230','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02364SBY','1','RS 17 5','','DP-02364');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZFAI-24-0','00044612');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSPRT-ZFAI-24-0','PSPRT','TOKO','SBYPSN','100.00','2.230','2.230','1','2.230','2.230','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02364SBY ');
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-02335';
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 ('PSGT-ZFAI-25-0','00044613','DP-02335SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','4079000','2026-06-19','4079000','3.730','45.00','375','550000','2430000.00','1','0.014', 'input','2026-06-19 17:30:55','3.730','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02335SBY','1','RS 18','','DP-02335');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZFAI-25-0','00044613');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','PSGT-ZFAI-25-0','PSGT','TOKO','SBYPSN','45.00','3.730','3.730','1','3.730','3.730','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02335SBY ');
UPDATE tp_curr SET rp= '17800.00' WHERE curr = 'USD' LIMIT 1;
INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '17800.00', 'input','2026-06-19 17:36:58');
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2540500',harga_beli ='2540500' WHERE kode_barcode='00001136' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5146000',harga_beli ='5146000' WHERE kode_barcode='00001394' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='200500',harga_beli ='200500' WHERE kode_barcode='00001984' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2911500',harga_beli ='2911500' WHERE kode_barcode='00002031' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6445500',harga_beli ='6445500' WHERE kode_barcode='00002094' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2414500',harga_beli ='2414500' WHERE kode_barcode='00003287' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2309500',harga_beli ='2309500' WHERE kode_barcode='00003288' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2351500',harga_beli ='2351500' WHERE kode_barcode='00003289' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5606000',harga_beli ='5606000' WHERE kode_barcode='00003290' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='20701500',harga_beli ='20701500' WHERE kode_barcode='00003291' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2880500',harga_beli ='2880500' WHERE kode_barcode='00005675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2854000',harga_beli ='2854000' WHERE kode_barcode='00005680' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2697000',harga_beli ='2697000' WHERE kode_barcode='00005686' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2801500',harga_beli ='2801500' WHERE kode_barcode='00005694' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2775500',harga_beli ='2775500' WHERE kode_barcode='00005695' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7790500',harga_beli ='7790500' WHERE kode_barcode='00006371' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2983000',harga_beli ='2983000' WHERE kode_barcode='00007446' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10685500',harga_beli ='10685500' WHERE kode_barcode='00007503' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3854500',harga_beli ='3854500' WHERE kode_barcode='00014815' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4531000',harga_beli ='4531000' WHERE kode_barcode='00015245' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4654000',harga_beli ='4654000' WHERE kode_barcode='00015248' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5474000',harga_beli ='5474000' WHERE kode_barcode='00016090' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4428500',harga_beli ='4428500' WHERE kode_barcode='00016091' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6335000',harga_beli ='6335000' WHERE kode_barcode='00019597' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7565000',harga_beli ='7565000' WHERE kode_barcode='00019598' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9123000',harga_beli ='9123000' WHERE kode_barcode='00019599' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7380500',harga_beli ='7380500' WHERE kode_barcode='00020277' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1538000',harga_beli ='1538000' WHERE kode_barcode='00020571' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2850000',harga_beli ='2850000' WHERE kode_barcode='00023554' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4346500',harga_beli ='4346500' WHERE kode_barcode='00023557' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3936500',harga_beli ='3936500' WHERE kode_barcode='00023558' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2255500',harga_beli ='2255500' WHERE kode_barcode='00023559' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2173500',harga_beli ='2173500' WHERE kode_barcode='00023560' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6663000',harga_beli ='6663000' WHERE kode_barcode='00023561' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7995500',harga_beli ='7995500' WHERE kode_barcode='00023565' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3567500',harga_beli ='3567500' WHERE kode_barcode='00023566' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7073000',harga_beli ='7073000' WHERE kode_barcode='00023567' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5617500',harga_beli ='5617500' WHERE kode_barcode='00023569' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2727000',harga_beli ='2727000' WHERE kode_barcode='00023577' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='2317000',harga_beli ='2317000' WHERE kode_barcode='00023578' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='00023579' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3690500',harga_beli ='3690500' WHERE kode_barcode='00023581' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5470000',harga_beli ='5470000' WHERE kode_barcode='00023587' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7052500',harga_beli ='7052500' WHERE kode_barcode='00023669' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10681500',harga_beli ='10681500' WHERE kode_barcode='00023670' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9635500',harga_beli ='9635500' WHERE kode_barcode='00023671' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3526500',harga_beli ='3526500' WHERE kode_barcode='00023673' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5494500',harga_beli ='5494500' WHERE kode_barcode='00023675' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7667500',harga_beli ='7667500' WHERE kode_barcode='00023677' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6991000',harga_beli ='6991000' WHERE kode_barcode='00023678' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7196000',harga_beli ='7196000' WHERE kode_barcode='00023696' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8262000',harga_beli ='8262000' WHERE kode_barcode='00023698' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='16483000',harga_beli ='16483000' WHERE kode_barcode='00023884' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1681500',harga_beli ='1681500' WHERE kode_barcode='00023899' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1681500',harga_beli ='1681500' WHERE kode_barcode='00023900' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1599500',harga_beli ='1599500' WHERE kode_barcode='00023902' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='1538000',harga_beli ='1538000' WHERE kode_barcode='00023903' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5084500',harga_beli ='5084500' WHERE kode_barcode='00023909' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8733500',harga_beli ='8733500' WHERE kode_barcode='00023910' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='9984500',harga_beli ='9984500' WHERE kode_barcode='00023911' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8487500',harga_beli ='8487500' WHERE kode_barcode='00023963' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7954500',harga_beli ='7954500' WHERE kode_barcode='00024003' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8713000',harga_beli ='8713000' WHERE kode_barcode='00024088' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7770000',harga_beli ='7770000' WHERE kode_barcode='00024116' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4633500',harga_beli ='4633500' WHERE kode_barcode='00024117' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='55619500',harga_beli ='55619500' WHERE kode_barcode='00024185' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='8651500',harga_beli ='8651500' WHERE kode_barcode='00024187' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7995500',harga_beli ='7995500' WHERE kode_barcode='00024190' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5925000',harga_beli ='5925000' WHERE kode_barcode='00024191' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11378500',harga_beli ='11378500' WHERE kode_barcode='00024259' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13204000',harga_beli ='13204000' WHERE kode_barcode='00024357' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='7585500',harga_beli ='7585500' WHERE kode_barcode='00024362' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6130000',harga_beli ='6130000' WHERE kode_barcode='00025021' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6724500',harga_beli ='6724500' WHERE kode_barcode='00026264' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5269000',harga_beli ='5269000' WHERE kode_barcode='00026265' LIMIT 1;
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'DM' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('DM','2470000','input','2026-06-19 17:37:08');
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='17321000',harga_beli ='17321000' WHERE kode_barcode='00001173' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='10162000',harga_beli ='10162000' WHERE kode_barcode='00001223' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5354000',harga_beli ='5354000' WHERE kode_barcode='00001224' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5396000',harga_beli ='5396000' WHERE kode_barcode='00001225' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6261500',harga_beli ='6261500' WHERE kode_barcode='00002442' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4753000',harga_beli ='4753000' WHERE kode_barcode='00004222' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='11804500',harga_beli ='11804500' WHERE kode_barcode='00006106' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3623500',harga_beli ='3623500' WHERE kode_barcode='00006485' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='13585000',harga_beli ='13585000' WHERE kode_barcode='00034435' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='6458000',harga_beli ='6458000' WHERE kode_barcode='00038144' LIMIT 1;
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'GOLD' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('GOLD','2470000','input','2026-06-19 17:37:14');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSBRE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRE','2470000','input','2026-06-19 17:37:18');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSBRL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRL','2470000','input','2026-06-19 17:37:21');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSBRT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSBRT','2470000','input','2026-06-19 17:37:24');
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='5843000',harga_beli ='5843000' WHERE kode_barcode='00044589' LIMIT 1;
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSGE' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGE','2470000','input','2026-06-19 17:37:28');
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSGL' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGL','2470000','input','2026-06-19 17:37:32');
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='3731500',harga_beli ='3731500' WHERE kode_barcode='00033486' LIMIT 1;
UPDATE tm_barang SET harga_skrg ='2470000',harga_jual='4146000',harga_beli ='4146000' WHERE kode_barcode='00044613' LIMIT 1;
UPDATE tm_group SET harga='2470000' WHERE kode_group = 'PSGT' LIMIT 1;
INSERT INTO th_troy(kode_group,harga_skrg,input_by,input_date) VALUES ('PSGT','2470000','input','2026-06-19 17:37:35');
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 ('KLBE-ZFAI-26-0','00044614','KLBE-00870 ','KALUNG KLBE-00870 ','','GR','---','DM','KLBE','TOKO','KLBE','28554500','2026-06-19','28554500','11.010','105.00','75','0','2470000.00','1','0.04', 'input','2026-06-19 17:46:28','11.010','570000','1174.50','17800.00','','TOKO','FREETAG','','10','','','IDR 187 500 000','1','0626','','');
DELETE FROM tp_barang WHERE kode_dept = 'KLBE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('KLBE','KLBE-ZFAI-26-0','00044614');
INSERT INTO tt_barang_saldo(tanggal,kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_tambah,berat_tambah_asli,stock_tambah,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-06-19','KLBE-ZFAI-26-0','KLBE','TOKO','KLBE','105.00','11.010','11.010','1','11.010','11.010','1');
DELETE FROM tp_kode_intern WHERE kode_dept='KLBE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('KLBE','KLBE-00870 ');
INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('KLBE-ZFAI-26-0','00044614','RD','57','2.610 ','450','1174.5');
DELETE FROM tm_berlian WHERE kode_barang='PSGT-ZFAI-25-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 ('PSGT-ZFAI-25-0','00044613','00044613','CINCIN EMAS ','CINCIN EMAS','','','4146000','4146000',' 550000','550000','input','2026-06-19 17:49:36');
UPDATE tm_barang SET nama_barang='CINCIN EMAS' ,nama_atribut='' ,kode_intern='DP-02335SBY ', kadar_cetak='375.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 18',total_usd_ext='PSN02335SBY',total_usd='0' WHERE kode_barang='PSGT-ZFAI-25-0' LIMIT 1;
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0004','1','PSGE-ZFAI-1-0','1','2.850','TOKO','PSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGE-ZFAI-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGE-ZFAI-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGE-ZFAI-1-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGE-ZFAI-1-0';
DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSGE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSGE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGE-ZFAI-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.850',berat_out_asli='2.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.850',berat_akhir_asli =berat_akhir_asli-'2.850' WHERE kode_barang='PSGE-ZFAI-1-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-260619-0004','2026-06-19','2026-06-19','17:50','2.850','input','2026-06-19 17:50:18','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0005','1','KLBE-ZFAI-26-0','1','11.010','TOKO','KLBE');
DELETE FROM tm_barang_export WHERE kode_barang='KLBE-ZFAI-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='KLBE-ZFAI-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='KLBE-ZFAI-26-0';
INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='KLBE-ZFAI-26-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='KLBE' LIMIT 1;
INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='KLBE' LIMIT 1;
DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='KLBE';
INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='KLBE';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='KLBE-ZFAI-26-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='11.010',berat_out_asli='11.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'11.010',berat_akhir_asli =berat_akhir_asli-'11.010' WHERE kode_barang='KLBE-ZFAI-26-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-260619-0005','2026-06-19','2026-06-19','17:50','11.010','input','2026-06-19 17:50:27','ELCO');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0006','1','PSPRT-ZFAI-5-0','1','2.480','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-5-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='DUPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZFAI-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.480',berat_out_asli='2.480', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.480',berat_akhir_asli =berat_akhir_asli-'2.480' WHERE kode_barang='PSPRT-ZFAI-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-260619-0006','2','PSPRT-ZFAI-6-0','1','2.650','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-6-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='DUPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZFAI-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.650',berat_out_asli='2.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.650',berat_akhir_asli =berat_akhir_asli-'2.650' WHERE kode_barang='PSPRT-ZFAI-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-260619-0006','3','PSPRT-ZFAI-7-0','1','1.580','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-7-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='DUPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZFAI-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.580',berat_out_asli='1.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.580',berat_akhir_asli =berat_akhir_asli-'1.580' WHERE kode_barang='PSPRT-ZFAI-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-260619-0006','4','PSPRT-ZFAI-8-0','1','4.510','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-8-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='DUPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZFAI-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.510',berat_out_asli='4.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.510',berat_akhir_asli =berat_akhir_asli-'4.510' WHERE kode_barang='PSPRT-ZFAI-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-260619-0006','5','PSPRT-ZFAI-9-0','1','3.150','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-9-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='DUPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZFAI-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.150',berat_out_asli='3.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.150',berat_akhir_asli =berat_akhir_asli-'3.150' WHERE kode_barang='PSPRT-ZFAI-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-260619-0006','6','PSPLT-ZFAI-20-0','1','2.280','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-20-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='DUPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZFAI-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.280',berat_out_asli='2.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.280',berat_akhir_asli =berat_akhir_asli-'2.280' WHERE kode_barang='PSPLT-ZFAI-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-260619-0006','7','PSPLT-ZFAI-21-0','1','3.480','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-21-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='DUPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZFAI-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.480',berat_out_asli='3.480', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.480',berat_akhir_asli =berat_akhir_asli-'3.480' WHERE kode_barang='PSPLT-ZFAI-21-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-260619-0006','2026-06-19','2026-06-19','17:50','3.480','input','2026-06-19 17:50:37','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0007','1','PSPLT-ZFAI-2-0','1','2.270','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-2-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-ZFAI-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.270',berat_out_asli='2.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.270',berat_akhir_asli =berat_akhir_asli-'2.270' WHERE kode_barang='PSPLT-ZFAI-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-260619-0007','2','PSPRT-ZFAI-3-0','1','2.770','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-3-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='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='PSPRT-ZFAI-3-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='PSPRT-ZFAI-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-260619-0007','3','PSPRT-ZFAI-4-0','1','3.170','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-4-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='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='PSPRT-ZFAI-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.170',berat_out_asli='3.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.170',berat_akhir_asli =berat_akhir_asli-'3.170' WHERE kode_barang='PSPRT-ZFAI-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-260619-0007','4','PSPLT-ZFAI-14-0','1','1.730','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-14-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-ZFAI-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.730',berat_out_asli='1.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.730',berat_akhir_asli =berat_akhir_asli-'1.730' WHERE kode_barang='PSPLT-ZFAI-14-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0007','5','PSPLT-ZFAI-15-0','1','3.090','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-15-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-ZFAI-15-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='PSPLT-ZFAI-15-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0007','6','PSPLT-ZFAI-16-0','1','3.180','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-16-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-ZFAI-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.180',berat_out_asli='3.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.180',berat_akhir_asli =berat_akhir_asli-'3.180' WHERE kode_barang='PSPLT-ZFAI-16-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0007','7','PSPLT-ZFAI-17-0','1','3.210','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-17-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-17-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-17-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-17-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-ZFAI-17-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.210',berat_out_asli='3.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.210',berat_akhir_asli =berat_akhir_asli-'3.210' WHERE kode_barang='PSPLT-ZFAI-17-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0007','8','PSPRT-ZFAI-18-0','1','2.440','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-18-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-18-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-18-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-18-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='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='PSPRT-ZFAI-18-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.440',berat_out_asli='2.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.440',berat_akhir_asli =berat_akhir_asli-'2.440' WHERE kode_barang='PSPRT-ZFAI-18-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0007','9','PSPRT-ZFAI-19-0','1','1.490','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-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='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='PSPRT-ZFAI-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.490',berat_out_asli='1.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.490',berat_akhir_asli =berat_akhir_asli-'1.490' WHERE kode_barang='PSPRT-ZFAI-19-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-260619-0007','2026-06-19','2026-06-19','17:50','1.490','input','2026-06-19 17:50:49','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0008','1','PSPLT-ZFAI-10-0','1','4.620','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-10-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZFAI-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.620',berat_out_asli='4.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.620',berat_akhir_asli =berat_akhir_asli-'4.620' WHERE kode_barang='PSPLT-ZFAI-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-260619-0008','2','PSPLT-ZFAI-11-0','1','3.480','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-11-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZFAI-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.480',berat_out_asli='3.480', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.480',berat_akhir_asli =berat_akhir_asli-'3.480' WHERE kode_barang='PSPLT-ZFAI-11-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0008','3','PSPRT-ZFAI-12-0','1','3.360','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-12-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZFAI-12-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-ZFAI-12-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0008','4','PSPLT-ZFAI-13-0','1','2.420','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-13-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZFAI-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.420',berat_out_asli='2.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.420',berat_akhir_asli =berat_akhir_asli-'2.420' WHERE kode_barang='PSPLT-ZFAI-13-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260619-0008','5','PSPLT-ZFAI-22-0','1','4.180','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZFAI-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZFAI-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZFAI-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZFAI-22-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZFAI-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.180',berat_out_asli='4.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.180',berat_akhir_asli =berat_akhir_asli-'4.180' WHERE kode_barang='PSPLT-ZFAI-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-260619-0008','6','PSPRT-ZFAI-23-0','1','3.930','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-23-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZFAI-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.930',berat_out_asli='3.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.930',berat_akhir_asli =berat_akhir_asli-'3.930' WHERE kode_barang='PSPRT-ZFAI-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-260619-0008','7','PSPRT-ZFAI-24-0','1','2.230','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZFAI-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZFAI-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZFAI-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZFAI-24-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZFAI-24-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='PSPRT-ZFAI-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-260619-0008','8','PSGT-ZFAI-25-0','1','3.730','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZFAI-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZFAI-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZFAI-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZFAI-25-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='SBYPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZFAI-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.730',berat_out_asli='3.730', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.730',berat_akhir_asli =berat_akhir_asli-'3.730' WHERE kode_barang='PSGT-ZFAI-25-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-260619-0008','2026-06-19','2026-06-19','17:51','3.730','input','2026-06-19 17:51:03','THIFA');