217 lines
8.7 KiB
PHP
217 lines
8.7 KiB
PHP
<?php
|
|
// 베이커리 재고관리
|
|
include_once "_common.php";
|
|
// 배포 시 아래 주석 해제
|
|
// if (!isset($_SESSION['user_id'])) header( 'Location: FG_MANAGER_URL' ); // 로그인 되어있지 않으면 로그인 페이지로 보냄
|
|
|
|
include_once "head.php";
|
|
|
|
// 검색 변수 초기화
|
|
!isset($search) ?? "";
|
|
!isset($where) ?? "";
|
|
!isset($search_count) ?? "";
|
|
|
|
$is_debug = false; // 디버깅 시 true로 변경
|
|
$is_member = true;
|
|
|
|
// ord_by 로 넘어온 값이 있으면 반영
|
|
$ord_by = isset($_REQUEST["ord_by"]) ? $_REQUEST["ord_by"] : "product_name ASC";
|
|
|
|
// 날짜로 검색한 경우 해당 날짜를 사용하고, 아닌 경우 오늘 날짜를 사용함
|
|
$searchDate = isset($_REQUEST["searchDate"]) ? $_REQUEST["searchDate"] : date("Y-m-d"); // 검색일
|
|
$prevDate = date("Y-m-d", strtotime("-1 day", strtotime($searchDate))); // 검색 전일
|
|
$edit_datetime = date('Y-m-d H:i:s'); // 최종 수정 시간 업데이트
|
|
|
|
$authInfo = getAuthorInfo($searchDate);
|
|
if (!$authInfo) {
|
|
$authInfo = ['worker' => '', 'author' => ''];
|
|
}
|
|
|
|
$table = $fg['visitor_category_table'];
|
|
$record_count = get_num_rows($table);
|
|
$ord_by = " ORDER BY idx ASC ";
|
|
$R = get_result($table, $ord_by, $query_limit);
|
|
|
|
?>
|
|
<style>
|
|
.bakery tfoot {
|
|
font-weight: 600;
|
|
}
|
|
.sort-icon {
|
|
margin-left: 5px;
|
|
font-size: 12px;
|
|
vertical-align: middle;
|
|
}
|
|
</style>
|
|
|
|
<h2 class="mb-3">항목관리</h2>
|
|
|
|
|
|
<div class="d-flex justify-content-between">
|
|
<div class="text-left">
|
|
전체 구분 수 : <b><?=$record_count?></b>
|
|
</div>
|
|
<div>
|
|
<button type="button" class="btn btn-primary btn-sm" data-bs-toggle="modal" data-bs-target="#add_modal">추가</button>
|
|
<!-- 추가 버튼을 누르면 출력한다. -->
|
|
<div id="add_modal" class="modal fade text-center"">
|
|
<div class="modal-dialog" style="width:800px;">
|
|
<div class="modal-content">
|
|
<form class="signup" action="adm_category.update.php" method="post">
|
|
<input type="hidden" id="mode" name="mode" value="add" readonly>
|
|
<div class="modal-header">
|
|
<h4 class="modal-title">추가</h4>
|
|
</div>
|
|
<div class="modal-body text-left">
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="cat01">대분류</span>
|
|
<input type="text" class="form-control" id="cat01" name="cat01" value="" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="cat02">중분류</span>
|
|
<input type="text" class="form-control" id="cat02" name="cat02" value="" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="cat03">소분류</span>
|
|
<input type="text" class="form-control" id="cat03" name="cat03" value="" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="code">항목코드</span>
|
|
<input type="text" class="form-control" id="code" name="code" value="" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="name">이름</span>
|
|
<input type="text" class="form-control" id="name" name="name" value="" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="unit_price">단가</span>
|
|
<input type="text" class="form-control" id="unit_price" name="unit_price" value="" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="memo">메모</span>
|
|
<textarea class="form-control" id="memo" name="memo" value="" ></textarea>
|
|
</div>
|
|
</div>
|
|
<div class="modal-footer">
|
|
<button type="submit" id="add_submit" class="btn btn-primary">추가</button>
|
|
<button type="button" class="btn btn-default" data-bs-dismiss="modal">닫기</button>
|
|
</div>
|
|
</form>
|
|
</div><!-- /.modal-content -->
|
|
</div><!-- /.modal-dialog -->
|
|
</div>
|
|
</div>
|
|
</div>
|
|
|
|
<div class="text-center">
|
|
<table class="table table-striped">
|
|
<colgroup>
|
|
<col width="40px">
|
|
<col width="120px">
|
|
<col width="120px">
|
|
<col width="120px">
|
|
<col />
|
|
<col width="150px">
|
|
<col width="80px">
|
|
<col width="80px">
|
|
</colgroup>
|
|
<thead>
|
|
<tr>
|
|
<th class="text-center">No.</th>
|
|
<th class="text-center">구분1</th>
|
|
<th class="text-center">구분2</th>
|
|
<th class="text-center">구분3</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
|
|
if (count($R)) {
|
|
foreach($R as $R){?>
|
|
<tr class="<?=(($R['used'] != 1) ? "unused" : "")?>">
|
|
<td class="text-center"><?=$R['idx']?></td>
|
|
<td class="text-center"><?=$R['cat01']?></td>
|
|
<td class="text-center"><?=$R['cat02']?></td>
|
|
<td class="text-center"><?=$R['cat03']?></td>
|
|
<td class="text-center"><?=$R['name']?></td>
|
|
<td class="text-center"><?=number_format($R['unit_price'])?></td>
|
|
<td class="text-center"><?=$R['used']?></td>
|
|
<td class="text-center">
|
|
<!-- 수정 버튼 -->
|
|
<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>
|
|
<!-- 수정 모달 -->
|
|
<div id="modify_modal_<?=$R['idx']?>" class="modal fade">
|
|
<div class="modal-dialog">
|
|
<div class="modal-content">
|
|
<form class="modify" action="adm_category.update.php" method="post">
|
|
<input type="hidden" class="form-control" id="idx" name="idx" value="<?=$R['idx']?>" readonly>
|
|
<input type="hidden" class="form-control" id="mode" name="mode" value="modify" readonly>
|
|
<div class="modal-header">
|
|
<h4 class="modal-title"><?=$R['name']?> 정보 수정</h4>
|
|
</div>
|
|
<div class="modal-body">
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="cat01_<?=$R['idx']?>">대분류</span>
|
|
<input type="text" class="form-control" id="cat01_<?=$R['idx']?>" name="cat01" value="<?=$R['cat01']?>" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="cat02_<?=$R['idx']?>">중분류</span>
|
|
<input type="text" class="form-control" id="cat02_<?=$R['idx']?>" name="cat02" value="<?=$R['cat02']?>" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="cat03_<?=$R['idx']?>">소분류</span>
|
|
<input type="text" class="form-control" id="cat03_<?=$R['idx']?>" name="cat03" value="<?=$R['cat03']?>" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="name_<?=$R['idx']?>">이름</span>
|
|
<input type="text" class="form-control" id="name_<?=$R['idx']?>" name="name" value="<?=$R['name']?>" required>
|
|
</div>
|
|
<div class="input-group mb-1">
|
|
<span class="input-group-text col-md-2" id="unit_price_<?=$R['idx']?>">단가</span>
|
|
<input type="text" class="form-control" id="unit_price_<?=$R['idx']?>" name="unit_price" value="<?=$R['unit_price']?>" required>
|
|
</div>
|
|
<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 class="mb-3">
|
|
<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-primary" 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-primary" for="used_<?=$R['idx']?>_0">비활성</label>
|
|
</div>
|
|
</div>
|
|
<div class="modal-footer">
|
|
<button type="submit" class="btn btn-primary">수정</button>
|
|
<button type="button" class="btn btn-default" data-bs-dismiss="modal">닫기</button>
|
|
</div>
|
|
</form>
|
|
</div><!-- /.modal-content -->
|
|
</div><!-- /.modal-dialog -->
|
|
</div>
|
|
<!-- 수정 모달 끝 -->
|
|
</td>
|
|
</tr>
|
|
<?php
|
|
} // endforeach
|
|
} else { ?>
|
|
<tr>
|
|
<td colspan="8">데이터가 없습니다.</td>
|
|
</tr>
|
|
<?php } // endif ?>
|
|
</tbody>
|
|
<tfoot>
|
|
<tr>
|
|
<td colspan="8" class="text-right">
|
|
</td>
|
|
</tr>
|
|
</tfoot>
|
|
</table>
|
|
</div>
|
|
|
|
|
|
<?php include_once FG_MANAGER_PATH."/tail.php";
|