<?php
    $dbhost = 'xxx.xxx.xxx.net';    // MySQL Server
    $dbuser = 'xxxx';        // Username
    $dbpass = 'xxxx';        // Password
    $dbroot = 'xxxx';        // DB Name

    session_start();
echo $_SESSION ['list']; // first session
    $host = mysql_connect($dbhost, $dbuser, $dbpass);
    if (mysql_select_db($dbroot,$host))
    {
        if (isset($_REQUEST["submit"]))
        {
            $sql = "SELECT * FROM `shifts` WHERE `id` = '" . $_REQUEST["shift"] . "'";
            $Result = mysql_query($sql);
            if (mysql_num_rows($Result) == 1)
            {
                $row = mysql_fetch_array($Result);
                $sql2 = "UPDATE `extensions` SET `appdata` = '" . $row["appdata"] . "' WHERE `context` = 'ivr-1' AND `exten` = 'tod-support' AND `priority` = '1';";
                $Result2 = mysql_query($sql2);
//                print '<font color=red>Updated ' . date('H:i:s m/d/Y') . ' </font><br>';
                header('location:index.php');
            } else {
                print 'A problem has occurred.  Something is broke.';
            }

        }

        
        print '<form method=POST>';
        print '<table align=center style="border: 1px solid #DDD; border-collapse: collapse;">';
        print '<tr><th style="background: #ABC; padding: 5px;" colspan=2>Update the PBX Routing</th></tr>';
        $sql = "SELECT * FROM `shifts` WHERE 1;";
        $Result = mysql_query($sql);
        while ($row = mysql_fetch_array($Result))
        {
            $sql2 = "SELECT * FROM `extensions` WHERE `appdata` = '" . $row["appdata"] . "'";
            $Result2 = mysql_query($sql2);
            print '<tr><td style="padding: 0 0 0 1em;"><input type=radio name=shift value="' . $row["id"] . '"';
            if (mysql_num_rows($Result2) == 1) { echo ' CHECKED'; }
            print '></td><td style="padding: 0 1em 0 0;">' . $row["description"] . '</td></tr>';
            
        }
echo $_SESSION ['last 24']; // second session
if ($_SERVER['REQUEST_METHOD'] == 'POST')
    {
        if (preg_match('/^[1-9][0-9]?[0-9]?$/',$_POST["howfarback"]))
        {
            $howfarback = $_POST["howfarback"] * 24;
        } else
        {
            die('Number of days must be 1 - 999.');
        }
    } else $howfarback = 24;


    $cdr_start_time = time() - ($howfarback*60*60); // how far back to display
    $cdr_start_time_formatted = date('n/j/y g:i:sA',$cdr_start_time);
    $cdr_start_time_mysql = date(YmdHis,$cdr_start_time);
        
        print '<tr><td colspan=2 align=center style="padding: 1em;">';
        print '<input type=submit name=submit value="Submit">';
        print '</td></tr>';
        print '</table>';
        print '</form>';
        print '<table id="table_cdr" align="center" border="0" cellpadding="2" cellspacing="1">';
        print '<tr><center><th style="background: #ABC; padding: 5px;" colspan=2>Call Log - From ';
        echo $cdr_start_time_formatted;
        print '</th></tr></center>'; print "\n";
        print '<tr><th>Date</th><th>CallerID</th><th>Destination Context</th><th>Destination Extension</th><th colspan=2>Last Command</th><th>Duration Seconds</th><th>Status</th></tr>'; print "\n";

        $sql1 = "SELECT calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,disp
osition,accountcode FROM `cdr` WHERE calldate >=$cdr_start_time_mysql;";
        $Result1 = mysql_query($sql1);
        
        {
            print '<tr>';
            print '<td bgcolor="#E5E5E5" style="padding: 2px;">' . $row["calldate"] . '</td>';
            print '<td bgcolor="#E5E5E5" style="padding: 2px;">' . $row["clid"] . '</td>';
            print '<td bgcolor="#E5E5E5" style="padding: 2px;">' . $row["dcontext"] . '</td>';
            print '<td bgcolor="#E5E5E5" style="padding: 2px;">' . $row["dst"] . '</td>';
            print '<td bgcolor="#E5E5E5" style="padding: 2px;">' . $row["lastapp"] . '</td>';
            print '<td bgcolor="#E5E5E5" style="padding: 2px;">' . $row["lastdata"] . '</td>';
            print '<td bgcolor="#E5E5E5" style="padding: 2px;">' . $row["duration"] . '</td>';
            print '<td bgcolor="#E5E5E5" style="padding: 2px;">' . $row["disposition"] . '</td>';
            print '</tr>'; print "\n";
        }

        print '<tr><td colspan=2 align=center style="padding: 1em;">';
        print '</td></tr>';
        print '</table>';
        print '<center>';
        print '<form method="POST" action="cdr.php">';
        print 'Display <input maxlength=3 size=2 name=howfarback value=""> ';
        print '<input type="submit" name="submit" value="days back"></form>';

        print '<A HREF="cdr.php">Call Log</A>';
        print '</center>';
    }
    else
    {
        print 'Cannot connect to the database server.';
    }

?>
<!-- vim:ts=4:sw=4
--!>