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 = "";