<?php

function array_sort($array, $on, $order=SORT_ASC)
{
    $new_array = array();
    $sortable_array = array();

    if (count($array) > 0) {
        foreach ($array as $k => $v) {
            if (is_array($v)) {
                foreach ($v as $k2 => $v2) {
                    if ($k2 == $on) {
                        $sortable_array[$k] = $v2;
                    }
                }
            } else {
                $sortable_array[$k] = $v;
            }
        }

        switch ($order) {
            case SORT_ASC:
                asort($sortable_array);
            break;
            case SORT_DESC:
                arsort($sortable_array);
            break;
        }

        foreach ($sortable_array as $k => $v) {
            $new_array[$k] = $array[$k];
        }
    }

    return $new_array;
}

$link = mysql_connect("localhost", "USER", "PASSWORD");
mysql_select_db("agent", $link);

$result = mysql_query("SELECT * FROM teacher JOIN (site) ON teacher.site_id = site.id ORDER BY site.name, teacher.last_name", $link);
$i = 0;
while($row = mysql_fetch_array($result)){

$teacher_pull = "SELECT teacher.first_name, teacher.last_name, site.passkey, site.name, logon_history.logon_time, COUNT(logon_history.logon_time) FROM teacher JOIN (site, logon_history) ON ( teacher.site_id = site.id AND teacher.id = logon_history.teacher_id ) WHERE teacher_id = " . $row[0];

$logon_history_pull = "SELECT logon_time FROM logon_history WHERE teacher_id=" . $row[0] . " ORDER BY logon_time DESC LIMIT 1";


        $teacher_results = mysql_query($teacher_pull, $link);

                $logon_history_results = mysql_query($logon_history_pull, $link);

        $teacher[$i]['name'] = mysql_result($teacher_results,0,"teacher.last_name");
        $teacher[$i]['name'] .= ", " . mysql_result($teacher_results,0,"teacher.first_name");


                $last_logon = mysql_fetch_assoc($logon_history_results);

                //print_r($last_logon);
                $teacher[$i]['last_logon'] = $last_logon['logon_time'];

                //print_r($logon_history_results);

                //$last_logon = mysql_result($logon_history_results,0,"logon_time");

                $teacher[$i]['site'] = mysql_result($teacher_results,0,"site.name");
        $teacher[$i]['passkey'] = mysql_result($teacher_results,0,"site.passkey");
        $teacher[$i]['date'] = mysql_result($teacher_results,0,"logon_history.logon_time");
        $teacher[$i]['numlogins'] = mysql_result($teacher_results,0,5);

$i = $i + 1;
}
//print_r($teacher);
//echo "<br />
//<br />";

//print_r(array_sort($teacher, 'last_logon', SORT_DESC));
//echo "<br />
//<br />";

$teacher = array_sort($teacher, 'last_logon', SORT_DESC);
//print_r($teacher);


$date = date("m/d/Y");

$report = "<H1>Stuff</H1><table width='800'><tr><td><H2>Stuff</H2></td><td align='right'><H2>" . $date . "</H2></td></tr><tr><td></td><td align='right'>user logins as of 7/13</td></tr></table>";


$report .= "<table width='800' border='1' cellpadding='3'><tr><td><strong>Site Name</strong></td><td><strong>Teacher</strong></td><td><strong>Keycode</strong></td>";

$report .= "<td align=center><strong>Date Registered</strong></td><td><strong>#of Logins</strong></td><td align=center><strong>Last Logon</strong></td></tr>";

foreach($teacher as $v){


        $report .= "<tr><td>";
        $report .= $v['site'];
        $report .= "</td><td>";
        $report .= $v['name'];
        $report .= "</td><td>";
        $report .= $v['passkey'];
        $report .= "</td><td>";
        $report .= $v['date'];
        $report .= "</td><td>";
                $report .= $v['numlogins'];
                $report .= "</td><td>";
                $report .= $v['last_logon'];
        $report .= "</td></tr>";


}
$report .= "</table>";


 require_once "Mail.php";

 $from = "EMAIL";
 $to = "EMAIL";
 $subject = "Daily Report";
 $body = $report;

 $host = "MAILSERVER";
 $username = "EMAIL";
 $password = "PASSWORD";

 $headers = array ('From' => $from,
   'To' => $to,
   'Subject' => $subject,
   'MIME-Version' => '1.0',
   'Content-Type' => 'text/html',
   'Charset' => 'ISO-8859-1');

 $smtp = Mail::factory('smtp',
   array ('host' => $host,
     'auth' => true,
     'username' => $username,
     'password' => $password));

 $mail = $smtp->send($to, $headers, $body);

 if (PEAR::isError($mail)) {
   echo("<p>" . $mail->getMessage() . "</p>");
  } else {
   echo("<p>Message successfully sent!</p>");
  }



?>