function filterLoansReaders($filter_name, $filter_source = "", $display, $filter, $sort, $parameters)
{
global $empr_sort_rows, $empr_show_rows, $empr_filter_rows, $pmb_lecteurs_localises;
if (SESSrights & CIRCULATION_AUTH) {
if ($empr_sort_rows || $empr_show_rows || $empr_filter_rows) {
if ($pmb_lecteurs_localises) {
$localisation = ",l";
} else {
$localisation = "";
}
$filter = new filter_list($filter_name, $filter_source, $display, $filter . $localisation, $sort);
$t_filters = explode(",", $filter->filtercolumns);
foreach ($t_filters as $f) {
$filters_selectors = "f" . $filter->fixedfields[$f]["ID"];
if ($parameters[$filters_selectors]) {
$tableau = array();
foreach ($parameters[$filters_selectors] as $categ) {
$tableau[$categ] = $categ;
}
global ${$filters_selectors};
${$filters_selectors} = $tableau;
}
}
$t_sort = explode(",", $filter->sortablecolumns);
for ($j = 0; $j <= count($t_sort) - 1; $j++) {
$sort_selector = "sort_list_" . $j;
if ($parameters[$sort_selector]) {
global ${$sort_selector};
${$sort_selector} = $parameters[$sort_selector];
}
}
$filter->activate_filters();
$requete = $filter->query;
}
$resultat = pmb_mysql_query($requete);
$result = array();
while ($row = pmb_mysql_fetch_assoc($resultat)) {
$result = array("id_empr" => $row["id_empr"], "empr_cb" => $row["empr_cb"], "empr_nom" => utf8_normalize($row["empr_nom"]), "empr_prenom" => utf8_normalize($row["empr_prenom"]), "categ_libelle" => utf8_normalize($row["libelle"]), "group_name" => utf8_normalize($row["group_name"]));
}
return $result;
} else {
return array();
}
}
break;
case "EMPR":
default:
if ($idemprcaddie) {
$caddie[0] = $idemprcaddie;
}
foreach ($caddie as $idemprcaddie) {
$myCart = new empr_caddie($idemprcaddie);
$myCart->add_item($item);
$myCart->compte_items();
}
break;
}
} elseif ($empr_sort_rows || $empr_show_rows || $empr_filter_rows) {
require_once "{$class_path}/filter_list.class.php";
$filter = new filter_list("empr", "empr_list", $empr_show_rows, $empr_filter_rows, $empr_sort_rows);
$requete = "SELECT id_empr FROM empr " . stripslashes($clause);
$filter->original_query = $requete;
if ($idemprcaddie) {
$caddie[0] = $idemprcaddie;
}
if ($caddie) {
foreach ($caddie as $idemprcaddie) {
$filter->filtered_query = stripslashes($filtered_query);
$filter->activate_filters();
if (!$filter->error) {
if ($filter->t_query) {
$myCart = new empr_caddie($idemprcaddie);
while ($r = mysql_fetch_object($filter->t_query)) {
$myCart->add_item($r->id_empr);
}
function show_form($param = '')
{
global $msg, $pmb_lecteurs_localises, $empr_sort_rows, $empr_show_rows, $empr_filter_rows, $deflt2docs_location;
// //paramètres pré-enregistré
// $lst_opt = array();
// if ($param['chk_loan']) {
// foreach ($param['chk_loan'] as $elem) {
// $lst_opt[$elem] = $elem;
// }
// }
// $loc_selected = ($param["empr_location_id"] ? $param["empr_location_id"] : "");
//Automatisation sur les prêts
$form_task .= "\n\t\t<div class='row'>\n\t\t\t<div class='colonne3'>\n\t\t\t\t<label for='loan'>" . $this->msg["planificateur_loan_generate"] . "</label>\n\t\t\t</div>\n\t\t\t<div class='colonne_suite'>\n\t\t\t\t<input type='radio' name='chk_loan' value='" . LOAN_ALL_ACTIONS . "' " . ($param["chk_loan"] == LOAN_ALL_ACTIONS ? "checked" : "") . "/>" . $this->msg["loan_all_actions"] . "\n\t\t\t\t<br /><input type='radio' name='chk_loan' value='" . LOAN_PRINT_MAIL . "' " . ($param["chk_loan"] == LOAN_PRINT_MAIL || !$param["chk_loan"] ? "checked" : "") . "/>" . $this->msg["loan_print_mail"] . "\n\t\t\t\t<br /><input type='radio' name='chk_loan' value='" . LOAN_CSV_MAIL . "' " . ($param["chk_loan"] == LOAN_CSV_MAIL ? "checked" : "") . "/>" . $this->msg["loan_csv_mail"] . "\n\t\t\t</div>\n\t\t</div>\n\t\t<div class='row'> </div>";
if ($empr_sort_rows || $empr_show_rows || $empr_filter_rows) {
if ($pmb_lecteurs_localises) {
$localisation = ",l";
}
$filter = new filter_list("empr", "empr_list", "b,n,c,g", "b,n,c,g" . $localisation . ",2,3,cs", "n,g");
if ($pmb_lecteurs_localises) {
$lo = "f" . $filter->fixedfields["l"]["ID"];
global ${$lo};
if (!${$lo}) {
$tableau = array();
$tableau[0] = $deflt2docs_location;
${$lo} = $tableau;
}
}
$filter->fixedcolumns = "b,n,c";
$filter->original_query = $requete;
$filter->multiple = 1;
$filter->select_original = "table_filter_tempo.empr_nb,empr_mail";
$filter->original_query = "select id_empr,count(pret_idexpl) as empr_nb from empr,pret where pret_retour<now() and pret_idempr=id_empr group by empr.id_empr";
$filter->from_original = "";
$filter->activate_filters();
if (!$filter->error) {
$t_filters = explode(",", $filter->filtercolumns);
foreach ($t_filters as $i => $f) {
if (substr($s[$i], 0, 1) == "#" && $filter->params["REFERENCE"][0]["DYNAMICFIELDS"] == "yes") {
//Faut-il adapter les champs perso ??
} elseif (array_key_exists($t_filters[$i], $filter->fixedfields)) {
$filters_selectors = "f" . $filter->fixedfields[$f]["ID"];
} else {
$filters_selectors = "f" . $filter->specialfields[$f]["ID"];
}
global ${$filters_selectors};
if ($param[$filters_selectors]) {
$tableau = array();
foreach ($param[$filters_selectors] as $categ) {
$tableau[$categ] = $categ;
}
${$filters_selectors} = $tableau;
}
}
$form_task .= "<div class='row'>\n\t\t\t\t<div class='colonne3'>\n\t\t\t\t\t<label for='loan'>" . $this->msg["planificateur_loan_filters"] . "</label>\n\t\t\t\t</div>\n\t\t\t\t<div class='colonne_suite'>\n\t\t\t\t\t" . $filter->display_filters() . "\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class='row'> </div>";
$t_sort = explode(",", $filter->sortablecolumns);
//parcours des selecteurs de tris
for ($j = 0; $j <= count($t_sort) - 1; $j++) {
$sort_selector = "sort_list_" . $j;
global ${$sort_selector};
if ($param[$sort_selector]) {
${$sort_selector} = $param[$sort_selector];
}
}
$form_task .= "<div class='row'>\n\t\t\t\t<div class='colonne3'>\n\t\t\t\t\t<label for='loan'>" . $this->msg["planificateur_loan_tris"] . "</label>\n\t\t\t\t</div>\n\t\t\t\t<div class='colonne_suite'>\n\t\t\t\t\t" . $filter->display_sort() . "\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t<div class='row'> </div>";
} else {
$form_task .= $filter->error_message;
}
}
return $form_task;
}
}
if ($pmb_transferts_actif) {
$loc_expl = ",13";
} else {
$loc_expl = "";
}
$p_perso = new pret_parametres_perso("pret");
$filter_p_perso = "";
if (count($p_perso->t_fields)) {
foreach ($p_perso->t_fields as $id => $field) {
if ($field["FILTERS"]) {
$filter_p_perso .= ",#p" . $id;
}
}
}
$filter = new filter_list("empr", "empr_list", "b,n,c,cs,g", "b,n,c,g" . $localisation . ",2,3,cs" . $loc_expl . $filter_p_perso, "n,g");
if ($pmb_lecteurs_localises) {
$lo = "f" . $filter->fixedfields["l"]["ID"];
global ${$lo};
if (!${$lo}) {
$tableau = array();
$tableau[0] = $deflt2docs_location;
${$lo} = $tableau;
}
}
$filter->fixedcolumns = "b,n,c";
$filter->original_query = $requete;
$filter->multiple = 1;
$t = array();
$t["table"] = "";
$t["row_even"] = "even";
if ($nbr_lignes) {
if ($empr_location_id && $pmb_lecteurs_localises) {
$docs_location = new docs_location($empr_location_id);
$where_intitule = $msg["empr_location_intitule"] . " \"" . $docs_location->libelle . "\"";
} else {
$where_intitule = "";
}
if ($empr_show_caddie) {
$script_filters = "<script type='text/javascript'>\n\t\t\tfunction popCaddie(the_form) {\n\t \t\t\tmy_form = eval(the_form);\n\t \t\t\twindow.open('./cart.php?object_type=EMPR&action=add_result', 'popup', 'height=700,width=600,menubar=no,toolbar=no,dependent=yes,resizable=yes,location=no,status=no,scrollbars=yes');\n\t \t\t\tmy_form.target = 'popup';\n\t \t\t\tmy_form.action='./cart.php?object_type=EMPR&action=add_result';\n\t \t\t\tmy_form.submit();\n\t\t\t}\n\t\t</script>\n\t\t<form name='AddToCaddie' method='post' style='display:none'>\n\t\t\t<input type='hidden' name='clause' value=\"" . htmlentities($clause, ENT_QUOTES, $charset) . "\">\n\t \t\t!!filtered_query_hidden!!\n\t\t</form>";
} else {
$script_filters = "";
}
$aff_filters = "";
if ($empr_sort_rows || $empr_show_rows || $empr_filter_rows) {
require_once $class_path . "/filter_list.class.php";
$filter = new filter_list("empr", "empr_list", $empr_show_rows, $empr_filter_rows, $empr_sort_rows);
if (!$empr_location_id) {
$empr_location_id = -1;
}
if (array_search("l", explode(",", $empr_filter_rows)) !== FALSE) {
$lo = "f" . $filter->fixedfields["l"]["ID"];
global ${$lo};
if (!${$lo}) {
$tableau = array();
$tableau[0] = $empr_location_id;
${$lo} = $tableau;
}
}
$requete = "SELECT id_empr,empr_cb,empr_nom,empr_prenom,empr_adr1,empr_ville,empr_year FROM empr {$clause} group by id_empr ORDER BY empr_nom, empr_prenom ";
$filter->original_query = $requete;
$filter->page = $page;
