123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254 |
- /****************************************************************
- ** Licensed Materials - Property of IBM
- **
- ** BI and PM: qs
- **
- ** (C) Copyright IBM Corp. 2001, 2015
- **
- ** US Government Users Restricted Rights - Use, duplication or
- ** disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
- *****************************************************************/
- // Copyright (C) 2008 Cognos ULC, an IBM Company. All Rights Reserved.
- // Cognos and the Cognos logo are trademarks of Cognos ULC (formerly Cognos Incorporated) in the United States and/or other countries. IBM and the IBM logo are trademarks of International Business Machines Corporation in the United States, or other countries, or both. Other company, product, or service names may be trademarks or service marks of others.
- function changeDialog(oSelectElement)
- {
- if (oSelectElement === null || oSelectElement.options === null || oSelectElement.options.length <= 0)
- {
- return;
- }
- var sFilterDialogType = oSelectElement.options[oSelectElement.selectedIndex].value;
- if (sFilterDialogType == "")
- {
- return;
- }
- var basedOnVal = filterCommon_initBasedOnDatasourceBox();
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- getConfigFrame().invokeOtherFilterDlg(sFilterDialogType, document.f.promptBox.checked, getNullOption(), basedOnVal, fd_getNOT(), "filterTypeInExactlyMatches");
- }
- else
- {
- getConfigFrame().invokeOtherFilterDlg(sFilterDialogType, document.f.promptBox.checked, false, basedOnVal, fd_getNOT(), "filterTypeInExactlyMatches");
- }
- };
- function hideFilterOperation()
- {
- if (document.f.operation)
- {
- document.f.operation.style.display = "none";
- }
- };
- function changeDateRangeDialog(oDateRangeElement)
- {
- var oSelectedElement = oDateRangeElement.options[oDateRangeElement.selectedIndex];
- if (oSelectedElement === null)
- {
- return;
- }
- var sFilterDialogType = oSelectedElement.value;
- if (sFilterDialogType == "")
- {
- return;
- }
- if ("filterDaysBeforeToday" == sFilterDialogType)
- {
- if ("selectDateTime" == complexFilterType)
- {
- cf.dlgGlobalSetParm("xxPreviousFilter", "filterDateTimeRange");
- }
- else
- {
- cf.dlgGlobalRemoveParm("xxPreviousFilter");
- }
- }
- else if ("filterDateRange" == sFilterDialogType && "filterDateTimeRange" == cf.dlgGlobalGetParm("xxPreviousFilter"))
- {
- oSelectedElement.value = "filterDateTimeRange";
- }
- changeDialog(oDateRangeElement);
- };
- function removeExecute()
- {
- var oBtn = document.getElementById("executeButton");
- if (oBtn)
- {
- oBtn.href = "#";
- }
- };
- function submitFilterExpression(sFE)
- {
- if (cf.dlgGlobalGetParm("xxConvertENUMToRange"))
- {
- removeEnumChildrenFromFilter();
- }
- clearFilterConversionGlobals();
-
-
- var oMQMgr = goDialogManager.getMiniQueryManager();
- var oCol = oMQMgr.getColumnById(cf.dlgGlobalGetParm("xxColName"));
-
- var sDetailAgg = oMQMgr.getDetailAggregate(oCol);
- var sSummaryAgg = oMQMgr.getSummaryAggregate(oCol);
-
- if (sSummaryAgg != "none" && (sDetailAgg == "count" || sDetailAgg == "countDistinct"))
- {
- sFE.m_nNode.setAttribute("postAutoAggregation","true");
- }
- else
- {
- sFE.m_nNode.setAttribute("postAutoAggregation","false");
- }
-
- if (cf.isDetailFilterEnabled())
- {
- submitFilter(sFE, onlyPrompt, (document.f.filterBasedOnDS && !document.f.filterBasedOnDS.checked));
- }
- else
- {
- submitFilter(sFE, onlyPrompt, true);
- }
- };
- function submitFilter(fString, onlyPrompt, summaryFilter)
- {
- var cf = getConfigFrame();
- var oCC = cf.getCombinedFilter();
- if (oCC || cf.getFilterMode() != cf.giFILTERCPLXMODE_SIMPLE)
- {
- submitComplexFilter(fString, onlyPrompt, summaryFilter);
- }
- else
- {
- submitBasicFilter(fString, onlyPrompt, summaryFilter);
- }
- };
- function submitBasicFilter(fString, onlyPrompt, summaryFilter)
- {
- var cf = getConfigFrame();
-
- if (fString && typeof fString.getXML == 'function')
- {
- fString = fString.getXML();
- }
- var bIsNot = (fd_getNOT() == "true");
- cf.dofc(fString, onlyPrompt, summaryFilter, bIsNot);
- cf.hideDialogFrame();
- cf.dlgGlobalReset();
- };
- function submitComplexFilter(fCondition, onlyPrompt, summaryFilter)
- {
- var oMQMgr = goDialogManager.getMiniQueryManager();
- var cf = getConfigFrame();
- var oCC = cf.getCombinedFilter();
- var sSummary = "true";
- var iMode = cf.getFilterMode();
- var oF = null;
- var oFG = null;
- if (oCC == null)
- {
- oCC = cf.convertToCombinedFilter();
- }
- var fString = fCondition;
- if (fCondition && typeof fCondition.getXML == 'function')
- {
- fString = fCondition.getXML();
- }
- if (fString.length <= 0 || fString == ("[" + getPromptId() + "]"))
- {
-
- if (!cf.dlgGlobalGetParm("xxNewFilter"))
- {
-
- oF = oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid"));
- if (oF)
- {
- oF.removeSelf();
- }
- if (iMode == cf.giFILTERCPLXMODE_SIMPLE)
- {
-
- cf.addColumnsForReselection();
- cf.sendCmd(oCC.getCommand(), "", true);
- }
- }
- if (iMode != cf.giFILTERCPLXMODE_SIMPLE)
- {
- cf.dlgReset();
- if (cf.isDetailFilterEnabled())
- {
- cf.dlgGlobalSetParm("xxAllowDetail", true);
- }
- cf.dlgSetParm("m", "/" + cf.qs_dir + "/filterCombine.xts");
-
- var sTab = cf.dlgGlobalGetParm("xxFCtab");
- if (!sTab)
- {
- sTab = (oCC.getCurrentFilterGroup() == oCC.getSummaryFilter() ? 's': 'r');
- }
- cf.dlgGlobalSetParm("xxFCtab", sTab);
- cf.dlgSetParm("m_tab", sTab);
- cf.dlgSubmit();
- }
- else
- {
- cf.hideDialogFrame();
- }
- return;
- }
- if (this.summarizationValue)
- {
- if (this.summarizationValue == "raw")
- {
- sSummary = "none";
- }
- else if (this.summarizationValue == "details")
- {
- sSummary = "true";
- }
- else
- {
- var summaryValue = '';
- if ( document.getElementById("summary") )
- {
- summaryValue = document.getElementById("summary").value;
- if (typeof summaryValue == "string" && summaryValue.match(/^\d+$/))
- {
- summaryValue = parseInt(summaryValue, 10);
- }
- }
- sSummary = oMQMgr.getColumnId(summaryValue);
- if (sSummary == oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
- {
- sSummary = "";
- }
- }
- }
- var filterBasedOnDS = document.getElementById("filterBasedOnDS");
- if (filterBasedOnDS && filterBasedOnDS.checked && cf.isDetailFilterEnabled())
- {
- sSummary = "none";
- }
- var bFilterFromMetadata = (cf.dlgGlobalGetParm("xxFilterFromMetadata") === true);
- if (iMode != cf.giFILTERCPLXMODE_SIMPLE || bFilterFromMetadata)
- {
-
-
-
-
- if (!cf.cfgGet("combinedFilters_default"))
- {
- cf.cfgSet("combinedFilters_default", oCC.clone());
- }
-
- cf.dlgReset();
- if (sSummary == "none")
- {
- oCC.setFilterView(cf.giFILTERVIEW_RAW);
- cf.dlgGlobalSetParm("xxFCtab", "r");
- }
- else
- {
- oCC.setFilterView(cf.giFILTERVIEW_SUMMARY);
- cf.dlgGlobalSetParm("xxFCtab", "s");
- }
- if (fCondition && typeof fCondition.setDataItemName == 'function')
- {
- fCondition.setDataItemName(cf.dlgGlobalGetParm('xxColName'));
- }
-
- oF = oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid"));
- if (oF == null || cf.dlgGlobalGetParm("xxNewFilter"))
- {
-
- var sFID = oCC.generateID();
- var selColSize = cf.cfgSize("SelColumns");
- var sel = cf.cfgGetAt("SelColumns", 0);
- oF = new cf.CFilter(
- sFID,
- (bFilterFromMetadata ? cf.dlgGlobalGetParm('xxFCid') : oMQMgr.getColumnId(sel)),
- cf.gsFILTER_REFTYPE_COLUMN,
- this.complexFilterType,
- fCondition,
- sSummary,
- (bFilterFromMetadata ? cf.dlgGlobalGetParm('xxFullColExpression') : fCondition)
-
- );
- oF.setNot(fd_getNOT());
- oCC.getCurrentFilterGroup().addPredicate(oF);
- oF.setDirty();
- }
- else if (oF != null)
- {
- oF.setCondition(fCondition);
- oF.setSummary(sSummary);
- oF.setNot(fd_getNOT());
- oFG = oCC.getCurrentFilterGroup();
- if (oFG.getFilterById(cf.dlgGlobalGetParm("xxFCid")) == null)
- {
-
- oF.removeSelf();
- oFG.addPredicate(oF);
- }
- }
- if (cf.dlgGlobalGetParm("xxFCtab") != null)
- {
- cf.dlgSetParm("m_tab", cf.dlgGlobalGetParm("xxFCtab"));
- }
- if (cf.isDetailFilterEnabled())
- {
- cf.dlgGlobalSetParm("xxAllowDetail", true);
- }
- cf.dlgSetParm("m", "/" + cf.qs_dir + "/filterCombine.xts");
- cf.dlgSubmit();
- }
- else
- {
- oF = (oCC ? oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid")) : null);
- if (oF)
- {
-
- oF.setCondition(fCondition);
- oF.setSummary(sSummary);
- oF.setNot(fd_getNOT());
-
- oCC.setFilterView(sSummary == "none" ? cf.giFILTERVIEW_RAW : cf.giFILTERVIEW_SUMMARY);
- oFG = oCC.getCurrentFilterGroup();
- if (oFG.getFilterById(cf.dlgGlobalGetParm("xxFCid")) == null)
- {
-
- oF.removeSelf();
- oFG.addPredicate(oF);
- }
- cf.addColumnsForReselection();
- cf.sendCmd(oCC.getCommand(), "", true);
- cf.hideDialogFrame();
- }
- cf.dlgGlobalReset();
- }
- };
- function cancelDialog()
- {
- if (cf.dlgGlobalGetParm("xxConvertENUMToRange"))
- {
- cancelEnumToRangeConversion();
- }
-
- clearFilterConversionGlobals();
- var oAppFrame = getAppFrame();
- if (oAppFrame !== null)
- {
- if (oAppFrame.getFilterMode() == oAppFrame.giFILTERCPLXMODE_WIZARD)
- {
- oAppFrame.dlgReset();
- if (oAppFrame.isDetailFilterEnabled())
- {
- oAppFrame.dlgGlobalSetParm("xxAllowDetail", true);
- }
- oAppFrame.dlgSetParm("m", "/" + oAppFrame.qs_dir + "/filterCombine.xts");
- if (oAppFrame.dlgGlobalGetParm("xxFCtab"))
- {
- oAppFrame.dlgSetParm("m_tab", oAppFrame.dlgGlobalGetParm("xxFCtab"));
- }
- oAppFrame.dlgSubmit();
- }
- else
- {
-
- if(typeof requestTracking != "undefined" && requestTracking != "")
- {
- if(typeof showCancellingIndicator != "undefined")
- {
- showCancellingIndicator();
- }
- var urlParams = "b_action=xts.run&m=portal/om-request.xts&ui.action=cancel";
- urlParams += "&m_tracking=" + encodeURIComponent(requestTracking);
-
- requestTracking = "";
- oAppFrame.sendDispatcherRequest(urlParams, cancelResponse);
- }
- else
- {
- oAppFrame.dlgReset();
- oAppFrame.dlgGlobalReset();
- oAppFrame.hideDialogFrame();
- }
- }
- }
- };
- function clearFilterConversionGlobals()
- {
- cf.dlgGlobalRemoveParm("xxConvertRangeToENUM");
- cf.dlgGlobalRemoveParm("xxConvertRangeFromValue");
- cf.dlgGlobalRemoveParm("xxConvertRangeToValue");
- cf.dlgGlobalRemoveParm("xxConvertENUMToRange");
- };
- function cancelEnumToRangeConversion()
- {
- var nFilterElement = getFilterElement();
- if (nFilterElement)
- {
- var fromNode = getChildNodeByName(nFilterElement, cf.gsFE_FROM_NODE);
- if (fromNode)
- {
- nFilterElement.removeChild(fromNode);
- }
- var toNode = getChildNodeByName(nFilterElement, cf.gsFE_TO_NODE);
-
- if (toNode)
- {
- nFilterElement.removeChild(toNode);
- }
- nFilterElement.setAttribute(cf.gsFE_FILTERTYPE_ATTR, cf.gsFE_FILTERTYPE_ENUM);
- }
- };
- function removeEnumChildrenFromFilter()
- {
- var nFilterElement = getFilterElement();
- if (nFilterElement)
- {
-
-
-
-
-
-
- var childNode;
- var childNodeName;
- for (var iChild=nFilterElement.childNodes.length-1; iChild>=0; iChild--)
- {
- childNode = nFilterElement.childNodes[iChild];
- if (typeof childNode.baseName != "undefined")
- {
- childNodeName = childNode.baseName;
- }
- else
- {
- childNodeName = childNode.localName;
- }
- if (childNodeName === cf.gsFE_VALUE_NODE)
- {
- nFilterElement.removeChild(childNode);
- }
- }
- }
- };
- function getFilterElement()
- {
- var nFilterElement;
- var nFilter;
- var oFilter;
- var cf = getConfigFrame();
- var oCC = cf.getCombinedFilter();
-
-
- if (oCC == null)
- {
- var oMQMgr = goDialogManager.getMiniQueryManager();
- var aFilters = oMQMgr.getFiltersForColumn(cf.dlgGlobalGetParm("xxFCid"));
- if (aFilters)
- {
-
- oFilter = aFilters[0];
- }
- }
- else if (oCC)
- {
- oFilter = oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid"));
- }
- if (oFilter)
- {
- nFilter = (oFilter.m_nNode ? oFilter.m_nNode : oFilter);
- }
- if (nFilter)
- {
- nFilterElement = getChildNodeByName(nFilter, cf.gsFE_NODE);
- }
- return nFilterElement;
- };
- function getChildNodeByName(node, nodeName)
- {
- var ii;
- var childNode;
- var childNodeName;
-
- if (node)
- {
- for (ii = 0; ii < node.childNodes.length; ii++)
- {
- if (typeof node.childNodes[ii].baseName != "undefined")
- {
- childNodeName = node.childNodes[ii].baseName;
- }
- else
- {
- childNodeName = node.childNodes[ii].localName;
- }
- if (nodeName === childNodeName)
- {
- childNode = node.childNodes[ii];
- break;
- }
-
- if (node.childNodes[ii].hasChildNodes())
- {
- childNode = getChildNodeByName(node.childNodes[ii], nodeName);
- if (childNode)
- {
- break;
- }
- }
- }
- }
- return childNode;
- };
- function cancelResponse(response)
- {
- cf.dlgReset();
- cf.dlgGlobalReset();
- cf.hideDialogFrame();
- };
- function cleanUpPage()
- {
- pickerControldateFrom.m_oDatePickerDialog.hidePicker();
- pickerControldateTo.m_oDatePickerDialog.hidePicker();
- };
- function toDropDown()
- {
- pickerControldateFrom.m_oDatePickerDialog.hidePicker();
- toGotFocus();
- };
- function fromDropDown()
- {
- pickerControldateTo.m_oDatePickerDialog.hidePicker();
- fromGotFocus();
- };
- function fromGotFocus()
- {
- document.f.fromValue[0].checked = true;
- };
- function toGotFocus()
- {
- document.f.toValue[0].checked = true;
- };
- function catchSubmit(iKeyCode)
- {
-
- if (iKeyCode == 13)
- {
- execute();
- }
- };
- function updateBasedOn()
- {
-
-
- if (cf.getCombinedFilter() != null)
- {
- cf.setFilterMode(cf.giFILTERCPLXMODE_PRE_WIZARD);
- }
- };
- function getPromptId()
- {
- if (isPromptParamAndIdEncoded())
- {
- return decodeURIComponent(cf.dlgGlobalGetParm("xxPromptID"));
- }
- return cf.dlgGlobalGetParm("xxPromptID");
- };
- function isPromptParamAndIdEncoded()
- {
- if (cf.dlgGlobalGetParm("xxPromptParamAndIDEncoded"))
- {
- return true;
- }
- return false;
- };
- function addNullOptionToFilter(fs, di, opt)
- {
- if (getConfigFrame().dlgGlobalGetParm('xxIsNullAllowed') == true && opt)
- {
- if (opt == 'include')
- {
- if ((fs != "")&&(fs != di))
- {
- fs += " or " + di + " is null";
- }
- }
- else if (opt == 'exclude')
- {
- if ((fs == "")||(fs == di))
- {
- fs = di + " is not null";
- }
- else
- {
- fs += " and " + di + " is not null";
- }
- }
- else if (opt == 'only')
- {
- fs = di + " is null";
- }
- }
- return fs;
- };
- function showNullOptions(bShow)
- {
- var cf = getConfigFrame();
- var ds = cf.cfgGet("DialogSize");
- var dsDefined = true;
- var advOptionSize = 40;
- if (ds == 0 || typeof ds == 'undefined' || ds == null)
- {
- dsDefined = false;
- }
- if (bShow)
- {
- document.getElementById('QsdlgVisibleNullOptions').style.display = 'block';
- document.getElementById('QsdlgHiddenNullOptions').style.display = 'none';
- if (dsDefined)
- {
- ds += advOptionSize;
- cf.showDialogFrame(ds);
- }
- }
- else
- {
- document.getElementById('QsdlgVisibleNullOptions').style.display = 'none';
- document.getElementById('QsdlgHiddenNullOptions').style.display = 'block';
- if (dsDefined)
- {
- ds -= advOptionSize;
- cf.showDialogFrame(ds);
- }
- }
- updateNullOptionText();
- };
- function updateNullOptionText()
- {
- var d = document.getElementById('nullOptionText');
- if (d)
- {
- d.innerHTML = document.f.QsdlgNullOptions.options[document.f.QsdlgNullOptions.selectedIndex].innerHTML;
- }
- update_NOC();
- };
- function getNullOption()
- {
- return document.f.QsdlgNullOptions.options[document.f.QsdlgNullOptions.selectedIndex].value;
- };
- function setNullOption(opt)
- {
- switch(opt)
- {
- case 'only':
- document.f.QsdlgNullOptions.selectedIndex = 3;
- break;
- case 'exclude':
- case 'false':
- document.f.QsdlgNullOptions.selectedIndex = 2;
- break;
- case 'include':
- case 'true':
- document.f.QsdlgNullOptions.selectedIndex = 1;
- break;
- default:
- document.f.QsdlgNullOptions.selectedIndex = 0;
- break;
- }
- updateNullOptionText();
- };
- function update_NOC()
- {
- set_NOC_disable('nocOnly',false);
- switch (document.f.QsdlgNullOptions.selectedIndex)
- {
- case 1:
- break;
- case 2:
- break;
- case 3:
- set_NOC_disable('nocOnly', true);
- break;
- default:
- break;
- }
- };
- function set_NOC_disable(type, state)
- {
- var a = document.getElementsByTagName("span");
- for (var i=0; i < a.length; i++)
- {
- if (a[i].getAttribute(type))
- {
- set_NOC_Children(a[i], state);
- }
- }
- };
- function set_NOC_Children(o, state)
- {
- if (o == null)
- {
- return;
- }
- if (state && typeof o.setAttribute == 'function')
- {
- o.setAttribute('disabled', 'disabled');
- }
- if (!state && typeof o.removeAttribute == 'function')
- {
- o.removeAttribute('disabled');
- }
- try
- {
- o.disabled = state;
- }
- catch(e)
- {}
- var c = o.firstChild;
- while (c)
- {
- set_NOC_Children(c, state);
- c = c.nextSibling;
- }
- };
- function initNullOptions()
- {
- var cf = getConfigFrame();
- if (cf !== null)
- {
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true && cf.isDetailFilterEnabled())
- {
- showNullOptions(false);
- if (cf.dlgGlobalGetParm('xxNullOption') != "")
- {
- setNullOption(cf.dlgGlobalGetParm('xxNullOption'));
- }
- }
- else
- {
- cf.showDialogFrame(400);
- }
- }
- var oPC = (G_PM_THIS_ ? G_PM_THIS_.getPromptControl('inputList') : null);
- if (oPC)
- {
- oPC.setExclusive( (cf.dlgGlobalGetParm('xxNOT') == 'true') );
- }
-
- if (document.f && document.f.oExcludeSelectedValues && document.f.oExcludeSelectedValues.options)
- {
- document.f.oExcludeSelectedValues.options[(cf.dlgGlobalGetParm('xxNOT') == 'true' ? 1 : 0)].selected = true;
- }
- };
- function sendPicklistRequest()
- {
- showLoading();
- var activeRequest = cf.dlgGlobalGetParm('xxActiveRequest');
- if (activeRequest != null)
- {
- cf.cancelDispatcherRequest(activeRequest);
- }
-
-
- var oMQMgr = goDialogManager.getMiniQueryManager();
- for (var i = 0; i < oMQMgr.getAllColumns().length; i++)
- {
-
-
- if((oMQMgr.isMeasure(i) === false) && (!oMQMgr.isReportExpression(i)))
- {
- var bIdAlreadySet = false;
- for (var j = 0; j < cf.dlgGlobalSize('xxOtherColIds'); j++)
- {
- if (oMQMgr.getColumnId(i) == cf.dlgGlobalGetParmAt('xxOtherColIds', j))
- {
- bIdAlreadySet = true;
- break;
- }
- }
- if (!bIdAlreadySet)
- {
- cf.dlgGlobalSetParmAt("xxOtherColIds", cf.dlgGlobalSize('xxOtherColIds'), oMQMgr.getColumnId(i));
- cf.dlgGlobalSetParmAt("xxOtherColExps", cf.dlgGlobalSize('xxOtherColExps'), oMQMgr.getExpression(i));
- }
- else
- {
- bIdAlreadySet = false;
- }
- }
- }
- var url = "m=/" + cf.qs_dir + "/filterPickListRequest.xts&b_action=xts.run";
- url += buildUrlFromGlobalParms();
- if (typeof cf.routingServerGroup != "undefined")
- {
- url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
- }
- if (cf.dlgGetParm('productLocale'))
- {
- url += "&productLocale=" + encodeURIComponent(cf.dlgGetParm('productLocale'));
- }
- url += "&xxListSeparator=" + encodeURIComponent(goDialogManager.getMiniQueryManager().getListSeparator());
- if (cf.cafContextId != "")
- {
- url += "&ui.cafcontextid=" + cf.cafContextId;
- }
- url += "&textBoxControl=checkBoxListpList";
-
-
- if (cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters() !== null)
- {
- url += "&xxExecutionParameters=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters());
- }
- if (cf.cfgGet("markup_track") != "undefined")
- {
- url += "&markup_track=" + cf.cfgGet("markup_track");
- }
- cf.dlgGlobalSetParm("xxActiveRequest", cf.sendDispatcherRequest(url, processResponse));
- };
- function buildUrlFromGlobalParms()
- {
- var aURL = [];
- var aKeys = cf.dlgGlobalKeys();
- aKeys = [
- 'searchConversation',
- 'searchTracking',
- 'xxCalcOp',
- 'xxColid',
- 'xxCreds',
- 'xxDesignMode',
- 'xxExprLocale',
- 'xxFilterItemRef',
- 'xxFilterItemRefExp',
- 'xxFullColExpression',
- 'xxHun',
- 'xxIsAttribute',
- 'xxIsNullAllowed',
- 'xxLevelNumber',
- 'xxModelName',
- 'xxOtherColIds',
- 'xxPromptCascade',
- 'xxPromptParam',
- 'xxPromptValues',
- 'xxRetrievePrompt',
- 'xxSearchPath',
- 'xxUseItemRef',
- 'xxUseItemRefExp',
- 'xxDisplayItemRef',
- 'xxDisplayItemRefExp',
- 'xxFilteredColId',
- 'xxFilteredColExpression',
- 'xxUseMUN',
- 'xxExecutionParameters'
- ];
- var idxKey;
- var sAmpersand = "&";
- var sEquals = "=";
- for(idxKey = 0; idxKey < aKeys.length; idxKey++)
- {
- var sKey = aKeys[idxKey];
- var iSize = cf.dlgGlobalSize(sKey);
- if (iSize > 0)
- {
- if (sKey == 'xxOtherColIds')
- {
-
-
- var url = "";
- for (var i = 0; i < cf.dlgGlobalSize('xxOtherColIds'); i++)
- {
- url += "&xxOtherCols=" + cf.dlgGlobalConstructPairParm(url, encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColIds', i)), encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColExps', i)));
- }
- aURL.push(url);
- }
- else
- {
- for (var i = 0; i < iSize; i++)
- {
- aURL.push(sAmpersand);
- aURL.push(sKey);
- aURL.push(sEquals);
- aURL.push(encodeURIComponent(cf.dlgGlobalGetParmAt(sKey, i)));
- }
- }
- }
- else if (cf.dlgGlobalGetParm(sKey))
- {
- aURL.push(sAmpersand);
- aURL.push(sKey);
- aURL.push(sEquals);
- aURL.push(encodeURIComponent(cf.dlgGlobalGetParm(sKey)));
- }
- }
- return aURL.join('');
- };
- function sendSearchRequest(bInit)
- {
- if (!bInit && promptsRetrieved == false)
- {
- return;
- }
- var activeRequest = cf.dlgGlobalGetParm('xxActiveRequest');
- if (activeRequest != null)
- {
- cf.cancelDispatcherRequest(activeRequest);
- }
- var url = "m=/" + cf.qs_dir + "/filterSearchRequest.xts&b_action=xts.run";
- url += "&_sws_pSearch_searchValue=" + encodeURIComponent(document.f._sws_pSearch_searchValue.value);
- url += "&_sws_pSearch_matchAnywhere=" + document.f._sws_pSearch_matchAnywhere.value;
- url += "&_sws_pSearch_matchAll=" + document.f._sws_pSearch_matchAll.value;
- url += "&_sws_pSearch_caseInsensitive=" + document.f._sws_pSearch_caseInsensitive.value;
- url += "&_sws_pSearch_submit=true";
- url += "&_promptIdBasedNames=true";
- if (cf.cafContextId != "")
- {
- url += "&ui.cafcontextid=" + cf.cafContextId;
- }
- if (bInit)
- {
- cf.dlgGlobalRemoveParm("searchConversation");
- cf.dlgGlobalRemoveParm("searchTracking");
- }
- else
- {
- url += "&_promptControl=search";
- }
- var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
- var sStoredExpr = cf.dlgGlobalGetParm('xxFullColExpression');
- if (sDataType === "MUN" && sStoredExpr.substring(0, 8) === "children" )
- {
-
- cf.dlgGlobalSetParm('xxFullColExpression', "caption(" + cf.dlgGlobalGetParm('xxFullColExpression') + ")");
- }
- url += buildUrlFromGlobalParms();
- cf.dlgGlobalSetParm('xxFullColExpression', sStoredExpr);
- if (typeof cf.routingServerGroup != "undefined")
- {
- url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
- }
- if (promptsRetrieved != false)
- {
- url = url.replace(/&xxRetrievePrompt=[^&]*/gi, '');
- url = url.replace(/&xxSearchPath=[^&]*/gi, '');
- }
- url += "&textBoxControl=searchpSearch";
- if (cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters() !== null)
- {
- url += "&xxExecutionParameters=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters());
- }
- if (cf.cfgGet("markup_track") != "undefined")
- {
- url += "&markup_track=" + cf.cfgGet("markup_track");
- }
-
- cf.dlgGlobalSetParm("xxActiveRequest", cf.sendDispatcherRequest(url, processSearchResponse));
- };
- function processSearchResponse(response)
- {
- promptsRetrieved = true;
- cf.dlgGlobalSetParm("xxActiveRequest", null);
- searchpSearch.stopAnimateSearchIcon();
- if (cf.cfgGet("LAST_ACTION") == "" || cf.cfgGet("LAST_ACTION") != "filterSearchExecute")
- {
- if (!cf.checkResponse(response, document, "filterSearchInit", filterSearch_init))
- {
- return;
- }
- }
- else
- {
- if (!cf.checkResponse(response, document, "filterSearchExecute", filterSearch_execute))
- {
- return;
- }
- }
-
- var bPrompting = false;
- var sReportSpecification = "";
- try
- {
- eval(response);
-
-
- if (bPrompting && bPrompting === true)
- {
- sendPromptRequest(sReportSpecification);
- }
- }
- catch(e)
- {
- }
- };
- function fd_getUseValue(obj)
- {
- var sRetVal = "";
- if (obj)
- {
- if ( typeof obj == "string" )
- {
- sRetVal = obj;
- }
- else if( typeof obj.getUse == "function" )
- {
- sRetVal = obj.getUse();
- }
- else if( obj.nodeType || typeof obj.getAttribute == "function" )
- {
- sRetVal = obj.getAttribute("use");
- }
- }
- return sRetVal;
- };
- function fd_getDisplayValue(obj)
- {
- if (typeof obj == "object")
- {
- if (obj.nodeType || typeof obj.getAttribute == "function")
- {
- var dv = obj.getAttribute("display");
- if (dv)
- {
- return fd_xmldecode(dv);
- }
- }
- else if (typeof obj.getDisplay == "function")
- {
- return obj.getDisplay();
- }
- }
- return fd_getUseValue(obj);
- };
- function fd_xmldecode(str)
- {
- var cf = getConfigFrame();
- if (cf !== null && typeof cf.sXmlDecode == "function")
- {
- str = cf.sXmlDecode(str);
- }
- return str;
- };
- function fd_getNOT()
- {
- if (document.f && document.f.oExcludeSelectedValues && document.f.oExcludeSelectedValues.options)
- {
- return (document.f.oExcludeSelectedValues.options[document.f.oExcludeSelectedValues.options.selectedIndex].value);
- }
- else
- {
- var oPC = (G_PM_THIS_ ? G_PM_THIS_.getPromptControl('inputList') : null);
- if (oPC)
- {
- return ( "" + oPC.isExclusive() );
- }
- }
- return '';
- };
- function buildFilterDateExpression()
- {
- var oFE = new cf.CFilterExpression();
- oFE.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- oFE.setNullOption(no);
- if (no == "only")
- {
- return oFE;
- }
- }
- var sFromUseValue = pickerControldateFrom.sGetValue();
- var sFromDisplayValue = pickerControldateFrom.sGetFormatValue();
- var sToUseValue = pickerControldateTo.sGetValue();
- var sToDisplayValue = pickerControldateTo.sGetFormatValue();
- if (document.getElementById("textBoxstringValueFrom"))
- {
- if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
- {
- sFromUseValue = substVarValueFrom;
- sFromDisplayValue = textBoxstringValueFrom.sGetFormatValue();
- }
- else if (document.f.fromValue[2].checked == true)
- {
- sFromUseValue = null;
- }
- if (document.f.toValue[1].checked == true && substVarValueTo != null)
- {
- sToUseValue = substVarValueTo;
- sToDisplayValue = textBoxstringValueTo.sGetFormatValue();
- }
- else if (document.f.toValue[2].checked == true)
- {
- sToUseValue = null;
- }
- }
- else
- {
- if (document.f.fromValue[1].checked == true)
- {
- sFromUseValue = null;
- }
- if (document.f.toValue[1].checked == true)
- {
- sToUseValue = null;
- }
- }
- if (sFromUseValue !== null && sToUseValue !== null && pickerControldateFrom.m_dDate > pickerControldateTo.m_dDate)
- {
-
- tmp = sFromUseValue;
- sFromUseValue = sToUseValue;
- sToUseValue = tmp;
- tmp = sFromDisplayValue;
- sFromDisplayValue = sToDisplayValue;
- sToDisplayValue = tmp;
- }
- if (cf.dlgGlobalGetParm("xxDataType") == 52)
- {
-
- if (sFromUseValue !== null)
- {
- sFromUseValue += (document.f.promptBox.checked ? "T" : " ") + "00:00:00.000";
- }
- if (sToUseValue !== null)
- {
- sToUseValue += (document.f.promptBox.checked ? "T" : " ") + "23:59:59.999";
- }
- }
- if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- oFE.setPrompt(promptID);
-
- var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
- var sPromptValues = oParamManager.getRangePromptValues(sFromUseValue, sFromDisplayValue, sToUseValue, sToDisplayValue);
- cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
- }
- else
- {
- if (sFromUseValue !== null)
- {
- oFE.setFrom(sFromUseValue, sFromDisplayValue);
- }
- if (sToUseValue !== null)
- {
- oFE.setTo(sToUseValue, sToDisplayValue);
- }
- }
- return oFE;
- };
- function getAppFrame()
- {
- var oAppFrame = null;
- if (typeof getConfigFrame == "function")
- {
- oAppFrame = getConfigFrame();
- }
- else if (typeof goDialogManager != "undefined")
- {
- oAppFrame = goDialogManager.getApplicationFrame();
- }
- return oAppFrame;
- };
- function setupDialog()
- {
-
- var oFilterFeature = goDialogManager.getThisFeatureObject();
- var oFilterName = document.getElementById("filterNameStr");
- oFilterName.appendChild(document.createTextNode(decodeURIComponent(oFilterFeature.m_sLabel)));
- var oFilterDeleteLink = document.getElementById("filterDeleteLink");
- var oFilterDeleteText = oFilterDeleteLink.innerHTML;
- oFilterDeleteText = oFilterDeleteText.replace(/<a>/i, '<a href="#" onclick="deleteModelFilter();" onmouseover="window.status=\'\';return true;">');
- oFilterDeleteText = oFilterDeleteText.replace(/<\/a>/i, '</a>');
- oFilterDeleteLink.innerHTML = oFilterDeleteText;
- var oAppFrame = getAppFrame();
- if (oAppFrame !== null && oAppFrame.isDetailFilterEnabled())
- {
- document.getElementById("b_summaryOptions").style.display = "block";
- }
- for (var idxSummaryOption = 0; idxSummaryOption < document.f.r_summaryOption.length; idxSummaryOption++)
- {
- document.f.r_summaryOption[idxSummaryOption].checked = (document.f.r_summaryOption[idxSummaryOption].value == oFilterFeature.m_sFilterSummaryType);
- }
- if (document.f && document.f.oExcludeSelectedValues && document.f.oExcludeSelectedValues.options)
- {
- document.f.oExcludeSelectedValues.options[(oFilterFeature.m_bNOT ? 1 : 0)].selected = true;
- }
- };
- function execute()
- {
-
- var oFilterFeature = goDialogManager.getThisFeatureObject();
- var sSummaryOption = "";
- for (var idxSummaryOption = 0; idxSummaryOption < document.f.r_summaryOption.length; idxSummaryOption++)
- {
- if (document.f.r_summaryOption[idxSummaryOption].checked)
- {
- sSummaryOption = document.f.r_summaryOption[idxSummaryOption].value;
- }
- }
- goDialogManager.getFeatureManager().executeFeature("ModelFilter", [fd_getNOT(), sSummaryOption]);
- };
- function deleteModelFilter()
- {
-
- goDialogManager.getFeatureManager().executeFeature("ModelFilter", ["DELETE"]);
- };
- function filterDialogCommon_init()
- {
- attachMouseEvents();
- var x = document.getElementById("link1");
- var y = document.getElementById("link2");
- if (cf.dlgGlobalGetParm('xxIsSearchAllowed') != true)
- {
- y.style.display = "none";
- }
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("filterBasedOnInfoMessage").style.display = "block";
- }
- if (cf.dlgGlobalGetParm('xxPromptState') == true)
- {
- document.f.promptBox.checked = true;
- }
- else if (cf.dlgGlobalGetParm('xxPromptState') == false)
- {
- document.f.promptBox.checked = false;
- }
- else if (sXXPromptParam != "")
- {
- document.f.promptBox.checked = true;
- }
- var x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- initNullOptions();
- };
- function filterCombine_execute(bLeaveDialog)
- {
-
- var sTab = cf.dlgGlobalGetParm("xxFCtab");
- cf.dlgGlobalReset();
- cf.dlgGlobalSetParm("xxFCtab", sTab);
- var oCFilters = cf.getCombinedFilter();
-
- if (oCFilters && (oCFilters.isDirty() || oCFilters.hasDirtyChildren()))
- {
- cf.addColumnsForReselection();
- cf.sendCmd(oCFilters.getCommand(), "", true, bLeaveDialog);
- }
- else
- {
- cf.hideDialogFrame();
- }
- if(typeof oCFilters != "undefined" && oCFilters != null)
- {
- oCFilters.clearDirtyFlag();
- cf.cfgRemove("combinedFilters");
- cf.cfgRemove("combinedFilters_default");
- cf.cfgBackup("filter_promptValues");
- cf.cfgBackup("filter_promptValuesXML");
- }
- };
- function filterCombine_cancelDialog()
- {
- cf.dlgGlobalReset();
- var oCCdefault = cf.cfgGet("combinedFilters_default");
- if (oCCdefault)
- {
- var oCC = cf.getCombinedFilter();
- if (oCC)
- {
- var nParent = oCC.m_nNode.parentNode;
- if (nParent)
- {
- nParent.insertBefore(oCCdefault.m_nNode, oCC.m_nNode);
- nParent.removeChild(oCC.m_nNode);
- }
- }
- cf.cfgRemove("combinedFilters_default");
- }
- cf.cfgRemove("combinedFilters");
- cf.cfgRestore("filter_promptValues");
- cf.cfgRestore("filter_promptValuesXML");
- cf.hideDialogFrame();
- };
- function filterCombine_applyChanges()
- {
- var oCFilters = cf.getCombinedFilter();
-
- var iCurrentFilterGroup = oCFilters.m_iFilterView;
- var sTab = cf.dlgGlobalGetParm("xxFCtab");
-
- if (oCFilters && (oCFilters.isDirty() || oCFilters.hasDirtyChildren()))
- {
-
-
-
- execute(null, true);
- oCFilters.renderFilterView(oFilterViewObj);
- }
- };
- function filterCombine_init(sTab, iFilterView)
- {
- attachMouseEvents();
- oFilterViewObj = document.getElementById('filterList');
- var oCFilters;
- if (cf)
- {
- cf.setFilterMode(cf.giFILTERCPLXMODE_WIZARD);
- cf.dlgGlobalSetParm("xxFCtab", sTab);
- oCFilters = cf.getCombinedFilter();
- if (oCFilters)
- {
- var oBackup = cf.cfgGet("combinedFilters_default");
- if (!oBackup)
- {
- cf.cfgSet("combinedFilters_default", oCFilters.clone());
- }
- oCFilters.setFilterView(iFilterView);
- oCFilters.renderFilterView(oFilterViewObj);
- }
- }
- if (cf && cf.dlgGlobalGetParm("xxAllowDetail") != true && oCFilters.getRawFilter().getSize() == 0)
- {
- var rTabElement = document.getElementById("rTab");
- if (rTabElement)
- {
- rTabElement.parentNode.parentNode.parentNode.parentNode.style.display = "none";
- }
- }
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(300);
- }
- document.onclick = function(event)
- {
- var sTCN = ((window.event && window.event.srcElement) ? window.event.srcElement : event.target).className;
- if ( gFContextMenu && gFContextMenu.m_contextMenu && !sTCN.match(/\bclsFilterOperator\b/gi) )
- {
-
- gFContextMenu.m_contextMenu.remove();
- }
- return true;
- };
- };
- function filterCombine_gf()
- {
- var oCFilters = cf.getCombinedFilter();
- oCFilters.groupFilters(oCFilters.getSelectedIds(oFilterViewObj));
- oCFilters.renderFilterView(oFilterViewObj);
- };
- function filterCombine_ugf()
- {
- var oCFilters = cf.getCombinedFilter();
- oCFilters.unGroupFilters(oCFilters.getSelectedIds(oFilterViewObj));
- oCFilters.renderFilterView(oFilterViewObj);
- };
- function filterCombine_df()
- {
- var oCFilters = cf.getCombinedFilter();
- oCFilters.deleteFilters(oCFilters.getSelectedIds(oFilterViewObj));
- oCFilters.renderFilterView(oFilterViewObj);
- };
- function filterCombine_fNot(bNot)
- {
- var oCFilters = cf.getCombinedFilter();
- var aFilterIDs = oCFilters.getSelectedIds(oFilterViewObj);
- for (var idxFilter in aFilterIDs)
- {
- var sFilterId = aFilterIDs[idxFilter];
- var oFilter = oCFilters.getFilterById(sFilterId);
- if (oFilter !== null)
- {
- oFilter.setNot(bNot);
- }
- }
- oCFilters.setDirty();
- oCFilters.renderFilterView(oFilterViewObj);
- };
- function filterCombine_dfa()
- {
- var oCFilters = cf.getCombinedFilter();
- oCFilters.deleteAll();
- oCFilters.renderFilterView(oFilterViewObj);
- };
- function filterCombine_afl()
- {
- cf.dlgGlobalSetParm("xxNewFilter", true);
- goDialogManager.getFeatureManager().launchFeature('FilterSimple');
- };
- function filterCombine_cOp(sId, sOp)
- {
- var oCFilters = cf.getCombinedFilter();
- var oFilterGroup = oCFilters.getFilterById(sId);
- if (oFilterGroup.isNot())
- {
- if (sOp == cf.gsFILTEROPERATOR_AND)
- {
- sOp = cf.gsFILTEROPERATOR_NAND;
- }
- else if (sOp == cf.gsFILTEROPERATOR_OR)
- {
- sOp = cf.gsFILTEROPERATOR_NOR;
- }
- }
- oFilterGroup.setOperator(sOp);
- oCFilters.renderFilterView(oFilterViewObj);
-
- if (window && window.getSelection && window.getSelection().removeAllRanges)
- {
- window.getSelection().removeAllRanges();
- }
- };
- function filterCombine_modifyFilter(sFID, sTab)
- {
- cf.dlgGlobalSetParm("xxNewFilter", false);
- cf.dlgGlobalSetParm("xxFCtab", sTab);
- cf.dlgGlobalSetParm("xxShowTypeInDropDown", cf.checkCalcFunctionAgainstDB("FLEXIBLE_FILTERS"));
- goDialogManager.getFeatureManager().launchFeature('FilterSimple', [sFID, true]);
- };
- function filterCombine_tab(sTab, sDialogName)
- {
- cf.dlgReset();
- if (cf.isDetailFilterEnabled())
- {
- cf.dlgGlobalSetParm("xxAllowDetail", true);
- }
- cf.dlgSetParm("m", "/" + cf.qs_dir + "/" + sDialogName);
- cf.dlgSetParm("m_tab", sTab);
- cf.dlgSubmit();
- };
- function filterDateRange_execute()
- {
- if((document.f.fromValue[0].checked && !pickerControldateFrom.isValid())||(document.f.toValue[0].checked && !pickerControldateTo.isValid()))
- {
- return;
- }
- submitFilterExpression( buildFilterDateExpression() );
- };
- function filterCommon_isColumHidden(sColId)
- {
- var oMQMgr = goDialogManager.getMiniQueryManager();
- var oCol = oMQMgr.getColumnById(sColId);
- var bHidden = false;
- if (oCol && oCol !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
- {
- bHidden = (oCol.getAttribute("hide") == "layout");
- }
- return bHidden;
- };
- function filterCommon_initBasedOnDatasourceBox()
- {
- var bRetval = false;
- if (cf.isDetailFilterEnabled())
- {
- var bIsColHidden = filterCommon_isColumHidden( cf.dlgGlobalGetParm("xxColName") );
- if (bIsColHidden)
- {
- document.getElementById("displayBasedOn").disabled = true;
- document.f.filterBasedOnDS.disabled = true;
- }
- document.getElementById("displayBasedOn").style.display = "block";
- if (cf.dlgGlobalGetParm('xxBasedOn') == 'details')
- {
- document.f.filterBasedOnDS.checked = false;
- }
- bRetval = document.f.filterBasedOnDS.checked;
- }
- return bRetval;
- };
- function filterDateRange_init(oOptions)
- {
- attachMouseEvents();
- filterCommon_initBasedOnDatasourceBox();
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("filterBasedOnInfoMessage").style.display = "block";
- }
- if (oOptions.bPrompt)
- {
- document.f.promptBox.checked = true;
- }
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(oOptions.bUseAdv ? 565 : 495);
- }
- initNullOptions();
- var x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- var oDateTo = document.getElementById('dateEditBoxdateTo');
- if (oDateTo)
- {
- oDateTo.onclick = toGotFocus;
- oDateTo.onkeypress = toGotFocus;
- oDateTo.onpaste = toGotFocus;
- }
- var oDateFrom = document.getElementById('dateEditBoxdateFrom');
- if (oDateFrom)
- {
- oDateFrom.onclick = fromGotFocus;
- oDateFrom.onkeypress = fromGotFocus;
- oDateFrom.onpaste = fromGotFocus;
- }
- if (pickerControldateFrom && pickerControldateFrom.m_oEditBox && !pickerControldateFrom.m_oEditBox.disabled)
- {
- pickerControldateFrom.m_oEditBox.focus();
- }
-
- document.onclick = cleanUpPage;
- if (document.dateToimgPicker)
- {
- document.dateToimgPicker.onmousedown = toDropDown;
- }
- if (document.dateFromimgPicker)
- {
- document.dateFromimgPicker.onmousedown = fromDropDown;
- }
- };
- function filterDateTimeRange_buildFilterExpression()
- {
- var fe = new cf.CFilterExpression();
- fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- var sFromUseValue = pickerControldateFrom.sGetValue() + (document.f.promptBox.checked ? "T" : " ") + timePickertimeFrom.sGetValue();
- var sFromDisplayValue = pickerControldateFrom.sGetFormatValue() + " " + timePickertimeFrom.sGetFormatValue();
- var sToUseValue = pickerControldateTo.sGetValue() + (document.f.promptBox.checked ? "T" : " ") + timePickertimeTo.sGetValue();
- var sToDisplayValue = pickerControldateTo.sGetFormatValue() + " " + timePickertimeTo.sGetFormatValue();
- if (document.getElementById("textBoxstringValueFrom"))
- {
- if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
- {
- sFromUseValue = substVarValueFrom;
- sFromDisplayValue = textBoxstringValueFrom.sGetFormatValue();
- }
- else if (document.f.fromValue[2].checked == true)
- {
- sFromUseValue = null;
- }
- if (document.f.toValue[1].checked == true && substVarValueTo != null)
- {
- sToUseValue = substVarValueTo;
- sToDisplayValue = textBoxstringValueTo.sGetFormatValue();
- }
- else if (document.f.toValue[2].checked == true)
- {
- sToUseValue = null;
- }
- }
- else
- {
- if (document.f.fromValue[1].checked == true)
- {
- sFromUseValue = null;
- }
- if (document.f.toValue[1].checked == true)
- {
- sToUseValue = null;
- }
- }
- if ( sFromUseValue !== null && sToUseValue !== null && (pickerControldateFrom.m_dDate > pickerControldateTo.m_dDate || (pickerControldateFrom.m_dDate.toString() == pickerControldateTo.m_dDate.toString() && timePickertimeFrom.sGetValue() > timePickertimeTo.sGetValue())) )
- {
-
- tmp = sFromUseValue;
- sFromUseValue = sToUseValue;
- sToUseValue = tmp;
- tmp = sFromDisplayValue;
- sFromDisplayValue = sToDisplayValue;
- sToDisplayValue = tmp;
- }
- if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- fe.setPrompt(promptID);
- var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
- var sPromptValues = oParamManager.getRangePromptValues(
- sFromUseValue,
- sFromDisplayValue,
- sToUseValue,
- sToDisplayValue
- );
- cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
- }
- else
- {
- if (sFromUseValue !== null)
- {
- fe.setFrom(sFromUseValue, sFromDisplayValue);
- }
- if (sToUseValue !== null)
- {
- fe.setTo(sToUseValue, sToDisplayValue);
- }
- }
- return fe;
- };
- function filterDateTimeRange_execute()
- {
- if((document.f.fromValue[0].checked && !pickerControldateFrom.isValid())||(document.f.toValue[0].checked && !pickerControldateTo.isValid())||(document.f.fromValue[0].checked && !timePickertimeFrom.isValid())||(document.f.toValue[0].checked && !timePickertimeTo.isValid()))
- {
- return;
- }
- submitFilterExpression( filterDateTimeRange_buildFilterExpression() );
- };
- function filterDateTimeRange_init(oOptions)
- {
- attachMouseEvents();
- filterCommon_initBasedOnDatasourceBox();
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("filterBasedOnInfoMessage").style.display = "block";
- }
- var x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- if (oOptions.bPrompt)
- {
- document.f.promptBox.checked = true;
- }
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(oOptions.bUseAdv ? 550 : 495);
- }
- initNullOptions();
-
- var oDateFrom = document.getElementById('dateEditBoxdateFrom');
- var oTimeFrom = document.getElementById('timeEditBoxtimeFrom');
- if (oDateFrom)
- {
- oDateFrom.onclick = fromGotFocus;
- oDateFrom.onkeypress = fromGotFocus;
- oDateFrom.onpaste = fromGotFocus;
- }
- if (oTimeFrom)
- {
- oTimeFrom.onclick = fromGotFocus;
- oTimeFrom.onkeypress = fromGotFocus;
- oTimeFrom.onpaste = fromGotFocus;
- }
- var oDateTo = document.getElementById('dateEditBoxdateTo');
- var oTimeTo = document.getElementById('timeEditBoxtimeTo');
- if (oDateTo)
- {
- oDateTo.onclick = toGotFocus;
- oDateTo.onkeypress = toGotFocus;
- oDateTo.onpaste = toGotFocus;
- }
- if (oTimeTo)
- {
- oTimeTo.onclick = toGotFocus;
- oTimeTo.onkeypress = toGotFocus;
- oTimeTo.onpaste = toGotFocus;
- }
- if (pickerControldateFrom && pickerControldateFrom.m_oEditBox && !pickerControldateFrom.m_oEditBox.disabled)
- {
- pickerControldateFrom.m_oEditBox.focus();
- }
-
- document.onclick = cleanUpPage;
- if (document.dateToimgPicker)
- {
- document.dateToimgPicker.onmousedown = toDropDown;
- }
- if (document.dateFromimgPicker)
- {
- document.dateFromimgPicker.onmousedown = fromDropDown;
- }
- };
- function filterDialogCommon_setParmValues()
- {
- var oPC = G_PM_THIS_.getPromptControl('inputList');
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(415);
- var aParams = [];
- for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
- {
- aParams.push(
- createParamValue(
- fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j)),
- fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxPickList", j))
- )
- );
- }
- for (var k = 0; k < cf.dlgGlobalSize("xxSelects"); k += 2)
- {
- aParams.push(
- createParamValue(
- fd_getUseValue(cf.dlgGlobalGetParmAt("xxSelects", k + 1)),
- fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxSelects", k))
- )
- );
- }
- if ( oPC )
- {
- oPC.setParameterValues( aParams );
- }
- }
- if (oPC)
- {
- var elInput = oPC.m_oForm;
- if (elInput && !elInput.disabled)
- {
- elInput.focus();
- }
- }
- };
- function filterDaysBeforeToday_init()
- {
- filterDialogCommon_init();
- var basedOnVal = filterCommon_initBasedOnDatasourceBox();
- filterDialogCommon_setParmValues();
- var hintText = document.getElementById("hintText");
- if (hintText)
- {
- hintText.innerHTML = sXXTodayString + " - " + sXXAllDaysString;
- }
- };
- function filterDaysBeforeToday_buildFilterExpression()
- {
- return filterTypeInStartsEndsContains_buildFilterExpression("daysBeforeToday");
- };
- function filterDaysBeforeToday_execute()
- {
- submitFilterExpression( filterDaysBeforeToday_buildFilterExpression() );
- };
- function filterTypeInCommon_init()
- {
- filterDialogCommon_init();
- var x = document.getElementById("link1");
- var y = document.getElementById("link2");
- var basedOnVal = filterCommon_initBasedOnDatasourceBox();
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
- y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
- }
- else
- {
- x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
- y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
- }
- y.appendChild(document.createTextNode(sFILTER_SEARCH_FOR_VALUES));
- x.appendChild(document.createTextNode(sFILTER_PICK_VALUES));
- filterDialogCommon_setParmValues();
- };
- function filterTypeInExactlyMatches_init()
- {
- filterTypeInCommon_init();
- };
- function filterTypeInExactlyMatches_buildFilterExpression()
- {
- var fe = new cf.CFilterExpression();
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- var oPC = G_PM_THIS_.getPromptControl('inputList');
- var aParamValues = oPC.getParameterValues();
- if (aParamValues.length > 0)
- {
- var promptID = getPromptId();
- if (document.f.promptBox.checked)
- {
- fe.setPrompt(promptID);
- }
-
- var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
- if (sDataType !== "")
- {
- fe.setDataType(sDataType);
- }
- if (document.f.promptBox.checked)
- {
- var promptValues = '<selectChoices>';
- promptValues += oPC.preProcess();
- promptValues += '</selectChoices>';
- cf.updateOrAddPromptParm("p_" + promptID, promptValues);
- }
- else
- {
- for (i = 0; i < aParamValues.length; i++)
- {
- fe.addValue( aParamValues[i].getUseValue(), aParamValues[i].getDisplayValue() );
- }
- }
- }
- else if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- fe.setPrompt(promptID);
- cf.updateOrAddPromptParm("p_" + promptID, '<selectChoices/>');
- onlyPrompt = true;
- }
- fe.setFilterType("exactlyMatches");
- return fe;
- };
- function filterTypeInExactlyMatches_execute()
- {
- submitFilterExpression( filterTypeInExactlyMatches_buildFilterExpression() );
- };
- function filterTypeInMatchesSQLPattern_buildFilterExpression()
- {
- var fe = filterTypeInExactlyMatches_buildFilterExpression();
- fe.setFilterType("isLike");
- return fe;
- };
- function filterTypeInMatchesSQLPattern_execute()
- {
- submitFilterExpression( filterTypeInMatchesSQLPattern_buildFilterExpression() );
- };
- function filterTypeInRange_getExcludeFlag(sBound)
- {
- var sXXNodeName = ( sBound == "from" ? "xxFromNode" : "xxToNode" );
- var sRangeNodeName = ( sBound == "from" ? "start" : "end" );
- var nNode = cf.dlgGlobalGetParm(sXXNodeName);
- var nSelectChoices = cf.dlgGlobalGetParm("xxSelectChoicesNode");
- var bExclude = ( nNode && nNode.getAttribute(cf.gsFE_EXCLUSIVE_ATTR) === "true" );
- if ( !bExclude && nSelectChoices )
- {
- var nNode = nSelectChoices.findChildByName(sRangeNodeName);
- bExclude = (nNode && nNode.getAttribute("inclusive") === "false");
- }
- return bExclude;
- };
- function filterTypeInRange_init()
- {
- filterTypeInCommon_init();
- filterTypeInRange_buildIncludeMenu("from");
- filterTypeInRange_buildIncludeMenu("to");
- };
- function filterTypeInRange_execute()
- {
- submitFilterExpression( filterTypeInRange_buildFilterExpression() );
- };
- function filterTypeInRange_buildFilterExpression()
- {
- var oFE = new cf.CFilterExpression();
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- oFE.setNullOption(no);
- if (no == "only")
- {
- return oFE;
- }
- }
- var sFromUseValue = filterTypeInRange_getValue("from");
- var sToUseValue = filterTypeInRange_getValue("to");
- var bFromInclusive = filterTypeInRange_getInclusive("from");
- var bToInclusive = filterTypeInRange_getInclusive("to");
- if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- oFE.setPrompt(promptID);
-
- var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
- var sPromptValues = oParamManager.getRangePromptValues(
- sFromUseValue,
- sFromUseValue,
- sToUseValue,
- sToUseValue,
- bFromInclusive,
- bToInclusive
- );
- cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
- }
- else
- {
- if (sFromUseValue !== null)
- {
- oFE.setFrom(sFromUseValue, sFromUseValue, !bFromInclusive);
- }
- if (sToUseValue !== null)
- {
- oFE.setTo(sToUseValue, sToUseValue, !bToInclusive);
- }
- }
- if (cf.dlgGlobalGetParm('xxFilterIsString') == true || cf.dlgGlobalGetParm('xxFilterIsString') == null)
- {
- oFE.setDataType('string');
- }
- oFE.setFilterType(cf.gsFE_FILTERTYPE_TYPEINRANGE);
- return oFE;
- };
- function filterTypeInRange_getValue(sName)
- {
- var oRadio = document.getElementById(sName + "Value");
- return ( oRadio && oRadio.checked ? document.f[sName + "TB"].value : null );
- };
- function filterTypeInRange_getInclusive(sPrefix)
- {
- return ( window["filterTypeInRange_inclusive_" + sPrefix] !== false );
- };
- function filterTypeInRange_buildIncludeMenu(sPrefix)
- {
- if (!sPrefix)
- {
- return;
- }
- var sParentDiv = sPrefix + "IncludedDiv";
- var sWebRoot = cf.cfgGet("gsWebRoot");
- var oIncludeButtonStyle = new CUIStyle('includeButton', 'includeButton', 'includeButton', 'includeButton', 'includeButton', 'includeButton');
- var oIncludedFlyoutMenu = new CUIStyle('headerButtonDropDown', 'headerButtonDropDownRollover', 'headerButtonDropDown', 'headerButtonDropDown','headerButtonDropDown');
- var oIncludedMenuItemStyle = new CUIStyle('includeMenuItem_normal', 'includeMenuItem_hover', 'includeMenuItem_pressed', '', 'menuItem_disabled');
- var oIncludedBar = new CBar(sParentDiv, null, null, sWebRoot + '/common/images/toolbar/', '', '', 'qs', 'tt');
- oIncludedBar.setMenuType(cHorizonalBar);
-
- var oIncludedMenuItem = new CQSMenuItem(oIncludedBar, sFILTER_INCLUDED, '', '', oIncludeButtonStyle, sWebRoot, null);
- oIncludedMenuItem.setIconPrecedingText("(");
- oIncludedMenuItem.setIconTrailingText(")");
- oIncludedMenuItem.setDropDownArrow(sWebRoot + "/common/images/toolbar_drop_arrow.gif");
-
- var menuStyle = new CUIStyle('clsMenu', '', '', '', '');
- var oIncludedMenu = oIncludedMenuItem.createDropDownMenu(menuStyle);
- oIncludedMenuItem = new CQSMenuItem(oIncludedMenu, sFILTER_INCLUDE_THE_VALUE, 'filterTypeInRange_includeMenuOnClickHandler("' + sFILTER_INCLUDED + '","'+sPrefix+'",true,this.menuItem);', '', oIncludedMenuItemStyle, sWebRoot, null);
- oIncludedMenuItem = new CQSMenuItem(oIncludedMenu, sFILTER_EXCLUDE_THE_VALUE, 'filterTypeInRange_includeMenuOnClickHandler("' + sFILTER_EXCLUDED + '","'+sPrefix+'",false,this.menuItem);', '', oIncludedMenuItemStyle, sWebRoot, null);
- oIncludedBar.draw();
- if ( filterTypeInRange_getExcludeFlag(sPrefix) )
- {
- filterTypeInRange_includeMenuOnClickHandler( sFILTER_EXCLUDED, sPrefix, false, oIncludedMenuItem );
- }
- return oIncludedMenuItem;
- };
- function filterTypeInRange_includeMenuOnClickHandler(sNewLabel, sPrefix, bInclusive, oMenuItem)
- {
- if ( !oMenuItem )
- {
- oMenuItem = (this ? this.menuItem : null);
- }
- if (oMenuItem && oMenuItem.getParent && oMenuItem.getParent().getParent)
- {
- var menuItemForLabel = oMenuItem.getParent().getParent();
- menuItemForLabel.setLabel(sNewLabel);
- if (menuItemForLabel.getParent && menuItemForLabel.getParent().draw)
- {
- menuItemForLabel.getParent().draw();
- }
- }
- window["filterTypeInRange_inclusive_" + sPrefix] = ( bInclusive !== false );
-
- if (window && window.getSelection && window.getSelection().removeAllRanges)
- {
- window.getSelection().removeAllRanges();
- }
- return true;
- };
- function filterTypeInStartsEndsContains_buildFilterExpression(sFilterType)
- {
- var fe = new cf.CFilterExpression();
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- var oPC = G_PM_THIS_.getPromptControl('inputList');
- var oParamValue = oPC.getParameterValues();
- if (oParamValue)
- {
- var promptID = getPromptId();
- if (document.f.promptBox.checked)
- {
- fe.setPrompt(promptID);
- }
- if (cf.dlgGlobalGetParm('xxFilterIsString') == true || cf.dlgGlobalGetParm('xxFilterIsString') == null)
- {
- fe.setDataType('string');
- }
- if (document.f.promptBox.checked)
- {
- var promptValues = '<selectChoices>';
- promptValues += oPC.preProcess();
- promptValues += '</selectChoices>';
- cf.updateOrAddPromptParm("p_" + promptID, promptValues);
- }
- else
- {
- fe.addValue( oParamValue.use, oParamValue.display );
- }
- fe.setFilterType(sFilterType);
- }
- else if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- fe.setPrompt(promptID);
- cf.updateOrAddPromptParm("p_" + promptID, '<selectChoices/>');
- onlyPrompt = true;
- }
- return fe;
- };
- function filterTypeInStartsEndsContains_execute(sFilterType)
- {
- submitFilterExpression( buildFilterExpression() );
- };
- function createParamValue( sUse, sDisplay )
- {
- var oParam = new C_ParameterValue(
- {
- "n": "selectOption",
- "@useValue": sUse,
- "@displayValue": sDisplay
- }
- );
- return oParam;
- };
- function filterIntervalRange_buildFilterExpression()
- {
- var fe = new cf.CFilterExpression();
- fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
- var firstValDisplay = null;
- var secondValDisplay = null;
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- var firstInterval = intervalControlintervalFrom.sGetInterval();
- var secondInterval = intervalControlintervalTo.sGetInterval();
- var firstIntervalXSD = intervalControlintervalFrom.sGetXSDValue();
- var secondIntervalXSD = intervalControlintervalTo.sGetXSDValue();
- if (document.getElementById("textBoxstringValueFrom"))
- {
- if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
- {
- firstInterval = substVarValueFrom;
- firstValDisplay = textBoxstringValueFrom.sGetFormatValue();
- }
- else if ((firstInterval == '' && firstInterval.length == 0) || document.f.fromValue[2].checked == true)
- {
- firstInterval = sFILTER_LOWEST_VALUE;
- }
- if (document.f.toValue[1].checked == true && substVarValueTo != null)
- {
- secondInterval = substVarValueTo;
- secondValDisplay = textBoxstringValueTo.sGetFormatValue();
- }
- else if ((secondInterval == '' && secondInterval.length == 0) || document.f.toValue[2].checked == true)
- {
- secondInterval = sFILTER_HIGHEST_VALUE;
- }
- }
- else
- {
- if ((firstInterval == '' && firstInterval.length == 0) || document.f.fromValue[1].checked == true)
- {
- firstInterval = sFILTER_LOWEST_VALUE;
- }
- if ((secondInterval == '' && secondInterval.length == 0) || document.f.toValue[1].checked == true)
- {
- secondInterval = sFILTER_HIGHEST_VALUE;
- }
- }
- if (
- (
- (firstInterval != "" && document.f.fromValue[0].checked) &&
- (secondInterval != "" && document.f.toValue[0].checked) ) &&
- (
- (
- parseInt(intervalControlintervalFrom.m_oDays.value,10) > parseInt(intervalControlintervalTo.m_oDays.value,10)
- ) || (
- parseInt(intervalControlintervalFrom.m_oDays.value,10) == parseInt(intervalControlintervalTo.m_oDays.value,10) &&
- parseInt(intervalControlintervalFrom.m_oHours.value,10) > parseInt(intervalControlintervalTo.m_oHours.value,10)
- ) || (
- parseInt(intervalControlintervalFrom.m_oDays.value,10) == parseInt(intervalControlintervalTo.m_oDays.value,10) &&
- parseInt(intervalControlintervalFrom.m_oHours.value,10) == parseInt(intervalControlintervalTo.m_oHours.value,10) &&
- parseInt(intervalControlintervalFrom.m_oMinutes.value,10) > parseInt(intervalControlintervalTo.m_oMinutes.value,10)
- ) || (
- parseInt(intervalControlintervalFrom.m_oDays.value,10) == parseInt(intervalControlintervalTo.m_oDays.value,10) &&
- parseInt(intervalControlintervalFrom.m_oHours.value,10) == parseInt(intervalControlintervalTo.m_oHours.value,10) &&
- parseInt(intervalControlintervalFrom.m_oMinutes.value,10) == parseInt(intervalControlintervalTo.m_oMinutes.value,10) &&
- parseInt(intervalControlintervalFrom.m_oSeconds.value,10) > parseInt(intervalControlintervalTo.m_oSeconds.value,10)
- )
- )
- )
- {
- var tmp = firstInterval;
- firstInterval = secondInterval;
- secondInterval = tmp;
- tmp = firstIntervalXSD;
- firstIntervalXSD = secondIntervalXSD;
- secondIntervalXSD = tmp;
- }
- if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- fe.setPrompt(promptID);
- var promptValues = '<selectChoices>';
- if (firstInterval == sFILTER_LOWEST_VALUE && secondInterval == sFILTER_HIGHEST_VALUE)
- {
- onlyPrompt = true;
- promptValues = '<selectChoices/>';
- }
- else
- {
- if (firstInterval == sFILTER_LOWEST_VALUE)
- {
- promptValues += '<selectUnboundedStartRange selected="true">';
- if (secondValDisplay)
- {
- promptValues += '<end displayValue="' + sXmlEncode(secondValDisplay) + '" useValue="' + sXmlEncode(secondInterval) + '"/>';
- }
- else
- {
- promptValues += '<end displayValue="' + sXmlEncode(secondInterval) + '" useValue="' + sXmlEncode(secondIntervalXSD) + '"/>';
- }
- promptValues += '</selectUnboundedStartRange>';
- }
- else if (secondInterval == sFILTER_HIGHEST_VALUE)
- {
- promptValues += '<selectUnboundedEndRange selected="true">';
- if (firstValDisplay)
- {
- promptValues += '<start displayValue="' + sXmlEncode(firstValDisplay) + '" useValue="' + sXmlEncode(firstInterval) + '"/>';
- }
- else
- {
- promptValues += '<start displayValue="' + sXmlEncode(firstInterval) + '" useValue="' + sXmlEncode(firstIntervalXSD) + '"/>';
- }
- promptValues += '</selectUnboundedEndRange>';
- }
- else if (firstInterval == secondInterval)
- {
- if (firstValDisplay)
- {
- promptValues += '<selectOption displayValue="' + sXmlEncode(firstValDisplay) + '" useValue="' + sXmlEncode(firstInterval) + '" selected="true"/>';
- }
- else
- {
- promptValues += '<selectOption displayValue="' + sXmlEncode(firstInterval) + '" useValue="' + sXmlEncode(firstIntervalXSD) + '" selected="true"/>';
- }
- }
- else
- {
- promptValues += '<selectBoundRange selected="true">';
- if (firstValDisplay)
- {
- promptValues += '<start displayValue="' + sXmlEncode(firstValDisplay) + '" useValue="' + sXmlEncode(firstInterval) + '"/>';
- }
- else
- {
- promptValues += '<start displayValue="' + sXmlEncode(firstInterval) + '" useValue="' + sXmlEncode(firstIntervalXSD) + '"/>';
- }
- if (secondValDisplay)
- {
- promptValues += '<end displayValue="' + sXmlEncode(secondValDisplay) + '" useValue="' + sXmlEncode(secondInterval) + '"/>';
- }
- else
- {
- promptValues += '<end displayValue="' + sXmlEncode(secondInterval) + '" useValue="' + sXmlEncode(secondIntervalXSD) + '"/>';
- }
- promptValues += '</selectBoundRange>';
- }
- promptValues += '</selectChoices>';
- }
- cf.updateOrAddPromptParm("p_" + promptID, promptValues);
- }
- else
- {
- if (firstInterval != sFILTER_LOWEST_VALUE)
- {
- fe.setFrom(firstInterval, (firstValDisplay ? firstValDisplay : firstInterval));
- }
- if (secondInterval != sFILTER_HIGHEST_VALUE)
- {
- fe.setTo(secondInterval, (secondValDisplay ? secondValDisplay : secondInterval));
- }
- }
- return fe;
- };
- function filterIntervalRange_execute()
- {
- if((document.f.fromValue[0].checked && !intervalControlintervalFrom.isValid())||(document.f.toValue[0].checked && !intervalControlintervalTo.isValid()))
- {
- return;
- }
- submitFilterExpression( filterIntervalRange_buildFilterExpression() );
- };
- function filterIntervalRange_init(oOptions)
- {
- attachMouseEvents();
- filterCommon_initBasedOnDatasourceBox();
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("filterBasedOnInfoMessage").style.display = "block";
- }
- if (oOptions.bPrompt)
- {
- document.f.promptBox.checked = true;
- }
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(oOptions.bUseAdv ? 565 : 500);
- }
- var x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- initNullOptions();
-
- filterIntervalRange_initBox(document.f.intervalDaysintervalFrom, fromGotFocus);
- filterIntervalRange_initBox(document.f.intervalHoursintervalFrom, fromGotFocus);
- filterIntervalRange_initBox(document.f.intervalMinutesintervalFrom, fromGotFocus);
- filterIntervalRange_initBox(document.f.intervalSecondsintervalFrom, fromGotFocus);
- filterIntervalRange_initBox(document.f.intervalDaysintervalTo, toGotFocus);
- filterIntervalRange_initBox(document.f.intervalHoursintervalTo, toGotFocus);
- filterIntervalRange_initBox(document.f.intervalMinutesintervalTo, toGotFocus);
- filterIntervalRange_initBox(document.f.intervalSecondsintervalTo, toGotFocus);
- if (document.f && document.f.intervalDaysintervalFrom && !document.f.intervalDaysintervalFrom.disabled)
- {
- document.f.intervalDaysintervalFrom.focus();
- }
- };
- function filterIntervalRange_initBox(oCtrl, oEventHandler)
- {
- if (oCtrl)
- {
- if (oCtrl.value == "")
- {
- oCtrl.value = sFILTER_INTERVAL_DEFAULT_VALUE;
- }
- oCtrl.onclick = oEventHandler;
- oCtrl.onkeypress = oEventHandler;
- oCtrl.onblur = oEventHandler;
- }
- };
- function filterNumRange_buildFilterExpression()
- {
- var fe = new cf.CFilterExpression();
- fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
- onlyPrompt = false;
- var fromValUse = '';
- var fromValDisplay = '';
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- var decimalSeparator = goDialogManager.getMiniQueryManager().getDecimalSeparator();
- if((textBoxtextBoxFrom.sGetValue() != '')&&(document.getElementById("textBoxNumericFrom").style.display != "none"))
- {
- fromValUse = textBoxtextBoxFrom.sGetValue();
- fromValUse = fromValUse.replace("\.", decimalSeparator);
- fromValDisplay = textBoxtextBoxFrom.sGetFormatValue();
- }
- else if ((substVarValueFrom != null)&&(document.getElementById("textBoxStringFrom").style.display != "none"))
- {
- fromValUse = substVarValueFrom.replace("\.", decimalSeparator);
- fromValDisplay = textBoxtextBoxStringFrom.sGetFormatValue();
- }
- var toValUse = '';
- var toValDisplay = '';
- if((textBoxtextBoxTo.sGetValue() != '')&&(document.getElementById("textBoxNumericTo").style.display != "none"))
- {
- toValUse = textBoxtextBoxTo.sGetValue();
- toValUse = toValUse.replace("\.", decimalSeparator);
- toValDisplay = textBoxtextBoxTo.sGetFormatValue();
- }
- else if ((substVarValueTo != null)&&(document.getElementById("textBoxStringTo").style.display != "none"))
- {
- toValUse = substVarValueTo.replace("\.", decimalSeparator);
- toValDisplay = textBoxtextBoxStringTo.sGetFormatValue();
- }
- if (((fromValUse != "" && document.f.fromValue[0].checked)&&(toValUse != "" && document.f.toValue[0].checked))&&(parseFloat(toValUse) < parseFloat(fromValUse)))
- {
- var tmp = fromValUse;
- fromValUse = toValUse;
- toValUse = tmp;
- tmp = fromValDisplay;
- fromValDisplay = toValDisplay;
- toValDisplay = tmp;
- }
- if ((fromValUse == "" && fromValUse.length == 0)|| document.f.fromValue[1].checked == true)
- {
- fromValUse = sFILTER_NUMBER_LOWEST;
- }
- if ((toValUse == "" && toValUse.length == 0) || document.f.toValue[1].checked == true)
- {
- toValUse = sFILTER_NUMBER_HIGHEST;
- }
- if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- fe.setPrompt(promptID);
- var promptValues = '<selectChoices>';
- if ((fromValUse == '<xts:string id="FILTER_NUMBER_LOWEST" encode="javascript"/>' && toValUse == '<xts:string id="FILTER_NUMBER_HIGHEST" encode="javascript"/>') ||
- (fromValUse == sFILTER_NUMBER_LOWEST && toValUse == sFILTER_NUMBER_HIGHEST))
- {
- onlyPrompt = true;
- promptValues = '<selectChoices/>';
- }
- else
- {
- if (fromValUse == sFILTER_NUMBER_LOWEST)
- {
- promptValues += '<selectUnboundedStartRange selected="true">';
- promptValues += '<end displayValue="' + sXmlEncode(toValDisplay) + '" useValue="' + sXmlEncode(toValUse) + '"/>';
- promptValues += '</selectUnboundedStartRange>';
- }
- else if (toValUse == sFILTER_NUMBER_HIGHEST)
- {
- promptValues += '<selectUnboundedEndRange selected="true">';
- promptValues += '<start displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '"/>';
- promptValues += '</selectUnboundedEndRange>';
- }
- else if (fromValUse == toValUse)
- {
- promptValues += '<selectOption displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '" selected="true"/>';
- }
- else
- {
- promptValues += '<selectBoundRange selected="true">';
- promptValues += '<start displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '"/>';
- promptValues += '<end displayValue="' + sXmlEncode(toValDisplay) + '" useValue="' + sXmlEncode(toValUse) + '"/>';
- promptValues += '</selectBoundRange>';
- }
- promptValues += '</selectChoices>';
- }
- cf.updateOrAddPromptParm("p_" + promptID, promptValues);
- }
- else
- {
- if (fromValUse != sFILTER_NUMBER_LOWEST)
- {
- fe.setFrom(fromValUse, (fromValDisplay ? fromValDisplay : fromValUse));
- }
- if (toValUse != sFILTER_NUMBER_HIGHEST)
- {
- fe.setTo(toValUse, (toValDisplay ? toValDisplay : toValUse));
- }
- }
- return fe;
- };
- function filterNumRange_execute()
- {
- if((document.f.fromValue[0].checked && !textBoxtextBoxFrom.isValid())||(document.f.toValue[0].checked && !textBoxtextBoxTo.isValid()))
- {
- return;
- }
- submitFilterExpression( filterNumRange_buildFilterExpression() );
- };
- function filterNumRange_init(oOptions)
- {
- attachMouseEvents();
- var x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- initNullOptions();
- filterCommon_initBasedOnDatasourceBox();
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("filterBasedOnInfoMessage").style.display = "block";
- }
- if (oOptions.bPrompt)
- {
- document.f.promptBox.checked = true;
- }
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(410);
- }
-
- var oTextBoxFrom = document.getElementById('textEditBoxtextBoxFrom');
- if (oTextBoxFrom)
- {
- oTextBoxFrom.onclick = fromGotFocus;
- oTextBoxFrom.onkeypress = fromGotFocus;
- oTextBoxFrom.onpaste = fromGotFocus;
- }
- var oTextBoxTo = document.getElementById('textEditBoxtextBoxTo');
- if (oTextBoxTo)
- {
- oTextBoxTo.onclick = toGotFocus;
- oTextBoxTo.onkeypress = toGotFocus;
- oTextBoxTo.onpaste = toGotFocus;
- }
- if (!textBoxtextBoxFrom.m_oForm.disabled)
- {
- textBoxtextBoxFrom.m_oForm.focus();
- }
- };
- function filterNumSumRange_buildFilterExpression()
- {
- var fe = new cf.CFilterExpression();
- fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
- onlyPrompt = false;
- var fromValUse = '';
- var fromValDisplay = '';
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- var decimalSeparator = goDialogManager.getMiniQueryManager().getDecimalSeparator();
- if((textBoxtextBoxFrom.sGetValue() != '')&&(document.getElementById("textBoxNumericFrom").style.display != "none"))
- {
- fromValUse = textBoxtextBoxFrom.sGetValue();
- fromValUse = fromValUse.replace("\.", decimalSeparator);
- fromValDisplay = textBoxtextBoxFrom.sGetFormatValue();
- }
- else if ((substVarValueFrom != null)&&(document.getElementById("textBoxStringFrom").style.display != "none"))
- {
- fromValUse = substVarValueFrom.replace("\.", decimalSeparator);
- fromValDisplay = textBoxtextBoxStringFrom.sGetFormatValue();
- }
- var toValUse = '';
- var toValDisplay = '';
- if((textBoxtextBoxTo.sGetValue() != '')&&(document.getElementById("textBoxNumericTo").style.display != "none"))
- {
- toValUse = textBoxtextBoxTo.sGetValue();
- toValUse = toValUse.replace("\.", decimalSeparator);
- toValDisplay = textBoxtextBoxTo.sGetFormatValue();
- }
- else if ((substVarValueTo != null)&&(document.getElementById("textBoxStringTo").style.display != "none"))
- {
- toValUse = substVarValueTo.replace("\.", decimalSeparator);
- toValDisplay = textBoxtextBoxStringTo.sGetFormatValue();
- }
- if (((fromValUse != "" && document.f.fromValue[0].checked)&&(toValUse != "" && document.f.toValue[0].checked))&&(parseFloat(toValUse) < parseFloat(fromValUse)))
- {
- var tmp = fromValUse;
- fromValUse = toValUse;
- toValUse = tmp;
- tmp = fromValDisplay;
- fromValDisplay = toValDisplay;
- toValDisplay = tmp;
- }
- if ((fromValUse == "" && fromValUse.length == 0)|| document.f.fromValue[1].checked == true)
- {
- fromValUse = sFILTER_NUMBER_LOWEST;
- }
- if ((toValUse == "" && toValUse.length == 0) || document.f.toValue[1].checked == true)
- {
- toValUse = sFILTER_NUMBER_HIGHEST;
- }
- if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- fe.setPrompt(promptID);
- var promptValues = '<selectChoices>';
- if (fromValUse == sFILTER_NUMBER_LOWEST && toValUse == sFILTER_NUMBER_HIGHEST)
- {
- onlyPrompt = true;
- promptValues = '<selectChoices/>';
- }
- else
- {
- if (fromValUse == sFILTER_NUMBER_LOWEST)
- {
- promptValues += '<selectUnboundedStartRange selected="true">';
- promptValues += '<end displayValue="' + sXmlEncode(toValDisplay) + '" useValue="' + sXmlEncode(toValUse) + '"/>';
- promptValues += '</selectUnboundedStartRange>';
- }
- else if (toValUse == sFILTER_NUMBER_HIGHEST)
- {
- promptValues += '<selectUnboundedEndRange selected="true">';
- promptValues += '<start displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '"/>';
- promptValues += '</selectUnboundedEndRange>';
- }
- else if (fromValUse == toValUse)
- {
- promptValues += '<selectOption displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '" selected="true"/>';
- }
- else
- {
- promptValues += '<selectBoundRange selected="true">';
- promptValues += '<start displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '"/>';
- promptValues += '<end displayValue="' + sXmlEncode(toValDisplay) + '" useValue="' + sXmlEncode(toValUse) + '"/>';
- promptValues += '</selectBoundRange>';
- }
- promptValues += '</selectChoices>';
- }
- cf.updateOrAddPromptParm("p_" + promptID, promptValues);
- }
- else
- {
- if (fromValUse != sFILTER_NUMBER_LOWEST)
- {
- fe.setFrom(fromValUse, (fromValDisplay ? fromValDisplay : fromValUse));
- }
- if (toValUse != sFILTER_NUMBER_HIGHEST)
- {
- fe.setTo(toValUse, (toValDisplay ? toValDisplay : toValUse));
- }
- }
- return fe;
- };
- function filterNumSumRange_execute()
- {
- var oMQMgr = goDialogManager.getMiniQueryManager();
- if((document.f.fromValue[0].checked && !textBoxtextBoxFrom.isValid())||(document.f.toValue[0].checked && !textBoxtextBoxTo.isValid()))
- {
- return;
- }
-
- var fString = filterNumSumRange_buildFilterExpression();
- var summaryValue = filterNumSumRange_getSummaryValue();
- submitFilter(fString, onlyPrompt, summaryValue);
- };
- function filterNumSumRange_getSummaryValue()
- {
- var oMQMgr = goDialogManager.getMiniQueryManager();
-
-
- var summaryValue = !(summarizationValue == "raw" && cf.isDetailFilterEnabled());
- if ( summarizationValue == "summary" )
- {
- summaryValue = document.getElementById("summary").value;
- if (typeof summaryValue == "string" && summaryValue.match(/^\d+$/))
- {
- summaryValue = parseInt(summaryValue, 10);
- }
- summaryValue = oMQMgr.getColumnId(summaryValue);
- }
- return (summaryValue);
- };
- function filterNumSumRange_init(oOptions)
- {
- attachMouseEvents();
- if (oOptions.bPrompt)
- {
- document.f.promptBox.checked = true;
- }
- var x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(420);
- }
- var y = document.createElement("select");
- y.id = "summary";
- if (oOptions.sUnSummarized == "" && cf.dlgGlobalGetParm('xxFilterDependancy'))
- {
- if (oOptions.sNonMeasure == "")
- {
- document.getElementById("displayNonMeasureSumm").style.display = "none";
- document.getElementById("displayMeasureGrp").style.display = "inline";
- document.getElementById("displayMeasureNoGrp").style.display = "none";
- document.getElementById("measureGrp").appendChild(y);
- if (cf.dlgGlobalGetParm('xxBasedOn') == 'summary')
- {
- document.f.summarization1[1].checked = "true";
- }
- else
- {
- y.disabled = "true";
- if ((cf.dlgGlobalGetParm('xxBasedOn') == 'raw') && cf.isDetailFilterEnabled())
- {
- document.f.summarization1[2].checked = "true";
- }
- else
- {
- document.f.summarization1[0].checked = "true";
- }
- }
- if (!cf.isDetailFilterEnabled())
- {
- document.getElementById("displayBasedOn1").style.display = "none";
- document.getElementById("displayBasedOn2").style.display = "none";
- }
- if (cf.isDetailFilterEnabled())
- {
- var oInfoMessage = document.getElementById("filterBasedOnInfoMessage");
- if (oInfoMessage)
- {
- oInfoMessage.style.display = "block";
- }
- }
- }
- else
- {
- document.getElementById("displayNonMeasureSumm").style.display = "inline";
- document.getElementById("displayMeasureGrp").style.display = "none";
- document.getElementById("displayMeasureNoGrp").style.display = "none";
- document.getElementById("nonMeasureSumm").appendChild(y);
- if (cf.dlgGlobalGetParm('xxBasedOn') == 'summary')
- {
- document.f.summarization2[1].checked = "true";
- }
- else
- {
- document.f.summarization2[0].checked = "true";
- }
- }
- if (cf.dlgGlobalGetParm('xxBasedOn') && cf.dlgGlobalGetParm('xxBasedOn') != 'summary')
- {
- y.disabled = "true";
- }
- for (var i = 0; i < cf.dlgGlobalSize('xxFilterDependancy'); i++)
- {
- var label = cf.dlgGlobalGetParmAt('xxFilterDependancy', i);
- var newOption = new Option(label[1], label[0]);
- y.options[y.options.length] = newOption;
- if (cf.dlgGlobalGetParm('xxSummaryOf') == label[0])
- {
- y.options[y.options.length - 1].selected = "true";
- }
- }
- }
- else
- {
- document.getElementById("displayNonMeasureSumm").style.display = "none";
- document.getElementById("displayMeasureGrp").style.display = "none";
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("displayMeasureNoGrp").style.display = "inline";
- if (cf.dlgGlobalGetParm('xxBasedOn') == 'raw')
- {
- document.f.summarization3[1].checked = "true";
- }
- else
- {
- document.f.summarization3[0].checked = "true";
- }
- }
- else
- {
- document.getElementById("displayMeasureNoGrp").style.display = "none";
- }
- }
- summarizationValue = (cf.dlgGlobalGetParm('xxBasedOn') ? cf.dlgGlobalGetParm('xxBasedOn') : "details");
- initNullOptions();
-
- var oTextBoxFrom = document.getElementById('textEditBoxtextBoxFrom');
- if (oTextBoxFrom)
- {
- oTextBoxFrom.onclick = fromGotFocus;
- oTextBoxFrom.onkeypress = fromGotFocus;
- oTextBoxFrom.onpaste = fromGotFocus;
- }
- var oTextBoxTo = document.getElementById('textEditBoxtextBoxTo');
- if (oTextBoxTo)
- {
- oTextBoxTo.onclick = toGotFocus;
- oTextBoxTo.onkeypress = toGotFocus;
- oTextBoxTo.onpaste = toGotFocus;
- }
- if (!textBoxtextBoxFrom.m_oForm.disabled)
- {
- textBoxtextBoxFrom.m_oForm.focus();
- }
- };
- function filterNumSumRange_setState(enabled)
- {
- if (document.getElementById("summary"))
- {
- if (enabled)
- {
- document.getElementById("summary").removeAttribute("disabled");
- }
- else
- {
- document.getElementById("summary").disabled = true;
- }
- }
- return true;
- };
- function filterNumSumRange_setSummVal(val)
- {
- if (summarizationValue != val)
- {
- summarizationValue = val;
- }
-
-
- if (cf.cfgGet("combinedFilters") != null)
- {
- cf.setFilterMode(cf.giFILTERCPLXMODE_PRE_WIZARD);
- }
- };
- function filterPicklist_buildFilterExpression()
- {
- var fe = new cf.CFilterExpression();
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true && cf.isDetailFilterEnabled())
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- if (filterPicklist_someCheckedSomeUnchecked() || document.f.oExcludeSelectedValues.options[1].selected === true)
- {
- var promptID = getPromptId();
- if (document.f.promptBox.checked)
- {
- fe.setPrompt(promptID);
- }
- var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
- if (sDataType !== "")
- {
- fe.setDataType(sDataType);
- }
- var aPromptValues = new Object();
- for (i = 0; i < checkBoxListpList.m_oForm.length; i++)
- {
- if ( checkBoxListpList.m_oForm[i].checked )
- {
- var str = checkBoxListpList.m_oForm[i].value;
- if (document.f.promptBox.checked)
- {
-
- var sDisplayValue = cf.getDisplayValueForOption(checkBoxListpList.m_oForm[i]);
- var sUseValue = str;
- aPromptValues[sUseValue] = sDisplayValue;
- }
- else
- {
- var dv = null;
- if (checkBoxListpList.m_oForm[i].nextSibling && checkBoxListpList.m_oForm[i].nextSibling.nodeType == 3)
- {
- dv = checkBoxListpList.m_oForm[i].nextSibling.nodeValue;
- }
- fe.addValue(str, dv);
- }
- }
- }
- if (document.f.promptBox.checked)
- {
- var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
- var sPromptValues = oParamManager.getOptionPromptValues(aPromptValues);
- cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
- }
- }
- else if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- fe.setPrompt(promptID);
- cf.updateOrAddPromptParm("p_" + promptID, '<selectChoices/>');
- onlyPrompt = true;
- }
- return fe;
- };
- function filterPicklist_execute()
- {
- submitFilterExpression( filterPicklist_buildFilterExpression() );
- };
- function filterPicklist_hideLoading()
- {
- var theDiv = document.getElementById("loadingDiv");
- theDiv.parentNode.removeChild(theDiv);
- };
- function filterPicklist_init(sPromptName, sSearchForLabel, sTypeInLabel)
- {
- attachMouseEvents();
- var x = document.getElementById("link1");
- if (cf.dlgGlobalGetParm('xxIsSearchAllowed') != true)
- {
- x.style.display = "none";
- }
-
- var y = document.getElementById("link2");
- var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
- if (sDataType === "MUN")
- {
- y.style.display = "none";
- }
- var basedOnVal = filterCommon_initBasedOnDatasourceBox();
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("filterBasedOnInfoMessage").style.display = "block";
- }
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
- if (sDataType !== "MUN")
- {
- y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
- }
- }
- else
- {
- x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
- if (sDataType !== "MUN")
- {
- y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
- }
- }
- x.appendChild(document.createTextNode(sSearchForLabel));
- if (y.href)
- {
- y.appendChild(document.createTextNode(sTypeInLabel));
- }
- x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- if (cf.dlgGlobalGetParm('xxPromptState') == true)
- {
- document.f.promptBox.checked = true;
- }
- else if (cf.dlgGlobalGetParm('xxPromptState') == false)
- {
- document.f.promptBox.checked = false;
- }
- else if (sPromptName != "")
- {
- document.f.promptBox.checked = true;
- }
- if (cf && cf.showDialogFrame)
- {
- cf.cfgSet("DialogSize", advClosedSize);
- }
- initNullOptions();
- filterPicklist_sendRequestForList();
- };
- function filterPicklist_processResponse(response)
- {
- hideLoading();
- cf.dlgGlobalSetParm("xxActiveRequest", null);
- if (!cf.checkResponse(response, document, "filterPickList", filterPicklist_sendRequestForList))
- {
- return;
- }
- var bPrompting = false;
- var sReportSpecification = "";
- eval(response);
- if(typeof status != "undefined" && status == "working" && typeof tracking != "undefined" && tracking != "")
- {
- showLoading();
- requestTracking = tracking;
- var url = "m=/" + cf.qs_dir + "/filterPickListRequest.xts&b_action=xts.run&ui.action=wait&m_tracking=";
- url += tracking;
- if (typeof cf.routingServerGroup != "undefined")
- {
- url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
- }
- if (cf.cafContextId != "")
- {
- url += "&ui.cafcontextid=" + cf.cafContextId;
- }
- setTimeout("sendWaitRequest('" + url + "');", 100);
- }
-
-
- if (bPrompting && bPrompting === true)
- {
- sendPromptRequest(sReportSpecification);
- }
- else
- {
-
- requestTracking = "";
- var allCheckBoxes = document.f.p_pickList;
- if (typeof allCheckBoxes != "undefined")
- {
- var numFound = 0;
-
- var convertRangeToCheckBoxes = cf.dlgGlobalGetParm("xxConvertRangeToENUM");
- if (convertRangeToCheckBoxes)
- {
- numFound = filterPicklist_convertRangeToCheckBoxes(allCheckBoxes);
- }
- else
- {
- for (var i = 0; i < allCheckBoxes.length; i++)
- {
- for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
- {
- var useValue = fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j));
- if (allCheckBoxes[i].value.toUpperCase() == useValue.toUpperCase())
- {
- allCheckBoxes[i].checked = true;
- checkBoxListpList.updateSelected(true);
- checkBoxListpList.checkData();
- numFound++;
- break;
- }
- }
- for (var k = 1; k < cf.dlgGlobalSize("xxSelects"); k += 2)
- {
- if (allCheckBoxes[i].value.toUpperCase() == cf.dlgGlobalGetParmAt("xxSelects", k).toUpperCase())
- {
- allCheckBoxes[i].checked = true;
- checkBoxListpList.updateSelected(true);
- checkBoxListpList.checkData();
- numFound++;
- break;
- }
- }
- if (numFound == (cf.dlgGlobalSize("xxPickList") + (cf.dlgGlobalSize("xxSelects") / 2)))
- {
- break;
- }
- }
- }
- }
- cf.dlgGlobalRemoveParm("xxPickListIsLoaded");
- cf.dlgGlobalRemoveParm("xxSelectsIsLoaded");
- }
- };
- function filterPicklist_convertRangeToCheckBoxes(allCheckBoxes)
- {
- var convertFromValue = cf.dlgGlobalGetParm("xxConvertRangeFromValue");
- convertFromValue = convertFromValue.getAttribute("use");
-
-
-
-
- var convertToValue = cf.dlgGlobalGetParm("xxConvertRangeToValue");
- convertToValue = convertToValue.getAttribute("use");
- var isString = false;
- if (isNaN(convertFromValue) || isNaN(convertToValue))
- {
- isString = true;
- }
- if (!isString)
- {
-
-
- for (var i = 0; i < allCheckBoxes.length; i++)
- {
- currentCheckBoxValue = allCheckBoxes[i].value.toUpperCase();
- if (isNaN(currentCheckBoxValue))
- {
- isString = true;
- break;
- }
- }
- }
- if (!isString)
- {
- convertFromValue = +convertFromValue;
- convertToValue = +convertToValue;
- }
- var currentCheckBoxValue;
- var numFound = 0;
- if (convertFromValue && convertToValue)
- {
- for (var i = 0; i < allCheckBoxes.length; i++)
- {
- currentCheckBoxValue = allCheckBoxes[i].value.toUpperCase();
- if (!isString)
- {
- currentCheckBoxValue = +currentCheckBoxValue;
- }
- if ((currentCheckBoxValue >= convertFromValue) && (currentCheckBoxValue <= convertToValue))
- {
- allCheckBoxes[i].checked = true;
- checkBoxListpList.updateSelected(true);
- checkBoxListpList.checkData();
- numFound++;
- }
- }
- }
-
- return numFound;
- };
- function filterPicklist_sendRequestForList()
- {
- sendPicklistRequest();
- };
- function filterPicklist_sendWaitRequest(url)
- {
- cf.sendDispatcherRequest(url, processResponse);
- };
- function filterPicklist_showCancellingIndicator()
- {
- var theDiv = document.getElementById("loadingDiv");
- if(theDiv)
- {
- var oldSpanText = theDiv.getElementsByTagName("SPAN");
- if(oldSpanText.length > 0)
- {
- var newSpanText = document.createElement("SPAN");
- newSpanText.appendChild(document.createTextNode(sCancelIndicator));
- theDiv.replaceChild(newSpanText, oldSpanText[0]);
- }
- }
- };
- function filterPicklist_showLoading()
- {
- var theParent = document.getElementById("selectListpList");
- var newDiv = document.createElement("DIV");
- newDiv.id = "loadingDiv";
- newDiv.className = "clsCheckBox";
- var loadingIcon = document.createElement("IMG");
- loadingIcon.align = "middle";
- loadingIcon.src = cf.TREE_LOADING;
- newDiv.appendChild(loadingIcon);
- var newSpanText = document.createElement("SPAN");
- newSpanText.appendChild(document.createTextNode(PMT_TRE_TREE_LOADING));
- newSpanText.style.paddingLeft = "4px";
- newDiv.appendChild(newSpanText);
- newDiv.style.verticalAlign = "middle";
- newDiv.style.padding = "2px";
- theParent.appendChild(newDiv);
- };
- function filterPicklist_someCheckedSomeUnchecked()
- {
- return ((checkBoxListpList.m_iSelectedCount > 0) && (checkBoxListpList.m_iItemCount > checkBoxListpList.m_iSelectedCount));
- };
- function filterSearch_buildFilterExpression()
- {
- var fe = new cf.CFilterExpression();
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- if (searchpSearch.m_oLstChoices.length > 0)
- {
- var promptID = getPromptId();
- if (document.f.promptBox.checked)
- {
- fe.setPrompt(promptID);
- }
- var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
- if (sDataType !== "")
- {
- fe.setDataType(sDataType);
- }
- var promptValues = '<selectChoices>';
- for (i = 0; i < searchpSearch.m_oLstChoices.length; i++)
- {
- var str = searchpSearch.m_oLstChoices.options[i].value;
- var dv = cf.getDisplayValueForOption(searchpSearch.m_oLstChoices.options[i]);
- if (document.f.promptBox.checked)
- {
- promptValues += '<selectOption displayValue="' + sXmlEncode(dv) + '" useValue="' + sXmlEncode(str) + '" selected="true"/>';
- }
- else
- {
- fe.addValue(str, dv);
- }
- }
- if (document.f.promptBox.checked)
- {
- promptValues += '</selectChoices>';
- cf.updateOrAddPromptParm("p_" + promptID, promptValues);
- }
- }
- else if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- fe.setPrompt(promptID);
- cf.updateOrAddPromptParm("p_" + promptID, '<selectChoices/>');
- onlyPrompt = true;
- }
- fe.setFilterType("search");
- return fe;
- };
- function filterSearch_execute()
- {
- cf.cfgSet("LAST_ACTION", "filterSearchExecute");
- submitFilterExpression( filterSearch_buildFilterExpression() );
- };
- function filterSearch_init()
- {
- attachMouseEvents();
- var x = document.getElementById("link1");
- var y = document.getElementById("link2");
- var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
- if (sDataType === "MUN")
- {
- y.style.display = "none";
- }
- var basedOnVal = filterCommon_initBasedOnDatasourceBox();
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("filterBasedOnInfoMessage").style.display = "block";
- }
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
- if (sDataType !== "MUN")
- {
- y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
- }
- }
- else
- {
- x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
- if (sDataType !== "MUN")
- {
- y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
- }
- }
- x.appendChild(document.createTextNode(sFILTER_PICK_VALUES));
- if (y.href)
- {
- y.appendChild(document.createTextNode(sFILTER_TYPE_IN_VALUES));
- }
- x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- if (cf.dlgGlobalGetParm('xxPromptState') == true)
- {
- document.f.promptBox.checked = true;
- }
- else if (cf.dlgGlobalGetParm('xxPromptState') == false)
- {
- document.f.promptBox.checked = false;
- }
- else if (sXXPromptParam != "")
- {
- document.f.promptBox.checked = true;
- }
- initNullOptions();
- if (sPromptCB!='')
- {
- document.f.promptBox.checked = (sPromptCB == 'true' ? true : false);
- }
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(520);
- if (searchpSearch.m_oLstChoices.options.length == 0)
- {
- var uv = null;
- var dv = null;
- if (cf.dlgGlobalGetParm("xxPickListIsLoaded") != true)
- {
- for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
- {
- uv = fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j));
- dv = fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxPickList", j));
- searchpSearch.addNoUpdate(dv, uv);
- }
- }
- if (cf.dlgGlobalGetParm("xxSelectsIsLoaded") != true)
- {
- for (var k = 0; k < cf.dlgGlobalSize("xxSelects"); k += 2)
- {
- uv = fd_getUseValue(cf.dlgGlobalGetParmAt("xxSelects", k + 1));
- dv = fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxSelects", k));
- searchpSearch.addNoUpdate(dv, uv);
- }
- }
- searchpSearch.update();
- cf.dlgGlobalSetParm("xxPickListIsLoaded", true);
- cf.dlgGlobalSetParm("xxSelectsIsLoaded", true);
- }
- }
- document.f._sws_pSearch_searchValue.focus();
-
-
- if (typeof searchpSearch == "object");
- {
-
- searchpSearch.startAnimateSearchIcon();
- }
- sendSearchRequest(true);
- };
- function filterTimeRange_buildFilterExpression()
- {
- var fe = new cf.CFilterExpression();
- fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
- var fromValDisplay = null;
- var toValDisplay = null;
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- var fromValueString = timePickertimeFrom.sGetValue();
- var toValueString = timePickertimeTo.sGetValue();
- if (document.getElementById("textBoxstringValueFrom"))
- {
- if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
- {
- fromValueString = substVarValueFrom;
- fromValDisplay = textBoxstringValueFrom.sGetFormatValue();
- }
- else if ((fromValueString == '' && fromValueString.length == 0) || (document.f.fromValue[2].checked == true))
- {
- fromValueString = sFILTER_TIME_EARLIEST;
- }
- if (document.f.toValue[1].checked == true && substVarValueTo != null)
- {
- toValueString = substVarValueTo;
- toValDisplay = textBoxstringValueTo.sGetFormatValue();
- }
- else if ((toValueString == '' && toValueString.length == 0) || (document.f.toValue[2].checked == true))
- {
- toValueString = sFILTER_TIME_LATEST;
- }
- }
- else
- {
- if ((fromValueString == '' && fromValueString.length == 0) || document.f.fromValue[1].checked == true)
- {
- fromValueString = sFILTER_TIME_EARLIEST;
- }
- if ((toValueString == '' && toValueString.length == 0) || document.f.toValue[1].checked == true)
- {
- toValueString = sFILTER_TIME_LATEST;
- }
- }
- if (((fromValueString != "" && document.f.fromValue[0].checked)&&(toValueString != "" && document.f.toValue[0].checked))&&(fromValueString > toValueString))
- {
- var tmp = fromValueString;
- fromValueString = toValueString;
- toValueString = tmp;
- }
- if (document.f.promptBox.checked)
- {
- var promptID = getPromptId();
- fe.setPrompt(promptID);
- var promptValues = '<selectChoices>';
- if (fromValueString == sFILTER_TIME_EARLIEST && toValueString == sFILTER_TIME_LATEST)
- {
- onlyPrompt = true;
- promptValues = '<selectChoices/>';
- }
- else
- {
- if (fromValueString == sFILTER_TIME_EARLIEST)
- {
- promptValues += '<selectUnboundedStartRange selected="true">';
- promptValues += '<end displayValue="';
- promptValues += sXmlEncode(toValDisplay ? toValDisplay : toValueString);
- promptValues += '" useValue="' + sXmlEncode(toValueString) + '"/>';
- promptValues += '</selectUnboundedStartRange>';
- }
- else if (toValueString == sFILTER_TIME_LATEST)
- {
- promptValues += '<selectUnboundedEndRange selected="true">';
- promptValues += '<start displayValue="';
- promptValues += sXmlEncode(fromValDisplay ? fromValDisplay : fromValueString);
- promptValues += '" useValue="' + sXmlEncode(fromValueString) + '"/>';
- promptValues += '</selectUnboundedEndRange>';
- }
- else if (fromValueString == toValueString)
- {
- promptValues += '<selectOption displayValue="';
- promptValues += sXmlEncode(fromValDisplay ? fromValDisplay : fromValueString);
- promptValues += '" useValue="' + sXmlEncode(fromValueString) + '" selected="true"/>';
- }
- else
- {
- promptValues += '<selectBoundRange selected="true">';
- promptValues += '<start displayValue="';
- promptValues += sXmlEncode(fromValDisplay ? fromValDisplay : fromValueString);
- promptValues += '" useValue="' + sXmlEncode(fromValueString) + '"/>';
- promptValues += '<end displayValue="';
- promptValues += sXmlEncode(toValDisplay ? toValDisplay : toValueString);
- promptValues += '" useValue="' + sXmlEncode(toValueString) + '"/>';
- promptValues += '</selectBoundRange>';
- }
- promptValues += '</selectChoices>';
- }
- cf.updateOrAddPromptParm("p_" + promptID, promptValues);
- }
- else
- {
- if (fromValueString != sFILTER_TIME_EARLIEST)
- {
- fe.setFrom(fromValueString, (fromValDisplay ? fromValDisplay : fromValueString));
- }
- if (toValueString != sFILTER_TIME_LATEST)
- {
- fe.setTo(toValueString, (toValDisplay ? toValDisplay : toValueString));
- }
- }
- return fe;
- };
- function filterTimeRange_execute()
- {
- if((document.f.fromValue[0].checked && !timePickertimeFrom.isValid())||(document.f.toValue[0].checked && !timePickertimeTo.isValid()))
- {
- return;
- }
- submitFilterExpression( filterTimeRange_buildFilterExpression() );
- };
- function filterTimeRange_init(oOptions)
- {
- attachMouseEvents();
- var x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- initNullOptions();
- filterCommon_initBasedOnDatasourceBox();
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("filterBasedOnInfoMessage").style.display = "block";
- }
- if (oOptions.bPrompt)
- {
- document.f.promptBox.checked = true;
- }
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(oOptions.bUseAdv ? 530 : 460);
- }
-
- var oTimeFrom = document.getElementById('timeEditBoxtimeFrom');
- if (oTimeFrom)
- {
- oTimeFrom.onclick = fromGotFocus;
- oTimeFrom.onkeypress = fromGotFocus;
- oTimeFrom.onpaste = fromGotFocus;
- }
- var oTimeTo = document.getElementById('timeEditBoxtimeTo');
- if (oTimeTo)
- {
- oTimeTo.onclick = toGotFocus;
- oTimeTo.onkeypress = toGotFocus;
- oTimeTo.onpaste = toGotFocus;
- }
- if (timePickertimeFrom && timePickertimeFrom.m_oHours && !timePickertimeFrom.m_oHours.disabled)
- {
- timePickertimeFrom.m_oHours.focus();
- }
- };
- function filterTree_buildFilterExpression()
- {
- var fe = new cf.CFilterExpression();
- onlyPrompt = false;
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- var no = getNullOption();
- fe.setNullOption(no);
- if (no == "only")
- {
- return fe;
- }
- }
- var listSeparator = goDialogManager.getMiniQueryManager().getListSeparator();
- var promptID = getPromptId();
- if (document.f.promptBox.checked)
- {
- fe.setPrompt(promptID);
- }
- fe.setDataType('MUN');
- var promptValues = '<selectChoices>';
- var picklistValue = "";
- var bFirst = true;
- var a = treepList.getSelectionOrder();
- for (i = 0; i < a.length; i++)
- {
- if (document.f.promptBox.checked)
- {
- promptValues += '<selectOption displayValue="' + sXmlEncode(a[i].getName()) +
- '" useValue="' + sXmlEncode(a[i].getValue()) + '" selected="true"/>';
- }
- else
- {
- fe.addValue(a[i].getValue(), a[i].getName());
- }
- }
- if (document.f.promptBox.checked)
- {
- promptValues += '</selectChoices>';
- cf.updateOrAddPromptParm("p_" + promptID, promptValues);
- }
- return fe;
- };
- function filterTree_execute()
- {
- submitFilterExpression( filterTree_buildFilterExpression() );
- };
- function filterTree_init()
- {
- attachMouseEvents();
- var x = document.getElementById("link1");
- if (cf.dlgGlobalGetParm('xxIsSearchAllowed') != true)
- {
- x.style.display = "none";
- }
- var basedOnVal = filterCommon_initBasedOnDatasourceBox();
- if (cf.isDetailFilterEnabled())
- {
- document.getElementById("filterBasedOnInfoMessage").style.display = "block";
- }
- if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
- {
- x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
- }
- else
- {
- x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
- }
- x.appendChild(document.createTextNode(sFILTER_SEARCH_FOR_VALUES));
- x = document.getElementById("colName");
- x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
- if (cf.dlgGlobalGetParm('xxPromptState') == true)
- {
- document.f.promptBox.checked = true;
- }
- else if (cf.dlgGlobalGetParm('xxPromptState') == false)
- {
- document.f.promptBox.checked = false;
- }
- else if (sXXPromptName != "")
- {
- document.f.promptBox.checked = true;
- }
- initNullOptions();
- treepList.setSelectionMode(DISCONTIGUOUS_TREE_SELECTION);
- treepList.setSelectTreeUI(CHECKBOX_TREE);
- treepList.setAllowDragDrop(false);
- treepList.setTrackSelectionOrder(true);
- treepList.setNodesCanHaveChildren(true);
- treepList.setRootNodeShowing(false);
- treepList.setPromptingTree(false);
- treepList.setLoadOnTheFlyFunction(loadFunc);
- treepList.getRootNode().setCanHaveChildren(true);
- if (cf && cf.showDialogFrame)
- {
- cf.showDialogFrame(advClosedSize);
- }
- treepList.setupOuterTable();
-
-
- filterTree_sendRequestForList();
- };
- function loadFunc(loadingNode)
- {
- if (loadingNode.getName() == "root")
- {
- return;
- }
- else
- {
- cf.dlgGlobalSetParm('xxFullColExpression', loadingNode.getValue());
- filterTree_sendRequestForList();
- }
- };
- function filterTree_processResponse(response)
- {
- cf.dlgGlobalSetParm("xxActiveRequest", null);
- if (!cf.checkResponse(response, document, "filterTreeList", filterTree_sendRequestForList))
- {
- return;
- }
-
- var bPrompting = false;
- var sReportSpecification = "";
-
- eval(response);
-
-
- if (bPrompting && bPrompting === true)
- {
- sendPromptRequest(sReportSpecification);
- return;
- }
-
- for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
- {
- var mun = fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j));
- var n = _treenodes[mun];
- if (typeof n == "object" && typeof n.setSelected == "function")
- {
- n.setSelected(true);
- }
- }
- for (var k = 1; k < cf.dlgGlobalSize("xxSelects"); k += 2)
- {
- var mun = cf.dlgGlobalGetParmAt("xxSelects", k);
- var n = _treenodes[mun];
- if (n instanceof CTreeNode)
- {
- n.setSelected(true);
- }
- }
- if(bDrawAll == 'true')
- {
- treepList.removeLoading(treepList.getRootNode());
- treepList.setLoading(false);
- setTimeout("treepList.drawAll()", 100);
- setTimeout("treepList.checkData()", 110);
-
- treepList.getRootNode().m_bRendered = true;
- }
- else
- {
- if(typeof addToNode != "undefined")
- {
- treepList.childrenReadyForNode(_treenodes[addToNode]);
- }
- else
- {
- if(cf.dlgGlobalGetParm('xxFullColExpression') )
- {
- treepList.childrenReadyForNode(_treenodes[cf.dlgGlobalGetParm('xxFullColExpression')]);
- }
- }
-
- }
- };
- function filterTree_sendRequestForList()
- {
- var activeRequest = cf.dlgGlobalGetParm('xxActiveRequest');
- if (activeRequest != null)
- {
- cf.cancelDispatcherRequest(activeRequest);
- }
- var url = "m=/" + cf.qs_dir + "/filterTreeRequest.xts&b_action=xts.run";
- if (cf.dlgGlobalGetParm('xxFullColExpression'))
- {
- url += "&xxFullColExpression=" + encodeURIComponent(cf.dlgGlobalGetParm('xxFullColExpression'));
- }
- if (cf.dlgGlobalGetParm('xxModelName'))
- {
- url += "&xxModelName=" + encodeURIComponent(cf.dlgGlobalGetParm('xxModelName'));
- }
- if (cf.dlgGlobalGetParm('xxColid'))
- {
- url += "&xxColid=" + encodeURIComponent(cf.dlgGlobalGetParm('xxColid'));
- }
- if (cf.dlgGlobalGetParm('xxRetrievePrompt'))
- {
- url += "&xxRetrievePrompt=" + encodeURIComponent(cf.dlgGlobalGetParm('xxRetrievePrompt'));
- }
- if (cf.dlgGlobalGetParm('xxSearchPath'))
- {
- url += "&xxSearchPath=" + encodeURIComponent(cf.dlgGlobalGetParm('xxSearchPath'));
- }
- if (cf.dlgGlobalGetParm('xxFilterItemRef'))
- {
- url += "&xxFilterItemRef=" + encodeURIComponent(cf.dlgGlobalGetParm('xxFilterItemRef'));
- }
- if (cf.dlgGlobalGetParm('xxFilterItemRefExp'))
- {
- url += "&xxFilterItemRefExp=" + encodeURIComponent(cf.dlgGlobalGetParm('xxFilterItemRefExp'));
- }
- if (cf.dlgGlobalGetParm('xxPromptParam'))
- {
- if (isPromptParamAndIdEncoded())
- {
- url += "&xxPromptParam=" + cf.dlgGlobalGetParm('xxPromptParam');
- }
- else
- {
- url += "&xxPromptParam=" + encodeURIComponent(cf.dlgGlobalGetParm('xxPromptParam'));
- }
- }
- for (var i = 0; i < cf.dlgGlobalSize('xxOtherColIds'); i++)
- {
- url += "&xxOtherCols=" + cf.dlgGlobalConstructPairParm(url, encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColIds', i)), encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColExps', i)));
- }
- for (var i = 0; i < cf.dlgGlobalSize('xxPromptCascade'); i++)
- {
- url += "&xxPromptCascade=" + encodeURIComponent(cf.dlgGlobalGetParmAt('xxPromptCascade', i));
- }
- for (var i = 0; i < cf.dlgGlobalSize('xxCreds'); i++)
- {
- url += "&xxCreds=" + encodeURIComponent(cf.dlgGlobalGetParmAt('xxCreds', i));
- }
- for (var i = 0; i < cf.dlgGlobalSize('xxPromptValues'); i++)
- {
- url += "&xxPromptValues=" + encodeURIComponent(cf.dlgGlobalGetParmAt('xxPromptValues', i));
- }
- if (cf.dlgGlobalGetParm('xxExprLocale'))
- {
- url += "&xxExprLocale=" + encodeURIComponent(cf.dlgGlobalGetParm('xxExprLocale'));
- }
- if (cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters() !== null)
- {
- url += "&xxExecutionParameters=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters());
- }
- if (cf.goApplicationManager.getReportManager().getParameterManager().getMetadataParameters() !== null)
- {
- url += "¶meterValues=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getMetadataParameters());
- }
- else if (cf.cfgGet('parameterValues'))
- {
- url += "¶meterValues=" + encodeURIComponent(cf.cfgGet('parameterValues'));
- }
- if (typeof cf.routingServerGroup != "undefined")
- {
- url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
- }
- if (cf.cafContextId != "")
- {
- url += "&ui.cafcontextid=" + cf.cafContextId;
- }
- url += "&depth=2&textBoxControl=treepList";
- if (cf.cfgGet("markup_track") != "undefined")
- {
- url += "&markup_track=" + cf.cfgGet("markup_track");
- }
- cf.dlgGlobalSetParm("xxActiveRequest", cf.sendDispatcherRequest(url, processResponse));
- };
- function getColumnIdFromFCId (sFCId)
- {
- var oMQMgr = goDialogManager.getMiniQueryManager();
-
- if(typeof cf.dialogGlobalValues["xxNewFilter"] != "undefined")
- {
- var oColumn = oMQMgr.getColumnById(sFCId);
- if (oColumn !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
- {
- return sFCId;
- }
- else
- {
- var oCC= cf.getCombinedFilter();
- if(oCC)
- {
- var filterNode=oCC.getFilterById(sFCId);
-
- if(filterNode)
- {
- var cid=filterNode.getColumnId();
- return cid;
- }
- }
- }
- return "";
- }
-
- var oColumn1 = oMQMgr.getColumnFromFilter(sFCId);
- if (oColumn1 !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
- {
- return oColumn1.getAttribute("id");
- }
-
- var oColumn2 = oMQMgr.getColumnById(sFCId);
- if (oColumn2 !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
- {
- return sFCId;
- }
-
- return "";
- };
- function getFilterDataType (sFCId)
- {
- var oMQMgr = goDialogManager.getMiniQueryManager();
- var sColumnId = getColumnIdFromFCId(sFCId);
- var sDataType = "";
- if(sColumnId === "")
- {
-
-
- var sType = oMQMgr.getFilterDataType(sFCId);
- if(sType != oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
- {
- return sType;
- }
- if (cf.dlgGlobalGetParm('xxFilterIsString'))
- {
- sDataType = "string";
- }
- else if (cf.dlgGlobalGetParm('xxUseMUN'))
- {
- sDataType = "MUN";
- }
- return sDataType;
- }
-
- var sPromptFilterItemRef = oMQMgr.getPromptFilterItemRef(sColumnId);
- var sPromptUseItemRef = oMQMgr.getPromptUseItemRef(sColumnId);
- var bPromptFilterRefIsString = oMQMgr.isPromptFilterItemRefString(sColumnId);
- var bPromptUseItemRefIsString = oMQMgr.isPromptUseItemRefString(sColumnId);
- var bColumnIsMUN = oMQMgr.isMUN(sColumnId);
-
-
- var bIsString = cf.dlgGlobalGetParm('xxFilterIsString') && !bColumnIsMUN;
- if (sPromptUseItemRef !== oMQMgr.MINI_QUERY_NONE_STR)
- {
- bIsString = bPromptUseItemRefIsString;
- }
- else if (sPromptFilterItemRef !== oMQMgr.MINI_QUERY_NONE_STR)
- {
- bIsString = bPromptFilterRefIsString;
- }
-
-
-
-
- var aFilters = oMQMgr.getFiltersForColumn(sColumnId);
- for (var key in aFilters)
- {
- try
- {
- var oObject = aFilters[key];
- var sExistingFilterDataType = oObject.getElementsByTagName("FilterExpression")[0].getElementsByTagName("FE")[0].getAttribute("dataType");
- if (sExistingFilterDataType === "string")
- {
- bIsString = true;
- break;
- }
- }
- catch (e)
- {
- }
- }
- if (bIsString)
- {
- sDataType = "string";
- }
- else if (bColumnIsMUN == true && sPromptFilterItemRef === oMQMgr.MINI_QUERY_NONE_STR && sPromptUseItemRef === oMQMgr.MINI_QUERY_NONE_STR)
- {
- sDataType = "MUN";
- }
-
- return sDataType;
- };
- function executeOk(evt)
- {
- var oDialogManager = new CDialogManager();
- if(oDialogManager.isSpaceOrEnterKeyEvent(evt))
- {
- execute();
- }
- };
-
- function executeCancel(evt)
- {
- var oDialogManager = new CDialogManager();
- if(oDialogManager.isSpaceOrEnterKeyEvent(evt))
- {
- typeof this.cancelDialog == 'function' ? this.cancelDialog() : getConfigFrame().hideDialogFrame();
- }
- };
- function sendPromptRequest(sReportSpecification)
- {
-
- var cf = getConfigFrame();
-
-
- sReportSpecification = sReportSpecification.replace(/^\s+|\s+$/,"");
-
-
- var oReportManager = goDialogManager.getApplicationManager().getReportManager();
- var oQSRequest = oReportManager.createRequest("runSpecification");
- oQSRequest.setRequestType("post");
- oQSRequest.addOption("m", "prompting/promptDataSource.xts");
- oQSRequest.addOption("ccs_invoke", "parent");
- oQSRequest.addOption("isEncoded", "1");
- oQSRequest.addOption("specification", sReportSpecification);
- oQSRequest.addOption("b_action", "xts.run");
- oQSRequest.addOption("ui.action", "collectParameterValuesSpecification");
- oQSRequest.addOption("releaseConversation", "1");
-
-
- if (typeof cf.cafContextId === "string")
- {
- oQSRequest.addOption("ui.cafcontextid", cf.cafContextId);
- }
-
-
- if (typeof cf.routingServerGroup === "string")
- {
- oQSRequest.addOption("routingServerGroup", cf.routingServerGroup);
- }
-
-
- oQSRequest.addOption("tracking", oReportManager.getCVObj().getTracking());
- cf.hideDialogFrame();
- oReportManager.sendQSRequest(oQSRequest);
- };
|