|
Server IP : 10.128.40.6 / Your IP : 216.73.216.233 Web Server : Apache System : Linux webd006.cluster128.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : logmcpe ( 111175) PHP Version : 7.3.33 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/logmcpe/www/mcg/pages/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
// if(!empty($_POST)){
// echo "<pre>" ;
// print_r($_POST);
// echo "</pre>" ;
// exit() ;
// }
if($_GET['action']=='sup')
{
$idfours=$_GET['id'];
$sreussie=dbi_query("DELETE FROM ".fournisseur." WHERE Fournisseur_ID = $idfours") ;
header('Location:Fournisseurs.php?msg=le fournisseurs bien supprimé&color=success');
// exit() ;
}
//nouveau fournisseure
if ( $_POST['Enregistrer']=="Enregistrer")
{
extract($_POST);
//if(!empty($four_nom) || !empty($four_adr1) || !empty($four_cp) || !empty($four_ville) || !empty($four_cont) || !empty($four_cont_fonct) || !empty($four_cont_tel) || !empty($four_cont_mail) || !empty($four_franco) || !empty($refclient))
$sql_ins_four = "INSERT INTO ".fournisseur." ";
$sql_ins_four.= "VALUES ('', '$four_nom', '$four_adr1', '$four_adr2' ,'$four_adr3', '$four_cp', '$four_ville', '$four_cont', '$four_cont_fonct', '$four_cont_tel', '$four_cont_mail', '$four_franco', '$refclient')";
dbi_query ( $sql_ins_four );
header('Location:Fournisseurs.php?msg=le fournisseur bien enregistré&color=success');
} //nouveau fournisseure
//modifier fournisseure
if ( $_POST['modifier']=="modifier")
{
extract($_POST);
$sqlm = "UPDATE ".fournisseur." SET Fournisseur_Nom='$four_nom', Fournisseur_Adresse1='$four_adr1', Fournisseur_Adresse2='$four_adr2' ,Fournisseur_Adresse3='$four_adr3', Fournisseur_CP='$four_cp', Fournisseur_ville='$four_ville', Fournisseur_contact='$four_cont', Fournisseur_contact_fonction='$four_cont_fonct', Fournisseur_contact_tel='$four_cont_tel', Fournisseur_contact_mail='$four_cont_mail', Fournisseur_franco='$four_franco', Fournisseur_refclient='$refclient' WHERE Fournisseur_ID = $idfourm";
$mreussie=dbi_query ( $sqlm );
header('Location:Fournisseurs.php?msg=le fournisseur bien modifié&color=success');
}
?>
<script type="text/javascript">
function Confirme(URL)
{
if (confirm("Etes-vous certain de vouloir supprimer cette entrꥠ?"))
{
window.location = URL;
}
}
</script>
<!DOCTYPE html>
<html>
<head>
<?php include('header.php'); ?>
</head>
<body class="hold-transition sidebar-mini">
<!-- Site wrapper -->
<div class="wrapper">
<!-- TOP MENU -->
<nav class="main-header navbar navbar-expand navbar-white navbar-light">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
</li>
<li>
<?php echo '<a href="#myModal" id="custId" data-toggle="modal" data-id="'.$c['Fournisseur_ID'].'"><h3><button type="button" class="btn btn-primary" ><i class="fas fa-plus"></i> FOURNISSEUR</button></h3></a>';?>
</li>
</ul>
</nav>
<aside class="main-sidebar sidebar-dark-primary elevation-4">
<!-- Brand Logo -->
<a href="index3.html" class="brand-link">
<img src="dist/img/logomcpro.png" alt="AdminLTE Logo" class="brand-image img-circle elevation-3"
style="opacity: .8">
<span class="brand-text font-weight-light">MC PRO</span>
</a>
<!-- Sidebar -->
<div class="sidebar">
<!-- Sidebar user panel (optional) -->
<div class="user-panel mt-3 pb-3 mb-3 d-flex">
<div class="image">
<img src="dist/img/user2-160x160.jpg" class="img-circle elevation-2" alt="User Image">
</div>
<div class="info">
<a href="#" class="d-block">Steeven ROBLOT</a>
</div>
</div>
<?php include('menu.php'); ?>
<!-- Sidebar Menu -->
</div>
<!-- /.sidebar -->
</aside>
<div class="modal fade" id="myModal" role="dialog" class="modal fade task-modal-single in" tabindex="-1" aria-labelledby="myLargeModalLabel" >
<div class="modal-dialog modal-lg">
<div class="modal-content data">
<div id="fetch" ></div>
</div>
</div>
</div>
<div class="modal fade" id="myModalll" role="dialog" class="modal fade task-modal-single in" tabindex="-1" aria-labelledby="myLargeModalLabel" >
<div class="modal-dialog modal-lg">
<div class="modal-content data">
<div id="fetchh" ></div>
</div>
</div>
</div>
<!-- Ne pas toucher au dessus / fin de la BARRE DE NAVIGATION-->
<!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
<div class="content-wrapper">
<section class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1>Paramétrage des Fournisseurs</h1>
</div>
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="index.php">Accueil</a></li>
<li class="breadcrumb-item"><a href="indexstock.php">Gestion du Stock</a></li>
<li class="breadcrumb-item"><a href="indexstock_parametrage.php">Paramétrage</a></li>
<li class="breadcrumb-item active">Paramétrage des Fournisseurs </li>
</ol>
</div>
</div>
</div><!-- /.container-fluid -->
</section>
<?
$q= dbi_query("SELECT * FROM prospect") ;
?>
<!-- Main content -->
<section class="content">
<div class="row">
<div class="col-12">
<div class="card card">
<!-- /.card-header -->
<div class="card-body">
<?php
if(isset($_GET["msg"])){
?>
<div class="alert alert-<?php echo $_GET["color"]; ?> alert-dismissible col-12" role="alert">
<strong><?php echo $_GET["color"].': '; ?></strong><?php echo $_GET["msg"]; ?>.
<button type="button" class="close" data-dismiss="alert" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<?php
}
?>
<?php if(isset($_GET['idf']) && !empty($_GET['idf'])){ ?>
<div style="jalil" >
<?php
$idfour=$_GET['idf'];
$reqfour = dbi_query("select * from fournisseur where Fournisseur_ID=$idfour") ;
$listfour = dbi_fetch_row($reqfour);
?>
<table class="td_normal" style="margin-top: 10px;" cellpadding="0" cellspacing="0" >
<tr>
<td class="td_listing1b">
<h3><center>Affichage des informations de fournisseur :</center><div style="float:right;"><a href="Fournisseurs.php?action=new" class="modal" rel="{handler: 'iframe', size: {x: 700, y: 500}}"><img src="images/ajouter.png" alt="Ajouter" border="0"></a> <a href="?action=edit&id=<?=$listfour['Fournisseur_ID']?>" class="modal" rel="{handler: 'iframe', size: {x: 700, y: 500}}"><img src="images/edit.png" alt="Modifier" border="0"></a> <a href="?action=sup&id=<?=$listfour['Fournisseur_ID']?>" onclick="Confirme('Fournisseurs.php?action=sup&id=<?=$c['Fournisseur_ID']?>'); return false;"><img src="images/sup.png" alt="Supprimer" border="0"></a> </div></h3><img src="" border="0"> <?=$listfour['Fournisseur_Nom']?><br><br>
</td>
</tr>
<tr>
<td>
<table>
<tr><td class="td_listing0"><b>Adresse : </b><br>Adresse1 : <?=$listfour['Fournisseur_Adresse1']?></b><?php if($listfour['Fournisseur_Adresse2'] != '') echo "<br>Adresse2 : ".$listfour['Fournisseur_Adresse2']."</b>"?><?php if($listfour['Fournisseur_Adresse3'] != '') echo "<br>Adresse3 : ".$listfour['Fournisseur_Adresse3']."</b>"?><br>Ville : <?=$listfour['Fournisseur_ville']?><br>Code postal : <?=$listfour['Fournisseur_CP']?></b></td><td class="td_listing0"></td></tr>
</table>
</td>
</tr>
<TR>
<TD class="td_listing1" style="padding:8px">
<table cellpadding="0" align="left" cellspacing="0" border="0" width="100%">
<tr>
<td width="300"><b>Contact Fournisseur: </b></td><td><b> <?=$listfour['Fournisseur_contact']?></b>
</td>
</tr>
<tr>
<td width="300"><b>Fonction Contact Fournisseur : </b></td>
<td> <?=$listfour['Fournisseur_contact_fonction']?></td>
</tr>
<tr>
<td width="300"><b>Tꭩphone Contact Fournisseur : </b></td>
<td> <?=$listfour['Fournisseur_contact_tel']?></td>
</tr>
<tr>
<td width="300"><b>Email Contact Fournisseur : </b></td>
<td> <?=$listfour['Fournisseur_contact_mail']?></td>
</tr>
<tr>
<td width="300"><b>Franco fournisseur : </b></td>
<td> <?=$listfour['Fournisseur_franco']?></td>
</tr>
<tr>
<td width="300"><b>RꦠClient : </b></td>
<td> <?=$listfour['Fournisseur_refclient']?></td>
</tr>
</table>
</TD>
</TR>
</table>
</br>
</br>
<center>
<form id="four_form" name="four_form" method="get" action="s-four.php">
<input type="submit" class="bigbutton" name="actionform" value="Tout Fournisseur"/>
</form>
</center>
</div>
<?php
}
?>
<div class="onglet_dotted">
<?php
if(isset($_GET['ordre']) && !empty($_GET['ordre']))
{
if($_GET['ordre']=='asc')
$ordre='desc';
else
$ordre='asc';
}
else
$ordre='desc';
$q = dbi_query("select * from fournisseur ORDER BY Fournisseur_Nom $ordre") ;
?>
</br>
<div></div>
<table id="example1" class="table table-bordered table-striped">
<thead>
<TR>
<th>Nom<SPAN class="sort">↑</SPAN></th>
<th></th>
</TR>
</thead>
<tbody>
<?
$tdl="td_listing0";
$tdl0=true;
$tdl1=false;
if($q>0){
while($c = dbi_fetch_row($q)) {
?>
<TR>
<TD align="center" nowrap><?=$c['Fournisseur_Nom']?></TD>
<TD align="center" nowrap>
<?php echo '<a class="btn btn-info btn-sm" href="#myModalll" id="custId" data-toggle="modal" data-id="'.$c['Fournisseur_ID'].'"><i class="fas fa-pencil-alt">Editer</i></a>';?>
<a class="btn btn-danger btn-sm" href="?action=sup&id=<?=$c['Fournisseur_ID']?>" onclick="return confirm('Voulez-vous vraiment supprimer ce Fournisseur ?');">
<i class="fas fa-trash">Supprimer
</i>
</a>
</TD>
<?php
// echo '<a class="btn btn-info btn-sm" href="#myModalll" id="custId" data-toggle="modal" data-id="'.$q['contact_id'].'"> <i class="fas fa-pencil-alt"></i> </a>';
?>
</a>
</TR>
<?
if($tdl1)
{
$tdl="td_listing0";
$tdl0=true;
$tdl1=false;
}
elseif($tdl0)
{
$tdl="td_listing1";
$tdl1=true;
$tdl0=false;
}else
{
$tdl="td_listing0";
$tdl0=true;
$tdl1=false;
}
}//while
}
else
{
?>
<TR>
<TD align="center" nowrap></TD>
<TD align="center" nowrap>aucun fournisseur existe</TD>
<TD align="center" nowrap></TD>
</TR>
<?php
}
?>
</tfoot>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.0.1
</div>
<strong>Copyright © 2019 MCPRO</strong>
</footer>
<!-- FIN DU PIED DE PAGE -->
<!-- NE PAS TOUCHER CI-DESSOUS -->
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<!-- jQuery -->
<script src="../../plugins/jquery/jquery.min.js"></script>
<!-- Bootstrap 4 -->
<script src="../../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- DataTables -->
<script src="../../plugins/datatables/jquery.dataTables.js"></script>
<script src="../../plugins/datatables-bs4/js/dataTables.bootstrap4.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>
<script>
$(function () {
$("#example1").DataTable();
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false,
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ajaxajoutfournisseur.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch').html(data);//Show fetched data from database
}
});
});
});
</script>
<script type="text/javascript">
$(document).ready(function(){
$('#myModalll').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ajaxajoutfournisseur.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetchh').html(data);//Show fetched data from database
}
});
});
});
</script>
</body>
</html>