using NCC.Common.Core.Manager; using NCC.Common.Enum; using NCC.Common.Extension; using NCC.Common.Filter; using NCC.Dependency; using NCC.DynamicApiController; using NCC.FriendlyException; using NCC.Extend.Interfaces.BusinessOperationLog; using NCC.Extend.Interfaces.LqMdxx; using NCC.Extend.Interfaces.StoreProfileVersion; using Mapster; using Microsoft.AspNetCore.Mvc; using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using NCC.Extend.Entitys.lq_mdxx; using NCC.Extend.Entitys.Dto.LqMdxx; using Yitter.IdGenerator; using NCC.Common.Helper; using NCC.JsonSerialization; using NCC.Common.Model.NPOI; using NCC.Common.Configuration; using NCC.DataEncryption; using NCC.ClayObject; using NCC.Extend.Entitys.Enum; using NCC.Code; using NCC.Extend.Entitys.Dto.Common; using Newtonsoft.Json; namespace NCC.Extend.LqMdxx { /// /// 门店信息服务 /// [ApiDescriptionSettings(Tag = "绿纤门店信息服务", Name = "LqMdxx", Order = 200)] [Route("api/Extend/[controller]")] public class LqMdxxService : ILqMdxxService, IDynamicApiController, ITransient { private readonly ISqlSugarRepository _lqMdxxRepository; private readonly SqlSugarScope _db; private readonly IUserManager _userManager; private readonly IStoreProfileVersionAppender _storeProfileVersionAppender; private readonly IBusinessOperationLogService _businessOperationLogService; private const int InvalidStatus = (int)StatusEnum.无效; /// /// 初始化一个类型的新实例 /// public LqMdxxService( ISqlSugarRepository lqMdxxRepository, IUserManager userManager, IStoreProfileVersionAppender storeProfileVersionAppender, IBusinessOperationLogService businessOperationLogService) { _lqMdxxRepository = lqMdxxRepository; _db = _lqMdxxRepository.Context; _userManager = userManager; _storeProfileVersionAppender = storeProfileVersionAppender; _businessOperationLogService = businessOperationLogService; } #region 门店信息 /// /// 获取门店信息 /// /// 参数 /// [HttpGet("{id}")] public async Task GetInfo(string id) { var entity = await _db.Queryable().FirstAsync(p => p.Id == id); var output = entity.Adapt(); return output; } #endregion #region 门店信息列表 /// /// 获取门店信息列表 /// /// 请求参数 /// [HttpGet("")] public async Task GetList([FromQuery] LqMdxxListQueryInput input) { var sidx = input.sidx == null ? "id" : input.sidx; List queryKysj = input.kysj != null ? input.kysj.Split(',').ToObeject>() : null; DateTime? startKysj = queryKysj != null ? Ext.GetDateTime(queryKysj.First()) : null; DateTime? endKysj = queryKysj != null ? Ext.GetDateTime(queryKysj.Last()) : null; var data = await _db.Queryable() .Where(p => p.Status == null || p.Status != InvalidStatus) .WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id)) .WhereIF(!string.IsNullOrEmpty(input.mdbm), p => p.Mdbm.Contains(input.mdbm)) .WhereIF(!string.IsNullOrEmpty(input.djmdbh), p => p.Djmdbh.Contains(input.djmdbh)) .WhereIF(!string.IsNullOrEmpty(input.djmd), p => p.Djmd.Contains(input.djmd)) .WhereIF(!string.IsNullOrEmpty(input.dm), p => p.Dm.Contains(input.dm) || p.Djmd.Contains(input.dm)) .WhereIF(!string.IsNullOrEmpty(input.cs), p => p.Cs.Contains(input.cs)) .WhereIF(!string.IsNullOrEmpty(input.dz), p => p.Dz.Contains(input.dz)) .WhereIF(!string.IsNullOrEmpty(input.xm), p => p.Xm.Contains(input.xm)) .WhereIF(!string.IsNullOrEmpty(input.dhhm), p => p.Dhhm.Contains(input.dhhm)) .WhereIF(!string.IsNullOrEmpty(input.zj), p => p.Zj.Contains(input.zj)) .WhereIF(queryKysj != null, p => p.Kysj >= new DateTime(startKysj.ToDate().Year, startKysj.ToDate().Month, startKysj.ToDate().Day, 0, 0, 0)) .WhereIF(queryKysj != null, p => p.Kysj <= new DateTime(endKysj.ToDate().Year, endKysj.ToDate().Month, endKysj.ToDate().Day, 23, 59, 59)) .WhereIF(!string.IsNullOrEmpty(input.zxzt), p => p.Zxzt.Equals(input.zxzt)) .WhereIF(!string.IsNullOrEmpty(input.gsmc), p => p.Gsmc.Contains(input.gsmc)) .WhereIF(!string.IsNullOrEmpty(input.fr), p => p.Fr.Contains(input.fr)) .WhereIF(!string.IsNullOrEmpty(input.ywsb), p => p.Ywsb.Equals(input.ywsb)) .Select(it => new LqMdxxListOutput { id = it.Id, mdbm = it.Mdbm, djmdbh = it.Djmdbh, djmd = it.Djmd, dm = it.Dm, cs = it.Cs, dz = it.Dz, xm = it.Xm, dhhm = it.Dhhm, zj = it.Zj, kysj = it.Kysj, zxzt = it.Zxzt, gsmc = it.Gsmc, fr = it.Fr, ywsb = it.Ywsb, jyb = it.Jyb, kjb = it.Kjb, dxmb = it.Dxmb, syb = it.Syb, xsyj = it.Xsyj, xhyj = it.Xhyj, xms = it.Xms, rt1 = it.Rt1, rt2 = it.Rt2, rc = it.Rc, storeCategory = it.StoreCategory, storeType = it.StoreType, zzrs = it.Zzrs, storeImages = it.StoreImages, storeDescription = it.StoreDescription, storeTags = it.StoreTags, businessHours = it.BusinessHours, trafficTips = it.TrafficTips, }).MergeTable().OrderBy(sidx + " " + input.sort).ToPagedListAsync(input.currentPage, input.pageSize); return PageResult.SqlSugarPageResult(data); } #endregion #region 新建门店信息 /// /// 新建门店信息 /// /// 参数 /// [HttpPost("")] public async Task Create([FromBody] LqMdxxCrInput input) { var userInfo = await _userManager.GetUserInfo(); var entity = input.Adapt(); entity.Id = YitIdHelper.NextId().ToString(); var isOk = await _db.Insertable(entity).IgnoreColumns(ignoreNullColumn: true).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1000); await TryWriteBusinessLogAsync( "门店信息", "新增门店", "lq_mdxx", entity.Id, $"新增门店:{GetStoreDisplayName(entity)}(ID:{entity.Id})", JsonConvert.SerializeObject(new { after = new { entity.Id, entity.Mdbm, entity.Dm, entity.Cs } })); } #endregion #region 获取门店信息无分页列表 /// /// 获取门店信息无分页列表 /// /// 请求参数 /// [NonAction] public async Task GetNoPagingList([FromQuery] LqMdxxListQueryInput input) { var sidx = input.sidx == null ? "id" : input.sidx; List queryKysj = input.kysj != null ? input.kysj.Split(',').ToObeject>() : null; DateTime? startKysj = queryKysj != null ? Ext.GetDateTime(queryKysj.First()) : null; DateTime? endKysj = queryKysj != null ? Ext.GetDateTime(queryKysj.Last()) : null; var data = await _db.Queryable() .Where(p => p.Status == null || p.Status != InvalidStatus) .WhereIF(!string.IsNullOrEmpty(input.id), p => p.Id.Contains(input.id)) .WhereIF(!string.IsNullOrEmpty(input.mdbm), p => p.Mdbm.Contains(input.mdbm)) .WhereIF(!string.IsNullOrEmpty(input.djmdbh), p => p.Djmdbh.Contains(input.djmdbh)) .WhereIF(!string.IsNullOrEmpty(input.djmd), p => p.Djmd.Contains(input.djmd)) .WhereIF(!string.IsNullOrEmpty(input.dm), p => p.Dm.Contains(input.dm) || p.Djmd.Contains(input.dm)) .WhereIF(!string.IsNullOrEmpty(input.cs), p => p.Cs.Contains(input.cs)) .WhereIF(!string.IsNullOrEmpty(input.dz), p => p.Dz.Contains(input.dz)) .WhereIF(!string.IsNullOrEmpty(input.xm), p => p.Xm.Contains(input.xm)) .WhereIF(!string.IsNullOrEmpty(input.dhhm), p => p.Dhhm.Contains(input.dhhm)) .WhereIF(!string.IsNullOrEmpty(input.zj), p => p.Zj.Contains(input.zj)) .WhereIF(queryKysj != null, p => p.Kysj >= new DateTime(startKysj.ToDate().Year, startKysj.ToDate().Month, startKysj.ToDate().Day, 0, 0, 0)) .WhereIF(queryKysj != null, p => p.Kysj <= new DateTime(endKysj.ToDate().Year, endKysj.ToDate().Month, endKysj.ToDate().Day, 23, 59, 59)) .WhereIF(!string.IsNullOrEmpty(input.zxzt), p => p.Zxzt.Equals(input.zxzt)) .WhereIF(!string.IsNullOrEmpty(input.gsmc), p => p.Gsmc.Contains(input.gsmc)) .WhereIF(!string.IsNullOrEmpty(input.fr), p => p.Fr.Contains(input.fr)) .WhereIF(!string.IsNullOrEmpty(input.ywsb), p => p.Ywsb.Equals(input.ywsb)) .Select(it => new LqMdxxListOutput { id = it.Id, mdbm = it.Mdbm, djmdbh = it.Djmdbh, djmd = it.Djmd, dm = it.Dm, cs = it.Cs, dz = it.Dz, xm = it.Xm, dhhm = it.Dhhm, zj = it.Zj, kysj = it.Kysj, zxzt = it.Zxzt, gsmc = it.Gsmc, fr = it.Fr, ywsb = it.Ywsb, jyb = it.Jyb, kjb = it.Kjb, dxmb = it.Dxmb, syb = it.Syb, gsqssj = it.Gsqssj, gszzsj = it.Gszzsj, status = it.Status, xsyj = it.Xsyj, xhyj = it.Xhyj, xms = it.Xms, rt1 = it.Rt1, rt2 = it.Rt2, rc = it.Rc, storeCategory = it.StoreCategory, storeType = it.StoreType, zzrs = it.Zzrs, storeImages = it.StoreImages, storeDescription = it.StoreDescription, storeTags = it.StoreTags, businessHours = it.BusinessHours, trafficTips = it.TrafficTips, }).MergeTable().OrderBy(sidx + " " + input.sort).ToListAsync(); return data; } #endregion #region 导出门店信息 /// /// 导出门店信息 /// /// 请求参数 /// [HttpGet("Actions/Export")] public async Task Export([FromQuery] LqMdxxListQueryInput input) { var userInfo = await _userManager.GetUserInfo(); var exportData = new List(); if (input.dataType == 0) { var data = Clay.Object(await this.GetList(input)); exportData = data.Solidify>().list; } else { exportData = await this.GetNoPagingList(input); } List paramList = "[{\"value\":\"主键\",\"field\":\"id\"},{\"value\":\"门店编码\",\"field\":\"mdbm\"},{\"value\":\"单据门店编号\",\"field\":\"djmdbh\"},{\"value\":\"单据门店\",\"field\":\"djmd\"},{\"value\":\"店名\",\"field\":\"dm\"},{\"value\":\"城市\",\"field\":\"cs\"},{\"value\":\"地址\",\"field\":\"dz\"},{\"value\":\"姓名\",\"field\":\"xm\"},{\"value\":\"电话号码\",\"field\":\"dhhm\"},{\"value\":\"座机\",\"field\":\"zj\"},{\"value\":\"开业时间\",\"field\":\"kysj\"},{\"value\":\"最新状态\",\"field\":\"zxzt\"},{\"value\":\"工商名称\",\"field\":\"gsmc\"},{\"value\":\"法人\",\"field\":\"fr\"},{\"value\":\"有无社保\",\"field\":\"ywsb\"},{\"value\":\"在职人数\",\"field\":\"zzrs\"},{\"value\":\"门店介绍\",\"field\":\"storeDescription\"},{\"value\":\"门店标签\",\"field\":\"storeTags\"},{\"value\":\"营业时间设置\",\"field\":\"businessHours\"},{\"value\":\"交通提示\",\"field\":\"trafficTips\"}]".ToList(); ExcelConfig excelconfig = new ExcelConfig(); excelconfig.FileName = "门店信息.xls"; excelconfig.HeadFont = "微软雅黑"; excelconfig.HeadPoint = 10; excelconfig.IsAllSizeColumn = true; excelconfig.ColumnModel = new List(); List selectKeyList = input.selectKey.Split(',').ToList(); foreach (var item in selectKeyList) { var isExist = paramList.Find(p => p.field == item); if (isExist != null) { excelconfig.ColumnModel.Add(new ExcelColumnModel() { Column = isExist.field, ExcelColumn = isExist.value }); } } var addPath = FileVariable.TemporaryFilePath + excelconfig.FileName; ExcelExportHelper.Export(exportData, excelconfig, addPath); await TryWriteBusinessLogAsync( "门店信息", "导出门店信息", "lq_mdxx", null, $"导出门店信息,共 {exportData.Count} 条", JsonConvert.SerializeObject(new { filters = new { input.mdbm, input.dm, input.cs, input.zxzt, input.dataType }, rowCount = exportData.Count, fileName = excelconfig.FileName })); var fileName = _userManager.UserId + "|" + addPath + "|xls"; var output = new { name = excelconfig.FileName, url = "/api/File/Download?encryption=" + DESCEncryption.Encrypt(fileName, "NCC") }; return output; } #endregion #region 批量删除门店信息 /// /// 批量标记删除门店信息(软删除,将 status 置为无效) /// /// 主键数组 /// [HttpPost("batchRemove")] public async Task BatchRemove([FromBody] List ids) { var entitys = await _db.Queryable() .In(it => it.Id, ids) .Where(p => p.Status == null || p.Status != InvalidStatus) .ToListAsync(); if (entitys.Count == 0) return; var deleteSnapshots = entitys .Select(entity => new { Entity = entity, BeforeStatus = entity.Status }) .ToList(); try { _db.BeginTran(); foreach (var snapshot in deleteSnapshots) { snapshot.Entity.Status = InvalidStatus; } var isOk = await _db.Updateable(entitys).UpdateColumns(it => new { it.Status }).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1001); foreach (var snapshot in deleteSnapshots) { await _storeProfileVersionAppender.AfterStorePersistedAsync(snapshot.Entity.Id, "STORE_STATUS_UPDATE"); } _db.CommitTran(); } catch (Exception) { _db.RollbackTran(); throw NCCException.Oh(ErrorCode.COM1002); } // 事务提交成功后再写业务日志,避免回滚后仍留下日志 foreach (var snapshot in deleteSnapshots) { try { await _businessOperationLogService.WriteAsync( "门店信息", "批量删除", "lq_mdxx", snapshot.Entity.Id, $"批量删除门店:{GetStoreDisplayName(snapshot.Entity)}(ID:{snapshot.Entity.Id})", BuildStoreDeleteDetailJson(snapshot.Entity, snapshot.BeforeStatus)); } catch (Exception) { // 写日志失败不拖垮主业务 } } } #endregion #region 更新门店信息 /// /// 更新门店信息 /// /// 主键 /// 参数 /// [HttpPut("{id}")] public async Task Update(string id, [FromBody] LqMdxxUpInput input) { var before = await _db.Queryable().FirstAsync(p => p.Id == id); _ = before ?? throw NCCException.Oh(ErrorCode.COM1005); var entity = input.Adapt(); entity.Id = id; // 设置主键ID var isOk = await _db.Updateable(entity).IgnoreColumns(ignoreAllNullColumns: true).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1001); await _storeProfileVersionAppender.AfterStorePersistedAsync(id, "STORE_UPDATE"); await TryWriteBusinessLogAsync( "门店信息", "修改门店", "lq_mdxx", id, $"修改门店:{GetStoreDisplayName(before)}(ID:{id})", JsonConvert.SerializeObject(new { before = new { before.Id, before.Mdbm, before.Dm, before.Cs, before.Zxzt }, after = new { entity.Mdbm, entity.Dm, entity.Cs, entity.Zxzt } })); } #endregion #region 更新门店目标字段 /// /// 更新门店目标字段 /// /// 主键 /// 目标字段参数 /// [HttpPut("{id}/targets")] public async Task UpdateTargets(string id, [FromBody] LqMdxxTargetUpdateInput input) { var before = await _db.Queryable().FirstAsync(p => p.Id == id); _ = before ?? throw NCCException.Oh(ErrorCode.COM1005); var isOk = await _db.Updateable() .SetColumns(it => new LqMdxxEntity { Xsyj = input.xsyj, Xhyj = input.xhyj, Xms = input.xms, Rt1 = input.rt1, Rt2 = input.rt2, Rc = input.rc }) .Where(x => x.Id == id) .ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1001); await _storeProfileVersionAppender.AfterStorePersistedAsync(id, "STORE_TARGETS_UPDATE"); await TryWriteBusinessLogAsync( "门店信息", "修改门店目标", "lq_mdxx", id, $"修改门店目标字段(ID:{id})", JsonConvert.SerializeObject(new { before = new { before.Xsyj, before.Xhyj, before.Xms, before.Rt1, before.Rt2, before.Rc }, after = new { input.xsyj, input.xhyj, input.xms, input.rt1, input.rt2, input.rc } })); } #endregion #region 删除门店信息 /// /// 标记删除门店信息(软删除,将 status 置为无效) /// /// [HttpDelete("{id}")] public async Task Delete(string id) { var entity = await _db.Queryable().FirstAsync(p => p.Id == id); _ = entity ?? throw NCCException.Oh(ErrorCode.COM1005); if (entity.Status == InvalidStatus) throw NCCException.Oh("该门店已标记删除"); var beforeStatus = entity.Status; entity.Status = InvalidStatus; var isOk = await _db.Updateable(entity).UpdateColumns(it => new { it.Status }).ExecuteCommandAsync(); if (!(isOk > 0)) throw NCCException.Oh(ErrorCode.COM1001); await _storeProfileVersionAppender.AfterStorePersistedAsync(id, "STORE_STATUS_UPDATE"); try { await _businessOperationLogService.WriteAsync( "门店信息", "删除", "lq_mdxx", id, $"删除门店:{GetStoreDisplayName(entity)}(ID:{id})", BuildStoreDeleteDetailJson(entity, beforeStatus)); } catch (Exception) { // 写日志失败不拖垮主业务 } } #endregion #region 获取门店下拉选择数据 /// /// 获取门店下拉选择数据 /// /// [HttpGet("Selector")] public async Task GetSelector() { var list = await _db.Queryable() .Where(it => it.Zxzt == "开店") .Where(p => p.Status == null || p.Status != InvalidStatus) .Select(it => new { id = it.Id, fullName = it.Dm, enCode = it.Mdbm }) .ToListAsync(); return new { list = list }; } #endregion #region 获取门店类别下拉选择数据 /// /// 获取门店类别下拉选择数据 /// /// [HttpGet("Selector/StoreCategory")] public List GetStoreCategorySelector() { return Enum.GetValues().Select(e => new EnumOutput { Value = (int)e, Name = e.ToString(), Description = e.GetDescription(), }).ToList(); } #endregion #region 获取门店类型下拉选择数据 /// /// 获取门店类型下拉选择数据 /// /// [HttpGet("Selector/StoreType")] public List GetStoreTypeSelector() { //从Enum中获取门店类型 var storeTypeEnum = Enum.GetValues() .Select(e => new EnumOutput { Value = (int)e, Name = e.ToString(), Description = e.GetDescription(), }) .ToList(); return storeTypeEnum; } #endregion private static string GetStoreDisplayName(LqMdxxEntity entity) { return entity.Dm ?? entity.Djmd ?? entity.Mdbm ?? entity.Id; } private static string BuildStoreDeleteDetailJson(LqMdxxEntity entity, int? beforeStatus) { return new { before = new { entity.Id, entity.Mdbm, entity.Dm, entity.Djmd, entity.Cs, status = beforeStatus }, after = new { status = InvalidStatus } }.Serialize(); } private async Task TryWriteBusinessLogAsync(string moduleCode, string actionCode, string bizType, string bizId, string summary, string detailJson = null) { try { await _businessOperationLogService.WriteAsync(moduleCode, actionCode, bizType, bizId, summary, detailJson); } catch (Exception) { // 写日志失败不拖垮主业务 } } } }