private static int Send_Usage_Emails(int year, int month, string SystemUrl, string SystemName, string FromAddress, string FromName)
{
// Get the list of all users linked to items
DataTable usersLinkedToItems = Engine_Database.Get_Users_Linked_To_Items(null);
// If NULL, then no data linked to users
if (usersLinkedToItems == null)
{
return(0);
}
// Determine the FROM
string fromAddr = FromAddress;
if (!String.IsNullOrEmpty(FromName))
{
fromAddr = FromName + " <" + FromAddress + ">";
}
// Step through each row and pull data about the usage stats for this user
int emails_sent = 0;
foreach (DataRow thisRow in usersLinkedToItems.Rows)
{
Thread.Sleep(1000);
// Pull out the user information from this row
string firstName = thisRow[0].ToString();
string lastName = thisRow[1].ToString();
string nickName = thisRow[2].ToString();
int userid = Convert.ToInt32(thisRow[4]);
string email = thisRow[5].ToString();
// Compose the name
string name = firstName + " " + lastName;
if (nickName.Length > 0)
{
name = nickName + " " + lastName;
}
// Try to compose and send the email. The email will only be sent if there was
// some total usage this month, as well as total
if (Usage_Stats_Email_Helper.Send_Individual_Usage_Email(userid, name, email, year, month, 10, SystemUrl, SystemName, fromAddr))
{
emails_sent++;
}
}
return(emails_sent);
}
/// <summary> Checks to see if there are web logs that need to be processed to the usage statistics </summary>
/// <param name="Settings"> Instance-wide settings which may be required for this process </param>
public override void DoWork(InstanceWide_Settings Settings)
{
// If there is no IIS web log set, then do nothing. Don't even need a log here.
if (String.IsNullOrEmpty(Settings.Builder.IIS_Logs_Directory))
{
return;
}
// Just don't run the first day of the month - ensures logs still not being written
if (DateTime.Now.Day < 2)
{
return;
}
// Ensure directory exists and is accessible
string log_directory = Settings.Builder.IIS_Logs_Directory;
try
{
if (!Directory.Exists(log_directory))
{
OnError("CalculateUsageStatisticsModule : IIS web log directory ( " + log_directory + " ) does not exists or is inaccessible", null, null, -1);
return;
}
}
catch (Exception ee)
{
OnError("CalculateUsageStatisticsModule : IIS web log directory ( " + log_directory + " ) does not exists or is inaccessible : " + ee.Message, null, null, -1);
return;
}
// Get the temporary workspace directory, and ensure it exists
string temporary_workspace = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "Temporary", "CalculateUsageStatisticsModule");
try
{
if (!Directory.Exists(temporary_workspace))
{
Directory.CreateDirectory(temporary_workspace);
}
}
catch (Exception ee)
{
OnError("CalculateUsageStatisticsModule : Unable to create the temporary workspace ( " + temporary_workspace + " ) : " + ee.Message, null, null, -1);
return;
}
// Clear the temporary workspace
try
{
string[] files = Directory.GetFiles(temporary_workspace);
foreach (string thisFile in files)
{
File.Delete(thisFile);
}
}
catch (Exception ee)
{
OnError("CalculateUsageStatisticsModule : Error caught clearing existing files from the temporary workspace ( " + temporary_workspace + " ) : " + ee.Message, null, null, -1);
return;
}
// Get (and double check) the web directory
if (String.IsNullOrEmpty(Settings.Servers.Application_Server_Network))
{
OnError("CalculateUsageStatisticsModule : No application server network setting! Correct ASAP!", null, null, -1);
return;
}
// Ensure directory exists and is accessible
string sobekcm_directory = Settings.Servers.Application_Server_Network;
try
{
if (!Directory.Exists(sobekcm_directory))
{
OnError("CalculateUsageStatisticsModule : Web application server network directory ( " + sobekcm_directory + " ) does not exists or is inaccessible", null, null, -1);
return;
}
}
catch (Exception ee)
{
OnError("CalculateUsageStatisticsModule : Web application server network ( " + sobekcm_directory + " ) does not exists or is inaccessible : " + ee.Message, null, null, -1);
return;
}
// Determine which year/months already have been analyzed for this instance
Statistics_Dates statsDates = new Statistics_Dates();
if (Engine_ApplicationCache_Gateway.Stats_Date_Range != null)
{
Engine_Database.Populate_Statistics_Dates(statsDates, null);
}
else
{
statsDates = Engine_ApplicationCache_Gateway.Stats_Date_Range;
}
// Get the list of all IIS web logs
string[] log_files = Directory.GetFiles(log_directory, "u_ex*.log");
// If no log files, just return
if (log_files.Length == 0)
{
OnError("CalculateUsageStatisticsModule : No IIS web logs found in directory ( " + log_directory + " )", null, null, -1);
return;
}
// Get the earliest and latest log files from the IIS web logs
string earliest = "ZZZZZZZZ";
string latest = "AAAAAAAA";
foreach (string thisFile in log_files)
{
string thisFileName = Path.GetFileNameWithoutExtension(thisFile);
if (String.Compare(thisFileName, earliest, StringComparison.OrdinalIgnoreCase) < 0)
{
earliest = thisFileName;
}
if (String.Compare(thisFileName, latest, StringComparison.OrdinalIgnoreCase) > 0)
{
latest = thisFileName;
}
}
// Parse them to determine the earliest and latest year/months
int earliest_year;
int earliest_month;
int latest_year;
int latest_month;
try
{
earliest_year = 2000 + Int32.Parse(earliest.Substring(4, 2));
earliest_month = Int32.Parse(earliest.Substring(6, 2));
latest_year = 2000 + Int32.Parse(latest.Substring(4, 2));
latest_month = Int32.Parse(latest.Substring(6, 2));
}
catch (Exception)
{
OnError("CalculateUsageStatisticsModule : Error parsing the earliest or latest log for year/month (" + earliest + " or " + latest + " )", null, null, -1);
return;
}
// Determine what years/months are missing
List <string> year_month = new List <string>();
if (statsDates.Earliest_Year == 2000)
{
// No stats every collected, so collect them all
int curr_year = earliest_year;
int curr_month = earliest_month;
while ((curr_year < latest_year) || ((curr_year == latest_year) && (curr_month <= latest_month)))
{
if ((curr_year == DateTime.Now.Year) && (curr_month == DateTime.Now.Month))
{
break;
}
year_month.Add(curr_year + curr_month.ToString().PadLeft(2, '0'));
curr_month++;
if (curr_month > 12)
{
curr_year++;
curr_month = 1;
}
}
}
else
{
// No stats every collected, so collect them all
int curr_year = earliest_year;
int curr_month = earliest_month;
while ((curr_year < latest_year) || ((curr_year == latest_year) && (curr_month <= latest_month)))
{
if ((curr_year == DateTime.Now.Year) && (curr_month == DateTime.Now.Month))
{
break;
}
if ((curr_year > statsDates.Latest_Year) || ((curr_year == statsDates.Latest_Year) && (curr_month > statsDates.Latest_Month)))
{
year_month.Add(curr_year + curr_month.ToString().PadLeft(2, '0'));
}
curr_month++;
if (curr_month > 12)
{
curr_year++;
curr_month = 1;
}
}
}
// If no year/months were added , then no work to do
if (year_month.Count == 0)
{
return;
}
// Create the processor
SobekCM_Stats_Reader_Processor processor = new SobekCM_Stats_Reader_Processor(log_directory, temporary_workspace, sobekcm_directory, year_month);
processor.New_Status += processor_New_Status;
// Create the thread
processor.Process_IIS_Logs();
// Delete the cached file, if one exists
try
{
string temp_directory = Path.Combine(Settings.Servers.Application_Server_Network, "temp");
if (Directory.Exists(temp_directory))
{
string cache_xml_file = Path.Combine(temp_directory, "overall_usage.xml");
if (File.Exists(cache_xml_file))
{
File.Delete(cache_xml_file);
}
}
}
catch { }
// Shoudl emails be sent?
if (Settings.Builder.Send_Usage_Emails)
{
// Load the text
string possible_email_body_dir = Path.Combine(Settings.Servers.Application_Server_Network, "design", "extra", "stats");
Usage_Stats_Email_Helper.Set_Email_Body(Path.Combine(possible_email_body_dir, "stats_email_body.txt"));
// Send emails for each year/month (in order)
foreach (string thisYearMonth in year_month)
{
int year = Convert.ToInt32(thisYearMonth.Substring(0, 4));
int month = Convert.ToInt32(thisYearMonth.Substring(4, 2));
Send_Usage_Emails(year, month, Settings.Servers.System_Base_URL, Settings.System.System_Name, Settings.Email.Setup.DefaultFromAddress, Settings.Email.Setup.DefaultFromDisplay);
}
}
}
