<?php
// get a user's authorised projects
require_once $_SERVER['DOCUMENT_ROOT'] . '/include/main_func.php';
auth();
$user = $_SESSION['user_id'];
$q = new myQuery("SELECT id, project.user_id, name, notes, perm FROM project\n LEFT JOIN project_user ON project.id=project_id \n WHERE project_user.user_id='{$user}'");
$return['projects'] = $q->get_assoc();
$_SESSION['projects'] = $q->get_one_col('id');
foreach ($return['projects'] as $i => $proj) {
$q = new myQuery("SELECT user.id, firstname, lastname, email, project_user.perm\n FROM project_user \n LEFT JOIN user ON user.id=user_id \n LEFT JOIN project ON project.id=project_id\n WHERE project_id={$proj['id']}\n ORDER BY project.user_id!=user.id, lastname, firstname");
$return['projects'][$i]['owners'] = $q->get_assoc();
}
$q = new myQuery("SELECT id, firstname, lastname, email FROM user");
$return['users'] = $q->get_by_id('id');
function countFilesOO($dir)
{
if (!is_dir($dir)) {
return false;
}
/*
$Directory=new RecursiveDirectoryIterator($dir, FilesystemIterator::SKIP_DOTS);
$Iterator = new RecursiveIteratorIterator($Directory);
$TrashRegex = new RegexIterator($Iterator, '/\/\.trash\//', RecursiveRegexIterator::GET_MATCH);
$trash = iterator_count($TrashRegex);
$TmpRegex = new RegexIterator($Iterator, '/\/\.tmp\//', RecursiveRegexIterator::GET_MATCH);
$tmp = iterator_count($TmpRegex);
$files = iterator_count($Iterator);
//foreach ($Iterator as $filename=>$cur) {
// $size += $cur->getSize();
//}
