// $Id: suggestions_empr.inc.php,v 1.4 2015-04-03 11:16:25 jpermanne Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
require_once $class_path . "/suggestions_map.class.php";
require_once "./acquisition/suggestions/func_suggestions.inc.php";
global $dbh, $statut;
$sug_map = new suggestions_map();
if ($statut == -1 || $statut == '') {
$statut_clause = "";
} else {
$statut_clause = "and statut='" . $statut . "'";
}
$req = "select count(id_suggestion) as nb, concat(empr_nom,' ',empr_prenom) as nom, id_empr as id, empr_location from suggestions, suggestions_origine, empr\n where origine=id_empr and num_suggestion=id_suggestion and type_origine=1 {$statut_clause} group by nom";
$res = pmb_mysql_query($req, $dbh);
$aff = "\n\t<h1>" . $msg['acquisition_sug_ges'] . "</h1>\n\t<form name='list_lecteur_sug' method='post' action='./acquisition.php?categ=sug&sub=empr_sug'>\n\t<h3>" . $msg['acquisition_sugg_list_lecteur'] . "</h3>\n\t<div class='form-contenu'>\n\t\t<div class='row'>\n\t\t\t<label class='etiquette'>" . $msg['acquisition_sugg_filtre_by_etat'] . "\n\t\t\t</label>\t\n\t\t</div>\n\t\t<div class='row'> " . $sug_map->getStateSelector() . "\n\t\t</div>\n\t\t<table>\n\t\t\t<tr>\n\t\t\t\t<th>" . $msg['acquisition_sugg_lecteur'] . "</th>\n\t\t\t\t<th>" . $msg['acquisition_sugg_nb'] . "</th>\n\t\t\t</tr>";
if (!pmb_mysql_num_rows($res)) {
$aff .= "<tr><td>" . htmlentities($msg['acquisition_sugg_no_state_lecteur'], ENT_QUOTES, $charset) . "</td></tr>";
} else {
$parity = 1;
while ($empr = pmb_mysql_fetch_object($res)) {
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$tr_javascript = "onclick=\"document.location='./acquisition.php?categ=sug&action=list&user_id[]=" . $empr->id . "&user_statut[]=1&sugg_location_id=" . $empr->empr_location . "' \" ";
$aff .= "<tr class='{$pair_impair}' {$tr_javascript} style='cursor: pointer'><td>" . $empr->nom . "</td><td>" . $empr->nb . "</td></tr>";
}
}
