/[SQLSession]/trunk/share/web/templates/fragments/queries
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 /trunk/share/web/templates/fragments/queries

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

revision 93 by dpavlin, Mon Feb 5 21:32:40 2007 UTC revision 94 by dpavlin, Mon Feb 5 22:04:59 2007 UTC
# Line 29  my $sort_menu = Jifty::Web::Menu->new( l Line 29  my $sort_menu = Jifty::Web::Menu->new( l
29  foreach my $c ( qw/name created_on owner/ ) {  foreach my $c ( qw/name created_on owner/ ) {
30          #next if ($c eq $order);          #next if ($c eq $order);
31          $sort_menu->child( $c,          $sort_menu->child( $c,
32                  #active => $c eq $order,                  active => $c eq $order,
33                  link => Jifty->web->link(                  link => Jifty->web->link(
34                          label => $sort_label->{$c},                          label => $sort_label->{$c},
35                          onclick => {                          onclick => {
# Line 60  $date_menu->child( 'clear', Line 60  $date_menu->child( 'clear',
60  ) if ($created_on);  ) if ($created_on);
61    
62  # select created_on,count(date(created_on)) from queries group by date(created_on) order by created_on;  # select created_on,count(date(created_on)) from queries group by date(created_on) order by created_on;
63  my $date_coll = SQLSession::Model::QueryCollection->new();  my $date_coll = SQLSession::Model::QueryCollection->new( results_are_readable => 1 );
64  my $created_on_date = $date_coll->column( function => 'date(created_on)', column => 'date' );  my $created_on_date = $date_coll->column( function => 'date(created_on)', column => 'date' );
65  my $count = $date_coll->column( function => 'count(date(created_on))', column => 'count' );  my $count = $date_coll->column( function => 'count(date(created_on))', column => 'count' );
66  $date_coll->group_by( function => $created_on_date );  $date_coll->group_by( function => $created_on_date );
Legend:
Removed from v.93  
changed lines
  Added in v.94
  ViewVC Help
Powered by ViewVC 1.1.26