project_view.js 174 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807
  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. selectedChangeNowTime: 0,
  22. selectedChangeDelayTime: 20,
  23. treeSelectedChanged: function (node) {
  24. let me = this;
  25. let project = projectObj.project;
  26. let mainSheet = projectObj.mainController.sheet;
  27. let init = true;
  28. locateToCache(node);
  29. //设置选中行底色和恢复前选中行底色
  30. let refreshNodes = [node];
  31. if(!project.mainTree.preSelected){
  32. refreshNodes.push(project.mainTree.items[0]);
  33. }
  34. else {
  35. refreshNodes.push(project.mainTree.preSelected);
  36. init = !(project.mainTree.preSelected == node)
  37. }
  38. mbzm_obj.nodeChanged = init;
  39. project.mainTree.preSelected = node;
  40. projectObj.setNodesStyle(projectObj.mainController.sheet, refreshNodes);
  41. function delayOpr(callback) {
  42. let nowTime = Date.now();
  43. me.selectedChangeNowTime = nowTime;
  44. setTimeout(function () {
  45. if (nowTime - me.selectedChangeNowTime == 0) {
  46. callback();
  47. }
  48. }, me.selectedChangeDelayTime);
  49. }
  50. delayOpr(function () {
  51. if($('#linkComments').hasClass('active')){
  52. subViewObj.loadComments(node);
  53. }
  54. let nodeID = node ? node.getID() : null;
  55. gljOprObj.mainTreeSelectedChange = gljOprObj.selectedNodeId != nodeID;
  56. if(init) subObj.initNavItem(node);
  57. /*
  58. 2018-11-9 在NavItem里设置了默认显示的item,在里执行了click这个操作所以这两个操作不用重复执行了
  59. gljOprObj.showDataIfRationSelect(node);
  60. if (activeSubSheetIsCalcProgram())
  61. calcProgramObj.refreshCalcProgram(node, 3);*/
  62. //zhong 2017-9-1 特征及内容
  63. if(pageCCOprObj.active){
  64. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
  65. pageCCOprObj.setCacheAndShow(node);
  66. }
  67. });
  68. },
  69. refreshBaseActn: function (tree) {
  70. let setButtonValid = function (valid, btn) {
  71. if (!projectReadOnly && valid) {
  72. btn.removeClass('disabled');
  73. } else {
  74. btn.addClass('disabled');
  75. }
  76. };
  77. let selected = tree.selected, that = projectObj;
  78. let canUpLevel = function (node) {
  79. if(!node){
  80. return false;
  81. }
  82. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  83. return false;
  84. }
  85. if(node.depth()<=1){//焦点行是树结构的第一/二层节点,灰显。
  86. return false;
  87. }
  88. if(node.sourceType !== that.project.Bills.getSourceType()){//焦点行是定额/量价/工料机,灰显。
  89. return false;
  90. }else {
  91. if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项,或者补项灰显。
  92. return false;
  93. }
  94. if(node.data.type == billType.FB&&node.nextSibling&&node.children.length>0){//焦点行是分部有后兄弟,有子项.
  95. if(node.children[0].data.type==billType.FX || node.children[0].data.type==billType.BX){ //焦点行子项是分项
  96. return false;
  97. }
  98. }
  99. if(node.data.type == billType.BILL &&node.nextSibling){//焦点行是清单有后兄弟
  100. if(node.data.calcBase&&node.data.calcBase!=""){//有基数计算
  101. return false;
  102. }
  103. if(node.children.length>0&&node.children[0].sourceType !== that.project.Bills.getSourceType()){//有子项,并且子项不是清单
  104. return false;
  105. }
  106. }
  107. }
  108. return true;
  109. };
  110. let canDownLevel = function (node) {
  111. if(!node){
  112. return false;
  113. }
  114. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  115. return false;
  116. }
  117. if(node.depth()==0){//焦点行是树结构的第一层节点,灰显。
  118. return false;
  119. }
  120. if(node.sourceType !== that.project.Bills.getSourceType()) {//焦点行是定额/量价/工料机,灰显。
  121. return false;
  122. }else {
  123. if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项,灰显。
  124. return false;
  125. }
  126. if(!node.preSibling){//无前兄弟,灰显
  127. return false;
  128. }else if(node.preSibling.data.calcBase&&node.preSibling.data.calcBase!=""){//前兄弟有基数计算
  129. return false
  130. }
  131. if(node.preSibling.children.length>0){//前兄弟有子项,子项是分项,灰显。
  132. if(node.data.type==billType.FB&&(node.preSibling.children[0].data.type==billType.FX||node.preSibling.children[0].data.type==billType.BX)){//焦点行是分部前兄弟有子项,子项是分项,灰显。
  133. return false;
  134. }
  135. if(node.data.type==billType.BILL&&node.preSibling.children[0].sourceType !== that.project.Bills.getSourceType()){//焦点行是清单,子项不是清单
  136. return false
  137. }
  138. }
  139. }
  140. return true;
  141. };
  142. let canUpMove = function (node) {
  143. if(node&&node.sourceType!= ModuleNames.ration_glj &&node.preSibling){//有前兄弟 并且不是定额工料机
  144. if(node.sourceType==that.project.Bills.getSourceType()){
  145. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  146. return false;
  147. }
  148. if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
  149. return false;
  150. }
  151. }
  152. return true
  153. }
  154. return false
  155. };
  156. let canDownMove = function (node) {
  157. if(node&& node.sourceType!= ModuleNames.ration_glj &&node.nextSibling){//并且不是定额工料机
  158. if(node.sourceType==that.project.Bills.getSourceType()){
  159. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  160. return false;
  161. }
  162. if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
  163. return false;
  164. }
  165. }
  166. return true;
  167. }
  168. return false
  169. };
  170. setButtonValid(projectObj.project.Ration.canAdd(selected), $('#insertRation'));
  171. setButtonValid(ifCanDelete(), $('#delete'));
  172. setButtonValid(canUpLevel(selected), $('#upLevel'));
  173. setButtonValid(canDownLevel(selected), $('#downLevel'));
  174. setButtonValid(canUpMove(selected) , $('#upMove'));
  175. setButtonValid(canDownMove(selected), $('#downMove'));
  176. setButtonValid(!projectObj.project.isBillsLocked(), $('#ZLFB_btn'));
  177. setButtonValid(!projectObj.project.isBillsLocked(), $('#ZLQD_btn'));
  178. },
  179. checkCommonField: function (editingText, colSetting) {
  180. let value;
  181. if (colSetting.data.decimal) {
  182. value = Number(editingText);
  183. if (number_util.isNumber(value)) {
  184. if (colSetting.data.decimal) {
  185. value = value.toDecimal(colSetting.data.decimal);
  186. }
  187. } else {
  188. value = null;
  189. alert('当前输入的数据类型不正确,请重新输入。');
  190. }
  191. } else {
  192. value = editingText;
  193. }
  194. return value;
  195. },
  196. checkFormulaValidField: function (editingText, colSetting) {
  197. let value = Number(editingText);
  198. if(isNaN(value)) return value;
  199. if (!value) {
  200. try {
  201. let exp = new Expression('');
  202. exp.Expression(editingText);
  203. value = Number(exp.Evaluate());
  204. } catch (error) {
  205. value = null;
  206. }
  207. }
  208. if (value!=undefined||value!=null) {
  209. if (colSetting.data.decimal) {
  210. value = value.toDecimal(colSetting.data.decimal);
  211. }
  212. } else if (editingText && editingText !== '') {
  213. value = null;
  214. alert('当前输入的数据类型不正确,请重新输入。');
  215. }
  216. return value;
  217. },
  218. checkSpreadEditingText: function (editingText, colSetting) {
  219. if (colSetting.data.field === 'contain'||colSetting.data.field === 'feesIndex.common.unitFee'|| colSetting.data.field === 'feesIndex.common.totalFee') {//colSetting.data.field === 'quantity'
  220. return this.checkFormulaValidField(editingText, colSetting);
  221. }
  222. else if (colSetting.data.field === 'programID') {
  223. return this.project.calcProgram.compiledTemplateMaps[editingText];
  224. }
  225. else if (colSetting.data.field === 'subType') {
  226. if (typeof(editingText) !== "number")
  227. return volumePriceMaps[editingText]
  228. else
  229. return editingText;
  230. }
  231. else {
  232. return this.checkCommonField(editingText, colSetting);
  233. }
  234. },
  235. getVisibleRows: function (sRow, count) {
  236. let rst = [];
  237. let nodes = projectObj.project.mainTree.items;
  238. for(let i = sRow, len = nodes.length; i < len; i++){
  239. if(count <= 0){
  240. break;
  241. }
  242. if(nodes[i].visible){
  243. rst.push(i);
  244. count--;
  245. }
  246. }
  247. return rst;
  248. },
  249. //根据列标段设置焦点单元格
  250. setActiveCell(field, moveScroll){
  251. projectObj.mainSpread.focus(true);
  252. let mainSheet = projectObj.mainSpread.getActiveSheet();
  253. TREE_SHEET_HELPER.massOperationSheet(mainSheet,function(){
  254. let fieldCol = colSettingObj.getColByField(field);
  255. if(fieldCol){
  256. if(moveScroll){
  257. mainSheet.showColumn(fieldCol, GC.Spread.Sheets.HorizontalPosition.center);
  258. }
  259. mainSheet.setActiveCell(projectObj.project.mainTree.selected.serialNo(), fieldCol);
  260. }
  261. });
  262. },
  263. //获取粘贴更改的单元格(粘贴时,跳过隐藏行)
  264. checkSpreadChangedCells: function (info) {
  265. let rst = {refreshRows: [], changedCells: []};
  266. //获取显示行号
  267. let vRows = projectObj.getVisibleRows(info.row, info.rowCount);
  268. let vCount = vRows.length;
  269. let lastRow = null, count = 0;
  270. for(let cell of info.changedCells){
  271. cell.text = info.sheet.getCell(cell.row, cell.col).text();
  272. if(cell.row !== lastRow){
  273. count++;
  274. lastRow = cell.row;
  275. }
  276. if(count <= vCount){
  277. if(vRows[count - 1] !== cell.row){
  278. rst.refreshRows.push(cell.row);
  279. }
  280. rst.changedCells.push({row: vRows[count - 1], col: cell.col, text: cell.text});
  281. }
  282. else {
  283. rst.refreshRows.push(cell.row);
  284. }
  285. }
  286. rst.refreshRows = Array.from(new Set(rst.refreshRows));
  287. return rst;
  288. },
  289. updateBillsCode: function (node, value) {
  290. let project = projectObj.project,me = this;
  291. let stdMatchCode, formatCode, matchs;
  292. let searchStdBillsAndUpdate = function (stdCode, formatCode) {
  293. let orgCode = node.data.code?node.data.code.substr(0, 9):"";
  294. if (projectObj.project.projectInfo.engineeringInfo.bill_lib.length === 0 || updateCodeCheck(value,stdCode === orgCode)) {
  295. normalUpdate(node,value,stdCode === orgCode);
  296. } else if (projectObj.project.projectInfo.engineeringInfo.bill_lib.length > 0) {
  297. let libId = projectObj.project.projectInfo.engineeringInfo.bill_lib[0].id;
  298. CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
  299. if (data) {
  300. function updateBeforeInsert(node, data) {
  301. node.data.name = data.name;
  302. if(node.data.type == billType.BX){//从清单库中找到标准清单的话,要把补项改成分项
  303. node.data.type = billType.FX;
  304. }
  305. //sortItems(data.items, data.itemCharacter);//2018-12-03 这里改成在后端获取
  306. // sortItems(data.jobs, data.jobContent);
  307. pageCCOprObj.setItemContentNode(node, data.jobContent, data.itemCharacter, node.data.name);
  308. pageCCOprObj.setCacheAndShow(node);
  309. }
  310. if (/\//.test(data.unit)) {
  311. let existB = projectObj.project.Bills.sameStdCodeBillsData(data.code);
  312. if (existB) {
  313. updateBeforeInsert(node, data);
  314. data.unit = existB.unit;
  315. project.Bills.replaceBills(node.source, data, formatCode);
  316. projectObj.mainController.refreshTreeNode([node], false);
  317. BillsSub.billsSelSub(node.data.code);
  318. } else {
  319. ConfirmModal.stdBillsUnit.check(data, function (std) {
  320. updateBeforeInsert(node, data);
  321. project.Bills.replaceBills(node.source, std, formatCode);
  322. projectObj.mainController.refreshTreeNode([node], false);
  323. BillsSub.billsSelSub(node.data.code);
  324. }, function () {
  325. projectObj.mainController.refreshTreeNode([node], false);
  326. });
  327. }
  328. } else {
  329. updateBeforeInsert(node, data);
  330. project.Bills.replaceBills(node.source, data, formatCode);
  331. projectObj.mainController.refreshTreeNode([node], false);
  332. BillsSub.billsSelSub(node.data.code);
  333. }
  334. } else {
  335. normalUpdate(node,value);
  336. }
  337. });
  338. }
  339. };
  340. //分部分项、措施项目才匹配
  341. let withinValidFixed = false;
  342. let matchFixedFlags = [fixedFlag.SUB_ENGINERRING, fixedFlag.MEASURE];
  343. let rootNode = getRootFixedNode(node);
  344. if(rootNode && rootNode.data.flagsIndex && rootNode.data.flagsIndex.fixed && matchFixedFlags.includes(rootNode.data.flagsIndex.fixed.flag)){
  345. withinValidFixed = true;
  346. }
  347. if(withinValidFixed && (node.data.type==billType.FX||node.data.type==billType.BX||(node.data.type==billType.BILL&&node.source.children.length==0))){//是分项、补项或者叶子清单的情况下才需要查找替换
  348. if (value&&value.length === 9) {//&& /^[\d]+$/.test(value) 去掉全数字判断 07-31 zhang
  349. stdMatchCode = value;
  350. formatCode = project.Bills.newFormatCode(stdMatchCode);
  351. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  352. return;
  353. } else if (value&&value.length === 12 ) {//&& /^[\d]+$/.test(value) 去掉全数字判断 07-31 zhang
  354. stdMatchCode = value.substr(0, 9);
  355. matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
  356. if (matchs.indexOf(value) === -1) {
  357. searchStdBillsAndUpdate(stdMatchCode, value);
  358. return;
  359. } else {
  360. hintBox.infoBox("系统提示","已存在该编码的清单,将自动修改编码后3位,是否继续?",2,function () {
  361. let newFormatCode = project.Bills.newFormatCode(stdMatchCode);
  362. searchStdBillsAndUpdate(stdMatchCode, newFormatCode);
  363. },function () {
  364. me.mainController.refreshTreeNode([node], false);
  365. },['确定','取消']);
  366. return;
  367. }
  368. }
  369. }
  370. normalUpdate(node,value);
  371. function normalUpdate(billnode,codeValue,no_Need_Check) {//在标准库中没有找到清单时改分项为补项再更新
  372. let toBX = false;
  373. if(no_Need_Check!==true && billnode.data.type == billType.FX){
  374. billnode.data.type = billType.BX;
  375. toBX = true;
  376. }
  377. project.Bills.updateField(billnode.source, 'code', codeValue, toBX);
  378. me.mainController.refreshTreeNode([billnode], false);
  379. }
  380. function updateCodeCheck(value,sameStdCode) {//如果前9位相同,只改前三位,则只更新编号就行了,不用做其它处理
  381. return sameStdCode && value && value.length == 12
  382. }
  383. },
  384. updateRationCode: function (node, value) {
  385. if(!isDef(node.data.code) && (!isDef(value) || value.toString().trim() == '')){
  386. return;
  387. }
  388. if (projectObj.project.projectInfo.engineeringInfo.ration_lib.length === 0) {
  389. alert('当前项目无定额库,请添加定额库。');
  390. this.mainController.refreshTreeNode([node], false);
  391. } else {
  392. let libId = parseInt($('#stdRationLibSelect').val());
  393. CommonAjax.post('/complementaryRation/api/getRationItem', {user_id: userID, rationRepId: libId, code: value}, function (data) {
  394. if (data) {
  395. projectObj.project.Ration.replaceRation(node.source, data);
  396. projectObj.project.ration_glj.addRationGLJ(node.source, data);
  397. } else {
  398. alert('当前库中找不到定额"' + value + '"');
  399. }
  400. projectObj.mainController.refreshTreeNode([node], false);
  401. });
  402. }
  403. },
  404. updateCode: function (node, value) {
  405. let project = projectObj.project;
  406. if (node.sourceType === project.Bills.getSourceType()) {
  407. this.updateBillsCode(node, value); // 新清单不适合实时计算,下面套什么还不能确定,无数量计算也无意义
  408. } else if (node.sourceType === project.Ration.getSourceType()) {
  409. if(value && typeof(value) == 'string'){//小写转换成大写
  410. value = value.toUpperCase();
  411. }
  412. project.Ration.updateRationCodes([{'node':node,value:value}]);
  413. // this.updateRationCode(node, value); // 新套定额适合实时计算
  414. // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
  415. }
  416. },
  417. updateNodeField : function (node,value,filedID,callback) {
  418. if(node.data[filedID] == value){
  419. return;
  420. }
  421. let data = {
  422. type:node.sourceType,
  423. data:{
  424. ID:node.data.ID
  425. }
  426. };
  427. data.data[filedID] = value;
  428. $.bootstrapLoading.start();
  429. projectObj.project.updateNodes([data],function () {
  430. node.data[filedID] = value;
  431. if(callback){
  432. callback();
  433. }
  434. $.bootstrapLoading.end();
  435. })
  436. },
  437. updateCellValue: function (node, value, colSetting,editingText) {
  438. let project = projectObj.project, fieldName = colSetting.data.field;
  439. if(node.sourceType==project.ration_glj.getSourceType()){
  440. project.ration_glj.updateFromMainSpread(value,node,fieldName);
  441. }
  442. else if (fieldName === 'overHeight') {
  443. OVER_HEIGHT.handleValueChanged([{ node, value }]);
  444. return;
  445. }
  446. else if(fieldName === 'remark'){
  447. projectObj.updateNodeField(node,value,'remark');
  448. }
  449. else if(calcTools.isGljRation(node)){
  450. gljOprObj.updateRationTypeGLJ(value,node,fieldName,editingText);
  451. }
  452. else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
  453. if (fieldName === 'code' && value != '' && !calcTools.isVolumePrice(node)) {
  454. projectObj.updateCode(node, value);
  455. }
  456. else if(fieldName ==='feeRate'){
  457. project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
  458. }
  459. else if(fieldName ==='contain'){//编辑含量
  460. project.Ration.updateContain(value,node);
  461. }
  462. else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee'||fieldName === 'feesIndex.common.totalFee' || fieldName === 'programID' ||
  463. fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'isSubcontract'){
  464. if (fieldName === 'quantity') {
  465. quantityEditObj.checkingAndUpdate(editingText,node);
  466. // project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
  467. return;
  468. } else if (fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee'||fieldName === 'feesIndex.common.totalFee') {
  469. if(isNaN(value)){//说明输入的是无效的字符
  470. //value == null && editingText!=null && editingText!=""
  471. alert("当前输入的数据类型不正确,请重新输入。");
  472. projectObj.mainController.refreshTreeNode([node]);
  473. return
  474. }
  475. if (value) {
  476. if(fieldName === 'feesIndex.common.unitFee') {
  477. value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node));
  478. //当前是量价/人材机,综合单价可输入,输入的值读取到市场单价,重算综合单价。
  479. if(node.sourceType == ModuleNames.ration && node.data.type != rationType.ration){
  480. fieldName = 'marketUnitFee';
  481. }
  482. }
  483. if(fieldName === 'feesIndex.common.totalFee'){//修改了综合合价后,反算综合单价,然后再由计算程序算个综合合价出来
  484. let unitfee = 0;
  485. if(node.data.quantity){//如果工程量为0或空,综合合单直接填到综合单价
  486. let t_quantity = scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
  487. value = scMathUtil.roundForObj(value,getDecimal("unitPrice", node));
  488. unitfee = scMathUtil.roundForObj(value/t_quantity,getDecimal("totalPrice", node));
  489. }else {
  490. unitfee = scMathUtil.roundForObj(value,getDecimal("totalPrice", node));
  491. }
  492. calcTools.setFieldValue(node, 'feesIndex.common.unitFee', unitfee);
  493. }
  494. }
  495. } else if (fieldName === 'calcBase') {
  496. //zhong
  497. if(value === undefined ||value === null || value.toString().trim() === ''){
  498. value = '';
  499. }
  500. if(value === node.data.calcBase){
  501. return;
  502. }
  503. node.data.userCalcBase = value;
  504. project.calcBase.calculate(node);
  505. if(!project.calcBase.success){
  506. let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  507. projectObj.mainController.refreshTreeNode([node]);
  508. return;
  509. } else if (value === '') {//删除清单基数,单价要清空
  510. calcTools.setFieldValue(node, 'feesIndex.common.unitFee', 0);
  511. }
  512. };
  513. //计算基数赋值要经过解析和标准化,已在calculate里赋值
  514. if(fieldName !== 'calcBase'){
  515. calcTools.setFieldValue(node, fieldName, value);
  516. };
  517. project.calcProgram.calcAndSave(node);
  518. gljOprObj.showRationGLJSheetData();
  519. } else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
  520. node.data[fieldName] = value;
  521. node.changed = true;
  522. if(node.data.quantity){
  523. node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
  524. }
  525. project.calcProgram.calcAndSave(node);
  526. } else {
  527. if (node.sourceType === project.Bills.getSourceType()) {
  528. if(fieldName === "maxPrice" || fieldName === 'minPrice'){
  529. if(value == null){
  530. value = "";
  531. }else {
  532. value = scMathUtil.roundToString(value,getDecimal("unitPrice", node))
  533. }
  534. }
  535. project.Bills.updateField(node.source, fieldName, value, false);
  536. } else if (node.sourceType === project.Ration.getSourceType()) {
  537. project.Ration.updateField(node.source, fieldName, value);
  538. }
  539. if (colSetting.data.wordWrap) {
  540. this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
  541. }
  542. projectObj.mainController.refreshTreeNode([node]);
  543. }
  544. } else if(value==null && fieldName ==='feeRate'){
  545. project.FeeRate.cleanFeeRateID(node);
  546. } else {
  547. projectObj.mainController.refreshTreeNode([node], false);
  548. }
  549. },
  550. mainSpreadLeaveCell: function (sender, info) {
  551. let colSetting = projectObj.mainController.setting.cols[info.col];
  552. projectObj.lastCol = colSetting;
  553. projectObj.lastCell = {row: info.row, col: info.col};
  554. if(colSetting.data.field === 'quantity'){
  555. SheetDataHelper.hideMoreButton()
  556. }
  557. },
  558. //滚动造价书鼠标时,工程量的更多按钮跟着移动
  559. TopRowChanged:function(type,info){
  560. let colSetting = projectObj.mainController.setting.cols[info.sheet.getActiveColumnIndex()];
  561. if(colSetting.data.field === 'quantity'){
  562. SheetDataHelper.moveMoreButton(info.sheet)
  563. }
  564. },
  565. //repaint 动态下拉框
  566. mainSpreadEnterCell: function (sender, info) {
  567. let colSetting = projectObj.mainController.setting.cols[info.col];
  568. if(colSetting.data.field === 'unit' || (projectObj.lastCol&&projectObj.lastCol.data.field === 'unit')||colSetting.data.field ==='subType'
  569. || (projectObj.lastCol&&projectObj.lastCol.data.field === 'subType') || colSetting.data.field === 'programID' ||(projectObj.lastCol&&projectObj.lastCol.data.field === 'programID')){
  570. let rects = [];
  571. rects.push(info.sheet.getCellRect(info.row, info.col));
  572. if(projectObj.lastCell){
  573. rects.push(info.sheet.getCellRect(projectObj.lastCell.row, projectObj.lastCell.col));
  574. }
  575. for(let rect of rects){
  576. info.sheet.repaint(rect);
  577. }
  578. }
  579. },
  580. mainSpreadEditStarting: function (sender, info) {
  581. let project = projectObj.project;
  582. let node = project.mainTree.items[info.row];
  583. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  584. let value = info.sheet.getValue(info.row, info.col);
  585. if(fieldName === 'code' && node && calcTools.isRationItem(node) && isDef(node.data.code)&&isDef(value)){
  586. if (isDef(node.data.prefix) && node.data.prefix !== rationPrefix.none){
  587. value = value.replace(new RegExp(node.data.prefix), '');
  588. };
  589. value = value.replace(new RegExp(rationPrefix.replace), '');
  590. info.sheet.setValue(info.row, info.col, value);
  591. }
  592. if(node&&fieldName =='quantity'&&(node.data.quantityEXP !==null||node.data.quantityEXP !==undefined)){
  593. info.sheet.setValue(info.row, info.col, node.data.quantityEXP);
  594. }
  595. },
  596. onCellDoubleClick: function (sender, info){
  597. let project = projectObj.project;
  598. if(info.row && info.col){
  599. let node = project.mainTree.items[info.row];
  600. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  601. if(fieldName == 'marketUnitFee'){
  602. if(gljOprObj.hasComposition(node.data,true)){
  603. alert("当前人材机的市场价由组成物计算得出,不可直接修改。");
  604. return;
  605. }
  606. }
  607. if(fieldName == 'code' && node){
  608. projectObj.showBillOrRationLib(node)
  609. }
  610. }
  611. },
  612. showBillOrRationLib(node){
  613. let BILLS = projectObj.project.Bills;
  614. let code = node.data.code ? node.data.code : '';
  615. if(node.sourceType == ModuleNames.bills){//当清单是“分部分项工程”、“措施项目工程”时,要展开清单规则节点
  616. if(BILLS.isFXorBX(node)||(node.data.type == billType.BILL && BILLS.isMeasure(node))){//是分项或补项,是清单并且属于措施项目节点
  617. if(!billsGuidance.bills.tree){
  618. doAfterLoadGuidance = function () {
  619. billsGuidance.locateAtBills(code);
  620. doAfterLoadGuidance = null;
  621. }
  622. } else {
  623. billsGuidance.locateAtBills(code);
  624. }
  625. if(!$("#zy").is(":visible")) {
  626. $('#stdBillsGuidanceTab').click();
  627. }
  628. }
  629. }
  630. if(node.sourceType == ModuleNames.ration){ //在定额编码中双击,如果右侧定额库没有展开,则自动展开。
  631. if(node.data.type != rationType.ration) return ;//只有定额类型才需要自动展开,其它都不用
  632. let libID = node.data.libID;
  633. if (node.data.from === 'cpt') {
  634. libID = node.data.fromUser ? `${rationLibObj.compleRationLibId}*${node.data.fromUser}` : rationLibObj.compleRationLibId;
  635. }
  636. if(!rationLibObj.tree){
  637. if(isDef(libID)) sessionStorage.setItem('stdRationLib', libID);
  638. rationLibObj.doAfterGetRationTree = function () {
  639. this.locateAtRation(libID, code);
  640. this.doAfterGetRationTree = null;
  641. };
  642. } else {
  643. if($('#stdRationLibSelect').select().val() != libID){
  644. let libOpts = $('#stdRationLibSelect').find('option');
  645. for(let libOpt of libOpts){
  646. if($(libOpt).val() == libID){
  647. $(libOpt).prop('selected', 'selected');
  648. break;
  649. }
  650. }
  651. $('#stdRationLibSelect').change();
  652. rationLibObj.doAfterGetRationTree = function () {
  653. this.locateAtRation(libID, code);
  654. this.doAfterGetRationTree = null;
  655. };
  656. } else {
  657. rationLibObj.locateAtRation(node.data.libID, code);
  658. }
  659. }
  660. if(!$("#de").is(":visible")) $('#stdRationTab').click();
  661. }
  662. },
  663. onColumnWidthChanged: function (sender, info) { // CSL,2018.07.25
  664. if (info.colList.includes(4) || info.colList.includes(5)){
  665. let items = projectObj.project.mainTree.items;
  666. let sheet = projectObj.mainSpread.getActiveSheet();
  667. for (let i = 0; i < items.length; i++) {
  668. let need = false;
  669. if (items[i].data.itemCharacterText){
  670. sheet.getCell(i, 4).wordWrap(true);
  671. need = true;
  672. }
  673. if (items[i].data.jobContentText){
  674. sheet.getCell(i, 5).wordWrap(true);
  675. need = true;
  676. }
  677. if (need) sheet.autoFitRow(i);
  678. }
  679. }
  680. },
  681. onClipboardPasting: function (sender, info){
  682. let rIdx = info.sheet.getActiveRowIndex();
  683. let node = projectObj.project.mainTree.items[rIdx];
  684. if (!node.parent){
  685. info.cancel = true;
  686. hintBox.infoBox('系统提示','大项费用不允许粘贴!', 1);
  687. return false;
  688. };
  689. let colName = projectObj.project.projSetting.main_tree_col.cols[info.cellRange.col].data.field;
  690. if (colName == 'code'){
  691. info.cancel = true;
  692. function getNodeType(node) {
  693. let t = null;
  694. if (calcTools.isRationItem(node))
  695. t = 1
  696. else if (calcTools.isBill(node)){
  697. if (calcTools.isBill_FB(node))
  698. t = 2
  699. else if (calcTools.isBill_FX(node) || calcTools.isBill_BX(node))
  700. t = 3
  701. else if (calcTools.isBill_BILL(node))
  702. t = 4;
  703. };
  704. return t;
  705. };
  706. function getPasteTextArr(info) {
  707. let copyText = info.pasteData.text.trim();
  708. if (!copyText) return null;
  709. let spliter = '';
  710. if (copyText.includes('\r\n')){
  711. spliter = '\r\n'
  712. }
  713. else if (copyText.includes('\n')){ // 兼容Unix、Mac 等系统回车换行符
  714. spliter = '\n'
  715. }
  716. else{
  717. spliter = '\r'
  718. };
  719. let rows = copyText.split(spliter);
  720. let rstArr = [];
  721. for (let row of rows) {
  722. row = row.trim();
  723. row = row.split('\t');
  724. rstArr.push(row);
  725. }
  726. return rstArr;
  727. };
  728. function getPasteNodes(node, nodeType, count) {
  729. let nodesArr = [];
  730. let curNode = null;
  731. for (let i = rIdx; i < rIdx + count; i++) {
  732. curNode = projectObj.project.mainTree.items[i];
  733. if (curNode && calcTools.isSameTypeNode(curNode, node)){
  734. nodesArr.push(curNode);
  735. }
  736. else{
  737. curNode = projectObj.project.mainTree.items[i - 1];
  738. break;
  739. }
  740. }
  741. if (nodesArr.length < count){
  742. if (projectObj.project.mainTree.selected != curNode)
  743. projectObj.project.mainTree.selected = curNode;
  744. let add = count - nodesArr.length;
  745. for (let i = 0; i < add; i++) {
  746. switch (nodeType) {
  747. case 1:
  748. curNode = projectObj.project.Ration.addNewRationFast(rationType.ration);
  749. break;
  750. case 2:
  751. curNode = ProjectController.addFB(projectObj.project, projectObj.mainController);
  752. break;
  753. case 3:
  754. curNode = ProjectController.addFX(projectObj.project, projectObj.mainController);
  755. break;
  756. case 4:
  757. curNode = ProjectController.addBills(projectObj.project, projectObj.mainController);
  758. break;
  759. }
  760. if (!curNode){
  761. hintBox.infoBox('系统提示','插入新结点出错,粘贴失败!', 1);
  762. return nodesArr;
  763. }
  764. else{
  765. nodesArr.push(curNode);
  766. if (projectObj.project.mainTree.selected != curNode)
  767. projectObj.project.mainTree.selected = curNode;
  768. }
  769. }
  770. };
  771. return nodesArr;
  772. };
  773. function doPaste(nodes, nodeType, datas) {
  774. if (nodeType == 1){ // 批量粘贴定额有严重的异步问题,这里要和清单分开处理
  775. let updateRationCodes = [];
  776. for (let i = 0; i < datas.length; i++) {
  777. let ptNode = nodes[i];
  778. let code = datas[i][0];
  779. // 编号去掉“换、借、补”等多余的字
  780. code = code.replace(new RegExp(rationPrefix.complementary), '');
  781. code = code.replace(new RegExp(rationPrefix.borrow), '');
  782. code = code.replace(new RegExp(rationPrefix.replace), '');
  783. updateRationCodes.push({'node':ptNode, value:code});
  784. }
  785. projectObj.project.Ration.updateRationCodes(updateRationCodes);
  786. }
  787. else {
  788. for (let i = 0; i < datas.length; i++) {
  789. let ptNode = nodes[i];
  790. let code = datas[i][0];
  791. if (!(ptNode.data && ptNode.data.code && ptNode.data.code.sameText(code))){
  792. projectObj.updateCode(ptNode, code);
  793. };
  794. }
  795. }
  796. projectObj.mainController.refreshTreeNode(nodes);
  797. };
  798. let tagType = getNodeType(node);
  799. if (!tagType){
  800. hintBox.infoBox('系统提示', '该树结点类型不支持从项目编码列粘贴!', 1);
  801. return false;
  802. };
  803. let datas = getPasteTextArr(info);
  804. if (!datas) return;
  805. let pasteNodes = getPasteNodes(node, tagType, datas.length);
  806. doPaste(pasteNodes, tagType, datas);
  807. };
  808. },
  809. mainSpreadEditEnded: function (sender, info) {
  810. let project = projectObj.project;
  811. let node = project.mainTree.items[info.row];
  812. project.withinBillsLocked(node);
  813. let colSetting = projectObj.mainController.setting.cols[info.col];
  814. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  815. //提前处理
  816. if (fieldName === 'code' || fieldName === 'name' || fieldName === 'unit') {
  817. info.editingText = info.editingText ? info.editingText.toString().replace(new RegExp(/[\r\n]/g), '') : info.editingText;
  818. }
  819. // 检查输入类型等
  820. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  821. projectObj.updateCellValue(node, value, colSetting,info.editingText);
  822. // 自动行高
  823. const autoHeight = project.property.displaySetting.autoHeight;
  824. if (autoHeight) {
  825. projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
  826. }
  827. },
  828. msClipboardChanged: function (sender, info) {
  829. let colSettings = projectObj.mainController.setting.cols;
  830. let cDatas = sheetCommonObj.getTableData(info.sheet, colSettings);
  831. sheetCommonObj.copyTextToClipboard(cDatas);
  832. return;
  833. },
  834. mainSpreadRangeChanged: function (sender, info) {
  835. let project = projectObj.project, setting = projectObj.mainController.setting;
  836. let changedObj = projectObj.checkSpreadChangedCells(info);
  837. let refreshNodes = [];
  838. for(let row of changedObj.refreshRows){
  839. refreshNodes.push(project.mainTree.items[row]);
  840. }
  841. let updateRationCodes = [];//更新定额编码时要用同步的方式
  842. // 超高降效的操作比较耗时,需要减少触发
  843. const overHeightChangedData = [];
  844. if(changedObj.changedCells.length > 0){
  845. console.log(changedObj.changedCells);
  846. for (let changedCell of changedObj.changedCells) {
  847. let node = project.mainTree.items[changedCell.row];
  848. let colSetting = setting.cols[changedCell.col];
  849. let value = projectObj.checkSpreadEditingText(changedCell.text, colSetting);
  850. if(colSetting.data.field=='code' && node.sourceType == project.Ration.getSourceType()&&node.data.type==rationType.ration){//如果是更新定额的编码
  851. updateRationCodes.push({'node':node,value:value});
  852. } else if (colSetting.data.field === 'overHeight') {
  853. overHeightChangedData.push({ node, value });
  854. } else {
  855. projectObj.updateCellValue(node, value, colSetting,changedCell.text);
  856. }
  857. }
  858. }
  859. if (overHeightChangedData.length) {
  860. OVER_HEIGHT.handleValueChanged(overHeightChangedData);
  861. }
  862. if(updateRationCodes.length>0){
  863. project.Ration.updateRationCodes(updateRationCodes);
  864. }
  865. if(refreshNodes.length > 0){
  866. projectObj.mainController.refreshTreeNode(refreshNodes);
  867. }
  868. },
  869. checkMainSpread: function () {
  870. if (!this.mainSpread) {
  871. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  872. sheetCommonObj.spreadDefaultStyle(this.mainSpread);
  873. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
  874. this.mainSpread.getActiveSheet().name('mainSheet');
  875. this.mainSpread.getActiveSheet().options.isProtected = true;
  876. this.mainSpread.getActiveSheet().options.frozenlineColor = '#ababab';
  877. }
  878. },
  879. refreshMainSpread: function () {
  880. if (this.mainSpread) {
  881. this.mainSpread.refresh();
  882. }
  883. },
  884. loadProjectData: function () {
  885. var that = this;
  886. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  887. let startTime = +new Date();
  888. console.log("开始加载-----"+startTime);
  889. $.bootstrapLoading.start();
  890. this.project.loadDatas(function (err) {
  891. let mTime = +new Date();
  892. console.log(`get data时间——${mTime - startTime}`);
  893. //快速列设置
  894. if(!colSettingObj.getVisible('itemCharacterText')){
  895. switchTznrHtml(true);
  896. }
  897. if(colSettingObj.getVisible('itemCharacterText')){
  898. switchTznrHtml(false);
  899. }
  900. if (!err) {
  901. that.project.projectGLJ.calcQuantity(true);//计算分部分项和技术措施项目消耗量;
  902. let quantityTime = +new Date();
  903. console.log(`计算quantity时间——${quantityTime - mTime}`);
  904. //that.project.property = projectObj.project.projectInfo.property; 改在doAfterLoad的时候设置
  905. if (typeof overwriteRationCalcBases === 'function')
  906. overwriteRationCalcBases(that.project.property.taxType);
  907. //that.project.calcProgram.compileAllTemps();
  908. if (typeof dynamicLoadCalcBase !== 'undefined') {
  909. dynamicLoadCalcBase();
  910. }
  911. that.project.calcBase.init(that.project);
  912. // that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
  913. // that.project.initCalcFields();
  914. let str = JSON.stringify(that.project.projSetting.main_tree_col);
  915. that.project.projSetting.mainGridSetting = JSON.parse(str);
  916. that.project.projSetting.mainGridSetting.frozenCols = 4;
  917. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
  918. that.project.projSetting.mainGridSetting.setAutoFitRow = MainTreeCol.getEvent("setAutoFitRow");
  919. that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
  920. col.data.splitFields = col.data.field.split('.');
  921. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  922. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  923. }
  924. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  925. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  926. }
  927. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  928. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  929. col.data.cellType = getCellType;
  930. }
  931. // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  932. // col.data.decimal = that.project.getDecimal(col.data.digit);
  933. // col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  934. // }
  935. if (col.data.field === 'code') {
  936. col.data.formatter = '@';
  937. }
  938. col.setAutoHeight = MainTreeCol.getEvent("setAutoHeight");
  939. col.editChecking = MainTreeCol.getEvent("editChecking");
  940. // 根据配置设置自动行高,在这里先做个标记,然后对每个单元格单独配置
  941. if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
  942. col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
  943. col.data.autoHeight = true;
  944. col.showHint = true;
  945. }
  946. if(col.data.field ==='quantity' || col.data.field ==='remark'){
  947. col.showHint = true;
  948. }
  949. // 综合单价、综合合价,小数部分应补0对齐。 CSL
  950. // if (col.data.field.hasSubStr("common")){
  951. if (col.data.field.hasSubStr(".totalFee"))
  952. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, true);
  953. else if (col.data.field.hasSubStr(".unitFee")||col.data.field.hasSubStr("maxPrice"))
  954. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, true);
  955. // }
  956. });
  957. let startShowTime = +new Date();
  958. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
  959. let endShowTime = +new Date();
  960. console.log(`show data时间——${endShowTime - startShowTime}`);
  961. that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
  962. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
  963. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
  964. gljCol.initGljCol(that.project.projSetting.glj_col?that.project.projSetting.glj_col.showAdjustPrice:false,
  965. that.project.property.tenderSetting.showTenderFields?that.project.property.tenderSetting.showTenderFields:false,true);
  966. that.mainController.showTreeData();
  967. subObj.initSubSpread();//初始化主界面下方的表格
  968. if(!projectReadOnly){
  969. that.mainSpreadEscKey(that.mainSpread, that.mainSpreadEditStarting, that.mainSpreadEditEnded);
  970. sheetCommonObj.bindEnterKey(that.mainSpread, that.mainSpreadEnterKey);
  971. that.bindPaseBlockKey(that.mainSpread);
  972. }
  973. setTimeout(function () {
  974. that.mainSpread.getActiveSheet().startEdit();//这两句需要挺多时间,而又需要在editend 事件前触发,而这些又不影响计算,所以这里用异步的方法
  975. that.mainSpread.getActiveSheet().endEdit();
  976. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  977. that.mainSpread.bind(GC.Spread.Sheets.Events.EditStarting, that.mainSpreadEditStarting);
  978. },100);
  979. that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);//选中统计专用,节点相关操作在treeSelectedChanged里些
  980. that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
  981. that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
  982. that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
  983. that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, that.msClipboardChanged);
  984. that.mainSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, that.onButtonClick);
  985. that.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, that.onCellDoubleClick);
  986. that.mainSpread.bind(GC.Spread.Sheets.Events.ColumnWidthChanged, that.onColumnWidthChanged);
  987. that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardPasting, that.onClipboardPasting);
  988. //工程量悬浮窗移动事件
  989. that.mainSpread.bind(GC.Spread.Sheets.Events.TopRowChanged, that.TopRowChanged);
  990. //let loadOtherStartTime = +new Date();
  991. //if(!projectReadOnly){
  992. that.loadMainSpreadContextMenu();
  993. //}
  994. socketObject.connect('main', { projectReadOnly: !!projectReadOnly, user: { ...projectObj.project.projectInfo.opener } });//连接socket服务器
  995. let endTime = +new Date();
  996. console.log(`其它时间——${endTime - endShowTime}`);
  997. console.log("加载完成-----"+endTime);
  998. console.log(`时间——${endTime - startTime}`);
  999. that.project.projectMarkChecking();//是否需要重新进行造价计算
  1000. autoFlashHeight();
  1001. that.loadFocusLocation();
  1002. projectObj.refreshMainSpread();
  1003. //定位到会话中的选项
  1004. let mainTabFocus = sessionStorage.getItem('mainTab') ? sessionStorage.getItem('mainTab') : '#tab_zaojiashu';
  1005. $(`${mainTabFocus}`).click();
  1006. if(projectReadOnly){
  1007. sheetCommonObj.disableSpread(that.mainSpread);
  1008. }
  1009. // 检查旧项目是否有调价数据,没有则自动生成 ----- 有种情况不行,如下:
  1010. // 未知情况:有调价数据,但调价算的不对,所以这里无论什么情况,打开时都要全局算一遍,牺牲速度体验,换来数据稳定。
  1011. // let node = projectObj.project.mainTree.firstNode();
  1012. // if (node.data.feesIndex && node.data.feesIndex.common && node.data.feesIndex.common.totalFee
  1013. // && node.data.feesIndex.common.totalFee != 0){
  1014. // if (node.data.feesIndex.common.tenderTotalFee == undefined || node.data.feesIndex.common.tenderTotalFee == 0)
  1015. // };
  1016. if (projectObj.project.projectInfo.lastFileVer != VERSION){
  1017. projectObj.project.calcProgram.doTenderCalc();
  1018. // console.log('旧项目,打开前进行了全局调价计算。')
  1019. }
  1020. $.bootstrapLoading.end();
  1021. }
  1022. else {
  1023. }
  1024. const onceAlert = getLocalCache(commonConstants.StorageKey.ONCE_MAIN_LOADED);
  1025. if (onceAlert) {
  1026. alert(onceAlert);
  1027. removeLocalCache(commonConstants.StorageKey.ONCE_MAIN_LOADED);
  1028. }
  1029. });
  1030. },
  1031. //绑定复制整块,粘贴整块快捷键
  1032. bindPaseBlockKey:function(workBook){
  1033. workBook.commandManager().register('paseBlock', function () {
  1034. // console.log("teest Z")
  1035. // BlockController.copyRightClickCallback();
  1036. })
  1037. workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.z, true, false, false, false);
  1038. workBook.commandManager().setShortcutKey('paseBlock', GC.Spread.Commands.Key.z, true, false, false, false);
  1039. },
  1040. //mainSpread有一些单元格进入编辑状态后,会动态改变值,公用的bindEscKey方法不适用
  1041. mainSpreadEscKey: function (workBook, editStarting = null, editEnded = null) {
  1042. workBook.commandManager().register('myEsc', function () {
  1043. let sheet = workBook.getActiveSheet();
  1044. if(editStarting){
  1045. sheet.unbind(GC.Spread.Sheets.Events.EditStarting);
  1046. }
  1047. if(editEnded){
  1048. sheet.unbind(GC.Spread.Sheets.Events.EditEnded);
  1049. }
  1050. let row = sheet.getActiveRowIndex();
  1051. let col = sheet.getActiveColumnIndex();
  1052. let orgV = sheet.getValue(row, col);
  1053. let node = projectObj.project.mainTree.items[row];
  1054. let field = colSettingObj.getFieldByCol(col);
  1055. //进入编辑状态后改变了单元格值的时候特殊处理
  1056. if(isDef(field) && field === 'code'){
  1057. if(node && node.sourceType === projectObj.project.Ration.getSourceType() && node.data.type === rationType.ration
  1058. && isDef(node.data.code) && isDef(node.data.prefix) && node.data.prefix !== rationPrefix.none){
  1059. orgV = node.data.prefix + orgV;
  1060. }
  1061. }
  1062. else if(isDef(field) && field === 'quantity'){
  1063. orgV = isDef(node) && isDef(node.data.quantity) ? node.data.quantity : '';
  1064. }
  1065. if(!isDef(orgV)){
  1066. orgV = '';
  1067. }
  1068. if(sheet.isEditing()){
  1069. sheet.endEdit();
  1070. sheet.setValue(row, col, orgV);
  1071. }
  1072. if(editStarting){
  1073. sheet.bind(GC.Spread.Sheets.Events.EditStarting, editStarting);
  1074. }
  1075. if(editEnded){
  1076. sheet.bind(GC.Spread.Sheets.Events.EditEnded, editEnded);
  1077. }
  1078. });
  1079. workBook.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.esc, false, false, false, false);
  1080. workBook.commandManager().setShortcutKey('myEsc', GC.Spread.Commands.Key.esc, false, false, false, false);
  1081. },
  1082. mainSpreadEnterKey: function () {
  1083. let me = projectObj;
  1084. let sheet = me.mainSpread.getActiveSheet();
  1085. let orgRow = sheet.getActiveRowIndex();
  1086. let orgCol = sheet.getActiveColumnIndex();
  1087. let orgField = colSettingObj.getFieldByCol(orgCol);
  1088. let selected = me.project.mainTree.items[orgRow];
  1089. if(sheet.isEditing()){
  1090. sheet.endEdit();
  1091. }
  1092. //正常情况,焦点应该是在下一行的同一列
  1093. let newRow = orgRow + 1, newCol = orgCol;
  1094. //getColByField getVisible都不提出来,减少调用次数
  1095. if(selected){
  1096. //在分项/补项的编码单元格回车,焦点应跳动至本行的工程量单元格
  1097. if(orgField && orgField === 'code' && selected.sourceType === me.project.Bills.getSourceType() && [billType.FX, billType.BX].includes(selected.data.type)){
  1098. let quantityCol = colSettingObj.getColByField('quantity');
  1099. let quantityVisible = colSettingObj.getVisible('quantity');
  1100. if(quantityCol !== null && quantityVisible !== false){
  1101. newRow = orgRow;
  1102. newCol = quantityCol;
  1103. }
  1104. }
  1105. else if(orgField && orgField === 'quantity' && selected.sourceType === me.project.Bills.getSourceType() && [billType.FX, billType.BX].includes(selected.data.type)){
  1106. //在分项/补项的工程量单元格回车,如果其下有定额/量价/人材机,焦点应跳动至其下第一条定额/量价/人材机的工程量,如果是空行,则跳到至第一条定额xx的编码;
  1107. if(selected.children.length !== 0 && !(isDef(selected.children[0].data.code) && selected.children[0].data.code.toString().trim() !== '')){
  1108. let codeCol = colSettingObj.getColByField('code');
  1109. let codeVisible = colSettingObj.getVisible('code');
  1110. newRow = orgRow + 1;
  1111. if(codeCol !== null && codeVisible !== false){
  1112. newCol = codeCol;
  1113. }
  1114. }
  1115. //如果其下没有定额/量价/人材机,则自动在其下插入一条定额空行,在其后自动插入一条分项空行,焦点跳动至定额空行的编码单元格。
  1116. else if(selected.children.length === 0){
  1117. //分项没有后兄弟,且没有锁定清单时在其后插入分项
  1118. if(!selected.nextSibling && !(projectObj.project.projectInfo.property.lockBills && projectObj.project.withinBillsLocked(projectObj.project.mainTree.selected))){
  1119. ProjectController.addFX(me.project, me.mainController);
  1120. //将焦点行设置成原本的行,以插入定额
  1121. me.mainController.setTreeSelected(me.project.mainTree.items[orgRow]);
  1122. }
  1123. /* 2021-04-26 只插入清单不插入定额
  1124. //插入定额
  1125. me.project.Ration.addNewRation(null, rationType.ration, function () {
  1126. newRow = sheet.getActiveRowIndex();
  1127. let codeCol = colSettingObj.getColByField('code');
  1128. let codeVisible = colSettingObj.getVisible('code');
  1129. if(codeCol !== null && codeVisible !== false){
  1130. newCol = codeCol;
  1131. }
  1132. sheet.setActiveCell(newRow, newCol);
  1133. },true); */
  1134. }
  1135. }
  1136. //在定额/量价/人材机的编码单元格回车,焦点应跳动至本行的工程量单元格
  1137. else if(orgField && orgField === 'code' && selected.sourceType === me.project.Ration.getSourceType()){
  1138. let quantityCol = colSettingObj.getColByField('quantity');
  1139. let quantityVisible = colSettingObj.getVisible('quantity');
  1140. if(quantityCol !== null && quantityVisible !== false){
  1141. newRow = orgRow;
  1142. newCol = quantityCol;
  1143. }
  1144. }
  1145. //在定额/量价/人材机的工程量单元格回车
  1146. else if(orgField && orgField === 'quantity' && selected.sourceType === me.project.Ration.getSourceType()){
  1147. let nextSibling = selected.nextSibling;
  1148. //如果其后有定额/量价/人材机(空行:编码为空不算),焦点应跳动至下一行定额/量价/人材机的工程量,不需处理
  1149. //如果其后没有定额/量价/人材机(空行也没有),则自动在其后插入一行定额空行,焦点跳动至定额空行的编码单元格
  1150. /* if(!nextSibling){
  1151. let codeCol = colSettingObj.getColByField('code');
  1152. let codeVisible = colSettingObj.getVisible('code');
  1153. me.project.Ration.addNewRation(null, rationType.ration, function () {
  1154. newRow = sheet.getActiveRowIndex();
  1155. if(codeCol !== null && codeVisible !== false){
  1156. newCol = codeCol;
  1157. }
  1158. sheet.setActiveCell(newRow, newCol);
  1159. }, true);
  1160. } */
  1161. //如果其后有定额空行,焦点跳动至定额空行的编码单元格
  1162. if(nextSibling && !(isDef(nextSibling.data.code) && nextSibling.data.code.toString().trim() !== '')) {
  1163. let codeCol = colSettingObj.getColByField('code');
  1164. let codeVisible = colSettingObj.getVisible('code');
  1165. if(codeCol !== null && codeVisible !== false){
  1166. newRow = orgRow + 1;
  1167. newCol = codeCol;
  1168. }
  1169. }
  1170. }
  1171. //在清单的编码单元格回车,如果清单是叶子节点,焦点跳动至本行的工程量单元格
  1172. else if(orgField && orgField === 'code' && selected.sourceType === me.project.Bills.getSourceType()
  1173. && selected.data.type === billType.BILL && selected.source.children.length === 0){
  1174. let quantityCol = colSettingObj.getColByField('quantity');
  1175. let quantityVisible = colSettingObj.getVisible('quantity');
  1176. if(quantityCol && quantityVisible){
  1177. newRow = orgRow;
  1178. newCol = quantityCol;
  1179. }
  1180. }
  1181. }
  1182. //设置焦点
  1183. sheet.setActiveCell(newRow, newCol);
  1184. //触发表格事件
  1185. me.mainController.setTreeSelected(me.project.mainTree.items[newRow]);//SelectionChanged
  1186. me.mainSpreadLeaveCell({type: 'LeaveCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: orgRow, col: orgCol});
  1187. me.mainSpreadEnterCell({type: 'EnterCell'}, {sheet: sheet, sheetName: sheet.name(), cancel: false, row: newRow, col: newCol});
  1188. },
  1189. // 注册自定义插入清单数量
  1190. registerFlexibleInsertBillMenu: function (type) {
  1191. const project = projectObj.project;
  1192. const name = `插入${billText[type]}`;
  1193. const inputID = `insert-bills-number${type}`;
  1194. const insertBillsHtml = `<span>${name}&nbsp;&nbsp;<input id=${inputID} class="menu-input" type="text" value="1" onfocus="this.select()">&nbsp;&nbsp;行</span>`;
  1195. return sheetCommonObj.registerInputContextMenuItem(`insertBills${type}`, insertBillsHtml, 'fa-sign-in', async function () {
  1196. if (project.mainTree.selected.data.type == billType.DXFY) {
  1197. if (project.mainTree.selected.data.calcBase && project.mainTree.selected.data.calcBase != "") {
  1198. alert("当前有基数计算,不能插入子项。");
  1199. return;
  1200. }
  1201. }
  1202. try {
  1203. const number = +$(`#${inputID}`).val();
  1204. if (!number) {
  1205. return;
  1206. }
  1207. $.bootstrapLoading.start();
  1208. const postData = ProjectController.getBillsPostData(number, type);
  1209. const newNodes = await ProjectController.addBillsByData(postData, true);
  1210. if (newNodes.length) {
  1211. projectObj.mainController.setTreeSelected(newNodes[0]);
  1212. projectObj.selectColAndFocus(project.mainTree.selected);
  1213. }
  1214. } catch (err) {
  1215. console.log(err);
  1216. if (!$('hintBox_form').is(':visible')) {
  1217. alert(err);
  1218. }
  1219. } finally {
  1220. $.bootstrapLoading.end();
  1221. }
  1222. });
  1223. },
  1224. // 注册自定义插入定额数量
  1225. registerFlexibleInsertRatoinMenu: function () {
  1226. const project = projectObj.project;
  1227. const insertRationHtml = `<span>插入定额&nbsp;&nbsp;<input id='insert-ration-number' class="menu-input" type="text" value="1" onfocus="this.select()">&nbsp;&nbsp;行</span>`;
  1228. return sheetCommonObj.registerInputContextMenuItem('insertRation', insertRationHtml, 'fa-sign-in', async function () {
  1229. try {
  1230. const number = +$('#insert-ration-number').val();
  1231. if (!number) {
  1232. return;
  1233. }
  1234. $.bootstrapLoading.start();
  1235. const newData = [];
  1236. for (let i = 0; i < number; i++) {
  1237. newData.push({ itemQuery: null, rationType: rationType.ration });
  1238. }
  1239. await project.Ration.addMultiRation(newData);
  1240. projectObj.setActiveCell('code', true);
  1241. } catch (err) {
  1242. console.log(err);
  1243. if (!$('hintBox_form').is(':visible')) {
  1244. alert(err);
  1245. }
  1246. } finally {
  1247. $.bootstrapLoading.end();
  1248. }
  1249. });
  1250. },
  1251. loadMainSpreadContextMenu: function () {
  1252. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  1253. $.contextMenu({
  1254. selector: '#billsSpread',
  1255. selectableSubMenu: true,
  1256. build: function ($trigger, e) {
  1257. projectObj.cusRationCombCheck(spread.getActiveSheet());
  1258. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  1259. controller.setTreeSelected(controller.tree.items[target.row]);
  1260. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  1261. },
  1262. items: {
  1263. "insertRootBill": {
  1264. name: "插入大项费用",
  1265. icon: 'fa-sign-in',
  1266. disabled: function () {
  1267. return projectReadOnly || (projectObj.project.isBillsLocked() && project.withinBillsLocked(project.mainTree.selected));
  1268. //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  1269. },
  1270. callback: function (key, opt) {
  1271. ProjectController.addRootBill(project, controller);
  1272. },
  1273. visible: function(key, opt){
  1274. return project.mainTree.selected&&project.mainTree.selected.parent==null;
  1275. }
  1276. },
  1277. "insertFB": {
  1278. name: "插入分部",
  1279. icon: 'fa-sign-in',
  1280. disabled: function () {
  1281. if (projectReadOnly) {
  1282. return true;
  1283. }
  1284. let selected = project.mainTree.selected;
  1285. if(projectObj.project.isBillsLocked()== false&&selected&&selected.sourceType==project.Bills.getSourceType()){
  1286. if(selected.data.type==billType.FB){
  1287. return false;
  1288. }
  1289. if(selected.data.type==billType.FX || selected.data.type==billType.BX){// 当前定位在分项(包括补项),
  1290. if(selected.preSibling){//判断分项有无前兄弟?
  1291. //有,则判断父项的类型是什么,是分部,右键有效显示,点击则按②执行。
  1292. return selected.parent.data.type!==billType.FB
  1293. }
  1294. return false;// 无,右键有效显示,
  1295. }
  1296. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  1297. if(selected.children.length>0){
  1298. return selected.children[0].data.type==billType.FX ||selected.children[0].data.type==billType.BX;//焦点行是分部分项工程,且子项是分项或补项
  1299. }else {
  1300. return false
  1301. }
  1302. }
  1303. }
  1304. return true;//除了清单,其它类型都只读
  1305. },
  1306. callback: function (key, opt) {
  1307. /* 2020-12-28 插入前先弹窗选择
  1308. let selected = project.mainTree.selected;
  1309. if(selected.data.type==billType.FX || selected.data.type==billType.BX){
  1310. //添加成分项的父亲
  1311. ProjectController.addFXParent(selected);
  1312. }else{//正常添加分部
  1313. ProjectController.addFB(project, controller);
  1314. projectObj.selectColAndFocus(project.mainTree.selected);
  1315. } */
  1316. $("#selectFBFor").val("add");
  1317. $('#selectFBDiv').modal('show');
  1318. },
  1319. visible: function(key, opt){
  1320. if(project.mainTree.selected){
  1321. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  1322. }else {
  1323. return false;
  1324. }
  1325. }
  1326. },
  1327. "insertFX": {
  1328. type: projectObj.registerFlexibleInsertBillMenu(billType.FX), // 插入分项
  1329. disabled: function () {
  1330. if (projectReadOnly) {
  1331. return true;
  1332. }
  1333. let selected = project.mainTree.selected;
  1334. if(projectObj.project.isBillsLocked()== false&& selected&&selected.sourceType==project.Bills.getSourceType()){
  1335. if(selected.data.type==billType.FX||selected.data.type==billType.BX){//焦点行是分项,有效显示
  1336. return false
  1337. }
  1338. if(selected.data.type==billType.FB){//点行是分部,
  1339. if(selected.children.length>0){//且有子项,子项是分部,灰显。
  1340. return selected.children[0].data.type == billType.FB
  1341. }else {
  1342. return false;
  1343. }
  1344. }
  1345. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  1346. if(selected.children.length>0){
  1347. return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程,且子项是分部时灰显
  1348. }else {
  1349. return false
  1350. }
  1351. }
  1352. }
  1353. return true;//除了清单,其它类型都只读
  1354. },
  1355. visible: function(key, opt){
  1356. return false
  1357. if(project.mainTree.selected){
  1358. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  1359. }else {
  1360. return false;
  1361. }
  1362. }
  1363. },
  1364. "insertBills": {
  1365. type: projectObj.registerFlexibleInsertBillMenu(billType.BILL), // 插入清单
  1366. disabled: function () {
  1367. if (projectReadOnly) {
  1368. return true;
  1369. }
  1370. let selected = project.mainTree.selected;
  1371. if(!(projectObj.project.isBillsLocked()== true && project.withinBillsLocked(selected)) && selected && selected.sourceType === project.Bills.getSourceType()){
  1372. return false
  1373. }
  1374. return true;
  1375. },
  1376. visible: function(key, opt){
  1377. return false
  1378. if(project.mainTree.selected){
  1379. return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;
  1380. }else {
  1381. return false;
  1382. }
  1383. }
  1384. },
  1385. "spr1": '--------',
  1386. "insertRation": {
  1387. type: projectObj.registerFlexibleInsertRatoinMenu(), // 插入定额
  1388. disabled: function () {
  1389. if (projectReadOnly) {
  1390. return true;
  1391. }
  1392. // var selected = project.mainTree.selected;
  1393. // return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  1394. // 工具栏要加按钮,且不能隐藏。菜单可以隐藏,两者又必须统一,所以启用新规则。怕以后又要改回来,所以保留。 CSL, 2018-01-02
  1395. return !project.Ration.canAdd(project.mainTree.selected);
  1396. },
  1397. },
  1398. "insertLJ": {
  1399. name: "插入量价",//插入量价不需要自动定位到编号列
  1400. icon: 'fa-sign-in',
  1401. disabled: function () {
  1402. if (projectReadOnly) {
  1403. return true;
  1404. }
  1405. return !project.Ration.canAdd(project.mainTree.selected);
  1406. },
  1407. callback: function (key, opt) {
  1408. /* project.Ration.addNewRation(null,rationType.volumePrice,function (newNode) {
  1409. projectObj.selectColAndFocus(newNode,null);
  1410. },true);*/
  1411. },
  1412. items:{
  1413. insertLabour:{
  1414. name: "人工",
  1415. icon: 'fa-sign-in',
  1416. callback:function(key){
  1417. project.Ration.insertVolumePrice(gljType.LABOUR);
  1418. }
  1419. },
  1420. insertMaterial:{
  1421. name:"材料" ,
  1422. icon: 'fa-sign-in',
  1423. callback:function(key){
  1424. project.Ration.insertVolumePrice(gljType.GENERAL_MATERIAL);
  1425. }
  1426. },
  1427. insertMachine:{
  1428. name:"机械" ,
  1429. icon: 'fa-sign-in',
  1430. callback:function(key){
  1431. project.Ration.insertVolumePrice(gljType.GENERAL_MACHINE);
  1432. }
  1433. },
  1434. insertMainMaterial:{
  1435. name:"主材" ,
  1436. icon: 'fa-sign-in',
  1437. callback:function(key){
  1438. project.Ration.insertVolumePrice(gljType.MAIN_MATERIAL);
  1439. }
  1440. },
  1441. insertEquipment:{
  1442. name:"设备" ,
  1443. icon: 'fa-sign-in',
  1444. visible: function () {
  1445. if (typeof isCQ2018 != 'undefined') {
  1446. return false;
  1447. }else{
  1448. return true;
  1449. }
  1450. },
  1451. callback:function(key){
  1452. project.Ration.insertVolumePrice(gljType.EQUIPMENT);
  1453. }
  1454. }
  1455. }
  1456. },
  1457. "insertGLJ": {
  1458. name: "插入人材机",
  1459. icon: 'fa-sign-in',
  1460. disabled: function () {
  1461. if (projectReadOnly) {
  1462. return true;
  1463. }
  1464. // var selected = project.mainTree.selected;
  1465. // return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  1466. return !project.Ration.canAdd(project.mainTree.selected);
  1467. },
  1468. callback: function (key, opt) {
  1469. var selected = project.mainTree.selected;
  1470. if(selected.sourceType == ModuleNames.bills){
  1471. if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
  1472. if(selected.data.calcBase&&selected.data.calcBase!=""){
  1473. alert("当前有基数计算,不能插入定额/量价/人材机。");
  1474. return;
  1475. }
  1476. }
  1477. }
  1478. getGLJData('insert', null, true, null);// ProjectController.addRation(project, controller, rationType.volumePrice);
  1479. },
  1480. visible: function(key, opt){//2018-11-08 新需求,这个按钮先隐藏,有需要再放开
  1481. return true;
  1482. }
  1483. },
  1484. "insertMainMaterial": {
  1485. name: "按清单名称插入主材",//插入量价不需要自动定位到编号列
  1486. icon: 'fa-sign-in',
  1487. disabled: function () {
  1488. if (projectReadOnly) {
  1489. return true;
  1490. }
  1491. return !project.Ration.canAdd(project.mainTree.selected);
  1492. },
  1493. callback: function (key, opt) {
  1494. //名称取清单名称,单位取清单单位
  1495. let selected = project.mainTree.selected;
  1496. let billNode = selected;
  1497. if(selected.sourceType==project.Ration.getSourceType()) billNode = selected.parent;
  1498. let ext = {name:billNode.data.name,unit:billNode.data.unit};
  1499. project.Ration.insertVolumePrice(gljType.MAIN_MATERIAL,ext);
  1500. },
  1501. },
  1502. "spr2": '--------',
  1503. "calc_installation_fee": {
  1504. name: "计取安装费用",
  1505. icon: 'fa-sign-in',
  1506. disabled: function () {
  1507. if (projectReadOnly) {
  1508. return true;
  1509. }
  1510. return false;
  1511. },
  1512. callback: function (key, opt) {
  1513. installationFeeObj.showCalcInstallSettingDiv();
  1514. },
  1515. visible: function(key, opt){
  1516. return projectObj.project.isInstall();
  1517. }
  1518. },
  1519. "calcOverHeightFee": {
  1520. name: '超高降效费用',
  1521. icon: 'fa-sign-in',
  1522. visible: function () {
  1523. return projectObj.project.isOverHeightProject();
  1524. },
  1525. items: {
  1526. 'calcOverHeight': {
  1527. name: '计取超高降效',
  1528. icon: 'fa-sign-in',
  1529. disabled: function () {
  1530. return projectReadOnly;
  1531. },
  1532. callback: function (key, opt) {
  1533. OVER_HEIGHT.switchVisible(true);
  1534. }
  1535. },
  1536. 'setOption': {
  1537. name: '设置子目生成方式',
  1538. icon: 'fa-sign-in',
  1539. disabled: function () {
  1540. return projectReadOnly;
  1541. },
  1542. callback: function (key, opt) {
  1543. $('#overHeightOpt').modal('show');
  1544. }
  1545. },
  1546. 'cancelOverHeight': {
  1547. name: '取消超高降效',
  1548. icon: 'fa-sign-in',
  1549. disabled: function () {
  1550. return projectReadOnly;
  1551. },
  1552. callback: function (key, opt) {
  1553. OVER_HEIGHT.cancelCalc();
  1554. }
  1555. },
  1556. }
  1557. },
  1558. "cleanzmhs":{
  1559. name:'清空子目换算',
  1560. icon: 'fa-remove',
  1561. callback: function (key, opt) {
  1562. let selected = project.mainTree.selected;
  1563. projectObj.project.Ration.updateRationCodes([{'node':selected, value:selected.data.code}],true);
  1564. },
  1565. visible: function(key, opt){
  1566. let selected = project.mainTree.selected;
  1567. if (selected && selected.sourceType == ModuleNames.ration) {
  1568. return true;
  1569. }
  1570. return false;
  1571. },
  1572. disabled: function () {
  1573. let selected = project.mainTree.selected;
  1574. if (projectReadOnly) {
  1575. return true;
  1576. }
  1577. if(selected && selected.data.type != rationType.ration){
  1578. return true;
  1579. }
  1580. return false;
  1581. },
  1582. },
  1583. "areaIncreaseFee":{
  1584. name:"面积增加费",
  1585. icon: 'fa-sign-in',
  1586. visible:function () {
  1587. return projectObj.project.property.isAreaIncrease == true;
  1588. },
  1589. items:{
  1590. "calcAreaIncreaseFee":{
  1591. name:"计取面积增加费",
  1592. icon: 'fa-sign-in',
  1593. callback:function () {
  1594. areaIncreaseFeeObj.setDefaultSetting();
  1595. colSettingObj.setVisible('areaIncreaseFee', true);
  1596. colSettingObj.updateColSetting(true);
  1597. }
  1598. },
  1599. "setArea":{
  1600. name:"设置调整系数",
  1601. icon: 'fa-sign-in',
  1602. callback:function(){
  1603. $("#areaIncreaseFeeDiv").modal('show');
  1604. }
  1605. },
  1606. "cancelAreaIncreaseFee":{
  1607. name:"取消面积增加费",
  1608. icon: 'fa-sign-in',
  1609. callback:function(){
  1610. colSettingObj.setVisible('areaIncreaseFee', false);
  1611. colSettingObj.updateColSetting(true);
  1612. areaIncreaseFeeObj.cancelAreaIncreaseFee();
  1613. }
  1614. }
  1615. }
  1616. },
  1617. "itemIncreaseFee":{
  1618. name:"子目增加费",
  1619. icon: 'fa-sign-in',
  1620. visible:function () {
  1621. return projectObj.project.property.isItemIncrease == true;
  1622. },
  1623. items:{
  1624. "setItem":{
  1625. name:"设置范围",
  1626. icon: 'fa-sign-in',
  1627. callback:function(){
  1628. $("#itemIncreaseFeeDiv").modal('show');
  1629. }
  1630. },
  1631. "cancelAreaIncreaseFee":{
  1632. name:"取消子目增加费",
  1633. icon: 'fa-sign-in',
  1634. callback:function(){
  1635. itemIncreaseFeeObj.cancelItemIncreaseFee();
  1636. }
  1637. }
  1638. }
  1639. },
  1640. "setBookMark": {
  1641. name: '设置书签批注',
  1642. icon: 'fa-flag',
  1643. disabled: function () {
  1644. if (projectReadOnly || !project.mainTree.selected || project.mainTree.selected.sourceType == ModuleNames.ration_glj) {
  1645. return true;
  1646. }
  1647. return false
  1648. },
  1649. items: {
  1650. cancelMark: {
  1651. name: '取消书签批注',
  1652. icon: 'fa-remove',
  1653. disabled: function () {
  1654. const selected = project.mainTree.selected;
  1655. return !(selected && selected.data.bookmarkBackground);
  1656. },
  1657. callback: function () {
  1658. locateObject.setOrCancelBookmark(project.mainTree.selected, null);
  1659. }
  1660. },
  1661. markE2F2C5: {
  1662. name: function () {
  1663. return locateObject.getDescribeByColor('E2F2C5');
  1664. },
  1665. icon: 'fa-square annotate-color-1',
  1666. callback: function () {
  1667. locateObject.setOrCancelBookmark(project.mainTree.selected, 'E2F2C5');
  1668. }
  1669. },
  1670. markF9E2CF: {
  1671. name: function () {
  1672. return locateObject.getDescribeByColor('F9E2CF');
  1673. },
  1674. icon: 'fa-square annotate-color-2',
  1675. callback: function () {
  1676. locateObject.setOrCancelBookmark(project.mainTree.selected, 'F9E2CF');
  1677. }
  1678. },
  1679. markF2EFD9: {
  1680. name: function () {
  1681. return locateObject.getDescribeByColor('F2EFD9');
  1682. },
  1683. icon: 'fa-square annotate-color-3',
  1684. callback: function () {
  1685. locateObject.setOrCancelBookmark(project.mainTree.selected, 'F2EFD9');
  1686. }
  1687. },
  1688. markF5D1DA: {
  1689. name: function () {
  1690. return locateObject.getDescribeByColor('F5D1DA');
  1691. },
  1692. icon: 'fa-square annotate-color-4',
  1693. callback: function () {
  1694. locateObject.setOrCancelBookmark(project.mainTree.selected, 'F5D1DA');
  1695. }
  1696. },
  1697. markE3E3E3: {
  1698. name: function () {
  1699. return locateObject.getDescribeByColor('E3E3E3');
  1700. },
  1701. icon: 'fa-square annotate-color-5',
  1702. callback: function () {
  1703. locateObject.setOrCancelBookmark(project.mainTree.selected, 'E3E3E3');
  1704. }
  1705. },
  1706. markB6F3F2: {
  1707. name: function () {
  1708. return locateObject.getDescribeByColor('B6F3F2');
  1709. },
  1710. icon: 'fa-square annotate-color-6',
  1711. callback: function () {
  1712. locateObject.setOrCancelBookmark(project.mainTree.selected, 'B6F3F2');
  1713. }
  1714. },
  1715. markECE0F5: {
  1716. name: function () {
  1717. return locateObject.getDescribeByColor('ECE0F5');
  1718. },
  1719. icon: 'fa-square annotate-color-7',
  1720. callback: function () {
  1721. locateObject.setOrCancelBookmark(project.mainTree.selected, 'ECE0F5');
  1722. }
  1723. },
  1724. }
  1725. },
  1726. "delete": {
  1727. name: '删除',
  1728. icon: 'fa-remove',
  1729. disabled: function () {
  1730. return !ifCanDelete();
  1731. },
  1732. callback: function () {
  1733. var selected = project.mainTree.selected;
  1734. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  1735. project.Bills.deleteSelectedNodes();//project.Bills.deleteSelectedNode();
  1736. }else {
  1737. $("#delete_row").modal({show:true});//弹出删除提示框;
  1738. }
  1739. }
  1740. },
  1741. "calculateAll_RationContent": {
  1742. name: '造价计算',
  1743. icon: 'fa-calculator',
  1744. callback: function () {
  1745. $.bootstrapLoading.start();
  1746. setTimeout(function(){
  1747. project.calcProgram.calcAllNodesAndSave();
  1748. $.bootstrapLoading.end();
  1749. },100)
  1750. },
  1751. disabled: function () {
  1752. if (projectReadOnly) {
  1753. return true;
  1754. }
  1755. },
  1756. visible:function(key, opt){//2018-11-15 新需求隐藏右键“造价计算”。
  1757. return true;
  1758. }
  1759. },
  1760. "spr4":'--------',
  1761. "copyBlock": {
  1762. name: '复制整块',
  1763. icon: 'fa-copy',
  1764. disabled: function () {
  1765. /* if (projectReadOnly) {
  1766. return true;
  1767. }
  1768. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  1769. let firstNode = projectObj.project.mainTree.items[selection.row];//当多选的情况,用mainTree.selected判断不正确,要用第一个选中的节点
  1770. for(let i = 0;i< selection.rowCount;i++){ //多选的时候判断所有与第一个节点同级的节点
  1771. let temNode = projectObj.project.mainTree.items[selection.row + i];
  1772. if(firstNode.getParentID() == temNode.getParentID()){
  1773. if(BlockController.copyBtnDisable(temNode) == true){
  1774. return true;
  1775. }
  1776. }
  1777. }
  1778. return false; */
  1779. return BlockController.disabelCopyRightClick();
  1780. },
  1781. callback: function () {
  1782. $.bootstrapLoading.start();
  1783. //let selected = project.mainTree.selected;
  1784. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1785. setTimeout(function () {
  1786. BlockController.copyBlock(selections[0]);
  1787. $.bootstrapLoading.end();
  1788. },100)
  1789. }
  1790. },
  1791. "pasteBlock": {
  1792. name: '粘贴整块',
  1793. icon: 'fa-paste',
  1794. disabled: function (){
  1795. if (projectReadOnly) {
  1796. return true;
  1797. }
  1798. return BlockController.pasteBtnDisable(project.mainTree.selected);
  1799. },
  1800. callback: function () {
  1801. BlockController.pasteBlock(project.mainTree.selected);
  1802. }
  1803. },
  1804. "recoverDeletedNodes": {
  1805. name: '恢复删除节点',
  1806. icon: 'fa-undo',
  1807. disabled: function (){
  1808. return BlockController.recoverBlockDisabled();
  1809. },
  1810. callback: function () {
  1811. BlockController.recoverBlock();
  1812. }
  1813. },
  1814. "editEngineer": {
  1815. name: '编辑工程内容',
  1816. icon: 'fa-edit',
  1817. disabled: function () {
  1818. return projectReadOnly;
  1819. },
  1820. visible: function(key, opt){
  1821. let selected = project.mainTree.selected;
  1822. return selected.sourceType==ModuleNames.bills&&project.Bills.isEngineerEst(selected);//当焦点行是“专业工程暂估价”时,右键可见并有效。
  1823. },
  1824. callback: function () {
  1825. let node = project.mainTree.selected;//project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.ENGINEERING_ESITIMATE);
  1826. if(node){
  1827. projectObj.editContent(node,'engineeringContent');
  1828. }
  1829. }
  1830. },
  1831. "editService": {
  1832. name: '编辑服务内容',
  1833. icon: 'fa-edit',
  1834. disabled: function () {
  1835. return projectReadOnly;
  1836. },
  1837. visible: function(key, opt){
  1838. let selected = project.mainTree.selected;
  1839. return selected.sourceType==ModuleNames.bills&&project.Bills.isTotalService(selected);//当焦点行是“总承包服务费”时,右键可见并有效。
  1840. },
  1841. callback: function () {
  1842. let node = project.mainTree.selected;//project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.TURN_KEY_CONTRACT);
  1843. if(node){
  1844. projectObj.editContent(node,'serviceContent');
  1845. }
  1846. }
  1847. },
  1848. "editAccording": {
  1849. name: '编辑签证及索赔依据',
  1850. icon: 'fa-edit',
  1851. disabled: function () {
  1852. return projectReadOnly;
  1853. },
  1854. visible: function(key, opt){
  1855. let selected = project.mainTree.selected;
  1856. return selected.sourceType==ModuleNames.bills&&project.Bills.isClaimVisa(selected);//当焦点行是“签证及索赔计价”时,右键可见并有效。
  1857. },
  1858. callback: function () {
  1859. let node = project.mainTree.selected;//project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.CLAIM_VISA);
  1860. if(node){
  1861. projectObj.editContent(node,'claimVisa');
  1862. }
  1863. }
  1864. },
  1865. "replaceMaterial":{
  1866. name:'智能材料替换',
  1867. icon: 'fa-edit',
  1868. disabled:function (key,opt) {
  1869. if (projectReadOnly) {
  1870. return true;
  1871. }
  1872. let selected = project.mainTree.selected;
  1873. return selected.sourceType==ModuleNames.bills ?!(project.Bills.isFXorBX(selected)||selected.source.children.length ==0):true//是分项、补项或叶子清单才有效;
  1874. },
  1875. callback:function(){
  1876. MaterialController.replaceMaterial([project.mainTree.selected]);
  1877. },
  1878. visible: function(key, opt){//2018-11-15 暂时隐藏
  1879. return false
  1880. }
  1881. },
  1882. "createBlocks":{
  1883. name:'生成组价模板',
  1884. icon: 'fa-puzzle-piece',
  1885. disabled:function (key,opt) {
  1886. if (projectReadOnly) {
  1887. return true;
  1888. }
  1889. let selected = project.mainTree.selected;
  1890. return selected.sourceType != ModuleNames.bills;
  1891. },
  1892. callback: function(){
  1893. blockLibObj.checkShow();
  1894. },
  1895. visible: function(key, opt){
  1896. return G_SHOW_BLOCK_LIB;
  1897. }
  1898. }
  1899. }
  1900. });
  1901. },
  1902. // 计算node及node的所有父项
  1903. converseCalculateBills: function (node) {
  1904. projectObj.project.calcProgram.calcAndSave(node);
  1905. },
  1906. // 获取上次退出时的焦点位置
  1907. loadFocusLocation: function(orow,ocol) {
  1908. const projectId = scUrlUtil.GetQueryString('project');
  1909. let row = gljUtil.isDef(orow)?orow:getLocalCache('lastRow:' + projectId);
  1910. let col = gljUtil.isDef(ocol)?ocol:getLocalCache('lastCol:' + projectId);
  1911. if(row == null || col == null){
  1912. //默认焦点定位到造价书的第一行“分项”。
  1913. col = 1;
  1914. row = 0;
  1915. for(let i =0;i<this.mainController.tree.items.length;i++){
  1916. let node = this.mainController.tree.items[i];
  1917. if(node && node.sourceType == ModuleNames.bills && (node.data.type === billType.FX ||node.data.type === billType.BX )){//默认字位到第一条分项或补项
  1918. row = i;
  1919. break;
  1920. }
  1921. }
  1922. }
  1923. row = parseInt(row);
  1924. col = parseInt(col);
  1925. const sheet = this.mainSpread.getActiveSheet();
  1926. sheet.setSelection(row, col, 1, 1);
  1927. row=row<this.mainController.tree.items.length?row:0;
  1928. this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
  1929. sheet.showRow(row, GC.Spread.Sheets.VerticalPosition.center);
  1930. },
  1931. // 选中区域合计数字
  1932. amountAreaNumber: function(e, info) {
  1933. if (info.newSelections === undefined || info.newSelections.length <= 0) {
  1934. return false;
  1935. }
  1936. const selectedArea = info.newSelections[0];
  1937. const sheet = info.sheet;
  1938. if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
  1939. return false;
  1940. }
  1941. //获取最左最右坐标
  1942. let maxCell = {row: selectedArea.row, col: selectedArea.col + selectedArea.colCount};
  1943. let maxCellX = sheet.getCellRect(maxCell.row, maxCell.col).x ? sheet.getCellRect(maxCell.row, maxCell.col).x : sheet.getCellRect(maxCell.row, maxCell.col - 1).x;
  1944. let minCell = {row: selectedArea.row, col: selectedArea.col};
  1945. let minCellX = sheet.getCellRect(minCell.row, minCell.col).x ? sheet.getCellRect(minCell.row, minCell.col).x : sheet.getCellRect(minCell.row, minCell.col + 1).x;
  1946. // 获取鼠标位置
  1947. let x = window.event.clientX;
  1948. let y = window.event.clientY;
  1949. // 匹配数字或小数
  1950. const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
  1951. // 小数点最高位数
  1952. let max = 0;
  1953. let total = 0;
  1954. let counter = 0;
  1955. let notNumber = false; //如果有非数字,则不显示
  1956. for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
  1957. for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
  1958. const value = sheet.getCell(row, col).text();
  1959. if (!regular.test(value)) {
  1960. if(value) notNumber = true;
  1961. continue;
  1962. }
  1963. counter++;
  1964. // 获取当前数据小数位数
  1965. let pointPosition = value.toString().indexOf(".");
  1966. pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
  1967. const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
  1968. max = current > max ? current : max;
  1969. total += parseFloat(value);
  1970. }
  1971. }
  1972. //选中的都是数字, 如果不为0则悬浮显示
  1973. if (notNumber === false && total > 0 && counter > 1) {
  1974. 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>');
  1975. div.css({
  1976. position: "absolute",
  1977. border: "1px #C0C0C0 solid",
  1978. background: "#fff",
  1979. boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
  1980. });
  1981. div.children("p").css({
  1982. textAlign: "center",
  1983. padding: 8,
  1984. marginBottom: 2,
  1985. });
  1986. div.children("p").first().css({
  1987. borderBottom: "1px #C0C0C0 solid"
  1988. });
  1989. const totalString = total.toFixed(max);
  1990. // input长度
  1991. const inputWidth = totalString.length * 8;
  1992. // 计算是否会超出显示范围
  1993. const baseWidth = 48;
  1994. const baseHeight = 81;
  1995. const canvasWidth = $("#billsSpreadvp_vp").width();
  1996. const canvasHeight = $("#billsSpreadvp_vp").height();
  1997. //x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
  1998. x = maxCellX + baseWidth + inputWidth > canvasWidth ? minCellX - baseWidth - inputWidth : maxCellX + baseWidth;
  1999. y = y + baseHeight > canvasHeight ? y - baseHeight : y;
  2000. //test
  2001. let testT = sheet.getParent().hitTest(x, y);
  2002. //test
  2003. div.css({
  2004. left: x,
  2005. top: y,
  2006. });
  2007. div.children().children("#total").width(inputWidth).val(totalString);
  2008. $("body").append(div);
  2009. // 用于判断是否要关闭窗体
  2010. setTimeout(function() {
  2011. isTotalShowing = true;
  2012. }, 200);
  2013. };
  2014. },
  2015. onButtonClick: function (e, info) {
  2016. let colSetting = projectObj.mainController.setting.cols[info.col];
  2017. let node = projectObj.project.mainTree.items[info.row];
  2018. let fieldName = colSetting.data.field;
  2019. if(fieldName == "isSubcontract"){
  2020. projectObj.onSubcontractClick(node);
  2021. }else if(fieldName == "isEstimate"){
  2022. projectObj.onIsEstimateClick(node,info);
  2023. }else if(fieldName == "evaluationProject"){
  2024. projectObj.onEvaluationProjectClic(node,info);
  2025. }else if(fieldName == "mainBills"||fieldName == "outPutMaxPrice"||fieldName=="outPutLimitPrice"||fieldName=="areaIncreaseFee"||fieldName == "lockUnitPrice"){
  2026. projectObj.onCasCadeButtonClick(node,info,fieldName);
  2027. }
  2028. },
  2029. onEvaluationProjectClic:function (node,info) {
  2030. let checkboxValue = info.sheet.getCell(info.row, info.col).value();
  2031. let newval = checkboxValue?0:1;
  2032. projectObj.project.updateEvalproject(newval,node.data,function (programID) {
  2033. node.data.evaluationProject = newval;
  2034. node.data.programID = programID;
  2035. node.changed=true;
  2036. projectObj.project.calcProgram.calcAndSave(node);
  2037. })
  2038. },
  2039. onIsEstimateClick: function(node,info){
  2040. let checkboxValue = info.sheet.getCell(info.row, info.col).value();
  2041. let cell = info.sheet.getCell(info.row, info.col), newval = 0;
  2042. if (checkboxValue) {
  2043. newval = 0;
  2044. cell.value(newval);
  2045. } else {
  2046. newval = 1;
  2047. cell.value(newval);
  2048. }
  2049. if(MainTreeCol.readOnly.bills(node)){
  2050. projectObj.updateNodeField(node,newval,'isEstimate');
  2051. }else if(node.data.projectGLJID){//更新的是定额类型的工料机或者是显示在造价书页面的主材、设备
  2052. console.log(node);
  2053. let updateData = {id: node.data.projectGLJID, field: 'is_evaluate', value: newval};
  2054. projectObj.project.projectGLJ.pGljUpdate(updateData);
  2055. }
  2056. },
  2057. /* onMainBillsClick:function (node,info) {//清单有三种状态,true,false,null。 打勾:true, 不打勾 false 子项有打勾和不打勾的情况 null
  2058. let checkboxValue = info.sheet.getCell(info.row, info.col).value();
  2059. let cell = info.sheet.getCell(info.row, info.col), newval = true;
  2060. if (checkboxValue == true) {
  2061. newval = false;
  2062. } else {
  2063. newval = true;
  2064. }
  2065. projectObj.project.updateMainBills(node,newval);
  2066. },*/
  2067. onCasCadeButtonClick:function (node,info,fieldName) {
  2068. let checkboxValue = info.sheet.getCell(info.row, info.col).value();
  2069. let cell = info.sheet.getCell(info.row, info.col), newval = true;
  2070. if (checkboxValue == true) {
  2071. newval = false;
  2072. } else {
  2073. newval = true;
  2074. }
  2075. if(fieldName == "areaIncreaseFee"){
  2076. areaIncreaseFeeObj.casCadeUpdate(node,newval,fieldName);
  2077. } else {
  2078. projectObj.project.updateCasCadeBills(node,newval,fieldName,fieldName != "lockUnitPrice");
  2079. }
  2080. },
  2081. onSubcontractClick:function (node) {//点击分包费checkbox
  2082. if (node.data.isSubcontract) node.data.isSubcontract = false;
  2083. else node.data.isSubcontract = true;
  2084. node.changed = true;
  2085. projectObj.project.calcProgram.calcAndSave(node);
  2086. },
  2087. //根据节点获取行style(颜色、字体加粗)
  2088. getNodeColorStyle: function (sheet, node, tree) {
  2089. let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
  2090. let mapping = {DEFAULT: 'DEFAULT', SELECTED: 'SELECTED', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
  2091. FX: 'FX', BX: 'BX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
  2092. let styleMap = null;
  2093. tree?'':tree = this.project.mainTree;
  2094. //中文字段名,由于同一节点中,中文字体大小和数字字体大小不同
  2095. if(colorSetting == null){
  2096. return null;
  2097. }
  2098. let stringFields = [
  2099. 'code',
  2100. 'subType',
  2101. 'name',
  2102. 'unit',
  2103. 'itemCharacterText',
  2104. 'jobContentText',
  2105. 'adjustState',
  2106. 'calcBase',
  2107. 'programID',
  2108. 'ruleText'
  2109. ];
  2110. if(!isDef(node)){
  2111. return null;
  2112. }
  2113. //清单大类
  2114. if(node.sourceType === this.project.Bills.getSourceType()){
  2115. //大项费用
  2116. if(node.data.type === billType.DXFY){
  2117. styleMap = mapping.DXFY;
  2118. }
  2119. //分部
  2120. if(node.data.type === billType.FB){
  2121. styleMap = mapping.FX;
  2122. }
  2123. //分项
  2124. else if(node.data.type === billType.FX){
  2125. styleMap = mapping.FB;
  2126. }
  2127. //补项
  2128. else if(node.data.type === billType.BX){
  2129. styleMap = mapping.BX;
  2130. }
  2131. //清单
  2132. else if(node.data.type === billType.BILL){
  2133. //非叶子节点的清单
  2134. if(node.source.children.length > 0){
  2135. styleMap = mapping.UNCBBILL;
  2136. // styleMap = mapping.UNLEAFBILL;
  2137. }
  2138. //未使用基数计算的叶子节点的清单
  2139. else if(node.source.children.length === 0 && (!isDef(node.data.calcBase) || node.data.calcBase === '')){
  2140. // styleMap = mapping.UNCBBILL;
  2141. styleMap = mapping.UNLEAFBILL;
  2142. }
  2143. //使用基数计算的叶子节点的清单
  2144. else if(node.source.children.length === 0 && isDef(node.data.calcBase && node.data.calcBaseValue !== '')){
  2145. // styleMap = mapping.CBBILL;
  2146. styleMap = mapping.UNLEAFBILL;
  2147. }
  2148. }
  2149. }
  2150. //定额下的主材、设备
  2151. else if(node.sourceType === this.project.ration_glj.getSourceType()){
  2152. styleMap = mapping.ZCSB;
  2153. }
  2154. else {
  2155. styleMap = mapping.DEFAULT;
  2156. }
  2157. let styleSetting = colorSetting[styleMap];
  2158. let defaultSetting = colorSetting[mapping.DEFAULT];
  2159. if(!isDef(styleSetting)){
  2160. return null;
  2161. }
  2162. let style = new GC.Spread.Sheets.Style();
  2163. //设置style属性
  2164. for(let attr in styleSetting){
  2165. if(attr !== 'stringFont' && attr !== 'numFont'){
  2166. style[attr] = styleSetting[attr] === 'default' || !isDef(styleSetting[attr]) ? defaultSetting[attr] : styleSetting[attr];
  2167. }
  2168. //暂时不开放字体设置,开放的话只能每个单元格进入此方法
  2169. /* else {
  2170. if(stringFields.indexOf(colSetting.data.field) > 0){
  2171. style.font = styleSetting.stringFont === 'default' || !isDef(styleSetting.stringFont) ? defaultSetting.stringFont : styleSetting.stringFont;
  2172. }
  2173. else {
  2174. style.font = styleSetting.numFont === 'default' || !isDef(styleSetting.numFont) ? defaultSetting.numFont : styleSetting.numFont;
  2175. }
  2176. }*/
  2177. }
  2178. //选中行-替换底色
  2179. if(node === tree.selected){
  2180. style.backColor = colorSetting[mapping.SELECTED]['backColor'];
  2181. }
  2182. if(_ && !_.isEmpty(node.data.bookmarkBackground)) style.backColor = "#"+ node.data.bookmarkBackground;//设置书签和批注背景色
  2183. //大项费用加粗(数字与中文字符大小不一问题由字体造成,暂时不考虑分别设置大小)
  2184. /* if(node.sourceType === this.project.Bills.getSourceType() && node.data.type === billType.DXFY){
  2185. style.font = 'bold 14px Arial';
  2186. }*/
  2187. style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  2188. style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  2189. style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  2190. style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  2191. return style;
  2192. },
  2193. //大项费用则字体加粗,String 15px, Number 13px
  2194. getBoldFontStyle: function (node, colSetting) {
  2195. let style = new GC.Spread.Sheets.Style();
  2196. if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
  2197. return null;
  2198. }
  2199. //备注暂无字段
  2200. let stringFields = [
  2201. 'code',
  2202. 'subType',
  2203. 'name',
  2204. 'unit',
  2205. 'itemCharacterText',
  2206. 'jobContentText',
  2207. 'adjustState',
  2208. 'calcBase',
  2209. 'programID',
  2210. 'ruleText'
  2211. ];
  2212. style.font = 'bold 14px Arial';
  2213. return style;
  2214. },
  2215. //设置节点style
  2216. setNodesStyle: function (sheet, nodes,tree) {
  2217. let me = this;
  2218. TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
  2219. for(let node of nodes){
  2220. if(node && node.serialNo()!= -1){
  2221. sheet.getRange(node.serialNo(), -1, 1, -1).backColor(me.getNodeColorStyle(sheet, node,tree)?me.getNodeColorStyle(sheet, node,tree).backColor:null);
  2222. }
  2223. }
  2224. });
  2225. },
  2226. loadLockBillsButton:function () {
  2227. if(projectObj.project.projectInfo.property.lockBills == true){
  2228. //$("a[name='lockBills']").attr("data-original-title","解锁清单");
  2229. $("a[name='lockBills']").html('<i class="fa fa-unlock-alt" aria-hidden="true"></i> 解锁清单');
  2230. }else {
  2231. //$("a[name='lockBills']").attr("data-original-title","锁定清单");
  2232. $("a[name='lockBills']").html('<i class="fa fa-lock" aria-hidden="true"></i> 锁定清单');
  2233. }
  2234. },
  2235. editContent:function (node,fieldID) {//右键编辑工程内容、服务内容、签证及索赔依据
  2236. let infoText = "请输入";
  2237. switch (fieldID){
  2238. case "engineeringContent":
  2239. infoText +='工程内容:';
  2240. break;
  2241. case "serviceContent":
  2242. infoText +='服务内容:';
  2243. break;
  2244. case "claimVisa":
  2245. infoText +='签证及索赔依据:';
  2246. break;
  2247. }
  2248. hintBox.valueBox(infoText, node.data[fieldID], function () {
  2249. let newValue = hintBox.value;
  2250. projectObj.updateNodeField(node,newValue,fieldID);
  2251. },3);
  2252. },
  2253. ifItemCharHiden:function (setting) {//项目特征及内容列是否隐藏
  2254. if(this.itemCol == null||this.itemCol == undefined){
  2255. this.itemCol = _.find(setting.cols,function (item) {
  2256. return item.data.field == "itemCharacterText";
  2257. })
  2258. }
  2259. return !this.itemCol.visible;
  2260. },
  2261. onCommonTotalFeeButtonClick:function(hitinfo) {
  2262. let me = calcBaseView;
  2263. if(hitinfo.sheet.getParent() === projectObj.mainSpread){
  2264. let node = projectObj.project.mainTree.items[hitinfo.row] ? projectObj.project.mainTree.items[hitinfo.row] : null;
  2265. projectObj.mainController.setTreeSelected(node);
  2266. }
  2267. hitinfo.sheet.setActiveCell(hitinfo.row, hitinfo.col);
  2268. calcBaseView.confirmBtn.attr('toggle', 'commonTotalFee');
  2269. changeCalcBaseFeeRate('commonTotalFee');
  2270. $('#tabCalcBase').tab('show');
  2271. let field = projectObj.mainController.setting.cols[hitinfo.col].data.field;
  2272. calcBaseView.initCalctor('bills',field);
  2273. feeRateObject.showSelectModal(hitinfo);
  2274. },
  2275. selectColAndFocus :function (newNode,field = 'code') {//选中单元格并设置焦点
  2276. if(newNode){
  2277. if(field != null) projectObj.mainController.sheet.setSelection(newNode.serialNo(), colSettingObj.getColByField(field), 1, 1); //自动定位到编号单元格
  2278. projectObj.mainSpread.focus();
  2279. }
  2280. },
  2281. cusRationCombCheck:function (sheet) {//检查自定义定额编号下拉框,右键的时候不自动消失,现手动结束编辑,并删除元素
  2282. if(sheet.isEditing()){
  2283. sheet.endEdit()
  2284. }
  2285. if($("#rationCheckBox").is(':visible')) $("#rationCheckBox").parent().parent().remove();
  2286. }
  2287. };
  2288. // 点击合计框中的复制
  2289. $("body").on("click", "#total-tips a", function() {
  2290. const totalElement = $(this).parent().siblings("p").find("#total");
  2291. totalElement.select();
  2292. document.execCommand("Copy");
  2293. $(this).text("已复制");
  2294. });
  2295. // 合计框点击其他位置关闭
  2296. let isTotalShowing = false;
  2297. $("body").on("click", function(e) {
  2298. if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
  2299. $("#total-tips").remove();
  2300. isTotalShowing = false;
  2301. }
  2302. });
  2303. $('#insert').click(function () {
  2304. var controller = projectObj.mainController, project = projectObj.project;
  2305. var selected = controller.tree.selected;
  2306. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  2307. ProjectController.addBills(project, controller);
  2308. } else if (selected.sourceType === project.Ration.getSourceType()) {
  2309. ProjectController.addRation(project, controller, selected.data.type);
  2310. };
  2311. });
  2312. $('#delete').click(function () {
  2313. let project = projectObj.project;
  2314. let selected = project.mainTree.selected;
  2315. if(isSingleSelect()&&selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  2316. project.Bills.deleteSelectedNode();
  2317. }else {
  2318. $("#delete_row").modal({show:true});//弹出删除提示框;
  2319. }
  2320. });
  2321. $('#upLevel').click(function () {
  2322. var controller = projectObj.mainController, project = projectObj.project;
  2323. var selected = controller.tree.selected, orgParent = selected.parent;
  2324. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  2325. project.Bills.upLevelBills(selected.source);
  2326. controller.upLevel();
  2327. controller.refreshTreeNode([orgParent]);
  2328. projectObj.project.calcProgram.calcNodesAndSave([selected,orgParent]);
  2329. }
  2330. });
  2331. $('#downLevel').click(function () {
  2332. var controller = projectObj.mainController, project = projectObj.project;
  2333. var selected = controller.tree.selected;
  2334. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  2335. project.Bills.downLevelBills(selected.source);
  2336. controller.downLevel();
  2337. controller.refreshTreeNode([selected.parent]);
  2338. projectObj.converseCalculateBills(selected.parent);
  2339. }
  2340. });
  2341. $('#insertRation').click(function () {
  2342. // projectObj.project.Ration.addNewRation(null,rationType.ration);
  2343. // 连续点工具栏的插入定额按钮,显示树结构画线有问题。
  2344. //projectObj.project.Ration.addNewRationFast(rationType.ration,projectObj.selectColAndFocus);
  2345. //2020-01-08 要限制定额数量,所以还是要用等回传信息的方式插入定额
  2346. projectObj.project.Ration.addNewRation(null,rationType.ration,projectObj.selectColAndFocus,false);
  2347. });
  2348. $('#upMove').click(function () {
  2349. var controller = projectObj.mainController, project = projectObj.project;
  2350. var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;
  2351. if (selected.sourceType === project.Bills.getSourceType()) {
  2352. project.Bills.upMoveBills(selected.source);
  2353. controller.upMove();
  2354. } else if (selected.sourceType === project.Ration.getSourceType()) {
  2355. project.Ration.changePos(selected.source, selected.preSibling.source);
  2356. controller.upMove();
  2357. };
  2358. });
  2359. $('#downMove').click(function () {
  2360. var controller = projectObj.mainController, project = projectObj.project;
  2361. var selected = controller.tree.selected, next, nextSerialNo;
  2362. if (selected) {
  2363. if (selected.sourceType === project.Bills.getSourceType()) {
  2364. project.Bills.downMoveBills(selected.source);
  2365. controller.downMove();
  2366. } else if (selected.sourceType === project.Ration.getSourceType()) {
  2367. project.Ration.changePos(selected.source, selected.nextSibling.source);
  2368. controller.downMove();
  2369. };
  2370. }
  2371. });
  2372. $("a[name='lockBills']").click(function () {//点击锁定/解锁清单
  2373. let lockBills = projectObj.project.projectInfo.property.lockBills;
  2374. lockBills = !lockBills;
  2375. projectObj.project.updateLockBills(lockBills,function () {
  2376. var controller = projectObj.mainController, project = projectObj.project;
  2377. var selected = controller.tree.selected;
  2378. let nodes = _.filter(project.mainTree.items,{'sourceType':ModuleNames.bills});
  2379. controller.refreshTreeNode(nodes);
  2380. projectObj.mainController.setTreeSelected(selected);//触发树节点选中事件
  2381. projectObj.loadLockBillsButton();
  2382. $('#tzCharacterText').prop('readonly', lockBills);
  2383. if(!projectReadOnly){
  2384. pageCCOprObj.refreshRuleTools(lockBills);
  2385. }
  2386. //$("[data-toggle='tooltip']").tooltip('hide'); bs 与 jqueryUI冲突
  2387. });
  2388. });
  2389. $('#ZLFB_btn').click(function () {
  2390. zlfb_object.getSectionInfo();
  2391. });
  2392. //显示至..
  2393. let displayLevel = function(nodes, depth, type){
  2394. let refreshNodes = [];
  2395. function getExpandedController(){
  2396. if(type === 'DXFY' || type === 'FB'){
  2397. if(type === 'FB'){
  2398. projectObj.project.mainTree.items[0].setExpanded(true);
  2399. refreshNodes.push(projectObj.project.mainTree.items[0]);
  2400. }
  2401. return function expandedControl(nodes, depth){
  2402. let bType = type === 'FB' ? billType.FB : billType.DXFY;
  2403. for(let node of nodes){
  2404. let nodeDepth = node.depth();
  2405. if(nodeDepth <= depth){
  2406. let expanded = nodeDepth === depth && !node.children[0] || nodeDepth < depth && node.children[0] && node.children[0].data.type === bType ? true : false;
  2407. node.setExpanded(expanded);
  2408. refreshNodes.push(node);
  2409. if(nodeDepth < depth){
  2410. expandedControl(node.children, depth);
  2411. }
  2412. }
  2413. }
  2414. }
  2415. }
  2416. else if(type === 'FX' || type === 'ZM' || type === 'ZD'){
  2417. return function expandedControl(nodes){
  2418. for(let node of nodes){
  2419. if(type !== 'FX' || node.sourceType === projectObj.project.Bills.getSourceType()){
  2420. let expanded = true;
  2421. if(type === 'FX'){
  2422. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType === projectObj.project.Bills.getSourceType() ? true : false;
  2423. }
  2424. else if(type === 'ZM'){
  2425. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType !== projectObj.project.ration_glj.getSourceType() ? true : false;
  2426. }
  2427. node.setExpanded(expanded);
  2428. refreshNodes.push(node);
  2429. expandedControl(node.children);
  2430. }
  2431. }
  2432. }
  2433. }
  2434. }
  2435. getExpandedController()(nodes, depth);
  2436. let sheet = projectObj.mainSpread.getActiveSheet();
  2437. TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
  2438. TREE_SHEET_HELPER.refreshNodesVisible(refreshNodes, projectObj.mainSpread.getActiveSheet(), true)
  2439. });
  2440. };
  2441. //导入下拉
  2442. $('#importSpan').click(function () {
  2443. $('[data-toggle="tooltip"]').tooltip('hide');
  2444. let toggle = $('#importDropDown').attr('data-toggle');
  2445. if (toggle) {
  2446. $('#importDropDown').removeAttr('data-toggle');
  2447. }
  2448. $('#importDropDown').dropdown('toggle');
  2449. setTimeout(function () {
  2450. $('#importDropDown').attr('data-toggle', 'dropdown');
  2451. }, 100);
  2452. });
  2453. $('#importDropDown').click(function () {
  2454. $('[data-toggle="tooltip"]').tooltip('hide');
  2455. });
  2456. //导出接口下拉
  2457. $('#exportSpan').click(function () {
  2458. $('[data-toggle="tooltip"]').tooltip('hide');
  2459. let toggle = $('#exportSpan>a').attr('data-toggle');
  2460. if (toggle) {
  2461. $('#exportSpan>a').removeAttr('data-toggle');
  2462. }
  2463. $('#exportSpan>a').dropdown('toggle');
  2464. setTimeout(function () {
  2465. $('#exportSpan>a').attr('data-toggle', 'dropdown');
  2466. }, 100);
  2467. });
  2468. $('#exportSpan>a').click(function () {
  2469. $('[data-toggle="tooltip"]').tooltip('hide');
  2470. });
  2471. $('body').click(function () {
  2472. //点击完后隐藏子菜单
  2473. if ($('#subDisplay').is(':visible')) {
  2474. $('#subDisplay').removeClass('show');
  2475. }
  2476. });
  2477. let enterDisplayA = false;
  2478. //鼠标移到显示至,自动弹出子菜单
  2479. $('#displayA').click(function () {
  2480. return false;
  2481. });
  2482. $('#displayA').mouseenter(function (e) {
  2483. enterDisplayA = true;
  2484. $('#subDisplay').addClass('show');
  2485. });
  2486. $('#displayA').mouseleave(function () {
  2487. enterDisplayA = false;
  2488. });
  2489. let enterInterfaceDropdown = false;
  2490. $('#interface-dropdown').mouseenter(function () {
  2491. enterInterfaceDropdown = true;
  2492. $('#interface-dropdown-sub').addClass('show');
  2493. });
  2494. $('#interface-dropdown').mouseleave(function () {
  2495. enterInterfaceDropdown = false;
  2496. });
  2497. $('#interface-dropdown').click(function() {
  2498. return false;
  2499. });
  2500. let enterZLFB = false
  2501. $('#ZLFB_MENU').mouseenter(function () {
  2502. enterZLFB = true;
  2503. $('#ZLFB_MENU_sub').addClass('show');
  2504. });
  2505. $('#ZLFB_MENU').mouseleave(function () {
  2506. enterZLFB = false;
  2507. });
  2508. $('#ZLFB_MENU').click(function() {
  2509. return false;
  2510. });
  2511. $('#moreMenu > a').mouseenter(function () {
  2512. if (!enterDisplayA) {
  2513. $('#subDisplay').removeClass('show');
  2514. }
  2515. if (!enterInterfaceDropdown) {
  2516. $('#interface-dropdown-sub').removeClass('show');
  2517. }
  2518. if(!enterZLFB){
  2519. $('#ZLFB_MENU_sub').removeClass('show');
  2520. }
  2521. });
  2522. $('#displayDXFY').click(function () {
  2523. displayLevel(projectObj.project.mainTree.items, 0, 'DXFY')
  2524. });
  2525. //显示至一级分部
  2526. $('#displayFB1').click(function () {
  2527. displayLevel(projectObj.project.mainTree.items[0].children, 1, 'FB');
  2528. });
  2529. //二级分部
  2530. $('#displayFB2').click(function () {
  2531. displayLevel(projectObj.project.mainTree.items[0].children, 2, 'FB');
  2532. });
  2533. //三级分部
  2534. $('#displayFB3').click(function () {
  2535. displayLevel(projectObj.project.mainTree.items[0].children, 3, 'FB');
  2536. });
  2537. //四级分部
  2538. $('#displayFB4').click(function () {
  2539. displayLevel(projectObj.project.mainTree.items[0].children, 4, 'FB');
  2540. });
  2541. //分项
  2542. $('#displayFX').click(function () {
  2543. displayLevel(projectObj.project.mainTree.items, null, 'FX');
  2544. });
  2545. //子目
  2546. $('#displayZM').click(function () {
  2547. displayLevel(projectObj.project.mainTree.items, null, 'ZM');
  2548. });
  2549. //最底层
  2550. $('#displayZD').click(function () {
  2551. displayLevel(projectObj.project.mainTree.roots, null, 'ZD');
  2552. });
  2553. $('#poj-set').on('show.bs.modal', function () {
  2554. //建设项目-编制说明
  2555. let compilationIVP = projectObj.project.property.compilationIllustrationProject ? projectObj.project.property.compilationIllustrationProject : '';
  2556. $('#compilationIllustrationP textarea').val(compilationIVP);
  2557. //单位工程-编制说明
  2558. let compilationIV = projectObj.project.property.compilationIllustration ? projectObj.project.property.compilationIllustration : '';
  2559. $('#compilationIllustration textarea').val(compilationIV);
  2560. let setCalcFlag = function (obj, val, curFlag) {
  2561. obj.val(val);
  2562. if (val === curFlag) {
  2563. obj.prop('checked', true);
  2564. } else {
  2565. obj.prop('checked', false);
  2566. }
  2567. }
  2568. if (projectObj.project) {
  2569. //江西重定义了leafBillGetFeeType的内容
  2570. let ft = (projectObj.project.property.billsCalcMode !== undefined && projectObj.project.property.billsCalcMode !== null) ?
  2571. projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent; // 广东默认取1不是0,但这里不动,防止这种情况:旧项目默认无值,按取0算的,你改成1了,计算结果会变。
  2572. let zg = projectObj.project.property.zanguCalcMode !== undefined &&
  2573. projectObj.project.property.zanguCalcMode !== null ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
  2574. setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
  2575. setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
  2576. setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
  2577. setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
  2578. setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
  2579. setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
  2580. let showAdjustPrice = projectObj.project.projSetting.glj_col?projectObj.project.projSetting.glj_col.showAdjustPrice:false;
  2581. showAdjustPrice === true ? $("#tab_poj-settings-6").show():$("#tab_poj-settings-6").hide();
  2582. projDisplayView.init();
  2583. calcOptions.init();
  2584. }
  2585. });
  2586. //恢复默认列设置
  2587. $('#recColSetting').click(function () {
  2588. let libID = projectObj.project.property.colLibID ? projectObj.project.property.colLibID : null;
  2589. if(!libID){
  2590. alert('项目没有绑定标准列设置');
  2591. return;
  2592. }
  2593. $(this).addClass('disabled');
  2594. CommonAjax.post('/project/getDefaultColSetting', {libID: libID}, function (rstData) {
  2595. if(!rstData || rstData.length === 0){
  2596. alert('标准列设置没有数据');
  2597. $('#recColSetting').removeClass('disabled');
  2598. return;
  2599. }
  2600. let sheet = colSettingObj.settingSpread.getActiveSheet();
  2601. SheetDataHelper.massOperationSheet(sheet, function () {
  2602. for(let row = 0; row < sheet.getRowCount(); row++){
  2603. sheet.setValue(row, 0, rstData.main_tree_col.cols[row].visible);
  2604. }
  2605. });
  2606. $('#recColSetting').removeClass('disabled');
  2607. }, function () {
  2608. $('#recColSetting').removeClass('disabled');
  2609. });
  2610. });
  2611. //恢复默认系统设置
  2612. $('#property_default').click(function () {
  2613. let project = projectObj.project,
  2614. projectID = project.ID();
  2615. /*
  2616. * 清除窗口比例缓存
  2617. * */
  2618. //清单精灵/指引窗口比例
  2619. removeLocalCache('stdBillsGuidanceTabmainWidth');
  2620. removeLocalCache('stdBillsGuidanceTabmainSideWidth');
  2621. // 清单展开状态
  2622. window.sessionStorage.removeItem('stdBillsGuidanceExpState');
  2623. //定额库窗口比例
  2624. removeLocalCache('stdRationTabmainWidth');
  2625. removeLocalCache('stdRationTabmainSideWidth');
  2626. removeLocalCache('dedeTopDivHeight');
  2627. removeLocalCache('dedeBottomDivHeight');
  2628. //查找定位窗口比例
  2629. removeLocalCache('locateTabmainWidth');
  2630. removeLocalCache('locateTabmainSideWidth');
  2631. removeLocalCache('locatelocateTopDivHeight');
  2632. removeLocalCache('locatelocateBottomDivHeight');
  2633. //块模板库窗口比例
  2634. removeLocalCache('kmbkkmbkTopDivHeight');
  2635. removeLocalCache('kmbkkmbkMidDivHeight');
  2636. removeLocalCache('kmbkkmbkBottomDivHeight');
  2637. //主界面窗口比例
  2638. removeLocalCache('mainVerticaltop_divHeight');
  2639. removeLocalCache('mainVerticalbottom_divHeight');
  2640. //造价书下方-人材机和项目特征文本
  2641. removeLocalCache('subRcjsubSpreadWidth');
  2642. removeLocalCache('subRcjitemTextDivWidth');
  2643. //造价书下方-子目换算下调整状态和辅助值
  2644. removeLocalCache('subRcjitemTextDivWidth');
  2645. removeLocalCache('subRcjitemTextDivWidth');
  2646. //造价书下方-特征及内容窗口比例
  2647. removeLocalCache('subZmhscoeSpreadWidth');
  2648. removeLocalCache('subZmhsassDivWidth');
  2649. //人材机汇总窗口比例
  2650. removeLocalCache('projectGljprojectGljTopHeight');
  2651. removeLocalCache('projectGljprojectGljBottomHeight');
  2652. //补充人材机库
  2653. removeLocalCache('compleGLjleftContentWidth');
  2654. removeLocalCache('compleGLjmidContentWidth');
  2655. removeLocalCache('compleGLjrightContentWidth');
  2656. //补充定额库
  2657. removeLocalCache('compleRationleftContentWidth');
  2658. removeLocalCache('compleRationmainContentWidth');
  2659. removeLocalCache('compleRationzmhsContentWidth');
  2660. removeLocalCache('compleRationrationItemsSheetHeight');
  2661. removeLocalCache('compleRationsubContentHeight');
  2662. removeLocalCache('compleRationmainSpreadHeight');
  2663. removeLocalCache('compleRationcontentSpreadHeight');
  2664. //在后台恢复一些设置
  2665. CommonAjax.post('/pm/api/defaultSettings', {user_id: userID, projectID: projectID}, function (rstData) {
  2666. window.location.href = `/main?project=${projectID}`;
  2667. });
  2668. });
  2669. $('#property_ok').click(function () {
  2670. let project = projectObj.project,
  2671. projectID = project.ID(),
  2672. properties = {},
  2673. options = {},
  2674. labourCoes = {},
  2675. rations = [],
  2676. bills = [],
  2677. mixDatas = {
  2678. projectID: projectID,
  2679. updateType: 'update',
  2680. properties: properties,
  2681. options: options,
  2682. labourCoes: labourCoes,
  2683. rations: rations,
  2684. bills: bills
  2685. },
  2686. reCalcBills = false,
  2687. reCalcRations = false;
  2688. let b = parseInt($("input[name='calcFlag']:checked").val());
  2689. if (b !== project.property.billsCalcMode) {
  2690. properties['property.billsCalcMode'] = b;
  2691. project.property.billsCalcMode = b;
  2692. reCalcBills = true;
  2693. };
  2694. let zg = parseInt($("input[name='zangu']:checked").val());
  2695. if (zg !== project.property.zanguCalcMode) {
  2696. properties['property.zanguCalcMode'] = zg;
  2697. project.property.zanguCalcMode = zg;
  2698. reCalcRations = true;
  2699. };
  2700. //基本信息
  2701. if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
  2702. let saveData = basicInfoView.toSaveDatas(basicInfoView.datas);
  2703. projectObj.project.property.basicInformation = saveData;
  2704. properties['property.basicInformation'] = saveData;
  2705. }
  2706. //建设项目-编制说明
  2707. let compilationIllustrationP = $('#compilationIllustrationP textarea').val();
  2708. if (compilationIllustrationP !== project.property.compilationIllustrationProject) {
  2709. properties['property.compilationIllustrationProject'] = compilationIllustrationP;
  2710. project.property.compilationIllustrationProject = compilationIllustrationP;
  2711. }
  2712. //工程特征
  2713. if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
  2714. let saveData = projFeatureView.toSaveDatas(projFeatureView.datas);
  2715. projectObj.project.property.projectFeature = saveData;
  2716. properties['property.projectFeature'] = saveData;
  2717. }
  2718. // 清单限价
  2719. const maxPriceRate = $('#max-price-rate') && +$('#max-price-rate').val();
  2720. if (commonUtil.isNumber(maxPriceRate) && maxPriceRate !== projectObj.project.property.maxPriceRate) {
  2721. properties['property.maxPriceRate'] = maxPriceRate;
  2722. }
  2723. const minPriceRate = $('#min-price-rate') && +$('#min-price-rate').val();
  2724. if (commonUtil.isNumber(minPriceRate) && minPriceRate !== projectObj.project.property.minPriceRate) {
  2725. properties['property.minPriceRate'] = minPriceRate;
  2726. }
  2727. //清单工程量精度
  2728. let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
  2729. if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
  2730. billsQuanDecimal.datas = newBillsDecimalDatas;
  2731. reCalcBills = true;
  2732. properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
  2733. }
  2734. //小数位数
  2735. let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
  2736. if(toUpdateDecimal(decimalObj, updateDecimal)) {
  2737. let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
  2738. setDecimal(decimalObj, updateDecimal);
  2739. if (frChanged) {
  2740. project.calcProgram.compileAllTemps()
  2741. }
  2742. reCalcRations = true;
  2743. reCalcBills = true;
  2744. properties['property.decimal'] = updateDecimal;
  2745. }
  2746. // 呈现选项
  2747. projDisplayView.updateChecking(properties);
  2748. //列设置(独立逻辑,只是通过项目属性确定按钮触发)
  2749. if(colSettingObj.dataChanged()){
  2750. colSettingObj.updateColSetting();
  2751. }
  2752. //单位工程-编制说明
  2753. let compilationIllustration = $('#compilationIllustration textarea').val();
  2754. if (compilationIllustration !== project.property.compilationIllustration) {
  2755. properties['property.compilationIllustration'] = compilationIllustration;
  2756. project.property.compilationIllustration = compilationIllustration;
  2757. }
  2758. //系统选项
  2759. if(optionsOprObj.needToSaveGeneralOpts()){
  2760. let v1 = optionsOprObj.rationQuanACToBillsQuan.prop('checked'),
  2761. v2 = optionsOprObj.rationQuanACToRationUnit.prop('checked');
  2762. options.updateData = {
  2763. rationQuanACToBillsQuan: v1,
  2764. rationQuanACToRationUnit: v2
  2765. };
  2766. }
  2767. if(calcOptions.updateChecking(properties)){
  2768. reCalcRations = true;
  2769. }
  2770. // 人工系数
  2771. if (labourCoeView.needSave()){
  2772. let libID = $("#std_labour_coe_files").children("option:selected").val();
  2773. let libName = $("#std_labour_coe_files").children("option:selected").text();
  2774. labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
  2775. project.labourCoe.refreshData(labourCoes.updateData); // 全编译所用到的人工系数来自project.labourCoe,所以必须先刷新project.labourCoe
  2776. project.calcProgram.compileAllTemps();
  2777. reCalcRations = true;
  2778. reCalcBills = true;
  2779. };
  2780. // 重新计算树节点
  2781. let changedNodes = [];
  2782. if (reCalcRations) // 定额动,全部计算。算完先不存储,和后面的数据一起提交,一次通讯。
  2783. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
  2784. else if (reCalcBills) // 清单动,可以只计算清单。
  2785. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
  2786. if (changedNodes.length > 0) {
  2787. for (let node of changedNodes){
  2788. let data = calcTools.cutNodeForSave(node);
  2789. if (node.sourceType == 'ration') rations.push(data)
  2790. else if (node.sourceType == 'bills') bills.push(data);
  2791. };
  2792. };
  2793. // for test.
  2794. /* console.log(mixDatas);
  2795. return; */
  2796. function hasMixData() {
  2797. return Object.keys(mixDatas.properties).length > 0 || mixDatas.options.updateData ||
  2798. mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
  2799. }
  2800. function needToReload(mixDatas){
  2801. if(Object.keys(mixDatas.labourCoes).length > 0){
  2802. return true;
  2803. }
  2804. if(Object.keys(mixDatas.properties).length > 0){
  2805. if(mixDatas.properties.hasOwnProperty('property.billsCalcMode') ||
  2806. mixDatas.properties.hasOwnProperty('property.zanguCalcMode') ||
  2807. mixDatas.properties.hasOwnProperty('property.calcOptions')||
  2808. mixDatas.properties.hasOwnProperty('property.billsQuantityDecimal')||
  2809. mixDatas.properties.hasOwnProperty('property.decimal')||
  2810. mixDatas.properties.hasOwnProperty('property.displaySetting')){
  2811. return true;
  2812. }
  2813. }
  2814. return false;
  2815. }
  2816. if(hasMixData()){
  2817. CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
  2818. //需要重载页面
  2819. if(needToReload(mixDatas)){
  2820. window.location.href = '/main?project=' + projectID;
  2821. }
  2822. else{
  2823. if(mixDatas.properties.hasOwnProperty('property.maxPriceRate')){
  2824. projectObj.project.property.maxPriceRate = maxPriceRate;
  2825. }
  2826. if(mixDatas.properties.hasOwnProperty('property.minPriceRate')){
  2827. projectObj.project.property.minPriceRate = minPriceRate;
  2828. }
  2829. if(mixDatas.properties.hasOwnProperty('property.basicInformation')){
  2830. basicInfoView.orgDatas = basicInfoView.toViewDatas(mixDatas.properties['property.basicInformation']);
  2831. }
  2832. if(mixDatas.properties.hasOwnProperty('property.projectFeature')){
  2833. projFeatureView.orgDatas = projFeatureView.toViewDatas(mixDatas.properties['property.projectFeature']);
  2834. }
  2835. if(mixDatas.options && mixDatas.options.updateData){
  2836. let v1 = mixDatas.options.updateData['rationQuanACToBillsQuan'],
  2837. v2 = mixDatas.options.updateData['rationQuanACToRationUnit'];
  2838. optionsOprObj.updateOptions(optionsOprObj.options, {type: optionsOprObj.optionsTypes.GENERALOPTS, opt: 'rationQuanACToBillsQuan', value: v1});
  2839. optionsOprObj.updateOptions(optionsOprObj.options, {type: optionsOprObj.optionsTypes.GENERALOPTS, opt: 'rationQuanACToRationUnit', value: v2});
  2840. }
  2841. }
  2842. });
  2843. }
  2844. });
  2845. function testShow() {
  2846. var controller = projectObj.mainController, project = projectObj.project;
  2847. var selected = controller.tree.selected, parent = selected.parent;
  2848. var showinfo = "<label>确认要删除当前选中行吗?</label>";
  2849. var showN = false;
  2850. var cancelText = "否";
  2851. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
  2852. if(isSingleSelect()||selectionChecking()){
  2853. showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
  2854. showN = true;
  2855. cancelText = "取消";
  2856. }
  2857. }
  2858. $('#delete_showinfo').html(showinfo);
  2859. showN==true? $('#deleteN').show():$('#deleteN').hide();
  2860. $('#deleteCancel').text(cancelText);
  2861. function selectionChecking() {
  2862. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  2863. let mainTreeMap = {};
  2864. for(let i =0;i<selection.rowCount;i++){
  2865. let tem_node = controller.tree.items[selection.row+i];
  2866. if(i==0){//第一个直接添加;
  2867. mainTreeMap[tem_node.getID()] = tem_node;
  2868. }else {
  2869. project.Bills.setNodeToMap(tem_node,mainTreeMap);
  2870. }
  2871. }
  2872. let nodes = changeMapToArray(mainTreeMap);
  2873. if(nodes.length==1){
  2874. return true
  2875. }
  2876. return false;
  2877. }
  2878. }
  2879. $('#delete_row').on('show.bs.modal', function (e) {//这里用show,在shown之前调用,页面不会出现按钮闪现的情况
  2880. var controller = projectObj.mainController, project = projectObj.project;
  2881. var selected = controller.tree.selected, parent = selected.parent;
  2882. var showinfo = "<label>确认要删除当前选中行吗?</label>";
  2883. var showN = false;
  2884. var cancelText = "否";
  2885. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
  2886. if(isSingleSelect()||selectionChecking()){
  2887. showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
  2888. showN = true;
  2889. cancelText = "取消";
  2890. }
  2891. }else if(isSingleSelect()&&mbzm_obj.hasReferenceRation(selected)){//“有模板关联的定额”右键点击删除,弹窗提示“删除主子目时将删除对应的关联子目,是否继续? 是 否” (只有单选中一条定额并且是有模板关联的定额)
  2892. showinfo = "<label>删除主子目时将删除对应的关联子目,是否继续?</label>";
  2893. }
  2894. $('#delete_showinfo').html(showinfo);
  2895. showN==true? $('#deleteN').show():$('#deleteN').hide();
  2896. $('#deleteCancel').text(cancelText);
  2897. function selectionChecking() {
  2898. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  2899. let mainTreeMap = {}, nodes = [];
  2900. for(let i =0;i<selection.rowCount;i++){
  2901. let tem_node = controller.tree.items[selection.row+i];
  2902. if(i==0){//第一个直接添加;
  2903. mainTreeMap[tem_node.getID()] = tem_node;
  2904. }else {
  2905. project.Bills.setNodeToMapAndArray(tem_node,mainTreeMap,nodes);
  2906. }
  2907. }
  2908. if(nodes.length==1){
  2909. return true
  2910. }
  2911. return false;
  2912. }
  2913. });
  2914. function changeMapToArray(map) {
  2915. let newArray = [];
  2916. for(let key in map){
  2917. newArray.push(map[key]);
  2918. }
  2919. return newArray;
  2920. }
  2921. $('#deleteY').click(function () { //正常删除,级联删除子项
  2922. let project = projectObj.project;
  2923. project.Bills.deleteSelectedNodes();
  2924. });
  2925. $('#deleteN').click(function () {//不删除子项
  2926. let controller = projectObj.mainController, project = projectObj.project;
  2927. let selected = controller.tree.selected, parent = selected.parent;
  2928. if(selected){
  2929. let preNode = selected.preSibling;
  2930. let nextNode = selected.nextSibling;
  2931. if(preNode){//有前兄弟
  2932. if(preNode.children.length>0&&preNode.children[0].data.type != selected.children[0].data.type){//并且前兄弟子项和焦点行子项类别不同。
  2933. alert("删除分部会导致分部和分项同级,不允许该操作!");
  2934. return;
  2935. }
  2936. }else if(nextNode){
  2937. if(nextNode.data.type != selected.children[0].data.type){
  2938. alert("删除分部会导致分部和分项同级,不允许该操作! ");
  2939. return;
  2940. }
  2941. }
  2942. project.Bills.singleDeleteBills(selected,controller);
  2943. }
  2944. });
  2945. function isSingleSelect() {//是否选中造价书中的单行
  2946. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  2947. if (selections[0].rowCount == 1) {
  2948. return true;
  2949. }
  2950. return false;
  2951. }
  2952. function ifCanDelete() {
  2953. if (projectReadOnly) {
  2954. return false;
  2955. }
  2956. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  2957. let tree = projectObj.project.mainTree;
  2958. let selected = projectObj.project.mainTree.selected;
  2959. if(selections[0].rowCount==1){//选中单行
  2960. return canDelete(selected);
  2961. }else {
  2962. return canDelete_m(selections[0]);
  2963. }
  2964. function canDelete(node,m_selection) {
  2965. if (node) {
  2966. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  2967. if(node.data.type == billType.DXFY&&node.data.isAdd!=1){
  2968. return false;
  2969. }
  2970. if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
  2971. return false;
  2972. }
  2973. if(projectObj.project.Bills.hasFlags(node)){
  2974. return false;
  2975. }
  2976. }
  2977. if(m_selection!=true&&node.sourceType === projectObj.project.ration_glj.getSourceType()){//多选的时候不做这一项判断
  2978. return false;
  2979. }
  2980. return true;
  2981. } else {
  2982. return false;
  2983. }
  2984. };
  2985. function canDelete_m(selection) {
  2986. for(let i =0;i<selection.rowCount;i++){
  2987. if(tree.items[selection.row+i]==undefined||tree.items[selection.row+i]==null){
  2988. return false;
  2989. }
  2990. if(i==0&&tree.items[selection.row].sourceType === projectObj.project.ration_glj.getSourceType()){
  2991. return false
  2992. }
  2993. if(canDelete(tree.items[selection.row+i],true)==false){
  2994. return false
  2995. }
  2996. }
  2997. return true
  2998. };
  2999. }
  3000. function canInsertRationNode(selected) {//判断是否能插入定额、量价、定额类型工料机, false 不能,true能
  3001. if(!selected)
  3002. return false;
  3003. let project = projectObj.project;
  3004. if(selected.sourceType == ModuleNames.bills && selected.data.type == billType.DXFY){
  3005. return false
  3006. }else if(!(project.Bills.isMeasure(selected)||project.Bills.isFBFX(selected))){
  3007. return false
  3008. }else if(selected.sourceType == ModuleNames.bills && selected.source.children.length > 0){
  3009. return false
  3010. }
  3011. else {
  3012. return true
  3013. }
  3014. }
  3015. //导入类型(09表、广联达)
  3016. const uploadType = {general: 'general', lj: 'lj', gld: 'gld'};
  3017. let fileType = uploadType.lj;
  3018. $('#uploadLj').click(function () {
  3019. $('#example-gld').hide();
  3020. $('#example-general').show();
  3021. fileType = uploadType.lj;
  3022. });
  3023. $('#uploadGld').click(function () {
  3024. $('#example-general').hide();
  3025. $('#example-gld').show();
  3026. fileType = uploadType.gld;
  3027. });
  3028. let importJson = null;
  3029. //选择导入的excel文件
  3030. $('#customFile').change(function () {
  3031. let file = $(this)[0];
  3032. let excelFile = file.files[0];
  3033. $('#uploadAlert').hide();
  3034. if(excelFile) {
  3035. let xlsReg = /xls$/g;
  3036. if(excelFile.name && xlsReg.test(excelFile.name)){
  3037. showUploadAlert(false, '请选择xlsx文件');
  3038. $(this).val('');
  3039. return;
  3040. }
  3041. $('.custom-file-label').text(`${file.files[0].name}`);
  3042. $('#uploadAlert').hide();
  3043. $.bootstrapLoading.start();
  3044. $('#loadingPage').css('z-index', '2000');
  3045. //前端解析excel数据
  3046. if(importJson){
  3047. importJson = null;
  3048. }
  3049. let excelIo = new GC.Spread.Excel.IO();
  3050. let sDate = +new Date();
  3051. excelIo.open(excelFile, function (json) {
  3052. importJson = json;
  3053. console.log(json);
  3054. //读取各个表及表名
  3055. importBills.setImportSheetsInfo(importJson.sheets);
  3056. console.log(`解析Excel文件时间:${+new Date() - sDate}`);
  3057. $.bootstrapLoading.end();
  3058. }, function (e) {
  3059. $.bootstrapLoading.end();
  3060. alert(e.errorMessage);
  3061. });
  3062. }
  3063. });
  3064. //线上nginx请求体最大设置为100m
  3065. //从excel导入清单
  3066. $('#importConfirm').click(function () {
  3067. let me = this;
  3068. $(me).addClass('disabled');
  3069. try{
  3070. $.bootstrapLoading.start();
  3071. $('#loadingPage').css('z-index', '2000');
  3072. let formData = new FormData();
  3073. let file = $('#customFile')[0];
  3074. if(file.files.length <= 0){
  3075. throw '未选择文件';
  3076. }
  3077. let projectID = scUrlUtil.GetQueryString('project');
  3078. if(!projectID || projectID <= 0){
  3079. throw '项目数据出错';
  3080. }
  3081. let sDate = +new Date();
  3082. formData.append('projectID', projectID);
  3083. //要去匹配的清单库(第一个)
  3084. let matchBillLibId = projectObj.project.projectInfo.engineeringInfo.bill_lib.length > 0 ? projectObj.project.projectInfo.engineeringInfo.bill_lib[0].id : null;
  3085. formData.append('billsLibId', matchBillLibId);
  3086. //选择的表及导入位置
  3087. let importSheetsInfo = importBills.getImportSheetsInfo();
  3088. if(importSheetsInfo.length === 0){
  3089. throw '请勾选要导入的表';
  3090. }
  3091. let importSheets = importBills.getImportSheets(importJson.sheets, importSheetsInfo, fileType);
  3092. console.log(`importSheets`);
  3093. console.log(importSheets);
  3094. let invalidSheetsInfo = importSheets.invalidSheets.join('、');
  3095. //获取同类表的有效数据
  3096. let importBillsData = importBills.getImportData(importSheets.validSheets, projectID);
  3097. if(!importBills.excelHasValidBills(importBillsData)){
  3098. throw 'excel无有效数据'
  3099. }
  3100. let compressData = LZString.compressToUTF16(JSON.stringify(importBillsData));
  3101. formData.append('compressData', compressData);
  3102. let eDate = +new Date();
  3103. console.log(`解析excel数据时间:${eDate - sDate}`);
  3104. $.ajax({
  3105. url: '/bills/import',
  3106. type: 'POST',
  3107. data: formData,
  3108. cache: false,
  3109. contentType: false,
  3110. processData: false,
  3111. success: function(response){
  3112. if (response.err === 0) {
  3113. if(invalidSheetsInfo !== ''){
  3114. alert(`${invalidSheetsInfo},导入失败。`);
  3115. }
  3116. // 成功则关闭窗体
  3117. $('#import').modal("hide");
  3118. //更新前端
  3119. doAfterImport(response.data);
  3120. if($.bootstrapLoading.isLoading()){
  3121. $.bootstrapLoading.end();
  3122. }
  3123. } else {
  3124. const message = response.msg !== undefined ? response.msg : '上传失败!';
  3125. $.bootstrapLoading.end();
  3126. alert(message);
  3127. }
  3128. $(me).removeClass('disabled');
  3129. },
  3130. error: function(jqXHR){
  3131. alert(`与服务器通信发生错误${jqXHR.status} ${jqXHR.statusText}`);
  3132. $.bootstrapLoading.end();
  3133. $(me).removeClass('disabled');
  3134. }
  3135. });
  3136. }
  3137. catch (err){
  3138. console.log(err);
  3139. showUploadAlert(false, err);
  3140. $(me).removeClass('disabled');
  3141. if($.bootstrapLoading.isLoading()){
  3142. $.bootstrapLoading.end();
  3143. }
  3144. }
  3145. });
  3146. function showUploadAlert(success, msg){
  3147. if(!success){
  3148. $('#uploadAlert').removeClass('alert-success');
  3149. $('#uploadAlert').addClass('alert-danger');
  3150. }
  3151. else{
  3152. $('#uploadAlert').removeClass('alert-danger');
  3153. $('#uploadAlert').addClass('alert-success');
  3154. }
  3155. $('#uploadAlert').text(msg);
  3156. $('#uploadAlert').show();
  3157. }
  3158. //导入清单到一个固定行位置后,更新数据
  3159. function doAfterImportPosition(positionData){
  3160. let nodes = projectObj.project.mainTree.nodes;
  3161. let bills_datas = projectObj.project.Bills.datas;
  3162. let ration_datas = projectObj.project.Ration.datas;
  3163. let quantity_detail_datas = projectObj.project.quantity_detail.datas;
  3164. let ration_glj_datas = projectObj.project.ration_glj.datas;
  3165. let ration_coe_datas = projectObj.project.ration_coe.datas;
  3166. let ration_install_datas = projectObj.project.ration_installation.datas;
  3167. let delNodes = [];
  3168. for(let billID of positionData.remove.bill){
  3169. if(nodes['id_' + billID]){
  3170. delNodes.push(nodes['id_' + billID]);
  3171. }
  3172. //清除清单数据
  3173. _.remove(bills_datas, {ID: billID});
  3174. //清除清单工程量明细数据
  3175. _.remove(quantity_detail_datas, {billID: billID});
  3176. }
  3177. for(let rationID of positionData.remove.ration){
  3178. //清除定额数据
  3179. _.remove(ration_datas, {ID: rationID});
  3180. //清除定额下的相关数据
  3181. _.remove(ration_glj_datas, {rationID: rationID});
  3182. _.remove(ration_coe_datas, {rationID: rationID});
  3183. _.remove(ration_install_datas, {rationID: rationID});
  3184. _.remove(quantity_detail_datas, {rationID: rationID});
  3185. }
  3186. //删除节点
  3187. if(delNodes.length > 0){
  3188. //通过固定清单获得删除节点的起始行索引
  3189. let beginRow = null;
  3190. if(positionData.fixedBill){
  3191. let fixedNode = nodes['id_' + positionData.fixedBill.ID];
  3192. if(fixedNode){
  3193. beginRow = projectObj.project.mainTree.items.indexOf(fixedNode) + 1;
  3194. }
  3195. }
  3196. //删除主树节点
  3197. projectObj.mainController.m_delete(delNodes, beginRow);
  3198. //删除清单树节点
  3199. let delIdNodes = [];
  3200. for(let delNode of delNodes){
  3201. delIdNodes.push(delNode.source);
  3202. }
  3203. projectObj.project.Bills.tree.m_delete(delIdNodes);
  3204. }
  3205. if(positionData.insert.bill.length > 0){
  3206. //设置flagsIndex
  3207. for(let insertBill of positionData.insert.bill){
  3208. insertBill.flagsIndex = {};
  3209. if (insertBill.flags) {
  3210. insertBill.flags.forEach(function (flag) {
  3211. insertBill.flagsIndex[flag.fieldName] = flag;
  3212. });
  3213. }
  3214. }
  3215. //插入清单节点
  3216. projectObj.project.Bills.tree.insertByDatas(positionData.insert.bill);
  3217. //插入主树节点
  3218. let newNodes = projectObj.project.mainTree.insertByDatas(positionData.insert.bill);
  3219. for(let node of newNodes){
  3220. node.source = projectObj.project.Bills.tree.nodes['id_' + node.getID()];
  3221. node.data = node.source.data;
  3222. node.sourceType = projectObj.project.Bills.getSourceType();
  3223. }
  3224. ProjectController.syncDisplayNewNodes(projectObj.mainController, newNodes);
  3225. }
  3226. if (positionData.insert.ration.length) {
  3227. const rationNodes = [];
  3228. positionData.insert.ration.forEach(ration => {
  3229. projectObj.project.Ration.datas.push(ration);
  3230. const rationNode = projectObj.project.mainTree.insert(ration.billsItemID, -1, ration.ID);
  3231. rationNode.source = ration;
  3232. rationNode.sourceType = projectObj.project.Ration.getSourceType();
  3233. rationNode.data = ration;
  3234. rationNodes.push(rationNode);
  3235. });
  3236. ProjectController.syncDisplayNewNodes(projectObj.mainController, rationNodes);
  3237. }
  3238. }
  3239. //导入后更新操作
  3240. function doAfterImport(resData){
  3241. if(resData && resData.length > 0){
  3242. for(let positionData of resData){
  3243. doAfterImportPosition(positionData);
  3244. }
  3245. //如果清单未锁定,导入后锁定清单
  3246. /*if(!projectObj.project.projectInfo.property.lockBills){
  3247. $("a[name='lockBills']").click();
  3248. }*/
  3249. $.bootstrapLoading.end();
  3250. //重算
  3251. projectObj.project.calcProgram.calcAllNodesAndSave(calcAllType.catAll, function () {
  3252. projectObj.project.projectGLJ.loadData(function () {
  3253. $.bootstrapLoading.end();
  3254. });
  3255. });
  3256. }
  3257. }
  3258. //下载导入清单示例文件
  3259. $('#uploadExample-general').click(function () {
  3260. window.location.href = `/bills/downloadExamp?type=${uploadType.general}`;
  3261. });
  3262. $('#uploadExample').click(function () {
  3263. window.location.href = `/bills/downloadExamp?type=${fileType === uploadType.lj ? uploadType.lj : uploadType.gld}`;
  3264. });
  3265. $('#uploadExample-lj').click(function () {
  3266. window.location.href = `/bills/downloadExamp?type=${uploadType.lj}`;
  3267. });
  3268. $('#uploadExample-gld').click(function () {
  3269. window.location.href = `/bills/downloadExamp?type=${uploadType.gld}`;
  3270. });
  3271. $(function () {
  3272. //清空导入清单选择文件
  3273. $('#import').on('show.bs.modal', function(){
  3274. $('#customFile').val('');
  3275. $('#uploadAlert').hide();
  3276. $('.custom-file-label').text(`请选择上传文件`);
  3277. });
  3278. $('#import').on('hidden.bs.modal', function () {
  3279. //恢复选择表高度
  3280. $('#uploadSheets').height('');
  3281. $('#uploadSheets').hide();
  3282. $('#uploadSheetsHead').hide();
  3283. });
  3284. /* $("#billsSpread").mouseover(function(){
  3285. spreadAutoFocus(projectObj.mainSpread,subSpread);
  3286. });
  3287. $("#subSpread").mouseover(function(){
  3288. spreadAutoFocus(subSpread,projectObj.mainSpread);
  3289. });
  3290. */
  3291. $("#paste_confirm").click(function (){
  3292. let selected = projectObj.project.mainTree.selected;
  3293. let blockData = BlockController.getBlockData();
  3294. let position = $("input[name='pastePositionRadio']:checked").val();
  3295. BlockController.confirmPaste(blockData,selected,position);
  3296. $("#pastePosition").modal("hide");
  3297. });
  3298. $("#div_createBlocks").on('show.bs.modal', function(){
  3299. function getBlockCategoriesHtml(Categories) {
  3300. let result = '';
  3301. if (Categories.length <= 0) return result;
  3302. for (let c of Categories){
  3303. result += '<option value="'+ c.data.ID +'">'+ c.data.nodeName +'</option>';
  3304. };
  3305. return result;
  3306. };
  3307. let sHtml = getBlockCategoriesHtml(blockLibObj.getCategories());
  3308. $("#select_block_category").html(sHtml);
  3309. $("#select_block_category")[0].selectedIndex = 0;
  3310. $('#ckb_block_exist_cover').prop("checked", false);
  3311. });
  3312. $("#div_cloneOptions").on('show.bs.modal', function(){
  3313. let s = '';
  3314. switch (blockLibObj.cloneType) {
  3315. case 1:
  3316. s = '一对一克隆';
  3317. break;
  3318. case 2:
  3319. s = '一对多克隆';
  3320. break;
  3321. case 3:
  3322. s = '多对多克隆';
  3323. break;
  3324. }
  3325. s = `<span style='color:red;'>${s}</span>`;
  3326. $('#clone_option_title').html(`快速组价 (${s})`);
  3327. $('#clone_option_code').prop("checked", true);
  3328. $('#clone_option_name').prop("checked", false);
  3329. $('#clone_option_unit').prop("checked", true);
  3330. $('#clone_option_quantity').prop("checked", true);
  3331. $('#clone_option_cover').prop("checked", true);
  3332. });
  3333. $("#btn_block_createBlocks").click(async function () {
  3334. if ($("#select_block_category")[0].options.length < 1) return;
  3335. let cID = $("#select_block_category").val();
  3336. let selected = projectObj.project.mainTree.selected;
  3337. let cover = $('#ckb_block_exist_cover').prop("checked");
  3338. async function createBlocks(aNode, categoryID){
  3339. async function createBlock(node) {
  3340. if (node.data.name == undefined || node.data.name == '') return; // 清单名称为空,不生成块模板文件
  3341. if (node.children.length == 0) return;
  3342. // 封装成伟城的块文件格式,直接调用伟城接口(定额这里的业务太多太庞杂,不要再重做一遍,尽量共用,维护代价小)
  3343. // 块文件要构建自己的树结构,所以也有自己的一部分数据。两种结构揉合在一起,显得有点杂乱,但利大于弊。
  3344. let vBlock_WC = {
  3345. compilationID: projectObj.project.projectInfo.compilation,
  3346. firstNodeType: node.data.type,
  3347. isFBFX: projectObj.project.Bills.isFBFX(node),
  3348. copyTime: +new Date(),
  3349. datas: []
  3350. };
  3351. let ration_glj_Map = _.groupBy(projectObj.project.ration_glj.datas, 'rationID');
  3352. vBlock_WC.datas.push(BlockController.getNodeDatas(node, ration_glj_Map));
  3353. vBlock_WC = JSON.parse(JSON.stringify(vBlock_WC));
  3354. const unitFee = (node.data.feesIndex && node.data.feesIndex.common) ? node.data.feesIndex.common.unitFee : 0;
  3355. let fileName = node.data.code + ' ' + node.data.name + ' ' + node.data.unit + ' ' + unitFee;
  3356. fileName = fileName.replace(/^\s+|\s+$/g, ""); // 只去两头空格
  3357. let extN = blockLibObj.getSameNameNode(fileName);
  3358. if (extN){
  3359. if (cover) blockLibObj.assignData(extN, vBlock_WC);
  3360. }
  3361. else
  3362. await blockLibObj.newNode(2, fileName, categoryID, vBlock_WC);
  3363. };
  3364. async function createRecursion(node){
  3365. if (!node) return;
  3366. if (calcTools.isLeafBill(node)) await createBlock(node);
  3367. if (node.firstChild()) await createRecursion(node.firstChild());
  3368. if (node.nextSibling) await createRecursion(node.nextSibling);
  3369. };
  3370. if (calcTools.isLeafBill(aNode))
  3371. await createBlock(aNode)
  3372. else
  3373. await createRecursion(aNode.firstChild());
  3374. };
  3375. await createBlocks(selected, cID);
  3376. blockLibObj.loadDetailDatas(blockLibObj.mainTree.selected);
  3377. $("#div_createBlocks").modal("hide");
  3378. });
  3379. $("#btn_block_clone_ok").click(async function () {
  3380. let projectNode = projectObj.project.mainTree.selected;
  3381. let block = blockLibObj.mainTree.selected;
  3382. let options = {};
  3383. if ($('#clone_option_code').prop("checked")) options.checkCode = true;
  3384. if ($('#clone_option_name').prop("checked")) options.checkName = true;
  3385. if ($('#clone_option_unit').prop("checked")) options.checkUnit = true;
  3386. if ($('#clone_option_zeroQuantity').prop("checked")) options.zeroQuantity = true;
  3387. if ($('#clone_option_cover').prop("checked")) options.overwriteRations = true;
  3388. let nodes = [];
  3389. let calcNodes = [];
  3390. switch (blockLibObj.cloneType) {
  3391. case 1:
  3392. nodes = await blockLibObj.oneToOneClone(projectNode, block, options);
  3393. calcNodes = calcNodes.concat(nodes[1]);
  3394. break;
  3395. case 2:
  3396. let bills = calcTools.getLeafBills(projectNode);
  3397. for (let bill of bills){
  3398. calcTools.forceSelect(bill);
  3399. nodes = await blockLibObj.oneToOneClone(bill, block, options);
  3400. calcNodes = calcNodes.concat(nodes[1]);
  3401. };
  3402. break;
  3403. case 3:
  3404. let mtmBills = calcTools.getLeafBills(projectNode);
  3405. let mtmBlocks = blockLibObj.mainTree.selected.children;
  3406. for (let mtmBill of mtmBills){
  3407. for (let mtmBlock of mtmBlocks){
  3408. calcTools.forceSelect(mtmBill);
  3409. nodes = await blockLibObj.oneToOneClone(mtmBill, mtmBlock, options);
  3410. calcNodes = calcNodes.concat(nodes[1]);
  3411. };
  3412. };
  3413. break;
  3414. }
  3415. if(calcNodes.length > 0){
  3416. // projectObj.project.calcProgram.calcNodesAndSave(calcNodes, function () {
  3417. // installationFeeObj.calcInstallationFee();
  3418. // });
  3419. projectObj.project.calcProgram.calcNodesAndSave(calcNodes, async function () {
  3420. installationFeeObj.calcInstallationFee();
  3421. await OVER_HEIGHT.reCalcOverHeightFee();
  3422. await itemIncreaseFeeObj.calcItemIncreaseFeeByNodes(nodes[0]);
  3423. });
  3424. }
  3425. });
  3426. function spreadAutoFocus(spread,relateSpread) {
  3427. if(relateSpread&&relateSpread.getActiveSheet().isEditing()){//关联的spread不在编辑状态的情况下,才自动获得焦点;
  3428. return;
  3429. }else {
  3430. spread?spread.focus():'';
  3431. }
  3432. }
  3433. //项目为只读
  3434. if(projectReadOnly){
  3435. disableTools();
  3436. }
  3437. });
  3438. //项目只读,处理不可操作的工具栏
  3439. function disableTools(){
  3440. //造价书按钮
  3441. $('#insertRation').addClass('disabled');
  3442. $('#delete').addClass('disabled');
  3443. $('#upLevel').addClass('disabled');
  3444. $('#downLevel').addClass('disabled');
  3445. $('#upMove').addClass('disabled');
  3446. $('#downMove').addClass('disabled');
  3447. $('#ZLFB_btn').addClass('disabled');
  3448. //$('#switchTznr').addClass('disabled');
  3449. $('#uploadLj').addClass('disabled');
  3450. $('#uploadGld').addClass('disabled');
  3451. $('a[name="lockBills"]').addClass('disabled');
  3452. //关于计算
  3453. $('#poj-settings-4').find('input').prop('disabled', 'disabled');
  3454. //小数位数
  3455. $('#poj-settings-decimal').find('input').prop('disabled', 'disabled');
  3456. // 清单限价
  3457. $('.limit-price-input').prop('disabled', 'disabled');
  3458. //人工单价调整
  3459. $('#std_labour_coe_files').prop('disabled', 'disabled');
  3460. //呈现选项
  3461. $('#display-setting').find('input').prop('disabled', 'disabled');
  3462. $('#recColSetting').remove();
  3463. //建设项目-编制说明
  3464. $('#compilationIllustrationP textarea').prop('readOnly', true);
  3465. //单位工程-编制说明
  3466. $('#compilationIllustration textarea').prop('readOnly', true);
  3467. //项目属性恢复默认系统设置
  3468. $('#property_default').addClass('disabled');
  3469. //项目属性确定
  3470. $('#property_ok').addClass('disabled');
  3471. // 清单指引
  3472. $('#guidanceInsertRation').addClass('disabled');
  3473. //清单精灵
  3474. $('#elfInsertRation').addClass('disabled');
  3475. $('#elfInsertSingle').addClass('disabled');
  3476. //模板子目:应用、下一条
  3477. $('#apply_mbzm').addClass('disabled');
  3478. $('#next_mbzm').addClass('disabled');
  3479. //特征及内容
  3480. $('#add-rule').find('select').prop('disabled', 'disabled');
  3481. $('#use-to-current').addClass('disabled');
  3482. $('#use-to-all').addClass('disabled');
  3483. $('.bottom-tools').remove();
  3484. //导入
  3485. $('#importConfirm').addClass('disabled');
  3486. //导出
  3487. $('#export-confirm').addClass('disabled');
  3488. $('#exportSpan .dropdown-item').addClass('disabled');
  3489. //选项
  3490. $('#generalOpts1').prop('disabled', 'disabled');
  3491. $('#generalOpts2').prop('disabled', 'disabled');
  3492. //补充库编辑器
  3493. $('.compleRationLib').addClass('disabled');
  3494. $('.compleGljLib').addClass('disabled')
  3495. //库
  3496. //$('#stdBillsGuidanceTab').addClass('disabled');
  3497. $('#stdBillsTab').addClass('disabled');
  3498. //$('#stdRationTab').addClass('disabled');
  3499. $('#blockLibTab').addClass('disabled');
  3500. // 组价模板分享
  3501. $('#btn_block_share').prop('disabled', true);
  3502. //人材机汇总,选择其他、另存使用
  3503. $('a[data-target="#change-unitFile"]').remove();
  3504. $('a[data-target="#unitFile-save-as"]').remove();
  3505. //费率,选择其他、另存使用、重选标准、统一设置相同参数
  3506. $('a[data-target="#change-lv"]').remove();
  3507. $('a[data-target="#copy-lv"]').remove();
  3508. $('#standardSelect').prop('disabled', 'disabled');
  3509. $('#cascadeSet').prop('disabled', 'disabled');
  3510. $('#changeConfirm').prop('disabled', 'disabled');
  3511. //计算程序标准
  3512. $('#calcProgramFileSelect').prop('disabled', 'disabled');
  3513. //调价
  3514. $('#calcPriceOption').prop('disabled', 'disabled');
  3515. $('#gljPriceTenderCoe').prop('readOnly', true);
  3516. $('#tenderGLJQuantity').prop('disabled', 'disabled');
  3517. $('#tenderRationQuantity').prop('disabled', 'disabled');
  3518. $('#cleanTender').prop('disabled', 'disabled');
  3519. $('#calcTender').prop('disabled', 'disabled');
  3520. }
  3521. //根据触发改变计算基数、费率弹出框
  3522. function changeCalcBaseFeeRate(toggle) {
  3523. if(toggle === 'calcBase'){
  3524. $('#mixedHeader').hide();
  3525. $('#normalHeader').show();
  3526. $('#calcBaseFeeRate').find('.modal-title').text('计算基数选择').show();
  3527. $('#calcBaseFeeRate').find('.modal-body').find('button:first').hide();
  3528. $('#calcBaseFeeRate').find('.modal-body').find('ul:first').show();
  3529. $('#calcBaseExp').remove();
  3530. let $textarea = $('<textarea>').attr('id', 'calcBaseExp').prop('rows', 2).addClass('form-control').css('resize', 'none');
  3531. $('#expArea').prepend($textarea);
  3532. }
  3533. else if(toggle === 'feeRate'){
  3534. $('#mixedHeader').hide();
  3535. $('#normalHeader').show();
  3536. $('#calcBaseFeeRate').find('.modal-title').text('费率选择').show();
  3537. $('#calcBaseFeeRate').find('.modal-body').find('button:first').hide();
  3538. $('#calcBaseFeeRate').find('.modal-body').find('ul:first').hide();
  3539. }
  3540. else if(toggle === 'commonTotalFee') {
  3541. $('#normalHeader').hide();
  3542. $('#mixedHeader').show();
  3543. $('#calcBaseFeeRate').find('.modal-body').find('button:first').show();
  3544. $('#calcBaseFeeRate').find('.modal-body').find('ul:first').show();
  3545. $('#calcBaseExp').remove();
  3546. let $textarea = $('<textarea>').attr('id', 'calcBaseExp').prop('rows', 2).addClass('form-control').css('resize', 'none');
  3547. $('#expArea').prepend($textarea);
  3548. }
  3549. }
  3550. //综合合价弹出计算基数费率确认
  3551. $('#calcBaseFeeRateConf').click(function () {
  3552. let toggle = $(this).attr('toggle');
  3553. if(!toggle || toggle !== 'commonTotalFee'){
  3554. return
  3555. }
  3556. let calcBaseValue = calcBaseView.getInputExpr() ? calcBaseView.getInputExpr() : '';
  3557. let selected = projectObj.project.mainTree.selected;
  3558. let needToSave = false,validateFeeRate=false,cusFeeRate = false;
  3559. if($("input[name='editFeeRateOptions']:checked").val() == "0"){ //等于”0“ 是自定义输入,删除费率关联ID,直接取值
  3560. let newVal = null;
  3561. if($("#customFeeRate").val() != ""){
  3562. newVal = number_util.checkNumberValue( $("#customFeeRate").val(),getDecimal("feeRate"));
  3563. if(newVal == null) return
  3564. }
  3565. selected.data.feeRateID = null;
  3566. selected.data.feeRate = newVal;
  3567. selected.changed = true;
  3568. needToSave = true;
  3569. cusFeeRate = true;
  3570. }else {
  3571. validateFeeRate = feeRateObject.checkSelectedFeeRate();
  3572. }
  3573. if(calcBaseValue !== selected.data.calcBase){
  3574. needToSave = true;
  3575. selected.data.userCalcBase = calcBaseValue;
  3576. selected.data.lockUnitPrice = null;
  3577. projectObj.project.calcBase.calculate(selected);
  3578. }
  3579. if(validateFeeRate){
  3580. feeRateObject.submitFeeRateFromBill();
  3581. } else {
  3582. if(calcBaseValue === calcBaseValue){
  3583. $('#calcBaseFeeRate').modal('hide');
  3584. }
  3585. }
  3586. //删除清单基数,要清空单价
  3587. if (projectObj.project.calcBase.success && calcBaseValue === '') {
  3588. calcTools.setFieldValue(selected, 'feesIndex.common.unitFee', 0);
  3589. }
  3590. if(!projectObj.project.calcBase.success && cusFeeRate==false){
  3591. return;
  3592. } else if((!validateFeeRate || selected.data.feeRateID === parseInt(feeRateObject.feeRateSelection.ID)) && needToSave) {
  3593. projectObj.project.calcProgram.calcAndSave(selected);
  3594. $('#calcBaseFeeRate').modal('hide');
  3595. }
  3596. });
  3597. $('#menu_calc_program_manage').click(function () {
  3598. $('#tab_calc_program_manage').click();
  3599. });
  3600. $('#menu_index_info').click(function () {
  3601. $('#tab_index').click();
  3602. });
  3603. // 快速定位
  3604. const FastLocateType = {
  3605. SUB_ENGINERRING: 'subEnginerring',
  3606. MEASURE: 'measure',
  3607. OTHER: 'other',
  3608. };
  3609. const locateCache = {
  3610. [FastLocateType.SUB_ENGINERRING]: null,
  3611. [FastLocateType.MEASURE]: null,
  3612. [FastLocateType.OTHER]: null,
  3613. };
  3614. // 变更焦点行时,将焦点节点存至对应部分的locateCache中,用于快速定位功能
  3615. function locateToCache(node) {
  3616. if (!node) {
  3617. return;
  3618. }
  3619. if (node.isBelongToFlags([fixedFlag.SUB_ENGINERRING])) {
  3620. locateCache[FastLocateType.SUB_ENGINERRING] = node;
  3621. } else if (node.isBelongToFlags([fixedFlag.MEASURE])) {
  3622. locateCache[FastLocateType.MEASURE] = node;
  3623. } else if (node.isBelongToFlags([fixedFlag.OTHER])) {
  3624. locateCache[FastLocateType.OTHER] = node;
  3625. }
  3626. }
  3627. // “分项”、“措施”、“其他”,用于快速定位至对应部分上次的焦点行
  3628. function fastLocate(type) {
  3629. let locatedNode;
  3630. if (type === FastLocateType.SUB_ENGINERRING) {
  3631. locatedNode = locateCache[type] || projectObj.project.mainTree.roots.find(node => node.getFlag() === fixedFlag.SUB_ENGINERRING);
  3632. } else if (type === FastLocateType.MEASURE) {
  3633. locatedNode = locateCache[type] || projectObj.project.mainTree.roots.find(node => node.getFlag() === fixedFlag.MEASURE);
  3634. } else {
  3635. locatedNode = locateCache[type] || projectObj.project.mainTree.roots.find(node => node.getFlag() === fixedFlag.OTHER);
  3636. }
  3637. if (locatedNode && locatedNode !== projectObj.project.mainTree.selected) {
  3638. const locateRow = locatedNode.serialNo();
  3639. const sheet = projectObj.mainController.sheet;
  3640. projectObj.loadFocusLocation(locateRow, sheet.getActiveColumnIndex());
  3641. }
  3642. }
  3643. $('#locate-sub').click(() => {
  3644. fastLocate(FastLocateType.SUB_ENGINERRING);
  3645. });
  3646. $('#locate-measure').click(() => {
  3647. fastLocate(FastLocateType.MEASURE);
  3648. });
  3649. $('#locate-other').click(() => {
  3650. fastLocate(FastLocateType.OTHER);
  3651. });
  3652. // 清单限价
  3653. $('.limit-price-input').bind('input', function () {
  3654. const limitType = $(this).data('limit');
  3655. const orgVal = limitType === 'max'
  3656. ? (projectObj.project.property.maxPriceRate || 0)
  3657. : (projectObj.project.property.minPriceRate || 0);
  3658. try {
  3659. const val = $(this).val();
  3660. if (isNaN(val)) {
  3661. throw '只能输入两位小数数值!';
  3662. }
  3663. const splits = val.split('.');
  3664. const decimalDigits = splits[1] && splits[1].length || 0;
  3665. if (decimalDigits > 2) {
  3666. const roundVal = scMathUtil.roundForObj(val, 2);
  3667. $(this).val(roundVal);
  3668. }
  3669. } catch (err) {
  3670. alert(err);
  3671. $(this).val(orgVal);
  3672. }
  3673. });
  3674. //导出接口
  3675. ExportView.exportListener();