Advertisement
liuhongbo

Untitled

Feb 10th, 2021
861
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. $today = Get-Date
  2. $TodayString = $today.ToShortDateString()
  3. $today = [datetime]::parse($TodayString)
  4. $today=$today.AddDays(-1)
  5.  
  6. $PlantsXml = ./concretego request --entity Plant
  7.  
  8. $PlantsXmlDoc = [xml]$PlantsXml
  9. $PlantNodes = $PlantsXmlDoc.SelectNodes("//PlantRet")
  10.  
  11. $FromTicketTime = $today.ToString("s")
  12. $ToTicketTime = $today.AddDays(1).AddSeconds(-1).ToString("s")
  13.  
  14. foreach ($PlantNode in $PlantNodes) {
  15.     $Plant = $PlantNode.SelectSingleNode("Code").InnerText
  16.     $FileNameSuffix = $today.tostring("yyyy-MM-dd") + "-P" + $Plant    
  17.     ./concretego request --entity Ticket --filter "FromTicketTime=$FromTicketTime" --filter "ToTicketTime=$ToTicketTime" --filter "PlantCode=$Plant" --filter="IncludeRemovedTicket=True" --filter="IncludeRetElement=USERDEFINEDFIELD" --output-format xml --output-xslt ticket-export.xsl -o "c:\concretegodata\export\tickets-$FileNameSuffix.txt"
  18. }
  19.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement