<html>
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 14 (filtered)">
<style>
<!--
 /* Font Definitions */
 @font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Tahoma;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin-top:0in;
	margin-right:0in;
	margin-bottom:8.0pt;
	margin-left:0in;
	line-height:107%;
	font-size:11.0pt;
	font-family:"Calibri","sans-serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
	{mso-style-link:"Balloon Text Char";
	margin:0in;
	margin-bottom:.0001pt;
	font-size:8.0pt;
	font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
	{mso-style-name:"Balloon Text Char";
	mso-style-link:"Balloon Text";
	font-family:"Tahoma","sans-serif";}
.MsoChpDefault
	{font-family:"Calibri","sans-serif";}
.MsoPapDefault
	{margin-bottom:8.0pt;
	line-height:107%;}
@page WordSection1
	{size:13.0in 8.5in;
	margin:48.25pt .5in .5in .75in;}
div.WordSection1
	{page:WordSection1;}
.style1 {
	font-family: "Times New Roman", "serif";
	font-size: 12.0pt;
}
-->
</style>
<?php include('print_header.php'); ?>
<?php include('session.php'); ?>
</head>

<body lang=EN-US>
<div class="empty">
<?php include('navbar.php'); ?>
<div class="container">
  <div class="row-fluid">
      <div class="col-lg-12">
            <div class="alert alert-success alert-dismissable">
             <button type="button" class="close" data-dismiss="alert" aria-hidden="true">&times;</button>
             <i class="icon-check"></i><strong> All Stock Print Report</strong>
            </div>
       </div>
    </div>
  </div>
 </div>
</div>

 <div class="container">
 <div class="row-fluid">
 <div class="block">
<div class="row-fluid">

<div class=WordSection1>



<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><b><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>&nbsp;</span></b></p>

<div class="container">
<div class="container-fluid">
<div class="row-fluid">
<div class="pull-left">
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
"Times New Roman","serif"'>All Stock
    <o:p></o:p></span></p>

<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
"Times New Roman","serif"'>DATE: <?php
 $date = new DateTime();
 echo $date->format('l, F jS, Y');
 $get_id='1';?><o:p></o:p></span></p>

<div class="pull-right">
   <div class="empty">
           <p class=MsoNormal style='margin-bottom:0in; margin-left:-110px; margin-top:-30px; margin-bottom:.0001pt;line-height:
           normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
           "Times New Roman","serif"'>
		   <a href="#" onClick="window.print()" class="btn btn-info" id="print" data-placement="top" title="Click to Print"><i class="icon-print icon-large"></i> Print List</a></p>		      
		   <script type="text/javascript">
		     $(document).ready(function(){
		     $('#print').tooltip('show');
		     $('#print').tooltip('hide');
		     });
		   </script> 
            <p class=MsoNormal style='margin-bottom:0in; margin-top:-30px; margin-bottom:.0001pt;line-height:
            normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
           "Times New Roman","serif"'>
			<a id="return" data-placement="top" class="btn btn-success" title="Click to Return" href="device_stocks.php"><i class="icon-arrow-left"></i> Back</a></p>		
			<script type="text/javascript">
			$(document).ready(function(){
			$('#return').tooltip('show');
			$('#return').tooltip('hide');
			});
			</script>       	   
    </div>
</div>
    
<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
"Times New Roman","serif"'><o:p>&nbsp;</o:p></span></p>
<table class=MsoTableGrid border=1 cellspacing=0 cellpadding=0
 style='border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt;
 mso-yfti-tbllook:1184;mso-padding-alt:0in 5.4pt 0in 5.4pt'>
 <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:23.25pt'>
  <td width=188 style='width:140.9pt;border:solid windowtext 1.0pt;mso-border-alt:
  solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1;
  mso-background-themeshade:191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>Location<o:p></o:p></span></b></p>
  </td>
  <td width=188 style='width:140.9pt;border:solid windowtext 1.0pt;mso-border-alt:
  solid windowtext .5pt;background:#BFBFBF;mso-background-themecolor:background1;
  mso-background-themeshade:191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>SERIAL NO<o:p></o:p></span></b></p>
  </td>
  <td width=188 style='width:140.9pt;border:solid windowtext 1.0pt;border-left:
  none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
  191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>TYPE<o:p></o:p></span></b></p>
  </td>
  <td width=188 style='width:140.9pt;border:solid windowtext 1.0pt;border-left:
  none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
  191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>MODEL<o:p></o:p></span></b></p>
  </td>
  <td width=188 style='width:140.9pt;border:solid windowtext 1.0pt;border-left:
  none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
  191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>BRAND<o:p></o:p></span></b></p>
  </td>
  <td width=188 style='width:140.95pt;border:solid windowtext 1.0pt;border-left:
  none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
  191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>DISCRIPTION<o:p></o:p></span></b></p>
  </td>
  <td width=188 style='width:140.95pt;border:solid windowtext 1.0pt;border-left:
  none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  background:#BFBFBF;mso-background-themecolor:background1;mso-background-themeshade:
  191;padding:0in 5.4pt 0in 5.4pt;height:23.25pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-family:"Times New Roman","serif"'>STATUS<o:p></o:p></span></b></p>
  </td>
 </tr>
   <!--NALD, ARI DI ASTA ANG IMO NA I BUTANG SULOD SA MYSQL FETCH ARRAY-->
<?php
		$device_query = mysqli_query($con,"select * from stdevice 
		LEFT JOIN stlocation ON stdevice.stdev_id=stlocation.stdev_id
		LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id ");
		while($row = mysqli_fetch_array($device_query)){
		$id = $row['id'];
		$dev_id = $row['dev_id'];
?>
 <tr style='mso-yfti-irow:1'>
  <td width=188 valign=top style='width:140.9pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['stdev_location_name']; ?><o:p></o:p></span></p>
  </td>
  <td width=188 valign=top style='width:140.9pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_serial']; ?><o:p></o:p></span></p>
  </td>
  <td width=188 valign=top style='width:140.9pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_name']; ?><o:p></o:p></span></p>
  </td>
  <td width=188 valign=top style='width:140.9pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_model']; ?><o:p></o:p></span></p>
  </td>
  <td width=188 valign=top style='width:140.9pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_brand']; ?><o:p></o:p></span></p>
  </td>
  <td width=188 valign=top style='width:140.95pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_desc']; ?><o:p></o:p></span></p>
  </td>
  <td width=188 valign=top style='width:140.95pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>
  <p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-family:"Times New Roman","serif"'><?php echo $row['dev_status']; ?><o:p></o:p></span></p>
  </td>
 <?php } ?> 
  <!--NALD, ARI DI ASTA ANG IMO NA I BUTANG SULOD SA MYSQL FETCH ARRAY-->
 </tr>
 <tr style='mso-yfti-irow:2;mso-yfti-lastrow:yes'>
  <td width=1127 colspan=6 valign=top style='width:845.5pt;border:solid windowtext 1.0pt;
  border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt;
  padding:0in 5.4pt 0in 5.4pt'>

  </td>
 </tr>
</table>

<p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
&quot;Times New Roman&quot;,&quot;serif&quot;'><o:p>&nbsp;</o:p></span></p>

<p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
&quot;Times New Roman&quot;,&quot;serif&quot;'><o:p>&nbsp;</o:p></span></p>

<p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
&quot;Times New Roman&quot;,&quot;serif&quot;'>
  <o:p>&nbsp;</o:p>
</span></p>
<table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0"
 style='border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt;
 mso-yfti-tbllook:1184;mso-padding-alt:0in 5.4pt 0in 5.4pt'>
  <tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
    <td width="1127" colspan="8" valign="top" style='width:845.5pt;border:none;
  padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" align="center" style='margin-bottom:0in;margin-bottom:.0001pt;
  text-align:center;line-height:normal'><b style='mso-bidi-font-weight:normal'><span
  style='font-size:14.0pt;mso-bidi-font-size:11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>SUMMARY</span></b><b
  style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;mso-bidi-font-size:
  11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p></o:p>
    </span></b></p></td>
  </tr>
  <tr style='mso-yfti-irow:1'>
    <td width="60" valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;
  mso-bidi-font-size:11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></b></p></td>
    <td width="174" valign="top" style='width:130.5pt;border:solid windowtext 1.0pt;
  border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;
  mso-bidi-font-size:11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>TYPE
      <o:p></o:p>
    </span></b></p></td>
    <td width="186" valign="top" style='width:139.5pt;border:solid windowtext 1.0pt;
  border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;
  mso-bidi-font-size:11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>TOTAL
      <o:p></o:p>
    </span></b></p></td>
    <td width="144" valign="top" style='width:107.95pt;border:none;mso-border-left-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;
  mso-bidi-font-size:11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></b></p></td>
    <td width="141" valign="top" style='width:105.7pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;
  mso-bidi-font-size:11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></b></p></td>
    <td width="171" valign="top" style='width:128.35pt;border:solid windowtext 1.0pt;
  border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;
  mso-bidi-font-size:11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>STATUS
      <o:p></o:p>
    </span></b></p></td>
    <td width="192" valign="top" style='width:2.0in;border:solid windowtext 1.0pt;
  border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;
  mso-bidi-font-size:11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>TOTAL
      <o:p></o:p>
    </span></b></p></td>
    <td width="60" valign="top" style='width:44.75pt;border:none;mso-border-left-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><b style='mso-bidi-font-weight:normal'><span style='font-size:12.0pt;
  mso-bidi-font-size:11.0pt;font-family:&quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></b></p></td>
  </tr>
  <tr style='mso-yfti-irow:2'>
    <td width="60" valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <?php	
	          $my_Desktop = mysqli_query($con,"SELECT * FROM `stdevice` LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id where  device_name.dev_name='Desktop'");
			  $count = mysqli_num_rows($my_Desktop);
			  ?>
    <td width="174" valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>Desktop
      <o:p></o:p>
    </span></p></td>
    <td width="186" valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'><?php echo $count;?>
              <o:p></o:p>
    </span></p></td>
    <td width="144" valign="top" style='width:107.95pt;border:none;mso-border-left-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <td width="141" valign="top" style='width:105.7pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <?php
$new = mysqli_query($con,"select * from stdevice    
	LEFT JOIN stlocation ON stdevice.stdev_id = stlocation.stdev_id
	LEFT JOIN device_name ON device_name.dev_id = stdevice.dev_id
	WHERE stdevice.dev_status='New'");
$count = mysqli_num_rows($new);		                                               
?>
    <td width="171" valign="top" style='width:128.35pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>New
      <o:p></o:p>
    </span></p></td>
    <td width="192" valign="top" style='width:2.0in;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'><?php echo $count;?>
              <o:p></o:p>
    </span></p></td>
    <td width="60" valign="top" style='width:44.75pt;border:none;mso-border-left-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
  </tr>
  <?php	
	            $my_ultrabook = mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Ultra Book'  
				");
			    $count = mysqli_num_rows($my_ultrabook);
 ?>
  <tr style='mso-yfti-irow:3'>
    <td width="60" valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <td width="174" valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>Ultra Book
      <o:p></o:p>
    </span></p></td>
    <td width="186" valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'><?php echo $count;?>
              <o:p></o:p>
    </span></p></td>
    <td width="144" valign="top" style='width:107.95pt;border:none;mso-border-left-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <td width="141" valign="top" style='width:105.7pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <?php
$stock = mysqli_query($con,"select * from stdevice    
	LEFT JOIN stlocation ON stdevice.stdev_id = stlocation.stdev_id
	LEFT JOIN device_name ON device_name.dev_id = stdevice.dev_id
	WHERE stdevice.dev_status='In-stock'");
$count = mysqli_num_rows($stock);		                                               
?>
    <td width="171" valign="top" style='width:128.35pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>In-stock
      <o:p></o:p>
    </span></p></td>
    <td width="192" valign="top" style='width:2.0in;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'><?php echo $count;?>
              <o:p></o:p>
    </span></p></td>
    <td width="60" valign="top" style='width:44.75pt;border:none;mso-border-left-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
  </tr>
  <?php	
	           $u= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='laptop'  ");
			    $count = mysqli_num_rows($u);
?>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>Laptop</span></span></td>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'><?php echo $count;?>
            <o:p></o:p>
    </span></span></td>
    <?php
	$use = mysqli_query($con,"select * from stdevice    
	LEFT JOIN stlocation ON stdevice.stdev_id = stlocation.stdev_id
	LEFT JOIN device_name ON device_name.dev_id = stdevice.dev_id
	WHERE  stdevice.dev_status='In-use'");
$count = mysqli_num_rows($use);
?>
    <td valign="top" style='width:107.95pt;border:none;mso-border-left-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:105.7pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:128.35pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>In-use
      <o:p></o:p>
    </span></span></td>
    <td valign="top" style='width:2.0in;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'><?php echo $count;?></span></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td width="60" valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <?php	
	           $my_server = mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Server'   ");
			    $count = mysqli_num_rows($my_server);
?>
    <td width="174" valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p></o:p>
      </span><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>Server
        <o:p></o:p>
      </span></span></p></td>
    <td width="186" valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'><?php echo $count;?>
                <o:p></o:p>
    </span></span></p></td>
    <?php
$new = mysqli_query($con,"select * from stdevice    
	LEFT JOIN stlocation ON stdevice.stdev_id = stlocation.stdev_id
	LEFT JOIN device_name ON device_name.dev_id = stdevice.dev_id
	WHERE  stdevice.dev_status='In-use'");
$count = mysqli_num_rows($new);	                                               
?>
    <td width="144" valign="top" style='width:107.95pt;border:none;mso-border-left-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <td width="141" valign="top" style='width:105.7pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <td width="171" valign="top" style='width:128.35pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'>Damaged</p></td>
    <?php
$d = mysqli_query($con,"select * from stdevice    
	LEFT JOIN stlocation ON stdevice.stdev_id = stlocation.stdev_id
	LEFT JOIN device_name ON device_name.dev_id = stdevice.dev_id
	WHERE  stdevice.dev_status='Damaged'");
$count = mysqli_num_rows($d);	                                               
?>
    <td width="192" valign="top" style='width:2.0in;border-top:none;border-left:none;
  border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p></o:p>
    </span><span style="font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;"><?php echo $count;?></span></p></td>
  </tr>
  <?php	
	           $my_server = mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Adapter Converter'   ");
			    $count = mysqli_num_rows($my_server);
?>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td width="60" valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
    <td width="174" valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>Adapter Converter
      <o:p></o:p>
    </span></span></p></td>
    <td width="186" valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'> <span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></span>
                <o:p></o:p>
    </span></span></p></td>
    <?php
$new = mysqli_query($con,"select * from stdevice    
	LEFT JOIN stlocation ON stdevice.stdev_id = stlocation.stdev_id
	LEFT JOIN device_name ON device_name.dev_id = stdevice.dev_id
	WHERE stdevice.dev_status='In stock'");
$count = mysqli_num_rows($new);	                                               
?>
    <td width="144" valign="top" style='width:107.95pt;border:none;mso-border-left-alt:
  solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
  &quot;Times New Roman&quot;,&quot;serif&quot;'>
      <o:p>&nbsp;</o:p>
    </span></p></td>
  </tr>
  <?php	
	            $my_vga = mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Adapter Converter'  ");
			    $count = mysqli_num_rows($my_vga);
?>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>DVD</td>
    <?php	
	            $my_dvd= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where device_name.dev_name='DVD'  ");
			    $count = mysqli_num_rows($my_dvd);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Ethernet Adapter </td>
    <?php	
	            $my_ea= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Ethernet Adapter'  ");
			    $count = mysqli_num_rows($my_ea);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Pointer</td>
    <?php	
	            $my_pointer= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Pointer'  ");
			    $count = mysqli_num_rows($my_pointer);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Netgear WIFI Adapter </td>
    <?php	
	            $my_netgear= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Netgear WIFI Adapter'  ");
			    $count = mysqli_num_rows($my_netgear);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Spinetix </td>
    <?php	
	            $my_spinetix= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='SPINETIX HMP 130'  ");
			    $count = mysqli_num_rows($my_spinetix);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>LCD TV </td>
    <?php	
	            $my_lcd= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where device_name.dev_name='LCD MOBILE & TV'  ");
			    $count = mysqli_num_rows($my_lcd);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>LED TV </td>
    <?php	
	            $my_led= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where device_name.dev_name='LED MOBILE & TV'  ");
			    $count = mysqli_num_rows($my_led);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>External Hardisk </td>
    <?php	
	            $my_eh= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='External Hardisk'  ");
			    $count = mysqli_num_rows($my_eh);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Access Point </td>
    <?php	
	            $my_ap= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Access point'  ");
			    $count = mysqli_num_rows($my_ap);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Core Switch </td>
    <?php	
	            $my_core= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where device_name.dev_name='Core Switch'  ");
			    $count = mysqli_num_rows($my_core);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Floor Switch </td>
    <?php	
	            $my_floor= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Floor Switch'  ");
			    $count = mysqli_num_rows($my_floor);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Poe Switch </td>
    <?php	
	            $my_poe= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Poe Switch'  ");
			    $count = mysqli_num_rows($my_poe);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Thumbprint</td>
    <?php	
	            $my_t= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where device_name.dev_name='thumbprint'  ");
			    $count = mysqli_num_rows($my_t);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
  <tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
    <td valign="top" style='width:44.75pt;border:none;border-right:solid windowtext 1.0pt;
  mso-border-right-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>&nbsp;</td>
    <td valign="top" style='width:130.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'>Printer</td>
    <?php	
	            $my_p= mysqli_query($con,"SELECT * FROM `stdevice` 
				                             LEFT JOIN stlocation ON stlocation.stdev_id=stdevice.stdev_id 
											 LEFT JOIN device_name ON stdevice.dev_id=device_name.dev_id 
											 where  device_name.dev_name='Printer'  ");
			    $count = mysqli_num_rows($my_p);
?>
    <td valign="top" style='width:139.5pt;border-top:none;border-left:
  none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
  mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
  mso-border-alt:solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt'><span class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:
  normal"><?php echo $count;?></span></td>
  </tr>
</table>
<p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
&quot;Times New Roman&quot;,&quot;serif&quot;'><o:p>&nbsp;</o:p></span></p>

<p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
&quot;Times New Roman&quot;,&quot;serif&quot;'><o:p>&nbsp;</o:p></span></p>



<p class="MsoNormal" style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
&quot;Times New Roman&quot;,&quot;serif&quot;'><o:p>&nbsp;</o:p></span></p>


 
 <?php $query= mysqli_query($con,"select * from admin where admin_id = '$session_id'");
  $row = mysqli_fetch_array($query);
?>
 
</table>

<p class=MsoNormal style='margin-bottom:0in;margin-bottom:.0001pt;line-height:
normal'><span style='font-size:12.0pt;mso-bidi-font-size:11.0pt;font-family:
"Times New Roman","serif"'><o:p>&nbsp;</o:p></span></p>

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

</body>
<?php include('script.php'); ?>
<div class="empty">
<center>
<hr>
		<footer>
           <p>Co-X Inventory System (C.I.S) Copyright 2018</p>
        <footer>
</center>
</div>
</html>