function getEnergyUsage()
{
$db = $this->conn;
$result = mysqli_query($db, "SELECT * FROM incoming_messages WHERE deleted=0 ORDER BY date_received DESC ");
echo "<table width = '880' border='0' class='table_s1' >";
echo "<th width='10'>#</th>";
echo '<th>Respondent</th>';
echo "<th>Fuel</th>";
echo "<th>Amount (Kg)</th>";
echo "<th>Date</th>";
echo "<tbody>";
$num = 0;
while ($row = mysqli_fetch_array($result)) {
$num++;
echo "<tr>";
echo "<td>";
echo $num . '.';
echo "</td>";
echo "<td>";
$model = new ClientModel();
$mobNum = $row['sender_number'];
$name = $model->getClientNameByMobNum($mobNum);
echo $name;
echo "</td>";
echo "<td>";
$id = $row['energy_id'];
$message = $this->getFuelName($id);
echo $message;
echo "</td>";
echo "<td>";
echo $row['amount'];
echo "</td>";
echo "<td>";
echo $row['date_received'];
echo "</td>";
echo "</tr>";
echo "</tbody>";
}
echo "</table>";
}
$objPHPExcel->getActiveSheet()->getStyle($header)->applyFromArray($style);
// Miscellaneous glyphs, UTF-8
$num = 1;
$x = 2;
while ($row = mysqli_fetch_array($result)) {
$head = 'A' . $x . ':D' . $x;
$objPHPExcel->getActiveSheet()->getStyle($head)->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID)->getStartColor()->setARGB('00ffcccc');
$style = array('font' => array('bold' => false), 'alignment' => array('horizontal' => \PHPExcel_Style_Alignment::HORIZONTAL_GENERAL));
$objPHPExcel->getActiveSheet()->getStyle($head)->applyFromArray($style);
$x += 2;
$id = $row['energy_id'];
$fuelName = $message->getFuelName($id);
$amount = $row['amount'];
$model = new ClientModel();
$mobNum = $row['sender_number'];
$name = $model->getClientNameByMobNum($mobNum);
$date = $row['date_received'];
$num++;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $num, $name)->setCellValue('B' . $num, $fuelName)->setCellValue('C' . $num, $amount)->setCellValue('D' . $num, $date);
}
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(0)->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(1)->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(2)->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimensionByColumn(3)->setAutoSize(true);
//$objPHPExcel->getActiveSheet()->getStyle('A8')->getAlignment()->setWrapText(true);
// Rename worksheet
//echo date('H:i:s'), " Rename worksheet", EOL;
$objPHPExcel->getActiveSheet()->setTitle('Simple');
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Save Excel 2007 file
