Skip to content

EdilsonBaggio/LaravelPadrao

Repository files navigation

Laravel Logo

Build Status Total Downloads Latest Stable Version License

About Laravel

Laravel is a web application framework with expressive, elegant syntax. We believe development must be an enjoyable and creative experience to be truly fulfilling. Laravel takes the pain out of development by easing common tasks used in many web projects, such as:

Laravel is accessible, powerful, and provides tools required for large, robust applications.

Learning Laravel

Laravel has the most extensive and thorough documentation and video tutorial library of all modern web application frameworks, making it a breeze to get started with the framework.

You may also try the Laravel Bootcamp, where you will be guided through building a modern Laravel application from scratch.

If you don't feel like reading, Laracasts can help. Laracasts contains over 2000 video tutorials on a range of topics including Laravel, modern PHP, unit testing, and JavaScript. Boost your skills by digging into our comprehensive video library.

Laravel Sponsors

We would like to extend our thanks to the following sponsors for funding Laravel development. If you are interested in becoming a sponsor, please visit the Laravel Partners program.

Premium Partners

Contributing

Thank you for considering contributing to the Laravel framework! The contribution guide can be found in the Laravel documentation.

Code of Conduct

In order to ensure that the Laravel community is welcoming to all, please review and abide by the Code of Conduct.

Security Vulnerabilities

If you discover a security vulnerability within Laravel, please send an e-mail to Taylor Otwell via [email protected]. All security vulnerabilities will be promptly addressed.

License

The Laravel framework is open-sourced software licensed under the MIT license.

View de teste para o banco de dados

-- padrao.dados_veiculo_garagem_v2 source

CREATE OR REPLACE ALGORITHM = UNDEFINED VIEW dados_veiculo_garagem AS select p.id AS id_motorista, p.name AS motorista_nome, p.cnh AS cnh_motorista, v.modelo AS veiculo_modelo, v.marca AS veiculo_marca, v.cor AS veiculo_cor, v.placa AS placa_carro, g.qtd_vagas AS vagas_totais_garagem, g.nome AS garagem_nome, v.deleted_at AS deleted_at, (g.qtd_vagas - ifnull((select count(v_sub.id) from veiculos v_sub where ((v_sub.garagem_id = g.id) and (v_sub.deleted_at is null))), 0)) AS vagas_disponiveis, ifnull((select count(v_sub.id) from veiculos v_sub where ((v_sub.garagem_id = g.id) and (v_sub.deleted_at is null))), 0) AS carros_quantidade from ((pessoas p left join veiculos v on ((v.usuario_id = p.id))) left join garagens g on ((g.id = v.garagem_id))) where (v.deleted_at is null);

About

Projeto com Docker integrado para estudos.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published