GaramX

Sheet을 javascript로 생성하자

function f_init_answer(ans, data){
	if( ans == undefined )
		ans = new Map();
	if( ans.has(data.opq_qust_item_id) ){
	} else {
		data["myOrder"] = ans.size;
		ans.set( data.opq_qust_item_id, data );
	}
}
function f_add_answer(ans, data){
	if( ans == undefined )
		alert("f_add_answer:error:ans가없습니다.");
	if( ans.has(data.opq_qust_item_id) ){
		let obj = ans.get(data.opq_qust_item_id);
		if( data.opq_ansr_item_id > 0 ) {
			if( obj["col_" + data.opq_ansr_item_id] == undefined )
				obj["col_" + data.opq_ansr_item_id] = 0;
			obj["col_" + data.opq_ansr_item_id] += Number(data.opq_cnt);
		}
		if( obj["qust_cnt"] == undefined )
			obj["qust_cnt"] = 0;
		obj["qust_cnt"] += Number(data.qust_cnt);
	} else {
		// console.log("opq_qust_item_id가없습니다." + data.opq_qust_item_id);
		// 없으면 주관식인가?
	}
}
function myMakeSheet(){
	let answerCol = new Map(); // 설문답변				
	let mAnswer = new Map();  // 설문문항
 
 
	for(let i=0; i < bindingObject["ME_OPQ0009_03"].length; i++){
		let data = bindingObject["ME_OPQ0009_03"][i];
		answerCol.set(data.opq_ansr_item_id, data);
		f_init_answer(mAnswer, data); // 설문문항준비
	};
	var tmpHeaderRow1 = '번호|상태|삭제|문항|응답자';
	/** BodyRow 기본 컬럼 **/
	var bodyRow = [{Type:"Seq", Width:40, SaveName:"_seq", Align:"Right"},
	               {Type:"Status", Width:60, SaveName:"sStatus", Align:"Center", Hidden:true},
	               {Type:"DelCheck", Width:40, SaveName:"sDelete", Align:"Center", Hidden:true},
	               {Type:"Text",SaveName:"qust_type_nm", Width:300, Align:"Left"},
	               {Type:"Text",SaveName:"qust_cnt", Width:100, Align:"Center", Hidden:true}
				  ];
	for (const [key, value] of answerCol.entries()) {
		  tmpHeaderRow1 += "|" + value.ansr_item_nm;
		  bodyRow.push({Type:"Text",SaveName:"col_" + value.opq_ansr_item_id, Width:100, Align:"Center"});
	}
 
	//var sheet = mySheet3; // 이렇게하면 안됨... 이유는 모름.
	var headers = [{ Text:tmpHeaderRow1, Align:"center"}];
	var info = { Sort:0,ColMove:0,ColResize:1,HeaderCheck:0 };
 
	mySheet3.Reset();
	mySheet3.SetConfig({SearchMode:1,Page:100,FrozenCol:4,MergeSheet:msHeaderOnly});
	mySheet3.InitHeaders( headers, info );
	mySheet3.InitColumns( bodyRow );
 
	//console.log(bodyRow);
 
	// 답변결과를 넣어주자.
	bindingObject['ME_OPQ0009_05'].forEach(function(data){
		f_add_answer(mAnswer, data);
	});
	//console.log(mAnswer);
 
	var myData = [];
	// myData준비하자
	for (const [key, value] of mAnswer.entries()) {
		myData[value.myOrder] = value;
	}
	// myData준비완료
	//console.log(myData);
 
	$('div[dataProvider="ME_OPQ0009_05"]').triggerHandler("bindData", [ myData ]);
}