editentity.jsp

Sequoia ERP是一个真正的企业级开源ERP解决方案。它提供的模块包括：电子商务应用(e-commerce), POS系统(point of sales),知识管理,存货与仓库管理

<BR>

<FORM method="post" action='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&event=updateEntity</ofbiz:url>' style='margin: 0;'>
  <TABLE>
  <TR>
    <TD>Entity Name</TD>
    <TD><%=entityName%></TD>
  </TR>
  <TR>
    <TD>Table Name</TD>
    <TD><%=(modelViewEntity == null) ? entity.getPlainTableName() : "What table name? This is a VIEW Entity."%></TD>
  </TR>
  <%if (modelViewEntity == null) {%>
    <TR>
      <TD>Table Name</TD>
      <TD><INPUT type="text" class='inputBox' size='60' name='tableName' value='<%=UtilFormatOut.checkNull(entity.getPlainTableName())%>'></TD>
    </TR>
  <%}%>
  <TR>
    <TD>Package Name</TD>
    <TD><INPUT type="text" class='inputBox' size='60' name='packageName' value='<%=entity.getPackageName()%>'></TD>
  </TR>
  <TR>
    <TD>Dependent On Entity</TD>
    <TD>
      <SELECT name='dependentOn' class='selectBox'>
        <OPTION selected><%=entity.getDependentOn()%></OPTION>
        <OPTION></OPTION>
        <%Iterator depIter = entSet.iterator();%>
        <%while (depIter.hasNext()) {%>
          <OPTION><%=(String)depIter.next()%></OPTION>
        <%}%>
      </SELECT>
    </TD>
  </TR>
  <TR>
    <TD>Title</TD>
    <TD><INPUT type="text" class='inputBox' size='60' name='title' value='<%=entity.getTitle()%>'></TD>
  </TR>
  <TR>
    <TD>Description</TD>
    <TD><TEXTAREA cols='60' class='textAreaBox' rows='5' name='description'><%=entity.getDescription()%></TEXTAREA></TD>
  </TR>
  <TR>
    <TD>Copyright</TD>
    <TD><INPUT type="text" class='inputBox' size='60' name='copyright' value='<%=entity.getCopyright()%>'></TD>
  </TR>
  <TR>
    <TD>Author</TD>
    <TD><INPUT type="text" class='inputBox' size='60' name='author' value='<%=entity.getAuthor()%>'></TD>
  </TR>
  <TR>
    <TD>Version</TD>
    <TD><INPUT type="text" class='inputBox' size='60' name='version' value='<%=entity.getVersion()%>'></TD>
  </TR>
  <TR>
    <TD>Group</TD>
    <TD>
      <INPUT type="text" class='inputBox' size='60' name='entityGroup' value='<%=UtilFormatOut.checkNull(delegator.getModelGroupReader().getEntityGroupName(entityName))%>'>
      <BR>(This group is for the "<%=delegator.getDelegatorName()%>" delegator)
    </TD>
  </TR>
  <%boolean isFile = entityResourceHandler == null ? true : entityResourceHandler.isFileResource();%>
  <TR>
    <TD>Resource Loader</TD>
    <TD><INPUT type="text" class='inputBox' size='20' name='loaderName' value='<%=entityResourceHandler == null ? "" : UtilFormatOut.checkNull((String) entityResourceHandler.getLoaderName())%>'<%if(!isFile){%> disabled<%}%>></TD>
  </TR>
  <TR>
    <TD>Location</TD>
    <TD><INPUT type="text" class='inputBox' size='60' name='location' value='<%=entityResourceHandler == null ? "" : UtilFormatOut.checkNull((String) entityResourceHandler.getLocation())%>'<%if(!isFile){%> disabled<%}%>></TD>
  </TR>
  </TABLE>
  <INPUT type="submit" value='Update Entity'>
</FORM>

<HR>
<%if (modelViewEntity == null) {%>
<B>FIELDS</B>
  <TABLE border='1' cellpadding='2' cellspacing='0'>
    <TR><TD>Field Name</TD><TD>Column Name (Length)</TD><TD>Field Type</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR>
    <%for (int f = 0; f < entity.getFieldsSize(); f++) {%>
      <%ModelField field = entity.getField(f);%>
      <TR>
        <TD><%=field.getIsPk()?"<B>":""%><%=field.getName()%><%=field.getIsPk()?"</B>":""%></TD>
        <TD><%=field.getColName()%> (<%=field.getColName().length()%>)</TD>
        <TD><%=field.getType()%></TD>
        <TD>
          <FORM method="post" action='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&fieldName=<%=field.getName()%>&event=updateField</ofbiz:url>' style='margin: 0;'>
            <INPUT type="checkbox" name='primaryKey'<%=field.getIsPk()?" checked":""%>>
            <SELECT name='fieldType' class='selectBox'>
              <OPTION selected><%=field.getType()%></OPTION>
              <%Iterator iter = UtilMisc.toIterator(types);%>
              <%while (iter != null && iter.hasNext()){ String typeName = (String)iter.next();%>
                <OPTION><%=typeName%></OPTION>
              <%}%>
            </SELECT>
            <INPUT type="submit" value='Set'>
          </FORM>
        </TD>
        <TD><A href='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&fieldName=<%=field.getName()%>&event=removeField</ofbiz:url>'>Remove</A></TD>
      </TR>
    <%}%>
  </TABLE>

<FORM method="post" action='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&event=addField</ofbiz:url>'>
  Add new field with <u>Field Name (Java style)</u> and field type.<BR>
  <INPUT type="text" class='inputBox' size='40' maxlength='30' name='name'>
  <SELECT name='fieldType' class='selectBox'>
    <%Iterator iter = UtilMisc.toIterator(types);%>
    <%while (iter != null && iter.hasNext()){ String typeName = (String)iter.next();%>
      <OPTION><%=typeName%></OPTION>
    <%}%>
  </SELECT>
  <INPUT type="submit" value="Create">
</FORM>
<%} else {%>

<B>VIEW MEMBER ENTITIES</B>
  <TABLE border='1' cellpadding='2' cellspacing='0'>
    <TR><TD>Entity Alias</TD><TD>Entity Name</TD><TD>&nbsp;</TD></TR>
    <%Iterator memberEntityNamesIter = UtilMisc.toIterator(modelViewEntity.getMemberModelMemberEntities().entrySet());%>
    <%while (memberEntityNamesIter != null && memberEntityNamesIter.hasNext()) {%>
      <%Map.Entry aliasEntry = (Map.Entry) memberEntityNamesIter.next();%>
      <%ModelViewEntity.ModelMemberEntity modelMemberEntity = (ModelViewEntity.ModelMemberEntity) aliasEntry.getValue();%>
      <TR>
        <TD><%=modelMemberEntity.getEntityAlias()%></TD>
        <TD><%=modelMemberEntity.getEntityName()%></TD>
        <TD><A href='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&alias=<%=(String) aliasEntry.getKey()%>&event=removeMemberEntity</ofbiz:url>'>Remove</A></TD>
      </TR>
    <%}%>
  </TABLE>

<FORM method="post" action='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&event=addMemberEntity</ofbiz:url>'>
  Add new member entity with <u>Entity Alias*</u> and <u>Entity Name*</u>.<BR>
  <INPUT type="text" class='inputBox' size='10' name='alias'>
  <SELECT name='aliasedEntityName' class='selectBox'>
    <OPTION selected>&nbsp;</OPTION>
    <%Iterator entIter = entSet.iterator();%>
    <%while (entIter.hasNext()) {%>
      <OPTION><%=(String)entIter.next()%></OPTION>
    <%}%>
  </SELECT>
  <INPUT type="submit" value='Add'>
</FORM>

<HR>
<B>VIEW ALIASES</B>

<HR>
<B>VIEW LINKS</B>

<div>NOTE: Editing not yet completed for view entities, try again later (or just edit the XML by hand, and not at the same time you are editing here...)</div>
<%--
    <!ELEMENT view-entity ( description?, member-entity+, alias+, view-link+, relation* )>
    <!ELEMENT member-entity EMPTY>
    <!ATTLIST member-entity
	entity-alias CDATA #REQUIRED
	entity-name CDATA #REQUIRED >
    <!ELEMENT alias EMPTY>
    <!ATTLIST alias
	entity-alias CDATA #REQUIRED
	name CDATA #REQUIRED
	field CDATA #IMPLIED
	prim-key CDATA #IMPLIED
	group-by ( true | false ) "false"
	function ( min | max | sum | avg | count | count-distinct | upper | lower ) #IMPLIED>
    <!ELEMENT view-link ( key-map+ )>
    <!ATTLIST view-link
	entity-alias CDATA #REQUIRED
	rel-entity-alias CDATA #REQUIRED >
--%>

<%}%>
<HR>

<B>RELATIONSHIPS</B>
  <TABLE border='1' cellpadding='2' cellspacing='0'>
  <%for (int r = 0; r < entity.getRelationsSize(); r++) {%>
    <%ModelRelation relation = entity.getRelation(r);%>
    <%ModelEntity relEntity = reader.getModelEntity(relation.getRelEntityName());%>
    <tr bgcolor='#CCCCFF'>
      <FORM method="post" action='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&event=updateRelation&relNum=<%=r%></ofbiz:url>'>
        <td align="left"><%=relation.getTitle()%><A class='listtext' href='<ofbiz:url>/view/EditEntity?entityName=<%=relation.getRelEntityName()%></ofbiz:url>'><%=relation.getRelEntityName()%></A></td>
        <td>
          <INPUT type=TEXT class='inputBox' name='title' value='<%=relation.getTitle()%>'>
          <INPUT type=TEXT class='inputBox' name='fkName' value='<%=relation.getFkName()%>' size='18' maxlength='18'>
          <SELECT name='type' class='selectBox'>
            <OPTION selected><%=relation.getType()%></OPTION>
            <OPTION>&nbsp;</OPTION>
            <OPTION>one</OPTION>
            <OPTION>one-nofk</OPTION>
            <OPTION>many</OPTION>
          </SELECT>
        </td>
        <td>
          <INPUT type=SUBMIT value='Set'>
        </td>
        <TD><A href='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&relNum=<%=r%>&event=removeRelation</ofbiz:url>'>Remove</A></TD>
        <TD><A href='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&relNum=<%=r%>&event=addKeyMap</ofbiz:url>'>Add&nbsp;KeyMap</A></TD>
        <TD><A href='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&relNum=<%=r%>&event=addReverse</ofbiz:url>'>Add&nbsp;Reverse</A></TD>
      </FORM>
    </tr>
    <%for (int km=0; km<relation.getKeyMapsSize(); km++){ ModelKeyMap keyMap = (ModelKeyMap)relation.getKeyMap(km);%>
      <tr>
        <FORM method="post" action='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&event=updateKeyMap&relNum=<%=r%>&kmNum=<%=km%></ofbiz:url>'>
          <td></td>
          <td colspan='2'>
            Main:
            <SELECT name='fieldName' class='selectBox'>
              <OPTION selected><%=keyMap.getFieldName()%></OPTION>
              <OPTION>&nbsp;</OPTION>
              <%for (int fld=0; fld<entity.getFieldsSize(); fld++) {%>
                <OPTION><%=entity.getField(fld).getName()%></OPTION>
              <%}%>
            </SELECT>
            Related:
            <SELECT name='relFieldName' class='selectBox'>
              <OPTION selected><%=keyMap.getRelFieldName()%></OPTION>
              <OPTION>&nbsp;</OPTION>
              <%for (int fld=0; fld<relEntity.getFieldsSize(); fld++) {%>
                <OPTION><%=relEntity.getField(fld).getName()%></OPTION>
              <%}%>
            </SELECT>
          </td>
          <td>
            <INPUT type=SUBMIT value='Set'>
          </td>          
          <TD><A href='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&relNum=<%=r%>&kmNum=<%=km%>&event=removeKeyMap</ofbiz:url>'>Remove</A></TD>
        </FORM>
      </tr>
    <%}%>			
  <%}%>
  </TABLE>

<FORM method="post" action='<ofbiz:url>/view/EditEntity?entityName=<%=entityName%>&event=addRelation</ofbiz:url>'>
  Add new relation with <u>Title</u>, <u>FK Name</u>, <u>Related Entity Name*</u> and <u>Relation Type*</u>.<BR>
  <INPUT type="text" class='inputBox' size='30' maxlength='30' name='title'>
  <INPUT type="text" class='inputBox' size='20' maxlength='18' name='fkName'>
  <%-- <INPUT type="text" size='40' maxlength='30' name='relEntityName'> --%>
  <SELECT name='relEntityName' class='selectBox'>
    <OPTION selected>&nbsp;</OPTION>
    <%Iterator entIter = entSet.iterator();%>
    <%while (entIter.hasNext()) {%>
      <OPTION><%=(String)entIter.next()%></OPTION>
    <%}%>
  </SELECT>
  <SELECT name='type' class='selectBox'>
    <OPTION>one</OPTION>
    <OPTION>one-nofk</OPTION>
    <OPTION>many</OPTION>
  </SELECT>
  <INPUT type="submit" value='Create'>
</FORM>

<%}%>
<%} else {%>
<H3>Entity Editor</H3>

ERROR: You do not have permission to use this page (ENTITY_MAINT needed)
<%}%>