download with all files, complete transport system in Laravel with roles, role permissions, apply cubic admin HTML template, each table with its respective CRUD and download information in PDF and Excel formats using dompdf, fill the tables with random data, different reports in diagrams and PDF and Excel from the matrix table, Authentication with role assignment on registration, Complete migrations, seeders, controllers, models, views, routes, and tests, Docker setup for easy deployment, with the following structure:
table vehiculos
field id_vehiculo, type field integer maximum 11 digits, autoincremental primary key;
field placa_vehiculo, type field varchar máximo 10 caracteres;
field tipo_camion, type field varchar máximo 30 caracteres.
table clientes
field id_cliente, type field integer maximum 11 digits, autoincremental primary key;
field identificacion_cliente, type field varchar max length;
field nombre_cliente, type field varchar max length.
table usuarios_contables
field id_usuario_contable, type field integer maximum 11 digits, autoincremental primary key;
field identificacion, type field varchar max length;
field nombres, type field varchar max length;
field apellidos, type field varchar max length;
field cargo, type field varchar max length.
table tarifas
field id_tarifa, type field integer maximum 11 digits, autoincremental primary key;
field id_cliente, type field integer maximum 11 digits;
field origen_destino, type field varchar max length;
field id_vehiculo, type field integer maximum 11 digits;
field trayecto, type field varchar max length;
field total, type field integer maximum 11 digits;
field year, type field integer máximo 5 digitos;
field costo, type field integer máximo 15 digitos.
table conductores
field id_conductor, type field integer maximum 11 digits, autoincremental primary key;
field identificacion_conductor, type field varchar max length;
field nombres, type field varchar max length;
field apellidos, type field varchar max length.
tables rutas
field id_rutas, type field integer maximum 11 digits, autoincremental primary key;
field ruta, type field varchar max length;
field vehiculo, type field varchar max length;
field flypass, type field varchar max length;
field flypass_peajes, type field varchar max length;
field no_flypass_peajes, type field varchar max length.
table programas
field id_programa, type field integer maximum 11 digits, autoincremental primary key
field descripcion, type field varchar max length.
table clasificaciones_facturas
field id_clasificacion_factura, type field integer maximum 11 digits, autoincremental primary key;
field descripcion, type field varchar max length.
table tipos_recaudos
field id_tipo_recaudo, type field integer maximum 11 digits, autoincremental primary key;
field descripcion, type field varchar max length.
table carteras
field id_carteras, type field integer maximum 11 digits, autoincremental primary key;
field descripcion, type field varchar max length.
table ordenes_conductores
field id_orden_conductor, type field integer maximum 11 digits, autoincremental primary key;
field marca_temporal, type field timestamp;
field fecha, type field datetime;
field hora, type field time;
field no_viaje, type field integer máximo 3 digitos;
field origen, type field varchar max length;
field destino, type field varchar max length;
field estado, type field varchar máximo 15 caracteres;
field manifiesto, type field longitud de 3 caracteres;
field id_vehiculo, type field integer maximum 11 digits;
field id_cliente, type field integer maximum 11 digits;
field id_conductor, type field integer maximum 11 digits;
field observacion_ard_conductores, type field lontext;
field dias_semanas, type field integer máximo 3 digitos.
table ordenes_servicios
field id_orden_servicio, type field integer maximum 11 digits, autoincremental primary key;
field id_orden_conductor, type field integer maximum 11 digits;
field marca_temporal, type field timestamp;
field valor, type field integer máximo 30 digitos;
field anticipo_conductor, type field integer máximo 30 digitos;
field anticipo_cliente, type field integer máximo 30 digitos;
field confirmado, type field varchar max length;
field id_programa, type field integer maximum 11 digits;
field pasado, type field varchar max length;
field observacion_orden, type field varchar max length.
table anticipos
field id_anticipos, type field integer maximum 11 digits, autoincremental primary key;
field fecha_inicial, type field datetime;
field fecha_final, type field datetime;
field nombre, type field varchar max length;
field id_orden_servicio, type field integer maximum 11 digits;
field id_cliente, type field integer maximum 11 digits;
field id_vehiculo, type field integer maximum 11 digits;
field flete, type field integer máximo 3 digitos;
field viaticos_conductor, type field integer máximo 3 digitos;
field nombre, type field varchar max length;
field coesco, type field varchar max length;
field terpel, type field integer maximum 11 digits;
field 18porciento_acpm, type field integer maximum 11 digits;
field flypass, type field integer maximum 11 digits;
field 8porciento_peaje, type field integer maximum 11 digits;
field parko, type field integer maximum 11 digits;
field hotel, type field integer maximum 11 digits;
field rstrt, type field integer maximum 11 digits;
field planilla, type field integer maximum 11 digits;
field imprevisto, type field integer maximum 11 digits;
field comision_12porciento, type field integer maximum 11 digits;
field admon_20porciento, type field integer maximum 11 digits;
field legal, type field integer maximum 11 digits;
field saldo_pendiente, type field integer maximum 11 digits;
field costos_viaje, type field integer maximum 11 digits;
field sumatoria, type field integer maximum 11 digits;
field porcentaje, type field integer maximum 11 digits;
field difrencia_viaje_largo_y_corto, type field varchar max length;
field observacion_anticipo, type field varchar max length.
table matrices
field id_matriz, type field integer maximum 11 digits, autoincremental primary key;
field id_orden_servicio, type field integer maximum 11 digits
field factura, type field varchar max length;
field id_clasificacion_factura, type field integer maximum 11 digits;
field fecha_elaborada, type field datetime;
field fecha_vencimiento, type field datetime;
field anticipo_cliente, type field integer maximum 11 digits;
field anticipo_conductor_gasto, type field integer maximum 11 digits;
field combustible, type field integer maximum 11 digits;
field observacion_matriz, type field varchar max length;
field fecha_factura, type field datetime;
field id_tipo_recaudo, type field integer maximum 11 digits;
field id_carteras, type field integer maximum 11 digits, autoincremental primary key;
field id_usuario_contable, type field integer maximum 11 digits.
create the follows foreign keys
in table ordenes_conductores create foreign keys to field id_cliente, which is related to the id_cliente from the table clientes in a many-to-one relationship,
in table ordenes_conductores create foreign keys to field id_vehiculo, which is related to the id_vehiculo from the table vehiculos in a many-to-many relationship,
in table ordenes_conductores create foreign keys to field id_conductor, which is related to the id_conductor from the table conductores in a many-to-many relationship,
in table ordenes_servicios create foreign keys to field id_orden_conductor, which is related to the id_orden_conductor from the table ordenes_conductores in a one-to-one relationship,
in table ordenes_servicios create foreign keys to field id_programa, which is related to the id_programa from the table programas in a many-to-one relationship,
in table anticipos create foreign keys to field id_orden_servicio, which is related to the id_orden_servicio from the table anticipos in a many-to-one relationship,
in table anticipos create foreign keys to field id_cliente, which is related to the id_cliente from the table clientes in a many-to-many relationship,
in table anticipos create foreign keys to field id_vehiculo, which is related to the id_vehiculo from the table vehiculos in a many-to-many relationship,
in table matrices create foreign keys to field id_orden_servicio, which is related to the id_orden_servicio from the table ordenes_servicios in a one-to-one relationship,
in table matrices create foreign keys to field id_clasificacion_factura, which is related to the id_clasificacion_factura from the table id_clasificaciones_facturas in a many-to-many relationship,
in table matrices create foreign keys to field id_tipo_recaudo, which is related to the id_clasificacion_factura from the table tipos_recaudos in a many-to-many relationship,
in table matrices create foreign keys to field id_carteras, which is related to the id_carteras from the table carteras in a many-to-many relationship,
in table matrices create foreign keys to field id_usuario_contable, which is related to the id_usuario_contable from the table usuarios_contables in a many-to-many relationship.