<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title"><i class="fa fa-smile-o"></i> Munki</h3>
</div>
<div class="panel-body text-center">
<?php
$munkireport = new Munkireport_model();
$sql = "SELECT \n\t\t\t\t\tSUM(errors > 0) as errors, \n\t\t\t\t\tSUM(warnings > 0) as warnings, \n\t\t\t\t\tSUM(pendinginstalls > 0) as pending,\n\t\t\t\t\tSUM(installresults > 0) as installed \n\t\t\t\t\tFROM munkireport\n\t\t\t\t\tLEFT JOIN reportdata USING (serial_number)\n\t\t\t\t\t" . get_machine_group_filter();
?>
<?php
foreach ($munkireport->query($sql) as $obj) {
?>
<a href="<?php
echo url('show/listing/munki#errors');
?>
" class="btn btn-danger">
<span class="bigger-150"> <?php
echo $obj->errors;
?>
</span><br>
<span data-i18n="error" data-i18n-options='{"count":<?php
echo $obj->errors;
?>
}'>Errors</span>
</a>
<a href="<?php
<th>User</th>
<th>IP</th>
<th>Latest run</th>
<th>Name</th>
<th>Type</th>
</tr>
</thead>
<tbody>
<?php
$sql = "SELECT computer_name, \n\t\t\t\t\t\t\tm.serial_number,\n\t\t\t\t\t\t\tlong_username,\n\t\t\t\t\t\t\tm.timestamp,\n\t\t\t\t\t\t\tremote_ip,\n\t\t\t\t\t\t\treport_plist\n\t\t\t\t\t\tFROM munkireport m\n\t\t\t\t\t\tLEFT JOIN machine USING (serial_number)\n\t\t\t\t\t\tLEFT JOIN reportdata USING (serial_number)\n\t\t\t\t\t\tWHERE pendinginstalls > 0\n\t\t\t\t\t\t" . get_machine_group_filter('AND');
$compress = function_exists('gzdeflate');
$mr = new Munkireport_model();
?>
<?php
foreach ($mr->query($sql) as $obj) {
?>
<?php
$report_plist = unserialize($compress ? gzinflate($obj->report_plist) : $obj->report_plist);
?>
<?php
if (isset($report_plist['AppleUpdates'])) {
?>
<?php
foreach ($report_plist['AppleUpdates'] as $update) {
?>
<tr>
<td><?php
echo $obj->computer_name;
?>