
<?php
session_name('CAKEPHP'); @session_start();
$PageSecurity = 3;
include ('includes/session.inc');
include ('includes/function_lib.php');
include('includes/fun-php.php');
include('includes/fun-HRClass.php');
 ?>
<?php 
	 $sql=$_SESSION['POorderRegPrnt'];
	 $date_year=$_SESSION['date_year1'];
?>

<!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>Item Price 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: landscape; margin:10px;}

@media print{
  *{box-sizing:border-box;}
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: 30px;
  font-weight:bold;
  text-transform: uppercase;
}
h2{
  font-size: 18px; line-height: 28px;
  font-weight:normal;
}
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;
  float: left; position: relative;
}
 .div_first .left
  {
    width:16%; text-align:center; height:auto; vertical-align:middle; height:auto; 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; border-top:#000 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:96%;}
.mt27{margin-top:4px; width:66%;}
.border_top{border-top:#000 1px solid;}
.border_bottom{border-bottom:#000 1px solid;}
.wdt1{width:8%;}
.wdt2{width:100px;}
.wdt3{width: 66px;}
.wdt4{width: 80px;}
.wdt5{width: 52px;}
.wdt6{width: 60px;}
}

@media screen{
/* CSS Document */
*{box-sizing:border-box;}
body{ margin:0px; padding:0px; background-color:#fff; 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;}

#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: 30px;
  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>

<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>
 </head>
 <body>
<div id="foo">
  <p style="text-align:right;"><input type="button" onclick="javascript:toggle_visibility('foo');" value="Print" /></p>
</div>
<?php 
$Compamies=DB_query("select * from companies",$db);
$CompamiesRow=DB_fetch_array($Compamies);
$sql1 = "SELECT * FROM companies where CompanyId='".$_SESSION['ACGCompanyId']."'";
  $sqlres = DB_query($sql1,$db);
  $companyRow = DB_fetch_array($sqlres);
  $s=new db_query(); 
?>

<div class="wrapper">
  <!-- <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>Purchase Item Price Summary Report</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;">Purchase Item Price Summary Report</h3>
    </div>
<div class="div_second">
  <table width="100%" cellpadding="3" cellspacing="0" border="0" style="border-collapse:collapse;">
  <thead>
  <tr>
    <th width="4%" class="f12">S. No.</th> 
    <th width="80" class="f12">Item Code</th>
	  <th class="f12">Item Name</th>
	  <th width="50" class="f12">Unit</th>
    <?php for($i=1;$i<32;$i++){ ?><th width="10" class="f12"><?php echo $i;?></div></th>
    <?php } ?>
    </tr>
  </thead>
<?php
$k=1;
$res = DB_query($sql,$db);
while($row = DB_fetch_array($res))
{ ?>
<tr bgcolor="#e0e0e0" height="25">
<td class="f12"><?php echo $k; ?></td>
<td colspan="34" class="f12"><?php echo $s->getField('suppliers','id',$row['vendorid'],'vendor_name'); ?></td>
</tr>
<tr>
        <td></td>
	    <td colspan="34" style="padding:0px;" valign="top">
	    <table width="100%" border="0" cellpadding="3" cellspacing="0">
	    	<?php 
		    	if($_REQUEST['item']!='')
		    		 $cond=" and b.mst_itemid='".$_REQUEST['item']."'";
		    	else
		    	$cond="";

	    	   $query="SELECT b.mst_itemid FROM purchorders a,purchorderdetails b WHERE  a.id=b.parantId AND MONTH(po_date)='".$date_year[0]."' AND YEAR(po_date)='".$date_year[1]."' AND a.site='".$_REQUEST['site']."' and a.vendorId='".$row['vendorid']."'".$cond." GROUP BY b.mst_itemid";
              //$query=$_SESSION['POorderRegPrnt1'];
                $j=1; $result = DB_query($query,$db);
				$num=DB_num_rows($result);

                while($rows = DB_fetch_array($result)){
				
	    		$a=$s->getField('item_master','id',$rows['mst_itemid'],'mst_unitid'); 
				if($j!=$num)
				$style1="border-bottom:#808080 1px solid;";
				else
				$style1="border-bottom:none;";
				?>
				
			<tr style="<?php echo $style1; ?>">
              <td width="80" class="f11"><?php echo $s->getField('item_master','id',$rows['mst_itemid'],'StockID'); ?></td>
              <td class="f11"><?php echo $s->getField('item_master','id',$rows['mst_itemid'],'item_name'); ?></td>
              <td width="50" class="f11"><?php echo $s->getField('unitsofmeasure','unitid',$a,'unitname'); ?></td>
				
					<?php
					$rate_res1=array();
					  //$rate_sql=$_SESSION['POorderRegPrnt2']; 
					$rate_sql="SELECT DAYOFMONTH(a.po_date) as day1,b.Rate FROM purchorders a,purchorderdetails b WHERE a.id=b.parantId AND a.vendorId='".$row['vendorid']."' AND b.mst_itemid='".$rows['mst_itemid']."' AND MONTH(po_date)='".$date_year[0]."' AND YEAR(po_date)='".$date_year[1]."'"; 
              	  	  $rate_sql1=DB_query($rate_sql,$db);
					  $p=1;
					$num1=DB_num_rows($rate_sql1);
					  
              	  	  while($rate_res=DB_fetch_assoc($rate_sql1))
              	  		{
              	  		 	$rate_res1[$rate_res['day1']]=$rate_res;
              	  		} // echo "<pre>"; print_r($rate_res1); ?>

				
						<?php for($i=1;$i<32;$i++){
						  if($i==31) {  $style="border-right:none;";   } else { $style="border-right:1px solid #808080;width:30px;"; } 
						 
						 ?>
                            <td width="10" style="<?php echo $style; ?>" class="f11">  
                              	<?php 
                              	if(array_key_exists($i,$rate_res1))
                              	{
                              		echo $rate_res1[$i]['Rate'];
                              	}
                              	else
                              	{
                              		echo " ";
                              	}
                              	?></td>
                      
                             <?php } ?>              	
       	  </tr>
	    	<?php $j++;} ?>  
	    </table></td>
</tr>
<?php $k++;} ?>   
</table>
</div>
</div>

</body>
</html>