* 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); $fleet = $fleetdayobj->getFleetById($count); //print('<pre>');print_r($fleet); $today = date("j"); //$today = 30; *TEST if ($fleet) { $fleetdetails = $fleetdayobj->getFleetScoreMonth($fleet['id']); } // print('<pre>');print_r($fleetdetails);exit; $fleetlist = $fleetdayobj->getIncomeFleets(); $totincome = 0; $subincome = 0; $totbudget = 0; $totkms = 0; $subkms = 0; $flashstring = ""; if ($fleetdetails) {
$times = substr_count($_SERVER['PHP_SELF'], "/"); $rootaccess = ""; $i = 1; while ($i < $times) { $rootaccess .= "../"; $i++; } define("BASE", $rootaccess); include_once BASE . "/basefunctions/localdefines.php"; include_once BASE . "/basefunctions/dbcontrols.php"; include_once BASE . "/basefunctions/baseapis/manapi.php"; include_once BASE . "Maxine/api/maxineapi.php"; 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(); $fleet = $fleetdayobj->getFleetById(substr($_POST['dashid'], 1)); //: Missing and open refuels $sql = (string) 'SELECT * FROM `refuels` WHERE `fleet_id`=' . (int) $fleet['maxid']; $refuels = sqlQuery($sql); if ($refuels === FALSE) { syslog(LOG_INFO, 'Query for unauthorized refuels returned FALSE.'); } //: End //: Unauthorized Refuels $sql = (string) 'SELECT * FROM `unauthorized_refuels` WHERE `fleet_id`=' . (int) $fleet['maxid']; $unauth = sqlQuery($sql); if ($unauth === FALSE) { syslog(LOG_INFO, 'Query for unauthorized refuels returned FALSE.'); } //: End //: End