DigRealtime DigRealtime DigRealtime DigRealtime
  • Start
  • Product
    • Product Information
    • Custom Widgets
    • Pricing
  • Support
    • Documentation
      • Setup Guide
      • Dashboard Studio Introduction
      • Data Extraction Guide
    • Forums
    • Services
  • Download
  • Customer
    • Log In
    • Register
  • Blog
  • Contact Us
DigRealtime DigRealtime
  • Start
  • Product
    • Product Information
    • Custom Widgets
    • Pricing
  • Support
    • Documentation
      • Setup Guide
      • Dashboard Studio Introduction
      • Data Extraction Guide
    • Forums
    • Services
  • Download
  • Customer
    • Log In
    • Register
  • Blog
  • Contact Us
Jun 20

Simple 3-Column Table with Select

  • 2016-06-20
  • admin
  • No Comments
  • Uncategorized

dr-table-3-col-select

A simple three column table template to put in your business dashboards. It has SelectableItem activated and could be used to link to other widgets.

If you want a DATE/Time column to be a SelectableItem, use another template, or use:

XHTML
1
selectvalue="{moment($T.row[$P.selectColumn]).toDate().floor('day').toString('yyyy-MM-dd HH:mm:ss')},{new Date(moment($T.row[$P.selectColumn]).toDate().setSeconds(1)).ceil('day').toString('yyyy-MM-dd HH:mm:ss')}"

Template:

XHTML
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
<!--DO NOT USE FOR DATE SELECTION. User other Template for that-->
<!--SETTINGS-->
{#param name=selectColumn value="Order Nr"}
{#param name=dr_table_3_col_idColumn value="Order Nr"}
{#param name=dr_table_3_col_property1 value="Namn"}
{#param name=dr_table_3_col_property2 value="Totalsumma"}
 
{#param name=dr_table_3_col_header1 value="Header1"}
{#param name=dr_table_3_col_header2 value="Header2"}
{#param name=dr_table_3_col_header3 value="Header3"}
 
{#param name=dr_table_3_col_header_bgcolor value="#4CAF50"}
{#param name=dr_table_3_col_header_textcolor value="#ffffff"}
 
<!--CHANGE COLOR ON ROWS:
Background color and Text color for nth-child(odd): Row 35
Background color and Text color for nth-child(even): Row 36
END SETTINGS-->
 
{#literal}
 
<style>
.dr-table-3-col {
    font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
    border-collapse: collapse;
    width: 100%;
}
 
.dr-table-3-col td, .dr-table-3-col th {
    border: 1px solid #ddd;
    text-align: left;
    padding: 8px;
}
 
.dr-table-3-col tr {background-color: lightgrey; color: #darkgrey;}
.dr-table-3-col tr:nth-child(even){background-color: white; color: #darkgrey;
}
 
.dr-table-3-col tr:hover {background-color: #4CAF50; color: white;}
 
.dr-table-3-col th {
    padding-top: 12px;
    padding-bottom: 12px;
   /* background-color: #4CAF50;
    color: white;*/
}
</style>
{#/literal}
 
 
<table class="dr-table-3-col">
  <tr style="background-color: {$P["dr_table_3_col_header_bgcolor"]}; color: {$P["dr_table_3_col_header_textcolor"]};">
<th>{$P.dr_table_3_col_header1}</th>
    <th>{$P.dr_table_3_col_header2}</th>
    <th>{$P.dr_table_3_col_header3}</th>
  </tr>
{#foreach $T.rows as row}
  <tr class="SelectableItem" selectcolumn="{$P.selectColumn}" selectvalue="{$T.row[$P.selectColumn]}">
    <td>{fixAndFormatIfNumber($T.row[$P.dr_table_3_col_idColumn])}</td>
    <td>{$T.row[$P.dr_table_3_col_property1]}</td>
    <td>{fixAndFormatIfNumber($T.row[$P.dr_table_3_col_property2])}</td>
  </tr>
  {#/for}
  
</table>
<!--Author: digrealtime.com-->
<!--Created: 2016-06-21-->
<!--Modified: 2016-06-21-->

Have a Template you want to share with us? Please send code and a screenshot to info@digrealtime.com

  • Facebook
  • Twitter
  • Tumblr
  • Pinterest
  • Google+
  • LinkedIn
  • E-Mail

Leave a reply Cancel reply

You must be logged in to post a comment.

Categories

  • No categories

Recent posts

  • KPI Display 2016-06-23
  • Horizontal Bars with Selectable Item 2016-06-23
  • Simple 3-Column Table with Select 2016-06-20
  • Simple Checkbox List 2016-06-19

Tags

badges bars checkbox displays KPI tables

About us

Manifact AB

It all started in 2006, when it was almost impossible to get real time data from operations within a company. But as change management consultants, we needed it badly to solve problems and follow up manufacturing processes for our customers, so we decided to develop our own realtime analytics platform from scratch.

And since then, that is what we've been busy doing.

Today, many medium and large sized companies throughout the world are using our enterprise business intelligence software in their everyday decision making.

On our 10th anniversary early 2016, we decided to let our platform be free to download and use for anyone. You can now implement it in your own organization in a couple of hours, and start solving business problems and follow up your entire business in real-time.

And if you need to restrict access to certain data and dashboards per user or per user group, sharing features, LDAP integration (Active Directory) and premium support, we also provide a Pro Edition.

Site Navigation

  • Start
  • Product
  • Services
  • Custom Widgets
  • Register a FREE Account
  • Download the Software
  • Quick Setup Guide
  • Dashboard Studio Guide
  • Data Extraction Guide
  • Pricing
  • Contact
  • Login
  • Forums
  • Blog
© 2016 DigRealtime.com

Insert/edit link

Enter the destination URL

Or link to existing content

    No search term specified. Showing recent items. Search or use up and down arrow keys to select an item.