Index: vhLibLogging.csp =================================================================== diff -u -r42 -r50 --- vhLibLogging.csp (.../vhLibLogging.csp) (revision 42) +++ vhLibLogging.csp (.../vhLibLogging.csp) (revision 50) @@ -64,6 +64,68 @@ + + + @@ -154,27 +217,81 @@ -

 

-

- -
- +     +

Aantal rijen :
-
-   - +
Show Query Editor +
+
+
+
+ + + +
#(HTMLSeparator)#
+
+
 
+
+
+
+    OF    + + + + #(HTMLSeparator)# + +
+
+
+
Aantal rijen : +
+ + +
+ +
+ + - - +


@@ -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)