idetagere = $etagere_id+0; $this->getData(); } // récupération infos etagere public function getData() { global $msg ; $this->name = ''; $this->comment = ''; $this->comment_gestion = ''; $this->autorisations = ""; $this->validite = ""; $this->validite_date_deb = ""; $this->validite_date_fin = ""; $this->validite_date_deb_f = ""; $this->validite_date_fin_f = ""; $this->visible_accueil = ""; $this->id_tri = 0; $this->thumbnail_url = ''; $this->classementGen = ''; if($this->idetagere) { $requete = "SELECT idetagere, name, comment, comment_gestion, validite, "; $requete .= "validite_date_deb, date_format(validite_date_deb, '".$msg["format_date"]."') as validite_date_deb_f, "; $requete .= "validite_date_fin, date_format(validite_date_fin, '".$msg["format_date"]."') as validite_date_fin_f, "; $requete .= "visible_accueil, autorisations, id_tri, thumbnail_url, etagere_classement FROM etagere WHERE idetagere='$this->idetagere' "; $result = pmb_mysql_query($requete); if(pmb_mysql_num_rows($result)) { $temp = pmb_mysql_fetch_object($result); $this->idetagere = $temp->idetagere; $this->name = $temp->name; $this->comment = $temp->comment; $this->comment_gestion = $temp->comment_gestion; $this->validite = $temp->validite; $this->validite_date_deb = $temp->validite_date_deb; $this->validite_date_deb_f = $temp->validite_date_deb_f; $this->validite_date_fin = $temp->validite_date_fin; $this->validite_date_fin_f = $temp->validite_date_fin_f; $this->visible_accueil = $temp->visible_accueil; $this->autorisations = $temp->autorisations; $this->id_tri = $temp->id_tri; $this->thumbnail_url = $temp->thumbnail_url; $this->classementGen = $temp->etagere_classement; } } } public function get_form() { global $msg, $charset; global $base_path; global $PMBuserid; global $pmb_javascript_office_editor; global $etagere_form; $form = $etagere_form; if($this->idetagere) { $form = str_replace('!!formulaire_titre!!', $msg['etagere_edit_etagere'], $form); $form = str_replace('!!formulaire_action!!', $base_path."/catalog.php?categ=etagere&sub=gestion&action=save_etagere&idetagere=".$this->idetagere, $form); $form = str_replace('!!autorisations_users!!', users::get_form_autorisations($this->autorisations,0), $form); } else { $form = str_replace('!!formulaire_titre!!', $msg['etagere_new_etagere'], $form); $form = str_replace('!!formulaire_action!!', $base_path."/catalog.php?categ=etagere&sub=gestion&action=valid_new_etagere", $form); $form = str_replace('!!autorisations_users!!', users::get_form_autorisations($this->autorisations,1), $form); } $form = str_replace('!!formulaire_annuler!!', $base_path."/catalog.php?categ=etagere&sub=gestion&action=", $form); $form = str_replace('!!idetagere!!', $this->idetagere, $form); $form = str_replace('!!name!!', htmlentities($this->name,ENT_QUOTES, $charset), $form); $bouton_suppr = "idetagere.",'".htmlentities(addslashes($this->name),ENT_QUOTES, $charset)."')\" />" ; $form = str_replace('', $bouton_suppr, $form); $form = str_replace('!!comment!!', $this->comment, $form); $form = str_replace('!!comment_gestion!!', $this->comment_gestion, $form); if($this->id_tri>0){ $sort = new sort("notices","base"); $form = str_replace('!!tri!!', $this->id_tri, $form); $form = str_replace('!!tri_name!!', $sort->descriptionTriParId($this->id_tri), $form); }else{ $form = str_replace('!!tri!!', "", $form); $form = str_replace('!!tri_name!!', $msg['etagere_form_no_active_tri'], $form); } if ($this->validite || !$this->idetagere) { $form = str_replace('!!checkbox_all!!', "checked", $form); $form = str_replace('!!form_visible_deb!!', "", $form); $form = str_replace('!!form_visible_fin!!', "", $form); } else { $form = str_replace('!!checkbox_all!!', "", $form); $form = str_replace('!!form_visible_deb!!', $this->validite_date_deb_f, $form); $form = str_replace('!!form_visible_fin!!', $this->validite_date_fin_f, $form); } if ($this->visible_accueil) $form = str_replace('!!checkbox_accueil!!', "checked", $form); else $form = str_replace('!!checkbox_accueil!!', "", $form); $message_folder = static::validate_img_folder(); $form = str_replace('!!message_folder!!', $message_folder, $form); $form = str_replace('!!thumbnail_url!!', $this->thumbnail_url, $form); $classementGen = new classementGen('etagere', $this->idetagere); $form = str_replace("!!object_type!!",$classementGen->object_type,$form); $form = str_replace("!!classements_liste!!",$classementGen->getClassementsSelectorContent($PMBuserid,$classementGen->libelle),$form); $js_script = confirmation_delete($base_path."/catalog.php?categ=etagere&action=del_etagere&idetagere="); if($pmb_javascript_office_editor){ $js_script .= $pmb_javascript_office_editor; $js_script .= ""; } return $js_script.$form; } public function set_properties_from_form() { global $form_etagere_name, $form_etagere_comment, $form_etagere_comment_gestion; global $form_visible_all, $form_visible_deb, $form_visible_fin; global $form_visible_accueil; global $tri, $f_thumbnail_url, $classementGen_etagere; global $autorisations; $this->name = stripslashes($form_etagere_name); $this->comment = stripslashes($form_etagere_comment); $this->comment_gestion = stripslashes($form_etagere_comment_gestion); $this->validite = $form_visible_all; $this->validite_date_deb_f = $form_visible_deb; $this->validite_date_fin_f = $form_visible_fin; $this->validite_date_deb = extraitdate($form_visible_deb); $this->validite_date_fin = extraitdate($form_visible_fin); $this->visible_accueil = $form_visible_accueil; $this->tri = $tri; $this->thumbnail_url = stripslashes($f_thumbnail_url); $this->classementGen = stripslashes($classementGen_etagere); if (is_array($autorisations)) { $this->autorisations=implode(" ",$autorisations); } else { $this->autorisations="1"; } } // liste des étagères disponibles public static function get_etagere_list() { global $msg ; $etagere_list=array(); $requete = "SELECT idetagere, name, comment, comment_gestion, validite, "; $requete .= "validite_date_deb, date_format(validite_date_deb, '".$msg["format_date"]."') as validite_date_deb_f, "; $requete .= "validite_date_fin, date_format(validite_date_fin, '".$msg["format_date"]."') as validite_date_fin_f, "; $requete .= "visible_accueil, autorisations, etagere_classement FROM etagere order by name "; $result = pmb_mysql_query($requete); if(pmb_mysql_num_rows($result)) { while ($temp = pmb_mysql_fetch_object($result)) { $sql = "SELECT COUNT(*) FROM etagere_caddie WHERE etagere_id = ".$temp->idetagere; $res = pmb_mysql_query($sql); $nbr_paniers = pmb_mysql_result($res, 0, 0); $etagere_list[] = array( 'idetagere' => $temp->idetagere, 'name' => $temp->name, 'comment' => $temp->comment, 'comment_gestion' => $temp->comment_gestion, 'validite' => $temp->validite, 'validite_date_deb' => $temp->validite_date_deb, 'validite_date_fin' => $temp->validite_date_fin, 'validite_date_deb_f' => $temp->validite_date_deb_f, 'validite_date_fin_f' => $temp->validite_date_fin_f, 'visible_accueil' => $temp->visible_accueil, 'autorisations' => $temp->autorisations, 'etagere_classement' => $temp->etagere_classement, 'nb_paniers' => $nbr_paniers ); } } return $etagere_list; } // création d'une etagere vide public function create_etagere() { $requete = "insert into etagere set name='".addslashes($this->name)."', comment='".addslashes($this->comment)."', comment_gestion='".addslashes($this->comment_gestion)."', validite='".$his->validite."', validite_date_deb='".$this->validite_date_deb."', validite_date_fin='".$this->validite_date_fin."', visible_accueil='".$this->visible_accueil."', autorisations='".$this->autorisations."'"; $result = pmb_mysql_query($requete); $this->idetagere = pmb_mysql_insert_id(); } // ajout d'un item panier public function add_panier($item=0) { if (!$item) return 0 ; $requete_compte = "select count(1) from etagere_caddie where etagere_id='".$this->idetagere."' and caddie_id='".$item."' "; $result_compte = pmb_mysql_query($requete_compte); $deja_item=pmb_mysql_result($result_compte, 0, 0); if (!$deja_item) { $requete = "insert into etagere_caddie set etagere_id='".$this->idetagere."', caddie_id='".$item."' "; $result = pmb_mysql_query($requete); } else return 0; return 1 ; } // suppression d'un item panier public function del_item($item=0) { $requete = "delete FROM etagere_caddie where etagere_id='".$this->idcaddie."' and caddie_id='".$item."' "; $result = pmb_mysql_query($requete); } // suppression d'une etagere public function delete() { $requete = "delete FROM etagere_caddie where etagere_id='".$this->idetagere."' "; $result = pmb_mysql_query($requete); $this->delete_vignette(); $requete = "delete FROM etagere where idetagere='".$this->idetagere."' "; $result = pmb_mysql_query($requete); } public function delete_vignette() { //Suppression de la vignette d'etagere thumbnail::delete($this->idetagere); } public function create_vignette() { $thumbnail_url=$this->thumbnail_url; // vignette de l'etagere $uploaded_thumbnail_url = thumbnail::create($this->idetagere, 'shelve'); if($uploaded_thumbnail_url) { $thumbnail_url = $uploaded_thumbnail_url; } return $thumbnail_url; } // sauvegarde de l'etagere public function save_etagere() { $this->thumbnail_url = $this->create_vignette(); if(!$this->thumbnail_url) { $this->delete_vignette(); } $requete = "update etagere set name='".addslashes($this->name)."', comment='".addslashes($this->comment)."', comment_gestion='".addslashes($this->comment_gestion)."', validite='".$this->validite."', validite_date_deb='".$this->validite_date_deb."', validite_date_fin='".$this->validite_date_fin."', visible_accueil='".$this->visible_accueil."', autorisations='".$this->autorisations."',id_tri='".$this->tri."',thumbnail_url='".addslashes($this->thumbnail_url)."',etagere_classement='".addslashes($this->classementGen)."' where idetagere='".$this->idetagere."'"; $result = pmb_mysql_query($requete); } // get_cart() : ouvre une étagère et récupère le contenu public function constitution($modif=1) { global $PMBuserid ; global $msg ; $liste = caddie::get_cart_list('NOTI'); if(sizeof($liste)) { $ret = pmb_bidi("
"); while(list($cle, $valeur) = each($liste)) { $rqt_autorisation=explode(" ",$valeur['autorisations']); if (array_search ($PMBuserid, $rqt_autorisation)!==FALSE || $PMBuserid==1) { if(!isset($myCart))$myCart = new caddie(0); $myCart->type=$valeur['type']; $print_cart[$myCart->type]["titre"]="".$msg["caddie_de_".$myCart->type]."".$msg['etagere_caddie_inclus']." | ".$msg['caddie_name']." |
---|