Skip to content
joelios edited this page Aug 15, 2019 · 3 revisions

libraDash

About

libraDash is an ERPNext app, provided by libracore for creating an admin dashboard based on SQL querys and morris.js diagrams.

How to install

You need a working ERPNext V11 installation.

$ bench get-app https://github.com/joelios/libradash

$ bench install-app libradash

Now you can call the default dashboard on .../libradash

Settings

After the successfull installation the default layout is activated. You can change to a custom layout on libradash > libradash settings.

To set your own dashboard layout with your own SQL querys, select Layout > Custom.

Create for every single graphical representation of your dashboard a row in the subtable. Choose the type and the column width.

Create Panels

  1. Add a new row
  2. Add panel color (in words, e.g.: yellow)
  3. Add a fontawesom icon (e.g.: fa fa-shopping-cart)
  4. Add an info text (e.g.: New SO(s) in current year)
  5. Add a link text (e.g.: View Sales Order Details)
  6. Add link (e.g.: /desk#List/Sales Order/List)
  7. Add a SQL query (e.g.: SELECT COUNT(name) FROM tabSales Order WHERE docstatus = 1 AND YEAR(transaction_date) = YEAR(CURDATE()))

Panel

Create Line Charts

tbd

Create Pie Charts

tbd

Create Bar Charts

tbd

Layout preview

tbd

Preview

tbd

Default

tbd