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

<?php include "head.php" ; ?>
<body>
	<!-- Main Wrapper -->

	<div class="main-wrapper">

		<!-- Header -->

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

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

		
			<!-- Breadcrumb -->
			<?php include "breadcrumb.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 "vendor_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>Paid Amount</h6>
															<?php
            											        $sql = "SELECT (SELECT sum(order_price) FROM order_master WHERE customer_id = '$user_id' And paid_status = 2 ) as paid 
            											        ,(SELECT sum(add_on) as bonus FROM order_master WHERE customer_id = '$user_id' And paid_status = 2 ) as bonus FROM order_master WHERE customer_id = '$user_id' " ;
            											        $res = $config->query($sql);
            											        $s_row = $res->fetch_assoc();
            											    ?>
															<h3><?= empty($s_row['paid']) ? 0 : $s_row['paid'] ; ?></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>Bonus</h6>
															<h3><?= empty($s_row['bonus']) ? 0 : $s_row['bonus'] ; ?></h3>
														</div>
													</div>
												</div>
												
												<div class="col-md-12 col-lg-4">
													<div class="dash-widget ">
														<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>Overall Wallet</h6>
															<h3><?= empty($row['total_amount']) ? 0 : $row['total_amount'] ; ?></h3>
														</div>
													</div>
												</div>
											</div>
										</div>
									</div>
								</div>
							</div>
	                        <div class="row">
								<div class="col-md-12">
									<h4 class="mb-4">Payment History</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></th>-->
																		<!--<th></th>-->
																		<th>Paid Amount</th>
																		<th>Date</th>
																		<th>Status</th>
																	</tr>
																</thead>
																<tbody>
																    <?php
																        $sno = 1;
                     											        $sql = "SELECT * FROM payment_request WHERE pay_vendor_id = '$user_id' ORDER BY pay_id DESC" ;
                    											        $res = $config->query($sql);
                       											        while($p_row = $res->fetch_assoc()){
                        											        $status = $p_row['pay_status'];
                  											        ?>
																	<tr>
																		<td><?= $sno; ?></td>
																		<!--<td><?#= $p_row['ticket']; ?></td>-->
																		<!--<td><?#= $p_row['transaction_id']; ?></td>-->
																		<td><?= $p_row['amount'] ?></td>
																		<td><?= date('d-m-Y',strtotime($p_row['payment_date'])); ?></td>
																		<td>
																	    <?php
																            if($status == 2){
    																            $o_status = "Success" ;
    																            $btn = "success" ;
    																        }else if($status == 1){
    																            $o_status = "Pending" ;
    																            $btn = "warning" ;
    															            }else{
    																            $o_status = "Failed" ;
    																            $btn = "danger" ;
    																        }
															            ?>
																			<div class="table-action">
																				<a href="javascript:void(0);" class="btn btn-sm bg-<?= $btn; ?>-light"><?= $o_status; ?></a>
																			</div>
																		</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 -->

	<!-- 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>