#-----------------------------------------------------------
#--Ｗｅｂ申込集計結果(FU_T_WEBMK_SRLT-FU_INSERT_001)
#--Ｗｅｂ申込集計結果へデータを登録する。
#-----------------------------------------------------------

--KEY:FU_INSERT_001

INSERT INTO FU_T_WEBMK_SRLT(
SHUK_TG_MSKM_YMD
,WEBMK_SHUK_SBT_CD
,WEBMK_SHUK_TG_VALUE
,MSKM_CNT_HOME_NET
,MSKM_CNT_HOME_TV
,MSKM_CNT_HOME_TEL
,MSKM_CNT_MAMS_NET
,MSKM_CNT_MAMS_TV
,MSKM_CNT_MAMS_TEL
,MSKM_CNT_MEZON_NET
,MSKM_CNT_MEZON_TV
,MSKM_CNT_MEZON_TEL
,MSKM_CNT_MBL
,MSKM_CNT_GK
,WRIB_TG_MSKM_CNT
,SCREEN_BETU_RDT_CNT
,DSEN_BETU_RDT_CNT
,ADD_DTM
,ADD_OPEACNT
,UPD_DTM
,UPD_OPEACNT
,MK_FLG
,ADD_UNYO_YMD
,ADD_TRN_ID
,UPD_UNYO_YMD
,UPD_TRN_ID
)VALUES(
?
,?
,?
,?
,?
,?
,?
,?
,?
,?
,?
,?
,?
,?
,?
,?
,?
,'ADD_DTM'
,'ADD_OPE'
,'UPD_DTM'
,'UPD_OPE'
,'0'
,'ADD_UNYO'
,'ADD_TRN'
,'UPD_UNYO'
,'UPD_TRN'
)

#-

#-----------------------------------------------------------
#--Ｗｅｂ申込集計結果(FU_T_WEBMK_SRLT-FU_UPDATE_001)
#--Ｗｅｂ申込集計結果へデータを更新する。
#-----------------------------------------------------------

--KEY:FU_UPDATE_001

UPDATE FU_T_WEBMK_SRLT
SET 
MSKM_CNT_HOME_NET = ?
,MSKM_CNT_HOME_TV = ?
,MSKM_CNT_HOME_TEL = ?
,MSKM_CNT_MAMS_NET = ?
,MSKM_CNT_MAMS_TV = ?
,MSKM_CNT_MAMS_TEL = ?
,MSKM_CNT_MEZON_NET = ?
,MSKM_CNT_MEZON_TV = ?
,MSKM_CNT_MEZON_TEL = ?
,MSKM_CNT_MBL = ?
,MSKM_CNT_GK = ?
,WRIB_TG_MSKM_CNT = ?
,SCREEN_BETU_RDT_CNT = ?
,DSEN_BETU_RDT_CNT = ?
,UPD_DTM = 'UPD_DTM'
,UPD_UNYO_YMD = 'UPD_UNYO'
,UPD_TRN_ID = 'UPD_TRN'
,UPD_OPEACNT = 'UPD_OPE'
,MK_FLG = '0'
WHERE
SHUK_TG_MSKM_YMD = ?
AND WEBMK_SHUK_SBT_CD = ?
AND WEBMK_SHUK_TG_VALUE = ?

#-

#-----------------------------------------------------------
#--Ｗｅｂ申込集計結果(FU_T_WEBMK_SRLT-FU_SELECT_001)
#--Ｗｅｂ申込集計結果に特定のキー項目について件数の取得を行う。
#-----------------------------------------------------------

--KEY:FU_SELECT_001

SELECT COUNT(*) CNT FROM FU_T_WEBMK_SRLT
WHERE SHUK_TG_MSKM_YMD = ?
AND WEBMK_SHUK_SBT_CD = ?
AND WEBMK_SHUK_TG_VALUE = ?
AND MK_FLG = '0'

#-

#-----------------------------------------------------------
#--Ｗｅｂ申込集計結果(FU_T_WEBMK_SRLT-FU_SELECT_002)
#--Ｗｅｂ申込集計結果より指定範囲内の集計対象年月日に該当するデータを全て取得する。
#-----------------------------------------------------------

--KEY:FU_SELECT_002

SELECT 
    FU0121.SHUK_TG_MSKM_YMD,
    FU0121.WEBMK_SHUK_SBT_CD,
    FU0121.WEBMK_SHUK_TG_VALUE,
    FU0121.MSKM_CNT_HOME_NET,
    FU0121.MSKM_CNT_HOME_TV,
    FU0121.MSKM_CNT_HOME_TEL,
    FU0121.MSKM_CNT_MAMS_NET,
    FU0121.MSKM_CNT_MAMS_TV,
    FU0121.MSKM_CNT_MAMS_TEL,
    FU0121.MSKM_CNT_MEZON_NET,
    FU0121.MSKM_CNT_MEZON_TV,
    FU0121.MSKM_CNT_MEZON_TEL,
    FU0121.MSKM_CNT_MBL,
    FU0121.MSKM_CNT_GK,
    FU0121.WRIB_TG_MSKM_CNT,
    FU0121.SCREEN_BETU_RDT_CNT,
    FU0121.DSEN_BETU_RDT_CNT
FROM FU_T_WEBMK_SRLT FU0121
WHERE FU0121.SHUK_TG_MSKM_YMD >= ?
AND FU0121.SHUK_TG_MSKM_YMD <= ?
AND WEBMK_SHUK_SBT_CD = ?
AND MK_FLG = '0'

#-