/** * 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');