my-Library-detail2.html 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415
  1. <!DOCTYPE html>
  2. <html lang="en">
  3. <head>
  4. <meta charset="utf-8">
  5. <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
  6. <meta http-equiv="x-ua-compatible" content="ie=edge">
  7. <title>造价文件库-纵横造价指标系统</title>
  8. <link rel="stylesheet" href="css/bootstrap/bootstrap.min.css">
  9. <link rel="stylesheet" href="css/main.css">
  10. <link rel="stylesheet" href="css/font-awesome/font-awesome.min.css">
  11. <link rel="stylesheet" href="css/spreadjs/sheets/gc.spread.sheets.excelsmartcost.css">
  12. </head>
  13. <body>
  14. <div class="header">
  15. <h1 class="logo"><a>造价文件库-纵横造价指标系统</a></h1>
  16. <div class="poj-name">
  17. <span class="name">造价文件库</span>
  18. </div>
  19. <div class="header-box">
  20. <div class="header-nav"></div>
  21. <div class="header-user pull-right">
  22. <div class="avatar btn-group">
  23. <a class="dropdown-toggle" data-toggle="dropdown">
  24. <span class="pic"><img src="img/avatar.png"></span>
  25. <span>张三</span>
  26. <span class="caret"></span>
  27. </a>
  28. <div class="dropdown-menu">
  29. <a href="#" class="dropdown-item">退出登录</a>
  30. </div>
  31. </div>
  32. </div>
  33. </div>
  34. </div>
  35. <div class="main">
  36. <div class="main-nav">
  37. <div class="nav-top">
  38. <ul class="nav nav-pills flex-column bg-nav">
  39. <li class="nav-item"><a href="template.html"title="指标模板"><i class="fa fa-file-text-o"></i> 指标模板</a></li>
  40. <li class="nav-item active"><a href="my-Library.html"title="指标库"><i class="fa fa-list-ul"></i> 造价文件库</a></li>
  41. <li class="nav-item"><a href="search-Library.html"title="指标对比"><i class="fa fa-search"></i> 指标对比</a></li>
  42. <li class="nav-item"><a href="singel-Library.html"title="指标对比"><i class="fa fa-search-plus"></i> 单元指标</a></li>
  43. </ul>
  44. </div>
  45. </div>
  46. <div class="main-panel">
  47. <div class="panel-content">
  48. <div class="panel-title fluid">
  49. <div class="title-main d-flex justify-content-between">
  50. <div>
  51. XXX标段 2018-03-14 17:12:23
  52. </div>
  53. <div>
  54. <a href="#storage" data-toggle="modal" data-target="#storage" class="btn btn-primary btn-sm pull-right">入库</a>
  55. <a href="#del" data-toggle="modal" data-target="#del" class="btn btn-outline-danger btn-sm pull-right">从库中删除</a>
  56. </div>
  57. </div>
  58. </div>
  59. <div class="content-wrap">
  60. <div class="c-header p-0 col-12">
  61. <ul class="nav nav-tabs">
  62. <li class="nav-item">
  63. <a class="nav-link" href="my-Library-detail.html">全局参数</a>
  64. </li>
  65. <li class="nav-item">
  66. <a class="nav-link active" href="my-Library-detail.html">项目节参数</a>
  67. </li>
  68. </ul>
  69. </div>
  70. <div class="c-body">
  71. <div class="row">
  72. <div class="col-5">
  73. <div class="sjs-height-1" id="bills-spread" style="overflow:hidden;border:1px solid #dee2e6">
  74. </div>
  75. </div>
  76. <div class="col-7">
  77. <!--top-->
  78. <div>
  79. <div class="top-title">
  80. <h5>指标</h5>
  81. </div>
  82. <div class="sjs-height-3">
  83. <table class="table table-bordered table-sm table-hover table-f">
  84. <thead>
  85. <tr>
  86. <th width="80">指标编号</th>
  87. <th width="150">项目或费用名称</th>
  88. <th colspan="2">指标单位</th>
  89. <th width="250">计算规则</th>
  90. <th width="300">指标计算</th>
  91. <th width="140">经济指标</th>
  92. </tr>
  93. </thead>
  94. <tbody id="indexList">
  95. <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>
  96. <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>
  97. <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>
  98. <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>
  99. <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>
  100. <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>
  101. <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>
  102. <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>
  103. <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>
  104. <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>
  105. <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>
  106. <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>
  107. <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>
  108. <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>
  109. <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>
  110. <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>
  111. <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>
  112. <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>
  113. <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>
  114. <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>
  115. <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>
  116. <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>
  117. </tbody>
  118. </table>
  119. </div>
  120. </div>
  121. <!--bottom-->
  122. <div>
  123. <div class="bottom-title mt-3">
  124. <h5 class="d-flex justify-content-between">填写参数 <a href="">展开</a></h5>
  125. </div>
  126. <div class="sjs-bottom-2">
  127. <!--本节点参数-->
  128. <div class="sjs-bottom-4" style="display:none">
  129. <table class="table table-bordered table-sm table-hover">
  130. <tr><th colspan="4" class="text-center">1-1 项目节 参数</th></tr>
  131. <tr class="text-center">
  132. <th>参数name</th><th>绑定分项节点</th><th>参数数值</th>
  133. </tr>
  134. <tr>
  135. <td>总造价</th><td></td><td><input class="form-control form-control-sm text-right"></td>
  136. </tr>
  137. <tr>
  138. <td>路线总长度</td><td>1-1-2</td><td><input class="form-control form-control-sm text-right" value="15123"></td>
  139. </tr>
  140. <tr>
  141. <td>路基工程费用</td><td>1-4-1</td><td><input class="form-control form-control-sm text-right" value="50410"></td>
  142. </tr>
  143. <tr>
  144. <td>边沟圬工体积</td><td></td><td><input class="form-control form-control-sm text-right"></td>
  145. </tr>
  146. </table>
  147. </div>
  148. </div>
  149. </div>
  150. </div>
  151. </div>
  152. </div>
  153. </div>
  154. </div>
  155. </div>
  156. </div>
  157. <!-- 删除已上报标段 -->
  158. <div id="del" class="modal fade" tabindex="-1" role="dialog" aria-hidden="true">
  159. <div class="modal-dialog">
  160. <div class="modal-content">
  161. <div class="modal-header">
  162. <h5 class="modal-title">删除确认</h5>
  163. <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
  164. </div>
  165. <div class="modal-body">
  166. <div class="form">
  167. <form>
  168. <div class="alert alert-danger">
  169. 删除 XXX标段 2018-03-14 17:12:23 后数据无法恢复,请谨慎操作;
  170. <br>需要删除,请在以下输入框输入"&nbsp;&nbsp;&nbsp;<b>确认删除</b>&nbsp;&nbsp;&nbsp;",再点击“确认删除”按钮。
  171. </div>
  172. <div class="form-group">
  173. <input class="form-control" type="text" placeholder="输入 “确认删除”">
  174. </div>
  175. </form>
  176. </div>
  177. </div>
  178. <div class="modal-footer">
  179. <button class="btn btn-danger">确认删除</button>
  180. <button class="btn btn-secondary" data-dismiss="modal" aria-hidden="true">关闭</button>
  181. </div>
  182. </div>
  183. </div>
  184. </div>
  185. <!-- 入库 -->
  186. <div id="storage" class="modal fade" tabindex="-1" role="dialog" aria-hidden="true">
  187. <div class="modal-dialog">
  188. <div class="modal-content">
  189. <div class="modal-header">
  190. <h5 class="modal-title">删除确认</h5>
  191. <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
  192. </div>
  193. <div class="modal-body">
  194. <div class="form">
  195. <h5>入库后,才可以进行指标对比。确认入库后,仍然可以对参数进行重新设置,重新进行指标计算。</h5>
  196. </div>
  197. </div>
  198. <div class="modal-footer">
  199. <button class="btn btn-primary">确认入库</button>
  200. <button class="btn btn-secondary" data-dismiss="modal" aria-hidden="true">关闭</button>
  201. </div>
  202. </div>
  203. </div>
  204. </div>
  205. <!-- JS. -->
  206. <script src="js/jquery/jquery-3.2.1.min.js"></script>
  207. <script src="js/popper/popper.min.js"></script>
  208. <script src="js/bootstrap/bootstrap.min.js"></script>
  209. <script src="js/global.js"></script>
  210. <script type="text/javascript">
  211. autoFlashHeight();
  212. </script>
  213. <script src="js/spreadjs/sheets/gc.spread.sheets.all.10.0.1.min.js"></script>
  214. <script>
  215. $(document).ready(function () {
  216. const data = [
  217. {
  218. code: '1',
  219. name:'第一部分 建筑安装工程费',
  220. unit:'公路公里',
  221. quantity: 0,
  222. total_price: 1045756,
  223. }, {
  224. code: '1-1',
  225. name:'临时工程',
  226. unit:'公路公里',
  227. quantity: 0,
  228. total_price: 50000,
  229. }, {
  230. code: '1-1-1',
  231. name:'临时道路',
  232. unit:'km',
  233. quantity: 0,
  234. total_price: 1045756,
  235. }, {
  236. code: '1-1-1',
  237. name:'临时道路',
  238. unit:'km',
  239. quantity: 0,
  240. total_price: 1045756,
  241. }, {
  242. code: '1-1-1',
  243. name:'临时道路',
  244. unit:'km',
  245. quantity: 0,
  246. total_price: 1045756,
  247. }, {
  248. code: '1-1-1',
  249. name:'临时道路',
  250. unit:'km',
  251. quantity: 0,
  252. total_price: 1045756,
  253. }, {
  254. code: '1-1-1',
  255. name:'临时道路',
  256. unit:'km',
  257. quantity: 0,
  258. total_price: 1045756,
  259. }, {
  260. code: '1-1-1',
  261. name:'临时道路',
  262. unit:'km',
  263. quantity: 0,
  264. total_price: 1045756,
  265. }, {
  266. code: '1-1-1',
  267. name:'临时道路',
  268. unit:'km',
  269. quantity: 0,
  270. total_price: 1045756,
  271. }, {
  272. code: '1-1-1',
  273. name:'临时道路',
  274. unit:'km',
  275. quantity: 0,
  276. total_price: 1045756,
  277. }, {
  278. code: '1-1-1',
  279. name:'临时道路',
  280. unit:'km',
  281. quantity: 0,
  282. total_price: 1045756,
  283. }, {
  284. code: '1-1-1',
  285. name:'临时道路',
  286. unit:'km',
  287. quantity: 0,
  288. total_price: 1045756,
  289. }, {
  290. code: '1-1-1',
  291. name:'临时道路',
  292. unit:'km',
  293. quantity: 0,
  294. total_price: 1045756,
  295. }, {
  296. code: '1-1-1',
  297. name:'临时道路',
  298. unit:'km',
  299. quantity: 0,
  300. total_price: 1045756,
  301. }, {
  302. code: '1-1-1',
  303. name:'临时道路',
  304. unit:'km',
  305. quantity: 0,
  306. total_price: 1045756,
  307. }, {
  308. code: '1-1-1',
  309. name:'临时道路',
  310. unit:'km',
  311. quantity: 0,
  312. total_price: 1045756,
  313. }, {
  314. code: '1-1-1',
  315. name:'临时道路',
  316. unit:'km',
  317. quantity: 0,
  318. total_price: 1045756,
  319. }, {
  320. code: '1-1-1',
  321. name:'临时道路',
  322. unit:'km',
  323. quantity: 0,
  324. total_price: 1045756,
  325. }, {
  326. code: '1-1-1',
  327. name:'临时道路',
  328. unit:'km',
  329. quantity: 0,
  330. total_price: 1045756,
  331. }, {
  332. code: '1-1-1',
  333. name:'临时道路',
  334. unit:'km',
  335. quantity: 0,
  336. total_price: 1045756,
  337. }, {
  338. code: '1-1-1',
  339. name:'临时道路',
  340. unit:'km',
  341. quantity: 0,
  342. total_price: 1045756,
  343. }, {
  344. code: '1-1-1',
  345. name:'临时道路',
  346. unit:'km',
  347. quantity: 0,
  348. total_price: 1045756,
  349. }, {
  350. code: '1-1-1',
  351. name:'临时道路',
  352. unit:'km',
  353. quantity: 0,
  354. total_price: 1045756,
  355. }, {
  356. code: '1-1-1',
  357. name:'临时道路',
  358. unit:'km',
  359. quantity: 0,
  360. total_price: 1045756,
  361. }, {
  362. code: '1-1-1',
  363. name:'临时道路',
  364. unit:'km',
  365. quantity: 0,
  366. total_price: 1045756,
  367. }, {
  368. code: '1-1-1',
  369. name:'临时道路',
  370. unit:'km',
  371. quantity: 0,
  372. total_price: 1045756,
  373. }, {
  374. code: '1-1-1',
  375. name:'临时道路',
  376. unit:'km',
  377. quantity: 0,
  378. total_price: 1045756,
  379. }, {
  380. code: '1-1-1',
  381. name:'临时道路',
  382. unit:'km',
  383. quantity: 0,
  384. total_price: 1045756,
  385. }, {
  386. code: '1-1-1',
  387. name:'临时道路',
  388. unit:'km',
  389. quantity: 0,
  390. total_price: 1045756,
  391. }, {
  392. code: '1-1-1',
  393. name:'临时道路',
  394. unit:'km',
  395. quantity: 0,
  396. total_price: 1045756,
  397. }, {
  398. code: '1-1-1',
  399. name:'临时道路',
  400. unit:'km',
  401. quantity: 0,
  402. total_price: 1045756,
  403. }
  404. ];
  405. const spread = new GC.Spread.Sheets.Workbook($('#bills-spread')[0], {
  406. sheetCount: 1
  407. });
  408. spread.getActiveSheet().setDataSource(data);
  409. })
  410. </script>
  411. </body>
  412. </html>