jQWidgets Forums

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • in reply to: Export Excel Export Excel #114642

    paulo33
    Participant

    I found the probleme
    If I Delete this line :
    showcolumnheaderlines: false,

    It works !!

    in reply to: Export Excel Export Excel #114641

    paulo33
    Participant

    My code Page :

    <script type=”text/javascript” src=”/jqwidget-prod/jqxtooltip.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxgrid.grouping.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxgrid.aggregates.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxgrid.filter.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxgrid.sort.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxdatetimeinput.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxcheckbox.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxgrid.selection.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxgrid.edit.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxcombobox.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxdropdownlist.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxpanel.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxgrid.export.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/jqxexport.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/globalization/globalize.js”></script>
    <script type=”text/javascript” src=”/jqwidget-prod/globalization/localization.js”></script>
    <!– JSZip –>
    <script type=”text/javascript” src=”/jqwidget-prod/scripts/jszip.min.js”></script>
    <script type=”text/javascript”>
    var valTheme1 = ‘office’;
    var valTheme2 = ‘ui-redmond’;
    var valLW = parseInt($(window).width() – 40);
    var valHW = parseInt($(window).height() – 40);
    var http = null;
    var valNoDatas = false;
    if (window.XMLHttpRequest) // Firefox
    http = new XMLHttpRequest();
    else if (window.ActiveXObject) // Internet Explorer
    http = new ActiveXObject(“Microsoft.XMLHTTP”);
    else // XMLHttpRequest non supporté par le navigateur
    alert(“Votre navigateur ne supporte pas les objets XMLHTTPRequest…”);

    $(document).ready(function () {

    var listeCles = “”;
    var valLargeur = parseInt($(window).width() – 40);
    var valHauteur = $(window).height() – 110;
    var urlGrid = “datas.asp?Entite=PARTHENA&Doublons=NON”;

    if ( valNoDatas == true ) { urlGrid = ” }

    var source = {
    datatype: “tab”,
    datafields: [
    { name: ‘id_Cle’, type: ‘float’ },
    { name: ‘Entite’, type: ‘string’ },
    { name: ‘N_serie’, type: ‘string’ },
    { name: ‘NumSerieRgt’, type: ‘string’ },
    { name: ‘Client_Final’, type: ‘string’ },
    { name: ‘Groupe’, type: ‘string’ },
    { name: ‘Produit’, type: ‘string’ },
    { name: ‘ID_TypeProduit’, type: ‘string’ },
    { name: ‘TypeProduit’, type: ‘string’ },
    { name: ‘ID_Situation’, type: ‘string’ },
    { name: ‘Situation’, type: ‘string’ },
    { name: ‘Commentaire’, type: ‘string’ },
    { name: ‘Eclatement’, type: ‘string’ },
    { name: ‘DateModif’, type: ‘date’ },
    { name: ‘QuiModif’, type: ‘string’ },
    { name: ‘Present’, type: ‘string’ },
    { name: ‘Previsionnel’, type: ‘string’ },
    { name: ‘Etalement’, type: ‘string’ }
    ],
    id: ‘id’,
    url: urlGrid
    };

    var dataAdapter = new $.jqx.dataAdapter(source);

    /* ———————————————- */
    /* RECUPERATION DE LA LISTE DES TYPES DE PRODUITS */
    /* ———————————————- */
    var urlTP = “datas-tp.asp”;
    var sourceTP = {
    datatype: “tab”,
    datafields: [
    { name: ‘value’, type: ‘string’ },
    { name: ‘label’, type: ‘string’ },
    ],
    url: urlTP
    };
    var AdapterTP = new $.jqx.dataAdapter(sourceTP, { autoBind: true });

    /* ———————————————- */
    /* RECUPERATION DE LA LISTE DES TYPES DE PRODUITS */
    /* ———————————————- */
    var urlSITU = “datas-situ.asp”;
    var sourceSITU = {
    datatype: “tab”,
    datafields: [
    { name: ‘value’, type: ‘string’ },
    { name: ‘label’, type: ‘string’ },
    ],
    url: urlSITU
    };
    var AdapterSITU = new $.jqx.dataAdapter(sourceSITU, { autoBind: true });

    var tooltiprenderer = function (element) {
    $(element).jqxTooltip({position: ‘mouse’, content: $(element).text() });
    }

    var columnsCenter = function (value) {
    return ‘<div style=”text-align: center;background-color:#445ca5;color:#ffffff;height:100%;padding-top:7px;font-weight: bold;”>  ‘ + value + ‘  </div>’;
    }
    var columnsLeft = function (value) {
    return ‘<div style=”text-align: left;background-color:#445ca5;color:#ffffff;height:100%;padding-top:10px;font-weight: bold;”>  ‘ + value + ‘  </div>’;
    }

    $(“#jqxgrid”).jqxGrid({
    width: “99%”,
    height: valHauteur,
    source: dataAdapter,
    showfilterrow: true,
    filterable: true,
    altrows: true,
    columnsresize: true,
    theme: valTheme1,
    sortable: true,
    altrows: true,
    editable: true,
    showstatusbar: true,
    showaggregates: true,
    statusbarheight: 35,
    rowsheight: 27,
    showcolumnheaderlines: false,
    selectionmode: ‘multiplerowsadvanced’,
    localization: getLocalization(‘fr’),
    columns: [
    {
    text: “”
    ,datafield: ‘EDIT’
    ,pinned: true
    ,filterable: false
    ,renderer: columnsLeft
    ,editable: false
    ,width: 30
    ,cellsrenderer: function() {
    return “
    }
    },
    {
    text: “”
    ,datafield: ‘SUPPR’
    ,pinned: true
    ,filterable: false
    ,renderer: columnsLeft
    ,editable: false
    ,width: 30
    ,cellsrenderer: function() {
    return “
    }
    },
    {
    text: ‘id_Cle’
    ,datafield: ‘id_Cle’
    ,pinned: false
    ,width: 100
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: false
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    ,hidden: true
    },
    {
    text: ‘N\260 de S\351rie’
    ,pinned: true
    ,datafield: ‘N_serie’
    ,pinned: false
    ,width: 141
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: false
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    ,aggregates: [{
    ‘<b>Nb. </b>’:
    function (aggregatedValue, currentValue, column, record) {
    var total = 1;
    return aggregatedValue + total;
    }
    }]
    },
    {
    text: ‘N\260 S\351rie Rgt’
    ,datafield: ‘NumSerieRgt’
    ,pinned: false
    ,width: 112
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: true
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    },
    {
    text: ‘Type Produit’
    ,datafield: ‘TypeProduit’
    ,pinned: false
    ,width: 153
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: false
    ,renderer: columnsLeft
    },
    {
    text: ‘Produit’
    ,datafield: ‘Produit’
    ,pinned: false
    ,width: 474
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: false
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    },
    {
    text: ‘Groupe’
    ,datafield: ‘Groupe’
    ,pinned: false
    ,width: 255
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: true
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    },
    {
    text: ‘Client Final’
    ,datafield: ‘Client_Final’
    ,pinned: false
    ,width: 347
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: false
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    },
    {
    text: ‘Situation Commentaire’
    ,datafield: ‘Situation’
    ,pinned: false
    ,width: 268
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: false
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    ,filtertype: ‘list’
    },
    {
    text: ‘Commentaire’
    ,datafield: ‘Commentaire’
    ,pinned: false
    ,width: 70
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: true
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    },
    {
    text: ‘Date Modif’
    ,datafield: ‘DateModif’
    ,pinned: false
    ,width: 80
    ,cellsalign: ‘center’
    ,align: ‘center’
    ,editable: false
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    ,cellsformat: ‘dd/MM/yyyy’
    },
    {
    text: ‘Qui Modif’
    ,datafield: ‘QuiModif’
    ,pinned: false
    ,width: 120
    ,cellsalign: ‘left’
    ,align: ‘left’
    ,editable: false
    ,renderer: columnsLeft
    ,rendered: tooltiprenderer
    },
    {
    text: ‘Eclat ?’
    ,datafield: ‘Eclatement’
    ,pinned: false
    ,width: 60
    ,cellsalign: ‘center’
    ,align: ‘center’
    ,editable: true
    ,renderer: columnsCenter
    ,rendered: tooltiprenderer
    ,filtertype: ‘list’
    },
    {
    text: ‘Présent ?’
    ,datafield: ‘Present’
    ,pinned: false
    ,width: 60
    ,cellsalign: ‘center’
    ,align: ‘center’
    ,editable: false
    ,renderer: columnsCenter
    ,rendered: tooltiprenderer
    ,filtertype: ‘list’
    },
    {
    text: ‘Prev ?’
    ,datafield: ‘Previsionnel’
    ,pinned: false
    ,width: 60
    ,cellsalign: ‘center’
    ,align: ‘center’
    ,editable: false
    ,renderer: columnsCenter
    ,rendered: tooltiprenderer
    ,filtertype: ‘list’
    },
    {
    text: ‘Etal ?’
    ,datafield: ‘Etalement’
    ,pinned: false
    ,width: 60
    ,cellsalign: ‘center’
    ,align: ‘center’
    ,editable: false
    ,renderer: columnsCenter
    ,rendered: tooltiprenderer
    ,filtertype: ‘list’
    }
    ]
    });

    $(“#jqxgrid”).on(“cellclick”, function (event) {
    var args = event.args;
    var rowIndex = args.rowindex;
    var columnName = args.datafield;
    if ( columnName == “EDIT” ) {
    var valeurCle = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowIndex, ‘id_Cle’);
    editLigne(valeurCle);
    }
    if ( columnName == “SUPPR” ) {
    var valeurCle = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowIndex, ‘id_Cle’);
    supprLigne(valeurCle);
    }
    if ( columnName == ‘TypeProduit’ ) {
    var valeurCle = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowIndex, ‘id_Cle’);
    editListe(valeurCle, columnName, 520);
    }
    if ( columnName == “Situation” ) {
    var valeurCle = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowIndex, ‘id_Cle’);
    editListe(valeurCle, columnName, 400);
    }
    });

    // ———————————-
    // CHANGEMENT DE LARGEUR D’UN COLONNE
    // ———————————-
    $(“#jqxgrid”).on(“columnresized”, function (event) {
    var args = event.args;
    var nomChamp = args.datafield;
    var newWidth = args.newwidth;
    var valLien = ‘enreg-largeur.asp?NomPage=NUMSERIE&NomChamp=’ + nomChamp + ‘&Largeur=’ + newWidth;
    //alert(valLien); return false;
    http.open(“GET”, valLien, false);
    http.send();
    var tabRep = http.responseText.split(“|”);
    $(“#messInfo”).html(“”);
    if ( tabRep[0] != ‘OK’ ) {
    $(“#messERR”).html(
    “<font color=’#ff0000′><b>Oups, c’est facheux … petite erreur !</b></font>” +
    “<br><br>” + tabRep[1] + “<br><br>” +
    “<font color=’#ff0000′>Merci de contacter <b>Jean-Paul au 06.73.61.52.43</b><br>ou par email <b>jean-paul.tauziede@parthena.com</b></font><br><br>”);
    $(“#dvERR”).fadeIn(5);
    }
    });

    // ———————————-
    // CHANGEMENT DE VALEUR D’UNE CELLULE
    // ———————————-

    $(“#jqxgrid”).bind(‘cellendedit’, function (event) {
    var column = $(“#jqxgrid”).jqxGrid(‘getcolumn’, event.args.datafield);
    if (column.displayfield != column.datafield) {
    var old_Value = event.args.oldvalue.value;
    var new_Value = event.args.value.value;
    var lib_new_Value = event.args.value;
    if ( new_Value == undefined ) {
    affichePopin(‘/tab_param/edit_ligne.asp’, ‘id_Table=11&listeCles=id_Cle&Valeur=’ + encodeURIComponent(lib_new_Value), 800, 300);
    }
    else {
    if ( new_Value != old_Value ) {
    var idCle = $(‘#jqxgrid’).jqxGrid(‘getcellvalue’, event.args.rowindex, ‘id_Cle’);
    var valLien = “enreg-valeur.asp?idCle=” + idCle + “&Valeur=” + encodeURIComponent(new_Value) + “&Champ=” + encodeURIComponent(column.datafield);
    //encodeURIComponent alert(valLien); return false;
    http.open(“GET”, valLien, false); //ouverture asynchrone
    http.send();
    var tabReponse = http.responseText.split(‘|’);
    if ( tabReponse[0] != ‘OK’ ) {
    $(“#dvERR”).fadeIn(5);
    $(“#messERR”).html(
    “<font color=’#ff0000′><b>Oups !! Une erreur s’est produite !</b></font><br><br>” +
    “url d’appel : ” + valLien + “<br><br>” +
    tabReponse[1] + “<br><br>” +
    “<font color=’#ff0000′>Merci de contacter <b>Jean-Paul au 06.73.61.52.43</b></font><br><br>”);
    }
    }
    }
    return false;
    }
    else {
    var column = event.args.datafield;
    var row = event.args.rowindex;
    var new_Value = event.args.value;
    var old_Value = event.args.oldvalue;
    if ( new_Value != old_Value && new_Value != ” ) {
    var idCle = $(‘#jqxgrid’).jqxGrid(‘getcellvalue’, row, ‘id_Cle’);
    var valLien = “enreg-valeur.asp?idCle=” + idCle + “&Valeur=” + encodeURIComponent(new_Value) + “&Champ=” + encodeURIComponent(column);
    //alert(valLien); return false;
    http.open(“GET”, valLien, false); //ouverture asynchrone
    http.send();
    var tabReponse = http.responseText.split(‘|’);
    if ( tabReponse[0] != ‘OK’ ) {
    $(“#dvERR”).fadeIn(5);
    $(“#messERR”).html(
    “<font color=’#ff0000′><b>Oups !! Une erreur s’est produite !</b></font><br><br>” +
    “url d’appel : ” + valLien + “<br><br>” +
    tabReponse[1] + “<br><br>” +
    “<font color=’#ff0000′>Merci de contacter <b>Jean-Paul au 06.73.61.52.43</b></font><br><br>”);
    }
    }
    }
    });

    /*
    $(“#btParthena”).jqxButton({ height: 28, theme: valTheme2, width: 90 });
    $(“#btParthena”).click(function () {
    var filtervalue = ‘PARTHENA’;
    var filtergroup = new $.jqx.filter();
    var filter = filtergroup.createfilter(‘stringfilter’, filtervalue, ‘EQUAL’);
    filtergroup.addfilter(0, filter);
    $(‘#jqxgrid’).jqxGrid(‘addfilter’, ‘Entite’, filtergroup, true);
    });
    $(“#btParthena”).jqxTooltip({ content: ‘CLIQUEZ POUR FILTRER LES N° DE SERIES DE PARTHENA’, width: 100, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2 });

    $(“#btCargo”).jqxButton({ height: 28, theme: valTheme2, width: 75 });
    $(“#btCargo”).click(function () {
    var filtervalue = ‘CARGO’;
    var filtergroup = new $.jqx.filter();
    var filter = filtergroup.createfilter(‘stringfilter’, filtervalue, ‘EQUAL’);
    filtergroup.addfilter(0, filter);
    $(‘#jqxgrid’).jqxGrid(‘addfilter’, ‘Entite’, filtergroup, true);
    });
    $(“#btCargo”).jqxTooltip({ content: ‘CLIQUEZ POUR FILTRER LES N° DE SERIES DE CARGO’, width: 100, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2 });

    $(“#btTMS”).jqxButton({ height: 28, theme: valTheme2, width: 50 });
    $(“#btTMS”).click(function () {
    var filtervalue = ‘TMS’;
    var filtergroup = new $.jqx.filter();
    var filter = filtergroup.createfilter(‘stringfilter’, filtervalue, ‘EQUAL’);
    filtergroup.addfilter(0, filter);
    $(‘#jqxgrid’).jqxGrid(‘addfilter’, ‘Entite’, filtergroup, true);
    });
    $(“#btTMS”).jqxTooltip({ content: ‘CLIQUEZ POUR FILTRER LES N° DE SERIES DE TMS’, width: 100, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2 });
    */
    $(“#btDoublons”).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/doublons.png”, textImageRelation: “imageBeforeText” });
    $(“#btDoublons”).click(function () {
    var valDoublon = $(“#Doublon”).val();
    window.location = “?Entite=PARTHENA&Doublons=” + valDoublon;
    });
    $(“#btDoublons”).jqxTooltip({ content: ‘CLIQUEZ POUR FILTRER LES N° DE SERIES EN DOUBLE’, width: 130, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2 });

    // ===========================
    // EDITION DE PLUSIEURS LIGNES
    // ===========================
    $(“#btEdit”).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/edit.png”, textImageRelation: “imageBeforeText” });
    $(“#btEdit”).click(function () {
    var lstCles = ”;
    var rowID = 0;
    var valSepar = “”;
    var selectedrowindexes = $(‘#jqxgrid’).jqxGrid(‘getselectedrowindexes’);
    var count = selectedrowindexes.length;
    if ( count == 0 ) {
    $(“#messInfo”).html(‘Veuillez sélectionner une ou plusieurs lignes à modifier’);
    return false;
    }
    if ( count == 1 ) {
    rowID = $(“#jqxgrid”).jqxGrid(‘getrowid’, selectedrowindexes[0]);
    lstCles = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “id_Cle”);
    }
    else {
    for (var i = 0; i < count; i++ ) {
    rowID = $(“#jqxgrid”).jqxGrid(‘getrowid’, selectedrowindexes[i]);
    lstCles = lstCles + valSepar + $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “id_Cle”);
    valSepar = “;”
    }
    }
    //alert(lstCles); return false;
    editLignes(lstCles);
    });
    $(“#btEdit”).jqxTooltip({ content: ‘CLIQUEZ POUR METTRE A JOUR LA OU LES LIGNES SELECTIONNEES’, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2, width: 120 });

    // ===========================
    // EDITION DE PLUSIEURS LIGNES
    // ===========================
    $(“#btSuppr”).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/delete.png”, textImageRelation: “imageBeforeText” });
    $(“#btSuppr”).click(function () {
    var lstCles = ”;
    var rowID = 0;
    var valSepar = “”;
    var selectedrowindexes = $(‘#jqxgrid’).jqxGrid(‘getselectedrowindexes’);
    var count = selectedrowindexes.length;
    if ( count == 0 ) {
    $(“#messInfo”).html(‘Veuillez sélectionner une ou plusieurs lignes à supprimer’);
    return false;
    }
    if ( count == 1 ) {
    rowID = $(“#jqxgrid”).jqxGrid(‘getrowid’, selectedrowindexes[0]);
    lstCles = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “id_Cle”);
    }
    else {
    for (var i = 0; i < count; i++ ) {
    rowID = $(“#jqxgrid”).jqxGrid(‘getrowid’, selectedrowindexes[i]);
    lstCles = lstCles + valSepar + $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “id_Cle”);
    valSepar = “;”
    }
    }
    //alert(lstCles); return false;
    supprLignes(lstCles);
    });
    $(“#btSuppr”).jqxTooltip({ content: ‘CLIQUEZ POUR SUPPRIMER LA OU LES LIGNES SELECTIONNEES’, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2, width: 120 });

    // ========================
    // RECHARGEMENT DES DONNEES
    // ========================
    $(“#btRefresh”).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/reload.png”, textImageRelation: “imageBeforeText” });
    $(“#btRefresh”).click(function () {
    $(“#jqxgrid”).jqxGrid(‘updatebounddata’, ‘cells’);
    });
    $(“#btRefresh”).jqxTooltip({ content: ‘CLIQUEZ POUR ACTUALISER LES DONNEES’, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2, width: 120 });

    $(“#btAllSelect”).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/tout_select.png”, textImageRelation: “imageBeforeText” });
    $(“#btAllSelect”).click(function () {
    $(‘#jqxgrid’).jqxGrid(‘selectallrows’);
    });
    $(“#btAllSelect”).jqxTooltip({ content: ‘CLIQUEZ POUR SELECTIONNER TOUTES LES LIGNES’, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2, width: 120 });

    $(“#btCalcul”).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/traite.png”, textImageRelation: “imageBeforeText” });
    $(“#btCalcul”).click(function () {
    fctIntegrationDatas();
    });
    $(“#btCalcul”).jqxTooltip({ content: ‘CLIQUEZ POUR RELANCER LE TRAITEMENT D\’INTEGRATION DES DONNEES’, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2, width: 120 });

    $(“#btExcel”).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/excel.png”, textImageRelation: “imageBeforeText” });
    $(“#btExcel”).click(function () {
    $(“#messInfo”).html(“Génération du document Excel en cours … merci de patienter  “);
    $(“#jqxgrid”).jqxGrid(‘exportdata’, ‘xlsx’, ‘ns’);
    $(“#messInfo”).html(“”);
    });
    $(“#btExcel”).jqxTooltip({ content: ‘CLIQUEZ POUR EXPORTER LE TABLEAU VERS EXCEL’, width: 100, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2 });

    $(“#btClear”).jqxButton({ height: 28, theme: valTheme2, width: 100 });
    $(“#btClear”).click(function () {
    $(“#jqxgrid”).jqxGrid(‘clearfilters’);
    });
    $(“#btClear”).jqxTooltip({ content: ‘CLIQUEZ POUR SUPPRIMER LES FILTRES DU TABLEAU’, width: 130, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2 });

    $(‘#btImportFile’).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/open-file.png”, textImageRelation: “imageBeforeText” });
    $(‘#btImportFile’).click(
    function () {
    affichePopin(‘import_file/import_csv.asp’, ‘idTable=” & strID_Table & “‘, 1200, 600);
    });
    $(‘#btImportFile’).jqxTooltip({ content: ‘CLIQUEZ POUR IMPORTER UN FICHIER’, width: 100, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2 });

    $(‘#btNewVAL’).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/add_valeur.png”, textImageRelation: “imageBeforeText”});
    $(‘#btNewVAL’).click(
    function () {
    editLigne(0);
    });
    $(‘#btNewVAL’).jqxTooltip({ content: ‘CLIQUEZ POUR AJOUTER UNE VALEUR’, width: 100, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2 });

    $(“#btEclate”).jqxButton({ height: 28, theme: valTheme2, imgSrc: “/images/eclate.png”, textImageRelation: “imageBeforeText” });
    $(“#btEclate”).click(function () {
    var lstNS_RGT = “”;
    var typeProduit = “”;
    var rowID = “0”;
    var valSepar = “”;
    var selectedrowindexes = $(‘#jqxgrid’).jqxGrid(‘getselectedrowindexes’);
    var count = selectedrowindexes.length;
    if ( count == 0 ) {
    var filtervalue = ‘OUI’;
    var filtergroup = new $.jqx.filter();
    var filter = filtergroup.createfilter(‘stringfilter’, filtervalue, ‘EQUAL’);
    filtergroup.addfilter(0, filter);
    $(‘#jqxgrid’).jqxGrid(‘addfilter’, ‘Eclatement’, filtergroup, true);
    return false;
    }
    if ( count == 1 ) {
    rowID = $(“#jqxgrid”).jqxGrid(‘getrowid’, selectedrowindexes[0]);
    lstNS_RGT = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “NumSerieRgt”);
    id_TypeProduit = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “ID_TypeProduit”);
    id_Situation = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “ID_Situation”);
    }
    else {
    for (var i = 0; i < count; i++ ) {
    rowID = $(“#jqxgrid”).jqxGrid(‘getrowid’, selectedrowindexes[i]);
    lstNS_RGT = lstNS_RGT + valSepar + $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “NumSerieRgt”);
    id_TypeProduit = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “ID_TypeProduit”);
    id_Situation = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “ID_Situation”);
    valSepar = “;”
    }
    }
    editEclate(lstNS_RGT, id_TypeProduit, id_Situation);
    });
    $(“#btEclate”).jqxTooltip({ content: ‘CLIQUEZ POUR ECLATER UN OU PLUSIEURS N° DE SERIE DE REGROUPEMENT’, width: 100, position: ‘bottom’, name: ‘movieTooltip’, theme: valTheme2 });
    });

    function exportExcel() {
    $(“#messWait”).html(“Exportation vers Excel en cours … merci de patienter”);
    $(“#dvWait”).fadeIn(1);
    iFrameLoaded(“frExportExcel”, “export_excel.asp?idTable=1”);
    }

    function iFrameLoaded(id, src) {
    var deferred = $.Deferred(),
    iframe = $(“<iframe class=’hiddenFrame’></iframe>”).attr({
    “id”: id,
    “src”: src
    });

    iframe.load(deferred.resolve);
    iframe.appendTo(“body”);

    deferred.done(function() {
    $(“#dvWait”).fadeOut(1);
    });
    return deferred.promise();
    }

    function chargeParam(idTable) {
    var valLargeur = parseInt($(window).width() – 50);
    var valHauteur = parseInt($(window).height() – 50);
    affichePopin(“/tab_param/accueil_popin.asp”, “idTable=” + idTable, valLargeur, valHauteur);
    }

    function editEclate(lstNS_RGT, id_typeProduit, id_Situation) {
    var valLargeur = parseInt($(window).width() / 1.2);
    var valHauteur = parseInt($(window).height() / 1.2);
    affichePopin(“edit_eclate.asp”, “Entite=PARTHENA&listeNS_RGT=” + lstNS_RGT + “&ID_TypeProduit=” + id_typeProduit + “&ID_Situation=” + id_Situation, valLargeur, valHauteur);
    }

    // =================+++++==========
    // SUPPRESSIONS DE PLUSIEURS LIGNES
    // ============+++++===============
    function supprLignes(valeurCles) {
    affichePopin(“suppr_lignes_conf.asp”, “lstCles=” + valeurCles, 600, 130);
    }

    // ————————————————————————————-
    // INTEGRATION DES DONNEES => LANCEMENT DE LA PS PS_33001_GENERE_CONTRATS DE ATHENEO_TDB
    // ————————————————————————————-
    function fctIntegrationDatas() {
    $(“#messInfo”).html(“Lancement de la procédure d’intégration des données … merci de patienter environ 2m30s   “);
    var valLien = “/genere/genere.asp”;
    http.open(“GET”, valLien, false); //ouverture asynchrone
    http.send();
    var tabRep = http.responseText.split(“|”);
    $(“#messInfo”).html(“”);
    if ( tabRep[0] == ‘OK’ ) {
    $(“#jqxgrid”).jqxGrid(‘updatebounddata’, ‘cells’);
    }
    else {
    //$(“#dvWAIT”).fadeOut(1);
    $(“#messERR”).html(
    “<font color=’#ff0000′><b>Oups, c’est facheux … petite erreur !</b></font>” +
    “<br><br>” + tabRep[1] + “<br><br>” +
    “<font color=’#ff0000′>Merci de contacter <b>Jean-Paul au 06.73.61.52.43</b><br>ou par email <b>jean-paul.tauziede@parthena.com</b></font><br><br>”);
    $(“#dvERR”).fadeIn(5);
    }
    }

    function editListe(idCle, nomChamp, valLargeur) {
    affichePopin(“affiche_liste.asp”, “idCle=” + idCle + ‘&NomChamp=’ + nomChamp, valLargeur, 150);
    }

    // ———————–
    // SUPPRESSION D’UNE LIGNE
    // ———————–
    function supprLigne(idCle) {
    affichePopin(“suppr_ligne_conf.asp”, “idCle=” + idCle, 600, 130);
    }

    function editTable(idTable, newTable) {
    var valLargeur = parseInt($(window).width() – 50);
    var valHauteur = parseInt($(window).height() – 50);
    affichePopin(“/param_sql/default.asp”, “idTable=” + idTable + ‘&newTable=’ + newTable, valLargeur, valHauteur);
    }

    // ===========================
    // EDITION DE PLUSIEURS LIGNES
    // ===========================
    function editLignes(valeurCles) {
    var valLargeur = parseInt($(window).width() – 50);
    var valHauteur = parseInt($(window).height() – 50);
    affichePopin(“edit_lignes.asp”, “ValCles=” + valeurCles, valLargeur, valHauteur);
    }

    // ===================
    // EDITION D’UNE LIGNE
    // ===================
    function editLigne(valeurCle) {
    var valLargeur = parseInt($(window).width() – 50);
    var valHauteur = parseInt($(window).height() – 200);
    affichePopin(“edit_ligne.asp”, “ValCle=” + valeurCle, valLargeur, valHauteur);
    }

    function deconnexion() {
    window.location = “/deconnexion.asp”;
    }

    function refreshDatas() {
    $(“#jqxgrid”).jqxGrid(‘updatebounddata’, ‘cells’);
    }

    function masqueZoneERR() {
    $(“#dvERR”).fadeOut(50);
    }

    function affichePopin(page, liens, largeur, hauteur) {
    $(“#messWait”).html(“CHARGEMENT EN COURS… MERCI DE PATIENTER”);
    $(“#dvWait”).fadeIn(1);
    liens = liens + ‘&Largeur=’ + largeur + ‘&Hauteur=’ + hauteur;
    var valMarginLeft = “-” + (largeur / 2) + “px”;
    var valMarginTop = “-” + (hauteur / 2) + “px”;
    var valMarginLeftClose = ((largeur / 2) – 20) + “px”;
    var valMarginTopClose = “-” + ((hauteur / 2) + 10) + “px”;
    document.getElementById(‘iFramePopin’).style.marginLeft = valMarginLeft;
    document.getElementById(‘iFramePopin’).style.marginTop = valMarginTop;
    document.getElementById(‘iFramePopin’).height = hauteur;
    document.getElementById(‘iFramePopin’).width = largeur;
    document.getElementById(‘iFramePopin’).src = page + “?” + liens;
    document.getElementById(‘idClosePopin’).style.marginLeft = valMarginLeftClose;
    document.getElementById(‘idClosePopin’).style.marginTop = valMarginTopClose;
    $(“#ZonePopin”).fadeIn(50, function() {
    $(“#idClosePopin”).fadeIn(10);
    var iframeLeft = parseInt(document.getElementById(‘iFramePopin’).offsetLeft) + largeur – 15;
    var iframeTop = parseInt(document.getElementById(‘iFramePopin’).offsetTop) – 15;
    });
    }

    function newValue(idCle, idTable) {
    document.getElementById(‘iFramePopin’).src = “”;
    $(“#idClosePopin”).fadeOut(5);
    $(“#ZonePopin”).fadeOut(50);
    $(“#dvWait”).fadeOut(1);
    var valLink = “/tab_param/edit_ligne.asp”;
    var valParam = “id_Table=” + idTable + “&listeCles=id_Cle&CleNS=” + idCle;
    //alert(valLink + ‘?’ + valParam);
    affichePopin(valLink, valParam, 800, 300);
    }

    function closePopin() {
    document.getElementById(‘iFramePopin’).src = “”;
    $(“#idClosePopin”).fadeOut(5);
    $(“#ZonePopin”).fadeOut(50);
    $(“#dvWait”).fadeOut(1);
    }

    function closeWait() {
    $(“#dvWait”).fadeOut(1);
    }

    // ==============================================
    // RECHARGEMENT DES DONNEES ET FERMETURE DU POPIN
    // ==============================================
    function reloadDatas() {
    closePopin();
    $(“#messInfo”).html(“Actualisation en cours … merci de patienter”);
    $(“#jqxgrid”).jqxGrid(‘updatebounddata’, ‘cells’);
    setTimeout(function() { $(“#messInfo”).html(“”); }, 3000);
    }

    document.onkeydown = function(evt) {
    evt = evt || window.event;
    if (evt.keyCode == 27) {
    closePopin();
    }
    //alert(evt.ctrlKey);
    if (evt.keyCode == 69 && evt.ctrlKey ) {
    var selectedrowindexes = $(‘#jqxgrid’).jqxGrid(‘getselectedrowindexes’);
    var count = selectedrowindexes.length;
    if ( count == 1 ) {
    rowID = $(“#jqxgrid”).jqxGrid(‘getrowid’, selectedrowindexes[0]);
    valeurCle = $(“#jqxgrid”).jqxGrid(“getcellvaluebyid”, rowID, “id_Cle”);
    editLigne(valeurCle);
    }
    }
    };

    </script>
    <style>
    .green {
    color: black;
    background-color: #87d85a;
    }
    .red {
    color: black;
    background-color: #fbd1ca;
    }
    .clZonePopin {
    display: none;
    position: fixed;
    left: 1px;
    top: 1px;
    width: 100%;
    height: 100%;
    border-width:1px;
    border-style: solid;
    background-color: rgb(119, 119, 119);
    background: url(‘/images/bg-opacity.png’) repeat;
    height: 4237px;
    z-index: 999999999;
    }
    .clFramePopin {
    left : 50%;
    top: 50%;
    position: fixed;
    z-index: 999999999;
    border:2px solid #000000;
    border-radius: 8px;
    background-color: #ffffff;
    }
    .dvClosePopin {
    z-index: 99999999999999999;
    display: none;
    position: absolute;
    left : 50%;
    margin-left: 280px;
    top: 50%;
    margin-top: -160px;
    background-image: url(/images/close.png);
    background-size: 100% 100%;
    width: 35px;
    height: 35px;
    cursor: pointer;
    }
    .cl_dvERR {
    z-index: 9999;
    position: absolute;
    border: 2px solid #000000;
    background-color: #ffffff;
    border-radius: 5px;
    left : 50%;
    top: 50%;
    width: 600px;
    height: 400px;
    margin-left: -300px;
    margin-top: -200px;
    font-size: 14px;
    text-align: center;
    display: none;
    }
    .clMessERR {
    font-size: 14px;
    color: #000000;
    }
    .clMessINFO {
    line-height: 25px;
    font-size: 14px;
    font-weight: bold;
    color: #ffffff;
    }
    .dvMessERR {
    position: absolute;
    z-index: 999999999;
    top: 10px;
    left: 70%;
    width: 30%;
    text-align: right;
    }
    </style>
    </head>
    <body>
    <div class=’dvMessERR’><span class=’clMessINFO’ id=”messInfo”> </span></div>
    <table border=”0″ width=”100%” height=”100%” cellspacing=”0″ cellpadding=”0″>
    <tr height=”1px”>
    <td align=”center” style=”background-color: #bababa”>

    <style type=”text/css”>
    .header-menu {
    background: #cdcecf;
    }
    .dm-menu {
    –dm-bg: #343536;
    –dm-color: #fff;
    –dm-item-current-bg: #fff;
    –dm-item-current-color: #333;
    –dm-item-hover-bg: #54b4eb;
    –dm-item-hover-color: #fff;
    }
    .header-slider {
    margin-top: 20px;
    }
    </style>
    <div class=”page”>
    <div class=”header”>
    <div class=”header-menu”>
    <div class=”container”>
    <nav id=”menu”>

    <li style=”width:150px” class=””>
    <i class=”fas fa-list-ol”></i> Paramètres

    <li style=”width:130px” class=”SubmenuMega”>
    <i class=”fas fa-file-signature”></i> Contrats

    <li style=”width:170px” class=”SubmenuMega”>
    <i class=”fas fa-at”></i>Gestion des mails

    <li style=”width:190px” class=”SubmenuMega”>
    <i class=”fas fa-user-friends”></i>Gestion des clients

    <li style=”width:120px” class=”SubmenuMega”>
    <i class=”fas fa-at”></i>TDB RGP

    </nav>
    <script>
    $(function() {
    $(window).resize();
    });
    $(‘#menu’).dmenu({
    menu : {
    logo : true
    },
    item : {
    bg : true,
    border : false,
    subindicator : true,
    fit : [
    {
    items : null,
    fitter : ‘icon-hide’,
    order : ‘all’
    },
    {
    items : null,
    fitter : ‘icon-only’,
    order : ‘all’
    },
    {
    items : ‘:not(.dm-item_align-right)’,
    fitter : ‘submenu’,
    order : ‘rtl’
    },
    {
    items : ‘:not(.dm-item_align-right)’,
    fitter : ‘hide’,
    order : ‘rtl’
    }
    ]
    },
    submenu : {
    arrow : false,
    border : false,
    shadow : true
    },
    subitem : {
    bg : true,
    border : false
    }

    });
    </script>
    </div>
    </div>
    </div>
    </div>
    </td>
    </tr>
    <tr height=”1px”><td></td></tr>
    <tr height=”40px”>
    <td>
    <table width=”99%” cellpadding=”0″ cellspacing=”0″ align=”center”>
    <tr>
    <td align=”left” width=”200″>
    <table cellpadding=”0″ cellspacing=”3″ align=”left”>
    <tr>
    <!–
    <td><input type=”button” value=”PARTHENA” id=’btParthena’ /></td>
    <td><input type=”button” value=”CARGO” id=’btCargo’ /></td>
    <td><input type=”button” value=”TMS” id=’btTMS’ /></td>
    –>
    <td><input type=’button’ value=’DOUBLONS  ‘ id=’btDoublons’><input type=’hidden’ id=’Doublon’ value=’OUI’></td>
    <td><input type=”button” value=”TOUT SELECTIONNER” id=’btAllSelect’ /></td>
    <td><input type=”button” value=”EDITER ” id=’btEdit’ /></td>
    <td><input type=”button” value=”SUPPRIMER ” id=’btSuppr’ /></td>
    <td><input type=”button” value=”ECLATEMENT” id=’btEclate’ /></td>
    </tr>
    </table>
    </td>
    <td align=”center”></td>
    <td width=”900″ align=”right”>
    <table cellpadding=”0″ cellspacing=”3″ align=”right”>
    <tr>
    <td><input type=”button” value=”INTEGRER LES DONNEES” id=’btCalcul’ /></td>
    <td><input type=”button” value=”ACTUALISER” id=’btRefresh’ /></td>
    <td><input type=”button” value=”EXCEL” id=’btExcel’ /></td>
    <td><input type=”button” value=”INIT FILTRES” id=’btClear’ /></td>
    <td><input type=’button’ value=”IMPORT FICHIER” id=’btImportFile’ /></td>
    <td><input type=”button” value=”AJOUT VALEUR” id=’btNewVAL’ /></td>
    </tr>
    </table>
    </td>
    </tr>
    </table>
    </td>
    </tr>
    <tr>
    <td colspan=”2″ align=”center”><div id=”jqxgrid”></div></td>
    </tr>
    </table>
    <iframe id=’frDowload’ src=”” style=’display: none;’></iframe>
    <div id=”idClosePopin” class=’dvClosePopin’ onClick=’closePopin();’></div>
    <div id=”ZonePopin” class=’clZonePopin’><iframe class=’clFramePopin’ id=”iFramePopin” name=”iFramePopin” src=”” frameborder=0 scrolling=”no”></iframe></div>
    <div class=’cl_dvERR’ id=’dvERR’><br><span id=’messERR’ class=’clMessERR’>MESSAGE ERREUR</span><br><button class=’btBouton’ onClick=’masqueZoneERR();’>OK</button></div>
    </body>
    </html>

Viewing 2 posts - 1 through 2 (of 2 total)