Files
KIN/management/vac_manage.asp
2025-09-29 17:55:08 +09:00

297 lines
14 KiB
Plaintext
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<!-- #include virtual = "include/header.asp" -->
<!-- #include virtual = "include/left.asp" -->
<%
dim defaultDate
defaultDate = cstr(date)
if request("datepicker") <> "" then
defaultDate = request("datepicker")
end if
%>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<style>
td[data-subholi]:not([data-subholi='0']){
font-weight: bold;
color: #000eb3;
font-size: 14px;
}
#ifrm_month_vac{
width:100%;
height:99%;
border:0;
}
</style>
<!-- Content Header (Page header) -->
<div class="content-header">
<h1>연차휴가 관리</h1>
</div>
<!-- /.content-header -->
<!-- Main content -->
<div class="content-body">
<div class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div style="margin-bottom: 5px; position:relative;">
기준날짜 : &nbsp;<input type="text" id="datepicker" value="<%=defaultDate%>" style="text-align:center;padding-left:10px;width:120px;cursor:pointer;" readonly>
<span style="color:#AAA;"> (* 날짜를 변경하면 해당하는 날짜 기준으로 연차휴가를 조회합니다.)</span>
<input type="button" value="연차 사용현황" id="month_vac_btn" style='cursor:pointer;position:absolute;right:0px;'/>
</div>
<div id='monthVacDialog'><iframe id='ifrm_month_vac' src=''></iframe></div>
<table class="table table-sm table-sm2 table-bordered table-head tr-colors">
<tr>
<td width="5%" align="center">증감<br>기록</td>
<td width="12%" align="center">입사일자</td>
<td width="10%" align="center">성명</td>
<td width="18%" align="center">부서/직책</td>
<td width="10%" align="center">휴가시즌<br>구분</td>
<td width="10%" align="center">총<br>연차수</td>
<td width="14%" align="center">관리자 증감<br>연차수</td>
<td width="7%" align="center">사용<br>연차수</td>
<td width="7%" align="center">잔여<br>연차수</td>
<td width="7%" align="center">대체휴무<br>사용수</td>
</tr>
<%
query = ""
query = query & " SELECT krc_in_date, T.p_no, p_name, p_team_name,"
query = query & " T.vac_season, vac_rem, vac_use, ISNULL(C.vac_change_cnt, 0) AS vac_change_cnt, "
query = query & " vac_rem - vac_use + ISNULL(C.vac_change_cnt, 0) AS vac_possi, ISNULL(vac_change, 0) AS vac_change, ISNULL(subholi_cnt, 0) AS subholi_cnt "
query = query & " FROM "
query = query & " ("
query = query & " SELECT krc_in_date, p_no, p_name, p_team_name, "
query = query & " dbo.VAC_REM(p_no, '" & defaultDate & "') AS vac_rem, "
query = query & " dbo.VAC_USE(p_no, '" & defaultDate & "') AS vac_use, "
query = query & " dbo.VAC_YEAR(p_no, '" & defaultDate & "') AS vac_season"
query = query & " FROM project2.dbo.V_person "
query = query & " WHERE p_resign='0' AND krc_in_date IS NOT NULL"
query = query & " ) T LEFT JOIN "
query = query & " ("
query = query & " SELECT p_no, vac_season,"
query = query & " sum(vac_change_cnt) AS vac_change_cnt, "
query = query & " count(*) AS vac_change "
query = query & " FROM project2.dbo.T_VACATION_CUSTOM "
query = query & " WHERE vac_change_yn = 'Y' "
query = query & " GROUP BY p_no, vac_season"
query = query & " ) C "
query = query & " ON T.p_no = C.p_no AND T.vac_season = C.vac_season LEFT JOIN "
query = query & " ( "
query = query & " SELECT p_no, dbo.VAC_YEAR(p_no, j_date) AS vac_season, count(*) AS subholi_cnt "
query = query & " FROM V_Job_List "
query = query & " WHERE j_contents = '9' "
query = query & " GROUP BY p_no, dbo.VAC_YEAR(p_no, j_date) "
query = query & " ) S ON T.p_no = S.p_no AND T.vac_season = S.vac_season "
query = query & " ORDER BY krc_in_date"
adoRs.Open query, adoconn, 1' adOpenForwardOnly
do while not adoRs.eof
%>
<tr>
<td align="center">
<% if cDbl(adoRs("vac_change")) > 0 then %>
<input type="button" value="▶" id="vac_change_log" style="cursor:pointer;margin:0;padding:1px 10px;border:0;background:rgba(255,255,255,0);" data-rowinf="<%=adoRs("p_no")%>|<%=adoRs("vac_season")%>"/>
<% end if %>
</td>
<td align="center"><%=adoRs("krc_in_date")%></td>
<td align="center"><%=adoRs("p_name")%></td>
<td align="center"><%=adoRs("p_team_name")%></td>
<td align="center"><%=adoRs("vac_season")%></td>
<td align="center"><%=adoRs("vac_rem")%></td>
<td><%
dim changeCntColor : changeCntColor="gray"
dim cntSign : cntSign = "&nbsp;"
if cDbl(adoRs("vac_change_cnt")) > 0 then
changeCntColor="blue"
cntSign="+"
elseif cDbl(adoRs("vac_change_cnt")) < 0 then
changeCntColor="red"
cntSign=""
end if
%>
<span style='color:<%=changeCntColor%>;width:40%;display:inline-block;'><%=cntSign%><%=adoRs("vac_change_cnt")%></span>
<%
dim vacChangeRem : vacChangeRem = cDbl(adoRs("vac_rem")) + cDbl(adoRs("vac_change_cnt"))
if vacChangeRem = adoRs("vac_rem") then
vacChangeRem = ""
end if
%>
<span style='color:<%=changeCntColor%>;width: calc(30% - 10px);display: inline-block;'><%=vacChangeRem%></span>
<span style='width: 30%;display: inline-block;text-align:right;'>
<% if adoRs("vac_season") <> "X" then %>
<input type="button" value="+ / -" id="vac_control" style="height:19px;width:60px;cursor:pointer;padding:0;font-weight:bold;" data-rowinf="<%=adoRs("p_no")%>|<%=adoRs("vac_season")%>"/>
<% end if %>
</span>
</td>
<td align="center"><%=adoRs("vac_use")%></td>
<td align="center"><%=adoRs("vac_possi")%></td>
<td align="center" data-subholi='<%=adoRs("subholi_cnt")%>'><%=adoRs("subholi_cnt")%></td>
</tr>
<%
adoRs.movenext
loop
adoRs.close
%>
</table>
<div id='vac_change_dialog'>
· 증감 연차수 : <input type="number" min="-25" max="25" step="0.5" id="changeNum" class='useMinus' value="0" />
<span style='color:#AAA;'>(방향키 ↑, ↓만 이용하세요)</span>
<br>
<span style='color:#AAA;'> * 증감 연차수는 -25 ~ 25 까지 선택할 수 있습니다.</span><br>
· 증감 사유  : <textarea style="resize: none;vertical-align:middle;margin-top:12px;width:250px;" spellcheck="false" id="changeReason"></textarea>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- /.content -->
<!-- REQUIRED SCRIPTS -->
<script>
$(function(){
$("#datepicker").datepicker({
onSelect : function(dateText){
location.href = "./vac_manage.asp?datepicker="+dateText;
}
});
var vacDialog;
var sel_p_no = "";
var sel_vac_season = "";
function changeVacation(){
if($("#changeNum").val() == "0"){
alert("증감 연차수를 설정해주세요.");
return false;
}
if($.trim($("#changeReason").val()) == ""){
alert("증감 사유를 입력해주세요.");
return false;
}
$.ajax({
url: './vac_manage_change_ok.asp',
data: {
'p_no' : sel_p_no,
'vac_season' : sel_vac_season,
'vac_change_cnt' : $("#changeNum").val(),
'vac_change_reason' : escape($("#changeReason").val())
},
success: function(result){
if(result == "1"){
vacDialog.dialog("close");
location.reload();
}else{
alert("Web Service Error !!");
}
}
});
}
function changeCancel(){
vacDialog.dialog("close");
}
function clearVacationValue(){
$("#changeNum").val("0");
$("#changeReason").val("");
sel_p_no = "";
sel_vac_season = "";
}
vacDialog = $("#vac_change_dialog").dialog({
autoOpen: false,
modal: true,
resizable: false,
height: 240,
width: 400,
title: '관리자 연차 증감',
close: function(){ clearVacationValue(); },
buttons: {
"적용": changeVacation,
"취소": changeCancel
}
});
$("input[id=vac_control]").click(function () {
vacDialog.dialog("option", "position", {
my: 'right top',
at: 'right bottom',
of: $(this)
});
var infoArr = $(this).data("rowinf").split("|");
// infoArr[0] - 사번
// infoArr[1] - 휴가시즌구분
sel_p_no = infoArr[0];
sel_vac_season = infoArr[1];
vacDialog.dialog("open");
});
var monthVacDialog = $("#monthVacDialog").dialog({
autoOpen: false,
modal: true,
resizable: false,
height: 800,
width: 1000,
title: '연차 사용현황',
close: function(){
$("#ifrm_month_vac").attr("src", "about:blank");
$("body").css("overflow", "auto");
},
open: function(){
$("body").css("overflow", "hidden");
}
});
monthVacDialog.dialog("option", "position", {
my: 'center',
at: 'center',
of: window
});
$("#month_vac_btn").on("click", function(){
var cyear = "<%=LEFT(defaultDate, 4)%>";
$("#ifrm_month_vac").attr("src", "./vac_month.asp?cyear="+cyear);
monthVacDialog.dialog("open");
});
$("#changeNum").keydown(function(e){
var key = e.which || e.keyCode;
if(key != 38 && key != 40 && key != 9){
return false;
}
});
$("input[id=vac_change_log]").click(function (){
var obj = $(this);
if(obj.val() == "▼"){
obj.val("▶");
obj.parent().parent().next("tr").remove();
}else{
var infoArr = $(this).data("rowinf").split("|");
// infoArr[0] - 사번
// infoArr[1] - 휴가시즌구분
$.ajax({
url: './vac_manage_change_log.asp',
data: {
'p_no' : infoArr[0],
'vac_season' : infoArr[1]
},
success: function(result){
if(result != ""){
obj.parent().parent().after("<tr><td colspan='10' align='right'>" + result + "</td></tr>");
obj.val("▼");
}else{
alert("Web Service Error !!");
}
}
});
}
});
});
</script>
</div>
<!-- /.content-wrapper -->
<!-- #include virtual = "include/footer.asp" -->