#!/usr/bin/php5
<?
if (isset($argv[1]) && $argv[1] == "autoconf") {
        echo "yes\n";
        exit(0);
}
if (isset($argv[1]) && $argv[1] == "config") {
        echo "graph_title Asterisk Last Hour\n";
        echo "graph_args --base 1000 -l 0\n";
        echo "graph_vlabel Calls In Last Hour\n";
        echo "graph_category asterisk\n";
        echo "answered.label Answered Calls\n";
        echo "busy.label Busy Calls\n";
        echo "failed.label Failed Calls\n";
        echo "noanswer.label No Answer Calls\n";
        exit (0);
}
$sql = "select count(*) as count, disposition from phoneDB.cdr where calldate > DATE_SUB(NOW(),INTERVAL 60 MINUTE) group by disposition";
$connection = mysql_connect("localhost","root","");
$result = mysql_query($sql);
$answered = 0;
$busy = 0;
$failed = 0;
$noanswer = 0;
if (mysql_num_rows($result) > 0) {
        while ($row = mysql_fetch_assoc($result)) {
                switch($row['disposition']) {
                        case "ANSWERED":
                                $answered = $row['count'];
                                break;
                        case "BUSY":
                                $busy = $row['count'];
                                break;
                        case "FAILED":
                                $failed = $row['count'];
                                break;
                        case "NO ANSWER":
                                $noanswer = $row['count'];
                                break;
                }
        }
}
echo "answered.value $answered\n";
echo "busy.value $busy\n";
echo "failed.value $failed\n";
echo "noanswer.value $noanswer\n";
?>