public PrintedFormsModel()
{
PartyJournal = new PartyJournalModel();
BSOFailForm13 = new BSOFailForm13Model();
BSOOperativeInformation = new BSOOperativeInformationModel();
BSOReportForm10 = new BSOReportForm10Model();
BSOReportForm10Full = new BSOReportForm10FullModel();
SMSBaseReport = new SMSBaseReportModel();
AllocationBSO = new AllocationBSOModel();
BSOMoveReportYear = new BSOMoveReportYearModel();
ScenarioForm2 = new ScenarioForm2Model();
ClientVisitReport = new ClientVisitReportModel();
SNILSReport = new SNILSReportModel();
StatusReport = new StatusReportModel();
}
public ActionResult SNILSReport(SNILSReportModel model)
{
string NameDeliveryPoint = string.Empty;
ClientVisitListModel clientVisitModel = new ClientVisitListModel();
clientVisitModel.SearchCriteriaModel.StatusDateFrom = model.DateSnilsFrom;
clientVisitModel.SearchCriteriaModel.StatusDateTo = model.DateSnilsTo;
//для Администраторов ограничений по точкам - нет
if (Role.Administrator.Id == Role.GetRealRole(CurrentUser).Id || Role.AdministratorBSO.Id == Role.GetRealRole(CurrentUser).Id)
{
if (model.DeliveryPointIds.Count > 0)
{
clientVisitModel.SearchCriteriaModel.DeliveryPointIds = model.DeliveryPointIds;
foreach (var item in model.DeliveryPointIds)
{
NameDeliveryPoint = NameDeliveryPoint + ", " + model.DeliveryPoints.Where(a => a.Value == item.ToString()).Select(b => b.Text).FirstOrDefault();
}
NameDeliveryPoint = NameDeliveryPoint.Trim(',', ' ');
}
else
{
NameDeliveryPoint = "Все точки";
}
}
else
{ //для ответственного
if (Role.ResponsibleBSO == Role.GetRealRole(CurrentUser))
{
if (model.DeliveryPointIds.Count > 0)
{
clientVisitModel.SearchCriteriaModel.DeliveryPointIds = model.DeliveryPointIds;
}
else
{//все точки для ответственного
model.DeliveryPoints = ReferencesProvider.GetDeliveryPointsForResponsibleBSO(CurrentUser.Id, false);
foreach (var item in model.DeliveryPoints)
{
if (item.Value != "")
{
model.DeliveryPointIds.Add(long.Parse(item.Value));
}
}
clientVisitModel.SearchCriteriaModel.DeliveryPointIds = model.DeliveryPointIds;
}
foreach (var item in model.DeliveryPointIds)
{
NameDeliveryPoint = NameDeliveryPoint + ", " + model.DeliveryPoints.Where(a => a.Value == item.ToString()).Select(b => b.Text).FirstOrDefault();
}
NameDeliveryPoint = NameDeliveryPoint.Trim(',', ' ');
}
else
{
//для всех остальных, только по их собственной точке
clientVisitModel.SearchCriteriaModel.DeliveryPointIds = new List <long>()
{
CurrentUser.DeliveryPoint.Id
};
model.DeliveryPointIds = new List <long>()
{
CurrentUser.DeliveryPoint.Id
};
NameDeliveryPoint = model.DeliveryPoints.Where(a => a.Value == model.DeliveryPointIds.FirstOrDefault().ToString()).Select(b => b.Text).FirstOrDefault();
}
}
ClientVisitSearchCriteria criteria = clientVisitModel.SearchCriteriaModel.GetClientSearchCriteria();
criteria.IsActualInVisitGroup = true;
List <ClientVisitInfo> clients = clientBusinessLogic.ClientVisit_Find(
criteria,
new List <SortCriteria <ClientVisitSortField> >(),
new PageRequest()
{
PageNumber = 1, PageSize = int.MaxValue
}).Data;
//Отсекаем только гр. РФ
clients = clients.Where(a => a.Citizenship == "РОССИЯ").ToList();
// Все статусы кроме: "ошибочная запись код 6", "выдан и отправлен в фонд код 11", "изготовлен другой компанией код 7", "перерегистрация завершена код 8"
clients = clients.Where(a => !(a.Status.Code == "6" ||
a.Status.Code == "11" ||
a.Status.Code == "7" ||
a.Status.Code == "8")
).ToList();
//Отсекаем по СНИЛС
//нет СНИЛС
//заявкой без СНИЛС является любая заявка, где поле СНИЛС заполнено иначе, чем XXX-XXX-XXX YY
if (model.IsSnilsNotEmpty == false)
{
clients = clients.Where(a => (string.IsNullOrEmpty(a.SNILS) || !(a.SNILS.Length == 14 && a.SNILS[3] == '-' && a.SNILS[7] == '-' && a.SNILS[11] == ' '))).ToList();
}
//есть СНИЛС
if (model.IsSnilsNotEmpty == true)
{
clients = clients.Where(a => (!string.IsNullOrEmpty(a.SNILS)) && (a.SNILS.Length == 14 && a.SNILS[3] == '-' && a.SNILS[7] == '-' && a.SNILS[11] == ' ')).ToList();
}
List <Entities.User> listUser = userBusinessLogic.Find("");
SNILSReport printedForm = new SNILSReport(clients, model.DateSnilsFrom, model.DateSnilsTo, NameDeliveryPoint, CurrentUser.Fullname,
model.IsSnilsNotEmpty, listUser);
return(File(printedForm.GetExcel(),
System.Net.Mime.MediaTypeNames.Application.Octet, string.Format("Заявки и наличие СНИЛС.xlsx")));
}
