Generate_Job_Summary.ps1

##/***************************************
## Copyright (c) All rights reserved
##
## File: Library_WHQL_ENV_Parsing.ps1
##
## Authors (s)
##
##   Mike Cao <bcao@redhat.com>
##
## This file is used to run netkvm related test cases automately
##
## This work is licensed under the terms of the GNU GPL,Version 2.
##
##****************************************/

function local:GetScriptDirectory
{
    $Invocation = (Get-Variable MyInvocation -Scope 1).Value
    Split-Path $Invocation.MyCommand.Path
}
	. (Join-Path (GetScriptDirectory) "Library_HCK_MachinePoolAPI.ps1" )
	. (Join-Path (GetScriptDirectory) "Library_WHQL_ENV_Parsing.ps1" )
	
	$ObjectModel1 = LoadObjectModel "microsoft.windows.Kits.Hardware.objectmodel.dll"
	$ObjectModel2 = LoadObjectModel "microsoft.windows.Kits.Hardware.objectmodel.dbconnection.dll"
	$Submission   = LoadObjectModel "microsoft.windows.Kits.Hardware.objectmodel.submission.dll"

	


function GenerateHCKPackages($Project,$saveFileName)
{
	write-host "file save path is " $saveFileName
	$packageWriter = new-object  -typename Microsoft.Windows.Kits.Hardware.ObjectModel.Submission.PackageWriter -Args $project
	$packageWriter.Save($saveFileName+".hckx")
    $packageWriter.Dispose()


}


function GenerateExcel($ResultsTable)
{  
    $excel = New-Object -ComObject Excel.Application
    $workbook = $excel.Workbooks.add()
    $workbook.workSheets.item(3).delete()
    $workbook.workSheets.item(2).delete()
    $workbook.WorkSheets.item(1).Name = "WHQL Result"
    $sheet = $workbook.WorkSheets.Item("WHQL Result")

    for ($m=0 ;$m -le $Line;$m++)
    {                      
       for ($n=0 ;$n -le ($col-1) ;$n++)
       {
            $sheet.cells.item($m+1,$n+1)=$ResultsTable[$m,$n]     
            switch ($ResultsTable[$m,$n])
            {
              Passed {$sheet.cells.item($m+1,$n+1).Interior.ColorIndex=4}
              Failed {$sheet.cells.item($m+1,$n+1).Interior.ColorIndex=3;$sheet.cells.item($m+1,$n+1)="Failed()"}
              N/A {$sheet.cells.item($m+1,$n+1).Interior.ColorIndex=16}
              NotRun {$sheet.cells.item($m+1,$n+1).Interior.ColorIndex=9}
              default {$sheet.cells.item($m+1,$n+1).Interior.ColorIndex=24}
            }
       }
    }  
    #$sheet.cells.item(1,1)="Detailed Testing Result"
    $sheet.cells.item($Line+1,1)="Note"
    $sheet.cells.item(2,1)="please write package info here"
    $sheet.cells.item($Line-1,1)="Total jobs"
    $sheet.cells.item($Line-1,2)=""
    $sheet.cells.item($Line-1,3)=""
    $sheet.cells.item($Line,2)=""
    $sheet.cells.item($Line,3)=""
    $sheet.Range($sheet.cells.item($Line-1,1),$sheet.cells.item($Line-1,3)).Merge()
    $sheet.cells.item($Line,1)="Passed jobs"
    $sheet.Range($sheet.cells.item($Line,1),$sheet.cells.item($Line,3)).Merge()
    $sheet.cells.item(1,1).font.bold = $true

    $sheet.Range($sheet.cells.item(1,1),$sheet.cells.item(1,$col)).Merge()
    $sheet.Range($sheet.cells.item($Line+1,1),$sheet.cells.item($Line+1,$col)).Merge()
    $sheet.Range($sheet.cells.item(2,1),$sheet.cells.item(($Line-2),1)).Merge()

    for ($o=2;$o -lt $col+1;$o ++)
    {
      $sheet.cells.item(2,$o).font.bold = $true
    }
    $range = $sheet.usedRange
    $range.EntireColumn.AutoFit() | out-null
    $range.Borders.LineStyle = 1 
    $workbook.SaveAs($SavePath+$GroupName+".xlsx")
    $excel.quit()
 }

function GenerateJobSummary
{	 
    
    GetXMLValues
	GetKitValues

	#$RootPool = $Manager.GetRootMachinePool();
    $JobHashTable=new-Object System.Collections.hashtable


    # list all projects, and get the basic status of each
    $projectcount = 0
    $Manager.GetProjectInfoList() | foreach {
        if($_.Name.Contains($GroupName)){
            write-host "Name   : " $_.Name
            write-host "`tStatus : " $_.Status
            write-host "`tNotRun : " $_.NotRunCount.ToString()
            write-host "`tPassed : " $_.PassedCount
            write-host "`tFailed : " $_.FailedCount
            write-host "`tRunning: " $_.RunningCount
			$Project = $Manager.GetProject($_.Name)
            write-host "`Project Status: " $Project.Info.Status
			$saveFileName = $SavePath + $GroupName
            GenerateHCKPackages $Project $saveFileName
			
            $Project.GetTests()|foreach {
                $JobHashTable.Add($_.Id,$_.Name)               
			}  #end of guest tests foreach
            
        } #end of if
    } #end of manager foreach
    
    Write-Host "totally job count" $JobHashTable.Count
    [int]$Line = $JobHashTable.Count+2+2
    [int]$col=0
    
    
    #get the column num of ResultsTable
    $Manager.GetProjectNames() | foreach {
        $Project = $Manager.GetProject($_)
        if ($Project.Name.Contains($GroupName)) {
            $Project.GetProductInstances() | foreach {
                $col++
                }
             }
          }
    $col=$col+3
    write-host "col= " $col
    
    $ResultsTable = New-Object "String[,]" $Line,$col
    [int]$tmp_line = 2
    [int]$tmp_column = 3
    
    for([int]$i = 1; $i -lt $Line; $i++){
        for([int]$j=1;$j -lt $col;$j++){
            $ResultsTable[$i,$j] = "N/A"         
        } #end of $j
    } #end of for $i


  
    foreach($item in $JobHashTable.Keys)
    {
        #"item-key is"+$item
        #"value is"+$JobHashTable[$item]
        $ResultsTable[$tmp_line,1]=$item
        $ResultsTable[$tmp_line,2]=$JobHashTable[$item]
        $tmp_line++    
    }#end of foreach
    
    $ResultsTable[1,1]="Job ID"
    $ResultsTable[1,2]="Job Name"
    
  
    $Manager.GetProjectNames() | foreach {
        $Project = $Manager.GetProject($_)
        if ($Project.Name.Contains($GroupName)) {
            $Projectname=$Project.Name
            write-host $Projectname
            $Project.GetProductInstances() | foreach {
                write-host "Product Instance : " $_.Name 
                write-host "`Machine pool s: " $_.MachinePool.Name 
                write-host "`OS Platform : " $_.OSPlatform.Description
                Write-Host "tmp_host" $tmp_column
                
                $Manager.GetProjectInfoList() | foreach {                
                if($_.Name -eq $Projectname) {
                  $ResultsTable[($Line-2),$tmp_column] = $_.TotalCount
                  $ResultsTable[($Line-1),$tmp_column] = $_.PassedCount
                }
                }
                
                #$ResultsTable[1,$tmp_column]=$_.OSPlatform.Description.ToString 
                 switch($_.OSPlatform.Description.ToString())
                {
                  "Windows Server 2012" {$ResultsTable[1,$tmp_column]="Win2012"}
                  "Windows Server 2008 Release 2 x64" {$ResultsTable[1,$tmp_column]="Win2k8R2"}
                  "Windows 7 Client x86" {$ResultsTable[1,$tmp_column]="Win7_32"}
                  "Windows 7 Client x64" {$ResultsTable[1,$tmp_column]="Win7_64"}
                  "Windows 8 x86" {$ResultsTable[1,$tmp_column]="Win8_32"}
                  "Windows 8 x64" {$ResultsTable[1,$tmp_column]="Win8_64"}
                  "Windows Server 2008 x86" {$ResultsTable[1,$tmp_column]="W2k8_32"}
                  "Windows Server 2008 x64" {$ResultsTable[1,$tmp_column]="W2k8_64"}
                  "Windows XP x86" {$ResultsTable[1,$tmp_column]="WinXP"}
                  "Windows Server 2003 x86" {$ResultsTable[1,$tmp_column]="W2k3_32"}
                  "Windows Server 2003 x64" {$ResultsTable[1,$tmp_column]="W2k3_64"}
                  "Windows Server v6.3" {$ResultsTable[1,$tmp_column]="Win2012R2"}
                  "Windows Server v6.3 x86" {$ResultsTable[1,$tmp_column]="Win8.1_32"}
                  "Windows Server v6.3 x64" {$ResultsTable[1,$tmp_column]="Win8.1_64"}
                }
                
                
                $_.GetTests() | foreach {
                    for ($i=2 ;$i -le $Line ;$i++){
                        
                        if($_.Id -eq $ResultsTable[$i,1]){
                            $ResultsTable[$i,$tmp_column] = $_.Status
                    
                        }#end of if
                    }#end of for
                 
                } #end of GetTests
            } #end of get Projectinstance
         $tmp_column++
    
       } #end of if 
    
    } #end of $manager get projectname
    GenerateExcel $ResultsTable

}  #end of function
	
. GenerateJobSummary