type = $type;
$id = intval($id);
$this->links_patterns = $links_patterns;
if($id){
$this->id = $id;
$this->fetch_data();
$this->format_data_lang();
}
}
protected function fetch_data(){
if(!$this->id || ($this->type != "article" && $this->type != "section")) {
return false;
}
// les infos générales...
$rqt = "
SELECT *
FROM cms_".$this->type."s
WHERE id_".$this->type." ='".$this->id."'";
$res = pmb_mysql_query($rqt);
if(pmb_mysql_num_rows($res)){
$row = pmb_mysql_fetch_assoc($res);
$this->num_type = $row[$this->type."_num_type"];
$this->title = $row[$this->type."_title"];
$this->resume = $row[$this->type."_resume"];
$this->contenu = (isset($row[$this->type."_contenu"]) ? $row[$this->type."_contenu"] : "");
$this->publication_state = $row[$this->type."_publication_state"];
$this->start_date = $row[$this->type."_start_date"];
$this->end_date = $row[$this->type."_end_date"];
$this->num_parent = (isset($row[$this->type."_num_parent"]) ? $row[$this->type."_num_parent"] : $row["num_section"]);
$this->create_date = $row[$this->type."_creation_date"];
$this->last_update_date = $row[$this->type."_update_timestamp"];
if (!empty($this->links_patterns[$this->type])) {
$this->link = str_replace('!!id!!', $this->id, $this->links_patterns[$this->type]);
}
}
if(strpos($this->start_date,"0000-00-00")!== false){
$this->start_date = "";
}
if(strpos($this->end_date,"0000-00-00")!== false){
$this->end_date = "";
}
}
public function get_descriptors(){
global $lang;
if(!isset($this->descriptors)) {
$this->descriptors = array();
// les descripteurs...
$rqt = "select num_noeud from cms_".$this->type."s_descriptors where num_".$this->type." = '".$this->id."' order by ".$this->type."_descriptor_order";
$res = pmb_mysql_query($rqt);
if(pmb_mysql_num_rows($res)){
while($row = pmb_mysql_fetch_object($res)){
$descriptors = array();
$categ = new categories($row->num_noeud, $lang);
$descriptors["id"] = $categ->num_noeud;
$descriptors["lang"] = $categ->langue;
$descriptors["name"] = $categ->libelle_categorie;
$descriptors["comment"] = $categ->comment_public;
$this->descriptors[] = $descriptors;
}
}
}
return $this->descriptors;
}
public function get_fields_type(){
if(!isset($this->fields_type)){
$this->fields_type = array();
$query = "select id_editorial_type from cms_editorial_types where editorial_type_element = '".$this->type."_generic'";
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)){
$fields_type = new cms_editorial_parametres_perso(pmb_mysql_result($result,0,0));
$this->fields_type = $fields_type->get_out_values($this->id);
}
if($this->num_type){
$query = "select editorial_type_label, editorial_type_permalink_num_page, editorial_type_permalink_var_name from cms_editorial_types where id_editorial_type = ".$this->num_type;
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)){
$row = pmb_mysql_fetch_object($result);
$this->num_page = $row->editorial_type_permalink_num_page;
$this->var_name = $row->editorial_type_permalink_var_name;
if(!$this->num_page || !$this->var_name){ //Récupération des éléments composants le permalien
$cms_editorial_types = new cms_editorial_types($this->type);
if($cms_editorial_types->get_generic_type()){
$generic_type = $cms_editorial_types->get_generic_type();
if($generic_type['var_name'] && $generic_type['num_page']){
$this->var_name = $generic_type['var_name'];
$this->num_page = $generic_type['num_page'];
}
}
}
$this->type_content = $row->editorial_type_label;
$fields_type = new cms_editorial_parametres_perso($this->num_type);
$this->fields_type = array_merge($this->fields_type, $fields_type->get_out_values($this->id));
}
}
}
return $this->fields_type;
}
public function get_documents(){
if(!isset($this->documents)) {
$documents_linked =array();
$query = "select document_link_num_document from cms_documents_links join cms_documents on document_link_num_document = id_document where document_link_type_object = '".$this->type."' and document_link_num_object = ".$this->id." order by document_create_date desc";
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)){
while($row = pmb_mysql_fetch_object($result)){
$documents_linked[] = $row->document_link_num_document;
}
}
foreach($documents_linked as $id_doc){
$document = new cms_document($id_doc);
$this->documents[] = $document->format_datas();
}
}
return $this->documents;
}
public function get_nb_documents() {
if(!isset($this->documents)) {
$this->get_documents();
}
return count($this->documents);
}
public function get_permalink(){
//on appelle get_fields_type pour recuperer le num_page et var_name
$this->get_fields_type();
if($this->num_page && $this->var_name){ //Le type d'élément sur lequel on se trouve a une page et une variable d'environnement renseignés
return "./index.php?lvl=cmspage&pageid=".$this->num_page."&".$this->var_name."=".$this->id;
}
return '';
}
public function get_num_page() {
return $this->num_page;
}
public function get_var_name() {
return $this->var_name;
}
public function get_id(){
return $this->id;
}
public function get_title(){
return $this->title;
}
public function get_logo() {
if (!isset($this->logo)) {
$this->logo = new cms_logo($this->id,$this->type);
}
return $this->logo->format_datas();
}
public function get_start_date() {
return format_date($this->start_date);
}
public function get_end_date() {
return format_date($this->end_date);
}
public function get_create_date() {
return format_date($this->create_date);
}
public function get_last_update_date() {
return format_date($this->last_update_date);
}
public function get_last_update_sql_date() {
return $this->last_update_date;
}
public function get_concepts() {
if (isset($this->concepts)) {
return $this->concepts;
}
$this->concepts = [];
$type_constant = 0;
switch ($this->type) {
case 'section':
$type_constant = TYPE_CMS_SECTION;
break;
case 'article':
$type_constant = TYPE_CMS_ARTICLE;
break;
}
$query = "
SELECT num_concept, order_concept
FROM index_concept
WHERE num_object = ".$this->id." AND type_object = ".$type_constant."
ORDER BY order_concept";
$result = pmb_mysql_query($query);
if (pmb_mysql_num_rows($result)) {
while ($row = pmb_mysql_fetch_assoc($result)){
$this->concepts[] = authorities_collection::get_authority(AUT_TABLE_INDEX_CONCEPT, $row["num_concept"]);
}
}
return $this->concepts;
}
public function get_type() {
if (!isset($this->type_content)) {
$this->get_fields_type();
}
return $this->type_content;
}
public function get_parent() {
if (isset($this->parent)) {
return $this->parent;
}
$parent = new cms_section($this->num_parent);
$this->parent = $parent->format_datas($this->links_patterns);
return $this->parent;
}
public function get_children(){
global $gestion_acces_active, $gestion_acces_empr_cms_section;
if (isset($this->children)) {
return $this->children;
}
$this->children = array();
if ($this->type == "section") {
if($this->id){
if ( ($gestion_acces_active==1) && ($gestion_acces_empr_cms_section==1) ) {
$ac = new acces();
$dom_7 = $ac->setDomain(7);
$acces_join = $dom_7->getJoin($_SESSION['id_empr_session'], 4, 'id_section');
$query = "SELECT id_section FROM cms_sections ";
$query.= "$acces_join ";
$query.= "WHERE section_num_parent = ".$this->id." ";
$query.= "AND ((section_start_date != 0 AND to_days(section_start_date)<=to_days(now()) AND to_days(section_end_date)>=to_days(now())) ";
$query.= "OR (section_start_date != 0 AND section_end_date =0 AND to_days(section_start_date)<=to_days(now())) ";
$query.= "OR (section_start_date = 0 AND to_days(section_end_date)>=to_days(now())) ";
$query.= "OR (section_start_date = 0 AND section_end_date = 0)) ";
$query.= "ORDER BY section_order";
} else {
$query = "SELECT id_section FROM cms_sections ";
$query.= "JOIN cms_editorial_publications_states ON section_publication_state=id_publication_state ";
$query.= "WHERE section_num_parent = ".$this->id." ";
$query.= "AND ((section_start_date != 0 AND to_days(section_start_date)<=to_days(now()) AND to_days(section_end_date)>=to_days(now())) ";
$query.= "OR (section_start_date != 0 AND section_end_date =0 AND to_days(section_start_date)<=to_days(now())) ";
$query.= "OR (section_start_date = 0 AND to_days(section_end_date)>=to_days(now())) ";
$query.= "OR (section_start_date = 0 AND section_end_date = 0)) ";
$query.= "AND (editorial_publication_state_opac_show=1".(!$_SESSION['id_empr_session'] ? " AND editorial_publication_state_auth_opac_show = 0" : "").") ";
$query.= "ORDER BY section_order";
}
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)){
while ($row = pmb_mysql_fetch_object($result)){
$child = new cms_section($row->id_section);
$this->children[] = $child->format_datas($this->links_patterns);
}
}
}
}
return $this->children;
}
public function get_social_media_sharing(){
global $opac_url_base;
return "
";
}
public function get_articles(){
global $gestion_acces_active, $gestion_acces_empr_cms_article;
if (isset($this->articles)) {
return $this->articles;
}
$articles = array();
if ($this->type == "section") {
if($this->id){
if ( ($gestion_acces_active==1) && ($gestion_acces_empr_cms_article==1) ){
$ac = new acces();
$dom_8 = $ac->setDomain(8);
$acces_join = $dom_8->getJoin($_SESSION['id_empr_session'], 4, 'id_article');
$query = "SELECT id_article FROM cms_articles ";
$query.= "$acces_join ";
$query.= "WHERE num_section = ".$this->id." ";
$query.= "AND ((article_start_date != 0 AND to_days(article_start_date)<=to_days(now()) ";
$query.= "AND to_days(article_end_date)>=to_days(now())) ";
$query.= "OR (article_start_date != 0 AND article_end_date =0 AND to_days(article_start_date)<=to_days(now())) ";
$query.= "OR (article_start_date=0 AND article_end_date=0) ";
$query.= "OR (article_start_date = 0 AND to_days(article_end_date)>=to_days(now()))) ";
$query.= "ORDER BY article_order";
} else {
$query = "SELECT id_article FROM cms_articles ";
$query.= "JOIN cms_editorial_publications_states ON article_publication_state=id_publication_state ";
$query.= "WHERE num_section = ".$this->id." ";
$query.= "AND ((article_start_date != 0 AND to_days(article_start_date)<=to_days(now()) ";
$query.= "AND to_days(article_end_date)>=to_days(now())) ";
$query.= "OR (article_start_date != 0 AND article_end_date =0 AND to_days(article_start_date)<=to_days(now())) ";
$query.= "OR (article_start_date=0 AND article_end_date=0) ";
$query.= "OR (article_start_date = 0 AND to_days(article_end_date)>=to_days(now()))) ";
$query.= "AND (editorial_publication_state_opac_show=1".(!$_SESSION['id_empr_session'] ? " AND editorial_publication_state_auth_opac_show = 0" : "").") ";
$query.= "ORDER BY article_order";
}
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)){
while ($row = pmb_mysql_fetch_object($result)){
$article = new cms_article($row->id_article);
$articles[] = $article->format_datas($this->links_patterns);
}
}
}
}
$this->articles = $articles;
return $this->articles;
}
public function get_content(){
// Anciennement, le contenu d'un article sortait sous la variable Django {{content}}.
// On ne peut pas changer ce comportement sans avoir à repasser PARTOUT.
// Donc on ajoute la feinte qui va bien...
return $this->contenu;
}
public function __get($attribute) {
//Test du getter en premier pour le get_type() afin d'être compatible à l'existant
if (method_exists($this, "get_".$attribute)) {
return call_user_func_array(array($this, "get_".$attribute), []);
} else if (isset($this->{$attribute})) {
return $this->{$attribute};
} else if (method_exists($this, $attribute)) {
return call_user_func_array(array($this, $attribute), []);
} else if (method_exists($this, "is_".$attribute)) {
return call_user_func_array(array($this, "is_".$attribute), []);
}
return null;
}
public function __set($name, $value){
$this->{$name} = $value;
}
public function get_avis_display() {
if (!$this->get_avis_allowed()) {
return "";
}
$avis_const = AVIS_ARTICLES;
if($this->type == "section") {
$avis_const = AVIS_SECTIONS;
}
$avis = new avis($this->id, $avis_const);
return $avis->get_display_detail();
}
protected function get_avis_allowed() {
global $opac_avis_allow;
global $allow_avis;
if(($opac_avis_allow && $opac_avis_allow !=2) || ($_SESSION["user_code"] && $opac_avis_allow ==2 && $allow_avis)) {
return true;
} else {
return false;
}
}
private function format_data_lang() {
global $lang, $opac_default_lang;
$lang_tmp = $lang;
$default_lang = $opac_default_lang;
if (empty($default_lang)) {
$default_lang = "fr_FR";
}
if ($lang_tmp != $default_lang) {
$this->get_fields_type();
$lang_tmp = pmb_strtolower($lang_tmp);
foreach ($this->fields_type as $key => $value) {
switch ($key) {
case "section_title_".$lang_tmp:
case "article_title_".$lang_tmp:
if ($value) $this->title = $value["values"][0]["format_value"];
break;
case "section_resume_".$lang_tmp:
case "article_resume_".$lang_tmp:
if ($value) $this->resume = $value["values"][0]["format_value"];
break;
case "article_content_".$lang_tmp:
case "article_contenu_".$lang_tmp:
if ($value) $this->contenu = $value["values"][0]["format_value"];
break;
default:
if (strpos($key, $lang_tmp) !== false) {
if ($value) $this->fields_type[str_replace("_".$lang_tmp, "", $key)] = $value;
}
break;
}
}
}
}
public function get_link() {
if (!empty($this->link)) {
return $this->link;
}
if (!empty($this->links_patterns[$this->type])) {
$this->link = str_replace('!!id!!', $this->id, $this->links_patterns[$this->type]);
}
return $this->link;
}
}