231 lines
11 KiB
PHP
231 lines
11 KiB
PHP
<?php
|
|
include_once "_common.php";
|
|
if (!isset($_SESSION['user_id'])) header( 'Location: FG_MANAGER_URL' ); // 로그인 되어있지 않으면 로그인 페이지로 보냄
|
|
|
|
include_once FG_MANAGER_PATH."/head.php";
|
|
|
|
$table = "{$fg['member_table']} AS a LEFT JOIN {$fg['member_group_table']} AS b ON a.tid = b.tid";
|
|
if ( $_SESSION['user_lv'] == 4 ) { // 시스템관리자는 모든 계정 열람 가능함
|
|
$where = "";
|
|
} else { // 아닌경우 로그인 계정과 동일 부서이면서 낮은 등급의 계정만 처리가능
|
|
$where = "WHERE user_lv < '{$_SESSION['user_lv']}' AND tname = '{$_SESSION['user_team']}' OR user_id = '{$_SESSION['user_id']}'";
|
|
}
|
|
$record_count = get_num_rows($table);
|
|
$ord_by = " ORDER BY idx ASC ";
|
|
$R = get_result($table, $ord_by, $query_limit, $where);
|
|
?>
|
|
<div class="d-flex justify-content-between align-items-center">
|
|
<p>전체 계정 수 : <b><?=$record_count; ?></b></p>
|
|
<button type="button" class="btn btn-primary" data-bs-toggle="modal" data-bs-target="#add_modal">추가</button>
|
|
</div>
|
|
<div class="text-center">
|
|
<table class="table table-striped align-middle">
|
|
<colgroup>
|
|
<!-- <col width="70px">-->
|
|
<col width="150px">
|
|
<col width="100px">
|
|
<col width="100px">
|
|
<col>
|
|
<col width="200px">
|
|
<col width="200px">
|
|
<col width="200px">
|
|
<col width="110px">
|
|
</colgroup>
|
|
<thead>
|
|
<tr>
|
|
<!--<th class="text-center">번호</th>-->
|
|
<th class="text-center">부서</th>
|
|
<th class="text-center">이름</th>
|
|
<th class="text-center">ID</th>
|
|
<th class="text-center">설명</th>
|
|
<th class="text-center">최종 로그인</th>
|
|
<th class="text-center">계정 생성일</th>
|
|
<th class="text-center">권한</th>
|
|
<th class="text-center">관리</th>
|
|
</tr>
|
|
</thead>
|
|
<!-- 목록 출력 -->
|
|
<tbody>
|
|
<?php foreach($R as $R){ ?>
|
|
<tr class="<?=($R['used'] == 1) ? "" : "unused"?>">
|
|
<!--<td class="text-center"><?=$R['idx']?></td>-->
|
|
<td class="text-center align-middle"><?=$R['tname']?></td>
|
|
<td class="text-center"><?=$R['user_name']?></td>
|
|
<td class="text-center"><?=$R['user_id']?></td>
|
|
<td class="text-center"><?=nl2br($R['memo'])?></td>
|
|
<td class="text-center"><?=$R['last_login_time']?></td>
|
|
<td class="text-center"><?=$R['join_datetime']?></td>
|
|
<td class="text-center">
|
|
<?php
|
|
// 레벨 확인하여 권한 확인
|
|
if($R['user_lv'] == 1){
|
|
echo "읽기전용";
|
|
} else if($R['user_lv'] == 2){
|
|
echo "읽기/VIP추가";
|
|
} else if($R['user_lv'] == 3){
|
|
echo "읽기/VIP관리/계정추가";
|
|
} else if($R['user_lv'] == 4){
|
|
echo "시스템관리자";
|
|
}
|
|
?></td>
|
|
<td class="text-center">
|
|
<!-- 수정 페이지 -->
|
|
<div id="modify_modal_<?=$R['idx']?>" class="modal fade center ">
|
|
<div class="modal-dialog">
|
|
<div class="modal-content">
|
|
<form class="modify">
|
|
<input type="hidden" id="idx" name="idx" value="<?=$R['idx']?>" readonly>
|
|
<div class="modal-header">
|
|
<h4 class="modal-title">정보 수정</h4>
|
|
</div>
|
|
<div class="modal-body text-left">
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="user_id_<?=$R['idx']?>">ID</span>
|
|
<input type="text" class="form-control" oninput="checkDupID(this.value)" id="user_id_<?=$R['idx']?>" name="user_id" value="<?=$R['user_id']?>">
|
|
</div>
|
|
<div class="input-group mb-1 checkdup">
|
|
<span id="duplicate-id-warning"></span>
|
|
</div>
|
|
<?php if ($_SESSION['user_id'] === $R['user_id'] ) { // 자기계정인 경우 패스워드 물어봄 ?>
|
|
<div class="input-group mb-1">
|
|
기존 패스워드 입력
|
|
</div>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="user_pw_<?=$R['idx']?>">PW</span>
|
|
<input type="text" class="form-control" id="user_pw_<?=$R['idx']?>" name="user_pw" value="">
|
|
</div>
|
|
<?php } ?>
|
|
<div class="input-group mb-1">
|
|
공란으로 두는경우 변경안함
|
|
</div>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="user_pw_new_<?=$R['idx']?>">변경PW</span>
|
|
<input type="text" class="form-control" id="user_pw_new_<?=$R['idx']?>" name="user_pw_new" value="">
|
|
</div>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="tid_<?=$R['idx']?>">부서</span>
|
|
<select id="tid" name="tid" class="form-select">
|
|
<option value="<?=$R['tid']?>" selected><?=$R['tname']?></option>
|
|
<?php
|
|
foreach (getTeamName() as $row) {
|
|
if ($row['tid'] === $R['tid']) continue;
|
|
?>
|
|
<option value="<?=$row['tid']?>"><?=$row['tname']?></option>
|
|
<?php } ?>
|
|
</select>
|
|
</div>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="user_name_<?=$R['idx']?>">성명</span>
|
|
<input type="text" class="form-control" id="user_name_<?=$R['idx']?>" name="user_name" value="<?=$R['user_name']?>" ><br>
|
|
</div>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="user_lv_<?=$R['idx']?>">권한</span>
|
|
|
|
<input type="radio" class="btn-check" name="user_lv" id="user_lv_<?=$R['idx']?>_1" value="1" <?=($R['user_lv'] == 1) ? "checked" : "" ?> required>
|
|
<label class="btn btn-outline-info" for="user_lv_<?=$R['idx']?>_1">읽기</label>
|
|
<?php if($_SESSION['user_lv'] >= 3){ ?>
|
|
<input type="radio" class="btn-check" name="user_lv" id="user_lv_<?=$R['idx']?>_2" value="2" <?=($R['user_lv'] == 2) ? "checked" : "" ?> required>
|
|
<label class="btn btn-outline-info" for="user_lv_<?=$R['idx']?>_2">VIP추가</label>
|
|
<?php } if($_SESSION['user_lv'] >= 4){ ?>
|
|
<input type="radio" class="btn-check" name="user_lv" id="user_lv_<?=$R['idx']?>_3" value="3" <?=($R['user_lv'] == 3) ? "checked" : "" ?> required>
|
|
<label class="btn btn-outline-info" for="user_lv_<?=$R['idx']?>_3">사용자추가</label>
|
|
<input type="radio" class="btn-check" name="user_lv" id="user_lv_<?=$R['idx']?>_4" value="4" <?=($R['user_lv'] == 4) ? "checked" : "" ?> required>
|
|
<label class="btn btn-outline-info" for="user_lv_<?=$R['idx']?>_4">시스템관리자</label>
|
|
<?php } ?>
|
|
</div>
|
|
<?php if($_SESSION['user_lv'] == 4 || $_SESSION['user_lv'] > $R['user_lv'] ){ ?>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="used_<?=$R['idx']?>">활성화</span>
|
|
<input type="radio" class="btn-check" name="used" id="used_<?=$R['idx']?>_1" value="1" <?=($R['used'] == 1) ? "checked" : "" ?> required>
|
|
<label class="btn btn-outline-info" for="used_<?=$R['idx']?>_1">활성화</label>
|
|
<input type="radio" class="btn-check" name="used" id="used_<?=$R['idx']?>_0" value="0" <?=($R['used'] != 1) ? "checked" : "" ?> required>
|
|
<label class="btn btn-outline-info" for="used_<?=$R['idx']?>_0">비활성화</label>
|
|
</div>
|
|
<?php } else { ?>
|
|
<input type="hidden" name="used" id="used_<?=$R['idx']?> value ="<?=$R['used']?>">
|
|
<?php } // 계정 활성화 체크 끝 ?>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="memo_<?=$R['idx']?>">메모</span>
|
|
<textarea class="form-control" id="memo_<?=$R['idx']?>" name="memo" ><?=$R['memo']?></textarea>
|
|
</div>
|
|
</div>
|
|
<div class="modal-footer">
|
|
<button type="submit" class="btn btn-primary">수정</button>
|
|
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">닫기</button>
|
|
</div>
|
|
</form>
|
|
</div><!-- /.modal-content -->
|
|
</div><!-- /.modal-dialog -->
|
|
</div>
|
|
<!-- 수정 버튼 -->
|
|
<button class="btn btn-success btn-xs" data-bs-toggle="modal" data-bs-target="#modify_modal_<?=$R['idx']?>"><i class="fa-solid fa-pen-to-square"></i></button>
|
|
<a class="btn btn-danger btn-xs" href="javascript:deleteItem('<?=$R['idx']?>')" role="button"><i class="fa-solid fa-trash-can"></i></a>
|
|
</td>
|
|
</tr>
|
|
<?php } ?>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
|
|
|
|
<!-- 추가 페이지 -->
|
|
<div id="add_modal" class="modal fade text-center"">
|
|
<div class="modal-dialog" style="width:800px;">
|
|
<div class="modal-content">
|
|
<form class="signup">
|
|
<div class="modal-header">
|
|
<h4 class="modal-title">사용자 추가</h4>
|
|
</div>
|
|
<div class="modal-body text-left">
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="user_id">ID</span>
|
|
<input type="text" class="form-control" id="user_id" name="user_id">
|
|
</div>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="user_pw">PW</span>
|
|
<input type="text" class="form-control" id="user_pw" name="user_pw">
|
|
</div>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="tid">부서</span>
|
|
<option value="">부서선택</option>
|
|
<select id="tid" name="tid" class="form-select">
|
|
<?php
|
|
foreach (getTeamName() as $row) {
|
|
?>
|
|
<option value="<?=$row['tid']?>"><?=$row['tname']?></option>
|
|
<?php } ?>
|
|
</select>
|
|
</div>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="user_name">성명</span>
|
|
<input type="text" class="form-control" id="user_name" name="user_name">
|
|
</div>
|
|
<div class="input-group mb-3">
|
|
<span class="input-group-text col-md-2" id="user_lv">권한</span>
|
|
<?php if($_SESSION > 2) { ?>
|
|
<input type="radio" class="btn-check" name="user_lv" id="user_lv_1" value="1" checked required>
|
|
<label class="btn btn-outline-info" for="user_lv_1">읽기</label>
|
|
<input type="radio" class="btn-check" name="user_lv" id="user_lv_2" value="2" required>
|
|
<label class="btn btn-outline-info" for="user_lv_2">VIP추가</label>
|
|
<?php } if($_SESSION['user_lv'] == "4"){ ?>
|
|
<input type="radio" class="btn-check" name="user_lv" id="user_lv_3" value="3" required>
|
|
<label class="btn btn-outline-info" for="user_lv_3">사용자추가</label>
|
|
<input type="radio" class="btn-check" name="user_lv" id="user_lv_4" value="4" required>
|
|
<label class="btn btn-outline-info" for="user_lv_4">시스템관리자</label>
|
|
<?php } ?>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="memo">메모</span>
|
|
<textarea class="form-control" name="memo" id="memo"></textarea>
|
|
</div>
|
|
</div>
|
|
<div class="modal-footer">
|
|
<button type="submit" class="btn btn-primary">추가</button>
|
|
<button type="button" class="btn btn-secondary" data-bs-dismiss="modal">닫기</button>
|
|
</div>
|
|
</form>
|
|
</div><!-- /.modal-content -->
|
|
</div><!-- /.modal-dialog -->
|
|
</div>
|
|
|
|
<?php include_once FG_MANAGER_PATH."/tail.php";
|