<?php
session_start();
require_once'lib/config.php';
    $admin_user_id=$_SESSION['session_login'];
 $sql="SELECT *,admin_login.name as name,user_group.name as role_name FROM admin_login INNER JOIN user_group ON user_group.group_id=admin_login.role WHERE id='".$_SESSION['session_login']."'";
        $res=$conn->query($sql);
        if($res->num_rows > 0)
        {
            $row = $res->fetch_assoc();
            $array=$row['permission'];
            $role=$row['role'];
            $per=explode(",",$array);
           
            $permission=$per;
            
          }

 if (in_array("Prime Vendor", $permission) || $role==0){
 }else{
    header("location: dashboard");
 }

require_once 'header.php';
require_once 'navbar.php';
$type = $_GET['type'];
?>

<!-- Page content -->
<div class="container-fluid pt-8">
    <div class="page-header mt-0 p-3">
        <h3 class="mb-sm-0 text-uppercase"><?=$type?> PRIME VENDOR</h3>

    </div>
    <div id="alert2" class="col-md-12"></div>
    <!-- Table -->
    <div class="row">
        <div class="col-12">
            <div class="card shadow">

                <div class="p-4">
                    <div class="grid-margin">
                        <div class="">
                            <div class="table-responsive">
                                <table id="example" class="text-center table card-table table-vcenter text-nowrap  align-items-center">
                                    <thead>
                                        <tr>
                                            <th style="width: 80px">S.NO.</th>
                                            <th>Vendor Name</th>
                                            <th>Contact</th>
                                            <?php if($type!='not'){ ?>
                                                <th>Posted Booking</th>
                                                <th>Accepted Booking</th>
                                                <th>Membership Name</th>
                                                <th>Membership Price</th>
                                                <th>Membership Duration</th>
                                                <th>Start Date</th>
                                                <th>End Date</th>
                                                <th>Status</th>
                                            <?php } ?>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        $i=1;
                                        $date = date('Y-m-d h:i:s');
                                        if ($type=='active') {

                                            $sql="SELECT *,membership_log.status as status FROM membership_log LEFT JOIN vendor_profile ON membership_log.vendor_id=vendor_profile.vendor_id LEFT JOIN vendor_login ON membership_log.vendor_id=vendor_login.id LEFT JOIN membership ON membership_log.membership_id=membership.id WHERE end>='$date'";
                                        }elseif($type=='expired'){

                                            $sql="SELECT *,membership_log.status as status FROM membership_log LEFT JOIN vendor_profile ON membership_log.vendor_id=vendor_profile.vendor_id LEFT JOIN vendor_login ON membership_log.vendor_id=vendor_login.id LEFT JOIN membership ON membership_log.membership_id=membership.id WHERE end<'$date'";
                                        }elseif($type=='renewal'){

                                            $q="SELECT *,membership_log.status as status FROM membership_log LEFT JOIN vendor_profile ON membership_log.vendor_id=vendor_profile.vendor_id LEFT JOIN vendor_login ON membership_log.vendor_id=vendor_login.id LEFT JOIN membership ON membership_log.membership_id=membership.id group by membership_log.vendor_id having count(*)>1";
                                            $qq = mysqli_query($conn,$q);
                                            while($row = mysqli_fetch_array($qq)) {
                                                $vendor_id[] = $row['vendor_id'];
                                            }
                                            $vendor_id = implode(',', $vendor_id);

                                            $sql="SELECT *,membership_log.status as status FROM membership_log LEFT JOIN vendor_profile ON membership_log.vendor_id=vendor_profile.vendor_id LEFT JOIN vendor_login ON membership_log.vendor_id=vendor_login.id LEFT JOIN membership ON membership_log.membership_id=membership.id WHERE end>='$date' AND membership_log.status=1 AND membership_log.vendor_id IN ($vendor_id)";
                                            

                                        }else{
                                            $sql="SELECT *,membership_log.status as status FROM membership_log INNER JOIN vendor_profile ON membership_log.vendor_id=vendor_profile.vendor_id INNER JOIN vendor_login ON vendor_profile.vendor_id=vendor_login.id LEFT JOIN membership ON membership_log.membership_id=membership.id WHERE membership_log.status=1";

                                            // $sql = "SELECT vendor_login.*,vendor_profile.* FROM vendor_login INNER JOIN vendor_profile ON vendor_profile.vendor_id=vendor_login.id WHERE vendor_login.id IN (SELECT membership_log.vendor_id FROM membership_log WHERE status=1)";
                                        }

                                        $query = mysqli_query($conn,$sql);
                                        
                                        while($res = mysqli_fetch_array($query)) {
                                            $start= explode(' ', $res['start']);
                                            $end= explode(' ', $res['end']);
                                            $bookings=$conn->query("select * from bookings where vendor_id='".$res['vendor_id']."'");
                                            $accepted_booking=$bookings->num_rows;

                                            $post_bookings=$conn->query("select * from bookings where post_by_id='".$res['vendor_id']."'");
                                            $posted_booking=$post_bookings->num_rows;
                                            ?>
                                            <tr>
                                                <td><?php echo $i++; ?></td>
                                                <td><?php echo $res['full_name']; ?></td>
                                                <td><?php echo $res['contact']; ?></td>
                                                <?php if($type!='not'){ ?>
                                                <td><a href="vendor_booking?post_id=<?=$res['vendor_id']?>" class="text-dark" target="_blank"><?=$posted_booking; ?></a></td>
                                                <td><a href="vendor_booking?vendor_id=<?=$res['vendor_id']?>" class="text-dark" target="_blank"><?=$accepted_booking; ?></a></td>
                                                <td><?php echo $res['name']; ?></td>
                                                <td><?php echo $res['price']; ?></td>
                                                <td><?php echo $res['duration']; ?></td>
                                                <td><?php echo $start[0]; ?></td>
                                                <td><?php echo $end[0]; ?></td>
                                                <td>
                                                    <?php 
                                                    if ($res['status']==1) {
                                                        echo '<label class="badge badge-success">Active</label>';
                                                    }else{
                                                        echo '<label class="badge badge-danger">In Active</label>';
                                                    }
                                                    ?>

                                                </td>
                                                <?php } ?>
                                            </tr>

                                        <?php } ?>
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php
require_once 'footer.php';
  require_once 'jslinks.php';
//   require_once 'datatable.php';
?>

<!-- Adon JS -->
<script src="assets/js/custom.js"></script>
<script src="assets/js/datatable.js"></script>