📄 accountsearchpopup.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">

<script>
	var openerReturnLoc = '';
</script>

<%
	String action = UtilFormatOut.checkNull(request.getParameter("action"));
	String accountName = UtilFormatOut.checkNull(request.getParameter("accountName"));
	String accountId = UtilFormatOut.checkNull(request.getParameter("accountId"));

	if ( accountId.length() > 0 )
	{
	
		GenericValue accountGV = delegator.findByPrimaryKey("Account", UtilMisc.toMap("accountId", accountId));
		accountName = accountGV.getString("accountName");
		
%>
	<BODY onload='window.opener.setAccount("<%=accountId%>","<%=accountName%>");window.close();window.opener.focus()'>
<%
	}
	else
	{
%>
	<BODY onload='self.focus()'>
<%
	}
%>
<BR>
<CENTER>
<FORM action=/sfa/control/accountSearchPopup>
<input type=hidden name=action value=find>
<input type=hidden name=accountId value=<%=accountId%>>

<TABLE class=freeFormSectionDisplayTable>
<TR><TD class=freeFormSectionLabelOptional>Name:</TD><TD class=freeFormSectionField><input name=accountName value='<%=accountName%>' size=20></TD>
    <TD><input type=submit value=Search name=Search></TD></TR>
</TABLE>
</FORM>
<CENTER>

<%
	
	if ( action.equals("find") )
	{
		if ( accountName.length() < 1 )
			accountName = "A";
			
		accountName = accountName.replace('*','%');

		QueryInfo queryInfo = new QueryInfo( delegator, "Account" );

		queryInfo.addJoin("Account", "Address", Boolean.TRUE, "accountId", "addressOwnerId");
		queryInfo.addCondition("Account", "accountName", EntityOperator.LIKE, accountName + "%");
		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");
        SecurityLinkInfo securityInfo = new SecurityLinkInfo("Account", "accountId", true);
		
		EntityListIterator eli = SecurityWrapper.findListIteratorByCondition("Account", queryInfo, UtilMisc.toList("accountName"), userInfo, securityInfo, delegator );
		List accounts = eli.getPartialList(1, 500);
		eli.close();
		
		if ( ( accounts == null ) || ( accounts.size() < 1) )
		{
			out.write("No Data");
		}
		else
		{

			request.setAttribute("results", accounts);
	
%>

			<BR><BR>
			<CENTER>
			<display:table name="results" export="false" sort="list" pagesize="15" class="its">
  				<display:column property="accountName" title="Name"  sortable="true" headerClass="sortable" href="/sfa/control/accountSearchPopup" paramId="accountId" paramProperty="accountId"/>
  				<display:column property="phone" title="Phone"  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 + -