public override void Execute(Guid contentDbId)
{
try {
PropertyBagOperations pbo = new PropertyBagOperations();
// using (SPWeb web = new SPSite(ConfigValues.PiwikPro_PiwikAdminSiteUrl).OpenWeb())
// using (SPWeb web = new SPSite(pbo.GetPropertyValueFromListByKey("piwik_adminsiteurl")).OpenWeb())
// {
Configuration cfg = new Configuration();
ClientContext clientContext = new ClientContext(pbo.GetPropertyValueFromListByKey(ConfigValues.PiwikPro_PropertyBag_ServiceUrl));
ListProcessor sdlo = new ListProcessor(clientContext, cfg);
//Get all Sites with status "New" and put it to Piwik
foreach (ListItem item in sdlo.GetAllNewSites())
{
//connect to service and create new site
PiwikPROServiceOperations pso = new PiwikPROServiceOperations(pbo.GetPropertyValueFromListByKey(ConfigValues.PiwikPro_PropertyBag_ClientID),
pbo.GetPropertyValueFromListByKey(ConfigValues.PiwikPro_PropertyBag_ClientSecret),
pbo.GetPropertyValueFromListByKey(ConfigValues.PiwikPro_PropertyBag_ServiceUrl),
pbo.GetPropertyValueFromListByKey(ConfigValues.PiwikPro_PropertyBag_OldApiToken));
SPFieldUrlValue valueUrl = new SPFieldUrlValue(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_Url]));
string idSite = string.Empty;
bool isSiteAlreadyOnPiwik = false;
if (!string.IsNullOrEmpty(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID])))
{
isSiteAlreadyOnPiwik = pso.CheckIfPageIsAlreadyOnPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]));
}
if (isSiteAlreadyOnPiwik)
{
idSite = Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]);
pso.ChangeNameSiteInPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_Title]), idSite);
}
else
{
idSite = pso.AddSiteToPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_Title]), valueUrl.Url);
}
if (idSite.Contains("Error: "))
{
item[ConfigValues.PiwikPro_SiteDirectory_Column_Status] = ConfigValues.PiwikPro_SiteDirectory_Column_Status_Error;
item[ConfigValues.PiwikPro_SiteDirectory_Column_ErrorLog] = idSite;
}
else
{
try
{
bool?ShouldTrackDocumentAddedGoal = null;
bool?ShouldTrackPageAddedGoal = null;
bool?ShouldTrackPageEditedGoal = null;
using (SPWeb webToPropertyBag = new SPSite(valueUrl.Url).OpenWeb())
{
bool oldAllowUnsafeUpdates = webToPropertyBag.AllowUnsafeUpdates;
webToPropertyBag.AllowUnsafeUpdates = true;
//create/update values in propbag
SPPropertyBag currentBag = webToPropertyBag.Properties;
if (isSiteAlreadyOnPiwik)
{
//operations if site was active before
}
else
{
//copy template values from piwikadmin
foreach (PropertyBagEntity pbe in pbo.PropertyBagList)
{
if (pbe.PropertyTitle.StartsWith("Template"))
{
CreateOrUpdateValueInPropertyBag(pbe.PropertyValue, webToPropertyBag, currentBag, pbe.PropertyName.Replace("template", ""));
}
}
}
CreateOrUpdateValueInPropertyBag(idSite, webToPropertyBag, currentBag, ConfigValues.PiwikPro_PropertyBag_SiteId);
CreateOrUpdateValueInPropertyBag("true", webToPropertyBag, currentBag, ConfigValues.PiwikPro_PropertyBag_PiwikIsTrackingActive);
//set gdpr off
pso.SetSetGdprOffInPiwik(idSite);
//Prepare goals
ShouldTrackDocumentAddedGoal = CheckIfValuesAreIntOrBoolAndReturn(currentBag[ConfigValues.PiwikPro_PropertyBag_ShouldTrackDocumentAddedGoal]);
ShouldTrackPageAddedGoal = CheckIfValuesAreIntOrBoolAndReturn(currentBag[ConfigValues.PiwikPro_PropertyBag_ShouldTrackPageAddedGoal]);
ShouldTrackPageEditedGoal = CheckIfValuesAreIntOrBoolAndReturn(currentBag[ConfigValues.PiwikPro_PropertyBag_ShouldTrackPageEditedGoal]);
//Add goals to Piwik site
AddGoalToPiwikAndWriteToPropertyBag(pso, ShouldTrackDocumentAddedGoal, idSite, ConfigValues.PiwikPro_PropertyBag_DocumentAddedGoalId, "Document added", currentBag, webToPropertyBag);
AddGoalToPiwikAndWriteToPropertyBag(pso, ShouldTrackPageAddedGoal, idSite, ConfigValues.PiwikPro_PropertyBag_PageAddedGoalId, "Page added", currentBag, webToPropertyBag);
AddGoalToPiwikAndWriteToPropertyBag(pso, ShouldTrackPageEditedGoal, idSite, ConfigValues.PiwikPro_PropertyBag_PageEditedGoalId, "Page edited", currentBag, webToPropertyBag);
AddPropBagValuesToIndexedProperties(webToPropertyBag);
webToPropertyBag.AllowUnsafeUpdates = oldAllowUnsafeUpdates;
}
}
catch (Exception exp)
{
item[ConfigValues.PiwikPro_SiteDirectory_Column_ErrorLog] = exp.Message;
}
item[ConfigValues.PiwikPro_SiteDirectory_Column_Status] = ConfigValues.PiwikPro_SiteDirectory_Column_Status_Active;
item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID] = idSite;
}
item.Update();
//PiwikPROServiceOperations pso = new PiwikPROServiceOperations();
// pso.RemoveSiteFromPiwik("4206f53d-c12a-4d63-a87c-677760ea58d8");
}
//Get all sites with status "Deactivating" and remove from Piwik
foreach (ListItem item in sdlo.GetAllDeactivatingSites())
{
//connect to service and deactivate
PiwikPROServiceOperations pso = new PiwikPROServiceOperations();
string idSite = Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]);
SPFieldUrlValue valueUrl = new SPFieldUrlValue(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_Url]));
//idSite = pso.RemoveSiteFromPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]));
pso.ChangeNameSiteInPiwik("Inactive - " + Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_Title]), idSite);
if (idSite.Contains("Error: "))
{
item[ConfigValues.PiwikPro_SiteDirectory_Column_Status] = ConfigValues.PiwikPro_SiteDirectory_Column_Status_Error;
item[ConfigValues.PiwikPro_SiteDirectory_Column_ErrorLog] = idSite;
}
else
{
item[ConfigValues.PiwikPro_SiteDirectory_Column_Status] = ConfigValues.PiwikPro_SiteDirectory_Column_Status_NoActive;
}
item.Update();
using (SPWeb webToPropertyBag = new SPSite(valueUrl.Url).OpenWeb())
{
bool oldAllowUnsafeUpdates = webToPropertyBag.AllowUnsafeUpdates;
webToPropertyBag.AllowUnsafeUpdates = true;
//create/update values in propbag
SPPropertyBag currentBag = webToPropertyBag.Properties;
CreateOrUpdateValueInPropertyBag("false", webToPropertyBag, currentBag, ConfigValues.PiwikPro_PropertyBag_PiwikIsTrackingActive);
webToPropertyBag.AllowUnsafeUpdates = oldAllowUnsafeUpdates;
}
}
//Get all sites with status "Settings updated" and update goals in Piwik
foreach (ListItem item in sdlo.GetAllSettingsUpdatedSites())
{
//connect to service and deactivate
PiwikPROServiceOperations pso = new PiwikPROServiceOperations();
string idSite = string.Empty;
idSite = Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]);
SPFieldUrlValue valueUrl = new SPFieldUrlValue(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_Url]));
string pwkChangedValues = Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_PropChanged]);
using (SPWeb webToPropertyBag = new SPSite(valueUrl.Url).OpenWeb())
{
SPPropertyBag currentBag = webToPropertyBag.Properties;
foreach (string pwkValue in pwkChangedValues.Split(';'))
{
if (pwkValue != null)
{
if (pwkValue.Split('|')[0] == "ShouldTrackDocumentAddedGoal" && pwkValue.Split('|')[1].ToLower() == "true")
{
AddGoalToPiwikAndWriteToPropertyBag(pso, true, idSite, ConfigValues.PiwikPro_PropertyBag_DocumentAddedGoalId, "Document added", currentBag, webToPropertyBag);
}
if (pwkValue.Split('|')[0] == "ShouldTrackPageAddedGoal" && pwkValue.Split('|')[1].ToLower() == "true")
{
AddGoalToPiwikAndWriteToPropertyBag(pso, true, idSite, ConfigValues.PiwikPro_PropertyBag_PageAddedGoalId, "Page added", currentBag, webToPropertyBag);
}
if (pwkValue.Split('|')[0] == "ShouldTrackPageEditedGoal" && pwkValue.Split('|')[1].ToLower() == "true")
{
AddGoalToPiwikAndWriteToPropertyBag(pso, true, idSite, ConfigValues.PiwikPro_PropertyBag_PageEditedGoalId, "Page edited", currentBag, webToPropertyBag);
}
}
}
item[ConfigValues.PiwikPro_SiteDirectory_Column_PropChanged] = "";
//pso.UpdateGoalToPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]), "Document added", currentBag[ConfigValues.PiwikPro_PropertyBag_DocumentAddedGoalId], CheckIfValuesAreIntOrBoolAndReturn(currentBag[ConfigValues.PiwikPro_PropertyBag_ShouldTrackDocumentAddedGoal]));
//pso.UpdateGoalToPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]), "Page added", currentBag[ConfigValues.PiwikPro_PropertyBag_PageAddedGoalId], CheckIfValuesAreIntOrBoolAndReturn(currentBag[ConfigValues.PiwikPro_PropertyBag_ShouldTrackPageAddedGoal]));
//pso.UpdateGoalToPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]), "Page edited", currentBag[ConfigValues.PiwikPro_PropertyBag_PageEditedGoalId], CheckIfValuesAreIntOrBoolAndReturn(currentBag[ConfigValues.PiwikPro_PropertyBag_ShouldTrackPageEditedGoal]));
}
if (idSite.Contains("Error: "))
{
item[ConfigValues.PiwikPro_SiteDirectory_Column_Status] = ConfigValues.PiwikPro_SiteDirectory_Column_Status_Error;
item[ConfigValues.PiwikPro_SiteDirectory_Column_ErrorLog] = idSite;
}
else
{
item[ConfigValues.PiwikPro_SiteDirectory_Column_Status] = ConfigValues.PiwikPro_SiteDirectory_Column_Status_Active;
}
item.Update();
}
//}
} catch (Exception ex) {
// Logger.WriteLog(Logger.Category.Unexpected, "Piwik Execute TimerJob", ex.Message);
}
}
public void GetAllNewSitesAndOperate(ClientContext clientContext, string spOnlineUserLogin, string spOnlineUserPassword, string adminTenantUrl)
{
try
{
ListProcessor sdlo = new ListProcessor(clientContext, cfg, logger);
//Get all Sites with status "New" and put it to Piwik
foreach (ListItem item in sdlo.GetAllNewSites())
{
//connect to service and create new site
PiwikPROServiceOperations pso = new PiwikPROServiceOperations(cfg.PiwikClientID, cfg.PiwikClientSecret, cfg.PiwikServiceUrl, cfg.PiwikOldApiToken, logger);
FieldUrlValue valueUrl = (FieldUrlValue)(item[ConfigValues.PiwikPro_SiteDirectory_Column_Url]);
string idSite = string.Empty;
bool isSiteAlreadyOnPiwik = false;
if (!string.IsNullOrEmpty(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID])))
{
isSiteAlreadyOnPiwik = pso.CheckIfPageIsAlreadyOnPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]));
}
if (isSiteAlreadyOnPiwik)
{
idSite = Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID]);
pso.ChangeNameSiteInPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_Title]), idSite);
}
else
{
idSite = pso.AddSiteToPiwik(Convert.ToString(item[ConfigValues.PiwikPro_SiteDirectory_Column_Title]), valueUrl.Url);
}
if (idSite.Contains("Error: "))
{
item[ConfigValues.PiwikPro_SiteDirectory_Column_Status] = ConfigValues.PiwikPro_SiteDirectory_Column_Status_Error;
item[ConfigValues.PiwikPro_SiteDirectory_Column_ErrorLog] = idSite;
}
else
{
try
{
bool? ShouldTrackDocumentAddedGoal = null;
bool? ShouldTrackPageAddedGoal = null;
bool? ShouldTrackPageEditedGoal = null;
ClientContext contextToPropBag;
if (!string.IsNullOrEmpty(spOnlineUserLogin))
{
OfficeDevPnP.Core.AuthenticationManager authMan = new OfficeDevPnP.Core.AuthenticationManager();
contextToPropBag = authMan.GetAppOnlyAuthenticatedContext(valueUrl.Url, spOnlineUserLogin, spOnlineUserPassword);
SetEnablePropertyBagChange(adminTenantUrl, valueUrl.Url, spOnlineUserLogin, spOnlineUserPassword, logger);
}
else
{
contextToPropBag = new ClientContext(valueUrl.Url);
}
if (isSiteAlreadyOnPiwik)
{
//operations if site was active before
}
else
{
//copy template values from piwikadmin
foreach (PropertyBagEntity pbe in cfg.PropertyBagList)
{
if (pbe.PropertyTitle.StartsWith("Template"))
{
CreateOrUpdateValueInPropertyBag(pbe.PropertyValue, contextToPropBag, pbe.PropertyName.Replace("template", ""));
}
}
}
CreateOrUpdateValueInPropertyBag(idSite, contextToPropBag, ConfigValues.PiwikPro_PropertyBag_SiteId);
CreateOrUpdateValueInPropertyBag("true", contextToPropBag, ConfigValues.PiwikPro_PropertyBag_PiwikIsTrackingActive);
//set gdpr off
pso.SetSetGdprOffInPiwik(idSite);
//create/update values in propbag
PropertyValues currentBag = contextToPropBag.Site.RootWeb.AllProperties;
contextToPropBag.Load(currentBag);
contextToPropBag.ExecuteQueryRetry();
//Prepare goals
ShouldTrackDocumentAddedGoal = CheckIfValuesAreIntOrBoolAndReturn(Convert.ToString(currentBag[ConfigValues.PiwikPro_PropertyBag_ShouldTrackDocumentAddedGoal]));
ShouldTrackPageAddedGoal = CheckIfValuesAreIntOrBoolAndReturn(Convert.ToString(currentBag[ConfigValues.PiwikPro_PropertyBag_ShouldTrackPageAddedGoal]));
ShouldTrackPageEditedGoal = CheckIfValuesAreIntOrBoolAndReturn(Convert.ToString(currentBag[ConfigValues.PiwikPro_PropertyBag_ShouldTrackPageEditedGoal]));
//Add goals to Piwik site
AddGoalToPiwikAndWriteToPropertyBag(pso, ShouldTrackDocumentAddedGoal, idSite, ConfigValues.PiwikPro_PropertyBag_DocumentAddedGoalId, "Document added", currentBag, contextToPropBag);
AddGoalToPiwikAndWriteToPropertyBag(pso, ShouldTrackPageAddedGoal, idSite, ConfigValues.PiwikPro_PropertyBag_PageAddedGoalId, "Page added", currentBag, contextToPropBag);
AddGoalToPiwikAndWriteToPropertyBag(pso, ShouldTrackPageEditedGoal, idSite, ConfigValues.PiwikPro_PropertyBag_PageEditedGoalId, "Page edited", currentBag, contextToPropBag);
AddPropBagValuesToIndexedProperties(contextToPropBag);
}
catch (Exception exp)
{
item[ConfigValues.PiwikPro_SiteDirectory_Column_ErrorLog] = exp.Message;
logger.WriteLog(Category.Unexpected, "Piwik GetAllNewSitesAndOperate", exp.Message);
}
item[ConfigValues.PiwikPro_SiteDirectory_Column_Status] = ConfigValues.PiwikPro_SiteDirectory_Column_Status_Active;
item[ConfigValues.PiwikPro_SiteDirectory_Column_SiteID] = idSite;
}
item.Update();
clientContext.ExecuteQueryRetry();
}
}
catch (Exception expcc)
{
logger.WriteLog(Category.Unexpected, "Piwik GetAllNewSitesAndOperateOnFinish", expcc.Message);
}
}
