3 * Authorization functions.
5 * LICENSE: This program is free software; you can redistribute it and/or
6 * modify it under the terms of the GNU General Public License
7 * as published by the Free Software Foundation; either version 2
8 * of the License, or (at your option) any later version.
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
13 * You should have received a copy of the GNU General Public License
14 * along with this program. If not, see <http://opensource.org/licenses/gpl-license.php>;.
17 * @author Rod Roark <rod@sunsetsystems.com>
18 * @author Brady Miller <brady@sparmy.com>
19 * @author Kevin Yeh <kevin.y@integralemr.com>
20 * @author ViCarePlus <visolve_emr@visolve.com>
22 * @link http://www.open-emr.org
25 //----------THINGS WE ALWAYS DO
27 require_once("{$GLOBALS['srcdir']}/log.inc");
28 require_once("{$GLOBALS['srcdir']}/sql.inc");
29 // added for the phpGACL group check -- JRM
30 require_once("{$GLOBALS['srcdir']}/acl.inc");
31 require_once("$srcdir/formdata.inc.php");
32 require_once("$srcdir/authentication/login_operations.php");
34 $incoming_site_id = '';
36 if (isset($_GET['auth']) && ($_GET['auth'] == "login") && isset($_POST['authUser']) &&
37 isset($_POST['clearPass']) && isset($_POST['authProvider']))
39 $clearPass=$_POST['clearPass'];
41 if (!empty($_POST['languageChoice'])) {
42 $_SESSION['language_choice'] = $_POST['languageChoice'];
45 $_SESSION['language_choice'] = 1;
47 // set language direction according to language choice. Later in globals.php we'll override main theme name if needed.
48 $_SESSION['language_direction'] = getLanguageDir($_SESSION['language_choice'] );
50 if(!validate_user_password($_POST['authUser'],$clearPass,$_POST['authProvider']) || !verify_user_gacl_group($_POST['authUser']))
52 $_SESSION['loginfailure'] = 1;
55 //If password expiration option is enabled call authCheckExpired() to check whether login user password is expired or not
57 if($GLOBALS['password_expiration_days'] != 0){
58 if(authCheckExpired($_POST['authUser']))
63 $ip=$_SERVER['REMOTE_ADDR'];
64 $_SESSION['loginfailure'] = null;
65 unset($_SESSION['loginfailure']);
66 //store the very first initial timestamp for timeout errors
67 $_SESSION["last_update"] = time();
69 else if ( (isset($_GET['auth'])) && ($_GET['auth'] == "logout") )
71 newEvent("logout", $_SESSION['authUser'], $_SESSION['authProvider'], 1, "success");
73 authLoginScreen(true);
77 if (authCheckSession())
79 if (isset($_SESSION['pid']) && empty($GLOBALS['DAEMON_FLAG']))
81 require_once("{$GLOBALS['srcdir']}/patient.inc");
83 $logpatient = getPatientData($_SESSION['pid'], "lname, fname, mname");
84 newEvent("view", $_SESSION['authUser'], $_SESSION['authProvider'],
85 "{$logpatient['lname']}, {$logpatient['fname']} {$logpatient['mname']} :: encounter " .
86 $_SESSION['encounter']);
90 //newEvent("view", $_SESSION['authUser'], $_SESSION['authProvider'], $_SERVER['REQUEST_URI']);
93 newEvent("login",$_POST['authUser'], $_POST['authProvider'], 0, "insufficient data sent");
98 if (!isset($_SESSION["last_update"])) {
101 //if page has not been updated in a given period of time, we call login screen
102 //--Note can't perform nice logout if skip_timeout_reset is set since these are called
103 //via ajax scripts where this output is not getting sent to browser.
104 //--Note DAEMON_FLAG is ok because it is run from a frame in the browser.
105 if ( ((time() - $_SESSION["last_update"]) > $timeout) && empty($_REQUEST['skip_timeout_reset']) ) {
106 newEvent("logout", $_SESSION['authUser'], $_SESSION['authProvider'], 0, "timeout");
108 authLoginScreen(true);
110 // Have a mechanism to skip the timeout reset mechanism if a skip_timeout_reset parameter exists. This
111 // can be used by scripts that continually request information from the server; for example the Messages
112 // and Reminders automated intermittent requests that happen in the Messages Center script and in
113 // the left navigation menu script.
114 if (empty($GLOBALS['DAEMON_FLAG']) && empty($_REQUEST['skip_timeout_reset'])) $_SESSION["last_update"] = time();
120 //----------THINGS WE DO IF WE STILL LIKE YOU
122 function authCheckSession ()
124 if (isset($_SESSION['authId'])) {
125 $authDB = privQuery("select ".implode(",",array(TBL_USERS.".".COL_ID,
126 TBL_USERS.".".COL_UNM,
127 TBL_USERS_SECURE.".".COL_PWD,
128 TBL_USERS_SECURE.".".COL_ID))
129 . " FROM ". implode(",",array(TBL_USERS,TBL_USERS_SECURE))
130 . " WHERE ". TBL_USERS.".".COL_ID." = ? "
131 . " AND ". TBL_USERS.".".COL_UNM . "=" . TBL_USERS_SECURE.".".COL_UNM
132 . " AND ". TBL_USERS.".".COL_ACTIVE . "=1"
133 ,array($_SESSION['authId']));
134 if ($_SESSION['authUser'] == $authDB['username']
135 && $_SESSION['authPass'] == $authDB['password'] )
148 function authCloseSession ()
150 // Before destroying the session, save its site_id so that the next
151 // login will default to that same site.
152 global $incoming_site_id;
153 $incoming_site_id = $_SESSION['site_id'];
157 unset($_COOKIE[session_name()]);
160 function authLoginScreen($timed_out = false)
162 // See comment in authCloseSession().
163 global $incoming_site_id;
166 // Find the top level window for this instance of OpenEMR, set a flag indicating
167 // session timeout has occurred, and reload the login page into it. This is so
168 // that beforeunload event handlers will not obstruct the process in this case.
170 while (w.opener) { // in case we are in a dialog window
175 <?php if ($timed_out) { ?>
176 w.top.timed_out = true;
178 w.top.location.href = '<?php echo "{$GLOBALS['login_screen']}?error=1&site=$incoming_site_id"; ?>';
184 // Check if the user's password has expired beyond the grace limit.
185 // If so, deactivate the user
186 function authCheckExpired($user)
188 $result = sqlStatement("select pwd_expiration_date from users where username = ?",array($user));
189 if($row = sqlFetchArray($result))
191 $pwd_expires = $row['pwd_expiration_date'];
193 $current_date = date("Y-m-d");
194 if($pwd_expires != "0000-00-00")
196 $grace_time1 = date("Y-m-d", strtotime($pwd_expires . "+".$GLOBALS['password_grace_time'] ."days"));
198 if(($grace_time1 != "") && strtotime($current_date) > strtotime($grace_time1))
200 sqlStatement("update users set active=0 where username = ?",array($user));
201 $_SESSION['loginfailure'] = 1;
207 function getUserList ($cols = '*', $limit = 'all', $start = '0')
210 $rez = sqlStatement("select $cols from users where username != '' order by date DESC");
212 $rez = sqlStatement("select $cols from users where username != '' order by date DESC limit $limit, $start");
213 for ($iter = 0; $row = sqlFetchArray($rez); $iter++)
218 function getProviderList ($cols = '*', $limit= 'all', $start = '0')
221 $rez = sqlStatement("select $cols from groups order by date DESC");
223 $rez = sqlStatement("select $cols from groups order by date DESC limit $limit, $start");
224 for ($iter = 0; $row = sqlFetchArray($rez); $iter++)
229 function addGroup ($groupname)
231 return sqlInsert("insert into groups (name) values (?)", array($groupname));
234 function delGroup ($group_id)
236 return sqlQuery("delete from groups where id = ? limit 0,1", array($group_id));
239 /***************************************************************
241 //Function currently user by new post calendar code to determine
242 //if a given user is in a group with another user
243 //and if so to allow editing of that users events
245 //*************************************************************/
247 function validateGroupStatus ($user_to_be_checked, $group_user) {
248 if (isset($user_to_be_checked) && isset($group_user)) {
249 if ($user_to_be_checked == $group_user) {
253 elseif ($_SESSION['authorizeduser'] == 1)
256 $query = "SELECT groups.name FROM users,groups WHERE users.username = ? " .
257 "AND users.username = groups.user group by groups.name";
258 $result = sqlStatement($query, array($user_to_be_checked));
260 $usertbcGroups = array();
262 while ($row = sqlFetchArray($result)) {
263 $usertbcGroups[] = $row[0];
266 $query = "SELECT groups.name FROM users,groups WHERE users.username = ? " .
267 "AND users.username = groups.user group by groups.name";
268 $result = sqlStatement($query, array($group_user));
270 $usergGroups = array();
272 while ($row = sqlFetchArray($result)) {
273 $usergGroups[] = $row[0];
275 foreach ($usertbcGroups as $group) {
276 if(in_array($group,$usergGroups)) {
287 // Attempt to update the user's password, password history, and password expiration.
288 // Verify that the new password does not match the last three passwords used.
289 // Return true if successfull, false on failure
290 function UpdatePasswordHistory($userid,$pwd)
292 $result = sqlStatement("select password, pwd_history1, pwd_history2 from users where id = ?",array($userid));
293 if ($row = sqlFetchArray($result)) {
294 $previous_pwd1=$row['password'];
295 $previous_pwd2=$row['pwd_history1'];
296 $previous_pwd3=$row['pwd_history2'];
298 if (($pwd != $previous_pwd1) && ($pwd != $previous_pwd2) && ($pwd != $previous_pwd3)) {
299 sqlStatement("update users set pwd_history2=?, pwd_history1=?,password=? where id=?",array($previous_pwd2,$previous_pwd1,$pwd,$userid));
300 if($GLOBALS['password_expiration_days'] != 0){
301 $exp_days=$GLOBALS['password_expiration_days'];
302 $exp_date = date('Y-m-d', strtotime("+$exp_days days"));
303 sqlStatement("update users set pwd_expiration_date=? where id=?",array($exp_date,$userid));