webxadmin PHP RAD TOOL for database administration

Based on Laravel's little brother, Lumen Framework, webxadmin is a xml based BREAD (browse, read, edit, add, delete) or CRUD ( Create-Read-Update-Delete) for MYSQL database table administration. I know this is quite unconventionnal for Laravel which relies mainly on a very mature and efficient data MODEL specification, allowing easy declaration and relationship management : the main objective of webxadmin is to keep the main data schema configuration in one single file that you can edit quickly, also allowing quicker declaration and relationship managament, and furthermore including a few UX/UI tricks like tabs structured forms, advanced fields, and so on....

With webxadmin, you setup a whole adminstration panel prototype in .. say 10 minutes. All you have to do is look at the storage_path('app') . '/database.xml' and declare your tables and fields based on database.dtd definition. All the work is performed by the single WaveController controller with a few views that still include raw PHP code to perform the BREAD / CRUD scaffolding :

• basic data table with filtering
• modal form generation with field types : input, wysiwyg (based on summer note), select (based on table relation ship)

Installation

• clone the repository
• configure database access in .env
• get dependencies with composer update
• create your tables in sql (with primary key autoincrement named "id")
• declare your tables in storage / database.xml
• browse your application url with table name to access webxadmin (no index page yet ..)

Basic Example

this example creates a basic time tracking application with three tables

• Notes
  • tab based form (2 tabs defined by d_tab )
  • aggregate sum function for counting hours
  • hierachic filtering for categories and customer related tables
• Category / Customer : hierarchic tree structure
• color coding for categories

  <d_table name="note">
        <d_tabs>
            <d_tab title="Infos"></d_tab>
            <d_tab title="Taxonomy"></d_tab>

        </d_tabs>
        <d_aggregate name="hours" function="sum"></d_aggregate>
        <d_field name="date_creation"  subtype="date" order="desc"  tab="Taxonomy"></d_field>
        <d_field name="date_modif" hide="both" subtype="date" ></d_field>
        <d_field name="title" tooltip="body"  tab="Infos"></d_field>
        <d_field name="body" type="textarea" hide="list"  tab="Infos"></d_field>
        <d_field name="category" type="select" relation="category"  tab="Taxonomy"></d_field>
        <d_field name="customer" type="select" relation="customer"  tab="Taxonomy" subtype="tree"></d_field>
        <d_field name="hours" type="number"   tab="Infos" ></d_field>
    </d_table>
       <d_table name="category">
        <d_field name="title"></d_field>
        <d_field name="body" type="textarea"></d_field>
        <d_field name="color" subtype="color"></d_field>
    </d_table>
    <d_table name="customer">
        <d_field name="parent_id" type="select" relation="customer"  ></d_field>

        <d_field name="title"></d_field>
        <d_field name="body" type="textarea"></d_field>
    </d_table>

TODO

• pagination
• export
• tree field : multi level filtering (currently only two levels)
• doc : add image in readme
• generic id primary key field
• translation of delete message

Screenshot

example of a time tracking application

Credit

• Bootstrap interface : tabler.io
• Date Range Filter: Date Range Picker
• Colorpicker
• Wysiwyg editor : SummerNote
• Hierarchical Tree filter : select2Tree , depends on select2

Alternatives

• Laravel Nova and BackPack Manager
• https://lean-admin.dev/
• https://filamentphp.com/
• Blue Print : https://github.com/laravel-shift/blueprint
• https://github.com/nafiesl/SimpleCrudGenerator

License

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