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'))
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"] ."'" ;
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
"]}");
35 $tqvar = formData('upin','G');
36 sqlStatement("update users set upin='$tqvar' where id={$_GET["id
"]}");
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
"]}");
47 $tqvar = formData('lname','G');
48 sqlStatement("update users set lname='$tqvar' where id={$_GET["id
"]}");
51 $tqvar = formData('job','G');
52 sqlStatement("update users set specialty='$tqvar' where id={$_GET["id
"]}");
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
"]}");
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',
74 table_id = {$_GET["id
"]}");
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
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");
136 <script type="text/javascript">
138 parent.$.fn.fancybox.close();
145 $res = sqlStatement("select * from users where id=?",array($_GET["id"]));
146 for ($iter = 0;$row = sqlFetchArray($res);$iter++
)
147 $result[$iter] = $row;
151 if (isset($_POST["mode"])) {
153 <script type="text/javascript">
155 parent.$.fn.fancybox.close();
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"); ?
>
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";
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.
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
);
209 top
.restoreSession();
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
);
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'; ?>");
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
))
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']){ ?
>
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
);
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();
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
;
304 function authorized_clicked() {
305 var f
= document
.forms
[0];
306 f
.calendar
.disabled
= !f
.authorized
.checked
;
307 f
.calendar
.checked
= f
.authorized
.checked
;
311 <style type
="text/css">
312 .physician_type_class
{
313 width
: 150px
!important
;
317 <body
class="body_top">
319 <span
class="title"><?php
xl('Edit User','e'); ?
></span
> 
;
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
>
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
="">
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
-->
347 $acl_name=acl_get_group_titles($iter["username"]);
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>
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
>
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
>
372 <TR height
="30" style
="valign:middle;">
373 <td
><span
class="text"> 
;</span
></td
><td
> 
;</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  
; 
;<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  
; 
;<span
class='text'><?php
xl('Active','e'); ?
>:
382 <input type
="checkbox" name
="active"<?php
if ($iter["active"]) echo " checked"; ?
> />
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"> 
;*</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
>
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"> 
;*</span
></td
>
394 <td
><span
class=text
><?php
xl('Default Facility','e'); ?
>: </span
></td
><td
><select name
=facility_id style
="width:150px;" >
396 $fres = sqlStatement("select * from facility where service_location != 0 order by name");
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
>
410 <?php
if ($GLOBALS['restrict_user_facility']) { ?
>
412 <td colspan
=2> 
;</td
>
413 <td
><span
class=text
><?php
xl('Schedule Facilities:', 'e');?
></td
>
415 <select name
="schedule_facility[]" multiple style
="width:150px;" >
417 $userFacilities = getUserFacilities($_GET['id']);
419 foreach($userFacilities as $uf)
421 $fres = sqlStatement("select * from facility where service_location != 0 order by name");
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
>
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
>
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;" >
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";
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
>
461 <!-- (CHEMED
) Calendar UI preference
-->
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;" >
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";
476 <!-- END (CHEMED
) Calendar UI preference
-->
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
>
483 <?php
echo generate_select_list("erxrole", "newcrop_erx_role", $iter['newcrop_user_role'],'',xl('Select Role'),'','','',array('style'=>'width:150px')); ?
>
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
>
491 <?php
if ($GLOBALS['inhouse_pharmacy']) { ?
>
493 <td
class="text"><?php
xl('Default Warehouse','e'); ?
>: </td
>
496 echo generate_select_list('default_warehouse', 'warehouse',
497 $iter['default_warehouse'], '');
500 <td
class="text"><?php
xl('Invoice Refno Pool','e'); ?
>: </td
>
503 echo generate_select_list('irnpool', 'irnpool', $iter['irnpool'],
504 xl('Invoice reference number pool, if used'));
511 // Collect the access control group of user
512 if (isset($phpgacl_location) && acl_check('admin', 'acl')) {
515 <td
class='text'><?php
xl('Access Control','e'); ?
>:</td
>
516 <td
><select id
="access_group_id" name
="access_group[]" multiple style
="width:150px;" >
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";
526 // Modified 6-2009 by BM - Translate group name if applicable
527 echo " <option value='$value'>" . xl_gacl_group($value) . "</option>\n";
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
>
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'); ?
>
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"> 
;</div
>
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']; ?>">
556 <script language
="JavaScript">
557 $
(document
).ready(function(){
558 $
("#cancel").click(function() {
559 parent
.$
.fn
.fancybox
.close();
569 // d41d8cd98f00b204e9800998ecf8427e == blank