CRUD Consulting Room: “Vientos de Libertad”

1. Project description:

  • This project develops a database with PHP for a client who has an alternative therapy clinic.
  • This purpose is to record telephone calls, linked to the day the procedure is carried out, and this assign an appointment to the patients who call the office.
  • This the database will be managed by a person who works as an administrator or in said office.

2. User stories:

Our client requests us:

  • Visualize in the home of the form, all the appointments.
  • Have an "Add" button to add your clients.
  • Have a “Cancel” button to cancel the form submission and return to the main panel.
  • Have a "Reset" button to delete the data from the fields where it has been entered, staying in the same panel.
  • Have an "Edit" button to be able to correct the data entered.

3. Team members:

4. Project Demo

For live version of the project, run the code with Live Server.

5. Next Steps

  • Improve the design of the start form with the appointment request and the table where the record of the assigned appointments appears, through the use of CSS and Bootstrap.

6. Initial Sketch & Designs (Screenshots)

Sketch

Sketch

Figma

Figma

7. Final Design & Atomic Design

Final Design

New Register Modify Appointments Appointments Register

Atomic Design

Atomic Design

8. Stacks

  • Frontend: HTML & CSS3.
  • Backend: PHP.
  • Final design & Sketch: FIGMA.
  • Backend: PHP.
  • Database: MySQL.

9. Required

  • Composer installed.
  • MySQL.
  • PHP (Minimum, version 7.4).

To install project:

  • Access preview with Live Server and use browser inspection.
  • In the link https://github.com/raquel2002x/vientosDeLibertad access the CODE tab.
  • Within the CODE tab copy the link that appears in HTTPS.
  • In Visual Studio Code run git clone an paste the HTTPS.
  • run composer install.
  • Create database in PhpMyAdmin with database name: vientosdelibertadbbdd
  • Import the following database table: vientosdelibertad\Public\import\appointments.sql
  • Test: vendor/bin/phpunit tests/CoderTest.php (4 tests, 4 assertions)

10. Methodology:

  • Pair Programming.
  • Mob Programming.
  • AGILE with SCRUM.