Calculation/test/app/service/ledger.test.js

/**
 * 标段--台账 模型 单元测试
 *
 * @author Mai
 * @date 2017/2/1
 * @version
 */
'use strict';

const excel = require('node-xlsx');

/*const testNodeData = [
    { ledger_id: 1, ledger_pid: -1, order: 1, level: 1, full_path: '1', code: '1', is_leaf: false },
    { ledger_id: 2, ledger_pid: 1, order: 1, level: 2, full_path: '1.2', code: '1-1', is_leaf: false },
    { ledger_id: 6, ledger_pid: 2, order: 1, level: 3, full_path: '1.2.6', code: '1-1-1', is_leaf: false },
    { ledger_id: 7, ledger_pid: 6, order: 1, level: 4, full_path: '1.2.6.7', code: '202-1', is_leaf: false },
    { ledger_id: 10, ledger_pid: 7, order: 2, level: 5, full_path: '1.2.6.7.10', code: '202-1-a', is_leaf: true },
    { ledger_id: 9, ledger_pid: 7, order: 1, level: 5, full_path: '1.2.6.7.9', code: '202-1-b', is_leaf: true },
    { ledger_id: 8, ledger_pid: 6, order: 2, level: 4, full_path: '1.2.6.8', code: '202-2', is_leaf: false },
    { ledger_id: 11, ledger_pid: 8, order: 1, level: 5, full_path: '1.2.6.8.11', code: '202-2-c', is_leaf: true },
    { ledger_id: 12, ledger_pid: 8, order: 2, level: 5, full_path: '1.2.6.8.12', code: '202-2-e', is_leaf: true },
    { ledger_id: 13, ledger_pid: 2, order: 2, level: 3, full_path: '1.2.13', code: '1-1-2', is_leaf: true },
    { ledger_id: 14, ledger_pid: 2, order: 3, level: 3, full_path: '1.2.14', code: '1-1-3', is_leaf: true },
    { ledger_id: 3, ledger_pid: 1, order: 2, level: 2, full_path: '1.3', code: '1-2', is_leaf: false },
    { ledger_id: 15, ledger_pid: 3, order: 1, level: 3, full_path: '1.3.15', code: '1-2-1', is_leaf: true },
    { ledger_id: 4, ledger_pid: 1, order: 3, level: 2, full_path: '1.4', code: '1-3', is_leaf: false },
    { ledger_id: 16, ledger_pid: 4, order: 1, level: 3, full_path: '1.4.16', code: '1-3-1', is_leaf: true },
    { ledger_id: 5, ledger_pid: 1, order: 4, level: 2, full_path: '1.5', code: '1-4', is_leaf: true },
];*/
const testNodeData = [
    { id: 1, pid: -1, order: 1, level: 1, full_path: '1', code: '1', is_leaf: false },
    { id: 2, pid: 1, order: 1, level: 2, full_path: '1.2', code: '1-1', is_leaf: false },
    { id: 6, pid: 2, order: 1, level: 3, full_path: '1.2.6', code: '1-1-1', is_leaf: false },
    { id: 7, pid: 6, order: 1, level: 4, full_path: '1.2.6.7', code: '202-1', is_leaf: false },
    { id: 10, pid: 7, order: 2, level: 5, full_path: '1.2.6.7.10', code: '202-1-a', is_leaf: true },
    { id: 9, pid: 7, order: 1, level: 5, full_path: '1.2.6.7.9', code: '202-1-b', is_leaf: true },
    { id: 8, pid: 6, order: 2, level: 4, full_path: '1.2.6.8', code: '202-2', is_leaf: false },
    { id: 11, pid: 8, order: 1, level: 5, full_path: '1.2.6.8.11', code: '202-2-c', is_leaf: true },
    { id: 12, pid: 8, order: 2, level: 5, full_path: '1.2.6.8.12', code: '202-2-e', is_leaf: true },
    { id: 13, pid: 2, order: 2, level: 3, full_path: '1.2.13', code: '1-1-2', is_leaf: true },
    { id: 14, pid: 2, order: 3, level: 3, full_path: '1.2.14', code: '1-1-3', is_leaf: true },
    { id: 3, pid: 1, order: 2, level: 2, full_path: '1.3', code: '1-2', is_leaf: false },
    { id: 15, pid: 3, order: 1, level: 3, full_path: '1.3.15', code: '1-2-1', is_leaf: true },
    { id: 4, pid: 1, order: 3, level: 2, full_path: '1.4', code: '1-3', is_leaf: false },
    { id: 16, pid: 4, order: 1, level: 3, full_path: '1.4.16', code: '1-3-1', is_leaf: true },
    { id: 5, pid: 1, order: 4, level: 2, full_path: '1.5', code: '1-4', is_leaf: true },
];
const testTenderId = 3;
const testUserId = 2;

const { app, assert } = require('egg-mock/bootstrap');
const findById = function(nodes, Id) {
    const filters = nodes.filter(function(x) {
        return x.ledger_id === Id;
    });
    return filters.length > 0 ? filters[0] : undefined;
};

describe('test/app/service/ledger.test.js', () => {
    // 准备测试数据
    it('clear history test data', function* () {
        const ctx = app.mockContext();
        const result = yield ctx.service.ledger.db.delete(ctx.service.ledger.tableName, { tender_id: testTenderId });
        assert(result.affectedRows >= 0);
    });
    it('add test data(test add)', function* () {
        const ctx = app.mockContext();
        for (const data of testNodeData) {
            data.tender_id = testTenderId;
        }
        //const result = yield ctx.service.ledger.db.insert(ctx.service.ledger.tableName, testNodeData);
        //assert(result.affectedRows === testNodeData.length);
        const result = yield ctx.service.ledger.add(testNodeData, testTenderId);
        assert(result);
        ctx.service.ledger.cache.set('tender_node_maxId:' + testTenderId, 16, 'EX', ctx.app.config.cacheTime);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   ├── 202-1
        │   │   │   ├── 202-1-a
        │   │   │   └── 202-1-b
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-1-3
        │   ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   └── 1-2-1
        ├── 1-3
        │   └── 1-3-1
        └── 1-4
     */

    // 测试R类方法
    it('test getDataByTenderId', function* () {
        const ctx = app.mockContext();

        // 查询前4层节点
        const result1 = yield ctx.service.ledger.getDataByTenderId(testTenderId);
        assert(result1.length === 12);
        // 查询前3层节点
        const result2 = yield ctx.service.ledger.getDataByTenderId(testTenderId, 3);
        assert(result2.length === 10);
    });
    it('test getDataByNodeId', function* () {
        const ctx = app.mockContext();

        // 查询节点202-1
        const node = yield ctx.service.ledger.getDataByNodeId(testTenderId, 7);
        assert(node);
        assert(node.code === '202-1');
        assert(node.full_path === '1.2.6.7');
    });
    it('test getDataByNodeIds', function* () {
        const ctx = app.mockContext();

        // 查询节点202-1-a与201-1-b
        const result = yield ctx.service.ledger.getDataByNodeIds(testTenderId, [10, 9]);
        assert(result.length === 2);

        let node = findById(result, 10);
        assert(node.code === '202-1-a');

        node = findById(result, 9);
        assert(node.full_path === '1.2.6.7.9');
    });
    it('test getDataByIds', function* () {
        const ctx = app.mockContext();

        // 查询节点202-1
        const node = yield ctx.service.ledger.getDataByNodeId(testTenderId, 7);
        const result = yield ctx.service.ledger.getDataByIds([node.id]);
        assert(result.length === 1);
        assert(node.code === result[0].code);
        assert(node.full_path === result[0].full_path);
    });
    it('test getLastChildData', function* () {
        const ctx = app.mockContext();

        // 查询节点202-1最后一个子节点
        const result = yield ctx.service.ledger.getLastChildData(testTenderId, 7);
        assert(result.ledger_id === 10);
        assert(result.full_path === '1.2.6.7.10');
    });
    it('test getDataByParentAndOrder', function* () {
        const ctx = app.mockContext();

        // 查询节点202-1 第1子节点
        const result1 = yield ctx.service.ledger.getDataByParentAndOrder(testTenderId, 8, 1);
        assert(result1.ledger_id === 11);
        assert(result1.full_path === '1.2.6.8.11');

        // 查询节点1-1 第2/3子节点
        const result2 = yield ctx.service.ledger.getDataByParentAndOrder(testTenderId, 2, [2, 3]);
        assert(result2.length === 2);

        let node = findById(result2, 13);
        assert(node);
        assert(node.code === '1-1-2');

        node = findById(result2, 14);
        assert(node);
        assert(node.code === '1-1-3');
    });
    it('test getChildrenByParentId', function* () {
        const ctx = app.mockContext();

        // 查询节点202-1最后一个子节点
        const result = yield ctx.service.ledger.getChildrenByParentId(testTenderId, 8);
        assert(result.length === 2);

        let node = findById(result, 11);
        assert(node);
        assert(node.code === '202-2-c');

        node = findById(result, 12);
        assert(node);
        assert(node.full_path === '1.2.6.8.12');
    });
    it('test getNextsData', function* () {
        const ctx = app.mockContext();

        // 查询节点1-1-1的全部子节点
        const result = yield ctx.service.ledger.getNextsData(testTenderId, 2, 1);
        assert(result.length === 2);

        let node = findById(result, 13);
        assert(node);
        assert(node.code === '1-1-2');

        node = findById(result, 14);
        assert(node);
        assert(node.code === '1-1-3');
    });
    it('test getDataByFullPath', function* () {
        const ctx = app.mockContext();

        // 查询节点202-2及其子节点
        const result = yield ctx.service.ledger.getDataByFullPath(testTenderId, '1.2.6.8%');
        assert(result.length === 3);

        let node = findById(result, 8);
        assert(node);
        assert(node.code === '202-2');

        node = findById(result, 11);
        assert(node);
        assert(node.code === '202-2-c');

        node = findById(result, 12);
        assert(node);
        assert(node.full_path === '1.2.6.8.12');

        // 查询1-1-1的子孙节点
        const result1 = yield ctx.service.ledger.getDataByFullPath(testTenderId, '1.2.6.%');
        assert(result1.length === 6);
    });
    it('test getFullLevelDataByFullPath', function* () {
        const ctx = app.mockContext();

        // 查询202-2-c及其全部父节点
        const result1 = yield ctx.service.ledger.getFullLevelDataByFullPath(testTenderId, '1.2.6.8.11');
        assert(result1.length === 5);

        const result2 = yield ctx.service.ledger.getFullLevelDataByFullPath(testTenderId, ['1.2.6.8.11', '1.2.6.7.9']);
        assert(result2.length === 7);
    });

    // 测试CUD类方法
    // 基本树结构操作
    it('test addNode', function* () {
        const ctx = app.mockContext();
        // 选中1-1-1，插入节点
        const resultData = yield ctx.service.ledger.addNode(testTenderId, 6);
        assert(resultData.create.length === 1);
        assert(resultData.update.length === 2);
        assert(resultData.create[0].is_leaf === 1);
        assert(resultData.create[0].ledger_id === 17);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   ├── 202-1
        │   │   │   ├── 202-1-a
        │   │   │   └── 202-1-b
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-1-3
        │   ├── new
        │   ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   └── 1-2-1
        ├── 1-3
        │   └── 1-3-1
        └── 1-4
     */
    it('test deleteNode', function* () {
        const ctx = app.mockContext();
        // 选中202-1，删除节点
        const resultData = yield ctx.service.ledger.deleteNode(testTenderId, 7);
        assert(resultData.delete.length === 3);
        assert(resultData.update.length === 1);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   ├── new
        │   ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   └── 1-2-1
        ├── 1-3
        │   └── 1-3-1
        └── 1-4
     */
    it('test upMoveNode', function* () {
        const ctx = app.mockContext();
        // 选中202-2-e上移
        const resultData = yield ctx.service.ledger.upMoveNode(testTenderId, 12);
        resultData.update.sort(function(x, y) {
            return x.order - y.order;
        });
        assert(resultData.update.length === 2);
        assert(resultData.update[0].code === '202-2-e');
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   ├── new
        │   ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   └── 1-2-1
        ├── 1-3
        │   └── 1-3-1
        └── 1-4
     */
    it('test downMoveNode', function* () {
        const ctx = app.mockContext();
        // 选中202-2-e下移
        const resultData = yield ctx.service.ledger.downMoveNode(testTenderId, 12);
        resultData.update.sort(function(x, y) {
            return x.order - y.order;
        });
        assert(resultData.update.length === 2);
        assert(resultData.update[0].code === '202-2-c');
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   ├── new
        │   ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   └── 1-2-1
        ├── 1-3
        │   └── 1-3-1
        └── 1-4
     */
    it('test upLevelNode', function* () {
        const ctx = app.mockContext();
        // 选中 1-1-2 升级
        const resultData = yield ctx.service.ledger.upLevelNode(testTenderId, 13);
        assert(resultData);
        assert(resultData.update.length === 6);

        let node = findById(resultData.update, 13);
        assert(node.full_path === '1.13');
        assert(node.ledger_pid === 1);
        assert(!node.is_leaf);

        node = findById(resultData.update, 14);
        assert(node.ledger_pid === 13);
        assert(node.full_path === '1.13.14');

        node = findById(resultData.update, 3);
        assert(node.order === 3);

        node = findById(resultData.update, 4);
        assert(node.order === 4);

        node = findById(resultData.update, 5);
        assert(node.order === 5);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   └── new
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   └── 1-2-1
        ├── 1-3
        │   └── 1-3-1
        └── 1-4
     */
    it('test downLevelNode', function* () {
        const ctx = app.mockContext();
        // 选中1-3 降级
        const resultData = yield ctx.service.ledger.downLevelNode(testTenderId, 4);
        // 1-3/1-3-1/1-4修改
        assert(resultData.update.length === 3);

        let node = findById(resultData.update, 4);
        assert(node.full_path === '1.3.4');
        assert(node.ledger_pid === 3);
        assert(node.level === 3);
        assert(node.order === 2);

        node = findById(resultData.update, 16);
        assert(node.level === 4);
        assert(node.full_path === '1.3.4.16');

        node = findById(resultData.update, 5);
        assert(node.order === 4);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   └── new
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    // 复制整块
    it('test pasteBlock', function* () {
        const ctx = app.mockContext();
        // 选中1-2-1, 粘贴1-1-1和new
        const resultData = yield ctx.service.ledger.pasteBlock(testTenderId, 15, [6, 17]);

        const ledger = resultData.ledger;
        assert(ledger.create.length === 5);
        assert(ledger.create[0].order = 2);
        assert(ledger.create[0].level = 3);
        assert(ledger.create[0].full_path = '1.3.18');

        assert(ledger.create[1].order = 3);
        assert(ledger.create[1].level = 3);
        assert(ledger.create[1].full_path = '1.3.22');

        assert(ledger.update.length === 1);
        assert(ledger.update[0].order = 3);

        assert(resultData.pos.length === 0);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   └── new
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   ├── new
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    // 增量计算
    it('test updateInfo', function* () {
        const ctx = app.mockContext();

        // 修改new(id=17)的code 为 1-1-4
        const node = yield ctx.service.ledger.getDataByNodeId(testTenderId, 17);
        assert(node);

        const resultData = yield ctx.service.ledger.updateInfo(testTenderId, {
            id: node.id,
            tender_id: node.tender_id,
            ledger_id: node.ledger_id,
            code: '1-1-4',
        });
        assert(resultData.code === '1-1-4');
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   └── 1-1-4
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   ├── new
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    it('test updateInfos', function* () {
        const ctx = app.mockContext();

        // 修改1-1-1(id=18)的code 为 1-2-2、修改new(id=22)的code 为 1-2-3
        const node1 = yield ctx.service.ledger.getDataByNodeId(testTenderId, 18);
        assert(node1);
        const node2 = yield ctx.service.ledger.getDataByNodeId(testTenderId, 22);
        assert(node2);

        const resultData = yield ctx.service.ledger.updateInfos(testTenderId, [{
            id: node1.id,
            tender_id: node1.tender_id,
            ledger_id: node1.ledger_id,
            code: '1-2-2',
        }, {
            id: node2.id,
            tender_id: node2.tender_id,
            ledger_id: node2.ledger_id,
            code: '1-2-3',
        }]);
        assert(resultData.length === 2);
        assert(resultData[0].code === '1-2-2');
        assert(resultData[1].code === '1-2-3');
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   └── 1-1-4
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    it('test updateCalc - update 1', function* () {
        const ctx = app.mockContext();
        // 修改202-2-e(1-1-1下)(id=12)的quantity为2.00000001, unit_price位3.0000005
        const qty = 2.00000001;
        const up = 3.0000005;
        const tp = 6.00000103;
        const node1 = yield ctx.service.ledger.getDataByNodeId(testTenderId, 12);
        assert(node1);
        const resultData = yield ctx.service.ledger.updateCalc(testTenderId, {
            id: node1.id,
            tender_id: node1.tender_id,
            ledger_id: node1.ledger_id,
            quantity: qty,
            unit_price: up
        });
        assert(resultData.update.length === 1);
        let node = findById(resultData.update, 12);
        assert(node.total_price.toFixed(8) == tp);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   └── 1-1-4
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    it('test updateCalc - update N', function* () {
        const ctx = app.mockContext();
        // 修改202-2-c(1-1-1下)(id=11)的quantity为4.00000025, unit_price为6.0000083
        //    202-2-c(1-2-2下)(id=20)的quantity为2.0000001, unit_price为5.000065
        //    202-2-e(1-2-2下)(id=21)的quantity为8.0000579, unit_price为4.0000086
        const qty = [4.00000025, 2.0000001, 8.0000579];
        const up = [6.0000083, 5.000065, 4.0000086];
        const tp = [24.0000347, 10.0001305, 32.0003004];
        const sum = [30.00003573, 42.0004309, 72.00046663]
        const node1 = yield ctx.service.ledger.getDataByNodeId(testTenderId, 11);
        assert(node1);
        const node2 = yield ctx.service.ledger.getDataByNodeId(testTenderId, 20);
        assert(node2);
        const node3 = yield ctx.service.ledger.getDataByNodeId(testTenderId, 21);
        assert(node3);

        const resultData = yield ctx.service.ledger.updateCalc(testTenderId, [{
            id: node1.id,
            tender_id: node1.tender_id,
            ledger_id: node1.ledger_id,
            quantity: qty[0],
            unit_price: up[0]
        }, {
            id: node2.id,
            tender_id: node2.tender_id,
            ledger_id: node2.ledger_id,
            quantity: qty[1],
            unit_price: up[1]
        }, {
            id: node3.id,
            tender_id: node3.tender_id,
            ledger_id: node3.ledger_id,
            quantity: qty[2],
            unit_price: up[2]
        }]);

        assert(resultData.update.length === 3);

        let node = findById(resultData.update, 11);
        assert(node.total_price.toFixed(8) == tp[0]);
        node = findById(resultData.update, 20);
        assert(node.total_price.toFixed(8) == tp[1]);
        node = findById(resultData.update, 21);
        assert(node.total_price.toFixed(8) == tp[2]);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   └── 1-1-4
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       ├── 202-2-c     2.0000001   5.000065    10.0001305
        │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    // 复制整块+实时计算
    it('test pasteBlock - with Increment Calculate', function* () {
        const ctx = app.mockContext();
        // 选中1-1-4, 粘贴202-2(1-1-1下)
        const resultData = yield ctx.service.ledger.pasteBlock(testTenderId, 17, [8]);

        assert(resultData.ledger.create.length === 3);
        assert(resultData.ledger.update.length === 0);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   ├── 1-1-4
        │   └── 202-2
        │       ├── 202-2-c         4.00000025  6.0000083   24.0000347
        │       └── 202-2-e         2.00000001  3.0000005   6.00000103
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       ├── 202-2-c     2.0000001   5.000065    10.0001305
        │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    // 树结构基本操作+实时计算
    it('test downLevel - with Increment Calculate', function* () {
        const ctx = app.mockContext();
        // 选中202-2(1-1-4后兄弟节点) 降级
        const resultData = yield ctx.service.ledger.downLevelNode(testTenderId, 23);
        assert(resultData.update.length === 4);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   └── 1-1-4
        │       └── 202-2
        │           ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │           └── 202-2-e     2.00000001  3.0000005   6.00000103
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       ├── 202-2-c     2.0000001   5.000065    10.0001305
        │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    it('test upLevel - with Increment Calculate', function* () {
        const ctx = app.mockContext();
        yield ctx.service.ledger.pasteBlock(testTenderId, 23, [23]);
        /* 期望运行结果:
            1
            ├── 1-1
            │   ├── 1-1-1
            │   │   └── 202-2
            │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
            │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
            │   └── 1-1-4
            │       ├── 202-2
            │       │   ├── 202-2-c     4.00000025  6.0000083   24.0000347
            │       │   └── 202-2-e     2.00000001  3.0000005   6.00000103
            │       └── 202-2
            │           ├── 202-2-c     4.00000025  6.0000083   24.0000347
            │           └── 202-2-e     2.00000001  3.0000005   6.00000103
            ├── 1-1-2
            │   └── 1-1-3
            ├── 1-2
            │   ├── 1-2-1
            │   ├── 1-2-2
            │   │   └── 202-2
            │   │       ├── 202-2-c     2.0000001   5.000065    10.0001305
            │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
            │   ├── 1-2-3
            │   └── 1-3
            │       └── 1-3-1
            └── 1-4
         */
        // 选中202-2-c(1-1-4下)(id=23)升级
        const resultData = yield ctx.service.ledger.upLevelNode(testTenderId, 23);
        assert(resultData.update.length === 7);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   ├── 1-1-4
        │   └── 202-2
        │       ├── 202-2-c         4.00000025  6.0000083   24.0000347
        │       ├── 202-2-e         2.00000001  3.0000005   6.00000103
        │       └── 202-2
        │           ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │           └── 202-2-e     2.00000001  3.0000005   6.00000103
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       ├── 202-2-c     2.0000001   5.000065    10.0001305
        │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    it('test deleteNode - with Increment Calculate', function* () {
        const ctx = app.mockContext();

        // 选中202-2-c(1-2-2下)(id=20)，删除节点
        const resultData = yield ctx.service.ledger.deleteNode(testTenderId, 20);
        assert(resultData.delete.length === 1);
        assert(resultData.update.length === 1);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   ├── 1-1-4
        │   └── 202-2
        │       ├── 202-2-c         4.00000025  6.0000083   24.0000347
        │       ├── 202-2-e         2.00000001  3.0000005   6.00000103
        │       └── 202-2
        │           ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │           └── 202-2-e     2.00000001  3.0000005   6.00000103
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    // 从标准库添加数据
    // 检查添加，直接添加为选中节点子节点
    it('test addStdNode', function* () {
        const ctx = app.mockContext();

        // 选中1-1-4
        const selectData = yield ctx.service.ledger.getDataByCondition({ tender_id: testTenderId, code: '1-1-4' });
        assert(selectData);
        // 从标准库中添加1-1-5
        const condition1 = { list_id: 1, code: '1-1-5' };
        const libData1 = yield ctx.service.stdChapter.getDataByCondition(condition1);
        assert(libData1);
        const stdData1 = yield ctx.service.stdChapter.getDataByDataId(1, libData1.chapter_id);
        assert(stdData1);
        assert(stdData1.id === libData1.id);
        const result1 = yield ctx.service.ledger.addStdNode(testTenderId, selectData.ledger_id, stdData1);
        assert(result1);
        assert(result1.create.length === 1);
        assert(result1.update.length === 1);
        // 从标准库中添加101-1
    });
    /* 期望运行结果:
        1                                                   122.00040759
        ├── 1-1                                             90.00009719
        │   ├── 1-1-1                                       30.00003573
        │   │   └── 202-2                                   30.00003573
        │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   ├── 1-1-4
        │   ├── 1-1-5
        │   └── 202-2                                       60.00007146
        │       ├── 202-2-c         4.00000025  6.0000083   24.0000347
        │       ├── 202-2-e         2.00000001  3.0000005   6.00000103
        │       └── 202-2                                   30.00003573
        │           ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │           └── 202-2-e     2.00000001  3.0000005   6.00000103
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2                                             32.0003004
        │   ├── 1-2-1
        │   ├── 1-2-2                                       32.0003004
        │   │   └── 202-2                                   32.0003004
        │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    it('test addStdNodeWithParent', function* () {
        const ctx = app.mockContext();

        // 从标准库添加1-4-2-1
        const condition1 = { list_id: 1, code: '1-4-2-1'};
        const libData1 = yield ctx.service.stdChapter.getDataByCondition(condition1);
        assert(libData1);
        const stdData1 = yield ctx.service.stdChapter.getDataByDataId(1, libData1.chapter_id);
        assert(stdData1);
        assert(stdData1.id === libData1.id);
        const result1 = yield ctx.service.ledger.addStdNodeWithParent(testTenderId, stdData1, ctx.service.stdChapter);
        assert(result1);
        assert(result1.create.length === 4);
        assert(!result1.update || result1.update.length === 0);
        assert(!result1.expand || result1.expand.length === 0);
        // 从标准库添加1-4-2-1-2
        const condition2 = { list_id: 1, code: '1-4-2-1-2'};
        const libData2 = yield ctx.service.stdChapter.getDataByCondition(condition2);
        assert(libData2);
        const stdData2 = yield ctx.service.stdChapter.getDataByDataId(1, libData2.chapter_id);
        assert(stdData2);
        assert(stdData2.id === libData2.id);
        const result2 = yield ctx.service.ledger.addStdNodeWithParent(testTenderId, stdData2, ctx.service.stdChapter);
        assert(result2);
        assert(result2.create.length === 1);
        assert(result2.update.length === 1);
        assert(result2.update[0].code = '1-4-2-1');
        assert(!result2.update[0].is_leaf);
        assert(result2.expand.length === 4);
        // 从标准库添加1-4-2-1-1
        const condition3 = { list_id: 1, code: '1-4-2-1-1'};
        const libData3 = yield ctx.service.stdChapter.getDataByCondition(condition3);
        assert(libData3);
        const stdData3 = yield ctx.service.stdChapter.getDataByDataId(1, libData3.chapter_id);
        assert(stdData3);
        assert(stdData3.id === libData3.id);
        const result3 = yield ctx.service.ledger.addStdNodeWithParent(testTenderId, stdData3, ctx.service.stdChapter);
        assert(result3);
        assert(result3.create.length === 1);
        assert(result3.create[0].order === 1);
        assert(result3.update.length === 1);
        assert(result3.update[0].code === '1-4-2-1-2');
        assert(result3.update[0].order === 2);
        assert(result3.expand.length === 5);
    });
    /* 期望运行结果:
        1                                                   122.00040759
        ├── 1-1                                             90.00009719
        │   ├── 1-1-1                                       30.00003573
        │   │   └── 202-2                                   30.00003573
        │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   ├── 1-1-4
        │   ├── 1-1-5
        │   └── 202-2                                       60.00007146
        │       ├── 202-2-c         4.00000025  6.0000083   24.0000347
        │       ├── 202-2-e         2.00000001  3.0000005   6.00000103
        │       └── 202-2                                   30.00003573
        │           ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │           └── 202-2-e     2.00000001  3.0000005   6.00000103
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2                                             32.0003004
        │   ├── 1-2-1
        │   ├── 1-2-2                                       32.0003004
        │   │   └── 202-2                                   32.0003004
        │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
            └── 1-4-2
                └── 1-4-2-1
                    ├── 1-4-2-1-1
                    └── 1-4-2-1-2
     */
    // 批量插入
    it('test batchInsertChild', function* () {
        const ctx = app.mockContext();
        // pos需要记录createUserId
        ctx.session = {
            sessionUser: {
                accountId: testUserId,
            },
        };

        const batchData = [
            {
                b_code: 401-1, name: 'A1', unit: 'B1', price: 2,
                pos: [{name: 'X1', quantity: 1}, {name: 'X2', quantity: 2}],
            },
            {
                b_code: 402-1, name: 'A2', unit: 'B2', price: 3,
                pos: [{name: 'X1', quantity: 3}, {name: 'X2', quantity: 4}],
            },
        ];
        // 选中1-1-3(id=14)
        const result = yield ctx.service.ledger.batchInsertChild(testTenderId, 14, batchData);
        assert(result.ledger.create.length === 2);
        let node = findById(result.ledger.create, 36);
        assert(node.quantity.toFixed(8) == 3);
        assert(node.total_price.toFixed(8) == 6);
        node = findById(result.ledger.create, 37);
        assert(node.quantity.toFixed(8) == 7);
        assert(node.total_price.toFixed(8) == 21);

        assert(result.pos.length === 4);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   ├── 1-1-4
        │   ├── 1-1-5
        │   └── 202-2
        │       ├── 202-2-c         4.00000025  6.0000083   24.0000347
        │       ├── 202-2-e         2.00000001  3.0000005   6.00000103
        │       └── 202-2
        │           ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │           └── 202-2-e     2.00000001  3.0000005   6.00000103
        ├── 1-1-2
        │   └── 1-1-3
        │       ├── 401-1           2           3           6
        │       │   ├── (pos)X1                 1
        │       │   └── (pos)X1                 2
        │       └── 402-1           3           7           21
        │           ├── (pos)X1                 3
        │           └── (pos)X2                 4
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
            └── 1-4-2
                └── 1-4-2-1
                    ├── 1-4-2-1-1
                    └── 1-4-2-1-2
     */
    // 批量插入
    it('test batchInsertNext', function* () {
        const ctx = app.mockContext();
        // pos需要记录createUserId
        ctx.session = {
            sessionUser: {
                accountId: testUserId,
            },
        };

        const batchData = [
            {
                b_code: 403-1, name: 'A1', unit: 'B1', price: 2,
                pos: [{name: 'Y1', quantity: 5}, {name: 'Y2', quantity: 6}],
            },
            {
                b_code: 404-1, name: 'A2', unit: 'B2', price: 3,
                pos: [{name: 'Y1', quantity: 7}, {name: 'Y2', quantity: 8}],
            },
        ];
        // 选中1-1-3(id=14)
        const result = yield ctx.service.ledger.batchInsertNext(testTenderId, 14, batchData);

        assert(result.ledger.create.length === 2);
        let node = findById(result.ledger.create, 39);
        assert(node.quantity.toFixed(8) == 11);
        assert(node.total_price.toFixed(8) == 22);
        node = findById(result.ledger.create, 40);
        assert(node.quantity.toFixed(8) == 15);
        assert(node.total_price.toFixed(8) == 45);

        assert(result.pos.length === 4);
    });
    /* 期望运行结果:
        1
        ├── 1-1
        │   ├── 1-1-1
        │   │   └── 202-2
        │   │       ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │   │       └── 202-2-e     2.00000001  3.0000005   6.00000103
        │   ├── 1-1-4
        │   ├── 1-1-5
        │   └── 202-2
        │       ├── 202-2-c         4.00000025  6.0000083   24.0000347
        │       ├── 202-2-e         2.00000001  3.0000005   6.00000103
        │       └── 202-2
        │           ├── 202-2-c     4.00000025  6.0000083   24.0000347
        │           └── 202-2-e     2.00000001  3.0000005   6.00000103
        ├── 1-1-2
        │   ├── 1-1-3
        │   │   ├── 401-1           2           3           6
        │   │   │   ├── (pos)X1                 1
        │   │   │   └── (pos)X1                 2
        │   │   └── 402-1           3           7           21
        │   │       ├── (pos)X1                 3
        │   │       └── (pos)X2                 4
        │   ├── 403-1               2           11          22
        │   │   ├── (pos)Y1                     5
        │   │   └── (pos)Y2                     6
        │   └── 404-1               3           15          45
        │       ├── (pos)Y1                     7
        │       └── (pos)Y2                     8
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       └── 202-2-e     8.0000579   4.0000086   32.0003004
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
            └── 1-4-2
                └── 1-4-2-1
                    ├── 1-4-2-1-1
                    └── 1-4-2-1-2
     */

    // 测试统计类方法
    it('test addUpChildren', function* () {
        const ctx = app.mockContext();

        // 统计202-2(id=23)前两个子节点的金额
        const result1 = yield ctx.service.ledger.addUpChildren(testTenderId, 23, 2, '<=');
        assert(result1 && result1.toFixed(8) == 30.00003573);
        // 数据库不再存储父项金额，以下两个查询不能获得实际金额
        // 统计202-2(id=23)后两个子节点的金额
        //const result2 = yield ctx.service.ledger.addUpChildren(testTenderId, 23, 2, '>=');
        //assert(result2 && result2.toFixed(8) == 36.00003676);
        // 统计202-2(id=23)全部子节点的金额
        //const result3 = yield ctx.service.ledger.addUpChildren(testTenderId, 23, 0, '>');
        //assert(result3 && result3.toFixed(8) == 60.00007146);
    });

    // 测试搜索类方法
    it('test search', function* () {
        const ctx = app.mockContext();

        const result = yield ctx.service.ledger.search(testTenderId, {
            value: app.mysql.escape('%1-3%'),
            operate: 'Like',
            fields: ['code', 'name'],
        });
        assert(result.length === 3);
    });
    it('test searchRange', function* () {
        const ctx = app.mockContext();
        const result = yield ctx.service.ledger.searchRange(testTenderId, {
            value: app.mysql.escape('%1-3%'),
            operate: 'Like',
            fields: ['code', 'name'],
        }, [{
            type: 'And',
            value: app.mysql.escape('1.13.%'),
            operate: 'Like',
            fields: ['full_path'],
        }]);
        assert(result.length === 1);
        assert(result[0].code === '1-1-3');
    });

    // it('test ImportExcelData', function* () {
    //     const ctx = app.mockContext();
    //
    //     const file = ctx.app.baseDir + '/test/app/test_file/ledger-upload-test.xls';
    //     const sheets = excel.parse(file);
    //     const result = yield ctx.service.
    // });

    // 小数位数策略示例：
    /*  先加总再保留3位小数:
        1                                        35.585
        ├── 1-1                                  35.585
        │   ├── 1-1-1                            35.585
        │   │   └── 202-2                        35.585
        │   │       ├── 202-2-c     4.25  6.83   29.028(29.0275)
        │   │       └── 202-2-e     2.15  3.05   6.558(6.5575)
        │   └── 1-1-3
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
    /*  先保留3位小数再加总:
        1                                        35.586
        ├── 1-1                                  35.586
        │   ├── 1-1-1                            35.586
        │   │   └── 202-2                        35.586
        │   │       ├── 202-2-c     4.25  6.83   29.028(29.0275)
        │   │       └── 202-2-e     2.15  3.05   6.558(6.5575)
        │   └── 1-1-3
        ├── 1-1-2
        │   └── 1-1-3
        ├── 1-2
        │   ├── 1-2-1
        │   ├── 1-2-2
        │   │   └── 202-2
        │   │       ├── 202-2-c
        │   │       └── 202-2-e
        │   ├── 1-2-3
        │   └── 1-3
        │       └── 1-3-1
        └── 1-4
     */
});