Files
BeWoPlaner/ReportImp/Mittelpunkt/CustomReportCreator.cs

573 lines
20 KiB
C#

using BeWo.Data.Access;
using BeWo.Data.Entities;
using BeWo.Report;
using BeWo.Report.DefaultReports;
using BeWo.Report.ReportObjects;
using BeWo.Service.DCEntityMapper;
using BeWo.Service.ServiceImplementations;
using BS.Shared.Core;
using BS.Shared.DataContracts;
using BS.Shared.Extensions;
using DevExpress.XtraReports.UI;
using System;
using System.Collections.Generic;
using System.Data;
using System.Globalization;
using System.IO;
using System.Linq;
namespace Mittelpunkt
{
public class CustomReportCreator : DefaultReportCreator
{
//public override XtraReport CreateAuslastungReport(long? employeeOid, IList<long> teamOids, DateTime startDate, DateTime endDate)
//{
// IBeWoReport<MitarbeiterauslastungRO> report;
// if (teamOids != null && teamOids.Count > 0)
// report = FindReportImp<MitarbeiterauslastungRO>("TeamauslastungNachMitarbeiter");
// else
// report = FindReportImp<MitarbeiterauslastungRO>("Mitarbeiterauslastung");
// var x = MitarbeiterauslastungRO.Create(employeeOid, teamOids, startDate, endDate);
// report.SetReportDataSource(x);
// return report as XtraReport;
//}
public override XtraReport CreateServiceOverviewAllCustomersReport(int month, int year, long orgaOid, long empOid, long? serviceCategoryOid, int startDay, int endDay)
{
List<ServicesOverviewRO> lROs = ServicesOverviewRO.Create(month, year, orgaOid, empOid, startDay, endDay, serviceCategoryOid, false);
if (lROs.Count > 0)
{
var rootReport = CreateServicesOverviewReportForRo(lROs[0], serviceCategoryOid);
if (rootReport.Pages.Count == 0)
{
rootReport.CreateDocument();
}
for (int i = 1; i < lROs.Count; i++)
{
var lNext = CreateServicesOverviewReportForRo(lROs[i], serviceCategoryOid);
if (lNext.Pages.Count == 0)
{
lNext.CreateDocument();
}
rootReport.Pages.AddRange(lNext.Pages);
}
return rootReport;
}
return new XtraReport();
}
public override XtraReport CreateServiceOverviewReportForCustomers(IList<long> customerOids, int month, int year, long? orgaOid, long? empOid, long? serviceCategoryOid, int startDay, int endDay, bool nurFehlende)
{
var roList = new List<ServicesOverviewRO>();
foreach (var coid in customerOids)
{
var ro = ServicesOverviewRO.Create(coid, month, year, false, orgaOid ?? 0, empOid ?? 0, startDay, endDay, serviceCategoryOid);
if (ro != null)
{
roList.Add(ro);
}
}
roList = roList.OrderBy(ro => ro.CustomerLastName).ToList();
if (roList.Count > 0)
{
var rootReport = CreateServicesOverviewReportForRo(roList[0], serviceCategoryOid);
rootReport.CreateDocument();
for (int i = 1; i < roList.Count; i++)
{
var lNext = CreateServicesOverviewReportForRo(roList[i], serviceCategoryOid);
lNext.CreateDocument();
rootReport.Pages.AddRange(lNext.Pages);
}
return rootReport;
}
return new XtraReport();
}
public override XtraReport CreateServiceOverviewSingleCustomerReport(long customerOid, int month, int year, long orgaOid, long empOid, long? serviceCategoryOid, int startDay, int endDay)
{
var ro = ServicesOverviewRO.Create(customerOid, month, year, false, orgaOid, empOid, startDay, endDay, serviceCategoryOid);
return CreateServicesOverviewReportForRo(ro, serviceCategoryOid);
}
private XtraReport CreateServicesOverviewReportForRo(ServicesOverviewRO ro, long? serviceCategoryOid)
{
ServicesOverviewRO flsRo = ServicesOverviewRO.CopyFromRO(ro);
ServicesOverviewRO assiRo = ServicesOverviewRO.CopyFromRO(ro);
if (ro.Services != null)
{
if (ro.Services.Count == 0)
ro.Services.Add(new ServicesOverviewRO.ServiceDetail());
foreach (ServicesOverviewRO.ServiceDetail s in ro.Services)
{
ServicesOverviewRO.CreateSignatureString(s);
if (!s.ServiceCategory.IsNullOrEmpty() && s.ServiceCategory.ToLower().Contains("assistenz"))
{
assiRo.Services.Add(s);
}
else
{
flsRo.Services.Add(s);
}
}
}
XtraReport report = null;
report = AddReportToReport<Quittierungsbeleg>(report, flsRo);
report = AddReportToReport<QuittierungsbelegAssistenz>(report, assiRo);
if (report == null)
report = new XtraReport();
return report;
}
public override XtraReport CreateReportForServicesOverviewRo(ServicesOverviewRO ro, string reportId)
{
return CreateServicesOverviewReportForRo(ro, null);
}
private XtraReport AddReportToReport<T>(XtraReport report, ServicesOverviewRO ro) where T : XtraReport, IBeWoReport<ServicesOverviewRO>, new()
{
if (ro.Services.Count > 0)
{
if (report == null)
{
report = new T();
((T)report).SetReportDataSource(ro);
}
else
{
if (report.Pages.Count == 0)
{
report.CreateDocument();
}
XtraReport newReport = new T();
((T)newReport).SetReportDataSource(ro);
newReport.CreateDocument();
report.Pages.AddRange(newReport.Pages);
}
}
return report;
}
public override XtraReport CreateEmployeeHourReport(long? employeeOid, IList<long> teamOids, DateTime startDate, DateTime endDate, int ansicht)
{
IBeWoReport<MitarbeiterstundenkontoRO> report;
if (ansicht == 1)
{
report = FindReportImp<MitarbeiterstundenkontoRO>("Mitarbeiterarbeitszeitkonto");
}
else if (ansicht == 2)
{
var reportjahr = FindReportImp<MitarbeiterstundenkontoMonateRO>("MitarbeiterstundenkontoJahr");
var jahrStart = new DateTime(startDate.Year, 1, 1);
var ds = new MitarbeiterstundenkontoMonateRO(employeeOid, teamOids, jahrStart, endDate, null);
reportjahr.SetReportDataSource(ds);
return reportjahr as XtraReport;
}
else
{
if (teamOids != null && teamOids.Count > 0)
{
report = FindReportImp<MitarbeiterstundenkontoRO>("Teamstundenkonto");
}
else
{
report = FindReportImp<MitarbeiterstundenkontoRO>("Mitarbeiterstundenkonto");
}
}
var reportObject = MitarbeiterstundenkontoRO.Create(employeeOid, teamOids, startDate, endDate, null);
report.SetReportDataSource(reportObject);
var xreport = report as XtraReport;
xreport.CreateDocument();
// Bei Tagesansicht für jeden MA eine zweite Seite erstellt werden, die alle gesammelt am Ende angefügt werden
if (ansicht == 1)
{
var reportObjectSeite2 = MitarbeiterstundenkontoRO.Create(employeeOid, teamOids, startDate, endDate, null);
IBeWoReport<MitarbeiterstundenkontoRO> report2 = new MitarbeiterarbeitszeitkontoSeite2();
report2.SetReportDataSource(reportObjectSeite2);
var xreport2 = report2 as XtraReport;
xreport2.CreateDocument();
xreport.Pages.AddRange(xreport2.Pages);
}
return xreport;
}
public override XtraReport CreateQueryReport(long queryOid, string queryReportId)
{
//if (queryOid == 4730)
//{
// var query = DAOFactory.GenericDAO.LoadByID<Query>(queryOid);
// if (query is null)
// {
// return new XtraReport();
// }
// var path = Utils.CreateSavePath(TempPath, queryReportId + ".xml");
// var table = Utils.XMLDeserialize<DataTable>(path);
// var queryReport = new GeplanteStunden();
// var queryReportObject = QueryRO.Create(query, table);
// queryReport.SetReportDataSource(queryReportObject);
// return queryReport as XtraReport;
// }
if (queryOid == 5000)
{
// nix tun, nur zur Uebersicht eingefuegt
}
else if (queryOid == 5001 || queryOid == 5002)
{
return CreateQueryReportArbeitstageMehrAls8h(queryOid, queryReportId);
}
else if (queryOid == 5005)
{
return CreateQueryReportZuschlaegeArbeit(queryOid, queryReportId);
}
//else
//{
// var query = DAOFactory.GenericDAO.LoadByID<Query>(queryOid);
// if (query is null)
// {
// return new XtraReport();
// }
// var path = Utils.CreateSavePath(TempPath, queryReportId + ".xml");
// var table = Utils.XMLDeserialize<DataTable>(path);
// var queryReport = new BeWo.Report.DefaultReports.Bericht();
// var queryReportObject = QueryRO.Create(query, table);
// queryReport.SetReportDataSource(queryReportObject);
// return queryReport as XtraReport;
//}
return base.CreateQueryReport(queryOid, queryReportId);
}
private XtraReport CreateQueryReportArbeitstageMehrAls8h(long queryOid, string queryReportId)
{
var query = DAOFactory.GenericDAO.LoadByID<Query>(queryOid);
if (query == null)
return new XtraReport();
var path = Path.Combine(TempPath, queryReportId + ".xml");
var table = Utils.XMLDeserialize<DataTable>(path);
var qro = QueryRO.Create(query, table);
if (qro.Rows.Count > 0)
{
DateTime startDate = DateTime.ParseExact(qro.Rows[0].Field1.ToString(), "yyyy-MM-dd", CultureInfo.InvariantCulture);
DateTime endDate = new DateTime(startDate.Year, 12, 31);
long? employeeOid = null;
long? teamOid = null;
if (qro.Rows[0].Field2 != null && qro.Rows[0].Field2.ToString() != "0")
{
long oid = Int64.Parse(qro.Rows[0].Field2.ToString());
if (queryOid == 5001)
employeeOid = oid;
else if (queryOid == 5002)
teamOid = oid;
}
XtraReport bericht = null;
if (employeeOid != null)
{
bericht = CreateAndAddArbeitstageMehrAls8hBericht((long)employeeOid, null, startDate, endDate);
}
else if (teamOid != null)
{
Team team = DAOFactory.GenericDAO.GetByID<Team>((long)teamOid);
if (team != null)
{
bericht = CreateAndAddArbeitstageMehrAls8hBericht(null, team.Oid, startDate, endDate);
//foreach (var employee in team.MemberList.OrderBy(e => e.Person.LastNameFirstName))
//{
// bericht = CreateAndAddArbeitstageMehrAls8hBericht((long)employee.Oid, startDate, endDate, bericht);
//}
}
}
else
{
bericht = CreateAndAddArbeitstageMehrAls8hBericht(null, null, startDate, endDate);
// kein Mitarbeiter oder Team ausgewaehlt, Bericht wird fuer alle Mitarbeiter erstellt
//var allEmployees = DAOFactory.GenericDAO.GetAllActiveAndArchived<Employee>();
//foreach (var employee in allEmployees.OrderBy(e => e.Person.LastNameFirstName))
//{
// bericht = CreateAndAddArbeitstageMehrAls8hBericht((long)employee.Oid, startDate, endDate, bericht);
//}
}
if (bericht != null)
{
return bericht;
}
}
return new XtraReport();
}
private XtraReport CreateAndAddArbeitstageMehrAls8hBericht(long? employeeOid, long? teamOid, DateTime startDate, DateTime endDate)
{
XtraReport result = null;
List<long> teamOids = null;
if (teamOid.HasValue)
{
teamOids = new List<long> { teamOid.Value };
}
MitarbeiterstundenkontoMonateRO ro = new MitarbeiterstundenkontoMonateRO(employeeOid, teamOids, startDate, endDate, null);
var msbm = new CustomMitarbeiterstundenkontoBerechnungMonate();
msbm.CreateReport(ro);
if (ro.EmployeeInfoList != null && ro.EmployeeInfoList.Count > 0)
{
foreach (var employeeInfo in ro.EmployeeInfoList)
{
var einzelRo = new MitarbeiterstundenkontoMonateRO(employeeOid, teamOids, startDate, endDate, null);
einzelRo.ReportStartDate = ro.ReportStartDate;
einzelRo.ReportEndDate = ro.ReportEndDate;
einzelRo.EmployeeInfoList.Add(employeeInfo);
var arbeitstageMehrAls8h = FindeArbeitstageMehrAls8h(employeeInfo);
if (arbeitstageMehrAls8h.Count > 0 && ro.EmployeeInfoList[0].EmployeeDetails.Count > 0)
{
einzelRo.EmployeeInfoList[0].EmployeeDetails[0].EmployeeDetail.Days = arbeitstageMehrAls8h;
var employeeBericht = new ArbeitstageMehrAls8h();
employeeBericht.SetReportDataSource(einzelRo);
employeeBericht.CreateDocument();
if (result == null)
result = employeeBericht;
else
result.Pages.AddRange(employeeBericht.Pages);
}
}
}
return result;
}
private IList<MitarbeiterstundenkontoRO.DayDetail> FindeArbeitstageMehrAls8h(MitarbeiterstundenkontoMonateRO.EmployeeInfo employeeInfo)
{
IList<MitarbeiterstundenkontoRO.DayDetail> arbeitstageMehrAls8h = new List<MitarbeiterstundenkontoRO.DayDetail>();
foreach (var employeeDetail in employeeInfo.EmployeeDetails)
{
foreach (var day in employeeDetail.EmployeeDetail.Days)
{
if (day.MinutesTotal > 480)
{
arbeitstageMehrAls8h.Add(day);
}
}
}
return arbeitstageMehrAls8h;
}
private XtraReport CreateQueryReportZuschlaegeArbeit(long queryOid, string queryReportId)
{
var query = DAOFactory.GenericDAO.LoadByID<Query>(queryOid);
if (query == null)
return new XtraReport();
var path = Path.Combine(TempPath, queryReportId + ".xml");
var table = Utils.XMLDeserialize<DataTable>(path);
var qro = QueryRO.Create(query, table);
if (qro.Rows.Count > 0)
{
DateTime startDate = DateTime.ParseExact(qro.Rows[0].Field1.ToString(), "yyyy-MM-dd", CultureInfo.InvariantCulture);
DateTime endDate = new DateTime(startDate.Year, 12, 31);
long? employeeOid = null;
if (qro.Rows[0].Field2 != null && qro.Rows[0].Field2.ToString() != "0")
{
employeeOid = Int64.Parse(qro.Rows[0].Field2.ToString());
}
IList<long> teamOids = null;
if (qro.Rows[0].Field3 != null && qro.Rows[0].Field3.ToString() != "0")
{
long teamOid = Int64.Parse(qro.Rows[0].Field3.ToString());
teamOids = new List<long>();
teamOids.Add(teamOid);
}
var allEmployees = DAOFactory.GenericDAO.GetAllActiveAndArchived<Employee>();
MitarbeiterstundenkontoRO mitarbeiterstundenkontoRO = MitarbeiterstundenkontoRO.Create(employeeOid, teamOids, startDate, endDate, null);
ZuschlaegeArbeit zuschlaegeArbeit = new ZuschlaegeArbeit();
zuschlaegeArbeit.SetReportDataSource(mitarbeiterstundenkontoRO);
zuschlaegeArbeit.CreateDocument();
return zuschlaegeArbeit;
}
return new XtraReport();
}
public override XtraReport CreateAuslastungReport(long? employeeOid, IList<long> teamOids, DateTime startDate, DateTime endDate)
{
if (teamOids != null && teamOids.Count > 0)
{
IBeWoReport<MitarbeiterauslastungRO> firstreport;
firstreport = new BeWo.Report.DefaultReports.Teamauslastung();
var firstRO = MitarbeiterauslastungRO.Create(employeeOid, teamOids, startDate, endDate);
firstreport.SetReportDataSource(firstRO);
var root = firstreport as XtraReport;
root.CreateDocument();
IBeWoReport<MitarbeiterauslastungRO> report;
report = FindReportImp<MitarbeiterauslastungRO>("Teamauslastung");
IList<long> employeeOids = new List<long>();
if (employeeOid.HasValue)
{
employeeOids.Add(employeeOid.Value);
}
var secondRO = MitarbeiterauslastungRO.Create(employeeOids, teamOids, startDate, endDate, false);
report.SetReportDataSource(secondRO);
var subreport = report as XtraReport;
subreport.CreateDocument();
root.Pages.AddRange(subreport.Pages);
return root;
}
else
{
IBeWoReport<MitarbeiterauslastungRO> report;
report = FindReportImp<MitarbeiterauslastungRO>("Mitarbeiterauslastung");
IList<long> employeeOids = new List<long>();
if (employeeOid.HasValue)
{
employeeOids.Add(employeeOid.Value);
}
var x = MitarbeiterauslastungRO.Create(employeeOids, teamOids, startDate, endDate, false);
report.SetReportDataSource(x);
return report as XtraReport;
}
}
public override XtraReport CreateRosterReportIst(long wOid, DateTime dt)
{
var opertionsService = new OperationsServiceImp();
var customerService = new CustomerServiceImp();
var employeeService = new EmployeeServiceImp();
var report = FindReportImp<RosterIstRO>();
var dienstEintraege = opertionsService.GetAllDienstEintraegeAsList(wOid, dt.Year, dt.Month);
var vertretungen = opertionsService.GetAllDienstvertretungenAsList(wOid, dt.Year, dt.Month);
List<long> employeeOids = new List<long>();
foreach (var eintrag in dienstEintraege)
{
if (!employeeOids.Contains(eintrag.EmployeeOid))
employeeOids.Add(eintrag.EmployeeOid);
}
foreach (var vertretung in vertretungen)
{
if (!employeeOids.Contains(vertretung.EmployeeOid))
employeeOids.Add(vertretung.EmployeeOid);
}
List<EmployeeDC> employee = new List<EmployeeDC>();
foreach (var oid in employeeOids)
employee.Add(MapperFactory.EmployeeDC_Employee.MapToNewDC(DAOFactory.GenericDAO.GetByID<Employee>(oid)));
List<AbsenceTimeDC> absences = employeeService.GetMultipleEmployeeAbsenceTimesForMonth(dt.Year, dt.Month, employeeOids);
List<FeiertagDC> feiertageDCs = opertionsService.ErstelleDefaultFeiertage(dt.Year).Where(f => f.Datum.Month == dt.Month).ToList();
Dictionary<long?, decimal> stundenBeiAbwesenheit = new Dictionary<long?, decimal>();
foreach (var emp in employee) // Irgendwo hier drin Fehler
{
ContractDC currentContract = null;
foreach (var c in emp.Contracts)
{
if (!c.ContractEndDate.HasValue)
{
if (dt >= c.EntryDate)
{
currentContract = c;
break;
}
}
else
{
if (dt >= c.EntryDate && dt <= c.ContractEndDate)
{
currentContract = c;
break;
}
}
}
if (currentContract != null)
{
if ((currentContract.WeeklyTotalHours == null && currentContract.MonthlyTotalHours == null) || currentContract.WeeklyDays == null)
continue;
else
{
if (currentContract.WeeklyTotalHours != null)
stundenBeiAbwesenheit.Add(emp.EmployeeOid, currentContract.WeeklyTotalHours.Value / currentContract.WeeklyDays);
else if (currentContract.MonthlyTotalHours != null)
stundenBeiAbwesenheit.Add(emp.EmployeeOid, currentContract.MonthlyTotalHours.Value / DateTime.DaysInMonth(dt.Year, dt.Month));
}
}
}
report.SetReportDataSource(RosterIstRO.Create(dienstEintraege, vertretungen, employee, opertionsService.GetAllDienste(wOid),
customerService.GetAllActiveWohnheimeCompact().First(x => x.WohnheimOid == wOid), dt.Year, dt.Month, feiertageDCs, absences, stundenBeiAbwesenheit));
return report as XtraReport;
}
}
}