glj.js 86 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901
  1. /**
  2. * Created by Zhong on 2017/8/14.
  3. */
  4. $(document).ready(function () {
  5. let moduleName = 'stdGLj';
  6. function refreshALlWorkBook() {
  7. if (gljClassTreeObj.workBook) {
  8. gljClassTreeObj.workBook.refresh();
  9. }
  10. if (repositoryGljObj.workBook) {
  11. repositoryGljObj.workBook.refresh();
  12. }
  13. if (gljComponentOprObj.workBook) {
  14. gljComponentOprObj.workBook.refresh();
  15. }
  16. }
  17. SlideResize.loadHorizonWidth(moduleName, [$('#slideResizeLeft'), $('#slideResizeRight')], [$('#leftContent'), $('#midContent'), $('#rightContent')], function () {
  18. refreshALlWorkBook();
  19. });
  20. //章节树与人材机表
  21. let leftElesObj = {};
  22. leftElesObj.module = moduleName;
  23. leftElesObj.resize = $('#slideResizeLeft');
  24. leftElesObj.parent = $('#dataRow');
  25. leftElesObj.left = $('#leftContent');
  26. leftElesObj.right = $('#midContent');
  27. SlideResize.horizontalSlide(leftElesObj, {min: 200, max: `$('#dataRow').width() - $('#rightContent').width() - 200`}, function () {
  28. refreshALlWorkBook();
  29. });
  30. //人材机表与人材机组成物表
  31. let rightElesObj = {};
  32. rightElesObj.module = moduleName;
  33. rightElesObj.resize = $('#slideResizeRight');
  34. rightElesObj.parent = $('#dataRow');
  35. rightElesObj.left = $('#midContent');
  36. rightElesObj.right = $('#rightContent');
  37. SlideResize.horizontalSlide(rightElesObj, {min: 200, max: `$('#dataRow').width() - $('#leftContent').width() - 200`}, function () {
  38. refreshALlWorkBook();
  39. });
  40. });
  41. const digital = {
  42. basePrice: -2,
  43. consumeAmt: -3
  44. };
  45. let pageOprObj = {
  46. gljLibName : null,
  47. gljLibId: null,
  48. initPage : function(container, containerComponent, containerC) {
  49. let me = this, gljLibId = getQueryString("gljLibId");//获取定额库参数
  50. me.gljLibId = gljLibId;
  51. //生成人材机表格列头
  52. repositoryGljObj.setting.header = repositoryGljObj.initHeaders(priceProperties);
  53. //生成列映射
  54. sheetCommonObj.initColMapping(repositoryGljObj, repositoryGljObj.setting.header);
  55. //生成单价列下标数组
  56. repositoryGljObj.initPriceCols(priceProperties, repositoryGljObj.colMapping);
  57. repositoryGljObj.getGljLib(gljLibId, function () {
  58. repositoryGljObj.buildSheet(container);
  59. gljComponentOprObj.buildSheet(containerComponent);
  60. componentOprObj.buildSheet(containerC);
  61. //获得定额库中引用此工料机库中的,所有被定额所套的工料机的ID
  62. //repositoryGljObj.getRationGljIds(gljLibId);
  63. repositoryGljObj.getGljDistType(function () {
  64. repositoryGljObj.currentRepositoryId = parseInt(gljLibId);
  65. /* repositoryGljObj.getGljTree(gljLibId, function () {
  66. repositoryGljObj.getGljItems(gljLibId);
  67. });*/
  68. repositoryGljObj.getGljItems(gljLibId, function () {
  69. gljClassTreeObj.getGljClassTree(gljLibId);
  70. })
  71. });
  72. });
  73. }
  74. };
  75. let repositoryGljObj = {
  76. colMapping: null,
  77. treeObj : null,
  78. workBook: null,
  79. gljCurTypeId: -1,
  80. currentRepositoryId: -1,
  81. currentCache: null,
  82. parentNodeIds: {},
  83. gljList: [],
  84. materialType: {textArr: ['钢材', '钢筋', '木材', '水泥', '商品砼','商品砂浆'], comboItems: [{text: '钢材', value: 1}, {text: '钢筋', value: 2},{text: '木材', value: 3},//三材类型:钢材1、钢筋2、木材3、水泥4、商品砼5、商品砂浆6
  85. {text: '水泥', value: 4}, {text: '商品砼', value: 5},{text: '商品砂浆', value: 6}]},
  86. materialTypeIdx: {'1': '钢材', '2': '钢筋', '3': '木材', '4': '水泥', '5': '商品砼', '6': '商品砂浆'},
  87. machineModel: {textArr: ['特', '大', '中', '小'], comboItems: [{text: '特', value: 1}, {text: '大', value: 2},{text: '中', value: 3}, {text: '小', value: 4}]},
  88. machineModelIdx: {'1': '特', '2': '大', '3': '中', '4': '小'},
  89. distTypeTree: null,//add
  90. setting: {
  91. owner: "glj",
  92. header:[
  93. {headerName:"编码",headerWidth:80,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  94. {headerName:"名称",headerWidth:160,dataCode:"name", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  95. {headerName:"规格型号",headerWidth:120,dataCode:"specs", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  96. {headerName:"单位",headerWidth:60,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"},
  97. {headerName:"定额价",headerWidth:80,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"},
  98. {headerName:"类型",headerWidth:90,dataCode:"gljType", dataType: "String", hAlign: "center", vAlign: "center"},
  99. {headerName:"调整系数",headerWidth:60,dataCode:"adjCoe", dataType: "Number", hAlign: "center", vAlign: "center"},
  100. {headerName:"三材类别",headerWidth:90,dataCode:"materialType", dataType: "String", hAlign: "center", vAlign: "center"},
  101. {headerName:"三材系数",headerWidth:60,dataCode:"materialCoe", dataType: "Number", hAlign: "center", vAlign: "center"},
  102. {headerName:"机型",headerWidth:60,dataCode:"model", dataType: "Number", hAlign: "center", vAlign: "center"},
  103. ],
  104. view:{
  105. comboBox:[
  106. {row:-1,col:3,rowCount:-1,colCount:1}
  107. ],
  108. lockedCells:[
  109. ]
  110. }
  111. },
  112. //根据费用定额的单价属性获取人材机的单价属性
  113. getPriceProperty: function (priceProperties) {
  114. let priceProperty = {};
  115. for(let priceProp of priceProperties){
  116. priceProperty[priceProp.price.dataCode] = 0;
  117. }
  118. return priceProperty;
  119. },
  120. //根据单价字段获取消耗量字段
  121. getConsumeAmtField: function (consumeAmtProperties, priceField) {
  122. if(!consumeAmtProperties || consumeAmtProperties.length === 0){
  123. return 'consumeAmt';
  124. }
  125. for(let consumeAmtProp of consumeAmtProperties){
  126. if(consumeAmtProp.consumeAmt.refPrice === priceField){
  127. return consumeAmtProp.consumeAmt.dataCode;
  128. }
  129. }
  130. return 'consumeAmt';
  131. },
  132. //初始单价相关的列(单价列、单价属性列)
  133. initPriceCols: function (priceProperties, colMapping) {
  134. let priceCols = [],
  135. pricePropertyCols = [];
  136. if(!priceProperties || priceProperties.length === 0){
  137. priceCols.push(colMapping.fieldToCol['basePrice']);
  138. }
  139. for(let priceProp of priceProperties){
  140. pricePropertyCols.push(colMapping.fieldToCol[priceProp.price.dataCode]);
  141. priceCols.push(colMapping.fieldToCol[priceProp.price.dataCode]);
  142. }
  143. this.priceCols = priceCols;
  144. this.pricePropertyCols = pricePropertyCols;
  145. },
  146. getPriceFields: function () {
  147. let rst = [];
  148. for(let priceCol of this.priceCols){
  149. rst.push(this.colMapping.colToField[priceCol]);
  150. }
  151. return rst;
  152. },
  153. //获取更新定额价的人材机价格(人材机只有一个单价取basePrice, 人材机有多个单价,取第一个单价)
  154. getRationGljPrice: function (glj) {
  155. if(glj.priceProperty){
  156. let keys = Object.keys(glj.priceProperty);
  157. if(keys.length > 0){
  158. return glj.priceProperty[keys[0]];
  159. }
  160. }
  161. return glj.basePrice;
  162. },
  163. //生成列头(多单价)
  164. initHeaders: function (priceProperties) {
  165. let headers = [
  166. {headerName:"编码",headerWidth:80,dataCode:"code", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  167. {headerName:"名称",headerWidth:160,dataCode:"name", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  168. {headerName:"规格型号",headerWidth:120,dataCode:"specs", dataType: "String", formatter: "@", hAlign: "left", vAlign: "center"},
  169. {headerName:"单位",headerWidth:60,dataCode:"unit", dataType: "String", hAlign: "center", vAlign: "center"},
  170. {headerName:"类型",headerWidth:90,dataCode:"gljType", dataType: "String", hAlign: "center", vAlign: "center"},
  171. ];
  172. //生成单价列
  173. if(!priceProperties || priceProperties.length === 0){
  174. headers.push({headerName:"定额价",headerWidth:80,dataCode:"basePrice", dataType: "Number", formatter: "0.00", hAlign: "right", vAlign: "center"});
  175. }
  176. else {
  177. for(let priceProp of priceProperties){
  178. let colData = {
  179. headerName: priceProp.price.dataName,
  180. headerWidth: 100,
  181. dataCode: priceProp.price.dataCode,
  182. dataType: 'Number',
  183. formatter: '0.00',
  184. hAlign: 'right',
  185. vAlign: 'center'
  186. };
  187. headers.push(colData);
  188. }
  189. }
  190. let tailHeaders = [
  191. {headerName:"调整系数",headerWidth:60,dataCode:"adjCoe", dataType: "Number", hAlign: "center", vAlign: "center"},
  192. {headerName:"三材类别",headerWidth:90,dataCode:"materialType", dataType: "String", hAlign: "center", vAlign: "center"},
  193. {headerName:"三材系数",headerWidth:60,dataCode:"materialCoe", dataType: "Number", hAlign: "center", vAlign: "center"},
  194. {headerName:"机型",headerWidth:60,dataCode:"model", dataType: "Number", hAlign: "center", vAlign: "center"}
  195. ];
  196. headers = headers.concat(tailHeaders);
  197. return headers;
  198. },
  199. //工料机单价赋初始值(没有单价属性,则单价字段为basePrice,否则单价字段为单价属性对象中的属性)
  200. initPrice: function (glj) {
  201. if(!priceProperties || priceProperties.length === 0){
  202. glj.basePrice = glj.basePrice && !isNaN(parseFloat(glj.basePrice)) ? scMathUtil.roundTo(parseFloat(glj.basePrice), -2) : 0;
  203. }
  204. else {
  205. if(!glj.priceProperty){
  206. glj.priceProperty = {};
  207. }
  208. for(let priceProp of priceProperties){
  209. let gljPrice = glj['priceProperty'][priceProp.price.dataCode];
  210. gljPrice = gljPrice && !isNaN(parseFloat(gljPrice)) ? scMathUtil.roundTo(parseFloat(gljPrice), -2) : 0;
  211. }
  212. }
  213. },
  214. //人材机单价是否变化
  215. isGljPriceChange: function (glj, newPrice) {
  216. //多单价,与人材机单价属性比较
  217. if(typeof newPrice === 'object'){
  218. return !_.isEqual(glj.priceProperty, newPrice);
  219. }
  220. return !_.isEqual(glj.basePrice, newPrice);
  221. },
  222. //粘贴数据含有单价
  223. pasteIncludesPrice: function (pasteObj) {
  224. let me = repositoryGljObj;
  225. for(let priceCol of me.priceCols){
  226. let priceField = me.colMapping.colToField[priceCol];
  227. if(typeof pasteObj[priceField] !== 'undefined'){
  228. return true;
  229. }
  230. }
  231. return false;
  232. },
  233. //获取人材机价格
  234. getPrice: function (glj, col) {
  235. let me = repositoryGljObj;
  236. if(!priceProperties || priceProperties.length === 0){
  237. return glj.basePrice;
  238. }
  239. return glj.priceProperty[me.colMapping.colToField[col]];
  240. },
  241. //工料机价格是否相同
  242. priceIsEqual: function (gljA, gljB) {
  243. if(!priceProperties || priceProperties.length === 0){
  244. return gljA.basePrice == gljB.basePrice;
  245. }
  246. return _.isEqual(gljA.priceProperty, gljB.priceProperty);
  247. },
  248. setGljPrice: function (glj, newPrice, col) {
  249. if(!priceProperties || priceProperties.length === 0){
  250. glj.basePrice = newPrice;
  251. }
  252. else {
  253. glj.priceProperty[this.colMapping.colToField[col]] = newPrice;
  254. }
  255. },
  256. setUnitCombo: function (sheet, headers) {
  257. let me = this;
  258. sheet.suspendPaint();
  259. sheet.suspendEvent();
  260. let combo = sheetCommonObj.getDynamicCombo();
  261. combo.items(rationAndGljUnits).itemHeight(10).editable(true);
  262. let unitCol = me.colMapping.fieldToCol['unit'];
  263. if(unitCol){
  264. sheet.getRange(-1, unitCol, -1, 1).cellType(combo);
  265. }
  266. sheet.resumePaint();
  267. sheet.resumeEvent();
  268. },
  269. getComboData: function (gljDistType) {
  270. let me = this;
  271. let distType;
  272. let distTypeTree = {
  273. prefix : 'gljType',
  274. distTypes: {},
  275. comboDatas: [],
  276. distTypesArr: []
  277. };
  278. gljDistType.forEach(function (typeData) {
  279. let typeObj = {
  280. data: typeData,
  281. children: [],
  282. parent: null
  283. };
  284. distTypeTree.distTypes[distTypeTree.prefix + typeData.ID] = typeObj;
  285. distTypeTree.distTypesArr.push(typeObj);
  286. });
  287. gljDistType.forEach(function (typeData) {
  288. distType = distTypeTree.distTypes[distTypeTree.prefix + typeData.ID];
  289. let parent = distTypeTree.distTypes[distTypeTree.prefix + typeData.ParentID];
  290. if(parent){
  291. distType.parent = parent;
  292. parent.children.push(distType);
  293. }
  294. });
  295. distTypeTree.distTypesArr.forEach(function (distTypeObj) {
  296. if(allowGljType.includes(distTypeObj.data.ID)){
  297. distTypeTree.comboDatas.push({text: distTypeObj.data.fullName, value: distTypeObj.data.ID});
  298. }
  299. });
  300. return distTypeTree;
  301. },
  302. getGljDistType: function (callback) {
  303. let me = this;
  304. $.ajax({
  305. type: 'post',
  306. url: "api/getGljDistType",
  307. dataType: 'json',
  308. success: function (result) {
  309. if(!result.error && callback){
  310. me.distTypeTree = me.getComboData(result.data);
  311. console.log(me.distTypeTree);
  312. callback();
  313. }
  314. }
  315. })
  316. },
  317. getGljLib: function (libId, callback) {
  318. let me = repositoryGljObj;
  319. $.ajax({
  320. type: 'post',
  321. url: 'api/getGljLib',
  322. data: {libId: libId},
  323. dataType: 'json',
  324. success: function (result) {
  325. if(!result.error){
  326. if(result.data.length > 0){
  327. me.rationLibs = result.data[0].rationLibs;
  328. $(".navbar-text").append(
  329. "<a href='/stdGljRepository/main'>人材机库</a><i class='fa fa-angle-right fa-fw'></i>"+result.data[0].dispName
  330. );
  331. pageOprObj.gljLibName = result.data[0].dispName;
  332. }
  333. callback();
  334. }
  335. }
  336. })
  337. },
  338. getGljTree: function(gljLibId, callback) {
  339. let me = this;
  340. $.ajax({
  341. type:"POST",
  342. url:"api/getGljTree",
  343. data:{"gljLibId": gljLibId},
  344. dataType:"json",
  345. cache:false,
  346. timeout:20000,
  347. success:function(result,textStatus,status){
  348. if(status.status == 200) {
  349. zTreeHelper.createTree(result.data, gljSetting, "repositoryTree", me);
  350. zTreeHelper.createTree(result.data, componentSetting, "componentTree", componentOprObj);
  351. if (result.data && result.data.length > 0) {
  352. me.gljCurTypeId = result.data[0].ID;
  353. } else {
  354. //重新创建库?
  355. gljTypeTreeOprObj.addRootNode();
  356. }
  357. callback();
  358. }
  359. },
  360. error:function(err){
  361. alert(err.responseJSON.error);
  362. }
  363. })
  364. },
  365. getGljItems: function(repId, callback) {
  366. let me = this;
  367. $.ajax({
  368. type:"POST",
  369. url:"api/getGljItems",
  370. data:{"repositoryId": repId},
  371. dataType:"json",
  372. cache:false,
  373. timeout:240000,
  374. success:function(result){
  375. if(!result.error) {
  376. me.gljList = result.data;
  377. me.workBook.getSheet(0).setRowCount(result.data.length);
  378. me.sortGlj();
  379. me.currentGlj = me.gljList.length > 0 ? me.gljList[0] : null;//初始
  380. if(callback){
  381. callback();
  382. }
  383. }
  384. },
  385. error:function(err){
  386. alert(err);
  387. }
  388. })
  389. },
  390. showGljItems: function(data, type) {
  391. let me = repositoryGljObj;
  392. if (me.workBook) {
  393. let cacheSection = data;
  394. me.sortGljDeep(cacheSection);
  395. sheetCommonObj.cleanData(me.workBook.getSheet(0), me.setting, -1);
  396. sheetsOprObj.showData(me, me.workBook.getSheet(0), me.setting, cacheSection, me.distTypeTree, me.materialTypeIdx, me.machineModelIdx);
  397. let gljTypeCol = me.colMapping.fieldToCol['gljType'],
  398. materialTypeCol = me.colMapping.fieldToCol['materialType'],
  399. modelCol = me.colMapping.fieldToCol['model'];
  400. sheetCommonObj.setDynamicCombo(me.workBook.getActiveSheet(), 0, gljTypeCol, me.workBook.getActiveSheet().getRowCount(), me.distTypeTree.comboDatas, 10, 'text');
  401. sheetCommonObj.setDynamicCombo(me.workBook.getActiveSheet(), 0, materialTypeCol, me.workBook.getActiveSheet().getRowCount(), me.materialType.comboItems, false, 'text');
  402. sheetCommonObj.setDynamicCombo(me.workBook.getActiveSheet(), 0, modelCol, me.workBook.getActiveSheet().getRowCount(), me.machineModel.comboItems, false, 'text');
  403. cacheSection = null;
  404. let selRow = me.workBook.getActiveSheet().getSelections()[0].row;
  405. me.initSel(selRow);
  406. }
  407. },
  408. bindEnterKey: function () {
  409. let me = this;
  410. let sheet = me.workBook.getActiveSheet();
  411. me.workBook.commandManager().register("myEnter", function(){
  412. let orgRow = sheet.getActiveRowIndex();
  413. let orgCol = sheet.getActiveColumnIndex();
  414. if(sheet.isEditing()){
  415. sheet.endEdit();
  416. }
  417. let codeCol = me.colMapping.fieldToCol['code'];
  418. let code = sheet.getValue(orgRow, codeCol);
  419. let newRow, newCol;
  420. if(!me.currentCache[orgRow] && code !== undefined && code !== null && orgCol !== me.setting.header.length - 1){
  421. newRow = orgRow;
  422. newCol = orgCol + 1;
  423. sheet.setActiveCell(newRow, newCol);
  424. }
  425. else{
  426. newRow = orgRow + 1;
  427. newCol = me.currentCache[orgRow + 1] ? orgCol : 0;
  428. sheet.setActiveCell(newRow, newCol);
  429. }
  430. //触发事件
  431. me.onLeaveCell({type: 'LeaveCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: orgRow, col: orgCol});
  432. me.onEnterCell({type: 'EnterCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: newRow, col: newCol});
  433. let newSels = [{row: newRow, rowCount: 1, col: newCol, colCount: 1}];
  434. let oldSels = [{row: orgRow, rowCount: 1, col: orgRow, colCount: 1}];
  435. me.onSelectionChanged({type: 'SelectionChanged'}, {sheet: sheet, sheetName: sheet.name(), newSelections: newSels, oldSelections: oldSels});
  436. });
  437. me.workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.enter, false, false, false, false);
  438. me.workBook.commandManager().setShortcutKey("myEnter", GC.Spread.Commands.Key.enter, false, false, false, false);
  439. },
  440. buildSheet: function(container) {
  441. let me = repositoryGljObj;
  442. me.workBook = sheetCommonObj.buildSheet(container, me.setting, 30, me);
  443. sheetCommonObj.bindEscKey(me.workBook, [{sheet: me.workBook.getSheet(0), editStarting: me.onCellEditStart, editEnded: me.onCellEditEnd}]);
  444. me.bindEnterKey();
  445. me.repositoryGljDelOpr();
  446. me.onContextmenuOpr();
  447. me.setUnitCombo(me.workBook.getActiveSheet(), me.setting.header);
  448. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasting, me.onClipboardPasting);
  449. me.workBook.bind(GC.Spread.Sheets.Events.ClipboardPasted, me.onClipboardPasted);
  450. if(priceProperties && priceProperties.length > 0){
  451. me.workBook.getSheet(0).frozenColumnCount(5);
  452. }
  453. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditStarting, me.onCellEditStart);
  454. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EditEnded, me.onCellEditEnd);
  455. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.EnterCell, me.onEnterCell);
  456. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.LeaveCell, me.onLeaveCell);
  457. me.workBook.getSheet(0).bind(GC.Spread.Sheets.Events.SelectionChanged, me.onSelectionChanged);
  458. },
  459. isDef: function (v) {
  460. return v !== undefined && v !== null;
  461. },
  462. //成为了组成物,暂时只需要判断主材的
  463. isComponent: function (gljId, gljList) {
  464. for(let i = 0, len = gljList.length; i < len; i++){
  465. let gljComponent = gljList[i].component;
  466. if(gljList[i].gljType === 4 && this.isDef(gljComponent) && gljComponent.length > 0){
  467. for(let j = 0, jLen = gljComponent.length; j < jLen; j++){
  468. if(gljComponent[j].ID === gljId){
  469. return true;
  470. }
  471. }
  472. }
  473. }
  474. return false;
  475. },
  476. getCurrentComponent: function (gljComponent, sort = false) {
  477. let me = repositoryGljObj,
  478. rst = [],
  479. IDCodeMapping = {};
  480. for(let i = 0; i < gljComponent.length; i++){
  481. let obj = {};
  482. for(let j = 0; j < me.gljList.length; j++){
  483. let specs = me.gljList[j].specs ? ' ' + me.gljList[j].specs : '';
  484. if(gljComponent[i].ID == me.gljList[j].ID){
  485. obj.ID = me.gljList[j].ID;
  486. obj.code = me.gljList[j].code;
  487. obj.name = me.gljList[j].name + specs;
  488. obj.unit = me.gljList[j].unit;
  489. obj.basePrice = me.gljList[j].basePrice;
  490. obj.priceProperty = me.gljList[j].priceProperty ? me.gljList[j].priceProperty : {};
  491. obj.consumeAmt = gljComponent[i].consumeAmt;
  492. obj.consumeAmtProperty = gljComponent[i].consumeAmtProperty ? gljComponent[i].consumeAmtProperty : {};
  493. rst.push(obj);
  494. IDCodeMapping[obj.ID] = obj.code;
  495. }
  496. }
  497. }
  498. if(sort){
  499. rst.sort(function (a, b) {
  500. let r = 0;
  501. if(a.code > b.code) r = 1;
  502. else if(a.code < b.code) r = -1;
  503. return r;
  504. });
  505. gljComponent.sort(function (a, b) {
  506. let aV = IDCodeMapping[a.ID],
  507. bV = IDCodeMapping[b.ID];
  508. if (aV > bV) {
  509. return 1;
  510. } else if (aV < bV) {
  511. return -1;
  512. }
  513. return 0;
  514. });
  515. }
  516. return rst;
  517. },
  518. //获得引用了组成物id为componentId的工料机,和重新变化组成物数组、重新计算单价
  519. getUpdateGljs: function (rObj, isDelete) {
  520. let me = repositoryGljObj, that = gljComponentOprObj,
  521. rst = {updateArr: [], updateBasePrcArr: []};
  522. //改变单价,以便reCalGljBasePrc方法可行
  523. if(!isDelete){
  524. for(let i = 0; i < me.gljList.length; i++){
  525. if(me.gljList[i].ID === rObj.ID){
  526. me.gljList[i].basePrice = rObj.basePrice;
  527. me.gljList[i].priceProperty = rObj.priceProperty ? rObj.priceProperty : {};
  528. break;
  529. }
  530. }
  531. }
  532. for(let i = 0; i < me.gljList.length; i++){
  533. let thisComponent = me.gljList[i].component, isChange = false;
  534. for(let j = 0; j < thisComponent.length; j++){
  535. if(thisComponent[j].ID === rObj.ID){
  536. //删除
  537. isChange = true;
  538. if(isDelete){
  539. thisComponent.splice(j--, 1);
  540. }
  541. else {
  542. break;
  543. }
  544. }
  545. }
  546. if(isChange){//引用了此组成物
  547. rst.updateArr.push(me.gljList[i]);
  548. }
  549. }
  550. return rst;
  551. },
  552. reshowGljBasePrc: function (glj) {
  553. let me = repositoryGljObj;
  554. let cacheSection = me.currentCache;
  555. let sheet = me.workBook.getActiveSheet();
  556. let row = _.findIndex(cacheSection, {ID: glj.ID});
  557. sheet.suspendEvent();
  558. sheet.suspendPaint();
  559. for(let priceCol of me.priceCols){
  560. sheet.setValue(row, priceCol, glj[me.colMapping.colToField[priceCol]]);
  561. }
  562. sheet.resumeEvent();
  563. sheet.resumePaint();
  564. },
  565. reSetGljBasePrc: function (gljs) {
  566. let me = repositoryGljObj;
  567. let cacheSection = me.currentCache;
  568. let sheet = me.workBook.getSheet(0);
  569. let basePriceCol = me.colMapping.fieldToCol['basePrice'];
  570. sheet.suspendPaint();
  571. sheet.suspendEvent();
  572. for(let i = 0; i < cacheSection.length; i++){
  573. for(let glj of gljs){
  574. if(glj.ID === cacheSection[i].ID){
  575. for(let priceCol of me.priceCols){
  576. sheet.setValue(i, priceCol, glj[me.colMapping.colToField[priceCol]]);
  577. }
  578. //sheet.setValue(i, basePriceCol, glj.basePrice);
  579. }
  580. }
  581. }
  582. sheet.resumePaint();
  583. sheet.resumeEvent();
  584. },
  585. initSel: function (row) {
  586. let me = repositoryGljObj, that = gljComponentOprObj;
  587. sheetCommonObj.cleanData(that.workBook.getSheet(0), that.setting, -1);
  588. //sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, -1);
  589. me.workBook.focus(true);
  590. me.currentComponent = [];
  591. that.workBook.getSheet(0).setRowCount(10);
  592. if(row < me.currentCache.length){
  593. //标记当前工料机
  594. me.currentGlj = me.currentCache[row];
  595. if(allowComponent.includes(me.currentCache[row].gljType)){
  596. //展示数据
  597. if(me.currentGlj.component.length > 0){
  598. me.currentComponent = me.getCurrentComponent(me.currentGlj.component, true);
  599. if(me.currentComponent.length > 0){
  600. sheetsOprObj.showData(that, that.workBook.getSheet(0), that.setting, me.currentComponent);
  601. }
  602. }
  603. }
  604. }
  605. else{
  606. me.currentGlj = null;
  607. }
  608. },
  609. onSelectionChanged: function (sender, info) {
  610. let me = repositoryGljObj, that = gljComponentOprObj;
  611. //混凝土202、砂浆203、配合比204、机械3
  612. if(info.oldSelections.length === 0 && info.newSelections.length > 0 || info.oldSelections[0].row !== info.newSelections[0].row){
  613. let row = info.newSelections[0].row;
  614. me.initSel(row);
  615. }
  616. },
  617. onLeaveCell: function (sender, args) {
  618. let me = repositoryGljObj;
  619. me.lastCell = {row: args.row, col: args.col};
  620. },
  621. onEnterCell: function (sender, args) {
  622. let me = repositoryGljObj;
  623. let thisDataCode = me.setting.header[args.col].dataCode,
  624. lastDataCode = me.setting.header[me.lastCell.col].dataCode;
  625. if(thisDataCode === 'unit'|| lastDataCode === 'unit' || thisDataCode === 'gljType' || lastDataCode === 'gljType'
  626. || thisDataCode === 'materialType' || lastDataCode === 'materialType' || thisDataCode === 'model' || lastDataCode === 'model'){
  627. let rects = [];
  628. rects.push(args.sheet.getCellRect(args.row, args.col));
  629. if(me.lastCell){
  630. rects.push(args.sheet.getCellRect(me.lastCell.row, me.lastCell.col));
  631. }
  632. for(let rect of rects){
  633. args.sheet.repaint(rect);
  634. }
  635. //args.sheet.repaint();
  636. }
  637. me.cellRowIdx = args.row;
  638. let isHasData = false;
  639. if(me.addGljObj){
  640. for(let i=0; i<me.setting.header.length; i++){
  641. if(me.addGljObj[me.setting.header[i].dataCode]){
  642. isHasData = true;
  643. break;
  644. }
  645. }
  646. }
  647. if(isHasData){
  648. if(me.editingRowIdx !== me.cellRowIdx) {
  649. let focusToCol;
  650. function getFocusToCol (me){
  651. if(!me.addGljObj.code){
  652. $('#alertGljTxt').text('编号不能为空,继续增加人材机?');
  653. return me.colMapping.fieldToCol['code'];
  654. }
  655. else if(!me.addGljObj.name){
  656. $('#alertGljTxt').text('名称不能为空,继续增加人材机?');
  657. return me.colMapping.fieldToCol['name'];
  658. }
  659. else if(!me.addGljObj.gljType){
  660. $('#alertGljTxt').text('类型不能为空,继续增加人材机?');
  661. return me.colMapping.fieldToCol['gljType'];
  662. }
  663. else {
  664. return -1;
  665. }
  666. }
  667. focusToCol = getFocusToCol(me);
  668. if(focusToCol !== -1) {
  669. $('#gljAlertBtn').click();
  670. $('#aleConfBtn').unbind('click');
  671. $('#aleConfBtn').bind('click', function () {
  672. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  673. me.workBook.focus(true);
  674. });
  675. $('#gljAleClose').click(function () {
  676. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, focusToCol);
  677. me.workBook.focus(true);
  678. });
  679. $('#aleCanceBtn').unbind('click');
  680. $('#aleCanceBtn').bind('click', function () {
  681. me.addGljObj = null;
  682. args.sheet.suspendEvent();
  683. args.sheet.suspendPaint();
  684. for(let col=0; col<me.setting.header.length; col++){
  685. if(col === 0){
  686. me.workBook.getSheet(0).getCell(me.editingRowIdx, 0).formatter("@");
  687. }
  688. me.workBook.getSheet(0).getCell(me.editingRowIdx, col).value('');
  689. }
  690. me.workBook.getSheet(0).setActiveCell(me.editingRowIdx, 0);
  691. me.workBook.focus(true);
  692. args.sheet.resumeEvent();
  693. args.sheet.resumePaint();
  694. });
  695. }
  696. }
  697. }
  698. },
  699. onCellEditStart: function(sender, args) {
  700. let me = repositoryGljObj;
  701. me.orgCode = me.workBook.getSheet(0).getValue(args.row, me.colMapping.fieldToCol['code']);
  702. let rObj = sheetsOprObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row, me);
  703. if(me.prevent){
  704. args.cancel = true;
  705. return;
  706. }
  707. me.currentEditingGlj = rObj;
  708. if(args.row < me.currentCache.length){
  709. let dataCode = me.setting.header[args.col].dataCode;
  710. me.currentGlj = me.currentCache[args.row];
  711. if(dataCode === 'code'
  712. || (dataCode === 'adjCoe' && me.currentGlj.gljType !== 1 && me.currentGlj.gljType !== 303)
  713. || (dataCode === 'materialCoe' && !me.currentGlj.materialType)
  714. || (dataCode === 'model' && me.currentGlj.gljType !== 301)){
  715. args.cancel = true;
  716. }
  717. else {
  718. rObj.ID = me.currentGlj.ID;
  719. rObj.gljClass = me.currentGlj.gljClass;
  720. }
  721. }
  722. else {
  723. me.currentGlj = null;
  724. }
  725. },
  726. dataChanged: function (objA, objB, col) {
  727. let me = repositoryGljObj;
  728. if(me.priceCols.includes(col)){
  729. if(!priceProperties || priceProperties.length === 0){
  730. return objA.basePrice !== objB.basePrice;
  731. }
  732. else {
  733. return objA.priceProperty[me.colMapping.colToField[col]] !== objB.priceProperty[me.colMapping.colToField[col]]
  734. }
  735. }
  736. return objA[me.colMapping.colToField[col]] !== objB[[me.colMapping.colToField[col]]];
  737. },
  738. onCellEditEnd: function(sender, args) {
  739. debugger;
  740. let me = repositoryGljObj, that = gljComponentOprObj,
  741. updateArr = [], addArr = [], updateBasePrcArr = [];
  742. let deESCFields = ['code', 'name', 'specs'];//消除转义字符
  743. if(deESCFields.includes(me.setting.header[args.col]['dataCode'])){
  744. args.editingText = me.isDef(args.editingText) ? args.editingText.toString().replace(/[\r, \n]/g, '') : '';
  745. args.sheet.setValue(args.row, args.col, args.editingText);
  746. }
  747. let rObj = sheetsOprObj.combineRowData(me.workBook.getSheet(0), me.setting, args.row, me);
  748. me.editingRowIdx = args.row;
  749. //rObj.basePrice = rObj.basePrice ? rObj.basePrice : 0;
  750. me.initPrice(rObj);
  751. //更新
  752. if (me.currentEditingGlj["ID"] && me.currentGlj) {
  753. rObj["ID"] = me.currentEditingGlj["ID"];
  754. rObj.gljClass = me.currentEditingGlj.gljClass;
  755. if(me.dataChanged(me.currentEditingGlj, rObj, args.col)){
  756. if(rObj.code && rObj.name && rObj.gljType &&
  757. rObj.code.toString().trim().length !== 0 && rObj.name.toString().trim().length !== 0 && rObj.gljType.toString().trim().length !== 0){
  758. if(rObj.gljType !== me.currentEditingGlj.gljType){//修改了工料机类型
  759. if(!$('#typeAlert').is(':visible')){
  760. $('#typeAlert').modal('show');
  761. }
  762. $('#typeConfirm').unbind('click');
  763. $('#typeConfirm').bind('click', function () {
  764. $('#typeAlert').modal('hide');
  765. if(me.currentGlj){
  766. me.currentGlj.component = [];
  767. }
  768. /*if(me.allowComponent.indexOf(rObj.gljType) !== -1){//更改成可添加组成物的类型,则将定额价设成零
  769. rObj.basePrice = 0;
  770. }*/
  771. //调整系数,工料机类型为人工和机上人工时,可输入整数
  772. if((me.currentEditingGlj.gljType === 1 || me.currentEditingGlj.gljType === 303) && !(rObj.gljType === 1 || rObj.gljType === 303)){
  773. rObj.adjCoe = null;
  774. }
  775. //工料机类型不为机械台班时,清空机型
  776. if(me.currentEditingGlj.gljType === 301 && rObj.gljType !== 301 && me.currentEditingGlj.model){
  777. rObj.model = null;
  778. }
  779. if(componentType.includes(me.currentEditingGlj.gljType)&&
  780. !(machineComponent.includes(me.currentEditingGlj.gljType) && machineComponent.includes(rObj.gljType)) &&
  781. !(materialComponent.includes(me.currentEditingGlj.gljType) && materialComponent.includes(rObj.gljType))){//修改了原本是组成物的工料机
  782. //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价
  783. let updateGljs = me.getUpdateGljs(rObj, true);
  784. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  785. for(let i = 0; i < updateGljs.updateArr.length; i++){
  786. updateArr.push(updateGljs.updateArr[i]);
  787. }
  788. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  789. updateArr.push(updateGljs.updateBasePrcArr[i]);
  790. }
  791. }
  792. }
  793. sheetCommonObj.cleanData(that.workBook.getSheet(0), that.setting, 5);
  794. rObj.component = me.currentGlj.component;
  795. updateArr.push(rObj);
  796. me.mixUpdateRequest(updateArr, [], []);
  797. });
  798. $('.typeClose').unbind('click');
  799. $('.typeClose').bind('click', function () {
  800. args.sheet.setValue(args.row, args.col, _.find(me.distTypeTree.comboDatas, {value: me.currentGlj.gljType}).text);
  801. });
  802. return;
  803. }
  804. else if(rObj.adjCoe !== me.currentEditingGlj.adjCoe){//修改调整系数,整数控制
  805. if(isNaN(rObj.adjCoe) || rObj.adjCoe % 1 !== 0){
  806. args.sheet.setValue(args.row, args.col, me.currentEditingGlj.adjCoe ? me.currentEditingGlj.adjCoe : '');
  807. alert('调整系数只能输入整数!');
  808. return;
  809. }
  810. }
  811. else if(rObj.materialCoe !== me.currentEditingGlj.materialCoe){
  812. if(isNaN(rObj.materialCoe)){
  813. args.sheet.setValue(args.row, args.col, me.currentEditingGlj.materialCoe ? me.currentEditingGlj.materialCoe : '');
  814. alert('三材系数只能输入数值!');
  815. return;
  816. }
  817. rObj.materialCoe = scMathUtil.roundTo(parseFloat(rObj.materialCoe), -5);
  818. }
  819. else if(!me.priceIsEqual(rObj, me.currentEditingGlj)){//修改了单价,可修改单价的必为可成为组成物的
  820. let rObjPrice = me.getPrice(rObj, args.col),
  821. editingGljPrice = me.getPrice(me.currentEditingGlj, args.col);
  822. //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价
  823. if(isNaN(parseFloat(rObjPrice))){
  824. alert('单价只能输入数值!');
  825. args.sheet.setValue(args.row, args.col, editingGljPrice ? editingGljPrice : 0);
  826. return;
  827. }
  828. me.setGljPrice(rObj, scMathUtil.roundTo(parseFloat(rObjPrice), -2), args.col);
  829. let updateGljs = me.getUpdateGljs(rObj);
  830. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  831. for(let i = 0; i < updateGljs.updateArr.length; i++){
  832. updateArr.push(updateGljs.updateArr[i]);
  833. }
  834. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  835. updateArr.push(updateGljs.updateBasePrcArr[i]);
  836. }
  837. }
  838. }
  839. rObj.component = me.currentGlj.component;
  840. updateArr.push(rObj);
  841. }
  842. else{
  843. if(me.setting.header[args.col].dataCode === 'gljType'){
  844. let distTypeVal = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj[me.setting.header[args.col].dataCode]].data.fullName;
  845. args.sheet.setValue(args.row, args.col, distTypeVal);
  846. }
  847. else{
  848. args.sheet.setValue(args.row, args.col, me.currentEditingGlj[me.setting.header[args.col].dataCode]);
  849. }
  850. }
  851. }
  852. if(!me.priceIsEqual(rObj, me.currentEditingGlj)){
  853. //update basePrice of ration when editting basePrice of glj
  854. let gljType = -1;
  855. let gljTypeParent = me.distTypeTree.distTypes[me.distTypeTree.prefix + me.currentEditingGlj.gljType].parent;
  856. if(gljTypeParent && gljTypeParent.data.ID <=3){
  857. gljType = gljTypeParent.data.ID;
  858. }
  859. if(!gljTypeParent && me.currentEditingGlj.gljType <= 3){
  860. gljType = me.currentEditingGlj.gljType;
  861. }
  862. let gljBasePrcObj = {gljId: me.currentEditingGlj.ID, gljType: gljType, basePrice: me.getRationGljPrice(rObj)};
  863. if(gljBasePrcObj.gljType !== -1){
  864. updateBasePrcArr.push(gljBasePrcObj);
  865. if(me.rationLibs.length > 0){//重算定额单价
  866. me.updateRationBasePrcRq(updateBasePrcArr);
  867. }
  868. }
  869. }
  870. }
  871. //新增
  872. else {
  873. if(typeof rObj.code !== 'undefined'){
  874. me.addGljObj = rObj;
  875. let isCanSav = true;
  876. if(!rObj.code || !rObj.name || !rObj.gljType){
  877. isCanSav = false;
  878. }
  879. if(isCanSav){
  880. me.addGljObj = null;
  881. rObj.component = [];
  882. //rObj.basePrice = !isNaN(parseFloat(rObj.basePrice)) && (rObj.basePrice && typeof rObj.basePrice !== 'undefined') ? scMathUtil.roundTo(parseFloat(rObj.basePrice), -2) : 0;
  883. me.initPrice(rObj);
  884. addArr.push(rObj);
  885. }
  886. }
  887. }
  888. if(!me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]){
  889. rObj.gljClass = me.gljCurTypeId;
  890. }
  891. if(updateArr.length >0 || addArr.length >0){
  892. me.currentEditingGlj = null;
  893. me.mixUpdateRequest(updateArr, addArr, []);
  894. }
  895. },
  896. delGljs: function (sels) {
  897. let me = repositoryGljObj;
  898. let sheet = me.workBook.getSheet(0),
  899. updateArr = [], removeArr = [],
  900. removeIDs = [],
  901. removeNames = [],
  902. updateBasePrcArr = [],//删除基价单位后重新计算
  903. canUpdate = false,
  904. cacheSection = me.currentCache,
  905. updateBackups = [];
  906. if(sels.length > 0 && cacheSection.length > 0){
  907. for(let i = 0; i < sels.length; i++){
  908. if(sels[i].colCount === me.setting.header.length){
  909. for(let j = 0; j < sels[i].rowCount; j++){
  910. if(sels[i].row + j < cacheSection.length){
  911. removeArr.push(cacheSection[sels[i].row + j]);
  912. removeIDs.push(cacheSection[sels[i].row + j].ID);
  913. removeNames.push(cacheSection[sels[i].row + j].name);
  914. //删除后重新计算引用了此工料机的定额单价
  915. updateBasePrcArr.push({gljId: cacheSection[sels[i].row + j].ID, gljType: cacheSection[sels[i].row + j].gljType, basePrice: 0, delete: 1});
  916. }
  917. }
  918. }
  919. else{
  920. let maxCol = sels[i].col + sels[i].colCount - 1;
  921. let cantNullDataCode = ['code', 'name', 'gljType'];
  922. for(let j = 0; j < sels[i].rowCount; j++){
  923. if(sels[i].row + j < cacheSection.length){
  924. let updateObj = cacheSection[sels[i].row + j];
  925. for(let col = sels[i].col; col <= maxCol; col++){
  926. let dataCode = me.setting.header[col].dataCode;
  927. if(cantNullDataCode.includes(dataCode)){
  928. $('#alertText').text(me.setting.header[col].headerName + "不可为空!");
  929. $('#codeAlert').modal('show');
  930. return false;
  931. }
  932. else {
  933. canUpdate = true;
  934. break;
  935. }
  936. }
  937. }
  938. }
  939. }
  940. }
  941. if(canUpdate){
  942. //删除警告
  943. let upAlertText = '确认删除选中字段?';
  944. $('#alertGljTxt').text(upAlertText);
  945. $('#gljAlert').modal('show');
  946. $('#aleConfBtn').unbind('click');
  947. //确认
  948. $('#aleConfBtn').bind('click', function () {
  949. for(let i = 0; i < sels.length; i++) {
  950. let maxCol = sels[i].col + sels[i].colCount - 1;
  951. for (let j = 0; j < sels[i].rowCount; j++) {
  952. if (sels[i].row + j < cacheSection.length) {
  953. let updateObj = cacheSection[sels[i].row + j];
  954. for (let col = sels[i].col; col <= maxCol; col++) {
  955. let dataCode = me.setting.header[col].dataCode;
  956. if (me.priceCols.includes(col)) {
  957. me.setGljPrice(updateObj, 0, col);
  958. updateBasePrcArr.push({
  959. gljId: updateObj.ID,
  960. gljType: updateObj.gljType,
  961. basePrice: 0
  962. });
  963. }
  964. else {
  965. if (dataCode === 'materialType') {
  966. updateObj['materialCoe'] = null;
  967. }
  968. updateObj[dataCode] = '';
  969. }
  970. }
  971. updateArr.push(updateObj);
  972. }
  973. }
  974. }
  975. me.mixUpdateRequest(updateArr, [], []);
  976. if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){
  977. me.updateRationBasePrcRq(updateBasePrcArr);
  978. }
  979. });
  980. }
  981. if(removeArr.length > 0){
  982. $.bootstrapLoading.start();
  983. CommonAjax.post('/stdGljRepository/api/isUsed', {gljIds: removeIDs}, function (rstData) {
  984. $.bootstrapLoading.end();
  985. //存在被引用的人材机(标准/补充定额库)
  986. if(rstData.isUsed){
  987. $('#gljAlert').find('.modal-body h5').text('已有定额引用了当前人材机,不可删除。');
  988. $('#gljAlert').modal('show');
  989. $('#aleConfBtn').unbind('click');
  990. $('#aleConfBtn').bind('click', function () {
  991. $('#gljAlert').modal('hide');
  992. me.workBook.focus(true)
  993. });
  994. }
  995. else {
  996. $('#gljAlert').find('.modal-body h5').text(`确定要删除人材机 “${removeNames.join(',')}” 吗? `);
  997. setTimeout(function () {
  998. $('#gljAlert').modal('show');
  999. }, 200);
  1000. //确认
  1001. $('#aleConfBtn').unbind('click');
  1002. $('#aleConfBtn').bind('click', function () {
  1003. for(let removeD of removeArr){
  1004. let updateGljs = me.getUpdateGljs(removeD, true);
  1005. if(updateGljs.updateArr.length > 0){
  1006. for(let i = 0; i < updateGljs.updateArr.length; i++){
  1007. updateArr.push(updateGljs.updateArr[i]);
  1008. }
  1009. }
  1010. }
  1011. me.mixUpdateRequest(updateArr, [], removeIDs);
  1012. /* if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){
  1013. me.updateRationBasePrcRq(updateBasePrcArr);
  1014. me.workBook.focus(true);
  1015. }*/
  1016. });
  1017. }
  1018. }, function () {
  1019. $.bootstrapLoading.end();
  1020. $('#gljAlert').find('.modal-body h5').text('查询引用错误,不可删除。');
  1021. $('#gljAlert').modal('show');
  1022. $('#aleConfBtn').unbind('click');
  1023. $('#aleConfBtn').bind('click', function () {
  1024. $('#gljAlert').modal('hide');
  1025. me.workBook.focus(true);
  1026. });
  1027. });
  1028. }
  1029. }
  1030. },
  1031. //删除人材机前需要判断人材机是否有被引用,被引用了则不可删除
  1032. repositoryGljDelOpr: function () {
  1033. let me = repositoryGljObj;
  1034. me.workBook.commandManager().register('repositoryGljDel', function () {
  1035. let sels = me.workBook.getActiveSheet().getSelections();
  1036. me.delGljs(sels);
  1037. });
  1038. me.workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.del, false, false, false, false);
  1039. me.workBook.commandManager().setShortcutKey('repositoryGljDel', GC.Spread.Commands.Key.del, false, false, false, false);
  1040. },
  1041. onContextmenuOpr: function () {
  1042. let me = repositoryGljObj;
  1043. $.contextMenu({
  1044. selector: '#GLJListSheet',
  1045. build: function($triggerElement, e){
  1046. //控制允许右键菜单在哪个位置出现
  1047. let sheet = me.workBook.getSheet(0);
  1048. let offset = $("#GLJListSheet").offset(),
  1049. x = e.pageX - offset.left,
  1050. y = e.pageY - offset.top;
  1051. let target = sheet.hitTest(x, y);
  1052. let sel = sheet.getSelections()[0];
  1053. if(sel.row === -1){
  1054. sel.row = 0;
  1055. }
  1056. if(sel.col === -1){
  1057. sel.col = 0;
  1058. }
  1059. if(target.hitTestType === 3 && typeof target.row !== 'undefined' && typeof target.col !== 'undefined'){//在表格内
  1060. me.initSel(target.row);
  1061. if(sel.row > target.row || sel.row + sel.rowCount - 1 < target.row ||
  1062. sel.col > target.col || sel.col + sel.colCount - 1 < target.col ){
  1063. sheet.setActiveCell(target.row, target.col);
  1064. }
  1065. return {
  1066. callback: function(){},
  1067. items: {
  1068. "delete": {
  1069. name: "删除",
  1070. disabled: function () {
  1071. return !(me.currentCache && me.currentCache[target.row]);
  1072. },
  1073. icon: "fa-remove",
  1074. callback: function (key, opt) {
  1075. let curSel = _.cloneDeep(sheet.getSelections()[0]);
  1076. curSel.colCount = me.setting.header.length;
  1077. me.delGljs([curSel]);
  1078. }}
  1079. }
  1080. };
  1081. }
  1082. else{
  1083. return false;
  1084. }
  1085. }
  1086. });
  1087. },
  1088. validUpdateObj: function (pasteObj, rowIdx) {
  1089. let rst = {updateGlj: [], updateBasePrcArr: []}, backUpObj = {},
  1090. me = repositoryGljObj,
  1091. that = gljComponentOprObj,
  1092. tempObj = me.currentCache[rowIdx],
  1093. reCalBasePrc = false,
  1094. isValid = true,
  1095. materialTypeValid = true;
  1096. //备份原始数据
  1097. for(let atr in tempObj){
  1098. backUpObj[atr] = tempObj[atr];
  1099. }
  1100. if(typeof pasteObj.code !== 'undefined'){
  1101. if(pasteObj.code.trim().length !== 0){
  1102. let isExist = false;
  1103. for(let i = 0; i < me.gljList.length; i++){
  1104. if(me.gljList[i].code === pasteObj.code){
  1105. isExist = true;
  1106. break;
  1107. }
  1108. }
  1109. if(!isExist){
  1110. tempObj.code = pasteObj.code;
  1111. }
  1112. else isValid = false;
  1113. }
  1114. else isValid = false;
  1115. }
  1116. if(typeof pasteObj.name !== 'undefined'){
  1117. if(pasteObj.name.trim().length === 0) isValid = false;
  1118. else tempObj.name = pasteObj.name;
  1119. }
  1120. if(typeof pasteObj.specs !== 'undefined'){
  1121. tempObj.specs = pasteObj.specs;
  1122. }
  1123. if(typeof pasteObj.unit !== 'undefined'){
  1124. tempObj.unit = pasteObj.unit;
  1125. }
  1126. if(typeof pasteObj.gljType !== 'undefined'){
  1127. let isExsit = false;
  1128. for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){
  1129. if(pasteObj.gljType === me.distTypeTree.comboDatas[i].text){
  1130. pasteObj.gljType = me.distTypeTree.comboDatas[i].value;
  1131. isExsit = true;
  1132. //调整系数
  1133. if(pasteObj.gljType !== 1 && pasteObj.gljType !== 303){
  1134. tempObj.adjCoe = null;
  1135. }
  1136. else if((pasteObj.gljType === 1 || pasteObj.gljType === 303) && typeof pasteObj.adjCoe !== 'undefined' && !isNaN(pasteObj.adjCoe) && pasteObj.adjCoe % 1 === 0) {
  1137. tempObj.adjCoe = pasteObj.adjCoe;
  1138. }
  1139. if(pasteObj.gljType !== 301 && tempObj.gljType === 301){
  1140. tempObj.model = null;
  1141. }
  1142. if(componentType.includes(tempObj.gljType) &&
  1143. //!(tempObj.gljType === 302 && pasteObj.gljType === 303) && !(tempObj.gljType === 303 && pasteObj.gljType === 302)){//修改了原本是组成物的工料机
  1144. !(machineComponent.includes(tempObj.gljType) && machineComponent.includes(pasteObj.gljType)) &&
  1145. !(materialComponent.includes(tempObj.gljType) && materialComponent.includes(pasteObj.gljType))){//修改了原本是组成物的工料机
  1146. //寻找所有引用了此组成物的工料机,并从组成物中删去此工料机,并重算单价
  1147. let updateGljs = me.getUpdateGljs(tempObj, true);
  1148. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  1149. for(let i = 0; i < updateGljs.updateArr.length; i++){
  1150. rst.updateGlj.push(updateGljs.updateArr[i]);
  1151. }
  1152. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  1153. rst.updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]);
  1154. }
  1155. }
  1156. }
  1157. tempObj.component = tempObj.gljType === pasteObj.gljType ? tempObj.component : [];
  1158. /*if(me.allowComponent.indexOf(tempObj.gljType) !== -1){//更改成可含组成物的工料机类型,定额价设置为零
  1159. tempObj.basePrice = tempObj.gljType === me.distTypeTree.comboDatas[i].value ? tempObj.basePrice : 0;
  1160. }*/
  1161. tempObj.gljType = pasteObj.gljType;
  1162. tempObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + tempObj.gljType].data.shortName;
  1163. break;
  1164. }
  1165. }
  1166. if(!isExsit) {
  1167. isValid = false;
  1168. }
  1169. }
  1170. if(typeof pasteObj.adjCoe !== 'undefined' && typeof pasteObj.gljType === 'undefined'){
  1171. if(tempObj.gljType && (tempObj.gljType === 1 || tempObj.gljType === 303) && typeof pasteObj.adjCoe !== 'undefined' && !isNaN(pasteObj.adjCoe) && pasteObj.adjCoe % 1 === 0) {
  1172. tempObj.adjCoe = pasteObj.adjCoe;
  1173. }
  1174. else {
  1175. isValid = false;
  1176. }
  1177. }
  1178. //单价相关
  1179. if(me.pasteIncludesPrice(pasteObj)){
  1180. if(!priceProperties || priceProperties.length === 0){
  1181. pasteObj.basePrice = pasteObj.basePrice && !isNaN(parseFloat(pasteObj.basePrice)) ?
  1182. scMathUtil.roundTo(parseFloat(pasteObj.basePrice), -2) : me.currentCache[rowIdx].basePrice;
  1183. if(pasteObj.basePrice !== me.currentCache[rowIdx].basePrice){
  1184. reCalBasePrc = true;
  1185. tempObj.basePrice = pasteObj.basePrice;
  1186. }
  1187. }
  1188. else {
  1189. //多单价粘贴
  1190. let pastePriceProperty = {};
  1191. let priceFields = me.getPriceFields();
  1192. for(let priceField of priceFields){
  1193. if(typeof pasteObj[priceField] !== 'undefined' && pasteObj[priceField] && !isNaN(parseFloat(pasteObj[priceField]))){
  1194. pastePriceProperty[priceField] = scMathUtil.roundTo(parseFloat(pasteObj[priceField]), -2);
  1195. }
  1196. }
  1197. if(!me.priceIsEqual(tempObj, pasteObj)){
  1198. reCalBasePrc = true;
  1199. //更新人材机单价
  1200. for(let priceField in pastePriceProperty){
  1201. tempObj.priceProperty[priceField] = pastePriceProperty[priceField];
  1202. }
  1203. }
  1204. }
  1205. let updateGljs = me.getUpdateGljs(tempObj, false);
  1206. if(updateGljs.updateArr.length > 0 || updateGljs.updateBasePrcArr.length > 0){
  1207. for(let i = 0; i < updateGljs.updateArr.length; i++){
  1208. rst.updateGlj.push(updateGljs.updateArr[i]);
  1209. }
  1210. for(let i = 0; i < updateGljs.updateBasePrcArr.length; i++){
  1211. rst.updateBasePrcArr.push(updateGljs.updateBasePrcArr[i]);
  1212. }
  1213. }
  1214. }
  1215. if(typeof pasteObj.materialType !== 'undefined'){
  1216. if(!me.materialType.textArr.includes(pasteObj.materialType)){
  1217. isValid = false;
  1218. materialTypeValid = false;
  1219. }
  1220. else {
  1221. me.materialType.comboItems.forEach(function (item) {
  1222. if(item.text === pasteObj.materialType){
  1223. tempObj.materialType = item.value;
  1224. }
  1225. });
  1226. }
  1227. }
  1228. if(typeof pasteObj.materialCoe !== 'undefined'){
  1229. if(isNaN(pasteObj.materialCoe) ||
  1230. (!tempObj.materialType && (!pasteObj.materialType || !me.materialType.textArr.includes(pasteObj.materialType)))){
  1231. tempObj.materialType = '';
  1232. tempObj.materialCoe = null;
  1233. isValid = false;
  1234. }
  1235. else{
  1236. tempObj.materialCoe = pasteObj.materialCoe !== '' ? scMathUtil.roundTo(parseFloat(pasteObj.materialCoe), -5) : null;
  1237. }
  1238. }
  1239. if(typeof pasteObj.model !== 'undefined'){
  1240. if(!me.machineModel.textArr.includes(pasteObj.model)){
  1241. isValid = false;
  1242. }
  1243. else {
  1244. let existsModel = false;
  1245. if((typeof pasteObj.gljType !== 'undefined' && pasteObj.gljType === 301) ||
  1246. (tempObj.gljType && tempObj.gljType === 301)){
  1247. me.machineModel.comboItems.forEach(function (item) {
  1248. if(item.text === pasteObj.model){
  1249. tempObj.model = item.value;
  1250. existsModel = true;
  1251. }
  1252. });
  1253. if(!existsModel){
  1254. isValid = false;
  1255. }
  1256. }
  1257. else {
  1258. isValid = false;
  1259. }
  1260. }
  1261. }
  1262. if(isValid){
  1263. rst.updateGlj.push(tempObj);
  1264. if(reCalBasePrc){
  1265. //重新计算定额基价对象
  1266. let newReObj = {gljId: tempObj.ID, gljType: tempObj.gljType, basePrice: me.getRationGljPrice(tempObj)};
  1267. rst.updateBasePrcArr.push(newReObj);
  1268. }
  1269. }
  1270. else {
  1271. for(let attr in backUpObj){
  1272. tempObj[attr] = backUpObj[attr];
  1273. }
  1274. }
  1275. return rst;
  1276. },
  1277. //粘贴的数据是否是可添加的数据,只有含有编号,名称,类型才可添加
  1278. isValidObj: function(pasteObj) {
  1279. let me = repositoryGljObj;
  1280. if(!(pasteObj.code && typeof pasteObj.code !== 'undefined') || !(pasteObj.name && typeof pasteObj.name !== 'undefined') ||
  1281. !(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined')){
  1282. return false;
  1283. }
  1284. if(pasteObj.gljType && typeof pasteObj.gljType !== 'undefined'){
  1285. let isExist = false;
  1286. for(let i = 0; i < me.distTypeTree.comboDatas.length; i++){
  1287. if(me.distTypeTree.comboDatas[i].text === pasteObj.gljType){
  1288. isExist = true;
  1289. pasteObj.gljType = me.distTypeTree.comboDatas[i].value;
  1290. pasteObj.shortName = me.distTypeTree.distTypes[me.distTypeTree.prefix + pasteObj.gljType].data.shortName;
  1291. break;
  1292. }
  1293. }
  1294. if(!isExist){
  1295. return false;
  1296. }
  1297. }
  1298. if(pasteObj.code && typeof pasteObj.code !== 'undefined'){
  1299. for(let i = 0; i < me.gljList.length; i++){
  1300. if(me.gljList[i].code === pasteObj.code){
  1301. return false;
  1302. }
  1303. }
  1304. }
  1305. if(pasteObj.adjCoe && typeof pasteObj.adjCoe !== 'undefined'){
  1306. if(isNaN(pasteObj.adjCoe) || pasteObj.adjCoe % 1 !== 0){
  1307. return false;
  1308. }
  1309. }
  1310. if(pasteObj.materialType){
  1311. if(!me.materialType.textArr.includes(pasteObj.materialType)){
  1312. return false;
  1313. }
  1314. else {
  1315. me.materialType.comboItems.forEach(function (item) {
  1316. if(item.text === pasteObj.materialType){
  1317. pasteObj.materialType = item.value;
  1318. }
  1319. });
  1320. }
  1321. }
  1322. if(pasteObj.materialCoe){
  1323. if(isNaN(pasteObj.materialCoe) || !pasteObj.materialType){
  1324. return false;
  1325. }
  1326. }
  1327. if(typeof pasteObj.model !== 'undefined' && pasteObj.model){
  1328. if(!me.machineModel.textArr.includes(pasteObj.model) || pasteObj.gljType !== 301){
  1329. return false;
  1330. }
  1331. me.machineModel.comboItems.forEach(function (item) {
  1332. if(item.text === pasteObj.model){
  1333. pasteObj.model = item.value;
  1334. }
  1335. });
  1336. }
  1337. if(!priceProperties || priceProperties.length === 0){
  1338. pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? parseFloat(pasteObj.basePrice) : 0;
  1339. }
  1340. else {
  1341. let pastePriceProperty = {};
  1342. let priceFields = me.getPriceFields();
  1343. for(let priceField of priceFields){
  1344. if(typeof pasteObj[priceField] !== 'undefined' && pasteObj[priceField] && !isNaN(parseFloat(pasteObj[priceField]))){
  1345. pastePriceProperty[priceField] = scMathUtil.roundTo(parseFloat(pasteObj[priceField]), -2);
  1346. }
  1347. else {
  1348. pastePriceProperty[priceField] = 0;
  1349. }
  1350. }
  1351. pasteObj.priceProperty = pastePriceProperty;
  1352. }
  1353. //pasteObj.basePrice = !isNaN(parseFloat(pasteObj.basePrice)) && (pasteObj.basePrice && typeof pasteObj.basePrice !== 'undefined') ? parseFloat(pasteObj.basePrice) : 0;
  1354. if(!me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]){
  1355. pasteObj.gljClass = me.gljCurTypeId;
  1356. }
  1357. return true;
  1358. },
  1359. canPasted: function (info) {
  1360. let rst = true;
  1361. let me = repositoryGljObj;
  1362. if(me.gljCurTypeId < 0){
  1363. return false;
  1364. }
  1365. //粘贴的最大列下标不超过总列数
  1366. if(info.cellRange.col + info.cellRange.colCount - 1 > me.setting.header.length - 1){
  1367. return false;
  1368. }
  1369. if(info.cellRange.row < me.currentCache.length){
  1370. if(info.cellRange.col === 0){
  1371. return false;
  1372. }
  1373. }
  1374. return rst;
  1375. },
  1376. onClipboardPasting: function(sender, args) {
  1377. let me = repositoryGljObj;
  1378. //复制的列数超过正确的列数,不可复制
  1379. if(me.prevent){
  1380. args.cancel = true;
  1381. return;
  1382. }
  1383. if(!me.canPasted(args)){
  1384. args.cancel = true;
  1385. }
  1386. },
  1387. onClipboardPasted: function(e, info) {
  1388. $.bootstrapLoading.start();
  1389. let me = repositoryGljObj;
  1390. let updateArr = [], addArr = [];
  1391. let items = sheetCommonObj.analyzePasteData(me.setting, info);
  1392. let beginRow = info.cellRange.row, endRow = info.cellRange.row + info.cellRange.rowCount - 1,
  1393. maxRow = me.currentCache.length - 1,
  1394. updateBasePrcArr = [],
  1395. updateCount, resumeArr = [];
  1396. if(endRow <= maxRow){
  1397. //updateItems = items;
  1398. for(let i = 0; i < items.length; i++){
  1399. let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i);
  1400. if(updateObj && typeof updateObj.updateGlj !== 'undefined' && updateObj.updateGlj.length > 0){
  1401. //updateArr = updateObj.updateGlj;
  1402. updateArr = updateArr.concat(updateObj.updateGlj);
  1403. if(typeof updateObj.updateBasePrcArr !== 'undefined'){
  1404. //updateBasePrcArr = updateObj.updateBasePrc;
  1405. updateBasePrcArr = updateBasePrcArr.concat(updateObj.updateBasePrcArr);
  1406. }
  1407. }
  1408. }
  1409. }
  1410. else if(beginRow <= maxRow && endRow > maxRow){
  1411. updateCount = maxRow - beginRow + 1;
  1412. for(let i = 0; i < updateCount; i++){
  1413. let updateObj = me.validUpdateObj(items[i], info.cellRange.row + i);
  1414. if(updateObj && typeof updateObj.updateGlj !== 'undefined'){
  1415. updateArr = updateArr.concat(updateObj.updateGlj);
  1416. if(typeof updateObj.updateBasePrcArr !== 'undefined'){
  1417. updateBasePrcArr = updateBasePrcArr.concat(updateObj.updateBasePrcArr);
  1418. }
  1419. }
  1420. }
  1421. //if(info.cellRange.colCount >= me.setting.header.length - 4 && info.cellRange.colCount <= me.setting.header.length){
  1422. //[code, ..., gljType]
  1423. if(info.cellRange.colCount >= 5 && info.cellRange.colCount <= me.setting.header.length){
  1424. for(let i = updateCount ; i < items.length; i++){
  1425. if(me.isValidObj(items[i])){
  1426. items[i].component = [];
  1427. addArr.push(items[i]);
  1428. }
  1429. }
  1430. }
  1431. }
  1432. else{
  1433. //if(info.cellRange.colCount >= me.setting.header.length - 4 && info.cellRange.colCount <= me.setting.header.length && info.cellRange.col + info.cellRange.colCount - 1 >= 5){
  1434. //粘贴的的最大列至少要等于工料机类型列,因为工料机类型必须有效才可新增
  1435. if(info.cellRange.colCount >= 5 && info.cellRange.colCount <= me.setting.header.length && info.cellRange.col + info.cellRange.colCount - 1 >= me.colMapping.fieldToCol['gljType']){
  1436. for(let i = 0; i < items.length; i++){
  1437. if(me.isValidObj(items[i])){
  1438. items[i].component = [];
  1439. addArr.push(items[i]);
  1440. }
  1441. }
  1442. }
  1443. }
  1444. //repaint
  1445. for(let i = 0; i < info.cellRange.rowCount; i++){
  1446. resumeArr.push(info.cellRange.row + i);
  1447. }
  1448. if(resumeArr.length > 0){
  1449. info.sheet.suspendPaint();
  1450. for(let i = 0; i < resumeArr.length ; i++){
  1451. if(resumeArr[i] < me.currentCache.length){
  1452. for(let col = 0; col < me.setting.header.length; col++){
  1453. let dCode = me.setting.header[col].dataCode;
  1454. if(me.priceCols.includes(col)){
  1455. let price = me.getPrice(me.currentCache[resumeArr[i]], col);
  1456. info.sheet.setValue(resumeArr[i], col, price ? price : 0);
  1457. }
  1458. else if(dCode === 'gljType'){
  1459. let gljType = me.currentCache[resumeArr[i]][dCode];
  1460. info.sheet.setValue(resumeArr[i], col, me.distTypeTree.distTypes["gljType" + gljType].data.fullName);
  1461. }
  1462. else if(dCode === 'materialType'){
  1463. info.sheet.setValue(resumeArr[i], col, me.currentCache[resumeArr[i]][dCode] ? me.materialTypeIdx[me.currentCache[resumeArr[i]][dCode]]: '');
  1464. }
  1465. else if(dCode === 'model'){
  1466. info.sheet.setValue(resumeArr[i], col, me.currentCache[resumeArr[i]][dCode] ? me.machineModelIdx[me.currentCache[resumeArr[i]][dCode]]: '');
  1467. }
  1468. else{
  1469. info.sheet.setValue(resumeArr[i], col, me.currentCache[resumeArr[i]][dCode]);
  1470. }
  1471. }
  1472. }
  1473. else{
  1474. for(let col = 0; col < me.setting.header.length; col++){
  1475. info.sheet.setValue(resumeArr[i], col, '');
  1476. }
  1477. }
  1478. }
  1479. info.sheet.resumePaint();
  1480. }
  1481. if (updateArr.length > 0 || addArr.length > 0) {
  1482. me.mixUpdateRequest(updateArr, addArr, []);
  1483. } else {
  1484. $.bootstrapLoading.end();
  1485. }
  1486. if(updateBasePrcArr.length > 0 && me.rationLibs.length > 0){
  1487. me.updateRationBasePrcRq(updateBasePrcArr);
  1488. }
  1489. },
  1490. updateRationBasePrcRq: function (basePrcArr, workBook, callback) {
  1491. let me = this;
  1492. me.prevent = true;
  1493. me.calcRation = true;
  1494. if (!$.bootstrapLoading.isLoading()) {
  1495. $.bootstrapLoading.start();
  1496. }
  1497. $.ajax({
  1498. type: 'post',
  1499. url: 'api/updateRationBasePrc',
  1500. data:{basePrcArr: JSON.stringify(basePrcArr), repId: pageOprObj.gljLibId},
  1501. dataType: 'json',
  1502. success: function (result) {
  1503. me.calcRation = false;
  1504. if(result.error){
  1505. alert("计算定额基价失败");
  1506. }
  1507. if(workBook){
  1508. workBook.focus(true);
  1509. }
  1510. else {
  1511. me.workBook.focus(true);
  1512. }
  1513. me.prevent = false;
  1514. if(callback){
  1515. callback();
  1516. }
  1517. if ($.bootstrapLoading.isLoading()) {
  1518. $.bootstrapLoading.end();
  1519. }
  1520. }
  1521. });
  1522. },
  1523. mixUpdateRequest: function(updateArr, addArr, removeIds) {
  1524. let me = repositoryGljObj;
  1525. if(updateArr.length > 0){
  1526. me.saveInString(updateArr)
  1527. }
  1528. if(addArr.length > 0){
  1529. me.saveInString(addArr);
  1530. }
  1531. $.ajax({
  1532. type:"POST",
  1533. url:"api/mixUpdateGljItems",
  1534. data:{"repositoryId": me.currentRepositoryId, "lastOpr": userAccount, "updateItems": JSON.stringify(updateArr), "addItems": JSON.stringify(addArr), "removeIds": JSON.stringify(removeIds)},
  1535. dataType:"json",
  1536. cache:false,
  1537. timeout:50000,
  1538. success:function(result){
  1539. if (result.error) {
  1540. alert(result.message);
  1541. } else {
  1542. me.updateCache(addArr, updateArr, removeIds, result);
  1543. //me.sortGlj();
  1544. if(me.currentOprParent === 1){
  1545. me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + me.gljCurTypeId]);
  1546. }
  1547. else{
  1548. me.currentCache = me.getCache();
  1549. }
  1550. me.showGljItems(me.currentCache, me.gljCurTypeId);
  1551. //getCurrentGlj
  1552. let row = me.workBook.getSheet(0).getSelections()[0].row;
  1553. me.currentGlj = row < me.currentCache.length ? me.currentCache[row] : null;
  1554. me.currentComponent = me.currentGlj ? me.getCurrentComponent(me.currentGlj.component) : [];
  1555. sheetCommonObj.cleanData(gljComponentOprObj.workBook.getSheet(0), gljComponentOprObj.setting, -1);
  1556. sheetsOprObj.showData(gljComponentOprObj, gljComponentOprObj.workBook.getSheet(0), gljComponentOprObj.setting, me.currentComponent);
  1557. }
  1558. if (!me.calcRation && $.bootstrapLoading.isLoading()) {
  1559. $.bootstrapLoading.end();
  1560. }
  1561. },
  1562. error:function(err){
  1563. if ($.bootstrapLoading.isLoading()) {
  1564. $.bootstrapLoading.end();
  1565. }
  1566. console.log(err);
  1567. alert("保存失败");
  1568. }
  1569. });
  1570. },
  1571. saveInString: function (datas) {
  1572. for(let i = 0, len = datas.length; i < len; i++){
  1573. let data = datas[i];
  1574. if(_exist(data, 'basePrice')){
  1575. data['basePrice'] = data['basePrice'].toString();
  1576. }
  1577. if(_exist(data, 'component')){
  1578. for(let j = 0, jLen = data['component'].length; j < jLen; j++){
  1579. let comGljObj = data['component'][j];
  1580. if(_exist(comGljObj, 'consumeAmt')){
  1581. comGljObj['consumeAmt'] = comGljObj['consumeAmt'].toString();
  1582. }
  1583. }
  1584. }
  1585. }
  1586. function _exist(data, attr){
  1587. return data && data[attr] !== undefined && data[attr];
  1588. }
  1589. },
  1590. getParentCache: function (nodes) {
  1591. let me = repositoryGljObj, rst = [];
  1592. for(let i = 0; i < me.gljList.length; i++){
  1593. if(nodes.indexOf(me.gljList[i].gljClass) !== -1){
  1594. rst.push(me.gljList[i]);
  1595. }
  1596. }
  1597. rst.sort(function (a, b) {
  1598. let rst = 0;
  1599. if(a.code > b.code) rst = 1;
  1600. else if(a.code < b.code)rst = -1;
  1601. return rst;
  1602. });
  1603. return rst;
  1604. },
  1605. getCache: function() {
  1606. let me = this, rst = [];
  1607. for (let i = 0; i < me.gljList.length; i++) {
  1608. if (me.gljList[i].gljClass == me.gljCurTypeId) {
  1609. rst.push(me.gljList[i]);
  1610. }
  1611. }
  1612. return rst;
  1613. },
  1614. updateCache: function(addArr, updateArr, removeIds, result) {
  1615. let me = this, cacheSection = me.gljList;
  1616. if (addArr.length > 0) {
  1617. me.gljList = me.gljList.concat(addArr);
  1618. cacheSection = me.gljList;
  1619. }
  1620. for (let i = removeIds.length - 1; i >= 0; i--) {
  1621. for (let j = cacheSection.length - 1; j >= 0 ; j--) {
  1622. if (cacheSection[j]["ID"] == removeIds[i]) {
  1623. cacheSection.splice(j,1);
  1624. }
  1625. }
  1626. }
  1627. if (result && result.data && result.data.ops && result.data.ops.length > 0) {
  1628. for (let i = 0; i < result.data.ops.length; i++) {
  1629. for (let j = 0; j < cacheSection.length; j++) {
  1630. if (cacheSection[j]['code'] == result.data.ops[i]['code']) {
  1631. cacheSection[j]["ID"] = result.data.ops[i]["ID"];
  1632. }
  1633. }
  1634. }
  1635. }
  1636. for (let i = 0; i < updateArr.length; i++) {
  1637. for (let j = 0; j < cacheSection.length; j++) {
  1638. if (updateArr[i]["ID"] && cacheSection[j]["ID"]) {
  1639. if (cacheSection[j]["ID"] == updateArr[i]["ID"]) {
  1640. cacheSection[j] = updateArr[i];
  1641. }
  1642. } else {
  1643. if (cacheSection[j]['code'] == updateArr[i]['code']) {
  1644. cacheSection[j] = updateArr[i];
  1645. }
  1646. }
  1647. }
  1648. }
  1649. },
  1650. updateParentNodeIds: function (nodes, caller) {
  1651. let private_build_parentNodeIds = function(pNodeId, nodesArr){
  1652. let rst = [];
  1653. for (let i = 0; i < nodesArr.length; i++) {
  1654. if (nodesArr[i].children.length > 0) {
  1655. rst = rst.concat(private_build_parentNodeIds(nodesArr[i].data.ID, nodesArr[i].children));
  1656. } else {
  1657. rst.push(nodesArr[i].data.ID);
  1658. }
  1659. }
  1660. if (pNodeId && rst.length > 0) {
  1661. caller.parentNodeIds["_pNodeId_" + pNodeId] = rst;
  1662. }
  1663. return rst;
  1664. };
  1665. if (caller.parentNodeIds) {
  1666. private_build_parentNodeIds(null, nodes);
  1667. }
  1668. },
  1669. sortGljDeep: function (datas) {
  1670. function recurCompare(a, b, index){
  1671. if (a[index] && !b[index]) {
  1672. return 1;
  1673. } else if (!a[index] && b[index]) {
  1674. return -1;
  1675. } else if (a[index] && b[index]) {
  1676. let aV = a[index],
  1677. bV = b[index];
  1678. if (!isNaN(aV) && !isNaN(bV)) {
  1679. aV = parseFloat(a[index]);
  1680. bV = parseFloat(b[index]);
  1681. }
  1682. if (aV > bV) {
  1683. return 1;
  1684. } else if (aV < bV) {
  1685. return -1;
  1686. } else {
  1687. return recurCompare(a, b, index + 1);
  1688. }
  1689. }
  1690. return 0;
  1691. }
  1692. //排序符号-
  1693. datas.sort(function (a, b) {
  1694. let aArr = a.code.split('-'),
  1695. bArr = b.code.split('-');
  1696. return recurCompare(aArr, bArr, 0);
  1697. });
  1698. },
  1699. //工料机排序
  1700. sortGlj: function() {
  1701. let me = this;
  1702. me.gljList.sort(function(a, b){
  1703. let rst = 0;
  1704. if (a.code > b.code) rst = 1
  1705. else if (a.code < b.code) rst = -1;
  1706. return rst;
  1707. });
  1708. }
  1709. }
  1710. let gljTypeTreeOprObj = {
  1711. onClick: function(event,treeId,treeNode) {
  1712. let me = repositoryGljObj,
  1713. that = gljComponentOprObj,
  1714. gljTypeId = treeNode.ID;
  1715. me.gljCurTypeId = treeNode.ID;
  1716. me.addGljObj = null;
  1717. sheetCommonObj.cleanSheet(that.workBook.getSheet(0), that.setting, 10);
  1718. if (me.parentNodeIds["_pNodeId_" + treeNode.ID]) {
  1719. me.currentOprParent = 1;
  1720. me.currentCache = me.getParentCache(me.parentNodeIds["_pNodeId_" + treeNode.ID]);
  1721. me.workBook.getSheet(0).setRowCount(me.currentCache.length);
  1722. } else {
  1723. me.currentOprParent = 0;
  1724. me.currentCache = me.getCache();
  1725. }
  1726. me.showGljItems(me.currentCache, gljTypeId);
  1727. },
  1728. beforeRename: function(treeId, treeNode, newName, isCancel) {
  1729. if (newName.length == 0) {
  1730. return false;
  1731. }
  1732. return true;
  1733. },
  1734. onRename : function(e, treeId, treeNode, isCancel) {
  1735. let nodes = [];
  1736. nodes.push(treeNode);
  1737. gljTypeTreeOprObj.updateNodes(nodes);
  1738. },
  1739. onBeforeRemove: function(treeId, treeNode){
  1740. let me = this;
  1741. if (treeNode.ParentID == -1 && treeNode.isFirstNode) {
  1742. alert("不允许删除全部!");
  1743. return false;
  1744. }
  1745. if (!confirm("您确定要删除此节点及所有子节点的数据?删除后不可恢复!")) {
  1746. return false;
  1747. }
  1748. let nodeIds = [], preNode = treeNode.getPreNode(), preNodeId = -1;
  1749. if (preNode) {
  1750. preNodeId = preNode.ID;
  1751. }
  1752. private_fetchAllSubItems = function(pItem){
  1753. nodeIds.push(pItem.ID);
  1754. if (pItem.items && pItem.items.length > 0) {
  1755. for (let i = 0; i < pItem.items.length; i++) {
  1756. private_fetchAllSubItems(pItem.items[i]);
  1757. }
  1758. }
  1759. };
  1760. nodeIds.push(treeNode.ID);
  1761. for (let i = 0; i < treeNode.items.length; i++) {
  1762. private_fetchAllSubItems(treeNode.items[i]);
  1763. }
  1764. $.ajax({
  1765. type:"POST",
  1766. url:"api/deleteGljNodes",
  1767. data:{"repId": pageOprObj.gljLibId, "lastOpr": userAccount, "nodes": JSON.stringify(nodeIds), "preNodeId": preNodeId, "preNodeNextId": treeNode.NextSiblingID},
  1768. dataType:"json",
  1769. cache:false,
  1770. timeout:5000,
  1771. success:function(result,textStatus,status){
  1772. let pNode = treeNode.getParentNode();
  1773. if (pNode && pNode.items && pNode.items.length == 1) {
  1774. pNode.isParent = false;
  1775. }
  1776. },
  1777. error:function(){
  1778. }
  1779. });
  1780. return true;
  1781. },
  1782. onRemove: function(e, treeId, treeNode){
  1783. let me = repositoryGljObj, pNode = me.treeObj.getNodeByTId(treeNode.parentTId);
  1784. if (pNode && pNode.items && pNode.items.length == 0) {
  1785. pNode.isParent = false;
  1786. me.treeObj.refresh();
  1787. }
  1788. },
  1789. updateNodes: function(nodes){
  1790. if (nodes && nodes.length > 0) {
  1791. let reqData = []
  1792. for (let i = 0; i < nodes.length; i++) {
  1793. let node = {};
  1794. node.repositoryId = nodes[i].repositoryId;
  1795. node.ID = nodes[i].ID;
  1796. node.ParentID = nodes[i].ParentID;
  1797. node.NextSiblingID = nodes[i].NextSiblingID;
  1798. node.Name = nodes[i].Name;
  1799. reqData.push(node);
  1800. }
  1801. $.ajax({
  1802. type:"POST",
  1803. url:"api/updateGljNodes",
  1804. data:{"repId": pageOprObj.gljLibId, "lastOpr": userAccount, "nodes": JSON.stringify(reqData)},
  1805. dataType:"json",
  1806. cache:false,
  1807. timeout:5000,
  1808. success:function(result,textStatus,status){
  1809. console.log(status + ' : ' + result);
  1810. },
  1811. error:function(){
  1812. }
  1813. })
  1814. }
  1815. },
  1816. addRootNode: function() {
  1817. let me = repositoryGljObj, rawNode = {ParentID: -1, NextSiblingID: -1, Name: "所有"}, lastNodeId = -1;
  1818. if (me.treeObj) {
  1819. let rootNodes = me.treeObj.getNodes();
  1820. if (rootNodes.length == 0) {
  1821. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  1822. if (!(err)) {
  1823. let newNodes = [], isSilent = false;
  1824. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"所有",isParent:false, items:[]});
  1825. me.treeObj.addNodes(null, -1, newNodes, isSilent);
  1826. }
  1827. });
  1828. }
  1829. }
  1830. },
  1831. addNewNode : function(rawNode, lastNodeId, callback){
  1832. $.ajax({
  1833. type:"POST",
  1834. url:"api/createNewGljTypeNode",
  1835. data:{"lastOpr": userAccount, "repositoryId": repositoryGljObj.currentRepositoryId,"lastNodeId": lastNodeId, "rawNodeData": JSON.stringify(rawNode)},
  1836. dataType:"json",
  1837. cache:false,
  1838. timeout:1000,
  1839. success: function(result,textStatus,status){
  1840. callback(false, result);
  1841. },
  1842. error:function(err){
  1843. callback(err);
  1844. }
  1845. })
  1846. },
  1847. addHoverDom: function(treeId, treeNode) {
  1848. if(typeof treeNode.doing !== 'undefined' && treeNode.doing){
  1849. return false;
  1850. }
  1851. hoverOpr();
  1852. function hoverOpr(){
  1853. let me = repositoryGljObj, sObj = $("#" + treeNode.tId + "_span");
  1854. if (treeNode.editNameFlag || $("#addBtn_"+treeNode.tId).length>0) return;
  1855. let addStr = "<span class='button add' id='addBtn_" + treeNode.tId + "' title='新增子节点' onfocus='this.blur();'></span>";
  1856. sObj.after(addStr);
  1857. let btn = $("#addBtn_"+treeNode.tId);
  1858. if (btn) btn.bind("click", function(){
  1859. treeNode.doing = true;
  1860. let rawNode = {ParentID: treeNode.ID, NextSiblingID: -1, Name: "新增子节点"}, lastNodeId = -1;
  1861. if (treeNode.items.length > 0) {
  1862. lastNodeId = treeNode.items[treeNode.items.length - 1].ID;
  1863. }
  1864. gljTypeTreeOprObj.addNewNode(rawNode, lastNodeId, function(err, rst){
  1865. if (!(err)) {
  1866. let newNodes = [], isSilent = false;
  1867. if(treeNode.items.length > 0){
  1868. treeNode.items[treeNode.items.length - 1].NextSiblingID = rst.data.ID;
  1869. }
  1870. newNodes.push({ repositoryId: rst.data.repositoryId, ID: rst.data.ID, ParentID: rst.data.ParentID, NextSiblingID:-1, Name:"新增子节点",isParent:false, items:[]});
  1871. treeNode.isParent = true;
  1872. if (me.treeObj) {
  1873. me.treeObj.addNodes(treeNode, -1, newNodes, isSilent);
  1874. } else {
  1875. me.treeObj = $.fn.zTree.init($("#rationChapterTree"), gljSetting, newNodes);
  1876. }
  1877. treeNode.doing = false;
  1878. hoverOpr();
  1879. }
  1880. });
  1881. });
  1882. }
  1883. },
  1884. removeHoverDom: function(treeId, treeNode) {
  1885. $("#addBtn_"+treeNode.tId).unbind().remove();
  1886. }
  1887. };