| Server IP : 167.99.254.82 / Your IP : 216.73.216.231 Web Server : Apache System : Linux host.techisquad.com 5.15.0-187-generic #197-Ubuntu SMP Fri Jul 17 19:17:01 UTC 2026 x86_64 User : pawluxera ( 1011) PHP Version : 8.1.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /home/factures/public_html/ |
Upload File : |
<?php
session_start();
if (!isset($_SESSION['compte_user']))
{
header('Location: erreur_surfing.html');
exit();
}
unset($_SESSION['r_devis']);
$link = mysqli_connect("localhost", "advery", "EoM6IJlnirGIfcu","factures") or die("Impossible de se connecter : " . mysqli_error());
$reponse = "select * from comptes_user where id_clt = $_SESSION[compte_user] ;";
$exec =mysqli_query($link,$reponse);
$row = mysqli_fetch_assoc($exec);
$year = date("y");
if ($row['pic_user'] == 'Vide')
$pic = 'images/user_male.png';
else
$pic = $row['pic_user'];
?>
<!doctype html>
<html lang="fr">
<meta http-equiv="content-type" content="text/html;charset=windows-1251" />
<head>
<meta charset="utf-8">
<title> ADVERY | Bons De Livraison</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="author" content="YOSRY MLIKA">
<meta name="description" content="ADVERY - Espace ADMIN">
<link rel="shortcut icon" href="images/logo-xs.png" type="image/png">
<link href="css/datatables/dataTables.bootstrap.css" rel="stylesheet" type="text/css">
<link href="css/datatables/dataTables.colReorder.min.css" rel="stylesheet" type="text/css">
<link href="css/overlay-effects/overlay-effects.css" rel="stylesheet" type="text/css">
<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css">
<link href="css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="css/dripicons.min.css" rel="stylesheet" type="text/css">
<link href="css/animate/animate.css" rel="stylesheet" type="text/css">
<link href="css/hover/hover-min.css" rel="stylesheet" type="text/css">
<link href="css/styles.css" rel="stylesheet" type="text/css">
</head>
<body>
<div class="wrapper">
<nav class="navbar navbar-default navbar-fixed-top main-top-navbar">
<!-- <a href="EspaceAdmin.php" class="navbar-brand hidden-xs hidden-sm"><img alt="Admnistry Logo" src="images/logo.png"></a> -->
<a href="EspaceAdmin.php" class="navbar-brand visible-xs visible-sm"><img alt="Admnistry Logo" src="images/logo-xs.png"></a>
<ul class="nav navbar-nav navbar-left">
<li class="hidden-xs">
<button class="sidebar-toggle btn" data-tooltip="tooltip" data-placement="bottom" title="Menu"><i class="dripicons-menu"></i></button>
</li>
<li class="visible-xs">
<button class="sidebar-toggle-xs btn" data-tooltip="tooltip" data-placement="bottom" title="Menu"><i class="dripicons-menu"></i></button>
</li>
<?php $ren = "select count(*) from notification ;";
$exen = mysqli_query($link,$ren);
$numn = mysqli_fetch_row($exen);
if ( $numn['0']!= 0) { ?>
<li class="dropdown notifications-bar">
<button type="button" class="btn dropdown-toggle" data-toggle="dropdown" aria-expanded="true" data-tooltip="tooltip" data-placement="bottom">
<i class="dripicons-bell"></i>
</button>
<ul class="dropdown-menu navbar-dropdown-menu" data-dropdown-in="flipInX" data-dropdown-out="flipOutX" role="menu">
<li>
<div class="list-group list-group-with-big-icons margin-0">
<?php $rentf = "select * from notification order by (id_notif) DESC LIMIT 7;";
$exentf = mysqli_query($link,$rentf);
while ($rowntf = mysqli_fetch_assoc($exentf)) { ?>
<a class="list-group-item list-group-item-success">
<i class="<?php echo $rowntf['ico_notif']; ?>"></i>
<span class="label label-success"><?php echo $rowntf['dt_notif']; ?> / <?php echo $rowntf['source_notif']; ?></span>
<p><?php echo $rowntf['titre_notif']; ?></p>
<i class="fa fa-arrow-right"></i>
</a>
<?php } ?>
<a href="Notification.php" class="list-group-item list-group-item-danger">
<span class="label label-danger" style="font-size:18px">Afficher Toutes Les Notifications</span>
<i class="fa fa-arrow-right"></i>
</a>
</div>
</li>
</ul>
</li>
<?php } ?>
</ul>
<div class="site-search">
<form action=""> <i class="fa dripicons-search"></i>
<input type="text" placeholder="Recherche.." required>
</form>
</div>
<ul class="nav navbar-nav navbar-right">
<li class="dropdown user-menu">
<a role="button" aria-haspopup="true" aria-expanded="false"><img alt="User Image" class="img-circle" src="<?php echo $pic; ?>"><span class="hidden-xs"><?php echo $row['nom']; ?>
<small>Administrateur</small></span></a>
</li>
<li>
<button class="btn userbar-toggle" data-tooltip="tooltip" data-placement="bottom" title="Raccourcis"><i class="dripicons-scale"></i></button>
</li>
<li class="hidden-xs">
<button class="goaway btn text-red" data-tooltip="tooltip" data-placement="bottom" title="Déconnexion"><i class="dripicons-exit"></i></button>
</li>
</ul>
</nav>
<nav class="sidebar-wrapper navbar sidebar">
<div class="sidebar-inner">
<ul class="nav" id="side-menu">
<li><a href="EspaceAdmin.php"><i class="dripicons-home"></i><span class="li-text">Espace Admin</span></a>
</li>
<li><a href="articles_services.php"><i class="dripicons-gear"></i><span class="li-text">Articles / Services</span></a></li>
<li><a href="ste_rh.php"><i class="dripicons-user-group"></i><span class="li-text">Gestion STE / RH</span><span class="fa arrow"></span></a>
<ul class="nav nav-second-level">
<li><a href="ClientsPro.php"><span class="li-text">Clients Pro</span></a></li>
<li><a href="ClientsPart.php"><span class="li-text">Clients Particuliers</span></a></li>
</ul>
</li>
<li><a href="#"><i class="dripicons-document"></i><span class="li-text">Facturation</span><span class="fa arrow"></span></a>
<ul class="nav nav-second-level">
<li><a href="DEVIS.php"><span class="li-text">DEVIS</span></a></li>
<li><a href="Factures.php"><span class="li-text">Factures</span></a></li>
</ul>
</li>
<!--
-->
</ul>
</div>
</nav>
<div class="page-content-wrapper">
<div class="page-header margin-top-0">
<table width="100%">
<tr><td align="left"><h1><i class="dripicons-document"></i> Bons De Livraison</h1></td> <td align="right"><h1><a data-toggle="modal" data-target="#primary-modal" class="label label-primary margin-bottom-20px">Ajouter BL</a></h1></td></tr>
</table>
</div>
<?php $reponse = "select count(*) from bon_livraison where etat_bl != 'Valide';";
$exec =mysqli_query($link,$reponse);
$num = mysqli_fetch_row($exec);
$reponse1 = "select count(*) from bon_livraison where etat_bl = 'Valide';";
$exec1 = mysqli_query($link,$reponse1);
$num1 = mysqli_fetch_row($exec1); ?>
<div class="row">
<div class="col-sm-12">
<div class="panel bg-facebook margin-bottom-20px">
<div class="panel-body">
<div align="center"><h3 class="margin-top-0 margin-bottom-5px"># Bons De Livraison <i class="fa dripicons-pulse pull-right"></i></h3></div>
<br><ul class="row vertical-bordered-blocks text-center">
<li class="col-xs-4">
<span class="text-lg">Statistiques</span>
<strong>ADMIN</strong>
</li>
<li class="col-xs-4">
<span class="text-lg"><?php echo $num['0']; ?></span>
<strong><i class="fa fa-fw fa-arrow-up"></i>BL En Attente</strong>
</li>
<li class="col-xs-4">
<span class="text-lg"><?php echo $num1['0']; ?></span>
<strong><i class="fa fa-fw fa-arrow-up"></i>BL Validés</strong>
</li>
</ul>
</div>
</div>
</div>
</div>
<div class="clearfix"></div>
<div class="row">
<div class="col-md-12">
<div class="panel panel-default">
<div class="panel-body">
<div class="row">
<div class="col-md-12">
<div class="panel panel-default" id="tabledb2">
<div class="panel-heading">
<div class="panel-title">Liste Des BL <small>Enregistrés dans la base de données</small>
</div>
</div>
<?php $reponse3 = "select count(*) from bon_livraison ;";
$exec3 = mysqli_query($link,$reponse3);
$num3 = mysqli_fetch_row($exec3);
if ( $num3['0']!= 0)
{
$reas = "select * from bon_livraison order by (ref_bl) DESC;";
$exas = mysqli_query($link,$reas);
$i = 1;
?>
<div class="panel-body">
<table id="datatablebonlivraison" class="table table-striped">
<thead>
<tr>
<th>Référence</th>
<th>Client</th>
<th>Date</th>
<th>État</th>
<th>Facture</th>
</tr>
</thead>
<tbody>
<?php while ($rowas = mysqli_fetch_assoc($exas)) { ?>
<tr>
<td><a href="Select_BL.php?aux=<?php echo $rowas['ref_bl']; ?>"><strong><?php echo $rowas['ref_bl']; ?></strong></a></td>
<td><a href="Select_BL.php?aux=<?php echo $rowas['ref_bl']; ?>"><strong><?php
$reponse12 = "select * from comptes_user where id_clt = $rowas[ref_client] ;";
$exec12 = mysqli_query($link,$reponse12);
$row12 = mysqli_fetch_assoc($exec12);
echo $row12['nom']; ?></strong></a></td>
<td><strong><?php echo $rowas['dt_bl']; ?></strong></td>
<td><strong><?php echo $rowas['etat_bl']; ?></strong></td>
<td><strong><?php $repbl = "select count(*) from bl_facture where refe_bl = '$rowas[ref_bl]';";
$exbl = mysqli_query($link,$repbl);
$numbl = mysqli_fetch_row($exbl);
if ( $numbl['0'] == 0 )
echo ' ';
else
{
$reponse12bl = "select * from bl_facture where refe_bl = '$rowas[ref_bl]' ;";
$exec12bl = mysqli_query($link,$reponse12bl);
$row12bl = mysqli_fetch_assoc($exec12bl);
?><a href="Select_facture_bl.php?aux=<?php echo $row12bl['refe_facture']; ?>"><?php echo '-> '.$row12bl['refe_facture']; ?></a> <?php
}?>
</strong></td>
</tr>
<?php $i ++; } ?>
</tbody>
</table>
</div>
<?php } ?>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<nav class="bottom-bar">
<button class="btn scrollToTop pull-right" data-tooltip="tooltip" data-placement="top" title="En Tête"><i class="dripicons-arrow-up"></i></button>
</nav>
<nav class="userbar-wrapper">
<div class="tabs tabs-default-dark">
<ul id="myTab" class="nav nav-tabs nav-justified" role="tablist">
<li class="active"><a href="#userbarHome" role="tab" data-toggle="tab"><i class="dripicons-user"></i></a></li>
<li><a href="#userbarEvents" role="tab" data-toggle="tab"><i class="dripicons-calendar"></i></a></li>
</ul>
<div id="myTabContent" class="tab-content">
<div class="tab-pane active" id="userbarHome">
<div class="user-main-area text-center">
<div class="user-img margin-bottom-10px">
<img src="<?php echo $pic; ?>">
</div>
<h4><?php echo $row['nom']; ?></h4>
<span class="label label-danger margin-bottom-20px">Administrateur</span><br>
<ul class="list-unstyled launcher-pad">
<li class="col-xs-4"><a class="hvr-pop" href="DEVIS.php"><i class="dripicons-blog"></i>DEVIS</a>
</li>
<li class="col-xs-4"><a class="hvr-pop" href="Factures.php"><i class="dripicons-document"></i>Factures</a>
</li>
<li class="col-xs-4"><a class="hvr-pop" href="#"><i class="dripicons-inbox"></i>Messages</a>
</li>
<li class="col-xs-4"><a class="hvr-pop" href="ClientsPro.php"><i class="dripicons-briefcase"></i>STE / Pro</a>
</li>
<li class="col-xs-4"><a class="hvr-pop" href="ClientsPart.php"><i class="dripicons-user"></i>Particuliers</a>
</li>
<li class="col-xs-4"><a class="hvr-pop" href="FAQ.html"><i class="dripicons-question"></i>FAQ</a>
</li>
</ul>
<div class="clearfix"></div>
</div>
</div>
<div class="tab-pane" id="userbarEvents">
<div class="date-lg" id="displayMoment"></div>
<div class="userbar-calendar">
<div id="userbar-calendar"></div>
</div>
</div>
</div>
</div>
</nav>
</div>
<!-- Deconnexion -->
<div class="modal modal-danger-filled" id="signout" data-easein="bounceIn" data-easeout="bounceOut">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-body text-center padding-bottom-0">
<i class="fa-5x dripicons-exit display-block"></i>
<h5 class="margin-top-0">Êtes-vous sûr de vouloir vous déconnecter?</h5>
</div>
<div class="modal-footer text-center">
<button type="button" class="btn btn-default" id="yesigo">OUI</button>
<button type="button" class="btn btn-default" data-dismiss="modal">NON</button>
</div>
</div>
</div>
</div>
<!-- Article -->
<div class="modal modal-primary fade" id="primary-modal" tabindex="-1" role="dialog" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal"><span aria-hidden="true"><i class="fa fa-times"></i></span><span class="sr-only">Close</span>
</button>
<h4 class="modal-title">Nouveau BL</h4>
</div>
<div class="modal-body">
<form class="form-horizontal">
<fieldset>
<div class="form-group">
<label class="col-md-3 control-label" for="textinput-normal">Référence BL </label>
<div class="col-md-9">
<?php $retour =mysqli_query($link,'SELECT MAX(id_bl) AS nbMax FROM bon_livraison WHERE `refe_system_fisc` = YEAR(CURRENT_DATE()) ');
$valeur = mysqli_fetch_assoc($retour);
$a = $valeur['nbMax'];
$a ++ ;
$x ='BL0'.$year.'/'.$a; ?>
<input type="text" class="form-control input-md" id="inp-type-1" value="<?php echo $x; ?>" name="referen" disabled>
<input type="hidden" class="form-control input-md" value="<?php echo $x; ?>" name="reference" >
</div>
</div>
<div class="form-group">
<div class="col-md-12">
<?php $reponse3 = "select count(*) from comptes_user where type_user like 'Client%';";
$exec3 = mysqli_query($link,$reponse3);
$num3 = mysqli_fetch_row($exec3);
if ( $num3['0']!= 0)
{
$reas = "select * from comptes_user where type_user like 'Client%';";
$exas = mysqli_query($link,$reas);
?>
<table id="list_clients" class="table table-striped">
<thead>
<tr>
<th>Code</th>
<th>Rais-Soc / Nom</th>
<th>Identifiant</th>
<th>Type</th>
</tr>
</thead>
<tbody>
<?php while ($rowas = mysqli_fetch_assoc($exas)) { ?>
<tr>
<td><a href="Ajout_BL.php?aux=<?php echo $rowas['id_clt']; ?>"><strong><?php if ($rowas['type_user'] == 'Client Pro'){$a='Pr';} else {$a='Pa';} echo $a.'-'.$rowas['id_clt']; ?></strong></a></td>
<td><a href="Ajout_BL.php?aux=<?php echo $rowas['id_clt']; ?>"><strong><?php echo $rowas['nom']; ?></strong></a></td>
<td><strong><?php echo $rowas['identificateur_client']; ?></strong></td>
<td><strong><?php echo $rowas['type_user']; ?></strong></td>
</tr>
<?php } ?>
</tbody>
</table>
<?php }
else { echo'<strong>Aucun Client</strong>'; }?>
</div>
</div>
</fieldset>
</div>
<div class="modal-footer">
<button type="button" class="btn btn-warning" data-dismiss="modal">Annuler</button>
</div>
</form>
</div>
</div>
</div>
<script type="text/javascript" src="js/vendors/jquery/jquery.min.js"></script>
<script type="text/javascript" src="js/vendors/jquery/jquery-ui.min.js"></script>
<script type="text/javascript" src="js/vendors/bootstrap/bootstrap.min.js"></script>
<script type="text/javascript" src="js/vendors/oakenwidgets/jquery.oakenwidgets.min.js"></script>
<script type="text/javascript" src="js/vendors/metismenu/metisMenu.min.js"></script>
<script type="text/javascript" src="js/vendors/sparkline/jquery.sparkline.min.js"></script>
<script type="text/javascript" src="js/vendors/bootstrap-modal-animation/animation.js"></script>
<script type="text/javascript" src="js/vendors/moment/moment.min.js"></script>
<?php /*
<script type="text/javascript" src="js/vendors/vmap/jquery.vmap.min.js"></script>
<script type="text/javascript" src="js/vendors/vmap/jquery.vmap.sampledata.js"></script>
<script type="text/javascript" src="js/vendors/vmap/jquery.vmap.world.js"></script>
<script type="text/javascript" src="js/vendors/vmap/vmap-samples.js"></script>
<script type="text/javascript" src="js/vendors/flotchart/jquery.flot.min.js"></script>
<script type="text/javascript" src="js/vendors/flotchart/jquery.flot.resize.min.js"></script>
<script type="text/javascript" src="js/vendors/flotchart/jquery.flot-tooltip.js"></script>
<script type="text/javascript" src="js/vendors/flotchart/flotchart-examples.js"></script>
<script type="text/javascript" src="js/vendors/sparkline/sparklines-examples.js"></script>
*/ ?>
<script type="text/javascript" src="js/scripts.js"></script>
<?php /*
<script type="text/javascript" src="js/vendors/chartjs/Chart.min.js"></script>
<script type="text/javascript" src="js/vendors/chartjs/chartjs-examples.js"></script>
<script type="text/javascript" src="js/vendors/datatables/datatables-examples.js"></script>
*/ ?>
<script type="text/javascript" src="js/vendors/datatables/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="js/vendors/datatables/dataTables.bootstrap.js"></script>
<script type="text/javascript" src="js/vendors/datatables/dataTables.colReorder.min.js"></script>
<script type="text/javascript" >
$(document).ready(function() {
$('#datatablebonlivraison').DataTable();
$('#list_clients').DataTable();
});
</script>
</body>
</html>