{"id":1442,"date":"2017-01-11T08:33:12","date_gmt":"2017-01-11T08:33:12","guid":{"rendered":"http:\/\/myprojects.advchaweb.com\/?p=1442"},"modified":"2017-01-12T04:27:57","modified_gmt":"2017-01-12T04:27:57","slug":"cleaner-booking","status":"publish","type":"post","link":"https:\/\/myprojects.advchaweb.com\/index.php\/2017\/01\/11\/cleaner-booking\/","title":{"rendered":"Cleaner Booking"},"content":{"rendered":"

Source: https:\/\/github.com\/ricardoandrietta\/cleaner_booking<\/a>
\nand https:\/\/github.com\/MasterHans\/HomeWork (better!)<\/a><\/p>\n

Installation:<\/p>\n

    \n
  1. Clone the app\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel$ git clone https:\/\/github.com\/ricardoandrietta\/cleaner_booking.git\r\nCloning into 'cleaner_booking'...\r\nremote: Counting objects: 221, done.\r\nremote: Total 221 (delta 0), reused 0 (delta 0), pack-reused 221\r\nReceiving objects: 100% (221\/221), 243.69 KiB | 150.00 KiB\/s, done.\r\nResolving deltas: 100% (72\/72), done.\r\nChecking connectivity... done.<\/pre>\n
     <\/li>\n
  2. Go to the new directory ‘cleaner_booking’ then use composer to install the dependencies\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel$ cd cleaner_booking\/\r\nteddy@teddy-K43SJ:~\/Documents\/works\/laravel\/cleaner_booking$ composer install\r\n...\r\nGenerating optimized class loader\r\nThe compiled class file has been removed.<\/pre>\n
     <\/li>\n
  3. Here i use sqlite (pls see \/config\/database.php file) as a default database\n
    'default' => 'sqlite',<\/pre>\n
    and here is the configuration in the same file.<\/p>\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
    The database ‘homework_database.sqlite’ in \/database\/ directory!
    \nNOTE: To open .sqlite file manually, I need to install ‘sqlitebrowser’ (ref:http:\/\/askubuntu.com\/questions\/805219\/how-to-properly-view-a-sqlite-file-using-sqlite<\/a>)<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/cleaner_booking$ sudo apt-get install sqlitebrowser<\/pre>\n
    The application menu in Programming -> SQLite database browser<\/li>\n
  4. Modify the files permission in \/storage\/ and \/bootstrap\/ AND ALSO \/database (because it need to update the sqlite database!) directories\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/cleaner_booking$ sudo chmod -R 777 storage\/\r\nteddy@teddy-K43SJ:~\/Documents\/works\/laravel\/cleaner_booking$ sudo chmod -R 777 bootstrap\/\r\nteddy@teddy-K43SJ:~\/Documents\/works\/laravel\/HomeWork$ sudo chmod -R 777 database\/<\/pre>\n
    OR I CAN MODIFY \/config\/database.php on the ‘connection’ like this:<\/p>\n
    'sqlite' => [\r\n    'driver' => 'sqlite',\r\n    'database' => storage_path('homework_database.sqlite'),\r\n    'prefix' => '',\r\n],\r\n<\/pre>\n
    Change ‘database_path’ to ‘storage_path’ (ref: http:\/\/stackoverflow.com\/questions\/30382554\/sqlite-unable-to-open-database-file-laravel-windows<\/a>)<\/li>\n
  5. Test the app (refer to the below errors if exist!) http:\/\/localhost\/works\/laravel\/cleaner_booking\/public\/\"cleaner-booking-front\"<\/a>and http:\/\/localhost\/works\/laravel\/HomeWork\/public\/home\"homework-front\"<\/a>For registering an user: http:\/\/localhost\/works\/laravel\/cleaner_booking\/public\/register. use user: ‘Admin’, email: ‘advcha@yahoo.com’ and password: ‘admin123’
    \nAdmin Customer: http:\/\/localhost\/works\/laravel\/HomeWork\/public\/admin\/customer
    \nAdmin Cleaner: http:\/\/localhost\/works\/laravel\/HomeWork\/public\/admin\/cleaner
    \nAdmin Booking: http:\/\/localhost\/works\/laravel\/HomeWork\/public\/admin\/booking
    \nAdmin City: http:\/\/localhost\/works\/laravel\/HomeWork\/public\/admin\/city
    \nAdmin Time selection: http:\/\/localhost\/works\/laravel\/HomeWork\/public\/admin\/time-gaps<\/li>\n
  6. Errors:\n
    PDOException in Connector.php line 119:\r\ncould not find driver<\/pre>\n
    Solution:
    \nI’ve tried many suggestion from here:     https:\/\/www.digitalocean.com\/community\/questions\/how-to-enable-extension-pdo-in-ubuntu-14-04<\/a>. I checked if php5-mysql package is installed or not<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/cleaner_booking$ dpkg-query --status php5-mysql | grep Status\r\nStatus: install ok installed<\/pre>\n
    It’s installed. From this link https:\/\/www.drupal.org\/docs\/7\/system-requirements\/what-is-pdo<\/a>, I modified my php.ini (sudo gedit \/etc\/php\/5.6\/apache2\/php.ini), I added these two lines<\/p>\n
    extension=pdo.so\r\nextension=pdo_mysql.so<\/pre>\n
    Then I checked my php info in http:\/\/localhost\/info.php. The PDO MySQL is exist! But The above error still persist!.
    \nThis link     http:\/\/stackoverflow.com\/questions\/2852748\/pdoexception-could-not-find-driver?rq=1<\/a> finally make it works. I need to install sqlite and php5-sqlite (for php 5.6) or php-sqlite3 (for php7)<\/p>\n
    For PHP 7\r\nteddy@teddy-K43SJ:~\/Documents\/works\/laravel\/cleaner_booking$ sudo apt-get install sqlite php-sqlite3\r\n\r\nFor PHP 5.6\r\nteddy@teddy-K43SJ:~\/Documents\/works\/laravel\/cleaner_booking$ sudo apt-get install php5-sqlite<\/pre>\n
    Check phpinfo, PDO SQLITE (pdo_sqlite) should be existed!
    \nRestart Apache server!<\/p>\n
    Another error when trying to register: http:\/\/localhost\/works\/laravel\/HomeWork\/public\/register<\/p>\n
    SQLSTATE[HY000]: General error: 8 attempt to write a readonly database\r\nSQLSTATE[HY000]: General error: 8 attempt to write a readonly database (SQL: insert into \"users\" (\"name\", \"email\", \"password\", \"updated_at\", \"created_at\") values (Admin, advcha@yahoo.com, $2y$10$uzxAC6sJTEmX8310QBrwW.ONGrjiht\/3aP2CWepsR0kjpdayse1iC, 2017-01-11 14:48:25, 2017-01-11 14:48:25))<\/pre>\n
    Solution:<\/p>\n
    teddy@teddy-K43SJ:~\/Documents\/works\/laravel\/HomeWork$ sudo chmod -R 777 database\/homework_database.sqlite<\/pre>\n
    BUT GOT ANOTHER ERROR:<\/p>\n
    SQLSTATE[HY000]: General error: 14 unable to open database file (SQL: insert into \"users\" (\"name\", \"email\", \"password\", \"role\", \"updated_at\", \"created_at\") values (Admin, advcha@yahoo.com, $2y$10$TuL4RS2rB5tUsd.wDhcK9eONLt\/pKsh8miQbWVJijojMihA9egC1S, 2, 2017-01-11 14:47:38, 2017-01-11 14:47:38))<\/pre>\n
    Solution: see #4 –> modify \/database\/ permission or modify \/config\/database.php
    \nAlso modify .env file and remove ‘DB_…’ related setting but change<\/p>\n
    DB_CONNECTION=sqlite<\/pre>\n
     <\/li>\n
  7. TASK SUMMARY!
    \nFor     https:\/\/github.com\/MasterHans\/HomeWork<\/a>
    \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)<\/p>\n
    Setup<\/strong>
    \n    https:\/\/github.com\/prehire\/php-23093023909ad09a09<\/a>
    \nFor     https:\/\/github.com\/ricardoandrietta\/cleaner_booking<\/a>.
    \nSummary<\/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<\/ol>\n","protected":false},"excerpt":{"rendered":"
    Source: https:\/\/github.com\/ricardoandrietta\/cleaner_booking and https:\/\/github.com\/MasterHans\/HomeWork (better!) Installation: Clone the app teddy@teddy-K43SJ:~\/Documents\/works\/laravel$ git clone https:\/\/github.com\/ricardoandrietta\/cleaner_booking.git Cloning into ‘cleaner_booking’… remote: Counting objects: 221, done. remote: Total 221 (delta 0), reused 0 (delta 0), pack-reused 221 Receiving objects: 100% (221\/221), 243.69 KiB | 150.00 KiB\/s, done. Resolving deltas: 100% (72\/72), done. Checking connectivity… done.   Go to the new … Continue reading “Cleaner Booking”<\/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-1442","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\/1442","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=1442"}],"version-history":[{"count":19,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1442\/revisions"}],"predecessor-version":[{"id":1473,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/posts\/1442\/revisions\/1473"}],"wp:attachment":[{"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/media?parent=1442"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/categories?post=1442"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/myprojects.advchaweb.com\/index.php\/wp-json\/wp\/v2\/tags?post=1442"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}