concierge's Introduction

Concierge - Laravel 5.x

ABOUT THIS BRANCH

This is a development Work In Progress branch to get a new (and decoupled) booking Library.

Concierge is a simple reservation library for your Laravel 5 app.

Usage

    $concierge = new Concierge();

    $reservation = [
        'business' => $business,
        'contact'  => $contact,
        'service'  => $service,
        'date'     => '2016-03-26',
        'time'     => '10:30',
        'timezone' => $business->timezone,
        'comments' => 'Hello, Dr.!',
    ];

    $appointment = $concierge->business($business)->takeReservation($reservation);

ADVICE: This package is under development and API may change. Join development!

See the Concierge Unit Tests for more and current examples.

Install

Step 1

Via Composer

$ composer require timegridio/concierge=dev-master

ADVICE: Note that this library is currently under development and API may change.

Step 2

Add the following item to config/app.php

Providers array:

'Timegridio\Concierge\TimegridioConciergeServiceProvider'

Timegridio\Concierge\TimegridioConciergeServiceProvider::class

Step 3

Migration

Publish the migration as well as the configuration of notifynder with the following command:

php artisan vendor:publish --provider="Timegridio\Concierge\TimegridioConciergeServiceProvider"

Don't forget to migrate.

Applications using this lib

Timegrid: A marketplace for service providers that use online booking.

Change log

Please see CHANGELOG for more information what has changed recently.

Testing

$ composer test

Contributing

Please see CONTRIBUTING and CONDUCT for details.

Security

If you discover any security related issues, please email [email protected] instead of using the issue tracker.

Credits

License

The MIT License (MIT). Please see License File for more information.

concierge's People

Contributors

Stargazers

Watchers

concierge's Issues

SQLSTATE[42000]: Syntax error or access violation: 1064

Hello,
I'm having an issue on migration.

I'm getting :

...
Migrating: 2016_02_01_000005_create_services_table

   Illuminate\Database\QueryException  : SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'after `id`, `deleted_at` timestamp null, `created_at` timestamp null, `updated_a' at line 1 (SQL: create table `services` (`id` int unsigned not null auto_increment primary key, `business_id` int unsigned not null, `slug` varchar(255) not null, `name` varchar(255) not null, `duration` int unsigned not null default '60', `description` varchar(255) not null, `prerequisites` varchar(255) null, `color` varchar(12) null, `type_id` int unsigned null after `id`, `deleted_at` timestamp null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci')

  at /timegridio-concierge/vendor/laravel/framework/src/Illuminate/Database/Connection.php:664
    660|         // If an exception occurs when attempting to run a query, we'll format the error
    661|         // message to include the bindings with SQL, which will make this exception a
    662|         // lot more helpful to the developer instead of just the database's errors.
    663|         catch (Exception $e) {
  > 664|             throw new QueryException(
    665|                 $query, $this->prepareBindings($bindings), $e
    666|             );
    667|         }
    668| 

  Exception trace:

  1   Doctrine\DBAL\Driver\PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'after `id`, `deleted_at` timestamp null, `created_at` timestamp null, `updated_a' at line 1")
      /timegridio-concierge/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:63

  2   PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'after `id`, `deleted_at` timestamp null, `created_at` timestamp null, `updated_a' at line 1")
      /timegridio-concierge/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:61

  Please use the argument -v to see more details.

I'm using PHP 7.2.8 and MySQL 5.7.23.
Table collation is utf8_general_ci and I also tried utf8mb4_unicode_ci.

Any idea on what could be wrong here please ?
Best regards,
David

Can you explain what is this appointment strategy?

Im looking through your code and it keeps popping up. Time slot is the default va
Is but what are some other examples that you could use. Also does changing the strategy have any effect ?

Recommend Projects