added cache clearing support for dialog.js (#411)
[openemr.git] / interface / usergroup / user_admin.php
blob95b9757b09a90caa4fd946ed162c6da7f1bdecf1
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/formdata.inc.php");
10 require_once("$srcdir/calendar.inc");
11 require_once("$srcdir/options.inc.php");
12 require_once("$srcdir/erx_javascript.inc.php");
14 if (!$_GET["id"] || !acl_check('admin', 'users'))
15 exit();
17 if ($_GET["mode"] == "update") {
18 if ($_GET["username"]) {
19 // $tqvar = addslashes(trim($_GET["username"]));
20 $tqvar = trim(formData('username','G'));
21 $user_data = sqlFetchArray(sqlStatement("select * from users where id={$_GET["id"]}"));
22 sqlStatement("update users set username='$tqvar' where id={$_GET["id"]}");
23 sqlStatement("update groups set user='$tqvar' where user='". $user_data["username"] ."'");
24 //echo "query was: " ."update groups set user='$tqvar' where user='". $user_data["username"] ."'" ;
26 if ($_GET["taxid"]) {
27 $tqvar = formData('taxid','G');
28 sqlStatement("update users set federaltaxid='$tqvar' where id={$_GET["id"]}");
30 if ($_GET["drugid"]) {
31 $tqvar = formData('drugid','G');
32 sqlStatement("update users set federaldrugid='$tqvar' where id={$_GET["id"]}");
34 if ($_GET["upin"]) {
35 $tqvar = formData('upin','G');
36 sqlStatement("update users set upin='$tqvar' where id={$_GET["id"]}");
38 if ($_GET["npi"]) {
39 $tqvar = formData('npi','G');
40 sqlStatement("update users set npi='$tqvar' where id={$_GET["id"]}");
42 if ($_GET["taxonomy"]) {
43 $tqvar = formData('taxonomy','G');
44 sqlStatement("update users set taxonomy = '$tqvar' where id= {$_GET["id"]}");
46 if ($_GET["lname"]) {
47 $tqvar = formData('lname','G');
48 sqlStatement("update users set lname='$tqvar' where id={$_GET["id"]}");
50 if ($_GET["job"]) {
51 $tqvar = formData('job','G');
52 sqlStatement("update users set specialty='$tqvar' where id={$_GET["id"]}");
54 if ($_GET["mname"]) {
55 $tqvar = formData('mname','G');
56 sqlStatement("update users set mname='$tqvar' where id={$_GET["id"]}");
58 if ($_GET["facility_id"]) {
59 $tqvar = formData('facility_id','G');
60 sqlStatement("update users set facility_id = '$tqvar' where id = {$_GET["id"]}");
61 //(CHEMED) Update facility name when changing the id
62 sqlStatement("UPDATE users, facility SET users.facility = facility.name WHERE facility.id = '$tqvar' AND users.id = {$_GET["id"]}");
63 //END (CHEMED)
65 if ($GLOBALS['restrict_user_facility'] && $_GET["schedule_facility"]) {
66 sqlStatement("delete from users_facility
67 where tablename='users'
68 and table_id={$_GET["id"]}
69 and facility_id not in (" . implode(",", $_GET['schedule_facility']) . ")");
70 foreach($_GET["schedule_facility"] as $tqvar) {
71 sqlStatement("replace into users_facility set
72 facility_id = '$tqvar',
73 tablename='users',
74 table_id = {$_GET["id"]}");
77 if ($_GET["fname"]) {
78 $tqvar = formData('fname','G');
79 sqlStatement("update users set fname='$tqvar' where id={$_GET["id"]}");
81 //(CHEMED) Calendar UI preference
82 if ($_GET["cal_ui"]) {
83 $tqvar = formData('cal_ui','G');
84 sqlStatement("update users set cal_ui = '$tqvar' where id = {$_GET["id"]}");
86 // added by bgm to set this session variable if the current user has edited
87 // their own settings
88 if ($_SESSION['authId'] == $_GET["id"]) {
89 $_SESSION['cal_ui'] = $tqvar;
92 //END (CHEMED) Calendar UI preference
94 if (isset($_GET['default_warehouse'])) {
95 sqlStatement("UPDATE users SET default_warehouse = '" .
96 formData('default_warehouse','G') .
97 "' WHERE id = '" . formData('id','G') . "'");
100 if (isset($_GET['irnpool'])) {
101 sqlStatement("UPDATE users SET irnpool = '" .
102 formData('irnpool','G') .
103 "' WHERE id = '" . formData('id','G') . "'");
106 if ($_GET["newauthPass"] && $_GET["newauthPass"] != "d41d8cd98f00b204e9800998ecf8427e") { // account for empty
107 $tqvar = formData('newauthPass','G');
108 sqlStatement("update users set password='$tqvar' where id={$_GET["id"]}");
111 $tqvar = $_GET["authorized"] ? 1 : 0;
112 $actvar = $_GET["active"] ? 1 : 0;
113 $calvar = $_GET["calendar"] ? 1 : 0;
115 sqlStatement("UPDATE users SET authorized = $tqvar, active = $actvar, " .
116 "calendar = $calvar, see_auth = '" . $_GET['see_auth'] . "' WHERE " .
117 "id = {$_GET["id"]}");
119 if ($_GET["comments"]) {
120 $tqvar = formData('comments','G');
121 sqlStatement("update users set info = '$tqvar' where id = {$_GET["id"]}");
124 if (isset($phpgacl_location) && acl_check('admin', 'acl')) {
125 // Set the access control group of user
126 $user_data = sqlFetchArray(sqlStatement("select username from users where id={$_GET["id"]}"));
127 set_user_aro($_GET['access_group'], $user_data["username"],
128 formData('fname','G'), formData('mname','G'), formData('lname','G'));
131 /*Dont move usergroup_admin (1).php just close window
132 // On a successful update, return to the users list.
133 include("usergroup_admin.php");
134 exit(0);
135 */ echo '
136 <script type="text/javascript">
137 <!--
138 parent.$.fn.fancybox.close();
139 //-->
140 </script>
145 $res = sqlStatement("select * from users where id=?",array($_GET["id"]));
146 for ($iter = 0;$row = sqlFetchArray($res);$iter++)
147 $result[$iter] = $row;
148 $iter = $result[0];
151 if (isset($_POST["mode"])) {
152 echo '
153 <script type="text/javascript">
154 <!--
155 parent.$.fn.fancybox.close();
156 //-->
157 </script>
165 <html>
166 <head>
168 <link rel="stylesheet" href="<?php echo $css_header; ?>" type="text/css">
169 <script type="text/javascript" src="../../library/dialog.js?v=<?php echo $v_js_includes; ?>"></script>
170 <script type="text/javascript" src="<?php echo $GLOBALS['assets_static_relative'] ?>/jquery-min-1-9-1/index.js"></script>
171 <script type="text/javascript" src="../../library/js/common.js"></script>
173 <script src="checkpwd_validation.js" type="text/javascript"></script>
175 <!-- validation library -->
176 <!--//Not lbf forms use the new validation, please make sure you have the corresponding values in the list Page validation-->
177 <?php $use_validate_js = 1;?>
178 <?php require_once($GLOBALS['srcdir'] . "/validation/validation_script.js.php"); ?>
179 <?php require_once($GLOBALS['srcdir'] . "/validation/validate_core.php"); ?>
180 <?php
181 //Gets validation rules from Page Validation list.
182 //Note that for technical reasons, we are bypassing the standard validateUsingPageRules() call.
183 $collectthis = collectValidationPageRules("/interface/usergroup/user_admin.php");
184 if (empty($collectthis)) {
185 $collectthis = "undefined";
187 else {
188 $collectthis = $collectthis["user_form"]["rules"];
192 <script language="JavaScript">
195 * validation on the form with new client side validation (using validate.js).
196 * this enable to add new rules for this form in the pageValidation list.
197 * */
198 var collectvalidation = <?php echo($collectthis); ?>;
200 function checkChange()
202 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.'));?>");
204 function submitform() {
206 var valid = submitme(1, undefined, 'user_form', collectvalidation);
207 if (!valid) return;
209 top.restoreSession();
210 var flag=0;
212 if(document.forms[0].clearPass.value!="")
214 //Checking for the strong password if the 'secure password' feature is enabled
215 if(document.forms[0].secure_pwd.value == 1)
217 var pwdresult = passwordvalidate(document.forms[0].clearPass.value);
218 if(pwdresult == 0) {
219 flag=1;
220 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'; ?>");
221 return false;
225 }//If pwd null ends here
226 //Request to reset the user password if the user was deactived once the password expired.
227 if((document.forms[0].pwd_expires.value != 0) && (document.forms[0].clearPass.value == "")) {
228 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))
230 flag=1;
231 document.getElementById('error_message').innerHTML="<?php xl('Please reset the password.','e') ?>";
235 if (document.forms[0].access_group_id) {
236 var sel = getSelected(document.forms[0].access_group_id.options);
237 for (var item in sel) {
238 if (sel[item].value == "Emergency Login") {
239 document.forms[0].check_acl.value = 1;
244 <?php if($GLOBALS['erx_enable']){ ?>
245 alertMsg='';
246 f=document.forms[0];
247 for(i=0;i<f.length;i++){
248 if(f[i].type=='text' && f[i].value)
250 if(f[i].name == 'fname' || f[i].name == 'mname' || f[i].name == 'lname')
252 alertMsg += checkLength(f[i].name,f[i].value,35);
253 alertMsg += checkUsername(f[i].name,f[i].value);
255 else if(f[i].name == 'taxid')
257 alertMsg += checkLength(f[i].name,f[i].value,10);
258 alertMsg += checkFederalEin(f[i].name,f[i].value);
260 else if(f[i].name == 'state_license_number')
262 alertMsg += checkLength(f[i].name,f[i].value,10);
263 alertMsg += checkStateLicenseNumber(f[i].name,f[i].value);
265 else if(f[i].name == 'npi')
267 alertMsg += checkLength(f[i].name,f[i].value,10);
268 alertMsg += checkTaxNpiDea(f[i].name,f[i].value);
270 else if(f[i].name == 'drugid')
272 alertMsg += checkLength(f[i].name,f[i].value,30);
273 alertMsg += checkAlphaNumeric(f[i].name,f[i].value);
277 if(alertMsg)
279 alert(alertMsg);
280 return false;
282 <?php } ?>
283 if(flag == 0){
284 document.forms[0].submit();
285 parent.$.fn.fancybox.close();
288 //Getting the list of selected item in ACL
289 function getSelected(opt) {
290 var selected = new Array();
291 var index = 0;
292 for (var intLoop = 0; intLoop < opt.length; intLoop++) {
293 if ((opt[intLoop].selected) ||
294 (opt[intLoop].checked)) {
295 index = selected.length;
296 selected[index] = new Object;
297 selected[index].value = opt[intLoop].value;
298 selected[index].index = intLoop;
301 return selected;
304 function authorized_clicked() {
305 var f = document.forms[0];
306 f.calendar.disabled = !f.authorized.checked;
307 f.calendar.checked = f.authorized.checked;
310 </script>
311 <style type="text/css">
312 .physician_type_class{
313 width: 150px !important;
315 </style>
316 </head>
317 <body class="body_top">
318 <table><tr><td>
319 <span class="title"><?php xl('Edit User','e'); ?></span>&nbsp;
320 </td><td>
321 <a class="css_button" name='form_save' id='form_save' href='#' onclick='return submitform()'> <span><?php xl('Save','e');?></span> </a>
322 <a class="css_button" id='cancel' href='#'><span><?php xl('Cancel','e');?></span></a>
323 </td></tr>
324 </table>
325 <br>
326 <FORM NAME="user_form" id="user_form" METHOD="POST" ACTION="usergroup_admin.php" target="_parent" onsubmit='return top.restoreSession()'>
328 <input type=hidden name="pwd_expires" value="<?php echo $GLOBALS['password_expiration_days']; ?>" >
329 <input type=hidden name="pre_active" value="<?php echo $iter["active"]; ?>" >
330 <input type=hidden name="exp_date" value="<?php echo $iter["pwd_expiration_date"]; ?>" >
331 <input type=hidden name="get_admin_id" value="<?php echo $GLOBALS['Emergency_Login_email']; ?>" >
332 <input type=hidden name="admin_id" value="<?php echo $GLOBALS['Emergency_Login_email_id']; ?>" >
333 <input type=hidden name="check_acl" value="">
334 <?php
335 //Calculating the grace time
336 $current_date = date("Y-m-d");
337 $password_exp=$iter["pwd_expiration_date"];
338 if($password_exp != "0000-00-00")
340 $grace_time1 = date("Y-m-d", strtotime($password_exp . "+".$GLOBALS['password_grace_time'] ."days"));
343 <input type=hidden name="current_date" value="<?php echo strtotime($current_date); ?>" >
344 <input type=hidden name="grace_time" value="<?php echo strtotime($grace_time1); ?>" >
345 <!-- Get the list ACL for the user -->
346 <?php
347 $acl_name=acl_get_group_titles($iter["username"]);
348 $bg_name='';
349 $bg_count=count($acl_name);
350 for($i=0;$i<$bg_count;$i++){
351 if($acl_name[$i] == "Emergency Login")
352 $bg_name=$acl_name[$i];
355 <input type=hidden name="user_type" value="<?php echo $bg_name; ?>" >
357 <TABLE border=0 cellpadding=0 cellspacing=0>
358 <TR>
359 <TD style="width:180px;"><span class=text><?php xl('Username','e'); ?>: </span></TD>
360 <TD style="width:270px;"><input type=entry name=username style="width:150px;" value="<?php echo $iter["username"]; ?>" disabled></td>
361 <TD style="width:200px;"><span class=text><?php xl('Your Password','e'); ?>: </span></TD>
362 <TD class='text' style="width:280px;"><input type='password' name=adminPass style="width:150px;" value="" autocomplete='off'><font class="mandatory">*</font></TD>
363 </TR>
364 <TR>
365 <TD style="width:180px;"><span class=text></span></TD>
366 <TD style="width:270px;"></td>
367 <TD style="width:200px;"><span class=text><?php xl('User\'s New Password','e'); ?>: </span></TD>
368 <TD class='text' style="width:280px;"> <input type=text name=clearPass style="width:150px;" value=""><font class="mandatory">*</font></td>
369 </TR>
372 <TR height="30" style="valign:middle;">
373 <td><span class="text">&nbsp;</span></td><td>&nbsp;</td>
374 <td colspan="2"><span class=text><?php xl('Provider','e'); ?>:
375 <input type="checkbox" name="authorized" onclick="authorized_clicked()"<?php
376 if ($iter["authorized"]) echo " checked"; ?> />
377 &nbsp;&nbsp;<span class='text'><?php xl('Calendar','e'); ?>:
378 <input type="checkbox" name="calendar"<?php
379 if ($iter["calendar"]) echo " checked";
380 if (!$iter["authorized"]) echo " disabled"; ?> />
381 &nbsp;&nbsp;<span class='text'><?php xl('Active','e'); ?>:
382 <input type="checkbox" name="active"<?php if ($iter["active"]) echo " checked"; ?> />
383 </TD>
384 </TR>
386 <TR>
387 <TD><span class=text><?php xl('First Name','e'); ?>: </span></TD>
388 <TD><input type=entry name=fname id=fname style="width:150px;" value="<?php echo $iter["fname"]; ?>"><span class="mandatory">&nbsp;*</span></td>
389 <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>
390 </TR>
392 <TR>
393 <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>
394 <td><span class=text><?php xl('Default Facility','e'); ?>: </span></td><td><select name=facility_id style="width:150px;" >
395 <?php
396 $fres = sqlStatement("select * from facility where service_location != 0 order by name");
397 if ($fres) {
398 for ($iter2 = 0; $frow = sqlFetchArray($fres); $iter2++)
399 $result[$iter2] = $frow;
400 foreach($result as $iter2) {
402 <option value="<?php echo $iter2['id']; ?>" <?php if ($iter['facility_id'] == $iter2['id']) echo "selected"; ?>><?php echo htmlspecialchars($iter2['name']); ?></option>
403 <?php
407 </select></td>
408 </tr>
410 <?php if ($GLOBALS['restrict_user_facility']) { ?>
411 <tr>
412 <td colspan=2>&nbsp;</td>
413 <td><span class=text><?php xl('Schedule Facilities:', 'e');?></td>
414 <td>
415 <select name="schedule_facility[]" multiple style="width:150px;" >
416 <?php
417 $userFacilities = getUserFacilities($_GET['id']);
418 $ufid = array();
419 foreach($userFacilities as $uf)
420 $ufid[] = $uf['id'];
421 $fres = sqlStatement("select * from facility where service_location != 0 order by name");
422 if ($fres) {
423 while($frow = sqlFetchArray($fres)):
425 <option <?php echo in_array($frow['id'], $ufid) || $frow['id'] == $iter['facility_id'] ? "selected" : null ?>
426 value="<?php echo $frow['id'] ?>"><?php echo htmlspecialchars($frow['name']) ?></option>
427 <?php
428 endwhile;
431 </select>
432 </td>
433 </tr>
434 <?php } ?>
436 <TR>
437 <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>
438 <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>
439 </TR>
441 <tr>
442 <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>
443 <td class='text'><?php xl('See Authorizations','e'); ?>: </td>
444 <td><select name="see_auth" style="width:150px;" >
445 <?php
446 foreach (array(1 => xl('None'), 2 => xl('Only Mine'), 3 => xl('All')) as $key => $value)
448 echo " <option value='$key'";
449 if ($key == $iter['see_auth']) echo " selected";
450 echo ">$value</option>\n";
453 </select></td>
454 </tr>
456 <tr>
457 <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>
458 <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>
459 </tr>
461 <!-- (CHEMED) Calendar UI preference -->
462 <tr>
463 <td><span class="text"><?php xl('Taxonomy','e'); ?>: </span></td>
464 <td><input type="text" name="taxonomy" style="width:150px;" value="<?php echo $iter["taxonomy"]?>"></td>
465 <td><span class="text"><?php xl('Calendar UI','e'); ?>: </span></td><td><select name="cal_ui" style="width:150px;" >
466 <?php
467 foreach (array(3 => xl('Outlook'), 1 => xl('Original'), 2 => xl('Fancy')) as $key => $value)
469 echo " <option value='$key'";
470 if ($key == $iter['cal_ui']) echo " selected";
471 echo ">$value</option>\n";
474 </select></td>
475 </tr>
476 <!-- END (CHEMED) Calendar UI preference -->
478 <tr>
479 <td><span class="text"><?php xl('State License Number','e'); ?>: </span></td>
480 <td><input type="text" name="state_license_number" style="width:150px;" value="<?php echo $iter["state_license_number"]?>"></td>
481 <td class='text'><?php xl('NewCrop eRX Role','e'); ?>:</td>
482 <td>
483 <?php echo generate_select_list("erxrole", "newcrop_erx_role", $iter['newcrop_user_role'],'',xl('Select Role'),'','','',array('style'=>'width:150px')); ?>
484 </td>
485 </tr>
487 <tr>
488 <td><span class="text"><?php xl('Provider Type','e'); ?>: </span></td>
489 <td><?php echo generate_select_list("physician_type", "physician_type", $iter['physician_type'],'',xl('Select Type'),'physician_type_class','','',''); ?></td>
490 </tr>
491 <?php if ($GLOBALS['inhouse_pharmacy']) { ?>
492 <tr>
493 <td class="text"><?php xl('Default Warehouse','e'); ?>: </td>
494 <td class='text'>
495 <?php
496 echo generate_select_list('default_warehouse', 'warehouse',
497 $iter['default_warehouse'], '');
499 </td>
500 <td class="text"><?php xl('Invoice Refno Pool','e'); ?>: </td>
501 <td class='text'>
502 <?php
503 echo generate_select_list('irnpool', 'irnpool', $iter['irnpool'],
504 xl('Invoice reference number pool, if used'));
506 </td>
507 </tr>
508 <?php } ?>
510 <?php
511 // Collect the access control group of user
512 if (isset($phpgacl_location) && acl_check('admin', 'acl')) {
514 <tr>
515 <td class='text'><?php xl('Access Control','e'); ?>:</td>
516 <td><select id="access_group_id" name="access_group[]" multiple style="width:150px;" >
517 <?php
518 $list_acl_groups = acl_get_group_title_list();
519 $username_acl_groups = acl_get_group_titles($iter["username"]);
520 foreach ($list_acl_groups as $value) {
521 if (($username_acl_groups) && in_array($value,$username_acl_groups)) {
522 // Modified 6-2009 by BM - Translate group name if applicable
523 echo " <option value='$value' selected>" . xl_gacl_group($value) . "</option>\n";
525 else {
526 // Modified 6-2009 by BM - Translate group name if applicable
527 echo " <option value='$value'>" . xl_gacl_group($value) . "</option>\n";
531 </select></td>
532 <td><span class=text><?php xl('Additional Info','e'); ?>:</span></td>
533 <td><textarea style="width:150px;" name="comments" wrap=auto rows=4 cols=25><?php echo $iter["info"];?></textarea></td>
535 </tr>
536 <tr height="20" valign="bottom">
537 <td colspan="4" class="text">
538 <font class="mandatory">*</font> <?php xl('You must enter your own password to change user passwords. Leave blank to keep password unchanged.','e'); ?>
539 <!--
540 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
542 <div class="redtext" id="error_message">&nbsp;</div>
543 </td>
544 </tr>
545 <?php
548 </table>
550 <INPUT TYPE="HIDDEN" NAME="id" VALUE="<?php echo attr($_GET["id"]); ?>">
551 <INPUT TYPE="HIDDEN" NAME="mode" VALUE="update">
552 <INPUT TYPE="HIDDEN" NAME="privatemode" VALUE="user_admin">
554 <INPUT TYPE="HIDDEN" NAME="secure_pwd" VALUE="<?php echo $GLOBALS['secure_password']; ?>">
555 </FORM>
556 <script language="JavaScript">
557 $(document).ready(function(){
558 $("#cancel").click(function() {
559 parent.$.fn.fancybox.close();
563 </script>
564 </BODY>
566 </HTML>
568 <?php
569 // d41d8cd98f00b204e9800998ecf8427e == blank