public static function actionDisplayNextTable()
{
if (isset($_GET['t']) && $_GET['t']) {
$table = $_GET['t'];
$filter = array();
if (isset($_GET['s']) && $_GET['s'] && $_GET['s'] != null && $_GET['s'] != 'null') {
$search = $_GET['s'];
} else {
$search = null;
}
if (isset($_GET['i']) && $_GET['i']) {
$currentEntityId = $_GET['i'];
} else {
$currentEntityId = null;
}
if ($table == 'customers' && ControleurRights::canAddCustomer()) {
if ($search != null) {
$filter[] = Customer::getFilter(CustomerColumns::last_name, $search);
}
return ControleurCRUD::getNextTable('Customer', $currentEntityId, CustomerColumns::last_name, $filter, false);
} elseif ($table == 'team_member' && ControleurRights::canAddTeamMember()) {
$team = ControleurCRUD::getNextTable('TeamMember', $currentEntityId, TeamMemberColumns::id, $filter, false);
return ControleurAdministration::actionDisplayNextTableTeamMember($team);
} elseif ($table == 'users' && ControleurRights::canAddUser()) {
if ($search != null) {
$filter[] = User::getFilter(UserColumns::last_name, $search);
}
$users = ControleurCRUD::getNextTable('User', $currentEntityId, UserColumns::last_name, $filter, false);
if (count($users) > 0) {
foreach ($users as $user) {
$user->setPicture();
}
}
return $users;
} elseif ($table == 'projects' && ControleurRights::canDisplayProjects()) {
if ($search != null) {
$filter[] = User::getFilter(ProjectColumns::name, $search);
}
return ControleurCRUD::getNextTable('Project', $currentEntityId, ProjectColumns::created_timestamp, $filter, true);
} elseif ($table == 'plans' && ControleurRights::canDisplayPlans()) {
if ($search != null) {
$filter[] = User::getFilter(ProjectColumns::name, $search);
}
if (isset($_GET['p']) && $_GET['p']) {
$filter[] = Plan::getFilter(PlanColumns::id_project, $_GET['p']);
}
return ControleurCRUD::getNextTable('Plan', $currentEntityId, PlanColumns::created_timestamp, $filter, true);
} elseif ($table == 'skills' && ControleurRights::canAddSkills()) {
if ($search != null) {
$filter[] = User::getFilter(SkillColumns::name, $search);
}
return ControleurCRUD::getNextTable('Skill', $currentEntityId, SkillColumns::name, $filter, true);
} else {
return "Table " . $table . " non configurée dans le CRUD ou interdiction d'accès à l'utilisateur";
}
}
}
public static function actionDisplayAllProjectPublic()
{
if (isset($_GET['t']) && $_GET['t']) {
$filter = array();
if (isset($_GET['s']) && $_GET['s'] && $_GET['s'] != null && $_GET['s'] != 'null') {
$search = $_GET['s'];
} else {
$search = null;
}
if (isset($_GET['i']) && $_GET['i']) {
$currentEntityId = $_GET['i'];
} else {
$currentEntityId = null;
}
if ($search != null) {
$filter[] = User::getFilter(ProjectColumns::name, $search);
}
$order[] = Project::getSorter(ProjectColumns::name, false);
return Project::getEntitySet($filter, $order, 0, 9999999999);
}
}
public static function actionDisplayAllSkillsPublic()
{
if (isset($_GET['t']) && $_GET['t']) {
$filter = array();
if (isset($_GET['s']) && $_GET['s'] && $_GET['s'] != null && $_GET['s'] != 'null') {
$search = $_GET['s'];
} else {
$search = null;
}
if (isset($_GET['i']) && $_GET['i']) {
$currentEntityId = $_GET['i'];
} else {
$currentEntityId = null;
}
if ($search != null) {
$filter[] = User::getFilter(SkillColumns::name, $search);
}
$order[] = Skill::getSorter(SkillColumns::name, false);
$skills = Skill::getEntitySet($filter, $order, 0, 9999999999);
if (count($skills) > 0) {
foreach ($skills as $skill) {
$skill->setProjects(Skill::getProjectsForSkill($skill->getId()));
}
}
return $skills;
}
}
public static function getCurrentUser()
{
if (!defined('CURRENT_VIEW')) {
define('CURRENT_VIEW', 'desktop');
}
$cache = ControleurConnexionCache::getInstance();
if (defined('CURRENT_VIEW') && CURRENT_VIEW == 'mobile') {
if (isset($_POST['current_id_alternatif']) && $_POST['current_id_alternatif'] != '') {
if ($cache->getCurrent_salt() != null && $cache->getCurrent_salt() == $_POST['current_id_alternatif']) {
return $cache->getCurrent_user();
} else {
$filter = User::getFilter(UserColumns::password, $_POST['current_id_alternatif']);
$user = User::getEntitySet($filter);
if ($user && count($user) > 0) {
$user = $user[0];
$cache->setCurrent_user($user->getId());
$cache->setCurrent_salt($_POST['current_id_alternatif']);
return $user->getId();
} else {
return false;
}
}
}
if (isset($_POST['current_id']) && $_POST['current_id'] != '') {
if ($cache->getCurrent_salt() != null && $cache->getCurrent_salt() == $_POST['current_id']) {
return $cache->getCurrent_user();
} else {
$filter[] = User::getFilter(UserColumns::password, $_POST['current_id']);
$user = User::getEntitySet($filter);
if ($user && count($user) > 0) {
$user = $user[0];
$cache->setCurrent_user($user->getId());
$cache->setCurrent_salt($_POST['current_id']);
return $user->getId();
} else {
return false;
}
}
}
} else {
if (isset($_COOKIE['compte_alternatif']) && $_COOKIE['compte_alternatif'] != '') {
if ($cache->getCurrent_salt() != null && $cache->getCurrent_salt() == $_COOKIE['compte_alternatif']) {
return $cache->getCurrent_user();
} else {
$filter = User::getFilter(UserColumns::password, $_COOKIE['compte_alternatif']);
$user = User::getEntitySet($filter);
if ($user && count($user) > 0) {
$user = $user[0];
$cache->setCurrent_user($user->getId());
$cache->setCurrent_salt($_POST['compte_alternatif']);
return $user->getId();
} else {
return false;
}
}
}
if (isset($_COOKIE['compte']) && $_COOKIE['compte'] != '') {
if ($cache->getCurrent_salt() != null && $cache->getCurrent_salt() == $_COOKIE['compte']) {
return $cache->getCurrent_user();
} else {
$filter = User::getFilter(UserColumns::password, $_COOKIE['compte']);
$user = User::getEntitySet($filter);
if ($user && count($user) > 0) {
$user = $user[0];
$cache->setCurrent_user($user->getId());
$cache->setCurrent_salt($_POST['compte']);
return $user->getId();
} else {
return false;
}
}
}
}
}
