</tr>
<tr>
<td>
Date To
</td>
<td>
<input class="datepicker" required="true" id="dateto" name="dateto" />
</td>
</tr>
<tr>
<td>
Event
</td>
<td>
<?php
createCombo("eventid", "id", "name", "{$_SESSION['DB_PREFIX']}event", "", false);
?>
</td>
</tr>
<tr>
<td>
</td>
<td>
<a class="link1" href="javascript: runreport();"><em><b>Run Report</b></em></a>
</td>
</tr>
</table>
</form>
</div>
?>
</td>
</tr>
<tr valign="center">
<td>Client</td>
<td colspan=2>
<?php
createCombo("clientid", "id", "name", "{$_SESSION['DB_PREFIX']}customerclient", "", true);
?>
</td>
</tr>
<tr valign="center">
<td>Site</td>
<td colspan=2>
<?php
createCombo("siteid", "id", "name", "{$_SESSION['DB_PREFIX']}customerclientsite", "", true);
?>
</td>
</tr>
<tr valign="center">
<td> </td>
<td>
<div>Invoice Address</div>
<textarea readonly id="invoiceaddress" name="invoiceaddress" cols="50" rows="6"></textarea>
</td>
<td>
<div>Delivery Address</div>
<textarea readonly id="deliveryaddress" name="deliveryaddress" cols="50" rows="6"></textarea>
</td>
</tr>
<tr valign="center">
public function createFilterScreen()
{
?>
<iframe style="display:none" id="submitframe" name="submitframe">
</iframe>
<div class="modal" id="filtersavedialog">
<label>Filter name</label>
<input type="text" id="filtername" name="filtername" size=60 />
</div>
<div class="modal" id="filterdialog">
<div id="filterpanel">
<?php
$filterformaction = $_SERVER['PHP_SELF'] . "?filtering=true";
foreach ($_GET as $key => $value) {
if (strpos($key, "filtering") != 0 && strpos($key, "filter_") != 0) {
$filterformaction .= "&" . $key . "=" . $value;
}
}
?>
<form id="filterform" method="POST" enctype="multipart/form-data" action="<?php
echo $filterformaction;
?>
" >
<input type="hidden" id="triggerrefresh" name="triggerrefresh" value="" />
<input type="hidden" id="crudcmd" name="crudcmd" value="" />
<input type="hidden" id="savefiltername" name="savefiltername" value="" />
<table width='100%' cellpadding=0 cellspacing=4>
<?php
foreach ($this->columns as $col) {
if ($col['filter']) {
if ($col['type'] == "DERIVED" || $col['type'] == "PASSWORD" || $col['type'] == "IMAGE" || $col['type'] == "BASICTEXTAREA" || $col['type'] == "TEXTAREA" || $col['hidden'] == true) {
continue;
}
echo "<tr valign=center>\n";
echo "<td valign=center nowrap>" . $col['label'] . "</td>\n";
echo "<td nowrap>";
$filterValue = "";
if (isset($_GET['filter_' . $col['name']])) {
$filterValue = base64_decode($_GET['filter_' . $col['name']]);
}
if (isset($_POST['filter_' . $col['name']])) {
$filterValue = $_POST['filter_' . $col['name']];
}
if ($col['type'] == "TEXTBOX") {
if ($col['datatype'] == "timestamp" || $col['datatype'] == "datetime") {
echo "<input class='datepicker' type='text' id='filter_" . $col['name'] . "' name='filter_" . $col['name'] . "' value='{$filterValue}' />\n";
} else {
if ($col['datatype'] == "date") {
echo "<input class='datepicker' type='text' id='filter_" . $col['name'] . "' name='filter_" . $col['name'] . "' value='{$filterValue}' />\n";
} else {
if ($col['datatype'] == "time") {
echo "<input class='timepicker' type='text' id='filter_" . $col['name'] . "' name='filter_" . $col['name'] . "' value='{$filterValue}' />\n";
} else {
if ($col['datatype'] == "contact") {
createContactCombo("filter_" . $col['name']);
} else {
if ($col['datatype'] == "typist") {
createTypistCombo("filter_" . $col['name']);
} else {
if ($col['datatype'] == "user") {
createUserCombo("filter_" . $col['name']);
} else {
echo "<input type='text' style='width:" . $col['length'] * 6 . "px' id='filter_" . $col['name'] . "' name='filter_" . $col['name'] . "' value='{$filterValue}' />\n";
}
}
}
}
}
}
} else {
if ($col['type'] == "GEOLOCATION") {
echo "<input type='text' style='width:" . $col['length'] * 6 . "px' id='filter_" . $col['name'] . "' name='filter_" . $col['name'] . "' value='{$filterValue}' />\n";
} else {
if ($col['type'] == "CHECKBOX") {
echo "<input type='checkbox' id='filter_" . $col['name'] . "' name='filter_" . $col['name'] . "' value='{$filterValue}' />\n";
} else {
if ($col['type'] == "BASICTEXTAREA") {
echo "<div style='width:600px; height: 150px; overflow:auto' id='filter_" . $col['name'] . "' name='filter_" . $col['name'] . "'>{$filterValue}</div>\n";
} else {
if ($col['type'] == "TEXTAREA") {
echo "<div style='width:400px; height: 150px; overflow:auto' id='filter_" . $col['name'] . "' name='filter_" . $col['name'] . "'>{$filterValue}</div>\n";
} else {
if ($col['type'] == "DATACOMBO") {
createCombo("filter_" . $col['name'], $col['table_id'], $col['table_name'], $_SESSION['DB_PREFIX'] . $col['table'], $col['where']);
} else {
if ($col['type'] == "LAZYDATACOMBO") {
createLazyCombo("filter_" . $col['name'], $col['table_id'], $col['table_name'], $_SESSION['DB_PREFIX'] . $col['table'], $col['where'], false, $col['length']);
} else {
if ($col['type'] == "MULTIDATACOMBO") {
createCombo("filter_" . $col['name'], $col['table_id'], $col['table_name'], $_SESSION['DB_PREFIX'] . $col['table']);
} else {
if ($col['type'] == "COMBO") {
echo "<SELECT id='filter_" . $col['name'] . "' name='filter_" . $col['name'] . "'>\n";
echo "<OPTION value=''></OPTION>\n";
foreach ($col['options'] as $opt) {
echo "<OPTION value='" . $opt['value'] . "'>" . $opt['text'] . "</OPTION>\n";
}
echo "</SELECT>";
}
}
}
}
}
}
}
}
}
echo " " . $col['suffix'];
echo "</td>";
echo "</tr>\n";
}
}
?>
</table>
</form>
</div>
</div>
<?php
}
<td><input required="true" name="lname" type="text" class="textfield" id="lname" /></td>
</tr>
<tr>
<td>Account Type </td>
<td>
<SELECT id="accounttype" name="accounttype" onchange="accounttype_onchange()">
<OPTION value="ADMIN">Administration</OPTION>
<OPTION value="CLIENT">Client</OPTION>
</SELECT>
</td>
</tr>
<tr id="clienttype" style="display:none">
<td>Client</td>
<td>
<?php
createCombo("customerid", "id", "name", "{$_SESSION['DB_PREFIX']}customer", "", false);
?>
</td>
</tr>
<tr>
<td>Login</td>
<td><input required="true" name="login" type="text" class="textfield logintext" id="login" /></td>
</tr>
<tr>
<td>Email</td>
<td><input required="true" name="email" type="text" class="textfield60" id="email" /></td>
</tr>
<tr>
<td>Confirm Email</td>
<td><input required="true" name="confirmemail" type="text" class="textfield60" id="confirmemail" /></td>
</tr>
<?php
include "system-header.php";
?>
<h4>Referee Average Report</h4>
<form method="POST" action="refereereportlib.php" class="entryform" target="_new">
<table cellspacing=10>
<tr>
<td>
Referee
</td>
<td>
<?php
createCombo("refereeid", "id", "name", "{$_SESSION['DB_PREFIX']}referee");
?>
</td>
</tr>
<tr>
<td>
From Date
</td>
<td>
<input type="text" class="datepicker" id="fromdate" name="fromdate" />
</td>
</tr>
<tr>
<td>
To Date
</td>
<td>
<input type="text" class="datepicker" id="todate" name="todate" />
<td>
Client
</td>
<td>
<?php
createCombo("clientid", "id", "name", "{$_SESSION['DB_PREFIX']}client");
?>
</td>
</tr>
<tr>
<td>
Cleaner
</td>
<td>
<?php
createCombo("memberid", "member_id", "fullname", "{$_SESSION['DB_PREFIX']}members");
?>
</td>
</tr>
<tr>
<td>
Date
</td>
<td>
<input class="datepicker" type="text" id="entrydate" />
</td>
</tr>
<tr>
<td>
Start Time
</td>
<?php
require_once "system-embeddedheader.php";
$customerid = getLoggedOnCustomerID();
?>
<form action="system-client-exec.php" method="post" id="loginForm">
<br>
<div><label>Client</label></div>
<br>
<?php
createCombo("clientid", "id", "name", "{$_SESSION['DB_PREFIX']}customerclient", "WHERE customerid = {$customerid}");
?>
<br>
<br>
<div><label>Site</label></div>
<br>
<SELECT id="siteid" name="siteid" style="width:200px">
<OPTION value=""></OPTION>
</SELECT>
<br>
<br>
<input type="submit" value="Confirm"></input>
</form>
<script>
$(document).ready(
function() {
$("#clientid").change(
function() {
$.ajax({
url: "createclientsitecombo.php",
<table width='75%' cellspacing=5>
<tr>
<td>Date of Match</td>
<td>
<input type="text" class="datepicker" id="matchdate" name="matchdate" value="<?php
if (isset($_POST['matchdate'])) {
echo $_POST['matchdate'];
}
?>
" />
</td>
<td>Age Group</td>
<td>
<?php
createCombo("agegroupid", "id", "name", "{$_SESSION['DB_PREFIX']}teamagegroup", "WHERE teamid = " . getLoggedOnTeamID(), true);
?>
</td>
</tr>
<tr>
<td>League / Cup</td>
<td>
<SELECT id="leaguecup" name="leaguecup">
<OPTION value="L">League</OPTION>
<OPTION value="C">Challenge Cup</OPTION>
<OPTION value="T">Challenge Trophy</OPTION>
</SELECT>
</td>
<td>Division</td>
<td>
<SELECT id="division" name="division">
</SELECT>
</td>
</tr>
<tr id="clienttype" style="display:none">
<td>Team</td>
<td>
<?php
createCombo("teamid", "id", "name", "{$_SESSION['DB_PREFIX']}teamagegroup", "WHERE teamid = " . getLoggedOnClubID(), false);
?>
</td>
</tr>
<tr id="sectype" style="display:none">
<td>Club</td>
<td>
<?php
createCombo("clubid", "id", "name", "{$_SESSION['DB_PREFIX']}team", "", false);
?>
</td>
</tr>
<tr>
<td>User Name</td>
<td><input required="true" name="login" type="text" class="textfield logintext" id="login" /></td>
</tr>
<tr>
<td>Telephone</td>
<td><input name="telephone" type="text" class="textfield" id="telephone" /></td>
</tr>
<tr>
<td>Email</td>
<td><input required="true" name="email" type="text" class="textfield60" id="email" /></td>
</tr>