<!DOCTYPE html>
<html lang="en"> 

<head>
<?php ob_start(); ?>
<?php   require_once 'head_link.php'; ?>

</head>

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

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

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

    <div class="pagetitle bg-light rounded p-2">
      <h1><i class="bi bi-file-earmark-minus-fill"></i> Assets Report By - <i class="bi bi-text-file-fill"></i> Room  Wise</h1>
       
    </div> 
  
	
  <section class="section">
      <div class="row">
	  
        <div class="col-lg-6">

          <div class="card">
            <div class="card-body p-5">
				
				<form class="form-horizontal" action="php_action/assets-report-by-rooms.php" method="post" id="getOrderReportForm">
				
				<div class="row mb-3 mt-5">
                  <label for="CustId" class="col-sm-3 control-label">Room Name</label>
                  <div class="col-sm-9">
                  <select style="width:100%;" class="form-control chosen-select" Id="RomId" name="RomId" required>
		<option value="#">Select Rooms</option>
				      	<?php 
				      	$sql = "SELECT distinct assets.rooms,asset_rooms.room_name FROM assets 
						left join asset_rooms on asset_rooms.rom_id=assets.rooms
						 ";
								$result = $con->query($sql);

								while($row = $result->fetch_array()) {
									echo "<option value='".$row[0]."'>".$row[1]."</option>";
								} // while
								
				      	?>
		</select> 
				  </div>
                </div>
				
			 
                <div class="text-center">
				  <button type="submit" class="btn btn-primary" id="generateReportBtn"> <i class="bi bi-file-earmark-text"></i> Open Report</button>
                </div>
				  
				
				 
				</form>

		
			</div>
          </div>

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

    <?php  require_once 'footer1.php'; ?>
	
	
<script src = "js/chosen.js"></script>
<script type = "text/javascript">
	$('.chosen-select').chosen({width: "100%"});
</script>

<script src="custom/js/report.js"></script>