public function consumption_ajax($sub_category = null) { $commodity_id = $this->input->post('commodity_id'); $from = $this->input->post('from'); $to = $this->input->post('to'); $total = 0; $to = $to == "NULL" || !isset($to) ? date('Y-m-d 23:59:59') : date('Y-m-d 23:59:59', strtotime(urldecode($to))); $from = $from == "NULL" || !isset($from) ? date('Y-m-d 00:00:00') : date('Y-m-d 00:00:00', strtotime(urldecode($from))); $consumption = facility_stocks::get_dispensing_consumption($commodity_id, $from, $to, $sub_category); $result_table = ""; $result_table .= ' <table class="table table-bordered row-fluid datatable" id="ajax_commodity_table"> <thead> <th>Commodity Name</th> <th>Units Consumed</th> </thead> <tbody>'; if (count($consumption) > 0) { foreach ($consumption as $data) { $total += intval($data['total']); $result_table .= '<tr> <td>' . $data['commodity'] . '</td> <td>' . $data['total'] . '</td> </tr>'; } } else { $result_table .= '<tr><td><b>There is no consumption history on this Commodity</b></td><td>N/A</td></tr>'; } $result_table .= '<tr><td><b>Total:</b></td><td><b>' . $total . '</b></td></tr>'; $result_table .= '</tbody></table>'; echo $result_table; }