project_view.js 104 KB

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