cs_tools.js 76 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635
  1. 'use strict';
  2. /**
  3. * cs_errorList:错误列表
  4. * 使用范围:
  5. * 台账分解(原报)、台账修订(原报)、计量台账(所有角色)
  6. *
  7. * posSearch & billsSearch:台账搜索相关
  8. * 使用范围:
  9. * 0号台账:台账分解、台账审批、台账修订、部位台账;
  10. * 期计量:计量台账、部位台账
  11. *
  12. * 所有工具均基于spreadjs,请放在gc.spread.sheets.all.10.0.1.min.js/spreadjs_zh.js之后
  13. *
  14. * @author Mai
  15. * @date
  16. * @version
  17. */
  18. const showSideTools = function (show) {
  19. const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
  20. if (show) {
  21. right.show();
  22. autoFlashHeight();
  23. /**
  24. * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
  25. * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px
  26. * 故需要通过最终的parent.width再计算一次left.width
  27. *
  28. * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width?
  29. * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width
  30. *
  31. */
  32. //left.css('width', parent.width() - right.outerWidth());
  33. //left.css('width', parent.width() - right.outerWidth());
  34. const percent = 100 - right.outerWidth() /parent.width() * 100;
  35. left.css('width', percent + '%');
  36. } else {
  37. left.width(parent.width());
  38. right.hide();
  39. }
  40. };
  41. const showSelectTab = function(select, spread, afterShow) {
  42. const tab = $(select), tabPanel = $(tab.attr('content'));
  43. $('a', '.side-menu').removeClass('active');
  44. tab.addClass('active');
  45. $('.tab-content .tab-pane').removeClass('active');
  46. tabPanel.addClass('active');
  47. showSideTools(true);
  48. spread && spread.refresh();
  49. if (afterShow) afterShow();
  50. };
  51. (function($){
  52. /**
  53. * 错误列表
  54. * @param setting
  55. * {
  56. * tabSelector: 'a[content=#error-list]',
  57. * selector: '#error-list',
  58. * relaSpread: ledgerSpread,
  59. * storeKey: 'ledger-error-' + tenderId,
  60. * }
  61. * @returns {{spread: *}}
  62. */
  63. $.cs_errorList = function (setting) {
  64. if (!setting.spreadSetting) {
  65. setting.spreadSetting = {
  66. cols: [
  67. {title: '行号', field: 'serialNo', width: 50, formatter: '@', hAlign: 1},
  68. {
  69. title: '错误类型', field: 'errorType', width: 85, formatter: '@',
  70. getValue: function (x) {
  71. switch (x.errorType) {
  72. case 'gather': return '汇总错误';
  73. case 'qty': return '数量';
  74. case 'tp': return '金额';
  75. case 'over': return '超计';
  76. case 'sibling': return '项目节清单同层';
  77. case 'same_code': return '重复项目节编号';
  78. case 's2b_over_gxby': return '违规计量(工序报验)';
  79. case 's2b_over_dagl': return '违规计量(档案管理)';
  80. case 's2b_lost_gxby': return '遗漏计量(工序报验)';
  81. case 's2b_lost_dagl': return '遗漏计量(档案管理)';
  82. case 'minus_cb': return '负变更清单漏计';
  83. default: return '';
  84. }
  85. }
  86. },
  87. {title: '清单编号', field: 'b_code', width: 85, formatter: '@'},
  88. {title: '清单名称', field: 'name', width: 165, formatter: '@'},
  89. {title: '备注', field: 'memo', width: 100, formatter: '@'},
  90. ],
  91. emptyRows: 0,
  92. headRows: 1,
  93. headRowHeight: [32],
  94. defaultRowHeight: 21,
  95. headerFont: '12px 微软雅黑',
  96. font: '12px 微软雅黑',
  97. selectedBackColor: '#fffacd',
  98. readOnly: true,
  99. };
  100. }
  101. const clearErrorData = function () {
  102. if (setting.storeKey) removeLocalCache(setting.storeKey);
  103. };
  104. const autoShowHistory = function (show) {
  105. if (setting.storeKey) {
  106. setLocalCache(setting.storeKey + '-showHis', show.toString());
  107. }
  108. };
  109. if (setting.selector && setting.relaSpread) {
  110. const resultId = setting.id + '-spread';
  111. const obj = $(setting.selector);
  112. obj.html(
  113. ' <div id="' + resultId + '" class="sjs-sh">\n' +
  114. ' </div>'
  115. );
  116. autoFlashHeight();
  117. const spread = SpreadJsObj.createNewSpread($('#' + resultId)[0]);
  118. const sheet = spread.getActiveSheet();
  119. SpreadJsObj.initSheet(sheet, setting.spreadSetting);
  120. spread.getActiveSheet().bind(spreadNS.Events.CellDoubleClick, function (e, info) {
  121. const sheet = info.sheet;
  122. const data = sheet.zh_data;
  123. if (!data) { return }
  124. const curBills = data[info.row];
  125. if (!curBills) { return }
  126. SpreadJsObj.locateTreeNode(setting.relaSpread.getActiveSheet(), curBills.ledger_id, true);
  127. if (setting.afterLocated) {
  128. setting.afterLocated();
  129. }
  130. });
  131. const loadErrorData = function (data, his = false) {
  132. const sourceTree = setting.relaSpread.getActiveSheet().zh_tree;
  133. if (!sourceTree) return;
  134. for (const d of data) {
  135. d.serialNo = sourceTree.getNodeIndex(sourceTree.getItems(d.ledger_id)) + 1;
  136. }
  137. data.sort(function (a, b) {
  138. return a.serialNo ? (b.serialNo ? a.serialNo - b.serialNo : 1) : 1;
  139. });
  140. SpreadJsObj.loadSheetData(sheet, SpreadJsObj.DataType.Data, data);
  141. if (!his && setting.storeKey) {
  142. setLocalCache(setting.storeKey, JSON.stringify(data));
  143. }
  144. $(setting.tabSelector).show();
  145. };
  146. const showErrorList = function () {
  147. const tab = $(setting.tabSelector), tabPanel = $(tab.attr('content'));
  148. $('a', '.side-menu').removeClass('active');
  149. tab.addClass('active');
  150. $('.tab-content .tab-pane').removeClass('active');
  151. tabPanel.addClass('active');
  152. showSideTools(true);
  153. spread.refresh();
  154. if (setting.afterShow) setting.afterShow();
  155. };
  156. const loadHisErrorData = function () {
  157. if (setting.storeKey) {
  158. const storeStr = getLocalCache(setting.storeKey);
  159. const storeData = storeStr ? JSON.parse(storeStr) : [];
  160. if (storeData.length > 0) {
  161. loadErrorData(storeData, true);
  162. const showHis = getLocalCache(setting.storeKey + '-showHis');
  163. if (showHis === 'true') {
  164. showErrorList();
  165. removeLocalCache(setting.storeKey + '-showHis');
  166. }
  167. }
  168. }
  169. };
  170. return {
  171. spread: spread,
  172. loadErrorData: loadErrorData,
  173. clearErrorData: clearErrorData,
  174. loadHisErrorData: loadHisErrorData,
  175. show: showErrorList,
  176. autoShowHistory: autoShowHistory,
  177. };
  178. } else {
  179. const loadErrorData = function (data) {
  180. if (setting.storeKey) {
  181. setLocalCache(setting.storeKey, JSON.stringify(data));
  182. }
  183. };
  184. return {
  185. loadErrorData: loadErrorData,
  186. clearErrorData: clearErrorData,
  187. autoShowHistory: autoShowHistory,
  188. };
  189. }
  190. };
  191. $.ledger_checkList = function (setting) {
  192. const checkTypeText = [];
  193. for (const ct in setting.checkType) {
  194. checkTypeText[setting.checkType[ct].value] = setting.checkType[ct].text;
  195. }
  196. if (!setting.spreadSetting) {
  197. setting.spreadSetting = {
  198. cols: [
  199. {
  200. title: '类型', field: 'type', width: 150, formatter: '@',
  201. getValue: function (data){
  202. if (setting.checkType) {
  203. return checkTypeText[data.type] || '';
  204. } else {
  205. return '';
  206. }
  207. }
  208. },
  209. {title: '行号', field: 'serialNo', hAlign: 1, width: 40, formatter: '@'},
  210. {title: '项目节编号\n(变更令号)', field: 'code', width: 80, formatter: '@'},
  211. {title: '清单编号', field: 'b_code', width: 80, formatter: '@'},
  212. {title: '名称', field: 'name', width: 150, formatter: '@'},
  213. ],
  214. emptyRows: 0,
  215. headRows: 1,
  216. headRowHeight: [32],
  217. defaultRowHeight: 21,
  218. headerFont: '12px 微软雅黑',
  219. font: '12px 微软雅黑',
  220. selectedBackColor: '#fffacd',
  221. readOnly: true,
  222. };
  223. }
  224. const clearCheckData = function () {
  225. if (setting.storeKey) removeLocalCache(setting.storeKey);
  226. };
  227. const autoShowHistory = function (show) {
  228. if (setting.storeKey) {
  229. setLocalCache(setting.storeKey + '-showHis', show.toString());
  230. }
  231. };
  232. if (setting.selector && setting.relaSpread) {
  233. const resultId = setting.id + '-spread';
  234. const obj = $(setting.selector);
  235. const dropdown = [];
  236. if (setting.checkType) {
  237. dropdown.push('<div class="dropdown">');
  238. dropdown.push('<button class="btn btn-sm btn-outline-primary dropdown-toggle" type="button" id="'+ setting.id + 'drop" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">所有类型</button>');
  239. dropdown.push('<div class="dropdown-menu" aria-labelledby="'+ setting.id + 'drop">');
  240. dropdown.push('<a class="dropdown-item" href="javascript: void(0);" check-type="all">所有类型</a>');
  241. for (const ct in setting.checkType) {
  242. dropdown.push('<a class="dropdown-item" href="javascript: void(0);" check-type="' + setting.checkType[ct].value +'">' + setting.checkType[ct].text + '</a>');
  243. }
  244. dropdown.push('</div>');
  245. dropdown.push('</div>');
  246. }
  247. obj.html(
  248. '<div class="sjs-bar">\n' +
  249. ' <div class="pb-1 d-flex">\n' + dropdown.join('') +
  250. ' <span class="ml-auto pr-2" id="' + setting.id + '-time">检查时间:2020-08-01 13:20:25</span>\n' +
  251. ' </div>\n' +
  252. '</div>' +
  253. '<div id="' + resultId + '" class="sjs-sh">\n' +
  254. '</div>'
  255. );
  256. autoFlashHeight();
  257. const spread = SpreadJsObj.createNewSpread($('#' + resultId)[0]);
  258. const sheet = spread.getActiveSheet();
  259. SpreadJsObj.initSheet(sheet, setting.spreadSetting);
  260. spread.getActiveSheet().bind(spreadNS.Events.CellDoubleClick, function (e, info) {
  261. const sheet = info.sheet;
  262. const data = sheet.zh_data;
  263. if (!data) { return }
  264. const curBills = data[info.row];
  265. if (!curBills) { return }
  266. SpreadJsObj.locateTreeNode(setting.relaSpread.getActiveSheet(), curBills.ledger_id, true);
  267. if (setting.afterLocated) {
  268. setting.afterLocated();
  269. }
  270. });
  271. const filterCheckData = function () {
  272. const filter = $(this).attr('check-type');
  273. $('#' + setting.id + 'drop').html(this.innerHTML);
  274. for (const d of sheet.zh_data) {
  275. if (filter === 'all') {
  276. d.visible = true;
  277. } else {
  278. d.visible = d.type == filter;
  279. }
  280. }
  281. SpreadJsObj.refreshTreeRowVisible(sheet);
  282. };
  283. $('a[check-type]').bind('click', filterCheckData);
  284. const hideCheckData = function () {
  285. const tab = $(setting.tabSelector), tabPanel = $(tab.attr('content'));
  286. if (tab.hasClass('active')) {
  287. $('a', '.side-menu').removeClass('active');
  288. tab.addClass('active');
  289. $('.tab-content .tab-pane').removeClass('active');
  290. tabPanel.addClass('active');
  291. showSideTools(false);
  292. if (spread) spread.refresh();
  293. if (setting.afterShow) setting.afterShow();
  294. tab.hide();
  295. }
  296. };
  297. const loadCheckData = function (data, his = false) {
  298. const sourceTree = setting.relaSpread.getActiveSheet().zh_tree;
  299. if (!sourceTree) return;
  300. for (const d of data.warning_data) {
  301. d.serialNo = sourceTree.getNodeIndex(sourceTree.getItems(d.ledger_id)) + 1;
  302. }
  303. $('#' + setting.id + '-time').html('检查时间:' + moment(data.check_time).format('YYYY-MM-DD HH:mm:ss'));
  304. SpreadJsObj.loadSheetData(sheet, SpreadJsObj.DataType.Data, data.warning_data);
  305. if (!his && setting.storeKey) {
  306. setLocalCache(setting.storeKey, JSON.stringify(data));
  307. }
  308. $(setting.tabSelector).show();
  309. };
  310. const showCheckList = function () {
  311. const tab = $(setting.tabSelector), tabPanel = $(tab.attr('content'));
  312. $('a', '.side-menu').removeClass('active');
  313. tab.addClass('active');
  314. $('.tab-content .tab-pane').removeClass('active');
  315. tabPanel.addClass('active');
  316. showSideTools(true);
  317. spread.refresh();
  318. if (setting.afterShow) setting.afterShow();
  319. };
  320. const loadHisCheckData = function () {
  321. if (setting.storeKey) {
  322. const storeStr = getLocalCache(setting.storeKey);
  323. const storeData = storeStr ? JSON.parse(storeStr) : null;
  324. if (storeData) {
  325. loadCheckData(storeData, true);
  326. const showHis = getLocalCache(setting.storeKey + '-showHis');
  327. if (showHis === 'true') {
  328. showCheckList();
  329. removeLocalCache(setting.storeKey + '-showHis');
  330. }
  331. }
  332. }
  333. };
  334. return {
  335. spread: spread,
  336. loadCheckData: loadCheckData,
  337. clearCheckData: clearCheckData,
  338. loadHisCheckData: loadHisCheckData,
  339. show: showCheckList,
  340. hide: hideCheckData,
  341. autoShowHistory: autoShowHistory,
  342. };
  343. } else {
  344. const loadCheckData = function (data) {
  345. if (setting.storeKey) {
  346. setLocalCache(setting.storeKey, JSON.stringify(data));
  347. }
  348. };
  349. return {
  350. loadCheckData: loadCheckData,
  351. clearCheckData: clearCheckData,
  352. autoShowHistory: autoShowHistory,
  353. };
  354. }
  355. };
  356. $.posSearch = function (setting) {
  357. if (!setting.selector || !setting.searchSpread) return;
  358. const searchHtml =
  359. ' <div class="ml-2">\n' +
  360. ' <div class="input-group input-group-sm">\n' +
  361. ' <input type="text" class="form-control" placeholder="输入名称查找" id="pos-keyword">\n' +
  362. ' <div class="input-group-append">\n' +
  363. ' <span class="input-group-text" id="pos-search-hint">结果:0</span>\n' +
  364. ' </div>\n' +
  365. ' <div class="input-group-append" >\n' +
  366. ' <button class="btn btn-outline-secondary" type="button" title="上一个" id="search-pre-pos"><i class="fa fa-angle-double-left"></i></button>\n' +
  367. ' <button class="btn btn-outline-secondary" type="button" title="下一个" id="search-next-pos"><i class="fa fa-angle-double-right"></i></button>\n' +
  368. ' </div>\n' +
  369. ' </div>\n' +
  370. ' </div>\n';
  371. $(setting.selector).html(searchHtml);
  372. const sheet = setting.searchSpread.getActiveSheet();
  373. const searchObj = (function () {
  374. let resultArr = [];
  375. const search = function (keyword) {
  376. if (keyword && keyword !== '') {
  377. resultArr = [];
  378. const sortData = sheet.zh_data;
  379. if (sortData) {
  380. for (let i = 0, iLength = sortData.length; i < iLength; i++) {
  381. const sd = sortData[i];
  382. if (sd.name && sd.name.indexOf(keyword) > -1) {
  383. resultArr.push({index: i, data: sd});
  384. }
  385. }
  386. }
  387. } else {
  388. resultArr = [];
  389. }
  390. $('#pos-search-hint').html('结果:' + resultArr.length);
  391. };
  392. const searchAndLocate = function (keyword) {
  393. search(keyword);
  394. if (resultArr.length > 0) {
  395. const sel = sheet.getSelections()[0];
  396. const curRow = sel ? sel.row : 0;
  397. const pos = resultArr[0];
  398. if (pos.index !== curRow) {
  399. sheet.setSelection(pos.index, sel ? sel.col : 0, 1, 1);
  400. sheet.getParent().focus();
  401. sheet.showRow(pos.index, spreadNS.VerticalPosition.center);
  402. SpreadJsObj.reloadRowsBackColor(sheet, [pos.index, curRow]);
  403. }
  404. }
  405. };
  406. const locateNext = function () {
  407. if (resultArr.length > 0) {
  408. const sel = sheet.getSelections()[0];
  409. const curRow = sel ? sel.row : 0;
  410. let next = _.find(resultArr, function (d) {
  411. return d.index > curRow;
  412. });
  413. if (!next) next = resultArr[0];
  414. if (next.index !== curRow) {
  415. sheet.setSelection(next.index, sel ? sel.col : 0, 1, 1);
  416. sheet.getParent().focus();
  417. sheet.showRow(next.index, spreadNS.VerticalPosition.center);
  418. SpreadJsObj.reloadRowsBackColor(sheet, [next.index, curRow]);
  419. }
  420. }
  421. };
  422. const locatePre = function () {
  423. if (resultArr.length > 0) {
  424. const sel = sheet.getSelections()[0];
  425. const curRow = sel ? sel.row : 0;
  426. let next = _.findLast(resultArr, function (d) {
  427. return d.index < curRow;
  428. });
  429. if (!next) next = resultArr[resultArr.length - 1];
  430. if (next.index !== curRow) {
  431. sheet.setSelection(next.index, sel ? sel.col : 0, 1, 1);
  432. sheet.getParent().focus();
  433. sheet.showRow(next.index, spreadNS.VerticalPosition.center);
  434. SpreadJsObj.reloadRowsBackColor(sheet, [next.index, curRow]);
  435. }
  436. }
  437. };
  438. return {search, searchAndLocate, locateNext, locatePre};
  439. })();
  440. // $('#pos-keyword').bind('input propertychange', function () {
  441. // posSearch.search(this.value);
  442. // });
  443. $('#pos-keyword').bind('keydown', function(e){
  444. if (e.keyCode == 13) searchObj.searchAndLocate(this.value);
  445. });
  446. $('#search-pre-pos').click(function () {
  447. searchObj.locatePre();
  448. });
  449. $('#search-next-pos').click(function () {
  450. searchObj.locateNext();
  451. });
  452. return searchObj;
  453. };
  454. $.billsSearch = function (setting) {
  455. if (!setting.selector || !setting.searchSpread || !setting.resultSpreadSetting) return;
  456. if (!setting.searchRangeStr) setting.searchRangeStr = '项目节编号/清单编号/名称/台账数量';
  457. if (!setting.keyId) setting.keyId = 'ledger_id';
  458. const resultId = setting.id + '-search-result';
  459. const obj = $(setting.selector);
  460. let filter = [];
  461. if (setting.searchOver || setting.searchEmpty) {
  462. filter.push('<select class="input-group-text" id="search-filter">');
  463. filter.push('<option value="">台账</option>');
  464. if (setting.customSearch) {
  465. for (const cs of setting.customSearch) {
  466. if (cs.valid) filter.push('<option value="' + cs.key + '">' + cs.title + '</option>');
  467. }
  468. }
  469. filter.push('</select>');
  470. }
  471. obj.html(
  472. ' <div class="sjs-bar">\n' +
  473. ' <div class="input-group input-group-sm pb-1">\n' +
  474. ' <div class="input-group-prepend">\n' +
  475. filter.join('') +
  476. ' </div>' +
  477. ' <input id="searchKeyword" type="text" class="form-control" autocomplete="off" placeholder="可查找 ' + setting.searchRangeStr + '" aria-label="Recipient\'s username" aria-describedby="button-addon2">\n' +
  478. ' <div class="input-group-append">\n' +
  479. ' <button class="btn btn-outline-secondary" type="button"">搜索</button>\n' +
  480. ' </div>\n' +
  481. ' </div>\n' +
  482. ' </div>\n' +
  483. ' <div id="' + resultId + '" class="sjs-sh">\n' +
  484. ' </div>'
  485. );
  486. autoFlashHeight();
  487. const resultSpread = SpreadJsObj.createNewSpread($('#' + resultId)[0]);
  488. SpreadJsObj.initSheet(resultSpread.getActiveSheet(), setting.resultSpreadSetting);
  489. const searchSheet = setting.searchSpread.getActiveSheet();
  490. let searchResult = [];
  491. const search = function () {
  492. const filter = $('#search-filter').val();
  493. if (filter) {
  494. searchCustom(filter);
  495. } else {
  496. searchBills();
  497. }
  498. };
  499. const get18Bw = function(tree, data) {
  500. let parent = tree.getParent(data);
  501. while (parent && (!parent.code || /^[a-zA-Z]/.test(parent.code || ''))) {
  502. parent = tree.getParent(parent);
  503. }
  504. return parent ? parent.name : '';
  505. };
  506. const get08Bw = function(tree, data) {
  507. let parent = tree.getParent(data);
  508. let lastXmj = '', level4Xmj = '';
  509. while (parent) {
  510. if (parent.code && !lastXmj) lastXmj = parent.name;
  511. if (parent.code && parent.level === 4) level4Xmj = parent.name;
  512. parent = tree.getParent(parent);
  513. }
  514. return level4Xmj || lastXmj;
  515. };
  516. const getBw = function (data) {
  517. if (!data.b_code) return '';
  518. if (searchSheet.zh_dataType !== SpreadJsObj.DataType.Tree) return '';
  519. const sortTree = searchSheet.zh_tree;
  520. if (!sortTree.checkCodeType) return '';
  521. if (sortTree.checkCodeType() === '18') {
  522. return get18Bw(sortTree, data)
  523. } else {
  524. return get08Bw(sortTree, data);
  525. }
  526. };
  527. const searchBills = function () {
  528. const keyword = $('#searchKeyword', obj).val();
  529. const keyNum = _.toNumber(keyword);
  530. searchResult = [];
  531. const sortData = SpreadJsObj.getSortData(searchSheet);
  532. for (const node of sortData) {
  533. if ((node.code && node.code.indexOf(keyword) > -1) ||
  534. (node.b_code && node.b_code.indexOf(keyword) > -1) ||
  535. (node.name && node.name.indexOf(keyword) > -1) ||
  536. (!_.isNaN(keyNum) && checkZero(ZhCalc.sub(keyNum, node.quantity)))
  537. ) {
  538. const data = JSON.parse(JSON.stringify(node));
  539. data.visible = true;
  540. data.bw = getBw(data);
  541. searchResult.push(data);
  542. }
  543. }
  544. calculateCompletePercent(searchResult);
  545. calculateSum();
  546. SpreadJsObj.loadSheetData(resultSpread.getActiveSheet(), 'data', searchResult);
  547. };
  548. const getCheckFun = function (key) {
  549. const cs = setting.customSearch.find(function (x) {return x.key === key});
  550. return cs ? cs.check : null;
  551. };
  552. const getParantFun = function (key) {
  553. const cs = setting.customSearch.find(function (x) {return x.key === key});
  554. return cs && cs.parent !== undefined ? cs.parent : false;
  555. };
  556. const searchCustom = function (key) {
  557. const keyword = $('#searchKeyword', obj).val();
  558. const keyNum = _.toNumber(keyword);
  559. const checkFun = getCheckFun(key);
  560. searchResult = [];
  561. const sortData = SpreadJsObj.getSortData(searchSheet);
  562. const parantFun = getParantFun(key);
  563. for (const node of sortData) {
  564. if (node.children && node.children.length > 0 && !parantFun) continue;
  565. if (checkFun && checkFun(node)) {
  566. if (!keyword ||
  567. (node.code && node.code.indexOf(keyword) > -1) ||
  568. (node.b_code && node.b_code.indexOf(keyword) > -1) ||
  569. (node.name && node.name.indexOf(keyword) > -1) ||
  570. (!_.isNaN(keyNum) && checkZero(ZhCalc.sub(keyNum, node.quantity)))
  571. ) {
  572. const data = JSON.parse(JSON.stringify(node));
  573. data.visible = true;
  574. searchResult.push(data);
  575. }
  576. }
  577. }
  578. calculateCompletePercent(searchResult);
  579. calculateSum();
  580. SpreadJsObj.loadSheetData(resultSpread.getActiveSheet(), 'data', searchResult);
  581. };
  582. const calculateSum = function () {
  583. if (!searchResult || searchResult.length === 0 || !setting.calcSum) return;
  584. const sum = setting.calcSum(searchResult);
  585. if (sum) searchResult.unshift(sum);
  586. };
  587. const calculateCompletePercent = function (searchResult) {
  588. if (!searchResult) return;
  589. for (const sr of searchResult) {
  590. const base = ZhCalc.add(sr.total_price, sr.end_qc_tp);
  591. sr.complete_percent = base !== 0 ? ZhCalc.mul(ZhCalc.div(sr.end_gather_tp, base), 100, 2) : 0;
  592. }
  593. };
  594. $('input', obj).bind('keydown', function (e) {
  595. if (e.keyCode == 13) search();
  596. });
  597. $('button', obj).bind('click', () => {search()});
  598. resultSpread.getActiveSheet().bind(spreadNS.Events.CellDoubleClick, function (e, info) {
  599. const sheet = info.sheet;
  600. const data = sheet.zh_data;
  601. if (!data) { return }
  602. const curBills = data[info.row];
  603. if (!curBills || curBills[setting.keyId] === undefined) { return }
  604. SpreadJsObj.locateTreeNode(searchSheet, curBills[setting.keyId], true);
  605. if (setting.afterLocated) {
  606. setting.afterLocated();
  607. }
  608. });
  609. return {spread: resultSpread};
  610. };
  611. $.listSearch = function (setting) {
  612. if (!setting.selector || !setting.searchSpread || !setting.resultSpreadSetting) return;
  613. if (!setting.searchRangeStr) setting.searchRangeStr = '清单编号/名称';
  614. const resultId = setting.id + '-search-result';
  615. const obj = $(setting.selector);
  616. let filter = [];
  617. if (setting.searchOver || setting.searchEmpty) {
  618. filter.push('<select class="input-group-text" id="search-filter">');
  619. filter.push('<option value="">台账</option>');
  620. if (setting.customSearch) {
  621. for (const cs of setting.customSearch) {
  622. if (cs.valid) filter.push('<option value="' + cs.key + '">' + cs.title + '</option>');
  623. }
  624. }
  625. filter.push('</select>');
  626. }
  627. obj.html(
  628. ' <div class="sjs-bar">\n' +
  629. ' <div class="input-group input-group-sm pb-1">\n' +
  630. ' <div class="input-group-prepend">\n' +
  631. filter.join('') +
  632. ' </div>' +
  633. ' <input id="searchKeyword" type="text" class="form-control" autocomplete="off" placeholder="可查找 ' + setting.searchRangeStr + '" aria-label="Recipient\'s username" aria-describedby="button-addon2">\n' +
  634. ' <div class="input-group-append">\n' +
  635. ' <button class="btn btn-outline-secondary" type="button"">搜索</button>\n' +
  636. ' </div>\n' +
  637. ' </div>\n' +
  638. ' </div>\n' +
  639. ' <div id="' + resultId + '" class="sjs-sh">\n' +
  640. ' </div>'
  641. );
  642. autoFlashHeight();
  643. const resultSpread = SpreadJsObj.createNewSpread($('#' + resultId)[0]);
  644. SpreadJsObj.initSheet(resultSpread.getActiveSheet(), setting.resultSpreadSetting);
  645. const searchSheet = setting.searchSpread.getActiveSheet();
  646. let searchResult = [];
  647. const search = function () {
  648. const filter = $('#search-filter').val();
  649. if (filter) {
  650. searchCustom(filter);
  651. } else {
  652. searchList();
  653. }
  654. };
  655. const calulateSum = function () {
  656. if (searchResult.length === 0 || !setting.calcSum) return;
  657. searchResult.unshift(setting.calcSum(searchResult));
  658. };
  659. const searchList = function () {
  660. const keyword = $('#searchKeyword', obj).val();
  661. searchResult = [];
  662. const sortData = SpreadJsObj.getSortData(searchSheet);
  663. for (const [i, node] of sortData.entries()) {
  664. if (setting.check(node, keyword)) {
  665. const data = JSON.parse(JSON.stringify(node));
  666. data.searchIndex = i;
  667. data.visible = true;
  668. searchResult.push(data);
  669. }
  670. }
  671. calulateSum();
  672. SpreadJsObj.loadSheetData(resultSpread.getActiveSheet(), 'data', searchResult);
  673. };
  674. const getCheckFun = function (key) {
  675. const cs = setting.customSearch.find(function (x) {return x.key === key});
  676. return cs ? cs.check : null;
  677. };
  678. const searchCustom = function (key) {
  679. const keyword = $('#searchKeyword', obj).val();
  680. const checkFun = getCheckFun(key);
  681. searchResult = [];
  682. const sortData = SpreadJsObj.getSortData(searchSheet);
  683. for (const [i, node] of sortData.entries()) {
  684. if (checkFun && checkFun(node)) {
  685. if (setting.check(node, keyword)) {
  686. const data = JSON.parse(JSON.stringify(node));
  687. data.searchIndex = i;
  688. data.visible = true;
  689. searchResult.push(data);
  690. }
  691. }
  692. }
  693. calulateSum();
  694. SpreadJsObj.loadSheetData(resultSpread.getActiveSheet(), 'data', searchResult);
  695. };
  696. $('input', obj).bind('keydown', function (e) {
  697. if (e.keyCode == 13) search();
  698. });
  699. $('button', obj).bind('click', () => {search()});
  700. resultSpread.getActiveSheet().bind(spreadNS.Events.CellDoubleClick, function (e, info) {
  701. const cur = SpreadJsObj.getSelectObject(info.sheet);
  702. if (!cur || cur.searchIndex < 0) return;
  703. SpreadJsObj.locateRow(searchSheet, cur.searchIndex);
  704. if (setting.afterLocated) {
  705. setting.afterLocated();
  706. }
  707. });
  708. return {spread: resultSpread};
  709. };
  710. $.billsTag = function (setting) {
  711. if (!setting.selector || !setting.relaSpread) return;
  712. if (!setting.tagType) setting.tagType = [
  713. {tagClass: 'text-primary', color: '#007bff'},
  714. {tagClass: 'text-success', color: '#28a745'},
  715. {tagClass: 'text-danger', color: '#dc3545'},
  716. {tagClass: 'text-warning', color: '#da9500'},
  717. {tagClass: 'text-info', color: '#17a2b8'},
  718. ];
  719. const obj = $(setting.selector);
  720. const html = [], pageLength = 15;
  721. let billsTags = [], classIndexes = [], billsIndexes = {}, curShow = [];
  722. html.push('<div class="sjs-bar d-flex justify-content-between">');
  723. // 下拉过滤
  724. html.push('<div class="dropdown mr-2">');
  725. html.push('<a class="btn btn-sm btn-outline-secondary" id="dmb-bills-tag" data-toggle="dropdown" title="优先显示" aria-expanded="false"><i class="fa fa-list-ol" id="bills-tag-filter"></i></a>');
  726. html.push('<div class="dropdown-menu" aria-labelledby="dmb-bills-tag" style="min-width: 60px; position: absolute; transform: translate3d(0px, 22px, 0px); top: 0px; left: 0px; will-change: transform;" x-placement="bottom-start">');
  727. html.push('<a class="dropdown-item" href="javascript: void(0);" tagType="all" ><i class="fa fa-list-ol"></i></a>');
  728. for (const t of setting.tagType) {
  729. html.push(`<a class="dropdown-item ${t.tagClass}" href="javascript: void(0);" tagType="${t.tagClass}" ><i class="fa fa-tag"></i></a>`);
  730. t.tags = [];
  731. classIndexes.push(t);
  732. }
  733. html.push('</div>', '</div>');
  734. // 搜索框
  735. html.push('<div class="input-group input-group-sm">');
  736. html.push('<input type="text" class="form-control" placeholder="可查找 项目节编号 / 清单编号 /名称" id="bills-tag-keyword" autocomplete="off">');
  737. html.push('<div class="input-group-append">', '<div class="input-group-cancel">',
  738. '<a href="javascript: void(0);" id="bills-tag-clear" class="text-danger"><i class="fa fa-times-circle" title="移除搜索结果"></i></a>', '</div>',
  739. '<button class="btn btn-outline-secondary" type="button" id="bills-tag-search">搜索</button>', '</div>');
  740. html.push('</div>');
  741. html.push('</div>');
  742. // 书签列表
  743. html.push('<div class="sjs-sh" style="overflow: auto;" id="bills-tag-list"></div>');
  744. obj.html(html.join(''));
  745. const clearViewTags = function () {
  746. const viewTags = $('.tag-item', obj);
  747. if (viewTags && viewTags.length > 0) viewTags.remove();
  748. billsTags.forEach(x => {x.display = false});
  749. };
  750. const getTagEditHtml = function(tag) {
  751. const tagClass = classIndexes.find(x => {return x.color === tag.color}) || {};
  752. const tagHtml = [];
  753. tagHtml.push('<div name="tag-edit">');
  754. tagHtml.push('<div class="card-header p-2"><div class="dropdown">');
  755. tagHtml.push(`<a class="pull-left mr-2" href="javascript: void(0);" id="tag-change-color" tag-color="${tag.color}" data-toggle="dropdown" aria-expanded="false"><i class="fa fa-tag ${tagClass.tagClass}" title="修改书签颜色"></i></a>`);
  756. // 下拉选择颜色
  757. tagHtml.push('<div class="dropdown-menu" aria-labelledby="tag-change-color" style="min-width:60px">',
  758. '<a class="dropdown-item text-primary" href="javascript: void(0);" name="tag-color"><i class="fa fa-tint"></i></a>',
  759. '<a class="dropdown-item text-success " href="javascript: void(0);" name="tag-color"><i class="fa fa-tint"></i></a>',
  760. '<a class="dropdown-item text-danger " href="javascript: void(0);" name="tag-color"><i class="fa fa-tint"></i></a>',
  761. '<a class="dropdown-item text-warning " href="javascript: void(0);" name="tag-color"><i class="fa fa-tint"></i></a>',
  762. '<a class="dropdown-item text-info " href="javascript: void(0);" name="tag-color"><i class="fa fa-tint"></i></a>', '</div>');
  763. tagHtml.push('</div>');
  764. tag.node && tagHtml.push((tag.node.code || '') + (tag.node.b_code || ''), ' / ', tag.node.name || '');
  765. tagHtml.push('</div>');
  766. tagHtml.push('<div class="card-body p-2">');
  767. tagHtml.push('<p class="card-text">', '<textarea class="form-control form-control-sm p-1" id="tag-comment">', tag.comment, '</textarea>', '</p>');
  768. tagHtml.push('<div class="d-flex justify-content-between">');
  769. // 参与人可见
  770. tagHtml.push('<div class="custom-control custom-switch mr-2">');
  771. tagHtml.push('<input type="checkbox" class="custom-control-input custom-control-warning-input" id="tag-share"', tag.share ? 'checked' : '', '>');
  772. tagHtml.push('<label class="custom-control-label custom-control-warning-label" for="tag-share" data-toggle="tooltip" data-placement="bottom" title="" data-original-title="所有参与台账审批管理的用户都可以看到这条书签"><i class="fa fa-users"></i> 参与者可见</label>');
  773. tagHtml.push('</div>');
  774. // 编辑按钮
  775. tagHtml.push('<div>', '<button type="button" class="btn btn-sm btn-outline-danger mr-3" id="tag-del"><i class="fa fa-close"></i> 删除书签</button>',
  776. '<button type="button" class="btn btn-sm btn-outline-success mr-1" id="tag-edit-ok"><i class="fa fa-check"></i> 确定</button>',
  777. '<button type="button" class="btn btn-sm btn-outline-secondary" id="tag-edit-cancel">取消</button>', '</div>');
  778. tagHtml.push('</div>');
  779. tagHtml.push('</div>');
  780. tagHtml.push('</div>');
  781. return tagHtml.join('');
  782. };
  783. const getTagDisplayHtml = function (tag) {
  784. console.log(tag);
  785. const tagClass = classIndexes.find(x => {return x.color === tag.color}) || {};
  786. const tagHtml = [];
  787. tagHtml.push('<div name="tag-view">');
  788. tagHtml.push('<div class="card-header p-2"><div class="dropdown">');
  789. tagHtml.push(`<div class="pull-left mr-2"><i class="fa fa-tag ${tagClass.tagClass}"></i></div>`);
  790. tagHtml.push('</div>');
  791. tag.node && tagHtml.push((tag.node.code || '') + (tag.node.b_code || ''), ' / ', tag.node.name || '');
  792. if (tag.share) {
  793. tagHtml.push(`<div class="pull-right"><i class="fa fa-users text-warning" data-toggle="tooltip" data-placement="bottom" title="" data-original-title="所有参与台账审批管理的用户都可以看到这条书签"></i> <span>${tag.u_name}</span></div>`);
  794. }
  795. tagHtml.push('<div class="pull-right edit-tag-btn">');
  796. const lid = tag.node ? tag.node.ledger_id : -1;
  797. tagHtml.push(`<a class="mr-1" name="bills-tag-locate" href="javascript: void(0);" lid="${lid}"><i class="fa fa-crosshairs"></i> 定位</a>`);
  798. if (tag.uid === userID && !setting.readOnly) tagHtml.push(`<a href="javascript: void(0);" name="bills-tag-edit" tag-id="${tag.id}"><i class="fa fa-edit"></i> 编辑</a>`);
  799. tagHtml.push('</div>');
  800. tagHtml.push('<div class="card-body p-2">', '<p class="card-text">', tag.comment, '</p>', '</div>');
  801. tagHtml.push('</div>');
  802. return tagHtml.join('');
  803. };
  804. const searchTagsAndShow = function () {
  805. const keyword = $('#bills-tag-keyword').val();
  806. const filterClass = $('#bills-tag-filter')[0].classList;
  807. const tagClass = filterClass.length > 2 ? filterClass[2] : null;
  808. const ci = tagClass ? classIndexes.find(x => {return x.tagClass === tagClass}) : null;
  809. curShow = billsTags.filter(x => {
  810. if (ci && ci.color !== x.color) return false;
  811. if (!keyword) return true;
  812. if (x.node.code && x.node.code.indexOf(keyword) >= 0) return true;
  813. if (x.node.b_code && x.node.b_code.indexOf(keyword) >= 0) return true;
  814. if (x.node.name && x.node.name.indexOf(keyword) >= 0) return true;
  815. return false;
  816. });
  817. reloadViewTags();
  818. };
  819. const refreshTagView = function (tag) {
  820. const obj = $('#bills-tag-' + tag.id);
  821. if (obj && obj.length > 0) {
  822. obj.html(getTagDisplayHtml(tag));
  823. }
  824. };
  825. const refreshBillsTagView = function (bills) {
  826. const bi = billsIndexes[bills.id] || [];
  827. for (const tag of bi) {
  828. refreshTagView(tag);
  829. }
  830. };
  831. const reviewTag = function (tag, isTop = false) {
  832. const obj = $('#bills-tag-' + tag.id);
  833. if (obj && obj.length > 0) {
  834. obj.html(getTagDisplayHtml(tag));
  835. } else {
  836. const objHtml = [];
  837. objHtml.push(`<div class="card border-primary my-2 tag-item" id="bills-tag-${tag.id}" tag-id="${tag.id}">`);
  838. objHtml.push(getTagDisplayHtml(tag));
  839. objHtml.push('</div>');
  840. if (isTop) {
  841. $('#bills-tag-list').prepend(objHtml.join(''));
  842. } else {
  843. $('#bills-tag-list').append(objHtml.join(''));
  844. }
  845. }
  846. tag.display = true;
  847. };
  848. const loadViewTags = function () {
  849. let showCount = 0;
  850. for (const t of curShow) {
  851. if (showCount >= pageLength) continue;
  852. if (t.display) continue;
  853. reviewTag(t);
  854. showCount++;
  855. }
  856. };
  857. const reloadViewTags = function () {
  858. clearViewTags();
  859. $("#bills-tag-lis").scrollTop(0);
  860. loadViewTags();
  861. };
  862. const _addToBillsIndex = function(data, isTop = false) {
  863. let bi = billsIndexes[data.lid];
  864. if (!bi) {
  865. bi = [];
  866. billsIndexes[data.lid] = bi;
  867. }
  868. isTop ? bi.unshift(data) : bi.push(data);
  869. };
  870. const loadDatas = function (datas) {
  871. billsTags = [];
  872. billsIndexes = {};
  873. for (const d of datas) {
  874. if (!d.node) continue;
  875. billsTags.push(d);
  876. _addToBillsIndex(d);
  877. }
  878. curShow = billsTags;
  879. reloadViewTags();
  880. };
  881. const updateDatas = function (data) {
  882. const refresh = {};
  883. if (data.add) {
  884. billsTags.push(data.add);
  885. _addToBillsIndex(data.add, true);
  886. refresh.add = data.add;
  887. }
  888. if (data.del) {
  889. const delTag = billsTags.find(x => {return x.id === data.del});
  890. billsTags.splice(billsTags.indexOf(delTag), 1);
  891. if (delTag.node) {
  892. const bi = billsIndexes[delTag.node.id];
  893. bi.splice(bi.indexOf(delTag), 1);
  894. }
  895. refresh.del = delTag;
  896. }
  897. if (data.update) {
  898. const updateTag = billsTags.find(x => {return x.id === data.update.id});
  899. for (const prop in data.update) {
  900. updateTag[prop] = data.update[prop];
  901. }
  902. refresh.update = updateTag;
  903. }
  904. return refresh;
  905. };
  906. const updateDatasAndShow = function (data) {
  907. const relaBills = [];
  908. const refresh = updateDatas(data);
  909. if (refresh.add) {
  910. reviewTag(refresh.add, true);
  911. relaBills.push(refresh.add.node);
  912. }
  913. if (refresh.del) {
  914. $('#bills-tag-' + refresh.del.id).remove();
  915. relaBills.push(refresh.del.node);
  916. }
  917. if (refresh.update) {
  918. refreshTagView(refresh.update);
  919. relaBills.push(refresh.update.node);
  920. }
  921. return relaBills;
  922. };
  923. const show = function () {
  924. showSelectTab(setting.selector, null, setting.afterShow);
  925. };
  926. const getBillsTagsColor = function (id) {
  927. const billsTags = billsIndexes[id] || [];
  928. return billsTags.length > 0 ? billsTags.map(x => {return x.color}) : undefined;
  929. };
  930. const getBillsTagsInfo = function (id) {
  931. const billsTags = billsIndexes[id] || [];
  932. return billsTags.length > 0 ? billsTags.map(x => {
  933. const tagClass = classIndexes.find(tc => {return tc.color === x.color}) || {};
  934. return {color: x.color, comment: x.comment, tagClass: tagClass.tagClass};
  935. }) : undefined;
  936. };
  937. const afterDeleteBills = function (nodes) {
  938. for (const node of nodes) {
  939. const bi = billsIndexes[node.id];
  940. if (!bi) continue;
  941. delete billsIndexes[node.id];
  942. for (const biTag of bi) {
  943. const delTag = billsTags.find(x => {return x.id === biTag.id});
  944. billsTags.splice(billsTags.indexOf(delTag), 1);
  945. $('#bills-tag-' + delTag.id).remove();
  946. }
  947. }
  948. };
  949. $('body').on('click', '[name=bills-tag-locate]', function () {
  950. const lid = parseInt(this.getAttribute('lid'));
  951. SpreadJsObj.locateTreeNode(setting.relaSpread.getActiveSheet(), lid, true);
  952. setting.afterLocated && setting.afterLocated();
  953. });
  954. $('body').on('click', '[name=bills-tag-edit]', function () {
  955. const tagId = this.getAttribute('tag-id');
  956. const tag = billsTags.find(x => {return x.id == tagId});
  957. if (tag) {
  958. const obj = $('#bills-tag-' + tag.id);
  959. $('[name=tag-view]', obj).hide();
  960. obj.append(getTagEditHtml(tag));
  961. }
  962. });
  963. $('body').on('click', '#tag-edit-cancel', function () {
  964. const obj = $('[name=tag-edit]').parent();
  965. $('[name=tag-edit]').remove();
  966. $('[name=tag-view]', obj).show();
  967. });
  968. $('body').on('click', '#tag-del', function () {
  969. const obj = $('[name=tag-edit]').parent();
  970. postData(setting.updateUrl, {del: parseInt(obj.attr('tag-id'))}, function (result) {
  971. if (!result.del) return;
  972. const bills = updateDatasAndShow(result);
  973. setting.afterModify && setting.afterModify(bills);
  974. });
  975. });
  976. $('body').on('click', '#tag-edit-ok', function () {
  977. const obj = $('[name=tag-edit]').parent();
  978. const data = {
  979. id: parseInt(obj.attr('tag-id')),
  980. share: $('#tag-share')[0].checked,
  981. comment: $('#tag-comment').val(),
  982. color: $('#tag-change-color').attr('tag-color'),
  983. };
  984. postData(setting.updateUrl, {update: data}, function (result) {
  985. if (!result.update) return;
  986. const bills = updateDatasAndShow(result);
  987. setting.afterModify && setting.afterModify(bills);
  988. });
  989. });
  990. $('body').on('click', '[name=tag-color]', function () {
  991. const tagClass = this.classList[1];
  992. const ci = classIndexes.find(tc => {return tc.tagClass === tagClass});
  993. const tcc = $('#tag-change-color');
  994. tcc.attr('tag-color', ci.color);
  995. tcc.find('i').attr('class', 'fa fa-tag ' + tagClass);
  996. });
  997. $('body').on('click', '[tagType]', function () {
  998. const tagClass = this.getAttribute('tagType');
  999. if (tagClass === 'all') {
  1000. $('#bills-tag-filter').attr('class', 'fa fa-list-ol');
  1001. } else {
  1002. $('#bills-tag-filter').attr('class', 'fa fa-tag ' + tagClass);
  1003. }
  1004. searchTagsAndShow();
  1005. });
  1006. // 防抖
  1007. function debounce(fun, delay) {
  1008. let timer = null;
  1009. return function () {
  1010. if (timer) {
  1011. clearTimeout(timer);
  1012. }
  1013. timer = setTimeout(fun, delay);
  1014. }
  1015. }
  1016. $('#bills-tag-list').bind('scroll', debounce(function (e) {
  1017. const obj = $('#bills-tag-list');
  1018. var sum = obj[0].scrollHeight;
  1019. if (sum <= obj.scrollTop() + obj.height()) {
  1020. loadViewTags();
  1021. }
  1022. }, 300));
  1023. $('#bills-tag-clear').bind('click', () => {
  1024. if (!$('#bills-tag-keyword').val()) return;
  1025. $('#bills-tag-keyword').val('');
  1026. searchTagsAndShow();
  1027. });
  1028. $('#bills-tag-search').bind('click', () => {searchTagsAndShow();});
  1029. $('#bills-tag-keyword').bind('keydown', e => {if (e.keyCode === 13) searchTagsAndShow();});
  1030. return { loadDatas, updateDatasAndShow, show, getBillsTagsColor, getBillsTagsInfo, refreshBillsTagView, afterDeleteBills }
  1031. };
  1032. $.sumLoadMiss = function (setting) {
  1033. if (!setting.spreadSetting) {
  1034. setting.spreadSetting = {
  1035. cols: [
  1036. { title: '清单编号', field: 'b_code', width: 80, formatter: '@' },
  1037. { title: '清单名称', field: 'name', width: 120, formatter: '@' },
  1038. { title: '单位', field: 'unit', width: 50, formatter: '@' },
  1039. { title: setting.type === 'stage' ? '合同数量' : '数量', field: 'qty', width: 60 },
  1040. { title: '变更数量', field: 'qc_qty', width: 60, visible: setting.type === 'stage' },
  1041. {
  1042. title: '类型', field: 'type', width: 100, getValue: function (x) {
  1043. switch (x.type) {
  1044. case 'less': return '数量变少';
  1045. case 'miss': return '找不到清单';
  1046. case 'qc-conflict': return '变更冲突(已调用变更令)';
  1047. default: return '';
  1048. }
  1049. }
  1050. }
  1051. ],
  1052. emptyRows: 0,
  1053. headRows: 1,
  1054. headRowHeight: [32],
  1055. defaultRowHeight: 21,
  1056. headerFont: '12px 微软雅黑',
  1057. font: '12px 微软雅黑',
  1058. selectedBackColor: '#fffacd',
  1059. readOnly: true,
  1060. };
  1061. }
  1062. const clearMissData = function () {
  1063. if (setting.storeKey) removeLocalCache(setting.storeKey);
  1064. };
  1065. const autoShowHistory = function (show) {
  1066. if (setting.storeKey) {
  1067. setLocalCache(setting.storeKey + '-showHis', show.toString());
  1068. }
  1069. };
  1070. if (setting.selector && setting.relaSpread) {
  1071. const resultId = setting.id + '-spread';
  1072. const obj = $(setting.selector);
  1073. obj.html(
  1074. ' <div id="' + resultId + '" class="sjs-sh">\n' +
  1075. ' </div>'
  1076. );
  1077. autoFlashHeight();
  1078. const spread = SpreadJsObj.createNewSpread($('#' + resultId)[0]);
  1079. const sheet = spread.getActiveSheet();
  1080. SpreadJsObj.initSheet(sheet, setting.spreadSetting);
  1081. spread.getActiveSheet().bind(spreadNS.Events.CellDoubleClick, function (e, info) {
  1082. if (!setting.relaSpread) return;
  1083. const sheet = info.sheet;
  1084. const data = sheet.zh_data;
  1085. if (!data) { return }
  1086. const curBills = data[info.row];
  1087. if (!curBills) { return }
  1088. if (curBills.ledger_id) {
  1089. SpreadJsObj.locateTreeNode(setting.relaSpread.getActiveSheet(), curBills.ledger_id, true);
  1090. if (setting.afterLocated) {
  1091. setting.afterLocated();
  1092. }
  1093. } else {
  1094. toastr.warning('找不到该清单');
  1095. }
  1096. });
  1097. const loadMissData = function (data, his = false) {
  1098. const sourceTree = setting.relaSpread.getActiveSheet().zh_tree;
  1099. if (!sourceTree) return;
  1100. for (const d of data) {
  1101. d.serialNo = sourceTree.getNodeIndex(sourceTree.getItems(d.ledger_id)) + 1;
  1102. }
  1103. data.sort(function (a, b) {
  1104. return a.serialNo - b.serialNo;
  1105. });
  1106. SpreadJsObj.loadSheetData(sheet, SpreadJsObj.DataType.Data, data);
  1107. if (!his && setting.storeKey) {
  1108. setLocalCache(setting.storeKey, JSON.stringify(data));
  1109. }
  1110. $(setting.tabSelector).show();
  1111. };
  1112. const showMissList = function () {
  1113. const tab = $(setting.tabSelector), tabPanel = $(tab.attr('content'));
  1114. $('a', '.side-menu').removeClass('active');
  1115. tab.addClass('active');
  1116. $('.tab-content .tab-pane').removeClass('active');
  1117. tabPanel.addClass('active');
  1118. showSideTools(true);
  1119. spread.refresh();
  1120. if (setting.afterShow) setting.afterShow();
  1121. };
  1122. const loadHisMissData = function () {
  1123. if (setting.storeKey) {
  1124. const storeStr = getLocalCache(setting.storeKey);
  1125. const storeData = storeStr ? JSON.parse(storeStr) : [];
  1126. if (storeData.length > 0) {
  1127. loadMissData(storeData, true);
  1128. const showHis = getLocalCache(setting.storeKey + '-showHis');
  1129. if (showHis === 'true') {
  1130. showMissList();
  1131. removeLocalCache(setting.storeKey + '-showHis');
  1132. }
  1133. }
  1134. }
  1135. };
  1136. return {
  1137. spread: spread,
  1138. loadMissData: loadMissData,
  1139. clearMissData: clearMissData,
  1140. loadHisMissData: loadHisMissData,
  1141. show: showMissList,
  1142. autoShowHistory: autoShowHistory,
  1143. };
  1144. } else {
  1145. const loadMissData = function (data) {
  1146. if (setting.storeKey) {
  1147. setLocalCache(setting.storeKey, JSON.stringify(data));
  1148. }
  1149. };
  1150. return {
  1151. loadErrorData: loadMissData,
  1152. clearErrorData: clearMissData,
  1153. autoShowHistory: autoShowHistory,
  1154. };
  1155. }
  1156. };
  1157. $.stdLib = function (setting) {
  1158. if (!setting.selector) return;
  1159. const obj = $(setting.selector);
  1160. const stdLibHtml = setting.libs.map(l => {
  1161. return `<option value="${l.id}" >${l.name}</option>`;
  1162. });
  1163. const relaSelect = {
  1164. showLevel: `std-${setting.stdType}-sl`,
  1165. searchText: `std-${setting.stdType}-st`,
  1166. searchResult: `std-${setting.stdType}-sr`,
  1167. searchPre: `std-${setting.stdType}-sp`,
  1168. searchNext: `std-${setting.stdType}-sn`,
  1169. searchClose: `std-${setting.stdType}-sc`,
  1170. };
  1171. obj.html(
  1172. '<div class="sjs-bar d-flex">\n' +
  1173. ' <div class="dropdown mr-1">\n' +
  1174. ' <button class="btn btn-sm btn-light dropdown-toggle text-primary" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">\n' +
  1175. ' <i class="fa fa-list-ol"></i> 显示层级\n' +
  1176. ' </button>\n' +
  1177. ' <div class="dropdown-menu" aria-labelledby="dropdownMenuButton">\n' +
  1178. ` <a class="dropdown-item" href="javascript: void(0);" tag="1" name="${relaSelect.showLevel}">第一层</a>\n` +
  1179. ` <a class="dropdown-item" href="javascript: void(0);" tag="2" name="${relaSelect.showLevel}">第二层</a>\n` +
  1180. ` <a class="dropdown-item" href="javascript: void(0);" tag="3" name="${relaSelect.showLevel}">第三层</a>\n` +
  1181. ` <a class="dropdown-item" href="javascript: void(0);" tag="4" name="${relaSelect.showLevel}">第四层</a>\n` +
  1182. ` <a class="dropdown-item" href="javascript: void(0);" tag="5" name="${relaSelect.showLevel}">第五层</a>\n` +
  1183. ` <a class="dropdown-item" href="javascript: void(0);" tag="last" name="${relaSelect.showLevel}">最底层</a>\n` +
  1184. ' </div>\n' +
  1185. ' </div>' +
  1186. ` <div class="input-group input-group-sm pr-1"><select class="form-control form-control-sm col-auto">${stdLibHtml.join('')}</select></div>\n` +
  1187. ' <div class="ml-1">\n' +
  1188. ' <div class="dropdown">\n' +
  1189. ' <button class="btn btn-sm btn-outline-secondary dropdown-toggle" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">\n' +
  1190. ' <i class="fa fa-search"></i>\n' +
  1191. ' </button>\n' +
  1192. ' <div class="dropdown-menu dropdown-menu-right">\n' +
  1193. ' <div class="px-2 border-primary border-1 d-flex" style="width: 300px">\n' +
  1194. ' <div class="d-inline-block">\n' +
  1195. ' <div class="input-group input-group-sm mr-1">' +
  1196. ` <input type="text" class="form-control" placeholder="输入编号/名称查找" id="${relaSelect.searchText}">\n` +
  1197. ` <div class="input-group-append" ><span class="input-group-text" id="${relaSelect.searchResult}">结果:0</span></div>\n` +
  1198. ' <div class="input-group-append" >\n' +
  1199. ` <button class="btn btn-outline-secondary" type="button" title="上一个" id="${relaSelect.searchPre}"><i class="fa fa-angle-double-left"></i></button>\n` +
  1200. ` <button class="btn btn-outline-secondary" type="button" title="下一个" id="${relaSelect.searchNext}"><i class="fa fa-angle-double-right"></i></button>\n` +
  1201. ' </div>\n' +
  1202. ' </div>\n' +
  1203. ' </div>\n' +
  1204. ` <div class="d-inline-block"><button class="btn btn-light text-danger btn-sm ml-1" type="button" id="${relaSelect.searchClose}"><i class="fa fa-remove"></i></button></div>\n` +
  1205. ' </div>\n' +
  1206. ' </div>\n' +
  1207. ' </div>\n' +
  1208. ' </div>' +
  1209. '</div>\n' +
  1210. `<div id="std-${setting.stdType}-spread" class="sjs-sh"></div>\n`
  1211. );
  1212. autoFlashHeight();
  1213. const pathTree = createNewPathTree('base', setting.treeSetting);
  1214. const spreadSetting = {
  1215. cols: [
  1216. {title: '名称', field: 'name', hAlign: 0, width: 180, formatter: '@'},
  1217. {title: '单位', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
  1218. ],
  1219. treeCol: 0,
  1220. emptyRows: 0,
  1221. headRows: 1,
  1222. headRowHeight: [32],
  1223. defaultRowHeight: 21,
  1224. headerFont: '12px 微软雅黑',
  1225. font: '12px 微软雅黑',
  1226. headColWidth: [30],
  1227. selectedBackColor: '#fffacd',
  1228. readOnly: true,
  1229. stdType: setting.stdType,
  1230. };
  1231. spreadSetting.cols.unshift(setting.stdType === 'xmj'
  1232. ? {title: '项目节编号', field: 'code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree'}
  1233. : {title: '清单编号', field: 'b_code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree'});
  1234. const spread = SpreadJsObj.createNewSpread($(`#std-${setting.stdType}-spread`)[0]);
  1235. const sheet = spread.getActiveSheet();
  1236. SpreadJsObj.initSheet(sheet, setting.spreadSetting || spreadSetting);
  1237. if (setting.cellDoubleClick) sheet.bind(spreadNS.Events.CellDoubleClick, setting.cellDoubleClick);
  1238. sheet.bind(spreadNS.Events.SelectionChanged, function (e, info) {
  1239. if (!info.oldSelections || !info.oldSelections[0] || info.newSelections[0].row !== info.oldSelections[0].row) {
  1240. SpreadJsObj.saveTopAndSelect(info.sheet, cacheKey.node);
  1241. }
  1242. });
  1243. sheet.bind(spreadNS.Events.TopRowChanged, function (e, info) {
  1244. SpreadJsObj.saveTopAndSelect(info.sheet, cacheKey.node);
  1245. });
  1246. const cacheLib = [];
  1247. const cacheKey = {
  1248. lib: setting.page + '-' + setting.tid + '-' + setting.stdType,
  1249. };
  1250. $('select', setting.selector).change(function () {
  1251. loadLib(parseInt(this.value), true);
  1252. });
  1253. (function (select, sheet) {
  1254. $(select).click(function () {
  1255. if (!sheet.zh_tree) return;
  1256. const tag = $(this).attr('tag');
  1257. const tree = sheet.zh_tree;
  1258. setTimeout(() => {
  1259. switch (tag) {
  1260. case "1":
  1261. case "2":
  1262. case "3":
  1263. case "4":
  1264. case "5":
  1265. tree.expandByLevel(parseInt(tag));
  1266. SpreadJsObj.refreshTreeRowVisible(sheet);
  1267. break;
  1268. case "last":
  1269. tree.expandByCustom(() => { return true; });
  1270. SpreadJsObj.refreshTreeRowVisible(sheet);
  1271. break;
  1272. }
  1273. }, 100);
  1274. });
  1275. })(`a[name=${relaSelect.showLevel}]`, sheet);
  1276. const loadLib = function(listId, reload = false) {
  1277. cacheKey.node = cacheLib.lib + '-' + listId;
  1278. const locateMemory = function () {
  1279. if (!reload) {
  1280. SpreadJsObj.loadTopAndSelect(sheet, cacheKey.node);
  1281. } else {
  1282. removeLocalCache(cacheKey.node);
  1283. }
  1284. };
  1285. const cacheData = cacheLib.find(function (lib) {
  1286. return lib.id === listId;
  1287. });
  1288. if (cacheData) {
  1289. pathTree.loadDatas(cacheData.data);
  1290. SpreadJsObj.loadSheetData(sheet, 'tree', pathTree);
  1291. locateMemory();
  1292. setLocalCache(cacheKey.lib, listId);
  1293. } else {
  1294. postData(`/std-lib/get-data`, {stdType: setting.stdType, list_id: listId}, function (data) {
  1295. cacheLib.push({id: listId, data: data});
  1296. pathTree.loadDatas(data);
  1297. SpreadJsObj.loadSheetData(sheet, 'tree', pathTree);
  1298. locateMemory();
  1299. setLocalCache(cacheKey.lib, listId);
  1300. });
  1301. }
  1302. };
  1303. const _loadCacheLib = function() {
  1304. let libId = getLocalCache(cacheKey.lib);
  1305. if (libId) {
  1306. $('select', setting.selector).val(libId);
  1307. loadLib(parseInt(libId));
  1308. } else {
  1309. loadLib(parseInt($('select', setting.selector).val()));
  1310. }
  1311. };
  1312. _loadCacheLib();
  1313. const searchObj = {
  1314. result: [],
  1315. cur: 0,
  1316. searchStdNode: function() {
  1317. const keyword = $(`#${relaSelect.searchText}`).val();
  1318. searchObj.result = keyword ? pathTree.nodes.filter(x => {
  1319. return x.code.indexOf(keyword) >= 0 || x.b_code.indexOf(keyword) >= 0 || x.name.indexOf(keyword) >= 0;
  1320. }) : [];
  1321. // searchObj.result = [];
  1322. // for (const x of pathTree.nodes) {
  1323. // if (x.code.indexOf(keyword) >= 0 || x.b_code.indexOf(keyword) >= 0 || x.name.indexOf(keyword) >= 0) {
  1324. // searchObj.result.push(x);
  1325. // }
  1326. // }
  1327. $(`#${relaSelect.searchResult}`)[0].innerText = `结果:${searchObj.result.length}`;
  1328. searchObj.cur = 0;
  1329. if (searchObj.result.length > 0) {
  1330. SpreadJsObj.locateTreeNode(sheet, pathTree.getNodeKey(searchObj.result[searchObj.cur]));
  1331. }
  1332. },
  1333. searchPre: function () {
  1334. if (searchObj.result.length === 0) return;
  1335. searchObj.cur = searchObj.cur === 0 ? searchObj.result.length - 1 : this.cur - 1;
  1336. SpreadJsObj.locateTreeNode(sheet, pathTree.getNodeKey(searchObj.result[searchObj.cur]), true);
  1337. },
  1338. searchNext: function () {
  1339. if (searchObj.result.length === 0) return;
  1340. searchObj.cur = searchObj.cur === searchObj.result.length - 1 ? 0 : searchObj.cur + 1;
  1341. SpreadJsObj.locateTreeNode(sheet, pathTree.getNodeKey(searchObj.result[searchObj.cur]), true);
  1342. },
  1343. clear: function () {
  1344. $(`#${relaSelect.searchText}`).val('');
  1345. $(`#${relaSelect.searchResult}`)[0].innerText = `结果:${0}`;
  1346. searchObj.result = [];
  1347. searchObj.cur = 0;
  1348. }
  1349. };
  1350. $(`#${relaSelect.searchText}`).change(searchObj.searchStdNode);
  1351. $(`#${relaSelect.searchPre}`).click(function (e) {
  1352. searchObj.searchPre();
  1353. e.stopPropagation();
  1354. });
  1355. $(`#${relaSelect.searchNext}`).click(function (e) {
  1356. searchObj.searchNext();
  1357. e.stopPropagation();
  1358. });
  1359. $(`#${relaSelect.searchClose}`).click(function (e) {
  1360. searchObj.clear();
  1361. e.stopPropagation();
  1362. });
  1363. return { spread }
  1364. };
  1365. $.gljLib = function (setting) {
  1366. if (!setting.selector) return;
  1367. const obj = $(setting.selector);
  1368. const stdLibHtml = setting.libs.map(l => {
  1369. return `<option value="${l.id}" >${l.name}</option>`;
  1370. });
  1371. const relaSelect = {
  1372. showLevel: `std-${setting.stdType}-sl`,
  1373. searchText: `std-${setting.stdType}-st`,
  1374. searchResult: `std-${setting.stdType}-sr`,
  1375. searchPre: `std-${setting.stdType}-sp`,
  1376. searchNext: `std-${setting.stdType}-sn`,
  1377. searchClose: `std-${setting.stdType}-sc`,
  1378. };
  1379. obj.html(
  1380. '<div class="sjs-bar d-flex">\n' +
  1381. ` <div class="input-group input-group-sm pr-1"><select class="form-control form-control-sm col-auto">${stdLibHtml.join('')}</select></div>\n` +
  1382. ' <div class="ml-1">\n' +
  1383. ' <div class="dropdown">\n' +
  1384. ' <button class="btn btn-sm btn-outline-secondary dropdown-toggle" type="button" id="dropdownMenuButton" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">\n' +
  1385. ' <i class="fa fa-search"></i>\n' +
  1386. ' </button>\n' +
  1387. ' <div class="dropdown-menu dropdown-menu-right">\n' +
  1388. ' <div class="px-2 border-primary border-1 d-flex" style="width: 300px">\n' +
  1389. ' <div class="d-inline-block">\n' +
  1390. ' <div class="input-group input-group-sm mr-1">' +
  1391. ` <input type="text" class="form-control" placeholder="输入编号/名称查找" id="${relaSelect.searchText}">\n` +
  1392. ` <div class="input-group-append" ><span class="input-group-text" id="${relaSelect.searchResult}">结果:0</span></div>\n` +
  1393. ' <div class="input-group-append" >\n' +
  1394. ` <button class="btn btn-outline-secondary" type="button" title="上一个" id="${relaSelect.searchPre}"><i class="fa fa-angle-double-left"></i></button>\n` +
  1395. ` <button class="btn btn-outline-secondary" type="button" title="下一个" id="${relaSelect.searchNext}"><i class="fa fa-angle-double-right"></i></button>\n` +
  1396. ' </div>\n' +
  1397. ' </div>\n' +
  1398. ' </div>\n' +
  1399. ` <div class="d-inline-block"><button class="btn btn-light text-danger btn-sm ml-1" type="button" id="${relaSelect.searchClose}"><i class="fa fa-remove"></i></button></div>\n` +
  1400. ' </div>\n' +
  1401. ' </div>\n' +
  1402. ' </div>\n' +
  1403. ' </div>' +
  1404. '</div>\n' +
  1405. `<div id="std-${setting.stdType}-spread" class="${setting.spreadClassCss ? setting.spreadClassCss : 'sjs-sh'}"></div>\n`
  1406. );
  1407. autoFlashHeight();
  1408. const pathTree = createNewPathTree('base', setting.treeSetting);
  1409. const spreadSetting = {
  1410. cols: [
  1411. {title: '名称', field: 'name', hAlign: 0, width: 180, formatter: '@'},
  1412. {title: '单位', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
  1413. ],
  1414. treeCol: 0,
  1415. emptyRows: 0,
  1416. headRows: 1,
  1417. headRowHeight: [32],
  1418. defaultRowHeight: 21,
  1419. headerFont: '12px 微软雅黑',
  1420. font: '12px 微软雅黑',
  1421. headColWidth: [30],
  1422. selectedBackColor: '#fffacd',
  1423. readOnly: true,
  1424. stdType: setting.stdType,
  1425. };
  1426. spreadSetting.cols.unshift(setting.stdType === 'xmj'
  1427. ? {title: '项目节编号', field: 'code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree'}
  1428. : {title: '清单编号', field: 'b_code', hAlign: 0, width: 150, formatter: '@', cellType: 'tree'});
  1429. const spread = SpreadJsObj.createNewSpread($(`#std-${setting.stdType}-spread`)[0]);
  1430. const sheet = spread.getActiveSheet();
  1431. SpreadJsObj.initSheet(sheet, setting.spreadSetting ? setting.spreadSetting : spreadSetting);
  1432. if (setting.cellDoubleClick) sheet.bind(spreadNS.Events.CellDoubleClick, setting.cellDoubleClick);
  1433. sheet.bind(spreadNS.Events.SelectionChanged, function (e, info) {
  1434. if (!info.oldSelections || !info.oldSelections[0] || info.newSelections[0].row !== info.oldSelections[0].row) {
  1435. SpreadJsObj.saveTopAndSelect(info.sheet, cacheKey.node);
  1436. }
  1437. });
  1438. sheet.bind(spreadNS.Events.TopRowChanged, function (e, info) {
  1439. SpreadJsObj.saveTopAndSelect(info.sheet, cacheKey.node);
  1440. });
  1441. const cacheLib = [];
  1442. const cacheKey = {
  1443. lib: setting.page + '-' + setting.tid + '-' + setting.stdType,
  1444. };
  1445. $('select', setting.selector).change(function () {
  1446. loadLib(parseInt(this.value), true);
  1447. });
  1448. const loadLib = function(listId, reload = false) {
  1449. cacheKey.node = cacheLib.lib + '-' + listId;
  1450. const locateMemory = function () {
  1451. if (!reload) {
  1452. SpreadJsObj.loadTopAndSelect(sheet, cacheKey.node);
  1453. } else {
  1454. removeLocalCache(cacheKey.node);
  1455. }
  1456. };
  1457. const cacheData = cacheLib.find(function (lib) {
  1458. return lib.id === listId;
  1459. });
  1460. if (cacheData) {
  1461. pathTree.loadDatas(cacheData.data);
  1462. SpreadJsObj.loadSheetData(sheet, 'tree', pathTree);
  1463. locateMemory();
  1464. setLocalCache(cacheKey.lib, listId);
  1465. } else {
  1466. postData(`/std-lib/get-data`, {stdType: setting.stdType, list_id: listId}, function (data) {
  1467. cacheLib.push({id: listId, data: data});
  1468. pathTree.loadDatas(data);
  1469. SpreadJsObj.loadSheetData(sheet, 'tree', pathTree);
  1470. locateMemory();
  1471. setLocalCache(cacheKey.lib, listId);
  1472. });
  1473. }
  1474. };
  1475. const _loadCacheLib = function() {
  1476. let libId = getLocalCache(cacheKey.lib);
  1477. if (libId) {
  1478. $('select', setting.selector).val(libId);
  1479. loadLib(parseInt(libId));
  1480. } else {
  1481. loadLib(parseInt($('select', setting.selector).val()));
  1482. }
  1483. };
  1484. _loadCacheLib();
  1485. const searchObj = {
  1486. result: [],
  1487. cur: 0,
  1488. searchStdNode: function() {
  1489. const keyword = $(`#${relaSelect.searchText}`).val();
  1490. searchObj.result = keyword ? pathTree.nodes.filter(x => {
  1491. return x.code.indexOf(keyword) >= 0 || x.name.indexOf(keyword) >= 0;
  1492. }) : [];
  1493. // searchObj.result = [];
  1494. // for (const x of pathTree.nodes) {
  1495. // if (x.code.indexOf(keyword) >= 0 || x.b_code.indexOf(keyword) >= 0 || x.name.indexOf(keyword) >= 0) {
  1496. // searchObj.result.push(x);
  1497. // }
  1498. // }
  1499. $(`#${relaSelect.searchResult}`)[0].innerText = `结果:${searchObj.result.length}`;
  1500. searchObj.cur = 0;
  1501. if (searchObj.result.length > 0) {
  1502. SpreadJsObj.locateTreeNode(sheet, pathTree.getNodeKey(searchObj.result[searchObj.cur]));
  1503. }
  1504. },
  1505. searchPre: function () {
  1506. if (searchObj.result.length === 0) return;
  1507. searchObj.cur = searchObj.cur === 0 ? searchObj.result.length - 1 : this.cur - 1;
  1508. SpreadJsObj.locateTreeNode(sheet, pathTree.getNodeKey(searchObj.result[searchObj.cur]), true);
  1509. },
  1510. searchNext: function () {
  1511. if (searchObj.result.length === 0) return;
  1512. searchObj.cur = searchObj.cur === searchObj.result.length - 1 ? 0 : searchObj.cur + 1;
  1513. SpreadJsObj.locateTreeNode(sheet, pathTree.getNodeKey(searchObj.result[searchObj.cur]), true);
  1514. },
  1515. clear: function () {
  1516. $(`#${relaSelect.searchText}`).val('');
  1517. $(`#${relaSelect.searchResult}`)[0].innerText = `结果:${0}`;
  1518. searchObj.result = [];
  1519. searchObj.cur = 0;
  1520. }
  1521. };
  1522. $(`#${relaSelect.searchText}`).change(searchObj.searchStdNode);
  1523. $(`#${relaSelect.searchPre}`).click(function (e) {
  1524. searchObj.searchPre();
  1525. e.stopPropagation();
  1526. });
  1527. $(`#${relaSelect.searchNext}`).click(function (e) {
  1528. searchObj.searchNext();
  1529. e.stopPropagation();
  1530. });
  1531. $(`#${relaSelect.searchClose}`).click(function (e) {
  1532. searchObj.clear();
  1533. e.stopPropagation();
  1534. });
  1535. return { spread }
  1536. };
  1537. })(jQuery);