prs/prs.desktop/Dashboards/ManufacturingTemplateAnalysis.xaml.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text.RegularExpressions;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Input;
using Comal.Classes;
using InABox.Clients;
using InABox.Core;
using InABox.WPF;
using PRSDesktop.WidgetGroups;
using Syncfusion.UI.Xaml.Grid;
using Syncfusion.UI.Xaml.Grid.Cells;
using SelectionChangedEventArgs = System.Windows.Controls.SelectionChangedEventArgs;

namespace PRSDesktop
{
    public class ManufacturingTemplateAnalysisProperties : IDashboardProperties { }

    public class ManufacturingTemplateAnalysisElement : DashboardElement<ManufacturingTemplateAnalysis, Manufacturing, ManufacturingTemplateAnalysisProperties> { }

    /// <summary>
    ///     Interaction logic for ManufacturingTemplateAnalysis.xaml
    /// </summary>
    public partial class ManufacturingTemplateAnalysis : UserControl, IPanel<ManufacturingTemplate>, IDashboardWidget<Manufacturing, ManufacturingTemplateAnalysisProperties>
    {
        private bool _activeonly;

        private DateTime _from;
        private string _search = "";
        private DateTime _to;
        private DataTable data;
        private readonly Dictionary<string, string> SectionDisplayNames = new() { { "Total", "Total" } };

        private ManufacturingSection[] sections;
        private ManufacturingTemplateStage[] stages;
        private ManufacturingTemplate[] templates;

        public ManufacturingTemplateAnalysis()
        {
            _from = DateTime.Today.AddDays(0 - WeekDay(DateTime.Today));
            _to = DateTime.Today;

            _activeonly = true;

            InitializeComponent();
            dataGrid.CellRenderers.Remove("StackedHeader");
            dataGrid.CellRenderers.Add("StackedHeader", new GridCustomStackedRenderer(Resources));
        }

        public bool IsReady { get; set; }

        public void CreateToolbarButtons(IPanelHost host)
        {
        }

        public string SectionName => "Manufacturing Template Analysis";

        public ManufacturingTemplateAnalysisProperties Properties { get; set; }

        public DataModel DataModel(Selection selection)
        {
            return new AutoDataModel<ManufacturingTemplate>(null);
        }

        public void Refresh()
        {
            using (new WaitCursor())
            {
                Progress.Show("Loading Data");

                data.Rows.Clear();

                templates = new Client<ManufacturingTemplate>().Load(
                    new Filter<ManufacturingTemplate>(x => x.ID).IsNotEqualTo(Guid.Empty).TextSearch(_search, x => x.Code, x => x.Name),
                    new SortOrder<ManufacturingTemplate>(x => x.Code)
                );

                var packets = new Client<ManufacturingPacket>().Query(
                    new Filter<ManufacturingPacket>(x => x.Completed).IsGreaterThanOrEqualTo(_from).And(x => x.Completed).IsLessThan(_to.AddDays(1)),
                    new Columns<ManufacturingPacket>
                    (
                        x => x.ID,
                        x => x.ManufacturingTemplateLink.ID,
                        x => x.Quantity
                    )
                );

                var history = new Client<ManufacturingHistory>().Query(
                    new Filter<ManufacturingHistory>(x => x.Packet.Completed).IsGreaterThanOrEqualTo(_from).And(x => x.Packet.Completed)
                        .IsLessThan(_to.AddDays(1)),
                    new Columns<ManufacturingHistory>
                    (
                        x => x.Packet.ID,
                        x => x.Section.ID,
                        x => x.QADuration,
                        x => x.WorkDuration
                    )
                );

                foreach (var template in templates)
                {
                    Progress.SetMessage(string.Format("Processing {0}: {1}", template.Code, template.Name));

                    var values = new List<object>();
                    values.Add(template.Code);
                    values.Add(template.Name);

                    var times = new Dictionary<Guid, long>();
                    foreach (var section in sections)
                        times[section.ID] = 0L;

                    var qty = 0;
                    var pktrows = packets.Rows.Where(r => r.Get<ManufacturingPacket, Guid>(c => c.ManufacturingTemplateLink.ID).Equals(template.ID));
                    foreach (var pktrow in pktrows)
                    {
                        var thisqty = pktrow.Get<ManufacturingPacket, int>(x => x.Quantity);
                        if (thisqty > 0)
                        {
                            qty += thisqty;
                            foreach (var section in sections)
                                if (stages.Any(x => x.Template.ID.Equals(template.ID) && x.Section.ID.Equals(section.ID)))
                                {
                                    var pktid = pktrow.Get<ManufacturingPacket, Guid>(c => c.ID);
                                    var histrows = history.Rows.Where(r =>
                                        r.Get<ManufacturingHistory, Guid>(c => c.Section.ID).Equals(section.ID) &&
                                        r.Get<ManufacturingHistory, Guid>(c => c.Packet.ID).Equals(pktid));
                                    foreach (var histrow in histrows)
                                        times[section.ID] += histrow.Get<ManufacturingHistory, TimeSpan>(c => c.QADuration).Ticks +
                                                             histrow.Get<ManufacturingHistory, TimeSpan>(c => c.WorkDuration).Ticks;
                                }
                        }
                    }

                    if (qty > 0)
                        values.Add(qty);
                    else
                        values.Add(null);

                    var total = 0L;
                    foreach (var section in sections)
                    {
                        total += times[section.ID];
                        if (qty > 0 && times[section.ID] > 0)
                            values.Add(Math.Truncate(new TimeSpan(times[section.ID] / qty).TotalHours * 100.0F) / 100.0F);
                        else
                            values.Add(null);
                    }

                    if (qty > 0 && total > 0)
                        values.Add(Math.Truncate(new TimeSpan(total / qty).TotalHours * 100.0F) / 100.0F);
                    else
                        values.Add(null);

                    if (!_activeonly || qty > 0)
                        data.Rows.Add(values.ToArray());
                }

                Progress.Close();
            }
        }

        public Dictionary<string, object[]> Selected()
        {
            return new Dictionary<string, object[]>();
        }

        public void Setup()
        {
            FromDate.SelectedDate = _from;
            ToDate.SelectedDate = _to;

            dataGrid.ScrollMode = ScrollMode.Async;

            sections = new Client<ManufacturingSection>().Load(
                new Filter<ManufacturingSection>(x => x.Hidden).IsEqualTo(false),
                new SortOrder<ManufacturingSection>(x => x.Factory.Sequence).ThenBy(x => x.Sequence)
            );

            stages = new Client<ManufacturingTemplateStage>().Load();

            data = new DataTable();
            data.Columns.Add("Code", typeof(string));
            data.Columns.Add("Description", typeof(string));
            data.Columns.Add("Qty", typeof(int));

            var columns = new Dictionary<string, List<string>>();

            foreach (var section in sections)
            {
                if (!columns.ContainsKey(section.Factory.Name))
                    columns[section.Factory.Name] = new List<string>();

                var columnname = string.Format("{0}:{1}", section.Factory.Name, Regex.Replace(section.Name, "[^a-zA-Z0-9]", string.Empty));
                columns[section.Factory.Name].Add(columnname);
                data.Columns.Add(columnname, typeof(double));
                SectionDisplayNames[columnname] = section.Name;
            }

            data.Columns.Add("Total", typeof(double));

            dataGrid.ItemsSource = data;

            var stackedHeaderRow1 = new StackedHeaderRow();
            stackedHeaderRow1.StackedColumns.Add(new StackedColumn
                { ChildColumns = "Code,Description,Qty", HeaderText = "Template Details", MappingName = "TemplateDetails" });
            foreach (var key in columns.Keys)
                stackedHeaderRow1.StackedColumns.Add(new StackedColumn
                    { ChildColumns = string.Join(",", columns[key]), HeaderText = key, MappingName = key });
            stackedHeaderRow1.StackedColumns.Add(new StackedColumn { ChildColumns = "Total", HeaderText = "", MappingName = "Total" });
            dataGrid.StackedHeaderRows.Add(stackedHeaderRow1);
        }

        public void Shutdown()
        {
        }

        public void Heartbeat(TimeSpan time)
        {
        }

        private void DataGrid_AutoGeneratingColumn(object sender, AutoGeneratingColumnArgs e)
        {
            e.Column.TextAlignment = TextAlignment.Center;
            e.Column.HorizontalHeaderContentAlignment = HorizontalAlignment.Center;
            e.Column.ColumnSizer = GridLengthUnitType.None;

            var value = e.Column.ValueBinding as Binding;
            if (value.Path.Path.Equals("Code"))
            {
                e.Column.Width = 100;
                e.Column.HeaderStyle = Resources["TemplateHeaderStyle"] as Style;
            }
            else if (value.Path.Path.Equals("Description"))
            {
                e.Column.Width = 300;
                e.Column.HeaderStyle = Resources["TemplateHeaderStyle"] as Style;
            }
            else if (value.Path.Path.Equals("Qty"))
            {
                e.Column.Width = 60;
                e.Column.HeaderStyle = Resources["TemplateHeaderStyle"] as Style;
            }
            else
            {
                var style = new Style(typeof(GridCell));
                //style.Setters.Add(new Setter(GridCell.BackgroundProperty, new Binding(value.Path.Path) { Converter = new LeaveBackgroundConverter() { Colors = activityColors } }));
                //style.Setters.Add(new Setter(GridCell.ForegroundProperty, new Binding(value.Path.Path) { Converter = new LeaveForegroundConverter() }));
                //style.Setters.Add(new Setter(GridCell.FontStyleProperty, new Binding(value.Path.Path) { Converter = new LeaveFontStyleConverter() }));
                //style.Setters.Add(new Setter(GridCell.FontWeightProperty, new Binding(value.Path.Path) { Converter = new LeaveFontWeightConverter() }));
                e.Column.CellStyle = style;
                e.Column.Width = 50;
                e.Column.HeaderStyle = Resources["DataHeaderStyle"] as Style;
                e.Column.HeaderText = SectionDisplayNames[value.Path.Path];
            }
        }

        private void DataGrid_ContextMenuOpening(object sender, ContextMenuEventArgs e)
        {
        }

        private void DataGrid_QueryRowHeight(object sender, QueryRowHeightEventArgs e)
        {
            e.Height = e.RowIndex == 1 ? 150 : 30;
            e.Handled = true;
        }

        private void ActiveItems_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (IsReady && !_changing)
            {
                _activeonly = ActiveItems.SelectedIndex == 1;
                Refresh();
            }
        }

        private void Search_KeyUp(object sender, KeyEventArgs e)
        {
            if (string.IsNullOrWhiteSpace(Search.Text) || e.Key == Key.Return)
            {
                _search = Search.Text;
                Refresh();
            }
        }

        private void Export_Click(object sender, RoutedEventArgs e)
        {
        }

        private class GridCustomStackedRenderer : GridStackedHeaderCellRenderer
        {
            private readonly ResourceDictionary _resources;

            public GridCustomStackedRenderer(ResourceDictionary resources)
            {
                _resources = resources;
            }

            public override void OnInitializeEditElement(DataColumnBase dataColumn, GridStackedHeaderCellControl uiElement, object dataContext)
            {
                uiElement.Style = _resources["GroupHeaderStyle"] as Style;
                base.OnInitializeEditElement(dataColumn, uiElement, dataContext);
            }
        }

        #region Date Handling

        private bool _changing;

        public event DataModelUpdateEvent OnUpdateDataModel;

        private void SetDates(DateTime from, DateTime to, bool enable)
        {
            if (_changing)
                return;
            _changing = true;

            _from = from;
            FromDate.SelectedDate = from;
            FromDate.IsEnabled = enable;

            _to = to;
            ToDate.SelectedDate = to;
            ToDate.IsEnabled = enable;

            _changing = false;
            if (!enable)
                Refresh();
        }

        private int WeekDay(DateTime date)
        {
            if (date.DayOfWeek == DayOfWeek.Sunday)
                return 7;
            return (int)date.DayOfWeek - 1;
        }

        private void DateRange_SelectionChanged(object sender, SelectionChangedEventArgs e)
        {
            if (!IsReady)
                return;

            if (DateRange.SelectedIndex == 0) // Week To Date
                SetDates(DateTime.Today.AddDays(0 - WeekDay(DateTime.Today)), DateTime.Today, false);
            else if (DateRange.SelectedIndex == 1) // Last 7 Days
                SetDates(DateTime.Today.AddDays(-6), DateTime.Today, false);
            else if (DateRange.SelectedIndex == 2) // Month To Date
                SetDates(new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1), DateTime.Today, false);
            else if (DateRange.SelectedIndex == 3) // Last 30 days
                SetDates(DateTime.Today.AddDays(-29), DateTime.Today, false);
            else if (DateRange.SelectedIndex == 4) // Year To Date
                SetDates(new DateTime(DateTime.Today.Year, 1, 1), DateTime.Today, false);
            else if (DateRange.SelectedIndex == 5) // Last 12 Months
                SetDates(DateTime.Today.AddYears(-1).AddDays(1), DateTime.Today, false);
            else if (DateRange.SelectedIndex == 6) // Custom
                SetDates(FromDate.SelectedDate.Value, ToDate.SelectedDate.Value, true);
        }

        private void FromDate_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
        {
            if (IsReady && !_changing)
            {
                _from = FromDate.SelectedDate.Value.Date;
                Refresh();
            }
        }

        private void ToDate_SelectedDateChanged(object sender, SelectionChangedEventArgs e)
        {
            if (IsReady && !_changing)
            {
                _to = ToDate.SelectedDate.Value.Date;
                Refresh();
            }
        }

        #endregion
    }
}