*/
include("session.php");
require_once("class_functions.php");
require_once("class_folders.php");
require_once("class_db.php");
require_once("class_letterbox.php");
$func = new functions();
$folders = new folders();
$conn = new dbquery();
$conn->connect();
$db = new dbquery();
$db->connect();
$conn2 = new dbquery();
$conn2->connect();
if(file_exists($_SESSION['config']['lang'].'.php'))
{
include($_SESSION['config']['lang'].'.php');
}
else
{
$_SESSION['error'] = "Language file missing...
";
}
/*Modifier cette requete pour avoir la liste des plans de classement partagés*/
$value = "'".$_SESSION['user']['services'][0]['ID']."'";
for ($cpt=1; $cpt < count($_SESSION['user']['services']); $cpt++)
{
$value = $value.", '".$_SESSION['user']['services'][$cpt]['ID']."'";
}
$conn->query("SELECT * FROM ".$_SESSION['tablename']['folderscope']." fds, ".$_SESSION['tablename']['folders']." fol, ".$_SESSION['tablename']['fileplans']." fil
WHERE fds.folder_id = fol.folder_id"
." AND fil.fileplan_id = fol.fileplan_id"
." AND fol.shared_folder = 'Y'"
." AND ((scope = 'user' AND value = '".$_SESSION['user']['UserId']."')"
." OR (scope = 'all')"
." OR (scope = 'entity' AND value in (".$value."))"
." OR (scope = 'entities' AND value in (".$value.")))"
." GROUP BY fol.folder_id, fileplan_description"
." ORDER BY fileplan_description");
$myFileplans = array();
while($line = $conn->fetch_object())
{
$myFileplans[$line->FILEPLAN_ID] = $line->FILEPLAN_DESCRIPTION;
}
//$conn->query("SELECT * FROM ".$_SESSION['tablename']['folders']." fol, ".$_SESSION['tablename']['fileplans']." fil, ".$_SESSION['tablename']['folderscope']." fds, ".$_SESSION['tablename']['users']." us WHERE (fds.VALUE = '*' OR fds.VALUE = 'us.DEPARTMENT' OR fds.VALUE = 'us.USER_ID') AND (fds.FOLDER_ID = fol.FOLDER_ID AND fol.USER_ID = us.USER_ID AND fil.FILEPLAN_ID = fol.FILEPLAN_ID AND us.USER_ID = '".$_SESSION['user']['UserId']."') ORDER BY fil.FILEPLAN_ID, fol.FOLDER_ID");
//The Fileplan
if(isset($_GET['id']) && !empty($_GET['id']))
{
$fileplanId = addslashes($func->wash($_GET['id'], "no", _FILEPLAN));
}
else
{
$fileplanId = "";
}
//The folder
if(isset($_REQUEST['folder_id']))
{
$folderId = addslashes($func->wash($_REQUEST['folder_id'], "no", _THE_FOLDER));
}
else
{
$folderId = "";
}
//Verifier si le plan appartient a l'utilisateur courant (sauf administrateur)
if (isset($line->FILEPLAN_ID) && ($folders->fileplanOwner($line->FILEPLAN_ID, $_SESSION['user']['UserId']) === false))
{
echo $line->FILEPLAN_ID;
$_SESSION['error'] = _UNKNOWN_PARAM;
echo '';
exit;
}
//exit;
//$func->show_array($myFileplans);
//$func->show_array($_SESSION['user']);
?>
