<% totalqty = 0 totalamt = 0 taftamts = 0 pagestart = params[:page] ? params[:page] : 1 if pagestart.to_i <=1 i = 1 else i = ((pagestart.to_i-1)*10)+1 i = i.to_i end if @proditems.length >0 @proditems.each do |pds| %> <% qty = 1 if pds.pd_productcode!=nil && pds.pd_productcode!='' proobj = get_stocks_detail(pds.pd_compcode,pds.pd_productcode) if proobj qty = proobj.cb_closing_bal end end %> <% aftamt = 0 duscounst = pds.pd_discount amnts = pds.pd_mrps.to_f*qty.to_f discounts = (duscounst.to_f*amnts.to_f)/100 aftamt = amnts.to_f-discounts.to_f totalqty += qty.to_f totalamt += amnts.to_f taftamts += aftamt.to_f %> <% i +=1 end %> <% else %> <% end %>

SL.No.	SKU Code	Name	Brand	Category	Gender	BalQty	MRP Est	Amount	Discount%	Amount After Disc.
<%=i%>	<%=pds.pd_productcode%>	<%=pds.pd_productname%>	<% brands = '' if pds.pd_brand.to_i >0 bobj = get_sel_brand(pds.pd_compcode,pds.pd_brand) if bobj brands = bobj.pb_brandname end end %> <%=brands%>	<% catsnm = '' if pds.pd_category.to_i >0 catsobj = get_sel_category(pds.pd_compcode,pds.pd_category) if catsobj catsnm = catsobj.pc_categoryname end end %> <%=catsnm%>	<%=pds.pd_gender%>	<%=currency_formatted(qty)%>	<%=currency_formatted(pds.pd_mrps)%>	<%=currency_formatted((pds.pd_mrps.to_f*qty))%>	<%=currency_formatted(pds.pd_discount)%>	<%=currency_formatted(aftamt)%>
No Record(s) Found.