ledger.js 107 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304
  1. /**
  2. * 台账相关js
  3. *
  4. * @author Mai
  5. * @date 2018/02/05
  6. * @version
  7. */
  8. const ckBillsSpread = window.location.pathname + '-billsSelect';
  9. function checkTzMeasureType () {
  10. return tender.measure_type === measureType.tz.value;
  11. }
  12. function getTenderId() {
  13. return window.location.pathname.split('/')[2];
  14. }
  15. const copyBlockTag = 'zh.calc.copyBlock';
  16. const invalidFields = {
  17. parent: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp', 'deal_qty', 'deal_tp', 'unit_price'],
  18. gcl: ['dgn_qty1', 'dgn_qty2'],
  19. posCode: ['b_code'],
  20. posCalc: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp'],
  21. };
  22. function transExpr(expr) {
  23. return expr.replace('=', '').replace('%', '/100');
  24. }
  25. $(document).ready(function() {
  26. let stdXmj, stdGcl, dealBills, searchLedger;
  27. autoFlashHeight();
  28. // 初始化台账
  29. const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]);
  30. SpreadJsObj.addDeleteBind(ledgerSpread);
  31. const treeSetting = {
  32. id: 'ledger_id',
  33. pid: 'ledger_pid',
  34. order: 'order',
  35. level: 'level',
  36. rootId: -1,
  37. keys: ['id', 'tender_id', 'ledger_id'],
  38. preUrl: '/tender/' + getTenderId() + '/ledger',
  39. };
  40. if (checkTzMeasureType()) {
  41. treeSetting.calcFields = ['sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'];
  42. } else {
  43. treeSetting.calcFields = ['deal_tp', 'sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'];
  44. }
  45. treeSetting.calcFun = function (node) {
  46. node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), 2);
  47. };
  48. const ledgerTree = createNewPathTree('ledger', treeSetting);
  49. // 初始化 计量单元
  50. const pos = new PosData({
  51. id: 'id', ledgerId: 'lid',
  52. });
  53. const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]);
  54. $.subMenu({
  55. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  56. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  57. key: 'menu.1.0.0',
  58. miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
  59. callback: function (info) {
  60. if (info.mini) {
  61. $('.panel-title').addClass('fluid');
  62. $('#sub-menu').removeClass('panel-sidebar');
  63. } else {
  64. $('.panel-title').removeClass('fluid');
  65. $('#sub-menu').addClass('panel-sidebar');
  66. }
  67. autoFlashHeight();
  68. ledgerSpread.refresh();
  69. if (posSpread) {
  70. posSpread.refresh();
  71. }
  72. if (stdXmj) {
  73. stdXmj.spread.refresh();
  74. }
  75. if (stdGcl) {
  76. stdGcl.spread.refresh();
  77. }
  78. if (dealBills) {
  79. dealBills.spread.refresh();
  80. }
  81. if (searchLedger) {
  82. searchLedger.spread.refresh();
  83. }
  84. }
  85. });
  86. // 定义事件
  87. const treeOperationObj = {
  88. loadExprToInput(sheet) {
  89. const sel = sheet.getSelections()[0];
  90. const col = sheet.zh_setting.cols[sel.col], cell = sheet.getCell(sel.row, sel.col);
  91. if (col && col.type === 'Number') {
  92. const data = SpreadJsObj.getSelectObject(sheet);
  93. if (data) {
  94. $('#bills-expr').val(data[col.field]).attr('field', col.field).attr('org', data[col.field]);
  95. if (col.field.indexOf('dgn') >= 0) {
  96. $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (_.isString(data.b_code) && data.b_code !== ''));
  97. } else {
  98. $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (data.children && data.children.length > 0));
  99. }
  100. } else {
  101. $('#bills-expr').val('').attr('readOnly', true);
  102. }
  103. } else {
  104. $('#bills-expr').val('').attr('readOnly', true);
  105. }
  106. },
  107. getSelectNode: function (sheet) {
  108. if (!sheet || !sheet.zh_tree) {
  109. return null;
  110. } else {
  111. const sel = sheet.getSelections()[0];
  112. return sheet.zh_tree.nodes[sel.row];
  113. }
  114. },
  115. getDefaultSelectInfo: function (sheet) {
  116. const tree = sheet.zh_tree;
  117. if (!tree) return;
  118. const sel = sheet.getSelections()[0];
  119. const node = sheet.zh_tree.nodes[sel.row];
  120. if (!node) return;
  121. let count = 1;
  122. if (sel.rowCount > 1) {
  123. for (let r = 1; r < sel.rowCount; r++) {
  124. const rNode = sheet.zh_tree.nodes[sel.row + r];
  125. if (rNode.level > node.level) continue;
  126. if ((rNode.level < node.level) || (rNode.level === node.level && rNode.pid !== node.pid)) {
  127. toastr.error('请选择同一清单下的节点,进行该操作');
  128. return;
  129. }
  130. count += 1;
  131. }
  132. }
  133. return [tree, node, count];
  134. },
  135. /**
  136. * 刷新顶部按钮是否可用
  137. * @param sheet
  138. * @param selections
  139. */
  140. refreshOperationValid: function (sheet, selection) {
  141. const setObjEnable = function (obj, enable) {
  142. if (enable) {
  143. obj.removeClass('disabled');
  144. } else {
  145. obj.addClass('disabled');
  146. }
  147. };
  148. const invalidAll = function () {
  149. setObjEnable($('#insert'), false);
  150. setObjEnable($('#delete'), false);
  151. setObjEnable($('#up-move'), false);
  152. setObjEnable($('#down-move'), false);
  153. setObjEnable($('#up-level'), false);
  154. setObjEnable($('#down-level'), false);
  155. };
  156. const sel = selection ? selection[0] : sheet.getSelections()[0];
  157. const row = sel ? sel.row : -1;
  158. const tree = sheet.zh_tree;
  159. if (!tree) {
  160. invalidAll();
  161. return;
  162. }
  163. const first = sheet.zh_tree.nodes[row];
  164. if (!first) {
  165. invalidAll();
  166. return;
  167. }
  168. let last = first, sameParent = true;
  169. if (sel.rowCount > 1 && first) {
  170. for (let r = 1; r < sel.rowCount; r++) {
  171. const rNode = tree.nodes[row + r];
  172. if (!rNode) {
  173. sameParent = false;
  174. break;
  175. }
  176. if (rNode.level > first.level) continue;
  177. if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
  178. sameParent = false;
  179. break;
  180. }
  181. last = rNode;
  182. }
  183. }
  184. const preNode = tree.getPreSiblingNode(first);
  185. const valid = !sheet.zh_setting.readOnly;
  186. setObjEnable($('#insert'), valid && first && first.level > 1);
  187. setObjEnable($('#delete'), valid && first && sameParent && !(first.level === 1 && first.node_type));
  188. setObjEnable($('#up-move'), valid && first && sameParent && first.level > 1 && preNode);
  189. setObjEnable($('#down-move'), valid && first && sameParent && first.level > 1 && !tree.isLastSibling(last));
  190. if (checkTzMeasureType()) {
  191. const posRange = last ? pos.getLedgerPos(last.id) : [];
  192. setObjEnable($('#up-level'), valid && first && sameParent && tree.getParent(first) && first.level > 2 && ((!posRange || posRange.length === 0) || tree.isLastSibling(last)));
  193. const preNodePosRange = preNode ? pos.getLedgerPos(preNode.id) : [];
  194. setObjEnable($('#down-level'), valid && first && sameParent && first.level > 1 && preNode && (!preNodePosRange || preNodePosRange.length === 0));
  195. } else {
  196. setObjEnable($('#up-level'), valid && first && sameParent && first.level > 2 && tree.getParent(first));
  197. setObjEnable($('#down-level'), valid && first && sameParent && first.level > 1 && preNode);
  198. }
  199. setObjEnable($('#cut'), valid);
  200. setObjEnable($('#paste'), valid);
  201. },
  202. refreshTree: function (sheet, data) {
  203. SpreadJsObj.massOperationSheet(sheet, function () {
  204. const tree = sheet.zh_tree;
  205. // 处理删除
  206. if (data.delete) {
  207. data.delete.sort(function (x, y) {
  208. return y.deleteIndex - x.deleteIndex;
  209. });
  210. for (const d of data.delete) {
  211. sheet.deleteRows(d.deleteIndex, 1);
  212. }
  213. }
  214. // 处理新增
  215. if (data.create) {
  216. const newNodes = data.create;
  217. if (newNodes) {
  218. newNodes.sort(function (a, b) {
  219. return a.index - b.index;
  220. });
  221. for (const node of newNodes) {
  222. sheet.addRows(node.index, 1);
  223. SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(node), 1);
  224. }
  225. }
  226. }
  227. // 处理更新
  228. if (data.update) {
  229. const rows = [];
  230. for (const u of data.update) {
  231. rows.push(tree.nodes.indexOf(u));
  232. }
  233. SpreadJsObj.reLoadRowsData(sheet, rows);
  234. }
  235. // 处理展开
  236. if (data.expand) {
  237. const expanded = [];
  238. for (const e of data.expand) {
  239. if (expanded.indexOf(e) === -1) {
  240. const posterity = tree.getPosterity(e);
  241. for (const p of posterity) {
  242. sheet.setRowVisible(tree.nodes.indexOf(p), p.visible);
  243. expanded.push(p);
  244. }
  245. }
  246. }
  247. }
  248. });
  249. },
  250. /**
  251. * 新增节点
  252. * @param spread
  253. */
  254. addNode: function (sheet, count = 1) {
  255. const self = this;
  256. const sel = sheet.getSelections()[0];
  257. const row = sheet.getSelections()[0].row;
  258. const tree = sheet.zh_tree;
  259. if (!tree) { return; }
  260. const node = sheet.zh_tree.nodes[row];
  261. if (!node) { return; }
  262. postData(window.location.pathname + '/update', {
  263. postType: 'add',
  264. postData: {
  265. id: tree.getNodeKey(node),
  266. count: count,
  267. }
  268. }, function (result) {
  269. const refreshNode = tree.loadPostData(result);
  270. self.refreshTree(sheet, refreshNode);
  271. sheet.setSelection(refreshNode.create[0].index, sel.col, sel.rowCount, sel.colCount);
  272. self.refreshOperationValid(sheet);
  273. });
  274. },
  275. /**
  276. * 删除选中节点
  277. * @param spread
  278. */
  279. deleteNode: function (sheet) {
  280. const self = this;
  281. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  282. if (tree && node && count) {
  283. const data = {
  284. postType: 'delete',
  285. postData: {
  286. id: tree.getNodeKey(node),
  287. count: count
  288. }
  289. };
  290. postData(window.location.pathname + '/update', data, function (result) {
  291. const refreshNode = tree.loadPostData(result);
  292. for (const d of refreshNode.delete) pos.removeDatasByMasterId(d.id);
  293. self.refreshTree(sheet, refreshNode);
  294. self.refreshOperationValid(sheet);
  295. posOperationObj.loadCurPosData();
  296. });
  297. }
  298. },
  299. /**
  300. * 上移选中节点
  301. * @param spread
  302. */
  303. upMove: function (sheet) {
  304. const self = this;
  305. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  306. if (tree && node && count) {
  307. const data = {
  308. postType: 'up-move',
  309. postData: {
  310. id: tree.getNodeKey(node),
  311. count: count
  312. }
  313. };
  314. postData(window.location.pathname + '/update', data, function (result) {
  315. const refreshNode = tree.loadPostData(result);
  316. self.refreshTree(sheet, refreshNode);
  317. const sel = sheet.getSelections()[0];
  318. sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  319. self.refreshOperationValid(sheet);
  320. });
  321. }
  322. },
  323. /**
  324. * 下移选中节点
  325. * @param spread
  326. */
  327. downMove: function (sheet) {
  328. const self = this;
  329. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  330. if (tree && node && count) {
  331. const data = {
  332. postType: 'down-move',
  333. postData: {
  334. id: tree.getNodeKey(node),
  335. count: count
  336. }
  337. };
  338. postData(window.location.pathname + '/update', data, function (result) {
  339. const refreshNode = tree.loadPostData(result);
  340. self.refreshTree(sheet, refreshNode);
  341. const sel = sheet.getSelections()[0];
  342. sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  343. self.refreshOperationValid(sheet);
  344. });
  345. }
  346. },
  347. /**
  348. * 升级选中节点
  349. * @param spread
  350. */
  351. upLevel: function (sheet) {
  352. const self = this;
  353. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  354. if (tree && node && count) {
  355. const data = {
  356. postType: 'up-level',
  357. postData: {
  358. id: tree.getNodeKey(node),
  359. count: count
  360. }
  361. };
  362. postData(window.location.pathname + '/update', data, function (result) {
  363. const refreshNode = tree.loadPostData(result);
  364. self.refreshTree(sheet, refreshNode);
  365. self.refreshOperationValid(sheet);
  366. });
  367. }
  368. },
  369. /**
  370. * 降级选中节点
  371. * @param spread
  372. */
  373. downLevel: function (sheet) {
  374. const self = this;
  375. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  376. if (tree && node && count) {
  377. const data = {
  378. postType: 'down-level',
  379. postData: {
  380. id: tree.getNodeKey(node),
  381. count: count
  382. }
  383. };
  384. postData(window.location.pathname + '/update', data, function (result) {
  385. const refreshNode = tree.loadPostData(result);
  386. self.refreshTree(sheet, refreshNode);
  387. self.refreshOperationValid(sheet);
  388. });
  389. }
  390. },
  391. /**
  392. * 编辑单元格响应事件
  393. * @param {Object} e
  394. * @param {Object} info
  395. */
  396. editEnded: function (e, info) {
  397. if (info.sheet.zh_setting) {
  398. const col = info.sheet.zh_setting.cols[info.col];
  399. const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
  400. const node = sortData[info.row];
  401. const data = {
  402. id: node.id,
  403. tender_id: node.tender_id,
  404. ledger_id: node.ledger_id
  405. };
  406. // 未改变值则不提交
  407. const orgValue = node[col.field];
  408. const newValue = trimInvalidChar(info.editingText);
  409. if (orgValue == info.editingText || ((!orgValue || orgValue === '') && (newValue === ''))) {
  410. return;
  411. }
  412. // 台账模式,检查计量单元相关
  413. if (checkTzMeasureType()) {
  414. if (col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
  415. col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
  416. col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
  417. if (!node.children || node.children.length ===0) {
  418. const lPos = pos.getLedgerPos(node.id);
  419. if (lPos && lPos.length > 0) {
  420. toastr.error('清单含有计量单元,请在计量单元输入数量');
  421. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  422. return;
  423. }
  424. }
  425. }
  426. if (col.field === 'b_code' && (info.editingText === '' || !info.editingText)) {
  427. const lPos = pos.getLedgerPos(node.id);
  428. if (lPos && lPos.length > 0) {
  429. toastr.error('清单含有计量单元,请先删除计量单元,再删除清单编号');
  430. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  431. return;
  432. }
  433. }
  434. }
  435. // 获取更新数据
  436. if (col.type === 'Number') {
  437. if (newValue) {
  438. const num = _.toNumber(newValue);
  439. if (_.isFinite(num)) {
  440. data[col.field] = num;
  441. } else {
  442. try {
  443. data[col.field] = math.evaluate(transExpr(newValue));
  444. } catch(err) {
  445. toastr.error('输入的表达式非法');
  446. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  447. return;
  448. }
  449. }
  450. } else {
  451. data[col.field] = null;
  452. }
  453. } else {
  454. data[col.field] = newValue;
  455. }
  456. // 更新至服务器
  457. postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
  458. const refreshNode = ledgerTree.loadPostData(result);
  459. treeOperationObj.refreshTree(info.sheet, refreshNode);
  460. });
  461. }
  462. },
  463. /**
  464. * 粘贴单元格响应事件
  465. * @param e
  466. * @param info
  467. */
  468. clipboardPasted: function (e, info) {
  469. if (info.sheet.zh_setting && info.sheet.zh_dataType === 'tree') {
  470. const tree = info.sheet.zh_tree;
  471. if (!tree) { return; }
  472. const sortData = info.sheet.zh_tree.nodes;
  473. const datas = [], filterNodes = [];
  474. let bHint = false, bPaste;
  475. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
  476. bPaste = false;
  477. const curRow = info.cellRange.row + iRow;
  478. const node = sortData[curRow];
  479. if (node) {
  480. const data = info.sheet.zh_tree.getNodeKeyData(node);
  481. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  482. const curCol = info.cellRange.col + iCol;
  483. const colSetting = info.sheet.zh_setting.cols[curCol];
  484. const value = trimInvalidChar(info.sheet.getText(curRow, curCol));
  485. const lPos = pos.getLedgerPos(node.id);
  486. if (lPos && lPos.length > 0) {
  487. if (value === '' && colSetting.field === 'b_code') {
  488. if (!bHint) {
  489. toastr.warning('清单含有计量单元,请先删除计量单元,再删除清单编号');
  490. bHint = true;
  491. }
  492. continue;
  493. }
  494. if (colSetting.field === 'sgfh_qty' || colSetting.field === 'sgfh_tp' ||
  495. colSetting.field === 'sjcl_qty' || colSetting.field === 'sjcl_tp' ||
  496. colSetting.field === 'qtcl_qty' || colSetting.field === 'qtcl_tp') {
  497. if (!bHint) {
  498. toastr.warning('清单含有计量单元,数量金额根据计量单元汇总计算所得,不可编辑');
  499. bHint = true;
  500. }
  501. continue;
  502. }
  503. }
  504. if (colSetting.type === 'Number') {
  505. const num = _.toNumber(value);
  506. if (num) {
  507. data[colSetting.field] = num;
  508. bPaste = true;
  509. } else {
  510. try {
  511. data[colSetting.field] = math.evaluate(transExpr(value));
  512. bPaste = true;
  513. } catch(err) {
  514. delete data[colSetting.field];
  515. if (!bHint) {
  516. toastr.warning('输入的表达式非法');
  517. bHint = true;
  518. }
  519. }
  520. }
  521. } else {
  522. data[colSetting.field] = value;
  523. bPaste = true;
  524. }
  525. }
  526. if (bPaste) {
  527. datas.push(data);
  528. } else {
  529. filterNodes.push(node);
  530. }
  531. }
  532. }
  533. if (datas.length > 0) {
  534. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  535. const refreshNode = tree.loadPostData(result);
  536. if (refreshNode.update) {
  537. refreshNode.update = refreshNode.update.concat(filterNodes);
  538. }
  539. treeOperationObj.refreshTree(info.sheet, refreshNode);
  540. }, function () {
  541. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  542. });
  543. } else {
  544. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  545. }
  546. }
  547. },
  548. clipboardPasting: function (e, info) {
  549. const tree = info.sheet.zh_tree, setting = info.sheet.zh_setting;
  550. info.cancel = true;
  551. if (!setting || !tree) return;
  552. const pasteData = info.pasteData.html
  553. ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
  554. : (info.pasteData.text === ''
  555. ? SpreadJsObj.Clipboard.getAnalysisPasteText()
  556. : SpreadJsObj.analysisPasteText(info.pasteData.text));
  557. let bParentHint = false, bGclHint = false, bCodeHint = false, bQtyHint = false, bNumHint = false;
  558. const datas = [], filterNodes = [];
  559. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
  560. const curRow = info.cellRange.row + iRow;
  561. const node = tree.nodes[curRow];
  562. if (!node) continue;
  563. let bPaste = false;
  564. const data = info.sheet.zh_tree.getNodeKeyData(node);
  565. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  566. const curCol = info.cellRange.col + iCol;
  567. const colSetting = info.sheet.zh_setting.cols[curCol];
  568. const value = trimInvalidChar(pasteData[iRow][iCol]);
  569. const lPos = pos.getLedgerPos(node.id);
  570. if (node.children && node.children.length > 0 && invalidFields.parent.indexOf(colSetting.field) >= 0) {
  571. if (!bParentHint) bParentHint = true;
  572. continue;
  573. }
  574. if (!_.isEmpty(node.b_code) && invalidFields.gcl.indexOf(colSetting.field) >= 0) {
  575. if (!bGclHint) bGclHint = true;
  576. continue;
  577. }
  578. if (lPos && lPos.length > 0) {
  579. if (value === '' && invalidFields.posCode.indexOf(colSetting.field) >= 0) {
  580. if (!bCodeHint) bCodeHint = true;
  581. continue;
  582. }
  583. if (invalidFields.posCalc.indexOf(colSetting.field) >= 0) {
  584. if (!bQtyHint) bQtyHint = true;
  585. continue;
  586. }
  587. }
  588. if (colSetting.type === 'Number') {
  589. const num = _.toNumber(value);
  590. if (num) {
  591. data[colSetting.field] = num;
  592. bPaste = true;
  593. } else {
  594. try {
  595. data[colSetting.field] = math.evaluate(transExpr(value));
  596. } catch(err) {
  597. bNumHint = true;
  598. }
  599. }
  600. } else {
  601. data[colSetting.field] = value;
  602. bPaste = true;
  603. }
  604. }
  605. if (bPaste) {
  606. datas.push(data);
  607. } else {
  608. filterNodes.push(node);
  609. }
  610. }
  611. const hint = [];
  612. if (bParentHint) hint.push('含有子项的清单,不可粘贴数量、单价、金额');
  613. if (bGclHint) hint.push('工程量清单,不可粘贴项目节数量');
  614. if (bQtyHint) hint.push('含有计量单元的清单,不可粘贴数量');
  615. if (bCodeHint) hint.push('含有计量单元的清单,清单编号不可粘贴空值');
  616. if (bNumHint) hint.push('单价、数量等应输入数字或可计算的表达式');
  617. // if (hint.length > 0) hint.unshift('复制粘贴的数据中,存在非法数据,已过滤:');
  618. // if (hint.length > 0) toastr.warning(hint.join('</br>'));
  619. if (hint.length > 0) toastr.warning('复制粘贴的数据中,存在非法数据,已过滤');
  620. if (datas.length > 0) {
  621. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  622. const refreshNode = tree.loadPostData(result);
  623. if (refreshNode.update) {
  624. refreshNode.update = refreshNode.update.concat(filterNodes);
  625. }
  626. treeOperationObj.refreshTree(info.sheet, refreshNode);
  627. }, function () {
  628. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  629. });
  630. } else {
  631. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  632. }
  633. },
  634. /**
  635. * 删除按钮响应事件
  636. * @param sheet
  637. */
  638. deletePress: function (sheet) {
  639. if (sheet.zh_setting && sheet.zh_dataType === 'tree') {
  640. const tree = sheet.zh_tree;
  641. if (!tree) { return; }
  642. const sortData = sheet.zh_tree.nodes;
  643. const datas = [], nodes = [];
  644. const sel = sheet.getSelections()[0];
  645. let bHint = false;
  646. for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
  647. const node = sortData[iRow];
  648. if (node) {
  649. let bDel = false;
  650. const data = sheet.zh_tree.getNodeKeyData(node);
  651. for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
  652. const col = sheet.zh_setting.cols[iCol];
  653. if (col.field === 'b_code' || col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
  654. col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
  655. col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
  656. const lPos = pos.getLedgerPos(node.id);
  657. if (lPos && lPos.length > 0) {
  658. if (!bHint) {
  659. if (col.field === 'code') {
  660. toastr.warning('清单含有计量单元,请先删除计量单元,再删除清单编号');
  661. } else {
  662. toastr.warning('清单含有计量单元,数量金额根据计量单元汇总计算所得,不可删除');
  663. }
  664. bHint = true;
  665. }
  666. continue;
  667. }
  668. }
  669. const style = sheet.getStyle(iRow, iCol);
  670. if (!style.locked) {
  671. const colSetting = sheet.zh_setting.cols[iCol];
  672. data[colSetting.field] = null;
  673. bDel = true;
  674. }
  675. }
  676. if (bDel) {
  677. datas.push(data);
  678. nodes.push(node);
  679. }
  680. }
  681. }
  682. if (datas.length > 0) {
  683. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  684. const refreshNode = tree.loadPostData(result);
  685. treeOperationObj.refreshTree(sheet, refreshNode);
  686. });
  687. }
  688. }
  689. },
  690. /**
  691. * 粘贴整块
  692. * @param spread
  693. * @param block
  694. */
  695. pasteBlock: function (spread, copyInfo) {
  696. const self = this;
  697. const sheet = spread.getActiveSheet();
  698. const sel = sheet.getSelections()[0];
  699. const row = sel.row;
  700. const tree = sheet.zh_tree;
  701. if (!tree) { return; }
  702. const node = tree.nodes[row];
  703. if (!node) { return; }
  704. postData(window.location.pathname + '/update', {
  705. postType: 'paste-block',
  706. postData: {
  707. id: tree.getNodeKey(node),
  708. tid: copyInfo.tid,
  709. block: copyInfo.block,
  710. }
  711. }, function (data) {
  712. pos.updateDatas(data.pos);
  713. const result = tree.loadPostData(data.ledger);
  714. self.refreshTree(sheet, result);
  715. sheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
  716. self.refreshOperationValid(sheet);
  717. removeLocalCache(copyBlockTag);
  718. }, null, true);
  719. },
  720. selectionChanged: function (e, info) {
  721. if (!info.oldSelections[0] || info.newSelections[0].row !== info.oldSelections[0].row) {
  722. posOperationObj.loadCurPosData();
  723. SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
  724. posSearch.search($('#pos-keyword').val());
  725. }
  726. SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
  727. treeOperationObj.loadExprToInput(info.sheet);
  728. },
  729. topRowChanged(e, info) {
  730. SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
  731. },
  732. cut: function (sheet, sel, callback) {
  733. if (!sheet || !sel) return;
  734. if (sel.colCount >= sheet.zh_setting.cols.length) {
  735. toastr.warning('请勿选中整行剪切');
  736. return;
  737. }
  738. const sortData = SpreadJsObj.getSortData(sheet), datas = [];
  739. for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
  740. const node = sortData[iRow];
  741. if (node) {
  742. const data = sheet.zh_tree.getNodeKeyData(node);
  743. for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
  744. const col = sheet.zh_setting.cols[iCol];
  745. if (col.field === 'b_code' || col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
  746. col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
  747. col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
  748. const lPos = pos.getLedgerPos(node.id);
  749. if (lPos && lPos.length > 0) {
  750. toastr.error('不可剪切');
  751. return;
  752. }
  753. }
  754. const style = sheet.getStyle(iRow, iCol);
  755. if (style.locked) {
  756. toastr.error('不可剪切');
  757. return;
  758. }
  759. const colSetting = sheet.zh_setting.cols[iCol];
  760. data[colSetting.field] = null;
  761. }
  762. datas.push(data);
  763. }
  764. }
  765. if (datas.length > 0) {
  766. callback();
  767. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  768. const refreshNode = sheet.zh_tree.loadPostData(result);
  769. treeOperationObj.refreshTree(sheet, refreshNode);
  770. });
  771. }
  772. },
  773. editStarting(e, info) {
  774. if (!info.sheet.zh_setting || !info.sheet.zh_tree) return;
  775. const col = info.sheet.zh_setting.cols[info.col];
  776. const node = info.sheet.zh_tree.nodes[info.row];
  777. switch (col.field) {
  778. case 'unit_price':
  779. case 'sgfh_qty':
  780. case 'sgfh_tp':
  781. case 'sjcl_qty':
  782. case 'sjcl_tp':
  783. case 'qtcl_qty':
  784. case 'qtcl_tp':
  785. case 'deal_qty':
  786. case 'deal_tp':
  787. info.cancel = node.children && node.children.length > 0;
  788. break;
  789. case 'dgn_qty1':
  790. case 'dgn_qty2':
  791. info.cancel = !_.isEmpty(node.b_code);
  792. break;
  793. }
  794. }
  795. };
  796. ledgerTreeCol.initSpreadSetting(ledgerSpreadSetting);
  797. SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);
  798. // 绑定事件
  799. ledgerSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, treeOperationObj.selectionChanged);
  800. ledgerSpread.bind(spreadNS.Events.TopRowChanged, treeOperationObj.topRowChanged);
  801. if (!ledgerSpreadSetting.readOnly) {
  802. ledgerSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, function (e, info) {
  803. treeOperationObj.refreshOperationValid(info.sheet, info.newSelections);
  804. });
  805. ledgerSpread.bind(GC.Spread.Sheets.Events.EditEnded, treeOperationObj.editEnded);
  806. //ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardPasted, treeOperationObj.clipboardPasted);
  807. SpreadJsObj.addDeleteBind(ledgerSpread, treeOperationObj.deletePress);
  808. ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardChanging, function (e, info) {
  809. const copyText = SpreadJsObj.getFilterCopyText(info.sheet);
  810. //console.log(info.copyData);
  811. SpreadJsObj.Clipboard.setCopyData(copyText);
  812. //copyToClipboard(copyText);
  813. });
  814. ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardPasting, treeOperationObj.clipboardPasting);
  815. ledgerSpread.bind(spreadNS.Events.EditStarting, treeOperationObj.editStarting);
  816. SpreadJsObj.addCutEvents(ledgerSpread, treeOperationObj.cut);
  817. // 绑定 删除等 顶部按钮
  818. $('#insert').click(() => {
  819. treeOperationObj.addNode(ledgerSpread.getActiveSheet());
  820. });
  821. $('#delete').click(function () {
  822. treeOperationObj.deleteNode(ledgerSpread.getActiveSheet());
  823. });
  824. $('#up-move').click(function () {
  825. treeOperationObj.upMove(ledgerSpread.getActiveSheet());
  826. });
  827. $('#down-move').click(function () {
  828. treeOperationObj.downMove(ledgerSpread.getActiveSheet());
  829. });
  830. $('#up-level').click(function () {
  831. treeOperationObj.upLevel(ledgerSpread.getActiveSheet());
  832. });
  833. $('#down-level').click(function () {
  834. treeOperationObj.downLevel(ledgerSpread.getActiveSheet());
  835. });
  836. $('#copy').click(function () {
  837. ledgerSpread.commandManager().execute({
  838. cmd: 'copy',
  839. sheetName: ledgerSpread.getActiveSheet().name()
  840. });
  841. });
  842. $('#paste').click(function () {
  843. ledgerSpread.commandManager().execute({
  844. cmd: 'paste',
  845. sheetName: ledgerSpread.getActiveSheet().name()
  846. });
  847. });
  848. $('#cut').click(function () {
  849. ledgerSpread.commandManager().execute({
  850. cmd: 'cut',
  851. sheetName: ledgerSpread.getActiveSheet().name()
  852. });
  853. });
  854. $('#bills-expr').bind('change mouseleave', function () {
  855. const expr = $(this);
  856. const sheet = ledgerSpread.getActiveSheet();
  857. const select = SpreadJsObj.getSelectObject(sheet);
  858. const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = trimInvalidChar(expr.val());
  859. if (orgValue === newValue || (!orgValue && newValue == '')) { return; }
  860. const data = {
  861. id: select.id,
  862. tender_id: select.tender_id,
  863. ledger_id: select.ledger_id
  864. };
  865. if (newValue !== '') {
  866. const num = _.toNumber(newValue);
  867. if (num) {
  868. data[field] = num;
  869. } else {
  870. try {
  871. data[field] = math.evaluate(transExpr(newValue));
  872. } catch (err) {
  873. toastr.error('输入的表达式非法');
  874. return;
  875. }
  876. }
  877. } else {
  878. data[field] = null;
  879. }
  880. // 更新至服务器
  881. postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
  882. const refreshNode = ledgerTree.loadPostData(result);
  883. expr.val(select[field]);
  884. treeOperationObj.refreshTree(sheet, refreshNode);
  885. });
  886. });
  887. let batchInsertObj;
  888. $.contextMenu.types.batchInsert = function (item, opt, root) {
  889. const self = this;
  890. if ($.isFunction(item.icon)) {
  891. item._icon = item.icon.call(this, this, $t, key, item);
  892. } else {
  893. if (typeof(item.icon) === 'string' && item.icon.substring(0, 3) === 'fa-') {
  894. // to enable font awesome
  895. item._icon = root.classNames.icon + ' ' + root.classNames.icon + '--fa fa ' + item.icon;
  896. } else {
  897. item._icon = root.classNames.icon + ' ' + root.classNames.icon + '-' + item.icon;
  898. }
  899. }
  900. this.addClass(item._icon);
  901. const $obj = $('<div>' + item.name + '<input class="text-right ml-1 mr-1" type="tel" max="20" min="1" value="' + item.value + '" style="width: 30px; height: 18px; padding-right: 4px;">行</div>')
  902. .appendTo(this);
  903. const $input = $obj.find('input');
  904. const event = () => {
  905. if (self.hasClass('context-menu-disabled')) return;
  906. item.batchInsert($input[0], root);
  907. };
  908. $obj.on('click', event).keypress(function (e) {if (e.keyCode === 13) { event(); }});
  909. $input.click((e) => {e.stopPropagation();})
  910. .keyup((e) => {if (e.keyCode === 13) item.batchInsert($input[0], root);})
  911. .on('input', function () {this.value = this.value.replace(/[^\d]/g, '');});
  912. };
  913. // 右键菜单
  914. $.contextMenu({
  915. selector: '#ledger-spread',
  916. build: function ($trigger, e) {
  917. const target = SpreadJsObj.safeRightClickSelection($trigger, e, ledgerSpread);
  918. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  919. },
  920. items: {
  921. 'create': {
  922. name: '新增',
  923. icon: 'fa-sign-in',
  924. callback: function (key, opt) {
  925. treeOperationObj.addNode(ledgerSpread.getActiveSheet());
  926. },
  927. disabled: function (key, opt) {
  928. const sheet = ledgerSpread.getActiveSheet();
  929. const selection = sheet.getSelections();
  930. const sel = selection ? selection[0] : sheet.getSelections()[0];
  931. const row = sel ? sel.row : -1;
  932. const tree = sheet.zh_tree;
  933. if (!tree) return true;
  934. const first = sheet.zh_tree.nodes[row];
  935. let last = first, sameParent = true;
  936. if (sel.rowCount > 1) {
  937. for (let r = 1; r < sel.rowCount; r++) {
  938. const rNode = tree.nodes[sel.row + r];
  939. if (rNode.level > first.level) continue;
  940. if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
  941. sameParent = false;
  942. break;
  943. }
  944. last = rNode;
  945. }
  946. }
  947. const valid = !sheet.zh_setting.readOnly;
  948. return !(valid && first && first.level > 1);
  949. }
  950. },
  951. 'delete': {
  952. name: '删除',
  953. icon: 'fa-remove',
  954. callback: function (key, opt) {
  955. treeOperationObj.deleteNode(ledgerSpread.getActiveSheet());
  956. },
  957. disabled: function (key, opt) {
  958. const sheet = ledgerSpread.getActiveSheet();
  959. const selection = sheet.getSelections();
  960. const sel = selection ? selection[0] : sheet.getSelections()[0];
  961. const row = sel ? sel.row : -1;
  962. const tree = sheet.zh_tree;
  963. if (!tree) return true;
  964. const first = sheet.zh_tree.nodes[row];
  965. let last = first, sameParent = true;
  966. if (sel.rowCount > 1) {
  967. for (let r = 1; r < sel.rowCount; r++) {
  968. const rNode = tree.nodes[sel.row + r];
  969. if (rNode.level > first.level) continue;
  970. if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
  971. sameParent = false;
  972. break;
  973. }
  974. last = rNode;
  975. }
  976. }
  977. const valid = !sheet.zh_setting.readOnly;
  978. return !(valid && first && sameParent && !(first.level === 1 && first.node_type));
  979. }
  980. },
  981. 'sprBase': '-----------',
  982. 'copyBlock': {
  983. name: '复制整块',
  984. icon: 'fa-files-o',
  985. callback: function (key, opt) {
  986. /*ledgerSpread.commandManager().execute({
  987. cmd:"copy",
  988. sheetName:ledgerSpread.getActiveSheet().name()
  989. });*/
  990. treeOperationObj.block = [];
  991. const copyBlockList = [];
  992. const sheet = ledgerSpread.getActiveSheet();
  993. const sel = sheet.getSelections()[0];
  994. let iRow = sel.row;
  995. const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
  996. while (iRow < sel.row + sel.rowCount) {
  997. const node = sheet.zh_tree.nodes[iRow];
  998. if (node.ledger_pid !== pid) {
  999. toastr.error('仅可同时选中同层节点');
  1000. return;
  1001. }
  1002. copyBlockList.push(node.ledger_id);
  1003. iRow += sheet.zh_tree.getPosterity(node).length + 1;
  1004. }
  1005. const tenderId = _.toInteger(getTenderId());
  1006. setLocalCache(copyBlockTag, JSON.stringify({tid: tenderId, block: copyBlockList}));
  1007. //treeOperationObj.block = copyBlockList;
  1008. },
  1009. visible: function (key, opt) {
  1010. const sheet = ledgerSpread.getActiveSheet();
  1011. const selection = sheet.getSelections();
  1012. const row = selection[0].row;
  1013. const select = ledgerTree.nodes[row];
  1014. return select;
  1015. }
  1016. },
  1017. 'pasteBlock': {
  1018. name: '粘贴整块',
  1019. icon: 'fa-clipboard',
  1020. disabled: function (key, opt) {
  1021. //const block = treeOperationObj.block || [];
  1022. const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
  1023. return !(copyInfo && copyInfo.tid && copyInfo.tid > 0 && copyInfo.block && copyInfo.block.length > 0);
  1024. },
  1025. callback: function (key, opt) {
  1026. //const block = treeOperationObj.block || [];
  1027. const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
  1028. if (copyInfo.block.length > 0) {
  1029. treeOperationObj.pasteBlock(ledgerSpread, copyInfo);
  1030. } else {
  1031. document.execCommand('paste');
  1032. }
  1033. }
  1034. },
  1035. 'sprBlock': '-----------',
  1036. 'batchInsert': {
  1037. name: '批量插入',
  1038. type: 'batchInsert',
  1039. value: '2',
  1040. icon: 'fa-sign-in',
  1041. batchInsert: function (obj, root) {
  1042. if (_.toNumber(obj.value) > _.toNumber(obj.max)) {
  1043. obj.value = obj.max;
  1044. toastr.warning('批量插入不可多于' + obj.max);
  1045. } else if(_.toNumber(obj.value) < _.toNumber(obj.min)) {
  1046. obj.value = obj.min;
  1047. toastr.warning('批量插入不可少于' + obj.min);
  1048. } else {
  1049. treeOperationObj.addNode(ledgerSpread.getActiveSheet(), parseInt(obj.value));
  1050. root.$menu.trigger('contextmenu:hide');
  1051. }
  1052. },
  1053. disabled: function (key, opt) {
  1054. const sheet = ledgerSpread.getActiveSheet();
  1055. const selection = sheet.getSelections();
  1056. const sel = selection ? selection[0] : sheet.getSelections()[0];
  1057. const row = sel ? sel.row : -1;
  1058. const tree = sheet.zh_tree;
  1059. if (!tree) return true;
  1060. const first = sheet.zh_tree.nodes[row];
  1061. let last = first, sameParent = true;
  1062. if (sel.rowCount > 1) {
  1063. for (let r = 1; r < sel.rowCount; r++) {
  1064. const rNode = tree.nodes[sel.row + r];
  1065. if (rNode.level > first.level) continue;
  1066. if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
  1067. sameParent = false;
  1068. break;
  1069. }
  1070. last = rNode;
  1071. }
  1072. }
  1073. const valid = !sheet.zh_setting.readOnly;
  1074. return !(valid && first && first.level > 1);
  1075. }
  1076. },
  1077. 'batchInsertBillsPos': {
  1078. name: '批量插入清单-计量单元',
  1079. icon: 'fa-sign-in',
  1080. disabled: function (key, opt) {
  1081. if (!checkTzMeasureType()) return true;
  1082. const sheet = ledgerSpread.getActiveSheet();
  1083. const selection = sheet.getSelections();
  1084. const row = selection[0].row;
  1085. const select = ledgerTree.nodes[row];
  1086. if (select) {
  1087. if (select.code && select.code !== '') {
  1088. return !ledgerTree.isLeafXmj(select);
  1089. } else {
  1090. const parent = ledgerTree.getParent(select);
  1091. return !(parent && ledgerTree.isLeafXmj(parent));
  1092. }
  1093. } else {
  1094. return false;
  1095. }
  1096. },
  1097. callback: function (key, opt) {
  1098. if (!batchInsertObj) {
  1099. batchInsertObj = new BatchInsertBillsPosObj($('#batch'));
  1100. } else {
  1101. batchInsertObj.initView();
  1102. }
  1103. $('#batch').modal('show');
  1104. }
  1105. },
  1106. 'sprBatch': '-----------',
  1107. 'importExcel': {
  1108. name: '导入分项清单Excel',
  1109. icon: 'fa-file-excel-o',
  1110. disabled: function (key, opt) {
  1111. return readOnly;
  1112. },
  1113. callback: function (key, opt) {
  1114. importExcel.doImport({
  1115. template: {
  1116. hint: '0号台账',
  1117. url: '/template/导入分项清单EXCEL格式.xls',
  1118. },
  1119. callback: function (sheet) {
  1120. postDataCompress(window.location.pathname + '/upload-excel/tz', sheet, function (result) {
  1121. ledgerTree.loadDatas(result.bills);
  1122. treeCalc.calculateAll(ledgerTree);
  1123. SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
  1124. pos.loadDatas(result.pos);
  1125. posOperationObj.loadCurPosData();
  1126. }, null);
  1127. }
  1128. });
  1129. //$('#upload-ledger').modal('show');
  1130. }
  1131. },
  1132. 'importGclBills2Xmj': {
  1133. name: '导入工程量清单至项目节',
  1134. icon: 'fa-file-excel-o',
  1135. disabled: function (key, opt) {
  1136. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1137. return readOnly
  1138. || (node.children && node.children.length > 0)
  1139. || (!_.isNil(node.b_code) && node.b_code !== '');
  1140. },
  1141. callback: function (key, opt) {
  1142. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1143. importExcel.doImport({
  1144. template: {
  1145. hint: '工程量清单',
  1146. url: '/template/导入工程量清单EXCEL格式.xls',
  1147. },
  1148. callback: function (sheet) {
  1149. postDataCompress(window.location.pathname + '/upload-excel/gcl2xmj', {id: node.id, sheet: sheet}, function (result) {
  1150. const ledgerSheet = ledgerSpread.getActiveSheet();
  1151. const sel = ledgerSheet.getSelections();
  1152. const refreshNode = ledgerTree.loadPostData(result);
  1153. treeOperationObj.refreshTree(ledgerSheet, refreshNode);
  1154. if (refreshNode.create[0]) {
  1155. if (sel && sel[0]) {
  1156. ledgerSheet.setSelection(refreshNode.create[0].index, sel[0].col, sel[0].rowCount, sel[0].colCount);
  1157. } else {
  1158. ledgerSheet.setSelection(refreshNode.create[0].index, 0, 1, 1);
  1159. }
  1160. }
  1161. treeOperationObj.refreshOperationValid(ledgerSheet);
  1162. }, null);
  1163. }
  1164. });
  1165. }
  1166. },
  1167. 'sprImport': '-----------',
  1168. 'exportExcel': {
  1169. name: '导出表格数据',
  1170. icon: 'fa-file-excel-o',
  1171. callback: function (key, opt) {
  1172. const excelIo = new GC.Spread.Excel.IO();
  1173. const date = new Date();
  1174. const fileName = $('.text-truncate').attr('data-original-title') + '.xlsx';
  1175. const sJson = JSON.stringify(ledgerSpread.toJSON({columnHeadersAsFrozenRows: true, rowHeadersAsFrozenColumns: true}));
  1176. excelIo.save(sJson, function(blob) {
  1177. saveAs(blob, fileName);
  1178. });
  1179. },
  1180. visible: function (key, opt) {
  1181. try {
  1182. return is_debug;
  1183. } catch (err) {
  1184. return false;
  1185. }
  1186. }
  1187. }
  1188. },
  1189. });
  1190. } else {
  1191. SpreadJsObj.forbiddenSpreadContextMenu('#ledger-spread', ledgerSpread);
  1192. }
  1193. const posSearch = $.posSearch({selector: '#pos-search', searchSpread: posSpread});
  1194. // 台账模式加载计量单元数据
  1195. if (checkTzMeasureType()) {
  1196. $.divResizer({
  1197. select: '#main-resize',
  1198. callback: function () {
  1199. ledgerSpread.refresh();
  1200. let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  1201. $(".sp-wrap").height(bcontent-40);
  1202. posSpread.refresh();
  1203. }
  1204. });
  1205. SpreadJsObj.initSheet(posSpread.getActiveSheet(), posSpreadSetting);
  1206. }
  1207. // 绑定计量单元编辑事件
  1208. const posOperationObj = {
  1209. editStarting: function (e, info) {
  1210. posOperationObj.ledgerTreeNode = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1211. },
  1212. /**
  1213. * 加载计量单元 根据当前台账选择节点
  1214. */
  1215. loadCurPosData: function () {
  1216. const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
  1217. if (node) {
  1218. const posData = pos.ledgerPos[itemsPre + node.id] || [];
  1219. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', posData);
  1220. } else {
  1221. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', []);
  1222. }
  1223. },
  1224. /**
  1225. * 编辑单元格响应事件
  1226. * @param {Object} e
  1227. * @param {Object} info
  1228. */
  1229. editEnded: function (e, info) {
  1230. if (info.sheet.zh_setting) {
  1231. const posData = info.sheet.zh_data ? info.sheet.zh_data[info.row] : null;
  1232. const col = info.sheet.zh_setting.cols[info.col];
  1233. const orgText = posData ? posData[col.field] : null;
  1234. const newText = trimInvalidChar(info.sheet.getCell(info.row, info.col).text());
  1235. if (orgText === newText || ((!orgText || orgText === '') && (newText === ''))) {
  1236. return;
  1237. }
  1238. //const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
  1239. const node = posOperationObj.ledgerTreeNode;
  1240. if (!node) {
  1241. toastr.error('数据错误,请选择台账节点后再试');
  1242. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1243. return;
  1244. } else if (newText && newText !== '' && node.children && node.children.length > 0) {
  1245. toastr.error('父节点不可插入计量单元');
  1246. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1247. return;
  1248. } else if (newText && newText !== '' && (!node.b_code || node.b_code === '')) {
  1249. toastr.error('项目节不可插入计量单元');
  1250. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1251. return;
  1252. }
  1253. const data = {};
  1254. if (col.field === 'name') {
  1255. if (newText === '' && posData) {
  1256. toastr.error('部位名称不可为空');
  1257. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1258. return;
  1259. } else if (!posData) {
  1260. if (newText && newText !== '') {
  1261. data.updateType = 'add';
  1262. const sortData = info.sheet.zh_data;
  1263. const order = (!sortData || sortData.length === 0) ? 1 : Math.max(sortData[sortData.length - 1].porder + 1, sortData.length + 1);
  1264. data.updateData = { name: newText, lid: node.id, tid: tender.id, porder: order};
  1265. } else {
  1266. return;
  1267. }
  1268. } else {
  1269. data.updateType = 'update';
  1270. data.updateData = {id: posData.id, name: newText};
  1271. }
  1272. } else if (!posData) {
  1273. toastr.warning('新增部位请先输入名称');
  1274. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1275. return;
  1276. } else {
  1277. data.updateType = 'update';
  1278. data.updateData = {id: posData.id};
  1279. if (col.type === 'Number') {
  1280. const num = _.toNumber(newText);
  1281. if (_.isFinite(num)) {
  1282. data.updateData[col.field] = num;
  1283. } else {
  1284. try {
  1285. data.updateData[col.field] = math.evaluate(transExpr(newText));
  1286. } catch(err) {
  1287. toastr.error('输入的表达式非法');
  1288. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1289. return;
  1290. }
  1291. }
  1292. } else {
  1293. data.updateData[col.field] = newText;
  1294. }
  1295. }
  1296. postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
  1297. const updateRst = pos.updateDatas(result.pos);
  1298. // 刷新当前行, 不适用于新增(在非下一空白行新增)
  1299. if (updateRst.create.length > 0) {
  1300. // info.sheet.addRows(info.row, 1);
  1301. // if (info.sheet.zh_data.length === 0) {
  1302. // info.sheet.zh_data = pos.ledgerPos[itemsPre + node.id] || [];
  1303. // }
  1304. // SpreadJsObj.reLoadRowData(info.sheet, info.sheet.zh_data.length - 1);
  1305. posOperationObj.loadCurPosData();
  1306. } else {
  1307. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1308. }
  1309. const loadResult = ledgerTree.loadPostData(result.ledger);
  1310. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1311. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1312. }, function () {
  1313. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1314. });
  1315. }
  1316. },
  1317. /**
  1318. * 删除按钮响应事件
  1319. * @param sheet
  1320. */
  1321. deletePress: function (sheet) {
  1322. const self = this;
  1323. if (sheet.zh_setting) {
  1324. const sortData = sheet.zh_data;
  1325. const datas = [], posSelects = [];
  1326. const sel = sheet.getSelections()[0];
  1327. for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
  1328. let bDel = false;
  1329. const node = sortData[iRow];
  1330. if (node) {
  1331. const data = {id: node.id};
  1332. for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
  1333. const colSetting = sheet.zh_setting.cols[iCol];
  1334. if (colSetting.field === 'name') {
  1335. toastr.error('部位名称不能为空');
  1336. return;
  1337. }
  1338. const style = sheet.getStyle(iRow, iCol);
  1339. if (!style.locked) {
  1340. const colSetting = sheet.zh_setting.cols[iCol];
  1341. data[colSetting.field] = null;
  1342. bDel = true;
  1343. }
  1344. }
  1345. if (bDel) {
  1346. datas.push(data);
  1347. posSelects.push(node);
  1348. }
  1349. }
  1350. }
  1351. if (datas.length > 0) {
  1352. postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: datas}, function (result) {
  1353. pos.updateDatas(result.pos);
  1354. posOperationObj.loadCurPosData();
  1355. const loadResult = ledgerTree.loadPostData(result.ledger);
  1356. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1357. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1358. }, function () {
  1359. posOperationObj.loadCurPosData();
  1360. });
  1361. }
  1362. }
  1363. },
  1364. /**
  1365. * 删除 计量单元
  1366. * @param sheet
  1367. */
  1368. deletePos: function (sheet) {
  1369. const selection = sheet.getSelections();
  1370. const data = {
  1371. updateType: 'delete',
  1372. updateData: [],
  1373. };
  1374. const row = selection[0].row, count = selection[0].rowCount;
  1375. const sortData = sheet.zh_data;
  1376. for (let iRow = 0; iRow < count; iRow++) {
  1377. if (sortData[iRow + row]) {
  1378. data.updateData.push(sortData[iRow + row].id);
  1379. }
  1380. }
  1381. if (data.updateData.length > 0) {
  1382. postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
  1383. pos.removeDatas(result.pos);
  1384. sheet.deleteRows(row, count);
  1385. const loadResult = ledgerTree.loadPostData(result.ledger);
  1386. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1387. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1388. });
  1389. }
  1390. },
  1391. /**
  1392. * 粘贴单元格响应事件
  1393. * @param e
  1394. * @param info
  1395. */
  1396. clipboardPasted: function (e, info) {
  1397. const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
  1398. if (node.code && (node.code !== '')) {
  1399. toastr.error('项目节不可含有清单明细');
  1400. posOperationObj.loadCurPosData();
  1401. return;
  1402. }
  1403. if (node.children && (node.children.length > 0)) {
  1404. toastr.error('仅清单子项可以含有计量单元');
  1405. posOperationObj.loadCurPosData();
  1406. return;
  1407. }
  1408. if (info.sheet.zh_setting) {
  1409. const data = [];
  1410. const sortData = info.sheet.zh_data || [];
  1411. if (sortData.length === 0 || info.cellRange.row + info.cellRange.rowCount > sortData.length) {
  1412. if (info.cellRange.col !== 0) {
  1413. toastr.warning('新增部位请先输入名称');
  1414. posOperationObj.loadCurPosData();
  1415. return;
  1416. }
  1417. }
  1418. const lastOrder = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
  1419. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
  1420. let bPaste = false;
  1421. const curRow = info.cellRange.row + iRow;
  1422. const posData = curRow >= sortData.length ? {lid: node.id, porder: lastOrder + curRow - sortData.length} : {id: sortData[curRow].id, lid: node.id};
  1423. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  1424. const curCol = info.cellRange.col + iCol;
  1425. const colSetting = info.sheet.zh_setting.cols[curCol];
  1426. posData[colSetting.field] = trimInvalidChar(info.sheet.getText(curRow, curCol));
  1427. if (colSetting.type === 'Number') {
  1428. const num = _.toNumber(posData[colSetting.field]);
  1429. if (num) {
  1430. posData[colSetting.field] = num;
  1431. bPaste = true;
  1432. } else {
  1433. try {
  1434. posData[colSetting.field] = math.evaluate(transExpr(posData[colSetting.field]));
  1435. bPaste = true;
  1436. } catch(err) {
  1437. delete posData[colSetting.field];
  1438. toastr.warning('粘贴了表达式非法,已过滤');
  1439. }
  1440. }
  1441. } else {
  1442. bPaste = true;
  1443. }
  1444. }
  1445. if (bPaste) {
  1446. data.push(posData);
  1447. }
  1448. }
  1449. if (data.length > 0) {
  1450. postData('/tender/' + getTenderId() + '/pos/paste', data, function (result) {
  1451. pos.updateDatas(result.pos);
  1452. posOperationObj.loadCurPosData();
  1453. const loadResult = ledgerTree.loadPostData(result.ledger);
  1454. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1455. posOperationObj.loadCurPosData();
  1456. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1457. }, function () {
  1458. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  1459. });
  1460. } else {
  1461. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  1462. }
  1463. }
  1464. },
  1465. selectionChanged: function (e, info) {
  1466. const col = info.sheet.zh_setting.cols[info.newSelections[0].col];
  1467. const cell = info.sheet.getCell(info.newSelections[0].row, info.newSelections[0].col);
  1468. if (col && col.type === 'Number') {
  1469. const data = SpreadJsObj.getSelectObject(info.sheet);
  1470. if (data) {
  1471. $('#pos-expr').val(data[col.field]).attr('field', col.field).attr('org', data[col.field])
  1472. .attr('row', info.newSelections[0].row).attr('readOnly', readOnly || cell.locked());
  1473. } else {
  1474. $('#pos-expr').val('').attr('readOnly', true);
  1475. }
  1476. } else {
  1477. $('#pos-expr').val('').attr('readOnly', true);
  1478. }
  1479. },
  1480. addPegs: function (pegs) {
  1481. if (!pegs || pegs.length <= 0) return;
  1482. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1483. if (!node) return;
  1484. const sheet = posSpread.getActiveSheet();
  1485. const sortData = sheet.zh_data || [];
  1486. let order = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
  1487. pegs.forEach(function (p) {p.porder = ++order; p.lid = node.id});
  1488. postData('/tender/' + getTenderId() + '/pos/paste', pegs, function (result) {
  1489. pos.updateDatas(result.pos);
  1490. posOperationObj.loadCurPosData();
  1491. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1492. });
  1493. }
  1494. };
  1495. posSpread.bind(spreadNS.Events.SelectionChanged, posOperationObj.selectionChanged);
  1496. if (!posSpreadSetting.readOnly) {
  1497. $('#pos-expr').bind('change mouseleave', function () {
  1498. const expr = $(this);
  1499. const posSheet = posSpread.getActiveSheet();
  1500. const select = SpreadJsObj.getSelectObject(posSheet);
  1501. if (select) return;
  1502. const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = expr.val(), row = trimInvalidChar(expr.attr('row'));
  1503. if (orgValue === newValue || (!orgValue && newValue == '')) { return; }
  1504. const data = {id: select.id};
  1505. if (newValue !== '') {
  1506. const num = _.toNumber(newValue);
  1507. if (num) {
  1508. data[field] = num;
  1509. } else {
  1510. try {
  1511. data[field] = math.evaluate(transExpr(newValue));
  1512. } catch (err) {
  1513. toastr.error('输入的表达式非法');
  1514. return;
  1515. }
  1516. }
  1517. } else {
  1518. data[field] = null;
  1519. }
  1520. // 更新至服务器
  1521. postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: data}, function (result) {
  1522. const updateRst = pos.updateDatas(result.pos);
  1523. expr.val(select[field]);
  1524. SpreadJsObj.reLoadRowData(posSheet, _.toNumber(row));
  1525. const loadResult = ledgerTree.loadPostData(result.ledger);
  1526. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1527. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1528. });
  1529. });
  1530. SpreadJsObj.addDeleteBind(posSpread, posOperationObj.deletePress);
  1531. posSpread.bind(spreadNS.Events.EditStarting, posOperationObj.editStarting);
  1532. posSpread.bind(spreadNS.Events.EditEnded, posOperationObj.editEnded);
  1533. posSpread.bind(spreadNS.Events.ClipboardPasted, posOperationObj.clipboardPasted);
  1534. const mergePeg = NewMergePeg({ callback: posOperationObj.addPegs });
  1535. // 右键菜单
  1536. $.contextMenu({
  1537. selector: '#pos-spread',
  1538. build: function ($trigger, e) {
  1539. const target = SpreadJsObj.safeRightClickSelection($trigger, e, posSpread);
  1540. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  1541. },
  1542. items: {
  1543. 'delete': {
  1544. name: '删除',
  1545. icon: 'fa-remove',
  1546. disabled: function (key, opt) {
  1547. const sheet = posSpread.getActiveSheet();
  1548. if (sheet.zh_data) {
  1549. const selection = sheet.getSelections();
  1550. return sheet.zh_data.length < selection[0].row + selection[0].rowCount;
  1551. } else {
  1552. return true;
  1553. }
  1554. },
  1555. callback: function (key, opt) {
  1556. posOperationObj.deletePos(posSpread.getActiveSheet());
  1557. }
  1558. },
  1559. 'merge-peg': {
  1560. name: '合并起讫桩号',
  1561. disabled: function (key, opt) {
  1562. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1563. return _.isNil(node) || _.isNil(node.b_code) || node.b_code === '';
  1564. },
  1565. callback: function (key, opt) {
  1566. mergePeg.show();
  1567. }
  1568. }
  1569. }
  1570. });
  1571. } else {
  1572. SpreadJsObj.forbiddenSpreadContextMenu('#pos-spread', posSpread);
  1573. }
  1574. postData(window.location.pathname + '/load', {}, function (data) {
  1575. ledgerTree.loadDatas(data.bills);
  1576. treeCalc.calculateAll(ledgerTree);
  1577. SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
  1578. SpreadJsObj.loadTopAndSelect(ledgerSpread.getActiveSheet(), ckBillsSpread);
  1579. pos.loadDatas(data.pos);
  1580. posOperationObj.loadCurPosData();
  1581. SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
  1582. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1583. treeOperationObj.loadExprToInput(ledgerSpread.getActiveSheet());
  1584. }, null, true);
  1585. $.divResizer({
  1586. select: '#right-spr',
  1587. callback: function () {
  1588. ledgerSpread.refresh();
  1589. if (posSpread) {
  1590. posSpread.refresh();
  1591. }
  1592. if (stdXmj) {
  1593. stdXmj.spread.refresh();
  1594. }
  1595. if (stdGcl) {
  1596. stdGcl.spread.refresh();
  1597. }
  1598. if (dealBills) {
  1599. dealBills.spread.refresh();
  1600. }
  1601. if (searchLedger) {
  1602. searchLedger.spread.refresh();
  1603. }
  1604. }
  1605. });
  1606. const stdLibCellDoubleClick = function (e, info) {
  1607. const stdSheet = info.sheet;
  1608. const mainSheet = ledgerSpread.getActiveSheet();
  1609. if (!stdSheet.zh_setting || !stdSheet.zh_tree || !mainSheet.zh_tree) { return; }
  1610. const stdTree = stdSheet.zh_tree;
  1611. const stdNode = stdTree.nodes[info.row];
  1612. const mainTree = mainSheet.zh_tree;
  1613. const sel = mainSheet.getSelections()[0];
  1614. const mainNode = mainTree.nodes[sel.row];
  1615. if (!stdNode) { return; }
  1616. if (info.sheet.zh_setting.stdType === 'gcl') {
  1617. if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
  1618. toastr.warning('非最底层项目下,不应添加清单');
  1619. return;
  1620. }
  1621. }
  1622. postData(window.location.pathname + '/update', {
  1623. postType: 'add-std',
  1624. postData: {
  1625. id: ledgerTree.getNodeKey(mainNode),
  1626. tender_id: mainNode.tender_id,
  1627. stdType: info.sheet.zh_setting.stdType,
  1628. stdLibId: stdNode.list_id,
  1629. stdNode: stdTree.getNodeKey(stdNode)
  1630. }
  1631. }, function (result) {
  1632. const refreshNode = mainTree.loadPostData(result);
  1633. treeOperationObj.refreshTree(mainSheet, refreshNode);
  1634. if (refreshNode.create && refreshNode.create.length > 0) {
  1635. mainSheet.setSelection(refreshNode.create[refreshNode.create.length - 1].index, sel.col, sel.rowCount, sel.colCount);
  1636. } else {
  1637. const node = _.find(ledgerTree.nodes, {code: stdNode.code, name: stdNode.name});
  1638. if (node) {
  1639. mainSheet.setSelection(ledgerTree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  1640. }
  1641. }
  1642. treeOperationObj.refreshOperationValid(mainSheet);
  1643. ledgerSpread.focus();
  1644. posOperationObj.loadCurPosData();
  1645. });
  1646. };
  1647. const stdXmjSetting = {
  1648. selector: '#std-xmj',
  1649. stdType: 'xmj',
  1650. treeSetting: {
  1651. id: 'chapter_id',
  1652. pid: 'pid',
  1653. order: 'order',
  1654. level: 'level',
  1655. rootId: -1,
  1656. keys: ['id', 'list_id', 'chapter_id'],
  1657. },
  1658. spreadSetting: {
  1659. cols: [
  1660. {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  1661. {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
  1662. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
  1663. ],
  1664. treeCol: 0,
  1665. emptyRows: 0,
  1666. headRows: 1,
  1667. headRowHeight: [32],
  1668. defaultRowHeight: 21,
  1669. headerFont: '12px 微软雅黑',
  1670. font: '12px 微软雅黑',
  1671. headColWidth: [0],
  1672. },
  1673. cellDoubleClick: stdLibCellDoubleClick,
  1674. page: 'ledger',
  1675. tid: getTenderId(),
  1676. };
  1677. const stdGclSetting = {
  1678. selector: '#std-gcl',
  1679. stdType: 'gcl',
  1680. treeSetting: {
  1681. id: 'bill_id',
  1682. pid: 'pid',
  1683. order: 'order',
  1684. level: 'level',
  1685. rootId: -1,
  1686. keys: ['id', 'list_id', 'bill_id']
  1687. },
  1688. spreadSetting: {
  1689. cols: [
  1690. {title: '清单编号', field: 'b_code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  1691. {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
  1692. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
  1693. ],
  1694. treeCol: 0,
  1695. emptyRows: 0,
  1696. headRows: 1,
  1697. headRowHeight: [32],
  1698. defaultRowHeight: 21,
  1699. headerFont: '12px 微软雅黑',
  1700. font: '12px 微软雅黑',
  1701. headColWidth: [0],
  1702. },
  1703. cellDoubleClick: stdLibCellDoubleClick,
  1704. page: 'ledger',
  1705. tid: getTenderId(),
  1706. };
  1707. // 展开收起标准清单
  1708. $('a', '#side-menu').bind('click', function (e) {
  1709. e.preventDefault();
  1710. const tab = $(this), tabPanel = $(tab.attr('content'));
  1711. const showSideTools = function (show) {
  1712. const left = $('#left-view'), right = $('#right-view'), parent = left.parent();
  1713. if (show) {
  1714. right.show();
  1715. autoFlashHeight();
  1716. /**
  1717. * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
  1718. * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px
  1719. * 故需要通过最终的parent.width再计算一次left.width
  1720. *
  1721. * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width?
  1722. * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width
  1723. *
  1724. */
  1725. //left.css('width', parent.width() - right.outerWidth());
  1726. //left.css('width', parent.width() - right.outerWidth());
  1727. const percent = 100 - right.outerWidth() /parent.width() * 100;
  1728. left.css('width', percent + '%');
  1729. } else {
  1730. left.width(parent.width());
  1731. right.hide();
  1732. }
  1733. };
  1734. // 展开工具栏、切换标签
  1735. if (!tab.hasClass('active')) {
  1736. const close = $('.active', '#side-menu').length === 0;
  1737. $('a', '#side-menu').removeClass('active');
  1738. tab.addClass('active');
  1739. $('.tab-content .tab-pane').removeClass('active');
  1740. tabPanel.addClass('active');
  1741. showSideTools(tab.hasClass('active'));
  1742. if (tab.attr('content') === '#std-xmj') {
  1743. if (!stdXmj) {
  1744. stdXmj = new stdLib(stdXmjSetting);
  1745. //stdXmj.loadLib($('select', '#std-xmj').val());
  1746. }
  1747. stdXmj.spread.refresh();
  1748. } else if (tab.attr('content') === '#std-gcl') {
  1749. if (!stdGcl) {
  1750. stdGcl = new stdLib(stdGclSetting);
  1751. //stdGcl.loadLib($('select', '#std-gcl').val());
  1752. }
  1753. stdGcl.spread.refresh();
  1754. } else if (tab.attr('content') === '#deal-bills') {
  1755. if (!dealBills) {
  1756. dealBills = new DealBills('#deal-bills-spread', {
  1757. cols: [
  1758. {title: '清单编号', field: 'code', hAlign: 0, width: 85, formatter: '@', readOnly: true},
  1759. {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
  1760. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
  1761. {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
  1762. {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
  1763. {title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true},
  1764. ],
  1765. emptyRows: 0,
  1766. headRows: 1,
  1767. headRowHeight: [32],
  1768. defaultRowHeight: 21,
  1769. headerFont: '12px 微软雅黑',
  1770. font: '12px 微软雅黑',
  1771. headColWidth: [0],
  1772. });
  1773. dealBills.loadData();
  1774. }
  1775. dealBills.spread.refresh();
  1776. } else if (tab.attr('content') === '#search' && !searchLedger) {
  1777. if (!searchLedger) {
  1778. searchLedger = $.billsSearch({
  1779. selector: '#search',
  1780. searchSpread: ledgerSpread,
  1781. resultSpreadSetting: {
  1782. cols: [
  1783. {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true},
  1784. {title: '清单编号', field: 'b_code', hAlign: 0, width: 120, formatter: '@', readOnly: true},
  1785. {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@', readOnly: true},
  1786. {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@', readOnly: true},
  1787. {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
  1788. {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
  1789. ],
  1790. emptyRows: 0,
  1791. headRows: 1,
  1792. headRowHeight: [32],
  1793. defaultRowHeight: 21,
  1794. headerFont: '12px 微软雅黑',
  1795. font: '12px 微软雅黑',
  1796. },
  1797. afterLocated: function () {
  1798. posOperationObj.loadCurPosData();
  1799. }
  1800. });
  1801. }
  1802. searchLedger.spread.refresh();
  1803. }
  1804. } else { // 收起工具栏
  1805. tab.removeClass('active');
  1806. tabPanel.removeClass('active');
  1807. showSideTools(tab.hasClass('active'));
  1808. }
  1809. ledgerSpread.refresh();
  1810. if (posSpread) {
  1811. posSpread.refresh();
  1812. }
  1813. });
  1814. class DealBills {
  1815. constructor (selector, spreadSetting) {
  1816. const self = this;
  1817. this.obj = $(selector)[0];
  1818. this.url = '/tender/' + getTenderId() + '/deal';
  1819. this.spreadSetting = spreadSetting;
  1820. this.spread = SpreadJsObj.createNewSpread(this.obj);
  1821. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  1822. if (!readOnly) {
  1823. this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
  1824. const dealSheet = info.sheet;
  1825. const mainSheet = ledgerSpread.getActiveSheet();
  1826. const dealBills = SpreadJsObj.getSelectObject(dealSheet);
  1827. if (!dealBills) { return; }
  1828. const mainTree = mainSheet.zh_tree;
  1829. const mainNode = SpreadJsObj.getSelectObject(mainSheet);
  1830. if (!mainNode || !mainTree) { return; }
  1831. if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
  1832. toastr.error('非最底层项目下,不应添加清单');
  1833. return;
  1834. }
  1835. postData(window.location.pathname + '/update', {
  1836. postType: 'add-deal',
  1837. postData: {
  1838. id: mainNode.ledger_id,
  1839. type: mainNode.code ? 'child' : 'next',
  1840. dealBills: {
  1841. b_code: dealBills.code, name: dealBills.name, unit: dealBills.unit,
  1842. unit_price: dealBills.unit_price,
  1843. }
  1844. },
  1845. }, function (result) {
  1846. const refreshData = mainTree.loadPostData(result);
  1847. treeOperationObj.refreshTree(mainSheet, refreshData);
  1848. const sel = mainSheet.getSelections()[0];
  1849. mainSheet.setSelection(refreshData.create[0].index, sel.col, sel.rowCount, sel.colCount);
  1850. treeOperationObj.refreshOperationValid(mainSheet);
  1851. ledgerSpread.focus();
  1852. posOperationObj.loadCurPosData();
  1853. });
  1854. });
  1855. }
  1856. SpreadJsObj.forbiddenSpreadContextMenu(selector, this.spread);
  1857. $('#upload-deal-bills').click(function () {
  1858. const file = $('#deal-bills-file')[0];
  1859. const formData = new FormData();
  1860. formData.append('file', file.files[0]);
  1861. postDataWithFile(self.url+'/upload-excel', formData, function (data) {
  1862. self.data = data;
  1863. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
  1864. $('#upload-deal').modal('hide');
  1865. }, function () {
  1866. $('#upload-deal').modal('hide');
  1867. });
  1868. });
  1869. }
  1870. loadData () {
  1871. const self = this;
  1872. postData(this.url+'/get-data', {}, function (data) {
  1873. self.data = data;
  1874. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
  1875. });
  1876. }
  1877. calculateData () {
  1878. if (this.data) {
  1879. for (const d of this.data) {
  1880. d.total_price = _.multiply(d.quantity, d.unit_price);
  1881. }
  1882. }
  1883. }
  1884. }
  1885. class BatchInsertBillsPosObj {
  1886. constructor (obj) {
  1887. const self = this;
  1888. this.obj = obj;
  1889. this.billsCount = 6;
  1890. this.posCount = 1000;
  1891. // 初始化 清单编号窗口 参数
  1892. this.qdSpreadSetting = {
  1893. cols: [
  1894. {title: '编号', field: 'code', hAlign: 0, width: 80, formatter: '@'},
  1895. {title: '名称', field: 'name', hAlign: 0, width: 120, formatter: '@'},
  1896. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
  1897. {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
  1898. {title: '图册号', field: 'name', hAlign: 0, width: 60, formatter: '@'},
  1899. ],
  1900. emptyRows: this.billsCount,
  1901. headRows: 1,
  1902. headRowHeight: [32],
  1903. headerFont: '12px 微软雅黑',
  1904. font: '12px 微软雅黑',
  1905. };
  1906. this.qdSpread = SpreadJsObj.createNewSpread($('.batch-l-t', this.obj)[0]);
  1907. // 初始化 部位数量复核表 参数
  1908. this.posSpreadSetting = {
  1909. cols: [
  1910. {title: '名称', field: 'bw', hAlign: 0, width: 80, formatter: '@'},
  1911. {title: '图册号', field: 'drawingCode', hAlign: 0, formatter: '@', width: 60},
  1912. ],
  1913. emptyRows: this.posCount,
  1914. headRows: 1,
  1915. headRowHeight: [32],
  1916. headerFont: '12px 微软雅黑',
  1917. font: '12px 微软雅黑',
  1918. };
  1919. for (let iNum = 1; iNum <= this.billsCount; iNum++) {
  1920. this.posSpreadSetting.cols.push(
  1921. {title: '清单' + iNum, field: 'bills' + iNum, hAlign: 2, width: 50}
  1922. )
  1923. }
  1924. this.posSpread = SpreadJsObj.createNewSpread($('.batch-l-b', this.obj)[0]);
  1925. // 初始化 签约清单 参数
  1926. this.dealSpreadSetting = {
  1927. cols: [
  1928. {title: '清单编号', field: 'code', width: 80, formatter: '@', readOnly: true},
  1929. {title: '名称', field: 'name', width: 120, formatter: '@', readOnly: true},
  1930. {title: '单位', field: 'unit', width: 50, formatter: '@', readOnly: true},
  1931. {title: '单价', field: 'unit_price', width: 50, readOnly: true},
  1932. ],
  1933. emptyRows: 0,
  1934. headRows: 1,
  1935. headRowHeight: [32],
  1936. headerFont: '12px 微软雅黑',
  1937. font: '12px 微软雅黑',
  1938. };
  1939. this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r', this.obj)[0]);
  1940. // 初始化 清单编号、部位数量复核表 表格
  1941. this.initView();
  1942. SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting);
  1943. SpreadJsObj.refreshColumnAlign(this.dealSpread.getActiveSheet());
  1944. $.contextMenu({
  1945. selector: '.batch-l-t',
  1946. build: function ($trigger, e) {
  1947. const target = SpreadJsObj.safeRightClickSelection($trigger, e, self.qdSpread);
  1948. return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
  1949. },
  1950. items: {
  1951. 'create': {
  1952. name: '新增行',
  1953. icon: 'fa-sign-in',
  1954. callback: function (key, opt) {
  1955. const qdSheet = self.qdSpread.getActiveSheet();
  1956. const posSheet = self.posSpread.getActiveSheet();
  1957. qdSheet.addRows(qdSheet.getRowCount(), 1);
  1958. const index = qdSheet.getRowCount();
  1959. qdSheet.getCell(qdSheet.getRowCount() - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + index);
  1960. posSheet.addColumns(posSheet.getColumnCount(), 1);
  1961. posSheet.getCell(0, index + 2, spreadNS.SheetArea.colHeader).text('清单' + index);
  1962. },
  1963. },
  1964. 'delete': {
  1965. name: '删除行',
  1966. icon: 'fa-remove',
  1967. callback: function (key, opt) {
  1968. const qdSheet = self.qdSpread.getActiveSheet();
  1969. const posSheet = self.posSpread.getActiveSheet();
  1970. const sel = qdSheet.getSelections()[0];
  1971. qdSheet.deleteRows(sel.row, sel.rowCount);
  1972. posSheet.deleteColumns(sel.row + 2, sel.rowCount);
  1973. for (let iRow = 0, iLen = qdSheet.getRowCount(); iRow < iLen; iRow++) {
  1974. qdSheet.getCell(iRow, 0, spreadNS.SheetArea.rowHeader).text('清单' + (iRow+1));
  1975. }
  1976. for (let iCol = 0, iLen = posSheet.getColumnCount() - 2; iCol < iLen; iCol++) {
  1977. posSheet.getCell(0, iCol + 2, spreadNS.SheetArea.colHeader).text('清单' + (iCol+1));
  1978. }
  1979. qdSheet.setSelection(sel.row, sel.col, 1, 1);
  1980. },
  1981. },
  1982. }
  1983. });
  1984. // 拉取签约清单数据
  1985. if (dealBills) {
  1986. SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
  1987. } else {
  1988. postData('/tender/' + getTenderId() + '/deal/get-data', {}, function (data) {
  1989. SpreadJsObj.loadSheetData(self.dealSpread.getActiveSheet(), 'data', data);
  1990. });
  1991. }
  1992. // 双击签约清单,自动添加到清单编号窗口
  1993. this.dealSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
  1994. const deal = info.sheet.zh_data[info.row];
  1995. const qdSheet = self.qdSpread.getActiveSheet(), posSheet = self.posSpread.getActiveSheet();
  1996. const sel = qdSheet.getSelections()[0];
  1997. qdSheet.getCell(sel.row, 0).value(deal.code);
  1998. qdSheet.getCell(sel.row, 1).value(deal.name);
  1999. qdSheet.getCell(sel.row, 2).value(deal.unit);
  2000. qdSheet.getCell(sel.row, 3).value(deal.unit_price);
  2001. if (sel.row + 1 === qdSheet.getRowCount()) {
  2002. const count = sel.row + 2;
  2003. qdSheet.setRowCount(count);
  2004. qdSheet.getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count);
  2005. const colCount = posSheet.getColumnCount() + 1
  2006. posSheet.setColumnCount(colCount);
  2007. posSheet.getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('数量' + count);
  2008. }
  2009. qdSheet.setSelection(sel.row + 1, sel.col, 1, 1);
  2010. });
  2011. this.obj.bind('shown.bs.modal', function () {
  2012. self.qdSpread.refresh();
  2013. self.posSpread.refresh();
  2014. self.dealSpread.refresh();
  2015. });
  2016. $('#batch-ok').click(function () {
  2017. const sheet = ledgerSpread.getActiveSheet();
  2018. const sel = sheet.getSelections()[0];
  2019. const row = sel.row;
  2020. const select = ledgerTree.nodes[row];
  2021. if (select) {
  2022. const insertData = {};
  2023. insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next';
  2024. insertData.id = ledgerTree.getNodeKey(select);
  2025. insertData.batchData = self.getBatchData();
  2026. if (insertData.batchData.length > 0) {
  2027. postData(window.location.pathname + '/update', {postType: 'batch-insert', postData: insertData}, function (data) {
  2028. pos.updateDatas(data.pos);
  2029. const result = ledgerTree.loadPostData(data.ledger);
  2030. treeOperationObj.refreshTree(sheet, result);
  2031. sheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
  2032. treeOperationObj.refreshOperationValid(sheet);
  2033. self.obj.modal('hide');
  2034. }, null, true);
  2035. } else {
  2036. self.obj.modal('hide');
  2037. }
  2038. }
  2039. });
  2040. }
  2041. // 初始化左侧表格
  2042. initView () {
  2043. // 初始化 清单编号
  2044. const qdSheet = this.qdSpread.getActiveSheet();
  2045. SpreadJsObj.initSheet(qdSheet, this.qdSpreadSetting);
  2046. SpreadJsObj.refreshColumnAlign(qdSheet);
  2047. // 清理原有数据
  2048. SpreadJsObj.beginMassOperation(qdSheet);
  2049. qdSheet.clear(0, 0, qdSheet.getRowCount(), qdSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  2050. for (let iRow = 1; iRow <= this.billsCount; iRow++) {
  2051. qdSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow);
  2052. }
  2053. qdSheet.setSelection(0, 0, 1 ,1);
  2054. SpreadJsObj.endMassOperation(qdSheet);
  2055. // 初始化 部位数量复核表
  2056. const posSheet = this.posSpread.getActiveSheet();
  2057. SpreadJsObj.initSheet(posSheet, this.posSpreadSetting);
  2058. SpreadJsObj.refreshColumnAlign(posSheet);
  2059. // 清理原有数据
  2060. SpreadJsObj.beginMassOperation(posSheet);
  2061. posSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader);
  2062. posSheet.clear(0, 0, posSheet.getRowCount(), posSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  2063. posSheet.setSelection(0, 0, 1 ,1);
  2064. SpreadJsObj.endMassOperation(posSheet);
  2065. // 检查签约清单数据,以工具栏数据为准
  2066. if (dealBills) {
  2067. SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
  2068. }
  2069. this.dealSpread.getActiveSheet().setSelection(0, 0, 1, 1);
  2070. }
  2071. // 获取界面数据
  2072. getBatchData () {
  2073. const result = [];
  2074. const qdSheet = this.qdSpread.getActiveSheet(), posSheet = this.posSpread.getActiveSheet();
  2075. for (let iRow = 0; iRow < qdSheet.getRowCount(); iRow++) {
  2076. if (qdSheet.getText(iRow, 0) === '') { continue; }
  2077. const qd = {
  2078. b_code: qdSheet.getText(iRow, 0),
  2079. name: qdSheet.getText(iRow, 1),
  2080. unit: qdSheet.getText(iRow, 2),
  2081. price: _.toNumber(qdSheet.getText(iRow, 3)),
  2082. pos: [],
  2083. };
  2084. result.push(qd);
  2085. for (let iPosRow = 0; iPosRow < posSheet.getRowCount(); iPosRow++) {
  2086. const value = _.toNumber(posSheet.getText(iPosRow, iRow + 2));
  2087. if (value !== 0 && !isNaN(value)) {
  2088. qd.pos.push({
  2089. name: posSheet.getText(iPosRow, 0),
  2090. drawing_code: posSheet.getText(iPosRow, 1),
  2091. quantity: value, porder: qd.pos.length + 1,
  2092. });
  2093. }
  2094. }
  2095. }
  2096. return result;
  2097. }
  2098. }
  2099. $('#searchAccount').click(() => {
  2100. const data = {
  2101. keyword: $('#searchName').val(),
  2102. };
  2103. postData('/search/user', data, (data) => {
  2104. const resultDiv = $('#searchResult');
  2105. if (data) {
  2106. $('h5>span', resultDiv).text(data.name);
  2107. $('#addAuditor').attr('auditorId', data.id);
  2108. $('h6', resultDiv).text(data.role);
  2109. $('p', resultDiv).text(data.company);
  2110. resultDiv.show();
  2111. } else {
  2112. toastr.info('未查询到该审核人');
  2113. resultDiv.hide();
  2114. }
  2115. }, () => {
  2116. $('#searchResult').hide();
  2117. });
  2118. });
  2119. // 审批人分组选择
  2120. $('#account_group').change(function () {
  2121. let account_html = '<option value="0">选择审批人</option>';
  2122. for (const account of accountList) {
  2123. if (parseInt($(this).val()) === 0 || parseInt($(this).val()) === account.account_group) {
  2124. const role = account.role !== '' ? '(' + account.role + ')' : '';
  2125. const company = account.company !== '' ? ' -' + account.company : '';
  2126. account_html += '<option value="' + account.id + '">' + account.name + role + company + '</option>';
  2127. }
  2128. }
  2129. $('#account_list').html(account_html);
  2130. });
  2131. // 添加到审批流程中
  2132. $('body').on('change', '#account_list', function () {
  2133. let id = $(this).val();
  2134. id = parseInt(id);
  2135. if (id !== 0) {
  2136. const data = {
  2137. auditorId: $(this).val(),
  2138. };
  2139. postData('/tender/' + getTenderId() + '/ledger/audit/add', data, (data) => {
  2140. const html = [];
  2141. html.push('<li class="list-group-item" auditorId="' + data.audit_id + '"><a href="javascript: void(0)" class="text-danger pull-right">移除</a>');
  2142. html.push('<span>');
  2143. html.push(data.audit_order + ' ');
  2144. html.push(data.name + ' ');
  2145. html.push('</span>');
  2146. html.push('<small class="text-muted">');
  2147. html.push(data.role);
  2148. html.push('</small></li>');
  2149. $('#auditors').append(html.join(''));
  2150. // 如果是重新上报,添加到重新上报列表中
  2151. const auditorshtml = [];
  2152. // 重新上报时。令其它的审批人流程图标转换
  2153. $('#auditors-list li i').removeClass('fa-stop-circle').addClass('fa-chevron-circle-down');
  2154. for (let i = 0; i < $('#auditors-list li').length; i++) {
  2155. $('#auditors-list li').eq(i).find('.pull-right').text(transFormToChinese(i+1) + '审');
  2156. $('#auditors-list2 li').eq(i).find('.pull-right').text(transFormToChinese(i+1) + '审');
  2157. }
  2158. // 添加新审批人
  2159. auditorshtml.push('<li class="list-group-item" data-auditid="' + data.audit_id + '">');
  2160. auditorshtml.push('<i class="fa fa-stop-circle"></i> ');
  2161. auditorshtml.push(data.name + ' <small class="text-muted">' + data.role + '</small>');
  2162. auditorshtml.push('<span class="pull-right">终审</span>');
  2163. auditorshtml.push('</li>');
  2164. $('#auditors-list').append(auditorshtml.join(''));
  2165. const auditorshtml2 = [];
  2166. // 重新上报时。令其它的审批人流程图标转换
  2167. $('#auditors-list2 li i').removeClass('fa-stop-circle').addClass('fa-chevron-circle-down');
  2168. // 添加新审批人
  2169. auditorshtml2.push('<li class="list-group-item" data-auditid="' + data.audit_id + '">');
  2170. auditorshtml2.push('<h5 class="card-title"><i class="fa fa-stop-circle"></i> ');
  2171. auditorshtml2.push(data.name + ' <small class="text-muted">' + data.role + '</small>');
  2172. auditorshtml2.push('<span class="pull-right">终审</span>');
  2173. auditorshtml2.push('</h5></li>');
  2174. $('#auditors-list2').append(auditorshtml2.join(''));
  2175. });
  2176. }
  2177. });
  2178. $('body').on('click', '#auditors li>a', function () {
  2179. const li = $(this).parent();
  2180. const data = {
  2181. auditorId: parseInt(li.attr('auditorId')),
  2182. };
  2183. postData('/tender/' + getTenderId() + '/ledger/audit/delete', data, (data2) => {
  2184. li.remove();
  2185. for (const a of data2) {
  2186. const aLi = $('li[auditorId=' + a.audit_id + ']');
  2187. $('span', aLi).text(a.audit_order + ' ' + a.name + ' ');
  2188. }
  2189. // 如果是重新上报
  2190. // 令最后一个图标转换
  2191. $('#auditors-list li[data-auditid="' + data.auditorId + '"]').remove();
  2192. if ($('#auditors-list li').length !== 0 && !$('#auditors-list li i').hasClass('fa-stop-circle')) {
  2193. $('#auditors-list li').eq($('#auditors-list li').length-1).children('i')
  2194. .removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
  2195. }
  2196. $('#auditors-list2 li[data-auditid="' + data.auditorId + '"]').remove();
  2197. if ($('#auditors-list2 li').length !== 0 && !$('#auditors-list2 li i').hasClass('fa-stop-circle')) {
  2198. $('#auditors-list2 li').eq($('#auditors-list2 li').length-1).children('i')
  2199. .removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
  2200. }
  2201. for (let i = 0; i < $('#auditors-list li').length; i++) {
  2202. $('#auditors-list li').eq(i).find('.pull-right').text((i+1 === $('#auditors-list li').length ? '终' : transFormToChinese(i+1)) + '审')
  2203. $('#auditors-list2 li').eq(i).find('.pull-right').text((i+1 === $('#auditors-list2 li').length ? '终' : transFormToChinese(i+1)) + '审')
  2204. }
  2205. });
  2206. });
  2207. $('#hideSp').click(function () {
  2208. $('#sp-list2').modal('hide');
  2209. });
  2210. // 显示层次
  2211. (function (select, sheet) {
  2212. $(select).click(function () {
  2213. const tag = $(this).attr('tag');
  2214. const tree = sheet.zh_tree;
  2215. if (!tree) return;
  2216. switch (tag) {
  2217. case "1":
  2218. case "2":
  2219. case "3":
  2220. case "4":
  2221. case "5":
  2222. tree.expandByLevel(parseInt(tag));
  2223. SpreadJsObj.refreshTreeRowVisible(sheet);
  2224. break;
  2225. case "last":
  2226. tree.expandByCustom(() => { return true; });
  2227. SpreadJsObj.refreshTreeRowVisible(sheet);
  2228. break;
  2229. case "leafXmj":
  2230. tree.expandToLeafXmj();
  2231. SpreadJsObj.refreshTreeRowVisible(sheet);
  2232. break;
  2233. }
  2234. });
  2235. })('a[name=showLevel]', ledgerSpread.getActiveSheet());
  2236. });
  2237. // 检查上报情况
  2238. function checkAuditorFrom () {
  2239. if ($('#auditors li').length === 0) {
  2240. toastr.error('请先选择审批人,再上报数据');
  2241. return false;
  2242. }
  2243. $('#hide-all').show();
  2244. }