1 |
package A3C::View::Strix; |
2 |
|
3 |
=head1 NAME |
4 |
|
5 |
A3C::View::Strix |
6 |
|
7 |
=head1 DESCRIPTION |
8 |
|
9 |
Display information about Strix sites |
10 |
|
11 |
=cut |
12 |
|
13 |
use strict; |
14 |
use warnings; |
15 |
|
16 |
use Jifty::View::Declare -base; |
17 |
use Data::Dump qw/dump/; |
18 |
|
19 |
template 'index.html' => page { |
20 |
|
21 |
h1 { _('Statistics') } |
22 |
|
23 |
my $orgs = A3C::Model::StrixSiteCollection->new; |
24 |
$orgs->unlimit; |
25 |
|
26 |
dt { _('Number of Strix sites') } |
27 |
dd { $orgs->count } |
28 |
|
29 |
my $name_diff = A3C::SQL->new({ query => qq{ |
30 |
select |
31 |
site,hreduorgurl, |
32 |
_site_name,o |
33 |
from strix_sites |
34 |
join hr_edu_orgs on cn = site |
35 |
where o != _site_name |
36 |
}}); |
37 |
|
38 |
h1 { _('Name differences') } |
39 |
dd { |
40 |
table { |
41 |
row { |
42 |
th { _('Site') } |
43 |
th { _('Strix site name') } |
44 |
th { _('hrEduOrg.o') } |
45 |
}; |
46 |
while ( my $row = $name_diff->next ) { |
47 |
row { |
48 |
cell { hyperlink( url => 'http://' . $row->hreduorgurl, label => $row->site ) } |
49 |
cell { $row->_site_name } |
50 |
cell { $row->o } |
51 |
} |
52 |
} |
53 |
} |
54 |
} |
55 |
|
56 |
}; |
57 |
|
58 |
1; |