dealadvancedsearch.jsp

国外的一套开源CRM

<%@ page import="org.ofbiz.entity.*" %>
<%@ page import="org.ofbiz.entity.model.*" %>
<%@ page import="java.lang.reflect.Method" %>
<%@ page import="java.util.*" %>
<%@ page import="org.ofbiz.entity.util.SequenceUtil" %>


<%@ include file="/includes/header.jsp" %>
<%@ include file="/includes/leftcolumn-deal.jsp" %>

<%
   String ENTITY = "Deal";
   String action = "";

   ModelEntity entity = delegator.getModelEntity(ENTITY);

   List l = null;
   if(request.getParameter("action") != null){
     //actions=search, update, create
     action = request.getParameter("action");
   }

   if(action.equals("search")){
    Enumeration params = request.getParameterNames();
    Vector dealFields = entity.getFieldsCopy();
    HashMap hashMap = new HashMap();
    while(params.hasMoreElements()){
      String pName = (String)params.nextElement();
      ModelField modelField = null;
      if((modelField = contains(dealFields, pName)) != null){
        String value = request.getParameter(pName);
        if(value.trim().length() >= 1){
          hashMap.put(pName, request.getParameter(pName).replace('*', '%'));
        }
      }
    }
     l = delegator.findByLike(ENTITY, hashMap, null);
   }
%>

<!-- title table -->
<table width="100%" height="30"><tr><td><div class="head1">Deal</div></td></tr></table>

<table width="100%" valign="top" border="0"><!-- outer table -->
  <tr>
    <td>
          <table width='350' class=viewOneHeader>
          <tr><td width='100%' height='100%'>
            <table width="100%">
              <tr class=viewOneHeader>
                <td><%=entity.entityName %> Advanced Search</td><td align="right"></td>
              </tr>
             </table>
            <table border="0" width="350">
            <form method="post" action="<ofbiz:url>/dealAdvancedSearch</ofbiz:url>" >
              <input type="hidden" value="search" name="action" >
            <% //display account details

             Iterator ix = entity.getFieldsIterator();
             while(ix.hasNext()){
              ModelField currField = (ModelField)ix.next();
            %>
            <tr>
                <td class=viewOneLabel>
                  <%=formatJavaString(currField.name)%></td>
                  <td class=viewOneField>
                    <input type="text" name="<%=currField.name%>" value="<%=(request.getParameter(currField.name) != null ? request.getParameter(currField.name) : "") %>">
                </td>
            </tr>
            <%} %>
              <tr><td colspan="2" align="right"><input type="submit" value="search" ></td></tr>
            </form>
            </td></tr>
           </table>
    </td>
  </tr>
</table>

       <!-- display results, if there are any -->
       <%if(action.equals("search") && l.size() > 0) {%>
    <table border="0" width='100%' cellpadding='<%=headerBoxBorderWidth%>' cellspacing='0' bgcolor='<%=headerBoxBorderColor%>'>
    <tr><td width='100%' height='100%'>
       <table width="100%" height="100%" bgcolor="white"><tr ><td>
         <table border="0" height="100%" width="100%" bgcolor="white" cellspacing="0" cellpadding="2">
              <tr valign="top" colspan="3"><td><div class="head3">Search Results</div></td><td align="right"></td></tr>
              <!-- Search Results -->
              <%
            Iterator i = l.iterator();
            GenericValue genericEntity = null;
            ModelField modelField = null;
            out.write("<tr bgcolor=\"#C0C0C0\">");

            ArrayList fieldNames = new ArrayList();
            fieldNames.add("dealId");
            fieldNames.add("dealName");
            fieldNames.add("dealTypeId");
            fieldNames.add("probability");
            fieldNames.add("dealStatusId");

            //include the fields that were searched.
            Enumeration params = request.getParameterNames();
            while(params.hasMoreElements()){
                String param = (String)params.nextElement();
                String value = request.getParameter(param);
                if(value.trim().length() >= 1 && !fieldNames.contains(param) && !param.equals("action")){
                  fieldNames.add(param);
                }
            }

            for(int ic=0;ic<fieldNames.size();ic++){
              out.write("<td><div class=\"tabletext\"><b>" + (String)fieldNames.get(ic) + "</b></div></td>");
            }
            out.write("</tr>");

            int rowColor = 0;
            String stringRowColor = "";
            while(i.hasNext()){
              genericEntity = (GenericValue)i.next();
              if(rowColor%2 == 1){
                stringRowColor = "#C0C0C0";
              } else {
                stringRowColor = "#CFCFCF";
              }

              rowColor++;
              out.write("<tr bgcolor=" + stringRowColor  + " >");
              for(int iz=0;iz<fieldNames.size();iz++){
                String s = (String)fieldNames.get(iz);
                out.write("<td><div class=\"tabletext\">");
                if(iz==0){
                  out.write("<a href='");
                  %><ofbiz:url>/dealDetail</ofbiz:url><%out.write("?dealId=" + String.valueOf(genericEntity.get(s)) + "'>" + String.valueOf(genericEntity.get(s)) + "</a>");
                } else {
                  out.write((String.valueOf(genericEntity.get(s)) != null ? String.valueOf(genericEntity.get(s)) : "" ));
                }
                out.write("</div></td>");
              }
              out.write("</tr>");
            }    %>
        </table>
        </td></tr></table>
    </td></tr></table>
      <%}%>


<%@ include file="/includes/footer.jsp" %>