[opencourrier-Commits] r1061 - branches/5.0.0/sql/pgsql

[ludo...@adullact.net]

Author: ludovicb
Date: 2017-10-06 15:20:23 +0200 (Fri, 06 Oct 2017)
New Revision: 1061

Added:
branches/5.0.0/sql/pgsql/tachenonsolde.inc.php
Log:
fonctionne avec widget tache non solde


Added: branches/5.0.0/sql/pgsql/tachenonsolde.inc.php
===================================================================
--- branches/5.0.0/sql/pgsql/tachenonsolde.inc.php (rev 0)
+++ branches/5.0.0/sql/pgsql/tachenonsolde.inc.php 2017-10-06 13:20:23 UTC (rev 1061)
@@ -0,0 +1,59 @@
+<?php
+//$Id: tachenonsolde.inc,v 1.6 2009-10-06 15:40:54 fraynaud Exp $
+include('../sql/pgsql/tache.inc.php');
+
+// Fil d'Ariane
+$ent = _("courrier")." -> "._("tache non soldee");
+if (isset($idx) && $idx != ']' && trim($idx) != '') {
+ $ent .= "->&nbsp;".$idx."&nbsp;";
+}
+if (isset($idz) && trim($idz) != '') {
+ $ent .= "&nbsp;".mb_strtoupper($idz, "UTF-8")."&nbsp;";
+}
+
+$champAffiche=array('tache as "'._("tache").'"',
+ 'registre as "'._("registre").'"',
+ 'service.libelle as "'._("traitement").'"',
+ 'emetteurnom ||\' \'|| emetteurprenom as "'._("emetteur").'"',
+ 'substring(objetcourrier,1,30) as "'._("objet courrier").'"',
+ 'to_char(datebutoir ,\'DD/MM/YYYY\') as "'._("datebutoir").'"',
+ 'categorie_tache.libelle as "'._("Categorie").'"',
+ 'tache.etat_tache as "'._("Etat").'"',
+ 'extract(day FROM (tache.datebutoir - now())) as "'._("Temps Restant").'"'
+ );
+$champRecherche=array(
+ "service.libelle as traitement",
+ "registre",
+ "objetcourrier as objet courrier",
+ "categorie_tache.libelle as categorie",
+ "tache.etat_tache as Etat",
+ );
+
+$tri= "order by datebutoir desc";
+
+$selection = " where tache.etat_tache <3 ";
+// Si la vue sur les sous-services est active
+/*if ($f->getParameter('vue_sous_service') == 'true') {
+ //
+ $selection .= " AND service.libelle IN ('".$_SESSION['service']."'";
+ foreach($_SESSION['sous_service'] as $elt) {
+ $selection.=",'".$elt."'";
+ }
+ $selection.=')';
+} else {
+
+ // Si l'utilisateur n'est pas tous service
+ if($f->get_service_code($_SESSION['service']) != '*') {*/
+ $selection .= " AND tache.service='".$_SESSION['service']."'";
+ //}
+//}
+
+/*$tab_actions['left']['tdb'] = array(
+ "lien" => "../app/courrier.php?tache=",
+ "id" => "&amp;tricol=".$tricol."&amp;origin=".$obj."&amp;obj=tachenonsolde&amp;premier=".$premier."&amp;recherche=".$recherche1."&amp;selectioncol=".$selectioncol,
+ "lib" => "<span class=\"om-icon om-icon-16 om-icon-fix tb-16\" title=\""._("Tableau de bord du courrier")."\">"._("TB")."</span>",
+ "ajax" => false,
+ "ordre" => 100,
+ );*/
+
+?>


Property changes on: branches/5.0.0/sql/pgsql/tachenonsolde.inc.php
___________________________________________________________________
Added: svn:executable
## -0,0 +1 ##
+*
\ No newline at end of property