YNU_JEUS/app_home/himed/xpapps/mis/reqxp/xp/SMRSD07300_치과재료 처방집계 조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMRSD07300" position="absolute 0 0 1201 775" titletext="처방집계 시행부서별" oninit="SMRSD07300_oninit" onload="SMRSD07300_onload">
    <Layouts>
      <Layout>
        <Static id="caption6" text="처방집계 시행부서별 조회" class="tit_1" position="absolute 0 0 230 25"/>
        <Div id="grp_search" anchor="left top right" taborder="1" class="div_SA2" position="absolute 0 55 1195 115">
          <Layouts>
            <Layout>
              <Static id="cap_allsizespecid" text="규격코드 :" class="search_name" position="absolute 975 10 1086 27" anchor="default"/>
              <Shape id="line30" linetype="vertical" class="line_4" position="absolute 1107 4 1113 58" anchor="top right"/>
              <Button id="btn_search" taborder="17" text="조회" class="btn1" position="absolute 1125 20 1181 42" anchor="top right" onclick="grp_search_btn_search_onclick"/>
              <Combo id="cmb_instcd" taborder="18" innerdataset="ds_init_cmb_instcd" codecolumn="cnstcd" datacolumn="cnstnm" class="combo_default" position="absolute 96 8 262 27" anchor="default"/>
              <Static id="cap_instcd" text="기관코드 :" class="search_name" position="absolute 10 9 96 26" anchor="default"/>
              <Edit id="ipt_goodnm" taborder="19" class="output" position="absolute 890 8 1095 27" style="background:URL('theme://images/bg_edit_R.png') stretch 5,5;" anchor="default"/>
              <Button id="btn_goodcd" taborder="20" class="icon_search" position="absolute 866 8 882 24" anchor="default" onclick="grp_search_btn_goodcd_onclick"/>
              <Edit id="ipt_goodcd" taborder="21" autoselect="true" autoskip="true" class="input_search" position="absolute 771 8 860 27" anchor="default"/>
              <Static id="cap_goodcd" text="물품코드 :" class="search_name" position="absolute 675 10 761 27" anchor="default"/>
              <Button id="button1" taborder="22" class="icon_search" position="absolute 494 10 510 26" anchor="default" onclick="grp_search_button1_onclick"/>
              <Edit id="ipt_prcpdeptnm" taborder="23" autoselect="true" autoskip="true" class="input_fix" position="absolute 515 8 645 27" anchor="default"/>
              <Edit id="ipt_prcpdeptcd" taborder="24" autoselect="true" autoskip="true" class="input_fix" position="absolute 404 8 489 27" anchor="default"/>
              <Static id="caption2" text="시행부서 :" class="search_name" position="absolute 305 10 398 27" anchor="default"/>
              <Calendar id="ipt_prcpmm" taborder="25" autoselect="true" autoskip="true" class="input_essential" position="absolute 96 34 262 53" mask="yyyy-mm" anchor="default" dateformat="yyyy-MM" value="null" editformat="yyyy-MM" style="align:left middle;" onchanged="grp_search_ipt_prcpmm_onchanged"/>
              <Static id="caption3" text="시행  월  :" class="search_name" position="absolute 7 35 96 52" anchor="default"/>
              <Radio id="rdo_sumflag" taborder="26" columncount="3" rowcount="0" innerdataset="@ds_init_sumflag" codecolumn="value" datacolumn="label" position="absolute 404 36 577 53" anchor="default"/>
              <Static id="caption7" text="집계여부 :" class="search_name" position="absolute 305 36 394 53" anchor="default"/>
              <Static id="caption1" text="물품구분 :" class="search_name" position="absolute 675 37 761 54" anchor="default"/>
              <Combo id="cmb_goodflag" taborder="27" codecolumn="codecolumn" datacolumn="datacolumn" class="combo_default" position="absolute 770 34 918 53" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn"/>
                    <Column id="datacolumn"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">S</Col>
                      <Col id="datacolumn">치과재료</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">C</Col>
                      <Col id="datacolumn">방사선재료</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
            </Layout>
          </Layouts>
        </Div>
        <Shape id="line1" class="line_10" position="absolute 0 150 1195 156" anchor="left top right"/>
        <Grid id="grd_prcptot" taborder="2" binddataset="ds_main_list_prcptotinfo_prcptotlist" autoenter="select" useinputpanel="false" cellsizingtype="col" autofittype="col" position="absolute 0 155 1195 770" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="21" band="left"/>
                <Column size="125"/>
                <Column size="133"/>
                <Column size="0"/>
                <Column size="129"/>
                <Column size="80"/>
                <Column size="33"/>
                <Column size="102"/>
                <Column size="112"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="69"/>
                <Column size="100"/>
                <Column size="86"/>
                <Column size="86"/>
                <Column size="66"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
                <Column size="0"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" text="계정"/>
                <Cell col="2" text="시행부서"/>
                <Cell col="3" text="거래처코드"/>
                <Cell col="4" text="거래처명"/>
                <Cell col="5" colspan="2" text="물품코드" taborder="undefined"/>
                <Cell col="7" text="물품명"/>
                <Cell col="8" text="규격"/>
                <Cell col="9" text="모델"/>
                <Cell col="10" text="수불수량"/>
                <Cell col="11" text="선입고량"/>
                <Cell col="12" text="출고량"/>
                <Cell col="13" text="BOX 단위"/>
                <Cell col="14" colspan="2" text="계약기간" taborder="undefined"/>
                <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 col="23" text="제조회사"/>
                <Cell col="24" text="단가"/>
                <Cell col="25" text="금액"/>
                <Cell col="26" text="청구월"/>
                <Cell col="27" text="입고계정"/>
                <Cell col="28" text="청구유무"/>
                <Cell col="29" text="출고일자(from)"/>
              </Band>
              <Band id="body">
                <Cell celltype="head" expr="currow+1"/>
                <Cell col="1" text="bind:winacntnm"/>
                <Cell col="2" text="bind:prcpdeptnm"/>
                <Cell col="3" text="bind:maincustlastsuplplce"/>
                <Cell col="4" text="bind:maincustlastsuplplcenm"/>
                <Cell col="5" text="bind:goodcd"/>
                <Cell col="6" text="bind:allsizespecid"/>
                <Cell col="7" text="bind:goodnm"/>
                <Cell col="8" text="bind:goodspec"/>
                <Cell col="9" text="bind:goodmodel"/>
                <Cell col="10" text="bind:deliveqty" mask="#,###"/>
                <Cell col="11" text="bind:totreqqty" mask="#,###"/>
                <Cell col="12" displaytype="number" text="bind:totstocqty"/>
                <Cell col="13" text="bind:fullpurcunit"/>
                <Cell col="14" displaytype="date" text="bind:fromconterm" calendardisplaynulltype="nulltext"/>
                <Cell col="15" displaytype="date" text="bind:toconterm" calendardisplaynulltype="nulltext"/>
                <Cell col="16" text="bind:costconyn"/>
                <Cell col="17" text="bind:exchqty"/>
                <Cell col="18" text="bind:purcunit"/>
                <Cell col="19" text="bind:instcd"/>
                <Cell col="20" text="bind:goodflag"/>
                <Cell col="21" text="bind:wareflag"/>
                <Cell col="22" text="bind:reqmm"/>
                <Cell col="23" text="bind:prodcmpynm"/>
                <Cell col="24" text="bind:goodunitcost"/>
                <Cell col="25" text="bind:reqfla"/>
                <Cell col="26" text="bind:reqmm"/>
                <Cell col="27" text="bind:winacnt"/>
                <Cell col="28" text="bind:reqyn"/>
                <Cell col="29" text="bind:deliveddfr"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_excel" taborder="3" text="Excel" class="btn5" position="absolute 1141 131 1194 150" anchor="top right" onclick="btn_excel_onclick"/>
        <Shape id="line7" class="line_6" position="absolute 0 49 1195 55" anchor="left top right"/>
        <Button id="btn_init" taborder="4" text="초기화" class="btn4" position="absolute 1126 28 1194 50" anchor="top right" onclick="btn_init_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_send_search_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="goodflag" type="STRING" size="256"/>
          <Column id="goodcd" type="STRING" size="256"/>
          <Column id="goodnm" type="STRING" size="256"/>
          <Column id="prcpdeptcd" type="STRING" size="256"/>
          <Column id="prcpdeptnm" type="STRING" size="256"/>
          <Column id="prcpmm" type="STRING" size="256"/>
          <Column id="sumflag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="instcd"/>
            <Col id="goodflag"/>
            <Col id="goodcd"/>
            <Col id="goodnm"/>
            <Col id="prcpdeptcd"/>
            <Col id="prcpdeptnm"/>
            <Col id="prcpmm"/>
            <Col id="sumflag"/>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_init_sumflag" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="label" type="STRING" size="256"/>
          <Column id="value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="label">전체</Col>
            <Col id="value"/>
          </Row>
          <Row>
            <Col id="label">집계</Col>
            <Col id="value">Y</Col>
          </Row>
          <Row>
            <Col id="label">미집계</Col>
            <Col id="value">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_list_prcptotinfo_prcptotlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="winacntnm" type="STRING" size="256" sumtext=" 계정과목       "/>
          <Column id="prcpdeptnm" type="STRING" size="256" sumtext=" 시행부서       "/>
          <Column id="maincustlastsuplplce" type="STRING" size="256" sumtext=" 거래처코드     "/>
          <Column id="maincustlastsuplplcenm" type="STRING" size="256" sumtext=" 거래처명       "/>
          <Column id="goodcd" type="STRING" size="256" sumtext=" 물품코드       "/>
          <Column id="allsizespecid" type="STRING" size="256" sumtext=" 규격코드       "/>
          <Column id="goodnm" type="STRING" size="256" sumtext=" 물품명         "/>
          <Column id="goodspec" type="STRING" size="256" sumtext=" 규격           "/>
          <Column id="goodmodel" type="STRING" size="256" sumtext=" 모델           "/>
          <Column id="deliveqty" type="STRING" size="256" sumtext=" 수불수량       "/>
          <Column id="totreqqty" type="STRING" size="256" sumtext=" 선입고량       "/>
          <Column id="totstocqty" type="STRING" size="256" sumtext=" 출고량         "/>
          <Column id="fullpurcunit" type="STRING" size="256" sumtext=" BOX 단위       "/>
          <Column id="fromconterm" type="STRING" size="256" sumtext=" 계약기간(from) "/>
          <Column id="toconterm" type="STRING" size="256" sumtext=" 계약기간(to)   "/>
          <Column id="costconyn" type="STRING" size="256" sumtext=" 단가계약 여부  "/>
          <Column id="exchqty" type="STRING" size="256" sumtext=" 환산수량       "/>
          <Column id="purcunit" type="STRING" size="256" sumtext=" 구매단위       "/>
          <Column id="instcd" type="STRING" size="256" sumtext=" 기관코드       "/>
          <Column id="goodflag" type="STRING" size="256" sumtext=" 물품구분       "/>
          <Column id="wareflag" type="STRING" size="256" sumtext=" 창고구분       "/>
          <Column id="reqmm" type="STRING" size="256" sumtext=" 청구월         "/>
          <Column id="prodcmpynm" type="STRING" size="256" sumtext=" 제조회사       "/>
          <Column id="goodunitcost" type="STRING" size="256" sumtext=" 단가           "/>
          <Column id="reqfla" type="STRING" size="256" sumtext=" 금액           "/>
          <Column id="reqmm" type="STRING" size="256" sumtext=" 청구월         "/>
          <Column id="winacnt" type="STRING" size="256" sumtext=" 입고계정       "/>
          <Column id="reqyn" type="STRING" size="256" sumtext=" 청구유무       "/>
          <Column id="deliveddfr" type="STRING" size="256" sumtext=" 출고일자(from) "/>
        </ColumnInfo>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_search.cmb_instcd" propid="value" datasetid="ds_send_search" columnid="instcd"/>
      <BindItem id="item1" compid="grp_search.ipt_prcpmm" propid="value" datasetid="ds_send_search" columnid="prcpmm"/>
      <BindItem id="item2" compid="grp_search.ipt_prcpdeptcd" propid="value" datasetid="ds_send_search" columnid="prcpdeptcd"/>
      <BindItem id="item3" compid="grp_search.ipt_prcpdeptnm" propid="value" datasetid="ds_send_search" columnid="prcpdeptnm"/>
      <BindItem id="item4" compid="grp_search.ipt_goodcd" propid="value" datasetid="ds_send_search" columnid="goodcd"/>
      <BindItem id="item5" compid="grp_search.ipt_goodnm" propid="value" datasetid="ds_send_search" columnid="goodnm"/>
      <BindItem id="item6" compid="grp_search.rdo_sumflag" propid="value" datasetid="ds_send_search" columnid="sumflag"/>
      <BindItem id="item7" compid="grp_search.cmb_goodflag" propid="value" datasetid="ds_send_search" columnid="goodflag"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[/***************************************************************************************  
 * System Name		:	
 * Job Name 		:	
 * Creator 	    :	
 * Make Date 		:	2017-06-19
 * Description  	:	                                                                   
 *--------------------------------------------------------------------------------------- 
 * Modify Date     	Modifier  	  Modify Description                                   
 *--------------------------------------------------------------------------------------- 
 * 2017-06-19      Live Converter   TF->XP                                           
 *                                                                                        
 *--------------------------------------------------------------------------------------- 
 ****************************************************************************************/
include "com_commonxp::comm_main.xjs";
include "mis_miscommonxp::MIS.xjs";
include "mis_miscommonxp::RSZ001.xjs";
function SMRSD07300_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SMRSD07300_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(grd_prcptot);
	
	fInitialize();
}

function fInitialize()
{
	var curdate = utlf_getCurrentDate();
	var cvtdate = curdate.toDate("YYYYMMDD");

	misfComboComCdListMulti("Z0007","grp_search.cmb_instcd");      		     
	ds_send_search.setColumn(0, "instcd", sysf_getUserInfo("dutplceinstcd"));
	
	ds_send_search.setColumn(0, "prcpmm", cvtdate.getDateFormat("YYYYMM"));
	
	ds_main_list_prcptotinfo_prcptotlist.clearData();
	grp_search.cmb_goodflag.index = 0;	
}

function grp_search_button1_onclick(obj:Button,  e:ClickEventInfo)
{
	var recv_list = "prcpdeptcd,prcpdeptnm";
	misfOpenPopUpList("02", grp_search.ipt_prcpdeptcd,"", recv_list) ; 	
}

function grp_search_btn_goodcd_onclick(obj:Button,  e:ClickEventInfo)
{
	rszfOpenPopUpListByWndName(grp_search.ipt_goodcd,"","goodcd,goodnm","SPRSD00210","instcd","grp_search.cmb_instcd");
}

function grp_search_ipt_prcpmm_onchanged(obj:Calendar, e:ChangeEventInfo)
{
	ds_send_search.setColumn(0, "prcpmm", String(obj.value).substr(0,6));
}

function grp_search_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_main_list_prcptotinfo_prcptotlist.clearData();

	var oParam = {};
		oParam.id          = "TRRSD07301";
		oParam.service     = "reqapp.ReqMngt";
		oParam.method      = "reqGetPrcpTotList";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_main_list_prcptotinfo_prcptotlist=prcptotlist";
		oParam.async       = false;
		//oParam.callback    = "cf_TRRSD07301";

	tranf_submit(oParam);
}

function btn_init_onclick(obj:Button,  e:ClickEventInfo)
{
	fInitialize();
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	grdf_exportExcel(grd_prcptot, "처방집계 시행부서별("+ grp_search.ipt_prcpmm.value +")", "처방집계 시행부서별("+ grp_search.ipt_prcpmm.value+")", "true", "", "open");
}
]]></Script>
  </Form>
</FDL>