/**
* Parcours des données de la table explnum
*/
function fetch_data()
{
global $dbh;
$rqt_expl = "select explnum_mimetype, explnum_nomfichier, explnum_extfichier, explnum_data, explnum_url, concat(repertoire_path,explnum_path) as path, explnum_repertoire from explnum left join upload_repertoire on repertoire_id=explnum_repertoire where explnum_id='" . $this->id_explnum . "'";
$result_expl = mysql_query($rqt_expl, $dbh);
if ($result_expl) {
while ($explnum = mysql_fetch_object($result_expl)) {
if ($explnum->explnum_data) {
//le fichier est en base
$this->file_content = $explnum->explnum_data;
} else {
//le fichier est en upload
$up = new upload_folder($explnum->explnum_repertoire);
$path = str_replace('//', '/', $explnum->path . $explnum->explnum_nomfichier);
if ($path) {
$path = $up->encoder_chaine($path);
if (file_exists($path)) {
$fp = fopen($path, "r");
if (filesize($path) && (filesize($path) < $this->return_bytes(ini_get('upload_max_filesize')) && (ini_get('memory_limit') * 1 == -1 || filesize($path) < $this->return_bytes(ini_get('memory_limit')) * 1 - memory_get_usage(true) * 1))) {
$this->file_content = fread($fp, filesize($path));
} else {
$this->file_content = "";
}
fclose($fp);
} else {
$this->file_content = "";
}
}
}
$this->file_url = $explnum->explnum_url;
$this->mimetype = $explnum->explnum_mimetype;
$this->explnum_nomfichier = $explnum->explnum_nomfichier;
$this->ext = $explnum->explnum_extfichier;
}
}
}
$res = pmb_mysql_query($rqt);
if ($res) {
$empr_carac = pmb_mysql_fetch_array($res);
$log->add_log('empr', $empr_carac);
}
$log->add_log('num_session', session_id());
$log->add_log('explnum', $infos_explnum);
$infos_restriction_abo = array();
foreach ($expl_num as $key => $value) {
$infos_restriction_abo[$key] = $value;
}
$log->add_log('restriction_abo', $infos_restriction_abo);
$log->save();
}
if ($ligne->explnum_path) {
$up = new upload_folder($ligne->repertoire_id);
$path = str_replace("//", "/", $ligne->path);
$path = $up->encoder_chaine($path);
$fo = fopen($path, 'rb');
$ligne->explnum_data = fread($fo, filesize($path));
$ligne->taille = filesize($path);
fclose($fo);
}
$nomfichier = "";
if ($ligne->explnum_nomfichier) {
$nomfichier = $ligne->explnum_nomfichier;
} elseif ($ligne->explnum_extfichier) {
if ($ligne->explnum_nom) {
$nomfichier = $ligne->explnum_nom;
if (!preg_match("/\\." . $ligne->explnum_extfichier . "\$/", $nomfichier)) {
$nomfichier .= "." . $ligne->explnum_extfichier;
function show_form_task($planificateur_id = "")
{
global $charset, $base_path, $msg;
global $planificateur_form, $act, $type_task_id, $subaction;
foreach ($this->types_taches as $type) {
if ($type->id_type == $type_task_id) {
$comment = $type->comment;
$name = $type->name;
$dir_upload_boolean = $type->dir_upload_boolean;
}
}
// Inclusion de la classe spécifique
if (is_file($base_path . '/admin/planificateur/' . $name . '/' . $name . '.class.php')) {
require_once $base_path . '/admin/planificateur/' . $name . '/' . $name . '.class.php';
eval("\$a_task=new " . $name . "();");
//Récupération des données du formulaire
if ($subaction == "change") {
global $task_name, $task_desc, $form_users, $task_active, $id_rep, $path;
global $task_perio_heure, $task_perio_min, $chkbx_task_quotidien, $chkbx_task_hebdo, $chkbx_task_mensuel;
global $timeout, $radio_histo_day_number, $histo_day, $histo_number, $restart_on_failure, $alert_mail_on_failure, $mail_on_failure;
$libelle_tache = stripslashes($task_name);
$desc_tache = stripslashes($task_desc);
$perio_heure = $task_perio_heure;
$statut = $task_active;
$rep_upload = $id_rep ? $id_rep : "";
$chemin_upload = $path ? $path : "";
$perio_heure = $task_perio_heure;
$perio_minute = $task_perio_min;
$perio_jour_mois = $chkbx_task_quotidien;
$perio_jour = $chkbx_task_hebdo;
$perio_mois = $chkbx_task_mensuel;
$param["timeout"] = $timeout;
$param["histo_day"] = $histo_day;
$param["histo_number"] = $histo_number;
$param["restart_on_failure"] = $restart_on_failure;
$param["alert_mail_on_failure"] = $alert_mail_on_failure . ($mail_on_failure ? "," . $mail_on_failure : "");
} else {
//Récupération des données de la base
$a_task->fetch_global_properties();
$tab_properties = $a_task->get_property_task_bdd($planificateur_id);
if (isset($tab_properties)) {
if (is_array($tab_properties)) {
foreach ($tab_properties as $atab_properties => $atab_propertiesv) {
// global $$atab_properties;
${$atab_properties} = $atab_propertiesv;
}
}
}
}
//form spécifique
$form_specific_task = $a_task->show_form($param);
} else {
$form_specific_task = "";
}
$planificateur_form = str_replace("!!script_js!!", "\n\t\t\t<script type='text/javascript' src='./javascript/select.js'></script>\n\t\t\t<script type='text/javascript' src='./javascript/upload.js'></script>", $planificateur_form);
$planificateur_form = str_replace("!!submit_action!!", "return checkForm();", $planificateur_form);
$planificateur_form = str_replace("!!libelle_type_task!!", $comment, $planificateur_form);
$planificateur_form = str_replace("!!task_name!!", htmlentities($libelle_tache, ENT_QUOTES, $charset), $planificateur_form);
$planificateur_form = str_replace("!!task_desc!!", htmlentities($desc_tache, ENT_QUOTES, $charset), $planificateur_form);
$rqt_user = mysql_query("select esuser_id, esuser_username from es_esusers");
$form_users = "<select name='form_users'>";
while ($row = mysql_fetch_object($rqt_user)) {
if ($row->esuser_id == $num_user) {
$form_users .= "<option value='" . $row->esuser_id . "' selected>" . $row->esuser_username . "</option>";
} else {
$form_users .= "<option value='" . $row->esuser_id . "'>" . $row->esuser_username . "</option>";
}
}
$form_users .= "</select>";
if (mysql_num_rows($rqt_user) == 0) {
$form_users .= "* " . $msg["planificateur_task_users_unknown"];
}
$planificateur_form = str_replace("!!task_users!!", $form_users, $planificateur_form);
$planificateur_form = str_replace("!!task_statut!!", "<input type='checkbox' name='task_active' id='task_active' value='" . $statut . "' " . ($statut != "0" ? " checked " : "''") . " onchange='changeStatut();'/>", $planificateur_form);
//ce type de tâche nécessite-t-il d'un répertoire d'upload pour les documents numériques?
if ($dir_upload_boolean != "0") {
$up = new upload_folder($rep_upload);
if ($subaction == 'change') {
$nom_chemin = $up->formate_path_to_nom($chemin_upload);
} else {
$nom_chemin = $up->formate_nom_to_path($up->repertoire_nom . $path_upload);
}
$planificateur_form = str_replace("!!div_upload!!", "<div class='row'>\n\t\t\t\t<div class='colonne3'><label for='timeout'/>" . $msg["print_numeric_ex_title"] . "</label></div>\n\t\t\t\t\t\t<div class='colonne_suite'>\n\t\t\t\t\t\t\t" . $msg["planificateur_upload"] . " : \n\t\t\t\t\t\t\t<input type='text' name='path' id='path' value='!!path!!' class='saisie-50emr' READONLY />\n\t\t\t\t\t\t\t<input type='button' id='upload_path' class='bouton' onclick='upload_openFrame(event)' value='...' name='upload_path' />\n\t\t\t\t\t\t\t<input id='id_rep' type='hidden' value='!!id_rep!!' name='id_rep' /> \n\t\t\t\t\t\t</div>\n\t\t\t\t</div>", $planificateur_form);
} else {
$planificateur_form = str_replace("!!div_upload!!", "", $planificateur_form);
}
$planificateur_form = str_replace('!!path!!', htmlentities($nom_chemin, ENT_QUOTES, $charset), $planificateur_form);
$planificateur_form = str_replace('!!id_rep!!', htmlentities($rep_upload, ENT_QUOTES, $charset), $planificateur_form);
$planificateur_form = str_replace("!!task_perio_heure!!", "<input type='text' id='task_perio_heure' name='task_perio_heure' value='" . $perio_heure . "' class='saisie-5em'/>", $planificateur_form);
$planificateur_form = str_replace("!!task_perio_min!!", "<input type='text' id='task_perio_min' name='task_perio_min' value='" . $perio_minute . "' class='saisie-5em'/>", $planificateur_form);
$planificateur_form = str_replace("!!help!!", "<a onclick='openPopUp(\"./admin/planificateur/help.php?action_help=configure_time\",\"help\",500,600,-2,-2,\"scrollbars=yes,menubar=0\"); w.focus(); return false;' href='#'>\n\t\t\t<img border='0' align='center' title='Aide...' alt='Aide...' src='" . $base_path . "/images/aide.gif' /></a>", $planificateur_form);
$perio_quotidien .= "<input type='checkbox' id='chkbx_task_quotidien_0' name='chkbx_task_quotidien[]' value='*' " . ($perio_jour_mois[0] == '*' ? "checked" : "''") . " onchange='changePerio(\"*\",\"chkbx_task_quotidien\",31);'> " . $msg["planificateur_task_all_days_of_month"] . "</input>";
for ($i = 1; $i <= 31; $i++) {
$cochee = false;
for ($j = 0; $j < sizeof($perio_jour_mois); $j++) {
if ($perio_jour_mois[$j] == $i) {
$cochee = true;
}
}
$perio_quotidien .= "<input type='checkbox' id='chkbx_task_quotidien_" . $i . "' name='chkbx_task_quotidien[]' value='" . $i . "' " . ($cochee == true ? "checked" : "''") . " onchange='changePerio({$i},\"chkbx_task_quotidien\",31);'/> " . $i . " ";
if ($i == 15) {
$perio_quotidien .= "<br />";
}
}
$planificateur_form = str_replace("!!task_perio_quotidien!!", $perio_quotidien, $planificateur_form);
$perio_hebdo .= "<input type='checkbox' id='chkbx_task_hebdo_0' name='chkbx_task_hebdo[]' value='*' " . ($perio_jour[0] == '*' ? "checked" : "''") . " onchange='changePerio(\"*\",\"chkbx_task_hebdo\",7);'> " . $msg["planificateur_task_all_days"] . "</input>";
for ($i = 1; $i <= 7; $i++) {
$cochee = false;
for ($j = 0; $j < sizeof($perio_jour); $j++) {
if ($perio_jour[$j] == $i) {
$cochee = true;
}
}
$perio_hebdo .= "<input type='checkbox' id='chkbx_task_hebdo_" . $i . "' name='chkbx_task_hebdo[]' value='" . $i . "' " . ($cochee == true ? "checked" : "''") . " onchange='changePerio({$i},\"chkbx_task_hebdo\",7);'/> " . $msg["week_days_{$i}"];
if ($i == 3) {
$perio_hebdo .= "<br />";
}
}
$planificateur_form = str_replace("!!task_perio_hebdo!!", $perio_hebdo, $planificateur_form);
$perio_mensuel .= "<input type='checkbox' id='chkbx_task_mensuel_0' name='chkbx_task_mensuel[]' value='*' " . ($perio_mois[0] == '*' ? " checked " : "''") . " onchange='changePerio(\"*\",\"chkbx_task_mensuel\",12);'> " . $msg["planificateur_task_all_months"] . "</input>";
for ($i = 1; $i <= 12; $i++) {
$cochee = false;
for ($j = 0; $j < sizeof($perio_mois); $j++) {
if ($perio_mois[$j] == $i) {
$cochee = true;
}
}
$perio_mensuel .= "<input type='checkbox' id='chkbx_task_mensuel_" . $i . "' name='chkbx_task_mensuel[]' value='" . $i . "' " . ($cochee == true ? "checked" : "''") . " onchange='changePerio({$i},\"chkbx_task_mensuel\",12);'> " . ucfirst($msg[$i + 1005]) . "</input>";
if ($i == 6) {
$perio_mensuel .= "<br />";
}
}
$planificateur_form = str_replace("!!task_perio_mensuel!!", $perio_mensuel, $planificateur_form);
$planificateur_form = str_replace("!!timeout!!", $param["timeout"], $planificateur_form);
$planificateur_form = str_replace("!!histo_day_checked!!", $param["histo_day"] != "" ? " checked " : "", $planificateur_form);
$planificateur_form = str_replace("!!histo_number_checked!!", $param["histo_number"] != "" ? " checked " : "", $planificateur_form);
$planificateur_form = str_replace("!!histo_day!!", $param["histo_day"], $planificateur_form);
$planificateur_form = str_replace("!!histo_day_visible!!", $param["histo_day"] == "" ? "disabled" : "", $planificateur_form);
$planificateur_form = str_replace("!!histo_number!!", $param["histo_number"], $planificateur_form);
$planificateur_form = str_replace("!!histo_number_visible!!", $param["histo_number"] == "" ? "disabled" : "", $planificateur_form);
$planificateur_form = str_replace("!!restart_on_failure_checked!!", $param["restart_on_failure"] ? " checked " : "", $planificateur_form);
$params_alert_mail = explode(",", $param["alert_mail_on_failure"]);
$planificateur_form = str_replace("!!alert_mail_on_failure_checked!!", $params_alert_mail[0] ? " checked " : "", $planificateur_form);
$planificateur_form = str_replace("!!mail_on_failure!!", $params_alert_mail[1], $planificateur_form);
//Inclusion du formulaire spécifique au type de tâche
$planificateur_form = str_replace("!!specific_form!!", $form_specific_task, $planificateur_form);
if ($act == "task_duplicate") {
$planificateur_id = 0;
}
if (!$planificateur_id) {
$bt_save = $base_path . "/admin.php?categ=planificateur&sub=manager&act=task&type_task_id=" . $type_task_id;
$bt_duplicate = "";
$bt_suppr = "";
} else {
$bt_save = $base_path . "/admin.php?categ=planificateur&sub=manager&act=task&type_task_id=" . $type_task_id . "&planificateur_id=" . $planificateur_id;
$bt_duplicate = "<input type='button' class='bouton' value='" . $msg["tache_duplicate_bouton"] . "' onclick='document.location=\"./admin.php?categ=planificateur&sub=manager&act=task_duplicate&type_task_id=" . $type_task_id . "&planificateur_id=" . $planificateur_id . "\"' />";
$bt_suppr = "<input type='button' class='bouton' value='" . $msg["63"] . "' onClick='location.href=\"{$base_path}/admin.php?categ=planificateur&sub=manager&act=task_del&type_task_id={$type_task_id}&planificateur_id=" . $planificateur_id . "\"'/>";
}
$planificateur_form = str_replace("!!bt_save!!", $bt_save, $planificateur_form);
$planificateur_form = str_replace("!!bt_duplicate!!", $bt_duplicate, $planificateur_form);
$planificateur_form = str_replace("!!bt_supprimer!!", $bt_suppr, $planificateur_form);
return $planificateur_form;
}
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: folders.inc.php,v 1.1 2009-07-03 09:35:36 kantin Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
require_once $class_path . "/upload_folder.class.php";
$upload_folder = new upload_folder($id, $action);
$upload_folder->proceed();
function explnum_add_from_url($f_notice_id, $f_bulletin_id, $f_nom, $f_url, $overwrite = true, $source_id = 0, $filename = '', $f_path = '', $f_statut)
{
global $dbh, $base_path;
if ($f_bulletin_id) {
$f_notice_id = 0;
} else {
if (!$f_bulletin_id && $f_notice_id) {
$f_bulletin_id = 0;
}
}
if (!$overwrite) {
$sql_find = "SELECT count(*) FROM explnum WHERE explnum_notice = " . $f_notice_id . " AND explnum_nom = '" . addslashes($f_nom) . "'";
$res = pmb_mysql_query($sql_find, $dbh);
$count = pmb_mysql_result($res, 0, 0);
if ($count) {
return;
}
}
$sql_delete = "DELETE FROM explnum WHERE explnum_notice = " . $f_notice_id . " AND explnum_nom = '" . addslashes($f_nom) . "' ";
pmb_mysql_query($sql_delete, $dbh);
$original_filename = basename($f_url);
$extension = substr($original_filename, strripos($original_filename, '.') * 1 + 1);
$tmp_filename = explnum::static_rename($extension);
if ($filename) {
$new_filename = $filename;
} else {
$new_filename = $tmp_filename;
}
//copie en répertoire temporaire
$r = false;
if (file_exists($f_url) && filesize($f_url)) {
//document en repertoire
$r = copy($f_url, $base_path . '/temp/' . $tmp_filename);
} else {
//url
$aCurl = new Curl();
$content = $aCurl->get($f_url);
$content = $content->body;
$r = file_put_contents("{$base_path}/temp/" . $tmp_filename, $content);
}
if ($r) {
//construction vignette
$vignette = construire_vignette('', $tmp_filename);
create_tableau_mimetype();
$mimetype = trouve_mimetype("{$base_path}/temp/" . $tmp_filename, $extension);
//si la source du connecteur est précisée, on regarde si on a pas un répertoire associé
$rep_upload = 0;
if ($source_id) {
$check_rep = "select rep_upload from connectors_sources where source_id = " . $source_id;
$res = pmb_mysql_query($check_rep);
if (pmb_mysql_num_rows($res)) {
$rep_upload = pmb_mysql_result($res, 0, 0);
}
}
if ($rep_upload != 0) {
$upload_folder = new upload_folder($rep_upload);
$rep_path = $upload_folder->get_path($new_filename);
if ($f_path && file_exists($rep_path . $f_path)) {
$rep_path = $rep_path . $f_path . '/';
}
if (file_exists($upload_folder->encoder_chaine($rep_path . $new_filename))) {
$suffix = 1;
$ext = extension_fichier($new_filename);
$file = str_replace("." . $ext, "", basename($new_filename));
while (file_exists($upload_folder->encoder_chaine($rep_path . $file . "_" . $suffix . "." . $ext))) {
$suffix++;
}
$new_filename = $file . "_" . $suffix . "." . $ext;
}
rename("{$base_path}/temp/" . $tmp_filename, $upload_folder->encoder_chaine($rep_path . $new_filename));
$path = $upload_folder->formate_path_to_save($upload_folder->formate_path_to_nom($rep_path));
$insert_sql = "INSERT INTO explnum (explnum_notice, explnum_bulletin, explnum_nom, explnum_nomfichier, explnum_mimetype, explnum_extfichier, explnum_vignette, explnum_repertoire, explnum_path, explnum_docnum_statut) VALUES (";
$insert_sql .= $f_notice_id . ",";
$insert_sql .= $f_bulletin_id . ",";
$insert_sql .= "'" . addslashes($f_nom) . "',";
$insert_sql .= "'" . addslashes($new_filename) . "',";
$insert_sql .= "'" . addslashes($mimetype) . "',";
$insert_sql .= "'" . addslashes($extension) . "',";
$insert_sql .= "'" . addslashes($vignette) . "',";
$insert_sql .= "'" . addslashes($rep_upload) . "',";
$insert_sql .= "'" . addslashes($path) . "',";
$insert_sql .= $f_statut;
$insert_sql .= ")";
} else {
$insert_sql = "INSERT INTO explnum (explnum_notice, explnum_bulletin, explnum_nom, explnum_nomfichier, explnum_mimetype, explnum_extfichier, explnum_data, explnum_vignette, explnum_docnum_statut) VALUES (";
$insert_sql .= $f_notice_id . ",";
$insert_sql .= $f_bulletin_id . ",";
$insert_sql .= "'" . addslashes($f_nom) . "',";
$insert_sql .= "'" . addslashes($new_filename) . "',";
$insert_sql .= "'" . addslashes($mimetype) . "',";
$insert_sql .= "'" . addslashes($extension) . "',";
$insert_sql .= "'" . addslashes($content) . "',";
$insert_sql .= "'" . addslashes($vignette) . "',";
$insert_sql .= $f_statut;
$insert_sql .= ")";
}
if (pmb_mysql_query($insert_sql, $dbh)) {
$docnum_id = pmb_mysql_insert_id($dbh);
if ($docnum_id) {
$index = new indexation_docnum($docnum_id);
$index->indexer();
}
}
/*
$aCurl = new Curl();
$content = $aCurl->get($f_url);
$content = $content->body;
$origine=str_replace(" ","",microtime());
$origine=str_replace("0.","",$origine);
$original_filename = basename($f_url);
if( $filename != "") $afilename = $filename;
else $afilename = $origine.$original_filename;
if (!$original_filename)
$original_filename = $afilename;
file_put_contents("$base_path/temp/".$afilename, $content);
*/
/*
$vignette = construire_vignette('', $afilename);
create_tableau_mimetype();
$afilename_ext=extension_fichier($afilename);
$mimetype = trouve_mimetype("$base_path/temp/".$afilename, $afilename_ext);
$extension = strrchr($afilename, '.');
//si la source du connecteur est précisée, on regarde si on a pas un répertoire associé
if ($source_id){
$check_rep = "select rep_upload from connectors_sources where source_id = ".$source_id;
$res = pmb_mysql_query($check_rep);
if(pmb_mysql_num_rows($res)){
$rep_upload = pmb_mysql_result($res,0,0);
}
}
*/
/*
if($rep_upload != 0){
$upload_folder = new upload_folder($rep_upload);
$rep_path = $upload_folder->get_path($afilename);
if ($f_path && file_exists($rep_path.$f_path)) {
$rep_path=$rep_path.$f_path.'/';
}
copy("$base_path/temp/".$afilename,$rep_path.$afilename);
$path =$upload_folder->formate_path_to_save($upload_folder->formate_path_to_nom($rep_path));
$insert_sql = "INSERT INTO explnum (explnum_notice, explnum_nom, explnum_nomfichier, explnum_mimetype, explnum_extfichier, explnum_vignette, explnum_repertoire, explnum_path) VALUES (";
$insert_sql .= $f_notice_id.",";
$insert_sql .= "'".addslashes($f_nom)."',";
$insert_sql .= "'".addslashes($afilename)."',";
$insert_sql .= "'".addslashes($mimetype)."',";
$insert_sql .= "'".addslashes($extension)."',";
$insert_sql .= "'".addslashes($vignette)."',";
$insert_sql .= "'".addslashes($rep_upload)."',";
$insert_sql .= "'".addslashes($path)."'";
$insert_sql .= ")";
}else{
$insert_sql = "INSERT INTO explnum (explnum_notice, explnum_nom, explnum_nomfichier, explnum_mimetype, explnum_extfichier, explnum_data, explnum_vignette) VALUES (";
$insert_sql .= $f_notice_id.",";
$insert_sql .= "'".addslashes($f_nom)."',";
$insert_sql .= "'".addslashes($afilename)."',";
$insert_sql .= "'".addslashes($mimetype)."',";
$insert_sql .= "'".addslashes($extension)."',";
$insert_sql .= "'".addslashes($content)."',";
$insert_sql .= "'".addslashes($vignette)."'";
$insert_sql .= ")";
}
pmb_mysql_query($insert_sql, $dbh);
unlink("$base_path/temp/".$afilename);
*/
}
}
function openCurrentDoc()
{
global $dbh;
//s'il est en cache, c'est vachement simple
if ($this->isInCache($this->listeDocs[$this->current]->explnum_id)) {
$document = $this->readInCache($this->listeDocs[$this->current]->explnum_id);
//sinon on va devoir regarder un peu ou ca se passe...
} elseif ($this->listeDocs[$this->current]->explnum_url != "") {
//on est sur une URL
$document = file_get_contents($this->listeDocs[$this->current]->explnum_url);
//on met les documents issues d'une URL en cache, ca évite les problèmes de connexion plus tard...
$this->setInCache($this->listeDocs[$this->current]->explnum_id, $document);
} elseif ($this->listeDocs[$this->current]->explnum_repertoire != 0) {
//le document est stocké dans un répertoire d'upload
$rep = new upload_folder($this->listeDocs[$this->current]->explnum_repertoire);
$filepath = $rep->encoder_chaine(str_replace("//", "/", $rep->repertoire_path . $this->listeDocs[$this->current]->explnum_path . "/" . $this->listeDocs[$this->current]->explnum_nomfichier));
$document = file_get_contents($filepath);
} else {
$requete = "SELECT explnum_data FROM explnum WHERE explnum_id = " . $this->listeDocs[$this->current]->explnum_id;
$res = pmb_mysql_query($requete, $dbh);
if (pmb_mysql_num_rows($res)) {
$document = pmb_mysql_result($res, 0, 0);
}
}
//on renvoie le contenu du document
return $document;
}
<?php
// +-------------------------------------------------+
// © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net)
// +-------------------------------------------------+
// $Id: upload_frame.php,v 1.2 2010-01-06 09:30:59 kantin Exp $
if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) {
die("no access");
}
// définition du minimum nécéssaire
$base_path = "../..";
$base_auth = "CATALOGAGE_AUTH";
$base_title = "\$msg[7]";
$include_path = "{$base_path}/includes";
$class_path = "{$base_path}/classes";
require_once "{$base_path}/includes/init.inc.php";
require_once "{$class_path}/upload_folder.class.php";
require_once $include_path . '/templates/upload_folder.tpl.php';
print "<div id='att' style='z-Index:1000'></div>";
print $up_frame;
$up = new upload_folder();
print $up->make_tree();
/**
* Construit les noeuds de l'arborescence
*/
function getNodes($chemin = '', $id, &$tree)
{
if ($chemin && is_dir($chemin)) {
if (($files = @scandir($chemin)) !== false) {
for ($i = 0; $i < sizeof($files); $i++) {
if ($files[$i] != '.' && $files[$i] != '..') {
$id_noeud = $id . "_" . $i;
$id_parent = $id;
$dir_name = $files[$i];
$path = $chemin . $dir_name . "/";
if (is_dir($path)) {
$id_copy = explode("_", $id_parent);
$up = new upload_folder($id_copy[1]);
//$tree .= "tab_libelle[\"$id_noeud\"] = \"".$up->decoder_chaine(addslashes($up->formate_path_to_nom($path))). "\";";
$tree .= "tab_libelle[\"{$id_noeud}\"] = \"" . addslashes($up->formate_path_to_nom($chemin) . $up->decoder_chaine($dir_name) . "/") . "\";";
$tree .= "_dt_fiel_.add('{$id_noeud}','{$id_parent}','" . addslashes($up->decoder_chaine($dir_name)) . "','','javascript:copy_to_div(\\'" . $id_noeud . "\\',\\'" . $up->repertoire_id . "\\');');\n";
$this->getNodes($path, $id_noeud, $tree);
}
}
}
}
}
return $tree;
}
function get_doc_num($explnum, $upload_folder)
{
global $pmb_set_time_limit, $dbh;
$report = array();
if (SESSrights & ADMINISTRATION_AUTH) {
@set_time_limit($pmb_set_time_limit);
if (is_array($explnum) && $upload_folder) {
$idLien = '';
if ($explnum['explnum_bulletin']) {
$query = "SELECT 1 FROM bulletins WHERE bulletin_id=" . $explnum['explnum_bulletin'];
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
$idLien = 'explnum_bulletin=' . $explnum['explnum_bulletin'];
}
} elseif ($explnum['explnum_notice']) {
$query = "SELECT 1 FROM notices WHERE notice_id=" . $explnum['explnum_notice'];
$result = pmb_mysql_query($query, $dbh);
if (pmb_mysql_num_rows($result)) {
$idLien = 'explnum_notice=' . $explnum['explnum_notice'];
}
}
if ($idLien) {
if (file_exists($upload_folder . $explnum['explnum_nomfichier'])) {
if (!$explnum['explnum_nom']) {
$explnum['explnum_nom'] = $explnum['explnum_nomfichier'];
}
if (!$explnum['explnum_repertoire']) {
$explnum['explnum_repertoire'] = '1';
}
if (!$explnum['explnum_statut']) {
$explnum['explnum_statut'] = '0';
}
if (!$explnum['explnum_path']) {
$explnum['explnum_path'] = '/';
}
if (!$explnum['explnum_extfichier']) {
$match = array();
if (preg_match('/.+\\.(.+)$/', $explnum['explnum_nomfichier'], $match)) {
$explnum['explnum_extfichier'] = $match[1];
}
}
if (!$explnum['explnum_mimetype']) {
$explnum['explnum_mimetype'] = trouve_mimetype($upload_folder . $explnum['explnum_nomfichier'], $explnum['explnum_extfichier']);
}
if (!$explnum['explnum_vignette']) {
$explnum['explnum_vignette'] = reduire_image($upload_folder . $explnum['explnum_nomfichier']);
}
$query = 'INSERT INTO explnum SET ' . $idLien . ',
explnum_nom="' . addslashes($explnum['explnum_nom']) . '",
explnum_mimetype="' . addslashes($explnum['explnum_mimetype']) . '",
explnum_extfichier="' . addslashes($explnum['explnum_extfichier']) . '",
explnum_nomfichier="' . addslashes($explnum['explnum_nomfichier']) . '",
explnum_vignette="' . addslashes($explnum['explnum_vignette']) . '",
explnum_path="' . addslashes($explnum['explnum_path']) . '",
explnum_repertoire="' . addslashes($explnum['explnum_repertoire']) . '",
explnum_statut="' . addslashes($explnum['explnum_statut']) . '"';
pmb_mysql_query($query, $dbh);
$explnum['explnum_id'] = pmb_mysql_insert_id($dbh);
if ($explnum['explnum_id']) {
//on récup le répertoire dans lequel envoyer le fichier
$upload_repertoire = new upload_folder($explnum['explnum_repertoire']);
if (!is_dir($upload_repertoire->decoder_chaine($upload_repertoire->repertoire_path))) {
$report['error'][] = $this->msg['get_doc_num_upload_repertoire_do_not_exist'];
//On efface l'entrée
$query = 'DELETE FROM explnum WHERE explnum_id=' . $explnum['explnum_id'];
pmb_mysql_query($query, $dbh);
}
if (!rename($upload_folder . $explnum['explnum_nomfichier'], $upload_repertoire->decoder_chaine($upload_repertoire->repertoire_path) . $explnum['explnum_nomfichier'])) {
$report['error'][] = $this->msg['get_doc_num_rename_error'];
//On efface l'entrée
$query = 'DELETE FROM explnum WHERE explnum_id=' . $explnum['explnum_id'];
pmb_mysql_query($query, $dbh);
} else {
//Réussi ici, on réindex et on incrémente le résultat
$obj_explnum = new explnum($explnum['explnum_id']);
$index = new indexation_docnum($explnum['explnum_id']);
$index->indexer();
$report['info'] = 1;
}
} else {
//erreur de déplacement ou de création
$report['error'][] = $this->msg['get_doc_num_cant_create_explnum'];
}
} else {
$report['error'][] = $this->msg['get_doc_num_file_not_found'];
//On efface l'entrée
$query = 'DELETE FROM explnum WHERE explnum_id=' . $explnum['explnum_id'];
pmb_mysql_query($query, $dbh);
}
} else {
//doc num sans id notice ou bulletin
$report['error'][] = $this->msg['get_doc_num_missing_link'];
}
} else {
//il manque un param
$report['error'][] = $this->msg['get_doc_num_missing_param'];
}
}
return $report;
}
function get_file_content()
{
$resultat = mysql_query("SELECT explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_data, length(explnum_data) as taille,explnum_path, concat(repertoire_path,explnum_path,explnum_nomfichier) as path, repertoire_id FROM explnum left join upload_repertoire on repertoire_id=explnum_repertoire WHERE explnum_id = '" . $this->explnum_id . "' ");
$nb_res = mysql_num_rows($resultat);
if (!$nb_res) {
exit;
}
$ligne = mysql_fetch_object($resultat);
if ($ligne->explnum_data || $ligne->explnum_path) {
if ($ligne->explnum_path) {
$up = new upload_folder($ligne->repertoire_id);
$path = str_replace("//", "/", $ligne->path);
$path = $up->encoder_chaine($path);
if (file_exists($path) && filesize($path)) {
$fo = fopen($path, 'rb');
$data = fread($fo, filesize($path));
fclose($fo);
} else {
$data = "";
}
} else {
$data = $ligne->explnum_data;
}
}
return $data;
}
function merge()
{
global $msg, $dbh, $gestion_acces_active, $gestion_acces_empr_notice;
$cpt_doc_num = 0;
if (is_array($this->docnum_ids) && count($this->docnum_ids)) {
foreach ($this->docnum_ids as $explnum_id) {
$resultat = pmb_mysql_query("SELECT explnum_id, explnum_notice, explnum_bulletin, explnum_nom, explnum_mimetype, explnum_url, explnum_data, length(explnum_data) as taille,explnum_path, concat(repertoire_path,explnum_path,explnum_nomfichier) as path, repertoire_id FROM explnum left join upload_repertoire on repertoire_id=explnum_repertoire WHERE explnum_id = '{$explnum_id}' ", $dbh);
$nb_res = pmb_mysql_num_rows($resultat);
$ligne = pmb_mysql_fetch_object($resultat);
$id_for_rigths = $ligne->explnum_notice;
if ($ligne->explnum_bulletin != 0) {
//si bulletin, les droits sont rattachés à la notice du bulletin, à défaut du pério...
$req = "select bulletin_notice,num_notice from bulletins where bulletin_id =" . $ligne->explnum_bulletin;
$res = pmb_mysql_query($req);
if (pmb_mysql_num_rows($res)) {
$row = pmb_mysql_fetch_object($result);
$id_for_rigths = $row->num_notice;
if (!$id_for_rigths) {
$id_for_rigths = $row->bulletin_notice;
}
}
$type = "";
}
//droits d'acces emprunteur/notice
if ($gestion_acces_active == 1 && $gestion_acces_empr_notice == 1) {
$ac = new acces();
$dom_2 = $ac->setDomain(2);
$rights = $dom_2->getRights($_SESSION['id_empr_session'], $id_for_rigths);
}
//Accessibilité des documents numériques aux abonnés en opac
$req_restriction_abo = "SELECT explnum_visible_opac, explnum_visible_opac_abon FROM notice_statut, explnum, notices WHERE explnum_notice=notice_id AND statut=id_notice_statut AND explnum_id='{$explnum_id}' ";
$result = pmb_mysql_query($req_restriction_abo, $dbh);
if (!pmb_mysql_num_rows($result)) {
$req_restriction_abo = "SELECT explnum_visible_opac, explnum_visible_opac_abon\n\t\t\t\t\t\tFROM notice_statut, explnum, bulletins, notices\n\t\t\t\t\t\tWHERE explnum_bulletin = bulletin_id\n\t\t\t\t\t\tAND num_notice = notice_id\n\t\t\t\t\t\tAND statut = id_notice_statut\n\t\t\t\t\t\tAND explnum_id='{$explnum_id}' ";
$result = pmb_mysql_query($req_restriction_abo, $dbh);
}
$expl_num = pmb_mysql_fetch_array($result);
if ($rights & 16 || is_null($dom_2) && $expl_num["explnum_visible_opac"] && (!$expl_num["explnum_visible_opac_abon"] || $expl_num["explnum_visible_opac_abon"] && $_SESSION["user_code"])) {
if ($ligne->explnum_data || $ligne->explnum_path) {
if ($ligne->explnum_path) {
$up = new upload_folder($ligne->repertoire_id);
$path = str_replace("//", "/", $ligne->path);
$path = $up->encoder_chaine($path);
$fo = fopen($path, 'rb');
$ligne->explnum_data = fread($fo, filesize($path));
$ligne->taille = filesize($path);
fclose($fo);
}
// $ligne->explnum_data;
$filename = "./temp/doc_num_" . $explnum_id . session_id() . ".pdf";
$filename_list[] = $filename;
$fp = fopen($filename, "wb");
fwrite($fp, $ligne->explnum_data);
fclose($fp);
$cpt_doc_num++;
}
}
}
}
if ($cpt_doc_num > 1) {
$filename_output = "./temp/doc_num_output" . session_id() . ".pdf";
$cmd = "pdfunite " . implode(' ', $filename_list) . " " . $filename_output;
exec($cmd);
$contenu_merge = file_get_contents($filename_output);
unlink($filename_output);
foreach ($filename_list as $filename) {
unlink($filename);
}
header('Content-type: application/pdf');
print $contenu_merge;
} elseif ($cpt_doc_num) {
$contenu_merge = file_get_contents($filename_list[0]);
header('Content-type: application/pdf');
print $contenu_merge;
unlink($filename_list[0]);
}
}
