#!/bin/bash

SOURCE_PAGE_ID=280606
CSV_FILE="cities.csv"

tail -n +2 "$CSV_FILE" | while IFS=',' read -r city state
do
  slug_city=$(echo "$city" | tr '[:upper:]' '[:lower:]' | tr ' ' '-')
  post_title="Web App Development Company $city"
  post_slug="web-app-development-company-${slug_city}"

  new_page_id=$(wp post create --from-post=$SOURCE_PAGE_ID --post_type=page --post_status=draft \
    --post_title="$post_title" --post_name="$post_slug" --porcelain)

  echo "✅ Created: $post_title → Page ID $new_page_id"

  # Fetch base _elementor_data in JSON
  base_data=$(wp post meta get $SOURCE_PAGE_ID _elementor_data --format=json)

  # Replace placeholders in JSON safely
  updated_data=$(echo "$base_data" | sed "s/{City}/$city/g" | sed "s/{State}/$state/g")

  # Save to temporary JSON file
  temp_file=$(mktemp /tmp/elementor_data.XXXXXX.json)
  echo "$updated_data" > "$temp_file"

  # Pass JSON via stdin (avoids shell arg limit)
  wp post meta update "$new_page_id" _elementor_data --format=json < "$temp_file"
  rm "$temp_file"

  # Update Elementor mode
  wp post meta update $new_page_id _elementor_edit_mode builder
  wp post meta update $new_page_id _elementor_template_type page

  # Update Yoast SEO
  wp post meta update $new_page_id _yoast_wpseo_title "Web App Development Company $city, $state | MMC Global"
  wp post meta update $new_page_id _yoast_wpseo_metadesc "Leading web app development company in $city, $state that delivers problem-solving and high-performing custom solutions for all businesses."
  wp post meta update $new_page_id _yoast_wpseo_focuskw "Web App Development $city"

  # Open Graph / Twitter
  wp post meta update $new_page_id _yoast_wpseo_opengraph-title "Web App Development Company $city, $state | MMC Global"
  wp post meta update $new_page_id _yoast_wpseo_opengraph-description "Leading web app development company in $city, $state that delivers problem-solving and high-performing custom solutions for all businesses."
  wp post meta update $new_page_id _yoast_wpseo_twitter-title "Web App Development Company $city, $state | MMC Global"
  wp post meta update $new_page_id _yoast_wpseo_twitter-description "Leading web app development company in $city, $state that delivers problem-solving and high-performing custom solutions for all businesses."

done