<?php
//$Id$ 
//gen openMairie le 09/10/2023 11:53

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

$ent = " -> ".__($obj);

require_once "../obj/reprise_abandon.class.php";
$reprise_abandon = new reprise_abandon(0);

if (isset($options) !== true) {
    $options = array();
}


$statut_trad = $reprise_abandon->compose_statut_reprise_trad();
$etat_trad = $reprise_abandon->compose_etat_reprise_trad();
$field_emplacement = '(emplacement.nature||\' - n°\'||emplacement.emplacement||\' - Famille : \'||emplacement.famille) as "'.__("emplacement").'"';

// SELECT 
$champAffiche = array(
    'reprise_abandon.reprise_abandon as "'.__("id").'"',
    $field_emplacement,
    $statut_trad.' as "'.__("statut").'"',
    $etat_trad.' as "'.__("etat").'"',
    'reprise_abandon.date_envoi_convo_1 as "'.__("date_envoi_convo_1").'"',
    'reprise_abandon.date_notification_pv1 as "'.__("date_notification_pv1").'"',
    'reprise_abandon.date_envoi_convo_2 as "'.__("date_envoi_convo_2").'"',
    'reprise_abandon.date_notification_pv2 as "'.__("date_notification_pv2").'"',
);

$fields_to_hide = array();
if (in_array($retourformulaire, $foreign_keys_extended["emplacement"])) {
    $fields_to_hide[] = $field_emplacement;
    $fields_to_hide[] = 'reprise_abandon.date_envoi_convo_1 as "'.__("date_envoi_convo_1").'"';
    $fields_to_hide[] = 'reprise_abandon.date_notification_pv1 as "'.__("date_notification_pv1").'"';
    $fields_to_hide[] = 'reprise_abandon.date_envoi_convo_2 as "'.__("date_envoi_convo_2").'"';
    $fields_to_hide[] = 'reprise_abandon.date_notification_pv2 as "'.__("date_notification_pv2").'"';
}
$champAffiche = array_diff($champAffiche, $fields_to_hide);
// $champRecherche[0] = $champAffiche[0];
// Recherche avancée
$advs_fields = array(
    "reprise_abandon" => array(
        "colonne" => "reprise_abandon",
        "table" => "reprise_abandon",
        "type" => "text",
        "libelle" => __("id"),
        "taille" => 8,
        "max" => '',
    ),
    "emplacement" =>  array(
        'colonne' => array('nature', 'emplacement','famille'),
        'table' => 'emplacement',
        'type' => 'text',
        'libelle' => __('emplacement'),
        'help' => __("identifiant de l'emplacement (ex : 12) ou famille (ex : DUPONT) ou nature de l'emplacement (ex : concession)"),
        'taille' => 8,
        'max' => '',
    ),
    "etat" => array(
        'colonne' => 'etat',
        'table' => 'reprise_abandon',
        'type' => 'select',
        'libelle' => __('etat'),
        'taille' => 8,
    ),
    "statut" => array(
        'colonne' => 'statut',
        'table' => 'reprise_abandon',
        'type' => 'select',
        'libelle' => __('statut'),
        'taille' => 8,
    ),
    "date_envoi_convo_1" => array(
        "colonne" => "date_envoi_convo_1",
        "table" => "reprise_abandon",
        "type" => "text",
        "libelle" => __("date_envoi_convo_1"),
        "type" => "date",
        "taille" => 8,
        "where" => "intervaldate",
    ),
    "date_notification_pv1" => array(
        "colonne" => "date_notification_pv1",
        "table" => "reprise_abandon",
        "type" => "text",
        "libelle" => __("date_notification_pv1"),
        "type" => "date",
        "taille" => 8,
        "where" => "intervaldate",
    ),
    "date_envoi_convo_2" => array(
        "colonne" => "date_envoi_convo_2",
        "table" => "reprise_abandon",
        "type" => "text",
        "libelle" => __("date_envoi_convo_2"),
        "type" => "date",
        "taille" => 8,
        "where" => "intervaldate",
    ),
    "date_notification_pv2" => array(
        "colonne" => "date_notification_pv2",
        "table" => "reprise_abandon",
        "type" => "text",
        "libelle" => __("date_notification_pv2"),
        "type" => "date",
        "taille" => 8,
        "where" => "intervaldate",
    ),
);

$options[] = array(
    "type" => "search",
    "display" => true,
    "advanced" => $advs_fields,
    'default_form' => 'advanced',
    "export" => array("csv", ),
    "absolute_object" => "reprise_abandon",
);


// L'action ajouter ne doit pas apparaître sur le listing général.
// Les liens vers les fiches de consultation sont remplacés par des directlink.
if (isset($_GET["module"]) && $_GET["module"] === "tab") {
    $tab_actions["corner"]["ajouter"] = NULL;
    $tab_actions["left"]["consulter"]["lien"] = str_replace(
        "action=3",
        "action=701",
        $tab_actions["left"]["consulter"]["lien"]
    );
    $tab_actions["content"]["lien"] = $tab_actions["left"]["consulter"]["lien"];
}