YNU_JEUS/app_home/himed/xpapps/mis/ctmsxp/xp/SMRIS00700_월별수익현황.xfdl

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRIS00700" position="absolute 0 0 1208 818" titletext="과제관리" onload="SMRIS00700_onload">
    <Layouts>
      <Layout>
        <Div id="group3" position="absolute 0 26 1205 66" style="align: top;" class="div_SA" anchor="left top right">
          <Layouts>
            <Layout>
              <Button id="btn_search" class="btn3" position="absolute 1137 10 1196 29" style="" text="조회" onclick="group3_btn_search_onclick" anchor="top right"/>
              <Static id="caption1" position="absolute 180 10 192 30" style="font:,,bold;" text="~" anchor="left top"/>
              <Static id="caption2" position="absolute 13 10 96 30" style="" text="조회기간" anchor="left top" class="search_name"/>
              <cp_monthCal id="cp_monthCal00" titletext="monthCalendar" taborder="1" text="cp_monthCal00" scrollbars="none" position="absolute 98 10 173 30" anchor="left top"/>
              <cp_monthCal id="cp_monthCal01" titletext="monthCalendar" taborder="2" text="cp_monthCal01" scrollbars="none" position="absolute 195 11 270 31" anchor="left top"/>
            </Layout>
          </Layouts>
        </Div>
        <Grid id="grd_monthlyprofit" binddataset="ds_main_profitlist" position="absolute 0 70 1205 814" style="" anchor="all" cellsizingtype="both" cellmovingtype="col" autofittype="col" autosizebandtype="body" cellsizebandtype="allband" extendsizetype="both">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="40" band="left"/>
                <Column size="65"/>
                <Column size="90"/>
                <Column size="85"/>
                <Column size="140"/>
                <Column size="100"/>
                <Column size="100"/>
                <Column size="85"/>
                <Column size="140"/>
                <Column size="90"/>
                <Column size="153"/>
                <Column size="113"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell rowspan="2" taborder="undefined"/>
                <Cell col="1" rowspan="2" text="월" taborder="undefined"/>
                <Cell col="2" rowspan="2" text="입금일" taborder="undefined"/>
                <Cell col="3" rowspan="2" text="연구책임자" taborder="undefined"/>
                <Cell col="4" rowspan="2" text="연구의뢰사" taborder="undefined"/>
                <Cell col="5" rowspan="2" text="수익액" taborder="undefined"/>
                <Cell col="6" rowspan="2" text="직접비" taborder="undefined"/>
                <Cell col="7" colspan="3" text="간접비" taborder="undefined"/>
                <Cell col="10" rowspan="2" text="연구과제명" taborder="undefined"/>
                <Cell col="11" rowspan="2" text="비고" taborder="undefined"/>
                <Cell col="12" text="월"/>
                <Cell col="13" text="입금일"/>
                <Cell col="14" text="연구책임자"/>
                <Cell col="15" text="연구의뢰사"/>
                <Cell col="16" text="수익액"/>
                <Cell col="17" text="직접비"/>
                <Cell col="18" text="일반관리비"/>
                <Cell col="19" text="약제_의료기기관리비"/>
                <Cell col="20" text="계"/>
                <Cell col="21" text="연구과제명"/>
                <Cell col="22" text="비고"/>
                <Cell row="1" col="7" text="일반관리비"/>
                <Cell row="1" col="8" text="약제_의료기기관리비"/>
                <Cell row="1" col="9" text="계"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow + 1"/>
                <Cell col="1" displaytype="expr:mon == '소계' ? 'normal' : mon == '합계' ? 'normal' : 'date'" style="background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:mon" mask="expr:mon == '소계' ? '' : mon == '합계' ? '' : 'yyyy-MM'" suppress="1" suppressalign="middle,over"/>
                <Cell col="2" displaytype="expr:mon == '소계' ? 'normal' : mon == '합계' ? 'normal' : 'date'" style="background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:bsdd" suppress="0"/>
                <Cell col="3" style="background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:hngnm" suppress="0"/>
                <Cell col="4" style="align:left middle;background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:reqfirm" suppress="0"/>
                <Cell col="5" displaytype="number" style="background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:inamt" suppress="0"/>
                <Cell col="6" displaytype="number" style="background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:drctamt" suppress="0"/>
                <Cell col="7" displaytype="number" style="background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:icmmnamt" suppress="0"/>
                <Cell col="8" displaytype="number" style="background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:idrugamt" suppress="0"/>
                <Cell col="9" displaytype="number" style="background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:indramt" suppress="0"/>
                <Cell col="10" style="align:left top;background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:projnm" wordwrap="word" suppress="0"/>
                <Cell col="11" displaytype="text" style="align:left top;background:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');background2:EXPR(mon == '소계' ? '#FFFFDA' : mon == '합계' ? '#FFBBFF' : 'default');" text="bind:bigo" wordwrap="word" suppress="0"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption10" text="월별 수익현황" class="tit_1" position="absolute 0 0 160 26"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_main_profitlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="mon" type="STRING" size="256"/>
          <Column id="bsdd" type="STRING" size="256"/>
          <Column id="rshid" type="STRING" size="256"/>
          <Column id="reqfirm" type="STRING" size="256"/>
          <Column id="inamt" type="STRING" size="256"/>
          <Column id="drctamt" type="STRING" size="256"/>
          <Column id="indramt" type="STRING" size="256"/>
          <Column id="idrugamt" type="STRING" size="256"/>
          <Column id="icmmnamt" type="STRING" size="256"/>
          <Column id="projnm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_reqdata" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="keep">
        <ColumnInfo>
          <Column id="bsddfrom" type="STRING" size="256"/>
          <Column id="bsddto" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="bsddfrom"/>
            <Col id="bsddto"/>
          </Row>
        </Rows>
      </Dataset>
    </Objects>
    <Bind/>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-01-10
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2018-01-10      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";

function SMRIS00700_onload(obj:Form, e:LoadEventInfo) {
	frmf_initForm(obj); 
	grdf_setToolTipBind(grd_monthlyprofit);
	//grdf_initGrid(grd_XXX); 
	//grdf_setGridSort(grd_XXX); 
	//grdf_setRowTypeIcon(grd_XXX, 0_컬럼위치값); 

	fInit();
}

function group3_btn_search_onclick(obj:Button, e:ClickEventInfo) {

	fSearch();
}

function fInit(){
	group3.cp_monthCal00.setData(utlf_getCurrentDate().toDate().getAddDate(-1, "M").getDateFormat());
	group3.cp_monthCal01.setData(utlf_getCurrentDate());
	ds_send_reqdata.setColumn(0,"bsddfrom", utlf_getCurrentDate().toDate().getAddDate(-1, "M").getDateFormat());
	ds_send_reqdata.setColumn(0,"bsddto", utlf_getCurrentDate());
}

function fSearch(){
	ds_send_reqdata.setColumn(0,"bsddfrom", group3.cp_monthCal00.getData());
	ds_send_reqdata.setColumn(0,"bsddto", group3.cp_monthCal01.getData());
	
	var oParam = {};
		oParam.id          = "TRRIS00701";
		oParam.service     = "ctmsapp.StatsMngt";
		oParam.method      = "reqGetMonthlyProfitList";
		oParam.inds        = "req=ds_send_reqdata";
		oParam.outds       = "ds_main_profitlist=profitlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRIS00701";

	tranf_submit(oParam);

}
]]></Script>
  </Form>
</FDL>