id_source = $id;
if(!$this->id_source){
$this->libelle_source ='';
} else {
$req="select libelle_source from suggestions_source where id_source='".$this->id_source."'";
$res = mysql_query($req,$dbh);
$src = mysql_fetch_object($res);
$this->libelle_source = $src->libelle_source;
}
}
/*
* Gestion des actions
*/
function proceed($action){
switch($action){
case 'save':
$this->save();
$this->show_form();
break;
case 'modif':
case 'add':
$this->show_edit_form();
break;
case 'del':
$ko = $this->delete();
if(!$ko) $this->show_form();
break;
default:
$this->show_form();
break;
}
}
/*
* Formulaire d'ajout/modification
*/
function show_edit_form(){
global $src_form, $msg, $charset;
if(!$this->id_source){
$src_form = str_replace('!!form_title!!',$msg[acquisition_ajout_src],$src_form);
$src_form = str_replace('!!libelle!!','',$src_form);
$src_form = str_replace('!!bouton_sup!!','',$src_form);
$src_form = str_replace('!!id!!','',$src_form);
} else {
$src_form .= "";
$src_form = str_replace('!!id!!',$this->id_source,$src_form);
$src_form = str_replace('!!form_title!!',$msg[acquisition_modif_src],$src_form);
$src_form = str_replace('!!libelle!!',htmlentities($this->libelle_source, ENT_QUOTES, $charset),$src_form);
$btn_sup = "
";
$tab_src =array();
$req = "select * from suggestions_source order by libelle_source";
$res=mysql_query($req,$dbh);
while ($row = mysql_fetch_object($res)){
$tab_src[$row->id_source] = $row->libelle_source;
}
if(count($tab_src) == 0){
$display .= "".$msg[acquisition_no_src_available]."";
}
$parity=1;
foreach($tab_src as $id_src=>$lib_src) {
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='$pair_impair'\" onmousedown=\"document.location='./admin.php?categ=acquisition&sub=src&act=modif&id_src=$id_src';\" ";
$display .= "".htmlentities($lib_src, ENT_QUOTES, $charset)."";
$display .= "";
}
$display .= "
";
print $display;
}
/*
* Cr�ation/Modification
*/
function save(){
global $dbh, $libelle;
if(!$this->id_source){
$req = "insert into suggestions_source set libelle_source='".$libelle."'";
} else {
$req="update suggestions_source set libelle_source='".$libelle."' where id_source='".$this->id_source."'";
}
mysql_query($req,$dbh);
}
//Suppression d'une source
function delete(){
global $dbh,$msg;
$error = false;
if($this->hasSuggestions()){
error_message($msg[321],$msg['acquisition_sugg_source_used'],1, 'admin.php?categ=acquisition&sub=src');
$error=true;
} else {
$req="delete from suggestions_source where id_source='".$this->id_source."'";
mysql_query($req,$dbh);
}
return $error;
}
//V�rifie si la source de suggestions est utilisee dans les suggestions
function hasSuggestions(){
global $dbh;
$q = "select count(1) from suggestions where sugg_source = '".$this->id_source."' ";
$r = mysql_query($q, $dbh);
return mysql_result($r, 0, 0);
}
}
?>