1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012 |
- <!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/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">
- <link rel="stylesheet" href="/lib/codemirror/codemirror.css">
- <link rel="stylesheet" href="/lib/codemirror/material.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 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-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 lock-btn-control" doing="false" fcsOnBills="true" 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 lock-btn-control" doing="false" fcsOnBills="true" 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 lock-btn-control" doing="false" fcsOnBills="true" 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 lock-btn-control" doing="false" fcsOnBills="true" 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 lock-btn-control" doing="false" fcsOnBills="true" canMove="false" 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 lock-btn-control" doing="false" fcsOnBills="true" canMove="false" 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>
- </div>
- <div class="main-side col-lg-5 p-0">
- <div class="container-fluid">
- <div style="width:50%; height: 100%; float: left;">
- <h5>工作内容</h5>
- <div id="spreadJobs" class="ovf-hidden" style="width:97%; height: 300px;"></div>
- </div>
- <div style="width:50%; height: 100%; float: left;">
- <h5>项目特征</h5>
- <div id="spreadItems" class="ovf-hidden" style="width: 97%; height: 300px;"></div>
- </div>
- <!-- <div class="form-group">
- <a class="pull-right" href="javacript:void(0);" data-toggle="modal" data-target="#help" >html怎么写?</a>
- <label for="exampleTextarea">补注:</label>
- <textarea id="exampleTextarea" name="editor" class="form-control" rows="8"></textarea>
- </div>-->
- <div class="form-group">
- <a class="pull-right" href="javacript:void(0);" data-toggle="modal" data-target="#help" >html怎么写?</a>
- <a trigger="billsRecharge" class="pull-right mr-3 uploadImgTrigger lock-btn-control" href="javacript:void(0);" data-toggle="modal" data-target="#uploadimg" ><i class="fa fa-image"></i>上传图片</a>
- <label for="exampleTextarea">补注:</label>
- <textarea class="form-control" id="exampleTextarea" rows="8"></textarea>
- </div>
- <!-- <div class="row">
- <div class="col ovf-hidden" style="width:50%; height: 100%; float: left;">
- <h5>工作内容</h5>
- <div id="spreadJobs" style="width:97%; height: 300px;"></div>
- </div>
- <div class="col" style="width:50%; height: 100%; float: left;">
- <h5>项目特征</h5>
- <div id="spreadItems" class="ovf-hidden" 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>
- <!--弹出提示窗口-->
- <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>
- <!--弹出html填写帮助-->
- <!--弹出html填写帮助-->
- <div class="modal fade" id="help" style="display: none;" aria-hidden="true">
- <div class="modal-dialog" role="document">
- <div class="modal-content">
- <div class="modal-header">
- <h5 class="modal-title">html填写帮助</h5>
- <button type="button" class="close" data-dismiss="modal" aria-label="Close">
- <span aria-hidden="true">×</span>
- </button>
- </div>
- <div class="modal-body">
- <p class="text-primary"><p>这是一行文本</p></p>
- <p class="mb-0">文本居中:text-center</p>
- <p class="text-primary"><p class="text-center" >这是一行文本</p></p>
- <p class="mb-0">文本居右:text-right</p>
- <p class="text-primary"><p class="text-right" >这是一行文本</p></p>
- <p class="mb-0">文本居左(默认已居左):text-left</p>
- <p class="text-primary"><p class="text-left" >这是一行文本</p></p>
- <p class="mb-0">表格:table、tr、th、td</p>
- <p class="mb-0 text-primary"><table></p>
- <p class="mb-0 text-primary"><tr><th>表头1</th><th>表头2</th><th>表头3</th></tr></p>
- <p class="mb-0 text-primary"><tr><td>内容1</td><td>内容2</td><td>内容3</td></tr></p>
- <p class="mb-0 text-primary"><tr><td>内容4</td><td>内容5</td><td>内容6</td></tr></p>
- <p class="mb-0 text-primary"></table></p>
- <p>
- <table class="table table-sm table-bordered">
- <tr><th>表头1</th><th>表头2</th><th>表头3</th></tr>
- <tr><td>内容1</td><td>内容2</td><td>内容3</td></tr>
- <tr><td>内容4</td><td>内容5</td><td>内容6</td></tr>
- </table>
- </p>
- <p class="mb-0">合并横向单元格(2格):colspan="2"</p>
- <p class="mb-0 text-primary"><table></p>
- <p class="mb-0 text-primary"><tr><th colspan="2">表头1表头2</th><th>表头3</th></tr></p>
- <p class="mb-0 text-primary"><tr><td>内容1</td><td>内容2</td><td>内容3</td></tr></p>
- <p class="mb-0 text-primary"><tr><td>内容4</td><td>内容5</td><td>内容6</td></tr></p>
- <p class="mb-0 text-primary"></table></p>
- <p>
- <table class="table table-sm table-bordered">
- <tr><th colspan="2">表头1表头2</th><th>表头3</th></tr>
- <tr><td>内容1</td><td>内容2</td><td>内容3</td></tr>
- <tr><td>内容4</td><td>内容5</td><td>内容6</td></tr>
- </table>
- </p>
- <p class="mb-0">合并竖向单元格(2格):rowspan="2"</p>
- <p class="mb-0 text-primary"><table></p>
- <p class="mb-0 text-primary"><tr><th>表头1</th><th>表头2</th><th>表头3</th></tr></p>
- <p class="mb-0 text-primary"><tr><td rowspan="2">内容1内容4</td><td>内容2</td><td>内容3</td></tr></p>
- <p class="mb-0 text-primary"><tr><td>内容5</td><td>内容6</td></tr></p>
- <p class="mb-0 text-primary"></table></p>
- <p>
- <table class="table table-sm table-bordered">
- <tr><th>表头1</th><th>表头2</th><th>表头3</th></tr>
- <tr><td rowspan="2">内容1内容4</td><td>内容2</td><td>内容3</td></tr>
- <tr><td>内容5</td><td>内容6</td></tr>
- </table>
- </p>
- </div>
- <div class="modal-footer">
- <button type="button" class="btn btn-secondary" data-dismiss="modal">关闭</button>
- </div>
- </div>
- </div>
- </div>
- <%include ../../../common/html/uploadImg.html %>
- <!-- 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="/public/web/uuid.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/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>
- <!--idTree-->
- <script src="/public/web/id_tree.js"></script>
- <script src="/public/web/tree_sheet/tree_sheet_controller.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/bills_lib_tree.js"></script>
- <script src="/web/maintain/bills_lib/scripts/db_controller.js"></script>
- <script src="/web/maintain/bills_lib/scripts/tools.js"></script>
- <script src="/lib/codemirror/codemirror.js"></script>
- <script src="/lib/codemirror/xml.js"></script>
- <script src="/web/common/js/uploadImg.js"></script>
- </body>
- <script type="text/javascript">
- const locked = lockUtil.getLocked();
- var codeEditor = CodeMirror.fromTextArea(document.getElementById("exampleTextarea"), {
- mode: "text/html",
- lineNumbers: true,
- theme:"material",
- readOnly: locked
- });
- codeEditor.setSize('auto','350px');
- autoFlashHeight();
- let BillsFixedFlagList = JSON.parse('<%- BillsFixedFlagList %>');
- let userAccount = '<%= userAccount %>';
- let maxJobsNumber;
- let maxItemsNumber;
- let orgJobData;
- let orgItemData;
- let billsTree = billsLibTree.createBillsTree();
- let billsLibId = getQueryString("billsLibId");
- let sheetDatas;
- let sheetItemsDatas;
- let sheetBillsDatas;
- tools.redirect(billsLibId, 'stdBillsmain');
- let billsSpread;
- let jobsSpread = new GC.Spread.Sheets.Workbook($("#spreadJobs")[0], {sheetCount: 1});
- sheetCommonObj.bindEscKey(jobsSpread, [{sheet: jobsSpread.getSheet(0), editStarting: jobsController.onEditStart, editEnded: jobsController.onEditEnded}]);
- let itemsSpread = new GC.Spread.Sheets.Workbook($("#spreadItems")[0], {sheetCount: 1});
- sheetCommonObj.bindEscKey(itemsSpread, [{sheet: itemsSpread.getSheet(0), editStarting: itemsController.onEditStart, editEnded: itemsController.onEditEnded}]);
- $(document).ready(function(){
- $("#aStdJobs").attr('href', function(){
- return `stdJobs?billsLibId=${billsLibId}&locked=${locked}`;
- });
- $('#aStdItems').attr('href', function(){
- return `stdItems?billsLibId=${billsLibId}&locked=${locked}`;
- });
- billsAjax.getStdBillsLibName(billsLibId);
- billsAjax.getBills(billsLibId, function(bills){
- showBillsSheet(bills, jobsSpread.getActiveSheet(), itemsSpread.getActiveSheet(), billsLibSetting)
- const spreads = [billsSpread, jobsSpread, itemsSpread];
- const $range = $(document.body);
- lockUtil.lockSpreadsAndTools(spreads, $range, locked);
- });
- buildJobs(jobsSpread, jobsSetting);
- buildItems(itemsSpread, itemsSetting);
- });
- function nodeOpration(controller, totalJobs, totalItems){
- let btnInsert = $('#insert');
- let btnDelete = $('#delete');
- let btnUpLevel = $('#upLevel');
- let btnDownLevel = $('#downLevel');
- let btnUpMove = $('#upMove');
- let btnDownMove = $('#downMove');
- dbController.editData(controller);
- btnInsert.click(function(){
- if(btnInsert.attr('doing') === 'false' && btnInsert.attr('fcsOnBills') === 'true'){
- dbController.insert(controller, btnInsert);
- tools.clearData(jobsSpread.getActiveSheet());
- tools.clearData(itemsSpread.getActiveSheet());
- }
- });
- //删除清单
- $('#delConfirm').click(function () {
- dbController.delete(controller, btnDelete, totalJobs, totalItems);
- $('#delAlert').modal('hide');
- });
- btnDelete.click(function(){
- if(btnDelete.attr('doing') === 'false' && btnDelete.attr('fcsOnBills') === 'true'){
- $('#delAlert').modal('show');
- }
- });
- btnUpLevel.click(function(){
- if(btnUpLevel.attr('doing') === 'false' && btnUpLevel.attr('fcsOnBills') === 'true'){
- dbController.upLevel(controller, btnUpLevel);
- }
- });
- btnDownLevel.click(function(){
- if(btnDownLevel.attr('doing') === 'false' && btnDownLevel.attr('fcsOnBills') === 'true'){
- dbController.downLevel(controller, btnDownLevel);
- }
- });
- btnUpMove.click(function(){
- if(btnUpMove.attr('doing') === 'false' && btnUpMove.attr('fcsOnBills') === 'true'){
- dbController.upMove(controller, btnUpMove);
- }
- //refSheet
- else if(btnUpMove.attr('doing') === 'false' && btnUpMove.attr('fcsOnBills') === 'false' && btnUpMove.attr('canMove') === 'true'){
- if(controller.tree.selected.field === 'job'){
- jobsController.upMove(controller, jobsSpread.getActiveSheet());
- }
- else if(controller.tree.selected.field === 'item'){
- itemsController.upMove(controller, itemsSpread.getActiveSheet());
- }
- }
- });
- btnDownMove.click(function(){
- if(btnDownMove.attr('doing') === 'false' && btnDownMove.attr('fcsOnBills') === 'true'){
- dbController.downMove(controller, btnDownMove);
- }
- else if(btnDownMove.attr('doing') === 'false' && btnDownMove.attr('fcsOnBills') === 'false' && btnDownMove.attr('canMove') === 'true'){
- if(controller.tree.selected.field === 'job'){
- jobsController.downMove(controller, jobsSpread.getActiveSheet());
- }
- else if(controller.tree.selected.field === 'item'){
- itemsController.downMove(controller, itemsSpread.getActiveSheet());
- }
- }
- });
- }
- function setCombo(sheet, col, comboDatas) {
- sheet.suspendPaint();
- sheet.suspendEvent();
- let combo = sheetCommonObj.getDynamicCombo();
- combo.items(comboDatas).itemHeight(10).editable(false);
- sheet.getRange(-1, col, -1, 1).cellType(combo);
- sheet.resumePaint();
- sheet.resumeEvent();
- }
- function showBillsSheet(datas, jobsSheet, itemsSheet, setting) {
- billsSpread = new GC.Spread.Sheets.Workbook($('#spreadBills')[0], {sheetCount: 1});
- let billsSheet = billsSpread.getSheet(0);
- sheetCommonObj.bindEscKey(billsSpread, [{sheet: billsSpread.getSheet(0), editStarting: dbController.onEditStart, editEnded: dbController.onEditEnded}]);
- billsSpread.focus(true);
- setSheet.initSheet(billsSpread, setting, true);
- myKey.delKey(billsSpread);
- for (let data of datas) {
- if (data.fixedFlag) {
- let findData = BillsFixedFlagList.find((x) => data.fixedFlag === x.value);
- if (findData) {
- data.fixedFlag = findData.name;
- }
- }
- }
- billsTree.loadDatas(datas);
- let controller = TREE_SHEET_CONTROLLER.createNew(billsTree.tree, billsSpread.getActiveSheet(), setting);
- controller.showTreeData();
- dbController.controller = controller;
- sheetBillsDatas = tools.getsheetDatas(controller.sheet, 'bills', controller);
- setSheet.formatter(billsSpread.getActiveSheet());
- //setTagId
- setTagID(controller, setting);
- 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)));
- }
- //刷新节点可进行操作的按钮
- refreshBtn(controller);
- controller.setTreeSelected(controller.tree.findNode(controller.sheet.getTag(0, 0)));
- //粘贴事件
- bindPasteBills(controller, billsSpread.getActiveSheet(), setting);
- //补注内容改变
- rechargeChange(controller);//
- //焦点控制
- switchFcs(controller, controller.sheet, billsSpread, jobsSheet, itemsSheet);
- //jobs
- jobOperation(controller, jobsSheet, function(totalJobs){
- //------关联表粘贴复制
- bindPasteRel(jobsSheet, controller, totalJobs, jobsSetting);
- //items
- itemOperation(controller, itemsSheet, function(totalItems){
- bindPasteItemsRel(itemsSheet, controller, totalItems, itemsSetting);
- //节点操作
- nodeOpration(controller, totalJobs, totalItems);
- });
- });
- let nameList = BillsFixedFlagList.map((data) => data.name);
- let comboCol = setting.cols.findIndex((data) => data.data.field === 'fixedFlag');
- setCombo(billsSheet, comboCol, nameList);
- }
- function switchFcs(controller, billsSheet, billsSpread, jobsSheet, itemsSheet){
- let btnInsert = $('#insert');
- let btnDelete = $('#delete');
- let btnUpMove = $('#upMove');
- let btnDownMove = $('#downMove');
- let btnUpLevel = $('#upLevel');
- let btnDownLevel = $('#downLevel');
- billsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
- jobsSheet.clearSelection();
- itemsSheet.clearSelection();
- billsSpread.focus(true);
- jobsSheet.options.isProtected = true;
- itemsSheet.options.isProtected = true;
- billsSheet.options.isProtected = false;
- btnInsert.attr('fcsOnBills', 'true');
- btnDelete.attr('fcsOnBills', 'true');
- btnUpLevel.attr('fcsOnBills', 'true');
- btnDownLevel.attr('fcsOnBills', 'true');
- btnUpMove.attr('fcsOnBills', 'true');
- btnDownMove.attr('fcsOnBills', 'true');
- });
- jobsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
- itemsSheet.clearSelection();
- jobsSpread.focus(true);
- itemsSheet.options.isProtected = true;
- billsSheet.options.isProtected = true;
- jobsSheet.options.isProtected = false;
- controller.tree.selected.args = args;
- controller.tree.selected.field = 'job';
- tools.btnClose(btnInsert);
- tools.btnClose(btnDelete);
- tools.btnClose(btnUpLevel);
- tools.btnClose(btnDownLevel);
- btnInsert.attr('fcsOnBills', 'false');
- btnDelete.attr('fcsOnBills', 'false');
- btnUpLevel.attr('fcsOnBills', 'false');
- btnDownLevel.attr('fcsOnBills', 'false');
- btnUpMove.attr('fcsOnBills', 'false');
- btnDownMove.attr('fcsOnBills', 'false');
- let selected;
- if(controller.tree.selected){
- selected = controller.tree.selected.jobs[args.row];
- }
- if(tools.canUpMove(selected, controller.tree.selected.jobs)){
- tools.btnAction(btnUpMove);
- btnUpMove.attr('canMove', 'true');
- }
- else{
- tools.btnClose(btnUpMove);
- btnUpMove.attr('canMove', 'false');
- }
- if(tools.canDownMove(selected, controller.tree.selected.jobs)){
- tools.btnAction(btnDownMove);
- btnDownMove.attr('canMove', 'true');
- }
- else{
- tools.btnClose(btnDownMove);
- btnDownMove.attr('canMove', 'false');
- }
- });
- itemsSheet.bind(GC.Spread.Sheets.Events.CellClick, function (sender, args) {
- jobsSheet.clearSelection();
- itemsSpread.focus(true);
- jobsSheet.options.isProtected = true;
- billsSheet.options.isProtected = true;
- itemsSheet.options.isProtected = false;
- controller.tree.selected.args = args;
- controller.tree.selected.field = 'item';
- tools.btnClose(btnInsert);
- tools.btnClose(btnDelete);
- tools.btnClose(btnUpLevel);
- tools.btnClose(btnDownLevel);
- btnInsert.attr('fcsOnBills', 'false');
- btnDelete.attr('fcsOnBills', 'false');
- btnUpLevel.attr('fcsOnBills', 'false');
- btnDownLevel.attr('fcsOnBills', 'false');
- btnUpMove.attr('fcsOnBills', 'false');
- btnDownMove.attr('fcsOnBills', 'false');
- let selected;
- if(controller.tree.selected){
- selected = controller.tree.selected.items[args.row];
- }
- if(tools.canUpMove(selected, controller.tree.selected.items)){
- tools.btnAction(btnUpMove);
- btnUpMove.attr('canMove', 'true');
- }
- else{
- tools.btnClose(btnUpMove);
- btnUpMove.attr('canMove', 'false');
- }
- if(tools.canDownMove(selected, controller.tree.selected.items)){
- tools.btnAction(btnDownMove);
- btnDownMove.attr('canMove', 'true');
- }
- else{
- tools.btnClose(btnDownMove);
- btnDownMove.attr('canMove', 'false');
- }
- });
- };
- function setTagID(controller, setting){
- if(controller.tree.items.length > 0){
- let length = controller.tree.items.length;
- for(var i=0; i<length; i++){
- setting.cols.forEach(function(col, colIdx){
- if(controller.tree.items[i].data.ID){
- controller.sheet.setTag(i, colIdx, controller.tree.items[i].data.ID);
- }
- });
- }
- }
- }
- function refreshBtn(controller){
- if (locked) {
- return;
- }
- controller.bind('refreshBaseActn', function (tree) {
- let showButton = function (show, btn) {
- tools.btnAction($('#insert'), 'focusOnBills');
- if (show) {
- tools.btnAction(btn, 'doing');
- } else {
- tools.btnClose(btn, 'doing');
- }
- };
- 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'));
- });
- }
- function rechargeChange(controller){
- codeEditor.on("change", function () {
- if(controller.tree.selected){
- let newData = codeEditor.getValue();
- if(newData !== controller.tree.selected.data.recharge){
- rechargeController.updateRechar(controller.tree.selected, newData);
- }
- }
- });
- /*$('#exampleTextarea').bind('change', function(){
- let newData = $('#exampleTextarea').val();
- if(controller.tree.selected){
- console.log(controller.tree.selected.data.code)
- rechargeController.updateRechar(controller.tree.selected, newData);
- }
- });*/
- }
- function jobOperation(controller, jobsSheet, callback){
- mainAjax.getMaxNumber(billsLibId, 'jobs', function(result){
- if(result.length === 0){
- maxJobsNumber = 0;
- }
- else {
- maxJobsNumber = result[0].code;
- }
- jobsAjax.getJobContent(billsLibId, function(datas){
- let totalJobs = createObj.newJobs();
- totalJobs.loadJobs(controller.tree.items, datas);
- jobsController.totalJobs = totalJobs;
- initData(controller, jobsSheet, jobsSetting, 'jobs');
- myKey.delKey(jobsSpread, controller, totalJobs, jobsSetting, 'jobs');
- bindSheet(controller, jobsSheet, 'jobs', jobsSetting);
- jobsController.editData(jobsSheet);
- if (callback){
- callback(totalJobs);
- }
- });
- });
- }
- function itemOperation(controller, itemsSheet, callback){
- mainAjax.getMaxNumber(billsLibId, 'items', function(result){
- if(result.length === 0){
- maxItemsNumber = 0;
- }
- else {
- maxItemsNumber = result[0].code;
- }
- itemsAjax.getItemCharacter(billsLibId, function(datas){
- let totalItems = createObj.newItems();
- totalItems.loadItems(controller.tree.items, datas);
- itemsController.totalItems = totalItems;
- initData(controller, itemsSheet, itemsSetting, 'items');
- myKey.delKey(itemsSpread, controller, totalItems, itemsSetting, 'items');
- bindSheet(controller, itemsSheet, 'items', itemsSetting);
- itemsController.editData(itemsSheet);
- if(callback){
- callback(totalItems)
- }
- });
- });
- }
- //初始焦点工作表和项目表绑定数据
- function initData(controller, sheet, setting, classify){
- if(controller.tree.selected){
- let arr = controller.tree.selected[classify];
- let recharge = controller.tree.selected.data.recharge;
- let prefix = classify === 'jobs' ? 'job' : 'item';
- if(arr.length > 0){
- tools.orderReshowData(sheet, arr, setting, prefix,true);
- }
- else{
- setSheet.setMaxRowCount(sheet, []);
- }
- if(recharge){
- codeEditor.setValue(recharge);
- //$('#exampleTextarea').val(recharge);
- }
- else{
- codeEditor.setValue('');
- //$('#exampleTextarea').val('');
- }
- }
- }
- function bindSheet(controller, sheet, field, setting){
- controller.sheet.bind(GC.Spread.Sheets.Events.SelectionChanged, function(sender, args){
- if(args.newSelections[0]){
- controller.tree.selected = controller.tree.items[args.newSelections[0].row] ? controller.tree.items[args.newSelections[0].row] : null;
- }
- if(controller.tree.selected && args.oldSelections[0].row !== args.newSelections[0].row|| controller.tree.selected && args.oldSelections[0].row === 0){
- //rechargeArea
- const recharge = controller.tree.selected.data.recharge || '';
- codeEditor.setValue(recharge);
- //$('#exampleTextarea').val(controller.tree.selected.data.recharge);
- if(field === 'jobs'){
- tools.clearData(sheet);
- let jobs = controller.tree.selected.jobs;
- setSheet.setMaxRowCount(sheet, jobs);
- if(jobs.length > 0){
- tools.orderReshowData(sheet, jobs, setting, 'job', true);
- orgJobData = sheet.getValue(0, 0);
- }
- //sheetDatas = tools.getsheetDatas(sheet, 'jobs');
- }
- if(field === 'items'){
- tools.clearData(sheet);
- let items = controller.tree.selected.items;
- setSheet.setMaxRowCount(sheet, items);
- if(items.length > 0){
- tools.orderReshowData(sheet, items, setting, 'item', true);
- orgItemData = sheet.getValue(0, 0);
- }
- //sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
- }
- }
- });
- }
- function bindPasteBills(controller, sheet, setting){
- sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
- sheetBillsDatas = tools.getsheetDatas(sheet, 'bills', controller);
- let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
- //复制的列数超过正确的列数,不可复制
- if(maxCol >= billsLibSetting.cols.length){
- args.cancel = true;
- }
- });
- sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
- let datas = [], field;
- 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 markRow = orgRow, colLen = sheet.getColumnCount(GC.Spread.Sheets.SheetArea.viewport);
- let validDatas = tools.getValidDatas(sheet, setting, args);
- sheet.suspendPaint();
- for(let i =orgRow, j=0; i<= maxRow; i++, j++){
- //let id = controller.tree.items[i] ? controller.tree.items[i].getID() : null;
- let id = sheet.getTag(i, 0);
- if(id && j< validDatas.length){
- validDatas[j].ID = id;
- for(let k =orgCol; k<= maxCol; k++){
- setting.cols.forEach(function(col, colIdx){
- if(colIdx === k){
- if(validDatas[j][col.data.field]){
- sheet.setValue(i, k, validDatas[j][col.data.field]);
- sheetBillsDatas.datasIdx['rowIdx'+ i][col.data.field] = validDatas[j][col.data.field];
- }
- else {
- sheet.setValue(i, k, '');
- sheetBillsDatas.datasIdx['rowIdx'+ i][col.data.field] = '';
- }
- }
- });
- }
- }
- else if(i < controller.tree.items.length && j>= validDatas.length){
- //reshow orgDatas
- sheet.setValue(i, 0, sheetBillsDatas.datasIdx['rowIdx'+ i].code + '');
- sheet.setValue(i, 1, sheetBillsDatas.datasIdx['rowIdx'+ i].name);
- sheet.setValue(i, 2, sheetBillsDatas.datasIdx['rowIdx'+ i].unit);
- sheet.setValue(i, 3, sheetBillsDatas.datasIdx['rowIdx'+ i].ruleText);
- sheet.setValue(i, 4, sheetBillsDatas.datasIdx['rowIdx'+ i].engineering);
- sheet.setValue(i, 5, sheetBillsDatas.datasIdx['rowIdx'+ i].fixedFlag);
- }
- else {
- sheet.clear(i, 0, 1, sheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport,GC.Spread.Sheets.StorageType.data);
- }
- }
- sheet.resumePaint();
- billsAjax.pasteBills(userAccount, billsLibId, validDatas);
- for(let vData of validDatas){
- let node = controller.tree.nodes['id_' + vData.ID];
- if(node){
- Object.assign(node.data, vData);
- }
- }
- sheet.setRowCount(sheetBillsDatas.datas.length);
- });
- }
- function bindPasteRel(sheet, controller, totalJobs, setting){
- //sheetDatas = tools.getsheetDatas(sheet, 'jobs');
- sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
- let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
- sheetDatas = tools.getsheetDatas(sheet, 'jobs');
- //复制的列数超过正确的列数,不可复制
- if(maxCol >= jobsSetting.cols.length){
- args.cancel = true;
- }
- });
- sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
- if(controller.tree.selected){
- 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 pasteArr = [];
- let crossedDatas = [];
- let uncrossedDatas = [];
- const codeCol = 0;
- const contentCol = 1;
- for(let i=orgRow; i<=maxRow; i++){
- //粘贴编号列,转换成粘贴内容处理
- let code = sheet.getCell(i, codeCol).value();
- let content = sheet.getCell(i, contentCol).value();
- if(code && !content){
- let contentByCode = tools.getContentByCode(totalJobs.jobsArr, code);
- if(contentByCode){
- pasteArr.push(contentByCode);
- }
- }
- if(content){
- pasteArr.push(content);
- }
- }
- let uniqPasteArr = tools.uniqArr(pasteArr);
- let serialNoUn = tools.getSerialNo(controller.tree.selected.jobs) - 1;
- for(let i =orgRow, j=0; i<=uniqPasteArr.length+orgRow-1; i++, j++ ){
- let flag = true;
- let crossedData;
- sheetDatas.forEach(function(rowData){
- if(rowData.rowIdx === i && rowData.data !== uniqPasteArr[j]){
- flag = false;
- let serialNo = tools.getObj(controller.tree.selected.jobs, rowData.id, 'job');
- crossedData = {
- orgId: rowData.id,
- newData: uniqPasteArr[j],
- serialNo: serialNo
- };
- }
- });
- if(flag){
- serialNoUn++;
- uncrossedDatas.push({data: uniqPasteArr[j], serialNo: serialNoUn});
- }
- else {
- crossedDatas.push(crossedData);
- }
- }
- let pasteDatas = tools.encapData(uncrossedDatas, crossedDatas, controller, totalJobs);
- if(pasteDatas.updateDatas.length > 0 || pasteDatas.createDatas.length > 0){
- billsAjax.pasteRel(userAccount, billsLibId, pasteDatas.updateDatas, pasteDatas.createDatas, 'jobs', function(datas){
- pasteController.frontOperator(sheet, setting, controller, totalJobs, datas);
- });
- }
- else {
- tools.orderReshowData(sheet, controller.tree.selected.jobs, setting, 'job', true);
- }
- }
- else {
- tools.clearData(sheet);
- }
- });
- }
- function bindPasteItemsRel(sheet, controller, totalItems, setting){
- //sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
- sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
- let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
- sheetItemsDatas = tools.getsheetDatas(sheet, 'items');
- //复制的列数超过正确的列数,不可复制
- if(maxCol >= itemsSetting.cols.length){
- args.cancel = true;
- }
- });
- sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
- if(controller.tree.selected){
- 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 pasteArr = [];
- let crossedDatas = [];
- let uncrossedDatas = [];
- const codeCol = 0;
- const contentCol = 1;
- for(let i=orgRow; i<=maxRow; i++){
- //编号列转换成内容列处理
- let code = sheet.getCell(i, codeCol).value();
- let content = sheet.getCell(i, contentCol).value();
- if(code && !content){
- let contentByCode = tools.getContentByCode(totalItems.itemsArr, code);
- if(contentByCode){
- pasteArr.push(contentByCode);
- }
- }
- if(content){
- pasteArr.push(content);
- }
- }
- let uniqPasteArr = tools.uniqArr(pasteArr);
- let serialNoUn = tools.getSerialNo(controller.tree.selected.items) - 1;
- for(let i =orgRow, j=0; i<=uniqPasteArr.length+orgRow-1; i++, j++ ){
- let flag = true;
- let crossedData;
- sheetItemsDatas.forEach(function(rowData){
- if(rowData.rowIdx === i && rowData.data !== uniqPasteArr[j]){
- flag = false;
- let serialNo = tools.getObj(controller.tree.selected.items, rowData.id, 'item');
- crossedData = {
- orgId: rowData.id,
- newData: uniqPasteArr[j],
- serialNo: serialNo
- };
- }
- });
- if(flag){
- serialNoUn ++;
- uncrossedDatas.push({data: uniqPasteArr[j], serialNo: serialNoUn});
- }
- else {
- crossedDatas.push(crossedData);
- }
- }
- let pasteDatas = tools.encapItemsData(uncrossedDatas, crossedDatas, controller, totalItems);
- if(pasteDatas.updateDatas.length > 0 || pasteDatas.createDatas.length > 0){
- billsAjax.pasteRel(userAccount, billsLibId, pasteDatas.updateDatas, pasteDatas.createDatas, 'items', function(datas){
- pasteController.frontItemsRelOperator(sheet, setting, controller, totalItems, datas);
- });
- }
- else{
- tools.orderReshowData(sheet, controller.tree.selected.items, setting, 'item', true);
- }
- }
- else {
- tools.clearData(sheet);
- }
- });
- }
- function buildJobs(jobsSpread, setting){
- setSheet.initSheet(jobsSpread, setting, true);
- jobsSpread.getActiveSheet().clearSelection();
- myKey.downKey(jobsSpread);
- myKey.enterKey(jobsSpread);
- TREE_SHEET_HELPER.loadSheetHeader(jobsSetting, jobsSpread.getActiveSheet());
- }
- function buildItems(itemsSpread, setting){
- setSheet.initSheet(itemsSpread, setting, true);
- // setSheet.setMaxRowCount(itemsSpread.getActiveSheet(), 10);
- itemsSpread.getActiveSheet().clearSelection();
- myKey.downKey(itemsSpread);
- myKey.enterKey(itemsSpread);
- TREE_SHEET_HELPER.loadSheetHeader(itemsSetting, itemsSpread.getActiveSheet());
- }
- </script>
- </html>
|