public static function bookings($app)
{
$database = Database::getFactory()->getConnection();
$sql = "SELECT * FROM `bookings`";
$query = $database->prepare($sql);
$query->execute();
echo json_encode(array("category" => "statistics", "type" => "bookings", "total" => $query->rowCount()));
}
public static function create($app, $details)
{
$Database = Database::getFactory()->getConnection();
$sql = "INSERT INTO `bookings` (\n `booking_id`,\n `booking_title`,\n `booking_room`,\n `booking_creator`,\n `booking_start`,\n `booking_end`,\n `booking_notes`,\n `booking_attendees`,\n `booking_guests`)\n VALUES ( NULL,\n ':title',\n ':room',\n ':creator',\n ':from',\n ':to',\n ':notes',\n ':attendees',\n ':guests' );";
$query = $Database->prepare($sql);
$title = $details['title'];
$room = $details['room'];
$creator = $details['creator'];
$from = $details['from'];
$to = $details['to'];
$notes = $details['notes'];
$attendees = $details['attendees'];
$guests = $details['guests'];
$query->execute(array(':title' => $title, ':room' => $room, ':creator' => $creator, ':from' => $from, ':to' => $to, ':notes' => $notes, ':attendees' => $attendees, ':guests' => $guests));
// TODO: If success then true, else false...
echo json_encode(array("category" => "bookings", "type" => "booking_create", "success" => true));
}
