TECHS 現地調査ツール
Invoke-TechsSiteSurvey.ps1

Invoke-Command -Session $s {
  [Net.ServicePointManager]::SecurityProtocol = 'Tls12'
  $root = 'C:\techs-sync'

  # 最新版を取得
  Invoke-WebRequest 'https://dev.fab-forward.co.jp/fab-forward-dev/srv/sites/techs6-agent/techs-sync.zip' -OutFile "$root\a.zip" -UseBasicParsing
  Expand-Archive "$root\a.zip" -DestinationPath "$root\current" -Force
  "installed version: " + (Get-Content "$root\current\VERSION" -Raw).Trim()

  # パスワードは画面に表示されます（schtasks が平文を要求するため）
  $pw = Read-Host "TECHS-SERVER\Administrator のパスワード"

  # /F で既存タスクを上書き。未登録でも、Interactive で登録済みでも、
  # どちらでもこれ1回で正しい状態になります
  schtasks /Create /TN "FabForward-TechsSync" /TR "cmd /c C:\techs-sync\run.cmd" `
           /SC MINUTE /MO 15 /RU "TECHS-SERVER\Administrator" /RP $pw /RL HIGHEST /F

  # すぐ1回動かして確認
  schtasks /Run /TN "FabForward-TechsSync"
  Start-Sleep -Seconds 20

  "--- 実行アカウント ---"
  (Get-ScheduledTask -TaskName 'FabForward-TechsSync').Principal | Format-List UserId, LogonType, RunLevel
  "--- 実行結果 ---"
  Get-ScheduledTask -TaskName 'FabForward-TechsSync' | Get-ScheduledTaskInfo |
    Format-List LastRunTime, LastTaskResult, NextRunTime
  "--- ログ ---"
  Get-ChildItem "$root\logs\agent-*.log" -ErrorAction SilentlyContinue |
    Sort-Object LastWriteTime | Select-Object -Last 1 | Get-Content -Tail 6
}

Invoke-Command -Session $s {
  Get-ScheduledTask -TaskName 'FabForward-TechsSync' | Get-ScheduledTaskInfo |
    Select-Object LastRunTime, LastTaskResult, NextRunTime
  Get-ChildItem 'C:\techs-sync\logs\agent-*.log' | Sort-Object LastWriteTime |
    Select-Object -Last 1 | Get-Content -Tail 8
}

# TLS1.2 を明示。Windows PowerShell 5.1 の既定は古く、これが無いと HTTPS に失敗します
[Net.ServicePointManager]::SecurityProtocol = 'Tls12'
$u = 'https://dev.fab-forward.co.jp/fab-forward-dev/srv/sites/techs6-survey/Invoke-TechsSiteSurvey.ps1.txt'
$p = "$env:TEMP\Invoke-TechsSiteSurvey.ps1"
Invoke-WebRequest $u -OutFile $p -UseBasicParsing
Unblock-File $p
powershell -NoProfile -ExecutionPolicy Bypass -File $p

# 保存したファイルのある場所へ移動してから実行（例: ダウンロードフォルダ）
cd $env:USERPROFILE\Downloads

# .txt を外して .ps1 にし、ダウンロード由来のブロックを解除して実行
Copy-Item .\Invoke-TechsSiteSurvey.ps1.txt .\Invoke-TechsSiteSurvey.ps1 -Force
Unblock-File .\Invoke-TechsSiteSurvey.ps1
powershell -NoProfile -ExecutionPolicy Bypass -File .\Invoke-TechsSiteSurvey.ps1

Get-VM | Select-Object Name, State, Uptime | Format-Table -AutoSize

# ★ここだけ書き換える（Get-VM で出た名前）
$vm = 'TECHS-SERVER'

# ホスト側でツールを取得
[Net.ServicePointManager]::SecurityProtocol = 'Tls12'
$p = "$env:TEMP\Invoke-TechsSiteSurvey.ps1"
Invoke-WebRequest 'https://dev.fab-forward.co.jp/fab-forward-dev/srv/sites/techs6-survey/Invoke-TechsSiteSurvey.ps1.txt' -OutFile $p -UseBasicParsing
Unblock-File $p

# VM の資格情報。Get-Credential は使わない（下の注意を参照）
$user = 'Administrator'
$pw = Read-Host "$vm の $user のパスワード" -AsSecureString
$c  = New-Object System.Management.Automation.PSCredential($user, $pw)

$s = New-PSSession -VMName $vm -Credential $c

# 送り込んで、VM の中で実行
Copy-Item $p -Destination 'C:\Users\Public\Invoke-TechsSiteSurvey.ps1' -ToSession $s
Invoke-Command -Session $s { powershell -NoProfile -ExecutionPolicy Bypass -File 'C:\Users\Public\Invoke-TechsSiteSurvey.ps1' -OutputDirectory 'C:\Users\Public' }

# 結果をホストへ回収
$out = "$env:USERPROFILE\Downloads\report"
New-Item -ItemType Directory -Force $out | Out-Null
Copy-Item -FromSession $s 'C:\Users\Public\techs-survey-*.json' -Destination $out
Copy-Item -FromSession $s 'C:\Users\Public\techs-survey-*.txt'  -Destination $out
Remove-PSSession $s
Write-Host "回収先: $out"

Test-NetConnection TECHS-SERVER -Port 1433

powershell -NoProfile -ExecutionPolicy Bypass -File .\Invoke-TechsSiteSurvey.ps1 -ServerInstance TECHS-SERVER

# ★書き換えるのはこの3行だけ
$server   = 'TECHS-SERVER'
$database = 'TECHS6_TEST'          # 通ったら 'TECHS6' に変える
$apiKey   = 'ここに鍵を貼る'          # または下の「鍵を打ち込まずに取る」を使う

# エージェントを取得
[Net.ServicePointManager]::SecurityProtocol = 'Tls12'
$root = 'C:\techs-sync'
New-Item -ItemType Directory -Force $root | Out-Null
Invoke-WebRequest 'https://dev.fab-forward.co.jp/fab-forward-dev/srv/sites/techs6-agent/techs-sync.zip' -OutFile "$root\a.zip" -UseBasicParsing
Expand-Archive "$root\a.zip" -DestinationPath "$root\current" -Force

# 設定を書く。SQL認証が無効なサーバーでは integratedSecurity が必須
$cfg = Get-Content "$root\current\config.example.json" -Raw | ConvertFrom-Json
$cfg.techs.server = $server
$cfg.techs.database = $database
$cfg.techs.integratedSecurity = $true
$cfg.api.baseUrl = 'https://create.fab-forward.co.jp'
$cfg.api.apiKey  = $apiKey
$cfg | ConvertTo-Json -Depth 10 | Set-Content "$root\config.json" -Encoding UTF8

# 何を送ることになるか一覧（★送信しません）
powershell -NoProfile -ExecutionPolicy Bypass -File "$root\current\Export-TechsAll.ps1" -ConfigPath "$root\config.json" -Preflight

# ★ホスト(Hyper-V)で実行。書き換えるのは3行
$vm   = 'TECHS-SERVER'
$user = 'Administrator'
$db   = 'TECHS6_TEST'          # 通ったら 'TECHS6'

# 既存セッションを再利用。無ければ作る
$s = Get-PSSession -VMName $vm -ErrorAction SilentlyContinue |
     Where-Object { $_.State -eq 'Opened' } | Select-Object -First 1
if (-not $s) {
  $pw = Read-Host "$vm の $user のパスワード" -AsSecureString
  $s  = New-PSSession -VMName $vm -Credential (New-Object System.Management.Automation.PSCredential($user, $pw))
}

Invoke-Command -Session $s -ArgumentList $db -ScriptBlock {
  param($db)
  [Net.ServicePointManager]::SecurityProtocol = 'Tls12'
  $apiKey = (Invoke-WebRequest '別途お伝えする鍵のURL' -UseBasicParsing).Content.Trim()

  $root = 'C:\techs-sync'
  New-Item -ItemType Directory -Force $root | Out-Null
  Invoke-WebRequest 'https://dev.fab-forward.co.jp/fab-forward-dev/srv/sites/techs6-agent/techs-sync.zip' -OutFile "$root\a.zip" -UseBasicParsing
  Expand-Archive "$root\a.zip" -DestinationPath "$root\current" -Force

  $cfg = Get-Content "$root\current\config.example.json" -Raw | ConvertFrom-Json
  $cfg.techs.server = 'localhost'        # 自ホスト名ではなく localhost
  $cfg.techs.database = $db
  $cfg.techs.integratedSecurity = $true
  $cfg.api.baseUrl = 'https://create.fab-forward.co.jp'
  $cfg.api.apiKey  = $apiKey
  $cfg | ConvertTo-Json -Depth 10 | Set-Content "$root\config.json" -Encoding UTF8

  powershell -NoProfile -ExecutionPolicy Bypass -File "$root\current\Export-TechsAll.ps1" -ConfigPath "$root\config.json" -Preflight
}

Invoke-Command -Session $s {
  powershell -NoProfile -ExecutionPolicy Bypass -File "C:\techs-sync\current\Export-TechsAll.ps1" `
    -ConfigPath "C:\techs-sync\config.json" -Preflight *>&1 |
    Out-File -FilePath 'C:\Users\Public\preflight.txt' -Encoding UTF8
}

# ホストへ回収
$out = "$env:USERPROFILE\Downloads\report"
New-Item -ItemType Directory -Force $out | Out-Null
Copy-Item -FromSession $s 'C:\Users\Public\preflight.txt' -Destination $out
Write-Host "回収先: $out\preflight.txt"

Invoke-Command -Session $s {
  $a = '-NoProfile -ExecutionPolicy Bypass -File "C:\techs-sync\current\Export-TechsAll.ps1" -ConfigPath "C:\techs-sync\config.json"'
  Start-Process powershell.exe -ArgumentList $a -WindowStyle Hidden
  'started, detached'
}

# ★送るファイルと、区別するためのタグ
Invoke-Command -Session $s -ArgumentList 'C:\Users\Public\preflight.txt','PREFLIGHT_TECHS6' -ScriptBlock {
  param($path, $tag)
  [Net.ServicePointManager]::SecurityProtocol = 'Tls12'
  $cfg   = Get-Content 'C:\techs-sync\config.json' -Raw | ConvertFrom-Json
  $lines = @(Get-Content $path -Encoding UTF8)

  $rows = New-Object System.Collections.ArrayList
  for ($i = 0; $i -lt $lines.Count; $i++) {
    [void]$rows.Add([pscustomobject]@{ n = $i + 1; text = [string]$lines[$i] })
  }

  $body = @{
    batchId        = "REPORT-$tag-" + (Get-Date -Format 'yyyyMMddHHmmss')
    sequenceNumber = 1
    isFinal        = $true
    source         = 'techs-s'
    entity         = "ZZ_$tag"
    sourceObject   = $path
    rowCount       = $rows.Count
    rows           = $rows
  } | ConvertTo-Json -Depth 6

  Invoke-RestMethod -Uri ($cfg.api.baseUrl + '/api/integrations/techs/batches') -Method Post `
    -Headers @{ 'x-api-key' = $cfg.api.apiKey } `
    -ContentType 'application/json; charset=utf-8' `
    -Body ([Text.Encoding]::UTF8.GetBytes($body))
}

[Net.ServicePointManager]::SecurityProtocol = 'Tls12'
$keyUrl = '別途お伝えするURL'
$apiKey = (Invoke-WebRequest $keyUrl -UseBasicParsing).Content.Trim()
$apiKey.Length   # 72 と出れば取得成功

Invoke-Command -Session $s {
  [Net.ServicePointManager]::SecurityProtocol = 'Tls12'

  # 最新版を取り直す
  Invoke-WebRequest 'https://dev.fab-forward.co.jp/fab-forward-dev/srv/sites/techs6-agent/techs-sync.zip' -OutFile 'C:\techs-sync\a.zip' -UseBasicParsing
  Expand-Archive 'C:\techs-sync\a.zip' -DestinationPath 'C:\techs-sync\current' -Force

  powershell -NoProfile -ExecutionPolicy Bypass -File "C:\techs-sync\current\Export-TechsAll.ps1" `
    -ConfigPath "C:\techs-sync\config.json" -SchemaReport
}

# ★1つめ=送るJSON、2つめ=再開するチャンク番号（初回は 0）
Invoke-Command -Session $s -ArgumentList 'C:\techs-sync\logs\schema-report-日時.json',0 -ScriptBlock {
  param($path, $startChunk)

  [Net.ServicePointManager]::SecurityProtocol = 'Tls12'
  $cfg = Get-Content 'C:\techs-sync\config.json' -Raw | ConvertFrom-Json
  $uri = $cfg.api.baseUrl.TrimEnd('/') + '/api/integrations/techs/batches'
  $hdr = @{ 'x-api-key' = $cfg.api.apiKey }

  # PS 5.1 の ConvertTo-Json は [DBNull] を {} に直す。受け側は値を
  # 文字列/数値/真偽/null に限定しているので {} は 400 で弾かれる。
  function San($v) {
    if ($null -eq $v) { return $null }
    if ($v -is [System.DBNull]) { return $null }
    if ($v -is [string] -or $v -is [bool] -or $v -is [int] -or $v -is [long] `
        -or $v -is [double] -or $v -is [decimal]) { return $v }
    if ($v -is [System.Management.Automation.PSCustomObject]) { return $null }
    return [string]$v
  }

  Write-Host "reading $path ..."
  $all = @(Get-Content $path -Raw -Encoding UTF8 | ConvertFrom-Json)
  $size = 1000
  $total = [math]::Ceiling($all.Count / $size)
  Write-Host "$($all.Count) rows -> $total chunk(s)"

  $batchId = 'SCHEMA-' + (Get-Date -Format 'yyyyMMddHHmmss')
  for ($c = $startChunk; $c -lt $total; $c++) {
    $raw = $all[($c * $size)..([math]::Min(($c + 1) * $size, $all.Count) - 1)]

    $clean = New-Object System.Collections.ArrayList
    foreach ($r in $raw) {
      $h = @{}
      foreach ($pn in $r.PSObject.Properties.Name) { $h[$pn] = San $r.$pn }
      [void]$clean.Add([pscustomobject]$h)
    }

    $body = @{
      batchId = $batchId; sequenceNumber = $c + 1; isFinal = ($c -eq $total - 1)
      source = 'techs-s'; entity = 'ZZ_SCHEMA'; sourceObject = 'schema-report'
      rowCount = $clean.Count; rows = $clean
    } | ConvertTo-Json -Depth 6 -Compress

    $ok = $false
    for ($try = 1; $try -le 5 -and -not $ok; $try++) {
      try {
        Invoke-RestMethod -Uri $uri -Method Post -Headers $hdr `
          -ContentType 'application/json; charset=utf-8' `
          -Body ([Text.Encoding]::UTF8.GetBytes($body)) -TimeoutSec 120 | Out-Null
        $ok = $true
      }
      catch {
        # サーバーの本文を出す。どの項目が不正か details.fields に出る
        $detail = $_.Exception.Message
        try {
          $rs = $_.Exception.Response.GetResponseStream()
          $detail = (New-Object IO.StreamReader($rs)).ReadToEnd()
        } catch { }
        Write-Host "  chunk $($c+1)/$total attempt $try : $detail"
        Start-Sleep -Seconds (2 * $try)
      }
    }
    if (-not $ok) { throw "chunk $($c+1) failed. 再開は -ArgumentList の2番目を $c に" }
    Write-Host "  sent $($c+1)/$total"
  }
  Write-Host "done. batchId=$batchId"
}

Invoke-Command -Session $s {
  powershell -NoProfile -ExecutionPolicy Bypass -File "C:\techs-sync\current\Export-TechsAll.ps1" `
    -ConfigPath "C:\techs-sync\config.json" `
    -OnlyObjects 'MstItemNo','MstPartsCompose','TrnSOrderH','020101_受注一覧情報'
}

powershell -NoProfile -ExecutionPolicy Bypass -File "$root\current\Export-TechsAll.ps1" -ConfigPath "$root\config.json"

Invoke-Command -Session $s {
  [Net.ServicePointManager]::SecurityProtocol = 'Tls12'

  # 最新版を取り直す（C13/C17 と同じ）
  Invoke-WebRequest 'https://dev.fab-forward.co.jp/fab-forward-dev/srv/sites/techs6-agent/techs-sync.zip' -OutFile 'C:\techs-sync\a.zip' -UseBasicParsing
  Expand-Archive 'C:\techs-sync\a.zip' -DestinationPath 'C:\techs-sync\current' -Force

  # 小さい表は全件（1オブジェクト 5,000 行で頭打ち）
  powershell -NoProfile -ExecutionPolicy Bypass -File "C:\techs-sync\current\Export-TechsAll.ps1" `
    -ConfigPath "C:\techs-sync\config.json" -MaxRowsPerObject 5000 `
    -OnlyObjects 'SymKbnField','SymKbn','SymApKbn', `
      'MstOrderClass','120215_受注分類マスタ情報', `
      'MstPartsClass','120218_部品分類マスタ情報', `
      'CtlNumberCompose','120244_採番構成マスタ情報','120222_図番マスタ情報', `
      'TrnOrderMoneyRedBlack', `
      '020120_売上単位別売上原価情報','090209_受注別予実対比表情報','090220_受注原価情報', `
      '090224_製番別原価項目別原価情報','090231_受注別原価項目別原価情報', `
      '090214_製番別原価一覧情報','090223_製番別原価項目別原価予定情報','090210_部門別月別工場原価一覧情報'
}

Invoke-Command -Session $s {
  # 大きいビューは先頭 50 行だけ（形を見るため。全件は引きません）
  powershell -NoProfile -ExecutionPolicy Bypass -File "C:\techs-sync\current\Export-TechsAll.ps1" `
    -ConfigPath "C:\techs-sync\config.json" -MaxRowsPerObject 50 `
    -OnlyObjects '080105_在庫入出庫履歴一覧情報','080201_払出実績一覧情報','050101-2_払出指示書明細情報', `
      '090229_ユニット別原価項目別原価情報','090202_原価明細一覧情報','090225_部品別原価情報','ViwTrnBom'
}