Files
KON-KIWI/include/ajax_contact.asp

190 lines
8.7 KiB
Plaintext

<!-- #include Virtual="/Lib/Config.asp"-->
<%
Server.ScriptTimeOut = 60 * 5
Dim SQL,Rcset
Dim COMMAND : COMMAND = Request("COMMAND")
Dim CRUD : CRUD = Request("CRUD")
Dim PKEY : PKEY = Request("PKEY")
Dim PSIDX : PSIDX = Request("PSIDX")
Dim TARGET : TARGET = Request("TARGET")
Dim PSIDX_CHECK
Const KON_CONTACT_API_KEY = "4B726963-436F6E74616374-53657276696365-402531213230"
Set Rcset = Server.CreateObject("ADODB.RecordSet")
Dim ObjCmd : set ObjCmd = Server.CreateObject("ADODB.Command")
IF (CRUD = "INSERT" OR CRUD = "DELETE") AND COMMAND = "CONTACT_SURVEY" THEN
IF Request.ServerVariables("HTTP_X_API_KEY") <> KON_CONTACT_API_KEY THEN
Response.Status = "401 Unauthorized"
Response.AddHeader "Cache-Control", "no-store"
Response.ContentType = "application/json; charset=utf-8"
Response.Write "{""message"":""Authentication required""}"
Response.End
END IF
END IF
IF (CRUD = "INSERT" OR CRUD = "SELECT" OR CRUD = "DELETE") AND COMMAND = "CONTACT_SURVEY" THEN
IF Len(PKEY) = 0 OR Len(PKEY) > 20 THEN
Response.Status = "400 Bad Request"
Response.ContentType = "application/json; charset=utf-8"
Response.Write "{""message"":""Invalid PKEY""}"
Response.End
END IF
IF CRUD = "INSERT" OR CRUD = "DELETE" THEN
IF Len(TARGET) = 0 OR Len(TARGET) > 32 THEN
Response.Status = "400 Bad Request"
Response.ContentType = "application/json; charset=utf-8"
Response.Write "{""message"":""Invalid TARGET""}"
Response.End
END IF
END IF
IF CRUD = "INSERT" OR CRUD = "DELETE" THEN
Set PSIDX_CHECK = Server.CreateObject("VBScript.RegExp")
PSIDX_CHECK.Pattern = "^-?[0-9]{1,19}$"
IF NOT PSIDX_CHECK.Test(PSIDX) THEN
Response.Status = "400 Bad Request"
Response.ContentType = "application/json; charset=utf-8"
Response.Write "{""message"":""Invalid PSIDX""}"
Response.End
END IF
END IF
END IF
Call DBConnect2()
SELECT CASE CRUD
'-- CREATE '
CASE "CREATE"
SELECT CASE COMMAND
END SELECT
'-- SELECT '
CASE "SELECT"
SELECT CASE COMMAND
CASE "CONTACT_SURVEY"
response.ContentType = "application/json"
SQL = ""
SQL = SQL & " SELECT IDX, PKEY, PSIDX, TARGET_SYSTEM, REG_DT FROM KON_CONTACT_MAPPING WHERE PKEY = ? ORDER BY IDX "
With ObjCmd
.ActiveConnection = DBConn
.CommandText = SQL
.CommandType = adCmdText
.Parameters.Append .CreateParameter("@PKEY", adVarChar, adParamInput, 20)
.Parameters("@PKEY") = PKEY
End With
Rcset.Open ObjCmd, , 3, 1
IF Rcset.eof or Rcset.bof THEN
response.write "[]"
ELSE
response.write RecordToJSON(Rcset)
END IF
Rcset.Close
Set Rcset = Nothing
Set ObjCmd = Nothing
Call DBClose()
response.end
END SELECT
'-- INSERT '
CASE "INSERT"
SELECT CASE COMMAND
CASE "CONTACT_SURVEY"
SQL = ""
SQL = SQL & " INSERT INTO KON_CONTACT_MAPPING (PKEY, PSIDX, TARGET_SYSTEM) VALUES (?, CAST(? AS BIGINT), ?) "
With ObjCmd
.ActiveConnection = DBConn
.CommandText = SQL
.CommandType = adCmdText
.Parameters.Append .CreateParameter("@PKEY", adVarChar, adParamInput, 20)
.Parameters.Append .CreateParameter("@PSIDX", adVarChar, adParamInput, 20)
.Parameters.Append .CreateParameter("@TARGET", adVarChar, adParamInput, 32)
.Parameters("@PKEY") = PKEY
.Parameters("@PSIDX") = PSIDX
.Parameters("@TARGET") = TARGET
.Execute , , adExecuteNoRecords
End With
CASE "EXTERNAL_API_LOG"
Dim LOG_API_NAME, LOG_IDKEY, LOG_RESULT, LOG_HTTP_MESSAGE, LOG_MESSAGE_SIZE
LOG_API_NAME = Trim(Request("API_NAME"))
LOG_IDKEY = Trim(Request("IDKEY"))
LOG_RESULT = Trim(Request("RESULT"))
LOG_HTTP_MESSAGE = Request("HTTP_MESSAGE")
IF Len(LOG_API_NAME) = 0 OR Len(LOG_API_NAME) > 30 OR Len(PKEY) > 20 OR Len(LOG_IDKEY) > 100 OR Len(LOG_RESULT) = 0 OR Len(LOG_RESULT) > 10 THEN
Response.Status = "400 Bad Request"
Response.Write "Invalid log parameters"
Response.End
END IF
IF Len(PSIDX) > 0 THEN
Set PSIDX_CHECK = Server.CreateObject("VBScript.RegExp")
PSIDX_CHECK.Pattern = "^-?[0-9]{1,19}$"
IF NOT PSIDX_CHECK.Test(PSIDX) THEN
Response.Status = "400 Bad Request"
Response.Write "Invalid PSIDX"
Response.End
END IF
END IF
LOG_MESSAGE_SIZE = Len(LOG_HTTP_MESSAGE)
IF LOG_MESSAGE_SIZE = 0 THEN LOG_MESSAGE_SIZE = 1
SQL = " INSERT INTO KON_EXTERNAL_API_LOG (API_NAME, PKEY, IDKEY, PSIDX, RESULT, HTTP_MESSAGE) VALUES (?, ?, ?, CAST(NULLIF(?, '') AS BIGINT), ?, ?) "
With ObjCmd
.ActiveConnection = DBConn
.CommandText = SQL
.CommandType = adCmdText
.Parameters.Append .CreateParameter("@API_NAME", adVarChar, adParamInput, 30)
.Parameters.Append .CreateParameter("@PKEY", adVarChar, adParamInput, 20)
.Parameters.Append .CreateParameter("@IDKEY", adVarChar, adParamInput, 100)
.Parameters.Append .CreateParameter("@PSIDX", adVarChar, adParamInput, 20)
.Parameters.Append .CreateParameter("@RESULT", adVarChar, adParamInput, 10)
.Parameters.Append .CreateParameter("@HTTP_MESSAGE", adLongVarWChar, adParamInput, LOG_MESSAGE_SIZE)
.Parameters("@API_NAME") = LOG_API_NAME
IF Len(PKEY) = 0 THEN
.Parameters("@PKEY") = Null
ELSE
.Parameters("@PKEY") = PKEY
END IF
IF Len(LOG_IDKEY) = 0 THEN
.Parameters("@IDKEY") = Null
ELSE
.Parameters("@IDKEY") = LOG_IDKEY
END IF
.Parameters("@PSIDX") = PSIDX
.Parameters("@RESULT") = LOG_RESULT
IF Len(LOG_HTTP_MESSAGE) = 0 THEN
.Parameters("@HTTP_MESSAGE") = Null
ELSE
.Parameters("@HTTP_MESSAGE") = LOG_HTTP_MESSAGE
END IF
.Execute , , adExecuteNoRecords
End With
END SELECT
'-- DELETE '
CASE "DELETE"
SELECT CASE COMMAND
CASE "CONTACT_SURVEY"
SQL = ""
SQL = SQL & " DELETE FROM KON_CONTACT_MAPPING WHERE PKEY = ? AND PSIDX = CAST(? AS BIGINT) AND TARGET_SYSTEM = ? "
With ObjCmd
.ActiveConnection = DBConn
.CommandText = SQL
.CommandType = adCmdText
.Parameters.Append .CreateParameter("@PKEY", adVarChar, adParamInput, 20)
.Parameters.Append .CreateParameter("@PSIDX", adVarChar, adParamInput, 20)
.Parameters.Append .CreateParameter("@TARGET", adVarChar, adParamInput, 32)
.Parameters("@PKEY") = PKEY
.Parameters("@PSIDX") = PSIDX
.Parameters("@TARGET") = TARGET
.Execute , , adExecuteNoRecords
End With
END SELECT
END SELECT
Set ObjCmd = Nothing
If Not Rcset Is Nothing Then Set Rcset = Nothing
call DBClose()
%>