Avoid SQL error if DMARC Result or Report Status chosen as initial sort column

Temporary fix to avoid an SQL error if DMARC Result or Report Status column sorting is set when "Save Current Settings as initial View" is selected. These two columns aren't in the database (only in the html table) and so can't be in the SQL statement.

1 files changed, 5 insertions, 0 deletions

diff --git a/dmarcts-report-viewer.js b/dmarcts-report-viewer.js
index 904577c..046479f 100644
--- a/dmarcts-report-viewer.js
+++ b/dmarcts-report-viewer.js
@@ -571,6 +571,11 @@ function build_cookie() {
 			sort = 1;
 		}
 
+		if ( sort_column == "" ) {
+			sort_column = "maxdate";
+			alert("Unfortuantely at this time, neither the DMARC Result nor the Report Status columns can be saved as initial sort columns. The initial sort column has been set to End Date, " + (sort == 0 ? "descending." : "ascending."));
+		}
+
 		// Create cookie_value object that gets placed into cookie
 
 		// When a new option is added, check the size of the cookie stored. The cookie size should be less than half of the maximum cookie size allowed per domain.