public IActionResult KanbanView([FromBody, FromQuery] KanbanGridModel model)
{
if (model.AggregateField.IsEmpty() || model.GroupField.IsEmpty())
{
return(JError("请指定统计字段及分组字段"));
}
QueryView.Domain.QueryView queryView = null;
if (model.QueryId.HasValue && !model.QueryId.Equals(Guid.Empty))
{
queryView = _queryViewFinder.FindById(model.QueryId.Value);
}
if (queryView == null)
{
return(NotFound());
}
if (!queryView.IsDefault && queryView.AuthorizationEnabled)
{
if (!_roleObjectAccessService.Exists(queryView.QueryViewId, QueryViewDefaults.ModuleName, CurrentUser.Roles.Select(n => n.RoleId).ToArray()))
{
return(Unauthorized());
}
}
model.QueryView = queryView;
model.EntityId = queryView.EntityId;
model.QueryId = queryView.QueryViewId;
model.EntityName = _entityFinder.FindById(model.EntityId.Value).Name;
var attributes = new List <Schema.Domain.Attribute>();
var aggAttr = _attributeFinder.Find(model.EntityId.Value, model.AggregateField);
attributes.Add(aggAttr);
var queryExp = new QueryExpression();
queryExp = queryExp.DeserializeFromJson(queryView.FetchConfig);
var orderExp = new OrderExpression("createdon", OrderType.Descending);
queryExp.Orders.Add(orderExp);
Dictionary <string, AggregateType> attributeAggs = new Dictionary <string, AggregateType>();
if (aggAttr.TypeIsInt() || aggAttr.TypeIsFloat() || aggAttr.TypeIsDecimal() || aggAttr.TypeIsMoney())
{
attributeAggs.Add(model.AggregateField, AggregateType.Sum);
model.AggType = AggregateType.Sum;
}
else
{
attributeAggs.Add(model.AggregateField, AggregateType.Count);
model.AggType = AggregateType.Count;
}
var datas = _aggregateService.Execute(queryExp, attributeAggs, new List <string>()
{
model.GroupField
});
model.Items = datas;
queryExp.ColumnSet.Columns.Clear();
queryExp.ColumnSet.AddColumns("createdon", model.AggregateField, model.GroupField, "ownerid");
model.GroupingDatas = _aggregateService.GroupingTop(model.GroupingTop, model.GroupField, queryExp, orderExp);
var groupAttr = _attributeFinder.Find(model.EntityId.Value, model.GroupField);
groupAttr.OptionSet = _optionSetFinder.FindById(groupAttr.OptionSetId.Value);
attributes.Add(groupAttr);
model.AttributeList = attributes;
return(View($"~/Views/Entity/{WebContext.ActionName}.cshtml", model));
}
