$t["row_even"] = "even";
$t["row_odd"] = "odd";
$t["cols"][0] = "";
$filter->css = $t;
$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<CURDATE() and pret_idempr=id_empr group by empr.id_empr";
$filter->from_original = "";
$filter->activate_filters();
if (!$filter->error) {
$aff_filters = "<script type='text/javascript' src='./javascript/tablist.js'></script><form class='form-{$current_module}' id='form_filters' name='form_filters' method='post' action='" . $PHP_SELF . "?categ=relance&sub=todo'><h3>" . $msg["filters_tris"] . "</h3>";
$aff_filters .= "<div class='form-contenu'><div id=\"el1Parent\" class=\"notice-parent\"><img src=\"./images/plus.gif\" name=\"imEx\" class=\"img_plus\" id=\"el1Img\" title=\"" . $msg['admin_param_detail'] . "\" border=\"0\" onClick=\"expandBase('el1', true); return false;\">\n \t\t\t\t\t\t\t\t<b>" . $msg["filters"] . "</b></div>\n\t\t\t\t\t\t<div id=\"el1Child\" style=\"margin-left:7px;display:none;\">";
$aff_filters .= $filter->display_filters();
$aff_filters .= "</div><div class='row'></div><div id=\"el2Parent\" class=\"notice-parent\"><img src=\"./images/plus.gif\" name=\"imEx\" class=\"img_plus\" id=\"el2Img\" title=\"" . $msg['admin_param_detail'] . "\" border=\"0\" onClick=\"expandBase('el2', true); return false;\">\n\t\t\t\t\t\t\t<b>" . $msg["tris_dispos"] . "</b></div>\n\t\t\t\t\t\t\t<div id=\"el2Child\" style=\"margin-left:7px;display:none;\">";
$aff_filters .= $filter->display_sort();
$aff_filters .= "</div></div><div class='row'></div><input type='submit' class='bouton' value='" . $msg["empr_sort_filter_button"] . "'></form>";
$aff_filters .= $filter->make_human_filters();
$aff_filters .= "<script>\n\t\t\t\t\t\tfunction envoi() {\n\t\t\t\t\t\t\tvar formulaire=document.form_filters;\n\t\t\t\t\t\t\tvar j=0;\n\t\t\t\t\t\t\tfor (i=0;i<formulaire.elements.length;i++) {\n\t\t\t\t\t\t\t\tvar values=new Array();\n\t\t\t\t\t\t\t\tif (formulaire.elements[i].type=='select-multiple') {\n\t\t\t\t\t\t\t\t\tfor (j=0; j<formulaire.elements[i].options.length; j++) {\n\t\t\t\t\t\t\t\t\t\tif (formulaire.elements[i].options[j].selected) {\n\t\t\t\t\t\t\t\t\t\t\tvalues[values.length]=formulaire.elements[i].options[j].value;\n\t\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t} else values[0]=formulaire.elements[i].value;\n\t\t\t\t\t\t\t\tif (values.length) {\n\t\t\t\t\t\t\t\t\tfor (j=0; j<values.length; j++) {\n\t\t\t\t\t\t\t\t\t\tvar nouvelelement=document.createElement('input');\n\t\t\t\t\t\t\t\t\t\tnouvelelement.setAttribute('type','hidden');\n\t\t\t\t\t\t\t\t\t\tnouvelelement.setAttribute('name',formulaire.elements[i].name);\n\t\t\t\t\t\t\t\t\t\tnouvelelement.value=values[j];\n\t\t\t\t\t\t\t\t\t\tdocument.relance_action.appendChild(nouvelelement);\t\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\tdocument.relance_action.submit();\n\t\t\t\t\t\t}\n\t\t\t\t\t</script>";
print $aff_filters;
if ($all_level) {
$pos = strpos($filter->query, "where");
$requete = substr($filter->query, 0, $pos + 6);
$requete .= $filter->params["REFERENCE"][0][value] . "." . $filter->params["REFERENCEKEY"][0][value] . " in (" . implode(",", array_keys($all_level)) . ") and ";
$requete .= substr($filter->query, $pos + 6, strlen($filter->query) - ($pos + 6));
} else {
$requete = $filter->query;
}
$colonnes = $filter->display_columns();
$script = "envoi();";
} else {
print $filter->error_message;
}
$empr_location_id = 0;
}
$url_base = "./circ.php?categ=pret&form_cb=" . rawurlencode($form_cb) . "&id_notice={$id_notice}" . "&id_bulletin={$id_bulletin}&empr_location_id={$empr_location_id}";
$aff_filters .= "<form class='form-{$current_module}' id='form_filters' name='form_filters' method='post' action='" . $url_base . "&nb_per_page={$nb_per_page}' onSubmit='this.page.value=\"1\";'><h3>" . $msg["filters_tris"] . "</h3>";
$aff_filters .= "<div class='form-contenu'><input type='hidden' name='page' value='{$page}'>\n\t\t\t\t\t\t\t\t\t<div id=\"el1Parent\" class=\"notice-parent\"><img src=\"./images/plus.gif\" class=\"img_plus\" name=\"imEx\" id=\"el1Img\" title=\"" . $msg['admin_param_detail'] . "\" border=\"0\" onClick=\"expandBase('el1', true); return false;\">\n\t\t \t\t\t\t\t\t\t\t<b>" . $msg["filters"] . "</b></div>\n\t\t\t\t\t\t\t\t<div id=\"el1Child\" style=\"margin-left:7px;display:none;\">";
$aff_filters .= $filter->display_filters();
$aff_filters .= "</div><div class='row'></div><div id=\"el2Parent\" class=\"notice-parent\"><img src=\"./images/plus.gif\" class=\"img_plus\" name=\"imEx\" id=\"el2Img\" title=\"" . $msg['admin_param_detail'] . "\" border=\"0\" onClick=\"expandBase('el2', true); return false;\">\n\t\t\t\t\t\t\t\t\t<b>" . $msg["tris_dispos"] . "</b></div>\n\t\t\t\t\t\t\t\t\t<div id=\"el2Child\" style=\"margin-left:7px;display:none;\">";
$aff_filters .= $filter->display_sort();
$aff_filters .= "</div></div><div class='row'></div><div class='row'><input type='submit' class='bouton' value='" . $msg["empr_sort_filter_button"] . "'>";
if ($empr_show_caddie) {
$aff_filters .= " <input type='button' class='bouton' value='" . $msg["add_empr_cart"] . "' onClick=\"popCaddie(document.forms['AddToCaddie']); return false;\">";
}
$aff_filters .= "</div></form>";
break;
}
$aff_filters .= "<br />" . $filter->make_human_filters();
$aff_filters .= $script_filters;
$empr_list_tmpl = str_replace("!!filters_list!!", $aff_filters, $empr_list_tmpl);
$nav_bar = $filter->display_pager();
$empr_list = $filter->display_result();
} else {
$empr_list_tmpl = str_replace("!!filters_list!!", $filter->error_message, $empr_list_tmpl);
}
} else {
// on lance la vraie requête
$requete = "SELECT *, count(pret_idexpl) as nb_pret FROM empr left join pret on id_empr=pret_idempr {$clause} group by id_empr ORDER BY empr_nom, empr_prenom LIMIT {$debut},{$nb_per_page} ";
$res = @mysql_query($requete, $dbh);
// $nbr_lignes = mysql_num_rows($res);
$parity = 0;
switch ($sub) {
case "launch":
