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

$Compamies=DB_query("select * from companies",$db);
$CompamiesRow=DB_fetch_array($Compamies); 
?>

<!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>Quotation Register Report</title>
<style type="text/css" media="print">
  @page port {size: portrait;}
@page land {size: landscape;}
 .portrait {page: port;}
.wrapper {page: land;}

</style>

<style type="text/css"> 
@page {size: portrait; margin:10px;}

@media print{
  *{box-sizing:border-box;}
body{ margin:0px; padding:0px;  font-size:10px; 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: 28px;
  font-weight:bold;
  text-transform: uppercase;
}
h2{
  font-size: 18px; line-height: 26px;
  font-weight:normal;
}
thead{display: table-header-group; border-top:#000000 1px solid;}
.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;
  float: left; position: relative;
}
 .div_first .left
  {
    width:16%; text-align:center; height:auto; vertical-align:middle; padding: 1% 0; float: left;
  }
  .div_first .middle
  {
    width:68%; text-align:center; padding: 1% 0; margin:0 auto; float: left;
  }
  .div_first .right
  {
    width:16%; text-align:center; padding: 1% 0;  float: left;
  }

.div_first .full{text-align: center; border: 0;}
.div_second, .div_third{
  width: 100%;
  height:auto;
  border-top: #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;}
.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{ 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:66%;}
.mt27{margin-top:4px; width:66%;}
.border_top{border-top:#000 1px solid;}
.border_bottom{border-bottom:#000 1px solid;}
.wdt1{width:10%;}
.wdt2{width:180px;}
.wdt3{width: 66px;}
.wdt4{width: 120px;}
.wdt5{width: 52px;}
.wdt6{width: 70px;}
}

@media screen{
/* CSS Document */
*{box-sizing:border-box;}
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: 32px;
  font-weight:bold;
  text-transform: uppercase; 
}
h2{
  font-size: 18px; line-height: 28px;
  font-weight:normal; 
}
.div_first, .div_first .full{
  width: 100%; height: auto;
  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:16%; text-align:center; height:auto; vertical-align:middle; padding: 1% 0; 
        }
        .div_first .middle
        {
          width:68%; text-align:center; padding: 1% 0; position: relative; margin:0 auto;
        }
        .div_first .right
        {
          width:16%; text-align:center; padding:1% 0; 
        }
.div_second, .div_third, .div_forth{
  width: 100%; height: auto;
  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:96%;}
.mt27{margin-top:4px; width:56%;}
.border_top{border-top:#000 1px solid;}
.border_bottom{border-bottom:#000 1px solid;}
.wdt1{width:10%;}
.wdt2{width:180px;}
.wdt3{width: 66px;}
.wdt4{width: 120px;}
.wdt5{width: 52px;}
.wdt6{width: 70px;}
}
</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">
  <div class="main">
    <!-- <div class="div_first">
    
    <?php $logoImage=($CompamiesRow['CompanyLogo']=='')?'Final_Logo_RM.png':$CompamiesRow['CompanyLogo']; ?>
        <div class="left"><img src="Setup/CompanyLogo/<?php echo $logoImage;  ?>" class="mt26" /></div>
        <div class="middle"><?php 
      if($CompamiesRow['CompanyName']!="") {echo "<h1>".$CompamiesRow['CompanyName']."</h1>"; } else { echo "";}
      
      if($InoRow['deladd1']!="") { echo $InoRow['deladd1']; } else { echo "";}
      if($InoRow['deladd2']!="") { echo ", ". $InoRow['deladd2']; } else { echo "";}
      if($InoRow['deladd3']!="") { echo ", ". $InoRow['deladd3']; } else { echo "";}
      if($InoRow['city']!="") { echo ", ". $s->getFieldValue("city_master", "id='".$InoRow['city']."'", "city"); } else { echo "";}
      if($InoRow['pincode']!="") { echo " - ".$InoRow['pincode']; } else { echo "";}
      if($InoRow['state']!="") { echo ", ". $s->getFieldValue("state_master", "id='".$InoRow['state']."'", "state"); } else { echo "";}
      if($InoRow['country']!="") { echo ", ". $s->getFieldValue("country_master", "id='".$InoRow['country']."'", "country");
      
       } else { echo "";}
      ?>
       <div class="full"><span class="f11"><?php echo "Phone No.:".$CompamiesRow['Phone'].",   Fax No.: ".$CompamiesRow['fax'].", Email ID.: ".$CompamiesRow['email'].",   Website: ".$CompamiesRow['website']; ?><br>
    <?php  echo $_SESSION['mess']; ?>
    </span></div>
        <h2>Quotation Register</h2>
        </div>
        <div class="right"></div>       
    </div> -->
    <div class="div_first">
        <?php echo $s->print_header(); ?>
        <h3 style="text-transform:uppercase;text-align:center;padding:5px;">Quotation Register</h3>
    </div>
  </div>

        
<div class="div_second" >
  <table width="100%" cellpadding="3" cellspacing="0" border="0">
  <thead>
  <tr>
    <th width="3%"  class="f12">S. No. </th>
    <th width="6%" class="f12 ">Date</th>
    <th width="12%" class="f12">Quotation No. </th>
    <th width="10%" class="f12">Branch</th>
    <th width="20%" class="f12">Vendor Name</th>
    <th width="70" class="f12">Item Code</th>
    <th class="f12">Item Name</th>
    <th width="50" class="f12">UOM</th>
    <th width="60" class="f12">Quantity</th>
    <th width="60" class="f12">Rate</th>
    <th width="60" class="f12">Total Discount</th>    
    <th width="70" class="f12">Total Amt</th>
  </tr>
  </thead>
  <?php
   $sql=$_SESSION['quat_reg1'];
  $result=DB_query($sql,$db);
    $i=1;
    if(DB_num_rows($result)>0)
    {
      while($myrow=DB_fetch_array($result))
      {
      ?>
    
  <tr>
    <td valign="top" class="f11"><?php echo $i;?></td>
    <td valign="top" class="f11"><?php echo ConvertSQLDate($myrow['Quotation_Date']);?></td>
    <td valign="top" class="f11"><?php echo $myrow['quotation_no']; //echo "===".$myrow['id'];?></td>
    <td valign="top" class="f11"><?php $sitename=$s->getField('locations','loccode',$myrow['Site'],'locationname');
  echo $sitename;?></td>
    <td valign="top" class="f11"><?php $sitename1=$s->getField('suppliers','id',$myrow['mst_supplierno'],'vendor_name');
  echo $sitename1;?></td>
    <td colspan="7" style="padding:0px;" valign="top"><table width="100%" border="0" cellpadding="3" cellspacing="0" >
      <?php 
      
    if($_REQUEST['itemCode']=='')
   $details_sql="Select * from vendorquotationdetails where parant_id=".$myrow['id']."";
    else
    $details_sql="Select * from vendorquotationdetails where parant_id=".$myrow['id']." and mst_productid='".$_REQUEST['itemCode']."'";
  $details_res=DB_query($details_sql,$db);  
  if(DB_num_rows($details_res)>0){
  $tot_received='';
  while($details_row=DB_fetch_array($details_res)){
    
  ?>
      <tr>
        <td class="f11" valign="top" width="70"><?php echo $s->getField('item_master','id',$details_row['mst_itemid'],'StockID');?></td>
        <td valign="top" class="f11"><?php echo $s->getField('item_master','id',$details_row['mst_itemid'],'item_name');?></td>
        <td width="50" valign="top" class="f11"><?php  $sitename1=$s->getField('item_master','id',$details_row['mst_itemid'],'mst_unitid');
    $sitename2=$s->getField('unitsofmeasure','unitid',$sitename1,'unitname');
  echo $sitename2;?></td>
   <td width="60" valign="top" class="f11" style="text-align:right"><?php echo number_format((float)$details_row['Quantity'],2); $tot_received[]=$details_row['quantity']; ?></td>
  <td width="60" valign="top" class="f11" style="text-align:right"><?php echo $details_row['Rate']; $tot_rate[]=$details_row['rate'];?></td>
  <td width="60" valign="top" class="f11" style="text-align:right"><?php echo $x=$details_row['Discount']; $tot_disc[]=$x;?></td>
  <td width="70" class="f11" valign="top" style="text-align:right"><?php echo number_format((float)$details_row['basic_Amt'],2); $tot_Amount[]=$details_row['basic_Amt'];?></td>
       </tr>
      <?php } ?>     
      <?php } ?>
      
    </table></td>
  </tr>
  <?php $i++;}
  ?>
  <tr>
     <td colspan="11" align="right"><strong>Total</strong></td>
     <td style="text-align:right"><strong><?php echo array_sum($tot_Amount); ?></strong></td>
  </tr>
  <?php
      }
    else
    {?>
  <tr>
    <td colspan="12"><font color="#FF0000"><strong>No Record Found</strong></font></td>
  </tr>
  <?php   
    }
  
  ?>
  
</table>
<?php if(!empty($tot_Amount)) { ?>

<!--<table width="1200px" cellpadding="0" cellspacing="0" border="0" style="border:solid 1px #666666;">
  <tr style="background-color:#CCCCCC; height: 30px">
  <td width="67" >&nbsp;</td>
  <td width="67"  >&nbsp;</td>
  
   <?php if($_REQUEST['site']=='') { ?> <td width="117"  >&nbsp;</td>
   <?php } ?>
  <?php if($_REQUEST['vendor']=='') { ?><td width="97" >&nbsp;</td>
  <?php } ?>
  <td width="92" >&nbsp;</td>
  <td width="184"  >&nbsp;</td>
        <td width="84"  ><strong>
          <center>
        </center></strong></td>
      
        <td width="259"  >&nbsp;</td>
    <td width="83"  >&nbsp;</td>
        <td width="84"  ><strong>Grand Total</strong></td>
      <td width="64" ><span style=" white-space:nowrap;"><?php  echo array_sum($tot_Amount); ?></span></td>
  </tr>
</table> -->

<?php } ?>
        </div>
    </div>
</div>


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

</body>
</html>