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

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

<%

	String action = "";
	if (request.getParameter("action") != null) {
		action = request.getParameter("action");
	}
	String displayTypeId = "";
	if (request.getParameter("displayTypeId") != null) {
		displayTypeId = request.getParameter("displayTypeId");
	}
	String displayTypeName = "";
	if (request.getParameter("displayTypeName") != null) {
		displayTypeName = request.getParameter("displayTypeName");
	} else {
		HashMap hashMap = new HashMap();
		hashMap.put("displayTypeId", displayTypeId);
		ModelEntity uiDisplayTypeME = delegator.getModelEntity("UiDisplayType");
		GenericPK genericPk = new GenericPK(uiDisplayTypeME, hashMap);
		GenericValue uiDisplayTypeGV = delegator.findByPrimaryKey(genericPk);
		displayTypeName = uiDisplayTypeGV.getString("name");
	}

	if (action.equals("showWriteSqlFile")) {
		String filePath = "c:\\ofbiz\\work\\ofbiz\\sfa\\sql\\ui-dt-" + displayTypeId + ".sql";

%>
      <form method="post" action="<ofbiz:url>/uiDisplayTypeWriteSql</ofbiz:url>" TARGET="headerFrame">
        <input type="hidden" name="displayTypeId" value="<%=displayTypeId%>">
        <input type="hidden" name="displayTypeName" value="<%=displayTypeName%>">
        <input type="hidden" value="writeSqlFile" name="action" >

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Display Type ID:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=displayTypeId%>
		 </TD>
        </TR>

        <TR>
         <TD CLASS="freeFormSectionLabel">
		  Display Type Name:
		 </TD>
		 <TD CLASS="freeFormSectionField">
		  <%=displayTypeName%>
		 </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.writeUiDisplayTypeFile(delegator, displayTypeId, filePath);
%>
        <TR>
		 <TD CLASS="freeFormSectionField" COLSPAN="2">
          <%=message%>
		 </TD>
        </TR>
<%
		return;
	}


%>

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