<%= render "layouts/portlet-config" %> <%= render "layouts/theme-panel" %> <% if flash[:error] %>

× <%= flash[:error] %>

<% end %> <%= render "layouts/breadcrumbs" %> <%= form_tag({:action=>'index'} ,:multipart=>true,:id=>'myForms' ) do %>

BO NO

JO NO

Buyer

Item

Order By

checked<% end %>/>Product checked<% end %>/>BONO

Status

checked<% elsif !@orderbyStatus %>checked<% end %>/>Pending checked<% end %>/>Completed

Update Status

<% k =1 jtotalod = 0 jtotalpo = 0 jtotalmrn = 0 jtotalpack = 0 jtotalinvoice = 0 joduedays = 0 if @TatList.length >0 @TatList.each do | lstns | miodqty = get_buyer_order_pdwise(lstns.hd_compcode,lstns.hd_billnumber,lstns.dt_itemcode) mipoqty = new_get_po_cb_details(lstns.hd_billnumber,lstns.dt_itemcode) mimrnqty = new_get_mrn_aginst_jo_qty(lstns.hd_billnumber,lstns.dt_itemcode) mipackqty = new_get_packlist_qty(lstns.hd_billnumber,lstns.dt_itemcode) miinvqty = new_get_invoice_qty_jo(lstns.hd_billnumber,lstns.dt_itemcode) jtotalod += miodqty.to_f #lstns.dt_miodqty.to_f jtotalpo += mipoqty.to_f # lstns.dt_mipoqty.to_f jtotalmrn += mimrnqty.to_f #lstns.dt_mrnqty.to_f jtotalpack += mipackqty.to_f # lstns.dt_mipackqty.to_f jtotalinvoice += miinvqty.to_f # lstns.dt_mipackinvqty.to_f joduedays += lstns.jodues.to_i %> <% k +=1 end else %> <% end %>

Sl.No.	Buyer Order	JOB Order	Buyer Date	Buyer	Product	BO QTY	PO QTY	MRN QTY	Pack QTY	Invoice QTY	Buyer Days	Status	Action
<%=k%>	<%=lstns.ponumbers%>	<%=lstns.hd_billnumber%>	<%=lstns.jodate%>	<%=lstns.buyername%>	<% pdnames = "" pdobj = get_name_of_product(@compcodes,lstns.dt_miprodcode) if pdobj pdnames = pdobj.pd_productname end %> <%=( pdnames!='' ? pdnames[0..40] : '')%>	<%=miodqty%>	<%=mipoqty%>	<%=mimrnqty%>	<%=mipackqty%>	<%=miinvqty%>	<%=lstns.jodues%>	<% if miinvqty.to_f >=miodqty.to_f %> Completed <% else %> Pending <% end %>	<% if lstns.closestatus !='Y' %> <% else %> Closed <% end %>
No record(s) found.
Total						<%=jtotalod%>	<%=jtotalpo%>	<%=jtotalmrn%>	<%=jtotalpack%>	<%=jtotalinvoice%>	<%=joduedays%>

<% end %>