Projet

Général

Profil

Anomalie #8046 » change_doctype.php

Henri QUENEAU, 09/07/2018 12:33

 
<?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 Script called by an ajax object to process the document type
* change during indexing (index_mlb.php), process limit date calcul and
* possible services from apps or module
*
* @file change_doctype.php
* @author Claire Figueras <dev@maarch.org>
* @date $date$
* @version $Revision$
* @ingroup indexing_searching_mlb
*/
require_once('core/class/class_security.php');
require_once('apps/' . $_SESSION['config']['app_id'] . '/class/class_types.php');

$db = new Database();
$core = new core_tools();
$core->load_lang();
$type = new types();

if (!isset($_REQUEST['type_id']) || empty($_REQUEST['type_id'])) {
$_SESSION['error'] = _DOCTYPE.' '._IS_EMPTY;
echo "{status : 1, error_txt : '".addslashes(functions::xssafe($_SESSION['error']))."'}";
exit();
}

if (!isset($_REQUEST['id_action']) || empty($_REQUEST['id_action'])) {
$_SESSION['error'] = _ACTION_ID.' '._IS_EMPTY;
echo "{status : 1, error_txt : '".addslashes(functions::xssafe($_SESSION['error']))."'}";
exit();
}
$id_action = $_REQUEST['id_action'];

if (
isset($_REQUEST['res_id'])
&& !empty($_REQUEST['res_id'])
&& isset($_REQUEST['coll_id'])
&& !empty($_REQUEST['coll_id'])
) {
$res_id = $_REQUEST['res_id'];
$coll_id = $_REQUEST['coll_id'];
}
if ($coll_id == '') {
$coll_id = $_REQUEST['coll_id'];
}
if ($coll_id == '') {
$coll_id = 'letterbox_coll';
}
if ($res_id == '') {
$res_id = $_REQUEST['res_id'];
}
if (isset($_REQUEST['admission_date'])
&& !empty($_REQUEST['admission_date'])
) {
$admissionDate = $_REQUEST['admission_date'];
}

$priorityId = $_SESSION['process_mode_priority'][$_SESSION['process_mode']];
$_SESSION['process_mode'] = NULL;
$priorityWDay = $_SESSION['mail_priorities_wdays'][$priorityId] == 'true' ? 'workingDay' : 'calendar';
foreach ($_SESSION['mail_priorities_id'] as $key => $value) {
if ($value == $priorityId) {
$fakeId = $key;
}
}
if ($_SESSION['mail_priorities_attribute'][$fakeId] <> 'false') {
$priorityDelay = $_SESSION['mail_priorities_attribute'][$fakeId];
}

// Process limit date calcul
//Bug fix if delay process is disabled in services
if ($core->service_is_enabled('param_mlb_doctypes')) {
$stmt = $db->query("SELECT process_delay FROM "
. $_SESSION['tablename']['mlb_doctype_ext'] . " WHERE type_id = ?",
array($_REQUEST['type_id'])
);

$res = $stmt->fetchObject();
$delay = $res->process_delay;
}
$mandatory_indexes = $type->get_mandatory_indexes($_REQUEST['type_id'], $coll_id);
$indexes = $type->get_indexes($_REQUEST['type_id'], $coll_id);

if(is_array($indexes)){
foreach ($indexes as $key => $value) {
if(filter_var($value['only_detail'], FILTER_VALIDATE_BOOLEAN)){
unset($indexes[$key]);
}
}
}

$opt_indexes = '';
$display_value = 'table-row';
$opt_indexes = '';
if(count($indexes) > 0)
{
if((isset($res_id) && isset($coll_id)) && (!empty($res_id) && !empty($coll_id)))
{
$sec = new security();
$table = $sec->retrieve_table_from_coll($coll_id);
if(!empty($table))
{
$fields = 'res_id ';
foreach(array_keys($indexes) as $key)
{
$fields .= ', '.$key;
}
$stmt = $db->query("SELECT " . $fields . " FROM " . $table
. " WHERE res_id = ?", array($res_id)
);
$values_fields = $stmt->fetchObject();
}
}
$opt_indexes .= '<hr />';

$opt_indexes .= '<h4 onclick="new Effect.toggle(\'doctype_fields\', \'blind\', {delay:0.2});'
. 'whatIsTheDivStatus(\'doctype_fields\', \'divStatus_doctype_fields\');" '
. 'class="categorie" style="width:90%;" onmouseover="this.style.cursor=\'pointer\';">';
$opt_indexes .= ' <span id="divStatus_doctype_fields" style="color:#1C99C5;"><i class="fa fa-minus-square-o"></i></span>&nbsp;'
. _DOCTYPE_INDEXES;
$opt_indexes .= '</h4>';

$opt_indexes .= '<div id="doctype_fields" style="display:inline">';
$opt_indexes .= '<div>';
$opt_indexes .= '<table width="100%" align="center" border="0">';
foreach (array_keys($indexes) as $key) {
$mandatory = false;
if (in_array($key, $mandatory_indexes)) {
$mandatory = true;
}
$opt_indexes .= '<tr >';
$opt_indexes.='<td><label for="' . functions::xssafe($key) . '" class="form_title" >'
. $indexes[$key]['label'].'</label></td>';
$opt_indexes .='<td>&nbsp;</td>';
$opt_indexes .='<td class="indexing_field">';
if ($indexes[$key]['type_field'] == 'input') {
if ($indexes[$key]['type'] == 'date') {
$opt_indexes .='<input name="' . functions::xssafe($key) . '" type="text" id="'
. $key . '" value="';
if (isset($values_fields->{$key})) {
$opt_indexes .= functions::format_date_db(
functions::xssafe($values_fields->{$key}), true
);
} elseif ($indexes[$key]['default_value'] <> false) {
$opt_indexes .= functions::format_date_db(
functions::xssafe($indexes[$key]['default_value']), true
);
}
$opt_indexes .= '" onclick="clear_error(\'frm_error_'
. $id_action . '\');showCalender(this);"/>';
} else {
$opt_indexes .= '<textarea name="'.functions::xssafe($key).'" type="text" id="'
. $key . '" value="';
if (isset($values_fields->{$key})) {
$valueCustom = null;
$valueCustom = $values_fields->{$key};
$opt_indexes .= functions::show_string(
functions::xssafe($values_fields->{$key}), true
);
} else if ($indexes[$key]['default_value'] <> false) {
$opt_indexes .= functions::show_string(
functions::xssafe($indexes[$key]['default_value']), true
);
}
$opt_indexes .= '" onclick="clear_error(\'frm_error_'
. $id_action . '\');">'.$valueCustom.'</textarea>';
}
} else {
$opt_indexes .= '<select name="'.functions::xssafe($key).'" id="'.functions::xssafe($key).'" >';
$opt_indexes .= '<option value="">'._CHOOSE.'...</option>';
for ($i=0; $i<count($indexes[$key]['values']);$i++) {
$opt_indexes .= '<option value="'
. functions::xssafe($indexes[$key]['values'][$i]['id']) . '"';
if ($indexes[$key]['values'][$i]['id']
== $values_fields->{$key}) {
$opt_indexes .= 'selected="selected"';
} elseif (
$indexes[$key]['default_value'] <> false
&& $indexes[$key]['values'][$i]['id']
== $indexes[$key]['default_value']
) {
$opt_indexes .= 'selected="selected"';
}
$opt_indexes .= ' >' . functions::xssafe($indexes[$key]['values'][$i]['label'])
. '</option>';
}
$opt_indexes .= '</select>';
}
$opt_indexes .='</td>';
if ($mandatory) {
$opt_indexes .='<td><span class="red_asterisk" id="'
. $key . '_mandatory">';
//$opt_indexes .= 'inline';
$opt_indexes .= '*</span>&nbsp;</td>';
} else {
$opt_indexes .='<td><span style="visibility:hidden;" id="'
. $key . '_mandatory">';
$opt_indexes .= '*</span>&nbsp;</td>';
}
//$opt_indexes .= ';">*</span>&nbsp;</td>';
$opt_indexes .= '</tr>';
}
$opt_indexes .= '</table>';
$opt_indexes .= '</div></div>';
}

$services = '[';
$_SESSION['indexing_services'] = array();
$_SESSION['indexing_type_id'] = $_REQUEST['type_id'];
$_SESSION['category_id_session'] = $_SESSION['indexing_type_id'];

// Module and apps services
$core->execute_modules_services(
$_SESSION['modules_services'], 'change_doctype.php', 'include'
);
$core->execute_app_services(
$_SESSION['app_services'], 'change_doctype.php', 'include'
);
for ($i=0;$i< count($_SESSION['indexing_services']);$i++) {
$services .= "{ script : '" . $_SESSION['indexing_services'][$i]['script']
. "', function_to_execute : '"
. functions::xssafe($_SESSION['indexing_services'][$i]['function_to_execute'])
. "', arguments : '[";
for ($j=0;$j<count($_SESSION['indexing_services'][$i]['arguments']);$j++) {
$services .= " { id : \'"
. functions::xssafe($_SESSION['indexing_services'][$i]['arguments'][$j]['id'])
. "\', value : \'"
. addslashes(
$_SESSION['indexing_services'][$i]['arguments'][$j]['value']
)
. "\' }, ";
}
$services = preg_replace('/, $/', '', $services);
$services .= "]' }, ";
}
$services = preg_replace('/, $/', '', $services);
$services .= ']';
unset($_SESSION['indexing_type_id']);
unset($_SESSION['indexing_services']);

if ($priorityDelay <> '') {
$delay = $priorityDelay;
}

if (isset($delay) && $delay > 0) {
require_once('core/class/class_alert_engine.php');
$alert_engine = new alert_engine();
if (isset($admissionDate) && !empty($admissionDate)) {
$convertedDate = $alert_engine->dateFR2Time(str_replace("-", "/", $admissionDate));
$date = $alert_engine->WhenOpenDay($convertedDate, $delay, false, $priorityWDay);
//$date = $alert_engine->date_max_treatment($delay, false);
} else {
$date = $alert_engine->date_max_treatment($delay, false);
}
$process_date = functions::dateformat($date, '-');
$tmpProcessDate = explode(" ", $process_date);
$date = $tmpProcessDate[0];
echo "{status : 0, process_date : '" . trim(functions::xssafe($date))
. "', opt_indexes : '" . addslashes($opt_indexes) . "', services : "
. $services . "}";
exit();
} else {
echo "{status : 1, opt_indexes : '" . addslashes($opt_indexes)
. "', services : " . $services . "}";
exit();
}
    (1-1/1)