CMS-CSE/core/views/pages/cms.proweb-dossiers.php

<?php
$dateData = get::jsonDateDataExcelProwebDossiers();
$date = ($dateData != NULL) ? " (au " . core::convertDate($dateData, FALSE) . ")" : "";

json::create("dossiers-proweb");

$jsonTarget = "/json.php?file=dossiers-proweb";
if(debug::isFile("debug")){
    debug::log(debug::getBadge($jsonTarget, "OUVRIR LE JSON : ".$jsonTarget), "JSON chargé en arrière plan");
} 
?>
<header class="d-flex flex-column flex-md-row align-items-md-center p-3 bg-light ">
    <h2 class="bd-title" id="content">
        <span>Proweb : Liste des dossiers<?php echo $date ?></span>
    </h2>
    <?php if(access::ifAccesss("proweb-dossiers-upload")){ ?>
    <div class="fix-container-button-nav">
        <a href="proweb-dossiers-upload.html"><button type="submit" class="btn btn-outline-success btn-sm"><?php icon::getFont(["icon" => "bi bi-file-earmark-plus"]) ?> Importer un fichier Excel</button></a>
        <a href="<?= PROWEB_DOSSIERS ?>" target="_blank"><button type="submit" class="btn btn-outline-secondary btn-sm"><?php icon::getFont(["icon" => "bi bi-link-45deg"]) ?> Exporter tous les dossiers depuis Proweb</button></a>
    </div>
    <?php } ?>
</header>

<?php
echo core::filAriane(array(
    "current" => "Liste des dossiers",
    "arbo" => array(
        "Proweb" => NULL,
        "Liste des dossiers" => "proweb-dossiers.html"
    )
));

?>
<div>
    <table id="ProWebSalary" class="table-striped table-hover table-sm" data-page-size="25" data-show-footer="true" data-toggle="table" data-buttons-align="left" data-pagination="true" data-filter-control="true" data-flat="true" data-show-columns-toggle-all="true" data-url="<?php echo $jsonTarget ?>">
        <thead>
            <tr>
                <th data-sortable="true" data-field="exe_ref" data-filter-control="select">Année</th>
                <th data-sortable="true" data-field="hismo_date_crea" data-filter-control="select">Création</th>
                <th data-sortable="true" data-field="prest_lib" data-filter-control="select">Prestation</th>
                <th data-sortable="true" data-field="prest_lib2" data-filter-control="select">Complément</th>
                <th data-sortable="true" data-field="catprest_lib" data-filter-control="select">Catégorie</th>
                <th data-sortable="true" data-field="comm_ref" data-filter-control="select">Commission</th>
                <th data-sortable="true" data-field="prest_closed" data-filter-control="select" data-formatter="clotureFormatter">Clôturé</th>
                <th data-sortable="true" data-field="etdoss_lib" data-filter-control="select">Etat</th>
                <th data-sortable="true" data-field="od_matricule" data-filter-control="input">Matricule</th>
                <th data-sortable="true" data-field="nomComplet" data-filter-control="input" data-formatter="concatNomPrenom">Prénom Nom</th>
                <th data-sortable="true" data-field="doss_nb_inscrit" data-filter-control="select" data-footer-formatter="totalInscrits">Nb. Inscrits</th>
                <th data-sortable="true" data-formatter="dataFormatter" data-field="doss_partce" data-filter-control="input" data-footer-formatter="prixCSE">Part CSE</th>
                <th data-sortable="true" data-formatter="dataFormatter" data-field="doss_partod" data-filter-control="input" data-footer-formatter="prixSalarie">Part Salarié</th>
                <th data-sortable="true" data-formatter="dataFormatter" data-field="doss_montant_total" data-filter-control="input" data-footer-formatter="prixTotal">Total</th>
            </tr>
        </thead>
    </table>
</div>

<script>
    let euro = Intl.NumberFormat('de-DE', {
        style: 'currency',
        currency: 'EUR',
    });

    function dataFormatter(value) {
        return euro.format(value);
    }

    function totalInscrits(data) {
        var total = 0;
        data.forEach(function(row) {
            var nb = parseFloat(row.doss_nb_inscrit);
            if (!isNaN(nb)) {
                total += nb;
            }
        });
        return total;
    }


    function prixCSE(data) {
        var total = 0;
        data.forEach(function(row) {
            total += parseFloat(row.doss_partce);
        });
        return parseFloat(total) === 0 ? euro.format(0.00) : euro.format(total.toFixed(2));
    }

    function prixSalarie(data) {
        var total = 0;
        data.forEach(function(row) {
            total += parseFloat(row.doss_partod);
        });
        return parseFloat(total) === 0 ? euro.format(0.00) : euro.format(total.toFixed(2));
    }

    function prixTotal(data) {
        var total = 0;
        data.forEach(function(row) {
            total += parseFloat(row.doss_montant_total);
        });
        return parseFloat(total) === 0 ? euro.format(0.00) : euro.format(total.toFixed(2));
    }

    function concatNomPrenom(value, row, index) {
        return row.od_prenom + ' ' + row.od_nom;
    }

    function clotureFormatter(value) {
        return value == 1 ? "Clôturé" : "Ouvert";
    }

    function subventionFormatter(value) {
        switch (value) {
            case "O":
                return "Subventionné"
                break;
            case "N":
                return "Non-subventionné"
                break;
            default:
                return "-"
                break;
        }
    }


</script>