add zooming to graph
[scannr.git] / viewcalls.php
blob:a/viewcalls.php -> blob:b/viewcalls.php
--- a/viewcalls.php
+++ b/viewcalls.php
@@ -1,7 +1,16 @@
 <?php
 include('common.inc.php');
 $tgid = 44028;
+$from = (isset($_REQUEST['from']) ? $_REQUEST['from'] : strtotime("2012-09-12"));
+$to = (isset($_REQUEST['to']) ? $_REQUEST['to'] : strtotime("2012-12-12"));
 include_header("fdds");
+    $sth = $conn->prepare('select distinct date_trunc(\'day\', call_timestamp) as rdate from recordings order by rdate');
+
+    $sth->execute();
+    foreach( $sth->fetchAll() as $row) {
+echo '<a href="?from='.strtotime($row['rdate']).'&amp;to='.strtotime($row['rdate'].' +1 day').'">'.$row['rdate'].'</a> <br>';
+}
+
 ?>
 <div class="span12">
 
@@ -12,12 +21,19 @@
            var options = {
             lines: { show: true },
             points: { show: true },
-            xaxis: { mode: "time" },
+               xaxis : {
+                   mode : 'time',
+                   labelsAngle : 45
+               },
                selection : { mode : 'x', fps : 30 },
             series: {
                 lines: { show: true },
                 points: { show: true }
-            }
+            },
+               mouse : {
+                   track : true,
+                   relative : true
+               }
         };
         $(function () {
         // graph
@@ -32,7 +48,7 @@
 
                 // Draw graph with new area
                 graph = drawGraph({
-                    xaxis: {min:area.x1, max:area.x2},
+                    xaxis: {min:area.x1, max:area.x2, mode : 'time', labelsAngle : 45},
                     yaxis: {min:area.y1, max:area.y2}
                 });
             });
@@ -41,7 +57,7 @@
             Flotr.EventAdapter.observe(placeholder, 'flotr:click', function () { drawGraph(); });
 
                
-        getData('<?php echo $tgid; ?>','<?php echo strtotime("10/09/2012") ?>','<?php echo strtotime("10/11/2012") ?>');
+        getData('<?php echo $tgid; ?>','<?php echo $from ?>','<?php echo $to ?>');
         
     });
 
@@ -84,3 +100,4 @@
 <?php
 include_footer();
 ?>
+