YNU_JEUS/app_home/himed/xpapps/com/hichartxp/xp/SPZMH00200_설명처방콘텐츠조회및관리.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SPZMH00200" classname="SPZMH00200_HiChartList관리" inheritanceid="" position="absolute 0 0 1000 700" titletext="설명처방 콘텐츠 조회 및 관리" oninit="SPZMH00200_HiChartList_oninit" onload="SPZMH00200_HiChartList_onload">
    <Layouts>
      <Layout>
        <Div id="grp_sea" anchor="left top right" taborder="0" style="align:center top;" class="div_SA" position="absolute 0 20 1000 61">
          <Layouts>
            <Layout width="1188" height="67">
              <Button id="btn_search" taborder="64" text="조회" onlbuttondown="grp_sea_btn_search_onlbuttondown" class="btn1" position="absolute 936 10 992 30" anchor="top right" onclick="grp_sea_btn_search_onclick"/>
              <Static id="caption2" text="분류" class="search_name" position="absolute 7 13 48 30" anchor="default"/>
              <Edit id="Edit_code" taborder="65" autoselect="true" onkeydown="grp_sea_ipt_search_wpid_onkeydown" class="input_search" position="absolute 462 10 532 30" anchor="default"/>
              <Combo id="Combo_gubun" taborder="66" position="absolute 51 10 151 30" index="-1" anchor="default" innerdataset="@ds_init_M0770list" codecolumn="cdid" datacolumn="cdnm"/>
              <Static id="caption00" text="콘텐츠코드" class="search_name" position="absolute 378 13 459 30" anchor="default"/>
              <Static id="caption01" text="콘텐츠 제목" class="search_name" position="absolute 551 13 632 30" anchor="default"/>
              <Edit id="Edit_title" taborder="67" autoselect="true" onkeydown="grp_sea_ipt_search_wpid_onkeydown" class="input_search" position="absolute 643 10 818 30" anchor="default"/>
              <Static id="caption03" text="하위분류" class="search_name" position="absolute 175 13 239 30" anchor="default"/>
              <Combo id="Combo_subgubun" taborder="68" position="absolute 251 10 351 30" anchor="default" innerdataset="@ds_init_M0771list" codecolumn="cdid" datacolumn="cdnm"/>
              <Static id="caption04" text="삭제포함" class="search_name" position="absolute 836 13 902 30" anchor="default"/>
              <CheckBox id="CheckBox_del" taborder="69" position="absolute 903 10 922 30" anchor="default" truevalue="Y" falsevalue="N"/>
            </Layout>
          </Layouts>
        </Div>
        <Static id="caption1" text="Hi Chart 조회" class="tit_1" position="absolute 0 0 117 20"/>
        <Static id="caption6" text="Hi Chart 리스트" class="tit_2" position="absolute 0 67 220 84"/>
        <Shape id="line2" class="line_10" position="absolute 0 82 1000 93" anchor="left top right"/>
        <Grid id="Grid_hichartlist" taborder="1" useinputpanel="false" position="absolute 0 89 1000 700" autofittype="col" binddataset="ds_main_hichartlist" oncelldblclick="Grid_hichartlist_oncelldblclick" selecttype="multirow" oncloseup="Grid_hichartlist_oncloseup" autoenter="select" anchor="all">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="30"/>
                <Column size="50"/>
                <Column size="90"/>
                <Column size="110"/>
                <Column size="90"/>
                <Column size="360"/>
                <Column size="65"/>
                <Column size="65"/>
                <Column size="70"/>
                <Column size="70"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell/>
                <Cell col="1" displaytype="normal" edittype="none" style="align:center;" text="삭제여부"/>
                <Cell col="2" text="분류"/>
                <Cell col="3" text="하위분류"/>
                <Cell col="4" text="콘텐츠 코드"/>
                <Cell col="5" text="콘텐츠 제목"/>
                <Cell col="6" text="상영시간"/>
                <Cell col="7" text="전용병원"/>
                <Cell col="8" text="등록일"/>
                <Cell col="9" text="수정일"/>
              </Band>
              <Band id="body">
                <Cell/>
                <Cell col="1" displaytype="combo" edittype="combo" style="align:center;" text="bind:delyn" combodataset="ds_init_del" combocodecol="cdid" combodatacol="cdnm"/>
                <Cell col="2" displaytype="combo" edittype="combo" style="align:center;" text="bind:gubuncd" combodataset="ds_init_M0770list" combocodecol="cdid" combodatacol="cdnm" combodisplayrowcount="10"/>
                <Cell col="3" displaytype="combo" edittype="combo" style="align:center;" text="bind:subgubuncd" combodataset="ds_init_M0771list" combocodecol="cdid" combodatacol="cdnm" combodisplayrowcount="20"/>
                <Cell col="4" displaytype="text" edittype="text" style="align:center;" text="bind:contentscd"/>
                <Cell col="5" displaytype="text" edittype="text" style="padding:0 0 0 5;" text="bind:contentsnm"/>
                <Cell col="6" displaytype="text" edittype="mask" style="align:center;" text="bind:viewingtime" mask="##:##"/>
                <Cell col="7" displaytype="checkbox" edittype="checkbox" text="bind:privatehospcd" expr="expr:(privatehospcd == &quot;Y&quot; || privatehospcd == 1) ? 1 : 0"/>
                <Cell col="8" displaytype="date" edittype="date" text="bind:regdt"/>
                <Cell col="9" displaytype="date" edittype="date" text="bind:updatedt"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Button id="btn_add" taborder="2" text="행추가" onlbuttondown="btn_patient_new_onlbuttondown" class="btn2" position="absolute 831 64 886 84" anchor="top right" onclick="btn_add_onclick"/>
        <Button id="btn_del" taborder="3" text="행삭제" onlbuttondown="btn_patient_del_onlbuttondown" class="btn2" position="absolute 888 64 943 84" anchor="top right" onclick="btn_del_onclick"/>
        <Button id="btn_save" taborder="4" text="저장" onlbuttondown="btn_patient_save_onlbuttondown" class="btn4" position="absolute 945 64 1000 84" anchor="top right" onclick="btn_save_onclick"/>
        <Button id="btn_select" taborder="5" text="선택" class="btn4" position="absolute 945 64 1000 84" anchor="top right" onclick="btn_select_onclick" visible="false"/>
        <Button id="btn_excel" taborder="6" text="엑셀입력" position="absolute 753 64 829 84" class="btn7" onclick="btn_excel_onclick"/>
      </Layout>
    </Layouts>
    <Objects>
      <Dataset id="ds_init_M0770list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_M0771list" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_search" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="gubuncd" type="STRING" size="256"/>
          <Column id="subgubuncd" type="STRING" size="256"/>
          <Column id="contentscd" type="STRING" size="256"/>
          <Column id="contentsnm" type="STRING" size="256"/>
          <Column id="delyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_main_hichartlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_main_hichartlist_oncolumnchanged">
        <ColumnInfo>
          <Column id="instcd" type="STRING" size="256"/>
          <Column id="gubuncd" type="STRING" size="256"/>
          <Column id="subgubuncd" type="STRING" size="256"/>
          <Column id="contentscd" type="STRING" size="256"/>
          <Column id="org_contentscd" type="STRING" size="256"/>
          <Column id="contentsnm" type="STRING" size="256"/>
          <Column id="viewingtime" type="STRING" size="256"/>
          <Column id="privatehospcd" type="STRING" size="256"/>
          <Column id="regdt" type="STRING" size="256"/>
          <Column id="updatedt" type="STRING" size="256"/>
          <Column id="delyn" type="STRING" size="256"/>
          <Column id="validfromdd" type="STRING" size="256"/>
          <Column id="validtodd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_send_save" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="status" type="STRING" size="256"/>
          <Column id="gubuncd" type="STRING" size="256"/>
          <Column id="subgubuncd" type="STRING" size="256"/>
          <Column id="contentscd" type="STRING" size="256"/>
          <Column id="contensnm" type="STRING" size="256"/>
          <Column id="delyn" type="STRING" size="256"/>
          <Column id="validfromdd" type="STRING" size="256"/>
          <Column id="validtodd" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_init_del" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="cdid">N</Col>
            <Col id="cdnm"> </Col>
          </Row>
          <Row>
            <Col id="cdid">Y</Col>
            <Col id="cdnm">삭제</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_excel" firefirstcount="0" firenextcount="0" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="new" type="STRING" size="256"/>
          <Column id="gubunnm" type="STRING" size="256"/>
          <Column id="subgubunnm" type="STRING" size="256"/>
          <Column id="contentscd" type="STRING" size="256"/>
          <Column id="contentsnm" type="STRING" size="256"/>
          <Column id="viewingtime" type="STRING" size="256"/>
          <Column id="regdt" type="STRING" size="256"/>
          <Column id="updatedt" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_excel_file" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="filenm" type="STRING" size="256" sumtext="파일명"/>
          <Column id="filedata" type="BLOB" size="256" sumtext="파일데이터"/>
          <Column id="filesize" type="STRING" size="256" sumtext="파일크기"/>
          <Column id="filetype" type="STRING" size="256" sumtext="파일종류"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item0" compid="grp_sea.Combo_gubun" propid="value" datasetid="ds_send_search" columnid="gubuncd"/>
      <BindItem id="item1" compid="grp_sea.Combo_subgubun" propid="value" datasetid="ds_send_search" columnid="subgubuncd"/>
      <BindItem id="item2" compid="grp_sea.Edit_code" propid="value" datasetid="ds_send_search" columnid="contentscd"/>
      <BindItem id="item3" compid="grp_sea.Edit_title" propid="value" datasetid="ds_send_search" columnid="contentsnm"/>
      <BindItem id="item4" compid="grp_sea.CheckBox_del" propid="value" datasetid="ds_send_search" columnid="delyn"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include "com_commonxp::comm_main.xjs";

var oOpener;


function SPZMH00200_HiChartList_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);
}

function SPZMH00200_HiChartList_onload(obj:Form, e:LoadEventInfo)
{
	grdf_initGrid(Grid_hichartlist);
	
	oOpener = this.opener;
	
	if(!utlf_isNull(oOpener)) {
		//SPMQP01400_STEP처방관리에서 오픈한 경우 입력, 수정, 삭제 권한 없앰
		if(!utlf_isNull(oOpener.frmf_getParameter("parentid"))){
			if(oOpener.frmf_getParameter("parentid") == "SPMQP01400"){
				btn_add.visible = false;
				btn_del.visible = false;
				btn_save.visible = false;
				grp_sea.caption04.visible = false;
				grp_sea.CheckBox_del.visible = false;
				btn_select.visible = true;
				btn_excel.visible = false;
			}
		}
	}
	
	//row 상태정보 셋팅
	grdf_setRowTypeIcon(Grid_hichartlist, 0);
	
	//공통코드 셋팅
	appf_getCodeList([{dsNm: "ds_init_M0770list", cdGrpId: "M0770"}
					,{dsNm: "ds_init_M0771list", cdGrpId: "M0771"}
					], false);


	//전체 추가
	dsf_addDsItem(ds_init_M0770list, "cdid", "cdnm", "전체", "", "above");
	dsf_addDsItem(ds_init_M0771list, "cdid", "cdnm", "전체", "", "above");
	
	//분류와 하위분류의 기본값을 전체로  설정
	grp_sea.Combo_gubun.index = 0;
	grp_sea.Combo_subgubun.index = 0;
	
	//삭제포함 여부 기본값으로 N 설정
	ds_send_search.setColumn(0, "delyn" , "N");
	
	
	// 화면 로딩시 자동으로 첫 조회
	grp_sea.btn_search.click();
}

function grp_sea_btn_search_onclick(obj:Button,  e:ClickEventInfo)
{
	ds_init_M0771list.filter("");
	
	var oParam = {};
		oParam.id          = "TRZMH00100";
		oParam.service     = "hichartapp.HichartListMngt";
		oParam.method      = "reqGetHichartList";
		oParam.inds        = "req=ds_send_search";
		oParam.outds       = "ds_main_hichartlist=result";
		oParam.async       = true;

	tranf_submit(oParam);
}

//행추가
function btn_add_onclick(obj:Button,  e:ClickEventInfo)
{
	var nRow = ds_main_hichartlist.addRow();//입력 행 추가
	
	//실제 하이차트 목록에는 유효일이 없으므로 임의로 시작일은 오늘, 종료일은 99991231 설정
	ds_main_hichartlist.setColumn(nRow, "validfromdd" , utlf_getCurrentDate());
	ds_main_hichartlist.setColumn(nRow, "validtodd" , "99991231");
	
	Grid_hichartlist.setCellPos(1);
	Grid_hichartlist.setFocus();
}


//행삭제
function btn_del_onclick(obj:Button,  e:ClickEventInfo)
{
	var selectedRow = grdf_getSelectedRows(Grid_hichartlist);
	if(selectedRow.length < 0){
		return;
	}
	
	var arrPosition = new Array();
	var iIndex = 0;
	var jIndex = 0;
	for(iIndex = selectedRow.length - 1 ; iIndex >= 0 ; iIndex--){
		var iRow = selectedRow[iIndex];
		var status = ds_main_hichartlist.getRowType(iRow);
		
		//2 : 추가된 행의 상태
		if(status == 2){
			ds_main_hichartlist.deleteRow(iRow);
		}else {
			arrPosition[jIndex++] = iRow;
		}
	}
	
	if(arrPosition.length > 0){
		grdf_setStatus(Grid_hichartlist, "d", arrPosition);
	}
}

function btn_save_onclick(obj:Button,  e:ClickEventInfo)
{
	var oDsUpdate = grdf_getGridUpdateData(Grid_hichartlist);
	
	if(oDsUpdate.rowcount < 1){
		sysf_messageBox("입력", "E013");// 입력, 수정, 삭제 데이터가 없으면 "입력된 데이터가 없습니다."는 메시지 출력
		return;
	}
	
	grdf_setStatusColumn(oDsUpdate, "status");//각 행의 status에 rowType 값에 따라 i, u, d로 업데이트 시켜줌
	ds_send_save.copyData(oDsUpdate, true);
	
	for(var iIndex = 0 ; iIndex < ds_send_save.rowcount ; iIndex++)	{
		if(utlf_isNull(ds_send_save.getColumn(iIndex, "gubuncd"))){
			sysf_messageBox("분류 항목을 입력하여 주십시오.", "C999");
			return;
		}
		
		if(utlf_isNull(ds_send_save.getColumn(iIndex, "subgubuncd"))){
			sysf_messageBox("하위분류 항목을 입력하여 주십시오.", "C999");
			return;
		}
		
		if(utlf_isNull(ds_send_save.getColumn(iIndex, "contentscd"))){
			sysf_messageBox("콘텐츠 코드 항목을 입력하여 주십시오.", "C999");
			return;
		}
		
		if(utlf_isNull(ds_send_save.getColumn(iIndex, "contentsnm"))){
			sysf_messageBox("콘텐츠 제목 항목을 입력하여 주십시오.", "C999");
			return;
		}
		
		if(utlf_isNull(ds_send_save.getColumn(iIndex, "viewingtime"))){
			sysf_messageBox("상영시간 항목을 입력하여 주십시오.", "C999");
			return;
		}
		
		if(utlf_isNull(ds_send_save.getColumn(iIndex, "regdt"))){
			sysf_messageBox("등록일 항목을 입력하여 주십시오.", "C999");
			return;
		}
		
		if(utlf_isNull(ds_send_save.getColumn(iIndex, "updatedt"))){
			sysf_messageBox("수정일 항목을 입력하여 주십시오.", "C999");
			return;
		}
	}
	
	var oParam = {};
		oParam.id          = "TXZMH00100";
		oParam.service     = "hichartapp.HichartListMngt";
		oParam.method      = "reqSetHichartList";
		oParam.inds        = "req=ds_send_save";
		oParam.async       = false;
		//oParam.callback    = "cf_TXMNP00361";

	tranf_submit(oParam);

	grp_sea.btn_search.click();
}

function Grid_hichartlist_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	//SPMQP01400_STEP처방관리에서 오픈한 경우 그리드 더블 클릭 시 값 넘겨줌
	if(!utlf_isNull(oOpener.frmf_getParameter("parentid"))){
		if(oOpener.frmf_getParameter("parentid") == "SPMQP01400"){
			trace(obj.selectendrow);
			trace(ds_main_hichartlist.getColumn(obj.selectendrow, "contentscd"));
			oOpener.frmf_setParameter("contentscd", ds_main_hichartlist.getColumn(obj.selectendrow, "contentscd"));
		}
	}
}

//선택 버튼 처리 : 부모에게 선택한 값 넘김
function btn_select_onclick(obj:Button,  e:ClickEventInfo)
{
	//SPMQP01400_STEP처방관리에서 오픈한 경우 선택 버튼에 대한 이벤트 처리
	if(!utlf_isNull(oOpener.frmf_getParameter("parentid"))){
		if(oOpener.frmf_getParameter("parentid") == "SPMQP01400"){	
			var sMsg = "contentscd▦contentnm▩";
			
			var selectedRow = grdf_getSelectedRows(Grid_hichartlist);
			if(selectedRow.length < 0){
				sysf_messageBox("선택된 항목이 없습니다.", "C999")
				return;
			}
				
			for(var iIndex = selectedRow.length - 1 ; iIndex >= 0 ; iIndex--){
				var iRow = selectedRow[iIndex];
				sMsg += utlf_transNullToEmpty(ds_main_hichartlist.getColumn(iRow, "contentscd")) + "▦"		
				     +  utlf_transNullToEmpty(ds_main_hichartlist.getColumn(iRow, "contentsnm")) + "▩"
			}
					
			opener.frmf_setParameter("SPMMP05000_Return", sMsg);
			
			this.close();
		}
	}
}

function Grid_hichartlist_oncloseup(obj:Grid, e:GridEditEventInfo)
{
	if(e.col == 2) {
		ds_main_hichartlist.setColumn(e.row, "subgubuncd", "");
		
		ds_init_M0771list.filter("cdid == '' || cdval == " + e.value);
	}
}

function ds_main_hichartlist_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "privatehospcd")
		obj.setColumn(e.row, e.columnid, (e.newvalue == "Y" || e.newvalue == 1) ? "Y" : "");
}

function btn_excel_onclick(obj:Button,  e:ClickEventInfo)
{
	var fd  = new FileDialog;
	var objVFileList = fd.open("업로드 할 파일을 선택하여 주십시오.", FileDialog.MULTILOAD);
	
	if(utlf_isNull(objVFileList)) return;
	
	var fileCnt = objVFileList.length;
	
	if(fileCnt < 2) {
		sysf_messageBox("'하이차트 콘텐츠 목록'과 '전용 콘텐츠 목록' 둘 다 한꺼번에 선택해주세요.\n\n예)000000_hichart.xls, 000000_knuh.xls", "E999");
		return;
	} else if(fileCnt > 2) {
		sysf_messageBox("'하이차트 콘텐츠 목록'과 '전용 콘텐츠 목록' 두 개만 선택해주세요.\n\n예)000000_hichart.xls, 000000_knuh.xls", "E999");
		return;
	}
	
	//선택한 파일이 저장버튼을 눌렀을때 저장이 되게 하기 위해 파일 저장 인스턴스에 파일주소를 저장해 둔다.
	ds_excel_file.clearData();
	
	ds_excel_file.enableevent = false;
	for(var i = 0; i < fileCnt; i++) {
		ds_excel_file.addRow();
		var objFileinfo = dsf_writeFileToDs(objVFileList[i], ds_excel_file, i, "filedata");            
		ds_excel_file.setColumn(i, "filenm",   objFileinfo.filename);
		ds_excel_file.setColumn(i, "filesize", objFileinfo.filesize);
		ds_excel_file.setColumn(i, "filetype", objFileinfo.filetype);
		
		var filename    = objFileinfo.filename.split('.')[0];
		var fileexttype = objFileinfo.filename.split('.')[1];
		
		if(filename.indexOf("_hichart") < 0 && filename.indexOf("_knuh") < 0 && filename.indexOf("_knuch") < 0) {
			sysf_messageBox("설명처방 콘텐츠 목록 파일이 아닙니다. 다른 파일을 선택하여 주세요.", "E999");
			return;
		}
		
		if(fileexttype != "xls" && fileexttype != "xlsx") {
			sysf_messageBox("설명처방 콘텐츠 목록 파일이 아닙니다. 다른 파일을 선택하여 주세요.", "E999");
			return;
		}
	}
	ds_excel_file.enableevent = true;
	
	if(sysf_messageBox("'" + ds_excel_file.getColumn(0, "filenm") + "', '" + ds_excel_file.getColumn(1, "filenm") + "'\n\n위 두 파일로 입력 하시겠습니까?", "Q999") == 6) {
		var oParam = {};
			oParam.id          = "TRZMH00500";
			oParam.service     = "hichartapp.HichartListMngt";
			oParam.method      = "reqUploadHichartList";
			oParam.inds        = "req=ds_excel_file";
			//oParam.outds       = "ds_main_hichartlist=result";
			oParam.async       = false;

		tranf_submit(oParam);
		
		this.reload();
	}
}
]]></Script>
  </Form>
</FDL>