123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367 |
- <!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 class="nav-link active px-3" href="javascript: void(0);">工作内容</a>
- </li>
- <li class="nav-item">
- <a id="aStdItems" class="nav-link px-3" href="stdItems">项目特征</a>
- </li>
- </ul>
- </nav>
- </div>
- <div class="main">
- <div class="content">
- <div class="container-fluid">
- <div class="row">
- <div class="main-content col-lg-12 p-0">
- <nav class="tools-bar">
- </nav>
- <div class="main-data" id="spreadAllJobs">
- </div>
- </div>
- <!-- <div class="main-side col-lg-5 p-0">
- </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 billsLibId = getQueryString("billsLibId");
- tools.redirect(billsLibId, 'stdBillsmain');
- let userAccount = '<%= userAccount%>'
- let spreadAllJobs = new GC.Spread.Sheets.Workbook($('#spreadAllJobs')[0], {sheetCount: 1});
- sheetCommonObj.bindEscKey(spreadAllJobs, [{sheet: spreadAllJobs.getSheet(0), editStarting: totalJobsController.onEditStart, editEnded: totalJobsController.onEditEnded}]);
- let orgJobData;
- let maxJobNumer;
- let maxJobsNumber;
- let sheetJobsDatas;
- $(document).ready(function(){
- $('#aStdBills').attr('href', function(){
- return `stdBills?billsLibId=${billsLibId}&locked=${locked}`;
- });
- $('#aStdItems').attr('href', function(){
- return `stdItems?billsLibId=${billsLibId}&locked=${locked}`;
- });
- billsAjax.getStdBillsLibName(billsLibId);
- buildAllJobs(spreadAllJobs, totalJobsSetting);
- lockUtil.lockSpreads([spreadAllJobs], locked);
- });
- function buildAllJobs(spreadAllJobs, setting){
- setSheet.initSheet(spreadAllJobs, setting, true);
- myKey.downKey(spreadAllJobs);
- myKey.enterKey(spreadAllJobs);
- TREE_SHEET_HELPER.loadSheetHeader(setting, spreadAllJobs.getActiveSheet());
- jobsAjax.getJobContent(billsLibId, function(datas){
- spreadAllJobs.getActiveSheet().suspendPaint();
- spreadAllJobs.getActiveSheet().setRowCount(datas.length + 10);
- let len = datas.length;
- for(var i=0; i<len; i++){
- setting.cols.forEach(function(col, colIdx){
- spreadAllJobs.getActiveSheet().setTag(i, colIdx, datas[i].id, GC.Spread.Sheets.SheetArea.viewport);
- if(datas[i][col.data.field]){
- spreadAllJobs.getActiveSheet().getCell(i, colIdx, GC.Spread.Sheets.SheetArea.viewport).value(datas[i][col.data.field]);
- }
- else {
- spreadAllJobs.getActiveSheet().getCell(i, colIdx, GC.Spread.Sheets.SheetArea.viewport).value('');
- }
- });
- }
- spreadAllJobs.getActiveSheet().resumePaint();
- let totalJobs = createObj.newJobs();
- totalJobs.loadJobs(null, datas);
- totalJobsController.totalJobs = totalJobs;
- tools.getBillsIds(function(ids){
- myKey.delKey(spreadAllJobs, ids, totalJobs, setting, 'totalJobs');
- bindSheet(totalJobs, spreadAllJobs.getActiveSheet(), setting);
- pasteJobs(spreadAllJobs.getActiveSheet(), totalJobs);
- });
- });
- }
- function bindSheet(totalJobs, sheet, setting){
- setSheet.setMaxRowCount(sheet, totalJobs.jobsArr);
- mainAjax.getMaxNumber(billsLibId, 'jobs', function(result){
- if(result.length === 0){
- maxJobsNumber = 0;
- }
- else {
- maxJobsNumber = result[0].code;
- }
- orgJobData = sheet.getCell(0, 0).value();
- totalJobsController.editData(sheet);
- });
- }
- function pasteJobs(sheet, totalJobs){
- // sheetJobsDatas = tools.getsheetDatas(sheet, 'total');
- sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
- sheetJobsDatas = tools.getsheetDatas(sheet, 'total');
- let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
- //复制的列数超过正确的列数,不可复制
- if(maxCol >= totalJobsSetting.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;
- sheetJobsDatas.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.encapTotalJobsDatas(sheet, totalJobs, uncrossedDatas, crossedDatas);
- if(encapDatas.updateDatas.length > 0 || encapDatas.createDatas.length >0){
- jobsAjax.pasteJobs(userAccount, billsLibId, encapDatas, function(datas){
- pasteController.pasteJobsFront(sheet, totalJobs,datas);
- });
- }
- else{
- tools.reshowData(sheet, totalJobs.jobsArr, totalJobsSetting, true);
- }
- });
- }
- </SCRIPT>
- </body>
- <script type="text/javascript">
- autoFlashHeight();
- </script>
- </html>
|