plus.js

/// <reference path="intellisense.js" />

var g_msSyncPeriod = 3 * (60 * 1000); //3 minutes
var g_tipUserTopReport = "Sync";
var g_marginLabelChart = 35;
var g_heightBarUser = 30;
var g_bShowBoardMarkers = false;
var g_portBackground = null; //plus engine notifications to this tab
var g_bCheckedbSumFiltered = null; //null means not yet initialized (From sync storage)
var DELAY_FIRST_SYNC = 2000;
var g_cRetryingSync = 0;
var g_cRowsWeekByUser = 0; //gets set after making the chart. Used by the tour
var g_bShowHomePlusSections = true;
var g_bSkipUpdateSsLinks = false; //used by dimensions dropdown to hack arround legacy way to start sync
var g_bInsertedStripeScript = false;
var g_fnCallbackStripeMessage=null;

const PROP_LS_MSLASTNOSYNCWARN = "plus_ms_last_sync_warn"; //warning: can be in the future. date since last time we showed the configure warning. 
const PROP_LS_MSLAST_IGNORE_EXTUPGRADE = "plus_msLastIgnoreExtUpg";
const PROP_LS_ASKEDNOTUSINGSE = "plus_asked_not_usingse";

//board dimensions combo
//sync see SYNCPROP_BOARD_DIMENSION
var VAL_COMBOVIEWKW_PREFIX = "~#^*()-"; //use weird value as cheap way to avoid collision with keywords
var VAL_COMBOVIEWKW_ALL = VAL_COMBOVIEWKW_PREFIX + "all";
var VAL_COMBOVIEWKW_KWONLY = VAL_COMBOVIEWKW_PREFIX + "kwonly";
var VAL_COMBOVIEWKW_CARDTITLES = VAL_COMBOVIEWKW_PREFIX + "cardtitles";
var VAL_COMBOVIEWKW_HELP = VAL_COMBOVIEWKW_PREFIX + "help";
var VAL_COMBOVIEWKW_REPORTKW = VAL_COMBOVIEWKW_PREFIX + "reportkw";
var VAL_COMBOVIEWKW_HEADER = VAL_COMBOVIEWKW_PREFIX + "header";
var VAL_COMBOVIEWKW_SEP = VAL_COMBOVIEWKW_PREFIX + "sep";

var g_globalUser = ""; //saved in sync storage
var g_rgKeywordsHome = [];

//for sync performance, we keep the preference as a single string
//it can be one of the special values above, or a keyword string
var g_dimension = VAL_COMBOVIEWKW_ALL;
//review zig: this was the easy way to prevent charts from rendering until their container is attached to the dom.
//  in the home page case, we dont attach the plus 2x2 table until all its cells have loaded, so that its full height
//  is known, thus preventing page jumps as its height grows until all 4 cells are loaded.
// if we dont do this, the charts draw smaller, probably are not picking up some font-size/type that makes them paint smaller.
// task: investigate if changing css attributes to match body, like font type/size will make the chart draw right.
//end-review
var g_bPreventChartDraw = true;

var g_delayedActions = {
    bPendingWeeklyReport: false
};

function isSpecialPayTestUser() {
    getCurrentTrelloUser();

    if (!g_userTrelloCurrent)
        return false;
    if (g_userTrelloCurrent == "zmandel")
        return true;
    var prop="plus_rand_user_pay_stage1";
    var randUser = localStorage.getItem(prop);
    if (!randUser) {
        randUser = Math.round(Math.random()*1000);
        localStorage.setItem(prop, ""+randUser);
    } else
        randUser = parseInt(randUser, 10);

    return true;
}

var g_waiterLi = CreateWaiter(2, function () {
    if (document.URL.indexOf("/trello.com/" + URLPART_PLUSLICENSE + "/") >= 0)
        return;

    assert(g_userTrelloCurrent); //waiters ensure user and db are loaded at this point
    checkFirstTimeUse(function (bShowedDialog) {
        if (bShowedDialog)
			return;
		checkDownWarning();
        checkNeedsExtensionUpdate(function (bShowedDialog) { //review: should also check regularly for users that never close the trello tab
            if (bShowedDialog)
                return;
            sendExtensionMessage({ method: "completedFirstSync" }, function (response) {
                if (response && response.status == STATUS_OK && response.bCompletedFirstSync) {
                    //setTimeout(checkLi, 2000);
                }
            });
        });
    });
});

function checkNeedsExtensionUpdate(callback) {
    sendExtensionMessage({ method: "getDateUpdateNotificationReceived" }, function (response) {
        if (response && response.status == STATUS_OK) {
            var msNow = Date.now();
            var bShowUpdateNeeded = false;
            var bUrgent = false;
            if (response.msDate > 0 && msNow - response.msDate > 1000 *60 *60 * 8) { //8 hours of pending update. so we dont bother users right away (give a chance for chrome to autoupdate)
                bShowUpdateNeeded = true;
                if (msNow - response.msDate > 1000 * 60 * 60 * 24 * 3) // 3 days old
                    bUrgent = true;
            }

            if (newerStoreVersion(true)) {
                bShowUpdateNeeded = true;
                bUrgent = true;
            }

            callback(bShowUpdateNeeded); //return it, even if later here we dont end up showing a dialog
            if (!bShowUpdateNeeded)
                return;
            
            var msDateLastWarn = parseInt(localStorage.getItem(PROP_LS_MSLAST_IGNORE_EXTUPGRADE) || "0", 10) || 0;
            if (msDateLastWarn > 0) {
                var msDelta = Date.now() - msDateLastWarn;
                var msLimit = (bUrgent ? 1000 * 60 * 40 : 1000 * 60 * 60 * 8); //40 minutes or 8 hours
                if (msDelta < msLimit)
                    bShowUpdateNeeded = false;
            }
            if (bShowUpdateNeeded)
                showExtensionUpgradedError(null, true);
        }
    });
}


function resizeHelp(container) {
    if (!container)
        container = $('#agile_help_container');
    if (container.length == 0)
        return;
    container.height($(window).innerHeight() - 20); //-20 prevents trello from adding a vertical scrollbar
}

function resizeMain() {
    resizeHelp();
    checkTrelloLogo();
}

window.addEventListener('resize', resizeMain);

var g_optIsPlusDisplayDisabled = null; //null means uninitialized. dont use directly. private to below
function isPlusDisplayDisabled() {
    if (g_optIsPlusDisplayDisabled === null)
        g_optIsPlusDisplayDisabled = localStorage.getItem(g_lsKeyDisablePlus); //we want to read it once so its consistent for future calls. user must refresh page if changed

    if (g_optIsPlusDisplayDisabled == "true")
        return true;
    return false;
}

/* isBackendMode
 *
 * REVIEW zig: warning: must be called only if g_bReadGlobalConfig, else caller should wait until later
 * all callers were verified on mar-11-2014
 **/
function isBackendMode(configData) {
	if (configData === undefined) {
		if (!g_bReadGlobalConfig)
			return false;
		configData = g_configData;
	}
	return (configData && configData.spentSpecialUser != null);
}

var g_bReadGlobalConfig = false;

function showAproveGoogleSyncPermissions(callback) {
//the main purpose of showing the dialog is to generate a user action (OK click)
//to ask for new permissions (allowed only during a user action)
//also, it lets us warn the user about what is about to be asked and why.
    var divDialog = $(".agile_dialog_showAproveGSP");
    if (divDialog.length == 0) {
        divDialog = $('\
<dialog class="agile_dialog_showAproveGSP agile_dialog_DefaultStyle"> \
<h2>Plus for Trello - Google Sync permissions</h2><br> \
<p>Your configuration was synced to this device. Plus may ask</p>\
<p>you to approve Google permissions after pressing OK.</p>\
<br>\
<button style="float:right;" id="agile_dialog_GSP_OK">OK</button> \
</dialog>');
		getDialogParent().append(divDialog);
        divDialog = $(".agile_dialog_showAproveGSP");
    }

    divDialog.find("#agile_dialog_GSP_OK").off("click.plusForTrello").on("click.plusForTrello", function (e) {
        divDialog[0].close();
        callback(); 
    });

    showModalDialog(divDialog[0]);
}

function handleProAproval(callback) {

    sendExtensionMessage({ method: "requestProPermission" }, function (response) {
        callback(response.status);
    });
}

//REVIEW: remove dialog
function showApproveProTrialDialog(callback) {
    var divDialog = $(".agile_dialog_showAprovePro");
    if (divDialog.length == 0) {
        //note: tabindex="1" will set focus to the title. this is to prevent focus to other elements that may cause a scroll down of the dialog on small screens.
        divDialog = $('\
<dialog class="agile_dialog_showAprovePro agile_dialog_DefaultStyle"> \
<h2  tabindex="1" id="agile_dialog_showAprovePro_Top" style="outline: none;" align="center">Plus for Trello - "Pro" version</h2>\
<p align="justify">\
<p align="justify">\
By Pressing "Approve" you agree to later purchase the "Pro" license for $9.⁹⁹ a year (*).<br>\
You also accept our <A target="_blank" href="http://www.plusfortrello.com/p/eula-plus-for-trello-end-user-license.html">End-user license agreement</A>.<br>\
<\p>\
<br>\
* We won\'t ask for payment information right now. Plus will remind you later.<br>Amount may vary slightly per country.<br>\
<br>\
<button id="agile_dialog_showAprovePro_OK">Approve</button>&nbsp;\
<button id="agile_dialog_showAprovePro_Cancel">Cancel</button>\
\
<a style="float:right;margin-top:2em;" target="_blank" href="http://www.plusfortrello.com/p/plus-for-trello-pro-version.html">Read more</a>.\
</dialog>');
		getDialogParent().append(divDialog);
        divDialog = $(".agile_dialog_showAprovePro");
    } else {
        $("#agile-scrolldown-alert-pro").hide(); //possible leftover
    }

    function doFinish(bOK) {
        divDialog[0].close();
        callback(bOK);
    }

    divDialog.find("#agile_dialog_showAprovePro_Cancel").off("click.plusForTrello").on("click.plusForTrello", function (e) {
        doFinish(false);
    });

    divDialog.find("#agile_dialog_showAprovePro_OK").off("click.plusForTrello").on("click.plusForTrello", function (e) {
        doFinish(true);
    });

    showModalDialog(divDialog[0]);
    setTimeout(function () {
        if (!elementInViewport($("#agile_dialog_showAprovePro_OK")[0]))
            $("#agile-scrolldown-alert-pro").slideDown();
    }, 200);
}



function configureSsLinks(bParam) {
	if (g_strServiceUrl != null) {
		configureSsLinksWorker(bParam, g_strServiceUrl);
	}
	else {
		chrome.storage.sync.get('serviceUrl', function (obj) {
			var strUrlNew = obj['serviceUrl']; //note: its still called serviceUrl even though now stores a sheet url (used to store a backend url in 2011)
			if (strUrlNew === undefined || strUrlNew == null)
				strUrlNew = ""; //means simple trello
			strUrlNew = strUrlNew.trim();
			var keyUrlLast = "serviceUrlLast";
			chrome.storage.local.get(keyUrlLast, function (obj) { //must be local as we are comparing local configuration. each devices does the same
				var strUrlOld = obj[keyUrlLast];
				if (strUrlOld)
					strUrlOld = strUrlOld.trim();
				else
				    strUrlOld = "";

				function continueConfig() {
				    g_strServiceUrl = strUrlNew;
				    configureSsLinksWorker(bParam, strUrlNew);
				}

				function saveLocalUrl(callback) {
				    var pairUrlOld = {};
				    pairUrlOld[keyUrlLast] = strUrlNew;
				    chrome.storage.local.set(pairUrlOld, function () {
				        if (chrome.runtime.lastError != undefined) {
				            alert("Plus for Trello:"+chrome.runtime.lastError.message);
				            return;
				        }
				        callback();
				    });
				}

				if (strUrlOld != strUrlNew && !g_bDisableSync && !g_optEnterSEByComment.IsEnabled()) {
				    //config changed from another device.
				    
				    if (strUrlOld && strUrlOld != "") {
				        function saveLocalAndRestart() {
				            saveLocalUrl(function () {
				                restartPlus("Refreshing with updated sync setting.");
				            });
				        }

				        var promiseClearStorage = DeleteOrMergeNewSyncSource("Google sync spreadsheet changed. ");
				        promiseClearStorage.then(function (bClearStorage) {
				            g_strServiceUrl = strUrlNew;
				            if (!bClearStorage) {
				                reloadConfigData(strUrlNew, function () {
				                    saveLocalAndRestart();
				                });
				            } else {
				                clearAllStorage(function () {
				                    saveLocalAndRestart();
				                });
				            }
				        });
				    }
				    else {
				        //possibly first time it has a sync url. must ask for extension permissions
                        //review zig multiple calls to continueConfig can be simplified with promises (need to add polyfill for older chromes)
				        showAproveGoogleSyncPermissions(function () {
				            sendExtensionMessage({ method: "requestGoogleSyncPermission" }, function (response) {
				                if (response.status != STATUS_OK) {
				                    alert(response.status);
				                    return;
				                }

				                if (!response.granted) {
				                    //here so user doesnt get stuck in a loop if no longer wants to use google sync
				                    if (confirm("Remove the Google sync url? Only press OK if you want to turn off Google sync.")) {
				                        chrome.storage.sync.set({ "serviceUrl": "" }, function () {
				                            if (chrome.runtime.lastError != undefined) {
				                                alert(chrome.runtime.lastError.message);
				                                return;
				                            }
				                            strUrlNew = "";
				                            saveLocalUrl(function () {
				                                continueConfig();
				                            });
				                        });
				                    }
				                    else {
				                        alert("You may continue using Plus but sync features may not work correctly.");
				                        continueConfig();
				                    }
				                }
				                else {
				                    saveLocalUrl(function () {
				                        continueConfig();
				                    });
				                }
				            });
				        });
				    }
				}
				else {
				    continueConfig();
				}
			});
		});
	}
}

var g_userTrelloCurrent = null;

function getCurrentUserByApi(callback, waitRetry) {
    //https://trello.com/members/me/
	var url = "https://trello.com/1/members/me?fields=username&token=";
    url = url + $.cookie("token"); //trello requires the extra token besides the cookie to prevent accidental errors from extensions
    var xhr = new XMLHttpRequest();
    xhr.withCredentials = true;
    xhr.onreadystatechange = function (e) {
        if (xhr.readyState == 4) {
            handleFinishRequest();

            function handleFinishRequest() {
                var objRet = { status: "unknown error", hasPermission: false };
                var bReturned = false;

                if (xhr.status == 200) {
                    try {
                        objRet.hasPermission = true;
                        objRet.obj = JSON.parse(xhr.responseText);
                        objRet.status = STATUS_OK;
                        bReturned = true;
                        callback(objRet);
                    } catch (ex) {
                        objRet.status = "error: " + ex.message;
                        logException(ex);
                    }
                } else {
                    if (bHandledDeletedOrNoAccess(xhr.status, objRet, "error: permission error or deleted")) { //no permission or deleted
                        null; //avoid lint
                    }
                    else if (xhr.status == 429) { //too many request, reached quota.
						var waitNew = (waitRetry || MsWaitRetry()) * 2;
						if (waitNew < g_msWaitMax) {
                            bReturned = true;
                            setTimeout(function () {
                                getCurrentUserByApi(callback, waitNew);
                            }, waitNew);
                        }
                        else {
                            objRet.status = errFromXhr(xhr);
                        }
                    }
                    else {
                        objRet.status = errFromXhr(xhr);
                    }
                }

                if (!bReturned)
                    callback(objRet);
            }
        }
    };

    xhr.open("GET", url);
    xhr.send();
	}

var g_bMakingUserApiCall = false;

/* getCurrentTrelloUser
 *
 * returns null if user not logged in, or not yet loaded
 * else returns user (without @)
 **/
function getCurrentTrelloUser() {
	var user=getCurrentTrelloUserWorker();
	if (user)
		return user;
	if (g_bMakingUserApiCall)
		return null;
	var header = $('#header');

	if (header.length == 0)
		return null;
	
	g_bMakingUserApiCall = true;
	getCurrentUserByApi(function (response) {
		g_bMakingUserApiCall = false;
		if (response.status == STATUS_OK && response.obj && response.obj.username) {
			g_userTrelloCurrent=response.obj.username;
		} 
	});
	
}

function getCurrentTrelloUserWorker() {
	if (g_userTrelloCurrent != null)
		return g_userTrelloCurrent;
	var header = $('#header');
	
	if (header.length==0)
		return null;

	var elemUserMenu = header.find('[data-testid="header-member-menu-button"]');
	var userElem = null;
	if (elemUserMenu.length == 0) {
		return null;
	}
	elemUserMenu = elemUserMenu.children("div");
	if (elemUserMenu.length==0)
		return null;
	userElem = elemUserMenu.first().attr("title");
	


    //search for the last () pair because the user long name could also have parenthesis
    //this happens a lot in users with non-western names, where trello adds the western name in parenthesis,
    //as in "%$#& &%948# (peter chang) (peterchang)"
	var iParenOpen = userElem.lastIndexOf("(");
	if (iParenOpen < 0)
	    return null;
	userElem = userElem.substring(iParenOpen+1);
	var iParenClose = userElem.lastIndexOf(")");
	if (iParenClose < 0 || iParenClose != userElem.length-1)
	    return null;
	userElem = userElem.substring(0,iParenClose);
	if (userElem.length == 0)
	    return null; //not needed, but might help when trello suddenly changes DOM
	g_userTrelloCurrent = userElem;
	g_waiterLi.Decrease("user");
    //save the user
	chrome.storage.local.get([PROP_TRELLOUSER], function (obj) {
	    var userTrelloLast = (obj[PROP_TRELLOUSER] || null);
	    if (userTrelloLast != userElem) {
	        if (userTrelloLast)
	            sendDesktopNotification("Warning: Trello user changed. Reset Sync from Plus help" , 30000);
	        var pairUser = {};
	        pairUser[PROP_TRELLOUSER] = userElem;
	        chrome.storage.local.set(pairUser, function () {
	            if (chrome.runtime.lastError != undefined)
	                alert("Plus for Trello:" + chrome.runtime.lastError.message);
	        });
	    }
	});
	return userElem;
}

var g_configData = null; //set to non-null when sync is configured


//returns true iff progress set. false when progress was already set
function setWeekSummaryProgress(elem) {
	var strClass = "agile_sync_state";
	var elemTable = elem.children("table"); //review zig cleanup table find all over
	if (elemTable.hasClass(strClass))
		return false;
	elemTable.addClass(strClass);
	elem.attr("title", "Syncing...\nTo see progress hover Chrome's Plus icon ↗");
	return true;
}

function removeWeekSummaryProgress(elem) {
	var strClass = "agile_sync_state";
	elem.children("table").removeClass(strClass);
}

var g_bCreatedPlusHeader = false; //review zig: get rid of this by always creating 'new' icon hidden when #urlUser is created.

function configureSsLinksWorker(b, url, bSkipConfigCache) {
	var userElem = getCurrentTrelloUser();
	if (userElem == null) {
		//try later. most likely user not logged-in 
		setTimeout(function () { configureSsLinksWorker(b, url, bSkipConfigCache); }, 500);
		return;
	}

	var urlUserElem = $('#urlUser');
	if (urlUserElem.length == 0) {
		g_bCreatedPlusHeader = true;
		urlUserElem = $('<span id="urlUser"></span>').css("margin-left", "0px").css("margin-right", "2px");
		urlUserElem.addClass('agile_urlUser');
		urlUserElem.appendTo(b);
		if (!isPlusDisplayDisabled()) {
		    if (g_bNoSE)
		        urlUserElem.hide();
		    getRecentWeeksList().appendTo(b);
		}
	}

	if (!isPlusDisplayDisabled())
	    checkCreateRecentFilter(b);
	urlUserElem.attr("title", g_tipUserTopReport); //reset
	if (url == "") {
		g_configData = null;
		g_bReadGlobalConfig = true;
		onReadGlobalConfig(g_configData, userElem);
		return;
	}

	function part2() {
	    sendExtensionMessage({ method: "getConfigData", userTrello: userElem, urlService: url, bSkipCache: bSkipConfigCache },
            function (respConfig) {
                //note: here we used to check for trello user changed. worked for google sync but not for trello sync. that has now moved
                //to a warning at the time we detect that we change PROP_TRELLOUSER (independent of configData now)
                //respConfig.config is null in the non-spreadsheet-sync case
                if (respConfig.config && respConfig.config.status != STATUS_OK) {
                    setTimeout(function () {
                        //set error text later, to avoid cases when user navigates back/away while on this xhr call.
                        setSyncErrorStatus(urlUserElem, respConfig.config.status);
                    }, 500);
                    return;
                }
                g_configData = respConfig.config; //cached. can be null
                g_bReadGlobalConfig = true;
                onReadGlobalConfig(g_configData, userElem);
            });
	}

//review zig remove g_bCheckedTrelloSyncEnable and just force-enable sync
	if (!g_bCheckedTrelloSyncEnable && !g_bEnableTrelloSync) {
	    g_bCheckedTrelloSyncEnable = true;
	    chrome.storage.sync.set({ "bCheckedTrelloSyncEnable": g_bCheckedTrelloSyncEnable }, function () { });
	    if (!g_bDisableSync) {
			//used to be that spreadsheet sync could be used without trellosync. no more.
	        var pairTrelloSync = {};
	        pairTrelloSync["bEnableTrelloSync"] = true;
	        chrome.storage.sync.set(pairTrelloSync, function () {
	            if (chrome.runtime.lastError != undefined)
	                alert("Plus for Trello:" + chrome.runtime.lastError.message);
                else
	                g_bEnableTrelloSync = true; //note: this is a safe place to init this global. be careful if init code changes.
	            part2();
	        });
	        return; //dont continue and call part2 again
	    }
	}

    part2();

}

var g_bDidInitialIntervalsSetup = false;

function initialIntervalsSetup() {
	g_spentTotal = InfoBoxFactory.makeTotalInfoBox(SPENT,true).hide();
	g_estimationTotal = InfoBoxFactory.makeTotalInfoBox(ESTIMATION, true).hide();
	g_remainingTotal = InfoBoxFactory.makeTotalInfoBox(REMAINING, true).hide();

	doAllUpdates(false);
	chrome.storage.local.get([LOCALPROP_NEEDSHOWHELPPANE], function (obj) {
	    if (obj && obj[LOCALPROP_NEEDSHOWHELPPANE]) {
	        var pair = {};
	        pair[LOCALPROP_NEEDSHOWHELPPANE] = false;
	        chrome.storage.local.set(pair, function () {
	            Help.display();
	        });
	    }
	});
	    

	setInterval(function () {
	    doAllUpdates(true);
	}, UPDATE_STEP);

	if (isPlusDisplayDisabled())
	    return;

	setTimeout(function () {
	    update(false); //first update
	}, 20);

	detectMovedCards();
	var oldLocation = location.href;
	setInterval(function () {
		if (location.href != oldLocation) {
		    oldLocation = location.href;
		    removeAllGrumbleBubbles();
			if (g_tour.bAutoShowTour && getIdBoardFromUrl(oldLocation))
				setTimeout(function () { handleTourStart(false); }, 2500);
			
		    //this might not be strictly needed. for safety clean this cache. it contains jquery elements inside and might confuse code.
		    //needed because trello plays with navigation and we can end up with the cache even though we are on another page (like a board page)
		    if (!bAtTrelloHome()) {
		        g_chartsCache = {};
		        cancelZoomin(null, true); //review zig: find a better way that is not timing-related, like a chrome url-changed notif, or change the href of recent/remaining to handlers
		    }

			setTimeout(function () { doAllUpdates(false); }, 100); //breathe
		}
	}, 400); //check often, its important to prevent a big layout jump (so you can click on boards right away on home without them jumping (used to be more important before new trello 2014-01)

	var msLastDetectedActivity = 0; //zero means nothing detected yet.
	setInterval(function () {
	    if (!g_bEnableTrelloSync)
	        return;
	    //detect trello network activity and initiate sync
	    //in case of multiple trello windows open, note that the extension message will only return the same count to only one of the windows and the rest will receive zero.
	    //its still possible that several consecutive changes cause more than one window to receive a non-zero modification count. its not a big deal as one will fail with busy.
	    //this method also protects us from performance issues with many trello tabs open. it should not use "isTabVisible" because if all tabs are hidden it would not do the sync.
	    sendExtensionMessage(
            { method: "queryTrelloDetectionCount" },
			function (response) {
			    if (response.status != STATUS_OK)
			        return;

			    var msNow = Date.now();
			    if (response.count == 0) {
			        if (msLastDetectedActivity == 0)
			            return;
			        if (msNow - msLastDetectedActivity > 500) { //this prevents many consecutive change detections from triggering many syncs
			            msLastDetectedActivity = 0; //reset
			            doSyncDB(null, true, true, true,true);
			        }
			    }
			    else {
			        msLastDetectedActivity = msNow;
			    }
			});
	}, 1000);

	setInterval(function () {
	    testExtensionAndcommitPendingPlusMessages();
	}, 20000);
}

function onReadGlobalConfig(configData, user) {
	g_bShowBoardMarkers = false;

	if (isBackendMode(configData))
		g_bShowBoardMarkers = true;
	var pair = {};
	pair[PROP_SHOWBOARDMARKERS] = g_bShowBoardMarkers;
	chrome.storage.local.set(pair, function () { });

	//REVIEW zig: need a new way to notify of new service url/spreadsheet archiving (like a row with special meaning)
	startOpenDB(configData, user);
}

function setSyncErrorStatus(urlUser, status, statusLastTrelloSync) {
    removeWeekSummaryProgress(urlUser);
    statusLastTrelloSync = statusLastTrelloSync || STATUS_OK;
    if (statusLastTrelloSync == "busy")
        statusLastTrelloSync = STATUS_OK; //dont bother the user when busy

    if (status == STATUS_OK && statusLastTrelloSync == STATUS_OK) {
        var dateNow = new Date();
        var strTip = g_tipUserTopReport;
        urlUser.children("table").removeClass("agile_plus_header_error");
        if (g_bDisableSync || (g_strServiceUrl == "" && !g_optEnterSEByComment.IsEnabled()))
            strTip = "";
        urlUser.attr("title", strTip);
        return;
    }

    urlUser.children("table").addClass("agile_plus_header_error");

	var statusSet = "";

	if (status != STATUS_OK) {
	    if (status && status.indexOf("error:") >= 0)
	        statusSet = status;
	    else
	        statusSet = "error: " + (status?status: "unknown error");
	}


    if (statusLastTrelloSync != STATUS_OK) {
        if (statusSet != "")
            statusSet = statusSet + "\n";
        statusSet = statusSet+ "sync error: " + statusLastTrelloSync;
    }

    urlUser.attr("title", statusSet);
    console.log(statusSet);
}

var g_intervalSync = null;
var g_dbOpened = false;
var g_idTimeoutReportHover = null;

function startOpenDB(config, user) {
	g_dbOpened = false;
    openPlusDb(
			function (response) {
			    if (response.status != STATUS_OK) {
			        showFatalError(response.status);
			        return;
			    }
			    g_cRowsHistoryLast = response.cRowsTotal; //review: only this caller uses cRowsTotal. that and 'dateMin' could be an option of handleOpenDB
				g_dbOpened = true;
				onDbOpened();
				doWeeklyReport(config, user, true, false, false); //bRefreshCardReport=false because onDbOpened already does so REVIEW zig detect it in a cleaner way
				
				setTimeout(function () {
				    doSyncDB(user, true, false, true);
				}, DELAY_FIRST_SYNC); //wait a little so trello itself can load fully. Not needed but may speed up loading trello page.

				if (g_intervalSync != null) {
					clearInterval(g_intervalSync);
					g_intervalSync = null;
				}

				var urlUser = $("#urlUser");

				//Note: why use javascript handlers instead of css hover?
				//we want to cover a common case that css hover cant do: if a user using the mouse aiming towards the Plus help icon,
				//and she hovers over the weekly report on her way, as soon as she hover out of the report it will shrink and the plus icon will
				//keep moving away. Thus, here we delay the mouseout by 2 seconds so it gives her time to reach the plus icon.
				function handlerIn(event) {
					zoomTopReport(urlUser);
				}

				function handlerOut(event) {
					programUnZoom(urlUser);
				}

				urlUser.unbind("hover");
				urlUser.hover(handlerIn, handlerOut);

				if (!isPlusDisplayDisabled()) {
					g_intervalSync = setInterval(function () { doSyncDB(user, true, false, false); }, g_msSyncPeriod);
					//review zig: these all should be at urlUser creation time to avoid the unbinds and such
					urlUser.unbind("click");
					urlUser.click(function () {
						doSyncDB(user, false, false, false);
					});
				}
			}, { dowStart: DowMapper.getDowStart(), dowDelta: DowMapper.getDowDelta() });
}


function zoomTopReport(userElem) {
	if (g_idTimeoutReportHover) {
		//cancel ongoing. will be recreated on Out
		clearTimeout(g_idTimeoutReportHover);
		g_idTimeoutReportHover = null;
	}
	userElem.children("table").addClass("agile_plus_header_link_zoomhoverActive");
}

function programUnZoom(userElem) {
    if (g_idTimeoutReportHover == null) { //note: !=null can actually happen in rare cases involving switching windows while on the hover timeout wait
		g_idTimeoutReportHover = setTimeout(function () {
		    userElem.children("table").removeClass("agile_plus_header_link_zoomhoverActive");
			g_idTimeoutReportHover = null;
		}, 8000);
	} 
}

var g_cRowsHistoryLast = 0;
var g_bFirstTimeUse = false;
var g_bDisplayPointUnits = false;
var g_bAllowNegativeRemaining = false;
var g_bPreventIncreasedE = false;
var g_bDontWarnParallelTimers = false;
var g_bUserDonated = false; //review: remove
var g_bHidePendingCards = false;
var g_bAlwaysShowSEBar = false;
var g_bHideLessMore = false;
var g_bSyncOutsideTrello = false; //allow sync outside trello
var g_bChangeCardColor = false; //change card background color based on its first label
var g_bHideTour = false;

function checkFirstTimeUse(callback) { //callback(bShowedDialog)
	var keyDateLastSetupCheck = "dateLastSetupCheck";
	var bShowedDialog = false;
	var msDateNow = Date.now();
	var bShowHelp = false;
	var totalDbRowsHistory = 0;
	sendExtensionMessage({ method: "getTotalDBRows" }, function (response) {
	    if (response.status == STATUS_OK) {
	        totalDbRowsHistory = response.cRowsTotal;
	        if (g_msStartPlusUsage === null && response.dateMin) {
	            g_msStartPlusUsage = response.dateMin;
	            chrome.storage.sync.set({ 'msStartPlusUsage': response.dateMin }, function () {
	                if (chrome.runtime.lastError)
	                    console.log(chrome.runtime.lastError.message);
	            });
	        }
	    }
	    chrome.storage.local.get([LOCALPROP_NEEDSHOWPRO, keyDateLastSetupCheck, LOCALPROP_DONTSHOWSYNCWARN], function (obj) {
	        var bSyncDontWarn = obj[LOCALPROP_DONTSHOWSYNCWARN] || false;
	        var bForceShowHelp = false;
	        var msDateLastSetupCheck = obj[keyDateLastSetupCheck];
	        g_bNeedShowPro = obj[LOCALPROP_NEEDSHOWPRO];
	        if (g_bNeedShowPro) {
	            bShowHelp = true;
	            bForceShowHelp = true;
	        }
	        var bSyncNotEnabled = (g_bDisableSync || (g_strServiceUrl == "" && !g_optEnterSEByComment.IsEnabled()));
	        if (bSyncNotEnabled && !g_bDisableSync) { //sync not set up ever
	            if (msDateLastSetupCheck !== undefined) {
	                if (totalDbRowsHistory > 0) {
	                    if (msDateNow - msDateLastSetupCheck > 1000 * 60 * 60 * 24) //nag once a day
	                        bShowHelp = true;
	                }
	            }
	            else {  
	                bShowHelp = true;
	                g_bFirstTimeUse = true;
	            }
	        }

	        function showHelp(msDelay) {
	            setTimeout(function () {
	                hiliteOnce($(".agile-main-plus-help-icon"), 2000);
	            }, msDelay);
	            setTimeout(function () { Help.display(); }, msDelay+500);
	        }

			if (bShowHelp) {
			    if (!bSyncDontWarn || bForceShowHelp) {
			        bShowedDialog = true;
			        var pair = {};
					pair[keyDateLastSetupCheck] = msDateNow;
					pair[LOCALPROP_NEEDSHOWPRO] = "";
					chrome.storage.local.set(pair, function () {
					    showHelp(1500);
					});
				}
			} else if (bSyncNotEnabled && !bSyncDontWarn) {
			    var boardCurrent = getCurrentBoard();
			    if (!boardCurrent || boardCurrent.toLowerCase().indexOf("plus for trello") < 0) { //skip the plus for trello help board
			        var msNow = Date.now();
			        var msLastHiliteNoSync = localStorage.getItem(PROP_LS_MSLASTNOSYNCWARN) || 0;
			        hiliteOnce($(".agile-main-plus-help-icon"), 500, "agile_box_input_hilite_red", 3);
			        if (msNow - msLastHiliteNoSync > 1000 * 60 * 5) { //can be negative
			            bShowedDialog = true;
			            localStorage.setItem(PROP_LS_MSLASTNOSYNCWARN, msNow);
			            setTimeout(function () {
			                showEnableSyncDialog(function (status) {
			                    //STATUS_OK, dontask, cancel (later)
			                    if (status == "dontask") {
			                        var pair = {};
			                        pair[LOCALPROP_DONTSHOWSYNCWARN] = true;
			                        chrome.storage.local.set(pair, function () {
			                        });
			                    }
			                    else if (status == STATUS_OK) {
			                        showHelp(0);
			                    } else if (status == "cancel") {
			                        //later
			                        localStorage.setItem(PROP_LS_MSLASTNOSYNCWARN, Date.now() + 1000 * 60 * 60 * 1);
			                    }
			                });
			            }, 2000);
			            g_msLastHiliteNoSync = msNow;
			        }
			    }
			}
			callback(bShowedDialog);
		});
	});
}

function updateCRowsTotalState(cRowsTotal, config, user) {
    var cRowsOld = g_cRowsHistoryLast;
    g_cRowsHistoryLast = cRowsTotal;
    var bNewRows = (cRowsOld != g_cRowsHistoryLast);
    //review zig: the hack below causes the side-effect that users not using S/E will have cRowsTotal==0 and make the empty
    //home charts refresh more than once.
    if (bNewRows || cRowsTotal == 0) { //cRowsTotal==0 is a hack so the "first sync" status text gets updated after a first sync with no rows
        g_bForceUpdate = true;
        g_seCardCur = null; //mark as uninitialized. will be set on the refresh below
        if (!isTabVisible())
            g_delayedActions.bPendingWeeklyReport = true;
        else
            doWeeklyReport(config, user, false, true);
    }
}

function onDbOpened() {
	if (!g_bDidInitialIntervalsSetup) {
		initialIntervalsSetup(); //also calls doAllUpdates
		g_bDidInitialIntervalsSetup = true;
		g_waiterLi.Decrease("dbOpened");
	}

	if (g_portBackground == null) {
	    g_portBackground = chrome.runtime.connect({ name: "registerForChanges" });
	    g_portBackground.onMessage.addListener(function (msg) {
	        var urlUser = $('#urlUser');
	        if (msg.status)
	            setSyncErrorStatus(urlUser, msg.status, msg.statusLastTrelloSync);

	        if (msg.status != STATUS_OK)
	            return;
           
	        if (msg.event == EVENTS.FIRST_SYNC_RUNNING) {
	            urlUser.html(buildDailyTable("<tr><td>Running</td></tr><tr><td>first sync</td></tr>"));
	            setWeekSummaryProgress(urlUser);
	            setTimeout(function () {
	                if (g_bNeedStartTourBubble)
	                    showTourBubble();
	            }, 1000);
	        }
	        else if (msg.event == EVENTS.NEW_ROWS) {
	            //this avoids refreshing the UI if no rows were added since last time
	            sendExtensionMessage({ method: "getTotalDBRows" },
                    function (response) {
                        
                        if (response.status != STATUS_OK)
                            return;
                        var user = getCurrentTrelloUser();

                        if (g_bReadGlobalConfig && user) {
                            updateCRowsTotalState(response.cRowsTotal, g_configData, user);
                        }
                    });
	        } else if (msg.event == EVENTS.DB_CHANGED) {
	            checkCardRecurringCheckbox();
	           //EVENTS.DB_CHANGED not handled for home/daily reports as we care about new rows only (otherwise it gets complicated to prevent double refreshing on new rows and other changes
	           //review zig" ideally refresh on this only if NEW_ROWS was not just received. then chart labels will rename when renamed in trello and so on (no new rows cases)
	           //important so we update card report then changing [R] status
				if (!msg.bNewHistoryRows) { //NEW_ROWS is already handled above
	               var user = getCurrentTrelloUser();
	               if (user) {
	                   g_bForceUpdate = true;
	                   if (!isTabVisible())
	                       g_delayedActions.bPendingWeeklyReport = true;
	                   else
	                       doWeeklyReport(g_configData, user, false, true);
	               }
	           }
	        } else if (msg.event == EVENTS.EXTENSION_RESTARTING) {
	            setTimeout(function () {
	                location.reload();
	            }, 1500);
	        }
	    });
	}
}

//REVIEW zig: workarround for Trello auth "dsc" issue
function AuthAndsendExtensionMessage(obj, responseParam, bRethrow) {
    setTrelloAuth(function () {
        sendExtensionMessage(obj, responseParam, bRethrow);
    });
}

function doSyncDB(userUnusedParam, bFromAuto, bOnlyTrelloSync, bRetry, bForce) {
    if (Help.isVisible() || isPlusDisplayDisabled())
        return;
    bOnlyTrelloSync = bOnlyTrelloSync || false;
    if (bRetry === undefined)
        bRetry = true;
    var config = g_configData;


    var urlUser = null;
    var dateNow = new Date();
    var bSetStatus = false;
    var cRetries = (bRetry? 3 : 1); //try this many times to start google sync
    var bDidTrelloSync=false;
    var bEnterSEByComments = g_optEnterSEByComment.IsEnabled();
    var tokenTrello = $.cookie("token");

		sendExtensionMessage(
			{ method: "queryTrelloToken" },
			function (response) {
					tokenTrello = response.cookie_value;
					if (bFromAuto && !bForce) {
							if (!isTabVisible()) {
								return;
							}
					}
					worker();
			});

    function worker() {
        if (g_cRetryingSync > 0)
            return;
        urlUser = $("#urlUser"); //set/refresh
        if (!setWeekSummaryProgress(urlUser))
            return;


        if (cRetries == 0) {
            //too busy. just pretent it succeeded
            setSyncErrorStatus(urlUser, STATUS_OK);
            return;
        }


        if (g_bDisableSync) {
            setSyncErrorStatus(urlUser, bFromAuto? STATUS_OK : "Sync is off. Enable it from Plus help.");
            return;
        }


        cRetries--;
        //when bEnterSEByComments, we want to go through google sync, which will route it to trello sync and take care of uptading history rows related stuff
        //review zig: this option will soon be imposible to configure in help, but legacy users could have it (thou we force-upgrade them on open except the few that declined it back when it was optional)
        if (g_bEnableTrelloSync && !bDidTrelloSync && !bEnterSEByComments) {
            AuthAndsendExtensionMessage({ method: "trelloSyncBoards", tokenTrello: tokenTrello, bUserInitiated: !bFromAuto },
            function (response) {
                var statusSync = response.status;
                if (response.status != STATUS_OK) {
                    if (statusSync == "busy") {
                        doRetry();
                        return;
                    }
                    bSetStatus = true;
                    setSyncErrorStatus(urlUser, response.status);
                }
                else {
                    bDidTrelloSync = true;
                }

                if (bOnlyTrelloSync && !bSetStatus) { //when status is set, we do want to continue to google sync
                    setSyncErrorStatus(urlUser, response.status);
                    return;
                }
                doGoogleSync();
            });
        }
        else
            doGoogleSync();
    }

    function doRetry() {
        if (!bSetStatus)
            setSyncErrorStatus(urlUser, STATUS_OK);
        g_cRetryingSync++;
        setTimeout(function () {
            g_cRetryingSync--;
            worker();
        }, 3000);
    }

    function doGoogleSync() {
        if ((!config || bOnlyTrelloSync) && !bEnterSEByComments) {
            if (!bSetStatus) {
                bSetStatus = true;
                setSyncErrorStatus(urlUser, STATUS_OK);
            }
            return;
        }
        bSetStatus = false;
        AuthAndsendExtensionMessage({ method: "syncDB", config: config, bUserInitiated: !bFromAuto, tokenTrello: tokenTrello },
            function (response) {
                statusSync = response.status;
                if (statusSync == "busy")
                    doRetry();
                //no need to call setSyncErrorStatus because a broadcastMessage will reach back to us and status will be set there
            });
    }
}

function doWeeklyReport(config, user, bUpdateErrorState, bReuseCharts, bRefreshCardReport) {
    if (!user)
        return; //safety in case trello DOM structure breaks

    g_delayedActions.bPendingWeeklyReport = false;
    var topbarElem = $("#agile_help_buttons_container");
    if (isPlusDisplayDisabled()) {
        configureSsLinksWorkerPostOauth(null, topbarElem, user, false);
        return;
    }

    if (bUpdateErrorState === undefined)
        bUpdateErrorState = true;

    if (bRefreshCardReport === undefined)
        bRefreshCardReport = true;
    
    bReuseCharts = bReuseCharts || false;
    if (bRefreshCardReport)
        refreshCardTableStats(); //review zig: register for refresh notifications instead of hardcoding here all these. also this causes two reports when card page refreshed
	var dateToday = new Date();
	var weekCur = getCurrentWeekNum();
	var dowToday = dateToday.getDay();
	var sToday = 0;
	if (weekCur != getCurrentWeekNum(dateToday))
		sToday = null; //means we are not tracking "today" because the week selection is not the current week.

	var sql = "select H.idCard, H.user,H.spent,H.est,H.comment,C.name as nameCard, strftime('%w',H.date,'unixepoch','localtime') as dow, H.date, B.name as nameBoard,B.idBoard, H.eType from HISTORY H JOIN BOARDS B ON H.idBoard=B.idBoard JOIN CARDS C ON H.idCard=C.idCard AND C.bDeleted=0 WHERE week=? ";
	var values = [weekCur];
	if (g_rgKeywordsHome.length > 0) {
	    
	    sql += " AND keyword IN (";
	    var bFirst = true;
	    g_rgKeywordsHome.forEach(function (kw) {
	        values.push(kw);
	        if (bFirst) {
	            sql += "?";
	            bFirst = false;
	        }
	        else
	            sql += ",?";
	    });
	    sql += ")";
	}
	sql += " order by user asc, date desc, H.rowid desc";
	g_cRowsWeekByUser = 0;
	getSQLReport(sql, values,
		function (response2) {
			var curUser = getCurrentTrelloUser();
			//transform array so it has all week days
			var i = 0;
			var ordered = [];
			var drilldownData = [];
			var iCurrentUserOrder = -1; //might not be there
			var row = null;
			if (response2.status == STATUS_OK) {
				for (; i < response2.rows.length; i++) {
					row = response2.rows[i];
					if (row.user == null)
						continue; //table empty
					if (ordered.length == 0 || ordered[ordered.length - 1][0] != row.user) { //note must be ordered by user
						ordered.push([row.user, 0, 0, 0, 0, 0, 0, 0]);
						drilldownData.push([row.user, [], [], [], [], [], [], []]);
						if (iCurrentUserOrder < 0 && row.user == curUser)
							iCurrentUserOrder = ordered.length - 1;
					}
					var rowOrder = ordered[ordered.length - 1];
					var drillOrder = drilldownData[ordered.length - 1];
					var iCol = DowMapper.posWeekFromDow(parseInt(row.dow, 10)) + 1; //this dow is a string (unlike most other code)
					rowOrder[iCol] += row.spent;
					drillOrder[iCol].push(row);
				}

				for (i = 0; i < ordered.length; i++) {
					row = ordered[i];
					var c = 1;
					for (; c < row.length; c++)
						row[c] = parseFixedFloat(row[c]); //reformat so charts dont have to
				}
			}
			g_cRowsWeekByUser = ordered.length; //used by tour
			var dataWeek = { config: config, status: response2.status, table: ordered, drilldownData: drilldownData, sWeek: 0, bReuseCharts: bReuseCharts };
			dataWeek.weekSummary = { rows: [] };
			if (iCurrentUserOrder >= 0) {
				var sumDays = 0;
				var k = 1;
				var strDays = "";
				var rowUser = ordered[iCurrentUserOrder];
				for (; k < rowUser.length; k++) {
					if (rowUser[k] == 0)
						continue;
					sumDays += rowUser[k];
					var dow = DowMapper.dowFromPosWeek(k - 1);
					if (sToday !== null && dow == dowToday)
					    sToday += rowUser[k];
					dataWeek.weekSummary.rows.push({ day: getWeekdayName(dow), total: rowUser[k] });
				}

				dataWeek.sWeek = sumDays;
			}
			if (sToday === null)
				dataWeek.sToday = null;
			else
				dataWeek.sToday = parseFixedFloat(sToday);
			addWeekDataByBoard(dataWeek, weekCur, response2, function () {
				useWeeklyReportData(dataWeek, topbarElem, user, bUpdateErrorState);
			});
		});
}

function addWeekDataByBoard(dataWeek, weekCur, response, callback) {
	//note: this used to be a separate sql report, now it reuses passed response
	var i = 0;
	var ordered = [];
	var mapUsers = {};
	var users = [];
	var colUserLast = 0; //column for next new user
	var drilldownData = [];
				
	if (response.status == STATUS_OK) {
		//dataWeek is not ordered like we want, do so first
		var rows = response.rows;
		rows.sort(function (a, b) {
			var ret = a.nameBoard.localeCompare(b.nameBoard);
			if (ret != 0)
				return ret;
			ret = a.user.localeCompare(b.user);
			if (ret != 0)
				return ret;
			ret = a.date - b.date;
			return ret;
		});

	    //transform array
		var rowOrder = null;
		if (response.status == STATUS_OK) {
			for (; i < rows.length; i++) {
				var row = rows[i];
				if (row.user == null)
					continue; //review zig when does this happen, no data? (sql response status row)
				var columnUser = mapUsers[row.user];
				if (columnUser === undefined) {
				    colUserLast++;
					columnUser = colUserLast;
					mapUsers[row.user] = columnUser;
					users.push(row.user);
				}

				if (ordered.length == 0 || ordered[ordered.length - 1][0] != row.nameBoard) {
					ordered.push([row.nameBoard]);
					drilldownData.push([row.nameBoard]);
				}
				rowOrder = ordered[ordered.length - 1]; //last one is current one
				var drillOrder = drilldownData[ordered.length - 1];
				while (rowOrder.length != colUserLast + 1) {
					rowOrder.push(0);
					drillOrder.push([]);
				}
				rowOrder[columnUser] += row.spent;
				drillOrder[columnUser].push(row);
			}

			for (i = 0; i < ordered.length; i++) {
				rowOrder = ordered[i];
				var iCol = 1;
				for (; iCol < rowOrder.length; iCol++)
					rowOrder[iCol] = parseFixedFloat(rowOrder[iCol]); //format it here so charts dont have to
				while (rowOrder.length != colUserLast + 1)
					rowOrder.push(0);
			}
		}
	}
	dataWeek.byBoard = { table: ordered, status: response.status, users: users, drilldownData: drilldownData, bReuseCharts: dataWeek.bReuseCharts };
	callback();
}

function useWeeklyReportData(dataWeek, topbarElem, user, bUpdateErrorState) {
	configureSsLinksWorkerPostOauth(dataWeek, topbarElem, user, bUpdateErrorState);
	//setTimeout(function () { insertFrontpageCharts(dataWeek, user); }, 1000); //to test the home page we add a delay
	insertFrontpageCharts(dataWeek, user);
}


function insertHistoryRowFromUI(rows, callback) {
	sendExtensionMessage({ method: "insertHistoryRowFromUI", rows: rows }, function (response) {
		if (response.status != STATUS_OK)
			alert("Insert error: " + response.status);
		
		callback(response.status);
	});
}

function getSQLReport(sql, values, callback) {
	getSQLReportShared(sql, values, callback, function onError(status) {
		setSyncErrorStatus($('#urlUser'), status);
	});
}


function fillRecentWeeksList(combo) {
    var date = new Date();
    const yearCur = date.getFullYear();
    var daysDelta = DowMapper.posWeekFromDow(date.getDay());
    var i = 0;
    combo.empty();
    for (; i < 15; i++) {
        date.setDate(date.getDate() - daysDelta);
        var text = getCurrentWeekNum(date);
        var title = date.toLocaleDateString();
        date.setDate(date.getDate() + 6);
        title = title + " - " + date.toLocaleDateString();
        var parts = text.split("-W");
        var year = parseInt(parts[0], 10);
        var textPretty = text;
        if (year==yearCur)
            textPretty = "W" + parts[1];
        combo.append($(new Option(textPretty, text)).addClass('agile_weeks_combo_element').attr("title", title));
        daysDelta = 13; //7+6
    }

    if (g_weekNumUse != null)
        combo.val(g_weekNumUse);
    adjustSelectWidthToContent(combo);
}

function adjustSelectWidthToContent(combo) {
    var val = combo[0].options[combo[0].selectedIndex || 0].innerHTML;
    var cch = val.length;
    if (cch > 4)
        combo.css("width", "auto");
    else
        combo.css("width", cch + "em");
}

function getRecentWeeksList() {
    var combo = $('<select id="spentRecentWeeks" />').addClass("agile_weeks_combo agile_boldfont");
	combo.css('cursor', 'pointer');
	combo.attr("title", "click to change the week being viewed.");
	if (g_bNoSE)
	    combo.hide();
	fillRecentWeeksList(combo);
	combo.change(function () {
		if (!g_bReadGlobalConfig) {
			combo[0].selectedIndex = 0;
			return false;
		}
		adjustSelectWidthToContent(combo);
		combo.attr("title", "");
		var val = ($(this).val());
		g_weekNumUse = val;
		var userCur = getCurrentTrelloUser();
		var config = g_configData;
		if (userCur) { //review zig move up
			doWeeklyReport(config, userCur, true, true);
		}
		if (!bAtTrelloHome()) {
		    sendDesktopNotification("This week selector controls the view on trello.com", 7000);
		}
		return true;
	});

	return combo;
}

function getKeywordsViewList() {
    var combo = $("#agile_globalkeywordlist");

    if (combo.length == 0 && g_bheader.comboSEView)
        combo = g_bheader.comboSEView;

    if (combo.length == 0) {
        combo = $('<select id="agile_globalkeywordlist"/>').addClass("agile_weeks_combo"); //review: rename agile_weeks_combo to generic
        combo.css('cursor', 'pointer');
        combo.attr("title", "Plus - Click to change the S/E view");
    }
    combo.empty();
    var rgItems = [];
    var bMultipleKeywords = false;
    var bUseKeywords = g_optEnterSEByComment.IsEnabled();
    if (bUseKeywords || g_bDisableSync) { //if g_bDisableSync we want to at least show something, so show default keywords
        rgItems = g_optEnterSEByComment.getAllKeywordsExceptLegacy();
        bMultipleKeywords = (rgItems.length>1);
    }

    if (g_bAcceptSFT || g_bAcceptPFTLegacy) {
        if (bUseKeywords)
            rgItems.push({ str: "Keywords only", val: VAL_COMBOVIEWKW_KWONLY, title: "S/E only from keywords (exclude card title s/e)" });
        rgItems.push({ str: "Title S/E", val: VAL_COMBOVIEWKW_CARDTITLES, title: "S/E only from card titles" });
    }

    if (rgItems.length >= 1) {
        rgItems.unshift({ str: "Board Dimensions", val: VAL_COMBOVIEWKW_HEADER, disabled: true });
        rgItems.push({ str: '\u00A0'+"All S/E", val: VAL_COMBOVIEWKW_ALL });
        rgItems.push({ str: "───────────────", val: VAL_COMBOVIEWKW_SEP, disabled: true });
        if (bMultipleKeywords)
            rgItems.push({ str: "↗ Report by keyword", val: VAL_COMBOVIEWKW_REPORTKW });
        rgItems.push({ str:  "↗ Dimensions help", val: VAL_COMBOVIEWKW_HELP });
        fillComboKeywords(combo, rgItems, g_dimension, "agile_weeks_combo_element", '\u00A0\u00A0\u00A0', true);
        if (combo.val() != g_dimension) { //keyword no longer in use, default to all
            combo.val(VAL_COMBOVIEWKW_ALL);
            doComboChange();
        }
    } else {
        combo.hide();
    }

    if (g_bNoSE)
        combo.hide();

    combo.change(doComboChange);

    function doComboChange() {
        combo.attr("title", "");
        var val = combo.val();
        if (val == VAL_COMBOVIEWKW_HELP || val == VAL_COMBOVIEWKW_REPORTKW) {
            combo.val(g_dimension);
            if (val == VAL_COMBOVIEWKW_REPORTKW) {
                var idBoardCur = getIdBoardFromUrl(document.URL);
                if (idBoardCur) {
                    var url = chrome.extension.getURL("report.html") + "?chartView=s&groupBy=keyword&orderBy=date&sortList=%5B%5B%22Keyword%22%2C0%5D%5D&idBoard=" + encodeURIComponent(idBoardCur);
                    window.open(url, '_blank');
                }
            }
            else if (val == VAL_COMBOVIEWKW_HELP) {
                window.open("http://www.plusfortrello.com/p/board-dimensions.html", '_blank');
            }
            return true;
        } else {
            var pair = {};
            pair[SYNCPROP_BOARD_DIMENSION] = val;
            chrome.storage.sync.set(pair, function () {
                if (chrome.runtime.lastError) {
                    alert(chrome.runtime.lastError.message);
                    combo.val(g_dimension);
                    return;
                }
                g_dimension = val;
                g_bForceUpdate = true;
                g_bSkipUpdateSsLinks = true; //due to legacy hehaviour, changing S/E totals in board would cause a sync
                update(true);
            });
        }
        return true;
    }

    return combo;
}

function getAllUsersList() {
	var combo = $('<select id="spentAllUsers" />').addClass("agile_users_combo");
	chrome.storage.local.get("allUsersSpent", function (obj) {
		var users = obj["allUsersSpent"];
		combo.css('cursor', 'pointer');
		combo.append($(new Option("Users", "")).addClass('agile_users_combo_element agile_users_combo_element_disabled').attr("disabled", "disabled"));
		if (users !== undefined) {
			var i = 0;
			for (i = 0; i < users.length; i++) {
				combo.append($(new Option(users[i][0], users[i][1])).addClass('agile_users_combo_element'));
			}
		}
		combo[0].selectedIndex = 0; //force it since its disabled
		combo.change(function () {
			var url = ($(this).val());
			$(this)[0].selectedIndex = 0;
			if (url != "") {
				url = "https://docs.google.com/spreadsheet/ccc?key=" + url;
				window.open(url, '_blank');
			}
		});
	});
	return combo;
}
function buildDailyTable(content) {
    return "<table class='agile_urlUserTable agile_plus_header_link_zoomhover'><tbody>" + content + "</tbody></table>";
}

function configureSsLinksWorkerPostOauth(resp, b, user, bUpdateErrorState) {
    //resp can be null in case plus display changes are is disabled from plus help
	if (bUpdateErrorState === undefined)
		bUpdateErrorState = true;
	var urlUserElem = $('#urlUser');
	if (resp && resp.status != STATUS_OK) {
		if (bUpdateErrorState) {
			setTimeout(function () {
				//set error text later, to avoid cases when user navigates back/away while on this xhr call.
				setSyncErrorStatus(urlUserElem, resp.status);
			}, 100);
		}
		return;
	}

	var nameSsLink = "";
	if (bUpdateErrorState)
		setSyncErrorStatus(urlUserElem, resp.status);

	if (!resp) {
	    nameSsLink = "<tr><td>Plus disabled</td></tr>";
	}
	else {
	    processUserSENotifications(resp.sToday, resp.sWeek);
	    if (resp.weekSummary.rows.length == 0)
	        nameSsLink = "<tr><td>Ø</td></tr>";
	    else {
	        var row1 = "";
	        var row2 = "";
	        resp.weekSummary.rows.forEach(function (row) {
	            row1 = row1 + "<td>" + row.day + "</td>";
	            row2 = row2 + "<td>" + parseFixedFloat(row.total, false, true) + "</td>";
	        });
	        nameSsLink = "<tr>" + row1 + "</tr>" + "<tr>" + row2 + "</tr>";
	    }
	}
	urlUserElem.html(buildDailyTable(nameSsLink));

	b.show();
    checkTrelloLogo();
	insertPlusFeed(g_bCreatedPlusHeader);
	g_bCreatedPlusHeader = false;
}

function checkTrelloLogo() {
	return; //review: since 2019-03-13 trello no longer exposes a way to find the logo.
	//here we used to prevent the trello logo from intersecting the Plus header on small windows.
	
    var trelloLogo = $(".header-logo-default");
    var topbarElem = $("#agile_help_buttons_container");

    if (trelloLogo.length == 0 || !trelloLogo.is(":visible"))
        trelloLogo = $(".header-logo-pride");

    if (trelloLogo.length == 0 || topbarElem.length == 0) {
        setTimeout(checkTrelloLogo, 300);
        return;
    }


    var rectLogo = trelloLogo[0].getBoundingClientRect();
    var rectBar = topbarElem[0].getBoundingClientRect();
    if (rectLogo.right>rectBar.left) {
        var parentLogo = trelloLogo.parent();
        parentLogo.hide();
        parentLogo.css("float", "right");
        parentLogo.css("left", "auto");
        parentLogo.css("margin-left", "-100px");
        parentLogo.css("margin-top", "-5px");
        parentLogo.insertAfter(topbarElem);
        parentLogo.show();
    }
}


function updateSsLinks() {
	doSyncDB(getCurrentTrelloUser(), true, false, true);
}


function setupBurnDown(bShowHeaderStuff, bShowSumFilter) {
	var board = getCurrentBoard();
	if (board == null || g_remainingTotal === undefined)
	    return false;

	if (!bShowHeaderStuff)
	    bShowSumFilter=false;
	var burndownLink = $(".agile_plus_burndown_link");
	var reportLink = $(".agile_plus_report_link");
	var spanFilter = $(".agile_plus_filter_span");

	var idBoard = getIdBoardFromUrl(document.URL);
	if (idBoard == null)
		return false;

	if (burndownLink.length == 0) {
	    burndownLink = $("<img title='Plus - Board Burndown & Projections' style='display:none;'>").attr("src", chrome.extension.getURL("images/chart-sm.png")).addClass("agile_img_boardheader agile_plus_burndown_link");
	    burndownLink.insertAfter(g_spentTotal);
	    burndownLink.click(function () {
	        var idBoardCur = getIdBoardFromUrl(document.URL);
	        if (idBoardCur == null)
	            return false;
	        var url = chrome.extension.getURL("dashboard.html") + "?idBoard=" + encodeURIComponent(idBoardCur);
	        window.open(url, '_blank');
	        return false;
	    });

	    reportLink = $("<img title='Plus - Board Reports & Charts' style='display:none;'>").attr("src", chrome.extension.getURL("images/report-sm.png")).addClass("agile_img_boardheader agile_plus_report_link");
	    reportLink.insertAfter(burndownLink);
	    reportLink.click(function () {
	        var idBoardCur = getIdBoardFromUrl(document.URL);
	        if (idBoardCur == null)
	            return false;
	        var url = chrome.extension.getURL("report.html") + "?groupBy=idCardH&idBoard=" + encodeURIComponent(idBoardCur);
	        window.open(url, '_blank');
	        return false;
	    });

	    spanFilter = $('<span class="agile_plus_filter_span" style="float:right;display:none;">');
	    var filterSumCheck = $('<input  type="checkbox" value="checked" id="agile_plus_filter_check"  style="margin-bottom:0px;margin-top:0.55em;float:right;min-height:0.5em;line-height:0.5em;height:1em;margin-bottom:0px;cursor:pointer;">');
	    var labelSumCheck = $('<label for="agile_plus_filter_check" style="float:right;padding-right:0.4em;margin-top:0.40em;margin-bottom:0px;font-weight:normal;cursor:pointer;">').text("Sum filtered");
	    spanFilter.append(labelSumCheck).append(filterSumCheck);
	    spanFilter.insertAfter(reportLink);
	    var keyPropbSumFilteredCardsOnly = "bSumFilteredCardsOnly";

	    filterSumCheck[0].checked = g_bCheckedbSumFiltered;

	    filterSumCheck.click(function () {
	        filterSumCheck[0].disabled = true;
	        g_bCheckedbSumFiltered = filterSumCheck.is(':checked');
	        var pairbCheckedbSumFiltered = {};
	        pairbCheckedbSumFiltered[keyPropbSumFilteredCardsOnly] = g_bCheckedbSumFiltered;
	        chrome.storage.sync.set(pairbCheckedbSumFiltered, function () {

	            function finished() {
	                filterSumCheck[0].disabled = false;
	            }

	            if (chrome.runtime.lastError !== undefined) {
	                g_bCheckedbSumFiltered = !g_bCheckedbSumFiltered; //poor man recovery
	                filterSumCheck[0].checked = g_bCheckedbSumFiltered;
	                finished();
	                return;
	            }
	            updateCards(getCurrentBoard(), finished, true);
	        });
	    });
	}

    if (!g_bNoSE && !g_bNoEst)
	    burndownLink.show();
	reportLink.show();

	if (!g_bheader.comboSEView) {
	    g_bheader.comboSEView = getKeywordsViewList();
	    g_bheader.comboSEView.insertAfter(reportLink);
	}

	if (bShowSumFilter)
	    spanFilter.show();
	else
	    spanFilter.hide();

	return true;
}


function processUserSENotifications(sToday,sWeek) {
	if (sToday === null)
		return;
	try {
		var factor = 10;
		if (sWeek > 100)
			factor = 1;
		else if (sWeek < 10)
			factor = 100;
		var sBadge = Math.round(sWeek * factor) / factor;
		if (sBadge >= 1000)
		    sBadge = "+999";

		if (sBadge == 0)
		    sBadge = ""; //dont show badge when zero spent, its annoying to those not using S/E (even thou it can be turned off from preferences)
		sendExtensionMessage({ method: "setBadgeData", text: "" + sBadge, weeknum: getCurrentWeekNum(new Date()) });
		var dtToday = new Date();
		var key = "spentLastNotified";
		var strToday = makeDateCustomString(dtToday);
		chrome.storage.local.get(key, function (obj) {
			var value = obj[key];
			if (value != null) {
				if (strToday == value.strToday && sToday == value.sToday)
					return;
			}
			var pair = {};
			pair[key] = { strToday: strToday, sToday: sToday };
			chrome.storage.local.set(pair, function (obj) { });
			if (sToday!=0 && !g_bDontShowSpentPopups)
			    sendDesktopNotification("Spent today: " + sToday, 3000, "spentTodayTotal");
		});

	} catch (e) {
		//nothing
	}
}

function bAtTrelloHome() {
    var url = document.URL.toLowerCase();
    var user = g_userTrelloCurrent.toLowerCase();
    if (url.lastIndexOf("/#") == url.length - 2)
        url = url.substring(0, url.length - 2);

    if (url != "https://trello.com/" && url != "https://trello.com/u/"+user+"/boards")
        return false;
    return true;
}

function insertFrontpageCharts(dataWeek, user) {
    if (g_bNoSE)
        return;
	var mainDiv = $("#content");
	insertFrontpageChartsWorker(mainDiv, dataWeek, user);
}

function insertFrontpageChartsWorker(mainDiv, dataWeek, user) {
	//reset. Note case when navigating from board to home through trello logo, wont cause navigation
    if (!bAtTrelloHome()) {
		g_chartsCache = {};
		return false;
	}

    if (!dataWeek.bReuseCharts)
        g_chartsCache = {};

    var divInsertAfter = $(".boards-page-board-section");
    var divPrepend = $(".home-container"); //new trello home april 2018 see bAtNewTrelloHome

    if (divInsertAfter.length == 0) {
        if (divPrepend.length == 0) {
            setTimeout(function () { insertFrontpageChartsWorker(mainDiv, dataWeek, user); }, 50); //wait until trello loads that div
            return false;
        }
    }

	var classContainer = "agile_spent_items_container";
	var divSpentItems = $("." + classContainer);
	var idChartModuleSpentWeekUsers = "spent_week_users";
	var idChartModuleSpentWeekBoard = "spent_week_board";
	var idRecentModule = "spent_recent_cards";
	var idPendingModule = "spent_pending_cards";
	var strPostfixStatus = "_status";

	if (divSpentItems.length == 0) {
	    var seHeader = $('<p id="headerSEActivities" class="agile_arrow_title"><b title="Click to open or close.\nUse the week selector (top-right of this page) to change the week." style="margin-left:17px;">Plus S/E</b></p>');
	    divSpentItems = $('<div></div>').addClass(classContainer);
        if (divInsertAfter.length>0)
	        divInsertAfter = divInsertAfter.eq(0);
		
	    divSpentItems.css("opacity", 0);
		divSpentItems.hide();
		var seContainer = $('<div id="agile_seContainer" class="agile_arrow_closed agile_arrow_container">');
		seContainer.append(seHeader);
		var waiter = CreateWaiter(4, function () { //review promise
		    seContainer.append(divSpentItems);
		    if (divPrepend.length > 0) {
		        seHeader.addClass("seContainerNewTrello");
		        divPrepend.parent().prepend(seContainer);
		        divPrepend.children(".home-sticky-container").css("margin-top", "-"+seContainer.height().toString()+"px");
		        }
		    else {
		        assert(divInsertAfter.length > 0);
		        seContainer.insertAfter(divInsertAfter); 
		    }

		    function refreshAll() {
                //all these is so we can have the chart drawn and height calculated before we start the slide
		        divSpentItems.css("opacity", 0);
		        divSpentItems.css("height", 0);
		        divSpentItems.show();
		        if (g_bPreventChartDraw)
		            g_bPreventChartDraw = false;

		        redrawAllCharts();
		        
		        divSpentItems.hide();
		        divSpentItems.css("height", "");
		    }

		    seHeader.click(function () {
		        var bOpened = (seContainer.hasClass("agile_arrow_opened"));
		        g_bShowHomePlusSections = !bOpened;
		        if (!bOpened) {
		            refreshAll();
		        }
		        handleSectionSlide(seContainer, divSpentItems);
		        chrome.storage.sync.set({ "bClosePlusHomeSection": !g_bShowHomePlusSections }, function () {
		        //ignore chrome.runtime.lastError
		        });
		    });

		    //pretend charts are visible so we can preload charts. this speeds up the first time we drop down the header
		    var bShowSaved = g_bShowHomePlusSections;
		    g_bShowHomePlusSections = true;
		    refreshAll();
		    g_bShowHomePlusSections = bShowSaved;
		    if (g_bShowHomePlusSections) {
		            handleSectionSlide(seContainer, divSpentItems);
		    }
		});

		g_bPreventChartDraw = true;
		var bNewTrelloHome = bAtNewTrelloHome();
		var tableSpentItems = $('<table id="idTableSpentItemsHome" border="0" cellpadding="0" cellspacing="0"></table>');
		var row1 = $('<tr></tr>');
		var row2 = $('<tr></tr>');
		tableSpentItems.append(row1);
		tableSpentItems.append(row2);
		if (bNewTrelloHome)
		    tableSpentItems.find("tbody").addClass("newTrelloHomeBackground");
		divSpentItems.append(tableSpentItems);
		var cellA = $('<td />');
		var cellB = $('<td />');
		row1.append(cellA);
		row1.append(cellB);
		var cellC = $('<td />');
		var cellD = $('<td />');
		row2.append(cellC);
		row2.append(cellD);
		waiter.SetWaiting(true);
		var divItemDashboardRecent = addModuleSection(true, false, cellA, "", idRecentModule, true, "left", false);
		divItemDashboardRecent.addClass("agile_spent_item_title  agile_spent_item_combo").attr("title", "Your recent S/E.\n\nTip: control+click items to open in a new tab");
		var divItemDashboardUnspent = addModuleSection(true, false, cellA, "", idPendingModule, true, "left", false);
		divItemDashboardUnspent.addClass("agile_spent_item_combo").attr("title", "Your remaining S/E.\n\nTip: control+click items to open in a new tab");
		if (bNewTrelloHome) {
		    divItemDashboardRecent.addClass("newTrelloHomeBackground");
		    divItemDashboardUnspent.addClass("newTrelloHomeBackground");
		}
		chartModuleLoader(waiter, divSpentItems, cellC, "Week by user", idChartModuleSpentWeekUsers, idChartModuleSpentWeekUsers + strPostfixStatus, dataWeek, loadChartSpentWeekUser, "left", true);
		chartModuleLoader(waiter, divSpentItems, cellD, "Week by board", idChartModuleSpentWeekBoard, idChartModuleSpentWeekBoard + strPostfixStatus, dataWeek.byBoard, loadChartSpentWeekBoard, "left", true);
		loadDashboards(waiter, divItemDashboardRecent, divItemDashboardUnspent, user);
	} else {
		var divItemDashboardRecent2 = $("#" + idRecentModule);
		var divItemDashboardUnspent2 = $("#" + idPendingModule);
		loadChartSpentWeekUser(null, divSpentItems, idChartModuleSpentWeekUsers, idChartModuleSpentWeekUsers + strPostfixStatus, dataWeek);
		loadChartSpentWeekBoard(null,divSpentItems, idChartModuleSpentWeekBoard, idChartModuleSpentWeekBoard + strPostfixStatus, dataWeek.byBoard);
		loadDashboards(null, divItemDashboardRecent2, divItemDashboardUnspent2, user);
	}
	return true;
}

function chartModuleLoader(waiter, divSuperContainer, divSpentItems, title, idChartModule, idElemChartStatus, data, callback, strFloat) {
    var divItem = addModuleSection(false, true, divSpentItems, title, idChartModule, false, strFloat);
	divItem.attr("align", "center");

	var nameLocal = idChartModule + "-Height";
	chrome.storage.local.get(nameLocal, function (obj) {
		var heightLast = obj[nameLocal];
		if (heightLast === undefined)
			heightLast = "50px";
		divItem.css("height", heightLast);
		//divSuperContainer.show();
		callback(waiter,divSuperContainer, idChartModule, idElemChartStatus, data);
	});
}

function cancelZoomin(callback, bQuick) {
    //needed because the zoom library leaves styles behind on the body. Clear them here, otherwise some things break like chart drill-down windows after a zoomin/zoomout
    var zoomed = $(".agile_zoomedElement");
    var strBodyTransProp = document.body.style.getPropertyValue("-webkit-transform") || "";
    if (zoomed.length > 0 || strBodyTransProp.length>0) {
        zoomed.removeClass("agile_zoomedElement");
        function preCallback() {
            document.body.style.setProperty("-webkit-transform-origin", "none");
            document.body.style.setProperty("transform-origin", "none");
            document.body.style.setProperty("-webkit-transform", "none");
            document.body.style.setProperty("transform", "none");
            if (callback) {
                setTimeout(callback, 10);
            }
        }

        $("body").zoomTo({ targetsize: 1, duration: bQuick?100 : 600, animationendcallback: preCallback });
    }
    else if (callback)
        callback();
}

function addModuleSection(bCombobox, bEnableZoom, div, name, id, bHidden, strFloat, bLastRow) {
    if (bHidden === undefined)
        bHidden = false;

    if (bCombobox) {
        var combo = $('<select id="' + id + '" />');
        div.append(combo);
        return combo;
    }
    var divItem = null;

    var divModule = $("<DIV>");
    var divTitleContainer = $("<DIV>").addClass("agile_spent_item_title");

    if (true) {
        divTitleContainer.addClass("agile_spent_item_title_newTrello"); //fix width
        divModule.addClass("agile_module_newtrello");

        if (strFloat)
            divModule.css("float", strFloat);
    }
    var titleModule = $('<h3>').addClass("classid_" + id + " sectionTitleFont");
    if (bEnableZoom) {
        titleModule.addClass("agile_spent_item_title_zoomable");
        titleModule.attr("title", "Click to zoom in/out");
        titleModule.css("cursor", "-webkit-zoom-in");
        titleModule.click(function (evt) {
            if (divModule.hasClass("agile_zoomedElement")) {
                titleModule.css("cursor", "-webkit-zoom-in");
                cancelZoomin();
            }
            else {
                function onFinishZoom() {
                    //need to change cursor here, else will change during animation on top of chart.
                    titleModule.css("cursor", "-webkit-zoom-out");
                }
                removeAllGrumbleBubbles();
                divModule.zoomTo({ targetsize: 1, duration: 600, animationendcallback: onFinishZoom });
                divModule.addClass("agile_zoomedElement");
            }
            evt.stopPropagation();
        });
    }
    divTitleContainer.append(titleModule.text(name));
    divModule.append(divTitleContainer);
    divItem = $('<div id="' + id + '"></div>').addClass("agile_spent_item notranslate");

    divItem.addClass("agile_spent_item_newTrello");
    if (bLastRow)
        divItem.addClass("agile_spent_item_lastRow");
    divModule.append(divItem);
    if (bHidden)
        divModule.hide();
    div.append(divModule);
    return divItem;
}

function checkNotUsingSE() {
    var sql = "select date from HISTORY AS H \
				ORDER by date DESC LIMIT 1";
    getSQLReport(sql, [],
		function (response) {
		    if (response && response.status == STATUS_OK && response.rows) {
		        var bNoSE= response.rows.length==0;

		        if (!bNoSE) {
		            var msDate = response.rows[0].date * 1000; //db is in seconds
		            if (Date.now() - msDate > 1000 * 60 * 60 * 24 * 30) {
		                //over a month ago
		                bNoSE = true;
		            }
		        }

		        if (bNoSE) {
		            setTimeout(function () { //wait a little for page to finish
		                showTryNoSEDialog();
		            }, 2000);
		        }
		    }
		});
}

function doRecentReport(waiter, elemRecent, user) {
    //note: includes deleted cards
    var sql = "select count(*) as cGrouped, max(date*1000) as msDate, max(dateLocal) as dateLocal, nameBoard, nameCard, SUM(spent) as spent, sum(est) as est, coalesce(GROUP_CONCAT(comment,'\n'),'') as comment, idCard from \
                (select H.date, datetime(H.date,'unixepoch','localtime') as dateLocal, B.name as nameBoard, C.name as nameCard, H.spent, H.est, H.comment, H.idCard \
				from HISTORY AS H \
				JOIN BOARDS AS B ON H.idBoard=B.idBoard \
				JOIN CARDS AS C ON H.idCard=C.idCard \
				WHERE H.user=? \
				ORDER BY date DESC, H.rowid DESC LIMIT 10) \
                GROUP BY nameBoard,nameCard,idCard \
                ORDER BY dateLocal DESC \
                ";
	var values = [user];
	getSQLReport(sql, values,
		function (response) {
		    elemRecent.empty();
		    elemRecent.append($(new Option("► Recent", "")).addClass("agile_section_comboTitle"));
		    elemRecent.append($(new Option("↗ Open report", VAL_COMBO_OPENREPORT)));
		    if (g_msStartPlusUsage && g_cRowsHistoryLast < 20 && !g_bNoSE && !g_bNoEst) {
		        var msDelta = Date.now() - g_msStartPlusUsage;
		        if (msDelta > 1000 * 60 * 60 * 2) { //2 days
		            if ((localStorage.getItem(PROP_LS_ASKEDNOTUSINGSE) || "") != "1") {
		                sendExtensionMessage({ method: "completedFirstSync" }, function (response) {
		                    if (response && response.status == STATUS_OK && response.bCompletedFirstSync) {
		                        localStorage.setItem(PROP_LS_ASKEDNOTUSINGSE, "1");
		                        checkNotUsingSE();
		                    }
		                });
		            }
		        }
		    }
		    handleLoadRecent(elemRecent, response.rows, user);
			elemRecent.parent().show();
			if (waiter)
			    waiter.Decrease();
		});
}

const VAL_COMBO_OPENREPORT = "//"; //special string that wont collide with idCard

function doPendingReport(waiter, elemPending, user) {
    if (g_bHidePendingCards || g_bNoEst) {
        if (waiter)
            waiter.Decrease();
        return;
    }
    var sqlNegativeDiff = (g_bAllowNegativeRemaining ? "" : "CB.diff<-0.005 OR");
	var sql = "select CB.user, CB.spent, CB.est, CB.diff, datetime(CB.date,'unixepoch','localtime') as dateLocal, B.name as nameBoard, C.name as nameCard, C.idCard, \
					CB.date*1000 AS msDate, CB.diff  \
					FROM CARDBALANCE AS CB join CARDS AS C ON CB.idCard=C.idCard AND C.bDeleted=0 \
					jOIN BOARDS B ON B.idBoard=C.idBoard \
					WHERE CB.user=? AND C.bArchived=0 AND C.bDeleted=0 AND (" + sqlNegativeDiff + " CB.diff>0.005 OR CB.spent<-0.005 OR CB.est<-0.005) \
					ORDER BY CB.date DESC";
	var values = [user];
	getSQLReport(sql, values,
		function (response) {
		    elemPending.empty();
		    elemPending.append($(new Option("► Remain", "")).addClass("agile_section_comboTitle"));
		    elemPending.append($(new Option("↗ Open report", VAL_COMBO_OPENREPORT)));
		    handleLoadPending(elemPending, response.rows, user);
			elemPending.parent().show();
			if (waiter)
			    waiter.Decrease();
		});
}

function loadDashboards(waiter, elemRecent, elemUnspent, user) {
	if (!g_bReadGlobalConfig) {
		logPlusError("unusual: loadDashboards not ready.");
		return;
	}

	doRecentReport(waiter, elemRecent, user);
	doPendingReport(waiter, elemUnspent, user);
}

function addDashboardListItem(list, name, url, tooltip) {
    name = '\u00A0\u00A0\u00A0\u00A0\u00A0\u00A0' + name + '\u00A0\u00A0'; //thanks http://stackoverflow.com/a/24847659/2213940
    var option = $(new Option(name, url)).addClass("agile_spent_item_combo_optionselectable");
    list.append(option);

	if (tooltip !== undefined)
	    option.attr('title', tooltip);
	return option;
}

var g_regexDoubleLines = /\n\n/gm;

function handleLoadRecent(combo, data, user) {
    var i = 0;
    var dateNow = new Date();
	for (; i < data.length; i++) {
		var row = data[i];
		if (row.dateLocal == null)
			break;
		var comment = row.comment || ""; //review zig: cant find how a user reported this was null. I added this and a colalesce into the report, but cant see how it can happen.
		var commentNew = "";
		do {
		    commentNew = replaceString(comment, g_regexDoubleLines, "\n");
		    if (commentNew == comment)
		        break;
		    comment = commentNew;
		} while (true);
		if (comment == "\n")
		    comment = "";
		var tooltip = "";
		var prefixSE = "";
		var bMultiple = (row.cGrouped > 1);
		if (bMultiple) {
		    prefixSE = "Sum ";
		    tooltip = "" + row.cGrouped + " S/E rows.\nLast: ";
		}

		var cDays = dateDiffInDays(dateNow, new Date(row.msDate));

		if (cDays == 0)
		    tooltip += "today ";
		else if (cDays == 1)
		    tooltip += cDays+" day ago ";
		else
		    tooltip += cDays+" days ago ";

		tooltip = tooltip + row.dateLocal + "\n" + prefixSE + "S: " + row.spent + "   E: " + row.est;
		if (comment)
		    tooltip=tooltip+ "\n" + (row.cGrouped > 1 ? "Comments:\n" : "Comment: ") + comment;

		addDashboardListItem(combo, strTruncate(row.nameBoard) + " - " + strTruncate(row.nameCard), row.idCard, tooltip);
	}

	var msDateLastCtrlClick = 0;
	combo.off("keydown").on("keydown", function (ev) {
	    //chrome does not fill the "change" event ctrlKey paramenters, thus we must remember here that a ctrl keydown happened.
	    if (ev && ev.ctrlKey)
	        msDateLastCtrlClick = performance.now();
	});

	combo.off("change").on("change", function (ev) {
	    var id = combo.val();
	    combo.val("");

	    if (id) {
	        if (id == VAL_COMBO_OPENREPORT) {
	            var params = "?chartView=s&groupBy=idCardH&orderBy=date&sinceSimple=w-4&user=" + user + "&archived=0&deleted=0";
	            if (g_bProVersion)
	                params += "&customColumns=card%2Cboard%2CdateDue%2CnameList%2Clabels%2Cs%2Ce%2Cnote%2CdateString";
	            params += "&named=_recentHome&useStoredNamed=true";
	            window.open(chrome.extension.getURL("report.html") + params, "_blank");
	        } else {
	            //must use timeout because this event arrives before the keydown event above
	            var msChange = performance.now();
	            setTimeout(function () {
	                var url = "https://trello.com/c/" + id;
	                if (msDateLastCtrlClick && Math.abs(msChange - msDateLastCtrlClick) < 500) {
	                    sendExtensionMessage({ method: "openCardWindow", idCard: id }, function (response) { });
	                    return;
	                }
	                window.location.href = url;
	            }, 300);
	        }
	    }
	});
}

function handleLoadPending(combo, data, user) {
    var i = 0;
    var dateNow = new Date();
    var bAddedSeparatorOld = false;
	for (; i < data.length; i++) {
		var row = data[i];
		if (row.dateLocal == null)
			break;
		var cDays = dateDiffInDays(dateNow, new Date(row.msDate));
		var tooltip = "Last S/E " + cDays;

		if (cDays == 1)
			tooltip += " day ago.";
		else
			tooltip += " days ago.";

		var bError = false;
		if (row.spent < -0.005) {
			tooltip += " Error! negative total spent in this card.";
			bError = true;
		} else if (row.est < -0.005) {
			tooltip += " Error! negative total estimate in this card.";
			bError = true;
		} else if (row.diff < -0.005 && !g_bAllowNegativeRemaining) {
			tooltip += " Error! negative remaining in this card. You must increase its Estimate.";
			bError = true;
		}

		if (cDays > 7 && !bAddedSeparatorOld) {
		    bAddedSeparatorOld = true;
		    var optSepOlder = $('<optgroup label="Older than 7 days:">');
		    combo.append(optSepOlder);
		}
		var span = addDashboardListItem(combo, parseFixedFloat(row.diff) + " \u00A0\u00A0\u00A0" + strTruncate(row.nameBoard) + " - " + strTruncate(row.nameCard), row.idCard, tooltip);
		if (bError)
			span.addClass("agile_card_error");
	}

	var msDateLastCtrlClick = 0;
	combo.off("keydown").on("keydown", function (ev) {
	    //chrome does not fill the "change" event ctrlKey paramenters, thus we must remember here that a ctrl keydown happened.
	    if (ev && ev.ctrlKey)
	        msDateLastCtrlClick = performance.now();
	});

	combo.off("change").on("change", function (ev) {
	    var id = combo.val();
	    combo.val("");
	    if (id) {
	        if (id == VAL_COMBO_OPENREPORT) {
	            var params="?chartView=r&groupBy=idCardH&orderBy=remain&user="+user+"&archived=0&deleted=0";
	            if (g_bProVersion)
	                params += "&customColumns=r%2Ccard%2Cboard%2Clabels%2CdateDue%2CdateString";
	            params += "&sortList=%5B%5B%22Due%20date%22%2C0%5D%2C%5B%22Date%22%2C1%5D%5D";
	            params += "&named=_remainHome&useStoredNamed=true";
	            window.open(chrome.extension.getURL("report.html")+params, "_blank");
	        } else {
	            //must use timeout because this event arrives before the keydown event above
	            var msChange = performance.now();
	            setTimeout(function () {
	                var url = "https://trello.com/c/" + id;
	                if (msDateLastCtrlClick && Math.abs(msChange - msDateLastCtrlClick) < 500) {
	                    sendExtensionMessage({ method: "openCardWindow", idCard: id }, function (response) { });
	                    return;
	                }
	                window.location.href = url;
	            }, 300);
	        }
	    }
	});
}


function dateDiffInDays(a, b) {
	// Discard the time and time-zone information.
	var utc1 = Date.UTC(a.getFullYear(), a.getMonth(), a.getDate());
	var utc2 = Date.UTC(b.getFullYear(), b.getMonth(), b.getDate());

	return Math.floor((utc1 - utc2) / (1000 * 60 * 60 * 24));
}

var g_chartsCache = {};
function loadChartSpentWeekUser(waiter, divContainer, idElem, idElemStatusChart, response) {
	if (!g_bReadGlobalConfig) {
		logPlusError("unusual: loadChartSpentWeekUser not ready.");
		return;
	}

	var elem = divContainer.find("#" + idElem);
	if (elem.length == 0)
		return;
	
	if (response.status != STATUS_OK || response.table === undefined || response.table.length == 0) {
	    if (waiter)
	        waiter.Decrease();
		elem.hide();
		return;
	} else
		elem.show();

	var rows = response.table;
	var data = new google.visualization.DataTable();
	var iDay = 0;
	data.addColumn('string', 'Who');
	for (; iDay < 7; iDay++) {
	    data.addColumn('number', getWeekdayName(DowMapper.dowFromPosWeek(iDay)));
	}

	var mapRows = addSumToRows(false, rows);
	data.addRows(rows);
	finishSpentChartConfig(waiter, idElem, elem, data, "top", 100, 0, response.drilldownData, "User", false, mapRows);
}



function getHtmlDrillDownTooltip(rows, bReverse, colExclude) {
	var headerBase = [{ name: "Date" }, { name: "User" }, { name: "Board" }, { name: "Card" }, { name: "S" }, { name: "E" }, { name: "Note", bExtend: true }, { name: COLUMNNAME_ETYPE }];

	var header = [];
	var iHeader = 0;
	for (; iHeader < headerBase.length; iHeader++) {
		if (headerBase[iHeader].name != colExclude)
			header.push(headerBase[iHeader]);
	}

	function callbackRowData(row) {
		var rgRet = [];
		var date = new Date(row.date * 1000); //db is in seconds
		rgRet.push({ name: makeDateCustomString(date,true), bNoTruncate: true });
		if (colExclude!="User")
			rgRet.push({ name: row.user, bNoTruncate: false });
		if (colExclude != "Board") {
		    if (row.idBoard) {
		        var urlBoard = "https://trello.com/b/" + row.idBoard;
		        rgRet.push({ name: "<A href='" + urlBoard + "'>" + strTruncate(row.nameBoard) + "</A>", bNoTruncate: true }); //no target makes it so trello loads it quickly and the drilldown stays up
		    }
		    else {
		        rgRet.push({ name: row.nameBoard, bNoTruncate: false });
		    }
		}
		var urlCard = null;
		if (row.idCard.indexOf("https://") == 0)
			urlCard = row.idCard; //old-style card URLs. Could be on old historical data from a previous Spent version
		else
			urlCard = "https://trello.com/c/" + row.idCard;
		rgRet.push({ name: "<A href='" + urlCard + "'>" + strTruncate(row.nameCard) + "</A>", bNoTruncate: true }); //no target makes it so trello loads it quickly and the drilldown stays up
		var sPush = parseFixedFloat(row.spent);
		var estPush = parseFixedFloat(row.est);
		rgRet.push({ type: "S", name: sPush, bNoTruncate: true });
		rgRet.push({ type: "E", name: estPush, bNoTruncate: true });
		rgRet.push({ name: row.comment, bNoTruncate: false });
		rgRet.push({ name: nameFromEType(row.eType), bNoTruncate: true });
		rgRet.title = "(" + sPush + " / " + estPush + ") " + row.comment;
		return rgRet;
	}

	return getHtmlBurndownTooltipFromRows(true, rows, bReverse, header, callbackRowData);
}

function loadChartSpentWeekBoard(waiter, divContainer, idElem, idElemStatusChart, response) {
	//review zig idElemStatusChart and in byUser unused
	if (!g_bReadGlobalConfig) {
		logPlusError("unusual: loadChartSpentWeekBoard not ready.");
		return;
	}

	var elem = divContainer.find("#" + idElem);
	if (elem.length == 0)
		return;

	if (response.status != STATUS_OK || response.table === undefined || response.table.length == 0) {
	    if (waiter)
	        waiter.Decrease();
		elem.hide();
		return;
	} else
		elem.show();

	var rows = response.table;
	var data = new google.visualization.DataTable();
	var iUser = 0;
	data.addColumn('string', 'Board');
	for (; iUser < response.users.length; iUser++)
		data.addColumn('number', response.users[iUser]);

	var mapRows = addSumToRows(false, rows);
	data.addRows(rows);
	finishSpentChartConfig(waiter, idElem, elem, data, "none", 150, 0, response.drilldownData, "Board",true, mapRows);
}

function finishSpentChartConfig(waiter, idElem, elem, data, posLegend, pxLeft, pxRight, drilldowns, colExclude, bReverse, mapRows) {
	var height = ((1 + data.getNumberOfRows()) * g_heightBarUser);
	if (posLegend == "top" || posLegend == "bottom")
		height += g_marginLabelChart;
	elem.css("height", "" + height);

	var chartParams = g_chartsCache[idElem];
    //timing note: we also check for elemChart being the right one. Sometimes the chart cache is left behind when trello plays navigation tricks.
    //example: from home click a board, then do "back". g_chartsCache will still be the old one
	var chartNew = null;
	if (chartParams === undefined || chartParams.elemChart != elem[0] || !g_bShowHomePlusSections) {
		chartNew = new google.visualization.BarChart(elem[0]);
		google.visualization.events.addListener(chartNew, 'animationfinish', function (e) {
		    handleRemapLabels(g_chartsCache[idElem]);
		});
	}
	else {
	    chartNew = chartParams.chart; //reuse chart
	}
	chartParams = { chart: chartNew, data: data, posLegend: posLegend, pxLeft: pxLeft, pxRight: pxRight };
	g_chartsCache[idElem] = chartParams;

	chartParams.data = data;
	chartParams.posLegend = posLegend;
	chartParams.pxLeft = pxLeft;
	chartParams.pxRight = pxRight; //NOTE: not used. gcharts doesnt support 'right'
	chartParams.mapRows = mapRows;
	chartParams.elemChart = elem[0];
	chartParams.chart.removeAction('drilldown'); //not sure if chart allows duplicate ids, so remove just in case
	chartParams.chart.removeAction('close-drilldown');
	if (drilldowns) {
	    
		chartParams.chart.setAction({
			id: 'drilldown',				  // An id is mandatory for all actions.
			text: 'Drill-down',	   // The text displayed in the tooltip.
			action: function () {		   // When clicked, the following runs.
			    cancelZoomin(function () {
			        handleDrilldownWindow(chartParams.chart, drilldowns, getHtmlDrillDownTooltip, colExclude, 950, bReverse);
			        drawSpentWeekChart(chartParams);
			    });
			}
		});

		chartParams.chart.setAction({
			id: 'close-drilldown',				  // An id is mandatory for all actions.
			text: 'Close',	   // The text displayed in the tooltip.
			action: function () {		   // When clicked, the following runs.
				drawSpentWeekChart(chartParams);
			}
		});
	}

	if (!g_bPreventChartDraw)
	    drawSpentWeekChart(chartParams);
	if (waiter)
	    waiter.Decrease();
	var pair = {};
	var nameLocal = idElem + "-Height";
	pair[nameLocal] = height;
	chrome.storage.local.set(pair, function () { });
}

function redrawAllCharts() {
	var i = null;
	var chartsParams = g_chartsCache;
	for (i in chartsParams) {
		var cp = chartsParams[i];
		drawSpentWeekChart(cp);
	}
}

function updateUsersList(users) {
	users.sort(
		function (aParam, bParam) {
			var a = aParam[0];
			var b = bParam[0];
			if (a > b)
				return 1;
			if (a < b)
				return -1;
			return 0;
		}
	);

	//chrome.storage.local.remove("allUsersSpent");
	//return;
	var pair = {};
	pair["allUsersSpent"] = users;
	chrome.storage.local.set(pair, function (obj) {

	}
	);
}

function bAtNewTrelloHome() {
    return ($(".home-container").length > 0);
}

function drawSpentWeekChart(chartParams) {
    if (!g_bShowHomePlusSections)
        return;
    var bNewTrelloHome = bAtNewTrelloHome();
	var chart = chartParams.chart;
	var data = chartParams.data;
	var posLegend = chartParams.posLegend;
	var pxLeft = chartParams.pxLeft;
	var pxRight = chartParams.pxRight;
	var mapRows = chartParams.mapRows;
	var elemChart = chartParams.elemChart;

	var top = 0;
	var bottom = 0;
	var right = 0;

	if (posLegend == "top")
		top = g_marginLabelChart;
	else if (posLegend == "bottom")
		bottom = g_marginLabelChart;

	var style = {
		chartArea: { left: pxLeft, top: top, bottom: bottom, right: 0, height: data.getNumberOfRows() * g_heightBarUser, width: "100%" },
		tooltip: { isHtml: true, trigger: 'selection' },
		vAxes: [{
			useFormatFromData: true,
			minValue: null,
			viewWindowMode: null,
			viewWindow: null,
			maxValue: null,
			titleTextStyle: {
				color: "#222",
				fontSize: 9,
				italic: true
			},
			textStyle: {
				color: "#222",
				fontSize: 9
			}
		},
		{
			useFormatFromData: true
		}],
		series: {
			0: {
				errorBars: {
					errorType: "none"
				}
			}
		},
		booleanRole: "certainty",
		animation: {
			duration: 330,
			easing: "in"
		},
		backgroundColor: {
		    fill: bNewTrelloHome ? "#f8f9f9" : "#FFFFFF"
		},
		legend: posLegend,
		hAxis: {
			useFormatFromData: false,
			formatOptions: {
				source: "inline",
				suffix: UNITS.getCurrentShort(g_bDisplayPointUnits)
			},
			slantedText: false,
			minValue: null,
			format: "0.##'" + UNITS.getCurrentShort(g_bDisplayPointUnits) + "'",
			viewWindow: {
				max: null,
				min: null
			},
			logScale: false,
			gridlines: {
				count: 4
			},
			maxValue: null,
			titleTextStyle: {
				color: "#222",
				fontSize: 9,
				italic: true
			},
			textStyle: {
				color: "#222",
				fontSize: 9
			}
		},
		isStacked: true,
		legendTextStyle: {
			color: "#222",
			fontSize: 9
		}
	};
	chart.draw(data, style);
	handleRemapLabels(chartParams);
}

function removePostfix(str, postfix) {
	if (postfix.length == 0)
		return str;
	var iDots = str.indexOf(postfix);
	if (iDots<0 || iDots + postfix.length != str.length)
		return str;
	return str.substr(0, iDots);
}

function remapTextElements(value, postfix, svg, mapRows, mapDone) {

	if (mapDone[value] == true)
		return;

	var elem = svg.eq(0).find("text").filter(function () {
		var valElem = removePostfix(this.innerHTML, postfix);
		if (valElem == value)
			return true;
		if (postfix.length == 0 || this.innerHTML==valElem)
			return false;
		return (value.indexOf(valElem) == 0);
	});

	if (elem.length != 1) {
		//corner case: if there are 2 boards with long names that are equal when cropped,
		//we cant tell which is which so we skip the calc instead of miscalculating
		return;
	}

	//jquery does not work on svg elements (jan 2014) so use the DOM api
	var elemSub = elem[0];
	var val = elemSub.textContent;
	elemSub.textContent = mapRows[value] + " " + removePostfix(elemSub.textContent,postfix);
	mapDone[value] = true;
}


/* handleRemapLabels
 *
 * Why is this needed?
 * Google charts support animations which we use. When we do, charts use the row name to match old with new data.
 * If we were to directly change the row labels when setting the chart data, animations wont match correctly the rows,
 * thus we instead hack the chart svg and change the labels ourselves.
 * For this to work, you need to call this function BOTH from your chart.draw AND from 'animationfinish' chart event.
 **/
function handleRemapLabels(chartParams) {
    if (chartParams && chartParams.mapRows) {
		var mapDone = {};
		var svg = $(chartParams.elemChart).find("svg");
		if (svg.length == 0)
			return;

		var iMap;
		for (iMap in chartParams.mapRows) {
			remapTextElements(iMap, "", svg, chartParams.mapRows, mapDone);
		}
		
		//2nd pass to cover ellipsed labels (long labels ending with ...)
		for (iMap in chartParams.mapRows) {
			remapTextElements(iMap, "...", svg, chartParams.mapRows, mapDone);
		}
	}
}

var g_current_fontSize = null; //cache for setSmallFont

function setMediumFont(elem) {
	return setSmallFont(elem, 0.9);
}

function setSmallFont(elem, percent) {
	var percentUse = percent;
	if (percent === undefined)
		percent = 0.7;
	if (g_current_fontSize == null)
		g_current_fontSize = parseInt($("body").css("font-size"), 10);
	elem.css("font-size", (g_current_fontSize * percent).toFixed() + "px");
	return elem; //for chaining
}

function setNormalFont(elem) {
	return setSmallFont(elem, 1);
}

function checkEnableMoses() {
	return true;
}


function doShowAgedCards(bShow) {
    if (isPlusDisplayDisabled())
        return;
    var elems = $(".aging-level-3");
    var elemTrelloFilter=$(".board-header-btn-filter-indicator");
	var bTrelloFilter = (elemTrelloFilter && elemTrelloFilter.length>0 && !elemTrelloFilter.hasClass("hide"));

    if (bTrelloFilter)  //REVIEW zig: not enough. ideally all hidden cards (by "less") shoul be shown again as soon at the trello filter cards pane comes up 
        return;

	if (bShow)
		elems.removeClass("hide");
	else
		elems.addClass("hide");
}

var g_bShowAllItems = true;  //show all items, or recent only (cards and boards)

function checkCreateRecentFilter(header) {
    if (g_bHideLessMore)
        return;

	var elemFilter = header.find($("#toggleAll"));
	if (elemFilter.length > 0)
		return;
	var elem = $('<a id="toggleAll" href="">...</a>').
			css('margin-left', '5px').addClass('agile_plus_header_link').appendTo(header);


	//var elem=$('<span>Less</span>', { id:'toggleAll'}).addClass("agile_all_button").addClass("header-btn").addClass("header-notifications");
	elem.css('cursor', 'pointer');
	header.append(elem);
	updateShowAllButtonState(elem,true);
	elem.click(function (e) {
	    hitAnalytics("MoreLess", "click", true);
		e.preventDefault();
	    //after set, we get again because set might have failed (over quota)
		var bShowAllItemsNew = !g_bShowAllItems;
		chrome.storage.sync.set({ 'bShowAllItems': bShowAllItemsNew }, function () {
		    if (chrome.runtime.lastError === undefined) {
		        updateShowAllButtonState(elem);
		    }
		});
	});
}

var g_cShownHiddenCardsAlert = 0;

function showHiddenCardsAlert() {
    if (g_cShownHiddenCardsAlert > 0)
        return;
    g_cShownHiddenCardsAlert++;
    sendDesktopNotification("Aged cards are hidden. Click on 'More' in the Plus header to show all cards.",7000);
}

function updateShowAllButtonState(elem, bFirstTime) {
    if (isPlusDisplayDisabled())
        return;
	chrome.storage.sync.get("bShowAllItems", function (obj) {
		var bShow = obj["bShowAllItems"];
		if (bShow === undefined)
			bShow = true;
		g_bShowAllItems = bShow;

		if (bShow) {
			elem.removeClass("agile_all_unpressed");
			elem.addClass("agile_all_pressed");
			elem.attr("title", "Click to hide old cards.\nMake sure Trello card aging is enabled.");
		} else {
			elem.removeClass("agile_all_pressed");
			elem.addClass("agile_all_unpressed");
			elem.attr("title", "Click to show old cards.");
			if (bFirstTime)
			    hiliteOnce(elem, 0, "agile_box_more_hilite");
			showHiddenCardsAlert();
		}
		doShowAgedCards(bShow);
		setTimeout(function () {
		    updateCards(getCurrentBoard(), null, true, false);
		}, 50);

		var classAgileFilter = "agile_plus_filter_old";

		if (bShow) {
		    elem.text("Less");
		    elem.removeClass(classAgileFilter);
		}
		else {
		    elem.text("More");
		    elem.addClass(classAgileFilter);
		}
	});
}



function testExtensionAndcommitPendingPlusMessages() {
	if (!g_bErrorExtension)
		testExtension(); //this attempts commit of pending queue
}

//resolves to true (delete) or false (merge)
function DeleteOrMergeNewSyncSource(prefix) {
    assert(window.Promise); //we check this on extension background
    var bDelete = confirm((prefix || "")+"When changing the sync spreadsheet you have two options:\n\n1) Press OK to clear all rows before adding the ones in this spreadsheet, or\n\n2) Press Cancel to merge existing rows with this new spreadsheet.");
    return Promise.resolve(bDelete);
}


function testModifySyncStorageUrl(url) {
    chrome.storage.sync.set({ "serviceUrl": (url || "")}, function () {
        if (chrome.runtime.lastError != undefined) {
            console.log(chrome.runtime.lastError.message);
            return;
        } else {
            console.log("set " + url);
        }
    });
}

//*************** */
function checkDownWarning() {
	const PROP_LS_MSLASTDOWNWARN = "MSLastTDOWNWARN";
	const MSDELTA_DOWNWARN = 1000 * 60 * 60 * 24 * 0.8;
	const msNow = Date.now();

	if (true) {
		var msLast = parseInt(localStorage.getItem(PROP_LS_MSLASTDOWNWARN) || "0", 10) || 0;

		if (msNow - msLast < MSDELTA_DOWNWARN)
			return;
	}

	showkDownWarning(function (bOK) {
		localStorage.setItem(PROP_LS_MSLASTDOWNWARN, msNow.toString());
	});
}

function showkDownWarning(callback) {
	var divDialog = $("#agile_dialog_DownWarning");

	function doCloseDialog(callbackAfter) {
		divDialog.removeClass("agile_dialog_Postit_Anim_ShiftToShow");
		setTimeout(function () {
			divDialog[0].close();
			if (callbackAfter)
				callbackAfter();
		}, 300); //wait for animation to complete
	}

	if (divDialog.length == 0) {
		//focus on h2 so it doesnt go to the first link
		divDialog = $('\
<dialog id="agile_dialog_DownWarning" style="cursor:pointer;padding-bottom:6px;padding-top:6px;text-align: center;width:21em;" class="agile_dialog_DefaultStyle agile_dialog_Postit agile_dialog_Postit_Anim">\
<div tabindex="1" style="outline: none;cursor:pointer;margin-top:0em;"><span><B>🟡 NOTE: Plus for Trello is getting a new owner!</B></span></div> \
<div> \
Hi! Soon a new owner will take and continue developing Plus<br><br>\
One of the first things the new owner will do is to remove the dependency from "web SQL" which \
Plus relies on and <A target="_blank" href="https://developer.chrome.com/blog/deps-rems-101/#remove-websql-in-third-party-contexts">might go away soon</A><br>	\
so as a precaution you should backup your Plus data as follows:</div> \
<div> <br>\
To export all your S/E data open <A target="_blank" href="'+ chrome.extension.getURL("report.html?pivotBy=year&orderBy=date&archived=-1&deleted=-1")+'">this report</A> and export it to excel or CSV.\
<br><A href="https://www.plusfortrello.com/2022/05/going-down.html" target="_blank"> More information</A>\
</div > \
			 <br>\
<div> <button style="display:inline-block;padding:0;margin-left:1em;margin-top:0;margin-bottom:0;width:3em;min-height:0.5em;">OK</button></div> \
			 <br>\
						  </dialog>');
		divDialog.find("button").off("click.plusForTrello").on("click.plusForTrello", function (e) {
			e.preventDefault();
			doCloseDialog(function () {
				callback(STATUS_OK, true);
			});
		});
	getDialogParent().append(divDialog);
	}

	showModlessDialog(divDialog[0]);
	setTimeout(function () { divDialog.addClass("agile_dialog_Postit_Anim_ShiftToShow"); }, 200); //some dialog conflict prevents animation from working without timeout
}
	/************************************************************* */


var g_bShowedTryPro = false;
var g_bForceShowTry = false; //for testing only

function checkTryPro() {
    const PROP_LS_MSLASTTRYPRO = "plus_ms_last_try_pro";
    const PROP_LS_DATELASTTRYPROCHECK = "plus_date_last_try_pro_check";
    const PROP_LS_CTIMESSHOWNTRYPRO= "plus_times_shown_try_pro";
    const MSDELTA_TRYPRO = 1000 * 60 * 60 * 24 * 40; //40 days
    const CTIMES_FINAL = 3;
    const msNow = Date.now();

    if (!g_bForceShowTry) {
        if (g_msStartPlusUsage === null || g_bShowedTryPro)
            return;

        var cDaysUsingPlus = Math.floor((msNow - g_msStartPlusUsage) / 1000 / 60 / 60 / 24);
        if (cDaysUsingPlus < 15)
            return;

        var msLast = parseInt(localStorage.getItem(PROP_LS_MSLASTTRYPRO) || "0", 10) || 0;

        if (msNow - msLast < MSDELTA_TRYPRO)
            return;
    }
    var strDateLast = localStorage.getItem(PROP_LS_DATELASTTRYPROCHECK) || "";
    var strDateNow = makeDateCustomString(new Date(msNow));
    var cTimesToday = 0;
    if (strDateNow == strDateLast)
        cTimesToday = (parseInt(localStorage.getItem(PROP_LS_CTIMESSHOWNTRYPRO) || "0", 10) || 0);
    else
        localStorage.setItem(PROP_LS_DATELASTTRYPROCHECK, strDateNow);

    cTimesToday++;

    if (!g_bForceShowTry) {
        if (cTimesToday > CTIMES_FINAL)
            return;

        if (cDaysUsingPlus < 20 && cTimesToday > 1)
            return;
    }

    localStorage.setItem(PROP_LS_CTIMESSHOWNTRYPRO, cTimesToday.toString());
    g_bShowedTryPro = true;
    showTryProDialog(cTimesToday == CTIMES_FINAL, function (bOK) {
        if (bOK) {
            g_bNeedShowPro = true;
            hiliteOnce($(".agile-main-plus-help-icon"), 1000, null, 2);
            setTimeout(function () {
                Help.display();
            }, 1000);
        }
        localStorage.setItem(PROP_LS_MSLASTTRYPRO, msNow.toString());
    });
}

function insertStripeDialog(liDataStripe) {
    var userTrello = getCurrentTrelloUser();
    if (!userTrello)
        return null;

    divStripeForm = $('\
<dialog class="agile_dialog_stripe_pay agile_dialog_DefaultStyle" style="width: 500px;top:0;"> \
<p align="center"><span style="font-size:120%;font-weight:normal;">Payments by stripe.com</span></p>\
<br>\
<form method="post" id="agile-stripe-payment-form">\
    <div style="display:none;" id="agile_stripe_li"></div>\
    <label style="display:inline-block;">License owner:</label>&nbsp;<span id="agile_userTrello_stripe">' + userTrello + '</span>\
    <br><br>\
    <label>\
        <span>Email of license owner</span>\
        <input  id="agile_email_stripe" class="field" name="email" type="email"  style="width:20em;background-color:#E2E4E6 !important;" autocomplete="email" />\
        <br>\
    </label>\
    <label for="agile_quantity_stripe" style="display:inline-block;">\
        <span>Total number of licenses</span>\
    </label>\
     <span id="agile_quantity_explain_modify_stripe" style="display:none;">Increase or decrease the total.</span><br>\
    <input id="agile_quantity_stripe" autocomplete="off" class="field" type="number" name="quantity" pattern="[0-9]" min="0" max="99" style="width:5em;display:inline-block;"/>\
    <span>&nbsp;one per Trello user, including you</span>\
    <br><br>\
    <label for="agile_cardholdername_stripe">\
        <span><span>Name of card holder</span></span>\
        <input id="agile_cardholdername_stripe"  name="name" class="field is-empty" style="width:20em;" autocomplete="cc-name" />\
    </label>\
    <div>&nbsp;</div>\
    <span id="agile_stripe_postpayhide">\
        <label for="agile-stripe-card-element">\
            Credit or debit card\
        </label>\
        <div id="agile-stripe-card-element"></div>\
        <br>\
        <button id="agile_stripe_paydialog_buy">Buy</button>\
        <button id="agile_cancel_stripe_buy">Cancel</button>\
    </span>\
     <a href="" id="agile_stripe_paydialog_tellmore">more about licenses</a>\
</form>\
<div style="min-height:3em;margin-top:0.5em;">\
    <div id="agile_stripe_paydialog_moreinfo" style="display:none;">\
        <br><p>Stripe payments (not Plus for Trello) processes your card.<br><A href="http://www.plusfortrello.com/p/plus-for-trello-pro-version.html#agile_stripe_payments" target="_blank">Read more</A> about Stripe, changing license quantities later or finding an existing license.<\p>\
    </div>\
    <div id="agile-stripe-card-errors" style="color:red;"></div>\
    <div id="agile_stripe_modifyinfo_reply" style="display:none;border: 1px solid;border-radius:6px;border-color:RGB(77,77,77);margin-top:1.5em;padding:1em;background-color: #FAF3C0;">\
    </div>\
    <div id="agile_stripe_modifyinfo" style="display:none;">\
<br>Change any detail. When changing quantities Plus will show a preview of charges or credits. To remove the subscription set licenses to zero. Credits always apply to the next yearly period.\
    </div>\
    <div style="display:none;" id="agile_stripe_licence_info" >\
        <p><b>Done! License processed OK.</b> You will receive an email shortly.</p>\
        Activate other computers with this URL or forward them the email: <input readonly id="agile_stripe_licence"  style="width:100%;" />\
        Start date: <span id="agile_stripe_startdate"></span>. View the license from the Plus help pane.\
    </div>\
    <button id="agile_stripe_ok" style="display:none;">OK</button>\
</div>\
<div id="agile_stripe_overlay" style="display:none;border-radius: 0px 0px 4px 4px;background:#F8F9F9;width: 100%;font-size:250%;height: 100%;text-align:center;position: absolute;top: 0;left: 0;">\
<p>&nbsp;</p>\
<p>&nbsp;</p>\
<p>&nbsp;</p>\
<p>&nbsp;</p>\
<p>&nbsp;</p>\
<p>&nbsp;</p>\
<p>&nbsp;</p>\
<p>&nbsp;</p>\
<span>Processing</span>\
<p>&nbsp;</p>\
<p>&nbsp;</p>\
<div><img src="' + chrome.extension.getURL("images/dotswait.gif") + '" /></div></div>\
</dialog>');
    document.body.appendChild(divStripeForm[0]);
    var bNeedsPreview = false;
    var quantityOrig = 0;
    $("#agile_cancel_stripe_buy,#agile_stripe_ok").click(function (ev) {
        divStripeForm[0].close();
        divStripeForm.remove();
        ev.preventDefault();
        if (ev.target.id == "agile_cancel_stripe_buy")
            hitAnalytics("LicActivation", "CANCELED-STRIPE");
        return false;
    });

    $("#agile_stripe_paydialog_tellmore").click(function (ev) {
        var elem = $("#agile_stripe_paydialog_moreinfo");
        if (elem.is(":visible"))
            elem.hide();
        else
            elem.show();
    });
   

    var elemNum = divStripeForm.find("[name='quantity']");
    elemNum.val("1");

    if (liDataStripe) {
        var elemEmail = divStripeForm.find("#agile_email_stripe");
        if (liDataStripe.li) {
            divStripeForm.find("#agile_stripe_modifyinfo, #agile_quantity_explain_modify_stripe").show();
            divStripeForm.find("#agile_stripe_li").text(liDataStripe.li);
        }
        if (liDataStripe.emailOwner)
            elemEmail.val(liDataStripe.emailOwner);
        quantityOrig = 0;
        if (liDataStripe.quantity) {
            quantityOrig = liDataStripe.quantity;
            elemNum.val(quantityOrig);
            setTimeout(function () { elemNum.focus(); },500);
        } else {
            setTimeout(function () { elemEmail.focus(); }, 500);
        }

        if (liDataStripe.nameCardOwner)
            divStripeForm.find("#agile_cardholdername_stripe").val(liDataStripe.nameCardOwner);
    }
    
    return divStripeForm;
}


function handleStripePay(callbackIn) {
    var bCalledBack = false;
    function callback() {
        if (callbackIn && !bCalledBack) {
            bCalledBack = true;
            callbackIn();
        }
    }

	alert("Please write to support@plusfortrello.com for any license issues.\nWe have suspended the purchase of new licenses until further notice.");
	callback();
	return;

    var divStripeForm = $(".agile_dialog_stripe_pay");
    if (divStripeForm.length > 0) {
        alert("Sorry, there was an error. Please refresh this Trello page and try again.");
        return;
    }
    chrome.storage.sync.get([SYNCPROP_LIDATA_STRIPE], function (objLiStripe) {
        if (chrome.runtime.lastError) {
            alert(chrome.runtime.lastError.message);
            return;
        }

        var liDataStripe = objLiStripe[SYNCPROP_LIDATA_STRIPE];

        //Insert the stripe API script (if needed), then insert our stripe-wrap.
        //the "wrap" is needed because we need to execute it in the context of Trello, not the extension, given that the stripe API script loads in that context.
        function insertWrap() {
            g_bInsertedStripeScript = true;
            var script = document.createElement("script");
            script.src = chrome.extension.getURL("stripe-wrap.js");
            script.onload = function () {
                showModalDialog(divStripeForm[0]);
            };
            document.head.appendChild(script);

        }
        //chrome.storage.sync.get()
        divStripeForm = insertStripeDialog(liDataStripe);
        if (!divStripeForm)
            return;

		function addCustomEventListener() {
			if (g_fnCallbackStripeMessage) {
				window.removeEventListener('message', g_fnCallbackStripeMessage)
				g_fnCallbackStripeMessage=null;
			}

			function callbackEvent(event) {
				if (event && event.isTrusted && event.data && event.data.type && event.data.type == "agile_stripe_data") {
                    //msCreated, li, userTrello, emailOwner, quantity, name
                    var license = event.data.license;
                    if (license && license.quantity>0)
                        hitAnalytics("LicActivation", "OK-ACTIVATED-STRIPE");
                    var objNew = {};
                    objNew[SYNCPROP_LIDATA_STRIPE] = license;
                    chrome.storage.sync.set(objNew, function () {
                        if (chrome.runtime.lastError) {
                            alert(chrome.runtime.lastError.message);
                            return;
                        }
                        callback();
                    });
                }
			}
			g_fnCallbackStripeMessage=callbackEvent;
			window.addEventListener('message', callbackEvent);
		}

        if (g_bInsertedStripeScript) {
            insertWrap();
        } else {
            //Dear Chrome store reviewer:
            //Please see cws-developer-support ticket #[9-0047000017350], I received a reply on may 12, 2017 that my case is being investigated
            //regarding failure of payments through the Chrome Web Store. I have also contacted other chrome web store extension developers and all confirmed multiple issues
            //with Chrome payments, typically like this: https://groups.google.com/a/chromium.org/d/msg/chromium-apps/pY_Rpt3P1eo/NUOjMx3IDAAJ
            //
            //My extension released (https://chrome.google.com/webstore/detail/plus-for-trello-time-trac/gjjpophepkbhejnglcmkdnncmaanojkf)
            //and developer test version (https://chrome.google.com/webstore/detail/test-pft/ehfjngfdbecjebnhoiohimligofdandp)
            //accepts Chrome store payments, but many payment attempts currently fail. Many users have written us
            //about being unable to pay with valid cards in valid countries.
            //Thus I am also supporting payments with stripe.com
            //Stripe ONLY allows their script to be loaded directly from Stripe, otherwise they detect and prevent using their api.
            //Thus, the only way to use stripe is to load it directly from their servers, from an https origin.
            //The stripe library cannot be included in the extension, cannot be loaded from the content script or the background page.
            var script = document.createElement("script");
            script.src = 'https://js.stripe.com/v3/';
            script.onload = insertWrap;
            document.head.appendChild(script);
		}
		addCustomEventListener();
    });
}

function checkLi(bForce, bExpanded, callbackIn) {
    var bCalledBack = false;
    function callback() {
        if (callbackIn && !bCalledBack) {
            bCalledBack = true;
            callbackIn();
        }
    }
		chrome.storage.local.get([LOCALPROP_PRO_VERSION], function (obj) {
        if (chrome.runtime.lastError) {
            console.error(chrome.runtime.lastError.message);
            return;
        }
        var bProVersion = obj[LOCALPROP_PRO_VERSION] || false;
        if (!bProVersion) {
            //checkTryPro();
            return;
        }
			
        chrome.storage.sync.get([SYNCPROP_LIDATA, SYNCPROP_LIDATA_STRIPE], function (obj) {
            if (chrome.runtime.lastError) {
                console.error(chrome.runtime.lastError.message);
                return;
            }

            var liData = obj[SYNCPROP_LIDATA] || { msLastCheck: 0, msCreated: 0, li: "" };
            var liDataStripe = obj[SYNCPROP_LIDATA_STRIPE] || { msLastCheck: 0, msCreated: 0, li: "" };
            var msNow = Date.now();
            if (!bForce && (liData.li || (liDataStripe.li && liDataStripe.quantity>0)))
                return; //review zig expiration etc

            var msLast = Math.max(liData.msLastCheck || 0, liDataStripe.msLastCheck || 0);
            var bWaitCheck = !bForce;
            if (bWaitCheck && (msNow - msLast < 1000 * 60 * 60 * 4)) //4 hours
                return;

            liData.msLastCheck = msNow;
            liDataStripe.msLastCheck = msNow; //note: currently we are not saving this value. Existing code will check liData.msLastCheck for showing dialog below


            function updateLiIfNewer(liData, bStripeMode) {
                //update msLastCheck if needed. must reload storage
                const propLi = (bStripeMode ? SYNCPROP_LIDATA_STRIPE : SYNCPROP_LIDATA);
                chrome.storage.sync.get([propLi], function (obj) {
                    if (chrome.runtime.lastError)
                        return;
                    var msLastCheckLast = liData.msLastCheck;
                    var liDataFromSync = obj[propLi];

                    if (liDataFromSync && liData.li && liData.li != liDataFromSync.li) {
                        //this is grave, we could save the new license anyway but it should never get here and may mess it up further so just log it
                        logPlusError("unexpected: received license in saveLiIfNewer. license:" + liData.li + ". previous retained:" + liDataFromSync.li);
                    }
                    liData = liDataFromSync || liData;

                    //this check will be false when we saved a newer liData to storage after we had set msNow to our local liData
                    if (liData.msLastCheck <= msLastCheckLast) {
                        liData.msLastCheck = msLastCheckLast;
                        var objNew = {};
                        //update msLastCheck
                        objNew[propLi] = liData;
                        chrome.storage.sync.set(objNew, function () {
                            if (chrome.runtime.lastError)
                                console.error(chrome.runtime.lastError.message);
                        });
                    }
                });
            }

            checkBackendEnabledPay(bForce, function () {
                showFirstLicDialog(bExpanded, liData.li == "", function (status, bStripeMode) {
                    hitAnalytics("LicDialog", (bStripeMode?"Stripe-":"Webstore-")+status);
                    if (status == STATUS_OK) {
                        if (bStripeMode) {
                            handleStripePay(callback);
                            return;
                        }
                        sendExtensionMessage({ method: "checkLi" }, function (response) {
                            hitAnalytics("LicActivation", response.status == STATUS_OK ? "OK-ACTIVATED" : response.status);
                            if (response.status == STATUS_OK)
                                sendDesktopNotification("Successful activation. Enjoy!");
                            else if (response.status == "hasLicense")
                                sendDesktopNotification("Existing license found (was already activated). Enjoy!", 12000); //user not using Chrome sign-in (storage sync) or crashed just after payment and before saving to storage.
                            else if (response.status == "TOKEN_MISSING_ERROR")
                                sendDesktopNotification("Please sign-in to Chrome before buying. In the top right of Chrome, click the button with your name or 'People'.", 12000);
                            else {
                                if (response.status == "PURCHASE_CANCELED")
                                    sendDesktopNotification("License not activated because the purchase was cancelled.", 12000);
                                else
                                    sendDesktopNotification("An error happened. Please try later. " + response.status, 12000);
                                updateLiIfNewer(liData, bStripeMode);
                            }

                            callback();

                        });
                    } else {
                        updateLiIfNewer(liData, bStripeMode);
                    }
                });
            });
        });
    });
}

//callback only if not payed
function checkBackendEnabledPay(bForce, callback) {
    callback();
}

function handlePlusLicenseUrl(userOwner, idSub) {
    var divPlusContent = $('#agile_plus_license_activate');
    if (divPlusContent.length > 0)
        return;
    var userTrello = getCurrentTrelloUser();

    if (!userTrello)
        return;

    chrome.storage.sync.get([SYNCPROP_LIDATA_STRIPE], function (obj) {
        if (chrome.runtime.lastError) {
            console.error(chrome.runtime.lastError.message);
            return;
        }

        var liDataStripe = obj[SYNCPROP_LIDATA_STRIPE] || { msLastCheck: 0, msCreated: 0, li: "" };
        var elemContent = $('#content');
        var elemNewContent = $('<div id="agile_plus_license_activate" class="big-message quiet" />');
        var elemText = $("<h1 >Activate \"Plus for Trello Pro\"</h1>");
        var elemP = $("<p>for Trello user: <b>" + userTrello + "</b></p>");
        var elemP2 = $("<p style='display:none;'></p>");
        var elemB = $("<button>Activate now</button>");
        var elemBottom = $('<p style="margin-top:4em;font-size:100%;color:#909090;"><A href="http://www.plusfortrello.com" target="_blank" style="color:#909090;">Plus for Trello</A> is not associated with Trello or Atlassian.</p>');
        elemNewContent.append(elemText);
        elemNewContent.append(elemP).append(elemP2);
        elemNewContent.append(elemB).append(elemBottom);
        elemContent.empty(); //killing content instead of reusing seems safer as trellos handlers will be gone too
        document.title = "License - Plus for Trello";
        elemContent.append(elemNewContent);

        if (liDataStripe.li) {
            elemP2.text("You already activated a license. Its ok, you can activate again to verify it.").show();
        }
        elemB.click(function (evt) {
            var url = "https://us-central1-plusfortrelloapp.cloudfunctions.net/checklic?";
            elemB.hide();
            elemP2.hide();
            elemBottom.hide();
            elemText.text("Activating...");
            elemP.html("&nbsp;");
            url += "userTrelloOwner=" + userOwner + "&userTrello=" + userTrello + "&liStripe=" + idSub;
            var xhr = new XMLHttpRequest();
            xhr.onreadystatechange = function (event) {
                if (xhr.readyState == 4) {
                    var statusRet = STATUS_OK;
                    var obj = null;
                    var val = xhr.responseText || "";
                    var iColon = val.indexOf(":");
                    const strOk = "sub-check-ok";
                    if (!val || !iColon || val.indexOf(strOk) != 0) {
                        if (iColon > 0)
                            val = val.substr(iColon + 1, val.length) + " (" + val.substr(0, iColon) + ")";
                        elemText.text("Error");
                        elemP.text(val);
                        elemP2.html("<p>Visit our <a href='http://www.plusfortrello.com/p/support.html' target='_blank'>Plus support page</a></p>").show();
                        hitAnalytics("LicActivation", "ERROR-URL-ACTIVATED-STRIPE");
                        return;
                    }
                    var parts = val.split(":");
                    var date = new Date(parseInt(parts[1], 10) || 0);
                    var quantity = parseInt(parts[2],10) || 0;
                    liDataStripe.msCreated = date.getTime();
                    liDataStripe.msLastCheck = Date.now();
                    liDataStripe.li = idSub;
                    liDataStripe.userTrello = userOwner;
                    liDataStripe.quantity = quantity;
                    var objNew = {};
                    objNew[SYNCPROP_LIDATA_STRIPE] = liDataStripe;
                    chrome.storage.sync.set(objNew, function () {
                        if (chrome.runtime.lastError) {
                            alert(chrome.runtime.lastError.message);
                            return;
                        }
                        var bSyncNotEnabled = (g_bDisableSync || (g_strServiceUrl == "" && !g_optEnterSEByComment.IsEnabled()));
                        elemText.html("Your 'Plus for Trello Pro' license seat is active");
                        if (bSyncNotEnabled) {
                            elemP2.html("<b><span style='color:red;'>You have not yet enabled sync.</span> <a href=''>Do it now</a><b/>").show();
                            elemP2.find("a").click(function (evt) {
                                evt.preventDefault();
                                Help.display();
                                return false;
                            });
                        }
                        elemP.html("<b>Thank you!</b><br><br><br>Love Plus? <a href='https://chrome.google.com/webstore/detail/plus-for-trello-time-trac/gjjpophepkbhejnglcmkdnncmaanojkf/reviews' target='_blank'>Rate us!</a><br><br>\
Explore our <a href='https://trello.com/b/0jHOl1As/plus-for-trello-help'>Plus help board</a><br><br>\
Go to <a href='https://trello.com'>trello.com</a><br><br>");

                        if (!g_bProVersion && quantity > 0) {
                            setProVersionOption(true, function () {
                                hitAnalytics("LicActivation", "OK-ACTIVATED-STRIPE");
                            });
                        }
                        return;
                    });
                }
            };

            xhr.open("GET", url, true);
            xhr.send();

        });
    });
}

function setProVersionOption(bValue, callback) {
    var pair = {};
    pair[LOCALPROP_PRO_VERSION] = bValue;
    var msNow = Date.now();
    var bSetDate = false;
    if (bValue && g_msStartPro == 0) {
        bSetDate = true;
        pair[LOCALPROP_PRO_MSDATEENABLED] = msNow;
    }
    chrome.storage.local.set(pair, function () {
        if (chrome.runtime.lastError == undefined) {
            g_bProVersion = bValue;
            if (bSetDate)
                g_msStartPro = msNow;
        }
        if (callback)
            callback();
    });
}

function showEnableSyncDialog(callback) { //callback: STATUS_OK, dontask, cancel (later)
    var divDialog = $("#agile_dialog_EnableSync");

    if (divDialog.length == 0) {
        //focus on h2 so it doesnt go to the first link
        divDialog = $('\
<dialog id="agile_dialog_EnableSync" style="cursor:pointer;text-align: center;width:24em;padding-top:0.5em;" class="agile_dialog_DefaultStyle agile_dialog_Postit agile_dialog_Postit_Anim_EnableSync">\
    <div id="agile_EnableSync_title" tabindex="1" style="outline: none; text-align: center;cursor:pointer;">Click here to configure Plus for Trello</div> \
    <div id="agile_EnableSync_content" style="display:none;"><br><b>Plus for Trello</b><br>\
        <br>\
        <p>You should pick a "sync" mode<br>to take advantage of most Plus features.</p>\
        <br>\
        <a href="" class="button-link agile_dialog_Postit_button" id="agile_dialog_EnableSync_OK">Show me how</a>&nbsp;&nbsp;\
        <a href="" class="button-link agile_dialog_Postit_button" style="" id="agile_dialog_EnableSync_Cancel">Later</a>&nbsp;&nbsp;\
        <a href="" class="button-link agile_dialog_Postit_button" style="" id="agile_dialog_EnableSync_DontAsk">Dont ask again</a><br>\
    <\div>\
</dialog>');
		getDialogParent().append(divDialog);
        divDialog = $("#agile_dialog_EnableSync");
    }

    function initDialog() {
        divDialog.off("click.plusForTrello").on("click.plusForTrello", function (e) {
            var content = divDialog.find("#agile_EnableSync_content");
            if (content.is(":visible"))
                return;
            divDialog.find("#agile_EnableSync_title").hide();
            divDialog.removeClass("agile_box_input_hilite");
            content.slideDown(200);
        });

        function doCloseDialog(callbackBefore, callbackAfter) {
            if (callbackBefore)
                callbackBefore();
            divDialog.removeClass("agile_dialog_Postit_Anim_ShiftToShow");
            setTimeout(function () {
                divDialog[0].close();
                if (callbackAfter)
                    callbackAfter();
            }, 300); //wait for animation to complete
        }


        divDialog.find("#agile_dialog_EnableSync_OK").off("click.plusForTrello").on("click.plusForTrello", function (e) {
            e.preventDefault();
            doCloseDialog(function () {
                callback(STATUS_OK);
            });
        });

        divDialog.find("#agile_dialog_EnableSync_Cancel").off("click.plusForTrello").on("click.plusForTrello", function (e) {
            e.preventDefault(); //link click would navigate otherwise
            doCloseDialog(function () {
                callback("cancel");
            });
        });


        divDialog.find("#agile_dialog_EnableSync_DontAsk").off("click.plusForTrello").on("click.plusForTrello", function (e) {
            e.preventDefault(); //link click would navigate otherwise
            doCloseDialog(function () {
                callback("dontask");
            });
        });

        divDialog.find("#agile_EnableSync_title").show();
        divDialog.find("#agile_EnableSync_content").hide();
        hiliteOnce(divDialog, 3000);
    }

    initDialog();
    showModlessDialog(divDialog[0]);
    divDialog.find("#agile_dialog_EnableSync_OK").focus();
    setTimeout(function () { divDialog.addClass("agile_dialog_Postit_Anim_ShiftToShow"); }, 200); //some dialog conflict prevents animation from working without timeout
}