* 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
