--- 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']).'&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(); ?> +