| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415 |
- <!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="css/bootstrap/bootstrap.min.css">
- <link rel="stylesheet" href="css/main.css">
- <link rel="stylesheet" href="css/font-awesome/font-awesome.min.css">
- <link rel="stylesheet" href="css/spreadjs/sheets/gc.spread.sheets.excelsmartcost.css">
- </head>
- <body>
- <div class="header">
- <h1 class="logo"><a>造价文件库-纵横造价指标系统</a></h1>
- <div class="poj-name">
- <span class="name">造价文件库</span>
- </div>
- <div class="header-box">
- <div class="header-nav"></div>
- <div class="header-user pull-right">
- <div class="avatar btn-group">
- <a class="dropdown-toggle" data-toggle="dropdown">
- <span class="pic"><img src="img/avatar.png"></span>
- <span>张三</span>
- <span class="caret"></span>
- </a>
- <div class="dropdown-menu">
- <a href="#" class="dropdown-item">退出登录</a>
- </div>
- </div>
- </div>
- </div>
- </div>
- <div class="main">
- <div class="main-nav">
- <div class="nav-top">
- <ul class="nav nav-pills flex-column bg-nav">
- <li class="nav-item"><a href="template.html"title="指标模板"><i class="fa fa-file-text-o"></i> 指标模板</a></li>
- <li class="nav-item active"><a href="my-Library.html"title="指标库"><i class="fa fa-list-ul"></i> 造价文件库</a></li>
- <li class="nav-item"><a href="search-Library.html"title="指标对比"><i class="fa fa-search"></i> 指标对比</a></li>
- <li class="nav-item"><a href="singel-Library.html"title="指标对比"><i class="fa fa-search-plus"></i> 单元指标</a></li>
- </ul>
- </div>
- </div>
- <div class="main-panel">
- <div class="panel-content">
- <div class="panel-title fluid">
- <div class="title-main d-flex justify-content-between">
- <div>
- XXX标段 2018-03-14 17:12:23
- </div>
- <div>
- <a href="#storage" data-toggle="modal" data-target="#storage" class="btn btn-primary btn-sm pull-right">入库</a>
- <a href="#del" data-toggle="modal" data-target="#del" class="btn btn-outline-danger btn-sm pull-right">从库中删除</a>
- </div>
- </div>
- </div>
- <div class="content-wrap">
- <div class="c-header p-0 col-12">
- <ul class="nav nav-tabs">
- <li class="nav-item">
- <a class="nav-link" href="my-Library-detail.html">全局参数</a>
- </li>
- <li class="nav-item">
- <a class="nav-link active" href="my-Library-detail.html">项目节参数</a>
- </li>
- </ul>
- </div>
- <div class="c-body">
- <div class="row">
- <div class="col-5">
- <div class="sjs-height-1" id="bills-spread" style="overflow:hidden;border:1px solid #dee2e6">
- </div>
- </div>
- <div class="col-7">
- <!--top-->
- <div>
- <div class="top-title">
- <h5>指标</h5>
- </div>
- <div class="sjs-height-3">
- <table class="table table-bordered table-sm table-hover table-f">
- <thead>
- <tr>
- <th width="80">指标编号</th>
- <th width="150">项目或费用名称</th>
- <th colspan="2">指标单位</th>
- <th width="250">计算规则</th>
- <th width="300">指标计算</th>
- <th width="140">经济指标</th>
- </tr>
- </thead>
- <tbody id="indexList">
- <tr> <td>z2-1</td> <td>路基工程路线总长度造价指标</td><td>元</td><td width="75">公路公里</td><td>本项合价/路线总长度</td> <td class="text-right">385554513.0264/63.182</td><td class="text-right">6102284</td> </tr>
- <tr> <td>z2-2</td> <td>路基工程路基长度造价指标</td><td>元</td><td>km</td><td>本项合价/本项数量1</td> <td class="text-right">385554513.0264/19.89</td><td class="text-right">19384340</td> </tr>
- <tr> <td>z2-3</td> <td>路基工程建筑总面积造价指标</td><td>元</td><td>m2</td><td>本项合价/(路线总长度*路基宽度*1000)</td> <td class="text-right">385554513.0264/(63.182*35*)</td><td class="text-right"></td> </tr>
- <tr> <td>z2-4</td> <td>路基工程建筑面积造价指标</td><td>元</td><td>m2</td><td>本项合价/(路基长度*路基宽度*1000)</td> <td class="text-right">385554513.0264/(19.89*35*)</td><td class="text-right"></td> </tr>
- <tr> <td>z2-5</td> <td>路基工程造价占比</td><td></td><td>%</td><td>本项合价/建安费</td> <td class="text-right">385554513.0264/6083375331.7505</td><td class="text-right">0.0634</td> </tr>
- <tr> <td>z2-6</td> <td>路基长度占比</td><td>km</td><td>公路公里</td><td>本项数量1/路线总长度</td> <td class="text-right">19.89/63.182</td><td class="text-right">0.3148</td> </tr>
- <tr> <td>z2t-1</td> <td>路基断面土石方长度造价</td><td>元</td><td>km</td><td>(挖方合价+填方合价)/本项数量1</td> <td class="text-right">(88620896+84867120.7764)/19.89</td><td class="text-right">8722374</td> </tr>
- <tr> <td>z2t-2</td> <td>路基断面土石方面积造价</td><td>元</td><td>m2</td><td>(挖方合价+填方合价)/(路基长度*路基宽度*1000)</td> <td class="text-right">(88620896+84867120.7764)/(19.89*35*</td><td class="text-right"></td> </tr>
- <tr> <td>z2t-3</td> <td>路基断面土石方体积造价</td><td>元</td><td>m3</td><td>(挖方合价+填方合价)/(挖方体积+填方体积)</td> <td class="text-right">(88620896+84867120.7764)/(5848604.6+7893208.257)</td><td class="text-right">12.6248</td> </tr>
- <tr> <td>z2t-4</td> <td>路基断面土石方面积含量指标</td><td>m3</td><td>m2</td><td>(挖方体积+填方体积)/(路基长度*路基宽度*1000)</td> <td class="text-right">(5848604.6+7893208.257)/(19.89*35*</td><td class="text-right"></td> </tr>
- <tr> <td>z2t-5</td> <td>路基断面土石方长度含量指标</td><td>m3</td><td>km</td><td>(挖方体积+填方体积)/本项数量1</td> <td class="text-right">(5848604.6+7893208.257)/19.89</td><td class="text-right">690890.5625</td> </tr>
- <tr> <td>z2t-6</td> <td>路基土石方造价占比</td><td></td><td>%</td><td>(挖方合价+填方合价)/路基工程费</td> <td class="text-right">(88620896+84867120.7764)/385554513.0264</td><td class="text-right">0.45</td> </tr>
- <tr> <td>z2t-7</td> <td>挖填路基长度比</td><td>km</td><td>km</td><td>挖方路基长/填方路基长</td> <td class="text-right">10/9.89</td><td class="text-right">1.0111</td> </tr>
- <tr> <td>z2t-8</td> <td>挖填土石方体积比</td><td>m3</td><td>m3</td><td>挖方体积/填方体积</td> <td class="text-right">5848604.6/7893208.257</td><td class="text-right">0.741</td> </tr>
- <tr> <td>z2p-1</td> <td>排水工程路基长度造价</td><td>元</td><td>km</td><td>排水工程费/本项数量1</td> <td class="text-right">30651660/19.89</td><td class="text-right">1541058.875</td> </tr>
- <tr> <td>z2p-2</td> <td>排水圬工路基长度含量指标</td><td>m3</td><td>km</td><td>排水工程量/本项数量1</td> <td class="text-right">19.8897/19.89</td><td class="text-right">1</td> </tr>
- <tr> <td>z2f-1</td> <td>防护工程路基长度造价</td><td>元</td><td>km</td><td>防护工程费/本项数量1</td> <td class="text-right">80903062.25/19.89</td><td class="text-right">4067524.5</td> </tr>
- <tr> <td>z2f-2</td> <td>防护圬工路基长度含量指标</td><td>m3</td><td>km</td><td>防护工程量/本项数量1</td> <td class="text-right">19.8897/19.89</td><td class="text-right">1</td> </tr>
- <tr> <td>z2g-1</td> <td>高边坡防护工程路基长度造价</td><td>元</td><td>km</td><td>高边坡防护工程费/本项数量1</td> <td class="text-right">23423789/19.89</td><td class="text-right">1177666.625</td> </tr>
- <tr> <td>z2g-2</td> <td>高边坡防护工程路基长度含量指标</td><td>m3</td><td>km</td><td>高边坡防护工程量/本项数量1</td> <td class="text-right">19.651/19.89</td><td class="text-right">0.988</td> </tr>
- <tr> <td>z2r-1</td> <td>特殊路基处理路基长度造价</td><td>元</td><td>km</td><td>特殊路基处理费/本项数量1</td> <td class="text-right">71546361/19.89</td><td class="text-right">3597102</td> </tr>
- <tr> <td>z2r-2</td> <td>特殊路基处理长度占比</td><td></td><td>%</td><td>特殊路基处理长度/本项数量1</td> <td class="text-right">10.446/19.89</td><td class="text-right">0.5252</td> </tr>
- </tbody>
- </table>
- </div>
- </div>
- <!--bottom-->
- <div>
- <div class="bottom-title mt-3">
- <h5 class="d-flex justify-content-between">填写参数 <a href="">展开</a></h5>
- </div>
- <div class="sjs-bottom-2">
- <!--本节点参数-->
- <div class="sjs-bottom-4" style="display:none">
- <table class="table table-bordered table-sm table-hover">
- <tr><th colspan="4" class="text-center">1-1 项目节 参数</th></tr>
- <tr class="text-center">
- <th>参数name</th><th>绑定分项节点</th><th>参数数值</th>
- </tr>
- <tr>
- <td>总造价</th><td></td><td><input class="form-control form-control-sm text-right"></td>
- </tr>
- <tr>
- <td>路线总长度</td><td>1-1-2</td><td><input class="form-control form-control-sm text-right" value="15123"></td>
- </tr>
- <tr>
- <td>路基工程费用</td><td>1-4-1</td><td><input class="form-control form-control-sm text-right" value="50410"></td>
- </tr>
- <tr>
- <td>边沟圬工体积</td><td></td><td><input class="form-control form-control-sm text-right"></td>
- </tr>
- </table>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- </div>
- <!-- 删除已上报标段 -->
- <div id="del" class="modal fade" tabindex="-1" role="dialog" aria-hidden="true">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <h5 class="modal-title">删除确认</h5>
- <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
- </div>
- <div class="modal-body">
- <div class="form">
- <form>
- <div class="alert alert-danger">
- 删除 XXX标段 2018-03-14 17:12:23 后数据无法恢复,请谨慎操作;
- <br>需要删除,请在以下输入框输入" <b>确认删除</b> ",再点击“确认删除”按钮。
- </div>
- <div class="form-group">
- <input class="form-control" type="text" placeholder="输入 “确认删除”">
- </div>
- </form>
- </div>
- </div>
- <div class="modal-footer">
- <button class="btn btn-danger">确认删除</button>
- <button class="btn btn-secondary" data-dismiss="modal" aria-hidden="true">关闭</button>
- </div>
- </div>
- </div>
- </div>
- <!-- 入库 -->
- <div id="storage" class="modal fade" tabindex="-1" role="dialog" aria-hidden="true">
- <div class="modal-dialog">
- <div class="modal-content">
- <div class="modal-header">
- <h5 class="modal-title">删除确认</h5>
- <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
- </div>
- <div class="modal-body">
- <div class="form">
- <h5>入库后,才可以进行指标对比。确认入库后,仍然可以对参数进行重新设置,重新进行指标计算。</h5>
- </div>
- </div>
- <div class="modal-footer">
- <button class="btn btn-primary">确认入库</button>
- <button class="btn btn-secondary" data-dismiss="modal" aria-hidden="true">关闭</button>
- </div>
- </div>
- </div>
- </div>
- <!-- JS. -->
- <script src="js/jquery/jquery-3.2.1.min.js"></script>
- <script src="js/popper/popper.min.js"></script>
- <script src="js/bootstrap/bootstrap.min.js"></script>
- <script src="js/global.js"></script>
- <script type="text/javascript">
- autoFlashHeight();
- </script>
- <script src="js/spreadjs/sheets/gc.spread.sheets.all.10.0.1.min.js"></script>
- <script>
- $(document).ready(function () {
- const data = [
- {
- code: '1',
- name:'第一部分 建筑安装工程费',
- unit:'公路公里',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1',
- name:'临时工程',
- unit:'公路公里',
- quantity: 0,
- total_price: 50000,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }, {
- code: '1-1-1',
- name:'临时道路',
- unit:'km',
- quantity: 0,
- total_price: 1045756,
- }
- ];
- const spread = new GC.Spread.Sheets.Workbook($('#bills-spread')[0], {
- sheetCount: 1
- });
- spread.getActiveSheet().setDataSource(data);
- })
- </script>
- </body>
- </html>
|