repository_glj.js 32 KB

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