. "(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);
