123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087 |
- /**
- * Spreadjs 通用方法集
- *
- * @author Mai
- * @date 2018/02/06
- * @version
- */
- // 定义画点线的方法
- const proto = window.CanvasRenderingContext2D && CanvasRenderingContext2D.prototype;
- proto.dottedLine = function (x1, y1, x2, y2, interval = 4) {
- const isHorizontal = x1 == x2 ? false : true;
- const dotLen = 1;
- let len = isHorizontal ? x2 - x1 : y2 - y1;
- this.moveTo(x1, y1);
- let progress = 0;
- while (len > progress) {
- if (progress > len) { progress = len; }
- if (isHorizontal) {
- this.moveTo(x1 + progress, y1);
- this.lineTo(x1 + progress + dotLen, y1);
- } else {
- this.moveTo(x1, y1 + progress);
- this.lineTo(x1, y1 + progress + dotLen);
- }
- progress += interval;
- }
- };
- // 简写Spread常量
- const spreadNS = GC.Spread.Sheets;
- // 授权码
- // V10版本
- // spreadNS.LicenseKey = "559432293813965#A0y3iTOzEDOzkjMyMDN9UTNiojIklkI1pjIEJCLi4TPB9mM5AFNTd4cvZ7SaJUVy3CWKtWYXx4VVhjMpp7dYNGdx2ia9sEVlZGOTh7NRlTUwkWR9wEV4gmbjBDZ4ElR8N7cGdHVvEWVBtCOwIGW0ZmeYVWVr3mI0IyUiwCMzETN8kzNzYTM0IicfJye&Qf35VfiEzRwEkI0IyQiwiIwEjL6ByUKBCZhVmcwNlI0IiTis7W0ICZyBlIsIyNyMzM5ADI5ADNwcTMwIjI0ICdyNkIsIibj9SbvNmL4N7bjRnch56ciojIz5GRiwiI8+Y9sWY9QmZ0Jyp96uL9v6L0wap9biY9qiq95q197Wr9g+89iojIh94Wiqi";
- // V11版本
- spreadNS.LicenseKey = "yhqa.smartcost.com.cn|yhqm.smartcost.com.cn|yhuat.smartcost.com.cn|yhum.smartcost.com.cn|yhyun.smartcost.com.cn|yhm.smartcost.com.cn|ym.smartcost.com.cn|qm.smartcost.com.cn|um.smartcost.com.cn|civil.smartcost.com.cn|yun.smartcost.com.cn|cloud.smartcost.com.cn|qa.smartcost.com.cn|uat.smartcost.com.cn|zbqa.smartcost.com.cn|zbuat.smartcost.com.cn|jlqa.smartcost.com.cn|jluat.smartcost.com.cn|zb.smartcost.com.cn|jl.smartcost.com.cn|jladmin.smartcost.com.cn|jlqaadmin.smartcost.com.cn|jluatadmin.smartcost.com.cn,834986144349993#A0B5njRnch56cu4Wds86Yu46bj9Cdz36Y4JXYtNnLtFHLuNmLt36YuQ7cvNGdyFWbz9Sb9xibj9SbvNmL4N7bjRnch56cu4Ga9xibj9SbvNmL4N7bjRnch56cu8Wd9hWes86Yu46bj9Cdz36Y4JXYtNnLtVHa9xibj9SbvNmL4N7bjRnch56cuQXY5hWes86Yu46bj9Cdz36Y4JXYtNnLtFHa9xibj9SbvNmL4N7bjRnch56cuEWcolnI0IyctRkIsICuPWOrFWOkZmeicaut1S+r3iOsWa+mIWuqoaet0e+t5aOoPeuI0ISYONkIsIyM9kTO4MDN4EjN8kDNzgjI0ICZJJCL3V6csFmZ0IiczRmI1pjIs9WQisnOiQkIsISP3c6LJh4Sm3iWrx6QulkNzhVSMB7ZCBFdGdVMyw4bztiRalHMrg4SzclTGV5LqFUTQ9ETpdTbVp7KwgFcw8mRUhDWOV5QMlWcKBTMRhVQ7IHWEFHcoh5SiojITJCLyMTOwMDNxMzN0IicfJye&Qf35VfiMjY6cmI0IyQiwiIxEjL6ByUKBCZhVmcwNlI0IiTis7W0ICZyBlIsICOykzM6ADIwMzMwAjMwIjI0ICdyNkIsIibj9SbvNmL4N7bjRnch56cu8WatRWY4FWdspGLuNmLt36YuQ7cvNGdyFWbz9ibp5GZhFWcspGLuNmLt36YuQ7cvNGdyFWbz9ibp5GZhxmas86Yu46bj9Cdz36Y4JXYtNnLspGLuNmLt36YuQ7cvNGdyFWbz9iY0xibj9SbvNmL4N7bjRnch56cuQXY5xmas86Yu46bj9Cdz36Y4JXYtNnLhFHbqxibj9SbvNmL4N7bjRnch56cuQXY5Jmes86Yu46bj9Cdz36Y4JXYtNnLhFnY0xibj9SbvNmL4N7bjRnch56cuQXY5xibj9SbvNmL4N7bjRnch56cuEWcs86Yu46bj9Cdz36Y4JXYtNnLkV7bsNGLuNmLt36YuQ7cvNGdyFWbz9ib5lHLuNmLt36YuQ7cvNGdyFWbz9CbpZXajxibj9Sbvlmn0";
- // SpreadJs常用方法
- const SpreadJsObj = {
- initSpreadSettingEvents: function (setting, events) {
- const getEvent = function (eventName) {
- const names = eventName.split('.');
- let event = events;
- for (let name of names) {
- if (event[name]) {
- event = event[name];
- } else {
- return null;
- }
- }
- if (event && Object.prototype.toString.apply(event) !== "[object Function]") {
- return null;
- } else {
- return event;
- }
- };
- for (const col of setting.cols) {
- if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object String]") {
- col.readOnly = getEvent(col.readOnly);
- }
- if (col.getValue && Object.prototype.toString.apply(col.getValue) === "[object String]") {
- col.getValue = getEvent(col.getValue);
- }
- }
- },
- DataType: {
- Data: 'data',
- Tree: 'tree',
- },
- /**
- * 创建Spread(默认1张表,3行数据)
- * @param obj 用于创建spreadjs的Dom元素
- * @returns {GC.Spread.Sheets.Workbook}
- */
- createNewSpread: function (obj, hidden) {
- const spread = new spreadNS.Workbook(obj, {sheetCount: 1});
- if (hidden) return spread;
- spread.options.tabStripVisible = false;
- spread.options.scrollbarMaxAlign = true;
- spread.options.cutCopyIndicatorVisible = false;
- spread.options.allowCopyPasteExcelStyle = false;
- spread.options.allowUserDragDrop = false;
- spread.options.allowUserDragFill = false;
- spread.options.showDragFillSmartTag = false;
- spread.options.allowUserEditFormula = false;
- spread.options.allowExtendPasteRange = true;
- spread.options.allowContextMenu = false;
- spread.options.copyPasteHeaderOptions = spreadNS.CopyPasteHeaderOptions.noHeaders;
- spread.getActiveSheet().options.clipBoardOptions = spreadNS.ClipboardPasteOptions.values;//设置粘贴时只粘贴值
- spread.getActiveSheet().setRowCount(3);
- return spread;
- },
- addCutEvents: function (spread, fun) {
- spread.cutFun = fun;
- const cut = spreadNS.Commands.copy.execute;
- spreadNS.Commands.cut.execute = function (context, options, isUndo) {
- const sheet = context.getActiveSheet();
- const sels = sheet.getSelections();
- const sel = sels ? sels[0] : null;
- if (sel) {
- return context.cutFun(sheet, sel, function (isUndo) {
- cut(context, options, isUndo);
- });
- }
- }
- },
- /**
- * 保护sheet(需设置保护后, 单元格的locked等属性方可生效)
- * @param {GC.Spread.Sheets.Worksheet} sheet
- */
- protectedSheet: function (sheet) {
- const option = {
- allowSelectLockedCells: true,
- allowSelectUnlockedCells: true,
- allowResizeRows: true,
- allowResizeColumns: true
- };
- const defaultStyle = sheet.getDefaultStyle();
- defaultStyle.locked = false;
- sheet.setDefaultStyle(defaultStyle);
- sheet.options.protectionOptions = option;
- sheet.options.isProtected = true;
- sheet.options.allowCellOverflow = false;
- },
- /**
- * sheet批量操作优化(sheet操作大批量数据时, 屏蔽数据刷新, 可优化大量时间)
- * @param {GC.Spread.Sheets.Worksheet} sheet
- * @param {function} operation
- */
- beginMassOperation: function (sheet) {
- sheet.suspendPaint();
- sheet.suspendEvent();
- },
- endMassOperation: function (sheet) {
- sheet.resumeEvent();
- sheet.resumePaint();
- },
- massOperationSheet: function (sheet, operation) {
- this.beginMassOperation(sheet);
- operation();
- this.endMassOperation(sheet);
- },
- /**
- * 获取Obj左顶点位置(部分功能需通过spreadjs左顶点位置计算)
- * @param obj
- * @returns {{x: number, y: number}}
- */
- getObjPos: function (obj) {
- if (!obj) return null;
- let target = obj;
- let pos = {x: obj.offsetLeft, y: obj.offsetTop};
- target = obj.offsetParent;
- while (target) {
- pos.x += target.offsetLeft;
- pos.y += target.offsetTop;
- target = target.offsetParent;
- }
- return pos;
- },
- /**
- * 以下四个方法来自Spread示例, 参见官网或文档
- */
- getHitTest: function (obj, e, sheet) {
- var offset = obj.offset(),
- x = e.pageX - offset.left,
- y = e.pageY - offset.top;
- return sheet.hitTest(x, y);
- },
- getTargetSelection: function (sheet, target) {
- if (target.hitTestType === spreadNS.SheetArea.colHeader) {
- return sheet.getRange(-1, target.col, sheet.getRowCount(), 1);
- } else if (target.hitTestType === spreadNS.SheetArea.rowHeader) {
- return sheet.getRange(target.row, -1, 1, sheet.getColumnCount());
- } else if (target.hitTestType === spreadNS.SheetArea.viewport) {
- return sheet.getRange(target.row, target.col, 1, 1);
- } else if (target.hitTestType === spreadNS.SheetArea.corner) {
- return sheet.getRange(-1, -1, sheet.getRowCount(), sheet.getColumnCount());
- };
- },
- getCellInSelections: function (selections, row, col) {
- const count = selections.length;
- let range;
- for (var i = 0; i < count; i++) {
- range = selections[i];
- if (range.contains(row, col)) {
- return range;
- }
- }
- return null;
- },
- checkTargetInSelection: function (selections, range) {
- var count = selections.length, sel;
- for (var i = 0; i < count; i++) {
- sel = selections[i];
- if (sel.containsRange(range)) {
- return true;
- }
- }
- return false;
- },
- /**
- * 获取 spread 在鼠标右键时, spread的选中区域
- * viewport, 选中鼠标点击单元格X, X不在原选中区域内, 则选中X
- * colHeader, 选中整列
- * rowHeader, 选中整行
- * corner, 全选
- * 该方法返回不符合需求时,可通过getHitTest/getTargetSelection/getCellInSelections/checkTargetInSelection来确定鼠标右键点击时,spread当前Sheet应选中的单元格
- * @param obj: 创建Spread的Dom元素(jquery-contextmenu.build方法的第一个变量可读取)
- * @param e: jquery-contextmenu.build方法的第二个变量
- * @param {GC.Spread.Sheets.Workbook} spread
- * @returns {*}
- */
- safeRightClickSelection: function (obj, e, spread) {
- const sheet = spread.getActiveSheet();
- if (sheet.isEditing()) sheet.endEdit(true);
- const selections = sheet.getSelections(), target = this.getHitTest(obj, e, sheet), range = this.getTargetSelection(sheet, target);
- if (!this.checkTargetInSelection(selections, range)) {
- sheet.setSelection(range.row, range.col, range.rowCount, range.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [selections[0].row, range.row]);
- }
- return target;
- },
- /**
- * 禁用右键菜单
- * @param selector
- * @param spread
- */
- forbiddenSpreadContextMenu: function (selector, spread) {
- $.contextMenu({
- selector: selector,
- build: function ($trigger, e) {
- const target = SpreadJsObj.safeRightClickSelection($trigger, e, spread);
- return target.hitTestType === spreadNS.SheetArea.viewport || target.hitTestType === spreadNS.SheetArea.rowHeader;
- }
- });
- },
- selChangedRefreshBackColor: function (sheet) {
- sheet.bind(spreadNS.Events.SelectionChanged, function (e, info) {
- const rows = [];
- if (info.oldSelections && info.oldSelections[0]) rows.push(info.oldSelections[0].row);
- if (info.newSelections && info.newSelections[0]) rows.push(info.newSelections[0].row);
- if (rows.length > 0) SpreadJsObj.reloadRowsBackColor(info.sheet, rows);
- });
- },
- /**
- * 获取写入sheet的数据序列
- * data:sheet.zh_data, tree: sheet.zh_tree.nodes
- * @param sheet
- * @returns {*}
- */
- getSortData: function (sheet) {
- if (sheet.zh_dataType) {
- if (sheet.zh_dataType === this.DataType.Data) {
- return sheet.zh_data;
- } else if (sheet.zh_dataType === this.DataType.Tree) {
- return sheet.zh_tree.nodes;
- } else {
- return null;
- }
- } else {
- return null;
- }
- },
- /**
- * sheet中 使用delete键,触发EndEdited事件
- * @param {GC.Spreads.Sheets.Workbook} spread
- * @param {function} fun
- */
- addDeleteBind: function (spread, fun) {
- spread.commandManager().register('deleteEvent', function () {
- fun(spread.getActiveSheet());
- });
- spread.commandManager().setShortcutKey(null, GC.Spread.Commands.Key.del, false, false, false, false);
- spread.commandManager().setShortcutKey('deleteEvent', GC.Spread.Commands.Key.del, false, false, false, false);
- },
- _initSheetDeafult: function (sheet) {
- if (sheet.zh_setting.headerFont) {
- const vStyle = new spreadNS.Style();
- vStyle.font = sheet.zh_setting.headerFont;
- vStyle.locked = false;
- sheet.setDefaultStyle(vStyle, spreadNS.SheetArea.colHeader);
- }
- if (sheet.zh_setting.font) {
- const vStyle = new spreadNS.Style();
- vStyle.font = sheet.zh_setting.font;
- vStyle.hAlign = 1;
- vStyle.locked = false;
- sheet.setDefaultStyle(vStyle, spreadNS.SheetArea.rowHeader);
- }
- if (sheet.zh_setting.font) {
- const vStyle = new spreadNS.Style();
- vStyle.font = sheet.zh_setting.font;
- vStyle.locked = false;
- sheet.setDefaultStyle(vStyle, spreadNS.SheetArea.viewport);
- }
- },
- /**
- * 根据sheet.zh_setting初始化sheet表头
- * @param {GC.Spread.Sheets.Worksheet} sheet
- */
- _initSheetHeader: function (sheet) {
- const setting = sheet.zh_setting;
- if (!setting || !setting.cols) { return; }
- sheet.setColumnCount(setting.cols.length);
- sheet.setRowCount(setting.headRows, spreadNS.SheetArea.colHeader);
- for (let iRow = 0; iRow < setting.headRowHeight.length; iRow ++) {
- sheet.setRowHeight(iRow, setting.headRowHeight[iRow], spreadNS.SheetArea.colHeader);
- }
- for (let iCol = 0; iCol < setting.cols.length; iCol++) {
- const col = setting.cols[iCol];
- const title = col.title.split('|');
- const colSpan = col.colSpan ? col.colSpan.split('|'): ['1'], rowSpan = col.rowSpan ? col.rowSpan.split('|'): ['1'];
- for (let i = 0; i < title.length; i++) {
- const cell = sheet.getCell(i, iCol, spreadNS.SheetArea.colHeader);
- cell.text(title[i]).wordWrap(true);
- if ((colSpan[i] !== '' && colSpan[i] !== '1') || (rowSpan[i] !== '' && rowSpan[i] !== '1')) {
- sheet.addSpan(i, iCol, parseInt(rowSpan[i]), parseInt(colSpan[i]), spreadNS.SheetArea.colHeader);
- }
- }
- sheet.setColumnWidth(iCol, col.width);
- if (col.visible !== undefined && col.visible !== null) {
- sheet.setColumnVisible(iCol, col.visible);
- }
- }
- sheet.rowOutlines.direction(spreadNS.Outlines.OutlineDirection.backward);
- sheet.showRowOutline(false);
- if (setting.defaultRowHeight) {
- sheet.defaults.rowHeight = setting.defaultRowHeight;
- }
- if (setting.frozenLineColor) sheet.options.frozenlineColor = setting.frozenLineColor;
- if (setting.frozenColCount) sheet.frozenColumnCount(setting.frozenColCount);
- },
- reinitSheetHeader: function (sheet) {
- this.beginMassOperation(sheet);
- if (sheet.zh_setting.headColWidth) {
- for (const [i, w] of sheet.zh_setting.headColWidth.entries()) {
- sheet.setColumnWidth(i, w, spreadNS.SheetArea.rowHeader);
- }
- }
- this._initSheetHeader(sheet);
- this.endMassOperation(sheet);
- },
- _rememberColWidth: function (sheet) {
- sheet.bind(spreadNS.Events.ColumnWidthChanged, function (e, info) {
- if (!info.sheet.zh_setting) return;
- const setting = info.sheet.zh_setting;
- if (!setting.localCache || !setting.localCache.key) return;
- if (!setting.localCache.colWidthCache) return;
- const cache = setting.localCache.colWidthCache;
- for (const col of info.colList) {
- const colSetting = setting.cols[col];
- if (colSetting && colSetting.field)
- cache[colSetting.field] = info.sheet.getColumnWidth(col);
- }
- setLocalCache(setting.localCache.key + '-colWidth', JSON.stringify(cache));
- });
- },
- _loadCacheSetting: function (sheet, setting) {
- if (!setting.localCache || !setting.localCache.key) return;
- if (setting.localCache.colWidth) {
- const cache = getLocalCache(setting.localCache.key + '-colWidth');
- setting.localCache.colWidthCache = cache ? JSON.parse(cache) : {};
- for (const prop in setting.localCache.colWidthCache) {
- const col = _.find(setting.cols, {field: prop});
- if (col) col.width = setting.localCache.colWidthCache[prop];
- }
- }
- },
- /**
- * 初始化sheet, 设置sheet.zh_setting, 并初始化表头
- * @param {GC.Spread.Sheets.Worksheet} sheet
- * @param setting
- */
- initSheet: function (sheet, setting) {
- const self = this;
- this.beginMassOperation(sheet);
- this._loadCacheSetting(sheet, setting);
- this._rememberColWidth(sheet);
- setting.pos = sheet.getParent().pos;
- if (!setting.tree) setting.tree = {};
- sheet.zh_setting = setting;
- if (sheet.zh_setting.headColWidth) {
- for (const [i, w] of sheet.zh_setting.headColWidth.entries()) {
- sheet.setColumnWidth(i, w, spreadNS.SheetArea.rowHeader);
- }
- }
- this._initSheetDeafult(sheet);
- this._initSheetHeader(sheet);
- sheet.setRowCount(sheet.zh_setting.emptyRows);
- sheet.extendCellType = {};
- sheet.extendRowHeader = {};
- sheet.zh_setting.rowHeader && sheet.zh_setting.rowHeader.forEach(function (col, j) {
- self._defineRowHeader(sheet, j, col);
- });
- sheet.borderLine = new spreadNS.LineBorder('#cccccc', spreadNS.LineStyle.thin);
- sheet.getRange(0, 0, sheet.getRowCount(), sheet.getColumnCount()).locked(setting.readOnly).setBorder(sheet.borderLine, {all: true});
- if (setting.selectedBackColor) {
- SpreadJsObj.selChangedRefreshBackColor(sheet);
- }
- this.endMassOperation(sheet);
- if (!setting.invalidCopyFilterHiddenRow) this.copyFilterHiddenRow(sheet);
- },
- reLoadSheetHeader: function (sheet) {
- if (sheet.zh_setting) {
- this.beginMassOperation(sheet);
- this._loadCacheSetting(sheet, sheet.zh_setting);
- this._initSheetHeader(sheet);
- this.endMassOperation(sheet);
- }
- },
- _loadCellData: function (sheet, data, iRow, iCol) {
- if (!data || !sheet.zh_setting) return;
- const col = sheet.zh_setting.cols[iCol];
- const cell = sheet.getCell(iRow, iCol);
- if (col.getValue && Object.prototype.toString.apply(col.getValue) === "[object Function]") {
- cell.value(col.getValue(data));
- } else if (col.field !== '' && data[col.field]) {
- cell.value(data[col.field]);
- }
- let font = sheet.getDefaultStyle().font;
- if (col.font) {
- font = col.font;
- }
- if (sheet.zh_setting.tree.getFont && Object.prototype.toString.apply(sheet.zh_setting.tree.getFont) === "[object Function]") {
- font = sheet.zh_setting.tree.getFont(sheet, data, iRow, col, font);
- }
- cell.font(font);
- if (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object Function]") {
- cell.locked(col.readOnly(data) || sheet.zh_setting.readOnly || false).vAlign(1).hAlign(col.hAlign);
- } else {
- cell.locked(col.readOnly || sheet.zh_setting.readOnly || false).vAlign(1).hAlign(col.hAlign);
- }
- if(col.type === 'Number') {
- if (col.formatter) {
- cell.formatter(SpreadJsObj.Formatter.getNumberFormatter(col.formatter))
- } else {
- cell.formatter(SpreadJsObj.Formatter.getNumberFormatter('0.######'));
- }
- } else if (col.formatter) {
- cell.formatter(col.formatter);
- }
- cell.backColor(SpreadJsObj._getBackColor(sheet, data, iRow, col));
- cell.foreColor(SpreadJsObj._getForeColor(sheet, data, iRow, col));
- cell.setBorder(sheet.borderLine, {all: true});
- },
- _getForeColor: function (sheet, data, row, col) {
- let foreColor = sheet.getDefaultStyle().foreColor;
- if (sheet.zh_setting.tree.getForeColor && Object.prototype.toString.apply(sheet.zh_setting.tree.getForeColor) === "[object Function]") {
- foreColor = sheet.zh_setting.tree.getColor(sheet, data, row, col, foreColor);
- }
- if (sheet.zh_setting.getForeColor && Object.prototype.toString.apply(sheet.zh_setting.getForeColor) === "[object Function]") {
- foreColor = sheet.zh_setting.getForeColor(sheet, data, row, col, foreColor);
- }
- return foreColor;
- },
- _getBackColor: function (sheet, data, row, col) {
- let backColor = sheet.getDefaultStyle().backColor;
- let sels = sheet.getSelections();
- if (sheet.zh_setting.selectedBackColor && sels && sels[0].row === row ) {
- return sheet.zh_setting.selectedBackColor;
- } else {
- if (sheet.zh_setting.tree.getColor && Object.prototype.toString.apply(sheet.zh_setting.tree.getColor) === "[object Function]") {
- backColor = sheet.zh_setting.tree.getColor(sheet, data, row, col, backColor);
- }
- if (sheet.zh_setting.getColor && Object.prototype.toString.apply(sheet.zh_setting.getColor) === "[object Function]") {
- backColor = sheet.zh_setting.getColor(sheet, data, row, col, backColor);
- }
- return backColor;
- }
- },
- _loadRowStyle: function (sheet, data, row) {
- sheet.zh_setting.cols.forEach(function (col, j) {
- const cell = sheet.getCell(row, j);
- if (col.font) {
- cell.font(col.font);
- }
- const readOnly1 = (sheet.zh_setting.readOnly && Object.prototype.toString.apply(sheet.zh_setting.readOnly) === "[object Function]")
- ? sheet.zh_setting.readOnly(data) : (sheet.zh_setting.readOnly || false);
- const readOnly2 = (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object Function]")
- ? col.readOnly(data) : col.readOnly || false;
- cell.locked(readOnly1 || readOnly2).vAlign(1).hAlign(col.hAlign);
- if(col.type === 'Number') {
- if (col.formatter) {
- cell.formatter(SpreadJsObj.Formatter.getNumberFormatter(col.formatter))
- } else {
- cell.formatter(SpreadJsObj.Formatter.getNumberFormatter('0.######'));
- }
- } else if (col.formatter) {
- cell.formatter(col.formatter);
- }
- cell.setBorder(sheet.borderLine, {all: true});
- });
- },
- _loadRowData: function (sheet, data, row) {
- // 单元格重新写入数据
- if (!data) { return }
- if (sheet.zh_dataType === SpreadJsObj.DataType.Tree && !data.visible && data.waitingLoading === undefined) {
- data.waitingLoading = true;
- return;
- }
- sheet.zh_setting.cols.forEach(function (col, j) {
- const cell = sheet.getCell(row, j);
- if (col.getValue && Object.prototype.toString.apply(col.getValue) === "[object Function]") {
- cell.value(col.getValue(data));
- } else if (col.field !== '' && data[col.field]) {
- cell.value(data[col.field]);
- }
- let font = sheet.getDefaultStyle().font;
- if (col.font) {
- font = col.font;
- }
- if (sheet.zh_setting.tree.getFont && Object.prototype.toString.apply(sheet.zh_setting.tree.getFont) === "[object Function]") {
- font = sheet.zh_setting.tree.getFont(sheet, data, row, col, font);
- }
- cell.font(font);
- if (col.foreColor) {
- if (Object.prototype.toString.apply(col.foreColor) === "[object Function]") {
- cell.foreColor(col.foreColor(data, sheet.getDefaultStyle().foreColor));
- } else {
- cell.foreColor(col.foreColor);
- }
- }
- const readOnly1 = (sheet.zh_setting.readOnly && Object.prototype.toString.apply(sheet.zh_setting.readOnly) === "[object Function]")
- ? sheet.zh_setting.readOnly(data) : (sheet.zh_setting.readOnly || false);
- const readOnly2 = (col.readOnly && Object.prototype.toString.apply(col.readOnly) === "[object Function]")
- ? col.readOnly(data) : col.readOnly || false;
- cell.locked(readOnly1 || readOnly2).vAlign(1).hAlign(col.hAlign);
- if(col.type === 'Number') {
- if (col.formatter) {
- cell.formatter(SpreadJsObj.Formatter.getNumberFormatter(col.formatter))
- } else {
- cell.formatter(SpreadJsObj.Formatter.getNumberFormatter('0.######'));
- }
- } else if (col.formatter) {
- cell.formatter(col.formatter);
- }
- cell.backColor(SpreadJsObj._getBackColor(sheet, data, row, col));
- cell.foreColor(SpreadJsObj._getForeColor(sheet, data, row, col));
- cell.setBorder(sheet.borderLine, {all: true});
- data.waitingLoading = false;
- });
- },
- _addActivePaintEvents: function (sheet, cellType) {
- if (!sheet.ActiveType) {
- sheet.ActiveType = [];
- }
- sheet.ActiveType.push(cellType);
- if (!sheet.AcitveRefresh) {
- sheet.bind(spreadNS.Events.LeaveCell, function (e, info) {
- const cellType = info.sheet.getCell(info.row, info.col).cellType();
- if (sheet.ActiveType.indexOf(cellType) >= 0) {
- info.sheet.leaveCell = {row: info.row, col: info.col};
- } else {
- delete info.sheet.leaveCell;
- }
- });
- sheet.bind(spreadNS.Events.EnterCell, function (e, info) {
- const cellType = info.sheet.getCell(info.row, info.col).cellType();
- if (sheet.ActiveType.indexOf(cellType) >= 0) {
- info.sheet.repaint(info.sheet.getCellRect(info.row, info.col));
- }
- if (info.sheet.leaveCell) {
- info.sheet.repaint(info.sheet.getCellRect(info.sheet.leaveCell.row, info.sheet.leaveCell.col));
- }
- });
- sheet.AcitveRefresh = true;
- }
- },
- _defineRowHeader: function (sheet, col, colSetting) {
- if (colSetting.rowHeaderType === 'tag') {
- if (!sheet.extendRowHeader.tag) {
- sheet.extendRowHeader.tag = this.RowHeader.getTagRowHeader(colSetting.setting);
- }
- sheet.getRange(-1, col, -1, 1, spreadNS.SheetArea.rowHeader).cellType(sheet.extendRowHeader.tag);
- }
- if (colSetting.rowHeaderType === 'circle') {
- if (!sheet.extendRowHeader.multiTag) {
- sheet.extendRowHeader.multiTag = this.RowHeader.getCircleTagRowHeader(colSetting.setting);
- }
- sheet.getRange(-1, col, -1, 1, spreadNS.SheetArea.rowHeader).cellType(sheet.extendRowHeader.multiTag);
- }
- },
- _defineColCellType: function (sheet, col, colSetting) {
- sheet.AcitveComboRefresh = false;
- if(colSetting.cellType === 'ellipsis') {
- if (!sheet.extendCellType.ellipsis) {
- sheet.extendCellType.ellipsis = this.CellType.getEllipsisTextCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.ellipsis);
- }
- if(colSetting.cellType === 'ellipsisAutoTip') {
- if (!sheet.extendCellType.ellipsisAutoTip) {
- sheet.extendCellType.ellipsisAutoTip = this.CellType.getEllipsisTextAutoTipCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.ellipsisAutoTip);
- }
- if(colSetting.cellType === 'html') {
- if (!sheet.extendCellType.html) {
- sheet.extendCellType.html = this.CellType.getHtmlCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.html);
- }
- if (colSetting.cellType === 'image') {
- if (!sheet.extendCellType.image) {
- sheet.extendCellType.image = this.CellType.getImageCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.image);
- }
- if (colSetting.cellType === 'imageBtn') {
- if (!sheet.extendCellType.imageBtn) {
- sheet.extendCellType.imageBtn = this.CellType.getImageButtonCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.imageBtn);
- }
- if (colSetting.cellType === 'activeImageBtn') {
- if (!sheet.extendCellType.activeImageBtn) {
- sheet.extendCellType.activeImageBtn = this.CellType.getActiveImageButtonCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.activeImageBtn);
- }
- if (colSetting.cellType === 'tree') {
- if (!sheet.extendCellType.tree) {
- sheet.extendCellType.tree = this.CellType.getTreeNodeCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.tree);
- }
- if (colSetting.cellType === 'tip') {
- if (!sheet.extendCellType.tip) {
- sheet.extendCellType.tip = this.CellType.getTipCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.tip);
- }
- if (colSetting.cellType === 'autoTip') {
- if (!sheet.extendCellType.autoTip) {
- sheet.extendCellType.autoTip = this.CellType.getAutoTipCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.autoTip);
- }
- if (colSetting.cellType === 'delayTip') {
- if (!sheet.extendCellType.tip) {
- sheet.extendCellType.tip = this.CellType.getDelayTipCellType();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.tip);
- }
- if (colSetting.cellType === 'checkbox') {
- if (!sheet.extendCellType.checkbox) {
- sheet.extendCellType.checkbox = new spreadNS.CellTypes.CheckBox();
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.checkbox);
- sheet.getRange(-1, col, -1, 1).hAlign(col ? col.hAlign : spreadNS.HorizontalAlign.center);// 空白行不居中问题,checkbox要默认居中
- }
- if (colSetting.cellType === 'unit') {
- if (!sheet.extendCellType.unit) {
- const comboEdit = colSetting.comboEdit ? colSetting.comboEdit : false;
- sheet.extendCellType.unit = colSetting.comboItems ? this.CellType.getUnitCellType(comboEdit, colSetting.comboItems) : this.CellType.getUnitCellType(comboEdit);
- SpreadJsObj._addActivePaintEvents(sheet, sheet.extendCellType.unit);
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.unit);
- }
- if (colSetting.cellType === 'customizeCombo') {
- const cellKey = colSetting.cellTypeKey ? 'customizeCombo-' + colSetting.cellTypeKey : 'customizeCombo';
- if (!sheet.extendCellType[cellKey]) {
- sheet.extendCellType[cellKey] = this.CellType.getCustomizeComboCellType(colSetting.comboItems);
- SpreadJsObj._addActivePaintEvents(sheet, sheet.extendCellType[cellKey]);
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType[cellKey]);
- }
- if (colSetting.cellType === 'stageCombo') {
- if (!sheet.extendCellType.stageCombo) {
- sheet.extendCellType.stageCombo = this.CellType.getStageComboCellType();
- SpreadJsObj._addActivePaintEvents(sheet, sheet.extendCellType.stageCombo);
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.stageCombo);
- }
- if (colSetting.cellType === 'specCombo') {
- if (!sheet.extendCellType.specCombo) {
- sheet.extendCellType.specCombo = this.CellType.getSpecComboCellType(colSetting.comboItems);
- SpreadJsObj._addActivePaintEvents(sheet, sheet.extendCellType.specCombo);
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.specCombo);
- }
- if (colSetting.cellType === 'datepicker') {
- if (!sheet.extendCellType.datepicker) {
- sheet.extendCellType.datepicker = this.CellType.getDatePickerCellType();
- SpreadJsObj._addActivePaintEvents(sheet, sheet.extendCellType.datepicker);
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.datepicker);
- }
- if (colSetting.cellType === 'mouseTouch') {
- if (!sheet.extendCellType.mouseTouch) {
- sheet.extendCellType.mouseTouch = this.CellType.getMouseTouchCellType();
- SpreadJsObj._addActivePaintEvents(sheet, sheet.extendCellType.mouseTouch);
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.mouseTouch);
- }
- if (colSetting.cellType === 'stackedBar') {
- if (!sheet.extendCellType.stackedBar) {
- sheet.extendCellType.stackedBar = this.CellType.getStackedBarCellType();
- SpreadJsObj._addActivePaintEvents(sheet, sheet.extendCellType.stackedBar);
- }
- sheet.getRange(-1, col, -1, 1).cellType(sheet.extendCellType.stackedBar);
- }
- if (colSetting.formatter) {
- sheet.getRange(-1, col, -1, 1).formatter(colSetting.formatter);
- if(colSetting.type === 'Number') {
- if (col.formatter) {
- sheet.getRange(-1, col, -1, 1).formatter(SpreadJsObj.Formatter.getNumberFormatter(colSetting.formatter));
- } else {
- sheet.getRange(-1, col, -1, 1).formatter(SpreadJsObj.Formatter.getNumberFormatter('0.######'));
- }
- } else if (col.formatter) {
- cell.formatter(col.formatter);
- }
- }
- },
- /**
- * 整个sheet重新加载数据
- * @param {GC.Spread.Sheets.Worksheet} sheet
- */
- reLoadSheetData: function (sheet, force = false) {
- const self = this;
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- this.beginMassOperation(sheet);
- try {
- force && sheet.setRowCount(0, spreadNS.SheetArea.viewport);
- sheet.clear(0, 0, sheet.getRowCount(), sheet.getColumnCount(), spreadNS.SheetArea.viewport, spreadNS.StorageType.data);
- sheet.getRange(0, 0, sheet.getRowCount(), sheet.getColumnCount()).backColor(sheet.getDefaultStyle().backColor);
- // 设置总行数
- const totalRow = sortData.length + sheet.zh_setting.emptyRows;
- sheet.setRowCount(totalRow, spreadNS.SheetArea.viewport);
- // 控制空白行
- const emptyRows = sheet.getRange(sortData.length, -1, sheet.zh_setting.emptyRows, -1);
- emptyRows.locked(sheet.zh_dataType === 'tree' || sheet.zh_setting.readOnly);
- if (sortData) {
- // 单元格写入数据
- sortData.forEach(function (data, i) {
- self._loadRowData(sheet, data, i);
- sheet.setRowVisible(i, data.visible);
- });
- // for (let iRow = sortData.length - 1; iRow < totalRow; iRow++) {
- // self._loadRowStyle(sheet, iRow);
- // }
- }
- // 设置列单元格格式
- sheet.zh_setting.cols.forEach(function (col, j) {
- //if (!col.cellType) { return; }
- self._defineColCellType(sheet, j, col);
- });
- this.endMassOperation(sheet);
- } catch (err) {
- console.log(err);
- this.endMassOperation(sheet);
- }
- },
- /**
- * 重新加载部分数据行
- * @param {GC.Spread.Sheets.Worksheet} sheet
- * @param {Number} row
- * @param {Number} count
- */
- reLoadRowData: function (sheet, row, count = 1) {
- if (row < 0) { return; }
- const self = this;
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- this.beginMassOperation(sheet);
- try {
- // 清空原单元格数据
- sheet.clear(row, -1, count, -1, spreadNS.SheetArea.viewport, spreadNS.StorageType.data);
- sheet.getRange(row, -1, count, -1).backColor(sheet.getDefaultStyle().backColor);
- // 单元格重新写入数据
- for (let i = row; i < row + count; i++) {
- const data = sortData[i];
- if (!data) { continue; }
- this._loadRowData(sheet, data, i);
- sheet.setRowVisible(i, data.visible);
- }
- this.endMassOperation(sheet);
- } catch (err) {
- this.endMassOperation(sheet);
- }
- },
- /**
- * 重新加载部分行数据
- * @param {GC.Spread.Sheets.Worksheet} sheet
- * @param {Array} rows
- */
- reLoadRowsData: function (sheet, rows) {
- const self = this;
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- this.beginMassOperation(sheet);
- try {
- for (const row of rows) {
- if (row < 0) { continue; }
- // 清空原单元格数据
- sheet.clear(row, -1, 1, -1, spreadNS.SheetArea.viewport, spreadNS.StorageType.data);
- sheet.getRange(row, -1, 1, -1).backColor(sheet.getDefaultStyle().backColor);
- const data = sortData[row];
- // 单元格重新写入数据
- this._loadRowData(sheet, data, row);
- sheet.setRowVisible(row, data.visible);
- };
- this.endMassOperation(sheet);
- } catch (err) {
- this.endMassOperation(sheet);
- }
- },
- reloadRowForeColor: function (sheet, row, count) {
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- this.beginMassOperation(sheet);
- try {
- for (let i = row; i < row + count; i++) {
- if (i < 0) { continue; }
- const data = sortData[i];
- for (const [iCol, col] of sheet.zh_setting.cols.entries()) {
- sheet.getCell(i, iCol).foreColor(SpreadJsObj._getForeColor(sheet, data, i, col));
- }
- };
- this.endMassOperation(sheet);
- } catch (err) {
- this.endMassOperation(sheet);
- }
- },
- reloadRowsForeColor: function (sheet, rows) {
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- this.beginMassOperation(sheet);
- try {
- for (const row of rows) {
- if (row < 0) { continue; }
- const data = sortData[row];
- for (const [iCol, col] of sheet.zh_setting.cols.entries()) {
- sheet.getCell(row, iCol).foreColor(SpreadJsObj._getForeColor(sheet, data, row, col));
- }
- };
- this.endMassOperation(sheet);
- } catch (err) {
- this.endMassOperation(sheet);
- }
- },
- reloadRowBackColor: function (sheet, row, count = 1) {
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- this.beginMassOperation(sheet);
- try {
- for (let i = row; i < row + count; i++) {
- if (i < 0) { continue; }
- const data = sortData[i];
- for (const [iCol, col] of sheet.zh_setting.cols.entries()) {
- sheet.getCell(i, iCol).backColor(SpreadJsObj._getBackColor(sheet, data, i, col));
- }
- };
- this.endMassOperation(sheet);
- } catch (err) {
- this.endMassOperation(sheet);
- }
- },
- reloadRowsBackColor: function (sheet, rows) {
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- this.beginMassOperation(sheet);
- try {
- for (const row of rows) {
- if (row < 0) { continue; }
- const data = sortData[row];
- for (const [iCol, col] of sheet.zh_setting.cols.entries()) {
- sheet.getCell(row, iCol).backColor(SpreadJsObj._getBackColor(sheet, data, row, col));
- }
- };
- this.endMassOperation(sheet);
- } catch (err) {
- this.endMassOperation(sheet);
- }
- },
- reloadRowsReadonly: function (sheet, rows) {
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- this.beginMassOperation(sheet);
- try {
- for (const row of rows) {
- if (row < 0) { continue; }
- this._loadRowStyle(sheet, sortData[row], row);
- };
- } catch (err) {
- }
- this.endMassOperation(sheet);
- },
- reloadColData: function (sheet, col, count = 1) {
- const cols = [];
- for (let i = 0; i < count; i++) {
- cols.push(col+i);
- }
- this.reLoadColsData(sheet, cols);
- },
- /**
- * 重新加载部分列数据
- * @param {GC.Spread.Sheets.Worksheet} sheet
- * @param {Array} cols
- */
- reLoadColsData: function (sheet, cols) {
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- if (!sortData) return;
- this.beginMassOperation(sheet);
- try {
- for (const col of cols) {
- // 清空原单元格数据
- sheet.clear(-1, col, -1, 1, spreadNS.SheetArea.viewport, spreadNS.StorageType.data);
- for (const [iRow, data] of sortData.entries()) {
- this._loadCellData(sheet, data, iRow, col);
- }
- }
- this.endMassOperation(sheet);
- } catch (err) {
- console.log(err);
- this.endMassOperation(sheet);
- }
- },
- reLoadNodesData: function (sheet, nodes) {
- this.beginMassOperation(sheet);
- nodes = nodes instanceof Array ? nodes : [nodes];
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- for (const node of nodes) {
- this._loadRowData(sheet, node, sortData.indexOf(node));
- }
- this.endMassOperation(sheet);
- },
- repaintNodesRowHeader: function (sheet, nodes) {
- nodes = nodes instanceof Array ? nodes : [nodes];
- const sortData = sheet.zh_dataType === 'tree' ? sheet.zh_tree.nodes : sheet.zh_data;
- const rowIndex = [];
- for (const node of nodes) {
- rowIndex.push(sortData.indexOf(node));
- }
- this.repaintRowsRowHeader(sheet, rowIndex);
- },
- repaintRowsRowHeader: function (sheet, rows) {
- for (const r of rows) {
- const cellRect = sheet.getCellRect(r, 0);
- cellRect.width = cellRect.x;
- cellRect.x = 0;
- sheet.repaint(cellRect);
- }
- },
- /**
- * 根据data加载sheet数据,合并了一般数据和树结构数据的加载
- * @param {GC.Spread.Sheets.Worksheet} sheet
- * @param {String} dataType - 1.'zh_data' 2.'zh_tree'
- * @param {Array|PathTree} data - 对dataType对应
- */
- loadSheetData: function (sheet, dataType, data, force = false){
- sheet.zh_dataType = dataType;
- if (dataType === 'tree') {
- sheet.zh_tree = data;
- } else {
- sheet.zh_data = data;
- }
- this.protectedSheet(sheet);
- this.reLoadSheetData(sheet, force);
- },
- /**
- * 获取复制数据HTML格式(过滤不可见单元格)
- * @param {GC.Spread.Sheets.Worksheet} sheet
- * @returns {string}
- */
- getFilterCopyHTML: function (sheet) {
- const sel = sheet.getSelections()[0];
- const html = [];
- html.push('<table>');
- for (let i = sel.row, iLen = sel.row + sel.rowCount; i < iLen; i++) {
- // 跳过隐藏行
- if (!sheet.getCell(i, -1).visible()) { continue; }
- const rowHtml = [];
- rowHtml.push('<tr>');
- for (let j = sel.col, jLen = sel.col + sel.colCount; j < jLen; j++) {
- const data = sheet.getText(i, j);
- rowHtml.push('<td>' + data + '</td>');
- }
- rowHtml.push('</tr>');
- html.push(rowHtml.join(''));
- }
- html.push('</table>');
- return html.join('');
- },
- /**
- * 获取复制数据Text格式(过滤不可见单元格)
- * @param {GC.Spread.Sheets.Worksheet} sheet
- * @returns {string}
- */
- getFilterCopyText: function (sheet) {
- const copyData = [];
- const sel = sheet.getSelections()[0];
- for(let i = sel.row, iLen = sel.row + sel.rowCount; i < iLen; i++) {
- // 跳过隐藏行
- if (!sheet.getCell(i, -1).visible()) { continue; }
- const rowText = [];
- for (let j = sel.col, jLen = sel.col + sel.colCount; j < jLen; j++) {
- const data = sheet.getText(i, j);
- rowText.push(data);
- }
- copyData.push(rowText.join('\t'));
- }
- return copyData.join('\r\n');
- },
- analysisPasteText: function (text, transpose = false) {
- const result = [];
- if (text === '') return result;
- const rows = text.split('\r\n');
- if (rows[rows.length - 1] === '') rows.splice(rows.length - 1, 1);
- for (const r of rows) {
- const cols = r.split('\t');
- result.push(cols);
- }
- return transpose ? SpreadJsObj.transposePasteData(result) : result;
- },
- analysisPasteHtml: function (html) {
- const result = [];
- if (!html || html === '') return result;
- },
- transposePasteData: function (data) {
- const result = [];
- const rowCount = data.length, colCount = data.reduce((r, x) => { return Math.max(r, x.length); }, 0);
- for (let c = 0; c < colCount; c++) {
- const newRow = [];
- for (let r = 0; r < rowCount; r++) {
- newRow.push(data[r][c]);
- }
- result.push(newRow)
- }
- return result;
- },
- copyFilterHiddenRow: function (sheet) {
- sheet.bind(spreadNS.Events.ClipboardChanged, function (e, info) {
- SpreadJsObj.Clipboard.setSysClipboard(SpreadJsObj.getFilterCopyText(info.sheet));
- });
- },
- /**
- * 树表结构,定位至指定的节点
- * @param {GC.Spread.Sheets.Worksheet} sheet - 需要定位的sheet
- * @param {Number} id - 定位节点的id
- */
- locateTreeNode: function (sheet, id, autoExpand = false) {
- const tree = sheet.zh_tree;
- if (!tree) { return }
- const node = tree.getItems(id);
- if (!node) { return }
- if (autoExpand && !node.visible) {
- const parents = tree.autoExpandNode(node);
- if (parents && parents.length > 0) {
- SpreadJsObj.reLoadNodesData(sheet, parents);
- SpreadJsObj.refreshTreeRowVisible(sheet);
- }
- }
- const index = tree.nodes.indexOf(node);
- const sels = sheet.getSelections();
- sheet.setSelection(index, sels[0].col, 1, 1);
- SpreadJsObj.reloadRowsBackColor(sheet, [index, sels[0].row]);
- sheet.getParent().focus();
- sheet.showRow(index, spreadNS.VerticalPosition.center);
- },
- locateData: function (sheet, data) {
- if (!sheet.zh_data) { return }
- const index = sheet.zh_data.indexOf(data);
- if (index < 0) return;
- const sels = sheet.getSelections();
- sheet.setSelection(index, sels[0].col, 1, 1);
- SpreadJsObj.reloadRowsBackColor(sheet, [index, sels[0].row]);
- sheet.getParent().focus();
- sheet.showRow(index, spreadNS.VerticalPosition.center);
- },
- locateRow: function (sheet, row) {
- const sels = sheet.getSelections();
- sheet.setSelection(row, sels[0].col, 1, 1);
- SpreadJsObj.reloadRowsBackColor(sheet, [row, sels[0].row]);
- sheet.getParent().focus();
- sheet.showRow(row, spreadNS.VerticalPosition.center);
- },
- saveTopAndSelect: function (sheet, cacheKey) {
- const sel = sheet.getSelections()[0];
- const top = sheet.getViewportTopRow(1);
- setLocalCache(cacheKey, JSON.stringify({top: top, sel: sel}));
- },
- loadTopAndSelect: function (sheet, cacheKey) {
- let ts = getLocalCache(cacheKey);
- if (ts !== '') {
- ts = JSON.parse(ts);
- if (ts === undefined || ts === null) return;
- if (ts.sel) {
- sheet.setSelection(ts.sel.row, ts.sel.col, ts.sel.rowCount, ts.sel.colCount);
- SpreadJsObj.reloadRowsBackColor(sheet, [0, ts.sel.row]);
- }
- if (ts.top) {
- sheet.showRow(ts.top, spreadNS.VerticalPosition.top);
- }
- }
- },
- resetTopAndSelect: function (sheet) {
- sheet.setSelection(0, 0, 1, 1);
- sheet.showRow(0, spreadNS.VerticalPosition.top);
- },
- /**
- * 获取当前选行的数据对象
- * @param {GC.Spread.Sheets.Worksheet} sheet
- * @returns {Object}
- */
- getSelectObject: function (sheet) {
- if (!sheet) {
- return null;
- } else if (sheet.zh_dataType) {
- const sel = sheet.getSelections()[0];
- if (!sel) {
- return null;
- }
- if (sheet.zh_dataType === this.DataType.Tree) {
- return sheet.zh_tree.nodes[sel.row];
- } else if (sheet.zh_dataType === this.DataType.Data) {
- return sheet.zh_data[sel.row];
- } else {
- return null;
- }
- }
- },
- getRowObject: function (sheet, row) {
- if (!sheet) {
- return null;
- } else if (sheet.zh_dataType) {
- if (sheet.zh_dataType === this.DataType.Tree) {
- return sheet.zh_tree.nodes[row];
- } else if (sheet.zh_dataType === this.DataType.Data) {
- return sheet.zh_data[row];
- } else {
- return null;
- }
- }
- },
- /**
- * 刷新列显示
- * @param sheet
- */
- refreshColumnVisible: function (sheet) {
- if(sheet.zh_setting) {
- sheet.zh_setting.cols.forEach(function (col, index) {
- if (col.visible !== undefined && col.visible !== null) {
- sheet.setColumnVisible(index, col.visible);
- }
- });
- }
- },
- /**
- * 刷新行显示
- * @param sheet
- */
- refreshTreeRowVisible: function (sheet) {
- this.beginMassOperation(sheet);
- const sortData = sheet.zh_dataType === this.DataType.Data ? sheet.zh_data : sheet.zh_tree.nodes;
- for (const iRow in sortData) {
- const node = sortData[iRow];
- if (node.visible !== undefined && node.visible !== null) {
- if (node.visible && node.waitingLoading) {
- SpreadJsObj._loadRowData(sheet, node, parseInt(iRow));
- }
- sheet.setRowVisible(iRow, node.visible);
- } else {
- if (node.waitingLoading) {
- this._loadRowData(sheet, node, parseInt(iRow));
- }
- sheet.setRowVisible(iRow, true);
- }
- }
- this.endMassOperation(sheet);
- },
- refreshColumnAlign: function (sheet) {
- if (sheet.zh_setting) {
- for (const iCol in sheet.zh_setting.cols) {
- const col = sheet.zh_setting.cols[iCol];
- sheet.getRange(-1, iCol, -1, 1).hAlign(col.hAlign);
- }
- }
- },
- refreshSheetReadOnly: function (sheet) {
- this.beginMassOperation(sheet);
- if (sheet.zh_setting) {
- sheet.zh_setting.cols.forEach(function (col, i) {
- for (let iRow = 0; iRow < sheet.getRowCount(); iRow++) {
- sheet.getCell(iRow, i).locked(col.readOnly || sheet.zh_setting.readOnly || false);
- }
- });
- }
- this.endMassOperation(sheet);
- },
- /**
- * 刷新列是否只读
- * @param sheet
- * @param field
- * @param readonly
- */
- resetFieldReadOnly: function (sheet, field, readonly) {
- const fields = field instanceof Array ? field : [field];
- if (sheet.zh_setting) {
- sheet.zh_setting.cols.forEach(function (col, i) {
- if (fields.indexOf(col.field) !== -1) {
- col.readOnly = readonly;
- for (let iRow = 0; iRow < sheet.getRowCount(); iRow++) {
- sheet.getCell(iRow, i).locked(col.readOnly || sheet.zh_setting.readOnly || false);
- }
- //sheet.getRange(-1, i, -1, 1, GC.Spread.Sheets.SheetArea.viewport).locked(col.readOnly || sheet.zh_setting.readOnly || false);
- }
- });
- }
- },
- CellType: {
- /**
- * 获取树结构CellType
- * 通过SpreadJsObj.loadSheetData(sheet, 'tree', tree)加载树结构数据
- * 要求tree类型为PathTree, 节点必须含有{id, pid, level, order, is_leaf}数据
- * @returns {TreeNodeCellType}
- */
- getTreeNodeCellType: function () {
- const xOffset = 2 + 5;
- const indent = 20;
- const levelIndent = -5;
- const halfBoxLength = 5;
- const halfExpandLength = 3;
- const lineColor = '#515151';//'#b8b8b8';
- const expandBoxColor = '#434343';//'#808080';
- const dotLine = true;
- /**
- * 画一条点线段
- * @param canvas - 画布
- * @param x1 - 线段起点 x
- * @param y1 - 线段起点 y
- * @param x2 - 线段终点 x
- * @param y2 - 线段终点 y
- * @param color - 线段颜色
- */
- const drawDotLine = function (canvas, x1, y1, x2, y2, color) {
- canvas.save();
- // 设置偏移量
- canvas.translate(0.5, 0.5);
- canvas.beginPath();
- canvas.strokeStyle = color;
- canvas.dottedLine(x1, y1, x2, y2);
- canvas.stroke();
- canvas.restore();
- };
- /**
- * 画一条线段
- * @param canvas - 画布
- * @param x1 - 线段起点 x
- * @param y1 - 线段起点 y
- * @param x2 - 线段终点 x
- * @param y2 - 线段终点 y
- * @param color - 线段颜色
- */
- const drawLine = function (canvas, x1, y1, x2, y2, color) {
- canvas.save();
- // 设置偏移量
- canvas.translate(0.5, 0.5);
- canvas.beginPath();
- canvas.moveTo(x1, y1);
- canvas.lineTo(x2, y2);
- canvas.strokeStyle = color;
- canvas.stroke();
- canvas.restore();
- };
- /**
- * 画一个方框
- * @param {Object} canvas - 画布
- * @param {Object} rect - 方框区域
- * @param {String} lineColor - 画线颜色
- * @param {String} fillColor - 填充颜色
- */
- const drawBox = function (canvas, rect, lineColor, fillColor) {
- canvas.save();
- // 设置偏移量
- canvas.translate(0.5, 0.5);
- canvas.strokeStyle = lineColor;
- canvas.beginPath();
- canvas.moveTo(rect.left, rect.top);
- canvas.lineTo(rect.left, rect.bottom);
- canvas.lineTo(rect.right, rect.bottom);
- canvas.lineTo(rect.right, rect.top);
- canvas.lineTo(rect.left, rect.top);
- canvas.stroke();
- canvas.fillStyle = fillColor ? fillColor : 'white';
- canvas.fill();
- canvas.restore();
- };
- /**
- * 画树结构-展开收起按钮
- * @param {Object} canvas - 画布
- * @param {Number} x - 单元格左顶点坐标 x
- * @param {Number} y - 单元格左顶点坐标 y
- * @param {Number} w - 单元格宽度
- * @param {Number} h - 单元格高度
- * @param {Number} centerX - 按钮中央坐标
- * @param {Number} centerY - 按钮中央坐标
- * @param {Boolean} expanded - 当前节点展开收起状态
- */
- const drawExpandBox = function (canvas, x, y, w, h, centerX, centerY, expanded, style) {
- let rect = {
- top: centerY - halfBoxLength,
- bottom: centerY + halfBoxLength,
- left: centerX - halfBoxLength,
- right: centerX + halfBoxLength
- };
- let h1, h2, offset = 1;
- if (rect.left < x + w) {
- // 方框超出单元格宽度时,超出部分不画。
- rect.right = Math.min(rect.right, x + w);
- drawBox(canvas, rect, expandBoxColor, style.backColor);
- // 画中心十字
- // 画十字横线
- h1 = centerX - halfExpandLength;
- h2 = Math.min(centerX + halfExpandLength, x + w);
- if (h2 > h1) {
- drawLine(canvas, h1, centerY, h2, centerY, expandBoxColor);
- }
- // 画十字竖线
- if (!expanded && (centerX < x + w)) {
- drawLine(canvas, centerX, centerY - halfExpandLength, centerX, centerY + halfExpandLength, expandBoxColor);
- }
- }
- };
- let TreeNodeCellType = function (){};
- TreeNodeCellType.prototype = new spreadNS.CellTypes.Text();
- const proto = TreeNodeCellType.prototype;
- /**
- * 绘制方法
- * @param {Object} canvas - 画布
- * @param value - cell.value
- * @param {Number} x - 单元格左顶点坐标 x
- * @param {Number} y - 单元格左顶点坐标 y
- * @param {Number} w - 单元格宽度
- * @param {Number} h - 单元格高度
- * @param {Object} style - cell.style
- * @param {Object} options
- */
- proto.paint = function (canvas, value, x, y, w, h, style, options) {
- // 清理 画布--单元格范围 旧数据
- if (style.backColor) {
- canvas.save();
- canvas.fillStyle = style.backColor;
- canvas.fillRect(x, y, w, h);
- canvas.restore();
- } else {
- // 不知道为什么在 概算投资-造价对比 下,这一句代码无法生效。
- // canvas.clearRect(x, y, w, h);
- canvas.save();
- canvas.fillStyle = 'white';
- canvas.fillRect(x, y, w, h);
- canvas.restore();
- }
- const tree = options.sheet.zh_tree;
- const setting = tree.setting;
- // 使用TreeCellType前,需定义sheet.tree
- if (tree) {
- const node = options.row < tree.nodes.length ? tree.nodes[options.row] : null;
- if (node) {
- const showTreeLine = true;
- const centerX = Math.floor(x) + (node[setting.level] - 1) * indent + (node[setting.level]) * levelIndent + indent / 2 + xOffset;
- const centerY = Math.floor((y + (y + h)) / 2);
- // Draw Sibling Line
- if (showTreeLine) {
- // Draw Horizontal Line
- if (centerX < x + w) {
- const x1 = centerX + indent / 2;
- if (dotLine) {
- drawDotLine(canvas, centerX, centerY, Math.min(x1, x + w), centerY, lineColor);
- // drawDotLine(canvas, centerX, centerY, Math.min(x1, x + w), centerY, style.foreColor);
- } else {
- drawLine(canvas, centerX, centerY, Math.min(x1, x + w), centerY, lineColor);
- // drawLine(canvas, centerX, centerY, Math.min(x1, x + w), centerY, style.foreColor);
- }
- }
- // Draw Vertical Line
- if (centerX < x + w) {
- const y1 = tree.isLastViewSibling(node) ? centerY : y + h;
- const parent = tree.getParent(node);
- const y2 = y1 - centerY;
- if (node[setting.order] === 1 && !parent) {
- if (dotLine) {
- drawDotLine(canvas, centerX, centerY, centerX, y1, lineColor);
- // drawDotLine(canvas, centerX, centerY, centerX, y1, style.foreColor);
- } else {
- drawLine(canvas, centerX, centerY, centerX, y1, lineColor);
- // drawLine(canvas, centerX, centerY, centerX, y1, style.foreColor);
- }
- } else {
- if (dotLine) {
- drawDotLine(canvas, centerX, y, centerX, y1, lineColor);
- // drawDotLine(canvas, centerX, y, centerX, y1, style.foreColor);
- } else {
- drawLine(canvas, centerX, y, centerX, y1, lineColor);
- // drawLine(canvas, centerX, y, centerX, y1, style.foreColor);
- }
- }
- }
- }
- // Draw Expand Box
- if (!node[setting.isLeaf]) {
- drawExpandBox(canvas, x, y, w, h, centerX, centerY, node.expanded, style);
- }
- // Draw Parent Line
- if (showTreeLine) {
- let parent = tree.getParent(node), parentCenterX = centerX - indent - levelIndent;
- while (parent) {
- if (!tree.isLastViewSibling(parent)) {
- if (parentCenterX < x + w) {
- if (dotLine) {
- drawDotLine(canvas, parentCenterX, y, parentCenterX, y + h, lineColor);
- // drawDotLine(canvas, parentCenterX, y, parentCenterX, y + h, style.foreColor);
- } else {
- drawLine(canvas, parentCenterX, y, parentCenterX, y + h, lineColor);
- // drawLine(canvas, parentCenterX, y, parentCenterX, y + h, style.foreColor);
- }
- }
- }
- parent = tree.getParent(parent);
- parentCenterX -= (indent + levelIndent);
- }
- };
- // 重定位x
- const move = (node[setting.level]) * indent + (node[setting.level]) * levelIndent + xOffset;
- x = x + move;
- w = w - move;
- }
- }
- // Drawing Text
- spreadNS.CellTypes.Text.prototype.paint.apply(this, [canvas, value, x, y, w, h, style, options]);
- };
- /**
- * 获取点击信息
- * @param {Number} x
- * @param {Number} y
- * @param {Object} cellStyle
- * @param {Object} cellRect
- * @param {Object} context
- * @returns {{x: *, y: *, row: *, col: *|boolean|*[]|number|{}|UE.dom.dtd.col, cellStyle: *, cellRect: *, sheet: *|StyleSheet, sheetArea: *}}
- */
- proto.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheet: context.sheet,
- sheetArea: context.sheetArea
- };
- };
- /**
- * 鼠标点击 树结构按钮 响应展开收起(未加载子节点时,先加载子节点)
- * @param {Object} hitinfo - 见getHitInfo
- */
- proto.processMouseDown = function (hitinfo) {
- const offset = -1;
- const tree = hitinfo.sheet.zh_tree;
- if (!tree) { return; }
- const node = tree.nodes[hitinfo.row];
- if (!node) { return; }
- let centerX = hitinfo.cellRect.x + offset + (node.level - 1) * indent + (node.level) * levelIndent + indent / 2 + xOffset;
- let centerY = (hitinfo.cellRect.y + offset + (hitinfo.cellRect.y + offset + hitinfo.cellRect.height)) / 2;
- // 点击展开节点时,如果已加载子项,则展开,反之这加载子项,展开
- if (Math.abs(hitinfo.x - centerX) < halfBoxLength && Math.abs(hitinfo.y - centerY) < halfBoxLength) {
- const children = tree.getChildren(node);
- if (!node.expanded && !node.is_leaf && children.length === 0 && tree.loadChildren) {
- tree.loadChildren(node, function () {
- node.expanded = true;
- const children = tree.getChildren(node);
- hitinfo.sheet.addRows(hitinfo.row + 1, children.length);
- SpreadJsObj.reLoadRowData(hitinfo.sheet, hitinfo.row + 1, children.length);
- });
- } else {
- tree.setExpanded(node, !node.expanded);
- SpreadJsObj.massOperationSheet(hitinfo.sheet, function () {
- const posterity = tree.getPosterity(node);
- for (const child of posterity) {
- const cIndex = tree.getNodeIndex(child);
- if (child.visible && child.waitingLoading) {
- SpreadJsObj._loadRowData(hitinfo.sheet, child, cIndex);
- }
- //if (child.visible !== hitinfo.sheet.getRowVisible(cIndex, hitinfo.sheetArea)) {
- hitinfo.sheet.setRowVisible(cIndex, child.visible, hitinfo.sheetArea);
- //}
- }
- });
- hitinfo.sheet.repaint();
- }
- }
- };
- return new TreeNodeCellType();
- },
- /**
- * 获取 带悬浮提示的CellType
- * @returns {TipCellType}
- */
- getTipCellType: function () {
- const maxHintWidth = 200, indent = 15, borderIndent = 10;
- const TipCellType = function () {};
- // 继承 SpreadJs定义的 普通的TextCellType
- TipCellType.prototype = new spreadNS.CellTypes.Text();
- const proto = TipCellType.prototype;
- proto.getTextDisplayWidth = function(hitinfo, str, font) {
- const xs = hitinfo.sheet.getParent().xs;
- const ctx = xs.childNodes[0].getContext("2d");
- if (font && font !== '') {
- ctx.font = font;
- } else {
- ctx.font = hitinfo.cellStyle.font;
- }
- return ctx.measureText(str).width;
- };
- proto.showTip = function (hitinfo, text) {
- return text && text !== '';
- };
- /**
- * 获取点击信息
- * @param {Number} x
- * @param {Number} y
- * @param {Object} cellStyle
- * @param {Object} cellRect
- * @param {Object} context
- * @returns {{x: *, y: *, row: *, col: *|boolean|*[]|number|{}|UE.dom.dtd.col, cellStyle: *, cellRect: *, sheet: *|StyleSheet, sheetArea: *}}
- */
- proto.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheet: context.sheet,
- sheetArea: context.sheetArea,
- ctx: context.sheet.getParent().xs,
- };
- };
- /**
- * 鼠标进入单元格事件 - 显示悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseEnter = function (hitinfo) {
- let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col);
- const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- if (col.getTip && Object.prototype.toString.apply(col.getTip) === "[object Function]") {
- const sortData = SpreadJsObj.getSortData(hitinfo.sheet);
- text = col.getTip(sortData[hitinfo.row]);
- }
- const pos = SpreadJsObj.getObjPos(hitinfo.sheet.getParent().qo);
- if (pos && this.showTip(hitinfo, text)) {
- if (!this._toolTipElement) {
- let div = $('#autoTip')[0];
- if (!div) {
- div = document.createElement("div");
- $(div).css("position", "absolute")
- .css("border", "1px #C0C0C0 solid")
- .css("box-shadow", "1px 2px 5px rgba(0,0,0,0.4)")
- .css("font", "9pt Arial")
- .css("background", "white")
- .css("padding", 5)
- .css("z-index", 999)
- .css("max-width", maxHintWidth)
- .css("word-wrap", "break-word")
- .attr("id", 'autoTip');
- document.body.insertBefore(div, null);
- }
- const validWidth = $(window).width() - (pos.x + hitinfo.x + indent) - borderIndent;
- const textWidth = this.getTextDisplayWidth(hitinfo, text, "9pt Arial");
- if (validWidth >= maxHintWidth || textWidth <= validWidth) {
- $(div).html(text).css("top", pos.y + hitinfo.y + indent).css("left", pos.x + hitinfo.x + indent);
- } else if (textWidth > maxHintWidth) {
- $(div).html(text).css("top", pos.y + hitinfo.y + indent).css("left", pos.x + hitinfo.x - indent - maxHintWidth);
- } else {
- $(div).html(text).css("top", pos.y + hitinfo.y + indent).css("left", pos.x + hitinfo.x - indent - textWidth);
- }
- this._toolTipElement = div;
- $(div).show("fast");
- }
- }
- };
- /**
- * 鼠标移出单元格事件 - 隐藏悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseLeave = function (hitinfo) {
- if (this._toolTipElement) {
- $(this._toolTipElement).hide();
- this._toolTipElement = null;
- }
- };
- return new TipCellType();
- },
- getAutoTipCellType: function () {
- const AutoTipCellType = function () {};
- // 继承 TipCellType
- AutoTipCellType.prototype = SpreadJsObj.CellType.getTipCellType();
- const proto = AutoTipCellType.prototype;
- proto.showTip = function (hitinfo, text) {
- return text && text !== '' && this.getTextDisplayWidth(hitinfo, text) > hitinfo.cellRect.width;
- };
- return new AutoTipCellType();
- },
- getDelayTipCellType: function () {
- const maxHintWidth = 200, indent = 15, borderIndent = 10;
- const TipCellType = function () {};
- // 继承 SpreadJs定义的 普通的TextCellType
- TipCellType.prototype = new spreadNS.CellTypes.Text();
- const proto = TipCellType.prototype;
- proto.getTextDisplayWidth = function(hitinfo, str, font) {
- const xs = hitinfo.sheet.getParent().xs;
- const ctx = xs.childNodes[0].getContext("2d");
- if (font && font !== '') {
- ctx.font = font;
- } else {
- ctx.font = hitinfo.cellStyle.font;
- }
- return ctx.measureText(str).width;
- };
- proto.showTip = function (hitinfo, text) {
- return text && text !== '';
- };
- /**
- * 获取点击信息
- * @param {Number} x
- * @param {Number} y
- * @param {Object} cellStyle
- * @param {Object} cellRect
- * @param {Object} context
- * @returns {{x: *, y: *, row: *, col: *|boolean|*[]|number|{}|UE.dom.dtd.col, cellStyle: *, cellRect: *, sheet: *|StyleSheet, sheetArea: *}}
- */
- proto.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheet: context.sheet,
- sheetArea: context.sheetArea,
- ctx: context.sheet.getParent().xs,
- };
- };
- /**
- * 鼠标进入单元格事件 - 显示悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseEnter = function (hitinfo) {
- let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col);
- const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- if (col.getTip && Object.prototype.toString.apply(col.getTip) === "[object Function]") {
- const sortData = SpreadJsObj.getSortData(hitinfo.sheet);
- text = col.getTip(sortData[hitinfo.row]);
- }
- const pos = SpreadJsObj.getObjPos(hitinfo.sheet.getParent().qo);
- if (pos && this.showTip(hitinfo, text)) {
- if (!this._toolTipElement) {
- let div = $('#autoTip')[0];
- if (!div) {
- div = document.createElement("div");
- $(div).css("position", "absolute")
- .css("border", "1px #C0C0C0 solid")
- .css("box-shadow", "1px 2px 5px rgba(0,0,0,0.4)")
- .css("font", "9pt Arial")
- .css("background", "white")
- .css("padding", 5)
- .css("z-index", 999)
- .css("max-width", maxHintWidth)
- .css("word-wrap", "break-word")
- .attr("id", 'autoTip');
- document.body.insertBefore(div, null);
- }
- const validWidth = $(window).width() - (pos.x + hitinfo.x + indent) - borderIndent;
- const textWidth = this.getTextDisplayWidth(hitinfo, text, "9pt Arial");
- if (validWidth >= maxHintWidth || textWidth <= validWidth) {
- $(div).html(text).css("top", pos.y + hitinfo.y + indent).css("left", pos.x + hitinfo.x + indent);
- } else if (textWidth > maxHintWidth) {
- $(div).html(text).css("top", pos.y + hitinfo.y + indent).css("left", pos.x + hitinfo.x - indent - maxHintWidth);
- } else {
- $(div).html(text).css("top", pos.y + hitinfo.y + indent).css("left", pos.x + hitinfo.x - indent - textWidth);
- }
- this._toolTipElement = div;
- const self = this;
- setTimeout(()=>{ if (self._toolTipElement) $(self._toolTipElement).show("fast");}, 300);
- }
- }
- };
- /**
- * 鼠标移出单元格事件 - 隐藏悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseLeave = function (hitinfo) {
- if (this._toolTipElement) {
- $(this._toolTipElement).hide();
- this._toolTipElement = null;
- }
- };
- return new TipCellType();
- },
- /**
- * 获取 带图片的cellType(图片需在document中定义好img,并写入col的img属性)
- *
- * img:
- * 1. 整列固定,则传入img的select
- * e.g. {title: '附件', field: 'attachment', cellType: 'image', img = '#attachment-img'}
- *
- * 2. 各单元格自定义,则
- * e.g. {title: '附件', field: 'attachment', cellType: 'image', img = getAttachmentImage}
- * function getAttachmentImage (data) {
- * $('#attachment-img').url = data.attachmentImageUrl;
- * return $('#attachment-img')[0];
- * }
- *
- * @returns {ImageCellType}
- */
- getImageCellType: function () {
- const ImageCellType = function (){};
- ImageCellType.prototype = new spreadNS.CellTypes.Text();
- const proto = ImageCellType.prototype;
- proto.getImage = function (sheet, iRow, iCol) {
- const col = sheet.zh_setting.cols[iCol];
- let imgSource = col.img;
- if (imgSource && Object.prototype.toString.apply(imgSource) === "[object Function]") {
- const sortData = SpreadJsObj.getSortData(sheet);
- const data = sortData ? sortData[iRow] : null;
- return data ? imgSource(data) : null;
- } else {
- return $(imgSource)[0] ? $(imgSource)[0] : null;
- }
- };
- proto.paint = function (canvas, value, x, y, w, h, style, options) {
- const col = options.sheet.zh_setting.cols[options.col];
- const img = this.getImage(options.sheet, options.row, options.col);
- const indent = col.indent ? col.indent : 10;
- if (img) {
- if (style.backColor) {
- canvas.save();
- canvas.fillStyle = style.backColor;
- canvas.fillRect(x, y, indent + img.width, h);
- canvas.restore();
- }
- canvas.drawImage(img, x + indent, y + (h - img.height) / 2);
- if (style.hAlign !== spreadNS.HorizontalAlign.left) {
- style.hAlign = spreadNS.HorizontalAlign.left;
- }
- x = x + indent + img.width;
- w = w - indent - img.width;
- }
- // Drawing Text
- spreadNS.CellTypes.Text.prototype.paint.apply(this, [canvas, value, x, y, w, h, style, options]);
- };
- /**
- * 获取点击信息
- * @param {Number} x
- * @param {Number} y
- * @param {Object} cellStyle
- * @param {Object} cellRect
- * @param {Object} context
- * @returns {{x: *, y: *, row: *, col: *|boolean|*[]|number|{}|UE.dom.dtd.col, cellStyle: *, cellRect: *, sheet: *|StyleSheet, sheetArea: *}}
- */
- proto.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheet: context.sheet,
- sheetArea: context.sheetArea
- };
- };
- /**
- * 鼠标点击
- * @param {Object} hitinfo - 见getHitInfo
- */
- proto.processMouseDown = function (hitinfo) {
- const img = this.getImage(hitinfo.sheet, hitinfo.row, hitinfo.col);
- if (img) {
- const halfX = img.width / 2, halfY = img.height / 2;
- const centerX = hitinfo.cellRect.x + indent + halfX;
- const centerY = hitinfo.cellRect.y + hitinfo.cellRect.height / 2;
- // 点击展开节点时,如果已加载子项,则展开,反之这加载子项,展开
- if (Math.abs(hitinfo.x - centerX) < halfX && Math.abs(hitinfo.y - centerY) < halfY) {
- const imageClick = hitinfo.sheet.zh_setting ? hitinfo.sheet.zh_setting.imageClick : null;
- if (imageClick && Object.prototype.toString.apply(imageClick) === "[object Function]") {
- const sortData = SpreadJsObj.getSortData(hitinfo.sheet);
- const data = sortData ? sortData[hitinfo.row] : null;
- imageClick(data, hitinfo);
- }
- }
- }
- };
- return new ImageCellType();
- },
- /**
- *
- * 获取 带normal-hover-active按钮的cellType(需定义三张图片,须在document中定义好img,并写入col的normalImg, hoverImg, activeImg属性)
- * 其中:normalImg必需,向下套用(不存在activeImg则使用hoverImg,不存在hoverImg则使用normalImg)
- * 三个img均可像getImageCellType一样动态获取,参见getImageCellType注释
- *
- * @returns {ImageCellType}
- */
- getImageButtonCellType: function () {
- let hover = 1, active = 2;
- const ImageCellType = function (){};
- ImageCellType.prototype = new spreadNS.CellTypes.Text();
- const proto = ImageCellType.prototype;
- proto.getImage = function (sheet, iRow, iCol) {
- const col = sheet.zh_setting.cols[iCol];
- let imgSource = col.normalImg;
- const cell = sheet.getCell(iRow, iCol), tag = cell.tag();
- if (tag === active) {
- imgSource = col.activeImg ? col.activeImg : (col.hoverImg ? col.hoverImg : col.normalImg);
- } else if (tag === hover) {
- imgSource = col.hoverImg ? col.hoverImg : col.normalImg;
- }
- if (imgSource && Object.prototype.toString.apply(imgSource) === "[object Function]") {
- const sortData = SpreadJsObj.getSortData(sheet);
- const data = sortData ? sortData[iRow] : null;
- return data ? imgSource(data) : null;
- } else {
- return $(imgSource)[0] ? $(imgSource)[0] : null;
- }
- };
- proto.paint = function (canvas, value, x, y, w, h, style, options) {
- const col = options.sheet.zh_setting.cols[options.col];
- const sortData = SpreadJsObj.getSortData(options.sheet);
- const data = sortData ? sortData[options.row] : null;
- let showImage = true;
- if (col.showImage && Object.prototype.toString.apply(col.showImage) === "[object Function]") {
- showImage = col.showImage(data);
- }
- const img = showImage ? this.getImage(options.sheet, options.row, options.col) : null;
- const indent = col.indent ? col.indent : 10;
- if (style.hAlign === spreadNS.HorizontalAlign.right) {
- if (img) {
- if (style.backColor) {
- canvas.save();
- canvas.fillStyle = style.backColor;
- canvas.fillRect(x + w - indent - img.width, y, img.width, h);
- canvas.restore();
- }
- canvas.drawImage(img, x + w - indent - img.width, y + (h - img.height) / 2);
- w = w - indent - img.width;
- }
- // Drawing Text
- spreadNS.CellTypes.Text.prototype.paint.apply(this, [canvas, value, x, y, w, h, style, options]);
- } else {
- if (img) {
- if (style.backColor) {
- canvas.save();
- canvas.fillStyle = style.backColor;
- canvas.fillRect(x, y, indent + img.width, h);
- canvas.restore();
- }
- canvas.drawImage(img, x + 10, y + (h - img.height) / 2);
- if (style.hAlign !== spreadNS.HorizontalAlign.left) {
- style.hAlign = spreadNS.HorizontalAlign.left;
- }
- x = x + indent + img.width;
- w = w - indent - img.width;
- }
- // Drawing Text
- spreadNS.CellTypes.Text.prototype.paint.apply(this, [canvas, value, x, y, w, h, style, options]);
- }
- };
- /**
- * 获取点击信息
- * @param {Number} x
- * @param {Number} y
- * @param {Object} cellStyle
- * @param {Object} cellRect
- * @param {Object} context
- * @returns {{x: *, y: *, row: *, col: *|boolean|*[]|number|{}|UE.dom.dtd.col, cellStyle: *, cellRect: *, sheet: *|StyleSheet, sheetArea: *}}
- */
- proto.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheet: context.sheet,
- sheetArea: context.sheetArea
- };
- };
- proto.processMouseEnter = function (hitinfo) {
- const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- // Drawing Image
- if (col.hoverImg) {
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- cell.tag(hover);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- };
- proto.processMouseLeave = function (hitinfo) {
- const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- // Drawing Image
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- cell.tag(null);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- };
- // proto.processMouseDown = function (hitinfo) {
- // const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- // if (col.activeImg) {
- // const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- // cell.tag(active);
- // hitinfo.sheet.repaint(hitinfo.cellRect);
- // }
- // };
- // proto.processMouseUp = function (hitinfo) {
- // const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- // const sortData = SpreadJsObj.getSortData(hitinfo.sheet);
- // const data = sortData ? sortData[hitinfo.row] : null;
- // if (col.showImage && Object.prototype.toString.apply(col.showImage) === "[object Function]") {
- // if (!col.showImage(data)) {
- // return;
- // }
- // }
- // const imageClick = hitinfo.sheet.zh_setting ? hitinfo.sheet.zh_setting.imageClick : null;
- // if (imageClick && Object.prototype.toString.apply(imageClick) === "[object Function]") {
- // imageClick(data);
- // const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- // cell.tag(null);
- // hitinfo.sheet.repaint(hitinfo.cellRect);
- // }
- // };
- /*
- 注释部分以进入鼠标进入图片,点击图片为基准更新图片,鼠标快速移动时,可能失效
- */
- proto.processMouseDown = function (hitinfo) {
- const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- const img = this.getImage(hitinfo.sheet, hitinfo.row, hitinfo.col);
- const halfX = img.width / 2, halfY = img.height / 2;
- const indent = col.indent ? col.indent : 10;
- const centerX = hitinfo.cellStyle.hAlign === spreadNS.HorizontalAlign.right
- ? hitinfo.cellRect.x + hitinfo.cellRect.width - indent -halfX
- : hitinfo.cellRect.x + indent + halfX;
- const centerY = hitinfo.cellRect.y + hitinfo.cellRect.height / 2;
- if (Math.abs(hitinfo.x - centerX) < halfX && Math.abs(hitinfo.y - centerY) < halfY) {
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- cell.tag(active);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- };
- proto.processMouseUp = function (hitinfo) {
- const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- const img = this.getImage(hitinfo.sheet, hitinfo.row, hitinfo.col);
- const halfX = img.width / 2, halfY = img.height / 2;
- const indent = col.indent ? col.indent : 10;
- const centerX = hitinfo.cellStyle.hAlign === spreadNS.HorizontalAlign.right
- ? hitinfo.cellRect.x + hitinfo.cellRect.width - indent -halfX
- : hitinfo.cellRect.x + indent + halfX;
- const centerY = hitinfo.cellRect.y + hitinfo.cellRect.height / 2;
- if (Math.abs(hitinfo.x - centerX) < halfX && Math.abs(hitinfo.y - centerY) < halfY) {
- const imageClick = hitinfo.sheet.zh_setting ? hitinfo.sheet.zh_setting.imageClick : null;
- if (imageClick && Object.prototype.toString.apply(imageClick) === "[object Function]") {
- const sortData = SpreadJsObj.getSortData(hitinfo.sheet);
- const data = sortData ? sortData[hitinfo.row] : null;
- imageClick(data, hitinfo);
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- cell.tag(null);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- }
- };
- proto.processMouseMove = function (hitinfo) {
- const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- const img = this.getImage(hitinfo.sheet, hitinfo.row, hitinfo.col);
- const halfX = img.width / 2, halfY = img.height / 2;
- const indent = col.indent ? col.indent : 10;
- const centerX = hitinfo.cellStyle.hAlign === spreadNS.HorizontalAlign.right
- ? hitinfo.cellRect.x + hitinfo.cellRect.width - indent -halfX
- : hitinfo.cellRect.x + indent + halfX;
- const centerY = hitinfo.cellRect.y + hitinfo.cellRect.height / 2;
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- if (Math.abs(hitinfo.x - centerX) < halfX && Math.abs(hitinfo.y - centerY) < halfY) {
- if (cell.tag() !== hover) {
- cell.tag(hover);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- } else {
- if (cell.tag() === hover) {
- cell.tag(null);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- }
- };
- return new ImageCellType();
- },
- getActiveImageButtonCellType: function () {
- let show = 1, hover = 2, active = 2;
- const ImageCellType = function (){};
- ImageCellType.prototype = new spreadNS.CellTypes.Text();
- const proto = ImageCellType.prototype;
- proto.getImage = function (sheet, iRow, iCol) {
- const col = sheet.zh_setting.cols[iCol];
- let imgSource = null;
- const cell = sheet.getCell(iRow, iCol), tag = cell.tag();
- if (tag === show) {
- imgSource = col.normalImg;
- } else if (tag === active) {
- imgSource = col.activeImg ? col.activeImg : (col.hoverImg ? col.hoverImg : col.normalImg);
- } else if (tag === hover) {
- imgSource = col.hoverImg ? col.hoverImg : col.normalImg;
- }
- if (imgSource && Object.prototype.toString.apply(imgSource) === "[object Function]") {
- const sortData = SpreadJsObj.getSortData(sheet);
- const data = sortData ? sortData[iRow] : null;
- return data ? imgSource(data) : null;
- } else {
- return $(imgSource)[0] ? $(imgSource)[0] : null;
- }
- };
- proto.getActiveImage = function(sheet, iRow, iCol) {
- const col = sheet.zh_setting.cols[iCol];
- const sortData = SpreadJsObj.getSortData(sheet);
- const data = sortData ? sortData[iRow] : null;
- let showImage = true;
- if (col.showImage && Object.prototype.toString.apply(col.showImage) === "[object Function]") {
- showImage = col.showImage(data);
- }
- const img = showImage ? this.getImage(sheet, iRow, iCol) : null;
- return [col, img];
- };
- proto.paint = function (canvas, value, x, y, w, h, style, options) {
- const [col, img] = this.getActiveImage(options.sheet, options.row, options.col);
- const indent = col.indent ? col.indent : 10;
- if (style.hAlign === spreadNS.HorizontalAlign.right || col.imgAlign === spreadNS.HorizontalAlign.right) {
- if (img) {
- if (style.backColor) {
- canvas.save();
- canvas.fillStyle = style.backColor;
- canvas.fillRect(x + w - indent - img.width, y, img.width + indent, h);
- canvas.restore();
- }
- canvas.drawImage(img, x + w - indent - img.width, y + (h - img.height) / 2);
- w = w - indent - img.width;
- }
- // Drawing Text
- spreadNS.CellTypes.Text.prototype.paint.apply(this, [canvas, value, x, y, w, h, style, options]);
- } else {
- if (img) {
- if (style.backColor) {
- canvas.save();
- canvas.fillStyle = style.backColor;
- canvas.fillRect(x, y, indent + img.width, h);
- canvas.restore();
- }
- canvas.drawImage(img, x + 10, y + (h - img.height) / 2);
- if (style.hAlign !== spreadNS.HorizontalAlign.left) {
- style.hAlign = spreadNS.HorizontalAlign.left;
- }
- x = x + indent + img.width;
- w = w - indent - img.width;
- }
- // Drawing Text
- spreadNS.CellTypes.Text.prototype.paint.apply(this, [canvas, value, x, y, w, h, style, options]);
- }
- };
- /**
- * 获取点击信息
- * @param {Number} x
- * @param {Number} y
- * @param {Object} cellStyle
- * @param {Object} cellRect
- * @param {Object} context
- * @returns {{x: *, y: *, row: *, col: *|boolean|*[]|number|{}|UE.dom.dtd.col, cellStyle: *, cellRect: *, sheet: *|StyleSheet, sheetArea: *}}
- */
- proto.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheet: context.sheet,
- sheetArea: context.sheetArea
- };
- };
- proto.processMouseEnter = function (hitinfo) {
- const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- // Drawing Image
- if (col.normalImg) {
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- cell.tag(show);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- };
- proto.processMouseLeave = function (hitinfo) {
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- cell.tag(null);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- };
- // proto.processMouseDown = function (hitinfo) {
- // const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- // if (col.activeImg) {
- // const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- // cell.tag(active);
- // hitinfo.sheet.repaint(hitinfo.cellRect);
- // }
- // };
- // proto.processMouseUp = function (hitinfo) {
- // const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- // const sortData = SpreadJsObj.getSortData(hitinfo.sheet);
- // const data = sortData ? sortData[hitinfo.row] : null;
- // if (col.showImage && Object.prototype.toString.apply(col.showImage) === "[object Function]") {
- // if (!col.showImage(data)) {
- // return;
- // }
- // }
- // const imageClick = hitinfo.sheet.zh_setting ? hitinfo.sheet.zh_setting.imageClick : null;
- // if (imageClick && Object.prototype.toString.apply(imageClick) === "[object Function]") {
- // imageClick(data);
- // const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- // cell.tag(null);
- // hitinfo.sheet.repaint(hitinfo.cellRect);
- // }
- // };
- /*
- 注释部分以进入鼠标进入图片,点击图片为基准更新图片,鼠标快速移动时,可能失效
- */
- proto.processMouseDown = function (hitinfo) {
- const [col, img] = this.getActiveImage(hitinfo.sheet, hitinfo.row, hitinfo.col);
- if (!img) return;
- const halfX = img.width / 2, halfY = img.height / 2;
- const indent = col.indent ? col.indent : 10;
- const centerX = (hitinfo.cellStyle.hAlign === spreadNS.HorizontalAlign.right || col.imgAlign === spreadNS.HorizontalAlign.right)
- ? hitinfo.cellRect.x + hitinfo.cellRect.width - indent -halfX
- : hitinfo.cellRect.x + indent + halfX;
- const centerY = hitinfo.cellRect.y + hitinfo.cellRect.height / 2;
- if (Math.abs(hitinfo.x - centerX) < halfX && Math.abs(hitinfo.y - centerY) < halfY) {
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- cell.tag(active);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- };
- proto.processMouseUp = function (hitinfo) {
- const [col, img] = this.getActiveImage(hitinfo.sheet, hitinfo.row, hitinfo.col);
- if (!img) return;
- const halfX = img.width / 2, halfY = img.height / 2;
- const indent = col.indent ? col.indent : 10;
- const centerX = (hitinfo.cellStyle.hAlign === spreadNS.HorizontalAlign.right || col.imgAlign === spreadNS.HorizontalAlign.right)
- ? hitinfo.cellRect.x + hitinfo.cellRect.width - indent -halfX
- : hitinfo.cellRect.x + indent + halfX;
- const centerY = hitinfo.cellRect.y + hitinfo.cellRect.height / 2;
- if (Math.abs(hitinfo.x - centerX) < halfX && Math.abs(hitinfo.y - centerY) < halfY) {
- const imageClick = hitinfo.sheet.zh_setting ? hitinfo.sheet.zh_setting.imageClick : null;
- if (imageClick && Object.prototype.toString.apply(imageClick) === "[object Function]") {
- const sortData = SpreadJsObj.getSortData(hitinfo.sheet);
- const data = sortData ? sortData[hitinfo.row] : null;
- imageClick(data, hitinfo);
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- cell.tag(hover);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- }
- };
- proto.processMouseMove = function (hitinfo) {
- const [col, img] = this.getActiveImage(hitinfo.sheet, hitinfo.row, hitinfo.col);
- if (!img) return;
- const halfX = img.width / 2, halfY = img.height / 2;
- const indent = col.indent ? col.indent : 10;
- const centerX = (hitinfo.cellStyle.hAlign === spreadNS.HorizontalAlign.right || col.imgAlign === spreadNS.HorizontalAlign.right)
- ? hitinfo.cellRect.x + hitinfo.cellRect.width - indent -halfX
- : hitinfo.cellRect.x + indent + halfX;
- const centerY = hitinfo.cellRect.y + hitinfo.cellRect.height / 2;
- const cell = hitinfo.sheet.getCell(hitinfo.row, hitinfo.col);
- if (Math.abs(hitinfo.x - centerX) < halfX && Math.abs(hitinfo.y - centerY) < halfY) {
- if (cell.tag() !== hover) {
- cell.tag(hover);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- } else {
- if (cell.tag() === hover) {
- cell.tag(show);
- hitinfo.sheet.repaint(hitinfo.cellRect);
- }
- }
- };
- return new ImageCellType();
- },
- /**
- * 获取 嵌入Html的cellType
- * @returns {HTMLCellType}
- */
- getHtmlCellType: function () {
- const HTMLCellType = function (){};
- HTMLCellType.prototype = new spreadNS.CellTypes.Text;
- const proto = HTMLCellType.prototype;
- proto.paint = function (ctx, value, x, y, w, h, style, context) {
- let DOMURL = window.URL || window.webkitURL || window;
- let cell = context.sheet.getCell(context.row, context.col);
- let img = cell.tag();
- if (img) {
- try {
- ctx.save();
- ctx.rect(x, y, w, h);
- ctx.clip();
- ctx.drawImage(img, x + 2, y + 2);
- ctx.restore();
- cell.tag(null);
- return;
- }
- catch (err) {
- GC.Spread.Sheets.CustomCellType.prototype.paint.apply(this, [ctx, "#HTMLError", x, y, w, h, style, context]);
- cell.tag(null);
- return;
- }
- }
- let svgPattern = '<svg xmlns="http://www.w3.org/2000/svg" width="{0}" height="{1}">' +
- '<foreignObject width="100%" height="100%"><div xmlns="http://www.w3.org/1999/xhtml" style="font:{2}">{3}</div></foreignObject></svg>';
- let data = svgPattern.replace("{0}", w).replace("{1}", h).replace("{2}", style.font).replace("{3}", value);
- let doc = document.implementation.createHTMLDocument("");
- doc.write(data);
- // Get well-formed markup
- data = (new XMLSerializer()).serializeToString(doc.body.children[0]);
- img = new Image();
- //var svg = new Blob([data], {type: 'image/svg+xml;charset=utf-8'});
- //var url = DOMURL.createObjectURL(svg);
- //img.src = url;
- img.src = 'data:image/svg+xml;base64,' + window.btoa(data);
- cell.tag(img);
- img.onload = function () {
- context.sheet.repaint(new GC.Spread.Sheets.Rect(x, y, w, h));
- }
- };
- return new HTMLCellType();
- },
- /**
- * 获取 字符超长缩略的cellType
- * @returns {EllipsisTextCellType}
- */
- getEllipsisTextCellType: function () {
- const EllipsisTextCellType = function (){};
- EllipsisTextCellType.prototype = new spreadNS.CellTypes.Text;
- const proto = EllipsisTextCellType.prototype;
- proto.getEllipsisText = function(c, str, maxWidth) {
- var width = c.measureText(str).width;
- var ellipsis = '…';
- var ellipsisWidth = c.measureText(ellipsis).width;
- if (width <= maxWidth || width <= ellipsisWidth) {
- return str;
- } else {
- var len = str.length;
- while (width >= maxWidth - ellipsisWidth && len-- > 0) {
- str = str.substring(0, len);
- width = c.measureText(str).width;
- }
- return str + ellipsis;
- }
- };
- proto.paint = function (ctx, value, x, y, w, h, style, context) {
- ctx.font = style.font;
- value = this.getEllipsisText(ctx, value, w - 2);
- spreadNS.CellTypes.Text.prototype.paint.apply(this, [ctx, value, x, y, w, h, style, context]);
- };
- return new EllipsisTextCellType();
- },
- getEllipsisTextAutoTipCellType: function () {
- const CellType = function () {};
- // 继承 TipCellType
- CellType.prototype = SpreadJsObj.CellType.getAutoTipCellType();
- const proto = CellType.prototype;
- const ellipsisTextCellType = SpreadJsObj.CellType.getEllipsisTextCellType();
- proto.getEllipsisText = ellipsisTextCellType.getEllipsisText;
- proto.paint = ellipsisTextCellType.paint;
- return new CellType();
- },
- /**
- * 获取 动态显示ComboBox的cellType
- * @returns {ActiveComboCellType}
- */
- getActiveComboCellType: function () {
- const ActiveComboCellType = function () {};
- ActiveComboCellType.prototype = new spreadNS.CellTypes.ComboBox();
- const proto = ActiveComboCellType.prototype;
- proto.paintValue = function (ctx, value, x, y, w, h, style, options) {
- const sheet = options.sheet;
- if (options.row === sheet.getActiveRowIndex() && options.col === sheet.getActiveColumnIndex()
- && !sheet.getCell(options.row, options.col).locked()) {
- spreadNS.CellTypes.ComboBox.prototype.paintValue.apply(this, arguments);
- } else {
- spreadNS.CellTypes.Base.prototype.paintValue.apply(this, arguments);
- }
- };
- proto.processMouseEnter = function (hitinfo) {
- hitinfo.sheet.repaint(hitinfo.cellRect);
- };
- proto.getHitInfo = function (x, y, cellStyle, cellRect, options) {
- const sheet = options.sheet;
- if (options.row === sheet.getActiveRowIndex() && options.col === sheet.getActiveColumnIndex()
- && !sheet.getCell(options.row, options.col).locked()) {
- return spreadNS.CellTypes.ComboBox.prototype.getHitInfo.apply(this, [x, y, cellStyle, cellRect, options]);
- } else {
- return {
- x: x,
- y: y,
- row: options.row,
- col: options.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheetArea: options.sheetArea
- };
- }
- };
- return new ActiveComboCellType();
- },
- /**
- * 获取 单位的CellType
- * @returns {GC.Spread.Sheets.CellTypes.ComboBox}
- */
- getUnitCellType: function (comboEdit, items = ['m', 'km', 'm2', 'm3', 'dm3', 'kg', 't', 'm3·km',
- '总额', '月' ,'项', '处' ,'个', '根', '棵', '块', '台', '系统', '延米', '每一试桩',
- '桥长米', '公路公里', '株', '组', '座', '元', '工日', '套', '台班', '艘班', '亩', '片',
- 'm/处', 'm/道', 'm/座', 'm2/m', 'm3/m', 'm3/处', '根/米', 'm3/m2']) {
- let combo = this.getActiveComboCellType();
- combo.editable(comboEdit);
- combo.itemHeight(10).items(items);
- return combo;
- },
- /**
- * 获取 自定义的CellType
- * @returns {GC.Spread.Sheets.CellTypes.ComboBox}
- */
- getCustomizeComboCellType: function (items) {
- let combo = this.getActiveComboCellType();
- combo.itemHeight(10).editorValueType(spreadNS.CellTypes.EditorValueType.value).items(items);
- return combo;
- },
- getSpecComboCellType: function (items) {
- const ComboCellType = function () {};
- ComboCellType.prototype = new spreadNS.CellTypes.ComboBox();
- const proto = ComboCellType.prototype;
- proto.paintValue = function (ctx, value, x, y, w, h, style, options) {
- const sheet = options.sheet;
- const setting = options.sheet.zh_setting;
- const col = setting.cols[options.col];
- const data = SpreadJsObj.getSelectObject(options.sheet);
- const comboEdit = (col.comboEdit && Object.prototype.toString.apply(col.comboEdit) === "[object Function]")
- ? col.comboEdit(options.sheet, data)
- : (col.comboEdit !== undefined ? col.comboEdit : true);
- if (options.row === sheet.getActiveRowIndex() && options.col === sheet.getActiveColumnIndex()
- && !sheet.getCell(options.row, options.col).locked() && comboEdit) {
- spreadNS.CellTypes.ComboBox.prototype.paintValue.apply(this, arguments);
- } else {
- spreadNS.CellTypes.Base.prototype.paintValue.apply(this, arguments);
- }
- };
- proto.processMouseEnter = function (hitinfo) {
- hitinfo.sheet.repaint(hitinfo.cellRect);
- };
- proto.getHitInfo = function (x, y, cellStyle, cellRect, options) {
- const sheet = options.sheet;
- if (options.row === sheet.getActiveRowIndex() && options.col === sheet.getActiveColumnIndex()
- && !sheet.getCell(options.row, options.col).locked()) {
- return spreadNS.CellTypes.ComboBox.prototype.getHitInfo.apply(this, [x, y, cellStyle, cellRect, options]);
- } else {
- return {
- x: x,
- y: y,
- row: options.row,
- col: options.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheetArea: options.sheetArea
- };
- }
- };
- const combo = new ComboCellType();
- combo.itemHeight(10).items(items).editorValueType(spreadNS.CellTypes.EditorValueType.value);
- return combo;
- },
- getStageComboCellType: function () {
- const ComboCellType = function () {};
- ComboCellType.prototype = new spreadNS.CellTypes.ComboBox();
- const proto = ComboCellType.prototype;
- proto.paint = function (ctx, value, x, y, w, h, style, context) {
- const setting = context.sheet.zh_setting;
- const col = setting.cols[context.col];
- const data = SpreadJsObj.getSelectObject(context.sheet);
- this.itemHeight(10).editorValueType(spreadNS.CellTypes.EditorValueType.value).items(col.getItems(data));
- };
- return new ComboCellType();
- },
- /**
- * 获取 日期选择 CellType
- * @returns {DatePickerCellType}
- */
- getDatePickerCellType: function () {
- let datepicker;
- const DatePickerCellType = function () {};
- DatePickerCellType.prototype = new spreadNS.CellTypes.Text();
- const proto = DatePickerCellType.prototype;
- proto.createEditorElement = function (context) {
- return document.createElement("input");
- };
- proto.activateEditor = function (editorContext, cellStyle, cellRect, context) {
- const self = this;
- if (editorContext) {
- const $editor = $(editorContext);
- //spreadNS.CellTypes.Text.prototype.activateEditor.apply(this, arguments);
- $editor.css("position", "absolute");
- datepicker = $editor.datepicker({
- language: 'zh',
- dateFormat: 'yyyy-MM-DD'
- }).data('datepicker');
- datepicker.show();
- }
- };
- proto.deactivateEditor = function (editorContext, context) {
- datepicker.hide();
- datepicker.destroy();
- spreadNS.CellTypes.Base.prototype.deactivateEditor.apply(this, arguments);
- };
- proto.setEditorValue = function (editor, value, context) {
- if (datepicker) {
- datepicker.selectDate(value);
- }
- };
- proto.getEditorValue = function (editor, context) {
- return datepicker ? datepicker.focused : null;
- };
- proto.updateEditor = function (editorContext, cellStyle, cellRect, context) {
- if (editorContext) {
- const $editor = $(editorContext);
- $editor.css("width", cellRect.width + 1);
- $editor.css("height", cellRect.height + 3);
- }
- };
- return new DatePickerCellType();
- },
- /**
- * 获取 鼠标移入变手势 CellType
- * @returns {DatePickerCellType}
- */
- getMouseTouchCellType: function () {
- const mouseTouchCellType = function () {};
- mouseTouchCellType.prototype = new spreadNS.CellTypes.Base();
- mouseTouchCellType.prototype.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- var xm = cellRect.x + cellRect.width / 2,
- ym = cellRect.y + cellRect.height / 2,
- size = 10;
- var info = { x: x, y: y, row: context.row, col: context.col, cellRect: cellRect, sheetArea: context.sheetArea };
- if (xm - size <= x && x <= xm + size && ym - size <= y && y <= ym + size) {
- info.isReservedLocation = true;
- }
- return info;
- };
- mouseTouchCellType.prototype.processMouseMove = function (hitInfo) {
- var sheet = hitInfo.sheet;
- var div = sheet.getParent().getHost();
- var canvasId = div.id + "vp_vp";
- var canvas = $("#"+canvasId)[0];
- if (sheet && hitInfo.isReservedLocation) {
- canvas.style.cursor='pointer';
- return true;
- }else{
- canvas.style.cursor='default';
- }
- return false;
- };
- return new mouseTouchCellType();
- },
- getStackedBarCellType: function () {
- const stackedBarCellType = function(){};
- stackedBarCellType.prototype = new spreadNS.CellTypes.Text();
- const indent = 3, defaultR = 0.05, minHeight = 2;
- const tipsMaxHintWidth = 200, tipsIndent = 15, tipsBorderIndent = 10;
- /**
- * 画一个长条
- * @param {Object} canvas - 画布
- * @param {Object} rect - 方框区域
- * @param {String} lineColor - 画线颜色
- * @param {String} fillColor - 填充颜色
- */
- // roundRect方法在Chrome99版本以后才支持
- const drawBarBefore99 = function (canvas, x, y, w, h, r, color) {
- const rArr = r instanceof Array ? r : [r, r, r, r];
- canvas.save();
- // 设置偏移量
- canvas.translate(0.5, 0.5);
- canvas.strokeStyle = color;
- canvas.beginPath();
- canvas.moveTo(x+rArr[0], y);
- canvas.arcTo(x+w, y, x+w, y+h, Math.min(rArr[1], w));
- canvas.arcTo(x+w, y+h, x, y+h, Math.min(rArr[2], w));
- canvas.arcTo(x, y+h, x, y, Math.min(rArr[3], w));
- canvas.arcTo(x, y, x+w, y, Math.min(rArr[0], w));
- canvas.stroke();
- canvas.fillStyle = color;
- canvas.fill();
- canvas.restore();
- };
- const drawBar = function (canvas, x, y, w, h, r, color) {
- canvas.save();
- // 设置偏移量
- canvas.translate(0.5, 0.5);
- canvas.strokeStyle = color;
- canvas.beginPath();
- canvas.roundRect(x, y, w, h, r);
- canvas.stroke();
- canvas.fillStyle = color;
- canvas.fill();
- canvas.restore();
- };
- const drawSB = function (canvas, x, y, w, h, r, color) {
- canvas.save();
- // 设置偏移量
- canvas.translate(0.5, 0.5);
- canvas.strokeStyle = color;
- canvas.beginPath();
- canvas.moveTo(x, y);
- canvas.lineTo(x+w, y);
- if (w > r) {
- canvas.arcTo(x+w, y+h, x, y+h, r);
- canvas.lineTo(x, y+h);
- } else {
- canvas.arcTo(x+w, y+h-r+w, x, y+h-r+w, Math.min(r, w));
- canvas.lineTo(x, y+h-r+w);
- }
- //canvas.arcTo(x+w, y+h, x, y+h, Math.min(r, w));
- //canvas.lineTo(x, y+h);
- canvas.lineTo(x, y);
- canvas.stroke();
- canvas.fillStyle = color;
- canvas.fill();
- canvas.restore();
- };
- const proto = stackedBarCellType.prototype;
- /**
- * 绘制方法
- * @param {Object} canvas - 画布
- * @param value - cell.value
- * @param {Number} x - 单元格左顶点坐标 x
- * @param {Number} y - 单元格左顶点坐标 y
- * @param {Number} w - 单元格宽度
- * @param {Number} h - 单元格高度
- * @param {Object} style - cell.style
- * @param {Object} options
- */
- proto.paint = function (canvas, value, x, y, w, h, style, options) {
- // 清理 画布--单元格范围 旧数据
- canvas.save();
- canvas.fillStyle = style.backColor || 'white';
- canvas.fillRect(x, y, w, h);
- canvas.restore();
- const col = options.sheet.zh_setting.cols[options.col];
- const barData = value;
- const left = x + indent;
- const startTop = y + indent;
- const validHeight = h - indent - indent - (col.stackedBarCover || barData.length === 1 ? 1 : barData.length / 2 + 1);
- const height = col.stackedBarCover || barData.length === 0 ? validHeight : Math.max(validHeight/barData.length, minHeight);
- const validWidth = w - indent - indent - 1;
- for (const [i, bd] of barData.entries()) {
- let width = ZhCalc.mul(validWidth, bd.percent, 2);
- if (width < defaultR) continue;
- const top = col.stackedBarCover ? startTop : startTop + height * i + i - 1;
- //drawBarBefore99(canvas, left, top, width, height, ZhCalc.mul(height, defaultR, 2), bd.color);
- //drawBarBefore99(canvas, left, top, width, height, [0, 0, ZhCalc.div(height, 2, 2), 0], bd.color);
- if (col.stackedBarCover) {
- drawSB(canvas, left, top, width, height, ZhCalc.div(height, 2, 2), bd.color);
- } else {
- drawBarBefore99(canvas, left, top, width, height, ZhCalc.mul(height, defaultR, 2), bd.color);
- }
- }
- };
- proto.getTextDisplayWidth = function(hitinfo, str, font) {
- const xs = hitinfo.sheet.getParent().xs;
- const ctx = xs.childNodes[0].getContext("2d");
- if (font && font !== '') {
- ctx.font = font;
- } else {
- ctx.font = hitinfo.cellStyle.font;
- }
- return ctx.measureText(str).width;
- };
- proto.showTip = function (hitinfo, text) {
- return text && text !== '';
- };
- /**
- * 获取点击信息
- * @param {Number} x
- * @param {Number} y
- * @param {Object} cellStyle
- * @param {Object} cellRect
- * @param {Object} context
- * @returns {{x: *, y: *, row: *, col: *|boolean|*[]|number|{}|UE.dom.dtd.col, cellStyle: *, cellRect: *, sheet: *|StyleSheet, sheetArea: *}}
- */
- proto.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheet: context.sheet,
- sheetArea: context.sheetArea,
- ctx: context.sheet.getParent().xs,
- };
- };
- /**
- * 鼠标进入单元格事件 - 显示悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseEnter = function (hitinfo) {
- let text = hitinfo.sheet.getText(hitinfo.row, hitinfo.col);
- const col = hitinfo.sheet.zh_setting.cols[hitinfo.col];
- if (col.getTip && Object.prototype.toString.apply(col.getTip) === "[object Function]") {
- const sortData = SpreadJsObj.getSortData(hitinfo.sheet);
- text = col.getTip(sortData[hitinfo.row]);
- }
- const pos = SpreadJsObj.getObjPos(hitinfo.sheet.getParent().qo);
- if (pos && this.showTip(hitinfo, text)) {
- if (!this._toolTipElement) {
- let div = $('#autoTip')[0];
- if (!div) {
- div = document.createElement("div");
- $(div).css("position", "absolute")
- .css("border", "1px #C0C0C0 solid")
- .css("box-shadow", "1px 2px 5px rgba(0,0,0,0.4)")
- .css("font", "9pt Arial")
- .css("background", "white")
- .css("padding", 5)
- .css("z-index", 999)
- .css("max-width", tipsMaxHintWidth)
- .css("word-wrap", "break-word")
- .attr("id", 'autoTip');
- document.body.insertBefore(div, null);
- }
- const validWidth = $(window).width() - (pos.x + hitinfo.x + tipsIndent) - tipsBorderIndent;
- const textWidth = this.getTextDisplayWidth(hitinfo, text, "9pt Arial");
- if (validWidth >= tipsMaxHintWidth || textWidth <= validWidth) {
- $(div).html(text).css("top", pos.y + hitinfo.y + tipsIndent).css("left", pos.x + hitinfo.x + tipsIndent);
- } else if (textWidth > tipsMaxHintWidth) {
- $(div).html(text).css("top", pos.y + hitinfo.y + tipsIndent).css("left", pos.x + hitinfo.x - tipsIndent - tipsMaxHintWidth);
- } else {
- $(div).html(text).css("top", pos.y + hitinfo.y + tipsIndent).css("left", pos.x + hitinfo.x - tipsIndent - textWidth);
- }
- this._toolTipElement = div;
- $(div).show("fast");
- }
- }
- };
- /**
- * 鼠标移出单元格事件 - 隐藏悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseLeave = function (hitinfo) {
- if (this._toolTipElement) {
- $(this._toolTipElement).hide();
- this._toolTipElement = null;
- }
- };
- return new stackedBarCellType();
- },
- },
- RowHeader: {
- getTagRowHeader: function (setting) {
- const indent = setting.indent || 18, maxHintWidth = 200, borderIndent = 10;
- const height = setting.tagSize ? 11 * setting.tagSize : 11, width = setting.tagSize ? 10 * setting.tagSize : 10;
- const tagFont = setting.tagFont || '9px 微软雅黑';
- const drawTag = function (canvas, x, y, fillColor) {
- canvas.save();
- // 设置偏移量
- canvas.translate(0.5, 0.5);
- canvas.beginPath();
- canvas.moveTo(x, y);
- canvas.lineTo(x, y+height/11*5);
- canvas.lineTo(x+width/10*5.5, y+height);
- canvas.lineTo(x+width, y+height-width/10*4.5);
- canvas.lineTo(x+width/11*5, y);
- canvas.lineTo(x, y);
- canvas.stroke();
- canvas.fillStyle = fillColor instanceof Array ? fillColor[0] : fillColor;
- canvas.fill();
- canvas.beginPath();
- canvas.arc(x+2, y+2, 1, 0, Math.PI*2, true);
- canvas.closePath();
- canvas.fillStyle = 'white';
- canvas.fill();
- if (fillColor instanceof Array && fillColor.length > 1) {
- canvas.fillStyle = '#444444';
- canvas.font = tagFont;
- canvas.fillText(fillColor.length, x+width/11*13, y+height/11*14);
- }
- canvas.restore();
- };
- let TagCellType = function (){};
- TagCellType.prototype = new spreadNS.CellTypes.RowHeader();
- const proto = TagCellType.prototype;
- proto.getTagColor = setting.getColor;
- proto.getTagHtml = setting.getTagHtml;
- proto.basePaint = proto.paint;
- proto.paint = function (canvas, value, x, y, w, h, style, options) {
- spreadNS.CellTypes.RowHeader.prototype.paint.apply(this, [canvas, '', x, y, w , h, style, options]);
- spreadNS.CellTypes.Text.prototype.paint.apply(this, [canvas, value, x, y, w - indent, h, style, options]);
- const node = SpreadJsObj.getRowObject(options.sheet, options.row);
- const color = this.getTagColor(options.row, node);
- const centerX = x + w - indent + height/2, centerY = y + h/2;
- color && drawTag(canvas, centerX - height/2, centerY - width/2, color);
- };
- /**
- * 获取点击信息
- * @param {Number} x
- * @param {Number} y
- * @param {Object} cellStyle
- * @param {Object} cellRect
- * @param {Object} context
- * @returns {{x: *, y: *, row: *, col: *|boolean|*[]|number|{}|UE.dom.dtd.col, cellStyle: *, cellRect: *, sheet: *|StyleSheet, sheetArea: *}}
- */
- proto.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheet: context.sheet,
- sheetArea: context.sheetArea,
- ctx: context.sheet.getParent().xs,
- };
- };
- /**
- * 鼠标进入单元格事件 - 显示悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseEnter = function (hitinfo) {
- const node = SpreadJsObj.getRowObject(hitinfo.sheet, hitinfo.row);
- let html = this.getTagHtml(hitinfo.row, node);
- const pos = SpreadJsObj.getObjPos(hitinfo.sheet.getParent().qo);
- if (pos && html) {
- if (!this._tagTipElement) {
- let div = $('#autoTip')[0];
- if (!div) {
- div = document.createElement("div");
- $(div).css("position", "absolute")
- .css("border", "1px #C0C0C0 solid")
- .css("box-shadow", "1px 2px 5px rgba(0,0,0,0.4)")
- .css("font", "9pt Arial")
- .css("background", "white")
- .css("padding", 5)
- .css("width", maxHintWidth)
- .css("z-index", 999)
- .attr("id", 'autoTagTip')
- .css("top", pos.y + hitinfo.y + indent)
- .css("left", pos.x + hitinfo.x + indent)
- .html(html);
- document.body.insertBefore(div, null);
- }
- this._tagTipElement = div;
- $(div).show("fast");
- }
- }
- };
- /**
- * 鼠标移出单元格事件 - 隐藏悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseLeave = function (hitinfo) {
- if (this._tagTipElement) {
- $(this._tagTipElement).hide().remove();
- this._tagTipElement = null;
- }
- };
- return new TagCellType();
- },
- getCircleTagRowHeader: function (setting) {
- const drawCircle = function (canvas, x, y, r, fillColor) {
- canvas.save();
- canvas.beginPath();
- canvas.arc(x, y, r, 0, Math.PI*2, true);
- canvas.closePath();
- canvas.fillStyle = fillColor;
- canvas.fill();
- canvas.restore();
- };
- const drawCircle2 = function (canvas, x, y, r, lineColor, fillColor) {
- canvas.save();
- canvas.beginPath();
- canvas.arc(x, y, r, 0, Math.PI*2, true);
- canvas.closePath();
- canvas.fillStyle = lineColor;
- canvas.fill();
- canvas.beginPath();
- canvas.arc(x, y, r-2, 0, Math.PI*2, true);
- canvas.closePath();
- canvas.fillStyle = fillColor;
- canvas.fill();
- canvas.restore();
- };
- let CircleTagCellType = function (){};
- CircleTagCellType.prototype = new spreadNS.CellTypes.RowHeader();
- const proto = CircleTagCellType.prototype;
- proto.indent = setting.indent || 16;
- proto.size = setting.size || 6;
- proto.getTagColor = setting.getColor;
- proto.basePaint = proto.paint;
- proto.paint = function (canvas, value, x, y, w, h, style, options) {
- spreadNS.CellTypes.RowHeader.prototype.paint.apply(this, [canvas, '', x, y, w , h, style, options]);
- spreadNS.CellTypes.Text.prototype.paint.apply(this, [canvas, value, x, y, w - this.indent, h, style, options]);
- const node = SpreadJsObj.getRowObject(options.sheet, options.row);
- let backColor = style.backColor;
- if (!backColor) {
- const tag = options.sheet.getTag(options.row, options.col, options.sheetArea);
- if (tag && tag === 'hover') backColor = '#dddfe1';
- if (!backColor) {
- let sel = options.sheet.getSelections();
- sel = sel ? sel[0] : null;
- backColor = (sel && options.row >= sel.row && options.row < sel.row + sel.rowCount ? '#dddfe1' : '#e9ecef');
- }
- }
- let color = this.getTagColor(options.row, node);
- color = color instanceof Array ? color : [color];
- for (let i = color.length - 1; i >= 0; i--) {
- drawCircle2(canvas, x + w - this.indent + 5 + i*5 , y + h/2, this.size, backColor, color[i]);
- }
- };
- /**
- * 获取点击信息
- * @param {Number} x
- * @param {Number} y
- * @param {Object} cellStyle
- * @param {Object} cellRect
- * @param {Object} context
- * @returns {{x: *, y: *, row: *, col: *|boolean|*[]|number|{}|UE.dom.dtd.col, cellStyle: *, cellRect: *, sheet: *|StyleSheet, sheetArea: *}}
- */
- proto.getHitInfo = function (x, y, cellStyle, cellRect, context) {
- return {
- x: x,
- y: y,
- row: context.row,
- col: context.col,
- cellStyle: cellStyle,
- cellRect: cellRect,
- sheet: context.sheet,
- sheetArea: context.sheetArea,
- ctx: context.sheet.getParent().xs,
- };
- };
- /**
- * 鼠标进入单元格事件 - 显示悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseEnter = function (hitinfo) {
- hitinfo.sheet.setTag(hitinfo.row, hitinfo.col, 'hover', hitinfo.sheetArea);
- };
- /**
- * 鼠标移出单元格事件 - 隐藏悬浮提示
- * @param {Object} hitinfo - 见getHitInfo返回值
- */
- proto.processMouseLeave = function (hitinfo) {
- hitinfo.sheet.setTag(hitinfo.row, hitinfo.col, undefined, hitinfo.sheetArea);
- };
- return new CircleTagCellType();
- },
- },
- Formatter: {
- baseNumberFormatter: function () {
- const formatter = function () {};
- formatter.prototype = new GC.Spread.Formatter.FormatterBase();
- const proto = formatter.prototype;
- /**
- * 格式化数字显示方式
- * 用法
- * formatNumber(12345.999,'#,##0.00');
- * formatNumber(12345.999,'#,##0.##');
- * formatNumber(123,'000000');
- * @param num
- * @param pattern
- */
- proto.formatNum = function (num, pattern) {
- var minusStr = num < 0 ? '-' : '';
- var strarr = num ? Math.abs(num).toString().split('.'):['0'];
- var fmtarr = pattern?pattern.split('.'):[''];
- var retstr='';
- // 整数部分
- var str = strarr[0];
- var fmt = fmtarr[0];
- var i = str.length-1;
- var comma = false;
- for(var f=fmt.length-1;f>=0;f--){
- switch(fmt.substr(f,1)){
- case '#':
- if(i>=0 ) retstr = str.substr(i--,1) + retstr;
- break;
- case '0':
- if(i>=0) retstr = str.substr(i--,1) + retstr;
- else retstr = '0' + retstr;
- break;
- case ',':
- comma = true;
- retstr=','+retstr;
- break;
- }
- }
- if(i>=0){
- if(comma){
- var l = str.length;
- for(;i>=0;i--){
- retstr = str.substr(i,1) + retstr;
- if(i>0 && ((l-i)%3)==0) retstr = ',' + retstr;
- }
- }
- else retstr = str.substr(0,i+1) + retstr;
- }
- retstr = retstr+'.';
- // 处理小数部分
- str=strarr.length>1?strarr[1]:'';
- fmt=fmtarr.length>1?fmtarr[1]:'';
- i=0;
- for(var f=0;f<fmt.length;f++){
- switch(fmt.substr(f,1)){
- case '#':
- if(i<str.length) retstr+=str.substr(i++,1);
- break;
- case '0':
- if(i<str.length) retstr+= str.substr(i++,1);
- else retstr+='0';
- break;
- }
- }
- return minusStr + retstr.replace(/^,+/,'').replace(/\.$/,'');
- };
- proto.format = function (obj, formattedData) {
- if (this.pattern) {
- return this.formatNum(obj, this.pattern);
- } else {
- return obj;
- }
- };
- return new formatter();
- },
- _numFormatter: [],
- getNumberFormatter(pattern) {
- let formatter = this._numFormatter.find(function (f) {
- return f.pattern === pattern;
- });
- if (!formatter) {
- formatter = this.baseNumberFormatter();
- formatter.pattern = pattern;
- this._numFormatter.push(formatter);
- }
- return formatter;
- },
- },
- Clipboard: (function () {
- let cText = '', cHtml;
- const setCopyData = function (text, html) {
- cText = text;
- cHtml = html;
- };
- const getPasteData = function () {
- return {text: cText, html: cHtml};
- };
- const clearData = function () {
- cText = '';
- cHtml = undefined;
- };
- const setSheetFilterCopyData = function (sheet) {
- cText = SpreadJsObj.getFilterCopyText(sheet);
- cHtml = SpreadJsObj.getFilterCopyHTML(sheet);
- };
- const getAnalysisPasteText = function () {
- return SpreadJsObj.analysisPasteText(cText);
- };
- const getAnalysisPasteHtml = function () {
- return SpreadJsObj.analysisPasteHtml(cHtml);
- };
- const setSysClipboard = function(text) {
- let textArea = document.createElement("textarea");
- textArea.style.position = 'fixed';
- textArea.style.top = 0;
- textArea.style.left = 0;
- textArea.style.width = '2em';
- textArea.style.height = '2em';
- textArea.style.padding = 0;
- textArea.style.border = 'none';
- textArea.style.outline = 'none';
- textArea.style.boxShadow = 'none';
- textArea.style.background = 'transparent';
- textArea.value = text;
- document.body.appendChild(textArea);
- textArea.select();
- try {
- document.execCommand('copy');
- } catch (err) {
- }
- document.body.removeChild(textArea);
- };
- return {
- setCopyData, getPasteData, clearData,
- setSheetFilterCopyData,
- getAnalysisPasteText, getAnalysisPasteHtml,
- setSysClipboard
- }
- })(),
- };
|