sql/pgsql/destination_shon.reqmo.inc.php

<?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],
                      [concat(substring(date_depot,9,2),'/',substring(date_depot,6,2),'/',substring(date_depot,1,4)) as date_depot],
                      [destination.destination as destination],
                      [destination.libelle as destinationlib],
                      [destination_shon.shon as shon],
                      from destination_shon inner join destination on destination.destination = destination_shon.destination
                      inner join 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	[concat(substring(date_depot,9,2),'/',substring(date_depot,6,2),'/',substring(date_depot,1,4)) as date_depot],
5	[destination.destination as destination],
6	[destination.libelle as destinationlib],
7	[destination_shon.shon as shon],
8	from destination_shon inner join destination on destination.destination = destination_shon.destination
9	inner join 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	?>