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,status_otorisasi,harga_skrg) VALUES ('F325050915191','input','1',' MGD1G X HW','TOKO','PM-D','D1G-YGBF-30-0','LT X SLOBOK CAT HITAM HW 8K ','','0.370','1','100.00','339000','0','0','15000','340000','0','0','0','340000','FIT','00362686','D1G','0','0','-','0','916000');
UPDATE tm_barang SET tgl_last_jual='2025-09-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='D1G-YGBF-30-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.370',berat_jual_asli=berat_jual_asli+'0.370',stock_jual='1',berat_akhir=berat_akhir-'0.370',berat_akhir_asli=berat_akhir_asli-'0.370',stock_akhir='0' WHERE tanggal='2025-09-05' AND kode_barang='D1G-YGBF-30-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-D' 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 ('F325050915191','2025-09-05','0.370','2025-09-05','09:15:20','PLG0024815','340000','340000','0','340000','340000','input','2025-09-05 09:15:19','F32505091519');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-05','F325050915191','2025-09-05','09:15:20','FIT','340000','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-250905-0002','D','2025-09-05','09:15:20','input','PENJUALAN','F325050915191','12542000','340000','12882000');
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,status_otorisasi,harga_skrg) VALUES ('F325050953011','input','1',' MFH1 KH 42','TOKO','PM-H','H1F-YGAF-221-0','KL KOREA KH 42CM 8K ','','3.100','1','100.00','2787000','0','0','15000','2787000','0','0','0','2787000','FIT','00361047','H1F','0','0','-','0','899000');
UPDATE tm_barang SET tgl_last_jual='2025-09-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='H1F-YGAF-221-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'3.100',berat_jual_asli=berat_jual_asli+'3.100',stock_jual='1',berat_akhir=berat_akhir-'3.100',berat_akhir_asli=berat_akhir_asli-'3.100',stock_akhir='0' WHERE tanggal='2025-09-05' AND kode_barang='H1F-YGAF-221-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-H' 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 ('F325050953011','2025-09-05','3.100','2025-09-05','09:53:01','PLG0024816','2787000','2787000','0','2787000','2787000','input','2025-09-05 09:53:01','F32505095301');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-05','F325050953011','2025-09-05','09:53:01','FIT','2787000','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-250905-0003','D','2025-09-05','09:53:01','input','PENJUALAN','F325050953011','12882000','2787000','15669000');
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-00016906','X-00016906','GL X GUCCI SLEP UB 8K','GR','---','F3F','BELI','BELI001','395000','2025-09-05','0.510','1','kasir','2025-09-05 10:37:57');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3F','X-00016906','X-00016906');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0001','F325191128501','AAT','1','BELI','BELI001','F3F', 'X-00016906', 'GL X GUCCI SLEP UB 8K','0.510','0.510','100.00','430000','395000','774510','899000','1','395000','395000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3F' 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) VALUES ('FB-250905-0001','2025-09-05','2025-09-05','10:37:56','AAT','---','0.510','395000','395000','395000','395000','395000','kasir','2025-09-05 10:37:57','FB-250905-0001');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0001','WINDA','KEPUH PLOSO','','','','kasir','2025-09-05 10:37:57');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0004','K','2025-09-05','10:37:56','kasir','PEMBELIAN UMUM','FB-250905-0001','15669000','395000','15274000');
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-00016907','X-00016907','CC MODEL MATA VAR LG 8 8K','GR','---','E2E','BELI','BELI001','395000','2025-09-05','0.510','1','kasir','2025-09-05 10:38:38');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00016907','X-00016907');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0002','F325060803201','FIT','1','BELI','BELI001','E2E', 'X-00016907', 'CC MODEL MATA VAR LG 8 8K','0.510','0.510','100.00','430000','395000','774510','882000','1','395000','395000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.510',berat_beli_asli=berat_beli_asli+'0.510',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.510',berat_akhir_asli=berat_akhir_asli+'0.510',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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) VALUES ('FB-250905-0002','2025-09-05','2025-09-05','10:38:38','FIT','---','0.510','395000','395000','395000','395000','395000','kasir','2025-09-05 10:38:38','FB-250905-0002');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0002','SEPTI','KELORAN JOHO','','','','kasir','2025-09-05 10:38:38');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0005','K','2025-09-05','10:38:38','kasir','PEMBELIAN UMUM','FB-250905-0002','15274000','395000','14879000');
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-00016908','X-00016908','AT X MODEL BOLA ARESO UB 17K','GR','---','A1TF','BELI','BELI001','1942000','2025-09-05','1.400','1','kasir','2025-09-05 10:39:12');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1TF';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1TF','X-00016908','X-00016908');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0003','F325100111391','FIT','1','BELI','BELI001','A1TF', 'X-00016908', 'AT X MODEL BOLA ARESO UB 17K','1.400','1.400','100.00','2068000','1942000','1387143','1567000','1','1942000','1942000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.400',berat_beli_asli=berat_beli_asli+'1.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.400',berat_akhir_asli=berat_akhir_asli+'1.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1TF' 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) VALUES ('FB-250905-0003','2025-09-05','2025-09-05','10:39:12','FIT','---','1.400','1942000','1942000','1942000','1942000','1942000','kasir','2025-09-05 10:39:12','FB-250905-0003');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0003','YANA','BADEGAN','','','','kasir','2025-09-05 10:39:12');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0006','K','2025-09-05','10:39:12','kasir','PEMBELIAN UMUM','FB-250905-0003','14879000','1942000','12937000');
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-00016909','X-00016909','LT X CHARM SLOBOK BOLA SLEP BG 8K','GR','---','D1F','BELI','BELI001','767000','2025-09-05','0.980','1','kasir','2025-09-05 10:39:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-D1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D1F','X-00016909','X-00016909');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0004','F325110257081','FIT','1','BELI','BELI001','D1F', 'X-00016909', 'LT X CHARM SLOBOK BOLA SLEP BG 8K','0.980','0.980','100.00','825000','767000','782653','899000','1','767000','767000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D1F' 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) VALUES ('FB-250905-0004','2025-09-05','2025-09-05','10:39:36','FIT','---','0.980','767000','767000','767000','767000','767000','kasir','2025-09-05 10:39:37','FB-250905-0004');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0004','YANA','BADEGAN','','','','kasir','2025-09-05 10:39:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0007','K','2025-09-05','10:39:36','kasir','PEMBELIAN UMUM','FB-250905-0004','12937000','767000','12170000');
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-250905-0001','1','H3J-YABC-261-0','TOKO','PM-H','KL X SANTA BOLA PASIR UB 42 9K ','1','3.640','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.640' WHERE kode_barang='H3J-YABC-261-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H3J-YABC-261-0';
DELETE FROM tm_barang WHERE kode_barang='H3J-YABC-261-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.640,berat_hancur_asli=berat_hancur_asli+3.640, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-H' AND kode_barang='H3J-YABC-261-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-250905-0001','2','E2E-XDBC-73-0','TOKO','PM-E','CC X MODEL MATA ROSE KH 10 8K ','1','1.560','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.560' WHERE kode_barang='E2E-XDBC-73-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XDBC-73-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XDBC-73-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.560,berat_hancur_asli=berat_hancur_asli+1.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-XDBC-73-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-250905-0001','3','F1E-XBBA-177-0','TOKO','PM-F','GL OVAL CAT SLEP HW 56 8K ','1','4.260','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='4.260' WHERE kode_barang='F1E-XBBA-177-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F1E-XBBA-177-0';
DELETE FROM tm_barang WHERE kode_barang='F1E-XBBA-177-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.260,berat_hancur_asli=berat_hancur_asli+4.260, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F1E-XBBA-177-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-250905-0001','4','A1E-XJBE-164-0','TOKO','PM-A','AT X MODEL MATA VAR LG 8K ','1','0.580','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.580' WHERE kode_barang='A1E-XJBE-164-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-XJBE-164-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-XJBE-164-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.580,berat_hancur_asli=berat_hancur_asli+0.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-A' AND kode_barang='A1E-XJBE-164-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-250905-0001','5','A1D-YBXA-145-0','TOKO','PM-A','AT X MODEL MATA BM 8K ','1','1.150','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.150' WHERE kode_barang='A1D-YBXA-145-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1D-YBXA-145-0';
DELETE FROM tm_barang WHERE kode_barang='A1D-YBXA-145-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 ='PM-A' AND kode_barang='A1D-YBXA-145-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-250905-0001','6','E2D-XLBD-10-0','TOKO','PM-E','CC X MODEL MATA UB 14 8K ','1','2.100','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.100' WHERE kode_barang='E2D-XLBD-10-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2D-XLBD-10-0';
DELETE FROM tm_barang WHERE kode_barang='E2D-XLBD-10-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.100,berat_hancur_asli=berat_hancur_asli+2.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2D-XLBD-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-250905-0001','7','E1D-XLBD-112-0','TOKO','PM-E','CC X MODEL SLEP HW 15 8K ','1','1.090','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.090' WHERE kode_barang='E1D-XLBD-112-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1D-XLBD-112-0';
DELETE FROM tm_barang WHERE kode_barang='E1D-XLBD-112-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.090,berat_hancur_asli=berat_hancur_asli+1.090, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1D-XLBD-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-250905-0001','8','F1E-YEAI-57-0','TOKO','PM-F','GL X OVAL SLEP HW 54 8K ','1','2.550','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.550' WHERE kode_barang='F1E-YEAI-57-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F1E-YEAI-57-0';
DELETE FROM tm_barang WHERE kode_barang='F1E-YEAI-57-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.550,berat_hancur_asli=berat_hancur_asli+2.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F1E-YEAI-57-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','9','E2E-UBAH-85-0','TOKO','PM-E','CC SOLITAIRE MATA UB 16 ','1','1.300','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.300' WHERE kode_barang='E2E-UBAH-85-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-UBAH-85-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-UBAH-85-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 ='PM-E' AND kode_barang='E2E-UBAH-85-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-250905-0001','10','A1E-WLBC-440-0','TOKO','PM-A','AT BANGKOK KLIP SLEP LG ','1','0.920','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.920' WHERE kode_barang='A1E-WLBC-440-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-WLBC-440-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-WLBC-440-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 ='PM-A' AND kode_barang='A1E-WLBC-440-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-250905-0001','11','E2D-XHBD-328-0','TOKO','PM-E','CC X MODEL MATA LG 14 8K ','1','1.000','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.000' WHERE kode_barang='E2D-XHBD-328-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2D-XHBD-328-0';
DELETE FROM tm_barang WHERE kode_barang='E2D-XHBD-328-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 ='PM-E' AND kode_barang='E2D-XHBD-328-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-250905-0001','12','E2E-WLAC-36-0','TOKO','PM-E','CC X MODEL MATA YT 12 ','1','1.400','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.400' WHERE kode_barang='E2E-WLAC-36-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-WLAC-36-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-WLAC-36-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 ='PM-E' AND kode_barang='E2E-WLAC-36-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-250905-0001','13','E2E-WLAC-46-0','TOKO','PM-E','CC X MODEL MATA CM 14 ','1','1.000','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.000' WHERE kode_barang='E2E-WLAC-46-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-WLAC-46-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-WLAC-46-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 ='PM-E' AND kode_barang='E2E-WLAC-46-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','14','E2E-WHXH-109-0','TOKO','PM-E','CC X MODEL MATA LG 16 ','1','1.000','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.000' WHERE kode_barang='E2E-WHXH-109-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-WHXH-109-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-WHXH-109-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 ='PM-E' AND kode_barang='E2E-WHXH-109-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-250905-0001','15','E2E-XDBF-33-0','TOKO','PM-E','CC X MODEL MATA VAR CM 18 8K ','1','1.920','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.920' WHERE kode_barang='E2E-XDBF-33-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XDBF-33-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XDBF-33-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.920,berat_hancur_asli=berat_hancur_asli+1.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-XDBF-33-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','16','A1E-WCXD-212-0','TOKO','PM-A','AT X MODEL MATA LG ','1','1.030','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.030' WHERE kode_barang='A1E-WCXD-212-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-WCXD-212-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-WCXD-212-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 ='PM-A' AND kode_barang='A1E-WCXD-212-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-250905-0001','17','E1E-WKXF-206-0','TOKO','PM-E','CC X MODEL SLEP HW 13 ','1','1.760','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.760' WHERE kode_barang='E1E-WKXF-206-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1E-WKXF-206-0';
DELETE FROM tm_barang WHERE kode_barang='E1E-WKXF-206-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.760,berat_hancur_asli=berat_hancur_asli+1.760, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1E-WKXF-206-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-250905-0001','18','E2F-YEAI-247-0','TOKO','PM-E','CC X MODEL SLEP BG 14 8K ','1','1.800','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.800' WHERE kode_barang='E2F-YEAI-247-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2F-YEAI-247-0';
DELETE FROM tm_barang WHERE kode_barang='E2F-YEAI-247-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.800,berat_hancur_asli=berat_hancur_asli+1.800, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2F-YEAI-247-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-250905-0001','19','A1E-XHXE-66-0','TOKO','PM-A','AT X HUGGIES MODEL SLEP UB 8K ','1','1.120','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.120' WHERE kode_barang='A1E-XHXE-66-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-XHXE-66-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-XHXE-66-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.120,berat_hancur_asli=berat_hancur_asli+1.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-A' AND kode_barang='A1E-XHXE-66-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-250905-0001','20','A1E-UEXI-25-0','TOKO','PM-A','AT GYPSY VAR LG ','1','0.530','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.530' WHERE kode_barang='A1E-UEXI-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-UEXI-25-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-UEXI-25-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.530,berat_hancur_asli=berat_hancur_asli+0.530, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-A' AND kode_barang='A1E-UEXI-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-250905-0001','21','E1E-WLBI-208-0','TOKO','PM-E','CC X MODEL SLEP BG 14 ','1','1.420','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.420' WHERE kode_barang='E1E-WLBI-208-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1E-WLBI-208-0';
DELETE FROM tm_barang WHERE kode_barang='E1E-WLBI-208-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.420,berat_hancur_asli=berat_hancur_asli+1.420, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1E-WLBI-208-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','22','E1F-XJAF-180-0','TOKO','PM-E','CC MODEL SLEP BG 14 8K ','1','0.650','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.650' WHERE kode_barang='E1F-XJAF-180-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1F-XJAF-180-0';
DELETE FROM tm_barang WHERE kode_barang='E1F-XJAF-180-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 ='PM-E' AND kode_barang='E1F-XJAF-180-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-250905-0001','23','A1E-XFBA-285-0','TOKO','PM-A','AT GYPSY BINTANG VAR LG 8K ','1','0.550','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.550' WHERE kode_barang='A1E-XFBA-285-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-XFBA-285-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-XFBA-285-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.550,berat_hancur_asli=berat_hancur_asli+0.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-A' AND kode_barang='A1E-XFBA-285-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-250905-0001','24','E1E-XEAD-165-0','TOKO','PM-E','CC X MODEL MATA KH 18 8K ','1','1.560','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.560' WHERE kode_barang='E1E-XEAD-165-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1E-XEAD-165-0';
DELETE FROM tm_barang WHERE kode_barang='E1E-XEAD-165-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.560,berat_hancur_asli=berat_hancur_asli+1.560, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1E-XEAD-165-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-250905-0001','25','E2D-YAXD-141-0','TOKO','PM-E','CC X MODEL MATA CM 18 8K ','1','1.520','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.520' WHERE kode_barang='E2D-YAXD-141-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2D-YAXD-141-0';
DELETE FROM tm_barang WHERE kode_barang='E2D-YAXD-141-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.520,berat_hancur_asli=berat_hancur_asli+1.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2D-YAXD-141-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','26','E2E-WHXA-71-0','TOKO','PM-E','CC X MODEL MATA CM 16 ','1','1.450','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.450' WHERE kode_barang='E2E-WHXA-71-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-WHXA-71-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-WHXA-71-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.450,berat_hancur_asli=berat_hancur_asli+1.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-WHXA-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-250905-0001','27','E2E-XGBB-205-0','TOKO','PM-E','CC X MODEL MATA UB 12 8K ','1','1.380','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.380' WHERE kode_barang='E2E-XGBB-205-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XGBB-205-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XGBB-205-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.380,berat_hancur_asli=berat_hancur_asli+1.380, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-XGBB-205-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-250905-0001','28','H1F-WFAI-76-0','TOKO','PM-H','KL SANTA MATA HITAM VAR HW 42 ','1','3.570','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.570' WHERE kode_barang='H1F-WFAI-76-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H1F-WFAI-76-0';
DELETE FROM tm_barang WHERE kode_barang='H1F-WFAI-76-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.570,berat_hancur_asli=berat_hancur_asli+3.570, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-H' AND kode_barang='H1F-WFAI-76-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','29','E1E-WDXF-161-0','TOKO','PM-E','CC MODEL SLEP MJ 16 ','1','1.230','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.230' WHERE kode_barang='E1E-WDXF-161-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1E-WDXF-161-0';
DELETE FROM tm_barang WHERE kode_barang='E1E-WDXF-161-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 ='PM-E' AND kode_barang='E1E-WDXF-161-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-250905-0001','30','E2E-XCBI-101-0','TOKO','PM-E','CC X LISTERING MATA BIRU LG 12 8K ','1','1.150','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.150' WHERE kode_barang='E2E-XCBI-101-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XCBI-101-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XCBI-101-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 ='PM-E' AND kode_barang='E2E-XCBI-101-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-250905-0001','31','E2E-WGXE-342-0','TOKO','PM-E','CC X MODEL MATA CAT YT 12 ','1','1.460','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.460' WHERE kode_barang='E2E-WGXE-342-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-WGXE-342-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-WGXE-342-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.460,berat_hancur_asli=berat_hancur_asli+1.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-WGXE-342-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-250905-0001','32','E2E-UAAE-31','TOKO','PM-E','CC * MODEL MATA BM 14','1','1.320','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.320' WHERE kode_barang='E2E-UAAE-31';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-UAAE-31';
DELETE FROM tm_barang WHERE kode_barang='E2E-UAAE-31';
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 ='PM-E' AND kode_barang='E2E-UAAE-31' 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-250905-0001','33','A1E-XBXI-38-0','TOKO','PM-A','AT X MODEL SLEP UB 8K ','1','1.050','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.050' WHERE kode_barang='A1E-XBXI-38-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-XBXI-38-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-XBXI-38-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 ='PM-A' AND kode_barang='A1E-XBXI-38-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','34','E1D-YBBF-352-0','TOKO','PM-E','CC X MODEL SLEP LT 12 8K ','1','1.500','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.500' WHERE kode_barang='E1D-YBBF-352-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1D-YBBF-352-0';
DELETE FROM tm_barang WHERE kode_barang='E1D-YBBF-352-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 ='PM-E' AND kode_barang='E1D-YBBF-352-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-250905-0001','35','A1E-YDAX-466-0','TOKO','PM-A','AT X MODEL MATA VAR BW 8K ','1','0.570','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.570' WHERE kode_barang='A1E-YDAX-466-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-YDAX-466-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-YDAX-466-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.570,berat_hancur_asli=berat_hancur_asli+0.570, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-A' AND kode_barang='A1E-YDAX-466-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-250905-0001','36','H3J-ULXA-90-0','TOKO','PM-H','KL X SANTA BONEKA CAT VAR UB ','1','2.710','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.710' WHERE kode_barang='H3J-ULXA-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H3J-ULXA-90-0';
DELETE FROM tm_barang WHERE kode_barang='H3J-ULXA-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.710,berat_hancur_asli=berat_hancur_asli+2.710, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-H' AND kode_barang='H3J-ULXA-90-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','37','E2E-VCAA-84-0','TOKO','PM-E','CC X MODEL MATA OR 12 ','1','0.940','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.940' WHERE kode_barang='E2E-VCAA-84-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-VCAA-84-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-VCAA-84-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 ='PM-E' AND kode_barang='E2E-VCAA-84-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','38','E2E-UHAH-429-0','TOKO','PM-E','CC X MODEL MATA AY 15 ','1','2.080','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.080' WHERE kode_barang='E2E-UHAH-429-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-UHAH-429-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-UHAH-429-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.080,berat_hancur_asli=berat_hancur_asli+2.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-UHAH-429-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-250905-0001','39','E2E-XEBD-220-0','TOKO','PM-E','CC X MODEL MATA CM 16 8K ','1','1.050','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.050' WHERE kode_barang='E2E-XEBD-220-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XEBD-220-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XEBD-220-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 ='PM-E' AND kode_barang='E2E-XEBD-220-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-250905-0001','40','A1F-UBXC-3','TOKO','PM-A','AT HUGGIES ARESO SLEP AY','1','1.320','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.320' WHERE kode_barang='A1F-UBXC-3';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1F-UBXC-3';
DELETE FROM tm_barang WHERE kode_barang='A1F-UBXC-3';
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 ='PM-A' AND kode_barang='A1F-UBXC-3' 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-250905-0001','41','H3J-WBXD-312-0','TOKO','PM-H','KL X SANTA ANAK BONEKA CAT UB ','1','3.010','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.010' WHERE kode_barang='H3J-WBXD-312-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H3J-WBXD-312-0';
DELETE FROM tm_barang WHERE kode_barang='H3J-WBXD-312-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.010,berat_hancur_asli=berat_hancur_asli+3.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-H' AND kode_barang='H3J-WBXD-312-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-250905-0001','42','A1F-VJBE-262-0','TOKO','PM-A','AT ITALY SLEP VAR T40 ','1','0.520','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.520' WHERE kode_barang='A1F-VJBE-262-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1F-VJBE-262-0';
DELETE FROM tm_barang WHERE kode_barang='A1F-VJBE-262-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.520,berat_hancur_asli=berat_hancur_asli+0.520, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-A' AND kode_barang='A1F-VJBE-262-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-250905-0001','43','E2E-XDBF-41-0','TOKO','PM-E','CC X MODEL MATA VAR AY 11 8K ','1','1.200','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.200' WHERE kode_barang='E2E-XDBF-41-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XDBF-41-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XDBF-41-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 ='PM-E' AND kode_barang='E2E-XDBF-41-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','44','F2E-YCBD-18-0','TOKO','PM-F','GL X OVAL MATA UB 58 8K ','1','5.770','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='5.770' WHERE kode_barang='F2E-YCBD-18-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F2E-YCBD-18-0';
DELETE FROM tm_barang WHERE kode_barang='F2E-YCBD-18-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.770,berat_hancur_asli=berat_hancur_asli+5.770, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F2E-YCBD-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-250905-0001','45','E2E-XGXB-244-0','TOKO','PM-E','CC X MODEL MATA UB 14 8K ','1','1.350','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.350' WHERE kode_barang='E2E-XGXB-244-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XGXB-244-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XGXB-244-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-XGXB-244-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-250905-0001','46','E2E-VIBF-375-0','TOKO','PM-E','CC X LISTRING MATA RAINBOO LG 12 ','1','1.160','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.160' WHERE kode_barang='E2E-VIBF-375-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-VIBF-375-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-VIBF-375-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 ='PM-E' AND kode_barang='E2E-VIBF-375-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-250905-0001','47','E2D-YAXD-135-0','TOKO','PM-E','CC X MODEL MATA PINK KH 16 8K ','1','1.870','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.870' WHERE kode_barang='E2D-YAXD-135-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2D-YAXD-135-0';
DELETE FROM tm_barang WHERE kode_barang='E2D-YAXD-135-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.870,berat_hancur_asli=berat_hancur_asli+1.870, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2D-YAXD-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-250905-0001','48','F2E-VHAX-37-0','TOKO','PM-F','GL X OVAL MATA UB 56 ','1','3.360','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.360' WHERE kode_barang='F2E-VHAX-37-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F2E-VHAX-37-0';
DELETE FROM tm_barang WHERE kode_barang='F2E-VHAX-37-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.360,berat_hancur_asli=berat_hancur_asli+3.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F2E-VHAX-37-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','49','E2E-VKXG-176-0','TOKO','PM-E','CC X MODEL MATA LG 14 ','1','2.300','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.300' WHERE kode_barang='E2E-VKXG-176-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-VKXG-176-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-VKXG-176-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.300,berat_hancur_asli=berat_hancur_asli+2.300, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-VKXG-176-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-250905-0001','50','A1E-XFBE-75-0','TOKO','PM-A','AT X BANGKOK SLEP LG 8K ','1','1.610','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.610' WHERE kode_barang='A1E-XFBE-75-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-XFBE-75-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-XFBE-75-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 ='PM-A' AND kode_barang='A1E-XFBE-75-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-250905-0001','51','A1E-WLAC-185-0','TOKO','PM-A','AT X MODEL MATA VAR LG ','1','1.050','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.050' WHERE kode_barang='A1E-WLAC-185-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-WLAC-185-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-WLAC-185-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 ='PM-A' AND kode_barang='A1E-WLAC-185-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-250905-0001','52','E2E-XDBC-146-0','TOKO','PM-E','CC X MODEL MATA UB 14 8K ','1','1.360','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.360' WHERE kode_barang='E2E-XDBC-146-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XDBC-146-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XDBC-146-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.360,berat_hancur_asli=berat_hancur_asli+1.360, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-XDBC-146-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-250905-0001','53','E1D-YAXD-184-0','TOKO','PM-E','CC X MODEL SLEP LG 22 8K ','1','2.120','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.120' WHERE kode_barang='E1D-YAXD-184-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1D-YAXD-184-0';
DELETE FROM tm_barang WHERE kode_barang='E1D-YAXD-184-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.120,berat_hancur_asli=berat_hancur_asli+2.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1D-YAXD-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-250905-0001','54','H1E-YBXG-28-0','TOKO','PM-H','KL X FANCY MODEL KUPU MATA VAR UB 8K','1','3.700','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.700' WHERE kode_barang='H1E-YBXG-28-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H1E-YBXG-28-0';
DELETE FROM tm_barang WHERE kode_barang='H1E-YBXG-28-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.700,berat_hancur_asli=berat_hancur_asli+3.700, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-H' AND kode_barang='H1E-YBXG-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-250905-0001','55','E1E-XGXH-185-0','TOKO','PM-E','CC X MODEL SLEP VAR NJ 13 8K ','1','0.970','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.970' WHERE kode_barang='E1E-XGXH-185-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1E-XGXH-185-0';
DELETE FROM tm_barang WHERE kode_barang='E1E-XGXH-185-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 ='PM-E' AND kode_barang='E1E-XGXH-185-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-250905-0001','56','E2D-XKXD-217-0','TOKO','PM-E','CC X MODEL MATA KH 16 8K ','1','1.010','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.010' WHERE kode_barang='E2D-XKXD-217-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2D-XKXD-217-0';
DELETE FROM tm_barang WHERE kode_barang='E2D-XKXD-217-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 ='PM-E' AND kode_barang='E2D-XKXD-217-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-250905-0001','57','E2E-XGCX-12-0','TOKO','PM-E','CC X MODEL MATA CAT YT 14 8K ','1','2.010','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.010' WHERE kode_barang='E2E-XGCX-12-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XGCX-12-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XGCX-12-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.010,berat_hancur_asli=berat_hancur_asli+2.010, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-XGCX-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-250905-0001','58','E1D-YAAC-309-0','TOKO','PM-E','CC X MODEL SLEP BM 19 8K ','1','1.810','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.810' WHERE kode_barang='E1D-YAAC-309-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1D-YAAC-309-0';
DELETE FROM tm_barang WHERE kode_barang='E1D-YAAC-309-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.810,berat_hancur_asli=berat_hancur_asli+1.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1D-YAAC-309-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-250905-0001','59','E2E-XACA-47-0','TOKO','PM-E','CC X MODEL MATA AY 14 8K ','1','1.510','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.510' WHERE kode_barang='E2E-XACA-47-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-XACA-47-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-XACA-47-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.510,berat_hancur_asli=berat_hancur_asli+1.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-XACA-47-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-250905-0001','60','E2E-WLBC-297-0','TOKO','PM-E','CC X MODEL MATA KH 14 8K ','1','1.480','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.480' WHERE kode_barang='E2E-WLBC-297-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-WLBC-297-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-WLBC-297-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.480,berat_hancur_asli=berat_hancur_asli+1.480, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-WLBC-297-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-250905-0001','61','E1E-VEAX-433-0','TOKO','PM-E','CC X MODEL SLEP CM 14 ','1','1.080','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.080' WHERE kode_barang='E1E-VEAX-433-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1E-VEAX-433-0';
DELETE FROM tm_barang WHERE kode_barang='E1E-VEAX-433-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.080,berat_hancur_asli=berat_hancur_asli+1.080, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1E-VEAX-433-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-250905-0001','62','E1D-YEXA-343-0','TOKO','PM-E','CC X MODEL SLEP KH 14 8K ','1','1.450','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.450' WHERE kode_barang='E1D-YEXA-343-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1D-YEXA-343-0';
DELETE FROM tm_barang WHERE kode_barang='E1D-YEXA-343-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.450,berat_hancur_asli=berat_hancur_asli+1.450, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1D-YEXA-343-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-250905-0001','63','F3E-VDAC-746-0','TOKO','PM-F','GL X PAPRLINA MATA VAR YT ','1','3.070','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.070' WHERE kode_barang='F3E-VDAC-746-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3E-VDAC-746-0';
DELETE FROM tm_barang WHERE kode_barang='F3E-VDAC-746-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.070,berat_hancur_asli=berat_hancur_asli+3.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F3E-VDAC-746-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-250905-0001','64','F1F-UGAD-390-0','TOKO','PM-F','GL X OVAL TINJU ARESO UB 60 ','1','3.330','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.330' WHERE kode_barang='F1F-UGAD-390-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F1F-UGAD-390-0';
DELETE FROM tm_barang WHERE kode_barang='F1F-UGAD-390-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.330,berat_hancur_asli=berat_hancur_asli+3.330, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F1F-UGAD-390-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-250905-0001','65','B1F-UDAX-171-0','TOKO','PM-B','GW X MODEL TOUGE SARANGHAEYO MATA YT ','1','0.620','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.620' WHERE kode_barang='B1F-UDAX-171-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='B1F-UDAX-171-0';
DELETE FROM tm_barang WHERE kode_barang='B1F-UDAX-171-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.620,berat_hancur_asli=berat_hancur_asli+0.620, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-B' AND kode_barang='B1F-UDAX-171-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-250905-0001','66','E1E-UDAE-294-0','TOKO','PM-E','CC X MODEL SLEP HW 15 ','1','2.070','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.070' WHERE kode_barang='E1E-UDAE-294-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1E-UDAE-294-0';
DELETE FROM tm_barang WHERE kode_barang='E1E-UDAE-294-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.070,berat_hancur_asli=berat_hancur_asli+2.070, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1E-UDAE-294-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-250905-0001','67','F2E-XEXB-25-0','TOKO','PM-F','GL X OVAL MODEL MATA VAR CMIP D56 8K ','1','3.960','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.960' WHERE kode_barang='F2E-XEXB-25-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F2E-XEXB-25-0';
DELETE FROM tm_barang WHERE kode_barang='F2E-XEXB-25-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.960,berat_hancur_asli=berat_hancur_asli+3.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F2E-XEXB-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-250905-0001','68','F3F-UHXG-106-0','TOKO','PM-F','GL X TRIXIE MATA SERUT YT ','1','2.310','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.310' WHERE kode_barang='F3F-UHXG-106-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3F-UHXG-106-0';
DELETE FROM tm_barang WHERE kode_barang='F3F-UHXG-106-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.310,berat_hancur_asli=berat_hancur_asli+2.310, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F3F-UHXG-106-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-250905-0001','69','F2E-WIBE-27-0','TOKO','PM-F','GL X OVAL MATA UB 56 ','1','3.880','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.880' WHERE kode_barang='F2E-WIBE-27-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F2E-WIBE-27-0';
DELETE FROM tm_barang WHERE kode_barang='F2E-WIBE-27-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.880,berat_hancur_asli=berat_hancur_asli+3.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F2E-WIBE-27-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','70','A1E-WDAF-341-0','TOKO','PM-A','AT ANAK MODEL BONEKA CAT UB ','1','1.020','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.020' WHERE kode_barang='A1E-WDAF-341-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1E-WDAF-341-0';
DELETE FROM tm_barang WHERE kode_barang='A1E-WDAF-341-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 ='PM-A' AND kode_barang='A1E-WDAF-341-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-250905-0001','71','E1F-UGBB-171-0','TOKO','PM-E','CC XX MODEL KUPU KARAWANG SLEP AY 10 ','1','1.350','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.350' WHERE kode_barang='E1F-UGBB-171-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1F-UGBB-171-0';
DELETE FROM tm_barang WHERE kode_barang='E1F-UGBB-171-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1F-UGBB-171-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-250905-0001','72','F2E-UGAD-385-0','TOKO','PM-F','GL X OVAL MATA HW D56 ','1','4.180','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='4.180' WHERE kode_barang='F2E-UGAD-385-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F2E-UGAD-385-0';
DELETE FROM tm_barang WHERE kode_barang='F2E-UGAD-385-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.180,berat_hancur_asli=berat_hancur_asli+4.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F2E-UGAD-385-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-250905-0001','73','E2E-UGBD-167-0','TOKO','PM-E','CC X MODEL MATA HW 13 ','1','1.830','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.830' WHERE kode_barang='E2E-UGBD-167-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-UGBD-167-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-UGBD-167-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.830,berat_hancur_asli=berat_hancur_asli+1.830, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-UGBD-167-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-250905-0001','74','E2E-WEAA-149-0','TOKO','PM-E','CC X WEDDING MATA CM 22','1','1.880','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.880' WHERE kode_barang='E2E-WEAA-149-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-WEAA-149-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-WEAA-149-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.880,berat_hancur_asli=berat_hancur_asli+1.880, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E2E-WEAA-149-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','75','E1E-VIAB-151-0','TOKO','PM-E','CC X BANGKOK SLEPDG 10 ','1','0.610','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.610' WHERE kode_barang='E1E-VIAB-151-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1E-VIAB-151-0';
DELETE FROM tm_barang WHERE kode_barang='E1E-VIAB-151-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.610,berat_hancur_asli=berat_hancur_asli+0.610, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1E-VIAB-151-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-250905-0001','76','E2E-UKBC-230-0','TOKO','PM-E','CC X METRO MATA LG 22 ','1','1.010','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.010' WHERE kode_barang='E2E-UKBC-230-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2E-UKBC-230-0';
DELETE FROM tm_barang WHERE kode_barang='E2E-UKBC-230-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 ='PM-E' AND kode_barang='E2E-UKBC-230-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-250905-0001','77','F1E-WKAF-90-0','TOKO','PM-F','GL X BANGKOK C SLEP TD 56 ','1','3.920','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.920' WHERE kode_barang='F1E-WKAF-90-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F1E-WKAF-90-0';
DELETE FROM tm_barang WHERE kode_barang='F1E-WKAF-90-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.920,berat_hancur_asli=berat_hancur_asli+3.920, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F1E-WKAF-90-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','78','B1E-WLBA-221-0','TOKO','PM-B','GW TUSUK MODEL MATA VAR CM PE 8K ','1','1.300','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.300' WHERE kode_barang='B1E-WLBA-221-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='B1E-WLBA-221-0';
DELETE FROM tm_barang WHERE kode_barang='B1E-WLBA-221-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 ='PM-B' AND kode_barang='B1E-WLBA-221-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-250905-0001','79','A1F-XFBH-123-0','TOKO','PM-A','AT X GYPSY ANAK MT VAR UB 8K ','1','0.850','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.850' WHERE kode_barang='A1F-XFBH-123-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1F-XFBH-123-0';
DELETE FROM tm_barang WHERE kode_barang='A1F-XFBH-123-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.850,berat_hancur_asli=berat_hancur_asli+0.850, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-A' AND kode_barang='A1F-XFBH-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-250905-0001','80','E1E-TKAD-7','TOKO','PM-E','CC MODEL LINEA SLEP UB 17','1','1.810','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.810' WHERE kode_barang='E1E-TKAD-7';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1E-TKAD-7';
DELETE FROM tm_barang WHERE kode_barang='E1E-TKAD-7';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.810,berat_hancur_asli=berat_hancur_asli+1.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-E' AND kode_barang='E1E-TKAD-7' 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-250905-0001','81','A0TA-VBAI-126-T','TOKO','PT-A','AT X GYPSY MRICAN DW ','1','0.500','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.500' WHERE kode_barang='A0TA-VBAI-126-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A0TA-VBAI-126-T';
DELETE FROM tm_barang WHERE kode_barang='A0TA-VBAI-126-T';
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 ='PT-A' AND kode_barang='A0TA-VBAI-126-T' 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-250905-0001','82','B1TF-WLAB-15-T','TOKO','PT-B','GW X TOUGE MODEL MATA HK ','1','0.550','RUSAK');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.550' WHERE kode_barang='B1TF-WLAB-15-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='B1TF-WLAB-15-T';
DELETE FROM tm_barang WHERE kode_barang='B1TF-WLAB-15-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.550,berat_hancur_asli=berat_hancur_asli+0.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-B' AND kode_barang='B1TF-WLAB-15-T' 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-250905-0001','83','F1E-XLXE-180-0','TOKO','PM-F','GL X SHOGUN SLEP UB 56 8K ','1','5.050','RETUR');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='5.050' WHERE kode_barang='F1E-XLXE-180-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F1E-XLXE-180-0';
DELETE FROM tm_barang WHERE kode_barang='F1E-XLXE-180-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.050,berat_hancur_asli=berat_hancur_asli+5.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-F' AND kode_barang='F1E-XLXE-180-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-250905-0001','84','F1TE-YHBG-15-T','TOKO','PT-F','GL OVAL MODEL DAUN VAR LT D56 17K ','1','3.460','RETUR');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.460' WHERE kode_barang='F1TE-YHBG-15-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F1TE-YHBG-15-T';
DELETE FROM tm_barang WHERE kode_barang='F1TE-YHBG-15-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.460,berat_hancur_asli=berat_hancur_asli+3.460, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-F' AND kode_barang='F1TE-YHBG-15-T' 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-250905-0001','85','H8TG-UEBX-75-T','TOKO','PT-H','KL X SANTA ANAK VAR KH SI 36CM ','1','2.680','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.680' WHERE kode_barang='H8TG-UEBX-75-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H8TG-UEBX-75-T';
DELETE FROM tm_barang WHERE kode_barang='H8TG-UEBX-75-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.680,berat_hancur_asli=berat_hancur_asli+2.680, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-H' AND kode_barang='H8TG-UEBX-75-T' 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-250905-0001','86','A1TE-VFBC-189-T','TOKO','PT-A','AT X MODEL SLEP UB ','1','1.500','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.500' WHERE kode_barang='A1TE-VFBC-189-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1TE-VFBC-189-T';
DELETE FROM tm_barang WHERE kode_barang='A1TE-VFBC-189-T';
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 ='PT-A' AND kode_barang='A1TE-VFBC-189-T' 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-250905-0001','87','H2TG-VFBC-184-T','TOKO','PT-H','KL X SANTA BONEKA ANAK CAT UB ','1','3.150','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='3.150' WHERE kode_barang='H2TG-VFBC-184-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H2TG-VFBC-184-T';
DELETE FROM tm_barang WHERE kode_barang='H2TG-VFBC-184-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+3.150,berat_hancur_asli=berat_hancur_asli+3.150, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-H' AND kode_barang='H2TG-VFBC-184-T' 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-250905-0001','88','F3TE-XBBF-64-T','TOKO','PT-F','GL X TRIXIE MODEL SLEP VAR MT 17K ','1','2.960','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.960' WHERE kode_barang='F3TE-XBBF-64-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3TE-XBBF-64-T';
DELETE FROM tm_barang WHERE kode_barang='F3TE-XBBF-64-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.960,berat_hancur_asli=berat_hancur_asli+2.960, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-F' AND kode_barang='F3TE-XBBF-64-T' 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-250905-0001','89','F3TE-VABX-126-T','TOKO','PT-F','GL FANCY BONEKA ANAK CAT UB ','1','2.390','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.390' WHERE kode_barang='F3TE-VABX-126-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3TE-VABX-126-T';
DELETE FROM tm_barang WHERE kode_barang='F3TE-VABX-126-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.390,berat_hancur_asli=berat_hancur_asli+2.390, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-F' AND kode_barang='F3TE-VABX-126-T' 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-250905-0001','90','H2TG-WEAC-60-T','TOKO','PT-H','KL X MILANO MODEL MATA VAR UB ','1','5.180','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='5.180' WHERE kode_barang='H2TG-WEAC-60-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H2TG-WEAC-60-T';
DELETE FROM tm_barang WHERE kode_barang='H2TG-WEAC-60-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+5.180,berat_hancur_asli=berat_hancur_asli+5.180, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-H' AND kode_barang='H2TG-WEAC-60-T' 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-250905-0001','91','E2TE-WBXH-109-T','TOKO','PT-E','CC XX METRO MODEL MATA LG 19 ','1','1.730','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.730' WHERE kode_barang='E2TE-WBXH-109-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2TE-WBXH-109-T';
DELETE FROM tm_barang WHERE kode_barang='E2TE-WBXH-109-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.730,berat_hancur_asli=berat_hancur_asli+1.730, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-E' AND kode_barang='E2TE-WBXH-109-T' 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-250905-0001','92','E2TD-XJAB-146-T','TOKO','PT-E','CC X MODEL MATA VAR UB 11 17K ','1','1.760','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.760' WHERE kode_barang='E2TD-XJAB-146-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2TD-XJAB-146-T';
DELETE FROM tm_barang WHERE kode_barang='E2TD-XJAB-146-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.760,berat_hancur_asli=berat_hancur_asli+1.760, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-E' AND kode_barang='E2TD-XJAB-146-T' 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-250905-0001','93','E2TE-WHAB-125-T','TOKO','PT-E','CC X MODEL CD MATA VAR YT 16 ','1','2.050','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.050' WHERE kode_barang='E2TE-WHAB-125-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2TE-WHAB-125-T';
DELETE FROM tm_barang WHERE kode_barang='E2TE-WHAB-125-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.050,berat_hancur_asli=berat_hancur_asli+2.050, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-E' AND kode_barang='E2TE-WHAB-125-T' 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-250905-0001','94','E2TE-UDXG-93-T','TOKO','PT-E','CC X MODEL MATA 13 ','1','1.350','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.350' WHERE kode_barang='E2TE-UDXG-93-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2TE-UDXG-93-T';
DELETE FROM tm_barang WHERE kode_barang='E2TE-UDXG-93-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.350,berat_hancur_asli=berat_hancur_asli+1.350, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-E' AND kode_barang='E2TE-UDXG-93-T' 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-250905-0001','95','E8TF-WCXB-30-T','TOKO','PT-E','CC X MODEL SLEP KH SI 12 ','1','2.120','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.120' WHERE kode_barang='E8TF-WCXB-30-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E8TF-WCXB-30-T';
DELETE FROM tm_barang WHERE kode_barang='E8TF-WCXB-30-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.120,berat_hancur_asli=berat_hancur_asli+2.120, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-E' AND kode_barang='E8TF-WCXB-30-T' 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-250905-0001','96','E2TE-UDAF-76-T','TOKO','PT-E','CC MODEL MATA UB 14 ','1','1.550','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.550' WHERE kode_barang='E2TE-UDAF-76-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2TE-UDAF-76-T';
DELETE FROM tm_barang WHERE kode_barang='E2TE-UDAF-76-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.550,berat_hancur_asli=berat_hancur_asli+1.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-E' AND kode_barang='E2TE-UDAF-76-T' 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-250905-0001','97','A1TE-WEXH-34-T','TOKO','PT-A','AT X MODEL MATA LG ','1','1.270','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.270' WHERE kode_barang='A1TE-WEXH-34-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1TE-WEXH-34-T';
DELETE FROM tm_barang WHERE kode_barang='A1TE-WEXH-34-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.270,berat_hancur_asli=berat_hancur_asli+1.270, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-A' AND kode_barang='A1TE-WEXH-34-T' 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-250905-0001','98','A1TE-UFAF-46-T','TOKO','PT-A','AT X BONEKA ANAK CAT MATA LG ','1','1.200','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.200' WHERE kode_barang='A1TE-UFAF-46-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1TE-UFAF-46-T';
DELETE FROM tm_barang WHERE kode_barang='A1TE-UFAF-46-T';
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 ='PT-A' AND kode_barang='A1TE-UFAF-46-T' 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-250905-0001','99','A1TE-WFBX-5-T','TOKO','PT-A','AT X KLIP BANGKOK SLEP LG ','1','0.980','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.980' WHERE kode_barang='A1TE-WFBX-5-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1TE-WFBX-5-T';
DELETE FROM tm_barang WHERE kode_barang='A1TE-WFBX-5-T';
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 ='PT-A' AND kode_barang='A1TE-WFBX-5-T' 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-250905-0001','100','F3TE-WDAB-68-T','TOKO','PT-F','GL FANCY ANAK BONEKA CAT VAR UB ','1','2.940','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.940' WHERE kode_barang='F3TE-WDAB-68-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3TE-WDAB-68-T';
DELETE FROM tm_barang WHERE kode_barang='F3TE-WDAB-68-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.940,berat_hancur_asli=berat_hancur_asli+2.940, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-F' AND kode_barang='F3TE-WDAB-68-T' 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-250905-0001','101','E1TE-WEXD-65-T','TOKO','PT-E','CC X MODEL SLEP KH 16 ','1','1.960','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.960' WHERE kode_barang='E1TE-WEXD-65-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E1TE-WEXD-65-T';
DELETE FROM tm_barang WHERE kode_barang='E1TE-WEXD-65-T';
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 ='PT-E' AND kode_barang='E1TE-WEXD-65-T' 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-250905-0001','102','F3TE-WJBE-58-T','TOKO','PT-F','GL X KREPYAK MODEL CD VAR CM ','1','2.780','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.780' WHERE kode_barang='F3TE-WJBE-58-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3TE-WJBE-58-T';
DELETE FROM tm_barang WHERE kode_barang='F3TE-WJBE-58-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.780,berat_hancur_asli=berat_hancur_asli+2.780, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-F' AND kode_barang='F3TE-WJBE-58-T' 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-250905-0001','103','A1TE-UEXF-99-T','TOKO','PT-A','AT BONEKA ANAK CAT HW ','1','1.150','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.150' WHERE kode_barang='A1TE-UEXF-99-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1TE-UEXF-99-T';
DELETE FROM tm_barang WHERE kode_barang='A1TE-UEXF-99-T';
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 ='PT-A' AND kode_barang='A1TE-UEXF-99-T' 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-250905-0001','104','H2TF-VKBB-149-T','TOKO','PT-H','KL X TRIXIE HATI HURUF VAR HW N ','1','4.870','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='4.870' WHERE kode_barang='H2TF-VKBB-149-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='H2TF-VKBB-149-T';
DELETE FROM tm_barang WHERE kode_barang='H2TF-VKBB-149-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+4.870,berat_hancur_asli=berat_hancur_asli+4.870, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-H' AND kode_barang='H2TF-VKBB-149-T' 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-250905-0001','105','F3TF-UDXI-62-T','TOKO','PT-F','GL X ITALY DOUBLE VAR UB ','1','2.100','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.100' WHERE kode_barang='F3TF-UDXI-62-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3TF-UDXI-62-T';
DELETE FROM tm_barang WHERE kode_barang='F3TF-UDXI-62-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.100,berat_hancur_asli=berat_hancur_asli+2.100, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-F' AND kode_barang='F3TF-UDXI-62-T' 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-250905-0001','106','F3TE-XBBF-63-T','TOKO','PT-F','GL X KREPYAK MODEL CD VAR CM 17K ','1','2.810','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='2.810' WHERE kode_barang='F3TE-XBBF-63-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='F3TE-XBBF-63-T';
DELETE FROM tm_barang WHERE kode_barang='F3TE-XBBF-63-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+2.810,berat_hancur_asli=berat_hancur_asli+2.810, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-F' AND kode_barang='F3TE-XBBF-63-T' 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-250905-0001','107','E2TE-VJAX-89-T','TOKO','PT-E','CC X PIPA MODEL MATA HK 14 ','1','0.510','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.510' WHERE kode_barang='E2TE-VJAX-89-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='E2TE-VJAX-89-T';
DELETE FROM tm_barang WHERE kode_barang='E2TE-VJAX-89-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.510,berat_hancur_asli=berat_hancur_asli+0.510, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-E' AND kode_barang='E2TE-VJAX-89-T' 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-250905-0001','108','A1TE-WKXI-47-T','TOKO','PT-A','AT X KLIP MODEL MATA RAINBOW UB ','1','1.250','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='1.250' WHERE kode_barang='A1TE-WKXI-47-T';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='A1TE-WKXI-47-T';
DELETE FROM tm_barang WHERE kode_barang='A1TE-WKXI-47-T';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+1.250,berat_hancur_asli=berat_hancur_asli+1.250, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PT-A' AND kode_barang='A1TE-WKXI-47-T' 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-250905-0001','109','D1F-WJAG-26-0','TOKO','PM-D','LT X MODEL MATA LG ','1','0.500','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.500' WHERE kode_barang='D1F-WJAG-26-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='D1F-WJAG-26-0';
DELETE FROM tm_barang WHERE kode_barang='D1F-WJAG-26-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 ='PM-D' AND kode_barang='D1F-WJAG-26-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','110','D2E-YHAI-31-0','TOKO','PM-D','LT X MODEL MATA LG 8K ','1','0.500','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.500' WHERE kode_barang='D2E-YHAI-31-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='D2E-YHAI-31-0';
DELETE FROM tm_barang WHERE kode_barang='D2E-YHAI-31-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 ='PM-D' AND kode_barang='D2E-YHAI-31-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','111','D2F-XJXA-140-0','TOKO','PM-D','LT X MODEL HURUF MATA LG J 8K ','1','0.550','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.550' WHERE kode_barang='D2F-XJXA-140-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='D2F-XJXA-140-0';
DELETE FROM tm_barang WHERE kode_barang='D2F-XJXA-140-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.550,berat_hancur_asli=berat_hancur_asli+0.550, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-D' AND kode_barang='D2F-XJXA-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-250905-0001','112','D2E-YHAI-32-0','TOKO','PM-D','LT X MODEL MATA LG 8K ','1','0.580','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.580' WHERE kode_barang='D2E-YHAI-32-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='D2E-YHAI-32-0';
DELETE FROM tm_barang WHERE kode_barang='D2E-YHAI-32-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.580,berat_hancur_asli=berat_hancur_asli+0.580, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-D' AND kode_barang='D2E-YHAI-32-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','113','D2E-YHAD-223-0','TOKO','PM-D','LT X SOLITAIRE MATA AY 8K ','1','0.780','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.780' WHERE kode_barang='D2E-YHAD-223-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='D2E-YHAD-223-0';
DELETE FROM tm_barang WHERE kode_barang='D2E-YHAD-223-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 ='PM-D' AND kode_barang='D2E-YHAD-223-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-250905-0001','114','D2E-XDXI-102-0','TOKO','PM-D','LT X MODEL MATA CM 8K','1','0.910','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.910' WHERE kode_barang='D2E-XDXI-102-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='D2E-XDXI-102-0';
DELETE FROM tm_barang WHERE kode_barang='D2E-XDXI-102-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.910,berat_hancur_asli=berat_hancur_asli+0.910, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-D' AND kode_barang='D2E-XDXI-102-0' AND stock_akhir > 0;
INSERT INTO tt_waste_detail (no_waste,no_urut,kode_barang,kode_lokasi_gudang,kode_lokasi_toko,nama_barang,qty_waste,berat,kondisi_barang) VALUES ('BS-250905-0001','115','D2E-YGAH-54-0','TOKO','PM-D','LT X MODEL MATA LG 8K ','1','0.470','CUCI ULANG');
UPDATE tm_barang SET deleted_by ='irgosa', deleted_date ='2025-09-05 10:54:06',status_delete='0.470' WHERE kode_barang='D2E-YGAH-54-0';
INSERT INTO tm_barang_deleted SELECT * FROM tm_barang WHERE kode_barang='D2E-YGAH-54-0';
DELETE FROM tm_barang WHERE kode_barang='D2E-YGAH-54-0';
UPDATE tt_barang_saldo SET stock_hancur=stock_hancur+1, berat_hancur=berat_hancur+0.470,berat_hancur_asli=berat_hancur_asli+0.470, stock_akhir=0, berat_akhir=0,berat_akhir_asli=0 WHERE kode_lokasi_gudang = 'TOKO' AND kode_lokasi_toko ='PM-D' AND kode_barang='D2E-YGAH-54-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-250905-0001','2025-09-05','irgosa','2025-09-05','10:54:06','irgosa','2025-09-05 10:54:06');
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-00016910','X-00016910','GL XXX CAPELLA SLEP YT 8K','GR','---','F3E','BELI','BELI001','762000','2025-09-05','1.000','1','kasir','2025-09-05 11:59:37');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00016910','X-00016910');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0005','F325220904221','FIT','1','BELI','BELI001','F3E', 'X-00016910', 'GL XXX CAPELLA SLEP YT 8K','1.000','1.000','100.00','820000','762000','762000','882000','1','762000','762000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.000',berat_beli_asli=berat_beli_asli+'1.000',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.000',berat_akhir_asli=berat_akhir_asli+'1.000',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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) VALUES ('FB-250905-0005','2025-09-05','2025-09-05','11:59:36','FIT','---','1.000','762000','762000','762000','762000','762000','kasir','2025-09-05 11:59:37','FB-250905-0005');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0005','NINING','PLOSOREJO KISMANTORO','','','','kasir','2025-09-05 11:59:37');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0008','K','2025-09-05','11:59:36','kasir','PEMBELIAN UMUM','FB-250905-0005','12170000','762000','11408000');
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,status_otorisasi,harga_skrg) VALUES ('F325050129351','kasir','1',' MEB1 X CM ','TOKO','PM-B','B1E-WKAD-316-0','GW X MODEL MATA CM PE ','','0.730','1','100.00','644000','0','0','15000','645000','0','0','0','645000','SIN','00264295','B1E','0','0','-','0','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='B1E-WKAD-316-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.730',berat_jual_asli=berat_jual_asli+'0.730',stock_jual='1',berat_akhir=berat_akhir-'0.730',berat_akhir_asli=berat_akhir_asli-'0.730',stock_akhir='0' WHERE tanggal='2025-09-05' AND kode_barang='B1E-WKAD-316-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-B' 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 ('F325050129351','2025-09-05','0.730','2025-09-05','13:29:36','PLG0024817','645000','645000','0','645000','645000','kasir','2025-09-05 13:29:35','F32505012935');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-05','F325050129351','2025-09-05','13:29:36','SIN','645000','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-250905-0009','D','2025-09-05','13:29:36','kasir','PENJUALAN','F325050129351','11408000','645000','12053000');
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,status_otorisasi,harga_skrg) VALUES ('F325050139461','kasir','1',' MEF3E UB ','TOKO','PM-F','F3E-YDBF-111-0','GL CAPELLA SLEP UB 8K ','','1.900','1','100.00','1676000','0','0','15000','1675000','0','0','0','1675000','FIT','00351060','F3E','0','0','-','1','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='F3E-YDBF-111-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.900',berat_jual_asli=berat_jual_asli+'1.900',stock_jual='1',berat_akhir=berat_akhir-'1.900',berat_akhir_asli=berat_akhir_asli-'1.900',stock_akhir='0' WHERE tanggal='2025-09-05' AND kode_barang='F3E-YDBF-111-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-F' 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 ('F325050139461','2025-09-05','1.900','2025-09-05','13:39:47','PLG0024818','1675000','1675000','0','1675000','1675000','kasir','2025-09-05 13:39:46','F32505013946');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-05','F325050139461','2025-09-05','13:39:47','FIT','1675000','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-250905-0010','D','2025-09-05','13:39:47','kasir','PENJUALAN','F325050139461','12053000','1675000','13728000');
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,status_otorisasi,harga_skrg) VALUES ('F325050202181','kasir','1',' MDE2X 10K ','TOKO','PM-E','E2D-YGAF-256-0','CC X WEDDING MATA CM 14 8K ','','1.600','1','100.00','1384000','0','0','15000','1385000','0','10000','0','1395000','SIN','00361082','E2D','0','0','-','0','865000');
UPDATE tm_barang SET tgl_last_jual='2025-09-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-YGAF-256-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2025-09-05' AND kode_barang='E2D-YGAF-256-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F325050202181','2025-09-05','1.600','2025-09-05','14:02:18','PLG0024819','1385000','1385000','10000','1395000','1395000','kasir','2025-09-05 14:02:18','F32505020218');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-05','F325050202181','2025-09-05','14:02:18','SIN','1395000','10000');
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-250905-0011','D','2025-09-05','14:02:18','kasir','PENJUALAN','F325050202181','13728000','1395000','15123000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1395000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325050202181' 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,status_otorisasi,harga_skrg) VALUES ('F325050202182','kasir',' 1',' MDE2 10K C','TOKO','PM-E','E2D-XLXC-58-0','CC WEDDING MATA CM 10 8K ','','1.600','1','100.00','1384000','0','0','15000','1385000','0','10000','0','1395000','SIN','00328357','E2D','0','0','-','0','865000');
UPDATE tm_barang SET tgl_last_jual='2025-09-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E2D-XLXC-58-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'1.600',berat_jual_asli=berat_jual_asli+'1.600',stock_jual='1',berat_akhir=berat_akhir-'1.600',berat_akhir_asli=berat_akhir_asli-'1.600',stock_akhir='0' WHERE tanggal='2025-09-05' AND kode_barang='E2D-XLXC-58-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F325050202182','2025-09-05','1.600','2025-09-05','14:02:18','PLG0024820','1385000','1385000','10000','1395000','1395000','kasir','2025-09-05 14:02:18','F32505020218');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-05','F325050202182','2025-09-05','14:02:18','SIN','1395000','10000');
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-250905-0012','D','2025-09-05','14:02:18','kasir','PENJUALAN','F325050202182','15123000','1395000','16518000','OPEN');
UPDATE tt_jual_head SET dibayar_rp='1395000',debet_rp='0',card_rp='0',card_fee_rp ='0',transfer_rp='0' WHERE no_faktur_jual='F325050202182' LIMIT 1;
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-00016911','X-00016911','AT COR 8K','GR','---','A1E','BELI','BELI001','315000','2025-09-05','0.700','1','kasir','2025-09-05 14:19:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00016911','X-00016911');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0006','F323111115061','FIT','1','BELI','BELI001','A1E', 'X-00016911', 'AT COR 8K','1.100','0.700','100.00','495000','315000','450000','882000','1','315000','315000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.700',berat_beli_asli=berat_beli_asli+'0.700',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.700',berat_akhir_asli=berat_akhir_asli+'0.700',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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) VALUES ('FB-250905-0006','2025-09-05','2025-09-05','14:19:51','FIT','---','0.700','315000','315000','315000','315000','315000','kasir','2025-09-05 14:19:51','FB-250905-0006');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0006','EKA','NAWANGAN','','','','kasir','2025-09-05 14:19:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0013','K','2025-09-05','14:19:51','kasir','PEMBELIAN UMUM','FB-250905-0006','16518000','315000','16203000');
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-00016912','X-00016912','CC COR M 8K','GR','---','E2E','BELI','BELI001','505000','2025-09-05','0.980','1','kasir','2025-09-05 14:20:51');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00016912','X-00016912');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0007','F323110141201','SIN','1','BELI','BELI001','E2E', 'X-00016912', 'CC COR M 8K','0.980','0.980','100.00','440000','505000','515306','882000','1','505000','505000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'0.980',berat_beli_asli=berat_beli_asli+'0.980',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'0.980',berat_akhir_asli=berat_akhir_asli+'0.980',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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) VALUES ('FB-250905-0007','2025-09-05','2025-09-05','14:20:51','SIN','---','0.980','505000','505000','505000','505000','505000','kasir','2025-09-05 14:20:51','FB-250905-0007');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0007','RISKA','BULUKERTO','','','','kasir','2025-09-05 14:20:51');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0014','K','2025-09-05','14:20:51','kasir','PEMBELIAN UMUM','FB-250905-0007','16203000','505000','15698000');
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-00016913','X-00016913','CC X MODEL MATA UB 14','GR','---','E2E','BELI','BELI001','787000','2025-09-05','1.400','1','kasir','2025-09-05 14:21:40');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2E','X-00016913','X-00016913');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0008','F324310239561','FIT','1','BELI','BELI001','E2E', 'X-00016913', 'CC X MODEL MATA UB 14','1.400','1.400','100.00','838000','787000','562143','882000','1','787000','787000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.400',berat_beli_asli=berat_beli_asli+'1.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.400',berat_akhir_asli=berat_akhir_asli+'1.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2E' 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) VALUES ('FB-250905-0008','2025-09-05','2025-09-05','14:21:39','FIT','---','1.400','787000','787000','787000','787000','787000','kasir','2025-09-05 14:21:40','FB-250905-0008');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0008','CHOOMSIATUN','SOCO SLOGOHIMO','','','','kasir','2025-09-05 14:21:40');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0015','K','2025-09-05','14:21:39','kasir','PEMBELIAN UMUM','FB-250905-0008','15698000','787000','14911000');
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-00016914','X-00016914','GL SIEM MODEL HATI VAR LT 8K','GR','---','F3E','BELI','BELI001','862000','2025-09-05','1.230','1','kasir','2025-09-05 14:22:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3E','X-00016914','X-00016914');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0009','F325191206491','FIT','1','BELI','BELI001','F3E', 'X-00016914', 'GL SIEM MODEL HATI VAR LT 8K','1.230','1.230','100.00','1015000','862000','700813','882000','1','862000','862000','RUSAK');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.230',berat_beli_asli=berat_beli_asli+'1.230',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.230',berat_akhir_asli=berat_akhir_asli+'1.230',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3E' 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) VALUES ('FB-250905-0009','2025-09-05','2025-09-05','14:22:05','FIT','---','1.230','862000','862000','862000','862000','862000','kasir','2025-09-05 14:22:06','FB-250905-0009');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0009','ELSA AMALIA','PAGERSARI','','','081326504695','kasir','2025-09-05 14:22:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0016','K','2025-09-05','14:22:05','kasir','PEMBELIAN UMUM','FB-250905-0009','14911000','862000','14049000');
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-00016915','X-00016915','CC X MODEL SLEP LG 12 8K','GR','---','E1D','BELI','BELI001','867000','2025-09-05','1.160','1','kasir','2025-09-05 14:22:30');
DELETE FROM tp_barang WHERE kode_dept = 'X-E1D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E1D','X-00016915','X-00016915');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0010','F325070303532','FIT','1','BELI','BELI001','E1D', 'X-00016915', 'CC X MODEL SLEP LG 12 8K','1.160','1.160','100.00','933000','867000','747414','865000','1','867000','867000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.160',berat_beli_asli=berat_beli_asli+'1.160',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.160',berat_akhir_asli=berat_akhir_asli+'1.160',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E1D' 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) VALUES ('FB-250905-0010','2025-09-05','2025-09-05','14:22:29','FIT','---','1.160','867000','867000','867000','867000','867000','kasir','2025-09-05 14:22:30','FB-250905-0010');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0010','MELIANA','KLAMPISAN KISMANTORO','','','','kasir','2025-09-05 14:22:30');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0017','K','2025-09-05','14:22:29','kasir','PEMBELIAN UMUM','FB-250905-0010','14049000','867000','13182000');
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-00016916','X-00016916','GL X FANCY POLOS HW','GR','---','F3TE','BELI','BELI001','1880000','2025-09-05','1.360','1','kasir','2025-09-05 14:22:52');
DELETE FROM tp_barang WHERE kode_dept = 'X-F3TE';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-F3TE','X-00016916','X-00016916');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0011','F325061058311','FIT','1','BELI','BELI001','F3TE', 'X-00016916', 'GL X FANCY POLOS HW','1.360','1.360','100.00','2000000','1880000','1382353','1550000','1','1880000','1880000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.360',berat_beli_asli=berat_beli_asli+'1.360',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.360',berat_akhir_asli=berat_akhir_asli+'1.360',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='F3TE' 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) VALUES ('FB-250905-0011','2025-09-05','2025-09-05','14:22:51','FIT','---','1.360','1880000','1880000','1880000','1880000','1880000','kasir','2025-09-05 14:22:52','FB-250905-0011');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0011','MELIANA','KLAMPISAN KISMANTORO','','','','kasir','2025-09-05 14:22:52');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0018','K','2025-09-05','14:22:51','kasir','PEMBELIAN UMUM','FB-250905-0011','13182000','1880000','11302000');
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-00016917','X-00016917','KL KADAR 8K','GR','---','H1F','BELI','BELI001','1265000','2025-09-05','2.410','1','kasir','2025-09-05 14:24:16');
DELETE FROM tp_barang WHERE kode_dept = 'X-H1F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H1F','X-00016917','X-00016917');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0012','F323060139332','AAT','1','BELI','BELI001','H1F', 'X-00016917', 'KL KADAR 8K','2.410','2.410','100.00','1200000','1265000','524896','899000','1','1265000','1265000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'2.410',berat_beli_asli=berat_beli_asli+'2.410',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'2.410',berat_akhir_asli=berat_akhir_asli+'2.410',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H1F' 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) VALUES ('FB-250905-0012','2025-09-05','2025-09-05','14:24:16','AAT','---','2.410','1265000','1265000','1265000','1265000','1265000','kasir','2025-09-05 14:24:16','FB-250905-0012');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0012','SEPTYA','SUKOMANGU','','','','kasir','2025-09-05 14:24:16');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0019','K','2025-09-05','14:24:16','kasir','PEMBELIAN UMUM','FB-250905-0012','11302000','1265000','10037000');
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-00016918','X-00016918','LT COR M 8K','GR','---','D2F','BELI','BELI001','690000','2025-09-05','1.400','1','kasir','2025-09-05 14:29:07');
DELETE FROM tp_barang WHERE kode_dept = 'X-D2F';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-D2F','X-00016918','X-00016918');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0013','F321201203571','AAT','1','BELI','BELI001','D2F', 'X-00016918', 'LT COR M 8K','1.400','1.400','100.00','581000','690000','492857','899000','1','690000','690000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.400',berat_beli_asli=berat_beli_asli+'1.400',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.400',berat_akhir_asli=berat_akhir_asli+'1.400',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='D2F' 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) VALUES ('FB-250905-0013','2025-09-05','2025-09-05','14:29:06','AAT','---','1.400','690000','690000','690000','690000','690000','kasir','2025-09-05 14:29:07','FB-250905-0013');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0013','SEPTIA','SUKOMANGU','','','','kasir','2025-09-05 14:29:07');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0020','K','2025-09-05','14:29:06','kasir','PEMBELIAN UMUM','FB-250905-0013','10037000','690000','9347000');
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-00016919','X-00016919','KL X SANTA KH 42CM','GR','---','H2I','BELI','BELI001','2300000','2025-09-05','3.880','1','kasir','2025-09-05 14:29:50');
DELETE FROM tp_barang WHERE kode_dept = 'X-H2I';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-H2I','X-00016919','X-00016919');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0014','F322241011051','AAT','1','BELI','BELI001','H2I', 'X-00016919', 'KL X SANTA KH 42CM','3.930','3.880','100.00','1860000','2300000','592784','950000','1','2300000','2300000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'3.880',berat_beli_asli=berat_beli_asli+'3.880',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'3.880',berat_akhir_asli=berat_akhir_asli+'3.880',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='H2I' 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) VALUES ('FB-250905-0014','2025-09-05','2025-09-05','14:29:49','AAT','---','3.880','2300000','2300000','2300000','2300000','2300000','kasir','2025-09-05 14:29:50','FB-250905-0014');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0014','SEPTIA','SUKOMANGU','','','','kasir','2025-09-05 14:29:50');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0021','K','2025-09-05','14:29:49','kasir','PEMBELIAN UMUM','FB-250905-0014','9347000','2300000','7047000');
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-00016920','X-00016920','AT X BONEKA ANAK KLIP MT CAT LG','GR','---','A1E','BELI','BELI001','935000','2025-09-05','1.150','1','kasir','2025-09-05 14:30:06');
DELETE FROM tp_barang WHERE kode_dept = 'X-A1E';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-A1E','X-00016920','X-00016920');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0015','F325251253161','SIN','1','BELI','BELI001','A1E', 'X-00016920', 'AT X BONEKA ANAK KLIP MT CAT LG','1.150','1.150','100.00','1005000','935000','813043','882000','1','935000','935000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.150',berat_beli_asli=berat_beli_asli+'1.150',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.150',berat_akhir_asli=berat_akhir_asli+'1.150',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='A1E' 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) VALUES ('FB-250905-0015','2025-09-05','2025-09-05','14:30:06','SIN','---','1.150','935000','935000','935000','935000','935000','kasir','2025-09-05 14:30:06','FB-250905-0015');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0015','SEPTYA','SUKOMANGU','','','','kasir','2025-09-05 14:30:06');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0022','K','2025-09-05','14:30:06','kasir','PEMBELIAN UMUM','FB-250905-0015','7047000','935000','6112000');
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-00016921','X-00016921','CC X SOLITAIRE MATA CM 16 8K','GR','---','E2D','BELI','BELI001','1040000','2025-09-05','1.380','1','kasir','2025-09-05 14:43:02');
DELETE FROM tp_barang WHERE kode_dept = 'X-E2D';
INSERT INTO tp_barang (kode_dept,kode_barang,kode_barcode) VALUES ('X-E2D','X-00016921','X-00016921');
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,harga_skrg,qty,dpp_det_rp,jml_det_rp,kondisi) VALUES ('FB-250905-0016','F325090911402','SIN','1','BELI','BELI001','E2D', 'X-00016921', 'CC X SOLITAIRE MATA CM 16 8K','1.380','1.380','100.00','1118000','1040000','753623','865000','1','1040000','1040000','CUCI');
UPDATE tt_barang_saldo SET berat_beli=berat_beli+'1.380',berat_beli_asli=berat_beli_asli+'1.380',stock_beli=stock_beli+'1',berat_akhir=berat_akhir+'1.380',berat_akhir_asli=berat_akhir_asli+'1.380',stock_akhir=stock_akhir+'1' WHERE tanggal ='2025-09-05' AND kode_lokasi_gudang ='BELI' AND kode_lokasi_toko='BELI001' AND kode_dept ='E2D' 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) VALUES ('FB-250905-0016','2025-09-05','2025-09-05','14:43:01','SIN','---','1.380','1040000','1040000','1040000','1040000','1040000','kasir','2025-09-05 14:43:02','FB-250905-0016');
INSERT INTO tm_supplier_umum(no_faktur_beli,nama_supplier,alamat1,alamat2,kota,telepon,input_by,input_date) VALUES ('FB-250905-0016','LILIS UNTARI','BUGELAN KISMANTORO','','','','kasir','2025-09-05 14:43:02');
SELECT Right(no_ref,4) as no_ref,sld_akhir_rp FROM tt_cash_daily WHERE tanggal='2025-09-05' 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) VALUES ('KK-250905-0023','K','2025-09-05','14:43:01','kasir','PEMBELIAN UMUM','FB-250905-0016','6112000','1040000','5072000');
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,status_otorisasi,harga_skrg) VALUES ('F325050247201','kasir','1',' MEE1 LG 14','TOKO','PM-E','E1E-YHAB-110-0','CC MODEL DAUN VAR LG 14 8K ','','0.510','1','100.00','450000','0','0','15000','450000','0','0','0','450000','SIN','00365365','E1E','0','0','-','0','882000');
UPDATE tm_barang SET tgl_last_jual='2025-09-05', stock_on_hand='0',tagid=kode_barcode WHERE kode_barang='E1E-YHAB-110-0' LIMIT 1;
UPDATE tt_barang_saldo SET berat_jual=berat_jual+'0.510',berat_jual_asli=berat_jual_asli+'0.510',stock_jual='1',berat_akhir=berat_akhir-'0.510',berat_akhir_asli=berat_akhir_asli-'0.510',stock_akhir='0' WHERE tanggal='2025-09-05' AND kode_barang='E1E-YHAB-110-0' AND kode_lokasi_gudang= 'TOKO' AND kode_lokasi_toko='PM-E' 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 ('F325050247201','2025-09-05','0.510','2025-09-05','14:47:20','PLG0024821','450000','450000','0','450000','450000','kasir','2025-09-05 14:47:20','F32505024720');
INSERT INTO tt_jual_sales(tgl_system,no_faktur_jual,tgl_faktur_jual,jam_faktur_jual,sales_id,jml_jual_rp,ongkos_rp) VALUES('2025-09-05','F325050247201','2025-09-05','14:47:20','SIN','450000','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-250905-0024','D','2025-09-05','14:47:20','kasir','PENJUALAN','F325050247201','5072000','450000','5522000');
INSERT INTO tt_pindah_detail(no_pindah,no_urut,kode_barang,qty,berat,jml_detail,gudang_asal,lokasi_asal,gudang_to,lokasi_to) VALUES ('PB-250905-0001','1','F3E-YGXE-177-0','1','1.730','1.730','TOKO','PM-F','TOKO','MBK-F');
UPDATE tm_barang SET berat_bandrol='0', kode_lokasi_gudang='TOKO', kode_lokasi_toko='MBK-F' WHERE kode_barang='F3E-YGXE-177-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-F';
INSERT INTO tt_barang_saldo(tanggal,kode_lokasi_gudang,kode_lokasi_toko,kode_dept,kode_barang,kadar,stock_in,berat_in,berat_in_asli,stock_akhir,berat_akhir,berat_akhir_asli) VALUES('2025-09-05','TOKO','MBK-F','F3E','F3E-YGXE-177-0','100.00','1','1.730','1.730','1','1.730','1.730');
UPDATE tt_barang_saldo SET stock_out=stock_out+1,berat_out=berat_out+'1.730',berat_out_asli=berat_out_asli+'1.730',stock_akhir=0,berat_akhir=0,berat_akhir_asli=0 WHERE tanggal='2025-09-05' AND kode_barang='F3E-YGXE-177-0' AND kode_lokasi_gudang='TOKO' AND kode_lokasi_toko='PM-F' AND stock_akhir > 0;
INSERT INTO tt_pindah_head(no_pindah,tgl_system,tgl_pindah,jam_pindah,jml_berat,input_by,input_date) VALUES('PB-250905-0001','2025-09-05','2025-09-05','14:55','1.73','input','2025-09-05 14:57:17');
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325050129351' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325050129351' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325050129351';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325050139461' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325050139461' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325050139461';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325050202181' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325050202181' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325050202181';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325050202182' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325050202182' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325050202182';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325050247201' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325050247201' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325050247201';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325050915191' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325050915191' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325050915191';
UPDATE tt_jual_head SET status_valid='DONE' WHERE no_faktur_jual='F325050953011' LIMIT 1;
UPDATE tt_jual_tukar_head SET status_valid='DONE' WHERE no_faktur_jual='F325050953011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='F325050953011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0001' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0001';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0002' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0002';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0003' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0003';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0004' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0004';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0005' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0005';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0006' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0006';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0007' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0007';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0008' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0008';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0009' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0009';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0010' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0010';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0011' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0011';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0012' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0012';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0013' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0013';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0014' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0014';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0015' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0015';
UPDATE tt_beli_head SET status_valid='DONE' WHERE no_faktur_beli='FB-250905-0016' LIMIT 1;
UPDATE tt_cash_daily SET status_valid='DONE' WHERE deskripsi='FB-250905-0016';
INSERT INTO th_saldo_hutang(tanggal,qty_awal,berat_awal,rp_awal,qty_akhir,berat_akhir,rp_akhir) VALUES ('2025-09-06','0','0','0','0','0','0');
DELETE FROM th_barang_saldo WHERE tanggal <= '2025-08-06';
INSERT INTO th_barang_saldo SELECT * FROM tt_barang_saldo WHERE tanggal = '2025-09-05';
UPDATE tt_barang_saldo SET status_close ='CLOS' WHERE tanggal='2025-09-05';
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='2025-09-05' AND berat_akhir*1 > '0'
INSERT INTO th_cash_daily SELECT * FROM tt_cash_daily WHERE tanggal = '2025-09-05';
DELETE FROM tt_cash_daily WHERE tanggal <= '2025-09-05';
INSERT INTO th_bank_daily SELECT * FROM tt_bank_daily WHERE tanggal = '2025-09-05';
DELETE FROM tt_bank_daily WHERE tanggal <= '2025-09-05';
CREATE TABLE IF NOT EXISTS th_barang_saldo_202508 SELECT * FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
DELETE FROM th_barang_saldo WHERE LEFT(tanggal,7)='2025-08';
UPDATE tt_barang_saldo SET tanggal= '2025-09-06' WHERE status_close ='OPEN';
DELETE FROM tt_barang_saldo WHERE tanggal <= '2025-09-05' OR stock_akhir*1<0  OR kode_lokasi_gudang='' OR kode_lokasi_toko='' OR status_close='CLOS';
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-250906-0001','D','2025-09-06','15:15:17','SYSTEM','SALDO AWAL','SALDO AWAL','0','5522000','5522000');
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-250906-0001','D','2025-09-06','15:15:17','DLL','SALDO AWAL','SALDO AWAL','0','0','0');
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-250906-0001','D','2025-09-06','15:15:17','BRI','SALDO AWAL','SALDO AWAL','0','0','0');
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-250906-0001','D','2025-09-06','15:15:17','BCA','SALDO AWAL','SALDO AWAL','0','693326000','693326000');
UPDATE tp_system SET tgl_system='2025-09-06';