#Crud Tickets

React+Laravel+MySQL app with tickets management and auth login

Technologies: Frontend React JavaScript, Backend Laravel Rest API Server using MySQL Data Base.

Getting Started

These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.

Prerequisites

• Composer https://getcomposer.org/
• nodejs + npm https://nodejs.org/en/download/
• XAMP (or another package that supports MySQL DB) https://www.apachefriends.org/es/index.html

Optional for test:

• Postman https://www.getpostman.com/

Installation

Install via git clone

1. $ git clone https://github.com/fquevedo/crud_tickets
2. $ cd crud_tickets
3. $ composer install
4. $ cd client && npm install

Database Configuration

First import database.sql (located in root) from MySQL and call "gestion_tickets" to the new database then set database name, user and password on database.php configuration laravel file:

        'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'gestion_tickets'),
            'username' => env('DB_USERNAME', 'root'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
        ]

Deploy

deploy using this command:

5. $ npm run dev

Running the tests

http://localhost:3000

Built With

• Node.js - JavaScript runtime built
• React - JavaScript library
• Postman - For test Api requests

Authors

• Fernando Quevedo - Initial work - fquevedo