| 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['r_client']))
{
header('Location: Factures.php');
exit();
}
$link = mysqli_connect("localhost", "advery", "EoM6IJlnirGIfcu","factures") or die("Impossible de se connecter : " . mysqli_error());
$reponse = "select * from comptes_user where id_clt = $_SESSION[r_client] ;";
$exec =mysqli_query($link,$reponse);
$row = mysqli_fetch_assoc($exec);
$year = date("y");
?>
<!doctype html>
<html lang="fr">
<meta http-equiv="content-type" content="text/html;charset=windows-1251" />
<head>
<meta charset="utf-8">
<title> ADVERY | Facture</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/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>
<?php
if ($row['pic_user'] == 'Vide')
$pic = 'images/user_male.png';
else
$pic = $row['pic_user']; ?>
<body>
<div class="row">
<div class="col-md-3">
</div>
<div class="col-md-6">
<div class="panel">
<div class="panel-body">
<div class="row">
<div class="col-xs-12">
<h3 class="margin-top-0"><?php echo $row['nom']; ?></h3><hr>
<ul class="row vertical-bordered-blocks">
<li class="col-xs-3 text-center">
<h3 class="margin-0"><span class="label label-danger"><?php echo $row['type_user']; ?></span></h3>
<small>Type</small>
</li>
<li class="col-xs-6 text-center">
<h3 class="margin-0"><?php echo $row['identificateur_client']; ?></h3>
<small>Identifiant</small>
</li>
<li class="col-xs-3 text-center">
<h3 class="margin-0"><?php if ( $_POST['dest'] == 'Standard' ) {
$retour =mysqli_query($link,'SELECT count(id_facture) AS nbMax FROM factures where type_facture = "Standard" ');
$valeur = mysqli_fetch_assoc($retour);
$a = $valeur['nbMax'];
$a ++ ;
$x ='F0'.$year.'/'.$a;
}
else {
$retour =mysqli_query($link,'SELECT count(id_facture) AS nbMax FROM factures where type_facture = "Comptable" ');
$valeur = mysqli_fetch_assoc($retour);
$a = $valeur['nbMax'];
$a ++ ;
$x ='FC0'.$year.'/'.$a;
echo $x ;} ?></h3>
<small>Ref Facture</small>
</li>
</ul>
</div>
</div>
<hr>
<h2 class="margin-top-0"><img src="images/load.gif" width="50" height="50"> Jumelage Des BLs En Cours ..</h2>
</div>
</div>
</div>
<div class="col-md-3">
</div>
</div>
</body>
</html>
<?php
$dt = date('d-m-Y');
// Creation facture
$reponse = "INSERT INTO factures VALUES(id_facture ,'$x' , '$_SESSION[r_client]' , '$_POST[date_fac]' , 'Valide','BLs', '$_POST[dest]',2019);";
mysqli_query($link,$reponse);
$reponse = "select * from comptes_user where id_clt = $_SESSION[compte_user] ;";
$exec =mysqli_query($link,$reponse);
$row = mysqli_fetch_assoc($exec);
$a = $row['nom'].' vient de creer un nouvelle Facture : '.$x.' . Source = Jumelage BLS.';
$reponse = "INSERT INTO notification VALUES(id_notif ,'dripicons-user-group','$a' ,'$dt', 'ADMIN');";
mysqli_query($link,$reponse);
// Insertion BL<>Facture
$reas = "select * from bon_livraison where ref_client = $_SESSION[r_client] and dt_bl LIKE '%$_SESSION[dt_prms]' and etat_bl = 'Valide' and ref_bl NOT IN ( select refe_bl from bl_facture) order by (ref_bl) DESC;";
$exas = mysqli_query($link,$reas);
while ($rowas = mysqli_fetch_assoc($exas)) {
$reponse = "INSERT INTO bl_facture VALUES(id_coresp ,'$x','$rowas[ref_bl]');";
mysqli_query($link,$reponse);
}
$link_bf = 'Select_facture_bl.php?aux='.$x?>
<script language="JavaScript">
function t()
{
var compteur=document.getElementById('compteur');
s=duree;
m=0;h=0;
if(s==0)
{
document.location.href="<?php echo $link_bf; ?>";
}
else
{
if(s>59)
{
m=Math.floor(s/60);
s=s-m*60
}
if(m>59)
{
h=Math.floor(m/60);
m=m-h*60
}
if(s<10)
{
s="0"+s
}
if(m<10)
{
m="0"+m
}
}
duree=duree-1;
window.setTimeout("t();",999);
}
</script>
<div id="compteur"></div>
<script language="JavaScript">
duree="5";
t();
</script>