/
profile.php
89 lines (77 loc) · 4.97 KB
/
profile.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
<?php
/********************************************************************************
* This file is part of eLabChem (http://github.com/martinp23/elabchem) *
* Copyright (c) 2013 Martin Peeks (martinp23@googlemail.com) *
* *
* eLabChem is free software: you can redistribute it and/or modify *
* it under the terms of the GNU Affero General Public License as *
* published by the Free Software Foundation, either version 3 of *
* the License, or (at your option) any later version. *
* *
* eLabChem is distributed in the hope that it will be useful, *
* but WITHOUT ANY WARRANTY; without even the implied *
* warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR *
* PURPOSE. See the GNU Affero General Public License for more details. *
* *
* You should have received a copy of the GNU Affero General Public *
* License along with eLabChem. If not, see <http://www.gnu.org/licenses/>. *
* *
* eLabChem is a fork of elabFTW. This file incorporates work covered by the *
* copyright notice below. *
* *
********************************************************************************/
/********************************************************************************
* *
* Copyright 2012 Nicolas CARPi (nicolas.carpi@gmail.com) *
* http://www.elabftw.net/ *
* *
********************************************************************************/
/********************************************************************************
* This file is part of eLabFTW. *
* *
* eLabFTW is free software: you can redistribute it and/or modify *
* it under the terms of the GNU Affero General Public License as *
* published by the Free Software Foundation, either version 3 of *
* the License, or (at your option) any later version. *
* *
* eLabFTW is distributed in the hope that it will be useful, *
* but WITHOUT ANY WARRANTY; without even the implied *
* warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR *
* PURPOSE. See the GNU Affero General Public License for more details. *
* *
* You should have received a copy of the GNU Affero General Public *
* License along with eLabFTW. If not, see <http://www.gnu.org/licenses/>. *
* *
********************************************************************************/
require_once('inc/common.php');
$page_title = 'Profile';
require_once('inc/head.php');
require_once('inc/menu.php');
// SQL to get number of experiments
$sql = "SELECT COUNT(*) FROM experiments WHERE userid_creator = ".$_SESSION['userid'] . " AND status <> 'deleted'";
$req = $bdd->prepare($sql);
$req->execute();
$countdone = $req->fetch();
$sql = "SELECT COUNT(*) FROM experiments WHERE userid_creator = ".$_SESSION['userid'] . " AND status = 'deleted'";
$req = $bdd->prepare($sql);
$req->execute();
$countdeleted = $req->fetch();
// SQL for profile
$sql = "SELECT * FROM users WHERE userid = ".$_SESSION['userid'];
$req = $bdd->prepare($sql);
$req->execute();
$data = $req->fetch();
echo "<section class='item'>";
echo "<img src='themes/".$_SESSION['prefs']['theme']."/img/user.png' alt='' /> <h4>INFOS</h4>";
echo "<div class='center'>
<p>".$data['firstname']." ".$data['lastname']." (".$data['email'].")</p>
<p>".$countdone[0]." experiments done and {$countdeleted[0]} deleted since ".date("l jS \of F Y", $data['register_date']);
if($data['group'] == 'admin') {echo "<p>You ARE admin \o/</p>";}
if($data['group'] === 'journalclub') {echo "<p>You ARE responsible of the <a href='journal-club.php'>Journal Club</a> !</p>";}
echo "</div>";
echo "<hr>";
require_once('inc/statistics.php');
echo "<hr>";
require_once('inc/tagcloud.php');
echo "</section>";
require_once('inc/footer.php');