/**
* Génération du tableau de critères enregistrés pour la source
* @return string
*/
private function generate_table()
{
$return_table = '<table id="defined_crits" name="defined_crits">';
$return_table .= '<th>' . $this->format_text($this->msg['cms_module_docnumslist_datasource_docnumslist_facette_crit']) . '</th><th></th>';
if (isset($this->parameters['crit'])) {
$facette_search = new facette_search();
foreach ($this->parameters['crit'] as $index => $crit) {
$return_table .= '<tr>
<td><label>' . $this->format_text($facette_search->array_sort()[$crit]) . '</label>
<input type="hidden" value="' . $crit . '" name="' . $this->get_form_value_name("crit") . '[]"/>
<input type="hidden" value="' . $this->parameters['subcrit'][$index] * 1 . '" name="' . $this->get_form_value_name("subcrit") . '[]"/>' . '
</td>
<td><input class="bouton" type="button" onclick="delete_line(event)" value="X"/></td>
</tr>';
}
}
$return_table .= '</table>';
return $return_table;
}
function get_src_list()
{
global $msg, $charset;
$r = "\n \t\t<script type='text/javascript'>\n \t\t\t\t\t\n\t\t\t\tfunction load_subfields(source_id,id_ss_champs){\n\t\t\t\t\n\t\t\t\t\tvar lst = document.getElementById('list_crit_'+source_id);\n\t\t\t\t\tvar id = lst.value;\n\t\t\t\t\tvar lst = document.getElementById('list_ss_crit_'+source_id);\n\t\t\t\t\tif(id=='0'){\t\n\t\t\t\t\t\tlst.innerHTML =\t'';\n\t\t\t\t\t\treturn;\t\t\n\t\t\t\t\t}\n\t\t\t\t\tvar xhr_object= new http_request();\t\t\t\t\t\n\t\t\t\t\txhr_object.request('./ajax.php?module=admin&categ=opac§ion=lst_facette',1,'list_crit=' +id+ '&sub_field=' +id_ss_champs+ '&suffixe_id='+source_id );\n\t\t\t\t\tlst.innerHTML = xhr_object.get_text();\n\t\t\t\t}\n\t\t\t</script>";
//Recherche des sources
$requete = "SELECT connectors_categ_sources.num_categ, connectors_sources.source_id as source_id, connectors_categ.connectors_categ_name as categ_name, connectors_sources.name, connectors_sources.comment, connectors_sources.repository, connectors_sources.opac_allowed, source_sync.cancel FROM connectors_sources LEFT JOIN connectors_categ_sources ON (connectors_categ_sources.num_source = connectors_sources.source_id) LEFT JOIN connectors_categ ON (connectors_categ.connectors_categ_id = connectors_categ_sources.num_categ) LEFT JOIN source_sync ON (connectors_sources.source_id = source_sync.source_id AND connectors_sources.repository=2) ORDER BY connectors_categ_sources.num_categ DESC, connectors_sources.name";
$resultat = mysql_query($requete);
$current_categ = 0;
$count = 0;
$facette = new facette_search();
while ($source = mysql_fetch_object($resultat)) {
$r .= "\n \t\t\t<tr>\n \t\t\t\t<td>" . htmlentities($source->name . ($source->comment ? " : " . $source->comment : ""), ENT_QUOTES, $charset) . "\n \t\t\t\t</td>\n \t\t\t\t<td>" . $this->create_list_fields($facette->array_sort(), $source->source_id, $this->info['search_field'][$source->source_id]['field'], $this->info['search_field'][$source->source_id]['ss_field']) . "\n \t\t\t\t</td>\n \t\t\t</tr>";
}
return $r;
}
