<%= render "layouts/portlet-config" %> <%= render "layouts/theme-panel" %> <% if flash[:error] %>
× <%= flash[:error] %>
<% end %> <%= render "layouts/breadcrumbs" %> <%= form_tag({:action=>'create'} ,:multipart=>true,:id=>"isMyForms" ) do %> <% end %>

Total Open Orders

Open Orders
<%=@topenordes %>

Total Pending PO

Pending PO
<%=@tponumbers%>

Total Completed Orders

Completed Orders
<%=@tcompleorder%>

Total Invoices Balance

Total Invoices
<%=currency_formatted(@thisMonthInvoice).to_f >0 ? currency_formatted(@thisMonthInvoice) : '0.00'%>

Total Due Outstanding

Uncleared Bills
<%=currency_formatted(@totaloutstaning).to_f >0 ? currency_formatted(@totaloutstaning) : '0.00'%>
 
<% tbvalues = 0 if @bExport.length >0 tbvalues += @bExport[0].dtValues.to_f end if @bLocal.length >0 tbvalues += @bLocal[0].dtValues.to_f end if @bPI.length >0 tbvalues += @bPI[0].dtValues.to_f end %> <% tbquantity = 0 if @bExport.length >0 tbquantity += @bExport[0].dtqnty.to_i end if @bLocal.length >0 tbquantity += @bLocal[0].dtqnty.to_i end if @bPI.length >0 tbquantity += @bPI[0].dtqnty.to_i end %> <% avlcquantity = 0 avexpquantity = 0 avpiquantity = 0 tavgcost = 0 if @bExport.length >0 qnt = @bExport[0].dtqnty.to_i avcost = @bExport[0].dtValues.to_f if qnt.to_i >0 && tbvalues.to_f >0 avexpquantity1 = (avcost.to_f/qnt.to_i) avexpquantity = "%.2f" % avexpquantity1.to_f tavgcost += avexpquantity1.to_f end end if @bLocal.length >0 lcqt = @bLocal[0].dtqnty.to_i lval = @bLocal[0].dtValues.to_f if lcqt.to_i >0 && lval.to_f >0 avlcquantity1 = (lval.to_f/lcqt.to_i) avlcquantity = "%.2f" % avlcquantity1.to_f tavgcost += avlcquantity1.to_f end end if @bPI.length >0 piqnt = @bPI[0].dtqnty.to_i pivals = @bPI[0].dtValues.to_f if piqnt.to_i >0 && pivals.to_f >0 avpiquantity1 = (pivals.to_f/piqnt.to_i) avpiquantity = "%.2f" % avpiquantity1.to_f tavgcost += avpiquantity1.to_f end end %>
Description Export Local PI Total
Value <% if @bExport.length >0 %><%="%.2f" % @bExport[0].dtValues.to_f%><% else %>0.00<% end %><% else %>0.00<% end %>"/> <% if @bLocal.length >0 %><%="%.2f" % @bLocal[0].dtValues.to_f%><% else %>0.00<% end %> <% else %>0.00<% end %>"/> <% if @bPI.length >0 %><%="%.2f" % @bPI[0].dtValues.to_f%><% else %>0.00<% end %><% else %>0.00<% end %>"/> <%="%.2f" % tbvalues%> "/>
Quantity <% if @bExport.length >0 %><%=@bExport[0].dtqnty.to_i%><% else %>0<% end %> <% if @bLocal.length >0 %><%=@bLocal[0].dtqnty.to_i%><% else %>0<% end %> <% if @bPI.length >0 %><%=@bPI[0].dtqnty.to_i%><% else %>0<% end %> <% if tbquantity %><%=tbquantity.to_i%><% else %>0<% end %>
Avg Quantity Cost <% if avexpquantity.to_f >0 %><%=avexpquantity%><% else %>0.00<% end %> <% if avlcquantity.to_f >0 %><%=avlcquantity%><% else %>0.00<% end %> <% if avpiquantity.to_f >0 %><%=avpiquantity%><% else %>0.00<% end %> <% if tavgcost.to_f >0 %><%="%.2f" % tavgcost.to_f %><% end %> <% end %>"/>
<% if @orderTSummary.length >0 @orderTSummary.each do |torder| %> <% end %> <% else %> <% end %> <% if @orderESummary.length >0 @orderESummary.each do |exorder| %> <% end %> <% else %> <% end %> <% if @orderESummary.length >0 @orderESummary.each do |holdorder| %> <% end %> <% else %> <% end %>
Description View Total Orders Value Age <7 Age 8-15 Age 16-30 Age 31-60 Age 61-90 Age >90
Approved Order <%=torder.totalorder%> <%=currency_formatted(torder.totavalue)%> <%=torder.ageseven%> <%=torder.agefifteen%> <%=torder.agexixteen%> <%=torder.agedaythirty%> <%=torder.agedaysixty%> <%=torder.agedayonetwenty%>
Total Approv. Order -- -- -- -- -- -- -- --
Executed Order <%=exorder.totalorder%> <%=currency_formatted(exorder.totavalue)%> <%=exorder.ageseven%> <%=exorder.agefifteen%> <%=exorder.agexixteen%> <%=exorder.agedaythirty%> <%=exorder.agedaysixty%> <%=exorder.agedayonetwenty%>
Executed Order -- -- -- -- -- -- -- --
Hold Order <%=holdorder.totalorder%> <%=currency_formatted(holdorder.totavalue)%> <%=holdorder.ageseven%> <%=holdorder.agefifteen%> <%=holdorder.agexixteen%> <%=holdorder.agedaythirty%> <%=holdorder.agedaysixty%> <%=holdorder.agedayonetwenty%>
Hold Order -- -- -- -- -- -- -- --
Open Tabular Buyer-Order
<% l1 = 1; k = 1 if @buyresOrder.length >0 @buyresOrder.each do |byrs| %>

<% buersid = byrs.hd_customer_id salesid = byrs.cs_salesman jbsorders = get_buyers_job_order_details('S',buersid,salesid) if jbsorders.length >0 jbsorders.each do |jo| %> <% k +=1 end else %> <% end %>
View Order No Order date Type Initiated by Buyer
PO No 		Buyer
PO date 		Payment Terms Payment Status Order Status OA Value OA Qty Dispatch Date Partial
Ship(Y/N) 		Ship Date
<%=jo.hd_billnumber%> <% dt = '' if jo.hd_billdate!=nil && jo.hd_billdate!='' dt = Date.parse(jo.hd_billdate.to_s).strftime("%d-%m-%Y") end %> <%=dt%> <%=jo.exprtype%> <%=jo.sl_name%> <%=jo.hd_po_number%> <% pdt = '' if jo.hd_po_date!=nil && jo.hd_po_date!='' pdt = Date.parse(jo.hd_po_date.to_s).strftime("%d-%m-%Y") end %> <%=pdt%> <%=jo.hd_payment_terms!=nil && jo.hd_payment_terms!='' ? jo.hd_payment_terms : '----'%> <%=jo.pamtstatus%> <%=jo.orderstatus%> <%="%.2f" % jo.dtValues.to_f%> <%=jo.dtqnty%> <%=jo.dispdate%> <%=jo.shipped%> <%=jo.shipdate%>
PO No Po Date Supplier Currency Prep By Auth By Remarks Approve Rmk Tot. Qty Tot. Value Bal. Qty
No Record(s) found.
<% l1 +=1 end end %>
ORDER STATUS
  Search
<% k =1 jtotalod = 0 jtotalpo = 0 jtotalmrn = 0 jtotalpack = 0 jtotalinvoice = 0 joduedays = 0 if @TatList.length >0 @TatList.each do | lstns | jtotalod += lstns.dt_miodqty.to_f jtotalpo += lstns.dt_mipoqty.to_f jtotalmrn += lstns.dt_mrnqty.to_f jtotalpack += lstns.dt_mipackqty.to_f jtotalinvoice += lstns.dt_mipackinvqty.to_f joduedays += lstns.jodues.to_i %> <% k +=1 end else %> <% end %>
JOB Order JO Date Buyer Product JO QTY PO QTY MRN QTY Pack QTY Invoice QTY JO Days Status Action
<%=lstns.dt_miod%> <%=lstns.jodate%> <%=lstns.buyername%> <% pdnames = "" pdobj = get_name_of_product(@compcodes,lstns.dt_miprodcode) if pdobj pdnames = pdobj.pd_productname end %> <%=pdnames%> <%=lstns.dt_miodqty%> <%=lstns.dt_mipoqty%> <%=lstns.dt_mrnqty%> <%=lstns.dt_mipackqty%> <%=lstns.dt_mipackinvqty%> <%=lstns.jodues%> <% if lstns.dt_mipackinvqty.to_f >=lstns.dt_miodqty.to_f %> Completed <% else %> Pending <% end %> <% if lstns.closestatus !='Y' %> Update Status <% else %> Closed <% end %>
No record(s) found.
Total <%=jtotalod%> <%=jtotalpo%> <%=jtotalmrn%> <%=jtotalpack%> <%=jtotalinvoice%> <%=joduedays%>
Calendar

**This section is under construction


Meetings

Birthdays

Special Events

AMC Dues