{"id":1466,"date":"2017-01-12T03:39:30","date_gmt":"2017-01-12T03:39:30","guid":{"rendered":"http:\/\/myprojects.advchaweb.com\/?p=1466"},"modified":"2017-01-16T15:52:17","modified_gmt":"2017-01-16T15:52:17","slug":"my-booking-app","status":"publish","type":"post","link":"https:\/\/myprojects.advchaweb.com\/index.php\/2017\/01\/12\/my-booking-app\/","title":{"rendered":"My Booking App"},"content":{"rendered":"

Source: (local) http:\/\/localhost\/works\/laravel\/mybooking\/public\/<\/a>
\n(from) https:\/\/github.com\/prehire\/php-23093023909ad09a09<\/a><\/p>\n

TASK:
\nNOTE: I do this without using because it’s heavier for my laptop. I can use vagrant later but need to set some configuration. Please read Laravel Homestead VirtualBox Vagrant<\/a>.<\/p>\n

    \n
  1. Copy the available local ‘php-23093023909ad09a09’ directory then paste to be\u00a0‘mybooking’. If you dont have the source code of ‘php-23093023909ad09a09’, then clone from https:\/\/github.com\/prehire\/php-23093023909ad09a09 then rename it to ‘mybooking’<\/li>\n
  2. Go to the directory ‘mybooking’ then use composer to install the dependency packages.\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ composer install\r\n<\/pre>\n<\/li>\n
  3. Because I want to use SQLite, so modify .env to use SQLite\n
    DB_CONNECTION=sqlite<\/pre>\n
    Also modify \/config\/database.php to make sure these settings:<\/p>\n
    'default' => 'sqlite',\r\n...\r\n'connections' => [\r\n\r\n    'sqlite' => [\r\n        'driver' => 'sqlite',\r\n        'database' => database_path('homework_database.sqlite'),\r\n        'prefix' => '',\r\n    ],\r\n    ...<\/pre>\n
    Also make sure the sqlite database ‘homework_database.sqlite’ is in \/database\/ directory!<\/li>\n
  4. Set the files permission for these directories:\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ sudo chmod -R 777 database\/\r\nteddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ sudo chmod -R 777 storage\/\r\nteddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ sudo chmod -R 777 bootstrap\/<\/pre>\n
     <\/li>\n
  5. Test the app for the first time http:\/\/localhost\/works\/laravel\/mybooking\/public\/. Here is how it looks\"mybooking-front-first\"<\/a>It only shows Homework<\/strong><\/span> (http:\/\/localhost\/works\/laravel\/mybooking\/public\/), Booking<\/strong><\/span> (http:\/\/localhost\/works\/laravel\/mybooking\/public\/booking), Customer<\/strong><\/span> (http:\/\/localhost\/works\/laravel\/mybooking\/public\/customer) and Cleaner<\/strong><\/span> (http:\/\/localhost\/works\/laravel\/mybooking\/public\/cleaner).<\/li>\n
  6. OK. It’s time for the task description!
    \nSummary
    \n<\/strong>We are a local home cleaning company called Homework. Today we are keeping track of all our bookings using a spreadsheet and we want to move it into a web application. Our main goal with this project is to make it possible for customers to schedule a booking online. I’ve already created the scaffolding of the app for you and now I need you to add some functionality to it. This should take you about 1-2 hours, but you have up to 4 hours to complete it.
    \nDeliverables
    \n<\/strong>1. All models and columns should have validation as described in the model spec below, plus any common-sense validation you’ll put on new models.
    \n2. We need to split the site in to Admin-only and Customer-only. Right now all the admin functionality is exposed to the world.
    \n3. Currently we operate in 10 cities, but plan to expand quickly. We need a way to admin the list of cities we operate in and the ability to add to the list. You should create a new table to do this.
    \n4. On the admin cleaner form we need a way to select the cities a cleaner works in. This should be a checkbox list populated by the list of the cities we operate in. You may need to create a new table to store this data.
    \n5. We need a way for customers to signup and schedule a booking all on one form. To accomplish this you will need to do the following:
    \n– Make the site root a customer-facing form designed for customers to sign up and book a cleaner.
    \n– On this form, capture all the data needed to create a customer in the database (first name, last name, phone number).
    \n– If the customer already exists in the database (use phone number to determine this) use the existing record instead of creating a new one. You should probably add a validation to enforce this.
    \n– Let the customer select what city they are in from the cities table created earlier.
    \n– Let the customer specify a date and time when they would like their house cleaned.
    \n– When the user submits the form, look for cleaners that work in the specified city that do not have any bookings that conflict with the time specified.
    \n– If you can find an available cleaner, create the booking and display the name of the cleaner assigned to the booking.
    \n– If you can’t find an available cleaner, tell the user that we could not fulfill their request.
    \n6. Write tests for the parts of the application you feel need it the most.
    \n7. When you are done, please zip up the entire root directory including your SQLite database and vendor files — do not cherry-pick folders.
    \nRestrictions<\/strong>
    \n1. Do NOT switch the database from SQLite to MySQL.
    \n2. If you create a password-protected account, use credentials “admin@admin.com” and password “admin”.Existing Models<\/strong>
    \n1. customer
    \n– first_name (required)
    \n– last_name (required)
    \n– phone_number (optional)
    \n2. booking
    \n– customer (required, enforce referential integrity)
    \n– cleaner (required, enforce referential integrity)
    \n– date (required)
    \n3. cleaner
    \n– first_name (required)
    \n– last_name (required)
    \n– quality_score (required, must be a number between 0.0 and 5.0)
    \nSetup<\/strong>
    \n    https:\/\/github.com\/prehire\/php-23093023909ad09a09<\/a>Summary<\/strong>
    \nThe following deliverables are not required but are nice-to-haves. If you choose to implement them, it should take around 1 hour but you must complete this section within 3 hours. You can complete any number of the bonus deliverables: you don’t need to complete all of them.Bonus Deliverables<\/strong>
    \n1. Use a free theme to make the application look a little better, especially the pages seen by our customers.
    \n2. Add security to the admin pages on our site. Customers and cleaners do not need to be able to login at the moment.
    \n3. The cleaner form should have one additional field: ’email’
    \no Email should be required
    \n0 Check that it is a valid email address
    \n4. When a new booking is created, email the cleaner with information on the booking and customer.
    \n5. The Customer Show view should show all associated bookings below the form and link to them.
    \n6. The Cleaner Show view should show all associated bookings below the form and link to them.
    \n7. When you are done, please zip up the whole app directory with dependencies and upload it below.<\/li>\n
  7. Step by step the task completion!
    \n“2. We need to split the site in to Admin-only and Customer-only. Right now all the admin functionality is exposed to the world.”<\/span>. For the Admin-only page, It’d need a login. But it not needed for Customer-only page! So we’re going to show the homepage for customer and also the login link for the admin!
    \nUse ‘Auth’ to create the login\/register scaffolding<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan make:auth\r\nAuthentication scaffolding generated successfully.<\/pre>\n
    NOTE: This will modify ‘app.blade.php’ in \/resources\/views\/layouts\/ directory and would mess the web looks. But no worry. We’d fix this later!
    \nThen modify ‘web.php’ in \/routes\/ like this:<\/p>\n
    Route::get('\/', function () {\r\n    return redirect('\/home');\r\n});\r\n\r\nRoute::get('\/home', 'Home\\HomeController@index');\r\nAuth::routes();<\/pre>\n
    Then create ‘HomeController’ in ‘Home’ directory:<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan make:controller Home\/HomeController\r\nController created successfully.<\/pre>\n
    You’ll see ‘HomeController.php’ in \/app\/Http\/Controllers\/Home\/ directory!
    \nNOTE: You can remove ‘HomeController.php’ file in \/app\/Http\/Controllers\/ directory created by Auth scaffoldiing!
    \nThen add a new function ‘index’ in the new controller. Here is the controller content look<\/p>\n
    <?php\r\n\r\nnamespace App\\Http\\Controllers\\Home;\r\n\r\nuse Illuminate\\Http\\Request;\r\n\r\nuse App\\Http\\Requests;\r\nuse App\\Http\\Controllers\\Controller;\r\n\r\nclass HomeController extends Controller\r\n{\r\n    public function index(){\r\n        return view('home.index');\r\n    }\r\n}<\/pre>\n
    Then create a new directory ‘home’ in \/resources\/views\/ and a new blade template ‘index.blade.php’ in the new directory. Here is the temporary content of the file<\/p>\n
    @extends('layouts.app')\r\n\r\n@section('content')\r\n\r\n    <h1>Hello My Customer!<\/h1>\r\n\r\n@endsection<\/pre>\n
    I also need to modify ‘app.blade.php’ in \/layouts\/ directory so we can fix the web layout and the login (and register) link can be showed up. We also need to add some bootstrap links for the CSS and Javascript\/JQuery. Here is the modification in app.blade.php<\/p>\n
    <!DOCTYPE html>\r\n<html lang=\"en\">\r\n<head>\r\n    <meta charset=\"utf-8\">\r\n    <meta http-equiv=\"X-UA-Compatible\" content=\"IE=edge\">\r\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1\">\r\n\r\n    <title>Homework<\/title>\r\n    <!-- Fonts -->\r\n    <link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/font-awesome\/4.5.0\/css\/font-awesome.min.css\"\r\n          integrity=\"sha384-XdYbMnZ\/QjLh6iI4ogqCTaIjrFk87ip+ekIjefZch0Y+PvJ8CDYtEs1ipDmPorQ+\" crossorigin=\"anonymous\">\r\n    <link rel=\"stylesheet\" href=\"https:\/\/fonts.googleapis.com\/css?family=Lato:100,300,400,700\">\r\n\r\n    <!-- Styles -->\r\n    <link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/twitter-bootstrap\/3.3.6\/css\/bootstrap.min.css\"\r\n          integrity=\"sha384-1q8mTJOASx8j1Au+a5WDVnPi2lkFfwwEAa8hDDdjZlpLegxhjVME1fgjWPGmkzs7\" crossorigin=\"anonymous\">\r\n    {{-- <link href=\"{{ elixir('css\/app.css') }}\" rel=\"stylesheet\"> --}}\r\n\r\n    <style>\r\n        body {\r\n            font-family: 'Lato';\r\n        }\r\n\r\n        .fa-btn {\r\n            margin-right: 6px;\r\n        }\r\n    <\/style>\r\n<\/head>\r\n<body>\r\n    <div id=\"app\">\r\n        <nav class=\"navbar navbar-default navbar-static-top\">\r\n            <div class=\"container\">\r\n                <div class=\"navbar-header\">\r\n\r\n                    <!-- Collapsed Hamburger -->\r\n                    <button type=\"button\" class=\"navbar-toggle collapsed\" data-toggle=\"collapse\" data-target=\"#app-navbar-collapse\">\r\n                        <span class=\"sr-only\">Toggle Navigation<\/span>\r\n                        <span class=\"icon-bar\"><\/span>\r\n                        <span class=\"icon-bar\"><\/span>\r\n                        <span class=\"icon-bar\"><\/span>\r\n                    <\/button>\r\n\r\n                    <!-- Branding Image -->\r\n                    <a class=\"navbar-brand\" href=\"{{ url('\/') }}\">\r\n                        Homework\r\n                    <\/a>\r\n                <\/div>\r\n\r\n                <div class=\"collapse navbar-collapse\" id=\"app-navbar-collapse\">\r\n                    <!-- Left Side Of Navbar -->\r\n                    <ul class=\"nav navbar-nav\">\r\n                        &nbsp;\r\n                    <\/ul>\r\n\r\n                    <!-- Right Side Of Navbar -->\r\n                    <ul class=\"nav navbar-nav navbar-right\">\r\n                        <!-- Authentication Links -->\r\n                        @if (Auth::guest())\r\n                            <li><a href=\"{{ url('\/login') }}\">Login<\/a><\/li>\r\n                            <li><a href=\"{{ url('\/register') }}\">Register<\/a><\/li>\r\n                        @else\r\n                            <li class=\"dropdown\">\r\n                                <a href=\"#\" class=\"dropdown-toggle\" data-toggle=\"dropdown\" role=\"button\" aria-expanded=\"false\">\r\n                                    {{ Auth::user()->name }} <span class=\"caret\"><\/span>\r\n                                <\/a>\r\n\r\n                                <ul class=\"dropdown-menu\" role=\"menu\">\r\n                                    <li>\r\n                                        <a href=\"{{ url('\/logout') }}\"\r\n                                            onclick=\"event.preventDefault();\r\n                                                     document.getElementById('logout-form').submit();\">\r\n                                            Logout\r\n                                        <\/a>\r\n\r\n                                        <form id=\"logout-form\" action=\"{{ url('\/logout') }}\" method=\"POST\" style=\"display: none;\">\r\n                                            {{ csrf_field() }}\r\n                                        <\/form>\r\n                                    <\/li>\r\n                                <\/ul>\r\n                            <\/li>\r\n                        @endif\r\n                    <\/ul>\r\n                <\/div>\r\n            <\/div>\r\n        <\/nav>\r\n\r\n        @yield('content')\r\n    <\/div>\r\n\r\n    <!-- JavaScripts -->\r\n    <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/jquery\/2.2.3\/jquery.min.js\"\r\n            integrity=\"sha384-I6F5OKECLVtK\/BL+8iSLDEHowSAfUo76ZL9+kGAgTRdiByINKJaqTPH\/QVNS1VDb\"\r\n            crossorigin=\"anonymous\"><\/script>\r\n    <script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/twitter-bootstrap\/3.3.6\/js\/bootstrap.min.js\"\r\n            integrity=\"sha384-0mSbJDEHialfmuBBQP6A4Qrprq5OVfW37PRR3j5ELqxss1yVqOtnepnHVP9aJ7xS\"\r\n            crossorigin=\"anonymous\"><\/script>\r\n    {{-- <script src=\"{{ elixir('js\/app.js') }}\"><\/script> --}}\r\n<\/body>\r\n<\/html><\/pre>\n
    OK. Here is the homepage looks\"mybooking-front-2\"<\/a>Then try to add a new user (customer) by clicking the register link (http:\/\/localhost\/works\/laravel\/mybooking\/public\/register). Then add a new user with Name: ‘Admin’, email: ‘advcha@admin.com’ and password: ‘admin123’. This is a ‘fake admin’ user!. Not actual admin user. We’re going to add the real admin later. (NOTE: I think also I need to differentiate the login\/register page for the customer and cleaner. May be add an option if the user want to be a customer or a cleaner!)<\/span>
    \nNow we can login with the name. But where is the links to Booking, Customer and Cleaner? Here is how to show them up. Modify ‘app.blade.php’ again, then put the links like this:<\/p>\n
    <div class=\"collapse navbar-collapse\" id=\"app-navbar-collapse\">\r\n    <!-- Left Side Of Navbar -->\r\n    @if (!Auth::guest())\r\n        <ul class=\"nav navbar-nav\">\r\n            <li><a href=\"{{ url('\/') }}\">Booking<\/a><\/li>\r\n            <li><a href=\"{{ url('\/') }}\">Customer<\/a><\/li>\r\n            <li><a href=\"{{ url('\/') }}\">Cleaner<\/a><\/li>\r\n        <\/ul>\r\n    @endif\r\n\r\n    <!-- Right Side Of Navbar -->\r\n    <ul class=\"nav navbar-nav navbar-right\">\r\n    ...<\/pre>\n
    Here is the looks\"mybooking-front-3\"<\/a>Okay. but the links still can be clicked properly. We need to add some routes in \/routes\/web.app like this:<\/p>\n
    ...\r\nRoute::resource('admin\/customer', 'Admin\\CustomerController');\r\nRoute::resource('admin\/booking', 'Admin\\BookingController');\r\nRoute::resource('admin\/cleaner', 'Admin\\CleanerController');\r\n...<\/pre>\n
    So create a new directory ‘Admin’ in \/app\/Http\/Controllers\/ then move BookingController.php, CleanerController.php and CustomerController.php into the new directory.
    \nThen (don’t forget<\/span>) to modify the namespace in those three files to<\/p>\n
    namespace App\\Http\\Controllers\\Admin;<\/pre>\n
    Now we can put the routes for the links in ‘app.blade.php’ like this:<\/p>\n
    @if (!Auth::guest())\r\n    <ul class=\"nav navbar-nav\">\r\n        <li><a href=\"{{ url('\/admin\/booking') }}\">Booking<\/a><\/li>\r\n        <li><a href=\"{{ url('\/admin\/customer') }}\">Customer<\/a><\/li>\r\n        <li><a href=\"{{ url('\/admin\/cleaner') }}\">Cleaner<\/a><\/li>\r\n    <\/ul>\r\n@endif\r\n<\/pre>\n
    Now we’ve completed the links! You can see the working urls like Booking (http:\/\/localhost\/works\/laravel\/mybooking\/public\/admin\/booking), Customer (http:\/\/localhost\/works\/laravel\/mybooking\/public\/admin\/customer) and Cleaner (http:\/\/localhost\/works\/laravel\/mybooking\/public\/admin\/cleaner). Here is the example for the admin booking page.\"mybooking-admin-booking\"<\/a>But there is another thing we need to pay attention for the above links. If we’re logged out, the above links and the urls should not be displayed and opened. Here we need to employ the middleware auth for each the controllers files (BookingController.php, CleanerController.php and CustomerController.php) in ‘__construct’ function like this:<\/p>\n
    public function __construct()\r\n{\r\n    $this->middleware('auth');\r\n}\r\n<\/pre>\n
    Now if we open the url (for example:\u00a0 http:\/\/localhost\/works\/laravel\/mybooking\/public\/admin\/customer) without login first, we’d be redirected to the login page!
    \n<IF YOU HAVE MORE TIME, PLS DO THIS. BUT IT’D TAKE MANY WORKS AND TIME!!!><\/span>
    \nTo make the view structures tidier, we need to create a new directory ‘admin’ in \/resources\/views\/ then move these directories ‘booking’, ‘customer’ and ‘cleaner’ into it. Then don’t forget to modify the ‘index’ function in our three controller files to refer to the new location:<\/p>\n
    BookingController.php:\r\npublic function index()\r\n{\r\n    $booking = Booking::paginate(25);\r\n\r\n    return view('admin.booking.index', compact('booking'));\r\n}\r\n\r\nCustomerController.php:\r\npublic function index()\r\n{\r\n    $customer = Customer::paginate(25);\r\n\r\n    return view('admin.customer.index', compact('customer'));\r\n}\r\n\r\nCleanerController.php:\r\npublic function index()\r\n{\r\n    $cleaner = Cleaner::paginate(25);\r\n\r\n    return view('admin.cleaner.index', compact('cleaner'));\r\n}<\/pre>\n
    Also do the same thing for others functions like ‘create’, ‘edit’ and ‘show’. Dont forget to modify also almost all the blade template for them!!! for example: \/admin\/customer\/index.blade.php, modify the urls like url(‘\/customer\/create’) to url(‘\/admin\/customer\/create’) and the others same urls in the file!!!
    \n<\/IF YOU HAVE MORE TIME, PLS DO THIS. BUT IT’D TAKE MANY WORKS AND TIME!!!>
    \nCRUD<\/span>
    \n<\/span>To make CRUD works for them, I need to modify also some functions in the controller files to redirect to the correct route. For example for CustomerController.php, modify the redirect to ‘admin\/customer’ for ‘store’, ‘update’ and ‘destroy’ functions. Do the same thing for Booking and Cleaner controllers! Also modify the blade templates!
    \nHere is the look for the admin customer (http:\/\/localhost\/works\/laravel\/mybooking\/public\/admin\/customer)
    \n    \"mybooking-admin-customer\"<\/a>I think I’ve completed the Admin page. NO!! WAIT!! How about the Admin page for Booking??? The Booking form need CustomerId, CleanerId and Date. On the create form, currently the Ids need to be typed manually, I want to change it to a select box to avoid any error like undefined Id. OK. First, modify ‘BookingController.php’ in \/app\/Http\/Controllers\/Admin\/ to retrieve the customers and cleaners data<\/p>\n
    ...\r\nuse App\\Booking;\r\nuse App\\Customer;\r\nuse App\\Cleaner;\r\n....\r\nclass BookingController extends Controller\r\n{\r\n    static $select_customers;\r\n    static $select_cleaners;\r\n    \r\n    public function __construct()\r\n    {\r\n        \/\/ get customers for drop-down menu\r\n\r\n        $customers = Customer::all();\r\n        self::$select_customers = [];\r\n        foreach ($customers as $item) {\r\n            self::$select_customers[$item->id] = $item->first_name . ' ' . $item->last_name;\r\n        }\r\n\r\n        \/\/ get cleaners for drop-down menu\r\n        $cleaners = Cleaner::all();\r\n        self::$select_cleaners = [];\r\n        foreach ($cleaners as $item) {\r\n            self::$select_cleaners[$item->id] = $item->first_name . ' ' . $item->last_name;\r\n        }\r\n\r\n        $this->middleware('auth');\r\n    }\r\n     \r\n    ...\r\n\r\n    public function create()\r\n    {\r\n        return view('admin.booking.create', [\r\n            'select_customers' => self::$select_customers,\r\n            'select_cleaners' => self::$select_cleaners,\r\n        ]);\r\n    }\r\n\r\n    ...\r\n}\r\n<\/pre>\n
    Then modify ‘create.blade.php’ in \/resources\/views\/admin\/booking\/ to display the selection of the customers and the cleaners<\/p>\n
    <div class=\"form-group {{ $errors->has('customer_id') ? 'has-error' : ''}}\">\r\n    {!! Form::label('customer_id', 'Customer', ['class' => 'col-sm-3 control-label']) !!}\r\n    <div class=\"col-sm-6\">\r\n        {!! Form::select('customer_id', $select_customers, null, ['class' => 'form-control']) !!}\r\n        {!! $errors->first('customer_id', '<p class=\"help-block\">:message<\/p>') !!}\r\n    <\/div>\r\n<\/div>\r\n<div class=\"form-group {{ $errors->has('cleaner_id') ? 'has-error' : ''}}\">\r\n    {!! Form::label('cleaner_id', 'Cleaner', ['class' => 'col-sm-3 control-label']) !!}\r\n    <div class=\"col-sm-6\">\r\n        {!! Form::select('cleaner_id', $select_cleaners, null, ['class' => 'form-control']) !!}\r\n        {!! $errors->first('cleaner_id', '<p class=\"help-block\">:message<\/p>') !!}\r\n    <\/div>\r\n<\/div><\/pre>\n
    \"mybooking-booking-admin-create\"<\/a>We need also change the booking table in \/resources\/views\/admin\/booking\/index.blade.php to show the names instead of the ids. First, modify the model ‘Booking.php’ in \/app\/ directory to add relation with customer and cleaner models<\/p>\n
    ...\r\nclass Booking extends Model\r\n{\r\n    ...\r\n\r\n    public function customer()\r\n    {\r\n        return $this->belongsTo('App\\Customer');\r\n    }\r\n\r\n    public function cleaner()\r\n    {\r\n        return $this->belongsTo('App\\Cleaner');\r\n    }\r\n}<\/pre>\n
    Then modify ‘index’ function in \/app\/Http\/Controllers\/Admin\/BookingController.php to retrieve also the customer and cleaner data<\/p>\n
    public function index()\r\n{\r\n    $booking = Booking::with('customer', 'cleaner')->paginate(25);\r\n\r\n    return view('admin.booking.index', compact('booking'));\r\n}<\/pre>\n
    Now in \/resources\/views\/admin\/booking\/index.blade.php, we can show the names instead of the ids<\/p>\n
    ...\r\n<thead>\r\n    <tr>\r\n        <th>S.No<\/th><th> Date <\/th><th> Customer <\/th><th> Cleaner <\/th><th>Actions<\/th>\r\n    <\/tr>\r\n<\/thead>\r\n<tbody>\r\n@foreach($booking as $item)\r\n    <tr>\r\n        <td>{{ $loop->iteration }}<\/td>\r\n        <td>{{ $item->date }}<\/td><td>@if(is_null($item->customer)){{ $item->customer_id }}@else{{$item->customer->first_name.' '.$item->customer->last_name}}@endif<\/td><td>@if(is_null($item->cleaner)){{ $item->cleaner_id }}@else{{ $item->cleaner->first_name.' '.$item->cleaner->last_name}}@endif<\/td>\r\n        <td>\r\n            ...\r\n        <\/td>\r\n    <\/tr>\r\n@endforeach\r\n<\/tbody>\r\n...<\/pre>\n
    Here is the looks\"mybooking-booking-admin-index\"<\/a>For the booking edit function, we only need to do a small changes. In \/app\/Http\/Controllers\/Admin\/BookingController.php, modify ‘edit’ function to pass also the customer and the cleaner data<\/p>\n
    public function edit($id)\r\n{\r\n    $booking = Booking::findOrFail($id);\r\n\r\n    \/\/return view('admin.booking.edit', compact('booking'));\r\n    return view('admin.booking.edit', [\r\n        'booking' => $booking,\r\n        'select_customers' => self::$select_customers,\r\n        'select_cleaners' => self::$select_cleaners,\r\n    ]);\r\n}<\/pre>\n
    Then modify \/resources\/views\/admin\/booking\/edit.blade.php to display the customer and the cleaner options<\/p>\n
    <div class=\"form-group {{ $errors->has('customer_id') ? 'has-error' : ''}}\">\r\n    {!! Form::label('customer_id', 'Customer', ['class' => 'col-sm-3 control-label']) !!}\r\n    <div class=\"col-sm-6\">\r\n        {!! Form::select('customer_id', $select_customers, null, ['class' => 'form-control']) !!}\r\n        {!! $errors->first('customer_id', '<p class=\"help-block\">:message<\/p>') !!}\r\n    <\/div>\r\n<\/div>\r\n<div class=\"form-group {{ $errors->has('cleaner_id') ? 'has-error' : ''}}\">\r\n    {!! Form::label('cleaner_id', 'Cleaner', ['class' => 'col-sm-3 control-label']) !!}\r\n    <div class=\"col-sm-6\">\r\n         {!! Form::select('cleaner_id', $select_cleaners, null, ['class' => 'form-control']) !!}\r\n        {!! $errors->first('cleaner_id', '<p class=\"help-block\">:message<\/p>') !!}\r\n    <\/div>\r\n<\/div><\/pre>\n
    NOTE: If any customer or the cleaner is not exists (may be because it’s already deleted) in the selection, the selection SHOWS THE FIRST OPTION NOT NULL. IT CAN BE MISLEADING AS IF THE FIRST OPTION IS SELECTED. HOW TO HANDLE THIS???
    \nNow I’m going to work on the Customer page (homepage). The current homepage (http:\/\/localhost\/works\/laravel\/mybooking\/public\/home) content still show the ugly text ‘Hello My Customer!’. Please modify the home template ‘app.blade.php’ in \/resources\/views\/layouts\/ to make it tidier. especially in the body tag, add class ‘container’ to wrap the content:<\/p>\n
    ...\r\n<body id=\"app-layout\">\r\n    <!--div id=\"app\"-->\r\n    <nav class=\"navbar navbar-default navbar-static-top\">\r\n        ...\r\n    <\/nav>\r\n\r\n    <div class=\"container\">\r\n\r\n        @if (Session::has('flash_message'))\r\n            <div class=\"alert alert-success\">\r\n                {{ Session::get('flash_message') }}\r\n            <\/div>\r\n        @endif\r\n\r\n        @yield('content')\r\n    <\/div>\r\n\r\n    <!-- JavaScripts -->\r\n    ...\r\n<\/body>\r\n...<\/pre>\n
    Then add a form and a few text input in \/resources\/views\/home\/index.blade.php. So it’ll be like this:<\/p>\n
    @extends('layouts.app')\r\n\r\n@section('content')\r\n\r\n    <h1>Welcome, Please fill this form to book a cleaner!<\/h1>\r\n    <hr\/>\r\n\r\n    {!! Form::open(['url' => '\/home\/book\/', 'class' => 'form-horizontal', 'files' => true]) !!}\r\n\r\n    <div class=\"form-group {{ $errors->has('first_name') ? 'has-error' : ''}}\">\r\n        {!! Form::label('first_name', 'First Name', ['class' => 'col-sm-3 control-label']) !!}\r\n        <div class=\"col-sm-6\">\r\n            {!! Form::text('first_name', null, ['class' => 'form-control']) !!}\r\n            {!! $errors->first('first_name', '<p class=\"help-block\">:message<\/p>') !!}\r\n        <\/div>\r\n    <\/div>\r\n    <div class=\"form-group {{ $errors->has('last_name') ? 'has-error' : ''}}\">\r\n        {!! Form::label('last_name', 'Last Name', ['class' => 'col-sm-3 control-label']) !!}\r\n        <div class=\"col-sm-6\">\r\n            {!! Form::text('last_name', null, ['class' => 'form-control']) !!}\r\n            {!! $errors->first('last_name', '<p class=\"help-block\">:message<\/p>') !!}\r\n        <\/div>\r\n    <\/div>\r\n    <div class=\"form-group {{ $errors->has('phone_number') ? 'has-error' : ''}}\">\r\n        {!! Form::label('phone_number', 'Phone Number', ['class' => 'col-sm-3 control-label']) !!}\r\n        <div class=\"col-sm-6\">\r\n            {!! Form::text('phone_number', null, ['class' => 'form-control']) !!}\r\n            {!! $errors->first('phone_number', '<p class=\"help-block\">:message<\/p>') !!}\r\n        <\/div>\r\n    <\/div>\r\n    \r\n\r\n    <div class=\"form-group\">\r\n        <div class=\"col-sm-offset-3 col-sm-3\">\r\n            {!! Form::submit('Create', ['class' => 'btn btn-primary form-control']) !!}\r\n        <\/div>\r\n    <\/div>\r\n    {!! Form::close() !!}\r\n\r\n    @if ($errors->any())\r\n        <ul class=\"alert alert-danger\">\r\n            @foreach ($errors->all() as $error)\r\n                <li>{{ $error }}<\/li>\r\n            @endforeach\r\n        <\/ul>\r\n    @endif\r\n\r\n@endsection<\/pre>\n
    \"mybooking-book-front\"<\/a>The layout looks same with the customer form for adding a new one. But this moment leave it as is. We’re going to change it later with some new features. For the front end booking, it’ll go to ‘\/home\/book\/’ url to save the inputs. We need to add this to our route in \/routes\/web.php<\/p>\n
    ...\r\nRoute::post('\/home\/book', 'Home\\HomeController@book');\r\n...<\/pre>\n
    Then modify \/app\/Http\/Controllers\/Home\/HomeController.php to add a new function ‘book’ to store the data into the customer table.<\/p>\n
    <?php\r\n\r\n...\r\nuse App\\Customer;\r\nuse Session;\r\n\r\nclass HomeController extends Controller\r\n{\r\n    ...\r\n    \r\n    public function book(Request $request)\r\n    {\r\n        $requestData = $request->all();\r\n        \r\n        Customer::create($requestData);\r\n\r\n        Session::flash('flash_message', 'Customer added!');\r\n        return view('home');\r\n    }\r\n}<\/pre>\n
    The ‘book’ function is pretty same with ‘store’ function in CustomerController.php file.
    \nOK. The Next task: “3. Currently we operate in 10 cities, but plan to expand quickly. We need a way to admin the list of cities we operate in and the ability to add to the list. You should create a new table to do this.”<\/span>
    \nFirst we need to create a new model ‘City’. Use artisan to do this job<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan make:model City\r\nModel created successfully.<\/pre>\n
    A new file ‘City.php’ would be in \/app\/ directory. Here is the content<\/p>\n
    <?php\r\n\r\nnamespace App;\r\n\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\n\r\nclass City extends Model\r\n{\r\n    \/\/\r\n}<\/pre>\n
    I’m going to add some variables into the file to represent the table name, the primary key and so on. So it’d be like this:<\/p>\n
    <?php\r\n\r\nnamespace App;\r\n\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\n\r\nclass City extends Model\r\n{\r\n    \/**\r\n     * The database table used by the model.\r\n     *\r\n     * @var string\r\n     *\/\r\n    protected $table = 'cities';\r\n\r\n    \/**\r\n    * The database primary key value.\r\n    *\r\n    * @var string\r\n    *\/\r\n    protected $primaryKey = 'id';\r\n\r\n    \/**\r\n     * Attributes that should be mass-assignable.\r\n     *\r\n     * @var array\r\n     *\/\r\n    protected $fillable = ['city_name'];\r\n}<\/pre>\n
    Then we need to create a new table ‘cities’ via ‘migration’ command<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan make:migration create_cities_table --create=cities\r\nCreated Migration: 2017_01_14_044005_create_cities_table<\/pre>\n
    NOTE: If you get an error like this<\/p>\n
    PHP Fatal error:  Uncaught UnexpectedValueException: The stream or file \"\/home\/teddy\/Documents\/works\/laravel\/mybooking\/storage\/logs\/laravel.log\" could not be opened: failed to open stream: Permission denied in \/home\/teddy\/Documents\/works\/laravel\/mybooking\/vendor\/monolog\/monolog\/src\/Monolog\/Handler\/StreamHandler.php:107\r\nStack trace: ...<\/pre>\n
    it means you need to set the file permission of ‘storage’ directory to 777 in order to let the migration command to create a new file<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ sudo chmod -R 777 storage\/<\/pre>\n
    Here is the migration file created (2017_01_14_044005_create_cities_table.php in \/database\/migrations\/)<\/p>\n
    <?php\r\n\r\nuse Illuminate\\Support\\Facades\\Schema;\r\nuse Illuminate\\Database\\Schema\\Blueprint;\r\nuse Illuminate\\Database\\Migrations\\Migration;\r\n\r\nclass CreateCitiesTable extends Migration\r\n{\r\n    \/**\r\n     * Run the migrations.\r\n     *\r\n     * @return void\r\n     *\/\r\n    public function up()\r\n    {\r\n        Schema::create('cities', function (Blueprint $table) {\r\n            $table->increments('id');\r\n            $table->timestamps();\r\n        });\r\n    }\r\n\r\n    \/**\r\n     * Reverse the migrations.\r\n     *\r\n     * @return void\r\n     *\/\r\n    public function down()\r\n    {\r\n        Schema::dropIfExists('cities');\r\n    }\r\n}<\/pre>\n
    In ‘up’ function, I need to add a new field ‘city_name’ with ‘string’ type. So it’d be like this<\/p>\n
    public function up()\r\n{\r\n    Schema::create('cities', function (Blueprint $table) {\r\n        $table->increments('id');\r\n        $table->string('city_name');\r\n        $table->timestamps();\r\n    });\r\n}<\/pre>\n
    Then do create the new table ‘cities’ via ‘migrate’ command<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php5.6 artisan migrate --database=sqlite\r\nMigrated: 2017_01_14_044005_create_cities_table<\/pre>\n
    NOTE: I got a confusing error the first time when tried to execute ‘migrate’ command. Here is the error<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan migrate --database=sqlite\r\n                         \r\n  [PDOException]         \r\n  could not find driver<\/pre>\n
    I JUST DIDN’T REALIZE MY PHP VERSION VIA TERMINAL IS VERSION 7.0! SO I USE ‘php5.6’ INSTEAD AN IT’S WORKS! IT SEEMS I HAVEN’T CONFIGURED THE PDO FOR SQLITE ON PHP 7.0.
    \nNOTE: ‘migration’ command ONLY RUN ON THE NEW FILE. IT’D NOT RUN THE FILES ALREADY MIGRATED!
    \nNow create a new controller ‘CityController’ in ‘Admin’ directory<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan make:controller Admin\/CityController\r\nController created successfully.<\/pre>\n
    The new file ‘CityController.php’ would be in \/app\/Http\/Controllers\/Admin\/ directory!. Here is the content<\/p>\n
    <?php\r\n\r\nnamespace App\\Http\\Controllers\\Admin;\r\n\r\nuse Illuminate\\Http\\Request;\r\n\r\nuse App\\Http\\Requests;\r\nuse App\\Http\\Controllers\\Controller;\r\n\r\nclass CityController extends Controller\r\n{\r\n    \/\/\r\n}<\/pre>\n
    Here we want some functions\/methods for CRUD the city data. The function much similar within the others controllers like Cleaner. Here it is<\/p>\n
    <?php\r\n\r\nnamespace App\\Http\\Controllers\\Admin;\r\n\r\nuse Illuminate\\Http\\Request;\r\n\r\nuse App\\Http\\Requests;\r\nuse App\\Http\\Controllers\\Controller;\r\nuse App\\City;\r\nuse Session;\r\n\r\nclass CityController extends Controller\r\n{\r\n    \/**\r\n     * Display a listing of the resource.\r\n     *\r\n     * @return \\Illuminate\\View\\View\r\n     *\/\r\n    public function __construct()\r\n    {\r\n        $this->middleware('auth');\r\n    } \r\n    \r\n    public function index()\r\n    {\r\n        $city = City::paginate(25);\r\n\r\n        return view('admin.city.index', compact('city'));\r\n    }\r\n\r\n    \/**\r\n     * Show the form for creating a new resource.\r\n     *\r\n     * @return \\Illuminate\\View\\View\r\n     *\/\r\n    public function create()\r\n    {\r\n        return view('admin.city.create');\r\n    }\r\n\r\n    \/**\r\n     * Store a newly created resource in storage.\r\n     *\r\n     * @param \\Illuminate\\Http\\Request $request\r\n     *\r\n     * @return \\Illuminate\\Http\\RedirectResponse|\\Illuminate\\Routing\\Redirector\r\n     *\/\r\n    public function store(Request $request)\r\n    {\r\n        \r\n        $requestData = $request->all();\r\n        \r\n        City::create($requestData);\r\n\r\n        Session::flash('flash_message', 'City added!');\r\n\r\n        return redirect('admin\/city');\r\n    }\r\n\r\n    \/**\r\n     * Display the specified resource.\r\n     *\r\n     * @param  int  $id\r\n     *\r\n     * @return \\Illuminate\\View\\View\r\n     *\/\r\n    public function show($id)\r\n    {\r\n        $city = City::findOrFail($id);\r\n\r\n        return view('admin.city.show', compact('city'));\r\n    }\r\n\r\n    \/**\r\n     * Show the form for editing the specified resource.\r\n     *\r\n     * @param  int  $id\r\n     *\r\n     * @return \\Illuminate\\View\\View\r\n     *\/\r\n    public function edit($id)\r\n    {\r\n        $city = City::findOrFail($id);\r\n\r\n        return view('admin.city.edit', compact('city'));\r\n    }\r\n\r\n    \/**\r\n     * Update the specified resource in storage.\r\n     *\r\n     * @param  int  $id\r\n     * @param \\Illuminate\\Http\\Request $request\r\n     *\r\n     * @return \\Illuminate\\Http\\RedirectResponse|\\Illuminate\\Routing\\Redirector\r\n     *\/\r\n    public function update($id, Request $request)\r\n    {\r\n        \r\n        $requestData = $request->all();\r\n        \r\n        $city = City::findOrFail($id);\r\n        $city->update($requestData);\r\n\r\n        Session::flash('flash_message', 'City updated!');\r\n\r\n        return redirect('admin\/city');\r\n    }\r\n\r\n    \/**\r\n     * Remove the specified resource from storage.\r\n     *\r\n     * @param  int  $id\r\n     *\r\n     * @return \\Illuminate\\Http\\RedirectResponse|\\Illuminate\\Routing\\Redirector\r\n     *\/\r\n    public function destroy($id)\r\n    {\r\n        City::destroy($id);\r\n\r\n        Session::flash('flash_message', 'City deleted!');\r\n\r\n        return redirect('admin\/city');\r\n    }\r\n}<\/pre>\n
    Then modify our routes in \/routes\/web.php for this ‘city’<\/p>\n
    ...\r\nRoute::resource('admin\/city', 'Admin\\CityController');\r\n...<\/pre>\n
    The last step is to create the blades templates for this ‘city’. Create a new directory ‘city’ in \/resources\/views\/admin\/. Then create some files ‘index.blade.php’, ‘create.blade.php’, ‘edit.blade.php’ and ‘show.blade.php’. The content of the files are pretty similar with Cleaner! Just modify some details like change ‘cleaner’ to ‘city’ and the others things. Also don’t forget to add ‘City’ menu in \/resources\/views\/layouts\/app.blade.php<\/p>\n
    @if (!Auth::guest())\r\n    <ul class=\"nav navbar-nav\">\r\n        <li><a href=\"{{ url('\/admin\/booking') }}\">Booking<\/a><\/li>\r\n        <li><a href=\"{{ url('\/admin\/customer') }}\">Customer<\/a><\/li>\r\n        <li><a href=\"{{ url('\/admin\/cleaner') }}\">Cleaner<\/a><\/li>\r\n        <li><a href=\"{{ url('\/admin\/city') }}\">City<\/a><\/li>\r\n    <\/ul>\r\n@endif\r\n<\/pre>\n
    http:\/\/localhost\/works\/laravel\/mybooking\/public\/admin\/city\"mybooking-city-admin2\"<\/a>The next task: “4. On the admin cleaner form we need a way to select the cities a cleaner works in. This should be a checkbox list populated by the list of the cities we operate in. You may need to create a new table to store this data.”<\/span>.
    \nHere I need to create a new table ‘cleaner_cities’. This new table would store the cleaner id and the city id values. Then I also need to modify the form input of the cleaner to include the cities they can work in (they can select more than one city). Then store the selection in the new table ‘cleaner_cities’. Same solution with the above, we need to create a new model ‘CleanerCity’. Use artisan to do this job<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan make:model CleanerCity\r\nModel created successfully.<\/pre>\n
    Then modify \/app\/CleanerCity.php file to add a few variables like cleaner_id and city_id. So it’d be like this:<\/p>\n
    <?php\r\n\r\nnamespace App;\r\n\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\n\r\nclass CleanerCity extends Model\r\n{\r\n    \/**\r\n     * The database table used by the model.\r\n     *\r\n     * @var string\r\n     *\/\r\n    protected $table = 'cleaner_cities';\r\n\r\n    \/**\r\n    * The database primary key value.\r\n    *\r\n    * @var string\r\n    *\/\r\n    protected $primaryKey = 'id';\r\n\r\n    \/**\r\n     * Attributes that should be mass-assignable.\r\n     *\r\n     * @var array\r\n     *\/\r\n    protected $fillable = ['cleaner_id','city_id'];\r\n}<\/pre>\n
    Then we need to create a new table ‘cleaner_cities’ via ‘migration’ command<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan make:migration create_cleaner_cities_table --create=cleaner_cities\r\nCreated Migration: 2017_01_14_070618_create_cleaner_cities_table<\/pre>\n
    Then modify ‘up’ function in the migration file created (2017_01_14_070618_create_cleaner_cities_table.php in \/database\/migrations\/)<\/p>\n
    public function up()\r\n{\r\n    Schema::create('cleaner_cities', function (Blueprint $table) {\r\n        $table->increments('id');\r\n        $table->integer('cleaner_id');\r\n        $table->integer('city_id');\r\n        $table->timestamps();\r\n    });\r\n}<\/pre>\n
    Use ‘migrate’ command to create the new table<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php5.6 artisan migrate --database=sqlite\r\nMigrated: 2017_01_14_070618_create_cleaner_cities_table<\/pre>\n
    Then modify the model ‘Cleaner.php’ to add ‘City’ and ‘CleanerCity’ model<\/p>\n
    ...\r\npublic function city()\r\n{\r\n    return $this->belongsTo('App\\City');\r\n}\r\n\r\npublic function cleanercity()\r\n{\r\n    return $this->belongsTo('App\\CleanerCity');\r\n}\r\n...<\/pre>\n
    Then modify ‘CleanerController.php’ in \/app\/Https\/Controllers\/Admin\/ directory. For example at ‘create’ function, we need to show up the cities checkboxes. So pass the ‘city’ data in the function<\/p>\n
    ...\r\nuse App\\City;\r\nuse App\\CleanerCity;\r\n...\r\nclass CleanerController extends Controller\r\n{\r\n    static $select_cities;\r\n    ...\r\n    public function __construct()\r\n    {\r\n        \/\/ get cities for checkbox menu\r\n\r\n        $cities = City::all();\r\n        self::$select_cities = [];\r\n        foreach ($cities as $item) {\r\n            self::$select_cities[$item->id] = $item->city_name;\r\n        }\r\n        \r\n        $this->middleware('auth');\r\n    } \r\n    ...\r\n    public function create()\r\n    {\r\n        return view('admin.cleaner.create',[\r\n            'select_cities' => self::$select_cities\r\n        ]);\r\n    }\r\n    ...\r\n}\r\n<\/pre>\n
    Then modify ‘create.blade.php’ in \/resources\/views\/admin\/cleaner\/ directory to display the checboxes<\/p>\n
    <div class=\"form-group\">\r\n    {!! Form::label('city', 'City', ['class' => 'col-sm-3 control-label']) !!}\r\n    <div class=\"col-sm-6\">\r\n        @foreach($select_cities as $idx=>$item)\r\n            <div class=\"chk_city\">{!! Form::checkbox('city[]', $idx, null, ['class' => 'field']) !!} <span>{!! $item !!}<\/span><\/div>\r\n        @endforeach\r\n    <\/div>\r\n<\/div><\/pre>\n
    Here I need to add a class ‘chk_city’ to manage the checkboxes display (side by side). I need to create a new css file ‘style.css’ in \/public\/css\/ directory. Here is the css content<\/p>\n
    .chk_city{\r\n    padding-right: 15px;\r\n    float:left;\r\n}<\/pre>\n
    Also I need to add the css link in \/resources\/views\/layouts\/app.blade.php file<\/p>\n
    ...\r\n<link href=\"{{ URL::asset('css\/style.css') }}\" rel=\"stylesheet\">\r\n...<\/pre>\n
    OK. Here is the looks (http:\/\/localhost\/works\/laravel\/mybooking\/public\/admin\/cleaner\/create)\"mybooking-cleaner-admin-create\"<\/a>OK. To make sure the create cleaner function work properly, modify ‘store’ function in \/app\/Http\/Controllers\/Admin\/CleanerController.php like this:<\/p>\n
    public function store(Request $request)\r\n{\r\n    \r\n    $requestData = $request->all();\r\n    \r\n    \/\/search if this cleaner is already exist in the cleaner table\r\n    $cleaner = Cleaner::where([\r\n        'first_name' => $requestData['first_name'],\r\n        'last_name'=> $requestData['last_name'],\r\n    ])->take(1)->get();\r\n        \r\n    if (count($cleaner) == 0) {\r\n        \r\n        Cleaner::create([\r\n            'first_name'  => $requestData['first_name'],\r\n            'last_name'  => $requestData['last_name'],\r\n            'quality_score'  => $requestData['quality_score'],\r\n        ]);\r\n        \r\n        if(isset($requestData['city'])){\r\n            $new_cleaner = Cleaner::where([\r\n                ['first_name', '=', $requestData['first_name']],\r\n                ['last_name', '=', $requestData['last_name']],\r\n            ])->take(1)->get();\r\n            \r\n            $new_cleaner_id=0;\r\n            foreach ($new_cleaner as $item) {\r\n                $new_cleaner_id = $item->id;\r\n            };\r\n            \r\n            if($new_cleaner_id){\r\n                foreach($requestData['city'] as $city_id){\r\n                    CleanerCity::create([\r\n                        'cleaner_id' => $new_cleaner_id,\r\n                        'city_id' => $city_id,\r\n                    ]);\r\n                }\r\n            }\r\n        }\r\n\r\n        Session::flash('flash_message', 'Cleaner added!');\r\n    }else{\r\n        Session::flash('flash_warning', 'Sorry, Your data is already exist!');\r\n    }\r\n\r\n    return redirect('admin\/cleaner');\r\n}<\/pre>\n
    So this function also check the input if already exist or not then also insert the cleaner_id and city_id into ‘cleaner_cities’ table!
    \nWe can do the same thing for ‘edit’ and ‘update’ function. Modify ‘edit’ and ‘update’ function in \/app\/Http\/Controllers\/Admin\/CleanerController.php like this<\/p>\n
    public function edit($id)\r\n{\r\n    $cleaner = Cleaner::findOrFail($id);\r\n    $cities = self::$select_cities;\r\n    $cleaner_cities = CleanerCity::where('cleaner_id',$id)->select('id','city_id')->get()->toArray();\r\n\r\n    return view('admin.cleaner.edit', compact('cleaner','cities','cleaner_cities'));\r\n}\r\n\r\npublic function update($id, Request $request)\r\n{\r\n    \r\n    $requestData = $request->all();\r\n    \r\n    $cleaner = Cleaner::findOrFail($id);\r\n    $cleaner->update($requestData);\r\n    \r\n    $cleaner_city = CleanerCity::where('cleaner_id',$id)->get();\r\n    \r\n    if (count($cleaner_city) == 0) {\r\n        if($requestData['city']){\r\n            foreach($requestData['city'] as $city_id){\r\n                CleanerCity::create([\r\n                    'cleaner_id' => $id,\r\n                    'city_id' => $city_id,\r\n                ]);\r\n            }\r\n        }\r\n    }else{\r\n        if(isset($requestData['city'])){\r\n            $new_city=$requestData['city'];\r\n            foreach($cleaner_city as $cc){\r\n                if(in_array($cc['city_id'], $requestData['city'])){\r\n                    $new_city=array_diff($new_city, array($cc['city_id']));\r\n                    continue;\r\n                }else{\r\n                    CleanerCity::destroy($cc['id']);\r\n                }\r\n            }\r\n            \r\n            if($new_city){\r\n                foreach($new_city as $city){\r\n                    CleanerCity::create([\r\n                        'cleaner_id' => $id,\r\n                        'city_id' => $city,\r\n                    ]);\r\n                }\r\n            }\r\n        }else{\r\n            foreach($cleaner_city as $cc){\r\n                CleanerCity::destroy($cc['id']);\r\n            }\r\n        }\r\n    }\r\n\r\n    Session::flash('flash_message', 'Cleaner updated!');\r\n\r\n    return redirect('admin\/cleaner');\r\n}<\/pre>\n
    The ‘update’ function is more complicated. If there is no city selected, remove all the cities if exist in the cleaner_cities related to the cleaner_id. If some cities selected and same within the table, just leave it. But if different cities are selected, add the new cities and remove the unselected ones.
    \nThen modify also \/resources\/views\/admin\/cleaner\/edit.blade.php to show the selected\/unselected cities<\/p>\n
    ...\r\n<div class=\"form-group\">\r\n    {!! Form::label('city', 'City', ['class' => 'col-sm-3 control-label']) !!}\r\n    <div class=\"col-sm-6\">\r\n        @foreach($cities as $idx=>$item)\r\n            <?php $checked=null; ?>\r\n            @foreach($cleaner_cities as $city)\r\n                @if($idx == $city['city_id'])\r\n                    <?php $checked=true; ?>\r\n                @endif\r\n            @endforeach\r\n            <div class=\"chk_city\">{!! Form::checkbox('city[]', $idx, $checked, ['class' => 'field']) !!} <span>{!! $item !!}<\/span><\/div>\r\n        @endforeach\r\n    <\/div>\r\n<\/div>\r\n...<\/pre>\n
    Now, we want to display the cities also on the cleaner table. So modify ‘index’ function in \/app\/Http\/Controllers\/Admin\/CleanerController.php like this:<\/p>\n
    public function index()\r\n{\r\n    \/\/$cleaner = Cleaner::paginate(25);\r\n    $cleaner = DB::table('cleaners')\r\n                    ->join('cleaner_cities','cleaners.id','=','cleaner_cities.cleaner_id')\r\n                    ->join('cities','cleaner_cities.city_id','=','cities.id')\r\n                    ->select('cleaners.id','cleaners.first_name','cleaners.last_name','cleaners.quality_score',DB::raw('(GROUP_CONCAT(cities.city_name)) AS city'))\r\n                    ->groupBy('cleaners.id','cleaners.first_name','cleaners.last_name','cleaners.quality_score')\r\n                    ->paginate(25);\r\n\r\n    return view('admin.cleaner.index', compact('cleaner'));\r\n}<\/pre>\n
    Then modify \/resources\/views\/admin\/cleaner\/index.blade.php to display the cities<\/p>\n
    <table class=\"table table-bordered table-striped table-hover\">\r\n    <thead>\r\n        <tr>\r\n            <th>S.No<\/th><th> First Name <\/th><th> Last Name <\/th><th> Quality Score <\/th><th> Cities <\/th><th>Actions<\/th>\r\n        <\/tr>\r\n    <\/thead>\r\n    <tbody>\r\n    @foreach($cleaner as $item)\r\n        <tr>\r\n            <td>{{ $loop->iteration }}<\/td>\r\n            <td>{{ $item->first_name }}<\/td><td>{{ $item->last_name }}<\/td><td>{{ $item->quality_score }}<\/td>\r\n            <td>{{ $item->city }}<\/td>\r\n            <td>\r\n                ...\r\n            <\/td>\r\n        <\/tr>\r\n    @endforeach\r\n    <\/tbody>\r\n<\/table><\/pre>\n
    Here is the looks:\"mybooking-cleaner-admin-index\"<\/a>The last thing for the ‘show’ function. Modify the function to get the cities then pass it to the view<\/p>\n
    public function show($id)\r\n{\r\n    $cleaner = Cleaner::findOrFail($id);\r\n    $cleaner_cities = DB::table('cleaner_cities')\r\n                    ->join('cities','cleaner_cities.city_id','=','cities.id')\r\n                    ->select(DB::raw('(GROUP_CONCAT(cities.city_name)) AS city_name'))\r\n                    ->where('cleaner_cities.cleaner_id',$id)\r\n                    ->groupBy('cities.city_name')\r\n                    ->get();\r\n\r\n    return view('admin.cleaner.show', compact('cleaner','cleaner_cities'));\r\n}<\/pre>\n
    Then modify \/resources\/views\/admin\/cleaner\/show.blade.php, to display the cities<\/p>\n
    <div class=\"table-responsive\">\r\n    <table class=\"table table-bordered table-striped table-hover\">\r\n        <tbody>\r\n            <tr>\r\n                <th>ID<\/th><td>{{ $cleaner->id }}<\/td>\r\n            <\/tr>\r\n            <tr>\r\n                <th> First Name <\/th><td> {{ $cleaner->first_name }} <\/td>\r\n            <\/tr>\r\n            <tr>\r\n                <th> Last Name <\/th><td> {{ $cleaner->last_name }} <\/td>\r\n            <\/tr>\r\n            <tr>\r\n                <th> Quality Score <\/th><td> {{ $cleaner->quality_score }} <\/td>\r\n            <\/tr>\r\n            <tr>\r\n                <th> City <\/th><td> {{ $cleaner_cities->implode('city_name', ', ') }} <\/td>\r\n            <\/tr>\r\n        <\/tbody>\r\n    <\/table>\r\n<\/div><\/pre>\n
    COMPLETED!
    \nThe next task: “5. We need a way for customers to signup and schedule a booking all on one form. To accomplish this you will need to do the following:<\/span>
    \n – Make the site root a customer-facing form designed for customers to sign up and book a cleaner.<\/span>
    \n – On this form, capture all the data needed to create a customer in the database (first name, last name, phone number).”
    \n<\/span>We already have it. Please look http:\/\/localhost\/works\/laravel\/mybooking\/public\/home. Also look the two routes for this in \/routes\/web.php<\/p>\n
    Route::get('\/home', 'Home\\HomeController@index');\r\nRoute::post('\/home\/book', 'Home\\HomeController@book');<\/pre>\n
    Look the function ‘index’ and ‘book’ (We’ll get it done at the next task) in \/app\/Http\/Controllers\/Home\/HomeController.php.
    \n “- If the customer already exists in the database (use phone number to determine this) use the existing record instead of creating a new one. You should probably add a validation to enforce this.”
    \n<\/span>Modify \/app\/Http\/Controllers\/Home\/HomeController.php at ‘book’ function like this:<\/p>\n
    public function book(Request $request)\r\n{\r\n    $requestData = $request->all();\r\n    \r\n    $customer = Customer::where('phone_number',$requestData['phone_number'])->take(1)->get();\r\n    \r\n    if (count($customer) == 0) {\r\n        \/\/create\/register a new customer\r\n        \r\n        Customer::create([\r\n            'first_name'  => $requestData['first_name'],\r\n            'last_name'  => $requestData['last_name'],\r\n            'phone_number'  => $requestData['phone_number'],\r\n        ]);\r\n\r\n        Session::flash('flash_message', 'Customer added!');\r\n    }else{\r\n        Session::flash('flash_warning', 'Sorry, A customer with phone number \"'.$requestData['phone_number'].'\" is already exist!');\r\n    }\r\n\r\n    return view('home.index');\r\n}<\/pre>\n
    Here we add a check and validation if a phone number entered is already exist in the customer table. If so, please give a message about it. Here is the look\"mybooking-front-customer\"<\/a>
    \n “- Let the customer select what city they are in from the cities table created earlier.”
    \n<\/span>Modify \/app\/Http\/Controllers\/Home\/HomeController.php to add the city data and pass it to the view<\/p>\n
    ...\r\nuse App\\City;\r\n...\r\nclass HomeController extends Controller\r\n{\r\n    static $select_cities;\r\n    \r\n    public function __construct()\r\n    {\r\n        \/\/ get cities\r\n\r\n        $cities = City::all();\r\n        self::$select_cities = [];\r\n        foreach ($cities as $item) {\r\n            self::$select_cities[$item->id] = $item->city_name;\r\n        }\r\n    } \r\n    \r\n    public function index(){\r\n        \r\n        return view('home.index',[\r\n            'select_cities' => self::$select_cities\r\n        ]);\r\n    }\r\n    \r\n    ...\r\n}<\/pre>\n
    Then show the city selection in \/resources\/views\/home\/index.blade.php file<\/p>\n
    ...\r\n<div class=\"form-group\">\r\n    {!! Form::label('city_id', 'Cleaner', ['class' => 'col-sm-3 control-label']) !!}\r\n    <div class=\"col-sm-6\">\r\n        {!! Form::select('city_id', $select_cities, null, ['class' => 'form-control']) !!}\r\n        {!! $errors->first('city_id', '<p class=\"help-block\">:message<\/p>') !!}\r\n    <\/div>\r\n<\/div>\r\n...<\/pre>\n
    Here is the new looks:\"mybooking-front-customer-city\"<\/a>We’ll do the rest after working on the below task!
    \n “- Let the customer specify a date and time when they would like their house cleaned.”
    \n<\/span>Put like this to show the datetime inputs in \/resources\/views\/home\/index.blade.php file<\/p>\n
    ...\r\n<div class=\"form-group {{ $errors->has('date') ? 'has-error' : ''}}\">\r\n    {!! Form::label('cleaning_time_from', 'Cleaning Time (From)', ['class' => 'col-sm-3 control-label']) !!}\r\n    <div class=\"col-sm-6\">\r\n        <div class='input-group date' id='dtp_cleaning_form'>\r\n            <input type='text' class=\"form-control\" name=\"cleaning_time_from\" \/>\r\n            <span class=\"input-group-addon\">\r\n                <span class=\"glyphicon glyphicon-calendar\"><\/span>\r\n            <\/span>\r\n        <\/div>\r\n        {!! $errors->first('cleaning_time_from', '<p class=\"help-block\">:message<\/p>') !!}\r\n    <\/div>\r\n<\/div>\r\n<div class=\"form-group {{ $errors->has('date') ? 'has-error' : ''}}\">\r\n    {!! Form::label('cleaning_time_to', 'Cleaning Time (To)', ['class' => 'col-sm-3 control-label']) !!}\r\n    <div class=\"col-sm-6\">\r\n        <div class='input-group date' id='dtp_cleaning_to'>\r\n            <input type='text' class=\"form-control\" name=\"cleaning_time_to\" \/>\r\n            <span class=\"input-group-addon\">\r\n                <span class=\"glyphicon glyphicon-calendar\"><\/span>\r\n            <\/span>\r\n        <\/div>\r\n        {!! $errors->first('cleaning_time_to', '<p class=\"help-block\">:message<\/p>') !!}\r\n    <\/div>\r\n<\/div>\r\n...<\/pre>\n
    I added two datetime input here: Cleaning Time (From) and Cleaning Time (To). I can’t use ‘Form::date’ here because I need ‘Datetime’ not just ‘Date’. I have to use datetimepicker from bootstrap. To make sure the dropdown of the datetime work properly, I have to add\/import ‘bootstrap-datetimepicker’ libraries in \/resources\/views\/layouts\/app.blade.php file<\/p>\n
    ...\r\n<!-- Styles -->\r\n...\r\n<link rel=\"stylesheet\" href=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/bootstrap-datetimepicker\/4.17.37\/css\/bootstrap-datetimepicker.min.css\" crossorigin=\"anonymous\" \/>\r\n...\r\n<!-- JavaScripts -->\r\n...\r\n<script src=\"https:\/\/cdnjs.cloudflare.com\/ajax\/libs\/bootstrap-datetimepicker\/4.17.37\/js\/bootstrap-datetimepicker.min.js\" crossorigin=\"anonymous\"><\/script>\r\n<script type=\"text\/javascript\">\r\n    $(function () {\r\n        $('#dtp_cleaning_form').datetimepicker();\r\n        $('#dtp_cleaning_to').datetimepicker();\r\n    });\r\n<\/script>\r\n...<\/pre>\n
    Here is the looks\"mybooking-front-datetime\"<\/a>Then I need to create a new model ‘CityCleaningTime’ to store the city id and the cleanings time.<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan make:model CityCleaningTime<\/pre>\n
    Then modify ‘CityCleaningTime.php’ file<\/p>\n
    <?php\r\n\r\nnamespace App;\r\n\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\n\r\nclass CityCleaningTime extends Model\r\n{\r\n    \/**\r\n     * The database table used by the model.\r\n     *\r\n     * @var string\r\n     *\/\r\n    protected $table = 'citycleaningtimes';\r\n\r\n    \/**\r\n    * The database primary key value.\r\n    *\r\n    * @var string\r\n    *\/\r\n    protected $primaryKey = 'id';\r\n\r\n    \/**\r\n     * Attributes that should be mass-assignable.\r\n     *\r\n     * @var array\r\n     *\/\r\n    protected $fillable = ['customer_id', 'city_id', 'cleaning_time_from', 'cleaning_time_to'];\r\n}<\/pre>\n
    Then do migration to create the migration file<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php artisan make:migration create_citycleaningtimes_table --create=citycleaningtimes<\/pre>\n
    Then do migrate to create the new table ‘citycleaningtimes’.<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php5.6 artisan migrate --database=sqlite<\/pre>\n
    NOTE: I did some mistakes about the migration file and the migrate. First I forgot to put ‘customer_id’ in the migration file. I realized it after I created the new table. I updated the migration file and did the migrate but I got a message ‘Nothing to migrate.’\u00a0 Because I was in a hurry, I deleted the migration file so I thought I can create a new one. But when I wanted to create the new migration file, I got this error:<\/span><\/p>\n
    [ErrorException]                                                             \r\n  include(\/home\/teddy\/Documents\/works\/laravel\/mybooking\/vendor\/composer\/..\/..  \r\n  \/database\/migrations\/2017_01_16_141740_create_citycleaningtimes_table.php):  \r\n   failed to open stream: No such file or directory<\/pre>\n
    To solve this problem, I have to type this ‘composer dump-autoload’:<\/span><\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ composer dump-autoload<\/pre>\n
    Then did the migration again. After fixing the file, I wanted to create the table again. But, of course, the same table is already exists!<\/span><\/p>\n
    [PDOException]                                                              \r\n  SQLSTATE[HY000]: General error: 1 table \"citycleaningtimes\" already exists<\/pre>\n
    I tried to fix this mistake by doing the ‘migrate:rollback’<\/span><\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php5.6 artisan migrate:rollback<\/pre>\n
    But I got another error<\/span><\/p>\n
    [ErrorException]                                                   \r\n  Undefined index: 2017_01_16_141740_create_citycleaningtimes_table<\/pre>\n
    Then I created again (manually) the old migration file (copy and paste the new migration file then rename it!). I did the rollback again. but here is another error:<\/span><\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/mybooking$ php5.6 artisan migrate:rollback\r\nPHP Fatal error:  Cannot redeclare class CreateCitycleaningtimesTable in \/home\/teddy\/Documents\/works\/laravel\/mybooking\/database\/migrations\/2017_01_16_151401_create_citycleaningtimes_table.php on line 35<\/pre>\n
    After some thought, I have to remove (or move it to another directory) the new migration file and let the old one (the above name!). Then did the rollback again. SUCCESS! Fixed the old migration file by adding ‘customer_id’ then did the migrate again. SUCCESS!<\/span>
    \nOK. HERE IS THE IMPORTANT LESSON, IF I FOUND AN ERROR\/NOT COMPLETED IN MY LAST MIGRATE\/MIGRATION FILE, DO THE ROLLBACK<\/span> IF THE TABLE IS ALREADY CREATED! DONT REMOVE THE MIGRATION FILE!<\/span>.
    \n “- When the user submits the form, look for cleaners that work in the specified city that do not have any bookings that conflict with the time specified.<\/span>
    \n – If you can find an available cleaner, create the booking and display the name of the cleaner assigned to the booking.<\/span>
    \n – If you can’t find an available cleaner, tell the user that we could not fulfill their request.”<\/span><\/li>\n
  8. First, add a free theme like bootstrap or materialize css<\/a>.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
    Source: (local) http:\/\/localhost\/works\/laravel\/mybooking\/public\/ (from) https:\/\/github.com\/prehire\/php-23093023909ad09a09 TASK: NOTE: I do this without using because it’s heavier for my laptop. I can use vagrant later but need to set some configuration. Please read Laravel Homestead VirtualBox Vagrant. Copy the available local ‘php-23093023909ad09a09’ directory then paste to be\u00a0‘mybooking’. If you dont have the source code of ‘php-23093023909ad09a09’, then … Continue reading “My Booking App”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,13],"tags":[],"class_list":["post-1466","post","type-post","status-publish","format-standard","hentry","category-laravel","category-tutorial"],"_links":{"self":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1466","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/comments?post=1466"}],"version-history":[{"count":40,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1466\/revisions"}],"predecessor-version":[{"id":1534,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1466\/revisions\/1534"}],"wp:attachment":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/media?parent=1466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/categories?post=1466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/tags?post=1466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}