Subversion Repositories eFlore/Projets.eflore-projets

Rev

Rev 1243 | Rev 1245 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 1243 Rev 1244
Line 261... Line 261...
261 
			$count,
 261 
			$count,
262 
			$this->limite_requete['limite']
 262 
			$this->limite_requete['limite']
263 
		);
 263 
		);
264 
        $req = sprintf(
 264 
        $req = sprintf(
265 
            'SELECT %s, group_concat(num_taxon) as num_taxon, IF(num_statut="",1,0) AS is_null' .
 265 
            'SELECT %s, group_concat(num_taxon) as num_taxon, IF(num_statut="",1,0) AS is_null' .
266 
            ' FROM %s WHERE %s GROUP BY id ORDER BY is_null ASC, num_statut ASC, %s %s -- %s:%d',
 266 
            ' FROM %s WHERE %s GROUP BY id ORDER BY is_null ASC, num_statut ASC %s %s -- %s:%d',
Line 267... Line 267...
267 
 
 267 
 
268 
            in_array('*', $this->requete_champ) ? ' * ' : implode(', ', $this->requete_champ),
 268 
            in_array('*', $this->requete_champ) ? ' * ' : implode(', ', $this->requete_champ),
269 
            $this->table,
 269 
            $this->table,
270 
            $this->requete_condition ? implode(' AND ', $this->requete_condition) : 'TRUE',
 270 
            $this->requete_condition ? implode(' AND ', $this->requete_condition) : 'TRUE',
271 
			$this->tri ? ($this->tri . ' ' . $this->tri_ordre . ' ') : '',
 271 
			$this->tri ? (', '.$this->tri . ' ' . $this->tri_ordre . ' ') : '',
272 
            $limiteClause,
 272 
            $limiteClause,
273 
            __FILE__, __LINE__);
 273 
            __FILE__, __LINE__);
274 
		return $req;
 274 
		return $req;
Line 288... Line 288...
288 
                $count,
 288 
                $count,
289 
                $this->limite_requete['limite']);
 289 
                $this->limite_requete['limite']);
290 
        }
 290 
        }
291 
        $req = sprintf(
 291 
        $req = sprintf(
292 
            'SELECT %s, IF(num_statut="",1,0) AS is_null' .
 292 
            'SELECT %s, IF(num_statut="",1,0) AS is_null' .
293 
            ' FROM %s WHERE %s ORDER BY is_null ASC, num_statut ASC, %s %s -- %s:%d',
 293 
            ' FROM %s WHERE %s ORDER BY is_null ASC, num_statut ASC %s %s -- %s:%d',
Line 294... Line 294...
294 
 
 294 
 
295 
            in_array('*', $this->requete_champ) ? ' * ' : implode(', ', $this->requete_champ),
 295 
            in_array('*', $this->requete_champ) ? ' * ' : implode(', ', $this->requete_champ),
296 
            $this->table,
 296 
            $this->table,
297 
            $this->requete_condition ? implode(' AND ', $this->requete_condition) : 'TRUE',
 297 
            $this->requete_condition ? implode(' AND ', $this->requete_condition) : 'TRUE',
298 
			$this->tri ? ($this->tri . ' ' . $this->tri_ordre . ' ') : '',
 298 
			$this->tri ? (', '.$this->tri . ' ' . $this->tri_ordre . ' ') : '',
299 
            $nolimit ? '' : $limiteClause,
 299 
            $nolimit ? '' : $limiteClause,
300 
            __FILE__, __LINE__);
 300 
            __FILE__, __LINE__);
301 
		return $req;
 301 
		return $req;