/**
* REST API for retrieving registration dates
*
**/
function new_clients()
{
$reportdata = new Reportdata_model();
new Machine_model();
$where = get_machine_group_filter('WHERE', 'r');
switch ($reportdata->get_driver()) {
case 'sqlite':
$sql = "SELECT DATE(reg_timestamp, 'unixepoch') AS date,\n\t\t\t\t\t\tCOUNT(*) AS cnt,\n\t\t\t\t\t\tmachine_name AS type\n\t\t\t\t\t\tFROM reportdata r\n\t\t\t\t\t\tLEFT JOIN machine m \n\t\t\t\t\t\t\tON (r.serial_number = m.serial_number)\n\t\t\t\t\t\t{$where}\n\t\t\t\t\t\tGROUP BY date, machine_name\n\t\t\t\t\t\tORDER BY date";
break;
case 'mysql':
$sql = "SELECT DATE(FROM_UNIXTIME(reg_timestamp)) AS date, \n\t\t\t\t\t\tCOUNT(*) AS cnt,\n\t\t\t\t\t\tmachine_name AS type\n\t\t\t\t\t\tFROM reportdata r\n\t\t\t\t\t\tLEFT JOIN machine m \n\t\t\t\t\t\t\tON (r.serial_number = m.serial_number)\n\t\t\t\t\t\t{$where}\n\t\t\t\t\t\tGROUP BY date, machine_name\n\t\t\t\t\t\tORDER BY date";
break;
default:
die('Unknown database driver');
}
//echo $sql;
$dates = array();
$out = array();
foreach ($reportdata->query($sql) as $event) {
// Store date
$pos = array_search($event->date, $dates);
if ($pos === FALSE) {
array_push($dates, $event->date);
$pos = count($dates) - 1;
}
$out[$event->type][$pos] = intval($event->cnt);
}
$obj = new View();
$obj->view('json', array('msg' => array('dates' => $dates, 'types' => $out)));
}
