public IEnumerable <TranslatedWordsReportRow> GetTranslatedWordsReport([FromBody] reportParamsDTO body)
{
TranslatedWordsReport translatedWords = new TranslatedWordsReport(Settings.GetStringDB());
return(translatedWords.GetRows(body.projectId, DateTime.Parse(body.start), DateTime.Parse(body.end),
body.user == null ? Guid.Empty : body.user.id, body.locale == null ? Guid.Empty : body.locale.id, body.volumeCalcType, body.calcBasisType));
}
public FileResult GetTranslatedWordsReportExcel([FromBody] reportParamsDTO body)
{
TranslatedWordsReport translatedWords = new TranslatedWordsReport(Settings.GetStringDB());
List <TranslatedWordsReportRow> reportRows = translatedWords.GetRows(body.projectId, DateTime.Parse(body.start), DateTime.Parse(body.end),
body.user == null ? Guid.Empty : body.user.id, body.locale == null ? Guid.Empty : body.locale.id, body.volumeCalcType, body.calcBasisType).ToList();
FileResult res;
using (ExcelPackage eP = new ExcelPackage())
{
eP.Workbook.Properties.Author = "Localization system";
eP.Workbook.Properties.Title = "Отчет по количеству переведенных слов";
eP.Workbook.Properties.Company = "Coderlink";
var sheet = eP.Workbook.Worksheets.Add("Report");
//Стили ячеек
var styleBaseTableLeft = eP.Workbook.Styles.CreateNamedStyle("BaseTableLeft");
styleBaseTableLeft.Style.Font.Name = "Arial";
styleBaseTableLeft.Style.Font.Size = 10;
styleBaseTableLeft.Style.HorizontalAlignment = ExcelHorizontalAlignment.Left;
var styleBaseTableRight = eP.Workbook.Styles.CreateNamedStyle("BaseTableRight");
styleBaseTableRight.Style.Font.Name = "Arial";
styleBaseTableRight.Style.Font.Size = 10;
styleBaseTableRight.Style.HorizontalAlignment = ExcelHorizontalAlignment.Right;
var rowNum = 1;
//Заголовок
sheet.Cells[rowNum, 1].Value = "Отчет по работам";
sheet.Cells[rowNum, 1].StyleName = styleBaseTableLeft.Name;
sheet.Cells[rowNum, 1].Style.Font.Size = 16;
sheet.Cells[rowNum, 1].Style.Font.Bold = true;
rowNum += 2;
//Отображение настроек фильтра
sheet.Cells[rowNum, 1].Value = "Диапазон дат: " + body.start.Replace('.', '-') + " - " + body.end.Replace('.', '-');
sheet.Cells[rowNum, 1].StyleName = styleBaseTableLeft.Name;
rowNum++;
sheet.Cells[rowNum, 1].Value = "Пользователь: " + (body.user != null ? body.user.Name_text : "Все пользователи");
sheet.Cells[rowNum, 1].StyleName = styleBaseTableLeft.Name;
rowNum++;
sheet.Cells[rowNum, 1].Value = "Язык: " + (body.locale != null ? body.locale.name_text : "Все языки");
sheet.Cells[rowNum, 1].StyleName = styleBaseTableLeft.Name;
rowNum++;
sheet.Cells[rowNum, 1].Value = "Вид работ: " + (body.workType != null ? body.workType.name_text : "Все");
sheet.Cells[rowNum, 1].StyleName = styleBaseTableLeft.Name;
rowNum++;
sheet.Cells[rowNum, 1].Value = "Подсчет объема по: " + (body.volumeCalcType ? "знакам с пробелами" : "словам");
sheet.Cells[rowNum, 1].StyleName = styleBaseTableLeft.Name;
rowNum++;
sheet.Cells[rowNum, 1].Value = "Основа: " + (body.calcBasisType ? "язык перевода" : "исходный язык");
sheet.Cells[rowNum, 1].StyleName = styleBaseTableLeft.Name;
rowNum += 2;
// шапка
sheet.Cells[rowNum, 1].Value = "Имя пользователя";
sheet.Cells[rowNum, 1].StyleName = styleBaseTableLeft.Name;
sheet.Cells[rowNum, 1].Style.Font.Bold = true;
sheet.Cells[rowNum, 1].Style.Border.BorderAround(ExcelBorderStyle.Thin);
sheet.Cells[rowNum, 2].Value = "Языки";
sheet.Cells[rowNum, 2].StyleName = styleBaseTableLeft.Name;
sheet.Cells[rowNum, 2].Style.Font.Bold = true;
sheet.Cells[rowNum, 2].Style.Border.BorderAround(ExcelBorderStyle.Thin);
sheet.Cells[rowNum, 3].Value = "Вид работ";
sheet.Cells[rowNum, 3].StyleName = styleBaseTableRight.Name;
sheet.Cells[rowNum, 3].Style.Font.Bold = true;
sheet.Cells[rowNum, 3].Style.Border.BorderAround(ExcelBorderStyle.Thin);
sheet.Cells[rowNum, 4].Value = "Переведено";
sheet.Cells[rowNum, 4].StyleName = styleBaseTableRight.Name;
sheet.Cells[rowNum, 4].Style.Font.Bold = true;
sheet.Cells[rowNum, 4].Style.Border.BorderAround(ExcelBorderStyle.Thin);
foreach (var row in reportRows)
{
rowNum++;
sheet.Cells[rowNum, 1].Value = row.name_text;
sheet.Cells[rowNum, 1].StyleName = styleBaseTableLeft.Name;
sheet.Cells[rowNum, 1].Style.Border.BorderAround(ExcelBorderStyle.Thin);
sheet.Cells[rowNum, 2].Value = row.language;
sheet.Cells[rowNum, 2].StyleName = styleBaseTableLeft.Name;
sheet.Cells[rowNum, 2].Style.Border.BorderAround(ExcelBorderStyle.Thin);
sheet.Cells[rowNum, 3].Value = row.work_Type;
sheet.Cells[rowNum, 3].StyleName = styleBaseTableRight.Name;
sheet.Cells[rowNum, 3].Style.Border.BorderAround(ExcelBorderStyle.Thin);
sheet.Cells[rowNum, 4].Value = row.translations;
sheet.Cells[rowNum, 4].StyleName = styleBaseTableRight.Name;
sheet.Cells[rowNum, 4].Style.Border.BorderAround(ExcelBorderStyle.Thin);
// указываем что в этой ячейке число
//sheet.Cells[row, 3].Style.Numberformat.Format = @"#,##0.00_ ;\-#,##0.00_ ;0.00_ ;";
}
var bin = eP.GetAsByteArray();
string file_type = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
string file_name = "Report.xlsx";
res = File(bin, file_type, file_name);
}
return(res);
}
