12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121 |
- /**
- * Created by Mai on 2017/6/21.
- */
- var projectObj = {
- project: null,
- mainSpread: null,
- mainController: null,
- gljSpreed:null,
- beforeMainTreeSelectedChange: function (node) {
- /*if (node) {
- subViewObj.saveComments(node);
- }*/
- },
- treeSelectedChanged: function (node) {
- let project = projectObj.project;
- subViewObj.loadComments(node);
- gljOprObj.showDataIfRationSelect(node);
- // CSL.2017.07.25
- if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
- calcProgramObj.showData(node);
- };
- //zhong 2017-9-1 特征及内容
- if(pageCCOprObj.active){
- pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
- if(node.sourceType === project.Bills.getSourceType()){
- pageCCOprObj.setCacheAndShow(node);
- }
- else{
- pageCCOprObj.clearData();
- }
- }
- },
- refreshBaseActn: function (tree) {
- let setButtonValid = function (valid, btn) {
- if (valid) {
- btn.removeClass('disabled');
- } else {
- btn.addClass('disabled');
- }
- };
- let selected = tree.selected, that = projectObj;
- let canUpLevel = function (node) {
- if (selected && selected.depth() > 0 && selected.canUpLevel()) {
- if (selected.sourceType === that.project.Bills.getSourceType()) {
- return (!selected.nextSibling) || (selected.children.length === 0) || (selected.source.children.length > 0);
- } else {
- return false;
- }
- } else {
- return false;
- }
- };
- let canDownLevel = function (node) {
- if (selected && selected.depth() > 0 && selected.canDownLevel()) {
- if (selected.sourceType === that.project.Bills.getSourceType()) {
- return (selected.preSibling.children.length === 0) || (selected.preSibling.source.children.length > 0);
- } else {
- return false;
- }
- } else {
- return false;
- }
- };
- let canDelete = function (node) {
- if (selected) {
- if (selected.sourceType === that.project.Bills.getSourceType()) {
- if(selected.data.type == billType.DXFY&&selected.data.isAdd!=1){//如果
- return false;
- }
- }if(selected.sourceType === that.project.ration_glj.getSourceType()){
- return false;
- }
- return true;
- } else {
- return false;
- }
- };
- setButtonValid(canUpLevel(selected), $('#upLevel'));
- setButtonValid(canDownLevel(selected), $('#downLevel'));
- setButtonValid(selected && (selected.depth() > 0) && selected.canUpMove(), $('#upMove'));
- setButtonValid(selected && (selected.depth() > 0) && selected.canDownMove(), $('#downMove'));
- setButtonValid(canDelete(selected), $('#delete'));
- },
- checkCommonField: function (editingText, colSetting) {
- let value;
- if (colSetting.data.decimal) {
- value = Number(editingText);
- if (number_util.isNumber(value)) {
- if (colSetting.data.decimal) {
- value = value.toDecimal(colSetting.data.decimal);
- }
- } else {
- value = null;
- alert('当前输入的数据类型不正确,请重新输入。');
- }
- } else {
- value = editingText;
- }
- return value;
- },
- checkFormulaValidField: function (editingText, colSetting) {
- let value = Number(editingText);
- if (!value) {
- try {
- let exp = new Expression('');
- exp.Expression(editingText);
- value = Number(exp.Evaluate());
- } catch (error) {
- value = null;
- }
- }
- if (value!=undefined||value!=null) {
- if (colSetting.data.decimal) {
- value = value.toDecimal(colSetting.data.decimal);
- }
- } else if (editingText && editingText !== '') {
- value = null;
- alert('当前输入的数据类型不正确,请重新输入。');
- }
- return value;
- },
- checkSpreadEditingText: function (editingText, colSetting) {
- if (colSetting.data.field === 'quantity'||colSetting.data.field === 'contain') {
- return this.checkFormulaValidField(editingText, colSetting);
- }
- else if (colSetting.data.field === 'programID') {
- return this.project.calcProgram.compiledTemplateMaps[editingText];
- }
- else if (colSetting.data.field === 'subType') {
- if (typeof(editingText) !== "number")
- return volumePriceMaps[editingText]
- else
- return editingText;
- }
- else {
- return this.checkCommonField(editingText, colSetting);
- }
- },
- /*updateAndReCalculate: function (node, fieldName, value) {
- let project = projectObj.project, calc = new BillsCalcHelper(project), nodes = [];
- let getNodes = function (node) {
- let cur = node, nodes = [];
- while (cur) {
- nodes.push(cur);
- cur = cur.parent;
- }
- return nodes;
- }
- if (value) {
- value = value.toDecimal(projectObj.project.Decimal.common.quantity);
- }
- if (node.sourceType === projectObj.project.Bills.getSourceType()) {
- calcFees.setFee(node.data, fieldName, value);
- calc.calcNode(node, true);
- nodes = getNodes(node);
- project.Bills.updateNodes(nodes, true);
- }
- else if (node.sourceType === projectObj.project.VolumePrice.getSourceType()) {
- project.beginUpdate('VolumePrice_QuantityChange');
- project.VolumePrice.updateField(node.source, fieldName, value, false);
- calc.calcNode(node.parent, true);
- nodes = getNodes(node.parent);
- project.Bills.updateNodes(nodes, false);
- project.endUpdate();
- nodes.push(node);
- }
- else if (node.sourceType === projectObj.project.Ration.getSourceType()) {
- project.beginUpdate('Ration_QuantityChange');
- calcFees.setFee(node.data, fieldName, value);
- node.data.gljList = project.ration_glj.getGljArrByRation(node.data.ID);
- // calcProgram.calculate的传参必须是cacheNode类型,故无法将计算放在Ration模块中。
- project.calcProgram.calculate(node);
- project.Ration.updateRation(node.source, false); // 加入待存储队列
- calc.calcNode(node.parent, true); //
- nodes = getNodes(node.parent);
- project.Bills.updateNodes(nodes, false);
- project.endUpdate();
- nodes.push(node);
- }
- this.mainController.refreshTreeNode(nodes, false);
- calc = null;
- },*/
- updateBillsCode: function (node, value) {
- let project = projectObj.project;
- let stdMatchCode, formatCode, matchs;
- let searchStdBillsAndUpdate = function (stdCode, formatCode) {
- let orgCode = node.data.code.substr(0, 9);
- if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
- project.Bills.updateField(node.source, 'code', formatCode, true);
- projectObj.mainController.refreshTreeNode([node], false);
- } else if (projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0) {
- let libId = projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id;
- CommonAjax.post('/stdBillsEditor/getStdBillsByCode', {userId: userID, billsLibId: libId, code: stdCode}, function (data) {
- if (data) {
- data.itemCharacter = pageCCOprObj.safeItemCharater(data.itemCharacter);
- if (/\//.test(data.unit)) {
- ConfirmModal.stdBillsUnit.check(data, function (std) {
- project.Bills.replaceBills(node.source, std, formatCode);
- projectObj.mainController.refreshTreeNode([node], false);
- }, function () {
- projectObj.mainController.refreshTreeNode([node], false);
- });
- } else {
- project.Bills.replaceBills(node.source, data, formatCode);
- projectObj.mainController.refreshTreeNode([node], false);
- }
- } else {
- project.Bills.updateField(node.source, 'code', formatCode, true);
- projectObj.mainController.refreshTreeNode([node], false);
- }
- });
- }
- }
- if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
- stdMatchCode = value;
- formatCode = project.Bills.newFormatCode(stdMatchCode);
- searchStdBillsAndUpdate(stdMatchCode, formatCode);
- } else if (value&&value.length === 12 && /^[\d]+$/.test(value)) {
- stdMatchCode = value.substr(0, 9);
- matchs = project.Bills.sameStdCode(stdMatchCode, node.data.code);
- if (matchs.indexOf(value) === -1) {
- searchStdBillsAndUpdate(stdMatchCode, value);
- } else if (confirm('已存在该编码的清单,是否继续?')) {
- formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
- searchStdBillsAndUpdate(stdMatchCode, formatCode);
- }
- } else {
- project.Bills.updateField(node.source, 'code', value, true);
- this.mainController.refreshTreeNode([node], false);
- }
- },
- updateRationCode: function (node, value) {
- if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
- alert('当前项目无定额库,请添加定额库。');
- this.mainController.refreshTreeNode([node], false);
- } else {
- let libId = projectInfoObj.projectInfo.engineeringInfo.ration_lib[0].id;
- CommonAjax.post('/complementaryRation/api/getRationItem', {user_id: userID, rationRepId: libId, code: value}, function (data) {
- if (data) {
- projectObj.project.Ration.replaceRation(node.source, data);
- projectObj.project.ration_glj.addRationGLJ(node.source, data);
- } else {
- alert('当前库中找不到定额"' + value + '"');
- }
- projectObj.mainController.refreshTreeNode([node], false);
- });
- }
- },
- updateCode: function (node, value) {
- let project = projectObj.project;
- if (node.sourceType === project.Bills.getSourceType()) {
- this.updateBillsCode(node, value); // 新清单不适合实时计算,下面套什么还不能确定,无数量计算也无意义
- } else if (node.sourceType === project.Ration.getSourceType()) {
- this.updateRationCode(node, value); // 新套定额适合实时计算
- // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
- /*project.calcProgram.calcAndSave(node);
- if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
- calcProgramObj.showData(node, false);
- };*/
- }
- },
- updateCellValue: function (node, value, colSetting) {
- let project = projectObj.project, fieldName = colSetting.data.field;
- if(node.sourceType==project.ration_glj.getSourceType()){
- project.ration_glj.updateFromMainSpread(value,node,fieldName);
- }else if(treeNodeTools.isGljRation(node)){
- gljOprObj.updateRationTypeGLJ(value,node,fieldName);
- } else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
- if (fieldName === 'code' && !treeNodeTools.isVolumePrice(node)) {
- projectObj.updateCode(node, value);
- }
- else if(fieldName ==='feeRate'){
- project.FeeRate.updateFeeRateFromBills(value,node,fieldName);
- }else if(fieldName ==='contain'){//编辑含量
- project.Ration.updateContain(value,node);
- }
- else if (fieldName === 'quantity' || fieldName === 'marketUnitFee' || fieldName === 'programID' ||
- fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'feesIndex.common.unitFee'){
- if (fieldName === 'quantity') {
- project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName);
- return;
- }
- else if (fieldName === 'marketUnitFee' || fieldName === 'feesIndex.common.unitFee') {
- if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("unitPrice", node))};
- }
- else if (fieldName === 'calcBase') {
- //zhong
- if(value === undefined ||value === null || value.toString().trim() === ''){
- value = '';
- }
- node.data.userCalcBase = value;
- project.calcBase.calculate(node);
- if(!project.calcBase.success){
- let activeCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];
- projectObj.mainSpread.getActiveSheet().setValue(activeCell.row, activeCell.col, node.data.calcBase? node.data.calcBase: '');
- return;
- }
- // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
- };
- node.changed = true;
- if (fieldName == 'feesIndex.common.unitFee'){
- treeNodeTools.initFeeField(node, 'common');
- node.data.feesIndex.common.unitFee = value;
- }
- else if(fieldName !== 'calcBase'){
- node.data[fieldName] = value;
- }
- project.calcProgram.calcAndSave(node);
- gljOprObj.showRationGLJSheetData();
- } else if (node.sourceType === project.Bills.getSourceType()&&fieldName === 'unit'){//修改清单单位的时候清单工程量要重新4舍5入
- node.data[fieldName] = value;
- node.changed = true;
- if(node.data.quantity){
- node.data.quantity =scMathUtil.roundForObj(node.data.quantity,getDecimal("quantity",node));
- }
- project.calcProgram.calcAndSave(node);
- }
- else {
- if (node.sourceType === project.Bills.getSourceType()) {
- project.Bills.updateField(node.source, fieldName, value, true);
- }
- else if (node.sourceType === project.Ration.getSourceType()) {
- project.Ration.updateField(node.source, fieldName, value, true);
- };
- if (colSetting.data.wordWrap) {
- this.mainSpread.getActiveSheet().autoFitRow(node.serialNo());
- }
- projectObj.mainController.refreshTreeNode([node]);
- }
- } else if(value==null && fieldName ==='feeRate'){
- project.FeeRate.cleanFeeRateID(node);
- } else {
- projectObj.mainController.refreshTreeNode([node], false);
- }
- },
- mainSpreadLeaveCell: function (sender, info) {
- let colSetting = projectObj.mainController.setting.cols[info.col];
- projectObj.lastCol = colSetting;
- },
- mainSpreadEnterCell: function (sender, info) {
- let colSetting = projectObj.mainController.setting.cols[info.col];
- if(colSetting.data.field === 'unit' || projectObj.lastCol.data.field === 'unit'||colSetting.data.field ==='subType'|| projectObj.lastCol.data.field === 'subType'){
- info.sheet.repaint();
- }
- },
- mainSpreadEditStarting: function (sender, info) {
- let project = projectObj.project;
- let node = project.mainTree.items[info.row];
- if(isDef(node) && node.sourceType === project.Ration.getSourceType() && isDef(node.data.code) && isDef(node.data.from) && node.data.from === 'cpt'){
- let orgV = info.sheet.getValue(info.row, info.col);
- let newV = orgV.replace(new RegExp('补'), '');
- info.sheet.setValue(info.row, info.col, newV);
- }
- },
- mainSpreadEditEnded: function (sender, info) {
- let project = projectObj.project;
- let node = project.mainTree.items[info.row];
- let colSetting = projectObj.mainController.setting.cols[info.col];
- let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
- // 检查输入类型等
- let value = projectObj.checkSpreadEditingText(info.editingText, colSetting);
- projectObj.updateCellValue(node, value, colSetting);
- // 自动行高
- const autoHeight = project.property.displaySetting.autoHeight;
- if (autoHeight) {
- projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
- }
- },
- mainSpreadRangeChanged: function (sender, info) {
- let project = projectObj.project, setting = projectObj.mainController.setting;
- if (info.changedCells.length > 0) {
- for (let changedCell of info.changedCells) {
- let cell = info.sheet.getCell(changedCell.row, changedCell.col);
- let node = project.mainTree.items[changedCell.row];
- let colSetting = setting.cols[changedCell.col];
- let value = projectObj.checkSpreadEditingText(cell.text(), colSetting);
- projectObj.updateCellValue(node, value, colSetting);
- }
- }
- },
- checkMainSpread: function () {
- if (!this.mainSpread) {
- this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
- this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
- }
- },
- refreshMainSpread: function () {
- if (this.mainSpread) {
- this.mainSpread.refresh();
- }
- },
- loadProjectData: function () {
- var that = this;
- this.project = PROJECT.createNew(scUrlUtil.GetQueryString('project'), userID);
- let startTime = +new Date();
- console.log("开始加载-----"+startTime);
- this.project.loadDatas(function (err) {
- if (!err) {
- that.project.projectGLJ.calcQuantity();//计算分部分项和技术措施项目消耗量;
- that.project.property = projectInfoObj.projectInfo.property;
- //that.project.calcProgram.compileAllTemps();
- that.project.calcBase.init(that.project);
- that.project.calcFields = JSON.parse(JSON.stringify(cpFeeTypes));
- // that.project.initCalcFields();
- let str = JSON.stringify(that.project.projSetting.main_tree_col);
- that.project.projSetting.mainGridSetting = JSON.parse(str);
- that.project.projSetting.mainGridSetting.frozenCols = 4;
- TREE_SHEET_HELPER.initSetting($('#billsSpread')[0], that.project.projSetting.mainGridSetting);
- const autoHeight = that.project.property.displaySetting !== undefined ?
- that.project.property.displaySetting.autoHeight : false;
- that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
- // for test. 后端没有绑定,暂时写死用于测试。
- /* if (col.data.field == '' && col.head.titleNames[0] == "取费专业") {
- col.data.field = 'programID';
- col.data.getText = 'getText.calcProgramName';
- col.data.cellType = 'cellType.calcProgramName';
- };*/
- col.data.splitFields = col.data.field.split('.');
- if (col.data.getText && Object.prototype.toString.apply(col.data.getText) === "[object String]") {
- col.data.getText = MainTreeCol.getEvent(col.data.getText);
- }
- if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
- col.readOnly = MainTreeCol.getEvent(col.readOnly);
- }
- if (col.data.cellType && Object.prototype.toString.apply(col.data.cellType) === "[object String]") {
- let getCellType = MainTreeCol.getEvent(col.data.cellType);
- col.data.cellType = getCellType;
- }
- // if (col.data.digit && Object.prototype.toString.apply(col.data.digit) === "[object String]") {
- // col.data.decimal = that.project.getDecimal(col.data.digit);
- // col.data.formatter = MainTreeCol.getNumberFormatter(col.data.decimal);
- // }
- if (col.data.field === 'code') {
- col.data.formatter = '@';
- }
- // 根据配置设置自动行高
- if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
- col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
- if (!autoHeight) {
- col.showHint = true;
- col.data.wordWrap = false;
- } else {
- col.showHint = false;
- col.data.wordWrap = true;
- }
- }
- if(col.data.field ==='quantity'){
- col.showHint = true;
- }
- // for test digit. CSLAAAAA
- if (col.data.field.hasSubStr("totalFee"))
- col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, false)
- else if (col.data.field.hasSubStr("unitFee"))
- col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, false)
- else if (col.data.field == "quantity")
- col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.quantity, false);
- });
- that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
- that.mainController.showTreeData();
- that.mainController.bind('refreshBaseActn', that.refreshBaseActn);
- that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.beforeTreeSelectedChange, that.beforeMainTreeSelectedChange);
- that.mainController.bind(TREE_SHEET_CONTROLLER.eventName.treeSelectedChanged, that.treeSelectedChanged);
- that.mainSpread.bind(GC.Spread.Sheets.Events.LeaveCell, that.mainSpreadLeaveCell);
- that.mainSpread.bind(GC.Spread.Sheets.Events.EnterCell, that.mainSpreadEnterCell);
- that.mainSpread.bind(GC.Spread.Sheets.Events.EditStarting, that.mainSpreadEditStarting);
- that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
- that.mainSpread.bind(GC.Spread.Sheets.Events.RangeChanged, that.mainSpreadRangeChanged);
- that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);
- that.loadMainSpreadContextMenu();
- that.loadFocusLocation();
- let endTime = +new Date();
- console.log("加载完成-----"+endTime);
- }
- else {
- }
- });
- },
- loadMainSpreadContextMenu: function () {
- var project = this.project, spread = this.mainSpread, controller = this.mainController;
- $.contextMenu({
- selector: '#billsSpread',
- build: function ($trigger, e) {
- var target = SheetDataHelper.safeRightClickSelection($trigger, e, spread);
- controller.setTreeSelected(controller.tree.items[target.row]);
- return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
- },
- items: {
- "insertRootBill": {
- name: "插入大项费用",
- icon: 'fa-sign-in',
- disabled: function () {
- //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
- },
- callback: function (key, opt) {
- ProjectController.addRootBill(project, controller);
- cbTools.refreshFormulaNodes();
- },
- visible: function(key, opt){
- return project.mainTree.selected&&project.mainTree.selected.parent==null;
- }
- },
- "insertFB": {
- name: "插入分部",
- icon: 'fa-sign-in',
- disabled: function () {
- let selected = project.mainTree.selected;
- if(selected.sourceType==project.Bills.getSourceType()){
- if(selected.data.type==billType.FB){
- return false;
- }
- if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
- if(selected.children.length>0){
- return selected.children[0].data.type==billType.FX;//焦点行是分部分项工程,且子项是分项
- }else {
- return false
- }
- }
- }
- return true;//除了清单,其它类型都只读
- },
- callback: function (key, opt) {
- ProjectController.addFB(project, controller);
- cbTools.refreshFormulaNodes();
- },
- visible: function(key, opt){
- return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
- }
- },
- "insertFX": {
- name: "插入分项",
- icon: 'fa-sign-in',
- disabled: function () {
- let selected = project.mainTree.selected;
- if(selected.sourceType==project.Bills.getSourceType()){
- if(selected.data.type==billType.FX){//焦点行是分项,有效显示
- return false
- }
- if(selected.data.type==billType.FB){//点行是分部,
- if(selected.children.length>0){//且有子项,子项是分部,灰显。
- return selected.children[0].data.type == billType.FB
- }else {
- return false;
- }
- }
- if(isFlag(selected.data)&&selected.data.flagsIndex.fixed.flag==fixedFlag.SUB_ENGINERRING){//焦点行是分部分项工程
- if(selected.children.length>0){
- return selected.children[0].data.type==billType.FB;//焦点行是分部分项工程,且子项是分部时灰显
- }else {
- return false
- }
- }
- }
- return true;//除了清单,其它类型都只读
- },
- callback: function (key, opt) {
- ProjectController.addFX(project, controller);
- cbTools.refreshFormulaNodes();
- },
- visible: function(key, opt){
- return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
- }
- },
- "insertBills": {
- name: "插入清单",
- icon: 'fa-sign-in',
- disabled: function () {
- return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
- },
- callback: function (key, opt) {
- if(project.mainTree.selected.data.type == billType.DXFY){
- if(project.mainTree.selected.data.calcBase&&project.mainTree.selected.data.calcBase!=""){
- alert("当前有基数计算不能插入子项。");
- return;
- }
- }
- ProjectController.addBills(project, controller);
- cbTools.refreshFormulaNodes();
- },
- visible: function(key, opt){
- return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;//不属于分部分项的话隐藏
- }
- },
- "insertRation": {
- name: "插入定额",
- icon: 'fa-sign-in',
- disabled: function () {
- var selected = project.mainTree.selected;
- return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
- },
- callback: function (key, opt) {
- ProjectController.addRation(project, controller, rationType.ration);
- cbTools.refreshFormulaNodes();
- },
- visible: function(key, opt){
- var selected = project.mainTree.selected;
- if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
- return false
- }else {
- return true
- }
- }
- },
- "insertLJ": {
- name: "插入量价",
- icon: 'fa-sign-in',
- disabled: function () {
- var selected = project.mainTree.selected;
- return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
- },
- callback: function (key, opt) {
- ProjectController.addRation(project, controller, rationType.volumePrice);
- cbTools.refreshFormulaNodes();
- },
- visible: function(key, opt){
- var selected = project.mainTree.selected;
- if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
- return false
- }else {
- return true
- }
- }
- },
- "insertGLJ": {
- name: "插入工料机",
- icon: 'fa-sign-in',
- disabled: function () {
- var selected = project.mainTree.selected;
- return project.Ration.addRationChecking(selected); // Vincent, 2018-01-02
- },
- callback: function (key, opt) {
- var selected = project.mainTree.selected;
- if(selected.sourceType == ModuleNames.bills){
- if(selected.data.type == billType.FX||selected.data.type ==billType.BILL){
- if(selected.data.calcBase&&selected.data.calcBase!=""){
- alert("当前有基数计算不能插入子项。");
- return;
- }
- }
- }
- getGLJData('insert');// ProjectController.addRation(project, controller, rationType.volumePrice);
- cbTools.refreshFormulaNodes();
- },
- visible: function(key, opt){
- var selected = project.mainTree.selected;
- if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
- return false
- }else {
- return true
- }
- }
- },
- "spr1": '--------',
- "delete": {
- name: '删除',
- icon: 'fa-remove',
- disabled: function () {
- var selected = project.mainTree.selected;
- return !selected;
- },
- callback: function () {
- var selected = controller.tree.selected, parent = selected.parent;
- if (selected) {
- if (selected.sourceType === project.Bills.getSourceType()) {
- if (cbTools.isUsedByFormula(selected)){
- alert('该清单行被其它公式结点引用,不允许删除!');
- return;
- };
- project.Bills.deleteBills(selected.source);
- controller.delete();
- } else if (selected.sourceType === project.Ration.getSourceType()) {
- project.Ration.delete(selected.source);
- controller.delete();
- };
- projectObj.converseCalculateBills(parent);
- cbTools.refreshFormulaNodes();
- }
- }
- },
- "spr2":'--------',
- "calculateAll_RationContent": {
- name: '造价计算',
- callback: function () {
- $.bootstrapLoading.start();
- let changedNodes = project.calcProgram.calcAllNodes();
- project.calcProgram.saveNodes(changedNodes);
- $.bootstrapLoading.end();
- }
- }
- }
- });
- },
- // 计算node及node的所有父项
- converseCalculateBills: function (node) {
- /* if (node) {
- let calc = new BillsCalcHelper(this.project);
- calc.calcNode(node, true);
- let cur = node, nodes = [];
- while (cur) {
- nodes.push(cur);
- cur = cur.parent;
- }
- this.mainController.refreshTreeNode(nodes, false);
- this.project.Bills.updateNodes(nodes, true);
- calc = null;
- }*/
- projectObj.project.calcProgram.calcAndSave(node);
- },
- // 计算全部清单
- /* calculateAll: function () {
- let calc = new BillsCalcHelper(this.project);
- calc.calcAll();
- this.mainController.showTreeData();
- this.project.Bills.updateAll();
- calc = null;
- }*/
- // 获取上次退出时的焦点位置
- loadFocusLocation: function() {
- const projectId = scUrlUtil.GetQueryString('project');
- let row = getLocalCache('lastRow:' + projectId);
- let col = getLocalCache('lastCol:' + projectId);
- if (row !== null && col !== null) {
- row = parseInt(row);
- col = parseInt(col);
- const sheet = this.mainSpread.getActiveSheet();
- sheet.setSelection(row, col, 1, 1);
- this.mainController.setTreeSelected(this.mainController.tree.items[row]);//触发树节点选中事件
- }
- },
- // 选中区域合计数字
- amountAreaNumber: function(e, info) {
- if (info.newSelections === undefined || info.newSelections.length <= 0) {
- return false;
- }
- const selectedArea = info.newSelections[0];
- const sheet = info.sheet;
- if (selectedArea.colCount <= 1 && selectedArea.rowCount <= 1) {
- return false;
- }
- // 获取鼠标位置
- let x = window.event.clientX;
- let y = window.event.clientY;
- // 匹配数字或小数
- const regular = /^([0-9]+[.]{1}[0-9]+)$|^([1-9]{1}\d*)$/;
- // 小数点最高位数
- let max = 0;
- let total = 0;
- let counter = 0;
- for (let col = selectedArea.col; col < (selectedArea.colCount + selectedArea.col); col++) {
- for (let row = selectedArea.row; row < (selectedArea.rowCount + selectedArea.row); row++) {
- const value = sheet.getCell(row, col).text();
- if (!regular.test(value)) {
- continue;
- }
- counter++;
- // 获取当前数据小数位数
- let pointPosition = value.toString().indexOf(".");
- pointPosition = pointPosition < 0 ? pointPosition : pointPosition + 1;
- const current = pointPosition > 0 ? value.toString().substring(pointPosition, value.toString().length).length : 0;
- max = current > max ? current : max;
- total += parseFloat(value);
- }
- }
- // 如果不为0则悬浮显示
- if (total > 0 && counter > 1) {
- 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>');
- div.css({
- position: "absolute",
- border: "1px #C0C0C0 solid",
- background: "#fff",
- boxShadow: "1px 2px 5px rgba(0,0,0,0.4)",
- });
- div.children("p").css({
- textAlign: "center",
- padding: 8,
- marginBottom: 2,
- });
- div.children("p").first().css({
- borderBottom: "1px #C0C0C0 solid"
- });
- const totalString = total.toFixed(max);
- // input长度
- const inputWidth = totalString.length * 8;
- // 计算是否会超出显示范围
- const baseWidth = 48;
- const baseHeight = 81;
- const canvasWidth = $("#billsSpreadvp_vp").width();
- const canvasHeight = $("#billsSpreadvp_vp").height();
- x = x + baseWidth + inputWidth > canvasWidth ? x - baseWidth - inputWidth : x;
- y = y + baseHeight > canvasHeight ? y - baseHeight : y;
- div.css({
- left: x,
- top: y,
- });
- div.children().children("#total").width(inputWidth).val(totalString);
- $("body").append(div);
- // 用于判断是否要关闭窗体
- setTimeout(function() {
- isTotalShowing = true;
- }, 200);
- };
- }
- };
- // 点击合计框中的复制
- $("body").on("click", "#total-tips a", function() {
- const totalElement = $(this).parent().siblings("p").find("#total");
- totalElement.select();
- document.execCommand("Copy");
- $(this).text("已复制");
- });
- // 合计框点击其他位置关闭
- let isTotalShowing = false;
- $("body").on("click", function(e) {
- if (isTotalShowing && !$(e.target).is("#total-tips") && !$(e.target).is("#total-tips p") && !$(e.target).is("#total-tips p a")) {
- $("#total-tips").remove();
- isTotalShowing = false;
- }
- });
- $('#insert').click(function () {
- var controller = projectObj.mainController, project = projectObj.project;
- var selected = controller.tree.selected;
- if (!selected || selected.sourceType === project.Bills.getSourceType()) {
- ProjectController.addBills(project, controller);
- } else if (selected.sourceType === project.Ration.getSourceType()) {
- ProjectController.addRation(project, controller, selected.data.type);
- };
- cbTools.refreshFormulaNodes();
- });
- $('#delete').click(function () {
- $("#delete_row").modal({show:true});//弹出删除提示框;
- });
- $('#upLevel').click(function () {
- var controller = projectObj.mainController, project = projectObj.project;
- var selected = controller.tree.selected, orgParent = selected.parent;
- if (selected && selected.sourceType === project.Bills.getSourceType()) {
- project.Bills.upLevelBills(selected.source);
- controller.upLevel();
- projectObj.converseCalculateBills(orgParent);
- }
- });
- $('#downLevel').click(function () {
- var controller = projectObj.mainController, project = projectObj.project;
- var selected = controller.tree.selected;
- if (selected && selected.sourceType === project.Bills.getSourceType()) {
- project.Bills.downLevelBills(selected.source);
- controller.downLevel();
- projectObj.converseCalculateBills(selected.parent);
- }
- });
- $('#upMove').click(function () {
- var controller = projectObj.mainController, project = projectObj.project;
- var selected = controller.tree.selected, pre = selected.preSibling, preSerialNo;
- if (selected.sourceType === project.Bills.getSourceType()) {
- project.Bills.upMoveBills(selected.source);
- controller.upMove();
- } else if (selected.sourceType === project.Ration.getSourceType()) {
- project.Ration.changePos(selected.source, selected.preSibling.source);
- controller.upMove();
- };
- });
- $('#downMove').click(function () {
- var controller = projectObj.mainController, project = projectObj.project;
- var selected = controller.tree.selected, next, nextSerialNo;
- if (selected) {
- if (selected.sourceType === project.Bills.getSourceType()) {
- project.Bills.downMoveBills(selected.source);
- controller.downMove();
- } else if (selected.sourceType === project.Ration.getSourceType()) {
- project.Ration.changePos(selected.source, selected.nextSibling.source);
- controller.downMove();
- };
- }
- });
- $('#poj-set').on('show.bs.modal', function () {
- let setCalcFlag = function (obj, val, curFlag) {
- obj.val(val);
- if (val === curFlag) {
- obj.attr('checked', true);
- } else {
- obj.removeAttr('checked');
- }
- }
- if (projectObj.project) {
- // let mode = projectObj.project.projSetting.billsCalcMode;
- // let settingConst = projectObj.project.projSetting.settingConst;
- let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
- setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
- setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
- setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
- setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
- // mode = projectObj.project.projSetting.zanguCalcType;
- let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
- setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
- setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
- }
- });
- $('#property_ok').click(function () {
- let project = projectObj.project,
- projectID = project.ID(),
- properties = {},
- labourCoes = {},
- rations = [],
- bills = [],
- mixDatas = {
- projectID: projectID,
- updateType: 'update',
- properties: properties,
- labourCoes: labourCoes,
- rations: rations,
- bills: bills
- },
- reCalcBills= false,
- reCalcRations= false;
- let b = parseInt($("input[name='calcFlag']:checked").val());
- if (b !== project.property.billsCalcMode) {
- properties['property.billsCalcMode'] = b;
- project.property.billsCalcMode = b;
- reCalcBills = true;
- };
- let zg = parseInt($("input[name='zangu']:checked").val());
- if (zg !== project.property.zanguCalcMode) {
- properties['property.zanguCalcMode'] = zg;
- project.property.zanguCalcMode = zg;
- reCalcBills = true;
- };
- //基本信息
- if(basicInfoView.toUpdate(basicInfoView.orgDatas, basicInfoView.datas)){
- properties['property.basicInformation'] = basicInfoView.toSaveDatas(basicInfoView.datas);
- }
- //工程特征
- if(projFeatureView.toUpdate(projFeatureView.orgDatas, projFeatureView.datas)){
- properties['property.projectFeature'] = projFeatureView.toSaveDatas(projFeatureView.datas);
- }
- //清单工程量精度
- let newBillsDecimalDatas = billsDecimalView.toBillsDecimalDatas(billsDecimalView.cache);
- if(billsDecimalView.toUpdate(billsQuanDecimal.datas, newBillsDecimalDatas)){
- billsQuanDecimal.datas = newBillsDecimalDatas;
- reCalcBills = true;
- properties['property.billsQuantityDecimal'] = newBillsDecimalDatas;
- }
- //小数位数
- let updateDecimal = m_getDecimalData($('input', '#poj-settings-decimal'));
- if(toUpdateDecimal(decimalObj, updateDecimal)) {
- let frChanged = decimalObj.feeRate != updateDecimal.feeRate;
- setDecimal(decimalObj, updateDecimal);
- if (frChanged) {
- project.calcProgram.compileAllTemps()
- }
- reCalcRations = true;
- reCalcBills = true;
- properties['property.decimal'] = updateDecimal;
- }
- // 呈现选项
- projDisplayView.updateChecking(properties);
- if(calcOptions.updateChecking(properties)){
- reCalcRations = true;
- }
- // 人工系数
- if (labourCoeView.needSave()){
- let libID = $("#std_labour_coe_files").children("option:selected").val();
- let libName = $("#std_labour_coe_files").children("option:selected").text();
- labourCoes.updateData = {libID: libID, libName: libName, newItemArr: labourCoeView.needUpdateDatas};
- project.labourCoe.refreshData(labourCoes.updateData); // 全编译所用到的人工系数来自project.labourCoe,所以必须先刷新project.labourCoe
- project.calcProgram.compileAllTemps();
- reCalcRations = true;
- reCalcBills = true;
- };
- // 重新计算树节点
- let changedNodes = [];
- if (reCalcRations) // 定额动,全部计算。
- changedNodes = project.calcProgram.calcAllNodes(calcAllType.catAll)
- else if (reCalcBills) // 清单动,可以只计算清单。
- changedNodes = project.calcProgram.calcAllNodes(calcAllType.catBills);
- if (changedNodes.length > 0) {
- for (let node of changedNodes){
- let data = {
- // projectID: projectID,
- ID: node.data.ID,
- quantity: node.data.quantity,
- calcBase: node.data.calcBase,
- calcBaseValue: node.data.calcBaseValue,
- marketUnitFee: node.data.marketUnitFee,
- marketTotalFee: node.data.marketTotalFee,
- fees: node.data.fees,
- feeRate: node.data.feeRate,
- feeRateID: node.data.feeRateID
- };
- if (node.sourceType == 'ration'){
- rations.push(data);
- }
- else if (node.sourceType == 'bills'){
- bills.push(data);
- };
- };
- };
- // for test.
- /* console.log(mixDatas);
- return; */
- function hasMixData() {
- return Object.keys(mixDatas.properties).length > 0 ||
- mixDatas.labourCoes.updateData || mixDatas.rations.length > 0 || mixDatas.bills.length > 0;
- }
- if(hasMixData()){
- CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
- /* if (changedNodes.length > 0) {
- for (let node of changedNodes){delete node.changed};
- };
- if (mixDatas.labourCoes.updateData) labourCoeView.refresh();*/
- window.location.href = '/main?project=' + projectID;
- });
- }
- });
- $('#delete_row').on('shown.bs.modal', function (e) {
- var controller = projectObj.mainController, project = projectObj.project;
- var selected = controller.tree.selected, parent = selected.parent;
- var showinfo = "确认要删除当前选中行吗?";
- var showN = false;
- var cancelText = "否";
- if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){
- showinfo = "是否删除其下的子项?";
- showN = true;
- cancelText = "取消";
- }
- $('#delete_showinfo').text(showinfo);
- showN==true? $('#deleteN').show():$('#deleteN').hide();
- $('#deleteCancel').text(cancelText);
- });
- $('#deleteY').click(function () { //正常删除,级联删除子项
- let controller = projectObj.mainController, project = projectObj.project;
- let selected = controller.tree.selected, parent = selected.parent;
- if (selected) {
- if (selected.sourceType === project.Bills.getSourceType()) {
- if (cbTools.isUsedByFormula(selected)){
- alert('该清单行被其它公式结点引用,不允许删除!');
- return;
- }
- project.Bills.deleteBills(selected.source);
- controller.delete();
- } else if (selected.sourceType === project.Ration.getSourceType()) {
- project.Ration.delete(selected.source);
- controller.delete();
- }else if(selected.sourceType==ModuleNames.ration_glj){
- project.ration_glj.updataOrdelete(selected.source);
- }
- if(parent){
- projectObj.converseCalculateBills(parent);
- }else { //删除的是大项费用要重新计算工程造价节点
- let roots = controller.tree.roots;
- for(let root of roots){
- if(project.Bills.isEngineeringCost(root)==true){
- project.calcProgram.calcAndSave(root);
- break;
- }
- }
- }
- }
- cbTools.refreshFormulaNodes();
- });
- $('#deleteN').click(function () {//不删除子项
- let controller = projectObj.mainController, project = projectObj.project;
- let selected = controller.tree.selected, parent = selected.parent;
- let updateData = {};
- if(selected){
- let preNode = selected.preSibling;
- let nextNode = selected.nextSibling;
- if(preNode){//有前兄弟
- if(preNode.children.length>0&&preNode.children[0].data.type != selected.children[0].data.type){//并且前兄弟子项和焦点行子项类别不同。
- alert("删除分部会导致分部和分项同级,不允许该操作!");
- return;
- }
- }else if(nextNode){
- if(nextNode.data.type != selected.children[0].data.type){
- alert("删除分部会导致分部和分项同级,不允许该操作! ");
- return;
- }
- }
- project.Bills.singleDeleteBills(selected,controller);
- }
- });
|