hskwon
aca1767eb9
- URL 하드코딩 → .env APP_URL 기반 동적 URL로 변경 - DB 연결 하드코딩 → .env 기반으로 변경 - MySQL strict mode DATE 오류 수정
162 lines
5.0 KiB
PHP
162 lines
5.0 KiB
PHP
<?php
|
|
require_once($_SERVER['DOCUMENT_ROOT'] . "/session.php");
|
|
|
|
isset($_REQUEST["num"]) ? $num=$_REQUEST["num"] : $num=$_REQUEST["num"];
|
|
require_once("../lib/mydb.php");
|
|
$pdo = db_connect();
|
|
|
|
try{
|
|
$sql = "select * from mirae8440.almember where num = ? ";
|
|
$stmh = $pdo->prepare($sql);
|
|
$stmh->bindValue(1,$num,PDO::PARAM_STR);
|
|
$stmh->execute();
|
|
$count = $stmh->rowCount();
|
|
$row = $stmh->fetch(PDO::FETCH_ASSOC); // $row 배열로 DB 정보를 불러온다.
|
|
|
|
include 'rowDB.php';
|
|
|
|
}catch (PDOException $Exception) {
|
|
print "오류: ".$Exception->getMessage();
|
|
}
|
|
// end of if
|
|
|
|
?>
|
|
|
|
<!DOCTYPE html>
|
|
<html lang="ko">
|
|
<head>
|
|
|
|
<meta charset="utf-8">
|
|
<meta http-equiv="X-UA-Compatible" content="IE=edge">
|
|
<meta name="viewport" content="width=device-width, initial-scale=1">
|
|
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
|
|
<meta name="description" content="">
|
|
<meta name="author" content="">
|
|
|
|
<!-- Bootstrap CSS -->
|
|
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" >
|
|
<!-- Optional JavaScript -->
|
|
<!-- jQuery first, then Popper.js, then Bootstrap JS -->
|
|
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
|
|
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"></script>
|
|
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" ></script>
|
|
|
|
</head>
|
|
<style>
|
|
|
|
html,body {
|
|
height: 100%;
|
|
}
|
|
</style>
|
|
<body>
|
|
<div class="container h-50">
|
|
<div class="row d-flex justify-content-center align-items-center h-100">
|
|
<div class="col-1"></div>
|
|
<div class="col-12 text-center">
|
|
<div class="card align-middle" style="width:30rem; border-radius:20px;">
|
|
<div class="card" style="padding:10px;margin:10px;">
|
|
<h3 class="card-title text-center" style="color:#113366;"> 연차일수 정보 등록/조회/수정 </h3>
|
|
</div>
|
|
<div class="card-body text-center">
|
|
<form id="board_form" class="form-signin" method="post" action="insert.php" >
|
|
<input type="hidden" id="mode" name="mode">
|
|
<input type="hidden" id="num" name="num" value="<?=$num?>" >
|
|
|
|
|
|
<h5 class="form-signin-heading">성명</h5>
|
|
<input type="text" name="name" class="form-control" placeholder="성명" required value="<?=$name?>" >
|
|
<h5 class="form-signin-heading">부서</h5>
|
|
|
|
<select name="part" id="part" class="form-control" >
|
|
<?php
|
|
for($i=0;$i<count($basic_part_arr);$i++) {
|
|
if($part==$basic_part_arr[$i])
|
|
print "<option selected value='" . $basic_part_arr[$i] . "'> " . $basic_part_arr[$i] . "</option>";
|
|
else
|
|
print "<option value='" . $basic_part_arr[$i] . "'> " . $basic_part_arr[$i] . "</option>";
|
|
}
|
|
?>
|
|
</select>
|
|
|
|
|
|
<h5 class="form-signin-heading">입사일</h5>
|
|
<input type="date" name="dateofentry" class="form-control" placeholder="입사일" required value="<?=$dateofentry?>" >
|
|
<h5 class="form-signin-heading">해당연도</h5>
|
|
<input type="number" name="referencedate" class="form-control" placeholder="해당연도" required value="<?=$referencedate?>" >
|
|
<h5 class="form-signin-heading">연차 발생일수</h5>
|
|
<input type="number" name="availableday" class="form-control" placeholder="발생일수" required autofocus value="<?=$availableday?>" ><br>
|
|
|
|
<button id="saveBtn" class="btn btn-lg btn-secondary btn-block" type="button">등록</button>
|
|
</form>
|
|
</div>
|
|
</div>
|
|
</div>
|
|
<div class="col-1"></div>
|
|
</div>
|
|
|
|
</div>
|
|
|
|
|
|
<form id=Form1 name="Form1">
|
|
<input type=hidden id="steelcompany" name="steelcompany[]" >
|
|
</form>
|
|
|
|
|
|
<script>
|
|
|
|
$(document).ready(function(){
|
|
|
|
$("#closeBtn").click(function(){ // 저장하고 창닫기
|
|
|
|
// data저장을 위한 ajax처리구문
|
|
// $.ajax({
|
|
// url: "registcompany_process.php",
|
|
// type: "post",
|
|
// data: $("#Form1").serialize(),
|
|
// dataType:"json",
|
|
// success : function( data ){
|
|
// console.log( data);
|
|
// },
|
|
// error : function( jqxhr , status , error ){
|
|
// console.log( jqxhr , status , error );
|
|
// }
|
|
// });
|
|
|
|
// window.close();
|
|
});
|
|
|
|
|
|
$("#saveBtn").click(function(){ // DATA 저장버튼 누름
|
|
|
|
$("#mode").val('insert');
|
|
|
|
$.ajax({
|
|
url: "insert.php",
|
|
type: "post",
|
|
data: $("#board_form").serialize(),
|
|
dataType:"json",
|
|
success : function( data ){
|
|
console.log( data);
|
|
opener.location.reload();
|
|
window.close();
|
|
},
|
|
error : function( jqxhr , status , error ){
|
|
console.log( jqxhr , status , error );
|
|
}
|
|
});
|
|
|
|
|
|
});
|
|
|
|
$("#deldataBtn").click(function(){ deldataDo(); });
|
|
$("#SelInsertDataBtn").click(function(){ SelInsertData(); });
|
|
|
|
|
|
}); // end of ready document
|
|
|
|
|
|
</script>
|
|
</body>
|
|
</html>
|
|
|