#!/bin/bash
# Upload 2629 pricing pack to Drive + share with Rocky Gmail
# Auth: opsman.systems@gmail.com (matches MCP-created folder ownership)
#
# GOTCHA discovered 2026-05-04 PM late on this run:
#   gws CLI `files create --params '{"name":..., "parents":[...], "mimeType":...}'`
#   uploads bytes but IGNORES all 3 fields. Files land in opsman.systems@gmail.com
#   My Drive root with name="Untitled" + mimeType="application/x-zip" (auto-detected).
#   xlsx files become unreadable in Drive UI because mimeType is wrong.
#
# CORRECT PATTERN: pass file metadata via --json (request body), NOT --params (URL query).
#
#   gws drive files create \
#       --upload "<path>" \
#       --json '{"name":"<name>","parents":["<folder_id>"],"mimeType":"<mime>"}'
#
# Spreadsheet mime: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
# PDF mime:         application/pdf  (Drive auto-detects PDF correctly)
# Word mime:        application/vnd.openxmlformats-officedocument.wordprocessingml.document
#
# Recovery if files already misuploaded: see fix_2629_drive.sh (rename + move) and
# reupload pattern in /tmp/reupload_xlsx.sh (delete broken + re-create with --json).

set -e

export GOOGLE_WORKSPACE_CLI_CONFIG_DIR="C:\\Users\\mclou\\.config\\gws-opsman"

JOB_DIR="HQ-Vault/11_OpsMan_LFCS/Operations/Jobs/Upcoming/2629 - TCE - Erskine Park WWTP Slab/02 - Scope and Pricing"
BOQ_FOLDER="1u1fFZWerF3kWV-oeFiWiHciwhgR-CcYx"
QUOTES_FOLDER="15Nv8QhVwo4IVS1U9AuBMFqoSrEEom3gy"
ROCKY_EMAIL="mcloughlinmichael.r@gmail.com"

upload_and_share() {
    local file_path="$1"
    local parent_folder="$2"
    local mime="$3"
    local file_name=$(basename "$file_path")

    echo "----- Uploading: $file_name -----"
    local result=$(gws drive files create \
        --upload "$file_path" \
        --params "{\"name\":\"$file_name\",\"parents\":[\"$parent_folder\"],\"mimeType\":\"$mime\"}" 2>&1)
    local file_id=$(echo "$result" | python -c "import json,sys; data=sys.stdin.read(); start=data.find('{'); print(json.loads(data[start:])['id'])" 2>&1)

    if [ -z "$file_id" ] || [ "$file_id" = "" ]; then
        echo "FAILED to extract file_id from result:"
        echo "$result"
        return 1
    fi

    echo "  uploaded id=$file_id"
    gws drive permissions create \
        --json "{\"role\":\"writer\",\"type\":\"user\",\"emailAddress\":\"$ROCKY_EMAIL\"}" \
        --params "{\"fileId\":\"$file_id\",\"sendNotificationEmail\":false,\"supportsAllDrives\":true}" >/dev/null 2>&1
    echo "  shared with $ROCKY_EMAIL as writer (no notification)"
    echo "  https://drive.google.com/file/d/$file_id/view"
    echo ""
}

# BOQ & Rate Schedules folder
# Pre-Pricing-Grill already uploaded + shared in prior run: file_id=12vi7DcRTS-Pt6qXBZsp6LMl4Hoi21nSs
echo "----- SKIPPING 2629-Pre-Pricing-Grill_v-CC.pdf (already uploaded id=12vi7DcRTS-Pt6qXBZsp6LMl4Hoi21nSs) -----"
echo "  https://drive.google.com/file/d/12vi7DcRTS-Pt6qXBZsp6LMl4Hoi21nSs/view"
echo ""
upload_and_share "$JOB_DIR/02b - BOQ and Rate Schedules/2629-Take-Off_v-CC.xlsx" "$BOQ_FOLDER" "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
upload_and_share "$JOB_DIR/02b - BOQ and Rate Schedules/2629-Rate-Buildup_v-CC.xlsx" "$BOQ_FOLDER" "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"

# Quotes & Estimates folder
upload_and_share "$JOB_DIR/02a - Quotes and Estimates/2629-Tender-Summary_v-CC.xlsx" "$QUOTES_FOLDER" "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
upload_and_share "$JOB_DIR/02a - Quotes and Estimates/2629-Tender-Summary-Cover_v-CC.pdf" "$QUOTES_FOLDER" "application/pdf"
upload_and_share "$JOB_DIR/02a - Quotes and Estimates/2629-Inclusions-Exclusions_v-CC.pdf" "$QUOTES_FOLDER" "application/pdf"
upload_and_share "$JOB_DIR/02a - Quotes and Estimates/2629-Submission-Cover_v-CC.pdf" "$QUOTES_FOLDER" "application/pdf"

echo "All 7 files uploaded + shared."