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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
|
<UserControl x:Class="Tango.PPC.UI.Views.MachineSetupView"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:vm="clr-namespace:Tango.PPC.UI.ViewModels"
xmlns:controls="clr-namespace:Tango.SharedUI.Controls;assembly=Tango.SharedUI"
xmlns:global="clr-namespace:Tango.PPC.UI"
xmlns:setup="clr-namespace:Tango.PPC.Common.MachineSetup;assembly=Tango.PPC.Common"
xmlns:connectivity="clr-namespace:Tango.PPC.Common.Connectivity;assembly=Tango.PPC.Common"
xmlns:touch="clr-namespace:Tango.Touch.Controls;assembly=Tango.Touch"
xmlns:web="clr-namespace:Tango.Web;assembly=Tango.Web"
xmlns:local="clr-namespace:Tango.PPC.UI.Views"
xmlns:common="clr-namespace:Tango.PPC.Common;assembly=Tango.PPC.Common"
mc:Ignorable="d"
d:DesignHeight="1280" d:DesignWidth="800" d:DataContext="{d:DesignInstance Type=vm:MachineSetupViewVM, IsDesignTimeCreatable=False}" DataContext="{x:Static global:ViewModelLocator.MachineSetupViewVM}">
<Grid Background="{StaticResource TangoPrimaryBackgroundBrush}">
<Grid>
<DockPanel>
<StackPanel DockPanel.Dock="Top" HorizontalAlignment="Center" Margin="0 100 0 0">
<Image Source="/Images/package.png" Width="180" Height="180" />
<TextBlock HorizontalAlignment="Center" FontSize="{StaticResource TangoHeaderFontSize}" Margin="30">Machine Setup Wizard</TextBlock>
</StackPanel>
<Grid DockPanel.Dock="Bottom" Height="200" Background="{StaticResource TangoMidBackgroundBrush}">
<Border BorderThickness="0 1 0 0" BorderBrush="{StaticResource TangoGrayBrush}">
<TextBox x:Name="txtLog" Foreground="{StaticResource TangoGrayTextBrush}" FontSize="12" SelectionBrush="#8BB0B0B0" IsReadOnly="True" Padding="5" Background="Transparent" AcceptsReturn="True" TextWrapping="Wrap" HorizontalScrollBarVisibility="Disabled" VerticalScrollBarVisibility="Auto">
</TextBox>
</Border>
</Grid>
<controls:NavigationControl x:Name="navigationControl" TransitionType="Slide" KeepElementsAttached="True" Margin="0 20 0 0" SelectedIndex="0">
<Grid controls:NavigationControl.NavigationName="WelcomeView">
<StackPanel HorizontalAlignment="Center" Margin="0 20 0 0">
<TextBlock TextAlignment="Center" LineHeight="40" Margin="20 0" TextWrapping="Wrap" FontSize="{StaticResource TangoTitleFontSize}">
<Run>Welcome to the machine setup wizard!</Run>
<Run>In the next steps the software will gather required information, perform tests and apply an initial configuration to this machine.</Run>
<LineBreak/>
<LineBreak/>
<Run>Press 'start' to initiate the setup process.</Run>
</TextBlock>
<touch:TouchButton Margin="0 250 0 0" Padding="20" Width="300" CornerRadius="35" Command="{Binding NavigateToWiFiCommand}">START</touch:TouchButton>
</StackPanel>
</Grid>
<Grid controls:NavigationControl.NavigationName="WiFiSelectionView">
<DockPanel>
<TextBlock DockPanel.Dock="Top" Margin="20 0" FontSize="{StaticResource TangoTitleFontSize}" HorizontalAlignment="Center" TextWrapping="Wrap" TextAlignment="Center">
<Run>We need an active internet connection in order to fetch the latest software package and machine configuration.</Run>
<LineBreak/>
<LineBreak/>
<Run>Please connect to one of the available WiFi networks.</Run>
</TextBlock>
<connectivity:AvailableWiFiConnectionsControl DataContext="{Binding ConnectivityProvider}" Margin="50 100 50 20" BorderBrush="{StaticResource TangoDividerBrush}" BorderThickness="0 1 0 0" />
</DockPanel>
</Grid>
<Grid controls:NavigationControl.NavigationName="WiFiTestView">
<StackPanel HorizontalAlignment="Center" Margin="0 200 0 0">
<TextBlock DockPanel.Dock="Top" Margin="20 0" FontSize="{StaticResource TangoTitleFontSize}" HorizontalAlignment="Center" TextWrapping="Wrap" TextAlignment="Center">
Checking internet connection, please wait...
</TextBlock>
<touch:TouchBusyIndicator Width="250" Margin="0 100 0 0" Height="250" IsIndeterminate="{Binding CurrentView,Converter={StaticResource EnumToBooleanConverter},ConverterParameter='WiFiTestView'}" />
</StackPanel>
</Grid>
<Grid controls:NavigationControl.NavigationName="TimeZoneView">
<StackPanel HorizontalAlignment="Center" VerticalAlignment="Center" Width="500">
<Image Source="/Images/time-zone.png" Width="128" />
<TextBlock HorizontalAlignment="Center" FontSize="{StaticResource TangoTitleFontSize}">Please select the machine time zone</TextBlock>
<touch:TouchComboBox Margin="0 80 0 0" ItemsSource="{Binding TimeZones}" SelectedItem="{Binding SelectedTimeZone,Mode=TwoWay}">
</touch:TouchComboBox>
<touch:TouchButton Margin="0 200 0 0" Padding="20" Width="300" CornerRadius="35" Command="{Binding TimeZoneSelectedCommand}">CONTINUE</touch:TouchButton>
</StackPanel>
</Grid>
<Grid controls:NavigationControl.NavigationName="EnvironmentView">
<StackPanel HorizontalAlignment="Center" VerticalAlignment="Center" Width="500">
<Image Source="/Images/environment.png" Width="128" />
<TextBlock Margin="0 20 0 0" HorizontalAlignment="Center" FontSize="{StaticResource TangoTitleFontSize}">Please select the machine working environment</TextBlock>
<touch:TouchComboBox Margin="0 80 0 0" Title="Select Environment" ItemsSource="{Binding Source={x:Type web:DeploymentSlot},Converter={StaticResource EnumToItemsSourceConverter},ConverterParameter='false'}" SelectedItem="{Binding DeploymentSlot}">
<touch:TouchComboBox.ItemTemplate>
<DataTemplate>
<TextBlock Padding="10" FontSize="{StaticResource TangoTitleFontSize}" Text="{Binding Converter={StaticResource EnumToDescriptionConverter}}">
<TextBlock.Style>
<Style TargetType="TextBlock">
<Style.Triggers>
<DataTrigger Binding="{Binding RelativeSource={RelativeSource AncestorType=touch:TouchListBoxItem},Path=IsSelected}" Value="True">
<Setter Property="Foreground" Value="{StaticResource TangoPrimaryAccentBrush}"></Setter>
</DataTrigger>
</Style.Triggers>
</Style>
</TextBlock.Style>
</TextBlock>
</DataTemplate>
</touch:TouchComboBox.ItemTemplate>
<touch:TouchComboBox.SelectedItemTemplate>
<DataTemplate>
<TextBlock FontSize="{StaticResource TangoTitleFontSize}" Text="{Binding Converter={StaticResource EnumToDescriptionConverter}}"></TextBlock>
</DataTemplate>
</touch:TouchComboBox.SelectedItemTemplate>
</touch:TouchComboBox>
<touch:TouchButton Margin="0 200 0 0" Padding="20" Width="300" CornerRadius="35" Command="{Binding EnvironmentSelectedCommand}">CONTINUE</touch:TouchButton>
</StackPanel>
</Grid>
<Grid controls:NavigationControl.NavigationName="SetupWelcomeView">
<StackPanel>
<TextBlock TextAlignment="Center" LineHeight="40" FontSize="{StaticResource TangoTitleFontSize}" Margin="40 0" TextWrapping="Wrap">
The next step is to download the latest software package and synchronize the machine data. Please enter your machine serial number and press 'install'.
</TextBlock>
<StackPanel Width="500" Margin="0 100 0 0" TextElement.FontSize="{StaticResource TangoTitleFontSize}">
<TextBlock>SERIAL NUMBER</TextBlock>
<touch:TouchTextBox Foreground="{StaticResource TangoGrayTextBrush}" Margin="0 10 0 0" Text="{Binding SerialNumber}" KeyboardContainer="{Binding ElementName=Container}" />
<StackPanel HorizontalAlignment="Center">
<TextBlock Margin="0 80 0 0" FontSize="12" Foreground="{StaticResource TangoGrayTextBrush}">MACHINE SERVICE ADDRESS</TextBlock>
<TextBlock FontSize="11" HorizontalAlignment="Center" Foreground="{StaticResource TangoGrayTextBrush}" Margin="0 5 0 0" Text="{Binding HostAddress}" />
</StackPanel>
<touch:TouchButton Margin="0 200 0 0" Padding="20" Width="300" CornerRadius="35" Command="{Binding InstallCommand}">INSTALL</touch:TouchButton>
</StackPanel>
</StackPanel>
</Grid>
<Grid controls:NavigationControl.NavigationName="SetupProgressView">
<StackPanel>
<TextBlock TextAlignment="Center" FontSize="{StaticResource TangoTitleFontSize}">
<Run>Please wait while we're setting up this machine.</Run>
<Run>Do not turn off this PC.</Run>
</TextBlock>
<StackPanel Margin="0 200 0 0">
<TextBlock Text="{Binding MachineSetupManager.Status.Name,FallbackValue='Download Software Package'}" HorizontalAlignment="Center" FontSize="{StaticResource TangoTitleFontSize}"></TextBlock>
<TextBlock HorizontalAlignment="Center" Text="{Binding MachineSetupManager.Status.Message,FallbackValue='Connecting to machine service...'}" Margin="0 40 0 0"></TextBlock>
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Tango.BL;
using Tango.BL.Builders;
using Tango.BL.Entities;
using Tango.BL.Enumerations;
using Tango.Core.Commands;
using Tango.MachineStudio.Common;
using Tango.MachineStudio.Common.Notifications;
using Tango.MachineStudio.Statistics.Models;
using Tango.SharedUI;
using Tango.SharedUI.Components;
using Tango.AutoComplete.Editors;
using System.Windows.Media;
using LiveCharts.Wpf;
using LiveCharts;
using Tango.BL.ValueObjects;
using System.Diagnostics;
using Microsoft.Win32;
using Tango.CSV;
using System.ComponentModel;
namespace Tango.MachineStudio.Statistics.ViewModels
{
public enum HeadCleaningSelectionEnum
{
[Description("Exclude")]
Exclude = 0,
[Description("Include")]
Include = 1,
[Description("Only")]
Only = 2
};
public class JobRunsViewVM : ViewModel
{
private INotificationProvider _notification;
private List<Machine> _allMachines;
private List<User> _allUsers;
private List<RmlModel> _rmlsModels;
#region Properties
private ObservableCollection<JobRunModel> _jobRuns;
/// <summary>
/// Gets or sets the job runs. Contains filtered data of JobRunModel.
/// </summary>
public ObservableCollection<JobRunModel> JobRuns
{
get { return _jobRuns; }
set
{
_jobRuns = value;
RaisePropertyChangedAuto();
}
}
private JobRunModel _selectedJobRun = null;
/// <summary>
/// Gets or sets the JobRunModel. Binding to selected item of grid items.
/// </summary>
public JobRunModel SelectedJobRun
{
get { return _selectedJobRun; }
set
{
_selectedJobRun = value;
RaisePropertyChangedAuto();
}
}
private SelectedObjectCollection<Machine> _selectedMachines;
/// <summary>
/// Gets or sets the selected machines. Contains all available machines and selected machines. Binding to ComboBox Machines.
/// </summary>
public SelectedObjectCollection<Machine> SelectedMachines
{
get { return _selectedMachines; }
set
{
_selectedMachines = value;
RaisePropertyChangedAuto();
}
}
private DateTime _startSelectedDate;
/// <summary>
/// Gets or sets the start selected date.
/// </summary>
public DateTime StartSelectedDate
{
get { return _startSelectedDate; }
set { _startSelectedDate = value;
RaisePropertyChangedAuto();
}
}
private DateTime _endSelectedDate;
/// <summary>
/// Gets or sets the end selected date.
/// </summary>
public DateTime EndSelectedDate
{
get { return _endSelectedDate; }
set { _endSelectedDate = value; RaisePropertyChangedAuto(); }
}
protected Double _lengthLowerValue;
/// <summary>
/// Gets or sets the length lower value of Range Slider
/// </summary>
public Double LengthLowerValue
{
get { return _lengthLowerValue; }
set
{
_lengthLowerValue = value;
RaisePropertyChangedAuto();
}
}
protected Double _lengthUpperValue;
/// <summary>
/// Gets or sets the length upper value of Range Slider.
/// </summary>
public Double LengthUpperValue
{
get { return _lengthUpperValue; }
set
{
_lengthUpperValue = value;
RaisePropertyChangedAuto();
}
}
private SelectedObjectCollection<JobSource> _jobRunSelectedSources;
/// <summary>
/// Gets or sets the job run selected sources. Binding to ComboBox "Source".
/// </summary>
public SelectedObjectCollection<JobSource> JobRunSelectedSources
{
get { return _jobRunSelectedSources; }
set { _jobRunSelectedSources = value; RaisePropertyChangedAuto(); }
}
private SelectedObjectCollection<JobRunStatus> _jobRunSelectedStatuses;
/// <summary>
/// Gets or sets the job run selected statuses. Binding to ComboBox "Status".
/// </summary>
public SelectedObjectCollection<JobRunStatus> JobRunSelectedStatuses
{
get { return _jobRunSelectedStatuses; }
set { _jobRunSelectedStatuses = value; RaisePropertyChangedAuto(); }
}
public SelectedObjectCollection<bool> _isGradientSelection;
/// <summary>
/// Gets or sets the is gradient selection. Binding to ComboBox "IsGradient".
/// </summary>
public SelectedObjectCollection<bool> IsGradientSelection
{
get { return _isGradientSelection; }
set
{
_isGradientSelection = value;
RaisePropertyChangedAuto();
}
}
private SelectedObjectCollection<RmlModel> _selectedThreads;
/// <summary>
/// Gets or sets the selected threads. Contains all available threads and selected threads. Binding to ComboBox "Thread".
/// </summary>
public SelectedObjectCollection<RmlModel> SelectedThreads
{
get { return _selectedThreads; }
set
{
_selectedThreads = value;
RaisePropertyChangedAuto();
}
}
private HeadCleaningSelectionEnum _headCleaningSelected;
public HeadCleaningSelectionEnum HeadCleaningSelected
{
get { return _headCleaningSelected; }
set
{
_headCleaningSelected = value;
RaisePropertyChangedAuto();
}
}
/// <summary>
/// Gets or sets the JobRuns providers.
/// </summary>
public ISuggestionProvider JobsProvider { get; set; }
private Job _selectedJob;
/// <summary>
/// Gets or sets the job.
/// </summary>
public Job SelectedJob
{
get { return _selectedJob; }
set
{
_selectedJob = value;
RaisePropertyChangedAuto();
}
}
/// <summary>
/// Gets or sets the statistics value collection. Class - container included calculated statistic values.
/// </summary>
public StatisticsValueCollection StatisticsValueCollection { get; set; }
#endregion
public RelayCommand LoadJobRunsCommand { get; set; }
public RelayCommand ExportToExcelCommand { get; set; }
public JobRunsViewVM(INotificationProvider notificationProvider)
{
_notification = notificationProvider;
JobRuns = new ObservableCollection<JobRunModel>();
LoadJobRunsCommand = new RelayCommand(async () => await LoadJobRuns(), () => IsFree);
ExportToExcelCommand = new RelayCommand(ExportToExcel, () => IsFree);
LengthUpperValue = 10000.0;
LengthLowerValue = 0.0;
DateTime now = DateTime.Now;
StartSelectedDate = now.AddMonths(-1);
EndSelectedDate = now;
JobRunSelectedSources = new SelectedObjectCollection<JobSource>(new ObservableCollection<JobSource>()
{
JobSource.Local,
JobSource.Remote
}, new ObservableCollection<JobSource>()
{
JobSource.Local,
JobSource.Remote
});
JobRunSelectedSources.SelectionChanged -= (x, y) => RaisePropertyChanged(nameof(JobRunSelectedSources));
JobRunSelectedSources.SelectionChanged += (x, y) => RaisePropertyChanged(nameof(JobRunSelectedSources));
JobRunSelectedStatuses = new SelectedObjectCollection<JobRunStatus>(new ObservableCollection<JobRunStatus>()
{
JobRunStatus.Aborted,
JobRunStatus.Completed,
JobRunStatus.Failed,
}, new ObservableCollection<JobRunStatus>()
{
JobRunStatus.Aborted,
JobRunStatus.Completed,
JobRunStatus.Failed,
});
JobRunSelectedStatuses.SelectionChanged -= (x, y) => RaisePropertyChanged(nameof(JobRunSelectedStatuses));
JobRunSelectedStatuses.SelectionChanged += (x, y) => RaisePropertyChanged(nameof(JobRunSelectedStatuses));
IsGradientSelection = new SelectedObjectCollection<bool>(new ObservableCollection<bool>
{
true,
false
}, new ObservableCollection<bool>
{
true,
false
});
IsGradientSelection.SelectionChanged -= (x, y) => RaisePropertyChanged(nameof(IsGradientSelection));
IsGradientSelection.SelectionChanged += (x, y) => RaisePropertyChanged(nameof(IsGradientSelection));
HeadCleaningSelected = HeadCleaningSelectionEnum.Exclude;
JobsProvider = new SuggestionProvider((filter) =>
{
try
{
if (filter != null)
{
using (ObservablesContext db = ObservablesContext.CreateDefault())
{
return db.Jobs.Where(x => x.Name != null && x.Name.ToLower().Contains(filter.ToLower())).ToList();
}
}
else
{
return new List<Job>();
}
}
catch (Exception ex)
{
LogManager.Log(ex, "Error loading jobs.");
return null;
}
});
StatisticsValueCollection = new StatisticsValueCollection();
}
/// <summary>
/// Initializes this instance. Called form main view VM in OnApplicationReady
/// </summary>
public async void Init()
{
using (_notification.PushTaskItem("Loading job runs..."))
{
try
{
IsFree = false;
using (var db = ObservablesContext.CreateDefault())
{
_allMachines = await db.Machines.ToListAsync();
_allUsers = await db.Users.Include(x => x.Contact).ToListAsync();
_rmlsModels = await db.Rmls.Select(x => new RmlModel() { Name = x.Name, Guid = x.Guid }).ToListAsync();
SelectedMachines = new SelectedObjectCollection<Machine>(_allMachines.ToObservableCollection(), new ObservableCollection<Machine>());
SelectedThreads = new SelectedObjectCollection<RmlModel>(_rmlsModels.ToObservableCollection(), new ObservableCollection<RmlModel>());
}
}
catch (Exception ex)
{
LogManager.Log(ex, "Error loading job runs.");
}
finally
{
IsFree = true;
}
}
}
/// <summary>
/// Loads the job runs by filters.
/// </summary>
private async Task LoadJobRuns()
{
using (_notification.PushTaskItem("Loading job runs..."))
{
try
{
IsFree = false;
using (var db = ObservablesContext.CreateDefault())
{
DateTime startUtc = new DateTime(StartSelectedDate.Year, StartSelectedDate.Month, StartSelectedDate.Day, 0, 0, 0).ToUniversalTime();
TimeSpan offsetTime = (EndSelectedDate.Date == DateTime.Now.Date) ? DateTime.Now.TimeOfDay : new TimeSpan(23, 59, 59);
DateTime endUtc = EndSelectedDate.ToUniversalTime() + offsetTime;
string jobName = SelectedJob == null ? "" : SelectedJob.Name;
var db_JobRuns = db.JobRuns.Where(x => (x.StartDate <= endUtc && x.StartDate >= startUtc))
.Select(x => new
{
x.ID,
x.ActualStartDate,
x.EndDate,
x.EndPosition,
x.GradientResolutionCm,
x.Guid,
x.HeatingStartDate,
x.IsGradient,
x.JobGuid,
x.JobLength,
x.JobName,
x.JobSource,
x.MachineGuid,
x.RmlGuid,
x.StartDate,
x.Status,
x.UploadingStartDate,
x.UserGuid,
x.CyanQuantity,
x.MagentaQuantity,
x.YellowQuantity,
x.BlackQuantity,
x.TransparentQuantity,
x.LubricantQuantity,
x.CleanerQuantity,
x.IsHeadCleaning
});
var machineIDs = new HashSet<string>(SelectedMachines.SynchedSource.ToList().Select(p => p.Guid));
if (machineIDs.Count > 0)
{
db_JobRuns = db_JobRuns.Where(x => machineIDs.Contains(x.MachineGuid));
}
int[] jobRunSourceArr = JobRunSelectedSources.SynchedSource.Select(x => (int)x).ToArray();
if (jobRunSourceArr.Length > 0)
{
db_JobRuns = db_JobRuns.Where(x => jobRunSourceArr.Contains(x.JobSource));
}
int[] jobRunStatusArr = JobRunSelectedStatuses.SynchedSource.Select(x => (int)x).ToArray();
if (jobRunStatusArr.Length > 0)
{
db_JobRuns = db_JobRuns.Where(x => jobRunStatusArr.Contains(x.Status));
}
bool[] isGradientArr = IsGradientSelection.SynchedSource.Select(x => (bool)x).ToArray();
if (isGradientArr.Length > 0)
{
db_JobRuns = db_JobRuns.Where(x => isGradientArr.Contains(x.IsGradient));
}
if(HeadCleaningSelected != HeadCleaningSelectionEnum.Include)
{
bool isHeadCleaning = HeadCleaningSelected == HeadCleaningSelectionEnum.Only;
db_JobRuns = db_JobRuns.Where(x => isHeadCleaning == x.IsHeadCleaning);
}
List<String> rmlGuids = SelectedThreads.SynchedSource.Select(y => y.Guid).ToList();
if (rmlGuids != null && rmlGuids.Count > 0)
{
db_JobRuns = db_JobRuns.Where(x => rmlGuids.Contains(x.RmlGuid));
}
if (!String.IsNullOrEmpty(jobName))
{
db_JobRuns = db_JobRuns.Where(x => x.JobName.ToLower().StartsWith(jobName.ToLower()));
}
var runs_db = await db_JobRuns.ToListAsync(); //Execute actual query.
List<JobRun> runs = runs_db.Where(x => (x.JobLength < LengthUpperValue && x.JobLength >= LengthLowerValue))
.Select(x => new JobRun()
{
ID = x.ID,
ActualStartDate = x.ActualStartDate,
EndDate = x.EndDate,
EndPosition = x.EndPosition,
GradientResolutionCm = x.GradientResolutionCm,
Guid = x.Guid,
HeatingStartDate = x.HeatingStartDate,
IsGradient = x.IsGradient,
JobGuid = x.JobGuid,
JobLength = x.JobLength,
JobName = x.JobName,
JobSource = x.JobSource,
MachineGuid = x.MachineGuid,
RmlGuid = x.RmlGuid,
StartDate = x.StartDate,
Status = x.Status,
UploadingStartDate = x.UploadingStartDate,
UserGuid = x.UserGuid,
CyanQuantity = x.CyanQuantity,
MagentaQuantity = x.MagentaQuantity,
YellowQuantity = x.YellowQuantity,
BlackQuantity = x.BlackQuantity,
TransparentQuantity = x.TransparentQuantity,
LubricantQuantity = x.LubricantQuantity,
CleanerQuantity = x.CleanerQuantity,
IsHeadCleaning = x.IsHeadCleaning
}).ToList();
var modelList = runs.Select(x => new JobRunModel()
{
JobRun = x,
Machine = _allMachines.FirstOrDefault(y => y.Guid == x.MachineGuid),
User = _allUsers.SingleOrDefault(y => y.Guid == x.UserGuid),
Rml = _rmlsModels.SingleOrDefault(y => y.Guid == x.RmlGuid),
}).OrderByDescending(x => x.JobRun.StartDate).ToList();
modelList.ForEach(x => x.Init());
JobRuns = modelList.ToObservableCollection();
GenerateStatistics();
}
}
catch (Exception ex)
{
LogManager.Log(ex, "Error loading job runs.");
}
finally
{
IsFree = true;
}
}
}
private void ExportToExcel()
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.Title = "Job Runs Statistic Report";
dlg.Filter = "CSV Files|*.csv";
dlg.FileName = $"Statistics_Job_runs";
dlg.DefaultExt = ".csv";
if (dlg.ShowDialog().Value)
{
try
{
CsvFile<ExcelModel> csvFile = new CsvFile<ExcelModel>(new CsvDestination(dlg.FileName), new CsvDefinition()
{
Columns = new List<String>()
{
"ID",
"Machine",
"User",
"Job Name",
"Thread",
"Length",
"Source",
"Upload Duration",
"Heating Duration",
"Start Time",
"IsGradient",
"Gradient Resolution",
"Status",
"End Date",
"End Position",
"Cyan",
"Magenta",
"Yellow",
"Black",
"Transparent",
"Lubricant",
"Cleaner"
},
});
var selection = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.JobRun.EndDate != null && z.JobRun.ActualStartDate != null);
foreach (var jobRunModel in selection)
{
ExcelModel excel_model = new ExcelModel();
excel_model.ID = jobRunModel.JobRun.ID.ToString();
excel_model.Machine = jobRunModel.Machine != null ? jobRunModel.Machine.SerialNumber : "";
excel_model.User = jobRunModel.User != null ? jobRunModel.User.Contact.FullName: "";
excel_model.JobName = jobRunModel.JobRun.JobName;
excel_model.Thread = jobRunModel.Rml != null ? jobRunModel.Rml.Name : "";
excel_model.Length = String.Format("{0:0.##}", jobRunModel.JobRun.JobLength);
excel_model.Source = jobRunModel.JobRun.Source.ToString();
excel_model.UploadDuration = jobRunModel.UploadDuration != null ? ((TimeSpan)(jobRunModel.UploadDuration)).ToString(@"hh\:mm\:ss") : TimeSpan.FromSeconds(0).ToString(@"hh\:mm\:ss");
excel_model.HeatingDuration = jobRunModel.HeatingDuration != null ? ((TimeSpan)(jobRunModel.HeatingDuration)).ToString(@"hh\:mm\:ss") : TimeSpan.FromSeconds(0).ToString(@"hh\:mm\:ss");
excel_model.StartTime = jobRunModel.JobRun.ActualStartDate != null ? ((DateTime)jobRunModel.JobRun.ActualStartDate).ToLocalTime().ToString("MM/dd/yy HH:mm"): "";
excel_model.IsGradient = jobRunModel.JobRun.IsGradient ? "Yes" : "No";
excel_model.GR = jobRunModel.JobRun.GradientResolutionCm.ToString();
excel_model.Status = jobRunModel.JobRun.JobRunStatus.ToString();
excel_model.EndTime = jobRunModel.JobRun.EndDate != null ? ((DateTime)jobRunModel.JobRun.EndDate).ToLocalTime().ToString("MM/dd/yy HH:mm"): "";
excel_model.EndPosition = String.Format("{0:0.##}", jobRunModel.JobRun.EndPosition);
excel_model.Cyan = jobRunModel.JobRun.CyanQuantity < 0 ? "" :jobRunModel.JobRun.CyanQuantity.ToString();
excel_model.Magenta = jobRunModel.JobRun.MagentaQuantity < 0 ? "" : jobRunModel.JobRun.MagentaQuantity.ToString();
excel_model.Yellow = jobRunModel.JobRun.YellowQuantity < 0 ? "" : jobRunModel.JobRun.YellowQuantity.ToString();
excel_model.Black = jobRunModel.JobRun.BlackQuantity < 0 ? "" : jobRunModel.JobRun.BlackQuantity.ToString();
excel_model.Transparent = jobRunModel.JobRun.TransparentQuantity < 0 ? "" : jobRunModel.JobRun.TransparentQuantity.ToString();
excel_model.Lubricant = jobRunModel.JobRun.LubricantQuantity < 0 ? "" : jobRunModel.JobRun.LubricantQuantity.ToString();
excel_model.Cleaner = jobRunModel.JobRun.CleanerQuantity < 0 ? "" : jobRunModel.JobRun.CleanerQuantity.ToString();
csvFile.Append(excel_model);
}
csvFile.Dispose();
_notification.ShowInfo("Report generated successfully.");
}
catch (Exception ex)
{
LogManager.Log(ex, "Error generating Statistics Job Runs report.");
_notification.ShowError($"Error generating Statistics Job Runs report..\n{ex.Message}");
}
}
}
#region GenerateS_StatisticsValueCollection
/// <summary>
/// Generates the statistics.
/// </summary>
protected void GenerateStatistics()
{
StatisticsValueCollection.Clean();
if (JobRuns.Count() == 0)
return;
GenerateTotalRunsCount();
GenerateTotalRunsLength();
GenerateTotalThreadConsumption();
GenerateRunsDuration();
GenerateAverageUploadDuration();
GenerateAverageHeatingDuration();
GeneratePieCharts();
CreateThreadConsumptionPerThread();
GenerateAllLiquidQuantities();
}
protected void GenerateTotalRunsCount()
{//Total Runs:
int val = JobRuns.Count();
StatisticsValueCollection.AddStatisticsValue("Total Runs ", val, " ");
}
/// <summary>
/// Generates the total length of the job runs.
/// </summary>
protected void GenerateTotalRunsLength()
{
double val = JobRuns.Where(z => z.JobRun.EndPosition > 0).Sum(x => x.JobRun.JobLength);
StatisticsValueCollection.AddStatisticsValue("Total Runs Length", val, " m");
}
/// <summary>
/// Generates the duration and average of the job runs.
/// </summary>
protected void GenerateRunsDuration()
{
var selection = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.JobRun.EndDate != null && z.JobRun.ActualStartDate != null);
double val = 0d;
double average = 0d;
if (selection != null && selection.Count<JobRunModel>() > 0)
{
val = selection.Sum(x => (x.JobRun.EndDate - x.JobRun.ActualStartDate).Value.TotalHours);
average = selection.Average(x => (x.JobRun.EndDate - x.JobRun.ActualStartDate).Value.TotalMilliseconds);
}
StatisticsValueCollection.AddStatisticsValue("Total Dyeing Time", val, " hours");
StatisticsValueCollection.AddStatisticsValue("Average Dyeing Time", Math.Max(TimeSpan.FromMilliseconds(average).TotalHours, 0), " hours");
}
/// <summary>
/// Generates the average upload duration of the job runs.
/// </summary>
protected void GenerateAverageUploadDuration()
{
var average = (long)JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.UploadDuration != null).Average(x => x.UploadDuration.Value.TotalMilliseconds);
StatisticsValueCollection.AddStatisticsValue("Average Upload Duration", Math.Max(TimeSpan.FromMilliseconds(average).TotalMinutes, 0), " minutes");
}
/// <summary>
/// Generates the average duration heating of the job runs.
/// </summary>
protected void GenerateAverageHeatingDuration()
{
var average = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.HeatingDuration != null && z.HeatingDuration.Value.Ticks > 0).Average(x => x.HeatingDuration.Value.TotalMilliseconds);
StatisticsValueCollection.AddStatisticsValue("Average Heating Duration", Math.Max(TimeSpan.FromMilliseconds(average).TotalMinutes, 0), " minutes");
}
/// <summary>
/// Generates the total thread consumption by EndPosition.
/// </summary>
protected void GenerateTotalThreadConsumption()
{
double val = JobRuns.Where(z => z.JobRun.EndPosition > 0).Sum(x => x.JobRun.EndPosition);
StatisticsValueCollection.AddStatisticsValue("Total Dyeing Length", val, " m");
}
/// <summary>
/// Generates the pie charts in percentage: JobSource, JobRunStatus, Gradient.
/// </summary>
protected void GeneratePieCharts()
{
int PPCCount = JobRuns.Count(x => x.JobRun.Source == JobSource.Local);
int MSCount = JobRuns.Count(x => x.JobRun.Source == JobSource.Remote);
StatisticsValueCollection.GeneratePieJobSource(PPCCount, MSCount);
int failedCount = JobRuns.Count(x => x.JobRun.JobRunStatus == JobRunStatus.Failed);
int abortedCount = JobRuns.Count(x => x.JobRun.JobRunStatus == JobRunStatus.Aborted);
int completedCount = JobRuns.Count(x => x.JobRun.JobRunStatus == JobRunStatus.Completed);
StatisticsValueCollection.GeneratePieJobRunStatus(failedCount, abortedCount, completedCount);
int gradientCount = JobRuns.Count(x => x.JobRun.IsGradient == true);
int solidCount = JobRuns.Count(x => x.JobRun.IsGradient == false);
StatisticsValueCollection.GeneratePieGradientSolid(gradientCount, solidCount);
}
/// <summary>
/// Creates the thread consumption per thread.
/// </summary>
protected void CreateThreadConsumptionPerThread()
{
var temp = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.Rml != null).GroupBy(x => x.Rml.Name);
List<StatisticsValue> result = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.Rml != null && !String.IsNullOrEmpty(z.Rml.Name)).GroupBy(x => x.Rml.Name).Select(y => new StatisticsValue { Name = y.Key, Value = y.Sum(x => x.JobRun.EndPosition), Unit = "m" }).ToList();
StatisticsValueCollection.CreateThreadConsumptionPerThread(result);
}
/// <summary>
/// Generates all liquid quantities.
/// </summary>
protected void GenerateAllLiquidQuantities()
{
var runs = JobRuns.Where(z => z.JobRun.EndPosition > 0 && z.JobRun.LiquidQuantitiesFast.Count > 0).ToList();
Dictionary<LiquidTypes, ulong> total_quantities = new Dictionary<LiquidTypes, ulong>();
foreach (LiquidTypes ltype in (LiquidTypes[])Enum.GetValues(typeof(LiquidTypes)))
{
total_quantities[ltype] = 0;
}
foreach (var run in runs)
{
foreach (var lq in run.JobRun.LiquidQuantitiesFast)
{
if (lq.Quantity < 0)
{
Debug.WriteLine($"Warning: JobRun '{run.JobRun.ID}' contains an invalid value '{lq.Quantity}' for {lq.LiquidType} quantity.");
}
total_quantities[lq.LiquidType] += Convert.ToUInt64(Math.Max(lq.Quantity, 0));
}
}
List<TotalLiquidQuantityModel> allLiquidQuantities = total_quantities.Select(x => new TotalLiquidQuantityModel()
{
LiquidType = x.Key,
Quantity = x.Value
}).ToList();
//foreach (LiquidTypes ltype in (LiquidTypes[])Enum.GetValues(typeof(LiquidTypes)))
//{
// var liquidQuantityByTypeList = db_liquidQuantities.Select(x => x.FirstOrDefault(y => y.LiquidType == ltype)).Where(x => x != null);
// var count = liquidQuantityByTypeList != null ? liquidQuantityByTypeList.Sum(x => x.Quantity) : 0;
// JobRunLiquidQuantity lq = new JobRunLiquidQuantity() { LiquidType = ltype, Quantity = count };
// allLiquidQuantities.Add(lq);
//}
StatisticsValueCollection.GenerateStatisticsLiquidQuantity(allLiquidQuantities);
}
#endregion
}
}
|
