INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-16 ','08:35:05');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-16 ','08:40:19');
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2026-09-16','120','0','-172100000','120','0','-172100000');
DELETE FROM th_barang_saldo WHERE tanggal <= '2026-08-16';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2026-09-15';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2026-09-15';
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-09-15' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2026-09-15';
DELETE FROM tt_cash_daily WHERE tanggal <= '2026-09-15';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2026-09-15';
DELETE FROM tt_bank_daily WHERE tanggal <= '2026-09-15';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202608 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2026-08';
UPDATE tt_barang_saldo SET tanggal= '2026-09-16' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2026-09-15' 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-260916-0001','D','2026-09-16','08:40:31','BCA','SALDO AWAL','SALDO AWAL','0','2151209713','2151209713');
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-260916-0001','D','2026-09-16','08:40:31','','SALDO AWAL','SALDO AWAL','0','0','0');
UPDATE tp_system SET tgl_system='2026-09-16';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-16 ','08:43:23');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-16 ','08:52:36');
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260916-0001','1','X-00009812','BELI','BELI001','AT COR KLP TDK BT SMBR PTH LC2','1','1.180','1126000.00' ,'0.00','1126000','','1126000','1126000','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-16 08:52:59' WHERE kode_barang='X-00009812' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009812' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009812' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'1.180',berat_hancur_asli=berat_hancur_asli+'1.180', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'1.180',berat_akhir_asli=berat_akhir_asli-'1.180' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDAT' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260916-0001','2','X-00009813','BELI','BELI001','KL FANCY 42CM KKT PER SHB','1','2.990','2454000.00' ,'0.00','2454000','','2454000','4706000','RUSAK BIASA');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-16 08:52:59' WHERE kode_barang='X-00009813' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009813' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009813' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'2.990',berat_hancur_asli=berat_hancur_asli+'2.990', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'2.990',berat_akhir_asli=berat_akhir_asli-'2.990' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MDKL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260916-0001','3','X-00009814','BELI','BELI001','GL CATENA DOUBLE VAR BT 17CM KKT PER MK','1','3.400','5504500.00' ,'0.00','5504500','','5504500','12664500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-16 08:52:59' WHERE kode_barang='X-00009814' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009814' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009814' AND kode_lokasi_toko ='BELI001' LIMIT 1;
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+'1', berat_hancur=berat_hancur+'3.400',berat_hancur_asli=berat_hancur_asli+'3.400', stock_akhir=stock_akhir-'1', berat_akhir=berat_akhir-'3.400',berat_akhir_asli=berat_akhir_asli-'3.400' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTGL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_detail(no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,harga_beli_rp,biaya_produksi_rp,jml_beli_waste_rp,harga_skrg,harga_jual_rp,jml_jual_waste_rp,kondisi_barang) VALUES ('BS-260916-0001','4','X-00009815','BELI','BELI001','KL ITALY ST VAR BT 42CM KKT PER BLT MK','1','3.230','5584500.00' ,'0.00','5584500','','5584500','23753500','MULUS');
UPDATE tm_barang_beli SET deleted_by ='adminpusat', deleted_date ='2026-09-16 08:52:59' WHERE kode_barang='X-00009815' AND kode_lokasi_toko ='BELI001' LIMIT 1;
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang_beli WHERE kode_barang='X-00009815' AND kode_lokasi_toko ='BELI001' LIMIT 1;
DELETE FROM tm_barang_beli WHERE kode_barang='X-00009815' AND kode_lokasi_toko ='BELI001' LIMIT 1;
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=stock_akhir-'1', berat_akhir=berat_akhir-'3.230',berat_akhir_asli=berat_akhir_asli-'3.230' WHERE kode_lokasi_gudang = 'BELI' AND kode_lokasi_toko ='BELI001' AND kode_dept='MTKL' AND stock_akhir >0 LIMIT 1;
INSERT INTO tt_waste_head(no_waste,sales_id,tgl_system,tgl_waste,jam_Waste,jml_beli_waste_rp,jml_jual_waste_rp,input_by,input_date) VALUES ('BS-260916-0001','adminpusat','2026-09-16','2026-09-16','08:52:59','14669000','23753500', 'adminpusat','2026-09-16 08:52:59');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-16 ','08:57:51');
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-00009816','X-00009816','CN COR TDK BT SHB','GR','---','MDCN','BELI','BELI001','1956500','2026-09-16','2.050','1','sales','2026-09-16 10:33:51');
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-00009816','X-00009816');
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-260916-0001','FJ-250411-0010','2502','1','BELI','BELI001','MDCN', 'X-00009816', 'CN COR TDK BT SHB','2.100','2.050','100.00','1633000','1956500','954390','1','1956500','1956500','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-09-16','BELI','BELI001','MDCN','MDCN','100.00','2.050','2.050','1','2.050','2.050','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-260916-0001','2026-09-16','2026-09-16','10:33:51','2502','---','2.050','1956500','1956500','1956500','1956500','1956500','sales','2026-09-16 10:33:51','FB-260916-0001','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0001','SRI HIDAYATI','SIDOTOPO KIDUL 47C','','','081317767825','sales','2026-09-16 10:33:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0002','K','2026-09-16','10:33:51','sales','PEMBELIAN UMUM','FB-260916-0001','138118539','1956500','136162039','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0001';
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-00009817','X-00009817','AT CAP TDK BT SHB','GR','---','MTAT','BELI','BELI001','1029000','2026-09-16','0.720','1','cashier1','2026-09-16 11:18:06');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTAT';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTAT','X-00009817','X-00009817');
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-260916-0002','FJ-230206-0006','2502','1','BELI','BELI001','MTAT', 'X-00009817', 'AT CAP TDK BT SHB','0.770','0.720','100.00','551000','1029000','1429167','1','1029000','1029000','RONGSOK');
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-09-16','BELI','BELI001','MTAT','MTAT','100.00','0.720','0.720','1','0.720','0.720','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-260916-0002','2026-09-16','2026-09-16','11:18:05','2502','---','0.720','1029000','1029000','1029000','1029000','1029000','cashier1','2026-09-16 11:18:06','FB-260916-0002','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0002','WARDAH','SAMPANG MADURA','','','087877852419','cashier1','2026-09-16 11:18:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0003','K','2026-09-16','11:18:05','cashier1','PEMBELIAN UMUM','FB-260916-0002','136162039','1029000','135133039','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0002';
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-260916-0001','cashier1','1',' ','TOKO','BTATMT','MTAT-ZGBG-57-0','AT COR KLP TDK BT SHB ','','1.520','1','100.00','2797000','0','0','0','2797000','0','0','0','2797000','2602','00030904','MTAT','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTAT-ZGBG-57-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.520',berat_jual_asli=berat_jual_asli+'1.520',stock_jual='1',berat_akhir=berat_akhir-'1.520',berat_akhir_asli=berat_akhir_asli-'1.520',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='MTAT-ZGBG-57-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMT' 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-260916-0001','2026-09-16','1.520','2026-09-16','11:42:51','PLG0019478','2797000','2797000','0','2797000','2797000','cashier1','2026-09-16 11:42:51','FJ-260916-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-09-16','FJ-260916-0001','2026-09-16','11:42:51','2602','2797000','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-260916-0004','D','2026-09-16','11:42:51','cashier1','PENJUALAN','FJ-260916-0001','135133039','2797000','137930039');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260916-0001' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260916-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260916-0001';
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-260916-0002','cashier1','1',' EX ','TOKO','BTCNMT','MTCN-ZEAH-33-0','CN CAP BANGKOK SHB ','','0.530','1','100.00','975500','0','0','0','975500','0','0','0','975500','2602','00029609','MTCN','221000','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MTCN-ZEAH-33-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.530',berat_jual_asli=berat_jual_asli+'0.530',stock_jual='1',berat_akhir=berat_akhir-'0.530',berat_akhir_asli=berat_akhir_asli-'0.530',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='MTCN-ZEAH-33-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-260916-0002','2026-09-16','0.530','2026-09-16','11:49:04','PLG0019479','975500','975500','0','975500','975500','cashier1','2026-09-16 11:49:03','FJ-260916-0002');
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-09-16','FJ-260916-0002','2026-09-16','11:49:04','2602','975500','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-260916-0005','D','2026-09-16','11:49:04','cashier1','PENJUALAN','FJ-260916-0002','137930039','975500','138905539');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260916-0002' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260916-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260916-0002';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-16 ','11:56:03');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-16 ','12:08:46');
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-00009818','X-00009818','GL BABY PLINTIR 2 BEL SHB','GR','---','MTGL','BELI','BELI001','4695000','2026-09-16','2.900','1','sales','2026-09-16 12:22:22');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MTGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MTGL','X-00009818','X-00009818');
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-260916-0003','FJ-220625-0003','2403','1','BELI','BELI001','MTGL', 'X-00009818', 'GL BABY PLINTIR 2 BEL SHB','3.000','2.900','100.00','2112000','4695000','1618966','1','4695000','4695000','MULUS');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.900',berat_beli_asli=berat_beli_asli+'2.900',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.900',berat_akhir_asli=berat_akhir_asli+'2.900',stock_akhir=stock_akhir+'1' WHERE tanggal ='2026-09-16' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='MTGL' LIMIT 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-260916-0003','2026-09-16','2026-09-16','12:22:21','2403','---','2.900','4695000','4695000','4695000','4695000','4695000','sales','2026-09-16 12:22:22','FB-260916-0003','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0003','IBU PATIYAH','KAPASAN SAMPING 2/47','','','08592968042','sales','2026-09-16 12:22:22');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0006','K','2026-09-16','12:22:21','sales','PEMBELIAN UMUM','FB-260916-0003','138905539','4695000','134210539','OPEN');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0003';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('admin','2026-09-16 ','12:28:57');
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-00009819','X-00009819','GL RANGKAIAN 18CM KKT PER SHB','GR','---','MDGL','BELI','BELI001','4142500','2026-09-16','4.340','1','sales','2026-09-16 12:34:25');
DELETE FROM tp_barang_beli WHERE kode_dept = 'X-MDGL';
INSERT INTO tp_barang_beli (kode_dept,kode_barang,kode_barcode) VALUES ('X-MDGL','X-00009819','X-00009819');
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-260916-0004','FJ-260219-0001','2105','1','BELI','BELI001','MDGL', 'X-00009819', 'GL RANGKAIAN 18CM KKT PER SHB','4.340','4.340','100.00','5447000','4142500','954493','1','4142500','4142500','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-09-16','BELI','BELI001','MDGL','MDGL','100.00','4.340','4.340','1','4.340','4.340','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-260916-0004','2026-09-16','2026-09-16','12:34:25','2105','---','4.340','4142500','4142500','4142500','4142500','4142500','sales','2026-09-16 12:34:25','FB-260916-0004','OPEN');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-260916-0004','ESAL','JL. WONOSARI LOR 92','','','','sales','2026-09-16 12:34:25');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2026-09-16' 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-260916-0007','K','2026-09-16','12:34:25','sales','PEMBELIAN UMUM','FB-260916-0004','134210539','4142500','130068039','OPEN');
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-260916-0002','1','MDCN-XBXA-10-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.800','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.790' WHERE kode_barang='MDCN-XBXA-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XBXA-10-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XBXA-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.800,berat_hancur_asli=berat_hancur_asli+0.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-XBXA-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-260916-0002','2','MDCN-YHBH-49-0','TOKO','BTCNMD','CN COR TDK BT SHB ','1','1.790','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.780' WHERE kode_barang='MDCN-YHBH-49-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YHBH-49-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YHBH-49-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.790,berat_hancur_asli=berat_hancur_asli+1.790, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YHBH-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-260916-0002','3','MDCN-YFAI-107-0','TOKO','BTCNMD','CN COR SETENGAH RT MK ','1','3.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='3.740' WHERE kode_barang='MDCN-YFAI-107-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-107-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-107-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.750,berat_hancur_asli=berat_hancur_asli+3.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-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-260916-0002','4','MDCN-YHBH-42-0','TOKO','BTCNMD','CN COR TDK BT MK ','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.020' WHERE kode_barang='MDCN-YHBH-42-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YHBH-42-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YHBH-42-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.030,berat_hancur_asli=berat_hancur_asli+1.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YHBH-42-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-260916-0002','5','MDCN-YFAI-114-0','TOKO','BTCNMD','CN COR TDK BT MK ','1','1.010','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.000' WHERE kode_barang='MDCN-YFAI-114-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-114-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-114-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.010,berat_hancur_asli=berat_hancur_asli+1.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-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-260916-0002','6','MDCN-YJAG-7-0','TOKO','BTCNMD','CN COR BT MK ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.870' WHERE kode_barang='MDCN-YJAG-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJAG-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJAG-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.880,berat_hancur_asli=berat_hancur_asli+0.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YJAG-7-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-260916-0002','7','MDCN-YKXD-184-0','TOKO','BTCNMD','CN COR TDK BT SHB ','1','1.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.810' WHERE kode_barang='MDCN-YKXD-184-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-184-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-184-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 ='BTCNMD' AND kode_barang='MDCN-YKXD-184-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-260916-0002','8','MDCN-YKXD-195-0','TOKO','BTCNMD','CN COR TDK BT MK ','1','1.930','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.920' WHERE kode_barang='MDCN-YKXD-195-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-195-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-195-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.930,berat_hancur_asli=berat_hancur_asli+1.930, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-195-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-260916-0002','9','MDCN-YKXD-142-0','TOKO','BTCNMD','CN COR BT MK ','1','2.540','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='2.530' WHERE kode_barang='MDCN-YKXD-142-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-142-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-142-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.540,berat_hancur_asli=berat_hancur_asli+2.540, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-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-260916-0002','10','MDCN-YKXD-200-0','TOKO','BTCNMD','CN COR DOLLAR LC2 ','1','2.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='2.870' WHERE kode_barang='MDCN-YKXD-200-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-200-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-200-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 ='BTCNMD' AND kode_barang='MDCN-YKXD-200-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-260916-0002','11','MDCN-YKXD-201-0','TOKO','BTCNMD','CN COR DOLLAR LC2 ','1','2.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='2.940' WHERE kode_barang='MDCN-YKXD-201-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-201-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-201-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.950,berat_hancur_asli=berat_hancur_asli+2.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-201-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-260916-0002','12','MDCN-YKXD-144-0','TOKO','BTCNMD','CN BRILLIANT SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.310' WHERE kode_barang='MDCN-YKXD-144-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-144-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-144-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 ='BTCNMD' AND kode_barang='MDCN-YKXD-144-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-260916-0002','13','MDCN-YJAG-17-0','TOKO','BTCNMD','CN COR BT UBS ','1','2.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='2.210' WHERE kode_barang='MDCN-YJAG-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJAG-17-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJAG-17-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 ='BTCNMD' AND kode_barang='MDCN-YJAG-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-260916-0002','14','MDCN-YJCX-13-0','TOKO','BTCNMD','CN PIPA SUSUN BT MK ','1','2.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='2.890' WHERE kode_barang='MDCN-YJCX-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJCX-13-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJCX-13-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 ='BTCNMD' AND kode_barang='MDCN-YJCX-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-260916-0002','15','MDCN-YKXD-198-0','TOKO','BTCNMD','CN COR DOLLAR LC2 ','1','1.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.960' WHERE kode_barang='MDCN-YKXD-198-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-198-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-198-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 ='BTCNMD' AND kode_barang='MDCN-YKXD-198-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-260916-0002','16','MDCN-YJAG-20-0','TOKO','BTCNMD','CN PIPA SUSUN BT MK ','1','2.260','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='2.250' WHERE kode_barang='MDCN-YJAG-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJAG-20-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJAG-20-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 ='BTCNMD' AND kode_barang='MDCN-YJAG-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-260916-0002','17','MDCN-YKXD-191-0','TOKO','BTCNMD','CN COR TDK BT BTG ','1','1.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.950' WHERE kode_barang='MDCN-YKXD-191-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-191-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-191-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.960,berat_hancur_asli=berat_hancur_asli+1.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-191-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-260916-0002','18','MDCN-YKXD-143-0','TOKO','BTCNMD','CN BRILLIANT SHB ','1','1.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.330' WHERE kode_barang='MDCN-YKXD-143-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-143-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-143-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.340,berat_hancur_asli=berat_hancur_asli+1.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-143-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-260916-0002','19','MDCN-ZBXF-28-0','TOKO','BTCNMD','CN ANAK COR BT SHB ','1','0.760','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.750' WHERE kode_barang='MDCN-ZBXF-28-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-28-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-28-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.760,berat_hancur_asli=berat_hancur_asli+0.760, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBXF-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-260916-0002','20','MDCN-ZAAB-15-0','TOKO','BTCNMD','CN PLINTIR SHB ','1','2.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='2.850' WHERE kode_barang='MDCN-ZAAB-15-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZAAB-15-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZAAB-15-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.860,berat_hancur_asli=berat_hancur_asli+2.860, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZAAB-15-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-260916-0002','21','MDCN-ZAAB-10-0','TOKO','BTCNMD','CN PLINTIR SHB ','1','2.040','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='2.030' WHERE kode_barang='MDCN-ZAAB-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZAAB-10-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZAAB-10-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 ='BTCNMD' AND kode_barang='MDCN-ZAAB-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-260916-0002','22','MDCN-ZBXF-150-0','TOKO','BTCNMD','CN COR TDK BT UBS ','1','1.740','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.730' WHERE kode_barang='MDCN-ZBXF-150-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-150-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-150-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 ='BTCNMD' AND kode_barang='MDCN-ZBXF-150-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-260916-0002','23','MDCN-ZFAC-28-0','TOKO','BTCNMD','CN PLINTIR SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.310' WHERE kode_barang='MDCN-ZFAC-28-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZFAC-28-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZFAC-28-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 ='BTCNMD' AND kode_barang='MDCN-ZFAC-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-260916-0002','24','MDCN-WAXI-18-0','TOKO','BTCNMD','CN COR BT UBS ','1','0.880','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.870' WHERE kode_barang='MDCN-WAXI-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-WAXI-18-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-WAXI-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.880,berat_hancur_asli=berat_hancur_asli+0.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-WAXI-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-260916-0002','25','MDCN-XKXI-45-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.780','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.770' WHERE kode_barang='MDCN-XKXI-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-XKXI-45-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-XKXI-45-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 ='BTCNMD' AND kode_barang='MDCN-XKXI-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-260916-0002','26','MDCN-YEXE-19-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.020','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.010' WHERE kode_barang='MDCN-YEXE-19-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YEXE-19-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YEXE-19-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.020,berat_hancur_asli=berat_hancur_asli+1.020, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YEXE-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-260916-0002','27','MDCN-YFAI-72-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.810' WHERE kode_barang='MDCN-YFAI-72-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-72-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-72-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.820,berat_hancur_asli=berat_hancur_asli+0.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-72-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-260916-0002','28','MDCN-YFAI-67-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.940','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.930' WHERE kode_barang='MDCN-YFAI-67-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-67-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-67-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.940,berat_hancur_asli=berat_hancur_asli+0.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-67-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-260916-0002','29','MDCN-YFAI-137-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','5.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='5.320' WHERE kode_barang='MDCN-YFAI-137-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-137-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-137-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.330,berat_hancur_asli=berat_hancur_asli+5.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-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-260916-0002','30','MDCN-YFAI-94-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.750','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.740' WHERE kode_barang='MDCN-YFAI-94-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-94-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-94-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.750,berat_hancur_asli=berat_hancur_asli+1.750, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-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-260916-0002','31','MDCN-YHBH-20-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.170','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.160' WHERE kode_barang='MDCN-YHBH-20-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YHBH-20-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YHBH-20-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 ='BTCNMD' AND kode_barang='MDCN-YHBH-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-260916-0002','32','MDCN-YFAI-52-0','TOKO','BTCNMD','CN COR BT MK ','1','1.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.990' WHERE kode_barang='MDCN-YFAI-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-52-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-52-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.000,berat_hancur_asli=berat_hancur_asli+1.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-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-260916-0002','33','MDCN-YFAI-93-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.150' WHERE kode_barang='MDCN-YFAI-93-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-93-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-93-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.160,berat_hancur_asli=berat_hancur_asli+1.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-93-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-260916-0002','34','MDCN-YFAI-135-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','5.110','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='5.100' WHERE kode_barang='MDCN-YFAI-135-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-135-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-135-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.110,berat_hancur_asli=berat_hancur_asli+5.110, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-135-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-260916-0002','35','MDCN-YFAI-86-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.890' WHERE kode_barang='MDCN-YFAI-86-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YFAI-86-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YFAI-86-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.900,berat_hancur_asli=berat_hancur_asli+0.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YFAI-86-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-260916-0002','36','MDCN-YKXD-112-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.610','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.600' WHERE kode_barang='MDCN-YKXD-112-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-112-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-112-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 ='BTCNMD' AND kode_barang='MDCN-YKXD-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-260916-0002','37','MDCN-YKXD-154-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','5.620','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='5.610' WHERE kode_barang='MDCN-YKXD-154-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-154-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-154-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.620,berat_hancur_asli=berat_hancur_asli+5.620, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-154-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-260916-0002','38','MDCN-YKXD-140-0','TOKO','BTCNMD','CN COR BT AD MRH SHB ','1','3.630','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='3.620' WHERE kode_barang='MDCN-YKXD-140-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-140-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-140-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.630,berat_hancur_asli=berat_hancur_asli+3.630, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-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-260916-0002','39','MDCN-YKXD-67-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.830','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.820' WHERE kode_barang='MDCN-YKXD-67-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-67-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-67-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.830,berat_hancur_asli=berat_hancur_asli+0.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-67-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-260916-0002','40','MDCN-YKXD-93-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.920','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.910' WHERE kode_barang='MDCN-YKXD-93-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-93-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-93-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.920,berat_hancur_asli=berat_hancur_asli+0.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-93-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-260916-0002','41','MDCN-YKXD-117-0','TOKO','BTCNMD','CN COR BT SHB ','1','2.410','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='2.400' WHERE kode_barang='MDCN-YKXD-117-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-117-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-117-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 ='BTCNMD' AND kode_barang='MDCN-YKXD-117-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-260916-0002','42','MDCN-YJBI-8-0','TOKO','BTCNMD','CN COR BT MK ','1','1.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.040' WHERE kode_barang='MDCN-YJBI-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YJBI-8-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YJBI-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.050,berat_hancur_asli=berat_hancur_asli+1.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YJBI-8-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-260916-0002','43','MDCN-YKXD-59-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.760','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.750' WHERE kode_barang='MDCN-YKXD-59-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-59-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-59-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.760,berat_hancur_asli=berat_hancur_asli+0.760, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-59-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-260916-0002','44','MDCN-YKXD-131-0','TOKO','BTCNMD','CN COR BT SHB ','1','3.680','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='3.670' WHERE kode_barang='MDCN-YKXD-131-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-131-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-131-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.680,berat_hancur_asli=berat_hancur_asli+3.680, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-131-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-260916-0002','45','MDCN-YKXD-155-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','5.820','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='5.810' WHERE kode_barang='MDCN-YKXD-155-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YKXD-155-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YKXD-155-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.820,berat_hancur_asli=berat_hancur_asli+5.820, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-YKXD-155-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-260916-0002','46','MDCN-ZBXF-131-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','5.120','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='5.110' WHERE kode_barang='MDCN-ZBXF-131-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-131-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-131-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.120,berat_hancur_asli=berat_hancur_asli+5.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBXF-131-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-260916-0002','47','MDCN-ZBXF-133-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','6.070','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='6.060' WHERE kode_barang='MDCN-ZBXF-133-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-133-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-133-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+6.070,berat_hancur_asli=berat_hancur_asli+6.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBXF-133-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-260916-0002','48','MDCN-ZBXF-130-0','TOKO','BTCNMD','CN COR EROPA SHB ','1','4.760','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='4.750' WHERE kode_barang='MDCN-ZBXF-130-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-130-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-130-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.760,berat_hancur_asli=berat_hancur_asli+4.760, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBXF-130-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-260916-0002','49','MDCN-ZBXF-104-0','TOKO','BTCNMD','CN COR BT SHB ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.310' WHERE kode_barang='MDCN-ZBXF-104-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-104-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-104-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 ='BTCNMD' AND kode_barang='MDCN-ZBXF-104-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-260916-0002','50','MDCN-ZBXF-71-0','TOKO','BTCNMD','CN COR BT SHB ','1','0.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='0.970' WHERE kode_barang='MDCN-ZBXF-71-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-71-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-71-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.980,berat_hancur_asli=berat_hancur_asli+0.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBXF-71-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-260916-0002','51','MDCN-ZBXF-45-0','TOKO','BTCNMD','CN COR BT MK ','1','1.430','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.420' WHERE kode_barang='MDCN-ZBXF-45-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBXF-45-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBXF-45-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.430,berat_hancur_asli=berat_hancur_asli+1.430, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTCNMD' AND kode_barang='MDCN-ZBXF-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-260916-0002','52','MDCN-YLXI-5-0','TOKO','BTCNMD','CN COR BT MK ','1','1.610','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.600' WHERE kode_barang='MDCN-YLXI-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-YLXI-5-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-YLXI-5-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 ='BTCNMD' AND kode_barang='MDCN-YLXI-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-260916-0002','53','MDCN-ZBAB-11-0','TOKO','BTCNMD','CN COR BT MK ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:39:01',status_delete='1.310' WHERE kode_barang='MDCN-ZBAB-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDCN-ZBAB-11-0';
DELETE FROM tm_barang WHERE kode_barang='MDCN-ZBAB-11-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 ='BTCNMD' AND kode_barang='MDCN-ZBAB-11-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-260916-0002','2026-09-16','admin','2026-09-16','12:39:01','admin','2026-09-16 12:39:01');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('cashier1','2026-09-16 ','12:40:53');
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-260916-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-260916-0004';
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('sales','2026-09-16 ','12:42:27');
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-260916-0003','1','MDGW-ZBAH-107-0','TOKO','BTGWMD','GW COR TDK BT LC2 ','1','0.860','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='0.850' WHERE kode_barang='MDGW-ZBAH-107-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBAH-107-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAH-107-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.860,berat_hancur_asli=berat_hancur_asli+0.860, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMD' AND kode_barang='MDGW-ZBAH-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-260916-0003','2','MDGW-ZBAH-114-0','TOKO','BTGWMD','GW COR TDK BT LC2 ','1','1.400','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='1.390' WHERE kode_barang='MDGW-ZBAH-114-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBAH-114-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAH-114-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 ='BTGWMD' AND kode_barang='MDGW-ZBAH-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-260916-0003','3','MDGW-ZBAH-110-0','TOKO','BTGWMD','GW COR TDK BT SMBR PTH LC2 ','1','0.960','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='0.950' WHERE kode_barang='MDGW-ZBAH-110-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBAH-110-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAH-110-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.960,berat_hancur_asli=berat_hancur_asli+0.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMD' AND kode_barang='MDGW-ZBAH-110-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-260916-0003','4','MDGW-ZBAH-108-0','TOKO','BTGWMD','GW COR TDK BT LC2 ','1','0.650','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='0.640' WHERE kode_barang='MDGW-ZBAH-108-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBAH-108-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAH-108-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.650,berat_hancur_asli=berat_hancur_asli+0.650, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMD' AND kode_barang='MDGW-ZBAH-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-260916-0003','5','MDGW-ZBAH-105-0','TOKO','BTGWMD','GW COR TDK BT LC2 ','1','0.670','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='0.660' WHERE kode_barang='MDGW-ZBAH-105-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBAH-105-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAH-105-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.670,berat_hancur_asli=berat_hancur_asli+0.670, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMD' AND kode_barang='MDGW-ZBAH-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-260916-0003','6','MDGW-YCAC-69-0','TOKO','BTGWMD','GW COR TDK BT UBS','1','0.770','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='0.760' WHERE kode_barang='MDGW-YCAC-69-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-YCAC-69-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-YCAC-69-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 ='BTGWMD' AND kode_barang='MDGW-YCAC-69-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-260916-0003','7','MDGW-ZBAX-50-0','TOKO','BTGWMD','GW COR BT SHB ','1','0.980','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='0.970' WHERE kode_barang='MDGW-ZBAX-50-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBAX-50-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAX-50-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.980,berat_hancur_asli=berat_hancur_asli+0.980, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMD' AND kode_barang='MDGW-ZBAX-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-260916-0003','8','MDGW-ZBBX-88-0','TOKO','BTGWMD','GW COR TDK BT 3 WRN UBS ','1','1.340','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='1.330' WHERE kode_barang='MDGW-ZBBX-88-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBBX-88-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBBX-88-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.340,berat_hancur_asli=berat_hancur_asli+1.340, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMD' AND kode_barang='MDGW-ZBBX-88-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-260916-0003','9','MDGW-ZBAX-52-0','TOKO','BTGWMD','GW COR BT SHB ','1','1.050','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='1.040' WHERE kode_barang='MDGW-ZBAX-52-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBAX-52-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAX-52-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.050,berat_hancur_asli=berat_hancur_asli+1.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMD' AND kode_barang='MDGW-ZBAX-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-260916-0003','10','MDGW-ZBAX-51-0','TOKO','BTGWMD','GW COR BT SHB ','1','1.030','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='1.020' WHERE kode_barang='MDGW-ZBAX-51-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBAX-51-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAX-51-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.030,berat_hancur_asli=berat_hancur_asli+1.030, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMD' AND kode_barang='MDGW-ZBAX-51-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-260916-0003','11','MDGW-ZBAB-47-0','TOKO','BTGWMD','GW COR BT UBS ','1','0.950','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:44:48',status_delete='0.940' WHERE kode_barang='MDGW-ZBAB-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDGW-ZBAB-47-0';
DELETE FROM tm_barang WHERE kode_barang='MDGW-ZBAB-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.950,berat_hancur_asli=berat_hancur_asli+0.950, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTGWMD' AND kode_barang='MDGW-ZBAB-47-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-260916-0003','2026-09-16','admin','2026-09-16','12:44:48','admin','2026-09-16 12:44:48');
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-260916-0004','1','MDAT-YABD-1-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.160','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.150' WHERE kode_barang='MDAT-YABD-1-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YABD-1-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YABD-1-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.160,berat_hancur_asli=berat_hancur_asli+1.160, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YABD-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-260916-0004','2','MDAT-YCBE-132-0','TOKO','BTATMD','AT COR KLP BT UBS ','1','1.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.490' WHERE kode_barang='MDAT-YCBE-132-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCBE-132-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCBE-132-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 ='BTATMD' AND kode_barang='MDAT-YCBE-132-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-260916-0004','3','MDAT-YCBE-134-0','TOKO','BTATMD','AT COR KLP BT AD PINK MK ','1','1.230','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.220' WHERE kode_barang='MDAT-YCBE-134-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCBE-134-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCBE-134-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 ='BTATMD' AND kode_barang='MDAT-YCBE-134-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-260916-0004','4','MDAT-YCBE-130-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.150','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.140' WHERE kode_barang='MDAT-YCBE-130-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCBE-130-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCBE-130-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 ='BTATMD' AND kode_barang='MDAT-YCBE-130-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-260916-0004','5','MDAT-YCBE-131-0','TOKO','BTATMD','AT COR KLP BT SHB ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.290' WHERE kode_barang='MDAT-YCBE-131-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCBE-131-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCBE-131-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.300,berat_hancur_asli=berat_hancur_asli+1.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YCBE-131-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-260916-0004','6','MDAT-YCBE-123-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','0.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.490' WHERE kode_barang='MDAT-YCBE-123-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCBE-123-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCBE-123-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.500,berat_hancur_asli=berat_hancur_asli+0.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YCBE-123-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-260916-0004','7','MDAT-YCBE-126-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','1.000','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.990' WHERE kode_barang='MDAT-YCBE-126-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCBE-126-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCBE-126-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.000,berat_hancur_asli=berat_hancur_asli+1.000, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YCBE-126-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-260916-0004','8','MDAT-YFAI-12-0','TOKO','BTATMD','AT COR KLP BT MK ','1','1.300','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.290' WHERE kode_barang='MDAT-YFAI-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YFAI-12-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YFAI-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.300,berat_hancur_asli=berat_hancur_asli+1.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YFAI-12-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-260916-0004','9','MDAT-YKXD-40-0','TOKO','BTATMD','AT COR KAWAT BT MK ','1','1.680','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.670' WHERE kode_barang='MDAT-YKXD-40-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YKXD-40-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YKXD-40-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.680,berat_hancur_asli=berat_hancur_asli+1.680, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YKXD-40-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-260916-0004','10','MDAT-YJCX-8-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','0.500','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.490' WHERE kode_barang='MDAT-YJCX-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YJCX-8-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YJCX-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.500,berat_hancur_asli=berat_hancur_asli+0.500, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YJCX-8-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-260916-0004','11','MDAT-YKXD-5-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','0.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.480' WHERE kode_barang='MDAT-YKXD-5-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YKXD-5-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YKXD-5-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.490,berat_hancur_asli=berat_hancur_asli+0.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YKXD-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-260916-0004','12','MDAT-YLXA-58-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','0.480','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.470' WHERE kode_barang='MDAT-YLXA-58-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YLXA-58-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YLXA-58-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.480,berat_hancur_asli=berat_hancur_asli+0.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YLXA-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-260916-0004','13','MDAT-YKXD-11-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','0.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.480' WHERE kode_barang='MDAT-YKXD-11-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YKXD-11-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YKXD-11-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.490,berat_hancur_asli=berat_hancur_asli+0.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YKXD-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-260916-0004','14','MDAT-YKXD-8-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','0.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.480' WHERE kode_barang='MDAT-YKXD-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YKXD-8-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YKXD-8-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.490,berat_hancur_asli=berat_hancur_asli+0.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YKXD-8-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-260916-0004','15','MDAT-ZBXF-4-0','TOKO','BTATMD','AT JEPSI POLOS MK ','1','0.970','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.960' WHERE kode_barang='MDAT-ZBXF-4-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZBXF-4-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZBXF-4-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.970,berat_hancur_asli=berat_hancur_asli+0.970, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-ZBXF-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-260916-0004','16','MDAT-ZDAX-3-0','TOKO','BTATMD','AT JEPSI PLS SHB ','1','0.490','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.480' WHERE kode_barang='MDAT-ZDAX-3-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-ZDAX-3-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-ZDAX-3-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.490,berat_hancur_asli=berat_hancur_asli+0.490, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-ZDAX-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-260916-0004','17','MDAT-XJAF-7-0','TOKO','BTATMD','AT ITALY BT SHB ','1','1.200','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.190' WHERE kode_barang='MDAT-XJAF-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XJAF-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XJAF-7-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.200,berat_hancur_asli=berat_hancur_asli+1.200, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-XJAF-7-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-260916-0004','18','MDAT-XJAF-13-0','TOKO','BTATMD','AT ITALY BT SHB ','1','1.330','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.320' WHERE kode_barang='MDAT-XJAF-13-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-XJAF-13-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-XJAF-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 ='BTATMD' AND kode_barang='MDAT-XJAF-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-260916-0004','19','MDAT-YCAC-25-0','TOKO','BTATMD','AT TUSUK BT UBS ','1','0.900','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='0.890' WHERE kode_barang='MDAT-YCAC-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCAC-25-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCAC-25-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.900,berat_hancur_asli=berat_hancur_asli+0.900, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YCAC-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-260916-0004','20','MDAT-YCAC-17-0','TOKO','BTATMD','AT COR KLP BT MN HT UBS ','1','1.220','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.210' WHERE kode_barang='MDAT-YCAC-17-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCAC-17-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCAC-17-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.220,berat_hancur_asli=berat_hancur_asli+1.220, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='BTATMD' AND kode_barang='MDAT-YCAC-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-260916-0004','21','MDAT-YCAC-8-0','TOKO','BTATMD','AT COR KLP MN HT UBS ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.310' WHERE kode_barang='MDAT-YCAC-8-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCAC-8-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCAC-8-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 ='BTATMD' AND kode_barang='MDAT-YCAC-8-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-260916-0004','22','MDAT-YCAC-7-0','TOKO','BTATMD','AT COR KLP MN HT UBS ','1','1.320','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.310' WHERE kode_barang='MDAT-YCAC-7-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YCAC-7-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YCAC-7-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 ='BTATMD' AND kode_barang='MDAT-YCAC-7-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-260916-0004','23','MDAT-YFAI-41-0','TOKO','BTATMD','AT ITALY HT BT SHB ','1','1.670','RETUR CUCI ULANG');
UPDATE tm_barang SET deleted_by ='admin', deleted_date ='2026-09-16 12:49:49',status_delete='1.660' WHERE kode_barang='MDAT-YFAI-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='MDAT-YFAI-41-0';
DELETE FROM tm_barang WHERE kode_barang='MDAT-YFAI-41-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 ='BTATMD' AND kode_barang='MDAT-YFAI-41-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-260916-0004','2026-09-16','admin','2026-09-16','12:49:49','admin','2026-09-16 12:49:49');
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-260916-0003','sales','1',' EX ','TOKO','BTGLMD','MDGL-ZEAI-46-0','GL FANCY 17CM KKT PER SHB ','','1.000','1','100.00','1110000','0','0','0','1110000','0','0','0','1110000','2103','00029688','MDGL','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDGL-ZEAI-46-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.000',berat_jual_asli=berat_jual_asli+'1.000',stock_jual='1',berat_akhir=berat_akhir-'1.000',berat_akhir_asli=berat_akhir_asli-'1.000',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='MDGL-ZEAI-46-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-260916-0003','2026-09-16','1.000','2026-09-16','13:08:08','PLG0019480','1110000','1110000','0','1110000','1110000','sales','2026-09-16 13:08:05','FJ-260916-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-09-16','FJ-260916-0003','2026-09-16','13:08:08','2103','1110000','0');
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 ('KM-260916-0008','D','2026-09-16','13:08:08','sales','PENJUALAN','FJ-260916-0003','130068039','1110000','131178039','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1110000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260916-0003' LIMIT 1;
INSERT INTO tt_jual_detail(no_faktur_jual,input_by,no_urut,kode_intern,kode_lokasi_gudang,kode_lokasi_toko,kode_barang,nama_barang,nama_atribut,berat,qty,kadar,harga_beli,berlian_rp,berlian_usd,curr_rp,harga_jual,harga_atribut,ongkos_detail,ongkos_berlian,dpp_detail,sales_id,kode_barcode,kode_dept,potongan,diskon,no_voucher,potong_rp) VALUES ('FJ-260916-0004','sales',' 1',' EX ','TOKO','BTATMD','MDAT-ZHBI-3-0','AT TINDIK MN MAS 1 MK ','','0.520','1','100.00','577500','0','0','0','577500','0','0','0','577500','2103','00031175','MDAT','155500','0','-','0');
UPDATE tm_barang SET tgl_last_jual='2026-09-16', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='MDAT-ZHBI-3-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.520',berat_jual_asli=berat_jual_asli+'0.520',stock_jual='1',berat_akhir=berat_akhir-'0.520',berat_akhir_asli=berat_akhir_asli-'0.520',stock_akhir='0' WHERE tanggal='2026-09-16' AND kode_barang='MDAT-ZHBI-3-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='BTATMD' 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-260916-0004','2026-09-16','0.520','2026-09-16','13:08:08','PLG0019481','577500','577500','0','577500','577500','sales','2026-09-16 13:08:05','FJ-260916-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-09-16','FJ-260916-0004','2026-09-16','13:08:08','2103','577500','0');
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 ('KM-260916-0009','D','2026-09-16','13:08:08','sales','PENJUALAN','FJ-260916-0004','131178039','577500','131755539','OPEN');
UPDATE tt_jual_head SET dibayar_rp='577500',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='FJ-260916-0004' LIMIT 1;
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260916-0003' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260916-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260916-0003';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260916-0004' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='FJ-260916-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FJ-260916-0004';
INSERT INTO tt_bayar_bunga(no_hutang,tgl_system,tgl_bayar,total_bunga,dibayar,saldo) Values ('PI26-01807','2026-09-16', '2026-09-16','168000','168000','168000');
UPDATE tt_hutang_head set sld_akhir_rp=sld_akhir_rp +'168000' WHERE no_hutang='PI26-01807';
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-260916-0010','D','2026-09-16','14:57:09','cashier1','HUTANG BUNGA','PI26-01807','131755539','168000','131923539');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-16 ','14:57:13');
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-260916-0011','K','2026-09-16','15:00:18','cashier1','PENGELUARAN','BELI AIR MINUM 3 GALON CLUB ','131923539','54000','131869539');
INSERT INTO th_user_login (user_id,tgl_login,jam_login) VALUES('adminpusat','2026-09-16 ','16:02:47');