$site_code = $_REQUEST['site_cd'];
$targetDate = $_REQUEST['target_date'];
if (!$site_code) {
exit("siteCdError:" . __LINE__);
}
if (!$calc->isDate($targetDate)) {
exit("targetDateError:" . __LINE__);
}
$targetDateYear = substr($targetDate, 0, 4);
$targetDateMonth = substr($targetDate, 4, 2);
$targetDateDay = substr($targetDate, 6, 2);
$reformTargetDate = $targetDateYear . "-" . $targetDateMonth . "-" . $targetDateDay;
//------------トップページのアクセス数を取得----------------------
$access_sql = "SELECT sum(access_count) AS total_access FROM media_analyze" . " WHERE analyze_datetime >= '" . $reformTargetDate . " 00:00:00'" . " AND analyze_datetime <= '" . $reformTargetDate . " 23:59:59'" . " AND disable = 0 ";
$access_result = $calc->executeQuery($access_sql);
$resultAccessData = $calc->fetchObject($access_result);
$i_total_access = $resultAccessData->total_access;
if (!$i_total_access) {
exit("topCntError:" . __LINE__);
}
//--------------対象日時の入金額取得---------------------------
$paymentSql = "SELECT SUM(receive_money) AS t_today_uriage";
$paymentSql .= ",SUM(CASE WHEN pay_type = " . PAY_TYPE_BANK_AUTOMATIONBAS . " THEN receive_money ELSE 0 END) AS bank_uriage";
$paymentSql .= ",SUM(CASE WHEN pay_type = " . PAY_TYPE_CREDIT . " THEN receive_money ELSE 0 END) AS credit_uriage";
$paymentSql .= ",SUM(CASE WHEN pay_type = " . PAY_TYPE_CVD . " THEN receive_money ELSE 0 END) AS cvd_uriage";
$paymentSql .= ",SUM(CASE WHEN pay_type = " . PAY_TYPE_BITCASH . " THEN receive_money ELSE 0 END) AS bitcash_uriage";
$paymentSql .= ",SUM(CASE WHEN pay_type = " . PAY_TYPE_TELECOM . " THEN receive_money ELSE 0 END) AS telecom_uriage";
$paymentSql .= ",SUM(CASE WHEN pay_type = " . PAY_TYPE_BANK_AUTOMATION . " THEN receive_money ELSE 0 END) AS omakase_uriage";
$paymentSql .= ",SUM(CASE WHEN pay_type = " . PAY_TYPE_CCHECK . " THEN receive_money ELSE 0 END) AS ccheck_uriage";
$paymentSql .= ",SUM(CASE WHEN pay_type = " . PAY_TYPE_DIGITALEDY . " THEN receive_money ELSE 0 END) AS edy_uriage";
$paymentSql .= ",SUM(CASE WHEN pay_type = " . PAY_TYPE_BANK_RAKUTEN . " THEN receive_money ELSE 0 END) AS ebank_uriage";
