fetch_datas();
}
protected function fetch_datas(){
$this->collections=array();
$query = "select id_collection from cms_collections order by collection_title asc";
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)){
while($row = pmb_mysql_fetch_object($result)){
$this->collections[] = new cms_collection($row->id_collection);
}
}
}
public function get_table($form_link=""){
global $msg;
if(!$form_link){
$form_link="./cms.php?categ=collection&sub=collection&action=edit";
}
$table = "
";
return $table;
}
public function process($action=""){
global $id;
switch($action){
case "edit" :
$collection = new cms_collection($id);
print $collection->get_form();
break;
case "delete" :
$collection = new cms_collection($id);
$collection->delete();
$this->fetch_datas();
print $this->get_table();
break;
case "save" :
$collection = new cms_collection();
$collection->save_form();
$this->fetch_datas();
print $this->get_table();
break;
case "list" :
default :
print $this->get_table();
break;
}
}
public function get_documents_form($selected=array()){
global $msg,$charset;
$list ="
".htmlentities($msg['cms_documents_add'])." ";
foreach($this->collections as $collection){
$coll_form = "
";
$coll_form = $collection->get_documents_form($selected);
$coll_form.= "
";
$list.=gen_plus('collection'.$collection->id,$collection->title." (".$collection->nb_doc." ".$msg['cms_document'].")",$coll_form);
}
return $list;
}
}
class cms_collection extends cms_root{
public $id=0;
public $title ="";
public $description = "";
public $num_parent = 0;
public $num_storage = 0;
public $nb_doc=0;
public $documents =array();
public function __construct($id=0){
$this->id = $id*1;
$this->fetch_datas_cache();
}
protected function fetch_datas_cache(){
if($tmp=cms_cache::get_at_cms_cache($this)){
$this->restore($tmp);
}else{
$this->fetch_datas();
cms_cache::set_at_cms_cache($this);
}
}
protected function restore($cms_object){
foreach(get_object_vars($cms_object) as $propertieName=>$propertieValue){
$this->{$propertieName}=$propertieValue;
}
}
public function fetch_datas(){
$query = "select id_collection,collection_title, collection_description, collection_num_parent, collection_num_storage, count(id_document) as nb_doc from cms_collections left join cms_documents on document_type_object='collection' and document_num_object = id_collection where id_collection = '".$this->id."' group by id_collection";
$result = pmb_mysql_query($query);
if(pmb_mysql_num_rows($result)){
$row = pmb_mysql_fetch_object($result);
$this->id = $row->id_collection;
$this->title = $row->collection_title;
$this->description = $row->collection_description;
$this->num_parent = $row->collection_num_parent;
$this->num_storage = $row->collection_num_storage;
$this->nb_doc = $row->nb_doc;
}else{
$this->id = 0;
$this->title = "";
$this->description = "";
$this->num_parent = 0;
$this->nb_doc = 0;
}
}
public function get_form($form_link=""){
global $cms_collection_form;
global $msg,$charset;
if(!$form_link){
$form_link="./cms.php?categ=collection&sub=collection&action=save";
}
//lien pour la soumission du formulaire
$form = str_replace("!!action!!",$form_link,$cms_collection_form);
//id
$form = str_replace("!!id!!",htmlentities($this->id,ENT_QUOTES,$charset), $form);
//titre
$form = str_replace("!!label!!",htmlentities($this->title,ENT_QUOTES,$charset), $form);
//description
$form = str_replace("!!comment!!",htmlentities($this->description,ENT_QUOTES,$charset), $form);
//bouton supprimer
if($this->id){
$form = str_replace("!!form_title!!",$msg['cms_collection_edit'],$form);
$form = str_replace("!!bouton_supprimer!!","";
foreach($this->documents as $document){
$list.= $document->get_item_render("openEditDialog");
}
$upload_max_filesize = ini_get('upload_max_filesize');
if (!$upload_max_filesize) {
$upload_max_filesize = 50000;
} else {
$upload_max_filesize = trim($upload_max_filesize);
$last = strtolower($upload_max_filesize[strlen($upload_max_filesize)-1]);
switch($last) {
// Le modifieur 'G' est disponible depuis PHP 5.1.0
case 'g':
$upload_max_filesize *= 1024;
case 'm':
$upload_max_filesize *= 1024;
case 'k':
$upload_max_filesize *= 1024;
}
}
$list.= "
".htmlentities($msg['drag_files_here'],ENT_QUOTES,$charset)."
";
foreach($this->documents as $document){
if(in_array($document->id,$used)){
$selected = true;
}else{
$selected = false;
}
$form.=$document->get_item_form($selected);
}
$upload_max_filesize = ini_get('upload_max_filesize');
if (!$upload_max_filesize) {
$upload_max_filesize = 50000;
} else {
$upload_max_filesize = trim($upload_max_filesize);
$last = strtolower($upload_max_filesize[strlen($upload_max_filesize)-1]);
switch($last) {
// Le modifieur 'G' est disponible depuis PHP 5.1.0
case 'g':
$upload_max_filesize *= 1024;
case 'm':
$upload_max_filesize *= 1024;
case 'k':
$upload_max_filesize *= 1024;
}
}
$form.="
".htmlentities($msg['drag_files_here'],ENT_QUOTES,$charset)."