@@ -281,27 +398,72 @@
; Request Parameters
Kill:($G(%request.Data("QUERY",1))="") %request.Data("QUERY")
Set name=""
- For Set name=$O(%request.Data(name)) Quit:(name="") Merge tmpRq(name)=%request.Data(name,1)
+ For Set name=$O(%request.Data(name)) Quit:(name="") Merge tmpRq(name)=%request.Data(name)
- Set blnSQED=$G(%request.Data("SQED",1),0)
+ ;d WLIP^vhDBG(97,"request : ")
+ ;d WLIP^vhDBG(97,$$$ArrayTT("Data",%request,"Data"))
+
+ Set blnSQED=$G(%request.Data("SQED",1),1)
+ Merge arFilterGroepen=%request.Data("chkFilterGroep")
+ Merge arFilterNiveaus=%request.Data("chkFilterNiveau")
+
+ Set ToonAlleNiveaus=($G(%request.Data("chkToonAlleNiveaus",1))=1)
+
+ If ToonAlleNiveaus {
+ Kill arFilterNiveaus
+ }
+ ElseIf '$D(arFilterNiveaus) {
+ Set arFilterNiveaus(1)=##class(vhLib.enu.LogNiveau).Error()
+ Set arFilterNiveaus(2)=##class(vhLib.enu.LogNiveau).Warning()
+ }
+ Set LogViewerHelper=##class(vhLib.LogViewer).%New()
+
Set sqlAll=""
set MaxRows = $get(%request.Data("MAXROWS",1),1000)
Set AantalDagen = 15
+
+ Set WhereClause="" ; "Datum > '"_$zd($Horolog-AantalDagen,1)_"'"
+ Set FilterNiveauIt=##class(TECH.ArrayOneDimIterator).%New(.arFilterNiveaus)
+ If FilterNiveauIt.HasNext() {
+ Set WhereClause=WhereClause_$S(WhereClause="":"", 1:" AND ")_"("_LogViewerHelper.GeefWhereClauseVoorNiveaus(FilterNiveauIt)_")"
+ }
+
+ Set FilterGroepenIt=##class(TECH.ArrayOneDimIterator).%New(.arFilterGroepen)
+ If FilterGroepenIt.HasNext() {
+ Set WhereClause=WhereClause_$S(WhereClause="":"", 1:" AND ")_"("_LogViewerHelper.GeefWhereClauseVoorGroepen(FilterGroepenIt)_")"
+ }
+
+ ;d WLIP^vhDBG(97,"WhereClause : "_WhereClause)
+
+
+
/*** SQL STATEMENTS ***/
/*** ============== ***/
Set sqlLOGAllFields="SELECT Datum, Tijd, Groep, Niveau, Actie, JobID, DetailTrunc As Detail, ID , LessDetail, MainIndex , Namespace , RemoteIP , Server , ProgLabel , SubID "
Set sqlLOG ="SELECT Datum, Tijd, Groep, Niveau, Actie, JobID, DetailTrunc As Detail"
- Set sqlLOG=sqlLOG_$C(13,10)_" FROM vhLib.Logging WHERE Datum > '"_$zd($Horolog-AantalDagen,1)_"' AND (Niveau = 'E' OR Niveau='W')"
+ Set sqlLOG=sqlLOG_$C(13,10)_" FROM vhLib.Logging WHERE "_WhereClause
Set sqlLOG=sqlLOG_$C(13,10)_" ORDER BY Datum DESC, Tijd DESC, SubID DESC"
; SQLs to be displayed
Set sqlDFL=$S(1:sqlLOG)
Set sqlActive=$G(%request.Data("QUERY",1),sqlDFL)
; URL for ToggleQueryEditor
Merge tmpAr=tmpRq
+ Kill tmpAr("chkFilterGroep")
+ Kill tmpAr("chkFilterNiveau")
+ Kill tmpAr("chkToonAlleNiveaus")
+
+ Merge tmpAr("chkFilterGroep")=%request.Data("chkFilterGroep")
+ If ToonAlleNiveaus {
+ Set tmpAr("chkToonAlleNiveaus")=1
+ }
+ Else {
+ Merge tmpAr("chkFilterNiveau")=%request.Data("chkFilterNiveau")
+ }
+
Kill tmpAr("SQED")
Set tmpAr("SQED")=('blnSQED)
Set arUrl("ToggleQED")="?"_##class(vhLib.cspBasis).CQueryString(.tmpAr)