المعهد العالي لأصول الدين - modification profil ensegn/adminsitr

التفاصيل: نشر بتاريخ: 05 نيسان/أبريل 2016

{source}
<?php
// You can place PHP like this
$db = JFactory::getDbo();
// Create a new query object.
$query = $db->getQuery(true);
$query->select($db->quoteName(array('user_id')));
$query->from($db->quoteName('#__profil_enseignant'));
$db->setQuery($query);
$rows = $db->loadObjectList();
$arrgroup = array();
$i=0;
foreach($rows as $key=>$value){
$query2 = $db->getQuery(true);
$query2->select($db->quoteName(array('username')));
$query2->from($db->quoteName('#__users'));
$query2->where($db->quoteName('id') . ' LIKE '. $value->user_id);
$db->setQuery($query2);
$rows2 = $db->loadObjectList();

foreach($rows2 as $key=>$value2){
$arrgroup[$i]=$value2->username;
}
$i++;
}

$query3 = $db->getQuery(true);
$query3->select($db->quoteName(array('user_id')));
$query3->from($db->quoteName('#__profil_administration'));
$db->setQuery($query3);
$rows3 = $db->loadObjectList();
$arrgroup3 = array();
$j=0;
foreach($rows3 as $key=>$value3){
$query4 = $db->getQuery(true);
$query4->select($db->quoteName(array('username')));
$query4->from($db->quoteName('#__users'));
$query4->where($db->quoteName('id') . ' LIKE '. $value3->user_id);
$db->setQuery($query4);
$rows4 = $db->loadObjectList();

foreach($rows4 as $key=>$value4){
$arrgroup3[$j]=$value4->username;
}
$j++;
}
$arrayid=array();
?>
<form class="form-horizontal" method="post" enctype="multipart/form-data" >
<div class="row">
<fieldset>
<div class="span1">
</div>
<div class="span3">
<select name="fonction" onchange="selection(this)">
<option selected="selected" value="choix">Choisir</option>
<option value="enseignant">Enseignant</option>
<option value="administratif">Corps Administratif</option>
</select>
</div>
<div class="span3">
<div id="affich-enseignant" class="hidden" >
<select name="selectenseign" >
<option selected="selected" value="">Choisir un enseignant</option>
<?php
while (list ($key, $val) = each ($arrgroup) ) {
?>
<option value="<?php echo htmlspecialchars($val)?>"><?php echo htmlspecialchars($val)?></option>

<?php
}
?>
</select>
</div>
</div>
<div id="affich-administratif" class="hidden">
<select name="selectadministr" >
<option selected="selected" value="">Choisir un administrateur</option>
<?php
while (list ($key4, $val4) = each ($arrgroup3) ) {
?>
<option value="<?php echo htmlspecialchars($val4)?>"><?php echo htmlspecialchars($val4)?></option>
<?php
}
?>
</select>

</div>
<div class="span3">

<input type="submit" class="btn btn-primary" name="submit" value="modifier" />
</div>
</fieldset>
</div>
</form>
<?php
if ((isset($_POST["submit"]) > 0) && (!$_POST['selectenseign'] == "" )) {
$selected_val = $_POST['selectenseign'];
$query5 = $db->getQuery(true);
$query5->select($db->quoteName(array('id','password','email')));
$query5->from($db->quoteName('#__users'));
$query5->where($db->quoteName('username') . ' LIKE '. $db->quote($selected_val));
$db->setQuery($query5);
$rows5 = $db->loadObjectList();

foreach($rows5 as $key=>$value5){
$arrayid[0]=$value5->id;
$emailancien=$value5->email;
}

$query6 = $db->getQuery(true);
$query6->select($db->quoteName(array('url_emploi','nom','prenom','grade','specialite','date_naissance','num_tel1','num_tel2','adresse','code_postale')));
$query6->from($db->quoteName('#__profil_enseignant'));
$query6->where($db->quoteName('user_id') . ' LIKE '. $db->quote($arrayid[0]));
$db->setQuery($query6);
$db->execute();
$num_rows6 = $db->getNumRows();
$rows6 = $db->loadObjectList();

foreach($rows6 as $key=>$value6){

$nom=$value6->nom;
$prenom=$value6->prenom;
$grade=$value6->grade;
$specialite=$value6->specialite;
$date_naissance=$value6->date_naissance;
$num_tel1=$value6->num_tel1;
$num_tel2=$value6->num_tel2;
$adresse=$value6->adresse;
$code_postale=$value6->code_postale;
$url_emploi=$value6->url_emploi;
}

?>
<body style="font-size:12pt">
<div class="row">
<form class="form-horizontal" method="post" enctype="multipart/form-data">
<legend>Modifier Profil</legend>
<div class="span12">
<fieldset>

<div class="control-group">
<label class="control-label" for="input01">Nom</label>
<div class="controls">
<input type="text" name="nomF" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($nom) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Prenom</label>
<div class="controls">
<input type="text" name="prenomF" class="input-xlarge" id="input01" value="<?php echo $prenom ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Date de naissance</label>
<div class="controls">
<input type="date" name="date" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($date_naissance) ?>">
<p class="help-block"></p>
</div>
</div>
</fieldset>
</div>
<div class="span10">
<fieldset>

<div class="control-group">
<label class="control-label" for="input01">Adresse</label>
<div class="controls">
<input type="text" name="adresse" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($adresse) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Code postale</label>
<div class="controls">
<input type="text" name="code" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($code_postale) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Numéro Tél(1)</label>
<div class="controls">
<input type="text" name="num-tel1" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($num_tel1) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Numéro Tél (2)</label>
<div class="controls">
<input type="text" name="num-tel2" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($num_tel2) ?>">
<p class="help-block"></p>
</div>
</div>

<div class="control-group">
<label class="control-label" for="input01">Grade</label>
<div class="controls">
<input type="text" name="grade" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($grade) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Spécialité</label>
<div class="controls">
<input type="text" name="specialite" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($specialite) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Emlpoi du temps</label>
<div class="controls">
<input type="file" name="fichier" class="input-xlarge" id="input01" value="<?php echo $url_emploi ?>"/>
<p class="help-block"></p>
</div>
</div>
<?php if ($value6->url_emploi!=''){ ?>
<div class="control-group">
<label class="control-label" for="input01">Aperçue de l'Emlpoi du temps</label>
<div class="controls">
<iframe src="/<?php echo "$url_emploi"; ?>" style="width: 100%; height: 620px"></iframe>
<p class="help-block"></p>
</div>
</div>
<?php } ?>
</fieldset>
</div>
<div class="span6" style="text-align:center">

<input type="submit" class="btn btn-primary" name="submitmodif" value="Enregistrer" />
<input type="hidden" name="id_select" value="<?php echo $arrayid[0]; ?>">
<input type="hidden" name="url_fichier" value="<?php echo $url_emploi; ?>">
</div>
</form>
</div>
</body>

<?php
}
else if ((isset($_POST["submit"]) > 0) && (!$_POST['selectadministr'] == "" )) {
$selected_val = $_POST['selectadministr'];
$query15 = $db->getQuery(true);
$query15->select($db->quoteName(array('id','password','email')));
$query15->from($db->quoteName('#__users'));
$query15->where($db->quoteName('username') . ' LIKE '. $db->quote($selected_val));
$db->setQuery($query15);
$rows15 = $db->loadObjectList();

foreach($rows15 as $key=>$value15){
$arrayid[0]=$value15->id;
$emailancien=$value15->email;
}

$query16 = $db->getQuery(true);
$query16->select($db->quoteName(array('nom','prenom','fonction','date_naissance','num_tel1','num_tel2','adresse','code_postale')));
$query16->from($db->quoteName('#__profil_administration'));
$query16->where($db->quoteName('user_id') . ' LIKE '. $db->quote($arrayid[0]));
$db->setQuery($query16);
$db->execute();
$num_rows16 = $db->getNumRows();
$rows16 = $db->loadObjectList();

foreach($rows16 as $key=>$value16){

$nom=$value16->nom;
$prenom=$value16->prenom;
$date_naissance=$value16->date_naissance;
$num_tel1=$value16->num_tel1;
$num_tel2=$value16->num_tel2;
$adresse=$value16->adresse;
$code_postale=$value16->code_postale;
}

?>
<body style="font-size:12pt">
<div class="row">
<form class="form-horizontal" method="post" enctype="multipart/form-data">
<legend>Modifier Profil</legend>
<div class="span12">
<fieldset>

<div class="control-group">
<label class="control-label" for="input01">Nom</label>
<div class="controls">
<input type="text" name="nomF" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($nom) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Prenom</label>
<div class="controls">
<input type="text" name="prenomF" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($prenom) ?>">
<p class="help-block"></p>
</div>
</div>

<div class="control-group">
<label class="control-label" for="input01">Date de naissance</label>
<div class="controls">
<input type="date" name="date" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($date_naissance) ?>">
<p class="help-block"></p>
</div>
</div>
</fieldset>
</div>
<div class="span10">
<fieldset>

<div class="control-group">
<label class="control-label" for="input01">Adresse</label>
<div class="controls">
<input type="text" name="adresse" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($adresse) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Code postale</label>
<div class="controls">
<input type="text" name="code" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($code_postale) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Numéro Tél(1)</label>
<div class="controls">
<input type="text" name="num-tel1" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($num_tel1) ?>">
<p class="help-block"></p>
</div>
</div>
<div class="control-group">
<label class="control-label" for="input01">Numéro Tél (2)</label>
<div class="controls">
<input type="text" name="num-tel2" class="input-xlarge" id="input01" value="<?php echo htmlspecialchars($num_tel2) ?>">
<p class="help-block"></p>
</div>
</div>

</fieldset>
</div>
<div class="span6" style="text-align:center">

<input type="submit" class="btn btn-primary" name="submitmodifadminist" value="Enregistrer" />
<input type="hidden" name="id_select" value="<?php echo $arrayid[0]; ?>">
</div>
</form>
</div>
</body>

<?php
}

if(isset($_POST['submitmodifadminist'])){
$idselect = $_POST['id_select'];
$nomModif = $_POST['nomF'];
$prenomModif = $_POST['prenomF'];
$dateModif = $_POST['date'];
$numtel1Modif = $_POST['num-tel1'];
$numtel2Modif = $_POST['num-tel2'];
$adresseModif = $_POST['adresse'];
$codepostalModif = $_POST['code'];

$query17 = $db->getQuery(true);
$fields = array(
$db->quoteName('nom') . ' = ' . $db->quote($nomModif),
$db->quoteName('prenom') . ' =' . $db->quote($prenomModif),
$db->quoteName('date_naissance') . ' = ' . $db->quote($dateModif),
$db->quoteName('num_tel1') . ' = ' . $db->quote($numtel1Modif),
$db->quoteName('num_tel2') . ' = ' . $db->quote($numtel2Modif),
$db->quoteName('adresse') . ' = ' . $db->quote($adresseModif),
$db->quoteName('code_postale') . ' = ' . $db->quote($codepostalModif)
);
$conditions = array($db->quoteName('user_id') . ' = ' . $db->quote($idselect));
$query17->update($db->quoteName('#__profil_administration'))->set($fields)->where($conditions);
$db->setQuery($query17);
$result = $db->execute();

$query18 = $db->getQuery(true);
$fields18 = array( $db->quoteName('name') . ' = ' . $db->quote($nomModif));
$conditions18 = array($db->quoteName('id') . ' = ' . $db->quote($idselect));
$query18->update($db->quoteName('#__users'))->set($fields18)->where($conditions18);
$db->setQuery($query18);
$result = $db->execute();
?>
<div class="alert alert-success"> <p>Le compte est modifié avec succès</p>
</div><?php

}

if(isset($_POST['submitmodif'])){
$idselect = $_POST['id_select'];
$nomModif = $_POST['nomF'];
$prenomModif = $_POST['prenomF'];
$gradeModif = $_POST['grade'];
$specialiteModif = $_POST['specialite'];
$dateModif = $_POST['date'];
$numtel1Modif = $_POST['num-tel1'];
$numtel2Modif = $_POST['num-tel2'];
$adresseModif = $_POST['adresse'];
$codepostalModif = $_POST['code'];
$fichier = $_POST['url_fichier'];
if(!empty($_FILES)) {
if(is_uploaded_file($_FILES['fichier']['tmp_name'])){
$file_name=$_FILES['fichier']['name'];
$file_extension=strrchr($file_name,".");
$file_tmp=$_FILES['fichier']['tmp_name'];
$file_dest='files/emploi_enseignant/'.$file_name;
$extensions=array('.pdf');
if(in_array($file_extension,$extensions))
{
if(move_uploaded_file($file_tmp,$file_dest))
{
$fichier = $file_dest;
$query7 = $db->getQuery(true);
$fields = array(
$db->quoteName('nom') . ' = ' . $db->quote($nomModif),
$db->quoteName('prenom') . ' =' . $db->quote($prenomModif),
$db->quoteName('grade') . ' = ' . $db->quote($gradeModif),
$db->quoteName('specialite') . ' = ' . $db->quote($specialiteModif),
$db->quoteName('date_naissance') . ' = ' . $db->quote($dateModif),
$db->quoteName('num_tel1') . ' = ' . $db->quote($numtel1Modif),
$db->quoteName('num_tel2') . ' = ' . $db->quote($numtel2Modif),
$db->quoteName('adresse') . ' = ' . $db->quote($adresseModif),
$db->quoteName('code_postale') . ' = ' . $db->quote($codepostalModif),
$db->quoteName('url_emploi') . ' = ' . $db->quote($fichier),
);
$conditions = array($db->quoteName('user_id') . ' = ' . $db->quote($idselect));
$query7->update($db->quoteName('#__profil_enseignant'))->set($fields)->where($conditions);
$db->setQuery($query7);
$result = $db->execute();

$query8 = $db->getQuery(true);
$fields8 = array( $db->quoteName('name') . ' = ' . $db->quote($nomModif));
$conditions8 = array($db->quoteName('id') . ' = ' . $db->quote($idselect));
$query8->update($db->quoteName('#__users'))->set($fields8)->where($conditions8);
$db->setQuery($query8);
$result = $db->execute();
?>
<div class="alert alert-success"> <p>Le compte est modifié avec succès</p>
</div><?php
}
}
else { ?>
<div class="alert alert-error"> <p>le fichier n est pas un .pdf </p> </div>
<?php
}
}
else {
$query7 = $db->getQuery(true);
$fields = array(
$db->quoteName('nom') . ' = ' . $db->quote($nomModif),
$db->quoteName('prenom') . ' =' . $db->quote($prenomModif),
$db->quoteName('grade') . ' = ' . $db->quote($gradeModif),
$db->quoteName('specialite') . ' = ' . $db->quote($specialiteModif),
$db->quoteName('date_naissance') . ' = ' . $db->quote($dateModif),
$db->quoteName('num_tel1') . ' = ' . $db->quote($numtel1Modif),
$db->quoteName('num_tel2') . ' = ' . $db->quote($numtel2Modif),
$db->quoteName('adresse') . ' = ' . $db->quote($adresseModif),
$db->quoteName('code_postale') . ' = ' . $db->quote($codepostalModif),
$db->quoteName('url_emploi') . ' = ' . $db->quote($fichier),
);
$conditions = array($db->quoteName('user_id') . ' = ' . $db->quote($idselect));
$query7->update($db->quoteName('#__profil_enseignant'))->set($fields)->where($conditions);
$db->setQuery($query7);
$result = $db->execute();

$query8 = $db->getQuery(true);
$fields8 = array( $db->quoteName('name') . ' = ' . $db->quote($nomModif));
$conditions8 = array($db->quoteName('id') . ' = ' . $db->quote($idselect));
$query8->update($db->quoteName('#__users'))->set($fields8)->where($conditions8);
$db->setQuery($query8);
$result = $db->execute();
?>
<div class="alert alert-success"> <p>Le compte est modifié avec succès</p>
</div><?php
}
}
}
?>
<script src="https://code.jquery.com/jquery-1.10.2.js"></script>
<script language="javascript" type="text/javascript">
// You can place JavaScript like this

function selection(liste) {
// Indiquer si l'on teste une égalité ou une différence 'egal' / 'diff'. exemple : creation/ modif/ supp --> egal 'creation' alors affichage OU pomme / poire/ autre --> si différent de 'autre' alors affichage
// par défault indiquer à la place de choix this.value pour prendre la valeur de la liste
//$(function (){
var numero = liste.selectedIndex;
var choix = liste.options[numero].value;

if(choix=='enseignant') { //Si la sélection dans la liste est égale à la valeur indiquée dans les paramètres
//On supprime la classe hidden, on ajoute la classe display, on supprime l'attribut disabled, on cache sans délais afin que l'utilisateur ne voit pas que l'on vient de le passer en display et on fait l'animation d'affichage
//$("div:"+id_a_afficher+'"').prev().removeClass('hidden');
alert("choix=enseignant !");
$('#affich-enseignant').removeClass('hidden').addClass('display');
$('#affich-administratif').removeClass('display').addClass('hidden');
}
else if(choix=='administratif'){
alert("choix=administratif !");
$('#affich-administratif').removeClass('hidden').addClass('display');
$('#affich-enseignant').removeClass('display').addClass('hidden');
}
// });
}
function select(liste) {
// Indiquer si l'on teste une égalité ou une différence 'egal' / 'diff'. exemple : creation/ modif/ supp --> egal 'creation' alors affichage OU pomme / poire/ autre --> si différent de 'autre' alors affichage
// par défault indiquer à la place de choix this.value pour prendre la valeur de la liste
//$(function (){
var numero = liste.selectedIndex;
var choix = liste.options[numero].value;
$('#nom').removeClass('hidden').addClass('display');

}
</script>
{/source}

إصدارات مجلة التنوير

المستجدات

نتائج الدورة الرئيسية لمرحلة الماجيستير دورة فيفري 2020

modification profil ensegn/adminsitr

الجوائز والأوسمة