INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-10 ','10:01:22');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-04-10','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-03-10';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-04-09';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-04-09';
INSERT INTO tt_barang_saldo (kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_awal,berat_awal_asli,stock_awal,berat_akhir,berat_akhir_asli,stock_akhir) SELECT kode_barang,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,kadar,berat_akhir,berat_akhir_asli,stock_akhir,berat_akhir,berat_akhir_asli,stock_akhir FROM tt_barang_saldo WHERE tanggal='2026-04-09' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-04-09';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-04-09';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-04-09';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-04-09';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202603 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-03';
UPDATE tt_barang_saldo SET tanggal= '2026-04-10' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-04-09' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','TBC','SALDO AWAL','SALDO AWAL','0','21451937514','21451937514');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','BCD','SALDO AWAL','SALDO AWAL','0','1356733500','1356733500');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','','SALDO AWAL','SALDO AWAL','0','250000','250000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','TOP','SALDO AWAL','SALDO AWAL','0','255107000','255107000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','MANDIRI','SALDO AWAL','SALDO AWAL','0','45890000','45890000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','TMR','SALDO AWAL','SALDO AWAL','0','31400000','31400000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','BNK','SALDO AWAL','SALDO AWAL','0','14200000','14200000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','DPE','SALDO AWAL','SALDO AWAL','0','850000','850000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','BNI','SALDO AWAL','SALDO AWAL','0','38506000','38506000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','SHO','SALDO AWAL','SALDO AWAL','0','142865650','142865650');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','KET','SALDO AWAL','SALDO AWAL','0','152646000','152646000');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260410-0001','D','2026-04-10','10:06:45','BCK','SALDO AWAL','SALDO AWAL','0','1980308000','1980308000');
UPDATE tp_system SET tgl_system='2026-04-10';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-10 ','10:51:56');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','10:58:14');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','11:46:22');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260410-0001','kasirbip','1',' 900K-8-220','TOKO','BIPPER','PBDG-ZBXE-11-0','CINCIN SILVER 925 ','','1.460','1','100.00','149000','0','0','17000','1000000','0','0','0','1000000','SULIS','00041334','PBDG','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='PBDG-ZBXE-11-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.460',berat_jual_asli=berat_jual_asli+'1.460',stock_jual='1',berat_akhir=berat_akhir-'1.460',berat_akhir_asli=berat_akhir_asli-'1.460',stock_akhir='0' WHERE tanggal='2026-04-10' AND kode_barang='PBDG-ZBXE-11-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BIPPER' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260410-0001','2026-04-10','1.460','2026-04-10','11:52:50','PLG0010341','1000000','1000000','0','1000000','0','kasirbip','2026-04-10 11:52:50','FJ-260410-0001','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-10','FJ-260410-0001','2026-04-10','11:52:50','SULIS','1000000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260410-0001','2026-04-10','2026-04-10 11:52:50','PENJUALAN : FJ-260410-0001','.','TBC','1000000','1000000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260410-0002','D','2026-04-10','11:52:50','TBC','PENJUALAN','FJ-260410-0001','21451937514','1000000','21452937514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='1000000' WHERE no_faktur_jual='FJ-260410-0001' LIMIT 1;
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','11:55:28');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260410-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260410-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260410-0001';
INSERT INTO tt_service_detail(no_service,sales_id,no_urut,nama_barang,deskripsi,berat,qty,ongkos_detail,jml_detail_rp) VALUES('SV-01939','SULIS','1','SEPASANG SILVER','FONT VINTAGE ROTTER','2.000','1','0','0');
INSERT INTO tt_service_head(no_service,tgl_system,tgl_service,jam_service,kode_customer,sales_id,tgl_ambil,input_by,input_date,berat,dibayar_rp,card_rp,debet_rp,transfer_rp,card_fee_rp,ongkos_rp,jml_awal_rp,sld_akhir_rp) VALUES('SV-01939','2026-04-10','2026-04-10','13:41:23','PLG0010342','kasirbip','2026-04-28','kasirbip','2026-04-10 13:41:23','2.000','0','0','0','0','0','0','0','0');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-1-0','1','2.570','2.570','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-1-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-1-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-1-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-1-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-1-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-1-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-1-0','1','2.570','2.570','1','2.570','2.570','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-1-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-1-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-2-0','1','2.810','2.810','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-2-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-2-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-2-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-2-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-2-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-2-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-2-0','1','2.810','2.810','1','2.810','2.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-2-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-2-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-3-0','1','1.810','1.810','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-3-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-3-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-3-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-3-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-3-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-3-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-3-0','1','1.810','1.810','1','1.810','1.810','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-3-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-3-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-4-0','1','1.800','1.800','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-4-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-4-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-4-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-4-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-4-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-4-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-4-0','1','1.800','1.800','1','1.800','1.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-4-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-4-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-5-0','1','1.760','1.760','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-5-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-5-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-5-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-5-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-5-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-5-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-5-0','1','1.760','1.760','1','1.760','1.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-5-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-5-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-6-0','1','1.800','1.800','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-6-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-6-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-6-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-6-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-6-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-6-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-6-0','1','1.800','1.800','1','1.800','1.800','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-6-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-6-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-7-0','1','1.230','1.230','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-7-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-7-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-7-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-7-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-7-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-7-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-7-0','1','1.230','1.230','1','1.230','1.230','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-7-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-7-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-8-0','1','3.010','3.010','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-8-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-8-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-8-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-8-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-8-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-8-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-8-0','1','3.010','3.010','1','3.010','3.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-8-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-8-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-9-0','1','2.890','2.890','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-9-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-9-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-9-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-9-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-9-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-9-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-9-0','1','2.890','2.890','1','2.890','2.890','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-9-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-9-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-10-0','1','1.980','1.980','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-10-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-10-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-10-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-10-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-10-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-10-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-10-0','1','1.980','1.980','1','1.980','1.980','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-10-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-10-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-11-0','1','1.190','1.190','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-11-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-11-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-11-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-11-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-11-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-11-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-11-0','1','1.190','1.190','1','1.190','1.190','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-11-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-11-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-12-0','1','1.840','1.840','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-12-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-12-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-12-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-12-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-12-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-12-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-12-0','1','1.840','1.840','1','1.840','1.840','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-12-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-12-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-13-0','1','1.510','1.510','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-13-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-13-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-13-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-13-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-13-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-13-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-13-0','1','1.510','1.510','1','1.510','1.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-13-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-13-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-14-0','1','1.630','1.630','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-14-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-14-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-14-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-14-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-14-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-14-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-14-0','1','1.630','1.630','1','1.630','1.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-14-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-14-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-15-0','1','3.420','3.420','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-15-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-15-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-15-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-15-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-15-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-15-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-15-0','1','3.420','3.420','1','3.420','3.420','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-15-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-15-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-16-0','1','3.180','3.180','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-16-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-16-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-16-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-16-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-16-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-16-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-16-0','1','3.180','3.180','1','3.180','3.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-16-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-16-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-17-0','1','2.740','2.740','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-17-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-17-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-17-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-17-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-17-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-17-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-17-0','1','2.740','2.740','1','2.740','2.740','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-17-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-17-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-18-0','1','2.610','2.610','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-18-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-18-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-18-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-18-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-18-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-18-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-18-0','1','2.610','2.610','1','2.610','2.610','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-18-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-18-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-19-0','1','4.000','4.000','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-19-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-19-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-19-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-19-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-19-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-19-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-19-0','1','4.000','4.000','1','4.000','4.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-19-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-19-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0001','1','PBDG-ZDXI-20-0','1','3.170','3.170','TOKO','PBDG','TOKO','BIPPER');
DELETE FROM tm_barang WHERE kode_barang='PBDG-ZDXI-20-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-20-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='PBDG-ZDXI-20-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='PBDG-ZDXI-20-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='BIPPER',tgl_last_beli='2026-04-10 14:41:24' WHERE kode_barang='PBDG-ZDXI-20-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='PBDG-ZDXI-20-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 14:41:24','TOKO','BIPPER','PBDG','PBDG-ZDXI-20-0','1','3.170','3.170','1','3.170','3.170','100.00');
DELETE FROM tm_dept WHERE kode_dept='PBDG' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='PBDG' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='PBDG-ZDXI-20-0';
DELETE FROM tm_barang_export WHERE kode_barang='PBDG-ZDXI-20-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260410-0001','2026-04-10','14:40','46.950','kasirbip','2026-04-10 14:41:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','14:58:49');
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-21-0','1','4.370','4.370','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-21-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-21-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-21-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-21-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-21-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-21-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-21-0','1','4.370','4.370','1','4.370','4.370','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-21-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-21-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-22-0','1','4.150','4.150','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-22-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-22-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-22-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-22-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-22-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-22-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-22-0','1','4.150','4.150','1','4.150','4.150','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-22-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-22-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-23-0','1','4.620','4.620','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-23-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-23-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-23-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-23-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-23-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-23-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-23-0','1','4.620','4.620','1','4.620','4.620','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-23-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-23-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-24-0','1','4.180','4.180','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-24-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-24-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-24-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-24-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-24-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-24-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-24-0','1','4.180','4.180','1','4.180','4.180','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-24-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-24-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-25-0','1','1.630','1.630','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-25-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-25-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-25-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-25-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-25-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-25-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-25-0','1','1.630','1.630','1','1.630','1.630','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-25-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-25-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-26-0','1','1.560','1.560','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-26-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-26-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-26-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-26-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-26-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-26-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-26-0','1','1.560','1.560','1','1.560','1.560','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-26-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-26-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-27-0','1','1.510','1.510','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-27-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-27-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-27-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-27-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-27-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-27-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-27-0','1','1.510','1.510','1','1.510','1.510','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-27-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-27-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-28-0','1','4.470','4.470','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-28-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-28-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-28-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-28-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-28-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-28-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-28-0','1','4.470','4.470','1','4.470','4.470','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-28-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-28-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-29-0','1','1.940','1.940','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-29-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-29-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-29-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-29-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-29-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-29-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-29-0','1','1.940','1.940','1','1.940','1.940','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-29-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-29-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-30-0','1','1.990','1.990','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-30-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-30-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-30-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-30-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-30-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-30-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-30-0','1','1.990','1.990','1','1.990','1.990','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-30-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-30-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-31-0','1','2.350','2.350','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-31-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-31-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-31-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-31-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-31-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-31-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-31-0','1','2.350','2.350','1','2.350','2.350','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-31-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-31-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-32-0','1','2.460','2.460','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-32-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-32-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-32-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-32-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-32-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-32-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-32-0','1','2.460','2.460','1','2.460','2.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-32-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-32-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-33-0','1','2.460','2.460','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-33-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-33-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-33-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-33-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-33-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-33-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-33-0','1','2.460','2.460','1','2.460','2.460','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-33-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-33-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-34-0','1','1.360','1.360','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-34-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-34-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-34-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-34-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-34-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-34-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-34-0','1','1.360','1.360','1','1.360','1.360','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-34-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-34-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-35-0','1','3.100','3.100','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-35-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-35-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-35-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-35-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-35-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-35-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-35-0','1','3.100','3.100','1','3.100','3.100','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-35-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-35-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-36-0','1','2.000','2.000','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-36-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-36-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-36-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-36-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-36-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-36-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-36-0','1','2.000','2.000','1','2.000','2.000','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-36-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-36-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-37-0','1','2.590','2.590','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-37-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-37-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-37-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-37-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-37-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-37-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-37-0','1','2.590','2.590','1','2.590','2.590','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-37-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-37-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-38-0','1','1.760','1.760','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-38-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-38-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-38-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-38-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-38-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-38-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-38-0','1','1.760','1.760','1','1.760','1.760','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-38-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-38-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-39-0','1','2.010','2.010','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-39-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-39-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-39-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-39-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-39-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-39-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-39-0','1','2.010','2.010','1','2.010','2.010','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-39-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-39-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-40-0','1','3.110','3.110','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-40-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-40-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-40-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-40-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-40-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-40-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-40-0','1','3.110','3.110','1','3.110','3.110','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-40-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-40-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-41-0','1','2.400','2.400','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-41-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-41-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-41-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-41-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-41-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-41-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-41-0','1','2.400','2.400','1','2.400','2.400','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-41-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-41-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-42-0','1','3.870','3.870','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-42-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-42-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-42-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-42-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-42-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-42-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-42-0','1','3.870','3.870','1','3.870','3.870','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-42-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-42-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_detail(no_terima,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('TB-20260410-0002','1','LXPER-ZDXI-43-0','1','3.320','3.320','TOKO','DUPER','TOKO','DUPER');
DELETE FROM tm_barang WHERE kode_barang='LXPER-ZDXI-43-0' LIMIT 1;
INSERT INTO tm_barang SELECT * FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-43-0' LIMIT 1;
DELETE FROM tm_berlian WHERE kode_barang='LXPER-ZDXI-43-0';
INSERT INTO tm_berlian SELECT * FROM tm_berlian_export WHERE kode_barang='LXPER-ZDXI-43-0';
UPDATE tm_barang SET kode_lokasi_gudang='TOKO',kode_lokasi_toko='DUPER',tgl_last_beli='2026-04-10 15:00:50' WHERE kode_barang='LXPER-ZDXI-43-0' LIMIT 1;
DELETE FROM tt_barang_saldo WHERE kode_barang='LXPER-ZDXI-43-0' LIMIT 1;
INSERT INTO tt_barang_saldo (tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli,kadar) VALUES ('2026-04-10 15:00:50','TOKO','DUPER','LXPER','LXPER-ZDXI-43-0','1','3.320','3.320','1','3.320','3.320','100.00');
DELETE FROM tm_dept WHERE kode_dept='LXPER' LIMIT 1;
INSERT INTO tm_dept SELECT * FROM tm_dept_export WHERE kode_dept='LXPER' LIMIT 1;
DELETE FROM tm_group WHERE kode_group='PER' LIMIT 1;
INSERT INTO tm_group SELECT * FROM tm_group_export WHERE kode_group='PER' LIMIT 1;
UPDATE tt_export_detail SET status_close='DONE' WHERE kode_barang='LXPER-ZDXI-43-0';
DELETE FROM tm_barang_export WHERE kode_barang='LXPER-ZDXI-43-0';
UPDATE tt_beli_detail SET tgl_terima='2026-04-10' WHERE no_faktur_beli='';
INSERT INTO tt_terima_brg_head(no_terima,tgl_terima,jam_terima,jml_berat,input_by,input_date) VALUES ('TB-20260410-0002','2026-04-10','14:59','63.210','kasirbip','2026-04-10 15:00:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','15:12:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','15:46:13');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-10 ','15:53:45');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','15:54:20');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','15:55:46');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-04-10 ','15:56:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','15:57:32');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','16:15:36');
UPDATE th_user_login SET tgl_logout = '2026-04-10', jam_logout = '16:44:10' WHERE user_id = 'kasirbip' AND tgl_login = '2026-04-10' AND jam_login= '16:15:36';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-04-10 ','16:44:33');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-04-10 ','16:50:27');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-04-10 ','16:50:41');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('spv','2026-04-10 ','16:50:52');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-10 ','16:51:07');
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-260410-0001','1','LXPER-ZDXI-32-0','1','2.460','2.460','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-32-0','100.00','1','2.460','2.460','1','2.460','2.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.460',berat_out_asli=berat_out_asli+'2.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-32-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0001','2','LXPER-ZDXI-43-0','1','3.320','3.320','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-43-0','100.00','1','3.320','3.320','1','3.320','3.320');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.320',berat_out_asli=berat_out_asli+'3.320',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-43-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0001','2026-04-10','2026-04-10','16:49','5.78','Nagatech','2026-04-10 16:55:08');
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-260410-0002','1','LXPER-ZDXI-42-0','1','3.870','3.870','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-42-0','100.00','1','3.870','3.870','1','3.870','3.870');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.870',berat_out_asli=berat_out_asli+'3.870',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-42-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0002','2026-04-10','2026-04-10','16:56','3.87','Nagatech','2026-04-10 16:56:41');
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-260410-0003','1','LXPER-ZDXI-41-0','1','2.400','2.400','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-41-0','100.00','1','2.400','2.400','1','2.400','2.400');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.400',berat_out_asli=berat_out_asli+'2.400',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-41-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','2','LXPER-ZDXI-40-0','1','3.110','3.110','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-40-0','100.00','1','3.110','3.110','1','3.110','3.110');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.110',berat_out_asli=berat_out_asli+'3.110',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-40-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','3','LXPER-ZDXI-39-0','1','2.010','2.010','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-39-0','100.00','1','2.010','2.010','1','2.010','2.010');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.010',berat_out_asli=berat_out_asli+'2.010',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-39-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','4','LXPER-ZDXI-38-0','1','1.760','1.760','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-38-0','100.00','1','1.760','1.760','1','1.760','1.760');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.760',berat_out_asli=berat_out_asli+'1.760',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-38-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','5','LXPER-ZDXI-37-0','1','2.590','2.590','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-37-0','100.00','1','2.590','2.590','1','2.590','2.590');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.590',berat_out_asli=berat_out_asli+'2.590',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-37-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','6','LXPER-ZDXI-36-0','1','2.000','2.000','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-36-0','100.00','1','2.000','2.000','1','2.000','2.000');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.000',berat_out_asli=berat_out_asli+'2.000',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-36-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','7','LXPER-ZDXI-35-0','1','3.100','3.100','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-35-0','100.00','1','3.100','3.100','1','3.100','3.100');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'3.100',berat_out_asli=berat_out_asli+'3.100',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-35-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','8','LXPER-ZDXI-34-0','1','1.360','1.360','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-34-0','100.00','1','1.360','1.360','1','1.360','1.360');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.360',berat_out_asli=berat_out_asli+'1.360',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-34-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','9','LXPER-ZDXI-33-0','1','2.460','2.460','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-33-0','100.00','1','2.460','2.460','1','2.460','2.460');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.460',berat_out_asli=berat_out_asli+'2.460',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-33-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','10','LXPER-ZDXI-21-0','1','4.370','4.370','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-21-0','100.00','1','4.370','4.370','1','4.370','4.370');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.370',berat_out_asli=berat_out_asli+'4.370',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-21-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','11','LXPER-ZDXI-31-0','1','2.350','2.350','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-31-0','100.00','1','2.350','2.350','1','2.350','2.350');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'2.350',berat_out_asli=berat_out_asli+'2.350',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-31-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','12','LXPER-ZDXI-30-0','1','1.990','1.990','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-30-0','100.00','1','1.990','1.990','1','1.990','1.990');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.990',berat_out_asli=berat_out_asli+'1.990',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-30-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','13','LXPER-ZDXI-29-0','1','1.940','1.940','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-29-0','100.00','1','1.940','1.940','1','1.940','1.940');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.940',berat_out_asli=berat_out_asli+'1.940',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-29-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','14','LXPER-ZDXI-28-0','1','4.470','4.470','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-28-0','100.00','1','4.470','4.470','1','4.470','4.470');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.470',berat_out_asli=berat_out_asli+'4.470',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-28-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','15','LXPER-ZDXI-27-0','1','1.510','1.510','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-27-0','100.00','1','1.510','1.510','1','1.510','1.510');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.510',berat_out_asli=berat_out_asli+'1.510',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-27-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','16','LXPER-ZDXI-26-0','1','1.560','1.560','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-26-0','100.00','1','1.560','1.560','1','1.560','1.560');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.560',berat_out_asli=berat_out_asli+'1.560',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-26-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','17','LXPER-ZDXI-25-0','1','1.630','1.630','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-25-0','100.00','1','1.630','1.630','1','1.630','1.630');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.630',berat_out_asli=berat_out_asli+'1.630',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-25-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','18','LXPER-ZDXI-24-0','1','4.180','4.180','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-24-0','100.00','1','4.180','4.180','1','4.180','4.180');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.180',berat_out_asli=berat_out_asli+'4.180',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-24-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','19','LXPER-ZDXI-23-0','1','4.620','4.620','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-23-0','100.00','1','4.620','4.620','1','4.620','4.620');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.620',berat_out_asli=berat_out_asli+'4.620',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-23-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','20','LXPER-ZDXI-22-0','1','4.150','4.150','TOKO','DUPER','TOKO','DUPERBDG');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='DUPERBDG' WHERE kode_barang='LXPER-ZDXI-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER';
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-04-10','TOKO','DUPERBDG','LXPER','LXPER-ZDXI-22-0','100.00','1','4.150','4.150','1','4.150','4.150');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'4.150',berat_out_asli=berat_out_asli+'4.150',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2026-04-10' AND kode_barang='LXPER-ZDXI-22-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='DUPER' 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-260410-0003','2026-04-10','2026-04-10','16:56','53.56','Nagatech','2026-04-10 17:31:02');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-10 ','19:15:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-10 ','19:29:39');
UPDATE th_user_login SET tgl_logout = '2026-04-10', jam_logout = '19:42:52' WHERE user_id = 'kasir' AND tgl_login = '2026-04-10' AND jam_login= '10:51:56';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('Nagatech','2026-04-10 ','19:44:16');
DELETE FROM tm_berlian WHERE kode_barang='TFCMR-YIXA-31-0';
INSERT INTO th_barang_update(kode_barang,old_kode_barcode,kode_barcode,old_nama_barang,nama_barang,old_nama_atribut,nama_atribut,old_harga_beli,harga_beli,old_harga_atribut,harga_atribut, input_by,input_date) VALUES ('TFCMR-YIXA-31-0','00038401','00038401','THIFA CINCIN MAS RG ','THIFA CINCIN MAS RG','','','2817500','2817500',' 0','0','Nagatech','2026-04-10 19:46:20');
UPDATE tm_barang SET nama_barang='THIFA CINCIN MAS RG' ,nama_atribut='' ,kode_intern='TFCMR75-84% ', kadar_cetak='75.00', potongan='0',tagid='FREETAG',harga_modal='0',kode_cetak='',total_usd_ext='',total_usd='0' WHERE kode_barang='TFCMR-YIXA-31-0' LIMIT 1;
UPDATE th_user_login SET tgl_logout = '2026-04-10', jam_logout = '19:46:29' WHERE user_id = 'Nagatech' AND tgl_login = '2026-04-10' AND jam_login= '19:44:16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasir','2026-04-10 ','19:46:52');
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260410-0002','kasir','1',' TFCMP75-85','TOKO','TFCINMAS','TFCMP-ZBBF-67-0','THIFA CINCIN MAS PUTIH ','','1.660','1','85.00','3714000','0','0','17000','3750000','0','0','0','3750000','RISIANA','00041966','TFCMP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMP-ZBBF-67-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.660',berat_jual_asli=berat_jual_asli+'1.660',stock_jual='1',berat_akhir=berat_akhir-'1.660',berat_akhir_asli=berat_akhir_asli-'1.660',stock_akhir='0' WHERE tanggal='2026-04-10' AND kode_barang='TFCMP-ZBBF-67-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260410-0002','2026-04-10','1.660','2026-04-10','19:48:49','PLG0010343','3750000','3750000','0','3750000','0','kasir','2026-04-10 19:48:48','FJ-260410-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-10','FJ-260410-0002','2026-04-10','19:48:49','RISIANA','3750000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260410-0002','2026-04-10','2026-04-10 19:48:48','PENJUALAN : FJ-260410-0002','.','TBC','3750000','3750000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260410-0003','D','2026-04-10','19:48:49','TBC','PENJUALAN','FJ-260410-0002','21452937514','3750000','21456687514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='3750000' WHERE no_faktur_jual='FJ-260410-0002' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260410-0003','kasir',' 1',' TFCMR75-84','TOKO','TFCINMAS','TFCMR-YIXA-31-0','THIFA CINCIN MAS RG','','1.300','1','84.00','2874000','0','0','17000','2950000','0','0','0','2950000','RISIANA','00038401','TFCMR','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFCMR-YIXA-31-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.300',berat_jual_asli=berat_jual_asli+'1.300',stock_jual='1',berat_akhir=berat_akhir-'1.300',berat_akhir_asli=berat_akhir_asli-'1.300',stock_akhir='0' WHERE tanggal='2026-04-10' AND kode_barang='TFCMR-YIXA-31-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFCINMAS' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260410-0003','2026-04-10','1.300','2026-04-10','19:48:49','PLG0010344','2950000','2950000','0','2950000','0','kasir','2026-04-10 19:48:48','FJ-260410-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-10','FJ-260410-0003','2026-04-10','19:48:49','RISIANA','2950000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260410-0003','2026-04-10','2026-04-10 19:48:48','PENJUALAN : FJ-260410-0003','.','TBC','2950000','2950000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260410-0004','D','2026-04-10','19:48:49','TBC','PENJUALAN','FJ-260410-0003','21456687514','2950000','21459637514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='6700000' WHERE no_faktur_jual='FJ-260410-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp,keterangan) VALUES ('FJ-260410-0004','kasir',' 1',' TFKMP75-85','TOKO','TFKMP','TFKMP-ZBBF-16-0','THIFA KALUNG MAS PUTIH ','','2.670','1','85.00','5973000','0','0','17000','6050000','0','0','0','6050000','RISIANA','00041915','TFKMP','0','0','-','0','');
UPDATE tm_barang SET tgl_last_jual='2026-04-10', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='TFKMP-ZBBF-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.670',berat_jual_asli=berat_jual_asli+'2.670',stock_jual='1',berat_akhir=berat_akhir-'2.670',berat_akhir_asli=berat_akhir_asli-'2.670',stock_akhir='0' WHERE tanggal='2026-04-10' AND kode_barang='TFKMP-ZBBF-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='TFKMP' AND stock_akhir > 0 LIMIT 1;
INSERT INTO tt_jual_head(no_faktur_jual,tgl_system,berat,tgl_faktur_jual,jam_faktur_jual,kode_customer,dpp_bruto_rp,dpp_netto_rp,ongkos_rp,jml_jual_rp,dibayar_rp,input_by,input_date,no_faktur_group,no_persekot,dp_pesanan) VALUES ('FJ-260410-0004','2026-04-10','2.670','2026-04-10','19:48:49','PLG0010345','6050000','6050000','0','6050000','0','kasir','2026-04-10 19:48:48','FJ-260410-0002','','POTONG');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2026-04-10','FJ-260410-0004','2026-04-10','19:48:49','RISIANA','6050000','0');
INSERT INTO tt_transfer(no_trx,tgl_system,tgl_trx,deskripsi,id_card,nama_bank,jml_cash_rp,transfer_rp,card_fee_rp) VALUES ('TF-260410-0004','2026-04-10','2026-04-10 19:48:48','PENJUALAN : FJ-260410-0004','.','TBC','6050000','6050000','0');
INSERT INTO tt_bank_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,jenis_trx) VALUES ('KM-260410-0005','D','2026-04-10','19:48:49','TBC','PENJUALAN','FJ-260410-0004','21459637514','6050000','21465687514','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('.','.');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='12750000' WHERE no_faktur_jual='FJ-260410-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260410-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260410-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260410-0002';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260410-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260410-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260410-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260410-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260410-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260410-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('kasirbip','2026-04-10 ','20:52:29');