Changeset 2001

Timestamp:

06/21/09 23:18:34 (3 years ago)

Author:

mswertz

Message:

feature: add 'mref' filter to getSystemRules to show related entities for parent form based on mref relationships.
cleanup: simpflified the 'xref' filter in getSystemRules.

File:

• molgenis3_3/src/org/molgenis/generators/screen/FormScreenGen.java.ftl (modified) (4 diffs)

molgenis3_3/src/org/molgenis/generators/screen/FormScreenGen.java.ftl

@@ -37 +37 @@
 
 // molgenis
+import org.molgenis.framework.data.QueryRule.Operator;
 import org.molgenis.framework.data.QueryRule;
 import org.molgenis.framework.screen.Screen;
 import org.molgenis.framework.screen.form.FormScreen;
 import org.molgenis.framework.html.*;
+import org.molgenis.framework.data.DatabaseException;
 
 ${imports(model,model.getEntity(entity),"data.types")}
@@ -46 +48 @@
 
 <#if parent_form?exists>
-        <#list form.getRecord().getAllFields() as field>
-                <#if field.getType().toString() = "xref">
-                        <#--check parent record. FIXME: move to model as parent_child relationships-->  
-                        <#assign parent_xref = false>
-                        <#list superclasses(parent_form.getRecord()) as parent_entity>
-                                <#if parent_entity.getName() == field.getXRefEntity()>
-                                        <#assign parent_xref = true/>
-                                </#if>
-                        </#list>
-                
-                        <#if parent_xref>
-                                <#assign xref_entity = model.getEntity(field.getXRefEntity())>
-import ${xref_entity.getNamespace()}.data.types.${Name(xref_entity)};
-                        </#if>
-                </#if>
-        </#list>
+<#assign xref_entity = parent_form.getRecord()>
+import ${xref_entity.getNamespace()}.data.types.${JavaName(xref_entity)};
 </#if>
 
@@ -184 +172 @@
         {
                 List<QueryRule> rules = new ArrayList<QueryRule>();
+                
+<#assign parent_xref = false>           
 <#if parent_form?exists>
-        <#list form.getRecord().getAllFields() as field>
-                <#if field.getType().toString() = "xref">
-                        <#--check parent record. FIXME: move to model as parent_child relationships-->  
-                        <#assign parent_xref = false>
-                        <#list superclasses(parent_form.getRecord()) as parent_entity>
-                                <#if parent_entity.getName() == field.getXRefEntity()>
-                                        <#assign parent_xref = true/>
-                                </#if>
-                        </#list>
-                
-                        <#if parent_xref>
-                                <#assign xrefentity = Name(field.getXRefEntity())>
+<#assign xrefentity = Name(parent_form.getRecord())>
                 FormScreen<${xrefentity}> parent = (FormScreen<${xrefentity}>)this.get("${parent_form.getVelocityName()}");
                 List<${xrefentity}> records = parent.getRecords();
+        
+                //add filters for xref or mref relationships (if any)
+                //if multiple xrefs apply then the filters are union (so xref1 OR xref2 OR etc)
                 if(records.size()>0)
-                {
-                        <#if form.isEmbedchild()>
-                        if (this.getMode() == Mode.EMBEDDED_VIEW)
-                        {
-                                List<Object> ids = new ArrayList<Object>();
-                                for(${form.getEmbedparentname()} record: records)
+                {               
+                        List<QueryRule> xref_filters = new ArrayList<QueryRule>();
+<#-- subform to parent form xrefs:-->
+<#list form.getRecord().getAllFields() as field>
+        <#--if subform entity refers to parent form entity: show only records that point to parent record-->
+        <#--if multiple references exist, then use union, so 'OR' in query rule-->
+        <#if field.getType() == "xref" || field.getType() == "mref">
+                <#list superclasses(parent_form.getRecord()) as parent_entity>
+                        <#if parent_entity.getName() == field.getXRefEntity()>
+                        //filter on <#if field.getType() == "mref">ANY </#if>subform_entity.${name(field)} == parentform_entity.${field.getXRefField()}
+                        {       
+                                QueryRule rule = new QueryRule("${SqlName(field)}",QueryRule.Operator.EQUALS, records.get(0).get${JavaName(field.getXRefField())}());
+                                rule.setOr(true);
+                                xref_filters.add(rule);
+                        }
+                        </#if>
+                </#list>
+        </#if>
+</#list>
+<#--parent to subform xrefs-->          
+<#list parent_form.getRecord().getAllFields() as field>
+        <#--if parent entity refers to subform form entity: show only records that are pointed to by parent record-->
+        <#--if multiple references exist, then use union, so 'OR' in query rule-->
+        <#if field.getType() == "xref" || field.getType() == "mref">
+                <#list superclasses(form.getRecord()) as subform_entity>
+                        <#if subform_entity.getName() == field.getXRefEntity()>
+                        //filter on <#if field.getType() == "mref">ANY </#if>parentform_entity.${name(field)} == subform_entity.${field.getXRefField()}
+                        {       
+                                QueryRule rule = null;
+                                if( records.get(0).get${JavaName(field)}()<#if field.getType() == "mref">.size() > 0<#else>!= null</#if>)
                                 {
-                                        ids.add(record.get${Name(form.getEmbedparentfield())}());
+                                        rule = new QueryRule("${SqlName(field.getXRefField())}",QueryRule.Operator.<#if field.getType() == "mref">IN<#else>EQUALS</#if>, records.get(0).get${JavaName(field)}());
                                 }
-                                QueryRule rule = new QueryRule("${form.getEmbedchildfield()}",QueryRule.Operator.IN, ids.toArray());
-                                rules.add(rule);
+                                else
+                                {
+                                        //disable all results by impossible condition
+                                        rule = new QueryRule("${SqlName(field.getXRefField())}",QueryRule.Operator.EQUALS, Integer.MIN_VALUE);
+                                }
+                                rule.setOr(true);
+                                xref_filters.add(rule);
                         }
-                        else
                         </#if>
-                        {
-                                QueryRule rule = new QueryRule("${name(field)}",QueryRule.Operator.EQUALS, records.get(0).get${Name(field.getXRefField())}());
-                                rules.add(rule);
-                        }
-                }
-                        <#break>
-                        </#if>
-                </#if>
-        </#list>        
+                </#list>
+        </#if>
+</#list>
+                        rules.add(new QueryRule(xref_filters));
+                }       
 </#if>
 <#if form.isFilter()>
+                //add predefined form filter
                 {
                         QueryRule rule = new QueryRule("${form.getFilterfield()}", QueryRule.Operator.${form.getFiltertype()}, "${form.getFiltervalue()}");
@@ -246 +253 @@
 </#list>
         }
-        
+
+        @Override       
         public String getSearchField(String fieldName)
         {
 <#list form.getRecord().getAllFields() as field>
-        <#if field.type="xref">
+        <#if field.type="xref" || field.type="mref">
                 if(fieldName.equals("${name(field)}")) return "${name(field)}_${name(field.getXRefLabelString())}";
         </#if>