| 1 |
<?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 |
|
| 23 |
$champAffiche = array( |
| 24 |
"instruction as no", |
| 25 |
"evenement.libelle", |
| 26 |
"to_char(date_evenement ,'DD/MM/YYYY') as \"".__("date_evenement")."\"", |
| 27 |
"etat.libelle as \"".__("etat")."\"", |
| 28 |
"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 |
J.value::json->>'user' login |
| 39 |
FROM |
| 40 |
json_array_elements(dossier.log_instructions::json) J |
| 41 |
WHERE |
| 42 |
(J.value::json->'values'->>'instruction')::int = instruction.instruction |
| 43 |
LIMIT 1) L |
| 44 |
INNER JOIN ".DB_PREFIXE."om_utilisateur U |
| 45 |
ON U.login = L.login) |
| 46 |
ELSE |
| 47 |
instruction.om_final_instruction_utilisateur |
| 48 |
END) as \"".__("finalise par").'/'.__("cree par")."\"", |
| 49 |
"signataire_arrete.nom as \"".__("signataire_arrete")."\"", |
| 50 |
); |
| 51 |
|
| 52 |
$champRecherche=array( |
| 53 |
"evenement.libelle", |
| 54 |
); |
| 55 |
$tri= " order by date_evenement asc, instruction asc "; |
| 56 |
|
| 57 |
// Gestion particulière de l'affichage du listing dans le contexte d'un dossier |
| 58 |
// d'instruction. |
| 59 |
include "../sql/pgsql/dossier_instruction_droit_specifique_par_division.inc.php"; |
| 60 |
// Gestion des groupes et confidentialité |
| 61 |
include('../sql/pgsql/filter_group.inc.php'); |
Parent Directory
| 
Revision Log