gigatables-react

v2.9.8

Published

2 years ago

GigaTables is a ReactJS plug-in to help web-developers process table-data in applications and CMS, CRM, ERP or similar systems. It supports ajax data processing/editing (CRUD), pagination, cross-sorting, global search, shft/ctrl rows selection, 7 popular

Downloads

192

0High
0Medium
0Low

zeusakm

reactjs tables greed react javascript row-edit table-view fixed-header sortable pagination search

GigaTables ReactJS plug-in

GigaTables supports the following capabilities:

-- ajax data processing/editing (CRUD),

-- classic pagination or infinite scroll,

-- column sorting,

-- live cell edit,

-- common search (through all columns),

-- discrete (per column) search,

-- ajax files upload,

-- shft/ctrl rows selection,

-- fixed header,

-- trigger functions,

-- dynamic column content functions,

-- 10 popular languages,

-- data load for period interval,

-- hot keys,

-- plugins

-- material-ui theme

and more...

Installation

npm i gigatables-react

After installation has been completed, add import to your main.js like this:

import { Reactables, Header } from 'gigatables-react'

see how to create table with JSX below.

Demo

More screen-shots

Installation based on browser script implementation (which U can download from build/ dir)

    <script src="build/index.js"></script>
    // or
    <script src="wherever/whatever.js"></script>

Getting Started

To initialize plug-in and to bind GigaTables with table structure - set settings prop with options and table structure in JSX format. The <Reactables> tag, it's Headers and all the stuff like pagination, per page selector will be constructed on the fly.

Minimal configuration

Add js below to main.js file:

import React from 'react'
import ReactDOM from 'react-dom'
import {Reactables, Header} from 'gigatables-react'

let settings = {
    struct: {// all in
        search: ['top', 'bottom'],
        rowsSelector: ['asc', 'top', 'bottom'],
        pagination: ['bottom']
    },
    ajax: 'http://example.com/your/tabledata',
    // or u can set local json data
    // data: localData, 
    columns: [
        {data: "id"},
        {data: "desc"},
        {data: "title"},
        {data: "date"},       
        {data: "info"},
        {data:"field1"},
        {data:"field2"},
        {data:"field3", visible: false}        
    ]
};

ReactDOM.render(
    <Reactables settings={settings}>
        <Header data="id">ID</Header>
        <Header data="title">Name</Header>
        <Header data="desc">Description</Header>
        <Header data="date">Date</Header>
        <Header data="info">Info</Header>
        <Header data="field2">Field123 but data from field2</Header>
        <Header data="field1">Field1</Header>
        <Header data="field3">Field3 invisible</Header>
        <Header>Field3 invisible</Header>
    </Reactables>,
    document.getElementById('app'));

If u run GT from scratch - don't forget to install dependencies, such as:

  "dependencies": {
    "react": "^16.3.1",
    "react-dom": "^16.3.1",  
    "classnames": "^2.2.5",
    "css-loader": "^0.26.1",
    "expect": "^1.20.2",
    "file-loader": "^0.10.0",
    "hoek": "^5.0.3",
    "lodash": "4.17.4",
    "prop-types": "^15.6.0",
    "react": "^16.1.1",
    "react-dom": "^16.1.1",      
    "resolve-url": "^0.2.1",
    "style-loader": "^0.13.1",
    "superagent": "^3.5.2",
    "url-loader": "^0.5.7",
    // for plugins
    "react-minimal-pie-chart": "^3.0.2",
    "react-rte": "^0.15.0",
    "react-trend": "^1.2.4",
    // dev deps  
    "babel": "^6.23.0",
    "babel-cli": "^6.26.0",
    "babel-loader": "^7.1.4",
    "babel-preset-react": "^6.24.1",
    "webpack": "^4.5.0",
    "webpack-cli": "^2.0.14",
    "webpack-dev-server": "^3.1.3"       
  },

Also add index.html file to the root and put the following content in it:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Title</title>
</head>
<body>
    <div id = "app"></div>
    <script src = "index.js"></script>
</body>
</html>

Be sure to create a webpack.config.js file and copy content from the same file in this repo. Get to the project directory and run npm start. That's it, you are up and running.

Advanced configuration with opts and editor

let settings = {
 struct: {
   search: ['top', 'bottom'],
   rowsSelector: ['asc', 'top', 'bottom'],
   pagination: ['bottom'],
   fixedHeader: true, // default false
   editableCells: true, // default false
 },
 lang: 'en', // english default
 perPageRows: [25, 50, 100, 200, 500],
 defaultPerPage: 50,
 ajax: 'https://example.com/your/tabledata',
 requestType: 'GET',
 columns: [
   {// include all defaults
     data: "id",
     sortable: true, // true by defualt
     visible: true, // true by defualt
     searchable: true, // true by defualt
     discreteSearch: true, // false by default
     discreteSearchValue: function (title) {
       return 'Search in field ' + title;
     }
   },
   {
     data: "title",
     cISearch: true // default false
   },
   {
     data: "desc",
     sortable: false,
     discreteSearch: true,
     discreteCISearch: true // default false
   },
   {
     data: "date",
     searchable: false
   },
   {
     data: "info"
   },
   {data:"field1"},
   {data:"field2"},
   {data:"field3", visible: false}
 ],
 columnOpts: [
   {
     render: function (data, row, type) {
       return '<div><form method="post" class="accForm" action=""><input type="hidden" name="action" value="forms" /><input type="hidden" name="id" value="' + row.id + '" /><div>' + data + '</div></form></div>';
     },
     target: 2
   },
   {
     render: function (data, row, type) {
       return '<div><form method="post" class="accForm" action=""><input type="hidden" name="action" value="forms" /><input type="hidden" name="id" value="' + row.id + '" /><div>' + data + '</div></form></div>';
     },
     target: 3
   }
 ],
 tableOpts: {
   buttons: [
     {extended: "editor_create", editor: editor, triggerAfter: (function () {
         console.log('after create');
       }), triggerBefore: (function () {
         console.log('before create');
       })},
     {extended: "editor_edit", editor: editor},
     {extended: "editor_remove", editor: editor, triggerAfter: (function () {
         console.log('after del');
       })}
   ],
   buttonsPosition: ['top', 'bottom'],
   theme: 'std'
 }
};

The table is defined like in example below:

ReactDOM.render(
  <Reactables editor={editor} settings={settings}>
    <Header data="id">ID</Header>
    <Header data="title">Name</Header>
    <Header data="desc">Description</Header>
    <Header data="date">Date</Header>
    <Header data="info">Info</Header>
    <Header data="field2">Field123 but data from field2</Header>
    <Header data="field1">Field1</Header>
    <Header data="field3">Field3 invisible</Header>
    <Header>Field3 invisible</Header>
  </Reactables>,
  document.getElementById('app'))

data attribute is needed to glue columns to json data steadily.

JSON structure to return from provided url in "ajax" GigaTables option:

{
    "rows": [
        {
            "GT_RowId": 2, // optional
            "id": 2, // if there is no GT_RowId - try to fetch "id"
            "title": "Test 2st row",
            "desc": "<input type=\"text\" name=\"ttl\" value=\"Test 2nd row Test 2nd row Test 2nd row
 Test 2st row Test 2st row\" \/> ",
            "date": "20:40:37 17:06:2015",
            "info": "some info some info some info some info"
        },
        {
            "GT_RowId": 1,
            "id": 1,
            "title": "Test 1st row",
            "desc": "<input type=\"text\" name=\"ttl\" value=\"Test 1st row Test 1st row Test 1st row
 Test 1st row Test 1st row\" \/> ",
            "date": "20:40:38 17:06:2015",
            "info": "some info some info some info some info"
        }, ...

An example of using GigaTables with Editor tool

First of all You should define an object Editor like this:

let editor = {
    ajax: 'http://example.com/editor.php',
    // it is possible to set discrete urls, http methods for any type of request
    // ajax: {
    //     create: {
    //         url: 'http://gigatables.loc/editor.php',
    //         type: 'POST',
    //         headers: {
    //             'X-Api-Key': '8013b37216a07f50027139d89ee9f822e3784049'
    //         }
    //     },
    //     edit: {
    //         url: 'http://gigatables.loc/editor.php',
    //         type: 'PUT',
    //         headers: {
    //             'X-Api-Key': '8013b37216a07f50027139d89ee9f822e3784049',
    //             'X-Header-Key': 'foo-bar'
    //         }
    //     },
    //     delete: {
    //         url: 'http://gigatables.loc/editor.php',
    //         type: 'DELETE',
    //         headers: {
    //             'X-Api-Key': '8013b37216a07f50027139d89ee9f822e3784049',
    //             'X-Header-Key': 'foo-bar-baz'
    //         }
    //     }
    // },
    ajaxFiles: 'http://example.com/uploadFiles.php',
    struct: {
        buttons: ['top', 'bottom'] // buttons
    },
    fields: [
        {
            label: 'ID',
            name: 'id',
            type: 'hidden'
        },
        {
            label: 'Progress',
            name: 'field1',
            type: 'range',
            attrs: {
                min: 0,
                max: 100,
                defaultValue: 55
            }
        },
        {
            label: 'Article title:',
            name: 'title',
            type: 'text', // default, other: password, file, select, multiselect etc
            fieldsetOpen: true,
            legend: 'Required fields',
            attrs: {
                pattern: '^[A-Za-z0-9_]+$',
                className: 'titleField'
            }
        },
        {
            label: 'Description:',
            name: 'desc',
            type: 'textarea',
            plugins: 'rte',
            attrs: {
                className: 'descriptionField'
            },
            fieldsetClose: true
        },
        {
            label: 'Date Time:',
            name: 'date',
            type: 'date'
        },
        {
            label: 'Image:',
            name: 'image',
            type: 'file'
        },
        {// an example of using select - automatically selected if matches with data in table column
            label: 'Types:',
            name: 'types[]',
            values: [// if select,checkbox,radio etc types - need this pre-set structure of values
                {'key1': 'val1'},
                {'key2': 'val2'}
            ],
            type: 'select' // select,checkbox,radio
        }
    ]
}

and then pass variable (in this case - editor) to GigaTables main options in tableOpts section like this:

          tableOpts: {
            buttons: [
              {extended: "editor_create", editor: editor},
              {extended: "editor_edit", editor: editor},
              {extended: "editor_remove", editor: editor}
            ],
            buttonsPosition: ['top', 'bottom'],
            theme: 'std'
          }

That's it then You will be able to CRUD any record You want.

Pagination or Infinite scroll

It is sometimes convenient to use an infinite scroll rather then classic pagination, ex.: sort and see only part of data, watching an updated list etc. To initialize an infinite scroll - set infiniteScroll: true property in struct object.

struct: {
  search: ['top', 'bottom'],
  rowsSelector: ['desc', 'top', 'bottom'],
  pagination: ['bottom'],
  infiniteScroll: true
},

even if You leave pagination option there - infinite scroll will take precedence.

Ajax or local data

While it is clear that GT was primarily developed with data processing via ajax, u can use either ajax or local data. To let GT accept local data the only thing u need to do is to set settings.data property to any json object that will be satisfy defined structure.

It can be variable, object itself or json from local file (loaded by require on nodejs for example).

The difference between data and ajax processing is that:

local data is always prioritized over ajax data, so if they both set - only the local data will be loaded
with local data u can't mutate rows/cols with editor create/edit/delete options

Ajax autoload period

If You need an autoload period set for online live-loaded grid data, just add 2 properties to settings object:

ajaxAutoloadData: true, // default false
ajaxAutoloadPeriod: 8, // sec

the ajaxAutoloadPeriod must be set in seconds and the interval should be placed between 5 and 300 seconds, if U wish to switch the mode to classic loader without touching settings structure - set the ajaxAutoloadData: false.

Hot keys

To efficiently manage table behavior You can use the following hot keys:

Ctrl+Arrow Up - selects rows above the selected
Ctrl+Arrow Down - selects rows below the selected
Ctrl+A - selects all rows in a current table view
Ctrl+Arrow Right - next page
Ctrl+Arrow Left - prev page

PS In some OS like Macintosh can be default conflicting hot keys, ex.: Cmd+Arrow Left get back in browsers

Plugins

Plugins can be helpful to build convenient features around form elements and table rows/columns. For instance - to edit text with HTML tags (aka WYSIWYG) and then save it in DB you can set the rte (Rich Text Editor): Reach Text Editor plugin

{
    ...
    type: 'textarea',
    plugins: 'rte',
    ...
}

Progress bar plugin (table):

Progress bar plugin

{
    data: 'field1',
    plugins: 'progressbar',
    pluginProps: {
        height: 20
    }
}

this will build 5 colored (left-to-right) progress bar for every row in the column, with percent number. Protected from null and negative numbers as well as more then 100.

PieChart plugin (table):

Pie chart plugin

{
    data: 'consumers',
    plugins: 'pie',
    pluginProps: {
        ratio: 2,
        startAngle: 3,
        rounded: true,
        animate: true,
        radius: 33,
    }
}

Trend plugin (table):

Pie chart plugin

{
    data: 'consumers_trend',
    plugins: 'trend',
    pluginProps: {
        autoDraw: true,
        autoDrawDuration: 2000,
        autoDrawEasing: 'ease-in',
        strokeWidth: 15,
        padding: 18
    }
}

and the data, as in progress bar plugin, comes in via children prop intuitively, thus the only thing you need is to pass them through json:

{
    "rows": [
        {
            ...
            "statistics": 89, // for progress bar
            ...
            "consumers": [ // for pie chart
                {
                    "value": 32,
                    "color": "#E38627"
                },
                {
                    "value": 19,
                    "color": "#C13C37"
                },
                {
                    "value": 68,
                    "color": "#6A2135"
                }
            ],
            ... 
            "consumers_trend": [0, 10, 5, 22, 3.6, 11]           
        }
    ]
}

React select plug-in (editor):

React select plugin

Pretty popular plug-in for ReactJS with simple settings

{
    label: 'Cities:',
    name: 'cities',
    type: 'select',
    plugins: 'react-select',
    pluginProps: {
        options: [
            {value: 'msc', label: 'Moscow'},
            {value: 'nyc', label: 'New York'},
            {value: 'london', label: 'London'}
        ],
    }
}

Plugins integration in GT is flexible in terms of versatility with which providers/vendors may supply props, e.g. some plugin have prop structure like:

strokeWidth: 123,
strokeOpacity: 0.75,
strokeLinejoin: true

then developers team may change it to e.g:

stroke: {
    width: 123,
    opacity: 0.75,
    linejoin: true
}

you can just place a new structure to pluginProps, update the plugin and proceed using new features.

Themes

GT supports the most popular ReactJS theme - material-ui, thus you can easelly switch between standard and material-ui themes by setting:

tableOpts: {
    ...
    theme: 'material-ui' // 'std' is the default theme
    ...    
}

there are buttons, inputs, selects, redio, checkboxes, textareas and other form/table elements for material-ui theme.

As an option you can always set additional attributes to any component as with std form elements e.g.:

attrs: {
    className: 'titleField',
    placeholder: 'Place holder'
}

Headers

In some work-flows u may need to send several useful headers, ex. with secret key for api, additional info for back-end to recognize anything etc In GT u can place those either in settings or editor this way: in settings:

    headers: {
        'X-Api-Key': '8013b37216a07f50027139d89ee9f822e3784049',
        'X-Header-Key': 'foo-bar'
    },

in editor:

... 
     edit: {
         url: 'http://example.com/editor.php',
         type: 'PUT',
         headers: {
             'X-Api-Key': '8013b37216a07f50027139d89ee9f822e3784049',
             'X-Header-Key': 'foo-bar'
         }
     },
...

Aggregate Footer

To set an aggregate footer, to be able to collect statistical data with different functions/methods use the following property in struct object:

    struct: {
        ...
        aggregateFooter: true
        ...
    }

then you can declare whatever function needed to be processed for particular columns like this:

    {
        data: "title",
        ...
        footer: 'frequency',
        ...
    },

to get most frequently used sentences/words,

    {
        data: "price",
        ...
        footer: "avg",
        ...
    },

to count an average value of all numbers in column,

    {
        data: "amount",
        ...
        footer: "sum",
        ...
    },

there are also minLength - maxLength footer settings to get a string lengths.

Data export

Sometimes users need to export data in different formats, the most popular is csv, so here we go:

define download object with csv property in settings->struct

    download: {
        csv: true,
    },

define button object in settings->tableOpts->buttons like this:

    {
        extended: "editor_csv",
        editor: editor,
    },

You'll see an extra button CSV Export on the left, right before standard buttons for CRUD.

Table options

Editor options

FAQ

Can I use file types in GT editor to upload files through AJAX on server?

Sure, it can be done by this additional option in editor:

ajaxFiles: 'https://example.com/upload/files',

which is pointing on script on the server where it should upload the file(s).

And to add the actual field which will send the file to the server script:

    {
      label: "Image:",
      name: "image",
      type: 'file'
    }

Ensure that the field is in fields: [ option. U can even specify:

attrs: [
  {'multiple': ''}
]

to upload as many files as U need.

What types of fields can be used in editor?

You can use any HTML5 types, but responsibility for cross-browser support is on Your side.

Can I choose more then one row?

It is possible to even select not only the bunch of rows, but several bunches and some between them, by manipulating with: Ctrl+Left click (one row anywhere) and Shift+Left click (several rows). Also U can use hot-keys to select above/below Ctrl+Arrow Up/Ctrl+Arrow Down and Ctrl+A will select them all for current table-view.

Is it possible to search for a particular column in GT?

Specify any column U wanted to search by setting these options in columns parts eg.:

          columns: [
            {// include all defaults
              data: "id",
              discreteSearch: true,
              discreteSearchValue: function(title) {
                return 'Search on the field - ' + title;
              }              
            }

Is there languages support?

You can pick one of 10 languages: English, German, Russian, French, Spanish, Chinese, Hindi, Portuguese, Arabic and Japanese - en, gr, ru, fr, es, ch, hi, ar, pt and ja respectively.

Does GT have any event-triggered functions, ex.: to run something before/after pop-up?

GigaTables plug-in has 2 types of triggers triggerBefore and triggerAfter which can be applied to any action button - Create, Edit or Delete.

Can I set case insensitive search to either common and/or discrete search?

Yes. For common search You should choose for which particular column it is needed and place cISearch: true option there, for discrete search use discreteCISearch: true.

Does GT have an ability to fix header while scrolling?

Just add:

  fixedHeader: true

to struct section of settings variable as in example above.

Is there a way to edit cells in real-time?

editableCells option will transform table to per-cell edit bases:

editableCells: true

Thus, You can click on any cell - edit the content and press Enter to send the AJAX request to the specified url.

Is it possible to edit multiple rows?

Sure, but you should understand the fact, that if you edit a field - it will be changed for all selected rows, those fields that were left unchanged will be sent in their current state.

How can I set css styling to form fields?

Simply by specifying:

attrs: [
  {'className': 'myClass1 myClass2'}
]

in the field settings, don't forget to import the styles file with global cascades like this:

import './main.css'

you can see an example in main.js file.

For those who like fieldset legend form structure GT offers:

    {
        ...
        fieldsetOpen: true,
        legend: 'Required fields',
        ...
    }

to open fieldset tag and set legend, to close previous fieldset in any further object use syntax like this:

    {
        ...
        fieldsetClose: true,
        ...
    },

I need to set the default value for a field, how can I achieve that? Sure, just add the defaultValue property to the particular fields object. It works for all types of fields input, select, html5 inputs etc.

How would GT behave if there will be > 1 000 000 rows data?

GT will perform good, but you should consider to turn off all the extra settings, for instance with aggregate footer set - the data will be counted through those 1M rows. Sure it will aggregate values only once and then get the results from state, but the 1st page load will be longer than usual.

Contribution gratitude

@tanz-sullamora (without this guy project would not be completed at all)

@AndreiEnache (solved problem with Exceptions)

@GreenbBro (helped with robust functionality and ES6 code-style)

@wangfrombupt (found critical bugs + translation issues)

Used by

Demo

Published

Vulnerabilities

Links

Maintainers

Keywords

Readme

GigaTables ReactJS plug-in

Installation

Demo

Installation based on browser script implementation (which U can download from build/ dir)

Getting Started

Minimal configuration

Advanced configuration with opts and editor

An example of using GigaTables with Editor tool

Pagination or Infinite scroll

Ajax or local data

Ajax autoload period

Hot keys

Plugins

Themes

Headers

Aggregate Footer

Data export

Table options

Editor options

FAQ

Contribution gratitude

Used by