prs/prs.mobile/comal.timesheets/Site/JobDocViewer.xaml.cs

using comal.timesheets.CustomControls;
using comal.timesheets.Data_Classes;
using Comal.Classes;
using InABox.Clients;
using InABox.Core;
using Syncfusion.TreeView.Engine;
using Syncfusion.XForms.PopupLayout;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.ComponentModel;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;
using Xamarin.Essentials;
using Xamarin.Forms;
using Xamarin.Forms.Xaml;
using XF.Material.Forms.UI.Dialogs;
using PRSSecurity = InABox.Core.Security;

namespace comal.timesheets
{
    public delegate void OnFolderListChanged();
    [XamlCompilation(XamlCompilationOptions.Compile)]
    public partial class JobDocViewer : ContentPage
    {
        #region Fields and Constructor / Navigation
        ObservableCollection<FolderViewItem> folderList = new ObservableCollection<FolderViewItem>();
        ObservableCollection<FolderViewItem> displayList = new ObservableCollection<FolderViewItem>();
        DeviceIdiom idiom;
        bool foldersLoaded = false;
        bool filesLoaded = false;
        bool specificQueryLoading = false;
        Guid jobID = Guid.Empty;
        List<Guid> loadedFolders = new List<Guid>();
        List<MileStoneShell> mileStoneShells = new List<MileStoneShell>();
        List<JobDocSetFileShell> fullListShells = new List<JobDocSetFileShell>();
        List<JobDocSetFileShell> filteredShells = new List<JobDocSetFileShell>();
        List<JobDocSetFileShell> searchList = new List<JobDocSetFileShell>();
        List<MileStoneShell> specificQueryMileStones = new List<MileStoneShell>();
        List<JobDocSetFileShell> specificQueryFileShells = new List<JobDocSetFileShell>();
        List<JobDocSetFileShell> currentQueryFileShells = new List<JobDocSetFileShell>();
        public JobDocViewer(Job job)
        {
            InitializeComponent();
            NavigationPage.SetHasBackButton(this, false);
            titleLbl.Text = "Job " + job.JobNumber;
            treeView.QueryNodeSize += TreeView_QueryNodeSize;
            idiom = DeviceInfo.Idiom;
            if (Device.RuntimePlatform.Equals(Device.iOS))
            {
                expandImg.HeightRequest = 50;
                expandImg.WidthRequest = 50;
                collapseImg.HeightRequest = 50;
                collapseImg.WidthRequest = 50;
            }
            jobID = job.ID;
            LoadFiles(new Filter<JobDocumentSetMileStone>(x => x.DocumentSet.Job.ID).IsEqualTo(jobID));
            LoadFolders(jobID);
        }
        void ExitBtn_Clicked(object sender, EventArgs e)
        {
            Navigation.PopAsync();
        }

        private void FilterButton_Tapped(object sender, EventArgs e)
        {
            var page = new JobDocsFilterPage(jobID);
            page.OnJobDocFiltersPicked += Page_OnJobDocFiltersPicked;
            Navigation.PushAsync(page);
        }

        private void Page_OnJobDocFiltersPicked(string discipline, string type, string category, string area)
        {
            filterLayout.Children.Clear();

            if (!string.IsNullOrWhiteSpace(discipline))
                AddFilter(discipline, JobDocFilterType.Discipline);
            if (!string.IsNullOrWhiteSpace(type))
                AddFilter(type, JobDocFilterType.Type);
            if (!string.IsNullOrWhiteSpace(discipline))
                AddFilter(category, JobDocFilterType.Category);
            if (!string.IsNullOrWhiteSpace(area))
                AddFilter(area, JobDocFilterType.Area);
        }

        private void AddFilter(string text, JobDocFilterType type)
        {
            JobDocFilterItem item = new JobDocFilterItem();
            item.Init(text, type);
            item.OnJobDocFilterClosed += ((filter, type) => 
            {
                filterLayout.Children.Remove(item);
            });
            filterLayout.Children.Add(item);
        }
        #endregion

        #region TreeView / Folder Interaction
        void Folder_Tapped(object sender, EventArgs e)
        {
            var folder = treeView.SelectedItem as FolderViewItem;
            if (folder.Documents == 0)
                return;

            if (specificQueryLoading)
                return;

            if (filesLoaded)
            {
                if (folder.ItemName == "All")
                {
                    AddSearchItems(fullListShells);
                }
                else
                {
                    var list = fullListShells.Where(x => x.FolderID == folder.ID);
                    AddSearchItems(list);
                }
            }
            else if (loadedFolders.Contains(folder.ID))
            {
                var list = specificQueryFileShells.Where(x => x.FolderID == folder.ID);
                AddSearchItems(list);
            }
            else
                LoadFilesForFolder(folder.ID);
        }
        private async void LoadFilesForFolder(Guid folderID)
        {
            currentQueryFileShells.Clear();
            specificQueryLoading = true;
            ShowLoading();
            LoadFiles(new Filter<JobDocumentSetMileStone>(x => x.DocumentSet.Folder.ID).IsEqualTo(folderID), true, folderID);
        }
        void Expand_Tapped(object sender, EventArgs e)
        {
            if (!foldersLoaded)
                return;

            treeViewFrame.HeightRequest = 28 * folderList.Count;
            expandImg.IsVisible = false;
            collapseImg.IsVisible = true;
        }
        void Collapse_Tapped(object sender, EventArgs e)
        {
            treeViewFrame.HeightRequest = 120;
            expandImg.IsVisible = true;
            collapseImg.IsVisible = false;
        }
        #endregion

        #region Searching
        private void SearchEnt_Changed(object sender, EventArgs e)
        {
            if (specificQueryLoading)
                return;
            RunSearch();
        }

        private void AddSearchItems(IEnumerable<JobDocSetFileShell> list)
        {
            searchList.Clear();
            foreach (var v in list)
            {
                searchList.Add(v);
            }
            RunSearch();
        }

        private void RunSearch()
        {
            Device.BeginInvokeOnMainThread(() =>
            {
                listView.ItemsSource = null;
                if (string.IsNullOrWhiteSpace(searchEnt.Text))
                {
                    listView.ItemsSource = searchList;
                    fileCountLbl.Text = "Files (" + searchList.Count() + ")";
                }
                else
                {
                    var list = searchList.Where
                        (
                        x =>
                        x.FileName.Contains(searchEnt.Text) || x.FileName.Contains(searchEnt.Text.ToLower()) ||
                        x.FileName.Contains(searchEnt.Text.ToUpper()) || x.FileName.Contains(SearchUtils.UpperCaseFirst(searchEnt.Text)) ||
                        x.DocSetDescription.Contains(searchEnt.Text) || x.DocSetDescription.Contains(searchEnt.Text.ToLower()) ||
                        x.DocSetDescription.Contains(searchEnt.Text.ToUpper()) || x.DocSetDescription.Contains(SearchUtils.UpperCaseFirst(searchEnt.Text)) ||
                        x.Issued.Contains(searchEnt.Text) || x.Issued.Contains(searchEnt.Text.ToLower()) ||
                        x.Issued.Contains(searchEnt.Text.ToUpper()) || x.Issued.Contains(SearchUtils.UpperCaseFirst(searchEnt.Text)) ||
                        x.TrimmedIssued.Contains(searchEnt.Text) || x.TrimmedIssued.Contains(searchEnt.Text.ToLower()) ||
                        x.TrimmedIssued.Contains(searchEnt.Text.ToUpper()) || x.TrimmedIssued.Contains(SearchUtils.UpperCaseFirst(searchEnt.Text)) ||
                        x.TrimmedIssued.Contains(SearchUtils.UpperCaseSecond(searchEnt.Text)) || x.TrimmedIssued.Contains(SearchUtils.UpperCaseThird(searchEnt.Text)) || x.TrimmedIssued.Contains(SearchUtils.UpperCaseFourth(searchEnt.Text))
                        );
                    listView.ItemsSource = list;
                    fileCountLbl.Text = "Files (" + list.Count() + ")";
                }
            });
        }
        #endregion

        #region Loading
        private void TreeView_QueryNodeSize(object sender, Syncfusion.XForms.TreeView.QueryNodeSizeEventArgs e)
        {
            e.Height = e.GetActualNodeHeight();
            e.Handled = true;
        }

        private void LoadFolders(Guid jobid)
        {
            CoreTable table = new Client<JobDocumentSetFolder>().Query(new Filter<JobDocumentSetFolder>(x => x.Job.ID).IsEqualTo(jobid),
                new Columns<JobDocumentSetFolder>(x => x.ID, x => x.Parent.ID, x => x.Name, x => x.Documents));
            foreach (CoreRow row in table.Rows)
            {
                FolderViewItem folderItem = new FolderViewItem
                {
                    ID = row.Get<Guid>("ID"),
                    ParentID = row.Get<Guid>("Parent.ID"),
                    ItemName = row.Get<string>("Name"),
                    Documents = row.Get<int>("Documents")
                };
                folderList.Add(folderItem);
            }
            foreach (var folder in folderList)
            {
                folder.List = folderList;
                if (folder.ParentID == Guid.Empty || folder.ParentID == CoreUtils.FullGuid)
                    displayList.Add(folder);
            }
            displayList = new ObservableCollection<FolderViewItem>(displayList.OrderBy(x => x.ItemName));
            treeView.ItemsSource = displayList;
            foldersLoaded = true;
        }

        private async void LoadFiles(Filter<JobDocumentSetMileStone> filter, bool specificQuery = false, Guid loadFolder = new Guid())
        {
            await Task.Run(() =>
            {
                try
                {
                    filter = filter.And(x => x.Status).IsEqualTo(JobDocumentSetMileStoneStatus.Approved)
                                .And(x => x.Type.SiteVisible).IsEqualTo(true);
                    CoreTable milestones = new Client<JobDocumentSetMileStone>().Query(filter,
                                new Columns<JobDocumentSetMileStone>(
                                x => x.ID,
                                x => x.DocumentSet.Folder.Name,
                                x => x.DocumentSet.Folder.ID,
                                x => x.DocumentSet.Type.Description,
                                x => x.DocumentSet.Category.Description,
                                x => x.DocumentSet.Discipline.Description,
                                x => x.DocumentSet.Area.Description,
                                x => x.Submitted,
                                x => x.Employee.Name,
                                x => x.Type.Description,
                                x => x.DocumentSet.Description
                                )
                                );
                    if (milestones.Rows.Any())
                    {
                        var table = QueryFiles(milestones, specificQuery);
                        if (table.Rows.Any())
                        {
                            foreach (CoreRow filerow in table.Rows)
                            {
                                AddFileShell(filerow, specificQuery);
                            }
                            Device.BeginInvokeOnMainThread(() =>
                            {
                                if (specificQuery)
                                {
                                    ShowFiles();
                                    specificQueryLoading = false;
                                    loadedFolders.Add(loadFolder);
                                    AddSearchItems(currentQueryFileShells);
                                }
                                else
                                {
                                    filesLoaded = true;
                                    displayList.Insert(0, new FolderViewItem { ItemName = "All", Documents = fullListShells.Count });
                                    folderList.Insert(0, new FolderViewItem { ItemName = "All", Documents = fullListShells.Count });
                                    treeView.ItemsSource = null;
                                    treeView.ItemsSource = displayList;
                                }
                            });
                        }
                    }
                    else
                    {
                        specificQueryLoading = false;
                        ShowFiles();
                    }
                }
                catch
                {
                    specificQueryLoading = false;
                    ShowFiles();
                }
            });
        }

        private CoreTable QueryFiles(CoreTable milestones, bool specificQuery = false)
        {
            Filter<JobDocumentSetMileStoneFile> filter = new Filter<JobDocumentSetMileStoneFile>(x => x.EntityLink.ID).IsEqualTo(milestones.Rows.FirstOrDefault().Get<Guid>("ID"));
            foreach (CoreRow milestonerow in milestones.Rows)
            {
                Guid id = AddMileStoneShell(milestonerow, specificQuery);
                filter = filter.Or(x => x.EntityLink.ID).IsEqualTo(milestonerow.Get<Guid>("ID"));
            }
            CoreTable table = new Client<JobDocumentSetMileStoneFile>().Query(
                filter,
                new Columns<JobDocumentSetMileStoneFile>(
                    x => x.DocumentLink.ID,
                    x => x.Thumbnail,
                    x => x.DocumentLink.FileName,
                    x => x.EntityLink.ID
                  ));
            return table;
        }

        private Guid AddMileStoneShell(CoreRow milestonerow, bool specificQuery = false)
        {
            Guid id = milestonerow.Get<Guid>("ID");
            MileStoneShell shell = new MileStoneShell
            {
                ID = milestonerow.Get<Guid>("ID"),
                FolderName = milestonerow.Get<JobDocumentSetMileStone, string>(x => x.DocumentSet.Folder.Name),
                FolderID = milestonerow.Get<JobDocumentSetMileStone, Guid>(x => x.DocumentSet.Folder.ID),
                EmployeeName = milestonerow.Get<JobDocumentSetMileStone, string>(x => x.Employee.Name),
                Type = milestonerow.Get<JobDocumentSetMileStone, string>(x => x.Type.Description),
                DocSetDescription = milestonerow.Get<JobDocumentSetMileStone, string>(x => x.DocumentSet.Description),
                Issued = "Submitted: " + milestonerow.Get<JobDocumentSetMileStone, DateTime>(x => x.Submitted).ToString("dd MMM yy"),
                DocSetType = milestonerow.Get<JobDocumentSetMileStone, string>(x => x.DocumentSet.Type.Description),
                DocSetCategory = milestonerow.Get<JobDocumentSetMileStone, string>(x => x.DocumentSet.Category.Description),
                DocSetDiscipline = milestonerow.Get<JobDocumentSetMileStone, string>(x => x.DocumentSet.Discipline.Description),
            };
            if (specificQuery)
                specificQueryMileStones.Add(shell);
            else
                mileStoneShells.Add(shell);
            return id;
        }

        private void AddFileShell(CoreRow filerow, bool specificQuery = false)
        {
            JobDocSetFileShell file = new JobDocSetFileShell
            {
                DocLinkID = filerow.Get<Guid>("DocumentLink.ID"),
                FileName = filerow.Get<string>("DocumentLink.FileName"),
                MileStoneID = filerow.Get<Guid>("EntityLink.ID")
            };

            MileStoneShell mileStone = mileStoneShells.Find(x => x.ID == file.MileStoneID);
            file.FolderName = mileStone.FolderName;
            file.FolderID = mileStone.FolderID;
            file.EmployeeName = mileStone.EmployeeName;
            file.Type = mileStone.Type;
            file.DocSetDescription = mileStone.DocSetDescription;
            file.Issued = mileStone.Issued;
            file.DocSetCategory = mileStone.DocSetCategory;
            file.DocSetType = mileStone.DocSetType;
            file.DocSetDiscipline = mileStone.DocSetDiscipline;

            file.TrimmedIssued = TrimWhiteSpace(file.Issued);

            byte[] data = filerow.Get<byte[]>("Thumbnail");

            if (data != null)
            {
                file.ImageSource = ImageSource.FromStream(() => new MemoryStream(data));
                if (idiom == DeviceIdiom.Tablet)
                {
                    file.HeightRequest = 400;
                    file.WidthRequest = 500;
                }
                file.Thumbnail = data;
            }
            if (specificQuery)
            {
                specificQueryFileShells.Add(file);
                currentQueryFileShells.Add(file);
            }
            else
                fullListShells.Add(file);
        }

        private void ShowFiles()
        {
            Device.BeginInvokeOnMainThread(() =>
            {
                treeView.IsEnabled = true;

                loadingLayout.IsVisible = false;
                loadingColumn.Width = 0;

                filesLayout.IsVisible = true;
                filesColumn.Width = new GridLength(1, GridUnitType.Star);
            });
        }

        private void ShowLoading()
        {
            Device.BeginInvokeOnMainThread(async () =>
            {
                treeView.IsEnabled = false;

                filesLayout.IsVisible = false;
                filesColumn.Width = 0;

                loadingLayout.IsVisible = true;
                loadingColumn.Width = new GridLength(1, GridUnitType.Star);

                Random random = new Random();
                uint number = (uint)random.Next(500, 3000);
                await loadingLbl.TranslateTo(0, 15, 500);
                await loadingLbl.TranslateTo(0, 0, 500);
                loadingLbl.RotateTo(360, number);

                await loadingLbl.TranslateTo(0, 15, 500);
                await loadingLbl.TranslateTo(0, 0, 500);

                await loadingLbl.TranslateTo(0, 15, 500);
                await loadingLbl.TranslateTo(0, 0, 500);
                await loadingLbl.TranslateTo(0, 15, 500);
                number = (uint)random.Next(500, 3000);
                await loadingLbl.TranslateTo(0, 0, 500);
                loadingLbl.RotateTo(360, number);
            });
        }

        static string TrimWhiteSpace(string s)
        {
            s = String.Concat(s.Where(c => !Char.IsWhiteSpace(c)));
            return s;
        }
        #endregion

        #region ListView Interaction
        void List_Tapped(object sender, EventArgs e)
        {
            var shell = listView.SelectedItem as JobDocSetFileShell;
            if (Device.RuntimePlatform.Equals(Device.Android) && PRSSecurity.IsAllowed<CanOpenMobileNativePDFViewer>())
                OpenNativeViewer(shell.DocLinkID);
            else
            {
                PDFViewer viewer = new PDFViewer(shell.DocLinkID);
                Navigation.PushAsync(viewer);
            }
        }

        private async void OpenNativeViewer(Guid docID)
        {
            CoreTable table = new Client<Document>().Query(new Filter<Document>(x => x.ID).IsEqualTo(docID),
            new Columns<Document>(x => x.Data, x => x.FileName));
            Document doc = table.Rows.First().ToObject<Document>();

            var filePath = Path.Combine(FileSystem.AppDataDirectory, doc.FileName);

            File.WriteAllBytes(filePath, doc.Data);

            await Launcher.OpenAsync(new OpenFileRequest
            {
                File = new ReadOnlyFile(filePath)
            });
        }

        void Image_Tapped(object sender, EventArgs e)
        {
            var shell = ((TappedEventArgs)e).Parameter as JobDocSetFileShell;
            if (shell == null)
                return;

            if (shell.Thumbnail != null)
            {
                Image popupContent = new Image();
                popupContent.HeightRequest = 500;
                popupContent.WidthRequest = 600;
                popupContent.HorizontalOptions = LayoutOptions.FillAndExpand;
                popupContent.VerticalOptions = LayoutOptions.FillAndExpand;
                popupContent.Aspect = Aspect.AspectFit;
                popupContent.Source = ImageSource.FromStream(() => new MemoryStream(shell.Thumbnail));
                popupLayout.PopupView.ShowHeader = false;
                popupLayout.PopupView.ShowFooter = false;
                popupLayout.PopupView.ContentTemplate = new DataTemplate(() =>
                {
                    return popupContent;
                });
                popupLayout.Show();
            }
        }
        #endregion
    }

    #region Classes
    public class FolderViewItem : INotifyPropertyChanged
    {
        public event OnFolderListChanged OnFolderListChanged;
        public event PropertyChangedEventHandler PropertyChanged;
        public Guid ID { get; set; }
        public Guid ParentID { get; set; }
        public ImageSource ImageIcon { get; set; }
        private ObservableCollection<FolderViewItem> list;
        public ObservableCollection<FolderViewItem> List
        {
            get
            {
                return list;
            }
            set
            {
                list = value;
                OnFolderListChanged?.Invoke();
            }
        }
        private string itemName;
        public string ItemName
        {
            get { return itemName; }
            set
            {
                itemName = value;
                RaisedOnPropertyChanged("ItemName");
            }
        }
        public int Documents { get; set; }
        public ObservableCollection<FolderViewItem> SubFiles { get; set; }

        public Guid DocID { get; set; }
        public FolderViewItem()
        {
            ID = Guid.Empty;
            ItemName = "";
            ImageIcon = "folder.png";
            DocID = Guid.Empty;
            ParentID = Guid.Empty;
            OnFolderListChanged += FolderViewItem_OnFolderListChanged;
            Documents = 0;
        }

        private void FolderViewItem_OnFolderListChanged()
        {
            GetChildren();
        }

        public void RaisedOnPropertyChanged(string _PropertyName)
        {
            if (PropertyChanged != null)
            {
                PropertyChanged(this, new PropertyChangedEventArgs(_PropertyName));
            }
        }

        private void GetChildren()
        {
            SubFiles = new ObservableCollection<FolderViewItem>(list.Where(x => x.ParentID.Equals(ID)));
        }
    }

    public class MileStoneShell
    {
        public Guid ID { get; set; }
        public string FolderName { get; set; }
        public Guid FolderID { get; set; }
        public string EmployeeName { get; set; }
        public string Type { get; set; }
        public string DocSetDescription { get; set; }
        public string Issued { get; set; }
        public string DocSetType { get; set; }
        public string DocSetDiscipline { get; set; }
        public string DocSetCategory { get; set; }
        public string DocSetArea { get; set; }
        public MileStoneShell()
        {
            ID = Guid.Empty;
            FolderID = Guid.Empty;
            FolderName = "";
            EmployeeName = "";
            Type = "";
            DocSetDescription = "";
            Issued = "";
            DocSetCategory = "";
            DocSetDiscipline = "";
            DocSetType = "";
            DocSetArea = "";
        }
    }

    public class JobDocSetFileShell
    {
        public Guid DocLinkID { get; set; }
        public string FileName { get; set; }
        public string FolderName { get; set; }
        public Guid FolderID { get; set; }
        public string EmployeeName { get; set; }
        public string Type { get; set; }
        public string DocSetDescription { get; set; }
        public string Issued { get; set; }
        public string TrimmedIssued { get; set; }
        public ImageSource ImageSource { get; set; }
        public double HeightRequest { get; set; }
        public double WidthRequest { get; set; }
        public byte[] Thumbnail { get; set; }
        public Guid MileStoneID { get; set; }
        public string DocSetType { get; set; }
        public string DocSetDiscipline { get; set; }
        public string DocSetCategory { get; set; }
        public string DocSetArea { get; set; }

        public JobDocSetFileShell()
        {
            DocLinkID = Guid.Empty;
            FileName = "";
            FolderName = "";
            EmployeeName = "";
            Type = "";
            DocSetDescription = "";
            ImageSource = null;
            Issued = "";
            TrimmedIssued = "";
            HeightRequest = 150;
            WidthRequest = 200;
            Thumbnail = null;
            MileStoneID = Guid.Empty;
            FolderID = Guid.Empty;
            DocSetCategory = "";
            DocSetDiscipline = "";
            DocSetType = "";
            DocSetArea = "";
        }
    }

    public enum JobDocFilterType
    {
        Discipline,
        Type,
        Category,
        Area
    }
    #endregion
}