while ($opportunite = mysql_fetch_array($r_opportunite)) {
$xzsql = "SELECT nom from texte where id=".$opportunite['texId'];
//print_r($xzsql);
$text = CBdd::select_one($xzsql,'nom');
$xzsql = "SELECT piece from hbpiecesjointes where id=".$opportunite['pieId'];
//print_r($xzsql);
$piece= CBdd::select_one($xzsql,'piece');
?>
<tr>
<td><a href="?a=5&id=<?=$opportunite['id'] ?>"><?=$opportunite['id'] ?></a></td>
<td><?=utf8_encode ($opportunite['nom']); ?></td>
<td><?=$text ; ?></td>
<td><?=str_replace('../../userfiles/pieces_jointes/', '',$piece); ?></td>
<td align="center"><?=CDate::date_switch(CDate::formate_date($opportunite['date'])) ?></td>
<td align="center"><?=CHtml::get_etat($opportunite['id'], $opportunite['etat'], $opportunite['id']); ?></td>
<td align="center"><?=CHtmlSession::get_editbutton($opportunite['id'], $opportunite['id']) ?></td>
<td align="center"><?=CHtml::get_delbutton($a, $opportunite['id'], $id, $opportunite['id']) ?></td>
</tr>
<?php } ?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 4) { ?>
<form id="form_ajout" method="post" action="opportunite.php">
<p> <?=CForm::get_hidden(44) ?> </p>
<fieldset>
<th><a href="?order=date">Date d'ajout</a></th>
<th><a href="?order=etat">Etat</a></th>
<th>Modif</th>
<th title="suppr"> Suppr </th>
</tr>
<?php
$i = 0;
while ($texte = @mysql_fetch_array($r_texte)) {
?>
<tr>
<td><a href="show_texte.php?id=<?php echo $texte['id'] ?>" target="popup" onclick="popup(this.href, this.target, '800', '600');"> <?php echo $texte['id'] ?> </a></td>
<td height><?php echo $texte['nom'] ?></td>
<td align="center"><?php echo CDate::date_switch(CDate::formate_date($texte['date'])) ?></td>
<td align="center"><?php echo CHtml::get_etat($texte['id'], $texte['etat'], CTableUser::is_admin($_SESSION['idmbr'])); ?></td>
<td align="center"><?php echo CHtmlSession::get_editbutton($texte['id'], CTableUser::is_admin($_SESSION['idmbr'])) ?></td>
<td align="center"><?php echo CHtmlSession::get_delbutton($a, $texte['id'], $id, CTableUser::is_admin($_SESSION['idmbr'])) ?></td>
</tr>
<?php } ?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 4) { ?>
<form id="form_ajout" method="post" action="texte.php" enctype="multipart/form-data">
<p> <?php echo CForm::get_hidden(44) ?> </p>
<fieldset>
<legend>Formulaire d'ajout de Texte</legend>
<p>
//----------- Owen recuperation nom pays pour commune
$sqlNomCat = "select pays FROM departement WHERE id_dep='".$listeCom['departement']."'";
$id_pays = CBdd::select_one($sqlNomCat, 'pays');
$Zsql = "SELECT nom FROM pays WHERE id_pays=".$id_pays;
$nom_pays = CBdd::select_one($Zsql, 'nom');
?>
<tr>
<td><a href="?a=5&id=<?php echo $listeCom['id_com'] ?>"><?php echo $listeCom['id_com'] ?></a></td>
<td><?php echo utf8_encode($listeCom['nom_com']) ?></td>
<td><?php echo $listeCom['CP'] ?></td>
<td><?php echo $nom_pays ?></td>
<td><?php echo $listeCom['urlCommune'] ?></td>
<td align="center"><?php echo CDate::date_switch(CDate::formate_date($listeCom['date_com'])) ?></td>
<td align="center"><a href="commune.php?a=5&id=<?php echo $listeCom['id_com'] ?>" target="_parent"><img src="../img/b_edit.png" alt="modifier, afficher" /></a></td>
<td align="center"><?php echo CHtmlSession::get_delbutton($a, $listeCom['id_com'], $id, $listeCom['idreda']) ?></td>
<td align="center"><input type="checkbox" name="ids[]" class="id_del" value="<?php echo $listeCom['id_com'] ?>"/></td>
</tr>
<?php
$i++;
}
?>
</table>
<p> <?php echo CForm::get_hidden(7); ?> </p>
<p>
<input type="hidden" name="id_groupe" value="<?php echo $_SESSION['id_groupe']; ?>"/>
</p>
</form>
<?
}
<th align="left">Id</th>
<th align="left">Nom</th>
<th>Valeur</th>
<th>Choix possibles</th>
<th>Modif</th>
</tr>
<?php
$i = 0;
while ($configuration = mysql_fetch_array($r_configuration)) {
?>
<tr>
<td><?php echo $configuration['id']?></td>
<td><?php echo stripslashes($configuration['nom']) ?></td>
<td align="center"><?php echo $configuration['valeur'] ?></td>
<td align="center"><?php echo stripslashes($configuration['choix']) ?></td>
<td align="center"><?php echo CHtmlSession::get_editbutton($configuration['id'], 1) ?></td>
</tr>
<?php
}
?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// MODIF
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 5) { ?>
<form id="form_modif" method="post" action="configuration.php">
<p> <?php echo CForm::get_hidden(55) ?> </p>
</tr>
<?
$i = 0;
if($requetPays){
while ($pays = mysql_fetch_array($requetPays)) {
$Zsql = "SELECT nom FROM pays WHERE id_pays='".$pays['pays']."'";
$nom = CBdd::select_one($Zsql, 'nom');
//$idcom_=CBdd::select_one($sql_idcom, 'idcom');
?>
<tr>
<td><a href="?a=5&id=<? echo $pays['id_dep'] ?>"><? echo utf8_decode($pays['id_dep']) ?></a></td>
<td><? echo ucfirst(strtolower(trim($pays['nom']))) ?></td>
<td><? echo $nom; ?></td>
<td align="center"><? echo CHtml::get_editbutton($pays['id_dep'], $pays['idreda'], $pays['idreda']) ?></td>
<td align="center"><? echo CHtmlSession::get_delbutton($a, $pays['id_dep'], $id, $pays['idreda']) ?></td>
</tr>
<? } ?>
</table>
<?
}
}
?>
<?
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<? if($a == 4) { ?>
<form id="form_ajout" method="post" action="departement.php" enctype="multipart/form-data">
<td style="text-align: center;">
<a href="#com-<?php echo $i;?>" class="tooltip"><img src="../img/comment.png" alt="Voir"/></a>
<div id="com-<?php echo $i;?>" style="display: none;"><?php echo nl2br($user['commentaire']); ?></div>
</td>
<?php
}
else {
?>
<td style="text-align: center;"> </td>
<?php
}
?>
<td align="center"><?php echo CTableUser::is_admin($_SESSION['idmbr']) ? CHtml::get_etat($rdv['id'], $rdv['etat'], 1) : CHtml::get_etat($rdv['id'], $rdv['etat'], 0) ?></td>
<td align="center"><?php echo CHtmlSession::get_editbutton($rdv['iduser'], $rdv['iduser']) ?></td>
<td align="center"><?php echo CHtmlSession::get_delbutton($a, $rdv['id'], $id, $rdv['iduser']) ?></td>
</tr>
<?php
$i++;
} ?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// MODIF
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 5) { ?>
<form id="form_modif" method="post" action="gr_rdv.php">
<p> <?php echo CForm::get_hidden(55) ?> </p>
<p> <?php echo CForm::get_hidden($id, 'id') ?> </p>
<td align="center">
<?php echo CHtmlUser::get_etat_contact($user['id'], $user['etat_contact'], 0) ?>
<!--<?php echo !$user['etat_contact'] ? "NC" : ($user['etat_contact'] == 1 ? "C" : ($user['etat_contact'] == 2 ? "NI" : "A")) ?>-->
</td>
<td align="center"><?php echo CDate::date_switch(CDate::formate_date($user['date'])) ?></td>
<td align="center"><?php echo CDate::date_switch(CDate::formate_date($rdv['date'])) ?></td>
<td align="center"><?php echo $rdv['heure'] ?></td>
<td align="center"><?php echo $rdv['type']==0 ? "Téléphone" : ($rdv['type']==1 ? "Skype" : "Domicile") ?></td>
<td align="center"><a href="user.php?a=5&id=<?php echo $user['id'] ?>" target="_parent"><img src="../img/b_edit.png" alt="modifier, afficher" /></a></td>
<td align="center">
<?php
if($user['type']==2) {
echo ' ';
}
else {
echo CHtmlSession::get_delbutton($a, $user['id'], $id, CTableUser::is_admin($_SESSION['idmbr']));
}
?>
</td>
<td align="center"><a href="envoi.php?destinataire=<?php echo $user['email'] ?>&a=4" target="_parent">>></a></td>
<td>
<?php
if($user['type']==2) {
?> <?php
}
else {
?>
<input type="checkbox" name="ids[]" class="id_del" value="<?php echo $user['id'] ?>"/>
<?php
}
?>
if($image['titre']) {
?>
<td style="text-align: center;">
<a href="#com-<?php echo $i;?>" class="tooltip"><img src="../img/comment.png" alt="Voir"/></a>
<div id="com-<?php echo $i;?>" style="display: none;"><?php echo nl2br($image['titre']); ?></div>
</td>
<?php
}
else {
?>
<td style="text-align: center;"> </td>
<?php
}
?>
<td><?php echo CHtmlSession::get_etat($image['id'], $image['etat'], $image['idreda']) ?></td>
<td align="center"><?php echo CHtml::get_editbutton($image['id'], $actif_btn) ?></td>
<td align="center"><?php echo CHtml::get_delbutton($a, $image['id'], $id, $actif_btn) ?></td>
<td align="center"><?php echo CDate::formate_date($image['date']) ?></td>
</tr>
<?php } ?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 4) { ?>
<form id="form_ajout" name="form_ajout" method="post" action="fichier-galerie.php" enctype="multipart/form-data">
<p> <?php echo CForm::get_hidden(44) ?> </p>
</tr>
<?php
$i = 0;
while ($video = mysql_fetch_array($r_video)) {
$tpage = new CTablePage(array('id'=>$video['id_page']));
$page = $tpage->select_row();
$actif_btn = CTableUser::is_admin($_SESSION['idmbr'])?1:0;
?>
<tr>
<td><?php echo $video['nom'] ?></td>
<td><?php echo $video['fichier'] ?></td>
<td align="center"><?php echo $page['nom'] ?></td>
<td><?php echo CHtmlSession::get_rang('video', $video['id'], $video['id_page']) ?></td>
<td><?php echo CHtmlSession::get_etat($video['id'], $video['etat'], null) ?></td>
<td align="center"><?php echo CHtml::get_editbutton($video['id'], $actif_btn) ?></td>
<td align="center"><?php echo CHtml::get_delbutton($a, $video['id'], $id, $actif_btn) ?></td>
<td align="center"><?php echo CDate::formate_date($video['date']) ?></td>
</tr>
<?php } ?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 4) {
// Liste des videos
?>
</td>
<td align="center"><?php echo $user['pays'] ?></td>
<td align="center"><?php echo date("d-m-20y", strtotime($user['date']));?></td>
<td align="center"><?php echo CHtmlUser::get_etat_contact($user['id'], $user['etat_contact'], 0) ?></td>
<td align="center">R<?php echo $user['relance']; ?></td>
<td style="text-align: center;"><?php echo $opp_num[$user['idopportunite']]; ?></td>
<?php if ($user['commentaire']) { ?>
<td align="center" class="info"><div class="bulle"><?php echo nl2br($user['commentaire']) ?></div></td>
<?php } else { ?>
<td align="center"></td>
<?php } ?>
<td><?php echo (CTableUser::is_admin($_SESSION['idmbr']) && !CTableUser::is_admin($user['id'])) ? CHtmlSession::get_etat($user['id'], $user['etat'], $user['id']) : CHtml::get_etat($user['id'], $user['etat']) ?></td>
<td align="center"><?php echo CHtmlSession::get_editbutton($user['id'], $user['id']) ?></td>
<td align="center"><?php echo (CTableUser::is_admin($_SESSION['idmbr']) && !CTableUser::is_admin($user['id']))
? CHtmlSession::get_delbutton($a, $user['id'], $id, $user['id']) : CHtml::get_delbutton($a, $user['id'], $id) ?></td>
<td><a href="envoi.php?destinataire=<?php echo $user['email'] ?>&a=4&isGr=1">>></a></td>
<td align="center"><?php if(CBdd::select_one("SELECT count(id) AS nb_reponse FROM reponse WHERE iduser = "******"../src/reponse.php?id=<?php echo $user['id'] ?>" target="popup" onclick="popup(this.href, this.target, '600', '500'); return false;"> >> </a>
<?php } ?></td>
<td align="center"><input class="caseacocher" name="tab_user[<?php echo $i ?>]" type="checkbox" id="contact[<?php echo $i ?>]" value="<?php echo $user['id'] ?>" checked /></td>
</tr>
<?php $i++; } ?>
</table>
<?php
//----------------------------------------------------------------------------------------------
// GROUPE
//----------------------------------------------------------------------------------------------
?>
<div class="floatright">
<p> <?php echo CForm::get_hidden(7) ?> </p>
$nb_image = CBdd::select_one("SELECT COUNT(id) as nb FROM image WHERE idgal = ".$galerie['id'], "nb");
?>
<tr>
<td> <?php echo $galerie['id'] ?> </td>
<td><?php echo CDate::date_switch(CDate::formate_date($galerie['date'])) ?></td>
<td align="center"><?php echo CFunction::clean(stripslashes($galerie['nom'])); ?></td>
<td align="center"><?php echo $categorie; ?></td>
<td align="center"><?php echo $article; ?></td>
<td align="center"><?php echo $page; ?></td>
<td style="text-align: center;"><?php echo $nb_image; ?></td>
<td style="text-align: center;"><?php echo CHtmlSession::get_etat($galerie['id'], $galerie['etat_diaporama'], $galerie['idreda'], 7) ?></td>
<td style="text-align: center;"><?php echo CHtmlSession::get_rang('galerie', $galerie['id'], $galerie['idreda']) ?></td>
<td style="text-align: center;"><?php echo CHtmlSession::get_etat($galerie['id'], $galerie['etat'], $galerie['idreda']) ?></td>
<td style="text-align: center;"><?php echo CHtmlSession::get_editbutton($galerie['id'], $galerie['idreda']) ?></td>
<td style="text-align: center;"><?php echo CHtmlSession::get_delbutton($a, $galerie['id'], $id, $galerie['idreda']) ?></td>
</tr>
<?php }
}
?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 4) { ?>
<form name="form_ajout" id="form_ajout" method="post" action="galerie.php">
<p> <?php echo CForm::get_hidden(44) ?> </p>
<fieldset>
<?php } ?>
<br />
<?php if($email['etat'] != 1) { ?>
<a href="reception.php?a=2&id=<?php echo $email['id'] ?>&etat=1"><img src="../img/publish_g.png" alt="Lu" /> Lu</a>
<?php } else { ?>
<img src="../img/publish_g.png" alt="Envoyé" /> Lu
<?php } ?>
<br />
<?php if($email['etat'] != 2) { ?>
<a href="reception.php?a=2&id=<?php echo $email['id'] ?>&etat=2"><img src="../img/publish_u.png" alt="Archivé" /> Archivé</a>
<?php } else { ?>
<img src="../img/publish_u.png" alt="Archivé" /> Archivé
<?php } ?>
</div></td>
<td><a href="envoi.php?a=5&reply=<?php echo $email['id'] ?>">></a></td>
<td><?php echo CHtmlSession::get_delbutton($a, $email['id'], $id, CTableUser::is_admin($_SESSION['idmbr'])) ?></td>
</tr>
<?php $i++; } ?>
</table>
<?php }
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
if($a == 4) { ?>
<form id="form_ajout" method="post" action="reception.php">
<p> <?php echo CForm::get_hidden(44) ?> </p>
<fieldset>
<legend>Formulaire de relève des courriers de <u><?php echo CTableUser::get_email_admin() ?></u> du serveur : <u><?php echo CTableConfiguration::get_value_by_element('POP_SERVER') ?></u></legend>
<p>
<label>Password POP </label>
<input name="passe" type="password" id="passe" value="<?php echo $passe ?>"/>
<tr align="center">
<th align="left"><a href="?order=id_sec">Id</a></th>
<th align="left"><a href="?order=nom_sec">Secteur</a></th>
<th>Modif</th>
<th title="suppr"> Suppr </th>
</tr>
<?php
$i = 0;
while ($secteur = mysql_fetch_array($requetSecteur)) {
?>
<tr>
<td><a href="?a=5&id=<?php echo $secteur['id_sec'] ?>"><?php echo utf8_decode($secteur['id_sec']) ?></a></td>
<td><?php echo $secteur['nom_sec'] ?></td>
<td align="center"><?php echo CHtmlSession::get_editbutton($secteur['id_sec'], $secteur['idreda']) ?></td>
<td align="center"><?php echo CHtmlSession::get_delbutton($a, $secteur['id_sec'], $id, $secteur['idreda']) ?></td>
</tr>
<?php } ?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 4) { ?>
<form id="form_ajout" method="post" action="secteur.php" enctype="multipart/form-data">
<p> <?php echo CForm::get_hidden(44) ?> </p>
<fieldset>
<legend>Formulaire d'ajout de menu </legend>
?>
<div class="bulle">
<?php echo utf8_encode($nomCat); ?>
</div>
</td>
<td align="center"><?php if ($user['dateajout_ent'] != "00-00-0000") echo CDate::date_switch($user['dateajout_ent']) ?></td>
<td align="center"><?php echo CHtmlUser::get_etat_contact($user['id_ent'], $user['etat_contact'], 0) ?></td>
<td style="text-align: center;">
<?php echo $opp_num[$user['idopportunite']]; ?>
</td>
<td align="center"><a href="contact.php?a=5&id=<?php echo $user['id_ent'] ?>" target="_parent"><img src="../img/b_edit.png" alt="modifier, afficher" /></a></td>
<td align="center"><?php echo CHtmlSession::get_delbutton($a, $user['id_ent'], $id, $user['id_ent']) ?></td>
<td><a href="envoi.php?destinataire=<?php echo $user['email'] ?>&a=4" target="_parent">>></a></td>
<td align="center"><?php if(CBdd::select_one("SELECT count(id) AS nb_reponse FROM reponse WHERE iduser = "******"../src/reponse.php?id=<?php echo $user['id_ent'] ?>" target="popup" onclick="popup(this.href, this.target, '600', '500'); return false;"> >> </a>
<?php } ?></td>
<td><input type="checkbox" name="ids[]" class="id_del" value="<?php echo $user['id_ent'] ?>"/></td>
</tr>
<?php $i++;
}
}
?>
</table>
<p> <?php echo CForm::get_hidden(7); ?> </p>
<p>
<input type="hidden" name="id_groupe" value="<?php echo $_SESSION['id_groupe']; ?>"/>
</p>
<th width="50px">Publié</th>
<th width="50px">Modif</th>
<th width="50px">Vider</th>
<th title="suppr" width="50px"> Suppr </th>
<th width="50px">Envoi</th>
</tr>
<?php foreach($tElms as $res){?>
<tr>
<td><?php echo $res['id'];?></td>
<td><?php echo $res['nom'];?></td>
<td><?php echo CTableMoulGpFic::get_nbr_fic_of_grp($res['id']);?></td>
<td><?php echo $res['fichiers'];?></td>
<td><?php echo CDate::date_switch(CDate::formate_date($res['date_creation']));?></td>
<td><?php echo CHtmlSession::get_etat($res['id'],$res['etat'],1);?></td>
<td><?php echo CHtmlSession::get_editbutton($res['id'], 1) ?></td>
<td><?php include('moul_vider_grpmail.php');?></td>
<td><?php include('moul_delete_grpmail.php');?></td>
<td><a href="envoi.php?destinataire=<?php echo $res['nom'] ?>&a=4&type_groupe=2">>></a></td>
</tr>
<?php }?>
</table>
<?php }
/*-----------------------------------
* AJOUT MODIFICATION
*-----------------------------------*/
if($a == 4){
?>
<form id="form_ajout" method="post" action="moul_groupe_mail.php">
<p> <?php echo CForm::get_hidden(44) ?> </p>
if($img['id']==$default) {
?>
DEFAULT
<?php
}
else {
?>
<a href="?a=7&id=<?php echo $img['id'] ?>">Définir</a>
<?php
}
?>
</td>
<td align="center"><?php echo CHtmlSession::get_rang('images', $img['id'], $img['idreda']) ?></td>
<td align="center"><?php echo CHtmlSession::get_etat($img['id'], $img['etat'], $img['idreda']) ?></td>
<td align="center"><?php echo CHtmlSession::get_editbutton($img['id'], $img['idreda']) ?></td>
<td align="center"><?php echo CHtmlSession::get_delbutton($a, $img['id'], $id, $img['idreda']) ?></td>
</tr>
<?php } ?>
</table>
<?php } ?>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//----------------------------------------------------------------------------------------------
?>
<?php if($a == 4) { ?>
<form id="form_ajout" method="post" action="image_menu.php" enctype="multipart/form-data">
<p> <?php echo CForm::get_hidden(44) ?> </p>
<fieldset>
<legend>Formulaire d'ajout d'image</legend>
<th title="suppr"> Suppr </th>
</tr>
<?php
$sql = "SELECT * FROM hbpiecesjointes ORDER BY ";
$sql .=($order) ? $order : '' ;
$pj = CBdd::select($sql) ;
//echo $sql ;
$i = 0;
while ($tzPj = mysql_fetch_array($pj)) {
?>
<tr>
<td> <?php echo $tzPj['id'] ; ?></td>
<td> <?php echo stripslashes($tzPj['piece']) ; ?></td>
<td align="center"><?php echo CHtmlSession::get_etat($tzPj['id'], $tzPj['etat'], 1) ?></td>
<td align="center"><?php echo CHtmlSession::get_editbutton($tzPj['id'], 1) ?></td>
<td align="center"><?php echo CHtmlSession::get_delbutton($a, $tzPj['id'], $id, 1) ?></td>
<?php $i++ ; ?>
</tr>
<?php
}
}
?>
</table>
<?php
//----------------------------------------------------------------------------------------------
// AJOUT
//-----------------------------------------------------------------------------------------------