<?php
include_once('header.php');

$getTxnQuery = "SELECT t.user_id, t.support_id, t.amount, t.transaction_id, t.payment_status, t.payment_date, su.remark, 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' order by t.id desc";
$getTxnData = $wpdb->get_results($getTxnQuery);
?>

<style>
	.modal-backdrop {
	    z-index: 999!important;
	}
	table.dataTable.nowrap th, table.dataTable.nowrap td {
	    white-space: nowrap !important;
	}
	.page-title{
		float: left;
	    width: 100%;
	}
</style>

<div class="page-inner">
    <div class="page-title">
		<div class="col-md-4">
			<h3>Transactions</h3>
			<div class="page-breadcrumb">
				<ol class="breadcrumb">
					<li><a href="dashboard">Home</a></li>
					<li class="active">Financial Support</li>
				</ol>
			</div>
		</div>
		<div class="col-md-8">
			<div class="navbar-right">
				<ul class="navul">
					<!--<li><a href="apt-class">Class List</a></li>-->
				</ul>
			</div>
		</div>
    </div>

    <div id="main-wrapper">
        <div class="col-md-12" style="padding:0;">
            <div class="panel panel-info">
                <div class="panel-heading clearfix">
                    <h4 class="panel-title">All Financial Support Transactions
                    <a style="padding: 2px;" target="_blank" href="txn-success_excel.php"><i style="font-size:25px; color:#fff; cursor:pointer;" class="fa fa-file-excel-o" title="Export to Excel"></i></a>
                    </h4>
                </div>
                <div class="panel-body">
                    <div class="table-responsive">
						<table class="display " id="userList" style="font-size: 13px;">
							<thead>
								<tr>
									<th>#No</th>
									<th>Amount</th>
									<th>TxnId</th>
									<th>Date</th>
									<th>Referral</th>
									<th>Name</th>
									<th>Email</th>
									<th>Mobile</th>
									<th>UseFor</th>
									<th>Remarks</th>
									<!--<th>Action</th>-->
								</tr>
							</thead>
							<tbody>
								<?php 
								$i=1;
								foreach($getTxnData as $tdd){
										
								?>
								<tr>
									<td><?php echo $i; ?></td>
									<td><?php echo $tdd->amount; ?></td>
									<td><?php echo $tdd->transaction_id; ?></td>
									<td><?php echo date('d-M-Y', strtotime($tdd->payment_date)); ?></td>
									<td><?php echo $tdd->refer_code; ?></td>
									<td><?php echo $tdd->name; ?></td>
									<td><?php echo $tdd->email; ?></td>
									<td><?php echo $tdd->mobile; ?></td>
									<td><?php echo $tdd->usefor; ?></td>
									<td><?php echo $tdd->remark; ?></td>
									<!--<td>
										<a href="<?php echo $link; ?>?testId=<?php echo $tst->test_taken_id; ?>" target="_blank">
											<i class="fa fa-eye" title="View Test Report" style="cursor:pointer;"></i>
										</a>
									</td>-->
								</tr>
								<?php $i++; } ?>
							</tbody>
						</table>
					</div>
				</div>
			</div>
        </div>
    </div>
    <!-- Main Wrapper -->

	<!-------------------edit ability modal---------------->
	<div class="modal fade" id="editAbilityModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
        <div class="modal-dialog">
            <div class="modal-content" style="border: 3px solid #ccc;">
                <div class="modal-header" style="padding: 5px 10px 0px 0px; height: 20px;">
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    	<span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body" id="edit_ability_modal"></div>
            </div>
        </div>
    </div>

    <div class="page-footer">
        <p class="no-s">https://santabrigade.in/</p>
    </div>
</div>
<!-- Page Inner -->

<script type="text/javascript" charset="utf-8">
	jQuery.noConflict();
    jQuery(function($) {
        $('#userList').dataTable({
            "bPaginate": true,
            "iDisplayLength": 50,
            "lengthMenu": [[10,20, 50, 100, 500, 1000 ], [10,20, 50, 100, 500, 1000]],
			"order": [[ 0, "asc" ]]
        });

	});

</script>

<link href="assets/css/jquery.dataTables.min.css" rel="stylesheet">
<link href="assets/css/responsive.dataTables.min.css" rel="stylesheet">
<script src="assets/js/jquery.dataTables.min.js"></script>
<script src="assets/js/dataTables.responsive.min.js"></script>

<?php include_once('footer.php'); ?>