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(); } }
$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); } // fin while $myCart->compte_items(); } } // fin if filter->t_query } // fin if idemprcaddie } // fin if !$filster->error
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; }