trunk/obj/task.class.php

<?php
//$Id$
//gen openMairie le 14/04/2020 14:11

require_once "../gen/obj/task.class.php";

class task extends task_gen {

    const STATUS_DRAFT = 'draft';
    const STATUS_NEW = 'new';
    const STATUS_PENDING = 'pending';
    const STATUS_DONE = 'done';
    const STATUS_ERROR = 'error';
    const STATUS_DEBUG = 'debug';
    const STATUS_ARCHIVED = 'archived';

    /**
     * Définition des actions disponibles sur la classe.
     *
     * @return void
     */
    public function init_class_actions() {
        parent::init_class_actions();
        //
        $this->class_actions[998] = array(
            "identifier" => "json_data",
            "view" => "view_json_data",
            "permission_suffix" => "consulter",
        );
        $this->class_actions[997] = array(
            "identifier" => "json_data",
            "view" => "post_update_task",
            "permission_suffix" => "modifier",
        );
        $this->class_actions[996] = array(
            "identifier" => "json_data",
            "view" => "post_add_task",
            "permission_suffix" => "ajouter",
        );
    }

    public function setvalF($val = array()) {

        // les guillets doubles sont remplacés automatiquement par des simples
        // dans core/om_formulaire.clasS.php::recupererPostvar()
        // voir le ticket https://dev.atreal.fr/projets/openmairie/tracker/209
        // ceci est un hack sale temporaire en attendant résolution du ticket
        foreach(array('json_payload', 'timestamp_log') as $key) {
            if (isset($val[$key]) && ! empty($val[$key]) &&
                    isset($_POST[$key]) && ! empty($_POST[$key])) {
                $submited_payload = $_POST[$key];
                if (! empty($submited_payload)) {
                    $new_payload = str_replace("'", '"', $val[$key]);
                    if ($new_payload == $submited_payload ||
                            strpos($submited_payload, '"') === false) {
                        $val[$key] = $new_payload;
                    }
                    else {
                        $error_msg = sprintf(
                            __("La convertion des guillemets de la payload JSON '%s' ".
                                "n'est pas idempotente (courante: %s, postée: %s, convertie: %s)"),
                            $key, var_export($val[$key], true), var_export($submited_payload, true),
                            var_export($new_payload, true));
                        $this->correct = false;
                        $this->addToMessage($error_msg);
                        $this->addToLog(__METHOD__."() erreur : $error_msg", DEBUG_MODE);
                        return false;
                    }
                }
            }
        }

        parent::setvalF($val);

        // récupération de l'ID de l'objet existant
        $id = property_exists($this, 'id') ? $this->id : null;
        if(isset($val[$this->clePrimaire])) {
            $id = $val[$this->clePrimaire];
        } elseif(isset($this->valF[$this->clePrimaire])) {
            $id = $this->valF[$this->clePrimaire];
        }

        // MODE MODIFIER
        if (! empty($id)) {

            // si aucune payload n'est fourni (devrait toujours être le cas)
            if (! isset($val['json_payload']) || empty($val['json_payload'])) {

                // récupère l'objet existant
                $existing = $this->f->findObjectById(get_class($this), $id);
                if (! empty($existing)) {

                    // récupère la payload de l'objet
                    $val['json_payload'] = $existing->getVal('json_payload');
                    $this->valF['json_payload'] = $existing->getVal('json_payload');
                    $this->f->addToLog(__METHOD__."() récupère la payload de la tâche existante ".
                        "'$id': ".$existing->getVal('json_payload'), EXTRA_VERBOSE_MODE);
                }
            }
        }
    }

    /**
     *
     * @return array
     */
    function get_var_sql_forminc__champs() {
        return array(
            "task",
            "type",
            "state",
            "object_id",
            "dossier",
            "stream",
            "json_payload",
            "timestamp_log",
        );
    }

    function setType(&$form, $maj) {
        parent::setType($form, $maj);

        // Récupération du mode de l'action
        $crud = $this->get_action_crud($maj);

        // MODE CREER
        if ($maj == 0 || $crud == 'create') {
            $form->setType("state", "select");
            $form->setType("stream", "select");
            $form->setType("json_payload", "textarea");
        }
        // MDOE MODIFIER
        if ($maj == 1 || $crud == 'update') {
            $form->setType("state", "select");
            $form->setType("stream", "select");
            $form->setType("json_payload", "jsonprettyprint");
        }
        // MODE CONSULTER
        if ($maj == 3 || $crud == 'read') {
            $form->setType('dossier', 'link');
            $form->setType('json_payload', 'jsonprettyprint');
        }

    }

    /**
     *
     */
    function setSelect(&$form, $maj, &$dnu1 = null, $dnu2 = null) {
        if($maj < 2) {

            $contenu = array();
            foreach(array('DRAFT', 'NEW', 'PENDING', 'DONE', 'ERROR', 'DEBUG') as $key) {
                $const_name = 'STATUS_'.$key;
                $const_value = constant("self::$const_name");
                $contenu[0][] = $const_value;
                $contenu[1][] = __($const_value);
            }

            $form->setSelect("state", $contenu);

            $contenu_stream =array();
            $contenu_stream[0][0]="input";
            $contenu_stream[1][0]=_('input');
            $contenu_stream[0][1]="output";
            $contenu_stream[1][1]=_('output');
            $form->setSelect("stream", $contenu_stream);

        }

        if ($maj == 3) {
            if ($this->getVal('stream') == 'output') {
                $inst_dossier = $this->f->get_inst__om_dbform(array(
                    "obj" => "dossier",
                    "idx" => $form->val['dossier'],
                ));

                if($form->val['type'] == "creation_DA"){
                    $obj_link = 'dossier_autorisation';
                } else {
                    $obj_link = 'dossier_instruction';
                }

                $params = array();
                $params['obj'] = $obj_link;
                $params['libelle'] = $inst_dossier->getVal('dossier');
                $params['title'] = "Consulter le dossier";
                $params['idx'] = $form->val['dossier'];
                $form->setSelect("dossier", $params);
            }
        }
    }

    /**
     * SETTER_FORM - setVal (setVal).
     *
     * @return void
     */
    function setVal(&$form, $maj, $validation, &$dnu1 = null, $dnu2 = null) {
        // parent::setVal($form, $maj, $validation);
        //
        if ($this->getVal('stream') == "output") {
            $form->setVal('json_payload', $this->view_form_json(true));
        } else {
            $form->setVal('json_payload', htmlentities($this->getVal('json_payload')));
        }
    }

    function setLib(&$form, $maj) {
        parent::setLib($form, $maj);

        // Récupération du mode de l'action
        $crud = $this->get_action_crud($maj);

        // MODE different de CREER
        if ($maj != 0 || $crud != 'create') {
            $form->setLib('json_payload', '');
        }
    }

    public function verifier($val = array(), &$dnu1 = null, $dnu2 = null) {
        $ret = parent::verifier($val, $dnu1, $dnu2);

        // une tâche entrante doit avoir un type et une payload non-vide
        if (isset($this->valF['stream']) === false || $this->valF['stream'] == 'input') {
            if (isset($this->valF['type']) === false) {
                $this->correct = false;
                $this->addToMessage(sprintf(
                    __("Le champ %s est obligatoire pour une tâche entrante."),
                    sprintf('<span class="bold">%s</span>', $this->getLibFromField('type'))
                ));
                $this->addToLog(__METHOD__.'(): erreur: '.$this->msg, DEBUG_MODE);
            }
            if (isset($this->valF['json_payload']) === false) {
                $this->correct = false;
                $this->addToMessage(sprintf(
                    __("Le champ %s est obligatoire pour une tâche entrante."),
                    sprintf('<span class="bold">%s</span>', $this->getLibFromField('json_payload'))
                ));
                $this->addToLog(__METHOD__.'(): erreur: '.$this->msg, DEBUG_MODE);
            }
        }

        // les JSONs doivent être décodables
        foreach(array('json_payload', 'timestamp_log') as $key) {
            if (isset($this->valF[$key]) && ! empty($this->valF[$key]) && (
                    is_array(json_decode($this->valF[$key], true)) === false
                    || json_last_error() !== JSON_ERROR_NONE)) {
                $this->correct = false;
                $champ_text = sprintf('<span class="bold">%s</span>', $this->getLibFromField($key));
                $this->addToMessage(sprintf(
                    __("Le champ %s doit être dans un format JSON valide (erreur: %s).".
                    "<p>%s valF:</br><pre>%s</pre></p>".
                    "<p>%s val:</br><pre>%s</pre></p>".
                    "<p>%s POST:</br><pre>%s</pre></p>".
                    "<p>%s submitted POST value:</br><pre>%s</pre></p>"),
                    $champ_text,
                    json_last_error() !== JSON_ERROR_NONE ? json_last_error_msg() : __('invalide'),
                    $champ_text,
                    $this->valF[$key],
                    $champ_text,
                    $val[$key],
                    $champ_text,
                    isset($_POST[$key]) ? $_POST[$key] : '',
                    $champ_text,
                    $this->f->get_submitted_post_value($key)
                ));
                $this->addToLog(__METHOD__.'(): erreur JSON: '.$this->msg, DEBUG_MODE);
            }
        }

        // une tâche entrante doit avoir une payload avec les clés requises
        if ($this->correct && (isset($this->valF['stream']) === false ||
                               $this->valF['stream'] == 'input')) {

            // décode la payload JSON
            $json_payload = json_decode($this->valF['json_payload'], true);

            // défini une liste de chemin de clés requises
            $paths = array(
                'external_uids/dossier'
            );

            // tâche de type création de DI/DA
            if (isset($this->valF['type']) !== false && $this->valF['type'] == 'create_DI_for_consultation') {

                $paths = array_merge($paths, array(
                    'dossier/dossier',
                    'dossier/dossier_autorisation_type_detaille_code',
                    'dossier/date_demande',
                    'dossier/depot_electronique',
                ));

                // si l'option commune est activée (mode MC)
                if ($this->f->is_option_dossier_commune_enabled()) {
                    $paths[] = 'dossier/insee';
                }

                // présence d'un moyen d'identifier la collectivité/le service
                if (! isset($json_payload['dossier']['acteur']) &&
                        ! isset($json_payload['dossier']['om_collectivite'])) {
                    $this->correct = false;
                    $this->addToMessage(sprintf(
                        __("L'une des clés %s ou %s est obligatoire dans le contenu du champ %s pour une tâche entrante."),
                        sprintf('<span class="bold">%s</span>', 'dossier/acteur'),
                        sprintf('<span class="bold">%s</span>', 'dossier/om_collectivite'),
                        sprintf('<span class="bold">%s</span>', $this->getLibFromField('json_payload'))
                    ));
                    $this->addToLog(__METHOD__.'(): erreur: '.$this->msg, DEBUG_MODE);
                }
            }

            // pas d'erreur déjà trouvée
            if($this->correct) {

                // pour chaque chemin
                foreach($paths as $path) {

                    // décompose le chemin
                    $tokens = explode('/', $path);
                    $cur_depth = $json_payload;

                    // descend au et à mesure dans l'arborescence du chemin
                    foreach($tokens as $token) {

                        // en vérifiant que chaque élément du chemin est défini et non-nul
                        if (isset($cur_depth[$token]) === false) {

                            // sinon on produit une erreur
                            $this->correct = false;
                            $this->addToMessage(sprintf(
                                __("La clé %s est obligatoire dans le contenu du champ %s pour une tâche entrante."),
                                sprintf('<span class="bold">%s</span>', $path),
                                sprintf('<span class="bold">%s</span>', $this->getLibFromField('json_payload'))
                            ));
                            $this->addToLog(__METHOD__.'(): erreur: '.$this->msg, DEBUG_MODE);
                            break 2;
                        }
                        $cur_depth = $cur_depth[$token];
                    }
                }
            }
        }

        return $ret && $this->correct;
    }

    protected function task_exists(string $type, string $object_id) {
        $query = sprintf('
            SELECT task
            FROM %1$stask
            WHERE state != \'%2$s\'
            AND type = \'%3$s\'
            AND object_id = \'%4$s\'
            ',
            DB_PREFIXE,
            self::STATUS_DONE,
            $type,
            $object_id
        );
        $res = $this->f->get_one_result_from_db_query($query);
        if ($res['result'] !== null && $res['result'] !== '') {
            return $res['result'];
        }
        return false;
    }

    /**
     * TRIGGER - triggerajouter.
     *
     * @param string $id
     * @param null &$dnu1 @deprecated  Ne pas utiliser.
     * @param array $val Tableau des valeurs brutes.
     * @param null $dnu2 @deprecated  Ne pas utiliser.
     *
     * @return boolean
     */
    function triggerajouter($id, &$dnu1 = null, $val = array(), $dnu2 = null) {

        // tâche entrante
        if (isset($this->valF['stream']) === false || $this->valF['stream'] == 'input') {

            // décode la paylod JSON pour extraire les données métiers à ajouter
            // en tant que métadonnées de la tâche
            $json_payload = json_decode($this->valF['json_payload'], true);

            // si la tâche possède déjà une clé dossier
            if (isset($json_payload['dossier']['dossier']) &&
                    ! empty($json_payload['dossier']['dossier'])) {
                $this->valF["dossier"] = $json_payload['dossier']['dossier'];
            }

            /**
             * Puisque le dossier n'a potentiellement pas encore été créé
             * alors il faut ne faut chercher à récupérer le numéro de dossier openADS
             * à partir de l'external_uids (en passant par la table de liens)
            // sinon si la tâche possède une clé external_uids/dossier
            elseif(isset($json_payload['external_uids']['dossier']) &&
                    ! empty($json_payload['external_uids']['dossier'])) {

                // instancie l'objet lien_id_interne_uid_externe
                $inst_lien = $this->f->get_inst__om_dbform(array(
                    "obj" => "lien_id_interne_uid_externe",
                    "idx" => ']',
                ));
                if(! $dossier = $inst_lien->get_id_dossier_from_external_uid(
                        $json_payload['external_uids']['dossier'])){
                    $error_msg = sprintf(
                        __("Aucune correspondance de dossier pour l'external_uid.dossier '%s'."),
                        $json_payload['external_uids']['dossier']);
                    $this->addToLog(__METHOD__."() : erreur : $error_msg", DEBUG_MODE);
                    $this->addToMessage($error_msg);
                    $this->correct = false;
                    return false;
                }
                $this->valF["dossier"] = $dossier;
            }*/
        }
    }

    /**
     * TREATMENT - add_task
     * Ajoute un enregistrement.
     *
     * @param  array $params Tableau des paramètres
     * @return boolean
     */
    public function add_task($params = array()) {
        $this->begin_treatment(__METHOD__);
        $timestamp_log = json_encode(array(
            'creation_date' => date('Y-m-d H:i:s'),
        ));

        // Si la tâche est de type ajout_piece et de stream input alors on ajoute le fichier
        // et on ajoute l'uid dans le champ json_payload avant l'ajout de la tâche
        if (isset($params['val']['type'])
            && $params['val']['type'] == "add_piece"
            && isset($params['val']['stream'])
            && $params['val']['stream'] == "input" ) {
            //
            $json_payload = json_decode($params['val']['json_payload'], true);
            $document_numerise = $json_payload['document_numerise'];
            $file_content = base64_decode($document_numerise["file_content"]);
            if ($file_content === false){
                $this->addToMessage(__("Le contenu du fichier lié à la tâche n'a pas pu etre recupere."));
                return $this->end_treatment(__METHOD__, false);
            }
            $metadata = array(
                "filename" => $document_numerise['nom_fichier'],
                "size" => strlen($file_content),
                "mimetype" => $document_numerise['file_content_type'],
                "date_creation" => $document_numerise['date_creation'],
            );
            $uid_fichier = $this->f->storage->create($file_content, $metadata, "from_content");
            if ($uid_fichier === OP_FAILURE) {
                $this->addToMessage(__("Erreur lors de la creation du fichier lié à la tâche."));
                return $this->end_treatment(__METHOD__, false);
            }
            $json_payload["document_numerise"]["uid"] = $uid_fichier;
            // Le fichier a été ajouté nous n'avons plus besoin du champ file_content dans la payload
            unset($json_payload["document_numerise"]["file_content"]);
            $params['val']['json_payload'] = json_encode($json_payload, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
        }

        // Mise à jour du DI
        $valF = array(
            'task' => '',
            'type' => $params['val']['type'],
            'timestamp_log' => $timestamp_log,
            'state' => isset($params['val']['state']) === true ? $params['val']['state'] : self::STATUS_NEW,
            'object_id' => isset($params['val']['object_id']) ? $params['val']['object_id'] : '',
            'dossier' => isset($params['val']['dossier']) ? $params['val']['dossier'] : '',
            'stream' => isset($params['val']['stream']) === true ? $params['val']['stream'] : 'output',
            'json_payload' => isset($params['val']['json_payload']) === true ? $params['val']['json_payload'] : '{}',
        );

        // tâche sortante
        if($valF["stream"] == "output"){

            // TODO expliquer ce code
            $task_exists = $this->task_exists($valF['type'], $valF['object_id']);
            if ($valF['type'] === 'modification_DI' && $task_exists === false) {
                $task_exists = $this->task_exists('creation_DI', $valF['object_id']);
            }
            if ($task_exists !== false) {
                $inst_task = $this->f->get_inst__om_dbform(array(
                    "obj" => "task",
                    "idx" => $task_exists,
                ));
                $update_state = $inst_task->getVal('state');
                if (isset($params['update_val']['state']) === true) {
                    $update_state = $params['update_val']['state'];
                }
                $update_params = array(
                    'val' => array(
                        'state' => $update_state,
                    ),
                );
                return $inst_task->update_task($update_params);
            }
        }

        $add = $this->ajouter($valF);
        $this->addToLog(__METHOD__."(): retour de l'ajout de tâche: ".var_export($add, true), VERBOSE_MODE);
        if ($add === false) {
            $this->addToLog(__METHOD__."(): ".$this->msg, DEBUG_MODE);
            return $this->end_treatment(__METHOD__, false);
        }
        return $this->end_treatment(__METHOD__, true);
    }

    /**
     * TREATMENT - update_task
     * Met à jour l'enregistrement instancié.
     *
     * @param  array  $params Tableau des paramètres
     * @return boolean
     */
    public function update_task($params = array()) {
        $this->begin_treatment(__METHOD__);
        $timestamp_log = $this->get_timestamp_log();
        if ($timestamp_log === false) {
            $this->addToLog(__METHOD__."(): erreur timestamp log", DEBUG_MODE);
            return $this->end_treatment(__METHOD__, false);
        }
        array_push($timestamp_log, array(
            'modification_date' => date('Y-m-d H:i:s'),
            'state' => $params['val']['state'],
            'prev_state' => $this->getVal('state'),
        ));
        $timestamp_log = json_encode($timestamp_log);
        $valF = array(
            'task' => $this->getVal($this->clePrimaire),
            'type' => $this->getVal('type'),
            'timestamp_log' => $timestamp_log,
            'state' => $params['val']['state'],
            'object_id' => $this->getVal('object_id'),
            'stream' => $this->getVal('stream'),
            'dossier' => $this->getVal('dossier'),
            'json_payload' => $this->getVal('json_payload'),
        );
        $update = $this->modifier($valF);
        if ($update === false) {
            $this->addToLog($this->msg, DEBUG_MODE);
            return $this->end_treatment(__METHOD__, false);
        }
        return $this->end_treatment(__METHOD__, true);
    }

    /**
     * Récupère le journal d'horodatage dans le champ timestamp_log de
     * l'enregistrement instancié.
     *
     * @param  array  $params Tableau des paramètres
     * @return array sinon false en cas d'erreur
     */
    protected function get_timestamp_log($params = array()) {
        $val = $this->getVal('timestamp_log');
        if ($val === '') {
            $val = json_encode(array());
        }
        if($this->isJson($val) === false) {
            return false;
        }
        return json_decode($val, true);
    }

    /**
     * VIEW - view_json_data
     * Affiche l'enregistrement dans le format JSON.
     *
     * @return void
     */
    public function view_json_data() {
        $this->checkAccessibility();
        $this->f->disableLog();
        if ($this->getParameter('idx') !== ']'
            && $this->getParameter('idx') !== '0') {
            //
            $this->view_form_json();
        }
        else {
            $this->view_tab_json();
        }
    }

    protected function view_tab_json() {
        $where = '';
        if ($this->f->get_submitted_get_value('state') !== null
            && $this->f->get_submitted_get_value('state') !== '') {
            //
            $where = sprintf(' WHERE state = \'%s\' ', $this->f->get_submitted_get_value('state'));
        }
        $query = sprintf('
            SELECT
                *
            FROM %1$stask
            %2$s
            ORDER BY task ASC
            ',
            DB_PREFIXE,
            $where
        );
        $res = $this->f->get_all_results_from_db_query($query, true);
        if ($res['code'] === 'KO') {
            return false;
        }
        $list_tasks = array();
        foreach ($res['result'] as $task) {
            $task['timestamp_log'] = json_decode($task['timestamp_log'], true);
            $task['dossier'] = $task['object_id'];
            if ($this->get_lien_objet_by_type($task['type']) === 'document_numerise') {
                $val_dn = $this->get_document_numerise_data($task['object_id']);
                $task['dossier'] = $val_dn['dossier'];
            }
            $list_tasks[$task['task']] = $task;
        }
        printf(json_encode($list_tasks));
    }

    protected function get_dossier_data(string $dossier) {
        $val_di = array();
        $inst_di = $this->f->get_inst__om_dbform(array(
            "obj" => "dossier",
            "idx" => $dossier,
        ));
        $val_di = $inst_di->get_json_data();
        if ($val_di['dossier_instruction_type_code'] === 'T') {
            $val_di['date_decision_transfert'] = $val_di['date_decision'];
        }
        unset($val_di['initial_dt']);
        unset($val_di['log_instructions']);
        return $val_di;
    }

    protected function get_dossier_autorisation_data(string $da) {
        $val_da = array();
        $inst_da = $this->f->get_inst__om_dbform(array(
            "obj" => "dossier_autorisation",
            "idx" => $da,
        ));
        $val_da = $inst_da->get_json_data();
        return $val_da;
    }

    protected function get_donnees_techniques_data(string $fk_idx, string $fk_field) {
        $val_dt = array();
        $inst_dt = $this->f->get_inst__by_other_idx(array(
            "obj" => "donnees_techniques",
            "fk_field" => $fk_field,
            "fk_idx" => $fk_idx,
        ));
        $val_dt = array(
            'donnees_techniques' => $inst_dt->getVal($inst_dt->clePrimaire),
            'cerfa' => $inst_dt->getVal('cerfa'),
        );
        $val_dt = array_merge($val_dt, $inst_dt->get_donnees_techniques_applicables());
        if (isset($val_dt['am_exist_date']) === true) {
            $val_dt['am_exist_date_num'] = '';
            if (is_numeric($val_dt['am_exist_date']) === true) {
                $val_dt['am_exist_date_num'] = $val_dt['am_exist_date'];
            }
        }
        // Correspond à la nomenclature de Plat'AU STATUT_INFO
        $val_dt['tax_statut_info'] = 'Déclaré';
        //
        if ($inst_dt->is_tab_surf_ssdest_enabled() === true) {
            $fields_tab_surf_dest = $inst_dt->get_fields_tab_surf_dest();
            foreach ($fields_tab_surf_dest as $field) {
                if (isset($val_dt[$field]) === true) {
                    unset($val_dt[$field]);
                }
            }
        } else {
            $fields_tab_surf_ssdest = $inst_dt->get_fields_tab_surf_ssdest();
            foreach ($fields_tab_surf_ssdest as $field) {
                if (isset($val_dt[$field]) === true) {
                    unset($val_dt[$field]);
                }
            }
        }
        // Correspond à la nouvelle ligne CERFA v7 dans le DENSI imposition 1.2.3
        if (isset($val_dt['tax_su_non_habit_surf2']) === true
            && isset($val_dt['tax_su_non_habit_surf3']) === true
            && (($val_dt['tax_su_non_habit_surf2'] !== null
                    && $val_dt['tax_su_non_habit_surf2'] !== '')
                || ($val_dt['tax_su_non_habit_surf3'] !== null
                    && $val_dt['tax_su_non_habit_surf3'] !== ''))) {
            //
            $val_dt['tax_su_non_habit_surf8'] = intval($val_dt['tax_su_non_habit_surf2']) + intval($val_dt['tax_su_non_habit_surf3']);
        }
        if (isset($val_dt['tax_su_non_habit_surf_stat2']) === true
            && isset($val_dt['tax_su_non_habit_surf_stat3']) === true
            && (($val_dt['tax_su_non_habit_surf_stat2'] !== null
                    && $val_dt['tax_su_non_habit_surf_stat2'] !== '')
                || ($val_dt['tax_su_non_habit_surf_stat3'] !== null
                    && $val_dt['tax_su_non_habit_surf_stat3'] !== ''))) {
            //
            $val_dt['tax_su_non_habit_surf_stat8'] = intval($val_dt['tax_su_non_habit_surf_stat2']) + intval($val_dt['tax_su_non_habit_surf_stat3']);
        }
        // Cas particulier d'un projet réduit à l'extension d'une habitation existante
        $particular_case = false;
        $fields_tab_crea_loc_hab = $inst_dt->get_fields_tab_crea_loc_hab();
        foreach ($fields_tab_crea_loc_hab as $field) {
            if (isset($val_dt[$field]) === false
                || (isset($val_dt[$field]) === true
                    && ($val_dt[$field] === null
                        || $val_dt[$field] === ''))) {
                //
                $particular_case = true;
            }
        }
        if ($particular_case === true) {
            if (isset($val_dt['tax_ext_pret']) === true
                && $val_dt['tax_ext_pret'] === 'f') {
                //
                $val_dt['tax_su_princ_surf1'] = $val_dt['tax_surf_tot_cstr'];
                $val_dt['tax_su_princ_surf_stat1'] = $val_dt['tax_surf_loc_stat'];
            }
            if (isset($val_dt['tax_ext_pret']) === true
                && $val_dt['tax_ext_pret'] === 't') {
                //
                if (isset($val_dt['tax_ext_desc']) === true) {
                    if (preg_match('/[pP].*[lL].*[aA].*[iI]/', $val_dt['tax_ext_desc']) === 1
                        || preg_match('/[lL].*[lL].*[tT].*[sS]/', $val_dt['tax_ext_desc']) === 1) {
                        //
                        $val_dt['tax_su_princ_surf2'] = $val_dt['tax_surf_tot_cstr'];
                        $val_dt['tax_su_princ_surf_stat2'] = $val_dt['tax_surf_loc_stat'];
                    }
                    // if (preg_match('/[pP].*[tT].*[zZ]/', $val_dt['tax_ext_desc']) === 1) {
                    //     $val_dt['tax_su_princ_surf4'] = $val_dt['tax_surf_tot_cstr'];
                    //     $val_dt['tax_su_princ_surf_stat4'] = $val_dt['tax_surf_loc_stat'];
                    // }
                    // if (preg_match('/[pP].*[lL].*[uU].*[sS]/', $val_dt['tax_ext_desc']) === 1
                    //     || preg_match('/[lL].*[eE].*[sS]/', $val_dt['tax_ext_desc']) === 1
                    //     || preg_match('/[pP].*[sS].*[lL].*[aA]/', $val_dt['tax_ext_desc']) === 1
                    //     || preg_match('/[pP].*[lL].*[sS]/', $val_dt['tax_ext_desc']) === 1
                    //     || preg_match('/[lL].*[lL].*[sS]/', $val_dt['tax_ext_desc']) === 1) {
                    //     //
                    //     $val_dt['tax_su_princ_surf3'] = $val_dt['tax_surf_tot_cstr'];
                    //     $val_dt['tax_su_princ_surf_stat3'] = $val_dt['tax_surf_loc_stat'];
                    // }
                }
            }
        }
        // Cas particulier de la surface taxable démolie
        if (isset($val_dt['tax_surf_tot_demo']) === true
            && isset($val_dt['tax_surf_tax_demo']) === true
            && ($val_dt['tax_surf_tot_demo'] === null
                || $val_dt['tax_surf_tot_demo'] === '')) {
            //
            $val_dt['tax_surf_tot_demo'] = $val_dt['tax_surf_tax_demo'];
        }
        return $val_dt;
    }

    protected function get_external_uid($fk_idx, string $fk_idx_2) {
        $inst_external_uid = $this->f->get_inst__by_other_idx(array(
            "obj" => "lien_id_interne_uid_externe",
            "fk_field" => 'object_id',
            "fk_idx" => $fk_idx,
            "fk_field_2" => 'object',
            "fk_idx_2" => $fk_idx_2,
        ));
        return $inst_external_uid->getVal('external_uid');
    }

    protected function get_demandeurs_data(string $dossier) {
        $val_demandeur = array();
        $inst_di = $this->f->get_inst__om_dbform(array(
            "obj" => "dossier",
            "idx" => $dossier,
        ));
        $list_demandeurs = $inst_di->get_demandeurs();
        foreach ($list_demandeurs as $demandeur) {
            $inst_demandeur = $this->f->get_inst__om_dbform(array(
                "obj" => "demandeur",
                "idx" => $demandeur['demandeur'],
            ));
            $val_demandeur[$demandeur['demandeur']] = $inst_demandeur->get_json_data();
            $val_demandeur[$demandeur['demandeur']]['petitionnaire_principal'] = $demandeur['petitionnaire_principal'];
        }
        return $val_demandeur;
    }

    protected function get_architecte_data($architecte = null) {
        $val_architecte = null;
        if ($architecte !== null
            && $architecte !== '') {
            //
            $inst_architecte = $this->f->get_inst__om_dbform(array(
                "obj" => "architecte",
                "idx" => $architecte,
            ));
            $val_architecte = $inst_architecte->get_json_data();
        }
        return $val_architecte;
    }

    protected function get_instruction_data(string $dossier, $type = 'decision') {
        $val_instruction = null;
        $instruction_with_doc = null;
        $inst_di = $this->f->get_inst__om_dbform(array(
            "obj" => "dossier",
            "idx" => $dossier,
        ));
        $idx = null;
        if ($type === 'decision') {
            $idx = $inst_di->get_last_instruction_decision();
        }
        if ($type === 'incompletude') {
            $idx = $inst_di->get_last_instruction_incompletude();
        }
        $inst_instruction = $this->f->get_inst__om_dbform(array(
            "obj" => "instruction",
            "idx" => $idx,
        ));
        if (count($inst_instruction->val) > 0) {
            $val_instruction = array();
            $instruction_data = $inst_instruction->get_json_data();
            $val_instruction = $this->sort_instruction_data($instruction_data, $val_instruction);
            if ($instruction_data['om_fichier_instruction'] !== null
                && $instruction_data['om_fichier_instruction'] !== '') {
                //
                $instruction_with_doc = $inst_instruction->getVal($inst_instruction->clePrimaire);
            }
            $inst_ev = $this->f->get_inst__om_dbform(array(
                "obj" => "evenement",
                "idx" => $inst_instruction->getVal('evenement'),
            ));
            if ($inst_ev->getVal('retour') === 't') {
                $instructions_related = $inst_instruction->get_related_instructions();
                foreach ($instructions_related as $instruction) {
                    if ($instruction !== null && $instruction !== '') {
                        $inst_related_instruction = $this->f->get_inst__om_dbform(array(
                            "obj" => "instruction",
                            "idx" => $instruction,
                        ));
                        $instruction_data = $inst_related_instruction->get_json_data();
                        $val_instruction = $this->sort_instruction_data($instruction_data, $val_instruction);
                        if ($instruction_data['om_fichier_instruction'] !== null
                            && $instruction_data['om_fichier_instruction'] !== '') {
                            //
                            $instruction_with_doc = $inst_related_instruction->getVal($inst_related_instruction->clePrimaire);
                        }
                    }
                }
            }
            if ($instruction_with_doc !== null) {
                //
                $val_instruction['path'] = sprintf('%s&snippet=%s&obj=%s&champ=%s&id=%s', 'app/index.php?module=form', 'file', 'instruction', 'om_fichier_instruction', $instruction_with_doc);
            }
        }
        return $val_instruction;
    }

    protected function sort_instruction_data(array $values, array $res) {
        $fields = array(
            "date_envoi_signature",
            "date_retour_signature",
            "date_envoi_rar",
            "date_retour_rar",
            "date_envoi_controle_legalite",
            "date_retour_controle_legalite",
            "signataire_arrete",
            "om_fichier_instruction",
            "tacite",
            "lettretype",
        );
        foreach ($values as $key => $value) {
            if (in_array($key, $fields) === true) {
                if (array_key_exists($key, $res) === false
                    && $value !== null
                    && $value !== '') {
                    //
                    $res[$key] = $value;
                } elseif ($key === 'tacite'
                    && $value === 't') {
                    //
                    $res[$key] = $value;
                }
            }
        }
        return $res;
    }

    protected function get_document_numerise_data(string $dn) {
        $val_dn = array();
        $inst_dn = $this->f->get_inst__om_dbform(array(
            "obj" => "document_numerise",
            "idx" => $dn,
        ));
        $val_dn = $inst_dn->get_json_data();
        $val_dn['path'] = sprintf('%s&snippet=%s&obj=%s&champ=%s&id=%s', 'app/index.php?module=form', 'file', 'document_numerise', 'uid', $this->getVal('object_id'));
        // Correspond à la nomenclature Plat'AU NATURE_PIECE
        $val_dn['nature'] = $val_dn['document_numerise_nature_libelle'];
        return $val_dn;
    }

    protected function get_parcelles_data(string $object, string $idx) {
        $val_dp = array();
        $inst_di = $this->f->get_inst__om_dbform(array(
            "obj" => $object,
            "idx" => $idx,
        ));
        $list_parcelles = $inst_di->get_parcelles();
        $no_ordre = 1;
        foreach ($list_parcelles as $parcelle) {
            $val_dp[$parcelle[$object.'_parcelle']] = array(
                $object.'_parcelle' => $parcelle[$object.'_parcelle'],
                'libelle' => $parcelle['libelle'],
                'no_ordre' => $no_ordre,
            );
            $no_ordre++;
        }
        return $val_dp;
    }

    protected function view_form_json($in_field = false) {
        //
        if ($this->f->get_submitted_post_value('valid') === null) {
            // Liste des valeurs à afficher
            $val = array();
            //
            $val_task = array_combine($this->champs, $this->val);
            foreach ($val_task as $key => $value) {
                $val_task[$key] = strip_tags($value);
            }
            $val_task['timestamp_log'] = json_decode($val_task['timestamp_log'], true);
            $val['task'] = $val_task;
            //
            if ($this->getVal('type') === 'creation_DA') {
                $val['dossier_autorisation'] = $this->get_dossier_autorisation_data($this->getVal('object_id'));
                $val['donnees_techniques'] = $this->get_donnees_techniques_data($this->getVal('object_id'), 'dossier_autorisation');
                $val['dossier_autorisation_parcelle'] = $this->get_parcelles_data('dossier_autorisation', $val['dossier_autorisation']['dossier_autorisation']);
                $val_external_uid = array();
                $val_external_uid['dossier_autorisation'] = $this->get_external_uid($val['dossier_autorisation']['dossier_autorisation'], 'dossier_autorisation');
                $val['external_uids'] = $val_external_uid;
            }
            //
            if ($this->getVal('type') === 'creation_DI'
                || $this->getVal('type') === 'modification_DI'
                || $this->getVal('type') === 'depot_DI') {
                //
                $val['dossier'] = $this->get_dossier_data($this->getVal('object_id'));
                $val['donnees_techniques'] = $this->get_donnees_techniques_data($this->getVal('object_id'), 'dossier_instruction');
                $val['demandeur'] = $this->get_demandeurs_data($val['dossier']['dossier']);
                $architecte = isset($val['donnees_techniques']['architecte']) === true ? $val['donnees_techniques']['architecte'] : null;
                $val['architecte'] = $this->get_architecte_data($architecte);
                $val['dossier_parcelle'] = $this->get_parcelles_data('dossier', $val['dossier']['dossier']);
                $val_external_uid = array();
                $val_external_uid['dossier_autorisation'] = $this->get_external_uid($val['dossier']['dossier_autorisation'], 'dossier_autorisation');
                $val_external_uid['dossier'] = $this->get_external_uid($val['dossier']['dossier'], 'dossier');
                $val['external_uids'] = $val_external_uid;
            }
            //
            if ($this->getVal('type') === 'qualification_DI') {
                $val['dossier'] = $this->get_dossier_data($this->getVal('object_id'));
                $val_external_uid = array();
                $val_external_uid['dossier_autorisation'] = $this->get_external_uid($val['dossier']['dossier_autorisation'], 'dossier_autorisation');
                $val_external_uid['dossier'] = $this->get_external_uid($val['dossier']['dossier'], 'dossier');
                $val['external_uids'] = $val_external_uid;
            }
            //
            if ($this->getVal('type') === 'ajout_piece') {
                $val['document_numerise'] = $this->get_document_numerise_data($this->getVal('object_id'));
                $val['dossier'] = $this->get_dossier_data($val['document_numerise']['dossier']);
                $val_external_uid = array();
                $val_external_uid['dossier_autorisation'] = $this->get_external_uid($val['dossier']['dossier_autorisation'], 'dossier_autorisation');
                $val_external_uid['dossier'] = $this->get_external_uid($val['dossier']['dossier'], 'dossier');
                $val_external_uid['document_numerise'] = $this->get_external_uid($val['document_numerise']['document_numerise'], 'document_numerise');
                $val['external_uids'] = $val_external_uid;
            }
            //
            if ($this->getVal('type') === 'decision_DI') {
                $val['dossier'] = $this->get_dossier_data($this->getVal('object_id'));
                $val['instruction'] = $this->get_instruction_data($val['dossier']['dossier']);
                $val_external_uid = array();
                $val_external_uid['dossier_autorisation'] = $this->get_external_uid($val['dossier']['dossier_autorisation'], 'dossier_autorisation');
                $val_external_uid['dossier'] = $this->get_external_uid($val['dossier']['dossier'], 'dossier');
                $val['external_uids'] = $val_external_uid;
            }
            //
            if ($this->getVal('type') === 'incompletude_DI') {
                $val['dossier'] = $this->get_dossier_data($this->getVal('object_id'));
                $val['instruction'] = $this->get_instruction_data($val['dossier']['dossier'], 'incompletude');
                $val_external_uid = array();
                $val_external_uid['dossier_autorisation'] = $this->get_external_uid($val['dossier']['dossier_autorisation'], 'dossier_autorisation');
                $val_external_uid['dossier'] = $this->get_external_uid($val['dossier']['dossier'], 'dossier');
                $val['external_uids'] = $val_external_uid;
            }
            //
            if ($this->getVal('type') === 'completude_DI') {
                $val['dossier'] = $this->get_dossier_data($this->getVal('object_id'));
                $val['instruction'] = $this->get_instruction_data($val['dossier']['dossier'], 'completude');
                $val_external_uid = array();
                $val_external_uid['dossier_autorisation'] = $this->get_external_uid($val['dossier']['dossier_autorisation'], 'dossier_autorisation');
                $val_external_uid['dossier'] = $this->get_external_uid($val['dossier']['dossier'], 'dossier');
                $val['external_uids'] = $val_external_uid;
            }

            if ($in_field === true) {
                return json_encode($val, JSON_PRETTY_PRINT | JSON_UNESCAPED_SLASHES);
            } else {
                // Liste des valeurs affichée en JSON
                printf(json_encode($val, JSON_UNESCAPED_SLASHES));
            }
        }
    }

    function post_update_task() {
        // Mise à jour des valeurs
        //
        $params = array(
            'val' => array(
                'state' => $this->f->get_submitted_post_value('state')
            ),
        );
        $update = $this->update_task($params);
        $message_class = "valid";
        $message = $this->msg;
        if ($update === false) {
            $this->addToLog($this->msg, DEBUG_MODE);
            $message_class = "error";
            $message = sprintf(
                '%s %s',
                __('Impossible de mettre à jour la tâche.'),
                __('Veuillez contacter votre administrateur.')
            );
        }
        $this->f->displayMessage($message_class, $message);
        //
        $inst_lien = $this->f->get_inst__om_dbform(array(
            "obj" => "lien_id_interne_uid_externe",
            "idx" => ']',
        ));
        $valF = array(
            'lien_id_interne_uid_externe' => '',
            'object' => $this->get_lien_objet_by_type($this->getVal('type')),
            'object_id' => $this->getVal('object_id'),
            'external_uid' => $this->f->get_submitted_post_value('external_uid'),
        );
        $add = $inst_lien->ajouter($valF);
        $message_class = "valid";
        $message = $inst_lien->msg;
        if ($add === false) {
            $this->addToLog($inst_lien->msg, DEBUG_MODE);
            $message_class = "error";
            $message = sprintf(
                '%s %s',
                __("Impossible de mettre à jour le lien entre l'identifiant interne et l'identifiant de l'application externe."),
                __('Veuillez contacter votre administrateur.')
            );
        }
        $this->f->displayMessage($message_class, $message);
    }

    function post_add_task() {
        // TODO Tester de remplacer la ligne de json_payload par un $_POST
        $result = $this->add_task(array(
            'val' => array(
                'stream' => 'input',
                'json_payload' => html_entity_decode($this->f->get_submitted_post_value('json_payload')),
                'type' => $this->f->get_submitted_post_value('type'),
            )
        ));
        $message = $this->msg;
        $message_class = "valid";
        if ($result === false){
            $this->addToLog($this->msg, DEBUG_MODE);
            $message_class = "error";
            $message = sprintf(
                '%s %s',
                __('Impossible d\'ajouter la tâche.'),
                __('Veuillez contacter votre administrateur.')
            );
        }
        $this->f->displayMessage($message_class, $message);
    }

    function get_lien_objet_by_type($type) {
        //
        $objet = '';
        if ($type === 'creation_DA') {
            $objet = 'dossier_autorisation';
        }
        if ($type === 'creation_DI'
            || $type === 'create_DI_for_consultation'
            || $type === 'depot_DI'
            || $type === 'modification_DI'
            || $type === 'qualification_DI'
            || $type === 'decision_DI'
            || $type === 'incompletude_DI'
            || $type === 'completude_DI') {
            //
            $objet = 'dossier';
        }
        if ($type === 'ajout_piece') {
            $objet = 'document_numerise';
        }
        // La tâche entrante se nomme add_piece
        if ($type === 'add_piece') {
            $objet = 'piece';
        }
        return $objet;
    }

    function setLayout(&$form, $maj) {

        // Récupération du mode de l'action
        $crud = $this->get_action_crud($maj);

        // MODE different de CREER
        if ($maj != 0 || $crud != 'create') {
            $form->setBloc('json_payload', 'D', '', 'col_6');
                $form->setFieldset('json_payload', 'DF', __("json_payload"), "collapsible, startClosed");
            $form->setBloc('json_payload', 'F');
        }
        $form->setBloc('timestamp_log', 'DF', '', 'col_9');
    }

}