public PageOf <ArticleInfo> Search(UserInfo user, QueryPackage queryPackage, int pageIndex, int pageSize)
{
var keyword = queryPackage.QueryString;
var sorting = _sortingConverter.ToDomainObject(queryPackage.SortingInfo);
var startDate = queryPackage.StartDate;
var endDate = queryPackage.EndDate;
var articles = _searchDao.Search(
keyword,
sorting,
startDate,
endDate,
pageIndex,
pageSize);
var articleInfos = _articleConverter.ToDataTransferObject(articles);
return(new PageOf <ArticleInfo>()
{
TotalCount = _searchDao.GetTotalCount(keyword, sorting, startDate, endDate),
PageSize = pageSize,
PageIndex = pageIndex,
Results = articleInfos
});
}
public List <SearchGroup> Search(String searchText, int projectId)
{
var queryResult = _searchDao.Search(searchText, projectId);
var groups = new Dictionary <int, SearchGroup>();
foreach (var r in queryResult)
{
var projId = 0;
SearchItem item = null;
if (r is Project)
{
var p = (Project)r;
if (ProjectSecurity.CanRead(p))
{
projId = p.ID;
if (!groups.ContainsKey(projId))
{
groups[projId] = new SearchGroup(projId, p.Title);
}
item = new SearchItem(EntityType.Project, p.ID, p.Title, p.Description, p.CreateOn);
}
}
else
{
if (r is Milestone)
{
var m = (Milestone)r;
if (ProjectSecurity.CanRead(m))
{
projId = m.Project.ID;
if (!groups.ContainsKey(projId))
{
groups[projId] = new SearchGroup(projId, m.Project.Title);
}
item = new SearchItem(EntityType.Milestone, m.ID, m.Title, null, m.CreateOn);
}
}
else if (r is Message)
{
var m = (Message)r;
if (ProjectSecurity.CanReadMessages(m.Project))
{
projId = m.Project.ID;
if (!groups.ContainsKey(projId))
{
groups[projId] = new SearchGroup(projId, m.Project.Title);
}
item = new SearchItem(EntityType.Message, m.ID, m.Title, m.Content, m.CreateOn);
}
}
else if (r is Task)
{
var t = (Task)r;
if (ProjectSecurity.CanRead(t))
{
projId = t.Project.ID;
if (!groups.ContainsKey(projId))
{
groups[projId] = new SearchGroup(projId, t.Project.Title);
}
item = new SearchItem(EntityType.Task, t.ID, t.Title, t.Description, t.CreateOn);
}
}
}
if (0 < projId && item != null)
{
groups[projId].Items.Add(item);
}
}
try
{
// search in files
var fileEntries = new List <Files.Core.FileEntry>();
using (var folderDao = FilesIntegration.GetFolderDao())
using (var fileDao = FilesIntegration.GetFileDao())
{
fileEntries.AddRange(folderDao.Search(searchText, Files.Core.FolderType.BUNCH).Cast <Files.Core.FileEntry>());
fileEntries.AddRange(fileDao.Search(searchText, Files.Core.FolderType.BUNCH).Cast <Files.Core.FileEntry>());
var projectIds = projectId != 0
? new List <int> {
projectId
}
: fileEntries.GroupBy(f => f.RootFolderId)
.Select(g => folderDao.GetFolder(g.Key))
.Select(f => f != null ? folderDao.GetBunchObjectID(f.RootFolderId).Split('/').Last() : null)
.Where(s => !string.IsNullOrEmpty(s))
.Select(s => int.Parse(s));
var rootProject = projectIds.ToDictionary(id => FilesIntegration.RegisterBunch("projects", "project", id.ToString()));
fileEntries.RemoveAll(f => !rootProject.ContainsKey(f.RootFolderId));
var security = FilesIntegration.GetFileSecurity();
fileEntries.RemoveAll(f => !security.CanRead(f));
foreach (var f in fileEntries)
{
var id = rootProject[f.RootFolderId];
if (!groups.ContainsKey(id))
{
var project = _projDao.GetById(id);
if (project != null && ProjectSecurity.CanRead(project) && ProjectSecurity.CanReadFiles(project))
{
groups[id] = new SearchGroup(id, project.Title);
}
else
{
continue;
}
}
var item = new SearchItem
{
EntityType = EntityType.File,
ID = f is Files.Core.File ? ((Files.Core.File)f).ViewUrl : string.Format("{0}tmdocs.aspx?prjID={1}#{2}", VirtualPathUtility.ToAbsolute("~/products/projects/"), id, f.ID),
Title = f.Title,
CreateOn = f.CreateOn,
};
groups[id].Items.Add(item);
}
}
}
catch (Exception err)
{
LogManager.GetLogger("ASC.Web").Error(err);
}
return(new List <SearchGroup>(groups.Values));
}
public IEnumerable <SearchItem> Search(string searchText, int projectId = 0)
{
var queryResult = searchDao.Search(searchText, projectId);
foreach (var r in queryResult.Where(ProjectSecurity.CanRead))
{
switch (r.EntityType)
{
case EntityType.Project:
searchItems.Add(new SearchItem((Project)r));
continue;
case EntityType.Milestone:
case EntityType.Message:
case EntityType.Task:
searchItems.Add(new SearchItem((ProjectEntity)r));
continue;
case EntityType.Comment:
var comment = (Comment)r;
var entity = factory.CommentEngine.GetEntityByTargetUniqId(comment);
if (entity == null)
{
continue;
}
searchItems.Add(new SearchItem(comment.EntityType, comment.ID.ToString(CultureInfo.InvariantCulture), HtmlUtil.GetText(comment.Content), comment.CreateOn, new SearchItem(entity)));
continue;
case EntityType.SubTask:
var subtask = (Subtask)r;
var parentTask = factory.TaskEngine.GetByID(subtask.Task);
if (parentTask == null)
{
continue;
}
searchItems.Add(new SearchItem(subtask.EntityType, subtask.ID.ToString(CultureInfo.InvariantCulture), subtask.Title, subtask.CreateOn, new SearchItem(parentTask)));
continue;
}
}
try
{
// search in files
var fileEntries = new List <Files.Core.FileEntry>();
using (var folderDao = FilesIntegration.GetFolderDao())
using (var fileDao = FilesIntegration.GetFileDao())
{
fileEntries.AddRange(folderDao.Search(searchText, Files.Core.FolderType.BUNCH));
fileEntries.AddRange(fileDao.Search(searchText, Files.Core.FolderType.BUNCH));
var projectIds = projectId != 0
? new List <int> {
projectId
}
: fileEntries.GroupBy(f => f.RootFolderId)
.Select(g => folderDao.GetFolder(g.Key))
.Select(f => f != null ? folderDao.GetBunchObjectID(f.RootFolderId).Split('/').Last() : null)
.Where(s => !string.IsNullOrEmpty(s))
.Select(int.Parse);
var rootProject = projectIds.ToDictionary(id => FilesIntegration.RegisterBunch("projects", "project", id.ToString(CultureInfo.InvariantCulture)));
fileEntries.RemoveAll(f => !rootProject.ContainsKey(f.RootFolderId));
var security = FilesIntegration.GetFileSecurity();
fileEntries.RemoveAll(f => !security.CanRead(f));
foreach (var f in fileEntries)
{
var id = rootProject[f.RootFolderId];
var project = projDao.GetById(id);
if (ProjectSecurity.CanReadFiles(project))
{
var itemId = f is Files.Core.File
? FilesLinkUtility.GetFileWebPreviewUrl(f.Title, f.ID)
: Web.Files.Classes.PathProvider.GetFolderUrl((Files.Core.Folder)f, project.ID);
searchItems.Add(new SearchItem(EntityType.File, itemId, f.Title, f.CreateOn, new SearchItem(project), itemPath: "{2}"));
}
}
}
}
catch (Exception err)
{
LogManager.GetLogger("ASC.Web").Error(err);
}
return(searchItems);
}