<?php
require "/nfs/users/clind/public_html/prescriptiontrails.org/admin/db.php";
require "PHPExcel.php";
$exportTrails = new trails();
$export = $exportTrails->getAllSheet();
$count = $export['totalMatched'];
$export = $export['trails'];
// Instantiate a new PHPExcel object
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("PT Webserver")->setLastModifiedBy("Jacob Mayfield")->setTitle("Prescription Trails Data Export")->setSubject("Prescription Trails Data Export")->setCategory("Data Dump");
// Set the active Excel worksheet to sheet 0
$objPHPExcel->setActiveSheetIndex(0);
// Initialise the Excel row number
$rowCount = 1;
// Iterate through each result from the SQL query in turn
// We fetch each database result row into $row in turn
foreach ($export as $id => $trail) {
if ($trail['loopcount'] == 1) {
$distance = $trail['loops'][1]['distance'];
$steps = $trail['loops'][1]['steps'];
} else {
$looptext = $trail['loopcount'] . " loops";
$distance = 0;
$steps = 0;
foreach ($trail['loops'] as $id => $details) {
$distance = $trail['loops'][$id]['distance'] + $distance;
$steps = $trail['loops'][$id]['steps'] + $steps;
}
}
$objPHPExcel->getActiveSheet()->SetCellValue('A' . $rowCount, $trail['id']);
