ATOUTFOX
COMMUNAUTÉ FRANCOPHONE DES PROFESSIONNELS FOXPRO
Visual FoxPro : le développement durable

Forum AtoutFox : Re: DPE   

Sujet

rss Flux RSS des derniers messages

Vous devez vous identifier pour pouvoir poser une question ou répondre.

lun. 31 décembre 2012, 00h09

P@trick
France France

atoutfox.public.association

Re: DPE

YO

le Report listener avec GDI+ il me semble que tu peux sauver l'image.

autrement un script cscript qui génére des % sur l'évolution des capacités disques à partir de CSS

[VFP]
Const HARD_DISK = 3
Dim htmlpage
Dim objExcel
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open(Replace(WScript.ScriptFullName,WScript.ScriptName,"") & "diskuse.xls")


htmlpage=""

htmlpage=htmlpage&"<!DOCTYPE html PUBLIC ""-//W3C//DTD XHTML 1.0 Strict//EN"" ""http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"">"&vbNewLine
htmlpage=htmlpage&"<html xmlns=""http://www.w3.org/1999/xhtml""; xml:lang=""fr"" lang=""fr"">"&vbNewLine
htmlpage=htmlpage&"<head>"&vbNewLine
htmlpage=htmlpage&"<meta http-equiv=""Content-Type"" content=""text/html; charset=windows-1252"" />"&vbNewLine
htmlpage=htmlpage&"<META HTTP-EQUIV=""refresh"" CONTENT=""3600"">"&vbNewLine
htmlpage=htmlpage&"<title>Supervision des dossiers partagés</title>"&vbNewline
htmlpage=htmlpage&"<style type=""text/css"" media=""screen"">"&vbNewline
htmlpage=htmlpage&"body { font: 12px ""Bitstream vera sans"", ""Trebuchet MS"", helvetica, sans-serif; }"&vbNewline


htmlpage=htmlpage&"span#part1 { width: 45%; float: left; }"&vbNewline
htmlpage=htmlpage&"span#part2 { width: 45%; float: right; }"&vbNewline

htmlpage=htmlpage&"span.stats ul { width: 320px; list-style: none; }"&vbNewline

htmlpage=htmlpage&"span.stats .percent {"&vbNewline
htmlpage=htmlpage&"display: block;"&vbNewline
htmlpage=htmlpage&"height: 1.5em;"&vbNewline
htmlpage=htmlpage&" line-height: 1.5em;"&vbNewline
htmlpage=htmlpage&"/* margin: 5px 10px; */"&vbNewline
htmlpage=htmlpage&"/* padding: 0 5px; */"&vbNewline
htmlpage=htmlpage&"text-align: right;"&vbNewline
htmlpage=htmlpage&"color: #fff;"&vbNewline
htmlpage=htmlpage&"font-weight: bold;"&vbNewline
htmlpage=htmlpage&"font-family: monospace;"&vbNewline
htmlpage=htmlpage&"-moz-border-radius: 5px;"&vbNewline
htmlpage=htmlpage&"/* border-bottom: 1px solid #aaa; */"&vbNewline
htmlpage=htmlpage&"/* border-right: 1px solid #aaa; */"&vbNewline
htmlpage=htmlpage&"cursor: default; }"&vbNewline

htmlpage=htmlpage&".v100 { width: 100%; }"&vbNewline
htmlpage=htmlpage&".v99 { width: 99%; }"&vbNewline
htmlpage=htmlpage&".v98 { width: 98%; }"&vbNewline
htmlpage=htmlpage&".v97 { width: 97%; }"&vbNewline
htmlpage=htmlpage&".v96 { width: 96%; }"&vbNewline
htmlpage=htmlpage&".v95 { width: 95%; }"&vbNewline
htmlpage=htmlpage&".v94 { width: 94%; }"&vbNewline
htmlpage=htmlpage&".v93 { width: 93%; }"&vbNewline
htmlpage=htmlpage&".v92 { width: 92%; }"&vbNewline
htmlpage=htmlpage&".v91 { width: 91%; }"&vbNewline
htmlpage=htmlpage&".v90 { width: 90%; }"&vbNewline
htmlpage=htmlpage&".v89 { width: 89%; }"&vbNewline
htmlpage=htmlpage&".v88 { width: 88%; }"&vbNewline
htmlpage=htmlpage&".v87 { width: 87%; }"&vbNewline
htmlpage=htmlpage&".v86 { width: 86%; }"&vbNewline
htmlpage=htmlpage&".v85 { width: 85%; }"&vbNewline
htmlpage=htmlpage&".v84 { width: 84%; }"&vbNewline
htmlpage=htmlpage&".v83 { width: 83%; }"&vbNewline
htmlpage=htmlpage&".v82 { width: 82%; }"&vbNewline
htmlpage=htmlpage&".v81 { width: 81%; }"&vbNewline
htmlpage=htmlpage&".v80 { width: 80%; }"&vbNewline
htmlpage=htmlpage&".v79 { width: 79%; }"&vbNewline
htmlpage=htmlpage&".v78 { width: 78%; }"&vbNewline
htmlpage=htmlpage&".v77 { width: 77%; }"&vbNewline
htmlpage=htmlpage&".v76 { width: 76%; }"&vbNewline
htmlpage=htmlpage&".v75 { width: 75%; }"&vbNewline
htmlpage=htmlpage&".v74 { width: 74%; }"&vbNewline
htmlpage=htmlpage&".v73 { width: 73%; }"&vbNewline
htmlpage=htmlpage&".v72 { width: 72%; }"&vbNewline
htmlpage=htmlpage&".v71 { width: 71%; }"&vbNewline
htmlpage=htmlpage&".v70 { width: 70%; }"&vbNewline
htmlpage=htmlpage&".v69 { width: 69%; }"&vbNewline
htmlpage=htmlpage&".v68 { width: 68%; }"&vbNewline
htmlpage=htmlpage&".v67 { width: 67%; }"&vbNewline
htmlpage=htmlpage&".v66 { width: 66%; }"&vbNewline
htmlpage=htmlpage&".v65 { width: 65%; }"&vbNewline
htmlpage=htmlpage&".v64 { width: 64%; }"&vbNewline
htmlpage=htmlpage&".v63 { width: 63%; }"&vbNewline
htmlpage=htmlpage&".v62 { width: 62%; }"&vbNewline
htmlpage=htmlpage&".v61 { width: 61%; }"&vbNewline
htmlpage=htmlpage&".v60 { width: 60%; }"&vbNewline
htmlpage=htmlpage&".v59 { width: 59%; }"&vbNewline
htmlpage=htmlpage&".v58 { width: 58%; }"&vbNewline
htmlpage=htmlpage&".v57 { width: 57%; }"&vbNewline
htmlpage=htmlpage&".v56 { width: 56%; }"&vbNewline
htmlpage=htmlpage&".v55 { width: 55%; }"&vbNewline
htmlpage=htmlpage&".v54 { width: 54%; }"&vbNewline
htmlpage=htmlpage&".v53 { width: 53%; }"&vbNewline
htmlpage=htmlpage&".v52 { width: 52%; }"&vbNewline
htmlpage=htmlpage&".v51 { width: 51%; }"&vbNewline
htmlpage=htmlpage&".v50 { width: 50%; }"&vbNewline
htmlpage=htmlpage&".v49 { width: 49%; }"&vbNewline
htmlpage=htmlpage&".v48 { width: 48%; }"&vbNewline
htmlpage=htmlpage&".v47 { width: 47%; }"&vbNewline
htmlpage=htmlpage&".v46 { width: 46%; }"&vbNewline
htmlpage=htmlpage&".v45 { width: 45%; }"&vbNewline
htmlpage=htmlpage&".v44 { width: 44%; }"&vbNewline
htmlpage=htmlpage&".v43 { width: 43%; }"&vbNewline
htmlpage=htmlpage&".v42 { width: 42%; }"&vbNewline
htmlpage=htmlpage&".v41 { width: 41%; }"&vbNewline
htmlpage=htmlpage&".v40 { width: 40%; }"&vbNewline
htmlpage=htmlpage&".v39 { width: 39%; }"&vbNewline
htmlpage=htmlpage&".v38 { width: 38%; }"&vbNewline
htmlpage=htmlpage&".v37 { width: 37%; }"&vbNewline
htmlpage=htmlpage&".v36 { width: 36%; }"&vbNewline
htmlpage=htmlpage&".v35 { width: 35%; }"&vbNewline
htmlpage=htmlpage&".v34 { width: 34%; }"&vbNewline
htmlpage=htmlpage&".v33 { width: 33%; }"&vbNewline
htmlpage=htmlpage&".v32 { width: 32%; }"&vbNewline
htmlpage=htmlpage&".v31 { width: 31%; }"&vbNewline
htmlpage=htmlpage&".v30 { width: 30%; }"&vbNewline
htmlpage=htmlpage&".v29 { width: 29%; }"&vbNewline
htmlpage=htmlpage&".v28 { width: 28%; }"&vbNewline
htmlpage=htmlpage&".v27 { width: 27%; }"&vbNewline
htmlpage=htmlpage&".v26 { width: 26%; }"&vbNewline
htmlpage=htmlpage&".v25 { width: 25%; }"&vbNewline
htmlpage=htmlpage&".v24 { width: 24%; }"&vbNewline
htmlpage=htmlpage&".v23 { width: 23%; }"&vbNewline
htmlpage=htmlpage&".v22 { width: 22%; }"&vbNewline
htmlpage=htmlpage&".v21 { width: 21%; }"&vbNewline
htmlpage=htmlpage&".v20 { width: 20%; }"&vbNewline
htmlpage=htmlpage&".v19 { width: 19%; }"&vbNewline
htmlpage=htmlpage&".v18 { width: 18%; }"&vbNewline
htmlpage=htmlpage&".v17 { width: 17%; }"&vbNewline
htmlpage=htmlpage&".v16 { width: 16%; }"&vbNewline
htmlpage=htmlpage&".v15 { width: 15%; }"&vbNewline
htmlpage=htmlpage&".v14 { width: 14%; }"&vbNewline
htmlpage=htmlpage&".v13 { width: 13%; }"&vbNewline
htmlpage=htmlpage&".v12 { width: 12%; }"&vbNewline
htmlpage=htmlpage&".v11 { width: 11%; }"&vbNewline
htmlpage=htmlpage&".v10 { width: 10%; }"&vbNewline
htmlpage=htmlpage&".v9 { width: 9%; }"&vbNewline
htmlpage=htmlpage&".v8 { width: 8%; }"&vbNewline
htmlpage=htmlpage&".v7 { width: 7%; }"&vbNewline
htmlpage=htmlpage&".v6 { width: 6%; }"&vbNewline
htmlpage=htmlpage&".v5 { width: 5%; }"&vbNewline
htmlpage=htmlpage&".v4 { width: 4%; }"&vbNewline
htmlpage=htmlpage&".v3 { width: 3%; }"&vbNewline
htmlpage=htmlpage&".v2 { width: 2%; }"&vbNewline
htmlpage=htmlpage&".v1 { width: 1%; }"&vbNewline

htmlpage=htmlpage&"/* Image dégradée */"&vbNewline
htmlpage=htmlpage&".gradiant_pic li { width: 300px; padding: 0; }"&vbNewline
htmlpage=htmlpage&".gradiant_pic li .percent {"&vbNewline
htmlpage=htmlpage&" height: 18px;"&vbNewline
htmlpage=htmlpage&" line-height: 18px;"&vbNewline
htmlpage=htmlpage&" padding: 0;"&vbNewline
htmlpage=htmlpage&" color: #000;"&vbNewline
htmlpage=htmlpage&" background: #fff url(http://SERVEUR/sites/IT-France/_layouts/tests/Images/gradiantsmall.png) repeat-y 0 0;"&vbNewline
htmlpage=htmlpage&" -moz-border-radius: 0;"&vbNewline
htmlpage=htmlpage&"}"&vbNewline
htmlpage=htmlpage&"</style>"&vbNewline

htmlpage=htmlpage&"<script type=""text/javascript"">"&vbNewline
htmlpage=htmlpage&"// script pour ajouter un attribut title au <span> de façon automatisée"&vbNewline
htmlpage=htmlpage&"function titlePercentage() {"&vbNewline
htmlpage=htmlpage&" // pour chaque élément de class ""percent"""&vbNewline
htmlpage=htmlpage&" $("".percent"").each(function() {"&vbNewline
htmlpage=htmlpage&" // on définit son attribut ""title"" à partir du texte de l'element"&vbNewline
htmlpage=htmlpage&" $(this).attr(""title"",$(this).html());"&vbNewline
htmlpage=htmlpage&" });"&vbNewline
htmlpage=htmlpage&"}"&vbNewline

htmlpage=htmlpage&"$(document).ready(function() {"&vbNewline
htmlpage=htmlpage&" titlePercentage();"&vbNewline
htmlpage=htmlpage&"});"&vbNewline
htmlpage=htmlpage&"</script>"&vbNewline
htmlpage=htmlpage&"</head>"&vbNewline
htmlpage=htmlpage&"<body>"&vbNewline


''' recheche S de Puteaux

Set objWorksheet = objWorkbook.Worksheets(4)
X=1
Do while UCase(objWorksheet.cells(X,1))<>"PUTEAUX"
X=X+1
Loop
Y=1
Do while UCase(objWorksheet.cells(1,Y))<>"S"
Y=Y+1
Loop
allserver=UCase(objWorksheet.cells(X,Y))
genhtml allserver," S de Puteaux "
completeXLS allserver,2,"S"


''' recherche U de Puteaux
Set objWorksheet = objWorkbook.Worksheets(4)
X=1
Do while UCase(objWorksheet.cells(X,1))<>"PUTEAUX"
X=X+1
Loop
Y=1
Do while UCase(objWorksheet.cells(1,Y))<>"U"
Y=Y+1
Loop
allserver=UCase(objWorksheet.cells(X,Y))
genhtml allserver," U de Puteaux "
completeXLS allserver,2,"U"


''' recherche N de Puteaux
Set objWorksheet = objWorkbook.Worksheets(4)
X=1
Do while UCase(objWorksheet.cells(X,1))<>"PUTEAUX"
X=X+1
Loop
Y=1
Do while UCase(objWorksheet.cells(1,Y))<>"N"
Y=Y+1
Loop
allserver=UCase(objWorksheet.cells(X,Y))
genhtml allserver," N de Puteaux "
completeXLS allserver,2,"N"

''' U de Marseille
Set objWorksheet = objWorkbook.Worksheets(4)
X=1
Do while UCase(objWorksheet.cells(X,1))<>"MARSEILLE"
X=X+1
Loop
Y=1
Do while UCase(objWorksheet.cells(1,Y))<>"U"
Y=Y+1
Loop
allserver=UCase(objWorksheet.cells(X,Y))
genhtml allserver," R & U de Marseille " 'espace insécable
completeXLS allserver,1,"U"

''' R de Marseille
Set objWorksheet = objWorkbook.Worksheets(4)
X=1
Do while UCase(objWorksheet.cells(X,1))<>"MARSEILLE"
X=X+1
Loop
Y=1
Do while UCase(objWorksheet.cells(1,Y))<>"R"
Y=Y+1
Loop
allserver=UCase(objWorksheet.cells(X,Y))

'''genhtml allserver," R & U de Marseille " 'espace insécable
completeXLS allserver,1,"R"

'''allserver="XXXXXXXXXXX"
'''genhtml allserver," U de Marseille "


htmlpage=htmlpage&"</body>"&vbNewline
htmlpage=htmlpage&"</html>"&vbNewline

xxx=strtofile(htmlpage,"etatdisques.aspx",True)
xxx=strtofile(htmlpage,"etatdisques.html",True)

objWorkbook.Save
objWorkbook.Close
objExcel.Quit



Function strtofile(lstr2file,lFileName,loverwrite)
DBG(lstr2file)
DBG(lfilename)
DBG(loverwrite)
Dim lfso, lMyFile
Set lfso = CreateObject("Scripting.FileSystemObject")
If Not lfso.FileExists(lFileName) or loverwrite Then
Set lMyFile = lfso.CreateTextFile(lFileName, loverwrite)
lMyFile.WriteLine(lstr2file)
lMyFile.Close
End if
strtofile=True
End Function
Function dtmdate( byref DateObject)
On Error Resume Next
Set objDate = DateObject
If (Err.Number <> 0) Then
On Error GoTo 0
dtmdate = #1/1/1601#
Else
On Error GoTo 0
lngHigh = objDate.HighPart
lngLow = objDate.LowPart
If (lngLow < 0) Then
lngHigh = lngHigh + 1
End If
If (lngHigh = 0) And (lngLow = 0) Then
dtmDate = #1/1/1601#
Else
dtmDate = #1/1/1601# + (((lngHigh * (2 ^ 32)) + lngLow)/600000000)/1440
End If
End If
End Function
Function DBG(lPhrase)
If BUG Then WScript.Echo mydate()& " --> " & lPhrase
End Function

Function echo(lPhrase)
WScript.Echo lPhrase
End Function

Function mydate

mois= ""&Month(Date())
If Len(mois)=1 Then
mois="0"&mois
End If
jour= ""&day(Date())
If Len(jour)=1 Then
jour="0"&jour
End If
tocante= "" & Hour(time())
If Len(tocante)=1 Then
tocante= "0" & tocante
End If
minutes=""&Minute(Time())
If Len(minutes)=1 Then
minutes="0"&minutes
End If
Seconde=""&Second(Time())
If Len(Seconde)=1 Then
Seconde="0"&Seconde
End If
mydate=""&Year(Date())&"_"&mois&"_"&jour&"_"&tocante&Minutes&Seconde

End Function

Sub genhtml(serveur,titre)

htmlpage=htmlpage&"<span id=""part1"">"&vbNewline
htmlpage=htmlpage&"<span class=""stats gradiant_pic"">"&vbNewline
htmlpage=htmlpage&"<H2>"&titre&"</H2>"&vbNewline
htmlpage=htmlpage&" <ul>"&vbNewline
oldstrcomputer=""
arrserver=Split(allserver,";")
For i=0 To UBound(arrserver)
strComputer = arrserver(i)
Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")

Set colDisks = objWMIService.ExecQuery _
("Select * from Win32_LogicalDisk Where DriveType = " & HARD_DISK & "")
j=1
For Each objDisk in colDisks
Libelle="Serveur : "
Libelle1="<BR> % d'occupation partition système : "
If oldstrcomputer=strcomputer Then
strcomputer=""
Libelle=""
Libelle1="% d'occupation partition données : "
End If
If j>=3 Then Libelle1 =""
htmlpage=htmlpage&"<li><DIV>"& "<B><FONT SIZE=4>" & Libelle & strcomputer & "</FONT></B>" & libelle1&"</DIV><span class="&Chr(34)&"percent v" & 100-Round(objDisk.FreeSpace/objDisk.size*100,0) & Chr(34) &">"& objDisk.DeviceID & 100 - round(objDisk.FreeSpace/objDisk.size*100,0) &"% "&round(objDisk.size/1073741824,0)-round(objDisk.FreeSpace/1073741824,0)&"/"&round(objDisk.size/1073741824,0)&"Go </span></li>"&vbNewline
'''Wscript.Echo "DeviceID: "& vbTab & objDisk.DeviceID
'''Wscript.Echo "Free Disk Space: "& vbTab & round(objDisk.FreeSpace/objDisk.size*100,0) &"%"
oldstrcomputer=strcomputer
j=j+1
Next
Next
htmlpage=htmlpage&"</ul>"
htmlpage=htmlpage&"</span>"
End Sub


Sub completeXLS(serveur,page,partage)
On Error Goto 0
Set objWorksheet = objWorkbook.Worksheets(page)
'' Mise à jour de l'année
decalage=Month(Now)*3+1
objWorksheet.cells(4,decalage).value=Year(Now)
'' Mise à jour du mois
objWorksheet.cells(5,decalage).value=MonthName(Month(Now))

arrserver=Split(serveur,";")

For i=0 To UBound(arrserver)
strComputer = arrserver(i)
Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")

Set colDisks = objWMIService.ExecQuery ("Select * from Win32_LogicalDisk Where DriveType = " & HARD_DISK & "")
j=1
X=7
Y=1
''' Do while UCase(objWorksheet.cells(X,1))<>""
''' X=X+1
''' Loop
For Each objDisk in colDisks
maj=True
objWorksheet.cells(X,Y+2).value=objDisk.DeviceID
Do While maj
If UCase(objWorksheet.cells(X,1))=UCase(strComputer) And UCase(objWorksheet.cells(X,2))=UCase(Partage)And UCase(objWorksheet.cells(X,3))= UCase(objDisk.DeviceID) Or UCase(objWorksheet.cells(X,1))="" Then
objWorksheet.cells(X,Y).value=strComputer
objWorksheet.cells(X,Y+1).value=Partage
objWorksheet.cells(X,Y+2).value=objDisk.DeviceID
objWorksheet.cells(X,decalage).value=round(objDisk.size/1073741824,0)-round(objDisk.FreeSpace/1073741824,0)
objWorksheet.cells(X,decalage+1).value=round(objDisk.size/1073741824,0)
objWorksheet.cells(X,decalage+2).value=100-Round((objDisk.size-objDisk.FreeSpace)/objDisk.size*100,0) &"%"
maj=False
End If
x=x+1
loop
Next
Next

End Sub

Sub Synthese
On Error Goto 0
Set objWorksheet = objWorkbook.Worksheets(4)
'' Mise à jour de l'année
decalage=Month(Now)*3+1
decalagesynthese=Month(Now)*3-2
objWorksheet.cells(4,decalagesynthese).value=Year(Now)
'' Mise à jour du mois
objWorksheet.cells(5,decalagesynthese).value=MonthName(Month(Now))

''' Calcul Marseille
Set objWorksheet = objWorkbook.Worksheets(1)
Do while UCase(objWorksheet.cells(X,1))<>""
X=X+1
Loop

For i=0 To UBound(arrserver)
strComputer = arrserver(i)
Set objWMIService = GetObject("winmgmts:" & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2")

Set colDisks = objWMIService.ExecQuery ("Select * from Win32_LogicalDisk Where DriveType = " & HARD_DISK & "")
j=1
Do while UCase(objWorksheet.cells(X,1))<>""
X=X+1
Loop

For Each objDisk in colDisks
Permalink : http://www.atoutfox.org/nntp.asp?ID=0000010501
20 286 messages dans le forum • Liste complète des messages

www.atoutfox.org - Site de la Communauté Francophone des Professionnels FoxPro - v3.4.0 - © 2004-2026.
Cette page est générée par un composant COM+ développé en Visual FoxPro 9.0-SP2-HF3