project_view.js 107 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450
  1. /**
  2. * Created by Mai on 2017/6/21.
  3. */
  4. var projectObj = {
  5. project: null,
  6. mainSpread: null,
  7. mainController: null,
  8. gljSpreed:null,
  9. beforeMainTreeSelectedChange: function (pre) {
  10. /*if (node) {
  11. subViewObj.saveComments(node);
  12. }*/
  13. },
  14. // CSL, 2018-02-09 用于测试显示。使用示例:projectObj.testDisplay(‘总额’, 100);
  15. testDisplay: function (caption, value) {
  16. let c = '';
  17. if (caption) c = caption + ': ';
  18. let s = `          ${c}${value}`;
  19. $('#testDisplay').html(s);
  20. },
  21. treeSelectedChanged: function (node) {
  22. let project = projectObj.project;
  23. let mainSheet = projectObj.mainController.sheet;
  24. //设置选中行底色和恢复前选中行底色
  25. let refreshNodes = [node];
  26. if(!project.mainTree.preSelected){
  27. refreshNodes.push(project.mainTree.items[0]);
  28. }
  29. else {
  30. refreshNodes.push(project.mainTree.preSelected);
  31. }
  32. project.mainTree.preSelected = node;
  33. projectObj.setNodesStyle(projectObj.mainController.sheet, refreshNodes);
  34. if($('#linkComments').hasClass('active')){
  35. subViewObj.loadComments(node);
  36. }
  37. gljOprObj.showDataIfRationSelect(node);
  38. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  39. calcProgramObj.showData(node);
  40. }
  41. //zhong 2017-9-1 特征及内容
  42. if(pageCCOprObj.active){
  43. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
  44. pageCCOprObj.setCacheAndShow(node);
  45. }
  46. // for test interface. CSLAAAAA
  47. // projectObj.testDisplay('前四项累计值排除当前选中项' + projectObj.project.calcProgram.getBeforeTaxTotalFee([node]));
  48. // 基数
  49. // node.data.isSubcontract = true;
  50. // node.data.gljList = project.ration_glj.getGljArrByRation(node.data);
  51. // let bname = '甲供定额基价材料费';
  52. // projectObj.testDisplay(bname, rationCalcBases[bname](node));
  53. },
  54. refreshBaseActn: function (tree) {
  55. let setButtonValid = function (valid, btn) {
  56. if (valid) {
  57. btn.removeClass('disabled');
  58. } else {
  59. btn.addClass('disabled');
  60. }
  61. };
  62. let selected = tree.selected, that = projectObj;
  63. let canUpLevel = function (node) {
  64. if(!node){
  65. return false;
  66. }
  67. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  68. return false;
  69. }
  70. if(node.depth()<=1){//焦点行是树结构的第一/二层节点,灰显。
  71. return false;
  72. }
  73. if(node.sourceType !== that.project.Bills.getSourceType()){//焦点行是定额/量价/工料机,灰显。
  74. return false;
  75. }else {
  76. if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项,或者补项灰显。
  77. return false;
  78. }
  79. if(node.data.type == billType.FB&&node.nextSibling&&node.children.length>0){//焦点行是分部有后兄弟,有子项.
  80. if(node.children[0].data.type==billType.FX || node.children[0].data.type==billType.BX){ //焦点行子项是分项
  81. return false;
  82. }
  83. }
  84. if(node.data.type == billType.BILL &&node.nextSibling){//焦点行是清单有后兄弟
  85. if(node.data.calcBase&&node.data.calcBase!=""){//有基数计算
  86. return false;
  87. }
  88. if(node.children.length>0&&node.children[0].sourceType !== that.project.Bills.getSourceType()){//有子项,并且子项不是清单
  89. return false;
  90. }
  91. }
  92. }
  93. return true;
  94. };
  95. let canDownLevel = function (node) {
  96. if(!node){
  97. return false;
  98. }
  99. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  100. return false;
  101. }
  102. if(node.depth()==0){//焦点行是树结构的第一层节点,灰显。
  103. return false;
  104. }
  105. if(node.sourceType !== that.project.Bills.getSourceType()) {//焦点行是定额/量价/工料机,灰显。
  106. return false;
  107. }else {
  108. if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项,灰显。
  109. return false;
  110. }
  111. if(!node.preSibling){//无前兄弟,灰显
  112. return false;
  113. }else if(node.preSibling.data.calcBase&&node.preSibling.data.calcBase!=""){//前兄弟有基数计算
  114. return false
  115. }
  116. if(node.preSibling.children.length>0){//前兄弟有子项,子项是分项,灰显。
  117. if(node.data.type==billType.FB&&(node.preSibling.children[0].data.type==billType.FX||node.preSibling.children[0].data.type==billType.BX)){//焦点行是分部前兄弟有子项,子项是分项,灰显。
  118. return false;
  119. }
  120. if(node.data.type==billType.BILL&&node.preSibling.children[0].sourceType !== that.project.Bills.getSourceType()){//焦点行是清单,子项不是清单
  121. return false
  122. }
  123. }
  124. }
  125. return true;
  126. };
  127. let canUpMove = function (node) {
  128. if(node&&node.preSibling){//有前兄弟
  129. if(node.sourceType==that.project.Bills.getSourceType()){
  130. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  131. return false;
  132. }
  133. if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
  134. return false;
  135. }
  136. }
  137. return true
  138. }
  139. return false
  140. };
  141. let canDownMove = function (node) {
  142. if(node&&node.nextSibling){
  143. if(node.sourceType==that.project.Bills.getSourceType()){
  144. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  145. return false;
  146. }
  147. if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
  148. return false;
  149. }
  150. }
  151. return true;
  152. }
  153. return false
  154. };
  155. setButtonValid(canInsertRationNode(selected), $('#insertRation'));
  156. setButtonValid(ifCanDelete(), $('#delete'));
  157. setButtonValid(canUpLevel(selected), $('#upLevel'));
  158. setButtonValid(canDownLevel(selected), $('#downLevel'));
  159. setButtonValid(canUpMove(selected) , $('#upMove'));
  160. setButtonValid(canDownMove(selected), $('#downMove'));
  161. setButtonValid(!projectObj.project.isBillsLocked(), $('#ZLFB_btn'));
  162. },
  163. checkCommonField: function (editingText, colSetting) {
  164. let value;
  165. if (colSetting.data.decimal) {
  166. value = Number(editingText);
  167. if (number_util.isNumber(value)) {
  168. if (colSetting.data.decimal) {
  169. value = value.toDecimal(colSetting.data.decimal);
  170. }
  171. } else {
  172. value = null;
  173. alert('当前输入的数据类型不正确,请重新输入。');
  174. }
  175. } else {
  176. value = editingText;
  177. }
  178. return value;
  179. },
  180. checkFormulaValidField: function (editingText, colSetting) {
  181. let value = Number(editingText);
  182. if (!value) {
  183. try {
  184. let exp = new Expression('');
  185. exp.Expression(editingText);
  186. value = Number(exp.Evaluate());
  187. } catch (error) {
  188. value = null;
  189. }
  190. }
  191. if (value!=undefined||value!=null) {
  192. if (colSetting.data.decimal) {
  193. value = value.toDecimal(colSetting.data.decimal);
  194. }
  195. } else if (editingText && editingText !== '') {
  196. value = null;
  197. alert('当前输入的数据类型不正确,请重新输入。');
  198. }
  199. return value;
  200. },
  201. checkSpreadEditingText: function (editingText, colSetting) {
  202. if (colSetting.data.field === 'quantity'||colSetting.data.field === 'contain') {
  203. return this.checkFormulaValidField(editingText, colSetting);
  204. }
  205. else if (colSetting.data.field === 'programID') {
  206. return this.project.calcProgram.compiledTemplateMaps[editingText];
  207. }
  208. else if (colSetting.data.field === 'subType') {
  209. if (typeof(editingText) !== "number")
  210. return volumePriceMaps[editingText]
  211. else
  212. return editingText;
  213. }
  214. else {
  215. return this.checkCommonField(editingText, colSetting);
  216. }
  217. },
  218. getVisibleRows: function (sRow, count) {
  219. let rst = [];
  220. let nodes = projectObj.project.mainTree.items;
  221. for(let i = sRow, len = nodes.length; i < len; i++){
  222. if(count <= 0){
  223. break;
  224. }
  225. if(nodes[i].visible){
  226. rst.push(i);
  227. count--;
  228. }
  229. }
  230. return rst;
  231. },
  232. //根据列标段设置焦点单元格
  233. setActiveCell(field, moveScroll){
  234. projectObj.mainSpread.focus(true);
  235. let mainSheet = projectObj.mainSpread.getActiveSheet();
  236. let fieldCol = colSettingObj.getColByField(field);
  237. if(fieldCol){
  238. if(moveScroll){
  239. mainSheet.showColumn(fieldCol, GC.Spread.Sheets.HorizontalPosition.left);
  240. }
  241. mainSheet.setActiveCell(projectObj.project.mainTree.selected.serialNo(), fieldCol);
  242. }
  243. },
  244. //获取粘贴更改的单元格(粘贴时,跳过隐藏行)
  245. checkSpreadChangedCells: function (info) {
  246. let rst = {refreshRows: [], changedCells: []};
  247. //获取显示行号
  248. let vRows = projectObj.getVisibleRows(info.row, info.rowCount);
  249. let vCount = vRows.length;
  250. let lastRow = null, count = 0;
  251. for(let cell of info.changedCells){
  252. cell.text = info.sheet.getCell(cell.row, cell.col).text();
  253. if(cell.row !== lastRow){
  254. count++;
  255. lastRow = cell.row;
  256. }
  257. if(count <= vCount){
  258. if(vRows[count - 1] !== cell.row){
  259. rst.refreshRows.push(cell.row);
  260. }
  261. rst.changedCells.push({row: vRows[count - 1], col: cell.col, text: cell.text});
  262. }
  263. else {
  264. rst.refreshRows.push(cell.row);
  265. }
  266. }
  267. rst.refreshRows = Array.from(new Set(rst.refreshRows));
  268. return rst;
  269. },
  270. updateBillsCode: function (node, value) {
  271. let project = projectObj.project,me = this;
  272. let stdMatchCode, formatCode, matchs;
  273. let searchStdBillsAndUpdate = function (stdCode, formatCode) {
  274. let orgCode = node.data.code?node.data.code.substr(0, 9):"";
  275. if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
  276. normalUpdate(node,value,stdCode === orgCode);
  277. } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
  278. let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
  279. CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
  280. if (data) {
  281. //data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
  282. node.data.name = data.name;
  283. if(node.data.type == billType.BX){//从清单库中找到标准清单的话,要把补项改成分项
  284. node.data.type = billType.FX;
  285. }
  286. pageCCOprObj.setItemContentNode(node, data.jobContent, data.itemCharacter, node.data.name);
  287. if (/\//.test(data.unit)) {
  288. let existB = projectObj.project.Bills.sameStdCodeBillsData(data.code);
  289. if (existB) {
  290. data.unit = existB.unit;
  291. //
  292. project.Bills.replaceBills(node.source, data, formatCode);
  293. projectObj.mainController.refreshTreeNode([node], false);
  294. } else {
  295. ConfirmModal.stdBillsUnit.check(data, function (std) {
  296. project.Bills.replaceBills(node.source, std, formatCode);
  297. projectObj.mainController.refreshTreeNode([node], false);
  298. }, function () {
  299. projectObj.mainController.refreshTreeNode([node], false);
  300. });
  301. }
  302. } else {
  303. project.Bills.replaceBills(node.source, data, formatCode);
  304. projectObj.mainController.refreshTreeNode([node], false);
  305. }
  306. } else {
  307. normalUpdate(node,value);
  308. }
  309. });
  310. }
  311. }
  312. //分部分项、措施项目才匹配
  313. let withinValidFixed = false;
  314. let matchFixedFlags = [fixedFlag.SUB_ENGINERRING, fixedFlag.MEASURE];
  315. let rootNode = getRootFixedNode(node);
  316. if(rootNode && rootNode.data.flagsIndex && rootNode.data.flagsIndex.fixed && matchFixedFlags.includes(rootNode.data.flagsIndex.fixed.flag)){
  317. withinValidFixed = true;
  318. }
  319. if(withinValidFixed && (node.data.type==billType.FX||node.data.type==billType.BX||(node.data.type==billType.BILL&&node.source.children.length==0))){//是分项、补项或者叶子清单的情况下才需要查找替换
  320. if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
  321. stdMatchCode = value;
  322. formatCode = project.Bills.newFormatCode(stdMatchCode);
  323. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  324. return;
  325. } else if (value&&value.length === 12 && /^[\d]+$/.test(value)) {
  326. stdMatchCode = value.substr(0, 9);
  327. matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
  328. if (matchs.indexOf(value) === -1) {
  329. searchStdBillsAndUpdate(stdMatchCode, value);
  330. return;
  331. } else {
  332. hintBox.infoBox("系统提示","已存在该编码的清单,是否继续?",2,function () {
  333. searchStdBillsAndUpdate(stdMatchCode, value);
  334. },function () {
  335. me.mainController.refreshTreeNode([node], false);
  336. },['确定','取消']);
  337. return;
  338. /*if (confirm('已存在该编码的清单,是否继续?')) {
  339. // formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
  340. searchStdBillsAndUpdate(stdMatchCode, value);
  341. return;
  342. }else {
  343. this.mainController.refreshTreeNode([node], false);
  344. return;
  345. }*/
  346. }
  347. }
  348. }
  349. normalUpdate(node,value);
  350. function normalUpdate(billnode,codeValue,onNeedCheck) {//在标准库中没有找到清单时改分项为补项再更新
  351. let toBX = false;
  352. if(onNeedCheck!==true && billnode.data.type == billType.FX){
  353. billnode.data.type = billType.BX;
  354. toBX = true;
  355. }
  356. project.Bills.updateField(billnode.source, 'code', codeValue, toBX);
  357. me.mainController.refreshTreeNode([billnode], false);
  358. }
  359. },
  360. updateRationCode: function (node, value) {
  361. if(!isDef(node.data.code) && (!isDef(value) || value.toString().trim() == '')){
  362. return;
  363. }
  364. if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
  365. alert('当前项目无定额库,请添加定额库。');
  366. this.mainController.refreshTreeNode([node], false);
  367. } else {
  368. let libId = parseInt($('#stdRationLibSelect').val());
  369. CommonAjax.post('/complementaryRation/api/getRationItem', {user_id: userID, rationRepId: libId, code: value}, function (data) {
  370. if (data) {
  371. projectObj.project.Ration.replaceRation(node.source, data);
  372. projectObj.project.ration_glj.addRationGLJ(node.source, data);
  373. } else {
  374. alert('当前库中找不到定额"' + value + '"');
  375. }
  376. projectObj.mainController.refreshTreeNode([node], false);
  377. });
  378. }
  379. },
  380. updateCode: function (node, value) {
  381. let project = projectObj.project;
  382. if (node.sourceType === project.Bills.getSourceType()) {
  383. this.updateBillsCode(node, value); // 新清单不适合实时计算,下面套什么还不能确定,无数量计算也无意义
  384. } else if (node.sourceType === project.Ration.getSourceType()) {
  385. if(value && typeof(value) == 'string'){//小写转换成大写
  386. value = value.toUpperCase();
  387. }
  388. project.Ration.updateRationCodes([{'node':node,value:value}]);
  389. // this.updateRationCode(node, value); // 新套定额适合实时计算
  390. // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
  391. /*project.calcProgram.calcAndSave(node);
  392. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  393. calcProgramObj.showData(node, false);
  394. };*/
  395. }
  396. },
  397. updateNodeField : function (node,value,filedID,callback) {
  398. if(node.data[filedID] == value){
  399. return;
  400. }
  401. let data = {
  402. type:node.sourceType,
  403. data:{
  404. ID:node.data.ID
  405. }
  406. };
  407. data.data[filedID] = value;
  408. $.bootstrapLoading.start();
  409. projectObj.project.updateNodes([data],function () {
  410. node.data[filedID] = value;
  411. if(callback){
  412. callback();
  413. }
  414. $.bootstrapLoading.end();
  415. })
  416. },
  417. updateCellValue: function (node, value, colSetting,editingText) {
  418. let project = projectObj.project, fieldName = colSetting.data.field;
  419. if(node.sourceType==project.ration_glj.getSourceType()){
  420. project.ration_glj.updateFromMainSpread(value,node,fieldName);
  421. }else if(fieldName === 'remark'){
  422. projectObj.updateNodeField(node,value,'remark');
  423. } else if(calcTools.isGljRation(node)){
  424. gljOprObj.updateRationTypeGLJ(value,node,fieldName,editingText);
  425. } else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
  426. if (fieldName === 'code' && value != '' && !calcTools.isVolumePrice(node)) {
  427. projectObj.updateCode(node, value);
  428. }
  429. else if(fieldName ==='feeRate'){
  430. project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
  431. }
  432. else if(fieldName ==='contain'){//编辑含量
  433. project.Ration.updateContain(value,node);
  434. }
  435. else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee' || fieldName === 'programID' ||
  436. fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'isSubcontract'){
  437. if (fieldName === 'quantity') {
  438. project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
  439. return;
  440. }
  441. else if (fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee') {
  442. if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
  443. }
  444. else if (fieldName === 'calcBase') {
  445. //zhong
  446. if(value === undefined ||value === null || value.toString().trim() === ''){
  447. value = '';
  448. }
  449. node.data.userCalcBase = value;
  450. project.calcBase.calculate(node);
  451. if(!project.calcBase.success){
  452. let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  453. projectObj.mainController.refreshTreeNode([node]);
  454. return;
  455. }
  456. // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
  457. };
  458. //计算基数赋值要经过解析和标准化,已在calculate里赋值
  459. if(fieldName !== 'calcBase'){
  460. calcTools.setFieldValue(node, fieldName, value);
  461. };
  462. project.calcProgram.calcAndSave(node);
  463. gljOprObj.showRationGLJSheetData();
  464. }
  465. else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
  466. node.data[fieldName] = value;
  467. node.changed = true;
  468. if(node.data.quantity){
  469. node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
  470. }
  471. project.calcProgram.calcAndSave(node);
  472. }
  473. else {
  474. if (node.sourceType === project.Bills.getSourceType()) {
  475. project.Bills.updateField(node.source, fieldName, value, false);
  476. }
  477. else if (node.sourceType === project.Ration.getSourceType()) {
  478. project.Ration.updateField(node.source, fieldName, value);
  479. };
  480. if (colSetting.data.wordWrap) {
  481. this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
  482. }
  483. projectObj.mainController.refreshTreeNode([node]);
  484. }
  485. }
  486. else if(value==null && fieldName ==='feeRate'){
  487. project.FeeRate.cleanFeeRateID(node);
  488. }
  489. else {
  490. projectObj.mainController.refreshTreeNode([node], false);
  491. }
  492. },
  493. mainSpreadLeaveCell: function (sender, info) {
  494. let colSetting = projectObj.mainController.setting.cols[info.col];
  495. projectObj.lastCol = colSetting;
  496. projectObj.lastCell = {row: info.row, col: info.col};
  497. },
  498. //repaint 动态下拉框
  499. mainSpreadEnterCell: function (sender, info) {
  500. let colSetting = projectObj.mainController.setting.cols[info.col];
  501. if(colSetting.data.field === 'unit' || (projectObj.lastCol&&projectObj.lastCol.data.field === 'unit')||colSetting.data.field ==='subType'
  502. || (projectObj.lastCol&&projectObj.lastCol.data.field === 'subType') || colSetting.data.field === 'programID' ||(projectObj.lastCol&&projectObj.lastCol.data.field === 'programID')){
  503. let rects = [];
  504. rects.push(info.sheet.getCellRect(info.row, info.col));
  505. if(projectObj.lastCell){
  506. rects.push(info.sheet.getCellRect(projectObj.lastCell.row, projectObj.lastCell.col));
  507. }
  508. for(let rect of rects){
  509. info.sheet.repaint(rect);
  510. }
  511. }
  512. },
  513. mainSpreadEditStarting: function (sender, info) {
  514. let project = projectObj.project;
  515. let node = project.mainTree.items[info.row];
  516. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  517. let orgV = info.sheet.getValue(info.row, info.col);
  518. let newV;
  519. if(node && node.sourceType === projectObj.project.Ration.getSourceType() && node.data.type === rationType.ration
  520. && isDef(node.data.code) && isDef(node.data.prefix) && node.data.prefix !== rationPrefix.none && fieldName === 'code'){
  521. /* if(node.data.prefix === rationPrefix.complementary){
  522. newV = orgV.replace(new RegExp(rationPrefix.complementary), '');
  523. }
  524. if(node.data.prefix === rationPrefix.borrow){
  525. newV = orgV.replace(new RegExp(rationPrefix.borrow), '');
  526. }*/
  527. if(node.data.prefix){
  528. newV = orgV.replace(new RegExp(node.data.prefix), '');
  529. }
  530. info.sheet.setValue(info.row, info.col, newV);
  531. }
  532. },
  533. onCellDoubleClick: function (sender, info){
  534. let project = projectObj.project;
  535. let node = project.mainTree.items[info.row];
  536. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  537. if(fieldName == 'marketUnitFee'){
  538. if(gljOprObj.hasComposition(node.data,true)){
  539. alert("当前人材机的市场价由组成物计算得出,不可直接修改。");
  540. return;
  541. }
  542. }
  543. },
  544. onColumnWidthChanged: function (sender, info) {
  545. projectObj.mainSpread.getActiveSheet().setColumnVisible(4, false);
  546. projectObj.mainSpread.getActiveSheet().setColumnVisible(4, true);
  547. projectObj.mainSpread.refresh();
  548. projectObj.mainSpread.repaint();
  549. },
  550. mainSpreadEditEnded: function (sender, info) {
  551. let project = projectObj.project;
  552. let node = project.mainTree.items[info.row];
  553. console.log( project.withinBillsLocked(node));
  554. project.withinBillsLocked(node);
  555. let colSetting = projectObj.mainController.setting.cols[info.col];
  556. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  557. // 检查输入类型等
  558. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  559. projectObj.updateCellValue(node, value, colSetting,info.editingText);
  560. // 自动行高
  561. const autoHeight = project.property.displaySetting.autoHeight;
  562. if (autoHeight) {
  563. projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
  564. }
  565. },
  566. msClipboardChanged: function (sender, info) {
  567. let colSettings = projectObj.mainController.setting.cols;
  568. let cDatas = sheetCommonObj.getTableData(info.sheet, colSettings);
  569. sheetCommonObj.copyTextToClipboard(cDatas);
  570. return;
  571. },
  572. mainSpreadRangeChanged: function (sender, info) {
  573. let project = projectObj.project, setting = projectObj.mainController.setting;
  574. let changedObj = projectObj.checkSpreadChangedCells(info);
  575. let refreshNodes = [];
  576. for(let row of changedObj.refreshRows){
  577. refreshNodes.push(project.mainTree.items[row]);
  578. }
  579. let updateRationCodes = [];//更新定额编码时要用同步的方式
  580. if(changedObj.changedCells.length > 0){
  581. for (let changedCell of changedObj.changedCells) {
  582. let node = project.mainTree.items[changedCell.row];
  583. let colSetting = setting.cols[changedCell.col];
  584. let value = projectObj.checkSpreadEditingText(changedCell.text, colSetting)
  585. if(colSetting.data.field=='code' && value != '' && node.sourceType == project.Ration.getSourceType()&&node.data.type==rationType.ration){//如果是更新定额的编码
  586. updateRationCodes.push({'node':node,value:value});
  587. }else {
  588. projectObj.updateCellValue(node, value, colSetting,changedCell.text);
  589. }
  590. }
  591. }
  592. if(updateRationCodes.length>0){
  593. project.Ration.updateRationCodes(updateRationCodes);
  594. }
  595. if(refreshNodes.length > 0){
  596. projectObj.mainController.refreshTreeNode(refreshNodes);
  597. }
  598. },
  599. checkMainSpread: function () {
  600. if (!this.mainSpread) {
  601. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  602. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
  603. this.mainSpread.getActiveSheet().name('mainSheet');
  604. this.mainSpread.getActiveSheet().options.isProtected = true;
  605. }
  606. },
  607. refreshMainSpread: function () {
  608. if (this.mainSpread) {
  609. this.mainSpread.refresh();
  610. }
  611. },
  612. loadProjectData: function () {
  613. var that = this;
  614. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  615. let startTime = +new Date();
  616. console.log("开始加载-----"+startTime);
  617. $.bootstrapLoading.start();
  618. this.project.loadDatas(function (err) {
  619. let mTime = +new Date();
  620. console.log(`get data时间——${mTime - startTime}`);
  621. //快速列设置
  622. if(!colSettingObj.getVisible('itemCharacterText') && !colSettingObj.getVisible('jobContentText')){
  623. switchTznrHtml(true);
  624. }
  625. if(colSettingObj.getVisible('itemCharacterText') && colSettingObj.getVisible('jobContentText')){
  626. switchTznrHtml(false);
  627. }
  628. if (!err) {
  629. that.project.projectGLJ.calcQuantity(true);//计算分部分项和技术措施项目消耗量;
  630. gljCol.initGljCol(that.project.projSetting.glj_col?that.project.projSetting.glj_col.showAdjustPrice:false);
  631. subObj.initSubSpread();//初始化主界面下方的表格
  632. let quantityTime = +new Date();
  633. console.log(`计算quantity时间——${quantityTime - mTime}`);
  634. that.project.property = projectInfoObj.projectInfo.property;
  635. //that.project.calcProgram.compileAllTemps();
  636. that.project.calcBase.init(that.project);
  637. // that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
  638. // that.project.initCalcFields();
  639. let str = JSON.stringify(that.project.projSetting.main_tree_col);
  640. that.project.projSetting.mainGridSetting = JSON.parse(str);
  641. that.project.projSetting.mainGridSetting.frozenCols = 4;
  642. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
  643. that.project.projSetting.mainGridSetting.setAutoFitRow = MainTreeCol.getEvent("setAutoFitRow");
  644. that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
  645. col.data.splitFields = col.data.field.split('.');
  646. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  647. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  648. }
  649. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  650. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  651. }
  652. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  653. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  654. col.data.cellType = getCellType;
  655. }
  656. // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  657. // col.data.decimal = that.project.getDecimal(col.data.digit);
  658. // col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  659. // }
  660. if (col.data.field === 'code') {
  661. col.data.formatter = '@';
  662. }
  663. col.setAutoHeight = MainTreeCol.getEvent("setAutoHeight");
  664. col.editChecking = MainTreeCol.getEvent("editChecking");
  665. // 根据配置设置自动行高,在这里先做个标记,然后对每个单元格单独配置
  666. if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
  667. col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
  668. col.data.autoHeight = true;
  669. col.showHint = true;
  670. }
  671. if(col.data.field ==='quantity'){
  672. col.showHint = true;
  673. }
  674. // 综合单价、综合合价,小数部分应补0对齐。 CSLAAAAA
  675. // if (col.data.field.hasSubStr("common")){
  676. if (col.data.field.hasSubStr(".totalFee"))
  677. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, true);
  678. else if (col.data.field.hasSubStr(".unitFee"))
  679. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, true);
  680. // }
  681. });
  682. let startShowTime = +new Date();
  683. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
  684. that.mainController.showTreeData();
  685. let endShowTime = +new Date();
  686. console.log(`show data时间——${endShowTime - startShowTime}`);
  687. that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
  688. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
  689. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
  690. setTimeout(function () {
  691. that.mainSpread.getActiveSheet().startEdit();//这两句需要挺多时间,而又需要在editend 事件前触发,而这些又不影响计算,所以这里用异步的方法
  692. that.mainSpread.getActiveSheet().endEdit();
  693. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  694. },100);
  695. that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);
  696. that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
  697. that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
  698. that.mainSpread.bind(GC.Spread.Sheets.Events.EditStarting, that.mainSpreadEditStarting);
  699. that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
  700. that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, that.msClipboardChanged);
  701. that.mainSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, that.onButtonClick);
  702. that.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, that.onCellDoubleClick);
  703. that.mainSpread.bind(GC.Spread.Sheets.Events.ColumnWidthChanged, that.onColumnWidthChanged);
  704. //let loadOtherStartTime = +new Date();
  705. if(!projectReadOnly){
  706. that.loadMainSpreadContextMenu();
  707. }
  708. that.loadFocusLocation();
  709. socketObject.connect();//连接socket服务器
  710. let endTime = +new Date();
  711. console.log(`其它时间——${endTime - endShowTime}`);
  712. console.log("加载完成-----"+endTime);
  713. console.log(`时间——${endTime - startTime}`);
  714. that.project.projectMarkChecking();//是否需要重新进行造价计算
  715. installationFeeObj.engineeringTypeChecking();//检查是否安装工程
  716. autoFlashHeight();
  717. projectObj.refreshMainSpread();
  718. //定位到会话中的选项
  719. let mainTabFocus = sessionStorage.getItem('mainTab') ? sessionStorage.getItem('mainTab') : '#tab_zaojiashu';
  720. $(`${mainTabFocus}`).click();
  721. if(projectReadOnly){
  722. disableSpread(that.mainSpread);
  723. }
  724. $.bootstrapLoading.end();
  725. }
  726. else {
  727. }
  728. });
  729. },
  730. loadMainSpreadContextMenu: function () {
  731. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  732. $.contextMenu({
  733. selector: '#billsSpread',
  734. build: function ($trigger, e) {
  735. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  736. controller.setTreeSelected(controller.tree.items[target.row]);
  737. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  738. },
  739. items: {
  740. "insertRootBill": {
  741. name: "插入大项费用",
  742. icon: 'fa-sign-in',
  743. disabled: function () {
  744. return projectObj.project.isBillsLocked() && project.withinBillsLocked(project.mainTree.selected);
  745. //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  746. },
  747. callback: function (key, opt) {
  748. ProjectController.addRootBill(project, controller);
  749. },
  750. visible: function(key, opt){
  751. return project.mainTree.selected&&project.mainTree.selected.parent==null;
  752. }
  753. },
  754. "insertFB": {
  755. name: "插入分部",
  756. icon: 'fa-sign-in',
  757. disabled: function () {
  758. let selected = project.mainTree.selected;
  759. if(projectObj.project.isBillsLocked()== false&&selected&&selected.sourceType==project.Bills.getSourceType()){
  760. if(selected.data.type==billType.FB){
  761. return false;
  762. }
  763. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  764. if(selected.children.length>0){
  765. return selected.children[0].data.type==billType.FX ||selected.children[0].data.type==billType.BX;//焦点行是分部分项工程,且子项是分项或补项
  766. }else {
  767. return false
  768. }
  769. }
  770. }
  771. return true;//除了清单,其它类型都只读
  772. },
  773. callback: function (key, opt) {
  774. ProjectController.addFB(project, controller);
  775. },
  776. visible: function(key, opt){
  777. if(project.mainTree.selected){
  778. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  779. }else {
  780. return false;
  781. }
  782. }
  783. },
  784. "insertFX": {
  785. name: "插入分项",
  786. icon: 'fa-sign-in',
  787. disabled: function () {
  788. let selected = project.mainTree.selected;
  789. if(projectObj.project.isBillsLocked()== false&& selected&&selected.sourceType==project.Bills.getSourceType()){
  790. if(selected.data.type==billType.FX||selected.data.type==billType.BX){//焦点行是分项,有效显示
  791. return false
  792. }
  793. if(selected.data.type==billType.FB){//点行是分部,
  794. if(selected.children.length>0){//且有子项,子项是分部,灰显。
  795. return selected.children[0].data.type == billType.FB
  796. }else {
  797. return false;
  798. }
  799. }
  800. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  801. if(selected.children.length>0){
  802. return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程,且子项是分部时灰显
  803. }else {
  804. return false
  805. }
  806. }
  807. }
  808. return true;//除了清单,其它类型都只读
  809. },
  810. callback: function (key, opt) {
  811. ProjectController.addFX(project, controller);
  812. },
  813. visible: function(key, opt){
  814. if(project.mainTree.selected){
  815. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  816. }else {
  817. return false;
  818. }
  819. }
  820. },
  821. "insertBills": {
  822. name: "插入清单",
  823. icon: 'fa-sign-in',
  824. disabled: function () {
  825. let selected = project.mainTree.selected;
  826. if(!(projectObj.project.isBillsLocked()== true && project.withinBillsLocked(selected)) && selected && selected.sourceType === project.Bills.getSourceType()){
  827. return false
  828. }
  829. return true;
  830. },
  831. callback: function (key, opt) {
  832. if(project.mainTree.selected.data.type == billType.DXFY){
  833. if(project.mainTree.selected.data.calcBase&&project.mainTree.selected.data.calcBase!=""){
  834. alert("当前有基数计算不能插入子项。");
  835. return;
  836. }
  837. }
  838. ProjectController.addBills(project, controller);
  839. },
  840. visible: function(key, opt){
  841. if(project.mainTree.selected){
  842. return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;
  843. }else {
  844. return false;
  845. }
  846. }
  847. },
  848. "insertRation": {
  849. name: "插入定额",
  850. icon: 'fa-sign-in',
  851. disabled: function () {
  852. var selected = project.mainTree.selected;
  853. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  854. },
  855. callback: function (key, opt) {
  856. project.Ration.addNewRation(null,rationType.ration);
  857. // ProjectController.addRation(project, controller, rationType.ration);
  858. },
  859. visible: function(key, opt){
  860. var selected = project.mainTree.selected;
  861. return canInsertRationNode(selected);
  862. }
  863. },
  864. "insertLJ": {
  865. name: "插入量价",
  866. icon: 'fa-sign-in',
  867. disabled: function () {
  868. var selected = project.mainTree.selected;
  869. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  870. },
  871. callback: function (key, opt) {
  872. project.Ration.addNewRation(null,rationType.volumePrice);
  873. // ProjectController.addRation(project, controller, rationType.volumePrice);
  874. },
  875. visible: function(key, opt){
  876. var selected = project.mainTree.selected;
  877. if(selected){
  878. return canInsertRationNode(selected);
  879. }
  880. return false;
  881. }
  882. },
  883. "insertGLJ": {
  884. name: "插入人材机",
  885. icon: 'fa-sign-in',
  886. disabled: function () {
  887. var selected = project.mainTree.selected;
  888. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  889. },
  890. callback: function (key, opt) {
  891. var selected = project.mainTree.selected;
  892. if(selected.sourceType == ModuleNames.bills){
  893. if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
  894. if(selected.data.calcBase&&selected.data.calcBase!=""){
  895. alert("当前有基数计算不能插入子项。");
  896. return;
  897. }
  898. }
  899. }
  900. getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
  901. },
  902. visible: function(key, opt){
  903. var selected = project.mainTree.selected;
  904. if(selected){
  905. return canInsertRationNode(selected);
  906. }
  907. return false;
  908. }
  909. },
  910. "calc_installation_fee": {
  911. name: "计取安装费用",
  912. icon: 'fa-sign-in',
  913. disabled: function () {
  914. return false;
  915. },
  916. callback: function (key, opt) {
  917. installationFeeObj.showCalcInstallSettingDiv();
  918. },
  919. visible: function(key, opt){
  920. let engineering = projectInfoObj.projectInfo.property.engineering;
  921. return engineering==engineeringType.BUILD_IN;
  922. }
  923. },
  924. "spr1": '--------',
  925. "delete": {
  926. name: '删除',
  927. icon: 'fa-remove',
  928. disabled: function () {
  929. return !ifCanDelete();
  930. },
  931. callback: function () {
  932. var selected = project.mainTree.selected;
  933. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  934. project.Bills.deleteSelectedNode();
  935. }else {
  936. $("#delete_row").modal({show:true});//弹出删除提示框;
  937. }
  938. }
  939. },
  940. "spr2":'--------',
  941. "calculateAll_RationContent": {
  942. name: '造价计算',
  943. callback: function () {
  944. project.calcProgram.calcAllNodesAndSave();
  945. }
  946. },
  947. "spr2":'--------',
  948. "copyBlock": {
  949. name: '复制整块',
  950. icon: 'fa-copy',
  951. disabled: function () {
  952. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  953. let firstNode = projectObj.project.mainTree.items[selection.row];//当多选的情况,用mainTree.selected判断不正确,要用第一个选中的节点
  954. for(let i = 0;i< selection.rowCount;i++){ //多选的时候判断所有与第一个节点同级的节点
  955. let temNode = projectObj.project.mainTree.items[selection.row + i];
  956. if(firstNode.getParentID() == temNode.getParentID()){
  957. if(BlockController.copyBtnDisable(temNode) == true){
  958. return true;
  959. }
  960. }
  961. }
  962. return false;
  963. },
  964. callback: function () {
  965. $.bootstrapLoading.start();
  966. //let selected = project.mainTree.selected;
  967. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  968. setTimeout(function () {
  969. BlockController.copyBlock(selections[0]);
  970. $.bootstrapLoading.end();
  971. },100)
  972. }
  973. },
  974. "spr2":'--------',
  975. "pasteBlock": {
  976. name: '粘贴整块',
  977. icon: 'fa-paste',
  978. disabled: function (){
  979. return BlockController.pasteBtnDisable(project.mainTree.selected);
  980. },
  981. callback: function () {
  982. BlockController.pasteBlock(project.mainTree.selected);
  983. }
  984. },
  985. "editEngineer": {
  986. name: '编辑工程内容',
  987. icon: 'fa-edit',
  988. visible: function(key, opt){
  989. return project.Bills.isEngineerEst(project.mainTree.selected);//当焦点行是“专业工程暂估价”时,右键可见并有效。
  990. },
  991. callback: function () {
  992. let node = project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.ENGINEERING_ESITIMATE);
  993. if(node){
  994. projectObj.editContent(node,'engineeringContent');
  995. }
  996. }
  997. },
  998. "editService": {
  999. name: '编辑服务内容',
  1000. icon: 'fa-edit',
  1001. visible: function(key, opt){
  1002. return project.Bills.isTotalService(project.mainTree.selected);//当焦点行是“总承包服务费”时,右键可见并有效。
  1003. },
  1004. callback: function () {
  1005. let node = project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.TURN_KEY_CONTRACT);
  1006. if(node){
  1007. projectObj.editContent(node,'serviceContent');
  1008. }
  1009. }
  1010. },
  1011. "editAccording": {
  1012. name: '编辑签证及索赔依据',
  1013. icon: 'fa-edit',
  1014. visible: function(key, opt){
  1015. return project.Bills.isClaimVisa(project.mainTree.selected);//当焦点行是“签证及索赔计价”时,右键可见并有效。
  1016. },
  1017. callback: function () {
  1018. let node = project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.CLAIM_VISA);
  1019. if(node){
  1020. projectObj.editContent(node,'claimVisa');
  1021. }
  1022. }
  1023. }
  1024. }
  1025. });
  1026. },
  1027. // 计算node及node的所有父项
  1028. converseCalculateBills: function (node) {
  1029. /* if (node) {
  1030. let calc = new BillsCalcHelper(this.project);
  1031. calc.calcNode(node, true);
  1032. let cur = node, nodes = [];
  1033. while (cur) {
  1034. nodes.push(cur);
  1035. cur = cur.parent;
  1036. }
  1037. this.mainController.refreshTreeNode(nodes, false);
  1038. this.project.Bills.updateNodes(nodes, true);
  1039. calc = null;
  1040. }*/
  1041. projectObj.project.calcProgram.calcAndSave(node);
  1042. },
  1043. // 计算全部清单
  1044. /* calculateAll: function () {
  1045. let calc = new BillsCalcHelper(this.project);
  1046. calc.calcAll();
  1047. this.mainController.showTreeData();
  1048. this.project.Bills.updateAll();
  1049. calc = null;
  1050. }*/
  1051. // 获取上次退出时的焦点位置
  1052. loadFocusLocation: function() {
  1053. const projectId = scUrlUtil.GetQueryString('project');
  1054. let row = getLocalCache('lastRow:' + projectId);
  1055. let col = getLocalCache('lastCol:' + projectId);
  1056. if(row == null || col == null){
  1057. row = 0;
  1058. col = 0;
  1059. }
  1060. row = parseInt(row);
  1061. col = parseInt(col);
  1062. const sheet = this.mainSpread.getActiveSheet();
  1063. sheet.setSelection(row, col, 1, 1);
  1064. this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
  1065. },
  1066. // 选中区域合计数字
  1067. amountAreaNumber: function(e, info) {
  1068. if (info.newSelections === undefined || info.newSelections.length <= 0) {
  1069. return false;
  1070. }
  1071. const selectedArea = info.newSelections[0];
  1072. const sheet = info.sheet;
  1073. if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
  1074. return false;
  1075. }
  1076. //获取最左最右坐标
  1077. let maxCell = {row: selectedArea.row, col: selectedArea.col + selectedArea.colCount};
  1078. let maxCellX = sheet.getCellRect(maxCell.row, maxCell.col).x ? sheet.getCellRect(maxCell.row, maxCell.col).x : sheet.getCellRect(maxCell.row, maxCell.col - 1).x;
  1079. let minCell = {row: selectedArea.row, col: selectedArea.col};
  1080. let minCellX = sheet.getCellRect(minCell.row, minCell.col).x ? sheet.getCellRect(minCell.row, minCell.col).x : sheet.getCellRect(minCell.row, minCell.col + 1).x;
  1081. // 获取鼠标位置
  1082. let x = window.event.clientX;
  1083. let y = window.event.clientY;
  1084. // 匹配数字或小数
  1085. const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
  1086. // 小数点最高位数
  1087. let max = 0;
  1088. let total = 0;
  1089. let counter = 0;
  1090. for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
  1091. for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
  1092. const value = sheet.getCell(row, col).text();
  1093. if (!regular.test(value)) {
  1094. continue;
  1095. }
  1096. counter++;
  1097. // 获取当前数据小数位数
  1098. let pointPosition = value.toString().indexOf(".");
  1099. pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
  1100. const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
  1101. max = current > max ? current : max;
  1102. total += parseFloat(value);
  1103. }
  1104. }
  1105. // 如果不为0则悬浮显示
  1106. if (total > 0 && counter > 1) {
  1107. const div = $('<div id="total-tips"><p>合计: <input type="text" id="total" readonly="readonly" style="border: none;"/></p><p><a href="javascript:void(0);">复制</a></p></div>');
  1108. div.css({
  1109. position: "absolute",
  1110. border: "1px #C0C0C0 solid",
  1111. background: "#fff",
  1112. boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
  1113. });
  1114. div.children("p").css({
  1115. textAlign: "center",
  1116. padding: 8,
  1117. marginBottom: 2,
  1118. });
  1119. div.children("p").first().css({
  1120. borderBottom: "1px #C0C0C0 solid"
  1121. });
  1122. const totalString = total.toFixed(max);
  1123. // input长度
  1124. const inputWidth = totalString.length * 8;
  1125. // 计算是否会超出显示范围
  1126. const baseWidth = 48;
  1127. const baseHeight = 81;
  1128. const canvasWidth = $("#billsSpreadvp_vp").width();
  1129. const canvasHeight = $("#billsSpreadvp_vp").height();
  1130. //x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
  1131. x = maxCellX + baseWidth + inputWidth > canvasWidth ? minCellX - baseWidth - inputWidth : maxCellX + baseWidth;
  1132. y = y + baseHeight > canvasHeight ? y - baseHeight : y;
  1133. //test
  1134. let testT = sheet.getParent().hitTest(x, y);
  1135. //test
  1136. div.css({
  1137. left: x,
  1138. top: y,
  1139. });
  1140. div.children().children("#total").width(inputWidth).val(totalString);
  1141. $("body").append(div);
  1142. // 用于判断是否要关闭窗体
  1143. setTimeout(function() {
  1144. isTotalShowing = true;
  1145. }, 200);
  1146. };
  1147. },
  1148. /*amountAreaNumber: function(e, info) {
  1149. if (info.newSelections === undefined || info.newSelections.length <= 0) {
  1150. return false;
  1151. }
  1152. const selectedArea = info.newSelections[0];
  1153. const sheet = info.sheet;
  1154. if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
  1155. return false;
  1156. }
  1157. // 获取鼠标位置
  1158. let x = window.event.clientX;
  1159. let y = window.event.clientY;
  1160. // 匹配数字或小数
  1161. const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
  1162. // 小数点最高位数
  1163. let max = 0;
  1164. let total = 0;
  1165. let counter = 0;
  1166. for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
  1167. for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
  1168. const value = sheet.getCell(row, col).text();
  1169. if (!regular.test(value)) {
  1170. continue;
  1171. }
  1172. counter++;
  1173. // 获取当前数据小数位数
  1174. let pointPosition = value.toString().indexOf(".");
  1175. pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
  1176. const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
  1177. max = current > max ? current : max;
  1178. total += parseFloat(value);
  1179. }
  1180. }
  1181. // 如果不为0则悬浮显示
  1182. if (total > 0 && counter > 1) {
  1183. const div = $('<div id="total-tips"><p>合计: <input type="text" id="total" readonly="readonly" style="border: none;"/></p><p><a href="javascript:void(0);">复制</a></p></div>');
  1184. div.css({
  1185. position: "absolute",
  1186. border: "1px #C0C0C0 solid",
  1187. background: "#fff",
  1188. boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
  1189. });
  1190. div.children("p").css({
  1191. textAlign: "center",
  1192. padding: 8,
  1193. marginBottom: 2,
  1194. });
  1195. div.children("p").first().css({
  1196. borderBottom: "1px #C0C0C0 solid"
  1197. });
  1198. const totalString = total.toFixed(max);
  1199. // input长度
  1200. const inputWidth = totalString.length * 8;
  1201. // 计算是否会超出显示范围
  1202. const baseWidth = 48;
  1203. const baseHeight = 81;
  1204. const canvasWidth = $("#billsSpreadvp_vp").width();
  1205. const canvasHeight = $("#billsSpreadvp_vp").height();
  1206. x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
  1207. y = y + baseHeight > canvasHeight ? y - baseHeight : y;
  1208. //test
  1209. let testT = sheet.getParent().hitTest(x, y);
  1210. console.log(sheet.getCellRect(0, 0));
  1211. //test
  1212. div.css({
  1213. left: x,
  1214. top: y,
  1215. });
  1216. div.children().children("#total").width(inputWidth).val(totalString);
  1217. $("body").append(div);
  1218. // 用于判断是否要关闭窗体
  1219. setTimeout(function() {
  1220. isTotalShowing = true;
  1221. }, 200);
  1222. };
  1223. },*/
  1224. onButtonClick: function (e, info) {
  1225. let colSetting = projectObj.mainController.setting.cols[info.col];
  1226. let node = projectObj.project.mainTree.items[info.row];
  1227. let fieldName = colSetting.data.field;
  1228. if(fieldName == "isSubcontract"){
  1229. projectObj.onSubcontractClick(node);
  1230. }else if(fieldName == "isEstimate"){
  1231. projectObj.onIsEstimateClick(node,info);
  1232. }
  1233. },
  1234. onIsEstimateClick: function(node,info){
  1235. let checkboxValue = info.sheet.getCell(info.row, info.col).value();
  1236. let cell = info.sheet.getCell(info.row, info.col), newval = 0;
  1237. if (checkboxValue) {
  1238. newval = 0;
  1239. cell.value(newval);
  1240. } else {
  1241. newval = 1;
  1242. cell.value(newval);
  1243. }
  1244. if(MainTreeCol.readOnly.bills(node)){
  1245. projectObj.updateNodeField(node,newval,'isEstimate');
  1246. }else if(node.data.projectGLJID){//更新的是定额类型的工料机或者是显示在造价书页面的主材、设备
  1247. console.log(node);
  1248. let updateData = {id: node.data.projectGLJID, field: 'is_evaluate', value: newval};
  1249. projectObj.project.projectGLJ.pGljUpdate(updateData);
  1250. }
  1251. },
  1252. onSubcontractClick:function (node) {//点击分包费checkbox
  1253. if (node.data.isSubcontract) node.data.isSubcontract = false;
  1254. else node.data.isSubcontract = true;
  1255. node.changed = true;
  1256. projectObj.project.calcProgram.calcAndSave(node);
  1257. },
  1258. //根据节点获取行style(颜色、字体加粗)
  1259. getNodeColorStyle: function (sheet, node, tree) {
  1260. let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
  1261. let mapping = {DEFAULT: 'DEFAULT', SELECTED: 'SELECTED', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
  1262. FX: 'FX', BX: 'BX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
  1263. let styleMap = null;
  1264. tree?'':tree = this.project.mainTree;
  1265. //中文字段名,由于同一节点中,中文字体大小和数字字体大小不同
  1266. if(colorSetting == null){
  1267. return null;
  1268. }
  1269. let stringFields = [
  1270. 'code',
  1271. 'subType',
  1272. 'name',
  1273. 'unit',
  1274. 'itemCharacterText',
  1275. 'jobContentText',
  1276. 'adjustState',
  1277. 'calcBase',
  1278. 'programID',
  1279. 'ruleText'
  1280. ];
  1281. if(!isDef(node)){
  1282. return null;
  1283. }
  1284. //清单大类
  1285. if(node.sourceType === this.project.Bills.getSourceType()){
  1286. //大项费用
  1287. if(node.data.type === billType.DXFY){
  1288. styleMap = mapping.DXFY;
  1289. }
  1290. //分部
  1291. if(node.data.type === billType.FB){
  1292. styleMap = mapping.FB;
  1293. }
  1294. //分项
  1295. else if(node.data.type === billType.FX){
  1296. styleMap = mapping.FX;
  1297. }
  1298. //补项
  1299. else if(node.data.type === billType.BX){
  1300. styleMap = mapping.BX;
  1301. }
  1302. //清单
  1303. else if(node.data.type === billType.BILL){
  1304. //非叶子节点的清单
  1305. if(node.source.children.length > 0){
  1306. styleMap = mapping.UNLEAFBILL;
  1307. }
  1308. //未使用基数计算的叶子节点的清单
  1309. else if(node.source.children.length === 0 && (!isDef(node.data.calcBase) || node.data.calcBase === '')){
  1310. styleMap = mapping.UNCBBILL;
  1311. }
  1312. //使用基数计算的叶子节点的清单
  1313. else if(node.source.children.length === 0 && isDef(node.data.calcBase && node.data.calcBaseValue !== '')){
  1314. styleMap = mapping.CBBILL;
  1315. }
  1316. }
  1317. }
  1318. //定额下的主材、设备
  1319. else if(node.sourceType === this.project.ration_glj.getSourceType()){
  1320. styleMap = mapping.ZCSB;
  1321. }
  1322. else {
  1323. styleMap = mapping.DEFAULT;
  1324. }
  1325. let styleSetting = colorSetting[styleMap];
  1326. let defaultSetting = colorSetting[mapping.DEFAULT];
  1327. if(!isDef(styleSetting)){
  1328. return null;
  1329. }
  1330. let style = new GC.Spread.Sheets.Style();
  1331. //设置style属性
  1332. for(let attr in styleSetting){
  1333. if(attr !== 'stringFont' && attr !== 'numFont'){
  1334. style[attr] = styleSetting[attr] === 'default' || !isDef(styleSetting[attr]) ? defaultSetting[attr] : styleSetting[attr];
  1335. }
  1336. //暂时不开放字体设置,开放的话只能每个单元格进入此方法
  1337. /* else {
  1338. if(stringFields.indexOf(colSetting.data.field) > 0){
  1339. style.font = styleSetting.stringFont === 'default' || !isDef(styleSetting.stringFont) ? defaultSetting.stringFont : styleSetting.stringFont;
  1340. }
  1341. else {
  1342. style.font = styleSetting.numFont === 'default' || !isDef(styleSetting.numFont) ? defaultSetting.numFont : styleSetting.numFont;
  1343. }
  1344. }*/
  1345. }
  1346. //选中行-替换底色
  1347. if(node === tree.selected){
  1348. style.backColor = colorSetting[mapping.SELECTED]['backColor'];
  1349. }
  1350. style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1351. style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1352. style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1353. style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1354. return style;
  1355. },
  1356. //大项费用则字体加粗,String 15px, Number 13px
  1357. getBoldFontStyle: function (node, colSetting) {
  1358. let style = new GC.Spread.Sheets.Style();
  1359. if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
  1360. return null;
  1361. }
  1362. //备注暂无字段
  1363. let stringFields = [
  1364. 'code',
  1365. 'subType',
  1366. 'name',
  1367. 'unit',
  1368. 'itemCharacterText',
  1369. 'jobContentText',
  1370. 'adjustState',
  1371. 'calcBase',
  1372. 'programID',
  1373. 'ruleText'
  1374. ];
  1375. if(stringFields.indexOf(colSetting.data.field) > 0){
  1376. style.font = 'bold 15px Arial';
  1377. }
  1378. else {
  1379. style.font = 'bold 13px Arial';
  1380. }
  1381. return style;
  1382. },
  1383. //设置节点style
  1384. setNodesStyle: function (sheet, nodes,tree) {
  1385. let me = this;
  1386. TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
  1387. for(let node of nodes){
  1388. if(node && node.serialNo()!= -1){
  1389. sheet.getRange(node.serialNo(), -1, 1, -1).backColor(me.getNodeColorStyle(sheet, node,tree).backColor);
  1390. }
  1391. }
  1392. });
  1393. },
  1394. loadLockBillsButton:function () {
  1395. if(projectInfoObj.projectInfo.property.lockBills == true){
  1396. $("a[name='lockBills']").prop("title","解锁清单");
  1397. $("a[name='lockBills']").html('<i class="fa fa-unlock-alt" aria-hidden="true"></i> 解锁清单');
  1398. }else {
  1399. $("a[name='lockBills']").prop("title","锁定清单");
  1400. $("a[name='lockBills']").html('<i class="fa fa-lock" aria-hidden="true"></i> 锁定清单');
  1401. }
  1402. },
  1403. editContent:function (node,fieldID) {//右键编辑工程内容、服务内容、签证及索赔依据
  1404. let infoText = "请输入";
  1405. switch (fieldID){
  1406. case "engineeringContent":
  1407. infoText +='工程内容:';
  1408. break;
  1409. case "serviceContent":
  1410. infoText +='服务内容:';
  1411. break;
  1412. case "claimVisa":
  1413. infoText +='签证及索赔依据:';
  1414. break;
  1415. }
  1416. hintBox.valueBox(infoText, node.data[fieldID], function () {
  1417. let newValue = hintBox.value;
  1418. projectObj.updateNodeField(node,newValue,fieldID);
  1419. });
  1420. }
  1421. };
  1422. // 点击合计框中的复制
  1423. $("body").on("click", "#total-tips a", function() {
  1424. const totalElement = $(this).parent().siblings("p").find("#total");
  1425. totalElement.select();
  1426. document.execCommand("Copy");
  1427. $(this).text("已复制");
  1428. });
  1429. // 合计框点击其他位置关闭
  1430. let isTotalShowing = false;
  1431. $("body").on("click", function(e) {
  1432. if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
  1433. $("#total-tips").remove();
  1434. isTotalShowing = false;
  1435. }
  1436. });
  1437. $('#insert').click(function () {
  1438. var controller = projectObj.mainController, project = projectObj.project;
  1439. var selected = controller.tree.selected;
  1440. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  1441. ProjectController.addBills(project, controller);
  1442. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1443. ProjectController.addRation(project, controller, selected.data.type);
  1444. };
  1445. });
  1446. $('#delete').click(function () {
  1447. let project = projectObj.project;
  1448. let selected = project.mainTree.selected;
  1449. if(isSingleSelect()&&selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  1450. project.Bills.deleteSelectedNode();
  1451. }else {
  1452. $("#delete_row").modal({show:true});//弹出删除提示框;
  1453. }
  1454. });
  1455. $('#upLevel').click(function () {
  1456. var controller = projectObj.mainController, project = projectObj.project;
  1457. var selected = controller.tree.selected, orgParent = selected.parent;
  1458. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1459. project.Bills.upLevelBills(selected.source);
  1460. controller.upLevel();
  1461. controller.refreshTreeNode([orgParent]);
  1462. projectObj.project.calcProgram.calcNodesAndSave([selected,orgParent]);
  1463. }
  1464. });
  1465. $('#downLevel').click(function () {
  1466. var controller = projectObj.mainController, project = projectObj.project;
  1467. var selected = controller.tree.selected;
  1468. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1469. project.Bills.downLevelBills(selected.source);
  1470. controller.downLevel();
  1471. controller.refreshTreeNode([selected.parent]);
  1472. projectObj.converseCalculateBills(selected.parent);
  1473. }
  1474. });
  1475. $('#upMove').click(function () {
  1476. var controller = projectObj.mainController, project = projectObj.project;
  1477. var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;
  1478. if (selected.sourceType === project.Bills.getSourceType()) {
  1479. project.Bills.upMoveBills(selected.source);
  1480. controller.upMove();
  1481. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1482. project.Ration.changePos(selected.source, selected.preSibling.source);
  1483. controller.upMove();
  1484. };
  1485. });
  1486. $('#downMove').click(function () {
  1487. var controller = projectObj.mainController, project = projectObj.project;
  1488. var selected = controller.tree.selected, next, nextSerialNo;
  1489. if (selected) {
  1490. if (selected.sourceType === project.Bills.getSourceType()) {
  1491. project.Bills.downMoveBills(selected.source);
  1492. controller.downMove();
  1493. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1494. project.Ration.changePos(selected.source, selected.nextSibling.source);
  1495. controller.downMove();
  1496. };
  1497. }
  1498. });
  1499. $("a[name='lockBills']").click(function () {//
  1500. let lockBills = projectInfoObj.projectInfo.property.lockBills;
  1501. lockBills = !lockBills;
  1502. projectObj.project.updateLockBills(lockBills,function () {
  1503. var controller = projectObj.mainController, project = projectObj.project;
  1504. var selected = controller.tree.selected;
  1505. let nodes = _.filter(project.mainTree.items,{'sourceType':ModuleNames.bills});
  1506. controller.refreshTreeNode(nodes);
  1507. projectObj.mainController.setTreeSelected(selected);//触发树节点选中事件
  1508. projectObj.loadLockBillsButton();
  1509. if(!projectReadOnly){
  1510. pageCCOprObj.refreshRuleTools(lockBills);
  1511. }
  1512. });
  1513. });
  1514. $('#ZLFB_btn').click(function () {
  1515. zlfb_object.getSectionInfo();
  1516. });
  1517. //工料机库
  1518. $('#compleGljLib').click(function () {
  1519. let newTab = window.open('about:blank');
  1520. let newHref = '/complementaryGlj';
  1521. CommonAjax.get(newHref, [], function () {
  1522. newTab.location.href = newHref;
  1523. });
  1524. });
  1525. //显示至..
  1526. let displayLevel = function(nodes, depth, type){
  1527. let refreshNodes = [];
  1528. function getExpandedController(){
  1529. if(type === 'DXFY' || type === 'FB'){
  1530. if(type === 'FB'){
  1531. projectObj.project.mainTree.items[0].setExpanded(true);
  1532. refreshNodes.push(projectObj.project.mainTree.items[0]);
  1533. }
  1534. return function expandedControl(nodes, depth){
  1535. let bType = type === 'FB' ? billType.FB : billType.DXFY;
  1536. for(let node of nodes){
  1537. let nodeDepth = node.depth();
  1538. if(nodeDepth <= depth){
  1539. let expanded = nodeDepth === depth && !node.children[0] || nodeDepth < depth && node.children[0] && node.children[0].data.type === bType ? true : false;
  1540. node.setExpanded(expanded);
  1541. refreshNodes.push(node);
  1542. if(nodeDepth < depth){
  1543. expandedControl(node.children, depth);
  1544. }
  1545. }
  1546. }
  1547. }
  1548. }
  1549. else if(type === 'FX' || type === 'ZM' || type === 'ZD'){
  1550. return function expandedControl(nodes){
  1551. for(let node of nodes){
  1552. if(type !== 'FX' || node.sourceType === projectObj.project.Bills.getSourceType()){
  1553. let expanded = true;
  1554. if(type === 'FX'){
  1555. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType === projectObj.project.Bills.getSourceType() ? true : false;
  1556. }
  1557. else if(type === 'ZM'){
  1558. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType !== projectObj.project.ration_glj.getSourceType() ? true : false;
  1559. }
  1560. node.setExpanded(expanded);
  1561. refreshNodes.push(node);
  1562. expandedControl(node.children);
  1563. }
  1564. }
  1565. }
  1566. }
  1567. }
  1568. getExpandedController()(nodes, depth);
  1569. let sheet = projectObj.mainSpread.getActiveSheet();
  1570. TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
  1571. TREE_SHEET_HELPER.refreshNodesVisible(refreshNodes, projectObj.mainSpread.getActiveSheet(), true)
  1572. });
  1573. };
  1574. $('#displayDXFY').click(function () {
  1575. displayLevel(projectObj.project.mainTree.items, 0, 'DXFY')
  1576. });
  1577. //显示至一级分部
  1578. $('#displayFB1').click(function () {
  1579. displayLevel(projectObj.project.mainTree.items[0].children, 1, 'FB');
  1580. });
  1581. //二级分部
  1582. $('#displayFB2').click(function () {
  1583. displayLevel(projectObj.project.mainTree.items[0].children, 2, 'FB');
  1584. });
  1585. //三级分部
  1586. $('#displayFB3').click(function () {
  1587. displayLevel(projectObj.project.mainTree.items[0].children, 3, 'FB');
  1588. });
  1589. //四级分部
  1590. $('#displayFB4').click(function () {
  1591. displayLevel(projectObj.project.mainTree.items[0].children, 4, 'FB');
  1592. });
  1593. //分项
  1594. $('#displayFX').click(function () {
  1595. displayLevel(projectObj.project.mainTree.items, null, 'FX');
  1596. });
  1597. //子目
  1598. $('#displayZM').click(function () {
  1599. displayLevel(projectObj.project.mainTree.items, null, 'ZM');
  1600. });
  1601. //最底层
  1602. $('#displayZD').click(function () {
  1603. displayLevel(projectObj.project.mainTree.roots, null, 'ZD');
  1604. });
  1605. $('#poj-set').on('show.bs.modal', function () {
  1606. let setCalcFlag = function (obj, val, curFlag) {
  1607. obj.val(val);
  1608. if (val === curFlag) {
  1609. obj.prop('checked', true);
  1610. } else {
  1611. obj.prop('checked', false);
  1612. }
  1613. }
  1614. if (projectObj.project) {
  1615. let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
  1616. let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
  1617. setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
  1618. setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
  1619. setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
  1620. setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
  1621. setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
  1622. setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
  1623. let showAdjustPrice = projectObj.project.projSetting.glj_col?projectObj.project.projSetting.glj_col.showAdjustPrice:false;
  1624. showAdjustPrice === true ? $("#tab_poj-settings-6").show():$("#tab_poj-settings-6").hide();
  1625. projDisplayView.init();
  1626. calcOptions.init();
  1627. }
  1628. });
  1629. //恢复默认列设置
  1630. $('#recColSetting').click(function () {
  1631. let libID = projectObj.project.property.colLibID ? projectObj.project.property.colLibID : null;
  1632. if(!libID){
  1633. alert('项目没有绑定标准列设置');
  1634. return;
  1635. }
  1636. $(this).addClass('disabled');
  1637. CommonAjax.post('/project/getDefaultColSetting', {libID: libID}, function (rstData) {
  1638. if(!rstData || rstData.length === 0){
  1639. alert('标准列设置没有数据');
  1640. $('#recColSetting').removeClass('disabled');
  1641. return;
  1642. }
  1643. let sheet = colSettingObj.settingSpread.getActiveSheet();
  1644. SheetDataHelper.massOperationSheet(sheet, function () {
  1645. for(let row = 0; row < sheet.getRowCount(); row++){
  1646. sheet.setValue(row, 0, rstData.main_tree_col.cols[row].visible);
  1647. }
  1648. });
  1649. $('#recColSetting').removeClass('disabled');
  1650. }, function () {
  1651. $('#recColSetting').removeClass('disabled');
  1652. });
  1653. });
  1654. $('#property_ok').click(function () {
  1655. let project = projectObj.project,
  1656. projectID = project.ID(),
  1657. properties = {},
  1658. labourCoes = {},
  1659. rations = [],
  1660. bills = [],
  1661. mixDatas = {
  1662. projectID: projectID,
  1663. updateType: 'update',
  1664. properties: properties,
  1665. labourCoes: labourCoes,
  1666. rations: rations,
  1667. bills: bills
  1668. },
  1669. reCalcBills = false,
  1670. reCalcRations = false;
  1671. let b = parseInt($("input[name='calcFlag']:checked").val());
  1672. if (b !== project.property.billsCalcMode) {
  1673. properties['property.billsCalcMode'] = b;
  1674. project.property.billsCalcMode = b;
  1675. reCalcBills = true;
  1676. };
  1677. let zg = parseInt($("input[name='zangu']:checked").val());
  1678. if (zg !== project.property.zanguCalcMode) {
  1679. properties['property.zanguCalcMode'] = zg;
  1680. project.property.zanguCalcMode = zg;
  1681. reCalcRations = true;
  1682. };
  1683. //基本信息
  1684. if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
  1685. let saveData = basicInfoView.toSaveDatas(basicInfoView.datas);
  1686. projectObj.project.property.basicInformation = saveData;
  1687. properties['property.basicInformation'] = saveData;
  1688. }
  1689. //工程特征
  1690. if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
  1691. let saveData = projFeatureView.toSaveDatas(projFeatureView.datas);
  1692. projectObj.project.property.projectFeature = saveData;
  1693. properties['property.projectFeature'] = saveData;
  1694. }
  1695. //清单工程量精度
  1696. let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
  1697. if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
  1698. billsQuanDecimal.datas = newBillsDecimalDatas;
  1699. reCalcBills = true;
  1700. properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
  1701. }
  1702. //小数位数
  1703. let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
  1704. if(toUpdateDecimal(decimalObj, updateDecimal)) {
  1705. let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
  1706. setDecimal(decimalObj, updateDecimal);
  1707. if (frChanged) {
  1708. project.calcProgram.compileAllTemps()
  1709. }
  1710. reCalcRations = true;
  1711. reCalcBills = true;
  1712. properties['property.decimal'] = updateDecimal;
  1713. }
  1714. // 呈现选项
  1715. projDisplayView.updateChecking(properties);
  1716. //列设置(独立逻辑,只是通过项目属性确定按钮触发)
  1717. if(colSettingObj.dataChanged()){
  1718. colSettingObj.updateColSetting();
  1719. }
  1720. if(calcOptions.updateChecking(properties)){
  1721. reCalcRations = true;
  1722. }
  1723. // 人工系数
  1724. if (labourCoeView.needSave()){
  1725. let libID = $("#std_labour_coe_files").children("option:selected").val();
  1726. let libName = $("#std_labour_coe_files").children("option:selected").text();
  1727. labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
  1728. project.labourCoe.refreshData(labourCoes.updateData); // 全编译所用到的人工系数来自project.labourCoe,所以必须先刷新project.labourCoe
  1729. project.calcProgram.compileAllTemps();
  1730. reCalcRations = true;
  1731. reCalcBills = true;
  1732. };
  1733. // 重新计算树节点
  1734. let changedNodes = [];
  1735. if (reCalcRations) // 定额动,全部计算。算完先不存储,和后面的数据一起提交,一次通讯。
  1736. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
  1737. else if (reCalcBills) // 清单动,可以只计算清单。
  1738. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
  1739. if (changedNodes.length > 0) {
  1740. for (let node of changedNodes){
  1741. let data = calcTools.cutNodeForSave(node);
  1742. if (node.sourceType == 'ration') rations.push(data)
  1743. else if (node.sourceType == 'bills') bills.push(data);
  1744. };
  1745. };
  1746. // for test.
  1747. /* console.log(mixDatas);
  1748. return; */
  1749. function hasMixData() {
  1750. return Object.keys(mixDatas.properties).length > 0 ||
  1751. mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
  1752. }
  1753. function needToReload(mixDatas){
  1754. if(Object.keys(mixDatas.labourCoes).length > 0){
  1755. return true;
  1756. }
  1757. if(Object.keys(mixDatas.properties).length > 0){
  1758. if(mixDatas.properties.hasOwnProperty('property.billsCalcMode') ||
  1759. mixDatas.properties.hasOwnProperty('property.zanguCalcMode') ||
  1760. mixDatas.properties.hasOwnProperty('property.calcOptions')||
  1761. mixDatas.properties.hasOwnProperty('property.billsQuantityDecimal')||
  1762. mixDatas.properties.hasOwnProperty('property.decimal')||
  1763. mixDatas.properties.hasOwnProperty('property.displaySetting')){
  1764. return true;
  1765. }
  1766. }
  1767. return false;
  1768. }
  1769. if(hasMixData()){
  1770. CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
  1771. //需要重载页面
  1772. if(needToReload(mixDatas)){
  1773. window.location.href = '/main?project=' + projectID;
  1774. }
  1775. else{
  1776. if(mixDatas.properties.hasOwnProperty('property.basicInformation')){
  1777. basicInfoView.orgDatas = basicInfoView.toViewDatas(mixDatas.properties['property.basicInformation']);
  1778. }
  1779. if(mixDatas.properties.hasOwnProperty('property.projectFeature')){
  1780. projFeatureView.orgDatas = projFeatureView.toViewDatas(mixDatas.properties['property.projectFeature']);
  1781. }
  1782. }
  1783. });
  1784. }
  1785. });
  1786. function testShow() {
  1787. var controller = projectObj.mainController, project = projectObj.project;
  1788. var selected = controller.tree.selected, parent = selected.parent;
  1789. var showinfo = "<label>确认要删除当前选中行吗?</label>";
  1790. var showN = false;
  1791. var cancelText = "否";
  1792. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
  1793. if(isSingleSelect()||selectionChecking()){
  1794. showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
  1795. showN = true;
  1796. cancelText = "取消";
  1797. }
  1798. }
  1799. $('#delete_showinfo').html(showinfo);
  1800. showN==true? $('#deleteN').show():$('#deleteN').hide();
  1801. $('#deleteCancel').text(cancelText);
  1802. function selectionChecking() {
  1803. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  1804. let mainTreeMap = {};
  1805. for(let i =0;i<selection.rowCount;i++){
  1806. let tem_node = controller.tree.items[selection.row+i];
  1807. if(i==0){//第一个直接添加;
  1808. mainTreeMap[tem_node.getID()] = tem_node;
  1809. }else {
  1810. project.Bills.setNodeToMap(tem_node,mainTreeMap);
  1811. }
  1812. }
  1813. let nodes = changeMapToArray(mainTreeMap);
  1814. if(nodes.length==1){
  1815. return true
  1816. }
  1817. return false;
  1818. }
  1819. }
  1820. $('#delete_row').on('show.bs.modal', function (e) {//这里用show,在shown之前调用,页面不会出现按钮闪现的情况
  1821. var controller = projectObj.mainController, project = projectObj.project;
  1822. var selected = controller.tree.selected, parent = selected.parent;
  1823. var showinfo = "<label>确认要删除当前选中行吗?</label>";
  1824. var showN = false;
  1825. var cancelText = "否";
  1826. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
  1827. if(isSingleSelect()||selectionChecking()){
  1828. showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
  1829. showN = true;
  1830. cancelText = "取消";
  1831. }
  1832. }
  1833. $('#delete_showinfo').html(showinfo);
  1834. showN==true? $('#deleteN').show():$('#deleteN').hide();
  1835. $('#deleteCancel').text(cancelText);
  1836. function selectionChecking() {
  1837. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  1838. let mainTreeMap = {}, nodes = [];
  1839. for(let i =0;i<selection.rowCount;i++){
  1840. let tem_node = controller.tree.items[selection.row+i];
  1841. if(i==0){//第一个直接添加;
  1842. mainTreeMap[tem_node.getID()] = tem_node;
  1843. }else {
  1844. project.Bills.setNodeToMapAndArray(tem_node,mainTreeMap,nodes);
  1845. }
  1846. }
  1847. if(nodes.length==1){
  1848. return true
  1849. }
  1850. return false;
  1851. }
  1852. });
  1853. function changeMapToArray(map) {
  1854. let newArray = [];
  1855. for(let key in map){
  1856. newArray.push(map[key]);
  1857. }
  1858. return newArray;
  1859. }
  1860. $('#deleteY').click(function () { //正常删除,级联删除子项
  1861. let project = projectObj.project;
  1862. project.Bills.deleteSelectedNodes();
  1863. /*if(isSingleSelect()){
  1864. project.Bills.deleteSelectedNode();//这个方法不用了,会出现异步删除干净的问题
  1865. }else {
  1866. project.Bills.deleteSelectedNodes();
  1867. }*/
  1868. });
  1869. $('#deleteN').click(function () {//不删除子项
  1870. let controller = projectObj.mainController, project = projectObj.project;
  1871. let selected = controller.tree.selected, parent = selected.parent;
  1872. if(selected){
  1873. let preNode = selected.preSibling;
  1874. let nextNode = selected.nextSibling;
  1875. if(preNode){//有前兄弟
  1876. if(preNode.children.length>0&&preNode.children[0].data.type != selected.children[0].data.type){//并且前兄弟子项和焦点行子项类别不同。
  1877. alert("删除分部会导致分部和分项同级,不允许该操作!");
  1878. return;
  1879. }
  1880. }else if(nextNode){
  1881. if(nextNode.data.type != selected.children[0].data.type){
  1882. alert("删除分部会导致分部和分项同级,不允许该操作! ");
  1883. return;
  1884. }
  1885. }
  1886. project.Bills.singleDeleteBills(selected,controller);
  1887. }
  1888. });
  1889. function isSingleSelect() {//是否选中造价书中的单行
  1890. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1891. if (selections[0].rowCount == 1) {
  1892. return true;
  1893. }
  1894. return false;
  1895. }
  1896. function ifCanDelete() {
  1897. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1898. let tree = projectObj.project.mainTree;
  1899. let selected = projectObj.project.mainTree.selected;
  1900. if(selections[0].rowCount==1){//选中单行
  1901. return canDelete(selected);
  1902. }else {
  1903. return canDelete_m(selections[0]);
  1904. }
  1905. function canDelete(node,m_selection) {
  1906. if (node) {
  1907. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  1908. if(node.data.type == billType.DXFY&&node.data.isAdd!=1){
  1909. return false;
  1910. }
  1911. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  1912. return false;
  1913. }
  1914. if(projectObj.project.Bills.hasFlags(node)){
  1915. return false;
  1916. }
  1917. }
  1918. if(m_selection!=true&&node.sourceType === projectObj.project.ration_glj.getSourceType()){//多选的时候不做这一项判断
  1919. return false;
  1920. }
  1921. return true;
  1922. } else {
  1923. return false;
  1924. }
  1925. };
  1926. function canDelete_m(selection) {
  1927. for(let i =0;i<selection.rowCount;i++){
  1928. if(tree.items[selection.row+i]==undefined||tree.items[selection.row+i]==null){
  1929. return false;
  1930. }
  1931. if(i==0&&tree.items[selection.row].sourceType === projectObj.project.ration_glj.getSourceType()){
  1932. return false
  1933. }
  1934. if(canDelete(tree.items[selection.row+i],true)==false){
  1935. return false
  1936. }
  1937. }
  1938. return true
  1939. };
  1940. }
  1941. function canInsertRationNode(selected) {//判断是否能插入定额、量价、定额类型工料机, false 不能,true能
  1942. if(!selected)
  1943. return false;
  1944. let project = projectObj.project;
  1945. if(selected.sourceType == ModuleNames.bills && selected.data.type == billType.DXFY){
  1946. return false
  1947. }else if(!(project.Bills.isMeasure(selected)||project.Bills.isFBFX(selected))){
  1948. return false
  1949. }else if(selected.sourceType == ModuleNames.bills && selected.source.children.length > 0){
  1950. return false
  1951. }
  1952. else {
  1953. return true
  1954. }
  1955. /* if (selected) {// Vincent, 2018-01-02
  1956. if(selected.sourceType === project.Ration.getSourceType()){ // 焦点行是定额/量价/工料机,有效显示。
  1957. return false;
  1958. }else if(selected.sourceType === project.Bills.getSourceType()){
  1959. if(selected.data.type == billType.FX || selected.data.type == billType.BX){//焦点行是分项,有效显示。
  1960. return false
  1961. }
  1962. if(selected.data.type == billType.BILL && selected.source.children.length === 0){//焦点行是清单,且没有子项,有效显示。
  1963. return false
  1964. }
  1965. }
  1966. }
  1967. return true;*/
  1968. }
  1969. //导入类型(09表、广联达)
  1970. const uploadType = {lj: 'lj', gld: 'gld'};
  1971. let fileType = uploadType.lj;
  1972. $('#uploadLj').click(function () {
  1973. fileType = uploadType.lj;
  1974. });
  1975. $('#uploadGld').click(function () {
  1976. fileType = uploadType.gld;
  1977. });
  1978. //设置导入表内容
  1979. function setUploadSheets(sheetNames){
  1980. let sheetArea = $('#uploadSheets');
  1981. $('#uploadSheets').height('');
  1982. sheetArea.empty();
  1983. for(let sheetName of sheetNames){
  1984. let sheetDiv = $(`<div style="margin-left: 5px;margin-top: 5px;" class="input-group form-check"><label class="form-check-label" style="width:270px; overflow: hidden; white-space: nowrap; text-overflow: ellipsis">
  1985. <input class="form-check-input" type="checkbox">${sheetName}</label></div>`);
  1986. sheetDiv.find('input[type="checkbox"]').click(function () {
  1987. if($('#uploadAlert').is(':visible')){
  1988. $('#uploadAlert').hide();
  1989. }
  1990. });
  1991. let sel = $(`<select style="margin-left: 5px; border-radius: .20rem;"><option value="fbfx">分部分项工程</option><option value="zzcsxm">施工组织措施项目</option><option value="jscsxm">施工技术措施项目</option></select>`);
  1992. if(sheetName.includes('分部分项工程项目清单计价表')){
  1993. sheetDiv.find('input[type="checkbox"]').prop('checked', true);
  1994. sel.find('option:eq(0)').prop('selected', true);
  1995. }
  1996. else if(sheetName.includes('施工组织措施项目清单计价表')){
  1997. sheetDiv.find('input[type="checkbox"]').prop('checked', true);
  1998. sel.find('option:eq(1)').prop('selected', true);
  1999. }
  2000. else if(sheetName.includes('施工技术措施项目清单计价表')){
  2001. sheetDiv.find('input[type="checkbox"]').prop('checked', true);
  2002. sel.find('option:eq(2)').prop('selected', true);
  2003. }
  2004. sheetDiv.append(sel);
  2005. sheetArea.append(sheetDiv);
  2006. }
  2007. if(sheetNames.length > 0){
  2008. sheetArea.show();
  2009. }
  2010. if($('#uploadSheets').height() > 250){
  2011. console.log('aa');
  2012. sheetArea.css('overflow', 'auto');
  2013. sheetArea.height(250);
  2014. }
  2015. else {
  2016. sheetArea.css('overflow', 'hidden');
  2017. }
  2018. }
  2019. //获得选择导入的表信息(表索引及导入位置)
  2020. function getUploadSheets(){
  2021. let rst = [];
  2022. let sheetArea = $('#uploadSheets');
  2023. let checkedInputs = sheetArea.find('input:checked');
  2024. for(let checked of checkedInputs){
  2025. rst.push({sheetIdx: $(checked).parent().parent().index(), position: $(checked).parent().next().select().val()})
  2026. }
  2027. return rst;
  2028. }
  2029. //选择要导入的excel文件
  2030. $('#customFile').change(function () {
  2031. let file = $(this)[0];
  2032. if(file.files.length > 0){
  2033. $('.custom-file-label').text(`${file.files[0].name}`);
  2034. $('#uploadAlert').hide();
  2035. console.log(file.files);
  2036. //读取各个表及表名
  2037. $.bootstrapLoading.start();
  2038. let fileReader = new FileReader();
  2039. fileReader.onload = function(ev) {
  2040. console.log('enter');
  2041. try {
  2042. let data = ev.target.result;
  2043. // 以二进制流方式读取得到整份excel表格对象
  2044. let workbook = XLSX.read(data, {type: 'binary'});
  2045. // 遍历每张表读取
  2046. let sheetNames = [];
  2047. for (let sheetName in workbook.Sheets) {
  2048. sheetNames.push(sheetName);
  2049. }
  2050. setUploadSheets(sheetNames);
  2051. $.bootstrapLoading.end();
  2052. } catch (e) {
  2053. console.log(e);
  2054. $.bootstrapLoading.end();
  2055. alert('文件类型不正确');
  2056. return;
  2057. }
  2058. };
  2059. // 以二进制方式打开文件
  2060. fileReader.readAsBinaryString(file.files[0]);
  2061. }
  2062. else{
  2063. $('.custom-file-label').text(`请选择上传文件`);
  2064. }
  2065. });
  2066. //从excel导入清单
  2067. $('#uploadConfirm').click(function () {
  2068. let me = this;
  2069. $(me).addClass('disabled');
  2070. try{
  2071. let formData = new FormData();
  2072. let file = $('#customFile')[0];
  2073. if(file.files.length <= 0){
  2074. throw '未选择文件';
  2075. }
  2076. formData.append('file', file.files[0]);
  2077. let projectID = scUrlUtil.GetQueryString('project');
  2078. if(!projectID || projectID <= 0){
  2079. throw '项目数据出错';
  2080. }
  2081. //导入表类型(09lj、广联达gld)
  2082. formData.append('fileType', fileType);
  2083. //选择的表及导入位置
  2084. let uploadWorkBook = getUploadSheets();
  2085. if(uploadWorkBook.length === 0){
  2086. throw '请选择要导入的表';
  2087. }
  2088. formData.append('uploadWorkBook', JSON.stringify(uploadWorkBook));
  2089. formData.append('projectID', projectID);
  2090. //要去匹配的清单库(第一个)
  2091. let matchBillLibId = projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0 ? projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id : null;
  2092. formData.append('billsLibId', matchBillLibId);
  2093. $.ajax({
  2094. url: '/bills/upload',
  2095. type: 'POST',
  2096. data: formData,
  2097. cache: false,
  2098. contentType: false,
  2099. processData: false,
  2100. beforeSend: function() {
  2101. $.bootstrapLoading.start();
  2102. },
  2103. success: function(response){
  2104. if (response.err === 0) {
  2105. const message = response.msg !== undefined ? response.msg : '';
  2106. if (message !== '') {
  2107. alert(message);
  2108. }
  2109. // 成功则关闭窗体
  2110. $('#import').modal("hide");
  2111. //更新前端
  2112. doAfterImport(response.data);
  2113. if($.bootstrapLoading.isLoading()){
  2114. $.bootstrapLoading.end();
  2115. }
  2116. } else {
  2117. const message = response.msg !== undefined ? response.msg : '上传失败!';
  2118. $.bootstrapLoading.end();
  2119. alert(message);
  2120. }
  2121. $(me).removeClass('disabled');
  2122. },
  2123. error: function(){
  2124. alert("与服务器通信发生错误");
  2125. $.bootstrapLoading.end();
  2126. $(me).removeClass('disabled');
  2127. }
  2128. });
  2129. }
  2130. catch (err){
  2131. //alert(err);
  2132. showUploadAlert(false, err);
  2133. $(me).removeClass('disabled');
  2134. }
  2135. });
  2136. function showUploadAlert(success, msg){
  2137. if(!success){
  2138. $('#uploadAlert').removeClass('alert-success');
  2139. $('#uploadAlert').addClass('alert-danger');
  2140. }
  2141. else{
  2142. $('#uploadAlert').removeClass('alert-danger');
  2143. $('#uploadAlert').addClass('alert-success');
  2144. }
  2145. $('#uploadAlert').text(msg);
  2146. $('#uploadAlert').show();
  2147. }
  2148. //导入清单到一个固定行位置后,更新数据
  2149. function doAfterImportPosition(positionData){
  2150. let nodes = projectObj.project.mainTree.nodes;
  2151. let bills_datas = projectObj.project.Bills.datas;
  2152. let ration_datas = projectObj.project.Ration.datas;
  2153. let quantity_detail_datas = projectObj.project.quantity_detail.datas;
  2154. let ration_glj_datas = projectObj.project.ration_glj.datas;
  2155. let ration_coe_datas = projectObj.project.ration_coe.datas;
  2156. let ration_install_datas = projectObj.project.ration_installation.datas;
  2157. let delNodes = [];
  2158. for(let billID of positionData.remove.bill){
  2159. if(nodes['id_' + billID]){
  2160. delNodes.push(nodes['id_' + billID]);
  2161. }
  2162. //清除清单数据
  2163. _.remove(bills_datas, {ID: billID});
  2164. //清除清单工程量明细数据
  2165. _.remove(quantity_detail_datas, {billID: billID});
  2166. }
  2167. for(let rationID of positionData.remove.ration){
  2168. //清除定额数据
  2169. _.remove(ration_datas, {ID: rationID});
  2170. //清除定额下的相关数据
  2171. _.remove(ration_glj_datas, {rationID: rationID});
  2172. _.remove(ration_coe_datas, {rationID: rationID});
  2173. _.remove(ration_install_datas, {rationID: rationID});
  2174. _.remove(quantity_detail_datas, {rationID: rationID});
  2175. }
  2176. //删除节点
  2177. if(delNodes.length > 0){
  2178. //通过固定清单获得删除节点的起始行索引
  2179. let beginRow = null;
  2180. if(positionData.fixedBill){
  2181. let fixedNode = nodes['id_' + positionData.fixedBill.ID];
  2182. if(fixedNode){
  2183. beginRow = projectObj.project.mainTree.items.indexOf(fixedNode) + 1;
  2184. }
  2185. }
  2186. //删除主树节点
  2187. projectObj.mainController.m_delete(delNodes, beginRow);
  2188. //删除清单树节点
  2189. let delIdNodes = [];
  2190. for(let delNode of delNodes){
  2191. delIdNodes.push(delNode.source);
  2192. }
  2193. projectObj.project.Bills.tree.m_delete(delIdNodes);
  2194. }
  2195. if(positionData.insert.bill.length > 0){
  2196. //设置flagsIndex
  2197. for(let insertBill of positionData.insert.bill){
  2198. insertBill.flagsIndex = {};
  2199. if (insertBill.flags) {
  2200. insertBill.flags.forEach(function (flag) {
  2201. insertBill.flagsIndex[flag.fieldName] = flag;
  2202. });
  2203. }
  2204. }
  2205. //插入清单节点
  2206. projectObj.project.Bills.tree.insertByDatas(positionData.insert.bill);
  2207. //插入主树节点
  2208. let newNodes = projectObj.project.mainTree.insertByDatas(positionData.insert.bill);
  2209. for(let node of newNodes){
  2210. node.source = projectObj.project.Bills.tree.nodes['id_' + node.getID()];
  2211. node.data = node.source.data;
  2212. node.sourceType = projectObj.project.Bills.getSourceType();
  2213. }
  2214. ProjectController.syncDisplayNewNodes(projectObj.mainController, newNodes);
  2215. }
  2216. }
  2217. //导入后更新操作
  2218. function doAfterImport(resData){
  2219. if(resData && resData.length > 0){
  2220. for(let positionData of resData){
  2221. doAfterImportPosition(positionData);
  2222. }
  2223. //如果清单未锁定,导入后锁定清单
  2224. if(!projectInfoObj.projectInfo.property.lockBills){
  2225. $("a[name='lockBills']").click();
  2226. }
  2227. $.bootstrapLoading.end();
  2228. //重算
  2229. projectObj.project.calcProgram.calcAllNodesAndSave(calcAllType.catAll, function () {
  2230. projectObj.project.projectGLJ.loadData(function () {
  2231. $.bootstrapLoading.end();
  2232. });
  2233. });
  2234. }
  2235. }
  2236. //下载导入清单示例文件
  2237. $('#uploadExample').click(function () {
  2238. window.location.href = '/bills/downloadExamp';
  2239. });
  2240. $(function () {
  2241. //清空导入清单选择文件
  2242. $('#import').on('show.bs.modal', function(){
  2243. $('#customFile').val('');
  2244. $('#uploadAlert').hide();
  2245. $('.custom-file-label').text(`请选择上传文件`);
  2246. });
  2247. $('#import').on('hidden.bs.modal', function () {
  2248. //恢复选择表高度
  2249. $('#uploadSheets').height('');
  2250. $('#uploadSheets').hide();
  2251. });
  2252. $("#billsSpread").mouseover(function(){
  2253. spreadAutoFocus(projectObj.mainSpread,subSpread);
  2254. });
  2255. $("#subSpread").mouseover(function(){
  2256. spreadAutoFocus(subSpread,projectObj.mainSpread);
  2257. });
  2258. $("#paste_confirm").click(function (){
  2259. let selected = projectObj.project.mainTree.selected;
  2260. let blockData = BlockController.getBlockData();
  2261. let position = $("input[name='pastePositionRadio']:checked").val();
  2262. BlockController.confirmPaste(blockData,selected,position);
  2263. $("#pastePosition").modal("hide");
  2264. });
  2265. function spreadAutoFocus(spread,relateSpread) {
  2266. if(relateSpread&&relateSpread.getActiveSheet().isEditing()){//关联的spread不在编辑状态的情况下,才自动获得焦点;
  2267. return;
  2268. }else {
  2269. spread?spread.focus():'';
  2270. }
  2271. }
  2272. //项目为只读
  2273. if(projectReadOnly){
  2274. disableTools();
  2275. }
  2276. });
  2277. //项目只读,处理不可操作的工具栏
  2278. function disableTools(){
  2279. //造价书按钮
  2280. $('#delete').remove();
  2281. $('#upLevel').remove();
  2282. $('#downLevel').remove();
  2283. $('#upMove').remove();
  2284. $('#downMove').remove();
  2285. $('#ZLFB_btn').remove();
  2286. $('#switchTznr').remove();
  2287. $('a[name="lockBills"]').remove();
  2288. //关于计算
  2289. $('#poj-settings-4').find('input').prop('disabled', 'disabled');
  2290. //小数位数
  2291. $('#poj-settings-decimal').find('input').prop('disabled', 'disabled');
  2292. //人工单价调整
  2293. $('#std_labour_coe_files').prop('disabled', 'disabled');
  2294. //呈现选项
  2295. $('#display-setting').find('input').prop('disabled', 'disabled');
  2296. $('#recColSetting').remove();
  2297. //项目属性确定
  2298. $('#property_ok').addClass('disabled');
  2299. //特征及内容
  2300. $('#add-rule').find('select').prop('disabled', 'disabled');
  2301. $('#use-to-current').addClass('disabled');
  2302. $('#use-to-all').addClass('disabled');
  2303. $('.bottom-tools').remove();
  2304. //导入
  2305. $('#uploadConfirm').addClass('disabled');
  2306. //选项
  2307. $('#generalOpts1').prop('disabled', 'disabled');
  2308. $('#generalOpts2').prop('disabled', 'disabled');
  2309. //补充库编辑器
  2310. $('#compleRationLib').addClass('disabled');
  2311. $('#compleGljLib').addClass('disabled')
  2312. //库
  2313. $('#stdBillsGuidanceTab').addClass('disabled');
  2314. $('#stdBillsTab').addClass('disabled');
  2315. $('#stdRationTab').addClass('disabled');
  2316. //人材机汇总,选择其他、另存使用
  2317. $('a[data-target="#change-unitFile"]').remove();
  2318. $('a[data-target="#unitFile-save-as"]').remove();
  2319. //费率,选择其他、另存使用、重选标准、统一设置相同参数
  2320. $('a[data-target="#change-lv"]').remove();
  2321. $('a[data-target="#copy-lv"]').remove();
  2322. $('#standardSelect').prop('disabled', 'disabled');
  2323. $('#cascadeSet').prop('disabled', 'disabled');
  2324. //计算程序标准
  2325. $('#calcProgramFileSelect').prop('disabled', 'disabled');
  2326. //调价
  2327. $('#calcPriceOption').prop('disabled', 'disabled');
  2328. $('#gljPriceTenderCoe').prop('disabled', 'disabled');
  2329. $('#tenderGLJQuantity').prop('disabled', 'disabled');
  2330. $('#tenderRationQuantity').prop('disabled', 'disabled');
  2331. $('#tenderPrice').prop('disabled', 'disabled');
  2332. $('#cleanTender').prop('disabled', 'disabled');
  2333. }
  2334. //项目只读,表格只读
  2335. function disableSpread(spread){
  2336. spread.unbind(GC.Spread.Sheets.Events.ButtonClicked);
  2337. let sheetCount = spread.getSheetCount();
  2338. console.log(sheetCount);
  2339. for(let i = 0; i < sheetCount; i++){
  2340. let sheet = spread.getSheet(i);
  2341. sheet.unbind(GC.Spread.Sheets.Events.ButtonClicked);
  2342. sheet.unbind(GC.Spread.Sheets.Events.EditStarting);
  2343. sheet.unbind(GC.Spread.Sheets.Events.EditEnded);
  2344. sheet.unbind(GC.Spread.Sheets.Events.RangeChanged);
  2345. sheet.unbind(GC.Spread.Sheets.Events.ClipboardChanging);
  2346. sheet.unbind(GC.Spread.Sheets.Events.ClipboardChanged);
  2347. sheet.unbind(GC.Spread.Sheets.Events.CellDoubleClick);
  2348. sheet.unbind(GC.Spread.Sheets.Events.CellClick);
  2349. sheet.unbind(GC.Spread.Sheets.Events.ValueChanged);
  2350. console.log(sheet.name());
  2351. sheet.suspendPaint();
  2352. sheet.suspendEvent();
  2353. sheet.options.isProtected = true;
  2354. let rowCount = sheet.getRowCount();
  2355. let colCount = sheet.getColumnCount();
  2356. for(let row = 0; row < rowCount; row++){
  2357. for(let col = 0; col < colCount; col++){
  2358. sheet.getCell(row, col).locked(true);
  2359. }
  2360. }
  2361. sheet.resumePaint();
  2362. sheet.resumeEvent();
  2363. }
  2364. }