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:
- Simple, fast routing engine.
- Powerful dependency injection container.
- Multiple back-ends for session and cache storage.
- Expressive, intuitive database ORM.
- Database agnostic schema migrations.
- Robust background job processing.
- Real-time event broadcasting.
Laravel is accessible, powerful, and provides tools required for large, robust applications.
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.
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.
- Vehikl
- Tighten Co.
- WebReinvent
- Kirschbaum Development Group
- 64 Robots
- Curotec
- Cyber-Duck
- DevSquad
- Jump24
- Redberry
- Active Logic
- byte5
- OP.GG
Thank you for considering contributing to the Laravel framework! The contribution guide can be found in the Laravel documentation.
In order to ensure that the Laravel community is welcoming to all, please review and abide by the Code of Conduct.
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.
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);