Subversion Repositories Applications.referentiel

Rev

Rev 51 | Go to most recent revision | Show entire file | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 51 Rev 142
Line 81... Line 81...
81
		
81
		
82
		$donnees = false;
82
		$donnees = false;
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 referentiel_code = $projet ".
86
						"WHERE ".(($projet == "'tout'") ? '' : 'referentiel_code = '.$projet.' AND ') .
87
						"	AND script = $script ".
87
							" script = $script ".
88
						'	AND date_fin IS NULL '.
88
							' AND date_fin IS NULL '.
89
						'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'meta_date_creation  DESC').' '.
89
						'ORDER BY '.((!is_null($this->orderby)) ? $this->orderby  : 'meta_date_creation  DESC').' '.
Line 90... Line 90...
90
						'LIMIT 0,1 ';
90
						'LIMIT 0,1 ';