glj.js 56 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223
  1. /**
  2. * Created by Zhong on 2017/8/14.
  3. */
  4. let pageOprObj = {
  5. gljLibName : null,
  6. gljLibId: null,
  7. initPage : function(container, containerComponent) {
  8. let me = this, gljLibId = getQueryString("gljLibId");//获取定额库参数
  9. me.gljLibId = gljLibId;
  10. repositoryGljObj.getGljLib(gljLibId, function () {
  11. repositoryGljObj.buildSheet(container);
  12. gljComponentOprObj.buildSheet(containerComponent);
  13. //获得定额库中引用此工料机库中的,所有被定额所套的工料机的ID
  14. //repositoryGljObj.getRationGljIds(gljLibId);
  15. repositoryGljObj.getGljDistType(function () {
  16. repositoryGljObj.currentRepositoryId = parseInt(gljLibId);
  17. repositoryGljObj.getGljTree(gljLibId, function () {
  18. repositoryGljObj.getGljItems(gljLibId);
  19. });
  20. });
  21. });
  22. }
  23. }
  24. let repositoryGljObj = {
  25. treeObj : null,
  26. workBook: null,
  27. gljCurTypeId: -1,
  28. currentRepositoryId: -1,
  29. currentCache: null,
  30. parentNodeIds: {},
  31. gljList: [],
  32. allowComponent: [202, 203, 204, 301],//可带组成物类型:混凝土、砂浆、配合比、机械台班
  33. componentGljType: [201, 302, 303],//可成为组成物的工料机类型: 普通材料、 机械组成物、 机上人工
  34. distTypeTree: null,//add
  35. setting: {
  36. owner: "glj",
  37. header:[
  38. {headerName:"编码",headerWidth:120,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  39. {headerName:"名称",headerWidth:260,dataCode:"name", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  40. {headerName:"规格型号",headerWidth:220,dataCode:"specs", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  41. {headerName:"单位",headerWidth:120,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"},
  42. {headerName:"基价单价",headerWidth:120,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"},
  43. {headerName:"类型",headerWidth:120,dataCode:"gljType", dataType: "String", hAlign: "center", vAlign: "center"},
  44. {headerName:"调整系数",headerWidth:80,dataCode:"adjCoe", dataType: "Number", hAlign: "center", vAlign: "center"},
  45. ],
  46. view:{
  47. comboBox:[
  48. {row:-1,col:3,rowCount:-1,colCount:1}
  49. ],
  50. lockedCells:[
  51. ]
  52. }
  53. },
  54. getComboData: function (gljDistType) {
  55. let me = this;
  56. let distType;
  57. let distTypeTree = {
  58. prefix : 'gljType',
  59. distTypes: {},
  60. comboDatas: [],
  61. distTypesArr: []
  62. };
  63. gljDistType.forEach(function (typeData) {
  64. let typeObj = {
  65. data: typeData,
  66. children: [],
  67. parent: null
  68. }
  69. distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
  70. distTypeTree.distTypesArr.push(typeObj);
  71. });
  72. gljDistType.forEach(function (typeData) {
  73. distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
  74. let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
  75. if(parent){
  76. distType.parent = parent;
  77. parent.children.push(distType);
  78. }
  79. });
  80. distTypeTree.distTypesArr.forEach(function (distTypeObj) {
  81. if(distTypeObj.data.fullName !== '材料' && distTypeObj.data.fullName !== '机械'){
  82. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  83. }
  84. });
  85. return distTypeTree;
  86. },
  87. getGljDistType: function (callback) {
  88. let me = this;
  89. $.ajax({
  90. type: 'post',
  91. url: "api/getGljDistType",
  92. dataType: 'json',
  93. success: function (result) {
  94. if(!result.error && callback){
  95. me.distTypeTree = me.getComboData(result.data);
  96. console.log(me.distTypeTree);
  97. callback();
  98. }
  99. }
  100. })
  101. },
  102. getGljLib: function (libId, callback) {
  103. let me = repositoryGljObj;
  104. $.ajax({
  105. type: 'post',
  106. url: 'api/getGljLib',
  107. data: {libId: libId},
  108. dataType: 'json',
  109. success: function (result) {
  110. if(!result.error){
  111. if(result.data.length > 0){
  112. me.rationLibs = result.data[0].rationLibs;
  113. $(".navbar-text").append(
  114. "<a href='/stdGljRepository/main'>工料机库</a><i class='fa fa-angle-right fa-fw'></i>"+result.data[0].dispName
  115. );
  116. pageOprObj.gljLibName = result.data[0].dispName;
  117. }
  118. callback();
  119. }
  120. }
  121. })
  122. },
  123. getGljTree: function(gljLibId, callback) {
  124. let me = this;
  125. $.ajax({
  126. type:"POST",
  127. url:"api/getGljTree",
  128. data:{"gljLibId": gljLibId},
  129. dataType:"json",
  130. cache:false,
  131. timeout:20000,
  132. success:function(result,textStatus,status){
  133. if(status.status == 200) {
  134. zTreeHelper.createTree(result.data, gljSetting, "repositoryTree", me);
  135. if (result.data && result.data.length > 0) {
  136. me.gljCurTypeId = result.data[0].ID;
  137. } else {
  138. //重新创建库?
  139. gljTypeTreeOprObj.addRootNode();
  140. }
  141. callback();
  142. }
  143. },
  144. error:function(err){
  145. alert(err.responseJSON.error);
  146. }
  147. })
  148. },
  149. getGljItems: function(repId) {
  150. let me = this;
  151. $.ajax({
  152. type:"POST",
  153. url:"api/getGljItems",
  154. data:{"repositoryId": repId},
  155. dataType:"json",
  156. cache:false,
  157. timeout:5000,
  158. success:function(result){
  159. if(!result.error) {
  160. me.gljList = result.data;
  161. me.workBook.getSheet(0).setRowCount(result.data.length);
  162. me.sortGlj();
  163. me.currentGlj = me.gljList.length > 0 ? me.gljList[0] : null;//初始
  164. let rootNode = me.treeObj.getNodes()[0];
  165. if(rootNode && rootNode.isParent && rootNode.isFirstNode){
  166. me.treeObj.selectNode(rootNode);
  167. gljTypeTreeOprObj.onClick(null, 'repositoryTree', rootNode);
  168. }
  169. }
  170. },
  171. error:function(err){
  172. alert(err.responseJSON.error);
  173. }
  174. })
  175. },
  176. showGljItems: function(data, type) {
  177. let me = repositoryGljObj;
  178. if (me.workBook) {
  179. let cacheSection = [];
  180. let pArr = me.parentNodeIds["_pNodeId_" + type];
  181. for (let i = 0; i < data.length; i++) {
  182. if (pArr && pArr.indexOf(data[i].gljClass) >= 0) {
  183. cacheSection.push(data[i]);
  184. } else if (type == data[i].gljClass) {
  185. cacheSection.push(data[i]);
  186. }
  187. }
  188. sheetCommonObj.cleanData(me.workBook.getSheet(0), me.setting, -1);
  189. sheetsOprObj.showData(me.workBook.getSheet(0), me.setting, cacheSection, me.distTypeTree);
  190. sheetCommonObj.setStaticCombo(me.workBook.getActiveSheet(), 0, 5, cacheSection.length, me.distTypeTree.comboDatas, false, 'text');
  191. sheetCommonObj.setDynamicCombo(me.workBook.getActiveSheet(), cacheSection.length, 5, me.workBook.getActiveSheet().getRowCount() - cacheSection.length, me.distTypeTree.comboDatas, false, 'text');
  192. cacheSection = null;
  193. }
  194. },
  195. buildSheet: function(container) {
  196. let me = repositoryGljObj;
  197. me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30, me);
  198. me.repositoryGljDelOpr();
  199. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  200. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
  201. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditStarting, me.onCellEditStart);
  202. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd);
  203. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onEnterCell);
  204. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.SelectionChanged, me.onSelectionChanged);
  205. },
  206. getCurrentComponent: function (gljComponent) {
  207. let me = repositoryGljObj, rst = [];
  208. for(let i = 0; i < gljComponent.length; i++){
  209. let obj = {};
  210. for(let j = 0; j < me.gljList.length; j++){
  211. if(gljComponent[i].ID == me.gljList[j].ID){
  212. obj.ID = me.gljList[j].ID;
  213. obj.code = me.gljList[j].code;
  214. obj.name = me.gljList[j].name;
  215. obj.unit = me.gljList[j].unit;
  216. obj.basePrice = me.gljList[j].basePrice;
  217. obj.consumeAmt = gljComponent[i].consumeAmt;
  218. rst.push(obj);
  219. }
  220. }
  221. }
  222. rst.sort(function (a, b) {
  223. let r = 0;
  224. if(a.code > b.code) r = 1;
  225. else if(a.code < b.code) r = -1;
  226. return r;
  227. });
  228. return rst;
  229. },
  230. //获得引用了组成物id为componentId的工料机,和重新变化组成物数组、重新计算单价
  231. getUpdateGljs: function (rObj, isDelete) {
  232. let me = repositoryGljObj, that = gljComponentOprObj,
  233. rst = {updateArr: [], updateBasePrcArr: []};
  234. //改变单价,以便reCalGljBasePrc方法可行
  235. if(!isDelete){
  236. for(let i = 0; i < me.gljList.length; i++){
  237. if(me.gljList[i].ID === rObj.ID){
  238. me.gljList[i].basePrice = rObj.basePrice;
  239. break;
  240. }
  241. }
  242. }
  243. for(let i = 0; i < me.gljList.length; i++){
  244. let thisComponent = me.gljList[i].component, isChange = false;
  245. for(let j = 0; j < thisComponent.length; j++){
  246. if(thisComponent[j].ID === rObj.ID){
  247. //删除
  248. isChange = true;
  249. if(isDelete){
  250. thisComponent.splice(j--, 1);
  251. }
  252. else {
  253. break;
  254. }
  255. }
  256. }
  257. if(isChange){//引用了此组成物
  258. let gljBasePrc = that.reCalGljBasePrc(me.getCurrentComponent(thisComponent));
  259. if(me.gljList[i].basePrice !== gljBasePrc){
  260. me.gljList[i].basePrice = gljBasePrc;
  261. rst.updateBasePrcArr.push({gljId: me.gljList[i].ID, gljType: me.gljList[i].gljType, basePrice: me.gljList[i].basePrice});
  262. }
  263. rst.updateArr.push(me.gljList[i]);
  264. }
  265. }
  266. return rst;
  267. },
  268. reshowGljBasePrc: function (glj) {
  269. let me = repositoryGljObj;
  270. let cacheSection = me.currentCache;
  271. for(let i = 0; i < cacheSection.length; i++){
  272. if(glj.ID === cacheSection[i].ID){
  273. cacheSection[i].basePrice = glj.basePrice;
  274. me.workBook.getSheet(0).setValue(i, 4, glj.basePrice);
  275. break;
  276. }
  277. }
  278. },
  279. onSelectionChanged: function (sender, info) {
  280. let me = repositoryGljObj, that = gljComponentOprObj;
  281. //混凝土202、砂浆203、配合比204、机械3
  282. if(info.oldSelections.length === 0 && info.newSelections.length > 0 || info.oldSelections[0].row !== info.newSelections[0].row){
  283. let row = info.newSelections[0].row;
  284. sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, -1);
  285. me.workBook.focus(true);
  286. me.currentComponent = [];
  287. that.workBook.getSheet(0).setRowCount(5);
  288. if(row < me.currentCache.length){
  289. //标记当前工料机
  290. me.currentGlj = me.currentCache[row];
  291. if(me.allowComponent.indexOf(me.currentCache[row].gljType) !== -1){
  292. //展示数据
  293. if(me.currentGlj.component.length > 0){
  294. me.currentComponent = me.getCurrentComponent(me.currentGlj.component);
  295. if(me.currentComponent.length > 0){
  296. sheetsOprObj.showData(that.workBook.getSheet(0), that.setting, me.currentComponent);
  297. }
  298. }
  299. }
  300. }
  301. else{
  302. me.currentGlj = null;
  303. }
  304. }
  305. },
  306. onEnterCell: function (sender, args) {
  307. let me = repositoryGljObj;
  308. args.sheet.repaint();
  309. me.cellRowIdx = args.row;
  310. let isHasData = false;
  311. if(me.addGljObj){
  312. for(let i=0; i<me.setting.header.length; i++){
  313. if(me.addGljObj[me.setting.header[i].dataCode]){
  314. isHasData = true;
  315. break;
  316. }
  317. }
  318. }
  319. if(isHasData){
  320. if(me.editingRowIdx !== me.cellRowIdx) {
  321. let isComple = true;
  322. let focusToCol;
  323. function getFocusToCol (me){
  324. if(!me.addGljObj[me.setting.header[0].dataCode]){
  325. $('#alertGljTxt').text('编号不能为空,继续增加工料机?');
  326. return 0;
  327. }
  328. else if(!me.addGljObj[me.setting.header[1].dataCode]){
  329. $('#alertGljTxt').text('名称不能为空,继续增加工料机?');
  330. return 1;
  331. }
  332. else if(!me.addGljObj[me.setting.header[5].dataCode]){
  333. $('#alertGljTxt').text('类型不能为空,继续增加工料机?');
  334. return 5;
  335. }
  336. else {
  337. return -1;
  338. }
  339. }
  340. focusToCol = getFocusToCol(me);
  341. if(focusToCol === -1){
  342. }
  343. else {
  344. $('#gljAlertBtn').click();
  345. $('#aleConfBtn').click(function () {
  346. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  347. });
  348. $('#gljAleClose').click(function () {
  349. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  350. });
  351. $('#aleCanceBtn').click(function () {
  352. me.addGljObj = null;
  353. for(let col=0; col<me.setting.header.length; col++){
  354. if(col === 0){
  355. me.workBook.getSheet(0).getCell(me.editingRowIdx, 0).formatter("@");
  356. }
  357. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value('');
  358. }
  359. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, 0);
  360. });
  361. }
  362. }
  363. }
  364. },
  365. onCellEditStart: function(sender, args) {
  366. let me = repositoryGljObj;
  367. let rObj = sheetsOprObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row);
  368. me.currentEditingGlj = rObj;
  369. me.orgCode = me.workBook.getSheet(0).getValue(args.row, 0);
  370. if(args.row < me.currentCache.length){
  371. me.currentGlj = me.currentCache[args.row];
  372. if(args.col === 0 || (args.col === 4 && me.allowComponent.indexOf(me.currentGlj.gljType) !== -1)
  373. || (args.col === 6 && me.currentGlj.gljType !== 1 && me.currentGlj.gljType !== 303)){
  374. args.cancel = true;
  375. }
  376. else {
  377. rObj.ID = me.currentGlj.ID;
  378. rObj.gljClass = me.currentGlj.gljClass;
  379. }
  380. }
  381. else {
  382. me.currentGlj = null;
  383. }
  384. },
  385. onCellEditEnd: function(sender, args) {
  386. let me = repositoryGljObj, that = gljComponentOprObj,
  387. rObj = sheetsOprObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row, me),
  388. updateArr = [], addArr = [], updateBasePrcArr = [];
  389. me.editingRowIdx = args.row;
  390. rObj.basePrice = rObj.basePrice ? rObj.basePrice : 0;
  391. //更新
  392. if (me.currentEditingGlj["ID"] && me.currentGlj) {
  393. rObj["ID"] = me.currentEditingGlj["ID"];
  394. rObj.gljClass = me.currentEditingGlj.gljClass;
  395. if(me.currentEditingGlj[me.setting.header[args.col].dataCode] !== rObj[me.setting.header[args.col].dataCode]){
  396. if(rObj[me.setting.header[0].dataCode] && rObj[me.setting.header[1].dataCode] && rObj[me.setting.header[5].dataCode] &&
  397. rObj[me.setting.header[0].dataCode].toString().trim().length !== 0 && rObj[me.setting.header[1].dataCode].toString().trim().length !== 0 && rObj[me.setting.header[5].dataCode].toString().trim().length !== 0){
  398. if(rObj.gljType !== me.currentEditingGlj.gljType){//修改了工料机类型
  399. if(me.currentGlj){
  400. me.currentGlj.component = [];
  401. }
  402. if(me.allowComponent.indexOf(rObj.gljType) !== -1){
  403. rObj.basePrice = 0;
  404. }
  405. //调整系数,工料机类型为人工和机上人工时,可输入整数
  406. if((me.currentEditingGlj.gljType === 1 || me.currentEditingGlj.gljType === 303) && !(rObj.gljType === 1 || rObj.gljType === 303)){
  407. rObj.adjCoe = null;
  408. }
  409. if(me.componentGljType.indexOf(me.currentEditingGlj.gljType) !== -1 &&
  410. !(me.currentEditingGlj.gljType === 302 && rObj.gljType === 303) && !(me.currentEditingGlj.gljType === 303 && rObj.gljType === 302)){//修改了原本是组成物的工料机
  411. //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价
  412. let updateGljs = me.getUpdateGljs(rObj, true);
  413. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  414. for(let i = 0; i < updateGljs.updateArr.length; i++){
  415. updateArr.push(updateGljs.updateArr[i]);
  416. }
  417. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  418. updateArr.push(updateGljs.updateBasePrcArr[i]);
  419. }
  420. }
  421. }
  422. sheetCommonObj.cleanData(that.workBook.getSheet(0), that.setting, 5);
  423. }
  424. else if(rObj.adjCoe !== me.currentEditingGlj.adjCoe){//修改调整系数,整数控制
  425. if(isNaN(rObj.adjCoe) || rObj.adjCoe % 1 !== 0){
  426. args.sheet.setValue(args.row, args.col, me.currentEditingGlj.adjCoe ? me.currentEditingGlj.adjCoe : '');
  427. alert('调整系数只能输入整数!');
  428. return;
  429. }
  430. }
  431. else if(rObj.basePrice !== me.currentEditingGlj.basePrice){//修改了单价,可修改单价的必为可成为组成物的
  432. //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价
  433. let updateGljs = me.getUpdateGljs(rObj);
  434. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  435. for(let i = 0; i < updateGljs.updateArr.length; i++){
  436. updateArr.push(updateGljs.updateArr[i]);
  437. }
  438. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  439. updateArr.push(updateGljs.updateBasePrcArr[i]);
  440. }
  441. }
  442. rObj.basePrice = !isNaN(parseFloat(rObj.basePrice)) && (rObj.basePrice && typeof rObj.basePrice !== 'undefined') ? that.round(parseFloat(rObj.basePrice), 2) : me.currentEditingGlj.basePrice;
  443. }
  444. rObj.component = me.currentGlj.component;
  445. updateArr.push(rObj);
  446. }
  447. else{
  448. if(me.setting.header[args.col].dataCode === 'gljType'){
  449. let distTypeVal = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj[me.setting.header[args.col].dataCode]].data.fullName;
  450. args.sheet.setValue(args.row, args.col, distTypeVal);
  451. }
  452. else{
  453. args.sheet.setValue(args.row, args.col, me.currentEditingGlj[me.setting.header[args.col].dataCode]);
  454. }
  455. }
  456. }
  457. //--------------------------------------
  458. if(me.currentEditingGlj.basePrice !== rObj.basePrice){
  459. //update basePrice of ration when editting basePrice of glj
  460. let gljType = -1;
  461. let gljTypeParent = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj.gljType].parent;
  462. if(gljTypeParent && gljTypeParent.data.ID <=3){
  463. gljType = gljTypeParent.data.ID;
  464. }
  465. if(!gljTypeParent && me.currentEditingGlj.gljType <= 3){
  466. gljType = me.currentEditingGlj.gljType;
  467. }
  468. let gljBasePrcObj = {gljId: me.currentEditingGlj.ID, gljType: gljType, basePrice: rObj.basePrice};
  469. if(gljBasePrcObj.gljType !== -1){
  470. updateBasePrcArr.push(gljBasePrcObj);
  471. if(me.rationLibs.length > 0){//重算定额单价
  472. me.updateRationBasePrcRq(updateBasePrcArr);
  473. }
  474. }
  475. }
  476. //update basePrice of ration when editting gljType of glj
  477. if(me.currentEditingGlj.gljType !== rObj.gljType){
  478. let gljTypeObj = {gljId: me.currentEditingGlj.ID, gljType: rObj.gljType, basePrice: rObj.basePrice};
  479. updateBasePrcArr.push(gljTypeObj);
  480. if(me.rationLibs.length > 0){
  481. me.updateRationBasePrcRq(updateBasePrcArr);
  482. }
  483. }
  484. //-----------------------------------------------------------
  485. }
  486. //新增
  487. else {
  488. if(typeof rObj.code !== 'undefined'){
  489. me.addGljObj = rObj;
  490. let isCanSav = true;
  491. if(!rObj[me.setting.header[0].dataCode] || !rObj[me.setting.header[1].dataCode] || !rObj[me.setting.header[5].dataCode]){
  492. isCanSav = false;
  493. }
  494. if(isCanSav){
  495. me.addGljObj = null;
  496. rObj.component = [];
  497. //如果类型为混凝土、砂浆、配合比、机械台班时,添加时填写的单价清空
  498. if(me.allowComponent.indexOf(rObj.gljType) !== -1){
  499. rObj.basePrice = 0;
  500. }
  501. rObj.basePrice = !isNaN(parseFloat(rObj.basePrice)) && (rObj.basePrice && typeof rObj.basePrice !== 'undefined') ? parseFloat(rObj.basePrice) : 0;
  502. addArr.push(rObj);
  503. }
  504. }
  505. }
  506. if(me.gljCurTypeId !== 732){
  507. rObj.gljClass = me.gljCurTypeId;
  508. }
  509. if(updateArr.length >0 || addArr.length >0){
  510. me.currentEditingGlj = null;
  511. me.mixUpdateRequest(updateArr, addArr, []);
  512. }
  513. },
  514. repositoryGljDelOpr: function () {
  515. let me = repositoryGljObj;
  516. me.workBook.commandManager().register('repositoryGljDel', function () {
  517. let sheet = me.workBook.getSheet(0),
  518. updateArr = [], removeArr = [],
  519. tempRemoveArr= [],
  520. refGljCodes = [], //已被引用的工料机
  521. updateBasePrcArr = [],//删除基价单位后重新计算
  522. sels = sheet.getSelections(),
  523. canUpdate = false,
  524. cacheSection = me.currentCache;
  525. if(sels.length > 0 && cacheSection.length > 0){
  526. for(let i = 0; i < sels.length; i++){
  527. if(sels[i].colCount === me.setting.header.length){
  528. for(let j = 0; j < sels[i].rowCount; j++){
  529. if(sels[i].row + j < cacheSection.length){
  530. //删除了已被引用成组成物的工料机,重新计算所有引用此组成物的工料机的单价、组成物数组
  531. let updateGljs = me.getUpdateGljs(cacheSection[sels[i].row + j], true);
  532. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  533. for(let i = 0; i < updateGljs.updateArr.length; i++){
  534. updateArr.push(updateGljs.updateArr[i]);
  535. }
  536. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  537. updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]);
  538. }
  539. }
  540. removeArr.push(cacheSection[sels[i].row + j].ID);
  541. //tempRemoveArr.push({ID: cacheSection[sels[i].row + j].ID, code: cacheSection[sels[i].row + j].code});
  542. //删除后重新计算引用了此工料机的定额单价
  543. updateBasePrcArr.push({gljId: cacheSection[sels[i].row + j].ID, gljType: cacheSection[sels[i].row + j].gljType, basePrice: 0, delete: 1});
  544. }
  545. }
  546. }
  547. else{
  548. let maxCol = sels[i].col + sels[i].colCount - 1;
  549. if(sels[i].col >= 2 && maxCol <= 4){
  550. for(let j = 0; j < sels[i].rowCount; j++){
  551. if(sels[i].row + j < cacheSection.length){
  552. let updateObj = cacheSection[sels[i].row + j];
  553. for(let col = sels[i].col; col <= maxCol; col++){
  554. if(me.setting.header[col].dataCode === 'basePrice'){
  555. //如果类型不为混凝土、砂浆、配合比、机械,才可删除单价 basePrice = 0
  556. if(me.allowComponent.indexOf(updateObj.gljType) === -1){
  557. canUpdate = true;
  558. updateObj[me.setting.header[col].dataCode] = 0;
  559. updateBasePrcArr.push({gljId: updateObj.ID, gljType: updateObj.gljType, basePrice: 0});
  560. }
  561. }
  562. else{
  563. canUpdate = true;
  564. updateObj[me.setting.header[col].dataCode] = '';
  565. }
  566. }
  567. if(canUpdate){
  568. updateArr.push(updateObj);
  569. }
  570. }
  571. }
  572. }
  573. //编号、名称、类型不可为空
  574. else{
  575. if(sels[i].row < cacheSection.length){
  576. let text = '', cantNullStr =['编码', '名称', '类型'];
  577. for(let col = sels[i].col; col <= sels[i].col + sels[i].colCount -1; col++){
  578. if(cantNullStr.indexOf(me.setting.header[col].headerName) !== -1){
  579. text += me.setting.header[col].headerName + " ";
  580. }
  581. }
  582. $('#alertText').text(text + "不可为空!");
  583. $('#codeAlertBtn').click();
  584. $('#codAleConfBtn').click(function () {
  585. });
  586. $('#codAleClose').click(function () {
  587. });
  588. }
  589. }
  590. }
  591. }
  592. if(removeArr.length > 0 || updateArr.length > 0){
  593. //删除警告
  594. $('#alertGljTxt').text('可能已有定额引用了当前工料机,导致定额查找不到此工料机。确定要删除吗?');
  595. $('#gljAlertBtn').click();
  596. //确认
  597. $('#aleConfBtn').click(function () {
  598. me.mixUpdateRequest(updateArr, [], removeArr);
  599. if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){
  600. me.updateRationBasePrcRq(updateBasePrcArr);
  601. }
  602. });
  603. }
  604. }
  605. });
  606. me.workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.del, false, false, false, false);
  607. me.workBook.commandManager().setShortcutKey('repositoryGljDel', GC.Spread.Commands.Key.del, false, false, false, false);
  608. },
  609. validUpdateObj: function (pasteObj, rowIdx) {
  610. let rst = {updateGlj: [], updateBasePrcArr: []}, backUpObj = {},
  611. me = repositoryGljObj,
  612. that = gljComponentOprObj,
  613. tempObj = me.currentCache[rowIdx],
  614. reCalBasePrc = false,
  615. isValid = true;
  616. //备份原始数据
  617. for(let atr in tempObj){
  618. backUpObj[atr] = tempObj[atr];
  619. }
  620. if(typeof pasteObj.code !== 'undefined'){
  621. if(pasteObj.code.trim().length !== 0){
  622. let isExist = false;
  623. for(let i = 0; i < me.gljList.length; i++){
  624. if(me.gljList[i].code === pasteObj.code){
  625. isExist = true;
  626. break;
  627. }
  628. }
  629. if(!isExist){
  630. tempObj.code = pasteObj.code;
  631. }
  632. else isValid = false;
  633. }
  634. else isValid = false;
  635. }
  636. if(typeof pasteObj.name !== 'undefined'){
  637. if(pasteObj.name.trim().length === 0) isValid = false;
  638. else tempObj.name = pasteObj.name;
  639. }
  640. if(typeof pasteObj.specs !== 'undefined'){
  641. tempObj.specs = pasteObj.specs;
  642. }
  643. if(typeof pasteObj.unit !== 'undefined'){
  644. tempObj.unit = pasteObj.unit;
  645. }
  646. if(typeof pasteObj.gljType !== 'undefined'){
  647. let isExsit = false;
  648. for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){
  649. if(pasteObj.gljType === me.distTypeTree.comboDatas[i].text){
  650. isExsit = true;
  651. reCalBasePrc = true;
  652. //调整系数
  653. if(me.distTypeTree.comboDatas[i].value !== 1 && me.distTypeTree.comboDatas[i].value !== 303){
  654. tempObj.adjCoe = null;
  655. }
  656. else if((me.distTypeTree.comboDatas[i].value === 1 || me.distTypeTree.comboDatas[i].value === 303) && typeof pasteObj.adjCoe !== 'undefined' && !isNaN(pasteObj.adjCoe) && pasteObj.adjCoe % 1 === 0) {
  657. tempObj.adjCoe = pasteObj.adjCoe;
  658. }
  659. if(me.componentGljType.indexOf(tempObj.gljType) !== -1 &&
  660. !(tempObj.gljType === 302 && pasteObj.gljType === 303) && !(tempObj.gljType === 303 && pasteObj.gljType === 302)){//修改了原本是组成物的工料机
  661. //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价
  662. let updateGljs = me.getUpdateGljs(tempObj, true);
  663. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  664. for(let i = 0; i < updateGljs.updateArr.length; i++){
  665. rst.updateGlj.push(updateGljs.updateArr[i]);
  666. }
  667. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  668. rst.updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]);
  669. }
  670. }
  671. }
  672. tempObj.gljType = me.distTypeTree.comboDatas[i].value;
  673. tempObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + tempObj.gljType].data.shortName;
  674. if(me.allowComponent.indexOf(tempObj.gljType) !== -1){
  675. tempObj.basePrice = 0;
  676. }
  677. break;
  678. }
  679. }
  680. if(!isExsit) {
  681. isValid = false;
  682. }
  683. }
  684. if(typeof pasteObj.adjCoe !== 'undefined' && typeof pasteObj.gljType === 'undefined'){
  685. if(tempObj.gljType && (tempObj.gljType === 1 || tempObj.gljType === 303) && typeof pasteObj.adjCoe !== 'undefined' && !isNaN(pasteObj.adjCoe) && pasteObj.adjCoe % 1 === 0) {
  686. tempObj.adjCoe = pasteObj.adjCoe;
  687. }
  688. else {
  689. isValid = false;
  690. }
  691. }
  692. if(typeof pasteObj.basePrice !== 'undefined'){
  693. pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? that.round(parseFloat(pasteObj.basePrice), 2) :
  694. me.currentCache[rowIdx].basePrice;
  695. if(pasteObj.basePrice !== me.currentCache[rowIdx].basePrice){
  696. reCalBasePrc = true;
  697. tempObj.basePrice = pasteObj.basePrice;
  698. let updateGljs = me.getUpdateGljs(tempObj, false);
  699. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  700. for(let i = 0; i < updateGljs.updateArr.length; i++){
  701. rst.updateGlj.push(updateGljs.updateArr[i]);
  702. }
  703. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  704. rst.updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]);
  705. }
  706. }
  707. }
  708. }
  709. if(isValid){
  710. rst.updateGlj.push(tempObj);
  711. if(reCalBasePrc){
  712. //重新计算定额基价对象
  713. //rst.updateBasePrc = {gljId: tempObj.ID, gljType: tempObj.gljType, basePrice: tempObj.basePrice};
  714. let newReObj = {gljId: tempObj.ID, gljType: tempObj.gljType, basePrice: tempObj.basePrice};
  715. rst.updateBasePrcArr.push(newReObj);
  716. }
  717. }
  718. else {
  719. for(let attr in backUpObj){
  720. tempObj[attr] = backUpObj[attr];
  721. }
  722. }
  723. return rst;
  724. },
  725. //粘贴的数据是否是可添加的数据,只有含有编号,名称,类型才可添加
  726. isValidObj: function(pasteObj) {
  727. let me = repositoryGljObj;
  728. if(!(pasteObj.code && typeof pasteObj.code !== 'undefined') || !(pasteObj.name && typeof pasteObj.name !== 'undefined') ||
  729. !(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined')){
  730. return false;
  731. }
  732. if(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined'){
  733. let isExist = false;
  734. for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){
  735. if(me.distTypeTree.comboDatas[i].text === pasteObj.gljType){
  736. isExist = true;
  737. pasteObj.gljType = me.distTypeTree.comboDatas[i].value;
  738. pasteObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + pasteObj.gljType].data.shortName;
  739. break;
  740. }
  741. }
  742. if(!isExist){
  743. return false;
  744. }
  745. }
  746. if(pasteObj.code && typeof pasteObj.code !== 'undefined'){
  747. for(let i = 0; i < me.gljList.length; i++){
  748. if(me.gljList[i].code === pasteObj.code){
  749. return false;
  750. }
  751. }
  752. }
  753. if(pasteObj.adjCoe && typeof pasteObj.adjCoe !== 'undefined'){
  754. if(isNaN(pasteObj.adjCoe) || pasteObj.adjCoe % 1 !== 0){
  755. return false;
  756. }
  757. }
  758. pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? parseFloat(pasteObj.basePrice) : 0;
  759. pasteObj.gljClass = me.gljCurTypeId;
  760. return true;
  761. },
  762. canPasted: function (info) {
  763. let rst = true;
  764. let me = repositoryGljObj;
  765. if(me.gljCurTypeId < 0){
  766. return false;
  767. }
  768. if(info.cellRange.col + info.cellRange.colCount - 1 > me.setting.header.length - 1){
  769. return false;
  770. }
  771. if(info.cellRange.row < me.currentCache.length){
  772. if(info.cellRange.col === 0){
  773. return false;
  774. }
  775. else if(info.cellRange.col <= 4 && info.cellRange.col + info.cellRange.colCount - 1 >= 4){
  776. for(let i = 0, len = info.cellRange.rowCount; i < len; i++){
  777. let row = i + info.cellRange.row;
  778. if(row < me.currentCache.length){
  779. if(me.allowComponent.indexOf(me.currentCache[row].gljType) !== -1){
  780. rst = false;
  781. }
  782. }
  783. else {
  784. break;
  785. }
  786. }
  787. }
  788. }
  789. return rst;
  790. },
  791. onClipboardPasting: function(sender, args) {
  792. let me = repositoryGljObj;
  793. //复制的列数超过正确的列数,不可复制
  794. if(!me.canPasted(args)){
  795. args.cancel = true;
  796. }
  797. },
  798. onClipboardPasted: function(e, info) {
  799. let me = repositoryGljObj;
  800. let updateArr = [], addArr = [];
  801. let items = sheetCommonObj.analyzePasteData(me.setting, info);
  802. let beginRow = info.cellRange.row, endRow = info.cellRange.row + info.cellRange.rowCount - 1,
  803. maxRow = me.currentCache.length - 1,
  804. updateBasePrcArr = [] ,
  805. updateCount, resumeArr = [];
  806. if(endRow <= maxRow){
  807. //updateItems = items;
  808. for(let i = 0; i < items.length; i++){
  809. let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i);
  810. if(updateObj && typeof updateObj.updateGlj !== 'undefined' && updateObj.updateGlj.length > 0){
  811. //updateArr = updateObj.updateGlj;
  812. updateArr = updateArr.concat(updateObj.updateGlj);
  813. if(typeof updateObj.updateBasePrc !== 'undefined'){
  814. //updateBasePrcArr = updateObj.updateBasePrc;
  815. updateBasePrcArr = updateBasePrcArr.concat(updateObj.updateBasePrc);
  816. }
  817. }
  818. else{
  819. resumeArr.push(info.cellRange.row + i);
  820. }
  821. }
  822. }
  823. else if(beginRow <= maxRow && endRow > maxRow){
  824. updateCount = maxRow - beginRow + 1;
  825. for(let i = 0; i < updateCount; i++){
  826. let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i);
  827. if(updateObj && typeof updateObj.updateGlj !== 'undefined'){
  828. updateArr = updateArr.concat(updateObj.updateGlj);
  829. if(typeof updateObj.updateBasePrc !== 'undefined'){
  830. updateBasePrcArr = updateBasePrcArr.concat(updateObj.updateBasePrc);
  831. }
  832. }
  833. else{
  834. resumeArr.push(info.cellRange.row + i);
  835. }
  836. }
  837. if(info.cellRange.colCount === me.setting.header.length){
  838. for(let i = updateCount ; i < items.length; i++){
  839. if(me.isValidObj(items[i])){
  840. items[i].component = [];
  841. //类型为混凝土、砂浆、配合比、机械时,基价只能组成物计算
  842. if(me.allowComponent.indexOf(items[i].gljType) !== -1){
  843. items[i].basePrice = 0;
  844. }
  845. addArr.push(items[i]);
  846. }
  847. else{
  848. resumeArr.push(info.cellRange.row + i);
  849. }
  850. }
  851. }
  852. else{
  853. for(let i = updateCount ; i < items.length; i++){
  854. resumeArr.push(info.cellRange.row + i);
  855. }
  856. }
  857. }
  858. else{
  859. if(info.cellRange.colCount === me.setting.header.length - 1 && info.cellRange.col + info.cellRange.colCount - 1 >= 5){
  860. for(let i = 0; i < items.length; i++){
  861. if(me.isValidObj(items[i])){
  862. items[i].component = [];
  863. if(me.allowComponent.indexOf(items[i].gljType) !== -1){
  864. items[i].basePrice = 0;
  865. }
  866. addArr.push(items[i]);
  867. }
  868. else{
  869. resumeArr.push(info.cellRange.row + i);
  870. }
  871. }
  872. }
  873. else{
  874. for(let i = 0; i < items.length; i++){
  875. resumeArr.push(info.cellRange.row + i);
  876. }
  877. }
  878. }
  879. //repaint
  880. if(resumeArr.length > 0){
  881. info.sheet.suspendPaint();
  882. for(let i = 0; i < resumeArr.length ; i++){
  883. if(resumeArr[i] < me.currentCache.length){
  884. for(let col = 0; col < me.setting.header.length; col++){
  885. if(me.setting.header[col].dataCode === 'gljType'){
  886. let gljType = me.currentCache[resumeArr[i]][me.setting.header[col].dataCode];
  887. info.sheet.setValue(resumeArr[i], col, me.distTypeTree.distTypes["gljType" + gljType].data.fullName);
  888. }
  889. else{
  890. info.sheet.setValue(resumeArr[i], col, me.currentCache[resumeArr[i]][me.setting.header[col].dataCode]);
  891. }
  892. }
  893. }
  894. else{
  895. for(let col = 0; col < me.setting.header.length; col++){
  896. info.sheet.setValue(resumeArr[i], col, '');
  897. }
  898. }
  899. }
  900. info.sheet.resumePaint();
  901. }
  902. if (updateArr.length > 0 || addArr.length > 0) {
  903. console.log(addArr);
  904. me.mixUpdateRequest(updateArr, addArr, []);
  905. }
  906. if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){
  907. me.updateRationBasePrcRq(updateBasePrcArr);
  908. }
  909. },
  910. updateRationBasePrcRq: function (basePrcArr) {
  911. $.ajax({
  912. type: 'post',
  913. url: 'api/updateRationBasePrc',
  914. data:{basePrcArr: JSON.stringify(basePrcArr)},
  915. dataType: 'json',
  916. success: function (result) {
  917. if(result.error){
  918. alert("计算定额基价失败");
  919. }
  920. }
  921. });
  922. },
  923. /* getRationGljIds: function (repId) {
  924. let me = repositoryGljObj;
  925. $.ajax({
  926. type: 'post',
  927. url: 'api/getRationGljIds',
  928. data: {data: JSON.stringify({repId: repId})},
  929. dataType: 'json',
  930. success: function(result){
  931. if(!result.error){
  932. me.rationGljIds = result.data;
  933. }
  934. }
  935. });
  936. },*/
  937. mixUpdateRequest: function(updateArr, addArr, removeIds) {
  938. let me = repositoryGljObj;
  939. $.ajax({
  940. type:"POST",
  941. url:"api/mixUpdateGljItems",
  942. data:{"repositoryId": me.currentRepositoryId, "lastOpr": userAccount, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr), "removeIds": JSON.stringify(removeIds)},
  943. dataType:"json",
  944. cache:false,
  945. timeout:5000,
  946. success:function(result){
  947. if (result.error) {
  948. alert(result.message);
  949. } else {
  950. me.updateCache(addArr, updateArr, removeIds, result);
  951. me.sortGlj();
  952. if(me.currentOprParent === 1){
  953. me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]);
  954. }
  955. else{
  956. me.currentCache = me.getCache();
  957. }
  958. me.showGljItems(me.gljList, me.gljCurTypeId);
  959. }
  960. },
  961. error:function(err){
  962. console.log(err);
  963. alert("保存失败");
  964. }
  965. })
  966. },
  967. getParentCache: function (nodes) {
  968. let me = repositoryGljObj, rst = [];
  969. for(let i = 0; i < me.gljList.length; i++){
  970. if(nodes.indexOf(me.gljList[i].gljClass) !== -1){
  971. rst.push(me.gljList[i]);
  972. }
  973. }
  974. rst.sort(function (a, b) {
  975. let rst = 0;
  976. if(a.code > b.code) rst = 1;
  977. else if(a.code < b.code)rst = -1;
  978. return rst;
  979. });
  980. return rst;
  981. },
  982. getCache: function() {
  983. let me = this, rst = [];
  984. for (let i = 0; i < me.gljList.length; i++) {
  985. if (me.gljList[i].gljClass == me.gljCurTypeId) {
  986. rst.push(me.gljList[i]);
  987. }
  988. }
  989. return rst;
  990. },
  991. updateCache: function(addArr, updateArr, removeIds, result) {
  992. let me = this, cacheSection = me.gljList;
  993. if (addArr.length > 0) {
  994. me.gljList = me.gljList.concat(addArr);
  995. cacheSection = me.gljList;
  996. }
  997. for (let i = removeIds.length - 1; i >= 0; i--) {
  998. for (let j = cacheSection.length - 1; j >= 0 ; j--) {
  999. if (cacheSection[j]["ID"] == removeIds[i]) {
  1000. cacheSection.splice(j,1);
  1001. }
  1002. }
  1003. }
  1004. if (result && result.data && result.data.ops && result.data.ops.length > 0) {
  1005. for (let i = 0; i < result.data.ops.length; i++) {
  1006. for (let j = 0; j < cacheSection.length; j++) {
  1007. if (cacheSection[j][me.setting.header[0].dataCode] == result.data.ops[i][me.setting.header[0].dataCode]) {
  1008. cacheSection[j]["ID"] = result.data.ops[i]["ID"];
  1009. }
  1010. }
  1011. }
  1012. }
  1013. for (let i = 0; i < updateArr.length; i++) {
  1014. for (let j = 0; j < cacheSection.length; j++) {
  1015. if (updateArr[i]["ID"] && cacheSection[j]["ID"]) {
  1016. if (cacheSection[j]["ID"] == updateArr[i]["ID"]) {
  1017. cacheSection[j] = updateArr[i];
  1018. }
  1019. } else {
  1020. if (cacheSection[j][me.setting.header[0].dataCode] == updateArr[i][me.setting.header[0].dataCode]) {
  1021. cacheSection[j] = updateArr[i];
  1022. }
  1023. }
  1024. }
  1025. }
  1026. },
  1027. sortGlj: function() {
  1028. let me = this;
  1029. me.gljList.sort(function(a, b){
  1030. let rst = 0;
  1031. if (a.code > b.code) rst = 1
  1032. else if (a.code < b.code) rst = -1;
  1033. return rst;
  1034. });
  1035. }
  1036. }
  1037. let gljTypeTreeOprObj = {
  1038. onClick: function(event,treeId,treeNode) {
  1039. let me = repositoryGljObj,
  1040. that = gljComponentOprObj,
  1041. gljTypeId = treeNode.ID;
  1042. me.gljCurTypeId = treeNode.ID;
  1043. me.addGljObj = null;
  1044. sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, 5);
  1045. if (me.parentNodeIds["_pNodeId_" + treeNode.ID]) {
  1046. me.currentOprParent = 1;
  1047. me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + treeNode.ID]);
  1048. me.workBook.getSheet(0).setRowCount(me.currentCache.length);
  1049. } else {
  1050. me.currentOprParent = 0;
  1051. me.currentCache = me.getCache();
  1052. }
  1053. me.showGljItems(me.gljList, gljTypeId);
  1054. },
  1055. beforeRename: function(treeId, treeNode, newName, isCancel) {
  1056. if (newName.length == 0) {
  1057. return false;
  1058. }
  1059. return true;
  1060. },
  1061. onRename : function(e, treeId, treeNode, isCancel) {
  1062. let nodes = [];
  1063. nodes.push(treeNode);
  1064. gljTypeTreeOprObj.updateNodes(nodes);
  1065. },
  1066. onBeforeRemove: function(treeId, treeNode){
  1067. let me = this;
  1068. if (treeNode.ParentID == -1 && treeNode.isFirstNode) {
  1069. alert("不允许删除全部!");
  1070. return false;
  1071. }
  1072. if (!confirm("您确定要删除此节点及所有子节点的数据?删除后不可恢复!")) {
  1073. return false;
  1074. }
  1075. let nodeIds = [], preNode = treeNode.getPreNode(), preNodeId = -1;
  1076. if (preNode) {
  1077. preNodeId = preNode.ID;
  1078. }
  1079. private_fetchAllSubItems = function(pItem){
  1080. nodeIds.push(pItem.ID);
  1081. if (pItem.items && pItem.items.length > 0) {
  1082. for (let i = 0; i < pItem.items.length; i++) {
  1083. private_fetchAllSubItems(pItem.items[i]);
  1084. }
  1085. }
  1086. };
  1087. nodeIds.push(treeNode.ID);
  1088. for (let i = 0; i < treeNode.items.length; i++) {
  1089. private_fetchAllSubItems(treeNode.items[i]);
  1090. }
  1091. $.ajax({
  1092. type:"POST",
  1093. url:"api/deleteGljNodes",
  1094. data:{"repId": pageOprObj.gljLibId, "lastOpr": userAccount, "nodes": JSON.stringify(nodeIds), "preNodeId": preNodeId, "preNodeNextId": treeNode.NextSiblingID},
  1095. dataType:"json",
  1096. cache:false,
  1097. timeout:5000,
  1098. success:function(result,textStatus,status){
  1099. let pNode = treeNode.getParentNode();
  1100. if (pNode && pNode.items && pNode.items.length == 1) {
  1101. pNode.isParent = false;
  1102. }
  1103. },
  1104. error:function(){
  1105. }
  1106. });
  1107. return true;
  1108. },
  1109. onRemove: function(e, treeId, treeNode){
  1110. let me = repositoryGljObj, pNode = me.treeObj.getNodeByTId(treeNode.parentTId);
  1111. if (pNode && pNode.items && pNode.items.length == 0) {
  1112. pNode.isParent = false;
  1113. me.treeObj.refresh();
  1114. }
  1115. },
  1116. updateNodes: function(nodes){
  1117. if (nodes && nodes.length > 0) {
  1118. let reqData = []
  1119. for (let i = 0; i < nodes.length; i++) {
  1120. let node = {};
  1121. node.repositoryId = nodes[i].repositoryId;
  1122. node.ID = nodes[i].ID;
  1123. node.ParentID = nodes[i].ParentID;
  1124. node.NextSiblingID = nodes[i].NextSiblingID;
  1125. node.Name = nodes[i].Name;
  1126. reqData.push(node);
  1127. }
  1128. $.ajax({
  1129. type:"POST",
  1130. url:"api/updateGljNodes",
  1131. data:{"repId": pageOprObj.gljLibId, "lastOpr": userAccount, "nodes": JSON.stringify(reqData)},
  1132. dataType:"json",
  1133. cache:false,
  1134. timeout:5000,
  1135. success:function(result,textStatus,status){
  1136. console.log(status + ' : ' + result);
  1137. },
  1138. error:function(){
  1139. }
  1140. })
  1141. }
  1142. },
  1143. addRootNode: function() {
  1144. let me = repositoryGljObj, rawNode = {ParentID: -1, NextSiblingID: -1, Name: "所有"}, lastNodeId = -1;
  1145. if (me.treeObj) {
  1146. let rootNodes = me.treeObj.getNodes();
  1147. if (rootNodes.length == 0) {
  1148. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  1149. if (!(err)) {
  1150. let newNodes = [], isSilent = false;
  1151. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"所有",isParent:false, items:[]});
  1152. me.treeObj.addNodes(null, -1, newNodes, isSilent);
  1153. }
  1154. });
  1155. }
  1156. }
  1157. },
  1158. addNewNode : function(rawNode, lastNodeId, callback){
  1159. $.ajax({
  1160. type:"POST",
  1161. url:"api/createNewGljTypeNode",
  1162. data:{"lastOpr": userAccount, "repositoryId": repositoryGljObj.currentRepositoryId,"lastNodeId": lastNodeId, "rawNodeData": JSON.stringify(rawNode)},
  1163. dataType:"json",
  1164. cache:false,
  1165. timeout:1000,
  1166. success: function(result,textStatus,status){
  1167. callback(false, result);
  1168. },
  1169. error:function(err){
  1170. callback(err);
  1171. }
  1172. })
  1173. },
  1174. addHoverDom: function(treeId, treeNode) {
  1175. if(typeof treeNode.doing !== 'undefined' && treeNode.doing){
  1176. return false;
  1177. }
  1178. hoverOpr();
  1179. function hoverOpr(){
  1180. let me = repositoryGljObj, sObj = $("#" + treeNode.tId + "_span");
  1181. if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length>0) return;
  1182. let addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增子节点' onfocus='this.blur();'></span>";
  1183. sObj.after(addStr);
  1184. let btn = $("#addBtn_"+treeNode.tId);
  1185. if (btn) btn.bind("click", function(){
  1186. treeNode.doing = true;
  1187. let rawNode = {ParentID: treeNode.ID, NextSiblingID: -1, Name: "新增子节点"}, lastNodeId = -1;
  1188. if (treeNode.items.length > 0) {
  1189. lastNodeId = treeNode.items[treeNode.items.length - 1].ID;
  1190. }
  1191. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  1192. if (!(err)) {
  1193. let newNodes = [], isSilent = false;
  1194. if(treeNode.items.length > 0){
  1195. treeNode.items[treeNode.items.length - 1].NextSiblingID = rst.data.ID;
  1196. }
  1197. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"新增子节点",isParent:false, items:[]});
  1198. treeNode.isParent = true;
  1199. if (me.treeObj) {
  1200. me.treeObj.addNodes(treeNode, -1, newNodes, isSilent);
  1201. } else {
  1202. me.treeObj = $.fn.zTree.init($("#rationChapterTree"), gljSetting, newNodes);
  1203. }
  1204. treeNode.doing = false;
  1205. hoverOpr();
  1206. }
  1207. });
  1208. });
  1209. }
  1210. },
  1211. removeHoverDom: function(treeId, treeNode) {
  1212. $("#addBtn_"+treeNode.tId).unbind().remove();
  1213. }
  1214. };
  1215. //export {repositoryGljObj};//测试用