function updateExpenses($driver, $latitude, $longitude, $address, $reason, $amount, $filename)
{
$db = new Connection();
$conn = $db->connect();
$companyId = Vehicle::getCompany();
$adminId = Vehicle::getAddedBy();
$sql = "INSERT INTO expenses (vehicle_id, driver_id, lattitude, longitude, address, reason, amount, filename, company, admin) VALUES ('{$this->id}', '{$driver}', '{$latitude}', '{$longitude}', '{$address}', '{$reason}', '{$amount}', '{$filename}', '{$companyId}', '{$adminId}')";
if (mysqli_query($conn, $sql)) {
return true;
} else {
return false;
}
}
public static function addBatteryNotification($type, $driver, $vehicle, $latitude, $longitude)
{
$db = new Connection();
$conn = $db->connect();
$today = date('Y-m-d');
$fgDate = $db->getTimeNow();
//$type = "power_battery_plugged";
$origin = "vehicle";
$priority = Notification::getPriority($type);
$mVehicle = new Vehicle($vehicle);
$companyId = $mVehicle->getCompany();
$adminId = $mVehicle->getAddedBy();
$sql = "INSERT INTO `notification` (priority, type, origin, driver, vehicle, latitude, longitude, company, admin, date_added) VALUES ('{$priority}', '{$type}', '{$origin}', '{$driver}', '{$vehicle}', '{$latitude}', '{$longitude}', '{$companyId}', '{$adminId}', '{$fgDate}')";
//echo $sql;
if (mysqli_query($conn, $sql)) {
return true;
} else {
return false;
}
}
