publications_states = array(); } protected function fetch_data(){ $rqt = "select * from cms_editorial_publications_states order by editorial_publication_state_label asc"; $res = mysql_query($rqt); if(mysql_num_rows($res)){ while($row = mysql_fetch_object($res)){ $this->publications_states[] =array( 'id' => $row->id_publication_state, 'label' => $row->editorial_publication_state_label, 'opac_show' => $row->editorial_publication_state_opac_show, 'auth_opac_show' => $row->editorial_publication_state_auth_opac_show ); } } } public function get_publications_states(){ if(!$this->publications_states) { $this->fetch_data(); } return $this->publications_states; } public function get_selector_options($selected=0){ global $charset; $options = ""; $this->get_publications_states(); for($i=0 ; $ipublications_states) ; $i++){ $options.= " "; } return $options; } public function get_table($form_link="./admin.php?categ=cms_editorial&sub=publication_state&action=edit"){ global $msg,$charset; $this->get_publications_states(); $table = " "; for($i=0 ; $ipublications_states) ; $i++){ $class = ($i%2 ? "odd":"even"); $table.= " "; } $table.= "

".$msg['editorial_content_publication_state_label']."	".$msg['editorial_content_publication_state_visible']."	".$msg['editorial_content_publication_state_visible_abo']."
".htmlentities($this->publications_states[$i]['label'],ENT_QUOTES,$charset)."	".($this->publications_states[$i]['opac_show'] ? "X" : "")."	".($this->publications_states[$i]['auth_opac_show'] ? "X" : "")."

"; return $table; } public function get_form($id=0,$url="./admin.php?categ=cms_editorial&sub=publication_state"){ global $msg,$charset; global $cms_editorial_publication_state_form; $this->get_publications_states(); $form =str_replace("!!action!!",$url,$cms_editorial_publication_state_form); if($id){ for($i=0 ; $ipublications_states) ; $i++){ if($this->publications_states[$i]['id'] == $id){ $publication_state = $this->publications_states[$i]; break; } } } if($publication_state['id']){ $form = str_replace("!!form_title!!",$msg['editorial_content_publication_state_edit'],$form); $form = str_replace("!!label!!",htmlentities($publication_state['label'],ENT_QUOTES,$charset),$form); $form = str_replace("!!visible!!",($publication_state['opac_show'] ? "checked='checked'": ""),$form); $form = str_replace("!!visible_abo!!",($publication_state['auth_opac_show'] ? "checked='checked'": ""),$form); $form = str_replace("!!id!!",$publication_state['id'],$form); $form = str_replace("!!bouton_supprimer!!","",$form); $form.= confirmation_delete($url); }else{ $form = str_replace("!!form_title!!",$msg['editorial_content_publication_state_add'],$form); $form = str_replace("!!label!!","",$form); $form = str_replace("!!visible!!","",$form); $form = str_replace("!!visible_abo!!","",$form); $form = str_replace("!!id!!",0,$form); $form = str_replace("!!bouton_supprimer!!","",$form); } return $form; } public function save(){ global $cms_editorial_publication_state_label,$cms_editorial_publication_state_visible,$cms_editorial_publication_state_visible_abo,$cms_editorial_publication_state_id; if($cms_editorial_publication_state_id){ $cms_editorial_publication_state_id+=0; $query = "update cms_editorial_publications_states set "; $clause = "where id_publication_state = ".$cms_editorial_publication_state_id; }else{ $query = "insert into cms_editorial_publications_states set "; $clause = ""; } $query.= " editorial_publication_state_label = '".$cms_editorial_publication_state_label."', editorial_publication_state_opac_show = ".($cms_editorial_publication_state_visible ? 1 : 0).", editorial_publication_state_auth_opac_show = ".($cms_editorial_publication_state_visible_abo ? 1 : 0); $query.= " ".$clause; mysql_query($query); } public function delete($id){ global $msg,$charset; $id+=0; if($id){ //on regarde si le statut est utilisé dans les rubriques $query = "select id_section from cms_sections where section_publication_state = ".$id; $result = mysql_query($query); if(mysql_num_rows($result)){ $error = $msg['publication_state_used_in_section']; }else{ //on regarde si le statut est utilisé dans les articles $query = "select id_article from cms_articles where article_publication_state = ".$id; $result = mysql_query($query); if(mysql_num_rows($result)){ $error = $msg['publication_state_used_in_article']; } } } if($error){ print " "; }else{ $query = "delete from cms_editorial_publications_states where id_publication_state = ".$id; mysql_query($query); } } }