<?
include_once('includes/top.php');
include_once('opendb.php');
$brcode=$_SESSION['brcode'];
$fromdt=$_REQUEST['fromdt'];
$todt=$_REQUEST['todt'];
$user=$_SESSION['user'];
//$br=$_SESSION['branch'];
if(strlen($user)<=0)
{
  print "<script> alert('Invalid User'); document.location='inde.php' </script>";
  return;
}

?>
<link href="css/form.css" type="text/css" rel="stylesheet" media="screen"  />
<html>
<body >

<title>Purchase Register</title>
<link rel="stylesheet" href="style.css" type="text/css" />
<script type="text/javascript" src="scripts/jquery-latest.js"></script>
<link type="text/css" href="includes/style1.css" rel="stylesheet" />
<link type="text/css" href="css/form.css" rel="stylesheet" />
<link rel="stylesheet" href="cal/jquery-ui.css" />
<script src="cal/jquery-1.9.1.js"></script>
<script src="cal/jquery-ui1.js"></script>
<link rel="stylesheet" href="/resources/demos/style.css" />

<script type="text/javascript">
$(function() {
$( "#ref_date" ).datepicker("destroy");
     var fyr=document.getElementById('f_yr').value;
     var splv=fyr.explode("-");
     var syr=splv[0];
     var eyr='20'.concat(splv[1]);
     var syr1='01-04-';
     var eyr1='31-03-';
     var stfnyr=syr1.concat(syr);
     var efnyr=eyr1.concat(eyr);
     $("#ref_date").datepicker({ dateFormat: 'dd-mm-yy', minDate: stfnyr, maxDate: efnyr});

$( "#ref_date1" ).datepicker("destroy");
     var fyr=document.getElementById('f_yr').value;
     var splv=fyr.explode("-");
     var syr=splv[0];
     var eyr='20'.concat(splv[1]);
     var syr1='01-04-';
     var eyr1='31-03-';
     var stfnyr=syr1.concat(syr);
     var efnyr=eyr1.concat(eyr);
     $("#ref_date1").datepicker({ dateFormat: 'dd-mm-yy', minDate: stfnyr, maxDate: efnyr});
});

</script>
<script>
function valid()
{
}
</script>
<style>
#txt{
font-family: Arial, Helvetica;
background-color: #F2F2F2;
}
</style>
<link rel="stylesheet" type="text/css" media="all" href="jsDatePick_ltr.min.css" />
<script type="text/javascript" src="jsDatePick.min.1.3.js"></script>
<script type="text/javascript">
window.onload = function(){
new JsDatePick({
  useMode:2,
  target:"inputField",
  dateFormat:"%Y-%m-%d"
});
new JsDatePick({
  useMode:2,
  target:"inputField1",
  dateFormat:"%Y-%m-%d"
});

};
</script>

<SCRIPT LANGUAGE="JavaScript" SRC="util/PopupWindow.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="util/AnchorPosition.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="util/CalendarPopup.js"></SCRIPT>
<SCRIPT LANGUAGE="JavaScript" SRC="util/date.js"></SCRIPT>
<script>

var cal1 = new CalendarPopup();
cal1.showYearNavigation();

var cal2 = new CalendarPopup();
cal2.showYearNavigation();

</script>
<style>
th{
    // background-color: grey;
    font-weight: bold;
    color: white;
    border:1px solid #D7D7D1;
    border-collapse:collapse;
background: rgb(181,189,200); /* Old browsers */
background: -moz-linear-gradient(top, rgba(181,189,200,1) 0%, rgba(130,140,149,1) 36%, rgba(40,52,59,1) 100%); /* FF3.6+ */
background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,rgba(181,189,200,1)), color-stop(36%,rgba(130,140,149,1)), color-stop(100%,rgba(40,52,59,1))); /* Chrome,Safari4+ */
background: -webkit-linear-gradient(top, rgba(181,189,200,1) 0%,rgba(130,140,149,1) 36%,rgba(40,52,59,1) 100%); /* Chrome10+,Safari5.1+ */
background: -o-linear-gradient(top, rgba(181,189,200,1) 0%,rgba(130,140,149,1) 36%,rgba(40,52,59,1) 100%); /* Opera 11.10+ */
background: -ms-linear-gradient(top, rgba(181,189,200,1) 0%,rgba(130,140,149,1) 36%,rgba(40,52,59,1) 100%); /* IE10+ */
background: linear-gradient(to bottom, rgba(181,189,200,1) 0%,rgba(130,140,149,1) 36%,rgba(40,52,59,1) 100%); /* W3C */
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#b5bdc8', endColorstr='#28343b',GradientType=0 ); /* IE6-9 */
}
.ro_settled td
{
background: #6bba70; /* Old browsers */
background: -moz-linear-gradient(top, #6bba70 0%, #6bba70 100%); /* FF3.6+ */
background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,#6bba70), color-stop(100%,#6bba70)); /* Chrome,Safari4+ */
background: -webkit-linear-gradient(top, #6bba70 0%,#6bba70 100%); /* Chrome10+,Safari5.1+ */
background: -o-linear-gradient(top, #6bba70 0%,#6bba70 100%); /* Opera 11.10+ */
background: -ms-linear-gradient(top, #6bba70 0%,#6bba70 100%); /* IE10+ */
background: linear-gradient(to bottom, #6bba70 0%,#6bba70 100%); /* W3C */
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#6bba70', endColorstr='#6bba70',GradientType=0 ); /* IE6-9 */
color:white;
}
.ro_settl td
{
background: #6bba70; /* Old browsers */
background: -moz-linear-gradient(top, #6bba70 0%, #6bba70 100%); /* FF3.6+ */
background: -webkit-gradient(linear, left top, left bottom, color-stop(0%,#6bba70), color-stop(100%,#6bba70)); /* Chrome,Safari4+ */
background: -webkit-linear-gradient(top, #6bba70 0%,#6bba70 100%); /* Chrome10+,Safari5.1+ */
background: -o-linear-gradient(top, #6bba70 0%,#6bba70 100%); /* Opera 11.10+ */
background: -ms-linear-gradient(top, #6bba70 0%,#6bba70 100%); /* IE10+ */
background: linear-gradient(to bottom, #6bba70 0%,#6bba70 100%); /* W3C */
filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#6bba70', endColorstr='#6bba70',GradientType=0 ); /* IE6-9 */
color:red;
}
</style>
<body background="back_ground.jpg">
<?php //include('logo2.php'); ?>
<?php //include('includes/top.php'); ?>
<form action='<?print $PHP_SELF?>' name="f1" method='post' >
<br>
<table class="container"><tr><td>
<br>
<center>
<?
$brqry="select brname from branch where brcode='$brcode'";
$brrs=mysqli_query($db,$brqry);
$brrw=mysqli_fetch_array($brrs);
$brnchnm=$brrw[0];
?>

<table class="form" style="width:auto;" align='center' >
<tr><th>PURCHASE REGISTER BILLWISE</th></tr>
<tr><td><input type=hidden name='f_yr' id='f_yr' value='<? echo $fin_year ?>'>
<?if($fromdt>0){?>
      Show Report From <input type="text" id="ref_date" value="<?echo $fromdt;?>" name="fromdt" readonly  >
<?} else {?>
      Show Report From <input type="text" id="ref_date" value="<?echo date('d-m-Y');?>" name="fromdt" readonly  >
<? } ?>
<?if($todt>0){?>
      To <input type="text" id="ref_date1" name="todt" value="<?echo $todt;?>" readonly > </td></tr>
<?} else {?>
      To <input type="text" id="ref_date1" name="todt" value="<?echo date('d-m-Y');?>" readonly > </td></tr>
<? } ?>
<tr><td align='center'>Report by:<select name='type' ><option>All</option>
<?
$tax_qry=mysqli_query($db,"select gname from groupmaster");
while($row=mysqli_fetch_array($tax_qry))
{
  print "<option>$row[0]</option>";
}?>
</select>
<input type='submit' name='show' value='Show'><input type=button value="Print Report" onclick=conslfn()><input type='button' onclick=excelfun() value='Print To Excel' ></td>
</tr></form>
</table>
<br><br>
<?
if(isset($_POST['show']))
{
  $fromdt=$_REQUEST['fromdt'];
  $todt=$_REQUEST['todt'];
  $fromdt = implode('-', array_reverse(explode('-', $fromdt)));
  $todt = implode('-', array_reverse(explode('-', $todt)));
  $type=$_REQUEST['type'];
  if ($type == 'All')
       $qry=mysqli_query($db,"select gname,invdate,sum(total),mba,comision,discount,mrgin,invno,pmode,pfchrgs,othr_chrgs,refno,refdt from brtransferin where invdate between '$fromdt' and '$todt' and brcode='$brcode' group by invno,gname");
  else
       $qry=mysqli_query($db,"select gname,invdate,sum(total),mba,comision,discount,mrgin,invno,pmode,pfchrgs,othr_chrgs,refno,refdt from brtransferin where invdate between '$fromdt' and '$todt' and brcode='$brcode' and gname = '$type' group by invno,gname");
  print "<table class='report' border='1'>";
  $fromdt=implode('-', array_reverse(explode('-', $fromdt)));
  $todt=implode('-', array_reverse(explode('-', $todt)));
  $mfrom_date = $fromdt;
  $mto_date = $todt;
  print "<tr><th COLSPAN=17>KERALA KHADI & VILLAGE INDUSTRIES BOARD</th></tr>";
  print "<tr><th COLSPAN=17>CENTER NAME : $brnchnm </th></tr>";
  print "<tr><th COLSPAN=17>Purchase Register for the period from <$mfrom_date> to <$mto_date></th>";
  print "<tr><th>GRS#</th><th>Invoice No</th><th>Inv. Date</th><th>Cotton</th><th>Poly</th><th>Reeled<br>Silk</th><th>Spun<br>Silk</th><th>VIP</th><th>Woollen</th><th>Others</th><th>MDA</th><th>Commission</th><th>Discount</th><th>Margin</th><th>PF Charges</th><th>Other<br>Charges</th><th>Total Amount</th></tr>";
    $colspan=6;
  $mstr[]='';
  $i=1;
  $mgname = '.';
  $mtot_cot = 0;
  $mtot_pol = 0;
  $mtot_rel = 0;
  $mtot_spu = 0;
  $mtot_vip = 0;
  $mtot_woo = 0;
  $mtot_oth = 0;
  $mtot_total = 0;
  $mtot_mba= 0;
  $mtot_comision = 0;
  $mtot_discount = 0;
  $mtot_pfchrgs = 0;
  $mtot_othr_chrgs = 0;
  $mtot_taxamt = 0;
  $mtot_nettot = 0;
  $mtot_dbtrs = 0;
  $mgr_total = 0;
  $mgr_cot = 0;
  $mgr_pol = 0;
  $mgr_rel = 0;
  $mgr_spu = 0;
  $mgr_vip = 0;
  $mgr_woo = 0;
  $mgr_oth = 0;
  $mgr_mba= 0;
  $mgr_comision = 0;
  $mgr_discount = 0;
  $mgr_pfchrgs = 0;
  $mgr_othr_chrgs = 0;
  $mgr_taxamt = 0;
  $mgr_nettot = 0;
  $mgr_dbtrs = 0;

  $ctr=0;
  $mgr_dbtrs=0; $mgr_dbtrs1=0;
  $minvno = '';
  while($row=mysqli_fetch_array($qry))
    {
    if($minvno <>  $row[7] && $ctr <> 0)
    {
        $mtot_nettot = $mtot_cot+$mtot_pol+$mtot_rel+$mtot_spu+$mtot_vip+$mtot_woo+$mtot_oth-$mtot_mba-$mtot_comision-$mtot_discount+$mtot_mrgin+$mtot_pfchrgs+$mtot_othr_chrgs;
        print "<tr><td>$minvno</td><td><b>$mrefno</td><td><b>$mrefdt</td><td align='right'>".number_format($mtot_cot,2,'.','')."</td><td align='right'>".number_format($mtot_pol,2,'.','')."</td><td align='right'>".number_format($mtot_rel,2,'.','')."</td><td align='right'>".number_format($mtot_spu,2,'.','')."</td><td align='right'>".number_format($mtot_vip,2,'.','')."</td><td align='right'>".number_format($mtot_woo,2,'.','')."</td><td align='right'>".number_format($mtot_oth,2,'.','')."</td><td align='right'>".number_format($mtot_mba,2,'.','')."</td><td align='right'>".number_format($mtot_comision,2,'.','')."</td><td align='right'>".number_format($mtot_discount,2,'.','')."</td><td align='right'>".number_format($mtot_mrgin,2,'.','')."</td><td align='right'>".number_format($mtot_pfchrgs,2,'.','')."</td><td align='right'>".number_format($mtot_othr_chrgs,2,'.','')."</td><td align='right'>".number_format($mtot_nettot,2,'.','')."</td></tr>";
        $mgr_cot +=  $mtot_cot;
        $mgr_pol +=  $mtot_pol;
        $mgr_rel +=  $mtot_rel;
        $mgr_spu +=  $mtot_spu;
        $mgr_vip +=  $mtot_vip;
        $mgr_woo +=  $mtot_woo;
        $mgr_oth +=  $mtot_oth;
        $mgr_mba+=  $mtot_mba;
        $mgr_comision +=  $mtot_comision;
        $mgr_discount +=  $mtot_discount;
        $mgr_pfchrgs +=  $mtot_pfchrgs;
        $mgr_othr_chrgs +=  $mtot_othr_chrgs;
        $mgr_mrgin +=  $mtot_mrgin;
        $mgr_nettot +=  $mtot_nettot;
        $mgr_dbtrs +=  $mtot_dbtrs;

        $mtot_cot = 0;
        $mtot_pol = 0;
        $mtot_rel = 0;
        $mtot_spu = 0;
        $mtot_vip = 0;
        $mtot_woo = 0;
        $mtot_oth = 0;
        $mtot_mba= 0;
        $mtot_comision = 0;
        $mtot_discount = 0;
        $mtot_pfchrgs = 0;
        $mtot_othr_chrgs = 0;
        $mtot_mrgin = 0;
        $mtot_nettot = 0;
        $mtot_dbtrs = 0;

    }
    $minvno = $row[7];
    ++$ctr;
    $mrefno = $row[11];
    $mrefdt = $row[1];
                $mrefdt=implode('-', array_reverse(explode('-', $mrefdt)));
    $date = $row[1];
    if($row[0]== 'COTTON')
      $mtot_cot += $row[2];
    else if ($row[0]== 'POLYSTER')
      $mtot_pol += $row[2];
    else if ($row[0]== 'REELED SILK')
      $mtot_rel += $row[2];
    else if ($row[0]== 'SPUNSILK')
      $mtot_spu += $row[2];
    else if ($row[0]== '0% TAXABLE VIP' || $row[0]== '5% TAXABLE VIP' || $row[0]== '14.5% TAXABLE VIP' || $row[0]== '1% TAXABLE VIP')
      $mtot_vip += $row[2];
    else if ($row[0]== 'WOOLEN')
      $mtot_woo += $row[2];
    else
      $mtot_oth += $row[2];

  //select gname,invdate,sum(total),sum(mba),sum(comision),sum(discount),sum(mrgin),invno,pmode,sum(pfchrgs),sum(othr_chrgs),refno,refdt from brtransferin
   //          0    1         2         3           4            5            6        7     8       9             10           11    12
    $mtot_mba+= $row[3];
    $mtot_comision =$row[4];
    $mtot_discount =$row[5];
    $mtot_mrgin+=$row[2]*($row[6]/100);
    $mtot_pfchrgs =$row[9];
    $mtot_othr_chrgs =$row[10];
    $i++;
  }
  $mgr_cot +=  $mtot_cot;
  $mgr_pol +=  $mtot_pol;
  $mgr_rel +=  $mtot_rel;
  $mgr_spu +=  $mtot_spu;
  $mgr_vip +=  $mtot_vip;
  $mgr_woo +=  $mtot_woo;
  $mgr_oth +=  $mtot_oth;
  $mgr_mba+=  $mtot_mba;
  $mgr_comision +=$mtot_comision;
  $mgr_discount +=$mtot_discount;
  $mgr_mrgin +=$mtot_mrgin;
  $mgr_pfchrgs +=$mtot_pfchrgs;
  $mgr_othr_chrgs +=$mtot_othr_chrgs;
  $mtot_nettot = $mtot_cot+$mtot_pol+$mtot_rel+$mtot_spu+$mtot_vip+$mtot_woo+$mtot_oth-$mtot_mba-$mtot_comision-$mtot_discount+$mtot_mrgin+$mtot_pfchrgs+$mtot_othr_chrgs;
  print "<tr><td>$minvno</td><td><b>$mrefno</td><td><b>$mrefdt</td><td align='right'>".number_format($mtot_cot,2)."</td><td align='right'>".number_format($mtot_pol,2)."</td><td align='right'>".number_format($mtot_rel,2)."</td><td align='right'>".number_format($mtot_spu,2)."</td><td align='right'>".number_format($mtot_vip,2)."</td><td align='right'>".number_format($mtot_woo,2)."</td><td align='right'>".number_format($mtot_oth,2)."</td><td align='right'>".number_format($mtot_mba,2)."</td><td align='right'>".number_format($mtot_comision,2)."</td><td align='right'>".number_format($mtot_discount,2)."</td><td align='right'>".number_format($mtot_mrgin,2)."</td><td align='right'>".number_format($mtot_pfchrgs,2)."</td><td align='right'>".number_format($mtot_othr_chrgs,2)."</td><td align='right'>".number_format($mtot_nettot,2)."</td></tr>";
  $mgr_nettot +=  $mtot_nettot;
        print "<tr><td colspan=3><b>Grand Total</td><td align='right'>".number_format($mgr_cot,2)."</td><td align='right'>".number_format($mgr_pol,2)."</td><td align='right'>".number_format($mgr_rel,2)."</td><td align='right'>".number_format($mgr_spu,2)."</td><td align='right'>".number_format($mgr_vip,2)."</td><td align='right'>".number_format($mgr_woo,2)."</td><td align='right'>".number_format($mgr_oth,2)."</td><td align='right'>".number_format($mgr_mba,2)."</td><td align='right'>".number_format($mgr_comision,2)."</td><td align='right'>".number_format($mgr_discount,2)."</td><td align='right'>".number_format($mgr_mrgin,2)."</td><td align='right'>".number_format($mgr_pfchrgs,2)."</td><td align='right'>".number_format($mgr_othr_chrgs,2)."</td><td align='right'>".number_format($mgr_nettot,2)."</td></tr>";
  print "</table>";
}
?>
<script>
function conslfn()
{
   var dfrom=document.f1.fromdt.value;
   var dto=document.f1.todt.value;
   var type=document.f1.type.value;

         document.location="purchreg_newprt.php?fromdt="+dfrom+"&&todt="+dto+"&&type="+type,true;
}s
function excelfun()
{
   var dfrom=document.f1.fromdt.value;
   var dto=document.f1.todt.value;
    var type=document.f1.type.value;
  document.location="purchreg_new_excel.php?fromdt="+dfrom+"&&todt="+dto+"&&type="+type,true;
}
</script>