글 수 7,449
조회 수 : 1233
2006.10.24 (22:12:45)
게시판을 이용해 주셔서 감사합니다.
다음양식에 맞게 입력해주세요.
* 고객시스템명 : LG CNS
* GAUCE 버전 : 3.5
* WAS 종류(WebLogic 등등) : 8.x
* DB 종류 : Oracle 9i
* 문의 유형(질문/요청/참조) : 질문
* 내용 : 수제건과 같이 SubSumText 를 subsum 라인별 표현하고 싶습니다.
아래는 소스이고 소스가 너무길어 필요 부분만 첨부 합니다.
=== 아 래 ===
function f_gridHeaderSet() {
var currentMonth = eme_currentMonth.text.substring(4,6);
gr_inventoryTurnoverRatio.format = ''
+'<fc> id=branchName name="LG Office" sort=true width=78 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText="Sub Total", SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=agentName name="Agent" sort=true width=70 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="6", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=product name="Product" sort=true width=80 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="5", SubSumText="", value={decode(product,""," ",product)}, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=productLine name="Product;Line" sort=true width=80 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="4", SubSumText="", value={decode(productLine,""," ",productLine)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=shipFrom name="Ship;From" sort=true width=55 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="3", SubSumText="", value={decode(shipFrom,""," ",shipFrom)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=gblModelAndGblSuffix name="Global Model.Suffix" sort=true width=140 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="2", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=agentModel name="Agent Model" sort=true width=100 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="1", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=monthCurrent name="Current("'+currentMonth+'")" width=80 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</fc>'
+'<c> id=month01 name=1M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month02 name=2M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month03 name=3M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month04 name=4M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month05 name=5M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month06 name=6M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month09 name=9M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month12 name=12M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month12Over name="12M ~" width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>';
+'<h> id=modelMapId name="ModelMapId" width=50 align=left HeadBgColor=#F7F7EF, HeadColor=Black, SumColor="Black", SumBgColor="#F7F7EF"</h>'
gr_inventoryTurnoverRatio.dataid = "ds_inventoryAsing";
}
<!-----------------------------------------------------------------------------
Dataset Components Declaration
------------------------------------------------------------------------------>
<!-- 재고 월 DataSet -->
<object id="ds_inventoryAsing" classid="<%=LGauceId.DATASET%>">
<param name=SubsumExpr value="3:branchName,2:agentName,1:product">
<param name=SyncLoad value=true >
</object>
위의 소스에서 grid 컴포넌트에서 데이터를 보여줄때 SubsumExpr의 value 값에서 3, 2, 1 의 값을 알아내어
'<fc> id=branchName name="LG Office" sort=true width=78 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText={decode(???,3,"Sub Total","") , SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
이런식으로 현현하고 싶습니다. 물론 ???는 제가 모르는 것이기에 물음표 처리 하였습니다.
연락처 : 02-3777-3142, 심동섭.
그럼 수고 하세요.
다음양식에 맞게 입력해주세요.
* 고객시스템명 : LG CNS
* GAUCE 버전 : 3.5
* WAS 종류(WebLogic 등등) : 8.x
* DB 종류 : Oracle 9i
* 문의 유형(질문/요청/참조) : 질문
* 내용 : 수제건과 같이 SubSumText 를 subsum 라인별 표현하고 싶습니다.
아래는 소스이고 소스가 너무길어 필요 부분만 첨부 합니다.
=== 아 래 ===
function f_gridHeaderSet() {
var currentMonth = eme_currentMonth.text.substring(4,6);
gr_inventoryTurnoverRatio.format = ''
+'<fc> id=branchName name="LG Office" sort=true width=78 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText="Sub Total", SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=agentName name="Agent" sort=true width=70 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="6", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=product name="Product" sort=true width=80 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="5", SubSumText="", value={decode(product,""," ",product)}, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=productLine name="Product;Line" sort=true width=80 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="4", SubSumText="", value={decode(productLine,""," ",productLine)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=shipFrom name="Ship;From" sort=true width=55 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="3", SubSumText="", value={decode(shipFrom,""," ",shipFrom)} show=false, SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=gblModelAndGblSuffix name="Global Model.Suffix" sort=true width=140 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="2", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=agentModel name="Agent Model" sort=true width=100 align=left HeadBgColor=#F7F7EF, HeadColor=Black, suppress="1", SubSumText="", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
+'<fc> id=monthCurrent name="Current("'+currentMonth+'")" width=80 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</fc>'
+'<c> id=month01 name=1M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month02 name=2M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month03 name=3M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month04 name=4M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month05 name=5M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month06 name=6M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month09 name=9M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month12 name=12M width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>'
+'<c> id=month12Over name="12M ~" width=50 align=reight HeadBgColor=#F7F7EF, HeadColor=Black, dec=0 gte_columntype="number:0:true", SumColor="Black", SumBgColor="#F7F7EF", SumText=@sum</c>';
+'<h> id=modelMapId name="ModelMapId" width=50 align=left HeadBgColor=#F7F7EF, HeadColor=Black, SumColor="Black", SumBgColor="#F7F7EF"</h>'
gr_inventoryTurnoverRatio.dataid = "ds_inventoryAsing";
}
<!-----------------------------------------------------------------------------
Dataset Components Declaration
------------------------------------------------------------------------------>
<!-- 재고 월 DataSet -->
<object id="ds_inventoryAsing" classid="<%=LGauceId.DATASET%>">
<param name=SubsumExpr value="3:branchName,2:agentName,1:product">
<param name=SyncLoad value=true >
</object>
위의 소스에서 grid 컴포넌트에서 데이터를 보여줄때 SubsumExpr의 value 값에서 3, 2, 1 의 값을 알아내어
'<fc> id=branchName name="LG Office" sort=true width=78 align=center HeadBgColor=#F7F7EF, HeadColor=Black, suppress="7", SubSumText={decode(???,3,"Sub Total","") , SumText="Grand Total", SumColor="Black", SumBgColor="#F7F7EF"</fc>'
이런식으로 현현하고 싶습니다. 물론 ???는 제가 모르는 것이기에 물음표 처리 하였습니다.
연락처 : 02-3777-3142, 심동섭.
그럼 수고 하세요.
http://member.shift.co.kr/index.php?document_srl=233260
(*.247.145.11)
|
|
