12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975297629772978297929802981298229832984298529862987298829892990299129922993299429952996299729982999300030013002300330043005300630073008300930103011301230133014301530163017301830193020302130223023302430253026302730283029303030313032303330343035303630373038303930403041304230433044304530463047304830493050305130523053305430553056305730583059306030613062306330643065306630673068306930703071307230733074307530763077307830793080308130823083308430853086308730883089309030913092309330943095309630973098309931003101310231033104310531063107310831093110311131123113311431153116311731183119312031213122312331243125312631273128312931303131313231333134313531363137313831393140314131423143314431453146314731483149315031513152315331543155315631573158315931603161316231633164316531663167316831693170317131723173317431753176317731783179318031813182318331843185318631873188318931903191319231933194319531963197319831993200320132023203320432053206320732083209321032113212321332143215321632173218321932203221322232233224322532263227322832293230323132323233323432353236323732383239324032413242324332443245324632473248324932503251325232533254325532563257325832593260326132623263326432653266326732683269327032713272327332743275327632773278327932803281328232833284328532863287328832893290329132923293329432953296329732983299330033013302330333043305330633073308330933103311331233133314331533163317331833193320332133223323332433253326332733283329333033313332333333343335333633373338333933403341334233433344334533463347334833493350335133523353335433553356335733583359336033613362336333643365336633673368336933703371337233733374337533763377337833793380338133823383338433853386338733883389339033913392339333943395339633973398339934003401340234033404340534063407340834093410341134123413341434153416341734183419342034213422342334243425342634273428342934303431343234333434343534363437343834393440344134423443344434453446344734483449345034513452345334543455345634573458345934603461346234633464346534663467346834693470347134723473347434753476347734783479348034813482348334843485348634873488348934903491349234933494349534963497349834993500350135023503350435053506350735083509351035113512351335143515351635173518351935203521352235233524352535263527352835293530353135323533353435353536353735383539354035413542354335443545354635473548354935503551355235533554355535563557355835593560356135623563356435653566356735683569357035713572357335743575357635773578357935803581358235833584358535863587358835893590359135923593359435953596359735983599360036013602360336043605360636073608360936103611361236133614361536163617361836193620362136223623362436253626362736283629363036313632363336343635363636373638363936403641364236433644364536463647364836493650365136523653365436553656365736583659366036613662366336643665366636673668366936703671367236733674367536763677367836793680368136823683368436853686368736883689369036913692369336943695369636973698369937003701370237033704370537063707370837093710371137123713371437153716371737183719372037213722372337243725372637273728372937303731373237333734373537363737373837393740374137423743374437453746374737483749375037513752375337543755375637573758375937603761376237633764376537663767376837693770377137723773377437753776377737783779378037813782378337843785378637873788378937903791379237933794379537963797379837993800380138023803380438053806380738083809381038113812381338143815381638173818381938203821382238233824382538263827382838293830383138323833383438353836383738383839384038413842384338443845384638473848384938503851385238533854385538563857385838593860386138623863386438653866386738683869387038713872387338743875387638773878387938803881388238833884388538863887388838893890389138923893389438953896389738983899390039013902390339043905390639073908390939103911391239133914391539163917391839193920392139223923392439253926392739283929393039313932393339343935393639373938393939403941394239433944394539463947394839493950395139523953395439553956395739583959396039613962396339643965396639673968396939703971397239733974397539763977397839793980398139823983398439853986398739883989399039913992399339943995399639973998399940004001400240034004400540064007400840094010401140124013401440154016401740184019402040214022402340244025402640274028402940304031403240334034403540364037403840394040404140424043404440454046404740484049405040514052405340544055405640574058405940604061406240634064406540664067406840694070407140724073407440754076407740784079408040814082408340844085408640874088408940904091409240934094409540964097409840994100410141024103410441054106410741084109411041114112411341144115411641174118411941204121412241234124412541264127412841294130413141324133413441354136413741384139414041414142414341444145414641474148414941504151415241534154415541564157415841594160416141624163416441654166416741684169417041714172417341744175417641774178417941804181418241834184418541864187418841894190419141924193419441954196419741984199420042014202420342044205420642074208420942104211421242134214421542164217421842194220422142224223422442254226422742284229423042314232423342344235423642374238423942404241424242434244424542464247424842494250425142524253425442554256425742584259426042614262426342644265426642674268426942704271427242734274427542764277427842794280428142824283428442854286428742884289429042914292429342944295429642974298429943004301430243034304430543064307430843094310431143124313431443154316431743184319432043214322432343244325432643274328432943304331433243334334433543364337433843394340434143424343434443454346434743484349435043514352435343544355435643574358435943604361436243634364436543664367436843694370437143724373437443754376437743784379438043814382438343844385438643874388438943904391439243934394439543964397439843994400440144024403440444054406440744084409441044114412441344144415441644174418441944204421442244234424442544264427442844294430443144324433443444354436443744384439444044414442444344444445444644474448444944504451445244534454445544564457445844594460446144624463446444654466446744684469447044714472447344744475447644774478447944804481448244834484448544864487448844894490449144924493449444954496449744984499450045014502450345044505450645074508450945104511451245134514451545164517451845194520452145224523452445254526452745284529453045314532453345344535453645374538453945404541454245434544454545464547454845494550455145524553455445554556455745584559456045614562456345644565456645674568456945704571457245734574457545764577457845794580458145824583458445854586458745884589459045914592459345944595459645974598459946004601460246034604460546064607460846094610461146124613461446154616461746184619462046214622462346244625462646274628462946304631463246334634463546364637463846394640464146424643464446454646464746484649465046514652465346544655465646574658465946604661466246634664466546664667466846694670467146724673467446754676467746784679468046814682468346844685468646874688468946904691469246934694469546964697469846994700470147024703470447054706470747084709471047114712471347144715471647174718471947204721472247234724472547264727472847294730473147324733473447354736473747384739474047414742474347444745474647474748474947504751475247534754475547564757475847594760476147624763476447654766476747684769477047714772 |
- /**
- * 台账相关js
- *
- * @author Mai
- * @date 2018/02/05
- * @version
- */
- const ckBillsSpread = window.location.pathname + '-billsSelect';
- function checkTzMeasureType () {
- return tender.measure_type === measureType.tz.value;
- }
- function getTenderId() {
- return window.location.pathname.split('/')[2];
- }
- const copyBlockTag = 'zh.calc.copyBlock';
- const invalidFields = {
- parent: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp', 'deal_qty', 'deal_tp', 'unit_price'],
- gcl: ['dgn_qty1', 'dgn_qty2'],
- posCode: ['b_code'],
- posCalc: ['sgfh_qty', 'sgfh_tp', 'sjcl_qty', 'sjcl_tp', 'qtcl_qty', 'qtcl_tp'],
- posXmj: ['code'],
- };
- function getExprInfo (field, converse = false) {
- const exprField = [
- {qty: 'sgfh_qty', expr: 'sgfh_expr'},
- {qty: 'sjcl_qty', expr: 'sjcl_expr'},
- {qty: 'qtcl_qty', expr: 'qtcl_expr'},
- ];
- if (converse) return _.find(exprField, { expr: field });
- return _.find(exprField, {qty: field});
- }
- function transExpr(expr) {
- return expr.replace('=', '').replace('%', '/100');
- }
- const checkOption = {
- sibling: { enable: 1 },
- empty_code: { enable: 1 },
- calc: {
- enable: 1,
- fields: ['sgfh_qty', 'qtcl_qty', 'sjcl_qty', 'quantity'],
- },
- zero: { enable: 1 },
- zeroPos: { enable: 1 },
- pos_drawingCode: { enable: 1 },
- tp: {
- enable: 1,
- fields: [
- {qty: 'sgfh_qty', tp: 'sgfh_tp'},
- {qty: 'sjcl_qty', tp: 'sjcl_tp'},
- {qty: 'qtcl_qty', tp: 'qtcl_tp'},
- {qty: 'quantity', tp: 'total_price'},
- {qty: 'deal_qty', tp: 'deal_tp'},
- ],
- },
- same_code: { enable: 1 },
- };
- $(document).ready(function() {
- let stdXmj, stdGcl, dealBills, searchLedger;
- autoFlashHeight();
- // 初始化台账
- const ledgerSpread = SpreadJsObj.createNewSpread($('#ledger-spread')[0]);
- const ledgerSheet = ledgerSpread.getActiveSheet();
- removeLocalCache('bills-fold');
- const treeSetting = {
- id: 'ledger_id',
- pid: 'ledger_pid',
- order: 'order',
- level: 'level',
- rootId: -1,
- keys: ['id', 'tender_id', 'ledger_id'],
- preUrl: '/tender/' + getTenderId() + '/ledger',
- //treeCacheKey: 'ledger_bills_fold' + '_' + getTenderId(),
- autoExpand: 3,
- // markFoldKey: 'bills-fold',
- // markFoldSubKey: window.location.pathname.split('/')[2],
- markExpandKey: 'bills-expand',
- markExpandSubKey: window.location.pathname.split('/')[2],
- calcFields: ['deal_tp', 'sgfh_tp', 'sjcl_tp', 'qtcl_tp', 'total_price'],
- };
- treeSetting.calcFun = function (node) {
- node.dgn_price = ZhCalc.round(ZhCalc.div(node.total_price, node.dgn_qty1), 2);
- };
- const ledgerTree = createNewPathTree('ledger', treeSetting);
- //初始化所有附件列表
- getAllList();
- // 初始化 计量单元
- const pos = new PosData({
- id: 'id', ledgerId: 'lid',
- });
- const posSpread = SpreadJsObj.createNewSpread($('#pos-spread')[0]);
- // 初始化 附属工程量
- const ancGcl = createAncillaryGcl({ id: 'id', masterId: 'lid', sort: [['g_order', 'asc']] });
- const ancGclSpread = SpreadJsObj.createNewSpread($('#anc-gcl-spread')[0]);
- const ancGclSheet = ancGclSpread.getActiveSheet();
- const billsTag = $.billsTag({
- relaTree: ledgerTree,
- selector: '#bills-tag',
- relaSpread: ledgerSpread,
- relaPosSpread: posSpread,
- updateUrl: window.location.pathname + '/tag',
- afterModify: function (nodes) {
- SpreadJsObj.repaintNodesRowHeader(ledgerSpread.getActiveSheet(), nodes);
- },
- afterLocated: function (lid, pos_id) {
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- if (pos_id) {
- const posSheet = posSpread.getActiveSheet();
- const relaPos = posSheet.zh_data.find(x => { return x.id === pos_id; });
- SpreadJsObj.locateData(posSheet, relaPos);
- }
- },
- afterShow: function () {
- ledgerSpread.refresh();
- if (posSpread) posSpread.refresh();
- if (ancGclSpread) ancGclSpread.refresh();
- },
- });
- const errorList = $.cs_errorList({
- tabSelector: '#error-list-tab',
- selector: '#error-list',
- relaSpread: ledgerSpread,
- storeKey: 'ledger-error-' + getTenderId(),
- afterLocated: function () {
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- },
- afterShow: function () {
- ledgerSpread.refresh();
- if (posSpread) posSpread.refresh();
- if (ancGclSpread) ancGclSpread.refresh();
- },
- });
- const checkList = $.ledger_checkList({
- id: 'check-list',
- tabSelector: '#check-list-tab',
- selector: '#check-list',
- relaSpread: ledgerSpread,
- storeKey: 'ledger-check-' + getTenderId(),
- checkType: getCheckType(checkOption),
- afterLocated: function () {
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- },
- afterShow: function () {
- ledgerSpread.refresh();
- if (posSpread) posSpread.refresh();
- if (ancGclSpread) ancGclSpread.refresh();
- },
- });
- const gclGather = $.cs_gclGather({
- selector: '#gcl-gather',
- id: 'gcl-gather',
- relaSheet: ledgerSpread.getActiveSheet(),
- });
- $.subMenu({
- menu: '#sub-menu', miniMenu: '#sub-mini-menu', miniMenuList: '#mini-menu-list',
- toMenu: '#to-menu', toMiniMenu: '#to-mini-menu',
- key: 'menu.1.0.0',
- miniHint: '#sub-mini-hint', hintKey: 'menu.hint.1.0.1',
- callback: function (info) {
- if (info.mini) {
- $('.panel-title').addClass('fluid');
- $('#sub-menu').removeClass('panel-sidebar');
- } else {
- $('.panel-title').removeClass('fluid');
- $('#sub-menu').addClass('panel-sidebar');
- }
- autoFlashHeight();
- ledgerSpread.refresh();
- if (posSpread) posSpread.refresh();
- if (ancGclSpread) ancGclSpread.refresh();
- if (stdXmj) stdXmj.spread.refresh();
- if (stdGcl) stdGcl.spread.refresh();
- if (dealBills) dealBills.spread.refresh();
- if (searchLedger) searchLedger.spread.refresh();
- if (errorList) errorList.spread.refresh();
- if (checkList) checkList.spread.refresh();
- if (gclGather) gclGather.spread.refresh();
- }
- });
- // 定义事件
- const treeOperationObj = {
- loadExprToInput(sheet) {
- const sel = sheet.getSelections()[0];
- const col = sheet.zh_setting.cols[sel.col], cell = sheet.getCell(sel.row, sel.col);
- if (col && col.type === 'Number') {
- const data = SpreadJsObj.getSelectObject(sheet);
- if (data) {
- const exprInfo = getExprInfo(col.field);
- if (exprInfo) {
- $('#bills-expr').val(data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field])
- .attr('field', col.field).attr('org', data[col.field]);
- } else {
- $('#bills-expr').val(data[col.field])
- .attr('field', col.field).attr('org', data[col.field]);
- }
- if (col.field.indexOf('dgn') >= 0) {
- $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (_.isString(data.b_code) && data.b_code !== ''));
- } else {
- const nodePos = pos.getLedgerPos(data.id);
- if (nodePos && nodePos.length > 0) {
- $('#bills-expr').val('').attr('readOnly', true);
- $('#bills-expr').removeAttr('data-row');
- } else {
- $('#bills-expr').attr('readOnly', readOnly || cell.locked() || (data.children && data.children.length > 0));
- }
- }
- $('#bills-expr').attr('data-row', sel.row);
- } else {
- $('#bills-expr').val('').attr('readOnly', true);
- $('#bills-expr').removeAttr('data-row');
- }
- } else {
- $('#bills-expr').val('').attr('readOnly', true);
- $('#bills-expr').removeAttr('data-row');
- }
- },
- getSelectNode: function (sheet) {
- if (!sheet || !sheet.zh_tree) {
- return null;
- } else {
- const sel = sheet.getSelections()[0];
- return sheet.zh_tree.nodes[sel.row];
- }
- },
- getDefaultSelectInfo: function (sheet) {
- const tree = sheet.zh_tree;
- if (!tree) return;
- const sel = sheet.getSelections()[0];
- const node = sheet.zh_tree.nodes[sel.row];
- if (!node) return;
- let count = 1;
- if (sel.rowCount > 1) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = sheet.zh_tree.nodes[sel.row + r];
- if (rNode.level > node.level) continue;
- if ((rNode.level < node.level) || (rNode.level === node.level && rNode.pid !== node.pid)) {
- toastr.error('请选择同一清单下的节点,进行该操作');
- return;
- }
- count += 1;
- }
- }
- return [tree, node, count];
- },
- /**
- * 刷新顶部按钮是否可用
- * @param sheet
- * @param selections
- */
- refreshOperationValid: function (sheet, selection) {
- const setObjEnable = function (obj, enable) {
- if (enable) {
- obj.removeClass('disabled');
- } else {
- obj.addClass('disabled');
- }
- };
- const invalidAll = function () {
- setObjEnable($('#insert'), false);
- setObjEnable($('#delete'), false);
- setObjEnable($('#up-move'), false);
- setObjEnable($('#down-move'), false);
- setObjEnable($('#up-level'), false);
- setObjEnable($('#down-level'), false);
- };
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const tree = sheet.zh_tree;
- if (!tree) {
- invalidAll();
- return;
- }
- const first = sheet.zh_tree.nodes[row];
- if (!first) {
- invalidAll();
- return;
- }
- let last = first, sameParent = true;
- if (sel.rowCount > 1 && first) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[row + r];
- if (!rNode) {
- sameParent = false;
- break;
- }
- if (rNode.level > first.level) continue;
- if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
- sameParent = false;
- break;
- }
- last = rNode;
- }
- }
- const preNode = tree.getPreSiblingNode(first);
- const valid = !sheet.zh_setting.readOnly;
- setObjEnable($('#insert'), valid && first && first.level > 1);
- setObjEnable($('#delete'), valid && first && sameParent && !(first.level === 1 && first.node_type));
- setObjEnable($('#up-move'), valid && first && sameParent && first.level > 1 && preNode);
- setObjEnable($('#down-move'), valid && first && sameParent && first.level > 1 && !tree.isLastSibling(last));
- if (checkTzMeasureType()) {
- const posRange = last ? pos.getLedgerPos(last.id) : [];
- setObjEnable($('#up-level'), valid && first && sameParent && tree.getParent(first) && first.level > 2 && ((!posRange || posRange.length === 0) || tree.isLastSibling(last)));
- const preNodePosRange = preNode ? pos.getLedgerPos(preNode.id) : [];
- setObjEnable($('#down-level'), valid && first && sameParent && first.level > 1 && preNode && (!preNodePosRange || preNodePosRange.length === 0));
- } else {
- setObjEnable($('#up-level'), valid && first && sameParent && first.level > 2 && tree.getParent(first));
- setObjEnable($('#down-level'), valid && first && sameParent && first.level > 1 && preNode);
- }
- setObjEnable($('#cut'), valid);
- setObjEnable($('#paste'), valid);
- },
- refreshTree: function (sheet, data) {
- SpreadJsObj.massOperationSheet(sheet, function () {
- const tree = sheet.zh_tree;
- // 处理删除
- if (data.delete) {
- data.delete.sort(function (x, y) {
- return y.deleteIndex - x.deleteIndex;
- });
- for (const d of data.delete) {
- sheet.deleteRows(d.deleteIndex, 1);
- }
- }
- // 处理新增
- if (data.create) {
- const newNodes = data.create;
- if (newNodes) {
- newNodes.sort(function (a, b) {
- return a.index - b.index;
- });
- for (const node of newNodes) {
- sheet.addRows(node.index, 1);
- SpreadJsObj.reLoadRowData(sheet, tree.nodes.indexOf(node), 1);
- }
- }
- }
- // 处理更新
- if (data.update) {
- const rows = [];
- for (const u of data.update) {
- rows.push(tree.nodes.indexOf(u));
- billsTag.refreshBillsTagView(u);
- }
- SpreadJsObj.reLoadRowsData(sheet, rows);
- }
- // 处理展开
- if (data.expand) {
- const expanded = [];
- for (const e of data.expand) {
- if (expanded.indexOf(e) === -1) {
- const posterity = tree.getPosterity(e);
- for (const p of posterity) {
- sheet.setRowVisible(tree.nodes.indexOf(p), p.visible);
- expanded.push(p);
- }
- }
- }
- }
- });
- },
- /**
- * 新增节点
- * @param spread
- */
- addNode: function (sheet, count = 1) {
- const self = this;
- const sel = sheet.getSelections()[0];
- const row = sheet.getSelections()[0].row;
- const tree = sheet.zh_tree;
- if (!tree) { return; }
- const node = sheet.zh_tree.nodes[row];
- if (!node) { return; }
- postData(window.location.pathname + '/update', {
- postType: 'add',
- postData: {
- id: tree.getNodeKey(node),
- count: count,
- }
- }, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- sheet.setSelection(refreshNode.create[0].index, sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, refreshNode.create[0].index]);
- self.refreshOperationValid(sheet);
- });
- },
- /**
- * 删除选中节点
- * @param spread
- */
- deleteNode: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'delete',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- deleteAfterHint(function () {
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- for (const d of refreshNode.delete) {
- pos.removeDatasByMasterId(d.id);
- ancGcl.removeDatasByMasterId(d.id);
- }
- self.refreshTree(sheet, refreshNode);
- self.refreshOperationValid(sheet);
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- billsTag.afterDeleteBills(refreshNode.delete);
- });
- });
- }
- },
- /**
- * 上移选中节点
- * @param spread
- */
- upMove: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'up-move',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- const sel = sheet.getSelections()[0];
- sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(node)]);
- self.refreshOperationValid(sheet);
- });
- }
- },
- /**
- * 下移选中节点
- * @param spread
- */
- downMove: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'down-move',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- const sel = sheet.getSelections()[0];
- sheet.setSelection(tree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, tree.nodes.indexOf(node)]);
- self.refreshOperationValid(sheet);
- });
- }
- },
- /**
- * 升级选中节点
- * @param spread
- */
- upLevel: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'up-level',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- self.refreshOperationValid(sheet);
- });
- }
- },
- /**
- * 降级选中节点
- * @param spread
- */
- downLevel: function (sheet) {
- const self = this;
- const [tree, node, count] = this.getDefaultSelectInfo(sheet);
- if (tree && node && count) {
- const data = {
- postType: 'down-level',
- postData: {
- id: tree.getNodeKey(node),
- count: count
- }
- };
- postData(window.location.pathname + '/update', data, function (result) {
- const refreshNode = tree.loadPostData(result);
- self.refreshTree(sheet, refreshNode);
- self.refreshOperationValid(sheet);
- });
- }
- },
- /**
- * 编辑单元格响应事件
- * @param {Object} e
- * @param {Object} info
- */
- editEnded: function (e, info) {
- if (info.sheet.zh_setting) {
- const col = info.sheet.zh_setting.cols[info.col];
- const sortData = info.sheet.zh_dataType === 'tree' ? info.sheet.zh_tree.nodes : info.sheet.zh_data;
- const node = sortData[info.row];
- const data = {
- id: node.id,
- tender_id: node.tender_id,
- ledger_id: node.ledger_id
- };
- // 未改变值则不提交
- const orgValue = node[col.field];
- const newValue = trimInvalidChar(info.editingText);
- if (orgValue == info.editingText || ((!orgValue || orgValue === '') && (newValue === ''))) {
- return;
- }
- // 台账模式,检查计量单元相关
- if (checkTzMeasureType()) {
- if (col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
- col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
- col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
- if (!node.children || node.children.length ===0) {
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- toastr.error('清单含有计量单元,请在计量单元输入数量');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- }
- if (col.field === 'b_code' && (info.editingText === '' || !info.editingText)) {
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- toastr.error('清单含有计量单元,请先删除计量单元,再删除清单编号');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- }
- if (col.field === 'node_type' && newValue && newValue !== '0' && newValue !== '19') {
- const sameNodeType = sortData.find(x => { return x.node_type == newValue; });
- if (sameNodeType) {
- toastr.error('已存在该费用类别,请勿重复选择');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- // 获取更新数据
- if (col.type === 'Number') {
- const exprInfo = getExprInfo(col.field);
- if (newValue) {
- const num = _.toNumber(newValue);
- if (_.isFinite(num)) {
- data[col.field] = num;
- } else {
- try {
- data[col.field] = math.evaluate(transExpr(newValue));
- if (exprInfo) {
- data[exprInfo.expr] = newValue;
- }
- } catch(err) {
- toastr.error('输入的表达式非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- } else {
- data[col.field] = null;
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- }
- } else {
- data[col.field] = newValue;
- }
- // 更新至服务器
- postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
- const refreshNode = ledgerTree.loadPostData(result);
- treeOperationObj.refreshTree(info.sheet, refreshNode);
- });
- }
- },
- /**
- * 粘贴单元格响应事件
- * @param e
- * @param info
- */
- clipboardPasted: function (e, info) {
- if (info.sheet.zh_setting && info.sheet.zh_dataType === 'tree') {
- const tree = info.sheet.zh_tree;
- if (!tree) { return; }
- const sortData = info.sheet.zh_tree.nodes;
- const datas = [], filterNodes = [];
- let bHint = false, bPaste;
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow ++) {
- bPaste = false;
- const curRow = info.cellRange.row + iRow;
- const node = sortData[curRow];
- if (node) {
- const data = info.sheet.zh_tree.getNodeKeyData(node);
- for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
- const curCol = info.cellRange.col + iCol;
- const colSetting = info.sheet.zh_setting.cols[curCol];
- const value = trimInvalidChar(info.sheet.getText(curRow, curCol));
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- if (value === '' && colSetting.field === 'b_code') {
- if (!bHint) {
- toastr.warning('清单含有计量单元,请先删除计量单元,再删除清单编号');
- bHint = true;
- }
- continue;
- }
- if (colSetting.field === 'sgfh_qty' || colSetting.field === 'sgfh_tp' ||
- colSetting.field === 'sjcl_qty' || colSetting.field === 'sjcl_tp' ||
- colSetting.field === 'qtcl_qty' || colSetting.field === 'qtcl_tp') {
- if (!bHint) {
- toastr.warning('清单含有计量单元,数量金额根据计量单元汇总计算所得,不可编辑');
- bHint = true;
- }
- continue;
- }
- }
- if (colSetting.type === 'Number') {
- const num = _.toNumber(value);
- if (num) {
- data[colSetting.field] = num;
- bPaste = true;
- } else {
- try {
- data[colSetting.field] = math.evaluate(transExpr(value));
- bPaste = true;
- } catch(err) {
- delete data[colSetting.field];
- if (!bHint) {
- toastr.warning('输入的表达式非法');
- bHint = true;
- }
- }
- }
- } else {
- data[colSetting.field] = value;
- bPaste = true;
- }
- }
- if (bPaste) {
- datas.push(data);
- } else {
- filterNodes.push(node);
- }
- }
- }
- if (datas.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = tree.loadPostData(result);
- if (refreshNode.update) {
- refreshNode.update = refreshNode.update.concat(filterNodes);
- }
- treeOperationObj.refreshTree(info.sheet, refreshNode);
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- });
- } else {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- }
- }
- },
- clipboardPasting: function (e, info) {
- const tree = info.sheet.zh_tree, setting = info.sheet.zh_setting;
- info.cancel = true;
- if (!setting || !tree) return;
- const pasteData = info.pasteData.html
- ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
- : (info.pasteData.text === ''
- ? SpreadJsObj.Clipboard.getAnalysisPasteText()
- : SpreadJsObj.analysisPasteText(info.pasteData.text));
- const hint = {
- invalidExpr: {type: 'warning', msg: '粘贴的表达式非法'},
- posCode: {type: 'warning', msg: '清单含有计量单元,不可粘贴清单编号为空'},
- posQty: {type: 'warning', msg: '清单含有计量单元,数量金额根据计量单元汇总计算所得,不可粘贴'},
- parent: {type: 'warning', msg: '含有子项的清单,不可粘贴数量、单价、金额'},
- gcl: {type: 'warning', msg: '工程量清单,不可粘贴项目节数量'},
- posXmj: {type: 'warning', msg: '清单含有计量单元,不可粘贴项目节编号'},
- // sameParent: {type: 'warning', msg: '仅可粘贴同层节点'},
- };
- const datas = [], filterNodes = [];
- let pid, level, filterRow = 0;
- for (let iRow = 0; iRow < info.cellRange.rowCount + filterRow; iRow++) {
- const curRow = info.cellRange.row + iRow;
- const node = tree.nodes[curRow];
- if (!node) continue;
- if (!pid) pid = node.ledger_pid;
- if (!level) level = node.level;
- // if (node.ledger_pid !== pid) {
- // toastMessageUniq(hint.sameParent);
- // filterRow+=1;
- // continue;
- // }
- if (node.level < level) break;
- let bPaste = false;
- const data = info.sheet.zh_tree.getNodeKeyData(node);
- for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
- const curCol = info.cellRange.col + iCol;
- const colSetting = info.sheet.zh_setting.cols[curCol];
- const value = trimInvalidChar(pasteData[iRow-filterRow][iCol]);
- const lPos = pos.getLedgerPos(node.id);
- if (node.children && node.children.length > 0 && invalidFields.parent.indexOf(colSetting.field) >= 0) {
- toastMessageUniq(hint.parent);
- continue;
- }
- if (!_.isEmpty(node.b_code) && invalidFields.gcl.indexOf(colSetting.field) >= 0) {
- toastMessageUniq(hint.gcl);
- continue;
- }
- if (lPos && lPos.length > 0) {
- if (value === '' && invalidFields.posCode.indexOf(colSetting.field) >= 0) {
- toastMessageUniq(hint.posCode);
- continue;
- }
- if (invalidFields.posCalc.indexOf(colSetting.field) >= 0) {
- toastMessageUniq(hint.posQty);
- continue;
- }
- if (value !== '' && invalidFields.posXmj.indexOf(colSetting.field) >= 0) {
- toastMessageUniq(hint.posXmj);
- continue;
- }
- }
- if (colSetting.type === 'Number') {
- const num = _.toNumber(value);
- if (num) {
- data[colSetting.field] = num;
- bPaste = true;
- } else {
- try {
- data[colSetting.field] = math.evaluate(transExpr(value));
- const exprInfo = getExprInfo(colSetting.field);
- if (exprInfo) {
- data[exprInfo.expr] = value;
- bPaste = true;
- }
- } catch(err) {
- toastMessageUniq(hint.invalidExpr);
- }
- }
- } else {
- data[colSetting.field] = value;
- bPaste = true;
- }
- }
- if (bPaste) {
- datas.push(data);
- } else {
- filterNodes.push(node);
- }
- }
- if (datas.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = tree.loadPostData(result);
- if (refreshNode.update) {
- refreshNode.update = refreshNode.update.concat(filterNodes);
- }
- treeOperationObj.refreshTree(info.sheet, refreshNode);
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- });
- } else {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- }
- },
- /**
- * 删除按钮响应事件
- * @param sheet
- */
- deletePress: function (sheet) {
- if (sheet.zh_setting && sheet.zh_dataType === 'tree') {
- const tree = sheet.zh_tree;
- if (!tree) { return; }
- const sortData = sheet.zh_tree.nodes;
- const datas = [], nodes = [];
- const sel = sheet.getSelections()[0];
- let bHint = false;
- for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
- const node = sortData[iRow];
- if (node) {
- let bDel = false;
- const data = sheet.zh_tree.getNodeKeyData(node);
- for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
- const col = sheet.zh_setting.cols[iCol];
- if (col.field === 'b_code' || col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
- col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
- col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- if (!bHint) {
- if (col.field === 'code') {
- toastr.warning('清单含有计量单元,请先删除计量单元,再删除清单编号');
- } else {
- toastr.warning('清单含有计量单元,数量金额根据计量单元汇总计算所得,不可删除');
- }
- bHint = true;
- }
- continue;
- }
- }
- const style = sheet.getStyle(iRow, iCol);
- if (!style.locked) {
- const colSetting = sheet.zh_setting.cols[iCol];
- data[colSetting.field] = null;
- const exprInfo = getExprInfo(colSetting.field);
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- bDel = true;
- }
- }
- if (bDel) {
- datas.push(data);
- nodes.push(node);
- }
- }
- }
- if (datas.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = tree.loadPostData(result);
- treeOperationObj.refreshTree(sheet, refreshNode);
- treeOperationObj.loadExprToInput(sheet);
- });
- }
- }
- },
- /**
- * 粘贴整块
- * @param spread
- * @param block
- */
- pasteBlock: function (spread, copyInfo) {
- const self = this;
- const sheet = spread.getActiveSheet();
- const sel = sheet.getSelections()[0];
- const row = sel.row;
- const tree = sheet.zh_tree;
- if (!tree) { return; }
- const node = tree.nodes[row];
- if (!node) { return; }
- postData(window.location.pathname + '/update', {
- postType: 'paste-block',
- postData: {
- id: tree.getNodeKey(node),
- tid: copyInfo.tid,
- block: copyInfo.block,
- }
- }, function (data) {
- pos.updateDatas(data.pos);
- if (data.ancGcl) ancGcl.updateDatas(data.ancGcl);
- const result = tree.loadPostData(data.ledger);
- self.refreshTree(sheet, result);
- sheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, result.create[0].index]);
- self.refreshOperationValid(sheet);
- removeLocalCache(copyBlockTag);
- }, null, true);
- },
- loadRelaData: function () {
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- posSearch.search($('#pos-keyword').val());
- treeOperationObj.loadExprToInput(ledgerSpread.getActiveSheet());
- },
- selectionChanged: function (e, info) {
- if (!info.oldSelections || !info.oldSelections[0] || info.newSelections[0].row !== info.oldSelections[0].row) {
- SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
- treeOperationObj.loadRelaData();
- // 全选去除
- $('#dqjiedian').find('.check-all-file').prop('checked', false);
- }
- SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
- },
- topRowChanged(e, info) {
- SpreadJsObj.saveTopAndSelect(info.sheet, ckBillsSpread);
- },
- cut: function (sheet, sel, callback) {
- if (!sheet || !sel) return;
- if (sel.colCount >= sheet.zh_setting.cols.length) {
- toastr.warning('请勿选中整行剪切');
- return;
- }
- const sortData = SpreadJsObj.getSortData(sheet), datas = [];
- for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
- const node = sortData[iRow];
- if (node) {
- const data = sheet.zh_tree.getNodeKeyData(node);
- for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
- const col = sheet.zh_setting.cols[iCol];
- if (col.field === 'b_code' || col.field === 'sgfh_qty' || col.field === 'sgfh_tp' ||
- col.field === 'sjcl_qty' || col.field === 'sjcl_tp' ||
- col.field === 'qtcl_qty' || col.field === 'qtcl_tp') {
- const lPos = pos.getLedgerPos(node.id);
- if (lPos && lPos.length > 0) {
- toastr.error('不可剪切');
- return;
- }
- }
- const style = sheet.getStyle(iRow, iCol);
- if (style.locked) {
- toastr.error('不可剪切');
- return;
- }
- const colSetting = sheet.zh_setting.cols[iCol];
- data[colSetting.field] = null;
- const exprInfo = getExprInfo(colSetting.field);
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- }
- datas.push(data);
- }
- }
- if (datas.length > 0) {
- callback();
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = sheet.zh_tree.loadPostData(result);
- treeOperationObj.refreshTree(sheet, refreshNode);
- });
- }
- },
- editStarting(e, info) {
- if (!info.sheet.zh_setting || !info.sheet.zh_tree) return;
- const tree = info.sheet.zh_tree;
- const col = info.sheet.zh_setting.cols[info.col];
- const node = info.sheet.zh_tree.nodes[info.row];
- if (!node) {
- info.cancel = true;
- return;
- }
- const exprInfo = getExprInfo(col.field);
- if (exprInfo) {
- if (node[exprInfo.expr] && node[exprInfo.expr] !== '') {
- info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]);
- }
- }
- switch (col.field) {
- case 'code':
- const posRange = pos.getLedgerPos(node.id);
- info.cancel = posRange && posRange.length > 0;
- break;
- case 'unit_price':
- case 'sgfh_qty':
- case 'sgfh_tp':
- case 'sjcl_qty':
- case 'sjcl_tp':
- case 'qtcl_qty':
- case 'qtcl_tp':
- case 'deal_qty':
- case 'deal_tp':
- info.cancel = node.children && node.children.length > 0;
- break;
- case 'dgn_qty1':
- case 'dgn_qty2':
- info.cancel = !_.isEmpty(node.b_code);
- break;
- case 'node_type':
- const parent = tree.getParent(node);
- if (parent) {
- info.cancel = false;
- // const topParent = tree.getTopParent(node);
- // info.cancel = [1, 5].indexOf(topParent.node_type) < 0;
- } else {
- info.cancel = true;
- }
- break;
- }
- },
- sortCode: function (sheet) {
- const tree = sheet.zh_tree;
- if (!tree) return;
- const select = SpreadJsObj.getSelectObject(sheet);
- if (!select || !select.code) return;
- const getChildSort = function (i, split) {
- if (i <= 0) throw '参数错误';
- switch(split) {
- case '0':
- return i < 10 ? split + i : i + '';
- case '-':
- default:
- return split + i;
- }
- };
- const recursiveSortCode = function (data, parentCode, children, split) {
- if (!children || children.length === 0) return;
- for (const [i, child] of children.entries()) {
- if (!child.b_code || child.b_code === '') {
- const code = parentCode + getChildSort(i + 1, split);
- const cData = tree.getNodeKeyData(child);
- cData.code = code;
- data.push(cData);
- if (!tree.isLeafXmj(child)) {
- recursiveSortCode(data, code, child.children, split);
- }
- }
- }
- };
- const data = [];
- recursiveSortCode(data, select.code, select.children, tree.getCodeSplit());
- if (data.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
- const refreshNode = tree.loadPostData(result);
- treeOperationObj.refreshTree(sheet, refreshNode);
- })
- }
- },
- batchReplace: function(orgInfo, newInfo) {
- const updateData = [];
- for (const d of ledgerTree.nodes) {
- if (!d.b_code) continue;
- const checkInfo = { code: d.b_code || '', name: d.name || '', unit: d.unit || '', unit_price: d.unit_price || 0 };
- if (_.isMatch(checkInfo, orgInfo)) {
- const data = ledgerTree.getNodeKeyData(d);
- data.b_code = newInfo.code;
- data.name = newInfo.name;
- data.unit = newInfo.unit;
- data.unit_price = newInfo.unit_price;
- updateData.push(data);
- }
- }
- if (updateData.length === 0) {
- toastr.warning('没有可以替换的数据');
- return;
- }
- postData(window.location.pathname + '/update', {postType: 'update', postData: updateData}, function (result) {
- const refreshNode = ledgerTree.loadPostData(result);
- treeOperationObj.refreshTree(ledgerSheet, refreshNode);
- });
- },
- };
- sjsSettingObj.setFxTreeStyle(ledgerSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
- if (thousandth) sjsSettingObj.setTpThousandthFormat(ledgerSpreadSetting);
- ledgerTreeCol.initSpreadSetting(ledgerSpreadSetting);
- ledgerSpreadSetting.headColWidth = [50];
- ledgerSpreadSetting.rowHeader = [
- {
- rowHeaderType: 'tag',
- setting: {
- indent: 14,
- tagSize: 0.8,
- tagFont: '8px 微软雅黑',
- getColor: function (index, data) {
- if (!data) return;
- return billsTag.getBillsTagsColor(data.id);
- },
- getTagHtml: function (index, data) {
- if (!data) return;
- const getHtml = function (list) {
- if (!list || list.length === 0) return '';
- const html = [];
- for (const l of list) {
- html.push('<div class="row mr-1">');
- html.push(`<div class="col-auto pr-1 ${l.tagClass}">`, '<i class="fa fa-tag"></i>', '</div>');
- html.push('<div class="col p-0">', '<p>', l.comment, '</p>', '</div>');
- html.push('</div>');
- }
- return html.join('');
- };
- return getHtml(billsTag.getBillsTagsInfo(data.id));
- }
- },
- },
- ];
- // ledgerSpreadSetting.cols.push(
- // {title: 'ledger_id', colSpan: '1', rowSpan: '2', field: 'ledger_id', hAlign: 2, width: 60, type: 'Number', readOnly: true},
- // {title: 'ledger_pid', colSpan: '1', rowSpan: '2', field: 'ledger_pid', hAlign: 2, width: 60, type: 'Number', readOnly: true},
- // {title: 'level', colSpan: '1', rowSpan: '2', field: 'level', hAlign: 2, width: 60, type: 'Number', readOnly: true},
- // {title: 'order', colSpan: '1', rowSpan: '2', field: 'order', hAlign: 2, width: 60, type: 'Number', readOnly: true},
- // {title: 'is_leaf', colSpan: '1', rowSpan: '2', field: 'is_leaf', hAlign: 2, width: 60, type: 'Number', readOnly: true},
- // {title: 'full_path', colSpan: '1', rowSpan: '2', field: 'full_path', hAlign: 2, width: 60, type: 'Number', readOnly: true},
- // {title: 'node_type', colSpan: '1', rowSpan: '2', field: 'node_type', hAlign: 2, width: 60, type: 'Number', readOnly: true}
- // );
- sjsSettingObj.setNodeTypeCol(ledgerSpreadSetting.cols, [{ field: 'node_type' }]);
- SpreadJsObj.initSheet(ledgerSpread.getActiveSheet(), ledgerSpreadSetting);
- SpreadJsObj.selChangedRefreshBackColor(ledgerSpread.getActiveSheet());
- // 绑定事件
- ledgerSpread.bind(spreadNS.Events.SelectionChanged, treeOperationObj.selectionChanged);
- ledgerSpread.bind(spreadNS.Events.TopRowChanged, treeOperationObj.topRowChanged);
- ledgerSpread.bind(spreadNS.Events.ClipboardChanging, function (e, info) {
- const copyText = SpreadJsObj.getFilterCopyText(info.sheet);
- SpreadJsObj.Clipboard.setCopyData(copyText);
- });
- if (!ledgerSpreadSetting.readOnly) {
- ledgerSpread.bind(spreadNS.Events.SelectionChanged, function (e, info) {
- treeOperationObj.refreshOperationValid(info.sheet, info.newSelections);
- });
- ledgerSpread.bind(spreadNS.Events.EditEnded, treeOperationObj.editEnded);
- SpreadJsObj.addDeleteBind(ledgerSpread, treeOperationObj.deletePress);
- ledgerSpread.bind(spreadNS.Events.ClipboardPasting, treeOperationObj.clipboardPasting);
- ledgerSpread.bind(spreadNS.Events.EditStarting, treeOperationObj.editStarting);
- SpreadJsObj.addCutEvents(ledgerSpread, treeOperationObj.cut);
- // 绑定 删除等 顶部按钮
- $('#insert').click(() => {
- treeOperationObj.addNode(ledgerSpread.getActiveSheet());
- });
- $('#delete').click(function () {
- treeOperationObj.deleteNode(ledgerSpread.getActiveSheet());
- });
- $('#up-move').click(function () {
- treeOperationObj.upMove(ledgerSpread.getActiveSheet());
- });
- $('#down-move').click(function () {
- treeOperationObj.downMove(ledgerSpread.getActiveSheet());
- });
- $('#up-level').click(function () {
- treeOperationObj.upLevel(ledgerSpread.getActiveSheet());
- });
- $('#down-level').click(function () {
- treeOperationObj.downLevel(ledgerSpread.getActiveSheet());
- });
- $('#copy').click(function () {
- ledgerSpread.commandManager().execute({
- cmd: 'copy',
- sheetName: ledgerSpread.getActiveSheet().name()
- });
- });
- $('#paste').click(function () {
- ledgerSpread.commandManager().execute({
- cmd: 'paste',
- sheetName: ledgerSpread.getActiveSheet().name()
- });
- });
- $('#cut').click(function () {
- ledgerSpread.commandManager().execute({
- cmd: 'cut',
- sheetName: ledgerSpread.getActiveSheet().name()
- });
- });
- $('#bills-expr').bind('change onblur', function () {
- const expr = $(this);
- const row = expr.attr('data-row') ? _.toInteger(expr.attr('data-row')) : -1;
- const select = ledgerTree.getItemsByIndex(row);
- if (!select) return;
- const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = trimInvalidChar(expr.val());
- if (orgValue === newValue || (!orgValue && newValue == '')) { return; }
- // 台账模式,检查计量单元相关
- if (checkTzMeasureType()) {
- if (field === 'sgfh_qty' || field === 'sgfh_tp' ||
- field === 'sjcl_qty' || field === 'sjcl_tp' ||
- field === 'qtcl_qty' || field === 'qtcl_tp') {
- if (!select.children || select.children.length === 0) {
- const lPos = pos.getLedgerPos(select.id);
- if (lPos && lPos.length > 0) {
- toastr.error('清单含有计量单元,请在计量单元输入数量');
- expr.val('');
- return;
- }
- }
- }
- }
- const data = {
- id: select.id,
- tender_id: select.tender_id,
- ledger_id: select.ledger_id
- };
- const exprInfo = getExprInfo(field);
- if (newValue !== '') {
- const num = _.toNumber(newValue);
- if (num) {
- data[field] = num;
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- } else {
- try {
- data[field] = math.evaluate(transExpr(newValue));
- if (exprInfo) {
- data[exprInfo.expr] = newValue;
- }
- } catch (err) {
- toastr.error('输入的表达式非法');
- return;
- }
- }
- } else {
- data[field] = null;
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- }
- // 更新至服务器
- postData(window.location.pathname + '/update', {postType: 'update', postData: data}, function (result) {
- const refreshNode = ledgerTree.loadPostData(result);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), refreshNode);
- });
- });
- }
- let batchInsertObj, contractExprObj;
- $.contextMenu.types.batchInsert = function (item, opt, root) {
- const self = this;
- if ($.isFunction(item.icon)) {
- item._icon = item.icon.call(this, this, $t, key, item);
- } else {
- if (typeof(item.icon) === 'string' && item.icon.substring(0, 3) === 'fa-') {
- // to enable font awesome
- item._icon = root.classNames.icon + ' ' + root.classNames.icon + '--fa fa ' + item.icon;
- } else {
- item._icon = root.classNames.icon + ' ' + root.classNames.icon + '-' + item.icon;
- }
- }
- this.addClass(item._icon);
- 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>')
- .appendTo(this);
- const $input = $obj.find('input');
- const event = () => {
- if (self.hasClass('context-menu-disabled')) return;
- item.batchInsert($input[0], root);
- };
- $obj.on('click', event).keypress(function (e) {if (e.keyCode === 13) { event(); }});
- $input.click((e) => {e.stopPropagation();})
- .keyup((e) => {if (e.keyCode === 13) item.batchInsert($input[0], root);})
- .on('input', function () {this.value = this.value.replace(/[^\d]/g, '');});
- };
- // $.contextMenu.types.switch = function (item, opt, root) {
- // const self = this;
- // if ($.isFunction(item.icon)) {
- // item._icon = item.icon.call(this, this, $t, key, item);
- // } else {
- // if (typeof(item.icon) === 'string' && item.icon.substring(0, 3) === 'fa-') {
- // // to enable font awesome
- // item._icon = root.classNames.icon + ' ' + root.classNames.icon + '--fa fa ' + item.icon;
- // } else {
- // item._icon = root.classNames.icon + ' ' + root.classNames.icon + '-' + item.icon;
- // }
- // }
- // const html = [];
- // html.push('<div>');
- // html.push('</div>');
- // const $obj = $('<div>' + item.name +)
- // };
- // 右键菜单
- const addTag = newTag({ledgerSheet: ledgerSpread.getActiveSheet(), posSheet: posSpread.getActiveSheet(), billsTag});
- const billsContextMenuOptions = {
- selector: '#ledger-spread',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, ledgerSpread);
- treeOperationObj.loadRelaData();
- return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
- },
- items: {},
- };
- if (!readOnly) {
- billsContextMenuOptions.items.create = {
- name: '新增',
- icon: 'fa-sign-in',
- callback: function (key, opt) {
- treeOperationObj.addNode(ledgerSpread.getActiveSheet());
- },
- disabled: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const tree = sheet.zh_tree;
- if (!tree) return true;
- const first = sheet.zh_tree.nodes[row];
- let last = first, sameParent = true;
- if (sel.rowCount > 1) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[sel.row + r];
- if (rNode.level > first.level) continue;
- if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
- sameParent = false;
- break;
- }
- last = rNode;
- }
- }
- const valid = !sheet.zh_setting.readOnly;
- return !(valid && first && first.level > 1);
- },
- visible: function (key, opt) {
- return !readOnly;
- }
- };
- billsContextMenuOptions.items.delete = {
- name: '删除',
- icon: 'fa-remove',
- callback: function (key, opt) {
- treeOperationObj.deleteNode(ledgerSpread.getActiveSheet());
- },
- disabled: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const tree = sheet.zh_tree;
- if (!tree) return true;
- const first = sheet.zh_tree.nodes[row];
- let last = first, sameParent = true;
- if (sel.rowCount > 1) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[sel.row + r];
- if (rNode.level > first.level) continue;
- if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
- sameParent = false;
- break;
- }
- last = rNode;
- }
- }
- const valid = !sheet.zh_setting.readOnly;
- return !(valid && first && sameParent && !(first.level === 1 && first.node_type));
- },
- visible: function (key, opt) {
- return !readOnly;
- }
- };
- billsContextMenuOptions.items.sprBase = '----';
- }
- if (!readOnly) {
- billsContextMenuOptions.items.batchInsert = {
- name: '批量插入',
- type: 'batchInsert',
- value: '2',
- icon: 'fa-sign-in',
- batchInsert: function (obj, root) {
- if (_.toNumber(obj.value) > _.toNumber(obj.max)) {
- obj.value = obj.max;
- toastr.warning('批量插入不可多于' + obj.max);
- } else if(_.toNumber(obj.value) < _.toNumber(obj.min)) {
- obj.value = obj.min;
- toastr.warning('批量插入不可少于' + obj.min);
- } else {
- treeOperationObj.addNode(ledgerSpread.getActiveSheet(), parseInt(obj.value));
- root.$menu.trigger('contextmenu:hide');
- }
- },
- disabled: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const tree = sheet.zh_tree;
- if (!tree) return true;
- const first = sheet.zh_tree.nodes[row];
- let last = first, sameParent = true;
- if (sel.rowCount > 1) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = tree.nodes[sel.row + r];
- if (rNode.level > first.level) continue;
- if ((rNode.level < first.level) || (rNode.level === first.level && rNode.pid !== first.pid)) {
- sameParent = false;
- break;
- }
- last = rNode;
- }
- }
- const valid = !sheet.zh_setting.readOnly;
- return !(valid && first && first.level > 1);
- },
- visible: function (key, opt) {
- return !readOnly;
- }
- };
- billsContextMenuOptions.items.batchInsertBillsPos = {
- name: '批量插入清单-计量单元',
- icon: 'fa-sign-in',
- disabled: function (key, opt) {
- if (!checkTzMeasureType()) return true;
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = ledgerTree.nodes[row];
- if (select) {
- if (select.code && select.code !== '') {
- return !ledgerTree.isLeafXmj(select);
- } else {
- const parent = ledgerTree.getParent(select);
- return !(parent && ledgerTree.isLeafXmj(parent));
- }
- } else {
- return true;
- }
- },
- callback: function (key, opt) {
- if (!batchInsertObj) {
- batchInsertObj = new BatchInsertBillsPosObj($('#batch'));
- } else {
- batchInsertObj.initView();
- }
- $('#batch').modal('show');
- },
- visible: function (key, opt) {
- return !readOnly;
- }
- };
- billsContextMenuOptions.items.batchReplace = {
- name: '批量替换清单',
- icon: 'fa-sign-in',
- callback: function(key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSheet);
- if (!node) return;
- BatchReplace.load(node.b_code, node.name, node.unit, node.unit_price, treeOperationObj.batchReplace);
- },
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSheet);
- return !node || !node.b_code;
- },
- visible: function (key, opt) {
- return !readOnly;
- }
- };
- billsContextMenuOptions.items.sprBatch = '----';
- }
- billsContextMenuOptions.items.copyBlock = {
- name: '复制整块',
- icon: 'fa-files-o',
- callback: function (key, opt) {
- /*ledgerSpread.commandManager().execute({
- cmd:"copy",
- sheetName:ledgerSpread.getActiveSheet().name()
- });*/
- treeOperationObj.block = [];
- const copyBlockList = [];
- const sheet = ledgerSpread.getActiveSheet();
- const sel = sheet.getSelections()[0];
- let iRow = sel.row;
- const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
- while (iRow < sel.row + sel.rowCount) {
- const node = sheet.zh_tree.nodes[iRow];
- if (node.ledger_pid !== pid) {
- toastr.error('仅可同时选中同层节点');
- return;
- }
- const posterity = sheet.zh_tree.getPosterity(node);
- iRow += posterity.length + 1;
- posterity.unshift(node);
- copyBlockList.push(sheet.zh_tree.getDefaultData(posterity));
- }
- for (const cbl of copyBlockList) {
- for (const b of cbl) {
- const posRange = pos.getLedgerPos(b.id);
- if (posRange && posRange.length > 0) b.pos = posRange;
- const gclRange = ancGcl.getPartData(b.id);
- if (gclRange && gclRange.length > 0) b.ancGcl = gclRange;
- }
- }
- setLocalCache(copyBlockTag, JSON.stringify({block: copyBlockList}));
- },
- visible: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = ledgerTree.nodes[row];
- return select;
- },
- disabled: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = ledgerTree.nodes[row];
- return select && select.level <= 1;
- }
- };
- billsContextMenuOptions.items.copyBlockXmj = {
- name: '复制整块(只复制项目节)',
- icon: 'fa-files-o',
- callback: function (key, opt) {
- treeOperationObj.block = [];
- const copyBlockList = [];
- const sheet = ledgerSpread.getActiveSheet();
- const sel = sheet.getSelections()[0];
- let iRow = sel.row;
- const pid = sheet.zh_tree.nodes[iRow].ledger_pid;
- while (iRow < sel.row + sel.rowCount) {
- const node = sheet.zh_tree.nodes[iRow];
- if (node.ledger_pid !== pid) {
- toastr.error('仅可同时选中同层节点');
- return;
- }
- const posterity = sheet.zh_tree.getPosterity(node);
- iRow += posterity.length + 1;
- const copyPosterity = posterity.filter(x => { return !x.b_code; });
- copyPosterity.unshift(node);
- const copyData = sheet.zh_tree.getDefaultData(copyPosterity);
- for (const p of copyData) {
- const children = copyData.filter(y => {return y.ledger_pid === p.ledger_id}) || [];
- p.is_leaf = children.length === 0;
- }
- copyBlockList.push(copyData);
- }
- setLocalCache(copyBlockTag, JSON.stringify({block: copyBlockList}));
- },
- visible: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = ledgerTree.nodes[row];
- return select;
- },
- disabled: function (key, opt) {
- const sheet = ledgerSpread.getActiveSheet();
- const selection = sheet.getSelections();
- const row = selection[0].row;
- const select = ledgerTree.nodes[row];
- return select && select.level <= 1;
- }
- };
- if (!readOnly) {
- billsContextMenuOptions.items.pasteBlock = {
- name: '粘贴整块',
- icon: 'fa-clipboard',
- disabled: function (key, opt) {
- //const block = treeOperationObj.block || [];
- const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
- return !(copyInfo && copyInfo.block && copyInfo.block.length > 0);
- },
- callback: function (key, opt) {
- //const block = treeOperationObj.block || [];
- const copyInfo = JSON.parse(getLocalCache(copyBlockTag));
- if (copyInfo.block.length > 0) {
- treeOperationObj.pasteBlock(ledgerSpread, copyInfo);
- } else {
- document.execCommand('paste');
- }
- },
- visible: function (key, opt) {
- return !readOnly;
- }
- };
- }
- billsContextMenuOptions.items.sprBlock = '----';
- if (!readOnly) {
- billsContextMenuOptions.items.sortChildren = {
- name: '顺序重排子项编号',
- icon: 'fa-sort-numeric-asc',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- return !node || !node.code || !node.children || node.children === 0 || node.code.length < 3;
- },
- callback: function (key, opt) {
- treeOperationObj.sortCode(ledgerSpread.getActiveSheet());
- },
- visible: function (key, opt) {
- return !readOnly;
- }
- };
- if (!checkTzMeasureType()) {
- billsContextMenuOptions.items.applyDeal2Sgfh = {
- name: '填设计量',
- icon: 'fa-pencil',
- callback: function (key, opt) {
- postData(window.location.pathname + '/deal2sgfh', null, function (result) {
- ledgerTree.loadDatas(result.bills);
- treeCalc.calculateAll(ledgerTree);
- SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
- });
- }
- };
- }
- billsContextMenuOptions.items.sprSort = '----';
- }
- if (!readOnly) {
- const tenderSelect = TenderSelect({
- type: 'ledger',
- afterLoad: function (result) {
- const ledgerSheet = ledgerSpread.getActiveSheet();
- const refreshNode = ledgerTree.loadPostData(result);
- treeOperationObj.refreshTree(ledgerSheet, refreshNode);
- treeOperationObj.refreshOperationValid(ledgerSheet);
- }
- });
- billsContextMenuOptions.items.importExcel = {
- name: '导入分项清单Excel',
- icon: 'fa-file-excel-o',
- disabled: function (key, opt) {
- return readOnly;
- },
- callback: function (key, opt) {
- importExcel.doImport({
- template: {
- hint: '0号台账',
- url: 'https://jl-assets.oss-cn-shenzhen.aliyuncs.com/template/A/导入分项清单EXCEL格式.xlsx',
- },
- filter: true,
- callback: function (sheet, filter) {
- postDataCompress(window.location.pathname + '/upload-excel/tz', {sheet, filter}, function (result) {
- ledgerTree.loadDatas(result.bills);
- treeCalc.calculateAll(ledgerTree);
- SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
- pos.loadDatas(result.pos);
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- checkShowLast(result.bills.length);
- }, null);
- },
- // callback: function (file, select) {
- // const formData = new FormData();
- // formData.append('file', file.files[0]);
- // postDataWithFileProgress(window.location.pathname + '/upload-excel?ueType=tz&sheetName=' + select, formData, function (result) {
- // ledgerTree.loadDatas(result.bills);
- // treeCalc.calculateAll(ledgerTree);
- // SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
- // pos.loadDatas(result.pos);
- // posOperationObj.loadCurPosData();
- // }, null);
- // }
- //u_type: importExcel.uploadType.file,
- });
- }
- };
- billsContextMenuOptions.items.importGclBills2Xmj = {
- name: '导入工程量清单至项目节',
- icon: 'fa-file-excel-o',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- return readOnly || !node
- || (node.children && node.children.length > 0)
- || (!_.isNil(node.b_code) && node.b_code !== '');
- },
- callback: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- importExcel.doImport({
- template: {
- hint: '工程量清单',
- url: '/template/导入工程量清单EXCEL格式.xls',
- },
- callback: function (sheet) {
- postDataCompress(window.location.pathname + '/upload-excel/gcl2xmj', {id: node.id, sheet: sheet}, function (result) {
- const ledgerSheet = ledgerSpread.getActiveSheet();
- const sel = ledgerSheet.getSelections();
- const refreshNode = ledgerTree.loadPostData(result);
- treeOperationObj.refreshTree(ledgerSheet, refreshNode);
- if (refreshNode.create[0]) {
- if (sel && sel[0]) {
- ledgerSheet.setSelection(refreshNode.create[0].index, sel[0].col, sel[0].rowCount, sel[0].colCount);
- SpreadJsObj.reloadRowsBackColor(ledgerSheet, [sel[0].row, refreshNode.create[0].index]);
- } else {
- ledgerSheet.setSelection(refreshNode.create[0].index, 0, 1, 1);
- SpreadJsObj.reloadRowsBackColor(ledgerSheet, [refreshNode.create[0].index]);
- }
- }
- treeOperationObj.refreshOperationValid(ledgerSheet);
- }, null);
- }
- });
- }
- };
- billsContextMenuOptions.items.importOtherTender = {
- name: '导入(其他标段)工程量清单至项目节',
- icon: 'fa-link',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- return readOnly || !node
- || (node.children && node.children.length > 0)
- || !ledgerTree.isLeafXmj(node);
- },
- callback: function (key, opt) {
- tenderSelect.showSelect(SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet()));
- }
- };
- billsContextMenuOptions.items.sprImport = '----';
- }
- billsContextMenuOptions.items.tag = {
- name: '书签',
- callback: function (key, opt, menu, e) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- addTag.do(node);
- },
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- return !node;
- }
- };
- billsContextMenuOptions.items.sprTag = '----';
- billsContextMenuOptions.items.showLast = {
- name: '显示至最底层',
- callback: function (key, opt, menu, e) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- setTimeout(() => {
- showWaitingView();
- ledgerTree.expandByCustom(x => {
- return x.expanded ||(x.id === node.id) || (x.full_path.indexOf(node.ledger_id + '-') >= 0);
- });
- SpreadJsObj.refreshTreeRowVisible(ledgerSpread.getActiveSheet());
- closeWaitingView();
- }, 100);
- },
- };
- billsContextMenuOptions.items.exportJSON = {
- name: '导出后台标准表json',
- callback: function (key, opt, menu, e) {
- const result = [];
- for (const node of ledgerTree.nodes) {
- result.push({
- id: node.ledger_id, pid: node.ledger_pid, level: node.level, order: node.order,
- is_leaf: !node.children || node.children.length === 0, full_path: node.full_path,
- code: node.code || '', b_code: node.b_code || '', name: node.name || '', unit: node.unit || '',
- node_type: node.node_type,
- });
- }
- const blob = new Blob([JSON.stringify(result, '', '\t')], { type: 'application/text'});
- saveAs(blob, "台账分解.json");
- },
- visible: function() {
- return is_debug;
- }
- };
- if (contractExpr && readOnly) {
- billsContextMenuOptions.items.exprTag = '----';
- billsContextMenuOptions.items.contractExpr = {
- name: '预设本期合同计量公式',
- callback: function (key, opt, menu, e) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- if (!contractExprObj) {
- contractExprObj = new ContractExpr({ sourceTree: ledgerTree });
- }
- contractExprObj.initView(node);
- $('#contract_expr').modal('show');
- },
- visible: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- if (node.children && node.children.length > 0) return false;
- const posRange = pos.getLedgerPos(node.id);
- if (posRange && posRange.length > 0) return false;
- return true;
- }
- };
- }
- $.contextMenu(billsContextMenuOptions);
- const posSearch = $.posSearch({selector: '#pos-search', searchSpread: posSpread});
- // 台账模式加载计量单元数据
- if (checkTzMeasureType()) {
- $.divResizer({
- select: '#main-resize',
- callback: function () {
- ledgerSpread.refresh();
- let bcontent = $(".bcontent-wrap") ? $(".bcontent-wrap").height() : 0;
- $(".sp-wrap").height(bcontent-30);
- posSpread.refresh();
- if (ancGclSpread) ancGclSpread.refresh();
- }
- });
- sjsSettingObj.setGridSelectStyle(posSpreadSetting);
- }
- posSpreadSetting.headColWidth = [50];
- posSpreadSetting.rowHeader = [
- {
- rowHeaderType: 'tag',
- setting: {
- indent: 14,
- tagSize: 0.8,
- tagFont: '8px 微软雅黑',
- getColor: function (index, data) {
- if (!data) return;
- return billsTag.getPosTagsColor(data.lid, data.id);
- },
- getTagHtml: function (index, data) {
- if (!data) return;
- const getHtml = function (list) {
- if (!list || list.length === 0) return '';
- const html = [];
- for (const l of list) {
- html.push('<div class="row mr-1">');
- html.push(`<div class="col-auto pr-1 ${l.tagClass}">`, '<i class="fa fa-tag"></i>', '</div>');
- html.push('<div class="col p-0">', '<p>', l.comment, '</p>', '</div>');
- html.push('</div>');
- }
- return html.join('');
- };
- return getHtml(billsTag.getPosTagsInfo(data.lid, data.id));
- }
- },
- },
- ];
- SpreadJsObj.initSheet(posSpread.getActiveSheet(), posSpreadSetting);
- //绑定计量单元编辑事件
- const posOperationObj = {
- /**
- * 刷新顶部按钮是否可用
- * @param sheet
- * @param selections
- */
- refreshOperationValid: function (sheet, selection) {
- const setObjEnable = function (obj, enable) {
- if (enable) {
- obj.removeClass('disabled');
- } else {
- obj.addClass('disabled');
- }
- };
- const invalidAll = function () {
- setObjEnable($('a[name=pos-opr][type=up-move]'), false);
- setObjEnable($('a[name=pos-opr][type=down-move]'), false);
- };
- const sel = selection ? selection[0] : sheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const first = sheet.zh_data[row];
- if (!first) {
- invalidAll();
- return;
- }
- let last = first;
- if (sel.rowCount > 1 && first) {
- for (let r = 1; r < sel.rowCount; r++) {
- const rNode = sheet.zh_data[sel.row + r];
- if (!rNode) break;
- last = rNode;
- }
- }
- const preNode = sheet.zh_data[row - 1];
- const valid = !sheet.zh_setting.readOnly;
- setObjEnable($('a[name=pos-opr][type=up-move]'), valid && first && preNode);
- setObjEnable($('a[name=pos-opr][type=down-move]'), valid && first && (sheet.zh_data.indexOf(last) < sheet.zh_data.length - 1));
- },
- editStarting: function (e, info) {
- posOperationObj.ledgerTreeNode = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- const sel = info.sheet.getSelections();
- if (!sel || !sel[0]) return;
- const col = info.sheet.zh_setting.cols[sel[0].col];
- const node = SpreadJsObj.getSelectObject(info.sheet);
- const exprInfo = getExprInfo(col.field);
- if (exprInfo) {
- if (node[exprInfo.expr] && node[exprInfo.expr] !== '') {
- info.sheet.getCell(info.row, info.col).text(node[exprInfo.expr]);
- }
- }
- },
- loadExprToInput: function () {
- const sheet = posSpread.getActiveSheet();
- const sel = sheet.getSelections()[0];
- if (!sel || !sheet.zh_setting) return;
- const col = sheet.zh_setting.cols[sel.col], cell = sheet.getCell(sel.row, sel.col);
- if (col && col.type === 'Number') {
- const data = SpreadJsObj.getSelectObject(sheet);
- if (data) {
- const exprInfo = getExprInfo(col.field);
- const value = exprInfo
- ? (data[exprInfo.expr] ? data[exprInfo.expr] : data[col.field])
- : data[col.field];
- $('#pos-expr').val(value).attr('field', col.field).attr('org', data[col.field])
- .attr('readOnly', readOnly || cell.locked()).attr('data-row', sel.row);
- } else {
- $('#pos-expr').val('').attr('readOnly', true);
- $('#pos-expr').removeAttr('data-row');
- }
- } else {
- $('#pos-expr').val('').attr('readOnly', true);
- $('#pos-expr').removeAttr('data-row');
- }
- },
- /**
- * 加载计量单元 根据当前台账选择节点
- */
- loadCurPosData: function () {
- //spreadJsObj.reinitSheet(posSpread.getActiveSheet());
- const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
- if (node) {
- const posData = pos.ledgerPos[itemsPre + node.id] || [];
- SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', posData);
- getNodeList(node.id);
- } else {
- SpreadJsObj.loadSheetData(posSpread.getActiveSheet(), 'data', []);
- }
- posOperationObj.loadExprToInput();
- posOperationObj.refreshOperationValid(posSpread.getActiveSheet());
- },
- baseOpr: function (sheet, type) {
- const data = {
- updateType: type === 'delete' ? type : 'update',
- updateData: [],
- };
- const selection = sheet.getSelections();
- const row = selection[0].row, count = selection[0].rowCount;
- const first = sheet.zh_data[row];
- if (type === 'delete') {
- for (let iRow = 0; iRow < count; iRow++) {
- const posData = sheet.zh_data[iRow + row];
- if (posData) {
- data.updateData.push(sheet.zh_data[iRow + row].id);
- }
- }
- } else if (type === 'up-move') {
- const pre = sheet.zh_data[row - 1], preUpdate = {id: pre.id};
- for (let iRow = 0; iRow < count; iRow++) {
- const posData = sheet.zh_data[iRow + row];
- if (posData) {
- data.updateData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row - 1].porder});
- preUpdate.porder = posData.porder;
- }
- }
- data.updateData.push(preUpdate);
- } else if (type === 'down-move') {
- const next = sheet.zh_data[row + count], nextUpdate = {id: next.id};
- for (let iRow = count - 1; iRow >= 0; iRow--) {
- const posData = sheet.zh_data[iRow + row];
- if (posData) {
- data.updateData.push({id: posData.id, lid: posData.lid, porder: sheet.zh_data[iRow + row + 1].porder});
- nextUpdate.porder = posData.porder;
- }
- }
- data.updateData.push(nextUpdate);
- }
- if (data.updateData.length > 0) {
- postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
- if (type === 'delete') {
- for (const p of result.pos) {
- const posInfo = pos.getPos(p);
- billsTag.afterDeletePos([posInfo]);
- }
- pos.removeDatas(result.pos);
- sheet.deleteRows(row, count);
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- } else {
- const updateRst = pos.updateDatas(result.pos);
- billsTag.refreshPosTagView(updateRst.update);
- const sel = selection[0];
- if (sel) {
- sheet.setSelection(sheet.zh_data.indexOf(first), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, sheet.zh_data.indexOf(first)]);
- }
- posOperationObj.loadCurPosData();
- }
- });
- }
- },
- /**
- * 编辑单元格响应事件
- * @param {Object} e
- * @param {Object} info
- */
- editEnded: function (e, info) {
- if (info.sheet.zh_setting) {
- const posData = info.sheet.zh_data ? info.sheet.zh_data[info.row] : null;
- const col = info.sheet.zh_setting.cols[info.col];
- const orgText = posData ? posData[col.field] : null;
- const newText = trimInvalidChar(info.editingText);
- if (orgText === newText || ((!orgText || orgText === '') && (newText === ''))) {
- return;
- }
- const node = posOperationObj.ledgerTreeNode;
- if (!node) {
- toastr.error('数据错误,请选择台账节点后再试');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- } else if (newText && newText !== '' && node.children && node.children.length > 0) {
- toastr.error('父节点不可插入计量单元');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }else if (newText && newText !== '' && (!node.b_code || node.b_code === '')) {
- toastr.error('项目节不可插入计量单元');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- const data = { updateType: posData ? 'update' : 'add' };
- if (!posData) {
- const sortData = info.sheet.zh_data;
- const order = (!sortData || sortData.length === 0) ? 1 : Math.max(sortData[sortData.length - 1].porder + 1, sortData.length + 1);
- data.updateData = { lid: node.id, tid: tender.id, porder: order };
- } else {
- data.updateData = { id: posData.id };
- }
- if (col.type === 'Number') {
- const exprInfo = getExprInfo(col.field);
- const num = _.toNumber(newText);
- if (_.isFinite(num)) {
- data.updateData[col.field] = num;
- if (exprInfo) {
- data.updateData[exprInfo.expr] = '';
- }
- } else {
- try {
- data.updateData[col.field] = math.evaluate(transExpr(newText));
- if (exprInfo) {
- data.updateData[exprInfo.expr] = newText;
- }
- } catch(err) {
- toastr.error('输入的表达式非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- }
- } else if (col.field.indexOf('_expr') > 0) {
- const exprInfo = getExprInfo(col.field, true);
- if (!exprInfo) return;
- if (newText) {
- try {
- data.updateData[exprInfo.qty] = math.evaluate(transExpr(newText));
- data.updateData[exprInfo.expr] = newText;
- } catch(err) {
- toastr.error('输入的表达式非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- } else {
- data.updateData[exprInfo.qty] = 0;
- data.updateData[exprInfo.expr] = '';
- }
- } else {
- data.updateData[col.field] = newText;
- }
- postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
- const updateRst = pos.updateDatas(result.pos);
- billsTag.refreshPosTagView(updateRst.update);
- // 刷新当前行, 不适用于新增(在非下一空白行新增)
- if (updateRst.create.length > 0) {
- // info.sheet.addRows(info.row, 1);
- // if (info.sheet.zh_data.length === 0) {
- // info.sheet.zh_data = pos.ledgerPos[itemsPre + node.id] || [];
- // }
- // SpreadJsObj.reLoadRowData(info.sheet, info.sheet.zh_data.length - 1);
- posOperationObj.loadCurPosData();
- } else {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- }
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- }
- },
- /**
- * 删除按钮响应事件
- * @param sheet
- */
- deletePress: function (sheet) {
- const self = this;
- if (sheet.zh_setting) {
- const sortData = sheet.zh_data;
- const datas = [], posSelects = [];
- const sel = sheet.getSelections()[0];
- for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
- let bDel = false;
- const node = sortData[iRow];
- if (node) {
- const data = {id: node.id};
- for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
- const colSetting = sheet.zh_setting.cols[iCol];
- const style = sheet.getStyle(iRow, iCol);
- if (!style.locked) {
- const colSetting = sheet.zh_setting.cols[iCol];
- if (colSetting.field.indexOf('_expr') > 0) {
- const exprInfo = getExprInfo(colSetting.field, true);
- if (!exprInfo) continue;
- data[exprInfo.expr] = '';
- data[exprInfo.qty] = 0;
- } else {
- data[colSetting.field] = null;
- const exprInfo = getExprInfo(colSetting.field);
- if (exprInfo) data[exprInfo.expr] = '';
- }
- bDel = true;
- }
- }
- if (bDel) {
- datas.push(data);
- posSelects.push(node);
- }
- }
- }
- if (datas.length > 0) {
- postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: datas}, function (result) {
- const updateRst = pos.updateDatas(result.pos);
- billsTag.refreshPosTagView(updateRst.update);
- posOperationObj.loadCurPosData();
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- }, function () {
- posOperationObj.loadCurPosData();
- });
- }
- }
- },
- /**
- * 删除 计量单元
- * @param sheet
- */
- deletePos: function (sheet) {
- const selection = sheet.getSelections();
- const data = {
- updateType: 'delete',
- updateData: [],
- };
- const row = selection[0].row, count = selection[0].rowCount;
- const sortData = sheet.zh_data;
- for (let iRow = 0; iRow < count; iRow++) {
- if (sortData[iRow + row]) {
- data.updateData.push(sortData[iRow + row].id);
- }
- }
- if (data.updateData.length > 0) {
- postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
- for (const p of result.pos) {
- const posInfo = pos.getPos(p);
- billsTag.afterDeletePos([posInfo]);
- }
- pos.removeDatas(result.pos);
- sheet.deleteRows(row, count);
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- });
- }
- },
- insertPos: function (sheet) {
- const selection = sheet.getSelections();
- const sortData = sheet.zh_data;
- const row = selection[0].row;
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- const select = SpreadJsObj.getSelectObject(sheet);
- const porder = select ? select.porder : sortData.length + 1;
- const data = {
- updateType: 'insert',
- updateData: [ { lid: node.id, tid: tender.id, porder } ],
- };
- postData('/tender/' + getTenderId() + '/pos/update', data, function (result) {
- const updateRst = pos.updateDatas(result.pos);
- posOperationObj.loadCurPosData();
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- });
- },
- /**
- * 粘贴单元格响应事件
- * @param e
- * @param info
- */
- clipboardPasted: function (e, info) {
- if (info.sheet.getColumnCount() > info.sheet.zh_setting.cols.length) {
- info.sheet.setColumnCount(info.sheet.zh_setting.cols.length);
- }
- const node = treeOperationObj.getSelectNode(ledgerSpread.getActiveSheet());
- if (node.code && (node.code !== '')) {
- toastr.error('项目节不可含有清单明细');
- posOperationObj.loadCurPosData();
- return;
- }
- if (node.children && (node.children.length > 0)) {
- toastr.error('仅清单子项可以含有计量单元');
- posOperationObj.loadCurPosData();
- return;
- }
- const hint = {
- expr: {type: 'warning', msg: '粘贴了表达式非法,已过滤'},
- };
- if (info.sheet.zh_setting) {
- const data = [];
- const sortData = info.sheet.zh_data || [];
- if (sortData.length === 0 || info.cellRange.row + info.cellRange.rowCount > sortData.length) {
- const nameCol = info.sheet.zh_setting.cols.findIndex(x => { return x.field === 'name'; });
- if (info.cellRange.col > nameCol || info.cellRange.col + info.cellRange.colCount < nameCol) {
- toastr.warning('新增计量单元请先输入名称');
- posOperationObj.loadCurPosData();
- return;
- }
- }
- const lastOrder = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
- let bPaste = false;
- const curRow = info.cellRange.row + iRow;
- const posData = curRow >= sortData.length ? {lid: node.id, porder: lastOrder + curRow - sortData.length} : {id: sortData[curRow].id, lid: node.id};
- for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
- const curCol = info.cellRange.col + iCol;
- const colSetting = info.sheet.zh_setting.cols[curCol];
- if (!colSetting) continue;
- posData[colSetting.field] = trimInvalidChar(info.sheet.getText(curRow, curCol));
- if (colSetting.type === 'Number') {
- const num = _.toNumber(posData[colSetting.field]);
- if (num) {
- posData[colSetting.field] = num;
- bPaste = true;
- } else {
- try {
- posData[colSetting.field] = math.evaluate(transExpr(posData[colSetting.field]));
- const exprInfo = getExprInfo(colSetting.field);
- if (exprInfo) {
- posData[exprInfo.expr] = trimInvalidChar(info.sheet.getText(curRow, curCol));
- }
- bPaste = true;
- } catch (err) {
- delete posData[colSetting.field];
- toastMessageUniq(hint.expr);
- }
- }
- } else if (colSetting.field.indexOf('_expr') > 0) {
- try {
- const exprInfo = getExprInfo(colSetting.field, true);
- posData[exprInfo.expr] = trimInvalidChar(info.sheet.getText(curRow, curCol));
- if (posData[exprInfo.expr] || !posData[exprInfo.qty]) {
- posData[exprInfo.qty] = math.evaluate(transExpr(posData[exprInfo.expr]));
- }
- bPaste = true;
- } catch (err) {
- toastMessageUniq(hint.expr);
- }
- } else {
- bPaste = true;
- }
- }
- if (bPaste) {
- data.push(posData);
- }
- }
- if (data.length > 0) {
- postData('/tender/' + getTenderId() + '/pos/paste', data, function (result) {
- const updateRst = pos.updateDatas(result.pos);
- billsTag.refreshPosTagView(updateRst.update);
- posOperationObj.loadCurPosData();
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- posOperationObj.loadCurPosData();
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- });
- } else {
- SpreadJsObj.reLoadRowData(info.sheet, info.cellRange.row, info.cellRange.rowCount);
- }
- }
- },
- selectionChanged: function (e, info) {
- posOperationObj.loadExprToInput();
- posOperationObj.refreshOperationValid(posSpread.getActiveSheet());
- },
- addPegs: function (pegs) {
- if (!pegs || pegs.length <= 0) return;
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- if (!node) return;
- const sheet = posSpread.getActiveSheet();
- const sortData = sheet.zh_data || [];
- let order = sortData.length > 0 ? sortData[sortData.length - 1].porder + 1 : 1;
- pegs.forEach(function (p) {p.porder = ++order; p.lid = node.id});
- postData('/tender/' + getTenderId() + '/pos/paste', pegs, function (result) {
- pos.updateDatas(result.pos);
- posOperationObj.loadCurPosData();
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- });
- }
- };
- posSpread.bind(spreadNS.Events.SelectionChanged, posOperationObj.selectionChanged);
- if (!posSpreadSetting.readOnly) {
- $('a[name="pos-opr"]').click(function () {
- posOperationObj.baseOpr(posSpread.getActiveSheet(), this.getAttribute('type'));
- });
- $('#pos-expr').bind('change onblur', function () {
- const expr = $(this);
- const posSheet = posSpread.getActiveSheet();
- const row = expr.attr('data-row') ? _.toInteger(expr.attr('data-row')) : -1;
- const select = posSheet.zh_data ? posSheet.zh_data[row] : null;
- if (!select) return;
- const field = expr.attr('field'), orgValue = expr.attr('org'), newValue = expr.val();
- if (orgValue === newValue || (!orgValue && newValue == '')) { return; }
- const data = {id: select.id};
- const exprInfo = getExprInfo(field);
- if (newValue !== '') {
- const num = _.toNumber(newValue);
- if (num) {
- data[field] = num;
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- } else {
- try {
- data[field] = math.evaluate(transExpr(newValue));
- if (exprInfo) {
- data[exprInfo.expr] = newValue;
- }
- } catch (err) {
- toastr.error('输入的表达式非法');
- return;
- }
- }
- } else {
- data[field] = null;
- if (exprInfo) {
- data[exprInfo.expr] = '';
- }
- }
- // 更新至服务器
- postData('/tender/' + getTenderId() + '/pos/update', {updateType: 'update', updateData: data}, function (result) {
- const updateRst = pos.updateDatas(result.pos);
- SpreadJsObj.reLoadRowData(posSheet, _.toNumber(row));
- const loadResult = ledgerTree.loadPostData(result.ledger);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- });
- });
- SpreadJsObj.addDeleteBind(posSpread, posOperationObj.deletePress);
- posSpread.bind(spreadNS.Events.EditStarting, posOperationObj.editStarting);
- posSpread.bind(spreadNS.Events.EditEnded, posOperationObj.editEnded);
- posSpread.bind(spreadNS.Events.ClipboardPasted, posOperationObj.clipboardPasted);
- }
- const mergePeg = NewMergePeg({ callback: posOperationObj.addPegs });
- // 右键菜单
- $.contextMenu({
- selector: '#pos-spread',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, posSpread);
- return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
- },
- items: {
- 'insert': {
- name: '插入',
- icon: 'fa-plus',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- return node && node.children && node.children.length > 0;
- },
- callback: function (key, opt) {
- posOperationObj.insertPos(posSpread.getActiveSheet());
- },
- visible: function(key, opt) {
- return !readOnly;
- }
- },
- 'delete': {
- name: '删除',
- icon: 'fa-remove',
- disabled: function (key, opt) {
- const sheet = posSpread.getActiveSheet();
- if (sheet.zh_data) {
- const selection = sheet.getSelections();
- return sheet.zh_data.length < selection[0].row + selection[0].rowCount;
- } else {
- return true;
- }
- },
- callback: function (key, opt) {
- posOperationObj.deletePos(posSpread.getActiveSheet());
- },
- visible: function(key, opt) {
- return !readOnly;
- }
- },
- 'merge-peg': {
- name: '合并起讫桩号',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- return _.isNil(node) || _.isNil(node.b_code) || node.b_code === '';
- },
- callback: function (key, opt) {
- mergePeg.show();
- },
- visible: function(key, opt) {
- return !readOnly;
- }
- },
- tag: {
- name: '书签',
- disabled: function(key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- const pos = SpreadJsObj.getSelectObject(posSpread.getActiveSheet());
- return _.isNil(node) || _.isNil(pos);
- },
- callback: function(key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- const pos = SpreadJsObj.getSelectObject(posSpread.getActiveSheet());
- addTag.do(node, pos);
- }
- }
- }
- });
- // 附属工程量相关
- const ancGclSpreadSetting = {
- cols: [
- {title: '辅材', colSpan: '1', rowSpan: '1', field: 'is_aux', hAlign: 1, width: 40, cellType: 'checkbox'},
- {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 120, formatter: '@'},
- {title: '单位', colSpan: '1', rowSpan: '1', field: 'unit', hAlign: 1, width: 40, formatter: '@', cellType: 'unit'},
- {title: '设计量', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 60, type: 'Number'},
- {title: '设计量公式', colSpan: '1', rowSpan: '1', field: 'expr', hAlign: 0, width: 80, formatter: '@'},
- {title: '图册号', colSpan: '1', rowSpan: '1', field: 'drawing_code', hAlign: 0, width: 80, formatter: '@'},
- {title: '备注', colSpan: '1', rowSpan: '1', field: 'memo', hAlign: 0, width: 80, formatter: '@'},
- ],
- emptyRows: 3,
- headRows: 1,
- headRowHeight: [32],
- headColWidth: [30],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- };
- SpreadJsObj.initSheet(ancGclSheet, ancGclSpreadSetting);
- const ancGclObj = {
- loadCurAncillaryGcl: function () {
- const node = treeOperationObj.getSelectNode(ledgerSheet);
- const gclData = node ? ancGcl.getPartData(node.id) || [] : [];
- SpreadJsObj.loadSheetData(ancGclSheet, SpreadJsObj.DataType.Data, gclData);
- },
- baseOpr: function (type) {
- const data = {};
- const gclRange = ancGclSheet.zh_data;
- if (type !== 'insert' && (!gclRange || gclRange.length === 0)) return;
- const sel = ancGclSheet.getSelections();
- if (!sel[0]) return;
- const row = sel[0].row, count = sel[0].rowCount;
- const first = gclRange[row];
- if (type === 'insert') {
- const node = SpreadJsObj.getSelectObject(ledgerSheet);
- data.add = [{ lid: node.id, g_order: gclRange.length + 1 }];
- } else if (type === 'delete') {
- data.del = [];
- for (let iRow = 0; iRow < count; iRow++) {
- const gclData = gclRange[row + iRow];
- if (!gclData) continue;
- data.del.push(gclData.id);
- }
- if (data.del.length === 0) return;
- } else if (type === 'up-move') {
- data.update = [];
- const pre = gclRange[row - 1];
- if (!pre) return;
- const preUpdate = { id: pre.id };
- for (let iRow = 0; iRow < count; iRow++) {
- const gclData = gclRange[iRow + row];
- if (!gclData) continue;
- data.update.push({ id: gclData.id, g_order: gclRange[iRow + row - 1].g_order });
- preUpdate.g_order = gclData.g_order;
- }
- data.update.push(preUpdate);
- if (data.update <= 1) return;
- } else if (type === 'down-move') {
- data.update = [];
- const next = gclRange[row + count];
- if (!next) return;
- const nextUpdate = { id: next.id };
- for (let iRow = count - 1; iRow >= 0; iRow--) {
- const gclData = gclRange[iRow + row];
- if (!gclData) continue;
- data.update.push({ id: gclData.id, g_order: gclRange[iRow + row + 1].g_order});
- nextUpdate.g_order = gclData.g_order;
- }
- data.update.push(nextUpdate);
- if (data.update <= 1) return;
- }
- postData('/tender/' + getTenderId() + '/anc-gcl/update', data, function(result) {
- ancGcl.updateDatas(result);
- ancGclObj.loadCurAncillaryGcl();
- if (type !== 'delete') SpreadJsObj.locateData(ancGclSheet, first);
- });
- },
- editStarting: function (e, info) {
- ancGclObj.ledgerTreeNode = SpreadJsObj.getSelectObject(ledgerSheet);
- },
- editEnded: function (e, info) {
- const setting = info.sheet.zh_setting;
- if (!setting) return;
- const gclData = SpreadJsObj.getSelectObject(info.sheet);
- const col = setting.cols[info.col];
- const orgText = gclData ? gclData[col.field] : '', newText = trimInvalidChar(info.editingText);
- if (orgText === newText || (!orgText && !newText)) return;
- const node = ancGclObj.ledgerTreeNode;
- if (!node) {
- toastr.error('数据错误,请选择台账节点后再试');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- if (!!newText && node.children && node.children.length > 0) {
- toastr.error('父节点不可添加附属工程量');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- if (!!newText && (!node.b_code || node.b_code === '')) {
- toastr.error('项目节不可插入附属工程量');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- const data = {};
- if (gclData) {
- const updateData = { id: gclData.id };
- if (col.type === 'Number') {
- const num = _.toNumber(newText);
- if (!_.isFinite(num)) {
- toastr.error('输入的数字非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- updateData[col.field] = num;
- if (gclData.expr) updateData.expr = '';
- } else if (col.field === 'expr') {
- try {
- updateData.expr = newText;
- updateData.quantity = math.evaluate(transExpr(newText));
- } catch(err) {
- toastr.error('输入的计算式非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- } else {
- updateData[col.field] = newText;
- }
- data.update = [ updateData ];
- } else {
- const sortData = info.sheet.zh_data;
- const order = (!sortData || sortData.length === 0) ? 1 : Math.max(sortData[sortData.length - 1].g_order + 1, sortData.length + 1);
- const addData = { lid: node.id, g_order: order };
- if (col.type === 'Number') {
- const num = _.toNumber(newText);
- if (!_.isFinite(num)) {
- toastr.error('输入的数字非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- addData[col.field] = num;
- if (gclData.expr) addData.expr = '';
- } else if (col.field === 'expr') {
- try {
- addData.expr = newText;
- addData.quantity = math.evaluate(transExpr(newText));
- } catch(err) {
- toastr.error('输入的计算式非法');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- } else {
- addData[col.field] = newText;
- }
- data.add = [addData];
- }
- postData('/tender/' + getTenderId() + '/anc-gcl/update', data, function (result) {
- ancGcl.updateDatas(result);
- ancGclObj.loadCurAncillaryGcl();
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- },
- deletePress: function (sheet) {
- const setting = sheet.zh_setting;
- if (!setting) return;
- const sortData = sheet.zh_data;
- if (!sortData || sortData.length === 0) return;
- const sel = sheet.getSelections()[0];
- const data = { update: [] };
- for (let iRow = sel.row; iRow < sel.row + sel.rowCount; iRow++) {
- let bDel = false;
- const node = sortData[iRow];
- if (!node) continue;
- const updateData = { id: node.id };
- for (let iCol = sel.col; iCol < sel.col + sel.colCount; iCol++) {
- const style = sheet.getStyle(iRow, iCol);
- if (style.locked) continue;
- const col = setting.cols[iCol];
- if (col.field === 'expr') {
- updateData.expr = '';
- updateData.quantity = 0;
- } else {
- updateData[col.field] = col.type === 'Number' ? 0 : '';
- if (col.field === 'quantity') updateDataexpr = '';
- }
- bDel = true;
- }
- if (bDel) data.update.push(updateData);
- }
- if (data.update.length === 0) return;
- postData('/tender/' + getTenderId() + '/anc-gcl/update', data, function (result) {
- ancGcl.updateDatas(result);
- ancGclObj.loadCurAncillaryGcl();
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- },
- clipboardPasting: function(e, info) {
- info.cancel = true;
- const node = SpreadJsObj.getSelectObject(ledgerSheet);
- if (!node) {
- toastr.error('数据错误,请选择台账节点后再试');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- if (node.children && node.children.length > 0) {
- toastr.error('父节点不可添加附属工程量');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- if ((!node.b_code || node.b_code === '')) {
- toastr.error('项目节不可插入附属工程量');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- const hint = {
- expr: {type: 'warning', msg: '输入的 计算式 非法,已过滤'},
- num: {type: 'warning', msg: '输入的 数字 非法,已过滤'},
- };
- const setting = info.sheet.zh_setting;
- const sortData = info.sheet.zh_data || [];
- const pasteData = SpreadJsObj.analysisPasteText(info.pasteData.text);
- const data = {};
- const analysisData = function(pasteRow, targetData) {
- pasteRow.forEach((value, iCol) => {
- const col = setting.cols[info.cellRange.col + iCol];
- if (col.field === 'expr') {
- try {
- targetData.expr = trimInvalidChar(value);
- targetData.quantity = math.evaluate(transExpr(targetData.expr));
- } catch(err) {
- toastMessageUniq(hint.expr);
- targetData.expr = '';
- return;
- }
- } else if (col.type === 'Number') {
- const num = _.toNumber(value);
- if (!_.isFinite(num)) {
- toastMessageUniq(hint.num);
- return;
- }
- targetData[col.field] = num;
- if (col.field === 'quantity') targetData.expr = '';
- } else {
- targetData[col.field] = value;
- }
- });
- };
- for (let iRow = 0; iRow < pasteData.length; iRow++) {
- const curRow = iRow + info.cellRange.row;
- const gclData = sortData[curRow];
- if (gclData) {
- if (!data.update) data.update = [];
- const updateData = { id: gclData.id };
- analysisData(pasteData[iRow], updateData);
- data.update.push(updateData);
- } else {
- if (!data.add) data.add = [];
- const addData = { lid: node.id, g_order: curRow + 1};
- analysisData(pasteData[iRow], addData);
- data.add.push(addData);
- }
- }
- if ((!data.update || data.update.length === 0) && (!data.add || data.add.length === 0)) return;
- postData('/tender/' + getTenderId() + '/anc-gcl/update', data, function (result) {
- ancGcl.updateDatas(result);
- ancGclObj.loadCurAncillaryGcl();
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- },
- buttonClicked: function (e, info) {
- const setting = info.sheet.zh_setting;
- if (!setting) return;
- const node = SpreadJsObj.getSelectObject(info.sheet);
- if (!node) {
- toastr.warning('请先添加附属工程量再设置辅材');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- const col = setting.cols[info.col];
- const updateData = { id: node.id };
- updateData[col.field] = node[col.field] ? 0 : 1;
- postData('/tender/' + getTenderId() + '/anc-gcl/update', { update: [updateData]}, function (result) {
- ancGcl.updateDatas(result);
- ancGclObj.loadCurAncillaryGcl();
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- },
- };
- SpreadJsObj.addDeleteBind(ancGclSpread, ancGclObj.deletePress);
- ancGclSpread.bind(spreadNS.Events.EditStarting, ancGclObj.editStarting);
- ancGclSpread.bind(spreadNS.Events.EditEnded, ancGclObj.editEnded);
- ancGclSpread.bind(spreadNS.Events.ClipboardPasting, ancGclObj.clipboardPasting);
- ancGclSpread.bind(spreadNS.Events.ButtonClicked, ancGclObj.buttonClicked);
- $.contextMenu({
- selector: '#anc-gcl-spread',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, ancGclSpread);
- return target.hitTestType === GC.Spread.Sheets.SheetArea.viewport || target.hitTestType === GC.Spread.Sheets.SheetArea.rowHeader;
- },
- items: {
- 'insert': {
- name: '插入',
- icon: 'fa-plus',
- disabled: function (key, opt) {
- const node = SpreadJsObj.getSelectObject(ledgerSheet);
- return !node || !node.b_code || (node.children && node.children.length > 0);
- },
- callback: function (key, opt) {
- ancGclObj.baseOpr('insert');
- }
- },
- 'delete': {
- name: '删除',
- icon: 'fa-remove',
- disabled: function (key, opt) {
- const gclData = SpreadJsObj.getSelectObject(ancGclSheet);
- return !gclData;
- },
- callback: function (key, opt) {
- ancGclObj.baseOpr('delete');
- }
- },
- 'down-move': {
- name: '下移',
- icon: 'fa-arrow-down',
- disabled: function(key, opt) {
- const sel = ancGclSheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const first = ancGclSheet.zh_data[row];
- const next = ancGclSheet.zh_data[sel.row + sel.rowCount];
- return !first || !next;
- },
- callback: function(key, opt) {
- ancGclObj.baseOpr('down-move');
- }
- },
- 'up-move': {
- name: '上移',
- icon: 'fa-arrow-up',
- disabled: function(key, opt) {
- const sel = ancGclSheet.getSelections()[0];
- const row = sel ? sel.row : -1;
- const first = ancGclSheet.zh_data[row];
- const preNode = ancGclSheet.zh_data[row - 1];
- return !first || !preNode;
- },
- callback: function(key, opt) {
- ancGclObj.baseOpr('up-move');
- }
- },
- }
- });
- $('#filter-anc-gcl').change(function() {
- if (this.checked) {
- const condition = {};
- condition[this.getAttribute('name')] = parseInt(this.value);
- ancGcl.filter = condition;
- } else {
- ancGcl.filter = null;
- }
- ancGclObj.loadCurAncillaryGcl();
- });
- postData(window.location.pathname + '/load', {}, function (data) {
- ledgerTree.loadDatas(data.bills);
- treeCalc.calculateAll(ledgerTree);
- checkShowLast(data.bills.length);
- pos.loadDatas(data.pos);
- ancGcl.loadDatas(data.ancGcl);
- for (const t of data.tags) {
- t.node = ledgerTree.datas.find(x => { return x.id === t.lid; });
- if (t.pos_id) {
- const posRange = pos.getLedgerPos(t.lid) || [];
- t.pos = posRange.find(x => { return x.id === t.pos_id; });
- }
- }
- billsTag.loadDatas(data.tags);
- SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
- SpreadJsObj.loadTopAndSelect(ledgerSpread.getActiveSheet(), ckBillsSpread);
- posOperationObj.loadCurPosData();
- SpreadJsObj.resetTopAndSelect(posSpread.getActiveSheet());
- ancGclObj.loadCurAncillaryGcl();
- SpreadJsObj.resetTopAndSelect(ancGclSheet);
- treeOperationObj.refreshOperationValid(ledgerSpread.getActiveSheet());
- treeOperationObj.loadExprToInput(ledgerSpread.getActiveSheet());
- checkList.loadHisCheckData();
- }, null, true);
- $.divResizer({
- select: '#right-spr',
- callback: function () {
- ledgerSpread.refresh();
- if (posSpread) posSpread.refresh();
- if (ancGclSpread) ancGclSpread.refresh();
- if (stdXmj) stdXmj.spread.refresh();
- if (stdGcl) stdGcl.spread.refresh();
- if (dealBills) dealBills.spread.refresh();
- if (searchLedger) searchLedger.spread.refresh();
- if (errorList) errorList.spread.refresh();
- if (checkList) checkList.spread.refresh();
- if (gclGather) gclGather.spread.refresh();
- }
- });
- const stdLibCellDoubleClick = function (updateData, stdNode) {
- if (!stdNode) return;
- const mainNode = SpreadJsObj.getSelectObject(ledgerSheet);
- if (!mainNode) return;
- if (updateData.postData.stdType === 'gcl') {
- if (!!mainNode.code && !ledgerTree.isLeafXmj(mainNode)) {
- toastr.warning('非最底层项目下,不应添加清单');
- return;
- }
- }
- updateData.postData.id = ledgerTree.getNodeKey(mainNode);
- updateData.postData.tender_id = mainNode.tender_id;
- postData(window.location.pathname + '/update', updateData, function (result) {
- const sel = ledgerSheet.getSelections()[0];
- const refreshNode = ledgerTree.loadPostData(result);
- treeOperationObj.refreshTree(ledgerSheet, refreshNode);
- if (refreshNode.create && refreshNode.create.length > 0) {
- ledgerSheet.setSelection(refreshNode.create[refreshNode.create.length - 1].index, sel.col, sel.rowCount, sel.colCount);
- const refreshRow = [sel.row, refreshNode.create[refreshNode.create.length - 1].index];
- const curIndex = ledgerTree.nodes.indexOf(mainNode);
- if (sel.row !== curIndex && curIndex >= 0) refreshRow.push(curIndex);
- SpreadJsObj.reloadRowsBackColor(ledgerSheet, refreshRow);
- } else {
- const node = _.find(ledgerTree.nodes, {code: stdNode.code, name: stdNode.name});
- if (node) {
- ledgerSheet.setSelection(ledgerTree.nodes.indexOf(node), sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(ledgerSheet, [sel.row, ledgerTree.nodes.indexOf(node)]);
- }
- }
- treeOperationObj.refreshOperationValid(ledgerSheet);
- ledgerSpread.focus();
- treeOperationObj.loadRelaData();
- });
- };
- const stdXmjSetting = {
- selector: '#std-xmj',
- stdType: 'xmj',
- libs: stdChapters,
- treeSetting: {
- id: 'chapter_id',
- pid: 'pid',
- order: 'order',
- level: 'level',
- rootId: -1,
- keys: ['id', 'list_id', 'chapter_id'],
- },
- spreadSetting: {
- cols: [
- {title: '项目节编号', field: 'code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
- {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
- ],
- treeCol: 0,
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- headColWidth: [30],
- selectedBackColor: '#fffacd',
- },
- cellDoubleClick: stdLibCellDoubleClick,
- page: 'ledger',
- tid: getTenderId(),
- };
- const stdGclSetting = {
- selector: '#std-gcl',
- stdType: 'gcl',
- libs: stdBills,
- treeSetting: {
- id: 'bill_id',
- pid: 'pid',
- order: 'order',
- level: 'level',
- rootId: -1,
- keys: ['id', 'list_id', 'bill_id']
- },
- spreadSetting: {
- cols: [
- {title: '清单编号', field: 'b_code', hAlign: 0, width: 120, formatter: '@', readOnly: true, cellType: 'tree'},
- {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true}
- ],
- treeCol: 0,
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- headColWidth: [30],
- selectedBackColor: '#fffacd',
- },
- cellDoubleClick: stdLibCellDoubleClick,
- page: 'ledger',
- tid: getTenderId(),
- showAddType: 1,
- };
- // 展开收起标准清单
- $('a', '#side-menu').bind('click', function (e) {
- e.preventDefault();
- const tab = $(this), tabPanel = $(tab.attr('content'));
- // 展开工具栏、切换标签
- if (!tab.hasClass('active')) {
- // const close = $('.active', '#side-menu').length === 0;
- $('a', '#side-menu').removeClass('active');
- $('.tab-content .tab-select-show.tab-pane.active').removeClass('active');
- tab.addClass('active');
- tabPanel.addClass('active');
- // $('.tab-content .tab-pane').removeClass('active');
- showSideTools(tab.hasClass('active'));
- if (tab.attr('content') === '#std-xmj') {
- if (!stdXmj) {
- stdXmj = $.stdLib(stdXmjSetting);
- }
- stdXmj.spread.refresh();
- } else if (tab.attr('content') === '#std-gcl') {
- if (!stdGcl) {
- stdGcl = $.stdLib(stdGclSetting);
- }
- stdGcl.spread.refresh();
- } else if (tab.attr('content') === '#deal-bills') {
- if (!dealBills) {
- dealBills = new DealBills('#deal-bills-spread', {
- cols: [
- {title: '清单编号', field: 'code', hAlign: 0, width: 85, formatter: '@'},
- {title: '名称', field: 'name', hAlign: 0, width: 150, formatter: '@'},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
- {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
- {title: '数量', field: 'quantity', hAlign: 2, width: 50},
- {title: '金额', field: 'total_price', hAlign: 2, width: 50, readOnly: true},
- ],
- emptyRows: 3,
- headRows: 1,
- headRowHeight: [32],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- headColWidth: [30],
- selectedBackColor: '#fffacd',
- readOnly: true,
- });
- dealBills.loadData();
- }
- dealBills.spread.refresh();
- } else if (tab.attr('content') === '#search') {
- if (!searchLedger) {
- searchLedger = $.billsSearch({
- selector: '#search',
- searchSpread: ledgerSpread,
- resultSpreadSetting: {
- cols: [
- {title: '项目节编号', field: 'code', hAlign: 0, width: 90, formatter: '@'},
- {title: '清单编号', field: 'b_code', hAlign: 0, width: 80, formatter: '@'},
- {title: '名称', field: 'name', width: 150, hAlign: 0, formatter: '@'},
- {title: '单位', field: 'unit', width: 50, hAlign: 1, formatter: '@'},
- {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
- {title: '数量', field: 'quantity', hAlign: 2, width: 50},
- {title: '部位', field: 'bw', hAlign: 2, width: 90},
- ],
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- headColWidth: [30],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- selectedBackColor: '#fffacd',
- readOnly: true,
- },
- afterLocated: function () {
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- },
- calcSum: function (result) {
- const sum = { name: '合计' };
- for (const r of result) {
- sum.quantity = ZhCalc.add(r.quantity, sum.quantity);
- }
- return sum;
- }
- });
- }
- searchLedger.spread.refresh();
- } else if (tab.attr('content') === '#bills-tag') {
- // do something
- } else if (tab.attr('content') === '#error-list') {
- errorList.spread.refresh();
- } else if (tab.attr('content') === '#check-list') {
- checkList.spread.refresh();
- } else if (tab.attr('content') === '#fujian') {
- $('#showAttachment').hide();
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- getNodeList(node.id);
- getAllList();
- } else if (tab.attr('content') === '#gcl-gather') {
- gclGather.spread.refresh();
- }
- } else { // 收起工具栏
- tab.removeClass('active');
- tabPanel.removeClass('active');
- showSideTools(tab.hasClass('active'));
- }
- ledgerSpread.refresh();
- if (posSpread) {
- posSpread.refresh();
- }
- if (ancGclSpread) ancGclSpread.refresh();
- });
- class DealBills {
- constructor (selector, spreadSetting) {
- const self = this;
- this.obj = $(selector)[0];
- this.url = '/tender/' + getTenderId() + '/deal';
- this.spreadSetting = spreadSetting;
- this.spread = SpreadJsObj.createNewSpread(this.obj);
- this.sheet = this.spread.getActiveSheet();
- SpreadJsObj.initSheet(this.spread.getActiveSheet(), this.spreadSetting);
- this.OprObj = {
- /**
- * 删除按钮响应事件
- * @param sheet
- */
- deletePress: function (sheet) {
- if (!sheet.zh_setting || sheet.zh_setting.readOnly) return;
- const sortData = sheet.zh_data;
- const datas = [];
- const sels = sheet.getSelections();
- if (!sels || !sels[0]) return;
- for (let iRow = sels[0].row; iRow < sels[0].row + sels[0].rowCount; iRow++) {
- let bDel = false;
- const node = sortData[iRow];
- if (node) {
- const data = {id: node.id};
- for (let iCol = sels[0].col; iCol < sels[0].col + sels[0].colCount; iCol++) {
- const colSetting = sheet.zh_setting.cols[iCol];
- if (colSetting.field === 'code') {
- toastr.error('清单编号不能为空,如需删除签约清单请使用右键删除');
- return;
- }
- const style = sheet.getStyle(iRow, iCol);
- if (!style.locked) {
- const colSetting = sheet.zh_setting.cols[iCol];
- data[colSetting.field] = null;
- bDel = true;
- }
- }
- if (bDel) {
- datas.push(data);
- }
- }
- }
- if (datas.length > 0) {
- postData(self.url + '/update', {update: datas}, function (result) {
- self.loadUpdateData(result);
- SpreadJsObj.reLoadSheetData(sheet);
- }, function () {
- SpreadJsObj.reLoadSheetData(sheet);
- });
- }
- },
- delete: function (sheet) {
- if (!sheet.zh_setting || sheet.zh_setting.readOnly) return;
- const sortData = sheet.zh_data;
- const datas = [];
- const sels = sheet.getSelections();
- if (!sels || !sels[0]) return;
- for (let iRow = sels[0].row, iLen = sels[0].row + sels[0].rowCount; iRow < iLen; iRow++) {
- const node = sortData[iRow];
- datas.push(node.id);
- }
- if (datas.length > 0) {
- postData(self.url + '/update', {del: datas}, function (result) {
- self.loadUpdateData(result);
- SpreadJsObj.reLoadSheetData(sheet);
- }, function () {
- SpreadJsObj.reLoadSheetData(sheet);
- });
- }
- },
- editEnded: function (e, info) {
- if (!info.sheet.zh_setting || !info.sheet.zh_data || info.sheet.zh_setting.readOnly) return;
- const node = info.sheet.zh_data[info.row];
- const col = info.sheet.zh_setting.cols[info.col];
- const data = {};
- if (node) {
- data.update = {};
- data.update.id = node.id;
- const oldValue = node ? node[col.field] : null;
- const newValue = trimInvalidChar(info.editingText);
- if (oldValue == info.editingText || ((!oldValue || oldValue === '') && (newValue === ''))) {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- data.update[col.field] = newValue;
- } else {
- if (col.field !== 'code') {
- toastr.warning('新增签约清单,请先输入清单编号');
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- return;
- }
- data.add = {};
- data.add.order = info.row + 1;
- data.add.code = trimInvalidChar(info.editingText);
- }
- postData(self.url + '/update', data, function (result) {
- self.loadUpdateData(result);
- SpreadJsObj.reLoadSheetData(info.sheet);
- }, function () {
- SpreadJsObj.reLoadRowData(info.sheet, info.row);
- });
- },
- clipboardPasting(e, info) {
- const setting = info.sheet.zh_setting, sortData = info.sheet.zh_data;
- info.cancel = true;
- if (!setting || !sortData || setting.readOnly) return;
- const pasteData = info.pasteData.html
- ? SpreadJsObj.analysisPasteHtml(info.pasteData.html)
- : (info.pasteData.text === ''
- ? SpreadJsObj.Clipboard.getAnalysisPasteText()
- : SpreadJsObj.analysisPasteText(info.pasteData.text));
- const hint = {
- code: {type: 'warning', msg: '签约清单编号不可为空,已过滤'},
- unit_price: {type: 'warning', msg: '输入的 单价 非法,已过滤'},
- quantity: {type: 'warning', msg: '输入的 数量 非法,已过滤'},
- };
- const uDatas = [], iDatas = [];
- for (let iRow = 0; iRow < info.cellRange.rowCount; iRow++) {
- const curRow = info.cellRange.row + iRow;
- const node = sortData[curRow];
- let bPaste = false;
- const data = {};
- for (let iCol = 0; iCol < info.cellRange.colCount; iCol++) {
- const curCol = info.cellRange.col + iCol;
- const colSetting = setting.cols[curCol];
- const value = trimInvalidChar(pasteData[iRow][iCol]);
- if (colSetting.field === 'code' && (!value || value === '')) {
- toastMessageUniq(hint.code);
- break;
- }
- if (colSetting.type === 'Number') {
- const num = _.toNumber(value);
- if (num) {
- data[colSetting.field] = num;
- bPaste = true;
- } else if (colSetting.field === 'unit_price') {
- toastMessageUniq(hint.unit_price);
- } else if (colSetting.field === 'quantity') {
- toastMessageUniq(hint.quantity);
- }
- } else {
- data[colSetting.field] = value;
- bPaste = true;
- }
- }
- if (bPaste) {
- if (node) {
- data.id = node.id;
- uDatas.push(data);
- } else {
- data.order = curRow + 1;
- iDatas.push(data);
- }
- }
- }
- const updateData = {};
- if (uDatas.length > 0) updateData.update = uDatas;
- if (iDatas.length > 0) updateData.add = iDatas;
- if (uDatas.length > 0 || iDatas.length > 0) {
- postData(self.url + '/update', updateData, function (result) {
- self.loadUpdateData(result);
- SpreadJsObj.reLoadSheetData(info.sheet);
- });
- } else {
- SpreadJsObj.reLoadSheetData(info.sheet);
- }
- },
- };
- if (!readOnly) {
- this.spread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
- const dealSheet = info.sheet;
- if (!dealSheet.zh_setting.readOnly) return;
- const mainSheet = ledgerSpread.getActiveSheet();
- const dealBills = SpreadJsObj.getSelectObject(dealSheet);
- if (!dealBills) { return; }
- const mainTree = mainSheet.zh_tree;
- const mainNode = SpreadJsObj.getSelectObject(mainSheet);
- if (!mainNode || !mainTree) { return; }
- if (mainNode.code && mainNode.code !== '' && !mainTree.isLeafXmj(mainNode)) {
- toastr.error('非最底层项目下,不应添加清单');
- return;
- }
- postData(window.location.pathname + '/update', {
- postType: 'add-deal',
- postData: {
- id: mainNode.ledger_id,
- type: mainNode.code ? 'child' : 'next',
- dealBills: {
- b_code: dealBills.code, name: dealBills.name, unit: dealBills.unit,
- unit_price: dealBills.unit_price,
- }
- },
- }, function (result) {
- const refreshData = mainTree.loadPostData(result);
- treeOperationObj.refreshTree(mainSheet, refreshData);
- const sel = mainSheet.getSelections()[0];
- mainSheet.setSelection(refreshData.create[0].index, sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(mainSheet, [sel.row, refreshData.create[0].index]);
- treeOperationObj.refreshOperationValid(mainSheet);
- ledgerSpread.focus();
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- });
- });
- }
- const dealBillsPermission = $('[href="#upload-deal"]').length > 0;
- if (!readOnly || dealBillsPermission) {
- this.spread.bind(spreadNS.Events.EditEnded, this.OprObj.editEnded);
- this.spread.bind(spreadNS.Events.ClipboardPasting, this.OprObj.clipboardPasting);
- SpreadJsObj.addDeleteBind(this.spread, this.OprObj.deletePress);
- $.contextMenu({
- selector: selector,
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, self.spread);
- return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
- },
- items: {
- edit: {
- name: '进入编辑模式',
- icon: 'fa-edit',
- visible: function (key, opt) {
- return self.sheet.zh_setting.readOnly;
- },
- callback: function (key, opt) {
- self.sheet.zh_setting.readOnly = false;
- SpreadJsObj.refreshSheetReadOnly(self.sheet);
- },
- },
- read: {
- name: '退出编辑模式',
- icon: 'fa-sign-out',
- visible: function (key, opt) {
- return !self.sheet.zh_setting.readOnly;
- },
- callback: function (key, opt) {
- self.sheet.zh_setting.readOnly = true;
- SpreadJsObj.refreshSheetReadOnly(self.sheet);
- },
- },
- del: {
- name: '删除',
- icon: 'fa-times',
- visible: function (key, opt) {
- return !self.sheet.zh_setting.readOnly;
- },
- disabled: function (key, opt) {
- const select = SpreadJsObj.getSelectObject(self.sheet);
- return !select;
- },
- callback: function (key, opt) {
- self.OprObj.delete(self.sheet);
- },
- },
- sprEdit: '----',
- apply: {
- name: '应用全部清单单价至台账',
- icon: 'fa-magic',
- disabled: function (key, opt) {
- const sheet = self.spread.getActiveSheet();
- return sheet.getRowCount() === 0 || readOnly;
- },
- callback: function (key, opt) {
- const datas = [], sourceData = self.spread.getActiveSheet().zh_data;
- for (const db of sourceData) {
- const targets = ledgerTree.nodes.filter(function (x) {
- return x.b_code === db.code && x.name === db.name && x.unit === db.unit;
- });
- for (const t of targets) {
- if (t.children && t.children.length > 0) continue;
- const data = ledgerTree.getNodeKeyData(t);
- data.unit_price = db.unit_price;
- datas.push(data);
- }
- }
- if (datas.length > 0) {
- doAfterHint({
- fun: function() {
- postData(window.location.pathname + '/update', {postType: 'update', postData: datas}, function (result) {
- const refreshNode = ledgerTree.loadPostData(result);
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), refreshNode);
- });
- },
- hint: '此操作会替换台账里所有同编号、名称、单位的清单,请谨慎操作',
- });
- } else {
- toastr.warning('没有可应用的清单。');
- }
- },
- }
- }
- });
- }
- $('#upload-deal-bills').click(function () {
- const file = $('#deal-bills-file')[0];
- const formData = new FormData();
- formData.append('file', file.files[0]);
- postDataWithFile(self.url+'/upload-excel', formData, function (data) {
- self.data = data;
- SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
- $('#upload-deal').modal('hide');
- }, function () {
- $('#upload-deal').modal('hide');
- });
- });
- this.initDealBillsSearch();
- }
- search(keyword) {
- this.searchResult = [];
- this.searchCur = 0;
- if (keyword) {
- for (const [i, d] of this.data.entries()) {
- if (d.code.indexOf(keyword) >= 0 || d.name.indexOf(keyword) >= 0) this.searchResult.push(d);
- }
- }
- $('#dbs-count').html(`结果:${this.searchResult.length}`);
- if (this.searchResult.length > 0) SpreadJsObj.locateData(this.sheet, this.searchResult[0]);
- }
- searchPre() {
- this.searchCur = this.searchCur - 1;
- if (this.searchCur < 0) this.searchCur = this.searchResult.length - 1;
- SpreadJsObj.locateData(this.sheet, this.searchResult[this.searchCur]);
- }
- searchNext() {
- this.searchCur = this.searchCur + 1;
- if (this.searchCur >= this.searchResult.length) this.searchCur = 0;
- SpreadJsObj.locateData(this.sheet, this.searchResult[this.searchCur]);
- }
- searchClear() {
- $('#dbs-keyword').val('');
- this.searchResult = [];
- this.searchCur = 0;
- $('#dbs-count').html(`结果:${this.searchResult.length}`);
- }
- initDealBillsSearch() {
- const self = this;
- $('#dbs-keyword').change(function () { self.search(this.value); });
- $('#dbs-pre').click(function (e) {
- self.searchPre();
- e.stopPropagation();
- });
- $('#dbs-next').click(function (e) {
- self.searchNext();
- e.stopPropagation();
- });
- $('#dbs-clear').click(function (e) {
- self.searchClear();
- e.stopPropagation();
- });
- }
- loadData () {
- const self = this;
- postData(this.url+'/get-data', {}, function (data) {
- self.data = data;
- SpreadJsObj.loadSheetData(self.spread.getActiveSheet(), 'data', data);
- if (data.length > 0) self.spread.getActiveSheet().setSelection(0, 0, 1, 1);
- });
- }
- calculateData () {
- if (this.data) {
- for (const d of this.data) {
- d.total_price = _.multiply(d.quantity, d.unit_price);
- }
- }
- }
- loadUpdateData(updateData) {
- if (updateData.add) {
- for (const a of updateData.add) {
- this.data.push(a);
- }
- }
- if (updateData.update) {
- for (const u of updateData.update) {
- const d = this.data.find(function (x) {
- return u.id === x.id;
- });
- if (d) {
- _.assign(d, u);
- } else {
- this.data.push(d);
- }
- }
- }
- if (updateData.del) {
- _.remove(this.data, function (d) {
- return updateData.del.indexOf(d.id) >= 0;
- });
- }
- }
- }
- class BatchInsertBillsPosObj {
- constructor (obj) {
- const self = this;
- this.obj = obj;
- this.billsCount = 6;
- this.posCount = 1000;
- this.filter = getLocalCache('zh-calc-batch-filter');
- if (!this.filter) {
- this.filter = '1';
- }
- $('input[name=batch-filter]')[0].checked = this.filter && this.filter != '0';
- // 初始化 清单编号窗口 参数
- this.qdSpreadSetting = {
- cols: [
- {title: '编号', field: 'code', hAlign: 0, width: 80, formatter: '@'},
- {title: '名称', field: 'name', hAlign: 0, width: 120, formatter: '@'},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@'},
- {title: '单价', field: 'unit_price', hAlign: 2, width: 50},
- {title: '图册号', field: 'name', hAlign: 0, width: 60, formatter: '@'},
- ],
- emptyRows: this.billsCount,
- headRows: 1,
- headRowHeight: [32],
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- };
- this.qdSpread = SpreadJsObj.createNewSpread($('.batch-l-t', this.obj)[0]);
- // 初始化 部位数量复核表 参数
- this.posSpreadSetting = {
- cols: [
- {title: '计量单元', field: 'bw', hAlign: 0, width: 80, formatter: '@'},
- {title: '图册号', field: 'drawingCode', hAlign: 0, formatter: '@', width: 60},
- ],
- emptyRows: this.posCount,
- headRows: 1,
- headRowHeight: [32],
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- };
- for (let iNum = 1; iNum <= this.billsCount; iNum++) {
- this.posSpreadSetting.cols.push(
- {title: '清单' + iNum, field: 'bills' + iNum, hAlign: 2, width: 50}
- )
- }
- this.posSpread = SpreadJsObj.createNewSpread($('.batch-l-b', this.obj)[0]);
- // 初始化 签约清单 参数
- this.dealSpreadSetting = {
- cols: [
- {title: '清单编号', field: 'code', width: 80, hAlign: 0, formatter: '@', readOnly: true},
- {title: '名称', field: 'name', width: 230, hAlign: 0, formatter: '@', readOnly: true},
- {title: '单位', field: 'unit', hAlign: 1, width: 50, formatter: '@', readOnly: true},
- {title: '单价', field: 'unit_price', hAlign: 2, width: 60, readOnly: true},
- ],
- emptyRows: 0,
- headRows: 1,
- headRowHeight: [32],
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- };
- this.dealSpread = SpreadJsObj.createNewSpread($('.batch-r', this.obj)[0]);
- this.dealSheet = this.dealSpread.getActiveSheet();
- // 初始化 清单编号、部位数量复核表 表格
- this.initView();
- SpreadJsObj.initSheet(this.dealSpread.getActiveSheet(), this.dealSpreadSetting);
- SpreadJsObj.refreshColumnAlign(this.dealSpread.getActiveSheet());
- $.contextMenu({
- selector: '.batch-l-t',
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, self.qdSpread);
- return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
- },
- items: {
- 'create': {
- name: '新增行',
- icon: 'fa-sign-in',
- callback: function (key, opt) {
- const qdSheet = self.qdSpread.getActiveSheet();
- const posSheet = self.posSpread.getActiveSheet();
- qdSheet.addRows(qdSheet.getRowCount(), 1);
- const index = qdSheet.getRowCount();
- qdSheet.getCell(qdSheet.getRowCount() - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + index);
- posSheet.addColumns(posSheet.getColumnCount(), 1);
- posSheet.getCell(0, index + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + index);
- },
- },
- 'delete': {
- name: '删除行',
- icon: 'fa-remove',
- callback: function (key, opt) {
- const qdSheet = self.qdSpread.getActiveSheet();
- const posSheet = self.posSpread.getActiveSheet();
- const sel = qdSheet.getSelections()[0];
- qdSheet.deleteRows(sel.row, sel.rowCount);
- posSheet.deleteColumns(sel.row + 2, sel.rowCount);
- for (let iRow = 0, iLen = qdSheet.getRowCount(); iRow < iLen; iRow++) {
- qdSheet.getCell(iRow, 0, spreadNS.SheetArea.rowHeader).text('清单' + (iRow+1));
- }
- for (let iCol = 0, iLen = posSheet.getColumnCount() - 2; iCol < iLen; iCol++) {
- posSheet.getCell(0, iCol + 2, spreadNS.SheetArea.colHeader).text('清单' + (iCol+1));
- }
- qdSheet.setSelection(sel.row, sel.col, 1, 1);
- },
- }
- }
- });
- // 拉取签约清单数据
- if (dealBills) {
- SpreadJsObj.loadSheetData(this.dealSpread.getActiveSheet(), 'data', dealBills.data);
- } else {
- postData('/tender/' + getTenderId() + '/deal/get-data', {}, function (data) {
- SpreadJsObj.loadSheetData(self.dealSpread.getActiveSheet(), 'data', data);
- });
- }
- // 双击签约清单,自动添加到清单编号窗口
- this.dealSpread.bind(spreadNS.Events.CellDoubleClick, function (e, info) {
- const deal = info.sheet.zh_data[info.row];
- const qdSheet = self.qdSpread.getActiveSheet(), posSheet = self.posSpread.getActiveSheet();
- const sel = qdSheet.getSelections()[0];
- qdSheet.getCell(sel.row, 0).value(deal.code);
- qdSheet.getCell(sel.row, 1).value(deal.name);
- qdSheet.getCell(sel.row, 2).value(deal.unit);
- qdSheet.getCell(sel.row, 3).value(deal.unit_price);
- if (sel.row + 1 === qdSheet.getRowCount()) {
- const count = sel.row + 2;
- qdSheet.setRowCount(count);
- qdSheet.getCell(sel.row + 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + count);
- const colCount = posSheet.getColumnCount() + 1
- posSheet.setColumnCount(colCount);
- posSheet.getCell(0, colCount - 1, GC.Spread.Sheets.SheetArea.colHeader).text('清单' + count);
- }
- qdSheet.setSelection(sel.row + 1, sel.col, 1, 1);
- });
- this.qdSpread.bind(spreadNS.Events.ClipboardPasting, function (e, info) {
- info.cancel = true;
- const transpose = $('[name=batch-transpose]')[0].checked;
- const pasteData = SpreadJsObj.analysisPasteText(info.pasteData.text, transpose);
- const billsSheet = info.sheet, posSheet = self.posSpread.getActiveSheet();
- const billsCount = info.sheet.getRowCount(), finalCount = info.cellRange.row + pasteData.length + 1;
- SpreadJsObj.beginMassOperation(billsSheet);
- if (finalCount > billsCount) {
- billsSheet.setRowCount(finalCount);
- posSheet.setColumnCount(finalCount + 2);
- for (let i = billsCount - 1; i <= finalCount; i++) {
- billsSheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i);
- posSheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i);
- }
- }
- for (let iRow = 0; iRow < pasteData.length; iRow++) {
- const curRow = iRow + info.cellRange.row;
- pasteData[iRow].forEach((value, iCol) => {
- billsSheet.getCell(curRow, iCol + info.cellRange.col).value(value);
- });
- if ([0, 1].indexOf(info.cellRange.col) >= 0) {
- const dealBills = self.dealSpread.getActiveSheet().zh_data;
- const bills = _.find(dealBills, {code: billsSheet.getText(curRow, 0)});
- if (bills) {
- billsSheet.getCell(curRow, 1).value(bills.name);
- billsSheet.getCell(curRow, 2).value(bills.unit);
- billsSheet.getCell(curRow, 3).value(bills.unit_price);
- }
- }
- }
- SpreadJsObj.endMassOperation(billsSheet);
- });
- this.posSpread.bind(spreadNS.Events.ClipboardPasted, function (e, info) {
- const billsCount = info.sheet.getColumnCount() - 2, qdSheet = self.qdSpread.getActiveSheet();
- const count = qdSheet.getRowCount();
- if (billsCount > count) {
- qdSheet.setRowCount(billsCount);
- for (let i = count + 1; i <= billsCount; i++) {
- qdSheet.getCell(i - 1, 0, spreadNS.SheetArea.rowHeader).text('清单' + i);
- info.sheet.getCell(0, i + 2 - 1, spreadNS.SheetArea.colHeader).text('清单' + i);
- }
- }
- });
- this.qdSpread.bind(spreadNS.Events.EditEnded, function (e, info) {
- if (info.col === 0) {
- const dealBills = self.dealSpread.getActiveSheet().zh_data;
- if (dealBills && dealBills.length > 0) {
- const bills = _.find(dealBills, {code: info.editingText});
- if (bills) {
- info.sheet.getCell(info.row, 1).value(bills.name);
- info.sheet.getCell(info.row, 2).value(bills.unit);
- info.sheet.getCell(info.row, 3).value(bills.unit_price);
- }
- }
- }
- });
- this.obj.bind('shown.bs.modal', function () {
- self.qdSpread.refresh();
- self.posSpread.refresh();
- self.dealSpread.refresh();
- });
- $('#batch-ok').click(function () {
- const sheet = ledgerSpread.getActiveSheet();
- const sel = sheet.getSelections()[0];
- const row = sel.row;
- const select = ledgerTree.nodes[row];
- if (select) {
- const insertData = {};
- insertData.batchType = (select.code && select.code !== '') ? 'child' : 'next';
- insertData.id = ledgerTree.getNodeKey(select);
- insertData.batchData = self.getBatchData();
- if (insertData.batchData.length > 0) {
- postData(window.location.pathname + '/update', {postType: 'batch-insert', postData: insertData}, function (data) {
- pos.updateDatas(data.pos);
- const result = ledgerTree.loadPostData(data.ledger);
- treeOperationObj.refreshTree(sheet, result);
- sheet.setSelection(result.create[0].index, sel.col, sel.rowCount, sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [sel.row, result.create[0].index]);
- treeOperationObj.refreshOperationValid(sheet);
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- self.obj.modal('hide');
- }, null, true);
- } else {
- self.obj.modal('hide');
- }
- }
- });
- $('input[name=batch-filter]').change(function () {
- setLocalCache('zh-calc-batch-filter', this.checked ? 1 : 0);
- });
- this.initDealBillsSearch();
- }
- search(keyword) {
- this.searchResult = [];
- this.searchCur = 0;
- if (keyword) {
- for (const [i, d] of this.dealSheet.zh_data.entries()) {
- if (d.code.indexOf(keyword) >= 0 || d.name.indexOf(keyword) >= 0) this.searchResult.push(d);
- }
- }
- $('#batch-dbs-count').html(`结果:${this.searchResult.length}`);
- if (this.searchResult.length > 0) SpreadJsObj.locateData(this.dealSheet, this.searchResult[0]);
- }
- searchPre() {
- this.searchCur = this.searchCur - 1;
- if (this.searchCur < 0) this.searchCur = this.searchResult.length - 1;
- SpreadJsObj.locateData(this.dealSheet, this.searchResult[this.searchCur]);
- }
- searchNext() {
- this.searchCur = this.searchCur + 1;
- if (this.searchCur >= this.searchResult.length) this.searchCur = 0;
- SpreadJsObj.locateData(this.dealSheet, this.searchResult[this.searchCur]);
- }
- initDealBillsSearch() {
- const self = this;
- $('#batch-dbs-keyword').change(function () { self.search(this.value); });
- $('#batch-dbs-pre').click(function (e) {
- self.searchPre();
- e.stopPropagation();
- });
- $('#batch-dbs-next').click(function (e) {
- self.searchNext();
- e.stopPropagation();
- });
- }
- // 初始化左侧表格
- initView () {
- // 初始化 清单编号
- const qdSheet = this.qdSpread.getActiveSheet();
- qdSheet.setColumnWidth(0, 45, spreadNS.SheetArea.rowHeader);
- SpreadJsObj.initSheet(qdSheet, this.qdSpreadSetting);
- SpreadJsObj.refreshColumnAlign(qdSheet);
- // 清理原有数据
- SpreadJsObj.beginMassOperation(qdSheet);
- qdSheet.clear(0, 0, qdSheet.getRowCount(), qdSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
- for (let iRow = 1; iRow <= this.billsCount; iRow++) {
- qdSheet.getCell(iRow - 1, 0, GC.Spread.Sheets.SheetArea.rowHeader).text('清单' + iRow);
- }
- qdSheet.setSelection(0, 0, 1 ,1);
- SpreadJsObj.endMassOperation(qdSheet);
- // 初始化 部位数量复核表
- const posSheet = this.posSpread.getActiveSheet();
- SpreadJsObj.initSheet(posSheet, this.posSpreadSetting);
- SpreadJsObj.refreshColumnAlign(posSheet);
- // 清理原有数据
- SpreadJsObj.beginMassOperation(posSheet);
- posSheet.setColumnWidth(0, 45, GC.Spread.Sheets.SheetArea.rowHeader);
- posSheet.clear(0, 0, posSheet.getRowCount(), posSheet.getColumnCount(), GC.Spread.Sheets.SheetArea.viewport, GC.Spread.Sheets.StorageType.data);
- posSheet.setSelection(0, 0, 1 ,1);
- SpreadJsObj.endMassOperation(posSheet);
- this.dealSpread.getActiveSheet().setSelection(0, 0, 1, 1);
- }
- // 获取界面数据
- getBatchData () {
- const result = [];
- const qdSheet = this.qdSpread.getActiveSheet(), posSheet = this.posSpread.getActiveSheet();
- for (let iRow = 0; iRow < qdSheet.getRowCount(); iRow++) {
- if (qdSheet.getText(iRow, 0) === '') { continue; }
- const qd = {
- b_code: qdSheet.getText(iRow, 0),
- name: qdSheet.getText(iRow, 1),
- unit: qdSheet.getText(iRow, 2),
- price: _.toNumber(qdSheet.getText(iRow, 3)),
- pos: [],
- };
- for (let iPosRow = 0; iPosRow < posSheet.getRowCount(); iPosRow++) {
- const value = _.toNumber(posSheet.getText(iPosRow, iRow + 2));
- if (value !== 0 && !isNaN(value)) {
- qd.pos.push({
- name: posSheet.getText(iPosRow, 0),
- drawing_code: posSheet.getText(iPosRow, 1),
- quantity: value, porder: qd.pos.length + 1,
- });
- }
- }
- if (!$('input[name=batch-filter]')[0].checked || qd.pos.length > 0) result.push(qd);
- }
- return result;
- }
- }
- class ContractExpr {
- constructor(setting) {
- const self = this;
- this.obj = $('#contract_expr');
- this.exprObj = $('#ce-expr');
- this.exprSpread = SpreadJsObj.createNewSpread($('#expr_spread')[0]);
- this.exprSheet = this.exprSpread.getActiveSheet();
- const exprSpreadSetting = {
- cols: [
- { title: '项目节编号', colSpan: '1', rowSpan: '2', field: 'code', hAlign: 0, width: 180, formatter: '@', cellType: 'tree' },
- { title: '清单编号', colSpan: '1', rowSpan: '2', field: 'b_code', hAlign: 0, width: 100, formatter: '@' },
- { title: '名称', colSpan: '1', rowSpan: '2', field: 'name', hAlign: 0, width: 230, formatter: '@' },
- { title: '单位', colSpan: '1', rowSpan: '2', field: 'unit', hAlign: 1, width: 60, formatter: '@', cellType: 'unit' },
- ],
- emptyRows: 0,
- headRows: 2,
- headRowHeight: [25, 25],
- defaultRowHeight: 21,
- headerFont: '12px 微软雅黑',
- font: '12px 微软雅黑',
- readOnly: true,
- getColor: function (sheet, data, row, col, defaultColor) {
- if (self.targetNode && data && data.id === self.targetNode.id) {
- return spreadColor.pay.expr_err;
- } if (self.invalidRows && self.invalidRows.indexOf(row + 1) >= 0) {
- return spreadColor.pay.yf_without;
- } else {
- return defaultColor;
- }
- }
- };
- sjsSettingObj.setFxTreeStyle(exprSpreadSetting, sjsSettingObj.FxTreeStyle.jz);
- SpreadJsObj.initSheet(this.exprSheet, exprSpreadSetting);
- this.exprTree = createNewPathTree('ledger', {
- id: 'ledger_id',
- pid: 'ledger_pid',
- order: 'order',
- level: 'level',
- rootId: -1,
- keys: ['id', 'tender_id', 'ledger_id'],
- });
- this.exprTree.loadDatas(setting.sourceTree.datas);
- SpreadJsObj.loadSheetData(this.exprSheet, SpreadJsObj.DataType.Tree, this.exprTree);
- // this.exprSpread.bind(spreadNS.Events.SelectionChanged, function(e, info) {
- // const select = SpreadJsObj.getSelectObject(info.sheet);
- // if (select && self.targetNode && select.id === self.targetNode.id) {
- // $('#select-row').html('');
- // } else {
- // $('#select-row').html(`(${select.code || ''}${select.b_code || ''})`);
- // }
- // });
- this.obj.bind('shown.bs.modal', function () {
- self.exprSpread.refresh();
- });
- $('td[exprValue]').dblclick(function() {
- const name = this.getAttribute('name');
- let row;
- if (name === 'tr') {
- row = self.targetRow;
- } else {
- const node = SpreadJsObj.getSelectObject(self.exprSheet);
- if (node.id === self.targetNode.id) return;
- row = self.exprTree.nodes.indexOf(node) + 1;
- }
- if (self.invalidRows.indexOf(row) >= 0) return;
- self.exprObj.val(self.exprObj.val() + `<<f${row}$${this.getAttribute('exprValue')}>>`);
- });
- $('#contract-expr-ok').click(function() {
- const exprStr = $('#ce-expr').val().toLowerCase();
- if ((!exprStr && !self.orgExpr) || (exprStr === self.orgExpr)) {
- self.obj.modal('hide');
- return;
- }
- const [valid, msg] = TreeExprCalc.checkExprValid(exprStr, self.invalidRows);
- if (!valid) {
- toastr.error(msg);
- return;
- }
- const expr = TreeExprCalc.exprStr2Expr(exprStr);
- if (expr.length > 500) {
- toastr.error('输入表达式过长');
- return;
- }
- // $('#ce-expr-org').val(expr + ' ' + TreeExprCalc.expr2ExprStr(expr));
- postData('expr/save', { calc_module: 'stage', calc_tag: 'contract', calc_id: self.targetNode.id, expr }, function() {
- self.targetNode.contract_expr = expr;
- self.obj.modal('hide');
- });
- });
- this.initLedgerSearch();
- this.initShowLevel();
- TreeExprCalc.init({ tree: this.exprTree });
- }
- search(keyword) {
- this.searchResult = [];
- this.searchCur = 0;
- if (keyword) {
- for (const [i, d] of this.exprSheet.zh_tree.nodes.entries()) {
- if (d.code && d.code.indexOf(keyword) >= 0) {
- this.searchResult.push(d);
- continue;
- }
- if (d.b_code && d.b_code.indexOf(keyword) >= 0) {
- this.searchResult.push(d);
- continue;
- }
- if (d.name && d.name.indexOf(keyword) >= 0) {
- this.searchResult.push(d);
- continue;
- }
- }
- }
- $('#expr_search_count').html(`结果:${this.searchResult.length}`);
- if (this.searchResult.length > 0) SpreadJsObj.locateTreeNode(this.exprSheet, this.searchResult[0].ledger_id);
- }
- searchPre() {
- this.searchCur = this.searchCur - 1;
- if (this.searchCur < 0) this.searchCur = this.searchResult.length - 1;
- SpreadJsObj.locateTreeNode(this.exprSheet, this.searchResult[this.searchCur].ledger_id);
- }
- searchNext() {
- this.searchCur = this.searchCur + 1;
- if (this.searchCur >= this.searchResult.length) this.searchCur = 0;
- SpreadJsObj.locateTreeNode(this.exprSheet, this.searchResult[this.searchCur].ledger_id);
- }
- initLedgerSearch() {
- const self = this;
- this.searchResult = [];
- this.searchCur = 0;
- $('#expr_search_count').html(`结果:${this.searchResult.length}`);
- $('#expr_search_keyword').change(function () { self.search(this.value); });
- $('#expr_search_pre').click(function (e) {
- self.searchPre();
- e.stopPropagation();
- });
- $('#expr_search_next').click(function (e) {
- self.searchNext();
- e.stopPropagation();
- });
- }
- initShowLevel(){
- // 显示层次
- (function (select, sheet) {
- $(select).click(function () {
- const tag = $(this).attr('tag');
- const tree = sheet.zh_tree;
- if (!tree) return;
- setTimeout(() => {
- showWaitingView();
- switch (tag) {
- case "1":
- case "2":
- case "3":
- case "4":
- case "5":
- tree.expandByLevel(parseInt(tag));
- SpreadJsObj.refreshTreeRowVisible(sheet);
- break;
- case "last":
- tree.expandByCustom(() => { return true; });
- SpreadJsObj.refreshTreeRowVisible(sheet);
- break;
- case "leafXmj":
- tree.expandToLeafXmj();
- SpreadJsObj.refreshTreeRowVisible(sheet);
- break;
- }
- closeWaitingView();
- }, 100);
- });
- })('a[name=ce-showLevel]', this.exprSheet);
- }
- async setTargetNode(node) {
- const self = this;
- this.targetNode = node;
- const relaNode = this.exprTree.getItems(node.ledger_id);
- this.invalidNode = this.exprTree.getAllParents(relaNode);
- this.invalidRows = this.invalidNode.map(x => {
- return self.exprTree.nodes.indexOf(x) + 1;
- });
- this.targetRow = this.exprTree.nodes.indexOf(relaNode) + 1;
- if (node.contract_expr === undefined) {
- node.contract_expr = await postDataAsync('expr/load', {calc_module: 'stage', calc_tag: 'contract', calc_id: node.id});
- }
- this.orgExpr = node.contract_expr;
- $('#ce-expr').val(TreeExprCalc.expr2ExprStr(this.orgExpr));
- }
- initView(node) {
- this.orgExpr = '';
- this.setTargetNode(node);
- $('#expr-hint').html(`${node.code || ''}${node.b_code || ''} ${node.name || ''}`);
- $('#target-row').html(`(${node.code || ''}${node.b_code || ''})`);
- SpreadJsObj.locateTreeNode(this.exprSheet, node.ledger_id);
- SpreadJsObj.reloadRowBackColor(this.exprSheet, 0, this.exprSheet.getRowCount());
- this.exprSpread.refresh();
- }
- }
- $('a', '#anc-gcl-nav').bind('click', function(e) {
- e.preventDefault();
- const tab = $(this);
- const showSideTab = function (show) {
- const left = $('#pos-spread'), right = $('#pos-right'), parent = left.parent();
- if (show) {
- right.show();
- autoFlashHeight();
- /**
- * right.show()后, parent被撑开成2倍left.height, 导致parent.width减少了10px
- * 第一次left.width调整后,parent的缩回left.height, 此时parent.width又增加了10px
- * 故需要通过最终的parent.width再计算一次left.width
- *
- * Q: 为什么不通过先计算left.width的宽度,以避免计算两次left.width?
- * A: 右侧工具栏不一定显示,当右侧工具栏显示过一次后,就必须使用parent和right来计算left.width
- *
- */
- const percent = 100 - right.outerWidth() /parent.width() * 100;
- left.css('width', percent + '%');
- } else {
- left.width(parent.width());
- right.hide();
- }
- };
- if (!tab.hasClass('active')) {
- tab.addClass('active');
- showSideTab(tab.hasClass('active'));
- } else {
- tab.removeClass('active');
- showSideTab(tab.hasClass('active'));
- }
- if (posSpread) posSpread.refresh();
- if (ancGclSpread) ancGclSpread.refresh();
- });
- $.divResizer({
- select: '#pos-right-spr',
- callback: function () {
- if (posSpread) posSpread.refresh();
- if (ancGclSpread) ancGclSpread.refresh();
- }
- });
- // $('#searchAccount').click(() => {
- // const data = {
- // keyword: $('#searchName').val(),
- // };
- // postData('/search/user', data, (data) => {
- // const resultDiv = $('#searchResult');
- // if (data) {
- // $('h5>span', resultDiv).text(data.name);
- // $('#addAuditor').attr('auditorId', data.id);
- // $('h6', resultDiv).text(data.role);
- // $('p', resultDiv).text(data.company);
- // resultDiv.show();
- // } else {
- // toastr.info('未查询到该审核人');
- // resultDiv.hide();
- // }
- // }, () => {
- // $('#searchResult').hide();
- // });
- // });
- // // 审批人分组选择
- // $('#account_group').change(function () {
- // let account_html = '<option value="0">选择审批人</option>';
- // for (const account of accountList) {
- // if (parseInt($(this).val()) === 0 || parseInt($(this).val()) === account.account_group) {
- // const role = account.role !== '' ? '(' + account.role + ')' : '';
- // const company = account.company !== '' ? ' -' + account.company : '';
- // account_html += '<option value="' + account.id + '">' + account.name + role + company + '</option>';
- // }
- // }
- // $('#account_list').html(account_html);
- // });
- let timer = null;
- let oldSearchVal = null;
- $('#gr-search').bind('input propertychange', function(e) {
- oldSearchVal = e.target.value
- timer && clearTimeout(timer)
- timer = setTimeout(() => {
- const newVal = $('#gr-search').val()
- let html = ''
- if (newVal && newVal === oldSearchVal) {
- accountList.filter(item => item && (item.name.indexOf(newVal) !== -1 || (item.mobile && item.mobile.indexOf(newVal) !== -1))).forEach(item => {
- html += `<dd class="border-bottom p-2 mb-0 " data-id="${item.id}" >
- <p class="mb-0 d-flex"><span class="text-primary">${item.name}</span><span
- class="ml-auto">${item.mobile || ''}</span></p>
- <span class="text-muted">${item.role || ''}</span>
- </dd>`
- })
- $('.book-list').empty()
- $('.book-list').append(html)
- } else {
- if (!$('.acc-btn').length) {
- accountGroup.forEach((group, idx) => {
- if (!group) return
- html += `<dt><a href="javascript: void(0);" class="acc-btn" data-groupid="${idx}" data-type="hide"><i class="fa fa-plus-square"></i>
- </a> ${group.groupName}</dt>
- <div class="dd-content" data-toggleid="${idx}">`
- group.groupList.forEach(item => {
- html += `<dd class="border-bottom p-2 mb-0 " data-id="${item.id}" >
- <p class="mb-0 d-flex"><span class="text-primary">${item.name}</span><span
- class="ml-auto">${item.mobile || ''}</span></p>
- <span class="text-muted">${item.role || ''}</span>
- </dd>`
- });
- html += '</div>'
- })
- $('.book-list').empty()
- $('.book-list').append(html)
- }
- }
- }, 400);
- });
- // 添加审批流程按钮逻辑
- $('.book-list').on('click', 'dt', function () {
- const idx = $(this).find('.acc-btn').attr('data-groupid')
- const type = $(this).find('.acc-btn').attr('data-type')
- if (type === 'hide') {
- $(this).parent().find(`div[data-toggleid="${idx}"]`).show(() => {
- $(this).children().find('i').removeClass('fa-plus-square').addClass('fa-minus-square-o')
- $(this).find('.acc-btn').attr('data-type', 'show')
- })
- } else {
- $(this).parent().find(`div[data-toggleid="${idx}"]`).hide(() => {
- $(this).children().find('i').removeClass('fa-minus-square-o').addClass('fa-plus-square')
- $(this).find('.acc-btn').attr('data-type', 'hide')
- })
- }
- return false
- });
- // 添加到审批流程中
- $('dl').on('click', 'dd', function () {
- const auditorId = parseInt($(this).data('id'))
- if (auditorId) {
- postData('/tender/' + getTenderId() + '/ledger/audit/add', { auditorId }, (datas) => {
- const html = [];
- // 如果是重新上报,添加到重新上报列表中
- const auditorshtml = [];
- for (const [index,data] of datas.entries()) {
- if (index !== 0) {
- html.push('<li class="list-group-item" auditorId="' + data.audit_id + '">');
- if (shenpi_status === shenpiConst.sp_status.sqspr || (shenpi_status === shenpiConst.sp_status.gdzs && index+1 !== datas.length)) {
- html.push('<a href="javascript: void(0)" class="text-danger pull-right">移除</a>');
- }
- html.push('<span>');
- html.push(data.audit_order + ' ');
- html.push(data.name + ' ');
- html.push('</span>');
- html.push('<small class="text-muted">');
- html.push(data.role);
- html.push('</small></li>');
- }
- auditorshtml.push('<li class="list-group-item" ' + (index !== 0 ? 'data-auditorid="' + data.audit_id + '"' : '') + '>');
- auditorshtml.push('<i class="fa ' + (index+1 === datas.length ? 'fa-stop-circle' : 'fa-chevron-circle-down') + '"></i> ');
- auditorshtml.push(data.name + ' <small class="text-muted">' + data.role + '</small>');
- if (index === 0) {
- auditorshtml.push('<span class="pull-right">原报</span>');
- } else if (index+1 === datas.length) {
- auditorshtml.push('<span class="pull-right">终审</span>');
- } else {
- auditorshtml.push('<span class="pull-right">'+ transFormToChinese(index) +'审</span>');
- }
- auditorshtml.push('</li>');
- }
- $('#auditors').html(html.join(''));
- $('#auditors-list').html(auditorshtml.join(''));
- });
- }
- });
- $('body').on('click', '#auditors li>a', function () {
- const li = $(this).parent();
- const data = {
- auditorId: parseInt(li.attr('auditorId')),
- };
- postData('/tender/' + getTenderId() + '/ledger/audit/delete', data, (data2) => {
- li.remove();
- for (const a of data2) {
- const aLi = $('li[auditorId=' + a.audit_id + ']');
- $('span', aLi).text(a.audit_order + ' ' + a.name + ' ');
- }
- // 如果是重新上报
- // 令最后一个图标转换
- $('#auditors-list li[data-auditorid="' + data.auditorId + '"]').remove();
- if ($('#auditors-list li').length !== 0 && !$('#auditors-list li i').hasClass('fa-stop-circle')) {
- $('#auditors-list li').eq($('#auditors-list li').length-1).children('i')
- .removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
- }
- // $('#auditors-list2 li[data-auditid="' + data.auditorId + '"]').remove();
- // if ($('#auditors-list2 li').length !== 0 && !$('#auditors-list2 li i').hasClass('fa-stop-circle')) {
- // $('#auditors-list2 li').eq($('#auditors-list2 li').length-1).children('i')
- // .removeClass('fa-chevron-circle-down').addClass('fa-stop-circle');
- // }
- for (let i = 0; i < $('#auditors-list li').length; i++) {
- $('#auditors-list li').eq(i).find('.pull-right').text(i === 0 ? '原报' : (i+1 === $('#auditors-list li').length ? '终' : transFormToChinese(i)) + '审')
- // $('#auditors-list2 li').eq(i).find('.pull-right').text((i+1 === $('#auditors-list2 li').length ? '终' : transFormToChinese(i+1)) + '审')
- }
- });
- });
- $('#hideSp').click(function () {
- $('#sp-list').modal('hide');
- });
- // 多层modal关闭后的滚动bug修复
- $('#sp-list').on('hidden.bs.modal', function (e) {
- $(document.body).addClass('modal-open');
- });
- // 显示层次
- (function (select, sheet) {
- $(select).click(function () {
- const tag = $(this).attr('tag');
- const tree = sheet.zh_tree;
- if (!tree) return;
- setTimeout(() => {
- showWaitingView();
- switch (tag) {
- case "1":
- case "2":
- case "3":
- case "4":
- case "5":
- tree.expandByLevel(parseInt(tag));
- SpreadJsObj.refreshTreeRowVisible(sheet);
- break;
- case "last":
- tree.expandByCustom(() => { return true; });
- SpreadJsObj.refreshTreeRowVisible(sheet);
- break;
- case "leafXmj":
- tree.expandToLeafXmj();
- SpreadJsObj.refreshTreeRowVisible(sheet);
- break;
- }
- closeWaitingView();
- }, 100);
- });
- })('a[name=showLevel]', ledgerSpread.getActiveSheet());
- // $('#exportLedger').click(function () {
- // const data = [];
- // const setting = {
- // header: ['项目节编号', '清单子目号', '部位明细', '名称', '单位', '清单数量', '设计数量1', '设计数量2', '单价', '合价', '图号', '备注'],
- // width: [100, 70, 70, 300, 60, 80, 80, 80, 80, 80, 100, 100],
- // hAlign: ['left', 'left', 'left', 'left','center', 'right', 'right', 'right', 'right', 'right', 'left', 'left'],
- // };
- // for (const node of ledgerTree.nodes) {
- // data.push([node.code, node.b_code, '', node.name, node.unit,
- // node.quantity, node.dgn_qty1, node.dgn_qty2, node.unit_price, node.total_price,
- // node.drawing_code, node.memo
- // ]);
- // const posRange = pos.getLedgerPos(node.id);
- // if (posRange && posRange.length > 0) {
- // for (const [i, p] of posRange.entries()) {
- // data.push(['', '', (i + 1) + '', p.name, '',
- // p.quantity, '', '', '', '',
- // p.drawing_code, p.memo
- // ]);
- // }
- // }
- // }
- //
- // XLSXObj.exportXlsxSheet(setting, data, "台账分解.xlsx");
- // });
- $('#exportLedger').click(function () {
- const data = [];
- const setting = {
- cols: [
- {title: '项目节编号', colSpan: '1', rowSpan: '1', field: 'code', hAlign: 0, width: 100, formatter: '@'},
- {title: '清单子目号', colSpan: '1', rowSpan: '1', field: 'b_code', hAlign: 0, width: 70, formatter: '@'},
- {title: '计量单元', colSpan: '1', rowSpan: '1', field: 'pos_code', hAlign: 1, width: 70, formatter: '@'},
- {title: '名称', colSpan: '1', rowSpan: '1', field: 'name', hAlign: 0, width: 300, formatter: '@'},
- {title: '单位', colSpan: '1', rowSpan: '1', field: 'unit', hAlign: 1, width: 60, formatter: '@'},
- {title: '签约数量', colSpan: '1', rowSpan: '1', field: 'deal_qty', hAlign: 2, width: 80, type: 'Number'},
- {title: '签约金额', colSpan: '1', rowSpan: '1', field: 'deal_tp', hAlign: 2, width: 80, type: 'Number'},
- {title: '清单数量', colSpan: '1', rowSpan: '1', field: 'quantity', hAlign: 2, width: 80, type: 'Number'},
- {title: '设计数量1', colSpan: '1', rowSpan: '1', field: 'dgn_qty1', hAlign: 2, width: 80, type: 'Number'},
- {title: '设计数量2', colSpan: '1', rowSpan: '1', field: 'dgn_qty2', hAlign: 2, width: 80, type: 'Number'},
- {title: '单价', colSpan: '1', rowSpan: '1', field: 'unit_price', hAlign: 2, width: 80, type: 'Number'},
- {title: '合价', colSpan: '1', rowSpan: '1', field: 'total_price', hAlign: 2, width: 80, type: 'Number'},
- {title: '图号', colSpan: '1', rowSpan: '1', field: 'drawing_code', hAlign: 0, width: 100, formatter: '@'},
- {title: '备注', colSpan: '1', rowSpan: '1', field: 'memo', hAlign: 0, width: 100, formatter: '@'},
- ],
- headRows: 1,
- headRowHeight: [32],
- defaultRowHeight: 21,
- headerFont: 'bold 10px 微软雅黑',
- font: '10px 微软雅黑'
- };
- const hasCl = ledgerSpreadSetting.cols.find(x => { return x.field === 'sjcl_qty'});
- const qtyF = hasCl ? 'quantity' : 'sgfh_qty';
- const tpF = hasCl ? 'total_price' : 'sgfh_tp';
- for (const node of ledgerTree.nodes) {
- data.push({
- code: node.code, b_code: node.b_code, name: node.name, unit: node.unit,
- unit_price: node.unit_price, quantity: node[qtyF], total_price: node[tpF],
- deal_qty: node.deal_qty, deal_tp: node.deal_tp,
- dgn_qty1: node.dgn_qty1, dgn_qty2: node.dgn_qty2,
- drawing_code: node.drawing_code, memo: node.memo
- });
- const posRange = pos.getLedgerPos(node.id);
- if (posRange && posRange.length > 0) {
- for (const [i, p] of posRange.entries()) {
- data.push({
- pos_code: (i + 1) + '', name: p.name,
- quantity: p[qtyF], drawing_code: p.drawing_code, memo: p.memo
- });
- }
- }
- }
- SpreadExcelObj.exportSimpleXlsxSheet(setting, data, "台账分解.xlsx");
- });
- $('#sync-ledger').click(function () {
- postData(syncLedgerUrl, {}, function (result) {
- ledgerTree.loadDatas(result.bills);
- treeCalc.calculateAll(ledgerTree);
- SpreadJsObj.loadSheetData(ledgerSpread.getActiveSheet(), 'tree', ledgerTree);
- pos.loadDatas(result.pos);
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- checkShowLast(result.bills.length);
- });
- });
- const dataChecker = DataChecker({
- checkUrl: window.location.pathname + '/check',
- completeData: function (data) {
- pos.updateDatas({update: data.source.pos});
- const loadResult = ledgerTree.loadPostData({update: data.source.bills});
- treeOperationObj.refreshTree(ledgerSpread.getActiveSheet(), loadResult);
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- for (const e of data.error) {
- e.serialNo = ledgerTree.getNodeIndex(ledgerTree.getItems(e.ledger_id)) + 1;
- }
- },
- errorList: errorList,
- });
- $('[name=audit-start]').submit(function (e) {
- if (checkAuditorFrom()) {
- $(this).parent().parent().parent().modal('hide');
- dataChecker.checkAndPost(this.action, {});
- $('#hide-all').hide();
- }
- return false;
- });
- $('#ledger-check2').click(() => {
- ledgerCheck2({
- ledgerTree: ledgerTree,
- ledgerPos: pos,
- checkList: checkList,
- decimal: tenderInfo.decimal,
- checkOption: checkOption,
- }).then(result => {
- check2Viewing({
- extra: ZhCalc.div(ledgerTree.datas.length + pos.datas.length, 10000, 0),
- randomWait: true,
- prefix: 'check2-',
- checks: result,
- checkList: checkList,
- });
- });
- });
- // 切换附件里节点和所有附件
- $('#fujian .nav-link').on('click', function () {
- const tabPanel = $(this).attr('fujian-content');
- if (tabPanel !== 'syfujian') {
- $('#showPage').hide();
- $('#bach-download').prop('type', 'curr');
- } else {
- $('#showPage').show();
- $('#bach-download').prop('type', 'all');
- }
- $('#showAttachment').hide();
- });
- // 上传附件
- $('#upload-file-btn').click(function () {
- // if (curAuditor && curAuditor.aid !== cur_uid) {
- // return toastr.error('当前操作没有权限!');
- // }
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- if (!node) return;
- const files = $('#upload-file')[0].files;
- const formData = new FormData();
- formData.append('lid', node.id);
- for (const file of files) {
- if (file === undefined) {
- toastr.error('未选择上传文件!');
- return false;
- }
- const filesize = file.size;
- if (filesize > 30 * 1024 * 1024) {
- toastr.error('存在上传文件大小过大!');
- return false;
- }
- const fileext = '.' + file.name.toLowerCase().split('.').splice(-1)[0];
- if (whiteList && !whiteList.includes(fileext)) {
- toastr.error('只能上传指定格式的附件!');
- return false;
- }
- formData.append('size', filesize);
- formData.append('file[]', file);
- }
- postDataWithFile('/tender/' + tender.id + '/ledger/upload/file', formData, function (data) {
- $('#upload').modal('hide');
- // 插入到attData中
- attData = data.concat(attData);
- // 重新生成List
- getAllList();
- getNodeList(node.id);
- }, function () {
- toastr.error('附件上传失败');
- });
- $('#upload-file').val('');
- });
- // 获取附件信息
- $('.list-table').on('click', '.att-file-name', function () {
- const fid = $(this).attr('file-id');
- if ($('#showAttachment').attr('file-id') === fid && !$('#showAttachment').is(":hidden")) {
- return;
- }
- const att = attData.find(function (item) {
- return item.id === parseInt(fid);
- });
- $('#edit-att').hide();
- $('#show-att').show();
- if (att !== undefined) {
- // 进来先把编辑功能隐藏
- $('#btn-att a').eq(3).hide()
- $('#show-att tr').eq(0).children('td').text(att.filename + att.fileext);
- const name = att.code !== null && att.code !== '' ? att.code : (att.b_code !== null ? att.b_code : '');
- $('#show-att tr').eq(1).children('td').text($.trim(name + ' ' + att.lname));
- // $('#show-att tr').eq(2).find('a').attr('href', '/tender/' + tender.id + '/measure/stage/' + stage.order + '/download/file/' + att.id);
- // $('#show-att tr').eq(2).find('a').attr('href', att.filepath);
- $('#show-att tr').eq(2).children('td').eq(0).text(att.username);
- $('#show-att tr').eq(2).children('td').eq(1).text(att.in_time);
- $('#show-att tr').eq(3).children('td').text(att.remark);
- // 附件uid等于当前用户id, 附件上传本人
- if (parseInt(cur_uid) === att.uid) {
- $('#btn-att').show();
- const showDel = tender.ledger_status === auditConst.status.checked ? Boolean(att.extra_upload) : true;
- if (showDel) $('#btn-att a').eq(3).show();
- // $('#btn-att a').eq(3).show();
- $('#btn-att a').eq(2).hide();
- $('#btn-att a').eq(4).hide();
- $('#btn-att a').eq(5).hide();
- } else {
- $('#btn-att').hide();
- $('#btn-att a').eq(3).hide();
- $('#btn-att a').eq(2).hide();
- $('#btn-att a').eq(4).hide();
- $('#btn-att a').eq(5).hide();
- }
- $('#showAttachment').attr('file-id', fid);
- $('#showAttachment').show();
- } else {
- $('#showAttachment').hide();
- $('#showAttachment').attr('file-id', '');
- toastr.error('附件信息获取失败');
- }
- });
- // $('body').on('click', '.alllist-table a', handleFileList);
- $('body').on('click', '#btn-att a', function () {
- const content = $(this).attr('content');
- const fid = $('#showAttachment').attr('file-id');
- const node = SpreadJsObj.getSelectObject(ledgerSpread.getActiveSheet());
- if (content === 'edit') {
- $('#btn-att a').eq(3).hide();
- $('#btn-att a').eq(2).show();
- $('#btn-att a').eq(4).show();
- $('#btn-att a').eq(5).show();
- $('#show-att').hide();
- $('#edit-att').show();
- const att = attData.find(function (item) {
- return item.id === parseInt(fid);
- });
- $('#edit-att .form-group').eq(0).find('input').val(att.filename);
- $('#edit-att .form-group').eq(0).find('span').eq(1).text(att.fileext);
- const name = att.code !== null && att.code !== '' ? att.code : (att.b_code !== null ? att.b_code : '');
- $('#edit-att .form-group').eq(1).find('input').val($.trim(name + ' ' + att.lname));
- $('#edit-att .form-group').eq(2).find('input').val(att.in_time);
- $('#edit-att .form-group').eq(3).find('input').val(att.remark);
- } else if (content === 'cancel') {
- $('#show-att').show();
- $('#edit-att').hide();
- $('#btn-att a').eq(3).show();
- $('#btn-att a').eq(2).hide();
- $('#btn-att a').eq(4).hide();
- $('#btn-att a').eq(5).hide();
- } else if (content === 'save') {
- const formData = new FormData();
- formData.append('id', fid);
- formData.append('filename', $('#edit-att .form-group').eq(0).find('input').val());
- formData.append('fileext', $('#edit-att .form-group').eq(0).find('span').eq(1).text());
- formData.append('remark', $('#edit-att .form-group').eq(3).find('input').val());
- const file = $('#change-att-btn')[0];
- if (file.files[0] !== undefined) {
- const filesize = file.files[0].size;
- formData.append('size', filesize);
- formData.append('file', file.files[0]);
- }
- postDataWithFile('/tender/' + tender.id + '/ledger/save/file', formData, function (data) {
- // 替换到attData中
- const att_index = attData.findIndex(function (item) {
- return item.id === parseInt(fid);
- });
- attData.splice(att_index, 1, data);
- // 重新生成List
- getAllList(parseInt($('#currentPage').text()));
- getNodeList(node.id);
- $('#show-att').show();
- $('#edit-att').hide();
- $('#show-att tr').eq(0).children('td').text(data.filename + data.fileext);
- const name = data.code !== null && data.code !== '' ? data.code : (data.b_code !== null ? data.b_code : '');
- $('#show-att tr').eq(1).children('td').text($.trim(name + ' ' + data.lname));
- $('#show-att tr').eq(2).children('td').eq(0).text(data.username);
- $('#show-att tr').eq(2).children('td').eq(1).text(data.in_time);
- $('#show-att tr').eq(3).children('td').text(data.remark);
- $('#btn-att a').eq(3).show();
- $('#btn-att a').eq(2).hide();
- $('#btn-att a').eq(4).hide();
- $('#btn-att a').eq(5).hide();
- }, function () {
- toastr.error('附件上传失败');
- });
- $('#change-att-btn').val('');
- } else if (content === 'del') {
- const data = {id: fid};
- postData('/tender/' + tender.id + '/ledger/delete/file', data, function (result) {
- // 删除到attData中
- const att_index = attData.findIndex(function (item) {
- return item.id === parseInt(fid);
- });
- attData.splice(att_index, 1);
- // 重新生成List
- if ($('#alllist-table tr').length === 1) {
- getAllList(parseInt($('#currentPage').text()) - 1);
- } else {
- getAllList(parseInt($('#currentPage').text()));
- }
- getNodeList(node.id);
- $('#showAttachment').hide();
- $('#showAttachment').attr('file-id', '');
- });
- } else if (content === 'view') {
- const data = {id: fid};
- postData('/tender/' + tender.id + '/ledger/check/file', data, function (result) {
- const { filepath } = result
- $('#load-file').attr('href', filepath);
- $('#load-file')[0].click();
- });
- } else if (content === 'location') {
- const att = attData.find(item => item.id === parseInt(fid));
- if (Object.keys(att).length) {
- SpreadJsObj.locateTreeNode(ledgerSpread.getActiveSheet(), att.ledger_id, true);
- posOperationObj.loadCurPosData();
- ancGclObj.loadCurAncillaryGcl();
- }
- }
- });
- // 替换附件
- $('#change-att-btn').on('change', function () {
- const file = $('#change-att-btn')[0].files[0];
- const name = file.name;
- const filename = name.substring(0, name.lastIndexOf("."));
- const fileext = name.substr(name.indexOf("."));
- const filesize = file.size;
- if (filesize > 30 * 1024 * 1024) {
- toastr.error('文件大小过大!');
- $('#change-att-btn').val('');
- return false;
- }
- if (whiteList && !whiteList.includes(fileext)) {
- toastr.error('只能上传指定格式的附件!');
- $('#change-att-btn').val('');
- return false;
- }
- $('#edit-att .form-group').eq(0).find('input').val(filename);
- $('#edit-att .form-group').eq(0).find('span').eq(1).text(fileext);
- });
- // 切换页数
- $('.page-select').on('click', function () {
- const totalPageNum = parseInt($('#totalPage').text());
- const lastPageNum = parseInt($('#currentPage').text());
- const status = $(this).attr('content');
- if (status === 'pre' && lastPageNum > 1) {
- getAllList(lastPageNum-1);
- $('#showAttachment').hide();
- $('#syfujian .check-all-file').prop('checked', false)
- } else if (status === 'next' && lastPageNum < totalPageNum) {
- getAllList(lastPageNum+1);
- $('#showAttachment').hide();
- $('#syfujian .check-all-file').prop('checked', false)
- }
- });
- // 批量下载
- $('#bach-download').click(function() {
- const fileIds = [];
- const type = $(this).attr('type');
- let node = ''
- if (type === 'curr') {
- node = '#nodelist-table .check-file:checked'
- } else {
- node = '#alllist-table .check-file:checked'
- }
- $(node).each(function() {
- const fileId = $(this).attr('file-id');
- fileId && fileIds.push(fileId);
- });
- if (fileIds.length) {
- if (fileIds.length > 20) {
- return toastr.warning(`最大允许20个文件(当前${fileIds.length}个)`)
- }
- toastr.success('正在进行压缩文件...', '', { timeOut: 0, extendedTimeOut: 0})
- $(this).attr('disabled', "true")
- const btn = $(this);
- const fileArr = [];
- for (const id of fileIds) {
- const fileInfo = _.find(currPageFileData, { id: parseInt(id) });
- fileArr.push({
- url: fileInfo.orginpath, //文件的oss存储路径 (必填)
- name: fileInfo.filename, // 文件名 (可选, 不需要填扩展名)
- foldPath: '' // (可选, 文件在压缩包中的存储路径)
- });
- }
- const packageName = `${tender.name}-台账分解-附件.zip`;
- try {
- zipOss.downloadFromAliOss(fileArr, packageName, btn);
- } catch (e) {
- btn.removeAttr('disabled');
- toastr.clear();
- toastr.error('批量下载失败');
- }
- // postCompressFile(`/tender/${tender.id}/ledger/compresse/file`, {fileIds}, function(result) {
- // toastr.clear()
- // toastr.success('压缩文件成功')
- // btn.removeAttr('disabled')
- // const href = window.URL.createObjectURL(result)
- // $('#zipDown').attr('href', href);
- // $('#zipDown').attr('download', `${tender.name}-台账分解-附件.zip`);
- // $("#zipDown")[0].click();
- // }, () => {
- // btn.removeAttr('disabled')
- // toastr.clear()
- // toastr.error('批量下载失败')
- // });
- // const url = `/tender/${tender.id}/ledger/compresse/file?fileIds=${JSON.stringify(fileIds)}`;
- }
- });
- // 监听附件check是否选中
- $('.list-table').on('click', '.check-file', function() {
- const checkedList = $(this).parents('.list-table').children().find('input:checked');
- const childs = $(this).parents('.list-table').children().length;
- const checkBox = $(this).parents('.list-table').parent().find('.check-all-file');
- if (checkedList.length === childs) {
- checkBox.prop("checked", true);
- } else {
- checkBox.prop("checked", false);
- }
- });
- $('.check-all-file').click(function() {
- const isCheck = $(this).is(':checked');
- $(this).parents('table').find('.list-table').each(function() {
- $(this).find('input:checkbox').prop("checked", isCheck);
- })
- });
- });
- // 生成当前节点列表
- function getNodeList(node) {
- let html = '';
- for(const att of attData) {
- if (node === att.lid) {
- // html += '<tr><td><a href="javascript:void(0)" file-id="'+ att.id +'">'+ att.filename + att.fileext +'</a></td><td>'+ att.username +'</td></tr>';
- html += `<tr>
- <td width="25"><input type="checkbox" class="check-file" file-id=${att.id}></td>
- <td>
- <div class="d-flex">
- <a href="javascript:void(0)" class="pl-0 col-11 att-file-name" file-id=${att.id}>${att.filename}${att.fileext}</a>
- <a href="/tender/${tender.id}/ledger/download/file/${att.id}" class="col-1 pl-0 att-file-btn"><i class="fa fa-download"></i></a>
- </div>
- </td><td>${att.username}</td></tr>`
- }
- }
- $('#nodelist-table').html(html);
- $('#nodelist-table').on('click', 'tr', function() {
- $('#nodelist-table tr').removeClass('bg-light')
- $(this).addClass('bg-light')
- })
- }
- // 生成所有附件列表
- function getAllList(currPageNum = 1) {
- // 每页最多几个附件
- const pageCount = 20;
- // 附件总数
- const total = attData.length;
- // 总页数
- const pageNum = Math.ceil(total/pageCount);
- $('#totalPage').text(pageNum);
- $('#currentPage').text(total === 0 ? 0 : currPageNum);
- // 当前页附件内容
- const currPageAttData = attData.slice((currPageNum-1)*pageCount, currPageNum*pageCount);
- currPageFileData = currPageAttData;
- let html = '';
- for(const att of currPageAttData) {
- html += `<tr>
- <td width="25"><input type="checkbox" class="check-file" file-id=${att.id}></td>
- <td>
- <div class="d-flex">
- <a href="javascript:void(0)" class="pl-0 col-11 att-file-name" file-id=${att.id}>${att.filename}${att.fileext}</a>
- <a href="/tender/${tender.id}/ledger/download/file/${att.id}" class="col-1 pl-0 att-file-btn"><i class="fa fa-download"></i></a>
- </div>
- </td><td>${att.username}</td></tr>`
- }
- $('#alllist-table').html(html);
- $('#alllist-table').on('click', 'tr', function() {
- $('#alllist-table tr').removeClass('bg-light')
- $(this).addClass('bg-light')
- })
- }
- // 检查上报情况
- function checkAuditorFrom () {
- if ($('#auditors li').length === 0) {
- if(shenpi_status === shenpiConst.sp_status.gdspl) {
- toastr.error('请联系管理员添加审批人');
- } else {
- toastr.error('请先选择审批人,再上报数据');
- }
- return false;
- } else {
- $('#hide-all').show();
- return true;
- }
- }
- // texterea换行
- function auditCheck(i) {
- const opinion = $('textarea[name="opinion"]').eq(i).val().replace(/\r\n/g, '<br/>').replace(/\n/g, '<br/>').replace(/\s/g, ' ');
- $('textarea[name="opinion"]').eq(i).val(opinion);
- return true;
- }
|