INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-24 ','08:10:17'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-10-24','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-09-23'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-10-23'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-10-23'; 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-23' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-10-23'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-10-23'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-10-23'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-10-23'; 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-24' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-10-23' 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-24'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-24 ','08:11:26'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-03148'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRE-ZJBD-1-0','00048576','DP-03148 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','320000','2026-10-24','320000','3.200','100.00','925','200000','100000.00','1','0.04', 'input','2026-10-24 08:20:29','3.200','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03148','1','RS 16','','DP-03148'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZJBD-1-0','00048576'); 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-24','PSPRE-ZJBD-1-0','PSPRE','TOKO','PSN','100.00','3.200','3.200','1','3.200','3.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03148 '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0001','1','PSPLE-ZJBC-1-0','1','3.420','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLE-ZJBC-1-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLE-ZJBC-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLE-ZJBC-1-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLE-ZJBC-1-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPLE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPLE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLE-ZJBC-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.420',berat_out_asli='3.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.420',berat_akhir_asli =berat_akhir_asli-'3.420' WHERE kode_barang='PSPLE-ZJBC-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-261024-0001','2','PSGE-ZJBC-18-0','1','3.300','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGE-ZJBC-18-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGE-ZJBC-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGE-ZJBC-18-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGE-ZJBC-18-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSGE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSGE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGE-ZJBC-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.300',berat_out_asli='3.300', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.300',berat_akhir_asli =berat_akhir_asli-'3.300' WHERE kode_barang='PSGE-ZJBC-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-261024-0001','3','PSPRE-ZJBD-1-0','1','3.200','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZJBD-1-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZJBD-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZJBD-1-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZJBD-1-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRE-ZJBD-1-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='PSPRE-ZJBD-1-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261024-0001','2026-10-24','2026-10-24','08:22','3.200','input','2026-10-24 08:22:36','ELCO'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0002','1','PSPRT-ZJBC-2-0','1','3.650','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBC-2-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBC-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBC-2-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBC-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='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-ZJBC-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.650',berat_out_asli='3.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.650',berat_akhir_asli =berat_akhir_asli-'3.650' WHERE kode_barang='PSPRT-ZJBC-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-261024-0002','2','PSPLT-ZJBC-3-0','1','3.310','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBC-3-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBC-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBC-3-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBC-3-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBC-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.310',berat_out_asli='3.310', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.310',berat_akhir_asli =berat_akhir_asli-'3.310' WHERE kode_barang='PSPLT-ZJBC-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-261024-0002','3','PSPRT-ZJBC-4-0','1','3.180','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBC-4-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBC-4-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBC-4-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBC-4-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBC-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.180',berat_out_asli='3.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.180',berat_akhir_asli =berat_akhir_asli-'3.180' WHERE kode_barang='PSPRT-ZJBC-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-261024-0002','4','PSGT-ZJBC-19-0','1','2.680','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBC-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJBC-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBC-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJBC-19-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJBC-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.680',berat_out_asli='2.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.680',berat_akhir_asli =berat_akhir_asli-'2.680' WHERE kode_barang='PSGT-ZJBC-19-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0002','5','PSPRT-ZJBC-26-0','1','5.360','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBC-26-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBC-26-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBC-26-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBC-26-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-ZJBC-26-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='5.360',berat_out_asli='5.360', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'5.360',berat_akhir_asli =berat_akhir_asli-'5.360' WHERE kode_barang='PSPRT-ZJBC-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-261024-0002','6','PSPRT-ZJBC-27-0','1','3.150','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBC-27-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBC-27-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBC-27-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBC-27-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBC-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.150',berat_out_asli='3.150', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.150',berat_akhir_asli =berat_akhir_asli-'3.150' WHERE kode_barang='PSPRT-ZJBC-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-261024-0002','7','PSPRT-ZJBC-28-0','1','3.020','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBC-28-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBC-28-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBC-28-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBC-28-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBC-28-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.020',berat_out_asli='3.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.020',berat_akhir_asli =berat_akhir_asli-'3.020' WHERE kode_barang='PSPRT-ZJBC-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-261024-0002','2026-10-24','2026-10-24','08:22','3.020','input','2026-10-24 08:22:52','THIFA'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-24 ','08:26:23'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-24 ','08:39:29'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-24 ','13:21:39'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKSE-ZJBD-2-0','00048577','750K-135 ','CINCIN KAWIN SIRKON ','','GR','---','GOLD','CKSE','TOKO','CKS','2039000','2026-10-24','2039000','1.970','45.00','375','260000','2300000.00','1','0.04', 'input','2026-10-24 13:42:22','1.970','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKSE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKSE','CKSE-ZJBD-2-0','00048577'); 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-24','CKSE-ZJBD-2-0','CKSE','TOKO','CKS','45.00','1.970','1.970','1','1.970','1.970','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKSE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKSE','750K-135 '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('CKSE-ZJBD-3-0','00048578','850K-105 ','CINCIN KAWIN SIRKON ','','GR','---','GOLD','CKSE','TOKO','CKS','1221500','2026-10-24','1221500','1.180','45.00','375','400000','2300000.00','1','0.04', 'input','2026-10-24 13:43:08','1.180','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CKSE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CKSE','CKSE-ZJBD-3-0','00048578'); 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-24','CKSE-ZJBD-3-0','CKSE','TOKO','CKS','45.00','1.180','1.180','1','1.180','1.180','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CKSE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CKSE','850K-105 '); 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 ('CMMM-ZJBD-4-0','00048579','750K-85 ','CINCIN MAS SR02 ','','GR','---','GOLD','CMMM','TOKO','MMCM','1666500','2026-10-24','1666500','1.610','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-24 13:46:07','1.610','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-ZJBD-4-0','00048579'); 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-24','CMMM-ZJBD-4-0','CMMM','TOKO','MMCM','45.00','1.610','1.610','1','1.610','1.610','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','750K-85 '); 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 ('CMMM-ZJBD-5-0','00048580','750K-95 ','CINCIN MAS ','','GR','---','GOLD','CMMM','TOKO','MMCM','1294000','2026-10-24','1294000','1.250','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-24 13:46:49','1.250','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-ZJBD-5-0','00048580'); 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-24','CMMM-ZJBD-5-0','CMMM','TOKO','MMCM','45.00','1.250','1.250','1','1.250','1.250','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','750K-95 '); 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 ('CMMM-ZJBD-6-0','00048581','750K-13 ','CINCIN MAS SR05 ','','GR','---','GOLD','CMMM','TOKO','MMCM','1377000','2026-10-24','1377000','1.330','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-24 13:47:33','1.330','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMMM','CMMM-ZJBD-6-0','00048581'); 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-24','CMMM-ZJBD-6-0','CMMM','TOKO','MMCM','45.00','1.330','1.330','1','1.330','1.330','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMMM','750K-13 '); 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 ('BDCM-ZJBD-7-0','00048582','750K-75 ','CINCIN EMAS SR01 ','','GR','---','GOLD','BDCM','TOKO','CMBD','1149000','2026-10-24','1149000','1.110','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-24 13:50:36','1.110','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZJBD-7-0','00048582'); 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-24','BDCM-ZJBD-7-0','BDCM','TOKO','CMBD','45.00','1.110','1.110','1','1.110','1.110','1'); DELETE FROM tp_kode_intern WHERE kode_dept='BDCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','750K-75 '); 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 ('BDCM-ZJBD-8-0','00048583','850K-125 ','CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','1314500','2026-10-24','1314500','1.270','45.00','375','400000','2300000.00','1','0.14', 'input','2026-10-24 13:51:10','1.270','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZJBD-8-0','00048583'); 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-24','BDCM-ZJBD-8-0','BDCM','TOKO','CMBD','45.00','1.270','1.270','1','1.270','1.270','1'); DELETE FROM tp_kode_intern WHERE kode_dept='BDCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','850K-125 '); 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 ('BDCM-ZJBD-9-0','00048584','900K-125 ','CINCIN EMAS ','','GR','---','GOLD','BDCM','TOKO','CMBD','1501000','2026-10-24','1501000','1.450','45.00','375','480000','2300000.00','1','0.14', 'input','2026-10-24 13:51:51','1.450','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'BDCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('BDCM','BDCM-ZJBD-9-0','00048584'); 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-24','BDCM-ZJBD-9-0','BDCM','TOKO','CMBD','45.00','1.450','1.450','1','1.450','1.450','1'); DELETE FROM tp_kode_intern WHERE kode_dept='BDCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('BDCM','900K-125 '); 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 ('LXCM-ZJBD-10-0','00048585','750K-135 ','CINCIN EMAS SR01 ','','GR','---','GOLD','LXCM','TOKO','DUCM','1242000','2026-10-24','1242000','1.200','45.00','375','260000','2300000.00','1','0.014', 'input','2026-10-24 13:55:11','1.200','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXCM','LXCM-ZJBD-10-0','00048585'); 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-24','LXCM-ZJBD-10-0','LXCM','TOKO','DUCM','45.00','1.200','1.200','1','1.200','1.200','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXCM','750K-135 '); 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 ('LXCM-ZJBD-11-0','00048586','850K-115 ','CINCIN EMAS ','','GR','---','GOLD','LXCM','TOKO','DUCM','1263000','2026-10-24','1263000','1.220','45.00','375','400000','2300000.00','1','0.014', 'input','2026-10-24 13:55:38','1.220','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXCM','LXCM-ZJBD-11-0','00048586'); 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-24','LXCM-ZJBD-11-0','LXCM','TOKO','DUCM','45.00','1.220','1.220','1','1.220','1.220','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXCM','850K-115 '); 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 ('LXCM-ZJBD-12-0','00048587','900K-115 ','CINCIN EMAS ','','GR','---','GOLD','LXCM','TOKO','DUCM','1480500','2026-10-24','1480500','1.430','45.00','375','480000','2300000.00','1','0.014', 'input','2026-10-24 13:56:02','1.430','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'LXCM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('LXCM','LXCM-ZJBD-12-0','00048587'); 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-24','LXCM-ZJBD-12-0','LXCM','TOKO','DUCM','45.00','1.430','1.430','1','1.430','1.430','1'); DELETE FROM tp_kode_intern WHERE kode_dept='LXCM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('LXCM','900K-115 '); 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 ('CMSBY-ZJBD-13-0','00048588','750K-13 ','CINCIN EMAS SR02 ','','GR','---','GOLD','CMSBY','TOKO','SBYCM','1718500','2026-10-24','1718500','1.660','45.00','375','260000','2300000.00','1','0.014', 'input','2026-10-24 13:58:58','1.660','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMSBY' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMSBY','CMSBY-ZJBD-13-0','00048588'); 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-24','CMSBY-ZJBD-13-0','CMSBY','TOKO','SBYCM','45.00','1.660','1.660','1','1.660','1.660','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMSBY'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMSBY','750K-13 '); 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 ('CMSBY-ZJBD-14-0','00048589','750K-9 ','CINCIN EMAS SR05 ','','GR','---','GOLD','CMSBY','TOKO','SBYCM','1252500','2026-10-24','1252500','1.210','45.00','375','260000','2300000.00','1','0.014', 'input','2026-10-24 13:59:27','1.210','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMSBY' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMSBY','CMSBY-ZJBD-14-0','00048589'); 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-24','CMSBY-ZJBD-14-0','CMSBY','TOKO','SBYCM','45.00','1.210','1.210','1','1.210','1.210','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMSBY'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMSBY','750K-9 '); 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 ('CMSBY-ZJBD-15-0','00048590','850K-95 ','CINCIN EMAS ','','GR','---','GOLD','CMSBY','TOKO','SBYCM','1221500','2026-10-24','1221500','1.180','45.00','375','400000','2300000.00','1','0.014', 'input','2026-10-24 13:59:52','1.180','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMSBY' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMSBY','CMSBY-ZJBD-15-0','00048590'); 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-24','CMSBY-ZJBD-15-0','CMSBY','TOKO','SBYCM','45.00','1.180','1.180','1','1.180','1.180','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMSBY'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMSBY','850K-95 '); 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 ('CMJOG-ZJBD-16-0','00048591','750K-11 ','CINCIN EMAS SR02 ','','GR','---','GOLD','CMJOG','TOKO','JOGCM','1625000','2026-10-24','1625000','1.570','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-24 14:02:10','1.570','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMJOG' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMJOG','CMJOG-ZJBD-16-0','00048591'); 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-24','CMJOG-ZJBD-16-0','CMJOG','TOKO','JOGCM','45.00','1.570','1.570','1','1.570','1.570','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMJOG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMJOG','750K-11 '); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco2.tt_persekot_detail SET status_close='DONE' WHERE no_persekot=''; 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 ('CMJOG-ZJBD-17-0','00048592','750K-14 ','CINCIN EMAS SR05 ','','GR','---','GOLD','CMJOG','TOKO','JOGCM','1325000','2026-10-24','1325000','1.280','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-24 14:02:33','1.280','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMJOG' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMJOG','CMJOG-ZJBD-17-0','00048592'); 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-24','CMJOG-ZJBD-17-0','CMJOG','TOKO','JOGCM','45.00','1.280','1.280','1','1.280','1.280','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMJOG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMJOG','750K-14 '); 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 ('CMJOG-ZJBD-18-0','00048593','750K-85 ','CINCIN EMAS SR04 ','','GR','---','GOLD','CMJOG','TOKO','JOGCM','1211000','2026-10-24','1211000','1.170','45.00','375','260000','2300000.00','1','0.14', 'input','2026-10-24 14:03:10','1.170','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'CMJOG' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMJOG','CMJOG-ZJBD-18-0','00048593'); 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-24','CMJOG-ZJBD-18-0','CMJOG','TOKO','JOGCM','45.00','1.170','1.170','1','1.170','1.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMJOG'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMJOG','750K-85 '); 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-04617'; 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-ZJBD-19-0','00048594','DP-04617DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','2736500','2026-10-24','2736500','4.000','57.00','50','250000','1200000.00','1','0.14', 'input','2026-10-24 14:31:23','4.000','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04617DU','1','RS 20','','DP-04617'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBD-19-0','00048594'); 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-24','PSPLT-ZJBD-19-0','PSPLT','TOKO','DUPSN','57.00','4.000','4.000','1','4.000','4.000','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04617DU '); 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-04420'; 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-ZJBD-20-0','00048595','DP-04420DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','380000','2026-10-24','380000','3.800','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-24 14:32:46','3.800','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04420DU','1','RS 25','','DP-04420'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBD-20-0','00048595'); 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-24','PSPRT-ZJBD-20-0','PSPRT','TOKO','DUPSN','100.00','3.800','3.800','1','3.800','3.800','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04420DU '); 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-04419'; 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-ZJBD-21-0','00048596','DP-04419DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','318000','2026-10-24','318000','3.180','100.00','925','200000','100000.00','1','0.14', 'input','2026-10-24 14:34:08','3.180','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04419DU','1','RS 17','','DP-04419'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBD-21-0','00048596'); 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-24','PSPRT-ZJBD-21-0','PSPRT','TOKO','DUPSN','100.00','3.180','3.180','1','3.180','3.180','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04419DU '); 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-04349'; 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-ZJBD-22-0','00048597','DP-04349SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','730000','2026-10-24','730000','1.900','32.00','25','340000','1200000.00','1','0.014', 'input','2026-10-24 14:36:57','1.900','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04349SBY','1','RS 8 5','','DP-04349'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBD-22-0','00048597'); 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-24','PSPLT-ZJBD-22-0','PSPLT','TOKO','SBYPSN','32.00','1.900','1.900','1','1.900','1.900','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04349SBY '); 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-04400'; 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-ZJBD-23-0','00048598','DP-04400SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','332000','2026-10-24','332000','3.320','100.00','925','200000','100000.00','1','0.014', 'input','2026-10-24 14:38:14','3.320','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04400SBY','1','RS 16','','DP-04400'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBD-23-0','00048598'); 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-24','PSPRT-ZJBD-23-0','PSPRT','TOKO','SBYPSN','100.00','3.320','3.320','1','3.320','3.320','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04400SBY '); 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 ('TFGRK-ZJBD-24-0','00048599','TFGRK70-77% ','THIFA GELANG RANTAI KUNING ','','GR','---','GOLD','TFGRK','TOKO','GLRTF','2904500','2026-10-24','2904500','1.640','77.00','70','0','2300000.00','1','0.14', 'input','2026-10-24 14:40:53','1.640','0','','18000.00','','TOKO','FREETAG','','2','','','','','','',''); DELETE FROM tp_barang WHERE kode_dept = 'TFGRK' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRK','TFGRK-ZJBD-24-0','00048599'); 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-24','TFGRK-ZJBD-24-0','TFGRK','TOKO','GLRTF','77.00','1.640','1.640','1','1.640','1.640','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFGRK'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRK','TFGRK70-77% '); 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-04374'; 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-ZJBD-25-0','00048600','DP-04374MM ','CINCIN EMAS ','','GR','---','PSGT','PSGT','TOKO','MMPSN','3120500','2026-10-24','3120500','2.380','57.00','50','260000','2300000.00','1','0.14', 'input','2026-10-24 14:58:11','2.380','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04374MM','1','RS 13','','DP-04374'); DELETE FROM tp_barang WHERE kode_dept = 'PSGT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSGT','PSGT-ZJBD-25-0','00048600'); 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-24','PSGT-ZJBD-25-0','PSGT','TOKO','MMPSN','57.00','2.380','2.380','1','2.380','2.380','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSGT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSGT','DP-04374MM '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli=''; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group=''; UPDATE db_nagagold_elco1.tt_persekot_detail SET status_close='DONE' WHERE no_persekot='DP-03145'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPRE-ZJBD-26-0','00048601','DP-03145 ','CINCIN PERAK ','','GR','---','PSPRE','PSPRE','TOKO','PSN','275000','2026-10-24','275000','2.750','100.00','925','210000','100000.00','1','0.04', 'input','2026-10-24 15:29:10','2.750','0','','18000.00','','TOKO','FREETAG','','2','','','PSN03145','1','RS 21 5','','DP-03145'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRE','PSPRE-ZJBD-26-0','00048601'); 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-24','PSPRE-ZJBD-26-0','PSPRE','TOKO','PSN','100.00','2.750','2.750','1','2.750','2.750','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRE','DP-03145 '); 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-04250'; 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-ZJBD-27-0','00048602','DP-04250MM ','CINCIN PERAK CP11 ','','GR','---','PSPRT','PSPRT','TOKO','MMPSN','399000','2026-10-24','399000','3.990','100.00','925','640000','100000.00','1','0.14', 'input','2026-10-24 15:35:43','3.990','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04250MM','1','RS 175 RS 195','','DP-04250'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBD-27-0','00048602'); 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-24','PSPRT-ZJBD-27-0','PSPRT','TOKO','MMPSN','100.00','3.990','3.990','1','3.990','3.990','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04250MM '); 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-04264'; 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-ZJBD-28-0','00048603','DP-04264BIP ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','PSNB','316000','2026-10-24','316000','3.160','100.00','925','210000','100000.00','1','0.14', 'input','2026-10-24 15:37:37','3.160','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04264BIP','1','RS 15 5','','DP-04264'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBD-28-0','00048603'); 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-24','PSPRT-ZJBD-28-0','PSPRT','TOKO','PSNB','100.00','3.160','3.160','1','3.160','3.160','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04264BIP '); 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-04474'; 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-ZJBD-29-0','00048604','DP-04474BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','726500','2026-10-24','726500','3.560','17.00','10','250000','1200000.00','1','0.14', 'input','2026-10-24 15:38:51','3.560','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04474BIP','1','RS 23','','DP-04474'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBD-29-0','00048604'); 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-24','PSPLT-ZJBD-29-0','PSPLT','TOKO','PSNB','17.00','3.560','3.560','1','3.560','3.560','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04474BIP '); 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-04392'; 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-ZJBD-30-0','00048605','DP-04392BIP ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','PSNB','435000','2026-10-24','435000','2.130','17.00','10','260000','1200000.00','1','0.14', 'input','2026-10-24 15:46:18','2.130','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04392BIP','1','RS 16','','DP-04392'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBD-30-0','00048605'); 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-24','PSPLT-ZJBD-30-0','PSPLT','TOKO','PSNB','17.00','2.130','2.130','1','2.130','2.130','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04392BIP '); 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-04447'; 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-ZJBD-31-0','00048606','DP-04447DU ','CINCIN PERAK SR02 YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','308000','2026-10-24','308000','3.080','100.00','925','410000','100000.00','1','0.14', 'input','2026-10-24 15:48:35','3.080','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04447DU','1','RS 12 RS 14','','DP-04447'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBD-31-0','00048606'); 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-24','PSPRT-ZJBD-31-0','PSPRT','TOKO','DUPSN','100.00','3.080','3.080','1','3.080','3.080','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04447DU '); 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-04348'; 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-ZJBD-32-0','00048607','DP-04348SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1478500','2026-10-24','1478500','3.850','32.00','25','250000','1200000.00','1','0.014', 'input','2026-10-24 15:50:38','3.850','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04348SBY','1','RS 19 5','','DP-04348'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBD-32-0','00048607'); 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-24','PSPLT-ZJBD-32-0','PSPLT','TOKO','SBYPSN','32.00','3.850','3.850','1','3.850','3.850','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04348SBY '); 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-04429'; 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-ZJBD-33-0','00048608','DP-04429SBY ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','SBYPSN','411500','2026-10-24','411500','4.110','100.00','925','200000','100000.00','1','0.014', 'input','2026-10-24 15:51:59','4.110','0','','18000.00','','TOKO','FREETAG','','2','','','PSN04429SBY','1','RS 26','','DP-04429'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZJBD-33-0','00048608'); 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-24','PSPRT-ZJBD-33-0','PSPRT','TOKO','SBYPSN','100.00','4.110','4.110','1','4.110','4.110','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04429SBY '); 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-04467'; 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-ZJBD-34-0','00048609','DP-04467SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','630500','2026-10-24','630500','3.090','17.00','10','250000','1200000.00','1','0.014', 'input','2026-10-24 15:53:13','3.090','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04467SBY','1','RS 14 5','','DP-04467'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBD-34-0','00048609'); 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-24','PSPLT-ZJBD-34-0','PSPLT','TOKO','SBYPSN','17.00','3.090','3.090','1','3.090','3.090','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04467SBY '); 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-04402'; 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-ZJBD-35-0','00048610','DP-04402SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1409500','2026-10-24','1409500','3.670','32.00','25','250000','1200000.00','1','0.014', 'input','2026-10-24 15:54:50','3.670','0','','18000.00','','TOKO','FREETAG','','10','','','PSN04402SBY','1','RS 24','','DP-04402'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZJBD-35-0','00048610'); 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-24','PSPLT-ZJBD-35-0','PSPLT','TOKO','SBYPSN','32.00','3.670','3.670','1','3.670','3.670','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04402SBY '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0003','1','CKSE-ZJBD-2-0','1','1.970','TOKO','CKS'); DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZJBD-2-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZJBD-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZJBD-2-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZJBD-2-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKS'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZJBD-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.970',berat_out_asli='1.970', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.970',berat_akhir_asli =berat_akhir_asli-'1.970' WHERE kode_barang='CKSE-ZJBD-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-261024-0003','2','CKSE-ZJBD-3-0','1','1.180','TOKO','CKS'); DELETE FROM tm_barang_export WHERE kode_barang='CKSE-ZJBD-3-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CKSE-ZJBD-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CKSE-ZJBD-3-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CKSE-ZJBD-3-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='CKSE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CKSE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='CKS'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CKS'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CKSE-ZJBD-3-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.180',berat_out_asli='1.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.180',berat_akhir_asli =berat_akhir_asli-'1.180' WHERE kode_barang='CKSE-ZJBD-3-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-261024-0003','2026-10-24','2026-10-24','16:01','1.180','input','2026-10-24 16:01:58','ELCO'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0004','1','CMMM-ZJBD-4-0','1','1.610','TOKO','MMCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMMM-ZJBD-4-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMMM-ZJBD-4-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMMM-ZJBD-4-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMMM-ZJBD-4-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMMM-ZJBD-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.610',berat_out_asli='1.610', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.610',berat_akhir_asli =berat_akhir_asli-'1.610' WHERE kode_barang='CMMM-ZJBD-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-261024-0004','2','CMMM-ZJBD-5-0','1','1.250','TOKO','MMCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMMM-ZJBD-5-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMMM-ZJBD-5-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMMM-ZJBD-5-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMMM-ZJBD-5-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMMM-ZJBD-5-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.250',berat_out_asli='1.250', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.250',berat_akhir_asli =berat_akhir_asli-'1.250' WHERE kode_barang='CMMM-ZJBD-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-261024-0004','3','CMMM-ZJBD-6-0','1','1.330','TOKO','MMCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMMM-ZJBD-6-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMMM-ZJBD-6-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMMM-ZJBD-6-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMMM-ZJBD-6-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMMM-ZJBD-6-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='CMMM-ZJBD-6-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-261024-0004','2026-10-24','2026-10-24','16:02','1.330','input','2026-10-24 16:02:12','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0005','1','BDCM-ZJBD-7-0','1','1.110','TOKO','CMBD'); DELETE FROM tm_barang_export WHERE kode_barang='BDCM-ZJBD-7-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-ZJBD-7-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-ZJBD-7-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-ZJBD-7-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-ZJBD-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.110',berat_out_asli='1.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.110',berat_akhir_asli =berat_akhir_asli-'1.110' WHERE kode_barang='BDCM-ZJBD-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-261024-0005','2','BDCM-ZJBD-8-0','1','1.270','TOKO','CMBD'); DELETE FROM tm_barang_export WHERE kode_barang='BDCM-ZJBD-8-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-ZJBD-8-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-ZJBD-8-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-ZJBD-8-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-ZJBD-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.270',berat_out_asli='1.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.270',berat_akhir_asli =berat_akhir_asli-'1.270' WHERE kode_barang='BDCM-ZJBD-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-261024-0005','3','BDCM-ZJBD-9-0','1','1.450','TOKO','CMBD'); DELETE FROM tm_barang_export WHERE kode_barang='BDCM-ZJBD-9-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='BDCM-ZJBD-9-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='BDCM-ZJBD-9-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='BDCM-ZJBD-9-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='BDCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='BDCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='CMBD'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='CMBD'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='BDCM-ZJBD-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.450',berat_out_asli='1.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.450',berat_akhir_asli =berat_akhir_asli-'1.450' WHERE kode_barang='BDCM-ZJBD-9-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-261024-0005','2026-10-24','2026-10-24','16:02','1.450','input','2026-10-24 16:02:21','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0006','1','LXCM-ZJBD-10-0','1','1.200','TOKO','DUCM'); DELETE FROM tm_barang_export WHERE kode_barang='LXCM-ZJBD-10-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXCM-ZJBD-10-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXCM-ZJBD-10-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXCM-ZJBD-10-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXCM-ZJBD-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.200',berat_out_asli='1.200', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.200',berat_akhir_asli =berat_akhir_asli-'1.200' WHERE kode_barang='LXCM-ZJBD-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-261024-0006','2','LXCM-ZJBD-11-0','1','1.220','TOKO','DUCM'); DELETE FROM tm_barang_export WHERE kode_barang='LXCM-ZJBD-11-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXCM-ZJBD-11-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXCM-ZJBD-11-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXCM-ZJBD-11-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXCM-ZJBD-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.220',berat_out_asli='1.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.220',berat_akhir_asli =berat_akhir_asli-'1.220' WHERE kode_barang='LXCM-ZJBD-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-261024-0006','3','LXCM-ZJBD-12-0','1','1.430','TOKO','DUCM'); DELETE FROM tm_barang_export WHERE kode_barang='LXCM-ZJBD-12-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXCM-ZJBD-12-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXCM-ZJBD-12-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXCM-ZJBD-12-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXCM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXCM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXCM-ZJBD-12-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.430',berat_out_asli='1.430', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.430',berat_akhir_asli =berat_akhir_asli-'1.430' WHERE kode_barang='LXCM-ZJBD-12-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-261024-0006','2026-10-24','2026-10-24','16:02','1.430','input','2026-10-24 16:02:30','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0007','1','CMSBY-ZJBD-13-0','1','1.660','TOKO','SBYCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMSBY-ZJBD-13-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMSBY-ZJBD-13-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMSBY-ZJBD-13-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMSBY-ZJBD-13-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMSBY-ZJBD-13-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.660',berat_out_asli='1.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.660',berat_akhir_asli =berat_akhir_asli-'1.660' WHERE kode_barang='CMSBY-ZJBD-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-261024-0007','2','CMSBY-ZJBD-14-0','1','1.210','TOKO','SBYCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMSBY-ZJBD-14-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMSBY-ZJBD-14-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMSBY-ZJBD-14-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMSBY-ZJBD-14-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMSBY-ZJBD-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.210',berat_out_asli='1.210', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.210',berat_akhir_asli =berat_akhir_asli-'1.210' WHERE kode_barang='CMSBY-ZJBD-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-261024-0007','3','CMSBY-ZJBD-15-0','1','1.180','TOKO','SBYCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMSBY-ZJBD-15-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMSBY-ZJBD-15-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMSBY-ZJBD-15-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMSBY-ZJBD-15-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMSBY-ZJBD-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.180',berat_out_asli='1.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.180',berat_akhir_asli =berat_akhir_asli-'1.180' WHERE kode_barang='CMSBY-ZJBD-15-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261024-0007','2026-10-24','2026-10-24','16:02','1.180','input','2026-10-24 16:02:42','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0008','1','CMJOG-ZJBD-16-0','1','1.570','TOKO','JOGCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMJOG-ZJBD-16-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMJOG-ZJBD-16-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMJOG-ZJBD-16-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMJOG-ZJBD-16-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMJOG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMJOG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMJOG-ZJBD-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.570',berat_out_asli='1.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.570',berat_akhir_asli =berat_akhir_asli-'1.570' WHERE kode_barang='CMJOG-ZJBD-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-261024-0008','2','CMJOG-ZJBD-17-0','1','1.280','TOKO','JOGCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMJOG-ZJBD-17-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMJOG-ZJBD-17-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMJOG-ZJBD-17-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMJOG-ZJBD-17-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMJOG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMJOG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMJOG-ZJBD-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.280',berat_out_asli='1.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.280',berat_akhir_asli =berat_akhir_asli-'1.280' WHERE kode_barang='CMJOG-ZJBD-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-261024-0008','3','CMJOG-ZJBD-18-0','1','1.170','TOKO','JOGCM'); DELETE FROM tm_barang_export WHERE kode_barang='CMJOG-ZJBD-18-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='CMJOG-ZJBD-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='CMJOG-ZJBD-18-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='CMJOG-ZJBD-18-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='CMJOG' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='CMJOG' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGCM'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGCM'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='CMJOG-ZJBD-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.170',berat_out_asli='1.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.170',berat_akhir_asli =berat_akhir_asli-'1.170' WHERE kode_barang='CMJOG-ZJBD-18-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-261024-0008','2026-10-24','2026-10-24','16:02','1.170','input','2026-10-24 16:02:54','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0009','1','TFGRK-ZJBD-24-0','1','1.640','TOKO','GLRTF'); DELETE FROM tm_barang_export WHERE kode_barang='TFGRK-ZJBD-24-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='TFGRK-ZJBD-24-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='TFGRK-ZJBD-24-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='TFGRK-ZJBD-24-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='GOLD' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='GOLD' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='TFGRK' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='TFGRK' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='GLRTF'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='GLRTF'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='TFGRK-ZJBD-24-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.640',berat_out_asli='1.640', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.640',berat_akhir_asli =berat_akhir_asli-'1.640' WHERE kode_barang='TFGRK-ZJBD-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-261024-0009','2026-10-24','2026-10-24','16:03','1.640','input','2026-10-24 16:03:08','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0010','1','PSPLT-ZJBD-19-0','1','4.000','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBD-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBD-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBD-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBD-19-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBD-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.000',berat_out_asli='4.000', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.000',berat_akhir_asli =berat_akhir_asli-'4.000' WHERE kode_barang='PSPLT-ZJBD-19-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0010','2','PSPRT-ZJBD-20-0','1','3.800','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBD-20-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBD-20-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBD-20-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBD-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-ZJBD-20-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.800',berat_out_asli='3.800', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.800',berat_akhir_asli =berat_akhir_asli-'3.800' WHERE kode_barang='PSPRT-ZJBD-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-261024-0010','3','PSPRT-ZJBD-21-0','1','3.180','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBD-21-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBD-21-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBD-21-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBD-21-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-ZJBD-21-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.180',berat_out_asli='3.180', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.180',berat_akhir_asli =berat_akhir_asli-'3.180' WHERE kode_barang='PSPRT-ZJBD-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-261024-0010','4','PSPRT-ZJBD-31-0','1','3.080','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBD-31-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBD-31-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBD-31-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBD-31-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBD-31-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.080',berat_out_asli='3.080', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.080',berat_akhir_asli =berat_akhir_asli-'3.080' WHERE kode_barang='PSPRT-ZJBD-31-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261024-0010','2026-10-24','2026-10-24','16:03','3.080','input','2026-10-24 16:03:20','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0011','1','PSPLT-ZJBD-22-0','1','1.900','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBD-22-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBD-22-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBD-22-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBD-22-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBD-22-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='PSPLT-ZJBD-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-261024-0011','2','PSPRT-ZJBD-23-0','1','3.320','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBD-23-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBD-23-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBD-23-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBD-23-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBD-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.320',berat_out_asli='3.320', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.320',berat_akhir_asli =berat_akhir_asli-'3.320' WHERE kode_barang='PSPRT-ZJBD-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-261024-0011','3','PSPLT-ZJBD-32-0','1','3.850','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBD-32-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBD-32-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBD-32-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBD-32-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-ZJBD-32-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.850',berat_out_asli='3.850', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.850',berat_akhir_asli =berat_akhir_asli-'3.850' WHERE kode_barang='PSPLT-ZJBD-32-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0011','4','PSPRT-ZJBD-33-0','1','4.110','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBD-33-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBD-33-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBD-33-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBD-33-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBD-33-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.110',berat_out_asli='4.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.110',berat_akhir_asli =berat_akhir_asli-'4.110' WHERE kode_barang='PSPRT-ZJBD-33-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0011','5','PSPLT-ZJBD-34-0','1','3.090','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBD-34-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBD-34-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBD-34-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBD-34-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-ZJBD-34-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.090',berat_out_asli='3.090', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.090',berat_akhir_asli =berat_akhir_asli-'3.090' WHERE kode_barang='PSPLT-ZJBD-34-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0011','6','PSPLT-ZJBD-35-0','1','3.670','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBD-35-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBD-35-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBD-35-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBD-35-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-ZJBD-35-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.670',berat_out_asli='3.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.670',berat_akhir_asli =berat_akhir_asli-'3.670' WHERE kode_barang='PSPLT-ZJBD-35-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261024-0011','2026-10-24','2026-10-24','16:03','3.670','input','2026-10-24 16:03:30','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0012','1','PSGT-ZJBD-25-0','1','2.380','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZJBD-25-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZJBD-25-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZJBD-25-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZJBD-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='MMPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZJBD-25-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.380',berat_out_asli='2.380', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.380',berat_akhir_asli =berat_akhir_asli-'2.380' WHERE kode_barang='PSGT-ZJBD-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-261024-0012','2','PSPRT-ZJBD-27-0','1','3.990','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBD-27-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBD-27-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBD-27-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBD-27-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBD-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.990',berat_out_asli='3.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.990',berat_akhir_asli =berat_akhir_asli-'3.990' WHERE kode_barang='PSPRT-ZJBD-27-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261024-0012','2026-10-24','2026-10-24','16:03','3.990','input','2026-10-24 16:03:41','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0013','1','PSPRE-ZJBD-26-0','1','2.750','TOKO','PSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRE-ZJBD-26-0' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRE-ZJBD-26-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRE-ZJBD-26-0'; INSERT INTO db_nagagold_elco1.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRE-ZJBD-26-0'; DELETE FROM db_nagagold_elco1.tm_group_export WHERE kode_group='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_dept_export WHERE kode_dept='PSPRE' LIMIT 1; INSERT INTO db_nagagold_elco1.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRE' LIMIT 1; DELETE FROM db_nagagold_elco1.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSN'; INSERT INTO db_nagagold_elco1.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRE-ZJBD-26-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.750',berat_out_asli='2.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.750',berat_akhir_asli =berat_akhir_asli-'2.750' WHERE kode_barang='PSPRE-ZJBD-26-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-261024-0013','2026-10-24','2026-10-24','16:03','2.750','input','2026-10-24 16:03:54','ELCO'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0014','1','PSPRT-ZJBD-28-0','1','3.160','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZJBD-28-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZJBD-28-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZJBD-28-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZJBD-28-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='PSNB'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='PSNB'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZJBD-28-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.160',berat_out_asli='3.160', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.160',berat_akhir_asli =berat_akhir_asli-'3.160' WHERE kode_barang='PSPRT-ZJBD-28-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261024-0014','2','PSPLT-ZJBD-29-0','1','3.560','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBD-29-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBD-29-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBD-29-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBD-29-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZJBD-29-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='PSPLT-ZJBD-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-261024-0014','3','PSPLT-ZJBD-30-0','1','2.130','TOKO','PSNB'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZJBD-30-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZJBD-30-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZJBD-30-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZJBD-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='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-ZJBD-30-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.130',berat_out_asli='2.130', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.130',berat_akhir_asli =berat_akhir_asli-'2.130' WHERE kode_barang='PSPLT-ZJBD-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-261024-0014','2026-10-24','2026-10-24','16:04','2.130','input','2026-10-24 16:04:04','THIFA'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-10-24 ','16:06:56');