123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373 |
- /**
- * Created by Mai on 2017/6/21.
- */
- var projectObj = {
- project: null,
- mainSpread: null,
- mainController: null,
- gljSpreed:null,
- beforeMainTreeSelectedChange: function (pre) {
- /*if (node) {
- subViewObj.saveComments(node);
- }*/
- },
- // CSL, 2018-02-09 用于测试显示。使用示例:projectObj.testDisplay(‘总额’, 100);
- testDisplay: function (caption, value) {
- let c = '';
- if (caption) c = caption + ': ';
- let s = ` ${c}${value}`;
- $('#testDisplay').html(s);
- },
- treeSelectedChanged: function (node) {
- let project = projectObj.project;
- let mainSheet = projectObj.mainController.sheet;
- //设置选中行底色和恢复前选中行底色
- let refreshNodes = [node];
- if(!project.mainTree.preSelected){
- refreshNodes.push(project.mainTree.items[0]);
- }
- else {
- refreshNodes.push(project.mainTree.preSelected);
- }
- project.mainTree.preSelected = node;
- projectObj.setNodesStyle(projectObj.mainController.sheet, refreshNodes);
- if($('#linkComments').hasClass('active')){
- subViewObj.loadComments(node);
- }
- gljOprObj.showDataIfRationSelect(node);
- if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
- calcProgramObj.showData(node);
- }
- //zhong 2017-9-1 特征及内容
- if(pageCCOprObj.active){
- pageCCOprObj.mainActiveCell = projectObj.mainSpread.getActiveSheet().getSelections()[0];//mainSpread焦点单元格
- pageCCOprObj.setCacheAndShow(node);
- }
- // for test interface. CSLAAAAA
- // projectObj.testDisplay('前四项累计值排除当前选中项' + projectObj.project.calcProgram.getBeforeTaxTotalFee([node]));
- // 基数
- // node.data.isSubcontract = true;
- // node.data.gljList = project.ration_glj.getGljArrByRation(node.data);
- // let bname = '甲供定额基价材料费';
- // projectObj.testDisplay(bname, rationCalcBases[bname](node));
- },
- 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(!node){
- return false;
- }
- if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
- return false;
- }
- if(node.depth()<=1){//焦点行是树结构的第一/二层节点,灰显。
- return false;
- }
- if(node.sourceType !== that.project.Bills.getSourceType()){//焦点行是定额/量价/工料机,灰显。
- return false;
- }else {
- if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项,或者补项灰显。
- return false;
- }
- if(node.data.type == billType.FB&&node.nextSibling&&node.children.length>0){//焦点行是分部有后兄弟,有子项.
- if(node.children[0].data.type==billType.FX || node.children[0].data.type==billType.BX){ //焦点行子项是分项
- return false;
- }
- }
- if(node.data.type == billType.BILL &&node.nextSibling){//焦点行是清单有后兄弟
- if(node.data.calcBase&&node.data.calcBase!=""){//有基数计算
- return false;
- }
- if(node.children.length>0&&node.children[0].sourceType !== that.project.Bills.getSourceType()){//有子项,并且子项不是清单
- return false;
- }
- }
- }
- return true;
- };
- let canDownLevel = function (node) {
- if(!node){
- return false;
- }
- if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
- return false;
- }
- if(node.depth()==0){//焦点行是树结构的第一层节点,灰显。
- return false;
- }
- if(node.sourceType !== that.project.Bills.getSourceType()) {//焦点行是定额/量价/工料机,灰显。
- return false;
- }else {
- if(node.data.type == billType.FX || node.data.type == billType.BX){//是分项,灰显。
- return false;
- }
- if(!node.preSibling){//无前兄弟,灰显
- return false;
- }else if(node.preSibling.data.calcBase&&node.preSibling.data.calcBase!=""){//前兄弟有基数计算
- return false
- }
- if(node.preSibling.children.length>0){//前兄弟有子项,子项是分项,灰显。
- if(node.data.type==billType.FB&&(node.preSibling.children[0].data.type==billType.FX||node.preSibling.children[0].data.type==billType.BX)){//焦点行是分部前兄弟有子项,子项是分项,灰显。
- return false;
- }
- if(node.data.type==billType.BILL&&node.preSibling.children[0].sourceType !== that.project.Bills.getSourceType()){//焦点行是清单,子项不是清单
- return false
- }
- }
- }
- return true;
- };
- let canUpMove = function (node) {
- if(node&&node.preSibling){//有前兄弟
- if(node.sourceType==that.project.Bills.getSourceType()){
- if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
- return false;
- }
- if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
- return false;
- }
- }
- return true
- }
- return false
- };
- let canDownMove = function (node) {
- if(node&&node.nextSibling){
- if(node.sourceType==that.project.Bills.getSourceType()){
- if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
- return false;
- }
- if(node.data.type == billType.DXFY&&node.data.isAdd!==1){
- return false;
- }
- }
- return true;
- }
- return false
- };
-
- setButtonValid(ifCanDelete(), $('#delete'));
- setButtonValid(canUpLevel(selected), $('#upLevel'));
- setButtonValid(canDownLevel(selected), $('#downLevel'));
- setButtonValid(canUpMove(selected) , $('#upMove'));
- setButtonValid(canDownMove(selected), $('#downMove'));
- setButtonValid(!projectObj.project.isBillsLocked(), $('#ZLFB_btn'));
- },
- 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);
- }
- },
- getVisibleRows: function (sRow, count) {
- let rst = [];
- let nodes = projectObj.project.mainTree.items;
- for(let i = sRow, len = nodes.length; i < len; i++){
- if(count <= 0){
- break;
- }
- if(nodes[i].visible){
- rst.push(i);
- count--;
- }
- }
- return rst;
- },
- //获取粘贴更改的单元格(粘贴时,跳过隐藏行)
- checkSpreadChangedCells: function (info) {
- let rst = {refreshRows: [], changedCells: []};
- //获取显示行号
- let vRows = projectObj.getVisibleRows(info.row, info.rowCount);
- let vCount = vRows.length;
- let lastRow = null, count = 0;
- for(let cell of info.changedCells){
- cell.text = info.sheet.getCell(cell.row, cell.col).text();
- if(cell.row !== lastRow){
- count++;
- lastRow = cell.row;
- }
- if(count <= vCount){
- if(vRows[count - 1] !== cell.row){
- rst.refreshRows.push(cell.row);
- }
- rst.changedCells.push({row: vRows[count - 1], col: cell.col, text: cell.text});
- }
- else {
- rst.refreshRows.push(cell.row);
- }
- }
- rst.refreshRows = Array.from(new Set(rst.refreshRows));
- return rst;
- },
- updateBillsCode: function (node, value) {
- let project = projectObj.project,me = this;
- let stdMatchCode, formatCode, matchs;
- let searchStdBillsAndUpdate = function (stdCode, formatCode) {
- let orgCode = node.data.code?node.data.code.substr(0, 9):"";
- if (stdCode === orgCode || projectInfoObj.projectInfo.engineeringInfo.bill_lib.length === 0) {
- normalUpdate(node,value);
- } 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);
- node.data.name = data.name;
- if(node.data.type == billType.BX){//从清单库中找到标准清单的话,要把补项改成分项
- node.data.type = billType.FX;
- }
- pageCCOprObj.setItemContentNode(node, data.jobContent, data.itemCharacter, node.data.name);
- if (/\//.test(data.unit)) {
- let existB = projectObj.project.Bills.sameStdCodeBillsData(data.code);
- if (existB) {
- data.unit = existB.unit;
- //
- project.Bills.replaceBills(node.source, data, formatCode);
- projectObj.mainController.refreshTreeNode([node], false);
- } else {
- 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 {
- normalUpdate(node,value);
- }
- });
- }
- }
- //分部分项、措施项目才匹配
- let withinValidFixed = false;
- let matchFixedFlags = [fixedFlag.SUB_ENGINERRING, fixedFlag.MEASURE];
- let rootNode = getRootFixedNode(node);
- if(rootNode && rootNode.data.flagsIndex && rootNode.data.flagsIndex.fixed && matchFixedFlags.includes(rootNode.data.flagsIndex.fixed.flag)){
- withinValidFixed = true;
- }
- if(withinValidFixed && (node.data.type==billType.FX||node.data.type==billType.BX||(node.data.type==billType.BILL&&node.source.children.length==0))){//是分项、补项或者叶子清单的情况下才需要查找替换
- if (value&&value.length === 9 && /^[\d]+$/.test(value)) {
- stdMatchCode = value;
- formatCode = project.Bills.newFormatCode(stdMatchCode);
- searchStdBillsAndUpdate(stdMatchCode, formatCode);
- return;
- } 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);
- return;
- } else {
- if (confirm('已存在该编码的清单,是否继续?')) {
- // formatCode = project.Bills.newFormatCode(stdMatchCode, node.data.code);
- searchStdBillsAndUpdate(stdMatchCode, value);
- return;
- }else {
- this.mainController.refreshTreeNode([node], false);
- return;
- }
- }
- }
- }
- normalUpdate(node,value);
- function normalUpdate(billnode,codeValue) {//在标准库中没有找到清单时改分项为补项再更新
- let toBX = false;
- if(billnode.data.type == billType.FX){
- billnode.data.type = billType.BX;
- toBX = true;
- }
- project.Bills.updateField(billnode.source, 'code', codeValue, toBX);
- me.mainController.refreshTreeNode([billnode], false);
- }
- },
- updateRationCode: function (node, value) {
- if(!isDef(node.data.code) && (!isDef(value) || value.toString().trim() == '')){
- return;
- }
- if (projectInfoObj.projectInfo.engineeringInfo.ration_lib.length === 0) {
- alert('当前项目无定额库,请添加定额库。');
- this.mainController.refreshTreeNode([node], false);
- } else {
- let libId = parseInt($('#stdRationLibSelect').val());
- 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()) {
- if(value && typeof(value) == 'string'){//小写转换成大写
- value = value.toUpperCase();
- }
- project.Ration.updateRationCodes([{'node':node,value:value}]);
- // this.updateRationCode(node, value); // 新套定额适合实时计算
- // 这里因异步问题暂时缺少工料机价格。该过程移到:ration_glj.js的refreshAfterSave方法中。
- /*project.calcProgram.calcAndSave(node);
- if (activeSubSheetIs(subSheetIndex.ssiCalcProgram)) {
- calcProgramObj.showData(node, false);
- };*/
- }
- },
- updateNodeField : function (node,value,filedID,callback) {
- if(node.data[filedID] == value){
- return;
- }
- let data = {
- type:node.sourceType,
- data:{
- ID:node.data.ID
- }
- };
- data.data[filedID] = value;
- $.bootstrapLoading.start();
- projectObj.project.updateNodes([data],function () {
- node.data[filedID] = value;
- if(callback){
- callback();
- }
- $.bootstrapLoading.end();
- })
- },
- updateCellValue: function (node, value, colSetting,editingText) {
- let project = projectObj.project, fieldName = colSetting.data.field;
- if(node.sourceType==project.ration_glj.getSourceType()){
- project.ration_glj.updateFromMainSpread(value,node,fieldName);
- }else if(fieldName === 'remark'){
- projectObj.updateNodeField(node,value,'remark');
- } else if(calcTools.isGljRation(node)){
- gljOprObj.updateRationTypeGLJ(value,node,fieldName,editingText);
- } else if (value !== calcFees.getFee(node.data, fieldName)||fieldName == 'quantity') {//工程量需要进行转换,所以做特殊处理
- if (fieldName === 'code' && !calcTools.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 === 'feesIndex.common.unitFee' || fieldName === 'programID' ||
- fieldName === 'subType' || fieldName === 'calcBase' || fieldName === 'isSubcontract'){
- if (fieldName === 'quantity') {
- project.quantity_detail.editMainTreeNodeQuantity(value,node,fieldName,editingText);
- 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.mainController.refreshTreeNode([node]);
- return;
- }
- // if (value) {value = parseFloat(value).toDecimal(decimalObj.decimal("totalPrice", node))};
- };
- //计算基数赋值要经过解析和标准化,已在calculate里赋值
- if(fieldName !== 'calcBase'){
- calcTools.setFieldValue(node, 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, false);
- }
- else if (node.sourceType === project.Ration.getSourceType()) {
- project.Ration.updateField(node.source, fieldName, value);
- };
- 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;
- projectObj.lastCell = {row: info.row, col: info.col};
- },
- //repaint 动态下拉框
- mainSpreadEnterCell: function (sender, info) {
- let colSetting = projectObj.mainController.setting.cols[info.col];
- if(colSetting.data.field === 'unit' || (projectObj.lastCol&&projectObj.lastCol.data.field === 'unit')||colSetting.data.field ==='subType'
- || (projectObj.lastCol&&projectObj.lastCol.data.field === 'subType') || colSetting.data.field === 'programID' ||(projectObj.lastCol&&projectObj.lastCol.data.field === 'programID')){
- let rects = [];
- rects.push(info.sheet.getCellRect(info.row, info.col));
- if(projectObj.lastCell){
- rects.push(info.sheet.getCellRect(projectObj.lastCell.row, projectObj.lastCell.col));
- }
- for(let rect of rects){
- info.sheet.repaint(rect);
- }
- }
- },
- mainSpreadEditStarting: function (sender, info) {
- let project = projectObj.project;
- let node = project.mainTree.items[info.row];
- let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
- let orgV = info.sheet.getValue(info.row, info.col);
- let newV;
- if(node && node.sourceType === projectObj.project.Ration.getSourceType() && node.data.type === rationType.ration
- && isDef(node.data.code) && isDef(node.data.prefix) && node.data.prefix !== rationPrefix.none && fieldName === 'code'){
- if(node.data.prefix === rationPrefix.complementary){
- newV = orgV.replace(new RegExp('补'), '');
- }
- if(node.data.prefix === rationPrefix.borrow){
- newV = orgV.replace(new RegExp('借'), '');
- }
- info.sheet.setValue(info.row, info.col, newV);
- }
- },
- onCellDoubleClick: function (sender, info){
- let project = projectObj.project;
- let node = project.mainTree.items[info.row];
- let fieldName = projectObj.mainController.setting.cols[info.col].data.field;
- if(fieldName == 'marketUnitFee'){
- if(gljOprObj.hasComposition(node.data,true)){
- alert("当前人材机的市场价由组成物计算得出,不可直接修改。");
- return;
- }
- }
- },
- mainSpreadEditEnded: function (sender, info) {
- let project = projectObj.project;
- let node = project.mainTree.items[info.row];
- console.log( project.withinBillsLocked(node));
- project.withinBillsLocked(node);
- 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,info.editingText);
- // 自动行高
- const autoHeight = project.property.displaySetting.autoHeight;
- if (autoHeight) {
- projectObj.mainSpread.getActiveSheet().autoFitRow(info.row);
- }
- },
- msClipboardChanged: function (sender, info) {
- let colSettings = projectObj.mainController.setting.cols;
- let cDatas = sheetCommonObj.getTableData(info.sheet, colSettings);
- sheetCommonObj.copyTextToClipboard(cDatas);
- return;
- },
- mainSpreadRangeChanged: function (sender, info) {
- let project = projectObj.project, setting = projectObj.mainController.setting;
- let changedObj = projectObj.checkSpreadChangedCells(info);
- let refreshNodes = [];
- for(let row of changedObj.refreshRows){
- refreshNodes.push(project.mainTree.items[row]);
- }
- let updateRationCodes = [];//更新定额编码时要用同步的方式
- if(changedObj.changedCells.length > 0){
- for (let changedCell of changedObj.changedCells) {
- let node = project.mainTree.items[changedCell.row];
- let colSetting = setting.cols[changedCell.col];
- let value = projectObj.checkSpreadEditingText(changedCell.text, colSetting)
- if(colSetting.data.field=='code'&& node.sourceType == project.Ration.getSourceType()&&node.data.type==rationType.ration){//如果是更新定额的编码
- updateRationCodes.push({'node':node,value:value});
- }else {
- projectObj.updateCellValue(node, value, colSetting,changedCell.text);
- }
- }
- }
- if(updateRationCodes.length>0){
- project.Ration.updateRationCodes(updateRationCodes);
- }
- if(refreshNodes.length > 0){
- projectObj.mainController.refreshTreeNode(refreshNodes);
- }
- },
- checkMainSpread: function () {
- if (!this.mainSpread) {
- this.mainSpread = SheetDataHelper.createNewSpread($('#billsSpread')[0]);
- this.mainSpread.getActiveSheet().selectionPolicy(GC.Spread.Sheets.SelectionPolicy.muliRange);
- this.mainSpread.getActiveSheet().name('mainSheet');
- this.mainSpread.getActiveSheet().options.isProtected = true;
- }
- },
- 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);
- $.bootstrapLoading.start();
- this.project.loadDatas(function (err) {
- let mTime = +new Date();
- console.log(`get data时间——${mTime - startTime}`);
- //快速列设置
- if(!colSettingObj.getVisible('itemCharacterText') && !colSettingObj.getVisible('jobContentText')){
- switchTznrHtml(true);
- }
- if(colSettingObj.getVisible('itemCharacterText') && colSettingObj.getVisible('jobContentText')){
- switchTznrHtml(false);
- }
- if (!err) {
- that.project.projectGLJ.calcQuantity(true);//计算分部分项和技术措施项目消耗量;
- gljCol.initGljCol(that.project.projSetting.glj_col?that.project.projSetting.glj_col.showAdjustPrice:false);
- subObj.initSubSpread();//初始化主界面下方的表格
- let quantityTime = +new Date();
- console.log(`计算quantity时间——${quantityTime - mTime}`);
- 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);
- that.project.projSetting.mainGridSetting.setAutoFitRow = MainTreeCol.getEvent("setAutoFitRow");
- that.project.projSetting.mainGridSetting.cols.forEach(function (col) {
- 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 = '@';
- }
- col.setAutoHeight = MainTreeCol.getEvent("setAutoHeight");
- col.editChecking = MainTreeCol.getEvent("editChecking");
- // 根据配置设置自动行高,在这里先做个标记,然后对每个单元格单独配置
- if (col.data.field === 'name' || col.data.field === 'itemCharacterText' ||
- col.data.field === 'jobContentText' || col.data.field === 'adjustState') {
- col.data.autoHeight = true;
- col.showHint = true;
- }
- if(col.data.field ==='quantity'){
- col.showHint = true;
- }
- // 综合单价、综合合价,小数部分应补0对齐。 CSLAAAAA
- // if (col.data.field.hasSubStr("common")){
- if (col.data.field.hasSubStr(".totalFee"))
- col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.totalPrice, true);
- else if (col.data.field.hasSubStr(".unitFee"))
- col.data.formatter = MainTreeCol.getNumberFormatter(decimalObj.ration.unitPrice, true);
- // }
- });
- let startShowTime = +new Date();
- that.mainController = TREE_SHEET_CONTROLLER.createNew(that.project.mainTree, that.mainSpread.getActiveSheet(), that.project.projSetting.mainGridSetting);
- that.mainController.showTreeData();
- let endShowTime = +new Date();
- console.log(`show data时间——${endShowTime - startShowTime}`);
- 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);
- setTimeout(function () {
- that.mainSpread.getActiveSheet().startEdit();//这两句需要挺多时间,而又需要在editend 事件前触发,而这些又不影响计算,所以这里用异步的方法
- that.mainSpread.getActiveSheet().endEdit();
- that.mainSpread.bind(GC.Spread.Sheets.Events.EditEnded, that.mainSpreadEditEnded);
- },100);
- that.mainSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, that.amountAreaNumber);
- 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.RangeChanged, that.mainSpreadRangeChanged);
- that.mainSpread.bind(GC.Spread.Sheets.Events.ClipboardChanged, that.msClipboardChanged);
- that.mainSpread.bind(GC.Spread.Sheets.Events.ButtonClicked, that.onButtonClick);
- that.mainSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, that.onCellDoubleClick);
- //let loadOtherStartTime = +new Date();
- if(!projectReadOnly){
- that.loadMainSpreadContextMenu();
- }
- that.loadFocusLocation();
- socketObject.connect();//连接socket服务器
- let endTime = +new Date();
- console.log(`其它时间——${endTime - endShowTime}`);
- console.log("加载完成-----"+endTime);
- console.log(`时间——${endTime - startTime}`);
- that.project.projectMarkChecking();//是否需要重新进行造价计算
- installationFeeObj.engineeringTypeChecking();//检查是否安装工程
- autoFlashHeight();
- projectObj.refreshMainSpread();
- //定位到会话中的选项
- let mainTabFocus = sessionStorage.getItem('mainTab') ? sessionStorage.getItem('mainTab') : '#tab_zaojiashu';
- $(`${mainTabFocus}`).click();
- if(projectReadOnly){
- disableSpread(that.mainSpread);
- }
- $.bootstrapLoading.end();
- }
- 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 projectObj.project.isBillsLocked() && project.withinBillsLocked(project.mainTree.selected);
- //return project.mainTree.selected ? project.mainTree.selected.sourceType !== project.Bills.getSourceType() : false;
- },
- callback: function (key, opt) {
- ProjectController.addRootBill(project, controller);
- },
- 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(projectObj.project.isBillsLocked()== false&&selected&&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 ||selected.children[0].data.type==billType.BX;//焦点行是分部分项工程,且子项是分项或补项
- }else {
- return false
- }
- }
- }
- return true;//除了清单,其它类型都只读
- },
- callback: function (key, opt) {
- ProjectController.addFB(project, controller);
- },
- visible: function(key, opt){
- if(project.mainTree.selected){
- return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
- }else {
- return false;
- }
- }
- },
- "insertFX": {
- name: "插入分项",
- icon: 'fa-sign-in',
- disabled: function () {
- let selected = project.mainTree.selected;
- if(projectObj.project.isBillsLocked()== false&& selected&&selected.sourceType==project.Bills.getSourceType()){
- if(selected.data.type==billType.FX||selected.data.type==billType.BX){//焦点行是分项,有效显示
- 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);
- },
- visible: function(key, opt){
- if(project.mainTree.selected){
- return project.Bills.isFBFX(project.mainTree.selected );//不属于分部分项的话隐藏
- }else {
- return false;
- }
- }
- },
- "insertBills": {
- name: "插入清单",
- icon: 'fa-sign-in',
- disabled: function () {
- let selected = project.mainTree.selected;
- if(!(projectObj.project.isBillsLocked()== true && project.withinBillsLocked(selected)) && selected && selected.sourceType === project.Bills.getSourceType()){
- return false
- }
- return true;
- },
- 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);
- },
- visible: function(key, opt){
- if(project.mainTree.selected){
- return project.Bills.isFBFX(project.mainTree.selected)==true?false:true;
- }else {
- return false;
- }
- }
- },
- "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) {
- project.Ration.addNewRation(null,rationType.ration);
- // ProjectController.addRation(project, controller, rationType.ration);
- },
- visible: function(key, opt){
- var selected = project.mainTree.selected;
- if(selected){
- return canInsertRationNode(selected);
- }
- return false;
- }
- },
- "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) {
- project.Ration.addNewRation(null,rationType.volumePrice);
- // ProjectController.addRation(project, controller, rationType.volumePrice);
- },
- visible: function(key, opt){
- var selected = project.mainTree.selected;
- if(selected){
- return canInsertRationNode(selected);
- }
- return false;
- }
- },
- "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);
- },
- visible: function(key, opt){
- var selected = project.mainTree.selected;
- if(selected){
- return canInsertRationNode(selected);
- }
- return false;
- }
- },
- "calc_installation_fee": {
- name: "计取安装费用",
- icon: 'fa-sign-in',
- disabled: function () {
- return false;
- },
- callback: function (key, opt) {
- installationFeeObj.showCalcInstallSettingDiv();
- },
- visible: function(key, opt){
- let engineering = projectInfoObj.projectInfo.property.engineering;
- return engineering==engineeringType.BUILD_IN;
- }
- },
- "spr1": '--------',
- "delete": {
- name: '删除',
- icon: 'fa-remove',
- disabled: function () {
- return !ifCanDelete();
- },
- callback: function () {
- var selected = project.mainTree.selected;
- if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
- project.Bills.deleteSelectedNode();
- }else {
- $("#delete_row").modal({show:true});//弹出删除提示框;
- }
- }
- },
- "spr2":'--------',
- "calculateAll_RationContent": {
- name: '造价计算',
- callback: function () {
- project.calcProgram.calcAllNodesAndSave();
- }
- },
- "spr2":'--------',
- "copyBlock": {
- name: '复制整块',
- icon: 'fa-copy',
- disabled: function () {
- let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
- let firstNode = projectObj.project.mainTree.items[selection.row];//当多选的情况,用mainTree.selected判断不正确,要用第一个选中的节点
- for(let i = 0;i< selection.rowCount;i++){ //多选的时候判断所有与第一个节点同级的节点
- let temNode = projectObj.project.mainTree.items[selection.row + i];
- if(firstNode.getParentID() == temNode.getParentID()){
- if(BlockController.copyBtnDisable(temNode) == true){
- return true;
- }
- }
- }
- return false;
- },
- callback: function () {
- $.bootstrapLoading.start();
- //let selected = project.mainTree.selected;
- let selections = projectObj.mainSpread.getActiveSheet().getSelections();
- setTimeout(function () {
- BlockController.copyBlock(selections[0]);
- $.bootstrapLoading.end();
- },100)
- }
- },
- "spr2":'--------',
- "pasteBlock": {
- name: '粘贴整块',
- icon: 'fa-paste',
- disabled: function (){
- return BlockController.pasteBtnDisable(project.mainTree.selected);
- },
- callback: function () {
- BlockController.pasteBlock(project.mainTree.selected);
- }
- },
- "editEngineer": {
- name: '编辑工程内容',
- icon: 'fa-edit',
- visible: function(key, opt){
- return project.Bills.isEngineerEst(project.mainTree.selected);//当焦点行是“专业工程暂估价”时,右键可见并有效。
- },
- callback: function () {
- let node = project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.ENGINEERING_ESITIMATE);
- if(node){
- projectObj.editContent(node,'engineeringContent');
- }
- }
- },
- "editService": {
- name: '编辑服务内容',
- icon: 'fa-edit',
- visible: function(key, opt){
- return project.Bills.isTotalService(project.mainTree.selected);//当焦点行是“总承包服务费”时,右键可见并有效。
- },
- callback: function () {
- let node = project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.TURN_KEY_CONTRACT);
- if(node){
- projectObj.editContent(node,'serviceContent');
- }
- }
- },
- "editAccording": {
- name: '编辑签证及索赔依据',
- icon: 'fa-edit',
- visible: function(key, opt){
- return project.Bills.isClaimVisa(project.mainTree.selected);//当焦点行是“签证及索赔计价”时,右键可见并有效。
- },
- callback: function () {
- let node = project.Bills.getNodeByFlag(project.mainTree.selected,fixedFlag.CLAIM_VISA);
- if(node){
- projectObj.editContent(node,'claimVisa');
- }
- }
- }
- }
- });
- },
- // 计算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 = 0;
- col = 0;
- }
- 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 maxCell = {row: selectedArea.row, col: selectedArea.col + selectedArea.colCount};
- let maxCellX = sheet.getCellRect(maxCell.row, maxCell.col).x ? sheet.getCellRect(maxCell.row, maxCell.col).x : sheet.getCellRect(maxCell.row, maxCell.col - 1).x;
- let minCell = {row: selectedArea.row, col: selectedArea.col};
- let minCellX = sheet.getCellRect(minCell.row, minCell.col).x ? sheet.getCellRect(minCell.row, minCell.col).x : sheet.getCellRect(minCell.row, minCell.col + 1).x;
- // 获取鼠标位置
- 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;
- x = maxCellX + baseWidth + inputWidth > canvasWidth ? minCellX - baseWidth - inputWidth : maxCellX + baseWidth;
- y = y + baseHeight > canvasHeight ? y - baseHeight : y;
- //test
- let testT = sheet.getParent().hitTest(x, y);
- //test
- div.css({
- left: x,
- top: y,
- });
- div.children().children("#total").width(inputWidth).val(totalString);
- $("body").append(div);
- // 用于判断是否要关闭窗体
- setTimeout(function() {
- isTotalShowing = true;
- }, 200);
- };
- },
- /*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;
- //test
- let testT = sheet.getParent().hitTest(x, y);
- console.log(sheet.getCellRect(0, 0));
- //test
- div.css({
- left: x,
- top: y,
- });
- div.children().children("#total").width(inputWidth).val(totalString);
- $("body").append(div);
- // 用于判断是否要关闭窗体
- setTimeout(function() {
- isTotalShowing = true;
- }, 200);
- };
- },*/
- onButtonClick: function (e, info) {
- let colSetting = projectObj.mainController.setting.cols[info.col];
- let node = projectObj.project.mainTree.items[info.row];
- let fieldName = colSetting.data.field;
- if(fieldName == "isSubcontract"){
- projectObj.onSubcontractClick(node);
- }else if(fieldName == "isEstimate"){
- projectObj.onIsEstimateClick(node,info);
- }
- },
- onIsEstimateClick: function(node,info){
- let checkboxValue = info.sheet.getCell(info.row, info.col).value();
- let cell = info.sheet.getCell(info.row, info.col), newval = 0;
- if (checkboxValue) {
- newval = 0;
- cell.value(newval);
- } else {
- newval = 1;
- cell.value(newval);
- }
- if(MainTreeCol.readOnly.bills(node)){
- projectObj.updateNodeField(node,newval,'isEstimate');
- }else if(node.data.projectGLJID){//更新的是定额类型的工料机或者是显示在造价书页面的主材、设备
- console.log(node);
- let updateData = {id: node.data.projectGLJID, field: 'is_evaluate', value: newval};
- projectObj.project.projectGLJ.pGljUpdate(updateData);
- }
- },
- onSubcontractClick:function (node) {//点击分包费checkbox
- if (node.data.isSubcontract) node.data.isSubcontract = false;
- else node.data.isSubcontract = true;
- node.changed = true;
- projectObj.project.calcProgram.calcAndSave(node);
- },
- //根据节点获取行style(颜色、字体加粗)
- getNodeColorStyle: function (sheet, node, tree) {
- let colorSetting = optionsOprObj.getOption(optionsOprObj.optionsTypes.COLOROPTS);
- let mapping = {DEFAULT: 'DEFAULT', SELECTED: 'SELECTED', DXFY: 'DXFY', FB: 'FB', UNLEAFBILL: 'UNLEAFBILL',
- FX: 'FX', BX: 'BX', UNCBBILL: 'UNCBBILL', CBBILL: 'CBBILL', ZCSB: 'ZCSB'};
- let styleMap = null;
- tree?'':tree = this.project.mainTree;
- //中文字段名,由于同一节点中,中文字体大小和数字字体大小不同
- if(colorSetting == null){
- return null;
- }
- let stringFields = [
- 'code',
- 'subType',
- 'name',
- 'unit',
- 'itemCharacterText',
- 'jobContentText',
- 'adjustState',
- 'calcBase',
- 'programID',
- 'ruleText'
- ];
- if(!isDef(node)){
- return null;
- }
- //清单大类
- if(node.sourceType === this.project.Bills.getSourceType()){
- //大项费用
- if(node.data.type === billType.DXFY){
- styleMap = mapping.DXFY;
- }
- //分部
- if(node.data.type === billType.FB){
- styleMap = mapping.FB;
- }
- //分项
- else if(node.data.type === billType.FX){
- styleMap = mapping.FX;
- }
- //补项
- else if(node.data.type === billType.BX){
- styleMap = mapping.BX;
- }
- //清单
- else if(node.data.type === billType.BILL){
- //非叶子节点的清单
- if(node.source.children.length > 0){
- styleMap = mapping.UNLEAFBILL;
- }
- //未使用基数计算的叶子节点的清单
- else if(node.source.children.length === 0 && (!isDef(node.data.calcBase) || node.data.calcBase === '')){
- styleMap = mapping.UNCBBILL;
- }
- //使用基数计算的叶子节点的清单
- else if(node.source.children.length === 0 && isDef(node.data.calcBase && node.data.calcBaseValue !== '')){
- styleMap = mapping.CBBILL;
- }
- }
- }
- //定额下的主材、设备
- else if(node.sourceType === this.project.ration_glj.getSourceType()){
- styleMap = mapping.ZCSB;
- }
- else {
- styleMap = mapping.DEFAULT;
- }
- let styleSetting = colorSetting[styleMap];
- let defaultSetting = colorSetting[mapping.DEFAULT];
- if(!isDef(styleSetting)){
- return null;
- }
- let style = new GC.Spread.Sheets.Style();
- //设置style属性
- for(let attr in styleSetting){
- if(attr !== 'stringFont' && attr !== 'numFont'){
- style[attr] = styleSetting[attr] === 'default' || !isDef(styleSetting[attr]) ? defaultSetting[attr] : styleSetting[attr];
- }
- //暂时不开放字体设置,开放的话只能每个单元格进入此方法
- /* else {
- if(stringFields.indexOf(colSetting.data.field) > 0){
- style.font = styleSetting.stringFont === 'default' || !isDef(styleSetting.stringFont) ? defaultSetting.stringFont : styleSetting.stringFont;
- }
- else {
- style.font = styleSetting.numFont === 'default' || !isDef(styleSetting.numFont) ? defaultSetting.numFont : styleSetting.numFont;
- }
- }*/
- }
- //选中行-替换底色
- if(node === tree.selected){
- style.backColor = colorSetting[mapping.SELECTED]['backColor'];
- }
- style.borderLeft = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
- style.borderTop = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
- style.borderRight = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
- style.borderBottom = new GC.Spread.Sheets.LineBorder("#D4D4D4", GC.Spread.Sheets.LineStyle.thin);
- return style;
- },
- //大项费用则字体加粗,String 15px, Number 13px
- getBoldFontStyle: function (node, colSetting) {
- let style = new GC.Spread.Sheets.Style();
- if(node.sourceType !== this.project.Bills.getSourceType() || node.data.type !== billType.DXFY){
- return null
- }
- //备注暂无字段
- let stringFields = [
- 'code',
- 'subType',
- 'name',
- 'unit',
- 'itemCharacterText',
- 'jobContentText',
- 'adjustState',
- 'calcBase',
- 'programID',
- 'ruleText'
- ];
- if(stringFields.indexOf(colSetting.data.field) > 0){
- style.font = 'bold 15px Arial';
- }
- else {
- style.font = 'bold 13px Arial';
- }
- return style;
- },
- //设置节点style
- setNodesStyle: function (sheet, nodes,tree) {
- let me = this;
- TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
- for(let node of nodes){
- if(node && node.serialNo()!= -1){
- sheet.getRange(node.serialNo(), -1, 1, -1).backColor(me.getNodeColorStyle(sheet, node,tree).backColor);
- }
- }
- });
- },
- loadLockBillsButton:function () {
- if(projectInfoObj.projectInfo.property.lockBills == true){
- $("a[name='lockBills']").prop("title","解锁清单");
- $("a[name='lockBills']").html('<i class="fa fa-unlock-alt" aria-hidden="true"></i> 解锁清单');
- }else {
- $("a[name='lockBills']").prop("title","锁定清单");
- $("a[name='lockBills']").html('<i class="fa fa-lock" aria-hidden="true"></i> 锁定清单');
- }
- },
- editContent:function (node,fieldID) {//右键编辑工程内容、服务内容、签证及索赔依据
- let infoText = "请输入";
- switch (fieldID){
- case "engineeringContent":
- infoText +='工程内容:';
- break;
- case "serviceContent":
- infoText +='服务内容:';
- break;
- case "claimVisa":
- infoText +='签证及索赔依据:';
- break;
- }
- hintBox.valueBox(infoText, node.data[fieldID], function () {
- let newValue = hintBox.value;
- projectObj.updateNodeField(node,newValue,fieldID);
- });
- }
- };
- // 点击合计框中的复制
- $("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);
- };
- });
- $('#delete').click(function () {
- let project = projectObj.project;
- let selected = project.mainTree.selected;
- if(isSingleSelect()&&selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length<=0){//选中的是分部,并且没有子项,直接删除
- project.Bills.deleteSelectedNode();
- }else {
- $("#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();
- controller.refreshTreeNode([orgParent]);
- projectObj.project.calcProgram.calcNodesAndSave([selected,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();
- controller.refreshTreeNode([selected.parent]);
- 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();
- };
- }
- });
- $("a[name='lockBills']").click(function () {//
- let lockBills = projectInfoObj.projectInfo.property.lockBills;
- lockBills = !lockBills;
- projectObj.project.updateLockBills(lockBills,function () {
- var controller = projectObj.mainController, project = projectObj.project;
- var selected = controller.tree.selected;
- let nodes = _.filter(project.mainTree.items,{'sourceType':ModuleNames.bills});
- controller.refreshTreeNode(nodes);
- projectObj.mainController.setTreeSelected(selected);//触发树节点选中事件
- projectObj.loadLockBillsButton();
- if(!projectReadOnly){
- pageCCOprObj.refreshRuleTools(lockBills);
- }
- });
- });
- $('#ZLFB_btn').click(function () {
- zlfb_object.getSectionInfo();
- });
- //工料机库
- $('#compleGljLib').click(function () {
- let newTab = window.open('about:blank');
- let newHref = '/complementaryGlj';
- CommonAjax.get(newHref, [], function () {
- newTab.location.href = newHref;
- });
- });
- //显示至..
- let displayLevel = function(nodes, depth, type){
- let refreshNodes = [];
- function getExpandedController(){
- if(type === 'DXFY' || type === 'FB'){
- if(type === 'FB'){
- projectObj.project.mainTree.items[0].setExpanded(true);
- refreshNodes.push(projectObj.project.mainTree.items[0]);
- }
- return function expandedControl(nodes, depth){
- let bType = type === 'FB' ? billType.FB : billType.DXFY;
- for(let node of nodes){
- let nodeDepth = node.depth();
- if(nodeDepth <= depth){
- let expanded = nodeDepth === depth && !node.children[0] || nodeDepth < depth && node.children[0] && node.children[0].data.type === bType ? true : false;
- node.setExpanded(expanded);
- refreshNodes.push(node);
- if(nodeDepth < depth){
- expandedControl(node.children, depth);
- }
- }
- }
- }
- }
- else if(type === 'FX' || type === 'ZM' || type === 'ZD'){
- return function expandedControl(nodes){
- for(let node of nodes){
- if(type !== 'FX' || node.sourceType === projectObj.project.Bills.getSourceType()){
- let expanded = true;
- if(type === 'FX'){
- expanded = !node.children[0] || node.children[0] && node.children[0].sourceType === projectObj.project.Bills.getSourceType() ? true : false;
- }
- else if(type === 'ZM'){
- expanded = !node.children[0] || node.children[0] && node.children[0].sourceType !== projectObj.project.ration_glj.getSourceType() ? true : false;
- }
- node.setExpanded(expanded);
- refreshNodes.push(node);
- expandedControl(node.children);
- }
- }
- }
- }
- }
- getExpandedController()(nodes, depth);
- let sheet = projectObj.mainSpread.getActiveSheet();
- TREE_SHEET_HELPER.massOperationSheet(sheet, function () {
- TREE_SHEET_HELPER.refreshNodesVisible(refreshNodes, projectObj.mainSpread.getActiveSheet(), true)
- });
- };
- $('#displayDXFY').click(function () {
- displayLevel(projectObj.project.mainTree.items, 0, 'DXFY')
- });
- //显示至一级分部
- $('#displayFB1').click(function () {
- displayLevel(projectObj.project.mainTree.items[0].children, 1, 'FB');
- });
- //二级分部
- $('#displayFB2').click(function () {
- displayLevel(projectObj.project.mainTree.items[0].children, 2, 'FB');
- });
- //三级分部
- $('#displayFB3').click(function () {
- displayLevel(projectObj.project.mainTree.items[0].children, 3, 'FB');
- });
- //四级分部
- $('#displayFB4').click(function () {
- displayLevel(projectObj.project.mainTree.items[0].children, 4, 'FB');
- });
- //分项
- $('#displayFX').click(function () {
- displayLevel(projectObj.project.mainTree.items, null, 'FX');
- });
- //子目
- $('#displayZM').click(function () {
- displayLevel(projectObj.project.mainTree.items, null, 'ZM');
- });
- //最底层
- $('#displayZD').click(function () {
- displayLevel(projectObj.project.mainTree.roots, null, 'ZD');
- });
- $('#poj-set').on('show.bs.modal', function () {
- let setCalcFlag = function (obj, val, curFlag) {
- obj.val(val);
- if (val === curFlag) {
- obj.prop('checked', true);
- } else {
- obj.prop('checked', false);
- }
- }
- if (projectObj.project) {
- let ft = projectObj.project.property.billsCalcMode ? projectObj.project.property.billsCalcMode : leafBillGetFeeType.rationContent;
- let zg = projectObj.project.property.zanguCalcMode ? projectObj.project.property.zanguCalcMode : zanguCalcType.common;
- setCalcFlag($('#rationContent'), leafBillGetFeeType.rationContent, ft);
- setCalcFlag($('#rationPriceConverse'), leafBillGetFeeType.rationPriceConverse, ft);
- setCalcFlag($('#rationPrice'), leafBillGetFeeType.rationPrice, ft);
- setCalcFlag($('#billsPrice'), leafBillGetFeeType.billsPrice, ft);
- setCalcFlag($('#zangu_common'), zanguCalcType.common, zg);
- setCalcFlag($('#zangu_gatherMaterial'), zanguCalcType.gatherMaterial, zg);
- let showAdjustPrice = projectObj.project.projSetting.glj_col?projectObj.project.projSetting.glj_col.showAdjustPrice:false;
- showAdjustPrice === true ? $("#tab_poj-settings-6").show():$("#tab_poj-settings-6").hide();
- projDisplayView.init();
- calcOptions.init();
- }
- });
- $('#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;
- reCalcRations = 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(colSettingObj.dataChanged()){
- colSettingObj.updateColSetting();
- }
- 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 = calcTools.cutNodeForSave(node);
- 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;
- }
- function needToReload(mixDatas){
- if(Object.keys(mixDatas.labourCoes).length > 0){
- return true;
- }
- if(Object.keys(mixDatas.properties).length > 0){
- if(mixDatas.properties.hasOwnProperty('property.billsCalcMode') ||
- mixDatas.properties.hasOwnProperty('property.zanguCalcMode') ||
- mixDatas.properties.hasOwnProperty('property.calcOptions')||
- mixDatas.properties.hasOwnProperty('property.billsQuantityDecimal')||
- mixDatas.properties.hasOwnProperty('property.decimal')||
- mixDatas.properties.hasOwnProperty('property.displaySetting')){
- return true;
- }
- }
- return false;
- }
- if(hasMixData()){
- CommonAjax.post('/pm/api/updateMixDatas', {user_id: userID, mixDataArr: mixDatas}, function (rstData) {
- //需要重载页面
- if(needToReload(mixDatas)){
- window.location.href = '/main?project=' + projectID;
- }
- else{
- if(mixDatas.properties.hasOwnProperty('property.basicInformation')){
- basicInfoView.orgDatas = basicInfoView.toViewDatas(mixDatas.properties['property.basicInformation']);
- }
- if(mixDatas.properties.hasOwnProperty('property.projectFeature')){
- projFeatureView.orgDatas = projFeatureView.toViewDatas(mixDatas.properties['property.projectFeature']);
- }
- }
- });
- }
- });
- function testShow() {
- var controller = projectObj.mainController, project = projectObj.project;
- var selected = controller.tree.selected, parent = selected.parent;
- var showinfo = "<label>确认要删除当前选中行吗?</label>";
- var showN = false;
- var cancelText = "否";
- if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
- if(isSingleSelect()||selectionChecking()){
- showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
- showN = true;
- cancelText = "取消";
- }
- }
- $('#delete_showinfo').html(showinfo);
- showN==true? $('#deleteN').show():$('#deleteN').hide();
- $('#deleteCancel').text(cancelText);
- function selectionChecking() {
- let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
- let mainTreeMap = {};
- for(let i =0;i<selection.rowCount;i++){
- let tem_node = controller.tree.items[selection.row+i];
- if(i==0){//第一个直接添加;
- mainTreeMap[tem_node.getID()] = tem_node;
- }else {
- project.Bills.setNodeToMap(tem_node,mainTreeMap);
- }
- }
- let nodes = changeMapToArray(mainTreeMap);
- if(nodes.length==1){
- return true
- }
- return false;
- }
- }
- $('#delete_row').on('show.bs.modal', function (e) {//这里用show,在shown之前调用,页面不会出现按钮闪现的情况
- var controller = projectObj.mainController, project = projectObj.project;
- var selected = controller.tree.selected, parent = selected.parent;
- var showinfo = "<label>确认要删除当前选中行吗?</label>";
- var showN = false;
- var cancelText = "否";
- if(selected.sourceType == project.Bills.getSourceType()&&selected.data.type==billType.FB&&selected.children.length>0){//选中的是分部,并且有子项
- if(isSingleSelect()||selectionChecking()){
- showinfo = "<label>是否删除其下的子项?</label><br><label>【是】则删除分部行及其下的所有子项,</label><br><label>【否】则仅删除当前分部行,子项保留,</label><br><label>【取消】则取消删除</label>";
- showN = true;
- cancelText = "取消";
- }
- }
- $('#delete_showinfo').html(showinfo);
- showN==true? $('#deleteN').show():$('#deleteN').hide();
- $('#deleteCancel').text(cancelText);
- function selectionChecking() {
- let selection = projectObj.mainSpread.getActiveSheet().getSelections()[0];
- let mainTreeMap = {}, nodes = [];
- for(let i =0;i<selection.rowCount;i++){
- let tem_node = controller.tree.items[selection.row+i];
- if(i==0){//第一个直接添加;
- mainTreeMap[tem_node.getID()] = tem_node;
- }else {
- project.Bills.setNodeToMapAndArray(tem_node,mainTreeMap,nodes);
- }
- }
- if(nodes.length==1){
- return true
- }
- return false;
- }
- });
- function changeMapToArray(map) {
- let newArray = [];
- for(let key in map){
- newArray.push(map[key]);
- }
- return newArray;
- }
- $('#deleteY').click(function () { //正常删除,级联删除子项
- let project = projectObj.project;
- project.Bills.deleteSelectedNodes();
- /*if(isSingleSelect()){
- project.Bills.deleteSelectedNode();//这个方法不用了,会出现异步删除干净的问题
- }else {
- project.Bills.deleteSelectedNodes();
- }*/
- });
- $('#deleteN').click(function () {//不删除子项
- let controller = projectObj.mainController, project = projectObj.project;
- let selected = controller.tree.selected, parent = selected.parent;
- 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);
- }
- });
- function isSingleSelect() {//是否选中造价书中的单行
- let selections = projectObj.mainSpread.getActiveSheet().getSelections();
- if (selections[0].rowCount == 1) {
- return true;
- }
- return false;
- }
- function ifCanDelete() {
- let selections = projectObj.mainSpread.getActiveSheet().getSelections();
- let tree = projectObj.project.mainTree;
- let selected = projectObj.project.mainTree.selected;
- if(selections[0].rowCount==1){//选中单行
- return canDelete(selected);
- }else {
- return canDelete_m(selections[0]);
- }
- function canDelete(node,m_selection) {
- if (node) {
- if (node.sourceType === projectObj.project.Bills.getSourceType()) {
- if(node.data.type == billType.DXFY&&node.data.isAdd!=1){
- return false;
- }
- if(projectObj.project.isBillsLocked()== true && projectObj.project.withinBillsLocked(node)){
- return false;
- }
- if(projectObj.project.Bills.hasFlags(node)){
- return false;
- }
- }
- if(m_selection!=true&&node.sourceType === projectObj.project.ration_glj.getSourceType()){//多选的时候不做这一项判断
- return false;
- }
- return true;
- } else {
- return false;
- }
- };
- function canDelete_m(selection) {
- for(let i =0;i<selection.rowCount;i++){
- if(tree.items[selection.row+i]==undefined||tree.items[selection.row+i]==null){
- return false;
- }
- if(i==0&&tree.items[selection.row].sourceType === projectObj.project.ration_glj.getSourceType()){
- return false
- }
- if(canDelete(tree.items[selection.row+i],true)==false){
- return false
- }
- }
- return true
- };
- }
- function canInsertRationNode(selected) {//判断是否能插入定额、量价、定额类型工料机, false 不能,true能
- let project = projectObj.project;
- if(selected.sourceType == ModuleNames.bills&&selected.data.type == billType.DXFY){
- return false
- }else if(!(project.Bills.isMeasure(selected)||project.Bills.isFBFX(selected))){
- return false
- }else {
- return true
- }
- }
- //导入类型(09表、广联达)
- const uploadType = {lj: 'lj', gld: 'gld'};
- let fileType = uploadType.lj;
- $('#uploadLj').click(function () {
- fileType = uploadType.lj;
- });
- $('#uploadGld').click(function () {
- fileType = uploadType.gld;
- });
- //设置导入表内容
- function setUploadSheets(sheetNames){
- let sheetArea = $('#uploadSheets');
- $('#uploadSheets').height('');
- sheetArea.empty();
- for(let sheetName of sheetNames){
- let sheetDiv = $(`<div style="margin-left: 5px;margin-top: 5px;" class="input-group form-check"><label class="form-check-label" style="width:270px; overflow: hidden; white-space: nowrap; text-overflow: ellipsis">
- <input class="form-check-input" type="checkbox">${sheetName}</label></div>`);
- sheetDiv.find('input[type="checkbox"]').click(function () {
- if($('#uploadAlert').is(':visible')){
- $('#uploadAlert').hide();
- }
- });
- let sel = $(`<select style="margin-left: 5px; border-radius: .20rem;"><option value="fbfx">分部分项工程</option><option value="zzcsxm">施工组织措施项目</option><option value="jscsxm">施工技术措施项目</option></select>`);
- if(sheetName.includes('分部分项工程项目清单计价表')){
- sheetDiv.find('input[type="checkbox"]').prop('checked', true);
- sel.find('option:eq(0)').prop('selected', true);
- }
- else if(sheetName.includes('施工组织措施项目清单计价表')){
- sheetDiv.find('input[type="checkbox"]').prop('checked', true);
- sel.find('option:eq(1)').prop('selected', true);
- }
- else if(sheetName.includes('施工技术措施项目清单计价表')){
- sheetDiv.find('input[type="checkbox"]').prop('checked', true);
- sel.find('option:eq(2)').prop('selected', true);
- }
- sheetDiv.append(sel);
- sheetArea.append(sheetDiv);
- }
- if(sheetNames.length > 0){
- sheetArea.show();
- }
- if($('#uploadSheets').height() > 250){
- console.log('aa');
- sheetArea.css('overflow', 'auto');
- sheetArea.height(250);
- }
- else {
- sheetArea.css('overflow', 'hidden');
- }
- }
- //获得选择导入的表信息(表索引及导入位置)
- function getUploadSheets(){
- let rst = [];
- let sheetArea = $('#uploadSheets');
- let checkedInputs = sheetArea.find('input:checked');
- for(let checked of checkedInputs){
- rst.push({sheetIdx: $(checked).parent().parent().index(), position: $(checked).parent().next().select().val()})
- }
- return rst;
- }
- //选择要导入的excel文件
- $('#customFile').change(function () {
- let file = $(this)[0];
- if(file.files.length > 0){
- $('.custom-file-label').text(`${file.files[0].name} 准备导入上传`);
- $('#uploadAlert').hide();
- console.log(file.files);
- //读取各个表及表名
- $.bootstrapLoading.start();
- let fileReader = new FileReader();
- fileReader.onload = function(ev) {
- console.log('enter');
- try {
- let data = ev.target.result;
- console.log(data);
- // 以二进制流方式读取得到整份excel表格对象
- let workbook = XLSX.read(data, {type: 'binary'});
- // 遍历每张表读取
- let sheetNames = [];
- for (let sheetName in workbook.Sheets) {
- sheetNames.push(sheetName);
- }
- setUploadSheets(sheetNames);
- $.bootstrapLoading.end();
- } catch (e) {
- console.log(e);
- $.bootstrapLoading.end();
- alert('文件类型不正确');
- return;
- }
- };
- // 以二进制方式打开文件
- fileReader.readAsBinaryString(file.files[0]);
- }
- else{
- $('.custom-file-label').text(`请选择上传文件`);
- }
- });
- //从excel导入清单
- $('#uploadConfirm').click(function () {
- let me = this;
- $(me).addClass('disabled');
- try{
- let formData = new FormData();
- let file = $('#customFile')[0];
- if(file.files.length <= 0){
- throw '未选择文件';
- }
- formData.append('file', file.files[0]);
- let projectID = scUrlUtil.GetQueryString('project');
- if(!projectID || projectID <= 0){
- throw '项目数据出错';
- }
- //导入表类型(09lj、广联达gld)
- formData.append('fileType', fileType);
- //选择的表及导入位置
- let uploadWorkBook = getUploadSheets();
- if(uploadWorkBook.length === 0){
- throw '请选择要导入的表';
- }
- formData.append('uploadWorkBook', JSON.stringify(uploadWorkBook));
- formData.append('projectID', projectID);
- //要去匹配的清单库(第一个)
- let matchBillLibId = projectInfoObj.projectInfo.engineeringInfo.bill_lib.length > 0 ? projectInfoObj.projectInfo.engineeringInfo.bill_lib[0].id : null;
- formData.append('billsLibId', matchBillLibId);
- $.ajax({
- url: '/bills/upload',
- type: 'POST',
- data: formData,
- cache: false,
- contentType: false,
- processData: false,
- beforeSend: function() {
- $.bootstrapLoading.start();
- },
- success: function(response){
- if (response.err === 0) {
- const message = response.msg !== undefined ? response.msg : '';
- if (message !== '') {
- alert(message);
- }
- // 成功则关闭窗体
- $('#import').modal("hide");
- //更新前端
- doAfterImport(response.data);
- if($.bootstrapLoading.isLoading()){
- $.bootstrapLoading.end();
- }
- } else {
- const message = response.msg !== undefined ? response.msg : '上传失败!';
- $.bootstrapLoading.end();
- alert(message);
- }
- $(me).removeClass('disabled');
- },
- error: function(){
- alert("与服务器通信发生错误");
- $.bootstrapLoading.end();
- $(me).removeClass('disabled');
- }
- });
- }
- catch (err){
- //alert(err);
- showUploadAlert(false, err);
- $(me).removeClass('disabled');
- }
- });
- function showUploadAlert(success, msg){
- if(!success){
- $('#uploadAlert').removeClass('alert-success');
- $('#uploadAlert').addClass('alert-danger');
- }
- else{
- $('#uploadAlert').removeClass('alert-danger');
- $('#uploadAlert').addClass('alert-success');
- }
- $('#uploadAlert').text(msg);
- $('#uploadAlert').show();
- }
- //导入清单到一个固定行位置后,更新数据
- function doAfterImportPosition(positionData){
- let nodes = projectObj.project.mainTree.nodes;
- let bills_datas = projectObj.project.Bills.datas;
- let ration_datas = projectObj.project.Ration.datas;
- let quantity_detail_datas = projectObj.project.quantity_detail.datas;
- let ration_glj_datas = projectObj.project.ration_glj.datas;
- let ration_coe_datas = projectObj.project.ration_coe.datas;
- let ration_install_datas = projectObj.project.ration_installation.datas;
- let delNodes = [];
- for(let billID of positionData.remove.bill){
- if(nodes['id_' + billID]){
- delNodes.push(nodes['id_' + billID]);
- }
- //清除清单数据
- _.remove(bills_datas, {ID: billID});
- //清除清单工程量明细数据
- _.remove(quantity_detail_datas, {billID: billID});
- }
- for(let rationID of positionData.remove.ration){
- //清除定额数据
- _.remove(ration_datas, {ID: rationID});
- //清除定额下的相关数据
- _.remove(ration_glj_datas, {rationID: rationID});
- _.remove(ration_coe_datas, {rationID: rationID});
- _.remove(ration_install_datas, {rationID: rationID});
- _.remove(quantity_detail_datas, {rationID: rationID});
- }
- //删除节点
- if(delNodes.length > 0){
- //通过固定清单获得删除节点的起始行索引
- let beginRow = null;
- if(positionData.fixedBill){
- let fixedNode = nodes['id_' + positionData.fixedBill.ID];
- if(fixedNode){
- beginRow = projectObj.project.mainTree.items.indexOf(fixedNode) + 1;
- }
- }
- //删除主树节点
- projectObj.mainController.m_delete(delNodes, beginRow);
- //删除清单树节点
- let delIdNodes = [];
- for(let delNode of delNodes){
- delIdNodes.push(delNode.source);
- }
- projectObj.project.Bills.tree.m_delete(delIdNodes);
- }
- if(positionData.insert.bill.length > 0){
- //设置flagsIndex
- for(let insertBill of positionData.insert.bill){
- insertBill.flagsIndex = {};
- if (insertBill.flags) {
- insertBill.flags.forEach(function (flag) {
- insertBill.flagsIndex[flag.fieldName] = flag;
- });
- }
- }
- //插入清单节点
- projectObj.project.Bills.tree.insertByDatas(positionData.insert.bill);
- //插入主树节点
- let newNodes = projectObj.project.mainTree.insertByDatas(positionData.insert.bill);
- for(let node of newNodes){
- node.source = projectObj.project.Bills.tree.nodes['id_' + node.getID()];
- node.data = node.source.data;
- node.sourceType = projectObj.project.Bills.getSourceType();
- }
- ProjectController.syncDisplayNewNodes(projectObj.mainController, newNodes);
- }
- }
- //导入后更新操作
- function doAfterImport(resData){
- if(resData && resData.length > 0){
- for(let positionData of resData){
- doAfterImportPosition(positionData);
- }
- //如果清单未锁定,导入后锁定清单
- if(!projectInfoObj.projectInfo.property.lockBills){
- $("a[name='lockBills']").click();
- }
- $.bootstrapLoading.end();
- //重算
- projectObj.project.calcProgram.calcAllNodesAndSave(calcAllType.catAll, function () {
- projectObj.project.projectGLJ.loadData(function () {
- $.bootstrapLoading.end();
- });
- });
- }
- }
- //下载导入清单示例文件
- $('#uploadExample').click(function () {
- window.location.href = '/bills/downloadExamp'
- });
- $(function () {
- //清空导入清单选择文件
- $('#import').on('show.bs.modal', function(){
- $('#customFile').val('');
- $('#uploadAlert').hide();
- $('.custom-file-label').text(`请选择上传文件`);
- });
- $('#import').on('hidden.bs.modal', function () {
- //恢复选择表高度
- $('#uploadSheets').height('');
- $('#uploadSheets').hide();
- });
- $("#billsSpread").mouseover(function(){
- spreadAutoFocus(projectObj.mainSpread,subSpread);
- });
- $("#subSpread").mouseover(function(){
- spreadAutoFocus(subSpread,projectObj.mainSpread);
- });
- $("#paste_confirm").click(function (){
- let selected = projectObj.project.mainTree.selected;
- let blockData = BlockController.getBlockData();
- let position = $("input[name='pastePositionRadio']:checked").val();
- BlockController.confirmPaste(blockData,selected,position);
- $("#pastePosition").modal("hide");
- });
- function spreadAutoFocus(spread,relateSpread) {
- if(relateSpread&&relateSpread.getActiveSheet().isEditing()){//关联的spread不在编辑状态的情况下,才自动获得焦点;
- return;
- }else {
- spread?spread.focus():'';
- }
- }
- //项目为只读
- if(projectReadOnly){
- disableTools();
- }
- });
- //项目只读,处理不可操作的工具栏
- function disableTools(){
- //造价书按钮
- $('#delete').remove();
- $('#upLevel').remove();
- $('#downLevel').remove();
- $('#upMove').remove();
- $('#downMove').remove();
- $('#ZLFB_btn').remove();
- $('#switchTznr').remove();
- $('a[name="lockBills"]').remove();
- //关于计算
- $('#poj-settings-4').find('input').prop('disabled', 'disabled');
- //小数位数
- $('#poj-settings-decimal').find('input').prop('disabled', 'disabled');
- //人工单价调整
- $('#std_labour_coe_files').prop('disabled', 'disabled');
- //呈现选项
- $('#display-setting').find('input').prop('disabled', 'disabled');
- //项目属性确定
- $('#property_ok').addClass('disabled');
- //特征及内容
- $('#add-rule').find('select').prop('disabled', 'disabled');
- $('#use-to-current').addClass('disabled');
- $('#use-to-all').addClass('disabled');
- $('.bottom-tools').remove();
- //导入
- $('#uploadConfirm').addClass('disabled');
- //选项
- $('#generalOpts1').prop('disabled', 'disabled');
- $('#generalOpts2').prop('disabled', 'disabled');
- //补充库编辑器
- $('#compleRationLib').addClass('disabled');
- $('#compleGljLib').addClass('disabled')
- //库
- $('#stdBillsGuidanceTab').addClass('disabled');
- $('#stdBillsTab').addClass('disabled');
- $('#stdRationTab').addClass('disabled');
- //人材机汇总,选择其他、另存使用
- $('a[data-target="#change-unitFile"]').remove();
- $('a[data-target="#unitFile-save-as"]').remove();
- //费率,选择其他、另存使用、重选标准、统一设置相同参数
- $('a[data-target="#change-lv"]').remove();
- $('a[data-target="#copy-lv"]').remove();
- $('#standardSelect').prop('disabled', 'disabled');
- $('#cascadeSet').prop('disabled', 'disabled');
- //计算程序标准
- $('#calcProgramFileSelect').prop('disabled', 'disabled');
- //调价
- $('#calcPriceOption').prop('disabled', 'disabled');
- $('#gljPriceTenderCoe').prop('disabled', 'disabled');
- $('#tenderGLJQuantity').prop('disabled', 'disabled');
- $('#tenderRationQuantity').prop('disabled', 'disabled');
- $('#tenderPrice').prop('disabled', 'disabled');
- $('#cleanTender').prop('disabled', 'disabled');
- }
- //项目只读,表格只读
- function disableSpread(spread){
- spread.unbind(GC.Spread.Sheets.Events.ButtonClicked);
- let sheetCount = spread.getSheetCount();
- console.log(sheetCount);
- for(let i = 0; i < sheetCount; i++){
- let sheet = spread.getSheet(i);
- sheet.unbind(GC.Spread.Sheets.Events.ButtonClicked);
- sheet.unbind(GC.Spread.Sheets.Events.EditStarting);
- sheet.unbind(GC.Spread.Sheets.Events.EditEnded);
- sheet.unbind(GC.Spread.Sheets.Events.RangeChanged);
- sheet.unbind(GC.Spread.Sheets.Events.ClipboardChanging);
- sheet.unbind(GC.Spread.Sheets.Events.ClipboardChanged);
- sheet.unbind(GC.Spread.Sheets.Events.CellDoubleClick);
- sheet.unbind(GC.Spread.Sheets.Events.CellClick);
- sheet.unbind(GC.Spread.Sheets.Events.ValueChanged);
- console.log(sheet.name());
- sheet.suspendPaint();
- sheet.suspendEvent();
- sheet.options.isProtected = true;
- let rowCount = sheet.getRowCount();
- let colCount = sheet.getColumnCount();
- for(let row = 0; row < rowCount; row++){
- for(let col = 0; col < colCount; col++){
- sheet.getCell(row, col).locked(true);
- }
- }
- sheet.resumePaint();
- sheet.resumeEvent();
- }
- }
|