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

[ludo...@adullact.net]

Author: ludovicb
Date: 2017-10-06 15:21:44 +0200 (Fri, 06 Oct 2017)
New Revision: 1062

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


Added: branches/5.0.0/sql/pgsql/tachenonsolde_service.inc.php
===================================================================
--- branches/5.0.0/sql/pgsql/tachenonsolde_service.inc.php (rev 0)
+++ branches/5.0.0/sql/pgsql/tachenonsolde_service.inc.php 2017-10-06 13:21:44 UTC (rev 1062)
@@ -0,0 +1,20 @@
+<?php
+//$Id: tachenonsolde.inc,v 1.6 2009-10-06 15:40:54 fraynaud Exp $
+$DEBUG=0;
+$serie=20;
+$ent = _("taches non soldees");
+$ico = "../img/ico_tache.png";
+$edition="";
+$table=DB_PREFIXE."tache inner join ".DB_PREFIXE."service on service.service = tache.service inner join ".DB_PREFIXE."courrier on courrier.courrier=tache.courrier";
+$champAffiche=array('to_char(datebutoir ,\'DD/MM/YYYY\') as "'._("datebutoir").'"',
+ 'registre as "'._("registre").'"',
+ 'substring(objetcourrier,1,30) as "'._("obj").'"');
+$tri= "order by datebutoir desc";
+/*if($f->get_service_code($_SESSION['service'])=='*')
+ $selection="where tache.etat_tache = 1";
+else*/
+ $selection=" where tache.etat_tache < 3 and (tache.service='".
+ // $_SESSION['service']."' or courrier.traitement='".
+ // $_SESSION['service']."') ";
+ $_SESSION['service']."') ";
+?>


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