sql/pgsql/instruction.inc.php

<?php
/**
 *
 *
 * @package openfoncier
 * @version SVN : $Id: instruction.inc.php 4418 2015-02-24 17:30:28Z tbenita $
 */

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

// =======================================================
// href special edition instruction
// =======================================================
$table=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement 
    LEFT JOIN ".DB_PREFIXE."signataire_arrete 
        ON instruction.signataire_arrete=signataire_arrete.signataire_arrete
    LEFT JOIN ".DB_PREFIXE."dossier
        ON instruction.dossier = dossier.dossier
    LEFT JOIN ".DB_PREFIXE."etat
        ON instruction.etat = etat.etat";

$champAffiche = array(
    "instruction as no",
    "evenement.libelle",
    "to_char(date_evenement ,'DD/MM/YYYY') as \"".__("date_evenement")."\"",
    "etat.libelle as \"".__("etat")."\"",
    "instruction.lettretype",
    "(CASE WHEN (instruction.om_final_instruction_utilisateur IS NULL
                OR length(trim(instruction.om_final_instruction_utilisateur)) = 0)
            AND (dossier.log_instructions IS NULL
                OR length(trim(dossier.log_instructions)) > 0)
        THEN
            (SELECT DISTINCT
                U.login || ' (' || U.nom || ')'
            FROM
                (SELECT
                    J.value::json->>'user' login
                FROM
                    json_array_elements(dossier.log_instructions::json) J
                WHERE
                    (J.value::json->'values'->>'instruction')::int = instruction.instruction
                LIMIT 1) L
            INNER JOIN ".DB_PREFIXE."om_utilisateur U
                ON U.login = L.login)
        ELSE
            instruction.om_final_instruction_utilisateur
    END) as \"".__("finalise par").'/'.__("cree par")."\"",
    "signataire_arrete.nom as \"".__("signataire_arrete")."\"",
);

$champRecherche=array(
    "evenement.libelle",
    );
$tri= " order by date_evenement asc, instruction asc ";

// Gestion particulière de l'affichage du listing dans le contexte d'un dossier
// d'instruction.
include "../sql/pgsql/dossier_instruction_droit_specifique_par_division.inc.php";
// Gestion des groupes et confidentialité
include('../sql/pgsql/filter_group.inc.php');
1	mbroquet	3730	<?php
2			/**
3			*
4			*
5			* @package openfoncier
6			* @version SVN : $Id: instruction.inc.php 4418 2015-02-24 17:30:28Z tbenita $
7			*/
8
9			//
10			include "../gen/sql/pgsql/instruction.inc.php";
11
12			// =======================================================
13			// href special edition instruction
14			// =======================================================
15			$table=DB_PREFIXE."instruction inner join ".DB_PREFIXE."evenement on instruction.evenement=evenement.evenement
16			LEFT JOIN ".DB_PREFIXE."signataire_arrete
17			ON instruction.signataire_arrete=signataire_arrete.signataire_arrete
18			LEFT JOIN ".DB_PREFIXE."dossier
19			ON instruction.dossier = dossier.dossier
20			LEFT JOIN ".DB_PREFIXE."etat
21			ON instruction.etat = etat.etat";
22	softime	12124
23			$champAffiche = array(
24			"instruction as no",
25			"evenement.libelle",
26	softime	18876	"to_char(date_evenement ,'DD/MM/YYYY') as \"".__("date_evenement")."\"",
27			"etat.libelle as \"".__("etat")."\"",
28	softime	12124	"instruction.lettretype",
29			"(CASE WHEN (instruction.om_final_instruction_utilisateur IS NULL
30			OR length(trim(instruction.om_final_instruction_utilisateur)) = 0)
31			AND (dossier.log_instructions IS NULL
32			OR length(trim(dossier.log_instructions)) > 0)
33			THEN
34			(SELECT DISTINCT
35			U.login \|\| ' (' \|\| U.nom \|\| ')'
36			FROM
37			(SELECT
38	softime	18436	J.value::json->>'user' login
39	softime	12124	FROM
40	softime	18436	json_array_elements(dossier.log_instructions::json) J
41	softime	12124	WHERE
42			(J.value::json->'values'->>'instruction')::int = instruction.instruction
43	softime	18436	LIMIT 1) L
44			INNER JOIN ".DB_PREFIXE."om_utilisateur U
45	softime	12124	ON U.login = L.login)
46			ELSE
47			instruction.om_final_instruction_utilisateur
48	softime	18436	END) as \"".__("finalise par").'/'.__("cree par")."\"",
49	softime	12124	"signataire_arrete.nom as \"".__("signataire_arrete")."\"",
50			);
51
52	nhaye	4781	$champRecherche=array(
53			"evenement.libelle",
54			);
55	mbroquet	3730	$tri= " order by date_evenement asc, instruction asc ";
56
57	softime	6565	// Gestion particulière de l'affichage du listing dans le contexte d'un dossier
58			// d'instruction.
59	mbroquet	3730	include "../sql/pgsql/dossier_instruction_droit_specifique_par_division.inc.php";
60	softime	6565	// Gestion des groupes et confidentialité
61	softime	12124	include('../sql/pgsql/filter_group.inc.php');