Changes between Version 7 and Version 8 of DeveloperGuidelines/DataTables

Timestamp:

06/10/11 08:56:14 (14 years ago)

Author:

graeme

Comment:

--

DeveloperGuidelines/DataTables

@@ -11 +11 @@
 || dataTable_iDisplayLength \\'''auto''' || The number of rows to be displayed on a page || Integer || Confusion... dataTable_iDisplayLength and iDisplayLength ||
 || no_sspag \\'''auto''' || This will turn off pagination || Boolean || Pagination is the default and nothing needs to be done to enable it. ||
-|| sortby || This will do an initial sort on the selected column or columns || list of sorting rules. The sorting rules are a list that comprises of the column number followed by the sort direction || default value ![[1,'asc']] if this is changed then you also need to use the orderby attribute which is used to order teh records coming off from the database.||
+|| sortby || This will do an initial sort on the selected column or columns || list of sorting rules. The sorting rules are a list that comprises of the column number followed by the sort direction ||default value ![[1,'asc']] if this is changed then you also need to use the orderby attribute which is used to order the records coming off from the database.||
 || dataTable_sDom \\'''auto''' || This defines where the controls of the !DataTable will be positioned || String explained in the !DataTables documentation || default value 'fril<"dataTable_table"t>pi' See http://www.datatables.net/usage/options for more information ||
 || dataTable_sPaginationType || This defines what controls are displayed to allow the user to page through the records || String either 'two_button' or 'full_numbers' \\default value 'full_numbers' || ||
@@ -190 +190 @@
 [[Image(DataTable_Sorted by_Status.png)]]
 [[BR]]
-
-=== Filter Rows ===
 === Selecting Rows ===
+It is possible to select multiple rows by setting the all this requires is to set the dataTableSelectable attribute
+{{{
+#!div style="font-size: 80%"
+Add this to the prep() function of the controller:
+  {{{#!python
+        response.s3.dataTableSelectable = True
+  }}}
+}}}
+[[Image(DataTable_with_Selected_Rows.png)]]
+[[BR]]
 === Highlighting Rows ===
+You can highlight rows. For example set an alert if the file has already been imported or set a warning if the file is more than 60 days old.
+{{{
+#!div style="font-size: 80%"
+Add this to the prep() function of the controller:
+  {{{#!python
+        # Display an Alert if the file has already been imported 
+        query = (r.table.status == 2)
+        rows = db(query).select(r.table.id)
+        response.s3.dataTableStyleAlert = [str(row.id) for row in rows]
+        # Display a Warning if the file is more than 60 days old 
+        warningDate = datetime.now() - timedelta(days=60)
+        query = (r.table.created_on < warningDate)
+        rows = db(query).select(r.table.id)
+        response.s3.dataTableStyleWarning = [str(row.id) for row in rows]
+  }}}
+}}}
+[[Image(DataTable_with_Highlighting.png)]]
+[[BR]]
 === Highlighting Cells ===
+Not Yet Implemented