parameters['external_sources'] */ public function get_value(){ global $dbh; if(!count($this->value) && count($this->parameters['external_sources'])){ //vérifions que ce soit toujours des external_sources... $query ="select distinct source_id from connectors_sources where source_id in (".implode(",",$this->parameters['external_sources']).") and repository=1"; $result = pmb_mysql_query($query,$dbh); if(pmb_mysql_num_rows($result)){ while($row=pmb_mysql_fetch_object($result)){ $requete = "select distinct recid from entrepot_source_".$row->source_id." order by date_import DESC"; $resultat = pmb_mysql_query($requete,$dbh); $i = 0; while($ligne=pmb_mysql_fetch_object($resultat)){ if($this->parameters['nb_max_elements']==0 || $i < $this->parameters['nb_max_elements']){ $this->value[] = $ligne->recid; } $i++; } } } } return $this->value; } public function get_form(){ global $msg,$charset; if(!isset($this->parameters['nb_max_elements'])) $this->parameters['nb_max_elements'] = ''; $form ="
".$this->gen_select()."
"; return $form; } public function set_from_form(){ global $docwatch_selector_external_sources_select; global $docwatch_selector_external_sources_limit; $this->parameters['external_sources'] = $docwatch_selector_external_sources_select; $this->parameters['nb_max_elements'] = (int) $docwatch_selector_external_sources_limit; } protected function gen_select(){ global $dbh,$charset; if(!isset($this->parameters['external_sources']) || !$this->parameters['external_sources']){ $this->parameters['external_sources']= array(); } $query ="select source_id, name from connectors_sources where repository='1' order by name"; $result = pmb_mysql_query($query,$dbh); if(pmb_mysql_num_rows($result)){ $select =" "; }else{ $select = $msg["dsi_docwatch_selector_external_sources_select_no_repository"]; } return $select; } } // end of docwatch_selector_external_sources