Exemplo n.º 1
0
function proj_get_best()
{
    global $db;
    $query = "SELECT id\n\t\t\t\tFROM (SELECT recog, grade,dateAdded\n\t\t\t\t\t\tFROM (SELECT recog,grade,MAX(A.dateAdded) dateAdded\n\t\t\t\t\t\t\t\tFROM (SELECT name, class, abstract, description\n\t\t\t\t\t\t\t\t\t\t\t\t, AVG(grade) AS grade, recog\n\t\t\t\t\t\t\t\t\t\t\t\t, P.dateAdded\n\t\t\t\t\t\t\t\t\t\tFROM pq_project P \n\t\t\t\t\t\t\t\t\t\tINNER JOIN pq_project_grades PG \n\t\t\t\t\t\t\t\t\t\t\tON P.id = PG.id AND P.status = 1 \n\t\t\t\t\t\t\t\t\t\t\t\tAND PG.status = 1 \n\t\t\t\t\t\t\t\t\t\t\t\tAND P.forJudging = 0\n\t\t\t\t\t\t\t\t\t\tINNER JOIN pq_project_recogs PR \n\t\t\t\t\t\t\t\t\t\t\tON P.id = PR.id\n\t\t\t\t\t\t\t\t\t\tWHERE forJudging = 0\n\t\t\t\t\t\t\t\t\t\tGROUP BY P.id) A\n\t\t\t\t\t\tGROUP BY recog, grade) B NATURAL JOIN \n\t\t\t\t\t\t(SELECT recog,MAX(grade) as grade\n\t\t\t\t\t\t\tFROM (SELECT name, class, abstract, description\n\t\t\t\t\t\t\t\t\t\t\t, AVG(grade) AS grade, recog\n\t\t\t\t\t\t\t\t\t\t\t, P.dateAdded\n\t\t\t\t\t\t\t\t\tFROM pq_project P \n\t\t\t\t\t\t\t\t\tINNER JOIN pq_project_grades PG \n\t\t\t\t\t\t\t\t\t\tON P.id = PG.id AND P.status = 1 \n\t\t\t\t\t\t\t\t\t\t\tAND PG.status = 1\n\t\t\t\t\t\t\t\t\t\t\tAND P.forJudging = 0\n\t\t\t\t\t\t\t\t\tINNER JOIN pq_project_recogs PR \n\t\t\t\t\t\t\t\t\t\tON P.id = PR.id\n\t\t\t\t\t\t\t\t\tWHERE forJudging = 0\n\t\t\t\t\t\t\t\t\tGROUP BY P.id) A\n\t\t\t\t\t\t\tGROUP BY recog)C)A2\n\t\t\t\t\t\tNATURAL JOIN \n\t\t\t\t        (SELECT P.id,AVG(grade) AS grade, recog, P.dateAdded\n\t\t\t\t\t\t\t\tFROM pq_project P \n\t\t\t\t\t\t\t\tINNER JOIN pq_project_grades PG \n\t\t\t\t\t\t\t\t\tON P.id = PG.id AND P.status = 1 \n\t\t\t\t\t\t\t\t\t\tAND PG.status = 1\n\t\t\t\t\t\t\t\t\t\tAND P.forJudging = 0\n\t\t\t\t\t\t\t\tINNER JOIN pq_project_recogs PR \n\t\t\t\t\t\t\t\t\tON P.id = PR.id\n\t\t\t\t\t\t\t\tWHERE forJudging = 0\n\t\t\t\t\t\t\t\tGROUP BY P.id)B\n\t\t\t\tORDER BY B.grade DESC";
    $res = $db->query("SELECT", $query);
    if ($res['status']) {
        $projects = array();
        foreach ($res['data'] as $project) {
            $projects[] = proj_get($project['id']);
        }
        return $projects;
    } else {
        return false;
    }
}
Exemplo n.º 2
0
<?php

/**
 * Developed and designed by: Laurenz T.
 * email me @: laurenz@outlook.ph
 * COLLEGE OF COMPUTER STUDIES
 * COMPUTER SCIENCE - SOFTWARE TECHNOLOGY
 * "Ang pusong nabiyak, madalas naninindak" #uselessQuotesNgBagongTaon #2016
 */
require_once "includes/project-functions.php";
if (!isset($_GET['id'])) {
    header("Location: ./");
}
$project = proj_get($_GET['id']);
?>
<html>
    <head>
        <title>Quiver | Sample </title>
        <!-- Google icons -->        
        <link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet"/>                
        <!-- Fonts up up and away -->
        <link type="text/css" rel="stylesheet" href="css/fontpack.css"/>
        <!-- Materialize CSS Import -->
        <link type="text/css" rel="stylesheet" href="css/materialize.css"  media="screen,projection"/>	      
        <!-- Custom Stylesheet -->
        <link type="text/css" rel="stylesheet" href="css/styles-2.css"/>  
        <!-- 
            PLEASE UPDATE THE FAVICON FFS
        -->
        <link rel="icon" type="image/png" href="assets/img/hack2015-favicon.png">
        <!--