results.show.php

Go to the documentation of this file.

<?php
/*
 * backend.php
 * 
 * Copyright 2012 Johannes <jojo@jojo-42>
 * 
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU General Public License for more details.
 * 
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,
 * MA 02110-1301, USA.
 * 
 * 
 */
require_once("../config.php");
require_once("../inc/user.class.php");
require_once("../inc/tools.php");
require_once("../inc/check_login.php");
check_login();

require_once("../inc/db.class.php");
require_once("../inc/config.class.php");

require_once("../inc/poll.class.php");
require_once("../inc/messages.class.php");
require_once("../inc/html.class.php");
require_once("../inc/chart.class.php");
$db= new db( DB_USER, DB_PASS, DB_DATABASE, DB_HOST );
$config = new config($db);
$config->load();
make_session();


function make_url($sort,$order){
        $qarr = explode("&",$_SERVER['QUERY_STRING']);
        $qarr_n = array();
        $sort_passed = false;
        $order_passed = false;
        // go through query string 
        foreach(  $qarr as $q ){
                if( (substr($q,0,5) == "sort=") ){
                        if( ($sort_passed === false) ){
                                $qarr_n[] = "sort=$sort";
                                $sort_passed = true;    
                        }else{
                                // ignore duplicates
                        }               
                
                }else if(  ($q == "asc") OR ($q == "desc")  ){
                        if( ($order_passed === false)  ){
                                $qarr_n[] = "$order";
                                $order_passed = true;   
                        }else{
                                // ignore duplicates                            
                        }
                }else{
                        // copy other
                        $qarr_n[] = "$q";                       
                }               
        }
        
        $url = $_SERVER[ 'SCRIPT_NAME' ]."?";
        $url .= implode("&",$qarr_n);
        // if missing
        if( strpos($url,"sort") === false ){
                $url .= "&sort=$sort";
        }
        if( (strpos($url,"asc") === false) AND (strpos($url,"desc") === false) ){
                $url .= "&$order";                      
        }

        return $url;
}


function make_table($db,$poll,$editable=false){
        if( isset($_GET["sort"]) ){
                $sort = $_GET["sort"];
        }else{
                $sort = "";
        }
        if( isset($_GET["asc"]) ){
                $order = "asc";
        }else if( isset($_GET["desc"]) ){
                $order = "desc";
        }else{
                $order = "asc";
        }
        
        $order2 = "";
        if( $order == "desc" ){
                $order2 = "asc";
        }else if( $order == "asc" ){
                $order2="desc";
        }
        //$order_icons = array( "asc" => "" , "desc" => "" , "ascdesc" => "");
        $order_icons = array( 
                "asc" => "<img src='".APP_ROOT."/icons/16/sort-down.png' alt='' style='vertical-align:middle'/>" , 
                "desc" => "<img src='".APP_ROOT."/icons/16/sort-up.png' alt='' style='vertical-align:middle'/>" , 
                "ascdesc" => "");

        $res = $db->export_result($poll->ID,$sort,$order);
        if( sizeof($res) > 0 ){
                echo "<table class='result_table'>";
                echo "<tr>";
                if($editable){
                        echo "<th></th>";
                }

                foreach( array_keys($res[0]) as $name ){
                        if( ($sort == $name) ){
                                $url = make_url($name,$order2);
                                $icon = $order_icons[$order2];
                                $css = "sorted";
                        }else{
                                $url = make_url($name,"asc");
                                $icon = "";//$order_icons["asc"];
                                $css = "";
                        }

                        if( ! in_array($name, array("user","name","group","Datum") ) ){
                                $wid = $poll->get_widget_by_name($name);
                                if( isset($wid) ){
                                        echo "<th class='$css'> <a href='$url'>$icon {$wid->dispName}"; 
                                        if( $poll->type == POLLTYPE_ADVANCED ){
                                                echo "<br/> <span style='font-size:80%;font-variant:italic'>({$name})</span>";  
                                        }
                                        echo "</a> </th>";
                                }else{
                                        echo "<th class='$css'> <a href='$url'>$icon {$name}</a> </th>";                                        
                                }
                        }else{
                                // other columns
                                echo "<th class='$css'> <a href='$url'>$icon {$name}</a> </th>";
                        }
                }               
                echo "</tr>";

                $c = 0;         
                // go through all results
                foreach( $res as $row ){
                        $evenodd = $c %2;
                        echo "<tr class='line$evenodd'>";
                        if($editable){
                                echo "<td> <input type='checkbox' name='selection[{$row["user"]}]'/> </td>";
                        }
                        // make collums per row
                        foreach( array_keys($row) as $name){    
                                $hh = htmlspecialchars($row[$name],ENT_QUOTES,"UTF-8",true);
                                echo "<td>{$hh}</td>";                                  
                        }
                        echo "</tr>";
                        ++$c;
                }
                echo "</table>";
        }
        
}

$edit = "";
// SET VARS 
if (    (isset($_GET["pollID"])) AND 
                (is_numeric($_GET["pollID"])) AND 
                ($_GET["pollID"] != "")
  )
{
        $poll = new poll();
        if (!$poll->load_from_id($db, intval($_GET["pollID"]) )  ){
                die("Umfrage existiert nicht.");
        }

}else{
        header("Location: index.php");
        exit();
}


if(             (intval($_SESSION["user"]->ID) !== intval($poll->owner) ) AND 
                ( !in_array("{$_SESSION["user"]->ID}",explode(",",SUPER_ADMIN) ))       ){
        die("Umfrage Bearbeiten nicht erlaubt.");
}




// CSV export
$db->garbage_collect_result_table($poll);
if( isset($_GET["view_csv"]) ){
        $poll->handle_export_edit($db,false);           
        exit();
}else if (isset($_GET["dl_csv"])){
        $poll->handle_export_edit($db,true);
        exit();
// HTML         
}else if(isset($_GET["view_html"]) ){
                $edit = "show html results";            
}else if(isset($_GET["edit_html"]) ){
                $edit = "edit html results";    
// STATS        
}else if( isset($_GET["view_count"]) ){
                $edit = "show count";
}else if( isset($_GET["view_charts"]) ){
        $edit = "show charts";
}       
        
$status_human_readable = array( STATUS_INCOMPLETE=>"Unfollständig konfiguriert", 
                                                                STATUS_NORMAL=>"Normal",        
                                                                STATUS_USER_DEACTIVATED=>"Deaktiviert", 
                                                                STATUS_DELETED=>"Gelöscht",    
                                                                STATUS_TEMPLATE=>"Vorlage",
                                                                STATUS_SHARED_TEMPLATE=>"Vorlage geteilt");
$polltype_human_readable = array(POLLTYPE_SIMPLE=>"Einfache Konfiguration",POLLTYPE_ADVANCED=>"Erweiterte Konfiguration");      
        
HTML::doctype();
if( ($edit == "show html results") OR ($edit == "edit html results") ){
                echo '
                        <head>
                                <title>Umfrage</title>
                                <meta http-equiv="content-type" content="text/html;charset=utf-8" />
                                <meta name="generator" content="Geany 0.21" />
                                <link rel="icon" type="image/png" href="../icons/32/dialog-apply.png">                          
                                <link href="../JS/jquery/css/smoothness/jquery-ui-1.10.0.custom" rel="stylesheet">
                                <script src="../JS/jquery/jquery-1.9.0.js"></script>
                                <script src="../JS/jquery/jquery-ui-1.10.0.custom.js"></script>
                                <link href="'.APP_ROOT.'/CSS/style.css" rel="stylesheet" type="text/css">
                                <link href="'.APP_ROOT.'/CSS/menu_nav.css" rel="stylesheet" type="text/css">
                                <link href="'.APP_ROOT.'/CSS/backend.css" rel="stylesheet" type="text/css">
                                <link href="'.APP_ROOT.'/CSS/messages.css" rel="stylesheet" type="text/css">
                        </head>
                        <body>
                        <div class="content" style="width:80% !important" >
                ';
}else{
        HTML::head("",1);
}

HTML::menu();
if( ($edit == "show html results") OR ($edit == "edit html results") ){
        $timeout = $poll->get_timeout_string();
        if($poll->anonymous == true){
                $anon = "Anonym";
        }else{
                $anon = "Nicht anonym";         
        }
        if( $poll->is_public === true){
                $anon = "Öffentlich";
        }
        echo "<table class='table_2' style='width:500px'>";
        echo "<tr> <th>Eigenschaft</th> <th>Wert</th></tr>";
        echo "<tr> <td>Name</td> <td>{$poll->name}</td></tr>";
        echo "<tr> <td>Typ</td> <td>{$polltype_human_readable[$poll->type]}</td></tr>";
        echo "<tr> <td>aktueller Status</td> <td>{$status_human_readable[$poll->status]}</td></tr>";
        echo "<tr> <td>Endet am</td> <td>$timeout</td></tr>";
        echo "<tr> <td>Anonymität</td> <td>$anon</td></tr>";
        echo "</table>";
        echo "<p><a href='edit.php?pollID={$poll->ID}'>zurück</a> zu den Umfrageeinstellungen</p>";
}

// HTML
if($edit == "show html results"){
        echo "<div style='width:100%;height:600px;overflow:scroll'>";
        make_table($db,$poll,false);
        echo "</div>";

}else if($edit == "edit html results"){

        echo "<form action='results.show.handle.php' method='POST'>";
        echo "<div style='width:100%;height:600px;overflow:scroll'>";
        make_table($db,$poll,true);
        echo "</div>";
        echo "<input type='hidden' name='pollID' value='{$poll->ID}'/>";

        echo "<br/>";
        if($poll->anonymous == false){
                echo "<span style='margin-left:2em'>&nbsp;</span>ausgewählte Elemente <input type='submit' name='save_results' value='Löschen'/>";
                echo "<span style='margin-left:2em'>&nbsp;</span>Auswahl <input type='reset'  value='Zurücksetzen'/>";
        }
        echo "<span style='margin-left:2em'>&nbsp;</span><b>alles</b> <input type='submit' name='rm_all' value='Löschen'/>";
        echo "</form>";

// COUNT
}else if ($edit == "show count"){
        $poll->load_widget_result_count($db);
        echo "<ul>";
        foreach($poll->widget_list as $widget){
                if( $widget instanceof container ){
                        echo "<li>{$widget->dispName} <span style='color:red'>{$widget->get_data("count")}</span>";
                        echo "<ul>";
                        if( $widget instanceof matrix ){
                                foreach($widget->widget_list as $question){
                                        echo "<li>{$question->dispName}";
                                        echo "<ul>";
                                        foreach( $widget->option_list as $opt){
                                                echo "<li>{$opt->value} <span style='color:red'>{$question->get_data('count_'.$opt->ID)}</span></li>";
                                        }
                                        echo "</ul></li>";
                                }                               

                        }else{
                                foreach($widget->option_list as $option){
                                        echo "<li>{$option->dispName} <span style='color:red'>{$option->get_data("count")}</span></li>";
                                }
                        }
                        echo "</ul></li>";
                }else if($widget instanceof checkBoxSingle){
                        $true = $widget->get_config("true"); $false = $widget->get_config("false");
                        echo "<li>{$widget->dispName} - $true <span style='color:red'>{$widget->get_data("count_true")}</span></li>";
                        echo "<li>{$widget->dispName} - $false <span style='color:red'>{$widget->get_data("count_false")}</span></li>";
                }else{
                        echo "<li>{$widget->dispName} <span style='color:red'>{$widget->get_data("count")}</span></li>";
                }
        }       
        echo "</ul>";

// CHARTS
}else if ($edit == "show charts"){
        echo "<p><a href='edit.php?pollID={$poll->ID}'>zurück</a> zu den Umfrageeinstellungen</p>";
        $poll->load_widget_result_count($db);
        echo '<script src="../JS/Chart.js"></script>';
        foreach( $poll->widget_list as $widget ){
                if( $widget instanceof chartable_widget ){
                        $widget->chart_display();
                }
        }
}

echo "<p><a href='edit.php?pollID={$poll->ID}'>zurück</a> zu den Umfrageeinstellungen</p>";

HTML::foot();   

?>