/**
 * @OnlyCurrentDoc
 * @see https://developers.google.com/apps-script/guides/services/authorization
 *
 * @requires https://www.googleapis.com/auth/script.external_request
 */

function getJWTToken() {
  const url = 'https://time4realestate.com/wp-json/jwt-auth/v1/token';
  const payload = {
    username: 'kpstg',
    password: 'TLV%d7&GS3^cVW43^u(Ny!#&'
  };

  const options = {
    method: 'POST',
    contentType: 'application/json',
    payload: JSON.stringify(payload),
    muteHttpExceptions: true
  };

  const response = UrlFetchApp.fetch(url, options);
  const result = JSON.parse(response.getContentText());

  if (response.getResponseCode() === 200 && result.token) {
    return result.token;
  } else {
    throw new Error('Failed to get JWT token: ' + result.message);
  }
}

function createWordPressProperty(property) {
  const token = getJWTToken();
  
  const options = {
    method: 'POST',
    contentType: 'application/json',
    headers: {
      'Authorization': 'Bearer ' + token
    },
    payload: JSON.stringify({
      title: property.title,
      price: property.price,
      address: property.address,
      description: property.description,
      bedrooms: property.bedrooms,
      bathrooms: property.bathrooms,
      size: property.size,
      type: property.type,
      image_url: property.image_url
    }),
    muteHttpExceptions: true
  };

  const url = 'https://time4realestate.com/wp-json/realestate/v1/properties';

  const response = UrlFetchApp.fetch(url, options);
  const result = JSON.parse(response.getContentText());

  if (response.getResponseCode() !== 200 && response.getResponseCode() !== 201) {
    throw new Error('Failed to create property: ' + result.message);
  }
}

function updateWordPressProperty(property) {
  const token = getJWTToken();
  
  const options = {
    method: 'POST',
    contentType: 'application/json',
    headers: {
      'Authorization': 'Bearer ' + token
    },
    payload: JSON.stringify({
      title: property.title,
      price: property.price,
      address: property.address,
      description: property.description,
      bedrooms: property.bedrooms,
      bathrooms: property.bathrooms,
      size: property.size,
      type: property.type,
      image_url: property.image_url
    }),
    muteHttpExceptions: true
  };

  const url = 'https://time4realestate.com/wp-json/realestate/v1/properties/' + property.ID;

  const response = UrlFetchApp.fetch(url, options);
  const result = JSON.parse(response.getContentText());

  if (response.getResponseCode() !== 200 && response.getResponseCode() !== 201) {
    throw new Error('Failed to update property: ' + result.message);
  }
}

function onEdit(e) {
  if (e && e.range) {
    const editedRow = e.range.getRow();
    const sheet = e.source.getActiveSheet();
    const dataRange = sheet.getDataRange();
    const values = dataRange.getValues();

    if (editedRow > 1 && editedRow <= values.length) {
      const property = {
        ID: values[editedRow - 1][0] !== '' ? values[editedRow - 1][0] : null,
        title: values[editedRow - 1][1],
        price: values[editedRow - 1][2] !== '' ? values[editedRow - 1][2] : null,
        address: values[editedRow - 1][3] !== '' ? values[editedRow - 1][3] : null,
        description: values[editedRow - 1][4] !== '' ? values[editedRow - 1][4] : null,
        bedrooms: values[editedRow - 1][5] !== '' ? values[editedRow - 1][5] : null,
        bathrooms: values[editedRow - 1][6] !== '' ? values[editedRow - 1][6] : null,
        size: values[editedRow - 1][7] !== '' ? values[editedRow - 1][7] : null,
        type: values[editedRow - 1][8] !== '' ? values[editedRow - 1][8] : null,
        image_url: values[editedRow - 1][9] !== '' ? values[editedRow - 1][9] : null
      };

      if (!property.ID) {
        try {
          createWordPressProperty(property);
          Logger.log('New property created successfully.');
        } catch (error) {
          Logger.log('Failed to create new property: ' + error);
        }
      } else {
        try {
          updateWordPressProperty(property);
          Logger.log('Property updated successfully.');
        } catch (error) {
          Logger.log('Failed to update property: ' + error);
        }
      }
    }
  } else {
    console.log("Event object or range is undefined.");
  }
}

const WORDPRESS_API_URL = 'https://time4realestate.com/wp-json/realestate/v1/properties';

function fetchPropertiesFromWordPress() {
  const response = UrlFetchApp.fetch(WORDPRESS_API_URL);
  const properties = JSON.parse(response.getContentText());
  
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.clear();
  
  const headers = ['ID', 'Title', 'Price', 'Address', 'Description', 'Bedrooms', 'Bathrooms', 'Size', 'Type', 'Image URL'];
  sheet.appendRow(headers);
  
  properties.forEach(property => {
    sheet.appendRow([
      property.ID, 
      property.title, 
      property.price, 
      property.address, 
      property.description, 
      property.bedrooms,
      property.bathrooms,
      property.size,
      property.type,
      property.image_url
    ]);
  });
}

function onOpen() {
  const ui = SpreadsheetApp.getUi();
  ui.createMenu('WordPress')
    .addItem('Fetch Properties', 'fetchPropertiesFromWordPress')
    .addToUi();
}
{"version":"1.0","provider_name":"Time 4 Real Estate","provider_url":"https:\/\/time4realestate.com","author_name":"kpstg","author_url":"https:\/\/time4realestate.com\/author\/kpstg\/","title":"New Pre-construction Sales","type":"rich","width":600,"height":338,"html":"<blockquote class=\"wp-embedded-content\" data-secret=\"7Bjso1YlWn\"><a href=\"https:\/\/time4realestate.com\/preconstruction\/\">New Pre-construction Sales<\/a><\/blockquote><iframe sandbox=\"allow-scripts\" security=\"restricted\" src=\"https:\/\/time4realestate.com\/preconstruction\/embed\/#?secret=7Bjso1YlWn\" width=\"600\" height=\"338\" title=\"&#8220;New Pre-construction Sales&#8221; &#8212; Time 4 Real Estate\" data-secret=\"7Bjso1YlWn\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" class=\"wp-embedded-content\"><\/iframe><script type=\"text\/javascript\">\n\/* <![CDATA[ *\/\n\/*! This file is auto-generated *\/\n!function(d,l){\"use strict\";l.querySelector&&d.addEventListener&&\"undefined\"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!\/[^a-zA-Z0-9]\/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret=\"'+t.secret+'\"]'),o=l.querySelectorAll('blockquote[data-secret=\"'+t.secret+'\"]'),c=new RegExp(\"^https?:$\",\"i\"),i=0;i<o.length;i++)o[i].style.display=\"none\";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute(\"style\"),\"height\"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):\"link\"===t.message&&(r=new URL(s.getAttribute(\"src\")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener(\"message\",d.wp.receiveEmbedMessage,!1),l.addEventListener(\"DOMContentLoaded\",function(){for(var e,t,s=l.querySelectorAll(\"iframe.wp-embedded-content\"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute(\"data-secret\"))||(t=Math.random().toString(36).substring(2,12),e.src+=\"#?secret=\"+t,e.setAttribute(\"data-secret\",t)),e.contentWindow.postMessage({message:\"ready\",secret:t},\"*\")},!1)))}(window,document);\n\/* ]]> *\/\n<\/script>\n"}