using System; using System.Collections.Generic; using System.Linq; using InABox.Clients; using System.Diagnostics.CodeAnalysis; namespace InABox.Core { public interface IDigitalFormReportDataModel { public DigitalFormVariable[]? Variables { get; set; } } /// /// /// /// Should always be an EntityForm<,> public class DigitalFormReportDataModel : AutoDataModel, IDigitalFormReportDataModel where T : Entity, IRemotable, IPersistent, IDigitalFormInstance, new() { private Guid? FormId { get; set; } = null; private CoreTable? FormDataTable { get; set; } = null; //private DigitalFormVariable[]? _variables = null; public DigitalFormVariable[]? Variables { get; set; } public DigitalFormReportDataModel(Filter filter, Guid? formId = null) : base(filter) { FormId = formId; } public override string Name => "Digital Form Reports"; protected override void CheckRequiredTables(List requiredtables) { base.CheckRequiredTables(requiredtables); requiredtables.Add(TableName()); } private void LoadFormDataTable(Guid formID) { var formDataTable = new CoreTable(); formDataTable.Columns.Add(new CoreColumn { ColumnName = "Parent.ID", DataType = typeof(Guid) }); Variables ??= new Client().Load(new Filter(x => x.Form.ID).IsEqualTo(formID)); foreach (var variable in Variables) foreach (var column in variable.GetDisplayColumns()) formDataTable.Columns.Add(column); FormDataTable = formDataTable; AddTable("Form_Data", formDataTable, true); LinkTable(typeof(T), "ID", "Form_Data", "Parent.ID"); } private void LoadFormDataIntoRow(CoreRow row, DFLoadStorage data) { foreach(var variable in Variables!) { var value = variable.Deserialize(data.GetEntry(variable.Code)); foreach(var (k, v) in variable.GetDisplayValues(value)) { row[k] = v; } } } protected override void AfterLoad(IEnumerable requiredtables) { base.AfterLoad(requiredtables); if(FormDataTable == null) { LoadFormDataTable(FormId ?? ExtractValues(x => x.Form.ID).FirstOrDefault()); } var idList = ExtractValues(x => x.ID); var jsonLists = ExtractValues(x => x.FormData, false).ToList(); var blobLists = ExtractValues(x => x.BlobData, false).ToList(); for(var i = 0; i < jsonLists.Count; ++i) { var json = jsonLists[i]; var blobJSON = blobLists[i]; var formData = DigitalForm.DeserializeFormData(json, blobJSON); var formRow = FormDataTable!.NewRow(); formRow["Parent.ID"] = idList[i]; if (formData != null) LoadFormDataIntoRow(formRow, formData); FormDataTable.Rows.Add(formRow); } Load(typeof(CoreTable), FormDataTable!, requiredtables, "Form_Data"); } } }