rpt_tpl_pre_handle.js 59 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211
  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", "projectGLJ"];
  7. const pre_handle_data_objects_name = ["清单", "定额", "定额人材机", "项目人材机"];
  8. //供货方式
  9. const fixed_supply_types = [
  10. {Name: "自行采购(0)", Title: "", Value: 0},
  11. {Name: "部分甲供(1)", Title: "", Value: 1},
  12. {Name: "完全甲供(2)", Title: "", Value: 2},
  13. {Name: "甲定乙供(3)", Title: "", Value: 3}
  14. ];
  15. //三材类别
  16. const fixed_material_types = [
  17. {Name: "钢材(1)", Title: "", Value: 1},
  18. {Name: "钢筋(2)", Title: "", Value: 2},
  19. {Name: "木材(3)", Title: "", Value: 3},
  20. {Name: "水泥(4)", Title: "", Value: 4},
  21. {Name: "标准砖(5)", Title: "", Value: 5}
  22. ];
  23. // const fixed_glj_types = [
  24. // {Name: "人工(1)", Title: "", Value: 1},
  25. // {Name: "普通材料(201)", Title: "", Value: 201},
  26. // {Name: "混凝土(202)", Title: "", Value: 202},
  27. // {Name: "砂浆(203)", Title: "", Value: 203},
  28. // {Name: "配合比(204)", Title: "", Value: 204},
  29. // {Name: "商品混凝土(205)", Title: "", Value: 205},
  30. // {Name: "商品砂浆(206)", Title: "", Value: 206},
  31. // {Name: "其他材料(207)", Title: "", Value: 207},
  32. // {Name: "普通机械(301)", Title: "", Value: 301},
  33. // {Name: "机械组成物(302)", Title: "", Value: 302},
  34. // {Name: "机上人工(303)", Value: 303},
  35. // {Name: "仪器仪表(304)", Value: 304},
  36. // {Name: "燃料动力费(305)", Value: 305},
  37. // {Name: "折旧费(306)", Value: 306},
  38. // {Name: "检修费(307)", Value: 307},
  39. // {Name: "维护费(308)", Value: 308},
  40. // {Name: "安拆费及场外运费(309)", Value: 309},
  41. // {Name: "校验费(310)", Value: 310},
  42. // {Name: "其他费用(311)", Value: 311},
  43. // {Name: "其他施工机具使用费(312)", Value: 312},
  44. // {Name: "主材(4)", Title: "", Value: 4},
  45. // {Name: "设备(5)", Title: "", Value: 5},
  46. // {Name: "企业管理费(6)", Title: "", Value: 6},
  47. // {Name: "利润(7)", Title: "", Value: 7},
  48. // {Name: "一般风险费(8)", Title: "", Value: 8}
  49. // ];
  50. const fixed_glj_types = [
  51. {Name: "人工(1)", Title: "", Value: 1},
  52. {Name: "普通材料(201)", Title: "", Value: 201},
  53. {Name: "混凝土(202)", Title: "", Value: 202},
  54. {Name: "砂浆(203)", Title: "", Value: 203},
  55. {Name: "配合比(204)", Title: "", Value: 204},
  56. {Name: "商品混凝土(205)", Title: "", Value: 205},
  57. {Name: "商品砂浆(206)", Title: "", Value: 206},
  58. {Name: "其他材料(207)", Title: "", Value: 207},
  59. {Name: "机械台班(301)", Title: "", Value: 301},
  60. {Name: "机械组成物(302)", Title: "", Value: 302},
  61. {Name: "机上人工(303)", Value: 303},
  62. {Name: "仪器仪表(304)", Value: 304},
  63. {Name: "燃料动力费(305)", Value: 305},
  64. {Name: "折旧费(306)", Value: 306},
  65. {Name: "检修费(307)", Value: 307},
  66. {Name: "维护费(308)", Value: 308},
  67. {Name: "安拆费及场外运费(309)", Value: 309},
  68. {Name: "校验费(310)", Value: 310},
  69. {Name: "其他费用(311)", Value: 311},
  70. {Name: "其他施工机具使用费(312)", Value: 312},
  71. {Name: "主材(4)", Title: "", Value: 4},
  72. {Name: "设备(5)", Title: "", Value: 5},
  73. {Name: "企业管理费(6)", Title: "", Value: 6},
  74. {Name: "利润(7)", Title: "", Value: 7},
  75. {Name: "一般风险费(8)", Title: "", Value: 8}
  76. ];
  77. // const fixed_top_bills_nodes = [
  78. // {Name: "分部分项工程(1)", Title: "", Value: 1}
  79. // ,{Name: "措施项目(2)", Title: "", Value: 2}
  80. // ,{Name: "其他项目(7)", Title: "", Value: 7}
  81. // ,{Name: "规费(15)", Title: "", Value: 15}
  82. // ,{Name: "税金(18)", Title: "", Value: 18}
  83. // ,{Name: "工程造价(19)", Title: "", Value: 19}
  84. // ];
  85. const fixed_top_bills_nodes = [
  86. {Name: "建筑安装工程费(1)", Title: "", Value: 1}
  87. ,{Name: "土地使用及拆迁补偿费(2)", Title: "", Value: 2}
  88. ,{Name: "养护工程其他费用(3)", Title: "", Value: 3}
  89. ,{Name: "预备费(4)", Title: "", Value: 4}
  90. ,{Name: "一二三四部分合计(7)", Title: "", Value: 7}
  91. ,{Name: "贷款利息(8)", Title: "", Value: 8}
  92. ,{Name: "总造价(9)", Title: "", Value: 9}
  93. ];
  94. // const fixed_other_bills_types = [
  95. // {Name: "施工技术措施项目(3)", Title: "", Value: 3}
  96. // ,{Name: "安全文明施工按实计算费用(4)", Title: "", Value: 4}
  97. // ,{Name: "施工组织措施专项费用(5)", Title: "", Value: 5}
  98. // ,{Name: "安全文明施工专项费用(6)", Title: "", Value: 6}
  99. // ,{Name: "暂列金额(8)", Title: "", Value: 8}
  100. // ,{Name: "暂估价(9)", Title: "", Value: 9}
  101. // ,{Name: "材料(工程设备)暂估价(10)", Title: "", Value: 10}
  102. // ,{Name: "专业工程暂估价(11)", Title: "", Value: 11}
  103. // ,{Name: "计日工(12)", Title: "", Value: 12}
  104. // ,{Name: "总承包服务费(13)", Title: "", Value: 13}
  105. // ,{Name: "索赔与现场签证(14)", Title: "", Value: 14}
  106. // ,{Name: "社会保险费及住房公积金(16)", Title: "", Value: 16}
  107. // ,{Name: "工程排污费(17)", Title: "", Value: 17}
  108. // ,{Name: "增值税(20)", Title: "", Value: 20}
  109. // ];
  110. const fixed_other_bills_types = [
  111. {Name: "基本预备费(5)", Title: "", Value: 5}
  112. ,{Name: "价差预备费(6)", Title: "", Value: 6}
  113. ,{Name: "设备购置费(10)", Title: "", Value: 10}
  114. ,{Name: "专项费用(11)", Title: "", Value: 11}
  115. ,{Name: "施工场地建设费(12)", Title: "", Value: 12}
  116. ,{Name: "养护单位(业主)管理费(13)", Title: "", Value: 13}
  117. ,{Name: "信息化费", Title: "", Value: 14}
  118. ,{Name: "工程监理费(15)", Title: "", Value: 15}
  119. ,{Name: "设计文件审查费(16)", Title: "", Value: 16}
  120. ,{Name: "勘察设计费(17)", Title: "", Value: 17}
  121. ,{Name: "招标代理及标底编制费(18)", Title: "", Value: 18}
  122. ,{Name: "第100章至700章清单(19)", Title: "", Value: 19}
  123. ,{Name: "专项暂定合计(20)", Title: "", Value: 20}
  124. ,{Name: "清单合计扣除专项暂定合计(21)", Title: "", Value: 21}
  125. ,{Name: "计日工(22)", Title: "", Value: 22}
  126. ,{Name: "劳务(23)", Title: "", Value: 23}
  127. ,{Name: "材料(24)", Title: "", Value: 24}
  128. ,{Name: "施工机械(25)", Title: "", Value: 25}
  129. ,{Name: "暂列金额(26)", Title: "", Value: 26}
  130. ,{Name: "安全生产费(27)", Title: "", Value: 27}
  131. ,{Name: "100章清单(28)", Title: "", Value: 28}
  132. ];
  133. // const fixed_bills_flags = [
  134. // {Name: "分部分项工程(1)", Title: "", Value: 1},
  135. // {Name: "措施项目(2)", Title: "", Value: 2},
  136. // {Name: "施工技术措施项目(3)", Title: "", Value: 3},
  137. // {Name: "安全文明施工按实计算费用(4)", Title: "", Value: 4},
  138. // {Name: "施工组织措施专项费用(5)", Title: "", Value: 5},
  139. // {Name: "安全文明施工专项费用(6)", Title: "", Value: 6},
  140. // {Name: "其他项目(7)", Title: "", Value: 7},
  141. // {Name: "暂列金额(8)", Title: "", Value: 8},
  142. // {Name: "暂估价(9)", Title: "", Value: 9},
  143. // {Name: "材料(工程设备)暂估价(10)", Title: "", Value: 10},
  144. // {Name: "专业工程暂估价(11)", Title: "", Value: 11},
  145. // {Name: "计日工(12)", Title: "", Value: 12},
  146. // {Name: "总承包服务费(13)", Title: "", Value: 13},
  147. // {Name: "索赔与现场签证(14)", Title: "", Value: 14},
  148. // {Name: "规费(15)", Title: "", Value: 15},
  149. // {Name: "社会保险费及住房公积金(16)", Title: "", Value: 16},
  150. // {Name: "工程排污费(17)", Title: "", Value: 17},
  151. // {Name: "税金(18)", Title: "", Value: 18},
  152. // {Name: "工程造价(19)", Title: "", Value: 19},
  153. // {Name: "增值税(20)", Title: "", Value: 20}
  154. // ];
  155. const fixed_bills_flags = [
  156. {Name: "建筑安装工程费(1)", Title: "", Value: 1}
  157. ,{Name: "土地使用及拆迁补偿费(2)", Title: "", Value: 2}
  158. ,{Name: "养护工程其他费用(3)", Title: "", Value: 3}
  159. ,{Name: "预备费(4)", Title: "", Value: 4}
  160. ,{Name: "基本预备费(5)", Title: "", Value: 5}
  161. ,{Name: "价差预备费(6)", Title: "", Value: 6}
  162. ,{Name: "一二三四部分合计(7)", Title: "", Value: 7}
  163. ,{Name: "贷款利息(8)", Title: "", Value: 8}
  164. ,{Name: "总造价(9)", Title: "", Value: 9}
  165. ,{Name: "设备购置费(10)", Title: "", Value: 10}
  166. ,{Name: "专项费用(11)", Title: "", Value: 11}
  167. ,{Name: "施工场地建设费(12)", Title: "", Value: 12}
  168. ,{Name: "养护单位(业主)管理费(13)", Title: "", Value: 13}
  169. ,{Name: "信息化费", Title: "", Value: 14}
  170. ,{Name: "工程监理费(15)", Title: "", Value: 15}
  171. ,{Name: "设计文件审查费(16)", Title: "", Value: 16}
  172. ,{Name: "勘察设计费(17)", Title: "", Value: 17}
  173. ,{Name: "招标代理及标底编制费(18)", Title: "", Value: 18}
  174. ,{Name: "第100章至700章清单(19)", Title: "", Value: 19}
  175. ,{Name: "专项暂定合计(20)", Title: "", Value: 20}
  176. ,{Name: "清单合计扣除专项暂定合计(21)", Title: "", Value: 21}
  177. ,{Name: "计日工(22)", Title: "", Value: 22}
  178. ,{Name: "劳务(23)", Title: "", Value: 23}
  179. ,{Name: "材料(24)", Title: "", Value: 24}
  180. ,{Name: "施工机械(25)", Title: "", Value: 25}
  181. ,{Name: "暂列金额(26)", Title: "", Value: 26}
  182. ,{Name: "安全生产费(27)", Title: "", Value: 27}
  183. ,{Name: "100章清单(28)", Title: "", Value: 28}
  184. ];
  185. const fixed_bills_types = [
  186. {Name: "大项费用(1)", Title: "", Value: 1},
  187. {Name: "分部(2)", Title: "", Value: 2},
  188. {Name: "分项(3)", Title: "", Value: 3},
  189. {Name: "清单(4)", Title: "", Value: 4},
  190. {Name: "补项(5)", Title: "", Value: 5}
  191. ];
  192. const fixed_bills_special_provisional_types = [
  193. {Name: "材料", Title: "", Value: "材料"},
  194. {Name: "工程设备", Title: "", Value: "工程设备"},
  195. {Name: "专业工程", Title: "", Value: "专业工程"}
  196. ];
  197. const exposed_bills_properties = [
  198. {Name: "清单_所属项目ID", Title: "", Key: "projectID", Order: "ascend"}
  199. ,{Name: "清单_ID", Title: "", Key: "ID", Order: "ascend"}
  200. ,{Name: "顶层父清单_标记", Title: "", Key: "topBillID", Order: "ascend", individualType: fixed_top_bills_nodes}
  201. ,{Name: "清单_层次", Title: "", Key: "treeLevel", Order: "ascend"}
  202. ,{Name: "清单_类别", Title: "", Key: "type", Order: "ascend", individualType: fixed_bills_types}
  203. ,{Name: "清单_标记", Title: "", Key: "flags.flag", Order: "ascend", individualType: fixed_bills_flags}
  204. ,{Name: "清单_顺序号", Title: "", Key: "treeFlatSerialOrder", Order: "ascend"}
  205. ,{Name: "清单_专项类型", Title: "", Key: "specialProvisional", Order: "ascend", individualType: fixed_bills_special_provisional_types}
  206. ];
  207. const exposed_ration_properties = [
  208. {Name: "定额_工程内部ID", Title: "", Key: "ID", Order: "ascend"}
  209. ,{Name: "定额_所属项目ID", Title: "", Key: "projectID", Order: "ascend"}
  210. ,{Name: "定额_所属清单ID", Title: "", Key: "billsItemID", Order: "ascend"}
  211. ,{Name: "定额_清单内顺序", Title: "", Key: "serialNo", Order: "ascend"}
  212. ];
  213. const exposed_ration_glj_properties = [
  214. {Name: "定额人材机_ID", Title: "", Key: "ID"}
  215. ,{Name: "定额人材机_所属定额ID", Title: "", Key: "rationID", Order: "ascend"}
  216. ,{Name: "定额人材机_所属清单ID", Title: "", Key: "billsItemID", Order: "ascend"}
  217. ,{Name: "定额人材机_所属工程ID", Title: "", Key: "projectID", Order: "ascend"}
  218. ,{Name: "定额人材机_代码", Title: "", Key: "code", Order: "ascend"}
  219. ,{Name: "定额人材机_类型", Title: "", Key: "type", Order: "ascend", individualType: fixed_glj_types}
  220. ,{Name: "定额人材机_数量", Title: "", Key: "quantity", Order: "ascend"}
  221. ,{Name: "定额人材机_是否暂估", Title: "", Key: "ref_join(projectGLJID,projectGLJ,id).is_evaluate", Order: "ascend", isBoolean: true, booleanOptions: [1,0]}
  222. ,{Name: "定额人材机_供货方式", Title: "", Key: "ref_join(projectGLJID,projectGLJ,id).supply", Order: "ascend", individualType: fixed_supply_types}
  223. ,{Name: "定额人材机_三材类别", Title: "", Key: "ref_join(projectGLJID,projectGLJ,id).materialType", Order: "ascend", individualType: fixed_material_types}
  224. ];
  225. const exposed_prj_glj_properties = [
  226. {Name: "项目人材机_ID", Title: "", Key: "ID"}
  227. ,{Name: "项目人材机_所属工程ID", Title: "", Key: "projectID", Order: "ascend"}
  228. ,{Name: "项目人材机_代码", Title: "", Key: "code", Order: "ascend"}
  229. ,{Name: "项目人材机_类型", Title: "", Key: "type", Order: "ascend", individualType: fixed_glj_types}
  230. ,{Name: "项目人材机_数量", Title: "", Key: "quantity", Order: "ascend"}
  231. ,{Name: "项目人材机_是否暂估", Title: "", Key: "is_evaluate", Order: "ascend", isBoolean: true, booleanOptions: [1,0]}
  232. ,{Name: "项目人材机_供货方式", Title: "", Key: "supply", Order: "ascend", individualType: fixed_supply_types}
  233. ,{Name: "项目人材机_三材类别", Title: "", Key: "materialType", Order: "ascend", individualType: fixed_material_types}
  234. ];
  235. const exposed_properties_arr = [exposed_bills_properties, exposed_ration_properties, exposed_ration_glj_properties, exposed_prj_glj_properties];
  236. let preHandleObj = {
  237. treeObj: null,
  238. typeTreeObj: null,
  239. currentNode: null,
  240. iniTree: function(rptTpl) {
  241. let me = this;
  242. me.buildData(rptTpl);
  243. },
  244. buildData: function(rptTpl) {
  245. let me = this, handles = [];
  246. if (rptTpl[JV.NODE_MAP_DATA_HANDLE_INFO]) {
  247. for (let item of rptTpl[JV.NODE_MAP_DATA_HANDLE_INFO]) {
  248. let hd = {Name: "预处理环节"};
  249. me.private_copy_node(item, hd);
  250. me.private_set_title(hd);
  251. hd.Operations = []; //考虑到用户可能会换来换去,这样会有冗余的属性出现
  252. handles.push(hd);
  253. }
  254. }
  255. me.treeObj = $.fn.zTree.init($("#pre_handle_data_info_reversed"), preHandleSetting, handles);
  256. },
  257. build_handle_data_selection: function() {
  258. let sel = $("#select_mapping_data"), sel2 = $("#select_mapping_data_for_sort_type");
  259. for (let i = 0; i < pre_handle_data_objects.length; i++) {
  260. sel2.append("<option value='" + pre_handle_data_objects[i] + "'>" + pre_handle_data_objects_name[i] + "</option>");
  261. sel.append("<option value='" + pre_handle_data_objects[i] + "'>" + pre_handle_data_objects_name[i] + "</option>");
  262. }
  263. },
  264. buildTypeData: function () {
  265. let me = this, types = [];
  266. types.push({Name: JV.PROP_HANDLE_TYPE_SORT, Title: ""});
  267. types.push({Name: JV.PROP_HANDLE_TYPE_FILTER, Title: ""});
  268. types.push({Name: JV.PROP_HANDLE_TYPE_BILLS_DATA_MOVE, Title: ""});
  269. types.push({Name: JV.PROP_HANDLE_TYPE_SUM, Title: ""});
  270. types.push({Name: JV.PROP_HANDLE_TYPE_ADJUST, Title: ""});
  271. types.push({Name: JV.PROP_HANDLE_TYPE_ADD_DUMMY, Title: ""});
  272. // types.push({Name: "纯手工填写", Title: ""});
  273. me.typeTreeObj = $.fn.zTree.init($("#pre_handle_type_reversed"), preHandleTypeSetting, types);
  274. me.setDisabledBandSelect([0,1,2,3,4,5]);
  275. me.build_handle_data_selection();
  276. },
  277. setDisabledBandSelect: function(disabledIdxArr) {
  278. let me = this;
  279. if (me.typeTreeObj) {
  280. let nodes = me.typeTreeObj.getNodes();
  281. for (let idx = 0; idx < nodes.length; idx++) {
  282. if (disabledIdxArr.indexOf(idx) >= 0) {
  283. me.typeTreeObj.setChkDisabled(nodes[idx], true, true, true);
  284. } else {
  285. me.typeTreeObj.setChkDisabled(nodes[idx], false, true, true);
  286. }
  287. }
  288. }
  289. },
  290. createNewNode: function (nodeType) {
  291. let rst = null, preHandleType = nodeType;
  292. if (!nodeType) {
  293. preHandleType = JV.PROP_HANDLE_TYPE_SORT;
  294. }
  295. switch (nodeType) {
  296. case JV.PROP_HANDLE_TYPE_SORT:
  297. rst = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "排序方式": "normal", "排序键值集":[]};
  298. break;
  299. case JV.PROP_HANDLE_TYPE_FILTER:
  300. rst = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "过滤键值集": []};
  301. break;
  302. case JV.PROP_HANDLE_TYPE_BILLS_DATA_MOVE:
  303. rst = {Name: "预处理环节", Title: "", "映射数据对象": "ration", "预处理类型": preHandleType};
  304. break;
  305. case JV.PROP_HANDLE_TYPE_SUM:
  306. rst = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "分组键值集": [], "统计键值集":[]};
  307. break;
  308. case JV.PROP_HANDLE_TYPE_ADJUST:
  309. rst = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "数据调整集":[]};
  310. break;
  311. case JV.PROP_HANDLE_TYPE_ADD_DUMMY:
  312. rst = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": preHandleType, "Dummy数据集":[]};
  313. break;
  314. default:
  315. rst = {Name: "预处理环节", Title: "", "映射数据对象": "bills", "预处理类型": "排序", "排序方式": "normal", "排序键值集":[]};
  316. break;
  317. }
  318. return rst;
  319. },
  320. addNewNode: function(nodeType) {
  321. let me = this, item = me.createNewNode(nodeType);
  322. me.private_set_title(item);
  323. me.treeObj.addNodes(null, -1, [item], true);
  324. },
  325. private_change_node_by_type: function(handleType, item) {
  326. let preHandleType = handleType;
  327. if (!handleType) {
  328. preHandleType = JV.PROP_HANDLE_TYPE_SORT;
  329. }
  330. item[JV.PROP_HANDLE_TYPE] = preHandleType;
  331. switch (handleType) {
  332. case JV.PROP_HANDLE_TYPE_SORT:
  333. item[JV.PROP_SORT_TYPE] = "normal";
  334. item[JV.PROP_SORT_KEYS] = [];
  335. break;
  336. case JV.PROP_HANDLE_TYPE_FILTER:
  337. item[JV.PROP_FILTER_KEYS] = [];
  338. break;
  339. case JV.PROP_HANDLE_TYPE_BILLS_DATA_MOVE:
  340. break;
  341. case JV.PROP_HANDLE_TYPE_SUM:
  342. item[JV.PROP_SUM_GROUP_KEYS] = [];
  343. item[JV.PROP_SUM_SUM_KEYS] = [];
  344. break;
  345. case JV.PROP_HANDLE_TYPE_ADJUST:
  346. item[JV.PROP_ADJUST_COLLECTION] = [];
  347. break;
  348. case JV.PROP_HANDLE_TYPE_ADD_DUMMY:
  349. item[JV.PROP_DUMMY_COLLECTION] = [];
  350. break;
  351. default:
  352. item[JV.PROP_HANDLE_TYPE] = JV.PROP_HANDLE_TYPE_SORT;
  353. item[JV.PROP_SORT_TYPE] = "normal";
  354. item[JV.PROP_SORT_KEYS] = [];
  355. break;
  356. }
  357. // return rst;
  358. },
  359. private_copy_node: function(src, dest) {
  360. let me = this;
  361. dest[JV.PROP_DATA_KEY] = src[JV.PROP_DATA_KEY];
  362. dest[JV.PROP_HANDLE_TYPE] = src[JV.PROP_HANDLE_TYPE];
  363. if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_SORT) {
  364. preHandleSortObj.copyNode(src, dest);
  365. } else if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_FILTER) {
  366. preHandleFilterObj.copyNode(src, dest);
  367. } else if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_SUM) {
  368. preHandleSummaryObj.copyNode(src, dest);
  369. } else if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_ADJUST) {
  370. preHandleAdjustObj.copyNode(src, dest);
  371. } else if (src[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_ADD_DUMMY) {
  372. preHandleAddDummyObj.copyNode(src, dest);
  373. }
  374. },
  375. private_set_title: function(node) {
  376. let nameStr = node[JV.PROP_NAME], idx = nameStr.indexOf("(");
  377. if (idx >= 0) {
  378. nameStr = nameStr.slice(0, idx);
  379. }
  380. node[JV.PROP_NAME] = nameStr + "(" + node[JV.PROP_HANDLE_TYPE] + ")";
  381. node.Title = "映射数据对象:" + node[JV.PROP_DATA_KEY] + " | " + node[JV.PROP_HANDLE_TYPE];
  382. },
  383. refreshByNode: function(treeNode) {
  384. let me = preHandleObj;
  385. if (me.typeTreeObj) {
  386. let nodes = me.typeTreeObj.getNodes();
  387. let typeNode = null;
  388. for (let node of nodes) {
  389. if (treeNode[JV.PROP_NAME].indexOf(node[JV.PROP_NAME]) > 0) {
  390. me.typeTreeObj.checkNode(node, true, false, false);
  391. typeNode = node;
  392. break;
  393. }
  394. }
  395. let md = $("#select_mapping_data")[0];
  396. for (let i = 0; i < md.children.length; i++) {
  397. if (treeNode[JV.PROP_DATA_KEY] === md.children[i].value) {
  398. md.selectedIndex = i;
  399. break;
  400. }
  401. }
  402. if (typeNode) {
  403. me.hide_all_dom();
  404. $("#div_pre_handle_data")[0].style.display = "";
  405. if (typeNode[JV.PROP_NAME] === "排序") {
  406. preHandleSortObj.refresh_node();
  407. } else if (typeNode[JV.PROP_NAME] === "过滤") {
  408. preHandleFilterObj.refresh_node();
  409. } else if (typeNode[JV.PROP_NAME] === "合计") {
  410. preHandleSummaryObj.refresh_node();
  411. } else if (typeNode[JV.PROP_NAME] === "数据调整") {
  412. preHandleAdjustObj.refresh_node();
  413. } else if (typeNode[JV.PROP_NAME] === "增加Dummy数据") {
  414. preHandleAddDummyObj.refresh_node();
  415. }
  416. }
  417. }
  418. },
  419. hide_all_dom: function() {
  420. $("#div_pre_handle_data")[0].style.display = "none";
  421. $("#div_sort_type")[0].style.display = "none";
  422. $("#div_sort_type_normal")[0].style.display = "none";
  423. $("#div_filter_type")[0].style.display = "none";
  424. $("#div_summary_type")[0].style.display = "none";
  425. $("#div_adjust_type")[0].style.display = "none";
  426. $("#div_add_dummy_type")[0].style.display = "none";
  427. $("#div_sort_type_according_to_parent")[0].style.display = "none";
  428. $("#div_sort_type_parent_data")[0].style.display = "none";
  429. $("#div_sort_tree")[0].style.display = "none";
  430. $("#div_sort_self_define")[0].style.display = "none";
  431. },
  432. onPreHandleClick: function(event,treeId,treeNode) {
  433. //点击预处理环节 节点
  434. let me = preHandleObj;
  435. me.currentNode = treeNode;
  436. me.setDisabledBandSelect([3,4,5]);
  437. // me.setDisabledBandSelect([]);
  438. me.refreshByNode(treeNode);
  439. },
  440. onTypeClick: function(event,treeId,treeNode) {
  441. //选择预处理类型(排序、过滤。。。)
  442. let me = preHandleObj;
  443. if (me.currentNode) {
  444. // me.currentNode[JV.PROP_HANDLE_TYPE] = treeNode[JV.PROP_NAME];
  445. me.private_change_node_by_type(treeNode[JV.PROP_NAME], me.currentNode);
  446. me.private_set_title(me.currentNode);
  447. me.treeObj.updateNode(me.currentNode, false);
  448. me.refreshByNode(me.currentNode);
  449. }
  450. },
  451. onChangeDataMappingObj: function(dom, oprType) {
  452. //更改(或选择)预处理环节中的 数据依据(就是说报表想预处理什么数据)
  453. let me = preHandleObj;
  454. if (oprType === "top") {
  455. preHandleObj.currentNode[JV.PROP_DATA_KEY] = dom.value;
  456. preHandleSortObj.childTreeObj = $.fn.zTree.init($("#child_sorting_keys"), sortingKeysSetting, exposed_properties_arr[dom.selectedIndex]);
  457. preHandleSortObj.treeObj = $.fn.zTree.init($("#pre_handle_sort_keys_reversed"), sortingKeysSetting, exposed_properties_arr[dom.selectedIndex]);
  458. preHandleFilterObj.treeObj = $.fn.zTree.init($("#pre_handle_filter_keys_reversed"), filterKeysSetting, exposed_properties_arr[dom.selectedIndex]);
  459. } else if (oprType === "accord_to_parent") {
  460. preHandleSortObj.parentTreeObj = $.fn.zTree.init($("#parent_sorting_keys"), sortingKeysSetting, exposed_properties_arr[dom.selectedIndex]);
  461. preHandleObj.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_DATA_KEY] = dom.value;
  462. }
  463. },
  464. onBeforeDrag: function (treeId, treeNodes) {
  465. let rst = true;
  466. for (let node of treeNodes) {
  467. if (node.level > 0) {
  468. rst = false;
  469. break;
  470. }
  471. }
  472. return rst;
  473. },
  474. onBeforeDrop: function(treeId, treeNodes, targetNode, moveType){
  475. let rst = false;
  476. if (targetNode.level === 0 && moveType !== "inner") {
  477. rst = true;
  478. }
  479. return rst;
  480. },
  481. onBeforeRemove: function(treeId, treeNode){
  482. let rst = true;
  483. if (treeNode.isParent) {
  484. rst = false;
  485. } else {
  486. //
  487. }
  488. return rst;
  489. },
  490. addHoverDom: function(treeId, treeNode) {
  491. let me = preHandleObj, sObj = $("#" + treeNode.tId + "_span");
  492. if ((treeNode.level > 0 && treeNode[JV.PROP_HANDLE_TYPE] !== JV.PROP_HANDLE_TYPE_FILTER) || ($("#addBtn_"+treeNode.tId).length > 0) ) return;
  493. if (treeNode[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_SORT && treeNode[JV.PROP_SORT_TYPE] === "accord_to_parent") {
  494. let addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增子排序' onfocus='this.blur();'></span>";
  495. sObj.after(addStr);
  496. let btn = $("#addBtn_"+treeNode.tId);
  497. if (btn) btn.bind("click", function(){
  498. let newSubNodes = [];
  499. let newNode = me.createNewNode(treeNode[JV.PROP_HANDLE_TYPE]);
  500. newNode.Name = "子排序";
  501. newNode[JV.PROP_DATA_KEY] = treeNode[JV.PROP_DATA_KEY];
  502. me.private_set_title(newNode);
  503. newSubNodes.push(newNode);
  504. treeNode.isParent = true;
  505. me.treeObj.addNodes(treeNode, -1, newSubNodes, true);
  506. me.treeObj.expandNode(treeNode, true, false);
  507. });
  508. } else if (treeNode[JV.PROP_HANDLE_TYPE] === JV.PROP_HANDLE_TYPE_FILTER) {
  509. let addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增子过滤' onfocus='this.blur();'></span>";
  510. sObj.after(addStr);
  511. let btn = $("#addBtn_"+treeNode.tId);
  512. if (btn) btn.bind("click", function(){
  513. let newSubNodes = [];
  514. let newNode = me.createNewNode(treeNode[JV.PROP_HANDLE_TYPE]);
  515. newNode.Name = "子过滤";
  516. newNode[JV.PROP_DATA_KEY] = treeNode[JV.PROP_DATA_KEY];
  517. newNode.Title = "";
  518. newNode[JV.PROP_HANDLE_TYPE] = JV.PROP_HANDLE_TYPE_FILTER;
  519. // me.private_set_title(newNode);
  520. newSubNodes.push(newNode);
  521. treeNode.isParent = true;
  522. me.treeObj.addNodes(treeNode, -1, newSubNodes, true);
  523. me.treeObj.expandNode(treeNode, true, false);
  524. });
  525. }
  526. },
  527. removeHoverDom: function (treeId, treeNode) {
  528. $("#addBtn_"+treeNode.tId).unbind().remove();
  529. },
  530. extractTabFields: function (rptTpl) {
  531. let me = this, nodes = me.treeObj.getNodes();
  532. let rst = [];
  533. if (nodes && nodes.length > 0) {
  534. for (let handleObj of nodes) {
  535. switch (handleObj[JV.PROP_HANDLE_TYPE]) {
  536. case JV.PROP_HANDLE_TYPE_SORT:
  537. rst.push(preHandleSortObj.extractTabFields(handleObj));
  538. break;
  539. case JV.PROP_HANDLE_TYPE_FILTER:
  540. rst.push(preHandleFilterObj.extractTabFields(handleObj));
  541. break;
  542. case JV.PROP_HANDLE_TYPE_SUM:
  543. rst.push(preHandleSummaryObj.extractTabFields(handleObj));
  544. break;
  545. case JV.PROP_HANDLE_TYPE_ADJUST:
  546. rst.push(preHandleAdjustObj.extractTabFields(handleObj));
  547. break;
  548. case JV.PROP_HANDLE_TYPE_ADD_DUMMY:
  549. rst.push(preHandleAddDummyObj.extractTabFields(handleObj));
  550. break;
  551. default:
  552. break;
  553. }
  554. }
  555. }
  556. rptTpl[JV.NODE_MAP_DATA_HANDLE_INFO] = rst;
  557. }
  558. };
  559. let preHandleSortObj = {
  560. normalTreeObj: null,
  561. parentTreeObj: null,
  562. childTreeObj: null,
  563. topBillsTreeObj: null,
  564. otherBillsTreeObj: null,
  565. copyNode: function (src, dest) {
  566. let me = preHandleSortObj;
  567. dest[JV.PROP_SORT_TYPE] = src[JV.PROP_SORT_TYPE];
  568. switch (sort_types.indexOf(src[JV.PROP_SORT_TYPE])) {
  569. case -1:
  570. //unknown!
  571. break;
  572. case 0 :
  573. //normal
  574. let keys = [];
  575. for (let sortKeyItem of src[JV.PROP_SORT_KEYS]) {
  576. let item = {key: sortKeyItem.key, order: sortKeyItem.order};
  577. keys.push(item);
  578. }
  579. dest[JV.PROP_SORT_KEYS] = keys;
  580. break;
  581. case 1 :
  582. //tree
  583. let billKeys = [];
  584. if (src[JV.PROP_FILTER_TOP_BILLS_NODES] && src[JV.PROP_FILTER_TOP_BILLS_NODES].length > 0) {
  585. billKeys = billKeys.concat(src[JV.PROP_FILTER_TOP_BILLS_NODES]);
  586. }
  587. dest[JV.PROP_FILTER_TOP_BILLS_NODES] = billKeys;
  588. let otherBillKeys = [];
  589. if (src[JV.PROP_FILTER_OTHER_BILLS_NODES] && src[JV.PROP_FILTER_OTHER_BILLS_NODES].length > 0) {
  590. otherBillKeys = otherBillKeys.concat(src[JV.PROP_FILTER_OTHER_BILLS_NODES]);
  591. }
  592. dest[JV.PROP_FILTER_OTHER_BILLS_NODES] = otherBillKeys;
  593. break;
  594. case 2 :
  595. //according to parent
  596. dest[JV.PROP_PARENT_CHILD_SORT_KEY] = {};
  597. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_DATA_KEY] = src[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_DATA_KEY];
  598. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS] = [];
  599. for (let item of src[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS]) {
  600. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS].push(item);
  601. }
  602. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS] = [];
  603. for (let item of src[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS]) {
  604. dest[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS].push(item);
  605. }
  606. dest[JV.PROP_OTHER_SUB_SORT] = [];
  607. if (src[JV.PROP_OTHER_SUB_SORT] !== null && src[JV.PROP_OTHER_SUB_SORT] !== undefined) {
  608. dest.items = [];
  609. for (let subSort of src[JV.PROP_OTHER_SUB_SORT]) {
  610. let destSubSort = {Name: "子排序"};
  611. me.copyNode(subSort, destSubSort);
  612. destSubSort[JV.PROP_DATA_KEY] = src[JV.PROP_DATA_KEY];
  613. dest.items.push(destSubSort);
  614. }
  615. }
  616. break;
  617. case 3 :
  618. //self define
  619. dest[JV.PROP_SORT_TYPE_SELF_DEFINE_LOGIC] = src[JV.PROP_SORT_TYPE_SELF_DEFINE_LOGIC];
  620. break;
  621. default:
  622. break;
  623. }
  624. },
  625. refresh_node: function () {
  626. let me = this;
  627. $("#div_sort_type")[0].style.display = "";
  628. if (preHandleObj.currentNode) {
  629. let sel = $("#select_sort_types")[0];
  630. let idx = -1;
  631. let sortTypeIdx = sort_types.indexOf(preHandleObj.currentNode[JV.PROP_SORT_TYPE]);
  632. sel.selectedIndex = sortTypeIdx;
  633. switch (sortTypeIdx) {
  634. case -1:
  635. //unknown!
  636. break;
  637. case 0 :
  638. //normal
  639. $("#div_sort_type_normal")[0].style.display = "";
  640. idx = pre_handle_data_objects.indexOf(preHandleObj.currentNode[JV.PROP_DATA_KEY]);
  641. me.normalTreeObj = $.fn.zTree.init($("#pre_handle_sort_keys_reversed"), sortingKeysSetting, exposed_properties_arr[idx]);
  642. let nodes = me.normalTreeObj.getNodes();
  643. for (let sortItem of preHandleObj.currentNode[JV.PROP_SORT_KEYS]) {
  644. for (let keyNode of nodes) {
  645. if (sortItem.key === keyNode.Key) {
  646. me.normalTreeObj.checkNode(keyNode, true, false, false);
  647. break;
  648. }
  649. }
  650. }
  651. break;
  652. case 1 :
  653. //tree
  654. //tree排序是我们特有的数据结构方式,与数据结构有关,非common用
  655. $("#div_sort_tree")[0].style.display = "";
  656. me.topBillsTreeObj = $.fn.zTree.init($("#bills_top_nodes"), sortingTreeSetting, fixed_top_bills_nodes);
  657. let topBillnodes = me.topBillsTreeObj.getNodes();
  658. if (preHandleObj.currentNode[JV.PROP_FILTER_TOP_BILLS_NODES]) {
  659. for (let topBillsNodeId of preHandleObj.currentNode[JV.PROP_FILTER_TOP_BILLS_NODES]) {
  660. for (let topBillsNode of topBillnodes) {
  661. if (topBillsNode.Value === topBillsNodeId) {
  662. me.topBillsTreeObj.checkNode(topBillsNode, true, false, false);
  663. break;
  664. }
  665. }
  666. }
  667. } else {
  668. preHandleObj.currentNode[JV.PROP_FILTER_TOP_BILLS_NODES] = [];
  669. }
  670. me.otherBillsTreeObj = $.fn.zTree.init($("#bills_other_nodes"), sortingTreeSetting2, fixed_other_bills_types);
  671. let otherBillnodes = me.otherBillsTreeObj.getNodes();
  672. if (preHandleObj.currentNode[JV.PROP_FILTER_OTHER_BILLS_NODES]) {
  673. for (let otherBillsNodeId of preHandleObj.currentNode[JV.PROP_FILTER_OTHER_BILLS_NODES]) {
  674. for (let otherBillsNode of otherBillnodes) {
  675. if (otherBillsNode.Value === otherBillsNodeId) {
  676. me.otherBillsTreeObj.checkNode(otherBillsNode, true, false, false);
  677. break;
  678. }
  679. }
  680. }
  681. } else {
  682. preHandleObj.currentNode[JV.PROP_FILTER_OTHER_BILLS_NODES] = [];
  683. }
  684. break;
  685. case 2 :
  686. //according to parent
  687. $("#div_sort_type_according_to_parent")[0].style.display = "";
  688. $("#div_sort_type_parent_data")[0].style.display = "";
  689. sel = $("#select_mapping_data_for_sort_type")[0];
  690. idx = pre_handle_data_objects.indexOf(preHandleObj.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_DATA_KEY]);
  691. sel.selectedIndex = idx;
  692. me.parentTreeObj = $.fn.zTree.init($("#parent_sorting_keys"), sortingKeysSetting, exposed_properties_arr[idx]);
  693. me.checkupNode(preHandleObj.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS], me.parentTreeObj);
  694. idx = pre_handle_data_objects.indexOf(preHandleObj.currentNode[JV.PROP_DATA_KEY]);
  695. me.childTreeObj = $.fn.zTree.init($("#child_sorting_keys"), sortingKeysSetting, exposed_properties_arr[idx]);
  696. me.checkupNode(preHandleObj.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS], me.childTreeObj);
  697. break;
  698. case 3 :
  699. //self define
  700. $("#div_sort_self_define")[0].style.display = "";
  701. $("#selfDefineSort")[0].value = preHandleObj.currentNode[JV.PROP_SORT_TYPE_SELF_DEFINE_LOGIC];
  702. break;
  703. default:
  704. break;
  705. }
  706. }
  707. },
  708. checkupNode: function(keysArr, treeObj) {
  709. let nodes = treeObj.getNodes();
  710. for (let key of keysArr) {
  711. for (let node of nodes) {
  712. if (node.Key === key) {
  713. treeObj.checkNode(node, true, false, false);
  714. break;
  715. }
  716. }
  717. }
  718. },
  719. onCheck: function(event,treeId,treeNode) {
  720. let me = preHandleSortObj;
  721. if (treeId.indexOf("parent_sorting_keys") >= 0) {
  722. me.resetParentSort();
  723. } else if (treeId.indexOf("child_sorting_keys") >= 0) {
  724. me.resetChildSort();
  725. } else {
  726. me.resetNormalSort();
  727. }
  728. },
  729. onTopBillsNodeCheck: function (event,treeId,treeNode) {
  730. let me = preHandleSortObj;
  731. if (treeNode.checked) {
  732. if (preHandleObj.currentNode[JV.PROP_FILTER_TOP_BILLS_NODES].indexOf(treeNode.Value) < 0) {
  733. preHandleObj.currentNode[JV.PROP_FILTER_TOP_BILLS_NODES].push(treeNode.Value);
  734. }
  735. } else {
  736. let idx = preHandleObj.currentNode[JV.PROP_FILTER_TOP_BILLS_NODES].indexOf(treeNode.Value);
  737. if (idx >= 0) {
  738. preHandleObj.currentNode[JV.PROP_FILTER_TOP_BILLS_NODES].splice(idx, 1);
  739. }
  740. }
  741. },
  742. onOtherBillsNodeCheck: function (event,treeId,treeNode) {
  743. let me = preHandleSortObj;
  744. if (treeNode.checked) {
  745. if (preHandleObj.currentNode[JV.PROP_FILTER_OTHER_BILLS_NODES].indexOf(treeNode.Value) < 0) {
  746. preHandleObj.currentNode[JV.PROP_FILTER_OTHER_BILLS_NODES].push(treeNode.Value);
  747. }
  748. } else {
  749. let idx = preHandleObj.currentNode[JV.PROP_FILTER_OTHER_BILLS_NODES].indexOf(treeNode.Value);
  750. if (idx >= 0) {
  751. preHandleObj.currentNode[JV.PROP_FILTER_OTHER_BILLS_NODES].splice(idx, 1);
  752. }
  753. }
  754. },
  755. resetParentSort: function () {
  756. let me = preHandleSortObj;
  757. let nodes = me.parentTreeObj.getCheckedNodes();
  758. let sortKeys = [];
  759. for (let node of nodes) {
  760. sortKeys.push(node.Key);
  761. }
  762. preHandleObj.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS] = sortKeys;
  763. },
  764. resetChildSort: function () {
  765. let me = preHandleSortObj;
  766. let nodes = me.childTreeObj.getCheckedNodes();
  767. let sortKeys = [];
  768. for (let node of nodes) {
  769. sortKeys.push(node.Key);
  770. }
  771. preHandleObj.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS] = sortKeys;
  772. },
  773. resetNormalSort: function() {
  774. let me = preHandleSortObj;
  775. let nodes = me.normalTreeObj.getCheckedNodes();
  776. let normalSortKeys = [];
  777. for (let node of nodes) {
  778. let keyObj = {key: node.Key, order: node.Order};
  779. normalSortKeys.push(keyObj);
  780. }
  781. preHandleObj.currentNode[JV.PROP_SORT_KEYS] = normalSortKeys;
  782. },
  783. addDiyDom: function(treeId,treeNode) {
  784. let aObj = $("#" + treeNode.tId + IDMark_A);
  785. let editStr = "<select class='selDemo' id='diySelect_" +treeNode.tId+ "'><option value='ascend'>升序 </option><option value='descend'>降序 </option></select>";
  786. aObj.after(editStr);
  787. let sel = $("#diySelect_" + treeNode.tId);
  788. if (sel) {
  789. sel.bind("change", function(){
  790. treeNode.Order = sel[0].value;
  791. preHandleSortObj.resetNormalSort();
  792. });
  793. }
  794. },
  795. onSortTypeChange: function(dom) {
  796. //排序类型的选择/更改
  797. let me = preHandleObj;
  798. me.hide_all_dom();
  799. $("#div_pre_handle_data")[0].style.display = "";
  800. $("#div_sort_type")[0].style.display = "";
  801. let data_dom = $("#select_mapping_data")[0];
  802. if (dom.selectedIndex === 2) {
  803. $("#div_sort_type_according_to_parent")[0].style.display = "";
  804. $("#div_sort_type_parent_data")[0].style.display = "";
  805. preHandleSortObj.parentTreeObj = $.fn.zTree.init($("#parent_sorting_keys"), sortingKeysSetting, exposed_properties_arr[0]);
  806. preHandleSortObj.childTreeObj = $.fn.zTree.init($("#child_sorting_keys"), sortingKeysSetting, exposed_properties_arr[data_dom.selectedIndex]);
  807. me.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY] = {};
  808. me.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_DATA_KEY] = pre_handle_data_objects[0];
  809. me.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_PARENT_SORT_KEYS] = [];
  810. me.currentNode[JV.PROP_PARENT_CHILD_SORT_KEY][JV.PROP_CHILD_SORT_KEYS] = [];
  811. me.currentNode[JV.PROP_OTHER_SUB_SORT] = [];
  812. } else if (dom.selectedIndex === 0) {
  813. $("#div_sort_type_normal")[0].style.display = "";
  814. preHandleSortObj.normalTreeObj = $.fn.zTree.init($("#pre_handle_sort_keys_reversed"), sortingKeysSetting, exposed_properties_arr[data_dom.selectedIndex]);
  815. me.currentNode[JV.PROP_SORT_KEYS] = [];
  816. } else if (dom.selectedIndex === 1) {
  817. $("#div_sort_tree")[0].style.display = "";
  818. preHandleSortObj.normalTreeObj = $.fn.zTree.init($("#bills_top_nodes"), sortingTreeSetting, fixed_top_bills_nodes);
  819. } else {
  820. //自定义
  821. $("#div_sort_self_define")[0].style.display = "";
  822. $("#selfDefineSort")[0].value = "";
  823. me.currentNode[JV.PROP_SORT_TYPE_SELF_DEFINE_LOGIC] = '';
  824. }
  825. me.currentNode[JV.PROP_SORT_TYPE] = dom.value;
  826. },
  827. changeSelfDefineExpression: function (dom) {
  828. let me = preHandleObj;
  829. if (me.currentNode) {
  830. me.currentNode[JV.PROP_SORT_TYPE_SELF_DEFINE_LOGIC] = dom.value;
  831. }
  832. },
  833. extractTabFields: function (handleObj) {
  834. let me = this, rst = {};
  835. rst[JV.PROP_HANDLE_TYPE] = handleObj[JV.PROP_HANDLE_TYPE];
  836. rst[JV.PROP_DATA_KEY] = handleObj[JV.PROP_DATA_KEY];
  837. rst[JV.PROP_SORT_TYPE] = handleObj[JV.PROP_SORT_TYPE];
  838. switch (sort_types.indexOf(handleObj[JV.PROP_SORT_TYPE])) {
  839. case -1:
  840. //unknown!
  841. break;
  842. case 0 :
  843. //normal
  844. rst[JV.PROP_SORT_KEYS] = handleObj[JV.PROP_SORT_KEYS];
  845. break;
  846. case 1 :
  847. //tree
  848. rst[JV.PROP_FILTER_TOP_BILLS_NODES] = handleObj[JV.PROP_FILTER_TOP_BILLS_NODES];
  849. rst[JV.PROP_FILTER_OTHER_BILLS_NODES] = handleObj[JV.PROP_FILTER_OTHER_BILLS_NODES];
  850. break;
  851. case 2 :
  852. //according to parent
  853. rst[JV.PROP_PARENT_CHILD_SORT_KEY] = handleObj[JV.PROP_PARENT_CHILD_SORT_KEY];
  854. rst[JV.PROP_OTHER_SUB_SORT] = [];
  855. if (handleObj.items && handleObj.items.length > 0) {
  856. for (let subSort of handleObj.items) {
  857. let dtlRst = {};
  858. me.copyNode(subSort, dtlRst);
  859. delete dtlRst.Name;
  860. delete dtlRst.PROP_DATA_KEY;
  861. rst[JV.PROP_OTHER_SUB_SORT].push(dtlRst);
  862. dtlRst = null;
  863. }
  864. }
  865. break;
  866. case 3 :
  867. //self define
  868. rst[JV.PROP_SORT_TYPE_SELF_DEFINE_LOGIC] = handleObj[JV.PROP_SORT_TYPE_SELF_DEFINE_LOGIC];
  869. break;
  870. default:
  871. break;
  872. }
  873. return rst;
  874. }
  875. };
  876. let preHandleFilterObj = {
  877. treeObj: null,
  878. copyNode: function (src, dest) {
  879. let me = preHandleFilterObj, keys = [];
  880. for (let filterItem of src[JV.PROP_FILTER_KEYS]) {
  881. let item = {key: filterItem.key};
  882. item[JV.PROP_FILTER_CONDITION] = filterItem[JV.PROP_FILTER_CONDITION];
  883. item[JV.PROP_FILTER_COMPARE_VAL] = filterItem[JV.PROP_FILTER_COMPARE_VAL];
  884. if (filterItem[JV.PROP_FILTER_COMPARE_OBJ]) {
  885. item[JV.PROP_FILTER_COMPARE_OBJ] = filterItem[JV.PROP_FILTER_COMPARE_OBJ];
  886. item[JV.PROP_FILTER_COMPARE_OBJ_KEY] = filterItem[JV.PROP_FILTER_COMPARE_OBJ_KEY];
  887. }
  888. keys.push(item);
  889. }
  890. dest[JV.PROP_HANDLE_TYPE] = src[JV.PROP_HANDLE_TYPE];
  891. dest[JV.PROP_DATA_KEY] = src[JV.PROP_DATA_KEY];
  892. dest[JV.PROP_FILTER_KEYS] = keys;
  893. if (src[JV.PROP_OTHER_SUB_FILTER] && src[JV.PROP_OTHER_SUB_FILTER].length > 0) {
  894. dest.items = [];
  895. for (let subFilter of src[JV.PROP_OTHER_SUB_FILTER]) {
  896. let dtlRst = {Name: "子过滤", Title: ""};
  897. subFilter[JV.PROP_DATA_KEY] = src[JV.PROP_DATA_KEY];
  898. me.copyNode(subFilter, dtlRst);
  899. dtlRst[JV.PROP_HANDLE_TYPE] = src[JV.PROP_HANDLE_TYPE];
  900. dtlRst[JV.PROP_DATA_KEY] = src[JV.PROP_DATA_KEY];
  901. dest.items.push(dtlRst);
  902. }
  903. }
  904. },
  905. refresh_node: function () {
  906. let me = this;
  907. $("#div_filter_type")[0].style.display = "";
  908. if (preHandleObj.currentNode) {
  909. let idx = pre_handle_data_objects.indexOf(preHandleObj.currentNode[JV.PROP_DATA_KEY]);
  910. me.treeObj = $.fn.zTree.init($("#pre_handle_filter_keys_reversed"), filterKeysSetting, exposed_properties_arr[idx]);
  911. let nodes = me.treeObj.getNodes();
  912. for (let filterItem of preHandleObj.currentNode[JV.PROP_FILTER_KEYS]) {
  913. for (let keyNode of nodes) {
  914. if (filterItem.key === keyNode.Key) {
  915. me.treeObj.checkNode(keyNode, true, false, false);
  916. //and then others...
  917. //过滤条件
  918. keyNode[JV.PROP_FILTER_CONDITION] = filterItem[JV.PROP_FILTER_CONDITION];
  919. if (keyNode.isBoolean) {
  920. keyNode[JV.PROP_FILTER_COMPARE_VAL] = filterItem[JV.PROP_FILTER_COMPARE_VAL];
  921. $("#diyCheck_" + keyNode.tId)[0].checked = (keyNode["booleanOptions"].indexOf(filterItem["compareValue"]) === 0);
  922. } else if (keyNode.hasOwnProperty("individualType")) {
  923. $("#diySelect_" + keyNode.tId)[0].selectedIndex = condition_types.indexOf(filterItem[JV.PROP_FILTER_CONDITION]);
  924. //条件值
  925. keyNode[JV.PROP_FILTER_COMPARE_VAL] = filterItem[JV.PROP_FILTER_COMPARE_VAL];
  926. $("#diyInput_" + keyNode.tId)[0].value = filterItem[JV.PROP_FILTER_COMPARE_VAL];
  927. for (let idx = 0; idx < keyNode["individualType"].length; idx++) {
  928. let idType = keyNode["individualType"][idx];
  929. if (idType.Value.toString() === filterItem[JV.PROP_FILTER_COMPARE_VAL].toString()) {
  930. $("#diyDataDetailSelect_" + keyNode.tId)[0].selectedIndex = idx;
  931. break;
  932. }
  933. }
  934. } else {
  935. $("#diySelect_" + keyNode.tId)[0].selectedIndex = condition_types.indexOf(filterItem[JV.PROP_FILTER_CONDITION]);
  936. //条件值
  937. keyNode[JV.PROP_FILTER_COMPARE_VAL] = filterItem[JV.PROP_FILTER_COMPARE_VAL];
  938. $("#diyInput_" + keyNode.tId)[0].value = filterItem[JV.PROP_FILTER_COMPARE_VAL];
  939. //其他关联业务数据对象
  940. if (filterItem[JV.PROP_FILTER_COMPARE_OBJ]) {
  941. let cmpObjDom = $("#diyDataSelect_" + keyNode.tId)[0];
  942. keyNode[JV.PROP_FILTER_COMPARE_OBJ] = filterItem[JV.PROP_FILTER_COMPARE_OBJ];
  943. let idx = pre_handle_data_objects.indexOf(filterItem[JV.PROP_FILTER_COMPARE_OBJ]);
  944. cmpObjDom.selectedIndex = idx + 1;
  945. me.private_setup_compare_obj(cmpObjDom);
  946. let cmpObjIdDom = $("#diyDataDetailSelect_" + keyNode.tId)[0];
  947. for (let i = 0; i < cmpObjIdDom.children.length; i++) {
  948. let option = cmpObjIdDom.children[i];
  949. if (option.value === filterItem[JV.PROP_FILTER_COMPARE_OBJ_KEY]) {
  950. keyNode[JV.PROP_FILTER_COMPARE_OBJ_KEY] = filterItem[JV.PROP_FILTER_COMPARE_OBJ_KEY]
  951. cmpObjIdDom.selectedIndex = i;
  952. break;
  953. }
  954. }
  955. }
  956. }
  957. break;
  958. }
  959. }
  960. }
  961. }
  962. },
  963. onCheck: function(event,treeId,treeNode) {
  964. let me = preHandleFilterObj;
  965. me.resetFilter();
  966. },
  967. resetFilter: function() {
  968. let me = this;
  969. let nodes = me.treeObj.getCheckedNodes();
  970. let normalSortKeys = [];
  971. for (let node of nodes) {
  972. let keyObj = {key: node.Key};
  973. if (!node[JV.PROP_FILTER_CONDITION]) {
  974. node[JV.PROP_FILTER_CONDITION] = "==";
  975. }
  976. keyObj[JV.PROP_FILTER_CONDITION] = node[JV.PROP_FILTER_CONDITION];
  977. keyObj[JV.PROP_FILTER_COMPARE_VAL] = node[JV.PROP_FILTER_COMPARE_VAL];
  978. if (node[JV.PROP_FILTER_COMPARE_OBJ]) {
  979. keyObj[JV.PROP_FILTER_COMPARE_OBJ] = node[JV.PROP_FILTER_COMPARE_OBJ];
  980. keyObj[JV.PROP_FILTER_COMPARE_OBJ_KEY] = node[JV.PROP_FILTER_COMPARE_OBJ_KEY];
  981. }
  982. normalSortKeys.push(keyObj);
  983. }
  984. preHandleObj.currentNode[JV.PROP_FILTER_KEYS] = normalSortKeys;
  985. },
  986. build_filter_handle_data_selection_str: function(treeId,treeNode) {
  987. let rst = [];
  988. rst.push("<select class='selDemo' id='diyDataSelect_" + treeNode.tId + "'>");
  989. rst.push("<option value='empty'>无</option>");
  990. for (let i = 0; i < pre_handle_data_objects.length; i++) {
  991. rst.push("<option value='" + pre_handle_data_objects[i] + "'>" + pre_handle_data_objects_name[i] + "</option>");
  992. }
  993. rst.push("</select>");
  994. return rst.join("");
  995. },
  996. build_filter_handle_data_detail_selection_str: function(treeId,treeNode) {
  997. let rst = [];
  998. rst.push("<select class='selDemo' id='diyDataDetailSelect_" + treeNode.tId + "'>");
  999. rst.push("</select>");
  1000. return rst.join("");
  1001. },
  1002. build_individual_filter_selection_str: function (individualTypes,treeNode) {
  1003. let rst = [];
  1004. rst.push("<select class='selDemo' id='diyDataDetailSelect_" + treeNode.tId + "'>");
  1005. for (let i = 0; i < individualTypes.length; i++) {
  1006. rst.push("<option value='" + individualTypes[i].Value + "'>" + individualTypes[i].Name + "</option>");
  1007. }
  1008. rst.push("</select>");
  1009. return rst.join("");
  1010. },
  1011. addDiyDom: function(treeId,treeNode) {
  1012. let me = preHandleFilterObj;
  1013. let aObj = $("#" + treeNode.tId + IDMark_A);
  1014. if (treeNode.hasOwnProperty("isBoolean")) {
  1015. let checkStr = "<input type='checkbox' id='diyCheck_" + treeNode.tId + "' />";
  1016. aObj.after(checkStr);
  1017. let sel = $("#diyCheck_" + treeNode.tId);
  1018. if (sel) {
  1019. sel.bind("change", me.filterConditionCheck);
  1020. }
  1021. } else if (treeNode.hasOwnProperty("individualType")) {
  1022. let dataDtlSelStr = me.build_individual_filter_selection_str(treeNode.individualType, treeNode);
  1023. aObj.after(dataDtlSelStr);
  1024. let editStr = "<input type='text' id='diyInput_" + treeNode.tId + "' width='10'/>";
  1025. aObj.after(editStr);
  1026. 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>";
  1027. aObj.after(selStr);
  1028. let sel = $("#diySelect_" + treeNode.tId);
  1029. if (sel) {
  1030. sel.bind("change", me.filterConditionChange);
  1031. }
  1032. sel = $("#diyInput_" + treeNode.tId);
  1033. if (sel) {
  1034. sel.bind("change", me.filterCompareValChange);
  1035. }
  1036. sel = $("#diyDataDetailSelect_" + treeNode.tId);
  1037. if (sel) {
  1038. sel.bind("change", me.filterIndividualCompareObjKeyChange);
  1039. }
  1040. } else {
  1041. //注意:这是后面的DOM先生成
  1042. let dataDtlSelStr = me.build_filter_handle_data_detail_selection_str(treeId,treeNode);
  1043. aObj.after(dataDtlSelStr);
  1044. let dataSelStr = me.build_filter_handle_data_selection_str(treeId,treeNode);
  1045. aObj.after(dataSelStr);
  1046. let editStr = "<input type='text' id='diyInput_" + treeNode.tId + "' width='10'/>";
  1047. aObj.after(editStr);
  1048. 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>";
  1049. aObj.after(selStr);
  1050. let sel = $("#diySelect_" + treeNode.tId);
  1051. if (sel) {
  1052. sel.bind("change", me.filterConditionChange);
  1053. }
  1054. sel = $("#diyInput_" + treeNode.tId);
  1055. if (sel) {
  1056. sel.bind("change", me.filterCompareValChange);
  1057. }
  1058. sel = $("#diyDataSelect_" + treeNode.tId);
  1059. if (sel) {
  1060. sel.bind("change", me.filterCompareObjChange);
  1061. }
  1062. sel = $("#diyDataDetailSelect_" + treeNode.tId);
  1063. if (sel) {
  1064. sel.bind("change", me.filterCompareObjKeyChange);
  1065. }
  1066. }
  1067. },
  1068. filterCompareValChange(event) {
  1069. let me = preHandleFilterObj, sel = event.currentTarget, tId = sel.id.slice(9);
  1070. let node = me.treeObj.getNodeByTId(tId);
  1071. node[JV.PROP_FILTER_COMPARE_VAL] = sel.value;
  1072. me.resetFilter();
  1073. },
  1074. filterConditionCheck: function (event) {
  1075. let me = preHandleFilterObj, sel = event.currentTarget, tId = sel.id.slice(9);
  1076. let node = me.treeObj.getNodeByTId(tId);
  1077. node[JV.PROP_FILTER_CONDITION] = "===";
  1078. if (sel.checked === true) {
  1079. node[JV.PROP_FILTER_COMPARE_VAL] = node.booleanOptions[0];
  1080. } else {
  1081. node[JV.PROP_FILTER_COMPARE_VAL] = node.booleanOptions[1];
  1082. }
  1083. //注:这里虽然是boolean选项,但实际有可能是0,1的选择(非true,false),所以需要设置node节点的booleanOptions
  1084. me.resetFilter();
  1085. },
  1086. filterConditionChange: function(event) {
  1087. let me = preHandleFilterObj, sel = event.currentTarget, tId = sel.id.slice(10);
  1088. let node = me.treeObj.getNodeByTId(tId);
  1089. node[JV.PROP_FILTER_CONDITION] = sel.value;
  1090. me.resetFilter();
  1091. },
  1092. private_setup_compare_obj: function(dom) {
  1093. let me = this, sel = dom, tId = sel.id.slice(14);
  1094. let node = me.treeObj.getNodeByTId(tId);
  1095. node[JV.PROP_FILTER_COMPARE_OBJ] = sel.value;
  1096. let idx = pre_handle_data_objects.indexOf(sel.value);
  1097. let dtlKey = "diyDataDetailSelect_" + tId;
  1098. let dtlSel = document.getElementById(dtlKey);
  1099. dtlSel.length = 0;
  1100. if (idx >= 0) {
  1101. let jdtlSel = $("#" + dtlKey);
  1102. for (let item of exposed_properties_arr[idx]) {
  1103. jdtlSel.append("<option value='" + item.Key + "'>" + item.Name + "</option>");
  1104. }
  1105. } else {
  1106. //清除所有key选项
  1107. node[JV.PROP_FILTER_COMPARE_OBJ_KEY] = null;
  1108. }
  1109. },
  1110. filterCompareObjChange: function(event) {
  1111. let me = preHandleFilterObj, sel = event.currentTarget;
  1112. me.private_setup_compare_obj(sel);
  1113. me.resetFilter();
  1114. },
  1115. filterIndividualCompareObjKeyChange: function(event) {
  1116. let me = preHandleFilterObj, sel = event.currentTarget, tId = sel.id.slice(20);
  1117. let inTxt = $("#diyInput_" + tId);
  1118. if (inTxt) {
  1119. inTxt[0].value = sel.value;
  1120. }
  1121. let node = me.treeObj.getNodeByTId(tId);
  1122. node[JV.PROP_FILTER_COMPARE_VAL] = sel.value;
  1123. me.resetFilter();
  1124. },
  1125. filterCompareObjKeyChange: function(event) {
  1126. let me = preHandleFilterObj, sel = event.currentTarget, tId = sel.id.slice(20);
  1127. let node = me.treeObj.getNodeByTId(tId);
  1128. node[JV.PROP_FILTER_COMPARE_OBJ_KEY] = sel.value;
  1129. me.resetFilter();
  1130. },
  1131. extractTabFields: function (handleObj) {
  1132. let me = preHandleFilterObj, rst = {};
  1133. me.copyNode(handleObj, rst);
  1134. rst[JV.PROP_OTHER_SUB_FILTER] = [];
  1135. let private_extract_other_sub_filter = function (parentFilter, currentFilterNode) {
  1136. let dtlRst = {};
  1137. me.copyNode(currentFilterNode, dtlRst);
  1138. parentFilter[JV.PROP_OTHER_SUB_FILTER].push(dtlRst);
  1139. if (currentFilterNode.items && currentFilterNode.items.length > 0) {
  1140. dtlRst[JV.PROP_OTHER_SUB_FILTER] = [];
  1141. for (let subFilterNode of currentFilterNode.items) {
  1142. private_extract_other_sub_filter(dtlRst, subFilterNode);
  1143. }
  1144. }
  1145. delete dtlRst.Name;
  1146. delete dtlRst[JV.PROP_DATA_KEY];
  1147. dtlRst = null;
  1148. };
  1149. if (handleObj.items && handleObj.items.length > 0) {
  1150. for (let subFilter of handleObj.items) {
  1151. private_extract_other_sub_filter(rst, subFilter);
  1152. }
  1153. }
  1154. return rst;
  1155. }
  1156. };
  1157. let preHandleSummaryObj = {
  1158. copyNode: function (src, dest) {
  1159. //
  1160. },
  1161. refresh_node: function () {
  1162. $("#div_summary_type")[0].style.display = "";
  1163. if (preHandleObj.currentNode) {
  1164. }
  1165. },
  1166. extractTabFields: function (handleObj) {
  1167. let rst = {};
  1168. //
  1169. return rst;
  1170. }
  1171. };
  1172. let preHandleAdjustObj = {
  1173. copyNode: function (src, dest) {
  1174. //
  1175. },
  1176. refresh_node: function () {
  1177. $("#div_adjust_type")[0].style.display = "";
  1178. if (preHandleObj.currentNode) {
  1179. }
  1180. },
  1181. extractTabFields: function (handleObj) {
  1182. let rst = {};
  1183. //
  1184. return rst;
  1185. }
  1186. };
  1187. let preHandleAddDummyObj = {
  1188. copyNode: function (src, dest) {
  1189. //
  1190. },
  1191. refresh_node: function () {
  1192. $("#div_add_dummy_type")[0].style.display = "";
  1193. if (preHandleObj.currentNode) {
  1194. }
  1195. },
  1196. extractTabFields: function (handleObj) {
  1197. let rst = {};
  1198. //
  1199. return rst;
  1200. }
  1201. };