public function changeClient($idProject, $id_from, $id_to, $csrf)
{
if (Session::get('csrf') != Helper::get('csrf')) {
Router::url('home.index');
}
if (!Session::exists('member')) {
Router::redirect('home.index');
}
$member = Session::get('member');
$other = $id_from;
if ($member['id'] == $other) {
$other = $id_to;
}
$project = Projects::select()->where('id', $idProject)->andWhere('id_leader', $member['id'])->get(0, 1);
if (empty($project)) {
Router::url('home.index');
}
$project = $project[0];
if ($project->id_leader != $member['id']) {
Router::url('home.index');
}
$project->id_client = intval($other);
$project->save();
Session::setFlash('success', '', 'Le projet à un nouveau client');
Router::redirect('task:project.detail', ['id' => $idProject]);
}
public function verify($key)
{
//Users::redirectIf(true);
$users = Users::select()->where('mail_check', $key)->andWhere('TIMESTAMPDIFF(MINUTE, mail_check_at, NOW())', '<', 30, false)->get();
if (!empty($users)) {
$user = $users[0];
$user->mail_check = '1';
$user->save();
}
$users = Users::select()->where('mail_check', '!=', '1')->andWhere('TIMESTAMPDIFF(MINUTE, mail_check_at, NOW())', '>', 35, false)->get();
foreach ($users as $user) {
$user->delete();
}
Session::setFlash('success', '', Translate::get('user.success.register_mail'));
Router::redirect('home.index');
}
public function delete($id, $csrf)
{
$this->checker('update_full_admin');
if (Session::get('csrf') != $csrf) {
Router::redirect('home.index');
}
$group = Groups::select()->where('id', $id)->get();
if (empty($group)) {
Router::redirect('home.index');
}
$countGroup = Groups::select()->addFields(['COUNT(*)' => 'nb'])->get();
$countGroup = intval($countGroup[0]->nb);
if ($countGroup > 1) {
$group = $group[0];
$group->delete();
$firstGroup = Groups::select()->addFields('id')->get(0, 1);
$firstGroup = $firstGroup[0];
$users = Users::select()->where('id_group', $id)->get();
if (!empty($users)) {
foreach ($users as $user) {
$user->id_group = $firstGroup->id;
$user->save();
}
}
} else {
Session::setFlash('danger', '', 'Il ne reste que 1 seul groupe donc on ne peut pas le supprimer');
}
Router::redirect('admin:group.show');
}
public function newPassword()
{
Users::redirectIf(true);
try {
$user = Users::findOrFail('mail', Helper::post('mail'));
$pass = Config::randomString(8);
$user->password = password_hash($pass, PASSWORD_BCRYPT);
$user->save();
Users::resendPassword($user, $pass);
} catch (\Exception $e) {
Session::setFlash('danger', '', 'Aucun compte trouvée avec cette adresse email !');
}
Router::redirect('user.signin');
}
public function delete($id)
{
Users::redirectIf(false);
$member = Session::get('member');
$project = Projects::find('id', $id);
if ($project->id_leader != $member['id']) {
Router::redirect('task:home.index');
}
$project->delete();
Session::setFlash('success', '', 'Vous avez supprimé le projet !');
Router::redirect('task:home.index');
}
