repository_glj.js 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750
  1. /**
  2. * Created by Tony on 2017/5/5.
  3. */
  4. $("#drirect-dinge").click(function(){
  5. $(this).attr('href', "/rationRepository/ration" + "?repository=" + getQueryString("repository"))
  6. });
  7. $("#fuzhu").click(function(){
  8. $(this).attr('href', "/rationRepository/coeList" + "?repository=" + getQueryString("repository"))
  9. });
  10. var pageOprObj = {
  11. rationLibName : null,
  12. initPage : function(container) {
  13. var me = this, rationLibId = getQueryString("repository"),//获取定额库参数
  14. rationLibName = storageUtil.getSessionCache("RationGrp","repositoryID_" + rationLibId);
  15. if (rationLibName) {
  16. var html = $("#rationname")[0].outerHTML;
  17. html = html.replace("XXX定额库", rationLibName);
  18. $("#rationname")[0].outerHTML = html;
  19. me.rationLibName = rationLibName;
  20. repositoryGljObj.buildSheet(container);
  21. repositoryGljObj.getRationGljIds(rationLibId);
  22. repositoryGljObj.getGljDistType(function () {
  23. repositoryGljObj.currentRepositoryId = parseInt(rationLibId);
  24. repositoryGljObj.getGljTree(rationLibId);
  25. repositoryGljObj.getGljItems(rationLibId);
  26. sheetCommonObj.shieldAllCells(repositoryGljObj.workBook.getSheet(0), repositoryGljObj.setting);
  27. });
  28. }
  29. }
  30. }
  31. repositoryGljObj = {
  32. treeObj : null,
  33. workBook: null,
  34. gljCurTypeId: -1,
  35. currentRepositoryId: -1,
  36. currentCache: null,
  37. parentNodeIds: {},
  38. gljList: [],
  39. distTypeTree: null,//add
  40. setting: {
  41. header:[
  42. {headerName:"编码",headerWidth:120,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  43. {headerName:"名称",headerWidth:260,dataCode:"name", dataType: "String", hAlign: "left", vAlign: "center"},
  44. {headerName:"规格",headerWidth:260,dataCode:"specs", dataType: "String", hAlign: "left", vAlign: "center"},
  45. {headerName:"单位",headerWidth:120,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"},
  46. {headerName:"基价单价",headerWidth:120,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"},
  47. {headerName:"类型",headerWidth:120,dataCode:"gljType", dataType: "String", hAlign: "center", vAlign: "center"}
  48. ],
  49. view:{
  50. comboBox:[
  51. {row:-1,col:3,rowCount:-1,colCount:1}
  52. ],
  53. lockedCells:[
  54. ]
  55. }
  56. },
  57. getComboData: function (gljDistType) {
  58. let me = this;
  59. let distType;
  60. let distTypeTree = {
  61. prefix : 'gljType',
  62. distTypes: {},
  63. comboDatas: [],
  64. distTypesArr: []
  65. };
  66. gljDistType.forEach(function (typeData) {
  67. let typeObj = {
  68. data: typeData,
  69. children: [],
  70. parent: null
  71. }
  72. distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
  73. distTypeTree.distTypesArr.push(typeObj);
  74. });
  75. gljDistType.forEach(function (typeData) {
  76. distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
  77. let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
  78. if(parent){
  79. distType.parent = parent;
  80. parent.children.push(distType);
  81. }
  82. });
  83. distTypeTree.distTypesArr.forEach(function (distTypeObj) {
  84. if(distTypeObj.children.length === 0 && distTypeObj.data.fullName !== '普通机械' &&distTypeObj.data.fullName !== '机械组成物'
  85. && distTypeObj.data.fullName !== '机上人工'){
  86. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  87. }
  88. if(distTypeObj.data.fullName === '机械'){
  89. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  90. }
  91. });
  92. //me.distTypeTree = distTypeTree;
  93. return distTypeTree;
  94. //return distTypeTree.comboDatas;
  95. },
  96. getGljDistType: function (callback) {
  97. let me = this;
  98. $.ajax({
  99. type: 'post',
  100. url: "api/getGljDistType",
  101. dataType: 'json',
  102. success: function (result) {
  103. if(!result.error && callback){
  104. me.distTypeTree = me.getComboData(result.data);
  105. let combo = new GC.Spread.Sheets.CellTypes.ComboBox();
  106. combo.items(me.distTypeTree.comboDatas).editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);
  107. me.workBook.getSheet(0).getCell(-1, 5, GC.Spread.Sheets.SheetArea.viewport).cellType(combo).value(me.distTypeTree.comboDatas[0].text);
  108. callback();
  109. }
  110. }
  111. })
  112. },
  113. getGljTree: function(rationLibId) {
  114. var me = this;
  115. $.ajax({
  116. type:"POST",
  117. url:"api/getGljTree",
  118. data:{"rationLibId": rationLibId},
  119. dataType:"json",
  120. cache:false,
  121. timeout:20000,
  122. success:function(result,textStatus,status){
  123. if(status.status == 200) {
  124. zTreeHelper.createTree(result.data, gljSetting, "repositoryTree", me);
  125. if (result.data && result.data.length > 0) {
  126. me.gljCurTypeId = result.data[0].ID;
  127. } else {
  128. gljTypeTreeOprObj.addRootNode();
  129. }
  130. }
  131. },
  132. error:function(err){
  133. alert(err.responseJSON.error);
  134. }
  135. })
  136. },
  137. getGljItems: function(repId) {
  138. var me = this;
  139. $.ajax({
  140. type:"POST",
  141. url:"api/getGljItems",
  142. data:{"repositoryId": repId},
  143. dataType:"json",
  144. cache:false,
  145. timeout:5000,
  146. success:function(result){
  147. if(!result.error) {
  148. me.gljList = result.data;
  149. me.workBook.getSheet(0).setRowCount(result.data.length);
  150. me.sortGlj();
  151. me.showGljItems(result.data, me.gljCurTypeId);
  152. }
  153. },
  154. error:function(err){
  155. alert(err.responseJSON.error);
  156. }
  157. })
  158. },
  159. showGljItems: function(data, type) {
  160. var me = repositoryGljObj;
  161. if (me.workBook) {
  162. var cacheSection = [];
  163. var pArr = me.parentNodeIds["_pNodeId_" + type];
  164. for (var i = 0; i < data.length; i++) {
  165. if (pArr && pArr.indexOf(data[i].gljClass) >= 0) {
  166. cacheSection.push(data[i]);
  167. } else if (type == data[i].gljClass) {
  168. //data[i].gljDistType = me.distTypeTree.distTypes[me.distTypeTree.prefix + data[i].gljDistType].data.fullName;
  169. cacheSection.push(data[i]);
  170. }
  171. }
  172. sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);
  173. sheetCommonObj.showData(me.workBook.getSheet(0), me.setting, cacheSection, me.distTypeTree);
  174. cacheSection = null;
  175. }
  176. },
  177. buildSheet: function(container) {
  178. var me = repositoryGljObj;
  179. me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30, me);
  180. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  181. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
  182. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditStarting, me.onCellEditStart);
  183. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd);
  184. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged);
  185. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onEnterCell);
  186. },
  187. onEnterCell: function (sender, args) {
  188. let me = repositoryGljObj;
  189. me.cellRowIdx = args.row;
  190. let isHasData = false;
  191. if(me.addGljObj){
  192. for(let i=0; i<me.setting.header.length; i++){
  193. if(me.addGljObj[me.setting.header[i].dataCode]){
  194. isHasData = true;
  195. break;
  196. }
  197. }
  198. }
  199. if(isHasData){
  200. if(me.editingRowIdx !== me.cellRowIdx) {
  201. let isComple = true;
  202. let focusToCol;
  203. function getFocusToCol (me){
  204. if(!me.addGljObj[me.setting.header[0].dataCode]){
  205. return 0;
  206. }
  207. else if(!me.addGljObj[me.setting.header[5].dataCode]){
  208. return 5;
  209. }
  210. else {
  211. return -1;
  212. }
  213. }
  214. focusToCol = getFocusToCol(me);
  215. if(focusToCol === -1){
  216. }
  217. else {
  218. $('#gljAlertBtn').click();
  219. me.workBook.getSheet(0).options.isProtected = true;
  220. $('#aleCanceBtn').click(function () {
  221. me.workBook.getSheet(0).options.isProtected = false;
  222. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  223. });
  224. $('#gljAleClose').click(function () {
  225. me.workBook.getSheet(0).options.isProtected = false;
  226. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  227. });
  228. $('#aleConfBtn').click(function () {
  229. me.workBook.getSheet(0).options.isProtected = false;
  230. me.addGljObj = null;
  231. for(let col=0; col<me.setting.header.length; col++){
  232. let field = me.setting.header[col].dataCode;
  233. if(field === 'gljType'){
  234. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value(
  235. me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj[field]].data.fullName);
  236. }
  237. else{
  238. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value(me.currentEditingGlj[me.setting.header[col].dataCode]);
  239. }
  240. }
  241. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, 0);
  242. });
  243. }
  244. }
  245. }
  246. },
  247. onCellEditStart: function(sender, args) {
  248. console.log(`enterEditStart`);
  249. var me = repositoryGljObj;
  250. var rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row);
  251. me.currentEditingGlj = rObj;
  252. console.log(me.currentEditingGlj);
  253. me.orgCode = me.workBook.getSheet(0).getValue(args.row, 0);
  254. var cacheSection = me.gljList;
  255. if (cacheSection) {
  256. for (var j = 0; j < cacheSection.length; j++) {
  257. if (cacheSection[j][me.setting.header[0].dataCode] && cacheSection[j][me.setting.header[0].dataCode] == rObj[me.setting.header[0].dataCode]) {
  258. rObj["ID"] = cacheSection[j]["ID"];
  259. rObj.gljClass = cacheSection[j].gljClass;
  260. break;
  261. }
  262. }
  263. }
  264. },
  265. onCellEditEnd: function(sender, args) {
  266. var me = repositoryGljObj, rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row, me),
  267. updateArr = [], addArr = [];
  268. console.log(`me.currentE`);
  269. console.log(me.currentEditingGlj);
  270. me.editingRowIdx = args.row;
  271. console.log(`editEnd_obj`);
  272. console.log(rObj);
  273. if (me.currentEditingGlj["ID"]) {
  274. rObj["ID"] = me.currentEditingGlj["ID"];
  275. rObj.gljClass = me.currentEditingGlj.gljClass;
  276. for(let col =0; col< me.setting.header.length; col++){
  277. if(me.currentEditingGlj[me.setting.header[col].dataCode] !== rObj[me.setting.header[col].dataCode]){
  278. me.addGljObj = rObj;
  279. if(rObj[me.setting.header[0].dataCode] && rObj[me.setting.header[5].dataCode]){
  280. updateArr.push(rObj);
  281. break;
  282. }
  283. }
  284. }
  285. if(me.currentEditingGlj.basePrice !== rObj.basePrice){
  286. //update basePrice of ration when editting basePrice of glj
  287. let gljType = -1;
  288. let gljTypeParent = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj.gljType].parent;
  289. if(gljTypeParent && gljTypeParent.data.ID <=3){
  290. gljType = gljTypeParent.data.ID;
  291. }
  292. if(!gljTypeParent && me.currentEditingGlj.gljType <= 3){
  293. gljType = me.currentEditingGlj.gljType;
  294. }
  295. let gljBasePrcObj = {gljId: me.currentEditingGlj.ID, gljType: gljType, basePrice: rObj.basePrice};
  296. if(gljBasePrcObj.gljType !== -1){
  297. me.updateRationBasePrcRq(gljBasePrcObj);
  298. }
  299. }
  300. //update basePrice of ration when editting gljType of glj
  301. if(me.currentEditingGlj.gljType !== rObj.gljType){
  302. let gljTypeObj = {gljId: me.currentEditingGlj.ID, gljType: rObj.gljType, basePrice: rObj.basePrice};
  303. me.updateRationBasePrcRq(gljTypeObj);
  304. }
  305. } else {
  306. me.addGljObj = rObj;
  307. let isCanSav = true;
  308. if(!rObj[me.setting.header[0].dataCode] || !rObj[me.setting.header[5].dataCode]){
  309. isCanSav = false;
  310. }
  311. if(isCanSav){
  312. me.addGljObj = null;
  313. addArr.push(rObj);
  314. }
  315. }
  316. if(me.gljCurTypeId !== 1){
  317. rObj.gljClass = me.gljCurTypeId;
  318. }
  319. if(updateArr.length >0 || addArr.length >0){
  320. me.currentEditingGlj = null;
  321. me.mixUpdateRequest(updateArr, addArr, []);
  322. }
  323. },
  324. onRangeChanged: function(sender, args) {
  325. if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
  326. var me = repositoryGljObj, updateArr = [], removeArr = [], cancelArr = [], isMisCode = true;
  327. var cacheSection = me.currentCache;
  328. if (cacheSection) {
  329. for (var i = 0; i < args.rowCount; i++) {
  330. var hasUpdate = false, rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row + i),
  331. isEmpty = sheetCommonObj.chkIfEmpty(rObj, me.setting);
  332. if(isEmpty){
  333. if(args.row + i < cacheSection.length){
  334. rObj.ID = cacheSection[args.row + i].ID
  335. removeArr.push(rObj.ID);
  336. }
  337. }
  338. else {
  339. if(!rObj.code){
  340. cancelArr.push(args.row + i);
  341. }
  342. else if(!rObj.gljType){
  343. isMisCode = false;
  344. cancelArr.push(args.row + i);
  345. }
  346. else{
  347. rObj.gljClass = me.gljCurTypeId;
  348. updateArr.push(rObj);
  349. }
  350. }
  351. }
  352. //reshow datas
  353. function resetDatas(args, repositoryGljObj, cancelArr){
  354. args.sheet.options.isProtected = false;
  355. args.sheet.suspendPaint();
  356. for(let i =0; i <cancelArr.length; i++){
  357. for(let col =args.col; col< repositoryGljObj.setting.header.length; col++){
  358. let value = repositoryGljObj.setting.header[col].dataCode === 'gljType' ?
  359. repositoryGljObj.distTypeTree.distTypes[repositoryGljObj.distTypeTree.prefix + cacheSection[cancelArr[i]].gljType].data.fullName :
  360. cacheSection[cancelArr[i]][repositoryGljObj.setting.header[col].dataCode];
  361. args.sheet.setValue(args.row + i, col, value);
  362. }
  363. }
  364. args.sheet.resumePaint();
  365. args.sheet.setActiveCell(args.row, 0);
  366. }
  367. if(cancelArr.length > 0){
  368. let text = isMisCode === true ? "编号不可为空,编辑失败!": "类型不可为空,编辑失败!"
  369. $('#alertText').text(text);
  370. $('#codeAlertBtn').click();
  371. args.sheet.options.isProtected = true;
  372. $('#codAleConfBtn').click(function () {
  373. resetDatas(args, me, cancelArr);
  374. });
  375. $('#codAleClose').click(function () {
  376. resetDatas(args, me, cancelArr);
  377. });
  378. }
  379. let refGljIds = [], refGljCodes = [], alertText;
  380. if(removeArr.length > 0){
  381. for(let i =0; i <removeArr.length; i++){
  382. if(me.rationGljIds.indexOf(removeArr[i]) !== -1){
  383. refGljIds.push(removeArr[i]);
  384. removeArr.splice(i--, 1);
  385. }
  386. }
  387. for(let i =0; i< me.currentCache.length; i++){
  388. for(let j=0; j< refGljIds.length; j++){
  389. if(me.currentCache[i].ID === refGljIds[j]){
  390. refGljCodes.push(me.currentCache[i].code);
  391. }
  392. }
  393. }
  394. }
  395. if(refGljIds.length > 0){
  396. if(refGljCodes.length > 3){
  397. alertText = "编号:" + refGljCodes[0]+" " + refGljCodes[1] + " " + refGljCodes[2] + "...等工料机已有定额引用,删除失败!";
  398. }
  399. else {
  400. let alertCode = " ";
  401. for(let i=0; i< refGljCodes.length; i++){
  402. alertCode += refGljCodes[i] + " ";
  403. }
  404. alertText = "编号:" + alertCode + "工料机已有定额引用,删除失败!"
  405. }
  406. $('#alertText').text(alertText);
  407. $('#codeAlertBtn').click();
  408. args.sheet.options.isProtected = true;
  409. $('#codAleConfBtn').click(function () {
  410. if(removeArr.length > 0){
  411. me.mixUpdateRequest(updateArr, [], removeArr);
  412. }
  413. else{
  414. let resetArr = [];
  415. for(let i=0; i<args.rowCount; i++){
  416. resetArr.push(args.row + i);
  417. }
  418. resetDatas(args, me, resetArr);
  419. }
  420. });
  421. $('#codAleClose').click(function () {
  422. if(removeArr.length > 0){
  423. me.mixUpdateRequest(updateArr, [], removeArr);
  424. }
  425. else{
  426. let resetArr = [];
  427. for(let i=0; i<args.rowCount; i++){
  428. resetArr.push(args.row + i);
  429. }
  430. resetDatas(args, me, resetArr);
  431. }
  432. });
  433. }
  434. else if(refGljIds.length === 0 && removeArr.length > 0){
  435. me.mixUpdateRequest(updateArr, [], removeArr);
  436. }
  437. if(updateArr.length > 0){
  438. me.mixUpdateRequest(updateArr, [], removeArr);
  439. }
  440. }
  441. }
  442. },
  443. onClipboardPasting: function(sender, args) {
  444. var me = repositoryGljObj;
  445. if (args.cellRange.colCount != me.setting.header.length || me.gljCurTypeId < 0 || me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]) {
  446. args.cancel = true;
  447. }
  448. },
  449. onClipboardPasted: function(e, info) {
  450. var me = repositoryGljObj;
  451. var updateArr = [], addArr = [];
  452. var items = sheetCommonObj.analyzePasteData(me.setting, info);
  453. var hasCacheItem = false;
  454. for (var i = 0; i < items.length; i++) {
  455. for (var j = 0; j < me.gljList.length; j++) {
  456. if (me.gljList[j][me.setting.header[0].dataCode] == items[i][me.setting.header[0].dataCode]) {
  457. hasCacheItem = true;
  458. items[i]["ID"] = me.gljList[j]["ID"];
  459. break;
  460. }
  461. }
  462. if (!hasCacheItem) {
  463. items[i].gljType = me.gljCurTypeId;
  464. addArr.push(items[i]);
  465. } else {
  466. updateArr.push(items[i]);
  467. }
  468. }
  469. if (updateArr.length > 0 || addArr.length > 0) {
  470. me.mixUpdateRequest(updateArr, addArr, []);
  471. }
  472. },
  473. updateRationBasePrcRq: function (gljObj) {
  474. $.ajax({
  475. type: 'post',
  476. url: 'api/updateRationBasePrc',
  477. data:{data: JSON.stringify({gljId: gljObj.gljId, basePrice: gljObj.basePrice, gljType: gljObj.gljType})},
  478. dataType: 'json',
  479. success: function (result) {
  480. if(result.error){
  481. alert("计算定额基价失败");
  482. }
  483. }
  484. });
  485. },
  486. getRationGljIds: function (repId) {
  487. let me = repositoryGljObj;
  488. $.ajax({
  489. type: 'post',
  490. url: 'api/getRationGljIds',
  491. data: {data: JSON.stringify({repId: repId})},
  492. dataType: 'json',
  493. success: function(result){
  494. if(!result.error){
  495. me.rationGljIds = result.data;
  496. }
  497. }
  498. });
  499. },
  500. mixUpdateRequest: function(updateArr, addArr, removeIds) {
  501. var me = repositoryGljObj;
  502. $.ajax({
  503. type:"POST",
  504. url:"api/mixUpdateGljItems",
  505. data:{"repositoryId": me.currentRepositoryId, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr), "removeIds": JSON.stringify(removeIds)},
  506. dataType:"json",
  507. cache:false,
  508. timeout:5000,
  509. success:function(result){
  510. if (result.error) {
  511. alert(result.message);
  512. me.getRationItems(me.currentRepositoryId);
  513. } else {
  514. console.log(`enterSc`);
  515. me.updateCache(addArr, updateArr, removeIds, result);
  516. me.sortGlj();
  517. me.currentCache = me.getCache();
  518. me.showGljItems(me.gljList, me.gljCurTypeId);
  519. }
  520. },
  521. error:function(err){
  522. alert("保存失败");
  523. }
  524. })
  525. },
  526. getCache: function() {
  527. var me = this, rst = [];
  528. for (var i = 0; i < me.gljList.length; i++) {
  529. if (me.gljList[i].gljClass == me.gljCurTypeId) {
  530. rst.push(me.gljList[i]);
  531. }
  532. }
  533. return rst;
  534. },
  535. updateCache: function(addArr, updateArr, removeIds, result) {
  536. var me = this, cacheSection = me.gljList;
  537. if (addArr.length > 0) {
  538. me.gljList = me.gljList.concat(addArr);
  539. cacheSection = me.gljList;
  540. }
  541. for (var i = removeIds.length - 1; i >= 0; i--) {
  542. for (var j = cacheSection.length - 1; j >= 0 ; j--) {
  543. if (cacheSection[j]["ID"] == removeIds[i]) {
  544. cacheSection.splice(j,1);
  545. }
  546. }
  547. }
  548. if (result && result.data.ops && result.data.ops.length > 0) {
  549. for (var i = 0; i < result.data.ops.length; i++) {
  550. for (var j = 0; j < cacheSection.length; j++) {
  551. if (cacheSection[j][me.setting.header[0].dataCode] == result.data.ops[i][me.setting.header[0].dataCode]) {
  552. cacheSection[j]["ID"] = result.data.ops[i]["ID"];
  553. }
  554. }
  555. }
  556. }
  557. for (var i = 0; i < updateArr.length; i++) {
  558. for (var j = 0; j < cacheSection.length; j++) {
  559. if (updateArr[i]["ID"] && cacheSection[j]["ID"]) {
  560. if (cacheSection[j]["ID"] == updateArr[i]["ID"]) {
  561. cacheSection[j] = updateArr[i];
  562. }
  563. } else {
  564. if (cacheSection[j][me.setting.header[0].dataCode] == updateArr[i][me.setting.header[0].dataCode]) {
  565. cacheSection[j] = updateArr[i];
  566. }
  567. }
  568. }
  569. }
  570. },
  571. sortGlj: function() {
  572. var me = this;
  573. me.gljList.sort(function(a, b){
  574. var rst = 0;
  575. if (a.code > b.code) rst = 1
  576. else if (a.code < b.code) rst = -1;
  577. return rst;
  578. });
  579. }
  580. }
  581. var gljTypeTreeOprObj = {
  582. onClick: function(event,treeId,treeNode) {
  583. var me = repositoryGljObj,
  584. gljTypeId = treeNode.ID;
  585. me.gljCurTypeId = treeNode.ID;
  586. me.currentCache = me.getCache();
  587. me.showGljItems(me.gljList, gljTypeId);
  588. console.log(me.gljCurTypeId);
  589. if (me.parentNodeIds["_pNodeId_" + treeNode.ID]) {
  590. sheetCommonObj.lockCodeCells(me.workBook.getSheet(0), me.gljList.length);
  591. //sheetCommonObj.shieldAllCells(me.workBook.getSheet(0), me.setting);
  592. } else {
  593. sheetCommonObj.unShieldAllCells(me.workBook.getSheet(0));
  594. }
  595. },
  596. beforeRename: function(treeId, treeNode, newName, isCancel) {
  597. if (newName.length == 0) {
  598. return false;
  599. }
  600. return true;
  601. },
  602. onRename : function(e, treeId, treeNode, isCancel) {
  603. var nodes = [];
  604. nodes.push(treeNode);
  605. gljTypeTreeOprObj.updateNodes(nodes);
  606. },
  607. onBeforeRemove: function(treeId, treeNode){
  608. if (treeNode.ParentID == -1 && treeNode.isFirstNode) {
  609. alert("不允许删除全部!");
  610. return false;
  611. }
  612. if (!confirm("您确定要删除此节点及所有子节点的数据?删除后不可恢复!")) {
  613. return false;
  614. }
  615. var nodeIds = [], preNode = treeNode.getPreNode(), preNodeId = -1;
  616. if (preNode) {
  617. preNodeId = preNode.ID;
  618. }
  619. private_fetchAllSubItems = function(pItem){
  620. nodeIds.push(pItem.ID);
  621. if (pItem.items && pItem.items.length > 0) {
  622. for (var i = 0; i < pItem.items.length; i++) {
  623. private_fetchAllSubItems(pItem.items[i]);
  624. }
  625. }
  626. };
  627. nodeIds.push(treeNode.ID);
  628. for (var i = 0; i < treeNode.items.length; i++) {
  629. private_fetchAllSubItems(treeNode.items[i]);
  630. }
  631. $.ajax({
  632. type:"POST",
  633. url:"api/deleteGljNodes",
  634. data:{"nodes": JSON.stringify(nodeIds), "preNodeId": preNodeId, "preNodeNextId": treeNode.NextSiblingID},
  635. dataType:"json",
  636. cache:false,
  637. timeout:5000,
  638. success:function(result,textStatus,status){
  639. var pNode = treeNode.getParentNode();
  640. if (pNode && pNode.items && pNode.items.length == 1) {
  641. pNode.isParent = false;
  642. }
  643. },
  644. error:function(){
  645. }
  646. });
  647. return true;
  648. },
  649. onRemove: function(e, treeId, treeNode){
  650. var me = repositoryGljObj, pNode = me.treeObj.getNodeByTId(treeNode.parentTId);
  651. if (pNode && pNode.items && pNode.items.length == 0) {
  652. pNode.isParent = false;
  653. me.treeObj.refresh();
  654. }
  655. },
  656. updateNodes: function(nodes){
  657. if (nodes && nodes.length > 0) {
  658. var reqData = []
  659. for (var i = 0; i < nodes.length; i++) {
  660. var node = {};
  661. node.repositoryId = nodes[i].repositoryId;
  662. node.ID = nodes[i].ID;
  663. node.ParentID = nodes[i].ParentID;
  664. node.NextSiblingID = nodes[i].NextSiblingID;
  665. node.Name = nodes[i].Name;
  666. if (nodes[i].__v != null) node.__v = nodes[i].__v + 1
  667. else node.__v = 0;
  668. reqData.push(node);
  669. }
  670. $.ajax({
  671. type:"POST",
  672. url:"api/updateGljNodes",
  673. data:{"nodes": JSON.stringify(reqData)},
  674. dataType:"json",
  675. cache:false,
  676. timeout:5000,
  677. success:function(result,textStatus,status){
  678. console.log(status + ' : ' + result);
  679. },
  680. error:function(){
  681. }
  682. })
  683. }
  684. },
  685. addRootNode: function() {
  686. var me = repositoryGljObj, rawNode = {ParentID: -1, NextSiblingID: -1, Name: "所有"}, lastNodeId = -1;
  687. if (me.treeObj) {
  688. var rootNodes = me.treeObj.getNodes();
  689. if (rootNodes.length == 0) {
  690. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  691. if (!(err)) {
  692. var newNodes = [], isSilent = false;
  693. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"所有",isParent:false, items:[]});
  694. me.treeObj.addNodes(null, -1, newNodes, isSilent);
  695. }
  696. });
  697. }
  698. }
  699. },
  700. addNewNode : function(rawNode, lastNodeId, callback){
  701. $.ajax({
  702. type:"POST",
  703. url:"api/createNewGljTypeNode",
  704. data:{"repositoryId": repositoryGljObj.currentRepositoryId,"lastNodeId": lastNodeId, "rawNodeData": JSON.stringify(rawNode)},
  705. dataType:"json",
  706. cache:false,
  707. timeout:1000,
  708. success: function(result,textStatus,status){
  709. callback(false, result);
  710. },
  711. error:function(err){
  712. callback(err);
  713. }
  714. })
  715. },
  716. addHoverDom: function(treeId, treeNode) {
  717. var me = repositoryGljObj, sObj = $("#" + treeNode.tId + "_span");
  718. if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length>0) return;
  719. var addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增子节点' onfocus='this.blur();'></span>";
  720. sObj.after(addStr);
  721. var btn = $("#addBtn_"+treeNode.tId);
  722. if (btn) btn.bind("click", function(){
  723. var rawNode = {ParentID: treeNode.ID, NextSiblingID: -1, Name: "新增子节点"}, lastNodeId = -1;
  724. if (treeNode.items.length > 0) {
  725. lastNodeId = treeNode.items[treeNode.items.length - 1].ID;
  726. }
  727. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  728. if (!(err)) {
  729. var newNodes = [], isSilent = false;
  730. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"新增子节点",isParent:false, items:[]});
  731. treeNode.isParent = true;
  732. if (me.treeObj) {
  733. me.treeObj.addNodes(treeNode, -1, newNodes, isSilent);
  734. } else {
  735. me.treeObj = $.fn.zTree.init($("#rationChapterTree"), gljSetting, newNodes);
  736. }
  737. }
  738. });
  739. });
  740. },
  741. removeHoverDom: function(treeId, treeNode) {
  742. $("#addBtn_"+treeNode.tId).unbind().remove();
  743. }
  744. }