/** * \brief Retourne la liste des categories du type choisi * \param selected Id categorie preselectionnee * \param select_name Nom formulaire HTML */ function select_all_sections($selected='',$select_name='') { global $langs; $langs->load("ecm"); if ($select_name=="") $select_name="catParent"; $cat = new ECMDirectory($this->db); $cate_arbo = $cat->get_full_arbo(); $output = '<select class="flat" name="'.$select_name.'">'; if (is_array($cate_arbo)) { if (! sizeof($cate_arbo)) $output.= '<option value="-1" disabled="true">'.$langs->trans("NoCategoriesDefined").'</option>'; else { $output.= '<option value="-1"> </option>'; foreach($cate_arbo as $key => $value) { if ($cate_arbo[$key]['id'] == $selected) { $add = 'selected="selected" '; } else { $add = ''; } $output.= '<option '.$add.'value="'.$cate_arbo[$key]['id'].'">'.$cate_arbo[$key]['fulllabel'].'</option>'; } } } $output.= '</select>'; $output.= "\n"; return $output; }
/** * Create record into database * @param user User that create * @return int <0 if KO, >0 if OK */ function create($user) { global $conf, $langs; $now=dol_now(); // Clean parameters $this->label=dol_sanitizeFileName(trim($this->label)); $this->fk_parent=trim($this->fk_parent); $this->description=trim($this->description); if (! $this->cachenbofdoc) $this->cachenbofdoc=0; $this->date_c=$now; $this->fk_user_c=$user->id; if ($this->fk_parent <= 0) $this->fk_parent=0; // Check if same directory does not exists with this name $relativepath=$this->label; if ($this->fk_parent) { $parent = new ECMDirectory($this->db); $parent->fetch($this->fk_parent); $relativepath=$parent->getRelativePath().$relativepath; } $relativepath=preg_replace('/([\/])+/i','/',$relativepath); // Avoid duplicate / or \ //print $relativepath.'<br>'; $cat = new ECMDirectory($this->db); $cate_arbo = $cat->get_full_arbo(1); $pathfound=0; foreach ($cate_arbo as $key => $categ) { $path=str_replace($this->forbiddenchars,'_',$categ['fulllabel']); //print $path.'<br>'; if ($path == $relativepath) { $pathfound=1; break; } } if ($pathfound) { $this->error="ErrorDirAlreadyExists"; dol_syslog("EcmDirectories::create ".$this->error, LOG_WARNING); return -1; } else { $this->db->begin(); // Insert request $sql = "INSERT INTO ".MAIN_DB_PREFIX."ecm_directories("; $sql.= "label,"; $sql.= "entity,"; $sql.= "fk_parent,"; $sql.= "description,"; $sql.= "cachenbofdoc,"; $sql.= "date_c,"; $sql.= "fk_user_c"; $sql.= ") VALUES ("; $sql.= " '".$this->db->escape($this->label)."',"; $sql.= " '".$conf->entity."',"; $sql.= " '".$this->fk_parent."',"; $sql.= " '".$this->db->escape($this->description)."',"; $sql.= " ".($this->cachenbofdoc).","; $sql.= " '".$this->db->idate($this->date_c)."',"; $sql.= " '".$this->fk_user_c."'"; $sql.= ")"; dol_syslog("EcmDirectories::create sql=".$sql, LOG_DEBUG); $resql=$this->db->query($sql); if ($resql) { $this->id = $this->db->last_insert_id(MAIN_DB_PREFIX."ecm_directories"); $dir=$conf->ecm->dir_output.'/'.$this->getRelativePath(); $result=create_exdir($dir); // Appel des triggers include_once(DOL_DOCUMENT_ROOT . "/core/class/interfaces.class.php"); $interface=new Interfaces($this->db); $result=$interface->run_triggers('MYECMDIR_CREATE',$this,$user,$langs,$conf); if ($result < 0) { $error++; $this->errors=$interface->errors; } // Fin appel triggers if (! $error) { $this->db->commit(); return $this->id; } else { $this->db->rollback(); return -1; } } else { $this->error="Error ".$this->db->lasterror(); dol_syslog("EcmDirectories::create ".$this->error, LOG_ERR); $this->db->rollback(); return -1; } } }
print '<td align="right">'; print '</td>'; print '<td align="right"> </td>'; //print '<td align="right"><a href="'.DOL_URL_ROOT.'/ecm/docdir.php?action=create">'.img_edit_add().'</a></td>'; print '<td align="right"> </td>'; print '<td align="right"> </td>'; print '<td align="center">'; $htmltooltip=$langs->trans("ECMAreaDesc2"); print $form->textwithpicto('',$htmltooltip,1,0); print '</td>'; print '</tr>'; // Load full tree if (empty($sqltree)) $sqltree=$ecmdirstatic->get_full_arbo(0); // ----- This section will show a tree from a fulltree array ----- // $section must also be defined // ---------------------------------------------------------------- // Define fullpathselected ( _x_y_z ) of $section parameter $fullpathselected=''; foreach($sqltree as $key => $val) { //print $val['id']."-".$section."<br>"; if ($val['id'] == $section) { $fullpathselected=$val['fullpath']; break; }