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

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

$champAffiche = array(
    'task.task as "'.__("task").'"',
    'task.type as "'.__("type").'"',
    'task.state as "'.__("state").'"',
    'task.object_id as "'.__("object_id").'"',
    'task.dossier as "'.__("dossier").'"',
    'task.stream 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' => 'text',
        'taille' => '',
        'max' => '',
    ),

    '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";