[mhk] r998 committed - Adds functions to explore page.

[codesite...@google.com]

Revision: 998
Author: jmnca...@gmail.com
Date: Mon May 2 04:11:48 2011
Log: Adds functions to explore page.
http://code.google.com/p/mhk/source/detail?r=998

Modified:
/trunk/idb/etc/template/new/explore.vm
/trunk/idb/pt/uc/cisuc/jrc/mhk/resources/MHKStrings.properties
/trunk/idb/pt/uc/cisuc/jrc/mhk/resources/MHKStrings_pt.properties

=======================================
--- /trunk/idb/etc/template/new/explore.vm Mon Jan 17 08:15:34 2011
+++ /trunk/idb/etc/template/new/explore.vm Mon May 2 04:11:48 2011
@@ -53,13 +53,20 @@
$attribute.the_type</a>^{<a title="$mhks.get('show.all.results.with')
$attribute.the_type"
href="$resp.encodeURL("${uri}?dbname=$!dbname&action=exec&script=attribute_count_show.vm&the_type=$attribute.the_type")">$attribute.n</a>}
#end

+<h3 class="separator">$mhks.get('$functions')</h3>
+#set($functions=$database.search("select func, count(*) as n from nfuncs
group by func order by func"))
+#foreach($function in $functions)
+ #set($tmpurl="${uri}?dbname=$!dbname&action=query&sql=select
id,name,func,act_date from nfuncs where func='$function.func' order by
name")
+ <a class="no_sub_exp" title="$mhks.get('show.all')"
href="$resp.encodeURL("$tmpurl")">$function.func</a>^$function.n
&nbsp;
+#end
+
<h3 class="separator">$mhks.get('relations')</h3>
#set($relations=$database.search("select the_type, count(*) as n from
relations group by the_type order by the_type"))
#foreach($relation in $relations)
- #if( !$relation.the_type.equalsIgnoreCase("identification")
&& !$relation.the_type.equals("function-in-act"))
- <a class="no_sub_exp" title="$mhks.get('show.all')"
href="$resp.encodeURL("${uri}?dbname=$!dbname&action=query&type=$relation.the_type&sql=select
the_value,count(*) as relation_value_count from relations where
the_type='$relation.the_type' group by the_value order by the_value")">
- $relation.the_type</a>^{<a title="$mhks.get('show.all.results.with')
$attribute.the_type"
href="$resp.encodeURL("${uri}?dbname=$!dbname&action=exec&script=relation_count_show.vm&the_type=$relation.the_type")">$relation.n</a>}
-#end
+ #if( !$relation.the_type.equalsIgnoreCase("identification")
&& !$relation.the_type.equals("function-in-act"))
+ <a class="no_sub_exp" title="$mhks.get('show.all')"
href="$resp.encodeURL("${uri}?dbname=$!dbname&action=query&type=$relation.the_type&sql=select
the_value,count(*) as relation_value_count from relations where
the_type='$relation.the_type' group by the_value order by the_value")">
+ $relation.the_type</a>^{<a title="$mhks.get('show.all.results.with')
$attribute.the_type"
href="$resp.encodeURL("${uri}?dbname=$!dbname&action=exec&script=relation_count_show.vm&the_type=$relation.the_type")">$relation.n</a>}
+ #end
#end

#set($geoentities=$database.search("SELECT id as rid, description as name,
user FROM rentities where the_class='rgeoentity' and
user='$db.getMhkAdmin()' order by description"))
=======================================
--- /trunk/idb/pt/uc/cisuc/jrc/mhk/resources/MHKStrings.properties Mon Mar
21 05:34:25 2011
+++ /trunk/idb/pt/uc/cisuc/jrc/mhk/resources/MHKStrings.properties Mon May
2 04:11:48 2011
Binary file, no diff available.
=======================================
--- /trunk/idb/pt/uc/cisuc/jrc/mhk/resources/MHKStrings_pt.properties Mon
Mar 21 05:34:25 2011
+++ /trunk/idb/pt/uc/cisuc/jrc/mhk/resources/MHKStrings_pt.properties Mon
May 2 04:11:48 2011
Binary file, no diff available.