rpt_tpl_pre_handle.js 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743
  1. /**
  2. * Created by Tony on 2017/12/26.
  3. */
  4. const sort_types = ["normal", "tree", "accord_to_parent", "self_define"];
  5. const condition_types = ["==", "===", ">", ">=", "<", "<=", "!=", "in", "not in"];
  6. const pre_handle_data_objects = ["bills", "ration", "ration_glj"];
  7. const pre_handle_data_objects_name = ["清单", "定额", "定额工料机"];
  8. const exposed_bills_properties = [
  9. {Name: "清单_ID", Title: "", Key: "ID", Order: "ascend"},
  10. {Name: "清单_所属项目ID", Title: "", Key: "projectID", Order: "ascend"},
  11. {Name: "清单_项目编码", Title: "", Key: "code", Order: "ascend"},
  12. {Name: "清单_项目名称", Title: "", Key: "name", Order: "ascend"},
  13. {Name: "清单_项目特征", Title: "", Key: "itemCharacterText", Order: "ascend"},
  14. {Name: "清单_计量单位", Title: "", Key: "unit", Order: "ascend"},
  15. {Name: "清单_工程量", Title: "", Key: "quantity", Order: "ascend"},
  16. {Name: "清单_综合单价", Title: "", Key: "unitFee", Order: "ascend"},
  17. {Name: "清单_综合合价", Title: "", Key: "totalFee", Order: "ascend"},
  18. {Name: "清单_暂估价", Title: "", Key: "tenderUnitFee", Order: "ascend"}
  19. ];
  20. const exposed_ration_properties = [
  21. {Name: "定额_工程内部ID", Title: "", Key: "ID", Order: "ascend"},
  22. {Name: "定额_所属清单ID", Title: "", Key: "billsItemID", Order: "ascend"},
  23. {Name: "定额_所属项目ID", Title: "", Key: "projectID", Order: "ascend"},
  24. {Name: "定额_编号", Title: "", Key: "code", Order: "ascend"},
  25. {Name: "定额_项目名称", Title: "", Key: "caption", Order: "ascend"},
  26. {Name: "定额_单位", Title: "", Key: "unit", Order: "ascend"},
  27. {Name: "定额_数量", Title: "", Key: "quantity", Order: "ascend"},
  28. {Name: "定额_人工费", Title: "", Key: "labour", Order: "ascend"},
  29. {Name: "定额_材料费", Title: "", Key: "material", Order: "ascend"},
  30. {Name: "定额_机械费", Title: "", Key: "machine", Order: "ascend"},
  31. {Name: "定额_机上人工费", Title: "", Key: "machineLabour", Order: "ascend"},
  32. {Name: "定额_人工费调整", Title: "", Key: "adjustLabour", Order: "ascend"},
  33. {Name: "定额_材料费调整", Title: "", Key: "'adjustMaterial'", Order: "ascend"},
  34. {Name: "定额_机械费调整", Title: "", Key: "adjustMachine", Order: "ascend"},
  35. {Name: "定额_机上人工费调整", Title: "", Key: "adjustMachineLabour", Order: "ascend"},
  36. {Name: "定额_人工价差", Title: "", Key: "labourDiff", Order: "ascend"},
  37. {Name: "定额_材料价差", Title: "", Key: "materialDiff", Order: "ascend"},
  38. {Name: "定额_机械价差", Title: "", Key: "machineDiff", Order: "ascend"},
  39. {Name: "定额_风险费用", Title: "", Key: "risk", Order: "ascend"}
  40. // {Name: "定额_管理费率", Title: "", Key: ""}
  41. ];
  42. const exposed_prj_glj_properties = [
  43. {Name: "工料机_ID", Title: "", Key: "ID"},
  44. {Name: "工料机_所属定额ID", Title: "", Key: "rationID", Order: "ascend"},
  45. {Name: "工料机_所属清单ID", Title: "", Key: "billsItemID", Order: "ascend"},
  46. {Name: "工料机_所属工程ID", Title: "", Key: "projectID", Order: "ascend"},
  47. {Name: "工料机_代码", Title: "", Key: "code", Order: "ascend"},
  48. {Name: "工料机_名称", Title: "", Key: "name", Order: "ascend"},
  49. {Name: "工料机_单位", Title: "", Key: "unit", Order: "ascend"},
  50. {Name: "工料机_数量", Title: "", Key: "quantity", Order: "ascend"}
  51. ];
  52. const exposed_properties_arr = [exposed_bills_properties, exposed_ration_properties, exposed_prj_glj_properties];
  53. const IDMark_Switch = "_switch",
  54. IDMark_Icon = "_ico",
  55. IDMark_Span = "_span",
  56. IDMark_Input = "_input",
  57. IDMark_Check = "_check",
  58. IDMark_Edit = "_edit",
  59. IDMark_Remove = "_remove",
  60. IDMark_Ul = "_ul",
  61. IDMark_A = "_a";
  62. let preHandleObj = {
  63. treeObj: null,
  64. typeTreeObj: null,
  65. currentNode: null,
  66. iniTree: function(rptTpl) {
  67. let me = this;
  68. me.buildData(rptTpl);
  69. },
  70. buildData: function(rptTpl) {
  71. let me = this, handles = [];
  72. if (rptTpl[JV.NODE_MAP_DATA_HANDLE_INFO]) {
  73. for (let item of rptTpl[JV.NODE_MAP_DATA_HANDLE_INFO]) {
  74. let hd = {Name: "预处理环节"};
  75. me.private_copy_node(item, hd);
  76. me.private_set_title(hd);
  77. hd.Operations = []; //考虑到用户可能会换来换去,这样会有冗余的属性出现
  78. handles.push(hd);
  79. }
  80. }
  81. me.treeObj = $.fn.zTree.init($("#pre_handle_data_info_reversed"), preHandleSetting, handles);
  82. },
  83. build_handle_data_selection: function() {
  84. let sel = $("#select_mapping_data"), sel2 = $("#select_mapping_data_for_sort_type");
  85. for (let i = 0; i < pre_handle_data_objects.length; i++) {
  86. sel2.append("<option value='" + pre_handle_data_objects[i] + "'>" + pre_handle_data_objects_name[i] + "</option>");
  87. sel.append("<option value='" + pre_handle_data_objects[i] + "'>" + pre_handle_data_objects_name[i] + "</option>");
  88. }
  89. },
  90. buildTypeData: function () {
  91. let me = this, types = [];
  92. types.push({Name: JV.PROP_HANDLE_TYPE_SORT, Title: ""});
  93. types.push({Name: JV.PROP_HANDLE_TYPE_FILTER, Title: ""});
  94. types.push({Name: JV.PROP_HANDLE_TYPE_SUM, Title: ""});
  95. types.push({Name: JV.PROP_HANDLE_TYPE_ADJUST, Title: ""});
  96. types.push({Name: JV.PROP_HANDLE_TYPE_ADD_DUMMY, Title: ""});
  97. // types.push({Name: "纯手工填写", Title: ""});
  98. me.typeTreeObj = $.fn.zTree.init($("#pre_handle_type_reversed"), preHandleTypeSetting, types);
  99. me.setDisabledBandSelect([0,1,2,3,4]);
  100. me.build_handle_data_selection();
  101. },
  102. setDisabledBandSelect: function(disabledIdxArr) {
  103. let me = this;
  104. if (me.typeTreeObj) {
  105. let nodes = me.typeTreeObj.getNodes();
  106. for (let idx = 0; idx < nodes.length; idx++) {
  107. if (disabledIdxArr.indexOf(idx) >= 0) {
  108. me.typeTreeObj.setChkDisabled(nodes[idx], true, true, true);
  109. } else {
  110. me.typeTreeObj.setChkDisabled(nodes[idx], false, true, true);
  111. }
  112. }
  113. }
  114. },
  115. addNewNode: function(nodeType) {
  116. let me = this, item = null, preHandleType = nodeType;
  117. if (!nodeType) {
  118. preHandleType = JV.PROP_HANDLE_TYPE_SORT;
  119. }
  120. switch (nodeType) {
  121. case JV.PROP_HANDLE_TYPE_SORT:
  122. item = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "排序方式": "normal", "排序键值集":[]};
  123. break;
  124. case JV.PROP_HANDLE_TYPE_FILTER:
  125. item = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "过滤键值集": []};
  126. break;
  127. case JV.PROP_HANDLE_TYPE_SUM:
  128. item = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "分组键值集": [], "统计键值集":[]};
  129. break;
  130. case JV.PROP_HANDLE_TYPE_ADJUST:
  131. item = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "数据调整集":[]};
  132. break;
  133. case JV.PROP_HANDLE_TYPE_ADD_DUMMY:
  134. item = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "Dummy数据集":[]};
  135. break;
  136. default:
  137. item = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": "排序", "排序方式": "normal", "排序键值集":[]};
  138. break;
  139. }
  140. me.private_set_title(item);
  141. me.treeObj.addNodes(null, -1, [item], true);
  142. },
  143. private_change_node_by_type: function(handleType, item) {
  144. let preHandleType = handleType;
  145. if (!handleType) {
  146. preHandleType = JV.PROP_HANDLE_TYPE_SORT;
  147. }
  148. item[JV.PROP_HANDLE_TYPE] = preHandleType;
  149. switch (handleType) {
  150. case JV.PROP_HANDLE_TYPE_SORT:
  151. item[JV.PROP_SORT_TYPE] = "normal";
  152. item[JV.PROP_SORT_KEYS] = [];
  153. break;
  154. case JV.PROP_HANDLE_TYPE_FILTER:
  155. item[JV.PROP_FILTER_KEYS] = [];
  156. break;
  157. case JV.PROP_HANDLE_TYPE_SUM:
  158. item[JV.PROP_SUM_GROUP_KEYS] = [];
  159. item[JV.PROP_SUM_SUM_KEYS] = [];
  160. break;
  161. case JV.PROP_HANDLE_TYPE_ADJUST:
  162. item[JV.PROP_ADJUST_COLLECTION] = [];
  163. break;
  164. case JV.PROP_HANDLE_TYPE_ADD_DUMMY:
  165. item[JV.PROP_DUMMY_COLLECTION] = [];
  166. break;
  167. default:
  168. item[JV.PROP_HANDLE_TYPE] = JV.PROP_HANDLE_TYPE_SORT;
  169. item[JV.PROP_SORT_TYPE] = "normal";
  170. item[JV.PROP_SORT_KEYS] = [];
  171. break;
  172. }
  173. // return rst;
  174. },
  175. private_copy_node: function(src, dest) {
  176. let me = this;
  177. dest[JV.PROP_DATA_KEY] = src[JV.PROP_DATA_KEY];
  178. dest[JV.PROP_HANDLE_TYPE] = src[JV.PROP_HANDLE_TYPE];
  179. if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_SORT) {
  180. preHandleSortObj.copyNode(src, dest);
  181. } else if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_FILTER) {
  182. preHandleFilterObj.copyNode(src, dest);
  183. } else if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_SUM) {
  184. preHandleSummaryObj.copyNode(src, dest);
  185. } else if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_ADJUST) {
  186. preHandleAdjustObj.copyNode(src, dest);
  187. } else if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_ADD_DUMMY) {
  188. preHandleAddDummyObj.copyNode(src, dest);
  189. }
  190. },
  191. private_set_title: function(node) {
  192. let nameStr = node[JV.PROP_NAME], idx = nameStr.indexOf("(");
  193. if (idx >= 0) {
  194. nameStr = nameStr.slice(0, idx);
  195. }
  196. node[JV.PROP_NAME] = nameStr + "(" + node[JV.PROP_HANDLE_TYPE] + ")";
  197. node.Title = "映射数据对象:" + node[JV.PROP_DATA_KEY] + " | " + node[JV.PROP_HANDLE_TYPE];
  198. },
  199. refreshByNode: function(treeNode) {
  200. let me = preHandleObj;
  201. if (me.typeTreeObj) {
  202. let nodes = me.typeTreeObj.getNodes();
  203. let typeNode = null;
  204. for (let node of nodes) {
  205. if (treeNode[JV.PROP_NAME].indexOf(node[JV.PROP_NAME]) > 0) {
  206. me.typeTreeObj.checkNode(node, true, false, false);
  207. typeNode = node;
  208. break;
  209. }
  210. }
  211. let md = $("#select_mapping_data")[0];
  212. for (let i = 0; i < md.children.length; i++) {
  213. if (treeNode[JV.PROP_DATA_KEY] === md.children[i].value) {
  214. md.selectedIndex = i;
  215. break;
  216. }
  217. }
  218. if (typeNode) {
  219. me.hide_all_dom();
  220. $("#div_pre_handle_data")[0].style.display = "";
  221. if (typeNode[JV.PROP_NAME] === "排序") {
  222. preHandleSortObj.refresh_node();
  223. } else if (typeNode[JV.PROP_NAME] === "过滤") {
  224. preHandleFilterObj.refresh_node();
  225. } else if (typeNode[JV.PROP_NAME] === "合计") {
  226. preHandleSummaryObj.refresh_node();
  227. } else if (typeNode[JV.PROP_NAME] === "数据调整") {
  228. preHandleAdjustObj.refresh_node();
  229. } else if (typeNode[JV.PROP_NAME] === "增加Dummy数据") {
  230. preHandleAddDummyObj.refresh_node();
  231. }
  232. }
  233. }
  234. },
  235. hide_all_dom: function() {
  236. $("#div_pre_handle_data")[0].style.display = "none";
  237. $("#div_sort_type")[0].style.display = "none";
  238. $("#div_sort_type_normal")[0].style.display = "none";
  239. $("#div_filter_type")[0].style.display = "none";
  240. $("#div_summary_type")[0].style.display = "none";
  241. $("#div_adjust_type")[0].style.display = "none";
  242. $("#div_add_dummy_type")[0].style.display = "none";
  243. $("#div_sort_type_according_to_parent")[0].style.display = "none";
  244. $("#div_sort_type_parent_data")[0].style.display = "none";
  245. },
  246. onPreHandleClick: function(event,treeId,treeNode) {
  247. //点击预处理环节 节点
  248. let me = preHandleObj;
  249. me.currentNode = treeNode;
  250. me.setDisabledBandSelect([2,3,4]);
  251. // me.setDisabledBandSelect([]);
  252. me.refreshByNode(treeNode);
  253. },
  254. onTypeClick: function(event,treeId,treeNode) {
  255. //选择预处理类型(排序、过滤。。。)
  256. let me = preHandleObj;
  257. if (me.currentNode) {
  258. // me.currentNode[JV.PROP_HANDLE_TYPE] = treeNode[JV.PROP_NAME];
  259. me.private_change_node_by_type(treeNode[JV.PROP_NAME], me.currentNode);
  260. me.private_set_title(me.currentNode);
  261. me.treeObj.updateNode(me.currentNode, false);
  262. me.refreshByNode(me.currentNode);
  263. }
  264. },
  265. onChangeDataMappingObj: function(dom, oprType) {
  266. //更改(或选择)预处理环节中的 数据依据(就是说报表想预处理什么数据)
  267. let me = preHandleObj;
  268. if (oprType === "top") {
  269. preHandleSortObj.childTreeObj = $.fn.zTree.init($("#child_sorting_keys"), sortingKeysSetting, exposed_properties_arr[dom.selectedIndex]);
  270. preHandleSortObj.treeObj = $.fn.zTree.init($("#pre_handle_sort_keys_reversed"), sortingKeysSetting, exposed_properties_arr[dom.selectedIndex]);
  271. preHandleFilterObj.treeObj = $.fn.zTree.init($("#pre_handle_filter_keys_reversed"), filterKeysSetting, exposed_properties_arr[dom.selectedIndex]);
  272. } else if (oprType === "accord_to_parent") {
  273. preHandleSortObj.parentTreeObj = $.fn.zTree.init($("#parent_sorting_keys"), sortingKeysSetting, exposed_properties_arr[dom.selectedIndex]);
  274. }
  275. },
  276. onBeforeDrop: function(treeId, treeNodes, targetNode, moveType){
  277. //
  278. },
  279. onBeforeRemove: function(treeId, treeNode){
  280. let rst = true;
  281. if (treeNode.isParent) {
  282. rst = false;
  283. } else {
  284. //
  285. }
  286. return rst;
  287. },
  288. extractTabFields: function (rptTpl) {
  289. let me = this, nodes = me.treeObj.getNodes();
  290. let rst = [];
  291. if (nodes && nodes.length > 0) {
  292. for (let handleObj of nodes) {
  293. switch (handleObj[JV.PROP_HANDLE_TYPE]) {
  294. case JV.PROP_HANDLE_TYPE_SORT:
  295. rst.push(preHandleSortObj.extractTabFields(handleObj));
  296. break;
  297. case JV.PROP_HANDLE_TYPE_FILTER:
  298. rst.push(preHandleFilterObj.extractTabFields(handleObj));
  299. break;
  300. case JV.PROP_HANDLE_TYPE_SUM:
  301. rst.push(preHandleSummaryObj.extractTabFields(handleObj));
  302. break;
  303. case JV.PROP_HANDLE_TYPE_ADJUST:
  304. rst.push(preHandleAdjustObj.extractTabFields(handleObj));
  305. break;
  306. case JV.PROP_HANDLE_TYPE_ADD_DUMMY:
  307. rst.push(preHandleAddDummyObj.extractTabFields(handleObj));
  308. break;
  309. default:
  310. break;
  311. }
  312. }
  313. }
  314. rptTpl[JV.NODE_MAP_DATA_HANDLE_INFO] = rst;
  315. }
  316. };
  317. let preHandleSortObj = {
  318. normalTreeObj: null,
  319. parentTreeObj: null,
  320. childTreeObj: null,
  321. copyNode: function (src, dest) {
  322. dest[JV.PROP_SORT_TYPE] = src[JV.PROP_SORT_TYPE];
  323. switch (sort_types.indexOf(src[JV.PROP_SORT_TYPE])) {
  324. case -1:
  325. //unknown!
  326. break;
  327. case 0 :
  328. //normal
  329. let keys = [];
  330. for (let sortKeyItem of src[JV.PROP_SORT_KEYS]) {
  331. let item = {key: sortKeyItem.key, order: sortKeyItem.order};
  332. keys.push(item);
  333. }
  334. dest[JV.PROP_SORT_KEYS] = keys;
  335. break;
  336. case 1 :
  337. //tree
  338. break;
  339. case 2 :
  340. //according to parent
  341. dest[JV.PROP_PARENT_CHILD_SORT_KEY] = {};
  342. dest[JV.PROP_OTHER_SUB_SORT] = [];
  343. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_DATA_KEY] = src[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_DATA_KEY];
  344. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS] = [];
  345. for (let item of src[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS]) {
  346. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS].push(item);
  347. }
  348. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS] = [];
  349. for (let item of src[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS]) {
  350. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS].push(item);
  351. }
  352. for (let subSort of src[JV.PROP_OTHER_SUB_SORT]) {
  353. let st = {};
  354. st[JV.PROP_SORT_TYPE] = subSort[JV.PROP_SORT_TYPE];
  355. if (subSort[JV.PROP_SORT_TYPE] === "normal") {
  356. st[JV.PROP_SORT_KEYS] = [];
  357. for (let item of subSort[JV.PROP_SORT_KEYS]) {
  358. let di = {key: item.key, order: item.order};
  359. st[JV.PROP_SORT_KEYS].push(di);
  360. }
  361. } else {
  362. //其他暂时不实现,目前没那么复杂
  363. }
  364. }
  365. break;
  366. case 3 :
  367. //self define
  368. break;
  369. default:
  370. break;
  371. }
  372. },
  373. refresh_node: function () {
  374. let me = this;
  375. $("#div_sort_type")[0].style.display = "";
  376. if (preHandleObj.currentNode) {
  377. let sel = $("#select_sort_types")[0];
  378. let idx = -1;
  379. let sortTypeIdx = sort_types.indexOf(preHandleObj.currentNode[JV.PROP_SORT_TYPE]);
  380. sel.selectedIndex = sortTypeIdx;
  381. switch (sortTypeIdx) {
  382. case -1:
  383. //unknown!
  384. break;
  385. case 0 :
  386. //normal
  387. $("#div_sort_type_normal")[0].style.display = "";
  388. idx = pre_handle_data_objects.indexOf(preHandleObj.currentNode[JV.PROP_DATA_KEY]);
  389. me.normalTreeObj = $.fn.zTree.init($("#pre_handle_sort_keys_reversed"), sortingKeysSetting, exposed_properties_arr[idx]);
  390. let nodes = me.normalTreeObj.getNodes();
  391. for (let sortItem of preHandleObj.currentNode[JV.PROP_SORT_KEYS]) {
  392. for (let keyNode of nodes) {
  393. if (sortItem.key === keyNode.Key) {
  394. me.normalTreeObj.checkNode(keyNode, true, false, false);
  395. break;
  396. }
  397. }
  398. }
  399. break;
  400. case 1 :
  401. //tree
  402. //tree排序是我们特有的数据结构方式,与数据结构有关,非common用
  403. break;
  404. case 2 :
  405. //according to parent
  406. $("#div_sort_type_according_to_parent")[0].style.display = "";
  407. $("#div_sort_type_parent_data")[0].style.display = "";
  408. sel = $("#select_mapping_data_for_sort_type")[0];
  409. idx = pre_handle_data_objects.indexOf(preHandleObj.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_DATA_KEY]);
  410. sel.selectedIndex = idx;
  411. me.parentTreeObj = $.fn.zTree.init($("#parent_sorting_keys"), sortingKeysSetting, exposed_properties_arr[idx]);
  412. me.checkupNode(preHandleObj.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS], me.parentTreeObj);
  413. idx = pre_handle_data_objects.indexOf(preHandleObj.currentNode[JV.PROP_DATA_KEY]);
  414. me.childTreeObj = $.fn.zTree.init($("#child_sorting_keys"), sortingKeysSetting, exposed_properties_arr[idx]);
  415. me.checkupNode(preHandleObj.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS], me.childTreeObj);
  416. break;
  417. case 3 :
  418. //self define
  419. break;
  420. default:
  421. break;
  422. }
  423. }
  424. },
  425. checkupNode: function(keysArr, treeObj) {
  426. let nodes = treeObj.getNodes();
  427. for (let key of keysArr) {
  428. for (let node of nodes) {
  429. if (node.Key === key) {
  430. treeObj.checkNode(node, true, false, false);
  431. break;
  432. }
  433. }
  434. }
  435. },
  436. onCheck: function(event,treeId,treeNode) {
  437. let me = preHandleSortObj;
  438. if (treeId.indexOf("parent_sorting_keys") >= 0) {
  439. //preHandleObj.currentNode
  440. } else if (treeId.indexOf("child_sorting_keys") >= 0) {
  441. //
  442. } else {
  443. me.resetNormalSort();
  444. }
  445. },
  446. resetNormalSort: function() {
  447. let me = preHandleSortObj;
  448. let nodes = me.normalTreeObj.getCheckedNodes();
  449. let normalSortKeys = [];
  450. for (let node of nodes) {
  451. let keyObj = {key: node.Key, order: node.Order};
  452. normalSortKeys.push(keyObj);
  453. }
  454. preHandleObj.currentNode[JV.PROP_SORT_KEYS] = normalSortKeys;
  455. },
  456. addDiyDom: function(treeId,treeNode) {
  457. let aObj = $("#" + treeNode.tId + IDMark_A);
  458. let editStr = "<select class='selDemo' id='diySelect_" +treeNode.tId+ "'><option value='ascend'>升序 </option><option value='descend'>降序 </option></select>";
  459. aObj.after(editStr);
  460. let sel = $("#diySelect_" + treeNode.tId);
  461. if (sel) {
  462. sel.bind("change", function(){
  463. treeNode.Order = sel[0].value;
  464. preHandleSortObj.resetNormalSort();
  465. });
  466. }
  467. },
  468. onSortTypeChange: function(dom) {
  469. //排序类型的选择/更改
  470. let me = preHandleObj;
  471. me.hide_all_dom();
  472. $("#div_pre_handle_data")[0].style.display = "";
  473. $("#div_sort_type")[0].style.display = "";
  474. let data_dom = $("#select_mapping_data")[0];
  475. if (dom.selectedIndex === 2) {
  476. $("#div_sort_type_according_to_parent")[0].style.display = "";
  477. $("#div_sort_type_parent_data")[0].style.display = "";
  478. preHandleSortObj.parentTreeObj = $.fn.zTree.init($("#parent_sorting_keys"), sortingKeysSetting, exposed_properties_arr[0]);
  479. preHandleSortObj.childTreeObj = $.fn.zTree.init($("#child_sorting_keys"), sortingKeysSetting, exposed_properties_arr[data_dom.selectedIndex]);
  480. me.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY] = {};
  481. me.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_DATA_KEY] = pre_handle_data_objects[0];
  482. me.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS] = [];
  483. me.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS] = [];
  484. } else if (dom.selectedIndex === 0) {
  485. $("#div_sort_type_normal")[0].style.display = "";
  486. preHandleSortObj.normalTreeObj = $.fn.zTree.init($("#pre_handle_sort_keys_reversed"), sortingKeysSetting, exposed_properties_arr[data_dom.selectedIndex]);
  487. me.currentNode[JV.PROP_SORT_KEYS] = [];
  488. }
  489. me.currentNode[JV.PROP_SORT_TYPE] = dom.value;
  490. },
  491. extractTabFields: function (handleObj) {
  492. let me = this, rst = {};
  493. rst[JV.PROP_HANDLE_TYPE] = handleObj[JV.PROP_HANDLE_TYPE];
  494. rst[JV.PROP_DATA_KEY] = handleObj[JV.PROP_DATA_KEY];
  495. rst[JV.PROP_SORT_TYPE] = handleObj[JV.PROP_SORT_TYPE];
  496. switch (sort_types.indexOf(handleObj[JV.PROP_SORT_TYPE])) {
  497. case -1:
  498. //unknown!
  499. break;
  500. case 0 :
  501. //normal
  502. rst[JV.PROP_SORT_KEYS] = handleObj[JV.PROP_SORT_KEYS];
  503. break;
  504. case 1 :
  505. //tree
  506. break;
  507. case 2 :
  508. //according to parent
  509. break;
  510. case 3 :
  511. //self define
  512. break;
  513. default:
  514. break;
  515. }
  516. return rst;
  517. }
  518. };
  519. let preHandleFilterObj = {
  520. treeObj: null,
  521. copyNode: function (src, dest) {
  522. let keys = [];
  523. for (let filterItem of src[JV.PROP_FILTER_KEYS]) {
  524. let item = {key: filterItem.key};
  525. item[JV.PROP_FILTER_CONDITION] = filterItem[JV.PROP_FILTER_CONDITION];
  526. item[JV.PROP_FILTER_COMPARE_VAL] = filterItem[JV.PROP_FILTER_COMPARE_VAL];
  527. if (filterItem[JV.PROP_FILTER_COMPARE_OBJ]) {
  528. item[JV.PROP_FILTER_COMPARE_OBJ] = filterItem[JV.PROP_FILTER_COMPARE_OBJ];
  529. item[JV.PROP_FILTER_COMPARE_OBJ_KEY] = filterItem[JV.PROP_FILTER_COMPARE_OBJ_KEY];
  530. }
  531. keys.push(item);
  532. }
  533. dest[JV.PROP_FILTER_KEYS] = keys;
  534. },
  535. refresh_node: function () {
  536. let me = this;
  537. $("#div_filter_type")[0].style.display = "";
  538. if (preHandleObj.currentNode) {
  539. let idx = pre_handle_data_objects.indexOf(preHandleObj.currentNode[JV.PROP_DATA_KEY]);
  540. me.treeObj = $.fn.zTree.init($("#pre_handle_filter_keys_reversed"), filterKeysSetting, exposed_properties_arr[idx]);
  541. let nodes = me.treeObj.getNodes();
  542. for (let filterItem of preHandleObj.currentNode[JV.PROP_FILTER_KEYS]) {
  543. for (let keyNode of nodes) {
  544. if (filterItem.key === keyNode.Key) {
  545. me.treeObj.checkNode(keyNode, true, false, false);
  546. //and then others...
  547. //过滤条件
  548. keyNode[JV.PROP_FILTER_CONDITION] = filterItem[JV.PROP_FILTER_CONDITION];
  549. $("#diySelect_" + keyNode.tId)[0].selectedIndex = condition_types.indexOf(filterItem[JV.PROP_FILTER_CONDITION]);
  550. //条件值
  551. keyNode[JV.PROP_FILTER_COMPARE_VAL] = filterItem[JV.PROP_FILTER_COMPARE_VAL];
  552. $("#diyInput_" + keyNode.tId)[0].selectedIndex = filterItem[JV.PROP_FILTER_COMPARE_VAL];
  553. //其他关联业务数据对象
  554. if (filterItem[JV.PROP_FILTER_COMPARE_OBJ]) {
  555. let cmpObjDom = $("#diyDataSelect_" + keyNode.tId)[0];
  556. keyNode[JV.PROP_FILTER_COMPARE_OBJ] = filterItem[JV.PROP_FILTER_COMPARE_OBJ];
  557. let idx = pre_handle_data_objects.indexOf(filterItem[JV.PROP_FILTER_COMPARE_OBJ]);
  558. cmpObjDom.selectedIndex = idx + 1;
  559. me.private_setup_compare_obj(cmpObjDom);
  560. let cmpObjIdDom = $("#diyDataDetailSelect_" + keyNode.tId)[0];
  561. for (let i = 0; i < cmpObjIdDom.children.length; i++) {
  562. let option = cmpObjIdDom.children[i];
  563. if (option.value === filterItem[JV.PROP_FILTER_COMPARE_OBJ_KEY]) {
  564. keyNode[JV.PROP_FILTER_COMPARE_OBJ_KEY] = filterItem[JV.PROP_FILTER_COMPARE_OBJ_KEY]
  565. cmpObjIdDom.selectedIndex = i;
  566. break;
  567. }
  568. }
  569. }
  570. break;
  571. }
  572. }
  573. }
  574. }
  575. },
  576. onCheck: function(event,treeId,treeNode) {
  577. let me = preHandleFilterObj;
  578. me.resetFilter();
  579. },
  580. resetFilter: function() {
  581. let me = this;
  582. let nodes = me.treeObj.getCheckedNodes();
  583. let normalSortKeys = [];
  584. for (let node of nodes) {
  585. let keyObj = {key: node.Key};
  586. if (!node[JV.PROP_FILTER_CONDITION]) {
  587. node[JV.PROP_FILTER_CONDITION] = "==";
  588. }
  589. keyObj[JV.PROP_FILTER_CONDITION] = node[JV.PROP_FILTER_CONDITION];
  590. keyObj[JV.PROP_FILTER_COMPARE_VAL] = node[JV.PROP_FILTER_COMPARE_VAL];
  591. if (node[JV.PROP_FILTER_COMPARE_OBJ]) {
  592. keyObj[JV.PROP_FILTER_COMPARE_OBJ] = node[JV.PROP_FILTER_COMPARE_OBJ];
  593. keyObj[JV.PROP_FILTER_COMPARE_OBJ_KEY] = node[JV.PROP_FILTER_COMPARE_OBJ_KEY];
  594. }
  595. normalSortKeys.push(keyObj);
  596. }
  597. preHandleObj.currentNode[JV.PROP_FILTER_KEYS] = normalSortKeys;
  598. },
  599. build_filter_handle_data_selection_str: function(treeId,treeNode) {
  600. let rst = [];
  601. rst.push("<select class='selDemo' id='diyDataSelect_" + treeNode.tId + "'>");
  602. rst.push("<option value='empty'>无</option>");
  603. for (let i = 0; i < pre_handle_data_objects.length; i++) {
  604. rst.push("<option value='" + pre_handle_data_objects[i] + "'>" + pre_handle_data_objects_name[i] + "</option>");
  605. }
  606. rst.push("</select>");
  607. return rst.join("");
  608. },
  609. build_filter_handle_data_detail_selection_str: function(treeId,treeNode) {
  610. let rst = [];
  611. rst.push("<select class='selDemo' id='diyDataDetailSelect_" + treeNode.tId + "'>");
  612. rst.push("</select>");
  613. return rst.join("");
  614. },
  615. addDiyDom: function(treeId,treeNode) {
  616. let me = preHandleFilterObj;
  617. let aObj = $("#" + treeNode.tId + IDMark_A);
  618. let dataDtlSelStr = me.build_filter_handle_data_detail_selection_str(treeId,treeNode);
  619. aObj.after(dataDtlSelStr);
  620. let dataSelStr = me.build_filter_handle_data_selection_str(treeId,treeNode);
  621. aObj.after(dataSelStr);
  622. let editStr = "<input type='text' id='diyInput_" + treeNode.tId + "' width='10'/>";
  623. aObj.after(editStr);
  624. let selStr = "<select class='selDemo' id='diySelect_" + treeNode.tId + "'><option value='=='>等于</option><option value='==='>全等于</option><option value='>'>大于</option><option value='>='>大于等于</option><option value='<'>小于</option><option value='<='>小于等于</option><option value='!='>不等于</option><option value='in'>在</option><option value='not in'>不在</option></select>";
  625. aObj.after(selStr);
  626. let sel = $("#diySelect_" + treeNode.tId);
  627. if (sel) {
  628. sel.bind("change", me.filterConditionChange);
  629. }
  630. sel = $("#diyDataSelect_" + treeNode.tId);
  631. if (sel) {
  632. sel.bind("change", me.filterCompareObjChange);
  633. }
  634. sel = $("#diyDataDetailSelect_" + treeNode.tId);
  635. if (sel) {
  636. sel.bind("change", me.filterCompareObjKeyChange);
  637. }
  638. },
  639. filterConditionChange: function(event) {
  640. let me = preHandleFilterObj, sel = event.currentTarget, tId = sel.id.slice(10);
  641. let node = me.treeObj.getNodeByTId(tId);
  642. node[JV.PROP_FILTER_CONDITION] = sel.value;
  643. me.resetFilter();
  644. },
  645. private_setup_compare_obj: function(dom) {
  646. let me = this, sel = dom, tId = sel.id.slice(14);
  647. let node = me.treeObj.getNodeByTId(tId);
  648. node[JV.PROP_FILTER_COMPARE_OBJ] = sel.value;
  649. let idx = pre_handle_data_objects.indexOf(sel.value);
  650. let dtlKey = "diyDataDetailSelect_" + tId;
  651. let dtlSel = document.getElementById(dtlKey);
  652. dtlSel.length = 0;
  653. if (idx >= 0) {
  654. let jdtlSel = $("#" + dtlKey);
  655. for (let item of exposed_properties_arr[idx]) {
  656. jdtlSel.append("<option value='" + item.Key + "'>" + item.Name + "</option>");
  657. }
  658. } else {
  659. //清除所有key选项
  660. node[JV.PROP_FILTER_COMPARE_OBJ_KEY] = null;
  661. }
  662. },
  663. filterCompareObjChange: function(event) {
  664. let me = preHandleFilterObj, sel = event.currentTarget;
  665. me.private_setup_compare_obj(sel);
  666. me.resetFilter();
  667. },
  668. filterCompareObjKeyChange: function(event) {
  669. let me = preHandleFilterObj, sel = event.currentTarget, tId = sel.id.slice(20);
  670. let node = me.treeObj.getNodeByTId(tId);
  671. node[JV.PROP_FILTER_COMPARE_OBJ_KEY] = sel.value;
  672. me.resetFilter();
  673. },
  674. extractTabFields: function (handleObj) {
  675. let me = this, rst = {};
  676. rst[JV.PROP_HANDLE_TYPE] = handleObj[JV.PROP_HANDLE_TYPE];
  677. rst[JV.PROP_DATA_KEY] = handleObj[JV.PROP_DATA_KEY];
  678. rst[JV.PROP_FILTER_KEYS] = [];
  679. for (let item of handleObj[JV.PROP_FILTER_KEYS]) {
  680. let dtl = {};
  681. dtl.key = item.key;
  682. dtl[JV.PROP_FILTER_CONDITION] = item[JV.PROP_FILTER_CONDITION];
  683. dtl[JV.PROP_FILTER_COMPARE_VAL] = item[JV.PROP_FILTER_COMPARE_VAL]?item[JV.PROP_FILTER_COMPARE_VAL]:null;
  684. dtl[JV.PROP_FILTER_COMPARE_OBJ] = item[JV.PROP_FILTER_COMPARE_OBJ]?item[JV.PROP_FILTER_COMPARE_OBJ]:null;
  685. dtl[JV.PROP_FILTER_COMPARE_OBJ_KEY] = item[JV.PROP_FILTER_COMPARE_OBJ_KEY]?item[JV.PROP_FILTER_COMPARE_OBJ_KEY]:null;
  686. rst[JV.PROP_FILTER_KEYS].push(dtl);
  687. }
  688. return rst;
  689. }
  690. };
  691. let preHandleSummaryObj = {
  692. copyNode: function (src, dest) {
  693. //
  694. },
  695. refresh_node: function () {
  696. $("#div_summary_type")[0].style.display = "";
  697. if (preHandleObj.currentNode) {
  698. }
  699. },
  700. extractTabFields: function (handleObj) {
  701. let rst = {};
  702. //
  703. return rst;
  704. }
  705. };
  706. let preHandleAdjustObj = {
  707. copyNode: function (src, dest) {
  708. //
  709. },
  710. refresh_node: function () {
  711. $("#div_adjust_type")[0].style.display = "";
  712. if (preHandleObj.currentNode) {
  713. }
  714. },
  715. extractTabFields: function (handleObj) {
  716. let rst = {};
  717. //
  718. return rst;
  719. }
  720. };
  721. let preHandleAddDummyObj = {
  722. copyNode: function (src, dest) {
  723. //
  724. },
  725. refresh_node: function () {
  726. $("#div_add_dummy_type")[0].style.display = "";
  727. if (preHandleObj.currentNode) {
  728. }
  729. },
  730. extractTabFields: function (handleObj) {
  731. let rst = {};
  732. //
  733. return rst;
  734. }
  735. };