Files
KIN/inspection/interviewer_cati_check.asp
2025-09-29 17:55:08 +09:00

684 lines
52 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" -->
<OBJECT RUNAT=Server PROGID=ADODB.Recordset id=rsp></OBJECT>
<%
Dim qc_ckd : qc_ckd="1" '-- 리스트선택여부 체크 (선택가능(0) / 선택불가(1))
Dim list_ckd : list_ckd="1" '-- 리스트가 있으면(0) / 없으면(1))
dim moneyType
day_time = 8 ' <- day_time 미만 근무 시 빨강색으로 표시
%>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<h1>면접원 확인(CATI)</h1>
</div>
<!-- /.content-header -->
<!-- Main content -->
<div class="content-body">
<div class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<% Dim f_menu : f_menu = "my" %>
<!-- #include file = "f_menu.asp" -->
<form method='post' id='cati_check' name='cati_check'>
<input type="hidden" name="prj_code" id="prj_code" value=<%=request("prj_code") %> >
<input type="hidden" name="intranet_project" id="intranet_project" value=<%=request("intranet_project") %> >
<input type="hidden" name="searchType" id="searchType" value=<%=request("searchType") %> >
<%
' 출퇴근 시간 기록 #테이블에 기록
sql = ""
sql = sql & " CREATE TABLE #work_log_cati ( "&VbCrlf
sql = sql & " m_name varchar(20) not null, "&VbCrlf
sql = sql & " m_jumin varchar(20) not null, "&VbCrlf
sql = sql & " start_time varchar(8) not null, "&VbCrlf
sql = sql & " end_time varchar(8) not null, "&VbCrlf
sql = sql & " time_gap varchar(10) not null "&VbCrlf
sql = sql & " ) "&VbCrlf
sql = sql & " INSERT INTO #work_log_cati "&VbCrlf
sql = sql & " SELECT ST.myun_name, LEFT(ST.myun_jumin, 6) as myun_jumin, ST.start_time, ISNULL(ED.end_time, '') as end_time, "&VbCrlf
sql = sql & " case when ISNULL(ED.end_time, '') <> '' then CONVERT(varchar(5), CONVERT(numeric(4,2), ROUND(datediff(MI, ST.start_time, ED.end_time) / 60.0, 2))) else '' end as time_gap "&VbCrlf
sql = sql & " FROM "&VbCrlf
sql = sql & " ( "&VbCrlf
sql = sql & " SELECT myun_name, myun_jumin, min(login_time) as start_time "&VbCrlf
sql = sql & " FROM new_cati.dbo.login WITH(NOLOCK) "&VbCrlf
sql = sql & " WHERE login_date = '" & request("date") & "' "&VbCrlf
sql = sql & " GROUP BY myun_name, myun_jumin "&VbCrlf
sql = sql & " ) ST LEFT OUTER JOIN "&VbCrlf
sql = sql & " ( "&VbCrlf
sql = sql & " SELECT log_user_name, log_user_jumin, max(log_en_time) as end_time "&VbCrlf
sql = sql & " FROM new_cati.dbo.Logfile WITH(NOLOCK) "&VbCrlf
sql = sql & " WHERE log_date = '" & request("date") & "' "&VbCrlf
sql = sql & " GROUP BY log_user_name, log_user_jumin "&VbCrlf
sql = sql & " ) ED ON ST.myun_name = ED.log_user_name AND ST.myun_jumin = ED.log_user_jumin "&VbCrlf
sql = sql & " WHERE myun_name NOT IN ('김일중', 'Cati_test') "&VbCrlf
'response.Write sql
'response.Write "<br><br>"
adoConn.execute(sql)
'response.Write "job_code : " & Session("job_code") & "<BR>"
'기존에 저장되어 있는 데이터 가져오기.
'업무 정보 가져오기.
sql = " SELECT T.prj_code, T.s_client_no, T.s_client_name, T.s_client_jumin, s_date, T.no_cnt, "&VbCrlf
sql = sql & " T.tok_cnt , T.error_cnt, tmp.confirm_yn, tmp.lunch, tmp.dinner "&VbCrlf
sql = sql & " , add_count, cast(add_count_memo as varchar) as add_count_memo, add_money, add_money_memo, isnull(qc_ok,'0') as qc_ok, tmp.id, tmp.s_pay_unit, isnull(tmp.money_type,'부수') as money_type , "&VbCrlf
sql = sql & " CASE "&VbCrlf
sql = sql & " WHEN d.d_order_cnt = '99' THEN '결재 반려' "&VbCrlf
sql = sql & " WHEN d.d_order_cnt = '77' THEN '결재 완료' "&VbCrlf
sql = sql & " WHEN d.d_order_cnt IS NULL THEN '' "&VbCrlf
sql = sql & " ELSE '결재중' "&VbCrlf
sql = sql & " END AS d_order_cnt, "&VbCrlf
sql = sql & " wlc.start_time, wlc.end_time, isnull(wlc.time_gap, 0) as time_gap, isnull(nwc.nw_cnt, 0) as nw_cnt "&VbCrlf
sql = sql & " FROM "&VbCrlf
sql = sql & " ( "&VbCrlf
sql = sql & " SELECT prj_code, prj_name, s_client_jumin, s_client_no, s_client_name, s_date, "&VbCrlf
sql = sql & " SUM(no_cnt) as no_cnt, SUM(tok_cnt) as tok_cnt, SUM(error_cnt) as error_cnt, intranet_pay, qc_ok "&VbCrlf
sql = sql & " FROM ( "&VbCrlf
sql = sql & " SELECT s.prj_code, P.prj_name, s_client_jumin, s_client as s_client_no, s_client_name, s_date, "&VbCrlf
sql = sql & " case when c.tel_result IS null then 1 else 0 end as no_cnt, "&VbCrlf
sql = sql & " case when c.tel_result != 2 then 1 else 0 end as tok_cnt, "&VbCrlf
sql = sql & " case when c.tel_result = 2 then 1 else 0 end as error_cnt, c.intranet_pay, C.qc_ok FROM "&VbCrlf
sql = sql & " new_cati.dbo.Sheet1 s "&VbCrlf
sql = sql & " Left Outer Join "&VbCrlf
sql = sql & " ( "&VbCrlf
sql = sql & " select CONVERT(varchar(10), tel_date, 120) as s_tel_date, "&VbCrlf
sql = sql & " prj_code,tel_cnt,tel_client_no, tel_result, tel_del_yn, intranet_pay, qc_ok "&VbCrlf
sql = sql & " from [new_cati].[dbo].[T_INSPECTION_CATI] with(nolock) "&VbCrlf
sql = sql & " where prj_code='" & request("prj_code") & "' "&VbCrlf
sql = sql & " AND tel_result is not null "&VbCrlf
sql = sql & " AND tel_del_yn = 'N' "&VbCrlf
sql = sql & " group by prj_code,tel_cnt,tel_client_no, tel_result, tel_del_yn, intranet_pay, CONVERT(varchar(10), tel_date, 120), qc_ok "&VbCrlf
sql = sql & " ) c "&VbCrlf
sql = sql & " ON s.prj_code = c.prj_code "&VbCrlf
sql = sql & " AND s.s_tcnt = c.tel_cnt "&VbCrlf
sql = sql & " AND s.s_client = c.tel_client_no "&VbCrlf
sql = sql & " AND c.tel_result is not null "&VbCrlf
sql = sql & " AND c.tel_del_yn = 'N' "&VbCrlf
sql = sql & " LEFT OUTER JOIN new_cati.dbo.project P ON S.prj_code = P.prj_code "&VbCrlf
sql = sql & " WHERE s.prj_code = '" & request("prj_code") & "' "&VbCrlf
sql = sql & " AND s.s_client_name not in ('Cati_Test', '김일중') "&VbCrlf
sql = sql & " AND s_tel_date = '" & request("date") & "' "&VbCrlf
sql = sql & " ) T "&VbCrlf
sql = sql & " GROUP BY prj_code, prj_name, s_client_jumin, s_client_no, s_client_name, s_date, intranet_pay, qc_ok "&VbCrlf
sql = sql & " ) T left outer join T_MYUN_PAY TMP "&VbCrlf
sql = sql & " ON T.prj_code = TMP.prj_code "&VbCrlf
sql = sql & " and T.s_client_name = TMP.m_name "&VbCrlf
sql = sql & " and T.s_client_jumin = TMP.m_jumin "&VbCrlf
sql = sql & " and T.s_date = tmp.work_dt "&VbCrlf
sql = sql & " left outer join Document d on tmp.attribute05 = d.d_no AND d_delok = 'N' "&VbCrlf
sql = sql & " left outer join 문서내용 m on tmp.attribute05 = m.문서번호 AND m.del_yes_no = 'no' "&VbCrlf
sql = sql & " left outer join #work_log_cati wlc on T.s_client_name = wlc.m_name AND LEFT(T.s_client_jumin, 6) = wlc.m_jumin "&VbCrlf
sql = sql & " left outer join ( "&VbCrlf
sql = sql & " SELECT neakeun_name, LEFT(neakeun_jumin, 6) as neakeun_jumin, date, COUNT(*) as nw_cnt "&VbCrlf
sql = sql & " FROM neakeun_work "&VbCrlf
sql = sql & " GROUP BY neakeun_name, LEFT(neakeun_jumin, 6), date "&VbCrlf
sql = sql & " ) nwc on T.s_client_name = nwc.neakeun_name AND LEFT(T.s_client_jumin, 6) = nwc.neakeun_jumin AND T.s_date = nwc.date "&VbCrlf
sql = sql & " ORDER BY qc_ok desc, s_pay_unit desc, cast(s_client_no as int) "&VbCrlf
AdoRs.open sql, adoconn, adopenstatic, adlockreadonly
%>
<table width="1200px" class="table table-sm table-sm2 table-bordered table-head tr-colors">
<tr>
<td align="center">프로젝트명</td>
<td align="left" colspan="4">
<input type="text" class="gray" style="width:calc(100% - 30px);" name="prj_name" id="prj_name" value='<%=request("prj_name") %>' onclick="winnewoepn('txt_prj_name','txt_p_sn');" readonly>
<img src="/images/common/btn_smallsrch2.gif" align="absmiddle" onclick="winnewoepn('txt_prj_name','txt_p_sn');" style="CURSOR:pointer;width:24px;">
</td>
<td align="center">날짜선택</td>
<td align="left">
<%
query = " select distinct s_date "
query = query & " FROM new_cati.dbo.sheet1 "
query = query & " where prj_code = '"& request("prj_code") &"' "
query = query & " order by s_date "
'response.Write query
rsp.Open query, adoConn, 1
%>
<select name = "date" id="date" style="width:100px;">
<option value="">선 택</option>
<%
for i=1 to rsp.recordCount
%>
<option value='<%=rsp("s_date") %>' <% if request("date") = rsp("s_date") then %> selected <% end if %>><%=rsp("s_date") %></option>
<% rsp.movenext
next
rsp.close
%>
</select>
</td>
<td><img src="/images/common/btn_smallsrch.gif" align="absmiddle" onclick="search('search')" style='cursor:pointer'></td>
</tr>
<%
dim tmp_est_money, tmp_s_sum
tmp_est_money = 0
tmp_s_sum = 0
query = " select dc1.p_child_sn, sebu, est_danga, dc2.est_money, isnull(tmp.s_sum, 0) as s_sum "&VbCrlf
query = query & " FROM direct_cost dc1 left outer join ( "&VbCrlf
query = query & " select p_child_sn, sum(cast(est_money as int)) as est_money "&VbCrlf
query = query & " FROM direct_cost "&VbCrlf
query = query & " where p_child_sn = '"& request("intranet_project") &"' "&VbCrlf
query = query & " and del_yes_no = 'no' "&VbCrlf
query = query & " and sebu like '면접원수당%' "&VbCrlf
query = query & " and hangmok = '48' "&VbCrlf
query = query & " group by p_child_sn "&VbCrlf
query = query & " ) dc2 on dc1.p_child_sn = dc2.p_child_sn "&VbCrlf
query = query & " left outer join ( "&VbCrlf
query = query & " select p_sn, sum(s_sum) as s_sum "&VbCrlf
query = query & " from T_MYUN_PAY "&VbCrlf
query = query & " where p_sn = '"& request("intranet_project") &"' "&VbCrlf
query = query & " AND confirm_yn = 'Y' "&VbCrlf
query = query & " group by p_sn "&VbCrlf
query = query & " ) tmp on dc1.p_child_sn = tmp.p_sn "&VbCrlf
query = query & " where dc1.p_child_sn = '"& request("intranet_project") &"' "&VbCrlf
query = query & " and del_yes_no = 'no' "&VbCrlf
query = query & " and sebu like '면접원수당%' "&VbCrlf
query = query & " and hangmok = '48' "&VbCrlf
'response.Write query
rsp.Open query, adoConn, 1
if rsp.recordCount > 0 then
tmp_est_money = cdbl(rsp("est_money"))
tmp_s_sum = cdbl(rsp("s_sum"))
end if
if adors.recordcount > 0 then %>
<tr>
<td align="center" >인트라넷<br /> 프로젝트 번호</td>
<td align="center" ><%=request("intranet_project") %></td>
<td align="center" colspan="2">면접원<br />예상직접비 총 수당</td>
<td align="right" ><%=FormatNumber(tmp_est_money,0) %> 원</td>
<td align="center" colspan="2">누적<br />Confirm 금액</td>
<td align="right" ><%=FormatNumber(tmp_s_sum,0) %> 원</td>
</tr>
<% End if %>
<%
if adors.recordcount > 0 then
moneyType = "부수"
if request("searchType") = "moneyTypeChange" then
moneyType = request("money_type")
elseif adors("money_type") = "일당" then
moneyType = "일당"
elseif adors("money_type") = "일당" then
moneyType = "부수"
end if
end if
%>
<% if adors.recordcount > 0 then %>
<tr>
<td align="center" >일당 또는 부수 선택</td>
<td >
<input type="radio" name="money_type" onclick="money_type_change()" value="부수" <% if moneyType = "부수" then %> checked="checked" <% end if %>/>부수
<input type="radio" name="money_type" onclick="money_type_change()" value="일당" <% if moneyType = "일당" then %> checked="checked" <% end if %>/>일당
</td>
<td align="center" >부수단가</td>
<td ><input type="text" name="paperMoney" id="paperMoney" <% if adors("money_type") = "일당" then %> readonly <% end if %> value="<%=adors("s_pay_unit") %>" /></td>
<td align="center" >일당금액</td>
<td ><input type="text" name="dayMoney" id="dayMoney" <% if adors("money_type") = "부수" then %> readonly <% end if %> value="<%=adors("s_pay_unit") %>" /></td>
<td align="center" >예상직접비</td>
<td >
<select name = "myun" id="myun" style="width:150;">
<option value="">선 택</option>
<% for i=1 to rsp.recordCount %>
<option value='<%=rsp("sebu") %>' <% if request("myun") = rsp("sebu") then %> selected <% end if %>>[<%=rsp("sebu") %>] - <%=rsp("est_danga") %></option>
<% rsp.movenext
next
rsp.close
%>
</select>
</td>
</tr>
<tr>
<td colspan="8" >하단 리스트 중 배경색상이 [<span style="background-color:#F6CEF5;">  </span>] 인 리스트는 내근직 업무일지가 있는 면접원 입니다.</td>
</tr>
<% end if %>
<% if request("date") <> "" then %>
<tr>
<td colspan="8">
<table border="1" class="resultTable">
<tr height='30'>
<td align="center" style="width:3%">순번</td>
<td align="center" style="width:5%">이름</td>
<td align="center" style="width:10%">시작 / 종료<br />* <%=day_time %>시간 미만 업무 시<br /><font color="red">빨강색</font>으로 표시</td>
<td align="center" style="width:4%">검증완료<br />부수</td>
<td align="center" style="width:5%">추가수당1<br /><input type="checkbox" id="lunchAll" name="lunchAll" onclick="javascript: alert('자동으로 산정 됩니다. \n필요시 각각 체크/해제가 가능 합니다.'); return false; "/></td>
<td align="center" style="width:5%">추가수당2<br /><input type="checkbox" id="dinnerAll" name="dinnerAll" onclick="javascript: alert('자동으로 산정 됩니다. \n필요시 각각 체크/해제가 가능 합니다.'); return false; " /></td>
<td align="center" style="width:11%">추가/삭제부수</td>
<td align="center" style="width:15%">사유</td>
<td align="center" style="width:11%">추가/삭제수당</td>
<td align="center" style="width:15%">사유</td>
<td align="center" style="width:10%">결재상태</td>
<td align="center" style="width:6%">Confirm<br />
<input type="checkbox" id="checkAll" name="checkAll" />
</td>
</tr>
<input type="hidden" name="cnt" value="<%=adors.recordcount %>"/>
<%
Dim pay_unit_blank_cnt
Dim total_tok_count
pay_unit_blank_cnt = 0
total_tok_count = 0
for i=1 to adors.recordcount
list_ckd="0"
query = " select top 1 tmp1.money_type, tmp1.prj_code, tmp1.s_pay_unit, tmp1.s_sum, tmp2.prj_code as lunch_prj_code, tmp2.prj_name as lunch_prj_name, tmp2.lunch, "&VbCrlf
query = query & " tmp3.prj_code as dinner_prj_code, tmp3.prj_name as dinner_prj_name, tmp3.dinner, tmp4.s_sum as allSum "&VbCrlf
query = query & " from T_MYUN_PAY tmp1 left outer join ( "&VbCrlf
query = query & " select top 1 tmp.prj_code, p.prj_name, lunch, work_dt "&VbCrlf
query = query & " from T_MYUN_PAY tmp left outer join new_cati.dbo.project p on tmp.prj_code = p.prj_code "&VbCrlf
query = query & " where work_dt = '" & request("date") & "' "&VbCrlf
query = query & " and m_name = '"& adors("s_client_name") & "' "&VbCrlf
query = query & " and m_jumin = '" & adors("s_client_jumin") &"' "&VbCrlf
query = query & " order by lunch desc "&VbCrlf
query = query & " ) tmp2 on tmp1.work_dt = tmp2.work_dt "&VbCrlf
query = query & " left outer join ( "&VbCrlf
query = query & " select top 1 tmp.prj_code, p.prj_name, dinner, work_dt "&VbCrlf
query = query & " from T_MYUN_PAY tmp left outer join new_cati.dbo.project p on tmp.prj_code = p.prj_code "&VbCrlf
query = query & " where work_dt = '" & request("date") & "' "&VbCrlf
query = query & " and m_name = '"& adors("s_client_name") & "' "&VbCrlf
query = query & " and m_jumin = '" & adors("s_client_jumin") &"' "&VbCrlf
query = query & " order by dinner desc "&VbCrlf
query = query & " ) tmp3 on tmp1.work_dt = tmp3.work_dt "&VbCrlf
query = query & " left outer join ( "&VbCrlf
query = query & " select SUM(s_sum) as s_sum, work_dt "&VbCrlf
query = query & " from T_MYUN_PAY tmp left outer join new_cati.dbo.project p on tmp.prj_code = p.prj_code "&VbCrlf
query = query & " where work_dt = '" & request("date") & "' "&VbCrlf
query = query & " and m_name = '"& adors("s_client_name") & "' "&VbCrlf
query = query & " and m_jumin = '" & adors("s_client_jumin") &"' and confirm_yn = 'y' "&VbCrlf
query = query & " group by work_dt "&VbCrlf
query = query & " ) tmp4 on tmp1.work_dt = tmp4.work_dt "&VbCrlf
query = query & " where tmp1.work_dt = '" & request("date") & "' "&VbCrlf
query = query & " and tmp1.confirm_yn = 'y' "&VbCrlf
query = query & " and tmp1.m_name = '"& adors("s_client_name") & "' "&VbCrlf
query = query & " and tmp1.m_jumin = '" & adors("s_client_jumin") &"' "&VbCrlf
query = query & " and tmp1.prj_code <> '"& adors("prj_code") &"' "&VbCrlf
query = query & " order by money_type desc, s_pay_unit desc "&VbCrlf
'response.Write query & "<br>"
rsp.Open query, adoConn, 1
%>
<tr height=30>
<td align="center" ><%=i %>
<td align="center" ><%=adors("s_client_name") %>
<input type="hidden" name="m_name" value="<%=adors("s_client_name") %>" >
<input type="hidden" name="m_jumin" value="<%=adors("s_client_jumin") %>" >
<input type="hidden" name="s_client_no" value="<%=adors("s_client_no") %>" >
<input type="hidden" name="id" value="<%=adors("id") %>" >
<input type="hidden" name="qc_ok" value="<%=adors("qc_ok") %>" >
</td>
<td align="center" >
<%If adors("time_gap")="" Then '-- 출퇴근 시간정보 없음%>
<font <% if adors("time_gap") < day_time then %>color="red" <%else %>color="black" <% end if %>><%= LEFT(adors("start_time"), 5)%> / <%= LEFT(adors("end_time"), 5)%> (<%=adors("time_gap") %>)<br>(출퇴근정보 불일치)</font>
<%Else %>
<font <% if cdbl(adors("time_gap")) < cdbl(day_time) then %>color="red" <%else %>color="black" <% end if %>><%= LEFT(adors("start_time"), 5)%> / <%= LEFT(adors("end_time"), 5)%> (<%=adors("time_gap") %>)</font>
<%End if%>
</td>
<td align="center" ><%=adors("tok_cnt") %><input type="hidden" name= "tok_cnt" value="<%=adors("tok_cnt") %>" ></td>
<%
dim tmpPayYn
tmpPayYn = false
if rsp.recordcount > 0 then
if rsp("prj_code") <> request("prj_code") then
if rsp("money_type") = "부수" and moneyType = "일당" then
tmpPayYn = true
elseif rsp("money_type") = "일당" then
tmpPayYn = true
end if
end if
end if
if tmpPayYn then %>
<td colspan="4" ><b style="color:red">
[<%=rsp("prj_code") %>]</b>에 <b style="color:red"><%=formatNumber(rsp("s_sum"),0) %></b>원의
<b style="color:red">
<% if rsp("money_type") = "일당" then %>
일당이
<% else %>
부수단가가
<% end if %>
</b>
입력되어 있습니다.(총금액 : <B><%=formatNumber(rsp("allSum"),0)%>원</B>)
<input type="hidden" name= "alreadyMoney" value="Y" />
<input type="hidden" name= "add_count" value="" />
<input type="hidden" name= "addCntReason" value="" />
</td>
<% else %>
<%
total_tok_count = total_tok_count + cint(adors("tok_cnt"))
%>
<input type="hidden" name= "alreadyMoney" value="N" />
<!-- 점심 추가수당1-->
<td align="center"
<%
if rsp.recordcount > 0 then
if rsp("lunch") = "Y" and adors("prj_code") <> rsp("lunch_prj_code") then %>
onclick="alert_eat('<%=rsp("lunch_prj_code") %>','<%=rsp("lunch_prj_name") %>','lunch')"
<% end if
end if
%>>
<input type="hidden" id="lunch_<%=i%>" name="lunch_<%=i%>" value="Y" />
<input type="checkbox" id="chk_lunch_<%=i%>" name= "chk_lunch" value="Y"
<% if moneyType = "일당" then %>
disabled="disabled" style="display:none"
<% elseIf adors("d_order_cnt") = "결재 완료" OR adors("d_order_cnt") = "결재중" then %>
disabled="disabled"
<% elseIf rsp.recordcount >0 then %>
<% if rsp("lunch") = "Y" and rsp("lunch_prj_code") <> request("prj_code") then %>
disabled="disabled" style="display:none"
<% elseif rsp("lunch") = "Y" and adors("prj_code") <> rsp("lunch_prj_code") then %>
disabled="disabled" style="display:none"
<% Else %>
<% if (adors("lunch") = "Y") or (Cint(adors("time_gap")) >= 7) then %>
checked
<% end if '당일 업무 시간에 따른 추가 수당 지급 %>
<% end if %>
<% else %>
<% if (adors("lunch") = "Y") or (Cint(adors("time_gap")) >= 7) then %> checked <% end if '당일 업무 시간에 따른 추가 수당 지급 %>
<% end if %>
/>
</td>
<!-- 점심 추가수당1 끝 -->
<!-- 저녁 추가수당2 -->
<td align="center"
<% if rsp.recordcount > 0 then
if rsp("dinner") = "Y" and adors("prj_code") <> rsp("dinner_prj_code") then %>
onclick="alert_eat('<%=rsp("dinner_prj_code") %>','<%=rsp("dinner_prj_name") %>','dinner')"
<% end if
end if %>>
<input type="hidden" id="dinner_<%=i%>" name="dinner_<%=i%>" value="Y" />
<input type="checkbox" id="chk_dinner_<%=i%>" name= "chk_dinner" value="Y"
<% if moneyType = "일당" then %>
disabled="disabled" style="display:none"
<% Elseif adors("d_order_cnt") = "결재 완료" OR adors("d_order_cnt") = "결재중" then %>
disabled="disabled"
<% Elseif rsp.recordcount >0 then %>
<% If rsp("dinner") = "Y" and rsp("dinner_prj_code") <> request("prj_code") then %>
disabled="disabled" style="display:none"
<% Elseif rsp("dinner") = "Y" and adors("prj_code") <> rsp("dinner_prj_code") then %>
disabled="disabled" style="display:none"
<% Else %>
<% if (adors("dinner") = "Y") or (Cint(adors("time_gap")) >=10 ) then %>
checked
<% end if '당일 업무 시간에 따른 추가 수당 지급 %>
<% End if %>
<% Else %>
<% if (adors("dinner") = "Y") or (Cint(adors("time_gap")) >=10 ) then %> checked <% end if '당일 업무 시간에 따른 추가 수당 지급 %>
<% end if %> />
</td>
<!--저녁 추가수당2 끝-->
<td align="center" ><input type="text" name= "add_count" style="width:95%;" value="<%=adors("add_count") %>"
<% if adors("d_order_cnt") = "결재 완료" OR adors("d_order_cnt") = "결재중" then %>
readonly
<% end if %>
/></td>
<td align="center" ><input type="text" name= "addCntReason" style="width:95%;" value="<%=adors("add_count_memo") %>"
<% if adors("d_order_cnt") = "결재 완료" OR adors("d_order_cnt") = "결재중" then %>
readonly
<% end if %>
/></td>
<% end if %>
<td align="center" ><input type="text" name= "addMoney" style="width:95%;" value = "<%=adors("add_money") %>"
<% if adors("d_order_cnt") = "결재 완료" OR adors("d_order_cnt") = "결재중" then %>
readonly
<% end if %>
/></td>
<td align="center" ><input type="text" name= "addMoneyReason" style="width:95%;" value="<%=adors("add_money_memo") %>"
<% if adors("d_order_cnt") = "결재 완료" OR adors("d_order_cnt") = "결재중" then %>
readonly
<% end if %>
/></td>
<td align="center" ><input type="text" name= "approvalYN" style="width:95%;" value="<%=adors("d_order_cnt") %>" readonly/></td>
<td align="center" >
<input type="hidden" id="cati_confirm_<%=i%>" name="cati_confirm_<%=i%>" value="Y"/>
<% if adors("qc_ok") = "1" then %>
<input type="checkbox" id="chk_cati_confirm_<%=i%>" name= "chk_cati_confirm" value="Y" <% if adors("confirm_yn") = "Y" then %>checked <% end if %>
<% if adors("d_order_cnt") = "결재 완료" OR adors("d_order_cnt") = "결재중" then %>
disabled
<% end if %> />
<%
'-----------------------------QC 검증 완료 여부 및 리스트선택가능여부 체크(20170813)-------------------------------------------
if Not (adors("d_order_cnt") = "결재 완료" OR adors("d_order_cnt") = "결재중") then
qc_ckd="0"
End If
'-------------------------------------------------------------------------------------------------------------------------
%>
<% else %>
검증미완료
<% end if %>
</td>
</tr>
<%
rsp.close
adors.movenext
next
AdoRs.close
%>
<tr>
<td colspan="12" align="left">모든 면접원의 TOK부수의 합은 <font color="red"><b><%=total_tok_count %></b></font> 입니다.</td>
</tr>
</table>
***결재 진행중 또는 결재 완료된 문서는 컨펌 수정이 불가능합니다. 참고해 주세요.
<center>
<%if list_ckd="0" then '-- 리스트가 있는경우만.. %>
<%
'####################################################################################
'-- CATI 완료데이터 중복 체크(20170824) ↓↓----------------------------------------------
query = " select top 1 prj_code, s_tcnt "
query = query & " from [new_cati].[dbo].[sheet1] with(nolock) "
query = query & " where prj_code='"&request("prj_code")&"' "
query = query & " group by prj_code, s_tcnt "
query = query & " having count(s_tcnt)>1 " '-- 카운팅이 1보다 큰거(중복)
'response.Write query
rsp.Open query, adoConn, 1
if not rsp.eof then '-- 중복건 있음
rsp.close
response.write "<font color=blue><b>※ 중복된 완료건이 있습니다. IT팀에 문의하여 주시기 바랍니다</b></font>"
response.write "</form>"
response.end
end if
rsp.close
'-- CATI 완료데이터 중복 체크(20170824) ↑↑----------------------------------------------
'####################################################################################
'-- 검증완료 데이터중 중복데이터 체크(20170813)--------------------
query = " select top 1 "
query = query & " prj_code, tel_cnt, count(tel_cnt) as 중복카운트 "
query = query & " from [new_cati].[dbo].[T_INSPECTION_CATI] with(nolock) "
query = query & " where prj_code='" & request("prj_code") & "' "
query = query & " and qc_ok='1' " '-- 검증완료(1)
query = query & " and tel_result<>'2' " '-- 불량을 제외한 나머지 (완료)
query = query & " and tel_del_yn='N' " '-- 사용(N)
query = query & " group by prj_code, tel_cnt "
query = query & " having count(tel_cnt)>1 "
'response.Write query
rsp.Open query, adoConn, 1
if rsp.eof then '-- 정상
%>
<%If qc_ckd="0" Then %>
<img src="/images/common/btn_save.jpg" align="absmiddle" onclick="save()" style="cursor:pointer;" id="img_save">
<%Else %>
<br><br><br><font color=blue><b>※ 검증이 [미완료]이거나, [결제중] 또는 [결제완료] 된 리스트 입니다</b></font><br><br><br>
<%End If %>
<%
else ' 검증완료데이터에 중복있음
%> <br><br><br><font color=red><b>※ 검증완료된 데이터에 중복된 검증완료 내용이 있습니다. IT팀에 문의하여 주시기 바랍니다 </b></font><br><br><br><%
end if
rsp.close
%>
<%end if%>
</center>
</td>
</tr>
</table>
</td>
</tr>
<% end if%>
</table>
</form>
</div>
</div>
</div>
</div>
</div>
<!-- /.content -->
<!-- REQUIRED SCRIPTS -->
<script>
$(function () {
$("#checkAll").click(function () {
var checked_status = this.checked;
$("input[name=chk_cati_confirm]").not(":disabled").prop("checked", checked_status);
});
$("#lunchAll").click(function () {
var checked_status = this.checked;
$("input[name=chk_lunch]").not(":disabled").prop("checked", checked_status);
});
$("#dinnerAll").click(function () {
var checked_status = this.checked;
$("input[name=chk_dinner]").not(":disabled").prop("checked", checked_status);
});
if ($(':radio[name="money_type"]:checked').val() == "부수") {
$("#dayMoney").val("");
$("#paperMoney").focus();
} else {
$("#paperMoney").val("")
$("input[name=add_count]").val("")
$("input[name=addCntReason]").val("")
$("input[name=dayMoney]").attr("readonly", false);
$("input[name=paperMoney]").attr("readonly", true);
$("input[name=add_count]").attr("readonly", true);
$("input[name=addCntReason]").attr("readonly", true);
$("input:checkbox[name='chk_lunch']").attr("checked", false);
$("input:checkbox[name='chk_dinner']").attr("checked", false);
$("#dayMoney").focus();
}
});
function winnewoepn(actval, actval2) {
var url = "/project_list/project_cati_list_2014.asp";
window.open(url, "wins", "left=50, top=50, menubar=no, location=no, status=no, toolbar=no, width=850, height=600, scrollbars=yes ,resizable=no");
}
function dateChange(prj_code) {
document.cati_check.prj_code.value = prj_code;
ajaxCallJson("interviewer_cati_check_ajax_date.asp", { prj_code: prj_code }, null, "post", "datereturnFunc()");
}
function datereturnFunc() {
$("#date option").remove();
$("#date").append(ajaxResponse);
}
function myunChange(intranet_project) {
document.cati_check.intranet_project.value = intranet_project;
ajaxCallJson("interviewer_cati_check_ajax_myun.asp", { intranet_project: intranet_project }, null, "post", "myunreturnFunc()");
}
function myunreturnFunc() {
$("#myun option").remove();
$("#myun").append(ajaxResponse);
}
function save() {
$("#img_save").css("display", "none");
if (!confirm("저장하시겠습니까?")) {
$("#img_save").css("display", "inline");
return false;
}
var cnt = document.cati_check.cnt.value;
if ($(":input:radio[name='money_type']:checked").val() == "부수" && document.cati_check.paperMoney.value == "") {
alert("부수단가를 반드시 입력하셔야 합니다.");
$("#img_save").css("display", "inline");
return;
} else if ($(":input:radio[name='money_type']:checked").val() == "일당" && document.cati_check.dayMoney.value == "") {
alert("일당금액을 반드시 입력하셔야 합니다.");
$("#img_save").css("display", "inline");
return;
} else if (document.cati_check.myun.value == "") {
alert("면접원 수당을 반드시 선택하셔야 합니다.");
$("#img_save").css("display", "inline");
return;
}
if (cnt > 1) {
for (i = 0; i < cnt; i++) {
if ($("input:checkbox[id='chk_cati_confirm_" + (i + 1) + "']").is(":checked") == false) {
$("#cati_confirm_" + (i + 1)).val("N");
}
if ($("input:checkbox[id='chk_lunch_" + (i + 1) + "']").is(":checked") == false) {
$("#lunch_" + (i + 1)).val("N");
}
if ($("input:checkbox[id='chk_dinner_" + (i + 1) + "']").is(":checked") == false) {
$("#dinner_" + (i + 1)).val("N");
}
if (document.cati_check.add_count[i].value != "" && document.cati_check.add_count[i].value != "0" && document.cati_check.addCntReason[i].value == "") {
alert(i + 1 + "번째 줄을 확인하세요.\n추가/삭제부수 입력시 사유를 반드시 입력해야 합니다.");
$("#img_save").css("display", "inline");
return false;
}
if (document.cati_check.addMoney[i].value != "" && document.cati_check.addMoney[i].value != "0" && document.cati_check.addMoneyReason[i].value == "") {
alert(i + 1 + "번째 줄을 확인하세요.\n추가/삭제수당 입력시 사유를 반드시 입력해야 합니다.");
$("#img_save").css("display", "inline");
return false;
}
}
} else {
if ($("input:checkbox[id='chk_cati_confirm_1']").is(":checked") == false) {
$("#cati_confirm_1").val("N");
}
if ($("input:checkbox[id='chk_lunch_1']").is(":checked") == false) {
$("#lunch_1").val("N");
}
if ($("input:checkbox[id='chk_dinner_1']").is(":checked") == false) {
$("#dinner_1").val("N");
}
if (document.cati_check.add_count.value != "" && document.cati_check.add_count.value != "0" && document.cati_check.addCntReason.value == "") {
alert("추가/삭제부수 입력시 사유를 반드시 입력해야 합니다.");
$("#img_save").css("display", "inline");
return false;
}
if (document.cati_check.addMoney.value != "" && document.cati_check.addMoney.value != "0" && document.cati_check.addMoneyReason.value == "") {
alert("추가/삭제수당 입력시 사유를 반드시 입력해야 합니다.");
$("#img_save").css("display", "inline");
return false;
}
}
document.cati_check.action = "cati_confirm_save.asp";
document.cati_check.submit();
}
function search(type) {
var prj_code = document.cati_check.prj_code.value;
var date = document.cati_check.date.value;
document.cati_check.searchType.value = type;
if (prj_code == "") {
alert("프로젝트를 선택하세요");
return;
}else if (date == "") {
alert("날짜를 선택하세요");
return;
}
document.cati_check.action = "interviewer_cati_check.asp";
document.cati_check.submit();
}
function alert_eat(prj_code, prj_name, lunch_dinner) {
if (lunch_dinner == "lunch") {
alert("[" + prj_code + "] " + prj_name + "에 추가수당1이 들어가 있습니다.");
} else if (lunch_dinner == "dinner") {
alert("[" + prj_code + "] " + prj_name + "에 추가수당2가 들어가 있습니다.");
}
}
function money_type_change() {
search('moneyTypeChange');
}
</script>
</div>
<!-- /.content-wrapper -->
<!-- #include virtual = "include/footer.asp" -->