"_item_"), "CATALOG"); //Création de la liste des types d'import $export_type=""; $form=str_replace("!!export_type!!",$export_type,$form); //Filtres //Propriétaires $requete="select idlender,lender_libelle from lenders"; $lenders="\n"; $form=str_replace("!!lenders!!",$lenders,$form); //Types de documents $typ_doc_lists = ""; $requete="select idlender, lender_libelle from lenders"; $resultat=pmb_mysql_query($requete); while (list($id_lender,$lender_libelle)=pmb_mysql_fetch_row($resultat)) { //Récupération des codes exemplaires du proptiétaire $requete="select idtyp_doc, concat(tdoc_libelle) as lib from docs_type, exemplaires, lenders where idtyp_doc=expl_typdoc and expl_owner=$id_lender and (idlender=tdoc_owner or tdoc_owner=0) group by expl_typdoc"; $typ_doc_lists.="
"; $typ_doc_lists.=gen_liste($requete,"idtyp_doc","lib","typdoc".$id_lender."[]","","","","","","",1); $typ_doc_lists.="
"; } //Tous les types $requete="select idtyp_doc, concat(tdoc_libelle) as lib from docs_type order by lib"; $typ_doc_lists.="
"; $typ_doc_lists.=gen_liste($requete,"idtyp_doc","lib","typdocx[]","","","","","","",1); $typ_doc_lists.="
"; $form=str_replace("!!typ_doc_lists!!",$typ_doc_lists,$form); //Status $statut_lists = ''; $requete="select idlender, lender_libelle from lenders"; $resultat=pmb_mysql_query($requete); while (list($id_lender,$lender_libelle)=pmb_mysql_fetch_row($resultat)) { //Récupération des codes exemplaires du propriétaire ayant le statut $requete="select idstatut, concat(statut_libelle) as lib from docs_statut, exemplaires, lenders where idstatut=expl_statut and expl_owner=$id_lender and (idlender=statusdoc_owner or statusdoc_owner=0) group by expl_statut"; $statut_lists.="
"; $statut_lists.=gen_liste($requete,"idstatut","lib","statut".$id_lender."[]","","","","","","",1); $statut_lists.="
"; } //Tous les status $requete="select idstatut, concat(statut_libelle) as lib from docs_statut order by lib"; $statut_lists.="
"; $statut_lists.=gen_liste($requete,"idstatut","lib","statutx[]","","","","","","",1); $statut_lists.="
"; $form=str_replace("!!statut_lists!!",$statut_lists,$form); $param = new export_param(EXP_DEFAULT_GESTION); $form=str_replace("!!form_param!!",$param->check_default_param(),$form); echo pmb_bidi($form); print "";