SUB=".$SUB." | MAT=".$MAT." | NOM=".$NOM.""; $forPile = false; if (strpos($_SERVER['REQUEST_URI'], '/pile/') !== false) { $forPile = true; $SUB = 1; } $valuesBind = array(':supp1' => 0, ':supp2' => 0); if ($SUB != "") { $valuesBind1 = array(); $typesBind1 = ""; if (($MAT != "") || ($NOM != "")) { if ($NOM != "") { $FILTER = " AND (c.nom LIKE :nom1 OR c.prenom LIKE :nom2 OR CONCAT(c.nom,' ', c.prenom) LIKE :nom3)"; $valuesBind1[':nom1'] = "%$NOM%"; $valuesBind1[':nom2'] = "%$NOM%"; $valuesBind1[':nom3'] = "%$NOM%"; } if ($MAT != "") { $FILTER = " AND c.id_agent=:id_agent"; $valuesBind1[':id_agent'] = $MAT; } } if ($AGC) { $FILTER .= " AND ca.id_agence=:id_agence"; $valuesBind1[':id_agence'] = $AGC; } $dlgColumn = $GLOBALS["BO_CONF"]["DELEGATION"] ? ", ca.delegue" : ""; $dlgCondition = $GLOBALS["BO_CONF"]["DELEGATION"] ? " OR ca.delegue = :delegue" : ""; $valuesBind2 = array(); $typesBind2 = ""; if ($GLOBALS["BO_CONF"]["DELEGATION"]) { $valuesBind2[':delegue'] = 1; } $valuesBind = array_merge($valuesBind, $valuesBind1, $valuesBind2); $typesBind = $typesBind1 . $typesBind2; $q = "SELECT c.id_conseiller, ca.id_agence, a.nom_agence, c.id_agent, c.nom, c.prenom, c.photo, IF(p.id_profil = 6, 1, 0) as is_da, DATE_FORMAT(d.date_delegation, '%d/%m/%Y') as date_creation, IF(c.id_agence = ca.id_agence,1,0) agence_affectation" . $dlgColumn . ",(SELECT CONCAT(dp.nom,' ', dp.prenom) FROM ca_conseillers dp WHERE dp.id_conseiller = d.id_da) AS delegue_par FROM ca_conseiller_agence as ca LEFT JOIN ca_delegations as d ON ca.id_agence=d.id_agence AND ca.id_conseiller = d.id_conseiller LEFT JOIN ca_agences as a ON ca.id_agence=a.id_agence LEFT JOIN ca_conseillers c ON ca.id_conseiller=c.id_conseiller LEFT JOIN ca_conseiller_profils p ON ca.id_conseiller=p.id_conseiller WHERE c.supp=:supp1 AND a.supp=:supp2" . $FILTER . " AND (ca.temporaire = 0 OR (TIMESTAMPDIFF(SECOND,ca.last_active,now())<=15 AND ca.temporaire = 1)) AND (p.id_profil = 6" . $dlgCondition . ") ORDER BY c.nom ASC"; // echo "

".$q; $DATA = ""; $stmt = excuteQuery($q, $valuesBind); $result = $stmt['stmt']; if ($result->rowCount() > 0) { while ($o = $result->fetchObject()) { $datecrea = $o->date_creation; if ($datecrea == "00/00/0000") { $datecreacons = $o->date_creation; if ($datecreacons == "00/00/0000") { $datecrea = ' - '; } else { $datecrea = $datecreacons; } } $NOMAGENCE = str_replace("'", ' ', $o->nom_agence); $NOMC = $o->nom . " " . $o->prenom; $ENTITE = $o->libelle; $NOMCONSEILLER = str_replace("'", ' ', $NOMC); $CONSLINK = ($o->agence_affectation && $ISADMIN) ? "" . $o->nom . " " . $o->prenom . "" : $o->nom . " " . $o->prenom; $CONSMAT = ($o->agence_affectation && $ISADMIN) ? "" . $o->id_agent . "" : $o->id_agent; $CONSTYPE = ($o->is_da == 0 && $o->delegue == 1) ? "Délégué" : "DA"; $CONSTYPECLASS = ($o->is_da == 0 && $o->delegue == 1) ? "label-dlg" : "label-da"; $DATA .= " " . $CONSTYPE . " " . $CONSLINK . " " . $CONSMAT . " " . $o->nom_agence . ""; $DATA .= "" . $datecrea . " "; $DATA .= ""; $DATA .= ""; $DATA .= ""; $DATA .= ""; $DATA .= ($o->is_da == 0 && $o->delegue == 1) ? "" : ""; $DATA .= " "; } } else if (($MAT != "") || ($NOM != "")) { $header = false; $FILTER_2 = str_replace("ca.id_agence", "c.id_agence", $FILTER); $q2 = "SELECT count(id_conseiller) nb FROM ca_conseillers c WHERE supp=0" . $FILTER_2; $nb = 0; $stmt2 = excuteQuery($q2, $valuesBind1); if ($stmt2['status']) { $result = $stmt2['stmt']; $nb = $result->fetchObject(); $nb = $nb->nb; } if ($nb) { $DATA = "

Aucun résultat ne correspond à votre recherche : le collaborateur renseigné n’a pas un profil « DA ».

"; } else { $DATA = "

Aucun résultat ne correspond à votre recherche

"; } } } ?>

Listes des DAs & Délégués

Direction	Nom	Matricule	Agence	Date de délégation	Déléguer	Supprimer