Files
KON-KIWI/QuotaSet_ajax.asp
2026-08-07 12:52:33 +09:00

161 lines
6.4 KiB
Plaintext

<!-- #include File="./Lib/Config.asp"-->
<%
Dim SQL,Rcset
Dim icnt
Dim QSJSON, QSORDER, QUOTAJSON
DIM qids, qid
Dim flag
Set Rcset = Server.CreateObject("ADODB.RecordSet")
Rcset.CursorLocation = adUseClient
Dim COMMAND : COMMAND = request("COMMAND")
Dim pkey : pkey = request("pkey")
Call DBConnect2()
SELECT CASE COMMAND
CASE "GET_QUESTION"
Response.ContentType = "application/json"
SQL = ""
SQL = SQL & " SELECT "
SQL = SQL & " QID, "
SQL = SQL & " json_value(QUESTIONJSON,'$.variable') as variable, "
SQL = SQL & " json_value(QUESTIONJSON,'$.title') as title, "
SQL = SQL & " json_value(QUESTIONJSON,'$.explain') as explain "
SQL = SQL & " from QUESTION as Qu "
SQL = SQL & " WHERE PKEY = '" & pkey & "' "
SQL = SQL & " AND json_value(QUESTIONJSON,'$.qtype') in ('single') "
SQL = SQL & " ORDER BY Qorder "
Rcset.Open SQL,DBConn,3,1,1
Response.Write RecordToJSON(Rcset)
Response.End
CASE "GET_QUOTASET"
Response.ContentType = "application/json"
SQL = ""
SQL = SQL & " select QSORDER, JSON_QUERY(QSJSON, '$.COL') as COL,JSON_QUERY(QSJSON, '$.ROW') as ROW "
SQL = SQL & " from konkiwi.dbo.QUOTASET where pkey = '" & pkey & "' "
SQL = SQL & " order by QSORDER "
Rcset.Open SQL,DBConn,3,1,1
Response.Write RecordToJSON(Rcset)
Response.End
CASE "INSERT_QUOTASET"
QSORDER = request("QSORDER")
QSJSON = request("QSJSON")
SQL = ""
SQL = SQL & " DELETE FROM QUOTASET WHERE PKEY = '"+pkey+"' AND QSORDER = '"&QSORDER&"'"
SQL = SQL & " DELETE FROM QUOTA WHERE PKEY = '"+pkey+"' AND QSORDER = '"&QSORDER&"'"
SQL = SQL & " INSERT INTO konkiwi.dbo.QUOTASET(PKEY, QSORDER, QSJSON, EXPLAINS) "
SQL = SQL & " VALUES('"+pkey+"','"&QSORDER&"','"&QSJSON&"', '') "
DBConn.Execute SQL
response.write "Quota "&QSORDER&" 로 등록되었습니다."
CASE "INSERT_QUOTACELL"
QSORDER = request("QSORDER")
QUOTAJSON = request("QUOTAJSON")
SQL = ""
SQL = SQL & " INSERT INTO konkiwi.dbo.QUOTA(PKEY, QSORDER, cnt, ori_cnt, QUOTAJSON) "
SQL = SQL & " VALUES('"+pkey+"','"&QSORDER&"', 0, 0,'"&QUOTAJSON&"') "
'response.write SQL
DBConn.Execute SQL
CASE "PREVIEW_JSON"
Response.ContentType = "application/json"
qids = request("QIDS")
qid = split(qids, ",")
flag = request("flag")
SQL = ""
SQL = SQL & " DECLARE @JSON nvarchar(max) "
SQL = SQL & " SET @JSON = ( "
SQL = SQL & " SELECT QID, flag, json, variable "
SQL = SQL & " FROM ( "
for icnt = 0 to UBound(qid)
If icnt > 0 Then
SQL = SQL & " UNION ALL"
END IF
SQL = SQL & " SELECT QID, '" & flag & "' as flag, JSON_QUERY(QUESTIONJSON, '$.dataset.single') AS json, JSON_VALUE(QuestionJson, '$.variable') as variable FROM konkiwi.dbo.QUESTION "
SQL = SQL & " WHERE PKEY = '" & pkey & "' AND JSON_VALUE(QuestionJson, '$.qtype') = 'single' AND QID = '" & qid(icnt) & "' "
next
SQL = SQL & " ) R "
SQL = SQL & " FOR JSON AUTO "
SQL = SQL & " ) "
SQL = SQL & " SELECT @JSON as json "
Rcset.Open SQL, DBConn,3,1,1
Response.write Rcset(0)
Response.End
CASE "SEL_QUOTATABLE"
Response.ContentType = "application/json"
QSORDER = request("QSORDER")
SQL = ""
SQL = SQL & " SET NOCOUNT ON; "
SQL = SQL & " DECLARE @data nvarchar(MAX) = ( "
SQL = SQL & " SELECT top 1 QSJSON FROM konkiwi.dbo.QUOTASET "
SQL = SQL & " WHERE PKEY = '" & pkey & "' and QSORDER = '" & QSORDER & "' "
SQL = SQL & " ) "
SQL = SQL & " SELECT 'col' as gubun, '1' AS TYPE, value FROM OPENJSON(@data,'$.COL') UNION ALL "
SQL = SQL & " SELECT 'row' as gubun, '1' AS TYPE, value FROM OPENJSON(@data,'$.ROW') "
SQL = SQL & " SET NOCOUNT OFF; "
Rcset.Open SQL, DBConn,3,1,1
Response.Write RecordToJSON(Rcset)
'Response.write SQL
Response.End
CASE "GET_QUOTA_CNT"
Response.ContentType = "application/json"
QSORDER = request("QSORDER")
SQL = ""
SQL = SQL & " SELECT [id], [cnt], [ori_cnt], [QUOTAJSON] "
SQL = SQL & " FROM [QUOTA] "
SQL = SQL & " where pkey = '" & pkey & "' and qsorder = "&QSORDER
SQL = SQL & " order by id "
Rcset.Open SQL, DBConn,3,1,1
Response.Write RecordToJSON(Rcset)
'Response.write SQL
Response.End
CASE "UPDATE_QUOTA_CELL"
Dim jsonObj
Dim ONLYCNT : ONLYCNT = request("ONLYCNT")
QSORDER = request("QSORDER")
QUOTAJSON = request("QUOTAJSON")
Set jsonObj = New aspJSON
jsonObj.loadJSON(QUOTAJSON)
For Each icnt In jsonOBJ.data
SQL = ""
SQL = SQL & " update a set a.cnt = " & jsonOBJ.data(icnt).item("cnt")
IF ONLYCNT = "0" THEN
SQL = SQL & ", a.ori_cnt = " & jsonOBJ.data(icnt).item("cnt")
END IF
SQL = SQL & " from [QUOTA] a "
SQL = SQL & " where pkey = '" & pkey & "' and qsorder = " & QSORDER & " and [id] = " & jsonOBJ.data(icnt).item("quotaid")
DBConn.Execute SQL
Next
response.write "저장됐습니다."
' mskwon 2025-07-21 추가
' CASE "UNSETQUOTA"
' Response.ContentType = "application/json"
' SQL = ""
' SQL = SQL & " SELECT QINFO " & vbCrLf
' SQL = SQL & " FROM [STRUCTURE] WHERE PKEY = '" & pkey & "' " & vbCrLf
' Rcset.Open SQL, DBConn, 3, 1, 1
' Response.Write RecordToJSON(Rcset)
' Response.End
CASE Else
END SELECT
Call DBClose()
%>