Bonjour, j'ai un tableau avec une base de donnée associé, j'aimerais que quand j’appuie sur un des 6 bouton, que sa rajoute un mot sur la ligne sélectionner avec une colonne dédié a cela ou copier/couper la ligne vers une autre base?
ps comment fait-on pour sélectionné une ligne dans un tableaux via avec un "radio"?
Merci
voici ma page php
<html>
<html lang="fr">
<head>
<meta charset="utf-8" />
<title>Flotte Mobile</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.3/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script src="dialog.js"></script>
<link href="Tableau.css" rel="stylesheet" />
<link rel="stylesheet" type="text/css" href="Bouton.css">
<link rel="stylesheet" href="dialog.css">
</head>
<body>
<h2 align="center">Affectation</h2><br />
<center>
<a href="Abonnement.php" class="bouton_dans_page">Abonnement</a>
<a href="Employe.php" class="bouton_dans_page"> Employe</a>
<a href="Equipement.php" class="bouton_dans_page"> Equipement</a>
<a href="Modele.php" class="bouton_dans_page"> Modele</a>
<a href="Nouvelle_Affectation.php" class="bouton_dans_page"> Nouvelle Affectation</a>
<a href="Employe.php" class="bouton_dans_page"> Employe</a>
<a href="Menu_Smartphone.html" class="bouton_dans_page"> Menu Smarphone</a>
</center>
<div class="container">
<br />
<div class="form-group">
<div class="input-group">
<span class="input-group-addon">Recherche</span>
<input type="text" name="search_text" id="search_text" placeholder="Rechercher par Nom/Opérateur/Num SIM" class="form-control" />
</div>
</div>
<br />
<div id="result"></div>
</div>
<center>
<div id="dialogoverlay"></div>
<div id="dialogbox">
<div>
<div id="dialogboxhead"></div>
<div id="dialogboxfoot"></div>
</div>
</div>
<button class="Menu" onclick="Confirm.render()">Suprimer Affectation</button>
<button class="Menu" type="button">Confirmer Retour Equipement</button>
<a href="Equipement_Modal.php" class="Menu"> Remplacer Equipement</a>
<button class="Menu" type="button">Ajout et Supression Ligne</button>
<button class="Menu" type="button">Confirmer Retour Abonnement</button>
<button class="Menu" type="button">Reaffectation Equipement</button>
</center>
</body>
</html>
<script>
$(document).ready(function(){
load_data();
function load_data(query)
{
$.ajax({
url:"fetch_Affect.php",
method:"POST",
data:{query:query},
success:function(data)
{
$('#result').html(data);
}
});
}
$('#search_text').keyup(function(){
var search = $(this).val();
if(search != '')
{
load_data(search);
}
else
{
load_data();
}
});
});
</script>
OuiNon = MsgBox("Est-ce que le matériel est déjà retourné ?", vbYesNo)
If OuiNon = vbYes Then
strmysql = "UPDATE Abonnements SET Abonnements.Statut_Abo = ""Non Affecté"""
strmysql = strmysql & " WHERE (Abonnements.Num_SIM = """
strmysql = strmysql & Numero_puce
strmysql = strmysql & """);"
' DoCmd.RunSQL strmysql
Me.Statut_Affectation = "Non Affecté"
DoCmd.RunCommand acCmdSaveRecord
MyDate = Date$
User = Environ("USERNAME")
RunMySQL = "INSERT INTO [Arch_Affectation] (Or_Affectation, USER_ID, PIN_Terminal, PIN_SIM, Coque, Vitre, Support_Vehicule, Num_EMEI,Num_SIM, Date_Début, Date_Fin, Actif, Statut_Affectation, Commentaire, Auteur, Date_Maj, Desc_Action )"
RunMySQL = RunMySQL & " select Or_Affectation, USER_ID, PIN_Terminal, PIN_SIM, Coque, Vitre, Support_Vehicule, Num_EMEI,Num_SIM , Date_Début, #"
RunMySQL = RunMySQL & MyDate
RunMySQL = RunMySQL & "#, Actif, Statut_Affectation, Commentaire, """
RunMySQL = RunMySQL & User
RunMySQL = RunMySQL & """, #"
RunMySQL = RunMySQL & MyDate
RunMySQL = RunMySQL & "#, ""Supprimer Affectation"""
RunMySQL = RunMySQL & " FROM [Affectation] WHERE [Affectation].Or_Affectation =" & Me.Or_Affectation & ";"
DoCmd.RunSQL RunMySQL
DoCmd.RunSQL " UPDATE [Equipement] INNER JOIN [Affectation] ON [Equipement].Num_EMEI = [Affectation].Num_EMEI SET [Equipement].Statut_Equipement =""Non Affecté""" _
& " WHERE Equipement.Num_EMEI='" & Me.Num_EMEI & "'"
ElseIf OuiNon = vbNo Then
strmysql = "UPDATE Abonnements SET Abonnements.Statut_Abo = ""Attente Retour"""
strmysql = strmysql & " WHERE (Abonnements.Num_SIM = """
strmysql = strmysql & Numero_puce
strmysql = strmysql & """);"
' DoCmd.RunSQL strmysql
Me.Statut_Affectation = "Attente Retour"
DoCmd.RunCommand acCmdSaveRecord
MyDate = Date$
User = Environ("USERNAME")
RunMySQL = "INSERT INTO [Arch_Affectation] (Or_Affectation, USER_ID, PIN_Terminal, PIN_SIM, Coque, Vitre, Support_Vehicule, Num_EMEI,Num_SIM, Date_Début, Date_Fin, Actif, Statut_Affectation, Commentaire, Auteur, Date_Maj, Desc_Action )"
RunMySQL = RunMySQL & " select Or_Affectation, USER_ID, PIN_Terminal, PIN_SIM, Coque, Vitre, Support_Vehicule, Num_EMEI,Num_SIM , Date_Début, #"
RunMySQL = RunMySQL & MyDate
RunMySQL = RunMySQL & "#, Actif, Statut_Affectation, Commentaire,"""
RunMySQL = RunMySQL & User
RunMySQL = RunMySQL & """, #"
RunMySQL = RunMySQL & MyDate
RunMySQL = RunMySQL & "#, ""Supprimer Affectation - Attente Retour"""
RunMySQL = RunMySQL & " FROM [Affectation] WHERE [Affectation].Or_Affectation =" & Me.Or_Affectation & ";"
DoCmd.RunSQL RunMySQL
DoCmd.RunSQL " UPDATE [Equipement] INNER JOIN [Affectation] ON [Equipement].Num_EMEI = [Affectation].Num_EMEI SET [Equipement].Statut_Equipement =""Attente Retour""" _
& " WHERE Equipement.Num_EMEI='" & Me.Num_EMEI & "'"
End If
Me.Refresh
Exit Sub
je ne vois pas comment l'inséré a un bouton
j'aimerais le mettre sur le premier bouton qui a une boite de dialogue e js, la voici:
function CustomAlert(){
this.render = function(dialog){
var winW = window.innerWidth;
var winH = window.innerHeight;
var dialogoverlay = document.getElementById('dialogoverlay');
var dialogbox = document.getElementById('dialogbox');
dialogoverlay.style.display = "block";
dialogoverlay.style.height = winH+"px";
dialogbox.style.left = (winW/2) - (550 * .5)+"px";
dialogbox.style.top = "100px";
dialogbox.style.display = "block";
document.getElementById('dialogboxhead').innerHTML = "Acknowledge This Message";
document.getElementById('dialogboxfoot').innerHTML = '<button onclick="Alert.ok()">OK</button>';
}
this.ok = function(){
document.getElementById('dialogbox').style.display = "none";
document.getElementById('dialogoverlay').style.display = "none";
}
}
var Alert = new CustomAlert();
function deletePost(id){
var db_id = id.replace("post_", "");
document.body.removeChild(document.getElementById(id));
}
function CustomConfirm(){
this.render = function(dialog,op,id){
var winW = window.innerWidth;
var winH = window.innerHeight;
var dialogoverlay = document.getElementById('dialogoverlay');
var dialogbox = document.getElementById('dialogbox');
dialogoverlay.style.display = "block";
dialogoverlay.style.height = winH+"px";
dialogbox.style.left = (winW/2) - (550 * .5)+"px";
dialogbox.style.top = "100px";
dialogbox.style.display = "block";
document.getElementById('dialogboxhead').innerHTML = "Est-ce que le matériel est déjà retourné ?";
document.getElementById('dialogboxfoot').innerHTML =
'<button onclick="Confirm.yes(\''+op+'\',\''+id+'\')">Oui</button><button onclick="Confirm.no()">Non</button>';
}
this.no = function(){
document.getElementById('dialogbox').style.display = "none";
document.getElementById('dialogoverlay').style.display = "none";
}
this.yes = function(op,id){
if(op == "delete_post"){
deletePost(id);
}
document.getElementById('dialogbox').style.display = "none";
document.getElementById('dialogoverlay').style.display = "none";
}
}
var Confirm = new CustomConfirm();
merci