repository_glj.js 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751
  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. $('#alertGljTxt').text('编号不能为空,是否取消增加工料机?');
  206. return 0;
  207. }
  208. else if(!me.addGljObj[me.setting.header[1].dataCode]){
  209. $('#alertGljTxt').text('名称不能为空,是否取消增加工料机?');
  210. return 1;
  211. }
  212. else if(!me.addGljObj[me.setting.header[5].dataCode]){
  213. $('#alertGljTxt').text('类型不能为空,是否取消增加工料机?');
  214. return 5;
  215. }
  216. else {
  217. return -1;
  218. }
  219. }
  220. focusToCol = getFocusToCol(me);
  221. if(focusToCol === -1){
  222. }
  223. else {
  224. $('#gljAlertBtn').click();
  225. me.workBook.getSheet(0).options.isProtected = true;
  226. $('#aleCanceBtn').click(function () {
  227. me.workBook.getSheet(0).options.isProtected = false;
  228. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  229. });
  230. $('#gljAleClose').click(function () {
  231. me.workBook.getSheet(0).options.isProtected = false;
  232. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  233. });
  234. $('#aleConfBtn').click(function () {
  235. me.workBook.getSheet(0).options.isProtected = false;
  236. me.addGljObj = null;
  237. for(let col=0; col<me.setting.header.length; col++){
  238. let field = me.setting.header[col].dataCode;
  239. if(field === 'gljType'){
  240. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value(
  241. me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj[field]].data.fullName);
  242. }
  243. else{
  244. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value(me.currentEditingGlj[me.setting.header[col].dataCode]);
  245. }
  246. }
  247. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, 0);
  248. });
  249. }
  250. }
  251. }
  252. },
  253. onCellEditStart: function(sender, args) {
  254. var me = repositoryGljObj;
  255. var rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row);
  256. me.currentEditingGlj = rObj;
  257. me.orgCode = me.workBook.getSheet(0).getValue(args.row, 0);
  258. var cacheSection = me.gljList;
  259. if (cacheSection) {
  260. for (var j = 0; j < cacheSection.length; j++) {
  261. if (cacheSection[j][me.setting.header[0].dataCode] && cacheSection[j][me.setting.header[0].dataCode] == rObj[me.setting.header[0].dataCode]) {
  262. rObj["ID"] = cacheSection[j]["ID"];
  263. rObj.gljClass = cacheSection[j].gljClass;
  264. break;
  265. }
  266. }
  267. }
  268. },
  269. onCellEditEnd: function(sender, args) {
  270. var me = repositoryGljObj, rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row, me),
  271. updateArr = [], addArr = [];
  272. me.editingRowIdx = args.row;
  273. rObj.basePrice = rObj.basePrice ? rObj.basePrice : 0;
  274. if (me.currentEditingGlj["ID"]) {
  275. rObj["ID"] = me.currentEditingGlj["ID"];
  276. rObj.gljClass = me.currentEditingGlj.gljClass;
  277. for(let col =0; col< me.setting.header.length; col++){
  278. if(me.currentEditingGlj[me.setting.header[col].dataCode] !== rObj[me.setting.header[col].dataCode]){
  279. me.addGljObj = rObj;
  280. if(rObj[me.setting.header[0].dataCode] && rObj[me.setting.header[1].dataCode] && rObj[me.setting.header[5].dataCode]){
  281. updateArr.push(rObj);
  282. break;
  283. }
  284. }
  285. }
  286. if(me.currentEditingGlj.basePrice !== rObj.basePrice){
  287. //update basePrice of ration when editting basePrice of glj
  288. let gljType = -1;
  289. let gljTypeParent = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj.gljType].parent;
  290. if(gljTypeParent && gljTypeParent.data.ID <=3){
  291. gljType = gljTypeParent.data.ID;
  292. }
  293. if(!gljTypeParent && me.currentEditingGlj.gljType <= 3){
  294. gljType = me.currentEditingGlj.gljType;
  295. }
  296. let gljBasePrcObj = {gljId: me.currentEditingGlj.ID, gljType: gljType, basePrice: rObj.basePrice};
  297. if(gljBasePrcObj.gljType !== -1){
  298. me.updateRationBasePrcRq(gljBasePrcObj);
  299. }
  300. }
  301. //update basePrice of ration when editting gljType of glj
  302. if(me.currentEditingGlj.gljType !== rObj.gljType){
  303. let gljTypeObj = {gljId: me.currentEditingGlj.ID, gljType: rObj.gljType, basePrice: rObj.basePrice};
  304. me.updateRationBasePrcRq(gljTypeObj);
  305. }
  306. } else {
  307. me.addGljObj = rObj;
  308. let isCanSav = true;
  309. if(!rObj[me.setting.header[0].dataCode] || !rObj[me.setting.header[1].dataCode] || !rObj[me.setting.header[5].dataCode]){
  310. isCanSav = false;
  311. }
  312. if(isCanSav){
  313. me.addGljObj = null;
  314. addArr.push(rObj);
  315. }
  316. }
  317. if(me.gljCurTypeId !== 1){
  318. rObj.gljClass = me.gljCurTypeId;
  319. }
  320. if(updateArr.length >0 || addArr.length >0){
  321. me.currentEditingGlj = null;
  322. me.mixUpdateRequest(updateArr, addArr, []);
  323. }
  324. },
  325. onRangeChanged: function(sender, args) {
  326. if (args.action == GC.Spread.Sheets.RangeChangedAction.clear) {
  327. var me = repositoryGljObj, updateArr = [], removeArr = [], cancelArr = [], isMisCode = true;
  328. var cacheSection = me.currentCache;
  329. if (cacheSection) {
  330. for (var i = 0; i < args.rowCount; i++) {
  331. var hasUpdate = false, rObj = sheetCommonObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row + i),
  332. isEmpty = sheetCommonObj.chkIfEmpty(rObj, me.setting);
  333. if(isEmpty){
  334. if(args.row + i < cacheSection.length){
  335. rObj.ID = cacheSection[args.row + i].ID
  336. removeArr.push(rObj.ID);
  337. }
  338. }
  339. else {
  340. if(!rObj.code){
  341. cancelArr.push(args.row + i);
  342. }
  343. else if(!rObj.gljType){
  344. isMisCode = false;
  345. cancelArr.push(args.row + i);
  346. }
  347. else{
  348. rObj.gljClass = me.gljCurTypeId;
  349. updateArr.push(rObj);
  350. }
  351. }
  352. }
  353. //reshow datas
  354. function resetDatas(args, repositoryGljObj, cancelArr){
  355. args.sheet.options.isProtected = false;
  356. args.sheet.suspendPaint();
  357. for(let i =0; i <cancelArr.length; i++){
  358. for(let col =args.col; col< repositoryGljObj.setting.header.length; col++){
  359. let value = repositoryGljObj.setting.header[col].dataCode === 'gljType' ?
  360. repositoryGljObj.distTypeTree.distTypes[repositoryGljObj.distTypeTree.prefix + cacheSection[cancelArr[i]].gljType].data.fullName :
  361. cacheSection[cancelArr[i]][repositoryGljObj.setting.header[col].dataCode];
  362. args.sheet.setValue(args.row + i, col, value);
  363. }
  364. }
  365. args.sheet.resumePaint();
  366. args.sheet.setActiveCell(args.row, 0);
  367. }
  368. if(cancelArr.length > 0){
  369. let text = isMisCode === true ? "编号不可为空,编辑失败!": "类型不可为空,编辑失败!"
  370. $('#alertText').text(text);
  371. $('#codeAlertBtn').click();
  372. args.sheet.options.isProtected = true;
  373. $('#codAleConfBtn').click(function () {
  374. resetDatas(args, me, cancelArr);
  375. });
  376. $('#codAleClose').click(function () {
  377. resetDatas(args, me, cancelArr);
  378. });
  379. }
  380. let refGljIds = [], refGljCodes = [], alertText;
  381. if(removeArr.length > 0){
  382. for(let i =0; i <removeArr.length; i++){
  383. if(me.rationGljIds.indexOf(removeArr[i]) !== -1){
  384. refGljIds.push(removeArr[i]);
  385. removeArr.splice(i--, 1);
  386. }
  387. }
  388. for(let i =0; i< me.currentCache.length; i++){
  389. for(let j=0; j< refGljIds.length; j++){
  390. if(me.currentCache[i].ID === refGljIds[j]){
  391. refGljCodes.push(me.currentCache[i].code);
  392. }
  393. }
  394. }
  395. }
  396. if(refGljIds.length > 0){
  397. if(refGljCodes.length > 3){
  398. alertText = "编号:" + refGljCodes[0]+" " + refGljCodes[1] + " " + refGljCodes[2] + "...等工料机已有定额引用,删除失败!";
  399. }
  400. else {
  401. let alertCode = " ";
  402. for(let i=0; i< refGljCodes.length; i++){
  403. alertCode += refGljCodes[i] + " ";
  404. }
  405. alertText = "编号:" + alertCode + "工料机已有定额引用,删除失败!"
  406. }
  407. $('#alertText').text(alertText);
  408. $('#codeAlertBtn').click();
  409. args.sheet.options.isProtected = true;
  410. $('#codAleConfBtn').click(function () {
  411. if(removeArr.length > 0){
  412. me.mixUpdateRequest(updateArr, [], removeArr);
  413. }
  414. else{
  415. let resetArr = [];
  416. for(let i=0; i<args.rowCount; i++){
  417. resetArr.push(args.row + i);
  418. }
  419. resetDatas(args, me, resetArr);
  420. }
  421. });
  422. $('#codAleClose').click(function () {
  423. if(removeArr.length > 0){
  424. me.mixUpdateRequest(updateArr, [], removeArr);
  425. }
  426. else{
  427. let resetArr = [];
  428. for(let i=0; i<args.rowCount; i++){
  429. resetArr.push(args.row + i);
  430. }
  431. resetDatas(args, me, resetArr);
  432. }
  433. });
  434. }
  435. else if(refGljIds.length === 0 && removeArr.length > 0){
  436. me.mixUpdateRequest(updateArr, [], removeArr);
  437. }
  438. if(updateArr.length > 0){
  439. me.mixUpdateRequest(updateArr, [], removeArr);
  440. }
  441. }
  442. }
  443. },
  444. onClipboardPasting: function(sender, args) {
  445. var me = repositoryGljObj;
  446. if (args.cellRange.colCount != me.setting.header.length || me.gljCurTypeId < 0 || me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]) {
  447. args.cancel = true;
  448. }
  449. },
  450. onClipboardPasted: function(e, info) {
  451. var me = repositoryGljObj;
  452. var updateArr = [], addArr = [];
  453. var items = sheetCommonObj.analyzePasteData(me.setting, info);
  454. var hasCacheItem = false;
  455. for (var i = 0; i < items.length; i++) {
  456. for (var j = 0; j < me.gljList.length; j++) {
  457. if (me.gljList[j][me.setting.header[0].dataCode] == items[i][me.setting.header[0].dataCode]) {
  458. hasCacheItem = true;
  459. items[i]["ID"] = me.gljList[j]["ID"];
  460. break;
  461. }
  462. }
  463. if (!hasCacheItem) {
  464. items[i].gljType = me.gljCurTypeId;
  465. addArr.push(items[i]);
  466. } else {
  467. updateArr.push(items[i]);
  468. }
  469. }
  470. if (updateArr.length > 0 || addArr.length > 0) {
  471. me.mixUpdateRequest(updateArr, addArr, []);
  472. }
  473. },
  474. updateRationBasePrcRq: function (gljObj) {
  475. $.ajax({
  476. type: 'post',
  477. url: 'api/updateRationBasePrc',
  478. data:{data: JSON.stringify({gljId: gljObj.gljId, basePrice: gljObj.basePrice, gljType: gljObj.gljType})},
  479. dataType: 'json',
  480. success: function (result) {
  481. if(result.error){
  482. alert("计算定额基价失败");
  483. }
  484. }
  485. });
  486. },
  487. getRationGljIds: function (repId) {
  488. let me = repositoryGljObj;
  489. $.ajax({
  490. type: 'post',
  491. url: 'api/getRationGljIds',
  492. data: {data: JSON.stringify({repId: repId})},
  493. dataType: 'json',
  494. success: function(result){
  495. if(!result.error){
  496. me.rationGljIds = result.data;
  497. }
  498. }
  499. });
  500. },
  501. mixUpdateRequest: function(updateArr, addArr, removeIds) {
  502. var me = repositoryGljObj;
  503. $.ajax({
  504. type:"POST",
  505. url:"api/mixUpdateGljItems",
  506. data:{"repositoryId": me.currentRepositoryId, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr), "removeIds": JSON.stringify(removeIds)},
  507. dataType:"json",
  508. cache:false,
  509. timeout:5000,
  510. success:function(result){
  511. if (result.error) {
  512. alert(result.message);
  513. me.getRationItems(me.currentRepositoryId);
  514. } else {
  515. console.log(`enterSc`);
  516. me.updateCache(addArr, updateArr, removeIds, result);
  517. me.sortGlj();
  518. me.currentCache = me.getCache();
  519. me.showGljItems(me.gljList, me.gljCurTypeId);
  520. }
  521. },
  522. error:function(err){
  523. alert("保存失败");
  524. }
  525. })
  526. },
  527. getCache: function() {
  528. var me = this, rst = [];
  529. for (var i = 0; i < me.gljList.length; i++) {
  530. if (me.gljList[i].gljClass == me.gljCurTypeId) {
  531. rst.push(me.gljList[i]);
  532. }
  533. }
  534. return rst;
  535. },
  536. updateCache: function(addArr, updateArr, removeIds, result) {
  537. var me = this, cacheSection = me.gljList;
  538. if (addArr.length > 0) {
  539. me.gljList = me.gljList.concat(addArr);
  540. cacheSection = me.gljList;
  541. }
  542. for (var i = removeIds.length - 1; i >= 0; i--) {
  543. for (var j = cacheSection.length - 1; j >= 0 ; j--) {
  544. if (cacheSection[j]["ID"] == removeIds[i]) {
  545. cacheSection.splice(j,1);
  546. }
  547. }
  548. }
  549. if (result && result.data.ops && result.data.ops.length > 0) {
  550. for (var i = 0; i < result.data.ops.length; i++) {
  551. for (var j = 0; j < cacheSection.length; j++) {
  552. if (cacheSection[j][me.setting.header[0].dataCode] == result.data.ops[i][me.setting.header[0].dataCode]) {
  553. cacheSection[j]["ID"] = result.data.ops[i]["ID"];
  554. }
  555. }
  556. }
  557. }
  558. for (var i = 0; i < updateArr.length; i++) {
  559. for (var j = 0; j < cacheSection.length; j++) {
  560. if (updateArr[i]["ID"] && cacheSection[j]["ID"]) {
  561. if (cacheSection[j]["ID"] == updateArr[i]["ID"]) {
  562. cacheSection[j] = updateArr[i];
  563. }
  564. } else {
  565. if (cacheSection[j][me.setting.header[0].dataCode] == updateArr[i][me.setting.header[0].dataCode]) {
  566. cacheSection[j] = updateArr[i];
  567. }
  568. }
  569. }
  570. }
  571. },
  572. sortGlj: function() {
  573. var me = this;
  574. me.gljList.sort(function(a, b){
  575. var rst = 0;
  576. if (a.code > b.code) rst = 1
  577. else if (a.code < b.code) rst = -1;
  578. return rst;
  579. });
  580. }
  581. }
  582. var gljTypeTreeOprObj = {
  583. onClick: function(event,treeId,treeNode) {
  584. var me = repositoryGljObj,
  585. gljTypeId = treeNode.ID;
  586. me.gljCurTypeId = treeNode.ID;
  587. me.currentCache = me.getCache();
  588. me.showGljItems(me.gljList, gljTypeId);
  589. console.log(me.gljCurTypeId);
  590. if (me.parentNodeIds["_pNodeId_" + treeNode.ID]) {
  591. sheetCommonObj.lockCodeCells(me.workBook.getSheet(0), me.gljList.length);
  592. //sheetCommonObj.shieldAllCells(me.workBook.getSheet(0), me.setting);
  593. } else {
  594. sheetCommonObj.unShieldAllCells(me.workBook.getSheet(0));
  595. }
  596. },
  597. beforeRename: function(treeId, treeNode, newName, isCancel) {
  598. if (newName.length == 0) {
  599. return false;
  600. }
  601. return true;
  602. },
  603. onRename : function(e, treeId, treeNode, isCancel) {
  604. var nodes = [];
  605. nodes.push(treeNode);
  606. gljTypeTreeOprObj.updateNodes(nodes);
  607. },
  608. onBeforeRemove: function(treeId, treeNode){
  609. if (treeNode.ParentID == -1 && treeNode.isFirstNode) {
  610. alert("不允许删除全部!");
  611. return false;
  612. }
  613. if (!confirm("您确定要删除此节点及所有子节点的数据?删除后不可恢复!")) {
  614. return false;
  615. }
  616. var nodeIds = [], preNode = treeNode.getPreNode(), preNodeId = -1;
  617. if (preNode) {
  618. preNodeId = preNode.ID;
  619. }
  620. private_fetchAllSubItems = function(pItem){
  621. nodeIds.push(pItem.ID);
  622. if (pItem.items && pItem.items.length > 0) {
  623. for (var i = 0; i < pItem.items.length; i++) {
  624. private_fetchAllSubItems(pItem.items[i]);
  625. }
  626. }
  627. };
  628. nodeIds.push(treeNode.ID);
  629. for (var i = 0; i < treeNode.items.length; i++) {
  630. private_fetchAllSubItems(treeNode.items[i]);
  631. }
  632. $.ajax({
  633. type:"POST",
  634. url:"api/deleteGljNodes",
  635. data:{"nodes": JSON.stringify(nodeIds), "preNodeId": preNodeId, "preNodeNextId": treeNode.NextSiblingID},
  636. dataType:"json",
  637. cache:false,
  638. timeout:5000,
  639. success:function(result,textStatus,status){
  640. var pNode = treeNode.getParentNode();
  641. if (pNode && pNode.items && pNode.items.length == 1) {
  642. pNode.isParent = false;
  643. }
  644. },
  645. error:function(){
  646. }
  647. });
  648. return true;
  649. },
  650. onRemove: function(e, treeId, treeNode){
  651. var me = repositoryGljObj, pNode = me.treeObj.getNodeByTId(treeNode.parentTId);
  652. if (pNode && pNode.items && pNode.items.length == 0) {
  653. pNode.isParent = false;
  654. me.treeObj.refresh();
  655. }
  656. },
  657. updateNodes: function(nodes){
  658. if (nodes && nodes.length > 0) {
  659. var reqData = []
  660. for (var i = 0; i < nodes.length; i++) {
  661. var node = {};
  662. node.repositoryId = nodes[i].repositoryId;
  663. node.ID = nodes[i].ID;
  664. node.ParentID = nodes[i].ParentID;
  665. node.NextSiblingID = nodes[i].NextSiblingID;
  666. node.Name = nodes[i].Name;
  667. if (nodes[i].__v != null) node.__v = nodes[i].__v + 1
  668. else node.__v = 0;
  669. reqData.push(node);
  670. }
  671. $.ajax({
  672. type:"POST",
  673. url:"api/updateGljNodes",
  674. data:{"nodes": JSON.stringify(reqData)},
  675. dataType:"json",
  676. cache:false,
  677. timeout:5000,
  678. success:function(result,textStatus,status){
  679. console.log(status + ' : ' + result);
  680. },
  681. error:function(){
  682. }
  683. })
  684. }
  685. },
  686. addRootNode: function() {
  687. var me = repositoryGljObj, rawNode = {ParentID: -1, NextSiblingID: -1, Name: "所有"}, lastNodeId = -1;
  688. if (me.treeObj) {
  689. var rootNodes = me.treeObj.getNodes();
  690. if (rootNodes.length == 0) {
  691. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  692. if (!(err)) {
  693. var newNodes = [], isSilent = false;
  694. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"所有",isParent:false, items:[]});
  695. me.treeObj.addNodes(null, -1, newNodes, isSilent);
  696. }
  697. });
  698. }
  699. }
  700. },
  701. addNewNode : function(rawNode, lastNodeId, callback){
  702. $.ajax({
  703. type:"POST",
  704. url:"api/createNewGljTypeNode",
  705. data:{"repositoryId": repositoryGljObj.currentRepositoryId,"lastNodeId": lastNodeId, "rawNodeData": JSON.stringify(rawNode)},
  706. dataType:"json",
  707. cache:false,
  708. timeout:1000,
  709. success: function(result,textStatus,status){
  710. callback(false, result);
  711. },
  712. error:function(err){
  713. callback(err);
  714. }
  715. })
  716. },
  717. addHoverDom: function(treeId, treeNode) {
  718. var me = repositoryGljObj, sObj = $("#" + treeNode.tId + "_span");
  719. if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length>0) return;
  720. var addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增子节点' onfocus='this.blur();'></span>";
  721. sObj.after(addStr);
  722. var btn = $("#addBtn_"+treeNode.tId);
  723. if (btn) btn.bind("click", function(){
  724. var rawNode = {ParentID: treeNode.ID, NextSiblingID: -1, Name: "新增子节点"}, lastNodeId = -1;
  725. if (treeNode.items.length > 0) {
  726. lastNodeId = treeNode.items[treeNode.items.length - 1].ID;
  727. }
  728. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  729. if (!(err)) {
  730. var newNodes = [], isSilent = false;
  731. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"新增子节点",isParent:false, items:[]});
  732. treeNode.isParent = true;
  733. if (me.treeObj) {
  734. me.treeObj.addNodes(treeNode, -1, newNodes, isSilent);
  735. } else {
  736. me.treeObj = $.fn.zTree.init($("#rationChapterTree"), gljSetting, newNodes);
  737. }
  738. }
  739. });
  740. });
  741. },
  742. removeHoverDom: function(treeId, treeNode) {
  743. $("#addBtn_"+treeNode.tId).unbind().remove();
  744. }
  745. }