From b2b262c06a40a475219ab9c1859b849121082e80 Mon Sep 17 00:00:00 2001
From: Tavares André <tavares_and@hotmail.com>
Date: Fri, 17 Apr 2015 21:12:25 +0200
Subject: Report manager implementation

---
 MediaBrowser.Api/Reports/Data/ReportExport.cs | 210 ++++++++++++++++++++++++++
 1 file changed, 210 insertions(+)
 create mode 100644 MediaBrowser.Api/Reports/Data/ReportExport.cs

(limited to 'MediaBrowser.Api/Reports/Data/ReportExport.cs')

diff --git a/MediaBrowser.Api/Reports/Data/ReportExport.cs b/MediaBrowser.Api/Reports/Data/ReportExport.cs
new file mode 100644
index 000000000..a8205f42e
--- /dev/null
+++ b/MediaBrowser.Api/Reports/Data/ReportExport.cs
@@ -0,0 +1,210 @@
+using System;
+using System.Collections.Generic;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace MediaBrowser.Api.Reports
+{
+	/// <summary> A report export. </summary>
+	public class ReportExport
+	{
+		/// <summary> Export to CSV. </summary>
+		/// <param name="reportResult"> The report result. </param>
+		/// <returns> A string. </returns>
+		public string ExportToCsv(ReportResult reportResult)
+		{
+			StringBuilder returnValue = new StringBuilder();
+
+			returnValue.AppendLine(string.Join(";", reportResult.Headers.Select(s => s.Name.Replace(',', ' ')).ToArray()));
+
+			if (reportResult.IsGrouped)
+				foreach (ReportGroup group in reportResult.Groups)
+				{
+					foreach (ReportRow row in reportResult.Rows)
+					{
+						returnValue.AppendLine(string.Join(";", row.Columns.Select(s => s.Name.Replace(',', ' ')).ToArray()));
+					}
+				}
+			else
+				foreach (ReportRow row in reportResult.Rows)
+				{
+					returnValue.AppendLine(string.Join(";", row.Columns.Select(s => s.Name.Replace(',', ' ')).ToArray()));
+				}
+
+			return returnValue.ToString();
+		}
+
+
+		/// <summary> Export to excel. </summary>
+		/// <param name="reportResult"> The report result. </param>
+		/// <returns> A string. </returns>
+		public string ExportToExcel(ReportResult reportResult)
+		{
+
+			string style = @"<style type='text/css'>
+							BODY {
+									font-family: Arial;
+									font-size: 12px;
+								}
+
+								TABLE {
+									font-family: Arial;
+									font-size: 12px;
+								}
+
+								A {
+									font-family: Arial;
+									color: #144A86;
+									font-size: 12px;
+									cursor: pointer;
+									text-decoration: none;
+									font-weight: bold;
+								}
+								DIV {
+									font-family: Arial;
+									font-size: 12px;
+									margin-bottom: 0px;
+								}
+								P, LI, DIV {
+									font-size: 12px;
+									margin-bottom: 0px;
+								}
+
+								P, UL {
+									font-size: 12px;
+									margin-bottom: 6px;
+									margin-top: 0px;
+								}
+
+								H1 {
+									font-size: 18pt;
+								}
+
+								H2 {
+									font-weight: bold;
+									font-size: 14pt;
+									COLOR: #C0C0C0;
+								}
+
+								H3 {
+									font-weight: normal;
+									font-size: 14pt;
+									text-indent: +1em;
+								}
+
+								H4 {
+									font-size: 10pt;
+									font-weight: normal;
+								}
+
+								H5 {
+									font-size: 10pt;
+									font-weight: normal;
+									background: #A9A9A9;
+									COLOR: white;
+									display: inline;
+								}
+
+								H6 {
+									padding: 2 1 2 5;
+									font-size: 11px;
+									font-weight: bold;
+									text-decoration: none;
+									margin-bottom: 1px;
+								}
+
+								UL {
+									line-height: 1.5em;
+									list-style-type: disc;
+								}
+
+								OL {
+									line-height: 1.5em;
+								}
+
+								LI {
+									line-height: 1.5em;
+								}
+
+								A IMG {
+									border: 0;
+								}
+
+								table.gridtable {
+									color: #333333;
+									border-width: 0.1pt;
+									border-color: #666666;
+									border-collapse: collapse;
+								}
+
+								table.gridtable th {
+									border-width: 0.1pt;
+									padding: 8px;
+									border-style: solid;
+									border-color: #666666;
+									background-color: #dedede;
+								}
+
+								table.gridtable td {
+									border-width: 0.1pt;
+									padding: 8px;
+									border-style: solid;
+									border-color: #666666;
+									background-color: #ffffff;
+								}
+						</style>";
+
+			string Html = @"<!DOCTYPE html>
+							<html xmlns='http://www.w3.org/1999/xhtml'>
+							<head>
+							<meta http-equiv='X-UA-Compatible' content='IE=8, IE=9, IE=10' />
+							<meta charset='utf-8'>
+							<title>Emby Export</title>";
+			Html += "\n" + style + "\n";
+			Html += "</head>\n";
+			Html += "<body>\n";
+
+			StringBuilder returnValue = new StringBuilder();
+			returnValue.AppendLine("<table  class='gridtable'>");
+			returnValue.AppendLine("<tr>");
+			returnValue.AppendLine(string.Join("", reportResult.Headers.Select(s => string.Format("<th>{0}</th>", s.Name)).ToArray()));
+			returnValue.AppendLine("</tr>");
+			if (reportResult.IsGrouped)
+				foreach (ReportGroup group in reportResult.Groups)
+				{
+					returnValue.AppendLine("<tr style='background-color: rgb(51, 51, 51);'>");
+					returnValue.AppendLine("<th scope='rowgroup' colspan='" + reportResult.Headers.Count + "'>" + (string.IsNullOrEmpty(group.Name) ? "&nbsp;" : group.Name) + "</th>");
+					returnValue.AppendLine("</tr>");
+					foreach (ReportRow row in group.Rows)
+					{
+						ExportToExcelRow(reportResult, returnValue, row);
+					}
+					returnValue.AppendLine("<tr style='background-color: white;'>");
+					returnValue.AppendLine("<th scope='rowgroup' colspan='" + reportResult.Headers.Count + "'>" + "&nbsp;" + "</th>");
+					returnValue.AppendLine("</tr>");
+				}
+
+			else
+				foreach (ReportRow row in reportResult.Rows)
+				{
+					ExportToExcelRow(reportResult, returnValue, row);
+				}
+			returnValue.AppendLine("</table>");
+
+			Html += returnValue.ToString();
+			Html += "</body>";
+			Html += "</html>";
+			return Html;
+		}
+		private static void ExportToExcelRow(ReportResult reportResult,
+			StringBuilder returnValue,
+			ReportRow row)
+		{
+			returnValue.AppendLine("<tr>");
+			returnValue.AppendLine(string.Join("", row.Columns.Select(s => string.Format("<td>{0}</td>", s.Name)).ToArray()));
+			returnValue.AppendLine("</tr>");
+		}
+	}
+
+}
-- 
cgit v1.2.3


From d2a8ca7f5f64ec08aa25ad2ca28cdf0b2ebfc993 Mon Sep 17 00:00:00 2001
From: Tavares André <tavares_and@hotmail.com>
Date: Tue, 21 Apr 2015 18:43:22 +0200
Subject: Report Manager - Code fix

---
 MediaBrowser.Api/Reports/Data/ReportExport.cs              | 8 +++++---
 MediaBrowser.WebDashboard/MediaBrowser.WebDashboard.csproj | 6 ++++++
 2 files changed, 11 insertions(+), 3 deletions(-)

(limited to 'MediaBrowser.Api/Reports/Data/ReportExport.cs')

diff --git a/MediaBrowser.Api/Reports/Data/ReportExport.cs b/MediaBrowser.Api/Reports/Data/ReportExport.cs
index a8205f42e..40466f002 100644
--- a/MediaBrowser.Api/Reports/Data/ReportExport.cs
+++ b/MediaBrowser.Api/Reports/Data/ReportExport.cs
@@ -145,7 +145,9 @@ namespace MediaBrowser.Api.Reports
 									border-color: #666666;
 									background-color: #dedede;
 								}
-
+								table.gridtable tr {
+									background-color: #ffffff;
+								}
 								table.gridtable td {
 									border-width: 0.1pt;
 									padding: 8px;
@@ -160,7 +162,7 @@ namespace MediaBrowser.Api.Reports
 							<head>
 							<meta http-equiv='X-UA-Compatible' content='IE=8, IE=9, IE=10' />
 							<meta charset='utf-8'>
-							<title>Emby Export</title>";
+							<title>Emby Reports Export</title>";
 			Html += "\n" + style + "\n";
 			Html += "</head>\n";
 			Html += "<body>\n";
@@ -180,7 +182,7 @@ namespace MediaBrowser.Api.Reports
 					{
 						ExportToExcelRow(reportResult, returnValue, row);
 					}
-					returnValue.AppendLine("<tr style='background-color: white;'>");
+					returnValue.AppendLine("<tr>");
 					returnValue.AppendLine("<th scope='rowgroup' colspan='" + reportResult.Headers.Count + "'>" + "&nbsp;" + "</th>");
 					returnValue.AppendLine("</tr>");
 				}
diff --git a/MediaBrowser.WebDashboard/MediaBrowser.WebDashboard.csproj b/MediaBrowser.WebDashboard/MediaBrowser.WebDashboard.csproj
index 5c4aab1e4..00debc459 100644
--- a/MediaBrowser.WebDashboard/MediaBrowser.WebDashboard.csproj
+++ b/MediaBrowser.WebDashboard/MediaBrowser.WebDashboard.csproj
@@ -135,6 +135,9 @@
     <Content Include="dashboard-ui\photos.html">
       <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
     </Content>
+    <Content Include="dashboard-ui\ReportManager.html">
+      <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+    </Content>
     <Content Include="dashboard-ui\scripts\dashboardhosting.js">
       <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
     </Content>
@@ -153,6 +156,9 @@
     <Content Include="dashboard-ui\scripts\photos.js">
       <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
     </Content>
+    <Content Include="dashboard-ui\scripts\reportmanager.js">
+      <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
+    </Content>
     <Content Include="dashboard-ui\scripts\selectserver.js">
       <CopyToOutputDirectory>PreserveNewest</CopyToOutputDirectory>
     </Content>
-- 
cgit v1.2.3


From adc52db15a497a003cbea77cf11d907390390e96 Mon Sep 17 00:00:00 2001
From: Tavares André <tavares_and@hotmail.com>
Date: Tue, 21 Apr 2015 20:21:45 +0200
Subject: Report Manager - Excel export fix and added localization

---
 MediaBrowser.Api/Reports/Data/ReportExport.cs                      | 4 ++--
 .../Localization/Server/server.json                                | 7 ++++++-
 2 files changed, 8 insertions(+), 3 deletions(-)

(limited to 'MediaBrowser.Api/Reports/Data/ReportExport.cs')

diff --git a/MediaBrowser.Api/Reports/Data/ReportExport.cs b/MediaBrowser.Api/Reports/Data/ReportExport.cs
index 40466f002..f313cf252 100644
--- a/MediaBrowser.Api/Reports/Data/ReportExport.cs
+++ b/MediaBrowser.Api/Reports/Data/ReportExport.cs
@@ -175,7 +175,7 @@ namespace MediaBrowser.Api.Reports
 			if (reportResult.IsGrouped)
 				foreach (ReportGroup group in reportResult.Groups)
 				{
-					returnValue.AppendLine("<tr style='background-color: rgb(51, 51, 51);'>");
+					returnValue.AppendLine("<tr>");
 					returnValue.AppendLine("<th scope='rowgroup' colspan='" + reportResult.Headers.Count + "'>" + (string.IsNullOrEmpty(group.Name) ? "&nbsp;" : group.Name) + "</th>");
 					returnValue.AppendLine("</tr>");
 					foreach (ReportRow row in group.Rows)
@@ -183,7 +183,7 @@ namespace MediaBrowser.Api.Reports
 						ExportToExcelRow(reportResult, returnValue, row);
 					}
 					returnValue.AppendLine("<tr>");
-					returnValue.AppendLine("<th scope='rowgroup' colspan='" + reportResult.Headers.Count + "'>" + "&nbsp;" + "</th>");
+					returnValue.AppendLine("<th style='background-color: #ffffff;' scope='rowgroup' colspan='" + reportResult.Headers.Count + "'>" + "&nbsp;" + "</th>");
 					returnValue.AppendLine("</tr>");
 				}
 
diff --git a/MediaBrowser.Server.Implementations/Localization/Server/server.json b/MediaBrowser.Server.Implementations/Localization/Server/server.json
index f464dad4b..d0c4aa164 100644
--- a/MediaBrowser.Server.Implementations/Localization/Server/server.json
+++ b/MediaBrowser.Server.Implementations/Localization/Server/server.json
@@ -1435,5 +1435,10 @@
     "LabelSelectViewStyles": "Enable rich presentations for:",
     "LabelSelectViewStylesHelp": "If enabled, views will be built with metadata to offer categories such as Suggestions, Latest, Genres, and more. If disabled, they'll be displayed with simple folders.",
     "TabPhotos": "Photos",
-    "TabVideos": "Videos"
+	"TabVideos": "Videos",
+	"OptionReportList": "List View",
+    "OptionReportStatistics": "Statistics",
+    "OptionReportGrouping": "Grouping",
+    "OptionReportExport": "Report Export",
+    "OptionReportColumns": "Report Columns"
 }
-- 
cgit v1.2.3