protected void buildThisReport(XslFOProfileWriter w, ReportParams Params, IReportDataProvider Provider, object CustomData)
{
// Получим параметры
object IntervalBegin = Params.GetParam("IntervalBegin").Value;
object IntervalEnd = Params.GetParam("IntervalEnd").Value;
Guid Employee = (Guid)Params.GetParam("Employee").Value;
int NonProjectExpences = (int)Params.GetParam("NonProjectExpences").Value;
int IncludeParams = (int)Params.GetParam("IncludeParams").Value;
int AnalysDirection = (int)Params.GetParam("AnalysDirection").Value;
int TimeLossReason = (int)Params.GetParam("TimeLossReason").Value;
int SectionByActivity = (int)Params.GetParam("SectionByActivity").Value;
int ExepenseDetalization = (int)Params.GetParam("ExepenseDetalization").Value;
int TimeMeasureUnits = (int)Params.GetParam("TimeMeasureUnits").Value;
object ActivityType = Params.GetParam("ActivityType").Value;
object ExpenseType = Params.GetParam("ExpenseType").Value;
object IncidentState = Params.GetParam("IncidentState").Value;
int Sort = (int)Params.GetParam("Sort").Value;
int SortOrder = (int)Params.GetParam("SortOrder").Value;
bool bIncidentAttributes = 0 != (int)Params.GetParam("IncidentAttributes").Value;
bool bDate = 0 != (int)Params.GetParam("Date").Value;
bool bNumberOfTasks = 0 != (int)Params.GetParam("NumberOfTasks").Value;
bool bRemaining = 0 != (int)Params.GetParam("Remaining").Value;
bool bNewState = 0 != (int)Params.GetParam("NewState").Value;
bool bComment = 0 != (int)Params.GetParam("Comment").Value;
StringBuilder sb = new StringBuilder();
switch (ExepenseDetalization)
{
case (int)ExpenseDetalization.ByExpences:
bNumberOfTasks = false;
break;
case (int)ExpenseDetalization.BySubActivity:
bNewState = bComment = bIncidentAttributes = false;
break;
}
using (IDataReader r = Provider.GetDataReader("dsMain", null))
{
IDictionary headerData;
w.WriteLayoutMaster();
w.StartPageSequence();
w.StartPageBody();
sb.Append("<fo:block>Список инцидентов и затрат сотрудника</fo:block>");
if (!r.Read())
{
//TODO: EmptyBody
}
headerData = _GetDataFromDataRow(r);
IntervalBegin = headerData["IntervalBegin"];
IntervalEnd = headerData["IntervalEnd"];
// Создадим заголовок
if (0 != IncludeParams)
{
sb.Append("<fo:block/>");
sb.Append("<fo:block font-size='14px'>Параметры отчета:</fo:block>");
sb.Append("<fo:table color='#FFFFFF' text-align='left' font-size='12px' font-family='MS Sans-serif'>");
sb.Append("<fo:table-column/>");
sb.Append("<fo:table-column/>");
sb.Append("<fo:table-body>");
sb.Append("<fo:table-row>");
sb.Append("<fo:table-cell width='35%'><fo:block>Направление анализа:</fo:block></fo:table-cell>");
sb.Append("<fo:table-cell><fo:block>" + xmlEncode(headerData["AnalysDirection"]) + "</fo:block></fo:table-cell>");
sb.Append("</fo:table-row>");
sb.Append("<fo:table-row>");
sb.Append("<fo:table-cell width='35%'><fo:block>Период времени:</fo:block></fo:table-cell>");
sb.Append("<fo:table-cell><fo:block>" + xmlEncode(headerData["DateInterval"]) + "</fo:block></fo:table-cell>");
sb.Append("</fo:table-row>");
sb.Append("<fo:table-row>");
sb.Append("<fo:table-cell width='35%'><fo:block>Сотрудник:</fo:block></fo:table-cell>");
sb.Append("<fo:table-cell><fo:block><fo:basic-link color=\"#ffffff\" external-destination=\"vbscript:ShowContextForEmployeeLite("" + Employee + "","" + xmlEncode(headerData["EMail"]) + "")\">" + headerData["EmployeeName"] + "</fo:basic-link></fo:block></fo:table-cell>");
sb.Append("</fo:table-row>");
sb.Append("<fo:table-row>");
sb.Append("<fo:table-cell width='35%'><fo:block>Тип активности:</fo:block></fo:table-cell>");
sb.Append("<fo:table-cell><fo:block>" + xmlEncode(headerData["ActivityType"]) + "</fo:block></fo:table-cell>");
sb.Append("</fo:table-row>");
sb.Append("<fo:table-row>");
sb.Append("<fo:table-cell width='35%'><fo:block>Детализация затрат:</fo:block></fo:table-cell>");
sb.Append("<fo:table-cell><fo:block>" + xmlEncode(headerData["ExepenseDetalization"]) + "</fo:block></fo:table-cell>");
sb.Append("</fo:table-row>");
sb.Append("<fo:table-row>");
sb.Append("<fo:table-cell width='35%'><fo:block>Вид трудозатрат:</fo:block></fo:table-cell>");
sb.Append("<fo:table-cell><fo:block>" + xmlEncode(headerData["ExpenseType"]) + "</fo:block></fo:table-cell>");
sb.Append("</fo:table-row>");
sb.Append("<fo:table-row>");
sb.Append("<fo:table-cell width='35%'><fo:block>Состояние инцидента:</fo:block></fo:table-cell>");
sb.Append("<fo:table-cell><fo:block>" + xmlEncode(headerData["IncidentState"]) + "</fo:block></fo:table-cell>");
sb.Append("</fo:table-row>");
sb.Append("<fo:table-row>");
sb.Append("<fo:table-cell width='35%'><fo:block>Единицы измерения времени:</fo:block></fo:table-cell>");
sb.Append("<fo:table-cell><fo:block>" + xmlEncode(TimeMeasureUnitsItem.GetItem((Croc.IncidentTracker.TimeMeasureUnits)TimeMeasureUnits).Description) + "</fo:block></fo:table-cell>");
sb.Append("</fo:table-row>");
sb.Append("<fo:table-row>");
sb.Append("<fo:table-cell width='35%'><fo:block> </fo:block></fo:table-cell>");
sb.Append("<fo:table-cell><fo:block>" + xmlEncode(headerData["NonProjectExpences"]) + "</fo:block></fo:table-cell>");
sb.Append("</fo:table-row>");
sb.Append("</fo:table-body>");
sb.Append("</fo:table>");
}
int nActivityColspan = 9;
int nWorkDayDuration = (int)headerData["WorkDayDuration"];
int nReportWorkDayDuration = TimeMeasureUnits == (int)IncidentTracker.TimeMeasureUnits.Hours?int.MaxValue:nWorkDayDuration;
w.Header(sb.ToString());
int nRowNum = 0;
if (!r.NextResult())
{
throw new ApplicationException("Отсутствует основной рекордсет");
}
nActivityColspan = 9;
w.TStart(0 == SectionByActivity, "CELL_CLASS", false);
w.TAddColumn("№ п/п", align.ALIGN_RIGHT, valign.VALIGN_MIDDLE, null, String.Empty, align.ALIGN_NONE, valign.VALIGN_NONE, "TABLE_HEADER");
if (bIncidentAttributes)
{
w.TAddColumn("Причина списания", align.ALIGN_LEFT, valign.VALIGN_MIDDLE, null, String.Empty, align.ALIGN_NONE, valign.VALIGN_NONE, "TABLE_HEADER");
}
else
{
--nActivityColspan;
}
w.TAddColumn("Наименование активности", align.ALIGN_LEFT, valign.VALIGN_MIDDLE, null, String.Empty, align.ALIGN_NONE, valign.VALIGN_NONE, "TABLE_HEADER");
if (bDate)
{
w.TAddColumn("Дата", align.ALIGN_CENTER, valign.VALIGN_MIDDLE, null, String.Empty, align.ALIGN_NONE, valign.VALIGN_NONE, "TABLE_HEADER");
}
else
{
--nActivityColspan;
}
int nTotalColspan = nActivityColspan - 5 - 1;
if (bNumberOfTasks)
{
w.TAddColumn("Кол-во заданий", align.ALIGN_RIGHT, valign.VALIGN_MIDDLE, null, String.Empty, align.ALIGN_NONE, valign.VALIGN_NONE, "TABLE_HEADER");
}
else
{
--nActivityColspan;
}
w.TAddColumn("Затрачено/Списано", align.ALIGN_CENTER, valign.VALIGN_MIDDLE, null, String.Empty, align.ALIGN_NONE, valign.VALIGN_NONE, "TABLE_HEADER");
if (bRemaining)
{
w.TAddColumn("Осталось", align.ALIGN_CENTER, valign.VALIGN_MIDDLE, null, String.Empty, align.ALIGN_NONE, valign.VALIGN_NONE, "TABLE_HEADER");
}
else
{
--nActivityColspan;
}
if (bNewState)
{
w.TAddColumn(ExepenseDetalization == (int)ExpenseDetalization.ByExpences ? "Новое состояние" : "Состояние", align.ALIGN_LEFT, valign.VALIGN_MIDDLE, null, String.Empty, align.ALIGN_NONE, valign.VALIGN_NONE, "TABLE_HEADER");
}
else
{
--nActivityColspan;
}
if (bComment)
{
w.TAddColumn("Комментарии", align.ALIGN_LEFT, valign.VALIGN_MIDDLE, null, String.Empty, align.ALIGN_NONE, valign.VALIGN_NONE, "TABLE_HEADER");
}
else
{
--nActivityColspan;
}
Guid currentTopActivityID = Guid.Empty;
int totalSpent = 0;
int totalLeft = 0;
int totalTasks = 0;
int totalLost = 0;
int totalSpentPerActivity = 0;
int totalLeftPerActivity = 0;
int totalTasksPerActivity = 0;
int previousCauseType = -1;
int nCauseType = -1;
while (r.Read())
{
IDictionary rec = _GetDataFromDataRow(r);
previousCauseType = nCauseType;
nCauseType = (int)rec["CauseType"];
bool bMergeIncidentAttributes = (3 == nCauseType) && bIncidentAttributes;
if (0 != SectionByActivity)
{
Guid topActivityID = (Guid)rec["topFolder"];
if (currentTopActivityID != topActivityID)
{
if (currentTopActivityID != Guid.Empty)
{
w.TRStart();
w.TRAddCell(" ", null);
w.TRAddCell(previousCauseType == 3?"Всего по непроектным списаниям":"Всего по активности:", null, nTotalColspan, 1);
if (bNumberOfTasks)
{
w.TRAddCell(totalTasksPerActivity, "i4");
}
w.TRAddCell(this._FormatTimeStringAtServer(totalSpentPerActivity, nReportWorkDayDuration), null);
if (bRemaining)
{
w.TRAddCell(this._FormatTimeStringAtServer(totalLeftPerActivity, nReportWorkDayDuration), null);
}
if (bNewState)
{
w.TRAddCell(" ", null);
}
if (bComment)
{
w.TRAddCell(" ", null);
}
w.TREnd();
totalSpentPerActivity = 0;
totalLeftPerActivity = 0;
totalTasksPerActivity = 0;
}
currentTopActivityID = topActivityID;
w.TRStart();
w.TROmitCell();
w.TRAddCell(3 == nActivityColspan?xmlEncode(rec["topName"]):this._GetFolderAnchor(rec["topName"], (Guid)rec["ActivityID"], Employee, true, IntervalBegin != null?(DateTime)IntervalBegin:DateTime.MinValue, IntervalEnd != null?(DateTime)IntervalEnd:DateTime.MaxValue), null, nActivityColspan, 1, "TABLE_HEADER");
w.TREnd();
w.TRStart();
w.TRAddCell("№ п/п", null, 1, 1, "TABLE_HEADER");
if (bIncidentAttributes)
{
w.TRAddCell("Причина списания", null, bMergeIncidentAttributes?2:1, 1, "TABLE_HEADER");
}
if (!bMergeIncidentAttributes)
{
w.TRAddCell(3 == nCauseType?"Причина списания":"Наименование активности", null, 1, 1, "TABLE_HEADER");
}
if (bDate)
{
w.TRAddCell("Дата", null, 1, 1, "TABLE_HEADER");
}
if (bNumberOfTasks)
{
w.TRAddCell(3 == nCauseType?"Кол-во списаний":"Кол-во заданий", null, 1, 1, "TABLE_HEADER");
}
w.TRAddCell(3 == nCauseType?"Списано":"Затрачено/Списано", null, 1, 1, "TABLE_HEADER");
if (bRemaining)
{
w.TRAddCell("Осталось", null, 1, 1, "TABLE_HEADER");
}
if (bNewState)
{
w.TRAddCell("Новое состояние", null, 1, 1, "TABLE_HEADER");
}
if (bComment)
{
w.TRAddCell("Комментарии", null, 1, 1, "TABLE_HEADER");
}
w.TREnd();
}
}
if (3 == nCauseType || 4 == nCauseType)
{
totalLost += (int)rec["Spent"];
}
else
{
totalSpent += (int)rec["Spent"];
}
totalSpentPerActivity += (int)rec["Spent"];
totalTasks += (3 == nCauseType ? 0 : (null != rec["NumberOfTasks"]?(int)rec["NumberOfTasks"]:0));
totalTasksPerActivity += ((1 != nCauseType && 2 != nCauseType)? 0 : null != rec["NumberOfTasks"]? (int)rec["NumberOfTasks"] : 0);
totalLeft += 3 == nCauseType?0:(null != rec["LeftTime"]?(int)rec["LeftTime"]:0);
totalLeftPerActivity += 3 == nCauseType?0:(null != rec["LeftTime"]?(int)rec["LeftTime"]:0);
w.TRStart();
w.TRAddCell(++nRowNum, "i4");
if (bIncidentAttributes)
{
w.TRAddCell(
1 == nCauseType? // только для инцидентов
this._GetIncidentAnchor(rec["CauseName"], (Guid)rec["CauseID"], true) :
xmlEncode(rec["CauseName"]),
null,
bMergeIncidentAttributes? 2 : 1,
1);
}
if (!bMergeIncidentAttributes)
{
if (3 != nCauseType)
{
w.TRAddCell(this._GetFolderAnchor(rec["ActivityName"], (Guid)rec["ActivityID"], Employee, true, IntervalBegin != null?(DateTime)IntervalBegin : DateTime.MinValue, IntervalEnd != null?(DateTime)IntervalEnd:DateTime.MaxValue), null);
}
else
{
w.TRAddCell(xmlEncode(rec["ActivityName"]), null);
}
}
if (bDate)
{
w.TRAddCell(xmlEncode(rec["DateSpent"]), null);
}
if (bNumberOfTasks)
{
// Кол-во инцидентов показваем только для инцидентов или проектов
if (1 == nCauseType || 2 == nCauseType)
{
w.TRAddCell("" + rec["NumberOfTasks"], "i4");
}
else
{
w.TRAddCell(" - ", "string");
}
}
w.TRAddCell(this._FormatTimeStringAtServer((int)rec["Spent"], nReportWorkDayDuration), null);
if (bRemaining)
{
object objLeftTime = rec["LeftTime"];
w.TRAddCell(objLeftTime == null?string.Empty:this._FormatTimeStringAtServer((int)objLeftTime, nReportWorkDayDuration), null);
}
if (bNewState)
{
w.TRAddCell(xmlEncode(rec["NewState"]), null);
}
if (bComment)
{
w.TRAddCell(xmlEncode(rec["Comments"]), null);
}
w.TREnd();
}
if (0 != SectionByActivity && currentTopActivityID != Guid.Empty)
{
w.TRStart();
w.TRAddCell(" ", null);
w.TRAddCell(nCauseType == 3?"Всего по непроектным списаниям":"Всего по активности:", null, nTotalColspan, 1);
if (bNumberOfTasks)
{
w.TRAddCell(totalTasksPerActivity, "i4");
}
w.TRAddCell(this._FormatTimeStringAtServer(totalSpentPerActivity, nReportWorkDayDuration), null);
if (bRemaining)
{
w.TRAddCell(this._FormatTimeStringAtServer(totalLeftPerActivity, nReportWorkDayDuration), null);
}
if (bNewState)
{
w.TRAddCell(" ", null);
}
if (bComment)
{
w.TRAddCell(" ", null);
}
w.TREnd();
}
// Итого
if ((int)ExpencesType.Both == (int)ExpenseType || (int)ExpencesType.Incidents == (int)ExpenseType)
{
w.TRStart();
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
w.TRAddCell("Итого затрачено на задания по инцидентам", null, nTotalColspan, 1, "TABLE_HEADER");
if (bNumberOfTasks)
{
w.TRAddCell(totalTasks, "i4", 1, 1, "TABLE_HEADER");
}
w.TRAddCell(this._FormatTimeStringAtServer(totalSpent, nReportWorkDayDuration), null, 1, 1, "TABLE_HEADER");
if (bRemaining)
{
w.TRAddCell(this._FormatTimeStringAtServer(totalLeft, nReportWorkDayDuration), null, 1, 1, "TABLE_HEADER");
}
if (bNewState)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
if (bComment)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
w.TREnd();
}
if ((int)ExpencesType.Both == (int)ExpenseType || (int)ExpencesType.Discarding == (int)ExpenseType)
{
w.TRStart();
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
w.TRAddCell("Итого списано ", null, nTotalColspan, 1, "TABLE_HEADER");
if (bNumberOfTasks)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
w.TRAddCell(this._FormatTimeStringAtServer(totalLost, nReportWorkDayDuration), null, 1, 1, "TABLE_HEADER");
if (bRemaining)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
if (bNewState)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
if (bComment)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
w.TREnd();
}
if ((int)ExpencesType.Both == (int)ExpenseType)
{
w.TRStart();
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
w.TRAddCell("Общие трудозатраты ", null, nTotalColspan, 1, "TABLE_HEADER");
if (bNumberOfTasks)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
w.TRAddCell(this._FormatTimeStringAtServer(totalLost + totalSpent, nReportWorkDayDuration), null, 1, 1, "TABLE_HEADER");
if (bRemaining)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
if (bNewState)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
if (bComment)
{
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
}
w.TREnd();
}
w.TRStart();
w.TRAddCell(" ", null, 1, 1, "TABLE_HEADER");
w.TRAddCell(xmlEncode(string.Format("Всего рабочих дней за период - {0}, Норма рабочего времени за период - {1}", headerData["WorkDays"], this._FormatTimeStringAtServer((int)headerData["WorkDays"] * nWorkDayDuration, int.MaxValue))), null, nActivityColspan - 1, 1, "TABLE_HEADER");
w.TREnd();
w.TEnd();
w.EndPageBody();
w.EndPageSequence();
}
}