public ShiftManagerTicker(
ITickerManager tickerManager,
WorkshiftsCM workshiftsCM,
MultiLevelTicketQueue inputQueue,
TicketQueue doneQueue,
Accounting accounting)
{
this.workshiftsCM = workshiftsCM;
this.tickerManager = tickerManager;
this.inputQueue = inputQueue;
this.doneQueue = doneQueue;
this.accounting = accounting;
}
public static WorkshiftsCM GetWorkshifts()
{
var ws = new WorkshiftsCM(null);
EmployeeType etS = new EmployeeType("Susanne", SupportLevel.Level1st, 60, 1, 1);
EmployeeType etP = new EmployeeType("Peter", SupportLevel.Level1st, 60, 1, 1);
ws.Add(new Workshift()
{
Begin = 540, End = 1080, EmployeeTypes = { { etS, 3 }, { etP, 2 } }
});
ws.Add(new Workshift()
{
Begin = 720, End = 1260, EmployeeTypes = { { etS, 3 }, { etP, 2 } }
});
return(ws);
}
public SimulationManager(string marker, int run, WorkshiftsCM workshiftsCM, TicketGenerationPlan plan, int daysToSimulate)
{
this.marker = marker;
this.run = run;
this.workshiftsCM = workshiftsCM;
this.plan = plan;
this.daysToSimulate = daysToSimulate;
// Init Basic Tickers
var shiftManager = new ShiftManagerTicker(this, workshiftsCM, inputQueue, doneQueue, Accounting);
shiftManager.LogEvent += ShiftManager_LogEvent;
Add(shiftManager);
Add(new NewTicketTicker(plan, inputQueue));
// Needed for Grafana
unixTimestamp = (Int32)((DateTimeOffset)DateTime.Today.ToUniversalTime()).ToUnixTimeSeconds();
}
public int Run()
{
init();
if (UseDatabase)
{
ConnectDb();
}
else if (TruncateFirst || DropAndCreateFirst || ClearTablesForMarker)
{
Print("You cannot do any data operations without --usedb");
return(1);
}
EmployeeTypesCM employeeTypesCM = new EmployeeTypesCM();
employeeTypesCM.Load(EmployeeTypesFilename);
WorkshiftsCM workshifts = new WorkshiftsCM(employeeTypesCM);
workshifts.Load(WorkshiftsFilename);
TicketGenerationPlan ticketGenerationPlan = new TicketGenerationPlan();
ticketGenerationPlan.Load(TicketGenerationPlan);
Print("All files loaded");
Print(string.Format("Total tickets: {0}", ticketGenerationPlan.TotalTickets));
if (Days == null)
{
Days = ticketGenerationPlan.NumberOfDays;
Print("Found {0} days in ticket plan", Days);
}
int run = 0;
if (UseDatabase)
{
if (DropAndCreateFirst)
{
DropTables(true);
CreateTables();
}
if (TruncateFirst)
{
TruncateTables();
}
if (ClearTablesForMarker)
{
Print("Deleted old datapoints (if exists) ({0})", DeleteDatapointsForMarker(Name));
Print("Deleted old summary (if exists) ({0})", DeleteSummariesForMarker(Name));
}
var getRunNumberCmd = new MySqlCommand(string.Format("select ifnull(max(run),0) as max from datapoints where marker=@Marker", Statics.TableSummaries), conn);
getRunNumberCmd.Parameters.Add("@Marker", MySqlDbType.VarChar).Value = Name;
using (var getRunNumberCmdReader = getRunNumberCmd.ExecuteReader())
{
getRunNumberCmdReader.Read();
run = getRunNumberCmdReader.GetInt32("max") + 1;
}
Print("Run number {0}", run);
}
SimulationManager sm = new SimulationManager(Name, run, workshifts, ticketGenerationPlan, Days.Value);
if (UseDatabase)
{
sm.NewDatapoint += Sm_NewDatapoint;
}
if (Debug)
{
sm.LogEvent += Print;
}
sm.Run();
if (UseDatabase)
{
Print("Inserting {0} datapoints into db if connected", datapoints.Count);
int inserts = 0;
if (datapoints.Count > 0)
{
inserts += InternalMySqlHelper.GetBulkInsert(conn, "datapoints", datapoints.ToArray()).ExecuteNonQuery();
}
Print("Inserts: {0}", inserts);
}
List <TicketEntity> tickets = ticketGenerationPlan.Tickets;
SimulationSummary ss = new SimulationSummary(
Name,
run,
tickets.Where(t => t.Solved).Count(),
tickets.Where(t => t.Deployed).Count(),
tickets.Where(t => t.Started).Count(),
tickets.Count(),
tickets.Where(t => !t.Solved && t.Difficulty == Models.SupportLevel.Level1st).Count(),
tickets.Where(t => !t.Solved && t.Difficulty == Models.SupportLevel.Level2nd).Count(),
tickets.Where(t => t.Solved).Any() ? tickets.Where(t => t.Solved).Average(i => i.Duration) : 0,
sm.Accounting.TotalExpenses,
sm.Accounting.TotalWorkingHours,
sm.Accounting.TotalWorkingHours != 0? sm.Accounting.TotalExpenses / sm.Accounting.TotalWorkingHours : 0,
tickets.Where(t => !t.Solved).Count()
);
if (UseDatabase)
{
var summaryInsert = InternalMySqlHelper.GetInsert(conn, TablePrefix + Statics.TableSummaries, ss);
Print("Insert summary ({0})", summaryInsert.ExecuteNonQuery());
}
Print("Solved tickets: {0}/{1}", ss.SolvedTickets, ss.TotalTickets);
Print("Deployed tickets: {0} ", ss.DeployedTickets);
Print("Started tickets: {0} ", ss.StartedTickets);
Print("Open 1st level tickets: {0} ", ss.Open1stLevelTickets);
Print("Open 2nd level tickets: {0} ", ss.Open2ndLevelTickets);
Print("Average Duration: {0} ", ss.AverageTicketSolveDuration);
Print("Total Costs: {0:C} ", ss.TotalCosts);
Print("Total Costs: {0:#,##0} h ", ss.TotalCosts);
Print("Average hourly wage: {0:C}", ss.AverageHourlyWage);
return(0);
}
