public IActionResult List(FlowRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var query = _dbContext.Flow.Where(x => x.IsDelete == 0);
if (AuthContextService.CurrentUser.SchoolGuid != null)
{
query = query.Where(x => x.SchoolUuid == AuthContextService.CurrentUser.SchoolGuid);
}
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.FlowName.Contains(payload.Kw));
}
if (!string.IsNullOrEmpty(payload.kw1))
{
query = query.Where(x => x.FlowTime.Contains(Convert.ToDateTime(payload.kw1).ToString("yyyy-MM-dd")));
}
if (payload.FirstSort != null)
{
query = query.OrderByDescending(x => x.FlowTime);
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var totalCount = query.Count();
response.SetData(list, totalCount);
return(Ok(response));
}
}
public IActionResult Getscreen(FlowRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbITMContext)
{
var school = _dbITMContext.Orgs.FirstOrDefault(x => x.SchoolName == payload.Kw);
if (school != null)
{
//var query = from s in _dbITMContext.Screenshots
// join m in _dbITMContext.Monitors
// on s.MonitorId equals m.Id
// where m.OrganizationId == school.OrganizationId
// && s.CreatedAt.ToString().Contains(payload.kw1)
// select new
// {
// s.Id,
// Path = "https://img.jiulong.yoruan.com/" + s.Path,
// CreatedAt = s.CreatedAt.Value.ToString("yyyy-MM-dd"),
// ispath = false,
// m.Procedure
// };
var query = from s in _dbITMContext.Screenshots
join m in _dbITMContext.Monitors
on s.MonitorId equals m.Id
where m.OrganizationId == school.OrganizationId &&
s.CreatedAt.ToString().Contains(payload.kw1)
select new
{
s,
m
};
if (!string.IsNullOrEmpty(payload.kw2))
{
query = query.Where(x => x.m.Procedure == payload.kw2);
}
//var list = query.Paged(payload.CurrentPage, payload.PageSize).ToList();
var list = query.ToList();
var menu = new List <dynamic>();
var list02 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 00:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 02:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "00:00-02:00"
});
var list24 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 02:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 04:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "02:00-04:00"
});
var list46 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 04:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 06:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "04:00-06:00"
});
var list68 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 06:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 08:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "06:00-8:00"
});
var list810 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 08:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 10:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "08:00-10:00"
});
var list1012 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 10:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 12:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "10:00-12:00"
});
var list1214 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 12:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 14:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "12:00-14:00"
});
var list1416 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 14:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 16:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "14:00-16:00"
});
var list1618 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 16:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 18:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "16:00-18:00"
});
var list1820 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 18:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 20:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "18:00-20:00"
});
var list2022 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 20:00") && x.s.CreatedAt <= Convert.ToDateTime(payload.kw1 + " 22:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "20:00-22:00"
});
var list2224 = list.Where(x => x.s.CreatedAt >= Convert.ToDateTime(payload.kw1 + " 22:00")).Select(x => new
{
x.s.Id,
Path = "https://img.jiulong.yoruan.com/" + x.s.Path,
CreatedAt = x.s.CreatedAt.Value.ToString("yyyy-MM-dd"),
ispath = false,
x.m.Procedure,
Time = "22:00-24:00"
});
menu.Add(list02);
menu.Add(list24);
menu.Add(list46);
menu.Add(list68);
menu.Add(list810);
menu.Add(list1012);
menu.Add(list1214);
menu.Add(list1416);
menu.Add(list1618);
menu.Add(list1820);
menu.Add(list2022);
menu.Add(list2224);
response.SetData(menu);
return(Ok(response));
}
return(Ok(response));
}
}
