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

$getElfQuery = "SELECT b.*, c.country_name, s.state_name, ct.city_name FROM `wp_sb_the_brigade` as b INNER JOIN `wp_sb_users` as u ON u.ID=b.user_id LEFT JOIN `wp_sb_loc_country` as c ON c.country_id=b.country_id LEFT JOIN `wp_sb_loc_state` as s ON s.state_id=b.state_id LEFT JOIN `wp_sb_loc_city` as ct ON ct.city_id=b.city_id where b.type='R' order by b.id desc";
$getElfData = $wpdb->get_results($getElfQuery);
?>

<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>The Brigade</h3>
			<div class="page-breadcrumb">
				<ol class="breadcrumb">
					<li><a href="dashboard">Home</a></li>
					<li class="active">Elves</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 Elves</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 title="user id">uId</th>
									<th>Unique Id</th>
									<th>Name</th>
									<th>Email</th>
									<th>Mobile</th>
									<th>Country</th>
									<th>State</th>
									<th>City</th>
									<th>RegDate</th>
									<!--<th>Action</th>-->
								</tr>
							</thead>
							<tbody>
								<?php 
								$i=1;
								foreach($getElfData as $ed){	
								?>
								<tr>
									<td><?php echo $i; ?>
									
									<a title="User Details" style="cursor:pointer; font-size:20px" href="./brigade-profile?user_id=<?php echo $ed->user_id; ?>" target="_blank">
										<i class="fa fa-eye"></i>
									</a>
									
									</td>
									<td><?php echo $ed->user_id; ?></td>
									<td><?php echo $ed->brigade_code; ?></td>
									<td><?php echo $ed->name; ?></td>
									<td><?php echo $ed->email; ?></td>
									<td><?php echo $ed->mobile; ?></td>
									<td><?php echo $ed->country_name; ?></td>
									<td><?php echo $ed->state_name; ?></td>
									<td><?php echo $ed->city_name; ?></td>
									<td><?php echo date('d-M-Y', strtotime($ed->add_date)); ?></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 -->

    <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": 100,
            "lengthMenu": [[100, 200, 300, 500, 1000 ], [100, 200, 300, 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'); ?>