コード例 #1
0
        public Report GetFilteredTicketsReportBulk(Filters filters)
        {
            using (var scope = _scopeFactory.CreateScope())
            {
                var db = scope.ServiceProvider.GetRequiredService <ApplicationDbContext>();
                List <TicketReportDTO> ticketReportDTOs = new List <TicketReportDTO>();
                var tickets = (from ticket in db.Ticket
                               where ticket.CreateTime.CompareTo(filters.Period.startTime) > 0 &&
                               ticket.CreateTime.CompareTo(filters.Period.endTime) < 0
                               select ticket)
                              .Include(ticket => ticket.TicketState)
                              .Include(ticket => ticket.Queue)
                              .Include(ticket => ticket.TicketPriority)
                              .ToList().Where(t => !t.Queue.Name.Equals("Trash"));

                var ttsDynamicFields = GetTTDynamicFieldsBulk((from ticket in tickets select ticket.Id).ToList());

                FilteringItems filteringItems = new FilteringItems();

                var zones       = ttsDynamicFields.Select(p => p.Value).ToList().SelectValues("Zone").Distinct().ToList();
                var types       = ttsDynamicFields.Select(p => p.Value).ToList().SelectValues("Type").Distinct().ToList();
                var direction   = ttsDynamicFields.Select(p => p.Value).ToList().SelectValues("Direction").Distinct().ToList();
                var natInt      = ttsDynamicFields.Select(p => p.Value).ToList().SelectValues("NatInt").Distinct().ToList();
                var initiator   = ttsDynamicFields.Select(p => p.Value).ToList().SelectValues("Initiator").Distinct().ToList();
                var category    = ttsDynamicFields.Select(p => p.Value).ToList().SelectValues("Category").Distinct().ToList();
                var problemSide = ttsDynamicFields.Select(p => p.Value).ToList().SelectValues("ProblemSide").Distinct().ToList();



                filteringItems.States           = tickets.Select(ticket => ticket.TicketState.Name).Distinct().OrderByDescending(state => state).toSelectItems();
                filteringItems.TicketPriorities = tickets.Select(ticket => ticket.TicketPriority.Name).Distinct().OrderByDescending(ticketPriority => ticketPriority).toSelectItems();
                filteringItems.Zones            = zones.Count > 0 ? zones.toSelectItems() : null;
                filteringItems.Types            = types.Count > 0 ? types.toSelectItems() : null;
                filteringItems.Directions       = direction.Count > 0 ? direction.toSelectItems() : null;
                filteringItems.NatInts          = natInt.Count > 0 ? natInt.toSelectItems() : null;
                filteringItems.Initiators       = initiator.Count > 0 ? initiator.toSelectItems() : null;
                filteringItems.Categories       = category.Count > 0 ? category.toSelectItems() : null;
                filteringItems.ProblemSides     = problemSide.Count > 0 ? problemSide.toSelectItems() : null;

                foreach (var ticket in tickets)
                {
                    TicketReportDTO ticketReportDTO = new TicketReportDTO();
                    ticketReportDTO.TN             = ticket.Tn;
                    ticketReportDTO.State          = ticket.TicketState.Name;
                    ticketReportDTO.CreateTime     = ticket.CreateTime;
                    ticketReportDTO.Client         = ticket.CustomerId;
                    ticketReportDTO.TicketPriority = ticket.TicketPriority.Name;
                    var dFields = ttsDynamicFields[ticket.Id];
                    if (dFields.Count > 0)
                    {
                        foreach (var field in dFields)
                        {
                            typeof(TicketReportDTO).GetProperty(field.Key)?.SetValue(ticketReportDTO, !field.Key.Equals("CloseTime") ? field.Value : DateTime.Parse(field.Value));
                        }
                    }
                    if (IsTicketDTOValid(ticketReportDTO, filters))
                    {
                        ticketReportDTOs.Add(ticketReportDTO);
                    }
                }

                return(new Report()
                {
                    ticketReportDTOs = ticketReportDTOs.OrderByDescending(ticket => ticket.CreateTime),
                    filteringItems = filteringItems
                });
            }
        }
コード例 #2
0
 //Category
 public FilteringItems GetFilteringItems(Period period)
 {
     using (var scope = _scopeFactory.CreateScope())
     {
         var db = scope.ServiceProvider.GetRequiredService <ApplicationDbContext>();
         List <TicketReportDTO> ticketReportDTOs = new List <TicketReportDTO>();
         var tickets = (from ticket in db.Ticket
                        where ticket.CreateTime.CompareTo(period.startTime.ToLocalTime()) > 0 &&
                        ticket.CreateTime.CompareTo(period.endTime.ToLocalTime()) < 0
                        select ticket)
                       .Include(ticket => ticket.TicketState)
                       .Include(ticket => ticket.Queue)
                       .Include(ticket => ticket.TicketPriority)
                       .ToList();
         var states       = tickets.Select(ticket => ticket.TicketState.Name).Distinct().OrderByDescending(state => state).toSelectItems();
         var priorities   = tickets.Select(ticket => ticket.TicketPriority.Name).Distinct().OrderByDescending(ticketPriority => ticketPriority).toSelectItems();
         var zones        = new List <string>();
         var types        = new List <string>();
         var directions   = new List <string>();
         var natInts      = new List <string>();
         var initiators   = new List <string>();
         var categories   = new List <string>();
         var problemSides = new List <string>();
         foreach (var ticket in tickets)
         {
             var dfields = GetTTDynamicFields(ticket.Id);
             if (dfields.Count > 0)
             {
                 if (dfields.ContainsKey("Zone") && !String.IsNullOrEmpty(dfields["Zone"]))
                 {
                     zones.Add(dfields["Zone"]);
                 }
                 if (dfields.ContainsKey("Type") && !String.IsNullOrEmpty(dfields["Type"]))
                 {
                     types.Add(dfields["Type"]);
                 }
                 if (dfields.ContainsKey("Direction") && !String.IsNullOrEmpty(dfields["Direction"]))
                 {
                     directions.Add(dfields["Direction"]);
                 }
                 if (dfields.ContainsKey("NatInt") && !String.IsNullOrEmpty(dfields["NatInt"]))
                 {
                     natInts.Add(dfields["NatInt"]);
                 }
                 if (dfields.ContainsKey("Initiator") && !String.IsNullOrEmpty(dfields["Initiator"]))
                 {
                     initiators.Add(dfields["Initiator"]);
                 }
                 if (dfields.ContainsKey("Category") && !String.IsNullOrEmpty(dfields["Category"]))
                 {
                     initiators.Add(dfields["Category"]);
                 }
                 if (dfields.ContainsKey("ProblemSide") && !String.IsNullOrEmpty(dfields["ProblemSide"]))
                 {
                     initiators.Add(dfields["ProblemSide"]);
                 }
             }
         }
         var filteringItems = new FilteringItems()
         {
             Directions       = directions.Distinct().OrderByDescending(name => name).toSelectItems(),
             Initiators       = initiators.Distinct().OrderByDescending(name => name).toSelectItems(),
             Types            = types.Distinct().OrderByDescending(name => name).toSelectItems(),
             Zones            = zones.Distinct().OrderByDescending(name => name).toSelectItems(),
             NatInts          = natInts.Distinct().OrderByDescending(name => name).toSelectItems(),
             States           = states,
             TicketPriorities = priorities,
             Categories       = categories.Distinct().OrderByDescending(name => name).toSelectItems(),
             ProblemSides     = problemSides.Distinct().OrderByDescending(name => name).toSelectItems()
         };
         return(filteringItems);
     }
 }