uiscreenwritesql.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 SCREEN: Write SQL File
      </td>
    </table>

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

	String action = "";
	if (request.getParameter("action") != null) {
		action = request.getParameter("action");
	}
	String screenId = "";
	if (request.getParameter("screenId") != null) {
		screenId = request.getParameter("screenId");
	}
	String screenName = "";
	if (request.getParameter("screenName") != null) {
		screenName = request.getParameter("screenName");
	} else {
		HashMap hashMap = new HashMap();
		hashMap.put("screenId", screenId);
		ModelEntity uiScreenME = delegator.getModelEntity("UiScreen");
		GenericPK genericPk = new GenericPK(uiScreenME, hashMap);
		GenericValue uiScreenGV = delegator.findByPrimaryKey(genericPk);
		screenName = uiScreenGV.getString("screenName");
	}
	if (action.equals("showWriteSqlFile")) {
		//String filePath = "c:\\ofbiz\\work\\ofbiz\\sfa\\sql\\ui-s-" + screenName.replace(' ', '_') + ".sql";
		String filePath = System.getProperty("ofbiz.home");
		filePath += "/sfa/sfadb/ui-s-" + screenName.replace(' ', '_') + ".xml";
%>
      <form method="post" action="<ofbiz:url>/uiScreenWriteSql</ofbiz:url>" TARGET="headerFrame">
        <input type="hidden" name="screenId" value="<%=screenId%>">
        <input type="hidden" name="screenName" value="<%=screenName%>">
        <input type="hidden" value="writeSqlFile" name="action" >

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Screen ID:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=screenId%>
		 </TD>
        </TR>

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Screen Name:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=screenName%>
		 </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.writeUiScreenFile (delegator, "-1", screenId, filePath);
%>
        <TR>
		 <TD CLASS="freeFormSectionField" COLSPAN="2">
          <%=message%>
		 </TD>
        </TR>
<%
		return;
	}

%>

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