filterDialog.js 104 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259226022612262226322642265226622672268226922702271227222732274227522762277227822792280228122822283228422852286228722882289229022912292229322942295229622972298229923002301230223032304230523062307230823092310231123122313231423152316231723182319232023212322232323242325232623272328232923302331233223332334233523362337233823392340234123422343234423452346234723482349235023512352235323542355235623572358235923602361236223632364236523662367236823692370237123722373237423752376237723782379238023812382238323842385238623872388238923902391239223932394239523962397239823992400240124022403240424052406240724082409241024112412241324142415241624172418241924202421242224232424242524262427242824292430243124322433243424352436243724382439244024412442244324442445244624472448244924502451245224532454245524562457245824592460246124622463246424652466246724682469247024712472247324742475247624772478247924802481248224832484248524862487248824892490249124922493249424952496249724982499250025012502250325042505250625072508250925102511251225132514251525162517251825192520252125222523252425252526252725282529253025312532253325342535253625372538253925402541254225432544254525462547254825492550255125522553255425552556255725582559256025612562256325642565256625672568256925702571257225732574257525762577257825792580258125822583258425852586258725882589259025912592259325942595259625972598259926002601260226032604260526062607260826092610261126122613261426152616261726182619262026212622262326242625262626272628262926302631263226332634263526362637263826392640264126422643264426452646264726482649265026512652265326542655265626572658265926602661266226632664266526662667266826692670267126722673267426752676267726782679268026812682268326842685268626872688268926902691269226932694269526962697269826992700270127022703270427052706270727082709271027112712271327142715271627172718271927202721272227232724272527262727272827292730273127322733273427352736273727382739274027412742274327442745274627472748274927502751275227532754275527562757275827592760276127622763276427652766276727682769277027712772277327742775277627772778277927802781278227832784278527862787278827892790279127922793279427952796279727982799280028012802280328042805280628072808280928102811281228132814281528162817281828192820282128222823282428252826282728282829283028312832283328342835283628372838283928402841284228432844284528462847284828492850285128522853285428552856285728582859286028612862286328642865286628672868286928702871287228732874287528762877287828792880288128822883288428852886288728882889289028912892289328942895289628972898289929002901290229032904290529062907290829092910291129122913291429152916291729182919292029212922292329242925292629272928292929302931293229332934293529362937293829392940294129422943294429452946294729482949295029512952295329542955295629572958295929602961296229632964296529662967296829692970297129722973297429752976297729782979298029812982298329842985298629872988298929902991299229932994299529962997299829993000300130023003300430053006300730083009301030113012301330143015301630173018301930203021302230233024302530263027302830293030303130323033303430353036303730383039304030413042304330443045304630473048304930503051305230533054305530563057305830593060306130623063306430653066306730683069307030713072307330743075307630773078307930803081308230833084308530863087308830893090309130923093309430953096309730983099310031013102310331043105310631073108310931103111311231133114311531163117311831193120312131223123312431253126312731283129313031313132313331343135313631373138313931403141314231433144314531463147314831493150315131523153315431553156315731583159316031613162316331643165316631673168316931703171317231733174317531763177317831793180318131823183318431853186318731883189319031913192319331943195319631973198319932003201320232033204320532063207320832093210321132123213321432153216321732183219322032213222322332243225322632273228322932303231323232333234323532363237323832393240324132423243324432453246324732483249325032513252325332543255325632573258325932603261326232633264326532663267326832693270327132723273327432753276327732783279328032813282328332843285328632873288328932903291329232933294329532963297329832993300330133023303330433053306330733083309331033113312331333143315331633173318331933203321332233233324332533263327332833293330333133323333333433353336333733383339334033413342334333443345334633473348334933503351335233533354335533563357335833593360336133623363336433653366336733683369337033713372337333743375337633773378337933803381338233833384338533863387338833893390339133923393339433953396339733983399340034013402340334043405340634073408340934103411341234133414341534163417341834193420342134223423342434253426342734283429343034313432343334343435343634373438343934403441344234433444344534463447344834493450345134523453345434553456345734583459346034613462346334643465346634673468346934703471347234733474347534763477347834793480348134823483348434853486348734883489349034913492349334943495349634973498349935003501350235033504350535063507350835093510351135123513351435153516351735183519352035213522352335243525352635273528352935303531353235333534353535363537353835393540354135423543354435453546354735483549355035513552355335543555355635573558355935603561356235633564356535663567356835693570357135723573357435753576357735783579358035813582358335843585358635873588358935903591359235933594359535963597359835993600360136023603360436053606360736083609361036113612361336143615361636173618361936203621362236233624362536263627362836293630363136323633363436353636363736383639364036413642364336443645364636473648364936503651365236533654365536563657365836593660366136623663366436653666366736683669367036713672367336743675367636773678367936803681368236833684368536863687368836893690369136923693369436953696369736983699370037013702370337043705370637073708370937103711371237133714371537163717371837193720372137223723372437253726372737283729373037313732373337343735373637373738373937403741374237433744374537463747374837493750375137523753375437553756375737583759376037613762376337643765376637673768376937703771377237733774377537763777377837793780378137823783378437853786378737883789379037913792379337943795379637973798379938003801380238033804380538063807380838093810381138123813381438153816381738183819382038213822382338243825382638273828382938303831383238333834383538363837383838393840384138423843384438453846384738483849385038513852385338543855385638573858385938603861386238633864386538663867386838693870387138723873387438753876387738783879388038813882388338843885388638873888388938903891389238933894389538963897389838993900390139023903390439053906390739083909391039113912391339143915391639173918391939203921392239233924392539263927392839293930393139323933393439353936393739383939394039413942394339443945394639473948394939503951395239533954395539563957395839593960396139623963396439653966396739683969397039713972397339743975397639773978397939803981398239833984398539863987398839893990399139923993399439953996399739983999400040014002400340044005400640074008400940104011401240134014401540164017401840194020402140224023402440254026402740284029403040314032403340344035403640374038403940404041404240434044404540464047404840494050405140524053405440554056405740584059406040614062406340644065406640674068406940704071407240734074407540764077407840794080408140824083408440854086408740884089409040914092409340944095409640974098409941004101410241034104410541064107410841094110411141124113411441154116411741184119412041214122412341244125412641274128412941304131413241334134413541364137413841394140414141424143414441454146414741484149415041514152415341544155415641574158415941604161416241634164416541664167416841694170417141724173417441754176417741784179418041814182418341844185418641874188418941904191419241934194419541964197419841994200420142024203420442054206420742084209421042114212421342144215421642174218421942204221422242234224422542264227422842294230423142324233423442354236423742384239424042414242424342444245424642474248424942504251425242534254
  1. /****************************************************************
  2. ** Licensed Materials - Property of IBM
  3. **
  4. ** BI and PM: qs
  5. **
  6. ** (C) Copyright IBM Corp. 2001, 2015
  7. **
  8. ** US Government Users Restricted Rights - Use, duplication or
  9. ** disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
  10. *****************************************************************/
  11. // Copyright (C) 2008 Cognos ULC, an IBM Company. All Rights Reserved.
  12. // 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.
  13. function changeDialog(oSelectElement)
  14. {
  15. if (oSelectElement === null || oSelectElement.options === null || oSelectElement.options.length <= 0)
  16. {
  17. return;
  18. }
  19. var sFilterDialogType = oSelectElement.options[oSelectElement.selectedIndex].value;
  20. if (sFilterDialogType == "")
  21. {
  22. return;
  23. }
  24. var basedOnVal = filterCommon_initBasedOnDatasourceBox();
  25. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  26. {
  27. getConfigFrame().invokeOtherFilterDlg(sFilterDialogType, document.f.promptBox.checked, getNullOption(), basedOnVal, fd_getNOT(), "filterTypeInExactlyMatches");
  28. }
  29. else
  30. {
  31. getConfigFrame().invokeOtherFilterDlg(sFilterDialogType, document.f.promptBox.checked, false, basedOnVal, fd_getNOT(), "filterTypeInExactlyMatches");
  32. }
  33. };
  34. function hideFilterOperation()
  35. {
  36. if (document.f.operation)
  37. {
  38. document.f.operation.style.display = "none";
  39. }
  40. };
  41. function changeDateRangeDialog(oDateRangeElement)
  42. {
  43. var oSelectedElement = oDateRangeElement.options[oDateRangeElement.selectedIndex];
  44. if (oSelectedElement === null)
  45. {
  46. return;
  47. }
  48. var sFilterDialogType = oSelectedElement.value;
  49. if (sFilterDialogType == "")
  50. {
  51. return;
  52. }
  53. if ("filterDaysBeforeToday" == sFilterDialogType)
  54. {
  55. if ("selectDateTime" == complexFilterType)
  56. {
  57. cf.dlgGlobalSetParm("xxPreviousFilter", "filterDateTimeRange");
  58. }
  59. else
  60. {
  61. cf.dlgGlobalRemoveParm("xxPreviousFilter");
  62. }
  63. }
  64. else if ("filterDateRange" == sFilterDialogType && "filterDateTimeRange" == cf.dlgGlobalGetParm("xxPreviousFilter"))
  65. {
  66. oSelectedElement.value = "filterDateTimeRange";
  67. }
  68. changeDialog(oDateRangeElement);
  69. };
  70. function removeExecute()
  71. {
  72. var oBtn = document.getElementById("executeButton");
  73. if (oBtn)
  74. {
  75. oBtn.href = "#";
  76. }
  77. };
  78. function submitFilterExpression(sFE)
  79. {
  80. if (cf.dlgGlobalGetParm("xxConvertENUMToRange"))
  81. {
  82. removeEnumChildrenFromFilter();
  83. }
  84. clearFilterConversionGlobals();
  85. var oMQMgr = goDialogManager.getMiniQueryManager();
  86. var oCol = oMQMgr.getColumnById(cf.dlgGlobalGetParm("xxColName"));
  87. var sDetailAgg = oMQMgr.getDetailAggregate(oCol);
  88. var sSummaryAgg = oMQMgr.getSummaryAggregate(oCol);
  89. if (sSummaryAgg != "none" && (sDetailAgg == "count" || sDetailAgg == "countDistinct"))
  90. {
  91. sFE.m_nNode.setAttribute("postAutoAggregation","true");
  92. }
  93. else
  94. {
  95. sFE.m_nNode.setAttribute("postAutoAggregation","false");
  96. }
  97. if (cf.isDetailFilterEnabled())
  98. {
  99. submitFilter(sFE, onlyPrompt, (document.f.filterBasedOnDS && !document.f.filterBasedOnDS.checked));
  100. }
  101. else
  102. {
  103. submitFilter(sFE, onlyPrompt, true);
  104. }
  105. };
  106. function submitFilter(fString, onlyPrompt, summaryFilter)
  107. {
  108. var cf = getConfigFrame();
  109. var oCC = cf.getCombinedFilter();
  110. if (oCC || cf.getFilterMode() != cf.giFILTERCPLXMODE_SIMPLE)
  111. {
  112. submitComplexFilter(fString, onlyPrompt, summaryFilter);
  113. }
  114. else
  115. {
  116. submitBasicFilter(fString, onlyPrompt, summaryFilter);
  117. }
  118. };
  119. function submitBasicFilter(fString, onlyPrompt, summaryFilter)
  120. {
  121. var cf = getConfigFrame();
  122. if (fString && typeof fString.getXML == 'function')
  123. {
  124. fString = fString.getXML();
  125. }
  126. var bIsNot = (fd_getNOT() == "true");
  127. cf.dofc(fString, onlyPrompt, summaryFilter, bIsNot);
  128. cf.hideDialogFrame();
  129. cf.dlgGlobalReset();
  130. };
  131. function submitComplexFilter(fCondition, onlyPrompt, summaryFilter)
  132. {
  133. var oMQMgr = goDialogManager.getMiniQueryManager();
  134. var cf = getConfigFrame();
  135. var oCC = cf.getCombinedFilter();
  136. var sSummary = "true";
  137. var iMode = cf.getFilterMode();
  138. var oF = null;
  139. var oFG = null;
  140. if (oCC == null)
  141. {
  142. oCC = cf.convertToCombinedFilter();
  143. }
  144. var fString = fCondition;
  145. if (fCondition && typeof fCondition.getXML == 'function')
  146. {
  147. fString = fCondition.getXML();
  148. }
  149. if (fString.length <= 0 || fString == ("[" + getPromptId() + "]"))
  150. {
  151. if (!cf.dlgGlobalGetParm("xxNewFilter"))
  152. {
  153. oF = oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid"));
  154. if (oF)
  155. {
  156. oF.removeSelf();
  157. }
  158. if (iMode == cf.giFILTERCPLXMODE_SIMPLE)
  159. {
  160. cf.addColumnsForReselection();
  161. cf.sendCmd(oCC.getCommand(), "", true);
  162. }
  163. }
  164. if (iMode != cf.giFILTERCPLXMODE_SIMPLE)
  165. {
  166. cf.dlgReset();
  167. if (cf.isDetailFilterEnabled())
  168. {
  169. cf.dlgGlobalSetParm("xxAllowDetail", true);
  170. }
  171. cf.dlgSetParm("m", "/" + cf.qs_dir + "/filterCombine.xts");
  172. var sTab = cf.dlgGlobalGetParm("xxFCtab");
  173. if (!sTab)
  174. {
  175. sTab = (oCC.getCurrentFilterGroup() == oCC.getSummaryFilter() ? 's': 'r');
  176. }
  177. cf.dlgGlobalSetParm("xxFCtab", sTab);
  178. cf.dlgSetParm("m_tab", sTab);
  179. cf.dlgSubmit();
  180. }
  181. else
  182. {
  183. cf.hideDialogFrame();
  184. }
  185. return;
  186. }
  187. if (this.summarizationValue)
  188. {
  189. if (this.summarizationValue == "raw")
  190. {
  191. sSummary = "none";
  192. }
  193. else if (this.summarizationValue == "details")
  194. {
  195. sSummary = "true";
  196. }
  197. else
  198. {
  199. var summaryValue = '';
  200. if ( document.getElementById("summary") )
  201. {
  202. summaryValue = document.getElementById("summary").value;
  203. if (typeof summaryValue == "string" && summaryValue.match(/^\d+$/))
  204. {
  205. summaryValue = parseInt(summaryValue, 10);
  206. }
  207. }
  208. sSummary = oMQMgr.getColumnId(summaryValue);
  209. if (sSummary == oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
  210. {
  211. sSummary = "";
  212. }
  213. }
  214. }
  215. var filterBasedOnDS = document.getElementById("filterBasedOnDS");
  216. if (filterBasedOnDS && filterBasedOnDS.checked && cf.isDetailFilterEnabled())
  217. {
  218. sSummary = "none";
  219. }
  220. var bFilterFromMetadata = (cf.dlgGlobalGetParm("xxFilterFromMetadata") === true);
  221. if (iMode != cf.giFILTERCPLXMODE_SIMPLE || bFilterFromMetadata)
  222. {
  223. if (!cf.cfgGet("combinedFilters_default"))
  224. {
  225. cf.cfgSet("combinedFilters_default", oCC.clone());
  226. }
  227. cf.dlgReset();
  228. if (sSummary == "none")
  229. {
  230. oCC.setFilterView(cf.giFILTERVIEW_RAW);
  231. cf.dlgGlobalSetParm("xxFCtab", "r");
  232. }
  233. else
  234. {
  235. oCC.setFilterView(cf.giFILTERVIEW_SUMMARY);
  236. cf.dlgGlobalSetParm("xxFCtab", "s");
  237. }
  238. if (fCondition && typeof fCondition.setDataItemName == 'function')
  239. {
  240. fCondition.setDataItemName(cf.dlgGlobalGetParm('xxColName'));
  241. }
  242. oF = oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid"));
  243. if (oF == null || cf.dlgGlobalGetParm("xxNewFilter"))
  244. {
  245. var sFID = oCC.generateID();
  246. var selColSize = cf.cfgSize("SelColumns");
  247. var sel = cf.cfgGetAt("SelColumns", 0);
  248. oF = new cf.CFilter(
  249. sFID,
  250. (bFilterFromMetadata ? cf.dlgGlobalGetParm('xxFCid') : oMQMgr.getColumnId(sel)),
  251. cf.gsFILTER_REFTYPE_COLUMN,
  252. this.complexFilterType,
  253. fCondition,
  254. sSummary,
  255. (bFilterFromMetadata ? cf.dlgGlobalGetParm('xxFullColExpression') : fCondition)
  256. );
  257. oF.setNot(fd_getNOT());
  258. oCC.getCurrentFilterGroup().addPredicate(oF);
  259. oF.setDirty();
  260. }
  261. else if (oF != null)
  262. {
  263. oF.setCondition(fCondition);
  264. oF.setSummary(sSummary);
  265. oF.setNot(fd_getNOT());
  266. oFG = oCC.getCurrentFilterGroup();
  267. if (oFG.getFilterById(cf.dlgGlobalGetParm("xxFCid")) == null)
  268. {
  269. oF.removeSelf();
  270. oFG.addPredicate(oF);
  271. }
  272. }
  273. if (cf.dlgGlobalGetParm("xxFCtab") != null)
  274. {
  275. cf.dlgSetParm("m_tab", cf.dlgGlobalGetParm("xxFCtab"));
  276. }
  277. if (cf.isDetailFilterEnabled())
  278. {
  279. cf.dlgGlobalSetParm("xxAllowDetail", true);
  280. }
  281. cf.dlgSetParm("m", "/" + cf.qs_dir + "/filterCombine.xts");
  282. cf.dlgSubmit();
  283. }
  284. else
  285. {
  286. oF = (oCC ? oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid")) : null);
  287. if (oF)
  288. {
  289. oF.setCondition(fCondition);
  290. oF.setSummary(sSummary);
  291. oF.setNot(fd_getNOT());
  292. oCC.setFilterView(sSummary == "none" ? cf.giFILTERVIEW_RAW : cf.giFILTERVIEW_SUMMARY);
  293. oFG = oCC.getCurrentFilterGroup();
  294. if (oFG.getFilterById(cf.dlgGlobalGetParm("xxFCid")) == null)
  295. {
  296. oF.removeSelf();
  297. oFG.addPredicate(oF);
  298. }
  299. cf.addColumnsForReselection();
  300. cf.sendCmd(oCC.getCommand(), "", true);
  301. cf.hideDialogFrame();
  302. }
  303. cf.dlgGlobalReset();
  304. }
  305. };
  306. function cancelDialog()
  307. {
  308. if (cf.dlgGlobalGetParm("xxConvertENUMToRange"))
  309. {
  310. cancelEnumToRangeConversion();
  311. }
  312. clearFilterConversionGlobals();
  313. var oAppFrame = getAppFrame();
  314. if (oAppFrame !== null)
  315. {
  316. if (oAppFrame.getFilterMode() == oAppFrame.giFILTERCPLXMODE_WIZARD)
  317. {
  318. oAppFrame.dlgReset();
  319. if (oAppFrame.isDetailFilterEnabled())
  320. {
  321. oAppFrame.dlgGlobalSetParm("xxAllowDetail", true);
  322. }
  323. oAppFrame.dlgSetParm("m", "/" + oAppFrame.qs_dir + "/filterCombine.xts");
  324. if (oAppFrame.dlgGlobalGetParm("xxFCtab"))
  325. {
  326. oAppFrame.dlgSetParm("m_tab", oAppFrame.dlgGlobalGetParm("xxFCtab"));
  327. }
  328. oAppFrame.dlgSubmit();
  329. }
  330. else
  331. {
  332. if(typeof requestTracking != "undefined" && requestTracking != "")
  333. {
  334. if(typeof showCancellingIndicator != "undefined")
  335. {
  336. showCancellingIndicator();
  337. }
  338. var urlParams = "b_action=xts.run&m=portal/om-request.xts&ui.action=cancel";
  339. urlParams += "&m_tracking=" + encodeURIComponent(requestTracking);
  340. requestTracking = "";
  341. oAppFrame.sendDispatcherRequest(urlParams, cancelResponse);
  342. }
  343. else
  344. {
  345. oAppFrame.dlgReset();
  346. oAppFrame.dlgGlobalReset();
  347. oAppFrame.hideDialogFrame();
  348. }
  349. }
  350. }
  351. };
  352. function clearFilterConversionGlobals()
  353. {
  354. cf.dlgGlobalRemoveParm("xxConvertRangeToENUM");
  355. cf.dlgGlobalRemoveParm("xxConvertRangeFromValue");
  356. cf.dlgGlobalRemoveParm("xxConvertRangeToValue");
  357. cf.dlgGlobalRemoveParm("xxConvertENUMToRange");
  358. };
  359. function cancelEnumToRangeConversion()
  360. {
  361. var nFilterElement = getFilterElement();
  362. if (nFilterElement)
  363. {
  364. var fromNode = getChildNodeByName(nFilterElement, cf.gsFE_FROM_NODE);
  365. if (fromNode)
  366. {
  367. nFilterElement.removeChild(fromNode);
  368. }
  369. var toNode = getChildNodeByName(nFilterElement, cf.gsFE_TO_NODE);
  370. if (toNode)
  371. {
  372. nFilterElement.removeChild(toNode);
  373. }
  374. nFilterElement.setAttribute(cf.gsFE_FILTERTYPE_ATTR, cf.gsFE_FILTERTYPE_ENUM);
  375. }
  376. };
  377. function removeEnumChildrenFromFilter()
  378. {
  379. var nFilterElement = getFilterElement();
  380. if (nFilterElement)
  381. {
  382. var childNode;
  383. var childNodeName;
  384. for (var iChild=nFilterElement.childNodes.length-1; iChild>=0; iChild--)
  385. {
  386. childNode = nFilterElement.childNodes[iChild];
  387. if (typeof childNode.baseName != "undefined")
  388. {
  389. childNodeName = childNode.baseName;
  390. }
  391. else
  392. {
  393. childNodeName = childNode.localName;
  394. }
  395. if (childNodeName === cf.gsFE_VALUE_NODE)
  396. {
  397. nFilterElement.removeChild(childNode);
  398. }
  399. }
  400. }
  401. };
  402. function getFilterElement()
  403. {
  404. var nFilterElement;
  405. var nFilter;
  406. var oFilter;
  407. var cf = getConfigFrame();
  408. var oCC = cf.getCombinedFilter();
  409. if (oCC == null)
  410. {
  411. var oMQMgr = goDialogManager.getMiniQueryManager();
  412. var aFilters = oMQMgr.getFiltersForColumn(cf.dlgGlobalGetParm("xxFCid"));
  413. if (aFilters)
  414. {
  415. oFilter = aFilters[0];
  416. }
  417. }
  418. else if (oCC)
  419. {
  420. oFilter = oCC.getFilterById(cf.dlgGlobalGetParm("xxFCid"));
  421. }
  422. if (oFilter)
  423. {
  424. nFilter = (oFilter.m_nNode ? oFilter.m_nNode : oFilter);
  425. }
  426. if (nFilter)
  427. {
  428. nFilterElement = getChildNodeByName(nFilter, cf.gsFE_NODE);
  429. }
  430. return nFilterElement;
  431. };
  432. function getChildNodeByName(node, nodeName)
  433. {
  434. var ii;
  435. var childNode;
  436. var childNodeName;
  437. if (node)
  438. {
  439. for (ii = 0; ii < node.childNodes.length; ii++)
  440. {
  441. if (typeof node.childNodes[ii].baseName != "undefined")
  442. {
  443. childNodeName = node.childNodes[ii].baseName;
  444. }
  445. else
  446. {
  447. childNodeName = node.childNodes[ii].localName;
  448. }
  449. if (nodeName === childNodeName)
  450. {
  451. childNode = node.childNodes[ii];
  452. break;
  453. }
  454. if (node.childNodes[ii].hasChildNodes())
  455. {
  456. childNode = getChildNodeByName(node.childNodes[ii], nodeName);
  457. if (childNode)
  458. {
  459. break;
  460. }
  461. }
  462. }
  463. }
  464. return childNode;
  465. };
  466. function cancelResponse(response)
  467. {
  468. cf.dlgReset();
  469. cf.dlgGlobalReset();
  470. cf.hideDialogFrame();
  471. };
  472. function cleanUpPage()
  473. {
  474. pickerControldateFrom.m_oDatePickerDialog.hidePicker();
  475. pickerControldateTo.m_oDatePickerDialog.hidePicker();
  476. };
  477. function toDropDown()
  478. {
  479. pickerControldateFrom.m_oDatePickerDialog.hidePicker();
  480. toGotFocus();
  481. };
  482. function fromDropDown()
  483. {
  484. pickerControldateTo.m_oDatePickerDialog.hidePicker();
  485. fromGotFocus();
  486. };
  487. function fromGotFocus()
  488. {
  489. document.f.fromValue[0].checked = true;
  490. };
  491. function toGotFocus()
  492. {
  493. document.f.toValue[0].checked = true;
  494. };
  495. function catchSubmit(iKeyCode)
  496. {
  497. if (iKeyCode == 13)
  498. {
  499. execute();
  500. }
  501. };
  502. function updateBasedOn()
  503. {
  504. if (cf.getCombinedFilter() != null)
  505. {
  506. cf.setFilterMode(cf.giFILTERCPLXMODE_PRE_WIZARD);
  507. }
  508. };
  509. function getPromptId()
  510. {
  511. if (isPromptParamAndIdEncoded())
  512. {
  513. return decodeURIComponent(cf.dlgGlobalGetParm("xxPromptID"));
  514. }
  515. return cf.dlgGlobalGetParm("xxPromptID");
  516. };
  517. function isPromptParamAndIdEncoded()
  518. {
  519. if (cf.dlgGlobalGetParm("xxPromptParamAndIDEncoded"))
  520. {
  521. return true;
  522. }
  523. return false;
  524. };
  525. function addNullOptionToFilter(fs, di, opt)
  526. {
  527. if (getConfigFrame().dlgGlobalGetParm('xxIsNullAllowed') == true && opt)
  528. {
  529. if (opt == 'include')
  530. {
  531. if ((fs != "")&&(fs != di))
  532. {
  533. fs += " or " + di + " is null";
  534. }
  535. }
  536. else if (opt == 'exclude')
  537. {
  538. if ((fs == "")||(fs == di))
  539. {
  540. fs = di + " is not null";
  541. }
  542. else
  543. {
  544. fs += " and " + di + " is not null";
  545. }
  546. }
  547. else if (opt == 'only')
  548. {
  549. fs = di + " is null";
  550. }
  551. }
  552. return fs;
  553. };
  554. function showNullOptions(bShow)
  555. {
  556. var cf = getConfigFrame();
  557. var ds = cf.cfgGet("DialogSize");
  558. var dsDefined = true;
  559. var advOptionSize = 40;
  560. if (ds == 0 || typeof ds == 'undefined' || ds == null)
  561. {
  562. dsDefined = false;
  563. }
  564. if (bShow)
  565. {
  566. document.getElementById('QsdlgVisibleNullOptions').style.display = 'block';
  567. document.getElementById('QsdlgHiddenNullOptions').style.display = 'none';
  568. if (dsDefined)
  569. {
  570. ds += advOptionSize;
  571. cf.showDialogFrame(ds);
  572. }
  573. }
  574. else
  575. {
  576. document.getElementById('QsdlgVisibleNullOptions').style.display = 'none';
  577. document.getElementById('QsdlgHiddenNullOptions').style.display = 'block';
  578. if (dsDefined)
  579. {
  580. ds -= advOptionSize;
  581. cf.showDialogFrame(ds);
  582. }
  583. }
  584. updateNullOptionText();
  585. };
  586. function updateNullOptionText()
  587. {
  588. var d = document.getElementById('nullOptionText');
  589. if (d)
  590. {
  591. d.innerHTML = document.f.QsdlgNullOptions.options[document.f.QsdlgNullOptions.selectedIndex].innerHTML;
  592. }
  593. update_NOC();
  594. };
  595. function getNullOption()
  596. {
  597. return document.f.QsdlgNullOptions.options[document.f.QsdlgNullOptions.selectedIndex].value;
  598. };
  599. function setNullOption(opt)
  600. {
  601. switch(opt)
  602. {
  603. case 'only':
  604. document.f.QsdlgNullOptions.selectedIndex = 3;
  605. break;
  606. case 'exclude':
  607. case 'false':
  608. document.f.QsdlgNullOptions.selectedIndex = 2;
  609. break;
  610. case 'include':
  611. case 'true':
  612. document.f.QsdlgNullOptions.selectedIndex = 1;
  613. break;
  614. default:
  615. document.f.QsdlgNullOptions.selectedIndex = 0;
  616. break;
  617. }
  618. updateNullOptionText();
  619. };
  620. function update_NOC()
  621. {
  622. set_NOC_disable('nocOnly',false);
  623. switch (document.f.QsdlgNullOptions.selectedIndex)
  624. {
  625. case 1:
  626. break;
  627. case 2:
  628. break;
  629. case 3:
  630. set_NOC_disable('nocOnly', true);
  631. break;
  632. default:
  633. break;
  634. }
  635. };
  636. function set_NOC_disable(type, state)
  637. {
  638. var a = document.getElementsByTagName("span");
  639. for (var i=0; i < a.length; i++)
  640. {
  641. if (a[i].getAttribute(type))
  642. {
  643. set_NOC_Children(a[i], state);
  644. }
  645. }
  646. };
  647. function set_NOC_Children(o, state)
  648. {
  649. if (o == null)
  650. {
  651. return;
  652. }
  653. if (state && typeof o.setAttribute == 'function')
  654. {
  655. o.setAttribute('disabled', 'disabled');
  656. }
  657. if (!state && typeof o.removeAttribute == 'function')
  658. {
  659. o.removeAttribute('disabled');
  660. }
  661. try
  662. {
  663. o.disabled = state;
  664. }
  665. catch(e)
  666. {}
  667. var c = o.firstChild;
  668. while (c)
  669. {
  670. set_NOC_Children(c, state);
  671. c = c.nextSibling;
  672. }
  673. };
  674. function initNullOptions()
  675. {
  676. var cf = getConfigFrame();
  677. if (cf !== null)
  678. {
  679. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true && cf.isDetailFilterEnabled())
  680. {
  681. showNullOptions(false);
  682. if (cf.dlgGlobalGetParm('xxNullOption') != "")
  683. {
  684. setNullOption(cf.dlgGlobalGetParm('xxNullOption'));
  685. }
  686. }
  687. else
  688. {
  689. cf.showDialogFrame(400);
  690. }
  691. }
  692. var oPC = (G_PM_THIS_ ? G_PM_THIS_.getPromptControl('inputList') : null);
  693. if (oPC)
  694. {
  695. oPC.setExclusive( (cf.dlgGlobalGetParm('xxNOT') == 'true') );
  696. }
  697. if (document.f && document.f.oExcludeSelectedValues && document.f.oExcludeSelectedValues.options)
  698. {
  699. document.f.oExcludeSelectedValues.options[(cf.dlgGlobalGetParm('xxNOT') == 'true' ? 1 : 0)].selected = true;
  700. }
  701. };
  702. function sendPicklistRequest()
  703. {
  704. showLoading();
  705. var activeRequest = cf.dlgGlobalGetParm('xxActiveRequest');
  706. if (activeRequest != null)
  707. {
  708. cf.cancelDispatcherRequest(activeRequest);
  709. }
  710. var oMQMgr = goDialogManager.getMiniQueryManager();
  711. for (var i = 0; i < oMQMgr.getAllColumns().length; i++)
  712. {
  713. if((oMQMgr.isMeasure(i) === false) && (!oMQMgr.isReportExpression(i)))
  714. {
  715. var bIdAlreadySet = false;
  716. for (var j = 0; j < cf.dlgGlobalSize('xxOtherColIds'); j++)
  717. {
  718. if (oMQMgr.getColumnId(i) == cf.dlgGlobalGetParmAt('xxOtherColIds', j))
  719. {
  720. bIdAlreadySet = true;
  721. break;
  722. }
  723. }
  724. if (!bIdAlreadySet)
  725. {
  726. cf.dlgGlobalSetParmAt("xxOtherColIds", cf.dlgGlobalSize('xxOtherColIds'), oMQMgr.getColumnId(i));
  727. cf.dlgGlobalSetParmAt("xxOtherColExps", cf.dlgGlobalSize('xxOtherColExps'), oMQMgr.getExpression(i));
  728. }
  729. else
  730. {
  731. bIdAlreadySet = false;
  732. }
  733. }
  734. }
  735. var url = "m=/" + cf.qs_dir + "/filterPickListRequest.xts&b_action=xts.run";
  736. url += buildUrlFromGlobalParms();
  737. if (typeof cf.routingServerGroup != "undefined")
  738. {
  739. url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
  740. }
  741. if (cf.dlgGetParm('productLocale'))
  742. {
  743. url += "&productLocale=" + encodeURIComponent(cf.dlgGetParm('productLocale'));
  744. }
  745. url += "&xxListSeparator=" + encodeURIComponent(goDialogManager.getMiniQueryManager().getListSeparator());
  746. if (cf.cafContextId != "")
  747. {
  748. url += "&ui.cafcontextid=" + cf.cafContextId;
  749. }
  750. url += "&textBoxControl=checkBoxListpList";
  751. if (cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters() !== null)
  752. {
  753. url += "&xxExecutionParameters=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters());
  754. }
  755. if (cf.cfgGet("markup_track") != "undefined")
  756. {
  757. url += "&markup_track=" + cf.cfgGet("markup_track");
  758. }
  759. cf.dlgGlobalSetParm("xxActiveRequest", cf.sendDispatcherRequest(url, processResponse));
  760. };
  761. function buildUrlFromGlobalParms()
  762. {
  763. var aURL = [];
  764. var aKeys = cf.dlgGlobalKeys();
  765. aKeys = [
  766. 'searchConversation',
  767. 'searchTracking',
  768. 'xxCalcOp',
  769. 'xxColid',
  770. 'xxCreds',
  771. 'xxDesignMode',
  772. 'xxExprLocale',
  773. 'xxFilterItemRef',
  774. 'xxFilterItemRefExp',
  775. 'xxFullColExpression',
  776. 'xxHun',
  777. 'xxIsAttribute',
  778. 'xxIsNullAllowed',
  779. 'xxLevelNumber',
  780. 'xxModelName',
  781. 'xxOtherColIds',
  782. 'xxPromptCascade',
  783. 'xxPromptParam',
  784. 'xxPromptValues',
  785. 'xxRetrievePrompt',
  786. 'xxSearchPath',
  787. 'xxUseItemRef',
  788. 'xxUseItemRefExp',
  789. 'xxDisplayItemRef',
  790. 'xxDisplayItemRefExp',
  791. 'xxFilteredColId',
  792. 'xxFilteredColExpression',
  793. 'xxUseMUN',
  794. 'xxExecutionParameters'
  795. ];
  796. var idxKey;
  797. var sAmpersand = "&";
  798. var sEquals = "=";
  799. for(idxKey = 0; idxKey < aKeys.length; idxKey++)
  800. {
  801. var sKey = aKeys[idxKey];
  802. var iSize = cf.dlgGlobalSize(sKey);
  803. if (iSize > 0)
  804. {
  805. if (sKey == 'xxOtherColIds')
  806. {
  807. var url = "";
  808. for (var i = 0; i < cf.dlgGlobalSize('xxOtherColIds'); i++)
  809. {
  810. url += "&xxOtherCols=" + cf.dlgGlobalConstructPairParm(url, encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColIds', i)), encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColExps', i)));
  811. }
  812. aURL.push(url);
  813. }
  814. else
  815. {
  816. for (var i = 0; i < iSize; i++)
  817. {
  818. aURL.push(sAmpersand);
  819. aURL.push(sKey);
  820. aURL.push(sEquals);
  821. aURL.push(encodeURIComponent(cf.dlgGlobalGetParmAt(sKey, i)));
  822. }
  823. }
  824. }
  825. else if (cf.dlgGlobalGetParm(sKey))
  826. {
  827. aURL.push(sAmpersand);
  828. aURL.push(sKey);
  829. aURL.push(sEquals);
  830. aURL.push(encodeURIComponent(cf.dlgGlobalGetParm(sKey)));
  831. }
  832. }
  833. return aURL.join('');
  834. };
  835. function sendSearchRequest(bInit)
  836. {
  837. if (!bInit && promptsRetrieved == false)
  838. {
  839. return;
  840. }
  841. var activeRequest = cf.dlgGlobalGetParm('xxActiveRequest');
  842. if (activeRequest != null)
  843. {
  844. cf.cancelDispatcherRequest(activeRequest);
  845. }
  846. var url = "m=/" + cf.qs_dir + "/filterSearchRequest.xts&b_action=xts.run";
  847. url += "&_sws_pSearch_searchValue=" + encodeURIComponent(document.f._sws_pSearch_searchValue.value);
  848. url += "&_sws_pSearch_matchAnywhere=" + document.f._sws_pSearch_matchAnywhere.value;
  849. url += "&_sws_pSearch_matchAll=" + document.f._sws_pSearch_matchAll.value;
  850. url += "&_sws_pSearch_caseInsensitive=" + document.f._sws_pSearch_caseInsensitive.value;
  851. url += "&_sws_pSearch_submit=true";
  852. url += "&_promptIdBasedNames=true";
  853. if (cf.cafContextId != "")
  854. {
  855. url += "&ui.cafcontextid=" + cf.cafContextId;
  856. }
  857. if (bInit)
  858. {
  859. cf.dlgGlobalRemoveParm("searchConversation");
  860. cf.dlgGlobalRemoveParm("searchTracking");
  861. }
  862. else
  863. {
  864. url += "&_promptControl=search";
  865. }
  866. var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
  867. var sStoredExpr = cf.dlgGlobalGetParm('xxFullColExpression');
  868. if (sDataType === "MUN" && sStoredExpr.substring(0, 8) === "children" )
  869. {
  870. cf.dlgGlobalSetParm('xxFullColExpression', "caption(" + cf.dlgGlobalGetParm('xxFullColExpression') + ")");
  871. }
  872. url += buildUrlFromGlobalParms();
  873. cf.dlgGlobalSetParm('xxFullColExpression', sStoredExpr);
  874. if (typeof cf.routingServerGroup != "undefined")
  875. {
  876. url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
  877. }
  878. if (promptsRetrieved != false)
  879. {
  880. url = url.replace(/&xxRetrievePrompt=[^&]*/gi, '');
  881. url = url.replace(/&xxSearchPath=[^&]*/gi, '');
  882. }
  883. url += "&textBoxControl=searchpSearch";
  884. if (cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters() !== null)
  885. {
  886. url += "&xxExecutionParameters=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters());
  887. }
  888. if (cf.cfgGet("markup_track") != "undefined")
  889. {
  890. url += "&markup_track=" + cf.cfgGet("markup_track");
  891. }
  892. cf.dlgGlobalSetParm("xxActiveRequest", cf.sendDispatcherRequest(url, processSearchResponse));
  893. };
  894. function processSearchResponse(response)
  895. {
  896. promptsRetrieved = true;
  897. cf.dlgGlobalSetParm("xxActiveRequest", null);
  898. searchpSearch.stopAnimateSearchIcon();
  899. if (cf.cfgGet("LAST_ACTION") == "" || cf.cfgGet("LAST_ACTION") != "filterSearchExecute")
  900. {
  901. if (!cf.checkResponse(response, document, "filterSearchInit", filterSearch_init))
  902. {
  903. return;
  904. }
  905. }
  906. else
  907. {
  908. if (!cf.checkResponse(response, document, "filterSearchExecute", filterSearch_execute))
  909. {
  910. return;
  911. }
  912. }
  913. var bPrompting = false;
  914. var sReportSpecification = "";
  915. try
  916. {
  917. eval(response);
  918. if (bPrompting && bPrompting === true)
  919. {
  920. sendPromptRequest(sReportSpecification);
  921. }
  922. }
  923. catch(e)
  924. {
  925. }
  926. };
  927. function fd_getUseValue(obj)
  928. {
  929. var sRetVal = "";
  930. if (obj)
  931. {
  932. if ( typeof obj == "string" )
  933. {
  934. sRetVal = obj;
  935. }
  936. else if( typeof obj.getUse == "function" )
  937. {
  938. sRetVal = obj.getUse();
  939. }
  940. else if( obj.nodeType || typeof obj.getAttribute == "function" )
  941. {
  942. sRetVal = obj.getAttribute("use");
  943. }
  944. }
  945. return sRetVal;
  946. };
  947. function fd_getDisplayValue(obj)
  948. {
  949. if (typeof obj == "object")
  950. {
  951. if (obj.nodeType || typeof obj.getAttribute == "function")
  952. {
  953. var dv = obj.getAttribute("display");
  954. if (dv)
  955. {
  956. return fd_xmldecode(dv);
  957. }
  958. }
  959. else if (typeof obj.getDisplay == "function")
  960. {
  961. return obj.getDisplay();
  962. }
  963. }
  964. return fd_getUseValue(obj);
  965. };
  966. function fd_xmldecode(str)
  967. {
  968. var cf = getConfigFrame();
  969. if (cf !== null && typeof cf.sXmlDecode == "function")
  970. {
  971. str = cf.sXmlDecode(str);
  972. }
  973. return str;
  974. };
  975. function fd_getNOT()
  976. {
  977. if (document.f && document.f.oExcludeSelectedValues && document.f.oExcludeSelectedValues.options)
  978. {
  979. return (document.f.oExcludeSelectedValues.options[document.f.oExcludeSelectedValues.options.selectedIndex].value);
  980. }
  981. else
  982. {
  983. var oPC = (G_PM_THIS_ ? G_PM_THIS_.getPromptControl('inputList') : null);
  984. if (oPC)
  985. {
  986. return ( "" + oPC.isExclusive() );
  987. }
  988. }
  989. return '';
  990. };
  991. function buildFilterDateExpression()
  992. {
  993. var oFE = new cf.CFilterExpression();
  994. oFE.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
  995. onlyPrompt = false;
  996. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  997. {
  998. var no = getNullOption();
  999. oFE.setNullOption(no);
  1000. if (no == "only")
  1001. {
  1002. return oFE;
  1003. }
  1004. }
  1005. var sFromUseValue = pickerControldateFrom.sGetValue();
  1006. var sFromDisplayValue = pickerControldateFrom.sGetFormatValue();
  1007. var sToUseValue = pickerControldateTo.sGetValue();
  1008. var sToDisplayValue = pickerControldateTo.sGetFormatValue();
  1009. if (document.getElementById("textBoxstringValueFrom"))
  1010. {
  1011. if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
  1012. {
  1013. sFromUseValue = substVarValueFrom;
  1014. sFromDisplayValue = textBoxstringValueFrom.sGetFormatValue();
  1015. }
  1016. else if (document.f.fromValue[2].checked == true)
  1017. {
  1018. sFromUseValue = null;
  1019. }
  1020. if (document.f.toValue[1].checked == true && substVarValueTo != null)
  1021. {
  1022. sToUseValue = substVarValueTo;
  1023. sToDisplayValue = textBoxstringValueTo.sGetFormatValue();
  1024. }
  1025. else if (document.f.toValue[2].checked == true)
  1026. {
  1027. sToUseValue = null;
  1028. }
  1029. }
  1030. else
  1031. {
  1032. if (document.f.fromValue[1].checked == true)
  1033. {
  1034. sFromUseValue = null;
  1035. }
  1036. if (document.f.toValue[1].checked == true)
  1037. {
  1038. sToUseValue = null;
  1039. }
  1040. }
  1041. if (sFromUseValue !== null && sToUseValue !== null && pickerControldateFrom.m_dDate > pickerControldateTo.m_dDate)
  1042. {
  1043. tmp = sFromUseValue;
  1044. sFromUseValue = sToUseValue;
  1045. sToUseValue = tmp;
  1046. tmp = sFromDisplayValue;
  1047. sFromDisplayValue = sToDisplayValue;
  1048. sToDisplayValue = tmp;
  1049. }
  1050. if (cf.dlgGlobalGetParm("xxDataType") == 52)
  1051. {
  1052. if (sFromUseValue !== null)
  1053. {
  1054. sFromUseValue += (document.f.promptBox.checked ? "T" : " ") + "00:00:00.000";
  1055. }
  1056. if (sToUseValue !== null)
  1057. {
  1058. sToUseValue += (document.f.promptBox.checked ? "T" : " ") + "23:59:59.999";
  1059. }
  1060. }
  1061. if (document.f.promptBox.checked)
  1062. {
  1063. var promptID = getPromptId();
  1064. oFE.setPrompt(promptID);
  1065. var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
  1066. var sPromptValues = oParamManager.getRangePromptValues(sFromUseValue, sFromDisplayValue, sToUseValue, sToDisplayValue);
  1067. cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
  1068. }
  1069. else
  1070. {
  1071. if (sFromUseValue !== null)
  1072. {
  1073. oFE.setFrom(sFromUseValue, sFromDisplayValue);
  1074. }
  1075. if (sToUseValue !== null)
  1076. {
  1077. oFE.setTo(sToUseValue, sToDisplayValue);
  1078. }
  1079. }
  1080. return oFE;
  1081. };
  1082. function getAppFrame()
  1083. {
  1084. var oAppFrame = null;
  1085. if (typeof getConfigFrame == "function")
  1086. {
  1087. oAppFrame = getConfigFrame();
  1088. }
  1089. else if (typeof goDialogManager != "undefined")
  1090. {
  1091. oAppFrame = goDialogManager.getApplicationFrame();
  1092. }
  1093. return oAppFrame;
  1094. };
  1095. function setupDialog()
  1096. {
  1097. var oFilterFeature = goDialogManager.getThisFeatureObject();
  1098. var oFilterName = document.getElementById("filterNameStr");
  1099. oFilterName.appendChild(document.createTextNode(decodeURIComponent(oFilterFeature.m_sLabel)));
  1100. var oFilterDeleteLink = document.getElementById("filterDeleteLink");
  1101. var oFilterDeleteText = oFilterDeleteLink.innerHTML;
  1102. oFilterDeleteText = oFilterDeleteText.replace(/&lt;a&gt;/i, '<a href="#" onclick="deleteModelFilter();" onmouseover="window.status=\'\';return true;">');
  1103. oFilterDeleteText = oFilterDeleteText.replace(/&lt;\/a&gt;/i, '</a>');
  1104. oFilterDeleteLink.innerHTML = oFilterDeleteText;
  1105. var oAppFrame = getAppFrame();
  1106. if (oAppFrame !== null && oAppFrame.isDetailFilterEnabled())
  1107. {
  1108. document.getElementById("b_summaryOptions").style.display = "block";
  1109. }
  1110. for (var idxSummaryOption = 0; idxSummaryOption < document.f.r_summaryOption.length; idxSummaryOption++)
  1111. {
  1112. document.f.r_summaryOption[idxSummaryOption].checked = (document.f.r_summaryOption[idxSummaryOption].value == oFilterFeature.m_sFilterSummaryType);
  1113. }
  1114. if (document.f && document.f.oExcludeSelectedValues && document.f.oExcludeSelectedValues.options)
  1115. {
  1116. document.f.oExcludeSelectedValues.options[(oFilterFeature.m_bNOT ? 1 : 0)].selected = true;
  1117. }
  1118. };
  1119. function execute()
  1120. {
  1121. var oFilterFeature = goDialogManager.getThisFeatureObject();
  1122. var sSummaryOption = "";
  1123. for (var idxSummaryOption = 0; idxSummaryOption < document.f.r_summaryOption.length; idxSummaryOption++)
  1124. {
  1125. if (document.f.r_summaryOption[idxSummaryOption].checked)
  1126. {
  1127. sSummaryOption = document.f.r_summaryOption[idxSummaryOption].value;
  1128. }
  1129. }
  1130. goDialogManager.getFeatureManager().executeFeature("ModelFilter", [fd_getNOT(), sSummaryOption]);
  1131. };
  1132. function deleteModelFilter()
  1133. {
  1134. goDialogManager.getFeatureManager().executeFeature("ModelFilter", ["DELETE"]);
  1135. };
  1136. function filterDialogCommon_init()
  1137. {
  1138. attachMouseEvents();
  1139. var x = document.getElementById("link1");
  1140. var y = document.getElementById("link2");
  1141. if (cf.dlgGlobalGetParm('xxIsSearchAllowed') != true)
  1142. {
  1143. y.style.display = "none";
  1144. }
  1145. if (cf.isDetailFilterEnabled())
  1146. {
  1147. document.getElementById("filterBasedOnInfoMessage").style.display = "block";
  1148. }
  1149. if (cf.dlgGlobalGetParm('xxPromptState') == true)
  1150. {
  1151. document.f.promptBox.checked = true;
  1152. }
  1153. else if (cf.dlgGlobalGetParm('xxPromptState') == false)
  1154. {
  1155. document.f.promptBox.checked = false;
  1156. }
  1157. else if (sXXPromptParam != "")
  1158. {
  1159. document.f.promptBox.checked = true;
  1160. }
  1161. var x = document.getElementById("colName");
  1162. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  1163. initNullOptions();
  1164. };
  1165. function filterCombine_execute(bLeaveDialog)
  1166. {
  1167. var sTab = cf.dlgGlobalGetParm("xxFCtab");
  1168. cf.dlgGlobalReset();
  1169. cf.dlgGlobalSetParm("xxFCtab", sTab);
  1170. var oCFilters = cf.getCombinedFilter();
  1171. if (oCFilters && (oCFilters.isDirty() || oCFilters.hasDirtyChildren()))
  1172. {
  1173. cf.addColumnsForReselection();
  1174. cf.sendCmd(oCFilters.getCommand(), "", true, bLeaveDialog);
  1175. }
  1176. else
  1177. {
  1178. cf.hideDialogFrame();
  1179. }
  1180. if(typeof oCFilters != "undefined" && oCFilters != null)
  1181. {
  1182. oCFilters.clearDirtyFlag();
  1183. cf.cfgRemove("combinedFilters");
  1184. cf.cfgRemove("combinedFilters_default");
  1185. cf.cfgBackup("filter_promptValues");
  1186. cf.cfgBackup("filter_promptValuesXML");
  1187. }
  1188. };
  1189. function filterCombine_cancelDialog()
  1190. {
  1191. cf.dlgGlobalReset();
  1192. var oCCdefault = cf.cfgGet("combinedFilters_default");
  1193. if (oCCdefault)
  1194. {
  1195. var oCC = cf.getCombinedFilter();
  1196. if (oCC)
  1197. {
  1198. var nParent = oCC.m_nNode.parentNode;
  1199. if (nParent)
  1200. {
  1201. nParent.insertBefore(oCCdefault.m_nNode, oCC.m_nNode);
  1202. nParent.removeChild(oCC.m_nNode);
  1203. }
  1204. }
  1205. cf.cfgRemove("combinedFilters_default");
  1206. }
  1207. cf.cfgRemove("combinedFilters");
  1208. cf.cfgRestore("filter_promptValues");
  1209. cf.cfgRestore("filter_promptValuesXML");
  1210. cf.hideDialogFrame();
  1211. };
  1212. function filterCombine_applyChanges()
  1213. {
  1214. var oCFilters = cf.getCombinedFilter();
  1215. var iCurrentFilterGroup = oCFilters.m_iFilterView;
  1216. var sTab = cf.dlgGlobalGetParm("xxFCtab");
  1217. if (oCFilters && (oCFilters.isDirty() || oCFilters.hasDirtyChildren()))
  1218. {
  1219. execute(null, true);
  1220. oCFilters.renderFilterView(oFilterViewObj);
  1221. }
  1222. };
  1223. function filterCombine_init(sTab, iFilterView)
  1224. {
  1225. attachMouseEvents();
  1226. oFilterViewObj = document.getElementById('filterList');
  1227. var oCFilters;
  1228. if (cf)
  1229. {
  1230. cf.setFilterMode(cf.giFILTERCPLXMODE_WIZARD);
  1231. cf.dlgGlobalSetParm("xxFCtab", sTab);
  1232. oCFilters = cf.getCombinedFilter();
  1233. if (oCFilters)
  1234. {
  1235. var oBackup = cf.cfgGet("combinedFilters_default");
  1236. if (!oBackup)
  1237. {
  1238. cf.cfgSet("combinedFilters_default", oCFilters.clone());
  1239. }
  1240. oCFilters.setFilterView(iFilterView);
  1241. oCFilters.renderFilterView(oFilterViewObj);
  1242. }
  1243. }
  1244. if (cf && cf.dlgGlobalGetParm("xxAllowDetail") != true && oCFilters.getRawFilter().getSize() == 0)
  1245. {
  1246. var rTabElement = document.getElementById("rTab");
  1247. if (rTabElement)
  1248. {
  1249. rTabElement.parentNode.parentNode.parentNode.parentNode.style.display = "none";
  1250. }
  1251. }
  1252. if (cf && cf.showDialogFrame)
  1253. {
  1254. cf.showDialogFrame(300);
  1255. }
  1256. document.onclick = function(event)
  1257. {
  1258. var sTCN = ((window.event && window.event.srcElement) ? window.event.srcElement : event.target).className;
  1259. if ( gFContextMenu && gFContextMenu.m_contextMenu && !sTCN.match(/\bclsFilterOperator\b/gi) )
  1260. {
  1261. gFContextMenu.m_contextMenu.remove();
  1262. }
  1263. return true;
  1264. };
  1265. };
  1266. function filterCombine_gf()
  1267. {
  1268. var oCFilters = cf.getCombinedFilter();
  1269. oCFilters.groupFilters(oCFilters.getSelectedIds(oFilterViewObj));
  1270. oCFilters.renderFilterView(oFilterViewObj);
  1271. };
  1272. function filterCombine_ugf()
  1273. {
  1274. var oCFilters = cf.getCombinedFilter();
  1275. oCFilters.unGroupFilters(oCFilters.getSelectedIds(oFilterViewObj));
  1276. oCFilters.renderFilterView(oFilterViewObj);
  1277. };
  1278. function filterCombine_df()
  1279. {
  1280. var oCFilters = cf.getCombinedFilter();
  1281. oCFilters.deleteFilters(oCFilters.getSelectedIds(oFilterViewObj));
  1282. oCFilters.renderFilterView(oFilterViewObj);
  1283. };
  1284. function filterCombine_fNot(bNot)
  1285. {
  1286. var oCFilters = cf.getCombinedFilter();
  1287. var aFilterIDs = oCFilters.getSelectedIds(oFilterViewObj);
  1288. for (var idxFilter in aFilterIDs)
  1289. {
  1290. var sFilterId = aFilterIDs[idxFilter];
  1291. var oFilter = oCFilters.getFilterById(sFilterId);
  1292. if (oFilter !== null)
  1293. {
  1294. oFilter.setNot(bNot);
  1295. }
  1296. }
  1297. oCFilters.setDirty();
  1298. oCFilters.renderFilterView(oFilterViewObj);
  1299. };
  1300. function filterCombine_dfa()
  1301. {
  1302. var oCFilters = cf.getCombinedFilter();
  1303. oCFilters.deleteAll();
  1304. oCFilters.renderFilterView(oFilterViewObj);
  1305. };
  1306. function filterCombine_afl()
  1307. {
  1308. cf.dlgGlobalSetParm("xxNewFilter", true);
  1309. goDialogManager.getFeatureManager().launchFeature('FilterSimple');
  1310. };
  1311. function filterCombine_cOp(sId, sOp)
  1312. {
  1313. var oCFilters = cf.getCombinedFilter();
  1314. var oFilterGroup = oCFilters.getFilterById(sId);
  1315. if (oFilterGroup.isNot())
  1316. {
  1317. if (sOp == cf.gsFILTEROPERATOR_AND)
  1318. {
  1319. sOp = cf.gsFILTEROPERATOR_NAND;
  1320. }
  1321. else if (sOp == cf.gsFILTEROPERATOR_OR)
  1322. {
  1323. sOp = cf.gsFILTEROPERATOR_NOR;
  1324. }
  1325. }
  1326. oFilterGroup.setOperator(sOp);
  1327. oCFilters.renderFilterView(oFilterViewObj);
  1328. if (window && window.getSelection && window.getSelection().removeAllRanges)
  1329. {
  1330. window.getSelection().removeAllRanges();
  1331. }
  1332. };
  1333. function filterCombine_modifyFilter(sFID, sTab)
  1334. {
  1335. cf.dlgGlobalSetParm("xxNewFilter", false);
  1336. cf.dlgGlobalSetParm("xxFCtab", sTab);
  1337. cf.dlgGlobalSetParm("xxShowTypeInDropDown", cf.checkCalcFunctionAgainstDB("FLEXIBLE_FILTERS"));
  1338. goDialogManager.getFeatureManager().launchFeature('FilterSimple', [sFID, true]);
  1339. };
  1340. function filterCombine_tab(sTab, sDialogName)
  1341. {
  1342. cf.dlgReset();
  1343. if (cf.isDetailFilterEnabled())
  1344. {
  1345. cf.dlgGlobalSetParm("xxAllowDetail", true);
  1346. }
  1347. cf.dlgSetParm("m", "/" + cf.qs_dir + "/" + sDialogName);
  1348. cf.dlgSetParm("m_tab", sTab);
  1349. cf.dlgSubmit();
  1350. };
  1351. function filterDateRange_execute()
  1352. {
  1353. if((document.f.fromValue[0].checked && !pickerControldateFrom.isValid())||(document.f.toValue[0].checked && !pickerControldateTo.isValid()))
  1354. {
  1355. return;
  1356. }
  1357. submitFilterExpression( buildFilterDateExpression() );
  1358. };
  1359. function filterCommon_isColumHidden(sColId)
  1360. {
  1361. var oMQMgr = goDialogManager.getMiniQueryManager();
  1362. var oCol = oMQMgr.getColumnById(sColId);
  1363. var bHidden = false;
  1364. if (oCol && oCol !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
  1365. {
  1366. bHidden = (oCol.getAttribute("hide") == "layout");
  1367. }
  1368. return bHidden;
  1369. };
  1370. function filterCommon_initBasedOnDatasourceBox()
  1371. {
  1372. var bRetval = false;
  1373. if (cf.isDetailFilterEnabled())
  1374. {
  1375. var bIsColHidden = filterCommon_isColumHidden( cf.dlgGlobalGetParm("xxColName") );
  1376. if (bIsColHidden)
  1377. {
  1378. document.getElementById("displayBasedOn").disabled = true;
  1379. document.f.filterBasedOnDS.disabled = true;
  1380. }
  1381. document.getElementById("displayBasedOn").style.display = "block";
  1382. if (cf.dlgGlobalGetParm('xxBasedOn') == 'details')
  1383. {
  1384. document.f.filterBasedOnDS.checked = false;
  1385. }
  1386. bRetval = document.f.filterBasedOnDS.checked;
  1387. }
  1388. return bRetval;
  1389. };
  1390. function filterDateRange_init(oOptions)
  1391. {
  1392. attachMouseEvents();
  1393. filterCommon_initBasedOnDatasourceBox();
  1394. if (cf.isDetailFilterEnabled())
  1395. {
  1396. document.getElementById("filterBasedOnInfoMessage").style.display = "block";
  1397. }
  1398. if (oOptions.bPrompt)
  1399. {
  1400. document.f.promptBox.checked = true;
  1401. }
  1402. if (cf && cf.showDialogFrame)
  1403. {
  1404. cf.showDialogFrame(oOptions.bUseAdv ? 565 : 495);
  1405. }
  1406. initNullOptions();
  1407. var x = document.getElementById("colName");
  1408. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  1409. var oDateTo = document.getElementById('dateEditBoxdateTo');
  1410. if (oDateTo)
  1411. {
  1412. oDateTo.onclick = toGotFocus;
  1413. oDateTo.onkeypress = toGotFocus;
  1414. oDateTo.onpaste = toGotFocus;
  1415. }
  1416. var oDateFrom = document.getElementById('dateEditBoxdateFrom');
  1417. if (oDateFrom)
  1418. {
  1419. oDateFrom.onclick = fromGotFocus;
  1420. oDateFrom.onkeypress = fromGotFocus;
  1421. oDateFrom.onpaste = fromGotFocus;
  1422. }
  1423. if (pickerControldateFrom && pickerControldateFrom.m_oEditBox && !pickerControldateFrom.m_oEditBox.disabled)
  1424. {
  1425. pickerControldateFrom.m_oEditBox.focus();
  1426. }
  1427. document.onclick = cleanUpPage;
  1428. if (document.dateToimgPicker)
  1429. {
  1430. document.dateToimgPicker.onmousedown = toDropDown;
  1431. }
  1432. if (document.dateFromimgPicker)
  1433. {
  1434. document.dateFromimgPicker.onmousedown = fromDropDown;
  1435. }
  1436. };
  1437. function filterDateTimeRange_buildFilterExpression()
  1438. {
  1439. var fe = new cf.CFilterExpression();
  1440. fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
  1441. onlyPrompt = false;
  1442. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  1443. {
  1444. var no = getNullOption();
  1445. fe.setNullOption(no);
  1446. if (no == "only")
  1447. {
  1448. return fe;
  1449. }
  1450. }
  1451. var sFromUseValue = pickerControldateFrom.sGetValue() + (document.f.promptBox.checked ? "T" : " ") + timePickertimeFrom.sGetValue();
  1452. var sFromDisplayValue = pickerControldateFrom.sGetFormatValue() + " " + timePickertimeFrom.sGetFormatValue();
  1453. var sToUseValue = pickerControldateTo.sGetValue() + (document.f.promptBox.checked ? "T" : " ") + timePickertimeTo.sGetValue();
  1454. var sToDisplayValue = pickerControldateTo.sGetFormatValue() + " " + timePickertimeTo.sGetFormatValue();
  1455. if (document.getElementById("textBoxstringValueFrom"))
  1456. {
  1457. if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
  1458. {
  1459. sFromUseValue = substVarValueFrom;
  1460. sFromDisplayValue = textBoxstringValueFrom.sGetFormatValue();
  1461. }
  1462. else if (document.f.fromValue[2].checked == true)
  1463. {
  1464. sFromUseValue = null;
  1465. }
  1466. if (document.f.toValue[1].checked == true && substVarValueTo != null)
  1467. {
  1468. sToUseValue = substVarValueTo;
  1469. sToDisplayValue = textBoxstringValueTo.sGetFormatValue();
  1470. }
  1471. else if (document.f.toValue[2].checked == true)
  1472. {
  1473. sToUseValue = null;
  1474. }
  1475. }
  1476. else
  1477. {
  1478. if (document.f.fromValue[1].checked == true)
  1479. {
  1480. sFromUseValue = null;
  1481. }
  1482. if (document.f.toValue[1].checked == true)
  1483. {
  1484. sToUseValue = null;
  1485. }
  1486. }
  1487. if ( sFromUseValue !== null && sToUseValue !== null && (pickerControldateFrom.m_dDate > pickerControldateTo.m_dDate || (pickerControldateFrom.m_dDate.toString() == pickerControldateTo.m_dDate.toString() && timePickertimeFrom.sGetValue() > timePickertimeTo.sGetValue())) )
  1488. {
  1489. tmp = sFromUseValue;
  1490. sFromUseValue = sToUseValue;
  1491. sToUseValue = tmp;
  1492. tmp = sFromDisplayValue;
  1493. sFromDisplayValue = sToDisplayValue;
  1494. sToDisplayValue = tmp;
  1495. }
  1496. if (document.f.promptBox.checked)
  1497. {
  1498. var promptID = getPromptId();
  1499. fe.setPrompt(promptID);
  1500. var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
  1501. var sPromptValues = oParamManager.getRangePromptValues(
  1502. sFromUseValue,
  1503. sFromDisplayValue,
  1504. sToUseValue,
  1505. sToDisplayValue
  1506. );
  1507. cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
  1508. }
  1509. else
  1510. {
  1511. if (sFromUseValue !== null)
  1512. {
  1513. fe.setFrom(sFromUseValue, sFromDisplayValue);
  1514. }
  1515. if (sToUseValue !== null)
  1516. {
  1517. fe.setTo(sToUseValue, sToDisplayValue);
  1518. }
  1519. }
  1520. return fe;
  1521. };
  1522. function filterDateTimeRange_execute()
  1523. {
  1524. 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()))
  1525. {
  1526. return;
  1527. }
  1528. submitFilterExpression( filterDateTimeRange_buildFilterExpression() );
  1529. };
  1530. function filterDateTimeRange_init(oOptions)
  1531. {
  1532. attachMouseEvents();
  1533. filterCommon_initBasedOnDatasourceBox();
  1534. if (cf.isDetailFilterEnabled())
  1535. {
  1536. document.getElementById("filterBasedOnInfoMessage").style.display = "block";
  1537. }
  1538. var x = document.getElementById("colName");
  1539. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  1540. if (oOptions.bPrompt)
  1541. {
  1542. document.f.promptBox.checked = true;
  1543. }
  1544. if (cf && cf.showDialogFrame)
  1545. {
  1546. cf.showDialogFrame(oOptions.bUseAdv ? 550 : 495);
  1547. }
  1548. initNullOptions();
  1549. var oDateFrom = document.getElementById('dateEditBoxdateFrom');
  1550. var oTimeFrom = document.getElementById('timeEditBoxtimeFrom');
  1551. if (oDateFrom)
  1552. {
  1553. oDateFrom.onclick = fromGotFocus;
  1554. oDateFrom.onkeypress = fromGotFocus;
  1555. oDateFrom.onpaste = fromGotFocus;
  1556. }
  1557. if (oTimeFrom)
  1558. {
  1559. oTimeFrom.onclick = fromGotFocus;
  1560. oTimeFrom.onkeypress = fromGotFocus;
  1561. oTimeFrom.onpaste = fromGotFocus;
  1562. }
  1563. var oDateTo = document.getElementById('dateEditBoxdateTo');
  1564. var oTimeTo = document.getElementById('timeEditBoxtimeTo');
  1565. if (oDateTo)
  1566. {
  1567. oDateTo.onclick = toGotFocus;
  1568. oDateTo.onkeypress = toGotFocus;
  1569. oDateTo.onpaste = toGotFocus;
  1570. }
  1571. if (oTimeTo)
  1572. {
  1573. oTimeTo.onclick = toGotFocus;
  1574. oTimeTo.onkeypress = toGotFocus;
  1575. oTimeTo.onpaste = toGotFocus;
  1576. }
  1577. if (pickerControldateFrom && pickerControldateFrom.m_oEditBox && !pickerControldateFrom.m_oEditBox.disabled)
  1578. {
  1579. pickerControldateFrom.m_oEditBox.focus();
  1580. }
  1581. document.onclick = cleanUpPage;
  1582. if (document.dateToimgPicker)
  1583. {
  1584. document.dateToimgPicker.onmousedown = toDropDown;
  1585. }
  1586. if (document.dateFromimgPicker)
  1587. {
  1588. document.dateFromimgPicker.onmousedown = fromDropDown;
  1589. }
  1590. };
  1591. function filterDialogCommon_setParmValues()
  1592. {
  1593. var oPC = G_PM_THIS_.getPromptControl('inputList');
  1594. if (cf && cf.showDialogFrame)
  1595. {
  1596. cf.showDialogFrame(415);
  1597. var aParams = [];
  1598. for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
  1599. {
  1600. aParams.push(
  1601. createParamValue(
  1602. fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j)),
  1603. fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxPickList", j))
  1604. )
  1605. );
  1606. }
  1607. for (var k = 0; k < cf.dlgGlobalSize("xxSelects"); k += 2)
  1608. {
  1609. aParams.push(
  1610. createParamValue(
  1611. fd_getUseValue(cf.dlgGlobalGetParmAt("xxSelects", k + 1)),
  1612. fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxSelects", k))
  1613. )
  1614. );
  1615. }
  1616. if ( oPC )
  1617. {
  1618. oPC.setParameterValues( aParams );
  1619. }
  1620. }
  1621. if (oPC)
  1622. {
  1623. var elInput = oPC.m_oForm;
  1624. if (elInput && !elInput.disabled)
  1625. {
  1626. elInput.focus();
  1627. }
  1628. }
  1629. };
  1630. function filterDaysBeforeToday_init()
  1631. {
  1632. filterDialogCommon_init();
  1633. var basedOnVal = filterCommon_initBasedOnDatasourceBox();
  1634. filterDialogCommon_setParmValues();
  1635. var hintText = document.getElementById("hintText");
  1636. if (hintText)
  1637. {
  1638. hintText.innerHTML = sXXTodayString + " - " + sXXAllDaysString;
  1639. }
  1640. };
  1641. function filterDaysBeforeToday_buildFilterExpression()
  1642. {
  1643. return filterTypeInStartsEndsContains_buildFilterExpression("daysBeforeToday");
  1644. };
  1645. function filterDaysBeforeToday_execute()
  1646. {
  1647. submitFilterExpression( filterDaysBeforeToday_buildFilterExpression() );
  1648. };
  1649. function filterTypeInCommon_init()
  1650. {
  1651. filterDialogCommon_init();
  1652. var x = document.getElementById("link1");
  1653. var y = document.getElementById("link2");
  1654. var basedOnVal = filterCommon_initBasedOnDatasourceBox();
  1655. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  1656. {
  1657. x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
  1658. y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
  1659. }
  1660. else
  1661. {
  1662. x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
  1663. y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
  1664. }
  1665. y.appendChild(document.createTextNode(sFILTER_SEARCH_FOR_VALUES));
  1666. x.appendChild(document.createTextNode(sFILTER_PICK_VALUES));
  1667. filterDialogCommon_setParmValues();
  1668. };
  1669. function filterTypeInExactlyMatches_init()
  1670. {
  1671. filterTypeInCommon_init();
  1672. };
  1673. function filterTypeInExactlyMatches_buildFilterExpression()
  1674. {
  1675. var fe = new cf.CFilterExpression();
  1676. onlyPrompt = false;
  1677. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  1678. {
  1679. var no = getNullOption();
  1680. fe.setNullOption(no);
  1681. if (no == "only")
  1682. {
  1683. return fe;
  1684. }
  1685. }
  1686. var oPC = G_PM_THIS_.getPromptControl('inputList');
  1687. var aParamValues = oPC.getParameterValues();
  1688. if (aParamValues.length > 0)
  1689. {
  1690. var promptID = getPromptId();
  1691. if (document.f.promptBox.checked)
  1692. {
  1693. fe.setPrompt(promptID);
  1694. }
  1695. var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
  1696. if (sDataType !== "")
  1697. {
  1698. fe.setDataType(sDataType);
  1699. }
  1700. if (document.f.promptBox.checked)
  1701. {
  1702. var promptValues = '<selectChoices>';
  1703. promptValues += oPC.preProcess();
  1704. promptValues += '</selectChoices>';
  1705. cf.updateOrAddPromptParm("p_" + promptID, promptValues);
  1706. }
  1707. else
  1708. {
  1709. for (i = 0; i < aParamValues.length; i++)
  1710. {
  1711. fe.addValue( aParamValues[i].getUseValue(), aParamValues[i].getDisplayValue() );
  1712. }
  1713. }
  1714. }
  1715. else if (document.f.promptBox.checked)
  1716. {
  1717. var promptID = getPromptId();
  1718. fe.setPrompt(promptID);
  1719. cf.updateOrAddPromptParm("p_" + promptID, '<selectChoices/>');
  1720. onlyPrompt = true;
  1721. }
  1722. fe.setFilterType("exactlyMatches");
  1723. return fe;
  1724. };
  1725. function filterTypeInExactlyMatches_execute()
  1726. {
  1727. submitFilterExpression( filterTypeInExactlyMatches_buildFilterExpression() );
  1728. };
  1729. function filterTypeInMatchesSQLPattern_buildFilterExpression()
  1730. {
  1731. var fe = filterTypeInExactlyMatches_buildFilterExpression();
  1732. fe.setFilterType("isLike");
  1733. return fe;
  1734. };
  1735. function filterTypeInMatchesSQLPattern_execute()
  1736. {
  1737. submitFilterExpression( filterTypeInMatchesSQLPattern_buildFilterExpression() );
  1738. };
  1739. function filterTypeInRange_getExcludeFlag(sBound)
  1740. {
  1741. var sXXNodeName = ( sBound == "from" ? "xxFromNode" : "xxToNode" );
  1742. var sRangeNodeName = ( sBound == "from" ? "start" : "end" );
  1743. var nNode = cf.dlgGlobalGetParm(sXXNodeName);
  1744. var nSelectChoices = cf.dlgGlobalGetParm("xxSelectChoicesNode");
  1745. var bExclude = ( nNode && nNode.getAttribute(cf.gsFE_EXCLUSIVE_ATTR) === "true" );
  1746. if ( !bExclude && nSelectChoices )
  1747. {
  1748. var nNode = nSelectChoices.findChildByName(sRangeNodeName);
  1749. bExclude = (nNode && nNode.getAttribute("inclusive") === "false");
  1750. }
  1751. return bExclude;
  1752. };
  1753. function filterTypeInRange_init()
  1754. {
  1755. filterTypeInCommon_init();
  1756. filterTypeInRange_buildIncludeMenu("from");
  1757. filterTypeInRange_buildIncludeMenu("to");
  1758. };
  1759. function filterTypeInRange_execute()
  1760. {
  1761. submitFilterExpression( filterTypeInRange_buildFilterExpression() );
  1762. };
  1763. function filterTypeInRange_buildFilterExpression()
  1764. {
  1765. var oFE = new cf.CFilterExpression();
  1766. onlyPrompt = false;
  1767. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  1768. {
  1769. var no = getNullOption();
  1770. oFE.setNullOption(no);
  1771. if (no == "only")
  1772. {
  1773. return oFE;
  1774. }
  1775. }
  1776. var sFromUseValue = filterTypeInRange_getValue("from");
  1777. var sToUseValue = filterTypeInRange_getValue("to");
  1778. var bFromInclusive = filterTypeInRange_getInclusive("from");
  1779. var bToInclusive = filterTypeInRange_getInclusive("to");
  1780. if (document.f.promptBox.checked)
  1781. {
  1782. var promptID = getPromptId();
  1783. oFE.setPrompt(promptID);
  1784. var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
  1785. var sPromptValues = oParamManager.getRangePromptValues(
  1786. sFromUseValue,
  1787. sFromUseValue,
  1788. sToUseValue,
  1789. sToUseValue,
  1790. bFromInclusive,
  1791. bToInclusive
  1792. );
  1793. cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
  1794. }
  1795. else
  1796. {
  1797. if (sFromUseValue !== null)
  1798. {
  1799. oFE.setFrom(sFromUseValue, sFromUseValue, !bFromInclusive);
  1800. }
  1801. if (sToUseValue !== null)
  1802. {
  1803. oFE.setTo(sToUseValue, sToUseValue, !bToInclusive);
  1804. }
  1805. }
  1806. if (cf.dlgGlobalGetParm('xxFilterIsString') == true || cf.dlgGlobalGetParm('xxFilterIsString') == null)
  1807. {
  1808. oFE.setDataType('string');
  1809. }
  1810. oFE.setFilterType(cf.gsFE_FILTERTYPE_TYPEINRANGE);
  1811. return oFE;
  1812. };
  1813. function filterTypeInRange_getValue(sName)
  1814. {
  1815. var oRadio = document.getElementById(sName + "Value");
  1816. return ( oRadio && oRadio.checked ? document.f[sName + "TB"].value : null );
  1817. };
  1818. function filterTypeInRange_getInclusive(sPrefix)
  1819. {
  1820. return ( window["filterTypeInRange_inclusive_" + sPrefix] !== false );
  1821. };
  1822. function filterTypeInRange_buildIncludeMenu(sPrefix)
  1823. {
  1824. if (!sPrefix)
  1825. {
  1826. return;
  1827. }
  1828. var sParentDiv = sPrefix + "IncludedDiv";
  1829. var sWebRoot = cf.cfgGet("gsWebRoot");
  1830. var oIncludeButtonStyle = new CUIStyle('includeButton', 'includeButton', 'includeButton', 'includeButton', 'includeButton', 'includeButton');
  1831. var oIncludedFlyoutMenu = new CUIStyle('headerButtonDropDown', 'headerButtonDropDownRollover', 'headerButtonDropDown', 'headerButtonDropDown','headerButtonDropDown');
  1832. var oIncludedMenuItemStyle = new CUIStyle('includeMenuItem_normal', 'includeMenuItem_hover', 'includeMenuItem_pressed', '', 'menuItem_disabled');
  1833. var oIncludedBar = new CBar(sParentDiv, null, null, sWebRoot + '/common/images/toolbar/', '', '', 'qs', 'tt');
  1834. oIncludedBar.setMenuType(cHorizonalBar);
  1835. var oIncludedMenuItem = new CQSMenuItem(oIncludedBar, sFILTER_INCLUDED, '', '', oIncludeButtonStyle, sWebRoot, null);
  1836. oIncludedMenuItem.setIconPrecedingText("(");
  1837. oIncludedMenuItem.setIconTrailingText(")");
  1838. oIncludedMenuItem.setDropDownArrow(sWebRoot + "/common/images/toolbar_drop_arrow.gif");
  1839. var menuStyle = new CUIStyle('clsMenu', '', '', '', '');
  1840. var oIncludedMenu = oIncludedMenuItem.createDropDownMenu(menuStyle);
  1841. oIncludedMenuItem = new CQSMenuItem(oIncludedMenu, sFILTER_INCLUDE_THE_VALUE, 'filterTypeInRange_includeMenuOnClickHandler("' + sFILTER_INCLUDED + '","'+sPrefix+'",true,this.menuItem);', '', oIncludedMenuItemStyle, sWebRoot, null);
  1842. oIncludedMenuItem = new CQSMenuItem(oIncludedMenu, sFILTER_EXCLUDE_THE_VALUE, 'filterTypeInRange_includeMenuOnClickHandler("' + sFILTER_EXCLUDED + '","'+sPrefix+'",false,this.menuItem);', '', oIncludedMenuItemStyle, sWebRoot, null);
  1843. oIncludedBar.draw();
  1844. if ( filterTypeInRange_getExcludeFlag(sPrefix) )
  1845. {
  1846. filterTypeInRange_includeMenuOnClickHandler( sFILTER_EXCLUDED, sPrefix, false, oIncludedMenuItem );
  1847. }
  1848. return oIncludedMenuItem;
  1849. };
  1850. function filterTypeInRange_includeMenuOnClickHandler(sNewLabel, sPrefix, bInclusive, oMenuItem)
  1851. {
  1852. if ( !oMenuItem )
  1853. {
  1854. oMenuItem = (this ? this.menuItem : null);
  1855. }
  1856. if (oMenuItem && oMenuItem.getParent && oMenuItem.getParent().getParent)
  1857. {
  1858. var menuItemForLabel = oMenuItem.getParent().getParent();
  1859. menuItemForLabel.setLabel(sNewLabel);
  1860. if (menuItemForLabel.getParent && menuItemForLabel.getParent().draw)
  1861. {
  1862. menuItemForLabel.getParent().draw();
  1863. }
  1864. }
  1865. window["filterTypeInRange_inclusive_" + sPrefix] = ( bInclusive !== false );
  1866. if (window && window.getSelection && window.getSelection().removeAllRanges)
  1867. {
  1868. window.getSelection().removeAllRanges();
  1869. }
  1870. return true;
  1871. };
  1872. function filterTypeInStartsEndsContains_buildFilterExpression(sFilterType)
  1873. {
  1874. var fe = new cf.CFilterExpression();
  1875. onlyPrompt = false;
  1876. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  1877. {
  1878. var no = getNullOption();
  1879. fe.setNullOption(no);
  1880. if (no == "only")
  1881. {
  1882. return fe;
  1883. }
  1884. }
  1885. var oPC = G_PM_THIS_.getPromptControl('inputList');
  1886. var oParamValue = oPC.getParameterValues();
  1887. if (oParamValue)
  1888. {
  1889. var promptID = getPromptId();
  1890. if (document.f.promptBox.checked)
  1891. {
  1892. fe.setPrompt(promptID);
  1893. }
  1894. if (cf.dlgGlobalGetParm('xxFilterIsString') == true || cf.dlgGlobalGetParm('xxFilterIsString') == null)
  1895. {
  1896. fe.setDataType('string');
  1897. }
  1898. if (document.f.promptBox.checked)
  1899. {
  1900. var promptValues = '<selectChoices>';
  1901. promptValues += oPC.preProcess();
  1902. promptValues += '</selectChoices>';
  1903. cf.updateOrAddPromptParm("p_" + promptID, promptValues);
  1904. }
  1905. else
  1906. {
  1907. fe.addValue( oParamValue.use, oParamValue.display );
  1908. }
  1909. fe.setFilterType(sFilterType);
  1910. }
  1911. else if (document.f.promptBox.checked)
  1912. {
  1913. var promptID = getPromptId();
  1914. fe.setPrompt(promptID);
  1915. cf.updateOrAddPromptParm("p_" + promptID, '<selectChoices/>');
  1916. onlyPrompt = true;
  1917. }
  1918. return fe;
  1919. };
  1920. function filterTypeInStartsEndsContains_execute(sFilterType)
  1921. {
  1922. submitFilterExpression( buildFilterExpression() );
  1923. };
  1924. function createParamValue( sUse, sDisplay )
  1925. {
  1926. var oParam = new C_ParameterValue(
  1927. {
  1928. "n": "selectOption",
  1929. "@useValue": sUse,
  1930. "@displayValue": sDisplay
  1931. }
  1932. );
  1933. return oParam;
  1934. };
  1935. function filterIntervalRange_buildFilterExpression()
  1936. {
  1937. var fe = new cf.CFilterExpression();
  1938. fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
  1939. var firstValDisplay = null;
  1940. var secondValDisplay = null;
  1941. onlyPrompt = false;
  1942. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  1943. {
  1944. var no = getNullOption();
  1945. fe.setNullOption(no);
  1946. if (no == "only")
  1947. {
  1948. return fe;
  1949. }
  1950. }
  1951. var firstInterval = intervalControlintervalFrom.sGetInterval();
  1952. var secondInterval = intervalControlintervalTo.sGetInterval();
  1953. var firstIntervalXSD = intervalControlintervalFrom.sGetXSDValue();
  1954. var secondIntervalXSD = intervalControlintervalTo.sGetXSDValue();
  1955. if (document.getElementById("textBoxstringValueFrom"))
  1956. {
  1957. if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
  1958. {
  1959. firstInterval = substVarValueFrom;
  1960. firstValDisplay = textBoxstringValueFrom.sGetFormatValue();
  1961. }
  1962. else if ((firstInterval == '' && firstInterval.length == 0) || document.f.fromValue[2].checked == true)
  1963. {
  1964. firstInterval = sFILTER_LOWEST_VALUE;
  1965. }
  1966. if (document.f.toValue[1].checked == true && substVarValueTo != null)
  1967. {
  1968. secondInterval = substVarValueTo;
  1969. secondValDisplay = textBoxstringValueTo.sGetFormatValue();
  1970. }
  1971. else if ((secondInterval == '' && secondInterval.length == 0) || document.f.toValue[2].checked == true)
  1972. {
  1973. secondInterval = sFILTER_HIGHEST_VALUE;
  1974. }
  1975. }
  1976. else
  1977. {
  1978. if ((firstInterval == '' && firstInterval.length == 0) || document.f.fromValue[1].checked == true)
  1979. {
  1980. firstInterval = sFILTER_LOWEST_VALUE;
  1981. }
  1982. if ((secondInterval == '' && secondInterval.length == 0) || document.f.toValue[1].checked == true)
  1983. {
  1984. secondInterval = sFILTER_HIGHEST_VALUE;
  1985. }
  1986. }
  1987. if (
  1988. (
  1989. (firstInterval != "" && document.f.fromValue[0].checked) &&
  1990. (secondInterval != "" && document.f.toValue[0].checked) ) &&
  1991. (
  1992. (
  1993. parseInt(intervalControlintervalFrom.m_oDays.value,10) > parseInt(intervalControlintervalTo.m_oDays.value,10)
  1994. ) || (
  1995. parseInt(intervalControlintervalFrom.m_oDays.value,10) == parseInt(intervalControlintervalTo.m_oDays.value,10) &&
  1996. parseInt(intervalControlintervalFrom.m_oHours.value,10) > parseInt(intervalControlintervalTo.m_oHours.value,10)
  1997. ) || (
  1998. parseInt(intervalControlintervalFrom.m_oDays.value,10) == parseInt(intervalControlintervalTo.m_oDays.value,10) &&
  1999. parseInt(intervalControlintervalFrom.m_oHours.value,10) == parseInt(intervalControlintervalTo.m_oHours.value,10) &&
  2000. parseInt(intervalControlintervalFrom.m_oMinutes.value,10) > parseInt(intervalControlintervalTo.m_oMinutes.value,10)
  2001. ) || (
  2002. parseInt(intervalControlintervalFrom.m_oDays.value,10) == parseInt(intervalControlintervalTo.m_oDays.value,10) &&
  2003. parseInt(intervalControlintervalFrom.m_oHours.value,10) == parseInt(intervalControlintervalTo.m_oHours.value,10) &&
  2004. parseInt(intervalControlintervalFrom.m_oMinutes.value,10) == parseInt(intervalControlintervalTo.m_oMinutes.value,10) &&
  2005. parseInt(intervalControlintervalFrom.m_oSeconds.value,10) > parseInt(intervalControlintervalTo.m_oSeconds.value,10)
  2006. )
  2007. )
  2008. )
  2009. {
  2010. var tmp = firstInterval;
  2011. firstInterval = secondInterval;
  2012. secondInterval = tmp;
  2013. tmp = firstIntervalXSD;
  2014. firstIntervalXSD = secondIntervalXSD;
  2015. secondIntervalXSD = tmp;
  2016. }
  2017. if (document.f.promptBox.checked)
  2018. {
  2019. var promptID = getPromptId();
  2020. fe.setPrompt(promptID);
  2021. var promptValues = '<selectChoices>';
  2022. if (firstInterval == sFILTER_LOWEST_VALUE && secondInterval == sFILTER_HIGHEST_VALUE)
  2023. {
  2024. onlyPrompt = true;
  2025. promptValues = '<selectChoices/>';
  2026. }
  2027. else
  2028. {
  2029. if (firstInterval == sFILTER_LOWEST_VALUE)
  2030. {
  2031. promptValues += '<selectUnboundedStartRange selected="true">';
  2032. if (secondValDisplay)
  2033. {
  2034. promptValues += '<end displayValue="' + sXmlEncode(secondValDisplay) + '" useValue="' + sXmlEncode(secondInterval) + '"/>';
  2035. }
  2036. else
  2037. {
  2038. promptValues += '<end displayValue="' + sXmlEncode(secondInterval) + '" useValue="' + sXmlEncode(secondIntervalXSD) + '"/>';
  2039. }
  2040. promptValues += '</selectUnboundedStartRange>';
  2041. }
  2042. else if (secondInterval == sFILTER_HIGHEST_VALUE)
  2043. {
  2044. promptValues += '<selectUnboundedEndRange selected="true">';
  2045. if (firstValDisplay)
  2046. {
  2047. promptValues += '<start displayValue="' + sXmlEncode(firstValDisplay) + '" useValue="' + sXmlEncode(firstInterval) + '"/>';
  2048. }
  2049. else
  2050. {
  2051. promptValues += '<start displayValue="' + sXmlEncode(firstInterval) + '" useValue="' + sXmlEncode(firstIntervalXSD) + '"/>';
  2052. }
  2053. promptValues += '</selectUnboundedEndRange>';
  2054. }
  2055. else if (firstInterval == secondInterval)
  2056. {
  2057. if (firstValDisplay)
  2058. {
  2059. promptValues += '<selectOption displayValue="' + sXmlEncode(firstValDisplay) + '" useValue="' + sXmlEncode(firstInterval) + '" selected="true"/>';
  2060. }
  2061. else
  2062. {
  2063. promptValues += '<selectOption displayValue="' + sXmlEncode(firstInterval) + '" useValue="' + sXmlEncode(firstIntervalXSD) + '" selected="true"/>';
  2064. }
  2065. }
  2066. else
  2067. {
  2068. promptValues += '<selectBoundRange selected="true">';
  2069. if (firstValDisplay)
  2070. {
  2071. promptValues += '<start displayValue="' + sXmlEncode(firstValDisplay) + '" useValue="' + sXmlEncode(firstInterval) + '"/>';
  2072. }
  2073. else
  2074. {
  2075. promptValues += '<start displayValue="' + sXmlEncode(firstInterval) + '" useValue="' + sXmlEncode(firstIntervalXSD) + '"/>';
  2076. }
  2077. if (secondValDisplay)
  2078. {
  2079. promptValues += '<end displayValue="' + sXmlEncode(secondValDisplay) + '" useValue="' + sXmlEncode(secondInterval) + '"/>';
  2080. }
  2081. else
  2082. {
  2083. promptValues += '<end displayValue="' + sXmlEncode(secondInterval) + '" useValue="' + sXmlEncode(secondIntervalXSD) + '"/>';
  2084. }
  2085. promptValues += '</selectBoundRange>';
  2086. }
  2087. promptValues += '</selectChoices>';
  2088. }
  2089. cf.updateOrAddPromptParm("p_" + promptID, promptValues);
  2090. }
  2091. else
  2092. {
  2093. if (firstInterval != sFILTER_LOWEST_VALUE)
  2094. {
  2095. fe.setFrom(firstInterval, (firstValDisplay ? firstValDisplay : firstInterval));
  2096. }
  2097. if (secondInterval != sFILTER_HIGHEST_VALUE)
  2098. {
  2099. fe.setTo(secondInterval, (secondValDisplay ? secondValDisplay : secondInterval));
  2100. }
  2101. }
  2102. return fe;
  2103. };
  2104. function filterIntervalRange_execute()
  2105. {
  2106. if((document.f.fromValue[0].checked && !intervalControlintervalFrom.isValid())||(document.f.toValue[0].checked && !intervalControlintervalTo.isValid()))
  2107. {
  2108. return;
  2109. }
  2110. submitFilterExpression( filterIntervalRange_buildFilterExpression() );
  2111. };
  2112. function filterIntervalRange_init(oOptions)
  2113. {
  2114. attachMouseEvents();
  2115. filterCommon_initBasedOnDatasourceBox();
  2116. if (cf.isDetailFilterEnabled())
  2117. {
  2118. document.getElementById("filterBasedOnInfoMessage").style.display = "block";
  2119. }
  2120. if (oOptions.bPrompt)
  2121. {
  2122. document.f.promptBox.checked = true;
  2123. }
  2124. if (cf && cf.showDialogFrame)
  2125. {
  2126. cf.showDialogFrame(oOptions.bUseAdv ? 565 : 500);
  2127. }
  2128. var x = document.getElementById("colName");
  2129. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  2130. initNullOptions();
  2131. filterIntervalRange_initBox(document.f.intervalDaysintervalFrom, fromGotFocus);
  2132. filterIntervalRange_initBox(document.f.intervalHoursintervalFrom, fromGotFocus);
  2133. filterIntervalRange_initBox(document.f.intervalMinutesintervalFrom, fromGotFocus);
  2134. filterIntervalRange_initBox(document.f.intervalSecondsintervalFrom, fromGotFocus);
  2135. filterIntervalRange_initBox(document.f.intervalDaysintervalTo, toGotFocus);
  2136. filterIntervalRange_initBox(document.f.intervalHoursintervalTo, toGotFocus);
  2137. filterIntervalRange_initBox(document.f.intervalMinutesintervalTo, toGotFocus);
  2138. filterIntervalRange_initBox(document.f.intervalSecondsintervalTo, toGotFocus);
  2139. if (document.f && document.f.intervalDaysintervalFrom && !document.f.intervalDaysintervalFrom.disabled)
  2140. {
  2141. document.f.intervalDaysintervalFrom.focus();
  2142. }
  2143. };
  2144. function filterIntervalRange_initBox(oCtrl, oEventHandler)
  2145. {
  2146. if (oCtrl)
  2147. {
  2148. if (oCtrl.value == "")
  2149. {
  2150. oCtrl.value = sFILTER_INTERVAL_DEFAULT_VALUE;
  2151. }
  2152. oCtrl.onclick = oEventHandler;
  2153. oCtrl.onkeypress = oEventHandler;
  2154. oCtrl.onblur = oEventHandler;
  2155. }
  2156. };
  2157. function filterNumRange_buildFilterExpression()
  2158. {
  2159. var fe = new cf.CFilterExpression();
  2160. fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
  2161. onlyPrompt = false;
  2162. var fromValUse = '';
  2163. var fromValDisplay = '';
  2164. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  2165. {
  2166. var no = getNullOption();
  2167. fe.setNullOption(no);
  2168. if (no == "only")
  2169. {
  2170. return fe;
  2171. }
  2172. }
  2173. var decimalSeparator = goDialogManager.getMiniQueryManager().getDecimalSeparator();
  2174. if((textBoxtextBoxFrom.sGetValue() != '')&&(document.getElementById("textBoxNumericFrom").style.display != "none"))
  2175. {
  2176. fromValUse = textBoxtextBoxFrom.sGetValue();
  2177. fromValUse = fromValUse.replace("\.", decimalSeparator);
  2178. fromValDisplay = textBoxtextBoxFrom.sGetFormatValue();
  2179. }
  2180. else if ((substVarValueFrom != null)&&(document.getElementById("textBoxStringFrom").style.display != "none"))
  2181. {
  2182. fromValUse = substVarValueFrom.replace("\.", decimalSeparator);
  2183. fromValDisplay = textBoxtextBoxStringFrom.sGetFormatValue();
  2184. }
  2185. var toValUse = '';
  2186. var toValDisplay = '';
  2187. if((textBoxtextBoxTo.sGetValue() != '')&&(document.getElementById("textBoxNumericTo").style.display != "none"))
  2188. {
  2189. toValUse = textBoxtextBoxTo.sGetValue();
  2190. toValUse = toValUse.replace("\.", decimalSeparator);
  2191. toValDisplay = textBoxtextBoxTo.sGetFormatValue();
  2192. }
  2193. else if ((substVarValueTo != null)&&(document.getElementById("textBoxStringTo").style.display != "none"))
  2194. {
  2195. toValUse = substVarValueTo.replace("\.", decimalSeparator);
  2196. toValDisplay = textBoxtextBoxStringTo.sGetFormatValue();
  2197. }
  2198. if (((fromValUse != "" && document.f.fromValue[0].checked)&&(toValUse != "" && document.f.toValue[0].checked))&&(parseFloat(toValUse) < parseFloat(fromValUse)))
  2199. {
  2200. var tmp = fromValUse;
  2201. fromValUse = toValUse;
  2202. toValUse = tmp;
  2203. tmp = fromValDisplay;
  2204. fromValDisplay = toValDisplay;
  2205. toValDisplay = tmp;
  2206. }
  2207. if ((fromValUse == "" && fromValUse.length == 0)|| document.f.fromValue[1].checked == true)
  2208. {
  2209. fromValUse = sFILTER_NUMBER_LOWEST;
  2210. }
  2211. if ((toValUse == "" && toValUse.length == 0) || document.f.toValue[1].checked == true)
  2212. {
  2213. toValUse = sFILTER_NUMBER_HIGHEST;
  2214. }
  2215. if (document.f.promptBox.checked)
  2216. {
  2217. var promptID = getPromptId();
  2218. fe.setPrompt(promptID);
  2219. var promptValues = '<selectChoices>';
  2220. if ((fromValUse == '<xts:string id="FILTER_NUMBER_LOWEST" encode="javascript"/>' && toValUse == '<xts:string id="FILTER_NUMBER_HIGHEST" encode="javascript"/>') ||
  2221. (fromValUse == sFILTER_NUMBER_LOWEST && toValUse == sFILTER_NUMBER_HIGHEST))
  2222. {
  2223. onlyPrompt = true;
  2224. promptValues = '<selectChoices/>';
  2225. }
  2226. else
  2227. {
  2228. if (fromValUse == sFILTER_NUMBER_LOWEST)
  2229. {
  2230. promptValues += '<selectUnboundedStartRange selected="true">';
  2231. promptValues += '<end displayValue="' + sXmlEncode(toValDisplay) + '" useValue="' + sXmlEncode(toValUse) + '"/>';
  2232. promptValues += '</selectUnboundedStartRange>';
  2233. }
  2234. else if (toValUse == sFILTER_NUMBER_HIGHEST)
  2235. {
  2236. promptValues += '<selectUnboundedEndRange selected="true">';
  2237. promptValues += '<start displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '"/>';
  2238. promptValues += '</selectUnboundedEndRange>';
  2239. }
  2240. else if (fromValUse == toValUse)
  2241. {
  2242. promptValues += '<selectOption displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '" selected="true"/>';
  2243. }
  2244. else
  2245. {
  2246. promptValues += '<selectBoundRange selected="true">';
  2247. promptValues += '<start displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '"/>';
  2248. promptValues += '<end displayValue="' + sXmlEncode(toValDisplay) + '" useValue="' + sXmlEncode(toValUse) + '"/>';
  2249. promptValues += '</selectBoundRange>';
  2250. }
  2251. promptValues += '</selectChoices>';
  2252. }
  2253. cf.updateOrAddPromptParm("p_" + promptID, promptValues);
  2254. }
  2255. else
  2256. {
  2257. if (fromValUse != sFILTER_NUMBER_LOWEST)
  2258. {
  2259. fe.setFrom(fromValUse, (fromValDisplay ? fromValDisplay : fromValUse));
  2260. }
  2261. if (toValUse != sFILTER_NUMBER_HIGHEST)
  2262. {
  2263. fe.setTo(toValUse, (toValDisplay ? toValDisplay : toValUse));
  2264. }
  2265. }
  2266. return fe;
  2267. };
  2268. function filterNumRange_execute()
  2269. {
  2270. if((document.f.fromValue[0].checked && !textBoxtextBoxFrom.isValid())||(document.f.toValue[0].checked && !textBoxtextBoxTo.isValid()))
  2271. {
  2272. return;
  2273. }
  2274. submitFilterExpression( filterNumRange_buildFilterExpression() );
  2275. };
  2276. function filterNumRange_init(oOptions)
  2277. {
  2278. attachMouseEvents();
  2279. var x = document.getElementById("colName");
  2280. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  2281. initNullOptions();
  2282. filterCommon_initBasedOnDatasourceBox();
  2283. if (cf.isDetailFilterEnabled())
  2284. {
  2285. document.getElementById("filterBasedOnInfoMessage").style.display = "block";
  2286. }
  2287. if (oOptions.bPrompt)
  2288. {
  2289. document.f.promptBox.checked = true;
  2290. }
  2291. if (cf && cf.showDialogFrame)
  2292. {
  2293. cf.showDialogFrame(410);
  2294. }
  2295. var oTextBoxFrom = document.getElementById('textEditBoxtextBoxFrom');
  2296. if (oTextBoxFrom)
  2297. {
  2298. oTextBoxFrom.onclick = fromGotFocus;
  2299. oTextBoxFrom.onkeypress = fromGotFocus;
  2300. oTextBoxFrom.onpaste = fromGotFocus;
  2301. }
  2302. var oTextBoxTo = document.getElementById('textEditBoxtextBoxTo');
  2303. if (oTextBoxTo)
  2304. {
  2305. oTextBoxTo.onclick = toGotFocus;
  2306. oTextBoxTo.onkeypress = toGotFocus;
  2307. oTextBoxTo.onpaste = toGotFocus;
  2308. }
  2309. if (!textBoxtextBoxFrom.m_oForm.disabled)
  2310. {
  2311. textBoxtextBoxFrom.m_oForm.focus();
  2312. }
  2313. };
  2314. function filterNumSumRange_buildFilterExpression()
  2315. {
  2316. var fe = new cf.CFilterExpression();
  2317. fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
  2318. onlyPrompt = false;
  2319. var fromValUse = '';
  2320. var fromValDisplay = '';
  2321. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  2322. {
  2323. var no = getNullOption();
  2324. fe.setNullOption(no);
  2325. if (no == "only")
  2326. {
  2327. return fe;
  2328. }
  2329. }
  2330. var decimalSeparator = goDialogManager.getMiniQueryManager().getDecimalSeparator();
  2331. if((textBoxtextBoxFrom.sGetValue() != '')&&(document.getElementById("textBoxNumericFrom").style.display != "none"))
  2332. {
  2333. fromValUse = textBoxtextBoxFrom.sGetValue();
  2334. fromValUse = fromValUse.replace("\.", decimalSeparator);
  2335. fromValDisplay = textBoxtextBoxFrom.sGetFormatValue();
  2336. }
  2337. else if ((substVarValueFrom != null)&&(document.getElementById("textBoxStringFrom").style.display != "none"))
  2338. {
  2339. fromValUse = substVarValueFrom.replace("\.", decimalSeparator);
  2340. fromValDisplay = textBoxtextBoxStringFrom.sGetFormatValue();
  2341. }
  2342. var toValUse = '';
  2343. var toValDisplay = '';
  2344. if((textBoxtextBoxTo.sGetValue() != '')&&(document.getElementById("textBoxNumericTo").style.display != "none"))
  2345. {
  2346. toValUse = textBoxtextBoxTo.sGetValue();
  2347. toValUse = toValUse.replace("\.", decimalSeparator);
  2348. toValDisplay = textBoxtextBoxTo.sGetFormatValue();
  2349. }
  2350. else if ((substVarValueTo != null)&&(document.getElementById("textBoxStringTo").style.display != "none"))
  2351. {
  2352. toValUse = substVarValueTo.replace("\.", decimalSeparator);
  2353. toValDisplay = textBoxtextBoxStringTo.sGetFormatValue();
  2354. }
  2355. if (((fromValUse != "" && document.f.fromValue[0].checked)&&(toValUse != "" && document.f.toValue[0].checked))&&(parseFloat(toValUse) < parseFloat(fromValUse)))
  2356. {
  2357. var tmp = fromValUse;
  2358. fromValUse = toValUse;
  2359. toValUse = tmp;
  2360. tmp = fromValDisplay;
  2361. fromValDisplay = toValDisplay;
  2362. toValDisplay = tmp;
  2363. }
  2364. if ((fromValUse == "" && fromValUse.length == 0)|| document.f.fromValue[1].checked == true)
  2365. {
  2366. fromValUse = sFILTER_NUMBER_LOWEST;
  2367. }
  2368. if ((toValUse == "" && toValUse.length == 0) || document.f.toValue[1].checked == true)
  2369. {
  2370. toValUse = sFILTER_NUMBER_HIGHEST;
  2371. }
  2372. if (document.f.promptBox.checked)
  2373. {
  2374. var promptID = getPromptId();
  2375. fe.setPrompt(promptID);
  2376. var promptValues = '<selectChoices>';
  2377. if (fromValUse == sFILTER_NUMBER_LOWEST && toValUse == sFILTER_NUMBER_HIGHEST)
  2378. {
  2379. onlyPrompt = true;
  2380. promptValues = '<selectChoices/>';
  2381. }
  2382. else
  2383. {
  2384. if (fromValUse == sFILTER_NUMBER_LOWEST)
  2385. {
  2386. promptValues += '<selectUnboundedStartRange selected="true">';
  2387. promptValues += '<end displayValue="' + sXmlEncode(toValDisplay) + '" useValue="' + sXmlEncode(toValUse) + '"/>';
  2388. promptValues += '</selectUnboundedStartRange>';
  2389. }
  2390. else if (toValUse == sFILTER_NUMBER_HIGHEST)
  2391. {
  2392. promptValues += '<selectUnboundedEndRange selected="true">';
  2393. promptValues += '<start displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '"/>';
  2394. promptValues += '</selectUnboundedEndRange>';
  2395. }
  2396. else if (fromValUse == toValUse)
  2397. {
  2398. promptValues += '<selectOption displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '" selected="true"/>';
  2399. }
  2400. else
  2401. {
  2402. promptValues += '<selectBoundRange selected="true">';
  2403. promptValues += '<start displayValue="' + sXmlEncode(fromValDisplay) + '" useValue="' + sXmlEncode(fromValUse) + '"/>';
  2404. promptValues += '<end displayValue="' + sXmlEncode(toValDisplay) + '" useValue="' + sXmlEncode(toValUse) + '"/>';
  2405. promptValues += '</selectBoundRange>';
  2406. }
  2407. promptValues += '</selectChoices>';
  2408. }
  2409. cf.updateOrAddPromptParm("p_" + promptID, promptValues);
  2410. }
  2411. else
  2412. {
  2413. if (fromValUse != sFILTER_NUMBER_LOWEST)
  2414. {
  2415. fe.setFrom(fromValUse, (fromValDisplay ? fromValDisplay : fromValUse));
  2416. }
  2417. if (toValUse != sFILTER_NUMBER_HIGHEST)
  2418. {
  2419. fe.setTo(toValUse, (toValDisplay ? toValDisplay : toValUse));
  2420. }
  2421. }
  2422. return fe;
  2423. };
  2424. function filterNumSumRange_execute()
  2425. {
  2426. var oMQMgr = goDialogManager.getMiniQueryManager();
  2427. if((document.f.fromValue[0].checked && !textBoxtextBoxFrom.isValid())||(document.f.toValue[0].checked && !textBoxtextBoxTo.isValid()))
  2428. {
  2429. return;
  2430. }
  2431. var fString = filterNumSumRange_buildFilterExpression();
  2432. var summaryValue = filterNumSumRange_getSummaryValue();
  2433. submitFilter(fString, onlyPrompt, summaryValue);
  2434. };
  2435. function filterNumSumRange_getSummaryValue()
  2436. {
  2437. var oMQMgr = goDialogManager.getMiniQueryManager();
  2438. var summaryValue = !(summarizationValue == "raw" && cf.isDetailFilterEnabled());
  2439. if ( summarizationValue == "summary" )
  2440. {
  2441. summaryValue = document.getElementById("summary").value;
  2442. if (typeof summaryValue == "string" && summaryValue.match(/^\d+$/))
  2443. {
  2444. summaryValue = parseInt(summaryValue, 10);
  2445. }
  2446. summaryValue = oMQMgr.getColumnId(summaryValue);
  2447. }
  2448. return (summaryValue);
  2449. };
  2450. function filterNumSumRange_init(oOptions)
  2451. {
  2452. attachMouseEvents();
  2453. if (oOptions.bPrompt)
  2454. {
  2455. document.f.promptBox.checked = true;
  2456. }
  2457. var x = document.getElementById("colName");
  2458. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  2459. if (cf && cf.showDialogFrame)
  2460. {
  2461. cf.showDialogFrame(420);
  2462. }
  2463. var y = document.createElement("select");
  2464. y.id = "summary";
  2465. if (oOptions.sUnSummarized == "" && cf.dlgGlobalGetParm('xxFilterDependancy'))
  2466. {
  2467. if (oOptions.sNonMeasure == "")
  2468. {
  2469. document.getElementById("displayNonMeasureSumm").style.display = "none";
  2470. document.getElementById("displayMeasureGrp").style.display = "inline";
  2471. document.getElementById("displayMeasureNoGrp").style.display = "none";
  2472. document.getElementById("measureGrp").appendChild(y);
  2473. if (cf.dlgGlobalGetParm('xxBasedOn') == 'summary')
  2474. {
  2475. document.f.summarization1[1].checked = "true";
  2476. }
  2477. else
  2478. {
  2479. y.disabled = "true";
  2480. if ((cf.dlgGlobalGetParm('xxBasedOn') == 'raw') && cf.isDetailFilterEnabled())
  2481. {
  2482. document.f.summarization1[2].checked = "true";
  2483. }
  2484. else
  2485. {
  2486. document.f.summarization1[0].checked = "true";
  2487. }
  2488. }
  2489. if (!cf.isDetailFilterEnabled())
  2490. {
  2491. document.getElementById("displayBasedOn1").style.display = "none";
  2492. document.getElementById("displayBasedOn2").style.display = "none";
  2493. }
  2494. if (cf.isDetailFilterEnabled())
  2495. {
  2496. var oInfoMessage = document.getElementById("filterBasedOnInfoMessage");
  2497. if (oInfoMessage)
  2498. {
  2499. oInfoMessage.style.display = "block";
  2500. }
  2501. }
  2502. }
  2503. else
  2504. {
  2505. document.getElementById("displayNonMeasureSumm").style.display = "inline";
  2506. document.getElementById("displayMeasureGrp").style.display = "none";
  2507. document.getElementById("displayMeasureNoGrp").style.display = "none";
  2508. document.getElementById("nonMeasureSumm").appendChild(y);
  2509. if (cf.dlgGlobalGetParm('xxBasedOn') == 'summary')
  2510. {
  2511. document.f.summarization2[1].checked = "true";
  2512. }
  2513. else
  2514. {
  2515. document.f.summarization2[0].checked = "true";
  2516. }
  2517. }
  2518. if (cf.dlgGlobalGetParm('xxBasedOn') && cf.dlgGlobalGetParm('xxBasedOn') != 'summary')
  2519. {
  2520. y.disabled = "true";
  2521. }
  2522. for (var i = 0; i < cf.dlgGlobalSize('xxFilterDependancy'); i++)
  2523. {
  2524. var label = cf.dlgGlobalGetParmAt('xxFilterDependancy', i);
  2525. var newOption = new Option(label[1], label[0]);
  2526. y.options[y.options.length] = newOption;
  2527. if (cf.dlgGlobalGetParm('xxSummaryOf') == label[0])
  2528. {
  2529. y.options[y.options.length - 1].selected = "true";
  2530. }
  2531. }
  2532. }
  2533. else
  2534. {
  2535. document.getElementById("displayNonMeasureSumm").style.display = "none";
  2536. document.getElementById("displayMeasureGrp").style.display = "none";
  2537. if (cf.isDetailFilterEnabled())
  2538. {
  2539. document.getElementById("displayMeasureNoGrp").style.display = "inline";
  2540. if (cf.dlgGlobalGetParm('xxBasedOn') == 'raw')
  2541. {
  2542. document.f.summarization3[1].checked = "true";
  2543. }
  2544. else
  2545. {
  2546. document.f.summarization3[0].checked = "true";
  2547. }
  2548. }
  2549. else
  2550. {
  2551. document.getElementById("displayMeasureNoGrp").style.display = "none";
  2552. }
  2553. }
  2554. summarizationValue = (cf.dlgGlobalGetParm('xxBasedOn') ? cf.dlgGlobalGetParm('xxBasedOn') : "details");
  2555. initNullOptions();
  2556. var oTextBoxFrom = document.getElementById('textEditBoxtextBoxFrom');
  2557. if (oTextBoxFrom)
  2558. {
  2559. oTextBoxFrom.onclick = fromGotFocus;
  2560. oTextBoxFrom.onkeypress = fromGotFocus;
  2561. oTextBoxFrom.onpaste = fromGotFocus;
  2562. }
  2563. var oTextBoxTo = document.getElementById('textEditBoxtextBoxTo');
  2564. if (oTextBoxTo)
  2565. {
  2566. oTextBoxTo.onclick = toGotFocus;
  2567. oTextBoxTo.onkeypress = toGotFocus;
  2568. oTextBoxTo.onpaste = toGotFocus;
  2569. }
  2570. if (!textBoxtextBoxFrom.m_oForm.disabled)
  2571. {
  2572. textBoxtextBoxFrom.m_oForm.focus();
  2573. }
  2574. };
  2575. function filterNumSumRange_setState(enabled)
  2576. {
  2577. if (document.getElementById("summary"))
  2578. {
  2579. if (enabled)
  2580. {
  2581. document.getElementById("summary").removeAttribute("disabled");
  2582. }
  2583. else
  2584. {
  2585. document.getElementById("summary").disabled = true;
  2586. }
  2587. }
  2588. return true;
  2589. };
  2590. function filterNumSumRange_setSummVal(val)
  2591. {
  2592. if (summarizationValue != val)
  2593. {
  2594. summarizationValue = val;
  2595. }
  2596. if (cf.cfgGet("combinedFilters") != null)
  2597. {
  2598. cf.setFilterMode(cf.giFILTERCPLXMODE_PRE_WIZARD);
  2599. }
  2600. };
  2601. function filterPicklist_buildFilterExpression()
  2602. {
  2603. var fe = new cf.CFilterExpression();
  2604. onlyPrompt = false;
  2605. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true && cf.isDetailFilterEnabled())
  2606. {
  2607. var no = getNullOption();
  2608. fe.setNullOption(no);
  2609. if (no == "only")
  2610. {
  2611. return fe;
  2612. }
  2613. }
  2614. if (filterPicklist_someCheckedSomeUnchecked() || document.f.oExcludeSelectedValues.options[1].selected === true)
  2615. {
  2616. var promptID = getPromptId();
  2617. if (document.f.promptBox.checked)
  2618. {
  2619. fe.setPrompt(promptID);
  2620. }
  2621. var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
  2622. if (sDataType !== "")
  2623. {
  2624. fe.setDataType(sDataType);
  2625. }
  2626. var aPromptValues = new Object();
  2627. for (i = 0; i < checkBoxListpList.m_oForm.length; i++)
  2628. {
  2629. if ( checkBoxListpList.m_oForm[i].checked )
  2630. {
  2631. var str = checkBoxListpList.m_oForm[i].value;
  2632. if (document.f.promptBox.checked)
  2633. {
  2634. var sDisplayValue = cf.getDisplayValueForOption(checkBoxListpList.m_oForm[i]);
  2635. var sUseValue = str;
  2636. aPromptValues[sUseValue] = sDisplayValue;
  2637. }
  2638. else
  2639. {
  2640. var dv = null;
  2641. if (checkBoxListpList.m_oForm[i].nextSibling && checkBoxListpList.m_oForm[i].nextSibling.nodeType == 3)
  2642. {
  2643. dv = checkBoxListpList.m_oForm[i].nextSibling.nodeValue;
  2644. }
  2645. fe.addValue(str, dv);
  2646. }
  2647. }
  2648. }
  2649. if (document.f.promptBox.checked)
  2650. {
  2651. var oParamManager = cf.goApplicationManager.getReportManager().getParameterManager();
  2652. var sPromptValues = oParamManager.getOptionPromptValues(aPromptValues);
  2653. cf.updateOrAddPromptParm("p_" + promptID, sPromptValues);
  2654. }
  2655. }
  2656. else if (document.f.promptBox.checked)
  2657. {
  2658. var promptID = getPromptId();
  2659. fe.setPrompt(promptID);
  2660. cf.updateOrAddPromptParm("p_" + promptID, '<selectChoices/>');
  2661. onlyPrompt = true;
  2662. }
  2663. return fe;
  2664. };
  2665. function filterPicklist_execute()
  2666. {
  2667. submitFilterExpression( filterPicklist_buildFilterExpression() );
  2668. };
  2669. function filterPicklist_hideLoading()
  2670. {
  2671. var theDiv = document.getElementById("loadingDiv");
  2672. theDiv.parentNode.removeChild(theDiv);
  2673. };
  2674. function filterPicklist_init(sPromptName, sSearchForLabel, sTypeInLabel)
  2675. {
  2676. attachMouseEvents();
  2677. var x = document.getElementById("link1");
  2678. if (cf.dlgGlobalGetParm('xxIsSearchAllowed') != true)
  2679. {
  2680. x.style.display = "none";
  2681. }
  2682. var y = document.getElementById("link2");
  2683. var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
  2684. if (sDataType === "MUN")
  2685. {
  2686. y.style.display = "none";
  2687. }
  2688. var basedOnVal = filterCommon_initBasedOnDatasourceBox();
  2689. if (cf.isDetailFilterEnabled())
  2690. {
  2691. document.getElementById("filterBasedOnInfoMessage").style.display = "block";
  2692. }
  2693. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  2694. {
  2695. x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
  2696. if (sDataType !== "MUN")
  2697. {
  2698. y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
  2699. }
  2700. }
  2701. else
  2702. {
  2703. x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
  2704. if (sDataType !== "MUN")
  2705. {
  2706. y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
  2707. }
  2708. }
  2709. x.appendChild(document.createTextNode(sSearchForLabel));
  2710. if (y.href)
  2711. {
  2712. y.appendChild(document.createTextNode(sTypeInLabel));
  2713. }
  2714. x = document.getElementById("colName");
  2715. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  2716. if (cf.dlgGlobalGetParm('xxPromptState') == true)
  2717. {
  2718. document.f.promptBox.checked = true;
  2719. }
  2720. else if (cf.dlgGlobalGetParm('xxPromptState') == false)
  2721. {
  2722. document.f.promptBox.checked = false;
  2723. }
  2724. else if (sPromptName != "")
  2725. {
  2726. document.f.promptBox.checked = true;
  2727. }
  2728. if (cf && cf.showDialogFrame)
  2729. {
  2730. cf.cfgSet("DialogSize", advClosedSize);
  2731. }
  2732. initNullOptions();
  2733. filterPicklist_sendRequestForList();
  2734. };
  2735. function filterPicklist_processResponse(response)
  2736. {
  2737. hideLoading();
  2738. cf.dlgGlobalSetParm("xxActiveRequest", null);
  2739. if (!cf.checkResponse(response, document, "filterPickList", filterPicklist_sendRequestForList))
  2740. {
  2741. return;
  2742. }
  2743. var bPrompting = false;
  2744. var sReportSpecification = "";
  2745. eval(response);
  2746. if(typeof status != "undefined" && status == "working" && typeof tracking != "undefined" && tracking != "")
  2747. {
  2748. showLoading();
  2749. requestTracking = tracking;
  2750. var url = "m=/" + cf.qs_dir + "/filterPickListRequest.xts&b_action=xts.run&ui.action=wait&m_tracking=";
  2751. url += tracking;
  2752. if (typeof cf.routingServerGroup != "undefined")
  2753. {
  2754. url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
  2755. }
  2756. if (cf.cafContextId != "")
  2757. {
  2758. url += "&ui.cafcontextid=" + cf.cafContextId;
  2759. }
  2760. setTimeout("sendWaitRequest('" + url + "');", 100);
  2761. }
  2762. if (bPrompting && bPrompting === true)
  2763. {
  2764. sendPromptRequest(sReportSpecification);
  2765. }
  2766. else
  2767. {
  2768. requestTracking = "";
  2769. var allCheckBoxes = document.f.p_pickList;
  2770. if (typeof allCheckBoxes != "undefined")
  2771. {
  2772. var numFound = 0;
  2773. var convertRangeToCheckBoxes = cf.dlgGlobalGetParm("xxConvertRangeToENUM");
  2774. if (convertRangeToCheckBoxes)
  2775. {
  2776. numFound = filterPicklist_convertRangeToCheckBoxes(allCheckBoxes);
  2777. }
  2778. else
  2779. {
  2780. for (var i = 0; i < allCheckBoxes.length; i++)
  2781. {
  2782. for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
  2783. {
  2784. var useValue = fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j));
  2785. if (allCheckBoxes[i].value.toUpperCase() == useValue.toUpperCase())
  2786. {
  2787. allCheckBoxes[i].checked = true;
  2788. checkBoxListpList.updateSelected(true);
  2789. checkBoxListpList.checkData();
  2790. numFound++;
  2791. break;
  2792. }
  2793. }
  2794. for (var k = 1; k < cf.dlgGlobalSize("xxSelects"); k += 2)
  2795. {
  2796. if (allCheckBoxes[i].value.toUpperCase() == cf.dlgGlobalGetParmAt("xxSelects", k).toUpperCase())
  2797. {
  2798. allCheckBoxes[i].checked = true;
  2799. checkBoxListpList.updateSelected(true);
  2800. checkBoxListpList.checkData();
  2801. numFound++;
  2802. break;
  2803. }
  2804. }
  2805. if (numFound == (cf.dlgGlobalSize("xxPickList") + (cf.dlgGlobalSize("xxSelects") / 2)))
  2806. {
  2807. break;
  2808. }
  2809. }
  2810. }
  2811. }
  2812. cf.dlgGlobalRemoveParm("xxPickListIsLoaded");
  2813. cf.dlgGlobalRemoveParm("xxSelectsIsLoaded");
  2814. }
  2815. };
  2816. function filterPicklist_convertRangeToCheckBoxes(allCheckBoxes)
  2817. {
  2818. var convertFromValue = cf.dlgGlobalGetParm("xxConvertRangeFromValue");
  2819. convertFromValue = convertFromValue.getAttribute("use");
  2820. var convertToValue = cf.dlgGlobalGetParm("xxConvertRangeToValue");
  2821. convertToValue = convertToValue.getAttribute("use");
  2822. var isString = false;
  2823. if (isNaN(convertFromValue) || isNaN(convertToValue))
  2824. {
  2825. isString = true;
  2826. }
  2827. if (!isString)
  2828. {
  2829. for (var i = 0; i < allCheckBoxes.length; i++)
  2830. {
  2831. currentCheckBoxValue = allCheckBoxes[i].value.toUpperCase();
  2832. if (isNaN(currentCheckBoxValue))
  2833. {
  2834. isString = true;
  2835. break;
  2836. }
  2837. }
  2838. }
  2839. if (!isString)
  2840. {
  2841. convertFromValue = +convertFromValue;
  2842. convertToValue = +convertToValue;
  2843. }
  2844. var currentCheckBoxValue;
  2845. var numFound = 0;
  2846. if (convertFromValue && convertToValue)
  2847. {
  2848. for (var i = 0; i < allCheckBoxes.length; i++)
  2849. {
  2850. currentCheckBoxValue = allCheckBoxes[i].value.toUpperCase();
  2851. if (!isString)
  2852. {
  2853. currentCheckBoxValue = +currentCheckBoxValue;
  2854. }
  2855. if ((currentCheckBoxValue >= convertFromValue) && (currentCheckBoxValue <= convertToValue))
  2856. {
  2857. allCheckBoxes[i].checked = true;
  2858. checkBoxListpList.updateSelected(true);
  2859. checkBoxListpList.checkData();
  2860. numFound++;
  2861. }
  2862. }
  2863. }
  2864. return numFound;
  2865. };
  2866. function filterPicklist_sendRequestForList()
  2867. {
  2868. sendPicklistRequest();
  2869. };
  2870. function filterPicklist_sendWaitRequest(url)
  2871. {
  2872. cf.sendDispatcherRequest(url, processResponse);
  2873. };
  2874. function filterPicklist_showCancellingIndicator()
  2875. {
  2876. var theDiv = document.getElementById("loadingDiv");
  2877. if(theDiv)
  2878. {
  2879. var oldSpanText = theDiv.getElementsByTagName("SPAN");
  2880. if(oldSpanText.length > 0)
  2881. {
  2882. var newSpanText = document.createElement("SPAN");
  2883. newSpanText.appendChild(document.createTextNode(sCancelIndicator));
  2884. theDiv.replaceChild(newSpanText, oldSpanText[0]);
  2885. }
  2886. }
  2887. };
  2888. function filterPicklist_showLoading()
  2889. {
  2890. var theParent = document.getElementById("selectListpList");
  2891. var newDiv = document.createElement("DIV");
  2892. newDiv.id = "loadingDiv";
  2893. newDiv.className = "clsCheckBox";
  2894. var loadingIcon = document.createElement("IMG");
  2895. loadingIcon.align = "middle";
  2896. loadingIcon.src = cf.TREE_LOADING;
  2897. newDiv.appendChild(loadingIcon);
  2898. var newSpanText = document.createElement("SPAN");
  2899. newSpanText.appendChild(document.createTextNode(PMT_TRE_TREE_LOADING));
  2900. newSpanText.style.paddingLeft = "4px";
  2901. newDiv.appendChild(newSpanText);
  2902. newDiv.style.verticalAlign = "middle";
  2903. newDiv.style.padding = "2px";
  2904. theParent.appendChild(newDiv);
  2905. };
  2906. function filterPicklist_someCheckedSomeUnchecked()
  2907. {
  2908. return ((checkBoxListpList.m_iSelectedCount > 0) && (checkBoxListpList.m_iItemCount > checkBoxListpList.m_iSelectedCount));
  2909. };
  2910. function filterSearch_buildFilterExpression()
  2911. {
  2912. var fe = new cf.CFilterExpression();
  2913. onlyPrompt = false;
  2914. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  2915. {
  2916. var no = getNullOption();
  2917. fe.setNullOption(no);
  2918. if (no == "only")
  2919. {
  2920. return fe;
  2921. }
  2922. }
  2923. if (searchpSearch.m_oLstChoices.length > 0)
  2924. {
  2925. var promptID = getPromptId();
  2926. if (document.f.promptBox.checked)
  2927. {
  2928. fe.setPrompt(promptID);
  2929. }
  2930. var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
  2931. if (sDataType !== "")
  2932. {
  2933. fe.setDataType(sDataType);
  2934. }
  2935. var promptValues = '<selectChoices>';
  2936. for (i = 0; i < searchpSearch.m_oLstChoices.length; i++)
  2937. {
  2938. var str = searchpSearch.m_oLstChoices.options[i].value;
  2939. var dv = cf.getDisplayValueForOption(searchpSearch.m_oLstChoices.options[i]);
  2940. if (document.f.promptBox.checked)
  2941. {
  2942. promptValues += '<selectOption displayValue="' + sXmlEncode(dv) + '" useValue="' + sXmlEncode(str) + '" selected="true"/>';
  2943. }
  2944. else
  2945. {
  2946. fe.addValue(str, dv);
  2947. }
  2948. }
  2949. if (document.f.promptBox.checked)
  2950. {
  2951. promptValues += '</selectChoices>';
  2952. cf.updateOrAddPromptParm("p_" + promptID, promptValues);
  2953. }
  2954. }
  2955. else if (document.f.promptBox.checked)
  2956. {
  2957. var promptID = getPromptId();
  2958. fe.setPrompt(promptID);
  2959. cf.updateOrAddPromptParm("p_" + promptID, '<selectChoices/>');
  2960. onlyPrompt = true;
  2961. }
  2962. fe.setFilterType("search");
  2963. return fe;
  2964. };
  2965. function filterSearch_execute()
  2966. {
  2967. cf.cfgSet("LAST_ACTION", "filterSearchExecute");
  2968. submitFilterExpression( filterSearch_buildFilterExpression() );
  2969. };
  2970. function filterSearch_init()
  2971. {
  2972. attachMouseEvents();
  2973. var x = document.getElementById("link1");
  2974. var y = document.getElementById("link2");
  2975. var sDataType = getFilterDataType(cf.dlgGlobalGetParm("xxFCid"));
  2976. if (sDataType === "MUN")
  2977. {
  2978. y.style.display = "none";
  2979. }
  2980. var basedOnVal = filterCommon_initBasedOnDatasourceBox();
  2981. if (cf.isDetailFilterEnabled())
  2982. {
  2983. document.getElementById("filterBasedOnInfoMessage").style.display = "block";
  2984. }
  2985. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  2986. {
  2987. x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
  2988. if (sDataType !== "MUN")
  2989. {
  2990. y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
  2991. }
  2992. }
  2993. else
  2994. {
  2995. x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterPickList', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
  2996. if (sDataType !== "MUN")
  2997. {
  2998. y.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterTypeInExactlyMatches', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
  2999. }
  3000. }
  3001. x.appendChild(document.createTextNode(sFILTER_PICK_VALUES));
  3002. if (y.href)
  3003. {
  3004. y.appendChild(document.createTextNode(sFILTER_TYPE_IN_VALUES));
  3005. }
  3006. x = document.getElementById("colName");
  3007. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  3008. if (cf.dlgGlobalGetParm('xxPromptState') == true)
  3009. {
  3010. document.f.promptBox.checked = true;
  3011. }
  3012. else if (cf.dlgGlobalGetParm('xxPromptState') == false)
  3013. {
  3014. document.f.promptBox.checked = false;
  3015. }
  3016. else if (sXXPromptParam != "")
  3017. {
  3018. document.f.promptBox.checked = true;
  3019. }
  3020. initNullOptions();
  3021. if (sPromptCB!='')
  3022. {
  3023. document.f.promptBox.checked = (sPromptCB == 'true' ? true : false);
  3024. }
  3025. if (cf && cf.showDialogFrame)
  3026. {
  3027. cf.showDialogFrame(520);
  3028. if (searchpSearch.m_oLstChoices.options.length == 0)
  3029. {
  3030. var uv = null;
  3031. var dv = null;
  3032. if (cf.dlgGlobalGetParm("xxPickListIsLoaded") != true)
  3033. {
  3034. for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
  3035. {
  3036. uv = fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j));
  3037. dv = fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxPickList", j));
  3038. searchpSearch.addNoUpdate(dv, uv);
  3039. }
  3040. }
  3041. if (cf.dlgGlobalGetParm("xxSelectsIsLoaded") != true)
  3042. {
  3043. for (var k = 0; k < cf.dlgGlobalSize("xxSelects"); k += 2)
  3044. {
  3045. uv = fd_getUseValue(cf.dlgGlobalGetParmAt("xxSelects", k + 1));
  3046. dv = fd_getDisplayValue(cf.dlgGlobalGetParmAt("xxSelects", k));
  3047. searchpSearch.addNoUpdate(dv, uv);
  3048. }
  3049. }
  3050. searchpSearch.update();
  3051. cf.dlgGlobalSetParm("xxPickListIsLoaded", true);
  3052. cf.dlgGlobalSetParm("xxSelectsIsLoaded", true);
  3053. }
  3054. }
  3055. document.f._sws_pSearch_searchValue.focus();
  3056. if (typeof searchpSearch == "object");
  3057. {
  3058. searchpSearch.startAnimateSearchIcon();
  3059. }
  3060. sendSearchRequest(true);
  3061. };
  3062. function filterTimeRange_buildFilterExpression()
  3063. {
  3064. var fe = new cf.CFilterExpression();
  3065. fe.setFilterType(cf.gsFE_FILTERTYPE_RANGE);
  3066. var fromValDisplay = null;
  3067. var toValDisplay = null;
  3068. onlyPrompt = false;
  3069. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  3070. {
  3071. var no = getNullOption();
  3072. fe.setNullOption(no);
  3073. if (no == "only")
  3074. {
  3075. return fe;
  3076. }
  3077. }
  3078. var fromValueString = timePickertimeFrom.sGetValue();
  3079. var toValueString = timePickertimeTo.sGetValue();
  3080. if (document.getElementById("textBoxstringValueFrom"))
  3081. {
  3082. if (document.f.fromValue[1].checked == true && substVarValueFrom != null)
  3083. {
  3084. fromValueString = substVarValueFrom;
  3085. fromValDisplay = textBoxstringValueFrom.sGetFormatValue();
  3086. }
  3087. else if ((fromValueString == '' && fromValueString.length == 0) || (document.f.fromValue[2].checked == true))
  3088. {
  3089. fromValueString = sFILTER_TIME_EARLIEST;
  3090. }
  3091. if (document.f.toValue[1].checked == true && substVarValueTo != null)
  3092. {
  3093. toValueString = substVarValueTo;
  3094. toValDisplay = textBoxstringValueTo.sGetFormatValue();
  3095. }
  3096. else if ((toValueString == '' && toValueString.length == 0) || (document.f.toValue[2].checked == true))
  3097. {
  3098. toValueString = sFILTER_TIME_LATEST;
  3099. }
  3100. }
  3101. else
  3102. {
  3103. if ((fromValueString == '' && fromValueString.length == 0) || document.f.fromValue[1].checked == true)
  3104. {
  3105. fromValueString = sFILTER_TIME_EARLIEST;
  3106. }
  3107. if ((toValueString == '' && toValueString.length == 0) || document.f.toValue[1].checked == true)
  3108. {
  3109. toValueString = sFILTER_TIME_LATEST;
  3110. }
  3111. }
  3112. if (((fromValueString != "" && document.f.fromValue[0].checked)&&(toValueString != "" && document.f.toValue[0].checked))&&(fromValueString > toValueString))
  3113. {
  3114. var tmp = fromValueString;
  3115. fromValueString = toValueString;
  3116. toValueString = tmp;
  3117. }
  3118. if (document.f.promptBox.checked)
  3119. {
  3120. var promptID = getPromptId();
  3121. fe.setPrompt(promptID);
  3122. var promptValues = '<selectChoices>';
  3123. if (fromValueString == sFILTER_TIME_EARLIEST && toValueString == sFILTER_TIME_LATEST)
  3124. {
  3125. onlyPrompt = true;
  3126. promptValues = '<selectChoices/>';
  3127. }
  3128. else
  3129. {
  3130. if (fromValueString == sFILTER_TIME_EARLIEST)
  3131. {
  3132. promptValues += '<selectUnboundedStartRange selected="true">';
  3133. promptValues += '<end displayValue="';
  3134. promptValues += sXmlEncode(toValDisplay ? toValDisplay : toValueString);
  3135. promptValues += '" useValue="' + sXmlEncode(toValueString) + '"/>';
  3136. promptValues += '</selectUnboundedStartRange>';
  3137. }
  3138. else if (toValueString == sFILTER_TIME_LATEST)
  3139. {
  3140. promptValues += '<selectUnboundedEndRange selected="true">';
  3141. promptValues += '<start displayValue="';
  3142. promptValues += sXmlEncode(fromValDisplay ? fromValDisplay : fromValueString);
  3143. promptValues += '" useValue="' + sXmlEncode(fromValueString) + '"/>';
  3144. promptValues += '</selectUnboundedEndRange>';
  3145. }
  3146. else if (fromValueString == toValueString)
  3147. {
  3148. promptValues += '<selectOption displayValue="';
  3149. promptValues += sXmlEncode(fromValDisplay ? fromValDisplay : fromValueString);
  3150. promptValues += '" useValue="' + sXmlEncode(fromValueString) + '" selected="true"/>';
  3151. }
  3152. else
  3153. {
  3154. promptValues += '<selectBoundRange selected="true">';
  3155. promptValues += '<start displayValue="';
  3156. promptValues += sXmlEncode(fromValDisplay ? fromValDisplay : fromValueString);
  3157. promptValues += '" useValue="' + sXmlEncode(fromValueString) + '"/>';
  3158. promptValues += '<end displayValue="';
  3159. promptValues += sXmlEncode(toValDisplay ? toValDisplay : toValueString);
  3160. promptValues += '" useValue="' + sXmlEncode(toValueString) + '"/>';
  3161. promptValues += '</selectBoundRange>';
  3162. }
  3163. promptValues += '</selectChoices>';
  3164. }
  3165. cf.updateOrAddPromptParm("p_" + promptID, promptValues);
  3166. }
  3167. else
  3168. {
  3169. if (fromValueString != sFILTER_TIME_EARLIEST)
  3170. {
  3171. fe.setFrom(fromValueString, (fromValDisplay ? fromValDisplay : fromValueString));
  3172. }
  3173. if (toValueString != sFILTER_TIME_LATEST)
  3174. {
  3175. fe.setTo(toValueString, (toValDisplay ? toValDisplay : toValueString));
  3176. }
  3177. }
  3178. return fe;
  3179. };
  3180. function filterTimeRange_execute()
  3181. {
  3182. if((document.f.fromValue[0].checked && !timePickertimeFrom.isValid())||(document.f.toValue[0].checked && !timePickertimeTo.isValid()))
  3183. {
  3184. return;
  3185. }
  3186. submitFilterExpression( filterTimeRange_buildFilterExpression() );
  3187. };
  3188. function filterTimeRange_init(oOptions)
  3189. {
  3190. attachMouseEvents();
  3191. var x = document.getElementById("colName");
  3192. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  3193. initNullOptions();
  3194. filterCommon_initBasedOnDatasourceBox();
  3195. if (cf.isDetailFilterEnabled())
  3196. {
  3197. document.getElementById("filterBasedOnInfoMessage").style.display = "block";
  3198. }
  3199. if (oOptions.bPrompt)
  3200. {
  3201. document.f.promptBox.checked = true;
  3202. }
  3203. if (cf && cf.showDialogFrame)
  3204. {
  3205. cf.showDialogFrame(oOptions.bUseAdv ? 530 : 460);
  3206. }
  3207. var oTimeFrom = document.getElementById('timeEditBoxtimeFrom');
  3208. if (oTimeFrom)
  3209. {
  3210. oTimeFrom.onclick = fromGotFocus;
  3211. oTimeFrom.onkeypress = fromGotFocus;
  3212. oTimeFrom.onpaste = fromGotFocus;
  3213. }
  3214. var oTimeTo = document.getElementById('timeEditBoxtimeTo');
  3215. if (oTimeTo)
  3216. {
  3217. oTimeTo.onclick = toGotFocus;
  3218. oTimeTo.onkeypress = toGotFocus;
  3219. oTimeTo.onpaste = toGotFocus;
  3220. }
  3221. if (timePickertimeFrom && timePickertimeFrom.m_oHours && !timePickertimeFrom.m_oHours.disabled)
  3222. {
  3223. timePickertimeFrom.m_oHours.focus();
  3224. }
  3225. };
  3226. function filterTree_buildFilterExpression()
  3227. {
  3228. var fe = new cf.CFilterExpression();
  3229. onlyPrompt = false;
  3230. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  3231. {
  3232. var no = getNullOption();
  3233. fe.setNullOption(no);
  3234. if (no == "only")
  3235. {
  3236. return fe;
  3237. }
  3238. }
  3239. var listSeparator = goDialogManager.getMiniQueryManager().getListSeparator();
  3240. var promptID = getPromptId();
  3241. if (document.f.promptBox.checked)
  3242. {
  3243. fe.setPrompt(promptID);
  3244. }
  3245. fe.setDataType('MUN');
  3246. var promptValues = '<selectChoices>';
  3247. var picklistValue = "";
  3248. var bFirst = true;
  3249. var a = treepList.getSelectionOrder();
  3250. for (i = 0; i < a.length; i++)
  3251. {
  3252. if (document.f.promptBox.checked)
  3253. {
  3254. promptValues += '<selectOption displayValue="' + sXmlEncode(a[i].getName()) +
  3255. '" useValue="' + sXmlEncode(a[i].getValue()) + '" selected="true"/>';
  3256. }
  3257. else
  3258. {
  3259. fe.addValue(a[i].getValue(), a[i].getName());
  3260. }
  3261. }
  3262. if (document.f.promptBox.checked)
  3263. {
  3264. promptValues += '</selectChoices>';
  3265. cf.updateOrAddPromptParm("p_" + promptID, promptValues);
  3266. }
  3267. return fe;
  3268. };
  3269. function filterTree_execute()
  3270. {
  3271. submitFilterExpression( filterTree_buildFilterExpression() );
  3272. };
  3273. function filterTree_init()
  3274. {
  3275. attachMouseEvents();
  3276. var x = document.getElementById("link1");
  3277. if (cf.dlgGlobalGetParm('xxIsSearchAllowed') != true)
  3278. {
  3279. x.style.display = "none";
  3280. }
  3281. var basedOnVal = filterCommon_initBasedOnDatasourceBox();
  3282. if (cf.isDetailFilterEnabled())
  3283. {
  3284. document.getElementById("filterBasedOnInfoMessage").style.display = "block";
  3285. }
  3286. if (cf.dlgGlobalGetParm('xxIsNullAllowed') == true)
  3287. {
  3288. x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, getNullOption(), " + basedOnVal + ",fd_getNOT())";
  3289. }
  3290. else
  3291. {
  3292. x.href = "javascript:getConfigFrame().invokeOtherFilterDlg('filterSearch', document.f.promptBox.checked, false, " + basedOnVal + ",fd_getNOT())";
  3293. }
  3294. x.appendChild(document.createTextNode(sFILTER_SEARCH_FOR_VALUES));
  3295. x = document.getElementById("colName");
  3296. x.appendChild(document.createTextNode(cf.dlgGlobalGetParm('xxColName')));
  3297. if (cf.dlgGlobalGetParm('xxPromptState') == true)
  3298. {
  3299. document.f.promptBox.checked = true;
  3300. }
  3301. else if (cf.dlgGlobalGetParm('xxPromptState') == false)
  3302. {
  3303. document.f.promptBox.checked = false;
  3304. }
  3305. else if (sXXPromptName != "")
  3306. {
  3307. document.f.promptBox.checked = true;
  3308. }
  3309. initNullOptions();
  3310. treepList.setSelectionMode(DISCONTIGUOUS_TREE_SELECTION);
  3311. treepList.setSelectTreeUI(CHECKBOX_TREE);
  3312. treepList.setAllowDragDrop(false);
  3313. treepList.setTrackSelectionOrder(true);
  3314. treepList.setNodesCanHaveChildren(true);
  3315. treepList.setRootNodeShowing(false);
  3316. treepList.setPromptingTree(false);
  3317. treepList.setLoadOnTheFlyFunction(loadFunc);
  3318. treepList.getRootNode().setCanHaveChildren(true);
  3319. if (cf && cf.showDialogFrame)
  3320. {
  3321. cf.showDialogFrame(advClosedSize);
  3322. }
  3323. treepList.setupOuterTable();
  3324. filterTree_sendRequestForList();
  3325. };
  3326. function loadFunc(loadingNode)
  3327. {
  3328. if (loadingNode.getName() == "root")
  3329. {
  3330. return;
  3331. }
  3332. else
  3333. {
  3334. cf.dlgGlobalSetParm('xxFullColExpression', loadingNode.getValue());
  3335. filterTree_sendRequestForList();
  3336. }
  3337. };
  3338. function filterTree_processResponse(response)
  3339. {
  3340. cf.dlgGlobalSetParm("xxActiveRequest", null);
  3341. if (!cf.checkResponse(response, document, "filterTreeList", filterTree_sendRequestForList))
  3342. {
  3343. return;
  3344. }
  3345. var bPrompting = false;
  3346. var sReportSpecification = "";
  3347. eval(response);
  3348. if (bPrompting && bPrompting === true)
  3349. {
  3350. sendPromptRequest(sReportSpecification);
  3351. return;
  3352. }
  3353. for (var j = 0; j < cf.dlgGlobalSize("xxPickList"); j++)
  3354. {
  3355. var mun = fd_getUseValue(cf.dlgGlobalGetParmAt("xxPickList", j));
  3356. var n = _treenodes[mun];
  3357. if (typeof n == "object" && typeof n.setSelected == "function")
  3358. {
  3359. n.setSelected(true);
  3360. }
  3361. }
  3362. for (var k = 1; k < cf.dlgGlobalSize("xxSelects"); k += 2)
  3363. {
  3364. var mun = cf.dlgGlobalGetParmAt("xxSelects", k);
  3365. var n = _treenodes[mun];
  3366. if (n instanceof CTreeNode)
  3367. {
  3368. n.setSelected(true);
  3369. }
  3370. }
  3371. if(bDrawAll == 'true')
  3372. {
  3373. treepList.removeLoading(treepList.getRootNode());
  3374. treepList.setLoading(false);
  3375. setTimeout("treepList.drawAll()", 100);
  3376. setTimeout("treepList.checkData()", 110);
  3377. treepList.getRootNode().m_bRendered = true;
  3378. }
  3379. else
  3380. {
  3381. if(typeof addToNode != "undefined")
  3382. {
  3383. treepList.childrenReadyForNode(_treenodes[addToNode]);
  3384. }
  3385. else
  3386. {
  3387. if(cf.dlgGlobalGetParm('xxFullColExpression') )
  3388. {
  3389. treepList.childrenReadyForNode(_treenodes[cf.dlgGlobalGetParm('xxFullColExpression')]);
  3390. }
  3391. }
  3392. }
  3393. };
  3394. function filterTree_sendRequestForList()
  3395. {
  3396. var activeRequest = cf.dlgGlobalGetParm('xxActiveRequest');
  3397. if (activeRequest != null)
  3398. {
  3399. cf.cancelDispatcherRequest(activeRequest);
  3400. }
  3401. var url = "m=/" + cf.qs_dir + "/filterTreeRequest.xts&b_action=xts.run";
  3402. if (cf.dlgGlobalGetParm('xxFullColExpression'))
  3403. {
  3404. url += "&xxFullColExpression=" + encodeURIComponent(cf.dlgGlobalGetParm('xxFullColExpression'));
  3405. }
  3406. if (cf.dlgGlobalGetParm('xxModelName'))
  3407. {
  3408. url += "&xxModelName=" + encodeURIComponent(cf.dlgGlobalGetParm('xxModelName'));
  3409. }
  3410. if (cf.dlgGlobalGetParm('xxColid'))
  3411. {
  3412. url += "&xxColid=" + encodeURIComponent(cf.dlgGlobalGetParm('xxColid'));
  3413. }
  3414. if (cf.dlgGlobalGetParm('xxRetrievePrompt'))
  3415. {
  3416. url += "&xxRetrievePrompt=" + encodeURIComponent(cf.dlgGlobalGetParm('xxRetrievePrompt'));
  3417. }
  3418. if (cf.dlgGlobalGetParm('xxSearchPath'))
  3419. {
  3420. url += "&xxSearchPath=" + encodeURIComponent(cf.dlgGlobalGetParm('xxSearchPath'));
  3421. }
  3422. if (cf.dlgGlobalGetParm('xxFilterItemRef'))
  3423. {
  3424. url += "&xxFilterItemRef=" + encodeURIComponent(cf.dlgGlobalGetParm('xxFilterItemRef'));
  3425. }
  3426. if (cf.dlgGlobalGetParm('xxFilterItemRefExp'))
  3427. {
  3428. url += "&xxFilterItemRefExp=" + encodeURIComponent(cf.dlgGlobalGetParm('xxFilterItemRefExp'));
  3429. }
  3430. if (cf.dlgGlobalGetParm('xxPromptParam'))
  3431. {
  3432. if (isPromptParamAndIdEncoded())
  3433. {
  3434. url += "&xxPromptParam=" + cf.dlgGlobalGetParm('xxPromptParam');
  3435. }
  3436. else
  3437. {
  3438. url += "&xxPromptParam=" + encodeURIComponent(cf.dlgGlobalGetParm('xxPromptParam'));
  3439. }
  3440. }
  3441. for (var i = 0; i < cf.dlgGlobalSize('xxOtherColIds'); i++)
  3442. {
  3443. url += "&xxOtherCols=" + cf.dlgGlobalConstructPairParm(url, encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColIds', i)), encodeURIComponent(cf.dlgGlobalGetParmAt('xxOtherColExps', i)));
  3444. }
  3445. for (var i = 0; i < cf.dlgGlobalSize('xxPromptCascade'); i++)
  3446. {
  3447. url += "&xxPromptCascade=" + encodeURIComponent(cf.dlgGlobalGetParmAt('xxPromptCascade', i));
  3448. }
  3449. for (var i = 0; i < cf.dlgGlobalSize('xxCreds'); i++)
  3450. {
  3451. url += "&xxCreds=" + encodeURIComponent(cf.dlgGlobalGetParmAt('xxCreds', i));
  3452. }
  3453. for (var i = 0; i < cf.dlgGlobalSize('xxPromptValues'); i++)
  3454. {
  3455. url += "&xxPromptValues=" + encodeURIComponent(cf.dlgGlobalGetParmAt('xxPromptValues', i));
  3456. }
  3457. if (cf.dlgGlobalGetParm('xxExprLocale'))
  3458. {
  3459. url += "&xxExprLocale=" + encodeURIComponent(cf.dlgGlobalGetParm('xxExprLocale'));
  3460. }
  3461. if (cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters() !== null)
  3462. {
  3463. url += "&xxExecutionParameters=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getExecutionParameters());
  3464. }
  3465. if (cf.goApplicationManager.getReportManager().getParameterManager().getMetadataParameters() !== null)
  3466. {
  3467. url += "&parameterValues=" + encodeURIComponent(cf.goApplicationManager.getReportManager().getParameterManager().getMetadataParameters());
  3468. }
  3469. else if (cf.cfgGet('parameterValues'))
  3470. {
  3471. url += "&parameterValues=" + encodeURIComponent(cf.cfgGet('parameterValues'));
  3472. }
  3473. if (typeof cf.routingServerGroup != "undefined")
  3474. {
  3475. url += "&ui.routingServerGroup=" + encodeURIComponent(cf.routingServerGroup);
  3476. }
  3477. if (cf.cafContextId != "")
  3478. {
  3479. url += "&ui.cafcontextid=" + cf.cafContextId;
  3480. }
  3481. url += "&depth=2&textBoxControl=treepList";
  3482. if (cf.cfgGet("markup_track") != "undefined")
  3483. {
  3484. url += "&markup_track=" + cf.cfgGet("markup_track");
  3485. }
  3486. cf.dlgGlobalSetParm("xxActiveRequest", cf.sendDispatcherRequest(url, processResponse));
  3487. };
  3488. function getColumnIdFromFCId (sFCId)
  3489. {
  3490. var oMQMgr = goDialogManager.getMiniQueryManager();
  3491. if(typeof cf.dialogGlobalValues["xxNewFilter"] != "undefined")
  3492. {
  3493. var oColumn = oMQMgr.getColumnById(sFCId);
  3494. if (oColumn !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
  3495. {
  3496. return sFCId;
  3497. }
  3498. else
  3499. {
  3500. var oCC= cf.getCombinedFilter();
  3501. if(oCC)
  3502. {
  3503. var filterNode=oCC.getFilterById(sFCId);
  3504. if(filterNode)
  3505. {
  3506. var cid=filterNode.getColumnId();
  3507. return cid;
  3508. }
  3509. }
  3510. }
  3511. return "";
  3512. }
  3513. var oColumn1 = oMQMgr.getColumnFromFilter(sFCId);
  3514. if (oColumn1 !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
  3515. {
  3516. return oColumn1.getAttribute("id");
  3517. }
  3518. var oColumn2 = oMQMgr.getColumnById(sFCId);
  3519. if (oColumn2 !== oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
  3520. {
  3521. return sFCId;
  3522. }
  3523. return "";
  3524. };
  3525. function getFilterDataType (sFCId)
  3526. {
  3527. var oMQMgr = goDialogManager.getMiniQueryManager();
  3528. var sColumnId = getColumnIdFromFCId(sFCId);
  3529. var sDataType = "";
  3530. if(sColumnId === "")
  3531. {
  3532. var sType = oMQMgr.getFilterDataType(sFCId);
  3533. if(sType != oMQMgr.MINI_QUERY_NO_COLUMN_FOUND)
  3534. {
  3535. return sType;
  3536. }
  3537. if (cf.dlgGlobalGetParm('xxFilterIsString'))
  3538. {
  3539. sDataType = "string";
  3540. }
  3541. else if (cf.dlgGlobalGetParm('xxUseMUN'))
  3542. {
  3543. sDataType = "MUN";
  3544. }
  3545. return sDataType;
  3546. }
  3547. var sPromptFilterItemRef = oMQMgr.getPromptFilterItemRef(sColumnId);
  3548. var sPromptUseItemRef = oMQMgr.getPromptUseItemRef(sColumnId);
  3549. var bPromptFilterRefIsString = oMQMgr.isPromptFilterItemRefString(sColumnId);
  3550. var bPromptUseItemRefIsString = oMQMgr.isPromptUseItemRefString(sColumnId);
  3551. var bColumnIsMUN = oMQMgr.isMUN(sColumnId);
  3552. var bIsString = cf.dlgGlobalGetParm('xxFilterIsString') && !bColumnIsMUN;
  3553. if (sPromptUseItemRef !== oMQMgr.MINI_QUERY_NONE_STR)
  3554. {
  3555. bIsString = bPromptUseItemRefIsString;
  3556. }
  3557. else if (sPromptFilterItemRef !== oMQMgr.MINI_QUERY_NONE_STR)
  3558. {
  3559. bIsString = bPromptFilterRefIsString;
  3560. }
  3561. var aFilters = oMQMgr.getFiltersForColumn(sColumnId);
  3562. for (var key in aFilters)
  3563. {
  3564. try
  3565. {
  3566. var oObject = aFilters[key];
  3567. var sExistingFilterDataType = oObject.getElementsByTagName("FilterExpression")[0].getElementsByTagName("FE")[0].getAttribute("dataType");
  3568. if (sExistingFilterDataType === "string")
  3569. {
  3570. bIsString = true;
  3571. break;
  3572. }
  3573. }
  3574. catch (e)
  3575. {
  3576. }
  3577. }
  3578. if (bIsString)
  3579. {
  3580. sDataType = "string";
  3581. }
  3582. else if (bColumnIsMUN == true && sPromptFilterItemRef === oMQMgr.MINI_QUERY_NONE_STR && sPromptUseItemRef === oMQMgr.MINI_QUERY_NONE_STR)
  3583. {
  3584. sDataType = "MUN";
  3585. }
  3586. return sDataType;
  3587. };
  3588. function executeOk(evt)
  3589. {
  3590. var oDialogManager = new CDialogManager();
  3591. if(oDialogManager.isSpaceOrEnterKeyEvent(evt))
  3592. {
  3593. execute();
  3594. }
  3595. };
  3596. function executeCancel(evt)
  3597. {
  3598. var oDialogManager = new CDialogManager();
  3599. if(oDialogManager.isSpaceOrEnterKeyEvent(evt))
  3600. {
  3601. typeof this.cancelDialog == 'function' ? this.cancelDialog() : getConfigFrame().hideDialogFrame();
  3602. }
  3603. };
  3604. function sendPromptRequest(sReportSpecification)
  3605. {
  3606. var cf = getConfigFrame();
  3607. sReportSpecification = sReportSpecification.replace(/^\s+|\s+$/,"");
  3608. var oReportManager = goDialogManager.getApplicationManager().getReportManager();
  3609. var oQSRequest = oReportManager.createRequest("runSpecification");
  3610. oQSRequest.setRequestType("post");
  3611. oQSRequest.addOption("m", "prompting/promptDataSource.xts");
  3612. oQSRequest.addOption("ccs_invoke", "parent");
  3613. oQSRequest.addOption("isEncoded", "1");
  3614. oQSRequest.addOption("specification", sReportSpecification);
  3615. oQSRequest.addOption("b_action", "xts.run");
  3616. oQSRequest.addOption("ui.action", "collectParameterValuesSpecification");
  3617. oQSRequest.addOption("releaseConversation", "1");
  3618. if (typeof cf.cafContextId === "string")
  3619. {
  3620. oQSRequest.addOption("ui.cafcontextid", cf.cafContextId);
  3621. }
  3622. if (typeof cf.routingServerGroup === "string")
  3623. {
  3624. oQSRequest.addOption("routingServerGroup", cf.routingServerGroup);
  3625. }
  3626. oQSRequest.addOption("tracking", oReportManager.getCVObj().getTracking());
  3627. cf.hideDialogFrame();
  3628. oReportManager.sendQSRequest(oQSRequest);
  3629. };