project_view.js 68 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518
  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 (node) {
  10. /*if (node) {
  11. subViewObj.saveComments(node);
  12. }*/
  13. },
  14. // CSL, 2018-02-09 用于测试显示。使用示例:projectObj.testDisplay(‘总额’, 100);
  15. testDisplay: function (caption, value) {
  16. let c = '';
  17. if (caption) c = caption + ': ';
  18. let s = `          ${c}${value}`;
  19. $('#testDisplay').html(s);
  20. },
  21. treeSelectedChanged: function (node) {
  22. let project = projectObj.project;
  23. subViewObj.loadComments(node);
  24. gljOprObj.showDataIfRationSelect(node);
  25. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  26. calcProgramObj.showData(node);
  27. };
  28. //zhong 2017-9-1 特征及内容
  29. if(pageCCOprObj.active){
  30. pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
  31. if(node.sourceType === project.Bills.getSourceType()){
  32. pageCCOprObj.setCacheAndShow(node);
  33. }
  34. else{
  35. pageCCOprObj.clearData();
  36. }
  37. }
  38. // for test interface. CSLAAAAA
  39. // projectObj.testDisplay('前四项累计值排除当前选中项' + projectObj.project.calcProgram.getBeforeTaxTotalFee([node]));
  40. // 基数
  41. // node.data.isSubcontract = true;
  42. // node.data.gljList = project.ration_glj.getGljArrByRation(node.data.ID);
  43. // let bname = '甲供定额基价材料费';
  44. // projectObj.testDisplay(bname, rationCalcBases[bname](node));
  45. },
  46. refreshBaseActn: function (tree) {
  47. let setButtonValid = function (valid, btn) {
  48. if (valid) {
  49. btn.removeClass('disabled');
  50. } else {
  51. btn.addClass('disabled');
  52. }
  53. };
  54. let selected = tree.selected, that = projectObj;
  55. let canUpLevel = function (node) {
  56. if(!node){
  57. return false;
  58. }
  59. if(node.depth()<=1){//焦点行是树结构的第一/二层节点,灰显。
  60. return false;
  61. }
  62. if(node.sourceType !== that.project.Bills.getSourceType()){//焦点行是定额/量价/工料机,灰显。
  63. return false;
  64. }else {
  65. if(node.data.type == billType.FX){//是分项,灰显。
  66. return false;
  67. }
  68. if(node.data.type == billType.FB&&node.nextSibling&&node.children.length>0){//焦点行是分部有后兄弟,有子项.
  69. if(node.children[0].data.type==billType.FX){ //焦点行子项是分项
  70. return false;
  71. }
  72. }
  73. if(node.data.type == billType.BILL &&node.nextSibling){//焦点行是清单有后兄弟
  74. if(node.data.calcBase&&node.data.calcBase!=""){//有基数计算
  75. return false;
  76. }
  77. if(node.children.length>0&&node.children[0].sourceType !== that.project.Bills.getSourceType()){//有子项,并且子项不是清单
  78. return false;
  79. }
  80. }
  81. }
  82. return true;
  83. };
  84. let canDownLevel = function (node) {
  85. if(!node){
  86. return false;
  87. }
  88. if(node.depth()==0){//焦点行是树结构的第一层节点,灰显。
  89. return false;
  90. }
  91. if(node.sourceType !== that.project.Bills.getSourceType()) {//焦点行是定额/量价/工料机,灰显。
  92. return false;
  93. }else {
  94. if(node.data.type == billType.FX){//是分项,灰显。
  95. return false;
  96. }
  97. if(!node.preSibling){//无前兄弟,灰显
  98. return false;
  99. }else if(node.preSibling.data.calcBase&&node.preSibling.data.calcBase!=""){//前兄弟有基数计算
  100. return false
  101. }
  102. if(node.preSibling.children.length>0){//前兄弟有子项,子项是分项,灰显。
  103. if(node.data.type==billType.FB&&node.preSibling.children[0].data.type==billType.FX){//焦点行是分部前兄弟有子项,子项是分项,灰显。
  104. return false;
  105. }
  106. if(node.data.type==billType.BILL&&node.preSibling.children[0].sourceType !== that.project.Bills.getSourceType()){//焦点行是清单,子项不是清单
  107. return false
  108. }
  109. }
  110. }
  111. return true;
  112. };
  113. let canUpMove = function (node) {
  114. if(node&&node.preSibling){//有前兄弟
  115. if(node.sourceType==that.project.Bills.getSourceType()&&node.data.type == billType.DXFY&&node.data.isAdd!==1){
  116. return false;
  117. }
  118. return true
  119. }
  120. return false
  121. };
  122. let canDownMove = function (node) {
  123. if(node&&node.nextSibling){
  124. if(node.sourceType==that.project.Bills.getSourceType()&&node.data.type == billType.DXFY&&node.data.isAdd!==1){
  125. return false;
  126. }
  127. return true;
  128. }
  129. return false
  130. };
  131. setButtonValid(ifCanDelete(), $('#delete'));
  132. setButtonValid(canUpLevel(selected), $('#upLevel'));
  133. setButtonValid(canDownLevel(selected), $('#downLevel'));
  134. setButtonValid(canUpMove(selected) , $('#upMove'));
  135. setButtonValid(canDownMove(selected), $('#downMove'));
  136. },
  137. checkCommonField: function (editingText, colSetting) {
  138. let value;
  139. if (colSetting.data.decimal) {
  140. value = Number(editingText);
  141. if (number_util.isNumber(value)) {
  142. if (colSetting.data.decimal) {
  143. value = value.toDecimal(colSetting.data.decimal);
  144. }
  145. } else {
  146. value = null;
  147. alert('当前输入的数据类型不正确,请重新输入。');
  148. }
  149. } else {
  150. value = editingText;
  151. }
  152. return value;
  153. },
  154. checkFormulaValidField: function (editingText, colSetting) {
  155. let value = Number(editingText);
  156. if (!value) {
  157. try {
  158. let exp = new Expression('');
  159. exp.Expression(editingText);
  160. value = Number(exp.Evaluate());
  161. } catch (error) {
  162. value = null;
  163. }
  164. }
  165. if (value!=undefined||value!=null) {
  166. if (colSetting.data.decimal) {
  167. value = value.toDecimal(colSetting.data.decimal);
  168. }
  169. } else if (editingText && editingText !== '') {
  170. value = null;
  171. alert('当前输入的数据类型不正确,请重新输入。');
  172. }
  173. return value;
  174. },
  175. checkSpreadEditingText: function (editingText, colSetting) {
  176. if (colSetting.data.field === 'quantity'||colSetting.data.field === 'contain') {
  177. return this.checkFormulaValidField(editingText, colSetting);
  178. }
  179. else if (colSetting.data.field === 'programID') {
  180. return this.project.calcProgram.compiledTemplateMaps[editingText];
  181. }
  182. else if (colSetting.data.field === 'subType') {
  183. if (typeof(editingText) !== "number")
  184. return volumePriceMaps[editingText]
  185. else
  186. return editingText;
  187. }
  188. else {
  189. return this.checkCommonField(editingText, colSetting);
  190. }
  191. },
  192. getVisibleRows: function (sRow, count) {
  193. let rst = [];
  194. let nodes = projectObj.project.mainTree.items;
  195. for(let i = sRow, len = nodes.length; i < len; i++){
  196. if(count <= 0){
  197. break;
  198. }
  199. if(nodes[i].visible){
  200. rst.push(i);
  201. count--;
  202. }
  203. }
  204. return rst;
  205. },
  206. //获取粘贴更改的单元格(粘贴时,跳过隐藏行)
  207. checkSpreadChangedCells: function (info) {
  208. let rst = {refreshRows: [], changedCells: []};
  209. //获取显示行号
  210. let vRows = projectObj.getVisibleRows(info.row, info.rowCount);
  211. let vCount = vRows.length;
  212. let lastRow = null, count = 0;
  213. for(let cell of info.changedCells){
  214. cell.text = info.sheet.getCell(cell.row, cell.col).text();
  215. if(cell.row !== lastRow){
  216. count++;
  217. lastRow = cell.row;
  218. }
  219. if(count <= vCount){
  220. if(vRows[count - 1] !== cell.row){
  221. rst.refreshRows.push(cell.row);
  222. }
  223. rst.changedCells.push({row: vRows[count - 1], col: cell.col, text: cell.text});
  224. }
  225. else {
  226. rst.refreshRows.push(cell.row);
  227. }
  228. }
  229. rst.refreshRows = Array.from(new Set(rst.refreshRows));
  230. return rst;
  231. },
  232. updateBillsCode: function (node, value) {
  233. let project = projectObj.project;
  234. let stdMatchCode, formatCode, matchs;
  235. let searchStdBillsAndUpdate = function (stdCode, formatCode) {
  236. let orgCode = node.data.code?node.data.code.substr(0, 9):"";
  237. if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
  238. project.Bills.updateField(node.source, 'code', formatCode, true);
  239. projectObj.mainController.refreshTreeNode([node], false);
  240. } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
  241. let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
  242. CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
  243. if (data) {
  244. //data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
  245. node.data.name = data.name;
  246. pageCCOprObj.setItemContentNode(node, data.jobContent, data.itemCharacter, node.data.name);
  247. if (/\//.test(data.unit)) {
  248. let existB = projectObj.project.Bills.sameStdCodeBillsData(data.code);
  249. if (existB) {
  250. data.unit = existB.unit;
  251. //
  252. project.Bills.replaceBills(node.source, data, formatCode);
  253. projectObj.mainController.refreshTreeNode([node], false);
  254. } else {
  255. ConfirmModal.stdBillsUnit.check(data, function (std) {
  256. project.Bills.replaceBills(node.source, std, formatCode);
  257. projectObj.mainController.refreshTreeNode([node], false);
  258. }, function () {
  259. projectObj.mainController.refreshTreeNode([node], false);
  260. });
  261. }
  262. } else {
  263. project.Bills.replaceBills(node.source, data, formatCode);
  264. projectObj.mainController.refreshTreeNode([node], false);
  265. }
  266. } else {
  267. project.Bills.updateField(node.source, 'code', formatCode, true);
  268. projectObj.mainController.refreshTreeNode([node], false);
  269. }
  270. });
  271. }
  272. }
  273. if(node.data.type==billType.FX||(node.data.type==billType.BILL&&node.source.children.length==0)){//是分项或者叶子清单的情况下才需要查找替换
  274. if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
  275. stdMatchCode = value;
  276. formatCode = project.Bills.newFormatCode(stdMatchCode);
  277. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  278. return;
  279. } else if (value&&value.length === 12 && /^[\d]+$/.test(value)) {
  280. stdMatchCode = value.substr(0, 9);
  281. matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
  282. if (matchs.indexOf(value) === -1) {
  283. searchStdBillsAndUpdate(stdMatchCode, value);
  284. } else if (confirm('已存在该编码的清单,是否继续?')) {
  285. formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
  286. searchStdBillsAndUpdate(stdMatchCode, formatCode);
  287. return;
  288. }
  289. }
  290. }
  291. project.Bills.updateField(node.source, 'code', value, true);
  292. this.mainController.refreshTreeNode([node], false);
  293. },
  294. updateRationCode: function (node, value) {
  295. if(!isDef(node.data.code) && (!isDef(value) || value.toString().trim() == '')){
  296. return;
  297. }
  298. if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
  299. alert('当前项目无定额库,请添加定额库。');
  300. this.mainController.refreshTreeNode([node], false);
  301. } else {
  302. let libId = parseInt($('#stdRationLibSelect').val());
  303. CommonAjax.post('/complementaryRation/api/getRationItem', {user_id: userID, rationRepId: libId, code: value}, function (data) {
  304. if (data) {
  305. projectObj.project.Ration.replaceRation(node.source, data);
  306. projectObj.project.ration_glj.addRationGLJ(node.source, data);
  307. } else {
  308. alert('当前库中找不到定额"' + value + '"');
  309. }
  310. projectObj.mainController.refreshTreeNode([node], false);
  311. });
  312. }
  313. },
  314. updateCode: function (node, value) {
  315. let project = projectObj.project;
  316. if (node.sourceType === project.Bills.getSourceType()) {
  317. this.updateBillsCode(node, value); // 新清单不适合实时计算,下面套什么还不能确定,无数量计算也无意义
  318. } else if (node.sourceType === project.Ration.getSourceType()) {
  319. project.Ration.updateRationCodes([{'node':node,value:value}]);
  320. // this.updateRationCode(node, value); // 新套定额适合实时计算
  321. // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
  322. /*project.calcProgram.calcAndSave(node);
  323. if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
  324. calcProgramObj.showData(node, false);
  325. };*/
  326. }
  327. },
  328. updateCellValue: function (node, value, colSetting,editingText) {
  329. let project = projectObj.project, fieldName = colSetting.data.field;
  330. if(node.sourceType==project.ration_glj.getSourceType()){
  331. project.ration_glj.updateFromMainSpread(value,node,fieldName);
  332. }
  333. else if(calcTools.isGljRation(node)){
  334. gljOprObj.updateRationTypeGLJ(value,node,fieldName);
  335. }
  336. else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
  337. if (fieldName === 'code' && !calcTools.isVolumePrice(node)) {
  338. projectObj.updateCode(node, value);
  339. }
  340. else if(fieldName ==='feeRate'){
  341. project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
  342. }
  343. else if(fieldName ==='contain'){//编辑含量
  344. project.Ration.updateContain(value,node);
  345. }
  346. else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'programID' ||
  347. fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'isSubcontract'){
  348. if (fieldName === 'quantity') {
  349. project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
  350. return;
  351. }
  352. else if (fieldName === 'marketUnitFee') {
  353. if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
  354. }
  355. else if (fieldName === 'calcBase') {
  356. //zhong
  357. if(value === undefined ||value === null || value.toString().trim() === ''){
  358. value = '';
  359. }
  360. node.data.userCalcBase = value;
  361. project.calcBase.calculate(node);
  362. if(!project.calcBase.success){
  363. let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  364. projectObj.mainSpread.getActiveSheet().setValue(activeCell.row, activeCell.col, node.data.calcBase? node.data.calcBase: '');
  365. return;
  366. }
  367. // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
  368. };
  369. //计算基数赋值要经过解析和标准化,已在calculate里赋值
  370. if(fieldName !== 'calcBase'){
  371. node.data[fieldName] = value;
  372. node.changed = true;
  373. }
  374. project.calcProgram.calcAndSave(node);
  375. gljOprObj.showRationGLJSheetData();
  376. }
  377. else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
  378. node.data[fieldName] = value;
  379. node.changed = true;
  380. if(node.data.quantity){
  381. node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
  382. }
  383. project.calcProgram.calcAndSave(node);
  384. }
  385. else {
  386. if (node.sourceType === project.Bills.getSourceType()) {
  387. project.Bills.updateField(node.source, fieldName, value, true);
  388. }
  389. else if (node.sourceType === project.Ration.getSourceType()) {
  390. project.Ration.updateField(node.source, fieldName, value, true);
  391. };
  392. if (colSetting.data.wordWrap) {
  393. this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
  394. }
  395. projectObj.mainController.refreshTreeNode([node]);
  396. }
  397. }
  398. else if(value==null && fieldName ==='feeRate'){
  399. project.FeeRate.cleanFeeRateID(node);
  400. }
  401. else {
  402. projectObj.mainController.refreshTreeNode([node], false);
  403. }
  404. },
  405. mainSpreadLeaveCell: function (sender, info) {
  406. let colSetting = projectObj.mainController.setting.cols[info.col];
  407. projectObj.lastCol = colSetting;
  408. },
  409. //repaint 动态下拉框
  410. mainSpreadEnterCell: function (sender, info) {
  411. let colSetting = projectObj.mainController.setting.cols[info.col];
  412. if(colSetting.data.field === 'unit' || projectObj.lastCol.data.field === 'unit'||colSetting.data.field ==='subType'
  413. || projectObj.lastCol.data.field === 'subType' || colSetting.data.field === 'programID' ||projectObj.lastCol.data.field === 'programID'){
  414. info.sheet.repaint();
  415. }
  416. },
  417. mainSpreadEditStarting: function (sender, info) {
  418. let project = projectObj.project;
  419. let node = project.mainTree.items[info.row];
  420. if(isDef(node) && node.sourceType === project.Ration.getSourceType() && isDef(node.data.code) && isDef(node.data.from) && node.data.from === 'cpt'){
  421. let orgV = info.sheet.getValue(info.row, info.col);
  422. let newV = orgV.replace(new RegExp('补'), '');
  423. info.sheet.setValue(info.row, info.col, newV);
  424. }
  425. },
  426. onCellDoubleClick: function (sender, info){
  427. let project = projectObj.project;
  428. let node = project.mainTree.items[info.row];
  429. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  430. if(fieldName == 'marketUnitFee'){
  431. if(gljOprObj.hasComposition(node.data,true)){
  432. alert("当前工料机的市场价由组成物计算得出,不可直接修改。");
  433. return;
  434. }
  435. }
  436. },
  437. mainSpreadEditEnded: function (sender, info) {
  438. let project = projectObj.project;
  439. let node = project.mainTree.items[info.row];
  440. let colSetting = projectObj.mainController.setting.cols[info.col];
  441. let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
  442. // 检查输入类型等
  443. let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
  444. projectObj.updateCellValue(node, value, colSetting,info.editingText);
  445. // 自动行高
  446. const autoHeight = project.property.displaySetting.autoHeight;
  447. if (autoHeight) {
  448. projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
  449. }
  450. },
  451. msClipboardChanged: function (sender, info) {
  452. let colSettings = projectObj.mainController.setting.cols;
  453. let cDatas = sheetCommonObj.getTableData(info.sheet, colSettings);
  454. sheetCommonObj.copyTextToClipboard(cDatas);
  455. return;
  456. },
  457. mainSpreadRangeChanged: function (sender, info) {
  458. let project = projectObj.project, setting = projectObj.mainController.setting;
  459. let changedObj = projectObj.checkSpreadChangedCells(info);
  460. let refreshNodes = [];
  461. for(let row of changedObj.refreshRows){
  462. refreshNodes.push(project.mainTree.items[row]);
  463. }
  464. let updateRationCodes = [];//更新定额编码时要用同步的方式
  465. if(changedObj.changedCells.length > 0){
  466. for (let changedCell of changedObj.changedCells) {
  467. let node = project.mainTree.items[changedCell.row];
  468. let colSetting = setting.cols[changedCell.col];
  469. let value = projectObj.checkSpreadEditingText(changedCell.text, colSetting)
  470. if(colSetting.data.field=='code'&& node.sourceType == project.Ration.getSourceType()&&node.data.type==rationType.ration){//如果是更新定额的编码
  471. updateRationCodes.push({'node':node,value:value});
  472. }else {
  473. projectObj.updateCellValue(node, value, colSetting,changedCell.text);
  474. }
  475. }
  476. }
  477. if(updateRationCodes.length>0){
  478. project.Ration.updateRationCodes(updateRationCodes);
  479. }
  480. if(refreshNodes.length > 0){
  481. projectObj.mainController.refreshTreeNode(refreshNodes);
  482. }
  483. },
  484. checkMainSpread: function () {
  485. if (!this.mainSpread) {
  486. this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
  487. this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
  488. this.mainSpread.getActiveSheet().name('mainSheet');
  489. }
  490. },
  491. refreshMainSpread: function () {
  492. if (this.mainSpread) {
  493. this.mainSpread.refresh();
  494. }
  495. },
  496. loadProjectData: function () {
  497. var that = this;
  498. this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
  499. let startTime = +new Date();
  500. console.log("开始加载-----"+startTime);
  501. this.project.loadDatas(function (err) {
  502. let mTime = +new Date();
  503. console.log(`get data时间——${mTime - startTime}`);
  504. if (!err) {
  505. that.project.projectGLJ.calcQuantity();//计算分部分项和技术措施项目消耗量;
  506. that.project.property = projectInfoObj.projectInfo.property;
  507. //that.project.calcProgram.compileAllTemps();
  508. that.project.calcBase.init(that.project);
  509. // that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
  510. // that.project.initCalcFields();
  511. let str = JSON.stringify(that.project.projSetting.main_tree_col);
  512. that.project.projSetting.mainGridSetting = JSON.parse(str);
  513. that.project.projSetting.mainGridSetting.frozenCols = 4;
  514. TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
  515. that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
  516. col.data.splitFields = col.data.field.split('.');
  517. if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
  518. col.data.getText = MainTreeCol.getEvent(col.data.getText);
  519. }
  520. if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
  521. col.readOnly = MainTreeCol.getEvent(col.readOnly);
  522. }
  523. if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
  524. let getCellType = MainTreeCol.getEvent(col.data.cellType);
  525. col.data.cellType = getCellType;
  526. }
  527. // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
  528. // col.data.decimal = that.project.getDecimal(col.data.digit);
  529. // col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
  530. // }
  531. if (col.data.field === 'code') {
  532. col.data.formatter = '@';
  533. }
  534. col.setAutoHeight = MainTreeCol.getEvent("setAutoHeight");
  535. // 根据配置设置自动行高,在这里先做个标记,然后对每个单元格单独配置
  536. if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
  537. col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
  538. col.data.autoHeight = true;
  539. col.showHint = true;
  540. }
  541. if(col.data.field ==='quantity'){
  542. col.showHint = true;
  543. }
  544. // 综合单价、综合合价,小数部分应补0对齐。 CSLAAAAA
  545. // if (col.data.field.hasSubStr("common")){
  546. if (col.data.field.hasSubStr(".totalFee"))
  547. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, true)
  548. else if (col.data.field.hasSubStr(".unitFee"))
  549. col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, true)
  550. // }
  551. });
  552. let startShowTime = +new Date();
  553. that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
  554. that.mainController.showTreeData();
  555. let endShowTime = +new Date();
  556. console.log(`show data时间——${endShowTime - startShowTime}`);
  557. that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
  558. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
  559. that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
  560. that.mainSpread.getActiveSheet().startEdit();
  561. that.mainSpread.getActiveSheet().endEdit();
  562. that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
  563. that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
  564. that.mainSpread.bind(GC.Spread.Sheets.Events.EditStarting, that.mainSpreadEditStarting);
  565. that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
  566. that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
  567. that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, that.msClipboardChanged);
  568. that.mainSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, that.onButtonClick);
  569. that.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, that.onCellDoubleClick);
  570. let loadOtherStartTime = +new Date();
  571. that.loadMainSpreadContextMenu();
  572. that.loadFocusLocation();
  573. let endTime = +new Date();
  574. console.log(`其它时间——${endTime - loadOtherStartTime}`);
  575. socketObject.connect();//连接socket服务器
  576. console.log("加载完成-----"+endTime);
  577. console.log(`时间——${endTime - startTime}`);
  578. that.project.projectMarkChecking();//是否需要重新进行造价计算
  579. installationFeeObj.engineeringTypeChecking();//检查是否安装工程
  580. //初始需要触发一次点击表格事件,sheet.getAutoFitWidth值(获取单元格文本长度)才正确
  581. autoFlashHeight();
  582. projectObj.refreshMainSpread();
  583. }
  584. else {
  585. }
  586. });
  587. },
  588. loadMainSpreadContextMenu: function () {
  589. var project = this.project, spread = this.mainSpread, controller = this.mainController;
  590. $.contextMenu({
  591. selector: '#billsSpread',
  592. build: function ($trigger, e) {
  593. var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
  594. controller.setTreeSelected(controller.tree.items[target.row]);
  595. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  596. },
  597. items: {
  598. "insertRootBill": {
  599. name: "插入大项费用",
  600. icon: 'fa-sign-in',
  601. disabled: function () {
  602. //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  603. },
  604. callback: function (key, opt) {
  605. ProjectController.addRootBill(project, controller);
  606. },
  607. visible: function(key, opt){
  608. return project.mainTree.selected&&project.mainTree.selected.parent==null;
  609. }
  610. },
  611. "insertFB": {
  612. name: "插入分部",
  613. icon: 'fa-sign-in',
  614. disabled: function () {
  615. let selected = project.mainTree.selected;
  616. if(selected&&selected.sourceType==project.Bills.getSourceType()){
  617. if(selected.data.type==billType.FB){
  618. return false;
  619. }
  620. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  621. if(selected.children.length>0){
  622. return selected.children[0].data.type==billType.FX;//焦点行是分部分项工程,且子项是分项
  623. }else {
  624. return false
  625. }
  626. }
  627. }
  628. return true;//除了清单,其它类型都只读
  629. },
  630. callback: function (key, opt) {
  631. ProjectController.addFB(project, controller);
  632. },
  633. visible: function(key, opt){
  634. if(project.mainTree.selected){
  635. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  636. }else {
  637. return false;
  638. }
  639. }
  640. },
  641. "insertFX": {
  642. name: "插入分项",
  643. icon: 'fa-sign-in',
  644. disabled: function () {
  645. let selected = project.mainTree.selected;
  646. if(selected&&selected.sourceType==project.Bills.getSourceType()){
  647. if(selected.data.type==billType.FX){//焦点行是分项,有效显示
  648. return false
  649. }
  650. if(selected.data.type==billType.FB){//点行是分部,
  651. if(selected.children.length>0){//且有子项,子项是分部,灰显。
  652. return selected.children[0].data.type == billType.FB
  653. }else {
  654. return false;
  655. }
  656. }
  657. if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
  658. if(selected.children.length>0){
  659. return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程,且子项是分部时灰显
  660. }else {
  661. return false
  662. }
  663. }
  664. }
  665. return true;//除了清单,其它类型都只读
  666. },
  667. callback: function (key, opt) {
  668. ProjectController.addFX(project, controller);
  669. },
  670. visible: function(key, opt){
  671. if(project.mainTree.selected){
  672. return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
  673. }else {
  674. return false;
  675. }
  676. }
  677. },
  678. "insertBills": {
  679. name: "插入清单",
  680. icon: 'fa-sign-in',
  681. disabled: function () {
  682. return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
  683. },
  684. callback: function (key, opt) {
  685. if(project.mainTree.selected.data.type == billType.DXFY){
  686. if(project.mainTree.selected.data.calcBase&&project.mainTree.selected.data.calcBase!=""){
  687. alert("当前有基数计算不能插入子项。");
  688. return;
  689. }
  690. }
  691. ProjectController.addBills(project, controller);
  692. },
  693. visible: function(key, opt){
  694. if(project.mainTree.selected){
  695. return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;
  696. }else {
  697. return false;
  698. }
  699. }
  700. },
  701. "insertRation": {
  702. name: "插入定额",
  703. icon: 'fa-sign-in',
  704. disabled: function () {
  705. var selected = project.mainTree.selected;
  706. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  707. },
  708. callback: function (key, opt) {
  709. project.Ration.addNewRation(null,rationType.ration);
  710. // ProjectController.addRation(project, controller, rationType.ration);
  711. },
  712. visible: function(key, opt){
  713. var selected = project.mainTree.selected;
  714. if(selected){
  715. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  716. return false
  717. }else {
  718. return true
  719. }
  720. }
  721. return false;
  722. }
  723. },
  724. "insertLJ": {
  725. name: "插入量价",
  726. icon: 'fa-sign-in',
  727. disabled: function () {
  728. var selected = project.mainTree.selected;
  729. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  730. },
  731. callback: function (key, opt) {
  732. project.Ration.addNewRation(null,rationType.volumePrice);
  733. // ProjectController.addRation(project, controller, rationType.volumePrice);
  734. },
  735. visible: function(key, opt){
  736. var selected = project.mainTree.selected;
  737. if(selected){
  738. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  739. return false
  740. }else {
  741. return true
  742. }
  743. }
  744. return false;
  745. }
  746. },
  747. "insertGLJ": {
  748. name: "插入工料机",
  749. icon: 'fa-sign-in',
  750. disabled: function () {
  751. var selected = project.mainTree.selected;
  752. return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
  753. },
  754. callback: function (key, opt) {
  755. var selected = project.mainTree.selected;
  756. if(selected.sourceType == ModuleNames.bills){
  757. if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
  758. if(selected.data.calcBase&&selected.data.calcBase!=""){
  759. alert("当前有基数计算不能插入子项。");
  760. return;
  761. }
  762. }
  763. }
  764. getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
  765. },
  766. visible: function(key, opt){
  767. var selected = project.mainTree.selected;
  768. if(selected){
  769. if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
  770. return false;
  771. }else {
  772. return true;
  773. }
  774. }
  775. return false;
  776. }
  777. },
  778. "ZLFB": {
  779. name: "整理分部",
  780. icon: 'fa-sign-in',
  781. disabled: function () {
  782. return false;
  783. },
  784. callback: function (key, opt) {
  785. zlfb_object.getSectionInfo();
  786. },
  787. visible: function(key, opt){
  788. return true;
  789. }
  790. },
  791. "calc_installation_fee": {
  792. name: "计取安装费用",
  793. icon: 'fa-sign-in',
  794. disabled: function () {
  795. return false;
  796. },
  797. callback: function (key, opt) {
  798. installationFeeObj.showCalcInstallSettingDiv();
  799. },
  800. visible: function(key, opt){
  801. let engineering = projectInfoObj.projectInfo.property.engineering;
  802. return engineering==engineeringType.BUILD_IN;
  803. }
  804. },
  805. "spr1": '--------',
  806. "delete": {
  807. name: '删除',
  808. icon: 'fa-remove',
  809. disabled: function () {
  810. return !ifCanDelete();
  811. },
  812. callback: function () {
  813. var selected = project.mainTree.selected;
  814. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  815. project.Bills.deleteSelectedNode();
  816. }else {
  817. $("#delete_row").modal({show:true});//弹出删除提示框;
  818. }
  819. }
  820. },
  821. "spr2":'--------',
  822. "calculateAll_RationContent": {
  823. name: '造价计算',
  824. callback: function () {
  825. project.calcProgram.calcAllNodesAndSave();
  826. }
  827. }
  828. }
  829. });
  830. },
  831. // 计算node及node的所有父项
  832. converseCalculateBills: function (node) {
  833. /* if (node) {
  834. let calc = new BillsCalcHelper(this.project);
  835. calc.calcNode(node, true);
  836. let cur = node, nodes = [];
  837. while (cur) {
  838. nodes.push(cur);
  839. cur = cur.parent;
  840. }
  841. this.mainController.refreshTreeNode(nodes, false);
  842. this.project.Bills.updateNodes(nodes, true);
  843. calc = null;
  844. }*/
  845. projectObj.project.calcProgram.calcAndSave(node);
  846. },
  847. // 计算全部清单
  848. /* calculateAll: function () {
  849. let calc = new BillsCalcHelper(this.project);
  850. calc.calcAll();
  851. this.mainController.showTreeData();
  852. this.project.Bills.updateAll();
  853. calc = null;
  854. }*/
  855. // 获取上次退出时的焦点位置
  856. loadFocusLocation: function() {
  857. const projectId = scUrlUtil.GetQueryString('project');
  858. let row = getLocalCache('lastRow:' + projectId);
  859. let col = getLocalCache('lastCol:' + projectId);
  860. if (row !== null && col !== null) {
  861. row = parseInt(row);
  862. col = parseInt(col);
  863. const sheet = this.mainSpread.getActiveSheet();
  864. sheet.setSelection(row, col, 1, 1);
  865. this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
  866. }
  867. },
  868. // 选中区域合计数字
  869. amountAreaNumber: function(e, info) {
  870. if (info.newSelections === undefined || info.newSelections.length <= 0) {
  871. return false;
  872. }
  873. const selectedArea = info.newSelections[0];
  874. const sheet = info.sheet;
  875. if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
  876. return false;
  877. }
  878. // 获取鼠标位置
  879. let x = window.event.clientX;
  880. let y = window.event.clientY;
  881. // 匹配数字或小数
  882. const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
  883. // 小数点最高位数
  884. let max = 0;
  885. let total = 0;
  886. let counter = 0;
  887. for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
  888. for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
  889. const value = sheet.getCell(row, col).text();
  890. if (!regular.test(value)) {
  891. continue;
  892. }
  893. counter++;
  894. // 获取当前数据小数位数
  895. let pointPosition = value.toString().indexOf(".");
  896. pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
  897. const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
  898. max = current > max ? current : max;
  899. total += parseFloat(value);
  900. }
  901. }
  902. // 如果不为0则悬浮显示
  903. if (total > 0 && counter > 1) {
  904. 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>');
  905. div.css({
  906. position: "absolute",
  907. border: "1px #C0C0C0 solid",
  908. background: "#fff",
  909. boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
  910. });
  911. div.children("p").css({
  912. textAlign: "center",
  913. padding: 8,
  914. marginBottom: 2,
  915. });
  916. div.children("p").first().css({
  917. borderBottom: "1px #C0C0C0 solid"
  918. });
  919. const totalString = total.toFixed(max);
  920. // input长度
  921. const inputWidth = totalString.length * 8;
  922. // 计算是否会超出显示范围
  923. const baseWidth = 48;
  924. const baseHeight = 81;
  925. const canvasWidth = $("#billsSpreadvp_vp").width();
  926. const canvasHeight = $("#billsSpreadvp_vp").height();
  927. x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
  928. y = y + baseHeight > canvasHeight ? y - baseHeight : y;
  929. div.css({
  930. left: x,
  931. top: y,
  932. });
  933. div.children().children("#total").width(inputWidth).val(totalString);
  934. $("body").append(div);
  935. // 用于判断是否要关闭窗体
  936. setTimeout(function() {
  937. isTotalShowing = true;
  938. }, 200);
  939. };
  940. },
  941. onButtonClick: function (e, info) {
  942. let node = projectObj.project.mainTree.items[info.row];
  943. if (node.data.isSubcontract) node.data.isSubcontract = false
  944. else node.data.isSubcontract = true;
  945. node.changed = true;
  946. projectObj.project.calcProgram.calcAndSave(node);
  947. },
  948. //根据节点获取行style(颜色、字体加粗)
  949. getNodeColorStyle: function (node, colSetting) {
  950. let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
  951. let mapping = {DEFAULT: 'DEFAULT', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
  952. FX: 'FX', BX: 'BX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
  953. let styleMap = null;
  954. //中文字段名,由于同一节点中,中文字体大小和数字字体大小不同
  955. if(colorSetting == null){
  956. return null;
  957. }
  958. let stringFields = [
  959. 'code',
  960. 'subType',
  961. 'name',
  962. 'unit',
  963. 'itemCharacterText',
  964. 'jobContentText',
  965. 'adjustState',
  966. 'calcBase',
  967. 'programID',
  968. 'ruleText'
  969. ];
  970. if(!isDef(node)){
  971. return null;
  972. }
  973. //清单大类
  974. if(node.sourceType === this.project.Bills.getSourceType()){
  975. //大项费用
  976. //大项费用
  977. if(node.data.type === billType.DXFY){
  978. styleMap = mapping.DXFY;
  979. }
  980. //分部
  981. if(node.data.type === billType.FB){
  982. styleMap = mapping.FB;
  983. }
  984. //分项
  985. else if(node.data.type === billType.FX){
  986. styleMap = mapping.FX;
  987. }
  988. //补项
  989. else if(node.data.type === billType.BX){
  990. styleMap = mapping.BX;
  991. }
  992. //清单
  993. else if(node.data.type === billType.BILL){
  994. //非叶子节点的清单
  995. if(node.source.children.length > 0){
  996. styleMap = mapping.UNLEAFBILL;
  997. }
  998. //未使用基数计算的叶子节点的清单
  999. else if(node.source.children.length === 0 && (!isDef(node.data.calcBase) || node.data.calcBase === '')){
  1000. styleMap = mapping.UNCBBILL;
  1001. }
  1002. //使用基数计算的叶子节点的清单
  1003. else if(node.source.children.length === 0 && isDef(node.data.calcBase && node.data.calcBaseValue !== '')){
  1004. styleMap = mapping.CBBILL;
  1005. }
  1006. }
  1007. }
  1008. //定额下的主材、设备
  1009. else if(node.sourceType === this.project.ration_glj.getSourceType()){
  1010. styleMap = mapping.ZCSB;
  1011. }
  1012. else {
  1013. styleMap = mapping.DEFAULT;
  1014. }
  1015. let styleSetting = colorSetting[styleMap];
  1016. let defaultSetting = colorSetting[mapping.DEFAULT];
  1017. if(!isDef(styleSetting)){
  1018. return null;
  1019. }
  1020. let style = new GC.Spread.Sheets.Style();
  1021. //设置style属性
  1022. for(let attr in styleSetting){
  1023. if(attr !== 'stringFont' && attr !== 'numFont'){
  1024. style[attr] = styleSetting[attr] === 'default' || !isDef(styleSetting[attr]) ? defaultSetting[attr] : styleSetting[attr];
  1025. }
  1026. //暂时不开放字体设置,开放的话只能每个单元格进入此方法
  1027. /* else {
  1028. if(stringFields.indexOf(colSetting.data.field) > 0){
  1029. style.font = styleSetting.stringFont === 'default' || !isDef(styleSetting.stringFont) ? defaultSetting.stringFont : styleSetting.stringFont;
  1030. }
  1031. else {
  1032. style.font = styleSetting.numFont === 'default' || !isDef(styleSetting.numFont) ? defaultSetting.numFont : styleSetting.numFont;
  1033. }
  1034. }*/
  1035. }
  1036. style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1037. style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1038. style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1039. style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
  1040. return style;
  1041. },
  1042. //大项费用则字体加粗,String 15px, Number 13px
  1043. getBoldFontStyle: function (node, colSetting) {
  1044. if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
  1045. return null;
  1046. }
  1047. let style = new GC.Spread.Sheets.Style();
  1048. //备注暂无字段
  1049. let stringFields = [
  1050. 'code',
  1051. 'subType',
  1052. 'name',
  1053. 'unit',
  1054. 'itemCharacterText',
  1055. 'jobContentText',
  1056. 'adjustState',
  1057. 'calcBase',
  1058. 'programID',
  1059. 'ruleText'
  1060. ];
  1061. if(stringFields.indexOf(colSetting.data.field) > 0){
  1062. style.font = 'bold 15px Arial';
  1063. }
  1064. else {
  1065. style.font = 'bold 13px Arial';
  1066. }
  1067. return style;
  1068. }
  1069. };
  1070. // 点击合计框中的复制
  1071. $("body").on("click", "#total-tips a", function() {
  1072. const totalElement = $(this).parent().siblings("p").find("#total");
  1073. totalElement.select();
  1074. document.execCommand("Copy");
  1075. $(this).text("已复制");
  1076. });
  1077. // 合计框点击其他位置关闭
  1078. let isTotalShowing = false;
  1079. $("body").on("click", function(e) {
  1080. if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
  1081. $("#total-tips").remove();
  1082. isTotalShowing = false;
  1083. }
  1084. });
  1085. $('#insert').click(function () {
  1086. var controller = projectObj.mainController, project = projectObj.project;
  1087. var selected = controller.tree.selected;
  1088. if (!selected || selected.sourceType === project.Bills.getSourceType()) {
  1089. ProjectController.addBills(project, controller);
  1090. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1091. ProjectController.addRation(project, controller, selected.data.type);
  1092. };
  1093. });
  1094. $('#delete').click(function () {
  1095. let project = projectObj.project;
  1096. let selected = project.mainTree.selected;
  1097. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
  1098. project.Bills.deleteSelectedNode();
  1099. }else {
  1100. $("#delete_row").modal({show:true});//弹出删除提示框;
  1101. }
  1102. });
  1103. $('#upLevel').click(function () {
  1104. var controller = projectObj.mainController, project = projectObj.project;
  1105. var selected = controller.tree.selected, orgParent = selected.parent;
  1106. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1107. project.Bills.upLevelBills(selected.source);
  1108. controller.upLevel();
  1109. controller.refreshTreeNode([orgParent]);
  1110. projectObj.project.calcProgram.calcBillsAndSave([selected,orgParent]);
  1111. }
  1112. });
  1113. $('#downLevel').click(function () {
  1114. var controller = projectObj.mainController, project = projectObj.project;
  1115. var selected = controller.tree.selected;
  1116. if (selected && selected.sourceType === project.Bills.getSourceType()) {
  1117. project.Bills.downLevelBills(selected.source);
  1118. controller.downLevel();
  1119. controller.refreshTreeNode([selected.parent]);
  1120. projectObj.converseCalculateBills(selected.parent);
  1121. }
  1122. });
  1123. $('#upMove').click(function () {
  1124. var controller = projectObj.mainController, project = projectObj.project;
  1125. var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;
  1126. if (selected.sourceType === project.Bills.getSourceType()) {
  1127. project.Bills.upMoveBills(selected.source);
  1128. controller.upMove();
  1129. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1130. project.Ration.changePos(selected.source, selected.preSibling.source);
  1131. controller.upMove();
  1132. };
  1133. });
  1134. $('#downMove').click(function () {
  1135. var controller = projectObj.mainController, project = projectObj.project;
  1136. var selected = controller.tree.selected, next, nextSerialNo;
  1137. if (selected) {
  1138. if (selected.sourceType === project.Bills.getSourceType()) {
  1139. project.Bills.downMoveBills(selected.source);
  1140. controller.downMove();
  1141. } else if (selected.sourceType === project.Ration.getSourceType()) {
  1142. project.Ration.changePos(selected.source, selected.nextSibling.source);
  1143. controller.downMove();
  1144. };
  1145. }
  1146. });
  1147. //显示至..
  1148. let displayLevel = function(nodes, depth, type){
  1149. let refreshNodes = [];
  1150. function getExpandedController(){
  1151. if(type === 'DXFY' || type === 'FB'){
  1152. if(type === 'FB'){
  1153. projectObj.project.mainTree.items[0].setExpanded(true);
  1154. refreshNodes.push(projectObj.project.mainTree.items[0]);
  1155. }
  1156. return function expandedControl(nodes, depth){
  1157. let bType = type === 'FB' ? billType.FB : billType.DXFY;
  1158. for(let node of nodes){
  1159. let nodeDepth = node.depth();
  1160. if(nodeDepth <= depth){
  1161. let expanded = nodeDepth === depth && !node.children[0] || nodeDepth < depth && node.children[0] && node.children[0].data.type === bType ? true : false;
  1162. node.setExpanded(expanded);
  1163. refreshNodes.push(node);
  1164. if(nodeDepth < depth){
  1165. expandedControl(node.children, depth);
  1166. }
  1167. }
  1168. }
  1169. }
  1170. }
  1171. else if(type === 'FX' || type === 'ZM' || type === 'ZD'){
  1172. return function expandedControl(nodes){
  1173. for(let node of nodes){
  1174. if(type !== 'FX' || node.sourceType === projectObj.project.Bills.getSourceType()){
  1175. let expanded = true;
  1176. if(type === 'FX'){
  1177. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType === projectObj.project.Bills.getSourceType() ? true : false;
  1178. }
  1179. else if(type === 'ZM'){
  1180. expanded = !node.children[0] || node.children[0] && node.children[0].sourceType !== projectObj.project.ration_glj.getSourceType() ? true : false;
  1181. }
  1182. node.setExpanded(expanded);
  1183. refreshNodes.push(node);
  1184. expandedControl(node.children);
  1185. }
  1186. }
  1187. }
  1188. }
  1189. }
  1190. getExpandedController()(nodes, depth);
  1191. let sheet = projectObj.mainSpread.getActiveSheet();
  1192. TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
  1193. TREE_SHEET_HELPER.refreshNodesVisible(refreshNodes, projectObj.mainSpread.getActiveSheet(), true)
  1194. });
  1195. };
  1196. $('#displayDXFY').click(function () {
  1197. displayLevel(projectObj.project.mainTree.items, 0, 'DXFY')
  1198. });
  1199. //显示至一级分部
  1200. $('#displayFB1').click(function () {
  1201. displayLevel(projectObj.project.mainTree.items[0].children, 1, 'FB');
  1202. });
  1203. //二级分部
  1204. $('#displayFB2').click(function () {
  1205. displayLevel(projectObj.project.mainTree.items[0].children, 2, 'FB');
  1206. });
  1207. //三级分部
  1208. $('#displayFB3').click(function () {
  1209. displayLevel(projectObj.project.mainTree.items[0].children, 3, 'FB');
  1210. });
  1211. //四级分部
  1212. $('#displayFB4').click(function () {
  1213. displayLevel(projectObj.project.mainTree.items[0].children, 4, 'FB');
  1214. });
  1215. //分项
  1216. $('#displayFX').click(function () {
  1217. displayLevel(projectObj.project.mainTree.items, null, 'FX');
  1218. });
  1219. //子目
  1220. $('#displayZM').click(function () {
  1221. displayLevel(projectObj.project.mainTree.items, null, 'ZM');
  1222. });
  1223. //最底层
  1224. $('#displayZD').click(function () {
  1225. displayLevel(projectObj.project.mainTree.roots, null, 'ZD');
  1226. });
  1227. $('#poj-set').on('show.bs.modal', function () {
  1228. let setCalcFlag = function (obj, val, curFlag) {
  1229. obj.val(val);
  1230. if (val === curFlag) {
  1231. obj.attr('checked', true);
  1232. } else {
  1233. obj.removeAttr('checked');
  1234. }
  1235. }
  1236. if (projectObj.project) {
  1237. // let mode = projectObj.project.projSetting.billsCalcMode;
  1238. // let settingConst = projectObj.project.projSetting.settingConst;、
  1239. let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
  1240. setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
  1241. setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
  1242. setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
  1243. setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
  1244. // mode = projectObj.project.projSetting.zanguCalcType;
  1245. let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
  1246. setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
  1247. setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
  1248. projDisplayView.init();
  1249. calcOptions.init();
  1250. }
  1251. });
  1252. $('#property_ok').click(function () {
  1253. let project = projectObj.project,
  1254. projectID = project.ID(),
  1255. properties = {},
  1256. labourCoes = {},
  1257. rations = [],
  1258. bills = [],
  1259. mixDatas = {
  1260. projectID: projectID,
  1261. updateType: 'update',
  1262. properties: properties,
  1263. labourCoes: labourCoes,
  1264. rations: rations,
  1265. bills: bills
  1266. },
  1267. reCalcBills = false,
  1268. reCalcRations = false;
  1269. let b = parseInt($("input[name='calcFlag']:checked").val());
  1270. if (b !== project.property.billsCalcMode) {
  1271. properties['property.billsCalcMode'] = b;
  1272. project.property.billsCalcMode = b;
  1273. reCalcBills = true;
  1274. };
  1275. let zg = parseInt($("input[name='zangu']:checked").val());
  1276. if (zg !== project.property.zanguCalcMode) {
  1277. properties['property.zanguCalcMode'] = zg;
  1278. project.property.zanguCalcMode = zg;
  1279. reCalcRations = true;
  1280. };
  1281. //基本信息
  1282. if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
  1283. properties['property.basicInformation'] = basicInfoView.toSaveDatas(basicInfoView.datas);
  1284. }
  1285. //工程特征
  1286. if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
  1287. properties['property.projectFeature'] = projFeatureView.toSaveDatas(projFeatureView.datas);
  1288. }
  1289. //清单工程量精度
  1290. let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
  1291. if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
  1292. billsQuanDecimal.datas = newBillsDecimalDatas;
  1293. reCalcBills = true;
  1294. properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
  1295. }
  1296. //小数位数
  1297. let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
  1298. if(toUpdateDecimal(decimalObj, updateDecimal)) {
  1299. let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
  1300. setDecimal(decimalObj, updateDecimal);
  1301. if (frChanged) {
  1302. project.calcProgram.compileAllTemps()
  1303. }
  1304. reCalcRations = true;
  1305. reCalcBills = true;
  1306. properties['property.decimal'] = updateDecimal;
  1307. }
  1308. // 呈现选项
  1309. projDisplayView.updateChecking(properties);
  1310. if(calcOptions.updateChecking(properties)){
  1311. reCalcRations = true;
  1312. }
  1313. // 人工系数
  1314. if (labourCoeView.needSave()){
  1315. let libID = $("#std_labour_coe_files").children("option:selected").val();
  1316. let libName = $("#std_labour_coe_files").children("option:selected").text();
  1317. labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
  1318. project.labourCoe.refreshData(labourCoes.updateData); // 全编译所用到的人工系数来自project.labourCoe,所以必须先刷新project.labourCoe
  1319. project.calcProgram.compileAllTemps();
  1320. reCalcRations = true;
  1321. reCalcBills = true;
  1322. };
  1323. // 重新计算树节点
  1324. let changedNodes = [];
  1325. if (reCalcRations) // 定额动,全部计算。算完先不存储,和后面的数据一起提交,一次通讯。
  1326. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
  1327. else if (reCalcBills) // 清单动,可以只计算清单。
  1328. changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
  1329. if (changedNodes.length > 0) {
  1330. for (let node of changedNodes){
  1331. let data = calcTools.cutNodeForSave(node);
  1332. if (node.sourceType == 'ration') rations.push(data)
  1333. else if (node.sourceType == 'bills') bills.push(data);
  1334. };
  1335. };
  1336. // for test.
  1337. /* console.log(mixDatas);
  1338. return; */
  1339. function hasMixData() {
  1340. return Object.keys(mixDatas.properties).length > 0 ||
  1341. mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
  1342. }
  1343. if(hasMixData()){
  1344. CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
  1345. /* if (changedNodes.length > 0) {
  1346. for (let node of changedNodes){delete node.changed};
  1347. };
  1348. if (mixDatas.labourCoes.updateData) labourCoeView.refresh();*/
  1349. window.location.href = '/main?project=' + projectID;
  1350. });
  1351. }
  1352. });
  1353. $('#delete_row').on('shown.bs.modal', function (e) {
  1354. var controller = projectObj.mainController, project = projectObj.project;
  1355. var selected = controller.tree.selected, parent = selected.parent;
  1356. var showinfo = "<label>确认要删除当前选中行吗?</label>";
  1357. var showN = false;
  1358. var cancelText = "否";
  1359. if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
  1360. if(isSingleSelect()||selectionChecking()){
  1361. showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
  1362. showN = true;
  1363. cancelText = "取消";
  1364. }
  1365. }
  1366. $('#delete_showinfo').html(showinfo);
  1367. showN==true? $('#deleteN').show():$('#deleteN').hide();
  1368. $('#deleteCancel').text(cancelText);
  1369. function selectionChecking() {
  1370. let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
  1371. let mainTreeMap = {};
  1372. for(let i =0;i<selection.rowCount;i++){
  1373. let tem_node = controller.tree.items[selection.row+i];
  1374. if(i==0){//第一个直接添加;
  1375. mainTreeMap[tem_node.getID()] = tem_node;
  1376. }else {
  1377. project.Bills.setNodeToMap(tem_node,mainTreeMap);
  1378. }
  1379. }
  1380. let nodes = changeMapToArray(mainTreeMap);
  1381. if(nodes.length==1){
  1382. return true
  1383. }
  1384. return false;
  1385. }
  1386. });
  1387. function changeMapToArray(map) {
  1388. let newArray = [];
  1389. for(let key in map){
  1390. newArray.push(map[key]);
  1391. }
  1392. return newArray;
  1393. }
  1394. $('#deleteY').click(function () { //正常删除,级联删除子项
  1395. let project = projectObj.project;
  1396. if(isSingleSelect()){
  1397. project.Bills.deleteSelectedNode();
  1398. }else {
  1399. project.Bills.deleteSelectedNodes();
  1400. }
  1401. });
  1402. $('#deleteN').click(function () {//不删除子项
  1403. let controller = projectObj.mainController, project = projectObj.project;
  1404. let selected = controller.tree.selected, parent = selected.parent;
  1405. if(selected){
  1406. let preNode = selected.preSibling;
  1407. let nextNode = selected.nextSibling;
  1408. if(preNode){//有前兄弟
  1409. if(preNode.children.length>0&&preNode.children[0].data.type != selected.children[0].data.type){//并且前兄弟子项和焦点行子项类别不同。
  1410. alert("删除分部会导致分部和分项同级,不允许该操作!");
  1411. return;
  1412. }
  1413. }else if(nextNode){
  1414. if(nextNode.data.type != selected.children[0].data.type){
  1415. alert("删除分部会导致分部和分项同级,不允许该操作! ");
  1416. return;
  1417. }
  1418. }
  1419. project.Bills.singleDeleteBills(selected,controller);
  1420. }
  1421. });
  1422. function isSingleSelect() {//是否选中造价书中的单行
  1423. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1424. if (selections[0].rowCount == 1) {
  1425. return true;
  1426. }
  1427. return false;
  1428. }
  1429. function ifCanDelete() {
  1430. let selections = projectObj.mainSpread.getActiveSheet().getSelections();
  1431. let tree = projectObj.project.mainTree;
  1432. let selected = projectObj.project.mainTree.selected;
  1433. if(selections[0].rowCount==1){//选中单行
  1434. return canDelete(selected);
  1435. }else {
  1436. return canDelete_m(selections[0]);
  1437. }
  1438. function canDelete(node,m_selection) {
  1439. if (node) {
  1440. if (node.sourceType === projectObj.project.Bills.getSourceType()) {
  1441. if(node.data.type == billType.DXFY&&node.data.isAdd!=1){
  1442. return false;
  1443. }
  1444. }
  1445. if(m_selection!=true&&node.sourceType === projectObj.project.ration_glj.getSourceType()){//多选的时候不做这一项判断
  1446. return false;
  1447. }
  1448. return true;
  1449. } else {
  1450. return false;
  1451. }
  1452. };
  1453. function canDelete_m(selection) {
  1454. for(let i =0;i<selection.rowCount;i++){
  1455. if(tree.items[selection.row+i]==undefined||tree.items[selection.row+i]==null){
  1456. return false;
  1457. }
  1458. if(i==0&&tree.items[selection.row].sourceType === projectObj.project.ration_glj.getSourceType()){
  1459. return false
  1460. }
  1461. if(canDelete(tree.items[selection.row+i],true)==false){
  1462. return false
  1463. }
  1464. }
  1465. return true
  1466. };
  1467. }