PHPGrid Footer

<?php
#*********************************************************************
# name:      E01_GUeb_Auftritt_Titel.php
#*********************************************************************
# parameter: 1
# - EreignisNr
#*********************************************************************
# erstellt am
#          19.02.2016 durch Gerd Huber
#
# TODO 4 -o Owner -c Category: gerd
// TODO 4 -o Owner -c Category:gerd Task:Aktuelle Filme aus youtube ermitteln
#*********************************************************************

# ----------------------
# DB-Verbindung herstellen
# ----------------------
include_once ("./includes/db_connect.php");
include_once ("./includes/functions.php");
# ----------------------
# sichere Funktion um eine PHP-Sitzung zu starten
# ----------------------
sec_session_start();

header('content-type: text/html; charset=utf-8');
#error_reporting(0);

# -------------------------------
# notwendige include-dateien
# -------------------------------
include ("../includes/tools.php");

# -------------------------------
# login erfolgt
# -------------------------------
if (!($_SERVER['REMOTE_ADDR'] == "127.0.0.1" or $_SERVER['REMOTE_ADDR'] == "0:0:0:0:0:0:0:1") )
{
    if(!login_check($db) == true)
    {
        header("Location: hhclogin.php");
        exit;
    }
}

# -------------------------------
# Grundwerte
# -------------------------------
$_SESSION["pfad"] = "../../";
$_SESSION["show_pageup"] = false;
$Form_name = "E01_GUeb_Auftritt_Titel";
$path_to_script = "";

/*-------------------------*/
/* Zur Datenbank verbinden */
/*-------------------------*/
//$db=connect_mysqli_database();

$_GET["ID_HHCBilder01_Abteilung"] = (!isset($_GET["ID_HHCBilder01_Abteilung"]) || $_GET["ID_HHCBilder01_Abteilung"] == 0 || empty($_GET["ID_HHCBilder01_Abteilung"])) ? 360 : $_GET["ID_HHCBilder01_Abteilung"];
$_GET["FK_HHCBilder01"] = (!isset($_GET["FK_HHCBilder01"]) || $_GET["FK_HHCBilder01"] == 0 || empty($_GET["FK_HHCBilder01"])) ? 308 : $_GET["FK_HHCBilder01"];

$_GET["pagenum"] = (!isset($_GET["pagenum"]) || $_GET["pagenum"] == 0 || empty($_GET["pagenum"])) ? 1 : $_GET["pagenum"];

$_SESSION["pagenum01"] = $_GET["pagenum"];
$_SESSION['sys_userid'] = (!isset($_SESSION['sys_userid']) || $_SESSION['sys_userid'] == 0 || empty($_SESSION['sys_userid'])) ? 1 : $_SESSION['sys_userid'];


# PHPGRID BEGINN-----------------------------------------------
    $PHPGRIDSFolder = $_SESSION["pfad"]."phpgrid";
    include_once($PHPGRIDSFolder."/config.php");

    // include and create object
    include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");

    $db_conf = array();
    $db_conf["type"] = PHPGRID_DBTYPE;
    $db_conf["server"] = PHPGRID_DBHOST; // or you mysql ip
    $db_conf["user"] = PHPGRID_DBUSER; // username
    $db_conf["password"] = PHPGRID_DBPASS; // password
    $db_conf["database"] = PHPGRID_DBNAME; // database

    // pass connection array to jqgrid()
    $g = new jqgrid($db_conf);

    $grid["footerrow"] = true;

    $e = array();
    $e["js_on_load_complete"] = "grid_onload";
    $g->set_events($e);

    $grid["multiselect"] = true; // allow you to multi-select through checkboxes

    // set few params
    $grid["caption"] = "Titel des Auftritts";
    $g->set_options($grid);

    // set database table for CRUD operations
    $g->table = "hhc_auftritt_titel";

    // for excel, sheet header
    $grid["export"]["sheetname"] = "GEMA-Liste";

    // Setting RTL will export pdf as RTL also
    // $grid["direction"] = "rtl";

    // export filtered data or all data
    $grid["export"]["range"] = "all"; // or "all"
    $grid["export"]["paged"] = "1";

    // Date will be sorted desc, and ID asc.
    $grid["sortname"] = "hhc_auftritt_titel.dt_sort";
    $grid["sortorder"] = "ASC";

    $sql = "SELECT
               hhc_auftritt_titel.id_hhc_auftritt_titel,
               hhc_titel.dt_titel_bez AS dt_titel_bez,
               Date_Format(hhc_titel.dt_titel_dauer, '%i:%s') AS dt_titel_dauer,
               hhc_bilder01_abteilung.ID_HHCBilder01_Abteilung,
               con_komp.komponist_name_concat,
               con_bearb.bearbeiter_name_concat,
               hhc_verlag.dt_verlag_name ,
               dt_sort,
               hhc_titel.id_titel ,
               TIME_TO_SEC(hhc_titel.dt_titel_dauer) AS dt_sekunden
            FROM
               hhc_bilder01_abteilung
               INNER JOIN hhc_auftritt_titel
                  ON hhc_auftritt_titel.fk_t_hhc_bilder01_abteilung_f_ID_HHCBilder01_Abteilung = hhc_bilder01_abteilung.ID_HHCBilder01_Abteilung
               INNER JOIN hhc_titel
                  ON hhc_auftritt_titel.fk_t_hhc_titel_f_id_titel = hhc_titel.id_titel
               inner join (  select hhc_komponist.id_komponist,
                                CASE WHEN hhc_komponist.dt_komponist_name = ''
                                    THEN 'diverse'
                                    ELSE CASE
                                        WHEN (hhc_komponist.dt_komponist_vorname = 'nop' or hhc_komponist.dt_komponist_vorname = '')
                                            THEN Concat(hhc_komponist.dt_komponist_name)
                                            ELSE Concat(hhc_komponist.dt_komponist_name, ', ', hhc_komponist.dt_komponist_vorname)
                                    END
                                end AS komponist_name_concat
                                from
                                    hhc_komponist
                                ) con_komp ON hhc_titel.fk_titel_komponist = con_komp.id_komponist
               inner join (  select hhc_bearbeiter.id_bearbeiter,
                                CASE WHEN hhc_bearbeiter.dt_bearbeiter_name = ''
                                    THEN 'diverse'
                                    ELSE CASE
                                        WHEN (hhc_bearbeiter.dt_bearbeiter_vorname = 'nop' or hhc_bearbeiter.dt_bearbeiter_vorname = '')
                                            THEN Concat(hhc_bearbeiter.dt_bearbeiter_name)
                                            ELSE Concat(hhc_bearbeiter.dt_bearbeiter_name, ', ', hhc_bearbeiter.dt_bearbeiter_vorname)
                                    END
                                end AS bearbeiter_name_concat
                                from
                                    hhc_bearbeiter
                                ) con_bearb ON hhc_titel.fk_titel_bearbeiter = con_bearb.id_bearbeiter
               LEFT OUTER JOIN hhc_verlag
                    ON hhc_titel.fk_titel_verlag_erschienen = hhc_verlag.id_verlag
            WHERE
              ( hhc_bilder01_abteilung.ID_HHCBilder01_Abteilung =".$_GET["ID_HHCBilder01_Abteilung"].")    ";
    $g->select_command = $sql;

    $g->set_actions(array(
                    "add"=>false,
                    "edit"=>true,
                    "clone"=>false,
                    "bulkedit"=>false,
                    "delete"=>true,
                    "view"=>true,
                    "rowactions"=>true,
                    "export_pdf"=>false,
                    "export_excel"=>true, // export excel button
                    "autofilter" => true,
                    "search" => "simple",
                    "inlineadd" => false,
                    "showhidecolumns" => true
                )
            );

    $col = array();
    $col["title"] = "id_hhc_auftritt_titel"; // caption of column, can use HTML tags too
    $col["name"] = "id_hhc_auftritt_titel"; // grid column name, same as db field or alias from sql
    #$col["width"] = "10"; // width on grid
    $col["editable"] = false;
    $col["hidden"] = true;
    $col["export"] = false; // this column will not be exported
    $cols[] = $col;

    $col = array();
    $col["title"] = "dt_sekunden"; // caption of column, can use HTML tags too
    $col["name"] = "dt_sekunden"; // grid column name, same as db field or alias from sql
    #$col["width"] = "10"; // width on grid
    $col["editable"] = false;
    $col["hidden"] = true;
    $col["export"] = false; // this column will not be exported
    $cols[] = $col;

    $col = array();
    $col["title"] = "id_titel"; // caption of column, can use HTML tags too
    $col["name"] = "id_titel"; // grid column name, same as db field or alias from sql
    #$col["width"] = "10"; // width on grid
    $col["editable"] = false;
    $col["hidden"] = true;
    $col["export"] = false; // this column will not be exported
    $cols[] = $col;

    $col = array();
    $col["title"] = "Titel"; // caption of column, can use HTML tags too
    $col["name"] = "dt_titel_bez"; // grid column name, same as db field or alias from sql
    $col["width"] = "130"; // width on grid
    $col["editable"] = false;
    $col["sortable"] = true;
    if ( $_SERVER['REMOTE_ADDR'] == "0:0:0:0:0:0:0:1" )
        $col["link"] = "http://localhost:8080/_HHCPHP/admin_php/E02_Auftritt_Titel.php?id_hhc_auftritt_titel={id_hhc_auftritt_titel}&ID_HHCBilder01_Abteilung=".$_GET["ID_HHCBilder01_Abteilung"]."";
    else
        $col["link"] = "http://hhc-freudental.de/_HHCPHP/admin_php/E02_Auftritt_Titel.php?id_hhc_auftritt_titel={id_hhc_auftritt_titel}&ID_HHCBilder01_Abteilung=".$_GET["ID_HHCBilder01_Abteilung"]."";

    # $col["linkoptions"] = "target='_blank'"; // extra params with <a> tag
    $cols[] = $col;

    $col = array();
    $col["title"] = "Dauer"; // caption of column, can use HTML tags too
    $col["name"] = "dt_titel_dauer"; // grid column name, same as db field or alias from sql
    $col["width"] = "50"; // width on grid
    $col["editable"] = false;
    $col["search"] = false;
    if ( $_SERVER['REMOTE_ADDR'] == "0:0:0:0:0:0:0:1" )
       $col["link"] = "http://localhost:8080/_HHCPHP/viewhhcNotenJahrgangGraph.php?pn_nr={id_titel}";
    else
       $col["link"] = "http://hhc-freudental.de/_HHCPHP/viewhhcNotenJahrgangGraph.php?pn_nr={id_titel}";
    $cols[] = $col;

    $col = array();
    $col["title"] = "Komponist"; // caption of column, can use HTML tags too
    $col["name"] = "komponist_name_concat"; // grid column name, same as db field or alias from sql
    $col["width"] = "100"; // width on grid
    $col["editable"] = false;
    $cols[] = $col;

    $col = array();
    $col["title"] = "Bearbeiter"; // caption of column, can use HTML tags too
    $col["name"] = "bearbeiter_name_concat"; // grid column name, same as db field or alias from sql
    $col["width"] = "100"; // width on grid
    $col["editable"] = false;
    $cols[] = $col;

    $col = array();
    $col["title"] = "Verlag"; // caption of column, can use HTML tags too
    $col["name"] = "dt_verlag_name"; // grid column name, same as db field or alias from sql
    $col["width"] = "110"; // width on grid
    $col["editable"] = false;
    $cols[] = $col;

    $col = array();
    $col["title"] = "Sortierung"; // caption of column, can use HTML tags too
    $col["name"] = "dt_sort"; // grid column name, same as db field or alias from sql
    $col["width"] = "110"; // width on grid
    $col["editable"] = true;
    $col["search"] = false;
    $cols[] = $col;

    // pass the cooked columns to grid
    //$g->set_columns($cols);

    // render grid and get html/js output
    $out = $g->render("list1");


# -------------------------------
# login erfolgt
# -------------------------------
if ($_SERVER['REMOTE_ADDR'] == "127.0.0.1" or $_SERVER['REMOTE_ADDR'] =="0:0:0:0:0:0:0:1") :
else:
    if ($_SESSION['sys_prooflogin'] == $GLOB_proof):
    else:
         header("Location: hhclogin.php");
         exit;
   endif;
endif;

//--------------------------------------
//Button "Zurück" wurde geklickt
//--------------------------------------
if ( !isset($_REQUEST["btnCancel_left_image"]) or $_REQUEST["btnCancel_left_image"] == ""  ) :
else:
    if ($_REQUEST["btnCancel_left_image"] == "Zurück" ):
        $_GET["func"] = "G";
        header("Location: E03_Ereignis.php?ID_HHCBilder01_Abteilung=".$_SESSION["ID_HHCBilder01_Abteilung"]
                    ."&FK_HHCBilder01=".$_GET["FK_HHCBilder01"]."");
        exit;
    endif;
endif;

//--------------------------------------
//Button "Neu" wurde geklickt
//--------------------------------------
if ( !isset($_REQUEST["btnNeu_left_image"]) or $_REQUEST["btnNeu_left_image"] == ""  ) :
else:
    if ($_REQUEST["btnNeu_left_image"] == "Neu" ):
        $_GET["id_hhc_auftritt_titel"] = Insert_HHC_Auftritt_Titel($db, $_GET["ID_HHCBilder01_Abteilung"]);
        if ($_GET["id_hhc_auftritt_titel"] > 0):
            $_GET["func"]=="G";

            header("Location: E02_Auftritt_Titel.php?func=G&id_hhc_auftritt_titel=".$_GET["id_hhc_auftritt_titel"]."&FK_HHCBilder01=".$_GET["FK_HHCBilder01"]
                            ."&ID_HHCBilder01_Abteilung=". $_GET["ID_HHCBilder01_Abteilung"]
                            ."");
        else:
        endif;
        #header("Location: E02_GUeb_Ereignisse.php?func=I");
         Exit;
    endif;
endif;



//Create KoolForm includes
$KoolControlsFolder = "../../KoolPHPSuite/KoolControls";
require $KoolControlsFolder."/KoolForm/koolform.php";

//Create KoolForm object. The parameter is the name of the form that you want to decorate.
$myform_manager = new KoolForm("myform");
$myform_manager->scriptFolder = $KoolControlsFolder."/KoolForm";
$myform_manager->DecorationEnabled = true;
$myform_manager->styleFolder = "office2010silver";

// Buttons
$btnNeu_left_image = new KoolButton("btnNeu_left_image");
$btnNeu_left_image->Text = "Neu";
$btnNeu_left_image->AutoPostback=true;
$btnNeu_left_image->ToolTip = "Neuen Eintrag erstellen";
$btnNeu_left_image->LeftImage = $KoolControlsFolder."/KoolForm/icons/plain/bookmark_add.png";
$myform_manager->AddControl($btnNeu_left_image);

$btnCancel_left_image = new KoolButton("btnCancel_left_image");
$btnCancel_left_image->Text = "Zurück";
$btnCancel_left_image->ToolTip = "Seite verlassen";
$btnCancel_left_image->AutoPostback=true;
$btnCancel_left_image->LeftImage = $KoolControlsFolder."/KoolForm/icons/plain/delete2.png";
$myform_manager->AddControl($btnCancel_left_image);

$btnexport_to_excel = new KoolButton("export_to_excel");
$btnexport_to_excel->Text = "Export";
$btnexport_to_excel->ToolTip = "Excel Export";
$btnexport_to_excel->AutoPostback=true;
$btnexport_to_excel->LeftImage = $KoolControlsFolder."/KoolForm/icons/plain/export1.png";
$myform_manager->AddControl($btnexport_to_excel);

//The form need to be init.
$myform_manager->Init();



# 01 ---------------------------------------------------------
# 01 --> Beginn HTML-Ausgabe-Template
include ($_SESSION["pfad"]."html_01_include_headinhalt.php");

# 01a ---------------------------------------------------------
# 01a --> Seitenbezogene Stylsheets, nur wenn unvermeidbar !!!!!
#echo ebene(1)."<link rel=\"stylesheet\" href=\"".$_SESSION["pfad"]."_stylesheet/bilderview.css\" type=\"text/css\" />\n";

?>
        <!-- these css and js files are required by php grid -->
        <link rel="stylesheet" href="../../phpgrid/lib/js/themes/redmond/jquery-ui.custom.css"></link>
        <link rel="stylesheet" href="../../phpgrid/lib/js/jqgrid/css/ui.jqgrid.css"></link>
        <script src="../../phpgrid/lib/js/jquery.min.js" type="text/javascript"></script>
        <script src="../../phpgrid/lib/js/jqgrid/js/i18n/grid.locale-de.js" type="text/javascript"></script>
        <script src="../../phpgrid/lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
        <script src="../../phpgrid/lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
        <!-- these css and js files are required by php grid -->
<?php
echo ebene(0)."</head>\n";
echo ebene(0)."<body>\n";
?>


<?php
#include ($_SESSION["pfad"]."html_02_include_menu.php");

echo ebene(1)."<!-- Beginn Seiteninhalt -->\n";
echo ebene(1)."<div class=\"container\">\n";
echo ebene(1)."\n";

# 01 --> Ende HTML-Ausgabe-Template
# 01 ---------------------------------------------------------

$titel = Get_Auftritt_Titel($_GET["ID_HHCBilder01_Abteilung"],$db);
# echo ebene(2)."<h4 class=\"bg-primary\">HHC - ADMIN: <span class=\"text-admin\">-Zuordnung der Stücke für ".$titel." </span></h4>\n";

echo ebene(2)."<div class=\"page-header\">\n";
echo ebene(2).$titel;
echo ebene(2)."<div>\n";

# Abstand zum Forminhalt
echo ebene(3)."<div style=\"padding-top:15px;\"> </div>\n";



echo ebene(3)."<FORM name=\"".$Form_name."\" class=\"decoration\" id=\"myform\"  method=\"post\" accept-charset=\"".
                $charset_utf8."\" action=\"".htmlspecialchars($_SERVER['PHP_SELF'],ENT_QUOTES,"UTF-8").
                "?FK_HHCBilder01=".$_GET['FK_HHCBilder01']."&ID_HHCBilder01_Abteilung=".$_GET["ID_HHCBilder01_Abteilung"]."\">";





    print ebene(3)."<br clear=all>\n\n";

   ?>

      <div style="margin:10px">
      <script>

    function grid_onload()
    {
        var grid = $("#list1"),

        count = grid.jqGrid('getCol', 'dt_titel_bez', false, 'count');
        grid.jqGrid('footerData','set', {dt_titel_bez: 'Anzahl: '+count});

        sec = grid.jqGrid('getCol', 'dt_sekunden', false, 'sum');
        grid.jqGrid('footerData','set', {dt_titel_dauer: 'Dauer: '+secToStr(sec)});


    }
    function secToStr(sec)
    {
       sec = parseInt(sec);
       minuten = parseInt(sec/60);
       sec = sec%60;
       stunden = parseInt(minuten/60);
       minuten = minuten%60;
       if (sec < 10)
       {
        ret_ss = '0'+sec;
       }
       else
       {
        ret_ss = sec;
       }
       if (minuten < 10)
       {
        ret_mm = '0'+minuten;
       }
       else
       {
        ret_mm = minuten;
       }
       if (stunden > 0)
       {
        retval = stunden+':'+ret_mm+':'+ret_ss;
       }
       else
       {
        retval = ret_mm+':'+ret_ss;
       }

       return retval;
    }


    </script>

        <!-- display grid here -->
        <?php echo $out?>
        <!-- display grid here -->

        </div>

   <?php



?>
<fieldset><legend><b>Aktionen</b></legend>
    <div style="margin-bottom:5px;margin-top:5px;margin-left:25px ;">
            <?php #echo $btnexport_to_excel->Render(); ?>
            <?php echo $btnNeu_left_image->Render(); ?>
            <?php echo $btnCancel_left_image->Render(); ?>
    </div>
</fieldset>
<?php

echo $myform_manager->Render();

echo ebene(3)."</form>\n";


# 02 ---------------------------------------------------------
# 02 --> Beginn HTML-Ausgabe-Template
echo ebene(2)."</div>\n";
echo ebene(1)."<!-- Ende Seiteninhalt -->\n";

include ($_SESSION["pfad"]."html_03_include_footer.php");

echo ebene(0)."</body>\n";
echo ebene(0)."</html>\n";
# 02 --> Ende HTML-Ausgabe-Template
# 02 ---------------------------------------------------------