laravel-lumen-crud-wizard
*this demo interface displays max 10 rows from every resource and is not part of the lib
Download Postman Collection
laravel 10
See also decorated version
List clients
List operations with query builder
List operations-products-pivot
List products
List relation as resource
Resource: clients
relations:operations,products
Filter:
Resource: operations
relations:parent,children,client,products,productsValueScopeIssue51825
Filter:
| Add column filter:
Select column
id
parent_id
client_id
currency
value
created_at
updated_at
;
| Add filter type:
Select filter type
in
notIn
from
to
starts with
isNull
isNullOr
isNotNull
contains
notContains
| Add with sums:
Select summable column
value
;
| Add with averages:
Select summable column
value
;
| Add with minimums:
Select summable column
value
created_at
;
| Add with maximums:
Select summable column
value
created_at
;
| Add group bys:
Select group by column
id
parent_id
client_id
currency
value
;
| Add group subtotals:
Select group summable column
value
;
| Add group subaverages:
Select group averageable column
value
;
| Add group subminimums:
Select group minable column
value
created_at
;
| Add group submaximums:
Select group maxable column
value
created_at
;
| Add group subcount distinct:
Select subcount distinct column
id
parent_id
client_id
currency
value
created_at
updated_at
;
| Add group having subtotal:
Select subtotal column
value
value from
value to
;
| Add group having subaverage:
Select subaverage column
value
value from
value to
;
| Add group having subminimum:
Select subminimum column
value
value from
value to
created_at
created_at from
created_at to
;
| Add group having submaximum:
Select submaximum column
value
value from
value to
created_at
created_at from
created_at to
;
| Add group having subcount distinct:
Select subcount distinct column
id
id from
id to
parent_id
parent_id from
parent_id to
client_id
client_id from
client_id to
currency
currency from
currency to
value
value from
value to
created_at
created_at from
created_at to
updated_at
updated_at from
updated_at to
;
| Add group having count relations:
Select count relations
parent
parent from
parent to
children
children from
children to
client
client from
client to
products
products from
products to
productsValueScopeIssue51825
productsValueScopeIssue51825 from
productsValueScopeIssue51825 to
;
| Add group having exist relations:
Select exist relations
parent
parent from
parent to
children
children from
children to
client
client from
client to
products
products from
products to
productsValueScopeIssue51825
productsValueScopeIssue51825 from
productsValueScopeIssue51825 to
;
| Add group having group_count:
Select group count
group_count
group_count from
group_count to
| Add relation filter:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add relation column filter:
Select relation column
| Add relation column filter type:
Select relation column filter type
in
notIn
from
to
starts with
isNull
isNullOr
isNotNull
contains
notContains
| Add with relation count:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add with relation exist:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add with relation sums on columns:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add with relation avgs on columns:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add with relation mins on columns:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add with relation maxs on columns:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add doesn't have relations filter:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add without relations:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add with relations:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add with distinct columns from relation:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add with distinct columns:
Select relation column
| Add has relations number:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add has relations number from:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add has relations number to:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add has distinct relations number:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add has distinct relations number from:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add has distinct relations number to:
Select relation
parent
children
client
products
productsValueScopeIssue51825
;
| Add distincts:
Select distinct column
id
parent_id
client_id
currency
value
created_at
updated_at
;
| Pagination:
Select paginator
With Count
Only Count
Streamed Json NOK - see fix https://laravel-crud-wizard.com/laravel-9/laravel-lumen-crud-wizard
Simple
Cursor
| Sort:
Select sort
id ASC
id DESC
parent_id ASC
parent_id DESC
client_id ASC
client_id DESC
created_at ASC
created_at DESC
currency ASC
currency DESC
value ASC
value DESC
;
aggregate column ASC
aggregate column DESC
Resource: operations-products-pivot
relations:product,operation
Filter:
Resource: products
relations:operations,clients
*
value
column can be incremented via api call by using ++x.xx or --x.xx
Filter:
List relation as resource
Filter:
/operations/2/children?currency[in][]=EUR
php code for operations:
