<% k = 1 if @AppList.length >0 @AppList.each do |aprv| %> <% compcodes = aprv.enq_compcode enqnumber = aprv.enq_number filesx = '' objtrn = TrnEnquiryFile.select("ef_enquiry_file,ef_img_title").where("ef_compcode=? AND ef_enquiry_number=?",compcodes,enqnumber) if objtrn.length >0 objtrn.each do |myfile| filesx += myfile.ef_enquiry_file.to_s+"_"+myfile.ef_img_title.to_s+"," end filesx = filesx.chop end %> <% 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 %> <% 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 %> <% 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%>	<%=sourcename%>	<%=pnames%>	<%=aprv.enq_new_requirement%>	<%=aprv.enq_remarks%>	<%=aprv.enq_company_name%>
No Record(s) Found.