akc/notes.properties

###################################
# NotesURL
###################################
NotesURL=aspire:\\reports\\notes\\notes.html
NotesURL.formHandlerName=newsURLFormHandler

###################################
# UpdateANoteURL: reportId
###################################
UpdateANoteURL=aspire:\\reports\\notes\\chg-notes.html
UpdateANoteURL.formHandlerName=updateANoteURLFormHandler
request.updateANoteURLFormHandler.form_handler.class_request.className=com.ai.htmlgen.DBHashTableFormHandler1

request.updateANoteURLFormHandler.maindataRequest.classname=com.ai.db.DBPreTranslateArgsMultiRequestExecutor
request.updateANoteURLFormHandler.maindataRequest.db=reportsDB
request.updateANoteURLFormHandler.maindataRequest.request.1=GetReportDetails
request.updateANoteURLFormHandler.maindataRequest.request.2=GetNoteDetails

#
# GetReportDetails
#
request.GetReportDetails.classname=com.ai.db.DBRequestExecutor2
request.GetReportDetails.db=reportsDB
request.GetReportDetails.stmt=\
\
select * \
from reports r left outer join report_types rt on r.report_type_id = rt.report_type_id \
where r.report_id = {reportId}

#
# GetNoteDetails
#
request.GetNoteDetails.classname=com.ai.db.DBRequestExecutor2
request.GetNoteDetails.db=reportsDB
request.GetNoteDetails.stmt=\
\
select * from {report_type_table_name} \
where {report_type_column_name} = {report_content_id}


###################################
# saveNoteRequest:SNR
###################################
request.saveNoteRequest.classname=com.ai.db.DBPreTranslateArgsMultiRequestExecutor
request.saveNoteRequest.db=reportsDB
request.saveNoteRequest.query_type=update
request.saveNoteRequest.request.1=SNRSaveReport
request.saveNoteRequest.request.2=SNRSaveNote
#
#send mail
#
request.saveNoteRequest.request.3=EN.TranslateForMail
request.saveNoteRequest.request.4=EN.CreateBodyText
request.saveNoteRequest.request.5=EN.emailNoteAsynchronously


request.saveNoteRequest.redirectURL=/akc/servlet/DisplayServlet?url=ShowFiledReportsJSPURL

#
# SNRSaveReport
#
request.SNRSaveReport.classname=com.ai.db.DBRequestExecutor2
request.SNRSaveReport.query_type=update
request.SNRSaveReport.stmt=\
\
update reports \
set report_short_name={report_short_name.quote} \
	,report_long_name={report_long_name.quote} \
	,report_description={report_description.quote} \
where report_id = {saveReportId}

#
# SNRSaveReport
#
request.SNRSaveNote.classname=com.ai.db.DBRequestExecutor2
request.SNRSaveNote.query_type=update
request.SNRSaveNote.stmt=\
\
update sql_statements \
set statement={sqlStatement.quote} \
where statement_id = {saveStatementId}