INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-22 ','08:18:09');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-22 ','08:32:52');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-07-22','131','0','-128750000','131','0','-128750000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-06-21';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-07-21';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-07-21';
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-07-21' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-07-21';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-07-21';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-07-21';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-07-21';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202606 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-06';
UPDATE tt_barang_saldo SET tanggal= '2026-07-22' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-07-21' 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-260722-0001','D','2026-07-22','08:33:14','BCA','SALDO AWAL','SALDO AWAL','0','1902289255','1902289255');
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-260722-0001','D','2026-07-22','08:33:14','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-07-22';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-22 ','08:33:34');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-07-22 ','08:55:49');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-22 ','09:02:30');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-22 ','09:23:41');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-22 ','10:05:44');
INSERT INTO tt_hutang_detail(no_hutang,sales_id,no_urut,deskripsi,berat,qty,jum_berat,kadar,harga) VALUES ('PI26-01819','2402','1','CN PLINTIR SSN ATI2 MT','0','1','0','','')
UPDATE th_saldo_hutang SET qty_tambah=qty_tambah+'1',berat_tambah=berat_tambah+'0',rp_tambah=rp_tambah+'1000000', qty_akhir=qty_akhir+'1',berat_akhir=berat_akhir+'0',rp_akhir=rp_akhir+'1000000'  WHERE tanggal='2026-07-22'
INSERT INTO tt_hutang_head (no_hutang,tgl_system,tgl_hutang,jam_hutang,kode_customer,sales_id,lama_hari,tgl_jth_tmp,input_by,input_date,berat,jml_awal_rp,bunga_persen,bunga_rp,jml_akhir_rp,sld_akhir_rp,status,berat_plus,qty,tgl_lunas,byr_harus_rp,kembali_rp)VALUES('PI26-01819','2026-07-22','2026-07-22','10:46:10','PLG0019207','2402','90','2026-10-20','sales','2026-07-22 10:46:09','1.430','1000000','3.00','90000','1090000','0','OPEN','11.51','1','2026-10-20','0','1090000')
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260722-0002','K','2026-07-22','10:46:10','sales','HUTANG','PI26-01819','406855150','1000000','405855150','OPEN') 
UPDATE tt_hutang_head SET byr_harus_rp='500000',lama_hari ='0', sld_akhir_rp=sld_akhir_rp +'530000',tgl_lunas='2026-07-22',status='CLOS',total_lunas='530000' WHERE no_hutang='PI26-01792';
UPDATE th_saldo_hutang SET qty_keluar=qty_keluar+'1',berat_keluar=berat_keluar+'0',rp_keluar=rp_keluar+'500000',qty_akhir=qty_akhir-'1',berat_akhir=berat_akhir-'0', rp_akhir=rp_akhir-'500000'  WHERE tanggal='2026-07-22';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260722-0003','D','2026-07-22','10:48:20','cashier1','HUTANG LUNAS','PI26-01792','405855150','530000','406385150');
UPDATE tt_hutang_head SET status_valid='DONE',status='OPEN' WHERE no_hutang='PI26-01819' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='PI26-01819';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-07-22 ','10:52:28');
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) VALUES ('FJ-260722-0001','sales','1',' EX ','TOKO','BTCNMT','MTCN-ZFAE-20-0','CN SESER SHB ','','3.060','1','100.00','5600000','0','0','0','5600000','0','0','0','5600000','2501','00030279','MTCN','220000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZFAE-20-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.060',berat_jual_asli=berat_jual_asli+'3.060',stock_jual='1',berat_akhir=berat_akhir-'3.060',berat_akhir_asli=berat_akhir_asli-'3.060',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='MTCN-ZFAE-20-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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) VALUES ('FJ-260722-0001','2026-07-22','3.060','2026-07-22','10:56:03','PLG0019208','5600000','5600000','0','5600000','0','sales','2026-07-22 10:56:02','FJ-260722-0001');
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-07-22','FJ-260722-0001','2026-07-22','10:56:03','2501','5600000','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-260722-0001','2026-07-22','2026-07-22 10:56:02','PENJUALAN : FJ-260722-0001','bca','BCA','5600000','5600000','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-260722-0002','D','2026-07-22','10:56:03','BCA','PENJUALAN','FJ-260722-0001','1902289255','5600000','1907889255','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','H ZAINAB');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='5600000' WHERE no_faktur_jual='FJ-260722-0001' 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) VALUES ('FJ-260722-0002','sales',' 1',' ','TOKO','BTGLMD','MDGL-ZBAH-85-0','GL PIPA LBG LC2 ','','16.370','1','100.00','18089000','0','0','0','18089000','0','0','0','18089000','2501','00028328','MDGL','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZBAH-85-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'16.370',berat_jual_asli=berat_jual_asli+'16.370',stock_jual='1',berat_akhir=berat_akhir-'16.370',berat_akhir_asli=berat_akhir_asli-'16.370',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='MDGL-ZBAH-85-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTGLMD' 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) VALUES ('FJ-260722-0002','2026-07-22','16.370','2026-07-22','10:56:03','PLG0019209','18089000','18089000','0','18089000','0','sales','2026-07-22 10:56:02','FJ-260722-0001');
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-07-22','FJ-260722-0002','2026-07-22','10:56:03','2501','18089000','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-260722-0002','2026-07-22','2026-07-22 10:56:02','PENJUALAN : FJ-260722-0002','bca','BCA','18089000','18089000','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-260722-0003','D','2026-07-22','10:56:03','BCA','PENJUALAN','FJ-260722-0002','1907889255','18089000','1925978255','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('bca','H ZAINAB');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='18089000' WHERE no_faktur_jual='FJ-260722-0002' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260722-0001';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260722-0002';
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','1','MTAT-XEBD-100-0','TOKO','BTATMT','AT JODHA CK SHB ','1','5.420','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='5.410' WHERE kode_barang='MTAT-XEBD-100-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XEBD-100-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XEBD-100-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.420,berat_hancur_asli=berat_hancur_asli+5.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XEBD-100-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','2','MTAT-XKXB-13-0','TOKO','BTATMT','AT KLP KTK BT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.320' WHERE kode_barang='MTAT-XKXB-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXB-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXB-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.330,berat_hancur_asli=berat_hancur_asli+1.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXB-13-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','3','MTAT-XLBG-13-0','TOKO','BTATMT','AT TINDIK POLOS MK ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.510' WHERE kode_barang='MTAT-XLBG-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLBG-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLBG-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLBG-13-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','4','MTAT-YABH-2-0','TOKO','BTATMT','AT TINDIK MN BTR MK ','1','0.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.770' WHERE kode_barang='MTAT-YABH-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.780,berat_hancur_asli=berat_hancur_asli+0.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-2-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','5','MTAT-YABH-3-0','TOKO','BTATMT','AT TINDIK MN BTR MK ','1','0.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.770' WHERE kode_barang='MTAT-YABH-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.780,berat_hancur_asli=berat_hancur_asli+0.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-3-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','6','MTAT-YABH-1-0','TOKO','BTATMT','AT TINDIK MN BTR MK ','1','0.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.770' WHERE kode_barang='MTAT-YABH-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.780,berat_hancur_asli=berat_hancur_asli+0.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-1-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','7','MTAT-XLBG-20-0','TOKO','BTATMT','AT TINDIK POLOS MK ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.510' WHERE kode_barang='MTAT-XLBG-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLBG-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLBG-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLBG-20-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','8','MTAT-XKBH-32-0','TOKO','BTATMT','AT KLP KTK TDK BT SHB ','1','2.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.030' WHERE kode_barang='MTAT-XKBH-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKBH-32-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKBH-32-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.040,berat_hancur_asli=berat_hancur_asli+2.040, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKBH-32-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','9','MTAT-XKBH-19-0','TOKO','BTATMT','AT KLP KTK BT SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.310' WHERE kode_barang='MTAT-XKBH-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKBH-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKBH-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.320,berat_hancur_asli=berat_hancur_asli+1.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKBH-19-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','10','MTAT-YAXD-13-0','TOKO','BTATMT','AT ITALY TDK BT SHB ','1','1.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.940' WHERE kode_barang='MTAT-YAXD-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YAXD-13-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YAXD-13-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.950,berat_hancur_asli=berat_hancur_asli+1.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YAXD-13-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','11','MTAT-YABH-50-0','TOKO','BTATMT','AT JODHA BT SHB ','1','5.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='5.910' WHERE kode_barang='MTAT-YABH-50-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-50-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-50-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.920,berat_hancur_asli=berat_hancur_asli+5.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-50-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','12','MTAT-YCXF-142-0','TOKO','BTATMT','AT TINDIK TOGE CAT SHB ','1','0.710','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.700' WHERE kode_barang='MTAT-YCXF-142-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXF-142-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXF-142-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.710,berat_hancur_asli=berat_hancur_asli+0.710, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXF-142-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','13','MTAT-YBBG-21-0','TOKO','BTATMT','AT TINDIK POLOS MK ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.510' WHERE kode_barang='MTAT-YBBG-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-21-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','14','MTAT-YBBG-25-0','TOKO','BTATMT','AT TINDIK POLOS MK ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.510' WHERE kode_barang='MTAT-YBBG-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-25-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-25-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-25-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','15','MTAT-YBBG-22-0','TOKO','BTATMT','AT TINDIK POLOS MK ','1','0.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.520' WHERE kode_barang='MTAT-YBBG-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-22-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.530,berat_hancur_asli=berat_hancur_asli+0.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','16','MTAT-XLBG-17-0','TOKO','BTATMT','AT TINDIK POLOS MK ','1','0.530','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.520' WHERE kode_barang='MTAT-XLBG-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLBG-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLBG-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.530,berat_hancur_asli=berat_hancur_asli+0.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLBG-17-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','17','MTAT-YBBH-98-0','TOKO','BTATMT','AT TINDIK MN BTR MK ','1','0.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.760' WHERE kode_barang='MTAT-YBBH-98-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBH-98-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBH-98-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.770,berat_hancur_asli=berat_hancur_asli+0.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBH-98-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','18','MTAT-YBBG-23-0','TOKO','BTATMT','AT TINDIK POLOS MK ','1','0.540','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.530' WHERE kode_barang='MTAT-YBBG-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-23-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.540,berat_hancur_asli=berat_hancur_asli+0.540, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-23-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','19','MTAT-YBBG-38-0','TOKO','BTATMT','AT TINDIK MN PLAT MK ','1','0.720','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.710' WHERE kode_barang='MTAT-YBBG-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-38-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-38-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.720,berat_hancur_asli=berat_hancur_asli+0.720, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-38-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','20','MTAT-YBBH-105-0','TOKO','BTATMT','AT COR KLP TETES UBS ','1','1.370','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.360' WHERE kode_barang='MTAT-YBBH-105-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBH-105-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBH-105-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.370,berat_hancur_asli=berat_hancur_asli+1.370, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBH-105-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','21','MTAT-YBBH-119-0','TOKO','BTATMT','AT TUSUK ITALY VC HTM MK ','1','1.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.160' WHERE kode_barang='MTAT-YBBH-119-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBH-119-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBH-119-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.170,berat_hancur_asli=berat_hancur_asli+1.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBH-119-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','22','MTAT-YBAA-22-0','TOKO','BTATMT','AT ITALY BT SHB ','1','1.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.570' WHERE kode_barang='MTAT-YBAA-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBAA-22-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBAA-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.580,berat_hancur_asli=berat_hancur_asli+1.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBAA-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','23','MTAT-YCXE-46-0','TOKO','BTATMT','AT ITALY KUPU BT SHB ','1','2.180','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.170' WHERE kode_barang='MTAT-YCXE-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-46-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-46-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.180,berat_hancur_asli=berat_hancur_asli+2.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-46-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','24','MTAT-YCXE-48-0','TOKO','BTATMT','AT ITALY KUPU BT SHB ','1','2.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.160' WHERE kode_barang='MTAT-YCXE-48-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-48-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-48-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.170,berat_hancur_asli=berat_hancur_asli+2.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-48-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','25','MTAT-YCXE-57-0','TOKO','BTATMT','AT JILBAB SHB ','1','4.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='4.330' WHERE kode_barang='MTAT-YCXE-57-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-57-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-57-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.340,berat_hancur_asli=berat_hancur_asli+4.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-57-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','26','MTAT-YDCX-60-0','TOKO','BTATMT','AT JODHA BT BTR SHB ','1','2.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.000' WHERE kode_barang='MTAT-YDCX-60-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-60-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-60-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.010,berat_hancur_asli=berat_hancur_asli+2.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-60-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','27','MTAT-YEXE-81-0','TOKO','BTATMT','AT UNYIL COBRA SHB ','1','0.520','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.510' WHERE kode_barang='MTAT-YEXE-81-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YEXE-81-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YEXE-81-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YEXE-81-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','28','MTAT-YDCX-55-0','TOKO','BTATMT','AT JODHA BT BTR SHB ','1','2.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.110' WHERE kode_barang='MTAT-YDCX-55-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-55-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-55-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.120,berat_hancur_asli=berat_hancur_asli+2.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-55-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','29','MTAT-YFAH-81-0','TOKO','BTATMT','AT CAP KWT BTR BT SHB ','1','1.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.960' WHERE kode_barang='MTAT-YFAH-81-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YFAH-81-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YFAH-81-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.970,berat_hancur_asli=berat_hancur_asli+1.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YFAH-81-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','30','MTAT-YFAH-87-0','TOKO','BTATMT','AT KAWAT SLP UBS ','1','3.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='3.220' WHERE kode_barang='MTAT-YFAH-87-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YFAH-87-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YFAH-87-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.230,berat_hancur_asli=berat_hancur_asli+3.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YFAH-87-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','31','MTAT-YHBH-115-0','TOKO','BTATMT','AT JODHA BTR BT SHB ','1','1.850','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.840' WHERE kode_barang='MTAT-YHBH-115-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YHBH-115-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YHBH-115-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.850,berat_hancur_asli=berat_hancur_asli+1.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YHBH-115-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','32','MTAT-XKXG-14-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.510','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.500' WHERE kode_barang='MTAT-XKXG-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.510,berat_hancur_asli=berat_hancur_asli+1.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-14-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','33','MTAT-XKXG-1-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.460' WHERE kode_barang='MTAT-XKXG-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.470,berat_hancur_asli=berat_hancur_asli+1.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-1-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','34','MTAT-XKXG-5-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.310' WHERE kode_barang='MTAT-XKXG-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.320,berat_hancur_asli=berat_hancur_asli+1.320, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','35','MTAT-XKXG-17-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.800' WHERE kode_barang='MTAT-XKXG-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKXG-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKXG-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.810,berat_hancur_asli=berat_hancur_asli+1.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKXG-17-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','36','MTAT-YABH-22-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.070' WHERE kode_barang='MTAT-YABH-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-22-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.080,berat_hancur_asli=berat_hancur_asli+2.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','37','MTAT-XLAA-1-0','TOKO','BTATMT','AT COR KLP BT MK ','1','1.590','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.580' WHERE kode_barang='MTAT-XLAA-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLAA-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLAA-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.590,berat_hancur_asli=berat_hancur_asli+1.590, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLAA-1-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','38','MTAT-XLXB-4-0','TOKO','BTATMT','AT COR KLP BT AD MRH SHB ','1','1.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.220' WHERE kode_barang='MTAT-XLXB-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLXB-4-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLXB-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.230,berat_hancur_asli=berat_hancur_asli+1.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLXB-4-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','39','MTAT-XLXB-2-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.470','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.460' WHERE kode_barang='MTAT-XLXB-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XLXB-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XLXB-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.470,berat_hancur_asli=berat_hancur_asli+1.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XLXB-2-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','40','MTAT-YABH-21-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.730' WHERE kode_barang='MTAT-YABH-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.740,berat_hancur_asli=berat_hancur_asli+1.740, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-21-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','41','MTAT-XKBH-17-0','TOKO','BTATMT','AT COR KLP VC HTM MK ','1','2.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.020' WHERE kode_barang='MTAT-XKBH-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKBH-17-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKBH-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.030,berat_hancur_asli=berat_hancur_asli+2.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKBH-17-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','42','MTAT-YABH-23-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.390' WHERE kode_barang='MTAT-YABH-23-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-23-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-23-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.400,berat_hancur_asli=berat_hancur_asli+1.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-23-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','43','MTAT-YABH-11-0','TOKO','BTATMT','AT COR KLP BT MK ','1','1.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.760' WHERE kode_barang='MTAT-YABH-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.770,berat_hancur_asli=berat_hancur_asli+1.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-11-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','44','MTAT-XKBH-2-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.570' WHERE kode_barang='MTAT-XKBH-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKBH-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKBH-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.580,berat_hancur_asli=berat_hancur_asli+0.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKBH-2-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','45','MTAT-XKBH-1-0','TOKO','BTATMT','AT TINDIK BTR SHB ','1','0.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='0.570' WHERE kode_barang='MTAT-XKBH-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-XKBH-1-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-XKBH-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.580,berat_hancur_asli=berat_hancur_asli+0.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-XKBH-1-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','46','MTAT-YAXF-5-0','TOKO','BTATMT','AT KAWAT TDK BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.340' WHERE kode_barang='MTAT-YAXF-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YAXF-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YAXF-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YAXF-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','47','MTAT-YAXF-4-0','TOKO','BTATMT','AT KAWAT TDK BT SHB ','1','1.350','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.340' WHERE kode_barang='MTAT-YAXF-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YAXF-4-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YAXF-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YAXF-4-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','48','MTAT-YAXD-10-0','TOKO','BTATMT','AT CAP KWT BTR BT SHB ','1','2.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.040' WHERE kode_barang='MTAT-YAXD-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YAXD-10-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YAXD-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.050,berat_hancur_asli=berat_hancur_asli+2.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YAXD-10-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','49','MTAT-YABH-27-0','TOKO','BTATMT','AT CAP VAR BT SHB ','1','1.640','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.630' WHERE kode_barang='MTAT-YABH-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.640,berat_hancur_asli=berat_hancur_asli+1.640, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-27-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','50','MTAT-YABH-30-0','TOKO','BTATMT','AT CAP KAWAT BTR BT SHB ','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.990' WHERE kode_barang='MTAT-YABH-30-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YABH-30-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YABH-30-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YABH-30-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','51','MTAT-YCXE-33-0','TOKO','BTATMT','AT COR KLP TDK BT SHB ','1','1.510','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.500' WHERE kode_barang='MTAT-YCXE-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-33-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-33-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.510,berat_hancur_asli=berat_hancur_asli+1.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-33-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','52','MTAT-YCXE-31-0','TOKO','BTATMT','AT COR KLP TDK BT SHB ','1','1.610','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.600' WHERE kode_barang='MTAT-YCXE-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.610,berat_hancur_asli=berat_hancur_asli+1.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-31-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','53','MTAT-YCXE-27-0','TOKO','BTATMT','AT COR KLP VC SLP BT MK ','1','2.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.060' WHERE kode_barang='MTAT-YCXE-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.070,berat_hancur_asli=berat_hancur_asli+2.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-27-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','54','MTAT-YCXE-34-0','TOKO','BTATMT','AT COR KLP TDK BT SHB ','1','1.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.970' WHERE kode_barang='MTAT-YCXE-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.980,berat_hancur_asli=berat_hancur_asli+1.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-34-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','55','MTAT-YCXE-28-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','1.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.130' WHERE kode_barang='MTAT-YCXE-28-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-28-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-28-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.140,berat_hancur_asli=berat_hancur_asli+1.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-28-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','56','MTAT-YCXE-26-0','TOKO','BTATMT','AT COR KLP VC HTM MK ','1','2.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.990' WHERE kode_barang='MTAT-YCXE-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCXE-26-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCXE-26-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.000,berat_hancur_asli=berat_hancur_asli+2.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCXE-26-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','57','MTAT-YBBH-114-0','TOKO','BTATMT','AT CAP KWT BT SHB ','1','2.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.400' WHERE kode_barang='MTAT-YBBH-114-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBH-114-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBH-114-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.410,berat_hancur_asli=berat_hancur_asli+2.410, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBH-114-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','58','MTAT-YBBH-113-0','TOKO','BTATMT','AT CAP KWT BTR BLB BT SHB ','1','2.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.250' WHERE kode_barang='MTAT-YBBH-113-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBH-113-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBH-113-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.260,berat_hancur_asli=berat_hancur_asli+2.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBH-113-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','59','MTAT-YBBG-52-0','TOKO','BTATMT','AT ANAK COR CAT BT SHB ','1','1.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.160' WHERE kode_barang='MTAT-YBBG-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-52-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-52-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.170,berat_hancur_asli=berat_hancur_asli+1.170, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-52-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','60','MTAT-YBBG-49-0','TOKO','BTATMT','AT ANAK COR CAT BT SHB ','1','1.080','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.070' WHERE kode_barang='MTAT-YBBG-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBBG-49-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBBG-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.080,berat_hancur_asli=berat_hancur_asli+1.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBBG-49-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','61','MTAT-YBXC-5-0','TOKO','BTATMT','AT CAP PLAT CAT BT SHB ','1','1.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.140' WHERE kode_barang='MTAT-YBXC-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YBXC-5-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YBXC-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.150,berat_hancur_asli=berat_hancur_asli+1.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YBXC-5-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','62','MTAT-YCAD-16-0','TOKO','BTATMT','AT COR KLP TDK BT MN HT UBS ','1','1.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.930' WHERE kode_barang='MTAT-YCAD-16-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YCAD-16-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YCAD-16-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.940,berat_hancur_asli=berat_hancur_asli+1.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YCAD-16-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','63','MTAT-YDCX-24-0','TOKO','BTATMT','AT COR KLP BT SHB ','1','2.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.110' WHERE kode_barang='MTAT-YDCX-24-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-24-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-24-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.120,berat_hancur_asli=berat_hancur_asli+2.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-24-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','64','MTAT-YDCX-39-0','TOKO','BTATMT','AT CAP KAWAT BT SHB ','1','2.450','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.440' WHERE kode_barang='MTAT-YDCX-39-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-39-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-39-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.450,berat_hancur_asli=berat_hancur_asli+2.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-39-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','65','MTAT-YDCX-49-0','TOKO','BTATMT','AT KAWAT SPIRAL BT SHB ','1','1.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.910' WHERE kode_barang='MTAT-YDCX-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-49-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.920,berat_hancur_asli=berat_hancur_asli+1.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-49-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','66','MTAT-YDCX-44-0','TOKO','BTATMT','AT ITALY DOLLAR TDK BT SHB ','1','2.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='2.010' WHERE kode_barang='MTAT-YDCX-44-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-44-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-44-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.020,berat_hancur_asli=berat_hancur_asli+2.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-44-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0001','67','MTAT-YDCX-42-0','TOKO','BTATMT','AT ITALY BT SHB ','1','1.670','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:16:07',status_delete='1.660' WHERE kode_barang='MTAT-YDCX-42-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTAT-YDCX-42-0';
DELETE FROM tm_barang WHERE kode_barang='MTAT-YDCX-42-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.670,berat_hancur_asli=berat_hancur_asli+1.670, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMT' AND kode_barang='MTAT-YDCX-42-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260722-0001','2026-07-22','admin','2026-07-22','11:16:07','admin','2026-07-22 11:16:07');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009663','X-00009663','LT COR BT SHB','GR','---','MDLT','BELI','BELI001','1026000','2026-07-22','1.080','1','sales','2026-07-22 11:20:20');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDLT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDLT','X-00009663','X-00009663');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260722-0001','FJ-260523-0009','2402','1','BELI','BELI001','MDLT', 'X-00009663', 'LT COR BT SHB','1.080','1.080','100.00','1226000','1026000','950000','1','1026000','1026000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-07-22','BELI','BELI001','MDLT','MDLT','100.00','1.080','1.080','1','1.080','1.080','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260722-0001','2026-07-22','2026-07-22','11:20:19','2402','---','1.080','1026000','1026000','1026000','1026000','1026000','sales','2026-07-22 11:20:20','FB-260722-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260722-0001','TIRASMA','GEMBONG','','','087850008422','sales','2026-07-22 11:20:20');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260722-0004','K','2026-07-22','11:20:19','sales','PEMBELIAN UMUM','FB-260722-0001','406385150','1026000','405359150','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260722-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260722-0001';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-07-22 ','11:29:03');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260722-0005','K','2026-07-22','11:39:04','cashier1','PENGELUARAN','SETOR PUSAT PAK BUDI','405359150','200000000','205359150');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260722-0006','D','2026-07-22','11:39:31','cashier1','PEMASUKAN','POS MOKA','205359150','8000','205367150');
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','1','MTGL-UHAF-34-0','TOKO','BTGLMT','GL PLTR SHB','1','20.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='20.330' WHERE kode_barang='MTGL-UHAF-34-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-UHAF-34-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-UHAF-34-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+20.340,berat_hancur_asli=berat_hancur_asli+20.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-UHAF-34-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','2','MTGL-YCAX-27-0','TOKO','BTGLMT','GL PLINTIR SHB ','1','14.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='14.920' WHERE kode_barang='MTGL-YCAX-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAX-27-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAX-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+14.930,berat_hancur_asli=berat_hancur_asli+14.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCAX-27-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','3','MTGL-YCXF-141-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SHB ','1','11.640','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='11.630' WHERE kode_barang='MTGL-YCXF-141-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-141-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-141-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+11.640,berat_hancur_asli=berat_hancur_asli+11.640, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-141-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','4','MTGL-YCXF-137-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SHB ','1','4.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.870' WHERE kode_barang='MTGL-YCXF-137-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-137-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-137-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.880,berat_hancur_asli=berat_hancur_asli+4.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-137-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','5','MTGL-XDBD-11-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SHB ','1','5.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='5.020' WHERE kode_barang='MTGL-XDBD-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XDBD-11-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XDBD-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.030,berat_hancur_asli=berat_hancur_asli+5.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XDBD-11-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','6','MTGL-YCXF-160-0','TOKO','BTGLMT','GL BANGKOK TMBL SHB ','1','5.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='5.210' WHERE kode_barang='MTGL-YCXF-160-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-160-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-160-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.220,berat_hancur_asli=berat_hancur_asli+5.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-160-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','7','MTGL-YBBH-211-0','TOKO','BTGLMT','GL BANGKOK TALI AIR SMBR PTH TL ','1','4.560','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.550' WHERE kode_barang='MTGL-YBBH-211-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBBH-211-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBBH-211-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.560,berat_hancur_asli=berat_hancur_asli+4.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBBH-211-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','8','MTGL-XEAX-3-0','TOKO','BTGLMT','GL CARA BTG ','1','8.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='8.220' WHERE kode_barang='MTGL-XEAX-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XEAX-3-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XEAX-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.230,berat_hancur_asli=berat_hancur_asli+8.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XEAX-3-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','9','MTGL-YABH-80-0','TOKO','BTGLMT','GL CAP HOLO 18CM KKT PER SHB ','1','8.280','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='8.270' WHERE kode_barang='MTGL-YABH-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YABH-80-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YABH-80-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+8.280,berat_hancur_asli=berat_hancur_asli+8.280, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YABH-80-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','10','MTGL-YCXF-116-0','TOKO','BTGLMT','GL ITALY ST SRT TDK BT 19CM KKT PER MK','1','3.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.240' WHERE kode_barang='MTGL-YCXF-116-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-116-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-116-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.250,berat_hancur_asli=berat_hancur_asli+3.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-116-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','11','MTGL-YCXF-90-0','TOKO','BTGLMT','GL CATENA VAR 17CM KKT PER MK ','1','2.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.890' WHERE kode_barang='MTGL-YCXF-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-90-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.900,berat_hancur_asli=berat_hancur_asli+2.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-90-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','12','MTGL-YCXF-97-0','TOKO','BTGLMT','GL CASTELI VIGARU 16CM KKT PER SHB ','1','1.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.910' WHERE kode_barang='MTGL-YCXF-97-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-97-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-97-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.920,berat_hancur_asli=berat_hancur_asli+1.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-97-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','13','MTGL-YCXF-102-0','TOKO','BTGLMT','GL ENGKEL VAR 16CM KKT PER SHB ','1','3.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.200' WHERE kode_barang='MTGL-YCXF-102-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-102-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-102-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.210,berat_hancur_asli=berat_hancur_asli+3.210, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-102-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','14','MTGL-YCXF-89-0','TOKO','BTGLMT','GL CATENA VAR 17CM KKT PER MK ','1','2.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.820' WHERE kode_barang='MTGL-YCXF-89-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-89-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-89-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.830,berat_hancur_asli=berat_hancur_asli+2.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-89-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','15','MTGL-YCXF-84-0','TOKO','BTGLMT','GL VIGARU FANCY 17CM KKT PER SHB','1','2.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.570' WHERE kode_barang='MTGL-YCXF-84-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-84-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-84-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.580,berat_hancur_asli=berat_hancur_asli+2.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-84-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','16','MTGL-YCXF-100-0','TOKO','BTGLMT','GL CASTELI VAR 16CM KKT PER SHB ','1','2.700','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.690' WHERE kode_barang='MTGL-YCXF-100-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-100-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-100-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.700,berat_hancur_asli=berat_hancur_asli+2.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-100-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','17','MTGL-XKXD-14-0','TOKO','BTGLMT','GL CASTELI VC VAR 17CM KKT PER MK ','1','2.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.150' WHERE kode_barang='MTGL-XKXD-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXD-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXD-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.160,berat_hancur_asli=berat_hancur_asli+2.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXD-14-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','18','MTGL-YCXF-94-0','TOKO','BTGLMT','GL CATENA FANCY KBS 17CM KKT PER SHB ','1','2.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.210' WHERE kode_barang='MTGL-YCXF-94-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-94-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-94-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.220,berat_hancur_asli=berat_hancur_asli+2.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-94-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','19','MTGL-YCXF-91-0','TOKO','BTGLMT','GL CATENA FANCY VAR 17CM KKT PER MK ','1','1.910','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.900' WHERE kode_barang='MTGL-YCXF-91-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-91-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-91-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.910,berat_hancur_asli=berat_hancur_asli+1.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-91-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','20','MTGL-XJAE-116-0','TOKO','BTGLMT','GL PIPA BT MK ','1','3.890','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.880' WHERE kode_barang='MTGL-XJAE-116-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XJAE-116-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XJAE-116-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.890,berat_hancur_asli=berat_hancur_asli+3.890, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XJAE-116-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','21','MTGL-XLXB-53-0','TOKO','BTGLMT','GL PIPA BT SHB ','1','10.290','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='10.280' WHERE kode_barang='MTGL-XLXB-53-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XLXB-53-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XLXB-53-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+10.290,berat_hancur_asli=berat_hancur_asli+10.290, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XLXB-53-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','22','MTGL-YCAD-35-0','TOKO','BTGLMT','GL PIPA TDK BT BTG ','1','7.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='7.800' WHERE kode_barang='MTGL-YCAD-35-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAD-35-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAD-35-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.810,berat_hancur_asli=berat_hancur_asli+7.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCAD-35-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','23','MTGL-YCAD-32-0','TOKO','BTGLMT','GL PIPA BT UBS ','1','9.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='9.110' WHERE kode_barang='MTGL-YCAD-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAD-32-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAD-32-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+9.120,berat_hancur_asli=berat_hancur_asli+9.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCAD-32-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','24','MTGL-YBBH-208-0','TOKO','BTGLMT','GL BANGKOK TMBL ANAK MK ','1','3.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.060' WHERE kode_barang='MTGL-YBBH-208-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YBBH-208-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YBBH-208-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.070,berat_hancur_asli=berat_hancur_asli+3.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YBBH-208-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','25','MTGL-XEBE-57-0','TOKO','BTGLMT','GL PIPA TDK BT LL ','1','4.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.220' WHERE kode_barang='MTGL-XEBE-57-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XEBE-57-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XEBE-57-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.230,berat_hancur_asli=berat_hancur_asli+4.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XEBE-57-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','26','MTGL-YEXB-76-0','TOKO','BTGLMT','GL KK TALIA VAR MN8 1BEL 26CM KKT S SHB ','1','4.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.480' WHERE kode_barang='MTGL-YEXB-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-76-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.490,berat_hancur_asli=berat_hancur_asli+4.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-76-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','27','MTGL-YCBE-63-0','TOKO','BTGLMT','GL RANGKAIAN BTR BL PSR 17CM KKT PER MK ','1','7.360','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='7.350' WHERE kode_barang='MTGL-YCBE-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-63-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+7.360,berat_hancur_asli=berat_hancur_asli+7.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-63-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','28','MTGL-YCBE-62-0','TOKO','BTGLMT','GL RANGKAIAN 16CM KKT PER MK ','1','5.540','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='5.530' WHERE kode_barang='MTGL-YCBE-62-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-62-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-62-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.540,berat_hancur_asli=berat_hancur_asli+5.540, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-62-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','29','MTGL-XKXH-19-0','TOKO','BTGLMT','GL RANGKAIAN BTR VAR 17CM KKT PER SHB ','1','4.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.090' WHERE kode_barang='MTGL-XKXH-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-19-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.100,berat_hancur_asli=berat_hancur_asli+4.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXH-19-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','30','MTGL-XKXH-21-0','TOKO','BTGLMT','GL RANGKAIAN BTR GLR 17CM KKT PER SHB ','1','4.250','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.240' WHERE kode_barang='MTGL-XKXH-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKXH-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKXH-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.250,berat_hancur_asli=berat_hancur_asli+4.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKXH-21-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','31','MTGL-YCBE-57-0','TOKO','BTGLMT','GL KERUCUT BTR 17CM KKT PER SHB ','1','4.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.930' WHERE kode_barang='MTGL-YCBE-57-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-57-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-57-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.940,berat_hancur_asli=berat_hancur_asli+4.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-57-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','32','MTGL-YABH-65-0','TOKO','BTGLMT','GL KERUCUT BTR 16CM KKT PER SHB ','1','4.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.620' WHERE kode_barang='MTGL-YABH-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YABH-65-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YABH-65-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.630,berat_hancur_asli=berat_hancur_asli+4.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YABH-65-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','33','MTGL-YABH-64-0','TOKO','BTGLMT','GL KERUCUT BTR 16CM KKT PER SHB ','1','4.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.870' WHERE kode_barang='MTGL-YABH-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YABH-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YABH-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.880,berat_hancur_asli=berat_hancur_asli+4.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YABH-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','34','MTGL-YEXB-21-0','TOKO','BTGLMT','GL RANGKAIAN GLR BTR 17CM KKT PER SHB ','1','5.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='5.090' WHERE kode_barang='MTGL-YEXB-21-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-21-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-21-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.100,berat_hancur_asli=berat_hancur_asli+5.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-21-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','35','MTGL-YCBE-58-0','TOKO','BTGLMT','GL RANGKAIAN 16CM KKT PER SHB ','1','4.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.100' WHERE kode_barang='MTGL-YCBE-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-58-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-58-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.110,berat_hancur_asli=berat_hancur_asli+4.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-58-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','36','MTGL-YEXB-22-0','TOKO','BTGLMT','GL RANGKAIAN 17CM KKT PER SHB ','1','3.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.450' WHERE kode_barang='MTGL-YEXB-22-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-22-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-22-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.460,berat_hancur_asli=berat_hancur_asli+3.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-22-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','37','MTGL-YEXB-41-0','TOKO','BTGLMT','GL ARIZO 16CM KKT S SHB ','1','5.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='5.390' WHERE kode_barang='MTGL-YEXB-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-41-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.400,berat_hancur_asli=berat_hancur_asli+5.400, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-41-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','38','MTGL-YCBE-55-0','TOKO','BTGLMT','GL CAP HOLO 17CM KKT PER SHB ','1','4.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.650' WHERE kode_barang='MTGL-YCBE-55-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-55-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-55-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.660,berat_hancur_asli=berat_hancur_asli+4.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-55-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','39','MTGL-YDCX-140-0','TOKO','BTGLMT','GL VANESSA VAR 17CM KKT PER SHB ','1','3.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.850' WHERE kode_barang='MTGL-YDCX-140-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-140-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-140-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.860,berat_hancur_asli=berat_hancur_asli+3.860, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-140-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','40','MTGL-YCBE-41-0','TOKO','BTGLMT','GL VANESSA PLAT BT 17CM KKT PER MK ','1','4.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.010' WHERE kode_barang='MTGL-YCBE-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-41-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-41-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.020,berat_hancur_asli=berat_hancur_asli+4.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-41-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','41','MTGL-YDCX-149-0','TOKO','BTGLMT','GL VANESSA VAR 17CM KKT PER SHB ','1','4.610','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.600' WHERE kode_barang='MTGL-YDCX-149-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-149-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-149-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.610,berat_hancur_asli=berat_hancur_asli+4.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-149-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','42','MTGL-YDCX-160-0','TOKO','BTGLMT','GL VANESSA VAR BT 16CM KKT PER SHB ','1','4.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.090' WHERE kode_barang='MTGL-YDCX-160-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-160-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-160-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.100,berat_hancur_asli=berat_hancur_asli+4.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-160-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','43','MTGL-YDCX-148-0','TOKO','BTGLMT','GL VANESSA VAR 16CM KKT PER SHB ','1','4.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.640' WHERE kode_barang='MTGL-YDCX-148-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-148-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-148-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.650,berat_hancur_asli=berat_hancur_asli+4.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-148-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','44','MTGL-YGAD-63-0','TOKO','BTGLMT','GL VANESSA GLR VAR 16CM KKT PER SHB ','1','4.580','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='4.570' WHERE kode_barang='MTGL-YGAD-63-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YGAD-63-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YGAD-63-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.580,berat_hancur_asli=berat_hancur_asli+4.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YGAD-63-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','45','MTGL-YCBE-77-0','TOKO','BTGLMT','GL HL SUPER BTR 16CM KKT PER SHB ','1','3.460','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.450' WHERE kode_barang='MTGL-YCBE-77-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-77-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-77-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.460,berat_hancur_asli=berat_hancur_asli+3.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-77-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','46','MTGL-YCBE-78-0','TOKO','BTGLMT','GL HL SUPER BTR 17CM KKT PER SHB ','1','3.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.640' WHERE kode_barang='MTGL-YCBE-78-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-78-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-78-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.650,berat_hancur_asli=berat_hancur_asli+3.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-78-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','47','MTGL-YEXB-45-0','TOKO','BTGLMT','GL VIGARU 16CM KKT PER SHB ','1','3.660','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.650' WHERE kode_barang='MTGL-YEXB-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-45-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.660,berat_hancur_asli=berat_hancur_asli+3.660, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-45-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','48','MTGL-YDCX-83-0','TOKO','BTGLMT','GL MOCCA VIGARU 16CM KKT PER SHB ','1','1.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.810' WHERE kode_barang='MTGL-YDCX-83-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-83-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-83-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.820,berat_hancur_asli=berat_hancur_asli+1.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-83-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','49','MTGL-YEXB-32-0','TOKO','BTGLMT','GL VIGARU 16CM KKT PER SHB ','1','3.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.970' WHERE kode_barang='MTGL-YEXB-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-32-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-32-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.980,berat_hancur_asli=berat_hancur_asli+3.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-32-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','50','MTGL-YDCX-116-0','TOKO','BTGLMT','GL FANCY VIGARU 17CM KKT PER BLT SHB ','1','1.810','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.800' WHERE kode_barang='MTGL-YDCX-116-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-116-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-116-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.810,berat_hancur_asli=berat_hancur_asli+1.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-116-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','51','MTGL-YDCX-115-0','TOKO','BTGLMT','GL FANCY VIGARU 17CM KKT PER BLT SHB ','1','1.690','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.680' WHERE kode_barang='MTGL-YDCX-115-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-115-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-115-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.690,berat_hancur_asli=berat_hancur_asli+1.690, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-115-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','52','MTGL-YCBG-2-0','TOKO','BTGLMT','GL CATENA VIGARU 16CM KKT PER SHB ','1','1.600','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.590' WHERE kode_barang='MTGL-YCBG-2-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBG-2-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBG-2-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.600,berat_hancur_asli=berat_hancur_asli+1.600, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBG-2-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','53','MTGL-XKAH-37-0','TOKO','BTGLMT','GL MOCCA VIGARU 16CM KKT PER SHB','1','2.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.090' WHERE kode_barang='MTGL-XKAH-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XKAH-37-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XKAH-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.100,berat_hancur_asli=berat_hancur_asli+2.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XKAH-37-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','54','MTGL-YDCX-107-0','TOKO','BTGLMT','GL RANGKAIAN 16CM KKT PER BLT SHB ','1','2.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.100' WHERE kode_barang='MTGL-YDCX-107-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-107-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-107-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.110,berat_hancur_asli=berat_hancur_asli+2.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-107-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','55','MTGL-YDCX-111-0','TOKO','BTGLMT','GL FANCY VIGARU 16CM KKT PER BLT SHB ','1','1.550','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.540' WHERE kode_barang='MTGL-YDCX-111-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-111-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-111-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.550,berat_hancur_asli=berat_hancur_asli+1.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-111-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','56','MTGL-YDCX-84-0','TOKO','BTGLMT','GL FANCY VIGARU 16CM KKT PER BLT SHB','1','1.710','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.700' WHERE kode_barang='MTGL-YDCX-84-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-84-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-84-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.710,berat_hancur_asli=berat_hancur_asli+1.710, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-84-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','57','MTGL-YEXB-14-0','TOKO','BTGLMT','GL FANCY VIGARU 16CM KKT PER BLT SHB ','1','1.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.610' WHERE kode_barang='MTGL-YEXB-14-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-14-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-14-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.620,berat_hancur_asli=berat_hancur_asli+1.620, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-14-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','58','MTGL-YDCX-113-0','TOKO','BTGLMT','GL FANCY VIGARU 17CM KKT PER BLT SHB ','1','1.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.640' WHERE kode_barang='MTGL-YDCX-113-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-113-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-113-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.650,berat_hancur_asli=berat_hancur_asli+1.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-113-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','59','MTGL-YEXB-31-0','TOKO','BTGLMT','GL VIGARU 16CM KKT PER SHB ','1','3.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.960' WHERE kode_barang='MTGL-YEXB-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YEXB-31-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YEXB-31-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.970,berat_hancur_asli=berat_hancur_asli+3.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YEXB-31-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','60','MTGL-YCAX-18-0','TOKO','BTGLMT','GL LAYER CATENA ITALY ST JEDAR 16CM KKT PER SHB ','1','2.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.220' WHERE kode_barang='MTGL-YCAX-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCAX-18-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCAX-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.230,berat_hancur_asli=berat_hancur_asli+2.230, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCAX-18-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','61','MTGL-YCBE-80-0','TOKO','BTGLMT','GL CABLE STRIP MN HT 16CM KKT PER BLT UBS ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='1.490' WHERE kode_barang='MTGL-YCBE-80-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-80-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-80-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.500,berat_hancur_asli=berat_hancur_asli+1.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-80-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','62','MTGL-XBAE-20-0','TOKO','BTGLMT','GL VIGARU KOMB ENGKEL 5BEL 17CM KKT PER SHB ','1','2.890','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.880' WHERE kode_barang='MTGL-XBAE-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XBAE-20-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XBAE-20-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.890,berat_hancur_asli=berat_hancur_asli+2.890, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XBAE-20-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','63','MTGL-YCBE-74-0','TOKO','BTGLMT','GL ATHENS MN DOLLAR 18CM KKT PER HWT ','1','2.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.060' WHERE kode_barang='MTGL-YCBE-74-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-74-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-74-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.070,berat_hancur_asli=berat_hancur_asli+2.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-74-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','64','MTGL-YCBE-65-0','TOKO','BTGLMT','GL FANCY MN 1 17CM KKT S SHB ','1','2.210','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.200' WHERE kode_barang='MTGL-YCBE-65-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-65-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-65-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.210,berat_hancur_asli=berat_hancur_asli+2.210, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-65-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','65','MTGL-YDCX-108-0','TOKO','BTGLMT','GL CATENA VAR 16CM KKT PER BLT SHB ','1','2.100','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.090' WHERE kode_barang='MTGL-YDCX-108-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-108-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-108-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.100,berat_hancur_asli=berat_hancur_asli+2.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-108-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','66','MTGL-YDCX-129-0','TOKO','BTGLMT','GL RANGKAIAN MN HT 16CM KKT PER MK ','1','2.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.870' WHERE kode_barang='MTGL-YDCX-129-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YDCX-129-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YDCX-129-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.880,berat_hancur_asli=berat_hancur_asli+2.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YDCX-129-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','67','MTGL-YCBE-76-0','TOKO','BTGLMT','GL CATENA MN HT 17CM KKT PER UBS ','1','2.790','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='2.780' WHERE kode_barang='MTGL-YCBE-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCBE-76-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCBE-76-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.790,berat_hancur_asli=berat_hancur_asli+2.790, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCBE-76-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','68','MTGL-XEBE-64-0','TOKO','BTGLMT','GL ITALY ST SRT VAR BT 18CM KKT PER SHB ','1','3.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.110' WHERE kode_barang='MTGL-XEBE-64-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-XEBE-64-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-XEBE-64-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.120,berat_hancur_asli=berat_hancur_asli+3.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-XEBE-64-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','69','MTGL-YCXF-112-0','TOKO','BTGLMT','GL ITALY ST SRT VAR BT 19CM KKT PER SHB ','1','3.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.060' WHERE kode_barang='MTGL-YCXF-112-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-112-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-112-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.070,berat_hancur_asli=berat_hancur_asli+3.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-112-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-260722-0002','70','MTGL-YCXF-111-0','TOKO','BTGLMT','GL ITALY ST SRT VAR BT 19CM KKT PER SHB ','1','3.140','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-07-22 11:52:05',status_delete='3.130' WHERE kode_barang='MTGL-YCXF-111-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MTGL-YCXF-111-0';
DELETE FROM tm_barang WHERE kode_barang='MTGL-YCXF-111-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.140,berat_hancur_asli=berat_hancur_asli+3.140, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGLMT' AND kode_barang='MTGL-YCXF-111-0' AND stock_akhir > 0;
INSERT INTO tt_waste_head (no_waste,tgl_system,sales_id,tgl_waste,jam_Waste,input_by,input_date) VALUES ('BS-260722-0002','2026-07-22','admin','2026-07-22','11:52:05','admin','2026-07-22 11:52:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-22 ','13:24:41');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009664','X-00009664','CN FORTUNE LC2','GR','---','MDCN','BELI','BELI001','1254000','2026-07-22','1.320','1','sales','2026-07-22 13:25:08');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDCN','X-00009664','X-00009664');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260722-0002','FJ-260126-0005','2106','1','BELI','BELI001','MDCN', 'X-00009664', 'CN FORTUNE LC2','1.320','1.320','100.00','1584000','1254000','950000','1','1254000','1254000','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-07-22','BELI','BELI001','MDCN','MDCN','100.00','1.320','1.320','1','1.320','1.320','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260722-0002','2026-07-22','2026-07-22','13:25:07','2106','---','1.320','1254000','1254000','1254000','1254000','1254000','sales','2026-07-22 13:25:08','FB-260722-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260722-0002','BY','KEDUNG MANGU 8/7-A','','SBY','085933540850','sales','2026-07-22 13:25:08');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260722-0007','K','2026-07-22','13:25:07','sales','PEMBELIAN UMUM','FB-260722-0002','205367150','1254000','204113150','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260722-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260722-0002';
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260722-0008','K','2026-07-22','13:27:04','cashier1','PENGELUARAN','IURAN APEPI BULAN JUNI 2026','204113150','250000','203863150');
INSERT INTO tm_barang_beli(kode_barang,kode_barcode,nama_barang,kode_satuan,kode_supplier,kode_dept,kode_lokasi_gudang,kode_lokasi_toko,harga_beli,tgl_last_beli,berat,stock_on_hand,input_by,input_date) VALUES ('X-00009665','X-00009665','CN CAP PLT ANAK TDK BT SHB','GR','---','MTCN','BELI','BELI001','724500','2026-07-22','0.450','1','sales','2026-07-22 13:57:28');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTCN';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTCN','X-00009665','X-00009665');
INSERT INTO tt_beli_detail(no_faktur_beli,no_faktur_ext,sales_id,no_urut,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,nama_barang,berat_nota,berat,kadar,harga_nota,harga_beli,harga_rata,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-260722-0003','FJ-220705-0002','2106','1','BELI','BELI001','MTCN', 'X-00009665', 'CN CAP PLT ANAK TDK BT SHB','0.500','0.450','100.00','352000','724500','1610000','1','724500','724500','MULUS');
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,berat_beli,berat_beli_asli,stock_beli,berat_akhir,berat_akhir_asli,stock_akhir) VALUES ('2026-07-22','BELI','BELI001','MTCN','MTCN','100.00','0.450','0.450','1','0.450','0.450','1');
INSERT INTO tt_beli_head(no_faktur_beli,tgl_system,tgl_faktur_beli,jam_faktur_beli,sales_id,kode_supplier,tot_berat,dpp_bruto_rp,dpp_netto_rp,dpp_intern_rp,jml_beli_rp,jml_beli_intern,input_by,input_date,no_faktur_group,status_valid) VALUES ('FB-260722-0003','2026-07-22','2026-07-22','13:57:28','2106','---','0.450','724500','724500','724500','724500','724500','sales','2026-07-22 13:57:28','FB-260722-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260722-0003','AINUN','KAMPUNG SENG 53A','','SBY','','sales','2026-07-22 13:57:28');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-07-22' ORDER BY right(no_ref,4) DESC LIMIT 1;
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp,status_valid) VALUES ('KK-260722-0009','K','2026-07-22','13:57:28','sales','PEMBELIAN UMUM','FB-260722-0003','203863150','724500','203138650','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260722-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260722-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-22 ','14:35:29');
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) VALUES ('FJ-260722-0003','sales','1',' ','TOKO','BTCNMT','MTCN-ZGAD-16-0','CN COR BT 3WRN PNT SHB','','2.540','1','100.00','4648500','0','0','0','4648500','0','0','0','4648500','2602','00030734','MTCN','220000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZGAD-16-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'2.540',berat_jual_asli=berat_jual_asli+'2.540',stock_jual='1',berat_akhir=berat_akhir-'2.540',berat_akhir_asli=berat_akhir_asli-'2.540',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='MTCN-ZGAD-16-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMT' 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) VALUES ('FJ-260722-0003','2026-07-22','2.540','2026-07-22','15:00:48','PLG0019210','4648500','4648500','0','4648500','4648500','sales','2026-07-22 15:00:47','FJ-260722-0003');
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-07-22','FJ-260722-0003','2026-07-22','15:00:48','2602','4648500','0');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KM-260722-0010','D','2026-07-22','15:00:48','sales','PENJUALAN','FJ-260722-0003','203138650','4648500','207787150');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260722-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-22 ','15:24:08');
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) VALUES ('FJ-260722-0004','sales','1',' EX ','TOKO','BTCNMD','MDCN-ZDAX-30-0','CN COR TDK BT SHB ','','0.770','1','100.00','851000','0','0','0','851000','0','0','0','851000','2402','00029060','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZDAX-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.770',berat_jual_asli=berat_jual_asli+'0.770',stock_jual='1',berat_akhir=berat_akhir-'0.770',berat_akhir_asli=berat_akhir_asli-'0.770',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='MDCN-ZDAX-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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) VALUES ('FJ-260722-0004','2026-07-22','0.770','2026-07-22','15:42:08','PLG0019211','851000','851000','0','851000','0','sales','2026-07-22 15:42:07','FJ-260722-0004');
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-07-22','FJ-260722-0004','2026-07-22','15:42:08','2402','851000','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-260722-0003','2026-07-22','2026-07-22 15:42:07','PENJUALAN : FJ-260722-0004','mandiri','BCA','851000','851000','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-260722-0004','D','2026-07-22','15:42:08','BCA','PENJUALAN','FJ-260722-0004','1925978255','851000','1926829255','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('mandiri','MASNUR FARISZAH AMAL');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='851000' WHERE no_faktur_jual='FJ-260722-0004' 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) VALUES ('FJ-260722-0005','sales',' 1',' EX ','TOKO','BTCNMD','MDCN-ZFAC-21-0','CN COR TDK BT SHB ','','0.750','1','100.00','829000','0','0','0','829000','0','0','0','829000','2402','00030213','MDCN','155000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-07-22', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDCN-ZFAC-21-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.750',berat_jual_asli=berat_jual_asli+'0.750',stock_jual='1',berat_akhir=berat_akhir-'0.750',berat_akhir_asli=berat_akhir_asli-'0.750',stock_akhir='0' WHERE tanggal='2026-07-22' AND kode_barang='MDCN-ZFAC-21-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTCNMD' 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) VALUES ('FJ-260722-0005','2026-07-22','0.750','2026-07-22','15:42:08','PLG0019212','829000','829000','0','829000','0','sales','2026-07-22 15:42:07','FJ-260722-0004');
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-07-22','FJ-260722-0005','2026-07-22','15:42:08','2402','829000','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-260722-0004','2026-07-22','2026-07-22 15:42:07','PENJUALAN : FJ-260722-0005','mandiri','BCA','829000','829000','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-260722-0005','D','2026-07-22','15:42:08','BCA','PENJUALAN','FJ-260722-0005','1926829255','829000','1927658255','TRANSFER');
INSERT IGNORE INTO tm_rek (no_rek,nama_rek) VALUES ('mandiri','MASNUR FARISZAH AMAL');
UPDATE tt_jual_head SET dibayar_rp='0',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='829000' WHERE no_faktur_jual='FJ-260722-0005' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260722-0004';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0005' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260722-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260722-0005';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-07-22 ','16:15:04');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-07-22 ','16:15:17');
INSERT INTO tt_cash_daily (no_ref,type_trx,tanggal,jam,input_by,kategori,deskripsi,sld_awal_rp,jumlah_rp,sld_akhir_rp) VALUES ('KK-260722-0011','K','2026-07-22','16:18:14','cashier1','PENGELUARAN','SETOR PUSAT PAK BUDI','207787150','100000000','107787150');