tezheng.html 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498
  1. <!DOCTYPE html>
  2. <html lang="zh-CN">
  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="/lib/bootstrap/css/bootstrap.min.css">
  9. <!--<link rel="stylesheet" href="../../web/css/bootstrap/themes.css">-->
  10. <link rel="stylesheet" href="/web/maintain/bills_lib/css/main.css">
  11. <link rel="stylesheet" href="/lib/font-awesome/font-awesome.min.css">
  12. <!--spread-->
  13. <link rel="stylesheet" href="/lib/spreadjs/sheets/css/gc.spread.sheets.sc.css">
  14. <!--zTree-->
  15. <link rel="stylesheet" href="/lib/ztree/css/zTreeStyle.css" type="text/css">
  16. </head>
  17. <body>
  18. <div class="header">
  19. <nav class="navbar navbar-toggleable-lg navbar-light bg-faded p-0 ">
  20. <span class="header-logo px-2">清单规则编辑器</span>
  21. <div class="navbar-text"></div>
  22. </nav>
  23. <nav class="navbar navbar-toggleable-lg justify-content-between navbar-light p-0">
  24. <ul class="nav nav-tabs" role="tablist">
  25. <li class="nav-item">
  26. <a id="aStdBills" class="nav-link px-3" href="stdBills">清单</a>
  27. </li>
  28. <li class="nav-item">
  29. <a id="aStdJobs" class="nav-link px-3" href="stdJobs">工作内容</a>
  30. </li>
  31. <li class="nav-item">
  32. <a class="nav-link active px-3" href="javascript: void(0);">项目特征</a>
  33. </li>
  34. </ul>
  35. </nav>
  36. </div>
  37. <div class="main">
  38. <div class="content">
  39. <div class="container-fluid">
  40. <div class="row">
  41. <div class="main-content col-lg-7 p-0">
  42. <nav class="tools-bar"></nav>
  43. <div class="main-data" id="spreadAllItems">
  44. </div>
  45. </div>
  46. <div class="main-side col-lg-5 p-0">
  47. <div class="main-data" id="spreadEigenvalue" >
  48. </div>
  49. </div>
  50. </div>
  51. </div>
  52. </div>
  53. </div>
  54. <!--弹出添加-->
  55. <div class="modal fade" id="add" data-backdrop="static" style="display: none;" aria-hidden="true">
  56. <div class="modal-dialog" role="document">
  57. <div class="modal-content">
  58. <div class="modal-header">
  59. <h5 class="modal-title">添加定额</h5>
  60. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  61. <span aria-hidden="true">×</span>
  62. </button>
  63. </div>
  64. <div class="modal-body">
  65. <form>
  66. <div class="form-group">
  67. <label>编码</label>
  68. <input class="form-control" placeholder="输入编码" type="text">
  69. </div>
  70. <div class="form-group">
  71. <label>名称</label>
  72. <input class="form-control" placeholder="输入名称" type="text">
  73. </div>
  74. <div class="form-group">
  75. <label>单位</label>
  76. <select class="form-control"><option>选择单位</option><option>m3</option></select>
  77. </div>
  78. <div class="form-group">
  79. <label>基价</label>
  80. <input class="form-control" placeholder="输入基价" type="number">
  81. </div>
  82. <div class="form-group">
  83. <label>显示名称(以%s表示参数)</label>
  84. <input class="form-control" placeholder="输入显示名称" type="text">
  85. </div>
  86. <div class="form-group">
  87. <label>默认取费专业</label>
  88. <input class="form-control" placeholder="输入取费专业" type="text">
  89. </div>
  90. </form>
  91. </div>
  92. <div class="modal-footer">
  93. <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
  94. <a href="" class="btn btn-primary">添加</a>
  95. </div>
  96. </div>
  97. </div>
  98. </div>
  99. <!--弹出编辑-->
  100. <div class="modal fade" id="edit" data-backdrop="static" style="display: none;" aria-hidden="true">
  101. <div class="modal-dialog" role="document">
  102. <div class="modal-content">
  103. <div class="modal-header">
  104. <h5 class="modal-title">编辑定额</h5>
  105. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  106. <span aria-hidden="true">×</span>
  107. </button>
  108. </div>
  109. <div class="modal-body">
  110. <form>
  111. <div class="form-group">
  112. <label>编码</label>
  113. <input class="form-control" placeholder="输入编码" type="text" value="AA0001">
  114. </div>
  115. <div class="form-group">
  116. <label>名称</label>
  117. <input class="form-control" placeholder="输入名称" type="text" value="人工挖土方">
  118. </div>
  119. <div class="form-group">
  120. <label>单位</label>
  121. <select class="form-control"><option>m3</option></select>
  122. </div>
  123. <div class="form-group">
  124. <label>基价</label>
  125. <input class="form-control" placeholder="输入基价" type="number" value="880.84">
  126. </div>
  127. <div class="form-group">
  128. <label>显示名称(以%s表示参数)</label>
  129. <input class="form-control" placeholder="输入显示名称" type="text" value="人工挖土方">
  130. </div>
  131. <div class="form-group">
  132. <label>默认取费专业</label>
  133. <input class="form-control" placeholder="输入取费专业" type="text" value="1">
  134. </div>
  135. </form>
  136. </div>
  137. <div class="modal-footer">
  138. <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
  139. <a href="" class="btn btn-primary">确定</a>
  140. </div>
  141. </div>
  142. </div>
  143. </div>
  144. <!--弹出删除-->
  145. <div class="modal fade" id="del" data-backdrop="static" style="display: none;" aria-hidden="true">
  146. <div class="modal-dialog" role="document">
  147. <div class="modal-content">
  148. <div class="modal-header">
  149. <h5 class="modal-title">删除确认</h5>
  150. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  151. <span aria-hidden="true">×</span>
  152. </button>
  153. </div>
  154. <div class="modal-body">
  155. <h5 class="text-danger">删除后无法恢复,确认是否删除?</h5>
  156. </div>
  157. <div class="modal-footer">
  158. <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
  159. <a href="" class="btn btn-danger">删除</a>
  160. </div>
  161. </div>
  162. </div>
  163. </div>
  164. <!--弹出提示窗口-->
  165. <button id="alertBtn" class="btn btn-primary btn-lg" data-toggle="modal" data-target="#alertDiv" style="display: none"></button>
  166. <div class="modal fade" id="alertDiv" data-backdrop="static" style="display: none;" aria-hidden="true">
  167. <input type="hidden" value="123">
  168. <div class="modal-dialog" role="document">
  169. <div class="modal-content">
  170. <div class="modal-header">
  171. <h5 class="modal-title">警告</h5>
  172. <button type="button" id="alertCls" class="close" data-dismiss="modal" aria-label="Close">
  173. <span aria-hidden="true">×</span>
  174. </button>
  175. </div>
  176. <div class="modal-body">
  177. <h5 class="text-danger" id="alertTxt">编号不存在,请重新输入!</h5>
  178. </div>
  179. <div class="modal-footer">
  180. <button type="button" class="btn btn-danger" id="alertCof" data-dismiss="modal">确认</button>
  181. </div>
  182. </div>
  183. </div>
  184. </div>
  185. <!--删除-->
  186. <div class="modal fade" id="delAlert" data-backdrop="static" style="display: none;" aria-hidden="true">
  187. <input type="hidden" value="123">
  188. <div class="modal-dialog" role="document">
  189. <div class="modal-content">
  190. <div class="modal-header">
  191. <h5 class="modal-title">警告</h5>
  192. <button type="button" class="close" data-dismiss="modal" aria-label="Close">
  193. <span aria-hidden="true">×</span>
  194. </button>
  195. </div>
  196. <div class="modal-body">
  197. <h5 class="text-danger" id="delText">是否删除当前行?</h5>
  198. </div>
  199. <div class="modal-footer">
  200. <button type="button" class="btn btn-danger" id="delConfirm">确认</button>
  201. <button type="button" class="btn btn-secondary" data-dismiss="modal">取消</button>
  202. </div>
  203. </div>
  204. </div>
  205. </div>
  206. <!-- JS. -->
  207. <script src = "/lib/spreadjs/sheets/gc.spread.sheets.all.11.1.2.min.js"></script>
  208. <script>GC.Spread.Sheets.LicenseKey = '<%- LicenseKey %>';</script>
  209. <script src="/lib/jquery/jquery.min.js"></script>
  210. <script src="/lib/tether/tether.min.js"></script>
  211. <script src="/lib/bootstrap/bootstrap.min.js"></script>
  212. <script src="/web/maintain/bills_lib/scripts/global.js"></script>
  213. <script src="/public/web/PerfectLoad.js"></script>
  214. <script src="/public/web/common_ajax.js"></script>
  215. <script src="/public/web/lock_util.js"></script>
  216. <script src="/public/web/sheet/sheet_common.js"></script>
  217. <script src="/web/maintain/bills_lib/scripts/set_sheets.js"></script>
  218. <script src="/web/maintain/bills_lib/scripts/bills_lib_ajax.js"></script>
  219. <script src="/web/maintain/bills_lib/scripts/tools.js"></script>
  220. <script src="/public/web/tree_sheet/tree_sheet_helper.js"></script>
  221. <script src="/web/maintain/bills_lib/scripts/bills_lib_setting.js"></script>
  222. <script src="/web/maintain/bills_lib/scripts/db_controller.js"></script>
  223. <SCRIPT type="text/javascript">
  224. const locked = lockUtil.getLocked();
  225. let spread = new GC.Spread.Sheets.Workbook($('#spreadAllItems')[0], {sheetCount: 1});
  226. sheetCommonObj.bindEscKey(spread, [{sheet: spread.getSheet(0), editStarting: totalItemsController.onEditStart, editEnded: totalItemsController.onEditEnded}]);
  227. let spreadVal = new GC.Spread.Sheets.Workbook($('#spreadEigenvalue')[0], {sheetCount: 1});
  228. sheetCommonObj.bindEscKey(spreadVal, [{sheet: spreadVal.getSheet(0), editStarting: valueController.onEditStart, editEnded: valueController.onEditEnded}])
  229. let billsLibId = getQueryString('billsLibId');
  230. tools.redirect(billsLibId, 'stdBillsmain');
  231. let userAccount = '<%= userAccount%>'
  232. let selectedId;
  233. let orgValue;
  234. let orgItemData;
  235. let maxItemsNumber;
  236. let totalItemsDatas;
  237. let valueDatas;
  238. $(document).ready(function(){
  239. $('#aStdBills').attr('href', function(){
  240. return `stdBills?billsLibId=${billsLibId}&locked=${locked}`;
  241. });
  242. $('#aStdJobs').attr('href', function(){
  243. return `stdJobs?billsLibId=${billsLibId}&locked=${locked}`;
  244. });
  245. billsAjax.getStdBillsLibName(billsLibId);
  246. buildAllItems(spread, totalItemsSetting);
  247. buildEigenvalue(spreadVal, eigenValueSetting);
  248. lockUtil.lockSpreads([spread, spreadVal], locked);
  249. });
  250. function buildAllItems(spread, setting){
  251. setSheet.initSheet(spread, setting, true);
  252. myKey.downKey(spread);
  253. myKey.enterKey(spread);
  254. TREE_SHEET_HELPER.loadSheetHeader(setting, spread.getActiveSheet());
  255. itemsAjax.getItemCharacter(billsLibId, function(datas){
  256. spread.getActiveSheet().suspendPaint();
  257. spread.getActiveSheet().setRowCount(datas.length + 10);
  258. let len = datas.length;
  259. for(var i=0; i<len; i++){
  260. if(datas[0].id){
  261. selectedId = datas[0].id;
  262. }
  263. totalItemsSetting.cols.forEach(function(col, colIdx){
  264. spread.getActiveSheet().setTag(i, colIdx, datas[i].id, GC.Spread.Sheets.SheetArea.viewport);
  265. if(datas[i][col.data.field]){
  266. spread.getActiveSheet().getCell(i, colIdx, GC.Spread.Sheets.SheetArea.viewport).value(datas[i][col.data.field]);
  267. }
  268. else {
  269. spread.getActiveSheet().getCell(i, colIdx, GC.Spread.Sheets.SheetArea.viewport).value('');
  270. }
  271. });
  272. }
  273. spread.getActiveSheet().resumePaint();
  274. spread.getActiveSheet().resumeEvent();
  275. //
  276. var totalItems = createObj.newItems();
  277. totalItems.loadItems(null, datas);
  278. totalItemsController.totalItems = totalItems;
  279. initValue(spreadVal.getActiveSheet(), totalItems, eigenValueSetting);
  280. tools.getBillsIds(function(ids){
  281. myKey.delKey(spread, ids, totalItems, totalItemsSetting, 'totalItems');
  282. myKey.delKey(spreadVal, null, totalItems, eigenValueSetting, 'itemValue');
  283. bindSheet(totalItems, spread.getActiveSheet(), spreadVal.getActiveSheet(), totalItemsSetting);
  284. pasteItems(spread.getActiveSheet(), totalItems);
  285. pasteValue(spreadVal.getActiveSheet(), totalItems);
  286. });
  287. });
  288. }
  289. function buildEigenvalue(spread, setting){
  290. setSheet.initSheet(spread, setting, false);
  291. setSheet.setMaxRowCount(spread.getActiveSheet(), 10);
  292. // setSheet.setEditCol(spread.getActiveSheet(), 1);
  293. myKey.downKey(spread);
  294. myKey.enterKey(spread);
  295. TREE_SHEET_HELPER.loadSheetHeader(setting, spread.getActiveSheet());
  296. }
  297. function bindSheet(totalItems, itemSheet, valueSheet, setting){
  298. setSheet.setMaxRowCount(itemSheet, totalItems.itemsArr);
  299. mainAjax.getMaxNumber(billsLibId, 'items', function(result){
  300. if(result.length === 0){
  301. maxItemsNumber = 0;
  302. }
  303. else {
  304. maxItemsNumber = result[0].code;
  305. }
  306. orgItemData = itemSheet.getCell(0, 0).value();
  307. totalItemsController.editData(itemSheet);
  308. });
  309. valueController.editData(valueSheet);
  310. itemSheet.bind(GC.Spread.Sheets.Events.SelectionChanged, function(sender, args){
  311. let itemId = itemSheet.getTag(args.newSelections[0].row, args.newSelections[0].col, GC.Spread.Sheets.SheetArea.viewport);
  312. if(itemId && args.oldSelections[0].row !== args.newSelections[0].row|| itemId && args.oldSelections[0].row === 0){
  313. let valueArr = valueController.getValues(totalItems, itemId);
  314. tools.clearData(valueSheet);
  315. selectedId = itemId;
  316. if(valueArr){
  317. setSheet.setMaxRowCount(valueSheet, valueArr);
  318. tools.reshowValue(valueSheet, valueArr, eigenValueSetting, true);
  319. }
  320. orgValue = valueSheet.getValue(0, 0);
  321. }
  322. else {
  323. tools.clearData(valueSheet);
  324. }
  325. });
  326. }
  327. function initValue(sheet, totalItems, setting){
  328. if(selectedId){
  329. let valueArr = valueController.getValues(totalItems, selectedId);
  330. if(valueArr.length > 0){
  331. setSheet.setMaxRowCount(sheet, valueArr);
  332. tools.reshowValue(sheet, valueArr, setting, true);
  333. }
  334. }
  335. else{
  336. setSheet.setMaxRowCount(sheet, []);
  337. }
  338. }
  339. function pasteItems(sheet, totalItems){
  340. //totalItemsDatas = tools.getsheetDatas(sheet, 'total');
  341. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
  342. totalItemsDatas = tools.getsheetDatas(sheet, 'total');
  343. let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
  344. //复制的列数超过正确的列数,不可复制
  345. if(maxCol >= totalItemsSetting.cols.length){
  346. args.cancel = true;
  347. }
  348. });
  349. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
  350. const colIdx = 1;
  351. let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
  352. let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
  353. let pasteDatas = [], uncrossedDatas = [], crossedDatas = [];
  354. for(let i = orgRow; i<= maxRow; i++){
  355. for(let j =0; j<=1; j++){
  356. let filed = j === 0 ? 'code' : 'content';
  357. if(sheet.getCell(i, j).value()){
  358. let unitData = {
  359. billsLibId: billsLibId,
  360. rowIdx: i,
  361. colIdx: j,
  362. field: filed,
  363. data: sheet.getCell(i, j).value(),
  364. type: 'Create'
  365. };
  366. pasteDatas.push(unitData);
  367. }
  368. }
  369. }
  370. let uniqPasteDatas = tools.uniqObjArr(pasteDatas);
  371. tools.resetRowIdx(uniqPasteDatas, orgRow);
  372. for(let i=0; i< uniqPasteDatas.length; i++){
  373. let crossedData;
  374. let flag = true;
  375. totalItemsDatas.forEach(function(orgData){
  376. if(uniqPasteDatas[i].rowIdx === orgData.rowIdx && uniqPasteDatas[i].colIdx === orgData.colIdx){
  377. flag = false;
  378. crossedData = {
  379. billsLibId: billsLibId,
  380. rowIdx: uniqPasteDatas[i].rowIdx,
  381. colIdx: uniqPasteDatas[i].colIdx,
  382. field: uniqPasteDatas[i].field,
  383. orgId: orgData.id,
  384. data: uniqPasteDatas[i].data,
  385. type: 'Update'
  386. }
  387. }
  388. });
  389. if(flag){
  390. uncrossedDatas.push(uniqPasteDatas[i]);
  391. }
  392. else{
  393. crossedDatas.push(crossedData);
  394. }
  395. }
  396. let encapDatas = tools.encapTotalItemsDatas(sheet, totalItems, uncrossedDatas, crossedDatas);
  397. if(encapDatas.updateDatas.length > 0 || encapDatas.createDatas.length > 0){
  398. itemsAjax.pasteItems(userAccount, billsLibId, encapDatas, function(datas){
  399. pasteController.pasteItemsFront(sheet, totalItems, datas);
  400. });
  401. }
  402. else{
  403. tools.reshowData(sheet, totalItems.itemsArr, totalItemsSetting, true);
  404. }
  405. });
  406. }
  407. function pasteValue(sheet, totalItems){
  408. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasting, function (sender, args) {
  409. valueDatas = tools.getsheetDatas(sheet, 'total');
  410. let maxCol = args.cellRange.col + args.cellRange.colCount - 1;
  411. //复制的列数超过正确的列数,不可复制
  412. if(maxCol >= eigenValueSetting.cols.length){
  413. args.cancel = true;
  414. }
  415. });
  416. sheet.bind(GC.Spread.Sheets.Events.ClipboardPasted, function(sender, args){
  417. const colIdx = 1;
  418. let orgRow = args.cellRange.row, orgCol = args.cellRange.col, rowCount = args.cellRange.rowCount, colCount = args.cellRange.colCount;
  419. let maxRow = orgRow + rowCount - 1, maxCol = orgCol + colCount -1;
  420. let pasteDatas = [], uncrossedDatas = [], crossedDatas = [];
  421. for(let i = orgRow; i<= maxRow; i++){
  422. for(let j =0; j<=1; j++){
  423. let filed = j === 0 ? 'code' : 'value';
  424. if(sheet.getCell(i, j).value()){
  425. let unitData = {
  426. billsLibId: billsLibId,
  427. rowIdx: i,
  428. colIdx: j,
  429. field: filed,
  430. data: sheet.getCell(i, j).value(),
  431. type: 'Create'
  432. };
  433. pasteDatas.push(unitData);
  434. }
  435. }
  436. }
  437. let uniqDatas = tools.uniqObjArr(pasteDatas);
  438. for(let i=0; i< uniqDatas.length; i++){
  439. let crossedData;
  440. let flag = true;
  441. valueDatas.forEach(function(orgData){
  442. if(uniqDatas[i].rowIdx === orgData.rowIdx && uniqDatas[i].colIdx === orgData.colIdx){
  443. flag = false;
  444. crossedData = {
  445. billsLibId: billsLibId,
  446. rowIdx: uniqDatas[i].rowIdx,
  447. colIdx: uniqDatas[i].colIdx,
  448. field: uniqDatas[i].field,
  449. orgId: orgData.id,
  450. data: uniqDatas[i].data,
  451. type: 'Update'
  452. }
  453. }
  454. });
  455. if(flag){
  456. uncrossedDatas.push(uniqDatas[i]);
  457. }
  458. else{
  459. crossedDatas.push(crossedData);
  460. }
  461. }
  462. let encapDatas = tools.encapValues(sheet, totalItems, uncrossedDatas, crossedDatas);
  463. console.log(encapDatas);
  464. if(encapDatas.updateDatas.length > 0 || encapDatas.createDatas.length > 0){
  465. itemsAjax.pasteValues(userAccount, billsLibId, encapDatas, function(datas){
  466. pasteController.pasteValueFront(sheet, totalItems, datas);
  467. });
  468. }
  469. else{
  470. let valuesArr = valueController.getValues(totalItems, selectedId);
  471. if(valuesArr.length > 0){
  472. tools.reshowValue(sheet, valuesArr, eigenValueSetting, true);
  473. }
  474. else {
  475. tools.clearData(sheet);
  476. }
  477. }
  478. });
  479. }
  480. </SCRIPT>
  481. </body>
  482. <script type="text/javascript">
  483. autoFlashHeight();
  484. </script>
  485. </html>