PHP get_tab_type_pointage_discipline示例

示例#1

文件： saisie_pointages.php 项目： alhousseyni/gepi

$sql = "CREATE TABLE IF NOT EXISTS sp_saisies (\nid int(11) NOT NULL AUTO_INCREMENT,\nid_type int(11) NOT NULL,\nlogin VARCHAR(50) NOT NULL default '',\ndate_sp datetime NOT NULL default '0000-00-00 00:00:00',\ncommentaire text NOT NULL,\ncreated_at datetime NOT NULL default '0000-00-00 00:00:00',\ncreated_by VARCHAR(50) NOT NULL DEFAULT '',\nPRIMARY KEY (id)\n) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;";
$create = mysqli_query($GLOBALS["mysqli"], $sql);
$sql = "CREATE TABLE IF NOT EXISTS sp_types_saisies (\nid_type int(11) NOT NULL AUTO_INCREMENT,\nnom VARCHAR(255) NOT NULL default '',\ndescription TEXT NOT NULL,\nPRIMARY KEY (id_type)\n) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;";
$create = mysqli_query($GLOBALS["mysqli"], $sql);
/*
$sql="CREATE TABLE IF NOT EXISTS sp_communication (
id int(11) NOT NULL AUTO_INCREMENT,
id_type int(11) NOT NULL,
seuil int(11) NOT NULL,
mail VARCHAR(255) NOT NULL default '',
observation VARCHAR(255) NOT NULL default '',
PRIMARY KEY (id)
) ENGINE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;";
$create=mysqli_query($GLOBALS["mysqli"], $sql);
*/
$tab_type_pointage_discipline = get_tab_type_pointage_discipline();
if (count($tab_type_pointage_discipline) == 0) {
    $sql = "INSERT INTO sp_types_saisies SET nom='Travail', description='Travail non fait';";
    $insert = mysqli_query($GLOBALS["mysqli"], $sql);
    $sql = "INSERT INTO sp_types_saisies SET nom='Matériel', description='Matériel manquant';";
    $insert = mysqli_query($GLOBALS["mysqli"], $sql);
    $sql = "INSERT INTO sp_types_saisies SET nom='Comportement', description='Comportement gênant';";
    $insert = mysqli_query($GLOBALS["mysqli"], $sql);
}
$mode = isset($_POST['mode']) ? $_POST['mode'] : (isset($_GET['mode']) ? $_GET['mode'] : NULL);
$id_groupe = isset($_POST['id_groupe']) ? $_POST['id_groupe'] : (isset($_GET['id_groupe']) ? $_GET['id_groupe'] : NULL);
$id_classe = isset($_POST['id_classe']) ? $_POST['id_classe'] : (isset($_GET['id_classe']) ? $_GET['id_classe'] : NULL);
$display_date = isset($_POST['display_date']) ? $_POST['display_date'] : (isset($_GET['display_date']) ? $_GET['display_date'] : NULL);
$id_creneau = isset($_POST['id_creneau']) ? $_POST['id_creneau'] : (isset($_GET['id_creneau']) ? $_GET['id_creneau'] : NULL);
$tab_creneaux = get_heures_debut_fin_creneaux();
// On suppose pour le moment $mode=='groupe'

示例#2

文件： share-html.inc.php 项目： alhousseyni/gepi

function retourne_tab_html_pointages_disc($login_ele)
{
    global $tab_type_pointage_discipline;
    if (count($tab_type_pointage_discipline) == 0) {
        $tab_type_pointage_discipline = get_tab_type_pointage_discipline();
    }
    $retour = "";
    // A REVOIR POUR AFFICHER DES TOTAUX PAR PERIODE
    $tab_totaux = array();
    $sql = "SELECT DISTINCT sp.* FROM sp_saisies sp WHERE sp.login='******';";
    //$retour.="$sql<br />";
    $res = mysqli_query($GLOBALS["mysqli"], $sql);
    if (mysqli_num_rows($res) > 0) {
        while ($lig = mysqli_fetch_object($res)) {
            if (!isset($tab_totaux[$lig->id_type])) {
                $tab_totaux[$lig->id_type] = 0;
            }
            $tab_totaux[$lig->id_type]++;
        }
        $tab_clas_ele = get_class_periode_from_ele_login($login_ele);
        $retour .= "<p class='bold'>Pointage des menus manquements&nbsp;:</p>\n<table class='boireaus boireaus_alt' style='margin-left:1em;'>\n\t<thead>\n\t\t<tr>\n\t\t\t<th>Type</th>";
        if (isset($tab_clas_ele['periode'])) {
            foreach ($tab_clas_ele['periode'] as $num_per => $current_classe) {
                $retour .= "\n\t\t\t<th title=\"Inscrit en " . $current_classe['classe'] . " en période {$num_per}\">P" . $num_per . "</th>";
            }
        }
        $retour .= "\n\t\t\t<th>Total</th>\n\t\t</tr>\n\t</thead>\n\t<tbody>\n\t\t<tr>";
        for ($loop2 = 0; $loop2 < count($tab_type_pointage_discipline['indice']); $loop2++) {
            $current_id_type = $tab_type_pointage_discipline['indice'][$loop2]['id_type'];
            $retour .= "\n\t\t<tr>\n\t\t\t<th>" . $tab_type_pointage_discipline['indice'][$loop2]['nom'] . "</th>";
            if (isset($tab_clas_ele['periode'])) {
                foreach ($tab_clas_ele['periode'] as $num_per => $current_classe) {
                    $retour .= "\n\t\t\t<td title=\"Filtrage des pointages par période non encore implémenté.\"></td>";
                }
            }
            $retour .= "\n\t\t\t<td>";
            if (isset($tab_totaux[$current_id_type])) {
                $retour .= $tab_totaux[$current_id_type];
            }
            $retour .= "</td>\n\t\t</tr>";
        }
        $retour .= "\n\t</tbody>\n</table>\n<br />";
    }
    return $retour;
}