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
}
