public ActionResult AdPlayBusiLocalTotalExcelReport(AdPlayTotalCond Cond)
{
List <string> headers = new List <string>()
{
"순번", "사업주", "로컬박스수", "이미지-1(건)", "이미지-1(초)", "이미지-6(건)", "이미지-6(초)", "이미지-12(건)", "이미지-12(초)", "클릭(건)", "클릭(초)"
, "비디오(건)", "비디오(초)", "유튜브(건)", "유튜브(초)", "총건수", "총시간(초)"
};
Cond.PAGE = 1; Cond.PAGE_COUNT = 1000000000;
return(new MongoDBService().GetAdPlayBusiLocalTotalList(Cond).Select(s => new {
ROW_IDX = s.ROW_IDX,
STRENAME = s.STORE_NAME,
AD_CNT = s.DEVICE_CNT,
IMAGE1_PLAY_QTY = s.IMAGE1_PLAY_QTY,
IMAGE1_PLAY_TIME = s.IMAGE1_PLAY_TIME,
IMAGE6_PLAY_QTY = s.IMAGE6_PLAY_QTY,
IMAGE6_PLAY_TIME = s.IMAGE6_PLAY_TIME,
IMAGE12_PLAY_QTY = s.IMAGE12_PLAY_QTY,
IMAGE12_PLAY_TIME = s.IMAGE12_PLAY_TIME,
CLICK_PLAY_QTY = s.CLICK_PLAY_QTY,
CLICK_PLAY_TIME = s.CLICK_PLAY_TIME,
VIDEO_PLAY_QTY = s.VIDEO_PLAY_QTY,
VIDEO_PLAY_TIME = s.VIDEO_PLAY_TIME,
YOUTUBE_PLAY_QTY = s.YOUTUBE_PLAY_QTY,
YOUTUBE_PLAY_TIME = s.YOUTUBE_PLAY_TIME,
TOT_QTY = s.TOT_QTY,
TOT_PLAY_TIME = s.TOT_PLAY_TIME
}).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));
}
/// <summary>
/// 월별 광고 플레이 집계리스트
/// </summary>
/// <param name="Cond"></param>
/// <returns></returns>
public List <AdPlayBusiTotalList> GetAdPlayMonthTotalList(AdPlayTotalCond Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\T_AD_PLAY_LOG_MONGO_DAY.xml", "GetAdPlayMonthTotalList"
, Cond.PAGE.ToString("1")
, Cond.PAGE_COUNT.ToString("10")
, Cond.SORT_ORDER.ToString("MAX(A.REG_DAY) DESC")
, Cond.FR_DATE.RemoveDateString().ToString(DateTime.Now.ToString("yyyyMMdd"))
, Cond.TO_DATE.RemoveDateString().ToString(DateTime.Now.ToString("yyyyMMdd"))
);
return(db.ExecuteQuery <AdPlayBusiTotalList>(sql).ToList());
}
/// <summary>
/// 일자별 배너재생 집계리스트
/// </summary>
/// <param name="Cond"></param>
/// <returns></returns>
public List <AdPlayTotalList> GetAdPlayDailyTotalList(AdPlayTotalCond Cond)
{
string sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\T_AD_PLAY_LOG_MONGO_DAY.xml", "GetAdPlayDailyTotalList"
, 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.AD_CODE.ToString("")
, Cond.TITLE.ToString("")
, Cond.BANNER_TYPE2.ToString("")
, Cond.BANNER_KIND.ToString("")
, Cond.DEVICE_KIND.ToString("")
, Cond.PLAY_TYPE.ToString("")
, Cond.FRAME_TYPE.ToString("")
, Cond.STORE_CODE.ToString("")
, Cond.STORE_NAME.ToString("")
);
return(db.ExecuteQuery <AdPlayTotalList>(sql).ToList());
}
public ActionResult adPlayDailyTotalExcelReport(AdPlayTotalCond Cond)
{
List <string> headers = new List <string>()
{
"순번", "일자", "구분", "제목", "배너유형", "재생유형", "프레임", "재생시간(초)", "건수", "광고주"
};
Cond.PAGE = 1; Cond.PAGE_COUNT = 1000000000;
return(new MongoDBService().GetAdPlayDailyTotalList(Cond).Select(s => new {
ROW_IDX = s.ROW_IDX,
REG_DAY = s.REG_DAY,
DEVICE_KIND = s.DEVICE_KIND_NAME,
TITLE = s.TITLE,
BANNER_TYPE2_NAME = s.BANNER_TYPE2_NAME,
FRAME_TYPE_NAME = s.FRAME_TYPE_NAME,
SUB_PLAY_TIME = s.SUB_PLAY_TIME
, SUB_QTY = s.SUB_QTY
, STORE_NAME = s.STORE_NAME
}).ToList().ToExcel(SessionHelper.LoginInfo.CURRENT_MENU_NAME + DateTime.Now.ToString("_yyyyMMddHHmmss"), headers));
}
public PartialViewResult pv_AdPlayMonthTotalList(AdPlayTotalCond Cond)
{
ViewBag.list = new MongoDBService().GetAdPlayMonthTotalList(Cond);
return(PartialView2());
}
public ActionResult AdPlayDailyTotalList(AdPlayTotalCond Cond)
{
ViewBag.Cond = Cond;
return(View());
}