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],
                      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	fraynaud	3	<?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	fraynaud	200	to_char(date_depot,'DD/MM/YYYY')as date_depot,
5	fraynaud	3	[destination.destination as destination],
6			[destination.libelle as destinationlib],
7			[destination_shon.shon as shon],
8	fraynaud	250	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	fraynaud	3	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			?>