public ActionResult adplaylogExcelReport(T_AD_PLAY_LOG_COND Cond)
{
List <string> headers = new List <string>()
{
"구분", "일자", "제목", "로컬박스명", "재생유형", "재생시간", "등록자", "비고"
};
Cond.PAGE = 1; Cond.PAGE_COUNT = 100000;
return(new AdvertisingService().GetAdPlayLogList(Cond).Select(s => new {
DEVICE_KIND_NAME = s.DEVICE_KIND_NAME
, REG_DATE = s.REG_DATE.ToDefaultDateString()
, TITLE = s.TITLE
, DEVICE_NAME = s.DEVICE_NAME
, BANNER_TYPE2_NAME = s.BANNER_TYPE2_NAME
, PLAY_TIME = s.PLAY_TIME
, INSERT_NAME = s.INSERT_NAME
, REMARK = s.REMARK
}).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));
}
public ActionResult adplaylogMongoExcelReport(T_AD_PLAY_LOG_COND Cond)
{
List <string> headers = new List <string>()
{
"구분", "일자", "광고코드", "제목", "로컬박스코드", "로컬박스명", "배너유형", "프레임", "재생유형", "재생시간", "비고"
};
Cond.PAGE = 1; Cond.PAGE_COUNT = 1000000000;
return(new MongoDBService().getAdPlayLogList(Cond).list.Select(s => new {
DEVICE_KIND_NAME = s.DEVICE_KIND_NAME
, REG_DATE = s.REG_DATE
, AD_CODE = s.AD_CODE
, TITLE = s.TITLE
, DEVICE_CODE = s.DEVICE_CODE
, DEVICE_NAME = s.DEVICE_NAME
, BANNER_TYPE2_NAME = s.BANNER_TYPE2_NAME
, FRAME_TYPE_NAME = s.FRAME_TYPE_NAME
, PLAY_TIME = s.PLAY_TIME
, REMARK = s.REMARK
}).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));
}
public T_AD_PLAY_LOG_MONGO_LIST getAdPlayLogList(T_AD_PLAY_LOG_COND Cond)
{
T_AD_PLAY_LOG_MONGO_LIST rtn = new T_AD_PLAY_LOG_MONGO_LIST();
var filterBuilder = Builders <T_AD_PLAY_LOG_MONGO> .Filter;
var sort = Builders <T_AD_PLAY_LOG_MONGO> .Sort.Ascending("_id");
if (!string.IsNullOrEmpty(Cond.SORT_ORDER))
{
String[] arrSort = Cond.SORT_ORDER.Split(' ');
if (arrSort.Count() == 2 && arrSort[1].ToUpper() == "DESC")
{
sort = Builders <T_AD_PLAY_LOG_MONGO> .Sort.Descending(arrSort[0]);
}
else
{
sort = Builders <T_AD_PLAY_LOG_MONGO> .Sort.Ascending((arrSort[0]));
}
}
#region 조건
var filter = filterBuilder.Exists(s => s._id);
if (Cond.AD_CODE != null)
{
filter = filter & filterBuilder.Eq(s => s.AD_CODE, Cond.AD_CODE);
}
if (!String.IsNullOrEmpty(Cond.TITLE))
{
filter = filter & filterBuilder.Regex(s => s.TITLE, new BsonRegularExpression(".*" + Cond.TITLE + ".*", "i"));
}
if (!string.IsNullOrEmpty(Cond.FR_DATE))
{
filter = filter & filterBuilder.Gte(s => s.REG_DATE, Cond.FR_DATE.ToDate());
}
if (!string.IsNullOrEmpty(Cond.TO_DATE))
{
filter = filter & filterBuilder.Lt(s => s.REG_DATE, Cond.TO_DATE.ToDate().Value.AddDays(1));
}
if (Cond.BANNER_KIND != null)
{
filter = filter & filterBuilder.Eq(s => s.BANNER_KIND, Cond.BANNER_KIND);
}
if (Cond.DEVICE_CODE != null)
{
filter = filter & filterBuilder.Eq(s => s.DEVICE_CODE, Cond.DEVICE_CODE);
}
if (Cond.DEVICE_KIND != null)
{
filter = filter & filterBuilder.Eq(s => s.DEVICE_KIND, Cond.DEVICE_KIND);
}
if (!String.IsNullOrEmpty(Cond.DEVICE_NAME))
{
filter = filter & filterBuilder.Regex(s => s.DEVICE_NAME, new BsonRegularExpression(".*" + Cond.DEVICE_NAME + ".*", "i"));
}
#endregion
int firstPage = (int)((Cond.PAGE - 1) * Cond.PAGE_COUNT);
var collection = database.GetCollection <T_AD_PLAY_LOG_MONGO>("adPlayLog");
var list = collection.Find(filter).Sort(sort);
#pragma warning disable CS0618 // 형식 또는 멤버는 사용되지 않습니다.
rtn.TOTAL_ROWCOUNT = list.Count();
#pragma warning restore CS0618 // 형식 또는 멤버는 사용되지 않습니다.
rtn.list = list.Skip(firstPage).Limit(Cond.PAGE_COUNT).ToList();
return(rtn);
}
public PartialViewResult pv_AdplaylogMongoList(T_AD_PLAY_LOG_COND Cond)
{
ViewBag.data = new MongoDBService().getAdPlayLogList(Cond);
ViewBag.cond = Cond;
return(PartialView2());
}
public ActionResult adplaylogMongolist(T_AD_PLAY_LOG_COND Cond)
{
ViewBag.Cond = Cond;
return(View());
}
public PartialViewResult pv_AdplaylogList(T_AD_PLAY_LOG_COND Cond)
{
ViewBag.list = new loggalServiceBiz.AdvertisingService().GetAdPlayLogList(Cond);
return(PartialView2());
}
