. "(select " . "yesterday.media_cd AS ad_code_yesterday," . "yesterday.trade_type AS trade_type_yesterday," . "COUNT(DISTINCT yesterday.user_id) AS yesterday_unique " . "FROM trade AS yesterday " . "WHERE yesterday.disable = 0 " . "AND yesterday.trade_datetime >= ".$date."000000 " . "AND yesterday.trade_datetime < ".$tomorrow."000000 " . "GROUP BY ad_code_yesterday,trade_type_yesterday " . ") AS yesterday on trade.media_cd = yesterday.ad_code_yesterday AND trade.trade_type = yesterday.trade_type_yesterday " . "WHERE trade.disable = 0 " . "AND trade.trade_datetime >= ".$three_month_ago."000000 " . "AND trade.trade_datetime < ".$tomorrow."000000 " . "GROUP BY ad_code,trade_type"; */ $unique_result = $calc->calcTradeUniqueCount($unique_sql); if (!is_array($user_result) || !is_array($access_result) || !is_array($trd_result) || !is_array($unique_result)) { echo "<?xml version=\"1.0\"?>"; echo "<delyzer>"; echo "<judge>false</judge>"; echo "</delyzer>"; exit; } //3配列のkeyが全てないと困るのでマージします $roop_array = array_merge($user_result, $access_result, $trd_result, $unique_result); echo "<?xml version=\"1.0\"?>\n"; echo "<delyzer>"; $i = 0; foreach ($roop_array as $ad_code_key => $ad_code_value) { echo "<ad_code_" . $i . ">"; $ad_code_data[] = "ad_code:" . urlencode($ad_code_key);