<?php
include_once"../wp-config.php";
global $wpdb;
$curDate = date('Y-m-d');

$csv_output ='S.No,Amount,TxnId,Date,Referral,Name,Email,Mobile UseFor';
$csv_output .= "\n";
	
$getTxnData ="SELECT t.user_id, t.support_id, t.amount, t.transaction_id, t.payment_status, t.payment_date, su.refer_code, su.name, su.email, su.mobile, m.name as usefor FROM `wp_sb_online_transaction` as t LEFT JOIN `wp_sb_support_user_detail` as su ON su.id=t.user_id LEFT JOIN `wp_sb_support_type` as st ON st.id=su.support_id LEFT JOIN `wp_sb_money_used_type` as m ON m.id=su.how_to_use where t.payment_status='S'";
$getTxnList = $wpdb->get_results($getTxnData);

$i=1;
if (sizeof($getTxnList) > 0) {
	foreach($getTxnList as $tdd)
	{
	    $csv_output .= $i . ',';
	    $csv_output .= $tdd->amount . ',';
	    $csv_output .= $tdd->transaction_id . ',';
	    $csv_output .= date('d-M-Y', strtotime($tdd->payment_date)) . ',';
		$csv_output .= $tdd->refer_code . ',';
        $csv_output .= $tdd->name . ',';
		$csv_output .= $tdd->email . ',';
		$csv_output .= $tdd->mobile . ',';
        $csv_output .= $tdd->usefor . ',';
        // $csv_output .= str_replace("."," ",$tdd->remark) . ',';
        $csv_output .= "\n";
		$i++;
    }
} else {
    $csv_output = "No Record Found!";
}

$filename = "Transaction List".$curDate;

header("Content-type: application/vnd.ms-excel");
header("Content-disposition:   filename=" . $filename . ".csv");
print $csv_output;

exit;