<?php

/*
*   Copyright 2008-2015 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   Contains data structure used to get the proper index for a given business category,
*  to checks data and to loads in db (indexing, process, validation, details, ...) and the function to access it
*
* @file
* @author Laurent Giovannoni <dev@maarch.org>
* @date $date$
* @version $Revision$
* @ingroup apps
*/

///////////////////// Pattern to check dates
$_ENV['date_pattern'] = "/^[0-3][0-9]-[0-1][0-9]-[1-2][0-9][0-9][0-9]$/";

/*
 * Categories are described in a global variable : $_ENV['categories']
 * $_ENV['categories'][category_id]
 *      ['img_cat'] : url of the icon category
 *      [id_field] // id_field must be an identifier of a field in the form and in the database
 *          ['type_form'] = Form type field: 'integer', 'date', 'string', 'yes_no', 'special'
 *          ['type_field'] = Database type field :'integer', 'date', 'string', 'yes_no', 'special'
 *          ['mandatory'] = true or false
 *          ['label'] = label of the field
 *          ['img'] = Image url (optional)
 *          ['table'] = keyword : 'res' = field in the res_x like table
 *                                'coll_ext' = field in collection ext table (ex : mlb_ext_coll)
 *                                'none' = field in no table, only in form for special functionnality
 *                                'special' = field in other table, handled in the code
 *          ['modify'] = true or false (optional) : can we modify this field (used in details.php)
 *          ['form_show'] = keyword (used with modify = true)
 *                           'select' = displayed in a select item
 *                           'textfield' = displayed in text input
 *                           'date' = displayed in a date input (with calendar activated)
 *      ['other_cases'] // particular cases handled in code
 *            [identifier] // keyword handled in the code
 *                  ['type_form'] = Form type field:'integer', 'date', 'string', 'yes_no', 'special'
 *                  ['type_field'] = Databse type field :'integer', 'date', 'string', 'yes_no', 'special'
 *                  ['mandatory'] = true or false
 *                  ['label'] = label of the field
 *                  ['table'] = keyword : 'res' = field in the res_x like table
 *                                        'coll_ext' = field in collection ext table (ex : mlb_ext_coll)
 *                                        'none' = field in no table, only in form for special functionnality
 *                                        'special' = field in another table, handled in the code
 *                  ['modify'] = true or false (optional) : can we modify this field (used in details.php)
 *                  ['form_show'] = keyword (used with modify = true)
 *                              'select' = displayed in a select item
 *                              'textfield' = keyword : 'date' = date input field
 *                              'date' = displayed in a date input (with calendar activated)
 *
 */

/**************************** Categories descriptions******************************/
$_ENV['categories'] = array ();

///////////////////////////// PURCHASE ////////////////////////////////////////////////
$_ENV['categories']['purchase'] = array ();
$_ENV['categories']['purchase']['img_cat'] = 'shopping-cart';
$_ENV['categories']['purchase']['other_cases'] = array ();

$_ENV['categories']['purchase']['type_id'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => true,
    'label' => _FILING,
    'table' => 'res',
    'img' => 'file',
    'modify' => true,
    'form_show' => 'select'
);

$_ENV['categories']['purchase']['subject'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => false,
    'label' => _SUBJECT,
    'table' => 'res',
    'img' => 'info',
    'modify' => true,
    'form_show' => 'textarea'
);

$_ENV['categories']['purchase']['contact_id'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => true,
    'label' => _SUPPLIER,
    'table' => 'coll_ext',
    'img' => 'book',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['purchase']['identifier'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => true,
    'label' => _IDENTIFIER,
    'table' => 'res',
    'img' => 'barcode',
    'modify' => true,
    'form_show' => 'textfield'
);

$_ENV['categories']['purchase']['doc_date'] = array (
    'type_form' => 'date',
    'type_field' => 'date',
    'mandatory' => true,
    'label' => _DOC_DATE,
    'table' => 'res',
    'img' => 'calendar',
    'modify' => true,
    'form_show' => 'date'
);

$_ENV['categories']['purchase']['currency'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => false,
    'label' => _CURRENCY,
    'table' => 'coll_ext',
    'img' => 'money',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['purchase']['net_sum'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => false,
    'label' => _NET_SUM,
    'table' => 'coll_ext',
    'img' => 'calculator',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['purchase']['tax_sum'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => false,
    'label' => _TAX_SUM,
    'table' => 'coll_ext',
    'img' => 'calculator',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['purchase']['total_sum'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => false,
    'label' => _TOTAL_SUM,
    'table' => 'coll_ext',
    'img' => 'calculator',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['purchase']['process_limit_date_use'] = array (
    'type_form' => 'radio',
    'mandatory' => true,
    'label' => _PROCESS_LIMIT_DATE_USE,
    'table' => 'none',
    'values' => array (
        'Y',
        'N'
    ),
    'modify' => false
);
$_ENV['categories']['purchase']['other_cases']['process_limit_date'] = array (
    'type_form' => 'date',
    'type_field' => 'date',
    'label' => _PROCESS_LIMIT_DATE,
    'table' => 'coll_ext',
    'img' => 'bell',
    'modify' => true,
    'form_show' => 'date'
);

///////////////////////////// SELL ////////////////////////////////////////////////
$_ENV['categories']['sell'] = array ();
$_ENV['categories']['sell']['img_cat'] = '<i class="fa fa-dollar fa-2x"></i>';
$_ENV['categories']['sell']['other_cases'] = array ();

$_ENV['categories']['sell']['type_id'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => true,
    'label' => _FILING,
    'table' => 'res',
    'img' => 'file',
    'modify' => true,
    'form_show' => 'select'
);

$_ENV['categories']['sell']['subject'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => false,
    'label' => _SUBJECT,
    'table' => 'res',
    'img' => 'info',
    'modify' => true,
    'form_show' => 'textarea'
);

$_ENV['categories']['sell']['contact_id'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => true,
    'label' => _PURCHASER,
    'table' => 'coll_ext',
    'img' => 'book',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['sell']['identifier'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => true,
    'label' => _IDENTIFIER,
    'table' => 'res',
    'img' => 'barcode',
    'modify' => true,
    'form_show' => 'textfield'
);

$_ENV['categories']['sell']['doc_date'] = array (
    'type_form' => 'date',
    'type_field' => 'date',
    'mandatory' => true,
    'label' => _DOC_DATE,
    'table' => 'res',
    'img' => 'calendar',
    'modify' => true,
    'form_show' => 'date'
);

$_ENV['categories']['sell']['currency'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => false,
    'label' => _CURRENCY,
    'table' => 'coll_ext',
    'img' => 'money',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['sell']['net_sum'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => false,
    'label' => _NET_SUM,
    'table' => 'coll_ext',
    'img' => 'calculator',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['sell']['tax_sum'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => false,
    'label' => _TAX_SUM,
    'table' => 'coll_ext',
    'img' => 'calculator',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['sell']['total_sum'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => false,
    'label' => _TOTAL_SUM,
    'table' => 'coll_ext',
    'img' => 'calculator',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['sell']['process_limit_date_use'] = array (
    'type_form' => 'radio',
    'mandatory' => true,
    'label' => _PROCESS_LIMIT_DATE_USE,
    'table' => 'none',
    'values' => array (
        'Y',
        'N'
    ),
    'modify' => false
);
$_ENV['categories']['sell']['other_cases']['process_limit_date'] = array (
    'type_form' => 'date',
    'type_field' => 'date',
    'label' => _PROCESS_LIMIT_DATE,
    'table' => 'coll_ext',
    'img' => 'bell',
    'modify' => true,
    'form_show' => 'date'
);

///////////////////////////// ENTERPRISE DOCUMENT ////////////////////////////////////////////////
$_ENV['categories']['enterprise_document'] = array ();
$_ENV['categories']['enterprise_document']['img_cat'] = '<i class="fa fa-building fa-2x"></i>';
$_ENV['categories']['enterprise_document']['other_cases'] = array ();

$_ENV['categories']['enterprise_document']['type_id'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => true,
    'label' => _FILING,
    'table' => 'res',
    'img' => 'file',
    'modify' => true,
    'form_show' => 'select'
);

$_ENV['categories']['enterprise_document']['subject'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => true,
    'label' => _SUBJECT,
    'table' => 'res',
    'img' => 'info',
    'modify' => true,
    'form_show' => 'textarea'
);

$_ENV['categories']['enterprise_document']['contact_id'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => false,
    'label' => _AUTHOR,
    'table' => 'coll_ext',
    'img' => 'book',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['enterprise_document']['identifier'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => false,
    'label' => _IDENTIFIER,
    'table' => 'res',
    'img' => 'barcode',
    'modify' => true,
    'form_show' => 'textfield'
);

$_ENV['categories']['enterprise_document']['doc_date'] = array (
    'type_form' => 'date',
    'type_field' => 'date',
    'mandatory' => true,
    'label' => _DOC_DATE,
    'table' => 'res',
    'img' => 'calendar',
    'modify' => true,
    'form_show' => 'date'
);

$_ENV['categories']['enterprise_document']['doc_custom_n1'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => false,
    'label' => _RM_DOCTYPE,
    'table' => 'res',
    'img' => 'archive',
    'modify' => true,
    'form_show' => 'select'
);

$_ENV['categories']['enterprise_document']['doc_custom_n2'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => false,
    'label' => _ITEM_FOLDER,
    'table' => 'res',
    'img' => 'folder',
    'modify' => true,
    'form_show' => 'autocomplete'
);
$core = new core_tools();
if ($core->is_module_loaded('physical_archive')) {
	$_ENV['categories']['enterprise_document']['other_cases']['arbox_id'] = array (
		'type_form' => 'integer',
		'type_field' => 'integer',
		'mandatory' => false,
		'label' => _BOX_ID,
		'table' => 'res',
		'img' => 'archive',
		'modify' => true,
		'form_show' => 'select'
	);
}
$_ENV['categories']['enterprise_document']['other_cases']['process_limit_date'] = array (
    'type_form' => 'date',
    'type_field' => 'date',
    'label' => _PROCESS_LIMIT_DATE,
    'table' => 'coll_ext',
    'img' => 'bell',
    'modify' => true,
    'form_show' => 'date'
);
$_ENV['categories']['enterprise_document']['folder_id'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'label' => _FOLDER,
    'table' => 'res',
    'img' => 'folder',
    'modify' => true,
    'form_show' => 'autocomplete'
);

///////////////////////////// HUMAN RESOURCES ////////////////////////////////////////////////
$_ENV['categories']['human_resources'] = array ();
$_ENV['categories']['human_resources']['img_cat'] = '<i class="fa fa-user fa-2x"></i>';
$_ENV['categories']['human_resources']['other_cases'] = array ();

$_ENV['categories']['human_resources']['type_id'] = array (
    'type_form' => 'integer',
    'type_field' => 'integer',
    'mandatory' => true,
    'label' => _FILING,
    'table' => 'res',
    'img' => 'file',
    'modify' => true,
    'form_show' => 'select'
);

$_ENV['categories']['human_resources']['subject'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => true,
    'label' => _SUBJECT,
    'table' => 'res',
    'img' => 'info',
    'modify' => true,
    'form_show' => 'textarea'
);

$_ENV['categories']['human_resources']['contact_id'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => false,
    'label' => _EMPLOYEE,
    'table' => 'coll_ext',
    'img' => 'book',
    'modify' => false,
    'form_show' => 'textfield'
);

$_ENV['categories']['human_resources']['identifier'] = array (
    'type_form' => 'string',
    'type_field' => 'string',
    'mandatory' => false,
    'label' => _IDENTIFIER,
    'table' => 'res',
    'img' => 'barcode',
    'modify' => true,
    'form_show' => 'textfield'
);

$_ENV['categories']['human_resources']['doc_date'] = array (
    'type_form' => 'date',
    'type_field' => 'date',
    'mandatory' => true,
    'label' => _DOC_DATE,
    'table' => 'res',
    'img' => 'calendar',
    'modify' => true,
    'form_show' => 'date'
);

/////////////////////////////MODULES SPECIFIC////////////////////////////////////////////////
$core = new core_tools();
if ($core->is_module_loaded('entities')) {
    $_ENV['categories']['purchase']['destination'] = array (
        'type_form' => 'string',
        'type_field' => 'string',
        'mandatory' => true,
        'label' => _DEPARTMENT_OWNER,
        'table' => 'res',
        'img' => 'sitemap',
        'modify' => false,
        'form_show' => 'select'
    );
    $_ENV['categories']['purchase']['other_cases']['diff_list'] = array (
        'type' => 'special',
        'mandatory' => true,
        'label' => _DIFF_LIST,
        'table' => 'special'
    );
    
    $_ENV['categories']['sell']['destination'] = array (
        'type_form' => 'string',
        'type_field' => 'string',
        'mandatory' => true,
        'label' => _DEPARTMENT_OWNER,
        'table' => 'res',
        'img' => 'sitemap',
        'modify' => false,
        'form_show' => 'select'
    );
    $_ENV['categories']['sell']['other_cases']['diff_list'] = array (
        'type' => 'special',
        'mandatory' => true,
        'label' => _DIFF_LIST,
        'table' => 'special'
    );
    
    $_ENV['categories']['enterprise_document']['destination'] = array (
        'type_form' => 'string',
        'type_field' => 'string',
        'mandatory' => true,
        'label' => _DEPARTMENT_OWNER,
        'table' => 'res',
        'img' => 'sitemap',
        'modify' => false,
        'form_show' => 'select'
    );
    $_ENV['categories']['enterprise_document']['other_cases']['diff_list'] = array (
        'type' => 'special',
        'mandatory' => false,
        'label' => _DIFF_LIST,
        'table' => 'special'
    );
    
    $_ENV['categories']['human_resources']['destination'] = array (
        'type_form' => 'string',
        'type_field' => 'string',
        'mandatory' => true,
        'label' => _DEPARTMENT_OWNER,
        'table' => 'res',
        'img' => 'sitemap',
        'modify' => false,
        'form_show' => 'select'
    );
    $_ENV['categories']['human_resources']['other_cases']['diff_list'] = array (
        'type' => 'special',
        'mandatory' => false,
        'label' => _DIFF_LIST,
        'table' => 'special'
    );
}

if ($core->is_module_loaded('folder')) {
    $_ENV['categories']['purchase']['other_cases']['folder'] = array (
        'type_form' => 'string',
        'type_field' => 'string',
        'mandatory' => false,
        'label' => _FOLDER,
        'table' => 'none',
        'img' => 'folder',
        'modify' => true,
        'form_show' => 'autocomplete'
    );
    $_ENV['categories']['sell']['other_cases']['folder'] = array (
        'type_form' => 'string',
        'type_field' => 'string',
        'mandatory' => false,
        'label' => _FOLDER,
        'table' => 'none',
        'img' => 'folder',
        'modify' => true,
        'form_show' => 'autocomplete'
    );
    $_ENV['categories']['enterprise_document']['other_cases']['folder'] = array (
        'type_form' => 'string',
        'type_field' => 'string',
        'mandatory' => false,
        'label' => _FOLDER,
        'table' => 'none',
        'img' => 'folder',
        'modify' => true,
        'form_show' => 'autocomplete'
    );
    $_ENV['categories']['human_resources']['other_cases']['folder'] = array (
        'type_form' => 'string',
        'type_field' => 'string',
        'mandatory' => false,
        'label' => _FOLDER,
        'table' => 'none',
        'img' => 'folder',
        'modify' => true,
        'form_show' => 'autocomplete'
    );
}

/************************* END *************************************************************/

/**
* Gets the index of a given res_id in an array
*
* @param $coll_id string  Collection identifier
* @param $res_id string  Resource identifier
* @param $mode string  'full' : fills the array with maximum data (id, value, show_value,etc...), 'minimal' the array contains only the value or 'form" the array contains the data to be displayed in a form
* @param $params array optional parameters
*           $params['img_'.field_id] = true (gets the img url in the 'full' mode array for the field_id), false (no img for the field_id )
* @return Array Structure different in 'full' mode, 'form' and 'minimal' mode
*           mode 'full' : $data[field_id] field_id exemple: 'priority'
*                                       ['value'] : value of the field in the database
*                                       ['show_value'] : value to display
*                                       ['label'] : label to display
*                                       ['display'] : type of display (only 'textinput' and 'textarea' for the moment)
*                                       ['img'] : url of an icon to display (optional)
*           mode 'minimal' : $data[field_id] = value of the field in the database
*           mode 'form' : $data[field_id] field_id exemple: 'priority'
*                                       ['value'] : value of the field in the database
*                                       ['show_value'] : value to display
*                                       ['label'] : label to display
*                                       ['display'] : type of display (only 'textinput' and 'textarea' for the moment)
*                                       ['img'] : url of an icon to display (optional)
*                                       ['readonly'] : true or false
*                                       ['field_type'] : keyword 'date' = date input field with calendar
 *                                                               'textfield' = text input field
 *                                                               'select' = select field
*                                       ['select'] : array of options items (only if field_type = 'select')
*                                               [$i]['id'] : option value
*                                                   ['label'] : option text
*/
function get_general_data($coll_id, $res_id, $mode, $params = array ()) {
    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();
    $db2 = new dbquery();
    $db2->connect();
    $db->query('select category_id from ' . $view . ' where res_id = ' . $res_id);
    $res = $db->fetch_object();
    $cat_id = $res->category_id;
    $fields = '';
    $data = array ();
    $arr = array ();

    // First we load the category_id
    if ($mode == 'full' || 'form') {
        if ($params['img_category_id'] == true) {
            $data['category_id'] = array (
                'value' => $res->category_id,
                'show_value' => $_SESSION['coll_categories']['business_coll'][$res->category_id],
                'label' => _CATEGORY,
                'display' => 'textinput',
                //'img' => $_SESSION['config']['businessappurl'] . 'static.php?filename=picto_change.gif'
                'img' => $_ENV['categories'][$res->category_id]['img_cat']
            );
        } else {
            $data['category_id'] = array (
                'value' => $res->category_id,
                'show_value' => $_SESSION['coll_categories']['business_coll'][$res->category_id],
                'label' => _CATEGORY,
                'display' => 'textinput'
            );
        }
    } else {
        $data['category_id'] = $res->category_id;
    }
    if (!isset ($cat_id) || empty ($cat_id)) {
        $cat_id = 'empty';
    }
    //Then we browse the $_ENV['categories'] array to get the other indexes
    foreach (array_keys($_ENV['categories'][$cat_id]) as $field) {
        // Normal cases : fields are put in a string to make a query
        if ($field <> 'process_limit_date_use' && $field <> 'other_cases' && $field <> 'type_contact' && $field <> 'img_cat') {
            $fields .= $field . ',';
            if (($mode == 'full' || $mode == 'form') && (!isset ($params['show_' . $field]) || $params['show_' . $field] == true)) {
                if ($params['img_' . $field] == true) {
                    $data[$field] = array (
                        'value' => '',
                        'show_value' => '',
                        'label' => $_ENV['categories'][$cat_id][$field]['label'],
                        'display' => 'textinput',
                        'img' => $_ENV['categories'][$cat_id][$field]['img'],
                    );
                } else {
                    $data[$field] = array (
                        'value' => '',
                        'show_value' => '',
                        'label' => $_ENV['categories'][$cat_id][$field]['label'],
                        'display' => 'textinput'
                    );
                }
                array_push($arr, $field);
                if ($field == 'subject') {
                    $data[$field]['display'] = 'textarea';
                }
                $data[$field]['readonly'] = true;
                if ($mode == 'form' && $_ENV['categories'][$cat_id][$field]['modify']) {
                    $data[$field]['readonly'] = false;
                    $data[$field]['field_type'] = $_ENV['categories'][$cat_id][$field]['form_show'];
                    if ($data[$field]['field_type'] == 'select') {
                        $data[$field]['select'] = array ();
                        if ($field == 'type_id') {
                            require_once ('apps/' . $_SESSION['config']['app_id'] . '/class/class_types.php');
                            $type = new types();
                            if ($_SESSION['features']['show_types_tree'] == 'true') {
                                $data[$field]['select'] = $type->getArrayStructTypes($coll_id);
                            } else {
                                $data[$field]['select'] = $type->getArrayTypes($coll_id);
                            }
                        } else
                            if ($field == 'destination') {
                                //require_once("apps".DIRECTORY_SEPARATOR.$_SESSION['config']['app_id'].DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_entities.php");
                                // TO DO : get the entities list
                            } else
                                if ($field == 'nature_id') {
                                    foreach (array_keys($_SESSION['mail_natures']) as $nature) {
                                        array_push($data[$field]['select'], array (
                                            'ID' => $nature,
                                            'LABEL' => $_SESSION['mail_natures'][$nature]
                                        ));
                                    }
                                } else
                                    if ($field == 'priority') {
                                        foreach (array_keys($_SESSION['mail_priorities']) as $prio) {
                                            array_push($data[$field]['select'], array (
                                                'ID' => $prio,
                                                'LABEL' => $_SESSION['mail_priorities'][$prio]
                                            ));
                                        }
                                    }
                    }
                }
            } else
                if ($mode == 'minimal' && (!isset ($params['show_' . $field]) || $params['show_' . $field] == true)) {
                    $data[$field] = '';
                    array_push($arr, $field);
                }
        }
    }
    // Special cases :  fields are put in a string to make a query
    // Process limit date
    if (isset ($_ENV['categories'][$cat_id]['other_cases']['process_limit_date']) && count($_ENV['categories'][$cat_id]['other_cases']['process_limit_date']) > 0 && (!isset ($params['show_process_limit_date']) || $params['show_process_limit_date'] == true)) {
        $fields .= 'process_limit_date,';
        if ($mode == 'full' || 'form') {
            if ($params['img_process_limit_date'] == true) {
                $data['process_limit_date'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['process_limit_date']['label'],
                    'display' => 'textinput',
                    'img' => $_ENV['categories'][$cat_id]['other_cases']['process_limit_date']['img'],
                    'modify' => true,
                    'form_show' => 'date',
                    'field_type' => 'date'
                );
            } else {
                $data['process_limit_date'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['process_limit_date']['label'],
                    'display' => 'textinput'
                );
            }
            $data['process_limit_date']['readonly'] = false;
            if (isset($_ENV['categories'][$cat_id]['process_limit_date']['modify'])
                && $mode == 'form' && $_ENV['categories'][$cat_id]['process_limit_date']['modify']
            ) {
                $data['process_limit_date']['field_type'] = $_ENV['categories'][$cat_id]['process_limit_date']['form_show'];
                $data['process_limit_date']['readonly'] = false;
            }
        } else {
            $data['process_limit_date'] = '';
            $data['process_limit_date_use'] = false;
        }
        array_push($arr, 'process_limit_date');
    }
    // Contact
    if (isset ($_ENV['categories'][$cat_id]['contact']) && count($_ENV['categories'][$cat_id]['contact']) > 0 && (!isset ($params['show_contact']) || $params['show_contact'] == true)) {
        $fields .= $_ENV['categories'][$cat_id]['contact']['special'] . ',';
        if (preg_match('/,/', $_ENV['categories'][$cat_id]['contact']['special'])) {
            $arr_tmp = preg_split('/,/', $_ENV['categories'][$cat_id]['contact']['special']);
        } else {
            $arr_tmp = array (
                $_ENV['categories'][$cat_id]['contact']['special']
            );
        }
        for ($i = 0; $i < count($arr_tmp); $i++) {
            if ($mode == 'full' || $mode == 'form') {
                $data[$arr_tmp[$i]] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['contact']['label'],
                    'display' => 'textinput'
                );
                $data[$arr_tmp[$i]]['readonly'] = true;
                if (isset($_ENV['categories'][$cat_id][$arr_tmp[$i]]['modify'])
                    && $mode == 'form' && $_ENV['categories'][$cat_id][$arr_tmp[$i]]['modify']
                ) {
                    $data[$arr_tmp[$i]]['field_type'] = $_ENV['categories'][$cat_id][$arr_tmp[$i]]['form_show'];
                    $data[$arr_tmp[$i]]['readonly'] = false;
                }
            }
            array_push($arr, $arr_tmp[$i]);
        }

        if ($mode == 'minimal') {
            $data['contact'] = '';
        }

    }
    // Market
    if (isset ($_ENV['categories'][$cat_id]['other_cases']['market']) && count($_ENV['categories'][$cat_id]['other_cases']['market']) > 0 && (!isset ($params['show_market']) || $params['show_market'] == true)) {
        //echo 'market ';
        $fields .= 'folders_system_id,';
        if ($mode == 'full' || $mode == 'form') {
            if (isset($params['img_project']) && $params['img_project'] == true) {
                $data['project'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['project']['label'],
                    'display' => 'textinput',
                    'img' => $_ENV['categories'][$cat_id]['other_cases']['project']['img']
                );
            } else {
                $data['project'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['project']['label'],
                    'display' => 'textinput'
                );
            }
            if (isset($params['img_market']) && $params['img_market'] == true) {
                $data['market'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['market']['label'],
                    'display' => 'textinput',
                    'img' => $_ENV['categories'][$cat_id]['other_cases']['market']['img']
                );
            } else {
                $data['market'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['market']['label'],
                    'display' => 'textinput'
                );
            }
            $data['market']['readonly'] = true;
            if ($mode == 'form' && $_ENV['categories'][$cat_id]['other_cases']['market']['modify']) {
                $data['market']['field_type'] = $_ENV['categories'][$cat_id]['other_cases']['market']['form_show'];
                $data['market']['readonly'] = false;
            }
            $data['project']['readonly'] = true;
            if ($mode == 'form' && $_ENV['categories'][$cat_id]['other_cases']['project']['modify']) {
                $data['project']['field_type'] = $_ENV['categories'][$cat_id]['other_cases']['project']['form_show'];
                $data['project']['readonly'] = false;
            }
        } else {
            $data['market'] = '';
            $data['project'] = '';
        }
        array_push($arr, 'market');
    }
    // Project
    if (isset ($_ENV['categories'][$cat_id]['other_cases']['project']) && count($_ENV['categories'][$cat_id]['other_cases']['project']) > 0 && (!isset ($params['show_project']) || $params['show_project'] == true)) {
        //echo 'project';
        if (!isset ($_ENV['categories'][$cat_id]['other_cases']['market']) || count($_ENV['categories'][$cat_id]['other_cases']['market']) == 0) {

            $fields .= 'folders_system_id,';
            //array_push($arr, 'project');
        }
        array_push($arr, 'project');
        if ($mode == 'full' || $mode == 'form') {
            if ($params['img_project'] == true) {
                $data['project'] = array(
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['project']['label'],
                    'display' => 'textinput',
                    'img' => $_ENV['categories'][$cat_id]['other_cases']['project']['img']
                );
            } else {
                $data['project'] = array(
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['project']['label'],
                    'display' => 'textinput'
                );
            }
            $data['project']['readonly'] = true;
            if ($mode == 'form' && $_ENV['categories'][$cat_id]['other_cases']['project']['modify']) {
                $data['project']['field_type'] = $_ENV['categories'][$cat_id]['other_cases']['project']['form_show'];
                $data['project']['readonly'] = false;
            }
        } else {
            $data['project'] = '';
        }
    }
    // Arboxes
    if (isset ($_ENV['categories'][$cat_id]['other_cases']['arbox_id']) && count($_ENV['categories'][$cat_id]['other_cases']['arbox_id']) > 0 && (!isset ($params['show_arbox_id']) || $params['show_arbox_id'] == true)) {
        $fields .= 'arbox_id,';
        if ($mode == 'full' || $mode == 'form') {
            if ($params['img_arbox_id'] == true) {
                $data['arbox_id'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['arbox_id']['label'],
                    'display' => 'textinput',
                    'img' => $_ENV['categories'][$cat_id]['other_cases']['arbox_id']['img']
                );
            } else {
                $data['arbox_id'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['other_cases']['arbox_id']['label'],
                    'display' => 'textinput'
                );
            }
            $data['arbox_id']['readonly'] = true;
            if ($mode == 'form' && $_ENV['categories'][$cat_id]['other_cases']['arbox_id']['modify']) {
                $data['arbox_id']['field_type'] = $_ENV['categories'][$cat_id]['other_cases']['arbox_id']['form_show'];
                $data['arbox_id']['readonly'] = false;
                $data['arbox_id']['select'] = array ();
                $db->query("select arbox_id, title from " . $_SESSION['tablename']['ar_boxes'] . " where status ='NEW' order by title");
                while ($res = $db->fetch_object()) {
                    array_push($data['arbox_id']['select'], array (
                        'ID' => $res->arbox_id,
                        'LABEL' => $res->title . ' (' . $res->arbox_id . ')'
                    ));
                }
            }
        } else {
            $data['arbox_id'] = '';
        }
        array_push($arr, 'arbox_id');
    }

	//Tableau de gestion avec fichiers
	if (isset ($_ENV['categories'][$cat_id]['doc_custom_n1']) && count($_ENV['categories'][$cat_id]['doc_custom_n1']) > 0 && (!isset ($params['show_doc_custom_n1']) || $params['show_doc_custom_n1'] == true)) {
        $fields .= 'doc_custom_n1,';
        if ($mode == 'full' || $mode == 'form') {
            if ($params['img_doc_custom_n1'] == true) {
                $data['doc_custom_n1'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['doc_custom_n1']['label'],
                    'display' => 'textinput',
                    'img' => $_ENV['categories'][$cat_id]['doc_custom_n1']['img']
                );
            } else {
                $data['doc_custom_n1'] = array (
                    'value' => '',
                    'show_value' => '',
                    'label' => $_ENV['categories'][$cat_id]['doc_custom_n1']['label'],
                    'display' => 'textinput'
                );
            }
            $data['doc_custom_n1']['readonly'] = true;
            if ($mode == 'form' && $_ENV['categories'][$cat_id]['doc_custom_n1']['modify']) {
                $data['doc_custom_n1']['field_type'] = $_ENV['categories'][$cat_id]['doc_custom_n1']['form_show'];
                $data['doc_custom_n1']['readonly'] = false;
                $data['doc_custom_n1']['select'] = array ();
				
                $db->query("select folders_system_id, folder_name from " . $_SESSION['tablename']['fold_folders'] . " where foldertype_id = 100 order by folder_name");
               				    array_push($data['doc_custom_n1']['select'], array (
                        'ID' => '',
                        'LABEL' => 'Sélectionner un type d archive'
                    ));

			   while ($res = $db->fetch_object()) {
                    array_push($data['doc_custom_n1']['select'], array (
                        'ID' => $res->folders_system_id,
                        'LABEL' => $res->folder_name
                    ));
                }
				
            }
        } else {
            $data['doc_custom_n1'] = '';
        }
        array_push($arr, 'doc_custom_n1');
    }
	
    if ($mode == 'full' || $mode == 'form') {
        $fields = preg_replace('/,$/', ',type_label', $fields);
    } else {
        $fields = preg_replace('/,$/', '', $fields);
    }
    // Query
    $db->query("select category_id," . $fields . " from " . $view . " where res_id = " . $res_id);
    //$db->show();
    //$db->show_array($arr);exit;

    $line = $db->fetch_object();
    // We fill the array with the query result
    $currency = '';
    for ($i = 0; $i < count($arr); $i++) {
        if ($mode == 'full' || $mode == 'form') {
            // Normal Cases
            if (isset($line-> $arr[$i])) {
                $data[$arr[$i]]['value'] = $line-> $arr[$i];
            }
            if ($arr[$i] <> 'project') {
                $data[$arr[$i]]['show_value'] = $db->show_string($data[$arr[$i]]['value']);
            }
            if (isset($_ENV['categories'][$cat_id][$arr[$i]]['type_field'])
                && $_ENV['categories'][$cat_id][$arr[$i]]['type_field'] == 'date'
            ) {
                $data[$arr[$i]]['show_value'] = $db->format_date_db($line-> $arr[$i], false);
            } else if (isset($_ENV['categories'][$cat_id]['other_cases'][$arr[$i]]['type_field'])
                && $_ENV['categories'][$cat_id]['other_cases'][$arr[$i]]['type_field'] == 'date'
            ) {
                $data[$arr[$i]]['show_value'] = $db->format_date_db($line-> $arr[$i], false);
            } else if (isset($_ENV['categories'][$cat_id][$arr[$i]]['type_field'])
                && $_ENV['categories'][$cat_id][$arr[$i]]['type_field'] == 'string'
            ) {
                $data[$arr[$i]]['show_value'] = $db->show_string($line-> $arr[$i], true);
            }
            // special cases :
            if ($arr[$i] == 'currency') {
                  $currency = $line-> $arr[$i];
            }
            if ($arr[$i] == 'priority') {
                $data[$arr[$i]]['show_value'] = $_SESSION['mail_priorities'][$line-> $arr[$i]];
            }
            elseif ($arr[$i] == 'destination') {
                $db2->query('select entity_label from ' . $_SESSION['tablename']['ent_entities'] . " where entity_id = '" . $line-> $arr[$i] . "'");
                if ($db2->nb_result() == 1) {
                    $res2 = $db2->fetch_object();
                    $data[$arr[$i]]['show_value'] = $db->show_string($res2->entity_label, true);
                }
            }
            elseif ($arr[$i] == 'nature_id') {
                $data[$arr[$i]]['show_value'] = $_SESSION['mail_natures'][$line-> $arr[$i]];
            }
            elseif ($arr[$i] == 'type_id') {
                $data[$arr[$i]]['show_value'] = $db->show_string($line->type_label);
            }
            elseif ($arr[$i] == 'net_sum' || $arr[$i] == 'tax_sum' || $arr[$i] == 'total_sum') {
                $data[$arr[$i]]['show_value'] = $db->formatAmount($currency, $line-> $arr[$i]);
            }
            // Arboxe
            elseif ($arr[$i] == 'arbox_id') {
                if (isset ($line->arbox_id) && !empty ($line->arbox_id)) {
                    $db2->query('select title from ' . $_SESSION['tablename']['ar_boxes'] . " where arbox_id = " . $line->arbox_id . "");

                    $res = $db2->fetch_object();
                    $data[$arr[$i]]['show_value'] = $db->show_string($res->title . ' (' . $line->arbox_id . ')');
					$data[$arr[$i]]['img'] = $_ENV['categories']['enterprise_document']['other_cases']['arbox_id']['img'];
                }
            }
			// Plan de classement
			elseif ($arr[$i] == 'doc_custom_n2') {
                if (isset ($line->doc_custom_n2) && !empty ($line->doc_custom_n2)) {
                    $db2->query('select folder_name, folder_id, folders_system_id from ' . $_SESSION['tablename']['fold_folders'] . " where folders_system_id = " . $line->doc_custom_n2 . "");

                    $res = $db2->fetch_object();
                    $data[$arr[$i]]['show_value'] = $db->show_string($res->folder_id) . ', ' . $db->show_string($res->folder_name) . ' (' .$db->show_string($res->folders_system_id) . ')';
					$data[$arr[$i]]['img'] = $_ENV['categories']['enterprise_document']['doc_custom_n2']['img'];
                }
            }
			// Tableau de gestion
			elseif ($arr[$i] == 'doc_custom_n1') {
                if (isset ($line->doc_custom_n1) && !empty ($line->doc_custom_n1)) {
                    $db2->query('select folder_name from ' . $_SESSION['tablename']['fold_folders'] . " where folders_system_id = " . $line->doc_custom_n1 . "");

                    $res = $db2->fetch_object();
                    $data[$arr[$i]]['show_value'] = $db->show_string($res->folder_name);
					$data[$arr[$i]]['img'] = $_ENV['categories']['enterprise_document']['doc_custom_n1']['img'];
                }else {
					$data[$arr[$i]]['show_value'] = 'Sélectionner un type d archive';
				}
            }
			
			//Folders
			elseif ($arr[$i] == 'folder_id') {
                if (isset ($line->folder_id) && !empty ($line->folder_id)) {
                    $db2->query('select folder_id, folder_name, folders_system_id from ' . $_SESSION['tablename']['fold_folders'] . " where folder_id = '" . $line->folder_id . "'");

                    $res = $db2->fetch_object();
                    $data[$arr[$i]]['show_value'] = $db->show_string($res->folder_id) . ', ' . $db->show_string($res->folder_name) . ' (' .$db->show_string($res->folders_system_id) . ')';
					$data[$arr[$i]]['img'] = $_ENV['categories']['enterprise_document']['folder_id']['img'];
                }
            }
			
            // Contact
            elseif ($arr[$i] == 'contact_id') {
                if (!empty ($line-> $arr[$i])) {
                    $db2->query('select is_corporate_person, lastname, firstname, society from ' . $_SESSION['tablename']['contacts_v2'] . " where  contact_id = " . $line-> $arr[$i] . "");
                    $res = $db2->fetch_object();
                    if ($res->is_corporate_person == 'Y') {
                        $data[$arr[$i]]['show_value'] = $res->society;
                    } else {
                        $data[$arr[$i]]['show_value'] = $res->lastname . ' ' . $res->firstname;
                        if (!empty ($res->society)) {
                            $data[$arr[$i]]['show_value'] .= ' (' . $res->society . ')';
                        }
                    }
                    $db2->query("select address_id from business_coll_ext where res_id = " . $res_id);
                    $res = $db2->fetch_object();
                    $data[$arr[$i]]['addon'] = '<a href="#" id="contact_card" title="' . _CONTACT_CARD . '" onclick="window.open(\'' . $_SESSION['config']['businessappurl'] . 'index.php?display=true&dir=my_contacts&page=info_contact_iframe&mode=view&contactid=' . $line-> $arr[$i] . '&addressid='.$res->address_id.'\', \'contact_info\', \'height=800, width=900,scrollbars=no,resizable=yes\');" >'
                        . '<i class="fa fa-' 
                        . $_ENV['categories'][$cat_id]['contact_id']['img'] . ' fa-2x" title="' . _CONTACT_CARD . '" ></i></a>';
                } else {
                    unset ($data[$arr[$i]]);
                }
            }
            // Folder : market
            elseif ($arr[$i] == 'market' && isset ($line->folders_system_id) && !empty ($line->folders_system_id)) {
                $db2->query('select folder_name, subject, folders_system_id, parent_id from ' . $_SESSION['tablename']['fold_folders'] . " where status <> 'DEL' and folders_system_id = " . $line->folders_system_id . " and folder_level = 2");

                if ($db2->nb_result() > 0) {
                    $res = $db2->fetch_object();
                    $data['market']['show_value'] = $res->folder_name . ', ' . $res->subject . ' (' . $res->folders_system_id . ')';
                    $folder_id = $res->parent_id;
                    if (isset ($folder_id) && !empty ($folder_id)) {
                        $db2->query('select folder_name, subject, folders_system_id from ' . $_SESSION['tablename']['fold_folders'] . " where status <> 'DEL' and folders_system_id = " . $folder_id . " and folder_level = 1");
                        //  $db2->show();
                        $res = $db2->fetch_object();
                        $data['project']['show_value'] = $res->folder_name . ', ' . $res->subject . ' (' . $res->folders_system_id . ')';
                        //$db2->show_array($data['project']);
                    }
                }
            }
            // Folder : project
            elseif ($arr[$i] == 'project' && $line->folders_system_id <> '' && isset ($line->folders_system_id) && empty ($data['market']['show_value'])) {
                $db2->query('select folder_name, subject, folders_system_id, parent_id from ' . $_SESSION['tablename']['fold_folders'] . " where status <> 'DEL' and folders_system_id = " . $line->folders_system_id . " and folder_level = 1");

                if ($db2->nb_result() > 0) {
                    $res = $db2->fetch_object();
                    $data['project']['show_value'] = $res->folder_name . ', ' . $res->subject . ' (' . $res->folders_system_id . ')';
                }
            }
        } else // 'mimimal' mode
            {
            // Normal cases
            $data[$arr[$i]] = $line-> $arr[$i];
            if ($arr[$i] == 'contact_id') {
                $data['type_contact'] = 'external';
                if (!empty ($line-> $arr[$i])) {
                    // $db2->query('select is_corporate_person, lastname, firstname, society from ' 
                    //     . $_SESSION['tablename']['contacts'] . " where enabled = 'Y' and contact_id = " . $line-> $arr[$i] . "");
                    // $res = $db2->fetch_object();
                    // if ($res->is_corporate_person == 'Y') {
                    //     $data['contact_id'] = $res->society . ' (' . $line-> $arr[$i] . ')';
                    // } else {
                    //     if (!empty ($res->society)) {
                    //         $data['contact_id'] = $res->society . ', ' . $res->lastname . ' ' . $res->firstname . ' (' . $line-> $arr[$i] . ')';
                    //     } else {
                    //         $data['contact_id'] = $res->lastname . ', ' . $res->firstname . ' (' . $line-> $arr[$i] . ')';
                    //     }
                    // }
                    $db2->query("select address_id from business_coll_ext where res_id = ".$res_id);
                    $resAddress = $db2->fetch_object();
                    $addressId = $resAddress->address_id;
                    $db2->query('select is_corporate_person, is_private, contact_lastname, contact_firstname, society, society_short, address_num, address_street, address_town, lastname, firstname from view_contacts where contact_id = ' . $line-> $arr[$i] . ' and ca_id = ' . $addressId);
                    $res = $db2->fetch_object();
                    if ($res->is_corporate_person == 'Y') {
                        $data['contact_id'] = $res->society . ' ' ;
                        if (!empty ($res->society_short)) {
                            $data['contact_id'] .= '('.$res->society_short.') ';
                        }
                        if (!empty($res->lastname) || !empty($res->firstname)) {
                            $data['contact_id'] .= '- ' . $res->lastname . ' ' . $res->firstname . ' ';
                        }
                    } else {
                        $data['contact_id'] = $res->contact_lastname . ' ' . $res->contact_firstname . ' ';
                        if (!empty ($res->society)) {
                            $data['contact_id'] .= '(' .$res->society . ') ';
                        }                        
                    }
                    if ($res->is_private == 'Y') {
                        $data['contact_id'] .= '('._CONFIDENTIAL_ADDRESS.')';
                    } else {
                        $data['contact_id'] .= $res->address_num .' ' . $res->address_street .' ' . strtoupper($res->address_town);                         
                    }

                    $data['contactId'] = $line-> $arr[$i];
                    $data['addressId'] = $addressId;
                }
                //unset ($data[$arr[$i]]);
            } 
            elseif ($_ENV['categories'][$cat_id][$arr[$i]]['type_field'] == 'date') {
                $data[$arr[$i]] = $db->format_date_db($line-> $arr[$i], false);
            }
            elseif ($_ENV['categories'][$cat_id]['other_cases'][$arr[$i]]['type_field'] == 'date') {
                $data[$arr[$i]] = $db->format_date_db($line-> $arr[$i], false);
            }
            elseif ($_ENV['categories'][$cat_id][$arr[$i]]['type_field'] == 'string') {
                $data[$arr[$i]] = $db->show_string($line-> $arr[$i], true);
            }
            // special cases :
            // Folder : market
            elseif ($arr[$i] == 'market' && isset ($line->folders_system_id) && !empty ($line->folders_system_id)) {
                $db2->query('select folder_name, subject, folders_system_id, parent_id, folder_level from ' . $_SESSION['tablename']['fold_folders'] . " where status <> 'DEL' and folders_system_id = " . $line->folders_system_id . " ");
                if ($db2->nb_result() > 0) {
                    $res = $db2->fetch_object();
                    if ($res->folder_level == 2) {
                        $data['market'] = $res->folder_name . ', ' . $res->subject . ' (' . $res->folders_system_id . ')';
                        $folder_id = $res->parent_id;
                        if (isset ($folder_id) && !empty ($folder_id)) {
                            $db2->query('select folder_name, subject, folders_system_id from ' . $_SESSION['tablename']['fold_folders'] . " where status <> 'DEL' and folders_system_id = " . $folder_id . " and folder_level = 1");
                            $res = $db2->fetch_object();
                            $data['project'] = $res->folder_name . ', ' . $res->subject . ' (' . $res->folders_system_id . ')';
                        }
                    } else {
                        $data['project'] = $res->folder_name . ', ' . $res->subject . ' (' . $res->folders_system_id . ')';
                    }
                }

            }
            // Folder : project
            elseif ($arr[$i] == 'project' && $line->folders_system_id <> '' && isset ($line->folders_system_id) && empty ($data['market'])) {
                $db2->query('select folder_name, subject, folders_system_id, parent_id from ' . $_SESSION['tablename']['fold_folders'] . " where status <> 'DEL' and folders_system_id = " . $line->folders_system_id . " and folder_level = 1");
                //$db2->show();
                $res = $db2->fetch_object();
                $data['project'] = $res->folder_name . ', ' . $res->subject . ' (' . $res->folders_system_id . ')';
            }
        }
    }

    if ($mode == 'minimal' && isset ($data['process_limit_date']) && !empty ($data['process_limit_date'])) {
        $data['process_limit_date_use'] = true;
    }
    return $data;
}

/**
 * Returns the icon for the given category or the default icon
 *
 * @param $cat_id string Category identifiert
 * @return string Icon Url
 **/
function get_img_cat($cat_id) {
    $default = $_SESSION['config']['businessappurl'] . 'static.php?filename=picto_delete.gif';
    if (empty ($cat_id)) {

        return $default;
    } else {
        if (!empty ($_ENV['categories'][$cat_id]['img_cat'])) {
            return $_ENV['categories'][$cat_id]['img_cat'];
        } else {
            return $default;
        }
    }
}

?>