repository_glj.js 43 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988
  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. $("#anzhuang").click(function(){
  11. $(this).attr('href', "/rationRepository/installation" + "?repository=" + getQueryString("repository"))
  12. });
  13. var pageOprObj = {
  14. rationLibName : null,
  15. rationLibId: null,
  16. initPage : function(container) {
  17. var me = this, rationLibId = getQueryString("repository"),//获取定额库参数
  18. rationLibName = storageUtil.getSessionCache("RationGrp","repositoryID_" + rationLibId);
  19. me.rationLibId = rationLibId;
  20. if (rationLibName) {
  21. var html = $("#rationname")[0].outerHTML;
  22. html = html.replace("XXX定额库", rationLibName);
  23. $("#rationname")[0].outerHTML = html;
  24. me.rationLibName = rationLibName;
  25. repositoryGljObj.buildSheet(container);
  26. repositoryGljObj.getRationGljIds(rationLibId);
  27. repositoryGljObj.getGljDistType(function () {
  28. repositoryGljObj.currentRepositoryId = parseInt(rationLibId);
  29. //引用的工料机库
  30. let gljLibID = storageUtil.getSessionCache("gljLib", "repositoryID_" + rationLibId);
  31. if(gljLibID && typeof gljLibID !== 'undefined'){
  32. repositoryGljObj.getGljTree(gljLibID, function () {
  33. repositoryGljObj.getGljItems(gljLibID);
  34. });
  35. }
  36. sheetCommonObj.shieldAllCells(repositoryGljObj.workBook.getSheet(0), repositoryGljObj.setting);
  37. });
  38. }
  39. }
  40. }
  41. repositoryGljObj = {
  42. treeObj : null,
  43. workBook: null,
  44. gljCurTypeId: -1,
  45. currentRepositoryId: -1,
  46. currentCache: null,
  47. parentNodeIds: {},
  48. gljList: [],
  49. distTypeTree: null,//add
  50. setting: {
  51. header:[
  52. {headerName:"编码",headerWidth:120,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  53. {headerName:"名称",headerWidth:260,dataCode:"name", dataType: "String", hAlign: "left", vAlign: "center"},
  54. {headerName:"规格型号",headerWidth:260,dataCode:"specs", dataType: "String", hAlign: "left", vAlign: "center"},
  55. {headerName:"单位",headerWidth:120,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"},
  56. {headerName:"定额价",headerWidth:120,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"},
  57. {headerName:"类型",headerWidth:120,dataCode:"gljType", dataType: "String", hAlign: "center", vAlign: "center"}
  58. ],
  59. view:{
  60. comboBox:[
  61. {row:-1,col:3,rowCount:-1,colCount:1}
  62. ],
  63. lockedCells:[
  64. ]
  65. }
  66. },
  67. getComboData: function (gljDistType) {
  68. let me = this;
  69. let distType;
  70. let distTypeTree = {
  71. prefix : 'gljType',
  72. distTypes: {},
  73. comboDatas: [],
  74. distTypesArr: []
  75. };
  76. gljDistType.forEach(function (typeData) {
  77. let typeObj = {
  78. data: typeData,
  79. children: [],
  80. parent: null
  81. }
  82. distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
  83. distTypeTree.distTypesArr.push(typeObj);
  84. });
  85. gljDistType.forEach(function (typeData) {
  86. distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
  87. let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
  88. if(parent){
  89. distType.parent = parent;
  90. parent.children.push(distType);
  91. }
  92. });
  93. distTypeTree.distTypesArr.forEach(function (distTypeObj) {
  94. if(distTypeObj.data.fullName !== '材料'){
  95. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  96. }
  97. });
  98. return distTypeTree;
  99. },
  100. getGljDistType: function (callback) {
  101. let me = this;
  102. $.ajax({
  103. type: 'post',
  104. url: "api/getGljDistType",
  105. dataType: 'json',
  106. success: function (result) {
  107. if(!result.error && callback){
  108. me.distTypeTree = me.getComboData(result.data);
  109. /*let combo = new GC.Spread.Sheets.CellTypes.ComboBox();
  110. combo.items(me.distTypeTree.comboDatas).editorValueType(GC.Spread.Sheets.CellTypes.EditorValueType.text);*/
  111. me.workBook.getSheet(0).getCell(-1, 5, GC.Spread.Sheets.SheetArea.viewport).value(me.distTypeTree.comboDatas[0].text);
  112. callback();
  113. }
  114. }
  115. })
  116. },
  117. getGljTree: function(gljLibID, callback) {
  118. var me = this;
  119. $.ajax({
  120. type:"POST",
  121. url:"api/getGljTree",
  122. data:{data: JSON.stringify({"gljLibId": gljLibID})},
  123. dataType:"json",
  124. cache:false,
  125. timeout:20000,
  126. success:function(result,textStatus,status){
  127. if(status.status == 200) {
  128. zTreeHelper.createTree(result.data, gljSetting, "repositoryTree", me);
  129. if (result.data && result.data.length > 0) {
  130. me.gljCurTypeId = result.data[0].ID;
  131. } else {
  132. gljTypeTreeOprObj.addRootNode();
  133. }
  134. callback();
  135. }
  136. },
  137. error:function(err){
  138. alert(err.responseJSON.error);
  139. }
  140. })
  141. },
  142. getGljItems: function(gljLibID) {
  143. var me = this;
  144. $.ajax({
  145. type:"POST",
  146. url:"api/getGljItems",
  147. data:{"repositoryId": gljLibID},
  148. dataType:"json",
  149. cache:false,
  150. timeout:10000,
  151. success:function(result){
  152. if(!result.error) {
  153. me.gljList = result.data;
  154. me.workBook.getSheet(0).setRowCount(result.data.length);
  155. me.sortGlj();
  156. let rootNode = me.treeObj.getNodes()[0];
  157. if(rootNode && rootNode.isParent && rootNode.isFirstNode){
  158. me.treeObj.selectNode(rootNode);
  159. gljTypeTreeOprObj.onClick(null, 'repositoryTree', rootNode);
  160. }
  161. //me.showGljItems(result.data, me.gljCurTypeId);
  162. }
  163. },
  164. error:function(err){
  165. alert(err.responseJSON.error);
  166. }
  167. })
  168. },
  169. showGljItems: function(data, type) {
  170. var me = repositoryGljObj;
  171. if (me.workBook) {
  172. var cacheSection = [];
  173. var pArr = me.parentNodeIds["_pNodeId_" + type];
  174. for (var i = 0; i < data.length; i++) {
  175. if (pArr && pArr.indexOf(data[i].gljClass) >= 0) {
  176. cacheSection.push(data[i]);
  177. } else if (type == data[i].gljClass) {
  178. //data[i].gljDistType = me.distTypeTree.distTypes[me.distTypeTree.prefix + data[i].gljDistType].data.fullName;
  179. cacheSection.push(data[i]);
  180. }
  181. }
  182. sheetCommonObj.cleanSheet(me.workBook.getSheet(0), me.setting, -1);
  183. sheetsOprObj.showData(me.workBook.getSheet(0), me.setting, cacheSection, me.distTypeTree);
  184. cacheSection = null;
  185. }
  186. },
  187. buildSheet: function(container) {
  188. var me = repositoryGljObj;
  189. me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30, me);
  190. me.workBook.getSheet(0).options.isProtected = true;
  191. /* me.repositoryGljDelOpr();
  192. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  193. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
  194. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditStarting, me.onCellEditStart);
  195. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd);
  196. //me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.RangeChanged, me.onRangeChanged);
  197. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onEnterCell);*/
  198. },
  199. onEnterCell: function (sender, args) {
  200. let me = repositoryGljObj;
  201. me.cellRowIdx = args.row;
  202. let isHasData = false;
  203. if(me.addGljObj){
  204. for(let i=0; i<me.setting.header.length; i++){
  205. if(me.addGljObj[me.setting.header[i].dataCode]){
  206. isHasData = true;
  207. break;
  208. }
  209. }
  210. }
  211. if(isHasData){
  212. if(me.editingRowIdx !== me.cellRowIdx) {
  213. let isComple = true;
  214. let focusToCol;
  215. function getFocusToCol (me){
  216. if(!me.addGljObj[me.setting.header[0].dataCode]){
  217. $('#alertGljTxt').text('编号不能为空,是否取消增加人材机?');
  218. return 0;
  219. }
  220. else if(!me.addGljObj[me.setting.header[1].dataCode]){
  221. $('#alertGljTxt').text('名称不能为空,是否取消增加人材机?');
  222. return 1;
  223. }
  224. else if(!me.addGljObj[me.setting.header[5].dataCode]){
  225. $('#alertGljTxt').text('类型不能为空,是否取消增加人材机?');
  226. return 5;
  227. }
  228. else {
  229. return -1;
  230. }
  231. }
  232. focusToCol = getFocusToCol(me);
  233. if(focusToCol === -1){
  234. }
  235. else {
  236. $('#gljAlertBtn').click();
  237. //me.workBook.getSheet(0).options.isProtected = true;
  238. sheetCommonObj.lockAllCells(args.sheet);
  239. $('#aleCanceBtn').click(function () {
  240. // me.workBook.getSheet(0).options.isProtected = false;
  241. sheetCommonObj.unLockAllCells(args.sheet);
  242. sheetsOprObj.reLockSomeCodes(args.sheet, 0, repositoryGljObj.currentCache.length);
  243. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  244. });
  245. $('#gljAleClose').click(function () {
  246. // me.workBook.getSheet(0).options.isProtected = false;
  247. sheetCommonObj.unLockAllCells(args.sheet);
  248. sheetsOprObj.reLockSomeCodes(args.sheet, 0, repositoryGljObj.currentCache.length);
  249. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  250. });
  251. $('#aleConfBtn').click(function () {
  252. // me.workBook.getSheet(0).options.isProtected = false;
  253. sheetCommonObj.unLockAllCells(args.sheet);
  254. sheetsOprObj.reLockSomeCodes(args.sheet, 0, repositoryGljObj.currentCache.length);
  255. me.addGljObj = null;
  256. for(let col=0; col<me.setting.header.length; col++){
  257. let field = me.setting.header[col].dataCode;
  258. if(field === 'gljType'){
  259. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value(
  260. me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj[field]].data.fullName);
  261. }
  262. else{
  263. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value(me.currentEditingGlj[me.setting.header[col].dataCode]);
  264. }
  265. }
  266. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, 0);
  267. });
  268. }
  269. }
  270. }
  271. },
  272. onCellEditStart: function(sender, args) {
  273. var me = repositoryGljObj;
  274. var rObj = sheetsOprObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row);
  275. me.currentEditingGlj = rObj;
  276. me.orgCode = me.workBook.getSheet(0).getValue(args.row, 0);
  277. var cacheSection = me.gljList;
  278. if (cacheSection) {
  279. for (var j = 0; j < cacheSection.length; j++) {
  280. if (cacheSection[j][me.setting.header[0].dataCode] && cacheSection[j][me.setting.header[0].dataCode] == rObj[me.setting.header[0].dataCode]) {
  281. rObj["ID"] = cacheSection[j]["ID"];
  282. rObj.gljClass = cacheSection[j].gljClass;
  283. break;
  284. }
  285. }
  286. }
  287. },
  288. onCellEditEnd: function(sender, args) {
  289. var me = repositoryGljObj, rObj = sheetsOprObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row, me),
  290. updateArr = [], addArr = [], updateBasePrcArr = [];
  291. me.editingRowIdx = args.row;
  292. rObj.basePrice = rObj.basePrice ? rObj.basePrice : 0;
  293. if (me.currentEditingGlj["ID"]) {
  294. rObj["ID"] = me.currentEditingGlj["ID"];
  295. rObj.gljClass = me.currentEditingGlj.gljClass;
  296. for(let col =0; col< me.setting.header.length; col++){
  297. if(me.currentEditingGlj[me.setting.header[col].dataCode] !== rObj[me.setting.header[col].dataCode]){
  298. me.addGljObj = rObj;
  299. if(rObj[me.setting.header[0].dataCode] && rObj[me.setting.header[1].dataCode] && rObj[me.setting.header[5].dataCode]){
  300. updateArr.push(rObj);
  301. break;
  302. }
  303. }
  304. }
  305. if(me.currentEditingGlj.basePrice !== rObj.basePrice){
  306. //update basePrice of ration when editting basePrice of glj
  307. let gljType = -1;
  308. let gljTypeParent = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj.gljType].parent;
  309. if(gljTypeParent && gljTypeParent.data.ID <=3){
  310. gljType = gljTypeParent.data.ID;
  311. }
  312. if(!gljTypeParent && me.currentEditingGlj.gljType <= 3){
  313. gljType = me.currentEditingGlj.gljType;
  314. }
  315. let gljBasePrcObj = {gljId: me.currentEditingGlj.ID, gljType: gljType, basePrice: rObj.basePrice};
  316. if(gljBasePrcObj.gljType !== -1){
  317. updateBasePrcArr.push(gljBasePrcObj);
  318. me.updateRationBasePrcRq(updateBasePrcArr);
  319. }
  320. }
  321. //update basePrice of ration when editting gljType of glj
  322. if(me.currentEditingGlj.gljType !== rObj.gljType){
  323. let gljTypeObj = {gljId: me.currentEditingGlj.ID, gljType: rObj.gljType, basePrice: rObj.basePrice};
  324. updateBasePrcArr.push(gljTypeObj);
  325. me.updateRationBasePrcRq(updateBasePrcArr);
  326. }
  327. } else {
  328. me.addGljObj = rObj;
  329. let isCanSav = true;
  330. if(!rObj[me.setting.header[0].dataCode] || !rObj[me.setting.header[1].dataCode] || !rObj[me.setting.header[5].dataCode]){
  331. isCanSav = false;
  332. }
  333. if(isCanSav){
  334. me.addGljObj = null;
  335. addArr.push(rObj);
  336. }
  337. }
  338. if(me.gljCurTypeId !== 1){
  339. rObj.gljClass = me.gljCurTypeId;
  340. }
  341. if(updateArr.length >0 || addArr.length >0){
  342. me.currentEditingGlj = null;
  343. //me.workBook.getSheet(0).setValue(11, 5, "人工");
  344. me.mixUpdateRequest(updateArr, addArr, []);
  345. }
  346. },
  347. repositoryGljDelOpr: function () {
  348. let me = repositoryGljObj;
  349. me.workBook.commandManager().register('repositoryGljDel', function () {
  350. let sheet = me.workBook.getSheet(0),
  351. updateArr = [], removeArr = [],
  352. tempRemoveArr= [],
  353. refGljCodes = [], //已被引用的工料机
  354. updateBasePrcArr = [],//删除基价单位后重新计算
  355. sels = sheet.getSelections(),
  356. cacheSection = me.currentCache;
  357. if(sels.length > 0 && cacheSection.length > 0){
  358. for(let i = 0; i < sels.length; i++){
  359. if(sels[i].colCount === me.setting.header.length){
  360. for(let j = 0; j < sels[i].rowCount; j++){
  361. if(sels[i].row + j < cacheSection.length){
  362. tempRemoveArr.push({ID: cacheSection[sels[i].row + j].ID, code: cacheSection[sels[i].row + j].code});
  363. }
  364. }
  365. }
  366. else{
  367. let maxCol = sels[i].col + sels[i].colCount - 1;
  368. if(sels[i].col >= 2 && maxCol <= 4){
  369. for(let j = 0; j < sels[i].rowCount; j++){
  370. if(sels[i].row + j < cacheSection.length){
  371. let updateObj = cacheSection[sels[i].row + j];
  372. for(let col = sels[i].col; col <= maxCol; col++){
  373. if(me.setting.header[col].dataCode === 'basePrice'){
  374. updateObj[me.setting.header[col].dataCode] = 0;
  375. updateBasePrcArr.push({gljId: updateObj.ID, gljType: updateObj.gljType, basePrice: 0});
  376. }
  377. else{
  378. updateObj[me.setting.header[col].dataCode] = '';
  379. }
  380. }
  381. updateArr.push(updateObj);
  382. }
  383. }
  384. }
  385. //编号、名称、类型不可为空
  386. else{
  387. if(sels[i].row < cacheSection.length){
  388. let text = '', cantNullStr =['编码', '名称', '类型'];
  389. for(let col = sels[i].col; col <= sels[i].col + sels[i].colCount -1; col++){
  390. if(cantNullStr.indexOf(me.setting.header[col].headerName) !== -1){
  391. text += me.setting.header[col].headerName + " ";
  392. }
  393. }
  394. $('#alertText').text(text + "不可为空!");
  395. $('#codeAlertBtn').click();
  396. sheet.options.isProtected = true;
  397. $('#codAleConfBtn').click(function () {
  398. sheetsOprObj.lockSomeCodes(sheet, 0, cacheSection.length);
  399. });
  400. $('#codAleClose').click(function () {
  401. sheetsOprObj.lockSomeCodes(sheet, 0, cacheSection.length);
  402. });
  403. }
  404. }
  405. }
  406. }
  407. //提取已被引用工料机
  408. if(tempRemoveArr.length > 0){
  409. for(let i = 0; i < tempRemoveArr.length; i++){
  410. if(me.rationGljIds.indexOf(tempRemoveArr[i].ID) !== -1){
  411. refGljCodes.push(tempRemoveArr[i].code);
  412. tempRemoveArr.splice(i--, 1);
  413. }
  414. else{
  415. removeArr.push(tempRemoveArr[i].ID);
  416. }
  417. }
  418. }
  419. //提示
  420. if(refGljCodes.length > 0){
  421. let alertText;
  422. if(refGljCodes.length > 3){
  423. alertText = "编号: " + refGljCodes[0]+" 、" + refGljCodes[1] + " 、" + refGljCodes[2] + "...等人材机已有定额引用,删除失败!";
  424. }
  425. else {
  426. let alertCode = " ";
  427. for(let i=0; i< refGljCodes.length; i++){
  428. alertCode += refGljCodes[i] + " 、";
  429. }
  430. alertText = "编号:" + alertCode + "人材机已有定额引用,删除失败!"
  431. }
  432. $('#alertText').text(alertText);
  433. $('#codeAlertBtn').click();
  434. sheet.options.isProtected = true;
  435. $('#codAleConfBtn').click(function () {
  436. sheetsOprObj.lockSomeCodes(sheet, 0, cacheSection.length);
  437. if(removeArr.length > 0){
  438. me.mixUpdateRequest(updateArr, [], removeArr);
  439. }
  440. });
  441. $('#codAleClose').click(function () {
  442. sheetsOprObj.lockSomeCodes(sheet, 0, cacheSection.length);
  443. me.mixUpdateRequest(updateArr, [], removeArr);
  444. });
  445. }
  446. else if(removeArr.length > 0 || updateArr.length > 0){
  447. me.mixUpdateRequest(updateArr, [], removeArr);
  448. if(updateBasePrcArr.length > 0){
  449. me.updateRationBasePrcRq(updateBasePrcArr);
  450. }
  451. }
  452. }
  453. });
  454. me.workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.del, false, false, false, false);
  455. me.workBook.commandManager().setShortcutKey('repositoryGljDel', GC.Spread.Commands.Key.del, false, false, false, false);
  456. },
  457. validUpdateObj: function (pasteObj, rowIdx) {
  458. let rst = {}, backUpObj = {},
  459. me = repositoryGljObj,
  460. tempObj = me.currentCache[rowIdx],
  461. reCalBasePrc = false, isValid = true;
  462. //备份原始数据
  463. for(let atr in tempObj){
  464. backUpObj[atr] = tempObj[atr];
  465. }
  466. if(typeof pasteObj.code !== 'undefined'){
  467. if(pasteObj.code.trim().length !== 0){
  468. let isExist = false;
  469. for(let i = 0; i < me.gljList.length; i++){
  470. if(me.gljList[i].code === pasteObj.code){
  471. isExist = true;
  472. break;
  473. }
  474. }
  475. if(!isExist){
  476. tempObj.code = pasteObj.code;
  477. }
  478. else isValid = false;
  479. }
  480. else isValid = false;
  481. }
  482. if(typeof pasteObj.name !== 'undefined'){
  483. if(pasteObj.name.trim().length === 0) isValid = false;
  484. else tempObj.name = pasteObj.name;
  485. }
  486. if(typeof pasteObj.specs !== 'undefined'){
  487. tempObj.specs = pasteObj.specs;
  488. }
  489. if(typeof pasteObj.unit !== 'undefined'){
  490. tempObj.unit = pasteObj.unit;
  491. }
  492. if(typeof pasteObj.gljType !== 'undefined'){
  493. let isExsit = false;
  494. for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){
  495. if(pasteObj.gljType === me.distTypeTree.comboDatas[i].text){
  496. isExsit = true;
  497. reCalBasePrc = true;
  498. tempObj.gljType = me.distTypeTree.comboDatas[i].value;
  499. tempObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + tempObj.gljType].data.shortName;
  500. }
  501. }
  502. if(!isExsit) isValid = false;
  503. }
  504. //
  505. pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? parseFloat(pasteObj.basePrice) :
  506. me.currentCache[rowIdx].basePrice;
  507. if(pasteObj.basePrice !== me.currentCache[rowIdx].basePrice){
  508. reCalBasePrc = true;
  509. tempObj.basePrice = pasteObj.basePrice;
  510. }
  511. if(isValid){
  512. rst.updateGlj = tempObj;
  513. if(reCalBasePrc){
  514. //重新计算定额基价对象
  515. rst.updateBasePrc = {gljId: tempObj.ID, gljType: tempObj.gljType, basePrice: tempObj.basePrice};
  516. }
  517. }
  518. else {
  519. for(let attr in backUpObj){
  520. tempObj[attr] = backUpObj[attr];
  521. }
  522. }
  523. return rst;
  524. },
  525. //粘贴的数据是否是可添加的数据,只有含有编号,名称,类型才可添加
  526. isValidObj: function(pasteObj) {
  527. let me = repositoryGljObj;
  528. if(!(pasteObj.code && typeof pasteObj.code !== 'undefined') || !(pasteObj.name && typeof pasteObj.name !== 'undefined') ||
  529. !(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined')){
  530. return false;
  531. }
  532. if(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined'){
  533. let isExist = false;
  534. for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){
  535. if(me.distTypeTree.comboDatas[i].text === pasteObj.gljType){
  536. isExist = true;
  537. pasteObj.gljType = me.distTypeTree.comboDatas[i].value;
  538. pasteObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + pasteObj.gljType].data.shortName;
  539. break;
  540. }
  541. }
  542. if(!isExist){
  543. return false;
  544. }
  545. }
  546. if(pasteObj.code && typeof pasteObj.code !== 'undefined'){
  547. for(let i = 0; i < me.gljList.length; i++){
  548. if(me.gljList[i].code === pasteObj.code){
  549. return false;
  550. }
  551. }
  552. }
  553. pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? parseFloat(pasteObj.basePrice) : 0;
  554. pasteObj.gljClass = me.gljCurTypeId;
  555. return true;
  556. },
  557. onClipboardPasting: function(sender, args) {
  558. var me = repositoryGljObj;
  559. /*if (args.cellRange.colCount != me.setting.header.length || me.gljCurTypeId < 0 || me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]) {
  560. args.cancel = true;
  561. }*/
  562. if (me.gljCurTypeId < 0 ) {
  563. args.cancel = true;
  564. }
  565. },
  566. onClipboardPasted: function(e, info) {
  567. var me = repositoryGljObj;
  568. var updateArr = [], addArr = [];
  569. var items = sheetCommonObj.analyzePasteData(me.setting, info);
  570. let beginRow = info.cellRange.row, endRow = info.cellRange.row + info.cellRange.rowCount - 1,
  571. maxRow = me.currentCache.length - 1, updateItems = [], addItems = [], updateBasePrcArr = [] , updateCount, resumeArr = [];
  572. if(endRow <= maxRow){
  573. //updateItems = items;
  574. for(let i = 0; i < items.length; i++){
  575. let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i);
  576. if(updateObj && typeof updateObj.updateGlj !== 'undefined'){
  577. updateArr.push(updateObj.updateGlj);
  578. if(typeof updateObj.updateBasePrc !== 'undefined'){
  579. updateBasePrcArr.push(updateObj.updateBasePrc);
  580. }
  581. }
  582. else{
  583. resumeArr.push(info.cellRange.row + i);
  584. }
  585. }
  586. }
  587. else if(beginRow <= maxRow && endRow > maxRow){
  588. updateCount = maxRow - beginRow + 1;
  589. for(let i = 0; i < updateCount; i++){
  590. let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i);
  591. if(updateObj && typeof updateObj.updateGlj !== 'undefined'){
  592. updateArr.push(updateObj.updateGlj);
  593. if(typeof updateObj.updateBasePrc !== 'undefined'){
  594. updateBasePrcArr.push(updateObj.updateBasePrc);
  595. }
  596. }
  597. else{
  598. resumeArr.push(info.cellRange.row + i);
  599. }
  600. }
  601. if(info.cellRange.colCount === me.setting.header.length){
  602. for(let i = updateCount ; i < items.length; i++){
  603. if(me.isValidObj(items[i])){
  604. addItems.push(items[i]);
  605. addArr.push(items[i]);
  606. }
  607. else{
  608. resumeArr.push(info.cellRange.row + i);
  609. }
  610. }
  611. }
  612. else{
  613. for(let i = updateCount ; i < items.length; i++){
  614. resumeArr.push(info.cellRange.row + i);
  615. }
  616. }
  617. }
  618. else{
  619. if(info.cellRange.colCount === me.setting.header.length){
  620. for(let i = 0; i < items.length; i++){
  621. if(me.isValidObj(items[i])){
  622. addArr.push(items[i]);
  623. }
  624. else{
  625. resumeArr.push(info.cellRange.row + i);
  626. }
  627. }
  628. }
  629. else{
  630. for(let i = 0; i < items.length; i++){
  631. resumeArr.push(info.cellRange.row + i);
  632. }
  633. }
  634. }
  635. //repaint
  636. if(resumeArr.length > 0){
  637. info.sheet.suspendPaint();
  638. for(let i = 0; i < resumeArr.length ; i++){
  639. if(resumeArr[i] < me.currentCache.length){
  640. for(let col = 0; col < me.setting.header.length; col++){
  641. if(me.setting.header[col].dataCode === 'gljType'){
  642. let gljType = me.currentCache[resumeArr[i]][me.setting.header[col].dataCode];
  643. info.sheet.setValue(resumeArr[i], col, me.distTypeTree.distTypes["gljType" + gljType].data.fullName);
  644. }
  645. else{
  646. info.sheet.setValue(resumeArr[i], col, me.currentCache[resumeArr[i]][me.setting.header[col].dataCode]);
  647. }
  648. }
  649. }
  650. else{
  651. for(let col = 0; col < me.setting.header.length; col++){
  652. info.sheet.setValue(resumeArr[i], col, '');
  653. }
  654. }
  655. }
  656. info.sheet.resumePaint();
  657. }
  658. if (updateArr.length > 0 || addArr.length > 0) {
  659. me.mixUpdateRequest(updateArr, addArr, []);
  660. }
  661. if(updateBasePrcArr.length > 0){
  662. me.updateRationBasePrcRq(updateBasePrcArr);
  663. }
  664. },
  665. updateRationBasePrcRq: function (basePrcArr) {
  666. $.ajax({
  667. type: 'post',
  668. url: 'api/updateRationBasePrc',
  669. data:{data: JSON.stringify({repId: pageOprObj.rationLibId, lastOpr: userAccount, basePrcArr: basePrcArr})},
  670. dataType: 'json',
  671. success: function (result) {
  672. if(result.error){
  673. alert("计算定额基价失败");
  674. }
  675. }
  676. });
  677. },
  678. getRationGljIds: function (repId) {
  679. let me = repositoryGljObj;
  680. $.ajax({
  681. type: 'post',
  682. url: 'api/getRationGljIds',
  683. data: {data: JSON.stringify({repId: repId})},
  684. dataType: 'json',
  685. success: function(result){
  686. if(!result.error){
  687. me.rationGljIds = result.data;
  688. }
  689. }
  690. });
  691. },
  692. mixUpdateRequest: function(updateArr, addArr, removeIds) {
  693. var me = repositoryGljObj;
  694. $.ajax({
  695. type:"POST",
  696. url:"api/mixUpdateGljItems",
  697. data:{"repositoryId": me.currentRepositoryId, "lastOpr": userAccount, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr), "removeIds": JSON.stringify(removeIds)},
  698. dataType:"json",
  699. cache:false,
  700. timeout:5000,
  701. success:function(result){
  702. if (result.error) {
  703. alert(result.message);
  704. me.getRationItems(me.currentRepositoryId);
  705. } else {
  706. me.updateCache(addArr, updateArr, removeIds, result);
  707. me.sortGlj();
  708. if(me.currentOprParent === 1){
  709. me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]);
  710. }
  711. else{
  712. me.currentCache = me.getCache();
  713. //sheetCommonObj.unLockAllCells(me.workBook.getSheet(0));
  714. sheetsOprObj.reLockSomeCodes(me.workBook.getSheet(0), 0, me.currentCache.length);
  715. //sheetCommonObj.lockSomeCodes(me.workBook.getSheet(0), 0, me.currentCache.length);
  716. }
  717. me.showGljItems(me.gljList, me.gljCurTypeId);
  718. }
  719. },
  720. error:function(err){
  721. alert("保存失败");
  722. }
  723. })
  724. },
  725. getParentCache: function (nodes) {
  726. let me = repositoryGljObj, rst = [];
  727. for(let i = 0; i < me.gljList.length; i++){
  728. if(nodes.indexOf(me.gljList[i].gljClass) !== -1){
  729. rst.push(me.gljList[i]);
  730. }
  731. }
  732. rst.sort(function (a, b) {
  733. let rst = 0;
  734. if(a.code > b.code) rst = 1;
  735. else if(a.code < b.code)rst = -1;
  736. return rst;
  737. });
  738. return rst;
  739. },
  740. getCache: function() {
  741. var me = this, rst = [];
  742. for (var i = 0; i < me.gljList.length; i++) {
  743. if (me.gljList[i].gljClass == me.gljCurTypeId) {
  744. rst.push(me.gljList[i]);
  745. }
  746. }
  747. return rst;
  748. },
  749. updateCache: function(addArr, updateArr, removeIds, result) {
  750. var me = this, cacheSection = me.gljList;
  751. if (addArr.length > 0) {
  752. me.gljList = me.gljList.concat(addArr);
  753. cacheSection = me.gljList;
  754. }
  755. for (var i = removeIds.length - 1; i >= 0; i--) {
  756. for (var j = cacheSection.length - 1; j >= 0 ; j--) {
  757. if (cacheSection[j]["ID"] == removeIds[i]) {
  758. cacheSection.splice(j,1);
  759. }
  760. }
  761. }
  762. if (result && result.data.ops && result.data.ops.length > 0) {
  763. for (var i = 0; i < result.data.ops.length; i++) {
  764. for (var j = 0; j < cacheSection.length; j++) {
  765. if (cacheSection[j][me.setting.header[0].dataCode] == result.data.ops[i][me.setting.header[0].dataCode]) {
  766. cacheSection[j]["ID"] = result.data.ops[i]["ID"];
  767. }
  768. }
  769. }
  770. }
  771. for (var i = 0; i < updateArr.length; i++) {
  772. for (var j = 0; j < cacheSection.length; j++) {
  773. if (updateArr[i]["ID"] && cacheSection[j]["ID"]) {
  774. if (cacheSection[j]["ID"] == updateArr[i]["ID"]) {
  775. cacheSection[j] = updateArr[i];
  776. }
  777. } else {
  778. if (cacheSection[j][me.setting.header[0].dataCode] == updateArr[i][me.setting.header[0].dataCode]) {
  779. cacheSection[j] = updateArr[i];
  780. }
  781. }
  782. }
  783. }
  784. },
  785. sortGlj: function() {
  786. var me = this;
  787. me.gljList.sort(function(a, b){
  788. var rst = 0;
  789. if (a.code > b.code) rst = 1
  790. else if (a.code < b.code) rst = -1;
  791. return rst;
  792. });
  793. }
  794. }
  795. var gljTypeTreeOprObj = {
  796. onClick: function(event,treeId,treeNode) {
  797. var me = repositoryGljObj,
  798. gljTypeId = treeNode.ID;
  799. me.gljCurTypeId = treeNode.ID;
  800. if (me.parentNodeIds["_pNodeId_" + treeNode.ID]) {
  801. me.currentOprParent = 1;
  802. me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + treeNode.ID]);
  803. // sheetCommonObj.lockCodeCells(me.workBook.getSheet(0), me.currentCache.length);
  804. me.workBook.getSheet(0).setRowCount(me.currentCache.length);
  805. } else {
  806. me.currentOprParent = 0;
  807. me.currentCache = me.getCache();
  808. me.workBook.getSheet(0).setRowCount(me.currentCache.length);
  809. /*sheetCommonObj.unLockAllCells(me.workBook.getSheet(0));
  810. sheetCommonObj.reLockSomeCodes(me.workBook.getSheet(0), 0, me.currentCache.length);*/
  811. }
  812. me.showGljItems(me.gljList, gljTypeId);
  813. me.workBook.getSheet(0).setRowCount(me.currentCache.length);
  814. },
  815. beforeRename: function(treeId, treeNode, newName, isCancel) {
  816. if (newName.length == 0) {
  817. return false;
  818. }
  819. return true;
  820. },
  821. onRename : function(e, treeId, treeNode, isCancel) {
  822. var nodes = [];
  823. nodes.push(treeNode);
  824. gljTypeTreeOprObj.updateNodes(nodes);
  825. },
  826. onBeforeRemove: function(treeId, treeNode){
  827. let me = this;
  828. if (treeNode.ParentID == -1 && treeNode.isFirstNode) {
  829. alert("不允许删除全部!");
  830. return false;
  831. }
  832. if (!confirm("您确定要删除此节点及所有子节点的数据?删除后不可恢复!")) {
  833. return false;
  834. }
  835. var nodeIds = [], preNode = treeNode.getPreNode(), preNodeId = -1;
  836. if (preNode) {
  837. preNodeId = preNode.ID;
  838. }
  839. private_fetchAllSubItems = function(pItem){
  840. nodeIds.push(pItem.ID);
  841. if (pItem.items && pItem.items.length > 0) {
  842. for (var i = 0; i < pItem.items.length; i++) {
  843. private_fetchAllSubItems(pItem.items[i]);
  844. }
  845. }
  846. };
  847. nodeIds.push(treeNode.ID);
  848. for (var i = 0; i < treeNode.items.length; i++) {
  849. private_fetchAllSubItems(treeNode.items[i]);
  850. }
  851. $.ajax({
  852. type:"POST",
  853. url:"api/deleteGljNodes",
  854. data:{"repId": pageOprObj.rationLibId, "lastOpr": userAccount, "nodes": JSON.stringify(nodeIds), "preNodeId": preNodeId, "preNodeNextId": treeNode.NextSiblingID},
  855. dataType:"json",
  856. cache:false,
  857. timeout:5000,
  858. success:function(result,textStatus,status){
  859. var pNode = treeNode.getParentNode();
  860. if (pNode && pNode.items && pNode.items.length == 1) {
  861. pNode.isParent = false;
  862. }
  863. },
  864. error:function(){
  865. }
  866. });
  867. return true;
  868. },
  869. onRemove: function(e, treeId, treeNode){
  870. var me = repositoryGljObj, pNode = me.treeObj.getNodeByTId(treeNode.parentTId);
  871. if (pNode && pNode.items && pNode.items.length == 0) {
  872. pNode.isParent = false;
  873. me.treeObj.refresh();
  874. }
  875. },
  876. updateNodes: function(nodes){
  877. if (nodes && nodes.length > 0) {
  878. var reqData = []
  879. for (var i = 0; i < nodes.length; i++) {
  880. var node = {};
  881. node.repositoryId = nodes[i].repositoryId;
  882. node.ID = nodes[i].ID;
  883. node.ParentID = nodes[i].ParentID;
  884. node.NextSiblingID = nodes[i].NextSiblingID;
  885. node.Name = nodes[i].Name;
  886. if (nodes[i].__v != null) node.__v = nodes[i].__v + 1
  887. else node.__v = 0;
  888. reqData.push(node);
  889. }
  890. $.ajax({
  891. type:"POST",
  892. url:"api/updateGljNodes",
  893. data:{"repId": pageOprObj.rationLibId, "lastOpr": userAccount, "nodes": JSON.stringify(reqData)},
  894. dataType:"json",
  895. cache:false,
  896. timeout:5000,
  897. success:function(result,textStatus,status){
  898. console.log(status + ' : ' + result);
  899. },
  900. error:function(){
  901. }
  902. })
  903. }
  904. },
  905. addRootNode: function() {
  906. var me = repositoryGljObj, rawNode = {ParentID: -1, NextSiblingID: -1, Name: "所有"}, lastNodeId = -1;
  907. if (me.treeObj) {
  908. var rootNodes = me.treeObj.getNodes();
  909. if (rootNodes.length == 0) {
  910. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  911. if (!(err)) {
  912. var newNodes = [], isSilent = false;
  913. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"所有",isParent:false, items:[]});
  914. me.treeObj.addNodes(null, -1, newNodes, isSilent);
  915. }
  916. });
  917. }
  918. }
  919. },
  920. addNewNode : function(rawNode, lastNodeId, callback){
  921. $.ajax({
  922. type:"POST",
  923. url:"api/createNewGljTypeNode",
  924. data:{"lastOpr": userAccount, "repositoryId": repositoryGljObj.currentRepositoryId,"lastNodeId": lastNodeId, "rawNodeData": JSON.stringify(rawNode)},
  925. dataType:"json",
  926. cache:false,
  927. timeout:1000,
  928. success: function(result,textStatus,status){
  929. callback(false, result);
  930. },
  931. error:function(err){
  932. callback(err);
  933. }
  934. })
  935. },
  936. addHoverDom: function(treeId, treeNode) {
  937. if(typeof treeNode.doing !== 'undefined' && treeNode.doing){
  938. return false;
  939. }
  940. hoverOpr();
  941. function hoverOpr(){
  942. //console.log(treeNode);
  943. var me = repositoryGljObj, sObj = $("#" + treeNode.tId + "_span");
  944. if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length>0) return;
  945. var addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增子节点' onfocus='this.blur();'></span>";
  946. sObj.after(addStr);
  947. var btn = $("#addBtn_"+treeNode.tId);
  948. if (btn) btn.bind("click", function(){
  949. treeNode.doing = true;
  950. var rawNode = {ParentID: treeNode.ID, NextSiblingID: -1, Name: "新增子节点"}, lastNodeId = -1;
  951. if (treeNode.items.length > 0) {
  952. lastNodeId = treeNode.items[treeNode.items.length - 1].ID;
  953. }
  954. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  955. if (!(err)) {
  956. var newNodes = [], isSilent = false;
  957. if(treeNode.items.length > 0){
  958. treeNode.items[treeNode.items.length - 1].NextSiblingID = rst.data.ID;
  959. }
  960. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"新增子节点",isParent:false, items:[]});
  961. treeNode.isParent = true;
  962. if (me.treeObj) {
  963. me.treeObj.addNodes(treeNode, -1, newNodes, isSilent);
  964. } else {
  965. me.treeObj = $.fn.zTree.init($("#rationChapterTree"), gljSetting, newNodes);
  966. }
  967. treeNode.doing = false;
  968. hoverOpr();
  969. }
  970. });
  971. });
  972. }
  973. },
  974. removeHoverDom: function(treeId, treeNode) {
  975. $("#addBtn_"+treeNode.tId).unbind().remove();
  976. }
  977. }