ludo...@adullact.net
unread,Oct 6, 2017, 9:19:12 AM10/6/17Sign in to reply to author
Sign in to forward
You do not have permission to delete messages in this group
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to openmairie-...@googlegroups.com
Author: ludovicb
Date: 2017-10-06 15:19:10 +0200 (Fri, 06 Oct 2017)
New Revision: 1060
Added:
branches/5.0.0/sql/pgsql/diffusion_non_validee.inc.php
Log:
fonctionne avec widget diffusion non validee
Added: branches/5.0.0/sql/pgsql/diffusion_non_validee.inc.php
===================================================================
--- branches/5.0.0/sql/pgsql/diffusion_non_validee.inc.php (rev 0)
+++ branches/5.0.0/sql/pgsql/diffusion_non_validee.inc.php 2017-10-06 13:19:10 UTC (rev 1060)
@@ -0,0 +1,45 @@
+<?php
+/**
+ * Script contenant les requetes effectuee par la class obj/diffusion.class.php
+ *
+ * @package openCourrier
+ *
+ *
+ */
+include('../sql/pgsql/diffusion.inc.php');
+
+
+$champAffiche = array(
+ 'diffusion.diffusion as "'._("Id").'"',
+ 'service.libelle as "'._("service").'"',
+ 'courrier.registre as "'._("courrier").'"',
+ 'to_char(diffusion.datediffusion ,\'DD/MM/YYYY\') as "'._("date").'"',
+ 'type_diffusion.libelle as "'._("type_diffusion").'"',
+ "concat(dossier.filename,' du ',to_char(datedossier, 'dd/mm/YYYY'),' ',type_dossier.libelle) as "._("dossier").'',
+ 'service2.libelle as "'._("origine").'"',
+ 'etat_diffusion.libelle as "'._("diffusion").'"',
+ );
+$tri="ORDER BY service.libelle ASC NULLS LAST";
+$selection =" where diffusion.etat_diffusion =1 ";
+$selection .=" and courrier.nature=1";
+
+// Lien vers l'enregistrement
+$link = '
+<a class="lienTable" href="form.php?'
+ .'obj=courrier_arrivee'
+ .'&action=3'
+ .'&idx=%s'
+ .'&idz=%s'
+ .'&premier=0'
+ .'&advs_id='
+ .'&recherche='
+ .'&tricol='
+ .'&selectioncol='
+ .'&valide='
+ .'&retour=tab">'
+ // Valeur affichée
+ .'%s'
+.'</a>';
+
+?>
+