--- lib/A3C/View.pm	2008/04/10 21:33:37	71
+++ lib/A3C/View.pm	2008/04/10 23:16:56	72
@@ -8,6 +8,52 @@
 
 use Data::Dump qw/dump/;
 
+template '/' => page {
+
+	h1 { _('Statistics') }
+
+	my $orgs = A3C::Model::OrganizationCollection->new;
+	$orgs->unlimit;
+
+	dt { _('Number of schools in system') }
+	dd { $orgs->count }
+
+	my $people = A3C::Model::PersonCollection->new;
+	$people->unlimit;
+
+	dt { _('Number of persons in system') }
+	dd { $people->count }
+
+=for later
+
+	dt { _('Breakdown by towns') }
+	dd {
+		$orgs->redo_search;
+		# select count(l),l from organizations group by l order by count desc limit 25
+		$orgs->group_by( column => 'l' );
+		$orgs->order_by( column => 'l', order => 'desc' );
+
+		warn "## SQL: ", $orgs->build_select_query;
+		my $count = $orgs->column( column => 'l', function => 'count(l)' );
+		warn "## count: $count\n";
+#		$orgs->column( column => 'l' );
+		warn "## SQL: ", $orgs->build_select_query;
+
+		ul {
+			for ( 1 .. 1 ) {
+				my $o = $orgs->next;
+				warn "## ",dump( $o );
+				li { outs ( $o->l, '|', $o->__value('l'), $o->__value( $count ) ) }
+			}
+		}
+
+
+	}
+
+=cut
+
+};
+
 
 template 'ldap' => page {
 	h1 { _('LDAP data about Schools in system') };