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'))
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"] ."'" ;
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
"]}");
34 $tqvar = formData('upin','G');
35 sqlStatement("update users set upin='$tqvar' where id={$_GET["id
"]}");
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
"]}");
46 $tqvar = formData('lname','G');
47 sqlStatement("update users set lname='$tqvar' where id={$_GET["id
"]}");
50 $tqvar = formData('job','G');
51 sqlStatement("update users set specialty='$tqvar' where id={$_GET["id
"]}");
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
"]}");
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',
73 table_id = {$_GET["id
"]}");
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
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");
135 <script type="text/javascript">
137 parent.$.fn.fancybox.close();
144 $res = sqlStatement("select * from users where id=?",array($_GET["id"]));
145 for ($iter = 0;$row = sqlFetchArray($res);$iter++
)
146 $result[$iter] = $row;
150 if (isset($_POST["mode"])) {
152 <script type="text/javascript">
154 parent.$.fn.fancybox.close();
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"); ?
>
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";
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.
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
);
207 top
.restoreSession();
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
);
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'; ?>");
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
))
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']){ ?
>
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
);
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();
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
;
302 function authorized_clicked() {
303 var f
= document
.forms
[0];
304 f
.calendar
.disabled
= !f
.authorized
.checked
;
305 f
.calendar
.checked
= f
.authorized
.checked
;
309 <style type
="text/css">
310 .physician_type_class
{
311 width
: 150px
!important
;
315 <body
class="body_top">
317 <span
class="title"><?php
xl('Edit User','e'); ?
></span
> 
;
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
>
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
="">
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
-->
345 $acl_name=acl_get_group_titles($iter["username"]);
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>
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
>
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
>
370 <TR height
="30" style
="valign:middle;">
371 <td
><span
class="text"> 
;</span
></td
><td
> 
;</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  
; 
;<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  
; 
;<span
class='text'><?php
xl('Active','e'); ?
>:
380 <input type
="checkbox" name
="active"<?php
if ($iter["active"]) echo " checked"; ?
> />
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"> 
;*</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
>
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"> 
;*</span
></td
>
392 <td
><span
class=text
><?php
xl('Default Facility','e'); ?
>: </span
></td
><td
><select name
=facility_id style
="width:150px;" >
394 $fres = sqlStatement("select * from facility where service_location != 0 order by name");
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
>
408 <?php
if ($GLOBALS['restrict_user_facility']) { ?
>
410 <td colspan
=2> 
;</td
>
411 <td
><span
class=text
><?php
xl('Schedule Facilities:', 'e');?
></td
>
413 <select name
="schedule_facility[]" multiple style
="width:150px;" >
415 $userFacilities = getUserFacilities($_GET['id']);
417 foreach($userFacilities as $uf)
419 $fres = sqlStatement("select * from facility where service_location != 0 order by name");
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
>
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
>
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;" >
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";
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
>
459 <!-- (CHEMED
) Calendar UI preference
-->
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;" >
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";
474 <!-- END (CHEMED
) Calendar UI preference
-->
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
>
481 <?php
echo generate_select_list("erxrole", "newcrop_erx_role", $iter['newcrop_user_role'],'',xl('Select Role'),'','','',array('style'=>'width:150px')); ?
>
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
>
489 <?php
if ($GLOBALS['inhouse_pharmacy']) { ?
>
491 <td
class="text"><?php
xl('Default Warehouse','e'); ?
>: </td
>
494 echo generate_select_list('default_warehouse', 'warehouse',
495 $iter['default_warehouse'], '');
498 <td
class="text"><?php
xl('Invoice Refno Pool','e'); ?
>: </td
>
501 echo generate_select_list('irnpool', 'irnpool', $iter['irnpool'],
502 xl('Invoice reference number pool, if used'));
509 // Collect the access control group of user
510 if (isset($phpgacl_location) && acl_check('admin', 'acl')) {
513 <td
class='text'><?php
xl('Access Control','e'); ?
>:</td
>
514 <td
><select id
="access_group_id" name
="access_group[]" multiple style
="width:150px;" >
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";
524 // Modified 6-2009 by BM - Translate group name if applicable
525 echo " <option value='$value'>" . xl_gacl_group($value) . "</option>\n";
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
>
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'); ?
>
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"> 
;</div
>
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']; ?>">
554 <script language
="JavaScript">
555 $
(document
).ready(function(){
556 $
("#cancel").click(function() {
557 parent
.$
.fn
.fancybox
.close();
567 // d41d8cd98f00b204e9800998ecf8427e == blank