function exportFleetScoreUpdates()
{
require_once BASE . 'basefunctions/baseapis/PHPExcel/php-excel.class.php';
$manager = new TableManager("fleet_scores");
$data = __sanitizeData($_GET);
$where = (string) "1=1";
if (isset($data["fleet"]) && $data["fleet"]) {
$where .= $manager->quoteString(" AND `fleetid`=?", (int) $data["fleet"]);
}
if (isset($data["start"]) && $data["start"]) {
$where .= $manager->quoteString(" AND `date`>=?", (int) unixDate($data["start"]));
}
if (isset($data["end"]) && $data["end"]) {
$where .= $manager->quoteString(" AND `date`<=?", (int) unixDate($data["end"]));
}
$manager->setWhere($where);
$manager->setOrderBy(array("column" => "date"));
$records = $manager->selectMultiple();
$rows = returnFleetTruckCount();
$xlsdata = (array) array();
$fleetdayobj = new fleetDayHandler();
$tempfleetlist = $fleetdayobj->getIncomeFleets();
$fleetlist = array();
foreach ($tempfleetlist as $tempkey => $tempval) {
$fleetlist[$tempval["id"]] = $tempval;
}
unset($tempfleetlist);
unset($fleetdayobj);
$row = (array) array("Date", "Fleet", "Income budget", "Income", "Contribution budget", "Contribution", "Truck count", "Kms", "Ave. Kms per truck", "Budget Ave. Kms per truck");
$xlsdata[] = $row;
foreach ($records as $val) {
$row = (array) array(date("Y-m-d", $val["date"]), $fleetlist[$val["fleetid"]]["name"], $val["budget"], $val["income"], $val["budgetcontrib"], $val["contrib"], $rows[$val["fleetid"]]["count"], $val["kms"], round($val["kms"] / (isset($rows[$val["fleetid"]]) && isset($rows[$val["fleetid"]]["count"]) ? $rows[$val["fleetid"]]["count"] : 1), 2), round($val["budkms"] / (isset($rows[$val["fleetid"]]) && isset($rows[$val["fleetid"]]["count"]) ? $rows[$val["fleetid"]]["count"] : 1), 2));
$xlsdata[] = $row;
}
$xls = new Excel_XML('UTF-8', TRUE);
$xls->addArray($xlsdata);
$xls->generateXML('fleet_score_data');
}
require_once BASE . "basefunctions/baseapis/fleetDayHandler.php";
$link = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_SCHEMA) or die(mysqli_error($link));
$fleetdayobj = new fleetDayHandler();
// }
/** returnFleetTruckCount()
* get all fleets truck count
* @return array on success false otherwise
*/
function returnFleetTruckCount()
{
require_once BASE . "/basefunctions/baseapis/TableManager.php";
$manager = new TableManager("fleet_truck_count");
$manager->setCustomIndex("fleet_id");
return $manager->selectMultiple();
}
$truckcount = returnFleetTruckCount();
// }
$count = $conf["fleetcount"];
$factor = findPageDimensionFactor(isset($conf["maxwidth"]) ? (int) $conf["maxwidth"] : NULL);
//$count = 2;
$fleet = $fleetdayobj->getFleetId($count);
$today = date("j");
//$today = 30; *TEST
if ($fleet) {
$fleetdetails = $fleetdayobj->getFleetScoreMonth($fleet);
}
$fleetlist = $fleetdayobj->getIncomeFleets();
$totcontrib = 0;
$totbudget = 0;
$totkms = 0;
$flashstring = "";
