sql/pgsql/destination_shon.reqmo.inc

<?php //$Id: destination_shon.reqmo.inc,v 1.2 2008-09-08 14:45:04 jbastide Exp $
$reqmo['libelle']="destination_shon";
$reqmo['sql']="select [destination_shon],[dossier.dossier as dossier],[etat],
                      to_char(date_depot,'DD/MM/YYYY')as date_depot,
                      [destination.destination as destination],
                      [destination.libelle as destinationlib],
                      [destination_shon.shon as shon],
                      from ".DB_PREFIXE."destination_shon inner join ".DB_PREFIXE."destination on destination.destination = destination_shon.destination
                      inner join ".DB_PREFIXE."dossier on dossier.dossier= destination_shon.dossier
                      order by [tri]";
$reqmo['tri']= array('destination_shon','etat');
$reqmo['destination_shon']="checked";
$reqmo['dossier']="checked";
$reqmo['destination']="checked";
$reqmo['destinationlib']="checked";
$reqmo['shon']="checked";
$reqmo['etat']="checked";
$reqmo['date_depot']="checked";
?>
1	<?php //$Id: destination_shon.reqmo.inc,v 1.2 2008-09-08 14:45:04 jbastide Exp $
2	$reqmo['libelle']="destination_shon";
3	$reqmo['sql']="select [destination_shon],[dossier.dossier as dossier],[etat],
4	to_char(date_depot,'DD/MM/YYYY')as date_depot,
5	[destination.destination as destination],
6	[destination.libelle as destinationlib],
7	[destination_shon.shon as shon],
8	from ".DB_PREFIXE."destination_shon inner join ".DB_PREFIXE."destination on destination.destination = destination_shon.destination
9	inner join ".DB_PREFIXE."dossier on dossier.dossier= destination_shon.dossier
10	order by [tri]";
11	$reqmo['tri']= array('destination_shon','etat');
12	$reqmo['destination_shon']="checked";
13	$reqmo['dossier']="checked";
14	$reqmo['destination']="checked";
15	$reqmo['destinationlib']="checked";
16	$reqmo['shon']="checked";
17	$reqmo['etat']="checked";
18	$reqmo['date_depot']="checked";
19	?>