maikealame/laravel-auto

Laravel helper to make almost everything for your project
4,657 41
laravel php pagination sort mysql postgresql automatic list where
Install
composer require maikealame/laravel-auto
Latest Version:1.1.3
PHP:>=5.5.9
License:MIT
Last Updated:Jan 13, 2023
Links: GitHub  ·  Packagist
Maintainer: maikealame

Laravel helper package to make automated lists with filters, sorting and paging like no other.

Wiki: https://maikealame.github.io/laravel-auto/

Latest Version Software License Total Downloads

You are free to create your own layout and style, there's no layout html/css included !

This package only grants a very automated query in Eloquent with Blade directives.

You can use it either without Blade directives, like Vue.js and React, but you need to implement manually the calls to backend and layout rendering.

table image

table image

$categories = Topic::from("topics as t")
            ->select("t.*")
            ->leftJoin("portals as p", "p.id","=","t.portal_id")
            ->autoWhere()->autoSort()->autoPaginate();

table image

table image

if (Request::has("filter")) {
    if (isset(Request::get("filter")['keyword'])) {
        $keyword = Request::get("filter")['keyword'];
        Auto::setField("notifications.title", $keyword);
        Auto::setField("notifications.description", $keyword);
    }
}
$notifications = Notification::select("notifications.*", "notification_users.readed_at")
            ->groupBy("notifications.id")
            ->leftJoin("notifications_users", "notifications.id", "=", "notifications_users.notification_id")
            ->leftJoin("notifications_roles", "notifications.id", "=", "notifications_roles.notification_id")
            ->leftJoin("notifications_departments", "notifications.id", "=", "notifications_departments.notification_id")
            ->autoWhere(['or' => ["notifications.title", "notifications.description"]])
            ->autoSort(["notifications.updated_at", "desc"])->autoPaginate();

table image

$enterprises = Enterprises::from("enterprises as e"))
            ->select("e.*")
            ->leftJoin("enterprise_indicators_enterprises as iei","eie.enterprise_id","=","e.id")
            ->groupBy("e.id")
            ->autoWhere()->autoSort()->autoPaginate();

table image

See https://maikealame.github.io/laravel-auto/

  1. View
  2. Controller
  3. Model

Related Packages

tommyknocker/pdo-database-class

Framework-agnostic PHP database library with unified API for MySQL, MariaDB, Pos...

6,323 82
activerecord ai-analysis ai-database-assistant ai-powered anthropic batch-processing bulk-operations cli-tools common-table-expressions connection-pooling connection-retry cross-apply cross-platform csv-loader cte cursor-pagination database database-abstraction-layer database-optimization-ai dbal ddl deepseek delete-join dialect-specific-types distinct-on dump error-diagnostics event-dispatcher except exception-hierarchy explain-analysis export-helpers filter-clause fluent-api framework-agnostic full-text-search google-ai helper-functions insert-select intersect json-loader lateral-join lightweight load-balancing mariadb merge-statements microsoft-ai migrations mssql mysql ollama openai oracle orm outer-apply pagination pdo pdo-db pdo-oci pdodb performance php8 plugin-system postgresql prepared-statements psr-14 psr-16 query-builder query-caching query-compilation-cache query-debugging query-macros query-monitoring query-optimization-ai query-profiling query-scopes read-write-splitting recursive-cte regexp relationships restore savepoints schema-builder schema-inspector schema-introspection security seeds set-operations sharding sql-builder sql-formatter sql-injection sql-server sqlite table-locking transactions type-safe union update-join upsert user-management validation window-functions xml-loader yandex-ai yii2-inspired zero-dependencies
popphp/pop-db

Pop Db Component for Pop PHP Framework

19,806 19
database database migrations mysql pdo php pop pop php postgresql schema builder sql builder sqlite sqlsrv
vcian/laravel-db-auditor

Database DB Auditor provide leverage to audit your MySql,sqlite, PostgreSQL data...

41,770 287
database db audit db constraints db standards laravel mysql pgsql php postgresql sqlite
watheqalshowaiter/model-fields

Get model fields fast — required, nullable, or default

2,679 39
laravel mariadb model model-fields mysql package php php-package postgresql sql sqlite sqlserver watheq alshowaiter watheqalshowaiter yemen_open_source yemenopensource
mevdschee/php-crud-api

Single file PHP script that adds a REST API to a SQL database.

69,042 3,736
api-server automatic-api crud database geospatial multi-database mysql openapi php php-api postgis postgresql rest-api restful sql-database sql-server swagger ubuntu-linux