/[A3C]/lib/A3C/View.pm
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /lib/A3C/View.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 119 by dpavlin, Sat Apr 12 10:29:30 2008 UTC revision 120 by dpavlin, Thu May 15 19:08:08 2008 UTC
# Line 13  template '/' => page { Line 13  template '/' => page {
13    
14          h1 { _('Statistics') }          h1 { _('Statistics') }
15    
16          my $orgs = A3C::Model::OrganizationCollection->new;          my $orgs = A3C::Model::hrEduOrgCollection->new;
17          $orgs->unlimit;          $orgs->unlimit;
18    
19          dt { _('Number of schools in system') }          dt { _('Number of schools in system') }
20          dd { $orgs->count }          dd { $orgs->count }
21    
22          my $people = A3C::Model::PersonCollection->new;          my $people = A3C::Model::hrEduPersonCollection->new;
23          $people->unlimit;          $people->unlimit;
24    
25          dt { _('Number of persons in system') }          dt { _('Number of persons in system') }
# Line 27  template '/' => page { Line 27  template '/' => page {
27    
28          my $by_towns = A3C::SQL->new({ query => qq{          my $by_towns = A3C::SQL->new({ query => qq{
29                  select count(uid),l                  select count(uid),l
30                  from organizations                  from hr_edu_orgs
31                  inner join towns on towns.name = l                  inner join towns on towns.name = l
32                  group by l                  group by l
33                  order by count desc                  order by count desc
# Line 48  template '/' => page { Line 48  template '/' => page {
48                          count(uid) as schools,                          count(uid) as schools,
49                          county,                          county,
50                          count(distinct municipality) as municipalities                          count(distinct municipality) as municipalities
51                  from organizations                  from hr_edu_orgs
52                  inner join towns on towns.name = l                  inner join towns on towns.name = l
53                  group by county                  group by county
54                  order by schools desc                  order by schools desc
Legend:
Removed from v.119  
changed lines
  Added in v.120
  ViewVC Help
Powered by ViewVC 1.1.26