INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','08:08:54'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-10','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-09'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-09'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-09'; 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-09' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-09'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-09'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-09'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-09'; 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-10' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-09' 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-10'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','08:09:50'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-11','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-10'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-10'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-10'; 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-10' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-10'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-10'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-10'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-10'; 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-11' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-10' 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-11'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','08:10:13'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-12','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-11'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-11'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-11'; 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-11' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-11'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-11'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-11'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-11'; 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-12' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-11' 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-12'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','08:10:35'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','08:16:06'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','08:38:17'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0001','1','PSPRT-ZJXH-3-0','1','4.360','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJXH-3-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJXH-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJXH-3-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJXH-3-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJXH-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.360',berat_out_asli='4.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.360',berat_akhir_asli =berat_akhir_asli-'4.360' WHERE kode_barang='PSPRT-ZJXH-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-261012-0001','2','PSPLT-ZJXH-11-0','1','1.850','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXH-11-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXH-11-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXH-11-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXH-11-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJXH-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.850',berat_out_asli='1.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.850',berat_akhir_asli =berat_akhir_asli-'1.850' WHERE kode_barang='PSPLT-ZJXH-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-261012-0001','3','PSPLT-ZJXH-23-0','1','3.350','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJXH-23-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJXH-23-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJXH-23-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJXH-23-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJXH-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.350',berat_out_asli='3.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.350',berat_akhir_asli =berat_akhir_asli-'3.350' WHERE kode_barang='PSPLT-ZJXH-23-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-261012-0001','2026-10-12','2026-10-12','09:09','3.350','input','2026-10-12 09:09:22','THIFA'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','09:15:28'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','09:15:50'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','09:16:02'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','09:16:56'); 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-04277'; 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-ZJAB-1-0','00048084','DP-04277BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','639000','2026-10-12','639000','3.130','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-12 10:26:17','3.130','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04277BIP','1','RS 19','','DP-04277'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJAB-1-0','00048084'); 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-12','PSPLT-ZJAB-1-0','PSPLT','TOKO','PSNB','17.00','3.130','3.130','1','3.130','3.130','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04277BIP '); 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-04313'; 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-ZJAB-2-0','00048085','DP-04313BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','416000','2026-10-12','416000','4.160','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-12 10:27:57','4.160','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04313BIP','1','RS 18','','DP-04313'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-2-0','00048085'); 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-12','PSPRT-ZJAB-2-0','PSPRT','TOKO','PSNB','100.00','4.160','4.160','1','4.160','4.160','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04313BIP '); 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-04137'; 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-ZJAB-3-0','00048086','DP-04137BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','133000','2026-10-12','133000','1.330','100.00','925','310000','100000.00','1','0.14', 'input','2026-10-12 10:29:36','1.330','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04137BIP','1','RS 9 5','','DP-04137'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-3-0','00048086'); 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-12','PSPRT-ZJAB-3-0','PSPRT','TOKO','PSNB','100.00','1.330','1.330','1','1.330','1.330','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04137BIP '); 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-04227'; 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-ZJAB-4-0','00048087','DP-04227BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','304000','2026-10-12','304000','1.490','17.00','10','270000','1200000.00','1','0.14', 'input','2026-10-12 10:30:59','1.490','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04227BIP','1','RS 11','','DP-04227'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJAB-4-0','00048087'); 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-12','PSPLT-ZJAB-4-0','PSPLT','TOKO','PSNB','17.00','1.490','1.490','1','1.490','1.490','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04227BIP '); 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-04454'; 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-ZJAB-5-0','00048088','DP-04454BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','469500','2026-10-12','469500','2.300','17.00','10','430000','1200000.00','1','0.14', 'input','2026-10-12 10:32:41','2.300','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04454BIP','1','RS 19','','DP-04454'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJAB-5-0','00048088'); 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-12','PSPLT-ZJAB-5-0','PSPLT','TOKO','PSNB','17.00','2.300','2.300','1','2.300','2.300','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04454BIP '); 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-04456'; 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-ZJAB-6-0','00048089','DP-04456BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','802000','2026-10-12','802000','3.930','17.00','10','250000','1200000.00','1','0.14', 'input','2026-10-12 10:34:03','3.930','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04456BIP','1','RS 18','','DP-04456'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJAB-6-0','00048089'); 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-12','PSPLT-ZJAB-6-0','PSPLT','TOKO','PSNB','17.00','3.930','3.930','1','3.930','3.930','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04456BIP '); 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-04114'; 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-ZJAB-7-0','00048090','DP-04114DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','356000','2026-10-12','356000','3.560','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-12 10:50:40','3.560','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04114DU','1','RS 18','','DP-04114'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-7-0','00048090'); 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-12','PSPRT-ZJAB-7-0','PSPRT','TOKO','DUPSN','100.00','3.560','3.560','1','3.560','3.560','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04114DU '); 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-04104'; 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-ZJAB-8-0','00048091','DP-04104DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','286000','2026-10-12','286000','1.400','17.00','10','400000','1200000.00','1','0.14', 'input','2026-10-12 10:52:36','1.400','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04104DU','1','RS 8 5','','DP-04104'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJAB-8-0','00048091'); 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-12','PSPLT-ZJAB-8-0','PSPLT','TOKO','DUPSN','17.00','1.400','1.400','1','1.400','1.400','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04104DU '); 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-04091'; 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-ZJAB-9-0','00048092','DP-04091DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','220500','2026-10-12','220500','2.200','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-12 10:54:51','2.200','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04091DU','1','RS 24','','DP-04091'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-9-0','00048092'); 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-12','PSPRT-ZJAB-9-0','PSPRT','TOKO','DUPSN','100.00','2.200','2.200','1','2.200','2.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04091DU '); 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-04105'; 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-ZJAB-10-0','00048093','DP-04105DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','140000','2026-10-12','140000','1.400','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-12 10:56:15','1.400','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04105DU','1','RS 13 5','','DP-04105'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-10-0','00048093'); 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-12','PSPRT-ZJAB-10-0','PSPRT','TOKO','DUPSN','100.00','1.400','1.400','1','1.400','1.400','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04105DU '); 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-04067'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZJAB-11-0','00048094','DP-04067SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','2491000','2026-10-12','2491000','1.900','57.00','50','300000','2300000.00','1','0.014', 'input','2026-10-12 11:00:00','1.900','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04067SBY','1','RS 12 5','','DP-04067'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJAB-11-0','00048094'); 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-12','PSGT-ZJAB-11-0','PSGT','TOKO','SBYPSN','57.00','1.900','1.900','1','1.900','1.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04067SBY '); 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-04170'; 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-ZJAB-12-0','00048095','DP-04170SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','347000','2026-10-12','347000','1.700','17.00','10','480000','1200000.00','1','0.014', 'input','2026-10-12 11:01:58','1.700','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04170SBY','1','RS 9 5','','DP-04170'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJAB-12-0','00048095'); 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-12','PSPLT-ZJAB-12-0','PSPLT','TOKO','SBYPSN','17.00','1.700','1.700','1','1.700','1.700','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04170SBY '); 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-04422'; 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-ZJAB-13-0','00048096','DP-04422SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','402500','2026-10-12','402500','4.020','100.00','925','200000','100000.00','1','0.014', 'input','2026-10-12 11:03:21','4.020','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04422SBY','1','RS 19','','DP-04422'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-13-0','00048096'); 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-12','PSPRT-ZJAB-13-0','PSPRT','TOKO','SBYPSN','100.00','4.020','4.020','1','4.020','4.020','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04422SBY '); 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-04395'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZJAB-14-0','00048097','DP-04395SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','6681500','2026-10-12','6681500','3.500','83.00','75','250000','2300000.00','1','0.014', 'input','2026-10-12 11:04:44','3.500','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04395SBY','1','RS 26','','DP-04395'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJAB-14-0','00048097'); 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-12','PSGT-ZJAB-14-0','PSGT','TOKO','SBYPSN','83.00','3.500','3.500','1','3.500','3.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04395SBY '); 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-04396'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZJAB-15-0','00048098','DP-04396SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','3971000','2026-10-12','3971000','2.080','83.00','75','430000','2300000.00','1','0.014', 'input','2026-10-12 11:26:02','2.080','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04396SBY','1','RS 19','','DP-04396'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJAB-15-0','00048098'); 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-12','PSGT-ZJAB-15-0','PSGT','TOKO','SBYPSN','83.00','2.080','2.080','1','2.080','2.080','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04396SBY '); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-12 ','13:41:21'); 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-04062'; 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-ZJAB-16-0','00048099','DP-04062BIP ','CINCIN PERAK YL10 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','512000','2026-10-12','512000','5.120','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-12 15:45:04','5.120','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04062BIP','1','RS 26','','DP-04062'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-16-0','00048099'); 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-12','PSPRT-ZJAB-16-0','PSPRT','TOKO','PSNB','100.00','5.120','5.120','1','5.120','5.120','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04062BIP '); 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-04174'; 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-ZJAB-17-0','00048100','DP-04174BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','343000','2026-10-12','343000','3.430','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-12 15:46:32','3.430','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04174BIP','1','RS 18','','DP-04174'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-17-0','00048100'); 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-12','PSPRT-ZJAB-17-0','PSPRT','TOKO','PSNB','100.00','3.430','3.430','1','3.430','3.430','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04174BIP '); 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-04176'; 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-ZJAB-18-0','00048101','DP-04176BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','230500','2026-10-12','230500','2.300','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-12 15:48:00','2.300','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04176BIP','1','RS 14','','DP-04176'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-18-0','00048101'); 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-12','PSPRT-ZJAB-18-0','PSPRT','TOKO','PSNB','100.00','2.300','2.300','1','2.300','2.300','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04176BIP '); 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-04191'; 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-ZJAB-19-0','00048102','DP-04191BIP ','CINCIN PERAK SR04 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','320000','2026-10-12','320000','3.200','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-12 15:49:50','3.200','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04191BIP','1','RS 95 RS 165','','DP-04191'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-19-0','00048102'); 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-12','PSPRT-ZJAB-19-0','PSPRT','TOKO','PSNB','100.00','3.200','3.200','1','3.200','3.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04191BIP '); 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-04108'; 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-ZJAB-20-0','00048103','DP-04108DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','181000','2026-10-12','181000','1.810','100.00','925','740000','100000.00','1','0.14', 'input','2026-10-12 15:57:23','1.810','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04108DU','1','RS 13 5','','DP-04108'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-20-0','00048103'); 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-12','PSPRT-ZJAB-20-0','PSPRT','TOKO','DUPSN','100.00','1.810','1.810','1','1.810','1.810','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04108DU '); 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-04129'; 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-ZJAB-21-0','00048104','DP-04129DU ','CINCIN PALADIUM YL10 ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','875500','2026-10-12','875500','4.290','17.00','10','250000','1200000.00','1','0.14', 'input','2026-10-12 15:59:00','4.290','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04129DU','1','RS 19','','DP-04129'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJAB-21-0','00048104'); 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-12','PSPLT-ZJAB-21-0','PSPLT','TOKO','DUPSN','17.00','4.290','4.290','1','4.290','4.290','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04129DU '); 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-03965'; 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-ZJAB-22-0','00048105','DP-03965DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','217000','2026-10-12','217000','2.170','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-12 16:00:23','2.170','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03965DU','1','RS 8','','DP-03965'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-22-0','00048105'); 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-12','PSPRT-ZJAB-22-0','PSPRT','TOKO','DUPSN','100.00','2.170','2.170','1','2.170','2.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-03965DU '); 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-04183'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZJAB-23-0','00048106','DP-04183DU ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','DUPSN','2153000','2026-10-12','2153000','2.080','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-12 16:01:52','2.080','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04183DU','1','RS 14 5','','DP-04183'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJAB-23-0','00048106'); 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-12','PSGT-ZJAB-23-0','PSGT','TOKO','DUPSN','45.00','2.080','2.080','1','2.080','2.080','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04183DU '); 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-04097'; 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-ZJAB-24-0','00048107','DP-04097DU ','CINCIN PERAK SR02 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','337000','2026-10-12','337000','3.370','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-12 16:03:34','3.370','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04097DU','1','RS 16 RS 16','','DP-04097'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-24-0','00048107'); 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-12','PSPRT-ZJAB-24-0','PSPRT','TOKO','DUPSN','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-04097DU '); 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-04125'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSGT-ZJAB-25-0','00048108','DP-04125SBY ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','SBYPSN','4156000','2026-10-12','4156000','3.170','57.00','50','440000','2300000.00','1','0.014', 'input','2026-10-12 16:05:25','3.170','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04125SBY','1','RS 12','','DP-04125'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJAB-25-0','00048108'); 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-12','PSGT-ZJAB-25-0','PSGT','TOKO','SBYPSN','57.00','3.170','3.170','1','3.170','3.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04125SBY '); 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-ZJAB-26-0','00048109','750K-12-00640 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','116500','2026-10-12','116500','1.160','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-12 16:10:45','1.160','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-ZJAB-26-0','00048109'); 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-12','LXPER-ZJAB-26-0','LXPER','TOKO','DUPER','100.00','1.160','1.160','1','1.160','1.160','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-12-00640 '); 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-ZJAB-27-0','00048110','750K-135-00641 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','162000','2026-10-12','162000','1.620','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-12 16:11:34','1.620','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-ZJAB-27-0','00048110'); 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-12','LXPER-ZJAB-27-0','LXPER','TOKO','DUPER','100.00','1.620','1.620','1','1.620','1.620','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-135-00641 '); 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-ZJAB-28-0','00048111','750K-10-00642 ','CINCIN SILVER 925 ','','GR','---','PER','LXPER','TOKO','DUPER','171000','2026-10-12','171000','1.710','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-12 16:12:18','1.710','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-ZJAB-28-0','00048111'); 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-12','LXPER-ZJAB-28-0','LXPER','TOKO','DUPER','100.00','1.710','1.710','1','1.710','1.710','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXPER'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXPER','750K-10-00642 '); 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-04403'; 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-ZJAB-29-0','00048112','DP-04403SBY ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','205500','2026-10-12','205500','2.050','100.00','925','200000','100000.00','1','0.014', 'input','2026-10-12 16:42:09','2.050','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04403SBY','1','RS 19','','DP-04403'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJAB-29-0','00048112'); 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-12','PSPRT-ZJAB-29-0','PSPRT','TOKO','SBYPSN','100.00','2.050','2.050','1','2.050','2.050','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04403SBY '); 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-04169'; 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-ZJAB-30-0','00048113','DP-04169SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','885500','2026-10-12','885500','4.340','17.00','10','250000','1200000.00','1','0.014', 'input','2026-10-12 16:43:27','4.340','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04169SBY','1','RS 21 5','','DP-04169'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJAB-30-0','00048113'); 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-12','PSPLT-ZJAB-30-0','PSPLT','TOKO','SBYPSN','17.00','4.340','4.340','1','4.340','4.340','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04169SBY '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0002','1','PSPLT-ZJAB-1-0','1','3.130','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-1-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-1-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-1-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJAB-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.130',berat_out_asli='3.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.130',berat_akhir_asli =berat_akhir_asli-'3.130' WHERE kode_barang='PSPLT-ZJAB-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-261012-0002','2','PSPRT-ZJAB-2-0','1','4.160','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-2-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-2-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-2-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJAB-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.160',berat_out_asli='4.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.160',berat_akhir_asli =berat_akhir_asli-'4.160' WHERE kode_barang='PSPRT-ZJAB-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-261012-0002','3','PSPRT-ZJAB-3-0','1','1.330','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-3-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-3-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-3-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJAB-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.330',berat_out_asli='1.330', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.330',berat_akhir_asli =berat_akhir_asli-'1.330' WHERE kode_barang='PSPRT-ZJAB-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-261012-0002','4','PSPLT-ZJAB-4-0','1','1.490','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-4-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-4-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-4-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-4-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJAB-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.490',berat_out_asli='1.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.490',berat_akhir_asli =berat_akhir_asli-'1.490' WHERE kode_barang='PSPLT-ZJAB-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-261012-0002','5','PSPLT-ZJAB-5-0','1','2.300','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-5-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-5-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-5-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-5-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJAB-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.300',berat_out_asli='2.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.300',berat_akhir_asli =berat_akhir_asli-'2.300' WHERE kode_barang='PSPLT-ZJAB-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-261012-0002','6','PSPLT-ZJAB-6-0','1','3.930','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-6-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-6-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-6-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-6-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJAB-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.930',berat_out_asli='3.930', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.930',berat_akhir_asli =berat_akhir_asli-'3.930' WHERE kode_barang='PSPLT-ZJAB-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-261012-0002','7','PSPRT-ZJAB-16-0','1','5.120','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-16-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-16-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-16-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-16-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJAB-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.120',berat_out_asli='5.120', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.120',berat_akhir_asli =berat_akhir_asli-'5.120' WHERE kode_barang='PSPRT-ZJAB-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-261012-0002','8','PSPRT-ZJAB-17-0','1','3.430','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-17-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-17-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-17-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-17-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-ZJAB-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.430',berat_out_asli='3.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.430',berat_akhir_asli =berat_akhir_asli-'3.430' WHERE kode_barang='PSPRT-ZJAB-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-261012-0002','9','PSPRT-ZJAB-18-0','1','2.300','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-18-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-18-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-18-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJAB-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.300',berat_out_asli='2.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.300',berat_akhir_asli =berat_akhir_asli-'2.300' WHERE kode_barang='PSPRT-ZJAB-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-261012-0002','10','PSPRT-ZJAB-19-0','1','3.200','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-19-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJAB-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.200',berat_out_asli='3.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.200',berat_akhir_asli =berat_akhir_asli-'3.200' WHERE kode_barang='PSPRT-ZJAB-19-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261012-0002','2026-10-12','2026-10-12','16:46','3.200','input','2026-10-12 16:46:00','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0003','1','PSPRT-ZJAB-7-0','1','3.560','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-7-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-7-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-7-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-7-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJAB-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.560',berat_out_asli='3.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.560',berat_akhir_asli =berat_akhir_asli-'3.560' WHERE kode_barang='PSPRT-ZJAB-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-261012-0003','2','PSPLT-ZJAB-8-0','1','1.400','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-8-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-8-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-8-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-8-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJAB-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.400',berat_out_asli='1.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.400',berat_akhir_asli =berat_akhir_asli-'1.400' WHERE kode_barang='PSPLT-ZJAB-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-261012-0003','3','PSPRT-ZJAB-9-0','1','2.200','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-9-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-9-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-9-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-9-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJAB-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.200',berat_out_asli='2.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.200',berat_akhir_asli =berat_akhir_asli-'2.200' WHERE kode_barang='PSPRT-ZJAB-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-261012-0003','4','PSPRT-ZJAB-10-0','1','1.400','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-10-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-10-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-10-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-10-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJAB-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.400',berat_out_asli='1.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.400',berat_akhir_asli =berat_akhir_asli-'1.400' WHERE kode_barang='PSPRT-ZJAB-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-261012-0003','5','PSPRT-ZJAB-20-0','1','1.810','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-20-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-20-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-20-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-20-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJAB-20-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.810',berat_out_asli='1.810', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.810',berat_akhir_asli =berat_akhir_asli-'1.810' WHERE kode_barang='PSPRT-ZJAB-20-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0003','6','PSPLT-ZJAB-21-0','1','4.290','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-21-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-21-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-21-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-21-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJAB-21-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.290',berat_out_asli='4.290', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.290',berat_akhir_asli =berat_akhir_asli-'4.290' WHERE kode_barang='PSPLT-ZJAB-21-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0003','7','PSPRT-ZJAB-22-0','1','2.170','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-22-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-22-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-22-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-22-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-ZJAB-22-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='PSPRT-ZJAB-22-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0003','8','PSGT-ZJAB-23-0','1','2.080','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAB-23-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJAB-23-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAB-23-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJAB-23-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJAB-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.080',berat_out_asli='2.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.080',berat_akhir_asli =berat_akhir_asli-'2.080' WHERE kode_barang='PSGT-ZJAB-23-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0003','9','PSPRT-ZJAB-24-0','1','3.370','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-24-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-24-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-24-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-24-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJAB-24-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-ZJAB-24-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-261012-0003','2026-10-12','2026-10-12','16:46','3.370','input','2026-10-12 16:46:12','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0004','1','PSGT-ZJAB-11-0','1','1.900','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAB-11-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJAB-11-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAB-11-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJAB-11-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJAB-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.900',berat_out_asli='1.900', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.900',berat_akhir_asli =berat_akhir_asli-'1.900' WHERE kode_barang='PSGT-ZJAB-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-261012-0004','2','PSPLT-ZJAB-12-0','1','1.700','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-12-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-12-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-12-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-12-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZJAB-12-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.700',berat_out_asli='1.700', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.700',berat_akhir_asli =berat_akhir_asli-'1.700' WHERE kode_barang='PSPLT-ZJAB-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-261012-0004','3','PSPRT-ZJAB-13-0','1','4.020','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-13-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-13-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-13-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-13-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJAB-13-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.020',berat_out_asli='4.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.020',berat_akhir_asli =berat_akhir_asli-'4.020' WHERE kode_barang='PSPRT-ZJAB-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-261012-0004','4','PSGT-ZJAB-14-0','1','3.500','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAB-14-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJAB-14-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAB-14-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJAB-14-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJAB-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.500',berat_out_asli='3.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.500',berat_akhir_asli =berat_akhir_asli-'3.500' WHERE kode_barang='PSGT-ZJAB-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-261012-0004','5','PSGT-ZJAB-15-0','1','2.080','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAB-15-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJAB-15-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAB-15-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJAB-15-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJAB-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.080',berat_out_asli='2.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.080',berat_akhir_asli =berat_akhir_asli-'2.080' WHERE kode_barang='PSGT-ZJAB-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-261012-0004','6','PSGT-ZJAB-25-0','1','3.170','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJAB-25-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJAB-25-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJAB-25-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJAB-25-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJAB-25-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.170',berat_out_asli='3.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.170',berat_akhir_asli =berat_akhir_asli-'3.170' WHERE kode_barang='PSGT-ZJAB-25-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0004','7','PSPRT-ZJAB-29-0','1','2.050','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJAB-29-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJAB-29-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJAB-29-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJAB-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='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-ZJAB-29-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.050',berat_out_asli='2.050', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.050',berat_akhir_asli =berat_akhir_asli-'2.050' WHERE kode_barang='PSPRT-ZJAB-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-261012-0004','8','PSPLT-ZJAB-30-0','1','4.340','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJAB-30-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJAB-30-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJAB-30-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJAB-30-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-ZJAB-30-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.340',berat_out_asli='4.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.340',berat_akhir_asli =berat_akhir_asli-'4.340' WHERE kode_barang='PSPLT-ZJAB-30-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-261012-0004','2026-10-12','2026-10-12','16:46','4.340','input','2026-10-12 16:46:52','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0005','1','LXPER-ZJAB-26-0','1','1.160','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAB-26-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJAB-26-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAB-26-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJAB-26-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-ZJAB-26-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.160',berat_out_asli='1.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.160',berat_akhir_asli =berat_akhir_asli-'1.160' WHERE kode_barang='LXPER-ZJAB-26-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0005','2','LXPER-ZJAB-27-0','1','1.620','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAB-27-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJAB-27-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAB-27-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJAB-27-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-ZJAB-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.620',berat_out_asli='1.620', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.620',berat_akhir_asli =berat_akhir_asli-'1.620' WHERE kode_barang='LXPER-ZJAB-27-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261012-0005','3','LXPER-ZJAB-28-0','1','1.710','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZJAB-28-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZJAB-28-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZJAB-28-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZJAB-28-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-ZJAB-28-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.710',berat_out_asli='1.710', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.710',berat_akhir_asli =berat_akhir_asli-'1.710' WHERE kode_barang='LXPER-ZJAB-28-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-261012-0005','2026-10-12','2026-10-12','16:47','1.710','input','2026-10-12 16:47:07','THIFA');