1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / thread-self / root / proc / self / root / home / earnlouq / jeffautomobileinc.com / dealer /
Filename : sales.php
back
<?php
session_start();
error_reporting(0);
include('../../config/jaconfig.php');
include('include/checklogin.php');
check_login();
$title="Sales";
$dealer_id =$_SESSION['id'];



?>

<?php include('include/header.php');?>
		
<?php include('include/sidebar.php');?>

<div class="container-fluid py-4">

                  <div class="card" style="padding:30px;">
                <h5 class="card-header">Sales</h5>
                <div class="table-responsive table-wrapper-top text-nowrap" >
                <p style="padding-left:10vw;color:#cb0c9f;"><?php if($msg) { echo htmlentities($msg);}?> </h5>
                    
                <table class="table table-bordered" id="dataTables-example" >
                  <thead>
                    <tr>
                      <th>SN</th>
                      <th>Order ID</th>
                      <th>Amount</th>
                      <th>Status</th>
                      <th>Date</th>
                      <th>Order Details</th>

                    </tr>
                  </thead>
                  <tbody>
                  <?php
                 $query="SELECT co.*, p.dealer_id
                 FROM customer_order co
                 JOIN products p ON co.pid = p.product_id
                 WHERE co.p_status = 'Confirmed'
                 AND p.dealer_id = '$dealer_id' ";
                 $result=mysqli_query($con,$query);
                  $cnt=+1;
                  if(mysqli_num_rows($result)>0){
                    while($row=mysqli_fetch_array($result)){
                      ?>
                    <tr>
                    <td><?php echo $cnt++;?></td>

                      <td>
                        <div class="d-flex px-2 py-1">
                         
                          <div class="d-flex flex-column justify-content-center">
                          <p class="text-xs font-weight-bold mb-0"><?php echo htmlentities($row['trx_id']);?></p>
                     
                          </div>
                        </div>
                      </td>
                      <td>
                        <p class="text-xs font-weight-bold mb-0">&pound;<?php echo htmlentities($row['p_price']);?></p>
                      </td>
                      <td>
                      <p class="btn btn-success"><?php echo htmlentities($row['p_status']);?></p>

                      
                      </td>
           <td>
           <p class="text-xs font-weight-bold mb-0"><?php echo htmlentities($row['date']);?></p>
                      </td>
                      <td class="align-middle">
                      <a href="order-details.php?id=<?php echo $row['trx_id'];?>" 
                      class="btn btn-success me-1 add-to-cart-button" >View Details</a>

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

                      echo"No Record Found!";
                    }

                 

                    ?>
                 
                   
                   
                  
                  </tbody>
                </table>
              </div>
            </div>
          </div>
        </div>
      </div>

      <div style="margin-left:10vw;height:30vh;"></div>



<?php include('include/footer.php');?>