INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-27 ','08:36:04'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-27','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-26'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-26'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-26'; 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-26' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-26'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-26'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-26'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-26'; 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-27' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-26' 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-27'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-27 ','08:36:54'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0001','1','PMM-ZJBF-9-0','1','3.210','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJBF-9-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZJBF-9-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZJBF-9-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZJBF-9-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZJBF-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.210',berat_out_asli='3.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.210',berat_akhir_asli =berat_akhir_asli-'3.210' WHERE kode_barang='PMM-ZJBF-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-261027-0001','2','PMM-ZJBF-10-0','1','3.520','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZJBF-10-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZJBF-10-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZJBF-10-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZJBF-10-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZJBF-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.520',berat_out_asli='3.520', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.520',berat_akhir_asli =berat_akhir_asli-'3.520' WHERE kode_barang='PMM-ZJBF-10-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-261027-0001','2026-10-27','2026-10-27','08:37','3.520','input','2026-10-27 08:37:43','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=''; 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 ('LXPER-ZJBG-1-0','00048655','500K-12-00664 ','CINCIN SILVER 925 YL01 ','','GR','---','PER','LXPER','TOKO','DUPER','177000','2026-10-27','177000','1.770','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-27 09:26:30','1.770','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-1-0','00048655'); 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-27','LXPER-ZJBG-1-0','LXPER','TOKO','DUPER','100.00','1.770','1.770','1','1.770','1.770','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','500K-12-00664 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-2-0','00048656','750K-10-00665 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','157000','2026-10-27','157000','1.570','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-27 09:27:23','1.570','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-2-0','00048656'); 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-27','LXPER-ZJBG-2-0','LXPER','TOKO','DUPER','100.00','1.570','1.570','1','1.570','1.570','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-10-00665 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-3-0','00048657','750K-125-00666 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','151000','2026-10-27','151000','1.510','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 09:28:11','1.510','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-3-0','00048657'); 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-27','LXPER-ZJBG-3-0','LXPER','TOKO','DUPER','100.00','1.510','1.510','1','1.510','1.510','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-125-00666 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-4-0','00048658','750K-115-00667 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','168000','2026-10-27','168000','1.680','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 09:28:53','1.680','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-4-0','00048658'); 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-27','LXPER-ZJBG-4-0','LXPER','TOKO','DUPER','100.00','1.680','1.680','1','1.680','1.680','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-115-00667 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-5-0','00048659','750K-17-00668 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','224500','2026-10-27','224500','2.240','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-27 09:29:32','2.240','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-5-0','00048659'); 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-27','LXPER-ZJBG-5-0','LXPER','TOKO','DUPER','100.00','2.240','2.240','1','2.240','2.240','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-17-00668 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-6-0','00048660','750K-105-00669 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','154000','2026-10-27','154000','1.540','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 09:30:26','1.540','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-6-0','00048660'); 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-27','LXPER-ZJBG-6-0','LXPER','TOKO','DUPER','100.00','1.540','1.540','1','1.540','1.540','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-105-00669 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-7-0','00048661','750K-145-00670 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','125000','2026-10-27','125000','1.250','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 09:31:54','1.250','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-7-0','00048661'); 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-27','LXPER-ZJBG-7-0','LXPER','TOKO','DUPER','100.00','1.250','1.250','1','1.250','1.250','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-145-00670 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-8-0','00048662','750K-135-00671 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','176000','2026-10-27','176000','1.760','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 09:32:30','1.760','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-8-0','00048662'); 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-27','LXPER-ZJBG-8-0','LXPER','TOKO','DUPER','100.00','1.760','1.760','1','1.760','1.760','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-135-00671 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-9-0','00048663','750K-105-00672 ','CINCIN SILVER 925 SR02 ','','GR','---','PER','LXPER','TOKO','DUPER','163000','2026-10-27','163000','1.630','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 09:33:35','1.630','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-9-0','00048663'); 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-27','LXPER-ZJBG-9-0','LXPER','TOKO','DUPER','100.00','1.630','1.630','1','1.630','1.630','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-105-00672 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-10-0','00048664','800K-28-00673 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','355000','2026-10-27','355000','3.550','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-27 09:34:16','3.550','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-10-0','00048664'); 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-27','LXPER-ZJBG-10-0','LXPER','TOKO','DUPER','100.00','3.550','3.550','1','3.550','3.550','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','800K-28-00673 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-11-0','00048665','800K-225-00674 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','347000','2026-10-27','347000','3.470','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-27 09:34:39','3.470','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-11-0','00048665'); 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-27','LXPER-ZJBG-11-0','LXPER','TOKO','DUPER','100.00','3.470','3.470','1','3.470','3.470','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','800K-225-00674 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-12-0','00048666','800K-225-00675 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','406500','2026-10-27','406500','4.060','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-27 09:35:15','4.060','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-12-0','00048666'); 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-27','LXPER-ZJBG-12-0','LXPER','TOKO','DUPER','100.00','4.060','4.060','1','4.060','4.060','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','800K-225-00675 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-13-0','00048667','800K-19-00676 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','388000','2026-10-27','388000','3.880','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-27 09:36:00','3.880','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-13-0','00048667'); 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-27','LXPER-ZJBG-13-0','LXPER','TOKO','DUPER','100.00','3.880','3.880','1','3.880','3.880','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','800K-19-00676 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-14-0','00048668','800K-20-00677 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','282000','2026-10-27','282000','2.820','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-27 09:36:37','2.820','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-14-0','00048668'); 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-27','LXPER-ZJBG-14-0','LXPER','TOKO','DUPER','100.00','2.820','2.820','1','2.820','2.820','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','800K-20-00677 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-15-0','00048669','850K-125-00678 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','138000','2026-10-27','138000','1.380','100.00','925','370000','100000.00','1','0.14', 'input','2026-10-27 09:37:23','1.380','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-15-0','00048669'); 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-27','LXPER-ZJBG-15-0','LXPER','TOKO','DUPER','100.00','1.380','1.380','1','1.380','1.380','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','850K-125-00678 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-16-0','00048670','850K-12-00679 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','179000','2026-10-27','179000','1.790','100.00','925','270000','100000.00','1','0.14', 'input','2026-10-27 09:38:05','1.790','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-16-0','00048670'); 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-27','LXPER-ZJBG-16-0','LXPER','TOKO','DUPER','100.00','1.790','1.790','1','1.790','1.790','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','850K-12-00679 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-17-0','00048671','900K-105-00680 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','167000','2026-10-27','167000','1.670','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-27 09:38:48','1.670','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-17-0','00048671'); 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-27','LXPER-ZJBG-17-0','LXPER','TOKO','DUPER','100.00','1.670','1.670','1','1.670','1.670','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','900K-105-00680 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-18-0','00048672','900K-125-00681 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','142000','2026-10-27','142000','1.420','100.00','925','300000','100000.00','1','0.14', 'input','2026-10-27 09:39:35','1.420','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-18-0','00048672'); 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-27','LXPER-ZJBG-18-0','LXPER','TOKO','DUPER','100.00','1.420','1.420','1','1.420','1.420','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','900K-125-00681 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-19-0','00048673','950K-8-00682 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','136000','2026-10-27','136000','1.360','100.00','925','430000','100000.00','1','0.14', 'input','2026-10-27 09:40:12','1.360','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-19-0','00048673'); 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-27','LXPER-ZJBG-19-0','LXPER','TOKO','DUPER','100.00','1.360','1.360','1','1.360','1.360','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','950K-8-00682 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('LXPER-ZJBG-20-0','00048674','1.0K-15-00683 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','338000','2026-10-27','338000','3.380','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 09:40:54','3.380','0','','18000.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXPER' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXPER','LXPER-ZJBG-20-0','00048674'); 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-27','LXPER-ZJBG-20-0','LXPER','TOKO','DUPER','100.00','3.380','3.380','1','3.380','3.380','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','1.0K-15-00683 '); 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-03149'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGE-ZJBG-21-0','00048675','DP-03149 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','1759500','2026-10-27','1759500','1.700','45.00','375','370000','2300000.00','1','0.04', 'input','2026-10-27 10:54:47','1.700','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03149','1','RS 13','','DP-03149'); DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-ZJBG-21-0','00048675'); 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-27','PSGE-ZJBG-21-0','PSGE','TOKO','PSN','45.00','1.700','1.700','1','1.700','1.700','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-03149 '); 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-03151'; 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-ZJBG-22-0','00048676','DP-03151 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','228500','2026-10-27','228500','2.280','100.00','925','230000','100000.00','1','0.04', 'input','2026-10-27 10:56:13','2.280','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03151','1','RS 16','','DP-03151'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZJBG-22-0','00048676'); 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-27','PSPRE-ZJBG-22-0','PSPRE','TOKO','PSN','100.00','2.280','2.280','1','2.280','2.280','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03151 '); 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-03146'; 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-ZJBG-23-0','00048677','DP-03146 ','CINCIN PERAK CM01 ','','GR','---','PSPRE','PSPRE','TOKO','PSN','360000','2026-10-27','360000','3.600','100.00','925','410000','100000.00','1','0.04', 'input','2026-10-27 10:58:28','3.600','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03146','1','RS 21 RS 19','','DP-03146'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZJBG-23-0','00048677'); 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-27','PSPRE-ZJBG-23-0','PSPRE','TOKO','PSN','100.00','3.600','3.600','1','3.600','3.600','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03146 '); 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-03150'; 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-ZJBG-24-0','00048678','DP-03150 ','CINCIN PERAK SR02 YL01 ','','GR','---','PSPRE','PSPRE','TOKO','PSN','307000','2026-10-27','307000','3.070','100.00','925','410000','100000.00','1','0.04', 'input','2026-10-27 11:00:16','3.070','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03150','1','RS 9 RS 17 5','','DP-03150'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZJBG-24-0','00048678'); 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-27','PSPRE-ZJBG-24-0','PSPRE','TOKO','PSN','100.00','3.070','3.070','1','3.070','3.070','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03150 '); 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-04717'; 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-ZJBG-25-0','00048679','DP-04717MM ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','1912500','2026-10-27','1912500','4.980','32.00','25','260000','1200000.00','1','0.14', 'input','2026-10-27 11:04:27','4.980','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04717MM','1','RS 19','','DP-04717'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBG-25-0','00048679'); 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-27','PSPLT-ZJBG-25-0','PSPLT','TOKO','MMPSN','32.00','4.980','4.980','1','4.980','4.980','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04717MM '); 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-04398'; 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-ZJBG-26-0','00048680','DP-04398MM ','CINCIN PALDAIUM ','','GR','---','PSPLT','PSPLT','TOKO','MMPSN','741000','2026-10-27','741000','3.630','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-27 11:06:01','3.630','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04398MM','1','RS 16','','DP-04398'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBG-26-0','00048680'); 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-27','PSPLT-ZJBG-26-0','PSPLT','TOKO','MMPSN','17.00','3.630','3.630','1','3.630','3.630','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04398MM '); 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-04393'; 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-ZJBG-27-0','00048681','DP-04393MM ','CINCIN PERAK SR03 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','351000','2026-10-27','351000','3.510','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-27 11:08:16','3.510','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04393MM','1','RS 18 RS 25','','DP-04393'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-27-0','00048681'); 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-27','PSPRT-ZJBG-27-0','PSPRT','TOKO','MMPSN','100.00','3.510','3.510','1','3.510','3.510','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04393MM '); 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-04378'; 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-ZJBG-28-0','00048682','DP-04378MM ','CINCIN PERAK CP03 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','420000','2026-10-27','420000','4.200','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-27 11:10:06','4.200','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04378MM','1','RS 155 RS 245','','DP-04378'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-28-0','00048682'); 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-27','PSPRT-ZJBG-28-0','PSPRT','TOKO','MMPSN','100.00','4.200','4.200','1','4.200','4.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04378MM '); UPDATE tp_curr SET rp= '18200.00' WHERE curr = 'USD' LIMIT 1; INSERT INTO th_troy_curr(curr,rp,input_by,input_date) VALUES ('USD', '18200.00', 'input','2026-10-27 13:16:59'); UPDATE tm_group SET nama_group='DIAMOND',jenis_group='TUA',harga='2270000',status_berlian='1',edit_by='input',edit_date='2026-10-27 13:17:49' WHERE kode_group='DM'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'2270000' WHERE stock_on_hand*1> 0 AND kode_group='DM'; UPDATE tm_group SET nama_group='GOLD',jenis_group='TUA',harga='2270000',status_berlian='0',edit_by='input',edit_date='2026-10-27 13:17:55' WHERE kode_group='GOLD'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'2270000' WHERE stock_on_hand*1> 0 AND kode_group='GOLD'; UPDATE tm_group SET nama_group='PSN BERLIAN ELCO',jenis_group='TUA',harga='2270000',status_berlian='1',edit_by='input',edit_date='2026-10-27 13:18:05' WHERE kode_group='PSBRE'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'2270000' WHERE stock_on_hand*1> 0 AND kode_group='PSBRE'; UPDATE tm_group SET nama_group='PSN BERLIAN LUXIA',jenis_group='TUA',harga='2270000',status_berlian='1',edit_by='input',edit_date='2026-10-27 13:18:10' WHERE kode_group='PSBRL'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'2270000' WHERE stock_on_hand*1> 0 AND kode_group='PSBRL'; UPDATE tm_group SET nama_group='PSN BERLIAN THIFA',jenis_group='TUA',harga='2270000',status_berlian='1',edit_by='input',edit_date='2026-10-27 13:18:17' WHERE kode_group='PSBRT'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'2270000' WHERE stock_on_hand*1> 0 AND kode_group='PSBRT'; UPDATE tm_group SET nama_group='PSN GOLD ELCO',jenis_group='TUA',harga='2270000',status_berlian='0',edit_by='input',edit_date='2026-10-27 13:18:24' WHERE kode_group='PSGE'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'2270000' WHERE stock_on_hand*1> 0 AND kode_group='PSGE'; UPDATE tm_group SET nama_group='PSN GOLD LUXIA',jenis_group='TUA',harga='2270000',status_berlian='0',edit_by='input',edit_date='2026-10-27 13:18:30' WHERE kode_group='PSGL'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'2270000' WHERE stock_on_hand*1> 0 AND kode_group='PSGL'; UPDATE tm_group SET nama_group='PSN GOLD THIFA',jenis_group='TUA',harga='2270000',status_berlian='0',edit_by='input',edit_date='2026-10-27 13:18:35' WHERE kode_group='PSGT'; UPDATE tm_barang SET harga_jual= (kadar/100)*berat *'2270000' WHERE stock_on_hand*1> 0 AND kode_group='PSGT'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-27 ','13:24:11'); 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-04700'; 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-ZJBG-29-0','00048683','DP-04700DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','282000','2026-10-27','282000','2.820','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 15:38:17','2.820','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04700DU','1','RS 15 5','','DP-04700'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-29-0','00048683'); 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-27','PSPRT-ZJBG-29-0','PSPRT','TOKO','DUPSN','100.00','2.820','2.820','1','2.820','2.820','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04700DU '); 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-04601'; 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-ZJBG-30-0','00048684','DP-04601DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','216000','2026-10-27','216000','2.160','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-27 15:39:36','2.160','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04601DU','1','RS 18','','DP-04601'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-30-0','00048684'); 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-27','PSPRT-ZJBG-30-0','PSPRT','TOKO','DUPSN','100.00','2.160','2.160','1','2.160','2.160','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04601DU '); 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-03141'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGE-ZJBG-31-0','00048685','DP-03141 ','CINCIN EMAS ','','GR','---','PSGE','PSGE','TOKO','PSN','7913500','2026-10-27','7913500','4.200','83.00','75','740000','2270000.00','1','0.04', 'input','2026-10-27 16:11:52','4.200','0','','18200.00','','TOKO','FREETAG','','2','','','PSN03141','1','RS 18','','DP-03141'); DELETE FROM tp_barang WHERE kode_dept = 'PSGE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGE','PSGE-ZJBG-31-0','00048685'); 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-27','PSGE-ZJBG-31-0','PSGE','TOKO','PSN','83.00','4.200','4.200','1','4.200','4.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGE','DP-03141 '); 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-04356'; 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-ZJBG-32-0','00048686','DP-04356MM ','CINCIN PERAK SR05 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','295000','2026-10-27','295000','2.950','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-27 16:14:37','2.950','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04356MM','1','RS 11 RS 165','','DP-04356'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-32-0','00048686'); 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-27','PSPRT-ZJBG-32-0','PSPRT','TOKO','MMPSN','100.00','2.950','2.950','1','2.950','2.950','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04356MM '); 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-04674'; 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-ZJBG-33-0','00048687','DP-04674BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','344000','2026-10-27','344000','3.440','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 16:16:40','3.440','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04674BIP','1','RS 19','','DP-04674'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-33-0','00048687'); 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-27','PSPRT-ZJBG-33-0','PSPRT','TOKO','PSNB','100.00','3.440','3.440','1','3.440','3.440','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04674BIP '); 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-04615'; 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-ZJBG-34-0','00048688','DP-04615BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','221000','2026-10-27','221000','2.210','100.00','925','230000','100000.00','1','0.14', 'input','2026-10-27 16:18:08','2.210','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04615BIP','1','RS 6','','DP-04615'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-34-0','00048688'); 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-27','PSPRT-ZJBG-34-0','PSPRT','TOKO','PSNB','100.00','2.210','2.210','1','2.210','2.210','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04615BIP '); 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-04578'; 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-ZJBG-35-0','00048689','DP-04578BIP ','CINCIN PERAK CP03 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','403000','2026-10-27','403000','4.030','100.00','925','420000','100000.00','1','0.14', 'input','2026-10-27 16:19:57','4.030','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04578BIP','1','RS 115 RS 20','','DP-04578'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-35-0','00048689'); 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-27','PSPRT-ZJBG-35-0','PSPRT','TOKO','PSNB','100.00','4.030','4.030','1','4.030','4.030','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04578BIP '); 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-04600'; 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-ZJBG-36-0','00048690','DP-04600DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','158000','2026-10-27','158000','1.580','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-27 16:22:45','1.580','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04600DU','1','RS 17 5','','DP-04600'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-36-0','00048690'); 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-27','PSPRT-ZJBG-36-0','PSPRT','TOKO','DUPSN','100.00','1.580','1.580','1','1.580','1.580','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04600DU '); 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-04544'; 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-ZJBG-37-0','00048691','DP-04544JOG ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','1498000','2026-10-27','1498000','3.900','32.00','25','250000','1200000.00','1','0.14', 'input','2026-10-27 16:25:04','3.900','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04544JOG','1','RS 18','','DP-04544'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBG-37-0','00048691'); 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-27','PSPLT-ZJBG-37-0','PSPLT','TOKO','JOGPSN','32.00','3.900','3.900','1','3.900','3.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04544JOG '); 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-04371'; 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-ZJBG-38-0','00048692','DP-04371JOG ','CINCIN PERAK CP11 ','','GR','---','PSPRT','PSPRT','TOKO','JOGPSN','287000','2026-10-27','287000','2.870','100.00','925','640000','100000.00','1','0.14', 'input','2026-10-27 16:27:25','2.870','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04371JOG','1','RS 11 RS 155','','DP-04371'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-38-0','00048692'); 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-27','PSPRT-ZJBG-38-0','PSPRT','TOKO','JOGPSN','100.00','2.870','2.870','1','2.870','2.870','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04371JOG '); 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-04466'; 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-ZJBG-39-0','00048693','DP-04466DU ','CINCIN PERAK SR03 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','309000','2026-10-27','309000','3.090','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-27 16:46:34','3.090','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04466DU','1','RS 8 RS 18','','DP-04466'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-39-0','00048693'); 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-27','PSPRT-ZJBG-39-0','PSPRT','TOKO','DUPSN','100.00','3.090','3.090','1','3.090','3.090','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04466DU '); 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-04697'; 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-ZJBG-40-0','00048694','DP-04697DU ','CINCIN PERAK SR03 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','359000','2026-10-27','359000','3.590','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-27 16:48:37','3.590','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04697DU','1','RS 13 RS 255','','DP-04697'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-40-0','00048694'); 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-27','PSPRT-ZJBG-40-0','PSPRT','TOKO','DUPSN','100.00','3.590','3.590','1','3.590','3.590','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04697DU '); 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-04479'; 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-ZJBG-41-0','00048695','DP-04479SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','328000','2026-10-27','328000','3.280','100.00','925','200000','100000.00','1','0.014', 'input','2026-10-27 16:50:49','3.280','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04479SBY','1','RS 19','','DP-04479'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-41-0','00048695'); 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-27','PSPRT-ZJBG-41-0','PSPRT','TOKO','SBYPSN','100.00','3.280','3.280','1','3.280','3.280','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04479SBY '); 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-04704'; 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-ZJBG-42-0','00048696','DP-04704SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','696000','2026-10-27','696000','3.410','17.00','10','250000','1200000.00','1','0.014', 'input','2026-10-27 16:52:17','3.410','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04704SBY','1','RS 21 5','','DP-04704'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBG-42-0','00048696'); 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-27','PSPLT-ZJBG-42-0','PSPLT','TOKO','SBYPSN','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-04704SBY '); 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-04455'; 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-ZJBG-43-0','00048697','DP-04455JOG ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','571500','2026-10-27','571500','2.800','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-27 16:54:48','2.800','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04455JOG','1','RS 23 5','','DP-04455'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBG-43-0','00048697'); 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-27','PSPLT-ZJBG-43-0','PSPLT','TOKO','JOGPSN','17.00','2.800','2.800','1','2.800','2.800','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04455JOG '); 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-04495'; 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-ZJBG-44-0','00048698','DP-04495JOG ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','663500','2026-10-27','663500','3.250','17.00','10','250000','1200000.00','1','0.14', 'input','2026-10-27 16:56:07','3.250','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04495JOG','1','RS 20','','DP-04495'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBG-44-0','00048698'); 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-27','PSPLT-ZJBG-44-0','PSPLT','TOKO','JOGPSN','17.00','3.250','3.250','1','3.250','3.250','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04495JOG '); 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-04475'; 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-ZJBG-45-0','00048699','DP-04475JOG ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','JOGPSN','337000','2026-10-27','337000','3.370','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-27 16:58:52','3.370','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04475JOG','1','RS 155 RS 24','','DP-04475'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-45-0','00048699'); 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-27','PSPRT-ZJBG-45-0','PSPRT','TOKO','JOGPSN','100.00','3.370','3.370','1','3.370','3.370','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04475JOG '); 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-04822'; 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-ZJBG-46-0','00048700','DP-04822BIP ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','299000','2026-10-27','299000','2.990','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-27 17:05:43','2.990','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04822BIP','1','RS 12 RS 14','','DP-04822'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-46-0','00048700'); 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-27','PSPRT-ZJBG-46-0','PSPRT','TOKO','PSNB','100.00','2.990','2.990','1','2.990','2.990','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04822BIP '); 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-04442'; 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-ZJBG-47-0','00048701','DP-04442SBY ','CINCIN PERAK SR04 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','295000','2026-10-27','295000','2.950','100.00','925','410000','100000.00','1','0.014', 'input','2026-10-27 17:15:05','2.950','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04442SBY','1','RS 13 RS 125','','DP-04442'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBG-47-0','00048701'); 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-27','PSPRT-ZJBG-47-0','PSPRT','TOKO','SBYPSN','100.00','2.950','2.950','1','2.950','2.950','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04442SBY '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0002','1','PSPRT-ZJBG-33-0','1','3.440','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-33-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-33-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-33-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-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='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-ZJBG-33-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.440',berat_out_asli='3.440', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.440',berat_akhir_asli =berat_akhir_asli-'3.440' WHERE kode_barang='PSPRT-ZJBG-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-261027-0002','2','PSPRT-ZJBG-34-0','1','2.210','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-34-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-34-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-34-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-34-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJBG-34-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.210',berat_out_asli='2.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.210',berat_akhir_asli =berat_akhir_asli-'2.210' WHERE kode_barang='PSPRT-ZJBG-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-261027-0002','3','PSPRT-ZJBG-35-0','1','4.030','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-35-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-35-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-35-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-35-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJBG-35-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.030',berat_out_asli='4.030', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.030',berat_akhir_asli =berat_akhir_asli-'4.030' WHERE kode_barang='PSPRT-ZJBG-35-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0002','4','PSPRT-ZJBG-46-0','1','2.990','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-46-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-46-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-46-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-46-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-ZJBG-46-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.990',berat_out_asli='2.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.990',berat_akhir_asli =berat_akhir_asli-'2.990' WHERE kode_barang='PSPRT-ZJBG-46-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-261027-0002','2026-10-27','2026-10-27','17:17','2.990','input','2026-10-27 17:17:34','THIFA'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-27 ','17:17:58'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0003','1','PSPRT-ZJBG-29-0','1','2.820','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-29-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-29-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-29-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-29-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBG-29-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.820',berat_out_asli='2.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.820',berat_akhir_asli =berat_akhir_asli-'2.820' WHERE kode_barang='PSPRT-ZJBG-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-261027-0003','2','PSPRT-ZJBG-30-0','1','2.160','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-30-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-30-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-30-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-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='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-ZJBG-30-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.160',berat_out_asli='2.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.160',berat_akhir_asli =berat_akhir_asli-'2.160' WHERE kode_barang='PSPRT-ZJBG-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-261027-0003','3','PSPRT-ZJBG-36-0','1','1.580','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-36-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-36-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-36-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-36-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBG-36-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.580',berat_out_asli='1.580', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.580',berat_akhir_asli =berat_akhir_asli-'1.580' WHERE kode_barang='PSPRT-ZJBG-36-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0003','4','PSPRT-ZJBG-39-0','1','3.090','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-39-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-39-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-39-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-39-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBG-39-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.090',berat_out_asli='3.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.090',berat_akhir_asli =berat_akhir_asli-'3.090' WHERE kode_barang='PSPRT-ZJBG-39-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0003','5','PSPRT-ZJBG-40-0','1','3.590','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-40-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-40-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-40-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-40-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBG-40-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.590',berat_out_asli='3.590', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.590',berat_akhir_asli =berat_akhir_asli-'3.590' WHERE kode_barang='PSPRT-ZJBG-40-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-261027-0003','2026-10-27','2026-10-27','17:18','3.590','input','2026-10-27 17:18:09','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0004','1','PSPRT-ZJBG-41-0','1','3.280','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-41-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-41-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-41-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-41-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBG-41-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.280',berat_out_asli='3.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.280',berat_akhir_asli =berat_akhir_asli-'3.280' WHERE kode_barang='PSPRT-ZJBG-41-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0004','2','PSPLT-ZJBG-42-0','1','3.410','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-42-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-42-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-42-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-42-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJBG-42-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-ZJBG-42-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0004','3','PSPRT-ZJBG-47-0','1','2.950','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-47-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-47-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-47-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-47-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-ZJBG-47-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='PSPRT-ZJBG-47-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-261027-0004','2026-10-27','2026-10-27','17:18','2.950','input','2026-10-27 17:18:23','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0005','1','PSPLT-ZJBG-37-0','1','3.900','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-37-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-37-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-37-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-37-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJBG-37-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.900',berat_out_asli='3.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.900',berat_akhir_asli =berat_akhir_asli-'3.900' WHERE kode_barang='PSPLT-ZJBG-37-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0005','2','PSPRT-ZJBG-38-0','1','2.870','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-38-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-38-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-38-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-38-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBG-38-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.870',berat_out_asli='2.870', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.870',berat_akhir_asli =berat_akhir_asli-'2.870' WHERE kode_barang='PSPRT-ZJBG-38-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0005','3','PSPLT-ZJBG-43-0','1','2.800','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-43-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-43-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-43-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-43-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJBG-43-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.800',berat_out_asli='2.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.800',berat_akhir_asli =berat_akhir_asli-'2.800' WHERE kode_barang='PSPLT-ZJBG-43-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0005','4','PSPLT-ZJBG-44-0','1','3.250','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBG-44-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBG-44-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBG-44-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBG-44-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJBG-44-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.250',berat_out_asli='3.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.250',berat_akhir_asli =berat_akhir_asli-'3.250' WHERE kode_barang='PSPLT-ZJBG-44-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0005','5','PSPRT-ZJBG-45-0','1','3.370','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBG-45-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBG-45-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBG-45-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBG-45-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-ZJBG-45-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.370',berat_out_asli='3.370', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.370',berat_akhir_asli =berat_akhir_asli-'3.370' WHERE kode_barang='PSPRT-ZJBG-45-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261027-0005','2026-10-27','2026-10-27','17:18','3.370','input','2026-10-27 17:18:34','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0006','1','LXPER-ZJBG-1-0','1','1.770','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-1-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-1-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-1-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.770',berat_out_asli='1.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.770',berat_akhir_asli =berat_akhir_asli-'1.770' WHERE kode_barang='LXPER-ZJBG-1-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0006','2','LXPER-ZJBG-2-0','1','1.570','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-2-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-2-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-2-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.570',berat_out_asli='1.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.570',berat_akhir_asli =berat_akhir_asli-'1.570' WHERE kode_barang='LXPER-ZJBG-2-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0006','3','LXPER-ZJBG-3-0','1','1.510','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-3-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-3-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-3-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.510',berat_out_asli='1.510', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.510',berat_akhir_asli =berat_akhir_asli-'1.510' WHERE kode_barang='LXPER-ZJBG-3-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261027-0006','4','LXPER-ZJBG-4-0','1','1.680','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-4-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-4-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-4-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-4-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-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='LXPER-ZJBG-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-261027-0006','5','LXPER-ZJBG-5-0','1','2.240','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-5-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-5-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-5-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-5-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.240',berat_out_asli='2.240', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.240',berat_akhir_asli =berat_akhir_asli-'2.240' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','6','LXPER-ZJBG-6-0','1','1.540','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-6-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-6-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-6-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-6-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.540',berat_out_asli='1.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.540',berat_akhir_asli =berat_akhir_asli-'1.540' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','7','LXPER-ZJBG-7-0','1','1.250','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-7-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-7-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-7-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-7-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.250',berat_out_asli='1.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.250',berat_akhir_asli =berat_akhir_asli-'1.250' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','8','LXPER-ZJBG-8-0','1','1.760','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-8-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-8-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-8-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-8-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.760',berat_out_asli='1.760', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.760',berat_akhir_asli =berat_akhir_asli-'1.760' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','9','LXPER-ZJBG-9-0','1','1.630','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-9-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-9-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-9-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-9-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.630',berat_out_asli='1.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.630',berat_akhir_asli =berat_akhir_asli-'1.630' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','10','LXPER-ZJBG-10-0','1','3.550','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-10-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-10-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-10-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-10-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.550',berat_out_asli='3.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.550',berat_akhir_asli =berat_akhir_asli-'3.550' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','11','LXPER-ZJBG-11-0','1','3.470','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-11-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-11-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-11-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-11-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.470',berat_out_asli='3.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.470',berat_akhir_asli =berat_akhir_asli-'3.470' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','12','LXPER-ZJBG-12-0','1','4.060','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-12-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-12-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-12-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-12-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-12-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.060',berat_out_asli='4.060', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.060',berat_akhir_asli =berat_akhir_asli-'4.060' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','13','LXPER-ZJBG-13-0','1','3.880','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-13-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-13-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-13-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-13-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-13-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='LXPER-ZJBG-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-261027-0006','14','LXPER-ZJBG-14-0','1','2.820','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-14-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-14-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-14-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-14-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.820',berat_out_asli='2.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.820',berat_akhir_asli =berat_akhir_asli-'2.820' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','15','LXPER-ZJBG-15-0','1','1.380','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-15-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-15-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-15-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-15-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.380',berat_out_asli='1.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.380',berat_akhir_asli =berat_akhir_asli-'1.380' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','16','LXPER-ZJBG-16-0','1','1.790','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-16-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-16-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-16-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-16-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='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.790',berat_out_asli='1.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.790',berat_akhir_asli =berat_akhir_asli-'1.790' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','17','LXPER-ZJBG-17-0','1','1.670','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-17-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-17-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-17-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-17-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='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.670',berat_out_asli='1.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.670',berat_akhir_asli =berat_akhir_asli-'1.670' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','18','LXPER-ZJBG-18-0','1','1.420','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-18-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-18-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-18-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='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.420',berat_out_asli='1.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.420',berat_akhir_asli =berat_akhir_asli-'1.420' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','19','LXPER-ZJBG-19-0','1','1.360','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-19-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='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.360',berat_out_asli='1.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.360',berat_akhir_asli =berat_akhir_asli-'1.360' WHERE kode_barang='LXPER-ZJBG-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-261027-0006','20','LXPER-ZJBG-20-0','1','3.380','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJBG-20-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJBG-20-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJBG-20-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJBG-20-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='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZJBG-20-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.380',berat_out_asli='3.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.380',berat_akhir_asli =berat_akhir_asli-'3.380' WHERE kode_barang='LXPER-ZJBG-20-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-261027-0006','2026-10-27','2026-10-27','17:18','3.380','input','2026-10-27 17:18:46','THIFA');