mirror of
https://github.com/hanzoai/jube-fork.git
synced 2026-10-30 18:33:33 +00:00
richard-churchman
811c938462
* Pushed Case Workflow Display HTML rendering logic down into a controller for improved security and consistent tokenisation of the Jube token format against context. Included a migration to update the default demo entry to use proper tokenisation. Updated the repository to support fetching CaseWorkflowDisplay with appropriate security. * Implemented improved tokenisation of the EntityAnalysisModelInstanceEntryPayload model via a common extension method on EntityAnalysisModelInstanceEntryPayload, used consistently across the system for serialisation and storage. * Included a migration to update the tokenisation format for full CaseWorkflowDisplay support. * Fixed an issue where CaseWorkflowFilter was incorrectly filtering on CaseWorkflowStatus.Guid instead of CaseWorkflowStatus.Name, causing the GUID to be returned rather than the display name on the template/demo model. (The remainder was fixed in GitHub issue #6.) Included a migration with a corrective SQL statement. * Fixed an issue where tokens were not being stored alongside CaseWorkflowFilter definition configuration. It now behaves identically to CaseSearch. Note: migrating missing tokens is not feasible as it requires JS-side parsing via JQueryBuilder. * Reduced the size of the CaseWorkflowForm invocation to include only the required fields given the new POST body context being rendered server side. Improved API serialisation by using a dictionary for form payload keys and values. * Consolidated JSON serialisation settings into DI and updated usages throughout. * Updated EntityAnalysisModelInstanceEntryPayload write serialisers to handle deserialisation, which is required to support tokenisation of new Case Automation POST bodies. * Created an extension method on the EntityAnalysisModelInstanceEntryPayload to centralise tokenisation of strings across Activation and Case Automation on a consistent basis. Simplified Case Notification and Case HTTP dispatch by removing tokenisation logic from those classes. * Removed a redundant field from the CaseWorkflowFormEntry POCO (database left unchanged for now). * Fixed a bug in Case session SQL rebuilding where the rebuild date was not being correctly checked for null or default value, which caused a failure in the last migration. * Made minor modifications to the Create Case process and method signature to skip serialisation when the payload object required for tokenisation is already available on the thread (e.g. during synchronous reprocessing). * Updated Case Workflow Macro processing to fetch the archive payload for the case from the database, improving security of that invocation endpoint. * Removed what appeared to be a duplicate EntityAnalysisModelInstanceEntryPayload model introduced during refactoring. * Fixed a but in Case Worfkflow Display Role assigment owing to volatile Guid in its update.
195 lines
9.4 KiB
C#
195 lines
9.4 KiB
C#
/* Copyright (C) 2022-present Jube Holdings Limited.
|
|
*
|
|
* This file is part of Jube™ software.
|
|
*
|
|
* Jube™ is free software: you can redistribute it and/or modify it under the terms of the GNU Affero General Public License
|
|
* as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.
|
|
* Jube™ is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty
|
|
* of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more details.
|
|
|
|
* You should have received a copy of the GNU Affero General Public License along with Jube™. If not,
|
|
* see <https://www.gnu.org/licenses/>.
|
|
*/
|
|
|
|
namespace Jube.Data.Repository
|
|
{
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Threading;
|
|
using System.Threading.Tasks;
|
|
using AutoMapper;
|
|
using Context;
|
|
using LinqToDB;
|
|
using Poco;
|
|
|
|
public class CaseWorkflowDisplayRepository
|
|
{
|
|
private readonly DbContext dbContext;
|
|
private readonly int tenantRegistryId;
|
|
private readonly string userName;
|
|
|
|
public CaseWorkflowDisplayRepository(DbContext dbContext, string userName)
|
|
{
|
|
this.dbContext = dbContext;
|
|
this.userName = userName;
|
|
tenantRegistryId = this.dbContext.UserInTenant.Where(w => w.User == this.userName)
|
|
.Select(s => s.TenantRegistryId).FirstOrDefault();
|
|
}
|
|
|
|
public CaseWorkflowDisplayRepository(DbContext dbContext, int tenantRegistryId)
|
|
{
|
|
this.dbContext = dbContext;
|
|
this.tenantRegistryId = tenantRegistryId;
|
|
}
|
|
|
|
public async Task<IEnumerable<CaseWorkflowDisplay>> GetAsync(CancellationToken token = default)
|
|
{
|
|
return await dbContext.CaseWorkflowDisplay
|
|
.Where(w => w.CaseWorkflow.EntityAnalysisModel.TenantRegistryId == tenantRegistryId)
|
|
.ToListAsync(token);
|
|
}
|
|
|
|
public Task<CaseWorkflowDisplay> GetByNameCaseWorkflowIdAsync(string name, int caseWorkflowId, CancellationToken token = default)
|
|
{
|
|
return dbContext.CaseWorkflowDisplay
|
|
.FirstOrDefaultAsync(f =>
|
|
f.CaseWorkflow.EntityAnalysisModel.TenantRegistryId == tenantRegistryId
|
|
&& f.CaseWorkflowId == caseWorkflowId
|
|
&& (f.Deleted == 0 || f.Deleted == null)
|
|
&& f.Name.ToLower() == name.ToLower(), token);
|
|
}
|
|
|
|
public async Task<IEnumerable<CaseWorkflowDisplay>> GetByCasesWorkflowIdOrderByIdAsync(int casesWorkflowId, CancellationToken token = default)
|
|
{
|
|
return await dbContext.CaseWorkflowDisplay
|
|
.Where(w => w.CaseWorkflow.EntityAnalysisModel.TenantRegistryId == tenantRegistryId
|
|
&& w.CaseWorkflowId == casesWorkflowId && (w.Deleted == 0 || w.Deleted == null))
|
|
.OrderBy(o => o.Id).ToListAsync(token);
|
|
}
|
|
|
|
public async Task<IEnumerable<CaseWorkflowDisplay>> GetByCasesWorkflowIdActiveOnlyAsync(int casesWorkflowId, CancellationToken token = default)
|
|
{
|
|
return await dbContext.CaseWorkflowDisplay
|
|
.Where(w => w.CaseWorkflow.EntityAnalysisModel.TenantRegistryId == tenantRegistryId
|
|
&& w.Active == 1
|
|
&& w.CaseWorkflowId == casesWorkflowId
|
|
&& (w.Deleted == 0 || w.Deleted == null)
|
|
&& (w.CaseWorkflowDisplayRole.RoleRegistry.UserRegistry.Name == userName
|
|
&& w.CaseWorkflowDisplayRole.Deleted == 0 || w.CaseWorkflowDisplayRole.Deleted == null)
|
|
&& (w.CaseWorkflow.CaseWorkflowRole.RoleRegistry.UserRegistry.Name == userName
|
|
&& w.CaseWorkflow.CaseWorkflowRole.Deleted == 0 || w.CaseWorkflow.CaseWorkflowRole.Deleted == null)
|
|
).ToListAsync(token);
|
|
}
|
|
|
|
public async Task<IEnumerable<CaseWorkflowDisplay>> GetByCasesWorkflowGuidActiveOnlyAsync(Guid casesWorkflowGuid, CancellationToken token = default)
|
|
{
|
|
return await dbContext.CaseWorkflowDisplay
|
|
.Where(w => w.CaseWorkflow.EntityAnalysisModel.TenantRegistryId == tenantRegistryId
|
|
&& w.Active == 1
|
|
&& w.CaseWorkflow.Guid == casesWorkflowGuid
|
|
&& (w.CaseWorkflow.EntityAnalysisModel.Deleted == 0 ||
|
|
w.CaseWorkflow.EntityAnalysisModel.Deleted == null)
|
|
&& (w.Deleted == 0 || w.Deleted == null)
|
|
&& (w.CaseWorkflowDisplayRole.RoleRegistry.UserRegistry.Name == userName
|
|
&& w.CaseWorkflowDisplayRole.Deleted == 0 || w.CaseWorkflowDisplayRole.Deleted == null)
|
|
&& (w.CaseWorkflow.CaseWorkflowRole.RoleRegistry.UserRegistry.Name == userName
|
|
&& w.CaseWorkflow.CaseWorkflowRole.Deleted == 0 || w.CaseWorkflow.CaseWorkflowRole.Deleted == null)
|
|
).ToListAsync(token);
|
|
}
|
|
|
|
public Task<CaseWorkflowDisplay> GetByIdAsync(int id, CancellationToken token = default)
|
|
{
|
|
return dbContext.CaseWorkflowDisplay.FirstOrDefaultAsync(w =>
|
|
w.CaseWorkflow.EntityAnalysisModel.TenantRegistryId == tenantRegistryId
|
|
&& w.Id == id && (w.Deleted == 0 || w.Deleted == null), token);
|
|
}
|
|
|
|
public Task<CaseWorkflowDisplay> GetByIdActiveOnlyAsync(int id, CancellationToken token = default)
|
|
{
|
|
return dbContext.CaseWorkflowDisplay.FirstOrDefaultAsync(w =>
|
|
w.CaseWorkflow.EntityAnalysisModel.TenantRegistryId == tenantRegistryId
|
|
&& w.Id == id && (w.Deleted == 0 || w.Deleted == null)
|
|
&& w.Active == 1
|
|
&& (w.CaseWorkflowDisplayRole.RoleRegistry.UserRegistry.Name == userName
|
|
&& w.CaseWorkflowDisplayRole.Deleted == 0 || w.CaseWorkflowDisplayRole.Deleted == null)
|
|
&& (w.CaseWorkflow.CaseWorkflowRole.RoleRegistry.UserRegistry.Name == userName
|
|
&& w.CaseWorkflow.CaseWorkflowRole.Deleted == 0 || w.CaseWorkflow.CaseWorkflowRole.Deleted == null), token);
|
|
}
|
|
|
|
public async Task<CaseWorkflowDisplay> InsertAsync(CaseWorkflowDisplay model, CancellationToken token = default)
|
|
{
|
|
model.CreatedUser = userName;
|
|
model.CreatedDate = DateTime.Now;
|
|
model.Version = 1;
|
|
model.Guid = model.Guid == Guid.Empty ? Guid.NewGuid() : model.Guid;
|
|
model.Id = await dbContext.InsertWithInt32IdentityAsync(model, token: token);
|
|
return model;
|
|
}
|
|
|
|
public async Task<CaseWorkflowDisplay> UpdateAsync(CaseWorkflowDisplay model, CancellationToken token = default)
|
|
{
|
|
var existing = await dbContext.CaseWorkflowDisplay
|
|
.FirstOrDefaultAsync(w => w.Id
|
|
== model.Id
|
|
&& w.CaseWorkflow.EntityAnalysisModel.TenantRegistryId ==
|
|
tenantRegistryId
|
|
&& (w.Deleted == 0 || w.Deleted == null)
|
|
&& (w.Locked == 0 || w.Locked == null), token);
|
|
|
|
if (existing == null)
|
|
{
|
|
throw new KeyNotFoundException();
|
|
}
|
|
|
|
model.Version = existing.Version + 1;
|
|
model.CreatedUser = userName ?? model.CreatedUser;
|
|
model.Guid = existing.Guid;
|
|
model.CreatedDate = DateTime.Now;
|
|
|
|
await dbContext.UpdateAsync(model, token: token);
|
|
|
|
var mapper = new Mapper(new MapperConfiguration(cfg =>
|
|
{
|
|
cfg.CreateMap<CaseWorkflowDisplay, CaseWorkflowDisplayVersion>();
|
|
}));
|
|
|
|
var audit = mapper.Map<CaseWorkflowDisplayVersion>(existing);
|
|
audit.CaseWorkflowDisplayId = existing.Id;
|
|
|
|
await dbContext.InsertAsync(audit, token: token);
|
|
|
|
return model;
|
|
}
|
|
|
|
public async Task DeleteAsync(int id, CancellationToken token = default)
|
|
{
|
|
var records = await dbContext.CaseWorkflowDisplay
|
|
.Where(d => d.CaseWorkflow.EntityAnalysisModel.TenantRegistryId == tenantRegistryId
|
|
&& d.Id == id
|
|
&& (d.Locked == 0 || d.Locked == null)
|
|
&& (d.Deleted == 0 || d.Deleted == null))
|
|
.Set(s => s.Deleted, Convert.ToByte(1))
|
|
.Set(s => s.DeletedDate, DateTime.Now)
|
|
.Set(s => s.DeletedUser, userName)
|
|
.UpdateAsync(token);
|
|
|
|
if (records == 0)
|
|
{
|
|
throw new KeyNotFoundException();
|
|
}
|
|
}
|
|
|
|
public Task DeleteByTenantRegistryIdOutsideOfInstanceAsync(int tenantRegistryIdOutsideOfInstance, int importId, CancellationToken token = default)
|
|
{
|
|
return dbContext.CaseWorkflowDisplay
|
|
.Where(d => d.CaseWorkflow.EntityAnalysisModel.TenantRegistryId == tenantRegistryIdOutsideOfInstance
|
|
&& (d.Deleted == 0 || d.Deleted == null))
|
|
.Set(s => s.ImportId, importId)
|
|
.Set(s => s.Deleted, Convert.ToByte(1))
|
|
.Set(s => s.DeletedDate, DateTime.Now)
|
|
.UpdateAsync(token);
|
|
}
|
|
}
|
|
}
|