123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304 |
- /**
- * 台账相关js
- *
- * @author Mai
- * @date 2018/02/05
- * @version
- */
- const ckBillsSpread = window.location.pathname + '-billsSelect';
- function checkTzMeasureType () {
- return tender.measure_type === measureType.tz.value;
- }
- function getTenderId() {
- return window.location.pathname.split('/')[2];
- }
- const copyBlockTag = 'zh.calc.copyBlock';
- 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'],
- };
- function transExpr(expr) {
- return expr.replace('=', '').replace('%', '/100');
- }
- $(document).ready(function() {
- let stdXmj, stdGcl, dealBills, searchLedger;
- autoFlashHeight();
- // 初始化台账
- const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]);
- SpreadJsObj.addDeleteBind(ledgerSpread);
- const treeSetting = {
- id: 'ledger_id',
- pid: 'ledger_pid',
- order: 'order',
- level: 'level',
- rootId: -1,
- keys: ['id', 'tender_id', 'ledger_id'],
- preUrl: '/tender/' + getTenderId() + '/ledger',
- };
- if (checkTzMeasureType()) {
- treeSetting.calcFields = ['sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'];
- } else {
- treeSetting.calcFields = ['deal_tp', 'sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'];
- }
- treeSetting.calcFun = function (node) {
- node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), 2);
- };
- const ledgerTree = createNewPathTree('ledger', treeSetting);
- // 初始化 计量单元
- const pos = new PosData({
- id: 'id', ledgerId: 'lid',
- });
- const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]);
- $.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();
- ledgerSpread.refresh();
- if (posSpread) {
- posSpread.refresh();
- }
- if (stdXmj) {
- stdXmj.spread.refresh();
- }
- if (stdGcl) {
- stdGcl.spread.refresh();
- }
- if (dealBills) {
- dealBills.spread.refresh();
- }
- if (searchLedger) {
- searchLedger.spread.refresh();
- }
- }
- });
- // 定义事件
- const treeOperationObj = {
- 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) {
- $('#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 {
- $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (data.children && data.children.length > 0));
- }
- } else {
- $('#bills-expr').val('').attr('readOnly', true);
- }
- } else {
- $('#bills-expr').val('').attr('readOnly', true);
- }
- },
- getSelectNode: function (sheet) {
- if (!sheet || !sheet.zh_tree) {
- return null;
- } else {
- const sel = sheet.getSelections()[0];
- return sheet.zh_tree.nodes[sel.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.error('请选择同一清单下的节点,进行该操作');
- 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($('#insert'), false);
- setObjEnable($('#delete'), false);
- setObjEnable($('#up-move'), false);
- setObjEnable($('#down-move'), false);
- setObjEnable($('#up-level'), false);
- setObjEnable($('#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;
- if (sel.rowCount > 1 && first) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[row + r];
- if (!rNode) {
- sameParent = false;
- break;
- }
- 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($('#insert'), valid && first && first.level > 1);
- setObjEnable($('#delete'), valid && first && sameParent && !(first.level === 1 && first.node_type));
- setObjEnable($('#up-move'), valid && first && sameParent && first.level > 1 && preNode);
- setObjEnable($('#down-move'), valid && first && sameParent && first.level > 1 && !tree.isLastSibling(last));
- if (checkTzMeasureType()) {
- const posRange = last ? pos.getLedgerPos(last.id) : [];
- setObjEnable($('#up-level'), valid && first && sameParent && tree.getParent(first) && first.level > 2 && ((!posRange || posRange.length === 0) || tree.isLastSibling(last)));
- const preNodePosRange = preNode ? pos.getLedgerPos(preNode.id) : [];
- setObjEnable($('#down-level'), valid && first && sameParent && first.level > 1 && preNode && (!preNodePosRange || preNodePosRange.length === 0));
- } else {
- setObjEnable($('#up-level'), valid && first && sameParent && first.level > 2 && tree.getParent(first));
- setObjEnable($('#down-level'), valid && first && sameParent && first.level > 1 && preNode);
- }
- setObjEnable($('#cut'), valid);
- setObjEnable($('#paste'), valid);
- },
- refreshTree: function (sheet, data) {
- SpreadJsObj.massOperationSheet(sheet, function () {
- const tree = sheet.zh_tree;
- // 处理删除
- if (data.delete) {
- data.delete.sort(function (x, y) {
- return y.deleteIndex - x.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);
- }
- }
- }
- }
- });
- },
- /**
- * 新增节点
- * @param spread
- */
- addNode: function (sheet, count = 1) {
- const self = this;
- const sel = sheet.getSelections()[0];
- const row = sheet.getSelections()[0].row;
- const tree = sheet.zh_tree;
- if (!tree) { return; }
- const node = sheet.zh_tree.nodes[row];
- if (!node) { return; }
- postData(window.location.pathname + '/update', {
- postType: 'add',
- postData: {
- id: tree.getNodeKey(node),
- count: count,
- }
- }, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- sheet.setSelection(refreshNode.create[0].index, sel.col, sel.rowCount, sel.colCount);
- self.refreshOperationValid(sheet);
- });
- },
- /**
- * 删除选中节点
- * @param spread
- */
- deleteNode: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'delete',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- for (const d of refreshNode.delete) pos.removeDatasByMasterId(d.id);
- self.refreshTree(sheet, refreshNode);
- self.refreshOperationValid(sheet);
- posOperationObj.loadCurPosData();
- });
- }
- },
- /**
- * 上移选中节点
- * @param spread
- */
- upMove: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'up-move',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- const sel = sheet.getSelections()[0];
- sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
- self.refreshOperationValid(sheet);
- });
- }
- },
- /**
- * 下移选中节点
- * @param spread
- */
- downMove: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'down-move',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- const sel = sheet.getSelections()[0];
- sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
- self.refreshOperationValid(sheet);
- });
- }
- },
- /**
- * 升级选中节点
- * @param spread
- */
- upLevel: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'up-level',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- self.refreshOperationValid(sheet);
- });
- }
- },
- /**
- * 降级选中节点
- * @param spread
- */
- downLevel: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'down-level',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- 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 (checkTzMeasureType()) {
- 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' && (info.editingText === '' || !info.editingText)) {
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- toastr.error('清单含有计量单元,请先删除计量单元,再删除清单编号');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- }
- // 获取更新数据
- if (col.type === 'Number') {
- if (newValue) {
- const num = _.toNumber(newValue);
- if (_.isFinite(num)) {
- data[col.field] = num;
- } else {
- try {
- data[col.field] = math.evaluate(transExpr(newValue));
- } catch(err) {
- toastr.error('输入的表达式非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- } else {
- data[col.field] = null;
- }
- } else {
- data[col.field] = newValue;
- }
- // 更新至服务器
- postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
- const refreshNode = ledgerTree.loadPostData(result);
- treeOperationObj.refreshTree(info.sheet, refreshNode);
- });
- }
- },
- /**
- * 粘贴单元格响应事件
- * @param e
- * @param info
- */
- clipboardPasted: function (e, info) {
- if (info.sheet.zh_setting && info.sheet.zh_dataType === 'tree') {
- const tree = info.sheet.zh_tree;
- if (!tree) { return; }
- const sortData = info.sheet.zh_tree.nodes;
- const datas = [], filterNodes = [];
- let bHint = false, bPaste;
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
- 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') {
- if (!bHint) {
- toastr.warning('清单含有计量单元,请先删除计量单元,再删除清单编号');
- bHint = true;
- }
- 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') {
- if (!bHint) {
- toastr.warning('清单含有计量单元,数量金额根据计量单元汇总计算所得,不可编辑');
- bHint = true;
- }
- continue;
- }
- }
- if (colSetting.type === 'Number') {
- const num = _.toNumber(value);
- if (num) {
- data[colSetting.field] = num;
- bPaste = true;
- } else {
- try {
- data[colSetting.field] = math.evaluate(transExpr(value));
- bPaste = true;
- } catch(err) {
- delete data[colSetting.field];
- if (!bHint) {
- toastr.warning('输入的表达式非法');
- bHint = true;
- }
- }
- }
- } else {
- 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);
- }
- treeOperationObj.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);
- }
- }
- },
- clipboardPasting: function (e, info) {
- const tree = info.sheet.zh_tree, setting = info.sheet.zh_setting;
- info.cancel = true;
- if (!setting || !tree) return;
- const pasteData = info.pasteData.html
- ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
- : (info.pasteData.text === ''
- ? SpreadJsObj.Clipboard.getAnalysisPasteText()
- : SpreadJsObj.analysisPasteText(info.pasteData.text));
- let bParentHint = false, bGclHint = false, bCodeHint = false, bQtyHint = false, bNumHint = false;
- const datas = [], filterNodes = [];
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
- const curRow = info.cellRange.row + iRow;
- const node = tree.nodes[curRow];
- if (!node) continue;
- 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][iCol]);
- const lPos = pos.getLedgerPos(node.id);
- if (node.children && node.children.length > 0 && invalidFields.parent.indexOf(colSetting.field) >= 0) {
- if (!bParentHint) bParentHint = true;
- continue;
- }
- if (!_.isEmpty(node.b_code) && invalidFields.gcl.indexOf(colSetting.field) >= 0) {
- if (!bGclHint) bGclHint = true;
- continue;
- }
- if (lPos && lPos.length > 0) {
- if (value === '' && invalidFields.posCode.indexOf(colSetting.field) >= 0) {
- if (!bCodeHint) bCodeHint = true;
- continue;
- }
- if (invalidFields.posCalc.indexOf(colSetting.field) >= 0) {
- if (!bQtyHint) bQtyHint = true;
- continue;
- }
- }
- if (colSetting.type === 'Number') {
- const num = _.toNumber(value);
- if (num) {
- data[colSetting.field] = num;
- bPaste = true;
- } else {
- try {
- data[colSetting.field] = math.evaluate(transExpr(value));
- } catch(err) {
- bNumHint = true;
- }
- }
- } else {
- data[colSetting.field] = value;
- bPaste = true;
- }
- }
- if (bPaste) {
- datas.push(data);
- } else {
- filterNodes.push(node);
- }
- }
- const hint = [];
- if (bParentHint) hint.push('含有子项的清单,不可粘贴数量、单价、金额');
- if (bGclHint) hint.push('工程量清单,不可粘贴项目节数量');
- if (bQtyHint) hint.push('含有计量单元的清单,不可粘贴数量');
- if (bCodeHint) hint.push('含有计量单元的清单,清单编号不可粘贴空值');
- if (bNumHint) hint.push('单价、数量等应输入数字或可计算的表达式');
- // if (hint.length > 0) hint.unshift('复制粘贴的数据中,存在非法数据,已过滤:');
- // if (hint.length > 0) toastr.warning(hint.join('</br>'));
- if (hint.length > 0) toastr.warning('复制粘贴的数据中,存在非法数据,已过滤');
- 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);
- }
- treeOperationObj.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);
- }
- },
- /**
- * 删除按钮响应事件
- * @param sheet
- */
- deletePress: function (sheet) {
- if (sheet.zh_setting && sheet.zh_dataType === 'tree') {
- const tree = sheet.zh_tree;
- if (!tree) { return; }
- const sortData = sheet.zh_tree.nodes;
- const datas = [], nodes = [];
- const sel = sheet.getSelections()[0];
- let bHint = false;
- for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
- const node = sortData[iRow];
- if (node) {
- let bDel = false;
- 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) {
- if (!bHint) {
- if (col.field === 'code') {
- toastr.warning('清单含有计量单元,请先删除计量单元,再删除清单编号');
- } else {
- toastr.warning('清单含有计量单元,数量金额根据计量单元汇总计算所得,不可删除');
- }
- bHint = true;
- }
- continue;
- }
- }
- const style = sheet.getStyle(iRow, iCol);
- if (!style.locked) {
- const colSetting = sheet.zh_setting.cols[iCol];
- data[colSetting.field] = null;
- bDel = true;
- }
- }
- if (bDel) {
- datas.push(data);
- nodes.push(node);
- }
- }
- }
- if (datas.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = tree.loadPostData(result);
- treeOperationObj.refreshTree(sheet, refreshNode);
- });
- }
- }
- },
- /**
- * 粘贴整块
- * @param spread
- * @param block
- */
- pasteBlock: function (spread, copyInfo) {
- const self = this;
- const sheet = spread.getActiveSheet();
- const sel = sheet.getSelections()[0];
- const row = sel.row;
- const tree = sheet.zh_tree;
- if (!tree) { return; }
- const node = tree.nodes[row];
- if (!node) { return; }
- 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);
- sheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
- self.refreshOperationValid(sheet);
- removeLocalCache(copyBlockTag);
- }, null, true);
- },
- selectionChanged: function (e, info) {
- if (!info.oldSelections[0] || info.newSelections[0].row !== info.oldSelections[0].row) {
- posOperationObj.loadCurPosData();
- SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
- posSearch.search($('#pos-keyword').val());
- }
- SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
- treeOperationObj.loadExprToInput(info.sheet);
- },
- topRowChanged(e, info) {
- SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
- },
- 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;
- }
- 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);
- treeOperationObj.refreshTree(sheet, refreshNode);
- });
- }
- },
- 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];
- switch (col.field) {
- case 'unit_price':
- 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;
- }
- }
- };
- ledgerTreeCol.initSpreadSetting(ledgerSpreadSetting);
- SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);
- // 绑定事件
- ledgerSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, treeOperationObj.selectionChanged);
- ledgerSpread.bind(spreadNS.Events.TopRowChanged, treeOperationObj.topRowChanged);
- if (!ledgerSpreadSetting.readOnly) {
- ledgerSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, function (e, info) {
- treeOperationObj.refreshOperationValid(info.sheet, info.newSelections);
- });
- ledgerSpread.bind(GC.Spread.Sheets.Events.EditEnded, treeOperationObj.editEnded);
- //ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardPasted, treeOperationObj.clipboardPasted);
- SpreadJsObj.addDeleteBind(ledgerSpread, treeOperationObj.deletePress);
- ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardChanging, function (e, info) {
- const copyText = SpreadJsObj.getFilterCopyText(info.sheet);
- //console.log(info.copyData);
- SpreadJsObj.Clipboard.setCopyData(copyText);
- //copyToClipboard(copyText);
- });
- ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardPasting, treeOperationObj.clipboardPasting);
- ledgerSpread.bind(spreadNS.Events.EditStarting, treeOperationObj.editStarting);
- SpreadJsObj.addCutEvents(ledgerSpread, treeOperationObj.cut);
- // 绑定 删除等 顶部按钮
- $('#insert').click(() => {
- treeOperationObj.addNode(ledgerSpread.getActiveSheet());
- });
- $('#delete').click(function () {
- treeOperationObj.deleteNode(ledgerSpread.getActiveSheet());
- });
- $('#up-move').click(function () {
- treeOperationObj.upMove(ledgerSpread.getActiveSheet());
- });
- $('#down-move').click(function () {
- treeOperationObj.downMove(ledgerSpread.getActiveSheet());
- });
- $('#up-level').click(function () {
- treeOperationObj.upLevel(ledgerSpread.getActiveSheet());
- });
- $('#down-level').click(function () {
- treeOperationObj.downLevel(ledgerSpread.getActiveSheet());
- });
- $('#copy').click(function () {
- ledgerSpread.commandManager().execute({
- cmd: 'copy',
- sheetName: ledgerSpread.getActiveSheet().name()
- });
- });
- $('#paste').click(function () {
- ledgerSpread.commandManager().execute({
- cmd: 'paste',
- sheetName: ledgerSpread.getActiveSheet().name()
- });
- });
- $('#cut').click(function () {
- ledgerSpread.commandManager().execute({
- cmd: 'cut',
- sheetName: ledgerSpread.getActiveSheet().name()
- });
- });
- $('#bills-expr').bind('change mouseleave', function () {
- const expr = $(this);
- const sheet = ledgerSpread.getActiveSheet();
- const select = SpreadJsObj.getSelectObject(sheet);
- 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
- };
- if (newValue !== '') {
- const num = _.toNumber(newValue);
- if (num) {
- data[field] = num;
- } else {
- try {
- data[field] = math.evaluate(transExpr(newValue));
- } catch (err) {
- toastr.error('输入的表达式非法');
- return;
- }
- }
- } else {
- data[field] = null;
- }
- // 更新至服务器
- postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
- const refreshNode = ledgerTree.loadPostData(result);
- expr.val(select[field]);
- treeOperationObj.refreshTree(sheet, refreshNode);
- });
- });
- 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, '');});
- };
- // 右键菜单
- $.contextMenu({
- selector: '#ledger-spread',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, ledgerSpread);
- return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
- },
- items: {
- 'create': {
- name: '新增',
- icon: 'fa-sign-in',
- callback: function (key, opt) {
- treeOperationObj.addNode(ledgerSpread.getActiveSheet());
- },
- disabled: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- 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;
- if (sel.rowCount > 1) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[sel.row + r];
- 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 && first.level > 1);
- }
- },
- 'delete': {
- name: '删除',
- icon: 'fa-remove',
- callback: function (key, opt) {
- treeOperationObj.deleteNode(ledgerSpread.getActiveSheet());
- },
- disabled: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- 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;
- if (sel.rowCount > 1) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[sel.row + r];
- 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));
- }
- },
- 'sprBase': '-----------',
- 'copyBlock': {
- name: '复制整块',
- icon: 'fa-files-o',
- callback: function (key, opt) {
- /*ledgerSpread.commandManager().execute({
- cmd:"copy",
- sheetName:ledgerSpread.getActiveSheet().name()
- });*/
- treeOperationObj.block = [];
- const copyBlockList = [];
- const sheet = ledgerSpread.getActiveSheet();
- 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;
- }
- copyBlockList.push(node.ledger_id);
- iRow += sheet.zh_tree.getPosterity(node).length + 1;
- }
- const tenderId = _.toInteger(getTenderId());
- setLocalCache(copyBlockTag, JSON.stringify({tid: tenderId, block: copyBlockList}));
- //treeOperationObj.block = copyBlockList;
- },
- visible: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = ledgerTree.nodes[row];
- return select;
- }
- },
- 'pasteBlock': {
- name: '粘贴整块',
- icon: 'fa-clipboard',
- disabled: function (key, opt) {
- //const block = treeOperationObj.block || [];
- const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
- return !(copyInfo && copyInfo.tid && copyInfo.tid > 0 && 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) {
- treeOperationObj.pasteBlock(ledgerSpread, copyInfo);
- } else {
- document.execCommand('paste');
- }
- }
- },
- 'sprBlock': '-----------',
- '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 {
- treeOperationObj.addNode(ledgerSpread.getActiveSheet(), parseInt(obj.value));
- root.$menu.trigger('contextmenu:hide');
- }
- },
- disabled: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- 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;
- if (sel.rowCount > 1) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[sel.row + r];
- 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 && first.level > 1);
- }
- },
- 'batchInsertBillsPos': {
- name: '批量插入清单-计量单元',
- icon: 'fa-sign-in',
- disabled: function (key, opt) {
- if (!checkTzMeasureType()) return true;
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = ledgerTree.nodes[row];
- if (select) {
- if (select.code && select.code !== '') {
- return !ledgerTree.isLeafXmj(select);
- } else {
- const parent = ledgerTree.getParent(select);
- return !(parent && ledgerTree.isLeafXmj(parent));
- }
- } else {
- return false;
- }
- },
- callback: function (key, opt) {
- if (!batchInsertObj) {
- batchInsertObj = new BatchInsertBillsPosObj($('#batch'));
- } else {
- batchInsertObj.initView();
- }
- $('#batch').modal('show');
- }
- },
- 'sprBatch': '-----------',
- 'importExcel': {
- name: '导入分项清单Excel',
- icon: 'fa-file-excel-o',
- disabled: function (key, opt) {
- return readOnly;
- },
- callback: function (key, opt) {
- importExcel.doImport({
- template: {
- hint: '0号台账',
- url: '/template/导入分项清单EXCEL格式.xls',
- },
- callback: function (sheet) {
- postDataCompress(window.location.pathname + '/upload-excel/tz', sheet, function (result) {
- ledgerTree.loadDatas(result.bills);
- treeCalc.calculateAll(ledgerTree);
- SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
- pos.loadDatas(result.pos);
- posOperationObj.loadCurPosData();
- }, null);
- }
- });
- //$('#upload-ledger').modal('show');
- }
- },
- 'importGclBills2Xmj': {
- name: '导入工程量清单至项目节',
- icon: 'fa-file-excel-o',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- return readOnly
- || (node.children && node.children.length > 0)
- || (!_.isNil(node.b_code) && node.b_code !== '');
- },
- callback: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- 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 ledgerSheet = ledgerSpread.getActiveSheet();
- const sel = ledgerSheet.getSelections();
- const refreshNode = ledgerTree.loadPostData(result);
- treeOperationObj.refreshTree(ledgerSheet, refreshNode);
- if (refreshNode.create[0]) {
- if (sel && sel[0]) {
- ledgerSheet.setSelection(refreshNode.create[0].index, sel[0].col, sel[0].rowCount, sel[0].colCount);
- } else {
- ledgerSheet.setSelection(refreshNode.create[0].index, 0, 1, 1);
- }
- }
- treeOperationObj.refreshOperationValid(ledgerSheet);
- }, null);
- }
- });
- }
- },
- 'sprImport': '-----------',
- 'exportExcel': {
- name: '导出表格数据',
- icon: 'fa-file-excel-o',
- callback: function (key, opt) {
- const excelIo = new GC.Spread.Excel.IO();
- const date = new Date();
- const fileName = $('.text-truncate').attr('data-original-title') + '.xlsx';
- const sJson = JSON.stringify(ledgerSpread.toJSON({columnHeadersAsFrozenRows: true, rowHeadersAsFrozenColumns: true}));
- excelIo.save(sJson, function(blob) {
- saveAs(blob, fileName);
- });
- },
- visible: function (key, opt) {
- try {
- return is_debug;
- } catch (err) {
- return false;
- }
- }
- }
- },
- });
- } else {
- SpreadJsObj.forbiddenSpreadContextMenu('#ledger-spread', ledgerSpread);
- }
- const posSearch = $.posSearch({selector: '#pos-search', searchSpread: posSpread});
- // 台账模式加载计量单元数据
- if (checkTzMeasureType()) {
- $.divResizer({
- select: '#main-resize',
- callback: function () {
- ledgerSpread.refresh();
- let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
- $(".sp-wrap").height(bcontent-40);
- posSpread.refresh();
- }
- });
- SpreadJsObj.initSheet(posSpread.getActiveSheet(), posSpreadSetting);
- }
- // 绑定计量单元编辑事件
- const posOperationObj = {
- editStarting: function (e, info) {
- posOperationObj.ledgerTreeNode = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- },
- /**
- * 加载计量单元 根据当前台账选择节点
- */
- loadCurPosData: function () {
- const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
- if (node) {
- const posData = pos.ledgerPos[itemsPre + node.id] || [];
- SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', posData);
- } else {
- SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', []);
- }
- },
- /**
- * 编辑单元格响应事件
- * @param {Object} e
- * @param {Object} info
- */
- editEnded: function (e, info) {
- if (info.sheet.zh_setting) {
- 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.sheet.getCell(info.row, info.col).text());
- if (orgText === newText || ((!orgText || orgText === '') && (newText === ''))) {
- return;
- }
- //const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
- const node = posOperationObj.ledgerTreeNode;
- 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 = {};
- if (col.field === 'name') {
- if (newText === '' && posData) {
- toastr.error('部位名称不可为空');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- } else if (!posData) {
- if (newText && newText !== '') {
- data.updateType = '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.updateData = { name: newText, lid: node.id, tid: tender.id, porder: order};
- } else {
- return;
- }
- } else {
- data.updateType = 'update';
- data.updateData = {id: posData.id, name: newText};
- }
- } else if (!posData) {
- toastr.warning('新增部位请先输入名称');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- } else {
- data.updateType = 'update';
- data.updateData = {id: posData.id};
- if (col.type === 'Number') {
- const num = _.toNumber(newText);
- if (_.isFinite(num)) {
- data.updateData[col.field] = num;
- } else {
- try {
- data.updateData[col.field] = math.evaluate(transExpr(newText));
- } catch(err) {
- toastr.error('输入的表达式非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- } else {
- data.updateData[col.field] = newText;
- }
- }
- postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
- const updateRst = pos.updateDatas(result.pos);
- // 刷新当前行, 不适用于新增(在非下一空白行新增)
- if (updateRst.create.length > 0) {
- // info.sheet.addRows(info.row, 1);
- // if (info.sheet.zh_data.length === 0) {
- // info.sheet.zh_data = pos.ledgerPos[itemsPre + node.id] || [];
- // }
- // SpreadJsObj.reLoadRowData(info.sheet, info.sheet.zh_data.length - 1);
- posOperationObj.loadCurPosData();
- } else {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- }
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- }
- },
- /**
- * 删除按钮响应事件
- * @param sheet
- */
- deletePress: function (sheet) {
- const self = this;
- if (sheet.zh_setting) {
- 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;
- bDel = true;
- }
- }
- if (bDel) {
- datas.push(data);
- posSelects.push(node);
- }
- }
- }
- if (datas.length > 0) {
- postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: datas}, function (result) {
- pos.updateDatas(result.pos);
- posOperationObj.loadCurPosData();
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- }, function () {
- posOperationObj.loadCurPosData();
- });
- }
- }
- },
- /**
- * 删除 计量单元
- * @param sheet
- */
- deletePos: function (sheet) {
- const selection = sheet.getSelections();
- const data = {
- updateType: 'delete',
- updateData: [],
- };
- const row = selection[0].row, count = selection[0].rowCount;
- const sortData = sheet.zh_data;
- for (let iRow = 0; iRow < count; iRow++) {
- if (sortData[iRow + row]) {
- data.updateData.push(sortData[iRow + row].id);
- }
- }
- if (data.updateData.length > 0) {
- postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
- pos.removeDatas(result.pos);
- sheet.deleteRows(row, count);
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- });
- }
- },
- /**
- * 粘贴单元格响应事件
- * @param e
- * @param info
- */
- clipboardPasted: function (e, info) {
- const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
- if (node.code && (node.code !== '')) {
- toastr.error('项目节不可含有清单明细');
- posOperationObj.loadCurPosData();
- return;
- }
- if (node.children && (node.children.length > 0)) {
- toastr.error('仅清单子项可以含有计量单元');
- posOperationObj.loadCurPosData();
- return;
- }
- if (info.sheet.zh_setting) {
- 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('新增部位请先输入名称');
- posOperationObj.loadCurPosData();
- return;
- }
- }
- const lastOrder = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
- let bPaste = false;
- 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];
- 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;
- bPaste = true;
- } else {
- try {
- posData[colSetting.field] = math.evaluate(transExpr(posData[colSetting.field]));
- bPaste = true;
- } catch(err) {
- delete posData[colSetting.field];
- toastr.warning('粘贴了表达式非法,已过滤');
- }
- }
- } else {
- bPaste = true;
- }
- }
- if (bPaste) {
- data.push(posData);
- }
- }
- if (data.length > 0) {
- postData('/tender/' + getTenderId() + '/pos/paste', data, function (result) {
- pos.updateDatas(result.pos);
- posOperationObj.loadCurPosData();
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- posOperationObj.loadCurPosData();
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- });
- } else {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- }
- }
- },
- selectionChanged: function (e, info) {
- const col = info.sheet.zh_setting.cols[info.newSelections[0].col];
- const cell = info.sheet.getCell(info.newSelections[0].row, info.newSelections[0].col);
- if (col && col.type === 'Number') {
- const data = SpreadJsObj.getSelectObject(info.sheet);
- if (data) {
- $('#pos-expr').val(data[col.field]).attr('field', col.field).attr('org', data[col.field])
- .attr('row', info.newSelections[0].row).attr('readOnly', readOnly || cell.locked());
- } else {
- $('#pos-expr').val('').attr('readOnly', true);
- }
- } else {
- $('#pos-expr').val('').attr('readOnly', true);
- }
- },
- addPegs: function (pegs) {
- if (!pegs || pegs.length <= 0) return;
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- 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('/tender/' + getTenderId() + '/pos/paste', pegs, function (result) {
- pos.updateDatas(result.pos);
- posOperationObj.loadCurPosData();
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- });
- }
- };
- posSpread.bind(spreadNS.Events.SelectionChanged, posOperationObj.selectionChanged);
- if (!posSpreadSetting.readOnly) {
- $('#pos-expr').bind('change mouseleave', function () {
- const expr = $(this);
- const posSheet = posSpread.getActiveSheet();
- const select = SpreadJsObj.getSelectObject(posSheet);
- if (select) return;
- const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = expr.val(), row = trimInvalidChar(expr.attr('row'));
- if (orgValue === newValue || (!orgValue && newValue == '')) { return; }
- const data = {id: select.id};
- if (newValue !== '') {
- const num = _.toNumber(newValue);
- if (num) {
- data[field] = num;
- } else {
- try {
- data[field] = math.evaluate(transExpr(newValue));
- } catch (err) {
- toastr.error('输入的表达式非法');
- return;
- }
- }
- } else {
- data[field] = null;
- }
- // 更新至服务器
- postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: data}, function (result) {
- const updateRst = pos.updateDatas(result.pos);
- expr.val(select[field]);
- SpreadJsObj.reLoadRowData(posSheet, _.toNumber(row));
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- });
- });
- SpreadJsObj.addDeleteBind(posSpread, posOperationObj.deletePress);
- posSpread.bind(spreadNS.Events.EditStarting, posOperationObj.editStarting);
- posSpread.bind(spreadNS.Events.EditEnded, posOperationObj.editEnded);
- posSpread.bind(spreadNS.Events.ClipboardPasted, posOperationObj.clipboardPasted);
- const mergePeg = NewMergePeg({ callback: posOperationObj.addPegs });
- // 右键菜单
- $.contextMenu({
- selector: '#pos-spread',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, posSpread);
- return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
- },
- items: {
- 'delete': {
- name: '删除',
- icon: 'fa-remove',
- disabled: function (key, opt) {
- const sheet = posSpread.getActiveSheet();
- if (sheet.zh_data) {
- const selection = sheet.getSelections();
- return sheet.zh_data.length < selection[0].row + selection[0].rowCount;
- } else {
- return true;
- }
- },
- callback: function (key, opt) {
- posOperationObj.deletePos(posSpread.getActiveSheet());
- }
- },
- 'merge-peg': {
- name: '合并起讫桩号',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- return _.isNil(node) || _.isNil(node.b_code) || node.b_code === '';
- },
- callback: function (key, opt) {
- mergePeg.show();
- }
- }
- }
- });
- } else {
- SpreadJsObj.forbiddenSpreadContextMenu('#pos-spread', posSpread);
- }
- postData(window.location.pathname + '/load', {}, function (data) {
- ledgerTree.loadDatas(data.bills);
- treeCalc.calculateAll(ledgerTree);
- SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
- SpreadJsObj.loadTopAndSelect(ledgerSpread.getActiveSheet(), ckBillsSpread);
- pos.loadDatas(data.pos);
- posOperationObj.loadCurPosData();
- SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- treeOperationObj.loadExprToInput(ledgerSpread.getActiveSheet());
- }, null, true);
- $.divResizer({
- select: '#right-spr',
- callback: function () {
- ledgerSpread.refresh();
- if (posSpread) {
- posSpread.refresh();
- }
- if (stdXmj) {
- stdXmj.spread.refresh();
- }
- if (stdGcl) {
- stdGcl.spread.refresh();
- }
- if (dealBills) {
- dealBills.spread.refresh();
- }
- if (searchLedger) {
- searchLedger.spread.refresh();
- }
- }
- });
- const stdLibCellDoubleClick = function (e, info) {
- const stdSheet = info.sheet;
- const mainSheet = ledgerSpread.getActiveSheet();
- 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: ledgerTree.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);
- treeOperationObj.refreshTree(mainSheet, refreshNode);
- if (refreshNode.create && refreshNode.create.length > 0) {
- mainSheet.setSelection(refreshNode.create[refreshNode.create.length - 1].index, sel.col, sel.rowCount, sel.colCount);
- } else {
- const node = _.find(ledgerTree.nodes, {code: stdNode.code, name: stdNode.name});
- if (node) {
- mainSheet.setSelection(ledgerTree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
- }
- }
- treeOperationObj.refreshOperationValid(mainSheet);
- ledgerSpread.focus();
- posOperationObj.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: [0],
- },
- cellDoubleClick: stdLibCellDoubleClick,
- page: 'ledger',
- tid: getTenderId(),
- };
- 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: [0],
- },
- cellDoubleClick: stdLibCellDoubleClick,
- page: 'ledger',
- tid: getTenderId(),
- };
- // 展开收起标准清单
- $('a', '#side-menu').bind('click', function (e) {
- e.preventDefault();
- const tab = $(this), tabPanel = $(tab.attr('content'));
- const showSideTools = function (show) {
- const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
- if (show) {
- right.show();
- autoFlashHeight();
- /**
- * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
- * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px
- * 故需要通过最终的parent.width再计算一次left.width
- *
- * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width?
- * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width
- *
- */
- //left.css('width', parent.width() - right.outerWidth());
- //left.css('width', parent.width() - right.outerWidth());
- const percent = 100 - right.outerWidth() /parent.width() * 100;
- left.css('width', percent + '%');
- } else {
- left.width(parent.width());
- right.hide();
- }
- };
- // 展开工具栏、切换标签
- 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.loadLib($('select', '#std-xmj').val());
- }
- stdXmj.spread.refresh();
- } else if (tab.attr('content') === '#std-gcl') {
- if (!stdGcl) {
- stdGcl = new stdLib(stdGclSetting);
- //stdGcl.loadLib($('select', '#std-gcl').val());
- }
- stdGcl.spread.refresh();
- } else if (tab.attr('content') === '#deal-bills') {
- if (!dealBills) {
- 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],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- headColWidth: [0],
- });
- dealBills.loadData();
- }
- dealBills.spread.refresh();
- } else if (tab.attr('content') === '#search' && !searchLedger) {
- if (!searchLedger) {
- searchLedger = $.billsSearch({
- selector: '#search',
- searchSpread: ledgerSpread,
- resultSpreadSetting: {
- cols: [
- {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true},
- {title: '清单编号', field: 'b_code', hAlign: 0, width: 120, 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],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- },
- afterLocated: function () {
- posOperationObj.loadCurPosData();
- }
- });
- }
- searchLedger.spread.refresh();
- }
- } else { // 收起工具栏
- tab.removeClass('active');
- tabPanel.removeClass('active');
- showSideTools(tab.hasClass('active'));
- }
- ledgerSpread.refresh();
- if (posSpread) {
- posSpread.refresh();
- }
- });
- class DealBills {
- constructor (selector, spreadSetting) {
- const self = this;
- this.obj = $(selector)[0];
- this.url = '/tender/' + getTenderId() + '/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 = ledgerSpread.getActiveSheet();
- 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.error('非最底层项目下,不应添加清单');
- 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);
- treeOperationObj.refreshTree(mainSheet, refreshData);
- const sel = mainSheet.getSelections()[0];
- mainSheet.setSelection(refreshData.create[0].index, sel.col, sel.rowCount, sel.colCount);
- treeOperationObj.refreshOperationValid(mainSheet);
- ledgerSpread.focus();
- posOperationObj.loadCurPosData();
- });
- });
- }
- SpreadJsObj.forbiddenSpreadContextMenu(selector, this.spread);
- $('#upload-deal-bills').click(function () {
- const file = $('#deal-bills-file')[0];
- const formData = new FormData();
- formData.append('file', file.files[0]);
- postDataWithFile(self.url+'/upload-excel', formData, function (data) {
- self.data = data;
- SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
- $('#upload-deal').modal('hide');
- }, function () {
- $('#upload-deal').modal('hide');
- });
- });
- }
- loadData () {
- const self = this;
- postData(this.url+'/get-data', {}, function (data) {
- self.data = data;
- SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
- });
- }
- calculateData () {
- if (this.data) {
- for (const d of this.data) {
- d.total_price = _.multiply(d.quantity, d.unit_price);
- }
- }
- }
- }
- class BatchInsertBillsPosObj {
- constructor (obj) {
- const self = this;
- this.obj = obj;
- this.billsCount = 6;
- this.posCount = 1000;
- // 初始化 清单编号窗口 参数
- 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, formatter: '@', readOnly: true},
- {title: '名称', field: 'name', width: 120, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
- {title: '单价', field: 'unit_price', width: 50, 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());
- $.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, 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);
- },
- },
- }
- });
- // 拉取签约清单数据
- if (dealBills) {
- SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
- } else {
- postData('/tender/' + getTenderId() + '/deal/get-data', {}, function (data) {
- SpreadJsObj.loadSheetData(self.dealSpread.getActiveSheet(), 'data', 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);
- });
- this.obj.bind('shown.bs.modal', function () {
- self.qdSpread.refresh();
- self.posSpread.refresh();
- self.dealSpread.refresh();
- });
- $('#batch-ok').click(function () {
- const sheet = ledgerSpread.getActiveSheet();
- const sel = sheet.getSelections()[0];
- const row = sel.row;
- const select = ledgerTree.nodes[row];
- if (select) {
- const insertData = {};
- insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next';
- insertData.id = ledgerTree.getNodeKey(select);
- 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 = ledgerTree.loadPostData(data.ledger);
- treeOperationObj.refreshTree(sheet, result);
- sheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
- treeOperationObj.refreshOperationValid(sheet);
- self.obj.modal('hide');
- }, null, true);
- } else {
- self.obj.modal('hide');
- }
- }
- });
- }
- // 初始化左侧表格
- 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: [],
- };
- result.push(qd);
- 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,
- });
- }
- }
- }
- return result;
- }
- }
- $('#searchAccount').click(() => {
- const data = {
- keyword: $('#searchName').val(),
- };
- postData('/search/user', data, (data) => {
- const resultDiv = $('#searchResult');
- if (data) {
- $('h5>span', resultDiv).text(data.name);
- $('#addAuditor').attr('auditorId', data.id);
- $('h6', resultDiv).text(data.role);
- $('p', resultDiv).text(data.company);
- resultDiv.show();
- } else {
- toastr.info('未查询到该审核人');
- resultDiv.hide();
- }
- }, () => {
- $('#searchResult').hide();
- });
- });
- // 审批人分组选择
- $('#account_group').change(function () {
- let account_html = '<option value="0">选择审批人</option>';
- for (const account of accountList) {
- if (parseInt($(this).val()) === 0 || parseInt($(this).val()) === account.account_group) {
- const role = account.role !== '' ? '(' + account.role + ')' : '';
- const company = account.company !== '' ? ' -' + account.company : '';
- account_html += '<option value="' + account.id + '">' + account.name + role + company + '</option>';
- }
- }
- $('#account_list').html(account_html);
- });
- // 添加到审批流程中
- $('body').on('change', '#account_list', function () {
- let id = $(this).val();
- id = parseInt(id);
- if (id !== 0) {
- const data = {
- auditorId: $(this).val(),
- };
- postData('/tender/' + getTenderId() + '/ledger/audit/add', data, (data) => {
- const html = [];
- html.push('<li class="list-group-item" auditorId="' + data.audit_id + '"><a href="javascript: void(0)" class="text-danger pull-right">移除</a>');
- html.push('<span>');
- html.push(data.audit_order + ' ');
- html.push(data.name + ' ');
- html.push('</span>');
- html.push('<small class="text-muted">');
- html.push(data.role);
- html.push('</small></li>');
- $('#auditors').append(html.join(''));
- // 如果是重新上报,添加到重新上报列表中
- const auditorshtml = [];
- // 重新上报时。令其它的审批人流程图标转换
- $('#auditors-list li i').removeClass('fa-stop-circle').addClass('fa-chevron-circle-down');
- for (let i = 0; i < $('#auditors-list li').length; i++) {
- $('#auditors-list li').eq(i).find('.pull-right').text(transFormToChinese(i+1) + '审');
- $('#auditors-list2 li').eq(i).find('.pull-right').text(transFormToChinese(i+1) + '审');
- }
- // 添加新审批人
- auditorshtml.push('<li class="list-group-item" data-auditid="' + data.audit_id + '">');
- auditorshtml.push('<i class="fa fa-stop-circle"></i> ');
- auditorshtml.push(data.name + ' <small class="text-muted">' + data.role + '</small>');
- auditorshtml.push('<span class="pull-right">终审</span>');
- auditorshtml.push('</li>');
- $('#auditors-list').append(auditorshtml.join(''));
- const auditorshtml2 = [];
- // 重新上报时。令其它的审批人流程图标转换
- $('#auditors-list2 li i').removeClass('fa-stop-circle').addClass('fa-chevron-circle-down');
- // 添加新审批人
- auditorshtml2.push('<li class="list-group-item" data-auditid="' + data.audit_id + '">');
- auditorshtml2.push('<h5 class="card-title"><i class="fa fa-stop-circle"></i> ');
- auditorshtml2.push(data.name + ' <small class="text-muted">' + data.role + '</small>');
- auditorshtml2.push('<span class="pull-right">终审</span>');
- auditorshtml2.push('</h5></li>');
- $('#auditors-list2').append(auditorshtml2.join(''));
- });
- }
- });
- $('body').on('click', '#auditors li>a', function () {
- const li = $(this).parent();
- const data = {
- auditorId: parseInt(li.attr('auditorId')),
- };
- postData('/tender/' + getTenderId() + '/ledger/audit/delete', data, (data2) => {
- li.remove();
- for (const a of data2) {
- const aLi = $('li[auditorId=' + a.audit_id + ']');
- $('span', aLi).text(a.audit_order + ' ' + a.name + ' ');
- }
- // 如果是重新上报
- // 令最后一个图标转换
- $('#auditors-list li[data-auditid="' + data.auditorId + '"]').remove();
- if ($('#auditors-list li').length !== 0 && !$('#auditors-list li i').hasClass('fa-stop-circle')) {
- $('#auditors-list li').eq($('#auditors-list li').length-1).children('i')
- .removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
- }
- $('#auditors-list2 li[data-auditid="' + data.auditorId + '"]').remove();
- if ($('#auditors-list2 li').length !== 0 && !$('#auditors-list2 li i').hasClass('fa-stop-circle')) {
- $('#auditors-list2 li').eq($('#auditors-list2 li').length-1).children('i')
- .removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
- }
- for (let i = 0; i < $('#auditors-list li').length; i++) {
- $('#auditors-list li').eq(i).find('.pull-right').text((i+1 === $('#auditors-list li').length ? '终' : transFormToChinese(i+1)) + '审')
- $('#auditors-list2 li').eq(i).find('.pull-right').text((i+1 === $('#auditors-list2 li').length ? '终' : transFormToChinese(i+1)) + '审')
- }
- });
- });
- $('#hideSp').click(function () {
- $('#sp-list2').modal('hide');
- });
- // 显示层次
- (function (select, sheet) {
- $(select).click(function () {
- const tag = $(this).attr('tag');
- const tree = sheet.zh_tree;
- if (!tree) return;
- 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;
- }
- });
- })('a[name=showLevel]', ledgerSpread.getActiveSheet());
- });
- // 检查上报情况
- function checkAuditorFrom () {
- if ($('#auditors li').length === 0) {
- toastr.error('请先选择审批人,再上报数据');
- return false;
- }
- $('#hide-all').show();
- }
|