<?php ob_start(); ?> 
<!DOCTYPE html> 
<html lang="en">  

<head>
<?php   require_once 'head_link.php'; ?>

</head>

<body>
 
<?php   require_once 'header1.php'; ?> 

<?php
	if(isset($_GET['delete_id']))
	{ 
		$stmt_delete = $DB_con->prepare('DELETE FROM assets WHERE id =:uid');
		$stmt_delete->bindParam(':uid',$_GET['delete_id']);
		$stmt_delete->execute();
		 
	}

?>

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


  <main id="main" class="main">

    <div class="pagetitle bg-light rounded p-2"> 
	  <h1><i class="bi bi-box-seam"></i>  Assets List | 
	  Total Asset Price : <?php 
$sql = $con->query("SELECT sum(`price`) as `gtotal` FROM assets where user_id='".$_SESSION['id']."' ");
$row = $sql->fetch_assoc();
echo $row['gtotal'];
?> |   <a target="_blank" href="assets-print"><i class="bi bi-printer"></i></a> | 
	  <span> <a href="asset-add">  <i class="bi bi-plus-circle-fill"></i> </a> </span>  </h1>
	
    </div> 

    <section class="section">
      <div class="row">
	  
        <div class="col-lg-12">

          <div class="card">
            <div class="card-body">
             
              <table class="table table-hover datatable">
                <thead class="alert-primary">
                        <tr>
							<th>SL</th>
							<th>Rooms</th>
							<th>Equipments</th>
							<th>Details</th>
							<th>Qty</th>
							<th>Price</th>
							<th>Total</th>
							<th>Buy From </th>
							<th>Date</th>
							<th>Edit</th>
							
							<th>Delete</th>
                        </tr>
                  </thead>
				  
                 <tbody id="tbody">
							<?php
							$sl=0;
								$eq=mysqli_query($con,"select * from assets                             
 							  left join asset_cat on asset_cat.ast_id=assets.ast_cat
 							  left join asset_rooms on asset_rooms.rom_id=assets.rooms
							  where assets.user_id='".$_SESSION['id']."' ORDER BY assets.id DESC ");
								while($eqrow=mysqli_fetch_array($eq)){
									$eidm=$eqrow['id'];
									?>
										<tr> 
											<td><?php echo ++$sl; ?></td> 
											<td><?php echo $eqrow['room_name']; ?></td>
											<td><?php echo $eqrow['ast_name']; ?></td>
											<td><?php echo $eqrow['details']; ?></td>
											<td><?php echo $eqrow['quantity']; ?></td>
											<td><?php echo $eqrow['price']; ?></td>
											<td><?php echo $eqrow['total_price']; ?></td>
											<td><?php echo $eqrow['buy_from']; ?></td>
											<td><?php echo date("d-M-Y", strtotime($eqrow['entry_date'])); ?></td>
											
											
				<td><a  class="btn-sm btn-info" href="asset-edit?update=<?php echo $eqrow['id']; ?>" title="click for edit" 
                 onclick="return confirm('Do You Want To Edit ?')"><span class="bi bi-pencil"></span>  Edit</a> </td>
				
				<td>
				
					<a class="btn-sm btn-danger delete-btn" href="#"   data-id="<?php echo $eqrow['id']; ?>" 
					   data-bs-toggle="modal" data-bs-target="#confirmDeleteModal" 
					   title="Click for delete"> <span class="bi bi-trash"></span> Delete
					</a>
				 
					<?php  require_once 'modal/delete_modal_for_all_list.php'; ?>
				</td>
			
				
			</tr>
		<?php
		}  
		?>

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

        </div>
      </div>
    </section>

  </main>
  
  <?php  require_once 'footer1.php'; ?>