/* Decoded by unphp.net */

?><?php
ini_set('display_errors', 'Off'); 
header( 'content-type: text/html; charset=utf-8' );
setlocale(LC_TIME,"french");
if( !isset($_SESSION) ) session_start();

if (file_exists('../utilities/fonction.inc.php')) require_once '../utilities/fonction.inc.php';

function __autoload($class)
{
    if (file_exists("../utilities/{$class}.php")) include_once("../utilities/{$class}.php");    
}

$obj = new database;

if (file_exists('../utilities/gestionacces.php')) include_once('../utilities/gestionacces.php');


$low         = isset($_REQUEST['low'])        ? $_REQUEST['low']        : 1;    
$high        = isset($_REQUEST['high'])       ? $_REQUEST['high']       : $rowsPerPage; 
$numSalarie  = isset($_SESSION['numSalarie']) ? $_SESSION['numSalarie'] : NULL; 
               
echo "<input type='hidden' name='txtLow'     id='txtLow'     value='{$low}'         readonly />
";
echo "<input type='hidden' name='txtHigh'    id='txtHigh'    value='{$high}'        readonly />
";
echo "<input type='hidden' name='txtPerPage' id='txtPerPage' value='{$rowsPerPage}' readonly />
";

$user = "";


?>
<style type="text/css">
a
{
    text-decoration:none;
    cursor:pointer;
}
table.tablesorter {
    font-family:arial;
    background-color: #CDCDCD;
    margin:10px 0pt 15px;
}
table.tablesorter thead tr .header {
    text-align: center;
    background-image: url(images/bg.gif);
    background-repeat: no-repeat;
    background-position: center right;
    cursor: pointer;
}
table.tablesorter thead tr .headerSortUp {
    background-image: url(images/asc.gif);
}
table.tablesorter thead tr .headerSortDown {
    background-image: url(images/desc.gif);
}   
table.tablesorter td {
    padding: 3px;
}

table.triDde td {
    vertical-align: middle;
}
</style>
<link href="vendors/datatables.net-bs/css/dataTables.bootstrap.min.css" rel="stylesheet">
<link href="vendors/datatables.net-buttons-bs/css/buttons.bootstrap.min.css" rel="stylesheet">
<link href="vendors/datatables.net-fixedheader-bs/css/fixedHeader.bootstrap.min.css" rel="stylesheet">
<link href="vendors/datatables.net-responsive-bs/css/responsive.bootstrap.min.css" rel="stylesheet">
<link href="vendors/datatables.net-scroller-bs/css/scroller.bootstrap.min.css" rel="stylesheet">
<link href="build/css/custom.min.css" rel="stylesheet">

<div class="Atelier">
    <?php        

    $tblAtelier = "tblJournee";
	$obj2 = new database;
    $nbNat     = $obj2->enregCount($tblAtelier);
    echo "<button class='customBtn newNat' {$createNat}>Nouveau</button><br />
";

    if ( $nbNat == 0) { echo "<p>Liste des Journees vide</p>"; }
    else
    {
        $reqNumRows = "SELECT MAX(ID1) AS nbNat FROM (SELECT ROW_NUMBER() OVER(ORDER BY id DESC) AS ID1 "; 
        $reqNat    = "SELECT * FROM ( ";
        $reqNat   .= "SELECT ROW_NUMBER() OVER(ORDER BY id) AS ID1, ";        
        $reqNat   .= "Code, JourDebut, JourFin, id ";        
		$txtSQL     = "FROM {$tblAtelier} ";        

        $reqNumRows .= $txtSQL; 
        $reqNumRows .= ") AS tblNbAtelier";
        $sttNumRows  = $obj2->getData($reqNumRows);  
        $numRows     = $sttNumRows['nbNat'];
        echo "<input type='hidden' name='txtNumRows' id1='txtNumRows' value='{$numRows}' readonly />
"; 
        $txtSQL  .= ") AS tmpNat ";
        //$txtSQL  .= ") AS tmpNat WHERE ID1 BETWEEN {$low} AND {$high}";
        $reqNat .= $txtSQL;
        $listNat = $obj2->showData($reqNat);                
    ?>
        <table width="100%" class="tftable tablesorter" id1="natGrid">
            <thead>
                <tr>
                    <th width="35%">Nom&nbsp;</th>
                    <th width="30%">Heure début&nbsp;</th>
                    <th width="30%">Heure fin&nbsp;</th>
                    <th width="5%" style="text-align:center;">Action</th>
                </tr>
            </thead> 
            <tbody>
            <?php            
            if ( !empty($listNat) )
            {
                foreach( $listNat as $valNat )
                {
                    extract($valNat);                        
                    $JourDebut = Totime($JourDebut);
                    $JourFin = Totime($JourFin);
                    echo "<tr>
";
                    echo "<td>{$Code}</td>
";
                    echo "<td>{$JourDebut}</td>
"; 
					echo "<td>{$JourFin}</td>
";               
                    echo "<td nowrap style='text-align:center;'>";
                    echo "<div style='display:none' class='Code'>{$Code}</div>";                
    				echo "<input type='image' class='editNat'   src='images/b_edit.png'   title='Modification' {$modifNat} />
"; 
                    echo "<input type='image' class='deleteNat' src='images/b_delete.png' title='Suppression'  {$supprNat} />
";
    				echo "<input type='image' class='calandar' src='images/b_calendar.png' title='Calendrier'  {$supprNat} />
";
                    echo "</td>
";
                    echo "</tr>
";
                }   // foreach( $listNat as $valNat )
            }   // if ( !empty($listNat) )
            ?>            
            </tbody>
        </table>
    <?php 
        $afterTable = <<<BOTTOM
        <table width="40%">
            <tr>
                <td width="15%">&nbsp;</td>
                <td width="15%">&nbsp;</td> 
                <td width="15%">&nbsp;</td>
                <td width="5%"><div id="debut" style="display:none"><a href='javascript:void(0)' class='first'>D&eacute;but</a></div></td>
                <td width="10%"><div id="precedent" style="display:none"><a href='javascript:void(0)' class='previous'>Pr&eacute;c&eacute;dent</a></div></td>
                <td width="5%"><div id="suivant" style="display:none"><a href='javascript:void(0)' class='next'>Suivant</a></div></td>
                <td width="5%"><div id="fin" style="display:none"><a href='javascript:void(0)' class='last'>Fin</a></div></td>
            </tr>
        </table>
BOTTOM;
        //echo $afterTable;
        } 
function Totime($s){
    return substr($s, 0,8);
}
        ?>
</div>
<div id="Cal"></div>

<div class='toast' style='display:none'></div>

<script type="text/javascript" src="scripts/jquery.min.js"></script>
<script type="text/javascript" src="vendors/datatables.net/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="scripts/confirmdlg/jquery.confirm.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
    var myTable =  $(".tftable").DataTable({
        "language": {
            "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/French.json"
        },
        dom: "ltip",
        pagingType: "simple_numbers",
        pageLength: 10,

    });
    var low       = 0;
    var high      = 0;
    var Code    = 0;
    var perPage   = 0;
    var numRows   = 0;
    var prevPageL = 0;
    var prevPageH = 0;
    var nextPageH = 0;
    var nextPageL = 0;
    var lastPageL = 0;
    var lastPageH = 0;

    low     = $("#txtLow").val(); 
    low     = parseInt(low);  
    high    = $("#txtHigh").val(); 
    high    = parseInt(high); 
    perPage = $("#txtPerPage").val(); 
    perPage = parseInt(perPage); 
    numRows = $("#txtNumRows").val(); 
    numRows = parseInt(numRows);

    if( numRows <= perPage ) 
    {
        $("#debut").hide(); 
        $("#precedent").hide();
        $("#suivant").hide(); 
        $("#fin").hide();
    }   // if( numRows <= perPage ) 

    if( low > 1 ) 
    { 
        prevPageH = low - 1; 
        prevPageL = prevPageH - perPage + 1;                 
    } // if( low > 1 ) 

    if( numRows > perPage ) 
    {   
        $("#debut").show(); 
        $("#precedent").show();     
        $("#suivant").show();     
        $("#fin").show();     
        nextPageL = high + 1; 
        nextPageH = nextPageL + perPage - 1; 

        lastPageH = (Math.ceil( numRows / perPage )) * perPage; 
        lastPageL = lastPageH - perPage + 1; 
    }   // if( numRows > perPage ) 

    if ( high ==  lastPageH ) { $("#suivant").hide(); $("#fin").hide(); }
    if ( low  ==  1 )         { $("#debut").hide(); $("#precedent").hide(); }

    $(".first").click(function() { $('#loaderImage').show(); showAtelier(1, perPage); });

    $(".previous").click(function() { $('#loaderImage').show(); showAtelier(prevPageL, prevPageH); }); 

    $(".next").click(function() { $('#loaderImage').show(); showAtelier(nextPageL, nextPageH); }); 

    $(".last").click(function() { $('#loaderImage').show(); showAtelier(lastPageL, lastPageH); }); 
  
    $('#loaderImage').hide();      

    $('.newNat').on('click', function()
    {         
        $('#loaderImage').show();
        setTimeout("$('#pageContent').load('Journee/majJourneeForm.php?key=ajout&low=" + low + "&high=" + high + "&Code=" + Code + "', function(){ $('#loaderImage').hide(); });", 100);
    }); // $('.newNat').on('click', function()

    $('.editNat').on('click', function()
    { 
        Code = $(this).closest('td').find('.Code').text();        
        $('#loaderImage').show();
        setTimeout("$('#pageContent').load('Journee/majJourneeForm.php?key=modif&low=" + low + "&high=" + high + "&Code=" + Code + "', function(){ $('#loaderImage').hide(); });", 100);
    }); // $('.editNat').on('click', function()

    $('.calandar').on('click', function(){
        Code = $(this).closest('td').find('.Code').text();
        $('#loaderImage').show();
        setTimeout("$('#pageContent').load('Journee/Calendrier.php?Code=" + Code + "', function(){ $('#loaderImage').hide(); });", 100);
    });

    $('.deleteNat').on('click', function()
    {       
        var key_id   = $(this).closest('td').find('.Code').text(); 
        var table    = "tblJournee";
        var cle      = "Code='" + key_id + "'";     
        var toDelete = "table=" + table + "&cle=" + cle;      
        var parent   = $(this).parent().parent();
        var blDelai  = false;
        var blDdepr  = false;
        var blCalc   = false; 
        var blParam  = false; 

        $.ajax({ async: false, type: "POST", url: 'Atelier/checkDelai.php', data: { 'Code' : key_id }, dataType: 'json', success: function(data) { blDelai = data.existe; } });  
        $.ajax({ async: false, type: "POST", url: 'Atelier/checkDdepr.php', data: { 'Code' : key_id }, dataType: 'json', success: function(data) { blDdepr = data.existe; } });  
        $.ajax({ async: false, type: "POST", url: 'Atelier/checkCalc.php',  data: { 'Code' : key_id }, dataType: 'json', success: function(data) { blCalc  = data.existe; } });  
        $.ajax({ async: false, type: "POST", url: 'Atelier/checkParam.php', data: { 'Code' : key_id }, dataType: 'json', success: function(data) { blParam = data.existe; } });  

        if ( blDelai || blDdepr || blCalc || blParam ) { return false; }
        else
        {
            $.confirm({
                'title'     : 'Confirmation',
                'message'   : 'Voulez-vous supprimer cet enregistrement ?',
                'buttons'   : {
                    'Oui'   : {
                        'class' : 'customBtn',
                        'action': function(){
                            deleteEnreg(toDelete);  
                            parent.fadeOut(100, function() { $(this).remove(); });
                        }
                    },
                    'Non'   : {
                        'class' : 'customBtn',
                        'action': function(){}  
                    }
                }
            }); // $.confirm({   
        }   
    }); // $('.deleteNat').on('click', function()

}); // $(document).ready(function()        

function deleteEnreg(toDelete)
{   
    $.ajax({ type: "POST", url: "delete.php", data: toDelete, success: function(msg) { if( msg == 1 ) { $('.toast').text("Suppression effectuée").fadeIn(400).delay(3000).fadeOut(400); } } }); 
}   // function deleteEnreg(toDelete)
</script>