<% k = 1 if @AppList.length >0 @AppList.each do |aprv| %> <% k +=1 end else %> <% end %>

Select	Enq. No	Date	Source Name	Product	New Requirement	Remarks	Company Name
	<%=aprv.enq_number%>	<% edate = '' if aprv.enq_date!=nil && aprv.enq_date!='' dt = Date.parse(aprv.enq_date.to_s) edate = dt.strftime("%d-%b-%Y") end %> <%=edate%>	<% compcodes = aprv.enq_compcode srctype = aprv.enq_source_type agentsid = aprv.enq_agent sourcename = '' if srctype!=nil && srctype!='' && srctype == 'agent' salesman = MstSale.select("sl_name").where("sl_compcode=? AND id=?",compcodes,agentsid).first if salesman sourcename = salesman.sl_name end elsif srctype!=nil && srctype!='' && srctype == 'emp' empman = MstEmployee.select("emp_name").where("emp_compcode=? AND id=?",compcodes,agentsid).first if empman sourcename = empman.emp_name end end %> <%=sourcename%>	<% pnames = '' aprprod = MstProduct.select("pd_productname").where("pd_compcode =? AND id=?",compcodes,aprv.enq_product_id.to_i).first if aprprod pnames = aprprod.pd_productname end %> <%=pnames%>	<%=aprv.enq_new_requirement%>	<%=aprv.enq_remarks%>	<%=aprv.enq_company_name%>
No Record(s) Found.