TEST DB FOR laravel-lumen-crud-wizard-decorator (displays max 10 rows from every resource)
laravel 9
See also undecorated 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
parentID
clientID
operationCurrency
operationValue
updatedAt
createdAt
parentClientID
parentOperationCurrency
parentOperationValue
parentUpdatedAt
parentCreatedAt
childID
childClientID
childOperationCurrency
childOperationValue
childUpdatedAt
childCreatedAt
clientFullName
clientIsActive
clientUpdatedAt
clientCreatedAt
productID
productEAN
productTitle
productCode
productValue
productCurrency
productUpdatedAt
productCreatedAt
;
| Add filter type:
Select filter type
in
notIn
from
to
starts with
isNull
isNullOr
isNotNull
contains
notContains
| Add with sums:
Select summable column
operationValue
;
| Add with averages:
Select summable column
operationValue
;
| Add with minimums:
Select summable column
operationValue
createdAt
;
| Add with maximums:
Select summable column
operationValue
createdAt
;
| Add group bys:
Select group by column
ID
parentID
clientID
operationCurrency
operationValue
;
| Add group subtotals:
Select group summable column
operationValue
;
| Add group subaverages:
Select group averageable column
operationValue
;
| Add group subminimums:
Select group minable column
operationValue
createdAt
;
| Add group submaximums:
Select group maxable column
operationValue
createdAt
;
| Add group subcount distinct:
Select subcount distinct column
ID
parentID
clientID
operationCurrency
operationValue
createdAt
updatedAt
;
| Add group having subtotal:
Select subtotal column
operationValue
operationValue from
operationValue to
;
| Add group having subaverage:
Select subaverage column
operationValue
operationValue from
operationValue to
;
| Add group having subminimum:
Select subminimum column
operationValue
operationValue from
operationValue to
createdAt
createdAt from
createdAt to
;
| Add group having submaximum:
Select submaximum column
operationValue
operationValue from
operationValue to
createdAt
createdAt from
createdAt to
;
| Add group having subcount distinct:
Select subcount distinct column
ID
ID from
ID to
parentID
parentID from
parentID to
clientID
clientID from
clientID to
operationCurrency
operationCurrency from
operationCurrency to
operationValue
operationValue from
operationValue to
createdAt
createdAt from
createdAt to
updatedAt
updatedAt from
updatedAt 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 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 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
;
| Restrict response to columns:
Select template
Defaults without aggregations
;
| Add distincts:
Select distinct column
ID
parentID
clientID
operationCurrency
operationValue
createdAt
updatedAt
;
| Pagination:
Select paginator
With Count
Only Count
Simple
Cursor
| Sort:
Select sort
ID ASC
ID DESC
parentID ASC
parentID DESC
clientID ASC
clientID DESC
createdAt ASC
createdAt DESC
operationCurrency ASC
operationCurrency DESC
operationValue ASC
operationValue DESC
;
aggregate column ASC
aggregate column DESC
Resource: operations-products-pivot
relations:product,operation
Filter:
Resource: products
relations:operations,clients
*
productValue
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:
