sql/pgsql/dossier_message.form.inc.php

<?php
//$Id$ 
//gen openMairie le 15/11/2012 18:30

include('../gen/sql/pgsql/dossier_message.form.inc.php');

$portlet_actions['supprimer'] = NULL;

$tableSelect = DB_PREFIXE."dossier_message
    LEFT JOIN ".DB_PREFIXE."dossier 
        ON dossier_message.dossier=dossier.dossier ";

$champs = array(
    "dossier_message",
    "dossier.dossier",
    "type",
    "emetteur",
    'to_char(dossier_message.date_emission ,\'DD/MM/YYYY HH24:MI\') as date_emission',
    "lu",
    "contenu");

$sql_messages_type="SELECT DISTINCT dossier_message.type, dossier_message.type
    FROM ".DB_PREFIXE."dossier_message 
    LEFT JOIN ".DB_PREFIXE."dossier ON dossier_message.dossier = dossier.dossier
    LEFT JOIN ".DB_PREFIXE."instructeur ON dossier.instructeur = instructeur.instructeur
    WHERE instructeur.division = (
        SELECT division FROM ".DB_PREFIXE."instructeur
        WHERE instructeur.om_utilisateur = (
            SELECT om_utilisateur FROM "
            .DB_PREFIXE."om_utilisateur where login = '".$_SESSION['login']."'))";
    
$portlet_actions['lu'] =
    array('lien' => "#\" onclick=\"markedAsRead(",
          'id' => ",'dossier_message', 'dossier_message');\"",
          'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
                _("Edition")."\">"._("Marquer comme lu")."</span>",
          'ordre' => 30,
          'rights' => array('list' => array("dossier_message", "dossier_message_modifier_lu"), 'operator' => 'OR'),
          'ajax' => false);
?>
1	mlimic	709	<?php
2			//$Id$
3			//gen openMairie le 15/11/2012 18:30
4
5			include('../gen/sql/pgsql/dossier_message.form.inc.php');
6
7			$portlet_actions['supprimer'] = NULL;
8
9			$tableSelect = DB_PREFIXE."dossier_message
10			LEFT JOIN ".DB_PREFIXE."dossier
11			ON dossier_message.dossier=dossier.dossier ";
12
13	mlimic	732	$champs = array(
14	atreal	974	"dossier_message",
15	mlimic	732	"dossier.dossier",
16			"type",
17			"emetteur",
18	mlimic	899	'to_char(dossier_message.date_emission ,\'DD/MM/YYYY HH24:MI\') as date_emission',
19	mlimic	732	"lu",
20			"contenu");
21
22			$sql_messages_type="SELECT DISTINCT dossier_message.type, dossier_message.type
23			FROM ".DB_PREFIXE."dossier_message
24			LEFT JOIN ".DB_PREFIXE."dossier ON dossier_message.dossier = dossier.dossier
25			LEFT JOIN ".DB_PREFIXE."instructeur ON dossier.instructeur = instructeur.instructeur
26			WHERE instructeur.division = (
27			SELECT division FROM ".DB_PREFIXE."instructeur
28			WHERE instructeur.om_utilisateur = (
29			SELECT om_utilisateur FROM "
30			.DB_PREFIXE."om_utilisateur where login = '".$_SESSION['login']."'))";
31	mlimic	709
32	vpihour	900	$portlet_actions['lu'] =
33			array('lien' => "#\" onclick=\"markedAsRead(",
34	atreal	974	'id' => ",'dossier_message', 'dossier_message');\"",
35	vpihour	900	'lib' => "<span class=\"om-prev-icon om-icon-16 om-icon-fix lu-16\" title=\"".
36			_("Edition")."\">"._("Marquer comme lu")."</span>",
37			'ordre' => 30,
38			'rights' => array('list' => array("dossier_message", "dossier_message_modifier_lu"), 'operator' => 'OR'),
39			'ajax' => false);
40	atreal	974	?>