INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-02 ','08:15:52'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-02','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-01'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-01'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-01'; 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-10-01' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-01'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-01'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-01'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-01'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202609 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-09'; UPDATE tt_barang_saldo SET tanggal= '2026-10-02' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-01' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-10-02'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-02 ','08:18:41'); UPDATE tm_group SET nama_group='PSN PALADIUM ELCO',jenis_group='TUA',harga='1200000',status_berlian='1',edit_by='input',edit_date='2026-10-02 08:19:52' WHERE kode_group='PSPLE'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'1200000' WHERE stock_on_hand*1> 0 AND kode_group='PSPLE'; 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-03116'; 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 ('PSPLE-ZJXB-1-0','00047820','DP-03116 ','CINCIN BERLIAN PALADIUM ','','GR','---','PSPLE','PSPLE','TOKO','PSN','955000','2026-10-02','955000','4.680','17.00','10','0','1200000.00','1','0.04', 'input','2026-10-02 08:21:31','4.680','265000','112.50','18000.00','','TOKO','FREETAG','','10','','','PSN03116','1','RS 23','','DP-03116'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLE','PSPLE-ZJXB-1-0','00047820'); 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-10-02','PSPLE-ZJXB-1-0','PSPLE','TOKO','PSN','17.00','4.680','4.680','1','4.680','4.680','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLE','DP-03116 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('PSPLE-ZJXB-1-0','00047820','RD','1','0.150 ','750','112.5'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-02 ','08:23:48'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0001','1','PSPLE-ZJXB-1-0','1','4.680','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-ZJXB-1-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLE-ZJXB-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLE-ZJXB-1-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLE-ZJXB-1-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPLE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLE-ZJXB-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.680',berat_out_asli='4.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.680',berat_akhir_asli =berat_akhir_asli-'4.680' WHERE kode_barang='PSPLE-ZJXB-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-261002-0001','2026-10-02','2026-10-02','08:25','4.680','input','2026-10-02 08:25:01','ELCO'); UPDATE tm_group SET nama_group='PSN PALADIUM ELCO',jenis_group='TUA',harga='1200000',status_berlian='0',edit_by='input',edit_date='2026-10-02 09:48:39' WHERE kode_group='PSPLE'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'1200000' WHERE stock_on_hand*1> 0 AND kode_group='PSPLE'; 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-03117'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSBRE-ZJXB-2-0','00047821','DP-03117 ','CINCIN BERLIAN ','','GR','---','PSBRE','PSBRE','TOKO','PSN','3933000','2026-10-02','3933000','2.060','83.00','75','0','2300000.00','1','0.04', 'input','2026-10-02 09:52:02','2.060','350000','75.60','18000.00','','TOKO','FREETAG','','10','','','PSN03117','1','RS 10 5','','DP-03117'); DELETE FROM tp_barang WHERE kode_dept = 'PSBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSBRE','PSBRE-ZJXB-2-0','00047821'); 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-10-02','PSBRE-ZJXB-2-0','PSBRE','TOKO','PSN','83.00','2.060','2.060','1','2.060','2.060','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSBRE','DP-03117 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('PSBRE-ZJXB-2-0','00047821','RD','9','0.180 ','420','75.6'); 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-04003'; 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-ZJXB-3-0','00047822','DP-04003BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','453000','2026-10-02','453000','2.220','17.00','10','430000','1200000.00','1','0.14', 'input','2026-10-02 09:55:51','2.220','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04003BIP','1','RS 16 5','','DP-04003'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-3-0','00047822'); 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-10-02','PSPLT-ZJXB-3-0','PSPLT','TOKO','PSNB','17.00','2.220','2.220','1','2.220','2.220','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04003BIP '); 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-03910'; 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-ZJXB-4-0','00047823','DP-03910BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','3448000','2026-10-02','3448000','2.630','57.00','50','260000','2300000.00','1','0.14', 'input','2026-10-02 09:57:30','2.630','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03910BIP','1','RS 10 5','','DP-03910'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-4-0','00047823'); 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-10-02','PSGT-ZJXB-4-0','PSGT','TOKO','PSNB','57.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-03910BIP '); 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-04053'; 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-ZJXB-5-0','00047824','DP-04053BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','2225500','2026-10-02','2225500','2.150','45.00','375','320000','2300000.00','1','0.14', 'input','2026-10-02 09:59:18','2.150','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04053BIP','1','RS 11','','DP-04053'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-5-0','00047824'); 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-10-02','PSGT-ZJXB-5-0','PSGT','TOKO','PSNB','45.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-04053BIP '); 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-04027'; 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-ZJXB-6-0','00047825','DP-04027BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','2277000','2026-10-02','2277000','2.200','45.00','375','320000','2300000.00','1','0.14', 'input','2026-10-02 10:01:03','2.200','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04027BIP','1','RS 12 5','','DP-04027'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-6-0','00047825'); 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-10-02','PSGT-ZJXB-6-0','PSGT','TOKO','PSNB','45.00','2.200','2.200','1','2.200','2.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04027BIP '); 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-03928'; 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-ZJXB-7-0','00047826','DP-03928BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','151000','2026-10-02','151000','1.510','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-02 10:02:30','1.510','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03928BIP','1','RS 16','','DP-03928'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-7-0','00047826'); 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-10-02','PSPRT-ZJXB-7-0','PSPRT','TOKO','PSNB','100.00','1.510','1.510','1','1.510','1.510','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03928BIP '); 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-04127'; 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-ZJXB-8-0','00047827','DP-04127BIP ','CINCIN PERAK SR04 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','316000','2026-10-02','316000','3.160','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-02 10:04:44','3.160','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04127BIP','1','RS 105 RS 175','','DP-04127'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-8-0','00047827'); 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-10-02','PSPRT-ZJXB-8-0','PSPRT','TOKO','PSNB','100.00','3.160','3.160','1','3.160','3.160','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04127BIP '); 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-04143'; 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-ZJXB-9-0','00047828','DP-04143BIP ','CINCIN PERAK SR01 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','289000','2026-10-02','289000','2.890','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-02 10:06:34','2.890','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04143BIP','1','RS 135 RS 145','','DP-04143'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-9-0','00047828'); 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-10-02','PSPRT-ZJXB-9-0','PSPRT','TOKO','PSNB','100.00','2.890','2.890','1','2.890','2.890','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04143BIP '); 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-03996'; 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-ZJXB-10-0','00047829','DP-03996BIP ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','308000','2026-10-02','308000','3.080','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-02 10:08:30','3.080','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03996BIP','1','RS 155 RS 17','','DP-03996'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-10-0','00047829'); 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-10-02','PSPRT-ZJXB-10-0','PSPRT','TOKO','PSNB','100.00','3.080','3.080','1','3.080','3.080','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03996BIP '); 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-03826'; 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-ZJXB-11-0','00047830','DP-03826MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','616500','2026-10-02','616500','3.020','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-02 10:13:03','3.020','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03826MM','1','RS 18 5','','DP-03826'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-11-0','00047830'); 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-10-02','PSPLT-ZJXB-11-0','PSPLT','TOKO','MMPSN','17.00','3.020','3.020','1','3.020','3.020','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03826MM '); 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-03825'; 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-ZJXB-12-0','00047831','DP-03825MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','4887500','2026-10-02','4887500','2.560','83.00','75','260000','2300000.00','1','0.14', 'input','2026-10-02 10:14:36','2.560','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03825MM','1','RS 11 5','','DP-03825'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-12-0','00047831'); 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-10-02','PSGT-ZJXB-12-0','PSGT','TOKO','MMPSN','83.00','2.560','2.560','1','2.560','2.560','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-03825MM '); 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-03865'; 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-ZJXB-13-0','00047832','DP-03865MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','4696500','2026-10-02','4696500','2.460','83.00','75','400000','2300000.00','1','0.14', 'input','2026-10-02 10:16:06','2.460','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03865MM','1','RS 12','','DP-03865'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-13-0','00047832'); 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-10-02','PSGT-ZJXB-13-0','PSGT','TOKO','MMPSN','83.00','2.460','2.460','1','2.460','2.460','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-03865MM '); 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-03863'; 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-ZJXB-14-0','00047833','DP-03863MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','2373000','2026-10-02','2373000','1.810','57.00','50','330000','2300000.00','1','0.14', 'input','2026-10-02 10:17:48','1.810','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03863MM','1','RS 9 5','','DP-03863'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-14-0','00047833'); 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-10-02','PSGT-ZJXB-14-0','PSGT','TOKO','MMPSN','57.00','1.810','1.810','1','1.810','1.810','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-03863MM '); 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-04140'; 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-ZJXB-15-0','00047834','DP-04140MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','1873500','2026-10-02','1873500','1.810','45.00','375','280000','2300000.00','1','0.14', 'input','2026-10-02 10:19:18','1.810','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04140BIP','1','RS 13 5','','DP-04140'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-15-0','00047834'); 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-10-02','PSGT-ZJXB-15-0','PSGT','TOKO','MMPSN','45.00','1.810','1.810','1','1.810','1.810','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04140MM '); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-02 ','10:50:03'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-02 ','14:18:43'); 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-03979'; 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-ZJXB-16-0','00047835','DP-03979BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','439000','2026-10-02','439000','2.150','17.00','10','440000','1200000.00','1','0.14', 'input','2026-10-02 14:35:15','2.150','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03979BIP','1','RS 15','','DP-03979'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-16-0','00047835'); 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-10-02','PSPLT-ZJXB-16-0','PSPLT','TOKO','PSNB','17.00','2.150','2.150','1','2.150','2.150','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03979BIP '); 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-03946'; 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-ZJXB-17-0','00047836','DP-03946DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','612500','2026-10-02','612500','3.000','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-02 14:37:06','3.000','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03946DU','1','RS 18','','DP-03946'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-17-0','00047836'); 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-10-02','PSPLT-ZJXB-17-0','PSPLT','TOKO','DUPSN','17.00','3.000','3.000','1','3.000','3.000','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03946DU '); 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-03977'; 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-ZJXB-18-0','00047837','DP-03977DU ','CINCIN PERAK YL10 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','467000','2026-10-02','467000','4.670','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-02 14:38:29','4.670','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03977DU','1','RS 28','','DP-03977'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-18-0','00047837'); 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-10-02','PSPRT-ZJXB-18-0','PSPRT','TOKO','DUPSN','100.00','4.670','4.670','1','4.670','4.670','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03977DU '); 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-04011'; 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-ZJXB-19-0','00047838','DP-04011DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','288000','2026-10-02','288000','2.880','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-02 14:39:41','2.880','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04011DU','1','RS 19','','DP-04011'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-19-0','00047838'); 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-10-02','PSPRT-ZJXB-19-0','PSPRT','TOKO','DUPSN','100.00','2.880','2.880','1','2.880','2.880','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04011DU '); 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-04025'; 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-ZJXB-20-0','00047839','DP-04025SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','228500','2026-10-02','228500','2.280','100.00','925','200000','100000.00','1','0.014', 'input','2026-10-02 14:43:27','2.280','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04025SBY','1','RS 16','','DP-04025'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-20-0','00047839'); 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-10-02','PSPRT-ZJXB-20-0','PSPRT','TOKO','SBYPSN','100.00','2.280','2.280','1','2.280','2.280','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04025SBY '); 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-04041'; 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-ZJXB-21-0','00047840','DP-04041SBY ','CINCIN EMAS SR03 ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','2688000','2026-10-02','2688000','2.050','57.00','50','260000','2300000.00','1','0.014', 'input','2026-10-02 14:45:06','2.050','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04041SBY','1','RS 12 5','','DP-04041'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-21-0','00047840'); 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-10-02','PSGT-ZJXB-21-0','PSGT','TOKO','SBYPSN','57.00','2.050','2.050','1','2.050','2.050','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04041SBY '); 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-04249'; 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-ZJXB-22-0','00047841','DP-04249JOG ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','833500','2026-10-02','833500','2.170','32.00','25','280000','1200000.00','1','0.14', 'input','2026-10-02 14:49:12','2.170','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04249JOG','1','RS 7 5','','DP-04249'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-22-0','00047841'); 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-10-02','PSPLT-ZJXB-22-0','PSPLT','TOKO','JOGPSN','32.00','2.170','2.170','1','2.170','2.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04249JOG '); 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-04006'; 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-ZJXB-23-0','00047842','DP-04006JOG ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','JOGPSN','450000','2026-10-02','450000','4.500','100.00','925','420000','100000.00','1','0.14', 'input','2026-10-02 14:51:13','4.500','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04006JOG','1','RS 26 RS 30','','DP-04006'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-23-0','00047842'); 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-10-02','PSPRT-ZJXB-23-0','PSPRT','TOKO','JOGPSN','100.00','4.500','4.500','1','4.500','4.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04006JOG '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPDE-ZJXB-24-0','00047843','CKPDE-00089 ','CINCIN KAWIN CKPDE-00089 ','','GR','---','PLD','CKPDE','TOKO','CKPDE','747000','2026-10-02','747000','3.660','17.00','10','250000','1200000.00','1','0.14', 'input','2026-10-02 15:08:44','3.660','0','','18000.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPDE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPDE','CKPDE-ZJXB-24-0','00047843'); 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-10-02','CKPDE-ZJXB-24-0','CKPDE','TOKO','CKPDE','17.00','3.660','3.660','1','3.660','3.660','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPDE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPDE','CKPDE-00089 '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKPDE-ZJXB-25-0','00047844','CKPDE-00090 ','CINCIN KAWIN CKPDE-00090 ','','GR','---','PLD','CKPDE','TOKO','CKPDE','859000','2026-10-02','859000','4.210','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-02 15:09:26','4.210','0','','18000.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKPDE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKPDE','CKPDE-ZJXB-25-0','00047844'); 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-10-02','CKPDE-ZJXB-25-0','CKPDE','TOKO','CKPDE','17.00','4.210','4.210','1','4.210','4.210','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKPDE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKPDE','CKPDE-00090 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLDMM-ZJXB-26-0','00047845','PLDMM-00049 ','CINCIN PALADIUM PLDMM-00049 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','496000','2026-10-02','496000','2.430','17.00','10','250000','1200000.00','1','0.04', 'input','2026-10-02 15:12:23','2.430','0','','18000.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-ZJXB-26-0','00047845'); 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-10-02','PLDMM-ZJXB-26-0','PLDMM','TOKO','MMPLD','17.00','2.430','2.430','1','2.430','2.430','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00049 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLDMM-ZJXB-27-0','00047846','PLDMM-00050 ','CINCIN PALADIUM PLDMM-00050 ','','GR','---','PLD','PLDMM','TOKO','MMPLD','704000','2026-10-02','704000','3.450','17.00','10','250000','1200000.00','1','0.04', 'input','2026-10-02 15:13:04','3.450','','','18000.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLDMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLDMM','PLDMM-ZJXB-27-0','00047846'); 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-10-02','PLDMM-ZJXB-27-0','PLDMM','TOKO','MMPLD','17.00','3.450','3.450','1','3.450','3.450','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLDMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLDMM','PLDMM-00050 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLBDG-ZJXB-28-0','00047847','PLBDG-00166 ','CINCIN PALADIUM PLBDG-00166 ','','GR','---','PLD','PLBDG','TOKO','PLBDG','694000','2026-10-02','694000','3.400','17.00','10','250000','1200000.00','1','0.14', 'input','2026-10-02 15:15:46','3.400','0','','18000.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLBDG' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLBDG','PLBDG-ZJXB-28-0','00047847'); 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-10-02','PLBDG-ZJXB-28-0','PLBDG','TOKO','PLBDG','17.00','3.400','3.400','1','3.400','3.400','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLBDG','PLBDG-00166 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLBDG-ZJXB-29-0','00047848','PLBDG-00167 ','CINCIN PALADIUM PLBDG-00167 ','','GR','---','PLD','PLBDG','TOKO','PLBDG','820500','2026-10-02','820500','4.020','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-02 15:16:10','4.020','0','','18000.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLBDG' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLBDG','PLBDG-ZJXB-29-0','00047848'); 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-10-02','PLBDG-ZJXB-29-0','PLBDG','TOKO','PLBDG','17.00','4.020','4.020','1','4.020','4.020','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLBDG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLBDG','PLBDG-00167 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPLD-ZJXB-30-0','00047849','LXPLD-00006 ','CINCIN PALADIUM LXPLD-00006 ','','GR','---','PLD','LXPLD','TOKO','DUPLD','430500','2026-10-02','430500','2.110','17.00','10','250000','1200000.00','1','0.04', 'input','2026-10-02 15:18:55','2.110','0','','18000.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPLD' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPLD','LXPLD-ZJXB-30-0','00047849'); 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-10-02','LXPLD-ZJXB-30-0','LXPLD','TOKO','DUPLD','17.00','2.110','2.110','1','2.110','2.110','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPLD'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPLD','LXPLD-00006 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPLD-ZJXB-31-0','00047850','LXPLD-00007 ','CINCIN PALADIUM LXPLD-00007 ','','GR','---','PLD','LXPLD','TOKO','DUPLD','838500','2026-10-02','838500','4.110','17.00','10','250000','1200000.00','1','0.04', 'input','2026-10-02 15:19:24','4.110','0','','18000.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPLD' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPLD','LXPLD-ZJXB-31-0','00047850'); 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-10-02','LXPLD-ZJXB-31-0','LXPLD','TOKO','DUPLD','17.00','4.110','4.110','1','4.110','4.110','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPLD'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPLD','LXPLD-00007 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PLSBY-ZJXB-32-0','00047851','PLSBY-00008 ','CINCIN PALADIUM PLSBY-00008 ','','GR','---','PLD','PLSBY','TOKO','SBYPLD','714500','2026-10-02','714500','3.500','17.00','10','250000','1200000.00','1','0.014', 'input','2026-10-02 15:21:56','3.500','0','','18000.00','','TOKO','FREETAG','','10','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PLSBY' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PLSBY','PLSBY-ZJXB-32-0','00047851'); 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-10-02','PLSBY-ZJXB-32-0','PLSBY','TOKO','SBYPLD','17.00','3.500','3.500','1','3.500','3.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PLSBY'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PLSBY','PLSBY-00008 '); 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-03119'; 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 ('PSPRE-ZJXB-33-0','00047852','DP-03119 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','165000','2026-10-02','165000','1.650','100.00','925','430000','100000.00','1','0.04', 'input','2026-10-02 16:07:10','1.650','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03119','1','RS 9','','DP-03119'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZJXB-33-0','00047852'); 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-10-02','PSPRE-ZJXB-33-0','PSPRE','TOKO','PSN','100.00','1.650','1.650','1','1.650','1.650','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03119 '); 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-03895'; 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-ZJXB-34-0','00047853','DP-03895BIP ','CINCIN PERAK YL10 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','472000','2026-10-02','472000','4.720','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-02 16:09:27','4.720','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03895BIP','1','RS 22','','DP-03895'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-34-0','00047853'); 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-10-02','PSPRT-ZJXB-34-0','PSPRT','TOKO','PSNB','100.00','4.720','4.720','1','4.720','4.720','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03895BIP '); 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-04082'; 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-ZJXB-35-0','00047854','DP-04082BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','385000','2026-10-02','385000','3.850','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-02 16:10:50','3.850','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04082BIP','1','RS 18','','DP-04082'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-35-0','00047854'); 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-10-02','PSPRT-ZJXB-35-0','PSPRT','TOKO','PSNB','100.00','3.850','3.850','1','3.850','3.850','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04082BIP '); 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-04134'; 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-ZJXB-36-0','00047855','DP-04134BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','216000','2026-10-02','216000','2.160','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-02 16:12:12','2.160','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04134BIP','1','RS 21','','DP-04134'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-36-0','00047855'); 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-10-02','PSPRT-ZJXB-36-0','PSPRT','TOKO','PSNB','100.00','2.160','2.160','1','2.160','2.160','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04134BIP '); 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-04024'; 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-ZJXB-37-0','00047856','DP-04024BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','301000','2026-10-02','301000','3.010','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-02 16:13:27','3.010','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04024BIP','1','RS 20','','DP-04024'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-37-0','00047856'); 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-10-02','PSPRT-ZJXB-37-0','PSPRT','TOKO','PSNB','100.00','3.010','3.010','1','3.010','3.010','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04024BIP '); 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-04043'; 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-ZJXB-38-0','00047857','DP-04043BIP ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','200000','2026-10-02','200000','2.000','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-02 16:14:50','2.000','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04043BIP','1','RS 23','','DP-04043'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-38-0','00047857'); 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-10-02','PSPRT-ZJXB-38-0','PSPRT','TOKO','PSNB','100.00','2.000','2.000','1','2.000','2.000','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04043BIP '); 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-04131'; 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-ZJXB-39-0','00047858','DP-04131BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','213000','2026-10-02','213000','2.130','100.00','925','350000','100000.00','1','0.14', 'input','2026-10-02 16:16:20','2.130','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04131BIP','1','RS 20','','DP-04131'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-39-0','00047858'); 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-10-02','PSPRT-ZJXB-39-0','PSPRT','TOKO','PSNB','100.00','2.130','2.130','1','2.130','2.130','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04131BIP '); 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-03907'; 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-ZJXB-40-0','00047859','DP-03907BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','264000','2026-10-02','264000','2.640','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-02 16:17:33','2.640','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03907BIP','1','RS 25','','DP-03907'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-40-0','00047859'); 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-10-02','PSPRT-ZJXB-40-0','PSPRT','TOKO','PSNB','100.00','2.640','2.640','1','2.640','2.640','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03907BIP '); 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-04015'; 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-ZJXB-41-0','00047860','DP-04015DU ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','151000','2026-10-02','151000','1.510','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-02 16:21:03','1.510','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04015DU','1','RS 13 5','','DP-04015'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-41-0','00047860'); 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-10-02','PSPRT-ZJXB-41-0','PSPRT','TOKO','DUPSN','100.00','1.510','1.510','1','1.510','1.510','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04015DU '); 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-04042'; 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-ZJXB-42-0','00047861','DP-04042SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1283000','2026-10-02','1283000','3.340','32.00','25','250000','1200000.00','1','0.014', 'input','2026-10-02 16:22:56','3.340','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04042SBY','1','RS 16 5','','DP-04042'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-42-0','00047861'); 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-10-02','PSPLT-ZJXB-42-0','PSPLT','TOKO','SBYPSN','32.00','3.340','3.340','1','3.340','3.340','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04042SBY '); 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-04008'; 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-ZJXB-43-0','00047862','DP-04008DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','327000','2026-10-02','327000','3.270','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-02 16:33:02','3.270','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04008DU','1','RS 22','','DP-04008'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-43-0','00047862'); 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-10-02','PSPRT-ZJXB-43-0','PSPRT','TOKO','DUPSN','100.00','3.270','3.270','1','3.270','3.270','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04008DU '); 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-04013'; 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-ZJXB-44-0','00047863','DP-04013DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','318000','2026-10-02','318000','3.180','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-02 16:34:26','3.180','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04013DU','1','RS 16 5','','DP-04013'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-44-0','00047863'); 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-10-02','PSPRT-ZJXB-44-0','PSPRT','TOKO','DUPSN','100.00','3.180','3.180','1','3.180','3.180','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04013DU '); 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-03988'; 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-ZJXB-45-0','00047864','DP-03988SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','3902000','2026-10-02','3902000','3.770','45.00','375','670000','2300000.00','1','0.014', 'input','2026-10-02 16:37:05','3.770','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03988SBY','1','RS 18 5','','DP-03988'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-45-0','00047864'); 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-10-02','PSGT-ZJXB-45-0','PSGT','TOKO','SBYPSN','45.00','3.770','3.770','1','3.770','3.770','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-03988SBY '); 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-03978'; 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-ZJXB-46-0','00047865','DP-03978SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','1615000','2026-10-02','1615000','1.560','45.00','375','490000','2300000.00','1','0.014', 'input','2026-10-02 16:38:58','1.560','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03978SBY','1','RS 15','','DP-03978'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-46-0','00047865'); 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-10-02','PSGT-ZJXB-46-0','PSGT','TOKO','SBYPSN','45.00','1.560','1.560','1','1.560','1.560','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-03978SBY '); 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-03981'; 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-ZJXB-47-0','00047866','DP-03981SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1517000','2026-10-02','1517000','3.950','32.00','25','260000','1200000.00','1','0.014', 'input','2026-10-02 16:40:17','3.950','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03981SBY','1','RS 14 5','','DP-03981'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-47-0','00047866'); 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-10-02','PSPLT-ZJXB-47-0','PSPLT','TOKO','SBYPSN','32.00','3.950','3.950','1','3.950','3.950','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03981SBY '); 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-04009'; 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-ZJXB-48-0','00047867','DP-04009SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1452000','2026-10-02','1452000','3.780','32.00','25','250000','1200000.00','1','0.014', 'input','2026-10-02 16:41:45','3.780','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04009SBY','1','RS 21 5','','DP-04009'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-48-0','00047867'); 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-10-02','PSPLT-ZJXB-48-0','PSPLT','TOKO','SBYPSN','32.00','3.780','3.780','1','3.780','3.780','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04009SBY '); 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-03985'; 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-ZJXB-49-0','00047868','DP-03985SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','242000','2026-10-02','242000','2.420','100.00','925','200000','100000.00','1','0.014', 'input','2026-10-02 16:43:08','2.420','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03985SBY','1','RS 23 5','','DP-03985'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-49-0','00047868'); 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-10-02','PSPRT-ZJXB-49-0','PSPRT','TOKO','SBYPSN','100.00','2.420','2.420','1','2.420','2.420','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03985SBY '); 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-03986'; 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-ZJXB-50-0','00047869','DP-03986SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','298000','2026-10-02','298000','1.460','17.00','10','530000','1200000.00','1','0.014', 'input','2026-10-02 16:45:02','1.460','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03986SBY','1','RS 13','','DP-03986'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-50-0','00047869'); 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-10-02','PSPLT-ZJXB-50-0','PSPLT','TOKO','SBYPSN','17.00','1.460','1.460','1','1.460','1.460','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03986SBY '); 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-03914'; 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-ZJXB-51-0','00047870','DP-03914MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','1842500','2026-10-02','1842500','1.780','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-02 17:04:04','1.780','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03914MM','1','RS 9','','DP-03914'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-51-0','00047870'); 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-10-02','PSGT-ZJXB-51-0','PSGT','TOKO','MMPSN','45.00','1.780','1.780','1','1.780','1.780','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-03914MM '); 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-04049'; 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-ZJXB-52-0','00047871','DP-04049MM ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','151000','2026-10-02','151000','1.510','100.00','925','270000','100000.00','1','0.14', 'input','2026-10-02 17:05:25','1.510','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04049MM','1','RS 8','','DP-04049'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-52-0','00047871'); 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-10-02','PSPRT-ZJXB-52-0','PSPRT','TOKO','MMPSN','100.00','1.510','1.510','1','1.510','1.510','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04049MM '); 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-03915'; 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-ZJXB-53-0','00047872','DP-03915MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','518500','2026-10-02','518500','2.540','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-02 17:06:47','2.540','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03915MM','1','RS 15 5','','DP-03915'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-53-0','00047872'); 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-10-02','PSPLT-ZJXB-53-0','PSPLT','TOKO','MMPSN','17.00','2.540','2.540','1','2.540','2.540','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03915MM '); 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-03905'; 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-ZJXB-54-0','00047873','DP-03905BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','673500','2026-10-02','673500','3.300','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-02 17:10:04','3.300','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03905BIP','1','RS 16','','DP-03905'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-54-0','00047873'); 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-10-02','PSPLT-ZJXB-54-0','PSPLT','TOKO','PSNB','17.00','3.300','3.300','1','3.300','3.300','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03905BIP '); 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-03898'; 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-ZJXB-55-0','00047874','DP-03898BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','361500','2026-10-02','361500','1.770','17.00','10','340000','1200000.00','1','0.14', 'input','2026-10-02 17:11:52','1.770','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03898BIP','1','RS 11','','DP-03898'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-55-0','00047874'); 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-10-02','PSPLT-ZJXB-55-0','PSPLT','TOKO','PSNB','17.00','1.770','1.770','1','1.770','1.770','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03898BIP '); 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-03929'; 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-ZJXB-56-0','00047875','DP-03929BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','479500','2026-10-02','479500','2.350','17.00','10','280000','1200000.00','1','0.14', 'input','2026-10-02 17:13:20','2.350','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03929BIP','1','RS 8','','DP-03929'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-56-0','00047875'); 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-10-02','PSPLT-ZJXB-56-0','PSPLT','TOKO','PSNB','17.00','2.350','2.350','1','2.350','2.350','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03929BIP '); 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-03908'; 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-ZJXB-57-0','00047876','DP-03908BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','712000','2026-10-02','712000','3.490','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-02 17:14:47','3.490','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03908BIP','1','RS 16 5','','DP-03908'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-57-0','00047876'); 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-10-02','PSPLT-ZJXB-57-0','PSPLT','TOKO','PSNB','17.00','3.490','3.490','1','3.490','3.490','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03908BIP '); 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-04016'; 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-ZJXB-58-0','00047877','DP-04016BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','3105000','2026-10-02','3105000','3.000','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-02 17:17:22','3.000','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04016BIP','1','RS 13','','DP-04016'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-58-0','00047877'); 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-10-02','PSGT-ZJXB-58-0','PSGT','TOKO','PSNB','45.00','3.000','3.000','1','3.000','3.000','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04016BIP '); 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-03896'; 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-ZJXB-59-0','00047878','DP-03896BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','3001500','2026-10-02','3001500','2.900','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-02 17:18:43','2.900','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03896BIP','1','RS 11','','DP-03896'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-59-0','00047878'); 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-10-02','PSGT-ZJXB-59-0','PSGT','TOKO','PSNB','45.00','2.900','2.900','1','2.900','2.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-03896BIP '); 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-04007'; 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-ZJXB-60-0','00047879','DP-04007DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','213000','2026-10-02','213000','2.130','100.00','925','420000','100000.00','1','0.14', 'input','2026-10-02 17:22:51','2.130','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04007DU','1','RS 14','','DP-04007'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-60-0','00047879'); 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-10-02','PSPRT-ZJXB-60-0','PSPRT','TOKO','DUPSN','100.00','2.130','2.130','1','2.130','2.130','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04007DU '); 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-03945'; 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-ZJXB-61-0','00047880','DP-03945DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','398000','2026-10-02','398000','1.950','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-02 17:24:14','1.950','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03945DU','1','RS 13','','DP-03945'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-61-0','00047880'); 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-10-02','PSPLT-ZJXB-61-0','PSPLT','TOKO','DUPSN','17.00','1.950','1.950','1','1.950','1.950','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03945DU '); 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-04028'; 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-ZJXB-62-0','00047881','DP-04028SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','206000','2026-10-02','206000','2.060','100.00','925','590000','100000.00','1','0.014', 'input','2026-10-02 17:26:54','2.060','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04028SBY','1','RS 12 5','','DP-04028'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-62-0','00047881'); 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-10-02','PSPRT-ZJXB-62-0','PSPRT','TOKO','SBYPSN','100.00','2.060','2.060','1','2.060','2.060','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04028SBY '); 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-04251'; 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-ZJXB-63-0','00047882','DP-04251JOG ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','492000','2026-10-02','492000','2.410','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-02 17:29:07','2.410','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04251JOG','1','RS 14 5','','DP-04251'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXB-63-0','00047882'); 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-10-02','PSPLT-ZJXB-63-0','PSPLT','TOKO','JOGPSN','17.00','2.410','2.410','1','2.410','2.410','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04251JOG '); 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-04284'; 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-ZJXB-64-0','00047883','DP-04284JOG ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','JOGPSN','173000','2026-10-02','173000','1.730','100.00','925','350000','100000.00','1','0.14', 'input','2026-10-02 17:30:40','1.730','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04284JOG','1','RS 10','','DP-04284'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXB-64-0','00047883'); 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-10-02','PSPRT-ZJXB-64-0','PSPRT','TOKO','JOGPSN','100.00','1.730','1.730','1','1.730','1.730','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04284JOG '); 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-04029'; 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-ZJXB-65-0','00047884','DP-04029JOG ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','JOGPSN','3001500','2026-10-02','3001500','2.900','45.00','375','740000','2300000.00','1','0.14', 'input','2026-10-02 17:32:24','2.900','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04029JOG','1','RS 12','','DP-04029'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-65-0','00047884'); 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-10-02','PSGT-ZJXB-65-0','PSGT','TOKO','JOGPSN','45.00','2.900','2.900','1','2.900','2.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04029JOG '); 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-04020'; 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-ZJXB-66-0','00047885','DP-04020JOG ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','JOGPSN','3540000','2026-10-02','3540000','3.420','45.00','375','390000','2300000.00','1','0.14', 'input','2026-10-02 17:34:12','3.420','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04020JOG','1','RS 19','','DP-04020'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXB-66-0','00047885'); 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-10-02','PSGT-ZJXB-66-0','PSGT','TOKO','JOGPSN','45.00','3.420','3.420','1','3.420','3.420','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04020JOG '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0002','1','PSBRE-ZJXB-2-0','1','2.060','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSBRE-ZJXB-2-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBRE-ZJXB-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSBRE-ZJXB-2-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBRE-ZJXB-2-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSBRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSBRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSBRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBRE-ZJXB-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.060' WHERE kode_barang='PSBRE-ZJXB-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-261002-0002','2','PSPRE-ZJXB-33-0','1','1.650','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZJXB-33-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZJXB-33-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZJXB-33-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZJXB-33-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRE-ZJXB-33-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.650',berat_out_asli='1.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.650',berat_akhir_asli =berat_akhir_asli-'1.650' WHERE kode_barang='PSPRE-ZJXB-33-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-261002-0002','2026-10-02','2026-10-02','17:37','1.650','input','2026-10-02 17:37:36','ELCO'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0003','1','PSPLT-ZJXB-11-0','1','3.020','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-11-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-11-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-11-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-11-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.020',berat_out_asli='3.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.020',berat_akhir_asli =berat_akhir_asli-'3.020' WHERE kode_barang='PSPLT-ZJXB-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-261002-0003','2','PSGT-ZJXB-12-0','1','2.560','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-12-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-12-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-12-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-12-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJXB-12-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='PSGT-ZJXB-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-261002-0003','3','PSGT-ZJXB-13-0','1','2.460','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-13-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-13-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-13-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-13-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJXB-13-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.460',berat_out_asli='2.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.460',berat_akhir_asli =berat_akhir_asli-'2.460' WHERE kode_barang='PSGT-ZJXB-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-261002-0003','4','PSGT-ZJXB-14-0','1','1.810','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-14-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-14-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-14-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-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='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJXB-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.810',berat_out_asli='1.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.810',berat_akhir_asli =berat_akhir_asli-'1.810' WHERE kode_barang='PSGT-ZJXB-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-261002-0003','5','PSGT-ZJXB-15-0','1','1.810','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-15-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-15-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-15-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-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='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJXB-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.810',berat_out_asli='1.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.810',berat_akhir_asli =berat_akhir_asli-'1.810' WHERE kode_barang='PSGT-ZJXB-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-261002-0003','6','PSGT-ZJXB-51-0','1','1.780','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-51-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-51-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-51-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-51-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJXB-51-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.780',berat_out_asli='1.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.780',berat_akhir_asli =berat_akhir_asli-'1.780' WHERE kode_barang='PSGT-ZJXB-51-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0003','7','PSPRT-ZJXB-52-0','1','1.510','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-52-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-52-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-52-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-52-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJXB-52-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='PSPRT-ZJXB-52-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0003','8','PSPLT-ZJXB-53-0','1','2.540','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-53-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-53-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-53-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-53-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-ZJXB-53-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.540',berat_out_asli='2.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.540',berat_akhir_asli =berat_akhir_asli-'2.540' WHERE kode_barang='PSPLT-ZJXB-53-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-261002-0003','2026-10-02','2026-10-02','17:37','2.540','input','2026-10-02 17:37:47','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','1','PSPLT-ZJXB-3-0','1','2.220','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-3-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-3-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-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='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-ZJXB-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.220',berat_out_asli='2.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.220',berat_akhir_asli =berat_akhir_asli-'2.220' WHERE kode_barang='PSPLT-ZJXB-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-261002-0004','2','PSGT-ZJXB-4-0','1','2.630','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-4-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-4-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-4-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-4-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-ZJXB-4-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-ZJXB-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-261002-0004','3','PSGT-ZJXB-5-0','1','2.150','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-5-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-5-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-5-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-5-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-ZJXB-5-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-ZJXB-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-261002-0004','4','PSGT-ZJXB-6-0','1','2.200','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-6-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-6-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-6-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-6-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-ZJXB-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.200',berat_out_asli='2.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.200',berat_akhir_asli =berat_akhir_asli-'2.200' WHERE kode_barang='PSGT-ZJXB-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-261002-0004','5','PSPRT-ZJXB-7-0','1','1.510','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-7-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-7-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-7-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-7-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-7-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='PSPRT-ZJXB-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-261002-0004','6','PSPRT-ZJXB-8-0','1','3.160','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-8-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-8-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-8-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-8-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.160',berat_out_asli='3.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.160',berat_akhir_asli =berat_akhir_asli-'3.160' WHERE kode_barang='PSPRT-ZJXB-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-261002-0004','7','PSPRT-ZJXB-9-0','1','2.890','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-9-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-9-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-9-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-9-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.890',berat_out_asli='2.890', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.890',berat_akhir_asli =berat_akhir_asli-'2.890' WHERE kode_barang='PSPRT-ZJXB-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-261002-0004','8','PSPRT-ZJXB-10-0','1','3.080','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-10-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-10-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-10-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-10-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-ZJXB-10-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='PSPRT-ZJXB-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-261002-0004','9','PSPLT-ZJXB-16-0','1','2.150','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-16-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-16-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-16-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-16-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJXB-16-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='PSPLT-ZJXB-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-261002-0004','10','PSPRT-ZJXB-34-0','1','4.720','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-34-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-34-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-34-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-34-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-ZJXB-34-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.720',berat_out_asli='4.720', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.720',berat_akhir_asli =berat_akhir_asli-'4.720' WHERE kode_barang='PSPRT-ZJXB-34-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','11','PSPRT-ZJXB-35-0','1','3.850','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-35-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-35-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-35-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-35-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-ZJXB-35-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.850',berat_out_asli='3.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.850',berat_akhir_asli =berat_akhir_asli-'3.850' WHERE kode_barang='PSPRT-ZJXB-35-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','12','PSPRT-ZJXB-36-0','1','2.160','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-36-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-36-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-36-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-36-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-ZJXB-36-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.160',berat_out_asli='2.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.160',berat_akhir_asli =berat_akhir_asli-'2.160' WHERE kode_barang='PSPRT-ZJXB-36-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','13','PSPRT-ZJXB-37-0','1','3.010','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-37-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-37-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-37-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-37-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-ZJXB-37-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.010',berat_out_asli='3.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.010',berat_akhir_asli =berat_akhir_asli-'3.010' WHERE kode_barang='PSPRT-ZJXB-37-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','14','PSPRT-ZJXB-38-0','1','2.000','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-38-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-38-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-38-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-38-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-ZJXB-38-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.000',berat_out_asli='2.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.000',berat_akhir_asli =berat_akhir_asli-'2.000' WHERE kode_barang='PSPRT-ZJXB-38-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','15','PSPRT-ZJXB-39-0','1','2.130','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-39-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-39-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-39-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-39-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-ZJXB-39-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.130',berat_out_asli='2.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.130',berat_akhir_asli =berat_akhir_asli-'2.130' WHERE kode_barang='PSPRT-ZJXB-39-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','16','PSPRT-ZJXB-40-0','1','2.640','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-40-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-40-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-40-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-40-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-ZJXB-40-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.640',berat_out_asli='2.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.640',berat_akhir_asli =berat_akhir_asli-'2.640' WHERE kode_barang='PSPRT-ZJXB-40-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','17','PSPLT-ZJXB-54-0','1','3.300','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-54-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-54-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-54-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-54-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-ZJXB-54-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.300',berat_out_asli='3.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.300',berat_akhir_asli =berat_akhir_asli-'3.300' WHERE kode_barang='PSPLT-ZJXB-54-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','18','PSPLT-ZJXB-55-0','1','1.770','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-55-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-55-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-55-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-55-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-ZJXB-55-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.770',berat_out_asli='1.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.770',berat_akhir_asli =berat_akhir_asli-'1.770' WHERE kode_barang='PSPLT-ZJXB-55-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','19','PSPLT-ZJXB-56-0','1','2.350','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-56-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-56-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-56-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-56-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-ZJXB-56-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.350',berat_out_asli='2.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.350',berat_akhir_asli =berat_akhir_asli-'2.350' WHERE kode_barang='PSPLT-ZJXB-56-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','20','PSPLT-ZJXB-57-0','1','3.490','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-57-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-57-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-57-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-57-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-ZJXB-57-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.490',berat_out_asli='3.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.490',berat_akhir_asli =berat_akhir_asli-'3.490' WHERE kode_barang='PSPLT-ZJXB-57-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','21','PSGT-ZJXB-58-0','1','3.000','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-58-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-58-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-58-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-58-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-ZJXB-58-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='PSGT-ZJXB-58-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0004','22','PSGT-ZJXB-59-0','1','2.900','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-59-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-59-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-59-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-59-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-ZJXB-59-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.900',berat_out_asli='2.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.900',berat_akhir_asli =berat_akhir_asli-'2.900' WHERE kode_barang='PSGT-ZJXB-59-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-261002-0004','2026-10-02','2026-10-02','17:38','2.900','input','2026-10-02 17:37:59','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0005','1','PSPLT-ZJXB-17-0','1','3.000','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-17-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-17-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-17-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-17-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.000',berat_out_asli='3.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.000',berat_akhir_asli =berat_akhir_asli-'3.000' WHERE kode_barang='PSPLT-ZJXB-17-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0005','2','PSPRT-ZJXB-18-0','1','4.670','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-18-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-18-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-18-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.670',berat_out_asli='4.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.670',berat_akhir_asli =berat_akhir_asli-'4.670' WHERE kode_barang='PSPRT-ZJXB-18-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0005','3','PSPRT-ZJXB-19-0','1','2.880','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-19-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.880',berat_out_asli='2.880', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.880',berat_akhir_asli =berat_akhir_asli-'2.880' WHERE kode_barang='PSPRT-ZJXB-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-261002-0005','4','PSPRT-ZJXB-41-0','1','1.510','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-41-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-41-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-41-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-41-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-ZJXB-41-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='PSPRT-ZJXB-41-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0005','5','PSPRT-ZJXB-43-0','1','3.270','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-43-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-43-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-43-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-43-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-ZJXB-43-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.270',berat_out_asli='3.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.270',berat_akhir_asli =berat_akhir_asli-'3.270' WHERE kode_barang='PSPRT-ZJXB-43-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0005','6','PSPRT-ZJXB-44-0','1','3.180','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-44-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-44-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-44-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-44-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-ZJXB-44-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.180',berat_out_asli='3.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.180',berat_akhir_asli =berat_akhir_asli-'3.180' WHERE kode_barang='PSPRT-ZJXB-44-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0005','7','PSPRT-ZJXB-60-0','1','2.130','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-60-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-60-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-60-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-60-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-ZJXB-60-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.130',berat_out_asli='2.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.130',berat_akhir_asli =berat_akhir_asli-'2.130' WHERE kode_barang='PSPRT-ZJXB-60-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0005','8','PSPLT-ZJXB-61-0','1','1.950','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-61-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-61-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-61-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-61-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-ZJXB-61-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.950',berat_out_asli='1.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.950',berat_akhir_asli =berat_akhir_asli-'1.950' WHERE kode_barang='PSPLT-ZJXB-61-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-261002-0005','2026-10-02','2026-10-02','17:38','1.950','input','2026-10-02 17:38:14','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0006','1','PSPRT-ZJXB-20-0','1','2.280','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-20-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-20-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-20-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-20-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-20-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.280',berat_out_asli='2.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.280',berat_akhir_asli =berat_akhir_asli-'2.280' WHERE kode_barang='PSPRT-ZJXB-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-261002-0006','2','PSGT-ZJXB-21-0','1','2.050','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-21-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-21-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-21-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-21-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-21-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.050',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.050',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='PSGT-ZJXB-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-261002-0006','3','PSPLT-ZJXB-42-0','1','3.340','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-42-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-42-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-42-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-42-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-ZJXB-42-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.340',berat_out_asli='3.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.340',berat_akhir_asli =berat_akhir_asli-'3.340' WHERE kode_barang='PSPLT-ZJXB-42-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0006','4','PSGT-ZJXB-45-0','1','3.770','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-45-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-45-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-45-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-45-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-ZJXB-45-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.770',berat_out_asli='3.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.770',berat_akhir_asli =berat_akhir_asli-'3.770' WHERE kode_barang='PSGT-ZJXB-45-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0006','5','PSGT-ZJXB-46-0','1','1.560','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-46-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-46-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-46-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-46-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-ZJXB-46-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.560',berat_out_asli='1.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.560',berat_akhir_asli =berat_akhir_asli-'1.560' WHERE kode_barang='PSGT-ZJXB-46-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0006','6','PSPLT-ZJXB-47-0','1','3.950','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-47-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-47-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-47-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-47-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-47-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.950',berat_out_asli='3.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.950',berat_akhir_asli =berat_akhir_asli-'3.950' WHERE kode_barang='PSPLT-ZJXB-47-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0006','7','PSPLT-ZJXB-48-0','1','3.780','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-48-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-48-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-48-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-48-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-48-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.780',berat_out_asli='3.780', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.780',berat_akhir_asli =berat_akhir_asli-'3.780' WHERE kode_barang='PSPLT-ZJXB-48-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0006','8','PSPRT-ZJXB-49-0','1','2.420','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-49-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-49-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-49-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-49-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-ZJXB-49-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.420',berat_out_asli='2.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.420',berat_akhir_asli =berat_akhir_asli-'2.420' WHERE kode_barang='PSPRT-ZJXB-49-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0006','9','PSPLT-ZJXB-50-0','1','1.460','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-50-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-50-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-50-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-50-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXB-50-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.460',berat_out_asli='1.460', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.460',berat_akhir_asli =berat_akhir_asli-'1.460' WHERE kode_barang='PSPLT-ZJXB-50-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0006','10','PSPRT-ZJXB-62-0','1','2.060','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-62-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-62-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-62-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-62-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-ZJXB-62-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.060',berat_out_asli='2.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.060',berat_akhir_asli =berat_akhir_asli-'2.060' WHERE kode_barang='PSPRT-ZJXB-62-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-261002-0006','2026-10-02','2026-10-02','17:38','2.060','input','2026-10-02 17:38:26','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0007','1','PSPLT-ZJXB-22-0','1','2.170','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-22-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-22-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-22-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-22-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJXB-22-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='PSPLT-ZJXB-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-261002-0007','2','PSPRT-ZJXB-23-0','1','4.500','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-23-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-23-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-23-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-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='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJXB-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.500',berat_out_asli='4.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.500',berat_akhir_asli =berat_akhir_asli-'4.500' WHERE kode_barang='PSPRT-ZJXB-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-261002-0007','3','PSPLT-ZJXB-63-0','1','2.410','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXB-63-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXB-63-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXB-63-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXB-63-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='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJXB-63-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.410',berat_out_asli='2.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.410',berat_akhir_asli =berat_akhir_asli-'2.410' WHERE kode_barang='PSPLT-ZJXB-63-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0007','4','PSPRT-ZJXB-64-0','1','1.730','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXB-64-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXB-64-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXB-64-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXB-64-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='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJXB-64-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='PSPRT-ZJXB-64-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0007','5','PSGT-ZJXB-65-0','1','2.900','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-65-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-65-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-65-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-65-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='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJXB-65-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.900',berat_out_asli='2.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.900',berat_akhir_asli =berat_akhir_asli-'2.900' WHERE kode_barang='PSGT-ZJXB-65-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0007','6','PSGT-ZJXB-66-0','1','3.420','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXB-66-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXB-66-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXB-66-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXB-66-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='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJXB-66-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.420',berat_out_asli='3.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.420',berat_akhir_asli =berat_akhir_asli-'3.420' WHERE kode_barang='PSGT-ZJXB-66-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-261002-0007','2026-10-02','2026-10-02','17:38','3.420','input','2026-10-02 17:38:38','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0008','1','CKPDE-ZJXB-24-0','1','3.660','TOKO','CKPDE'); DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZJXB-24-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPDE-ZJXB-24-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKPDE-ZJXB-24-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPDE-ZJXB-24-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKPDE'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKPDE'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPDE-ZJXB-24-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.660',berat_out_asli='3.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.660',berat_akhir_asli =berat_akhir_asli-'3.660' WHERE kode_barang='CKPDE-ZJXB-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-261002-0008','2','CKPDE-ZJXB-25-0','1','4.210','TOKO','CKPDE'); DELETE FROM tm_barang_export WHERE kode_barang='CKPDE-ZJXB-25-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPDE-ZJXB-25-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKPDE-ZJXB-25-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPDE-ZJXB-25-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPDE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPDE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKPDE'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKPDE'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPDE-ZJXB-25-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.210',berat_out_asli='4.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.210',berat_akhir_asli =berat_akhir_asli-'4.210' WHERE kode_barang='CKPDE-ZJXB-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-261002-0008','2026-10-02','2026-10-02','17:38','4.210','input','2026-10-02 17:38:47','ELCO'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0009','1','PLDMM-ZJXB-26-0','1','2.430','TOKO','MMPLD'); DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZJXB-26-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZJXB-26-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZJXB-26-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZJXB-26-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZJXB-26-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.430',berat_out_asli='2.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.430',berat_akhir_asli =berat_akhir_asli-'2.430' WHERE kode_barang='PLDMM-ZJXB-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-261002-0009','2','PLDMM-ZJXB-27-0','1','3.450','TOKO','MMPLD'); DELETE FROM tm_barang_export WHERE kode_barang='PLDMM-ZJXB-27-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLDMM-ZJXB-27-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLDMM-ZJXB-27-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLDMM-ZJXB-27-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLDMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLDMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLDMM-ZJXB-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.450',berat_out_asli='3.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.450',berat_akhir_asli =berat_akhir_asli-'3.450' WHERE kode_barang='PLDMM-ZJXB-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-261002-0009','2026-10-02','2026-10-02','17:38','3.450','input','2026-10-02 17:38:58','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0010','1','PLBDG-ZJXB-28-0','1','3.400','TOKO','PLBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-ZJXB-28-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLBDG-ZJXB-28-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLBDG-ZJXB-28-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLBDG-ZJXB-28-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PLBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PLBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLBDG-ZJXB-28-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.400',berat_out_asli='3.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.400',berat_akhir_asli =berat_akhir_asli-'3.400' WHERE kode_barang='PLBDG-ZJXB-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-261002-0010','2','PLBDG-ZJXB-29-0','1','4.020','TOKO','PLBDG'); DELETE FROM tm_barang_export WHERE kode_barang='PLBDG-ZJXB-29-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLBDG-ZJXB-29-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLBDG-ZJXB-29-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLBDG-ZJXB-29-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLBDG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLBDG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PLBDG'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PLBDG'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLBDG-ZJXB-29-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.020',berat_out_asli='4.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.020',berat_akhir_asli =berat_akhir_asli-'4.020' WHERE kode_barang='PLBDG-ZJXB-29-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-261002-0010','2026-10-02','2026-10-02','17:39','4.020','input','2026-10-02 17:39:07','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0011','1','LXPLD-ZJXB-30-0','1','2.110','TOKO','DUPLD'); DELETE FROM tm_barang_export WHERE kode_barang='LXPLD-ZJXB-30-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPLD-ZJXB-30-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPLD-ZJXB-30-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPLD-ZJXB-30-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPLD-ZJXB-30-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='LXPLD-ZJXB-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-261002-0011','2','LXPLD-ZJXB-31-0','1','4.110','TOKO','DUPLD'); DELETE FROM tm_barang_export WHERE kode_barang='LXPLD-ZJXB-31-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPLD-ZJXB-31-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPLD-ZJXB-31-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPLD-ZJXB-31-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPLD-ZJXB-31-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.110',berat_out_asli='4.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.110',berat_akhir_asli =berat_akhir_asli-'4.110' WHERE kode_barang='LXPLD-ZJXB-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-261002-0011','2026-10-02','2026-10-02','17:39','4.110','input','2026-10-02 17:39:17','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261002-0012','1','PLSBY-ZJXB-32-0','1','3.500','TOKO','SBYPLD'); DELETE FROM tm_barang_export WHERE kode_barang='PLSBY-ZJXB-32-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PLSBY-ZJXB-32-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PLSBY-ZJXB-32-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PLSBY-ZJXB-32-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PLSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PLSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPLD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPLD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PLSBY-ZJXB-32-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='PLSBY-ZJXB-32-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-261002-0012','2026-10-02','2026-10-02','17:39','3.500','input','2026-10-02 17:39:26','THIFA');