<?php

include 'load.php';

if(isset($_GET['remove'])){
	$remove=mysqli_real_escape_string($conn,$_GET['remove']);
	mysqli_query($conn,"DELETE FROM investvideoclass WHERE classid='$remove'");
	echo "<script>window.location='videoclass.php';</script>";
}
?>

<!DOCTYPE html>
<html lang="en">

<head>
	
	<meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width,initial-scale=1">
    <title>Services | Sony Investment | sonyinvestments.com</title>
    <?php
	require_once 'headercss.php';
	?>

</head>

<body>

        <!--**********************************
        Main wrapper start
    ***********************************-->
    <div id="main-wrapper">
	
<?php
require_once 'header.php';
?>

        <!--**********************************
            Sidebar start
        ***********************************-->
        <div class="deznav">
            <div class="deznav-scroll">
<?php

require_once 'sidebarmenu.php';

?>
            </div>
        </div>
        <!--**********************************
            Sidebar end
        ***********************************-->
		
        <!--**********************************
            Content body start
        ***********************************-->
        <div class="content-body">
            <!-- row -->
            <div class="container-fluid">
				<div class="row">
				<div class="col-xl-12 col-xxl-12 col-sm-12">
				<div class="alert alert-danger bg-danger text-white" role="alert">
				<strong>Alert!</strong> ඔබගේ ගිනුම තහවුරු කිරීම අසම්පුර්නයි.<a href="identity_verify.php" class="btn btn-success float-right" style="padding: 0px 3px;">සම්පුර්න කරන්න</a>
				</div>
				</div>
				</div>    
                <div class="row page-titles mx-0">
                    <div class="col-sm-6 p-md-0">
                        <div class="welcome-text">
                            <h4>All Services</h4>
                        </div>
                    </div>
                    <div class="col-sm-6 p-md-0 justify-content-sm-end mt-2 mt-sm-0 d-flex">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="home.php">Home</a></li>
                            <li class="breadcrumb-item active"><a href="javascript:void(0);">Services</a></li>
                            <li class="breadcrumb-item active"><a href="javascript:void(0);">All Services</a></li>
                        </ol>
                    </div>
                </div>
				
				<div class="row">
					<div class="col-lg-12">
						<div class="row tab-content">
							<div id="list-view" class="tab-pane fade active show col-lg-12">
								<div class="card">
									<div class="card-header">
										<h4 class="card-title">All Services </h4>
										<a href="add_services.php" class="btn btn-square btn-secondary">+ Add Services</a>
									</div>
									<div class="card-body">
										<div class="table-responsive">
											<table id="example3" class="table table-bordered">
												<thead>
													<tr>
														<th>#</th>
														<th>Action</th>
														<th>Status</th>
														<th>Category</th>
														<th>Provider</th>
														<th>Service Name</th>
														<th>Service Code</th>
														<th>Comission Rate</th>
														<th>Add Time</th>
													</tr>
												</thead>
												<tbody>
<?php
$count=0;
$list_qury=mysqli_query($conn,"SELECT * FROM ormsservices where userid='".$customer."' ORDER BY sid ASC");

while($list_resalt=mysqli_fetch_array($list_qury)){
$count++;

?>
<tr>
<td><?php echo number_format($count,0); ?></td>
<td align="center">
<a href="edit_services.php?sid=<?php echo $list_resalt['sid']; ?>" class="btn btn-sm btn-primary"><i class="fa fa-lg fa-edit"></i></a>
<a href="services.php?remove=<?php echo $list_resalt['sid']; ?>" onClick="JavaScript:return confirm('Are your sure delete service?');" class="btn btn-sm btn-danger"><i class="fa fa-lg fa-trash"></i></a>
</td>
<td>
<?php 
						
							if($list_resalt['status'] == "Deactive"){

								echo '<button class="btn btn-danger btn-sm" on>Deactive</button>';

							}else if($list_resalt['status'] == "Active"){

								echo '<button class="btn btn-success btn-sm">Active</button>';

							}
?>
</td>
<td><h5 class="badge badge-primary">
<?php

						$id = $list_resalt['category'];;

						$query = $DB_con->prepare('SELECT catename FROM ormscategory WHERE cid='.$id);

						$query->execute();

						$result = $query->fetch();

						echo $result['catename'];

?>
</h5></td>	
<td><h5 class="badge badge-primary">
<?php

						$id = $list_resalt['provider'];;

						$query = $DB_con->prepare('SELECT pname FROM ormsproviders WHERE pid='.$id);

						$query->execute();

						$result = $query->fetch();

						echo $result['pname'];

?>
</h5></td>								
<td style="text-transform: capitalize;"><?php echo $list_resalt['sname']; ?></td>
<td style="text-transform: capitalize;"><?php echo $list_resalt['scode']; ?></td>
<td><?php echo $list_resalt['scomission']; ?>%</td>
<td><?php echo date_format(date_create($list_resalt['add_date']),"M d, Y - h:i:s A"); ?></td>
													
												</tr>
								<?php 
								}
								?>
												</tbody>
											</table>
										</div>
									</div>
                                </div>
                            </div>
						</div>
					</div>
				</div>
				
            </div>
        </div>
        <!--**********************************
            Content body end
        ***********************************-->


        <?php
		require_once 'footer.php';
		?>

		<!--**********************************
           Support ticket button start
        ***********************************-->

        <!--**********************************
           Support ticket button end
        ***********************************-->


    </div>
    <!--**********************************
        Main wrapper end
    ***********************************-->

    <?php
	require_once 'footerjs.php';
	?>
    
	
</body>
</html>