using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using Microsoft.AspNetCore.Mvc; using MadRunFabric.Common; using Microsoft.AspNetCore.Authorization; using Microsoft.Extensions.Logging; using WorkOrderApi.IRepositories; using WorkOrderApi.Input; using MadRunFabric.Model.WorkOrderApi; using System.Security.Claims; using MongoDB.Driver; using Microsoft.Extensions.Configuration; using SignTokenApi.IRepositories; namespace WorkOrderApi.Areas.Hy_Order.Controllers { /// /// 工单 - 售后管理系统 /// [Authorize] [ApiVersion("6.0")] [Route("api/[controller]")] [Produces("application/json")] public class BaseWorkOrderController : BaseController { private readonly ILogger _logger; private readonly IBus_WorkOrder_BaseRepository _bus_workorder_baseRepository; private readonly IBus_WorkOrder_ItemRepository _bus_workorder_itemRepository; private readonly IBus_Msg_ListRepository _bus_msg_listRepository; private readonly IConfiguration _configuration; private readonly ISys_User_AccountRepository _sys_user_accountRepository; public BaseWorkOrderController( ILogger logger, IBus_WorkOrder_BaseRepository bus_workorder_baseRepository, IBus_WorkOrder_ItemRepository bus_workorder_itemRepository, IBus_Msg_ListRepository bus_msg_listRepository, IConfiguration configuration, ISys_User_AccountRepository sys_user_accountRepository ) { _logger = logger; _bus_workorder_baseRepository = bus_workorder_baseRepository; _bus_workorder_itemRepository = bus_workorder_itemRepository; _bus_msg_listRepository = bus_msg_listRepository; _configuration = configuration; _sys_user_accountRepository = sys_user_accountRepository; } /// /// 获取工单分页 /// [HttpGet("getlistbypage")] public IActionResult GetListsByPageAsync(string ordercode, string keyword, string phone, string province, string city, string sourceid, string typeid, string deptid, string stime, string etime, int state = -1, int pageindex = 1, int pagesize = 10) { int recordCount = 0; var result = _bus_workorder_baseRepository.GetListsByPage(ordercode, keyword, phone, province, city, sourceid, typeid, deptid, stime, etime, state, pageindex, pagesize, out recordCount); var obj = new { rows = result.ToList(), total = recordCount }; return Success("获取成功", obj); } /// /// 获取工单详情 /// [HttpGet("getsingle")] public async Task GetSingleAsync(string ordercode) { var cls = await _bus_workorder_baseRepository.Get(p => p.ordercode == ordercode && p.isdelete == 0); var clmodel = cls.FirstOrDefault(); if (clmodel != null) { var model = _bus_workorder_baseRepository.GetDetails(ordercode); var item = await _bus_workorder_itemRepository.Get(s => s.ordercode.Equals(clmodel.ordercode) & s.isdelete == 0); var obj = new { model, item, }; return Success("获取成功", obj); } else return Error("获取失败"); } /// /// 添加工单 /// [HttpPost("add")] public async Task AddAsync(WorkOrderInput input) { #region 判断验证 if (string.IsNullOrWhiteSpace(input.name)) return Error("请输入客户姓名"); if (string.IsNullOrEmpty(input.phone)) return Error("请输入客户电话"); //if (string.IsNullOrEmpty(input.content)) // return Error("请输入内容"); #endregion string usercode = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; string username = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Name).Value; var model = new Bus_WorkOrder_Base(); #region model 添加工单对象 model.unique_id = input.unique_id; model.ordercode = DateTime.Now.ToString("yyyyMMddHHmmssfff"); //工单编号 - 时间戳 model.callrecordid = input.callrecordid; model.typeid = input.typeid; model.state = (int)EnumOrderType.create; //工单状态:0未处理,1已处理 model.customerid = input.customerid; model.name = input.name; model.company = input.company; model.callintel = input.callintel; model.phone = input.phone; model.province = input.province; //省 model.city = input.city; //市 model.proid = input.proid; model.projectname = input.projectname; model.address = input.address; model.faulty_equipment = input.faulty_equipment; model.content = input.content; model.faulty_typeid = input.faulty_typeid; model.faulty_type2id = input.faulty_type2id; model.sourceid = input.sourceid; model.productive = input.productive; model.deptid = input.deptid; model.createuser = usercode; model.createusername = username; model.createtime = DateTime.Now; model.touser = input.touser; model.businesstype = input.businesstype; model.dealinstantly = input.dealinstantly; model.iseffective = input.iseffective; #endregion bool bl = await _bus_workorder_baseRepository.Add(model); if (bl) { #region 添加item var modelb = new Bus_WorkOrder_Item(); #region model 添加工单对象 modelb.ordercode = model.ordercode;//DateTime.Now.ToString("yyyyMMddHHmmssfff"); //工单编号 - 时间戳 modelb.typeid = input.typeid; modelb.state = (int)EnumOrderType.create; //工单状态:0未处理,1已处理 modelb.createuser = usercode; modelb.createusername = username; modelb.createtime = DateTime.Now; #endregion bool b = await _bus_workorder_itemRepository.Add(modelb); #endregion AddItems(model.ordercode, model.state, usercode + "(" + username + ") 创建", usercode, username); return Success("保存成功"); } else return Error("保存失败"); } /// /// 修改工单 /// [HttpPost("update")] public async Task UpdateAsync(WorkOrderInput input) { string usercode = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; string username = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Name).Value; var model = (await _bus_workorder_baseRepository.Get(p => p.ordercode == input.ordercode && p.isdelete == 0)).FirstOrDefault(); if (model != null && model.createuser == usercode && model.state == (int)EnumOrderType.create) { #region 判断验证 if (string.IsNullOrWhiteSpace(input.name)) return Error("请输入客户姓名"); if (string.IsNullOrEmpty(input.callintel)) return Error("请输入来电电话"); //if (string.IsNullOrEmpty(input.content)) // return Error("请输入内容"); #endregion #region model 添加工单对象 model.typeid = input.typeid; model.name = input.name; model.company = input.company; model.phone = input.phone; model.province = input.province; //省 model.city = input.city; //市 model.projectname = input.projectname; model.address = input.address; model.faulty_equipment = input.faulty_equipment; model.content = input.content; model.faulty_typeid = input.faulty_typeid; model.faulty_type2id = input.faulty_type2id; model.sourceid = input.sourceid; model.productive = input.productive; model.dealinstantly = input.dealinstantly; model.iseffective = input.iseffective; model.deptid = input.deptid; model.touser = input.touser; model.businesstype = input.businesstype; #endregion bool b = await _bus_workorder_baseRepository.UpdateOne(model); if (b) { AddItems(model.ordercode, model.state, usercode + "(" + username + ") 修改", usercode, username); return Success("保存成功"); } else return Error("保存失败"); } return Error("操作失败"); } /// /// 处理 /// [HttpPost("deal")] public async Task DealAsync(string ordercode, string result) { string usercode = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; string username = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Name).Value; #region 判断验证 if (string.IsNullOrWhiteSpace(ordercode)) return Error("参数错误"); if (string.IsNullOrWhiteSpace(result)) return Error("请输入处理结果"); #endregion var model = (await _bus_workorder_baseRepository.Get(p => p.ordercode == ordercode && p.isdelete == 0)).FirstOrDefault(); if (model != null && model.state == (int)EnumOrderType.create) { model.state = (int)EnumOrderType.complete; model.dealuser = usercode; model.dealusername = username; model.result = result; model.dealtime = DateTime.Now; await _bus_workorder_baseRepository.UpdateOne(model); AddItems(model.ordercode, model.state, usercode + "(" + username + ") 处理,结果:" + result, usercode, username); return Success("处理成功"); } return Error("处理失败"); } /// /// 删除工单 /// /// /// [HttpPost("delete")] public async Task DeleteAsync(string[] ids) { string usercode = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; string username = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Name).Value; //使用逻辑删除 var res = 0; if (ids != null && ids.Length > 0) { foreach (var id in ids) { var model = await _bus_workorder_baseRepository.GetSingle(id); model.isdelete = 1; model.deleteuser = usercode; model.deletetime = DateTime.Now; if (await _bus_workorder_baseRepository.UpdateOne(model)) { res += 1; AddItems(model.ordercode, model.state, usercode + "(" + username + ") 删除", usercode, username); } } if (res == ids.Length) return Success("删除成功"); else if (res > 0 && res < ids.Length) return Error("部分删除失败"); else return Error("删除失败"); } else return Error("请选择要删除的记录"); } /// /// 添加操作记录 /// /// 编号 /// 状态 /// 处理说明 /// 当前操作人 /// 当前操作人姓名 private async void AddItems(string ordercode, int state, string detail, string usercode, string username) { var model = new Bus_Msg_List(); model.ordercode = ordercode; model.state = state; model.createuser = usercode; model.createusername = username; model.createtime = DateTime.Now; model.detail = detail; await _bus_msg_listRepository.Add(model); } /// /// 获取工单动态 /// [HttpGet("getdt")] public async Task GetDTAsync(string ordercode) { var cls = await _bus_msg_listRepository.Get(p => p.ordercode == ordercode && p.isdelete == 0); if (cls != null) { return Success("获取成功", cls); } else return Error("获取失败"); } //2019-5-7添加工单指派 /// /// 获取待指派工单 /// [HttpGet("getdzplist")] public IActionResult GetDZPListAsync(string ordercode, string keyword, string phone, string province, string city, string sourceid, string typeid, string deptid, string stime, string etime, int state = -1, int pageindex = 1, int pagesize = 10) { string usercode = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; var list = _sys_user_accountRepository.Get(x => x.usercode == usercode && x.delete_flag == false); if (list.Result != null) { foreach (var item in list.Result) { int seatright = item.seat_right; if (seatright == 1) { usercode = ""; } } } int recordcount = 0; //var result = _bus_workorder_baseRepository.GetOrderListsByPage("", "", "", "", 0, "", "", "", "", pageindex, pagesize, out recordcount); var result = _bus_workorder_baseRepository.GetOrderListsByPage("", "", "", "", 0, "", "", "", usercode, phone, province, city, sourceid, typeid, deptid, pageindex, pagesize, out recordcount, 0); var obj = new { rows = result.ToList(), total = recordcount }; return Success("获取成功", obj); } /// /// 获取待接单列表 /// /// [HttpGet("getdjdlist")] public IActionResult GetDJDListAsync(string ordercode, string keyword, string phone, string province, string city, string sourceid, string typeid, string deptid, string stime, string etime, int state = -1, int pageindex = 1, int pagesize = 10) { string usercode = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; var list = _sys_user_accountRepository.Get(x => x.usercode == usercode && x.delete_flag == false); if (list.Result != null) { foreach (var item in list.Result) { int seatright = item.seat_right; if (seatright == 1) { usercode = ""; } } } int recordcount = 0; //var result = _bus_workorder_baseRepository.GetOrderListsByPage("","","","",2,"" ,"","","", pageindex, pagesize,out recordcount); var result = _bus_workorder_baseRepository.GetOrderListsByPage("", "", "", "", 2, usercode, "", "", "", phone, province, city, sourceid, typeid, deptid, pageindex, pagesize, out recordcount, 0); var obj = new { rows = result.ToList(), total = recordcount }; return Success("获取成功", obj); } /// /// 获取待处理列表 /// /// [HttpGet("getdcllist")] public IActionResult GetDCLListAsync(string ordercode, string keyword, string phone, string province, string city, string sourceid, string typeid, string deptid, string stime, string etime, int state = -1, int pageindex = 1, int pagesize = 10) { string usercode = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; var list = _sys_user_accountRepository.Get(x => x.usercode == usercode && x.delete_flag == false); if (list.Result != null) { foreach (var item in list.Result) { int seatright = item.seat_right; if (seatright == 1) { usercode = ""; } } } int recordcount = 0; //var result = _bus_workorder_baseRepository.GetOrderListsByPage("", "", "", "", 3,"", "", "", "", pageindex, pagesize, out recordcount); var result = _bus_workorder_baseRepository.GetOrderListsByPage("", "", "", "", 3, "", usercode, "", "", phone, province, city, sourceid, typeid, deptid, pageindex, pagesize, out recordcount, 0); var obj = new { rows = result.ToList(), total = recordcount }; return Success("获取成功", obj); } /// /// 获取已处理列表 /// /// [HttpGet("getycllist")] public IActionResult GetYCLListAsync(string ordercode, string keyword, string phone, string province, string city, string sourceid, string typeid, string deptid, string stime, string etime, int state = -1, int pageindex = 1, int pagesize = 10) { string usercode = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; var list = _sys_user_accountRepository.Get(x => x.usercode == usercode && x.delete_flag == false); if (list.Result != null) { foreach (var item in list.Result) { int seatright = item.seat_right; if (seatright == 1) { usercode = ""; } } } int recordcount = 0; //var result = _bus_workorder_baseRepository.GetOrderListsByPage("", "", "", "", 9, "", "", "", "", pageindex, pagesize, out recordcount); var result = _bus_workorder_baseRepository.GetOrderListsByPage("", "", "", "", 9, "", usercode, "", "", phone, province, city, sourceid, typeid, deptid, pageindex, pagesize, out recordcount, 0); var obj = new { rows = result.ToList(), total = recordcount }; return Success("获取成功", obj); } /// /// 处理工单 /// [HttpPost("dealorder")] public async Task DealWAsync(string ordercode, string result, string touser, string todept, string helper, string helpcontent, int dealtype = 0)//dealtype为0时指派,为1时接单,为2时处理,3为撤回,4为退回 { string usercode = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; string username = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Name).Value; #region 判断验证 if (string.IsNullOrWhiteSpace(ordercode)) return Error("参数错误"); //if (string.IsNullOrWhiteSpace(result)) // return Error("请输入处理结果"); #endregion var model0 = (await _bus_workorder_baseRepository.Get(p => p.ordercode == ordercode && p.isdelete == 0)).FirstOrDefault(); if (model0 != null && dealtype == 0)//指派工单model0.state == (int)EnumOrderType.create { if (model0.zptime == null || model0.zptime.ToString() == "")//记录指派时间用于计算工单时效 { model0.zptime = DateTime.Now; } model0.zpusercode = usercode; model0.state = (int)EnumOrderType.appoint; await _bus_workorder_baseRepository.UpdateOne(model0); var model = (await _bus_workorder_itemRepository.Get(p => p.ordercode == ordercode && p.isdelete == 0)).FirstOrDefault(); if (model != null) { model.state = (int)EnumOrderType.appoint; model.touser = touser; model.todept = todept; model.zpcontent = result; model.zptime = DateTime.Now; model.zpusercode = usercode; await _bus_workorder_itemRepository.UpdateOne(model); } AddItems(model.ordercode, model.state, usercode + "向" + touser + "指派了工单:" + ordercode, usercode, username); return Success("指派成功"); } else if (model0 != null && dealtype == 1) { model0.state = (int)EnumOrderType.accept; await _bus_workorder_baseRepository.UpdateOne(model0); var model = (await _bus_workorder_itemRepository.Get(p => p.ordercode == ordercode && p.isdelete == 0)).FirstOrDefault(); if (model != null) { model.state = (int)EnumOrderType.accept; model.sureuser = usercode; model.suretime = DateTime.Now; await _bus_workorder_itemRepository.UpdateOne(model); } AddItems(model.ordercode, model.state, usercode + "已接工单:" + ordercode, usercode, username); return Success("接单成功"); } else if (model0 != null && dealtype == 2) { model0.dealuser = usercode; model0.dealtime = DateTime.Now; model0.state = (int)EnumOrderType.complete; model0.result = result; await _bus_workorder_baseRepository.UpdateOne(model0); var model = (await _bus_workorder_itemRepository.Get(p => p.ordercode == ordercode && p.isdelete == 0)).FirstOrDefault(); if (model != null) { model.state = (int)EnumOrderType.complete; model.dealuser = usercode; model.dealtime = DateTime.Now; model.helper = helper; model.helpcontent = helpcontent; await _bus_workorder_itemRepository.UpdateOne(model); } AddItems(model.ordercode, model.state, usercode + "处理工单:" + ordercode, usercode, username); return Success("处理成功"); } else if (model0 != null && dealtype == 3)//撤回 { model0.state = (int)EnumOrderType.create; await _bus_workorder_baseRepository.UpdateOne(model0); var model = (await _bus_workorder_itemRepository.Get(p => p.ordercode == ordercode && p.isdelete == 0)).FirstOrDefault(); if (model != null) { model.state = (int)EnumOrderType.create; model.touser = ""; model.touser = ""; await _bus_workorder_itemRepository.UpdateOne(model); } AddItems(model.ordercode, model.state, usercode + "撤回工单:" + ordercode, usercode, username); return Success("撤回成功"); } else if (model0 != null && dealtype == 4)//退回 { model0.state = (int)EnumOrderType.create; await _bus_workorder_baseRepository.UpdateOne(model0); var model = (await _bus_workorder_itemRepository.Get(p => p.ordercode == ordercode && p.isdelete == 0)).FirstOrDefault(); if (model != null) { model.state = (int)EnumOrderType.create; model.touser = ""; model.touser = ""; await _bus_workorder_itemRepository.UpdateOne(model); } AddItems(model.ordercode, model.state, usercode + "退回工单:" + ordercode, usercode, username); return Success("退回成功"); } return Error("处理失败"); } //获取工单统计数据 #region 获取工单统计数据 /// /// 获取日周月年工单状态数量统计 /// [HttpGet("getworkorderstatecount")] public async Task GetWorkOrderStateCountReportAsync(int datetype = 0) { string optuser = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; string stime = string.Empty; string etime = string.Empty; if (datetype != 0) { GetStartEndTime(datetype, out stime, out etime); } //根据条件查询集合 var flist = new List>(); flist.Add(Builders.Filter.Eq("isdelete", 0)); var wwcflist = flist.ToList(); var ywcflist = flist.ToList(); if (!string.IsNullOrWhiteSpace(stime)) { wwcflist.Add(Builders.Filter.Gt("createtime", DateTime.Parse(stime.Trim()))); ywcflist.Add(Builders.Filter.Gt("dealtime", DateTime.Parse(stime.Trim()))); } if (!string.IsNullOrWhiteSpace(etime)) { wwcflist.Add(Builders.Filter.Lt("createtime", DateTime.Parse(etime.Trim()))); ywcflist.Add(Builders.Filter.Lt("dealtime", DateTime.Parse(etime.Trim()))); } wwcflist.Add(Builders.Filter.Eq("state", (int)EnumOrderType.create)); var wwcfilter = Builders.Filter.And(wwcflist); ywcflist.Add(Builders.Filter.Eq("state", (int)EnumOrderType.deal)); var ywcfilter = Builders.Filter.And(ywcflist); var wwccount = await _bus_workorder_baseRepository.CountAsync(wwcfilter); var ywccount = await _bus_workorder_baseRepository.CountAsync(ywcfilter); var obj = new { wwccount, ywccount }; return Success("获取成功", obj); } /// /// 获取日周月年工单类型统计 /// [HttpGet("getworkordertypecount")] public IActionResult GetWorkOrderTypeCountReport(int datetype = 0) { string optuser = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; string stime = string.Empty; string etime = string.Empty; if (datetype != 0) { GetStartEndTime(datetype, out stime, out etime); } var result = _bus_workorder_baseRepository.GetWorkOrderTypeCountReport(stime, etime, optuser); return Success("获取成功", result); } /// /// 获取日周月年工单来源统计 /// [HttpGet("getworkordersourcecount")] public IActionResult GetWorkOrderSourceCountReport(int datetype = 0) { string optuser = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; string stime = string.Empty; string etime = string.Empty; if (datetype != 0) { GetStartEndTime(datetype, out stime, out etime); } var result = _bus_workorder_baseRepository.GetWorkOrderSourceCountReport(stime, etime, optuser); return Success("获取成功", result); } /// /// 获取日周月年工单24小时统计 /// [HttpGet("getworkorder24count")] public IActionResult GetWorkOrder24CountReport(int datetype = 0) { string optuser = User.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Sid).Value; if (optuser == "8000") { optuser = "";//8000帐号可以查看所有数据 } string stime = string.Empty; string etime = string.Empty; if (datetype != 0) { GetStartEndTime(datetype, out stime, out etime); } var result = _bus_workorder_baseRepository.GetWorkOrder24CountReport(stime, etime, optuser); return Success("获取成功", result); } /// /// 获取用户工单排行榜 /// [HttpGet("getusercountrank")] public IActionResult GetUserCountRank(int top = 0, int datetype = 0) { string stime = string.Empty; string etime = string.Empty; if (datetype != 0) { GetStartEndTime(datetype, out stime, out etime); } var result = _bus_workorder_baseRepository.GetUserCountRank(top, stime, etime); return Success("获取成功", result); } /// /// 获取当天、本周、本月、本年、累计时间 /// /// /// /// public void GetStartEndTime(int datetype, out string start, out string end) { start = string.Empty; end = string.Empty; var datenow = DateTime.Now; var datestart = datenow; var dateend = datenow; switch (datetype) { case 1://当天 break; case 2://本周 int n = (int)datenow.DayOfWeek == 0 ? 7 : (int)datenow.DayOfWeek; datestart = datenow.AddDays(1 - n);//本周周一 dateend = datestart.AddDays(6);//本周周日 break; case 3://本月 datestart = datenow.AddDays(1 - datenow.Day); //本月月初 dateend = datestart.AddMonths(1).AddDays(-1); //本月月末 break; case 4://本年 datestart = new DateTime(datenow.Year, 1, 1); //本年年初 dateend = new DateTime(datenow.Year, 12, 31); //本年年末 break; default: break; } start = datestart.ToString("yyyy-MM-dd") + " 00:00:00"; end = dateend.ToString("yyyy-MM-dd") + " 23:59:59"; } #endregion } }