$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";