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;