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");
}
}
}