elseif($_REQUEST['report']==113) 
{echo $str;
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td bgcolor="#333333"><span class="style3">S/L</span></td>
    <td bgcolor="#333333"><span class="style3">DEALER NAME </span></td>
<?
for($i=12;$i>0;$i--)
{
?>
<td bgcolor="#333333"><div align="center"><span class="style3"><?=date('M\'y',strtotime(${'f_mons'.$i}))?></span></div></td>
<?
}
?>
    <td bgcolor="#333333"><div align="center"><strong><span class="style5">Total</span></strong></div></td>
    </tr>
 <?
 


$sql = "select dealer_code,dealer_name_e as dealer_name from dealer_info d, area a where d.area_code=a.AREA_CODE and a.ZONE_ID=".$_REQUEST['zone_id']."  order by dealer_name_e";
if(isset($product_group)) 		{$con=' and d.product_group="'.$product_group.'"';}
$query = @db_query($sql);
while($item=@mysqli_fetch_object($query)){

$dealer_code = $item->dealer_code;
for($i=12;$i>0;$i--)
{
$m = ($i-1);

$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".${'f_mons'.$i}."' and '".${'f_mone'.$i}."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.dealer_code='".$dealer_code."'".$con;



${'sqlmon'.$i} = mysqli_fetch_row(db_query($sqql));

${'totalc'.$i} = ${'totalc'.$i} + ${'sqlmon'.$i}[0];
${'totalr'.$dealer_code} = ${'totalr'.$dealer_code} + ${'sqlmon'.$i}[0];
}



 ?>
  <tr bgcolor="#<? echo (($i%2)==0)?'fff':'EBEBEB';?>">
    <td><?=++$j?></td>
    <td><?=$item->dealer_name?></td>
<?
for($i=12;$i>0;$i--)
{
?>
<td bgcolor="#99CCFF"><div align="right"><?=number_format(${'sqlmon'.$i}[0],2);?></div></td>
<?
}
?>
    <td bgcolor="#FFFF99"><div align="right"><strong>
        <? $totalallr= $totalallr + ${'totalr'.$dealer_code};echo number_format(${'totalr'.$dealer_code},2)?>
    </strong></div></td>
    </tr>
  <? }

for($i=12;$i>0;$i--)
{
$m = ($i-1);


$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".${'f_mons'.$i}."' and '".${'f_mone'.$i}."' and c.dealer_code=d.dealer_code and d.dealer_type='Corporate'".$con;

${'sqlmonc'.$i} = mysqli_fetch_row(db_query($sqql));
${'totalco'.$i} = ${'totalco'.$i} + ${'sqlmonc'.$i}[0];
${'totalrc1'} = ${'totalrc1'} + ${'sqlmonc'.$i}[0];
}

  ?>
    <tr bgcolor="#<? echo (($i%2)==0)?'fff':'EBEBEB';?>">
      <td>&nbsp;</td>
      <td><strong>D Total</strong></td>
<?
for($i=12;$i>0;$i--)
{
${'totald'} = ${'totald'} + ${'totalc'.$i};
?>
<td bgcolor="#FFFF66"><div align="right"><?=number_format(${'totalc'.$i},2);?></div></td>
<?
}
?>

      <td bgcolor="#FFFF99"><div align="right">
        <?=number_format($totalallr,2);?>
      </div></td>
    </tr>
	<?
	  for($i=12;$i>0;$i--)
{
$m = ($i-1);


$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".${'f_mons'.$i}."' and '".${'f_mone'.$i}."' and c.dealer_code=d.dealer_code and d.dealer_type='SuperShop'".$con;
${'sqlmons'.$i} = mysqli_fetch_row(db_query($sqql));
${'totals'.$i} = ${'totals'.$i} + ${'sqlmons'.$i}[0];
${'totalrc'} = ${'totalrc'} + ${'sqlmons'.$i}[0];
}
	?>
</table>
<?
}
elseif($_REQUEST['report']==114) 
{echo $str;
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td bgcolor="#333333"><span class="style3">S/L</span></td>
    <td bgcolor="#333333"><span class="style3">DEALER NAME </span></td>
<?
for($i=12;$i>0;$i--)
{
?>
<td bgcolor="#333333"><div align="center"><span class="style3"><?=date('M\'y',strtotime(${'f_mons'.$i}))?></span></div></td>
<?
}
?>
   
    <td bgcolor="#333333"><div align="center"><strong><span class="style5">Total</span></strong></div></td>
  </tr>
 <?
 


$sql = "select dealer_code,dealer_name_e as dealer_name from dealer_info d, area a where d.area_code=a.AREA_CODE and a.ZONE_ID=".$_REQUEST['zone_id']."  order by dealer_name_e";
if(isset($product_group)) 		{$con=' and d.product_group="'.$product_group.'"';}
if(isset($item_id)) 		{$con=' and c.item_id="'.$item_id.'"';}
$query = @db_query($sql);
while($item=@mysqli_fetch_object($query)){

$dealer_code = $item->dealer_code;
for($i=12;$i>0;$i--)
{
$m = ($i-1);
$sqql = "select sum(c.pkt_unit) from sale_do_chalan c,dealer_info d where c.chalan_date between '".${'f_mons'.$i}."' and '".${'f_mone'.$i}."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.dealer_code='".$dealer_code."'".$con;
${'sqlmon'.$i} = mysqli_fetch_row(db_query($sqql));

${'totalc'.$i} = ${'totalc'.$i} + ${'sqlmon'.$i}[0];
${'totalr'.$dealer_code} = ${'totalr'.$dealer_code} + ${'sqlmon'.$i}[0];
}



 ?>
  <tr bgcolor="#<? echo (($i%2)==0)?'fff':'EBEBEB';?>">
    <td><?=++$j?></td>
    <td><?=$item->dealer_name?></td>
	
<?
for($i=12;$i>0;$i--)
{
?>
<td bgcolor="#99CCFF"><div align="right"><?=number_format(${'sqlmon'.$i}[0],0);?></div></td>
<?
}
?>
	
    <td bgcolor="#FFFF99"><div align="right"><strong>
      <?=number_format(${'totalr'.$dealer_code},0)?>
    </strong></div></td>
  </tr>
  <? }
  
  for($i=12;$i>0;$i--)
{
$m = ($i-1);
$sqql = "select sum(c.pkt_unit) from sale_do_chalan c,dealer_info d where c.chalan_date between '".${'f_mons'.$i}."' and '".${'f_mone'.$i}."' and c.dealer_code=d.dealer_code and d.dealer_type='Corporate'".$con;
${'sqlmonc'.$i} = mysqli_fetch_row(db_query($sqql));
${'totalco'.$i} = ${'totalco'.$i} + ${'sqlmonc'.$i}[0];
${'totalrc1'} = ${'totalrc1'} + ${'sqlmonc'.$i}[0];
}

  ?>
    <tr bgcolor="#<? echo (($i%2)==0)?'fff':'EBEBEB';?>">
      <td>&nbsp;</td>
      <td><strong>D Total</strong></td>
	  
<?
for($i=12;$i>0;$i--)
{
${'totald'} = ${'totald'} + ${'totalc'.$i};
?>
<td bgcolor="#FFFF66"><div align="right"><?=number_format(${'totalc'.$i},0);?></div></td>
<?
}
?>

	  
      <td bgcolor="#FFFF99"><div align="right"><?=number_format(${'totald'},0);?></div></td>
    </tr>
	<?
	  for($i=12;$i>0;$i--)
{
$m = ($i-1);
$sqql = "select sum(c.pkt_unit) from sale_do_chalan c,dealer_info d where c.chalan_date between '".${'f_mons'.$i}."' and '".${'f_mone'.$i}."' and c.dealer_code=d.dealer_code and d.dealer_type='SuperShop'".$con;;
${'sqlmons'.$i} = mysqli_fetch_row(db_query($sqql));
${'totals'.$i} = ${'totals'.$i} + ${'sqlmons'.$i}[0];
${'totalrc'} = ${'totalrc'} + ${'sqlmons'.$i}[0];
}
	?>
</table>
<?
}
elseif($_REQUEST['report']==115) 
{echo $str;
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td bgcolor="#333333"><span class="style3">S/L</span></td>
    <td bgcolor="#333333"><span class="style3">DEALER NAME </span></td>
    <?
for($i=12;$i>0;$i--)
{
?>
    <td bgcolor="#333333"><div align="center"><span class="style3">
      <?=date('M\'y',strtotime(${'f_mons'.$i}))?>
    </span></div></td>
    <?
}
?>
    <td bgcolor="#333333"><div align="center"><strong><span class="style5">Total</span></strong></div></td>
  </tr>
  <?
 


$sql = "select dealer_code,dealer_name_e as dealer_name from dealer_info d, area a where d.area_code=a.AREA_CODE and a.ZONE_ID=".$_REQUEST['zone_id']."  order by dealer_name_e";
if(isset($product_group)) 		{$con=' and d.product_group="'.$product_group.'"';}
if(isset($item_id)) 		{$con=' and c.item_id="'.$item_id.'"';}
$query = @db_query($sql);
while($item=@mysqli_fetch_object($query)){

$dealer_code = $item->dealer_code;
for($i=12;$i>0;$i--)
{
$m = ($i-1);

$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".${'f_mons'.$i}."' and '".${'f_mone'.$i}."' and c.dealer_code=d.dealer_code and d.dealer_type='Distributor' and d.dealer_code='".$dealer_code."'".$con;



${'sqlmon'.$i} = mysqli_fetch_row(db_query($sqql));

${'totalc'.$i} = ${'totalc'.$i} + ${'sqlmon'.$i}[0];
${'totalr'.$dealer_code} = ${'totalr'.$dealer_code} + ${'sqlmon'.$i}[0];
}



 ?>
  <tr bgcolor="#<? echo (($i%2)==0)?'fff':'EBEBEB';?>">
    <td><?=++$j?></td>
    <td><?=$item->dealer_name?></td>
    <?
for($i=12;$i>0;$i--)
{
?>
    <td bgcolor="#99CCFF"><div align="right">
      <?=number_format(${'sqlmon'.$i}[0],2);?>
    </div></td>
    <?
}
?>
    <td bgcolor="#FFFF99"><div align="right"><strong>
      <? 
$totalallr= $totalallr + ${'totalr'.$dealer_code};
echo number_format(${'totalr'.$dealer_code},2);
	  ?>
    </strong></div></td>
  </tr>
  <? }

for($i=12;$i>0;$i--)
{
$m = ($i-1);


$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".${'f_mons'.$i}."' and '".${'f_mone'.$i}."' and c.dealer_code=d.dealer_code and d.dealer_type='Corporate'".$con;

${'sqlmonc'.$i} = mysqli_fetch_row(db_query($sqql));
${'totalco'.$i} = ${'totalco'.$i} + ${'sqlmonc'.$i}[0];
${'totalrc1'} = ${'totalrc1'} + ${'sqlmonc'.$i}[0];
}

  ?>
  <tr bgcolor="#<? echo (($i%2)==0)?'fff':'EBEBEB';?>">
    <td>&nbsp;</td>
    <td><strong>D Total</strong></td>
    <?
for($i=12;$i>0;$i--)
{
${'totald'} = ${'totald'} + ${'totalc'.$i};
?>
    <td bgcolor="#FFFF66"><div align="right">
      <?=number_format(${'totalc'.$i},2);?>
    </div></td>
    <?
}
?>
    <td bgcolor="#FFFF99"><div align="right">
      <?=number_format($totalallr,2);?>
    </div></td>
  </tr>
  <?
	  for($i=12;$i>0;$i--)
{
$m = ($i-1);


$sqql = "select sum(c.total_amt) from sale_do_chalan c,dealer_info d where c.chalan_date between '".${'f_mons'.$i}."' and '".${'f_mone'.$i}."' and c.dealer_code=d.dealer_code and d.dealer_type='SuperShop'".$con;
${'sqlmons'.$i} = mysqli_fetch_row(db_query($sqql));
${'totals'.$i} = ${'totals'.$i} + ${'sqlmons'.$i}[0];
${'totalrc'} = ${'totalrc'} + ${'sqlmons'.$i}[0];
}
	?>
</table>
<?
}