uidisplayobjectwritesql.jsp

国外的一套开源CRM

<jsp:useBean id="uISQLFileWriter" class="com.sourcetap.sfa.ui.UISQLFileWriter" scope="application" />

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

    <table WIDTH="100%" CLASS="freeFormSectionTitleTable"><tr>
      <td>
        UI DISPLAY OBJECT: Write SQL File
      </td>
    </table>

    <table WIDTH="100%" HEIGHT="100%" CLASS="freeFormSectionDisplayTable">
<%

	String action = "";
	if (request.getParameter("action") != null) {
		action = request.getParameter("action");
	}
	String displayObjectId = "";
	if (request.getParameter("displayObjectId") != null) {
		displayObjectId = request.getParameter("displayObjectId");
	}
	String displayObjectName = "";
	if (request.getParameter("displayObjectName") != null) {
		displayObjectName = request.getParameter("displayObjectName");
	} else {
		HashMap hashMap = new HashMap();
		hashMap.put("displayObjectId", displayObjectId);
		ModelEntity uiDisplayObjectME = delegator.getModelEntity("UiDisplayObject");
		GenericPK genericPk = new GenericPK(uiDisplayObjectME, hashMap);
		GenericValue uiDisplayObjectGV = delegator.findByPrimaryKey(genericPk);
		displayObjectName = uiDisplayObjectGV.getString("name");
	}
	if (action.equals("showWriteSqlFile")) {
		String filePath = "c:\\ofbiz\\work\\ofbiz\\sfa\\sql\\ui-do-" + displayObjectId + ".sql";

%>
      <form method="post" action="<ofbiz:url>/uiDisplayObjectWriteSql</ofbiz:url>" TARGET="headerFrame">
        <input type="hidden" name="displayObjectId" value="<%=displayObjectId%>">
        <input type="hidden" name="displayObjectName" value="<%=displayObjectName%>">
        <input type="hidden" value="writeSqlFile" name="action" >

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Display Object ID:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=displayObjectId%>
		 </TD>
        </TR>

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Display Object Name:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=displayObjectName%>
		 </TD>
        </TR>

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  File Path:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <input MAXLENGTH=100 SIZE=80 type="text" name="filePath" value="<%=filePath%>">
		 </TD>
        </TR>

        <TR>
		 <TD CLASS="freeFormSectionSaveButtonArea" COLSPAN="2">
          <input type="submit" value="Write File" >
		 </TD>
        </TR>

      </FORM>
     </TABLE>
<%

		return;
	}

	if (action.equals("writeSqlFile")) {
		String filePath = request.getParameter("filePath");
		String message = uISQLFileWriter.writeUiDisplayObjectFile (delegator, displayObjectId, filePath);
%>
        <TR>
		 <TD CLASS="freeFormSectionField" COLSPAN="2">
          <%=message%>
		 </TD>
        </TR>
<%
		return;
	}


%>

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