<script>
$(document).ready(function() {

    $("#close").click(function() {

         $('#results').hide();    
    });

     $(".userlist").click(function() {
         
        var id=$(this).attr("id");
         $('#results').hide();
            $.ajax({
               type: "POST",
               url: "get-user-details.php",
               data: {
                   'id': id
               },
               dataType:"json",
               success: function(data) 
               {
                //   displaytickets(data.mobile);
                 $("#name").val(data.name);
                 $("#cid").val(data.id);
                 $("#email").val(data.email);
                 $("#mobile").val(data.mobile);
                 $("#details").html('<label class="form-label"><b>User Details</b></label><br><p>Address : '+data.address+' | <b>Wallet Balance : '+data.balance+'<b> | <b>Active Coupon(s) : '+data.coupon+'<b></p>');
                }
           });

    });
      $(".list").click(function() {
         
        var id=$(this).attr("id");
         $('#results').hide();
            $.ajax({
               type: "POST",
               url: "get-user-details.php",
               data: {
                   'id': id
               },
               dataType:"json",
               success: function(data) 
               {
                 $("#user").val(data.mobile);
                }
           });

    });
    
function displaytickets(cid)
{

    
    $.ajax({
    type: "POST",
    url: "get-tickets.php",
    data: {'cid':cid}, // serializes form input
    success: function (data) {
        $("#ticketlist").html(data);
         calculateTotals();
         
            // Reset coupon if no rows exist or subtotal becomes 0
            let subtotal = parseFloat($('#subtotal').val()) || 0;
            if (subtotal <= 0) {
                $('#coupon_code').val('');
                $('#coupon_discount').val('0.00');

                // Re-enable Apply buttons, hide Cancel buttons
                $('.apply-coupon').show();
                $('.cancel-coupon').hide();
            }
    }
   });
}
function calculateTotals() {
    let subtotal = 0;
    const taxRate = 0.18; // 18% GST

    // Sum all ticket totals
    $('#ticketlist table tbody tr').each(function () {
        let total = parseFloat($(this).find('td:eq(4)').text()) || 0;
        subtotal += total;
    });

    // Calculate tax
    let tax = subtotal * taxRate;

    // Get discounts
    let couponDiscount = parseFloat($('#coupon_discount').val()) || 0;
    let manualDiscount = parseFloat($('#Discount').val()) || 0;

    // Clamp discounts so they never exceed subtotal
    let maxAllowedDiscount = subtotal + tax;
    let totalDiscount = couponDiscount + manualDiscount;

    if (totalDiscount > maxAllowedDiscount) {
        totalDiscount = maxAllowedDiscount;
        // Optionally reset the fields too
        couponDiscount = Math.min(couponDiscount, maxAllowedDiscount);
        manualDiscount = maxAllowedDiscount - couponDiscount;

        $('#coupon_discount').val(couponDiscount.toFixed(2));
        $('#Discount').val(manualDiscount.toFixed(2));
    }

    // Final total (clamped at minimum 0)
    let grandTotal = subtotal + tax - totalDiscount;
    grandTotal = Math.max(grandTotal, 0);

    // Update values
    $('#subtotal').val(subtotal.toFixed(2));
    $('#tax').val(tax.toFixed(2));
    $('#grandtotal').val(grandTotal.toFixed(2));
}

   
});
</script>
<?php

require "conn.php"; 

    
    if (isset($_POST['mobile']))
    {
        
          $mobile = $_POST['mobile'];
            $sql="select * from tbl_user where mobile like'%$mobile%' and deleted_at is NULL and status='Active' limit 5";   
           
           $smt= mysqli_query($conn,$sql);
           if(mysqli_num_rows($smt))
           {
           echo '
             <ul  class="search-cell p-2 mt-1 rounded " style="list-style-type : none; position : absolute; background-color:#E3E6EA; color:black;width:100%;">
             <li><span id="close" style="float:right;">x</span></li>';
   //Fetching result from database.
   while ($rs = mysqli_fetch_array($smt)) {
       ?>
   
   <li id="<?php echo $rs['id']; ?>"  class="userlist">
     <?php echo $rs['uname']; ?>
   </li>
   
   
   <?php
      }
   echo '</ul>'  ;   
     
    }
    }
    else if (isset($_POST['user']))
    {
        
          $user = $_POST['user'];
            $sql="select * from tbl_user where (mobile like'%$user%' or uname like'%$user%') and deleted_at is NULL and status='Active' limit 5";   
           
           $smt= mysqli_query($conn,$sql);
           if(mysqli_num_rows($smt))
           {
           echo '
             <ul  class="search-cell p-2 mt-1 rounded " style="list-style-type : none; position : absolute; background-color:#E3E6EA; color:black;width:100%;">
             <li><span id="close" style="float:right;">x</span></li>';
   //Fetching result from database.
   while ($rs = mysqli_fetch_array($smt)) {
       ?>
   
   <li id="<?php echo $rs['id']; ?>"  class="list">
     <?php echo $rs['uname']; ?> - <?php echo $rs['mobile']; ?>
   </li>
   
   
   <?php
      }
   echo '</ul>'  ;   
     
    }
    }

?>