<?php
    session_start();
    if(isset($_SESSION['user_id']) && isset($_SESSION['user_name']) && $_SESSION['user_cate'] === "user"){
        $user_id = $_SESSION['user_id'] ;
        $username = $_SESSION['user_name'] ;
        // $ticket = $_SESSION['last_ticket'] ;
        // $company = $_SESSION['company'] ;
        $user_image = $_SESSION['user_image'] ;
    }else{
        header("Location:login.php") ;
    }
?>

<?php include "head.php" ; ?>
<style>
    .event-box img {
        height: 300px;
        width: 100%;
        min-height: 100%;
    }
    .event-title {
        font-weight: 500;
        color: #4b94e5;
        /*width: 40%;*/
    }
    .event-para {
        /*width: 60%;*/
        margin-left: 10px;
    }
</style>
<body>
	<!-- Main Wrapper -->

	<div class="main-wrapper">

		<!-- Header -->

		<?php include "header.php" ; ?>

		<!-- /Header -->
	<body>

		
			<!-- Breadcrumb -->
			<?php include "breadcrumbuser.php" ; ?>
			<!-- /Breadcrumb -->
			
			<!-- Page Content -->
			<div class="content">
				<div class="container-fluid">

					<div class="row">
						<div class="col-md-5 col-lg-4 col-xl-3 theiaStickySidebar">
							
							<!-- Profile Sidebar -->
							<?php include "sidebar.php" ; ?>
							<!-- /Profile Sidebar -->
							
						</div>
						
						<div class="col-md-7 col-lg-8 col-xl-9">
							<div class="row">
								<div class="col-md-12">
									<div class="card dash-card">
										<div class="card-body">
											<div class="row">
												<div class="col-md-12 col-lg-4">
													<div class="dash-widget dct-border-rht">
														<div class="circle-bar circle-bar1">
															<div class="circle-graph1" data-percent="75">
																<img src="assets/img/icon-01.png" class="img-fluid" alt="patient">
															</div>
														</div>
														<div class="dash-widget-info">
															<h6>Applied</h6>
															<h3>
															<?php
            											        $post_sql = "SELECT COUNT(DISTINCT event_id) as tot FROM apply_request WHERE user_id = '$user_id' " ;
            											        $post_res = $config->query($post_sql);
            											        $post = $post_res->fetch_assoc();
            											        echo $post['tot'];
            											    ?>
															</h3>
														</div>
													</div>
												</div>
												
												<div class="col-md-12 col-lg-4">
													<div class="dash-widget dct-border-rht">
														<div class="circle-bar circle-bar2">
															<div class="circle-graph2" data-percent="65">
																<img src="assets/img/icon-02.png" class="img-fluid" alt="Patient">
															</div>
														</div>
														<div class="dash-widget-info">
															<h6>Wallet</h6>
															<h3><?= empty($row['total_amount']) ? 0 : $row['total_amount']; ?></h3>
														</div>
													</div>
												</div>
												
												<div class="col-md-12 col-lg-4">
													<div class="dash-widget dct-border-rht">
														<div class="circle-bar circle-bar3">
															<div class="circle-graph3" data-percent="50">
																<img src="assets/img/icon-03.png" class="img-fluid" alt="Patient">
															</div>
														</div>
														<div class="dash-widget-info">
															<h6>Notification</h6>
															<h3>0</h3>
														</div>
													</div>
												</div>
											</div>
										</div>
									</div>
								</div>
							</div>
							
							<div class="row">
								<div class="col-md-12">
									<h4 class="mb-4">Applied Events</h4>
									<div class="appointment-tab">
										
										<div class="tab-content">
										
											<!-- Upcoming Appointment Tab -->
											<div class="tab-pane show active" id="upcoming-appointments">
												<div class="card card-table mb-0">
													<div class="card-body">
														<div class="table-responsive">
															<table class="table table-hover table-center mb-0">
																<thead>
																	<tr>
																		<th>S.No</th>
																		<th>Event Date</th>
																		<th>Event Name</th>
																		<th>Prize</th>
																		<th>Entry Paid</th>
																		<th>Applied Date</th>
																		<th></th>
																	</tr>
																</thead>
																<tbody>
																    <?php
																        $sno = 1;
                     											        $sql = "SELECT *,SUM(entry_fees) as tot FROM apply_request WHERE user_id = '$user_id' GROUP BY event_id ORDER BY apply_id DESC " ;
                    											        $res = $config->query($sql);
                       											        while($row = $res->fetch_assoc()){
                        											      $event_id = $row['event_id'];
                        											      $e_sql = $config->query("SELECT * FROM event_post WHERE event_id = '$event_id' ") ;  
                        											      $e_res = $e_sql->fetch_assoc();
                  											        ?>
																	<tr>
																		<td><?= $sno; ?></td>
																		<td><?= date('d-m-Y',strtotime($e_res['e_date'])); ?></td>
																		<!--<td><?#= $p_row['ticket']; ?></td>-->
																		<!--<td><?#= $p_row['transaction_id']; ?></td>-->
																		<td><?= $e_res['e_title'] ?></td>
																		<td><?= $e_res['e_type'] ?></td>
																		<td><?= ($row['entry'] == 'free') ? "Free" : $row['tot'] ; ?></td>
																		<td><?= date('d-m-Y',strtotime($row['apply_on'])); ?></td>
																		<td><a href="tournament-details.php?event=<?= $event_id ?>" class="btn btn-primary"><i class="fas fa-eye"></i></a></td>
																		<td><a href="invoices.php" class="btn btn-info"><i class="fas fa-file-invoice"></i></a></td>
																	</tr>
																	<?php $sno++; } ?>
																</tbody>
															</table>		
														</div>
													</div>
												</div>
											</div>
											<!-- /Upcoming Appointment Tab -->
									   
											
										</div>
									</div>
								</div>
							</div>

						</div>
					</div>

				</div>

			</div>		
			<!-- /Page Content -->
   	<!-- Footer -->

		<?php include "footer.php" ; ?>

		<!-- /Footer -->
	</div>

	<!-- /Main Wrapper -->
	<script>
		<?php if(isset($_SESSION['check']) && !empty($_SESSION['check'])) { ?>
		    swal({
                title: "<?= $_SESSION['check'] ?>", 
                text: "",
                icon: "<?= $_SESSION['alert'] ?>",
                button: {
                    className: "agree",
                },
            });
        <?php unset($_SESSION['check']) ; } ?>
    </script>
	<!-- jQuery -->

	<script src="assets/js/jquery.min.js"></script>

	<!-- Bootstrap Core JS -->

	<script src="assets/js/popper.min.js"></script>

	<script src="assets/js/bootstrap.min.js"></script>

	<!-- Sticky Sidebar JS -->
    <script src="assets/plugins/theia-sticky-sidebar/ResizeSensor.js"></script>
    <script src="assets/plugins/theia-sticky-sidebar/theia-sticky-sidebar.js"></script>
	
	<!-- Circle Progress JS -->
	<script src="assets/js/circle-progress.min.js"></script>
		
	<!-- Slick JS -->

	<script src="assets/js/slick.js"></script>

	<!-- Custom JS -->

	<script src="assets/js/script.js"></script>
		

</body>

<!-- doccure/  30 Nov 2019 04:11:53 GMT -->

</html>