// $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>"; } }