INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-06 ','08:24:38'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-06','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-05'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-05'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-05'; 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-05' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-05'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-05'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-05'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-05'; 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-06' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-05' 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-06'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-06 ','08:25:00'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0001','1','CKPRE-ZJXE-29-0','1','4.120','TOKO','PER'); DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZJXE-29-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZJXE-29-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZJXE-29-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZJXE-29-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZJXE-29-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.120',berat_out_asli='4.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.120',berat_akhir_asli =berat_akhir_asli-'4.120' WHERE kode_barang='CKPRE-ZJXE-29-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0001','2','CKPRE-ZJXE-30-0','1','2.980','TOKO','PER'); DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZJXE-30-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZJXE-30-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZJXE-30-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZJXE-30-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZJXE-30-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.980',berat_out_asli='2.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.980',berat_akhir_asli =berat_akhir_asli-'2.980' WHERE kode_barang='CKPRE-ZJXE-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-261006-0001','3','CKPRE-ZJXE-31-0','1','2.790','TOKO','PER'); DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZJXE-31-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZJXE-31-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZJXE-31-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZJXE-31-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZJXE-31-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.790',berat_out_asli='2.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.790',berat_akhir_asli =berat_akhir_asli-'2.790' WHERE kode_barang='CKPRE-ZJXE-31-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0001','4','CKPRE-ZJXE-32-0','1','3.740','TOKO','PER'); DELETE FROM tm_barang_export WHERE kode_barang='CKPRE-ZJXE-32-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKPRE-ZJXE-32-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKPRE-ZJXE-32-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKPRE-ZJXE-32-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PER'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKPRE-ZJXE-32-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.740',berat_out_asli='3.740', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.740',berat_akhir_asli =berat_akhir_asli-'3.740' WHERE kode_barang='CKPRE-ZJXE-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-261006-0001','2026-10-06','2026-10-06','08:25','3.740','input','2026-10-06 08:25:22','ELCO'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0002','1','PMM-ZJXE-33-0','1','2.910','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJXE-33-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZJXE-33-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZJXE-33-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZJXE-33-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZJXE-33-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.910',berat_out_asli='2.910', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.910',berat_akhir_asli =berat_akhir_asli-'2.910' WHERE kode_barang='PMM-ZJXE-33-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0002','2','PMM-ZJXE-34-0','1','3.690','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJXE-34-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZJXE-34-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZJXE-34-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZJXE-34-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZJXE-34-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.690',berat_out_asli='3.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.690',berat_akhir_asli =berat_akhir_asli-'3.690' WHERE kode_barang='PMM-ZJXE-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-261006-0002','3','PMM-ZJXE-35-0','1','3.160','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJXE-35-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZJXE-35-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZJXE-35-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZJXE-35-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZJXE-35-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='PMM-ZJXE-35-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261006-0002','2026-10-06','2026-10-06','08:25','3.160','input','2026-10-06 08:25:36','THIFA'); 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-04035'; 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-ZJXF-1-0','00047929','DP-04035MM ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','411500','2026-10-06','411500','4.110','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-06 10:25:47','4.110','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04035MM','1','RS 27','','DP-04035'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-1-0','00047929'); 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-06','PSPRT-ZJXF-1-0','PSPRT','TOKO','MMPSN','100.00','4.110','4.110','1','4.110','4.110','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04035MM '); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-06 ','10:26:17'); 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-04014'; 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-ZJXF-2-0','00047930','DP-04014MM ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','415500','2026-10-06','415500','4.150','100.00','925','510000','100000.00','1','0.14', 'input','2026-10-06 10:27:49','4.150','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04014MM','1','RS 13 RS 18','','DP-04014'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-2-0','00047930'); 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-06','PSPRT-ZJXF-2-0','PSPRT','TOKO','MMPSN','100.00','4.150','4.150','1','4.150','4.150','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04014MM '); 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-03964'; 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-ZJXF-3-0','00047931','DP-03964MM ','CINCIN PERAK CM02 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','417000','2026-10-06','417000','4.170','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-06 10:29:45','4.170','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03964MM','1','RS 12 RS 30','','DP-03964'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-3-0','00047931'); 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-06','PSPRT-ZJXF-3-0','PSPRT','TOKO','MMPSN','100.00','4.170','4.170','1','4.170','4.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03964MM '); 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-04076'; 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-ZJXF-4-0','00047932','DP-04076BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','168000','2026-10-06','168000','1.680','100.00','925','370000','100000.00','1','0.14', 'input','2026-10-06 10:32:22','1.680','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04076BIP','1','RS 10','','DP-04076'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-4-0','00047932'); 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-06','PSPRT-ZJXF-4-0','PSPRT','TOKO','PSNB','100.00','1.680','1.680','1','1.680','1.680','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04076BIP '); 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-04038'; 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-ZJXF-5-0','00047933','DP-04038DU ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','DUPSN','2639500','2026-10-06','2639500','2.550','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-06 10:35:15','2.550','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04038DU','1','RS 19','','DP-04038'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXF-5-0','00047933'); 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-06','PSGT-ZJXF-5-0','PSGT','TOKO','DUPSN','45.00','2.550','2.550','1','2.550','2.550','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04038DU '); 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-04039'; 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-ZJXF-6-0','00047934','DP-04039DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','461500','2026-10-06','461500','2.260','17.00','10','250000','1200000.00','1','0.14', 'input','2026-10-06 10:36:44','2.260','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04039DU','1','RS 19','','DP-04039'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXF-6-0','00047934'); 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-06','PSPLT-ZJXF-6-0','PSPLT','TOKO','DUPSN','17.00','2.260','2.260','1','2.260','2.260','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04039DU '); 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-04033'; 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-ZJXF-7-0','00047935','DP-04033DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','232500','2026-10-06','232500','2.320','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-06 10:38:46','2.320','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04033DU','1','RS 17','','DP-04033'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-7-0','00047935'); 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-06','PSPRT-ZJXF-7-0','PSPRT','TOKO','DUPSN','100.00','2.320','2.320','1','2.320','2.320','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04033DU '); 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-04010'; 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-ZJXF-8-0','00047936','DP-04010DU ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','DUPSN','2845000','2026-10-06','2845000','2.170','57.00','50','260000','2300000.00','1','0.14', 'input','2026-10-06 10:40:23','2.170','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04010DU','1','RS 13','','DP-04010'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXF-8-0','00047936'); 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-06','PSGT-ZJXF-8-0','PSGT','TOKO','DUPSN','57.00','2.170','2.170','1','2.170','2.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04010DU '); 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-04019'; 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-ZJXF-9-0','00047937','DP-04019DU ','CINCIN PERAK SR03 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','342000','2026-10-06','342000','3.420','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-06 10:42:27','3.420','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04019DU','1','RS 145 RS 205','','DP-04019'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-9-0','00047937'); 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-06','PSPRT-ZJXF-9-0','PSPRT','TOKO','DUPSN','100.00','3.420','3.420','1','3.420','3.420','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04019DU '); 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-04093'; 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-ZJXF-10-0','00047938','DP-04093DU ','CINCIN PERAK SR01 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','318000','2026-10-06','318000','3.180','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-06 10:45:22','3.180','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04093DU','1','RS 12 RS 18','','DP-04093'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-10-0','00047938'); 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-06','PSPRT-ZJXF-10-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-04093DU '); 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-03972'; 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-ZJXF-11-0','00047939','DP-03972BIP ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','PSNB','17200500','2026-10-06','17200500','9.010','83.00','75','880000','2300000.00','1','0.14', 'input','2026-10-06 10:53:15','9.010','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03972BIP','1','RS 29 5','','DP-03972'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJXF-11-0','00047939'); 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-06','PSGT-ZJXF-11-0','PSGT','TOKO','PSNB','83.00','9.010','9.010','1','9.010','9.010','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-03972BIP '); 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-04012'; 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-ZJXF-12-0','00047940','DP-04012DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','350000','2026-10-06','350000','3.500','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-06 13:24:33','3.500','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04012DU','1','RS 23','','DP-04012'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-12-0','00047940'); 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-06','PSPRT-ZJXF-12-0','PSPRT','TOKO','DUPSN','100.00','3.500','3.500','1','3.500','3.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04012DU '); 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-04084'; 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-ZJXF-13-0','00047941','DP-04084DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','350000','2026-10-06','350000','3.500','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-06 13:25:59','3.500','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04084DU','1','RS 15','','DP-04084'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-13-0','00047941'); 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-06','PSPRT-ZJXF-13-0','PSPRT','TOKO','DUPSN','100.00','3.500','3.500','1','3.500','3.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04084DU '); 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-03976'; 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-ZJXF-14-0','00047942','DP-03976DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','400000','2026-10-06','400000','4.000','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-06 13:27:27','4.000','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03976DU','1','RS 21','','DP-03976'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-14-0','00047942'); 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-06','PSPRT-ZJXF-14-0','PSPRT','TOKO','DUPSN','100.00','4.000','4.000','1','4.000','4.000','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03976DU '); 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-04026'; 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-ZJXF-15-0','00047943','DP-04026DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','1133000','2026-10-06','1133000','2.950','32.00','25','250000','1200000.00','1','0.14', 'input','2026-10-06 13:28:56','2.950','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04026DU','1','RS 18 5','','DP-04026'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXF-15-0','00047943'); 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-06','PSPLT-ZJXF-15-0','PSPLT','TOKO','DUPSN','32.00','2.950','2.950','1','2.950','2.950','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04026DU '); 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-03974'; 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-ZJXF-16-0','00047944','DP-03974DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','202000','2026-10-06','202000','2.020','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-06 13:30:19','2.020','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03974DU','1','RS 18 5','','DP-03974'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-16-0','00047944'); 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-06','PSPRT-ZJXF-16-0','PSPRT','TOKO','DUPSN','100.00','2.020','2.020','1','2.020','2.020','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03974DU '); 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-04031'; 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-ZJXF-17-0','00047945','DP-04031DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','275500','2026-10-06','275500','1.350','17.00','10','530000','1200000.00','1','0.14', 'input','2026-10-06 13:32:10','1.350','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04031DU','1','RS 11 5','','DP-04031'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXF-17-0','00047945'); 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-06','PSPLT-ZJXF-17-0','PSPLT','TOKO','DUPSN','17.00','1.350','1.350','1','1.350','1.350','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04031DU '); 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-04225'; 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-ZJXF-18-0','00047946','DP-04225DU ','CINCIN PERAK SR02 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','358000','2026-10-06','358000','3.580','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-06 13:34:34','3.580','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04225DU','1','RS 95 RS 205','','DP-04225'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-18-0','00047946'); 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-06','PSPRT-ZJXF-18-0','PSPRT','TOKO','DUPSN','100.00','3.580','3.580','1','3.580','3.580','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04225DU '); 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-04120'; 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-ZJXF-19-0','00047947','DP-04120JOG ','CINCIN PERAK CM01 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','JOGPSN','388000','2026-10-06','388000','3.880','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-06 13:36:35','3.880','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04120JOG','1','RS 145 RS 18','','DP-04120'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-19-0','00047947'); 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-06','PSPRT-ZJXF-19-0','PSPRT','TOKO','JOGPSN','100.00','3.880','3.880','1','3.880','3.880','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04120JOG '); 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-03967'; 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-ZJXF-20-0','00047948','DP-03967DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','972000','2026-10-06','972000','2.530','32.00','25','260000','1200000.00','1','0.14', 'input','2026-10-06 14:36:49','2.530','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03967DU','1','RS 11','','DP-03967'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXF-20-0','00047948'); 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-06','PSPLT-ZJXF-20-0','PSPLT','TOKO','DUPSN','32.00','2.530','2.530','1','2.530','2.530','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03967DU '); 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-03984'; 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-ZJXF-21-0','00047949','DP-03984BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','437000','2026-10-06','437000','2.140','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-06 15:29:52','2.140','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03984BIP','1','RS 11 5','','DP-03984'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXF-21-0','00047949'); 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-06','PSPLT-ZJXF-21-0','PSPLT','TOKO','PSNB','17.00','2.140','2.140','1','2.140','2.140','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03984BIP '); 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-03983'; 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-ZJXF-22-0','00047950','DP-03983BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','453000','2026-10-06','453000','2.220','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-06 15:31:17','2.220','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03983BIP','1','RS 17','','DP-03983'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXF-22-0','00047950'); 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-06','PSPLT-ZJXF-22-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-03983BIP '); 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-04072'; 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 ('PSBRT-ZJXF-23-0','00047951','DP-04072SBY ','CINCIN BERLIAN ','','GR','---','PSBRT','PSBRT','TOKO','SBYPSN','4772500','2026-10-06','4772500','2.500','83.00','75','0','2300000.00','1','0.014', 'input','2026-10-06 15:35:23','2.500','350000','24.00','18000.00','','TOKO','FREETAG','','10','','','PSN04072SBY','1','RS 16','','DP-04072'); DELETE FROM tp_barang WHERE kode_dept = 'PSBRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSBRT','PSBRT-ZJXF-23-0','00047951'); 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-06','PSBRT-ZJXF-23-0','PSBRT','TOKO','SBYPSN','83.00','2.500','2.500','1','2.500','2.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSBRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSBRT','DP-04072SBY '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('PSBRT-ZJXF-23-0','00047951','RD','1','0.050 ','480','24'); 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-03124'; 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-ZJXF-24-0','00047952','DP-03124 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','297000','2026-10-06','297000','2.970','100.00','925','220000','100000.00','1','0.04', 'input','2026-10-06 15:36:58','2.970','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03124','1','RS 19 5','','DP-03124'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZJXF-24-0','00047952'); 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-06','PSPRE-ZJXF-24-0','PSPRE','TOKO','PSN','100.00','2.970','2.970','1','2.970','2.970','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03124 '); 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-04323'; 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-ZJXF-25-0','00047953','DP-04323DU ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','180000','2026-10-06','180000','1.800','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-06 15:55:05','1.800','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04323DU','1','RS 18 5','','DP-04323'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-25-0','00047953'); 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-06','PSPRT-ZJXF-25-0','PSPRT','TOKO','DUPSN','100.00','1.800','1.800','1','1.800','1.800','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04323DU '); 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-03997'; 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-ZJXF-26-0','00047954','DP-03997DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','696000','2026-10-06','696000','3.410','17.00','10','250000','1200000.00','1','0.14', 'input','2026-10-06 15:56:25','3.410','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03997DU','1','RS 15 5','','DP-03997'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXF-26-0','00047954'); 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-06','PSPLT-ZJXF-26-0','PSPLT','TOKO','DUPSN','17.00','3.410','3.410','1','3.410','3.410','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03997DU '); 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-03993'; 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-ZJXF-27-0','00047955','DP-03993DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','265000','2026-10-06','265000','2.650','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-06 15:58:01','2.650','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03993DU','1','RS 22','','DP-03993'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-27-0','00047955'); 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-06','PSPRT-ZJXF-27-0','PSPRT','TOKO','DUPSN','100.00','2.650','2.650','1','2.650','2.650','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03993DU '); 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-03966'; 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-ZJXF-28-0','00047956','DP-03966DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','382000','2026-10-06','382000','3.820','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-06 15:59:53','3.820','0','','18000.00','','TOKO','FREETAG','','2','','','PSN3966DU','1','RS 20 5','','DP-03966'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-28-0','00047956'); 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-06','PSPRT-ZJXF-28-0','PSPRT','TOKO','DUPSN','100.00','3.820','3.820','1','3.820','3.820','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03966DU '); 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-03968'; 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-ZJXF-29-0','00047957','DP-03968DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','1413500','2026-10-06','1413500','3.680','32.00','25','260000','1200000.00','1','0.14', 'input','2026-10-06 16:01:15','3.680','0','','18000.00','','TOKO','FREETAG','','10','','','PSN03968DU','1','RS 21 5','','DP-03968'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJXF-29-0','00047957'); 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-06','PSPLT-ZJXF-29-0','PSPLT','TOKO','DUPSN','32.00','3.680','3.680','1','3.680','3.680','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-03968DU '); 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-04037'; 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-ZJXF-30-0','00047958','DP-04037SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','339000','2026-10-06','339000','3.390','100.00','925','410000','100000.00','1','0.014', 'input','2026-10-06 16:05:05','3.390','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04037SBY','1','RS 22','','DP-04037'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-30-0','00047958'); 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-06','PSPRT-ZJXF-30-0','PSPRT','TOKO','SBYPSN','100.00','3.390','3.390','1','3.390','3.390','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04037SBY '); 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-04098'; 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-ZJXF-31-0','00047959','DP-04098SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','195000','2026-10-06','195000','1.950','100.00','925','200000','100000.00','1','0.014', 'input','2026-10-06 16:06:23','1.950','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04098SBY','1','RS 18','','DP-04098'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-31-0','00047959'); 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-06','PSPRT-ZJXF-31-0','PSPRT','TOKO','SBYPSN','100.00','1.950','1.950','1','1.950','1.950','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04098SBY '); 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-04266'; 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-ZJXF-32-0','00047960','DP-04266JOG ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','JOGPSN','361000','2026-10-06','361000','3.610','100.00','925','600000','100000.00','1','0.14', 'input','2026-10-06 16:09:40','3.610','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04266JOG','1','RS 13 RS 18','','DP-04266'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-32-0','00047960'); 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-06','PSPRT-ZJXF-32-0','PSPRT','TOKO','JOGPSN','100.00','3.610','3.610','1','3.610','3.610','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04266JOG '); 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-04163'; 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-ZJXF-33-0','00047961','DP-04163JOG ','1PS CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','JOGPSN','622000','2026-10-06','622000','6.220','100.00','925','520000','100000.00','1','0.14', 'input','2026-10-06 16:11:28','6.220','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04163JOG','1','RS 20 RS 125','','DP-04163'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJXF-33-0','00047961'); 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-06','PSPRT-ZJXF-33-0','PSPRT','TOKO','JOGPSN','100.00','6.220','6.220','1','6.220','6.220','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04163JOG '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0003','1','PSPRT-ZJXF-4-0','1','1.680','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-4-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-4-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-4-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-4-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJXF-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.680',berat_out_asli='1.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.680',berat_akhir_asli =berat_akhir_asli-'1.680' WHERE kode_barang='PSPRT-ZJXF-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-261006-0003','2','PSGT-ZJXF-11-0','1','9.010','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXF-11-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXF-11-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXF-11-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXF-11-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-ZJXF-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='9.010',berat_out_asli='9.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'9.010',berat_akhir_asli =berat_akhir_asli-'9.010' WHERE kode_barang='PSGT-ZJXF-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-261006-0003','3','PSPLT-ZJXF-21-0','1','2.140','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXF-21-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXF-21-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXF-21-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXF-21-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJXF-21-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.140',berat_out_asli='2.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.140',berat_akhir_asli =berat_akhir_asli-'2.140' WHERE kode_barang='PSPLT-ZJXF-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-261006-0003','4','PSPLT-ZJXF-22-0','1','2.220','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXF-22-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXF-22-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXF-22-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXF-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='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-ZJXF-22-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-ZJXF-22-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-261006-0003','2026-10-06','2026-10-06','16:29','2.220','input','2026-10-06 16:29:18','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0004','1','PSGT-ZJXF-5-0','1','2.550','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXF-5-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXF-5-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXF-5-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXF-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='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJXF-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.550',berat_out_asli='2.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.550',berat_akhir_asli =berat_akhir_asli-'2.550' WHERE kode_barang='PSGT-ZJXF-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-261006-0004','2','PSPLT-ZJXF-6-0','1','2.260','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXF-6-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXF-6-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXF-6-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXF-6-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJXF-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.260',berat_out_asli='2.260', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.260',berat_akhir_asli =berat_akhir_asli-'2.260' WHERE kode_barang='PSPLT-ZJXF-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-261006-0004','3','PSPRT-ZJXF-7-0','1','2.320','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-7-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-7-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-7-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-7-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJXF-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.320',berat_out_asli='2.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.320',berat_akhir_asli =berat_akhir_asli-'2.320' WHERE kode_barang='PSPRT-ZJXF-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-261006-0004','4','PSGT-ZJXF-8-0','1','2.170','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJXF-8-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJXF-8-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJXF-8-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJXF-8-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJXF-8-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='PSGT-ZJXF-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-261006-0004','5','PSPRT-ZJXF-9-0','1','3.420','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-9-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-9-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-9-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-9-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJXF-9-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='PSPRT-ZJXF-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-261006-0004','6','PSPRT-ZJXF-10-0','1','3.180','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-10-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-10-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-10-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-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='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-ZJXF-10-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-ZJXF-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-261006-0004','7','PSPRT-ZJXF-12-0','1','3.500','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-12-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-12-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-12-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-12-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXF-12-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='PSPRT-ZJXF-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-261006-0004','8','PSPRT-ZJXF-13-0','1','3.500','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-13-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-13-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-13-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-13-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-ZJXF-13-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='PSPRT-ZJXF-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-261006-0004','9','PSPRT-ZJXF-14-0','1','4.000','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-14-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-14-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-14-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-14-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-ZJXF-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.000',berat_out_asli='4.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.000',berat_akhir_asli =berat_akhir_asli-'4.000' WHERE kode_barang='PSPRT-ZJXF-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-261006-0004','10','PSPLT-ZJXF-15-0','1','2.950','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXF-15-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXF-15-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXF-15-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXF-15-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXF-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.950',berat_out_asli='2.950', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.950',berat_akhir_asli =berat_akhir_asli-'2.950' WHERE kode_barang='PSPLT-ZJXF-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-261006-0004','11','PSPRT-ZJXF-16-0','1','2.020','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-16-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-16-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-16-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-16-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-ZJXF-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.020',berat_out_asli='2.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.020',berat_akhir_asli =berat_akhir_asli-'2.020' WHERE kode_barang='PSPRT-ZJXF-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-261006-0004','12','PSPLT-ZJXF-17-0','1','1.350','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXF-17-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXF-17-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXF-17-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXF-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-ZJXF-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.350',berat_out_asli='1.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.350',berat_akhir_asli =berat_akhir_asli-'1.350' WHERE kode_barang='PSPLT-ZJXF-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-261006-0004','13','PSPRT-ZJXF-18-0','1','3.580','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-18-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-18-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-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-ZJXF-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.580',berat_out_asli='3.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.580',berat_akhir_asli =berat_akhir_asli-'3.580' WHERE kode_barang='PSPRT-ZJXF-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-261006-0004','14','PSPLT-ZJXF-20-0','1','2.530','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXF-20-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXF-20-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXF-20-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXF-20-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJXF-20-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.530',berat_out_asli='2.530', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.530',berat_akhir_asli =berat_akhir_asli-'2.530' WHERE kode_barang='PSPLT-ZJXF-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-261006-0004','15','PSPRT-ZJXF-25-0','1','1.800','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-25-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-25-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-25-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-25-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-ZJXF-25-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.800',berat_out_asli='1.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.800',berat_akhir_asli =berat_akhir_asli-'1.800' WHERE kode_barang='PSPRT-ZJXF-25-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0004','16','PSPLT-ZJXF-26-0','1','3.410','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXF-26-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXF-26-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXF-26-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXF-26-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXF-26-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.410',berat_out_asli='3.410', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.410',berat_akhir_asli =berat_akhir_asli-'3.410' WHERE kode_barang='PSPLT-ZJXF-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-261006-0004','17','PSPRT-ZJXF-27-0','1','2.650','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-27-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-27-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-27-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-27-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-ZJXF-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.650',berat_out_asli='2.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.650',berat_akhir_asli =berat_akhir_asli-'2.650' WHERE kode_barang='PSPRT-ZJXF-27-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0004','18','PSPRT-ZJXF-28-0','1','3.820','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-28-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-28-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-28-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-28-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXF-28-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.820',berat_out_asli='3.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.820',berat_akhir_asli =berat_akhir_asli-'3.820' WHERE kode_barang='PSPRT-ZJXF-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-261006-0004','19','PSPLT-ZJXF-29-0','1','3.680','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXF-29-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXF-29-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXF-29-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXF-29-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-ZJXF-29-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.680',berat_out_asli='3.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.680',berat_akhir_asli =berat_akhir_asli-'3.680' WHERE kode_barang='PSPLT-ZJXF-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-261006-0004','2026-10-06','2026-10-06','16:29','3.680','input','2026-10-06 16:29:28','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0005','1','PSPRT-ZJXF-19-0','1','3.880','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-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='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-ZJXF-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.880',berat_out_asli='3.880', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.880',berat_akhir_asli =berat_akhir_asli-'3.880' WHERE kode_barang='PSPRT-ZJXF-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-261006-0005','2','PSPRT-ZJXF-32-0','1','3.610','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-32-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-32-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-32-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-32-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-ZJXF-32-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.610',berat_out_asli='3.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.610',berat_akhir_asli =berat_akhir_asli-'3.610' WHERE kode_barang='PSPRT-ZJXF-32-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0005','3','PSPRT-ZJXF-33-0','1','6.220','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-33-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-33-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-33-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-33-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-ZJXF-33-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='6.220',berat_out_asli='6.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'6.220',berat_akhir_asli =berat_akhir_asli-'6.220' WHERE kode_barang='PSPRT-ZJXF-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-261006-0005','2026-10-06','2026-10-06','16:29','6.220','input','2026-10-06 16:29:44','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261006-0006','1','PSBRT-ZJXF-23-0','1','2.500','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSBRT-ZJXF-23-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBRT-ZJXF-23-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSBRT-ZJXF-23-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBRT-ZJXF-23-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSBRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSBRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBRT' 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='PSBRT-ZJXF-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.500',berat_out_asli='2.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.500',berat_akhir_asli =berat_akhir_asli-'2.500' WHERE kode_barang='PSBRT-ZJXF-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-261006-0006','2','PSPRT-ZJXF-30-0','1','3.390','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-30-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-30-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-30-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-30-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXF-30-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.390',berat_out_asli='3.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.390',berat_akhir_asli =berat_akhir_asli-'3.390' WHERE kode_barang='PSPRT-ZJXF-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-261006-0006','3','PSPRT-ZJXF-31-0','1','1.950','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXF-31-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXF-31-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXF-31-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXF-31-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJXF-31-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='PSPRT-ZJXF-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-261006-0006','2026-10-06','2026-10-06','16:30','1.950','input','2026-10-06 16:30:01','THIFA');