function update_ride_request_status($driver_id, $data)
{
$trip = database\get_trip($data['trip_id']);
if ($trip['driver_id'] != $driver_id) {
return functions\json_respond('ERROR', 'Unauthorized access!');
}
$spots_remaining = database\update_ride_request_status($data['user_id'], $data['trip_id'], $data['status']);
if ($spots_remaining < 0) {
return functions\json_respond('ERROR', 'Insufficient spots!');
}
functions\json_respond('OK', 'Query performed!', array("spots_remaining" => $spots_remaining));
}
function delete_trip($trip_id)
{
$trip_table = 'trip';
$place_table = 'place';
$trip = database\get_trip($trip_id);
if ($trip) {
$origin = $trip['origin']['id'];
$destination = $trip['destination']['id'];
var_dump($origin, $destination);
$delete_trip = mysql_query("DELETE FROM {$trip_table} WHERE id={$trip_id}");
$delete_place_1 = mysql_query("DELETE FROM {$place_table} WHERE id= {$origin} ");
$delete_place_2 = mysql_query("DELETE FROM {$place_table} WHERE id={$destination}");
if ($delete_trip & $delete_place_1 & $delete_place_2) {
var_dump("Deleted Trip!");
return true;
// Trip successfully deleted
}
return false;
// Failed to delete the trip
}
var_dump("Not Deleted!");
return false;
// The trip is not in the trip table
}
