public ReportChartDataModel GetCustomersBars(string business_id, [FromQuery] ReportDataFilter filter) { ReportChartDataModel model = new ReportChartDataModel { lines = new List <ChartDataLine>() }; IEnumerable <ReportChatDataLine> list = _reportService.GetCustomerChatChartData(business_id, filter).Result; var total = 0; var data = new int[] { list.Select(t => t.customers).Sum(), list.Select(t => t.inboxes).Sum(), list.Select(t => t.comments).Sum(), list.Select(t => t.inbox_replies).Sum(), list.Select(t => t.comment_replies).Sum() }; model.lines.Add(new ChartDataLine { data = data }); model.total = total; return(model); //{"lines": [{"name": "Phan Nhung", "data": [1, 1, 0]}, {"name": "\u0110o\u00e0n Nhi", "data": [1, 1, 0]}, {"name": "B\u00ecnh Tr\u1ecbnh", "data": [2, 1, 0]}, {"name": "Ti\u1ebfn Ph\u1ea1m", "data": [2, 1, 0]}, {"name": "H\u01b0ng C\u00f2ii", "data": [2, 1, 0]}, {"name": "Ha Nguyen", "data": [1, 1, 0]}, {"name": "S\u1eefu Ca", "data": [1, 1, 0]}, {"name": "\u0110inh Nghi\u1ec7p", "data": [2, 1, 0]}, {"name": "Baza Vietnam", "data": [0, 0, 0]}, {"name": "Qu\u1ef3nh Nh\u01b0", "data": [0, 0, 0]}]} //reports/customers_bar?date=range&init=1483203600000&finish=1485968399999&customer=43264%2C44410%2C39751%2C39754%2C39755%2C39759%2C39764%2C39791%2C39803%2C39821&page=1 }
public ReportChartDataModel GetTicketsBar(string business_id, [FromQuery] ReportDataFilter filter) { ReportChartDataModel model = new ReportChartDataModel { lines = new List <ChartDataLine>() }; IEnumerable <ReportTicketDataLine> list = _reportService.GetTicketChartData(business_id, filter).Result; var total = 0; var data = new int[] { list.Select(t => t.tickets).Sum(), list.Select(t => t.tickets - (t.completed_tickets + t.pending_tickets + t.attention_tickets)).Sum(), list.Select(t => t.pending_tickets).Sum(), list.Select(t => t.attention_tickets).Sum() }; model.lines.Add(new ChartDataLine { data = data }); model.total = total; return(model); //{"lines": [{"name": "2016-12-26", "data": [0, 0, 0]}, {"name": "2017-01-02", "data": [0, 0, 0]}, {"name": "2017-01-09", "data": [0, 0, 0]}, {"name": "2017-01-16", "data": [0, 0, 0]}, {"name": "2017-01-23", "data": [148, 0, 0]}, {"name": "2017-01-30", "data": [17, 0, 0]}]} //reports/orders_line?date=range&init=1483203600000&finish=1485968399999&period=week&page=1 }
public ReportChartDataModel GetAgentChartData(string business_id, [FromQuery] ReportDataFilter filter) { ReportChartDataModel model = new ReportChartDataModel { lines = new List <ChartDataLine>() }; IEnumerable <ReportAgentDataLine> list = _reportService.GetAgentChartData(business_id, filter).Result; foreach (var item in list) { //var data = string.Format("[{0}, {1}, {2}, {3}]", item.customers, item.conversations, item.messages, item.tickets); var data = new int[] { item.customers, item.conversations, item.messages, item.tickets }; model.lines.Add(new ChartDataLine { id = item.id, name = item.name, data = data }); model.total++; } return(model); //db_agents?date=range&init=1483203600000&finish=1488034801447&agent=1664%2C1815&period=month }
public ReportChartDataModel GetFirstResponseChartData(string business_id, [FromQuery] ReportDataFilter filter) { ReportChartDataModel model = new ReportChartDataModel { lines = new List <ChartDataLine>() }; IEnumerable <ReportResponseModel> list = _reportService.GetFirstResponseChartData(business_id, filter).Result; foreach (var item in list) { var data = string.Format("[{0}]", string.Join(",", new int[item.first_response_time])); model.lines.Add(new ChartDataLine { id = item.id, name = item.name, data = data }); } return(model); //{"total": 0, "lines": [{"name": "2016/12", "data": [0] }, {"name": "2017/1", "data": [497]}, {"name": "2017/2", "data": [23]}]} //reports/db_first_response?date=range&init=1483203600000&finish=1488038268796&samurai=1664%2C1815&period=month }
public ReportChartDataModel GetAgentsBars(string business_id, [FromQuery] ReportDataFilter filter) { filter.limit = 50; ReportChartDataModel model = new ReportChartDataModel { lines = new List <ChartDataLine>() }; IEnumerable <ReportAgentDataLine> list = _reportService.GetAgentChartData(business_id, filter).Result; foreach (var item in list) { var data = new int[] { item.customers, item.conversations, item.messages, item.tickets }; model.lines.Add(new ChartDataLine { id = item.id, name = item.name, data = data }); model.total++; } return(model); //{"lines": [{"name": "Human MM", "data": [497, 0, 0, 59]}, {"name": "Agent1 Bz", "data": [0, 0, 0, 0]}]} //reports/agents_bar?date=range&init=1483203600000&finish=1485968399999&agent=1664%2C1815&page=1 }
public ReportChartDataModel GetAgentMessageChartData(string business_id, [FromQuery] ReportDataFilter filter) { ReportChartDataModel model = new ReportChartDataModel { lines = new List <ChartDataLine>() }; IEnumerable <ReportChatDataLine> list = _reportService.GetAgentChatChartData(business_id, filter).Result; var total = 0; foreach (var item in list) { var data = new int[] { item.inboxes, item.comments }; total += item.inboxes + item.comments; model.lines.Add(new ChartDataLine { name = item.name, data = data }); } model.total = total; return(model); // { "total": 408, "lines": [{"name": "2016/12", "data": [0] }, {"name": "2017/1", "data": [182]}, {"name": "2017/2", "data": [226]}]} }
public ReportChartDataModel GetTicketsLine(string business_id, [FromQuery] ReportDataFilter filter) { ReportChartDataModel model = new ReportChartDataModel { lines = new List <ChartDataLine>() }; IEnumerable <ReportTicketDataLine> list = _reportService.GetTicketChartData(business_id, filter).Result; var total = 0; foreach (var item in list) { var data = new int[] { item.tickets, item.completed_tickets, item.tickets - (item.completed_tickets + item.pending_tickets + item.attention_tickets), item.pending_tickets, item.attention_tickets }; model.lines.Add(new ChartDataLine { name = item.name, data = data }); total += item.tickets; } model.total = total; return(model); //{"lines": [{"name": "2016-12-26", "data": [0, 0, 0]}, {"name": "2017-01-02", "data": [0, 0, 0]}, {"name": "2017-01-09", "data": [0, 0, 0]}, {"name": "2017-01-16", "data": [0, 0, 0]}, {"name": "2017-01-23", "data": [148, 0, 0]}, {"name": "2017-01-30", "data": [17, 0, 0]}]} //reports/orders_line?date=range&init=1483203600000&finish=1485968399999&period=week&page=1 }
public ReportChartDataModel GetTicketChartData(string business_id, [FromQuery] ReportDataFilter filter) { ReportChartDataModel model = new ReportChartDataModel { lines = new List <ChartDataLine>() }; IEnumerable <ReportTicketDataLine> list = _reportService.GetTicketChartData(business_id, filter).Result; var total = 0; foreach (var item in list) { var data = new int[] { item.tickets }; model.lines.Add(new ChartDataLine { id = item.id, name = item.name, data = data }); total += item.tickets; } model.total = total; return(model); //{ "total": 408, "lines": [{"name": "2016/12", "data": [0]}, {"name": "2017/1", "data": [182]}, {"name": "2017/2", "data": [226]}]} //reports/db_ticket_opened?date=range&init=1483203600000&finish=1488038268796&samurai=1664%2C1815&period=month }