INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-01 ','08:09:04');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-01','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-05-31';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-06-30';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-06-30';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-06-30' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-06-30';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-06-30';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-06-30';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-06-30';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202605 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-05';
UPDATE tt_barang_saldo SET tanggal= '2026-07-01' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-06-30' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
UPDATE tp_system SET tgl_system='2026-07-01';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-01 ','08:09:36');
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-02448';
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-ZGXA-1-0','00044861','DP-02448MM ','CINCIN PALADIUM YL-10 ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','3543500','2026-07-01','3543500','5.180','57.00','50','250000','1200000.00','1','0.14', 'input','2026-07-01 08:21:33','5.180','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02448MM','1','RS 24','','DP-02448');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-1-0','00044861');
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-07-01','PSPLT-ZGXA-1-0','PSPLT','TOKO','MMPSN','57.00','5.180','5.180','1','5.180','5.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02448MM ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0001','1','PMM-ZFCX-6-0','1','2.100','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-6-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.100',berat_out_asli='2.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.100',berat_akhir_asli =berat_akhir_asli-'2.100' WHERE kode_barang='PMM-ZFCX-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-260701-0001','2','PMM-ZFCX-7-0','1','3.500','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-7-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.500',berat_out_asli='3.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.500',berat_akhir_asli =berat_akhir_asli-'3.500' WHERE kode_barang='PMM-ZFCX-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-260701-0001','3','PMM-ZFCX-8-0','1','2.230','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-8-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-8-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='PMM-ZFCX-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-260701-0001','4','PMM-ZFCX-9-0','1','3.090','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-9-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-9-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='PMM-ZFCX-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-260701-0001','5','PMM-ZFCX-10-0','1','1.530','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-10-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.530',berat_out_asli='1.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.530',berat_akhir_asli =berat_akhir_asli-'1.530' WHERE kode_barang='PMM-ZFCX-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-260701-0001','6','PMM-ZFCX-11-0','1','2.210','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-11-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.210',berat_out_asli='2.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.210',berat_akhir_asli =berat_akhir_asli-'2.210' WHERE kode_barang='PMM-ZFCX-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-260701-0001','7','PMM-ZFCX-12-0','1','2.370','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.370',berat_out_asli='2.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.370',berat_akhir_asli =berat_akhir_asli-'2.370' WHERE kode_barang='PMM-ZFCX-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-260701-0001','8','PMM-ZFCX-13-0','1','2.010','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-13-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.010' WHERE kode_barang='PMM-ZFCX-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-260701-0001','9','PMM-ZFCX-14-0','1','1.350','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-14-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.350',berat_out_asli='1.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.350',berat_akhir_asli =berat_akhir_asli-'1.350' WHERE kode_barang='PMM-ZFCX-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-260701-0001','10','PMM-ZFCX-15-0','1','2.600','TOKO','MMPER');
DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZFCX-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZFCX-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZFCX-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZFCX-15-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZFCX-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.600',berat_out_asli='2.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.600',berat_akhir_asli =berat_akhir_asli-'2.600' WHERE kode_barang='PMM-ZFCX-15-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-260701-0001','2026-07-01','2026-07-01','08:28','2.600','input','2026-07-01 08:28:48','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0002','1','PSPLT-ZGXA-1-0','1','5.180','TOKO','MMPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-1-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-1-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-1-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-1-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='MMPSN';
INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN';
UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZGXA-1-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='5.180',berat_out_asli='5.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.180',berat_akhir_asli =berat_akhir_asli-'5.180' WHERE kode_barang='PSPLT-ZGXA-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-260701-0002','2026-07-01','2026-07-01','08:29','5.180','input','2026-07-01 08:29:15','THIFA');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-01 ','08:38:28');
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-02614';
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-ZGXA-2-0','00044862','DP-02614BIP ','CINCIN PERAK YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','179000','2026-07-01','179000','1.790','100.00','925','200000','100000.00','1','0.14', 'input','2026-07-01 13:56:21','1.790','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02614BIP','1','RS 16 5','','DP-02614');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXA-2-0','00044862');
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-07-01','PSPRT-ZGXA-2-0','PSPRT','TOKO','PSNB','100.00','1.790','1.790','1','1.790','1.790','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02614BIP ');
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-02501';
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-ZGXA-3-0','00044863','DP-02501DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','728500','2026-07-01','728500','3.570','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-01 13:58:54','3.570','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02501DU','1','RS 21 5','','DP-02501');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-3-0','00044863');
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-07-01','PSPLT-ZGXA-3-0','PSPLT','TOKO','DUPSN','17.00','3.570','3.570','1','3.570','3.570','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02501DU ');
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-02531';
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-ZGXA-4-0','00044864','DP-02531DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','363000','2026-07-01','363000','3.630','100.00','925','210000','100000.00','1','0.14', 'input','2026-07-01 14:00:14','3.630','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02531DU','1','RS 18','','DP-02531');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXA-4-0','00044864');
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-07-01','PSPRT-ZGXA-4-0','PSPRT','TOKO','DUPSN','100.00','3.630','3.630','1','3.630','3.630','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02531DU ');
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-02559';
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-ZGXA-5-0','00044865','DP-02559DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','628500','2026-07-01','628500','3.080','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-01 14:01:32','3.080','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02559DU','1','RS 16','','DP-02559');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-5-0','00044865');
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-07-01','PSPLT-ZGXA-5-0','PSPLT','TOKO','DUPSN','17.00','3.080','3.080','1','3.080','3.080','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02559DU ');
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-02568';
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-ZGXA-6-0','00044866','DP-02568DU ','CINCIN PALADIUM YL-10 ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','1000000','2026-07-01','1000000','4.900','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-01 14:03:07','4.900','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02568DU','1','RS 22','','DP-02568');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-6-0','00044866');
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-07-01','PSPLT-ZGXA-6-0','PSPLT','TOKO','DUPSN','17.00','4.900','4.900','1','4.900','4.900','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02568DU ');
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-02489';
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-ZGXA-7-0','00044867','DP-02489DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','530500','2026-07-01','530500','2.600','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-01 14:04:25','2.600','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02489DU','1','RS 21','','DP-02489');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-7-0','00044867');
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-07-01','PSPLT-ZGXA-7-0','PSPLT','TOKO','DUPSN','17.00','2.600','2.600','1','2.600','2.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02489DU ');
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-02443';
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-ZGXA-8-0','00044868','DP-02443DU ','CINCIN PALADIUM YL-01 ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','1571000','2026-07-01','1571000','4.090','32.00','25','250000','1200000.00','1','0.14', 'input','2026-07-01 14:06:13','4.090','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02443DU','1','RS 17','','DP-02443');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-8-0','00044868');
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-07-01','PSPLT-ZGXA-8-0','PSPLT','TOKO','DUPSN','32.00','4.090','4.090','1','4.090','4.090','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02443DU ');
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-7-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 ('PSPLT-ZGXA-7-0','00044867','00044867','CINCIN PALADIUM ','CINCIN PALADIUM','','','530500','530500',' 250000','250000','input','2026-07-01 14:07:10');
UPDATE tm_barang SET nama_barang='CINCIN PALADIUM' ,nama_atribut='' ,kode_intern='DP-02489SBY', kadar_cetak='10.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 21',total_usd_ext='PSN02489DU',total_usd='0' WHERE kode_barang='PSPLT-ZGXA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-7-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 ('PSPLT-ZGXA-7-0','00044867','00044867','CINCIN PALADIUM','CINCIN PALADIUM','','','530500','530500',' 250000','250000','input','2026-07-01 14:07:15');
UPDATE tm_barang SET nama_barang='CINCIN PALADIUM' ,nama_atribut='' ,kode_intern='DP-02489SBY', kadar_cetak='10.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 21',total_usd_ext='PSN02489SBY',total_usd='0' WHERE kode_barang='PSPLT-ZGXA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-7-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 ('PSPLT-ZGXA-7-0','00044867','00044867','CINCIN PALADIUM','CINCIN PALADIUM','','','530500','530500',' 250000','250000','input','2026-07-01 14:07:31');
UPDATE tm_barang SET nama_barang='CINCIN PALADIUM' ,nama_atribut='' ,kode_intern='DP-02489SBY', kadar_cetak='10.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 21',total_usd_ext='PSN02489SBY',total_usd='0' WHERE kode_barang='PSPLT-ZGXA-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-8-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 ('PSPLT-ZGXA-8-0','00044868','00044868','CINCIN PALADIUM YL-01 ','CINCIN PALADIUM YL-01','','','1571000','1571000',' 250000','250000','input','2026-07-01 14:07:58');
UPDATE tm_barang SET nama_barang='CINCIN PALADIUM YL-01' ,nama_atribut='' ,kode_intern='DP-02443SBY', kadar_cetak='25.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 17',total_usd_ext='PSN02443SBY',total_usd='0' WHERE kode_barang='PSPLT-ZGXA-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-8-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 ('PSPLT-ZGXA-8-0','00044868','00044868','CINCIN PALADIUM YL-01','CINCIN PALADIUM YL-01','','','1571000','1571000',' 250000','250000','input','2026-07-01 14:08:07');
UPDATE tm_barang SET nama_barang='CINCIN PALADIUM YL-01' ,nama_atribut='' ,kode_intern='DP-02443SBY', kadar_cetak='25.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='RS 17',total_usd_ext='PSN02443SBY',total_usd='0' WHERE kode_barang='PSPLT-ZGXA-8-0' LIMIT 1;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260701-0001','1','PSPLT-ZGXA-7-0','1','2.600','2.600','TOKO','DUPSN','TOKO','SBYPSN');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBYPSN' WHERE kode_barang='PSPLT-ZGXA-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-07-01','TOKO','SBYPSN','PSPLT','PSPLT-ZGXA-7-0','17.00','1','2.600','2.600','1','2.600','2.600');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.600',berat_out_asli=berat_out_asli+'2.600',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-01' AND kode_barang='PSPLT-ZGXA-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-260701-0001','2','PSPLT-ZGXA-8-0','1','4.090','4.090','TOKO','DUPSN','TOKO','SBYPSN');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SBYPSN' WHERE kode_barang='PSPLT-ZGXA-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPSN';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-07-01','TOKO','SBYPSN','PSPLT','PSPLT-ZGXA-8-0','32.00','1','4.090','4.090','1','4.090','4.090');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.090',berat_out_asli=berat_out_asli+'4.090',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-07-01' AND kode_barang='PSPLT-ZGXA-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPSN' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-260701-0001','2026-07-01','2026-07-01','14:08','6.69','input','2026-07-01 14:08:22');
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-02626';
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-ZGXA-9-0','00044869','DP-02626SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1098500','2026-07-01','1098500','2.860','32.00','25','260000','1200000.00','1','0.014', 'input','2026-07-01 14:12:00','2.860','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02626SBY','1','RS 21','','DP-02626');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-9-0','00044869');
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-07-01','PSPLT-ZGXA-9-0','PSPLT','TOKO','SBYPSN','32.00','2.860','2.860','1','2.860','2.860','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02626SBY ');
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-02486';
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-ZGXA-10-0','00044870','DP-02486SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','720500','2026-07-01','720500','3.530','17.00','10','260000','1200000.00','1','0.014', 'input','2026-07-01 14:13:23','3.530','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02486SBY','1','RS 17 5','','DP-02486');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-10-0','00044870');
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-07-01','PSPLT-ZGXA-10-0','PSPLT','TOKO','SBYPSN','17.00','3.530','3.530','1','3.530','3.530','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02486SBY ');
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-02521';
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-ZGXA-11-0','00044871','DP-02521SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','211000','2026-07-01','211000','2.110','100.00','925','300000','100000.00','1','0.014', 'input','2026-07-01 14:14:57','2.110','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02521SBY','1','RS 9 5','','DP-02521');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXA-11-0','00044871');
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-07-01','PSPRT-ZGXA-11-0','PSPRT','TOKO','SBYPSN','100.00','2.110','2.110','1','2.110','2.110','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02521SBY ');
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-02503';
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-ZGXA-12-0','00044872','DP-02503SBY ','CINCIN PALADIUM YL-01 ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','335000','2026-07-01','335000','1.640','17.00','10','250000','1200000.00','1','0.014', 'input','2026-07-01 14:16:18','1.640','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02503SBY','1','RS 12','','DP-02503');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-12-0','00044872');
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-07-01','PSPLT-ZGXA-12-0','PSPLT','TOKO','SBYPSN','17.00','1.640','1.640','1','1.640','1.640','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02503SBY ');
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-02507';
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-ZGXA-13-0','00044873','DP-02507SBY ','CINCIN PALADIUM YL-01 ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','577500','2026-07-01','577500','2.830','17.00','10','250000','1200000.00','1','0.014', 'input','2026-07-01 14:17:33','2.830','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02507SBY','1','RS 16 5','','DP-02507');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-13-0','00044873');
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-07-01','PSPLT-ZGXA-13-0','PSPLT','TOKO','SBYPSN','17.00','2.830','2.830','1','2.830','2.830','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02507SBY ');
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-02508';
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-ZGXA-14-0','00044874','DP-02508SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','2698500','2026-07-01','2698500','2.630','45.00','375','260000','2280000.00','1','0.014', 'input','2026-07-01 14:19:23','2.630','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02508SBY','1','RS 17 5','','DP-02508');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGXA-14-0','00044874');
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-07-01','PSGT-ZGXA-14-0','PSGT','TOKO','SBYPSN','45.00','2.630','2.630','1','2.630','2.630','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02508SBY ');
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-02533';
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-ZGXA-15-0','00044875','DP-02533SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','1980500','2026-07-01','1980500','1.930','45.00','375','360000','2280000.00','1','0.014', 'input','2026-07-01 14:20:58','1.930','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02533SBY','1','RS 20 5','','DP-02533');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGXA-15-0','00044875');
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-07-01','PSGT-ZGXA-15-0','PSGT','TOKO','SBYPSN','45.00','1.930','1.930','1','1.930','1.930','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02533SBY ');
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-02499';
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-ZGXA-16-0','00044876','DP-02499SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','537000','2026-07-01','537000','2.630','17.00','10','260000','1200000.00','1','0.014', 'input','2026-07-01 14:22:18','2.630','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02499SBY','1','RS 14 5','','DP-02499');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-16-0','00044876');
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-07-01','PSPLT-ZGXA-16-0','PSPLT','TOKO','SBYPSN','17.00','2.630','2.630','1','2.630','2.630','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02499SBY ');
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-03040';
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-ZGXA-17-0','00044877','DP-03040 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','3898500','2026-07-01','3898500','2.060','83.00','75','260000','2280000.00','1','0.04', 'input','2026-07-01 15:13:39','2.060','0','','18100.00','','TOKO','FREETAG','','2','','','PSN03040','1','RS 11 5','','DP-03040');
DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-ZGXA-17-0','00044877');
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-07-01','PSGE-ZGXA-17-0','PSGE','TOKO','PSN','83.00','2.060','2.060','1','2.060','2.060','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGE';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-03040 ');
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-02474';
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-ZGXA-18-0','00044878','DP-02474MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','2168500','2026-07-01','2168500','3.170','57.00','50','260000','1200000.00','1','0.14', 'input','2026-07-01 15:15:51','3.170','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02474MM','1','RS 16','','DP-02474');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-18-0','00044878');
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-07-01','PSPLT-ZGXA-18-0','PSPLT','TOKO','MMPSN','57.00','3.170','3.170','1','3.170','3.170','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02474MM ');
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-02562';
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-ZGXA-19-0','00044879','DP-02562BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','316500','2026-07-01','316500','1.550','17.00','10','460000','1200000.00','1','0.14', 'input','2026-07-01 15:18:13','1.550','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02562BIP','1','RS 11 5','','DP-02562');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-19-0','00044879');
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-07-01','PSPLT-ZGXA-19-0','PSPLT','TOKO','PSNB','17.00','1.550','1.550','1','1.550','1.550','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02562BIP ');
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-02563';
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-ZGXA-20-0','00044880','DP-02563BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','522500','2026-07-01','522500','2.560','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-01 15:19:34','2.560','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02563BIP','1','RS 22','','DP-02563');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-20-0','00044880');
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-07-01','PSPLT-ZGXA-20-0','PSPLT','TOKO','PSNB','17.00','2.560','2.560','1','2.560','2.560','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02563BIP ');
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-02577';
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-ZGXA-21-0','00044881','DP-02577BIP ','CINCIN PALADIUM YL-01 ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','308500','2026-07-01','308500','1.510','17.00','10','250000','1200000.00','1','0.14', 'input','2026-07-01 15:21:12','1.510','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02577BIP','1','RS 15','','DP-02577');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-21-0','00044881');
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-07-01','PSPLT-ZGXA-21-0','PSPLT','TOKO','PSNB','17.00','1.510','1.510','1','1.510','1.510','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-02577BIP ');
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-02594';
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-ZGXA-22-0','00044882','DP-02594BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','5866500','2026-07-01','5866500','3.100','83.00','75','260000','2280000.00','1','0.14', 'input','2026-07-01 15:22:37','3.100','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02594BIP','1','RS 15 5','','DP-02594');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGXA-22-0','00044882');
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-07-01','PSGT-ZGXA-22-0','PSGT','TOKO','PSNB','83.00','3.100','3.100','1','3.100','3.100','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02594BIP ');
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-02664';
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-ZGXA-23-0','00044883','DP-02664DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','236000','2026-07-01','236000','2.360','100.00','925','230000','100000.00','1','0.14', 'input','2026-07-01 15:26:12','2.360','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02664DU','1','RS 14','','DP-02664');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXA-23-0','00044883');
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-07-01','PSPRT-ZGXA-23-0','PSPRT','TOKO','DUPSN','100.00','2.360','2.360','1','2.360','2.360','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02664DU ');
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-02514';
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-ZGXA-24-0','00044884','DP-02514DU ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','DUPSN','4069000','2026-07-01','4069000','2.150','83.00','75','480000','2280000.00','1','0.14', 'input','2026-07-01 15:27:54','2.150','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02514DU','1','RS 10','','DP-02514');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGXA-24-0','00044884');
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-07-01','PSGT-ZGXA-24-0','PSGT','TOKO','DUPSN','83.00','2.150','2.150','1','2.150','2.150','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02514DU ');
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-02532';
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-ZGXA-25-0','00044885','DP-02532DU ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','DUPSN','4125500','2026-07-01','4125500','2.180','83.00','75','340000','2280000.00','1','0.14', 'input','2026-07-01 15:29:23','2.180','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02532DU','1','RS 11','','DP-02532');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGXA-25-0','00044885');
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-07-01','PSGT-ZGXA-25-0','PSGT','TOKO','DUPSN','83.00','2.180','2.180','1','2.180','2.180','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02532DU ');
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-02451';
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-ZGXA-26-0','00044886','DP-02451SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','664500','2026-07-01','664500','1.730','32.00','25','260000','1200000.00','1','0.014', 'input','2026-07-01 15:32:25','1.730','0','','18100.00','','TOKO','FREETAG','','10','','','PSN02451SBY','1','RS 10','','DP-02451');
DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZGXA-26-0','00044886');
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-07-01','PSPLT-ZGXA-26-0','PSPLT','TOKO','SBYPSN','32.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-02451SBY ');
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-02625';
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-ZGXA-27-0','00044887','DP-02625SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','4712500','2026-07-01','4712500','2.490','83.00','75','340000','2280000.00','1','0.014', 'input','2026-07-01 15:34:00','2.490','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02625SBY','1','RS 14','','DP-02625');
DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZGXA-27-0','00044887');
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-07-01','PSGT-ZGXA-27-0','PSGT','TOKO','SBYPSN','83.00','2.490','2.490','1','2.490','2.490','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSGT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-02625SBY ');
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-02565';
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-ZGXA-28-0','00044888','DP-02565BIP ','CINCIN PERAK SR-04 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','360000','2026-07-01','360000','3.600','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-01 15:53:18','3.600','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02565BIP','1','RS 115 RS 25','','DP-02565');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXA-28-0','00044888');
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-07-01','PSPRT-ZGXA-28-0','PSPRT','TOKO','PSNB','100.00','3.600','3.600','1','3.600','3.600','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02565BIP ');
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-02539';
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-ZGXA-29-0','00044889','DP-02539BIP ','CINCIN PERAK SR-01 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','337000','2026-07-01','337000','3.370','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-01 15:55:00','3.370','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02539BIP','1','RS 18 RS 20','','DP-02539');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXA-29-0','00044889');
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-07-01','PSPRT-ZGXA-29-0','PSPRT','TOKO','PSNB','100.00','3.370','3.370','1','3.370','3.370','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02539BIP ');
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-02587';
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-ZGXA-30-0','00044890','DP-02587BIP ','CINCIN PERAK SR-05 YL-01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','299000','2026-07-01','299000','2.990','100.00','925','410000','100000.00','1','0.14', 'input','2026-07-01 15:56:49','2.990','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02587BIP','1','RS 95 RS 12','','DP-02587');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXA-30-0','00044890');
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-07-01','PSPRT-ZGXA-30-0','PSPRT','TOKO','PSNB','100.00','2.990','2.990','1','2.990','2.990','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02587BIP ');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-07-01 ','15:59:06');
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-02557';
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-ZGXA-31-0','00044891','DP-02557BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','162000','2026-07-01','162000','1.620','100.00','925','370000','100000.00','1','0.14', 'input','2026-07-01 15:59:35','1.620','0','','18100.00','','TOKO','FREETAG','','2','','','PSN02557BIP','1','RS 19','','DP-02557');
DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1;
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZGXA-31-0','00044891');
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-07-01','PSPRT-ZGXA-31-0','PSPRT','TOKO','PSNB','100.00','1.620','1.620','1','1.620','1.620','1');
DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT';
INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-02557BIP ');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0003','1','PSPLT-ZGXA-3-0','1','3.570','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-3-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-3-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-3-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-3-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-ZGXA-3-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.570',berat_out_asli='3.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.570',berat_akhir_asli =berat_akhir_asli-'3.570' WHERE kode_barang='PSPLT-ZGXA-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-260701-0003','2','PSPRT-ZGXA-4-0','1','3.630','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXA-4-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXA-4-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXA-4-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXA-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='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-ZGXA-4-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.630',berat_out_asli='3.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.630',berat_akhir_asli =berat_akhir_asli-'3.630' WHERE kode_barang='PSPRT-ZGXA-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-260701-0003','3','PSPLT-ZGXA-5-0','1','3.080','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-5-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-5-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-5-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-5-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-ZGXA-5-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.080',berat_out_asli='3.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.080',berat_akhir_asli =berat_akhir_asli-'3.080' WHERE kode_barang='PSPLT-ZGXA-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-260701-0003','4','PSPLT-ZGXA-6-0','1','4.900','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-6-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-6-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-6-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-6-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-ZGXA-6-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.900',berat_out_asli='4.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.900',berat_akhir_asli =berat_akhir_asli-'4.900' WHERE kode_barang='PSPLT-ZGXA-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-260701-0003','5','PSPRT-ZGXA-23-0','1','2.360','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXA-23-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXA-23-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXA-23-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXA-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='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-ZGXA-23-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.360',berat_out_asli='2.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.360',berat_akhir_asli =berat_akhir_asli-'2.360' WHERE kode_barang='PSPRT-ZGXA-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-260701-0003','6','PSGT-ZGXA-24-0','1','2.150','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGXA-24-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGXA-24-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGXA-24-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGXA-24-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='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='PSGT-ZGXA-24-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.150',berat_out_asli='2.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.150',berat_akhir_asli =berat_akhir_asli-'2.150' WHERE kode_barang='PSGT-ZGXA-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-260701-0003','7','PSGT-ZGXA-25-0','1','2.180','TOKO','DUPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGXA-25-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGXA-25-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGXA-25-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGXA-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='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='PSGT-ZGXA-25-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.180',berat_out_asli='2.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.180',berat_akhir_asli =berat_akhir_asli-'2.180' WHERE kode_barang='PSGT-ZGXA-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-260701-0003','2026-07-01','2026-07-01','16:18','2.180','input','2026-07-01 16:18:25','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0004','1','PSPRT-ZGXA-2-0','1','1.790','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXA-2-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXA-2-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXA-2-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXA-2-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-ZGXA-2-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.790',berat_out_asli='1.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.790',berat_akhir_asli =berat_akhir_asli-'1.790' WHERE kode_barang='PSPRT-ZGXA-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-260701-0004','2','PSPLT-ZGXA-19-0','1','1.550','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-19-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-19-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-19-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-19-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-ZGXA-19-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.550',berat_out_asli='1.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.550',berat_akhir_asli =berat_akhir_asli-'1.550' WHERE kode_barang='PSPLT-ZGXA-19-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0004','3','PSPLT-ZGXA-20-0','1','2.560','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-20-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-20-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-20-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-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='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-ZGXA-20-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.560',berat_out_asli='2.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.560',berat_akhir_asli =berat_akhir_asli-'2.560' WHERE kode_barang='PSPLT-ZGXA-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-260701-0004','4','PSPLT-ZGXA-21-0','1','1.510','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-21-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-21-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-21-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-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='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-ZGXA-21-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.510',berat_out_asli='1.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.510',berat_akhir_asli =berat_akhir_asli-'1.510' WHERE kode_barang='PSPLT-ZGXA-21-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0004','5','PSGT-ZGXA-22-0','1','3.100','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGXA-22-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGXA-22-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGXA-22-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGXA-22-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='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='PSGT-ZGXA-22-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.100',berat_out_asli='3.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.100',berat_akhir_asli =berat_akhir_asli-'3.100' WHERE kode_barang='PSGT-ZGXA-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-260701-0004','6','PSPRT-ZGXA-28-0','1','3.600','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXA-28-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXA-28-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXA-28-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXA-28-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-ZGXA-28-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.600',berat_out_asli='3.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.600',berat_akhir_asli =berat_akhir_asli-'3.600' WHERE kode_barang='PSPRT-ZGXA-28-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0004','7','PSPRT-ZGXA-29-0','1','3.370','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXA-29-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXA-29-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXA-29-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXA-29-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-ZGXA-29-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.370',berat_out_asli='3.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.370',berat_akhir_asli =berat_akhir_asli-'3.370' WHERE kode_barang='PSPRT-ZGXA-29-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0004','8','PSPRT-ZGXA-30-0','1','2.990','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXA-30-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXA-30-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXA-30-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXA-30-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-ZGXA-30-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.990',berat_out_asli='2.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.990',berat_akhir_asli =berat_akhir_asli-'2.990' WHERE kode_barang='PSPRT-ZGXA-30-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0004','9','PSPRT-ZGXA-31-0','1','1.620','TOKO','PSNB');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXA-31-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXA-31-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXA-31-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXA-31-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-ZGXA-31-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.620',berat_out_asli='1.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.620',berat_akhir_asli =berat_akhir_asli-'1.620' WHERE kode_barang='PSPRT-ZGXA-31-0' AND stock_akhir ='1';
INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-260701-0004','2026-07-01','2026-07-01','16:18','1.620','input','2026-07-01 16:18:42','THIFA');
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0005','1','PSPLT-ZGXA-7-0','1','2.600','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-7-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-7-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-7-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-7-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-ZGXA-7-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.600',berat_out_asli='2.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.600',berat_akhir_asli =berat_akhir_asli-'2.600' WHERE kode_barang='PSPLT-ZGXA-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-260701-0005','2','PSPLT-ZGXA-8-0','1','4.090','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-8-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-8-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-8-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-8-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-ZGXA-8-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='4.090',berat_out_asli='4.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.090',berat_akhir_asli =berat_akhir_asli-'4.090' WHERE kode_barang='PSPLT-ZGXA-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-260701-0005','3','PSPLT-ZGXA-9-0','1','2.860','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-9-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-9-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-9-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-9-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-ZGXA-9-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.860',berat_out_asli='2.860', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.860',berat_akhir_asli =berat_akhir_asli-'2.860' WHERE kode_barang='PSPLT-ZGXA-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-260701-0005','4','PSPLT-ZGXA-10-0','1','3.530','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-10-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-10-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-10-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-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-ZGXA-10-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='3.530',berat_out_asli='3.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.530',berat_akhir_asli =berat_akhir_asli-'3.530' WHERE kode_barang='PSPLT-ZGXA-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-260701-0005','5','PSPRT-ZGXA-11-0','1','2.110','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZGXA-11-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZGXA-11-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZGXA-11-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZGXA-11-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-ZGXA-11-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='PSPRT-ZGXA-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-260701-0005','6','PSPLT-ZGXA-12-0','1','1.640','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-12-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-12-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-12-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-12-0';
DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1;
DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZGXA-12-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.640',berat_out_asli='1.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.640',berat_akhir_asli =berat_akhir_asli-'1.640' WHERE kode_barang='PSPLT-ZGXA-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-260701-0005','7','PSPLT-ZGXA-13-0','1','2.830','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-13-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-13-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-13-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-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-ZGXA-13-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.830',berat_out_asli='2.830', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.830',berat_akhir_asli =berat_akhir_asli-'2.830' WHERE kode_barang='PSPLT-ZGXA-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-260701-0005','8','PSGT-ZGXA-14-0','1','2.630','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGXA-14-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGXA-14-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGXA-14-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGXA-14-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-ZGXA-14-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.630',berat_out_asli='2.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.630',berat_akhir_asli =berat_akhir_asli-'2.630' WHERE kode_barang='PSGT-ZGXA-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-260701-0005','9','PSGT-ZGXA-15-0','1','1.930','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGXA-15-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGXA-15-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGXA-15-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGXA-15-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-ZGXA-15-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='1.930',berat_out_asli='1.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.930',berat_akhir_asli =berat_akhir_asli-'1.930' WHERE kode_barang='PSGT-ZGXA-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-260701-0005','10','PSPLT-ZGXA-16-0','1','2.630','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-16-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-16-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-16-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-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='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-ZGXA-16-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.630',berat_out_asli='2.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.630',berat_akhir_asli =berat_akhir_asli-'2.630' WHERE kode_barang='PSPLT-ZGXA-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-260701-0005','11','PSPLT-ZGXA-26-0','1','1.730','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZGXA-26-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZGXA-26-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZGXA-26-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZGXA-26-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-ZGXA-26-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-ZGXA-26-0' AND stock_akhir ='1';
INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-260701-0005','12','PSGT-ZGXA-27-0','1','2.490','TOKO','SBYPSN');
DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZGXA-27-0' LIMIT 1;
INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZGXA-27-0' LIMIT 1;
DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZGXA-27-0';
INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZGXA-27-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-ZGXA-27-0';
UPDATE tt_barang_saldo set stock_out='1',berat_out='2.490',berat_out_asli='2.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.490',berat_akhir_asli =berat_akhir_asli-'2.490' WHERE kode_barang='PSGT-ZGXA-27-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-260701-0005','2026-07-01','2026-07-01','16:18','2.490','input','2026-07-01 16:18:56','THIFA');