INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-12 ','08:22:47'); INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-11-12','0','0','0','0','0','0'); DELETE FROM th_barang_saldo WHERE tanggal <= '2026-10-12'; INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-11-11'; UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-11-11'; INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-11-11' AND berat_akhir*1 > '0' INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-11-11'; DELETE FROM tt_cash_daily WHERE tanggal <= '2026-11-11'; INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-11-11'; DELETE FROM tt_bank_daily WHERE tanggal <= '2026-11-11'; CREATE TABLE IF NOT EXISTS th_barang_saldo_202610 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-10'; UPDATE tt_barang_saldo SET tanggal= '2026-11-12' WHERE status_close ='OPEN'; DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-11-11' OR stock_akhir*1<0 OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS'; UPDATE tp_system SET tgl_system='2026-11-12'; INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-12 ','08:23: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 ('PMM-ZKAB-1-0','00049350','750K-19-1373 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','228500','2026-11-12','228500','2.280','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-12 08:23:53','2.280','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZKAB-1-0','00049350'); 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-11-12','PMM-ZKAB-1-0','PMM','TOKO','MMPER','100.00','2.280','2.280','1','2.280','2.280','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','750K-19-1373 '); 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 ('PMM-ZKAB-2-0','00049351','800K-15-1374 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','250000','2026-11-12','250000','2.500','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-12 08:24:23','2.500','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZKAB-2-0','00049351'); 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-11-12','PMM-ZKAB-2-0','PMM','TOKO','MMPER','100.00','2.500','2.500','1','2.500','2.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','800K-15-1374 '); 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 ('PMM-ZKAB-3-0','00049352','800K-9-1375 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','161000','2026-11-12','161000','1.610','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-12 08:24:47','1.610','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZKAB-3-0','00049352'); 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-11-12','PMM-ZKAB-3-0','PMM','TOKO','MMPER','100.00','1.610','1.610','1','1.610','1.610','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','800K-9-1375 '); 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 ('PMM-ZKAB-4-0','00049353','850K-13-1376 ','CINCIN SILVER 925 ','','GR','---','PER','PMM','TOKO','MMPER','152000','2026-11-12','152000','1.520','100.00','925','235000','100000.00','1','0.14', 'input','2026-11-12 08:25:18','1.520','0','','18200.00','','TOKO','FREETAG','','2','','','','1','','',''); DELETE FROM tp_barang WHERE kode_dept = 'PMM' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PMM','PMM-ZKAB-4-0','00049353'); 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-11-12','PMM-ZKAB-4-0','PMM','TOKO','MMPER','100.00','1.520','1.520','1','1.520','1.520','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PMM'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PMM','850K-13-1376 '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0001','1','PSPLT-ZKAA-1-0','1','2.500','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAA-1-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAA-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAA-1-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAA-1-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZKAA-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.500',berat_out_asli='2.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.500',berat_akhir_asli =berat_akhir_asli-'2.500' WHERE kode_barang='PSPLT-ZKAA-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-261112-0001','2','PSPRT-ZKAA-2-0','1','4.750','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAA-2-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAA-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAA-2-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAA-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-ZKAA-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.750',berat_out_asli='4.750', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.750',berat_akhir_asli =berat_akhir_asli-'4.750' WHERE kode_barang='PSPRT-ZKAA-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-261112-0001','3','PSPLT-ZKAA-32-0','1','3.020','TOKO','MMPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAA-32-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAA-32-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAA-32-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAA-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='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-ZKAA-32-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.020',berat_out_asli='3.020', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.020',berat_akhir_asli =berat_akhir_asli-'3.020' WHERE kode_barang='PSPLT-ZKAA-32-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261112-0001','2026-11-12','2026-11-12','08:31','3.020','input','2026-11-12 08:31:10','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0002','1','PMM-ZKAB-1-0','1','2.280','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKAB-1-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKAB-1-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKAB-1-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKAB-1-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKAB-1-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.280',berat_out_asli='2.280', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.280',berat_akhir_asli =berat_akhir_asli-'2.280' WHERE kode_barang='PMM-ZKAB-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-261112-0002','2','PMM-ZKAB-2-0','1','2.500','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKAB-2-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKAB-2-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKAB-2-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKAB-2-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKAB-2-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.500',berat_out_asli='2.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.500',berat_akhir_asli =berat_akhir_asli-'2.500' WHERE kode_barang='PMM-ZKAB-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-261112-0002','3','PMM-ZKAB-3-0','1','1.610','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKAB-3-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKAB-3-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKAB-3-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKAB-3-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKAB-3-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='PMM-ZKAB-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-261112-0002','4','PMM-ZKAB-4-0','1','1.520','TOKO','MMPER'); DELETE FROM tm_barang_export WHERE kode_barang='PMM-ZKAB-4-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PMM-ZKAB-4-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PMM-ZKAB-4-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PMM-ZKAB-4-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PMM' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PMM' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='MMPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='MMPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PMM-ZKAB-4-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.520',berat_out_asli='1.520', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.520',berat_akhir_asli =berat_akhir_asli-'1.520' WHERE kode_barang='PMM-ZKAB-4-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-261112-0002','2026-11-12','2026-11-12','08:31','1.520','input','2026-11-12 08:31:30','THIFA'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-12 ','08:33:00'); INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('input','2026-11-12 ','08:39:00'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261003-0002'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261003-0002'; 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 ('ABRE-ZKAB-5-0','00049354','ABRE-01386 ','ANTING ABRE-01386 ','','GR','---','DM','ABRE','TOKO','ABRE.BALIK','2245500','2026-11-12','2245500','1.310','75.00','75','0','2285000.00','1','0.04', 'input','2026-11-12 10:09:59','1.310','0','67.50','18200.00','','TOKO','FREETAG','','10','','0','IDB 14 000 000','2','1B0 1026','BE-261003-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'ABRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('ABRE','ABRE-ZKAB-5-0','00049354'); 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-11-12','ABRE-ZKAB-5-0','ABRE','TOKO','ABRE.BALIK','75.00','1.310','1.310','1','1.310','1.310','1'); DELETE FROM tp_kode_intern WHERE kode_dept='ABRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('ABRE','ABRE-01386 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('ABRE-ZKAB-5-0','00049354','RD','30','0.150 ','450','67.5'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0001','1','ABRE-ZKAB-5-0','1','1.310','1.310','TOKO','ABRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='ABRE-ZKAB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-12','TOKO','SEM-BALIK','ABRE','ABRE-ZKAB-5-0','75.00','1','1.310','1.310','1','1.310','1.310'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.310',berat_out_asli=berat_out_asli+'1.310',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='ABRE-ZKAB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261112-0001','2026-11-12','2026-11-12','10:10','1.31','input','2026-11-12 10:10:20'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-261009-0001'; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-261009-0001'; 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 ('TFGRR-ZKAB-6-0','00049355','TFGRR75-76% ','THIFA GELANG RANTAI RG ','','GR','---','GOLD','TFGRR','TOKO','SEM-EMAS','5001500','2026-11-12','5001500','2.880','76.00','75','0','2285000.00','1','0.14', 'input','2026-11-12 10:14:14','2.880','0','','18200.00','','TOKO','FREETAG','','2','','','','2','','FB-261009-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'TFGRR' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFGRR','TFGRR-ZKAB-6-0','00049355'); 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-11-12','TFGRR-ZKAB-6-0','TFGRR','TOKO','SEM-EMAS','76.00','2.880','2.880','1','2.880','2.880','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFGRR'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFGRR','TFGRR75-76% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261021-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261021-0001'; 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 ('CBRE-ZKAB-7-0','00049356','CBRE-00756 ','CINCIN CBRE-00756 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','1080000','2026-11-12','1080000','0.630','75.00','75.00','0','2285000.00','1','0.04', 'input','2026-11-12 10:18:45','0.630','0','22.50','18200.00','0','TOKO','FREETAG','','10','','0','IDB 6 000 000','4','RS16 1B5 1026','BE-261021-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKAB-7-0','00049356'); 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-11-12','CBRE-ZKAB-7-0','CBRE','TOKO','CBRE.BALIK','75.00','0.630','0.630','1','0.630','0.630','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-00756 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAB-7-0','00049356','RD','13','0.050 ','450','22.5'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0002','1','CBRE-ZKAB-7-0','1','0.630','0.630','TOKO','CBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKAB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-12','TOKO','SEM-BALIK','CBRE','CBRE-ZKAB-7-0','75.00','1','0.630','0.630','1','0.630','0.630'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.630',berat_out_asli=berat_out_asli+'0.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='CBRE-ZKAB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261112-0002','2026-11-12','2026-11-12','10:18','0.63','input','2026-11-12 10:19:00'); UPDATE db_nagagold_elco2.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='FB-261021-0002'; UPDATE db_nagagold_elco2.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='FB-261021-0002'; 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 ('TFC-ZKAB-8-0','00049357','TFC-21523 ','CINCIN TFC-21523 ','','GR','---','DM','TFC','TOKO','SEM-BALIK','3650500','2026-11-12','3650500','2.130','75.00','75','0','2285000.00','1','0.14', 'input','2026-11-12 10:24:43','2.130','0','86.40','18200.00','','TOKO','FREETAG','','10','','','IDB 19 500 000','1','RS135 5B0 1026','FB-261021-0002',''); DELETE FROM tp_barang WHERE kode_dept = 'TFC' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('TFC','TFC-ZKAB-8-0','00049357'); 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-11-12','TFC-ZKAB-8-0','TFC','TOKO','SEM-BALIK','75.00','2.130','2.130','1','2.130','2.130','1'); DELETE FROM tp_kode_intern WHERE kode_dept='TFC'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('TFC','TFC-21523 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZKAB-8-0','00049357','RD','21','0.200 ','320','64'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('TFC-ZKAB-8-0','00049357','RD','2','0.070 ','320','22.4'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261024-0004'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261024-0004'; 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 ('CBRE-ZKAB-9-0','00049358','CBRE-03752 ','CINCIN CBRE-03752 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','872500','2026-11-12','872500','0.460','83.00','75','0','2285000.00','1','0.04', 'input','2026-11-12 10:32:33','0.460','100000','20.25','18200.00','','TOKO','FREETAG','','10','','0','IDB 5 000 000','6','RS11 1B4 1026','BE-261024-0004',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKAB-9-0','00049358'); 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-11-12','CBRE-ZKAB-9-0','CBRE','TOKO','CBRE.BALIK','83.00','0.460','0.460','1','0.460','0.460','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03752 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAB-9-0','00049358','RD','12','0.045 ','450','20.25'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0003','1','CBRE-ZKAB-9-0','1','0.460','0.460','TOKO','CBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKAB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-12','TOKO','SEM-BALIK','CBRE','CBRE-ZKAB-9-0','83.00','1','0.460','0.460','1','0.460','0.460'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.460',berat_out_asli=berat_out_asli+'0.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='CBRE-ZKAB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261112-0003','2026-11-12','2026-11-12','10:32','0.46','input','2026-11-12 10:32:47'); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261030-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261030-0001'; 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 ('CMK-ZKAB-10-0','00049359','CMKE70-71% ','CINCIN MAS KUNING ','','GR','---','GOLD','CMK','TOKO','SEM-EMAS','5889500','2026-11-12','5889500','3.630','71.00','70','0','2285000.00','1','0.14', 'input','2026-11-12 10:34:38','3.630','0','','18200.00','','TOKO','FREETAG','','2','','','','6','','BE-261030-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CMK' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CMK','CMK-ZKAB-10-0','00049359'); 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-11-12','CMK-ZKAB-10-0','CMK','TOKO','SEM-EMAS','71.00','3.630','3.630','1','3.630','3.630','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CMK'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CMK','CMKE70-71% '); UPDATE db_nagagold_elco1.tt_beli_detail SET status='DONE' WHERE no_faktur_beli='BE-261031-0001'; UPDATE db_nagagold_elco1.tt_barang_tukar SET status='DONE' WHERE no_faktur_group='BE-261031-0001'; 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 ('CBRE-ZKAB-11-0','00049360','CBRE-03927 ','CBRE-03927 GIA 6401454346 ','','GR','---','DM','CBRE','TOKO','CBRE.BALIK','4404500','2026-11-12','4404500','2.570','75.00','75.00','0','2285000.00','1','0.04', 'input','2026-11-12 10:41:17','2.570','0','477.75','18200.00','0','TOKO','FREETAG','','10','','0','GDB 47 000 000','4','FVS1 12B8 1026','BE-261031-0001',''); DELETE FROM tp_barang WHERE kode_dept = 'CBRE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('CBRE','CBRE-ZKAB-11-0','00049360'); 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-11-12','CBRE-ZKAB-11-0','CBRE','TOKO','CBRE.BALIK','75.00','2.570','2.570','1','2.570','2.570','1'); DELETE FROM tp_kode_intern WHERE kode_dept='CBRE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('CBRE','CBRE-03927 '); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAB-11-0','00049360','RD','36','0.175 ','450','78.75'); INSERT INTO tm_berlian (kode_barang,kode_barcode,jenis_batu,jml_batu,krt_batu,harga_usd,total_usd) VALUES('CBRE-ZKAB-11-0','00049360','OVAL','1','0.300 ','1330','399'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0004','1','CBRE-ZKAB-11-0','1','2.570','2.570','TOKO','CBRE.BALIK','TOKO','SEM-BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='SEM-BALIK' WHERE kode_barang='CBRE-ZKAB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-12','TOKO','SEM-BALIK','CBRE','CBRE-ZKAB-11-0','75.00','1','2.570','2.570','1','2.570','2.570'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.570',berat_out_asli=berat_out_asli+'2.570',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='CBRE-ZKAB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261112-0004','2026-11-12','2026-11-12','10:41','2.57','input','2026-11-12 10:41:33'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0005','1','ABRE-ZKAB-5-0','1','1.310','1.310','TOKO','SEM-BALIK','TOKO','ABRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='ABRE.BALIK' WHERE kode_barang='ABRE-ZKAB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'1.310',berat_in_asli=berat_in_asli+'1.310',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'1.310',berat_akhir_asli=berat_akhir_asli+'1.310' WHERE tanggal='2026-11-12' AND kode_barang='ABRE-ZKAB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='ABRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.310',berat_out_asli=berat_out_asli+'1.310',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='ABRE-ZKAB-5-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261112-0005','2026-11-12','2026-11-12','10:57','1.31','input','2026-11-12 10:57:54'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0006','1','CBRE-ZKAB-11-0','1','2.570','2.570','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKAB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'2.570',berat_in_asli=berat_in_asli+'2.570',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'2.570',berat_akhir_asli=berat_akhir_asli+'2.570' WHERE tanggal='2026-11-12' AND kode_barang='CBRE-ZKAB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.570',berat_out_asli=berat_out_asli+'2.570',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='CBRE-ZKAB-11-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0006','2','CBRE-ZKAB-7-0','1','0.630','0.630','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKAB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.630',berat_in_asli=berat_in_asli+'0.630',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.630',berat_akhir_asli=berat_akhir_asli+'0.630' WHERE tanggal='2026-11-12' AND kode_barang='CBRE-ZKAB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.630',berat_out_asli=berat_out_asli+'0.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='CBRE-ZKAB-7-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0006','3','CBRE-ZKAB-9-0','1','0.460','0.460','TOKO','SEM-BALIK','TOKO','CBRE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CBRE.BALIK' WHERE kode_barang='CBRE-ZKAB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; UPDATE tt_barang_saldo SET stock_in=stock_in+1 ,berat_in= berat_in+'0.460',berat_in_asli=berat_in_asli+'0.460',stock_akhir=stock_akhir+1, berat_akhir=berat_akhir+'0.460',berat_akhir_asli=berat_akhir_asli+'0.460' WHERE tanggal='2026-11-12' AND kode_barang='CBRE-ZKAB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='CBRE.BALIK'; UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'0.460',berat_out_asli=berat_out_asli+'0.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='CBRE-ZKAB-9-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261112-0006','2026-11-12','2026-11-12','10:58','3.66','input','2026-11-12 10:58:20'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0007','1','CMK-ZKAB-10-0','1','3.630','3.630','TOKO','SEM-EMAS','TOKO','CMKE.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='CMKE.BALIK' WHERE kode_barang='CMK-ZKAB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-12','TOKO','CMKE.BALIK','CMK','CMK-ZKAB-10-0','71.00','1','3.630','3.630','1','3.630','3.630'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.630',berat_out_asli=berat_out_asli+'3.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='CMK-ZKAB-10-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261112-0007','2026-11-12','2026-11-12','10:58','3.63','input','2026-11-12 10:58:39'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0008','1','TFC-ZKAB-8-0','1','2.130','2.130','TOKO','SEM-BALIK','TOKO','TFC.BALIK'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='TFC.BALIK' WHERE kode_barang='TFC-ZKAB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-12','TOKO','TFC.BALIK','TFC','TFC-ZKAB-8-0','75.00','1','2.130','2.130','1','2.130','2.130'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.130',berat_out_asli=berat_out_asli+'2.130',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='TFC-ZKAB-8-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-BALIK' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261112-0008','2026-11-12','2026-11-12','10:58','2.13','input','2026-11-12 10:58:53'); INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-261112-0009','1','TFGRR-ZKAB-6-0','1','2.880','2.880','TOKO','SEM-EMAS','TOKO','GLRTF'); UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='GLRTF' WHERE kode_barang='TFGRR-ZKAB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS'; INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2026-11-12','TOKO','GLRTF','TFGRR','TFGRR-ZKAB-6-0','76.00','1','2.880','2.880','1','2.880','2.880'); UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.880',berat_out_asli=berat_out_asli+'2.880',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-11-12' AND kode_barang='TFGRR-ZKAB-6-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='SEM-EMAS' AND stock_akhir > 0; INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-261112-0009','2026-11-12','2026-11-12','10:58','2.88','input','2026-11-12 10:59:09'); 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-04941'; 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-ZKAB-12-0','00049361','DP-04941JOG ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','435000','2026-11-12','435000','2.130','17.00','10','215000','1200000.00','1','0.14', 'input','2026-11-12 13:23:40','2.130','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04941JOG','1','RS 14','','DP-04941'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKAB-12-0','00049361'); 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-11-12','PSPLT-ZKAB-12-0','PSPLT','TOKO','JOGPSN','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-04941JOG '); 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-04756'; 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-ZKAB-13-0','00049362','DP-04756JOG ','CINCIN PALADIUM SR04 ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','614500','2026-11-12','614500','1.600','32.00','25','205000','1200000.00','1','0.14', 'input','2026-11-12 13:25:14','1.600','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04756JOG','1','RS 11','','DP-04756'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKAB-13-0','00049362'); 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-11-12','PSPLT-ZKAB-13-0','PSPLT','TOKO','JOGPSN','32.00','1.600','1.600','1','1.600','1.600','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04756JOG '); 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-04659'; 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-ZKAB-14-0','00049363','DP-04659SBY ','CINCIN PALADIUM YL10 ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','1455500','2026-11-12','1455500','3.790','32.00','25','200000','1200000.00','1','0.014', 'input','2026-11-12 13:28:21','3.790','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04659SBY','1','RS 22 5','','DP-04659'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKAB-14-0','00049363'); 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-11-12','PSPLT-ZKAB-14-0','PSPLT','TOKO','SBYPSN','32.00','3.790','3.790','1','3.790','3.790','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04659SBY '); 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-04863'; 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-ZKAB-15-0','00049364','DP-04863SBY ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','SBYPSN','783500','2026-11-12','783500','3.840','17.00','10','200000','1200000.00','1','0.014', 'input','2026-11-12 13:29:43','3.840','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04863SBY','1','RS 22','','DP-04863'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKAB-15-0','00049364'); 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-11-12','PSPLT-ZKAB-15-0','PSPLT','TOKO','SBYPSN','17.00','3.840','3.840','1','3.840','3.840','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04863SBY '); 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-04861'; 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-ZKAB-16-0','00049365','DP-04861DU ','CINCIN PERAK YL01 ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','314000','2026-11-12','314000','3.140','100.00','925','305000','100000.00','1','0.14', 'input','2026-11-12 13:32:22','3.140','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04861DU','1','RS 10 RS 20','','DP-04861'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKAB-16-0','00049365'); 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-11-12','PSPRT-ZKAB-16-0','PSPRT','TOKO','DUPSN','100.00','3.140','3.140','1','3.140','3.140','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04861DU '); 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-04813'; 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-ZKAB-17-0','00049366','DP-04813DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','210000','2026-11-12','210000','2.100','100.00','925','195000','100000.00','1','0.14', 'input','2026-11-12 13:33:47','2.100','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04813DU','1','RS 11','','DP-04813'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKAB-17-0','00049366'); 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-11-12','PSPRT-ZKAB-17-0','PSPRT','TOKO','DUPSN','100.00','2.100','2.100','1','2.100','2.100','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04813DU '); 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-04665'; 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-ZKAB-18-0','00049367','DP-04665DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','117000','2026-11-12','117000','1.170','100.00','925','265000','100000.00','1','0.14', 'input','2026-11-12 13:35:31','1.170','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04665DU','1','RS 8','','DP-04665'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKAB-18-0','00049367'); 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-11-12','PSPRT-ZKAB-18-0','PSPRT','TOKO','DUPSN','100.00','1.170','1.170','1','1.170','1.170','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04665DU '); 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-04792'; 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-ZKAB-19-0','00049368','DP-04792DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','724500','2026-11-12','724500','3.550','17.00','10','200000','1200000.00','1','0.14', 'input','2026-11-12 13:36:53','3.550','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04792DU','1','RS 16','','DP-04792'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKAB-19-0','00049368'); 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-11-12','PSPLT-ZKAB-19-0','PSPLT','TOKO','DUPSN','17.00','3.550','3.550','1','3.550','3.550','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04792DU '); 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-04955'; 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-ZKAB-20-0','00049369','DP-04955DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','256000','2026-11-12','256000','2.560','100.00','925','175000','100000.00','1','0.14', 'input','2026-11-12 13:38:18','2.560','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04955DU','1','RS 20','','DP-04955'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKAB-20-0','00049369'); 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-11-12','PSPRT-ZKAB-20-0','PSPRT','TOKO','DUPSN','100.00','2.560','2.560','1','2.560','2.560','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04955DU '); 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-04580'; 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-ZKAB-21-0','00049370','DP-04580DU ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','DUPSN','949000','2026-11-12','949000','2.470','32.00','25','205000','1200000.00','1','0.14', 'input','2026-11-12 13:39:35','2.470','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04580DU','1','RS 15','','DP-04580'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKAB-21-0','00049370'); 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-11-12','PSPLT-ZKAB-21-0','PSPLT','TOKO','DUPSN','32.00','2.470','2.470','1','2.470','2.470','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04580DU '); 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-04889'; 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-ZKAB-22-0','00049371','DP-04889DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','182000','2026-11-12','182000','1.820','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-12 13:40:46','1.820','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04889DU','1','RS 20','','DP-04889'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKAB-22-0','00049371'); 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-11-12','PSPRT-ZKAB-22-0','PSPRT','TOKO','DUPSN','100.00','1.820','1.820','1','1.820','1.820','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04889DU '); 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-04864'; 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-ZKAB-23-0','00049372','DP-04864DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','266000','2026-11-12','266000','2.660','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-12 13:42:17','2.660','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04864DU','1','RS 15 5','','DP-04864'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKAB-23-0','00049372'); 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-11-12','PSPRT-ZKAB-23-0','PSPRT','TOKO','DUPSN','100.00','2.660','2.660','1','2.660','2.660','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04864DU '); 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-03174'; INSERT INTO tm_barang (kode_barang,kode_barcode,kode_intern,nama_barang,nama_atribut,kode_satuan,kode_supplier,kode_group,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,harga_jual,berat,kadar,kadar_cetak,harga_atribut,harga_skrg,stock_on_hand,berat_bandrol,input_by,input_date,berat_asli,ongkos_berlian,total_usd,curr_rp,potongan,gudang_asal,tagid,kadar_beli,profit,harga_modal,berat_atribut,total_usd_ext,no_urut,kode_cetak,no_faktur_beli,no_persekot) VALUES ('PSPLE-ZKAB-24-0','00049373','DP-03174 ','CINCIN PALADIUM ','','GR','---','PSPLE','PSPLE','TOKO','PSN','806000','2026-11-12','806000','3.950','17.00','10','205000','1200000.00','1','0.04', 'input','2026-11-12 13:47:54','3.950','0','','18200.00','','TOKO','FREETAG','','10','','','PSN03174','1','RS 18','','DP-03174'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLE' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLE','PSPLE-ZKAB-24-0','00049373'); 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-11-12','PSPLE-ZKAB-24-0','PSPLE','TOKO','PSN','17.00','3.950','3.950','1','3.950','3.950','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLE'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLE','DP-03174 '); 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-04752'; 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-ZKAB-25-0','00049374','DP-04752JOG ','CINCIN PALADIUM ','','GR','---','PSPLT','PSPLT','TOKO','JOGPSN','960000','2026-11-12','960000','2.500','32.00','25','295000','1200000.00','1','0.14', 'input','2026-11-12 16:43:10','2.500','0','','18200.00','','TOKO','FREETAG','','10','','','PSN04752JOG','1','RS 19','','DP-04752'); DELETE FROM tp_barang WHERE kode_dept = 'PSPLT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPLT','PSPLT-ZKAB-25-0','00049374'); 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-11-12','PSPLT-ZKAB-25-0','PSPLT','TOKO','JOGPSN','32.00','2.500','2.500','1','2.500','2.500','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPLT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPLT','DP-04752JOG '); 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-04865'; 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-ZKAB-26-0','00049375','DP-04865DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','211000','2026-11-12','211000','2.110','100.00','925','225000','100000.00','1','0.14', 'input','2026-11-12 16:45:13','2.110','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04865DU','1','RS 11','','DP-04865'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKAB-26-0','00049375'); 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-11-12','PSPRT-ZKAB-26-0','PSPRT','TOKO','DUPSN','100.00','2.110','2.110','1','2.110','2.110','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04865DU '); 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-04907'; 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-ZKAB-27-0','00049376','DP-04907DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','314000','2026-11-12','314000','3.140','100.00','925','155000','100000.00','1','0.14', 'input','2026-11-12 16:46:41','3.140','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04907DU','1','RS 8 5','','DP-04907'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKAB-27-0','00049376'); 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-11-12','PSPRT-ZKAB-27-0','PSPRT','TOKO','DUPSN','100.00','3.140','3.140','1','3.140','3.140','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04907DU '); 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-04908'; 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-ZKAB-28-0','00049377','DP-04908DU ','CINCIN PERAK ','','GR','---','PSPRT','PSPRT','TOKO','DUPSN','342000','2026-11-12','342000','3.420','100.00','925','150000','100000.00','1','0.14', 'input','2026-11-12 16:47:56','3.420','0','','18200.00','','TOKO','FREETAG','','2','','','PSN04908DU','1','RS 12','','DP-04908'); DELETE FROM tp_barang WHERE kode_dept = 'PSPRT' LIMIT 1; INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('PSPRT','PSPRT-ZKAB-28-0','00049377'); 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-11-12','PSPRT-ZKAB-28-0','PSPRT','TOKO','DUPSN','100.00','3.420','3.420','1','3.420','3.420','1'); DELETE FROM tp_kode_intern WHERE kode_dept='PSPRT'; INSERT INTO tp_kode_intern (kode_dept,no_intern) VALUES ('PSPRT','DP-04908DU '); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0003','1','PSGT-ZKAA-6-0','1','1.960','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAA-6-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKAA-6-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAA-6-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKAA-6-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKAA-6-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.960',berat_out_asli='1.960', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.960',berat_akhir_asli =berat_akhir_asli-'1.960' WHERE kode_barang='PSGT-ZKAA-6-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0003','2','PSPRT-ZKAA-9-0','1','4.350','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAA-9-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAA-9-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAA-9-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAA-9-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKAA-9-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.350',berat_out_asli='4.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.350',berat_akhir_asli =berat_akhir_asli-'4.350' WHERE kode_barang='PSPRT-ZKAA-9-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0003','3','PSPLT-ZKAA-10-0','1','2.980','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAA-10-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAA-10-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAA-10-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAA-10-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-ZKAA-10-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.980',berat_out_asli='2.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.980',berat_akhir_asli =berat_akhir_asli-'2.980' WHERE kode_barang='PSPLT-ZKAA-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-261112-0003','4','PSGT-ZKAA-40-0','1','2.170','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAA-40-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKAA-40-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAA-40-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKAA-40-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKAA-40-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.170',berat_out_asli='2.170', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.170',berat_akhir_asli =berat_akhir_asli-'2.170' WHERE kode_barang='PSGT-ZKAA-40-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0003','5','PSGT-ZKAA-41-0','1','2.010','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAA-41-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKAA-41-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAA-41-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKAA-41-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKAA-41-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.010',berat_out_asli='2.010', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.010',berat_akhir_asli =berat_akhir_asli-'2.010' WHERE kode_barang='PSGT-ZKAA-41-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0003','6','PSGT-ZKAA-42-0','1','1.770','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAA-42-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKAA-42-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAA-42-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKAA-42-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKAA-42-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.770',berat_out_asli='1.770', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.770',berat_akhir_asli =berat_akhir_asli-'1.770' WHERE kode_barang='PSGT-ZKAA-42-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0003','7','PSPRT-ZKAB-16-0','1','3.140','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAB-16-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAB-16-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAB-16-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAB-16-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKAB-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.140',berat_out_asli='3.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.140',berat_akhir_asli =berat_akhir_asli-'3.140' WHERE kode_barang='PSPRT-ZKAB-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-261112-0003','8','PSPRT-ZKAB-17-0','1','2.100','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAB-17-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAB-17-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAB-17-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAB-17-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZKAB-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.100',berat_out_asli='2.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.100',berat_akhir_asli =berat_akhir_asli-'2.100' WHERE kode_barang='PSPRT-ZKAB-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-261112-0003','9','PSPRT-ZKAB-18-0','1','1.170','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAB-18-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAB-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAB-18-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAB-18-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKAB-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='PSPRT-ZKAB-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-261112-0003','10','PSPLT-ZKAB-19-0','1','3.550','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAB-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAB-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAB-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAB-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-ZKAB-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.550',berat_out_asli='3.550', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.550',berat_akhir_asli =berat_akhir_asli-'3.550' WHERE kode_barang='PSPLT-ZKAB-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-261112-0003','11','PSPRT-ZKAB-20-0','1','2.560','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAB-20-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAB-20-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAB-20-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAB-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-ZKAB-20-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.560',berat_out_asli='2.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.560',berat_akhir_asli =berat_akhir_asli-'2.560' WHERE kode_barang='PSPRT-ZKAB-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-261112-0003','12','PSPLT-ZKAB-21-0','1','2.470','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAB-21-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAB-21-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAB-21-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAB-21-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKAB-21-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.470',berat_out_asli='2.470', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.470',berat_akhir_asli =berat_akhir_asli-'2.470' WHERE kode_barang='PSPLT-ZKAB-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-261112-0003','13','PSPRT-ZKAB-22-0','1','1.820','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAB-22-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAB-22-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAB-22-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAB-22-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKAB-22-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.820',berat_out_asli='1.820', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.820',berat_akhir_asli =berat_akhir_asli-'1.820' WHERE kode_barang='PSPRT-ZKAB-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-261112-0003','14','PSPRT-ZKAB-23-0','1','2.660','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAB-23-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAB-23-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAB-23-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAB-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='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-ZKAB-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.660',berat_out_asli='2.660', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.660',berat_akhir_asli =berat_akhir_asli-'2.660' WHERE kode_barang='PSPRT-ZKAB-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-261112-0003','15','PSPRT-ZKAB-26-0','1','2.110','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAB-26-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAB-26-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAB-26-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAB-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='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-ZKAB-26-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.110',berat_out_asli='2.110', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.110',berat_akhir_asli =berat_akhir_asli-'2.110' WHERE kode_barang='PSPRT-ZKAB-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-261112-0003','16','PSPRT-ZKAB-27-0','1','3.140','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAB-27-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAB-27-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAB-27-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAB-27-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKAB-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.140',berat_out_asli='3.140', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.140',berat_akhir_asli =berat_akhir_asli-'3.140' WHERE kode_barang='PSPRT-ZKAB-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-261112-0003','17','PSPRT-ZKAB-28-0','1','3.420','TOKO','DUPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPRT-ZKAB-28-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPRT-ZKAB-28-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPRT-ZKAB-28-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPRT-ZKAB-28-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPRT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPRT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPRT-ZKAB-28-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.420',berat_out_asli='3.420', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.420',berat_akhir_asli =berat_akhir_asli-'3.420' WHERE kode_barang='PSPRT-ZKAB-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-261112-0003','2026-11-12','2026-11-12','16:54','3.420','input','2026-11-12 16:54:02','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0004','1','PSGT-ZKAA-7-0','1','3.070','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAA-7-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKAA-7-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAA-7-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKAA-7-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKAA-7-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.070',berat_out_asli='3.070', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.070',berat_akhir_asli =berat_akhir_asli-'3.070' WHERE kode_barang='PSGT-ZKAA-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-261112-0004','2','PSPLT-ZKAA-8-0','1','3.490','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAA-8-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAA-8-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAA-8-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAA-8-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZKAA-8-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.490',berat_out_asli='3.490', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.490',berat_akhir_asli =berat_akhir_asli-'3.490' WHERE kode_barang='PSPLT-ZKAA-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-261112-0004','3','PSPLT-ZKAA-11-0','1','4.100','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAA-11-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAA-11-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAA-11-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAA-11-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZKAA-11-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.100',berat_out_asli='4.100', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.100',berat_akhir_asli =berat_akhir_asli-'4.100' WHERE kode_barang='PSPLT-ZKAA-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-261112-0004','4','PSGT-ZKAA-43-0','1','2.390','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSGT-ZKAA-43-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSGT-ZKAA-43-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSGT-ZKAA-43-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSGT-ZKAA-43-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSGT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSGT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSGT-ZKAA-43-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.390',berat_out_asli='2.390', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.390',berat_akhir_asli =berat_akhir_asli-'2.390' WHERE kode_barang='PSGT-ZKAA-43-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0004','5','PSPLT-ZKAB-14-0','1','3.790','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAB-14-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAB-14-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAB-14-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAB-14-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-ZKAB-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.790',berat_out_asli='3.790', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.790',berat_akhir_asli =berat_akhir_asli-'3.790' WHERE kode_barang='PSPLT-ZKAB-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-261112-0004','6','PSPLT-ZKAB-15-0','1','3.840','TOKO','SBYPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAB-15-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAB-15-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAB-15-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAB-15-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='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-ZKAB-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='3.840',berat_out_asli='3.840', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'3.840',berat_akhir_asli =berat_akhir_asli-'3.840' WHERE kode_barang='PSPLT-ZKAB-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-261112-0004','2026-11-12','2026-11-12','16:54','3.840','input','2026-11-12 16:54:17','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0005','1','PSPLT-ZKAB-12-0','1','2.130','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAB-12-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAB-12-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAB-12-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAB-12-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKAB-12-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-ZKAB-12-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0005','2','PSPLT-ZKAB-13-0','1','1.600','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAB-13-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAB-13-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAB-13-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAB-13-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKAB-13-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.600' WHERE kode_barang='PSPLT-ZKAB-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-261112-0005','3','PSPLT-ZKAB-25-0','1','2.500','TOKO','JOGPSN'); DELETE FROM tm_barang_export WHERE kode_barang='PSPLT-ZKAB-25-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSPLT-ZKAB-25-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSPLT-ZKAB-25-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSPLT-ZKAB-25-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSPLT' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSPLT' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='JOGPSN'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='JOGPSN'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSPLT-ZKAB-25-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.500',berat_out_asli='2.500', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.500',berat_akhir_asli =berat_akhir_asli-'2.500' WHERE kode_barang='PSPLT-ZKAB-25-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261112-0005','2026-11-12','2026-11-12','16:54','2.500','input','2026-11-12 16:54:28','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0006','1','LXPER-ZKAA-12-0','1','2.220','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-12-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-12-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-12-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-12-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-12-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.220',berat_out_asli='2.220', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.220',berat_akhir_asli =berat_akhir_asli-'2.220' WHERE kode_barang='LXPER-ZKAA-12-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0006','2','LXPER-ZKAA-13-0','1','1.630','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-13-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-13-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-13-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-13-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-13-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.630',berat_out_asli='1.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.630',berat_akhir_asli =berat_akhir_asli-'1.630' WHERE kode_barang='LXPER-ZKAA-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-261112-0006','3','LXPER-ZKAA-14-0','1','1.980','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-14-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-14-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-14-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-14-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-14-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.980',berat_out_asli='1.980', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.980',berat_akhir_asli =berat_akhir_asli-'1.980' WHERE kode_barang='LXPER-ZKAA-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-261112-0006','4','LXPER-ZKAA-15-0','1','1.650','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-15-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-15-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-15-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-15-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-15-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.650',berat_out_asli='1.650', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.650',berat_akhir_asli =berat_akhir_asli-'1.650' WHERE kode_barang='LXPER-ZKAA-15-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0006','5','LXPER-ZKAA-16-0','1','2.570','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-16-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-16-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-16-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-16-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-16-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.570',berat_out_asli='2.570', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.570',berat_akhir_asli =berat_akhir_asli-'2.570' WHERE kode_barang='LXPER-ZKAA-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-261112-0006','6','LXPER-ZKAA-17-0','1','2.540','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-17-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-17-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-17-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-17-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-17-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.540',berat_out_asli='2.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.540',berat_akhir_asli =berat_akhir_asli-'2.540' WHERE kode_barang='LXPER-ZKAA-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-261112-0006','7','LXPER-ZKAA-18-0','1','2.540','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-18-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-18-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-18-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-18-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-18-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.540',berat_out_asli='2.540', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.540',berat_akhir_asli =berat_akhir_asli-'2.540' WHERE kode_barang='LXPER-ZKAA-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-261112-0006','8','LXPER-ZKAA-19-0','1','4.630','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-19-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-19-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-19-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-19-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-19-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.630',berat_out_asli='4.630', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.630',berat_akhir_asli =berat_akhir_asli-'4.630' WHERE kode_barang='LXPER-ZKAA-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-261112-0006','9','LXPER-ZKAA-20-0','1','3.650','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-20-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-20-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-20-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-20-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-20-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='LXPER-ZKAA-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-261112-0006','10','LXPER-ZKAA-21-0','1','1.680','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-21-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-21-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-21-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-21-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-21-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.680',berat_out_asli='1.680', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.680',berat_akhir_asli =berat_akhir_asli-'1.680' WHERE kode_barang='LXPER-ZKAA-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-261112-0006','11','LXPER-ZKAA-22-0','1','1.600','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-22-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-22-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-22-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-22-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-22-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.600',berat_out_asli='1.600', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.600',berat_akhir_asli =berat_akhir_asli-'1.600' WHERE kode_barang='LXPER-ZKAA-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-261112-0006','12','LXPER-ZKAA-23-0','1','2.340','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-23-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-23-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-23-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-23-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-23-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.340',berat_out_asli='2.340', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.340',berat_akhir_asli =berat_akhir_asli-'2.340' WHERE kode_barang='LXPER-ZKAA-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-261112-0006','13','LXPER-ZKAA-24-0','1','1.350','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-24-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-24-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-24-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-24-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-24-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.350',berat_out_asli='1.350', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.350',berat_akhir_asli =berat_akhir_asli-'1.350' WHERE kode_barang='LXPER-ZKAA-24-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0006','14','LXPER-ZKAA-45-0','1','2.670','TOKO','DUPER'); DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZKAA-45-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='LXPER-ZKAA-45-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='LXPER-ZKAA-45-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='LXPER-ZKAA-45-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='LXPER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='DUPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='DUPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='LXPER-ZKAA-45-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.670',berat_out_asli='2.670', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.670',berat_akhir_asli =berat_akhir_asli-'2.670' WHERE kode_barang='LXPER-ZKAA-45-0' AND stock_akhir ='1'; INSERT INTO tt_export_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date,tujuan_toko) VALUES ('EX-261112-0006','2026-11-12','2026-11-12','16:54','2.670','input','2026-11-12 16:54:41','THIFA'); INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0007','1','PSBY-ZKAA-25-0','1','1.990','TOKO','SBYPER'); DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZKAA-25-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZKAA-25-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZKAA-25-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZKAA-25-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZKAA-25-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.990',berat_out_asli='1.990', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.990',berat_akhir_asli =berat_akhir_asli-'1.990' WHERE kode_barang='PSBY-ZKAA-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-261112-0007','2','PSBY-ZKAA-26-0','1','2.270','TOKO','SBYPER'); DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZKAA-26-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZKAA-26-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZKAA-26-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZKAA-26-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZKAA-26-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.270',berat_out_asli='2.270', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.270',berat_akhir_asli =berat_akhir_asli-'2.270' WHERE kode_barang='PSBY-ZKAA-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-261112-0007','3','PSBY-ZKAA-27-0','1','1.690','TOKO','SBYPER'); DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZKAA-27-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZKAA-27-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZKAA-27-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZKAA-27-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZKAA-27-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.690',berat_out_asli='1.690', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.690',berat_akhir_asli =berat_akhir_asli-'1.690' WHERE kode_barang='PSBY-ZKAA-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-261112-0007','4','PSBY-ZKAA-28-0','1','4.560','TOKO','SBYPER'); DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZKAA-28-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZKAA-28-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZKAA-28-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZKAA-28-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZKAA-28-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='4.560',berat_out_asli='4.560', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'4.560',berat_akhir_asli =berat_akhir_asli-'4.560' WHERE kode_barang='PSBY-ZKAA-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-261112-0007','5','PSBY-ZKAA-29-0','1','2.450','TOKO','SBYPER'); DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZKAA-29-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZKAA-29-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZKAA-29-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZKAA-29-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZKAA-29-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='2.450',berat_out_asli='2.450', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'2.450',berat_akhir_asli =berat_akhir_asli-'2.450' WHERE kode_barang='PSBY-ZKAA-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-261112-0007','6','PSBY-ZKAA-30-0','1','1.400','TOKO','SBYPER'); DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZKAA-30-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZKAA-30-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZKAA-30-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZKAA-30-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZKAA-30-0'; UPDATE tt_barang_saldo set stock_out='1',berat_out='1.400',berat_out_asli='1.400', stock_akhir = stock_akhir-'1',berat_akhir =berat_akhir-'1.400',berat_akhir_asli =berat_akhir_asli-'1.400' WHERE kode_barang='PSBY-ZKAA-30-0' AND stock_akhir ='1'; INSERT INTO tt_export_detail (no_pindah,no_urut,kode_barang,qty,berat,gudang_asal,lokasi_asal) VALUES ('EX-261112-0007','7','PSBY-ZKAA-31-0','1','2.380','TOKO','SBYPER'); DELETE FROM tm_barang_export WHERE kode_barang='PSBY-ZKAA-31-0' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_barang_export SELECT * FROM tm_barang WHERE kode_barang='PSBY-ZKAA-31-0' LIMIT 1; DELETE FROM tm_berlian_export WHERE kode_barang='PSBY-ZKAA-31-0'; INSERT INTO db_nagagold_elco2.tm_berlian_export SELECT * FROM tm_berlian WHERE kode_barang='PSBY-ZKAA-31-0'; DELETE FROM db_nagagold_elco2.tm_group_export WHERE kode_group='PER' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_group_export SELECT * FROM tm_group WHERE kode_group='PER' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_dept_export WHERE kode_dept='PSBY' LIMIT 1; INSERT INTO db_nagagold_elco2.tm_dept_export SELECT * FROM tm_dept WHERE kode_dept='PSBY' LIMIT 1; DELETE FROM db_nagagold_elco2.tm_lokasi_toko_export WHERE kode_lokasi_toko='SBYPER'; INSERT INTO db_nagagold_elco2.tm_lokasi_toko_export SELECT * FROM tm_lokasi_toko WHERE kode_lokasi_toko='SBYPER'; UPDATE tm_barang set stock_on_hand='0' WHERE kode_barang='PSBY-ZKAA-31-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='PSBY-ZKAA-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-261112-0007','2026-11-12','2026-11-12','16:54','2.380','input','2026-11-12 16:54:56','THIFA');