📄 contactsearchpopup.jsp

📁 国外的一套开源CRM
💻 JSP
字号:

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

<%@ page import="org.apache.commons.beanutils.*" %>
<%@ page import="com.sourcetap.sfa.ui.*" %>
<%@ page import="com.sourcetap.sfa.util.*" %>
<%@ page import="com.sourcetap.sfa.security.*" %>
<%@ page import="org.ofbiz.entity.util.*" %>

<%@ taglib uri="displaytag" prefix="display" %>

<LINK rel="stylesheet" type="text/css" href="/sfa/includes/maincss.css">
<LINK rel="stylesheet" type="text/css" href="/sfa/css/report.css">

<BASE target="_self">

<%
	String action = UtilFormatOut.checkNull(request.getParameter("action"));
	String firstName = UtilFormatOut.checkNull(request.getParameter("firstName")).replace('*','%');
	String lastName = UtilFormatOut.checkNull(request.getParameter("lastName")).replace('*','%');
	String accountName = UtilFormatOut.checkNull(request.getParameter("accountName")).replace('*','%');
	String city = UtilFormatOut.checkNull(request.getParameter("city")).replace('*','%');
	String contactId = UtilFormatOut.checkNull(request.getParameter("contactId"));

	if ( contactId.length() > 0 )
	{
			
		GenericValue contactGV = delegator.findByPrimaryKey("Contact", UtilMisc.toMap("contactId", contactId));
		String contactName = contactGV.getString("firstName") + " " + contactGV.getString("lastName");
		
%>
	<BODY onload='window.opener.setContact("<%=contactId%>","<%=contactName%>");window.close();window.opener.focus()'>
<%
	}
	else
	{
%>
	<BODY onload='self.focus()'>
<%
	}
%>
<BR>
<CENTER>
<FORM action=/sfa/control/contactSearchPopup>
<input type=hidden name=action value=find>
<input type=hidden name=contactId value=<%=contactId%>>
<TABLE class=freeFormSectionDisplayTable>
<TR><TD class=freeFormSectionLabelOptional>First:</TD><TD class=freeFormSectionField><input name=firstName value='<%=firstName%>' size=20></TD>
    <TD class=freeFormSectionLabelOptional>Last:</TD><TD class=freeFormSectionField><input name=lastName value='<%=lastName%>' size=20></TD>
    <TD class=freeFormSectionLabelOptional>Company:</TD><TD class=freeFormSectionField><input name=accountName value='<%=accountName%>' size=20></TD>
    <TD class=freeFormSectionLabelOptional>City:</TD><TD class=freeFormSectionField><input name=city value='<%=city%>' size=20></TD>
    <TD><input type=submit value=Search name=Search></TD></TR>
</TABLE>
</FORM>
<CENTER>

<%
	
	if ( action.equals("find") )
	{
	
	
		QueryInfo queryInfo = new QueryInfo( delegator, "Contact" );

		queryInfo.addJoin("Contact", "Address", Boolean.TRUE, "contactId", "addressOwnerId");
		queryInfo.addJoin("Contact", "Account", Boolean.TRUE, "accountId", "accountId");
		queryInfo.addCondition("Address", "isPrimary", EntityOperator.EQUALS, "Y");

        queryInfo.addAlias("Address", "mailingAddress", "mailingAddress");
        queryInfo.addAlias("Address", "city", "city");
        queryInfo.addAlias("Address", "state", "state");
        queryInfo.addAlias("Address", "zip", "zip");
        queryInfo.addAlias("Account", "accountName", "accountName");
		
		if ( firstName.length() > 0 )
			queryInfo.addCondition("Contact", "firstName", EntityOperator.LIKE, firstName + "%");

		if ( lastName.length() > 0 )
			queryInfo.addCondition("Contact", "lastName", EntityOperator.LIKE, lastName + "%");
			
		if ( accountName.length() > 0)
			queryInfo.addCondition("Account", "accountName", EntityOperator.LIKE, accountName + "%");

		if ( city.length() > 0)
			queryInfo.addCondition("Address", "city", EntityOperator.LIKE, city + "%");

        //SecurityLinkInfo securityInfo = new SecurityLinkInfo("Account", "accountId", true);
		SecurityLinkInfo securityInfo = null;
				
		EntityListIterator eli = null;
		if (securityInfo == null )
			eli = queryInfo.getQueryIterator();
		else
			eli = SecurityWrapper.findListIteratorByCondition("Contact", queryInfo, UtilMisc.toList("lastName","firstName"), userInfo, securityInfo, delegator );
			
		List contacts = eli.getPartialList(1, 500);
		eli.close();
			
		if ( ( contacts == null ) || ( contacts.size() < 1) )
		{
			out.write("No Data");
		}
		else
		{
				
			request.setAttribute("results", contacts);
	
%>

			<BR><BR>
			<CENTER>
			<display:table name="results" export="false" sort="list" pagesize="10" class="its">
  				<display:column property="firstName" title="First"  sortable="true" headerClass="sortable" href="/sfa/control/contactSearchPopup" paramId="contactId" paramProperty="contactId"/>
  				<display:column property="lastName" title="Last"  sortable="true" headerClass="sortable" href="/sfa/control/contactSearchPopup" paramId="contactId" paramProperty="contactId"/>
  				<display:column property="businessPhone" title="Phone"  sortable="false" headerClass="sortable"/>	
  				<display:column property="accountName" title="Company"  sortable="true" headerClass="sortable"/>	
  				<display:column property="mailingAddress" title="Address"  sortable="true" headerClass="sortable"/>	
  				<display:column property="city" title="City"  sortable="true" headerClass="sortable"/>	
  				<display:column property="state" title="State"  sortable="true" headerClass="sortable"/>	
  				<display:column property="zip" title="Zip"  sortable="true" headerClass="sortable"/>	
			</display:table>
			</CENTER>

<%
		}
	}
%>

<%@ include file="/includes/footer.jsp" %>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -