Esempio n. 1
0
$ord = "DESC";
if ($sortOrder == 'CountryCode' || $sortOrder == 'intName') {
    $ord = "ASC";
}
$sortOrderFinal = $sortOrder;
$filter_clause = $_SESSION["filter_clause"];
$where_clause .= $filter_clause;
//-----------------------------------------------------------------------------------------------------------
$query = "SELECT {$clubsTable}.*  , count({$clubsPilotsTable}.pilotID)  as pilotsCount\n\tFROM {$clubsPilotsTable},{$clubsTable}  \n\tWHERE {$clubsPilotsTable}.clubID={$clubsTable}.ID  \n" . $where_clause . " GROUP BY {$clubsTable}.ID ORDER BY {$sortOrderFinal} " . $ord . " ";
// echo $query;
$res = $db->sql_query($query);
if ($res <= 0) {
    echo "no takeoffs found <br>";
    return;
}
listTakeoffs($res, $legend, $query_str, $sortOrder);
function printHeaderTakeoffs($width, $headerSelectedBgColor, $headerUnselectedBgColor, $sortOrder, $fieldName, $fieldDesc, $query_str)
{
    global $moduleRelPath;
    global $Theme;
    if ($width == 0) {
        $widthStr = "";
    } else {
        $widthStr = "width='" . $width . "'";
    }
    if ($sortOrder == $fieldName) {
        echo "<td {$widthStr} bgcolor='{$headerSelectedBgColor}'>\n\t\t<div class='whiteLetter' align=left>\n\t\t<a href='" . CONF_MODULE_ARG . "&op=list_takeoffs&sortOrder={$fieldName}{$query_str}'>{$fieldDesc}<img src='{$moduleRelPath}/img/icon_arrow_down.png' border=0  width=10 height=10></div></td>";
    } else {
        echo "<td {$widthStr} bgcolor='{$headerUnselectedBgColor}'>\n\t\t<div align=left>\n\t\t<a href='" . CONF_MODULE_ARG . "&op=list_takeoffs&sortOrder={$fieldName}{$query_str}'>{$fieldDesc}</div></td>";
    }
}
Esempio n. 2
0
$where_clause .= $where_clause_country;
//-----------------------------------------------------------------------------------------------------------
$query = "SELECT DISTINCT takeoffID, name, intName, " . $waypointsTable . ".countryCode, count(*) as FlightsNum, max(LINEAR_DISTANCE) as max_distance \n  \t\t\tFROM {$flightsTable},{$waypointsTable} {$extra_table_str}\n  \t\t\tWHERE {$flightsTable}.takeoffID={$waypointsTable}.ID  \n\t\t\tAND {$flightsTable}.userID<>0 " . $where_clause . " \n\t\t\tGROUP BY takeoffID ORDER BY {$sortOrderFinal} " . $ord . ",max_distance DESC";
// echo $query;
$res = $db->sql_query($query);
if ($res <= 0) {
    echo "no takeoffs found<br>";
    return;
}
$legendRight = "";
if (0) {
    echo "<div class='tableTitle shadowBox'>\n   <div class='titleDiv'>{$legend}</div>\n   <div class='pagesDiv'>{$legendRight}</div>\n   </div>";
}
require_once dirname(__FILE__) . "/MENU_second_menu.php";
echo "<div class='list_header'>\n\t\t\t\t<div class='list_header_r'></div>\n\t\t\t\t<div class='list_header_l'></div>\n\t\t\t\t<h1>{$legend}</h1>\n\t\t\t\t<div class='pagesDiv'>{$legendRight}</div>\n\t\t\t</div>";
listTakeoffs($res, $legend, $queryExtraArray, $sortOrder);
?>
<script type="text/javascript" src="<?php 
echo $moduleRelPath;
?>
/js/tipster.js"></script>
<?php 
echo makeTakeoffPopup();
function printHeaderTakeoffs($width, $sortOrder, $fieldName, $fieldDesc, $queryExtraArray)
{
    global $moduleRelPath, $Theme;
    if ($width == 0) {
        $widthStr = "";
    } else {
        $widthStr = "width='" . $width . "'";
    }