private static SelectQueryDefinition BuildQuery(DataSourceContext context, Select selectQuery)
{
SelectQueryDefinition def = new SelectQueryDefinition();
def.Build(selectQuery);
if (LogContext.IsLogActive)
{
var logKey = "Lucene query";
LogContext.Log(context.ActiveModuleId, logKey, "Filter", def.Filter.ToString());
LogContext.Log(context.ActiveModuleId, logKey, "Query", def.Query.ToString());
LogContext.Log(context.ActiveModuleId, logKey, "Sort", def.Sort.ToString());
LogContext.Log(context.ActiveModuleId, logKey, "PageIndex", def.PageIndex);
LogContext.Log(context.ActiveModuleId, logKey, "PageSize", def.PageSize);
}
return(def);
}
public virtual IDataItems GetAll(DataSourceContext context, Select select)
{
if (select == null)
{
return(GetAll(context));
}
else
{
OpenContentController ctrl = new OpenContentController();
SelectQueryDefinition def = new SelectQueryDefinition();
def.Build(@select);
if (LogContext.IsLogActive)
{
var logKey = "Lucene query";
LogContext.Log(context.ActiveModuleId, logKey, "Filter", def.Filter.ToString());
LogContext.Log(context.ActiveModuleId, logKey, "Query", def.Query.ToString());
LogContext.Log(context.ActiveModuleId, logKey, "Sort", def.Sort.ToString());
LogContext.Log(context.ActiveModuleId, logKey, "PageIndex", def.PageIndex);
LogContext.Log(context.ActiveModuleId, logKey, "PageSize", def.PageSize);
}
SearchResults docs = LuceneController.Instance.Search(GetModuleId(context).ToString(), def.Filter, def.Query, def.Sort, def.PageSize, def.PageIndex);
int total = docs.TotalResults;
var dataList = new List <IDataItem>();
foreach (string item in docs.ids)
{
var content = ctrl.GetContent(int.Parse(item));
if (content != null)
{
dataList.Add(CreateDefaultDataItem(content));
}
else
{
Log.Logger.DebugFormat("OpenContentDataSource.GetAll() ContentItem not found [{0}]", item);
}
}
return(new DefaultDataItems()
{
Items = dataList,
Total = total,
DebugInfo = def.Filter.ToString() + " - " + def.Query.ToString() + " - " + def.Sort.ToString()
});
}
}
public HttpResponseMessage List(RequestDTO req)
{
try
{
Log.Logger.DebugFormat("OpenFiles.JplistApiController.List() called with request [{0}].", req.ToJson());
FieldConfig indexConfig = FilesRepository.GetIndexConfig(PortalSettings.PortalId);
bool addWorkFlow = PortalSettings.UserMode != PortalSettings.Mode.Edit;
QueryBuilder queryBuilder = new QueryBuilder(indexConfig);
queryBuilder.BuildFilter(PortalSettings.PortalId, req.folder, addWorkFlow, PortalSettings.UserInfo.Social.Roles);
JplistQueryBuilder.MergeJpListQuery(FilesRepository.GetIndexConfig(PortalSettings), queryBuilder.Select, req.StatusLst, DnnLanguageUtils.GetCurrentCultureCode());
string curFolder = NormalizePath(req.folder);
foreach (var item in queryBuilder.Select.Query.FilterRules.Where(f => f.Field == LuceneMappingUtils.FolderField))
{
curFolder = NormalizePath(item.Value.AsString);
item.Value = new StringRuleValue(NormalizePath(item.Value.AsString)); //any file of current folder
}
var def = new SelectQueryDefinition();
def.Build(queryBuilder.Select);
var docs = LuceneController.Instance.Search(def);
int total = docs.TotalResults;
var ratio = string.IsNullOrEmpty(req.imageRatio) ? new Ratio(100, 100) : new Ratio(req.imageRatio);
Log.Logger.DebugFormat("OpenFiles.JplistApiController.List() Searched for [{0}], found [{1}] items", def.Filter.ToString() + " / " + def.Query.ToString(), total);
//if (LogContext.IsLogActive)
//{
// var logKey = "Query";
// LogContext.Log(ActiveModule.ModuleID, logKey, "select", queryBuilder.Select);
// LogContext.Log(ActiveModule.ModuleID, logKey, "debuginfo", dsItems.DebugInfo);
// LogContext.Log(ActiveModule.ModuleID, logKey, "model", model);
// model["Logs"] = JToken.FromObject(LogContext.Current.ModuleLogs(ActiveModule.ModuleID));
//}
var fileManager = FileManager.Instance;
var data = new List <FileDTO>();
var breadcrumbs = new List <IFolderInfo>();
if (req.withSubFolder)
{
//hier blijken we resultaten toe te voegen die niet uit lucene komen
breadcrumbs = AddFolders(NormalizePath(req.folder), curFolder, fileManager, data, ratio);
}
foreach (var doc in docs.ids)
{
IFileInfo f = fileManager.GetFile(doc.FileId);
if (f == null)
{
//file seems to have been deleted
LuceneController.Instance.Delete(LuceneMappingUtils.CreateLuceneItem(doc.PortalId, doc.FileId));
total -= 1;
}
else
{
if (f.FileName == "_folder.jpg")
{
continue; // skip
}
dynamic title = null;
var custom = GetCustomFileDataAsDynamic(f);
if (custom != null && custom.meta != null)
{
try
{
title = Normalize.DynamicValue(custom.meta.title, "");
}
catch (Exception ex)
{
Log.Logger.Debug("OpenFiles.JplistApiController.List() Failed to get title.", ex);
}
}
data.Add(new FileDTO()
{
Id = f.FileId,
Name = Normalize.DynamicValue(title, f.FileName),
FileName = f.FileName,
CreatedOnDate = f.CreatedOnDate,
LastModifiedOnDate = f.LastModifiedOnDate,
FolderName = f.Folder,
Url = fileManager.GetUrl(f),
IsImage = fileManager.IsImageFile(f),
ImageUrl = ImageHelper.GetImageUrl(f, ratio),
Custom = custom,
IconUrl = GetFileIconUrl(f.Extension),
IsEditable = IsEditable,
EditUrl = IsEditable ? GetFileEditUrl(f) : ""
});
}
}
var res = new ResultExtDTO <FileDTO>()
{
data = new ResultDataDTO <FileDTO>()
{
items = data,
breadcrumbs = breadcrumbs.Select(f => new ResultBreadcrumbDTO
{
name = f.FolderName,
path = f.FolderPath.Trim('/')
})
},
count = total
};
return(Request.CreateResponse(HttpStatusCode.OK, res));
}
catch (Exception exc)
{
Log.Logger.Error(exc);
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, exc));
}
}