<?php
function SQL_Get_NewsBoard($nb) {
	$requete= "SELECT news_id, news_title, DATE_FORMAT(news_published_date, '%d-%m-%Y à %T') AS news_published_date_display FROM " . T_NEWS . " WHERE news_statut = 'P' ORDER BY news_published_date DESC LIMIT 0, ".$nb.";";
	
	return $requete;
}
function SQL_Get_SdiBoard() {
  
$requete= "SELECT DISTINCT I.sdii_name, sdiv_id, sdii_id, sdiv_scale, sdiv_date_crea, MAX(sdiv_date_crea) AS date_c_max
			FROM " . T_SDI_INFO . " as I LEFT OUTER JOIN " . T_SDI_VALUE . " as V ON I.sdii_id=V.sdiv_sdi_info
			WHERE sdiv_statut='P' AND sdii_statut='P' GROUP BY I.sdii_name, sdiv_scale ORDER BY date_c_max DESC;";
	//sdiv_sdi_info,,  sdiv_scale
	return $requete;
}
function SQL_Get_FilterTheme() {
	$requete = "SELECT * FROM " . T_SD_THEME . " ORDER BY sdtheme_range, sdtheme_id;";
	return $requete;
}
function SQL_Get_FilterScale($mask=-1) {
	if ($mask<>-1) $mask="OR scale_statut='I'";
	else $mask="";
	$requete= "SELECT * FROM " . T_SCALE . " WHERE scale_statut='P' ".$mask." ORDER BY scale_dependencies ASC, scale_denomination ASC;";
	return $requete;
}
function SQL_Get_FilterLevel() {
	$requete = "SELECT * FROM " . T_LEVEL . " WHERE level_statut='P' ORDER BY level_range DESC;";
	return $requete;
}

function SQL_Get_UserWorkshop($login, $pass) {
	$requete = "SELECT user_id ,  jwu_workshop_id FROM " . T_USER . " As U LEFT OUTER JOIN " . J_WORK_USERS . " As W ON U.user_id=W.jwu_user_id WHERE user_login = BINARY '".$login."' AND user_password='".$pass."' AND user_validity='Y';";
	return $requete;
}

function SQL_Get_LastPublications($nb) {
	$requete = "SELECT publi_id, publi_title, publi_resume  FROM  " . T_PUBLI . " WHERE publi_statut = 'P' ORDER BY publi_published_date DESC LIMIT 0, ".$nb.";";
	return $requete;
}
?>