glj.js 60 KB

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