ledger.js 151 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374237523762377237823792380238123822383238423852386238723882389239023912392239323942395239623972398239924002401240224032404240524062407240824092410241124122413241424152416241724182419242024212422242324242425242624272428242924302431243224332434243524362437243824392440244124422443244424452446244724482449245024512452245324542455245624572458245924602461246224632464246524662467246824692470247124722473247424752476247724782479248024812482248324842485248624872488248924902491249224932494249524962497249824992500250125022503250425052506250725082509251025112512251325142515251625172518251925202521252225232524252525262527252825292530253125322533253425352536253725382539254025412542254325442545254625472548254925502551255225532554255525562557255825592560256125622563256425652566256725682569257025712572257325742575257625772578257925802581258225832584258525862587258825892590259125922593259425952596259725982599260026012602260326042605260626072608260926102611261226132614261526162617261826192620262126222623262426252626262726282629263026312632263326342635263626372638263926402641264226432644264526462647264826492650265126522653265426552656265726582659266026612662266326642665266626672668266926702671267226732674267526762677267826792680268126822683268426852686268726882689269026912692269326942695269626972698269927002701270227032704270527062707270827092710271127122713271427152716271727182719272027212722272327242725272627272728272927302731273227332734273527362737273827392740274127422743274427452746274727482749275027512752275327542755275627572758275927602761276227632764276527662767276827692770277127722773277427752776277727782779278027812782278327842785278627872788278927902791279227932794279527962797279827992800280128022803280428052806280728082809281028112812281328142815281628172818281928202821282228232824282528262827282828292830283128322833283428352836283728382839284028412842284328442845284628472848284928502851285228532854285528562857285828592860286128622863286428652866286728682869287028712872287328742875287628772878287928802881288228832884288528862887288828892890289128922893289428952896289728982899290029012902290329042905290629072908290929102911291229132914291529162917291829192920292129222923292429252926292729282929293029312932293329342935293629372938293929402941294229432944294529462947294829492950295129522953295429552956295729582959296029612962296329642965296629672968296929702971297229732974297529762977297829792980298129822983298429852986298729882989299029912992299329942995299629972998299930003001300230033004300530063007300830093010301130123013301430153016301730183019302030213022302330243025302630273028302930303031303230333034303530363037303830393040304130423043304430453046304730483049305030513052305330543055305630573058305930603061306230633064306530663067306830693070307130723073307430753076307730783079308030813082308330843085308630873088308930903091309230933094309530963097309830993100310131023103310431053106310731083109311031113112311331143115311631173118311931203121312231233124312531263127312831293130313131323133313431353136313731383139314031413142314331443145314631473148314931503151315231533154315531563157315831593160316131623163316431653166316731683169317031713172317331743175317631773178317931803181318231833184318531863187318831893190319131923193319431953196319731983199320032013202320332043205320632073208320932103211321232133214321532163217321832193220322132223223322432253226322732283229323032313232323332343235323632373238323932403241324232433244324532463247324832493250325132523253325432553256325732583259326032613262326332643265326632673268326932703271
  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. posXmj: ['code'],
  22. };
  23. function getExprInfo (field) {
  24. const exprField = [
  25. {qty: 'sgfh_qty', expr: 'sgfh_expr'},
  26. {qty: 'sjcl_qty', expr: 'sjcl_expr'},
  27. {qty: 'qtcl_qty', expr: 'qtcl_expr'},
  28. ];
  29. return _.find(exprField, {qty: field});
  30. }
  31. function transExpr(expr) {
  32. return expr.replace('=', '').replace('%', '/100');
  33. }
  34. $(document).ready(function() {
  35. let stdXmj, stdGcl, dealBills, searchLedger;
  36. autoFlashHeight();
  37. // 初始化台账
  38. const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]);
  39. const treeSetting = {
  40. id: 'ledger_id',
  41. pid: 'ledger_pid',
  42. order: 'order',
  43. level: 'level',
  44. rootId: -1,
  45. keys: ['id', 'tender_id', 'ledger_id'],
  46. preUrl: '/tender/' + getTenderId() + '/ledger',
  47. //treeCacheKey: 'ledger_bills_fold' + '_' + getTenderId(),
  48. markFoldKey: 'bills-fold',
  49. markFoldSubKey: window.location.pathname.split('/')[2],
  50. };
  51. if (checkTzMeasureType()) {
  52. treeSetting.calcFields = ['sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'];
  53. } else {
  54. treeSetting.calcFields = ['deal_tp', 'sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'];
  55. }
  56. treeSetting.calcFun = function (node) {
  57. node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), 2);
  58. };
  59. const ledgerTree = createNewPathTree('ledger', treeSetting);
  60. // 初始化 计量单元
  61. const pos = new PosData({
  62. id: 'id', ledgerId: 'lid',
  63. });
  64. const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]);
  65. const errorList = $.cs_errorList({
  66. tabSelector: '#error-list-tab',
  67. selector: '#error-list',
  68. relaSpread: ledgerSpread,
  69. storeKey: 'ledger-error-' + getTenderId(),
  70. afterLocated: function () {
  71. posOperationObj.loadCurPosData();
  72. },
  73. afterShow: function () {
  74. ledgerSpread.refresh();
  75. if (posSpread) posSpread.refresh();
  76. },
  77. });
  78. const checkList = $.ledger_checkList({
  79. id: 'check-list',
  80. tabSelector: '#check-list-tab',
  81. selector: '#check-list',
  82. relaSpread: ledgerSpread,
  83. storeKey: 'ledger-check-' + getTenderId(),
  84. checkType: ledgerCheckType,
  85. afterLocated: function () {
  86. posOperationObj.loadCurPosData();
  87. },
  88. afterShow: function () {
  89. ledgerSpread.refresh();
  90. if (posSpread) posSpread.refresh();
  91. },
  92. });
  93. $.subMenu({
  94. menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
  95. toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
  96. key: 'menu.1.0.0',
  97. miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
  98. callback: function (info) {
  99. if (info.mini) {
  100. $('.panel-title').addClass('fluid');
  101. $('#sub-menu').removeClass('panel-sidebar');
  102. } else {
  103. $('.panel-title').removeClass('fluid');
  104. $('#sub-menu').addClass('panel-sidebar');
  105. }
  106. autoFlashHeight();
  107. ledgerSpread.refresh();
  108. if (posSpread) {
  109. posSpread.refresh();
  110. }
  111. if (stdXmj) {
  112. stdXmj.spread.refresh();
  113. }
  114. if (stdGcl) {
  115. stdGcl.spread.refresh();
  116. }
  117. if (dealBills) {
  118. dealBills.spread.refresh();
  119. }
  120. if (searchLedger) {
  121. searchLedger.spread.refresh();
  122. }
  123. if (errorList) {
  124. errorList.spread.refresh();
  125. }
  126. if (checkList) {
  127. checkList.spread.refresh();
  128. }
  129. }
  130. });
  131. // 定义事件
  132. const treeOperationObj = {
  133. loadExprToInput(sheet) {
  134. const sel = sheet.getSelections()[0];
  135. const col = sheet.zh_setting.cols[sel.col], cell = sheet.getCell(sel.row, sel.col);
  136. if (col && col.type === 'Number') {
  137. const data = SpreadJsObj.getSelectObject(sheet);
  138. if (data) {
  139. const exprInfo = getExprInfo(col.field);
  140. if (exprInfo) {
  141. $('#bills-expr').val(data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field])
  142. .attr('field', col.field).attr('org', data[col.field]);
  143. } else {
  144. $('#bills-expr').val(data[col.field])
  145. .attr('field', col.field).attr('org', data[col.field]);
  146. }
  147. if (col.field.indexOf('dgn') >= 0) {
  148. $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (_.isString(data.b_code) && data.b_code !== ''));
  149. } else {
  150. const nodePos = pos.getLedgerPos(data.id);
  151. if (nodePos && nodePos.length > 0) {
  152. $('#bills-expr').val('').attr('readOnly', true);
  153. $('#bills-expr').removeAttr('data-row');
  154. } else {
  155. $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (data.children && data.children.length > 0));
  156. }
  157. }
  158. $('#bills-expr').attr('data-row', sel.row);
  159. } else {
  160. $('#bills-expr').val('').attr('readOnly', true);
  161. $('#bills-expr').removeAttr('data-row');
  162. }
  163. } else {
  164. $('#bills-expr').val('').attr('readOnly', true);
  165. $('#bills-expr').removeAttr('data-row');
  166. }
  167. },
  168. getSelectNode: function (sheet) {
  169. if (!sheet || !sheet.zh_tree) {
  170. return null;
  171. } else {
  172. const sel = sheet.getSelections()[0];
  173. return sheet.zh_tree.nodes[sel.row];
  174. }
  175. },
  176. getDefaultSelectInfo: function (sheet) {
  177. const tree = sheet.zh_tree;
  178. if (!tree) return;
  179. const sel = sheet.getSelections()[0];
  180. const node = sheet.zh_tree.nodes[sel.row];
  181. if (!node) return;
  182. let count = 1;
  183. if (sel.rowCount > 1) {
  184. for (let r = 1; r < sel.rowCount; r++) {
  185. const rNode = sheet.zh_tree.nodes[sel.row + r];
  186. if (rNode.level > node.level) continue;
  187. if ((rNode.level < node.level) || (rNode.level === node.level && rNode.pid !== node.pid)) {
  188. toastr.error('请选择同一清单下的节点,进行该操作');
  189. return;
  190. }
  191. count += 1;
  192. }
  193. }
  194. return [tree, node, count];
  195. },
  196. /**
  197. * 刷新顶部按钮是否可用
  198. * @param sheet
  199. * @param selections
  200. */
  201. refreshOperationValid: function (sheet, selection) {
  202. const setObjEnable = function (obj, enable) {
  203. if (enable) {
  204. obj.removeClass('disabled');
  205. } else {
  206. obj.addClass('disabled');
  207. }
  208. };
  209. const invalidAll = function () {
  210. setObjEnable($('#insert'), false);
  211. setObjEnable($('#delete'), false);
  212. setObjEnable($('#up-move'), false);
  213. setObjEnable($('#down-move'), false);
  214. setObjEnable($('#up-level'), false);
  215. setObjEnable($('#down-level'), false);
  216. };
  217. const sel = selection ? selection[0] : sheet.getSelections()[0];
  218. const row = sel ? sel.row : -1;
  219. const tree = sheet.zh_tree;
  220. if (!tree) {
  221. invalidAll();
  222. return;
  223. }
  224. const first = sheet.zh_tree.nodes[row];
  225. if (!first) {
  226. invalidAll();
  227. return;
  228. }
  229. let last = first, sameParent = true;
  230. if (sel.rowCount > 1 && first) {
  231. for (let r = 1; r < sel.rowCount; r++) {
  232. const rNode = tree.nodes[row + r];
  233. if (!rNode) {
  234. sameParent = false;
  235. break;
  236. }
  237. if (rNode.level > first.level) continue;
  238. if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
  239. sameParent = false;
  240. break;
  241. }
  242. last = rNode;
  243. }
  244. }
  245. const preNode = tree.getPreSiblingNode(first);
  246. const valid = !sheet.zh_setting.readOnly;
  247. setObjEnable($('#insert'), valid && first && first.level > 1);
  248. setObjEnable($('#delete'), valid && first && sameParent && !(first.level === 1 && first.node_type));
  249. setObjEnable($('#up-move'), valid && first && sameParent && first.level > 1 && preNode);
  250. setObjEnable($('#down-move'), valid && first && sameParent && first.level > 1 && !tree.isLastSibling(last));
  251. if (checkTzMeasureType()) {
  252. const posRange = last ? pos.getLedgerPos(last.id) : [];
  253. setObjEnable($('#up-level'), valid && first && sameParent && tree.getParent(first) && first.level > 2 && ((!posRange || posRange.length === 0) || tree.isLastSibling(last)));
  254. const preNodePosRange = preNode ? pos.getLedgerPos(preNode.id) : [];
  255. setObjEnable($('#down-level'), valid && first && sameParent && first.level > 1 && preNode && (!preNodePosRange || preNodePosRange.length === 0));
  256. } else {
  257. setObjEnable($('#up-level'), valid && first && sameParent && first.level > 2 && tree.getParent(first));
  258. setObjEnable($('#down-level'), valid && first && sameParent && first.level > 1 && preNode);
  259. }
  260. setObjEnable($('#cut'), valid);
  261. setObjEnable($('#paste'), valid);
  262. },
  263. refreshTree: function (sheet, data) {
  264. SpreadJsObj.massOperationSheet(sheet, function () {
  265. const tree = sheet.zh_tree;
  266. // 处理删除
  267. if (data.delete) {
  268. data.delete.sort(function (x, y) {
  269. return y.deleteIndex - x.deleteIndex;
  270. });
  271. for (const d of data.delete) {
  272. sheet.deleteRows(d.deleteIndex, 1);
  273. }
  274. }
  275. // 处理新增
  276. if (data.create) {
  277. const newNodes = data.create;
  278. if (newNodes) {
  279. newNodes.sort(function (a, b) {
  280. return a.index - b.index;
  281. });
  282. for (const node of newNodes) {
  283. sheet.addRows(node.index, 1);
  284. SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(node), 1);
  285. }
  286. }
  287. }
  288. // 处理更新
  289. if (data.update) {
  290. const rows = [];
  291. for (const u of data.update) {
  292. rows.push(tree.nodes.indexOf(u));
  293. }
  294. SpreadJsObj.reLoadRowsData(sheet, rows);
  295. }
  296. // 处理展开
  297. if (data.expand) {
  298. const expanded = [];
  299. for (const e of data.expand) {
  300. if (expanded.indexOf(e) === -1) {
  301. const posterity = tree.getPosterity(e);
  302. for (const p of posterity) {
  303. sheet.setRowVisible(tree.nodes.indexOf(p), p.visible);
  304. expanded.push(p);
  305. }
  306. }
  307. }
  308. }
  309. });
  310. },
  311. /**
  312. * 新增节点
  313. * @param spread
  314. */
  315. addNode: function (sheet, count = 1) {
  316. const self = this;
  317. const sel = sheet.getSelections()[0];
  318. const row = sheet.getSelections()[0].row;
  319. const tree = sheet.zh_tree;
  320. if (!tree) { return; }
  321. const node = sheet.zh_tree.nodes[row];
  322. if (!node) { return; }
  323. postData(window.location.pathname + '/update', {
  324. postType: 'add',
  325. postData: {
  326. id: tree.getNodeKey(node),
  327. count: count,
  328. }
  329. }, function (result) {
  330. const refreshNode = tree.loadPostData(result);
  331. self.refreshTree(sheet, refreshNode);
  332. sheet.setSelection(refreshNode.create[0].index, sel.col, sel.rowCount, sel.colCount);
  333. SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, refreshNode.create[0].index]);
  334. self.refreshOperationValid(sheet);
  335. });
  336. },
  337. /**
  338. * 删除选中节点
  339. * @param spread
  340. */
  341. deleteNode: function (sheet) {
  342. const self = this;
  343. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  344. if (tree && node && count) {
  345. const data = {
  346. postType: 'delete',
  347. postData: {
  348. id: tree.getNodeKey(node),
  349. count: count
  350. }
  351. };
  352. deleteAfterHint(function () {
  353. postData(window.location.pathname + '/update', data, function (result) {
  354. const refreshNode = tree.loadPostData(result);
  355. for (const d of refreshNode.delete) pos.removeDatasByMasterId(d.id);
  356. self.refreshTree(sheet, refreshNode);
  357. self.refreshOperationValid(sheet);
  358. posOperationObj.loadCurPosData();
  359. });
  360. });
  361. }
  362. },
  363. /**
  364. * 上移选中节点
  365. * @param spread
  366. */
  367. upMove: function (sheet) {
  368. const self = this;
  369. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  370. if (tree && node && count) {
  371. const data = {
  372. postType: 'up-move',
  373. postData: {
  374. id: tree.getNodeKey(node),
  375. count: count
  376. }
  377. };
  378. postData(window.location.pathname + '/update', data, function (result) {
  379. const refreshNode = tree.loadPostData(result);
  380. self.refreshTree(sheet, refreshNode);
  381. const sel = sheet.getSelections()[0];
  382. sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  383. SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(node)]);
  384. self.refreshOperationValid(sheet);
  385. });
  386. }
  387. },
  388. /**
  389. * 下移选中节点
  390. * @param spread
  391. */
  392. downMove: function (sheet) {
  393. const self = this;
  394. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  395. if (tree && node && count) {
  396. const data = {
  397. postType: 'down-move',
  398. postData: {
  399. id: tree.getNodeKey(node),
  400. count: count
  401. }
  402. };
  403. postData(window.location.pathname + '/update', data, function (result) {
  404. const refreshNode = tree.loadPostData(result);
  405. self.refreshTree(sheet, refreshNode);
  406. const sel = sheet.getSelections()[0];
  407. sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  408. SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(node)]);
  409. self.refreshOperationValid(sheet);
  410. });
  411. }
  412. },
  413. /**
  414. * 升级选中节点
  415. * @param spread
  416. */
  417. upLevel: function (sheet) {
  418. const self = this;
  419. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  420. if (tree && node && count) {
  421. const data = {
  422. postType: 'up-level',
  423. postData: {
  424. id: tree.getNodeKey(node),
  425. count: count
  426. }
  427. };
  428. postData(window.location.pathname + '/update', data, function (result) {
  429. const refreshNode = tree.loadPostData(result);
  430. self.refreshTree(sheet, refreshNode);
  431. self.refreshOperationValid(sheet);
  432. });
  433. }
  434. },
  435. /**
  436. * 降级选中节点
  437. * @param spread
  438. */
  439. downLevel: function (sheet) {
  440. const self = this;
  441. const [tree, node, count] = this.getDefaultSelectInfo(sheet);
  442. if (tree && node && count) {
  443. const data = {
  444. postType: 'down-level',
  445. postData: {
  446. id: tree.getNodeKey(node),
  447. count: count
  448. }
  449. };
  450. postData(window.location.pathname + '/update', data, function (result) {
  451. const refreshNode = tree.loadPostData(result);
  452. self.refreshTree(sheet, refreshNode);
  453. self.refreshOperationValid(sheet);
  454. });
  455. }
  456. },
  457. /**
  458. * 编辑单元格响应事件
  459. * @param {Object} e
  460. * @param {Object} info
  461. */
  462. editEnded: function (e, info) {
  463. if (info.sheet.zh_setting) {
  464. const col = info.sheet.zh_setting.cols[info.col];
  465. const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
  466. const node = sortData[info.row];
  467. const data = {
  468. id: node.id,
  469. tender_id: node.tender_id,
  470. ledger_id: node.ledger_id
  471. };
  472. // 未改变值则不提交
  473. const orgValue = node[col.field];
  474. const newValue = trimInvalidChar(info.editingText);
  475. if (orgValue == info.editingText || ((!orgValue || orgValue === '') && (newValue === ''))) {
  476. return;
  477. }
  478. // 台账模式,检查计量单元相关
  479. if (checkTzMeasureType()) {
  480. if (col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
  481. col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
  482. col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
  483. if (!node.children || node.children.length ===0) {
  484. const lPos = pos.getLedgerPos(node.id);
  485. if (lPos && lPos.length > 0) {
  486. toastr.error('清单含有计量单元,请在计量单元输入数量');
  487. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  488. return;
  489. }
  490. }
  491. }
  492. if (col.field === 'b_code' && (info.editingText === '' || !info.editingText)) {
  493. const lPos = pos.getLedgerPos(node.id);
  494. if (lPos && lPos.length > 0) {
  495. toastr.error('清单含有计量单元,请先删除计量单元,再删除清单编号');
  496. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  497. return;
  498. }
  499. }
  500. }
  501. // 获取更新数据
  502. if (col.type === 'Number') {
  503. const exprInfo = getExprInfo(col.field);
  504. if (newValue) {
  505. const num = _.toNumber(newValue);
  506. if (_.isFinite(num)) {
  507. data[col.field] = num;
  508. } else {
  509. try {
  510. data[col.field] = math.evaluate(transExpr(newValue));
  511. if (exprInfo) {
  512. data[exprInfo.expr] = newValue;
  513. }
  514. } catch(err) {
  515. toastr.error('输入的表达式非法');
  516. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  517. return;
  518. }
  519. }
  520. } else {
  521. data[col.field] = null;
  522. if (exprInfo) {
  523. data[exprInfo.expr] = '';
  524. }
  525. }
  526. } else {
  527. data[col.field] = newValue;
  528. }
  529. // 更新至服务器
  530. postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
  531. const refreshNode = ledgerTree.loadPostData(result);
  532. treeOperationObj.refreshTree(info.sheet, refreshNode);
  533. });
  534. }
  535. },
  536. /**
  537. * 粘贴单元格响应事件
  538. * @param e
  539. * @param info
  540. */
  541. clipboardPasted: function (e, info) {
  542. if (info.sheet.zh_setting && info.sheet.zh_dataType === 'tree') {
  543. const tree = info.sheet.zh_tree;
  544. if (!tree) { return; }
  545. const sortData = info.sheet.zh_tree.nodes;
  546. const datas = [], filterNodes = [];
  547. let bHint = false, bPaste;
  548. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
  549. bPaste = false;
  550. const curRow = info.cellRange.row + iRow;
  551. const node = sortData[curRow];
  552. if (node) {
  553. const data = info.sheet.zh_tree.getNodeKeyData(node);
  554. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  555. const curCol = info.cellRange.col + iCol;
  556. const colSetting = info.sheet.zh_setting.cols[curCol];
  557. const value = trimInvalidChar(info.sheet.getText(curRow, curCol));
  558. const lPos = pos.getLedgerPos(node.id);
  559. if (lPos && lPos.length > 0) {
  560. if (value === '' && colSetting.field === 'b_code') {
  561. if (!bHint) {
  562. toastr.warning('清单含有计量单元,请先删除计量单元,再删除清单编号');
  563. bHint = true;
  564. }
  565. continue;
  566. }
  567. if (colSetting.field === 'sgfh_qty' || colSetting.field === 'sgfh_tp' ||
  568. colSetting.field === 'sjcl_qty' || colSetting.field === 'sjcl_tp' ||
  569. colSetting.field === 'qtcl_qty' || colSetting.field === 'qtcl_tp') {
  570. if (!bHint) {
  571. toastr.warning('清单含有计量单元,数量金额根据计量单元汇总计算所得,不可编辑');
  572. bHint = true;
  573. }
  574. continue;
  575. }
  576. }
  577. if (colSetting.type === 'Number') {
  578. const num = _.toNumber(value);
  579. if (num) {
  580. data[colSetting.field] = num;
  581. bPaste = true;
  582. } else {
  583. try {
  584. data[colSetting.field] = math.evaluate(transExpr(value));
  585. bPaste = true;
  586. } catch(err) {
  587. delete data[colSetting.field];
  588. if (!bHint) {
  589. toastr.warning('输入的表达式非法');
  590. bHint = true;
  591. }
  592. }
  593. }
  594. } else {
  595. data[colSetting.field] = value;
  596. bPaste = true;
  597. }
  598. }
  599. if (bPaste) {
  600. datas.push(data);
  601. } else {
  602. filterNodes.push(node);
  603. }
  604. }
  605. }
  606. if (datas.length > 0) {
  607. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  608. const refreshNode = tree.loadPostData(result);
  609. if (refreshNode.update) {
  610. refreshNode.update = refreshNode.update.concat(filterNodes);
  611. }
  612. treeOperationObj.refreshTree(info.sheet, refreshNode);
  613. }, function () {
  614. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  615. });
  616. } else {
  617. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  618. }
  619. }
  620. },
  621. clipboardPasting: function (e, info) {
  622. const tree = info.sheet.zh_tree, setting = info.sheet.zh_setting;
  623. info.cancel = true;
  624. if (!setting || !tree) return;
  625. const pasteData = info.pasteData.html
  626. ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
  627. : (info.pasteData.text === ''
  628. ? SpreadJsObj.Clipboard.getAnalysisPasteText()
  629. : SpreadJsObj.analysisPasteText(info.pasteData.text));
  630. const hint = {
  631. invalidExpr: {type: 'warning', msg: '粘贴的表达式非法'},
  632. posCode: {type: 'warning', msg: '清单含有计量单元,不可粘贴清单编号为空'},
  633. posQty: {type: 'warning', msg: '清单含有计量单元,数量金额根据计量单元汇总计算所得,不可粘贴'},
  634. parent: {type: 'warning', msg: '含有子项的清单,不可粘贴数量、单价、金额'},
  635. gcl: {type: 'warning', msg: '工程量清单,不可粘贴项目节数量'},
  636. posXmj: {type: 'warning', msg: '清单含有计量单元,不可粘贴项目节编号'},
  637. sameParent: {type: 'warning', msg: '仅可粘贴同层节点'},
  638. };
  639. const datas = [], filterNodes = [];
  640. let pid, level, filterRow = 0;
  641. for (let iRow = 0; iRow < info.cellRange.rowCount + filterRow; iRow++) {
  642. const curRow = info.cellRange.row + iRow;
  643. const node = tree.nodes[curRow];
  644. if (!node) continue;
  645. if (!pid) pid = node.ledger_pid;
  646. if (!level) level = node.level;
  647. if (node.ledger_pid !== pid) {
  648. toastMessageUniq(hint.sameParent);
  649. filterRow+=1;
  650. continue;
  651. }
  652. if (node.level < level) break;
  653. let bPaste = false;
  654. const data = info.sheet.zh_tree.getNodeKeyData(node);
  655. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  656. const curCol = info.cellRange.col + iCol;
  657. const colSetting = info.sheet.zh_setting.cols[curCol];
  658. const value = trimInvalidChar(pasteData[iRow-filterRow][iCol]);
  659. const lPos = pos.getLedgerPos(node.id);
  660. if (node.children && node.children.length > 0 && invalidFields.parent.indexOf(colSetting.field) >= 0) {
  661. toastMessageUniq(hint.parent);
  662. continue;
  663. }
  664. if (!_.isEmpty(node.b_code) && invalidFields.gcl.indexOf(colSetting.field) >= 0) {
  665. toastMessageUniq(hint.gcl);
  666. continue;
  667. }
  668. if (lPos && lPos.length > 0) {
  669. if (value === '' && invalidFields.posCode.indexOf(colSetting.field) >= 0) {
  670. toastMessageUniq(hint.posCode);
  671. continue;
  672. }
  673. if (invalidFields.posCalc.indexOf(colSetting.field) >= 0) {
  674. toastMessageUniq(hint.posQty);
  675. continue;
  676. }
  677. if (value !== '' && invalidFields.posXmj.indexOf(colSetting.field) >= 0) {
  678. toastMessageUniq(hint.posXmj);
  679. continue;
  680. }
  681. }
  682. if (colSetting.type === 'Number') {
  683. const num = _.toNumber(value);
  684. if (num) {
  685. data[colSetting.field] = num;
  686. bPaste = true;
  687. } else {
  688. try {
  689. data[colSetting.field] = math.evaluate(transExpr(value));
  690. const exprInfo = getExprInfo(colSetting.field);
  691. if (exprInfo) {
  692. data[exprInfo.expr] = value;
  693. bPaste = true;
  694. }
  695. } catch(err) {
  696. toastMessageUniq(hint.invalidExpr);
  697. }
  698. }
  699. } else {
  700. data[colSetting.field] = value;
  701. bPaste = true;
  702. }
  703. }
  704. if (bPaste) {
  705. datas.push(data);
  706. } else {
  707. filterNodes.push(node);
  708. }
  709. }
  710. if (datas.length > 0) {
  711. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  712. const refreshNode = tree.loadPostData(result);
  713. if (refreshNode.update) {
  714. refreshNode.update = refreshNode.update.concat(filterNodes);
  715. }
  716. treeOperationObj.refreshTree(info.sheet, refreshNode);
  717. }, function () {
  718. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  719. });
  720. } else {
  721. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  722. }
  723. },
  724. /**
  725. * 删除按钮响应事件
  726. * @param sheet
  727. */
  728. deletePress: function (sheet) {
  729. if (sheet.zh_setting && sheet.zh_dataType === 'tree') {
  730. const tree = sheet.zh_tree;
  731. if (!tree) { return; }
  732. const sortData = sheet.zh_tree.nodes;
  733. const datas = [], nodes = [];
  734. const sel = sheet.getSelections()[0];
  735. let bHint = false;
  736. for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
  737. const node = sortData[iRow];
  738. if (node) {
  739. let bDel = false;
  740. const data = sheet.zh_tree.getNodeKeyData(node);
  741. for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
  742. const col = sheet.zh_setting.cols[iCol];
  743. if (col.field === 'b_code' || col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
  744. col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
  745. col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
  746. const lPos = pos.getLedgerPos(node.id);
  747. if (lPos && lPos.length > 0) {
  748. if (!bHint) {
  749. if (col.field === 'code') {
  750. toastr.warning('清单含有计量单元,请先删除计量单元,再删除清单编号');
  751. } else {
  752. toastr.warning('清单含有计量单元,数量金额根据计量单元汇总计算所得,不可删除');
  753. }
  754. bHint = true;
  755. }
  756. continue;
  757. }
  758. }
  759. const style = sheet.getStyle(iRow, iCol);
  760. if (!style.locked) {
  761. const colSetting = sheet.zh_setting.cols[iCol];
  762. data[colSetting.field] = null;
  763. const exprInfo = getExprInfo(colSetting.field);
  764. if (exprInfo) {
  765. data[exprInfo.expr] = '';
  766. }
  767. bDel = true;
  768. }
  769. }
  770. if (bDel) {
  771. datas.push(data);
  772. nodes.push(node);
  773. }
  774. }
  775. }
  776. if (datas.length > 0) {
  777. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  778. const refreshNode = tree.loadPostData(result);
  779. treeOperationObj.refreshTree(sheet, refreshNode);
  780. treeOperationObj.loadExprToInput(sheet);
  781. });
  782. }
  783. }
  784. },
  785. /**
  786. * 粘贴整块
  787. * @param spread
  788. * @param block
  789. */
  790. pasteBlock: function (spread, copyInfo) {
  791. const self = this;
  792. const sheet = spread.getActiveSheet();
  793. const sel = sheet.getSelections()[0];
  794. const row = sel.row;
  795. const tree = sheet.zh_tree;
  796. if (!tree) { return; }
  797. const node = tree.nodes[row];
  798. if (!node) { return; }
  799. postData(window.location.pathname + '/update', {
  800. postType: 'paste-block',
  801. postData: {
  802. id: tree.getNodeKey(node),
  803. tid: copyInfo.tid,
  804. block: copyInfo.block,
  805. }
  806. }, function (data) {
  807. pos.updateDatas(data.pos);
  808. const result = tree.loadPostData(data.ledger);
  809. self.refreshTree(sheet, result);
  810. sheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
  811. SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, result.create[0].index]);
  812. self.refreshOperationValid(sheet);
  813. removeLocalCache(copyBlockTag);
  814. }, null, true);
  815. },
  816. selectionChanged: function (e, info) {
  817. if (!info.oldSelections || !info.oldSelections[0] || info.newSelections[0].row !== info.oldSelections[0].row) {
  818. SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
  819. posOperationObj.loadCurPosData();
  820. posSearch.search($('#pos-keyword').val());
  821. }
  822. SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
  823. treeOperationObj.loadExprToInput(info.sheet);
  824. },
  825. topRowChanged(e, info) {
  826. SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
  827. },
  828. cut: function (sheet, sel, callback) {
  829. if (!sheet || !sel) return;
  830. if (sel.colCount >= sheet.zh_setting.cols.length) {
  831. toastr.warning('请勿选中整行剪切');
  832. return;
  833. }
  834. const sortData = SpreadJsObj.getSortData(sheet), datas = [];
  835. for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
  836. const node = sortData[iRow];
  837. if (node) {
  838. const data = sheet.zh_tree.getNodeKeyData(node);
  839. for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
  840. const col = sheet.zh_setting.cols[iCol];
  841. if (col.field === 'b_code' || col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
  842. col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
  843. col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
  844. const lPos = pos.getLedgerPos(node.id);
  845. if (lPos && lPos.length > 0) {
  846. toastr.error('不可剪切');
  847. return;
  848. }
  849. }
  850. const style = sheet.getStyle(iRow, iCol);
  851. if (style.locked) {
  852. toastr.error('不可剪切');
  853. return;
  854. }
  855. const colSetting = sheet.zh_setting.cols[iCol];
  856. data[colSetting.field] = null;
  857. const exprInfo = getExprInfo(colSetting.field);
  858. if (exprInfo) {
  859. data[exprInfo.expr] = '';
  860. }
  861. }
  862. datas.push(data);
  863. }
  864. }
  865. if (datas.length > 0) {
  866. callback();
  867. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  868. const refreshNode = sheet.zh_tree.loadPostData(result);
  869. treeOperationObj.refreshTree(sheet, refreshNode);
  870. });
  871. }
  872. },
  873. editStarting(e, info) {
  874. if (!info.sheet.zh_setting || !info.sheet.zh_tree) return;
  875. const col = info.sheet.zh_setting.cols[info.col];
  876. const node = info.sheet.zh_tree.nodes[info.row];
  877. if (!node) {
  878. info.cancel = true;
  879. return;
  880. }
  881. const exprInfo = getExprInfo(col.field);
  882. if (exprInfo) {
  883. if (node[exprInfo.expr] && node[exprInfo.expr] !== '') {
  884. info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]);
  885. }
  886. }
  887. switch (col.field) {
  888. case 'code':
  889. const posRange = pos.getLedgerPos(node.id);
  890. info.cancel = posRange && posRange.length > 0;
  891. break;
  892. case 'unit_price':
  893. case 'sgfh_qty':
  894. case 'sgfh_tp':
  895. case 'sjcl_qty':
  896. case 'sjcl_tp':
  897. case 'qtcl_qty':
  898. case 'qtcl_tp':
  899. case 'deal_qty':
  900. case 'deal_tp':
  901. info.cancel = node.children && node.children.length > 0;
  902. break;
  903. case 'dgn_qty1':
  904. case 'dgn_qty2':
  905. info.cancel = !_.isEmpty(node.b_code);
  906. break;
  907. }
  908. },
  909. sortCode: function (sheet) {
  910. const tree = sheet.zh_tree;
  911. if (!tree) return;
  912. const select = SpreadJsObj.getSelectObject(sheet);
  913. if (!select || !select.code) return;
  914. const recursiveSortCode = function (data, parentCode, children) {
  915. if (!children || children.length === 0) return;
  916. for (const [i, child] of children.entries()) {
  917. if (!child.b_code || child.b_code === '') {
  918. const code = parentCode + '-' + (i + 1);
  919. const cData = tree.getNodeKeyData(child);
  920. cData.code = code;
  921. data.push(cData);
  922. if (!tree.isLeafXmj(child)) {
  923. recursiveSortCode(data, code, child.children);
  924. }
  925. }
  926. }
  927. };
  928. const data = [];
  929. recursiveSortCode(data, select.code, select.children);
  930. if (data.length > 0) {
  931. postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
  932. const refreshNode = tree.loadPostData(result);
  933. treeOperationObj.refreshTree(sheet, refreshNode);
  934. })
  935. }
  936. },
  937. };
  938. sjsSettingObj.setFxTreeStyle(ledgerSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
  939. if (thousandth) sjsSettingObj.setTpThousandthFormat(ledgerSpreadSetting);
  940. ledgerTreeCol.initSpreadSetting(ledgerSpreadSetting);
  941. // ledgerSpreadSetting.cols.push(
  942. // {title: 'ledger_id', colSpan: '1', rowSpan: '2', field: 'ledger_id', hAlign: 2, width: 60, type: 'Number', readOnly: true},
  943. // {title: 'ledger_pid', colSpan: '1', rowSpan: '2', field: 'ledger_pid', hAlign: 2, width: 60, type: 'Number', readOnly: true},
  944. // {title: 'level', colSpan: '1', rowSpan: '2', field: 'level', hAlign: 2, width: 60, type: 'Number', readOnly: true},
  945. // {title: 'order', colSpan: '1', rowSpan: '2', field: 'order', hAlign: 2, width: 60, type: 'Number', readOnly: true},
  946. // {title: 'is_leaf', colSpan: '1', rowSpan: '2', field: 'is_leaf', hAlign: 2, width: 60, type: 'Number', readOnly: true},
  947. // {title: 'full_path', colSpan: '1', rowSpan: '2', field: 'full_path', hAlign: 2, width: 60, type: 'Number', readOnly: true},
  948. // {title: 'node_type', colSpan: '1', rowSpan: '2', field: 'node_type', hAlign: 2, width: 60, type: 'Number', readOnly: true}
  949. // );
  950. SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);
  951. SpreadJsObj.selChangedRefreshBackColor(ledgerSpread.getActiveSheet());
  952. // 绑定事件
  953. ledgerSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, treeOperationObj.selectionChanged);
  954. ledgerSpread.bind(spreadNS.Events.TopRowChanged, treeOperationObj.topRowChanged);
  955. if (!ledgerSpreadSetting.readOnly) {
  956. ledgerSpread.bind(GC.Spread.Sheets.Events.SelectionChanged, function (e, info) {
  957. treeOperationObj.refreshOperationValid(info.sheet, info.newSelections);
  958. });
  959. ledgerSpread.bind(GC.Spread.Sheets.Events.EditEnded, treeOperationObj.editEnded);
  960. SpreadJsObj.addDeleteBind(ledgerSpread, treeOperationObj.deletePress);
  961. ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardChanging, function (e, info) {
  962. const copyText = SpreadJsObj.getFilterCopyText(info.sheet);
  963. SpreadJsObj.Clipboard.setCopyData(copyText);
  964. });
  965. ledgerSpread.bind(GC.Spread.Sheets.Events.ClipboardPasting, treeOperationObj.clipboardPasting);
  966. ledgerSpread.bind(spreadNS.Events.EditStarting, treeOperationObj.editStarting);
  967. SpreadJsObj.addCutEvents(ledgerSpread, treeOperationObj.cut);
  968. // 绑定 删除等 顶部按钮
  969. $('#insert').click(() => {
  970. treeOperationObj.addNode(ledgerSpread.getActiveSheet());
  971. });
  972. $('#delete').click(function () {
  973. treeOperationObj.deleteNode(ledgerSpread.getActiveSheet());
  974. });
  975. $('#up-move').click(function () {
  976. treeOperationObj.upMove(ledgerSpread.getActiveSheet());
  977. });
  978. $('#down-move').click(function () {
  979. treeOperationObj.downMove(ledgerSpread.getActiveSheet());
  980. });
  981. $('#up-level').click(function () {
  982. treeOperationObj.upLevel(ledgerSpread.getActiveSheet());
  983. });
  984. $('#down-level').click(function () {
  985. treeOperationObj.downLevel(ledgerSpread.getActiveSheet());
  986. });
  987. $('#copy').click(function () {
  988. ledgerSpread.commandManager().execute({
  989. cmd: 'copy',
  990. sheetName: ledgerSpread.getActiveSheet().name()
  991. });
  992. });
  993. $('#paste').click(function () {
  994. ledgerSpread.commandManager().execute({
  995. cmd: 'paste',
  996. sheetName: ledgerSpread.getActiveSheet().name()
  997. });
  998. });
  999. $('#cut').click(function () {
  1000. ledgerSpread.commandManager().execute({
  1001. cmd: 'cut',
  1002. sheetName: ledgerSpread.getActiveSheet().name()
  1003. });
  1004. });
  1005. $('#bills-expr').bind('change onblur', function () {
  1006. const expr = $(this);
  1007. const row = expr.attr('data-row') ? _.toInteger(expr.attr('data-row')) : -1;
  1008. const select = ledgerTree.getItemsByIndex(row);
  1009. if (!select) return;
  1010. const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = trimInvalidChar(expr.val());
  1011. if (orgValue === newValue || (!orgValue && newValue == '')) { return; }
  1012. // 台账模式,检查计量单元相关
  1013. if (checkTzMeasureType()) {
  1014. if (field === 'sgfh_qty' || field === 'sgfh_tp' ||
  1015. field === 'sjcl_qty' || field === 'sjcl_tp' ||
  1016. field === 'qtcl_qty' || field === 'qtcl_tp') {
  1017. if (!select.children || select.children.length === 0) {
  1018. const lPos = pos.getLedgerPos(select.id);
  1019. if (lPos && lPos.length > 0) {
  1020. toastr.error('清单含有计量单元,请在计量单元输入数量');
  1021. expr.val('');
  1022. return;
  1023. }
  1024. }
  1025. }
  1026. }
  1027. const data = {
  1028. id: select.id,
  1029. tender_id: select.tender_id,
  1030. ledger_id: select.ledger_id
  1031. };
  1032. const exprInfo = getExprInfo(field);
  1033. if (newValue !== '') {
  1034. const num = _.toNumber(newValue);
  1035. if (num) {
  1036. data[field] = num;
  1037. if (exprInfo) {
  1038. data[exprInfo.expr] = '';
  1039. }
  1040. } else {
  1041. try {
  1042. data[field] = math.evaluate(transExpr(newValue));
  1043. if (exprInfo) {
  1044. data[exprInfo.expr] = newValue;
  1045. }
  1046. } catch (err) {
  1047. toastr.error('输入的表达式非法');
  1048. return;
  1049. }
  1050. }
  1051. } else {
  1052. data[field] = null;
  1053. if (exprInfo) {
  1054. data[exprInfo.expr] = '';
  1055. }
  1056. }
  1057. // 更新至服务器
  1058. postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
  1059. const refreshNode = ledgerTree.loadPostData(result);
  1060. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), refreshNode);
  1061. });
  1062. });
  1063. }
  1064. let batchInsertObj;
  1065. $.contextMenu.types.batchInsert = function (item, opt, root) {
  1066. const self = this;
  1067. if ($.isFunction(item.icon)) {
  1068. item._icon = item.icon.call(this, this, $t, key, item);
  1069. } else {
  1070. if (typeof(item.icon) === 'string' && item.icon.substring(0, 3) === 'fa-') {
  1071. // to enable font awesome
  1072. item._icon = root.classNames.icon + ' ' + root.classNames.icon + '--fa fa ' + item.icon;
  1073. } else {
  1074. item._icon = root.classNames.icon + ' ' + root.classNames.icon + '-' + item.icon;
  1075. }
  1076. }
  1077. this.addClass(item._icon);
  1078. const $obj = $('<div>' + item.name + '<input class="text-right ml-1 mr-1" type="tel" max="100" min="1" value="' + item.value + '" style="width: 30px; height: 18px; padding-right: 4px;">行</div>')
  1079. .appendTo(this);
  1080. const $input = $obj.find('input');
  1081. const event = () => {
  1082. if (self.hasClass('context-menu-disabled')) return;
  1083. item.batchInsert($input[0], root);
  1084. };
  1085. $obj.on('click', event).keypress(function (e) {if (e.keyCode === 13) { event(); }});
  1086. $input.click((e) => {e.stopPropagation();})
  1087. .keyup((e) => {if (e.keyCode === 13) item.batchInsert($input[0], root);})
  1088. .on('input', function () {this.value = this.value.replace(/[^\d]/g, '');});
  1089. };
  1090. // 右键菜单
  1091. const billsContextMenuOptions = {
  1092. selector: '#ledger-spread',
  1093. build: function ($trigger, e) {
  1094. const target = SpreadJsObj.safeRightClickSelection($trigger, e, ledgerSpread);
  1095. return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
  1096. },
  1097. items: {},
  1098. };
  1099. if (!readOnly) {
  1100. billsContextMenuOptions.items.create = {
  1101. name: '新增',
  1102. icon: 'fa-sign-in',
  1103. callback: function (key, opt) {
  1104. treeOperationObj.addNode(ledgerSpread.getActiveSheet());
  1105. },
  1106. disabled: function (key, opt) {
  1107. const sheet = ledgerSpread.getActiveSheet();
  1108. const selection = sheet.getSelections();
  1109. const sel = selection ? selection[0] : sheet.getSelections()[0];
  1110. const row = sel ? sel.row : -1;
  1111. const tree = sheet.zh_tree;
  1112. if (!tree) return true;
  1113. const first = sheet.zh_tree.nodes[row];
  1114. let last = first, sameParent = true;
  1115. if (sel.rowCount > 1) {
  1116. for (let r = 1; r < sel.rowCount; r++) {
  1117. const rNode = tree.nodes[sel.row + r];
  1118. if (rNode.level > first.level) continue;
  1119. if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
  1120. sameParent = false;
  1121. break;
  1122. }
  1123. last = rNode;
  1124. }
  1125. }
  1126. const valid = !sheet.zh_setting.readOnly;
  1127. return !(valid && first && first.level > 1);
  1128. },
  1129. visible: function (key, opt) {
  1130. return !readOnly;
  1131. }
  1132. };
  1133. billsContextMenuOptions.items.delete = {
  1134. name: '删除',
  1135. icon: 'fa-remove',
  1136. callback: function (key, opt) {
  1137. treeOperationObj.deleteNode(ledgerSpread.getActiveSheet());
  1138. },
  1139. disabled: function (key, opt) {
  1140. const sheet = ledgerSpread.getActiveSheet();
  1141. const selection = sheet.getSelections();
  1142. const sel = selection ? selection[0] : sheet.getSelections()[0];
  1143. const row = sel ? sel.row : -1;
  1144. const tree = sheet.zh_tree;
  1145. if (!tree) return true;
  1146. const first = sheet.zh_tree.nodes[row];
  1147. let last = first, sameParent = true;
  1148. if (sel.rowCount > 1) {
  1149. for (let r = 1; r < sel.rowCount; r++) {
  1150. const rNode = tree.nodes[sel.row + r];
  1151. if (rNode.level > first.level) continue;
  1152. if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
  1153. sameParent = false;
  1154. break;
  1155. }
  1156. last = rNode;
  1157. }
  1158. }
  1159. const valid = !sheet.zh_setting.readOnly;
  1160. return !(valid && first && sameParent && !(first.level === 1 && first.node_type));
  1161. },
  1162. visible: function (key, opt) {
  1163. return !readOnly;
  1164. }
  1165. };
  1166. billsContextMenuOptions.items.sprBase = '-----------';
  1167. }
  1168. billsContextMenuOptions.items.copyBlock = {
  1169. name: '复制整块',
  1170. icon: 'fa-files-o',
  1171. callback: function (key, opt) {
  1172. /*ledgerSpread.commandManager().execute({
  1173. cmd:"copy",
  1174. sheetName:ledgerSpread.getActiveSheet().name()
  1175. });*/
  1176. treeOperationObj.block = [];
  1177. const copyBlockList = [];
  1178. const sheet = ledgerSpread.getActiveSheet();
  1179. const sel = sheet.getSelections()[0];
  1180. let iRow = sel.row;
  1181. const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
  1182. while (iRow < sel.row + sel.rowCount) {
  1183. const node = sheet.zh_tree.nodes[iRow];
  1184. if (node.ledger_pid !== pid) {
  1185. toastr.error('仅可同时选中同层节点');
  1186. return;
  1187. }
  1188. const posterity = sheet.zh_tree.getPosterity(node);
  1189. iRow += posterity.length + 1;
  1190. posterity.unshift(node);
  1191. copyBlockList.push(sheet.zh_tree.getDefaultData(posterity));
  1192. }
  1193. for (const cbl of copyBlockList) {
  1194. for (const b of cbl) {
  1195. const posRange = pos.getLedgerPos(b.id);
  1196. if (posRange && posRange.length > 0) b.pos = posRange;
  1197. }
  1198. }
  1199. setLocalCache(copyBlockTag, JSON.stringify({block: copyBlockList}));
  1200. },
  1201. visible: function (key, opt) {
  1202. const sheet = ledgerSpread.getActiveSheet();
  1203. const selection = sheet.getSelections();
  1204. const row = selection[0].row;
  1205. const select = ledgerTree.nodes[row];
  1206. return select;
  1207. },
  1208. disabled: function (key, opt) {
  1209. const sheet = ledgerSpread.getActiveSheet();
  1210. const selection = sheet.getSelections();
  1211. const row = selection[0].row;
  1212. const select = ledgerTree.nodes[row];
  1213. return select && select.level <= 1;
  1214. }
  1215. };
  1216. billsContextMenuOptions.items.copyBlockXmj = {
  1217. name: '复制整块(只复制项目节)',
  1218. icon: 'fa-files-o',
  1219. callback: function (key, opt) {
  1220. treeOperationObj.block = [];
  1221. const copyBlockList = [];
  1222. const sheet = ledgerSpread.getActiveSheet();
  1223. const sel = sheet.getSelections()[0];
  1224. let iRow = sel.row;
  1225. const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
  1226. while (iRow < sel.row + sel.rowCount) {
  1227. const node = sheet.zh_tree.nodes[iRow];
  1228. if (node.ledger_pid !== pid) {
  1229. toastr.error('仅可同时选中同层节点');
  1230. return;
  1231. }
  1232. const posterity = sheet.zh_tree.getPosterity(node);
  1233. iRow += posterity.length + 1;
  1234. const copyPosterity = posterity.filter(x => { return !x.b_code; });
  1235. copyPosterity.unshift(node);
  1236. const copyData = sheet.zh_tree.getDefaultData(copyPosterity);
  1237. for (const p of copyData) {
  1238. const children = copyData.filter(y => {return y.ledger_pid === p.ledger_id}) || [];
  1239. p.is_leaf = children.length === 0;
  1240. }
  1241. copyBlockList.push(copyData);
  1242. }
  1243. setLocalCache(copyBlockTag, JSON.stringify({block: copyBlockList}));
  1244. },
  1245. visible: function (key, opt) {
  1246. const sheet = ledgerSpread.getActiveSheet();
  1247. const selection = sheet.getSelections();
  1248. const row = selection[0].row;
  1249. const select = ledgerTree.nodes[row];
  1250. return select;
  1251. },
  1252. disabled: function (key, opt) {
  1253. const sheet = ledgerSpread.getActiveSheet();
  1254. const selection = sheet.getSelections();
  1255. const row = selection[0].row;
  1256. const select = ledgerTree.nodes[row];
  1257. return select && select.level <= 1;
  1258. }
  1259. };
  1260. if (!readOnly) {
  1261. billsContextMenuOptions.items.pasteBlock = {
  1262. name: '粘贴整块',
  1263. icon: 'fa-clipboard',
  1264. disabled: function (key, opt) {
  1265. //const block = treeOperationObj.block || [];
  1266. const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
  1267. return !(copyInfo && copyInfo.block && copyInfo.block.length > 0);
  1268. },
  1269. callback: function (key, opt) {
  1270. //const block = treeOperationObj.block || [];
  1271. const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
  1272. if (copyInfo.block.length > 0) {
  1273. treeOperationObj.pasteBlock(ledgerSpread, copyInfo);
  1274. } else {
  1275. document.execCommand('paste');
  1276. }
  1277. },
  1278. visible: function (key, opt) {
  1279. return !readOnly;
  1280. }
  1281. };
  1282. billsContextMenuOptions.items.sprBlock = '-----------';
  1283. }
  1284. if (!readOnly) {
  1285. billsContextMenuOptions.items.sortChildren = {
  1286. name: '顺序重排子项编号',
  1287. icon: 'fa-sort-numeric-asc',
  1288. disabled: function (key, opt) {
  1289. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1290. return !node || !node.code || !node.children || node.children === 0 || node.code.indexOf('-') < 0;
  1291. },
  1292. callback: function (key, opt) {
  1293. treeOperationObj.sortCode(ledgerSpread.getActiveSheet());
  1294. },
  1295. visible: function (key, opt) {;
  1296. return !readOnly;
  1297. }
  1298. };
  1299. if (!checkTzMeasureType()) {
  1300. billsContextMenuOptions.items.applyDeal2Sgfh = {
  1301. name: '填设计量',
  1302. icon: 'fa-pencil',
  1303. callback: function (key, opt) {
  1304. postData(window.location.pathname + '/deal2sgfh', null, function (result) {
  1305. ledgerTree.loadDatas(result.bills);
  1306. treeCalc.calculateAll(ledgerTree);
  1307. SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
  1308. });
  1309. }
  1310. };
  1311. }
  1312. billsContextMenuOptions.items.sprSort = '-----------';
  1313. }
  1314. if (!readOnly) {
  1315. billsContextMenuOptions.items.batchInsert = {
  1316. name: '批量插入',
  1317. type: 'batchInsert',
  1318. value: '2',
  1319. icon: 'fa-sign-in',
  1320. batchInsert: function (obj, root) {
  1321. if (_.toNumber(obj.value) > _.toNumber(obj.max)) {
  1322. obj.value = obj.max;
  1323. toastr.warning('批量插入不可多于' + obj.max);
  1324. } else if(_.toNumber(obj.value) < _.toNumber(obj.min)) {
  1325. obj.value = obj.min;
  1326. toastr.warning('批量插入不可少于' + obj.min);
  1327. } else {
  1328. treeOperationObj.addNode(ledgerSpread.getActiveSheet(), parseInt(obj.value));
  1329. root.$menu.trigger('contextmenu:hide');
  1330. }
  1331. },
  1332. disabled: function (key, opt) {
  1333. const sheet = ledgerSpread.getActiveSheet();
  1334. const selection = sheet.getSelections();
  1335. const sel = selection ? selection[0] : sheet.getSelections()[0];
  1336. const row = sel ? sel.row : -1;
  1337. const tree = sheet.zh_tree;
  1338. if (!tree) return true;
  1339. const first = sheet.zh_tree.nodes[row];
  1340. let last = first, sameParent = true;
  1341. if (sel.rowCount > 1) {
  1342. for (let r = 1; r < sel.rowCount; r++) {
  1343. const rNode = tree.nodes[sel.row + r];
  1344. if (rNode.level > first.level) continue;
  1345. if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
  1346. sameParent = false;
  1347. break;
  1348. }
  1349. last = rNode;
  1350. }
  1351. }
  1352. const valid = !sheet.zh_setting.readOnly;
  1353. return !(valid && first && first.level > 1);
  1354. },
  1355. visible: function (key, opt) {
  1356. return !readOnly;
  1357. }
  1358. };
  1359. billsContextMenuOptions.items.batchInsertBillsPos = {
  1360. name: '批量插入清单-计量单元',
  1361. icon: 'fa-sign-in',
  1362. disabled: function (key, opt) {
  1363. if (!checkTzMeasureType()) return true;
  1364. const sheet = ledgerSpread.getActiveSheet();
  1365. const selection = sheet.getSelections();
  1366. const row = selection[0].row;
  1367. const select = ledgerTree.nodes[row];
  1368. if (select) {
  1369. if (select.code && select.code !== '') {
  1370. return !ledgerTree.isLeafXmj(select);
  1371. } else {
  1372. const parent = ledgerTree.getParent(select);
  1373. return !(parent && ledgerTree.isLeafXmj(parent));
  1374. }
  1375. } else {
  1376. return true;
  1377. }
  1378. },
  1379. callback: function (key, opt) {
  1380. if (!batchInsertObj) {
  1381. batchInsertObj = new BatchInsertBillsPosObj($('#batch'));
  1382. } else {
  1383. batchInsertObj.initView();
  1384. }
  1385. $('#batch').modal('show');
  1386. },
  1387. visible: function (key, opt) {
  1388. return !readOnly;
  1389. }
  1390. };
  1391. billsContextMenuOptions.items.sprBatch = '-----------';
  1392. }
  1393. if (!readOnly) {
  1394. billsContextMenuOptions.items.importExcel = {
  1395. name: '导入分项清单Excel',
  1396. icon: 'fa-file-excel-o',
  1397. disabled: function (key, opt) {
  1398. return readOnly;
  1399. },
  1400. callback: function (key, opt) {
  1401. importExcel.doImport({
  1402. template: {
  1403. hint: '0号台账',
  1404. url: '/template/导入分项清单EXCEL格式.xls',
  1405. },
  1406. filter: true,
  1407. callback: function (sheet, filter) {
  1408. postDataCompress(window.location.pathname + '/upload-excel/tz', {sheet, filter}, function (result) {
  1409. ledgerTree.loadDatas(result.bills);
  1410. treeCalc.calculateAll(ledgerTree);
  1411. SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
  1412. pos.loadDatas(result.pos);
  1413. posOperationObj.loadCurPosData();
  1414. }, null);
  1415. },
  1416. // callback: function (file, select) {
  1417. // const formData = new FormData();
  1418. // formData.append('file', file.files[0]);
  1419. // postDataWithFileProgress(window.location.pathname + '/upload-excel?ueType=tz&sheetName=' + select, formData, function (result) {
  1420. // ledgerTree.loadDatas(result.bills);
  1421. // treeCalc.calculateAll(ledgerTree);
  1422. // SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
  1423. // pos.loadDatas(result.pos);
  1424. // posOperationObj.loadCurPosData();
  1425. // }, null);
  1426. // }
  1427. //u_type: importExcel.uploadType.file,
  1428. });
  1429. //$('#upload-ledger').modal('show');
  1430. },
  1431. visible: function (key, opt) {
  1432. return !readOnly;
  1433. }
  1434. };
  1435. billsContextMenuOptions.items.importGclBills2Xmj = {
  1436. name: '导入工程量清单至项目节',
  1437. icon: 'fa-file-excel-o',
  1438. disabled: function (key, opt) {
  1439. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1440. return readOnly || !node
  1441. || (node.children && node.children.length > 0)
  1442. || (!_.isNil(node.b_code) && node.b_code !== '');
  1443. },
  1444. callback: function (key, opt) {
  1445. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1446. importExcel.doImport({
  1447. template: {
  1448. hint: '工程量清单',
  1449. url: '/template/导入工程量清单EXCEL格式.xls',
  1450. },
  1451. callback: function (sheet) {
  1452. postDataCompress(window.location.pathname + '/upload-excel/gcl2xmj', {id: node.id, sheet: sheet}, function (result) {
  1453. const ledgerSheet = ledgerSpread.getActiveSheet();
  1454. const sel = ledgerSheet.getSelections();
  1455. const refreshNode = ledgerTree.loadPostData(result);
  1456. treeOperationObj.refreshTree(ledgerSheet, refreshNode);
  1457. if (refreshNode.create[0]) {
  1458. if (sel && sel[0]) {
  1459. ledgerSheet.setSelection(refreshNode.create[0].index, sel[0].col, sel[0].rowCount, sel[0].colCount);
  1460. SpreadJsObj.reloadRowsBackColor(ledgerSheet, [sel[0].row, refreshNode.create[0].index]);
  1461. } else {
  1462. ledgerSheet.setSelection(refreshNode.create[0].index, 0, 1, 1);
  1463. SpreadJsObj.reloadRowsBackColor(ledgerSheet, [refreshNode.create[0].index]);
  1464. }
  1465. }
  1466. treeOperationObj.refreshOperationValid(ledgerSheet);
  1467. }, null);
  1468. }
  1469. });
  1470. },
  1471. visible: function (key, opt) {
  1472. return !readOnly;
  1473. }
  1474. };
  1475. billsContextMenuOptions.items.sprImport = '-----------';
  1476. }
  1477. $.contextMenu(billsContextMenuOptions);
  1478. const posSearch = $.posSearch({selector: '#pos-search', searchSpread: posSpread});
  1479. // 台账模式加载计量单元数据
  1480. if (checkTzMeasureType()) {
  1481. $.divResizer({
  1482. select: '#main-resize',
  1483. callback: function () {
  1484. ledgerSpread.refresh();
  1485. let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
  1486. $(".sp-wrap").height(bcontent-30);
  1487. posSpread.refresh();
  1488. }
  1489. });
  1490. sjsSettingObj.setGridSelectStyle(posSpreadSetting);
  1491. SpreadJsObj.initSheet(posSpread.getActiveSheet(), posSpreadSetting);
  1492. }
  1493. //绑定计量单元编辑事件
  1494. const posOperationObj = {
  1495. /**
  1496. * 刷新顶部按钮是否可用
  1497. * @param sheet
  1498. * @param selections
  1499. */
  1500. refreshOperationValid: function (sheet, selection) {
  1501. const setObjEnable = function (obj, enable) {
  1502. if (enable) {
  1503. obj.removeClass('disabled');
  1504. } else {
  1505. obj.addClass('disabled');
  1506. }
  1507. };
  1508. const invalidAll = function () {
  1509. setObjEnable($('a[name=pos-opr][type=up-move]'), false);
  1510. setObjEnable($('a[name=pos-opr][type=down-move]'), false);
  1511. };
  1512. const sel = selection ? selection[0] : sheet.getSelections()[0];
  1513. const row = sel ? sel.row : -1;
  1514. const first = sheet.zh_data[row];
  1515. if (!first) {
  1516. invalidAll();
  1517. return;
  1518. }
  1519. let last = first;
  1520. if (sel.rowCount > 1 && first) {
  1521. for (let r = 1; r < sel.rowCount; r++) {
  1522. const rNode = sheet.zh_data[sel.row + r];
  1523. if (!rNode) break;
  1524. last = rNode;
  1525. }
  1526. }
  1527. const preNode = sheet.zh_data[row - 1];
  1528. const valid = !sheet.zh_setting.readOnly;
  1529. setObjEnable($('a[name=pos-opr][type=up-move]'), valid && first && preNode);
  1530. setObjEnable($('a[name=pos-opr][type=down-move]'), valid && first && (sheet.zh_data.indexOf(last) < sheet.zh_data.length - 1));
  1531. },
  1532. editStarting: function (e, info) {
  1533. posOperationObj.ledgerTreeNode = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1534. const sel = info.sheet.getSelections();
  1535. if (!sel || !sel[0]) return;
  1536. const col = info.sheet.zh_setting.cols[sel[0].col];
  1537. const node = SpreadJsObj.getSelectObject(info.sheet);
  1538. const exprInfo = getExprInfo(col.field);
  1539. if (exprInfo) {
  1540. if (node[exprInfo.expr] && node[exprInfo.expr] !== '') {
  1541. info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]);
  1542. }
  1543. }
  1544. },
  1545. loadExprToInput: function () {
  1546. const sheet = posSpread.getActiveSheet();
  1547. const sel = sheet.getSelections()[0];
  1548. if (!sel || !sheet.zh_setting) return;
  1549. const col = sheet.zh_setting.cols[sel.col], cell = sheet.getCell(sel.row, sel.col);
  1550. if (col && col.type === 'Number') {
  1551. const data = SpreadJsObj.getSelectObject(sheet);
  1552. if (data) {
  1553. const exprInfo = getExprInfo(col.field);
  1554. const value = exprInfo
  1555. ? (data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field])
  1556. : data[col.field];
  1557. $('#pos-expr').val(value).attr('field', col.field).attr('org', data[col.field])
  1558. .attr('readOnly', readOnly || cell.locked()).attr('data-row', sel.row);
  1559. } else {
  1560. $('#pos-expr').val('').attr('readOnly', true);
  1561. $('#pos-expr').removeAttr('data-row');
  1562. }
  1563. } else {
  1564. $('#pos-expr').val('').attr('readOnly', true);
  1565. $('#pos-expr').removeAttr('data-row');
  1566. }
  1567. },
  1568. /**
  1569. * 加载计量单元 根据当前台账选择节点
  1570. */
  1571. loadCurPosData: function () {
  1572. //spreadJsObj.reinitSheet(posSpread.getActiveSheet());
  1573. const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
  1574. if (node) {
  1575. const posData = pos.ledgerPos[itemsPre + node.id] || [];
  1576. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', posData);
  1577. } else {
  1578. SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', []);
  1579. }
  1580. posOperationObj.loadExprToInput();
  1581. posOperationObj.refreshOperationValid(posSpread.getActiveSheet());
  1582. },
  1583. baseOpr: function (sheet, type) {
  1584. const data = {
  1585. updateType: type === 'delete' ? type : 'update',
  1586. updateData: [],
  1587. };
  1588. const selection = sheet.getSelections();
  1589. const row = selection[0].row, count = selection[0].rowCount;
  1590. const first = sheet.zh_data[row];
  1591. if (type === 'delete') {
  1592. for (let iRow = 0; iRow < count; iRow++) {
  1593. const posData = sheet.zh_data[iRow + row];
  1594. if (posData) {
  1595. data.updateData.push(sheet.zh_data[iRow + row].id);
  1596. }
  1597. }
  1598. } else if (type === 'up-move') {
  1599. const pre = sheet.zh_data[row - 1], preUpdate = {id: pre.id};
  1600. for (let iRow = 0; iRow < count; iRow++) {
  1601. const posData = sheet.zh_data[iRow + row];
  1602. if (posData) {
  1603. data.updateData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row - 1].porder});
  1604. preUpdate.porder = posData.porder;
  1605. }
  1606. }
  1607. data.updateData.push(preUpdate);
  1608. } else if (type === 'down-move') {
  1609. const next = sheet.zh_data[row + count], nextUpdate = {id: next.id};
  1610. for (let iRow = count - 1; iRow >= 0; iRow--) {
  1611. const posData = sheet.zh_data[iRow + row];
  1612. if (posData) {
  1613. data.updateData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row + 1].porder});
  1614. nextUpdate.porder = posData.porder;
  1615. }
  1616. }
  1617. data.updateData.push(nextUpdate);
  1618. }
  1619. if (data.updateData.length > 0) {
  1620. postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
  1621. if (type === 'delete') {
  1622. pos.removeDatas(result.pos);
  1623. sheet.deleteRows(row, count);
  1624. const loadResult = ledgerTree.loadPostData(result.ledger);
  1625. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1626. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1627. } else {
  1628. pos.updateDatas(result.pos);
  1629. const sel = selection[0];
  1630. if (sel) {
  1631. sheet.setSelection(sheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
  1632. SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, sheet.zh_data.indexOf(first)]);
  1633. }
  1634. posOperationObj.loadCurPosData();
  1635. }
  1636. });
  1637. }
  1638. },
  1639. /**
  1640. * 编辑单元格响应事件
  1641. * @param {Object} e
  1642. * @param {Object} info
  1643. */
  1644. editEnded: function (e, info) {
  1645. if (info.sheet.zh_setting) {
  1646. const posData = info.sheet.zh_data ? info.sheet.zh_data[info.row] : null;
  1647. const col = info.sheet.zh_setting.cols[info.col];
  1648. const orgText = posData ? posData[col.field] : null;
  1649. const newText = trimInvalidChar(info.editingText);
  1650. if (orgText === newText || ((!orgText || orgText === '') && (newText === ''))) {
  1651. return;
  1652. }
  1653. //const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
  1654. const node = posOperationObj.ledgerTreeNode;
  1655. if (!node) {
  1656. toastr.error('数据错误,请选择台账节点后再试');
  1657. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1658. return;
  1659. } else if (newText && newText !== '' && node.children && node.children.length > 0) {
  1660. toastr.error('父节点不可插入计量单元');
  1661. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1662. return;
  1663. } else if (newText && newText !== '' && (!node.b_code || node.b_code === '')) {
  1664. toastr.error('项目节不可插入计量单元');
  1665. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1666. return;
  1667. }
  1668. const data = {};
  1669. if (col.field === 'name') {
  1670. if (newText === '' && posData) {
  1671. toastr.error('部位名称不可为空');
  1672. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1673. return;
  1674. } else if (!posData) {
  1675. if (newText && newText !== '') {
  1676. data.updateType = 'add';
  1677. const sortData = info.sheet.zh_data;
  1678. const order = (!sortData || sortData.length === 0) ? 1 : Math.max(sortData[sortData.length - 1].porder + 1, sortData.length + 1);
  1679. data.updateData = { name: newText, lid: node.id, tid: tender.id, porder: order};
  1680. } else {
  1681. return;
  1682. }
  1683. } else {
  1684. data.updateType = 'update';
  1685. data.updateData = {id: posData.id, name: newText};
  1686. }
  1687. } else if (!posData) {
  1688. toastr.warning('新增计量单元请先输入名称');
  1689. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1690. return;
  1691. } else {
  1692. data.updateType = 'update';
  1693. data.updateData = {id: posData.id};
  1694. if (col.type === 'Number') {
  1695. const exprInfo = getExprInfo(col.field);
  1696. const num = _.toNumber(newText);
  1697. if (_.isFinite(num)) {
  1698. data.updateData[col.field] = num;
  1699. if (exprInfo) {
  1700. data.updateData[exprInfo.expr] = '';
  1701. }
  1702. } else {
  1703. try {
  1704. data.updateData[col.field] = math.evaluate(transExpr(newText));
  1705. if (exprInfo) {
  1706. data.updateData[exprInfo.expr] = newText;
  1707. }
  1708. } catch(err) {
  1709. toastr.error('输入的表达式非法');
  1710. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1711. return;
  1712. }
  1713. }
  1714. } else {
  1715. data.updateData[col.field] = newText;
  1716. }
  1717. }
  1718. postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
  1719. const updateRst = pos.updateDatas(result.pos);
  1720. // 刷新当前行, 不适用于新增(在非下一空白行新增)
  1721. if (updateRst.create.length > 0) {
  1722. // info.sheet.addRows(info.row, 1);
  1723. // if (info.sheet.zh_data.length === 0) {
  1724. // info.sheet.zh_data = pos.ledgerPos[itemsPre + node.id] || [];
  1725. // }
  1726. // SpreadJsObj.reLoadRowData(info.sheet, info.sheet.zh_data.length - 1);
  1727. posOperationObj.loadCurPosData();
  1728. } else {
  1729. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1730. }
  1731. const loadResult = ledgerTree.loadPostData(result.ledger);
  1732. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1733. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1734. }, function () {
  1735. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  1736. });
  1737. }
  1738. },
  1739. /**
  1740. * 删除按钮响应事件
  1741. * @param sheet
  1742. */
  1743. deletePress: function (sheet) {
  1744. const self = this;
  1745. if (sheet.zh_setting) {
  1746. const sortData = sheet.zh_data;
  1747. const datas = [], posSelects = [];
  1748. const sel = sheet.getSelections()[0];
  1749. for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
  1750. let bDel = false;
  1751. const node = sortData[iRow];
  1752. if (node) {
  1753. const data = {id: node.id};
  1754. for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
  1755. const colSetting = sheet.zh_setting.cols[iCol];
  1756. if (colSetting.field === 'name') {
  1757. toastr.error('部位名称不能为空');
  1758. return;
  1759. }
  1760. const style = sheet.getStyle(iRow, iCol);
  1761. if (!style.locked) {
  1762. const colSetting = sheet.zh_setting.cols[iCol];
  1763. data[colSetting.field] = null;
  1764. const exprInfo = getExprInfo(colSetting.field);
  1765. if (exprInfo) {
  1766. data[exprInfo.expr] = '';
  1767. }
  1768. bDel = true;
  1769. }
  1770. }
  1771. if (bDel) {
  1772. datas.push(data);
  1773. posSelects.push(node);
  1774. }
  1775. }
  1776. }
  1777. if (datas.length > 0) {
  1778. postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: datas}, function (result) {
  1779. pos.updateDatas(result.pos);
  1780. posOperationObj.loadCurPosData();
  1781. const loadResult = ledgerTree.loadPostData(result.ledger);
  1782. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1783. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1784. }, function () {
  1785. posOperationObj.loadCurPosData();
  1786. });
  1787. }
  1788. }
  1789. },
  1790. /**
  1791. * 删除 计量单元
  1792. * @param sheet
  1793. */
  1794. deletePos: function (sheet) {
  1795. const selection = sheet.getSelections();
  1796. const data = {
  1797. updateType: 'delete',
  1798. updateData: [],
  1799. };
  1800. const row = selection[0].row, count = selection[0].rowCount;
  1801. const sortData = sheet.zh_data;
  1802. for (let iRow = 0; iRow < count; iRow++) {
  1803. if (sortData[iRow + row]) {
  1804. data.updateData.push(sortData[iRow + row].id);
  1805. }
  1806. }
  1807. if (data.updateData.length > 0) {
  1808. postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
  1809. pos.removeDatas(result.pos);
  1810. sheet.deleteRows(row, count);
  1811. const loadResult = ledgerTree.loadPostData(result.ledger);
  1812. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1813. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1814. });
  1815. }
  1816. },
  1817. /**
  1818. * 粘贴单元格响应事件
  1819. * @param e
  1820. * @param info
  1821. */
  1822. clipboardPasted: function (e, info) {
  1823. if (info.sheet.getColumnCount() > info.sheet.zh_setting.cols.length) {
  1824. info.sheet.setColumnCount(info.sheet.zh_setting.cols.length);
  1825. }
  1826. const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
  1827. if (node.code && (node.code !== '')) {
  1828. toastr.error('项目节不可含有清单明细');
  1829. posOperationObj.loadCurPosData();
  1830. return;
  1831. }
  1832. if (node.children && (node.children.length > 0)) {
  1833. toastr.error('仅清单子项可以含有计量单元');
  1834. posOperationObj.loadCurPosData();
  1835. return;
  1836. }
  1837. if (info.sheet.zh_setting) {
  1838. const data = [];
  1839. const sortData = info.sheet.zh_data || [];
  1840. if (sortData.length === 0 || info.cellRange.row + info.cellRange.rowCount > sortData.length) {
  1841. if (info.cellRange.col !== 0) {
  1842. toastr.warning('新增计量单元请先输入名称');
  1843. posOperationObj.loadCurPosData();
  1844. return;
  1845. }
  1846. }
  1847. const lastOrder = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
  1848. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
  1849. let bPaste = false;
  1850. const curRow = info.cellRange.row + iRow;
  1851. const posData = curRow >= sortData.length ? {lid: node.id, porder: lastOrder + curRow - sortData.length} : {id: sortData[curRow].id, lid: node.id};
  1852. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  1853. const curCol = info.cellRange.col + iCol;
  1854. const colSetting = info.sheet.zh_setting.cols[curCol];
  1855. if (!colSetting) continue;
  1856. posData[colSetting.field] = trimInvalidChar(info.sheet.getText(curRow, curCol));
  1857. if (colSetting.type === 'Number') {
  1858. const num = _.toNumber(posData[colSetting.field]);
  1859. if (num) {
  1860. posData[colSetting.field] = num;
  1861. bPaste = true;
  1862. } else {
  1863. try {
  1864. posData[colSetting.field] = math.evaluate(transExpr(posData[colSetting.field]));
  1865. const exprInfo = getExprInfo(colSetting.field);
  1866. if (exprInfo) {
  1867. posData[exprInfo.expr] = trimInvalidChar(info.sheet.getText(curRow, curCol));
  1868. }
  1869. bPaste = true;
  1870. } catch(err) {
  1871. delete posData[colSetting.field];
  1872. toastr.warning('粘贴了表达式非法,已过滤');
  1873. }
  1874. }
  1875. } else {
  1876. bPaste = true;
  1877. }
  1878. }
  1879. if (bPaste) {
  1880. data.push(posData);
  1881. }
  1882. }
  1883. if (data.length > 0) {
  1884. postData('/tender/' + getTenderId() + '/pos/paste', data, function (result) {
  1885. pos.updateDatas(result.pos);
  1886. posOperationObj.loadCurPosData();
  1887. const loadResult = ledgerTree.loadPostData(result.ledger);
  1888. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1889. posOperationObj.loadCurPosData();
  1890. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1891. }, function () {
  1892. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  1893. });
  1894. } else {
  1895. SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
  1896. }
  1897. }
  1898. },
  1899. selectionChanged: function (e, info) {
  1900. posOperationObj.loadExprToInput();
  1901. posOperationObj.refreshOperationValid(posSpread.getActiveSheet());
  1902. },
  1903. addPegs: function (pegs) {
  1904. if (!pegs || pegs.length <= 0) return;
  1905. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1906. if (!node) return;
  1907. const sheet = posSpread.getActiveSheet();
  1908. const sortData = sheet.zh_data || [];
  1909. let order = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
  1910. pegs.forEach(function (p) {p.porder = ++order; p.lid = node.id});
  1911. postData('/tender/' + getTenderId() + '/pos/paste', pegs, function (result) {
  1912. pos.updateDatas(result.pos);
  1913. posOperationObj.loadCurPosData();
  1914. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1915. });
  1916. }
  1917. };
  1918. posSpread.bind(spreadNS.Events.SelectionChanged, posOperationObj.selectionChanged);
  1919. if (!posSpreadSetting.readOnly) {
  1920. $('a[name="pos-opr"]').click(function () {
  1921. posOperationObj.baseOpr(posSpread.getActiveSheet(), this.getAttribute('type'));
  1922. });
  1923. $('#pos-expr').bind('change onblur', function () {
  1924. const expr = $(this);
  1925. const posSheet = posSpread.getActiveSheet();
  1926. const row = expr.attr('data-row') ? _.toInteger(expr.attr('data-row')) : -1;
  1927. const select = posSheet.zh_data ? posSheet.zh_data[row] : null;
  1928. if (!select) return;
  1929. const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = expr.val();
  1930. if (orgValue === newValue || (!orgValue && newValue == '')) { return; }
  1931. const data = {id: select.id};
  1932. const exprInfo = getExprInfo(field);
  1933. if (newValue !== '') {
  1934. const num = _.toNumber(newValue);
  1935. if (num) {
  1936. data[field] = num;
  1937. if (exprInfo) {
  1938. data[exprInfo.expr] = '';
  1939. }
  1940. } else {
  1941. try {
  1942. data[field] = math.evaluate(transExpr(newValue));
  1943. if (exprInfo) {
  1944. data[exprInfo.expr] = newValue;
  1945. }
  1946. } catch (err) {
  1947. toastr.error('输入的表达式非法');
  1948. return;
  1949. }
  1950. }
  1951. } else {
  1952. data[field] = null;
  1953. if (exprInfo) {
  1954. data[exprInfo.expr] = '';
  1955. }
  1956. }
  1957. // 更新至服务器
  1958. postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: data}, function (result) {
  1959. const updateRst = pos.updateDatas(result.pos);
  1960. SpreadJsObj.reLoadRowData(posSheet, _.toNumber(row));
  1961. const loadResult = ledgerTree.loadPostData(result.ledger);
  1962. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  1963. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  1964. });
  1965. });
  1966. SpreadJsObj.addDeleteBind(posSpread, posOperationObj.deletePress);
  1967. posSpread.bind(spreadNS.Events.EditStarting, posOperationObj.editStarting);
  1968. posSpread.bind(spreadNS.Events.EditEnded, posOperationObj.editEnded);
  1969. posSpread.bind(spreadNS.Events.ClipboardPasted, posOperationObj.clipboardPasted);
  1970. const mergePeg = NewMergePeg({ callback: posOperationObj.addPegs });
  1971. // 右键菜单
  1972. $.contextMenu({
  1973. selector: '#pos-spread',
  1974. build: function ($trigger, e) {
  1975. const target = SpreadJsObj.safeRightClickSelection($trigger, e, posSpread);
  1976. return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
  1977. },
  1978. items: {
  1979. 'delete': {
  1980. name: '删除',
  1981. icon: 'fa-remove',
  1982. disabled: function (key, opt) {
  1983. const sheet = posSpread.getActiveSheet();
  1984. if (sheet.zh_data) {
  1985. const selection = sheet.getSelections();
  1986. return sheet.zh_data.length < selection[0].row + selection[0].rowCount;
  1987. } else {
  1988. return true;
  1989. }
  1990. },
  1991. callback: function (key, opt) {
  1992. posOperationObj.deletePos(posSpread.getActiveSheet());
  1993. }
  1994. },
  1995. 'merge-peg': {
  1996. name: '合并起讫桩号',
  1997. disabled: function (key, opt) {
  1998. const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
  1999. return _.isNil(node) || _.isNil(node.b_code) || node.b_code === '';
  2000. },
  2001. callback: function (key, opt) {
  2002. mergePeg.show();
  2003. }
  2004. }
  2005. }
  2006. });
  2007. } else {
  2008. SpreadJsObj.forbiddenSpreadContextMenu('#pos-spread', posSpread);
  2009. }
  2010. postData(window.location.pathname + '/load', {}, function (data) {
  2011. ledgerTree.loadDatas(data.bills);
  2012. treeCalc.calculateAll(ledgerTree);
  2013. SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
  2014. SpreadJsObj.loadTopAndSelect(ledgerSpread.getActiveSheet(), ckBillsSpread);
  2015. pos.loadDatas(data.pos);
  2016. posOperationObj.loadCurPosData();
  2017. SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
  2018. treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
  2019. treeOperationObj.loadExprToInput(ledgerSpread.getActiveSheet());
  2020. checkList.loadHisCheckData();
  2021. }, null, true);
  2022. $.divResizer({
  2023. select: '#right-spr',
  2024. callback: function () {
  2025. ledgerSpread.refresh();
  2026. if (posSpread) {
  2027. posSpread.refresh();
  2028. }
  2029. if (stdXmj) {
  2030. stdXmj.spread.refresh();
  2031. }
  2032. if (stdGcl) {
  2033. stdGcl.spread.refresh();
  2034. }
  2035. if (dealBills) {
  2036. dealBills.spread.refresh();
  2037. }
  2038. if (searchLedger) {
  2039. searchLedger.spread.refresh();
  2040. }
  2041. if (errorList) {
  2042. errorList.spread.refresh();
  2043. }
  2044. if (checkList) {
  2045. checkList.spread.refresh();
  2046. }
  2047. }
  2048. });
  2049. const stdLibCellDoubleClick = function (e, info) {
  2050. const stdSheet = info.sheet;
  2051. const mainSheet = ledgerSpread.getActiveSheet();
  2052. if (!stdSheet.zh_setting || !stdSheet.zh_tree || !mainSheet.zh_tree) { return; }
  2053. const stdTree = stdSheet.zh_tree;
  2054. const stdNode = stdTree.nodes[info.row];
  2055. const mainTree = mainSheet.zh_tree;
  2056. const sel = mainSheet.getSelections()[0];
  2057. const mainNode = mainTree.nodes[sel.row];
  2058. if (!stdNode) { return; }
  2059. if (info.sheet.zh_setting.stdType === 'gcl') {
  2060. if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
  2061. toastr.warning('非最底层项目下,不应添加清单');
  2062. return;
  2063. }
  2064. }
  2065. postData(window.location.pathname + '/update', {
  2066. postType: 'add-std',
  2067. postData: {
  2068. id: ledgerTree.getNodeKey(mainNode),
  2069. tender_id: mainNode.tender_id,
  2070. stdType: info.sheet.zh_setting.stdType,
  2071. stdLibId: stdNode.list_id,
  2072. stdNode: stdTree.getNodeKey(stdNode)
  2073. }
  2074. }, function (result) {
  2075. const refreshNode = mainTree.loadPostData(result);
  2076. treeOperationObj.refreshTree(mainSheet, refreshNode);
  2077. if (refreshNode.create && refreshNode.create.length > 0) {
  2078. mainSheet.setSelection(refreshNode.create[refreshNode.create.length - 1].index, sel.col, sel.rowCount, sel.colCount);
  2079. SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, refreshNode.create[refreshNode.create.length - 1].index]);
  2080. } else {
  2081. const node = _.find(ledgerTree.nodes, {code: stdNode.code, name: stdNode.name});
  2082. if (node) {
  2083. mainSheet.setSelection(ledgerTree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
  2084. SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, ledgerTree.nodes.indexOf(node)]);
  2085. }
  2086. }
  2087. treeOperationObj.refreshOperationValid(mainSheet);
  2088. ledgerSpread.focus();
  2089. posOperationObj.loadCurPosData();
  2090. });
  2091. };
  2092. const stdXmjSetting = {
  2093. selector: '#std-xmj',
  2094. stdType: 'xmj',
  2095. treeSetting: {
  2096. id: 'chapter_id',
  2097. pid: 'pid',
  2098. order: 'order',
  2099. level: 'level',
  2100. rootId: -1,
  2101. keys: ['id', 'list_id', 'chapter_id'],
  2102. },
  2103. spreadSetting: {
  2104. cols: [
  2105. {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  2106. {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
  2107. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
  2108. ],
  2109. treeCol: 0,
  2110. emptyRows: 0,
  2111. headRows: 1,
  2112. headRowHeight: [32],
  2113. defaultRowHeight: 21,
  2114. headerFont: '12px 微软雅黑',
  2115. font: '12px 微软雅黑',
  2116. headColWidth: [30],
  2117. selectedBackColor: '#fffacd',
  2118. },
  2119. cellDoubleClick: stdLibCellDoubleClick,
  2120. page: 'ledger',
  2121. tid: getTenderId(),
  2122. };
  2123. const stdGclSetting = {
  2124. selector: '#std-gcl',
  2125. stdType: 'gcl',
  2126. treeSetting: {
  2127. id: 'bill_id',
  2128. pid: 'pid',
  2129. order: 'order',
  2130. level: 'level',
  2131. rootId: -1,
  2132. keys: ['id', 'list_id', 'bill_id']
  2133. },
  2134. spreadSetting: {
  2135. cols: [
  2136. {title: '清单编号', field: 'b_code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
  2137. {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
  2138. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
  2139. ],
  2140. treeCol: 0,
  2141. emptyRows: 0,
  2142. headRows: 1,
  2143. headRowHeight: [32],
  2144. defaultRowHeight: 21,
  2145. headerFont: '12px 微软雅黑',
  2146. font: '12px 微软雅黑',
  2147. headColWidth: [30],
  2148. selectedBackColor: '#fffacd',
  2149. },
  2150. cellDoubleClick: stdLibCellDoubleClick,
  2151. page: 'ledger',
  2152. tid: getTenderId(),
  2153. };
  2154. // 展开收起标准清单
  2155. $('a', '#side-menu').bind('click', function (e) {
  2156. e.preventDefault();
  2157. const tab = $(this), tabPanel = $(tab.attr('content'));
  2158. // 展开工具栏、切换标签
  2159. if (!tab.hasClass('active')) {
  2160. const close = $('.active', '#side-menu').length === 0;
  2161. $('a', '#side-menu').removeClass('active');
  2162. tab.addClass('active');
  2163. $('.tab-content .tab-pane').removeClass('active');
  2164. tabPanel.addClass('active');
  2165. showSideTools(tab.hasClass('active'));
  2166. if (tab.attr('content') === '#std-xmj') {
  2167. if (!stdXmj) {
  2168. stdXmj = new stdLib(stdXmjSetting);
  2169. //stdXmj.loadLib($('select', '#std-xmj').val());
  2170. }
  2171. stdXmj.spread.refresh();
  2172. } else if (tab.attr('content') === '#std-gcl') {
  2173. if (!stdGcl) {
  2174. stdGcl = new stdLib(stdGclSetting);
  2175. //stdGcl.loadLib($('select', '#std-gcl').val());
  2176. }
  2177. stdGcl.spread.refresh();
  2178. } else if (tab.attr('content') === '#deal-bills') {
  2179. if (!dealBills) {
  2180. dealBills = new DealBills('#deal-bills-spread', {
  2181. cols: [
  2182. {title: '清单编号', field: 'code', hAlign: 0, width: 85, formatter: '@'},
  2183. {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@'},
  2184. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
  2185. {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
  2186. {title: '数量', field: 'quantity', hAlign: 2, width: 50},
  2187. {title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true},
  2188. ],
  2189. emptyRows: 3,
  2190. headRows: 1,
  2191. headRowHeight: [32],
  2192. defaultRowHeight: 21,
  2193. headerFont: '12px 微软雅黑',
  2194. font: '12px 微软雅黑',
  2195. headColWidth: [30],
  2196. selectedBackColor: '#fffacd',
  2197. readOnly: true,
  2198. });
  2199. dealBills.loadData();
  2200. }
  2201. dealBills.spread.refresh();
  2202. } else if (tab.attr('content') === '#search') {
  2203. if (!searchLedger) {
  2204. searchLedger = $.billsSearch({
  2205. selector: '#search',
  2206. searchSpread: ledgerSpread,
  2207. resultSpreadSetting: {
  2208. cols: [
  2209. {title: '项目节编号', field: 'code', hAlign: 0, width: 90, formatter: '@', readOnly: true},
  2210. {title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@', readOnly: true},
  2211. {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@', readOnly: true},
  2212. {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@', readOnly: true},
  2213. {title: '单价', field: 'unit_price', hAlign: 2, width: 50, readOnly: true},
  2214. {title: '数量', field: 'quantity', hAlign: 2, width: 50, readOnly: true},
  2215. ],
  2216. emptyRows: 0,
  2217. headRows: 1,
  2218. headRowHeight: [32],
  2219. headColWidth: [30],
  2220. defaultRowHeight: 21,
  2221. headerFont: '12px 微软雅黑',
  2222. font: '12px 微软雅黑',
  2223. selectedBackColor: '#fffacd',
  2224. },
  2225. afterLocated: function () {
  2226. posOperationObj.loadCurPosData();
  2227. }
  2228. });
  2229. }
  2230. searchLedger.spread.refresh();
  2231. } else if (tab.attr('content') === '#error-list') {
  2232. errorList.spread.refresh();
  2233. } else if (tab.attr('content') === '#check-list') {
  2234. checkList.spread.refresh();
  2235. }
  2236. } else { // 收起工具栏
  2237. tab.removeClass('active');
  2238. tabPanel.removeClass('active');
  2239. showSideTools(tab.hasClass('active'));
  2240. }
  2241. ledgerSpread.refresh();
  2242. if (posSpread) {
  2243. posSpread.refresh();
  2244. }
  2245. });
  2246. class DealBills {
  2247. constructor (selector, spreadSetting) {
  2248. const self = this;
  2249. this.obj = $(selector)[0];
  2250. this.url = '/tender/' + getTenderId() + '/deal';
  2251. this.spreadSetting = spreadSetting;
  2252. this.spread = SpreadJsObj.createNewSpread(this.obj);
  2253. this.sheet = this.spread.getActiveSheet();
  2254. SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
  2255. this.OprObj = {
  2256. /**
  2257. * 删除按钮响应事件
  2258. * @param sheet
  2259. */
  2260. deletePress: function (sheet) {
  2261. if (!sheet.zh_setting || readOnly || sheet.zh_setting.readOnly) return;
  2262. const sortData = sheet.zh_data;
  2263. const datas = [];
  2264. const sels = sheet.getSelections();
  2265. if (!sels || !sels[0]) return;
  2266. for (let iRow = sels[0].row; iRow < sels[0].row + sels[0].rowCount; iRow++) {
  2267. let bDel = false;
  2268. const node = sortData[iRow];
  2269. if (node) {
  2270. const data = {id: node.id};
  2271. for (let iCol = sels[0].col; iCol < sels[0].col + sels[0].colCount; iCol++) {
  2272. const colSetting = sheet.zh_setting.cols[iCol];
  2273. if (colSetting.field === 'code') {
  2274. toastr.error('清单编号不能为空,如需删除签约清单请使用右键删除');
  2275. return;
  2276. }
  2277. const style = sheet.getStyle(iRow, iCol);
  2278. if (!style.locked) {
  2279. const colSetting = sheet.zh_setting.cols[iCol];
  2280. data[colSetting.field] = null;
  2281. bDel = true;
  2282. }
  2283. }
  2284. if (bDel) {
  2285. datas.push(data);
  2286. }
  2287. }
  2288. }
  2289. if (datas.length > 0) {
  2290. postData(self.url + '/update', {update: datas}, function (result) {
  2291. self.loadUpdateData(result);
  2292. SpreadJsObj.reLoadSheetData(sheet);
  2293. }, function () {
  2294. SpreadJsObj.reLoadSheetData(sheet);
  2295. });
  2296. }
  2297. },
  2298. delete: function (sheet) {
  2299. if (!sheet.zh_setting || readOnly || sheet.zh_setting.readOnly) return;
  2300. const sortData = sheet.zh_data;
  2301. const datas = [];
  2302. const sels = sheet.getSelections();
  2303. if (!sels || !sels[0]) return;
  2304. for (let iRow = sels[0].row, iLen = sels[0].row + sels[0].rowCount; iRow < iLen; iRow++) {
  2305. const node = sortData[iRow];
  2306. datas.push(node.id);
  2307. }
  2308. if (datas.length > 0) {
  2309. postData(self.url + '/update', {del: datas}, function (result) {
  2310. self.loadUpdateData(result);
  2311. SpreadJsObj.reLoadSheetData(sheet);
  2312. }, function () {
  2313. SpreadJsObj.reLoadSheetData(sheet);
  2314. });
  2315. }
  2316. },
  2317. editEnded: function (e, info) {
  2318. if (!info.sheet.zh_setting || !info.sheet.zh_data || info.sheet.zh_setting.readOnly) return;
  2319. const node = info.sheet.zh_data[info.row];
  2320. const col = info.sheet.zh_setting.cols[info.col];
  2321. const data = {};
  2322. if (node) {
  2323. data.update = {};
  2324. data.update.id = node.id;
  2325. const oldValue = node ? node[col.field] : null;
  2326. const newValue = trimInvalidChar(info.editingText);
  2327. if (oldValue == info.editingText || ((!oldValue || oldValue === '') && (newValue === ''))) {
  2328. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  2329. return;
  2330. }
  2331. data.update[col.field] = newValue;
  2332. } else {
  2333. if (col.field !== 'code') {
  2334. toastr.warning('新增签约清单,请先输入清单编号');
  2335. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  2336. return;
  2337. }
  2338. data.add = {};
  2339. data.add.order = info.row + 1;
  2340. data.add.code = trimInvalidChar(info.editingText);
  2341. }
  2342. postData(self.url + '/update', data, function (result) {
  2343. self.loadUpdateData(result);
  2344. SpreadJsObj.reLoadSheetData(info.sheet);
  2345. }, function () {
  2346. SpreadJsObj.reLoadRowData(info.sheet, info.row);
  2347. });
  2348. },
  2349. clipboardPasting(e, info) {
  2350. const setting = info.sheet.zh_setting, sortData = info.sheet.zh_data;
  2351. info.cancel = true;
  2352. if (!setting || !sortData || setting.readOnly) return;
  2353. const pasteData = info.pasteData.html
  2354. ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
  2355. : (info.pasteData.text === ''
  2356. ? SpreadJsObj.Clipboard.getAnalysisPasteText()
  2357. : SpreadJsObj.analysisPasteText(info.pasteData.text));
  2358. const hint = {
  2359. code: {type: 'warning', msg: '签约清单编号不可为空,已过滤'},
  2360. unit_price: {type: 'warning', msg: '输入的 单价 非法,已过滤'},
  2361. quantity: {type: 'warning', msg: '输入的 数量 非法,已过滤'},
  2362. };
  2363. const uDatas = [], iDatas = [];
  2364. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
  2365. const curRow = info.cellRange.row + iRow;
  2366. const node = sortData[curRow];
  2367. let bPaste = false;
  2368. const data = {};
  2369. for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
  2370. const curCol = info.cellRange.col + iCol;
  2371. const colSetting = setting.cols[curCol];
  2372. const value = trimInvalidChar(pasteData[iRow][iCol]);
  2373. if (colSetting.field === 'code' && (!value || value === '')) {
  2374. toastMessageUniq(hint.code);
  2375. break;
  2376. }
  2377. if (colSetting.type === 'Number') {
  2378. const num = _.toNumber(value);
  2379. if (num) {
  2380. data[colSetting.field] = num;
  2381. bPaste = true;
  2382. } else if (colSetting.field === 'unit_price') {
  2383. toastMessageUniq(hint.unit_price);
  2384. } else if (colSetting.field === 'quantity') {
  2385. toastMessageUniq(hint.quantity);
  2386. }
  2387. } else {
  2388. data[colSetting.field] = value;
  2389. bPaste = true;
  2390. }
  2391. }
  2392. if (bPaste) {
  2393. if (node) {
  2394. data.id = node.id;
  2395. uDatas.push(data);
  2396. } else {
  2397. data.order = curRow + 1;
  2398. iDatas.push(data);
  2399. }
  2400. }
  2401. }
  2402. const updateData = {};
  2403. if (uDatas.length > 0) updateData.update = uDatas;
  2404. if (iDatas.length > 0) updateData.add = iDatas;
  2405. if (uDatas.length > 0 || iDatas.length > 0) {
  2406. postData(self.url + '/update', updateData, function (result) {
  2407. self.loadUpdateData(result);
  2408. SpreadJsObj.reLoadSheetData(info.sheet);
  2409. });
  2410. } else {
  2411. SpreadJsObj.reLoadSheetData(info.sheet);
  2412. }
  2413. },
  2414. };
  2415. if (!readOnly) {
  2416. this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
  2417. const dealSheet = info.sheet;
  2418. if (!dealSheet.zh_setting.readOnly) return;
  2419. const mainSheet = ledgerSpread.getActiveSheet();
  2420. const dealBills = SpreadJsObj.getSelectObject(dealSheet);
  2421. if (!dealBills) { return; }
  2422. const mainTree = mainSheet.zh_tree;
  2423. const mainNode = SpreadJsObj.getSelectObject(mainSheet);
  2424. if (!mainNode || !mainTree) { return; }
  2425. if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
  2426. toastr.error('非最底层项目下,不应添加清单');
  2427. return;
  2428. }
  2429. postData(window.location.pathname + '/update', {
  2430. postType: 'add-deal',
  2431. postData: {
  2432. id: mainNode.ledger_id,
  2433. type: mainNode.code ? 'child' : 'next',
  2434. dealBills: {
  2435. b_code: dealBills.code, name: dealBills.name, unit: dealBills.unit,
  2436. unit_price: dealBills.unit_price,
  2437. }
  2438. },
  2439. }, function (result) {
  2440. const refreshData = mainTree.loadPostData(result);
  2441. treeOperationObj.refreshTree(mainSheet, refreshData);
  2442. const sel = mainSheet.getSelections()[0];
  2443. mainSheet.setSelection(refreshData.create[0].index, sel.col, sel.rowCount, sel.colCount);
  2444. SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, refreshData.create[0].index]);
  2445. treeOperationObj.refreshOperationValid(mainSheet);
  2446. ledgerSpread.focus();
  2447. posOperationObj.loadCurPosData();
  2448. });
  2449. });
  2450. this.spread.bind(spreadNS.Events.EditEnded, this.OprObj.editEnded);
  2451. this.spread.bind(spreadNS.Events.ClipboardPasting, this.OprObj.clipboardPasting);
  2452. SpreadJsObj.addDeleteBind(this.spread, this.OprObj.deletePress);
  2453. }
  2454. $('#upload-deal-bills').click(function () {
  2455. const file = $('#deal-bills-file')[0];
  2456. const formData = new FormData();
  2457. formData.append('file', file.files[0]);
  2458. postDataWithFileProgress(self.url+'/upload-excel', formData, function (data) {
  2459. self.data = data;
  2460. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
  2461. $('#upload-deal').modal('hide');
  2462. }, function () {
  2463. $('#upload-deal').modal('hide');
  2464. });
  2465. });
  2466. if (!readOnly) {
  2467. $.contextMenu({
  2468. selector: selector,
  2469. build: function ($trigger, e) {
  2470. const target = SpreadJsObj.safeRightClickSelection($trigger, e, self.spread);
  2471. return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
  2472. },
  2473. items: {
  2474. edit: {
  2475. name: '进入编辑模式',
  2476. icon: 'fa-edit',
  2477. visible: function (key, opt) {
  2478. return self.sheet.zh_setting.readOnly;
  2479. },
  2480. callback: function (key, opt) {
  2481. self.sheet.zh_setting.readOnly = false;
  2482. SpreadJsObj.refreshSheetReadOnly(self.sheet);
  2483. },
  2484. },
  2485. read: {
  2486. name: '退出编辑模式',
  2487. icon: 'fa-sign-out',
  2488. visible: function (key, opt) {
  2489. return !self.sheet.zh_setting.readOnly;
  2490. },
  2491. callback: function (key, opt) {
  2492. self.sheet.zh_setting.readOnly = true;
  2493. SpreadJsObj.refreshSheetReadOnly(self.sheet);
  2494. },
  2495. },
  2496. del: {
  2497. name: '删除',
  2498. icon: 'fa-times',
  2499. visible: function (key, opt) {
  2500. return !self.sheet.zh_setting.readOnly;
  2501. },
  2502. disabled: function (key, opt) {
  2503. const select = SpreadJsObj.getSelectObject(self.sheet);
  2504. return !select;
  2505. },
  2506. callback: function (key, opt) {
  2507. self.OprObj.delete(self.sheet);
  2508. },
  2509. },
  2510. sprEdit: '---------',
  2511. apply: {
  2512. name: '应用全部清单单价至台账',
  2513. icon: 'fa-magic',
  2514. disabled: function (key, opt) {
  2515. const sheet = self.spread.getActiveSheet();
  2516. return sheet.getRowCount() === 0;
  2517. },
  2518. callback: function (key, opt) {
  2519. const datas = [], sourceData = self.spread.getActiveSheet().zh_data;
  2520. for (const db of sourceData) {
  2521. const targets = ledgerTree.nodes.filter(function (x) {
  2522. return x.b_code === db.code && x.name === db.name && x.unit === db.unit;
  2523. });
  2524. for (const t of targets) {
  2525. if (t.children && t.children.length > 0) continue;
  2526. const data = ledgerTree.getNodeKeyData(t);
  2527. data.unit_price = db.unit_price;
  2528. datas.push(data);
  2529. }
  2530. }
  2531. if (datas.length > 0) {
  2532. postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
  2533. const refreshNode = ledgerTree.loadPostData(result);
  2534. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), refreshNode);
  2535. });
  2536. } else {
  2537. toastr.warning('没有可应用的清单。');
  2538. }
  2539. }
  2540. }
  2541. }
  2542. });
  2543. }
  2544. }
  2545. loadData () {
  2546. const self = this;
  2547. postData(this.url+'/get-data', {}, function (data) {
  2548. self.data = data;
  2549. SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
  2550. if (data.length > 0) self.spread.getActiveSheet().setSelection(0, 0, 1, 1);
  2551. });
  2552. }
  2553. calculateData () {
  2554. if (this.data) {
  2555. for (const d of this.data) {
  2556. d.total_price = _.multiply(d.quantity, d.unit_price);
  2557. }
  2558. }
  2559. }
  2560. loadUpdateData(updateData) {
  2561. if (updateData.add) {
  2562. for (const a of updateData.add) {
  2563. this.data.push(a);
  2564. }
  2565. }
  2566. if (updateData.update) {
  2567. for (const u of updateData.update) {
  2568. const d = this.data.find(function (x) {
  2569. return u.id === x.id;
  2570. });
  2571. if (d) {
  2572. _.assign(d, u);
  2573. } else {
  2574. this.data.push(d);
  2575. }
  2576. }
  2577. }
  2578. if (updateData.del) {
  2579. _.remove(this.data, function (d) {
  2580. return updateData.del.indexOf(d.id) >= 0;
  2581. });
  2582. }
  2583. }
  2584. }
  2585. class BatchInsertBillsPosObj {
  2586. constructor (obj) {
  2587. const self = this;
  2588. this.obj = obj;
  2589. this.billsCount = 6;
  2590. this.posCount = 1000;
  2591. this.filter = getLocalCache('zh-calc-batch-filter');
  2592. if (!this.filter) {
  2593. this.filter = '1';
  2594. }
  2595. $('input[name=batch-filter]')[0].checked = this.filter && this.filter != '0';
  2596. // 初始化 清单编号窗口 参数
  2597. this.qdSpreadSetting = {
  2598. cols: [
  2599. {title: '编号', field: 'code', hAlign: 0, width: 80, formatter: '@'},
  2600. {title: '名称', field: 'name', hAlign: 0, width: 120, formatter: '@'},
  2601. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
  2602. {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
  2603. {title: '图册号', field: 'name', hAlign: 0, width: 60, formatter: '@'},
  2604. ],
  2605. emptyRows: this.billsCount,
  2606. headRows: 1,
  2607. headRowHeight: [32],
  2608. headerFont: '12px 微软雅黑',
  2609. font: '12px 微软雅黑',
  2610. };
  2611. this.qdSpread = SpreadJsObj.createNewSpread($('.batch-l-t', this.obj)[0]);
  2612. // 初始化 部位数量复核表 参数
  2613. this.posSpreadSetting = {
  2614. cols: [
  2615. {title: '计量单元', field: 'bw', hAlign: 0, width: 80, formatter: '@'},
  2616. {title: '图册号', field: 'drawingCode', hAlign: 0, formatter: '@', width: 60},
  2617. ],
  2618. emptyRows: this.posCount,
  2619. headRows: 1,
  2620. headRowHeight: [32],
  2621. headerFont: '12px 微软雅黑',
  2622. font: '12px 微软雅黑',
  2623. };
  2624. for (let iNum = 1; iNum <= this.billsCount; iNum++) {
  2625. this.posSpreadSetting.cols.push(
  2626. {title: '清单' + iNum, field: 'bills' + iNum, hAlign: 2, width: 50}
  2627. )
  2628. }
  2629. this.posSpread = SpreadJsObj.createNewSpread($('.batch-l-b', this.obj)[0]);
  2630. // 初始化 签约清单 参数
  2631. this.dealSpreadSetting = {
  2632. cols: [
  2633. {title: '清单编号', field: 'code', width: 80, hAlign: 0, formatter: '@', readOnly: true},
  2634. {title: '名称', field: 'name', width: 230, hAlign: 0, formatter: '@', readOnly: true},
  2635. {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
  2636. {title: '单价', field: 'unit_price', hAlign: 2, width: 60, readOnly: true},
  2637. ],
  2638. emptyRows: 0,
  2639. headRows: 1,
  2640. headRowHeight: [32],
  2641. headerFont: '12px 微软雅黑',
  2642. font: '12px 微软雅黑',
  2643. };
  2644. this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r', this.obj)[0]);
  2645. // 初始化 清单编号、部位数量复核表 表格
  2646. this.initView();
  2647. SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting);
  2648. SpreadJsObj.refreshColumnAlign(this.dealSpread.getActiveSheet());
  2649. $.contextMenu({
  2650. selector: '.batch-l-t',
  2651. build: function ($trigger, e) {
  2652. const target = SpreadJsObj.safeRightClickSelection($trigger, e, self.qdSpread);
  2653. return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
  2654. },
  2655. items: {
  2656. 'create': {
  2657. name: '新增行',
  2658. icon: 'fa-sign-in',
  2659. callback: function (key, opt) {
  2660. const qdSheet = self.qdSpread.getActiveSheet();
  2661. const posSheet = self.posSpread.getActiveSheet();
  2662. qdSheet.addRows(qdSheet.getRowCount(), 1);
  2663. const index = qdSheet.getRowCount();
  2664. qdSheet.getCell(qdSheet.getRowCount() - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + index);
  2665. posSheet.addColumns(posSheet.getColumnCount(), 1);
  2666. posSheet.getCell(0, index + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + index);
  2667. },
  2668. },
  2669. 'delete': {
  2670. name: '删除行',
  2671. icon: 'fa-remove',
  2672. callback: function (key, opt) {
  2673. const qdSheet = self.qdSpread.getActiveSheet();
  2674. const posSheet = self.posSpread.getActiveSheet();
  2675. const sel = qdSheet.getSelections()[0];
  2676. qdSheet.deleteRows(sel.row, sel.rowCount);
  2677. posSheet.deleteColumns(sel.row + 2, sel.rowCount);
  2678. for (let iRow = 0, iLen = qdSheet.getRowCount(); iRow < iLen; iRow++) {
  2679. qdSheet.getCell(iRow, 0, spreadNS.SheetArea.rowHeader).text('清单' + (iRow+1));
  2680. }
  2681. for (let iCol = 0, iLen = posSheet.getColumnCount() - 2; iCol < iLen; iCol++) {
  2682. posSheet.getCell(0, iCol + 2, spreadNS.SheetArea.colHeader).text('清单' + (iCol+1));
  2683. }
  2684. qdSheet.setSelection(sel.row, sel.col, 1, 1);
  2685. },
  2686. },
  2687. }
  2688. });
  2689. // 拉取签约清单数据
  2690. if (dealBills) {
  2691. SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
  2692. } else {
  2693. postData('/tender/' + getTenderId() + '/deal/get-data', {}, function (data) {
  2694. SpreadJsObj.loadSheetData(self.dealSpread.getActiveSheet(), 'data', data);
  2695. });
  2696. }
  2697. // 双击签约清单,自动添加到清单编号窗口
  2698. this.dealSpread.bind(GC.Spread.Sheets.Events.CellDoubleClick, function (e, info) {
  2699. const deal = info.sheet.zh_data[info.row];
  2700. const qdSheet = self.qdSpread.getActiveSheet(), posSheet = self.posSpread.getActiveSheet();
  2701. const sel = qdSheet.getSelections()[0];
  2702. qdSheet.getCell(sel.row, 0).value(deal.code);
  2703. qdSheet.getCell(sel.row, 1).value(deal.name);
  2704. qdSheet.getCell(sel.row, 2).value(deal.unit);
  2705. qdSheet.getCell(sel.row, 3).value(deal.unit_price);
  2706. if (sel.row + 1 === qdSheet.getRowCount()) {
  2707. const count = sel.row + 2;
  2708. qdSheet.setRowCount(count);
  2709. qdSheet.getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count);
  2710. const colCount = posSheet.getColumnCount() + 1
  2711. posSheet.setColumnCount(colCount);
  2712. posSheet.getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('清单' + count);
  2713. }
  2714. qdSheet.setSelection(sel.row + 1, sel.col, 1, 1);
  2715. });
  2716. this.qdSpread.bind(spreadNS.Events.ClipboardPasted, function (e, info) {
  2717. const billsCount = info.sheet.getRowCount(), posSheet = self.posSpread.getActiveSheet();
  2718. const count = posSheet.getColumnCount() - 2;
  2719. if (billsCount > count) {
  2720. posSheet.setColumnCount(billsCount + 2);
  2721. for (let i = count + 1; i <= billsCount; i++) {
  2722. info.sheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i);
  2723. posSheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i);
  2724. }
  2725. }
  2726. if (info.cellRange.col === 0 && info.cellRange.colCount === 1) {
  2727. const dealBills = self.dealSpread.getActiveSheet().zh_data;
  2728. if (dealBills && dealBills.length > 0) {
  2729. for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
  2730. const curRow = iRow + info.cellRange.row;
  2731. const bills = _.find(dealBills, {code: info.sheet.getText(curRow, 0)});
  2732. if (bills) {
  2733. info.sheet.getCell(curRow, 1).value(bills.name);
  2734. info.sheet.getCell(curRow, 2).value(bills.unit);
  2735. info.sheet.getCell(curRow, 3).value(bills.unit_price);
  2736. }
  2737. }
  2738. }
  2739. }
  2740. });
  2741. this.posSpread.bind(spreadNS.Events.ClipboardPasted, function (e, info) {
  2742. const billsCount = info.sheet.getColumnCount() - 2, qdSheet = self.qdSpread.getActiveSheet();
  2743. const count = qdSheet.getRowCount();
  2744. if (billsCount > count) {
  2745. qdSheet.setRowCount(billsCount);
  2746. for (let i = count + 1; i <= billsCount; i++) {
  2747. qdSheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i);
  2748. info.sheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i);
  2749. }
  2750. }
  2751. });
  2752. this.qdSpread.bind(spreadNS.Events.EditEnded, function (e, info) {
  2753. if (info.col === 0) {
  2754. const dealBills = self.dealSpread.getActiveSheet().zh_data;
  2755. if (dealBills && dealBills.length > 0) {
  2756. const bills = _.find(dealBills, {code: info.editingText});
  2757. if (bills) {
  2758. info.sheet.getCell(info.row, 1).value(bills.name);
  2759. info.sheet.getCell(info.row, 2).value(bills.unit);
  2760. info.sheet.getCell(info.row, 3).value(bills.unit_price);
  2761. }
  2762. }
  2763. }
  2764. });
  2765. this.obj.bind('shown.bs.modal', function () {
  2766. self.qdSpread.refresh();
  2767. self.posSpread.refresh();
  2768. self.dealSpread.refresh();
  2769. });
  2770. $('#batch-ok').click(function () {
  2771. const sheet = ledgerSpread.getActiveSheet();
  2772. const sel = sheet.getSelections()[0];
  2773. const row = sel.row;
  2774. const select = ledgerTree.nodes[row];
  2775. if (select) {
  2776. const insertData = {};
  2777. insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next';
  2778. insertData.id = ledgerTree.getNodeKey(select);
  2779. insertData.batchData = self.getBatchData();
  2780. if (insertData.batchData.length > 0) {
  2781. postData(window.location.pathname + '/update', {postType: 'batch-insert', postData: insertData}, function (data) {
  2782. pos.updateDatas(data.pos);
  2783. const result = ledgerTree.loadPostData(data.ledger);
  2784. treeOperationObj.refreshTree(sheet, result);
  2785. sheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
  2786. SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, result.create[0].index]);
  2787. treeOperationObj.refreshOperationValid(sheet);
  2788. posOperationObj.loadCurPosData();
  2789. self.obj.modal('hide');
  2790. }, null, true);
  2791. } else {
  2792. self.obj.modal('hide');
  2793. }
  2794. }
  2795. });
  2796. $('input[name=batch-filter]').change(function () {
  2797. setLocalCache('zh-calc-batch-filter', this.checked ? 1 : 0);
  2798. });
  2799. }
  2800. // 初始化左侧表格
  2801. initView () {
  2802. // 初始化 清单编号
  2803. const qdSheet = this.qdSpread.getActiveSheet();
  2804. qdSheet.setColumnWidth(0, 45, spreadNS.SheetArea.rowHeader);
  2805. SpreadJsObj.initSheet(qdSheet, this.qdSpreadSetting);
  2806. SpreadJsObj.refreshColumnAlign(qdSheet);
  2807. // 清理原有数据
  2808. SpreadJsObj.beginMassOperation(qdSheet);
  2809. qdSheet.clear(0, 0, qdSheet.getRowCount(), qdSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  2810. for (let iRow = 1; iRow <= this.billsCount; iRow++) {
  2811. qdSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow);
  2812. }
  2813. qdSheet.setSelection(0, 0, 1 ,1);
  2814. SpreadJsObj.endMassOperation(qdSheet);
  2815. // 初始化 部位数量复核表
  2816. const posSheet = this.posSpread.getActiveSheet();
  2817. SpreadJsObj.initSheet(posSheet, this.posSpreadSetting);
  2818. SpreadJsObj.refreshColumnAlign(posSheet);
  2819. // 清理原有数据
  2820. SpreadJsObj.beginMassOperation(posSheet);
  2821. posSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader);
  2822. posSheet.clear(0, 0, posSheet.getRowCount(), posSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
  2823. posSheet.setSelection(0, 0, 1 ,1);
  2824. SpreadJsObj.endMassOperation(posSheet);
  2825. // 检查签约清单数据,以工具栏数据为准
  2826. if (dealBills) {
  2827. SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
  2828. }
  2829. this.dealSpread.getActiveSheet().setSelection(0, 0, 1, 1);
  2830. }
  2831. // 获取界面数据
  2832. getBatchData () {
  2833. const result = [];
  2834. const qdSheet = this.qdSpread.getActiveSheet(), posSheet = this.posSpread.getActiveSheet();
  2835. for (let iRow = 0; iRow < qdSheet.getRowCount(); iRow++) {
  2836. if (qdSheet.getText(iRow, 0) === '') { continue; }
  2837. const qd = {
  2838. b_code: qdSheet.getText(iRow, 0),
  2839. name: qdSheet.getText(iRow, 1),
  2840. unit: qdSheet.getText(iRow, 2),
  2841. price: _.toNumber(qdSheet.getText(iRow, 3)),
  2842. pos: [],
  2843. };
  2844. for (let iPosRow = 0; iPosRow < posSheet.getRowCount(); iPosRow++) {
  2845. const value = _.toNumber(posSheet.getText(iPosRow, iRow + 2));
  2846. if (value !== 0 && !isNaN(value)) {
  2847. qd.pos.push({
  2848. name: posSheet.getText(iPosRow, 0),
  2849. drawing_code: posSheet.getText(iPosRow, 1),
  2850. quantity: value, porder: qd.pos.length + 1,
  2851. });
  2852. }
  2853. }
  2854. if (!$('input[name=batch-filter]')[0].checked || qd.pos.length > 0) result.push(qd);
  2855. }
  2856. return result;
  2857. }
  2858. }
  2859. // $('#searchAccount').click(() => {
  2860. // const data = {
  2861. // keyword: $('#searchName').val(),
  2862. // };
  2863. // postData('/search/user', data, (data) => {
  2864. // const resultDiv = $('#searchResult');
  2865. // if (data) {
  2866. // $('h5>span', resultDiv).text(data.name);
  2867. // $('#addAuditor').attr('auditorId', data.id);
  2868. // $('h6', resultDiv).text(data.role);
  2869. // $('p', resultDiv).text(data.company);
  2870. // resultDiv.show();
  2871. // } else {
  2872. // toastr.info('未查询到该审核人');
  2873. // resultDiv.hide();
  2874. // }
  2875. // }, () => {
  2876. // $('#searchResult').hide();
  2877. // });
  2878. // });
  2879. // // 审批人分组选择
  2880. // $('#account_group').change(function () {
  2881. // let account_html = '<option value="0">选择审批人</option>';
  2882. // for (const account of accountList) {
  2883. // if (parseInt($(this).val()) === 0 || parseInt($(this).val()) === account.account_group) {
  2884. // const role = account.role !== '' ? '(' + account.role + ')' : '';
  2885. // const company = account.company !== '' ? ' -' + account.company : '';
  2886. // account_html += '<option value="' + account.id + '">' + account.name + role + company + '</option>';
  2887. // }
  2888. // }
  2889. // $('#account_list').html(account_html);
  2890. // });
  2891. let timer = null
  2892. let oldSearchVal = null
  2893. $('#gr-search').bind('input propertychange', function(e) {
  2894. oldSearchVal = e.target.value
  2895. timer && clearTimeout(timer)
  2896. timer = setTimeout(() => {
  2897. const newVal = $('#gr-search').val()
  2898. let html = ''
  2899. if (newVal && newVal === oldSearchVal) {
  2900. accountList.filter(item => item && (item.name.indexOf(newVal) !== -1 || (item.mobile && item.mobile.indexOf(newVal) !== -1))).forEach(item => {
  2901. html += `<dd class="border-bottom p-2 mb-0 " data-id="${item.id}" >
  2902. <p class="mb-0 d-flex"><span class="text-primary">${item.name}</span><span
  2903. class="ml-auto">${item.mobile || ''}</span></p>
  2904. <span class="text-muted">${item.role || ''}</span>
  2905. </dd>`
  2906. })
  2907. $('.book-list').empty()
  2908. $('.book-list').append(html)
  2909. } else {
  2910. if (!$('.acc-btn').length) {
  2911. accountGroup.forEach((group, idx) => {
  2912. if (!group) return
  2913. html += `<dt><a href="javascript: void(0);" class="acc-btn" data-groupid="${idx}" data-type="hide"><i class="fa fa-plus-square"></i>
  2914. </a> ${group.groupName}</dt>
  2915. <div class="dd-content" data-toggleid="${idx}">`
  2916. group.groupList.forEach(item => {
  2917. html += `<dd class="border-bottom p-2 mb-0 " data-id="${item.id}" >
  2918. <p class="mb-0 d-flex"><span class="text-primary">${item.name}</span><span
  2919. class="ml-auto">${item.mobile || ''}</span></p>
  2920. <span class="text-muted">${item.role || ''}</span>
  2921. </dd>`
  2922. });
  2923. html += '</div>'
  2924. })
  2925. $('.book-list').empty()
  2926. $('.book-list').append(html)
  2927. }
  2928. }
  2929. }, 400);
  2930. })
  2931. // 添加审批流程按钮逻辑
  2932. $('.book-list').on('click', 'dt', function () {
  2933. const idx = $(this).find('.acc-btn').attr('data-groupid')
  2934. const type = $(this).find('.acc-btn').attr('data-type')
  2935. if (type === 'hide') {
  2936. $(this).parent().find(`div[data-toggleid="${idx}"]`).show(() => {
  2937. $(this).children().find('i').removeClass('fa-plus-square').addClass('fa-minus-square-o')
  2938. $(this).find('.acc-btn').attr('data-type', 'show')
  2939. })
  2940. } else {
  2941. $(this).parent().find(`div[data-toggleid="${idx}"]`).hide(() => {
  2942. $(this).children().find('i').removeClass('fa-minus-square-o').addClass('fa-plus-square')
  2943. $(this).find('.acc-btn').attr('data-type', 'hide')
  2944. })
  2945. }
  2946. return false
  2947. })
  2948. // 添加到审批流程中
  2949. $('dl').on('click', 'dd', function () {
  2950. const auditorId = parseInt($(this).data('id'))
  2951. if (auditorId) {
  2952. postData('/tender/' + getTenderId() + '/ledger/audit/add', { auditorId }, (datas) => {
  2953. const html = [];
  2954. // 如果是重新上报,添加到重新上报列表中
  2955. const auditorshtml = [];
  2956. for (const [index,data] of datas.entries()) {
  2957. if (index !== 0) {
  2958. html.push('<li class="list-group-item" auditorId="' + data.audit_id + '">');
  2959. if (shenpi_status === shenpiConst.sp_status.sqspr || (shenpi_status === shenpiConst.sp_status.gdzs && index+1 !== datas.length)) {
  2960. html.push('<a href="javascript: void(0)" class="text-danger pull-right">移除</a>');
  2961. }
  2962. html.push('<span>');
  2963. html.push(data.audit_order + ' ');
  2964. html.push(data.name + ' ');
  2965. html.push('</span>');
  2966. html.push('<small class="text-muted">');
  2967. html.push(data.role);
  2968. html.push('</small></li>');
  2969. }
  2970. auditorshtml.push('<li class="list-group-item" ' + (index !== 0 ? 'data-auditorid="' + data.audit_id + '"' : '') + '>');
  2971. auditorshtml.push('<i class="fa ' + (index+1 === datas.length ? 'fa-stop-circle' : 'fa-chevron-circle-down') + '"></i> ');
  2972. auditorshtml.push(data.name + ' <small class="text-muted">' + data.role + '</small>');
  2973. if (index === 0) {
  2974. auditorshtml.push('<span class="pull-right">原报</span>');
  2975. } else if (index+1 === datas.length) {
  2976. auditorshtml.push('<span class="pull-right">终审</span>');
  2977. } else {
  2978. auditorshtml.push('<span class="pull-right">'+ transFormToChinese(index) +'审</span>');
  2979. }
  2980. auditorshtml.push('</li>');
  2981. }
  2982. $('#auditors').html(html.join(''));
  2983. $('#auditors-list').html(auditorshtml.join(''));
  2984. });
  2985. }
  2986. });
  2987. $('body').on('click', '#auditors li>a', function () {
  2988. const li = $(this).parent();
  2989. const data = {
  2990. auditorId: parseInt(li.attr('auditorId')),
  2991. };
  2992. postData('/tender/' + getTenderId() + '/ledger/audit/delete', data, (data2) => {
  2993. li.remove();
  2994. for (const a of data2) {
  2995. const aLi = $('li[auditorId=' + a.audit_id + ']');
  2996. $('span', aLi).text(a.audit_order + ' ' + a.name + ' ');
  2997. }
  2998. // 如果是重新上报
  2999. // 令最后一个图标转换
  3000. $('#auditors-list li[data-auditorid="' + data.auditorId + '"]').remove();
  3001. if ($('#auditors-list li').length !== 0 && !$('#auditors-list li i').hasClass('fa-stop-circle')) {
  3002. $('#auditors-list li').eq($('#auditors-list li').length-1).children('i')
  3003. .removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
  3004. }
  3005. // $('#auditors-list2 li[data-auditid="' + data.auditorId + '"]').remove();
  3006. // if ($('#auditors-list2 li').length !== 0 && !$('#auditors-list2 li i').hasClass('fa-stop-circle')) {
  3007. // $('#auditors-list2 li').eq($('#auditors-list2 li').length-1).children('i')
  3008. // .removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
  3009. // }
  3010. for (let i = 0; i < $('#auditors-list li').length; i++) {
  3011. $('#auditors-list li').eq(i).find('.pull-right').text(i === 0 ? '原报' : (i+1 === $('#auditors-list li').length ? '终' : transFormToChinese(i)) + '审')
  3012. // $('#auditors-list2 li').eq(i).find('.pull-right').text((i+1 === $('#auditors-list2 li').length ? '终' : transFormToChinese(i+1)) + '审')
  3013. }
  3014. });
  3015. });
  3016. $('#hideSp').click(function () {
  3017. $('#sp-list').modal('hide');
  3018. });
  3019. // 多层modal关闭后的滚动bug修复
  3020. $('#sp-list').on('hidden.bs.modal', function (e) {
  3021. $(document.body).addClass('modal-open');
  3022. });
  3023. // 显示层次
  3024. (function (select, sheet) {
  3025. $(select).click(function () {
  3026. const tag = $(this).attr('tag');
  3027. const tree = sheet.zh_tree;
  3028. if (!tree) return;
  3029. switch (tag) {
  3030. case "1":
  3031. case "2":
  3032. case "3":
  3033. case "4":
  3034. case "5":
  3035. tree.expandByLevel(parseInt(tag));
  3036. SpreadJsObj.refreshTreeRowVisible(sheet);
  3037. break;
  3038. case "last":
  3039. tree.expandByCustom(() => { return true; });
  3040. SpreadJsObj.refreshTreeRowVisible(sheet);
  3041. break;
  3042. case "leafXmj":
  3043. tree.expandToLeafXmj();
  3044. SpreadJsObj.refreshTreeRowVisible(sheet);
  3045. break;
  3046. }
  3047. });
  3048. })('a[name=showLevel]', ledgerSpread.getActiveSheet());
  3049. // $('#exportLedger').click(function () {
  3050. // const data = [];
  3051. // const setting = {
  3052. // header: ['项目节编号', '清单子目号', '部位明细', '名称', '单位', '清单数量', '设计数量1', '设计数量2', '单价', '合价', '图号', '备注'],
  3053. // width: [100, 70, 70, 300, 60, 80, 80, 80, 80, 80, 100, 100],
  3054. // hAlign: ['left', 'left', 'left', 'left','center', 'right', 'right', 'right', 'right', 'right', 'left', 'left'],
  3055. // };
  3056. // for (const node of ledgerTree.nodes) {
  3057. // data.push([node.code, node.b_code, '', node.name, node.unit,
  3058. // node.quantity, node.dgn_qty1, node.dgn_qty2, node.unit_price, node.total_price,
  3059. // node.drawing_code, node.memo
  3060. // ]);
  3061. // const posRange = pos.getLedgerPos(node.id);
  3062. // if (posRange && posRange.length > 0) {
  3063. // for (const [i, p] of posRange.entries()) {
  3064. // data.push(['', '', (i + 1) + '', p.name, '',
  3065. // p.quantity, '', '', '', '',
  3066. // p.drawing_code, p.memo
  3067. // ]);
  3068. // }
  3069. // }
  3070. // }
  3071. //
  3072. // XLSXObj.exportXlsxSheet(setting, data, "台账分解.xlsx");
  3073. // });
  3074. $('#exportLedger').click(function () {
  3075. const data = [];
  3076. const setting = {
  3077. cols: [
  3078. {title: '项目节编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 100, formatter: '@'},
  3079. {title: '清单子目号', colSpan: '1', rowSpan: '1', field: 'b_code', hAlign: 0, width: 70, formatter: '@'},
  3080. {title: '计量单元', colSpan: '1', rowSpan: '1', field: 'pos_code', hAlign: 1, width: 70, formatter: '@'},
  3081. {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 300, formatter: '@'},
  3082. {title: '单位', colSpan: '1', rowSpan: '1', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
  3083. {title: '清单数量', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'},
  3084. {title: '设计数量1', colSpan: '1', rowSpan: '1', field: 'dgn_qty1', hAlign: 2, width: 80, type: 'Number'},
  3085. {title: '设计数量2', colSpan: '1', rowSpan: '1', field: 'dgn_qty2', hAlign: 2, width: 80, type: 'Number'},
  3086. {title: '单价', colSpan: '1', rowSpan: '1', field: 'unit_price', hAlign: 2, width: 80, type: 'Number'},
  3087. {title: '合价', colSpan: '1', rowSpan: '1', field: 'total_price', hAlign: 2, width: 80, type: 'Number'},
  3088. {title: '图号', colSpan: '1', rowSpan: '1', field: 'drawing_code', hAlign: 0, width: 100, formatter: '@'},
  3089. {title: '备注', colSpan: '1', rowSpan: '1', field: 'memo', hAlign: 0, width: 100, formatter: '@'},
  3090. ],
  3091. headRows: 1,
  3092. headRowHeight: [32],
  3093. defaultRowHeight: 21,
  3094. headerFont: 'bold 10px 微软雅黑',
  3095. font: '10px 微软雅黑'
  3096. };
  3097. for (const node of ledgerTree.nodes) {
  3098. data.push({
  3099. code: node.code, b_code: node.b_code, name: node.name, unit: node.unit,
  3100. unit_price: node.unit_price, quantity: node.quantity, total_price: node.total_price,
  3101. dgn_qty1: node.dgn_qty1, dgn_qty2: node.dgn_qty2,
  3102. drawing_code: node.drawing_code, memo: node.memo
  3103. });
  3104. const posRange = pos.getLedgerPos(node.id);
  3105. if (posRange && posRange.length > 0) {
  3106. for (const [i, p] of posRange.entries()) {
  3107. data.push({
  3108. pos_code: (i + 1) + '', name: p.name,
  3109. quantity: p.quantity, drawing_code: p.drawing_code, memo: p.memo
  3110. });
  3111. }
  3112. }
  3113. }
  3114. SpreadExcelObj.exportSimpleXlsxSheet(setting, data, "台账分解.xlsx");
  3115. });
  3116. const dataChecker = DataChecker({
  3117. checkUrl: window.location.pathname + '/check',
  3118. completeData: function (data) {
  3119. pos.updateDatas({update: data.source.pos});
  3120. const loadResult = ledgerTree.loadPostData({update: data.source.bills});
  3121. treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
  3122. posOperationObj.loadCurPosData();
  3123. for (const e of data.error) {
  3124. e.serialNo = ledgerTree.getNodeIndex(ledgerTree.getItems(e.ledger_id)) + 1;
  3125. }
  3126. },
  3127. errorList: errorList,
  3128. });
  3129. $('[name=audit-start]').submit(function (e) {
  3130. if (checkAuditorFrom()) {
  3131. $(this).parent().parent().parent().modal('hide');
  3132. dataChecker.checkAndPost(this.action, {});
  3133. $('#hide-all').hide();
  3134. }
  3135. return false;
  3136. });
  3137. LedgerChecker({
  3138. ledgerTree: ledgerTree,
  3139. ledgerPos: pos,
  3140. checkList: checkList,
  3141. decimal: tenderInfo.decimal,
  3142. checkOption: {
  3143. sibling: { enable: 1 },
  3144. empty_code: { enable: 1 },
  3145. calc: {
  3146. enable: 1,
  3147. fields: ['sgfh_qty', 'qtcl_qty', 'sjcl_qty', 'quantity'],
  3148. },
  3149. zero: { enable: 1 },
  3150. tp: {
  3151. enable: 1,
  3152. fields: [
  3153. {qty: 'sgfh_qty', tp: 'sgfh_tp'},
  3154. {qty: 'sjcl_qty', tp: 'sjcl_tp'},
  3155. {qty: 'qtcl_qty', tp: 'qtcl_tp'},
  3156. {qty: 'quantity', tp: 'total_price'},
  3157. {qty: 'deal_qty', tp: 'deal_tp'},
  3158. ],
  3159. },
  3160. }
  3161. });
  3162. });
  3163. // 检查上报情况
  3164. function checkAuditorFrom () {
  3165. if ($('#auditors li').length === 0) {
  3166. if(shenpi_status === shenpiConst.sp_status.gdspl) {
  3167. toastr.error('请联系管理员添加审批人');
  3168. } else {
  3169. toastr.error('请先选择审批人,再上报数据');
  3170. }
  3171. return false;
  3172. } else {
  3173. $('#hide-all').show();
  3174. return true;
  3175. }
  3176. }