migrated ubiquitous libraries to composer autoloader (#421)
[openemr.git] / interface / usergroup / user_admin.php
blob76c86e485dec2fbc99da7664f8db4f95d5630f2f
1 <?php
2 // This program is free software; you can redistribute it and/or
3 // modify it under the terms of the GNU General Public License
4 // as published by the Free Software Foundation; either version 2
5 // of the License, or (at your option) any later version.
6 require_once("../globals.php");
7 require_once("../../library/acl.inc");
8 require_once("$srcdir/sql.inc");
9 require_once("$srcdir/calendar.inc");
10 require_once("$srcdir/options.inc.php");
11 require_once("$srcdir/erx_javascript.inc.php");
13 if (!$_GET["id"] || !acl_check('admin', 'users'))
14 exit();
16 if ($_GET["mode"] == "update") {
17 if ($_GET["username"]) {
18 // $tqvar = addslashes(trim($_GET["username"]));
19 $tqvar = trim(formData('username','G'));
20 $user_data = sqlFetchArray(sqlStatement("select * from users where id={$_GET["id"]}"));
21 sqlStatement("update users set username='$tqvar' where id={$_GET["id"]}");
22 sqlStatement("update groups set user='$tqvar' where user='". $user_data["username"] ."'");
23 //echo "query was: " ."update groups set user='$tqvar' where user='". $user_data["username"] ."'" ;
25 if ($_GET["taxid"]) {
26 $tqvar = formData('taxid','G');
27 sqlStatement("update users set federaltaxid='$tqvar' where id={$_GET["id"]}");
29 if ($_GET["drugid"]) {
30 $tqvar = formData('drugid','G');
31 sqlStatement("update users set federaldrugid='$tqvar' where id={$_GET["id"]}");
33 if ($_GET["upin"]) {
34 $tqvar = formData('upin','G');
35 sqlStatement("update users set upin='$tqvar' where id={$_GET["id"]}");
37 if ($_GET["npi"]) {
38 $tqvar = formData('npi','G');
39 sqlStatement("update users set npi='$tqvar' where id={$_GET["id"]}");
41 if ($_GET["taxonomy"]) {
42 $tqvar = formData('taxonomy','G');
43 sqlStatement("update users set taxonomy = '$tqvar' where id= {$_GET["id"]}");
45 if ($_GET["lname"]) {
46 $tqvar = formData('lname','G');
47 sqlStatement("update users set lname='$tqvar' where id={$_GET["id"]}");
49 if ($_GET["job"]) {
50 $tqvar = formData('job','G');
51 sqlStatement("update users set specialty='$tqvar' where id={$_GET["id"]}");
53 if ($_GET["mname"]) {
54 $tqvar = formData('mname','G');
55 sqlStatement("update users set mname='$tqvar' where id={$_GET["id"]}");
57 if ($_GET["facility_id"]) {
58 $tqvar = formData('facility_id','G');
59 sqlStatement("update users set facility_id = '$tqvar' where id = {$_GET["id"]}");
60 //(CHEMED) Update facility name when changing the id
61 sqlStatement("UPDATE users, facility SET users.facility = facility.name WHERE facility.id = '$tqvar' AND users.id = {$_GET["id"]}");
62 //END (CHEMED)
64 if ($GLOBALS['restrict_user_facility'] && $_GET["schedule_facility"]) {
65 sqlStatement("delete from users_facility
66 where tablename='users'
67 and table_id={$_GET["id"]}
68 and facility_id not in (" . implode(",", $_GET['schedule_facility']) . ")");
69 foreach($_GET["schedule_facility"] as $tqvar) {
70 sqlStatement("replace into users_facility set
71 facility_id = '$tqvar',
72 tablename='users',
73 table_id = {$_GET["id"]}");
76 if ($_GET["fname"]) {
77 $tqvar = formData('fname','G');
78 sqlStatement("update users set fname='$tqvar' where id={$_GET["id"]}");
80 //(CHEMED) Calendar UI preference
81 if ($_GET["cal_ui"]) {
82 $tqvar = formData('cal_ui','G');
83 sqlStatement("update users set cal_ui = '$tqvar' where id = {$_GET["id"]}");
85 // added by bgm to set this session variable if the current user has edited
86 // their own settings
87 if ($_SESSION['authId'] == $_GET["id"]) {
88 $_SESSION['cal_ui'] = $tqvar;
91 //END (CHEMED) Calendar UI preference
93 if (isset($_GET['default_warehouse'])) {
94 sqlStatement("UPDATE users SET default_warehouse = '" .
95 formData('default_warehouse','G') .
96 "' WHERE id = '" . formData('id','G') . "'");
99 if (isset($_GET['irnpool'])) {
100 sqlStatement("UPDATE users SET irnpool = '" .
101 formData('irnpool','G') .
102 "' WHERE id = '" . formData('id','G') . "'");
105 if ($_GET["newauthPass"] && $_GET["newauthPass"] != "d41d8cd98f00b204e9800998ecf8427e") { // account for empty
106 $tqvar = formData('newauthPass','G');
107 sqlStatement("update users set password='$tqvar' where id={$_GET["id"]}");
110 $tqvar = $_GET["authorized"] ? 1 : 0;
111 $actvar = $_GET["active"] ? 1 : 0;
112 $calvar = $_GET["calendar"] ? 1 : 0;
114 sqlStatement("UPDATE users SET authorized = $tqvar, active = $actvar, " .
115 "calendar = $calvar, see_auth = '" . $_GET['see_auth'] . "' WHERE " .
116 "id = {$_GET["id"]}");
118 if ($_GET["comments"]) {
119 $tqvar = formData('comments','G');
120 sqlStatement("update users set info = '$tqvar' where id = {$_GET["id"]}");
123 if (isset($phpgacl_location) && acl_check('admin', 'acl')) {
124 // Set the access control group of user
125 $user_data = sqlFetchArray(sqlStatement("select username from users where id={$_GET["id"]}"));
126 set_user_aro($_GET['access_group'], $user_data["username"],
127 formData('fname','G'), formData('mname','G'), formData('lname','G'));
130 /*Dont move usergroup_admin (1).php just close window
131 // On a successful update, return to the users list.
132 include("usergroup_admin.php");
133 exit(0);
134 */ echo '
135 <script type="text/javascript">
136 <!--
137 parent.$.fn.fancybox.close();
138 //-->
139 </script>
144 $res = sqlStatement("select * from users where id=?",array($_GET["id"]));
145 for ($iter = 0;$row = sqlFetchArray($res);$iter++)
146 $result[$iter] = $row;
147 $iter = $result[0];
150 if (isset($_POST["mode"])) {
151 echo '
152 <script type="text/javascript">
153 <!--
154 parent.$.fn.fancybox.close();
155 //-->
156 </script>
164 <html>
165 <head>
167 <link rel="stylesheet" href="<?php echo $css_header; ?>" type="text/css">
168 <script type="text/javascript" src="../../library/dialog.js?v=<?php echo $v_js_includes; ?>"></script>
169 <script type="text/javascript" src="<?php echo $GLOBALS['assets_static_relative'] ?>/jquery-min-1-9-1/index.js"></script>
170 <script type="text/javascript" src="../../library/js/common.js"></script>
172 <script src="checkpwd_validation.js" type="text/javascript"></script>
174 <!-- validation library -->
175 <!--//Not lbf forms use the new validation, please make sure you have the corresponding values in the list Page validation-->
176 <?php $use_validate_js = 1;?>
177 <?php require_once($GLOBALS['srcdir'] . "/validation/validation_script.js.php"); ?>
178 <?php
179 //Gets validation rules from Page Validation list.
180 //Note that for technical reasons, we are bypassing the standard validateUsingPageRules() call.
181 $collectthis = collectValidationPageRules("/interface/usergroup/user_admin.php");
182 if (empty($collectthis)) {
183 $collectthis = "undefined";
185 else {
186 $collectthis = $collectthis["user_form"]["rules"];
190 <script language="JavaScript">
193 * validation on the form with new client side validation (using validate.js).
194 * this enable to add new rules for this form in the pageValidation list.
195 * */
196 var collectvalidation = <?php echo($collectthis); ?>;
198 function checkChange()
200 alert("<?php echo addslashes(xl('If you change e-RX Role for ePrescription, it may affect the ePrescription workflow. If you face any difficulty, contact your ePrescription vendor.'));?>");
202 function submitform() {
204 var valid = submitme(1, undefined, 'user_form', collectvalidation);
205 if (!valid) return;
207 top.restoreSession();
208 var flag=0;
210 if(document.forms[0].clearPass.value!="")
212 //Checking for the strong password if the 'secure password' feature is enabled
213 if(document.forms[0].secure_pwd.value == 1)
215 var pwdresult = passwordvalidate(document.forms[0].clearPass.value);
216 if(pwdresult == 0) {
217 flag=1;
218 alert("<?php echo xl('The password must be at least eight characters, and should'); echo '\n'; echo xl('contain at least three of the four following items:'); echo '\n'; echo xl('A number'); echo '\n'; echo xl('A lowercase letter'); echo '\n'; echo xl('An uppercase letter'); echo '\n'; echo xl('A special character');echo '('; echo xl('not a letter or number'); echo ').'; echo '\n'; echo xl('For example:'); echo ' healthCare@09'; ?>");
219 return false;
223 }//If pwd null ends here
224 //Request to reset the user password if the user was deactived once the password expired.
225 if((document.forms[0].pwd_expires.value != 0) && (document.forms[0].clearPass.value == "")) {
226 if((document.forms[0].user_type.value != "Emergency Login") && (document.forms[0].pre_active.value == 0) && (document.forms[0].active.checked == 1) && (document.forms[0].grace_time.value != "") && (document.forms[0].current_date.value) > (document.forms[0].grace_time.value))
228 flag=1;
229 document.getElementById('error_message').innerHTML="<?php xl('Please reset the password.','e') ?>";
233 if (document.forms[0].access_group_id) {
234 var sel = getSelected(document.forms[0].access_group_id.options);
235 for (var item in sel) {
236 if (sel[item].value == "Emergency Login") {
237 document.forms[0].check_acl.value = 1;
242 <?php if($GLOBALS['erx_enable']){ ?>
243 alertMsg='';
244 f=document.forms[0];
245 for(i=0;i<f.length;i++){
246 if(f[i].type=='text' && f[i].value)
248 if(f[i].name == 'fname' || f[i].name == 'mname' || f[i].name == 'lname')
250 alertMsg += checkLength(f[i].name,f[i].value,35);
251 alertMsg += checkUsername(f[i].name,f[i].value);
253 else if(f[i].name == 'taxid')
255 alertMsg += checkLength(f[i].name,f[i].value,10);
256 alertMsg += checkFederalEin(f[i].name,f[i].value);
258 else if(f[i].name == 'state_license_number')
260 alertMsg += checkLength(f[i].name,f[i].value,10);
261 alertMsg += checkStateLicenseNumber(f[i].name,f[i].value);
263 else if(f[i].name == 'npi')
265 alertMsg += checkLength(f[i].name,f[i].value,10);
266 alertMsg += checkTaxNpiDea(f[i].name,f[i].value);
268 else if(f[i].name == 'drugid')
270 alertMsg += checkLength(f[i].name,f[i].value,30);
271 alertMsg += checkAlphaNumeric(f[i].name,f[i].value);
275 if(alertMsg)
277 alert(alertMsg);
278 return false;
280 <?php } ?>
281 if(flag == 0){
282 document.forms[0].submit();
283 parent.$.fn.fancybox.close();
286 //Getting the list of selected item in ACL
287 function getSelected(opt) {
288 var selected = new Array();
289 var index = 0;
290 for (var intLoop = 0; intLoop < opt.length; intLoop++) {
291 if ((opt[intLoop].selected) ||
292 (opt[intLoop].checked)) {
293 index = selected.length;
294 selected[index] = new Object;
295 selected[index].value = opt[intLoop].value;
296 selected[index].index = intLoop;
299 return selected;
302 function authorized_clicked() {
303 var f = document.forms[0];
304 f.calendar.disabled = !f.authorized.checked;
305 f.calendar.checked = f.authorized.checked;
308 </script>
309 <style type="text/css">
310 .physician_type_class{
311 width: 150px !important;
313 </style>
314 </head>
315 <body class="body_top">
316 <table><tr><td>
317 <span class="title"><?php xl('Edit User','e'); ?></span>&nbsp;
318 </td><td>
319 <a class="css_button" name='form_save' id='form_save' href='#' onclick='return submitform()'> <span><?php xl('Save','e');?></span> </a>
320 <a class="css_button" id='cancel' href='#'><span><?php xl('Cancel','e');?></span></a>
321 </td></tr>
322 </table>
323 <br>
324 <FORM NAME="user_form" id="user_form" METHOD="POST" ACTION="usergroup_admin.php" target="_parent" onsubmit='return top.restoreSession()'>
326 <input type=hidden name="pwd_expires" value="<?php echo $GLOBALS['password_expiration_days']; ?>" >
327 <input type=hidden name="pre_active" value="<?php echo $iter["active"]; ?>" >
328 <input type=hidden name="exp_date" value="<?php echo $iter["pwd_expiration_date"]; ?>" >
329 <input type=hidden name="get_admin_id" value="<?php echo $GLOBALS['Emergency_Login_email']; ?>" >
330 <input type=hidden name="admin_id" value="<?php echo $GLOBALS['Emergency_Login_email_id']; ?>" >
331 <input type=hidden name="check_acl" value="">
332 <?php
333 //Calculating the grace time
334 $current_date = date("Y-m-d");
335 $password_exp=$iter["pwd_expiration_date"];
336 if($password_exp != "0000-00-00")
338 $grace_time1 = date("Y-m-d", strtotime($password_exp . "+".$GLOBALS['password_grace_time'] ."days"));
341 <input type=hidden name="current_date" value="<?php echo strtotime($current_date); ?>" >
342 <input type=hidden name="grace_time" value="<?php echo strtotime($grace_time1); ?>" >
343 <!-- Get the list ACL for the user -->
344 <?php
345 $acl_name=acl_get_group_titles($iter["username"]);
346 $bg_name='';
347 $bg_count=count($acl_name);
348 for($i=0;$i<$bg_count;$i++){
349 if($acl_name[$i] == "Emergency Login")
350 $bg_name=$acl_name[$i];
353 <input type=hidden name="user_type" value="<?php echo $bg_name; ?>" >
355 <TABLE border=0 cellpadding=0 cellspacing=0>
356 <TR>
357 <TD style="width:180px;"><span class=text><?php xl('Username','e'); ?>: </span></TD>
358 <TD style="width:270px;"><input type=entry name=username style="width:150px;" value="<?php echo $iter["username"]; ?>" disabled></td>
359 <TD style="width:200px;"><span class=text><?php xl('Your Password','e'); ?>: </span></TD>
360 <TD class='text' style="width:280px;"><input type='password' name=adminPass style="width:150px;" value="" autocomplete='off'><font class="mandatory">*</font></TD>
361 </TR>
362 <TR>
363 <TD style="width:180px;"><span class=text></span></TD>
364 <TD style="width:270px;"></td>
365 <TD style="width:200px;"><span class=text><?php xl('User\'s New Password','e'); ?>: </span></TD>
366 <TD class='text' style="width:280px;"> <input type=text name=clearPass style="width:150px;" value=""><font class="mandatory">*</font></td>
367 </TR>
370 <TR height="30" style="valign:middle;">
371 <td><span class="text">&nbsp;</span></td><td>&nbsp;</td>
372 <td colspan="2"><span class=text><?php xl('Provider','e'); ?>:
373 <input type="checkbox" name="authorized" onclick="authorized_clicked()"<?php
374 if ($iter["authorized"]) echo " checked"; ?> />
375 &nbsp;&nbsp;<span class='text'><?php xl('Calendar','e'); ?>:
376 <input type="checkbox" name="calendar"<?php
377 if ($iter["calendar"]) echo " checked";
378 if (!$iter["authorized"]) echo " disabled"; ?> />
379 &nbsp;&nbsp;<span class='text'><?php xl('Active','e'); ?>:
380 <input type="checkbox" name="active"<?php if ($iter["active"]) echo " checked"; ?> />
381 </TD>
382 </TR>
384 <TR>
385 <TD><span class=text><?php xl('First Name','e'); ?>: </span></TD>
386 <TD><input type=entry name=fname id=fname style="width:150px;" value="<?php echo $iter["fname"]; ?>"><span class="mandatory">&nbsp;*</span></td>
387 <td><span class=text><?php xl('Middle Name','e'); ?>: </span></TD><td><input type=entry name=mname style="width:150px;" value="<?php echo $iter["mname"]; ?>"></td>
388 </TR>
390 <TR>
391 <td><span class=text><?php xl('Last Name','e'); ?>: </span></td><td><input type=entry name=lname id=lname style="width:150px;" value="<?php echo $iter["lname"]; ?>"><span class="mandatory">&nbsp;*</span></td>
392 <td><span class=text><?php xl('Default Facility','e'); ?>: </span></td><td><select name=facility_id style="width:150px;" >
393 <?php
394 $fres = sqlStatement("select * from facility where service_location != 0 order by name");
395 if ($fres) {
396 for ($iter2 = 0; $frow = sqlFetchArray($fres); $iter2++)
397 $result[$iter2] = $frow;
398 foreach($result as $iter2) {
400 <option value="<?php echo $iter2['id']; ?>" <?php if ($iter['facility_id'] == $iter2['id']) echo "selected"; ?>><?php echo htmlspecialchars($iter2['name']); ?></option>
401 <?php
405 </select></td>
406 </tr>
408 <?php if ($GLOBALS['restrict_user_facility']) { ?>
409 <tr>
410 <td colspan=2>&nbsp;</td>
411 <td><span class=text><?php xl('Schedule Facilities:', 'e');?></td>
412 <td>
413 <select name="schedule_facility[]" multiple style="width:150px;" >
414 <?php
415 $userFacilities = getUserFacilities($_GET['id']);
416 $ufid = array();
417 foreach($userFacilities as $uf)
418 $ufid[] = $uf['id'];
419 $fres = sqlStatement("select * from facility where service_location != 0 order by name");
420 if ($fres) {
421 while($frow = sqlFetchArray($fres)):
423 <option <?php echo in_array($frow['id'], $ufid) || $frow['id'] == $iter['facility_id'] ? "selected" : null ?>
424 value="<?php echo $frow['id'] ?>"><?php echo htmlspecialchars($frow['name']) ?></option>
425 <?php
426 endwhile;
429 </select>
430 </td>
431 </tr>
432 <?php } ?>
434 <TR>
435 <TD><span class=text><?php xl('Federal Tax ID','e'); ?>: </span></TD><TD><input type=text name=taxid style="width:150px;" value="<?php echo $iter["federaltaxid"]?>"></td>
436 <TD><span class=text><?php xl('Federal Drug ID','e'); ?>: </span></TD><TD><input type=text name=drugid style="width:150px;" value="<?php echo $iter["federaldrugid"]?>"></td>
437 </TR>
439 <tr>
440 <td><span class="text"><?php xl('UPIN','e'); ?>: </span></td><td><input type="text" name="upin" style="width:150px;" value="<?php echo $iter["upin"]?>"></td>
441 <td class='text'><?php xl('See Authorizations','e'); ?>: </td>
442 <td><select name="see_auth" style="width:150px;" >
443 <?php
444 foreach (array(1 => xl('None'), 2 => xl('Only Mine'), 3 => xl('All')) as $key => $value)
446 echo " <option value='$key'";
447 if ($key == $iter['see_auth']) echo " selected";
448 echo ">$value</option>\n";
451 </select></td>
452 </tr>
454 <tr>
455 <td><span class="text"><?php xl('NPI','e'); ?>: </span></td><td><input type="text" name="npi" style="width:150px;" value="<?php echo $iter["npi"]?>"></td>
456 <td><span class="text"><?php xl('Job Description','e'); ?>: </span></td><td><input type="text" name="job" style="width:150px;" value="<?php echo $iter["specialty"]?>"></td>
457 </tr>
459 <!-- (CHEMED) Calendar UI preference -->
460 <tr>
461 <td><span class="text"><?php xl('Taxonomy','e'); ?>: </span></td>
462 <td><input type="text" name="taxonomy" style="width:150px;" value="<?php echo $iter["taxonomy"]?>"></td>
463 <td><span class="text"><?php xl('Calendar UI','e'); ?>: </span></td><td><select name="cal_ui" style="width:150px;" >
464 <?php
465 foreach (array(3 => xl('Outlook'), 1 => xl('Original'), 2 => xl('Fancy')) as $key => $value)
467 echo " <option value='$key'";
468 if ($key == $iter['cal_ui']) echo " selected";
469 echo ">$value</option>\n";
472 </select></td>
473 </tr>
474 <!-- END (CHEMED) Calendar UI preference -->
476 <tr>
477 <td><span class="text"><?php xl('State License Number','e'); ?>: </span></td>
478 <td><input type="text" name="state_license_number" style="width:150px;" value="<?php echo $iter["state_license_number"]?>"></td>
479 <td class='text'><?php xl('NewCrop eRX Role','e'); ?>:</td>
480 <td>
481 <?php echo generate_select_list("erxrole", "newcrop_erx_role", $iter['newcrop_user_role'],'',xl('Select Role'),'','','',array('style'=>'width:150px')); ?>
482 </td>
483 </tr>
485 <tr>
486 <td><span class="text"><?php xl('Provider Type','e'); ?>: </span></td>
487 <td><?php echo generate_select_list("physician_type", "physician_type", $iter['physician_type'],'',xl('Select Type'),'physician_type_class','','',''); ?></td>
488 </tr>
489 <?php if ($GLOBALS['inhouse_pharmacy']) { ?>
490 <tr>
491 <td class="text"><?php xl('Default Warehouse','e'); ?>: </td>
492 <td class='text'>
493 <?php
494 echo generate_select_list('default_warehouse', 'warehouse',
495 $iter['default_warehouse'], '');
497 </td>
498 <td class="text"><?php xl('Invoice Refno Pool','e'); ?>: </td>
499 <td class='text'>
500 <?php
501 echo generate_select_list('irnpool', 'irnpool', $iter['irnpool'],
502 xl('Invoice reference number pool, if used'));
504 </td>
505 </tr>
506 <?php } ?>
508 <?php
509 // Collect the access control group of user
510 if (isset($phpgacl_location) && acl_check('admin', 'acl')) {
512 <tr>
513 <td class='text'><?php xl('Access Control','e'); ?>:</td>
514 <td><select id="access_group_id" name="access_group[]" multiple style="width:150px;" >
515 <?php
516 $list_acl_groups = acl_get_group_title_list();
517 $username_acl_groups = acl_get_group_titles($iter["username"]);
518 foreach ($list_acl_groups as $value) {
519 if (($username_acl_groups) && in_array($value,$username_acl_groups)) {
520 // Modified 6-2009 by BM - Translate group name if applicable
521 echo " <option value='$value' selected>" . xl_gacl_group($value) . "</option>\n";
523 else {
524 // Modified 6-2009 by BM - Translate group name if applicable
525 echo " <option value='$value'>" . xl_gacl_group($value) . "</option>\n";
529 </select></td>
530 <td><span class=text><?php xl('Additional Info','e'); ?>:</span></td>
531 <td><textarea style="width:150px;" name="comments" wrap=auto rows=4 cols=25><?php echo $iter["info"];?></textarea></td>
533 </tr>
534 <tr height="20" valign="bottom">
535 <td colspan="4" class="text">
536 <font class="mandatory">*</font> <?php xl('You must enter your own password to change user passwords. Leave blank to keep password unchanged.','e'); ?>
537 <!--
538 Display red alert if entered password matched one of last three passwords/Display red alert if user password was expired and the user was inactivated previously
540 <div class="redtext" id="error_message">&nbsp;</div>
541 </td>
542 </tr>
543 <?php
546 </table>
548 <INPUT TYPE="HIDDEN" NAME="id" VALUE="<?php echo attr($_GET["id"]); ?>">
549 <INPUT TYPE="HIDDEN" NAME="mode" VALUE="update">
550 <INPUT TYPE="HIDDEN" NAME="privatemode" VALUE="user_admin">
552 <INPUT TYPE="HIDDEN" NAME="secure_pwd" VALUE="<?php echo $GLOBALS['secure_password']; ?>">
553 </FORM>
554 <script language="JavaScript">
555 $(document).ready(function(){
556 $("#cancel").click(function() {
557 parent.$.fn.fancybox.close();
561 </script>
562 </BODY>
564 </HTML>
566 <?php
567 // d41d8cd98f00b204e9800998ecf8427e == blank