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

?>

<title>Sale Summary Report</title>



<style>
body {
    font:14px "Courier New", Courier, monospace;
    background-color:#ffffff;
    letter-spacing: 2px;
}
</style>
<body onload="window.print()">

<?
$brqry="select brname from branch where brcode='$brcode'";
$brrs=mysqli_query($db,$brqry);
$brrw=mysqli_fetch_array($brrs);
$brnchnm=$brrw[0];


  $fromdt=$_REQUEST['fromdt'];
  $todt=$_REQUEST['todt'];
  $mfrom_date = $fromdt;
  $mto_date = $todt;
  $fromdt = implode('-', array_reverse(explode('-', $fromdt)));
  $todt = implode('-', array_reverse(explode('-', $todt)));
  $qry=mysqli_query($db,"select gname,invdate,sum(total),sum(mba),sum(strbtnml),sum(strbtspl),sum(redct),sum(befrtx),sum(taxamt),sum(nettot),invno,pmode from prod_invoice where invdate between '$fromdt' and '$todt' and brcode='$brcode' group by invno,gname");
  print "<table class='report' border='1'>";

  print "<tr><th COLSPAN=16>KERALA KHADI & VILLAGE INDUSTRIES BOARD</th></tr>";
  print "<tr><th COLSPAN=16>CENTER NAME : $brnchnm </th></tr>";
  print "<tr><th COLSPAN=16>Sales Summary for the period from <$mfrom_date> to <$mto_date></th>";
  print "<tr><th>BillNo</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>State Rebate<br> Normal</th><th>State Rebate <br>Special</th><th>Reduction</th><th>Net Cash</th><th>Tax</th><th>Total Amount</th><th>Debtors</th>";
    $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_strbtnml = 0;
  $mtot_strbtspl = 0;
  $mtot_redct = 0;
  $mtot_befrtx = 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_strbtnml = 0;
  $mgr_strbtspl = 0;
  $mgr_redct = 0;
  $mgr_befrtx = 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[10] && $ctr <> 0)
    {
        print "<tr><td><b>$minvno</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_strbtnml,2,'.','')."</td><td align='right'>".number_format($mtot_strbtspl,2,'.','')."</td><td align='right'>".number_format($mtot_redct,2,'.','')."</td><td align='right'>".number_format($mtot_befrtx,2,'.','')."</td><td align='right'>".number_format($mtot_taxamt,2,'.','')."</td><td align='right'>".number_format($mtot_nettot,2,'.','')."</td><td align='right'>".number_format($mtot_dbtrs, 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_strbtnml +=  $mtot_strbtnml;
        $mgr_strbtspl +=  $mtot_strbtspl;
        $mgr_redct +=  $mtot_redct;
        $mgr_befrtx +=  $mtot_befrtx;
        $mgr_taxamt +=  $mtot_taxamt;
        $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_strbtnml = 0;
        $mtot_strbtspl = 0;
        $mtot_redct = 0;
        $mtot_befrtx = 0;
        $mtot_taxamt = 0;
        $mtot_nettot = 0;
        $mtot_dbtrs = 0;
    }
    $minvno = $row[10];
    ++$ctr;
    $date = $row[1];
        // *** getting staff discount from (Especially for Bed)
        $mstaffdisc_amt = 0;
        $mdummy=0;
        $rbt_tbl=mysqli_query($db,"select item_code,qty,staffdisc,total from prod_invoice where brcode = '$brcode' and invno = '$row[10]' and gname = '$row[0]' and staffdisc > 0");
        while($rrow=mysqli_fetch_array($rbt_tbl))
        {
             $rbt_val=mysqli_query($db,"select rbtbl,rbtvl from partmaster where partcode = '$rrow[0]'");
             $row22=mysqli_fetch_row($rbt_val);
             if($row22[0]=='Yes')
                  $mstaffdisc_amt += ($row22[1]*$rrow[1])*$rrow[2]/100;
             else
             {
                  $mstaffdisc_amt += $rrow[3]*$rrow[2]/100;
                  $mdummy +=  $rrow[3]*$rrow[2]/100;
             }
        }
        $mval = $mstaffdisc_amt;
    if($row[11]=='CREDIT')
    {
      $dbtrs=$row[9];
      $cshvl=0;
      $mtot_dbtrs+=$row[9];
    }
    else
    {
      $dbtrs=0;
      $cshvl=$row[9];
      $mtot_nettot += $row[9];

    }
    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];
    $mtot_mba+= $row[3];
    $mtot_strbtnml +=$row[4];
    $mtot_strbtspl +=$row[5];
    $mtot_redct +=$mval;
    $mtot_befrtx +=$row[7];
    $mtot_taxamt +=$row[8];
    $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_strbtnml +=  $mtot_strbtnml;
  $mgr_strbtspl +=  $mtot_strbtspl;
  $mgr_redct +=  $mtot_redct;
  $mgr_befrtx +=  $mtot_befrtx;
  $mgr_taxamt +=  $mtot_taxamt;
  $mgr_nettot +=  $mtot_nettot;
  $mgr_dbtrs +=  $mtot_dbtrs;

  print "<tr><td><b>$minvno</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_strbtnml,2,'.','')."</td><td align='right'>".number_format($mtot_strbtspl,2,'.','')."</td><td align='right'>".number_format($mtot_redct,2,'.','')."</td><td align='right'>".number_format($mtot_befrtx,2,'.','')."</td><td align='right'>".number_format($mtot_taxamt,2,'.','')."</td><td align='right'>".number_format($mtot_nettot,2,'.','')."</td><td align='right'>".number_format($mtot_dbtrs, 2, '.', '')."</td></tr>";
  print "<tr><td><b>Grand Total</td><td align='right'>".$mgr_cot."</td><td align='right'>".$mgr_pol."</td><td align='right'>".$mgr_rel."</td><td align='right'>".$mgr_spu."</td><td align='right'>".$mgr_vip."</td><td align='right'>".$mgr_woo."</td><td align='right'>".$mgr_oth."</td><td align='right'>".$mgr_mba."</td><td align='right'>".$mgr_strbtnml."</td><td align='right'>".$mgr_strbtspl."</td><td align='right'>".$mgr_redct."</td><td align='right'>".$mgr_befrtx."</td><td align='right'>".$mgr_taxamt."</td><td align='right'>".$mgr_nettot."</td><td align='right'>".number_format($mgr_dbtrs, 2, '.', '')."</td></tr>";
  print "</table>";
  ?>
</body>