정재석(Buzzer Beat) 님의 말 :
function doPrint(flag){
if(datagrid1.rows == datagrid1.fixedRows){
jsAlert("조회된 데이터가 없습니다.");
return;
}
/* 2011-12-02 수정 */
// var aiRqstNo = doScreenListPrint("datagrid2");
var aiRqstNo1 = doScreenListPrint("datagrid1");
var aiRqstNo2 = doScreenListPrint("datagrid2");
// var param = "AI_RQST_NO="+aiRqstNo+"&AI_RQST_NO1="+aiRqstNo1+"&AI_RQST_NO2="+aiRqstNo2;
var param = "AI_RQST_NO1="+aiRqstNo1+"&AI_RQST_NO2="+aiRqstNo2;
param += "&TITLE1=" + model.getValue("/root/temp/title1");
param += "&TITLE2=" + model.getValue("/root/temp/title2");
if(flag == "view"){
htmlwindow.aiReport("pms/common/popup/popDeptEmpRateList.jsp",param,"","");
}else if(flag == "print"){
htmlwindow.aiReport("pms/common/popup/popDeptEmpRateList.jsp", param, "pop", "print");
}
}
이게 xrw
---------------------------------------------
SELECT AI_DATA_001
,AI_DATA_002
,AI_DATA_003
,AI_DATA_004
,AI_DATA_005
,AI_DATA_006
,AI_DATA_007
,AI_DATA_008
,AI_DATA_009
,AI_DATA_010
,AI_DATA_011
,AI_DATA_012
,AI_DATA_013
,AI_DATA_014
,AI_DATA_015
,AI_DATA_016
,AI_DATA_017
,AI_DATA_018
,AI_DATA_019
,AI_DATA_020
,AI_DATA_021
,AI_DATA_022
,AI_DATA_023
,AI_DATA_024
,AI_DATA_025
,AI_DATA_026
,AI_DATA_027
,AI_DATA_028
,AI_DATA_029
,AI_DATA_030
FROM COM_AI_DATA_DTL
WHERE AI_RQST_NO = '^AI_RQST_NO1^'
이게 ai쿼리