<?php
//$Id$ 
//gen openMairie le 09/10/2020 15:34

include "../gen/sql/pgsql/task.inc.php";

if(!empty($obj) && $obj == "task" ){
    $ent = __("Application")." -> ".__("Moniteur Plat'AU");
    $args_type = array(
        //
        0 => array(
            "", 
            'creation_DA',
            'creation_DI',
            'depot_DI',
            'modification_DI',
            'qualification_DI',
            'decision_DI',
            'incompletude_DI',
            'completude_DI',
            'ajout_piece',
            'add_piece',
            'creation_consultation',
            'modification_DA',
            'create_DI',
            'envoi_CL',
            'notification_recepisse',
            'notification_instruction',
            'notification_decision',
            'notification_service_consulte',
            'notification_tiers_consulte'),

        1 => array(
            _("choisir")." ".__("type"),
            __('creation_DA'),
            __('creation_DI'),
            __('depot_DI'),
            __('modification_DI'),
            __('qualification_DI'),
            __('decision_DI'),
            __('incompletude_DI'),
            __('completude_DI'),
            __('ajout_piece'),
            __('add_piece'),
            __('creation_consultation'),
            __('modification_DA'),
            __('create_DI'),
            __('envoi_CL'),
            __('notification_recepisse'),
            __('notification_instruction'),
            __('notification_decision'),
            __('notification_service_consulte'),
            __('notification_tiers_consulte')),
    );
}
else {
    $ent = __("Application")." -> ".__("Moniteur Ide'AU");
    $args_type = array(
        //
        0 => array(
            "",
            "creation_DA",
            "creation_DI",
            "depot_DI",
            "qualification_DI",
            'create_DI_for_consultation',
            'avis_consultation',
            'pec_metier_consultation',
            'create_message',
            'notification_recepisse',
            'notification_instruction',
            'notification_decision',
            'notification_service_consulte',
            'notification_tiers_consulte',
            'prescription'),

        1 => array(
            _("choisir")." ".__("type"),
            __("creation_DA"),
            __("creation_DI"),
            __("depot_DI"),
            __("qualification_DI"),
            __('create_DI_for_consultation'),
            __('avis_consultation'),
            __('pec_metier_consultation'),
            __('create_message'),
            __('notification_recepisse'),
            __('notification_instruction'),
            __('notification_decision'),
            __('notification_service_consulte'),
            __('notification_tiers_consulte'),
            __('prescription')),
    );
}

$template_case_traduction_type =
    'CASE WHEN task.type=\'creation_DA\' 
            THEN \''._("Création DA").'\'
            WHEN task.type=\'creation_DI\' 
            THEN \''._("Création demande").'\'
            WHEN task.type=\'modification_DA\' 
            THEN \''._("Modification DA").'\'
            WHEN task.type=\'modification_DI\' 
            THEN \''._("Modification DI").'\'
            WHEN task.type=\'ajout_piece\' 
            THEN \''._("Ajout pièce").'\'
            WHEN task.type=\'depot_DI\' 
            THEN \''._("Dépôt DI").'\'
            WHEN task.type=\'qualification_DI\' 
            THEN \''._("Qualification DI").'\'
            WHEN task.type=\'creation_consultation\' 
            THEN \''._("Création consultation").'\'
            WHEN task.type=\'decision_DI\' 
            THEN \''._("Décision DI").'\'
            WHEN task.type=\'envoi_CL\' 
            THEN \''._("Envoi contrôle de légalité").'\'
            WHEN task.type=\'pec_metier_consultation\' 
            THEN \''._("PeC consultation").'\'
            WHEN task.type=\'avis_consultation\' 
            THEN \''._("Avis").'\'
            WHEN task.type=\'prescription\' 
            THEN \''._("Prescription").'\'
            WHEN task.type=\'create_DI_for_consultation\' 
            THEN \''._("Création DI pour consultation").'\'
            WHEN task.type=\'add_piece\' 
            THEN \''._("Ajout pièce").'\'
            WHEN task.type=\'create_message\' 
            THEN \''._("Message").'\'
            WHEN task.type=\'notification_recepisse\' 
            THEN \''._("Notification récépissé").'\'
            WHEN task.type=\'notification_instruction\' 
            THEN \''._("Notification instruction").'\'
            WHEN task.type=\'notification_decision\' 
            THEN \''._("Notification décision").'\'
            WHEN task.type=\'notification_service_consulte\' 
            THEN \''._("notification service consulté").'\'
            WHEN task.type=\'notification_tiers_consulte\' 
            THEN \''._("notification tiers consulté").'\'
            WHEN task.type=\'incompletude_DI\' 
            THEN \''._("incomplétude DI").'\'
            WHEN task.type=\'completude_DI\' 
            THEN \''._("completude DI").'\'
            WHEN task.type=\'create_DI\' 
            THEN \''._("création DI").'\'
    END';

$template_case_traduction_etat =
    'CASE WHEN task.state=\'draft\' 
            THEN \''._("brouillon").'\'
            WHEN task.state=\'new\' 
            THEN \''._("à traiter").'\'
            WHEN task.state=\'pending\' 
            THEN \''._("en cours").'\'
            WHEN task.state=\'done\' 
            THEN \''._("terminé").'\'
            WHEN task.state=\'archived\' 
            THEN \''._("archivé").'\'
            WHEN task.state=\'error\' 
            THEN \''._("erreur").'\'
            WHEN task.state=\'debug\' 
            THEN \''._("debug").'\'
            WHEN task.state=\'canceled\' 
            THEN \''._("annulé").'\'
    END';

$template_case_traduction_flux =
    'CASE WHEN task.stream=\'input\' 
            THEN \''._("Entrant").'\'
            WHEN task.stream=\'output\' 
            THEN \''._("Sortant").'\'
    END';


$champAffiche = array(
    'task.task as "'.__("task").'"',
    $template_case_traduction_type.' as "'._("type").'"',
    $template_case_traduction_etat.' as "'._("state").'"',
    'task.object_id as "'.__("object_id").'"',
    'task.dossier as "'.__("dossier").'"',
    $template_case_traduction_flux.' as "'._("stream").'"',

    );

$args_state = array(
    //
    0 => array("", "draft", "new", "pending", "done", "archived", "error", "debug", "canceled", ),
    1 => array(__("choisir")." ".__("state"),__("draft"), __("new"), __("pending"), __("done"), __("archived"), __("error"), __("debug"), __("canceled"), ),
);

$args_stream = array(
    //
    0 => array("", "input", "output"),
    1 => array(_("choisir")." ".__("stream"), __("input"), __("output")),
);

$advsearch_fields= array(
    //
    'task' => array(
        'colonne' => 'task',
        'table' => 'task',
        'libelle' => __("task"),
        'type' => 'text',
        'taille' => '',
        'max' => '',
    ),

    'type' => array(
        'colonne' => 'type',
        'table' => 'task',
        'libelle' => __("type"),
        'type' => 'select',
        'subtype' => 'manualselect',
        'args' => $args_type
    ),

    'state' => array(
        'colonne' => 'state',
        'table' => 'task',
        'libelle' => __("state"),
        'type' => 'select',
        'subtype' => 'manualselect',
        'args' => $args_state
    ),

    'object_id' => array(
        'colonne' => 'object_id',
        'table' => 'task',
        'libelle' => __("object_id"),
        'type' => 'text',
        'taille' => '',
        'max' => '',
    ),

     'dossier' => array(
        'colonne' => 'dossier',
        'table' => 'task',
        'libelle' => __("dossier"),
        'type' => 'text',
        'taille' => '',
        'max' => '',
    ),

    'stream' => array(
        'colonne' => 'stream',
        'table' => 'task',
        'libelle' => __("stream"),
        'type' => 'select',
        'subtype' => 'manualselect',
        'args' => $args_stream
    ),
);

// advsearch -> options
$options[] = array(
    'type' => 'search',
    'display' => true,
    'advanced' => $advsearch_fields,
    'absolute_object' => 'dossier',
);

$selection = " WHERE LOWER(task.category) = 'platau' ";

$tri="ORDER BY task.task ASC NULLS LAST";