public MenuModel HeaderMenu(IServiceProvider serviceProvider)
{
IWorkOrdersLocalizationService localizationService = serviceProvider
.GetService <IWorkOrdersLocalizationService>();
MenuModel result = new MenuModel();
result.LeftMenu.Add(new MenuItemModel()
{
Name = localizationService.GetString("WorkOrders"),
E2EId = "work-orders-pn",
Link = "",
Guards = new List <string>()
{
WorkOrdersClaims.AccessWorkOrdersPlugin
},
MenuItems = new List <MenuItemModel>()
{
new MenuItemModel()
{
Name = localizationService.GetString("Orders"),
E2EId = "work-orders-pn-orders",
Link = "/plugins/work-orders-pn/orders",
Position = 0,
}
}
});
return(result);
}
public async Task <OperationDataResult <WorkOrdersModel> > GetWorkOrdersAsync(WorkOrdersRequestModel pnRequestModel)
{
try
{
var core = await _coreService.GetCore();
var sites = await core.Advanced_SiteItemReadAll(false);
var workOrdersModel = new WorkOrdersModel();
var workOrdersQuery = _dbContext.WorkOrders
.Where(x => x.WorkflowState != Constants.WorkflowStates.Removed)
.AsQueryable();
// add serch
if (!string.IsNullOrEmpty(pnRequestModel.SearchString))
{
workOrdersQuery = workOrdersQuery.Where(x =>
x.Description.ToLower().Contains(pnRequestModel.SearchString.ToLower()) ||
x.DescriptionOfTaskDone.ToLower().Contains(pnRequestModel.SearchString.ToLower()));
}
// sort
if (!string.IsNullOrEmpty(pnRequestModel.Sort))
{
if (pnRequestModel.IsSortDsc)
{
workOrdersQuery = workOrdersQuery.CustomOrderByDescending(pnRequestModel.Sort);
}
else
{
workOrdersQuery = workOrdersQuery.CustomOrderBy(pnRequestModel.Sort);
}
}
else
{
workOrdersQuery = _dbContext.WorkOrders.OrderBy(x => x.Id);
}
// pagination
workOrdersQuery = workOrdersQuery
.Skip(pnRequestModel.Offset)
.Take(pnRequestModel.PageSize);
// add select
var workOrderList = await AddSelectToQuery(workOrdersQuery).Result.ToListAsync();
foreach (var workOrderModel in workOrderList)
{
workOrderModel.CreatedBy = sites
.Where(x => x.SiteUId == workOrderModel.CreatedByUserId)
.Select(x => x.SiteName)
.FirstOrDefault();
workOrderModel.DoneBy = sites
.Where(x => x.SiteUId == workOrderModel.DoneBySiteId)
.Select(x => x.SiteName)
.FirstOrDefault();
}
workOrdersModel.Total = await _dbContext.WorkOrders.CountAsync(x =>
x.WorkflowState != Constants.WorkflowStates.Removed);
workOrdersModel.WorkOrders = workOrderList;
return(new OperationDataResult <WorkOrdersModel>(true, workOrdersModel));
}
catch (Exception e)
{
Trace.TraceError(e.Message);
_logger.LogError(e.Message);
return(new OperationDataResult <WorkOrdersModel>(false,
_workOrdersLocalizationService.GetString("ErrorWhileObtainingWorkOrders")));
}
}
public async Task <OperationDataResult <WorkOrdersSettingsModel> > GetAllSettingsAsync()
{
try
{
var assignedSitesIds = await _dbContext.AssignedSites.Where(y => y.WorkflowState != Constants.WorkflowStates.Removed).Select(x => x.SiteMicrotingUid).ToListAsync();
var theCore = await _core.GetCore();
await using var sdkDbContext = theCore.DbContextHelper.GetDbContext();
var workOrdersSettings = new WorkOrdersSettingsModel()
{
AssignedSites = new List <SiteNameModel>()
};
if (assignedSitesIds.Count > 0)
{
var allSites = await sdkDbContext.Sites.ToListAsync();
foreach (var id in assignedSitesIds)
{
var siteNameModel = allSites.Where(x => x.MicrotingUid == id).Select(x => new SiteNameModel()
{
SiteName = x.WorkflowState == Constants.WorkflowStates.Removed ? $"{x.Name} (Removed)" : x.Name,
SiteUId = (int)x.MicrotingUid,
WorkflowState = x.WorkflowState,
CreatedAt = x.CreatedAt,
UpdatedAt = x.UpdatedAt
}).FirstOrDefault();
workOrdersSettings.AssignedSites.Add(siteNameModel);
}
}
var option = _options.Value;
if (option.FolderId > 0)
{
workOrdersSettings.FolderId = option.FolderId;
}
else
{
workOrdersSettings.FolderId = null;
}
if (option.FolderTasksId > 0)
{
workOrdersSettings.FolderTasksId = option.FolderTasksId;
}
else
{
workOrdersSettings.FolderTasksId = null;
}
return(new OperationDataResult <WorkOrdersSettingsModel>(true, workOrdersSettings));
}
catch (Exception e)
{
Trace.TraceError(e.Message);
_logger.LogError(e.Message);
return(new OperationDataResult <WorkOrdersSettingsModel>(false,
_workOrdersLocalizationService.GetString("ErrorWhileObtainingWorkOrdersSettings")));
}
}
public async Task Handle(SiteAdded message)
{
Console.WriteLine("[INF] EFormCompletedHandler.Handle: called");
_s3Enabled = _sdkCore.GetSdkSetting(Settings.s3Enabled).Result.ToLower() == "true";
_swiftEnabled = _sdkCore.GetSdkSetting(Settings.swiftEnabled).Result.ToLower() == "true";
string downloadPath = await _sdkCore.GetSdkSetting(Settings.fileLocationPdf);
// Docx and PDF files
string timeStamp = DateTime.UtcNow.ToString("yyyyMMdd") + "_" + DateTime.UtcNow.ToString("hhmmss");
string docxFileName = $"{timeStamp}{message.SiteId}_temp.docx";
string tempPDFFileName = $"{timeStamp}{message.SiteId}_temp.pdf";
string tempPDFFilePath = Path.Combine(downloadPath, tempPDFFileName);
string newTaskIdValue = _dbContext.PluginConfigurationValues
.SingleOrDefault(x => x.Name == "WorkOrdersBaseSettings:NewTaskId")?.Value;
bool newTaskIdParseResult = int.TryParse(newTaskIdValue, out int newTaskId);
if (!newTaskIdParseResult)
{
const string errorMessage = "[ERROR] New task eform id not found in setting";
Console.WriteLine(errorMessage);
throw new Exception(errorMessage);
}
string taskListIdValue = _dbContext.PluginConfigurationValues
.SingleOrDefault(x => x.Name == "WorkOrdersBaseSettings:TaskListId")?.Value;
bool taskListIdParseResult = int.TryParse(taskListIdValue, out int taskListId);
if (!taskListIdParseResult)
{
const string errorMessage = "[ERROR] Task list eform id not found in setting";
Console.WriteLine(errorMessage);
throw new Exception(errorMessage);
}
string folderIdValue = _dbContext.PluginConfigurationValues
.SingleOrDefault(x => x.Name == "WorkOrdersBaseSettings:FolderTasksId")?.Value;
int?folderId;
if (string.IsNullOrEmpty(folderIdValue) || folderIdValue == "0")
{
folderId = null;
}
else
{
bool folderIdParseResult = int.TryParse(folderIdValue, out int result);
if (!folderIdParseResult)
{
var errorMessage = $"[ERROR] Folder id parse error. folderIdValue: {folderIdValue}";
Console.WriteLine(errorMessage);
throw new Exception(errorMessage);
}
folderId = result;
}
List <WorkOrder> workOrders = await _dbContext.WorkOrders.Where(x =>
x.DoneAt == null &&
x.WorkflowState != Constants.WorkflowStates.Removed &&
x.MicrotingId != 0 &&
x.CheckMicrotingUid != 0).ToListAsync();
foreach (WorkOrder workOrder in workOrders)
{
Console.WriteLine("[INF] EFormCompletedHandler.Handle: message.CheckId == createNewTaskEFormId");
await using var sdkDbContext = _sdkCore.DbContextHelper.GetDbContext();
Language language = await sdkDbContext.Languages
.SingleAsync(x => x.LanguageCode == "da");
ReplyElement replyElement = await _sdkCore.CaseRead(workOrder.MicrotingId, workOrder.CheckMicrotingUid, language);
var doneBy = sdkDbContext.Workers
.Single(x => x.Id == replyElement.DoneById).full_name();
CheckListValue checkListValue = (CheckListValue)replyElement.ElementList[0];
List <Field> fields = checkListValue.DataItemList.Select(di => di as Field).ToList();
var picturesOfTasks = new List <string>();
if (fields.Any())
{
if (fields.Count == 4)
{
if (!string.IsNullOrEmpty(fields[1]?.FieldValues[0]?.Value))
{
workOrder.Description = fields[1].FieldValues[0].Value;
}
if (!string.IsNullOrEmpty(fields[2]?.FieldValues[0]?.Value))
{
workOrder.CorrectedAtLatest = DateTime.Parse(fields[2].FieldValues[0].Value);
}
if (fields[0].FieldValues.Count > 0)
{
foreach (FieldValue fieldValue in fields[0].FieldValues)
{
if (fieldValue.UploadedDataObj != null)
{
picturesOfTasks.Add(fieldValue.UploadedDataObj.FileName);
}
}
}
}
else
{
// field[0] - picture of the task
if (!string.IsNullOrEmpty(fields[3]?.FieldValues[0]?.Value))
{
workOrder.Description = fields[3].FieldValues[0].Value;
}
if (!string.IsNullOrEmpty(fields[4]?.FieldValues[0]?.Value))
{
workOrder.CorrectedAtLatest = DateTime.Parse(fields[4].FieldValues[0].Value);
}
if (fields[2].FieldValues.Count > 0)
{
foreach (FieldValue fieldValue in fields[2].FieldValues)
{
if (fieldValue.UploadedDataObj != null)
{
picturesOfTasks.Add(fieldValue.UploadedDataObj.FileName);
}
}
}
}
}
// Read html and template
var resourceString = "WorkOrders.Pn.Resources.Templates.page.html";
var assembly = Assembly.GetExecutingAssembly();
string html;
await using (var resourceStream = assembly.GetManifestResourceStream(resourceString))
{
using var reader = new StreamReader(resourceStream ?? throw new InvalidOperationException($"{nameof(resourceStream)} is null"));
html = await reader.ReadToEndAsync();
}
// Read docx stream
resourceString = "WorkOrders.Pn.Resources.Templates.file.docx";
var docxFileResourceStream = assembly.GetManifestResourceStream(resourceString);
if (docxFileResourceStream == null)
{
throw new InvalidOperationException($"{nameof(docxFileResourceStream)} is null");
}
var docxFileStream = new MemoryStream();
await docxFileResourceStream.CopyToAsync(docxFileStream);
await docxFileResourceStream.DisposeAsync();
string basePicturePath = await _sdkCore.GetSdkSetting(Settings.fileLocationPicture);
var word = new WordProcessor(docxFileStream);
string imagesHtml = "";
foreach (var imagesName in picturesOfTasks)
{
imagesHtml = await InsertImage(imagesName, imagesHtml, 700, 650, basePicturePath);
}
html = html.Replace("{%Content%}", imagesHtml);
word.AddHtml(html);
word.Dispose();
docxFileStream.Position = 0;
// Build docx
await using (var docxFile = new FileStream(docxFileName, FileMode.Create, FileAccess.Write))
{
docxFileStream.WriteTo(docxFile);
}
// Convert to PDF
ReportHelper.ConvertToPdf(docxFileName, downloadPath);
File.Delete(docxFileName);
// Upload PDF
// string pdfFileName = null;
string hash = await _sdkCore.PdfUpload(tempPDFFilePath);
if (hash != null)
{
//rename local file
FileInfo fileInfo = new FileInfo(tempPDFFilePath);
fileInfo.CopyTo(downloadPath + hash + ".pdf", true);
fileInfo.Delete();
await _sdkCore.PutFileToStorageSystem(Path.Combine(downloadPath, $"{hash}.pdf"), $"{hash}.pdf");
// TODO Remove from file storage?
}
//var folderResult = await _dbContext.PluginConfigurationValues.SingleAsync(x => x.Name == "WorkOrdersBaseSettings:FolderTasksId");
string folderMicrotingUid = sdkDbContext.Folders.Single(x => x.Id == folderId)
.MicrotingUid.ToString();
List <AssignedSite> sites = await _dbContext.AssignedSites.Where(x => x.WorkflowState != Constants.WorkflowStates.Removed).ToListAsync();
foreach (AssignedSite site in sites)
{
Site sdkSite = await sdkDbContext.Sites.SingleAsync(x => x.MicrotingUid == site.SiteMicrotingUid);
language = await sdkDbContext.Languages.SingleAsync(x => x.Id == sdkSite.LanguageId);
Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo(language.LanguageCode);
MainElement mainElement = await _sdkCore.ReadeForm(taskListId, language);
mainElement.Repeated = 1;
mainElement.EndDate = DateTime.Now.AddYears(10).ToUniversalTime();
mainElement.StartDate = DateTime.Now.ToUniversalTime();
mainElement.CheckListFolderName = folderMicrotingUid;
DateTime startDate = new DateTime(2020, 1, 1);
mainElement.DisplayOrder = (workOrder.CorrectedAtLatest - startDate).Days;
DataElement dataElement = (DataElement)mainElement.ElementList[0];
if (fields.Count == 4)
{
mainElement.Label = fields[1].FieldValues[0].Value;
mainElement.PushMessageTitle = mainElement.Label;
mainElement.PushMessageBody = string.IsNullOrEmpty(fields[2].FieldValues[0].Value)
? ""
: $"{_workOrdersLocalizationService.GetString("DontAtTheLatest")}: " + DateTime.Parse(fields[2].FieldValues[0].Value).ToString("dd-MM-yyyy");
dataElement.Label = fields[1].FieldValues[0].Value;
dataElement.Description.InderValue += $"<strong>{_workOrdersLocalizationService.GetString("TaskCreatedBy")}:</strong> {doneBy}<br>";
dataElement.Description.InderValue += $"<strong>{_workOrdersLocalizationService.GetString("DontAtTheLatest")}:</strong>"; // Needs i18n support "Corrected at the latest:"
dataElement.Description.InderValue += string.IsNullOrEmpty(fields[2].FieldValues[0].Value)
? ""
: DateTime.Parse(fields[2].FieldValues[0].Value).ToString("dd-MM-yyyy");
dataElement.DataItemList[0].Description.InderValue = dataElement.Description.InderValue;
dataElement.DataItemList[0].Label = dataElement.Label;
}
else
{
mainElement.Label = fields[3].FieldValues[0].Value;
mainElement.PushMessageTitle = mainElement.Label;
mainElement.PushMessageBody = string.IsNullOrEmpty(fields[4].FieldValues[0].Value)
? ""
: $"{_workOrdersLocalizationService.GetString("DontAtTheLatest")}: " + DateTime.Parse(fields[4].FieldValues[0].Value).ToString("dd-MM-yyyy");
dataElement.Label = fields[3].FieldValues[0].Value;
dataElement.Description.InderValue += string.IsNullOrEmpty(fields[0].FieldValues[0].ValueReadable)
? "" :
$"<strong>{_workOrdersLocalizationService.GetString("Area")}:</strong> {fields[0].FieldValues[0].ValueReadable}<br>";
dataElement.Description.InderValue += string.IsNullOrEmpty(fields[1].FieldValues[0].ValueReadable)
? ""
:$"<strong>{_workOrdersLocalizationService.GetString("AssignedTo")}:</strong> {fields[1].FieldValues[0].ValueReadable}<br>";
dataElement.Description.InderValue += $"<strong>{_workOrdersLocalizationService.GetString("TaskCreatedBy")}:</strong> {doneBy}<br>";
dataElement.Description.InderValue += $"<strong>{_workOrdersLocalizationService.GetString("DontAtTheLatest")}:</strong>"; // Needs i18n support "Corrected at the latest:"
dataElement.Description.InderValue += string.IsNullOrEmpty(fields[4].FieldValues[0].Value)
? ""
: DateTime.Parse(fields[4].FieldValues[0].Value).ToString("dd-MM-yyyy");
dataElement.DataItemList[0].Description.InderValue = dataElement.Description.InderValue;
dataElement.DataItemList[0].Label = dataElement.Label;
}
if (hash != null)
{
((ShowPdf)dataElement.DataItemList[1]).Value = hash;
}
var wotCase = await _dbContext.WorkOrdersTemplateCases.SingleOrDefaultAsync(x =>
x.CheckId == workOrder.CheckId &&
x.CheckMicrotingUid == workOrder.CheckMicrotingUid &&
x.SdkSiteMicrotingUid == site.SiteMicrotingUid &&
x.WorkflowState != Constants.WorkflowStates.Removed);
if (wotCase != null)
{
continue;
}
int?caseId = await _sdkCore.CaseCreate(mainElement, "", site.SiteMicrotingUid, folderId);
wotCase = new WorkOrdersTemplateCase()
{
CheckId = workOrder.CheckId,
CheckMicrotingUid = workOrder.CheckMicrotingUid,
WorkOrderId = workOrder.Id,
CaseId = (int)caseId,
CaseMicrotingUid = workOrder.MicrotingId,
SdkSiteMicrotingUid = site.SiteMicrotingUid
};
await wotCase.Create(_dbContext);
}
}
}