Subversion Repositories eFlore/Applications.cel

Rev

Rev 1078 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1078 Rev 1277
Line 36... Line 36...
36
			if(isset($uid[1]))
36
			if(isset($uid[1]))
37
			{
37
			{
38
				$criteres = explode("&", $uid[1]) ;
38
				$criteres = explode("&", $uid[1]) ;
39
			}
39
			}
Line 40... Line 40...
40
 
40
 
41
			$query="SELECT identifiant, ordre, nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille, location, id_location, date_observation," .
41
			$query="SELECT id, identifiant, ordre, nom_sel, num_nom_sel, nom_ret, num_nom_ret, num_taxon, famille, location, id_location, date_observation," .
Line 42... Line 42...
42
		           " lieudit, station, milieu, commentaire, transmission, coord_x, coord_y, ref_geo FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."' AND " ;
42
		           " lieudit, station, milieu, commentaire, transmission, coord_x, coord_y, ref_geo FROM cel_inventory WHERE identifiant='".$DB->escapeSimple($uid[0])."' AND " ;
Line 152... Line 152...
152
            $worksheet->write(0,11,'Milieu');
152
            $worksheet->write(0,11,'Milieu');
153
            $worksheet->write(0,12,'Notes');
153
            $worksheet->write(0,12,'Notes');
154
            $worksheet->write(0,13,'Latitude');
154
            $worksheet->write(0,13,'Latitude');
155
            $worksheet->write(0,14,'Longitude');
155
            $worksheet->write(0,14,'Longitude');
156
            $worksheet->write(0,15,'Referentiel Geographique');
156
            $worksheet->write(0,15,'Referentiel Geographique');
-
 
157
            $worksheet->write(0,16,'Ordre');
-
 
158
            $worksheet->write(0,17,'Identifiant');
Line 157... Line 159...
157
 
159
 
158
 
160
 
Line 195... Line 197...
195
                $worksheet->write($i,11,$row['milieu']);
197
                $worksheet->write($i,11,$row['milieu']);
196
                $worksheet->write($i,12,$row['commentaire']);
198
                $worksheet->write($i,12,$row['commentaire']);
197
                $worksheet->write($i,13,$row['coord_x']);
199
                $worksheet->write($i,13,$row['coord_x']);
198
                $worksheet->write($i,14,$row['coord_y']);
200
                $worksheet->write($i,14,$row['coord_y']);
199
                $worksheet->write($i,15,$row['ref_geo']);
201
                $worksheet->write($i,15,$row['ref_geo']);
-
 
202
                $worksheet->write($i,16,$row['ordre']);
-
 
203
                $worksheet->write($i,17,$row['id']);
200
                $i++;
204
                $i++;
201
    	    }
205
    	    }
Line 202... Line 206...
202
 
206