echo "</select>"; echo "</div>"; echo "</div>"; echo FormBuilder::createFormGroup($i18n, "message_id", array("type" => "foreign_key", "jointable" => "spiel_text", "entity" => "matchtext", "labelcolumns" => "aktion,nachricht"), "", "match_manage_reportmsg_"); echo FormBuilder::createFormGroup($i18n, "playernames", array("type" => "text"), "", "match_manage_reportmsg_"); echo FormBuilder::createFormGroup($i18n, "minute", array("type" => "number"), "", "match_manage_reportmsg_"); echo FormBuilder::createFormGroup($i18n, "intermediateresult", array("type" => "text"), "", "match_manage_reportmsg_"); echo "</fieldset>"; echo "<div class=\"form-actions\">"; echo "<button type=\"submit\" class=\"btn btn-primary\">" . $i18n->getMessage("button_save") . "</button>"; echo "</div></form>"; // ******** list items $reportItems = MatchesDataService::getMatchReportMessages($website, $db, $i18n, $matchId); // no items if (!count($reportItems)) { echo createInfoMessage("", $i18n->getMessage("match_manage_reportitems_noitems")); // list items } else { echo "<table class=\"table table-bordered table-striped table-hover\">"; echo "<thead>"; echo "<tr>"; echo "<th>" . $i18n->getMessage("match_manage_reportmsg_minute") . "</th>"; echo "<th>" . $i18n->getMessage("entity_matchtext_aktion") . "</th>"; echo "<th>" . $i18n->getMessage("entity_matchtext_nachricht") . "</th>"; echo "<th>" . $i18n->getMessage("match_manage_reportmsg_playernames") . "</th>"; echo "<th>" . $i18n->getMessage("match_manage_reportmsg_intermediateresult") . "</th>"; echo "</tr>"; echo "</thead>"; echo "<tbody>"; $homeTeam = escapeOutput($match["match_home_name"]); $guestTeam = escapeOutput($match["match_guest_name"]);
foreach ($teamPrefixes as $teamPrefix) { echo "<h2><a href=\"" . $website->getInternalUrl("team", "id=" . $match["match_" . $teamPrefix . "_id"]) . "\" target=\"_blank\">" . escapeOutput($match["match_" . $teamPrefix . "_name"]) . "</a></h2>"; // tactic echo "<div class=\"form-horizontal\">"; echo FormBuilder::createFormGroup($i18n, $teamPrefix . "_offensive", array("type" => "number", "value" => $match["match_" . $teamPrefix . "_offensive"]), $match["match_" . $teamPrefix . "_offensive"], "formation_"); echo FormBuilder::createFormGroup($i18n, $teamPrefix . "_longpasses", array("type" => "boolean", "value" => $match["match_" . $teamPrefix . "_longpasses"]), $match["match_" . $teamPrefix . "_longpasses"], "formation_"); echo FormBuilder::createFormGroup($i18n, $teamPrefix . "_counterattacks", array("type" => "boolean", "value" => $match["match_" . $teamPrefix . "_counterattacks"]), $match["match_" . $teamPrefix . "_counterattacks"], "formation_"); echo "</div>"; // get existing players $playerTable = $website->getConfig("db_prefix") . "_spiel_berechnung SB"; $playerTable .= " INNER JOIN " . $website->getConfig("db_prefix") . "_spieler S ON S.id = SB.spieler_id"; $result = $db->querySelect("SB.*", $playerTable, "spiel_id = %d AND team_id = %d ORDER BY feld ASC, field(SB.position_main, 'T', 'LV', 'IV', 'RV', 'DM', 'LM', 'ZM', 'RM', 'OM', 'LS', 'MS', 'RS')", array($matchId, $match["match_" . $teamPrefix . "_id"])); $playersCount = $result->num_rows; // no player records if (!$playersCount) { echo createInfoMessage("", $i18n->getMessage("match_manage_playerstatistics_noitems")); // check if any formation is available $fresult = $db->querySelect("COUNT(*) AS hits", $website->getConfig("db_prefix") . "_aufstellung", "verein_id = %d", $match["match_" . $teamPrefix . "_id"]); $formationCount = $fresult->fetch_array(); $fresult->free(); if ($formationCount && $formationCount["hits"]) { echo "<p><a href=\"?site={$site}&match={$matchId}&team={$teamPrefix}&action=generate\" class=\"btn\"><i class=\"icon-hand-right\"></i> " . $i18n->getMessage("match_manage_playerstatistics_createfromfrmation") . "</a></p>"; } else { echo "<p><i class=\"icon-warning-sign\"></i> " . $i18n->getMessage("match_manage_playerstatistics_noformationavailable") . "</p>"; } // list player records } else { $players = array(); echo "<table class=\"table table-bordered table-striped table-hover\">"; echo "<thead>"; echo "<tr>";
if (!empty($_POST['lastlogindays'])) { $whereCondition .= ' OR U.lastonline < %d'; $parameters[] = $website->getNowAsTimestamp() - $_POST['lastlogindays'] * 24 * 3600; } if (!empty($_POST['maxplayers'])) { $whereCondition .= ' OR (SELECT COUNT(*) FROM ' . $website->getConfig('db_prefix') . '_spieler AS PlayerTab WHERE PlayerTab.verein_id = C.id AND status = \'1\') < %d'; $parameters[] = $_POST['maxplayers']; } if (!empty($_POST['userid']) && $_POST['userid']) { $whereCondition .= ' OR U.id = %d'; $parameters[] = $_POST['userid']; } $whereCondition .= ')'; $result = $db->querySelect($columns, $fromTable, $whereCondition, $parameters, 50); if (!$result->num_rows) { echo createInfoMessage($i18n->getMessage('firemanagers_search_nohits'), ''); } else { ?> <form action='<?php echo $_SERVER['PHP_SELF']; ?> ' method='post' class='form-horizontal' id='frmMain' name='frmMain'> <input type='hidden' name='site' value='<?php echo $site; ?> '> <input type='hidden' name='show' value='selectoptions'> <table class='table table-striped table-hover'> <thead> <tr> <th></th>
$wherePart = "1=1"; $parameters = array(); foreach ($filterFields as $filterFieldId => $filterFieldInfo) { if (strlen(trim($filterFieldInfo["value"]))) { $searchValue = strtoupper(trim($filterFieldInfo["value"])); $wherePart .= " AND UCASE(" . $filterFieldInfo["field"] . ") LIKE '%%%s%%'"; $parameters[] = $searchValue; } } // count records $columns = "COUNT(*) AS hits"; $result = $db->querySelect($columns, $fromTable, $wherePart, $parameters); $rows = $result->fetch_array(); $result->free(); if (!$rows['hits']) { echo createInfoMessage($i18n->getMessage("manage_no_records_found"), ""); } else { // enable pagination $seite = isset($_REQUEST[PARAM_PAGE]) ? (int) $_REQUEST[PARAM_PAGE] : 1; $eps = 20; if ($rows['hits'] % $eps) { $seiten = floor($rows['hits'] / $eps) + 1; } else { $seiten = $rows['hits'] / $eps; } $start = ($seite - 1) * $eps; $firstNo = $start + 1; $lastNo = min($start + $eps, $rows['hits']); echo "<p>" . sprintf($i18n->getMessage("manage_number_of_records"), $rows['hits'], $firstNo, $lastNo) . "</p>"; // ordering if ($sortColumn) {