<?php

/**
* @brief   Action : Viser le courrier
*
* Ouverture, dans une fenêtre séparée en deux, d'un document entrant (+ ses informations) d'une part
* et de ses projets de réponses d'autre part. Possibilité de modifier les réponses, écrire des notes 
* et envoyer des mails rapidement
*
* @file visa_mail
* @author Nicolas Couture <couture@docimsol.com>
* @date $date$
* @version $Revision$
* @ingroup apps
*/

/**
* $confirm  bool false
*/
$confirm = false;
/**
* $etapes  array Contains only one etap : form
*/
$etapes = array('form');
/**
* $frm_width  Width of the modal (empty)
*/
$frm_width='';
/**
* $frm_height  Height of the modal (empty)
*/
$frm_height = '';
/**
* $mode_form  Mode of the modal : fullscreen
*/
$mode_form = 'fullscreen';

include('apps'.DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR.'definition_mail_categories.php');
	
require_once("core" . DIRECTORY_SEPARATOR . "class" . DIRECTORY_SEPARATOR 
    . "class_request.php");
require_once("core" . DIRECTORY_SEPARATOR . "class" . DIRECTORY_SEPARATOR 
    . "class_security.php");
require_once("core" . DIRECTORY_SEPARATOR . "class" . DIRECTORY_SEPARATOR 
    . "class_resource.php");


require_once "modules" . DIRECTORY_SEPARATOR . "visa" . DIRECTORY_SEPARATOR
			. "class" . DIRECTORY_SEPARATOR
			. "class_modules_tools.php";
$_ENV['date_pattern'] = "/^[0-3][0-9]-[0-1][0-9]-[1-2][0-9][0-9][0-9]$/";

function writeLogIndex($EventInfo)
{
    $logFileOpened = fopen($_SESSION['config']['logdir']."visa_mail.log", 'a');
    fwrite($logFileOpened, '[' . date('d') . '/' . date('m') . '/' . date('Y')
        . ' ' . date('H') . ':' . date('i') . ':' . date('s') . '] ' . $EventInfo
        . "\r\n"
    );
    fclose($logFileOpened);
}


function createPdfNotes($list_notes){
	
	define('FPDF_FONTPATH','modules/visa/class/font/');
	//above line is import to define, otherwise it gives an error : Could not include font metric file
	require('modules/visa/class/fpdf.php');
	require('modules/visa/class/fpdi.php');
	class ChargePdf extends FPDI
	{
	function LoadData($tab)
	{
		// Lecture des lignes du fichier
		$data = array();
		/*foreach($lines as $line)
			$data[] = explode(';',trim($line));*/
		for ($i = 0; $i < count($tab); $i++){
			$note = getNote($tab[$i]);
			$user = getInfosUser($note['user']);
			
			$data[] = array(utf8_decode($user['prenom']).' '.utf8_decode($user['nom']),$note['date'],utf8_decode($note['text']));
		}
		return $data;
	}

	var $widths;
	var $aligns;

	function SetWidths($w)
	{
		$this->widths=$w;
	}

	function SetAligns($a)
	{
		$this->aligns=$a;
	}

	function Row($data)
	{
		//Calcule la hauteur de la ligne
		$nb=0;
		for($i=0;$i<count($data);$i++)
			$nb=max($nb,$this->NbLines($this->widths[$i],$data[$i]));
		$h=5*$nb;
		$this->CheckPageBreak($h);
		for($i=0;$i<count($data);$i++)
		{
			$w=$this->widths[$i];	
			$a=isset($this->aligns[$i]) ? $this->aligns[$i] : 'L';
			$x=$this->GetX();$y=$this->GetY();
			$this->Rect($x,$y,$w,$h);
			$this->MultiCell($w,5,$data[$i],0,$a);
			$this->SetXY($x+$w,$y);
		}
		$this->Ln($h);
	}

	function CheckPageBreak($h)
	{
		if($this->GetY()+$h>$this->PageBreakTrigger)$this->AddPage($this->CurOrientation);
	}

	function NbLines($w,$txt)
	{
		$cw=&$this->CurrentFont['cw'];
		if($w==0)
			$w=$this->w-$this->rMargin-$this->x;
		$wmax=($w-2*$this->cMargin)*1000/$this->FontSize;
		$s=str_replace("\r",'',$txt);
		$nb=strlen($s);
		if($nb>0 and $s[$nb-1]=="\n")	$nb--;
		$sep=-1;$i=0;$j=0;$l=0;$nl=1;
		while($i<$nb)
		{
			$c=$s[$i];
			if($c=="\n")
			{
				$i++;$sep=-1;$j=$i;$l=0;$nl++;
				continue;
			}
			if($c==' ')	$sep=$i;
			$l+=$cw[$c];
			if($l>$wmax)
			{
				if($sep==-1)
				{
					if($i==$j)	$i++;
				}
				else
					$i=$sep+1;$sep=-1;$j=$i;$l=0;$nl++;
			}
			else
				$i++;
		}
		return $nl;
	}
	}

	$pdf = new ChargePdf();
	$pdf->addPage();
	$data = $pdf->LoadData($list_notes);
	$header = array('Nom', 'Consigne', 'Date');
	$pdf->SetFont('Arial','B',12);
	$pdf->SetY(30);
	//$pdf->Table($header, $data);
	$pdf->SetWidths(array(40,30,100));
	$pdf->SetAligns(array('C','C','C'));
	$pdf->Row(array('Nom', 'Date', 'Note'));
	$pdf->SetAligns(array('L','C','L'));
	$pdf->SetFont('Arial','',10);
	foreach($data as $d){
		$pdf->Row($d);
	}
	
	$outputFile = $_SESSION['config']['tmppath'] . DIRECTORY_SEPARATOR . "listNotes".$_SESSION['user']['UserId'].".pdf";
	$pdf->Output($outputFile, 'F');
	return $outputFile;
}

function getNotes($res_id){
	$db = new dbquery();
    $db->connect();
	$req_notes = "select * from notes where identifier = '".$res_id."'";
	$db->query($req_notes);

	$tab_notes = array();
	 while ($notes = $db->fetch_object()) {
		$note = "Note de ".$notes->user_id.", le ".$notes->date_note." : ".$notes->note_text;
		//array_push($tab_notes, $note);
		array_push($tab_notes, array('id_note'=>$notes->id,'user_id'=>$notes->user_id,'date_note'=>$notes->date_note,'note_text'=>$notes->note_text));
	}
	
	return $tab_notes;
}
function getNote($id_note){
	$note = array();
	$requete = "SELECT * from notes where id = $id_note";
	$db = new dbquery();
	$db->connect();
	$db->query($requete);
	$res=$db->fetch_object();
	$note['user'] = $res->user_id;
	$note['text'] = $res->note_text;
	$date = explode("-",$res->date_note);
	$note['date'] = $date[2]."/".$date[1]."/".$date[0];
	
	return $note;
}


/**
 * Gets the path of the file to displays
 *
 * @param $res_id String Resource identifier
 * @param $coll_id String Collection identifier
 * @return String File path
 **/
function get_file_path($res_id, $coll_id)
{
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
    $sec =new security();
    $view = $sec->retrieve_view_from_coll_id($coll_id);
    if(empty($view))
    {
        $view = $sec->retrieve_table_from_coll($coll_id);
    }
    $db = new dbquery();
    $db->connect();
    $db->query("select docserver_id, path, filename from ".$view." where res_id = ".$res_id);
    $res = $db->fetch_object();
    $path = preg_replace('/#/', DIRECTORY_SEPARATOR, $res->path);
    $docserver_id = $res->docserver_id;
    $filename = $res->filename;
    $db->query("select path_template from ".$_SESSION['tablename']['docservers']." where docserver_id = '".$docserver_id."'");
    $res = $db->fetch_object();
    $docserver_path = $res->path_template;

    return $docserver_path.$path.$filename;
}

function check_category($coll_id, $res_id)
{
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
    $sec =new security();
    $view = $sec->retrieve_view_from_coll_id($coll_id);

    $db = new dbquery();
    $db->connect();
    $db->query("select category_id from ".$view." where res_id = ".$res_id);
    $res = $db->fetch_object();

    if(!isset($res->category_id))
    {
        $ind_coll = $sec->get_ind_collection($coll_id);
        $table_ext = $_SESSION['collections'][$ind_coll]['extensions'][0];
        $db->query("insert into ".$table_ext." (res_id, category_id) VALUES (".$res_id.", '".$_SESSION['coll_categories']['letterbox_coll']['default_category']."')");
        //$db->show();
    }
}

function get_rep_path($res_id, $coll_id)
{
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."docservers_controler.php");
	$docserverControler = new docservers_controler();
    $sec =new security();
    $view = $sec->retrieve_view_from_coll_id($coll_id);
    if(empty($view))
    {
        $view = $sec->retrieve_table_from_coll($coll_id);
    }
    $db = new dbquery();
    $db->connect();

    //$db->query("select docserver_id, path, filename from ".$view." where res_id = ".$res_id);
    $db->query("select docserver_id from res_view_attachments where res_id_master = " . $res_id . " order by res_id desc");
    while ($res = $db->fetch_object()) {
        $docserver_id = $res->docserver_id;
        break;
    }

    $db->query("select path_template from ".$_SESSION['tablename']['docservers']." where docserver_id = '".$docserver_id."'");
    $res = $db->fetch_object();
    $docserver_path = $res->path_template;
	$db->query("select filename, path,title,res_id,res_id_version,attachment_type  from res_view_attachments where res_id_master = " . $res_id . " AND status <> 'OBS' AND status <> 'SIGN' AND status <> 'DEL' and attachment_type IN ('response_project','signed_response') order by creation_date asc");
	$array_reponses = array();
	$cpt_rep = 0;
	while ($res2 = $db->fetch_object()){
		$filename=$res2->filename;
		$path = preg_replace('/#/', DIRECTORY_SEPARATOR, $res2->path);
		$filename_pdf = str_replace(pathinfo($filename, PATHINFO_EXTENSION), "pdf",$filename);
		if (file_exists($docserver_path.$path.$filename_pdf)){
			$array_reponses[$cpt_rep]['path'] = $docserver_path.$path.$filename_pdf;
			$array_reponses[$cpt_rep]['title'] = $res2->title;
			$array_reponses[$cpt_rep]['attachment_type'] = $res2->attachment_type;
			if ($res2->res_id_version == 0){
				$array_reponses[$cpt_rep]['res_id'] = $res2->res_id;
				$array_reponses[$cpt_rep]['is_version'] = 0;
			}
			else{
				$array_reponses[$cpt_rep]['res_id'] = $res2->res_id_version;
				$array_reponses[$cpt_rep]['is_version'] = 1;
			}
			$cpt_rep++;
		}
	}
    return $array_reponses;
}
function getDossier($values_form){
	$dossier = array();
	$list_notes = array();
	foreach($values_form as $v){
		if ($v['ID'] == "contenu_dossier"){
			$val = explode("_",$v['VALUE']);
			array_push($dossier,array('type'=>$val[0],'id'=>$val[1]));
			if ($val[0] == "note"){
				array_push($list_notes,$val[1]);
			}
		}
	}
	if (count($list_notes) > 0){
		$path_file_notes = createPdfNotes($list_notes);
		array_push($dossier,array('type'=>'pdf_notes','path'=>$path_file_notes));
	}
	
	return $dossier;
}

function getPaths($dossier, $id_doc){
	//$paths = array();
	//foreach ($dossier as $d){
	for ($i = 0; $i < count($dossier); $i++){
		$id = $dossier[$i]['id'];
		if ($dossier[$i]['type'] == "initial"){
			$db = new dbquery();
			$db->connect();
			$resource = new resource();
			$whereClause = ' and 1=1';
			$adrTable = $_SESSION['collections'][0]['adr'];
			/* TEST VERSION */
			$sec = new security();
			$versionTable = $sec->retrieve_version_table_from_coll_id(
				'letterbox_coll'
			);
			$selectVersions = "select res_id from " 
            . $versionTable . " where res_id_master = " 
            . $id . " and status <> 'DEL' order by res_id desc";
			$dbVersions = new dbquery();
			$dbVersions->connect();
			$dbVersions->query($selectVersions);
			$lineLastVersion = $dbVersions->fetch_object();
			$lastVersion = $lineLastVersion->res_id;
			if ($lastVersion <> ''){
				$adr = $resource->getResourceAdr(
				$versionTable,
				$lastVersion,
				$whereClause,
				''
				);
			}
			else {
				$adr = $resource->getResourceAdr(
				"res_view_letterbox",
				$id,
				$whereClause,
				$adrTable
				);
			}
			/****************/
			//writeLogIndex(print_r($adr,true));
			
			$db->query("select path_template from ".$_SESSION['tablename']['docservers']." where docserver_id = '".$adr[0][0]['docserver_id']."'");
			$res = $db->fetch_object();
			$docserver_path = $res->path_template;
			
			if (isset($adr[0][0]['visu_filename']) && $adr[0][0]['visu_filename'] != "") $dossier[$i]['path'] = str_replace("//","/",$docserver_path . str_replace("#", DIRECTORY_SEPARATOR , $adr[0][0]['path']) . $adr[0][0]['visu_filename']);
			else $dossier[$i]['path'] = str_replace("//","/",$docserver_path . str_replace("#", DIRECTORY_SEPARATOR , $adr[0][0]['path']) . $adr[0][0]['filename']);
			
		}
		elseif ($dossier[$i]['type'] == "attach"){
			//writeLogIndex("Attach num $id");
			$path = get_attach_path_id($id, $id_doc, "letterbox_coll");
			//writeLogIndex(print_r($path,true));
			$dossier[$i]['path'] = $path;
		}
		elseif ($dossier[$i]['type'] == "note"){
		
		}
	}
	return $dossier;
}

function concat_files($dossier, $res_id){
	require_once "core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."docservers_controler.php";
	require_once "core".DIRECTORY_SEPARATOR."docservers_tools.php";
	require_once 'core/class/docserver_types_controler.php';

	$cmd = "pdftk ";
	foreach($dossier as $d){
		if (isset($d['path']))
			$cmd .= $d['path']." ";
	}
	
	$tmpFileName = 'tmp_file_' . $_SESSION['user']['UserId']
            . '_' . rand() . '.pdf';
	$filePathOnTmp = $_SESSION['config']['tmppath'] . $tmpFileName;
	
	$cmd .= " cat output ".$filePathOnTmp;
	exec($cmd);
	
	ajout_bdd($tmpFileName,$res_id);
}

function ajout_bdd($fnameTmp, $res_id){
	$db = new dbquery();
	$db->connect();
	$collId = 'letterbox_coll';

	require_once 'modules/attachments/attachments_tables.php';
	require_once "core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."docservers_controler.php";
	require_once "core".DIRECTORY_SEPARATOR."docservers_tools.php";
	require_once 'core/class/docserver_types_controler.php';

	
	$docserv_control = new docservers_controler();
	$docserverTypeControler = new docserver_types_controler();
	
	$docserver = $docserv_control->getDocserverToInsert($collId);
	
	if (empty($docserver)) {
    $_SESSION['error'] = _DOCSERVER_ERROR . ' : '
        . _NO_AVAILABLE_DOCSERVER . '. ' . _MORE_INFOS;
	} else {
		
		$newSize = $docserv_control->checkSize(
			$docserver, $filesize
		);
		if ($newSize == 0) {
        $_SESSION['error'] = _DOCSERVER_ERROR . ' : '
            . _NOT_ENOUGH_DISK_SPACE . '. ' . _MORE_INFOS . '.';
		} else {
			$title = "Dossier du document n°".$res_id;
			
			$fileInfos = array(
            'tmpDir'      => $_SESSION['config']['tmppath'],
            'size'        => filesize ($_SESSION['config']['tmppath'].$fnameTmp),
            'format'      => 'pdf',
            'tmpFileName' => $fnameTmp,
			);

			$storeResult = array();
			$storeResult = $docserv_control->storeResourceOnDocserver(
				$collId, $fileInfos
			);
			
			if (isset($storeResult['error']) && $storeResult['error'] <> '') {
				$_SESSION['error'] = $storeResult['error'];
			} else {
				require_once "core/class/class_request.php";
				$req = new request();
				$req->connect();
				
				$resAttach = new resource();
				$_SESSION['data'] = array();
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'typist',
						'value' => $_SESSION['user']['UserId'],
						'type' => 'string',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'format',
						'value' => 'pdf',
						'type' => 'string',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'docserver_id',
						'value' => $storeResult['docserver_id'],
						'type' => 'string',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'status',
						'value' => 'TRA',
						'type' => 'string',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'offset_doc',
						'value' => ' ',
						'type' => 'string',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'logical_adr',
						'value' => ' ',
						'type' => 'string',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'title',
						'value' => $req->protect_string_db($title),
						'type' => 'string',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'relation',
						'value' => 1,
						'type' => 'integer',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'coll_id',
						'value' => $collId,
						'type' => 'string',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'res_id_master',
						'value' => $res_id,
						'type' => 'integer',
					)
				);
				
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'type_id',
						'value' => 0,
						'type' => 'int',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'identifier',
						'value' => '1',
						'type' => 'string',
					)
				);
				array_push(
					$_SESSION['data'],
					array(
						'column' => 'attachment_type',
						'value' => 'print_folder',
						'type' => 'string',
					)
				);

				$id = $resAttach->load_into_db(
					RES_ATTACHMENTS_TABLE,
					$storeResult['destination_dir'],
					$storeResult['file_destination_name'] ,
					$storeResult['path_template'],
					$storeResult['docserver_id'], 
					$_SESSION['data'],
					$_SESSION['config']['databasetype']
				);
				
				$complete_path = $storeResult['path_template'].str_replace('#',DIRECTORY_SEPARATOR,$storeResult['destination_dir']).$storeResult['file_destination_name'];
				
				if ($id == false) {
					$_SESSION['error'] = $resAttach->get_error();
				} else {
					if ($_SESSION['history']['attachadd'] == "true") {
						$hist = new history();
						$sec = new security();
						$view = $sec->retrieve_view_from_coll_id(
							$collId
						);
						$hist->add(
							$view, $res_id, 'ADD', 'attachadd',
							ucfirst(_DOC_NUM) . $id . ' '
							. _NEW_ATTACH_ADDED . ' ' . _TO_MASTER_DOCUMENT
							. $res_id,
							$_SESSION['config']['databasetype'],
							'apps'
						);
						$hist->add(
							RES_ATTACHMENTS_TABLE, $id, 'ADD','attachadd',
							$_SESSION['error'] 
							. _NEW_ATTACHMENT,
							$_SESSION['config']['databasetype'],
							'attachments'
						);
					}
				}
				
				return $complete_path;
			}
			
			return 'null';
		}
	}
}

function get_attach_path($res_id, $coll_id)
{
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."docservers_controler.php");
	$docserverControler = new docservers_controler();
    $sec =new security();
    $view = $sec->retrieve_view_from_coll_id($coll_id);
    if(empty($view))
    {
        $view = $sec->retrieve_table_from_coll($coll_id);
    }
    $db = new dbquery();
    $db->connect();

    $db->query("select docserver_id, path, filename from ".$view." where res_id = ".$res_id);
    $res = $db->fetch_object();
    $docserver_id = $res->docserver_id;
	
	
	$db->query("select path_template from ".$_SESSION['tablename']['docservers']." where docserver_id = '".$docserver_id."'");
    $res = $db->fetch_object();
    $docserver_path = $res->path_template;
	$db->query("select filename, path,title,res_id,status,typist,creation_date,format,attachment_type from res_view_attachments where status <> 'DEL' AND status IN ('TRA','SIGN') AND res_id_master = " . $res_id . " order by attachment_type, creation_date asc");
	$array_attach = array();
	$cpt_rep = 0;
	while ($res2 = $db->fetch_object()){
		$filename=$res2->filename;
		$path = preg_replace('/#/', DIRECTORY_SEPARATOR, $res2->path);
		$filename_pdf = str_replace(pathinfo($filename, PATHINFO_EXTENSION), "pdf",$filename);
		$array_attach[$cpt_rep]['path'] = $docserver_path.$path.$filename_pdf;
		$array_attach[$cpt_rep]['title'] = $res2->title;
		$array_attach[$cpt_rep]['res_id'] = $res2->res_id;
		$array_attach[$cpt_rep]['attachment_type'] = $res2->attachment_type;
		$array_attach[$cpt_rep]['format'] = $res2->format;
		$array_attach[$cpt_rep]['typist'] = $res2->typist;
		$date = explode(" ",$res2->creation_date);
		$array_attach[$cpt_rep]['date'] = $date[0];
		$cpt_rep++;
	}
    return $array_attach;
}

function get_attach_path_id($id_attach, $id_doc, $coll_id)
{
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."docservers_controler.php");
	$docserverControler = new docservers_controler();
    $sec =new security();
    $view = $sec->retrieve_view_from_coll_id($coll_id);
    if(empty($view))
    {
        $view = $sec->retrieve_table_from_coll($coll_id);
    }
    $db = new dbquery();
    $db->connect();

    $db->query("select docserver_id, path, filename from ".$view." where res_id = ".$id_doc);
    $res = $db->fetch_object();
    $docserver_id = $res->docserver_id;
	
	
	$db->query("select path_template from ".$_SESSION['tablename']['docservers']." where docserver_id = '".$docserver_id."'");
    $res = $db->fetch_object();
    $docserver_path = $res->path_template;
	$db->query("select filename, path,title,res_id,status,typist,creation_date  from res_attachments where res_id = " . $id_attach );
	$res2 = $db->fetch_object();
	$filename=$res2->filename;
	$path = preg_replace('/#/', DIRECTORY_SEPARATOR, $res2->path);
	$path = str_replace ("//","/",$path);
	$filename_pdf = str_replace(pathinfo($filename, PATHINFO_EXTENSION), "pdf",$filename);
	return $docserver_path.$path.$filename_pdf;
}


function getDocsBasket(){
	$db = new dbquery();
	$db->connect();
	$orderstr = "order by creation_date desc";
	if (isset($_SESSION['last_order_basket'])) $orderstr = $_SESSION['last_order_basket'];
	$requete = "select res_id from ".$_SESSION['current_basket']['view']." where " . $_SESSION['current_basket']['clause'] . " $orderstr";
	$db->query($requete, true);
	$tab_docs = array();
	while($res = $db->fetch_object()){
		array_push($tab_docs,$res->res_id);
	}
	return $tab_docs;
}


function getInfosUser($user_id){
	$db=new dbquery();
	$db->connect();
	$db->query("SELECT firstname, lastname, group_id, entity_id from users u, usergroup_content uc, users_entities ue where u.user_id = '$user_id' AND uc.user_id = u.user_id AND ue.user_id = u.user_id AND ue.primary_entity='Y' AND uc.primary_group = 'Y' ");
	$user = array();
	$res = $db->fetch_object();
	$user['prenom'] = $res->firstname;
	$user['nom'] = $res->lastname;
	$user['groupe'] = $res->group_id;
	$user['entite'] = $res->entity_id;
	return $user;
}

function get_form_txt($values, $path_manage_action,  $id_action, $table, $module, $coll_id, $mode )
{
    if (preg_match("/MSIE 6.0/", $_SERVER["HTTP_USER_AGENT"]))
    {
        $browser_ie = true;
        $display_value = 'block';
    }
    elseif(preg_match('/msie/i', $_SERVER["HTTP_USER_AGENT"]) && !preg_match('/opera/i', $_SERVER["HTTP_USER_AGENT"]) )
    {
        $browser_ie = true;
        $display_value = 'block';
    }
    else
    {
        $browser_ie = false;
        $display_value = 'table-row';
    }
    unset($_SESSION['m_admin']['contact']);
    $_SESSION['req'] = "action";
    $res_id = $values[0];
    $_SESSION['doc_id'] = $res_id;

		// Ouverture de la modal

	$docLockerCustomPath = 'apps/maarch_entreprise/actions/docLocker.php';
    $docLockerPath = $_SESSION['config']['businessappurl'] . '/actions/docLocker.php';
    if (is_file($docLockerCustomPath))
        require_once $docLockerCustomPath;
    else if (is_file($docLockerPath))
        require_once $docLockerPath;
    else
        exit("can't find docLocker.php");

    $docLocker = new docLocker($res_id);
    if (!$docLocker->canOpen()) {
        $docLockerscriptError = '<script>';
            $docLockerscriptError .= 'destroyModal("modal_' . $id_action . '");';
            $docLockerscriptError .= 'alert("'._DOC_LOCKER_RES_ID.''.$res_id.''._DOC_LOCKER_USER.' ' . $_SESSION['userLock'] . '");';
        $docLockerscriptError .= '</script>';
        return $docLockerscriptError;
    }

    $frm_str = '';
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
    require_once("apps".DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_business_app_tools.php");
    require_once("modules".DIRECTORY_SEPARATOR."basket".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_modules_tools.php");
    require_once("apps".DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_types.php");
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php");

    $sec =new security();
    $core_tools =new core_tools();
    $b = new basket();
    $type = new types();
    $business = new business_app_tools();
	
	/*check_category($coll_id, $res_id);
    $data = get_general_data($coll_id, $res_id, 'minimal');*/
/*
    echo '<pre>';
    print_r($data);
    echo '</pre>';exit;
*/
	$db = new dbquery();
    $db->connect();
	$view = $sec->retrieve_view_from_coll_id($coll_id);
	$db->query("select alt_identifier,typist from " 
		. $view 
		. " where res_id = " . $res_id);
	$resChrono = $db->fetch_object();
	$chrono_number = $resChrono->alt_identifier;
	$typist = getInfosUser($resChrono->typist);
	$typist = $typist['prenom'].' '.$typist['nom'];
	
    $frm_str .= '<h2 class="tit" id="action_title">'._VISA_MAIL.' '._NUM.'<span id="numIdDocPage">'.$res_id.'</span>';
    $frm_str .= '</h2>';
	
	$frm_str .= '<div id="visa_listDoc">';
	$frm_str .= '<div class="listDocsBasket">';
	$tab_docs = getDocsBasket();
	//$frm_str .= '<pre>'.print_r($tab_docs,true).'</pre>';
	//$selectedCat = '';
	$list_docs = '';
	foreach($tab_docs as $num=>$res_id_doc){
		$list_docs .= $res_id_doc."#";
		if ($res_id_doc == $res_id){
			$classLine = ' class="selectedId" ';
		}
		else $classLine = ' class="unselectedId" ';
		$frm_str .= '<div '.$classLine.' onmouseover="this.style.cursor=\'pointer\';"  onclick="loadNewId(\'index.php?display=true&module=visa&page=update_printFolder\','.$res_id_doc.',\''.$coll_id.'\');" id="list_doc_'.$res_id_doc.'">';
		check_category($coll_id, $res_id_doc);
		$data = get_general_data($coll_id, $res_id_doc, 'minimal');
		if ($res_id_doc == $res_id){
			$selectedCat = $data['category_id']['value'];
			$curContact = $data['contact'];
			$curSubject = $data['subject'];
			$curDate = $data['doc_date'];
			$curNumDoc = $num;
			$curdest = $data['destination'];
		}
		
		$frm_str .= '<ul>';
		$frm_str .= '<li><b>';
		$frm_str .= $chrono_number . ' - ' .$res_id_doc;
		$frm_str .= '</b></li>';
		
		$frm_str .= '<li>';
		$frm_str .= '<i class="fa fa-user" title="Contact"></i> ';
		if(isset($data['contact']) && !empty($data['contact']))
        {
			if (strlen($data['contact']) > 35) $contact = substr($data['contact'],0,35).'...';
			else $contact = $data['contact'];
			$frm_str .= $contact;
		}
		$frm_str .= '</li>';
		
		$frm_str .= '<li>';
		$frm_str .= '<i class="fa fa-file" title="Objet"></i> ';
		if(isset($data['subject']) && !empty($data['subject']))
        {
			if (strlen($data['subject']) > 80) $subject = substr($data['subject'],0,80).'...';
			else $subject = $data['subject'];
			$frm_str .= $subject;
		}
		$frm_str .= '</li>';
		
		$frm_str .= '<li>';
		$frm_str .= '<i class="fa fa-calendar " title="Date d\'arrivée"></i> ';
		$frm_str .= $data['admission_date'];
		$frm_str .= ' <i class="fa fa-bell" title="Date limite"></i> ';
		$frm_str .= $data['process_limit_date'];
		$frm_str .= '</li>';
		
		$frm_str .= '</ul>';
		
		$frm_str .= '</div>';
	}
	$frm_str .= '</div>';
	
	$frm_str .= '<div class="toolbar">';
	$frm_str .= '<table>';	
	$frm_str .= '<tr>';
		$frm_str .= '<td style="width:33%";">';	
		$frm_str .= '<a href="javascript://" id="previous_doc" onclick="previousDoc(\'index.php?display=true&module=visa&page=update_printFolder\',\''.$coll_id.'\');"><i class="fa fa-chevron-up fa-2x" title="Précédent"></i></a>';
		
		$frm_str .= '</td>';
		
		$frm_str .= '<td style="width:33%";">';	
		$frm_str .= '<a href="javascript://" id="next_doc" onclick="nextDoc(\'index.php?display=true&module=visa&page=update_printFolder\',\''.$coll_id.'\');"><i class="fa fa-chevron-down fa-2x" title="Suivant"></i></a>';
		
		$frm_str .= '</td>';
		
		$frm_str .= '<td style="width:33%";">';	
		$frm_str .= '<a href="javascript://" id="cancel" onclick="javascript:$(\'baskets\').style.visibility=\'visible\';destroyModal(\'modal_'.$id_action.'\');reinit();"><i class="fa fa-undo fa-2x" title="Annuler"></i></a>';
		
		$frm_str .= '</td>';
	$frm_str .= '</tr>';	
	$frm_str .= '</table>';	
	$frm_str .= '</div>';
	$frm_str .= '</div>';
	
	$frm_str .= '<div id="visa_left">';
	
	$frm_str .= '<dl id="tabricatorLeft" >';
	
	//Onglet document
	$frm_str .= '<dt id="onglet_entrant">'._INCOMING.'</dt><dd style="overflow-y: hidden;">';
	$frm_str .= '<iframe src="'.$_SESSION['config']['businessappurl'].'index.php?display=true&dir=indexing_searching&page=view_resource_controler&visu&id='. $res_id.'&coll_id='.$coll_id.'" name="viewframevalidDoc" id="viewframevalidDoc"  scrolling="auto" frameborder="0"  style="width:100%;height:100%;" ></iframe></dd>';
	
	$frm_str .= '</dd>';
	
		$countAttachments = "select res_id from res_view_attachments where status NOT IN ('DEL','OBS') and res_id_master = " . $res_id . " and coll_id = '" . $coll_id . "'";
		$dbAttach = new dbquery();
		$dbAttach->query($countAttachments);
		if ($dbAttach->nb_result() > 0) {
			$nb_attach = ' (' . ($dbAttach->nb_result()). ')';
		}
	
		$frm_str .= '<dt id="onglet_pj">'. _ATTACHED_DOC .$nb_attach.'</dt><dd id="page_pj">';
		
		if ($core_tools->is_module_loaded('attachments')) {
        require 'modules/templates/class/templates_controler.php';
        $templatesControler = new templates_controler();
        $templates = array();
        $templates = $templatesControler->getAllTemplatesForProcess($curdest);
        $_SESSION['destination_entity'] = $curdest;
        //var_dump($templates);
        $frm_str .= '<div id="list_answers_div" onmouseover="this.style.cursor=\'pointer\';">';
            $frm_str .= '<div class="block" style="margin-top:-2px;">';
                $frm_str .= '<div id="processframe" name="processframe">';
                    $frm_str .= '<center><h2>' . _PJ . ', ' . _ATTACHEMENTS . '</h2></center>';
                    $req = new request;
                    $req->connect();
                    $req->query("select res_id from ".$_SESSION['tablename']['attach_res_attachments']
                        . " where (status = 'A_TRA' or status = 'TRA') and res_id_master = " . $res_id . " and coll_id = '" . $coll_id . "'");
                    //$req->show();
                    $nb_attach = 0;
                    if ($req->nb_result() > 0) {
                        $nb_attach = $req->nb_result();
                    }
                    $frm_str .= '<div class="ref-unit">';
                    $frm_str .= '<center>';
                    if ($core_tools->is_module_loaded('templates')) {
                        $frm_str .= '<input type="button" name="attach" id="attach" class="button" value="'
                            . _CREATE_PJ
                            .'" onclick="showAttachmentsForm(\'' . $_SESSION['config']['businessappurl']
                            . 'index.php?display=true&module=attachments&page=attachments_content\')" />';
                    }
                    $frm_str .= '</center><iframe name="list_attach" id="list_attach" src="'
                    . $_SESSION['config']['businessappurl']
                    . 'index.php?display=true&module=attachments&page=frame_list_attachments&load" '
                    . 'frameborder="0" width="100%" height="600px"></iframe>';
                    $frm_str .= '</div>';
                $frm_str .= '</div>';
            $frm_str .= '</div>';
            $frm_str .= '<hr />';
        $frm_str .= '</div>';
    }
	
	
		$frm_str .= '</dd>';
		
	//Onglet Avancement 
	$frm_str .= '<dt id="onglet_avancement">Avancement</dt><dd id="page_avancement" style="overflow-x: hidden;">';
	$frm_str .= '<dt id="onglet_avancement">Avancement</dt><dd id="page_avancement" style="overflow-x: hidden;">';
	$frm_str .= '<h2>'. _WF .'</h2>';
	$frm_str .= '<iframe src="' . $_SESSION['config']['businessappurl'].'index.php?display=true&dir=indexing_searching&page=document_workflow_history&id='. $res_id .'&coll_id='. $coll_id.'&load&size=full&small=true" name="workflow_history_document" width="100%" height="620px" align="left" scrolling="yes" frameborder="0" id="workflow_history_document"></iframe>';
	$frm_str .= '<br/>';
	$frm_str .= '<br/>';
	
	$frm_str .= '<span style="cursor: pointer;" onmouseover="this.style.cursor=\'pointer\';" onclick="new Effect.toggle(\'history_document\', \'blind\', {delay:0.2});whatIsTheDivStatus(\'history_document\', \'divStatus_all_history_div\');return false;">';
	$frm_str .= '<span id="divStatus_all_history_div" style="color:#1C99C5;"><<</span>';
	$frm_str .= '<b>&nbsp;'. _ALL_HISTORY .'</b>';
	$frm_str .= '</span>';
	$frm_str .= '<iframe src="' . $_SESSION['config']['businessappurl'].'index.php?display=true&dir=indexing_searching&page=document_history&id='. $res_id .'&coll_id='. $coll_id.'&load&size=full&small=true" name="history_document" width="100%" height="620px" align="left" scrolling="yes" frameborder="0" id="history_document" style="display:none;"></iframe>';

	$frm_str .= '</dd>';
	
	
	//Onglet notes
	if ($core_tools->is_module_loaded('notes')){
		require_once "modules" . DIRECTORY_SEPARATOR . "notes" . DIRECTORY_SEPARATOR
							. "class" . DIRECTORY_SEPARATOR
							. "class_modules_tools.php";
		$notes_tools    = new notes();
						
		//Count notes
		$nbr_notes = $notes_tools->countUserNotes($res_id, $coll_id);
		if ($nbr_notes > 0 ) $nbr_notes = ' ('.$nbr_notes.')';  else $nbr_notes = '';
		//Notes iframe
		$frm_str .= '<dt id="onglet_notes">'. _NOTES.$nbr_notes .'</dt><dd id="page_notes" style="overflow-x: hidden;"><h2>'. _NOTES .'</h2><iframe name="list_notes_doc" id="list_notes_doc" src="'. $_SESSION['config']['businessappurl'].'index.php?display=true&module=notes&page=notes&identifier='. $res_id .'&origin=document&coll_id='.$coll_id.'&load&size=full" frameborder="0" scrolling="no" width="99%" height="570px"></iframe></dd> ';	
	}
		
	
	$frm_str .= '</dl>';
	$frm_str .= '</div>';
	
	$frm_str .= '<form name="index_file" method="post" id="index_file" action="#" class="forms " style="text-align:left;height:95%;" >';
	$frm_str .= '<div id="visa_right">';
	
	$frm_str .= '<dl id="tabricatorRight"  style="height:98%;">';
	
	$frm_str .= '<dt>Dossier</dt><dd style="overflow-x: hidden;">';
	
	$frm_str .= '<div id="frm_error_'.$id_action.'" class="indexing_error"></div>';		
	$frm_str .= '<h2>Contenu du dossier de réponse</h2>';
	
	$frm_str .= '<p><b>Requérent</b> : '.$curContact.'</p>';
	$frm_str .= '<p><b>Objet</b> : '.$curSubject.'</p>';
	$frm_str .= '<hr/>';
	
	/*$circuit_visa = new visa();
	$frm_str .= $circuit_visa->getList($res_id, $coll_id, true);*/
	$tab_attach_file = get_attach_path($res_id, $coll_id);
	$frm_str .= '<table style="width:99%;">';
	$frm_str .= '<thead><tr><th style="width:25%;"></th><th style="width:40%;">Titre</th><th style="width:20%;">Rédacteur</th><th style="width:10%;">Date</th><th style="width:5%;"></th></tr></thead>';
	$frm_str .= '<tbody>';
	if ($selectedCat == "incoming"){
	$frm_str .= '<tr><td><h3>+ Courrier entrant</h3></td><td></td><td></td><td></td><td></td></tr>';
	$frm_str .= '<tr><td></td><td>'.$curSubject.'</td><td>'.$curContact.'</td><td>'.$curDate.'</td><td><input id="contenu_dossier" type="checkbox" name="dossier[]" value="initial_'.$res_id.'" checked></input></td></tr>';	
	}
	else{
		$frm_str .= '<tr><td><h3>+ Courrier sortant</h3></td><td></td><td></td><td></td><td></td></tr>';
		$frm_str .= '<tr><td></td><td>'.$curSubject.'</td><td>'.$typist.'</td><td>'.$curDate.'</td><td><input id="contenu_dossier" type="checkbox" name="dossier[]" value="initial_'.$res_id.'" checked></input></td></tr>';	
	}
	$currentStat = "";
	//$frm_str .= print_r($tab_attach_file,true);
	$bordereauExists = false;
	for ($i=0; $i<count($tab_attach_file);$i++){
		$auteur = getInfosUser($tab_attach_file[$i]['typist']);
		if ($tab_attach_file[$i]['attachment_type'] != $currentStat){
			
			if ($tab_attach_file[$i]['attachment_type'] == "response_project"){
				$frm_str .= '<tr><td><h3>+ Réponse(s) effectuée(s)</h3></td><td></td><td></td><td></td><td></td></tr>';			
				$checked = " checked";				
			}
			if ($tab_attach_file[$i]['attachment_type'] == "signed_response"){
				$frm_str .= '<tr><td><h3>+ Réponse(s) effectuée(s)</h3></td><td></td><td></td><td></td><td></td></tr>';			
				$checked = " checked";				
			}
			if ($tab_attach_file[$i]['attachment_type'] == "simple_attachment"){
				$frm_str .= '<tr><td><h3>+ Pièce(s) jointe(s)</h3></td><td></td><td></td><td></td><td></td></tr>';	
				$checked = " ";	
			}
			if ($tab_attach_file[$i]['attachment_type'] == "routing"){
				$frm_str .= '<tr><td><h3>+ Fiche de circulation</h3></td><td></td><td></td><td></td><td></td></tr>';	
				$checked = " checked ";
				$bordereauExists = true;
			}
				
			$currentStat = $tab_attach_file[$i]['attachment_type'];
		}
		
		if ($tab_attach_file[$i]['attachment_type'] == "simple_attachment" && $tab_attach_file[$i]['format'] != "pdf") $disabled = " disabled title=\"Il n'est pas possible d'imprimer une pièce d'un autre format que pdf\" ";	
		else  $disabled = " ";	
		
		$frm_str .= '<tr><td></td><td><a href="index.php?display=true&module=attachments&page=view_attachment&id='.$tab_attach_file[$i]['res_id'].'&res_id_master='.$res_id.'" target="_blank">'.$tab_attach_file[$i]['title'].'</a></td><td>'.$auteur['prenom'].' '.$auteur['nom'].'</td><td>'.$tab_attach_file[$i]['date'].'</td><td><input type="checkbox" id="contenu_dossier" name="dossier[]" value="attach_'.$tab_attach_file[$i]['res_id'].'" '.$checked.' '.$disabled.'></input></td></tr>';	
	}
	
	if (!$bordereauExists){
		$frm_str .= "<tr><td><h3 id=\"tit_bord\" onclick=\"window.open('".$_SESSION['config']['businessappurl']."/index.php?display=true&module=content_management&page=applet_popup_launcher&objectType=bordereauFromTemplate&objectId=113&objectTable=res_letterbox&resMaster=".$res_id."', '', 'height=301, width=301,scrollbars=no,resizable=no,directories=no,toolbar=no');\" ". "onmouseover=\"this.style.cursor='pointer';\" >+ Générer la fiche de circulation</h3></td><td></td><td></td><td></td><td></td></tr>";	
		$frm_str .= '<tr id="line_bord"><td></td><td></td><td></td><td></td><td><input type="checkbox" name="dossier[]" value="attach_" checked></input></td></tr>';	
	}
	
	$tab_notes = getNotes($res_id);
	if (count($tab_notes) > 0){
		$frm_str .= '<tr><td><h3>+ Notes</h3></td><td></td><td></td><td></td><td></td></tr>';	
		
		foreach($tab_notes as $note){
			$auteur = getInfosUser($note['user_id']);
			$frm_str .= '<tr><td></td><td>'.$note['note_text'].'</td><td>'.$auteur['prenom'].' '.$auteur['nom'].'</td><td>'.$note['date_note'].'</td><td><input type="checkbox" id="contenu_dossier" name="dossier[]" value="note_'.$note['id_note'].'"  ></input></td></tr>';	
		}
	}
	
	
	$frm_str .= '</tbody>';
	$frm_str .= '</table>';
	$frm_str .= '<hr/>';
	$frm_str .= '</dd>';
	
	
	//Onglet Circuit 
	$frm_str .= '<dt id="onglet_circuit">'._VISA_WORKFLOW.'</dt><dd id="page_circuit" style="overflow-x: hidden;">';
	$frm_str .= '<h2>'._VISA_WORKFLOW.'</h2>';
	
	$modifVisaWorkflow = false;
    if ($core_tools->test_service('config_visa_workflow', 'visa', false)) {
        $modifVisaWorkflow = true;
    }
	$visa = new visa();
	
	$frm_str .= '<div class="error" id="divError" name="divError"></div>';
	$frm_str .= '<div style="text-align:center;">';
	$frm_str .= $visa->getList($res_id, $coll_id, $modifVisaWorkflow, 'VISA_CIRCUIT');
                
	$frm_str .= '</div><br>';
	/* Historique diffusion visa */
	$frm_str .= '<br/>'; 
		$frm_str .= '<br/>';                
		$frm_str .= '<span class="diff_list_visa_history" style="width: 90%; cursor: pointer;" onmouseover="this.style.cursor=\'pointer\';" onclick="new Effect.toggle(\'diff_list_visa_history_div\', \'blind\', {delay:0.2});whatIsTheDivStatus(\'diff_list_visa_history_div\', \'divStatus_diff_list_visa_history_div\');return false;">';
			$frm_str .= '<span id="divStatus_diff_list_visa_history_div" style="color:#1C99C5;"><<</span>';
			$frm_str .= '<b>&nbsp;<small>'._DIFF_LIST_VISA_HISTORY.'</small></b>';
		$frm_str .= '</span>';

		$frm_str .= '<div id="diff_list_visa_history_div" style="display:none">';

			$s_id = $res_id;
			$return_mode = true;
			$diffListType = 'VISA_CIRCUIT';
			require_once('modules/entities/difflist_visa_history_display.php');
						
	$frm_str .= '</div>';
	$frm_str .= '</dd>';
	

	$frm_str .= '</dl>';
	$frm_str .= '<div class="toolbar">';
	$frm_str .= '<table style="width:90%;">';	
	
	$frm_str .= '<tr>';
	$frm_str .= '<td>';	
		
		$frm_str .= '<b>'._ACTIONS.' : </b>';
		$actions  = $b->get_actions_from_current_basket($res_id, $coll_id, 'PAGE_USE');
		if(count($actions) > 0)
		{
			$frm_str .='<select name="chosen_action" id="chosen_action">';
				$frm_str .='<option value="">'._CHOOSE_ACTION.'</option>';
				for($ind_act = 0; $ind_act < count($actions);$ind_act++)
				{
					$frm_str .='<option value="'.$actions[$ind_act]['VALUE'].'"';
					if($ind_act==0)
					{
						$frm_str .= 'selected="selected"';
					}
					$frm_str .= '>'.$actions[$ind_act]['LABEL'].'</option>';
				}
			$frm_str .='</select> ';
			$table = $sec->retrieve_table_from_coll($coll_id);
			$frm_str .= '<input type="button" name="send" id="send_action" value="'._VALIDATE.'" class="button" onclick="valid_action_form( \'index_file\', \''.$path_manage_action.'\', \''. $id_action.'\', \''.$res_id.'\', \''.$table.'\', \''.$module.'\', \''.$coll_id.'\', \''.$mode.'\');"/> ';
		}
		
		
		$frm_str .= '<input type="hidden" name="cur_rep" id="cur_rep" value="'.$tab_path_rep_file[0]['res_id'].'" >';
		$frm_str .= '<input type="hidden" name="cur_idAffich" id="cur_idAffich" value="1" >';
		$frm_str .= '<input type="hidden" name="cur_resId" id="cur_resId" value="'.$res_id.'" >';
		$frm_str .= '<input type="hidden" name="list_docs" id="list_docs" value="'.$list_docs.'" >';
		
		$frm_str .= '<input type="hidden" name="values" id="values" value="'.$res_id.'" />';
		$frm_str .= '<input type="hidden" name="action_id" id="action_id" value="'.$id_action.'" />';
		$frm_str .= '<input type="hidden" name="mode" id="mode" value="'.$mode.'" />';
		$frm_str .= '<input type="hidden" name="table" id="table" value="'.$table.'" />';
		$frm_str .= '<input type="hidden" name="coll_id" id="coll_id" value="'.$coll_id.'" />';
		$frm_str .= '<input type="hidden" name="module" id="module" value="'.$module.'" />';
		$frm_str .= '<input type="hidden" name="category_id" id="category_id" value="'.$data['category_id']['value'].'" />';
		$frm_str .= '<input type="hidden" name="req" id="req" value="second_request" />';
	
	
		//$frm_str .= '<input type="hidden" name="next_resId" id="next_resId" value="'.$nextId.'" >';
		
		$frm_str .= '</td>';
		$frm_str .= '<td style="width:5%;display:none;">';	
		$frm_str .= ' <a href="javascript://" id="update_rep_link" onclick="';
		/*if ($tab_path_rep_file[0]['is_version'] == 0) $frm_str .= 'window.open(\''.$_SESSION['config']['businessappurl'] . 'index.php?display=true&module=attachments&page=update_attachments&mode=up&collId='.$coll_id.'&id='.$tab_path_rep_file[0]['res_id'].'\',\'\',\'height=301, width=301,scrollbars=yes,resizable=yes\');';
		else  $frm_str .= 'window.open(\''.$_SESSION['config']['businessappurl'] . 'index.php?display=true&module=attachments&page=update_attachments&mode=up&collId='.$coll_id.'&id='.$tab_path_rep_file[0]['res_id'].'isVersion\',\'\',\'height=301, width=301,scrollbars=yes,resizable=yes\');';*/
		if ($tab_path_rep_file[0]['is_version'] == 0) $frm_str .= 'modifyAttachmentsForm(\''.$_SESSION['config']['businessappurl'] . 'index.php?display=true&module=attachments&page=attachments_content&id='.$tab_path_rep_file[0]['res_id'].'&relation=1&fromDetail=\',\'98%\',\'auto\');';
		else  $frm_str .= 'modifyAttachmentsForm(\''.$_SESSION['config']['businessappurl'] . 'index.php?display=true&module=attachments&page=attachments_content&id='.$tab_path_rep_file[0]['res_id'].'&relation=2&fromDetail=\',\'98%\',\'auto\');';
		
		$frm_str .= '"><i class="fa fa-pencil-square-o fa-3x" title="Modifier la réponse"></i></a>';
		
		$frm_str .= '</td>';
		$frm_str .= '</tr>';	
	$frm_str .= '</table>';	
	
	$frm_str .= '</div>';	
	
	$frm_str .= '</div>';
	$frm_str .= '</form>';
	/*** Extra javascript ***/
	$frm_str .= '<script type="text/javascript">launchTabri();window.scrollTo(0,0);$(\'divList\').style.display = \'none\';';
	$frm_str .='</script>';
	return addslashes($frm_str);
}

/**
 * Checks the action form
 *
 * @param $form_id String Identifier of the form to check
 * @param $values Array Values of the form
 * @return Bool true if no error, false otherwise
 **/
function check_form($form_id,$values)
{
		//writeLogIndex("GO check_form !!");

    $_SESSION['action_error'] = '';
    if(count($values) < 1 || empty($form_id))
    {
        $_SESSION['action_error'] =  _FORM_ERROR;
        return false;
    }
    else
    {
       
        return true;
    }
}

/**
 * Get the value of a given field in the values returned by the form
 *
 * @param $values Array Values of the form to check
 * @param $field String the field
 * @return String the value, false if the field is not found
 **/
function get_value_fields($values, $field)
{
    for($i=0; $i<count($values);$i++)
    {
        if($values[$i]['ID'] == $field)
        {
            return  $values[$i]['VALUE'];
        }
    }
    return false;
}


/**
 * Action of the form : update the database
 *
 * @param $arr_id Array Contains the res_id of the document to validate
 * @param $history String Log the action in history table or not
 * @param $id_action String Action identifier
 * @param $label_action String Action label
 * @param $status String  Not used here
 * @param $coll_id String Collection identifier
 * @param $table String Table
 * @param $values_form String Values of the form to load
 **/
function manage_form($arr_id, $history, $id_action, $label_action, $status,  $coll_id, $table, $values_form )
{
	$res_id = $arr_id[0];
	
	
	require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
	$sec = new security();
	$table = $sec->retrieve_table_from_coll($coll_id);
	
	$dossier = getDossier($values_form);
	
	$dossier = getPaths($dossier, $res_id);
	concat_files($dossier,$res_id);
    return array(
		'result' => $res_id.'#',
		'history_msg' => '',
        'page_result' => $_SESSION['config']['businessappurl']
                         . 'index.php?page=view_parapheur_controller&module=visa'
                         . '&res_id=' . $res_id
	);
}