D:\host\scoreman.in\highrange2026\summary.php

<?php
include('dbconnect.php');
include('jfunctions.php');
include('functions.php');
$configs = include('conf.php');
//phpinfo();


$sumtype=$_GET["sumtype"];


   $bankacno="";

			     $bankifsc="";
			      $bankacname="";
			       $bankname="";
	$eventtitle="";
	$eventdate="";
	$contact="";

	$team=$_GET["team"];
if($team=="All Entries")
{
    $team=NULL;
}
if($team!="")
{
		$_SESSION['teamf']=$team;
}

//$_SESSION['currentdistrict']=$team;

$repdistrict=$_SESSION['teamf'];
if($repdistrict=="")
{
	$repdistrict=$_SESSION['currentdistrict'];
}

if($repdistrict=="")
{
	$repdistrict=$_SESSION['username'];
}
   // $club = $_SESSION["username"];

    if ($_SESSION["username"]=="") {

    	loginbox();

    	}


    	if($sumtype=="summary-speed")
    	{

echo buildSpeedEventSummary($con,$team);
}

    	if($sumtype=="summary-entry")
    	{

	$club=$_SESSION["username"];
    			$usertype=$_SESSION["usertype"];
$dt="";
$dt=$_SESSION["currentdistrict"];
if($usertype=="District")
{

	$dt=$_SESSION["currentdistrict"];

$club="%";
}

if($club =="secretary" )
{
  echo "Payout Summary <br/><table border=1>";
		$databaseQuery = 'SELECT  count(appno) as cnt,repdistrict,sum(fees) as sfees,sum(amt) as samt,sum(capamt) as samt,sum(ccavenuefee) as sccavenuefee,round(sum(paytax),2) as spaytax,sum(capamt)-sum(ccavenuefee)-round(sum(paytax),2) as total FROM applications where order_status="Success" group by repdistrict order by repdistrict';

		  echo "<tr><td>Dt</td><td>Entries</td><td>Fee</td><td>Captured</td><td>Service Charge</td><td>Tax</td><td>Total</td></tr>";

	$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
	while($row = mysqli_fetch_array($result))
  {
	 
	   echo "<tr><td>".$row["repdistrict"]."</td><td>".$row["cnt"]."</td><td>".$row["sfees"]."</td><td>".$row["samt"]."</td><td>".$row["sccavenuefee"]."</td><td>".$row["spaytax"]."</td><td>".$row["total"]."</td></tr>";
	 
  }
  echo "</table>";
}

if($club =="secretary" || $usertype=="District")
	{




		echo "Team Wise Entries <br/><table border=1>";
		$databaseQuery = 'SELECT repdistrict,club,count(appno) as c FROM applications T where status != "delete" and (order_status="Success" ) and (repdistrict like "%'.$con->real_escape_string($dt).'%")  group by repdistrict,club';
	$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
	 echo "<tr><th>Dt</th><th>Team</th><th>Total</th></tr>";
	while($row = mysqli_fetch_array($result))
  {
	   echo "<tr><td>".$row["repdistrict"]."</td><td>".$row["club"]."</td><td>".$row["c"]."</td></tr>";
  }
  echo "</table>";
  
  echo "Summary <br/><table border=1>";
		$databaseQuery = 'SELECT  status,order_status,count(appno) as c FROM applications where order_status="Success"  and (repdistrict like "%'.$con->real_escape_string($dt).'%") group by status order by c desc';
	$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
	while($row = mysqli_fetch_array($result))
  {
	  if($row["status"]!="")
	  {
	   echo "<tr><td>".$row["status"]."</td><td>".$row["c"]."</td></tr>";
	  }
	  else
	  {
		  	   echo "<tr><td>Unverified</td><td>".$row["c"]."</td></tr>";
		  }
  }
  echo "</table>";
echo "Participation Summary <br/><table border=1>";
		$databaseQuery = 'SELECT  skatertype,count(appno) as c FROM applications where order_status="Success" and (repdistrict="'.$cdt.'")  group by skatertype order by c desc';
	$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
	while($row = mysqli_fetch_array($result))
  {
	  if($row["skatertype"]!="")
	  {
	   echo "<tr><td>".$row["skatertype"]."</td><td>".$row["c"]."</td></tr>";
	  }
	  else
	  {
		  	   echo "<tr><td>Unverified</td><td>".$row["c"]."</td></tr>";
		  }
  }
  echo "</table>";
	
	
	
	
	$club=$_GET['team'];
	$skey=$_GET['team'];
	$stype=$_GET['stype'];
	if($stype=="" || $stype=="all")
	{
		$stype="%";
		}


		$usertype=$_SESSION["usertype"];
$dt="";

if($usertype=="District")
{

	$dt=$_SESSION["currentdistrict"];

$club="%";
}


	
	$databaseQuery = 'SELECT * FROM applications WHERE (skatertype like "%'.$stype.'%") and (club like "%'.$con->real_escape_string($club).'%") and (repdistrict like "%'.$con->real_escape_string($dt).'%")   and order_status="Success"   order by agorder+0,LTRIM(RTRIM(gender)) desc,LTRIM(RTRIM(skatertype)),club,CONVERT(LTRIM(RTRIM(appno)),UNSIGNED INTEGER)';
	//echo  $databaseQuery;
	$result2 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
	$skey=$club;
	
	 echo "Summary for ".$club."<br/><table border=1>";
		$databaseQuery = 'SELECT  status,count(appno) as c FROM applications  WHERE (club like "%'.$con->real_escape_string($club).'%") and (repdistrict like "%'.$con->real_escape_string($dt).'%") and (order_status="Success" )   group by status order by c desc';

		//	echo $databaseQuery;
	$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
	while($row = mysqli_fetch_array($result))
  {
	  if($row["status"]!="")
	  {
	   echo "<tr><td>".$row["status"]."</td><td>".$row["c"]."</td></tr>";
	  }
	  else
	  {
		  	   echo "<tr><td>Unverified</td><td>".$row["c"]."</td></tr>";
		  }
  }
  echo "</table>";
		
	}
	else
	{
	//	$club=$_GET['team'];
	//$skey=$_GET['team'];
	$stype="all";
	if($stype=="" || $stype=="all")
	{
		$stype="%";
		}


				$usertype=$_SESSION["usertype"];
$dt="";

if($usertype=="District")
{

	$dt=$_SESSION["currentdistrict"];

$club="%";
}

	
	
	$skey=$club;
	if($club!="")
	{
	 echo "Summary for ".$club."<br/><table border=1>";
		$databaseQuery = 'SELECT  status,count(appno) as c FROM applications  WHERE (club like "%'.$con->real_escape_string($club).'%") and (repdistrict like "%'.$con->real_escape_string($dt).'%")  AND (order_status="Success"  )  group by status order by c desc';

		//	echo $databaseQuery;
	$result = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
	while($row = mysqli_fetch_array($result))
  {
	  if($row["status"]!="")
	  {
	   echo "<tr><td>".$row["status"]."</td><td>".$row["c"]."</td></tr>";
	  }
	  else
	  {
		  	   echo "<tr><td>Unverified</td><td>".$row["c"]."</td></tr>";
		  }
  }
  echo "</table>";

  }

	} 
    	}



?>