<?
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;
}
//require_once('tcpdf/config/lang/eng.php');
//require_once('tcpdf/tcpdf.php');
require_once('tcpdf/examples/tcpdf_include.php');
$brqry="select brname from branch where brcode='$brcode'";
$brrs=mysqli_query($db,$brqry);
$brrw=mysqli_fetch_array($brrs);
$brnchnm=$brrw[0];

$fromdt=$_REQUEST['dfrom'];
$todt=$_REQUEST['dto'];
$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf->SetPrintHeader(false);


$contents.="\t\t\t\t\t\t\tKERALA KHADI & VILLAGE INDUSTRIES BOARD\n";

$contents.="\t\t\t\t\t\t\t\tCENTER NAME :".$brnchnm."\n";

$contents.="\t\t\t\t\t\t\t\tSALES SUMMARY REPORT BILLWISE\n";

$contents.="\t\t\t\t\t\t\tShow Report From  ".$fromdt." to ".$todt."\n";



	
	$tbl='sales_summ'.$brcode.$user;
	mysqli_query($db,"delete from $tbl");
	mysqli_query($db,"create table $tbl(gname varchar(50),total double(14,2),mba double(14,2),strbtnml double(14,2),strbtspl double(14,2),redct double(14,2),befrtx double(14,2),taxamt double(14,2),nettot double(14,2),dbttot double(14,2))");
	$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");
	
	$mfrom_date = $fromdt;
	$mto_date = $todt;
	$contents.="Bill No.\t Cotton \t Poly \t Reeled Silk \t Spun Silk \t VIP\t Woollen \tOthers\t MDA\tState Rebate Normal\tState Rebate Special\tReduction\tNet Cash\tTax\tTotal Amount\t Debtors\n\n";
	
	//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)
		{
				$contents.="'".$minvno."\t".number_format($mtot_cot,2)."\t".number_format($mtot_pol,2)."\t".number_format($mtot_rel,2)."\t".number_format($mtot_spu,2)."\t".number_format($mtot_vip,2)."\t".number_format($mtot_woo,2)."\t".number_format($mtot_oth,2)."\t".number_format($mtot_mba,2)."\t".number_format($mtot_strbtnml,2)."\t".number_format($mtot_strbtspl)."\t".number_format($mtot_redct,2)."\t".number_format($mtot_befrtx,2)."\t".number_format($mtot_taxamt,2)."\t".number_format($mtot_nettot,2)."\t".number_format($mtot_dbtrs, 2)."\n";
				
				$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];
		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 +=$row[6];
		$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;
	
	$contents.="'".$minvno."\t".number_format($mtot_cot,2)."\t".number_format($mtot_pol,2)."\t".number_format($mtot_rel,2)."\t".number_format($mtot_spu,2)."\t".number_format($mtot_vip,2)."\t".number_format($mtot_woo,2)."\t".number_format($mtot_oth,2)."\t".number_format($mtot_mba,2)."\t".number_format($mtot_strbtnml,2)."\t".number_format($mtot_strbtspl,2)."\t".number_format($mtot_redct,2)."\t".number_format($mtot_befrtx,2)."\t".number_format($mtot_taxamt,2)."\t".number_format($mtot_nettot,2)."\t".number_format($mtot_dbtrs, 2)."\n";
	
	//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>";
	$contents.="\nGrand Total\t".number_format($mgr_cot,2)."\t".number_format($mgr_pol,2)."\t".number_format($mgr_rel,2)."\t".number_format($mgr_spu,2)."\t".number_format($mgr_vip,2)."\t".number_format($mgr_woo,2)."\t".number_format($mgr_oth,2)."\t".number_format($mgr_mba,2)."\t".number_format($mgr_strbtnml,2)."\t".number_format($mgr_strbtspl,2)."\t".number_format($mgr_redct,2)."\t".number_format($mgr_befrtx,2)."\t".number_format($mgr_taxamt,2)."\t".number_format($mgr_nettot,2)."\t".number_format($mgr_dbtrs, 2)."\n";
	
	//print "</table>";
	
	?>
	
	


