$sql_cropid = $pdo_sql->sql_injection($corpid);
$sql_syntax = str_replace("[+++corpid+++]", "AND corpid={$sql_cropid}", $sql_syntax);
}
if ($allpay_gid == "") {
$sql_syntax = str_replace("[+++allpay_gid_rule+++]", "", $sql_syntax);
} else {
$sql_allpay_gid = $pdo_sql->sql_injection($allpay_gid);
$sql_syntax = str_replace("[+++allpay_gid_rule+++]", "AND client={$sql_allpay_gid}", $sql_syntax);
}
if ($allpay_mid == "") {
$sql_syntax = str_replace("[+++allpay_mid_rule+++]", "", $sql_syntax);
} else {
$sql_allpay_mid = $pdo_sql->sql_injection($allpay_mid);
$sql_syntax = str_replace("[+++allpay_mid_rule+++]", "AND allpayMID={$sql_allpay_mid}", $sql_syntax);
}
$result = $pdo_sql->exe($sql_syntax);
$sql_syntax = "\n CREATE TEMPORARY TABLE temp_trade_info AS(\n SELECT\n SUM(amount) AS total_sum,\n SUM(case when remsg='已授權' then amount end) as succ_total ,\n SUM(case when remsg!='已授權' then amount end) as not_succ_total ,\n COUNT(*) AS total_count,\n COUNT(case when remsg='已授權' then amount end) AS succ_total_count,\n COUNT(case when remsg!='已授權' then amount end) AS not_succ_total_count,\n client\n FROM o_auth \n WHERE procdt> '{$start_date}' AND procdt < '{$start_end}' AND client!='3' [+++allpay_gid_rule+++] GROUP BY client\n );";
if ($allpay_gid == "") {
$sql_syntax = str_replace("[+++allpay_gid_rule+++]", "", $sql_syntax);
} else {
$sql_allpay_gid = $pdo_sql->sql_injection($allpay_gid);
$sql_syntax = str_replace("[+++allpay_gid_rule+++]", "AND client={$sql_allpay_gid}", $sql_syntax);
}
$result = $pdo_sql->exe($sql_syntax);
$sql_syntax = "SELECT \n SUM(trade_info.total_sum) AS all_total,\n SUM(trade_info.succ_total) AS all_total_succ,\n SUM(trade_info.not_succ_total) AS all_not_succ_total,\n SUM(trade_info.succ_total_count) AS all_succ_total_count,\n SUM(trade_info.not_succ_total_count) AS all_not_succ_total_count,\n SUM(trade_info.total_count) AS all_total_count,\n allpayMID,\n merchant_info.corpname,\n merchant_info.webname\n FROM \n (SELECT * FROM temp_trade_info)AS trade_info LEFT JOIN \n (SELECT * FROM temp_merchant_info)AS merchant_info ON merchant_info.client=trade_info.client \n WHERE merchant_info.allpayMID IS NOT NULL [+++allpay_mid_rule+++] GROUP BY allpayMID ORDER BY all_total_succ DESC";
if ($allpay_mid == "") {
$sql_syntax = str_replace("[+++allpay_mid_rule+++]", "", $sql_syntax);
} else {
$sql_allpay_mid = $pdo_sql->sql_injection($allpay_mid);
$sql_syntax = str_replace("[+++allpay_mid_rule+++]", "AND allpayMID={$sql_allpay_mid}", $sql_syntax);
}
