<?php

/*
*   Copyright 2008-2012 Maarch
*
*   This file is part of Maarch Framework.
*
*   Maarch Framework is free software: you can redistribute it and/or modify
*   it under the terms of the GNU General Public License as published by
*   the Free Software Foundation, either version 3 of the License, or
*   (at your option) any later version.
*
*   Maarch Framework is distributed in the hope that it will be useful,
*   but WITHOUT ANY WARRANTY; without even the implied warranty of
*   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
*   GNU General Public License for more details.
*
*   You should have received a copy of the GNU General Public License
*   along with Maarch Framework.  If not, see <http://www.gnu.org/licenses/>.
*/

/**
* @brief Action : Process a document
*
* Open a modal box to displays the process form, make the form checks and loads the result in database.
* Used by the core (manage_action.php page).
*
* @file
* @author Claire Figueras <dev@maarch.org>
* @author Laurent Giovannoni <dev@maarch.org>
* @date $date$
* @version $Revision$
* @ingroup apps
*/

/**
* $confirm  bool false
*/
$confirm = false;
/**
* $etapes  array Contains 2 etaps : form and status (order matters)
*/
$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/' . $_SESSION['config']['app_id']. '/definition_mail_categories.php');


/**
 * Gets the folder data for a given document
 *
 * @param $coll_id string Collection identifier
 * @param $res_id string Resource identifier
 * @return Array Folder data (folder + subfolder)
 **/
function get_folder_data($coll_id, $res_id)
{
    require_once('core/class/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();
    $folder = '';
    $db->query("select folders_system_id, folder_id, folder_name, fold_parent_id, fold_subject, folder_level from "
        . $view . " where res_id = " . $res_id);

    if ($db->nb_result() == 1) {
        $res = $db->fetch_object();
        if (!empty($res->folders_system_id)) {
        // $folder = $res->folder_name.', '.$res->fold_subject.' ('.$res->folders_system_id.')';
            $folder = $res->folder_id.', '.$res->folder_name.' ('.$res->folders_system_id.')';
        }
    }

    return $folder;
}


/**
 * Returns the indexing form text
 *
 * @param $values Array Contains the res_id of the document to process
 * @param $path_manage_action String Path to the PHP file called in Ajax
 * @param $id_action String Action identifier
 * @param $table String Table
 * @param $module String Origin of the action
 * @param $coll_id String Collection identifier
 * @param $mode String Action mode 'mass' or 'page'
 * @return String The form content text
 **/
function get_form_txt($values, $path_manage_action,  $id_action, $table, $module, $coll_id, $mode)
{
    //print_r($_SESSION['current_basket']);
    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';
    }
    $_SESSION['req'] = "action";
    $res_id = $values[0];
    $frm_str = '';
    require_once('core/class/class_security.php');
    require_once('modules/basket/class/class_modules_tools.php');
    require_once('core/class/class_request.php');
    require_once('apps/' . $_SESSION['config']['app_id'] . '/class/class_types.php');
    require_once('apps/' . $_SESSION['config']['app_id'] . '/class/class_indexing_searching_app.php');
    require_once('apps/' . $_SESSION['config']['app_id'] . '/class/class_chrono.php');
    $type = new types();
    $sec =new security();
    $core_tools =new core_tools();
    $doctypes = $type->getArrayTypes($coll_id);
    $b = new basket();
    $is = new indexing_searching_app();
    $cr = new chrono();
    $data = array();
    $params_data = array('show_folder' => false);
    $data = get_general_data($coll_id, $res_id, 'full', $params_data);
    $process_data = $is->get_process_data($coll_id, $res_id);
    $chrono_number = $cr->get_chrono_number($res_id, $sec->retrieve_view_from_table($table));
    $_SESSION['doc_id'] = $res_id;
    $indexes = array();
    if (isset($data['type_id'])) {
        $indexes = $type->get_indexes($data['type_id']['value'], $coll_id);
        $fields = 'res_id';
        foreach (array_keys($indexes) as $key) {
            $fields .= ','.$key;
        }
        $b->connect();
        $b->query("select ".$fields." from ".$table." where res_id = ".$res_id);
        $values_fields = $b->fetch_object();
        //print_r($indexes);
    }
    if ($core_tools->is_module_loaded('entities')) {
        require_once('modules/entities/class/class_manage_listdiff.php');
        $listdiff = new diffusion_list();
        $roles = $listdiff->list_difflist_roles();
        $_SESSION['process']['diff_list'] = $listdiff->get_listinstance($res_id, false, $coll_id);
        $_SESSION['process']['difflist_type'] = $listdiff->get_difflist_type($_SESSION['process']['diff_list']['object_type']);
    }
    //  to activate locking decomment these lines
    /*if ($b->reserve_doc($_SESSION['user']['UserId'], $res_id, $coll_id) == false) {
        $frm_str = '<div>';
        $frm_str .= '<h1 class="tit" id="action_title"><img src="'
        * . $_SESSION['config']['businessappurl']
        * . 'static.php?filename=file_index_b.gif"  align="middle" alt="" />'._DOC_NUM." ".$res_id ;
                    $frm_str .= '</h1>';
            $frm_str .= '<div>'._DOC_ALREADY_RSV.'</div>';
            $frm_str .= '<div><input type="button" name="close" id="close" value="'
            * . _CLOSE_WINDOW.'" class="button" onclick="javascript:destroyModal(\'modal_'.$id_action.'\');reinit();"/></div>';
            $frm_str .= '</div>';

    } else {
    */

    /********************************* LEFT PART **************************************/
    $frm_str = '<div id="validleftprocess">';
        $frm_str .= '<h2 id="action_title"><img src="'
            . $_SESSION['config']['businessappurl']
            . 'static.php?filename=file_index_b.gif"  align="middle" alt="" />'
            . _PROCESS . _LETTER_NUM . ' ' . $res_id;
                $frm_str .= '</h2>';
                $frm_str .= '<div id="frm_error_' . $id_action . '" class="error"></div>';
                $frm_str .= '<form name="process" method="post" id="process" action="#" '
                          . 'class="formsProcess addformsProcess" style="text-align:left;">';
                $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="req" id="req" value="second_request" />';
                
                $frm_str .= '<h3 onclick="new Effect.toggle(\'general_datas_div\', \'blind\', {delay:0.2});'
                    . 'whatIsTheDivStatus(\'general_datas_div\', \'divStatus_general_datas_div\');return false;" '
                    . 'onmouseover="this.style.cursor=\'pointer\';" class="categorie" style="width:90%;">';
                $frm_str .= ' <span id="divStatus_general_datas_div" style="color:#1C99C5;">>></span>&nbsp;<b>'
                        . _GENERAL_INFO . ' :</b>';
            $frm_str .= '<span class="lb1-details">&nbsp;</span>';
        $frm_str .= '</h3>';

        //GENERAL DATAS
        $frm_str .= '<div id="general_datas_div" style="display:block">';
            $frm_str .= '<div>';
              $frm_str .= '<table width="95%" align="left" border="0">';
              // Displays the document indexes
            foreach (array_keys($data) as $key) {
                $frm_str .= '<tr>';
                    $frm_str .= '<td width="50%" align="left"><span class="form_title_process">'
                        . $data[$key]['label'] . ' :</span></td>';
                    $frm_str .= '<td>';
                    if ($data[$key]['display'] == 'textinput') {
                        $frm_str .= '<input type="text" name="' . $key . '" id="' . $key
                            . '" value="' . $data[$key]['show_value']
                            . '" readonly="readonly" class="readonly" style="border:none;" />';
                    } elseif ($data[$key]['display'] == 'textarea') {
                        $frm_str .= '<textarea name="'.$key.'" id="'.$key.'" rows="3" readonly="readonly" class="readonly" '
                                    .'title="'.$data[$key]['show_value'].'" style="width: 150px; max-width: 150px; border: none; color: #666666;">'
                                        .$data[$key]['show_value']
                                    .'</textarea>';
                        if (isset($data[$key]['addon'])) {
                            $frm_str .= $data[$key]['addon'];
                        }
                    }
					
					if($key == 'type_id'){
						$_SESSION['category_id_session'] = $data[$key]['value'];
					}
					
                    $frm_str .= '</td>';
                $frm_str .= '</tr>';
            }
            if ($chrono_number <> '') {
                $frm_str .= '<tr>';
                $frm_str .= '<td width="50%" align="left"><span class="form_title_process">'
                    . _CHRONO_NUMBER . ' :</span></td>';
                $frm_str .= '<td>';
                $frm_str .= '<input type="text" name="alt_identifier" id="alt_identifier" value="'
                    . $chrono_number . '" readonly="readonly" class="readonly" style="border:none;" />';
                $frm_str .= '</td>';
                $frm_str .= '</tr>';
            }
            if (count($indexes) > 0) {
                foreach (array_keys($indexes) as $key) {
                    $frm_str .= '<tr>';
                        $frm_str .= '<td width="50%" align="left"><span class="form_title_process" >'
                                  . $indexes[$key]['label'] . ' :</span></td>';
                        $frm_str .= '<td>';
                        $frm_str .= '<input type="text" name="' . $key . '" id="'
                                  . $key . '" readonly="readonly" class="readonly" style="border:none;" ';
                        if ($indexes[$key]['type_field'] == 'input') {
                            $frm_str .= ' value="'.$values_fields->$key.'" ';
                        } else {
                            $val = '';
                            for ($i=0; count($indexes[$key]['values']); $i++) {
                                if ($values_fields->$key == $indexes[$key]['values'][$i]['id']) {
                                    $val =     $indexes[$key]['values'][$i]['label'];
                                    break;
                                }
                            }
                            $frm_str .= ' value="'.$val.'" ';
                        }
                        $frm_str .= ' />';
                        $frm_str .= '</td >';
                    $frm_str .= '</tr>';
                }
            }
            //extension
            $db = new dbquery();
            $db->connect();
            $db->query("select format from ".$table." where res_id = ".$res_id);
            $formatLine = $db->fetch_object();
            $frm_str .= '<tr>';
            $frm_str .= '<td width="50%" align="left"><span class="form_title_process">' . _FORMAT . ' :</span></td>';
            $frm_str .= '<td>';
            $frm_str .= '<input type="text" name="alt_identifier" id="alt_identifier" value="'
                . $formatLine->format . '" readonly="readonly" class="readonly" style="border:none;" />';
            $frm_str .= '</td >';
            $frm_str .= '</tr>';
        $frm_str .= '</table>';
        $frm_str .= '</div>';
    $frm_str .= '</div><br/>';

    //RESPONSE FORM
    $nb_attach = 0;

    $db = new request;
    $db->connect();
    $db->query("select answer_type_bitmask from ".$_SESSION['collections'][0]['extensions'][0]." where res_id = ".$res_id);
    $res = $db->fetch_object();
    $bitmask = $res->answer_type_bitmask;
    switch ($bitmask) {
        case "000000":
            $answer = '';
            break;
        case "000001":
            $answer = _SIMPLE_MAIL;
            break;
        case "000010":
            $answer = _REGISTERED_MAIL;
            break;
        case "000100":
            $answer = _DIRECT_CONTACT;
            break;
        case "001000":
            $answer = _EMAIL;
            break;
        case "010000":
            $answer = _FAX;
            break;
        case "100000":
            $answer = _ANSWER;
            break;
        default:
            $answer = _ANSWER;
    }

    if ($core_tools->is_module_loaded('attachments')) {
        $req = new request;
        $req->connect();
        $req->query("select res_id from "
            . $_SESSION['tablename']['attach_res_attachments']
            . " where status <> 'DEL' and res_id_master = " . $res_id . " and coll_id = '" . $coll_id . "'");
        if ($req->nb_result() > 0) {
            $nb_attach = $req->nb_result();
        }
    }

    if ($answer <> '') {
        $answer .= ': ';
    }

    $frm_str .= '<h3 onclick="new Effect.toggle(\'list_answers_div\', \'blind\', {delay:0.2});'
              . 'new Effect.toggle(\'done_answers_div\', \'blind\', {delay:0.2});'
              . 'whatIsTheDivStatus(\'done_answers_div\', \'divStatus_done_answers_div\');return false;" '
              . 'onmouseover="this.style.cursor=\'pointer\';" style="width:90%;">';
    $frm_str .= ' <span id="divStatus_done_answers_div" style="color:#1C99C5;"><<</span>';
    $frm_str .= '&nbsp;<b>' . _PJ . ', ' . _DONE_ANSWERS . ' (' . $answer .'<span id="nb_attach">'. $nb_attach . '</span>) :</b>';
    $frm_str .= '<span class="lb1-details">&nbsp;</span>';
    $frm_str .= '</h3>';
    $frm_str .= '<div class="desc" id="done_answers_div" style="display:none;width:90%;">';
        $frm_str .= '<div class="ref-unit" style="width:95%;">';
            $frm_str .= '<table width="95%">';
                $frm_str .= '<tr>';
                    $frm_str .= '<td>';
                    $frm_str .= '<input type="checkbox"  class="check" name="direct_contact" id="direct_contact" value="true"';
                    if ($process_data['direct_contact']) {
                        $frm_str .= 'checked="checked"';
                    }
                    $frm_str .= ' onclick="unmark_empty_process(\'no_answer\');" />'._DIRECT_CONTACT.'<br/>';
                    $frm_str .= '<input type="checkbox"  class="check" name="fax" id="fax" value="true"';
                    if ($process_data['fax']) {
                        $frm_str .= 'checked="checked"';
                    }
                    $frm_str .=' onclick="unmark_empty_process(\'no_answer\');" />'._FAX.'<br/>';
                    $frm_str .= '<input type="checkbox"  class="check" name="email" id="email"  value="true"';
                    if ($process_data['email']) {
                        $frm_str .= 'checked="checked"';
                    }
                    $frm_str .='onclick="unmark_empty_process(\'no_answer\');" />'._EMAIL.'<br/>';
                    $frm_str .= '<input type="checkbox"  class="check" name="simple_mail" id="simple_mail"  value="true" ';
                    if ($process_data['simple_mail']) {
                        $frm_str .= 'checked="checked"';
                    }
                    $frm_str .= 'onclick="unmark_empty_process(\'no_answer\');" />'._SIMPLE_MAIL.'<br/>';
                    $frm_str .= '<input type="checkbox"  class="check" name="registered_mail" id="registered_mail" value="true" ';
                    if ($process_data['registered_mail']) {
                        $frm_str .= 'checked="checked"';
                    }
                    $frm_str .='onclick="unmark_empty_process(\'no_answer\');" />'._REGISTERED_MAIL.'<br/>';
                    $frm_str .= '<input type="checkbox"  class="check" name="no_answer" id="no_answer" value="true"';
                    if ($process_data['no_answer']) {
                        $frm_str .= 'checked="checked"';
                    }
                    $frm_str .='/>'._NO_ANSWER.'<br />';
                    $frm_str .= '<input type="checkbox"  class="check" name="other" id="other" value="true"';
                    if ($process_data['other']) {
                        $frm_str .= 'checked="checked"';
                    }
                    $frm_str .='onclick="unmark_empty_process(\'no_answer\');" />'
                        . _OTHER . ' : <input type="text" name="other_answer" id="other_answer" value="';
                    if (!empty($process_data['other_answer_desc'])) {
                        $frm_str .= $process_data['other_answer_desc'];
                    } else {
                        $frm_str .='['._DEFINE.']';
                    }
                    $frm_str .='"';
                    if (empty($process_data['other_answer_desc']))
                    {
                        $frm_str .= ' onfocus="if (this.value==\'['._DEFINE.']\'){this.value=\'\';}" ';
                    }
                    $frm_str .=' /><br/>';
                    $frm_str .= '</td>';
                    $frm_str .= '<td>&nbsp;</td>';

                    $frm_str .= '</tr>';
                    $frm_str .= '<tr>';
                    /*$frm_str .= '<td><label for="process_notes">'
                        . _PROCESS_NOTES
                        . ' : </label><br/><textarea name="process_notes" id="process_notes" style="display:block;" rows="8" cols="30">'
                        . $process_data['process_notes'].'</textarea></td>';*/
                $frm_str .= '</tr>';
            $frm_str .= '</table>';
        $frm_str .= '</div>';
    $frm_str .= '</div>';
    $frm_str .= '<br>';

    //TAGS
    if (
        $core_tools->is_module_loaded('tags') && (
        $core_tools->test_service('tag_view', 'tags',false) == 1)
        )
    {
        include_once("modules".DIRECTORY_SEPARATOR."tags".
        DIRECTORY_SEPARATOR."templates/process/index.php");
    }

    //CASES
    if ($core_tools->is_module_loaded('cases')) {
        require_once('modules/cases/class/class_modules_tools.php');
        $cases = new cases();
        $case_id = $cases->get_case_id($res_id);
        if ($case_id <> false) {
            $case_properties = $cases->get_case_info($case_id);
        } else {
            $case_properties = array();
        }
        $frm_str .= '<h3 onclick="new Effect.toggle(\'cases_div\', \'blind\', {delay:0.2});'
            . 'whatIsTheDivStatus(\'cases_div\', \'divStatus_cases_div\');return false;" '
            . 'onmouseover="this.style.cursor=\'pointer\';" class="categorie" style="width:90%;">';
        $frm_str .= ' <span id="divStatus_cases_div" style="color:#1C99C5;"><<</span>&nbsp;<b>' . _CASE . ' :</b>';
        $frm_str .= '<span class="lb1-details">&nbsp;</span>';
        $frm_str .= '</h3>';
        $frm_str .= '<br>';
    }

    //FOLDERS
    if ($core_tools->is_module_loaded('folder')) {
         // Displays the folder data
        $folder = get_folder_data($coll_id, $res_id);

        $frm_str .= '<h3 onclick="new Effect.toggle(\'folder_div\', \'blind\', {delay:0.2});'
            . 'whatIsTheDivStatus(\'folder_div\', \'divStatus_folder_div\');return false;" '
            . 'onmouseover="this.style.cursor=\'pointer\';" class="categorie" style="width:90%;">';
        $frm_str .= ' <span id="divStatus_folder_div" style="color:#1C99C5;"><<</span>&nbsp;<b>' . _FOLDER_ATTACH . ' :</b>';
            $frm_str .= '<span class="lb1-details">&nbsp;</span>';
        $frm_str .= '</h3>';
        $frm_str .= '<div id="folder_div"  style="display:none">';
            $frm_str .= '<div>';
                $frm_str .= '<table width="98%" align="center" border="0">';
                        $frm_str .= '<tr id="folder_tr" style="display:'.$display_value.';">';
                    $frm_str .= '<td><label for="folder" class="form_title_process" >' . _FOLDER_OR_SUBFOLDER . '</label></td>';
                    $frm_str .= '<td>&nbsp;</td>';
                     $frm_str .='<td><input type="text" name="folder" id="folder" value="'
                        . $folder . '" onblur=""/><div id="show_folder" class="autocomplete"></div>';
                $frm_str .= '</tr>';
                $frm_str .= '</table>';
            $frm_str .= '</div>';
        $frm_str .= '</div>';
        $frm_str .='<input type="hidden" name="res_id_to_process" id="res_id_to_process"  value="' . $res_id . '" />';
        $frm_str .= '<br>';
    }

    //ACTIONS
    $frm_str .= '<hr class="hr_process"/>';
    $frm_str .= '<p align="center" style="width:90%;">';
        $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><br>';
            $frm_str .= '<input type="button" name="send" id="send" value="'
                . _VALIDATE
                . '" class="button" onclick="valid_action_form(\'process\', \''
                . $path_manage_action . '\', \'' . $id_action.'\', \''
                . $res_id . '\', \'' . $table . '\', \'' . $module . '\', \''
                . $coll_id . '\', \'' . $mode . '\');"/> ';
        }
        $frm_str .= '<input name="close" id="close" type="button" value="'
            . _CANCEL . '" class="button" onclick="javascript:var tmp_bask=$(\'baskets\');';
        $frm_str .= 'if (tmp_bask){tmp_bask.style.visibility=\'visible\';}var tmp_ent =$(\'entity\');';
        $frm_str .= 'if (tmp_ent){tmp_ent.style.visibility=\'visible\';} var tmp_cat =$(\'category\');';
        $frm_str .= 'if (tmp_cat){tmp_cat.style.visibility=\'visible\';}destroyModal(\'modal_'
            . $id_action . '\');reinit();"/>';
    $frm_str .= '</p>';
    $frm_str .= '</form>';
    $frm_str .= '</div>';
    $frm_str .= '</div>';

    // ****************************** RIGHT PART *******************************************/

    $frm_str .= '<div id="validright">';
    
    /*** TOOLBAR ***/
    $frm_str .= '<div class="block" align="center" style="height:20px;width=100%;">';
    
    $frm_str .= '<table width="95%" cellpadding="0" cellspacing="0">';
    $frm_str .= '<tr align="center">';
    
    //HISTORY
    $frm_str .= '<td>';
    $frm_str .= '|<span onclick="new Effect.toggle(\'history_div\', \'appear\', {delay:0.2});'
        . 'whatIsTheDivStatus(\'history_div\', \'divStatus_history_div\');return false;" '
        . 'onmouseover="this.style.cursor=\'pointer\';" class="categorie" style="width:90%;">';
    $frm_str .= '<span id="divStatus_history_div" style="color:#1C99C5;"><<</span><b>'
        . '<small>' . _DOC_HISTORY . '</small>';
    $frm_str .= '</b></span>|';
    $frm_str .= '</td>';
    
    //NOTE
    if ($core_tools->is_module_loaded('notes')) {
        $frm_str .= '<td>';
        require_once 'modules/notes/class/class_modules_tools.php';
        $notes_tools    = new notes();
        //Count notes
        $nbr_notes = $notes_tools->countUserNotes($res_id, $coll_id);
        $nbr_notes = ' ('.$nbr_notes.')';
        $frm_str .= '|<span onclick="new Effect.toggle(\'notes_div\', \'appear\', {delay:0.2});'
            . 'whatIsTheDivStatus(\'notes_div\', \'divStatus_notes_div\');return false;" '
            . 'onmouseover="this.style.cursor=\'pointer\';" class="categorie" style="width:90%;">';
        $frm_str .= '<span id="divStatus_notes_div" style="color:#1C99C5;"><<</span><b>'
            . '<small>' . _NOTES . $nbr_notes . '</small>';
        $frm_str .= '</b></span>|';
        $frm_str .= '</td>';
    }
    
    //SENDMAILS                
    if ($core_tools->is_module_loaded('sendmail') === true 
        && $core_tools->test_service('sendmail', 'sendmail', false) === true
    ) {
        require_once "modules" . DIRECTORY_SEPARATOR . "sendmail" . DIRECTORY_SEPARATOR
            . "class" . DIRECTORY_SEPARATOR
            . "class_modules_tools.php";
        $sendmail_tools    = new sendmail();
        //Count mails
        $nbr_emails = 0;
        $nbr_emails = $sendmail_tools->countUserEmails($res_id, $coll_id);
        $frm_str .= '<td>';
        $frm_str .= '|<span onclick="new Effect.toggle(\'emails_div\', \'appear\', {delay:0.2});'
            . 'whatIsTheDivStatus(\'emails_div\', \'divStatus_emails_div\');return false;" '
            . 'onmouseover="this.style.cursor=\'pointer\';" class="categorie" style="width:90%;">';
        $frm_str .= ' <span id="divStatus_emails_div" style="color:#1C99C5;"><<</span><b>&nbsp;'
            . '<small>' ._SENDED_EMAILS . ' ('.$nbr_emails.')</small>';
        $frm_str .= '</b></span>&nbsp;|';
        $frm_str .= '</td>';
    }
    
    //DIFFUSION LIST
    if ($core_tools->is_module_loaded('entities')) {        
        $frm_str .= '<td>';
        $frm_str .= '|<span onclick="new Effect.toggle(\'diff_list_div\', \'appear\', {delay:0.2});'
            . 'whatIsTheDivStatus(\'diff_list_div\', \'divStatus_diff_list_div\');return false;" '
            . 'onmouseover="this.style.cursor=\'pointer\';" class="categorie" style="width:90%;">';
        $frm_str .= '<span id="divStatus_diff_list_div" style="color:#1C99C5;"><<</span><b>'
            . '<small>' . _DIFF_LIST_COPY . '</small>';
        $frm_str .= '</b></span>|';
        $frm_str .= '</td>';
    }
    
     //test service add new version
    $viewVersions = false;
    if ($core->test_service('add_new_version', 'apps', false)) {
        $viewVersions = true;
    }
    //VERSIONS
    if ($core->is_module_loaded('content_management') && $viewVersions) {
        $versionTable = $sec->retrieve_version_table_from_coll_id(
            $coll_id
        );
        $selectVersions = "select res_id from "
            . $versionTable . " where res_id_master = "
            . $res_id . " and status <> 'DEL' order by res_id desc";
        $dbVersions = new dbquery();
        $dbVersions->connect();
        $dbVersions->query($selectVersions);
        $nb_versions_for_title = $dbVersions->nb_result();
        $lineLastVersion = $dbVersions->fetch_object();
        $lastVersion = $lineLastVersion->res_id;
        if ($lastVersion <> '') {
            $objectId = $lastVersion;
            $objectTable = $versionTable;
        } else {
            $objectTable = $sec->retrieve_table_from_coll(
                $coll_id
            );
            $objectId = $res_id;
            $_SESSION['cm']['objectId4List'] = $res_id;
        }
        if ($nb_versions_for_title == 0) {
            $extend_title_for_versions = '0';
        } else {
            $extend_title_for_versions = $nb_versions_for_title;
        }
        $_SESSION['cm']['resMaster'] = '';
        $frm_str .= '<td>';
        $frm_str .= '|<span onclick="new Effect.toggle(\'versions_div\', \'appear\', {delay:0.2});'
            . 'whatIsTheDivStatus(\'versions_div\', \'divStatus_versions_div\');return false;" '
            . 'onmouseover="this.style.cursor=\'pointer\';" class="categorie" style="width:90%;">';
        $frm_str .= '<span id="divStatus_versions_div" style="color:#1C99C5;"><<</span><b>'
            . '<small>' . _VERSIONS . ' (<span id="nbVersions">' . $extend_title_for_versions . '</span>)</small>';
        $frm_str .= '</b></span>|';
        $frm_str .= '</td>';
    }
    
    //LINKS
    $frm_str .= '<td>';
    require_once('core/class/LinkController.php');
    $Class_LinkController = new LinkController();
    $nbLink = $Class_LinkController->nbDirectLink(
        $res_id,
        $coll_id,
        'all'
    );
    $frm_str .= '|<span onclick="new Effect.toggle(\'links_div\', \'appear\', {delay:0.2});'
        . 'whatIsTheDivStatus(\'links_div\', \'divStatus_links_div\');return false;" '
        . 'onmouseover="this.style.cursor=\'pointer\';" class="categorie" style="width:90%;">';
    $frm_str .= '<span id="divStatus_links_div" style="color:#1C99C5;"><<</span><b>'
         . '<small>' . _LINK_TAB . ' (<span id="nbLinks">' . $nbLink . '</span>)</small>';
    $frm_str .= '</b></span>|';
    $frm_str .= '</td>';
    
    //END TOOLBAR
    $frm_str .= '</table>';
    $frm_str .= '</div>';
    
    //ATTACHMENTS FRAME
    if ($core_tools->is_module_loaded('attachments')) {
        require 'modules/templates/class/templates_controler.php';
        $templatesControler = new templates_controler();
        $templates = array();
        $templates = $templatesControler->getAllTemplatesForProcess($data['destination']['value']);
        $frm_str .= '<div id="list_answers_div" style="display:none" onmouseover="this.style.cursor=\'pointer\';">';
            $frm_str .= '<div>';
                $frm_str .= '<div id="processframe" name="processframe">';
                    $frm_str .= '<center><h2 onclick="new Effect.toggle(\'list_answers_div\', \'blind\', {delay:0.2});';
                    $frm_str .= 'new Effect.toggle(\'done_answers_div\', \'blind\', {delay:0.2});';
                    $frm_str .= 'whatIsTheDivStatus(\'done_answers_div\', \'divStatus_done_answers_div\');';
                    $frm_str .= 'return false;">' . _ATTACHMENTS . ', ' . _DONE_ANSWERS . '</h2></center>';
                    $req = new request;
                    $req->connect();
                    $req->query("select res_id from ".$_SESSION['tablename']['attach_res_attachments']
                        . " where status = 'NEW' 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')) {
                        $objectTable = $sec->retrieve_table_from_coll($coll_id);
                        $frm_str .= _GENERATE_ATTACHMENT_FROM . ' <br><select name="templateOffice" id="templateOffice" style="width:250px" onchange="';
                        //$frm_str .= 'loadApplet(\''
                        $frm_str .= 'window.open(\''
                            . $_SESSION['config']['businessappurl'] . 'index.php?display=true'
                            . '&module=content_management&page=applet_popup_launcher&objectType=attachmentFromTemplate'
                            . '&objectId='
                            . '\' + $(\'templateOffice\').value + \''
                            . '&objectTable='
                            . $objectTable
                            . '&resMaster='
                            . $res_id
                            //. '\', $(\'templateOffice\').value);">';
                            . '\', \'\', \'height=301, width=301,scrollbars=no,resizable=no,directories=no,toolbar=no\');">';
                            $frm_str .= '<option value="">' . _OFFICE . '</option>';
                                for ($i=0;$i<count($templates);$i++) {
                                    if ($templates[$i]['TYPE'] == 'OFFICE') {
                                        $frm_str .= '<option value="';
                                            $frm_str .= $templates[$i]['ID'];
                                            $frm_str .= '">';
                                            //$frm_str .= $templates[$i]['TYPE'] . ' : ';
                                            $frm_str .= $templates[$i]['LABEL'];
                                        }
                                    $frm_str .= '</option>';
                                }
                        $frm_str .= '</select>&nbsp;|&nbsp;';
                        $frm_str .= '<select name="templateHtml" id="templateHtml" style="width:250px" '
                            //. 'onchange="window.alert(\'\' + $(\'templateHtml\').value + \'\');">';
                            . 'onchange="checkBeforeOpenBlank(\''
                            . $_SESSION['config']['businessappurl']
                            . 'index.php?display=true&module=templates&page=generate_attachment_html&mode=add&template='
                            . '\' + $(\'templateHtml\').value + \''
                            . '&res_id=' . $res_id
                            . '&coll_id=' . $_REQUEST['coll_id']
                            . '\', $(\'templateHtml\').value);">';
                            $frm_str .= '<option value="">' . _HTML . '</option>';
                                for ($i=0;$i<count($templates);$i++) {
                                    if ($templates[$i]['TYPE'] == 'HTML') {
                                        $frm_str .= '<option value="';
                                            $frm_str .= $templates[$i]['ID'];
                                            $frm_str .= '">';
                                            //$frm_str .= $templates[$i]['TYPE'] . ' : ';
                                            $frm_str .= $templates[$i]['LABEL'];
                                        }
                                    $frm_str .= '</option>';
                                }
                        $frm_str .= '</select><br>' . _OR . '&nbsp;';
                        $frm_str .= '<input type="button" name="attach" id="attach" class="button" value="'
                            . _ATTACH_FROM_HDD
                            . '" onclick="javascript:window.open(\'' . $_SESSION['config']['businessappurl']
                            . 'index.php?display=true&module=attachments&page=join_file\',\'\', \'scrollbars=yes,'
                            . 'menubar=no,toolbar=no,resizable=yes,status=no,width=550,height=200\');" />';
                    }
                    $frm_str .= '</center><iframe name="list_attach" id="list_attach" src="'
                    . $_SESSION['config']['businessappurl']
                    . 'index.php?display=true&module=attachments&page=frame_list_attachments" '
                    . 'frameborder="0" width="100%" height="450px"></iframe>';
                    $frm_str .= '</div>';
                $frm_str .= '</div>';
                //$frm_str .= '<hr class="hr_process"/>';
            $frm_str .= '</div>';
            $frm_str .= '<hr />';
        $frm_str .= '</div>';
    }

    //DIFFUSION FRAME
    if ($core_tools->is_module_loaded('entities')) {
        $frm_str .= '<div id="diff_list_div" style="display:none" onmouseover="this.style.cursor=\'pointer\';">';
            $frm_str .= '<div>';
                $frm_str .= '<center><h2 onclick="new Effect.toggle(\'diff_list_div\', \'blind\', {delay:0.2});';
                $frm_str .= 'whatIsTheDivStatus(\'diff_list_div\', \'divStatus_diff_list_div\');';
                $frm_str .= 'return false;">' . _DIFF_LIST_COPY . '</h2></center>';
                if ($core_tools->test_service('add_copy_in_process', 'entities', false)) {
                    $frm_str .= '<a href="#" onclick="window.open(\''
                        . $_SESSION['config']['businessappurl']
                        . 'index.php?display=true&module=entities&page=manage_listinstance'
                        . '&origin=process&only_cc\', \'\', \'scrollbars=yes,menubar=no,'
                        . 'toolbar=no,status=no,resizable=yes,width=1024,height=650,location=no\');" title="'
                        . _UPDATE_LIST_DIFF
                        . '"><img src="'
                        . $_SESSION['config']['businessappurl']
                        . 'static.php?filename=modif_liste.png" alt="'
                        . _UPDATE_LIST_DIFF
                        . '" />'
                        . _UPDATE_LIST_DIFF
                        . '</a><br/>';
                }
                # Get content from buffer of difflist_display 
                $difflist = $_SESSION['process']['diff_list'];
                
                ob_start();
                require_once 'modules/entities/difflist_display.php';
                $frm_str .= str_replace(array("\r", "\n", "\t"), array("", "", ""), ob_get_contents());
                ob_end_clean();
                
                //$frm_str .= '<hr class="hr_process"/>';
            $frm_str .= '</div>';
            $frm_str .= '<hr />';
        $frm_str .= '</div>';
    }

    //HISTORY FRAME
    $frm_str .= '<div class="desc" id="history_div" style="display:none">';
    $frm_str .= '<div class="ref-unit">';
    $frm_str .= '<center><h2 onclick="new Effect.toggle(\'history_div\', \'blind\', {delay:0.2});';
    $frm_str .= 'whatIsTheDivStatus(\'history_div\', \'divStatus_history_div\');';
    $frm_str .= 'return false;" onmouseover="this.style.cursor=\'pointer\';">' . _HISTORY. '</h2></center>';
    $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=medium" '
        . 'name="hist_doc_process" id="hist_doc_process" width="100%" height="650px" align="center" '
        . 'scrolling="auto" frameborder="0" style="height: 650px; max-height: 650px; overflow: scroll;"></iframe>';
    //$frm_str .= '<hr class="hr_process"/>';
    $frm_str .= '</div>';
    $frm_str .= '<hr />';
    $frm_str .= '</div>';

    //NOTES FRAME
    if ($core_tools->is_module_loaded('notes')) {
        $frm_str .= '<div class="desc" id="notes_div" style="display:none;">';
        $frm_str .= '<div class="ref-unit">';
        $frm_str .= '<center><h2 onclick="new Effect.toggle(\'notes_div\', \'blind\', {delay:0.2});';
        $frm_str .= 'whatIsTheDivStatus(\'notes_div\', \'divStatus_notes_div\');';
        $frm_str .= 'return false;" onmouseover="this.style.cursor=\'pointer\';">' . _NOTES. '</h2></center>';
        $frm_str .= '<iframe src="'
            . $_SESSION['config']['businessappurl']
            . 'index.php?display=true&module=notes&page=notes&identifier='
            . $res_id . '&origin=document&coll_id=' . $coll_id . '&load&size=medium" '
            . 'name="list_notes_doc" id="list_notes_doc" width="100%" height="650px" align="center" '
            . 'scrolling="auto" frameborder="0" ></iframe>';
        //$frm_str .= '<hr class="hr_process"/>';
        $frm_str .= '</div>';
        $frm_str .= '<hr />';
        $frm_str .= '</div>';
    }
    
    //SENDMAIL FRAME
    if ($core_tools->test_service('sendmail', 'sendmail', false) === true) {
        $frm_str .= '<div class="desc" id="emails_div" style="display:none;">';
        $frm_str .= '<div class="ref-unit">';
        $frm_str .= '<center><h2 onclick="new Effect.toggle(\'emails_div\', \'blind\', {delay:0.2});';
        $frm_str .= 'whatIsTheDivStatus(\'emails_div\', \'divStatus_emails_div\');';
        $frm_str .= 'return false;" onmouseover="this.style.cursor=\'pointer\';">' . _SENDED_EMAILS. '</h2></center>';
        $frm_str .= '<iframe src="'
            . $_SESSION['config']['businessappurl']
            . 'index.php?display=true&module=sendmail&page=sendmail&identifier='
            . $res_id . '&origin=document&coll_id=' . $coll_id . '&load&size=medium" '
            . 'name="sendmail_iframe" id="sendmail_iframe" width="100%" height="650px" align="center" '
            . 'scrolling="auto" frameborder="0" ></iframe>';
        $frm_str .= '</div>';
        $frm_str .= '</div>';
    }

    //CASES FRAME
    if ($core_tools->is_module_loaded('cases')) {
        if (!isset($case_properties['case_id'])) {
            $case_properties = array();
            $case_properties['case_id'] = '';
            $case_properties['case_label'] = '';
            $case_properties['case_description'] = '';
        }
        $frm_str .= '<div id="cases_div" style="display:none" onmouseover="this.style.cursor=\'pointer\';">';
            $frm_str .= '<div>';
                $frm_str .= '<center><h2 onclick="new Effect.toggle(\'cases_div\', \'blind\', {delay:0.2});';
                $frm_str .= 'whatIsTheDivStatus(\'cases_div\', \'divStatus_cases_div\');';
                $frm_str .= 'return false;">' . _CASE . '</h2></center>';
                $frm_str .= '<form name="cases" method="post" id="cases" action="#" class="forms addforms2" style="text-align:center;">';
                    $frm_str .= '<table width="98%" align="center" border="0">';
                        $frm_str .= '<tr>';
                            $frm_str .= '<td><label for="case_id" class="case_label" >' . _CASE . '</label></td>';
                                $frm_str .= '<td>&nbsp;</td>';
                                $frm_str .= '<td><input type="text" readonly="readonly" class="readonly" name="case_id" id="case_id" value="'
                                    . $case_properties['case_id'] . '"  onblur=""/>';
                                $frm_str .= '</td>';
                                $frm_str .= '</tr>';
                                $frm_str .= '<tr>';
                                $frm_str .= '<td><label for="case_label" class="case_label" >' . _CASE_LABEL . '</label></td>';
                                $frm_str .= '<td>&nbsp;</td>';
                                $frm_str .= '<td><input type="text" readonly="readonly" class="readonly" name="case_label" '
                                    . 'id="case_label" onblur="" value="'.$case_properties['case_label'].'" />';
                                $frm_str .= '</td>';
                                $frm_str .= '</tr>';
                                $frm_str .= '<tr>';
                                $frm_str .= '<td><label for="case_description" class="case_description" >'
                                    . _CASE_DESCRIPTION . '</label></td>';
                                $frm_str .= '<td>&nbsp;</td>';
                                $frm_str .= '<td><input type="text" readonly="readonly" class="readonly" '
                                    . 'name="case_description" id="case_description" onblur="" value="'
                                    . $case_properties['case_description'].'" />';
                                $frm_str .= '</td>';
                                $frm_str .= '</tr>';
                                $frm_str .= '<tr>';
                                if ($core_tools->test_service('join_res_case_in_process', 'cases',false) == 1) {
                                    $frm_str .= '<td colspan="3"> <input type="button" class="button" name="search_case" '
                                        . 'id="search_case" value="';
                                    if ($case_properties['case_id']<>'') {
                                        $frm_str .= _MODIFY_CASE;
                                    } else {
                                        $frm_str .= _JOIN_CASE;
                                    }
                                    $frm_str .= '" onclick="window.open(\'' . $_SESSION['config']['businessappurl']
                                        . 'index.php?display=true&module=cases&page=search_adv_for_cases'
                                        . '&searched_item=res_id_in_process&searched_value=' . $_SESSION['doc_id']
                                        . '\',\'\', \'scrollbars=yes,menubar=no,toolbar=no,resizable=yes,'
                                        . 'status=no,width=1020,height=710\');"/></td>';
                                }
                            $frm_str .= '</tr>';
                    $frm_str .= '</table>';
                $frm_str .= '</form>';
                $frm_str .= '<br>';
                //$frm_str .= '<hr class="hr_process"/>';
            $frm_str .= '</div>';
            $frm_str .= '<hr />';
        $frm_str .= '</div>';
    }

    //LINKS FRAME
    $frm_str .= '<div id="links_div" style="display:none" onmouseover="this.style.cursor=\'pointer\';">';
        $frm_str .= '<div style="text-align: left;">';
            $frm_str .= '<h2 onclick="new Effect.toggle(\'links_div\', \'blind\', {delay:0.2});';
            $frm_str .= 'whatIsTheDivStatus(\'links_div\', \'divStatus_links_div\');';
                $frm_str .= 'return false;">';
                $frm_str .= '<center>' . _LINK_TAB . '</center>';
            $frm_str .= '</h2>';
            $frm_str .= '<div id="loadLinks">';
                $nbLinkDesc = $Class_LinkController->nbDirectLink(
                    $_SESSION['doc_id'],
                    $_SESSION['collection_id_choice'],
                    'desc'
                );
                if ($nbLinkDesc > 0) {
                    $frm_str .= '<img src="static.php?filename=cat_doc_incoming.gif"/>';
                    $frm_str .= $Class_LinkController->formatMap(
                        $Class_LinkController->getMap(
                            $_SESSION['doc_id'],
                            $_SESSION['collection_id_choice'],
                            'desc'
                        ),
                        'desc'
                    );
                    $frm_str .= '<br />';
                }
                $nbLinkAsc = $Class_LinkController->nbDirectLink(
                    $_SESSION['doc_id'],
                    $_SESSION['collection_id_choice'],
                    'asc'
                );
                if ($nbLinkAsc > 0) {
                    $frm_str .= '<img src="static.php?filename=cat_doc_outgoing.gif" />';
                    $frm_str .= $Class_LinkController->formatMap(
                        $Class_LinkController->getMap(
                            $_SESSION['doc_id'],
                            $_SESSION['collection_id_choice'],
                            'asc'
                        ),
                        'asc'
                    );
                    $frm_str .= '<br />';
                }
            $frm_str .= '</div>';
            if ($core_tools->test_service('add_links', 'apps', false)) {
                include 'apps/'.$_SESSION['config']['app_id'].'/add_links.php';
                $frm_str .= $Links;
            }
        $frm_str .= '</div>';
        $frm_str .= '<hr />';
    $frm_str .= '</div>';

    //VERSIONS FRAME
    //test service add new version
    $addNewVersion = false;
    if ($core->test_service('add_new_version', 'apps', false)) {
        $addNewVersion = true;
    }
    $frm_str .= '<div id="versions_div" style="display:none" onmouseover="this.style.cursor=\'pointer\';">';
        $frm_str .= '<div>';
                //$frm_str .= '<center><h2>' . _VERSIONS . '</h2></center>';
                $frm_str .= '<h2 onclick="new Effect.toggle(\'versions_div\', \'blind\', {delay:0.2});';
                $frm_str .= 'whatIsTheDivStatus(\'versions_div\', \'divStatus_versions_div\');';
                    $frm_str .= 'return false;">';
                    $frm_str .= '<center>' . _VERSIONS . '</center>';
                $frm_str .= '</h2>';
                $frm_str .= '<div class="error" id="divError" name="divError"></div>';
                $frm_str .= '<div style="text-align:center;">';
                    $frm_str .= '<a href="';
                        $frm_str .=  $_SESSION['config']['businessappurl'];
                        $frm_str .= 'index.php?display=true&dir=indexing_searching&page=view_resource_controler&original&id=';
                        $frm_str .= $res_id;
                        $frm_str .= '" target="_blank">';
                        $frm_str .= '<img alt="' . _VIEW_ORIGINAL . '" src="';
                        $frm_str .= $_SESSION['config']['businessappurl'];
                        $frm_str .= 'static.php?filename=picto_dld.gif" border="0" alt="" />';
                        $frm_str .= _VIEW_ORIGINAL . ' | ';
                    $frm_str .= '</a>';
                    if ($addNewVersion) {
                        $_SESSION['cm']['objectTable'] = $objectTable;
                        $frm_str .= '<div id="createVersion" style="display: inline;"></div>';
                    }
                    $frm_str .= '<div id="loadVersions"></div>';
                    $frm_str .= '<script language="javascript">';
                        $frm_str .= 'showDiv("loadVersions", "nbVersions", "createVersion", "';
                            $frm_str .= $_SESSION['urltomodules'];
                            $frm_str .= 'content_management/list_versions.php")';
                    $frm_str .= '</script>';
                $frm_str .= '</div><br>';
        $frm_str .= '</div>';
        $frm_str .= '<hr />';
    $frm_str .= '</div>';

    //RESOURCE FRAME
    $frm_str .= '<iframe src="' . $_SESSION['config']['businessappurl']
        . 'index.php?display=true&dir=indexing_searching&page=view_resource_controler&id='
        . $res_id . '" name="viewframe" id="viewframe" scrolling="auto" frameborder="0" width="100%"></iframe>';

    $frm_str .= '</div>';

    //SCRIPT
    $frm_str .= '<script type="text/javascript">resize_frame_process("modal_'
        . $id_action . '", "viewframe", true, true);window.scrollTo(0,0);';
        if ($core_tools->is_module_loaded('folder')) {
            $frm_str .= ' initList(\'folder\', \'show_folder\',\''
                . $_SESSION['config']['businessappurl'] . 'index.php?display='
                . 'true&module=folder&page=autocomplete_folders&mode=folder\','
                . ' \'Input\', \'2\');';
        }
        $frm_str .= '$(\'entity\').style.visibility=\'hidden\';';
        $frm_str .= '$(\'category\').style.visibility=\'hidden\';';
        $frm_str .= '$(\'baskets\').style.visibility=\'hidden\';';
    $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)
{
    $check = false;
    $other_checked = false;
    $other_txt = '';
    $folder = '';
    $core = new core_tools();
    //print_r($values);
    for ($i=0; $i<count($values); $i++) {
        if ($values[$i]['ID'] == "direct_contact" && $values[$i]['VALUE'] == "true") {
            $check = true;
        }
        if ($values[$i]['ID'] == "fax" && $values[$i]['VALUE'] == "true") {
            $check = true;
        }
        if ($values[$i]['ID'] == "email" && $values[$i]['VALUE'] == "true") {
            $check = true;
        }
        if ($values[$i]['ID'] == "simple_mail" && $values[$i]['VALUE'] == "true") {
            $check = true;
        }
        if ($values[$i]['ID'] == "registered_mail" && $values[$i]['VALUE'] == "true") {
            $check = true;
        }
        if ($values[$i]['ID'] == "no_answer" && $values[$i]['VALUE'] == "true") {
            $check = true;
        }
        if ($values[$i]['ID'] == "other" && $values[$i]['VALUE'] == "true")
        {
            $check = true;
            $other_checked = true;
        }
        if ($values[$i]['ID'] == "other_answer"  && trim($values[$i]['VALUE']) <> html_entity_decode('['._DEFINE.']', ENT_NOQUOTES, 'UTF-8')) {
            $other_txt = $values[$i]['VALUE'];
        }
        if ($values[$i]['ID'] == "folder") {
            $folder = $values[$i]['VALUE'];
        }
        if ($values[$i]['ID'] == "coll_id") {
            $coll_id = $values[$i]['VALUE'];
        }
        if ($values[$i]['ID'] == "res_id_to_process") {
            $res_id = $values[$i]['VALUE'];
        }
    }
    if ($core->is_module_loaded('folder')) {
        $db = new dbquery();
        $db->connect();
        $folder_id = '';

        if (!empty($folder)) {
            if (!preg_match('/\([0-9]+\)$/', $folder)) {
                $_SESSION['action_error'] = _FOLDER." "._WRONG_FORMAT."";
                return false;
            }
            $folder_id = str_replace(')', '', substr($folder, strrpos($folder,'(')+1));
            $db->query("select folders_system_id from ".$_SESSION['tablename']['fold_folders']." where folders_system_id = ".$folder_id);
            if ($db->nb_result() == 0) {
                $_SESSION['action_error'] = _FOLDER.' '.$folder_id.' '._UNKNOWN;
                return false;
            }
        }

        if (!empty($res_id) && !empty($coll_id) && !empty($folder_id)) {
            require_once('core'.DIRECTORY_SEPARATOR.'class'.DIRECTORY_SEPARATOR.'class_security.php');
            $sec = new security();
            $table = $sec->retrieve_table_from_coll($coll_id);
            if (empty($table)) {
                $_SESSION['action_error'] .= _COLLECTION.' '._UNKNOWN;
                return false;
            }
            $db->query("select type_id from ".$table." where res_id = ".$res_id);
            $res = $db->fetch_object();
            $type_id = $res->type_id;
            $foldertype_id = '';
            $db->query("select foldertype_id from ".$_SESSION['tablename']['fold_folders']." where folders_system_id = ".$folder_id);
            $res = $db->fetch_object();
            $foldertype_id = $res->foldertype_id;
            $db->query("select fdl.foldertype_id from ".$_SESSION['tablename']['fold_foldertypes_doctypes_level1']
                ." fdl, ".$_SESSION['tablename']['doctypes']
                ." d where d.doctypes_first_level_id = fdl.doctypes_first_level_id and fdl.foldertype_id = "
                .$foldertype_id." and d.type_id = ".$type_id);
            if ($db->nb_result() == 0) {
                $_SESSION['action_error'] .= _ERROR_COMPATIBILITY_FOLDER;
                return false;
            }
        }
    }
    if ($other_checked && $other_txt == '') {
        $_SESSION['action_error'] = _MUST_DEFINE_ANSWER_TYPE;
        return false;
    }
    if ($check == false) {
        $_SESSION['action_error'] = _MUST_CHECK_ONE_BOX;
    }
    return $check;
}

/**
 * Action of the form : loads the index in the db
 *
 * @param $arr_id Array Not used here
 * @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
 * @return false or an array
 *             $data['result'] : res_id of the new file followed by #
 *             $data['history_msg'] : Log complement (empty by default)
 **/
function manage_form($arr_id, $history, $id_action, $label_action, $status,  $coll_id, $table, $values_form)
{
    if (empty($values_form) || count($arr_id) < 1 || empty($coll_id)) {
        return false;
    }
    //require_once("core/class/class_db.php");
    require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_security.php");
    $sec =new security();
    $db = new dbquery();
    $core = new core_tools();
    $db->connect();
    $res_table = $sec->retrieve_table_from_coll($coll_id);
    $ind = $sec->get_ind_collection($coll_id);
    $table = $_SESSION['collections'][$ind]['extensions'][0];
    $simple_mail = '0';
    $AR_mail = '0';
    $contact = '0';
    $email = '0';
    $fax = '0';
    $other = '0';
    $no_answer = '0';
    $other_txt = '';
    $process_notes = '';
    $folder = '';
    for ($j=0; $j<count($values_form); $j++) {
        if ($values_form[$j]['ID'] == "simple_mail" && $values_form[$j]['VALUE'] == "true") {
            $simple_mail = '1';
        }
        if ($values_form[$j]['ID'] == "registered_mail" && $values_form[$j]['VALUE'] == "true") {
            $AR_mail = '1';
        }
        if ($values_form[$j]['ID'] == "direct_contact" && $values_form[$j]['VALUE'] == "true") {
            $contact = '1';
        }
        if ($values_form[$j]['ID'] == "email" && $values_form[$j]['VALUE'] == "true") {
            $email = '1';
        }
        if ($values_form[$j]['ID'] == "fax" && $values_form[$j]['VALUE'] == "true") {
            $fax = '1';
        }
        if ($values_form[$j]['ID'] == "other" && $values_form[$j]['VALUE'] == "true") {
            $other = '1';
        }
        if ($values_form[$j]['ID'] == "no_answer" && $values_form[$j]['VALUE'] == "true") {
            $no_answer = '1';
        }
        if ($values_form[$j]['ID'] == "other_answer" && !empty($values_form[$j]['ID']) && trim($values_form[$j]['ID']) <> html_entity_decode('['._DEFINE.']', ENT_NOQUOTES, 'UTF-8')) {
            $other_txt = $values_form[$j]['VALUE'];
        }
        if ($values_form[$j]['ID'] == "process_notes") {
            $process_notes = $values_form[$j]['VALUE'];
        }
        if ($values_form[$j]['ID'] == "folder") {
            $folder = $values_form[$j]['VALUE'];
        }
    }
    if ($no_answer == '1') {
        $bitmask = '000000';
    } else {
        $bitmask = $other.$fax.$email.$contact.$AR_mail.$simple_mail;
    }

    if ($core->is_module_loaded('tags')) {
        include_once("modules".DIRECTORY_SEPARATOR."tags".
                    DIRECTORY_SEPARATOR."tags_update.php");
    }
    if ($core->is_module_loaded('folder')) {
        $folder_id = '';
        $old_folder_id = '';
        //get old folder ID
        $db->connect();
        $db->query("select folders_system_id from ".$res_table." where res_id = ".$arr_id[0]);
        $res = $db->fetch_object();
        $old_folder_id = $res->folders_system_id;
            
        if (!empty($folder)) {    
            $folder_id = str_replace(')', '', substr($folder, strrpos($folder,'(')+1));

            if ($folder_id <> $old_folder_id && $_SESSION['history']['folderup']) {
                require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_history.php");
                $hist = new history();
                $hist->add($_SESSION['tablename']['fold_folders'], $folder_id, "UP", 'folderup', _DOC_NUM.$arr_id[0]._ADDED_TO_FOLDER, $_SESSION['config']['databasetype'],'apps');
                if (isset($old_folder_id) && !empty($old_folder_id)) {
                    $hist->add($_SESSION['tablename']['fold_folders'], $old_folder_id, "UP", 'folderup', _DOC_NUM.$arr_id[0]._DELETED_FROM_FOLDER, $_SESSION['config']['databasetype'],'apps');
                }
            }

            $db->query("update ".$res_table." set folders_system_id =".$folder_id." where res_id =".$arr_id[0]);
        } else if(empty($folder) && !empty($old_folder_id)) { //Delete folder reference in res_X
            $db->query("update ".$res_table." set folders_system_id = NULL where res_id =".$arr_id[0]);
        }
    }
    if ($core->is_module_loaded('entities') && count($_SESSION['redirect']['diff_list']) == 0) {
        require_once('modules/entities/class/class_manage_listdiff.php');
        $list = new diffusion_list();
        $params = array('mode'=> 'listinstance', 'table' => $_SESSION['tablename']['ent_listinstance'], 'coll_id' => $coll_id, 'res_id' => $arr_id[0], 'user_id' => $_SESSION['user']['UserId'], 'concat_list' => true, 'only_cc' => true);
        $list->load_list_db($_SESSION['process']['diff_list'], $params); //pb enchainement avec action redirect
    }
    //$_SESSION['process']['diff_list'] = array();
    $_SESSION['redirect']['diff_list'] = array();
    unset($_SESSION['redirection']);
    unset($_SESSION['redirect']);
    $db->query("update ".$table." set answer_type_bitmask = '".$bitmask."', process_notes = '".$db->protect_string_db($process_notes)."', other_answer_desc ='".$db->protect_string_db($other_txt)."'
    WHERE res_id=".$arr_id[0]);
    return array('result' => $arr_id[0].'#', 'history_msg' => '');
}

function manage_unlock($arr_id, $history, $id_action, $label_action, $status, $coll_id, $table)
{
    $db = new dbquery();
    $db->connect();
    $result = '';
    for ($i=0; $i<count($arr_id);$i++) {
        $result .= $arr_id[$i].'#';
        $req = $db->query("update ".$table. " set video_user = '', video_time = 0 where res_id = ".$arr_id[$i], true);
        if (!$req) {
            $_SESSION['action_error'] = _SQL_ERROR;
            return false;
        }
    }
    return array('result' => $result, 'history_msg' => '');
}