
<?php
session_name('CAKEPHP'); @session_start();
$PageSecurity = 1;
include('config.php');
include('includes/ConnectDB.inc');
include('includes/function_lib.php');
include('includes/LanguageSetup.php');
include('includes/DateFunctions.inc');

$qry=$_SESSION['qry'];

$sql=DB_query($qry,$db);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
  <meta http-equiv='Content-Type' content='text/html; charset=UTF-8' />
<title>Fixed Asset Register Report</title>
<style type="text/css"> 
@print {size:A4; margin:20px 20px;}

@media print{
body{ margin:0px; padding:0px;  font-size:12px; line-height: 18px; font-family: Arial, Helvetica, sans-serif; color:#000; font-weight:normal;}

h1,h2,h3,h4,h5,p{ margin:0px; padding:0px;}
p{ text-align:left;}

h1{
  font-size: 20px; line-height: 24px;
  font-weight:normal;
  font-family:Arial, Helvetica, sans-serif !important;
  color:#006699;  
}
h2{
  font-size: 18px; line-height: 22px;
  font-weight:normal;
  font-family:Arial, Helvetica, sans-serif !important;
}
thead{display: table-header-group;}
.wrapper{width:99%; height: auto; float:left; border:#000000 1px solid; border-bottom:#000000 1px solid;}
.div_first, .div_first .full{
  width: 100%; height: auto;
  /*border-bottom: #000000 1px solid;
  border-top: #000000 1px solid;*/
  /*border-left: #000000 1px solid;
  border-right: #000000 1px solid;*/
  float: left; position: relative;
}
 .div_first .left
        {
          width:10%; text-align:left; height:auto; vertical-align:middle; height:auto; padding: 10px; position: absolute; left: 0; top: 0;
        }
        .div_first .middle
        {
          width:60%; text-align:center; padding: 10px; margin:0 auto; position: relative;
        }
        .div_first .right
        {
          width:20%;text-align:right; padding: 10px; position: absolute; right: 0; top: 0;
        }

.div_first .full{text-align: center; border: 0;}
.div_second, .div_third{
  width: 100%;
  height:auto;
  /*border-top: #000000 1px solid;*/
  /*border-bottom: #000000 1px solid;*/
  /*border-left: #000000 1px solid;
  border-right: #000000 1px solid;*/
  float: left;
}
.div_second table tr th, .div_second table tr td{border-right:#000000 1px solid; border-bottom:#000000 1px solid;}
.div_second table tr th{text-align: left; border-top:#000000 1px solid;}
.div_second table tr th:last-child, .div_second table tr td:last-child{border-right:0;}
.div_second table tr:last-child td{border-bottom:0;}
.div_second table tr td > table tr td{border-right:#000000 1px solid; border-bottom:#000000 1px solid;}
.div_second table tr td > table tr td:last-child{border-right:0;}
.div_second table tr td > table tr:last-child td{border-bottom:0;}

.div_third table tr th, .div_third table tr td{ border-bottom:#000 1px solid; border-right:#000 1px solid;}
.div_third table tr th{background-color:transparent; text-align: left;}
.div_third table tr th:last-child, .div_third table tr td:last-child{border-right:none;}
.div_third table tr:last-child td{border-bottom:none;}

.f12{ font-weight: bold; color:#000; font-size:12px;}
.f11{color:#000; font-size:12px; line-height:18px;}
.f14{color:#000; font-size:18px;}
.mt26{margin-top:4px; width:90%;}
.mt27{margin-top:0px; width:90%;}
.mt28{margin-top:0px; width:100%;}
.border_top{border-top:#000 1px solid;}
.border_bottom{border-bottom:#000 1px solid;}
.panel{width:100%; height:auto; float:left;}
.wdt1{width:8%;}
.wdt2{width:100px;}
.wdt3{width: 66px;}
.wdt4{width: 80px;}
.wdt5{width: 52px;}
.wdt6{width: 60px;}
.tab-wdth{width:160%;}
}

@media screen{
/* CSS Document */
body{ margin:0px; padding:0px; background-color:#fff; font-size:12px; font-family: Arial, Helvetica, sans-serif; color:#000; font-weight:normal;}
h1,h2,h3,h4,h5,p{ margin:0px; padding:0px;}
p{ text-align:left;}

#foo{width:1070px; height: auto; margin:0px auto;}
.wrapper{width:1070px; height: auto; margin:10px auto; border-top:#000000 1px solid;}

h1{
  font-size: 24px; line-height: 28px;
  font-weight:bold;
  font-family:Arial, Helvetica, sans-serif !important;
  color:#006699;  
}
h2{
  font-size: 18px; line-height: 22px;
  font-weight:normal;
  font-family:Arial, Helvetica, sans-serif !important;  
}
.div_first, .div_first .full{
  width: 100%; height: auto;
  /*border-bottom: #000000 1px solid;
  border-top: #000000 1px solid;*/
  border-left: #000000 1px solid;
  border-right: #000000 1px solid;
  float: left; position: relative; display: table;
}
.div_first .full{text-align: center; border: 0; margin:10px 0 0;}
.div_first .left, .div_first .middle, .div_first .right{float: left; display: table-cell; vertical-align: middle;}
.div_first .left
        {
          width:8%; text-align:center; height:auto; vertical-align:middle; padding: 1%; 
        }
        .div_first .middle
        {
          width:78%; text-align:center; padding: 1%; position: relative; margin:0 auto;
        }
        .div_first .right
        {
          width:8%; text-align:center; padding:1%; 
        }
.div_second, .div_third, .div_forth{
  width: 100%; height: auto;
  /*border-bottom: #000000 1px solid;*/
  border-top: #000000 1px solid;
  border-left: #000000 1px solid;
  border-right: #000000 1px solid;
  float: left;
}
.div_second table tr th, .div_second table tr td{border-right:#000000 1px solid; border-bottom:#000000 1px solid;}
.div_second table tr th{background-color: #ccc; text-align: left;}
.div_second table tr th:last-child, .div_second table tr td:last-child{border-right:0;}
/*.div_second table tr:last-child td{border-bottom:0;}*/
.div_second table tr td > table tr td{border-right:#000000 1px solid; border-bottom:#000000 1px solid;}
.div_second table tr td > table tr td:last-child{border-right:0;}
.div_second table tr td > table tr:last-child td{border-bottom:0;}

.div_third table tr th, .div_third table tr td{ border-bottom:#000 1px solid; border-right:#000 1px solid;}
.div_third table tr th{background-color: #ccc; text-align: left;}
.div_third table tr th:last-child, .div_third table tr td:last-child{border-right:none;}
/*.div_third table tr:last-child td{border-bottom:none;}*/

.f12{font-weight: bold; color:#000; font-size:12px;}
.f11{ color:#000; font-size:12px; line-height:18px;}
.f14{ color:#000; font-size:18px;}
.mt26{margin-top:4px; width:90%;}
.mt27{margin-top:0px; width:100%;}
.mt28{margin-top:0px; width:90%;}
.border_top{border-top:#000 1px solid;}
.border_bottom{border-bottom:#000 1px solid;}
.panel{width:100%; height:auto; float:left; overflow:auto;}
.wdt1{width:10%;}
.wdt2{width:180px;}
.wdt3{width: 66px;}
.wdt4{width: 120px;}
.wdt5{width: 52px;}
.wdt6{width: 70px;}
.tab-wdth{width:160%;}
}
</style>
</head>
<body>
<div id="foo">
  <p style="text-align:right;"><input type="button" onclick="javascript:toggle_visibility('foo');" value="Print" /></p>
</div>
<div class="wrapper">
<?php 
   $sql1 = "SELECT * FROM companies where CompanyId='".$_SESSION['ACGCompanyId']."'";
  $sqlres = DB_query($sql1,$db);
  $companyRow = DB_fetch_array($sqlres);
  
// order Details
 $arr=array(1=>"Jan","Feb","Mar","Apr","May","June","July","Aug","Sept","Oct","Nov","Dec");
  

?>
<div class="div_first">
<?php $logoImage=($companyRow['CompanyLogo']=='')?'Final_Logo_RM.png':$companyRow['CompanyLogo']; ?>
      <div class="left"><img src="Setup/CompanyLogo/<?php echo $logoImage;  ?>" class="mt26" /></div>
      <div class="middle"><h1>Ayodhya Eye Hospital</h1>
      <span class="f12">A Unit of Mani Mandir Sewa Nyas Samiti</span> <br>
       <span class="f12">Tulsibari, Praikrma Marg, Ayodhya - 224123, Dist. - Faizabad</span>
       <div class="full"><h2>AMC Entry</h2>
       <span class="f11"><?php echo "<span class='f12'>Phone No.:</span> ".$CompamiesRow['Phone'].", <span class='f12'>Fax No.:</span> ".$CompamiesRow['fax'].", <span class='f12'>Email ID.:</span> ".$CompamiesRow['email'].", <span class='f12'>Website:</span> ".$CompamiesRow['website']; ?><br>
        <?php  echo $_SESSION['mess1']; ?><br>
       
      <?php //if($_SESSION['project']!='') { echo "Branch: ". $s->getField('locations','loccode',$_SESSION['project'],'locationname'); } else { echo ""; } ?> 

 <?php if($_SESSION['asset_group']!='') { echo "Group: ". $s->getField('machine_group_master','id',$_SESSION['asset_group'],'machine_gp_location'); } else { echo ""; } ?>

<?php if($_SESSION['asset_name']!='') { echo "Asset Name: ". $s->getField('machine_center','id',$_SESSION['asset_name'],'name'); } else { echo ""; } ?> 

 <?php if($_SESSION['frmdate']!='') { echo "From Date: ". $_SESSION['frmdate']; } else { echo $_SESSION['frmdate']; } ?>

 <?php if($_SESSION['todate']!='') { echo "To date: ". $_SESSION['todate']; } else { echo $_SESSION['todate']; } ?> 
 

<?php if($_SESSION['source']!='') { echo "Source: ". $_SESSION['source']; } else { echo ""; } ?> 

        </span></div>
      </div>
      <div class="right"><img src="images/eye-logo-blue.png" vspace="10" class="mt27" /></div>
</div>

<div class="div_second">

    <div class="panel">
	<table class="tab-wdth" border="0" cellspacing="0" cellpadding="3">
  	<tr>
  		<th width="3%" class="f12">S.No.</th>
	  	<th width="4%" class="f12">Branch</th>
	    <th width="4%" class="f12">Asset Code</th>
	    <th class="f12">Asset Name</th>
	    <th width="4%" class="f12">Asset Group</th>
	    <th width="4%" class="f12">Asset Type</th>
      <th width="4%" class="f12">Source</th>
	   	<?php 
   $title='';
   $title1=DB_query("select * from tbl_title_master order by serial_no ASC",$db);
   while($r=DB_fetch_array($title1))
   { 
    
    ?>
    <th width="4%" class="f12" ><?php echo $r['title_name'];?></th>
    <?php } ?>
	   	<th width="4%" class="f12">Purchase Date</th>
	   	<th width="4%" class="f12">Purchase Amount</th>
      <th width="4%" class="f12">Installed By</th>
   </tr>
<?php
$i=1;
$num=DB_num_rows($sql);
if($num>0)
{
while($row=DB_fetch_array($sql))
	{
	//$loc=DB_query("select locationname from locations where loccode='".$row['location']."'",$db);	
	//$location=DB_fetch_array($loc);
		$sqlG=DB_query("Select * from machine_group_master where id='".$row['under_group']."' ",$db); 
		 $myrow_group=DB_fetch_array($sqlG);

	
?>
<tr>
	<td class="f11"><?php echo $i; ?></td>
	<td class="f11"><?php echo $row['location']; //$location['locationname']; ?></td>
	<td class="f11"><?php echo $row['code']; ?></td>
	<td class="f11"><?php echo $row['name']; ?></td>
	<td class="f11"><?php echo $myrow_group['machine_gp_location']; ?></td>
	<td class="f11">
	  <?php if($row['asset_type']=='A'){echo "Asset";}else{ echo "Sub Asset";	} ?>
	</td>
  <td class="f11"><?php echo $row['source']; ?></td>

    
<?php 
   $title='';
   $title1=DB_query("select * from tbl_title_master order by serial_no ASC",$db);
   while($r=DB_fetch_array($title1))
   { 
    
    ?>
    <td class="f11" style="word-break:break-all;"><?php echo $row[$r['db_field_name']] ?>&nbsp;</td>
    <?php } ?>

        <td width="13%" class="f11">
          <?php  echo ConvertSQLDate($row['purchase_date']);?>
        </td>
        <td width="16%" class="f11">
          <?php  echo $row['purchase_amt'];?>
        </td>
        <td width="16%" class="f11">
          <?php  echo $row['insatallation_by'];?>
        </td>
</tr>
<?php $i++; }} else { ?>
	<tr><td colspan="11" style="text-align: center;"><font color="#FF0000" style="font-weight:bold;"><?php echo "No Records Found"; ?></font></td></tr>	 
	<?php }?> 
</table>	
	</div>
</div>

</div>
<script type="text/javascript" language="javascript">
function toggle_visibility(id) 
{
    var e = document.getElementById(id);
    e.style.display = 'none';
	window.print();
}
</script>
</body>
</html>
