12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081208220832084208520862087208820892090209120922093209420952096209720982099210021012102210321042105210621072108210921102111211221132114211521162117211821192120212121222123212421252126212721282129213021312132213321342135213621372138213921402141214221432144214521462147214821492150215121522153215421552156215721582159216021612162216321642165216621672168216921702171217221732174217521762177217821792180218121822183218421852186218721882189219021912192219321942195219621972198219922002201220222032204220522062207220822092210221122122213221422152216221722182219222022212222222322242225222622272228222922302231223222332234223522362237223822392240224122422243224422452246224722482249225022512252225322542255225622572258225922602261226222632264226522662267226822692270227122722273227422752276227722782279228022812282228322842285228622872288228922902291229222932294229522962297229822992300230123022303230423052306230723082309231023112312231323142315231623172318231923202321232223232324232523262327232823292330233123322333233423352336233723382339234023412342234323442345234623472348234923502351235223532354235523562357235823592360236123622363236423652366236723682369237023712372237323742375237623772378237923802381238223832384238523862387238823892390239123922393239423952396239723982399240024012402240324042405240624072408240924102411241224132414241524162417241824192420242124222423242424252426242724282429243024312432243324342435243624372438243924402441244224432444244524462447244824492450245124522453245424552456245724582459246024612462246324642465246624672468246924702471247224732474247524762477247824792480248124822483248424852486248724882489249024912492249324942495249624972498249925002501250225032504250525062507250825092510251125122513251425152516251725182519252025212522252325242525252625272528252925302531253225332534253525362537253825392540254125422543254425452546254725482549255025512552255325542555255625572558255925602561256225632564256525662567256825692570257125722573257425752576257725782579258025812582258325842585258625872588258925902591259225932594259525962597259825992600260126022603260426052606260726082609261026112612261326142615261626172618261926202621262226232624262526262627262826292630263126322633263426352636263726382639264026412642264326442645264626472648264926502651265226532654265526562657265826592660266126622663266426652666266726682669267026712672267326742675267626772678267926802681268226832684268526862687268826892690269126922693269426952696269726982699270027012702270327042705270627072708270927102711271227132714271527162717271827192720272127222723272427252726272727282729273027312732273327342735273627372738273927402741274227432744274527462747274827492750275127522753275427552756275727582759276027612762276327642765276627672768276927702771277227732774277527762777277827792780278127822783278427852786278727882789279027912792279327942795279627972798279928002801280228032804280528062807280828092810281128122813281428152816281728182819282028212822282328242825282628272828282928302831283228332834283528362837283828392840284128422843284428452846284728482849285028512852285328542855285628572858285928602861286228632864286528662867286828692870287128722873287428752876287728782879288028812882288328842885288628872888288928902891289228932894289528962897289828992900290129022903290429052906290729082909291029112912291329142915291629172918291929202921292229232924292529262927292829292930293129322933293429352936293729382939294029412942294329442945294629472948294929502951295229532954295529562957295829592960296129622963296429652966296729682969297029712972297329742975 |
- <?xml version="1.0" encoding="UTF-8"?>
- <WorkBook xmlVersion="20170720" releaseVersion="10.0.0">
- <TableDataMap>
- <TableData name="ds_buisness_data" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-07-12]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-07-13]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT d.dict_name,d.dict_description,(
- SELECT SUM(r1.update_number) AS update_number
- FROM platform_buisness_data_record r1
- WHERE
- DATE_ADD(DATE_FORMAT(r1.records_time,"%y-%m-%d"),interval 1 day)<='${p_day}'
- AND
- DATE_ADD(DATE_FORMAT(r1.records_time,"%y-%m-%d"),interval 1 day)>='${p_start_day}'
- AND r1.data_name=d.dict_name
- ) AS update_number,(
- SELECT MAX(r1.update_number_all) AS update_number_all
- FROM platform_buisness_data_record r1
- WHERE
- DATE_ADD(DATE_FORMAT(r1.records_time,"%y-%m-%d"),interval 1 day)<='${p_day}'
- AND
- DATE_ADD(DATE_FORMAT(r1.records_time,"%y-%m-%d"),interval 1 day)>='${p_start_day}'
- AND r1.data_name=d.dict_name
- ) AS update_number_all
- FROM sys_dict_misc d
- WHERE d.dict_type_code='INTERVIEW_TYPE_DATA' ORDER BY d.dict_disp_order
- ]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_register_number" class="com.fr.data.impl.DBTableData">
- <Parameters/>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu1.all_number,uu2.vip_number,uu3.enterprise_number,uu4.internal_number,(uu1.all_number-uu2.vip_number-uu3.enterprise_number-uu4.internal_number) as extranal_number FROM(SELECT count(1) as all_number FROM ums_user) uu1,
- (SELECT count(1)as vip_number FROM ums_user WHERE user_usertype = "会员用户") uu2 ,
- (SELECT count(1)as enterprise_number FROM ums_user WHERE user_usertype = "企业注册用户") uu3 ,
- (SELECT count(1)as internal_number FROM ums_user WHERE user_email LIKE "%@geidco.org") uu4
- ]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_register_number_month" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-05-22]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-05-26]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu1.all_number,uu2.vip_number,uu3.enterprise_number,uu4.internal_number,(uu1.all_number-uu2.vip_number-uu3.enterprise_number-uu4.internal_number) as extranal_number FROM
- (SELECT count(1) as all_number FROM ums_user WHERE create_date >='${p_start_day}' AND create_date <='${p_day}') uu1,
- (SELECT count(1)as vip_number FROM ums_user WHERE user_usertype = "会员用户" AND create_date >='${p_start_day}' AND create_date <='${p_day}' ) uu2 ,
- (SELECT count(1)as enterprise_number FROM ums_user WHERE user_usertype = "企业注册用户" AND create_date >='${p_start_day}' AND create_date <='${p_day}' ) uu3 ,
- (SELECT count(1)as internal_number FROM ums_user WHERE user_email LIKE "%@geidco.org" AND create_date >='${p_start_day}' AND create_date <='${p_day}') uu4 ]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_vip" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-05-03]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-05-04]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu1.vip_number,uu2.vip_login_number,(uu1.vip_number - uu2.vip_login_number)as vip_nologin_number ,uu3.vip_new_login_number FROM (
- SELECT COUNT(1) as vip_number FROM ums_user where user_usertype = "会员用户") uu1,
- (SELECT COUNT(1) as vip_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "会员用户" GROUP BY uu.id ) p) uu2,
- (SELECT COUNT(1) as vip_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "会员用户" AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_external" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-05-03]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-10-03]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu1.external_number,uu2.external_login_number,(uu1.external_number - uu2.external_login_number)as internal_nologin_number ,uu3.external_new_login_number FROM (
- SELECT COUNT(1) as external_number FROM ums_user where (user_email not like "%@geidco.org%" or isnull(user_email)) AND user_usertype != "会员用户" and user_usertype != "企业注册用户") uu1,
- (SELECT COUNT(1) as external_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and (uu.user_email not like "%@geidco.org%" or isnull(uu.user_email)) AND uu.user_usertype != "会员用户" and uu.user_usertype != "企业注册用户" GROUP BY uu.id ) p) uu2,
- (SELECT COUNT(1) as external_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and (uu.user_email not like "%@geidco.org%" or isnull(uu.user_email)) AND uu.user_usertype != "会员用户" and uu.user_usertype != "企业注册用户"AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3
- ]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_enterprise" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-10-01]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-10-03]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu1.enterprise_number,uu2.enterprise_login_number,(uu1.enterprise_number - uu2.enterprise_login_number)as enterprise_nologin_number ,uu3.enterprise_new_login_number FROM (
- SELECT COUNT(1) as enterprise_number FROM ums_user where user_usertype = "企业注册用户") uu1,
- (SELECT COUNT(1) as enterprise_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "企业注册用户" GROUP BY uu.id ) p) uu2,
- (SELECT COUNT(1) as enterprise_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "企业注册用户" AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3
- ]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_internal" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-10-10]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-10-11]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu1.internal_number,uu2.internal_login_number,(uu1.internal_number - uu2.internal_login_number)as internal_nologin_number ,uu3.internal_new_login_number FROM (
- SELECT COUNT(1) as internal_number FROM ums_user where user_email LIKE "%@geidco.org") uu1,
- (SELECT COUNT(1) as internal_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email LIKE "%@geidco.org" GROUP BY uu.id ) p) uu2,
- (SELECT COUNT(1) as internal_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email LIKE "%@geidco.org" AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_interview" class="com.fr.data.impl.DBTableData">
- <Parameters/>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT COUNT(1) AS '当日总访问次数' FROM sys_log
- WHERE (
- request_uri LIKE '/baseProjectViews%'
- OR request_uri LIKE '/baseCountryViews%'
- OR request_uri LIKE '/baseUnitViews%'
- OR request_uri LIKE '/baseMemberInfos%'
- OR request_uri LIKE '/committeeInformationReleaseManagementInfos%'
- OR request_uri LIKE '/baseResearchResultViews%'
- OR request_uri LIKE '/cmsInformationViews%'
- OR request_uri LIKE '/meetingBasicInfos%'
- OR request_uri LIKE '/activityInfos%'
- OR request_uri LIKE '/baseFinancialInstit%'
- OR request_uri LIKE '/baseThinkTankInfos%'
- )]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_business" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-05-13]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT data_name,update_number_all from platform_buisness_data_record WHERE records_time = '${p_day}']]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_chart" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-05-13]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-05-14]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT "会员用户" AS user_usertype ,uu1.vip_number AS all_number,uu2.vip_login_number AS login_number,(uu1.vip_number - uu2.vip_login_number)as nologin_number ,uu3.vip_new_login_number AS new_login_number FROM (
- SELECT COUNT(1) as vip_number FROM ums_user where user_usertype = "会员用户") uu1,
- (SELECT COUNT(1) as vip_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "会员用户" GROUP BY uu.id ) p) uu2,
- (SELECT COUNT(1) as vip_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "会员用户" AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3
- UNION ALL
- SELECT "外部用户" AS user_usertype ,uu1.external_number AS all_number ,uu2.external_login_number AS login_number,(uu1.external_number - uu2.external_login_number)as nologin_number ,uu3.external_new_login_number AS new_login_number FROM (
- SELECT COUNT(1) as external_number FROM ums_user where user_email NOT LIKE "%@geidco.org" AND user_usertype != "会员用户" and user_usertype != "企业注册用户") uu1,
- (SELECT COUNT(1) as external_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email NOT LIKE "%@geidco.org" AND uu.user_usertype != "会员用户" and uu.user_usertype != "企业注册用户" GROUP BY uu.id ) p) uu2,
- (SELECT COUNT(1) as external_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email LIKE "%@geidco.org" AND uu.user_usertype != "会员用户" and uu.user_usertype != "企业注册用户"AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3
- UNION ALL
- SELECT "企业注册用户" AS user_usertype , uu1.enterprise_number AS all_number,uu2.enterprise_login_number AS login_number,(uu1.enterprise_number - uu2.enterprise_login_number)as nologin_number ,uu3.enterprise_new_login_number as new_login_number FROM (
- SELECT COUNT(1) as enterprise_number FROM ums_user where user_usertype = "企业注册用户") uu1,
- (SELECT COUNT(1) as enterprise_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "企业注册用户" GROUP BY uu.id ) p) uu2,
- (SELECT COUNT(1) as enterprise_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu.user_usertype = "企业注册用户" AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3
- UNION ALL
- SELECT "内部用户"AS user_usertype,uu1.internal_number AS all_number ,uu2.internal_login_number AS login_number,(uu1.internal_number - uu2.internal_login_number)as nologin_number ,uu3.internal_new_login_number AS new_login_number FROM (
- SELECT COUNT(1) as internal_number FROM ums_user where user_email LIKE "%@geidco.org") uu1,
- (SELECT COUNT(1) as internal_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email LIKE "%@geidco.org" GROUP BY uu.id ) p) uu2,
- (SELECT COUNT(1) as internal_new_login_number FROM (SELECT uu.id,uu.user_email,uu.user_usertype FROM sys_log sl,ums_user uu WHERE sl.create_by = uu.id and uu. user_email LIKE "%@geidco.org" AND sl.create_date >='${p_start_day}' AND sl.create_date <='${p_day}' GROUP BY uu.id ) p) uu3]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_business2" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-06-24]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-06-26]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT data_name,SUM(update_number) AS update_number from platform_buisness_data_record WHERE records_time >= '${p_start_day}'and records_time <= '${p_day}' GROUP BY data_name]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_business_total" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-06-23]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT SUM(update_number_all) AS update_number_all from platform_buisness_data_record WHERE records_time = '${p_day}' ]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_business2_total" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-08-24]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-08-26]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT SUM(update_number) AS update_number from platform_buisness_data_record WHERE records_time >= '${p_start_day}'and records_time <= '${p_day}']]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_vip_data" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-07-12]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu.user_uid,uu.user_usertype
- ,(SELECT MAX(bue.unit_name) FROM base_unit_entity bue ,unit_ums_user uuu WHERE uuu.ums_id=uu.id AND bue.id = uuu.unit_id ) AS unit_name
- ,(SELECT MAX(bue.are) FROM base_unit_entity bue,unit_ums_user uuu WHERE bue.id = uuu.unit_id and uu.id = uuu.ums_id) AS are
- ,MAX(DATE_FORMAT(sl.create_date,'%Y-%m-%d')) AS login_date,COUNT(DISTINCT DATE_FORMAT(sl.create_date,'%Y-%m-%d')) AS logincount
- FROM
- sys_log sl,ums_user uu
- WHERE
- sl.create_by = uu.id
- AND uu.user_usertype = "会员用户"
- and sl.create_date<='${p_day}'
- and sl.create_date>='2021-03-23'
- GROUP BY uu.id,uu.user_uid,uu.user_email,uu.user_preferred_mobile
- ORDER BY logincount DESC;]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_external_data" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-10-14]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu.user_uid,uu.user_email,uu.user_preferred_mobile
- ,MAX(DATE_FORMAT(sl.create_date,'%Y-%m-%d')) AS login_date,COUNT(DISTINCT DATE_FORMAT(sl.create_date,'%Y-%m-%d')) AS logincount
- ,IF(uu.id in (SELECT id FROM ums_user WHERE user_usertype != "会员用户"
- AND user_usertype !="企业注册用户"
- and (user_email not like "%@geidco.org%" or isnull(user_email))
- AND create_date <='${p_day}'
- AND create_date>='{p_start_day}'
- ),"新增","") AS new_insert
- FROM
- sys_log sl,ums_user uu
- WHERE
- sl.create_by = uu.id
- AND uu.user_usertype != "会员用户"
- AND uu.user_usertype !="企业注册用户"
- and (uu.user_email not like "%@geidco.org%" or isnull(uu.user_email))
- and sl.create_date<='${p_day}'
- and sl.create_date>='2021-03-23'
- GROUP BY uu.id,uu.user_uid,uu.user_email,uu.user_preferred_mobile
- ORDER BY logincount DESC;]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_enterprise_data" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-10-13]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu.user_uid,uu.user_usertype
- ,(SELECT MAX(bue.unit_name) FROM base_unit_entity bue ,unit_ums_user uuu WHERE uuu.ums_id=uu.id AND bue.id = uuu.unit_id ) AS unit_name
- ,(SELECT MAX(bue.are) FROM base_unit_entity bue,unit_ums_user uuu WHERE bue.id = uuu.unit_id and uu.id = uuu.ums_id) AS are
- ,MAX(DATE_FORMAT(sl.create_date,'%Y-%m-%d')) AS login_date,COUNT(DISTINCT DATE_FORMAT(sl.create_date,'%Y-%m-%d')) AS logincount
- FROM
- sys_log sl,ums_user uu
- WHERE
- sl.create_by = uu.id
- AND uu.user_usertype = "企业注册用户"
- and sl.create_date<='${p_day}'
- and sl.create_date>='2021-03-23'
- GROUP BY uu.id,uu.user_uid,uu.user_email,uu.user_preferred_mobile
- ORDER BY logincount DESC;]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_internal_data" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-10-13]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT uu.user_uid,uu.user_email,uue.extend_3
- ,MAX(DATE_FORMAT(sl.create_date,'%Y-%m-%d')) AS login_date,COUNT(DISTINCT DATE_FORMAT(sl.create_date,'%Y-%m-%d')) AS logincount
- FROM
- sys_log sl,ums_user uu
- LEFT JOIN ums_user_extend uue on uue.id = uu.id
- WHERE
- sl.create_by = uu.id
- AND uu.user_email like "%geidco.org"
- and sl.create_date<='${p_day}'
- and sl.create_date>='2021-03-23'
- GROUP BY uu.id,uu.user_uid,uu.user_email,uu.user_preferred_mobile
- ORDER BY logincount DESC;
- ]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- <TableData name="ds_login_number" class="com.fr.data.impl.DBTableData">
- <Parameters>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-01-12]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-01-13]]></O>
- </Parameter>
- </Parameters>
- <Attributes maxMemRowCount="-1"/>
- <Connection class="com.fr.data.impl.NameDatabaseConnection">
- <DatabaseName>
- <![CDATA[dcp]]></DatabaseName>
- </Connection>
- <Query>
- <![CDATA[SELECT s1.all_interview_login_number,s2.all_interview_number,(s2.all_interview_number-s1.all_interview_login_number)AS all_nologin_number, s3.month_interview_login_number,s4.month_interview_number,(s4.month_interview_number -s3.month_interview_login_number) AS month_nologin_number FROM (SELECT COUNT(1) AS all_interview_login_number FROM sys_log
- WHERE (
- request_uri LIKE '/baseProjectViews%'
- OR request_uri LIKE '/baseCountryViews%'
- OR request_uri LIKE '/baseUnitViews%'
- OR request_uri LIKE '/baseMemberInfos%'
- OR request_uri LIKE '/committeeInformationReleaseManagementInfos%'
- OR request_uri LIKE '/baseResearchResultViews%'
- OR request_uri LIKE '/cmsInformationViews%'
- OR request_uri LIKE '/meetingBasicInfos%'
- OR request_uri LIKE '/activityInfos%'
- OR request_uri LIKE '/baseFinancialInstit%'
- OR request_uri LIKE '/baseThinkTankInfos%'
- ) AND create_by != '0') s1,
- (SELECT COUNT(1) AS all_interview_number FROM sys_log
- WHERE (
- request_uri LIKE '/baseProjectViews%'
- OR request_uri LIKE '/baseCountryViews%'
- OR request_uri LIKE '/baseUnitViews%'
- OR request_uri LIKE '/baseMemberInfos%'
- OR request_uri LIKE '/committeeInformationReleaseManagementInfos%'
- OR request_uri LIKE '/baseResearchResultViews%'
- OR request_uri LIKE '/cmsInformationViews%'
- OR request_uri LIKE '/meetingBasicInfos%'
- OR request_uri LIKE '/activityInfos%'
- OR request_uri LIKE '/baseFinancialInstit%'
- OR request_uri LIKE '/baseThinkTankInfos%'
- ) ) s2,
- (SELECT COUNT(1) AS month_interview_login_number FROM sys_log
- WHERE (
- request_uri LIKE '/baseProjectViews%'
- OR request_uri LIKE '/baseCountryViews%'
- OR request_uri LIKE '/baseUnitViews%'
- OR request_uri LIKE '/baseMemberInfos%'
- OR request_uri LIKE '/committeeInformationReleaseManagementInfos%'
- OR request_uri LIKE '/baseResearchResultViews%'
- OR request_uri LIKE '/cmsInformationViews%'
- OR request_uri LIKE '/meetingBasicInfos%'
- OR request_uri LIKE '/activityInfos%'
- OR request_uri LIKE '/baseFinancialInstit%'
- OR request_uri LIKE '/baseThinkTankInfos%'
- ) AND create_by != '0' AND create_date >='${p_start_day}'AND create_date <='${p_day}')s3,
- (SELECT COUNT(1) AS month_interview_number FROM sys_log
- WHERE (
- request_uri LIKE '/baseProjectViews%'
- OR request_uri LIKE '/baseCountryViews%'
- OR request_uri LIKE '/baseUnitViews%'
- OR request_uri LIKE '/baseMemberInfos%'
- OR request_uri LIKE '/committeeInformationReleaseManagementInfos%'
- OR request_uri LIKE '/baseResearchResultViews%'
- OR request_uri LIKE '/cmsInformationViews%'
- OR request_uri LIKE '/meetingBasicInfos%'
- OR request_uri LIKE '/activityInfos%'
- OR request_uri LIKE '/baseFinancialInstit%'
- OR request_uri LIKE '/baseThinkTankInfos%'
- ) AND create_date >='${p_start_day}'AND create_date <='${p_day}')s4
- ]]></Query>
- <PageQuery>
- <![CDATA[]]></PageQuery>
- </TableData>
- </TableDataMap>
- <ReportExportAttr>
- <ExcelExportAttr hideColumn="false" hideRow="false"/>
- <PDFExportAttr/>
- <HTMLExportAttr/>
- <WordExportAttr WordTable="true"/>
- <ImageExportAttr imageResolution="200" imageType="false"/>
- </ReportExportAttr>
- <ElementCaseMobileAttr>
- <ElementCaseMobileAttrProvider horizontal="1" vertical="1" zoom="true" refresh="false" isUseHTML="false" isMobileCanvasSize="false" appearRefresh="false" allowFullScreen="false" allowDoubleClickOrZoom="true" functionalWhenUnactivated="false"/>
- </ElementCaseMobileAttr>
- <Report class="com.fr.report.worksheet.WorkSheet" name="sheet1">
- <ReportPageAttr>
- <HR/>
- <FR/>
- <HC/>
- <FC/>
- </ReportPageAttr>
- <ColumnPrivilegeControl/>
- <RowPrivilegeControl/>
- <RowHeight defaultValue="723900">
- <![CDATA[5029200,1638300,1411200,2286000,2160000,2160000,2095500,1676400,1714500,13258800,1485900,723900,1600200,1600200,4381500,1714500,1714500,1638300,1638300,1676400,1638300,1600200,1676400,1676400,1638300,1676400,3048000,1676400,1714500,2286000,1872000,1872000,3048000,1562100,1714500,2286000,1562100,1714500,3048000,1676400,1714500,2286000,2016000,1714500,3048000,1676400,1714500,2286000,2286000,1714500,1714500,3048000,1676400,723900,723900,723900,723900,723900,723900,723900,1714500,3048000,2016000,1872000,1872000,723900]]></RowHeight>
- <ColumnWidth defaultValue="2743200">
- <![CDATA[1930400,0,2286000,2880000,2160000,2160000,2160000,2160000,6248400,0,2743200]]></ColumnWidth>
- <CellElementList>
- <C c="0" r="0" cs="9" s="0">
- <O>
- <![CDATA[关于发展合作平台运行情况的汇报]]></O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <CellInsertPolicy/>
- <Expand/>
- </C>
- <C c="0" r="1" cs="9" s="1">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[="<font> 截至</font>" + YEAR($p_day) + "年" + MONTH($p_day) + "月" + DAY($p_day) + "日,对发展合作平台用户注册、登录、访问、内容更新、APP下载情况进行了统计分析,有关情况汇报如下:"]]></Attributes>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="0" r="2" cs="9" s="2">
- <O>
- <![CDATA[ 一、用户注册登录]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="3" cs="9" s="1">
- <O t="DSColumn">
- <Attributes dsName="ds_register_number" columnName="all_number"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA["<font style='font-weight:bold'> 平台累计注册用户</font>"+all_number+"个,包括会员用户"+vip_number+"个、外部用户"+extranal_number+"个、企业用户"+enterprise_number+"个与内部用户"+inter_number+"个。"]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="0" r="4" cs="9" s="1">
- <O t="DSColumn">
- <Attributes dsName="ds_register_number_month" columnName="all_number"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[if(vip_number >0,"本月新增会员用户"+vip_number+"个,","")+if(extranal_number>0,"本月新增外部用户"+extranal_number+"个,","")+if(inter_number>0,"本月新增内部用户"+inter_number+"个,","")+if(enterprise_number>0,"本月新增企业用户"+enterprise_number+"个,","")+"各类用户登录情况统计图1所示,其中:"]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <CellInsertPolicy/>
- <Expand dir="0"/>
- </C>
- <C c="0" r="5" cs="9" s="1">
- <O t="DSColumn">
- <Attributes dsName="ds_vip" columnName="vip_number"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA["<font style='font-weight:bold'> 1.会员用户。</font>"+"共计"+vip_number+"个,其中登录平台"+vip_login_number+"个,未登录平台"+vip_nologin_number+"个。登陆率为"+FORMAT(vip_login_number/vip_number,"0.00%")+"。"+if(vip_new_login_number>0,"<font style='font-weight:bold'>本月新增登录用户</font>"+vip_new_login_number+"个。","<font style='font-weight:bold'>本月无新增登录用户</font>")+"登录情况详见附件1。"]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="0" r="6" cs="9" s="1">
- <O t="DSColumn">
- <Attributes dsName="ds_external" columnName="external_number"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA["<font style='font-weight:bold'> 2.外部用户。</font>"+"共计"+external_number+"个,其中登录平台"+external_login_number+"个,未登录平台"+internal_nologin_number+"个。登陆率为"+FORMAT(external_login_number/external_number,"0.00%")+"。"+if(external_new_login_number>0,"<font style='font-weight:bold'>本月新增登录用户</font>"+external_new_login_number+"个。","<font style='font-weight:bold'>本月无新增登录用户</font>")+"登录情况详见附件2。"]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="0" r="7" cs="9" s="1">
- <O t="DSColumn">
- <Attributes dsName="ds_enterprise" columnName="enterprise_number"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA["<font style='font-weight:bold'> 2.外部用户。</font>"+"共计"+enterprise_number+"个,其中登录平台"+enterprise_login_number+"个,未登录平台"+enterprise_nologin_number+"个。登陆率为"+FORMAT(enterprise_login_number/enterprise_number,"0.00%")+"。"+if(enterprise_new_login_number>0,"<font style='font-weight:bold'>本月新增登录用户</font>"+enterprise_new_login_number+"个。","<font style='font-weight:bold'>本月无新增登录用户</font>")+"登录情况详见附件3。"]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="0" r="8" cs="9" s="1">
- <O t="DSColumn">
- <Attributes dsName="ds_internal" columnName="internal_number"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA["<font style='font-weight:bold'> 4.内部用户。</font>"+"共计"+internal_number+"个,其中登录平台"+internal_login_number+"个,未登录平台"+internal_nologin_number+"个。登陆率为"+FORMAT(internal_login_number/internal_number,"0.00%")+"。"+if(internal_new_login_number>0,"<font style='font-weight:bold'>本月新增登录用户</font>"+internal_new_login_number+"个。","<font style='font-weight:bold'>本月无新增登录用户</font>")+"登录情况详见附件3。"]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="0" r="9" cs="9" s="3">
- <O t="CC">
- <LayoutAttr selectedIndex="0"/>
- <ChangeAttr enable="false" changeType="button" timeInterval="5" buttonColor="-6710887" carouselColor="-8421505" showArrow="true">
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="PingFangSC-Regular" style="0" size="96" foreground="-1"/>
- </Attr>
- </TextAttr>
- </ChangeAttr>
- <Chart name="默认" chartClass="com.fr.plugin.chart.vanchart.VanChart">
- <Chart class="com.fr.plugin.chart.vanchart.VanChart">
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="1" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-1118482" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <ChartAttr isJSDraw="true" isStyleGlobal="false"/>
- <Title4VanChart>
- <Title>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-6908266" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <O>
- <![CDATA[新建图表标题]]></O>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="微软雅黑" style="0" size="128" foreground="-13421773"/>
- </Attr>
- </TextAttr>
- <TitleVisible value="false" position="0"/>
- </Title>
- <Attr4VanChart useHtml="false" floating="false" x="0.0" y="0.0" limitSize="false" maxHeight="15.0"/>
- </Title4VanChart>
- <Plot class="com.fr.plugin.chart.custom.VanChartCustomPlot">
- <VanChartPlotVersion version="20170715"/>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <Attr isNullValueBreak="true" autoRefreshPerSecond="6" seriesDragEnable="false" plotStyle="0" combinedSize="50.0"/>
- <newHotTooltipStyle>
- <AttrContents>
- <Attr showLine="false" position="1" isWhiteBackground="true" isShowMutiSeries="false" seriesLabel="${VALUE}"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##]]></Format>
- <PercentFormat>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#0.##%]]></Format>
- </PercentFormat>
- </AttrContents>
- </newHotTooltipStyle>
- <ConditionCollection>
- <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
- <ConditionAttr name=""/>
- </DefaultAttr>
- </ConditionCollection>
- <Legend4VanChart>
- <Legend>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-3355444" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <Attr position="3" visible="true" predefinedStyle="false"/>
- <FRFont name="微软雅黑" style="0" size="88" foreground="-10066330"/>
- </Legend>
- <Attr4VanChart floating="false" x="0.0" y="0.0" layout="aligned" customSize="true" maxHeight="100.0" isHighlight="true"/>
- </Legend4VanChart>
- <DataSheet>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="1" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <Attr isVisible="false" predefinedStyle="false"/>
- <FRFont name="SimSun" style="0" size="72"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##]]></Format>
- </DataSheet>
- <DataProcessor class="com.fr.base.chart.chartdata.model.NormalDataModel"/>
- <newPlotFillStyle>
- <AttrFillStyle>
- <AFStyle colorStyle="1"/>
- <FillStyleName fillStyleName=""/>
- <isCustomFillStyle isCustomFillStyle="true"/>
- <PredefinedStyle predefinedStyle="false"/>
- <ColorList>
- <OColor colvalue="-9654529"/>
- <OColor colvalue="-26368"/>
- <OColor colvalue="-39373"/>
- <OColor colvalue="-16750485"/>
- <OColor colvalue="-3658447"/>
- <OColor colvalue="-10331231"/>
- <OColor colvalue="-7763575"/>
- <OColor colvalue="-6514688"/>
- <OColor colvalue="-16744620"/>
- <OColor colvalue="-6187579"/>
- <OColor colvalue="-15714713"/>
- <OColor colvalue="-945550"/>
- <OColor colvalue="-4092928"/>
- <OColor colvalue="-13224394"/>
- <OColor colvalue="-12423245"/>
- <OColor colvalue="-10043521"/>
- <OColor colvalue="-406154"/>
- <OColor colvalue="-13031292"/>
- <OColor colvalue="-16732559"/>
- <OColor colvalue="-7099690"/>
- <OColor colvalue="-11991199"/>
- <OColor colvalue="-331445"/>
- <OColor colvalue="-6991099"/>
- <OColor colvalue="-16686527"/>
- <OColor colvalue="-9205567"/>
- <OColor colvalue="-7397856"/>
- <OColor colvalue="-406154"/>
- <OColor colvalue="-2712831"/>
- <OColor colvalue="-4737097"/>
- <OColor colvalue="-11460720"/>
- <OColor colvalue="-6696775"/>
- <OColor colvalue="-3685632"/>
- </ColorList>
- </AttrFillStyle>
- </newPlotFillStyle>
- <VanChartPlotAttr isAxisRotation="false" categoryNum="1"/>
- <GradientStyle>
- <Attr gradientType="normal" startColor="-12146441" endColor="-9378161"/>
- </GradientStyle>
- <VanChartRectanglePlotAttr vanChartPlotType="normal" isDefaultIntervalBackground="true"/>
- <XAxisList>
- <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartAxis">
- <Title>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <O>
- <![CDATA[]]></O>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <TitleVisible value="true" position="0"/>
- </Title>
- <newAxisAttr isShowAxisLabel="true"/>
- <AxisLineStyle AxisStyle="1" MainGridStyle="1"/>
- <newLineColor mainGridPredefinedStyle="false" lineColor="-5197648" predefinedStyle="false"/>
- <AxisPosition value="3"/>
- <TickLine201106 type="2" secType="0"/>
- <ArrowShow arrowShow="false"/>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="64" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <AxisLabelCount value="=1"/>
- <AxisRange/>
- <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
- <ZoomAxisAttr isZoom="false"/>
- <axisReversed axisReversed="false"/>
- <VanChartAxisAttr mainTickLine="2" secTickLine="0" axisName="X轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="solid"/>
- <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
- <alertList/>
- <customBackgroundList/>
- </VanChartAxis>
- </XAxisList>
- <YAxisList>
- <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartValueAxis">
- <Title>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <O>
- <![CDATA[]]></O>
- <TextAttr>
- <Attr rotation="-90" alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <TitleVisible value="true" position="0"/>
- </Title>
- <newAxisAttr isShowAxisLabel="true"/>
- <AxisLineStyle AxisStyle="0" MainGridStyle="1"/>
- <newLineColor mainGridColor="-3881788" mainGridPredefinedStyle="false" lineColor="-5197648" predefinedStyle="false"/>
- <AxisPosition value="2"/>
- <TickLine201106 type="2" secType="0"/>
- <ArrowShow arrowShow="false"/>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="72" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <AxisLabelCount value="=1"/>
- <AxisRange minValue="=0"/>
- <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
- <ZoomAxisAttr isZoom="false"/>
- <axisReversed axisReversed="false"/>
- <VanChartAxisAttr mainTickLine="0" secTickLine="0" axisName="Y轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="solid"/>
- <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
- <alertList/>
- <customBackgroundList/>
- <VanChartValueAxisAttr isLog="false" valueStyle="false" baseLog="=10"/>
- <ds>
- <RadarYAxisTableDefinition>
- <Top topCate="-1" topValue="-1" isDiscardOtherCate="false" isDiscardOtherSeries="false" isDiscardNullCate="false" isDiscardNullSeries="false"/>
- <attr/>
- </RadarYAxisTableDefinition>
- </ds>
- </VanChartAxis>
- </YAxisList>
- <stackAndAxisCondition>
- <ConditionCollection>
- <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
- <ConditionAttr name=""/>
- </DefaultAttr>
- </ConditionCollection>
- </stackAndAxisCondition>
- <VanChartCustomPlotAttr customStyle="column_line"/>
- <CustomPlotList>
- <VanChartPlot class="com.fr.plugin.chart.column.VanChartColumnPlot">
- <VanChartPlotVersion version="20170715"/>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <Attr isNullValueBreak="true" autoRefreshPerSecond="6" seriesDragEnable="false" plotStyle="0" combinedSize="50.0"/>
- <newHotTooltipStyle>
- <AttrContents>
- <Attr showLine="false" position="1" isWhiteBackground="true" isShowMutiSeries="false" seriesLabel="${VALUE}"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##]]></Format>
- <PercentFormat>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#0.##%]]></Format>
- </PercentFormat>
- </AttrContents>
- </newHotTooltipStyle>
- <ConditionCollection>
- <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
- <ConditionAttr name="">
- <AttrList>
- <Attr class="com.fr.plugin.chart.base.AttrTooltip">
- <AttrTooltip>
- <Attr enable="true" duration="4" followMouse="false" showMutiSeries="true" isCustom="false"/>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="SimSun" style="0" size="72"/>
- </Attr>
- </TextAttr>
- <AttrToolTipContent>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="SimSun" style="0" size="72"/>
- </Attr>
- </TextAttr>
- <richText class="com.fr.plugin.chart.base.AttrTooltipRichText">
- <AttrTooltipRichText>
- <Attr content="" isAuto="true" initParamsContent=""/>
- <params>
- <![CDATA[{}]]></params>
- </AttrTooltipRichText>
- </richText>
- <richTextValue class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
- <AttrTooltipValueFormat>
- <Attr enable="true"/>
- </AttrTooltipValueFormat>
- </richTextValue>
- <richTextPercent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
- <AttrTooltipPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipPercentFormat>
- </richTextPercent>
- <richTextCategory class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
- <AttrToolTipCategoryFormat>
- <Attr enable="true"/>
- </AttrToolTipCategoryFormat>
- </richTextCategory>
- <richTextSeries class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
- <AttrTooltipSeriesFormat>
- <Attr enable="true"/>
- </AttrTooltipSeriesFormat>
- </richTextSeries>
- <richTextChangedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
- <AttrTooltipChangedPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipChangedPercentFormat>
- </richTextChangedPercent>
- <richTextChangedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
- <AttrTooltipChangedValueFormat>
- <Attr enable="false"/>
- </AttrTooltipChangedValueFormat>
- </richTextChangedValue>
- <TableFieldCollection/>
- <Attr isCommon="true" isCustom="false" isRichText="false" richTextAlign="left" showAllSeries="false"/>
- <value class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
- <AttrTooltipValueFormat>
- <Attr enable="true"/>
- </AttrTooltipValueFormat>
- </value>
- <percent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
- <AttrTooltipPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipPercentFormat>
- </percent>
- <category class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
- <AttrToolTipCategoryFormat>
- <Attr enable="true"/>
- </AttrToolTipCategoryFormat>
- </category>
- <series class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
- <AttrTooltipSeriesFormat>
- <Attr enable="true"/>
- </AttrTooltipSeriesFormat>
- </series>
- <changedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
- <AttrTooltipChangedPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipChangedPercentFormat>
- </changedPercent>
- <changedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
- <AttrTooltipChangedValueFormat>
- <Attr enable="false"/>
- </AttrTooltipChangedValueFormat>
- </changedValue>
- <HtmlLabel customText="" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
- </AttrToolTipContent>
- <GI>
- <AttrBackground>
- <Background name="ColorBackground" color="-16777216"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="true" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="2"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="0.5"/>
- </AttrAlpha>
- </GI>
- </AttrTooltip>
- </Attr>
- <Attr class="com.fr.chart.base.AttrBorder">
- <AttrBorder>
- <Attr lineStyle="1" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-1" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- </Attr>
- <Attr class="com.fr.chart.base.AttrAlpha">
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </Attr>
- </AttrList>
- </ConditionAttr>
- </DefaultAttr>
- </ConditionCollection>
- <Legend4VanChart>
- <Legend>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-3355444" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <Attr position="4" visible="true" predefinedStyle="false"/>
- <FRFont name="Microsoft YaHei" style="0" size="88" foreground="-10066330"/>
- </Legend>
- <Attr4VanChart floating="false" x="0.0" y="0.0" layout="aligned" customSize="true" maxHeight="100.0" isHighlight="true"/>
- </Legend4VanChart>
- <DataSheet>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="1" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <Attr isVisible="false" predefinedStyle="false"/>
- <FRFont name="SimSun" style="0" size="72"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##]]></Format>
- </DataSheet>
- <DataProcessor class="com.fr.base.chart.chartdata.model.NormalDataModel"/>
- <newPlotFillStyle>
- <AttrFillStyle>
- <AFStyle colorStyle="1"/>
- <FillStyleName fillStyleName="新特性"/>
- <isCustomFillStyle isCustomFillStyle="false"/>
- <PredefinedStyle predefinedStyle="false"/>
- <ColorList>
- <OColor colvalue="-10243346"/>
- <OColor colvalue="-8988015"/>
- <OColor colvalue="-472193"/>
- <OColor colvalue="-486008"/>
- <OColor colvalue="-8595761"/>
- <OColor colvalue="-7236949"/>
- <OColor colvalue="-8873759"/>
- <OColor colvalue="-1071514"/>
- <OColor colvalue="-1188474"/>
- <OColor colvalue="-6715442"/>
- <OColor colvalue="-10243346"/>
- <OColor colvalue="-8988015"/>
- <OColor colvalue="-472193"/>
- <OColor colvalue="-486008"/>
- <OColor colvalue="-8595761"/>
- <OColor colvalue="-7236949"/>
- <OColor colvalue="-8873759"/>
- <OColor colvalue="-1071514"/>
- <OColor colvalue="-1188474"/>
- <OColor colvalue="-6715442"/>
- <OColor colvalue="-10243346"/>
- <OColor colvalue="-8988015"/>
- <OColor colvalue="-472193"/>
- <OColor colvalue="-486008"/>
- <OColor colvalue="-8595761"/>
- <OColor colvalue="-7236949"/>
- <OColor colvalue="-8873759"/>
- <OColor colvalue="-1071514"/>
- <OColor colvalue="-1188474"/>
- <OColor colvalue="-6715442"/>
- <OColor colvalue="-10243346"/>
- <OColor colvalue="-8988015"/>
- </ColorList>
- </AttrFillStyle>
- </newPlotFillStyle>
- <VanChartPlotAttr isAxisRotation="false" categoryNum="1"/>
- <GradientStyle>
- <Attr gradientType="normal" startColor="-12146441" endColor="-9378161"/>
- </GradientStyle>
- <VanChartRectanglePlotAttr vanChartPlotType="custom" isDefaultIntervalBackground="true"/>
- <XAxisList>
- <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartAxis">
- <Title>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <O>
- <![CDATA[]]></O>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <TitleVisible value="true" position="0"/>
- </Title>
- <newAxisAttr isShowAxisLabel="true"/>
- <AxisLineStyle AxisStyle="1" MainGridStyle="1"/>
- <newLineColor mainGridPredefinedStyle="false" lineColor="-5197648" predefinedStyle="false"/>
- <AxisPosition value="3"/>
- <TickLine201106 type="2" secType="0"/>
- <ArrowShow arrowShow="false"/>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="64" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <AxisLabelCount value="=1"/>
- <AxisRange/>
- <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
- <ZoomAxisAttr isZoom="false"/>
- <axisReversed axisReversed="false"/>
- <VanChartAxisAttr mainTickLine="2" secTickLine="0" axisName="X轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="solid"/>
- <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
- <alertList/>
- <customBackgroundList/>
- </VanChartAxis>
- </XAxisList>
- <YAxisList>
- <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartValueAxis">
- <Title>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <O>
- <![CDATA[]]></O>
- <TextAttr>
- <Attr rotation="-90" alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <TitleVisible value="true" position="0"/>
- </Title>
- <newAxisAttr isShowAxisLabel="true"/>
- <AxisLineStyle AxisStyle="0" MainGridStyle="1"/>
- <newLineColor mainGridColor="-3881788" mainGridPredefinedStyle="false" lineColor="-5197648" predefinedStyle="false"/>
- <AxisPosition value="2"/>
- <TickLine201106 type="2" secType="0"/>
- <ArrowShow arrowShow="false"/>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="72" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <AxisLabelCount value="=1"/>
- <AxisRange minValue="=0"/>
- <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
- <ZoomAxisAttr isZoom="false"/>
- <axisReversed axisReversed="false"/>
- <VanChartAxisAttr mainTickLine="0" secTickLine="0" axisName="Y轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="solid"/>
- <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
- <alertList/>
- <customBackgroundList/>
- <VanChartValueAxisAttr isLog="false" valueStyle="false" baseLog="=10"/>
- <ds>
- <RadarYAxisTableDefinition>
- <Top topCate="-1" topValue="-1" isDiscardOtherCate="false" isDiscardOtherSeries="false" isDiscardNullCate="false" isDiscardNullSeries="false"/>
- <attr/>
- </RadarYAxisTableDefinition>
- </ds>
- </VanChartAxis>
- </YAxisList>
- <stackAndAxisCondition>
- <ConditionCollection>
- <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
- <ConditionAttr name=""/>
- </DefaultAttr>
- <ConditionAttrList>
- <List index="0">
- <ConditionAttr name="堆积和坐标轴1">
- <AttrList>
- <Attr class="com.fr.plugin.chart.base.AttrSeriesStackAndAxis">
- <AttrSeriesStackAndAxis>
- <Attr xAxisIndex="0" yAxisIndex="0" stacked="false" percentStacked="false" stackID="堆积和坐标轴1"/>
- </AttrSeriesStackAndAxis>
- </Attr>
- </AttrList>
- <Condition class="com.fr.data.condition.ListCondition"/>
- </ConditionAttr>
- </List>
- </ConditionAttrList>
- </ConditionCollection>
- </stackAndAxisCondition>
- <VanChartColumnPlotAttr seriesOverlapPercent="20.0" categoryIntervalPercent="20.0" fixedWidth="false" columnWidth="0" filledWithImage="false" isBar="false"/>
- </VanChartPlot>
- <VanChartPlot class="com.fr.plugin.chart.line.VanChartLinePlot">
- <VanChartPlotVersion version="20170715"/>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <Attr isNullValueBreak="true" autoRefreshPerSecond="6" seriesDragEnable="false" plotStyle="0" combinedSize="50.0"/>
- <newHotTooltipStyle>
- <AttrContents>
- <Attr showLine="false" position="1" isWhiteBackground="true" isShowMutiSeries="false" seriesLabel="${VALUE}"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##]]></Format>
- <PercentFormat>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#0.##%]]></Format>
- </PercentFormat>
- </AttrContents>
- </newHotTooltipStyle>
- <ConditionCollection>
- <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
- <ConditionAttr name="">
- <AttrList>
- <Attr class="com.fr.plugin.chart.base.AttrTooltip">
- <AttrTooltip>
- <Attr enable="true" duration="4" followMouse="false" showMutiSeries="true" isCustom="false"/>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="SimSun" style="0" size="72"/>
- </Attr>
- </TextAttr>
- <AttrToolTipContent>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="SimSun" style="0" size="72"/>
- </Attr>
- </TextAttr>
- <richText class="com.fr.plugin.chart.base.AttrTooltipRichText">
- <AttrTooltipRichText>
- <Attr content="" isAuto="true" initParamsContent=""/>
- <params>
- <![CDATA[{}]]></params>
- </AttrTooltipRichText>
- </richText>
- <richTextValue class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
- <AttrTooltipValueFormat>
- <Attr enable="true"/>
- </AttrTooltipValueFormat>
- </richTextValue>
- <richTextPercent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
- <AttrTooltipPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipPercentFormat>
- </richTextPercent>
- <richTextCategory class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
- <AttrToolTipCategoryFormat>
- <Attr enable="true"/>
- </AttrToolTipCategoryFormat>
- </richTextCategory>
- <richTextSeries class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
- <AttrTooltipSeriesFormat>
- <Attr enable="true"/>
- </AttrTooltipSeriesFormat>
- </richTextSeries>
- <richTextChangedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
- <AttrTooltipChangedPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipChangedPercentFormat>
- </richTextChangedPercent>
- <richTextChangedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
- <AttrTooltipChangedValueFormat>
- <Attr enable="false"/>
- </AttrTooltipChangedValueFormat>
- </richTextChangedValue>
- <TableFieldCollection/>
- <Attr isCommon="true" isCustom="false" isRichText="false" richTextAlign="left" showAllSeries="false"/>
- <value class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
- <AttrTooltipValueFormat>
- <Attr enable="true"/>
- </AttrTooltipValueFormat>
- </value>
- <percent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
- <AttrTooltipPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipPercentFormat>
- </percent>
- <category class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
- <AttrToolTipCategoryFormat>
- <Attr enable="true"/>
- </AttrToolTipCategoryFormat>
- </category>
- <series class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
- <AttrTooltipSeriesFormat>
- <Attr enable="true"/>
- </AttrTooltipSeriesFormat>
- </series>
- <changedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
- <AttrTooltipChangedPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipChangedPercentFormat>
- </changedPercent>
- <changedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
- <AttrTooltipChangedValueFormat>
- <Attr enable="false"/>
- </AttrTooltipChangedValueFormat>
- </changedValue>
- <HtmlLabel customText="" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
- </AttrToolTipContent>
- <GI>
- <AttrBackground>
- <Background name="ColorBackground" color="-16777216"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="true" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="2"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="0.5"/>
- </AttrAlpha>
- </GI>
- </AttrTooltip>
- </Attr>
- <Attr class="com.fr.plugin.chart.base.VanChartAttrLine">
- <VanAttrLine>
- <Attr lineType="solid" lineWidth="2.0" lineStyle="2" nullValueBreak="true"/>
- </VanAttrLine>
- </Attr>
- <Attr class="com.fr.plugin.chart.base.VanChartAttrMarker">
- <VanAttrMarker>
- <Attr isCommon="true" anchorSize="22.0" markerType="NullMarker" radius="4.5" width="30.0" height="30.0"/>
- <Background name="NullBackground"/>
- </VanAttrMarker>
- </Attr>
- </AttrList>
- </ConditionAttr>
- </DefaultAttr>
- </ConditionCollection>
- <Legend4VanChart>
- <Legend>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-3355444" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <Attr position="4" visible="true" predefinedStyle="false"/>
- <FRFont name="Microsoft YaHei" style="0" size="88" foreground="-10066330"/>
- </Legend>
- <Attr4VanChart floating="false" x="0.0" y="0.0" layout="aligned" customSize="true" maxHeight="100.0" isHighlight="true"/>
- </Legend4VanChart>
- <DataSheet>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="1" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <Attr isVisible="false" predefinedStyle="false"/>
- <FRFont name="SimSun" style="0" size="72"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##]]></Format>
- </DataSheet>
- <DataProcessor class="com.fr.base.chart.chartdata.model.NormalDataModel"/>
- <newPlotFillStyle>
- <AttrFillStyle>
- <AFStyle colorStyle="1"/>
- <FillStyleName fillStyleName="新特性"/>
- <isCustomFillStyle isCustomFillStyle="false"/>
- <PredefinedStyle predefinedStyle="false"/>
- <ColorList>
- <OColor colvalue="-10243346"/>
- <OColor colvalue="-8988015"/>
- <OColor colvalue="-472193"/>
- <OColor colvalue="-486008"/>
- <OColor colvalue="-8595761"/>
- <OColor colvalue="-7236949"/>
- <OColor colvalue="-8873759"/>
- <OColor colvalue="-1071514"/>
- <OColor colvalue="-1188474"/>
- <OColor colvalue="-6715442"/>
- <OColor colvalue="-10243346"/>
- <OColor colvalue="-8988015"/>
- <OColor colvalue="-472193"/>
- <OColor colvalue="-486008"/>
- <OColor colvalue="-8595761"/>
- <OColor colvalue="-7236949"/>
- <OColor colvalue="-8873759"/>
- <OColor colvalue="-1071514"/>
- <OColor colvalue="-1188474"/>
- <OColor colvalue="-6715442"/>
- <OColor colvalue="-10243346"/>
- <OColor colvalue="-8988015"/>
- <OColor colvalue="-472193"/>
- <OColor colvalue="-486008"/>
- <OColor colvalue="-8595761"/>
- <OColor colvalue="-7236949"/>
- <OColor colvalue="-8873759"/>
- <OColor colvalue="-1071514"/>
- <OColor colvalue="-1188474"/>
- <OColor colvalue="-6715442"/>
- <OColor colvalue="-10243346"/>
- <OColor colvalue="-8988015"/>
- </ColorList>
- </AttrFillStyle>
- </newPlotFillStyle>
- <VanChartPlotAttr isAxisRotation="false" categoryNum="1"/>
- <GradientStyle>
- <Attr gradientType="normal" startColor="-12146441" endColor="-9378161"/>
- </GradientStyle>
- <VanChartRectanglePlotAttr vanChartPlotType="custom" isDefaultIntervalBackground="true"/>
- <XAxisList>
- <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartAxis">
- <Title>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <O>
- <![CDATA[]]></O>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <TitleVisible value="true" position="0"/>
- </Title>
- <newAxisAttr isShowAxisLabel="true"/>
- <AxisLineStyle AxisStyle="1" MainGridStyle="1"/>
- <newLineColor mainGridPredefinedStyle="false" lineColor="-5197648" predefinedStyle="false"/>
- <AxisPosition value="3"/>
- <TickLine201106 type="2" secType="0"/>
- <ArrowShow arrowShow="false"/>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="64" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <AxisLabelCount value="=1"/>
- <AxisRange/>
- <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
- <ZoomAxisAttr isZoom="false"/>
- <axisReversed axisReversed="false"/>
- <VanChartAxisAttr mainTickLine="2" secTickLine="0" axisName="X轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="solid"/>
- <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
- <alertList/>
- <customBackgroundList/>
- </VanChartAxis>
- </XAxisList>
- <YAxisList>
- <VanChartAxis class="com.fr.plugin.chart.attr.axis.VanChartValueAxis">
- <Title>
- <GI>
- <AttrBackground>
- <Background name="NullBackground"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="0" isRoundBorder="false" roundRadius="0"/>
- <newColor borderColor="-16777216" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="1.0"/>
- </AttrAlpha>
- </GI>
- <O>
- <![CDATA[]]></O>
- <TextAttr>
- <Attr rotation="-90" alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="88" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <TitleVisible value="true" position="0"/>
- </Title>
- <newAxisAttr isShowAxisLabel="true"/>
- <AxisLineStyle AxisStyle="0" MainGridStyle="1"/>
- <newLineColor mainGridColor="-3881788" mainGridPredefinedStyle="false" lineColor="-5197648" predefinedStyle="false"/>
- <AxisPosition value="2"/>
- <TickLine201106 type="2" secType="0"/>
- <ArrowShow arrowShow="false"/>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="Verdana" style="0" size="72" foreground="-10066330"/>
- </Attr>
- </TextAttr>
- <AxisLabelCount value="=1"/>
- <AxisRange minValue="=0"/>
- <AxisUnit201106 isCustomMainUnit="false" isCustomSecUnit="false" mainUnit="=0" secUnit="=0"/>
- <ZoomAxisAttr isZoom="false"/>
- <axisReversed axisReversed="false"/>
- <VanChartAxisAttr mainTickLine="0" secTickLine="0" axisName="Y轴" titleUseHtml="false" labelDisplay="interval" autoLabelGap="true" limitSize="false" maxHeight="15.0" commonValueFormat="true" isRotation="false" isShowAxisTitle="true" gridLineType="solid"/>
- <HtmlLabel customText="function(){ return this; }" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
- <alertList/>
- <customBackgroundList/>
- <VanChartValueAxisAttr isLog="false" valueStyle="false" baseLog="=10"/>
- <ds>
- <RadarYAxisTableDefinition>
- <Top topCate="-1" topValue="-1" isDiscardOtherCate="false" isDiscardOtherSeries="false" isDiscardNullCate="false" isDiscardNullSeries="false"/>
- <attr/>
- </RadarYAxisTableDefinition>
- </ds>
- </VanChartAxis>
- </YAxisList>
- <stackAndAxisCondition>
- <ConditionCollection>
- <DefaultAttr class="com.fr.chart.chartglyph.ConditionAttr">
- <ConditionAttr name=""/>
- </DefaultAttr>
- </ConditionCollection>
- </stackAndAxisCondition>
- </VanChartPlot>
- </CustomPlotList>
- </Plot>
- <ChartDefinition>
- <CustomDefinition>
- <DefinitionMapList>
- <DefinitionMap key="column">
- <MoreNameCDDefinition>
- <Top topCate="-1" topValue="-1" isDiscardOtherCate="false" isDiscardOtherSeries="false" isDiscardNullCate="false" isDiscardNullSeries="false"/>
- <TableData class="com.fr.data.impl.NameTableData">
- <Name>
- <![CDATA[ds_chart]]></Name>
- </TableData>
- <CategoryName value="user_usertype"/>
- <ChartSummaryColumn name="login_number" function="com.fr.data.util.function.NoneFunction" customName="登录用户"/>
- <ChartSummaryColumn name="nologin_number" function="com.fr.data.util.function.NoneFunction" customName="未登录用户"/>
- </MoreNameCDDefinition>
- </DefinitionMap>
- <DefinitionMap key="line">
- <MoreNameCDDefinition>
- <Top topCate="-1" topValue="-1" isDiscardOtherCate="false" isDiscardOtherSeries="false" isDiscardNullCate="false" isDiscardNullSeries="false"/>
- <TableData class="com.fr.data.impl.NameTableData">
- <Name>
- <![CDATA[ds_chart]]></Name>
- </TableData>
- <CategoryName value="user_usertype"/>
- <ChartSummaryColumn name="all_number" function="com.fr.plugin.chart.base.FirstFunction" customName="合计"/>
- </MoreNameCDDefinition>
- </DefinitionMap>
- </DefinitionMapList>
- </CustomDefinition>
- </ChartDefinition>
- </Chart>
- <UUID uuid="15b3fe86-e9c9-488f-874f-54811574d2b5"/>
- <tools hidden="true" sort="false" export="true" fullScreen="true"/>
- <VanChartZoom>
- <zoomAttr zoomVisible="false" zoomGesture="true" zoomResize="true" zoomType="xy" controlType="zoom" categoryNum="8" scaling="0.3"/>
- <from>
- <![CDATA[]]></from>
- <to>
- <![CDATA[]]></to>
- </VanChartZoom>
- <refreshMoreLabel>
- <attr moreLabel="false" autoTooltip="true"/>
- <AttrTooltip>
- <Attr enable="true" duration="4" followMouse="false" showMutiSeries="false" isCustom="false"/>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="SimSun" style="0" size="72"/>
- </Attr>
- </TextAttr>
- <AttrToolTipContent>
- <TextAttr>
- <Attr alignText="0" predefinedStyle="false">
- <FRFont name="SimSun" style="0" size="72"/>
- </Attr>
- </TextAttr>
- <richText class="com.fr.plugin.chart.base.AttrTooltipRichText">
- <AttrTooltipRichText>
- <Attr content="" isAuto="true" initParamsContent=""/>
- <params>
- <![CDATA[{}]]></params>
- </AttrTooltipRichText>
- </richText>
- <richTextValue class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
- <AttrTooltipValueFormat>
- <Attr enable="true"/>
- </AttrTooltipValueFormat>
- </richTextValue>
- <richTextPercent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
- <AttrTooltipPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipPercentFormat>
- </richTextPercent>
- <richTextCategory class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
- <AttrToolTipCategoryFormat>
- <Attr enable="false"/>
- </AttrToolTipCategoryFormat>
- </richTextCategory>
- <richTextSeries class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
- <AttrTooltipSeriesFormat>
- <Attr enable="false"/>
- </AttrTooltipSeriesFormat>
- </richTextSeries>
- <richTextChangedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
- <AttrTooltipChangedPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipChangedPercentFormat>
- </richTextChangedPercent>
- <richTextChangedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
- <AttrTooltipChangedValueFormat>
- <Attr enable="false"/>
- </AttrTooltipChangedValueFormat>
- </richTextChangedValue>
- <TableFieldCollection/>
- <Attr isCommon="true" isCustom="false" isRichText="false" richTextAlign="left" showAllSeries="false"/>
- <value class="com.fr.plugin.chart.base.format.AttrTooltipValueFormat">
- <AttrTooltipValueFormat>
- <Attr enable="true"/>
- </AttrTooltipValueFormat>
- </value>
- <percent class="com.fr.plugin.chart.base.format.AttrTooltipPercentFormat">
- <AttrTooltipPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipPercentFormat>
- </percent>
- <category class="com.fr.plugin.chart.base.format.AttrTooltipCategoryFormat">
- <AttrToolTipCategoryFormat>
- <Attr enable="true"/>
- </AttrToolTipCategoryFormat>
- </category>
- <series class="com.fr.plugin.chart.base.format.AttrTooltipSeriesFormat">
- <AttrTooltipSeriesFormat>
- <Attr enable="true"/>
- </AttrTooltipSeriesFormat>
- </series>
- <changedPercent class="com.fr.plugin.chart.base.format.AttrTooltipChangedPercentFormat">
- <AttrTooltipChangedPercentFormat>
- <Attr enable="false"/>
- <Format class="com.fr.base.CoreDecimalFormat" roundingMode="6">
- <![CDATA[#.##%]]></Format>
- </AttrTooltipChangedPercentFormat>
- </changedPercent>
- <changedValue class="com.fr.plugin.chart.base.format.AttrTooltipChangedValueFormat">
- <AttrTooltipChangedValueFormat>
- <Attr enable="true"/>
- </AttrTooltipChangedValueFormat>
- </changedValue>
- <HtmlLabel customText="" useHtml="false" isCustomWidth="false" isCustomHeight="false" width="50" height="50"/>
- </AttrToolTipContent>
- <GI>
- <AttrBackground>
- <Background name="ColorBackground" color="-1"/>
- <Attr gradientType="normal" gradientStartColor="-12146441" gradientEndColor="-9378161" shadow="false" autoBackground="false" predefinedStyle="false"/>
- </AttrBackground>
- <AttrBorder>
- <Attr lineStyle="1" isRoundBorder="false" roundRadius="4"/>
- <newColor borderColor="-15395563" autoColor="false" predefinedStyle="false"/>
- </AttrBorder>
- <AttrAlpha>
- <Attr alpha="0.8"/>
- </AttrAlpha>
- </GI>
- </AttrTooltip>
- </refreshMoreLabel>
- <ThemeAttr>
- <Attr darkTheme="false" predefinedStyle="false"/>
- </ThemeAttr>
- </Chart>
- </O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="10" cs="9" s="2">
- <O>
- <![CDATA[ 二、用户访问]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="11">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="1" r="11">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="11">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="3" r="11">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="4" r="11">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="5" r="11">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="6" r="11">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="7" r="11">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="8" r="11">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="12" cs="9" s="1">
- <O t="DSColumn">
- <Attributes dsName="ds_login_number" columnName="all_interview_login_number"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA["平台总访问次数为"+all_interview_number+"次,日均"+ROUNDUP((all_interview_login_number/(DATEDIF(TODATE($p_day),TODATE($p_start_day),"D"))),0)+"次。其中注册用户访问"+all_interview_login_number+"次,未注册用户访问"+all_nologin_number+"次。本月访问次数为"+month_interview_number+"次,其中注册用户访问"+month_interview_login_number+"次,未注册用户访问"+month_nologin_number+"次。"]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="13" cs="9" s="2">
- <O>
- <![CDATA[ 三、APP下载量]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="14" cs="9" s="1">
- <O>
- <![CDATA[ APP各平台累计下载851次(详见附件5), 其中苹果商城下载150次,华为商城下载584次,小米商城下载115次,应用宝下载2次。本月累计下载59次。 ]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="15" cs="9" s="2">
- <O>
- <![CDATA[ 四、业务数据]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="16" cs="9" s="1">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[="<font> 平台累计发布业务数据</font>" + ds_business_total.select(update_number_all) + "条(详见附件6),其中" + JOINARRAY(MAPARRAY(ds_business.select(data_name), item + INDEXOF(ds_business.select(update_number_all), INARRAY(item, ds_business.select(data_name))) + "条"), "、") + "。"]]></Attributes>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="0" r="17" cs="9" s="1">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[="<font> 本月新增数据</font>" + ds_business2_total.select(update_number) + "条(详见附件6),其中" + JOINARRAY(MAPARRAY(ds_business2.select(data_name), item + INDEXOF(ds_business2.select(update_number), INARRAY(item, ds_business2.select(data_name))) + "条"), "、") + "。"]]></Attributes>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsHTML="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="0" r="18" cs="9" s="4">
- <O>
- <![CDATA[ 附件:1.会员用户登录详情表]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="19" cs="9" s="4">
- <O>
- <![CDATA[ 2.外部用户登录详情表]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="20" cs="9" s="4">
- <O>
- <![CDATA[ 3.企业用户登录详情表]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="21" cs="9" s="4">
- <O>
- <![CDATA[ 4.内部用户登录详情表]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="22" cs="9" s="4">
- <O>
- <![CDATA[ 5.能联全球APP上架下载统计表 ]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="23" cs="9" s="4">
- <O>
- <![CDATA[ 6.业务数据统计表]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="24" cs="9">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="25" cs="9" s="4">
- <O>
- <![CDATA[附件1:]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="26" cs="10" s="5">
- <O>
- <![CDATA[会员用户登录详情表]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="27" s="6">
- <O>
- <![CDATA[序号]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="1" r="27" s="6">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="27" s="6">
- <O>
- <![CDATA[账号]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="3" r="27" cs="3" s="6">
- <O>
- <![CDATA[企业名称]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="6" r="27" s="6">
- <O>
- <![CDATA[地区]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="7" r="27" s="6">
- <O>
- <![CDATA[登录次数]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="8" r="27" cs="2" s="6">
- <O>
- <![CDATA[最后登录时间]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="28" s="7">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=SEQ(C29)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <Expand extendable="1" leftParentDefault="false" left="C29" upParentDefault="false"/>
- </C>
- <C c="1" r="28" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="28" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_vip_data" columnName="user_uid"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="3" r="28" cs="3" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_vip_data" columnName="unit_name"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="6" r="28" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_vip_data" columnName="are"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="7" r="28" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_vip_data" columnName="logincount"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="8" r="28" cs="2" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_vip_data" columnName="login_date"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="0" r="29" cs="7" s="6">
- <O>
- <![CDATA[合计]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="7" r="29" s="7">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=SUM(H29)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="8" r="29" cs="2" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="31" cs="9" s="4">
- <O>
- <![CDATA[附件2:]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="32" cs="10" s="5">
- <O>
- <![CDATA[外部用户登录详情表]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="33" s="6">
- <O>
- <![CDATA[序号]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="1" r="33" s="6">
- <O>
- <![CDATA[账号]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="33" s="6">
- <O>
- <![CDATA[账号]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="3" r="33" s="6">
- <O>
- <![CDATA[邮箱]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="4" r="33" s="6">
- <O>
- <![CDATA[电话]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="5" r="33" s="6">
- <O>
- <![CDATA[登录次数]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="6" r="33" cs="2" s="6">
- <O>
- <![CDATA[最后登录时间]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="8" r="33" cs="2" s="6">
- <O>
- <![CDATA[是否为新增登录用户]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="34" s="7">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=SEQ(3)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <Expand extendable="1" leftParentDefault="false" left="C35" upParentDefault="false"/>
- </C>
- <C c="1" r="34" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="34" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_external_data" columnName="user_uid"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="3" r="34" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_external_data" columnName="user_email"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="4" r="34" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_external_data" columnName="user_preferred_mobile"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="5" r="34" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_external_data" columnName="logincount"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="6" r="34" cs="2" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_external_data" columnName="login_date"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="8" r="34" cs="2" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_external_data" columnName="new_insert"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="0" r="35" cs="5" s="6">
- <O>
- <![CDATA[合计]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="5" r="35" s="7">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=SUM(F35)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="6" r="35" cs="2" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="8" r="35" cs="2" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="37" cs="10" s="4">
- <O>
- <![CDATA[附件3:]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="38" cs="10" s="5">
- <O>
- <![CDATA[企业用户登录详情表]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="39" s="6">
- <O>
- <![CDATA[序号]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="1" r="39" s="6">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="39" s="6">
- <O>
- <![CDATA[账号]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="3" r="39" cs="3" s="6">
- <O>
- <![CDATA[企业名称]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="6" r="39" s="6">
- <O>
- <![CDATA[地区]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="7" r="39" s="6">
- <O>
- <![CDATA[登录次数]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="8" r="39" cs="2" s="6">
- <O>
- <![CDATA[最后登录时间]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="40" s="7">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=SEQ(2)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <Expand extendable="1" leftParentDefault="false" left="C41" upParentDefault="false"/>
- </C>
- <C c="1" r="40" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="40" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_enterprise_data" columnName="user_uid"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="3" r="40" cs="3" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_enterprise_data" columnName="unit_name"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="6" r="40" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_enterprise_data" columnName="are"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="7" r="40" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_enterprise_data" columnName="logincount"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="8" r="40" cs="2" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_enterprise_data" columnName="login_date"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="0" r="41" cs="7" s="6">
- <O>
- <![CDATA[合计]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="7" r="41" s="7">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=SUM(H41)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="8" r="41" cs="2" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="43" cs="10" s="4">
- <O>
- <![CDATA[附件4:]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="44" cs="10" s="5">
- <O>
- <![CDATA[内部用户登录详情表]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="45" s="6">
- <O>
- <![CDATA[序号]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="1" r="45" s="6">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="45" s="6">
- <O>
- <![CDATA[账号]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="3" r="45" cs="3" s="6">
- <O>
- <![CDATA[邮箱]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="6" r="45" s="6">
- <O>
- <![CDATA[登录次数]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="7" r="45" s="6">
- <O>
- <![CDATA[使用者]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="8" r="45" cs="2" s="6">
- <O>
- <![CDATA[最后登录时间]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="46" s="7">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=SEQ(4)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <Expand extendable="1" leftParentDefault="false" left="C47" upParentDefault="false"/>
- </C>
- <C c="1" r="46" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="46" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_internal_data" columnName="user_uid"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="3" r="46" cs="3" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_internal_data" columnName="user_email"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="6" r="46" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_internal_data" columnName="logincount"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="7" r="46" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_internal_data" columnName="extend_3"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="8" r="46" cs="2" s="7">
- <O t="DSColumn">
- <Attributes dsName="ds_internal_data" columnName="login_date"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0"/>
- </C>
- <C c="0" r="47" cs="6" s="6">
- <O>
- <![CDATA[合计]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="6" r="47" s="7">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=SUM(G47)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="7" r="47" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="8" r="47" cs="2" s="7">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="50" cs="10" s="4">
- <O>
- <![CDATA[附件5:]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="51" cs="10" s="5">
- <O>
- <![CDATA[能联全球APP上架下载统计表]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="52" s="6">
- <O>
- <![CDATA[平台]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="1" r="52" s="6">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="52" s="6">
- <O>
- <![CDATA[应用商店]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="3" r="52" s="6">
- <O>
- <![CDATA[版本]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="4" r="52" s="6">
- <O>
- <![CDATA[上架版本号]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="5" r="52" cs="2" s="6">
- <O>
- <![CDATA[审核状态]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="7" r="52" cs="3" s="6">
- <O>
- <![CDATA[使用者]]></O>
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="5" r="53" cs="2">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="7" r="53" cs="3">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="0" r="60" cs="10" s="4">
- <O>
- <![CDATA[附件6:]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="61" cs="10" s="5">
- <O>
- <![CDATA[业务数据统计表]]></O>
- <PrivilegeControl/>
- <Expand leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="62" s="8">
- <O>
- <![CDATA[序号]]></O>
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="1" r="62" s="8">
- <O>
- <![CDATA[栏目]]></O>
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="2" r="62" cs="2" s="8">
- <O>
- <![CDATA[栏目]]></O>
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="4" r="62" cs="2" s="8">
- <O>
- <![CDATA[新增/修改数据量]]></O>
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="6" r="62" cs="2" s="8">
- <O>
- <![CDATA[累计业务数据量]]></O>
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="8" r="62" s="8">
- <O>
- <![CDATA[责任部门]]></O>
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="0" r="63" s="9">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=seq()]]></Attributes>
- </O>
- <PrivilegeControl/>
- <Present class="com.fr.base.present.FormulaPresent">
- <Content>
- <![CDATA[=seq(1)]]></Content>
- </Present>
- <Expand extendable="1" leftParentDefault="false" left="C64" upParentDefault="false"/>
- </C>
- <C c="1" r="63" s="9">
- <PrivilegeControl/>
- <Expand/>
- </C>
- <C c="2" r="63" cs="2" s="9">
- <O t="DSColumn">
- <Attributes dsName="ds_buisness_data" columnName="DICT_NAME"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0" leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="4" r="63" cs="2" s="9">
- <O t="DSColumn">
- <Attributes dsName="ds_buisness_data" columnName="update_number"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0" leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="6" r="63" cs="2" s="9">
- <O t="DSColumn">
- <Attributes dsName="ds_buisness_data" columnName="update_number_all"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0" leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="8" r="63" s="9">
- <O t="DSColumn">
- <Attributes dsName="ds_buisness_data" columnName="DICT_DESCRIPTION"/>
- <Condition class="com.fr.data.condition.ListCondition"/>
- <Complex/>
- <RG class="com.fr.report.cell.cellattr.core.group.FunctionGrouper"/>
- <Result>
- <![CDATA[$$$]]></Result>
- <Parameters/>
- </O>
- <PrivilegeControl/>
- <Expand dir="0" leftParentDefault="false" upParentDefault="false"/>
- </C>
- <C c="0" r="64" cs="4" s="10">
- <O>
- <![CDATA[总计]]></O>
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="4" r="64" cs="2" s="10">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=sum(E64)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="6" r="64" cs="2" s="10">
- <O t="XMLable" class="com.fr.base.Formula">
- <Attributes>
- <![CDATA[=sum(G64)]]></Attributes>
- </O>
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- <C c="8" r="64" s="10">
- <PrivilegeControl/>
- <CellGUIAttr showAsDefault="true"/>
- <CellPageAttr/>
- <Expand/>
- </C>
- </CellElementList>
- <ReportAttrSet>
- <ReportSettings headerHeight="0" footerHeight="2448000">
- <PaperSetting>
- <Margin top="5040000" left="4032000" bottom="3600000" right="4032000"/>
- </PaperSetting>
- <Background name="ColorBackground" color="-1"/>
- </ReportSettings>
- <Header reportPageType="0">
- <Background name="NullBackground"/>
- <LeftList/>
- <CenterList/>
- <RightList/>
- </Header>
- <Footer reportPageType="0">
- <Background name="NullBackground"/>
- <LeftList/>
- <CenterList>
- <HFElement className="com.fr.base.headerfooter.TextHFElement">
- <FRFont name="宋体" style="0" size="128"/>
- <![CDATA[— ]]></HFElement>
- <HFElement className="com.fr.base.headerfooter.PageNumberHFElement">
- <FRFont name="宋体" style="0" size="128"/>
- <![CDATA[1]]></HFElement>
- <HFElement className="com.fr.base.headerfooter.TextHFElement">
- <FRFont name="宋体" style="0" size="128"/>
- <![CDATA[ —]]></HFElement>
- </CenterList>
- <RightList/>
- </Footer>
- </ReportAttrSet>
- <PrivilegeControl/>
- </Report>
- <ReportParameterAttr>
- <Attributes showWindow="true" delayPlaying="true" windowPosition="1" align="0" useParamsTemplate="true" currentIndex="0"/>
- <PWTitle>
- <![CDATA[参数]]></PWTitle>
- <Parameter>
- <Attributes name="p_day"/>
- <O>
- <![CDATA[2021-05-13]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_start_day"/>
- <O>
- <![CDATA[2021-03-22]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_day_count"/>
- <O>
- <![CDATA[1]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_report_no"/>
- <O>
- <![CDATA[0]]></O>
- </Parameter>
- <Parameter>
- <Attributes name="p_work_count"/>
- <O t="I">
- <![CDATA[5]]></O>
- </Parameter>
- </ReportParameterAttr>
- <StyleList>
- <Style horizontal_alignment="0" imageLayout="1" paddingLeft="1" paddingRight="1" spacingBefore="20" spacingAfter="20">
- <FRFont name="宋体" style="1" size="208"/>
- <Background name="NullBackground"/>
- <Border/>
- </Style>
- <Style horizontal_alignment="6" imageLayout="1" paddingLeft="0" paddingRight="0" lineSpacing="7">
- <FRFont name="仿宋" style="0" size="152"/>
- <Background name="NullBackground"/>
- <Border/>
- </Style>
- <Style imageLayout="1" paddingLeft="0" paddingRight="0" lineSpacing="1">
- <FRFont name="黑体" style="1" size="152"/>
- <Background name="NullBackground"/>
- <Border/>
- </Style>
- <Style imageLayout="1" paddingLeft="0" paddingRight="0" spacingBefore="100" lineSpacing="-24">
- <FRFont name="SimSun" style="0" size="72"/>
- <Background name="NullBackground"/>
- <Border/>
- </Style>
- <Style imageLayout="1" paddingLeft="0" paddingRight="0" lineSpacing="7">
- <FRFont name="仿宋" style="0" size="152"/>
- <Background name="NullBackground"/>
- <Border/>
- </Style>
- <Style horizontal_alignment="0" imageLayout="1">
- <FRFont name="SimSun" style="1" size="176"/>
- <Background name="NullBackground"/>
- <Border/>
- </Style>
- <Style horizontal_alignment="0" imageLayout="1">
- <FRFont name="SimSun" style="0" size="72"/>
- <Background name="NullBackground"/>
- <Border>
- <Top style="1"/>
- <Bottom style="1"/>
- <Left style="1"/>
- <Right style="1"/>
- </Border>
- </Style>
- <Style imageLayout="1">
- <FRFont name="SimSun" style="0" size="72"/>
- <Background name="NullBackground"/>
- <Border>
- <Top style="1" color="-16777216"/>
- <Bottom style="1" color="-16777216"/>
- <Left style="1" color="-16777216"/>
- <Right style="1" color="-16777216"/>
- </Border>
- </Style>
- <Style horizontal_alignment="0" imageLayout="1">
- <FRFont name="仿宋" style="1" size="96"/>
- <Background name="ColorBackground" color="-4144960"/>
- <Border>
- <Top style="1" color="-16777216"/>
- <Bottom style="1" color="-16777216"/>
- <Left style="1" color="-16777216"/>
- <Right style="1" color="-16777216"/>
- </Border>
- </Style>
- <Style horizontal_alignment="0" imageLayout="1">
- <FRFont name="仿宋" style="0" size="96"/>
- <Background name="NullBackground"/>
- <Border>
- <Top style="1" color="-16777216"/>
- <Bottom style="1" color="-16777216"/>
- <Left style="1" color="-16777216"/>
- <Right style="1" color="-16777216"/>
- </Border>
- </Style>
- <Style horizontal_alignment="0" imageLayout="1">
- <FRFont name="仿宋" style="1" size="96"/>
- <Background name="NullBackground"/>
- <Border>
- <Top style="1"/>
- <Bottom style="1"/>
- <Left style="1"/>
- <Right style="1"/>
- </Border>
- </Style>
- </StyleList>
- <DesignerVersion DesignerVersion="KAA"/>
- <PreviewType PreviewType="0"/>
- <TemplateCloudInfoAttrMark class="com.fr.plugin.cloud.analytics.attr.TemplateInfoAttrMark" pluginID="com.fr.plugin.cloud.analytics.v10" plugin-version="2.3.6.20211125">
- <TemplateCloudInfoAttrMark createTime="1634809950430"/>
- </TemplateCloudInfoAttrMark>
- <TemplateIdAttMark class="com.fr.base.iofile.attr.TemplateIdAttrMark">
- <TemplateIdAttMark TemplateId="c6bb10a2-3f96-48e7-b54d-32c3ca450676"/>
- </TemplateIdAttMark>
- </WorkBook>
|