| | | 1 | | using Microsoft.EntityFrameworkCore; |
| | | 2 | | using Microsoft.Extensions.Logging; |
| | | 3 | | using System; |
| | | 4 | | using System.Collections.Generic; |
| | | 5 | | using System.Linq; |
| | | 6 | | using System.Text.Json; |
| | | 7 | | using System.Threading.Tasks; |
| | | 8 | | using WinSolutions.Sveta.Server.Domain; |
| | | 9 | | using WinSolutions.Sveta.Server.Data.DataModel.Contexts; |
| | | 10 | | using WinSolutions.Sveta.Server.Data.DataModel.Entities; |
| | | 11 | | using WinSolutions.Sveta.Server.Data.DataModel.Kinds; |
| | | 12 | | using WinSolutions.Sveta.Server.Services.Interfaces; |
| | | 13 | | using WinSolutions.Sveta.Common; |
| | | 14 | | |
| | | 15 | | namespace WinSolutions.Sveta.Server.Services.Implements |
| | | 16 | | { |
| | | 17 | | public class ControlsAccessService : SvetaServiceBase, IControlsAccessService |
| | | 18 | | { |
| | | 19 | | private readonly SvetaDbContext _db; |
| | | 20 | | private readonly ILogger<ControlsAccessService> _logger; |
| | | 21 | | private readonly IDepartmentService _departService; |
| | | 22 | | private readonly IMovementService _movementService; |
| | | 23 | | private readonly IAuthenticationService _authenticationService; |
| | | 24 | | private readonly IAnonymousMovementService _anonymousMovementService; |
| | | 25 | | public ControlsAccessService(SvetaDbContext db, ILogger<ControlsAccessService> logger, IAuthenticationService au |
| | | 26 | | IMovementService movementService, IAnonymousMovementService anonymousMovementService) |
| | 4 | 27 | | : base(authenticationService) |
| | 4 | 28 | | { |
| | 4 | 29 | | _authenticationService = authenticationService; |
| | 4 | 30 | | _movementService = movementService; |
| | 4 | 31 | | _departService = departService; |
| | 4 | 32 | | _db = db; |
| | 4 | 33 | | _logger = logger; |
| | 4 | 34 | | _anonymousMovementService = anonymousMovementService; |
| | 4 | 35 | | } |
| | | 36 | | |
| | | 37 | | /// <summary> |
| | | 38 | | /// получить список доступов с пагинацией |
| | | 39 | | /// </summary> |
| | | 40 | | /// <param name="page">номер страницы</param> |
| | | 41 | | /// <param name="limit">размер страницы</param> |
| | | 42 | | /// <param name="sort">сортировка</param> |
| | | 43 | | /// <param name="filter">фильтр по названию действия, роли</param> |
| | | 44 | | /// <returns></returns> |
| | | 45 | | public async Task<PaginatedData<List<ControlAccess>>> GetAccesses(int page, int limit, string sort, string filte |
| | 3 | 46 | | { |
| | 3 | 47 | | var accesses = PrepareAccesses().AsNoTracking(); |
| | 3 | 48 | | int total = await accesses?.CountAsync(); |
| | 3 | 49 | | accesses = accesses.Where(x => string.IsNullOrWhiteSpace(filter) || x.Action.Name.ToLower().Contains(filter. |
| | 3 | 50 | | accesses = Sort(accesses, sort?.ToLower()); |
| | 3 | 51 | | int filtered = await accesses?.CountAsync(); |
| | 3 | 52 | | return new PaginatedData<List<ControlAccess>> |
| | 3 | 53 | | { |
| | 3 | 54 | | Result = await accesses.Skip(page * limit).Take(limit).ToListAsync(), |
| | 3 | 55 | | TotalCount = total, |
| | 3 | 56 | | TotalFilteredCount = filtered |
| | 3 | 57 | | }; |
| | 3 | 58 | | } |
| | | 59 | | |
| | | 60 | | /// <summary> |
| | | 61 | | /// получить доступ по id роли и id действия |
| | | 62 | | /// </summary> |
| | | 63 | | /// <param name="roleId">id роли</param> |
| | | 64 | | /// <param name="actionId">id действия</param> |
| | | 65 | | /// <returns></returns> |
| | 1 | 66 | | public async Task<ControlAccess> GetAccess(long roleId, long actionId) => await PrepareAccesses() |
| | 1 | 67 | | .FirstOrDefaultAsync(d => d.RoleId == roleId && d.ActionId == actionId); |
| | | 68 | | |
| | | 69 | | /// <summary> |
| | | 70 | | /// предварительаня выборка доступов |
| | | 71 | | /// </summary> |
| | | 72 | | /// <returns></returns> |
| | 9 | 73 | | private IQueryable<ControlAccess> PrepareAccesses() => _db.ControlsAccess |
| | 9 | 74 | | .Include(e=>e.Role) |
| | 9 | 75 | | .Include(e => e.Action) |
| | 9 | 76 | | .Where(e => !e.IsDeleted) |
| | 9 | 77 | | .AsQueryable(); |
| | | 78 | | |
| | | 79 | | /// <summary> |
| | | 80 | | /// получить доступ по id |
| | | 81 | | /// </summary> |
| | | 82 | | /// <param name="id">id доступа</param> |
| | | 83 | | /// <returns></returns> |
| | 3 | 84 | | public async Task<ControlAccess> GetAccess(long id) => await PrepareAccesses().FirstOrDefaultAsync(e => e.Id == |
| | | 85 | | |
| | | 86 | | /// <summary> |
| | | 87 | | /// Возвращает список доступных действий для текущей роли пользователя |
| | | 88 | | /// </summary> |
| | | 89 | | /// <returns></returns> |
| | | 90 | | public async Task<List<ControlAccess>> GetAvailableAccesses() |
| | 0 | 91 | | { |
| | 0 | 92 | | var accesses = PrepareAccesses().AsNoTracking().Where(e => e.Available == true); |
| | 0 | 93 | | if (!(await _departService.GetDeparmentsList()).Any()) //если нет привязанных подразделений, то исключаем ча |
| | 0 | 94 | | accesses = accesses.Where(x => x.Action.Name != "viewOrders" && x.Action.Name != "viewShipments" && x.Ac |
| | 0 | 95 | | if (_authenticationService.ContragentKindId == (long)ContragentKind.Wholesaler && |
| | 0 | 96 | | !(_movementService.GetFilterMovementsWithoutPagination(0, 0, _authenticationService.ContragentId)).Any() |
| | 0 | 97 | | accesses = accesses.Where(x => x.Action.Name != "viewShipments"); |
| | 0 | 98 | | return await accesses.ToListAsync(); |
| | 0 | 99 | | } |
| | | 100 | | |
| | | 101 | | /// <summary> |
| | | 102 | | /// создать доступ |
| | | 103 | | /// </summary> |
| | | 104 | | /// <param name="data">доступ</param> |
| | | 105 | | /// <returns></returns> |
| | | 106 | | public async Task Create(ControlAccess data) |
| | 1 | 107 | | { |
| | 1 | 108 | | _db.Entry(data.RecState).State = EntityState.Unchanged; |
| | 1 | 109 | | _db.Entry(data.Role).State = EntityState.Unchanged; |
| | 1 | 110 | | _db.Entry(data.Action).State = EntityState.Unchanged; |
| | 1 | 111 | | await _db.ControlsAccess.AddAsync(data); |
| | 1 | 112 | | await _db.SaveChangesAsync(CurrentUserId); |
| | 1 | 113 | | } |
| | | 114 | | |
| | | 115 | | /// <summary> |
| | | 116 | | /// проверяет существование доступа |
| | | 117 | | /// </summary> |
| | | 118 | | /// <param name="id">id доступа</param> |
| | | 119 | | /// <returns></returns> |
| | 2 | 120 | | public async Task<bool> AccessExists(long id) => await PrepareAccesses().AsNoTracking().Where(e => e.Id == id).A |
| | | 121 | | |
| | | 122 | | /// <summary> |
| | | 123 | | /// обновляет доступ |
| | | 124 | | /// </summary> |
| | | 125 | | /// <param name="data">доступ</param> |
| | | 126 | | /// <returns></returns> |
| | | 127 | | public async Task Update(ControlAccess data) |
| | 1 | 128 | | { |
| | 1 | 129 | | if (!(await AccessExists(data.Id))) |
| | 0 | 130 | | { |
| | 0 | 131 | | throw new ArgumentException($"Запись с id={data.Id} не найдена"); |
| | | 132 | | } |
| | 1 | 133 | | _db.ControlsAccess.Update(data); |
| | 1 | 134 | | await _db.SaveChangesAsync(CurrentUserId); |
| | 1 | 135 | | } |
| | | 136 | | |
| | | 137 | | /// <summary> |
| | | 138 | | /// удалить доступ |
| | | 139 | | /// </summary> |
| | | 140 | | /// <param name="id">id доступа</param> |
| | | 141 | | /// <returns></returns> |
| | | 142 | | public async Task Delete(long id) |
| | 1 | 143 | | { |
| | 1 | 144 | | ControlAccess rec = await _db.ControlsAccess.FindAsync(id); |
| | 1 | 145 | | if (rec == null) |
| | 0 | 146 | | throw new KeyNotFoundException($"Запись с id={id} не найдена"); |
| | 1 | 147 | | rec.IsDeleted = true; |
| | 1 | 148 | | await _db.SaveChangesAsync(CurrentUserId); |
| | 1 | 149 | | } |
| | | 150 | | |
| | | 151 | | /// <summary> |
| | | 152 | | /// сортировка |
| | | 153 | | /// </summary> |
| | | 154 | | /// <param name="items">выборка доступов</param> |
| | | 155 | | /// <param name="sort">тип сортировки</param> |
| | | 156 | | /// <returns></returns> |
| | 3 | 157 | | private IQueryable<ControlAccess> Sort(IQueryable<ControlAccess> items, string sort = default) => (sort ?? "").T |
| | 3 | 158 | | { |
| | 3 | 159 | | "roleid" => items.OrderBy(d => d.RoleId), |
| | 3 | 160 | | "roleid|desc" => items.OrderByDescending(d => d.RoleId), |
| | 3 | 161 | | "available" => items.OrderBy(d => d.Available), |
| | 3 | 162 | | "available|desc" => items.OrderByDescending(d => d.Available), |
| | 3 | 163 | | "action|desc" => items.OrderByDescending(d => d.Action.Name), |
| | 3 | 164 | | _ => items.OrderBy(d => d.Action.Name) |
| | 3 | 165 | | }; |
| | | 166 | | |
| | | 167 | | /// <summary> |
| | | 168 | | /// получить список действий |
| | | 169 | | /// </summary> |
| | | 170 | | /// <param name="typeId">id действия. Если 0, то все выводить</param> |
| | | 171 | | /// <param name="filter">фильтр по названию действия</param> |
| | | 172 | | /// <returns></returns> |
| | | 173 | | public async Task<List<FrontAction>> GetActions(long typeId, string filter = null) |
| | 3 | 174 | | { |
| | 3 | 175 | | var data = _db.FrontActions |
| | 3 | 176 | | .AsNoTracking() |
| | 3 | 177 | | .Where(x => typeId == 0 || x.Id == typeId) |
| | 3 | 178 | | .Where(x => string.IsNullOrWhiteSpace(filter) || x.Name.ToLower().Contains(filter.ToLower())) |
| | 3 | 179 | | .Where(d => !d.IsDeleted); |
| | 3 | 180 | | return await data.ToListAsync(); |
| | 3 | 181 | | } |
| | | 182 | | |
| | | 183 | | /// <summary> |
| | | 184 | | /// получить действие по id |
| | | 185 | | /// </summary> |
| | | 186 | | /// <param name="id">id действия</param> |
| | | 187 | | /// <returns></returns> |
| | 1 | 188 | | public async Task<FrontAction> GetAction(long id) => await _db.FrontActions |
| | 1 | 189 | | .Where(d => !d.IsDeleted && d.Id == id).FirstOrDefaultAsync(); |
| | | 190 | | } |
| | | 191 | | } |