/**
* File : join_file.php
*
* Add an answer in the process
*
* @package Maarch LetterBox 2.3
* @version 2.5
* @since 06/2007
* @license GPL
* @author Claire Figueras echo _PLEASE_SELECT_FILE;?> :
";
}
require_once("class_functions.php");
require_once("class_db.php");
function update_gid($gid)
{
if ($gid <> '')
{
$_SESSION['tmp_gid_id'] = $_SESSION['courrier']['gid_id'] + 1;
$_SESSION['courrier']['gid_id'] = $_SESSION['courrier']['gid_id'] + 1;
//$db_istres = new dbquery();
//$db_istres -> connect();
//$db_istres -> query("UPDATE parameters set VALUE = '".$gid."' where KEY1 = 'ISTRES_GDI'");
}
}
//Restore ISTRES_GDI Value:
$istres_db = new dbquery();
$istres_db -> connect();
$istres_db -> query("select * from parameters where KEY1 = 'ISTRES_GDI'");
$res_istres = $istres_db -> fetch_object();
$current_value = ($res_istres->VALUE) + 1;
$_SESSION['courrier']['gid_id'] = $current_value;
if(isset($_REQUEST['gid_id'])&&!empty($_REQUEST["gid_id"]))
{
$_SESSION['courrier']['gid_id'] = $_REQUEST['gid_id'];
}
$func = new functions();
$db_istres = new dbquery();
$db_istres -> connect();
$table = "res_x";
$_SESSION['error'] = "";
if($_POST['choix'])
{
if($_REQUEST['gid_id'] <> '')
{
$db_istres -> query("select count(*) as nb from res_x where GID_ID = '".$_POST['gid_id']."' ");
$res_istres = $db_istres -> fetch_object();
if($res_istres -> nb <> 0)
{
$_SESSION['error'] .= _GID_ID_EXISTS.".
";
}
}
else
{
$_SESSION['error'] .= _GID_ID_MISSING.".
";
}
$_SESSION['upfile'] = array();
if(empty($_FILES['file']['tmp_name']))
{
$_SESSION['error'] .= _FILE_MISSING.".
";
}
else
{
$_SESSION['upfile']['tmp_name'] = $_FILES['file']['tmp_name'];
}
if($_FILES['file']['size'] == 0)
{
$_SESSION['error'] .= _FILE_EMPTY.".
";
}
else
{
$_SESSION['upfile']['size'] = $_FILES['file']['size'];
}
if($_FILES['file']['error'] == 1)
{
$filesize = $func->return_bytes(ini_get("upload_max_filesize"));
$_SESSION['error'] = _ERROR_FILE_UPLOAD_MAX."(".round($filesize/1024,2)."Ko Max).
";
}
if(empty($_SESSION['error']))
{
$_SESSION['upfile']['name'] = $_FILES['file']['name'];
if(isset($_SESSION['upfile']) && !empty($_SESSION['upfile']))
{
$extension = explode(".",$_SESSION['upfile']['name']);
$count_level = count($extension)-1;
$the_ext = $extension[$count_level];
require("load_extensions.php");
$ext_ok = false;
for($i=0;$i
";
}
else
{
$info = $conn->fetch_object();
$docserver_id = $info->DOCSERVER_ID;
$docserver_size = $info->ACTUAL_SIZE + $_SESSION['upfile']['size'];
if($info->SIZE_LIMIT > 0 && $docserver_size >= $info->SIZE_LIMIT)
{
$_SESSION['error'] .= _NOT_ENOUGH_DISK_SPACE."."._MORE_INFOS." : ".$_SESSION['config']['adminname'].".
";
}
else
{
if(!is_uploaded_file($_FILES['file']['tmp_name']))
{
$_SESSION['error'] .= _FILE_NOT_SEND.". "._TRY_AGAIN."."._MORE_INFOS." : ".$_SESSION['config']['adminname'].".
";
}
else
{
$path_template = $info->PATH_TEMPLATE;
require("class_docserver.php");
$docserver = new docserver();
$docinfo = $docserver->filename(trim($info->PATH_TEMPLATE));
$destination_rept = $docinfo['destination_rept'];
$file_destination_name = $docinfo['file_destination_name'];
if(file_exists($destination_rept.$file_destination_name.".".$the_ext))
{
$_SESSION['error'] = _FILE_ALREADY_EXISTS.". "._MORE_INFOS." : ".$_SESSION['config']['adminname'].".";
header("location: enregistrement_doc.php");
exit;
}
if(!move_uploaded_file($_FILES['file']['tmp_name'],$destination_rept.$file_destination_name.".".$the_ext))
{
$_SESSION['error'] .= _FILE_SEND_ERROR.". "._TRY_AGAIN.". "._MORE_INFOS." : ".$_SESSION['config']['adminname'].".
";
}
else
{
$md5 = md5($destination_rept.$file_destination_name.".".$the_ext);
$conn->query("UPDATE ".$_SESSION['tablename']['docservers']." SET ACTUAL_SIZE=".$docserver_size." WHERE DOCSERVER_ID='".$docserver_id."'");
$destination_rept = substr($destination_rept,strlen($path_template),4);
if ($_SESSION['config']['system'] == "true")
{
$destination_rept = str_replace('/','#',$destination_rept);
}
else
{
$destination_rept = str_replace('\\','#',$destination_rept);
}
$_SESSION['courrier']['description'] = addslashes($_SESSION['courrier']['description']);
$conn->query("INSERT INTO ".$table." ( TITLE, RELATION, DESCRIPTION, FORMAT, CREATION_DATE,
DOC_DATE, DOCSERVER_ID, PATH, FILENAME, FILESIZE, STATUS, TYPIST,
TYPE_ID, CUSTOM_T3, CUSTOM_T4, AUTHOR, CUSTOM_D1, CUSTOM_D2, DESTINATION, DEST_USER, SOURCE, GID_ID )
VALUES
('".addslashes($_SESSION['upfile']['name'])."', '".$_SESSION['courrier']['res_id']."','".addslashes($_SESSION['courrier']['description'])."', '".strtoupper($the_ext)."', now() , '".$_SESSION['courrier']['doc_date']."','".$docserver_id."','"
.$destination_rept."','".$file_destination_name.".".strtolower($the_ext)
."',".$_SESSION['upfile']['size']
.",'REP','".$_SESSION['user']['UserId']
."','".$_SESSION['courrier']['type_id']."','".addslashes($_SESSION['courrier']['civ'])."',
'".addslashes($_SESSION['courrier']['prenom'])."', '".addslashes($_SESSION['courrier']['author'])."',
'".$_SESSION['courrier']['date_arrivee']."', '".$_SESSION['courrier']['date_limite']."' ,
'".addslashes($_SESSION['courrier']['service'])."', '".$_SESSION['courrier']['dest']."', 'Local File', 'R".date('Y').$_REQUEST['gid_id']."' )");
update_gid($_REQUEST['gid_id']);
$conn->query("select res_id from ".$table." where DOCSERVER_ID = '".$docserver_id."' and PATH = '".$destination_rept."' and FILENAME = '".$file_destination_name.".".strtolower($the_ext)."'" );
$res = $conn->fetch_object();
$id_rep = $res->res_id;
$conn->query("update ".$table." set fingerprint = '".$md5."' where res_id = ".$id_rep);
if($_SESSION['history']['resadd'] == "true")
{
require_once("class_history.php");
$users = new history();
$users->add($table, $_SESSION['courrier']['res_id'],"ADD", _NEW_ANSWER_ADDED." : ".$_SESSION['courrier']['identifier']." (".$_SESSION['courrier']['type_id'].")");
}
}
}
}
}
?>
}
}
}
}
?>
echo _ATTACH_ANSWER;?>