Changeset 1446

Timestamp:

11/01/15 23:13:16 (9 years ago)

Author:

nanardon

Message:

Report also hour to graph stat

Location:

trunk

Files:

• LATMOS-Accounts-Web/lib/LATMOS/Accounts/Web/Controller/Json/Stat.pm (modified) (1 diff)
• LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/Stat.pm (modified) (1 diff)

trunk/LATMOS-Accounts-Web/lib/LATMOS/Accounts/Web/Controller/Json/Stat.pm

@@ -60 +60 @@
     }
 
-    my $date = POSIX::strftime('%Y-%m-%d', localtime);
+    my $date = POSIX::strftime('%Y-%m-%d %H:%M', localtime);
     foreach my $val (sort keys %$res) {
         push(@{ $lines{$val} }, [ $date , $res->{$val} + 0 ]);

trunk/LATMOS-Accounts/lib/LATMOS/Accounts/Bases/Sql/Stat.pm

@@ -203 +203 @@
 
     my $sth = $self->db->prepare(q{
-        SELECT count, value, to_char(tstamp, 'YYYY-MM-DD') as d from statsentry join
+        SELECT count, value, to_char(tstamp, 'YYYY-MM-DD HH24:MI') as d from statsentry join
                       statvalues
             on statsentry.id = statvalues.sid