Evolutility-UI-React is a set of model-driven views to Browse, Edit, List, Cards, Charts, Stats, Overview, and Activity.
With it you can easily build CRUD applications by writing models rather than code. It uses Hasura GraphQL backend. No hand-coding is necessary!
Check out the live demos.
- Installation
- Configuration
- Views for One, Many records, and for Comfort
- Models
- Backend
- License
Download or clone from GitHub.
# To get the latest stable version, use git from the command line.
git clone https://github.com/evoluteur/evolutility-ui-reactor use the npm package:
# To get the latest stable version, use npm from the command line.
npm install evolutility-ui-reactIn the Evolutility-UI-React directory, use the command line to type the following:
# Install dependencies
npm install
# Run the node.js server
npm start
In a web browser, go to the url [http://localhost:3000/ the REST endpoints, you also need to install and run Evolutility-Server-Node which provides the matching REST endpoints based on the same metadata.
Configurations options are specified in the file /src/config.js. They apply to all apps (app specific options are specified in models).
| Option | Description | Example |
|---|---|---|
| apiPath | Path to GraphQL API. | "https://myapp.hasura.app/v1/graphql" |
| adminSecret | Token for Hasura. | |
| useCache | Enable/disable data caching. | true |
| cacheDuration | Cache duration in seconds. | 120 (for 2 minutes) |
| filesUrl | Path to upload files to. | "/pix/" |
| pageSize | Page size in pagination. | 50 |
| withActivity | Tracks and shows records activity (last visited and most visited). Currently implemented w/ the browser's localStorage, it will be moved to the server later. | true |
| queryModels | Get models from JSON files or from the database through the API. (not implemented yet) | |
| withTimestamp | Tracks and shows timestamp for creation date and last update for every record. The DB tables need timestamp columns "updated_at" and "created_at" for the feature to work. (partial implementation) | true |
For any object, a single model defines UI elements across views in a simple declarative way.
Evolutility-UI-React provides different types of view:
- Views for One - a single record: Browse, Edit.
- Views for Many - a collection of records: List, Cards, Charts, Stats.
Evolutility uses GraphQL with Hasura.
Notes: Views for actions (search, filter, export) will come later.
Shows all fields for viewing (read only). Fields are grouped in panels.
Code: /src/components/views/one/Browse/Browse.jsx
Route: "/{entity}/browse/{id}"
This view shows all fields for edition to create or update records. It automatically performs validation based on the model. Fields are grouped in panels and tabs.
Code: /src/components/views/one/Edit/Edit.jsx
Route: "/{entity}/edit/{id}"
Gives a tabular view of a collection.
Code: /src/components/views/many/List/List.jsx
Route: "/{entity}/list"
Shows records side by side as cards.
Code: /src/components/views/many/Cards/Cards.jsx
Route: "/{entity}/cards"
Draws charts about the collection. Currently bars and pie charts are implemented, a list with count and percentages is also available. Only provided for fields of types like boolean, lov, integer, decimal, date... (not text or textmultilines).
Code: /src/components/views/analytics/Charts/Charts.jsx
Route: "/{entity}/charts"
Note: The "Charts" view is currently only implemented for REST, not available with GraphQL yet.
Display last update, number of updates in the last week, and for numeric fields the min, max, count, average.
Code: /src/components/views/analytics/Stats/Stats.jsx
Route: "/{entity}/stats"
Display a summary of the object and the latest activity on it.
Display a summary of the object and the latest activity on it.
Code: /src/components/views/comfort/Overview/Overview.jsx
Route: "/{entity}/"
Show list of "last visited" and "most visited" records for the object (stored in the browser's localStorage).
Code: /src/components/views/comfort/Activity/Activity.jsx
Route: "/{entity}/activity"
Each model describe an object and its list of fields. A single model is used for all views (Browse, Edit, List, Cards...).
For any object, all UI views (List, Cards, Edit, Charts...) share the same model. All Fields are present in the Edit and Browse views. Fields can be flagged with "inMany" to be included in the List and Cards views, or "noCharts" and "noStats" to be excluded from the Charts or Stats views.
| Property | Meaning |
|---|---|
| id | Unique key to identify the entity (used in route and as API parameter). |
| qid | Entity ID used in GraphQL (may be different from id in route). |
| icon | Icon file name for the entity (example: "cube.gif"). |
| name | Object name (singular). |
| namePlural | Object name (plural). |
| title | Application name. |
| fields | Array of Fields. |
| groups | Array of Groups. If not provided a single group will be used. |
| collections | Array of Collections. |
| titleField | Id of the field which value is used as record title. titleField can also be a function. |
| titleFunction | Function to calculate the record title based it's data. Example: titleFunction = (data, model) => data.firstname + " " + data.lastname; |
| defaultViewOne | To have List and Cards link to Edit instead of Browse, set defaultViewOne="edit". |
Objects have fields.
| Property | Meaning |
|---|---|
| id | Unique key for the field (can be the same as column but doesn't have to be). |
| type | Field type to show in the UI. Possible field types:
|
| label | Field description (displayed with an asterisk for required fields). |
| labelShort | Optional shorter version of the labels (used in List and Cards views). |
| required | Determines if the field is required for saving. |
| readOnly | If set to true, the field value cannot be changed. |
| defaultValue | Default field value for new records. |
| format | Field format (using moment for date values and numeral for numeric values). |
| max, min | Maximum/Minimum value allowed (only applies to numeric fields). |
| maxLength, minLength | Maximum/Minimum length allowed (only applies to text fields). |
| regExp | Regular expression used to validate the field value. |
| list | List of items in the dropdown as an array of id-text objects (only for fields of "lov" type). If ommited, the list will be retrieved in the first query by id on that object. |
| lovIcon | Set to True to include icon with LOV items(only for fields of "lov" type). |
| object | Model id for the object to link to (only for fields of "lov" type). |
| chartObject | Optional overide for object name in charts (only for "lov" fields). |
| aggregate | Optional overide for aggregation name in charts (only for "lov" fields). |
| inMany | Determines if the field is present (by default) in lists of records. |
| inSearch | Determine if the field is used in text searches. |
| height | For fields of type "textmultiline", number of lines used in the field (in Browse and Edit views). |
| width | Field width in Browse and Edit views (in percent of parent width). |
| help | Optional help on the field. |
| chartType | Default charts type used for the field ("Bars", "Pie", or "Table"). "Bars" is used if not specified. |
| noCharts | Exclude field from charts (only applies to fields of type integer, decimal, money, boolean, list of values which are "chartable"). |
| noStats | Exclude field from Stats. |
Field Groups are used to separate Fields into panels in the Edit and Browse views.
| Property | Meaning |
|---|---|
| id | Unique key for the group. It is optional. |
| type | Type of fields group. Only "panel" is currently supported (tab and other types of groups will be added later). |
| label | Group title displayed in the group header. |
| fields | Array of field ids. |
| width | Width (in % of the container total width). |
| help | Optional help tooltip text. |
| header | Optional text displayed at the top of the group (just below the group title). |
| footer | Optional text displayed below the group. |
Notes:
- Field Groups are optional. By default a single group holds all fields.
- Field Groups are positioned based on their "width" property the same way than fields are positioned inside groups.
Multiple details tables can be specified with "collections".
| Property | Meaning |
|---|---|
| id | Unique key for the collection. |
| title | Collection title. |
| object | Model.id for the Object to link to. |
| fields | Array of fields (objects or ids). Fields in collections can be field objects or just ids of fields in the collection's object. |
| readOnly | Specify if the collection is readOnly. |
| hideIfEmpty | Hide Collection when it is empty in Edit view (always hidden when empty in Browse view). |
| help | Optional help tooltip text. |
| header | Text to be displayed before the collection. |
| footer | Text to be displayed below the collection. |
Sample model using collections: Wine Cellar.
The following example is the model for a simple graphic novels inventory app.
{
id: "comics",
title: "Graphic Novels",
name: "graphic novel serie",
namePlural: "graphic novel series",
icon: "comics.png",
titleField: "title",
fields:[
{
id: "title", type: "text",
label: "Title",
required: true, maxLength: 255,
width: 100, inMany: true,
},
{
id: "authors", type: "text",
label: "Authors",
inMany: true, width: 62,
},
{
id: "genre", type: "lov",
label: "Genre",
width: 38, inMany: true,
list: [
{id: 1, text: "Adventure"},
{id: 2, text: "Fairy tale"},
{id: 3, text: "Erotic"},
{id: 4, text: "Fantastic"},
{id: 5, text: "Heroic Fantasy"},
{id: 6, text: "Historic"},
{id: 7, text: "Humor"},
{id: 8, text: "One of a kind"},
{id: 9, text: "Youth"},
{id: 10, text: "Thriller"},
{id: 11, text: "Science-fiction"},
{id: 12, text: "Super Heros"},
{id: 13, text: "Western"}
]
},
{
id: "serie_nb", type: "integer",
label: "Albums", noCharts: true,
width: 15, inMany: false
},
{
id: "have_nb", type: "integer",
label: "Owned",
width: 15, inMany: false, noCharts: true
},
{
id: "have", type: "text",
label: "Have",
width: 15, inMany: false
},
{
id: "language", type: "lov",
label: "Language",
width: 17, inMany: true,
lovIcon: true,
list: [
{id: 2, text: 'French', icon:'comics/flags/fr.png'},
{id: 1, text: 'American', icon:'comics/flags/us.png'}
]
},
{
id: "complete", type: "boolean",
label: "Complete",
width: 19, inMany: false
},
{
id: "finished", type: "boolean",
label: "Finished",
width: 19, inMany: false
},
{
id: "pix", type: "image",
label: "Cover",
width: 30, inMany: true
},
{
id: "notes", type: "textmultiline",
label: "Notes",
width: 70, height: 7, maxLength: 5000,
inMany: false
}
],
groups: [
{
id:"serie", type: "panel", label: "Serie", width: 70,
fields: ["title", "authors", "genre",
"serie_nb", "have_nb", "have",
"language", "complete", "finished", "notes"
]
},
{
id:"pix", type: "panel", label: "Cover", width: 30,
fields: ["pix"]
}
]
}More sample models: To-do list, Address book, Restaurants list, Wine cellar.
You will need to setup the GraphQL backend on Hasura with the Evolutility demo database.
- You can signup for a free account or host it yourself (Quickstart Hasura CLI).
- Add a Postgres database to your Hasura setup.
- Add the demo tables by running the SQL script evol-db-schema.sql.
- Populate your database with sample data by running evol-db-data.sql
- Add relationships in Hasura console.Relationships on comics table:
- genre (Object): comics / genre_id -> comics_genre / id
- language (Object): comics / language_id -> comics_language / id
Relationships on comics_genre table:- comics (Array): comics_genre / id => comics / genre_id
Relationships on comics_language table:- comics (Array): comics_language / id => comics / language_id
Relationships on contact table:- category (Object): contact / category_id -> contact_category / id
Relationships on contact_category table:- contacts (Array): contact_category / id => contact / category_id
Relationships on music_album table:- artist (Object): music_album / artist_id -> music_artist / id
- tracks (Array): music_album / id -> music_track / album_id
Relationships on music_artist table:- albums (Array): music_artist / id -> music_album / artist_id
Relationships on music_genre table:- tracks (Array): music_genre / id -> music_track / genre_id
Relationships on music_track table:- album (Object): music_track / album_id -> music_album / id
- genre (Object): music_track / genre_id -> music_genre / id
Relationships on restaurant table:- cuisine (Object): restaurant / cuisine_id -> restaurant_cuisine / id
- price (Object): restaurant / price_id -> restaurant_price / id
Relationships on restaurant_cuisine table:- restaurants (Array): restaurant_cuisine / id => restaurants / cuisine_id
Relationships on restaurant_price table:- restaurants (Array): restaurant_price / id => restaurants / price_id
Relationships on task table:- category (Object): task / category_id -> task_category / id
- priority (Object): task / priority_id -> task_priority / id
Relationships on task_category table:- tasks (Array): task_category / id => task / category_id
Relationships on task_priority table:- tasks (Array): task_priority / id => task / priority_id
Relationships on wine table:- wine_tastings (Array): wine / id -> wine_tasting / wine_id
- bsize (Object): wine / bsize_id -> wine_bsize / id
- country (Object): wine / country_id -> wine_country / id
- grape (Object): wine / grape_id -> wine_grape / id
- score (Object): wine / score_id -> wine_score / id
- type (Object): wine / type_id -> wine_type / id
Relationships on wine_bsize table:- wines (Array): wine_bsize / id => wine / bsize_id
Relationships on wine_country table:- wines (Array): wine_country / id => wine / country_id
Relationships on wine_grape table:- wines (Array): wine_grape / id => wine / grape_id
Relationships on wine_score table:- wines (Array): wine_score / id => wine / score_id
Relationships on wine_tasting table:- wine (Object): wine_tasting / wine_id -> wine / id
Relationships on wine_type table:- wines (Array): wine_type / id => wine / type_id
- In Evolutility, change the "apiPath" and "adminSecret" in the ./src/config.js file.
Copyright (c) 2023 Olivier Giulieri.
Evolutility-UI-React is released under the AGPL-3.0 license.
To suggest a feature or report a bug: https://github.com/evoluteur/evolutility-ui-react/issues
![dependabot[bot] avatar](https://avatars.githubusercontent.com/in/29110?v=4 "dependabot[bot]")
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent