45 lines
2.4 KiB
Plaintext
45 lines
2.4 KiB
Plaintext
<!-- #include virtual = "lib/config.asp" -->
|
|
<%
|
|
device_id = request("device_id")
|
|
|
|
Response.CharSet = "EUC-KR" '한글
|
|
Response.AddHeader "Pragma","no-cache"
|
|
Response.AddHeader "cache-control", "no-staff"
|
|
Response.Expires = -1
|
|
|
|
query = ""
|
|
query = query & " SELECT ROW_NUMBER() OVER(ORDER BY D.ID) AS NO, D.ID, DU.ID as UID, D.T_RENT_DEVICE_MODEL, "
|
|
query = query & " ISNULL(DU.P_CHILD_SN, '') AS P_CHILD_SN, "
|
|
query = query & " ISNULL(VPM.P_SUBJECT, '') AS P_SUBJECT, "
|
|
query = query & " ISNULL(DU.USE_ST_DT, '') AS USE_ST_DT,"
|
|
query = query & " ISNULL(DU.USE_ED_DT, '') AS USE_ED_DT,"
|
|
query = query & " ISNULL(DU.INSERT_USER, '') AS INSERT_USER,"
|
|
query = query & " ISNULL(P.p_name, '') AS INSERT_USER_NAME,"
|
|
query = query & " INSERT_DT, MODIFY_DT "
|
|
query = query & " FROM project2.dbo.T_RENT D"
|
|
query = query & " LEFT JOIN project2.dbo.T_RENT_USE DU ON D.ID = DU.RENT_DEVICE_ID"
|
|
query = query & " LEFT JOIN project2.dbo.V_PROJECT_METHOD VPM ON DU.P_CHILD_SN = VPM.p_child_sn"
|
|
query = query & " LEFT JOIN project2.dbo.V_Person P ON DU.INSERT_USER = P.p_no "
|
|
query = query & " WHERE D.ID = " & device_id & " AND DU.USE_YN = 'N' "
|
|
query = query & " ORDER BY MODIFY_DT DESC "
|
|
|
|
response.write "<table class='table table-sm table-sm2 table-bordered table-head tr-colors'>"
|
|
response.write "<tr>"
|
|
response.write " <td class='tit7' style='text-align:center; width:50%; font-weight:bold;'>프로젝트</td>"
|
|
response.write " <td class='tit7' style='text-align:center; width:20%; font-weight:bold;'>대여기간</td>"
|
|
response.write " <td class='tit7' style='text-align:center; width:10%; font-weight:bold;'>대여신청자</td>"
|
|
response.write " <td class='tit7' style='text-align:center; width:20%; font-weight:bold;'>기록일시</td>"
|
|
response.write "</tr>"
|
|
Rs.Open query, adoConn, 1
|
|
do while not Rs.eof
|
|
response.write "<tr>"
|
|
response.write " <td class='tit7' align='left'>[" & Rs("P_CHILD_SN") & "] " & Rs("P_SUBJECT") & "</td>"
|
|
response.write " <td class='tit7' align='center'>" & Rs("USE_ST_DT") & " ~ " & Rs("USE_ED_DT") & "</td>"
|
|
response.write " <td class='tit7' align='center'>" & Rs("INSERT_USER_NAME") & "</td>"
|
|
response.write " <td class='tit7' align='center'>" & Rs("MODIFY_DT") & "</td>"
|
|
response.write "</tr>"
|
|
Rs.movenext
|
|
loop
|
|
Rs.close
|
|
response.write "</table>"
|
|
%> |