SmartCost
/
YangHuOperation


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498
							<!DOCTYPE html>
<html lang="zh-CN">

<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="/lib/bootstrap/css/bootstrap.min.css">
    <!--<link rel="stylesheet" href="../../web/css/bootstrap/themes.css">-->
    <link rel="stylesheet" href="/web/maintain/bills_lib/css/main.css">
    <link rel="stylesheet" href="/lib/font-awesome/font-awesome.min.css">
    <!--spread-->
    <link rel="stylesheet" href="/lib/spreadjs/sheets/css/gc.spread.sheets.sc.css">
    <!--zTree-->
    <link rel="stylesheet" href="/lib/ztree/css/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 id="aStdBills" class="nav-link px-3" href="stdBills">清单</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 active px-3" href="javascript: void(0);">项目特征</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="tools-bar"></nav>
              <div class="main-data" id="spreadAllItems">
            </div>
            </div>
            <div class="main-side col-lg-5 p-0">
              <div class="main-data" id="spreadEigenvalue" >
              </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>
    <!--弹出提示窗口-->
    <button id="alertBtn" class="btn btn-primary btn-lg" data-toggle="modal" data-target="#alertDiv" style="display: none"></button>
    <div class="modal fade" id="alertDiv" data-backdrop="static" style="display: none;" aria-hidden="true">
        <input type="hidden"  value="123">
        <div class="modal-dialog" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">警告</h5>
                    <button type="button" id="alertCls" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">×</span>
                    </button>
                </div>
                <div class="modal-body">
                    <h5 class="text-danger" id="alertTxt">编号不存在，请重新输入！</h5>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-danger" id="alertCof" data-dismiss="modal">确认</button>
                </div>
            </div>
        </div>
    </div>
    <!--删除-->
    <div class="modal fade" id="delAlert" data-backdrop="static" style="display: none;" aria-hidden="true">
        <input type="hidden"  value="123">
        <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" id="delText">是否删除当前行？</h5>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-danger" id="delConfirm">确认</button>
                    <button type="button" class="btn btn-secondary"  data-dismiss="modal">取消</button>
                </div>
            </div>
        </div>
    </div>
    <!-- JS. -->
    <script src = "/lib/spreadjs/sheets/gc.spread.sheets.all.11.1.2.min.js"></script>
    <script>GC.Spread.Sheets.LicenseKey =  '<%- LicenseKey %>';</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/maintain/bills_lib/scripts/global.js"></script>
    <script src="/public/web/PerfectLoad.js"></script>
    <script src="/public/web/common_ajax.js"></script>
    <script src="/public/web/lock_util.js"></script>
    <script src="/public/web/sheet/sheet_common.js"></script>
    <script src="/web/maintain/bills_lib/scripts/set_sheets.js"></script>
    <script src="/web/maintain/bills_lib/scripts/bills_lib_ajax.js"></script>
    <script src="/web/maintain/bills_lib/scripts/tools.js"></script>
    <script src="/public/web/tree_sheet/tree_sheet_helper.js"></script>
    <script src="/web/maintain/bills_lib/scripts/bills_lib_setting.js"></script>
    <script src="/web/maintain/bills_lib/scripts/db_controller.js"></script>
    <SCRIPT type="text/javascript">
        const locked = lockUtil.getLocked();
        let spread = new GC.Spread.Sheets.Workbook($('#spreadAllItems')[0], {sheetCount: 1});
        sheetCommonObj.bindEscKey(spread, [{sheet: spread.getSheet(0), editStarting: totalItemsController.onEditStart, editEnded: totalItemsController.onEditEnded}]);
        let spreadVal = new GC.Spread.Sheets.Workbook($('#spreadEigenvalue')[0], {sheetCount: 1});
        sheetCommonObj.bindEscKey(spreadVal, [{sheet: spreadVal.getSheet(0), editStarting: valueController.onEditStart, editEnded: valueController.onEditEnded}])
        let billsLibId = getQueryString('billsLibId');
        tools.redirect(billsLibId, 'stdBillsmain');
        let userAccount = '<%= userAccount%>'
        let selectedId;
        let orgValue;
        let orgItemData;
        let maxItemsNumber;
        let totalItemsDatas;
        let valueDatas;
  		$(document).ready(function(){
            $('#aStdBills').attr('href', function(){
                return `stdBills?billsLibId=${billsLibId}&locked=${locked}`;
            });
            $('#aStdJobs').attr('href', function(){
                return `stdJobs?billsLibId=${billsLibId}&locked=${locked}`;
            });

            billsAjax.getStdBillsLibName(billsLibId);
            buildAllItems(spread, totalItemsSetting);
            buildEigenvalue(spreadVal, eigenValueSetting);
            lockUtil.lockSpreads([spread, spreadVal], locked);
  		});
        function buildAllItems(spread, setting){
            setSheet.initSheet(spread, setting, true);
            myKey.downKey(spread);
            myKey.enterKey(spread);
            TREE_SHEET_HELPER.loadSheetHeader(setting, spread.getActiveSheet());
            itemsAjax.getItemCharacter(billsLibId, function(datas){
                spread.getActiveSheet().suspendPaint();
                spread.getActiveSheet().setRowCount(datas.length + 10);
                let len = datas.length;
                for(var i=0; i<len; i++){
                    if(datas[0].id){
                        selectedId = datas[0].id;
                    }
                    totalItemsSetting.cols.forEach(function(col, colIdx){
                        spread.getActiveSheet().setTag(i, colIdx, datas[i].id, GC.Spread.Sheets.SheetArea.viewport);
                        if(datas[i][col.data.field]){
                            spread.getActiveSheet().getCell(i, colIdx, GC.Spread.Sheets.SheetArea.viewport).value(datas[i][col.data.field]);
                        }
                        else {
                            spread.getActiveSheet().getCell(i, colIdx, GC.Spread.Sheets.SheetArea.viewport).value('');
                        }
                    });
                }
                spread.getActiveSheet().resumePaint();
                spread.getActiveSheet().resumeEvent();
                //
                var totalItems = createObj.newItems();
                totalItems.loadItems(null, datas);
                totalItemsController.totalItems = totalItems;
                initValue(spreadVal.getActiveSheet(), totalItems, eigenValueSetting);
                tools.getBillsIds(function(ids){
                    myKey.delKey(spread, ids, totalItems, totalItemsSetting, 'totalItems');
                    myKey.delKey(spreadVal, null, totalItems, eigenValueSetting, 'itemValue');
                    bindSheet(totalItems, spread.getActiveSheet(), spreadVal.getActiveSheet(), totalItemsSetting);
                    pasteItems(spread.getActiveSheet(), totalItems);
                    pasteValue(spreadVal.getActiveSheet(), totalItems);
                });
            });
        }

        function buildEigenvalue(spread, setting){
            setSheet.initSheet(spread, setting, false);
            setSheet.setMaxRowCount(spread.getActiveSheet(), 10);
           // setSheet.setEditCol(spread.getActiveSheet(), 1);
            myKey.downKey(spread);
            myKey.enterKey(spread);
            TREE_SHEET_HELPER.loadSheetHeader(setting, spread.getActiveSheet());
        }

        function bindSheet(totalItems, itemSheet, valueSheet, setting){
            setSheet.setMaxRowCount(itemSheet, totalItems.itemsArr);
            mainAjax.getMaxNumber(billsLibId, 'items', function(result){
                if(result.length === 0){
                    maxItemsNumber = 0;
                }
                else {
                    maxItemsNumber = result[0].code;
                }
                orgItemData = itemSheet.getCell(0, 0).value();
                totalItemsController.editData(itemSheet);
            });
            valueController.editData(valueSheet);
            itemSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, function(sender, args){
                let itemId = itemSheet.getTag(args.newSelections[0].row, args.newSelections[0].col, GC.Spread.Sheets.SheetArea.viewport);
                if(itemId && args.oldSelections[0].row !== args.newSelections[0].row|| itemId && args.oldSelections[0].row === 0){
                    let valueArr = valueController.getValues(totalItems, itemId);
                    tools.clearData(valueSheet);
                    selectedId = itemId;
                    if(valueArr){
                        setSheet.setMaxRowCount(valueSheet, valueArr);
                        tools.reshowValue(valueSheet, valueArr, eigenValueSetting, true);
                    }
                    orgValue = valueSheet.getValue(0, 0);
                }
                else {
                    tools.clearData(valueSheet);
                }
            });
        }

        function initValue(sheet, totalItems, setting){
            if(selectedId){
                let valueArr = valueController.getValues(totalItems, selectedId);
                if(valueArr.length > 0){
                    setSheet.setMaxRowCount(sheet, valueArr);
                    tools.reshowValue(sheet, valueArr, setting, true);
                }
            }
            else{
                    setSheet.setMaxRowCount(sheet, []);
            }
        }

        function pasteItems(sheet, totalItems){
            //totalItemsDatas = tools.getsheetDatas(sheet, 'total');
            sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
                totalItemsDatas = tools.getsheetDatas(sheet, 'total');
                let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
                //复制的列数超过正确的列数，不可复制
                if(maxCol >= totalItemsSetting.cols.length){
                    args.cancel = true;
                }
            });
            sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
                const colIdx = 1;
                let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
                let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
                let pasteDatas = [], uncrossedDatas = [], crossedDatas = [];
                for(let i = orgRow; i<= maxRow; i++){
                    for(let j =0; j<=1; j++){
                        let filed = j === 0 ? 'code' : 'content';
                        if(sheet.getCell(i, j).value()){
                            let unitData = {
                                billsLibId: billsLibId,
                                rowIdx: i,
                                colIdx: j,
                                field: filed,
                                data: sheet.getCell(i, j).value(),
                                type:  'Create'
                            };
                            pasteDatas.push(unitData);
                        }
                    }
                }
                let uniqPasteDatas = tools.uniqObjArr(pasteDatas);
                tools.resetRowIdx(uniqPasteDatas, orgRow);
                for(let i=0; i< uniqPasteDatas.length; i++){
                    let crossedData;
                    let flag = true;
                    totalItemsDatas.forEach(function(orgData){
                        if(uniqPasteDatas[i].rowIdx === orgData.rowIdx && uniqPasteDatas[i].colIdx === orgData.colIdx){
                            flag = false;
                            crossedData = {
                                billsLibId: billsLibId,
                                rowIdx: uniqPasteDatas[i].rowIdx,
                                colIdx: uniqPasteDatas[i].colIdx,
                                field: uniqPasteDatas[i].field,
                                orgId: orgData.id,
                                data: uniqPasteDatas[i].data,
                                type: 'Update'
                            }
                        }
                    });
                    if(flag){
                        uncrossedDatas.push(uniqPasteDatas[i]);
                    }
                    else{
                        crossedDatas.push(crossedData);
                    }
                }
                let encapDatas = tools.encapTotalItemsDatas(sheet, totalItems, uncrossedDatas, crossedDatas);
                if(encapDatas.updateDatas.length > 0 || encapDatas.createDatas.length > 0){
                    itemsAjax.pasteItems(userAccount, billsLibId, encapDatas, function(datas){
                        pasteController.pasteItemsFront(sheet, totalItems, datas);
                    });
                }
                else{
                    tools.reshowData(sheet, totalItems.itemsArr, totalItemsSetting, true);
                }
            });
        }

        function pasteValue(sheet, totalItems){
            sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
                valueDatas = tools.getsheetDatas(sheet, 'total');
                let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
                //复制的列数超过正确的列数，不可复制
                if(maxCol >= eigenValueSetting.cols.length){
                    args.cancel = true;
                }
            });

            sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
                const colIdx = 1;
                let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
                let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
                let pasteDatas = [], uncrossedDatas = [], crossedDatas = [];
                for(let i = orgRow; i<= maxRow; i++){
                    for(let j =0; j<=1; j++){
                        let filed = j === 0 ? 'code' : 'value';
                        if(sheet.getCell(i, j).value()){
                            let unitData = {
                                billsLibId: billsLibId,
                                rowIdx: i,
                                colIdx: j,
                                field: filed,
                                data: sheet.getCell(i, j).value(),
                                type:  'Create'
                            };
                            pasteDatas.push(unitData);
                        }
                    }
                }
                let uniqDatas = tools.uniqObjArr(pasteDatas);
                for(let i=0; i< uniqDatas.length; i++){
                    let crossedData;
                    let flag = true;
                    valueDatas.forEach(function(orgData){
                        if(uniqDatas[i].rowIdx === orgData.rowIdx && uniqDatas[i].colIdx === orgData.colIdx){
                            flag = false;
                            crossedData = {
                                billsLibId: billsLibId,
                                rowIdx: uniqDatas[i].rowIdx,
                                colIdx: uniqDatas[i].colIdx,
                                field: uniqDatas[i].field,
                                orgId: orgData.id,
                                data: uniqDatas[i].data,
                                type: 'Update'
                            }
                        }
                    });
                    if(flag){
                        uncrossedDatas.push(uniqDatas[i]);
                    }
                    else{
                        crossedDatas.push(crossedData);
                    }
                }
                let encapDatas = tools.encapValues(sheet, totalItems, uncrossedDatas, crossedDatas);
                console.log(encapDatas);
                if(encapDatas.updateDatas.length > 0 || encapDatas.createDatas.length > 0){
                    itemsAjax.pasteValues(userAccount, billsLibId, encapDatas, function(datas){
                        pasteController.pasteValueFront(sheet, totalItems, datas);
                    });
                }
                else{
                    let valuesArr = valueController.getValues(totalItems, selectedId);
                    if(valuesArr.length > 0){
                        tools.reshowValue(sheet, valuesArr, eigenValueSetting, true);
                    }
                    else {
                        tools.clearData(sheet);
                    }
                }
            });
        }

  	</SCRIPT>
</body>
<script type="text/javascript">
    autoFlashHeight();
</script>

</html>