-- ibSHEET8 호출 시 ajax
function loadData1()
{
// 목록
var _param =
{
"mode" : "list"
, "mad_id" : ""
, "mad_password" : ""
};
var param = JSON.stringify(_param);
var p_url = "/ddd";
//sheet.doSearch("/ooo", ""); // 안됨!
/*
-- API (class)
.....
@PostMapping("/ooo")
public Object ooo(code_vo code) {
return codeService.code_list_tree_json(code);
}
-- Service (class)
@Service
.....
public List<code_vo> code_list_tree_json(code_vo code) {
return codeMapper.code_list_tree_json(code);
}
-- Mapper (interface)
@Mapper
.....
public List<code_vo> code_list_tree_json ( code_vo code );
-- myBatis (xml)
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.blz.dia.code.CodeMapper">
<select id="code_list_tree_json" resultType="code_vo">
SELECT cce_num
, cce_primary
, cce_hname
, cce_ename
, cce_jname
FROM con_element
ORDER BY cce_position ASC
</select>
*/
$.ajax({
type : "post"
, url : p_url
, data : ""
, cache : false
, data : param
, success: function (rtnData) {
console.log(rtnData);
// IBsheet's json return function
sheet.loadSearchData(rtnData);
},
error : function(request, status, error) {
console.log("실패!");
console.log("loading error:" + request.status + " / code : " + request.statusText + " / message : " + request.responseText);
return false;
}
});
}
-- IBsheet8 sheet 기본 설정
///////////////////////////////////////////////////////////////////////////////////
// sheet
///////////////////////////////////////////////////////////////////////////////////
var ib = ib||{};
ib = {
//시트 초기화 구문
'init':{
//공통기능 설정 부분
"Cfg": {
"SearchMode": 0,
"MaxPages": 3,
"SuppressMessage": 3,
"HeaderMerge": 3,
"FitWidth": false
},
//틀고정 좌측 컬럼 설정
"LeftCols": [
{"Type": "Int","Width": 50,"Align": "Center","Name": "SEQ"}
],
//중앙(메인) 컬럼 설정
"Cols": [
{ "Name": "cce_num","Type": "Int","hidden": 1},
{"Header": "상위번호","Name": "cce_primary" ,"Type": "Int" ,"Width": "100","Align": "Center","CanEdit": 1},
{"Header": "한글명","Name": "cce_hname" ,"Type": "Text","Width": "100","Align": "Center","CanEdit": 1, "RelWidth":1},
{"Header": "영문명","Name": "cce_ename" ,"Type": "Text","Width": "100","Align": "Center","CanEdit": 1},
{"Header": "일어명","Name": "cce_jname" ,"Type": "Text","Width": "100","Align": "Center","CanEdit": 1},
]
},
//시트 이벤트
'event':{
},
//시트객체 생성
'create':function () {
var options = this.init;
options.Events = this.event;
IBSheet.create({
id: 'sheet', // 생성할 시트의 id
el: 'sheetDiv', // 시트를 생성할 Dom 객체 및 id
options: options, // 생성될 시트의 속성
data: this.data // 생성될 시트의 정적데이터
});
},
//화면 기능
'sampleBtn':function () {
},
//조회 데이터
'data': loadData1()
}
ib.create();
|