123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643 |
- 'use strict';
- /**
- * 台账修订页面js
- *
- * @author Mai
- * @date
- * @version
- */
- const ckBillsSpread = window.location.pathname + '-billsSelect';
- const invalidFields = {
- parent: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp', 'deal_qty', 'deal_tp', 'unit_price'],
- gcl: ['dgn_qty1', 'dgn_qty2'],
- posCode: ['b_code'],
- posCalc: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp'],
- posXmj: ['code'],
- };
- function getExprInfo (field) {
- const exprField = [
- {qty: 'sgfh_qty', expr: 'sgfh_expr'},
- {qty: 'sjcl_qty', expr: 'sjcl_expr'},
- {qty: 'qtcl_qty', expr: 'qtcl_expr'},
- ];
- return _.find(exprField, {qty: field});
- }
- function transExpr(expr) {
- return $.trim(expr).replace('\t', '').replace('=', '').replace('%', '/100');
- }
- const copyBlockTag = 'zh.calc.copyBlock';
- const checkOption = {
- sibling: { enable: 1 },
- empty_code: { enable: 1 },
- calc: {
- enable: 1,
- fields: ['sgfh_qty', 'qtcl_qty', 'sjcl_qty', 'quantity'],
- },
- zero: { enable: 1 },
- zeroPos: { enable: 1 },
- tp: {
- enable: 1,
- fields: [
- {qty: 'sgfh_qty', tp: 'sgfh_tp'},
- {qty: 'sjcl_qty', tp: 'sjcl_tp'},
- {qty: 'qtcl_qty', tp: 'qtcl_tp'},
- {qty: 'quantity', tp: 'total_price'},
- {qty: 'deal_qty', tp: 'deal_tp'},
- ],
- },
- };
- $(document).ready(() => {
- let stdXmj, stdGcl, searchLedger;
- autoFlashHeight();
- // 初始化spread
- const billsSpread = SpreadJsObj.createNewSpread($('#bills-spread')[0]);
- const billsSheet = billsSpread.getActiveSheet();
- sjsSettingObj.setFxTreeStyle(billsSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
- if (thousandth) sjsSettingObj.setTpThousandthFormat(billsSpreadSetting);
- SpreadJsObj.initSheet(billsSheet, billsSpreadSetting);
- const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]);
- const posSheet = posSpread.getActiveSheet();
- sjsSettingObj.setGridSelectStyle(posSpreadSetting);
- if (thousandth) sjsSettingObj.setTpThousandthFormat(posSpreadSetting);
- SpreadJsObj.initSheet(posSheet, posSpreadSetting);
- const posSearch = $.posSearch({selector: '#pos-search', searchSpread: posSpread});
- const errorList = $.cs_errorList({
- tabSelector: '#error-list-tab',
- selector: '#error-list',
- relaSpread: billsSpread,
- storeKey: 'revise-error-' + window.location.pathname.split('/')[2] + '-' + window.location.pathname.split('/')[4],
- afterLocated: function () {
- posSpreadObj.loadCurPosData();
- },
- afterShow: function () {
- billsSpread.refresh();
- if (posSpread) posSpread.refresh();
- },
- });
- const checkList = $.ledger_checkList({
- id: 'check-list',
- tabSelector: '#check-list-tab',
- selector: '#check-list',
- relaSpread: billsSpread,
- storeKey: 'revise-check-' + window.location.pathname.split('/')[2] + '-' + window.location.pathname.split('/')[4],
- checkType: getCheckType(checkOption),
- afterLocated: function () {
- posSpreadObj.loadCurPosData();
- },
- afterShow: function () {
- billsSpread.refresh();
- if (posSpread) posSpread.refresh();
- },
- });
- const sumLoadMiss = $.sumLoadMiss({
- tabSelector: '#sum-load-miss-tab',
- selector: '#sum-load-miss',
- relaSpread: billsSpread,
- storeKey: 'revise-slm-' + window.location.pathname.split('/')[2] + '-' + window.location.pathname.split('/')[4],
- id: 'revise-slm',
- afterLocated: function () {
- posSpreadObj.loadCurPosData();
- },
- afterShow: function () {
- billsSpread.refresh();
- if (posSpread) posSpread.refresh();
- },
- });
- // 初始化 节点树结构
- const treeSetting = {
- id: 'ledger_id',
- pid: 'ledger_pid',
- order: 'order',
- level: 'level',
- rootId: -1,
- keys: ['id', 'tender_id', 'ledger_id'],
- calcFields: ['sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'],
- autoExpand: 3,
- };
- if (!isTz) {
- treeSetting.calcFields.push('deal_tp');
- }
- treeSetting.calcFun = function (node) {
- node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), 2);
- };
- const billsTree = createNewPathTree('revise', treeSetting);
- // 初始化 计量单元
- const pos = new PosData({ id: 'id', ledgerId: 'lid' });
- // 清单 相关方法&绑定spreadjs事件
- const billsTreeSpreadObj = {
- loadExprToInput(sheet) {
- const sel = sheet.getSelections()[0];
- const col = sheet.zh_setting.cols[sel.col], cell = sheet.getCell(sel.row, sel.col);
- if (col && col.type === 'Number') {
- const data = SpreadJsObj.getSelectObject(sheet);
- if (data) {
- const exprInfo = getExprInfo(col.field);
- if (exprInfo) {
- $('#bills-expr').val(data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field])
- .attr('field', col.field).attr('org', data[col.field]);
- } else {
- $('#bills-expr').val(data[col.field]).attr('field', col.field).attr('org', data[col.field]);
- }
- if (col.field.indexOf('dgn') >= 0) {
- $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (_.isString(data.b_code) && data.b_code !== ''));
- } else if (col.field === 'unit_price') {
- $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (data.children && data.children.length > 0) || (_.isBoolean(data.used) && data.used === true));
- } else {
- const nodePos = pos.getLedgerPos(data.id);
- if (nodePos && nodePos.length > 0) {
- $('#bills-expr').val('').attr('readOnly', true);
- $('#bills-expr').removeAttr('data-row');
- } else {
- $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (data.children && data.children.length > 0));
- }
- }
- $('#bills-expr').attr('data-row', sel.row);
- } else {
- $('#bills-expr').val('').attr('readOnly', true);
- $('#bills-expr').removeAttr('data-row');
- }
- } else {
- $('#bills-expr').val('').attr('readOnly', true);
- $('#bills-expr').removeAttr('data-row');
- }
- },
- getDefaultSelectInfo: function (sheet) {
- const tree = sheet.zh_tree;
- if (!tree) return;
- const sel = sheet.getSelections()[0];
- const node = sheet.zh_tree.nodes[sel.row];
- if (!node) return;
- let count = 1;
- if (sel.rowCount > 1) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = sheet.zh_tree.nodes[sel.row + r];
- if (rNode.level > node.level) continue;
- if ((rNode.level < node.level) || (rNode.level === node.level && rNode.pid !== node.pid)) {
- toastr.warning('请选择同一节点下的节点,进行该操作');
- return;
- }
- count += 1;
- }
- }
- return [tree, node, count];
- },
- /**
- * 刷新顶部按钮是否可用
- * @param sheet
- * @param selections
- */
- refreshOperationValid: function (sheet, selection) {
- const setObjEnable = function (obj, enable) {
- if (enable) {
- obj.removeClass('disabled');
- } else {
- obj.addClass('disabled');
- }
- };
- const invalidAll = function () {
- setObjEnable($('a[name=base-opr][type=add]'), false);
- setObjEnable($('a[name=base-opr][type=delete]'), false);
- setObjEnable($('a[name=base-opr][type=up-move]'), false);
- setObjEnable($('a[name=base-opr][type=down-move]'), false);
- setObjEnable($('a[name=base-opr][type=up-level]'), false);
- setObjEnable($('a[name=base-opr][type=down-level]'), false);
- };
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const tree = sheet.zh_tree;
- if (!tree) {
- invalidAll();
- return;
- }
- const first = sheet.zh_tree.nodes[row];
- if (!first) {
- invalidAll();
- return;
- }
- let last = first, sameParent = true, nodeUsed = first.used;
- if (sel.rowCount > 1 && first) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[sel.row + r];
- if (!rNode) {
- sameParent = false;
- break;
- }
- nodeUsed = nodeUsed || rNode.used;
- if (rNode.level > first.level) continue;
- if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
- sameParent = false;
- break;
- }
- last = rNode;
- }
- }
- const preNode = tree.getPreSiblingNode(first);
- const valid = !sheet.zh_setting.readOnly;
- setObjEnable($('a[name=base-opr][type=add]'), valid && first && first.level > 1);
- setObjEnable($('a[name=base-opr][type=delete]'), valid && first && sameParent && first.level > 1 && !nodeUsed);
- setObjEnable($('a[name=base-opr][type=up-move]'), valid && first && sameParent && first.level > 1 && preNode);
- setObjEnable($('a[name=base-opr][type=down-move]'), valid && first && sameParent && first.level > 1 && !tree.isLastSibling(last));
- const posRange = last ? pos.getLedgerPos(last.id) : [];
- setObjEnable($('a[name=base-opr][type=up-level]'), valid && first && sameParent && tree.getParent(first) && !nodeUsed
- && first.level > 2 && ((!posRange || posRange.length === 0) || tree.isLastSibling(last)));
- const preNodePosRange = preNode ? pos.getLedgerPos(preNode.id) : [];
- setObjEnable($('a[name=base-opr][type=down-level]'), valid && first && sameParent
- && first.level > 1 && preNode && (!preNodePosRange || preNodePosRange.length === 0) && !preNode.used);
- setObjEnable($('#cut'), valid);
- setObjEnable($('#paste'), valid);
- },
- /**
- *
- * @param sheet
- * @param data
- */
- refreshTree: function (sheet, data) {
- SpreadJsObj.massOperationSheet(sheet, function () {
- const tree = sheet.zh_tree;
- // 处理删除
- if (data.delete) {
- data.delete.sort(function (a, b) {
- return b.deleteIndex - a.deleteIndex;
- });
- for (const d of data.delete) {
- sheet.deleteRows(d.deleteIndex, 1);
- }
- }
- // 处理新增
- if (data.create) {
- const newNodes = data.create;
- if (newNodes) {
- newNodes.sort(function (a, b) {
- return a.index - b.index;
- });
- for (const node of newNodes) {
- sheet.addRows(node.index, 1);
- SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(node), 1);
- }
- }
- }
- // 处理更新
- if (data.update) {
- const rows = [];
- for (const u of data.update) {
- rows.push(tree.nodes.indexOf(u));
- }
- SpreadJsObj.reLoadRowsData(sheet, rows);
- }
- // 处理展开
- if (data.expand) {
- const expanded = [];
- for (const e of data.expand) {
- if (expanded.indexOf(e) === -1) {
- const posterity = tree.getPosterity(e);
- for (const p of posterity) {
- sheet.setRowVisible(tree.nodes.indexOf(p), p.visible);
- expanded.push(p);
- }
- }
- }
- }
- });
- },
- selectionChanged: function (e, info) {
- if (info.newSelections) {
- if (!info.oldSelections || info.newSelections[0].row !== info.oldSelections[0].row) {
- billsTreeSpreadObj.refreshOperationValid(info.sheet);
- SpreadJsObj.resetTopAndSelect(posSheet);
- posSpreadObj.loadCurPosData();
- SpreadJsObj.saveTopAndSelect(billsSheet, ckBillsSpread);
- posSearch.search($('#pos-keyword').val());
- }
- }
- billsTreeSpreadObj.loadExprToInput(info.sheet);
- },
- /**
- * 新增节点
- * @param spread
- */
- baseOpr: function (sheet, type, addCount = 1) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (!tree || !node || !count) return;
- if (type === 'delete') {
- const parent = tree.getParent(node);
- const children = parent ? parent.children : tree.children;
- const index = children.indexOf(node);
- for (let i = 0; i < count; i++) {
- const child = children[i+index];
- if (tree.checkNodeUsed(child, pos)) {
- toastr.warning('选中的节点已计量,不可删除');
- return;
- }
- }
- } else if (type === 'up-level') {
- const parent = tree.getParent(node);
- const children = parent ? parent.children : tree.children;
- const index = children.indexOf(node);
- for (let i = index; i < children.length; i++) {
- const child = children[index];
- if (tree.checkNodeUsed(child, pos)) {
- if (i >= index + count) {
- toastr.warning('其后节点已计量,选中的节点不可升级');
- } else {
- toastr.warning('选中的节点已计量,不可升级');
- }
- return;
- }
- }
- } else if (type === 'down-level') {
- const parent = tree.getParent(node);
- const children = parent ? parent.children : tree.children;
- const index = children.indexOf(node);
- for (let i = 0; i < count; i++) {
- const child = children[i+index];
- if (tree.checkNodeUsed(child, pos)) {
- toastr.warning('选中的节点已计量,不可降级');
- return;
- }
- }
- }
- if (type === 'delete') {
- deleteAfterHint(function () {
- postData(window.location.pathname + '/update', {
- postType: type,
- postData: {
- id: node.ledger_id,
- count: type === 'add' ? addCount : count,
- }
- }, function (result) {
- const refreshData = tree.loadPostData(result);
- self.refreshTree(sheet, refreshData);
- const sel = sheet.getSelections()[0];
- if (sel) {
- sheet.setSelection(sel.row, sel.col, 1, sel.colCount);
- }
- self.refreshOperationValid(sheet);
- });
- });
- } else {
- postData(window.location.pathname + '/update', {
- postType: type,
- postData: {
- id: node.ledger_id,
- count: type === 'add' ? addCount : count,
- }
- }, function (result) {
- const refreshData = tree.loadPostData(result);
- self.refreshTree(sheet, refreshData);
- if (['up-move', 'down-move'].indexOf(type) > -1) {
- const sel = sheet.getSelections()[0];
- if (sel) {
- sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(node)]);
- }
- } else if (type === 'add') {
- const sel = sheet.getSelections()[0];
- if (sel) {
- sheet.setSelection(tree.nodes.indexOf(refreshData.create[0]), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(refreshData.create[0])]);
- }
- }
- self.refreshOperationValid(sheet);
- });
- }
- },
- /**
- * 编辑单元格响应事件
- * @param {Object} e
- * @param {Object} info
- */
- editEnded: function (e, info) {
- if (info.sheet.zh_setting) {
- const col = info.sheet.zh_setting.cols[info.col];
- const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
- const node = sortData[info.row];
- const data = {
- id: node.id,
- tender_id: node.tender_id,
- ledger_id: node.ledger_id
- };
- // 未改变值则不提交
- const orgValue = node[col.field];
- const newValue = trimInvalidChar(info.editingText);
- if (orgValue == info.editingText || ((!orgValue || orgValue === '') && (newValue === ''))) {
- return;
- }
- // 台账模式,检查计量单元相关
- if (isTz) {
- if (col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
- col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
- col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
- if (!node.children || node.children.length ===0) {
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- toastr.error('清单含有计量单元,不可修改施工图复核数量');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- }
- if (col.field === 'b_code' && (newValue === '' || !newValue)) {
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- toastr.error('清单含有计量单元,请先删除计量单元,再删除清单编号');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- }
- // 获取更新数据
- const exprInfo = getExprInfo(col.field);
- if (info.editingText) {
- const text = newValue;
- if (node.used && (col.field === 'code' || col.field ==='b_code') && orgValue !== '' && text === '') {
- toastr.error('节点已计量,请勿删除编号');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- if (col.type === 'Number') {
- const num = _.toNumber(text);
- if (_.isFinite(num)) {
- data[col.field] = num;
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- } else {
- try {
- data[col.field] = math.evaluate(transExpr(text));
- if (exprInfo) {
- data[exprInfo.expr] = newValue;
- }
- } catch(err) {
- toastr.error('输入的表达式非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- } else {
- data[col.field] = text;
- }
- } else {
- if (node.used && (col.field === 'code' || col.field ==='b_code') && orgValue !== '') {
- toastr.error('节点已计量,请勿删除编号');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- data[col.field] = null;
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- }
- // 更新至服务器
- postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
- const refreshNode = billsTree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(info.sheet, refreshNode);
- });
- }
- },
- clipboardPasting: function (e, info) {
- const tree = info.sheet.zh_tree, setting = info.sheet.zh_setting;
- info.cancel = true;
- if (!setting || !tree) return;
- // const range = info.cellRange;
- // for (let iRow = range.row; iRow < range.row + range.rowCount; iRow++) {
- // const node = tree.nodes[iRow];
- // if (tree.checkNodeUsed(node, pos)) {
- // toastr.warning('"' + node.code + node.b_code + ' ' + node.name +'"已计量,请勿修改');
- // return;
- // }
- // }
- const pasteData = info.pasteData.html
- ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
- : (info.pasteData.text === ''
- ? SpreadJsObj.Clipboard.getAnalysisPasteText()
- : SpreadJsObj.analysisPasteText(info.pasteData.text));
- const hint = {
- usedUp: {type: 'warning', msg: '节点已计量,不可修改单价'},
- usedCode: {type: 'warning', msg: '节点已计量,编号不可修改为空值'},
- invalidExpr: {type: 'warning', msg: '粘贴的表达式非法'},
- posCode: {type: 'warning', msg: '清单含有计量单元,不可粘贴清单编号为空'},
- posQty: {type: 'warning', msg: '清单含有计量单元,数量金额根据计量单元汇总计算所得,不可粘贴'},
- parent: {type: 'warning', msg: '含有子项的清单,不可粘贴数量、单价、金额'},
- gcl: {type: 'warning', msg: '工程量清单,不可粘贴项目节数量'},
- posXmj: {type: 'warning', msg: '清单含有计量单元,不可粘贴项目节编号'},
- sameParent: {type: 'warning', msg: '仅可粘贴同层节点'},
- };
- const datas = [], filterNodes = [];
- let pid, level, filterRow = 0;
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
- const curRow = info.cellRange.row + iRow;
- const node = tree.nodes[curRow];
- if (!node) continue;
- if (!pid) pid = node.ledger_pid;
- if (!level) level = node.level;
- if (node.ledger_pid !== pid) {
- toastMessageUniq(hint.sameParent);
- filterRow+=1;
- continue;
- }
- if (node.level < level) break;
- let bPaste = false;
- const data = info.sheet.zh_tree.getNodeKeyData(node);
- for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
- const curCol = info.cellRange.col + iCol;
- const colSetting = info.sheet.zh_setting.cols[curCol];
- const value = trimInvalidChar(pasteData[iRow-filterRow][iCol]);
- if (node.children && node.children.length > 0 && invalidFields.parent.indexOf(colSetting.field) >= 0) {
- toastMessageUniq(hint.parent);
- continue;
- }
- if (!_.isEmpty(node.b_code) && invalidFields.gcl.indexOf(colSetting.field) >= 0) {
- toastMessageUniq(hint.gcl);
- continue;
- }
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- if (value === '' && colSetting.field === 'b_code') {
- toastMessageUniq(hint.posCode);
- continue;
- }
- if (colSetting.field === 'sgfh_qty' || colSetting.field === 'sgfh_tp' ||
- colSetting.field === 'sjcl_qty' || colSetting.field === 'sjcl_tp' ||
- colSetting.field === 'qtcl_qty' || colSetting.field === 'qtcl_tp') {
- toastMessageUniq(hint.posQty);
- continue;
- }
- if (value !== '' && invalidFields.posXmj.indexOf(colSetting.field) >= 0) {
- toastMessageUniq(hint.posXmj);
- continue;
- }
- }
- if (tree.checkNodeUsed(node, pos) && colSetting.field === 'unit_price') {
- toastMessageUniq (hint.usedUp);
- continue;
- }
- if (colSetting.type === 'Number') {
- const num = _.toNumber(value);
- if (num) {
- data[colSetting.field] = num;
- } else {
- try {
- data[colSetting.field] = math.evaluate(transExpr(value));
- const exprInfo = getExprInfo(colSetting.field);
- if (exprInfo) {
- data[exprInfo.expr] = value;
- }
- bPaste = true;
- } catch (err) {
- toastMessageUniq(hint.invalidExpr);
- continue;
- }
- }
- } else {
- if (node.used && (colSetting.field === 'code' || colSetting.field ==='b_code')
- && data[colSetting.field] !== '' && value === '') {
- toastMessageUniq(hint.usedCode);
- continue;
- }
- data[colSetting.field] = value;
- }
- bPaste = true;
- }
- if (bPaste) {
- datas.push(data);
- } else {
- filterNodes.push(node);
- }
- }
- if (datas.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = tree.loadPostData(result);
- if (refreshNode.update) {
- refreshNode.update = refreshNode.update.concat(filterNodes);
- }
- billsTreeSpreadObj.refreshTree(info.sheet, refreshNode);
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- });
- } else {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- }
- },
- clipboardPasted: function (e, info) {
- const hint = {
- usedUp: {type: 'error', msg: '节点已计量,不可修改单价'},
- usedCode: {type: 'error', msg: '节点已计量,编号不可修改为空值'},
- invalidExpr: {type: 'error', msg: '粘贴的表达式非法'},
- posCode: {type: 'error', msg: '清单含有计量单元,请先删除计量单元,再修改清单编号为空'},
- posQty: {type: 'error', msg: '清单含有计量单元,数量金额根据计量单元汇总计算所得,不可修改'},
- };
- const tree = info.sheet.zh_tree;
- if (!tree) { return; }
- const sortData = info.sheet.zh_tree.nodes;
- const datas = [], filterNodes = [];
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
- let bPaste = false;
- const curRow = info.cellRange.row + iRow;
- const node = sortData[curRow];
- if (node) {
- const data = info.sheet.zh_tree.getNodeKeyData(node);
- for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
- const curCol = info.cellRange.col + iCol;
- const colSetting = info.sheet.zh_setting.cols[curCol];
- const value = trimInvalidChar(info.sheet.getText(curRow, curCol));
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- if (value === '' && colSetting.field === 'b_code') {
- toastMessageUniq(hint.posCode);
- continue;
- }
- if (colSetting.field === 'sgfh_qty' || colSetting.field === 'sgfh_tp' ||
- colSetting.field === 'sjcl_qty' || colSetting.field === 'sjcl_tp' ||
- colSetting.field === 'qtcl_qty' || colSetting.field === 'qtcl_tp') {
- toastMessageUniq(hint.posQty);
- continue;
- }
- }
- if (node.used && col.field === 'unit_price') {
- toastMessageUniq (hint.usedUp);
- continue;
- }
- if (colSetting.type === 'Number') {
- const num = _.toNumber(value);
- if (num) {
- data[colSetting.field] = num;
- } else {
- try {
- data[colSetting.field] = math.evaluate(transExpr(value));
- } catch (err) {
- toastMessageUniq(hint.invalidExpr);
- continue;
- }
- }
- } else {
- if (node.used && (col.field === 'code' || col.field ==='b_code')
- && data[colSetting.field] !== '' && value === '') {
- toastMessageUniq(hint.usedCode);
- continue;
- }
- data[colSetting.field] = value;
- }
- bPaste = true;
- }
- if (bPaste) {
- datas.push(data);
- } else {
- filterNodes.push(node);
- }
- }
- }
- if (datas.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = tree.loadPostData(result);
- if (refreshNode.update) {
- refreshNode.update = refreshNode.update.concat(filterNodes);
- }
- billsTreeSpreadObj.refreshTree(info.sheet, refreshNode);
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- });
- } else {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- }
- },
- deletePress: function (sheet) {
- if (!sheet.zh_setting) return;
- const sel = sheet.getSelections()[0], datas = [];
- for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
- let bDel = false;
- const node = sheet.zh_tree.nodes[iRow];
- const data = sheet.zh_tree.getNodeKeyData(node);
- for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
- const col = sheet.zh_setting.cols[iCol];
- const style = sheet.getStyle(iRow, iCol);
- if (style.locked || (['dgn_qty1', 'dgn_qty2'].indexOf(col.field) >= 0 && node.b_code)) continue;
- if (['dgn_qty1', 'dgn_qty2'].indexOf(col.field) < 0 && sheet.zh_tree.checkNodeUsed(node, pos)) {
- toastr.warning('"' + (node.code || '') + (node.b_code || '') + ' ' + node.name +'"已计量,请勿修改');
- return;
- }
- data[col.field] = null;
- const exprInfo = getExprInfo(col.field);
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- bDel = true;
- }
- if (bDel) datas.push(data);
- }
- if (datas.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = sheet.zh_tree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(sheet, refreshNode);
- billsTreeSpreadObj.loadExprToInput(sheet);
- });
- }
- },
- pasteBlock: function (spread, copyInfo) {
- const self = this;
- const sheet = spread.getActiveSheet();
- const [tree, node] = this.getDefaultSelectInfo(spread.getActiveSheet());
- postData(window.location.pathname + '/update', {
- postType: 'paste-block',
- postData: {
- id: tree.getNodeKey(node),
- tid: copyInfo.tid,
- block: copyInfo.block,
- }
- }, function (data) {
- pos.updateDatas(data.pos);
- const result = tree.loadPostData(data.ledger);
- self.refreshTree(sheet, result);
- const sel = sheet.getSelections()[0];
- if (sel) {
- sheet.setSelection(tree.nodes.indexOf(result.create[0]), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(result.create[0])]);
- }
- self.refreshOperationValid(sheet);
- removeLocalCache(copyBlockTag);
- }, null, true);
- },
- topRowChanged: function (e, info) {
- SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
- },
- editStarting(e, info) {
- if (!info.sheet.zh_setting || !info.sheet.zh_tree) return;
- const col = info.sheet.zh_setting.cols[info.col];
- const node = info.sheet.zh_tree.nodes[info.row];
- if (!node) {
- info.cancel = true;
- return;
- }
- const exprInfo = getExprInfo(col.field);
- if (exprInfo) {
- if (node[exprInfo.expr] && node[exprInfo.expr] !== '') {
- info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]);
- }
- }
- switch (col.field) {
- case 'code':
- const posRange = pos.getLedgerPos(node.id);
- info.cancel = posRange && posRange.length > 0;
- break;
- case 'unit_price':
- info.cancel = (node.children && node.children.length > 0) || node.used;
- break;
- case 'sgfh_qty':
- case 'sgfh_tp':
- case 'sjcl_qty':
- case 'sjcl_tp':
- case 'qtcl_qty':
- case 'qtcl_tp':
- case 'deal_qty':
- case 'deal_tp':
- info.cancel = (node.children && node.children.length > 0);
- break;
- case 'dgn_qty1':
- case 'dgn_qty2':
- info.cancel = !_.isEmpty(node.b_code);
- break;
- }
- },
- cut: function (sheet, sel, callback) {
- if (!sheet || !sel) return;
- if (sel.colCount >= sheet.zh_setting.cols.length) {
- toastr.warning('请勿选中整行剪切');
- return;
- }
- const sortData = SpreadJsObj.getSortData(sheet), datas = [];
- for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
- const node = sortData[iRow];
- if (node) {
- const data = sheet.zh_tree.getNodeKeyData(node);
- for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
- const col = sheet.zh_setting.cols[iCol];
- if (col.field === 'b_code' || col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
- col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
- col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- toastr.error('不可剪切');
- return;
- }
- }
- const style = sheet.getStyle(iRow, iCol);
- if (style.locked) {
- toastr.error('不可剪切');
- return;
- }
- const colSetting = sheet.zh_setting.cols[iCol];
- data[colSetting.field] = null;
- const exprInfo = getExprInfo(colSetting.field);
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- }
- datas.push(data);
- }
- }
- if (datas.length > 0) {
- callback();
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = sheet.zh_tree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(sheet, refreshNode);
- });
- }
- },
- sortCode: function (sheet) {
- const tree = sheet.zh_tree;
- if (!tree) return;
- const select = SpreadJsObj.getSelectObject(sheet);
- if (!select || !select.code || select.code === '') return;
- const recursiveSortCode = function (data, parentCode, children) {
- if (!children || children.length === 0) return;
- for (const [i, child] of children.entries()) {
- if (!child.b_code || child.b_code === '') {
- const code = parentCode + '-' + (i + 1);
- const cData = tree.getNodeKeyData(child);
- cData.code = code;
- data.push(cData);
- if (!tree.isLeafXmj(child)) {
- recursiveSortCode(data, code, child.children);
- }
- }
- }
- };
- const data = [];
- recursiveSortCode(data, select.code, select.children);
- if (data.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
- const refreshNode = tree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(sheet, refreshNode);
- })
- }
- }
- };
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- billsTreeSpreadObj.loadExprToInput(billsSheet);
- billsSpread.bind(spreadNS.Events.SelectionChanged, billsTreeSpreadObj.selectionChanged);
- billsSpread.bind(spreadNS.Events.topRowChanged, billsTreeSpreadObj.topRowChanged);
- if (!readOnly) {
- // 增删上下移升降级
- $('a[name="base-opr"]').click(function () {
- billsTreeSpreadObj.baseOpr(billsSheet, this.getAttribute('type'));
- });
- $('a[name=cpc]').click(function () {
- billsSpread.commandManager().execute({
- cmd: this.getAttribute('type'),
- sheetName: billsSheet.name()
- });
- });
- $('#bills-expr').bind('change onblur', function () {
- if (this.readOnly) return;
- const expr = $(this);
- const row = expr.attr('data-row') ? _.toInteger(expr.attr('data-row')) : -1;
- const select = billsTree.getItemsByIndex(row);
- if (!select) return;
- const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = trimInvalidChar(expr.val());
- if (orgValue === newValue || (!orgValue && newValue == '')) { return; }
- const data = {
- id: select.id,
- tender_id: select.tender_id,
- ledger_id: select.ledger_id
- };
- const exprInfo = getExprInfo(field);
- if (newValue !== '') {
- const num = _.toNumber(newValue);
- if (num) {
- data[field] = num;
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- } else {
- try {
- data[field] = math.evaluate(transExpr(newValue));
- if (exprInfo) {
- data[exprInfo.expr] = newValue;
- }
- } catch (err) {
- toastr.error('输入的表达式非法');
- return;
- }
- }
- } else {
- data[field] = null;
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- }
- // 更新至服务器
- postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
- const refreshNode = billsTree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(billsSheet, refreshNode);
- });
- });
- billsSpread.bind(spreadNS.Events.EditStarting, billsTreeSpreadObj.editStarting);
- billsSpread.bind(spreadNS.Events.EditEnded, billsTreeSpreadObj.editEnded);
- billsSpread.bind(spreadNS.Events.ClipboardPasting, billsTreeSpreadObj.clipboardPasting);
- billsSpread.bind(spreadNS.Events.ClipboardChanging, function (e, info) {
- const copyText = SpreadJsObj.getFilterCopyText(info.sheet);
- SpreadJsObj.Clipboard.setCopyData(copyText);
- });
- SpreadJsObj.addDeleteBind(billsSpread, billsTreeSpreadObj.deletePress);
- SpreadJsObj.addCutEvents(billsSpread, billsTreeSpreadObj.cut);
- }
- // 右键菜单
- let batchInsertObj;
- $.contextMenu.types.batchInsert = function (item, opt, root) {
- const self = this;
- if ($.isFunction(item.icon)) {
- item._icon = item.icon.call(this, this, $t, key, item);
- } else {
- if (typeof(item.icon) === 'string' && item.icon.substring(0, 3) === 'fa-') {
- // to enable font awesome
- item._icon = root.classNames.icon + ' ' + root.classNames.icon + '--fa fa ' + item.icon;
- } else {
- item._icon = root.classNames.icon + ' ' + root.classNames.icon + '-' + item.icon;
- }
- }
- this.addClass(item._icon);
- const $obj = $('<div>' + item.name + '<input class="text-right ml-1 mr-1" type="tel" max="20" min="1" value="' + item.value + '" style="width: 30px; height: 18px; padding-right: 4px;">行</div>')
- .appendTo(this);
- const $input = $obj.find('input');
- const event = () => {
- if (self.hasClass('context-menu-disabled')) return;
- item.batchInsert($input[0], root);
- };
- $obj.on('click', event).keypress(function (e) {if (e.keyCode === 13) { event(); }});
- $input.click((e) => {e.stopPropagation();})
- .keyup((e) => {if (e.keyCode === 13) item.batchInsert($input[0], root);})
- .on('input', function () {this.value = this.value.replace(/[^\d]/g, '');});
- };
- const billsContextMenuOptions = {
- selector: '#bills-spread',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, billsSpread);
- return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
- },
- items: {}
- };
- if (!readOnly) {
- billsContextMenuOptions.items.create = {
- name: '新增',
- icon: 'fa-sign-in',
- callback: function (key, opt) {
- billsTreeSpreadObj.baseOpr(billsSheet, 'add');
- },
- disabled: function (key, opt) {
- const sheet = billsSheet;
- const selection = sheet.getSelections();
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const tree = sheet.zh_tree;
- if (!tree) return true;
- const first = sheet.zh_tree.nodes[row];
- const valid = !sheet.zh_setting.readOnly;
- return !(valid && first && first.level > 1);
- }
- };
- billsContextMenuOptions.items.delete = {
- name: '删除',
- icon: 'fa-remove',
- callback: function (key, opt) {
- billsTreeSpreadObj.baseOpr(billsSheet, 'delete');
- },
- disabled: function (key, opt) {
- const sheet = billsSheet;
- const selection = sheet.getSelections();
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const tree = sheet.zh_tree;
- if (!tree) return true;
- const first = sheet.zh_tree.nodes[row];
- let last = first, sameParent = true, nodeUsed = first.used;
- if (sel.rowCount > 1 && first) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[sel.row + r];
- if (!rNode) {
- sameParent = false;
- break;
- }
- nodeUsed = nodeUsed || rNode.used;
- if (rNode.level > first.level) continue;
- if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
- sameParent = false;
- break;
- }
- last = rNode;
- }
- }
- const valid = !sheet.zh_setting.readOnly;
- return !(valid && first && sameParent && !(first.level === 1 && first.node_type) && !nodeUsed);
- }
- };
- billsContextMenuOptions.items.sprBase = '----';
- }
- billsContextMenuOptions.items.copyBlock = {
- name: '复制整块',
- icon: 'fa-files-o',
- callback: function (key, opt) {
- const copyBlockList = [];
- const sheet = billsSheet;
- const sel = sheet.getSelections()[0];
- let iRow = sel.row;
- const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
- while (iRow < sel.row + sel.rowCount) {
- const node = sheet.zh_tree.nodes[iRow];
- if (node.ledger_pid !== pid) {
- toastr.error('仅可同时选中同层节点');
- return;
- }
- const posterity = sheet.zh_tree.getPosterity(node);
- iRow += posterity.length + 1;
- posterity.unshift(node);
- copyBlockList.push(sheet.zh_tree.getDefaultData(posterity));
- }
- for (const cbl of copyBlockList) {
- for (const b of cbl) {
- const posRange = pos.getLedgerPos(b.id);
- if (posRange && posRange.length > 0) b.pos = posRange;
- }
- }
- setLocalCache(copyBlockTag, JSON.stringify({ block: copyBlockList }));
- },
- visible: function (key, opt) {
- const sheet = billsSheet;
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = billsTree.nodes[row];
- return select;
- },
- disabled: function (key, opt) {
- const sheet = billsSheet;
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = billsTree.nodes[row];
- return select && select.level <= 1;
- }
- };
- billsContextMenuOptions.items.copyBlockXmj = {
- name: '复制整块(只复制项目节)',
- icon: 'fa-files-o',
- callback: function (key, opt) {
- const copyBlockList = [];
- const sheet = billsSheet;
- const sel = sheet.getSelections()[0];
- let iRow = sel.row;
- const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
- while (iRow < sel.row + sel.rowCount) {
- const node = sheet.zh_tree.nodes[iRow];
- if (node.ledger_pid !== pid) {
- toastr.error('仅可同时选中同层节点');
- return;
- }
- const posterity = sheet.zh_tree.getPosterity(node);
- iRow += posterity.length + 1;
- const copyPosterity = posterity.filter(x => { return !x.b_code; });
- copyPosterity.unshift(node);
- const copyData = sheet.zh_tree.getDefaultData(copyPosterity);
- for (const p of copyData) {
- const children = copyData.filter(y => {return y.ledger_pid === p.ledger_id}) || [];
- p.is_leaf = children.length === 0;
- }
- copyBlockList.push(copyData);
- }
- setLocalCache(copyBlockTag, JSON.stringify({ block: copyBlockList }));
- },
- visible: function (key, opt) {
- const sheet = billsSheet;
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = billsTree.nodes[row];
- return select;
- },
- disabled: function (key, opt) {
- const sheet = billsSheet;
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = billsTree.nodes[row];
- return select && select.level <= 1;
- }
- };
- if (!readOnly) {
- billsContextMenuOptions.items.pasteBlock = {
- name: '粘贴整块',
- icon: 'fa-clipboard',
- disabled: function (key, opt) {
- //const block = treeOperationObj.block || [];
- const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
- return !(copyInfo && copyInfo.block && copyInfo.block.length > 0);
- },
- callback: function (key, opt) {
- //const block = treeOperationObj.block || [];
- const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
- if (copyInfo.block.length > 0) {
- billsTreeSpreadObj.pasteBlock(billsSpread, copyInfo);
- } else {
- document.execCommand('paste');
- }
- },
- visible: function (key, opt) {
- return !readOnly;
- }
- };
- billsContextMenuOptions.items.sprBlock = '----';
- }
- if (!readOnly) {
- billsContextMenuOptions.items.batchInsert = {
- name: '批量插入',
- type: 'batchInsert',
- value: '2',
- icon: 'fa-sign-in',
- batchInsert: function (obj, root) {
- if (_.toNumber(obj.value) > _.toNumber(obj.max)) {
- obj.value = obj.max;
- toastr.warning('批量插入不可多于' + obj.max);
- } else if (_.toNumber(obj.value) < _.toNumber(obj.min)) {
- obj.value = obj.min;
- toastr.warning('批量插入不可少于' + obj.min);
- } else {
- billsTreeSpreadObj.baseOpr(billsSheet, 'add', parseInt(obj.value));
- root.$menu.trigger('contextmenu:hide');
- }
- },
- disabled: function (key, opt) {
- const sheet = billsSheet;
- const selection = sheet.getSelections();
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const tree = sheet.zh_tree;
- if (!tree) return true;
- const first = sheet.zh_tree.nodes[row];
- const valid = !sheet.zh_setting.readOnly;
- return !(valid && first && first.level > 1);
- }
- };
- billsContextMenuOptions.items.batchInsertBillsPos = {
- name: '批量插入清单-计量单元',
- icon: 'fa-sign-in',
- disabled: function (key, opt) {
- if (!isTz) return true;
- const select = SpreadJsObj.getSelectObject(billsSheet);
- if (select) {
- if (select.code && select.code !== '') {
- return !billsTree.isLeafXmj(select);
- } else {
- const parent = billsTree.getParent(select);
- return !(parent && billsTree.isLeafXmj(parent));
- }
- } else {
- return false;
- }
- },
- callback: function (key, opt) {
- if (!batchInsertObj) {
- batchInsertObj = new BatchInsertBillsPosObj($('#batch'));
- } else {
- batchInsertObj.initView();
- }
- $('#batch').modal('show');
- }
- };
- billsContextMenuOptions.items.sprBatch = '----';
- billsContextMenuOptions.items.importGclBills2Xmj = {
- name: '导入工程量清单至项目节',
- icon: 'fa-file-excel-o',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(billsSheet);
- return readOnly
- || (node.children && node.children.length > 0)
- || (!_.isNil(node.b_code) && node.b_code !== '')
- || billsTree.checkNodeUsed(node, pos);
- },
- callback: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(billsSheet);
- importExcel.doImport({
- template: {
- hint: '工程量清单',
- url: '/template/导入工程量清单EXCEL格式.xls',
- },
- callback: function (sheet) {
- postDataCompress(window.location.pathname + '/upload-excel/gcl2xmj', {id: node.id, sheet: sheet}, function (result) {
- const sel = billsSheet.getSelections();
- const refreshNode = billsTree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(billsSheet, refreshNode);
- if (refreshNode.create[0]) {
- if (sel && sel[0]) {
- billsSheet.setSelection(refreshNode.create[0].index, sel[0].col, sel[0].rowCount, sel[0].colCount);
- SpreadJsObj.reloadRowsBackColor(billsSheet, [sel[0].row, refreshNode.create[0].index]);
- } else {
- billsSheet.setSelection(refreshNode.create[0].index, 0, 1, 1);
- SpreadJsObj.reloadRowsBackColor(billsSheet, [refreshNode.create[0].index]);
- }
- }
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- }, null);
- }
- });
- }
- };
- const tenderSelect = TenderSelect({
- type: 'revise',
- afterLoad: function (result) {
- const refreshNode = billsTree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(billsSheet, refreshNode);
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- if (result.sumLoadHis.errors.length > 0) {
- sumLoadMiss.loadMissData(result.sumLoadHis.errors);
- sumLoadMiss.show();
- } else {
- sumLoadMiss.clearMissData();
- }
- }
- });
- billsContextMenuOptions.items.importOtherTender = {
- name: '更新(其他标段)工程量清单至项目节',
- icon: 'fa-link',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(billsSheet);
- return readOnly || !node || !billsTree.isLeafXmj(node);
- },
- callback: function (key, opt) {
- tenderSelect.showSelect(SpreadJsObj.getSelectObject(billsSheet));
- }
- };
- }
- billsContextMenuOptions.items.sprTag = '----';
- billsContextMenuOptions.items.showLast = {
- name: '显示至最底层',
- callback: function (key, opt, menu, e) {
- const node = SpreadJsObj.getSelectObject(billsSheet);
- setTimeout(() => {
- showWaitingView();
- billsTree.expandByCustom(x => {
- return x.expanded || (x.id === node.id) || (x.full_path.indexOf(node.ledger_id + '-') >= 0);
- });
- SpreadJsObj.refreshTreeRowVisible(billsSheet);
- closeWaitingView();
- }, 100);
- },
- };
- $.contextMenu(billsContextMenuOptions);
- // 计量单元 相关方法&绑定spreadjs事件
- const posSpreadObj = {
- refreshOperationValid: function (sheet, selection) {
- const setObjEnable = function (obj, enable) {
- if (enable) {
- obj.removeClass('disabled');
- } else {
- obj.addClass('disabled');
- }
- };
- const invalidAll = function () {
- setObjEnable($('a[name=pos-opr][type=up-move]'), false);
- setObjEnable($('a[name=pos-opr][type=down-move]'), false);
- };
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const first = sheet.zh_data[row];
- if (!first) {
- invalidAll();
- return;
- }
- let last = first;
- if (sel.rowCount > 1 && first) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = sheet.zh_data[sel.row + r];
- if (!rNode) break;
- last = rNode;
- }
- }
- const preNode = sheet.zh_data[row - 1];
- const valid = !sheet.zh_setting.readOnly;
- setObjEnable($('a[name=pos-opr][type=up-move]'), valid && first && preNode);
- setObjEnable($('a[name=pos-opr][type=down-move]'), valid && first && (sheet.zh_data.indexOf(last) < sheet.zh_data.length - 1));
- },
- loadExprToInput: function () {
- const sel = posSheet.getSelections()[0];
- if (!sel) return;
- const col = posSheet.zh_setting.cols[sel.col];
- const cell = posSheet.getCell(sel.col, sel.col);
- if (col && col.type === 'Number') {
- const data = SpreadJsObj.getSelectObject(posSheet);
- if (data) {
- const exprInfo = getExprInfo(col.field);
- const value = exprInfo
- ? (data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field])
- : data[col.field];
- $('#pos-expr').val(value).attr('field', col.field).attr('org', data[col.field])
- .attr('readOnly', readOnly || cell.locked()).attr('data-row', sel.row);
- } else {
- $('#pos-expr').val('').attr('readOnly', true);
- $('#pos-expr').removeAttr('data-row');
- }
- } else {
- $('#pos-expr').val('').attr('readOnly', true);
- $('#pos-expr').removeAttr('data-row');
- }
- },
- /**
- * 加载计量单元 根据当前台账选择节点
- */
- loadCurPosData: function () {
- const node = SpreadJsObj.getSelectObject(billsSheet);
- if (node) {
- const posData = pos.getLedgerPos(node.id) || [];
- SpreadJsObj.loadSheetData(posSheet, 'data', posData);
- posSheet.zh_setting.readOnly = readOnly || (node.used && posData.length === 0);
- } else {
- SpreadJsObj.loadSheetData(posSheet, 'data', []);
- posSheet.zh_setting.readOnly = true;
- }
- SpreadJsObj.refreshSheetReadOnly(posSheet);
- posSpreadObj.loadExprToInput();
- posSpreadObj.refreshOperationValid(posSheet);
- },
- baseOpr: function (sheet, type) {
- const data = {
- postType: 'pos',
- posPostType: type === 'delete' ? type : 'update',
- postData: [],
- };
- const selection = sheet.getSelections();
- const row = selection[0].row, count = selection[0].rowCount;
- const first = sheet.zh_data[row];
- if (type === 'delete') {
- for (let iRow = 0; iRow < count; iRow++) {
- const posData = sheet.zh_data[iRow + row];
- if (posData) {
- if (posData.used) {
- toastr.error('"' + posData.name + '"已计量,请勿删除');
- return;
- }
- data.postData.push(sheet.zh_data[iRow + row].id);
- }
- }
- } else if (type === 'up-move') {
- const pre = sheet.zh_data[row - 1], preUpdate = {id: pre.id};
- for (let iRow = 0; iRow < count; iRow++) {
- const posData = sheet.zh_data[iRow + row];
- if (posData) {
- data.postData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row - 1].porder});
- preUpdate.porder = posData.porder;
- }
- }
- data.postData.push(preUpdate);
- } else if (type === 'down-move') {
- const next = sheet.zh_data[row + count], nextUpdate = {id: next.id};
- for (let iRow = count - 1; iRow >= 0; iRow--) {
- const posData = sheet.zh_data[iRow + row];
- if (posData) {
- data.postData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row + 1].porder});
- nextUpdate.porder = posData.porder;
- }
- }
- data.postData.push(nextUpdate);
- }
- if (data.postData.length > 0) {
- postData(window.location.pathname + '/update', data, function (result) {
- if (type === 'delete') {
- pos.removeDatas(result.pos);
- sheet.deleteRows(row, count);
- const loadResult = billsTree.loadPostData(result.ledger);
- billsTreeSpreadObj.refreshTree(billsSheet, loadResult);
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- posSpreadObj.refreshOperationValid(posSheet);
- } else {
- pos.updateDatas(result.pos);
- const sel = selection[0];
- if (sel) {
- sheet.setSelection(sheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, sheet.zh_data.indexOf(first)]);
- }
- posSpreadObj.loadCurPosData();
- }
- });
- }
- },
- editStarting: function (e, info) {
- posSpreadObj.billsNode = SpreadJsObj.getSelectObject(billsSheet);
- const sel = info.sheet.getSelections();
- if (!sel || !sel[0]) return;
- const col = info.sheet.zh_setting.cols[sel[0].col];
- const node = SpreadJsObj.getSelectObject(info.sheet);
- const exprInfo = getExprInfo(col.field);
- if (exprInfo) {
- if (node[exprInfo.expr] && node[exprInfo.expr] !== '') {
- info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]);
- }
- }
- },
- /**
- * 编辑单元格响应事件
- * @param {Object} e
- * @param {Object} info
- */
- editEnded: function (e, info) {
- if (!info.sheet.zh_setting) {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- const posData = info.sheet.zh_data ? info.sheet.zh_data[info.row] : null;
- const col = info.sheet.zh_setting.cols[info.col];
- const orgText = posData ? posData[col.field] : null;
- const newText = trimInvalidChar(info.editingText);
- if (orgText === newText || ((!orgText || orgText === '') && (newText === ''))) return;
- const node = posSpreadObj.billsNode;
- if (!node) {
- toastr.error('数据错误,请选择台账节点后再试');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- } else if (newText && newText !== '' && node.children && node.children.length > 0) {
- toastr.error('父节点不可插入计量单元');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- } else if (newText && newText !== '' && (!node.b_code || node.b_code === '')) {
- toastr.error('项目节不可插入计量单元');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- const data = {postType: 'pos'};
- if (col.field === 'name') {
- if (newText === '' && posData) {
- toastr.error('部位名称不可为空', 'error');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- } else if (!posData) {
- if (newText && newText !== '') {
- data.posPostType = 'add';
- const sortData = info.sheet.zh_data;
- const order = (!sortData || sortData.length === 0) ? 1 : Math.max(sortData[sortData.length - 1].porder + 1, sortData.length + 1);
- data.postData = { name: newText, lid: node.id, porder: order};
- } else {
- return;
- }
- } else {
- data.posPostType = 'update';
- data.postData = {id: posData.id, name: newText};
- }
- } else if (!posData) {
- toastr.warning('新增计量单元请先输入名称');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- } else {
- data.posPostType = 'update';
- data.postData = {id: posData.id};
- if (col.type === 'Number') {
- const exprInfo = getExprInfo(col.field);
- const num = _.toNumber(newText);
- if (_.isFinite(num)) {
- data.postData[col.field] = num;
- if (exprInfo) {
- data.postData[exprInfo.expr] = '';
- }
- } else {
- try {
- data.postData[col.field] = math.evaluate(transExpr(newText));
- if (exprInfo) {
- data.postData[exprInfo.expr] = newText;
- }
- } catch(err) {
- toastr.error('输入的表达式非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- } else {
- data.postData[col.field] = newText;
- }
- }
- postData(window.location.pathname + '/update', data, function (result) {
- const updateRst = pos.updateDatas(result.pos);
- // 刷新当前行, 不适用于新增(在非下一空白行新增)
- if (updateRst.create.length > 0) {
- posSpreadObj.loadCurPosData();
- } else {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- }
- const loadResult = billsTree.loadPostData(result.ledger);
- billsTreeSpreadObj.refreshTree(billsSheet, loadResult);
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- },
- /**
- * 删除按钮响应事件
- * @param sheet
- */
- deletePress: function (sheet) {
- if (!sheet.zh_setting) return;
- const sortData = sheet.zh_data;
- const datas = [], posSelects = [];
- const sel = sheet.getSelections()[0];
- for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
- let bDel = false;
- const node = sortData[iRow];
- if (node) {
- const data = {id: node.id};
- for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
- const colSetting = sheet.zh_setting.cols[iCol];
- if (colSetting.field === 'name') {
- toastr.error('部位名称不能为空');
- return;
- }
- const style = sheet.getStyle(iRow, iCol);
- if (!style.locked) {
- const colSetting = sheet.zh_setting.cols[iCol];
- data[colSetting.field] = null;
- const exprInfo = getExprInfo(colSetting.field);
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- bDel = true;
- }
- }
- if (bDel) {
- datas.push(data);
- posSelects.push(node);
- }
- }
- }
- if (datas.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'pos', posPostType: 'update', postData: datas}, function (result) {
- pos.updateDatas(result.pos);
- posSpreadObj.loadCurPosData();
- const loadResult = billsTree.loadPostData(result.ledger);
- billsTreeSpreadObj.refreshTree(billsSheet, loadResult);
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- }, function () {
- posSpreadObj.loadCurPosData();
- });
- }
- },
- /**
- * 删除 计量单元
- * @param sheet
- */
- deletePos: function (sheet) {
- const selection = sheet.getSelections();
- const data = {
- postType: 'pos',
- posPostType: 'delete',
- postData: [],
- };
- const row = selection[0].row, count = selection[0].rowCount;
- const sortData = sheet.zh_data;
- for (let iRow = 0; iRow < count; iRow++) {
- const posData = sortData[iRow + row];
- if (posData) {
- if (posData.used) {
- toastr.error('"' + posData.name + '"已计量,请勿删除');
- return;
- }
- data.postData.push(sortData[iRow + row].id);
- }
- }
- if (data.postData.length > 0) {
- postData(window.location.pathname + '/update', data, function (result) {
- pos.removeDatas(result.pos);
- sheet.deleteRows(row, count);
- const loadResult = billsTree.loadPostData(result.ledger);
- billsTreeSpreadObj.refreshTree(billsSheet, loadResult);
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- });
- }
- },
- /**
- * 粘贴单元格响应事件
- * @param e
- * @param info
- */
- clipboardPasted: function (e, info) {
- if (info.sheet.getColumnCount() > info.sheet.zh_setting.cols.length) {
- info.sheet.setColumnCount(info.sheet.zh_setting.cols.length);
- }
- const node = SpreadJsObj.getSelectObject(billsSheet);
- if (node.code && (node.code !== '')) {
- toastr.error('项目节不可含有节点明细');
- posSpreadObj.loadCurPosData();
- return;
- }
- if (node.children && (node.children.length > 0)) {
- toastr.error('仅节点子项可以含有计量单元');
- posSpreadObj.loadCurPosData();
- return;
- }
- if (!info.sheet.zh_setting) {
- posSpreadObj.loadCurPosData();
- return;
- }
- const data = [];
- const sortData = info.sheet.zh_data || [];
- if (sortData.length === 0 || info.cellRange.row + info.cellRange.rowCount > sortData.length) {
- if (info.cellRange.col !== 0) {
- toastr.warning('新增计量单元请先输入名称');
- posSpreadObj.loadCurPosData();
- return;
- }
- }
- const hint = {
- name: {type: 'warning', msg: '计量单元名称不可为空,已过滤'},
- expr: {type: 'warning', msg: '粘贴了表达式非法,已过滤'},
- };
- const lastOrder = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
- let bPaste = true;
- const curRow = info.cellRange.row + iRow;
- const posData = curRow >= sortData.length ? {lid: node.id, porder: lastOrder + curRow - sortData.length} : {id: sortData[curRow].id, lid: node.id};
- for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
- const curCol = info.cellRange.col + iCol;
- const colSetting = info.sheet.zh_setting.cols[curCol];
- if (!colSetting) continue;
-
- posData[colSetting.field] = trimInvalidChar(info.sheet.getText(curRow, curCol));
- if (colSetting.type === 'Number') {
- const num = _.toNumber(posData[colSetting.field]);
- if (num) {
- posData[colSetting.field] = num;
- } else {
- try {
- posData[colSetting.field] = math.evaluate(transExpr(posData[colSetting.field]));
- const exprInfo = getExprInfo(colSetting.field);
- if (exprInfo) {
- posData[exprInfo.expr] = trimInvalidChar(info.sheet.getText(curRow, curCol));
- }
- } catch (err) {
- toastMessageUniq(hint.expr);
- bPaste = false;
- }
- }
- } else if (colSetting.field === 'name') {
- if (!posData[colSetting.field]) {
- toastMessageUniq(hint.name);
- bPaste = false;
- }
- }
- }
- if (bPaste) {
- data.push(posData);
- }
- }
- if (data.length === 0) {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- return;
- }
- postData(window.location.pathname + '/update', {postType: 'pos', posPostType: 'paste', postData: data}, function (result) {
- pos.updateDatas(result.pos);
- posSpreadObj.loadCurPosData();
- const loadResult = billsTree.loadPostData(result.ledger);
- billsTreeSpreadObj.refreshTree(billsSheet, loadResult);
- posSpreadObj.loadCurPosData();
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- });
- },
- selectionChanged: function (e, info) {
- posSpreadObj.loadExprToInput();
- posSpreadObj.refreshOperationValid(posSheet);
- },
- addPegs: function (pegs) {
- if (!pegs || pegs.length <= 0) return;
- const node = SpreadJsObj.getSelectObject(billsSheet);
- if (!node) return;
- const sheet = posSpread.getActiveSheet();
- const sortData = sheet.zh_data || [];
- let order = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
- pegs.forEach(function (p) {p.porder = ++order; p.lid = node.id});
- postData(window.location.pathname + '/update', {postType: 'pos', posPostType: 'paste', postData: pegs}, function (result) {
- pos.updateDatas(result.pos);
- posSpreadObj.loadCurPosData();
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- });
- }
- };
- posSpread.bind(spreadNS.Events.SelectionChanged, posSpreadObj.selectionChanged);
- if (!readOnly && isTz) {
- $('a[name="pos-opr"]').click(function () {
- posSpreadObj.baseOpr(posSheet, this.getAttribute('type'));
- });
- $('#pos-expr').bind('change onblur', function () {
- if (this.readOnly) return;
- const expr = $(this);
- const row = expr.attr('data-row') ? _.toInteger(expr.attr('data-row')) : -1;
- const select = posSheet.zh_data ? posSheet.zh_data[row] : null;
- if (!select) return;
- const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = trimInvalidChar(expr.val());
- if (orgValue === newValue || (!orgValue && newValue == '')) return;
- const data = {id: select.id};
- const exprInfo = getExprInfo(field);
- if (newValue !== '') {
- const num = _.toNumber(newValue);
- if (num) {
- data[field] = num;
- if (exprInfo) data[exprInfo.expr] = '';
- } else {
- try {
- data[field] = math.evaluate(transExpr(newValue));
- if (exprInfo) data[exprInfo.expr] = newValue;
- } catch (err) {
- toastr.error('输入的表达式非法');
- return;
- }
- }
- } else {
- data[field] = null;
- if (exprInfo) data[exprInfo.expr] = '';
- }
- // 更新至服务器
- postData(window.location.pathname + '/update', {postType: 'pos', posPostType: 'update', postData: data}, function (result) {
- const updateRst = pos.updateDatas(result.pos);
- // 刷新当前行, 不适用于新增(在非下一空白行新增)
- SpreadJsObj.reLoadRowData(posSheet, row);
- const loadResult = billsTree.loadPostData(result.ledger);
- billsTreeSpreadObj.refreshTree(billsSheet, loadResult);
- billsTreeSpreadObj.refreshOperationValid(billsSheet);
- });
- });
- posSpread.bind(spreadNS.Events.EditStarting, posSpreadObj.editStarting);
- posSpread.bind(spreadNS.Events.EditEnded, posSpreadObj.editEnded);
- posSpread.bind(spreadNS.Events.ClipboardPasted, posSpreadObj.clipboardPasted);
- SpreadJsObj.addDeleteBind(posSpread, posSpreadObj.deletePress);
- const mergePeg = NewMergePeg({ callback: posSpreadObj.addPegs });
- $.contextMenu({
- selector: '#pos-spread',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, posSpread);
- return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
- },
- items: {
- 'delete': {
- name: '删除',
- icon: 'fa-remove',
- disabled: function (key, opt) {
- if (posSheet.zh_data) {
- const selection = posSheet.getSelections();
- return posSheet.zh_data.length < selection[0].row + selection[0].rowCount;
- } else {
- return true;
- }
- },
- callback: function (key, opt) {
- posSpreadObj.deletePos(posSheet);
- }
- },
- 'merge-peg': {
- name: '合并起讫桩号',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(billsSheet);
- return _.isNil(node) || _.isNil(node.b_code) || node.b_code === '';
- },
- callback: function (key, opt) {
- mergePeg.show();
- },
- visible: function (key, opt) {
- return isTz;
- }
- }
- }
- });
- }
- // 加载清单&计量单元数据
- postData(window.location.pathname + '/load', {}, function (result) {
- billsTree.loadDatas(result.bills);
- treeCalc.calculateAll(billsTree);
- SpreadJsObj.loadSheetData(billsSheet, SpreadJsObj.DataType.Tree, billsTree);
- SpreadJsObj.loadTopAndSelect(billsSheet, ckBillsSpread);
- checkShowLast(result.bills.length);
- pos.loadDatas(result.pos);
- posSpreadObj.loadCurPosData();
- SpreadJsObj.resetTopAndSelect(posSheet);
- checkList.loadHisCheckData();
- }, null);
- $.divResizer({
- select: '#revise-resize',
- callback: function () {
- billsSpread.refresh();
- let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
- $(".sp-wrap").height(bcontent-30);
- posSpread.refresh();
- }
- });
- class DealBills {
- constructor (selector, spreadSetting) {
- const self = this;
- this.loaded = false;
- this.obj = $(selector)[0];
- this.url = '/tender/' + window.location.pathname.split('/')[2] + '/deal';
- this.spreadSetting = spreadSetting;
- this.spread = SpreadJsObj.createNewSpread(this.obj);
- SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
- if (!readOnly) {
- this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
- const dealSheet = info.sheet;
- const mainSheet = billsSheet;
- const dealBills = SpreadJsObj.getSelectObject(dealSheet);
- if (!dealBills) { return; }
- const mainTree = mainSheet.zh_tree;
- const mainNode = SpreadJsObj.getSelectObject(mainSheet);
- if (!mainNode || !mainTree) { return; }
- if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
- toastr.warning('非最底层项目下,不应添加节点');
- return;
- }
- postData(window.location.pathname + '/update', {
- postType: 'add-deal',
- postData: {
- id: mainNode.ledger_id,
- type: mainNode.code ? 'child' : 'next',
- dealBills: {
- b_code: dealBills.code, name: dealBills.name, unit: dealBills.unit,
- unit_price: dealBills.unit_price,
- }
- },
- }, function (result) {
- const refreshData = mainTree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(mainSheet, refreshData);
- const sel = mainSheet.getSelections()[0];
- if (sel && refreshData.create[0]) {
- mainSheet.setSelection(mainTree.nodes.indexOf(refreshData.create[0]), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, mainTree.nodes.indexOf(refreshData.create[0])]);
- }
- billsTreeSpreadObj.refreshOperationValid(mainSheet);
- billsSpread.focus();
- posSpreadObj.loadCurPosData();
- });
- });
- }
- SpreadJsObj.forbiddenSpreadContextMenu(selector, this.spread);
- }
- loadData (callback) {
- if (this.loaded) {
- if (callback) callback();
- return;
- }
- const self = this;
- postData(this.url+'/get-data', {}, function (data) {
- self.data = data;
- SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
- self.loaded = true;
- if (callback) callback();
- });
- }
- calculateData () {
- if (this.data) {
- for (const d of this.data) {
- d.total_price = _.multiply(d.quantity, d.unit_price);
- }
- }
- }
- }
- class BgBills {
- constructor (selector, spreadSetting) {
- this.loaded = false;
- this.obj = $(selector)[0];
- this.spreadSetting = spreadSetting;
- this.spread = SpreadJsObj.createNewSpread(this.obj);
- this.sheet = this.spread.getActiveSheet();
- SpreadJsObj.initSheet(this.sheet, this.spreadSetting);
- if (!readOnly) {
- this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
- const dealSheet = info.sheet;
- const mainSheet = billsSheet;
- const bgBills = SpreadJsObj.getSelectObject(dealSheet);
- if (!bgBills) { return; }
- const mainTree = mainSheet.zh_tree;
- const mainNode = SpreadJsObj.getSelectObject(mainSheet);
- if (!mainNode || !mainTree) { return; }
- if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
- toastr.warning('非最底层项目下,不应添加变更清单');
- return;
- }
- postData(window.location.pathname + '/update', {
- postType: 'add-bg',
- postData: {
- id: mainNode.ledger_id,
- type: mainNode.code ? 'child' : 'next',
- dealBills: {
- b_code: bgBills.code, name: bgBills.name, unit: bgBills.unit,
- unit_price: bgBills.unit_price,
- }
- },
- }, function (result) {
- const refreshData = mainTree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(mainSheet, refreshData);
- const sel = mainSheet.getSelections()[0];
- if (sel && refreshData.create[0]) {
- mainSheet.setSelection(mainTree.nodes.indexOf(refreshData.create[0]), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, mainTree.nodes.indexOf(refreshData.create[0])]);
- }
- billsTreeSpreadObj.refreshOperationValid(mainSheet);
- billsSpread.focus();
- posSpreadObj.loadCurPosData();
- });
- });
- }
- SpreadJsObj.forbiddenSpreadContextMenu(selector, this.spread);
- }
- loadData () {
- if (this.loaded) return;
- const self = this;
- postData('/tender/' + window.location.pathname.split('/')[2] +'/change/bills', {type: 'gather'}, function (data) {
- self.data = data;
- SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
- self.loaded = true;
- });
- }
- }
- class BatchInsertBillsPosObj {
- constructor (obj) {
- const self = this;
- this.obj = obj;
- this.billsCount = 6;
- this.posCount = 1000;
- this.filter = getLocalCache('zh-calc-batch-filter');
- if (!this.filter) {
- this.filter = '1';
- }
- $('input[name=batch-filter]')[0].checked = this.filter && this.filter != '0';
- // 初始化 清单编号窗口 参数
- this.qdSpreadSetting = {
- cols: [
- {title: '编号', field: 'code', hAlign: 0, width: 80, formatter: '@'},
- {title: '名称', field: 'name', hAlign: 0, width: 120, formatter: '@'},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
- {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
- {title: '图册号', field: 'name', hAlign: 0, width: 60, formatter: '@'},
- ],
- emptyRows: this.billsCount,
- headRows: 1,
- headRowHeight: [32],
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- };
- this.qdSpread = SpreadJsObj.createNewSpread($('.batch-l-t', this.obj)[0]);
- // 初始化 部位数量复核表 参数
- this.posSpreadSetting = {
- cols: [
- {title: '名称', field: 'bw', hAlign: 0, width: 80, formatter: '@'},
- {title: '图册号', field: 'drawingCode', hAlign: 0, formatter: '@', width: 60},
- ],
- emptyRows: this.posCount,
- headRows: 1,
- headRowHeight: [32],
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- };
- for (let iNum = 1; iNum <= this.billsCount; iNum++) {
- this.posSpreadSetting.cols.push(
- {title: '清单' + iNum, field: 'bills' + iNum, hAlign: 2, width: 50}
- )
- }
- this.posSpread = SpreadJsObj.createNewSpread($('.batch-l-b', this.obj)[0]);
- // 初始化 签约节点 参数
- this.dealSpreadSetting = {
- cols: [
- {title: '清单编号', field: 'code', width: 80, hAlign: 0, formatter: '@', readOnly: true},
- {title: '名称', field: 'name', width: 230, hAlign: 0, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
- {title: '单价', field: 'unit_price', hAlign: 2, width: 60, readOnly: true},
- ],
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- };
- this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r', this.obj)[0]);
- // 初始化 清单编号、部位数量复核表 表格
- this.initView();
- SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting);
- SpreadJsObj.refreshColumnAlign(this.dealSpread.getActiveSheet());
- // 拉取签约节点数据
- dealBills.loadData(() => {
- SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
- });
- // 双击签约节点,自动添加到清单编号窗口
- this.dealSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
- const deal = info.sheet.zh_data[info.row];
- const qdSheet = self.qdSpread.getActiveSheet(), posSheet = self.posSpread.getActiveSheet();
- const sel = qdSheet.getSelections()[0];
- qdSheet.getCell(sel.row, 0).value(deal.code);
- qdSheet.getCell(sel.row, 1).value(deal.name);
- qdSheet.getCell(sel.row, 2).value(deal.unit);
- qdSheet.getCell(sel.row, 3).value(deal.unit_price);
- if (sel.row + 1 === qdSheet.getRowCount()) {
- const count = sel.row + 2;
- qdSheet.setRowCount(count);
- qdSheet.getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count);
- const colCount = posSheet.getColumnCount() + 1;
- posSheet.setColumnCount(colCount);
- posSheet.getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('清单' + count);
- }
- qdSheet.setSelection(sel.row + 1, sel.col, 1, 1);
- qdSheet.getParent().focus();
- });
- this.qdSpread.bind(spreadNS.Events.ClipboardPasted, function (e, info) {
- const billsCount = info.sheet.getRowCount(), posSheet = self.posSpread.getActiveSheet();
- const count = posSheet.getColumnCount() - 2;
- if (billsCount > count) {
- posSheet.setColumnCount(billsCount + 2);
- for (let i = count + 1; i <= billsCount; i++) {
- info.sheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i);
- posSheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i);
- }
- }
- if (info.cellRange.col === 0 && info.cellRange.colCount === 1) {
- const dealBills = self.dealSpread.getActiveSheet().zh_data;
- if (dealBills && dealBills.length > 0) {
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
- const curRow = iRow + info.cellRange.row;
- const bills = _.find(dealBills, {code: info.sheet.getText(curRow, 0)});
- if (bills) {
- info.sheet.getCell(curRow, 1).value(bills.name);
- info.sheet.getCell(curRow, 2).value(bills.unit);
- info.sheet.getCell(curRow, 3).value(bills.unit_price);
- }
- }
- }
- }
- });
- this.posSpread.bind(spreadNS.Events.ClipboardPasted, function (e, info) {
- const billsCount = info.sheet.getColumnCount() - 2, qdSheet = self.qdSpread.getActiveSheet();
- const count = qdSheet.getRowCount();
- if (billsCount > count) {
- qdSheet.setRowCount(billsCount);
- for (let i = count + 1; i <= billsCount; i++) {
- qdSheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i);
- info.sheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i);
- }
- }
- });
- this.qdSpread.bind(spreadNS.Events.EditEnded, function (e, info) {
- if (info.col === 0) {
- const dealBills = self.dealSpread.getActiveSheet().zh_data;
- if (dealBills && dealBills.length > 0) {
- const bills = _.find(dealBills, {code: info.editingText});
- if (bills) {
- info.sheet.getCell(info.row, 1).value(bills.name);
- info.sheet.getCell(info.row, 2).value(bills.unit);
- info.sheet.getCell(info.row, 3).value(bills.unit_price);
- }
- }
- }
- });
- this.obj.bind('shown.bs.modal', function () {
- self.qdSpread.refresh();
- self.posSpread.refresh();
- self.dealSpread.refresh();
- });
- $('#batch-ok').click(function () {
- const selection = billsSheet.getSelections();
- const sel = selection[0];
- const row = selection[0].row;
- const select = billsTree.nodes[row];
- if (select) {
- const insertData = {};
- insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next';
- insertData.id = select[billsTree.setting.id];
- insertData.batchData = self.getBatchData();
- if (insertData.batchData.length > 0) {
- postData(window.location.pathname + '/update', {
- postType: 'batch-insert',
- postData: insertData
- }, function (data) {
- pos.updateDatas(data.pos);
- const result = billsTree.loadPostData(data.ledger);
- billsTreeSpreadObj.refreshTree(billsSheet, result);
- billsSheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(billsSheet, [sel.row, result.create[0].index]);
- billsTreeSpreadObj.refreshOperationValid(billsSheet, selection);
- posSpreadObj.loadCurPosData();
- self.obj.modal('hide');
- }, null, true);
- } else {
- self.obj.modal('hide');
- }
- }
- });
- $('input[name=batch-filter]').change(function () {
- setLocalCache('zh-calc-batch-filter', this.checked ? 1 : 0);
- });
- $.contextMenu({
- selector: '.batch-l-t',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, self.qdSpread);
- return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
- },
- items: {
- 'create': {
- name: '新增行',
- icon: 'fa-sign-in',
- callback: function (key, opt) {
- const qdSheet = self.qdSpread.getActiveSheet();
- const posSheet = self.posSpread.getActiveSheet();
- qdSheet.addRows(qdSheet.getRowCount(), 1);
- const index = qdSheet.getRowCount();
- qdSheet.getCell(qdSheet.getRowCount() - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + index);
- posSheet.addColumns(posSheet.getColumnCount(), 1);
- posSheet.getCell(0, index + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + index);
- },
- },
- 'delete': {
- name: '删除行',
- icon: 'fa-remove',
- callback: function (key, opt) {
- const qdSheet = self.qdSpread.getActiveSheet();
- const posSheet = self.posSpread.getActiveSheet();
- const sel = qdSheet.getSelections()[0];
- qdSheet.deleteRows(sel.row, sel.rowCount);
- posSheet.deleteColumns(sel.row + 2, sel.rowCount);
- for (let iRow = 0, iLen = qdSheet.getRowCount(); iRow < iLen; iRow++) {
- qdSheet.getCell(iRow, 0, spreadNS.SheetArea.rowHeader).text('清单' + (iRow+1));
- }
- for (let iCol = 0, iLen = posSheet.getColumnCount() - 2; iCol < iLen; iCol++) {
- posSheet.getCell(0, iCol + 2, spreadNS.SheetArea.colHeader).text('清单' + (iCol+1));
- }
- qdSheet.setSelection(sel.row, sel.col, 1, 1);
- },
- },
- }
- });
- }
- // 初始化左侧表格
- initView () {
- // 初始化 清单编号
- const qdSheet = this.qdSpread.getActiveSheet();
- SpreadJsObj.initSheet(qdSheet, this.qdSpreadSetting);
- SpreadJsObj.refreshColumnAlign(qdSheet);
- // 清理原有数据
- SpreadJsObj.beginMassOperation(qdSheet);
- qdSheet.clear(0, 0, qdSheet.getRowCount(), qdSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
- for (let iRow = 1; iRow <= this.billsCount; iRow++) {
- qdSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow);
- }
- qdSheet.setSelection(0, 0, 1 ,1);
- SpreadJsObj.endMassOperation(qdSheet);
- // 初始化 部位数量复核表
- const posSheet = this.posSpread.getActiveSheet();
- SpreadJsObj.initSheet(posSheet, this.posSpreadSetting);
- SpreadJsObj.refreshColumnAlign(posSheet);
- // 清理原有数据
- SpreadJsObj.beginMassOperation(posSheet);
- posSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader);
- posSheet.clear(0, 0, posSheet.getRowCount(), posSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
- posSheet.setSelection(0, 0, 1 ,1);
- SpreadJsObj.endMassOperation(posSheet);
- // 检查签约节点数据,以工具栏数据为准
- if (dealBills) {
- SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
- }
- this.dealSpread.getActiveSheet().setSelection(0, 0, 1, 1);
- }
- // 获取界面数据
- getBatchData () {
- const result = [];
- const qdSheet = this.qdSpread.getActiveSheet(), posSheet = this.posSpread.getActiveSheet();
- for (let iRow = 0; iRow < qdSheet.getRowCount(); iRow++) {
- if (qdSheet.getText(iRow, 0) === '') { continue; }
- const qd = {
- b_code: qdSheet.getText(iRow, 0),
- name: qdSheet.getText(iRow, 1),
- unit: qdSheet.getText(iRow, 2),
- price: _.toNumber(qdSheet.getText(iRow, 3)),
- pos: [],
- };
- for (let iPosRow = 0; iPosRow < posSheet.getRowCount(); iPosRow++) {
- const value = _.toNumber(posSheet.getText(iPosRow, iRow + 2));
- if (value !== 0 && !isNaN(value)) {
- qd.pos.push({
- name: posSheet.getText(iPosRow, 0),
- drawing_code: posSheet.getText(iPosRow, 1),
- quantity: value, porder: qd.pos.length + 1,
- });
- }
- }
- if (!$('input[name=batch-filter]')[0].checked || qd.pos.length > 0) result.push(qd);
- }
- return result;
- }
- }
- const dealBills = new DealBills('#deal-bills-spread', {
- cols: [
- {title: '清单编号', field: 'code', hAlign: 0, width: 85, formatter: '@', readOnly: true},
- {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
- {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
- {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
- {title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true},
- ],
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- headColWidth: [30],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- selectedBackColor: '#fffacd',
- });
- const bgBills = new BgBills('#bg-bills-spread', {
- cols: [
- {title: '清单编号', field: 'code', hAlign: 0, width: 85, formatter: '@', readOnly: true},
- {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
- {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
- {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
- {title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true},
- ],
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- headColWidth: [30],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- selectedBackColor: '#fffacd',
- });
- $.divResizer({
- select: '#revise-right-spr',
- callback: function () {
- billsSpread.refresh();
- if (posSpread) posSpread.refresh();
- if (stdXmj) stdXmj.spread.refresh();
- if (stdGcl) stdGcl.spread.refresh();
- if (dealBills) dealBills.spread.refresh();
- if (bgBills) bgBills.spread.refresh();
- if (searchLedger) searchLedger.spread.refresh();
- if (errorList) errorList.spread.refresh();
- if (checkList) checkList.spread.refresh();
- if (sumLoadMiss) sumLoadMiss.spread.refresh();
- }
- });
- $.subMenu({
- menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
- toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
- key: 'menu.1.0.0',
- miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
- callback: function (info) {
- if (info.mini) {
- $('.panel-title').addClass('fluid');
- $('#sub-menu').removeClass('panel-sidebar');
- } else {
- $('.panel-title').removeClass('fluid');
- $('#sub-menu').addClass('panel-sidebar');
- }
- autoFlashHeight();
- billsSpread.refresh();
- if (posSpread) posSpread.refresh();
- if (stdXmj) stdXmj.spread.refresh();
- if (stdGcl) stdGcl.spread.refresh();
- if (dealBills) dealBills.spread.refresh();
- if (bgBills) bgBills.spread.refresh();
- if (searchLedger) searchLedger.spread.refresh();
- if (errorList) errorList.spread.refresh();
- if (checkList) checkList.spread.refresh();
- if (sumLoadMiss) sumLoadMiss.spread.refresh();
- }
- });
- $('#content-tab').addClass('active');
- $('#xd-content').addClass('active');
- showSideTools(true);
- billsSpread.refresh();
- if (posSpread) posSpread.refresh();
- const stdLibCellDoubleClick = function (e, info) {
- const stdSheet = info.sheet;
- const mainSheet = billsSheet;
- if (!stdSheet.zh_setting || !stdSheet.zh_tree || !mainSheet.zh_tree) { return; }
- const stdTree = stdSheet.zh_tree;
- const stdNode = stdTree.nodes[info.row];
- const mainTree = mainSheet.zh_tree;
- const sel = mainSheet.getSelections()[0];
- const mainNode = mainTree.nodes[sel.row];
- if (!stdNode) return;
- if (info.sheet.zh_setting.stdType === 'gcl') {
- if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
- toastr.warning('非最底层项目下,不应添加节点');
- return;
- }
- }
- postData(window.location.pathname + '/update', {
- postType: 'add-std',
- postData: {
- id: mainTree.getNodeKey(mainNode),
- tender_id: mainNode.tender_id,
- stdType: info.sheet.zh_setting.stdType,
- stdLibId: stdNode.list_id,
- stdNode: stdTree.getNodeKey(stdNode)
- }
- }, function (result) {
- const refreshNode = mainTree.loadPostData(result);
- billsTreeSpreadObj.refreshTree(mainSheet, refreshNode);
- if (sel) {
- if (refreshNode.create && refreshNode.create.length > 0) {
- mainSheet.setSelection(refreshNode.create[refreshNode.create.length - 1].index, sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, refreshNode.create[refreshNode.create.length - 1].index]);
- } else {
- const node = _.find(mainTree.nodes, {code: stdNode.code, name: stdNode.name});
- if (node) {
- mainSheet.setSelection(mainTree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, mainTree.nodes.indexOf(node)]);
- }
- }
- }
- billsTreeSpreadObj.refreshOperationValid(mainSheet);
- billsSpread.focus();
- posSpreadObj.loadCurPosData();
- });
- };
- const stdXmjSetting = {
- selector: '#std-xmj',
- stdType: 'xmj',
- treeSetting: {
- id: 'chapter_id',
- pid: 'pid',
- order: 'order',
- level: 'level',
- rootId: -1,
- keys: ['id', 'list_id', 'chapter_id'],
- },
- spreadSetting: {
- cols: [
- {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
- {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
- ],
- treeCol: 0,
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- headColWidth: [30],
- selectedBackColor: '#fffacd',
- },
- cellDoubleClick: stdLibCellDoubleClick,
- page: 'revise',
- tid: window.location.pathname.split('/')[2],
- };
- const stdGclSetting = {
- selector: '#std-gcl',
- stdType: 'gcl',
- treeSetting: {
- id: 'bill_id',
- pid: 'pid',
- order: 'order',
- level: 'level',
- rootId: -1,
- keys: ['id', 'list_id', 'bill_id']
- },
- spreadSetting: {
- cols: [
- {title: '清单编号', field: 'b_code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
- {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
- ],
- treeCol: 0,
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- headColWidth: [30],
- selectedBackColor: '#fffacd',
- },
- cellDoubleClick: stdLibCellDoubleClick,
- page: 'revise',
- tid: window.location.pathname.split('/')[2],
- };
- // 展开收起标准节点
- $('a', '#side-menu').bind('click', function (e) {
- e.preventDefault();
- const tab = $(this), tabPanel = $(tab.attr('content'));
- // 展开工具栏、切换标签
- if (!tab.hasClass('active')) {
- const close = $('.active', '#side-menu').length === 0;
- $('a', '#side-menu').removeClass('active');
- tab.addClass('active');
- $('.tab-content .tab-pane').removeClass('active');
- tabPanel.addClass('active');
- showSideTools(tab.hasClass('active'));
- if (tab.attr('content') === '#std-xmj') {
- if (!stdXmj) {
- stdXmj = new stdLib(stdXmjSetting);
- }
- stdXmj.spread.refresh();
- } else if (tab.attr('content') === '#std-gcl') {
- if (!stdGcl) {
- stdGcl = new stdLib(stdGclSetting);
- }
- stdGcl.spread.refresh();
- } else if (tab.attr('content') === '#deal-bills') {
- dealBills.loadData();
- dealBills.spread.refresh();
- } else if (tab.attr('content') === '#bg-bills') {
- bgBills.loadData();
- bgBills.spread.refresh();
- } else if (tab.attr('content') === '#search') {
- if (!searchLedger) {
- searchLedger = $.billsSearch({
- selector: '#search',
- searchSpread: billsSpread,
- resultSpreadSetting: {
- cols: [
- {title: '项目节编号', field: 'code', hAlign: 0, width: 90, formatter: '@', readOnly: true},
- {title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@', readOnly: true},
- {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@', readOnly: true},
- {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
- {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
- ],
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- headColWidth: [30],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- selectedBackColor: '#fffacd',
- },
- afterLocated: function () {
- posSpreadObj.loadCurPosData();
- }
- });
- }
- searchLedger.spread.refresh();
- } else if (tab.attr('content') === '#error-list') {
- errorList.spread.refresh();
- } else if (tab.attr('content') === '#check-list') {
- checkList.spread.refresh();
- } else if (tab.attr('content') === '#sum-load-miss') {
- sumLoadMiss.spread.refresh();
- }
- }
- else {// 收起工具栏
- tab.removeClass('active');
- tabPanel.removeClass('active');
- showSideTools(tab.hasClass('active'));
- }
- billsSpread.refresh();
- if (posSpread) posSpread.refresh();
- });
- if (!readOnly) {
- // 修订详情 保存
- $('#save').click(function () {
- const content = $('#content').val();
- postData('save', { content: content }, function () {
- $('#content').attr('org-value', content);
- });
- });
- }
- // 显示层次
- (function (select, sheet) {
- $(select).click(function () {
- if (!sheet.zh_tree) return;
- const tag = $(this).attr('tag');
- const tree = sheet.zh_tree;
- setTimeout(() => {
- showWaitingView();
- switch (tag) {
- case "1":
- case "2":
- case "3":
- case "4":
- case "5":
- tree.expandByLevel(parseInt(tag));
- SpreadJsObj.refreshTreeRowVisible(sheet);
- break;
- case "last":
- tree.expandByCustom(() => { return true; });
- SpreadJsObj.refreshTreeRowVisible(sheet);
- break;
- case "leafXmj":
- tree.expandToLeafXmj();
- SpreadJsObj.refreshTreeRowVisible(sheet);
- break;
- }
- closeWaitingView();
- }, 100);
- });
- })('a[name=showLevel]', billsSheet);
- const dataChecker = DataChecker({
- checkUrl: window.location.pathname + '/check',
- completeData: function (data) {
- pos.updateDatas({update: data.source.pos});
- const loadResult = billsTree.loadPostData({update: data.source.bills});
- billsTreeSpreadObj.refreshTree(billsSheet, loadResult);
- posSpreadObj.loadCurPosData();
- for (const e of data.error) {
- e.serialNo = billsTree.getNodeIndex(billsTree.getItems(e.ledger_id)) + 1;
- }
- },
- errorList: errorList,
- });
- $('#ledger-check2').click(() => {
- const result = ledgerCheck2({
- ledgerTree: billsTree,
- ledgerPos: pos,
- checkList: checkList,
- decimal: decimal,
- checkOption: checkOption,
- });
- check2Viewing({
- extra: ZhCalc.div(billsTree.datas.length + pos.datas.length, 10000, 0),
- randomWait: true,
- prefix: 'check2-',
- checks: result,
- checkList: checkList,
- })
- });
- $('[name=revise-start]').submit(function (e) {
- if (checkAuditorFrom()) {
- $(this).parent().parent().parent().modal('hide');
- dataChecker.checkAndPost(this.action, {});
- $('#hide-all').hide();
- }
- return false;
- });
- });
|