TEST DB FOR laravel-lumen-crud-wizard (displays max 10 rows from every resource)
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
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:
