D:\host\scoreman.in\tldt2025\adjustable.php
<?php
include('dbconnect.php');
include('jfunctionsadj.php');
include('functions.php');
$configs = include('conf.php');
function auto_version($file)
{
// if(strpos($file, '/') !== 0 || !file_exists($_SERVER['DOCUMENT_ROOT'] . $file))
// return $file;
//$mtime = filemtime($file);
// return preg_replace('{\\.([^./]+)$}', ".$mtime.\$1", $file);
$appvers=3343433;
return $file."?version=".$appvers;
}
//header("Cache-Control: no-cache, no-store, must-revalidate"); // HTTP 1.1.
//header("Pragma: no-cache"); // HTTP 1.0.
//header("Expires: 0"); // Proxies.
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
<link rel="icon" href="/favicon.ico" type="image/x-icon">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="https://fonts.googleapis.com/css?family=Pacifico&display=swap" rel="stylesheet">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0, user-scalable=no" />
<link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/font-awesome/4.3.0/css/font-awesome.min.css" />
<link rel="stylesheet" href="//ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.css" />
<link rel="stylesheet" href="vendor/waves/waves.min.css" />
<link rel="stylesheet" href="css/nativedroid2.css" />
<link rel="stylesheet" href="css/cbstyle.css" />
<link rel="stylesheet" href="vendor/wow/animate.css" />
<link href="https://fonts.googleapis.com/css?family=Righteous" rel="stylesheet">
<!-- <link rel="stylesheet" type="text/css" href="../css/sparkle.css">
<style>
/* //*[@id="entryform"]/div[1]/div[3]/div/div/div[1]
#entryform > div:nth-child(1) > div:nth-child(3) > div > div > div
{
content:"";
display:none !important;
width:50% !important;
height:0px !important;
}*/
</style>-->
<style>
h1 span, h2 span, h3 span {
font-family: Righteous;
font-size: 1.9em;
font-weight: 400;
margin: 0 0.3em;
color: #ff0080;
}
</style>
<style type='text/css'>
table {
border-collapse: collapse;
}
body {
background-image:url("bg.jpg");
//background-repeat: repeat-x;
background-attachment: fixed;
background-size: cover;
background-color: #2a2a72;
/*background-image: linear-gradient(315deg, #2a2a72 0%, #009ffd 74%);*/
}
@media only screen and (min-width: 600px){
.ui-page {
width: 100% !important;
max-width:1600px !important;
margin: 0 auto !important;
position: relative !important;
// border-right: 1px #aaa !important;
// border-left: 1px #aaa !important;
// border-top: 1px #aaa !important;
// border-style: solid !important;
// border: 1px #666 !important;
// box-shadow:0 0 3px 1px #aaa;
// background-image:url("jimages/rsfi trans bg.jpg");
// background-size: 32%;
// background-position:center;
//background-repeat: no-repeat;
}
}
.content-desktop {display: block;}
.content-mobile {display: block !important;}
@media screen and (max-width: 768px) {
.content-desktop {display: none;}
.content-mobile {display: block;}
}
</style>
<script src="//ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script>
<script src="//code.jquery.com/ui/1.11.4/jquery-ui.min.js"></script>
<script src="//ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"></script>
<script src="vendor/waves/waves.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-cookie/1.4.1/jquery.cookie.min.js"></script>
<script src="vendor/wow/wow.min.js"></script>
<script src="js/nativedroid2.js"></script>
<script src="nd2settings.js"></script>
<script src="js/jquery.cropit.js"></script>
<script type="text/javascript" src="<?php echo auto_version('j.js'); ?>"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jspdf/0.9.0rc1/jspdf.min.js"></script>
<script type="text/javascript">
window.onload = function () {
var lastScrollTop = $.cookie('last-scroll-top');
// alert(lastScrollTop);
if (lastScrollTop) {
$(window).scrollTop(lastScrollTop);
// $(window).scroll(0,lastScrollTop);
// alert("final"+ $(window).scrollTop());
$.removeCookie('last-scroll-top');
}
}
$(function() {
$('.image-editor').cropit({
maxZoom: 2,
smallImage: 'stretch'
});
$('.image-editor').cropit('initialZoom', 'fit');
$('#image-editor2').cropit({
maxZoom: 2,
smallImage: 'stretch',
minZoom:'fit'
});
$('#image-editor2').cropit('initialZoom', 'fit');
$('#image-editor2').cropit('previewSize', { width:248, height: 350.75});
$('#image-editor3').cropit({
maxZoom: 2,
smallImage: 'stretch',
minZoom:'fit'
});
$('#image-editor3').cropit('initialZoom', 'fit');
$('#image-editor3').cropit('previewSize', { width:248, height: 350.75});
$("#slider-step").on('slidestop', function (event) {
console.log("slidestop event fired");
});
//$zoomSlider= $('.image-editor').find('input.cropit-image-zoom-input');
$('#photorotcw').click(function() {
$('.image-editor').cropit('rotateCW');
});
$('#photorotccw').click(function() {
$('.image-editor').cropit('rotateCCW');
});
$('#dobrotcw').click(function() {
$('#image-editor2').cropit('rotateCW');
});
$('#dobrotccw').click(function() {
$('#image-editor2').cropit('rotateCCW');
});
$('#otrotcw').click(function() {
$('#image-editor3').cropit('rotateCW');
});
$('#otrotccw').click(function() {
$('#image-editor3').cropit('rotateCCW');
});
$('#entryform').submit(function() {
// Move cropped image data to hidden input
// var w = window.open();
// var imageData = $('.image-editor').cropit('export');
var imageData = $('.image-editor').cropit('export', {
type: 'image/jpeg',
quality: .6,
});
if(typeof imageData !== "undefined")
{
$('.hidden-image-data').val(imageData);
}
$('#image-editor2').cropit('exportZoom', 2.5);
var dobData = $('#image-editor2').cropit('export', {
type: 'image/jpeg',
quality: .6,
});
//// dobData = $('#image-editor2').cropit('export');
// console.log("DobData");
//console.log(dobData);
if(typeof dobData !== "undefined")
{
$('.hidden-dob-data').val(dobData);
// console.log("Setting..");
}
$('#image-editor3').cropit('exportZoom', 2.5);
var otData = $('#image-editor3').cropit('export', {
type: 'image/jpeg',
quality: .6,
});
if(typeof otData !== "undefined")
{
$('.hidden-ot-data').val(otData);
}
// console.log("HDobData");
// console.log( $('.hidden-dob-data').val());
// alert(dobData);
if(checkform()==false)
{
return false;
}
// Print HTTP request params
// var formValue = $(this).serialize();
// $('#result-data').text(formValue);
var formData = new FormData($(this)[0]);
$.mobile.loading( "show", {
text: "Submitting...",
textVisible: true,
theme: "z",
html: ""
});
// }
$serdata=$('#entryform').serialize();
///console.log($serdata);
$.ajax({
url: 'register.php',
type: 'post',
// dataType: 'text',
data: formData,
async: false,
cache: false,
contentType: false,
enctype: 'multipart/form-data',
processData: false,
// data: $serdata,
success: function(data) {
console.log("data received:");
console.log(data);
// $(w.document.body).html(data);
try {
var myObj = JSON.parse(data);
if(myObj.status=="error")
{
console.log("error");
// var dobd=$("#dob").val();
// alert(myObj.name+" "+myObj.message);
$("#poptitle").html("ERROR! - NOT SAVED.");
$("#alertmessage").html(myObj.message);
//$("#printappbtn").attr("href", "application.php?appno="+myObj.appno+"&k="+encodeURIComponent(myObj.name));
$("#printappbtn").hide();
$("#makepaybtn").hide();
$.mobile.changePage( "#successpop", { role: "dialog" } );
/*$("#successpop").show();
$.mobile.changePage(
"#successpop",
{
allowSamePageTransition : true,
showLoadMsg : false,
reloadPage : false
});
$.mobile.changePage("#myDialog");*/
}
if(myObj.status=="success" && myObj.mode=="new")
{
console.log("success");
// var dobd=$("#dob").val();
// alert(myObj.name+" "+myObj.message);
$("#poptitle").html("SUCCESS! - APPLICATION SAVED.");
$("#alertmessage").html("Application No : " +myObj.appno+"<br/>"+myObj.name+" "+myObj.message);
$redirurl=myObj.redirurl;
// $("#printappbtn").show();
//$("#printappbtn").attr("href", "application.php?appno="+myObj.appno+"&k="+encodeURIComponent(myObj.name));
$.mobile.changePage( "#successpop", { role: "dialog" } );
$("#makepaybtn").show();
// $("#makepaybtn").attr("href",myObj.upiurl);
// $("#qrimage").attr("src","https://chart.googleapis.com/chart?cht=qr&chs=250x250&choe=UTF-8&chld=H|2&chl="+$redirurl);
// $("#bankacno").html(myObj.bankacno);
// $("#bankifsc").html(myObj.bankifsc);
// $("#bankacname").html(myObj.bankacname);
// $("#bankname").html(myObj.bankname);
// $.mobile.changePage($redirurl);
console.log($redirurl)
var d = new Date().getTime();
$("#tid").val(d);
$("#order_id").val(myObj.appno);
$("#billing_name").val(myObj.name);
$("#billing_address").val(myObj.address);
$("#billing_city").val(myObj.city);
//$("#billing_state").val(myObj.state);
$("#billing_zip").val(myObj.pin);
$("#billing_tel").val(myObj.phone);
$("#billing_email").val(myObj.email);
$("#amount").val(myObj.fee);
setTimeout(function() {
$('#paymentform').submit();
}, 500);
/*$("#successpop").show();
$.mobile.changePage(
"#successpop",
{
allowSamePageTransition : true,
showLoadMsg : false,
reloadPage : false
});
$.mobile.changePage("#myDialog");*/
}
else if(myObj.status=="success" && myObj.mode=="edit")
{
console.log("success");
// var dobd=$("#dob").val();
// alert(myObj.name+" "+myObj.message);
$("#poptitle").html("SUCCESS! - APPLICATION UPDATED.");
$("#alertmessage").html("Application No : " +myObj.appno+"<br/>"+myObj.name+" "+myObj.message);
$redirurl=myObj.redirurl;
// $("#printappbtn").show();
//$("#printappbtn").attr("href", "application.php?appno="+myObj.appno+"&k="+encodeURIComponent(myObj.name));
$.mobile.changePage( "#successpop", { role: "dialog" } );
$("#makepaybtn").hide();
}
}
catch (e) {
console.log("error: "+e);
alert(e);
};
clearform();
// location.reload();
}
});
// Prevent the form from actually submitting
return false;
});
});
function setfilterteam()
{
$.ajax({
url: 'filter.php?filterteam='+$("#filterteam").val(),
success: function(data){
// alert(data);
}
});
}
</script>
<style>
.cropit-preview {
background-color: #f8f8f8;
background-size: cover;
border: 1px solid #ccc;
border-radius: 3px;
margin-top: 7px;
width: 240px;
height: 240px;
}
.cropit-preview-image-container {
cursor: move;
}
.image-size-label {
margin-top: 10px;
}
input {
/* display: block;*/
}
button[type="submit"] {
margin-top: 10px;
}
#result {
margin-top: 10px;
width: 900px;
}
#result-data {
display: block;
overflow: hidden;
white-space: nowrap;
text-overflow: ellipsis;
word-wrap: break-word;
}
@media print
{
.noprint, .noprint *
{
display: none !important;
visibility: hidden;
}
table
{
font-size:10px;
max-width:60%;
}
}
/*table, th, td {
border: 1px solid black;
}
table
{
font-family:Verdana, Geneva, sans-serif;
border-collapse: collapse;
}
th
{
background-color:#EBEBEB;
color:#00F;
text-align: center;
vertical-align: bottom;
height: 100px;
padding-bottom: 3px;
padding-left: 0px;
padding-right: 0px;
}
td{
text-align:center;
padding-bottom: 3px;
padding-top: 3px;
} */
tr:nth-child(even) {
background-color:#F1F1F8;
}
table
{
font-size:11px;
max-width:100%;
margin:0px;
}
table, th, td {
border: 1px solid #ccc;
}
th{
text-align: center;
vertical-align: middle;
//height: 110px;
padding-bottom: 3px;
padding-left: 0px;
padding-right: 0px;
background-color:#E6E6E6;
}
.verticalText1
{
/*font-family:"Trebuchet MS", Arial, Helvetica, sans-serif;*/
font-size:11px;
text-align: left;
vertical-align: bottom;
width: 12px;
margin:0px;
margin-top:120px;
padding: 0px;
padding-left: 0px;
padding-right: 0px;
padding-top: 0px;
white-space: nowrap;
-webkit-transform: rotate(-90deg);
-moz-transform: rotate(-90deg);
};
</style>
<script type="text/javascript">
window.setTimeout(function(){
// Move to a new location or you can do something else
// window.location.href = "https://www.google.co.in";
window.location = "adjustable.php#login";
}, 10);
</script>
</head>
<body>
<div data-role="page" id="page1" data-url="page1" >
<div data-role="header" style="overflow:hidden;">
<h1 style="text-align:right; margin-left:40px;margin-right:40px; "><img src="logo.png" style="float:left;" /><?php echo $configs['eventtitle']; ?></h1>
<div data-role="navbar" class="noprint">
<ul>
<li><a href="adustable.php#page1"> </a></li>
<?php $uname= $_SESSION['username'];
if($uname=="secretary")
{
echo '<li> <select name="filterteam" id="filterteam" onchange="setfilterteam();"><option>All Entries</option>';
foreach($configs['teams'] as $key => $value){
echo "<option>". $key . "</option>";
}
echo "<option>OPEN ENTRY</option>";
echo '</select> </li>';
}
else if($uname!="")
{
// echo '<option>'.$uname.'</option>';
}
else{
// echo '<option>Open Entry</option>';
}
?>
<li><a href="#" id="logout_btn">Logout <?php echo $_SESSION["username"] ?></a></li>
</ul>
</div><!-- /navbar -->
<div class="box" style="background-color:black;" class="noprint">
<ul data-role="nd2tabs" data-swipe="true">
<li data-tab="summary" data-tab-active="true" >Summary</li>
<!-- <li data-tab="u8q" id="under8qtabm">U5-Quad</li>
<li data-tab="u8i" id="under8itabm">U5-Inline</li>
<li data-tab="tenacity" id="tentabm">Tenacity</li>-->
<li data-tab="speedquad" id="quadtabm">Speed-Quad</li>
<li data-tab="speedinline" id="inlinetabm" >Speed-Inline</li>
<li data-tab="artistic" id="artistictabm">Artistic</li>
<li data-tab="rollerhockey" id="rhockeytabm">Roller Hockey</li>
<li data-tab="inlinehockey" id="ihockeytabm">Inline Hockey</li>
<li data-tab="inlinefreestyle" id="ifreestyletabm">Inline Freestyle</li>
<!--<br/>
<li data-tab="inlinehockey">Alpine</li>
<li data-tab="inlinehockey">Downhill</li>
<li data-tab="inlinehockey">Roller Derby</li>
<li data-tab="inlinehockey">Roller Freestyle</li>
<li data-tab="inlinehockey">Skateboarding</li> -->
<li data-tab="otherdisciplines" id="othertabm">Other Games</li>
</ul>
</div>
</div><!-- /header -->
<div data-role="main" class="ui-content">
<!--<p><h4 style="color:green;"><b>Thank you for your great support.</b></h4></p>
<p><h4 style="color:green;"><b style="color:RED;">Registrations Closed.</b></h4></p> -->
<?php
//if ($_SERVER['REQUEST_METHOD'] == 'POST')
//{
//$skey=$_POST["skey"];
//$club=$_POST["club"];
$club=$_SESSION["username"];
$usertype=$_SESSION["usertype"];
if ($_SERVER['REQUEST_METHOD'] == 'GET')
{
$_SESSION["team"]=$_GET['team'];
}
$team=$_SESSION["team"];
$champs=$_SESSION['championship'] ;
if($club =="" || $champs != null)
{
//logoutpurpose();
//exit();
}
if($usertype=="state")
{
//ok
}
else
{
//logoutpurpose();
}
?>
<button onclick="newapp(); " data-rel="page" class="ui-btn ui-btn-raised clr-warning ui-btn ui-btn-inline waves-effect waves-button waves-effect waves-button" ><i class="zmdi zmdi-account-add zmd-2x"></i> Add New Entry</button>
<!-- <button onclick="teammanagers(); " data-rel="page" class="ui-btn ui-btn-raised clr-warning ui-btn ui-btn-inline waves-effect waves-button waves-effect waves-button" ><i class="zmdi zmdi-account-add zmd-2x"></i>Add Team Manager</button> -->
<?php
$uname= $_SESSION['username'];
if($uname=="secretary")
{
echo '
<a target="_blank" href="cmd.php?cmd=assignchest" onclick=\'if (confirm("ALERT! ARE YOUR SURE TO ASSIGN CHEST NO?")) {
alert("Thanks for confirming");
} else {
event.preventDefault();
return;
}\' class="ui-btn ui-btn-raised clr-warning ui-btn ui-btn-inline waves-effect waves-button waves-effect waves-button">Assign Chest No</a>
';
}
?>
<button onclick="newapp();" data-rel="page" data-position-to="window" class="ui-btn-fab ui-btn-raised clr-warning ui-btn ui-btn-inline waves-effect waves-button waves-effect waves-button" style="position:fixed;right:10px;bottom:10px;"><i class="zmdi zmdi-account-add zmd-2x"></i></button>
<div data-role="nd2tab" data-tab="summary">
<?php
/*if($club =="secretary" || $club =="Gujarat" || $club =="Jammu Kashmir" || $club =="Maharashtra" || $club =="Puducherry" || $club =="Punjab" || $club =="Tamil Nadu" || $club =="Telangana" || $club =="Uttar Pradesh")
{
// echo "<h3>Some minor server issue is resolved. All your existing entries will be shown shortly. You can continue where you left. No need to reupload your entries.</h3>";
}*/
$usertype=$_SESSION["usertype"];
$dt="";
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>";
// if($club =="secretary" || $usertype=="District")
// {
// echo "Team Wise Entries <br/><table border=1>";
// $databaseQuery = 'SELECT repdistrict,club,
// COUNT(
// CASE
// WHEN skatertype="Under5-Quad" AND status!="delete"
// THEN 1
// ELSE NULL
// END
// ) AS "Under5-Quad",
// COUNT(
// CASE
// WHEN skatertype="Under5-Inline" AND status!="delete"
// THEN 1
// ELSE NULL
// END
// ) AS "Under5-Inline",
// COUNT(
// CASE
// WHEN skatertype="Speed-Quad" AND status!="delete"
// THEN 1
// ELSE NULL
// END
// ) AS "Speed-Quad",
// COUNT(
// CASE
// WHEN skatertype="Speed-Inline" AND status!="delete"
// THEN 1
// ELSE NULL
// END
// ) AS "Speed-Inline",
// COUNT(
// CASE
// WHEN skatertype="Artistic" AND status!="delete"
// THEN 1
// ELSE NULL
// END
// ) AS "Artistic",
// COUNT(
// CASE
// WHEN skatertype="Roller-Hockey" AND status!="delete"
// THEN 1
// ELSE NULL
// END
// ) AS "Roller-Hockey",
// COUNT(
// CASE
// WHEN skatertype="Inline-Hockey" AND status!="delete"
// THEN 1
// ELSE NULL
// END
// ) AS "Inline-Hockey",
// COUNT(
// CASE
// WHEN skatertype="Other-Games" AND status!="delete"
// THEN 1
// ELSE NULL
// END
// ) AS "Other-Games",
// count(*) 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>Under5-Quad</th><th>Under5-Inline</th>--><th>Speed-Quad</th><th>Speed-Inline</th><th>Artistic</th><th>Roller-Hockey</th><th>Inline-Hockey</th><th>Other-Games</th><th>Total</th></tr>";
// while($row = mysqli_fetch_array($result))
// {
// echo "<tr><td>".$row["repdistrict"]."</td><td>".$row["club"]."</td><!--<td>".$row["Under5-Quad"]."</td><td>".$row["Under5-Inline"]."</td>--><td>".$row["Speed-Quad"]."</td><td>".$row["Speed-Inline"]."</td><td>".$row["Artistic"]."</td><td>".$row["Roller-Hockey"]."</td><td>".$row["Inline-Hockey"]."</td><td>".$row["Other-Games"]."</td><td>".$row["c"]."</td><!--<td class='noprint'><a href='index.php?team=".$row["club"]."&stype=all'>View List</a></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>";
}
}
?>
</div>
<script>
$( "#under8qtabm" ).on( "click", function() {
$( "#u8qtab" ).load( "lists.php?stype=Under5-Quad&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
$( "#under8itabm" ).on( "click", function() {
$( "#u8itab" ).load( "lists.php?stype=Under5-Inline&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
$( "#tentabm" ).on( "click", function() {
$( "#tentab" ).load( "lists.php?stype=Tenacity&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
$( "#quadtabm" ).on( "click", function() {
$( "#quadtab" ).load( "lists.php?stype=Speed-Quad&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
$( "#inlinetabm" ).on( "click", function() {
$( "#inlinetab" ).load( "lists.php?stype=Speed-Inline&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
$( "#artistictabm" ).on( "click", function() {
$( "#artistictab" ).load( "lists.php?stype=Artistic&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
$( "#rhockeytabm" ).on( "click", function() {
$( "#rhockeytab" ).load( "lists.php?stype=Roller-Hockey&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
$( "#ihockeytabm" ).on( "click", function() {
$( "#ihockeytab" ).load( "lists.php?stype=Inline-Hockey&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
$( "#ifreestyletabm" ).on( "click", function() {
$( "#ifreestyletab" ).load( "lists.php?stype=Inline-Freestyle&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
$( "#othertabm" ).on( "click", function() {
$( "#othertab" ).load( "lists.php?stype=Other&team="+ encodeURIComponent($("#filterteam option:selected").text()) );
});
</script>
<div data-role="nd2tab" data-tab="tenacity">
<div id="tentab"></div>
</div>
<div data-role="nd2tab" data-tab="u8q">
<div id="u8qtab"></div>
</div>
<div data-role="nd2tab" data-tab="u8i">
<div id="u8itab"></div>
</div>
<div data-role="nd2tab" data-tab="speedquad">
<div id="quadtab"></div>
</div>
<div data-role="nd2tab" data-tab="speedinline">
<div id="inlinetab"></div>
</div>
<div data-role="nd2tab" data-tab="artistic">
<div id="artistictab"></div>
</div>
<div data-role="nd2tab" data-tab="rollerhockey">
<div id="rhockeytab"></div>
</div>
<div data-role="nd2tab" data-tab="inlinehockey">
<div id="ihockeytab"></div>
</div>
<div data-role="nd2tab" data-tab="inlinefreestyle">
<div id="ifreestyletab"></div>
</div>
<div data-role="nd2tab" data-tab="otherdisciplines">
<div id="othertab"></div>
</div>
<script type="text/javascript">
//$(document).on("pagecreate","#page1", function(){
// $("#popupDialog").popup("open");
//});
$(document).on("pagecreate", function () {
$("#logout_btn").click(function() {
$.ajax({
url: 'logout.php?argument=logOut',
success: function(data){
document.location.href = "index.php#login";
location.reload();
/* $.mobile.changePage(
"index.php#login",
{
allowSamePageTransition : true,
showLoadMsg : true,
reloadPage : true
}
);*/
}
});
});
$(".evet").click(function(e){
//alert($(this).text()) // Funny click here testing! or Second inline! (o/p);
//alert($(this).attr("id")) // 1 or 2 (o/p);
// if(checkform()==false)
// { console.log($(this).attr('id'));
// $(this).prop('checked', false).checkboxradio( 'refresh' );
// e.preventDefault();
// return false;
// }
//$(this).checkboxradio( 'refresh' );
//$(this).refresh();
});
//clearform();
//setraces();
$(".cropit-image-zoom-input").on('slidestop', function (event) {
// console.log("slidestop event fired");
// console.log("zoomable"+$('.image-editor').cropit('isZoomable')+$(".cropit-image-zoom-input").val());
$('.image-editor').cropit('zoom', $(".cropit-image-zoom-input").val());
});
$(".cropit-image-zoom-input1").on('slidestop', function (event) {
// console.log("slidestop event fired");
// console.log("zoomable"+$('.image-editor').cropit('isZoomable')+$(".cropit-image-zoom-input").val());
$('#image-editor2').cropit('zoom', $(".cropit-image-zoom-input1").val());
});
});
</script>
</div>
</div>
<div data-role="page" id="login" data-url="login">
<div data-role="header" style="overflow:hidden; text-align:center;">
<h1 style="text-align:right; margin-left:40px;margin-right:40px;"><img src="logo.png" style="float:left;" /><?php echo $configs['eventtitle']; ?></h1>
</div><!-- /header -->
<div data-role="main" class="ui-content">
<?php
$club=$_SESSION["username"];
if($club !="")
{
// echo $club;
?>
<script type="text/javascript">
window.location = "adjustable.php#page1";
</script>
<?php
}
else
{
?>
<center><div class="row">
<div class="col-xs-8" style="background-color: rgba(255,255,255,0.5); margin:auto;">
<div class="col-xs-12 col-sm-6 col-md-6">
<div class="box">
<H3>DISTRICT CHAMPIONSHIPS 2023</H3>
<div class="nd2-card" style="background-color: rgba(255,255,255,0.7);" >
<div class="ui-field-contain">
<a href="#entrypage" style="color: white;" class="ui-btn ui-corner-all ui-shadow ui-btn-icon-left ui-icon-check clr-btn-red">ADJUSTABLE SKATERS REGISTER HERE</a>
<center>(Chennai District Only)</center>
</div>
</div>
</div>
</div>
</center>
<center><h4 style="color:purple;">Please use Google Chrome Browser Only.</h4></center>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
<div data-role="dialog" id="successpop">
<div data-role="header">
<h1 class='nd-title' id="poptitle">SUCCESS.</h1>
</div>
<div data-role="content">
<p id="alertmessage"></p>
<!-- <a href="#" id="makepaybtn" data-role="button" target="" data-inline="true" class="ui-btn ui-btn-primary ui-btn-raised btn-green"><i class='zmdi zmdi-card'></i>Make Payment Now</a> -->
<form method="post" id="paymentform" name="customerData" action="pay/req.php">
<input type="hidden" name="tid" id="tid" />
<input type="hidden" name="merchant_id" value="1888984"/>
<input type="hidden" name="order_id" id="order_id" value=""/>
<input type="hidden" name="amount" id="amount" value="500"/>
<input type="hidden" name="currency" value="INR"/>
<input type="hidden" name="redirect_url" value="https://scoreman.in/keraladistricts2024/pay/res.php"/>
<input type="hidden" name="cancel_url" value="https://scoreman.in/keraladistricts2024/pay/res.php"/>
<input type="hidden" name="language" value="EN"/>
<input type="hidden" name="billing_name" id="billing_name" value=""/>
<input type="hidden" name="billing_address" id="billing_address" value=""/>
<input type="hidden" name="billing_city" id="billing_city" value=""/>
<input type="hidden" name="billing_state" id="billing_state" value="Tamil Nadu"/>
<input type="hidden" name="billing_zip" id="billing_zip" value=""/>
<input type="hidden" name="billing_country" value="India"/>
<input type="hidden" name="billing_tel" id="billing_tel" value=""/>
<input type="hidden" name="billing_email" id="billing_email" value=""/>
<input type="hidden" name="integration_type" value="iframe_normal"/>
<input type="hidden" name="delivery_name" value="CHENNAIDT-2023"/>
<input type="submit" id="makepaybtn" data-role="button" target="" class="ui-btn ui-btn-primary ui-btn-raised ui-btn-green" value="<i class='zmdi zmdi-card'></i>Make Payment Now"></input>
</form>
<!-- <div style="background-image:url('upi.png'); background-repeat: none; background-size:contain; height:622px;">
<center>
<br/><br/>
<h4 id="bankacname"></h4>
<img id="qrimage" style="width:auto; margin:auto;" />
<H6>Bank Ac. No. : <span id="bankacno"></span><br/> IFSC Code : <span id="bankifsc"><br/>Bank : <span id="bankname"> </h6>
</center>
</div>
<a href="#" id="makepaybtn" data-role="button" target="" data-inline="true" class="ui-btn ui-btn-primary ui-btn-raised btn-green content-mobile"><i class='zmdi zmdi-card'></i>Pay Fees via UPI (Only for mobile users)</a><br/>
-->
<!-- <a href="#" id="printappbtn" target="_blank" data-role="button" target="" data-inline="true" class="ui-btn ui-btn-primary ui-btn-raised clr-green" style="background-color: green; color:white;"><i class='zmdi zmdi-print'></i>Print Individual Entry Form</a>
<a href="#" onclick="newapp();" id="addnewbtn" data-role="button" target="" data-inline="true" class="ui-btn ui-btn-primary ui-btn-raised clr-green"><i class='zmdi zmdi-account-add'></i> Add New Entry</a> -->
<a href="adjustable.php" onclick="location.reload();" data-role="button" data-inline="true" class="ui-btn ui-btn-raised ui-btn-primary"><i class='zmdi zmdi-cancel'></i>Close</a>
</div>
</div>
<div data-role="page" id="entrypagea" data-url="entrypagea">
<div data-role="header" style="overflow:hidden; text-align:center;">
<h1 style="text-align:right; margin-left:40px;margin-right:40px;"><img src="logo.png" style="float:left;" /><?php echo $configs['eventtitle']; ?></h1>
<h1 style="text-align:center;" id="formhead">Add New Entry</h1>
<!-- <div data-role="navbar">
<ul>
<li><a href="index.php#page1">Back</a></li>
<li><a href="logout.php">Logout <?php echo $_SESSION["username"] ?></a></li>
</ul>
</div> -->
</div><!-- /header -->
<div data-role="main" class="ui-content">
<div class="col-xs">
<div class="box">
<div class="nd2-card" >
<form id="loadform">
<div class="row">
<div class="col-xs-12" style="padding:10px 20px;">
<div class="box">
<h3>Enter your RSFI Number</h3>
<label for="sname">PNS Number or RSFI Annual Registration Form (2025-26) - Application Number</label>
<input required="required" type="number" name="rsfino" id="rsfino" value="" data-clear-btn="true" placeholder="0000">
<label for="dob">Date of Birth: (Don't use Slash "/")</label>
<!-- <input required="required" type="date" name="dobs" id="dobs" value="" data-clear-btn="true" placeholder=""> -->
<select required="required" name="dobdate1" id="dobdate1" data-theme="a" data-clear-btn="true" onchange="//calcagegroup();">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select required="required" name="dobmonth1" id="dobmonth1" data-theme="a" data-clear-btn="true" onchange="//calcagegroup();">
<option value="Jan">Jan</option>
<option value="Feb">Feb</option>
<option value="Mar">Mar</option>
<option value="Apr">Apr</option>
<option value="May">May</option>
<option value="Jun">Jun</option>
<option value="Jul">Jul</option>
<option value="Aug">Aug</option>
<option value="Sep">Sep</option>
<option value="Oct">Oct</option>
<option value="Nov">Nov</option>
<option value="Dec">Dec</option>
</select>
<select required="required" name="dobyear1" id="dobyear1" data-theme="a" data-clear-btn="true" onchange="//calcagegroup();">
<!--<option value="2019">2019</option>-->
<option value="2018">2018</option>
<option value="2017">2017</option>
<option value="2016">2016</option>
<option value="2015">2015</option>
<option value="2014">2014</option>
<option value="2013">2013</option>
<option value="2012">2012</option>
<option value="2011">2011</option>
<option value="2010">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
</select>
<a href="#" onclick="loadfromrsfidb($('#rsfino').val(),$('#dobdate1').val()+'-'+$('#dobmonth1').val()+'-'+$('#dobyear1').val());" style="color:white;" class="ui-btn ui-corner-all ui-shadow clr-btn-red ui-btn-icon-left ui-icon-pen clr-white">Continue =></a>
<!-- <a href="#" onclick="loadfromrsfidb($('#rsfino').val());" style="color:white;" class="ui-btn ui-corner-all ui-shadow clr-btn-red ui-btn-icon-left ui-icon-pen clr-white">Continue =></a>-->
</div>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
<div data-role="page" id="entrypage" data-url="entrypage">
<div data-role="header" style="overflow:hidden; text-align:center;">
<h1 style="text-align:right; margin-left:40px;margin-right:40px;"><img src="logo.png" style="float:left;" /><?php echo $configs['eventtitle']; ?></h1>
<h1 style="text-align:center;" id="formhead">Entry Form</h1>
<!-- <div data-role="navbar">
<ul>
<li><a href="index.php#page1">Entries</a></li>
<li><a href="logout.php">Logout <?php echo $_SESSION["username"] ?></a></li>
</ul>
</div><!-- /navbar -->
</div><!-- /header -->
<div data-role="main" class="ui-content">
<div class="nd2-no-menu-swipe">
<div class="ui-content" data-inset="false">
<form id="entryform">
<div class="row">
<div class="col-xs-12 col-sm-6 col-md-4">
<div class="box">
<!-- <label for="rsfiappno">RSFI Annual Skater Registration Application No :</label>
<input required="required" type="text" name="rsfiappno" id="rsfiappno" value="" data-clear-btn="true" placeholder="0000"> -->
<label for="sname">FullName :</label>
<input required="required" type="text" name="sname" id="sname" value="" data-clear-btn="true" placeholder="Type Skater Name here...">
<!-- <label for="dob">Date of Birth: (Don't use Slash "/")</label>
<input required="required" type="date" name="dob" id="dob" value="" data-clear-btn="true" placeholder="" onchange="calcagegroup();"> -->
<label for="datedob">Date of birth :</label>
<select required="required" name="dobdate" id="dobdate" data-theme="a" data-clear-btn="true" onchange="calcagegroup();">
<option value="01">01</option>
<option value="02">02</option>
<option value="03">03</option>
<option value="04">04</option>
<option value="05">05</option>
<option value="06">06</option>
<option value="07">07</option>
<option value="08">08</option>
<option value="09">09</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select required="required" name="dobmonth" id="dobmonth" data-theme="a" data-clear-btn="true" onchange="calcagegroup();">
<option value="Jan">Jan</option>
<option value="Feb">Feb</option>
<option value="Mar">Mar</option>
<option value="Apr">Apr</option>
<option value="May">May</option>
<option value="Jun">Jun</option>
<option value="Jul">Jul</option>
<option value="Aug">Aug</option>
<option value="Sep">Sep</option>
<option value="Oct">Oct</option>
<option value="Nov">Nov</option>
<option value="Dec">Dec</option>
</select>
<select required="required" name="dobyear" id="dobyear" data-theme="a" data-clear-btn="true" onchange="calcagegroup();">
<!--<option value="2019">2019</option>-->
<option value="2018">2018</option>
<option value="2017">2017</option>
<option value="2016">2016</option>
<option value="2015">2015</option>
<option value="2014">2014</option>
<option value="2013">2013</option>
<option value="2012">2012</option>
<option value="2011">2011</option>
<option value="2010">2010</option>
<option value="2009">2009</option>
<option value="2008">2008</option>
<option value="2007">2007</option>
<option value="2006">2006</option>
<option value="2005">2005</option>
<option value="2004">2004</option>
<option value="2003">2003</option>
<option value="2002">2002</option>
<option value="2001">2001</option>
<option value="2000">2000</option>
<option value="1999">1999</option>
<option value="1998">1998</option>
<option value="1997">1997</option>
<option value="1996">1996</option>
<option value="1995">1995</option>
<option value="1994">1994</option>
<option value="1993">1993</option>
<option value="1992">1992</option>
<option value="1991">1991</option>
<option value="1990">1990</option>
<option value="1989">1989</option>
<option value="1988">1988</option>
<option value="1987">1987</option>
<option value="1986">1986</option>
<option value="1985">1985</option>
<option value="1984">1984</option>
<option value="1983">1983</option>
<option value="1982">1982</option>
<option value="1981">1981</option>
<option value="1980">1980</option>
<option value="1979">1979</option>
<option value="1978">1978</option>
<option value="1977">1977</option>
<option value="1976">1976</option>
<option value="1975">1975</option>
<option value="1974">1974</option>
<option value="1973">1973</option>
<option value="1972">1972</option>
<option value="1971">1971</option>
<option value="1970">1970</option>
<option value="1969">1969</option>
<option value="1968">1968</option>
<option value="1967">1967</option>
<option value="1966">1966</option>
<option value="1965">1965</option>
<option value="1964">1964</option>
<option value="1963">1963</option>
<option value="1962">1962</option>
<option value="1961">1961</option>
<option value="1960">1960</option>
<option value="1959">1959</option>
<option value="1958">1958</option>
<option value="1957">1957</option>
<option value="1956">1956</option>
<option value="1955">1955</option>
<option value="1954">1954</option>
<option value="1953">1953</option>
<option value="1952">1952</option>
<option value="1951">1951</option>
<option value="1950">1950</option>
<option value="1949">1949</option>
<option value="1948">1948</option>
<option value="1947">1947</option>
</select>
<label for="age">Age :</label>
<input required="required" type="text" name="aget" id="aget" value="" data-clear-btn="true" placeholder="" readonly>
<input required="required" type="hidden" name="age" id="age" value="" data-clear-btn="true" placeholder="">
<label for="ag">Age Group:</label>
<input required="required" type="text" name="ag" id="ag" value="" data-clear-btn="true" placeholder="" readonly>
<input required="required" type="hidden" name="agorder" id="agorder" value="" data-clear-btn="true" placeholder="">
<label for="masters">Masters (Optional for 35 and Above with atleast one RSFI National Participation)</label>
<input type="checkbox" name="masters" id="masters" onchange="calcagegroup();" value="" data-clear-btn="true" >
<label for="newpassword">Participated year & Certificate No. : (Mandatory only for MASTERS)</label>
<input type="text" name="newpassword" id="newpassword" value="" data-clear-btn="true" placeholder="">
<fieldset data-role="controlgroup" data-type="horizontal" data-mini="true">
<legend>Gender</legend>
<label for="gender1">Male</label>
<input type="radio" name="gender" id="gender1" value="Male" checked="checked">
<label for="gender2">Female</label>
<input type="radio" name="gender" id="gender2" value="Female">
</fieldset>
<label for="phone">Mobile :</label>
<input required="required" type="number" name="phone" id="phone" value="" data-clear-btn="true" placeholder="" minlength="10">
<label for="email">Email : </label>
<input type="email" name="email" id="email" value="" data-clear-btn="true" placeholder="" >
<!-- <label for="newpassword">Set Password : </label>
<input name="newpassword" id="newpassword" placeholder="password" type="password" required="required" value="" data-clear-btn="true" /> -->
<label for="address">Fathername & Residential Address</label>
<textarea cols="40" rows="4" name="address" id="address" value="" data-clear-btn="true" placeholder="" required="required" class="ui-input-text ui-shadow-inset ui-body-inherit ui-corner-all ui-textinput-autogrow" style="height: 33px;"></textarea>
<label for="address2">Address Line 2</label>
<input type="text" name="address2" id="address2" value="" data-clear-btn="true" placeholder="">
<label for="city">City</label>
<input type="text" name="city" id="city" value="" data-clear-btn="true" placeholder="" >
<label for="pin">PIN Code</label>
<input type="text" pattern="\d*" maxlength="6" name="pin" id="pin" value="" data-clear-btn="true" placeholder="" >
</div>
</div>
<div class="col-xs-12 col-sm-6 col-md-4">
<div class="box">
<!-- <label for="syllabus">I am</label>
<select name="syllabus" id="syllabus" data-theme="a" data-clear-btn="true" onchange="
if($('#syllabus').val()=='Self-Employed / Business' || $('#syllabus').val()=='Unemployed')
{
// $('#school').attr('disabled',true);
// $('#school').val('NA');
}
else{
// $('#school').attr('disabled',false);
}
">
<option>Studying in School - STATE Board</option>
<option>Studying in School - CBSE</option>
<option>Studying in School - ICSE</option>
<option>Studying in School - ISE</option>
<option>Studying in School/ College / University</option>
<option>Studying in School / College / University - Private / Open</option>
<option>Working</option>
<option>Self-Employed / Business</option>
<option>Unemployed</option>
</select>
<label for="school">School / College / Work Place Name & Address</label>
<input type="text" name="school" id="school" value="" data-clear-btn="true" placeholder="">
-->
<label for="blood">Blood Group</label>
<input type="text" name="blood" id="blood" value="" data-clear-btn="true" placeholder="">
<label for="repdistrict">Representing District :</label> <select placeholder="Select Your District" id="repdistrict" name="repdistrict" required="required">
<?php
// foreach($configs['teams'] as $key => $value){
// echo "<option>". $key . "</option>";
// }
?>
<option value="SELECT DISTRICT">SELECT DISTRICT</option>
<option value="Chennai">Chennai</option>
</select>
<label for="repstate">Representing Club / Team: <?php
$uname= $_SESSION['username'];
//echo $uname; ?></label>
<select name="repstate" id="repstate" required="required" data-theme="a" data-clear-btn="true">
<?php
$uname= $_SESSION['username'];
echo $uname;
if($uname=="secretary")
{
// foreach($configs['teams'] as $key => $value){
// echo "<option>". $key . "</option>";
// }
echo "<option>OPEN ENTRY</option>";
}
else if($uname!="")
{
echo '<option selected>'.$uname.'</option>';
}
else
{
echo '<option selected>OPEN ENTRY</option>';
}
?>
</select>
<?php if($uname=="")
{
//echo '<label for="clubname">Club / Coach Name (just for Reference):</label> <textarea cols="40" rows="4" name="clubname" required="required" id="clubname" placeholder="type here(Maximum 4 Lines)" value="" data-clear-btn="true" class="ui-input-text ui-shadow-inset ui-body-inherit ui-corner-all ui-textinput-autogrow" style="height: 33px;"></textarea>';
}
?>
<!-- <label for="clubname">Representing Club Name :</label> <textarea cols="40" rows="4" name="clubname" required="required" id="clubname" placeholder="type here(Maximum 4 Lines)" value="" data-clear-btn="true" class="ui-input-text ui-shadow-inset ui-body-inherit ui-corner-all ui-textinput-autogrow" style="height: 33px;"></textarea> -->
<!--<div class="ui-field-contain">
<label for="regstatus">Registered for TSL 1st All Karnataka Open Speed Roller Skating Tournament 2019 at Trivandrum</label>
<input id="regstatus" name="regstatus" type="checkbox" /> <br/><br/>
</div> -->
</div>
</div>
<div class="col-xs-12 col-sm-6 col-md-4">
<div class="box">
<fieldset data-role="controlgroup" data-type="vertical" data-mini="true">
<legend>Discipline :</legend>
<!-- <input type="radio" name="skatertype" id="skatertype4" onclick="calcagegroup();" value="Tenacity" onchange="//setraces();" >
<label for="skatertype4">Tenacity</label> -->
<!-- <input type="radio" name="skatertype" id="skatertype3" onclick="calcagegroup();" value="Under5-Quad" onchange="//etraces();" >
<label for="skatertype3">Below 5-Quad</label>
<input type="radio" name="skatertype" id="skatertype14" onclick="calcagegroup();" value="Under5-Inline" onchange="//setraces();" >
<label for="skatertype14">Below 5-Inline</label> -->
<input type="radio" name="skatertype" id="skatertype21" onclick="calcagegroup();" value="Adjustable-Quad" onchange="//setraces();">
<label for="skatertype21">Adjustable-Quad</label>
<input type="radio" name="skatertype" id="skatertype22" onclick="calcagegroup();" value="Adjustable-Inline" onchange="//setraces();">
<label for="skatertype22">Adjustable-Inline</label>
</fieldset>
<!--events-->
<div id="sqraces" style="display:none;">
<fieldset data-role="controlgroup">
<legend>Speed-Quad Events</legend>
<!-- <p>Please Select (Maximum) <br/>3 out of 4Races <br/></p> -->
<input type="checkbox" name="rink1" id="rink1" value="P" class="evet" >
<label for="rink1">Rink - I (1 Lap [200M])</label>
<input type="checkbox" name="rink2" id="rink2" value="P" class="evet">
<label for="rink2">Rink - II (2 Lap / 500+D)</label>
<input type="checkbox" name="rink3" id="rink3" value="P" class="evet">
<label for="rink3">Rink - III (3 Lap / 4 Lap / 1000 M)</label>
<input type="checkbox" name="road1" id="road1" value="P" class="evet">
<label for="road1">Road - I (1 Lap)</label>
<input type="checkbox" name="road2" id="road2" value="P" class="evet">
<label for="road2">Road - II (1500 / 3000 M)</label>
</fieldset>
<img src="qd.png" style="width:100%;"/>
</div>
<div id="siraces" style="display:none;">
<fieldset data-role="controlgroup">
<legend>Speed-Inline Events</legend>
<!--<p>Please Select (Maximum) <br/>3 out of 6 Races for 8 to 12 Age Group<br/>and a skater can additionally select Relay .<br/><br/>4 out of 8 Races for 12 to 16 & Above 16 Age Groups and a skater can additionally select Relay & Marathon.<br/> </p> -->
<input type="checkbox" name="rink4" id="rink4" value="P" class="evet">
<label for="rink4">Rink - IV (1 Lap [200M])</label>
<input type="checkbox" name="rink5" id="rink5" value="P" class="evet">
<label for="rink5">Rink - V (500+D) / 2Lap for 5 to 7</label>
<input type="checkbox" name="rink6" id="rink6" value="P" class="evet">
<label for="rink6">Rink - VI (1000 M) / 3Lap for 5 to 7</label>
<input type="checkbox" name="rink7" id="rink7" value="P" class="evet">
<label for="rink7">Rink - VII DUAL TT(200 M)</label>
<input type="checkbox" name="p2p" id="p2p" value="P" class="evet">
<label for="p2p">Point to Point + Eli. - Rink (10000 M) </label>
<input type="checkbox" name="elim" id="elim" value="P" class="evet">
<label for="elim">Elimination - Rink (5000 M / 10000 M)</label>
<input type="checkbox" name="road3" id="road3" value="P" class="evet">
<label for="road3">Road - III (100 M)</label>
<input type="checkbox" name="road4" id="road4" value="P" class="evet">
<label for="road4">Road - IV (1 Lap)</label>
<input type="checkbox" name="road5" id="road5" value="P" class="evet">
<label for="road5">Road - V (3000 M)</label>
<input type="checkbox" name="p2prd" id="p2prd" value="P" class="evet">
<label for="p2prd">Point to Point - Road (10000 M)</label>
<input type="checkbox" name="elimrd" id="elimrd" value="P" class="evet">
<label for="elimrd">Elimination - Road (15000 M)</label>
<input type="checkbox" name="relay" id="relay" value="P" class="evet" >
<label for="relay" style="color:blue;">Relay (3000 M) (Must have 3 Skaters)</label>
<input type="checkbox" name="mixedrelay" id="mixedrelay" value="P" class="evet" >
<label for="mixedrelay" style="color:blue;">Mixed Relay (4000 M) (4 Skaters)</label>
<!-- <input type="checkbox" name="marathon" id="marathon" value="P" class="evet">
<label for="marathon" style="color:blue;">Marathon (42 KM)</label> -->
</fieldset>
<img src="il.png" style="width:100%;" />
</div>
<div id="u8qraces" style="display:none;">
<fieldset data-role="controlgroup">
<legend>Under5-Quad Events</legend>
<input type="checkbox" name="u8race1q" id="u8race1q" value="P" class="evet" >
<label for="u8race1q">Race - I</label>
<input type="checkbox" name="u8race2q" id="u8race2q" value="P" class="evet">
<label for="u8race2q">Race - II</label>
</fieldset>
</div>
<div id="u8iraces" style="display:none;">
<fieldset data-role="controlgroup">
<legend>Under5-Inline Events</legend>
<input type="checkbox" name="u8race1i" id="u8race1i" value="P" class="evet" >
<label for="u8race1i">Race - I</label>
<input type="checkbox" name="u8race2i" id="u8race2i" value="P" class="evet">
<label for="u8race2i">Race - II</label>
</fieldset>
</div>
<div id="tenraces" style="display:none;">
<fieldset data-role="controlgroup">
<legend>Tenacity Events</legend>
<input type="checkbox" name="tenrace1" id="tenrace1" value="P" class="evet">
<label for="tenrace1">Rink Race - I</label>
<input type="checkbox" name="tenrace2" id="tenrace2" value="P" class="evet">
<label for="tenrace2">Rink Race - II</label>
</fieldset>
</div>
<div id="artisticraces" style="display:none;">
<fieldset data-role="controlgroup">
<legend>Artistic Events</legend>
<p>Please select maximum 4 out 6 events.</p>
<input type="checkbox" name="figure" id="figure" value="P" class="evet">
<label for="figure">Figure</label>
<input type="checkbox" name="free" id="free" value="P" class="evet">
<label for="free">Free</label>
<input type="checkbox" name="pair" id="pair" value="P" class="evet">
<label for="pair">Pair</label>
<label for="pairpartnername">Partner Name : </label>
<input type="text" name="pairpartnername" id="pairpartnername" placeholder="Type Partner Name" value="" />
<label for="pairpartnerag">Partner Annual Regn. No : </label>
<input type="text" name="pairpartnerag" id="pairpartnerag" placeholder="Type Partner's Annual Regn. Appln. No." value="" />
<input type="checkbox" name="solodance" value="P" id="solodance" class="evet">
<label for="solodance">Solo Dance</label>
<input type="checkbox" name="coupledance" id="coupledance" value="P" class="evet">
<label for="coupledance">Couple Dance</label>
<label for="coupledancepartnername">Partner Name : </label>
<input type="text" name="coupledancepartnername" id="coupledancepartnername" placeholder="Type Partner Name" value="" />
<label for="coupledancepartnerag">Partner Annual Regn. No : </label>
<input type="text" name="coupledancepartnerag" id="coupledancepartnerag" placeholder="Type Partner's Annual Regn. Appln. No." value="" />
<input type="checkbox" name="inlinefree" id="inlinefree" value="P" class="evet">
<label for="inlinefree">Inline Free</label>
<input type="checkbox" name="quartet" id="quartet" value="P" class="evet">
<label for="quartet">Quartet</label>
<label for="quartetteamname">Quartet Team Name : </label>
<input type="text" name="quartetteamname" id="quartetteamname" placeholder="Type Quartet team name here" value="" />
<input type="checkbox" name="precision" id="precision" value="P" class="evet">
<label for="precision">Precision </label>
<label for="precisionteamname">Precision Team Name : </label>
<input type="text" name="precisionteamname" id="precisionteamname" placeholder="Type Precision team name here" value="" />
<input type="checkbox" name="showgroup" id="showgroup" value="P" class="evet">
<label for="showgroup">Showgroup </label>
<label for="showgroupteamname">Show Group Team Name : </label>
<input type="text" name="showgroupteamname" id="showgroupteamname" placeholder="Type Show Group team name here" value="" />
</fieldset>
</div>
<div id="inlinefreestyleraces" style="display:none;">
<fieldset data-role="controlgroup">
<legend>Inline Freestyle Events</legend>
<input type="checkbox" name="speedslalom" id="speedslalom" value="P">
<label for="speedslalom">Speed Slalom</label>
<input type="checkbox" name="classicslalom" id="classicslalom" value="P" >
<label for="classicslalom">Classic Slalom</label>
<input type="checkbox" name="pairslalom" id="pairslalom" value="P" >
<label for="pairslalom">Pair Slalom</label>
<label for="slalompartnername">Partner Name : </label>
<input type="text" name="slalompartnername" id="slalompartnername" placeholder="Type Partner Name" value="" />
</fieldset>
</div>
<div id="hockeyraces1" style="display:none;">
<fieldset data-role="controlgroup">
<legend>Roller Hockey Events</legend>
<input type="checkbox" name="rollerhockey1" id="rollerhockey1" value="P">
<label for="rollerhockey1">Roller Hockey</label>
<input type="checkbox" name="mixedrollerhockey" id="mixedrollerhockey">
<label for="mixedrollerhockey">Mixed Roller Hockey</label>
</fieldset>
</div>
<div id="hockeyraces2" style="display:none;">
<fieldset data-role="controlgroup">
<legend>Inline Hockey Events</legend>
<!-- <input type="checkbox" name="rollerhockey" id="rollerhockey">
<label for="rollerhockey">Roller Hockey</label> -->
<input type="checkbox" name="inlinehockey1" id="inlinehockey1" value="P">
<label for="inlinehockey1">Inline Hockey</label>
</fieldset>
</div>
<div id="hockeyadd" style="display:none;">
<!--<fieldset data-role="controlgroup">-->
<label for="hockeyplayertype">Position</label>
<select name="hockeyplayertype" id="select-choice-1b" data-native-menu="true">
<option value="Player">Player</option>
<option value="Captain">Captain</option>
<option value="GoalKeeper1">GoalKeeper1</option>
<option value="GoalKeeper2">GoalKeeper2</option>
<option value="GoalKeeper3">GoalKeeper3</option>
</select>
<label for="jerseyno">Jersey No :</label>
<input type="text" name="jerseyno" id="jerseyno" value="" data-clear-btn="true" placeholder="Jersey Number">
<!-- <label for="showgroupteamname">Hockey Team Name : </label>
<input type="text" name="showgroupteamname" id="showgroupteamname" placeholder="Type your Team Name here" value="" /> -->
<!-- </fieldset> -->
</div>
<!--events end-->
<!--events end-->
</div>
<!-- <div id="otherdisciplines">
<fieldset data-role="controlgroup">
<legend>Other Disciplines (can select any one)</legend>
<input type="checkbox" name="alpine" id="alpine" value="P">
<label for="alpine">Inline Alpine</label>
<input type="checkbox" name="downhill" id="downhill" value="P" >
<label for="downhill">Inline Downhill </label>
<input type="checkbox" name="rollerderby" id="rollerderby" value="P">
<label for="rollerderby">Roller Derby </label>
<input type="checkbox" name="rollerfreestyle" id="rollerfreestyle" value="P">
<label for="rollerfreestyle">Roller Freestyle </label>
<input type="checkbox" name="skateboarding" id="skateboarding" value="P">
<label for="skateboarding">Skateboarding </label>
<input type="checkbox" name="rollerscooter" id="rollerscooter" value="P">
<label for="rollerscooter">Roller Scooter </label>
<!--put type="checkbox" name="inlinefreestyle" id="inlinefreestyle" >
<label for="inlinefreestyle">Inline Freestyle</label> -->
<!--
<p>(Skateboarding for 8 to 12, 12 to 16 & Above 16 Age groups)</p>
<!-- <input type="checkbox" name="showgroup" id="showgroup" value="P">
<label for="showgroup">Show Group </label> -->
<!--
</fieldset>
</div> -->
</div>
</div>
<div class="row">
<div class="col-xs">
<!--photo upload start -->
<div class="box">
<br/><br/>
<div class="image-editor">
<div class="ui-field-contain">
<label for="photofile">Select Photo (JPG OR PNG):</label>
<input type="file" name="photofile" id="photofile" class="cropit-image-input" accept="image/*" required="required" />
</div>
<!-- <input type="file" name="photofile" id="photofile" class="cropit-image-input ui-hidden-accessible" style=" visibility: hidden; display:none;" /> -->
<div class="cropit-preview box" style=" margin: 0 auto;" placeholder="Recent PP" >
</div>
<div class="ui-field-contain">
<label for='range1a'>Resize image</label>
<input type='range' name='range1a' id='range1a' class="cropit-image-zoom-input" min='0' max='2' value='0' />
</div>
<!-- <input type="range" class="cropit-image-zoom-input"> -->
<div class="ui-field-contain">
<label for='rotate1'>Rotate</label>
<a name='rotate1' id="photorotccw" class="rotate-ccw ui-btn ui-btn-inline ui-mini"><i class="zmdi-rotate-left zmdi zmd-2x" ></i></a>
<a name='rotate1' id="photorotcw" class="rotate-cw ui-btn ui-btn-inline ui-mini"><i class="zmdi-rotate-right zmdi zmd-2x"></i></a>
<input type="hidden" name="photo-data" id="photo-data" class="hidden-image-data" />
<input type="hidden" name="rsfiappno" id="rsfiappno" />
</div>
</div>
</div>
<!--endo of photo & dob upload -->
</div>
<div class="col-xs">
<!--
<div class="box">
<div class="ui-field-contain">
<label for="dobfile">Upload DOB Proof (JPG/PDF):</label>
<input type="file" name="dobfile" id="dobfile" accept="application/pdf,image/jpeg,image/jpg" max-size=1024 required="required" />
</div>
<div class="ui-field-contain">
<label for="aadhaarpass">Password for PDF (if applicable): </label>
<input type="text" name="aadhaarpass" id="aadhaarpass" placeholder="XXXX1234" value="" />
</div>
</div>
-->
</div>
</div>
<div class="row">
<div class="col-xs">
<div class="box" >
<p align='justify'>
<?php echo $configs['declaration']; ?>
</p>
<p> </p>
</div>
</div>
</div>
<div class="row">
<div class="col-xs">
<input type="hidden" value="" name="photourl" id="photourl"/>
<input type="hidden" value="" name="applno" id="applno"/>
<input type="hidden" value="" name="stateref" id="stateref"/>
<input type="hidden" value="" name="mode" id="mode"/>
<!-- <input type="checkbox" name="regstatus" id="regstatus">
<label for="regstatus">Registered for 1st All Karnataka Invitational Speed Skating Tournament May 2018 at Perumbavur </label> -->
<input type="submit" id="submitbutton" value="I Agree & Submit" class="ui-btn clr-btn-green" /> <br/>
<img id="uploadeddob" name="uploadeddob" />
<img id="uploadedot" name="uploadedot" />
</div>
</div>
</form>
</div>
</div>
</div>
</div>
<div data-role="page" id="teammanager" data-url="teammanager">
<div data-role="header" style="overflow:hidden; text-align:center;">
<h1 style="text-align:center;" id="formhead">Update Team Managers</h1>
<div data-role="navbar">
<ul>
<li><a href="index.php#page1">Entries</a></li>
<li><a href="logout.php">Logout <?php echo $_SESSION["username"] ?></a></li>
</ul>
</div><!-- /navbar -->
</div><!-- /header -->
<div data-role="main" class="ui-content">
<?php
$club=$_SESSION["username"];
if($club !="")
{
// echo $club;
?>
<!--content start -->
<script>
$(function(){
//acknowledgement message
var message_status = $("#status");
$("td[contenteditable=true]").blur(function(){
var field_userid = $(this).attr("id") ;
var value = $(this).text() ;
$.post('ajax.php' , field_userid + "=" + value, function(data){
if(data != '')
{
message_status.show();
message_status.text(data);
//hide the message
//setTimeout(function(){message_status.hide()},1000);
}
});
});
$("teammsave").click(function(){
// var field_userid = $(this).attr("id") ;
// var value = $(this).text() ;
// $.post('ajax.php' , field_userid + "=" + value, function(data){
// if(data != '')
// {
// message_status.show();
// message_status.text(data);
//hide the message
// setTimeout(function(){message_status.hide()},3000);
message_status.show();
message_status.text("Saved");
setTimeout(function(){message_status.hide()},3000);
//}
// });
});
jQuery('.s_download').click(function(){
var semail = jQuery("#itzurkarthi_email").val();
if(semail == '')
{
alert('Enter Email');
return false;
}
var str = "sub_email="+semail
jQuery.ajax({
type: "POST",
url: "download.php",
data: str,
cache: false,
success: function(htmld){
jQuery('#down_update').html(htmld);
}
});
});
});
</script>
<style>
table.zebra-style {
font-family:"Lucida Sans Unicode", "Lucida Grande", Sans-Serif;
text-align:left;
border:1px solid #ccc;
margin-bottom:25px;
width:90%
}
table.zebra-style th {
color: #444;
font-size: 13px;
font-weight: normal;
padding: 10px 8px;
}
table.zebra-style td {
color: #777;
padding: 8px;
font-size:13px;
border:1px solid black;
}
table.zebra-style tr.odd {
background:#f2f2f2;
}
.container {
}
#status { padding:10px; background:#88C4FF; color:#000; font-weight:bold; font-size:12px; margin-bottom:10px; display:none; width:90%; }
</style>
<div class="container"><br>
<div id="status"></div>
<table class="table zebra-style">
<thead>
<tr>
<th>#</th>
<th>State / U.T.</th>
<th>Discipline</th>
<th>Age Group</th>
<th>TeamManager</th>
<th>TM's - Phone</th>
<th>LadyTeamManager</th>
<th>LadyTM's - Phone</th>
<th>Coach</th>
<th>Coach's Phone</th>
</tr>
</thead>
<tbody>
<?php
include "config.php";
$team=$club;
$databaseQuery = 'SELECT * FROM `teammagers` WHERE `Team`="'.$con->real_escape_string($team).'"';
$result3 = mysqli_query($con,$databaseQuery) or die('Query failed: ' . mysqli_error());
while($row = mysqli_fetch_array($result3))
{
$ID=trim($row["ID"]);
$team=trim($row["Team"]);
$discipline=trim($row["Discipline"]);
$agegr=trim($row["AgeGroup"]);
$teammanager=trim($row["TeamManager"]);
$tmphone=trim($row["TMPhone"]);
$ladyteammanager=trim($row["LadyTeamManager"]);
$ladytmphone=trim($row["LadyTMPhone"]);
$coach=trim($row["Coach"]);
$coachphone=trim($row["CoachPhone"]);
echo' <tr ><td>1</td><td id="Team:'.$ID.'" contenteditable="false">'.$team.'</td><td id="Discipline:'.$ID.'" contenteditable="false">'.$discipline.'</td><td id="AgeGroup:'.$ID.'" contenteditable="false">'.$agegr.'</td><td id="TeamManager:'.$ID.'" contenteditable="true">'.$teammanager.'</td><td id="TMPhone:'.$ID.'" contenteditable="true">'.$tmphone.'</td><td id="LadyTeamManager:'.$ID.'" contenteditable="true">'.$ladyteammanager.'</td><td id="LadyTMPhone:'.$ID.'" contenteditable="true">'.$ladytmphone.'</td><td id="Coach:'.$ID.'" contenteditable="true">'.$coach.'</td><td id="CoachPhone:'.$ID.'" contenteditable="true">'.$coachphone.'</td> </tr> ';
}
?>
</tbody>
</table>
<br>
<button class="ui-btn" id="teammsave"> SAVE </button>
<br>
<br>
</div>
<!-- content end -->
<?php
}
else
{
//loginbox();
}
?>
</div>
</div>
</body>
</html>