Visualize Sequelize data in data tables.
# Using npm
npm install --save bloggify-sequelize-datatable-views
# Using yarn
yarn add bloggify-sequelize-datatable-views
There are few ways to get help:
- Please post questions on Stack Overflow. You can open issues with questions, as long you add a link to your Stack Overflow question.
- For bug reports and feature requests, open issues. 🐛
Visualize Sequelize data in data tables.
When using this plugin, the Bloggify.partials.datatable_view
will be
available and will require the following parameters:
-
columns
(Array of Strings): The table headers. If you need special actions, you can pass HTML. -
name
(String): The model name (e.g.users
) -
type
(String): The table type (default
|compact
)
Example:
<div class="bg-light p-3 rounded mt-5 table-responsive">
<%
include(Bloggify.partials.datatable_view, {
columns: [
"ID",
"Email",
"First Name",
"Last Name",
"Roles",
"Actions",
],
name: "users",
type: "compact" // or "default"
})
%>
</div>
💡 Note: You have to initialize the datatables in your own JavaScript code.
Generates the action to draw the table.
Assets.tableDraw = Bloggify.services.utils.tableDraw([
"id",
"serial_number",
"user.email",
"file.id"
], {
base: Bloggify.models.Document,
include: [
Bloggify.models.File
, Bloggify.models.User
]
}, {
searchFields: [
"serial_number",
"$user.email$",
],
output: [
"id",
"serial_number",
"user.email",
// Return null elements if on the client
// side you want to have empty columns
// populated via JavaScript
null, null,
// This will resolve into an object with these fields
[ "edit_url", "delete_url" ]
],
beforeQuery (ctx, findQuery) {
// For example, restrict the results
// to a specific user id
findQuery.where.userId = ctx.user.id
}
})
The above will resolve to the following:
{
data: [
[
42, // id
143, // serial_number
"foo@bar.com", // email
null,
null,
{
edit_url: "...",
delete_url: "...
}
]
],
draw: <timestamp>,
recordsFiltered: <count>,
recordsTotal: <total>
}
-
Array
headers
: The column names the table has. -
Object
models
: An object containing:-
base
(Model): The base model. -
include
(Array of Models): The models to include (for join).
-
-
Object
options
: Additional querying options:-
searchFields
(Array): The column names you want to enable searching for. -
output
(Array): An array of column names,null
(for empty output) and array (for object output) elements.
-
Have an idea? Found a bug? See how to contribute.