<?php
/*
* This file generates an xml feed of reviews
* The format is specific to Google Merchant Center
*/

/*
* Settings
*/
//Location of the feed file, starting with a slash and ending in .xml
$file_path = '/feeds/product-reviews.xml';
//If this is left empty, the value from global config will be used
$siteTitle = '';
//It must be png, jpg or gif and 16x16px
$favicon = 'https://www.juicybike.co.uk/favicon_16.png';
// Min and max ratings set in hikashop options
$minRating = 1;
$maxRating = 5;
//We need the id's of the products in each category to add the reviews to each bike
$classic_ids = array(198,201,281,303);
$sport_ids = array(199,180,285,336);
$compact_ids = array(191,340);


// Turn off all error reporting
//error_reporting(0);
// Configure error reporting to maximum for CLI output.
error_reporting(E_ALL);
ini_set('display_errors', 1);

// We are a valid entry point.
const _JEXEC = 1;

// Load system defines
if (file_exists(dirname(__DIR__) . '/defines.php'))
{
  require_once dirname(__DIR__) . '/defines.php';
}

if (!defined('_JDEFINES'))
{
  define('JPATH_BASE', dirname(__DIR__));
  require_once JPATH_BASE . '/includes/defines.php';
}

require_once JPATH_BASE . '/includes/framework.php';

// Instantiate the application.
$app = JFactory::getApplication('site');

$config = JFactory::getConfig();

$file_path = JPATH_SITE . $file_path;

if ($siteTitle === '') {
  $siteTitle =  $config->get('sitename');
}

$minRating = isset($minRating) ? $minRating : 1;
$maxRating = isset($maxRating) ? $maxRating : 5;

//import the hikashop router to construct the urls
//jimport only seems to work locally so we just use an include
//jimport('helpers.route', JPATH_SITE.'/components/com_hikashop');
include_once ('../components/com_hikashop/helpers/route.php');

// Get a db connection.
$db = JFactory::getDbo();

// Create a new query object.
$query = $db->getQuery(true);

// Select all records from the hikashop vote table
// Order it by the id field, newest first.
$query->select('*');
$query->from($db->quoteName('#__hikashop_vote'));
$query->order('vote_ref_id DESC');
// Reset the query using our newly populated query object.
$db->setQuery($query);

// Load the results as a list of stdClass objects.
$reviews = $db->loadObjectList();

$xmlItems = array();

if($reviews){

  //Function to clean the comment and make it xml compatible
  function clean_comment($text) {
    $text = strip_tags($text); //Remove all html tags
    $text = str_replace('&nbsp;', ' ', $text); // Replaces non-breaking spaces with a normal space
    $text = str_replace('&ndash;', '-', $text);
    $text = str_replace('&pound;', '£', $text);
    $text = str_replace('&amp;', '&', $text);
    $text = str_replace(array('&lsquo;', '&rsquo;', '&rdquo;', '&ldquo;', '’', '‘', '”', '“'), '\'', $text); //Converts different quotes to singles
    $text = htmlspecialchars($text, ENT_QUOTES); //Converts any other chars to the correct entities and encodes single quotes
    $text = str_replace('&#039;', '&apos;', $text);
    $text = preg_replace('#\bhttps?://[^,\s()<>]+(?:\([\w\d]+\)|([^,[:punct:]\s]|/))#', '', $text); //Strips and urls from the text

    return $text;
  }

  //Loop through the reviews and add a node for each
  foreach ($reviews as $review) {

    //Get the item details
    $query = $db->getQuery(true);
    $query->select('*');
    $query->from($db->quoteName('#__hikashop_product'));
    $query->where('product_id = '. $review->vote_ref_id);
    $query->setLimit('1');
    $db->setQuery($query);
// Load the results as a list of stdClass objects.
    $product = $db->loadAssoc();

    if ($product['product_published'] == 1) {

      $mpn = str_replace(array(' ','-'),array('',''), $product['product_code']);

      $itemLink = str_replace('/cli/', '/', hikashopTagRouteHelper::getProductRoute($review->vote_ref_id));

      $itemTitle = $item->title;
      $item = "\t".'<review>'."\n";
      $item .= "\t\t".'<review_id>'.$review->vote_id.'</review_id>'."\n";
      $item .= "\t\t".'<reviewer>'."\n";
      $item .= "\t\t\t".'<name>'.trim($review->vote_pseudo). '</name>'."\n";
      $item .= "\t\t".'</reviewer>'."\n";
      $item .= "\t\t".'<review_timestamp>'.date('Y-m-d\Th:i:s\Z', $review->vote_date).'</review_timestamp>'."\n";
      $item .= "\t\t".'<content>'.clean_comment($review->vote_comment).'</content>'."\n";
      $item .= "\t\t".'<review_url type="group">'.$itemLink.'</review_url>'."\n";
      $item .= "\t\t".'<ratings>'."\n";
      $item .= "\t\t\t".'<overall min="'.$minRating.'" max="'.$maxRating.'">'.$review->vote_rating. '</overall>'."\n";
      $item .= "\t\t".'</ratings>'."\n";
      $item .= "\t\t".'<products>'."\n";
      $item .= "\t\t\t".'<product>'."\n";
      $item .= "\t\t\t\t<product_ids>\n";
      $item .= "\t\t\t\t\t<mpns>\n";
      $item .= "\t\t\t\t\t\t<mpn>".$mpn."</mpn>\n";
      $item .= "\t\t\t\t\t</mpns>\n";
      $item .= "\t\t\t\t\t<brands>\n";
      $item .= "\t\t\t\t\t\t<brand>Juicy Bike</brand>\n";
      $item .= "\t\t\t\t\t</brands>\n";
      $item .= "\t\t\t\t</product_ids>\n";
      $item .= "\t\t\t\t<product_url>".$itemLink."</product_url>\n";
      $item .= "\t\t\t".'</product>'."\n";
      $item .= "\t\t".'</products>'."\n";
      $item .= "\t".'</review>'."\n";
    //push into the items
      $xmlItems[] = $item;

    }  //end if published
  } 
}

// Output XML header.
$xml = '<?xml version="1.0" encoding="UTF-8"?>' . "\n";
$xml .= '<feed xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.google.com/shopping/reviews/schema/product/2.1/product_reviews.xsd">' . "\n";

// Output root element.
$xml .= '<publisher>'."\n";
$xml .= '<name>'.$siteTitle.'</name>'."\n";
$xml .= '<favicon>'.$favicon.'</favicon>'."\n";
$xml .= '</publisher>'."\n";
$xml .= '<reviews>'."\n";


// Output the data.
if(!empty($xmlItems)){
  foreach ($xmlItems as $xmlItem){
    $xml .= $xmlItem;
  }
}

// Terminate the reviews element
$xml .= '</reviews>'."\n";
// Terminate feed element.
$xml .= '</feed>'."\n";

if(JFile::write($file_path, $xml)) {
  echo "Product review feed generated sucessfully";
} else {
  echo "There was an error saving the product review feed";
}