<?php include('include/sidebar.php'); ?>
<!-- Start Welcome area -->

<?php include('include/header.php'); ?>
<div class="breadcome-area">
    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <div class="breadcome-list">
                    <div class="row">
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="breadcomb-wp">
                                <div class="breadcomb-icon">
                                    <i class="icon nalika-home"></i>
                                </div>
                                <div class="breadcomb-ctn">
                                    <h2>Agent Sale </h2>
                                </div>
                            </div>
                        </div>
                        <!-- <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="breadcomb-report">
                                <button data-toggle="tooltip" data-placement="left" title="Download Report" class="btn"><i class="icon nalika-download"></i></button>
                            </div>
                        </div> -->
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</div>

<div class="product-status mg-b-30">

    <div class="container-fluid">

        <div class="row">

            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">

                <div class="product-status-wrap">

                    <h4>Agent Sale List</h4>

                    <div class="add-product">

                        <!-- <a href="add_service.php">Add</a> -->

                    </div>

                    <table>

                        <tr>

                            <th>S.NO</th>

                            <th>User Name</th>

                            <th>Agent Name</th>

                            <th>Amount</th>

                            <th>Unit</th>
                            <th>Service</th>
                            <th>duration</th>
                            <th>Start Date</th>
                            <th>Expiry Date</th>

                            <th>Time</th>

                            <th>Action</th>

                        </tr>
                        <?php
                        $q = "select transaction.*,users.name,services.unit,services.service,services.duration,agent.name as agent_name from transaction inner join users on users.id=transaction.user_id inner join services on services.id=transaction.service_id inner join agent on agent.id=transaction.agent_id where agent_id!=0";
                        $query = mysqli_query($conn,$q);
                        $i=1;
                        if (mysqli_num_rows($query)>0) {
                           
                        while($res = mysqli_fetch_array($query)) { 
                            $Date = $res['date'];
                            $expirydate= date('Y-m-d', strtotime($Date. ' + 365 days'));
                            ?>
                            <tr>

                                <td><?php echo $i++; ?></td>

                                <td><?php echo $res['name'] ?></td>
                                <td><?php echo $res['agent_name'] ?></td>
                                <td><?php echo $res['txn_amount'] ?></td>
                                <td><?php echo $res['unit'] ?></td>
                                <td><?php echo $res['service'] ?></td>
                                <td><?php echo $res['duration'] ?></td>
                                <td><?php echo $res['date'] ?></td>
                                <td><?php echo $expirydate ?></td>
                                <td><?php echo $res['time'] ?></td>
                                <td>

                                    <!-- <button data-toggle="tooltip" title="Edit" class="pd-setting-ed"><a style="color: #fff;" href="edit_service.php?id=<?php echo $res['id'] ?>"><i class="fa fa-pencil-square-o" aria-hidden="true"></i></a></button> -->

                                    <button onclick="del(<?php echo $res['id'] ?>)" data-toggle="tooltip" title="Trash" class="pd-setting-ed"><i class="fa fa-trash-o" aria-hidden="true"></i></button>

                                </td>

                            </tr>
                        <?php } } ?>

                        </table>

                   </div>

               </div>

           </div>

       </div>

   </div>
<script>
    function del(e) {
      var verify = confirm("Do you really want to delete!!!");
      if(verify) {
          $.ajax({
              url: "delete.php",
              type: "POST",
              data: {
                  delete_order_id: e,
              },
              success: function(response){
                 location.reload();
              },
          })
      }
  }
</script>
   <?php include('include/footer.php'); ?>