/**
* Get conditions
*
* @return void
* @author AvB
**/
function conditions()
{
if (!$this->authorized()) {
die('Authenticate first.');
// Todo: return json
}
$queryobj = new Power_model();
$sql = "SELECT COUNT(CASE WHEN `condition` = 'Normal' THEN 1 END) AS normal,\n\t\t\t\t\t\tCOUNT(CASE WHEN `condition` = 'Replace Soon' THEN 1 END) AS soon,\n\t\t\t\t\t\tCOUNT(CASE WHEN `condition` = 'Service Battery' THEN 1 END) AS service,\n\t\t\t\t\t\tCOUNT(CASE WHEN `condition` = 'Replace Now' THEN 1 END) AS now,\n\t\t\t\t\t\tCOUNT(CASE WHEN `condition` = 'No Battery' THEN 1 END) AS missing\n\t\t\t \t\t\tFROM power\n\t\t\t \t\t\tLEFT JOIN reportdata USING (serial_number)\n\t\t\t \t\t\t" . get_machine_group_filter();
$obj = new View();
$obj->view('json', array('msg' => current($queryobj->query($sql))));
}
<div class="col-lg-4 col-md-6">
<div class="panel panel-default">
<div class="panel-heading" data-container="body" title="Battery condition listing">
<h3 class="panel-title"><i class="fa fa-flash"></i> Battery Condition</h3>
</div>
<div class="panel-body text-center">
<?php
$queryobj = new Power_model();
$sql = "SELECT COUNT(CASE WHEN `condition` = 'Normal' THEN 1 END) AS Normal,\n\t\t\t\t\t\t\t\t\t\tCOUNT(CASE WHEN `condition` = 'Replace Soon' THEN 1 END) AS Soon,\n\t\t\t\t\t\t\t\t\t\tCOUNT(CASE WHEN `condition` = 'Service Battery' THEN 1 END) AS Service,\n\t\t\t\t\t\t\t\t\t\tCOUNT(CASE WHEN `condition` = 'Replace Now' THEN 1 END) AS Now,\n\t\t\t\t\t\t\t\t\t\tCOUNT(CASE WHEN `condition` = 'No Battery' THEN 1 END) AS Missing\n\t\t\t\t\t\t\t \t\t\tFROM power;";
$obj = current($queryobj->query($sql));
?>
<?php
if ($obj) {
?>
<a href="<?php
echo url('show/listing/power#Replace%20Now');
?>
" class="btn btn-danger">
<span class="bigger-150"> <?php
echo $obj->Now;
?>
</span><br>
<span data-i18n="widget.power.now">Now</span>
</a>
<a href="<?php
echo url('show/listing/power#Service%20Battery');
