Subversion Repositories Applications.referentiel

Rev

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

Rev 142 Rev 159
Line 83... Line 83...
83 
		if (isset($projet) && isset($script)) {
 83 
		if (isset($projet) && isset($script)) {
84 
			$requete =	($this->distinct ? 'SELECT DISTINCT' : 'SELECT').' * '.
 84 
			$requete =	($this->distinct ? 'SELECT DISTINCT' : 'SELECT').' * '.
85 
						'FROM ref_traitement '.
 85 
						'FROM ref_traitement '.
86 
						"WHERE ".(($projet == "'tout'") ? '' : 'referentiel_code = '.$projet.' AND ') .
 86 
						"WHERE ".(($projet == "'tout'") ? '' : 'referentiel_code = '.$projet.' AND ') .
87 
							" script = $script ".
 87 
							" script = $script ".
- 
 
 88 
							' AND date_debut IS NULL '.
88 
							' AND date_fin IS NULL '.
 89 
							' AND date_fin IS NULL '.
89 
						'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'meta_date_creation  DESC').' '.
 90 
						'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'meta_date_creation  DESC').' '.
90 
						'LIMIT 0,1 ';
 91 
						'LIMIT 0,1 ';
Line 91... Line 92...
91
92