public ActionResult AdPlayDailyLocalboxTotalExcelReport(AdPlayLocalboxTotalCond Cond)
{
List <string> headers = new List <string>()
{
"순번", "일자", "로컬박스", "구분", "이미지-1(초)", "이미지-6(초)", "이미지-12(초)", "클릭(초)", "비디오(초)", "유튜브(초)", "건수", "총시간", "로컬사업자"
};
Cond.PAGE = 1; Cond.PAGE_COUNT = 1000000000;
return(new MongoDBService().GetAdPlayDailyLocalboxTotalList(Cond).Select(s => new {
ROW_IDX = s.ROW_IDX,
REG_DAY = s.REG_DAY,
DEVICE_NAME = s.DEVICE_NAME,
BANNER_KIND_NAME = s.BANNER_KIND_NAME,
IMAGE1_PLAY_TIME = s.IMAGE1_PLAY_TIME,
IMAGE6_PLAY_TIME = s.IMAGE6_PLAY_TIME,
IMAGE12_PLAY_TIME = s.IMAGE12_PLAY_TIME,
CLICK_PLAY_TIME = s.CLICK_PLAY_TIME,
VIDEO_PLAY_TIME = s.VIDEO_PLAY_TIME,
YOUTUBE_PLAY_TIME = s.YOUTUBE_PLAY_TIME,
TOT_QTY = s.TOT_QTY,
TOT_PLAY_TIME = s.TOT_PLAY_TIME,
STORE_NAME = s.STORE_NAME
}).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));
}
/// <summary>
/// 일자별로컬박스재생집계
/// </summary>
/// <param name="Cond"></param>
/// <returns></returns>
public List <AdPlayLocalboxTotalList> GetAdPlayDailyLocalboxTotalList(AdPlayLocalboxTotalCond Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\T_AD_PLAY_LOG_MONGO_DAY.xml", "GetAdPlayDailyLocalboxTotalList"
, Cond.PAGE.ToString("1")
, Cond.PAGE_COUNT.ToString("10")
, Cond.SORT_ORDER.ToString("A.REG_DAY DESC")
, Cond.FR_DATE.RemoveDateString().ToString(DateTime.Now.ToString("yyyyMMdd"))
, Cond.TO_DATE.RemoveDateString().ToString(DateTime.Now.ToString("yyyyMMdd"))
, Cond.DEVICE_CODE.ToString("")
, Cond.DEVICE_NAME.ToString("")
, Cond.STORE_CODE.ToString("")
, Cond.STORE_NAME.ToString("")
);
return(db.ExecuteQuery <AdPlayLocalboxTotalList>(sql).ToList());
}
public PartialViewResult pv_AdPlayDailyLocalboxTotalList(AdPlayLocalboxTotalCond Cond)
{
ViewBag.list = new MongoDBService().GetAdPlayDailyLocalboxTotalList(Cond);
return(PartialView2());
}
public ActionResult AdPlayDailyLocalboxTotalList(AdPlayLocalboxTotalCond Cond)
{
ViewBag.Cond = Cond;
return(View());
}
