Accounting application of the COGIP

• Type of challenge: consolidation
• Repository: COGIP-app
• Duration: 10 days 🕓
• Deadline: 19/04/2021 17:00 🔔
• Team:
  • Back: Samuel Letocart & Pierre Ricci
  • Front: Pierre Ricci
  • Other: Natascha Gritte.

Missions objectives

• Use of different URL parameters and filename
• Use of sanitization to avoid SQL injections
• Validation of data
• Construction of a functional relational database
• Use of correct joins in SQL
• Use of aliases in your SQL request
• Implementation of a CRUD to read, add, modify and delete data

At the end of this challenge we should be able to:

• Crypt password in a database (NEVER store unhashed / unencrypted passwords). Use password_hash() for this.
• Use an MVC structure
• Use a router
• Setup a session
• Allow access to certain page in regards to permissions

The mission

The COGIP is a company which we don't know an all lot about apart that they produce Jean-Michel toys and that they are serious workers. They also have a incredible team spirit within their rank.

Jean-Christian Ranu works in accounting at the COGIP. He has been using an old, ugly and incomplete software for years, making him go between it and excels sheet. Jean-Christian like paella, crosswords and his coworker Muriel Perrache.

So we coded a web application which will (we hope) respond to the needs and desire of Jean-Christian.

Requirements

We will use the MVC structure provided in the PHP MVC Boilerplate repo provided by our coach, to help us on our way!

Link to our app:

Our deployed app !