SmartCost
/
ConstructionCost


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592
							<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <meta http-equiv="x-ua-compatible" content="ie=edge">
    <title>清单规则编辑器</title>
    <link rel="stylesheet" href="web/css/bootstrap/bootstrap.min.css">
    <!--<link rel="stylesheet" href="../../web/css/bootstrap/themes.css">-->
    <link rel="stylesheet" href="web/css/main.css">
    <link rel="stylesheet" href="web/css/font-awesome/font-awesome.min.css">
    <!--spread-->
    <link rel="stylesheet" href="web/css/spreadjs/gc.spread.sheets.excel2013white.10.0.1.css">
    <!--zTree-->
    <link rel="stylesheet" href="web/css/ztree/zTreeStyle.css" type="text/css">
</head>

<body>
    <div class="header">
        <nav class="navbar navbar-toggleable-lg navbar-light bg-faded p-0 ">
            <span class="header-logo px-2">清单规则编辑器</span>
            <div class="navbar-text"></div>
        </nav>
        <nav class="navbar navbar-toggleable-lg justify-content-between navbar-light p-0">

              <ul class="nav nav-tabs" role="tablist">
                  <li class="nav-item">
                      <a class="nav-link active px-3" href="javascript: void(0);">清单</a>
                  </li>
                  <li class="nav-item">
                      <a id="aStdJobs" class="nav-link px-3" href="stdJobs">工作内容</a>
                  </li>
                  <li class="nav-item">
                      <a class="nav-link px-3" href="tezheng.html">项目特征</a>
                  </li>
              </ul>
        </nav>
    </div>
    <div class="main">
      <div class="content" >
        <div class="container-fluid">
          <div class="row">
            <div class="main-content col-lg-7 p-0">
                <nav class="navbar sticky-top navbar-toggleable-md navbar-light bg-faded tools-bar">
                  <div class="collapse navbar-collapse" id="navbarNav">
                      <ul class="navbar-nav">
                          <li class="nav-item">
                              <a class="nav-link text-primary" id="insert" href="javascript: void(0);"><i class="fa fa-share" aria-hidden="true"></i>插入</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" id ="delete" href="javascript:void (0)"><i class="fa fa-remove" aria-hidden="true"></i>删除</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" id="upLevel"  href="javascript: void(0);"><i class="fa fa-arrow-left" aria-hidden="true"></i>升级</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" id="downLevel" href="javascript: void(0);"><i class="fa fa-arrow-right" aria-hidden="true"></i>降级</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" id="upMove" href="javascript: void(0);"><i class="fa fa-arrow-up" aria-hidden="true"></i>上移</a>
                          </li>
                          <li class="nav-item">
                              <a class="nav-link text-primary" id="downMove" href="javascript: void(0);"><i class="fa fa-arrow-down" aria-hidden="true"></i>下移</a>
                          </li>
                      </ul>
                  </div>
                </nav>
                <div class="main-data" id="spreadBills">
                  <!--<div id="spreadBills" style="width: 100%; height: 700px;"></div>-->
                </div>
            </div>
            <div class="main-side col-lg-5 p-0">
              <div class="container-fluid">
                <div class="row">
                  <div class="col" style="width:50%; height: 100%">
                      <h5>工作内容</h5>
                      <div id="spreadJobs"  style="width:97%; height: 300px;"></div>
                  </div>
                  <div class="col" style="width:50%; height: 100%">
                    <h5>项目特征</h5>
                      <div id="spreadItems" style="width: 97%; height: 300px;"></div>
                  </div>
                  <div class="w-100"></div>
                  <div class="col">
                    <div class="form-group">
                      <label for="exampleTextarea"><h5>补注：</h5></label>
                      <textarea class="form-control" id="exampleTextarea" rows="8"></textarea>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
    <!--弹出添加-->
    <div class="modal fade" id="add" data-backdrop="static" style="display: none;" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                  <h5 class="modal-title">添加定额</h5>
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                  </button>
                </div>
                <div class="modal-body">
                  <form>
                    <div class="form-group">
                      <label>编码</label>
                      <input class="form-control" placeholder="输入编码" type="text">
                    </div>
                    <div class="form-group">
                      <label>名称</label>
                      <input class="form-control" placeholder="输入名称" type="text">
                    </div>
                    <div class="form-group">
                      <label>单位</label>
                      <select class="form-control"><option>选择单位</option><option>m3</option></select>
                    </div>
                    <div class="form-group">
                      <label>基价</label>
                      <input class="form-control" placeholder="输入基价" type="number">
                    </div>
                    <div class="form-group">
                      <label>显示名称（以%s表示参数）</label>
                      <input class="form-control" placeholder="输入显示名称" type="text">
                    </div>
                    <div class="form-group">
                      <label>默认取费专业</label>
                      <input class="form-control" placeholder="输入取费专业" type="text">
                    </div>
                  </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
                    <a href="" class="btn btn-primary">添加</a>
                </div>
            </div>
        </div>
    </div>
    <!--弹出编辑-->
    <div class="modal fade" id="edit" data-backdrop="static" style="display: none;" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                  <h5 class="modal-title">编辑定额</h5>
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                  </button>
                </div>
                <div class="modal-body">
                  <form>
                    <div class="form-group">
                      <label>编码</label>
                      <input class="form-control" placeholder="输入编码" type="text" value="AA0001">
                    </div>
                    <div class="form-group">
                      <label>名称</label>
                      <input class="form-control" placeholder="输入名称" type="text" value="人工挖土方">
                    </div>
                    <div class="form-group">
                      <label>单位</label>
                      <select class="form-control"><option>m3</option></select>
                    </div>
                    <div class="form-group">
                      <label>基价</label>
                      <input class="form-control" placeholder="输入基价" type="number" value="880.84">
                    </div>
                    <div class="form-group">
                      <label>显示名称（以%s表示参数）</label>
                      <input class="form-control" placeholder="输入显示名称" type="text" value="人工挖土方">
                    </div>
                    <div class="form-group">
                      <label>默认取费专业</label>
                      <input class="form-control" placeholder="输入取费专业" type="text" value="1">
                    </div>
                  </form>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
                    <a href="" class="btn btn-primary">确定</a>
                </div>
            </div>
        </div>
    </div>

    <!--弹出删除-->
    <div class="modal fade" id="del" data-backdrop="static" style="display: none;" aria-hidden="true">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                  <h5 class="modal-title">删除确认</h5>
                  <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                  </button>
                </div>
                <div class="modal-body">
                    <h5 class="text-danger">删除后无法恢复，确认是否删除？</h5>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
                    <a href="" class="btn btn-danger">删除</a>
                </div>
            </div>
        </div>
    </div>
    <!-- JS. -->
    <script src="lib/spreadjs/sheets/gc.spread.sheets.all.10.0.1.min.js"></script>
    <script src="lib/jquery/jquery.min.js"></script>
    <script src="lib/tether/tether.min.js"></script>
    <script src="lib/bootstrap/bootstrap.min.js"></script>
    <script src="web/billsLib/scripts/global.js"></script>
    <script src="web/billsLib/scripts/setSheets.js"></script>
    <script src="web/billsLib/scripts/billsLibAjax.js"></script>
    <!--idTree-->
    <script src="public/web/idTree.js"></script>
    <script src="public/web/tree_sheet_controller.js"></script>
    <script src="public/web/tree_sheet_helper.js"></script>
    <script src="web/billsLib/scripts/billsLibSetting.js"></script>
    <script src="web/billsLib/scripts/billsLibTree.js"></script>
    <!--<script src="test/tmp_data/data_15690.js"></script>-->
    <script src="test/tmp_data/bills_grid_setting.js"></script>
    <script src="web/billsLib/scripts/dbController.js"></script>
    <script src="web/billsLib/scripts/tools.js"></script>
</body>
<script type="text/javascript">
    autoFlashHeight();
    var billsTree = billsLibTree.createBillsTree();
    var billsLibId = getQueryString("billsLibId");
    var jobsSpread = new GC.Spread.Sheets.Workbook($("#spreadJobs")[0], {sheetCount: 1});
    var itemsSpread = new GC.Spread.Sheets.Workbook($("#spreadItems")[0], {sheetCount: 1});
    $(document).ready(function(){
        $("#aStdJobs").attr('href', function(){
            return 'stdJobs?billsLibId=' + billsLibId;
        });
        billsAjax.getStdBillsLibName(billsLibId);
        billsAjax.getBills(billsLibId, function(bills){
            showBillsSheet(bills, jobsSpread.getActiveSheet(), itemsSpread.getActiveSheet(), billsLibSetting)
        });
        buildJobs(jobsSpread);
        buildItems(itemsSpread);
    });
    //test
    //test


    function nodeOpration(controller){
        dbController.editData(controller, controller.sheet);
        $('#insert').click(function(){
            //controller.insert();
            dbController.insert(controller);
        });
        $('#delete').click(function(){
            //controller.delete();
            dbController.delete(controller);
        });
        $('#upLevel').click(function(){
          //   controller.upLevel();
            dbController.upLevel(controller);
        });
        $('#downLevel').click(function(){
           // controller.downLevel();
           dbController.downLevel(controller);
        });
        $('#upMove').click(function(){
           // controller.upMove();
            dbController.upMove(controller);
        });
        $('#downMove').click(function(){
          //  controller.downMove();
            dbController.downMove(controller);
        });
    }


    function showBillsSheet(datas, jobsSheet, itemsSheet, setting){
        var billsSpread = new GC.Spread.Sheets.Workbook($('#spreadBills')[0], {sheetCount: 1});
        initSheet(billsSpread);
        billsTree.loadDatas(datas);
        var controller = TREE_SHEET_CONTROLLER.createInit(billsTree.tree, billsSpread.getActiveSheet(), setting);
        controller.showTreeData();
        if(!controller.tree.selected && controller.tree.findNode(controller.sheet.getTag(0, 0, GC.Spread.Sheets.SheetArea.viewport))){
            controller.setTreeSelected(controller.tree.findNode(controller.sheet.getTag(0, 0, GC.Spread.Sheets.SheetArea.viewport)));
        }
        controller.bind('refreshBaseActn', function (tree) {
            var showButton = function (show, btn) {
                if (show) {
                    btn.show();
                } else {
                    btn.hide();
                }
            };
            showButton(tree.selected && tree.selected.canUpLevel(), $('#upLevel'));
            showButton(tree.selected && tree.selected.canDownLevel(), $('#downLevel'));
            showButton(tree.selected && tree.selected.canUpMove(), $('#upMove'));
            showButton(tree.selected && tree.selected.canDownMove(), $('#downMove'));
            showButton(tree.selected ? true : false, $('#delete'));
        });
        controller.setTreeSelected(controller.tree.findNode(controller.sheet.getTag(0,0)));
        nodeOpration(controller);

        /*var totalJobs = new TotalJobs(controller.tree);
        totalJobs.loadJobs(controller.tree.items);

        bindSheet(controller, jobsSheet, 'jobs', jobsSetting);
        jobsController(controller, jobsSheet, totalJobs, jobsSetting);*/

        mainAjax.getMaxNumber(billsLibId, 'jobs', function(maxNumber){
            var totalJobs = createObj.newJobs();
            totalJobs.loadJobs(controller.tree.items);
            bindSheet(controller, jobsSheet, 'jobs', jobsSetting);
            jobsController.editData(controller, jobsSheet, totalJobs, maxNumber, jobsSetting);
        });


        /*var totalItems = createObj.newItems();
        totalItems.loadItems(controller.tree.items);
        bindSheet(controller, itemsSheet, 'items', itemsSetting);
        itemsController.editData(controller, itemsSheet, totalItems, itemsSetting);*/


        //testNodeID:
        /*console.log('newNodeID: '+controller.tree.newNodeID());
        console.log('maxNodeID: '+controller.tree.maxNodeID());
        console.log('rangeNodeID: '+controller.tree.rangeNodeID());
        controller.tree.maxNodeID(100);
        console.log('newNodeID: '+controller.tree.newNodeID());*/
        //test
    }

    /*var Job = function(data){
        this.data = data;
    }

    var TotalJobs = function(tree){
        this.tree = tree;
        this.jobs = {};
        this.jobsArr = [];
        this.prefix = '_id';
    }

    TotalJobs.prototype.loadJobs = function (nodes){
        var me = this;
        jobsAjax.getJobContent(billsLibId, function(reslut){
            reslut.forEach(function(jobData){
                var job = new Job(jobData);
                me.jobs[me.prefix + jobData.id] = job;
                me.jobsArr.push(job);
            });
            nodes.forEach(function(node){
                node.data.jobs.forEach(function(data){
                    node.jobs.push(me.jobs[me.prefix + data.id]);
                });
            });
       });
    }

    TotalJobs.prototype.getUpdateIds = function(nodes, repeatId){
        var ids = [];
        nodes.forEach(function(node){
            node.jobs.forEach(function(job){
                if(job.data.id === repeatId){
                    ids.push(node.getID());
                }
            });
        });
        return ids;
    }

    //items
    var Item = function(data){
        this.data = data;
    }

    var TotalItems = function(tree){
        this.tree = tree;
        this.items = {};
        this.itemsArr = [];
        this.prefix = '_id';
    }

    TotalItems.prototype.loaditems = function (nodes){
        var me = this;
        itemsAjax.getItemCharacter(billsLibId, function(reslut){
            reslut.forEach(function(itemData){
                var item = new Item(itemData);
                me.items[me.prefix + itemData.id] = item;
                me.itemsArr.push(item);
            });
            nodes.forEach(function(node){
                node.data.items.forEach(function(data){
                    node.items.push(me.items[me.prefix + data.id]);
                });
            });
        });
    }

    TotalItems.prototype.getUpdateIds = function(nodes, repeatId){
        var ids = [];
        nodes.forEach(function(node){
            node.items.forEach(function(item){
                if(item.data.id === repeatId){
                    ids.push(node.getID());
                }
            });
        });
        return ids;
    }*/

    function bindSheet(controller, sheet, field, setting){
        controller.sheet.bind(GC.Spread.Sheets.Events.SelectionChanged, function(sender, args){
            if(controller.tree.selected && args.oldSelections[0].row !== args.newSelections[0].row|| controller.tree.selected && args.oldSelections[0].row === 0){
                sheet.clear(0, 0, sheet.getRowCount(), sheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport,GC.Spread.Sheets.StorageType.data);
                sheet.clear(0, 0, sheet.getRowCount(), sheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport,GC.Spread.Sheets.StorageType.tag);
                if(field === 'jobs'){
                    var jobs = controller.tree.selected.jobs;
                    if(jobs.length > 0){
                        for(var i=0; i<jobs.length; i++){
                            setting.cols.forEach(function(col, cidx){
                                sheet.setTag(i, cidx, jobs[i].data.id, GC.Spread.Sheets.SheetArea.viewport);
                                if(jobs[i].data[col.data.field]){
                                    sheet.getCell(i, cidx, GC.Spread.Sheets.SheetArea.viewport).value(jobs[i].data[col.data.field]);
                                }
                                else {
                                    sheet.getCell(i, cidx, GC.Spread.Sheets.SheetArea.viewport).value('');
                                }
                            });
                        }
                    }
                }
                if(field === 'items'){
                    var items = controller.tree.selected.items;
                    if(items.length > 0){
                        for(var i=0; i<items.length; i++){
                            setting.cols.forEach(function(col, cidx){
                                sheet.setTag(i, cidx, items[i].data.id, GC.Spread.Sheets.SheetArea.viewport);
                                if(items[i].data[col.data.field]){
                                    sheet.getCell(i, cidx, GC.Spread.Sheets.SheetArea.viewport).value(items[i].data[col.data.field]);
                                }
                                else {
                                    sheet.getCell(i, cidx, GC.Spread.Sheets.SheetArea.viewport).value('');
                                }
                            });
                        }
                    }
                }
            }
        });
    }

/*    function jobsController(controller, sheet, totalJobs, setting){
        var orgData;
        sheet.bind(GC.Spread.Sheets.Events.EnterCell, function(sender, args){
            orgData = sheet.getCell(args.row, args.col).value();
        });
        sheet.bind(GC.Spread.Sheets.Events.EditEnded, function(sender, args){
            var field, newData = args.editingText, id = sheet.getTag(args.row, args.col) ;
            setting.cols.forEach(function(col, idx){
                if(args.col === idx){
                    field = col.data.field;
                }
            });
            if(controller.tree.selected){
                var isExist = false;
                var isRepeat = false;
                //isRepeat?
                if(controller.tree.selected.jobs){
                    controller.tree.selected.jobs.forEach(function(job){
                        if(job.data[field] === newData && id !== job.data.id){
                            isRepeat = true;
                        }
                    });
                }
                //create
                if(!id && newData && !isRepeat){
                    if(totalJobs.jobsArr.length > 0){
                        totalJobs.jobsArr.forEach(function(job){
                            //todo:整合代码
                            if(field === 'content'&& newData === job.data.content){
                                console.log('ECreate1');
                                isExist = true;
                                billsAjax.updateBills(billsLibId, controller.tree.selected.getID(), 'jobs', job.data);
                                if(!controller.tree.selected.jobs){
                                    controller.tree.selected.jobs = new Array();
                                }
                                controller.tree.selected.jobs.push(job);
                                sheet.getCell(args.row, 0).value(job.data.code);
                                sheet.setTag(args.row, 0, job.data.id);
                                sheet.setTag(args.row, 1, job.data.id);
                            }
                            else if(field === 'code' && newData === job.data.code){
                                console.log('ECreate2');
                                isExist = true;
                                billsAjax.updateBills(billsLibId, controller.tree.selected.getID(), 'jobs', job.data);
                                if(!controller.tree.selected.jobs){
                                    controller.tree.selected.jobs = new Array();
                                }
                                controller.tree.selected.jobs.push(job);
                                sheet.getCell(args.row, 1).value(job.data.content);
                                sheet.setTag(args.row, 0, job.data.id);
                                sheet.setTag(args.row, 1, job.data.id);
                            }
                        });
                        if(!isExist){
                            console.log('notEcreate');
                            jobsAjax.createJobContent(billsLibId, field, newData, function(id){
                                var newJobData, newJob;
                                if(field === 'code'){
                                    newJobData = {id: id, code: newData, content: ''};
                                }
                                else {
                                    newJobData = {id: id, content: newData, code: ''};
                                }
                                newJob = new Job(newJobData);
                                totalJobs.jobs[totalJobs.prefix + id] = newJob;
                                totalJobs.jobsArr.push(newJob);
                                billsAjax.updateBills(billsLibId, controller.tree.selected.getID(), 'jobs', newJobData);
                                if(!controller.tree.selected.jobs){
                                    controller.tree.selected.jobs = new Array();
                                }
                                controller.tree.selected.jobs.push(newJob);
                                sheet.setTag(args.row, 0, id);
                                sheet.setTag(args.row, 1, id);
                            });
                        }
                    }
                    else {
                        console.log('0create '+totalJobs.jobsArr.length);
                        jobsAjax.createJobContent(billsLibId, field, newData, function(id){
                            var newJobData, newJob;
                            if(field === 'code'){
                                newJobData = {id: id, code: newData, content: ''};
                            }
                            else {
                                newJobData = {id: id, content: newData, code: ''};
                            }
                            newJob = new Job(newJobData);
                            totalJobs.jobs[totalJobs.prefix + id] = newJob;
                            totalJobs.jobsArr.push(newJob);
                            billsAjax.updateBills(billsLibId, controller.tree.selected.getID(), 'jobs', newJobData);
                            if(!controller.tree.selected.jobs){
                                controller.tree.selected.jobs = new Array();
                            }
                            controller.tree.selected.jobs.push(newJob);
                            sheet.setTag(args.row, 0, id);
                            sheet.setTag(args.row, 1, id);
                        });
                    }
                }
                //update
                else if(id && newData !== orgData && !isRepeat){
                    console.log('update');
                    var ids = totalJobs.getUpdateIds(controller.tree.items, id);
                    totalJobs.jobs[totalJobs.prefix + id].data[field] = newData;
                    jobsAjax.updateJobContent(id, field, newData);
                    billsAjax.updateBillsArr(billsLibId, ids, field, id, newData);
                }
                if(isRepeat){
                    //todo:redirect focus
                    if(id && newData){
                        console.log('isRepeat1 orgData:'+orgData);
                        sheet.getCell(args.row, args.col, GC.Spread.Sheets.SheetArea.viewport).value(orgData);
                    }
                    else {
                        console.log('isRepeat2');
                        sheet.getCell(args.row, args.col, GC.Spread.Sheets.SheetArea.viewport).value('');
                    }
                }
                //delete


            }
        });

    }*/

    function buildJobs(jobsSpread){
        initSheet(jobsSpread);
        TREE_SHEET_HELPER.loadSheetHeader(jobsSetting, jobsSpread.getActiveSheet());
    }

    function buildItems(itemsSpread){
        initSheet(itemsSpread);
        TREE_SHEET_HELPER.loadSheetHeader(itemsSetting, itemsSpread.getActiveSheet());
    }


</script>

</html>