// ==UserScript==
// @name         Rotten Tomatoes export CSV button with Reviews- update -2020
// @namespace
// @version      0.5
// @description  Adds a 'Download CSV' button to the personal ratings page in Rotten Tomatoes which downloads a Letterboxd compatible CSV file.
// @author       Guy Hizkiau
// @Guy who added reviews as an exported field   Lagomorph
// @match        https://www.rottentomatoes.com/user/id/*/ratings
// @grant        none
// @namespace https://greasyfork.org/users/72895
// @downloadURL https://update.greasyfork.cloud/scripts/395957/Rotten%20Tomatoes%20export%20CSV%20button%20with%20Reviews-%20update%20-2020.user.js
// @updateURL https://update.greasyfork.cloud/scripts/395957/Rotten%20Tomatoes%20export%20CSV%20button%20with%20Reviews-%20update%20-2020.meta.js
// ==/UserScript==
debugger;
String.prototype.replaceAll = function(search, replacement) {
    var target = this;
    return target.replace(new RegExp(search, 'g'), replacement);
};

var ratingBoxes = document.getElementsByClassName("ratings__user-rating-review");
var ratingsArray = [];

for (var i = ratingBoxes.length - 1; i >= 0; i--) {
	var boxBody = ratingBoxes[i].getElementsByClassName("bottom_divider ratings__user-rating")[0];

	var boxHeading = boxBody.getElementsByClassName("ratings__review-top")[0];
	var titleA = boxHeading.getElementsByTagName("a")[0];
	var title = titleA.textContent.replaceAll(",", "");

	var yearSpan = boxHeading.getElementsByTagName("span")[0];
	var year = yearSpan.textContent.substring(1,5);

	var ratingDiv = boxBody.getElementsByTagName("div")[1];
    var ratinghalf = 0;
    var ratingfull = ratingBoxes[i].getElementsByClassName("star-display__filled ").length;
    ratinghalf = ratingBoxes[i].getElementsByClassName("star-display__half ").length;
	if (ratinghalf == 1) {
		ratingValue = ratingfull + 0.5;
	}
	else {
		ratingValue = ratingfull;
	}

    var ratingLog = boxBody.getElementsByClassName("ratings__age")[0].textContent;
    var ratingDateVerbal = ratingLog.substring(0,ratingLog.indexOf("ago")-1).split(" ");

    var ratingDate = new Date();
    var ratingDateFormated;
    var ratingValue
    //var reviewRaw = boxBody.children[3].innerText; //grab raw review text
    var reviewRaw_full = boxBody.getElementsByClassName("ratings__comment")[0].textContent;
    var reviewRaw = reviewRaw_full.replaceAll("\"", "\"\""); //replace double quotes with double double quotes to prepare for comma sanitziation for CSV format
    reviewRaw = reviewRaw.replace(/\n/g, " ");
    reviewRaw = reviewRaw.replace(/[`~!@#$%^&*()]/gi, '');
    var review = '"' + reviewRaw + '"' //append quotes at beginning and end of string to escape all commas for CSV format

    if (ratingDateVerbal[1] == "days") {
        ratingDate.setDate(ratingDate.getDate()-ratingDateVerbal[0]);
        ratingDateFormated = ratingDate.getFullYear() + '-' + (ratingDate.getMonth()+1) + '-' + ratingDate.getDate();
    } else if (ratingDateVerbal[1] == "months") {
        ratingDate.setMonth(ratingDate.getMonth()-ratingDateVerbal[0]);
        ratingDateFormated = ratingDate.getFullYear() + '-' + (ratingDate.getMonth()+1) + '-' + 1;
    } else if (ratingDateVerbal[1] == "years") {
        ratingDate.setFullYear(ratingDate.getFullYear()-ratingDateVerbal[0]);
        ratingDateFormated = ratingDate.getFullYear() + '-' + 1 + '-' + 1;
    }

	ratingsArray.push([title, year, ratingDateFormated, ratingValue, review]);
}

//debugger;
var csvContent = "data:text/csv;charset=utf-8,";

csvContent += "Title,Year,WatchedDate,Rating,Review\n"

ratingsArray.forEach(function(infoArray, index){
   var dataString = infoArray.join(",");
   csvContent += index < ratingsArray.length ? dataString + "\n" : dataString;

});

var encodedUri = encodeURI(csvContent);
var link = document.createElement("a");
link.setAttribute("href", encodedUri);
link.setAttribute("download", "rotten_tomatoes_ratings.csv");
document.body.appendChild(link); // Required for FF

var pageBody = document.getElementsByClassName("panel-heading")[0]
//debugger;
function download() {
	link.click();
	return;
}

var downloadButton = document.createElement("button");
var buttonText = document.createTextNode("Download CSV");
downloadButton.appendChild(buttonText);
downloadButton.classList.add("panel-heading");
downloadButton.onclick = download;

pageBody.insertBefore(downloadButton, pageBody.children[0]);