1249 lines
83 KiB
C#
1249 lines
83 KiB
C#
using System.Collections.Generic;
|
|
using System.IO;
|
|
using System.Linq;
|
|
using FastReport;
|
|
using FastReport.Export.OoXML;
|
|
using FastReport.Export.Pdf;
|
|
using Microsoft.AspNetCore.Mvc;
|
|
using rmutr_report.Models;
|
|
using rmutr_report.Models.Personnel;
|
|
using Swashbuckle.AspNetCore.Annotations;
|
|
|
|
namespace rmutr_report.Controllers
|
|
{
|
|
[SwaggerTag("สำหรับรายงานบุคลากร")]
|
|
public class PersonnelReport : Controller
|
|
{
|
|
readonly Setting _setting;
|
|
|
|
public PersonnelReport(Setting setting)
|
|
{
|
|
_setting = setting;
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_1/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel1Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Sum(d => d.value_2);
|
|
var sum3 = personnelReport1.personnel_report_detail.Sum(d => d.value_3);
|
|
var sum4 = personnelReport1.personnel_report_detail.Sum(d => d.value_4);
|
|
var sum5 = personnelReport1.personnel_report_detail.Sum(d => d.value_5);
|
|
var sum6 = personnelReport1.personnel_report_detail.Sum(d => d.value_6);
|
|
var sum7 = personnelReport1.personnel_report_detail.Sum(d => d.value_7);
|
|
var sum8 = personnelReport1.personnel_report_detail.Sum(d => d.value_8);
|
|
var sum9 = personnelReport1.personnel_report_detail.Sum(d => d.value_9);
|
|
var sum10 = personnelReport1.personnel_report_detail.Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Sum(d => d.value_11);
|
|
var sum12 = personnelReport1.personnel_report_detail.Sum(d => d.value_12);
|
|
var sum13 = personnelReport1.personnel_report_detail.Sum(d => d.value_13);
|
|
var sum14 = personnelReport1.personnel_report_detail.Sum(d => d.value_14);
|
|
var sum15 = personnelReport1.personnel_report_detail.Sum(d => d.value_15);
|
|
var sum16 = personnelReport1.personnel_report_detail.Sum(d => d.value_16);
|
|
var sum17 = personnelReport1.personnel_report_detail.Sum(d => d.value_17);
|
|
var sum18 = personnelReport1.personnel_report_detail.Sum(d => d.value_18);
|
|
var sum19 = personnelReport1.personnel_report_detail.Sum(d => d.value_19);
|
|
var sum20 = personnelReport1.personnel_report_detail.Sum(d => d.value_20);
|
|
var sum21 = personnelReport1.personnel_report_detail.Sum(d => d.value_21);
|
|
var sum22 = personnelReport1.personnel_report_detail.Sum(d => d.value_22);
|
|
var sum23 = personnelReport1.personnel_report_detail.Sum(d => d.value_23);
|
|
var sum24 = personnelReport1.personnel_report_detail.Sum(d => d.value_24);
|
|
var sum25 = personnelReport1.personnel_report_detail.Sum(d => d.value_25);
|
|
var sum26 = personnelReport1.personnel_report_detail.Sum(d => d.value_26);
|
|
var sum27 = personnelReport1.personnel_report_detail.Sum(d => d.value_27);
|
|
var sum28 = personnelReport1.personnel_report_detail.Sum(d => d.value_28);
|
|
personnelReport1.value_1 = sum1;
|
|
personnelReport1.value_2 = sum2;
|
|
personnelReport1.value_3 = sum3;
|
|
personnelReport1.value_4 = sum4;
|
|
personnelReport1.value_5 = sum5;
|
|
personnelReport1.value_6 = sum6;
|
|
personnelReport1.value_7 = sum7;
|
|
personnelReport1.value_8 = sum8;
|
|
personnelReport1.value_9 = sum9;
|
|
personnelReport1.value_10 = sum10;
|
|
personnelReport1.value_11 = sum11;
|
|
personnelReport1.value_12 = sum12;
|
|
personnelReport1.value_13 = sum13;
|
|
personnelReport1.value_14 = sum14;
|
|
personnelReport1.value_15 = sum15;
|
|
personnelReport1.value_16 = sum16;
|
|
personnelReport1.value_17 = sum17;
|
|
personnelReport1.value_18 = sum18;
|
|
personnelReport1.value_19 = sum19;
|
|
personnelReport1.value_20 = sum20;
|
|
personnelReport1.value_21 = sum21;
|
|
personnelReport1.value_22 = sum22;
|
|
personnelReport1.value_23 = sum23;
|
|
personnelReport1.value_24 = sum2 + sum9 + sum15 + sum20;
|
|
personnelReport1.value_25 = sum25;
|
|
personnelReport1.value_26 = sum4 + sum13 + sum17 + sum22;
|
|
personnelReport1.value_27 = sum27;
|
|
personnelReport1.value_28 = personnelReport1.value_24 + personnelReport1.value_26;
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_1.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport1" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_2/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel2Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_1);
|
|
var sum_1 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_2);
|
|
var sum_2 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_2);
|
|
var sum3 = personnelReport1.personnel_report_detail.Sum(d => d.value_3);
|
|
var sum4 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_4);
|
|
var sum_4 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_4);
|
|
var sum5 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_5);
|
|
var sum_5 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_5);
|
|
var sum6 = personnelReport1.personnel_report_detail.Sum(d => d.value_6);
|
|
var sum7 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_7);
|
|
var sum_7 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_7);
|
|
var sum8 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_8);
|
|
var sum_8 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_8);
|
|
var sum9 = personnelReport1.personnel_report_detail.Sum(d => d.value_9);
|
|
var sum10 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_10);
|
|
var sum_10 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_11);
|
|
var sum_11 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_11);
|
|
var sum12 = personnelReport1.personnel_report_detail.Sum(d => d.value_12);
|
|
var sum13 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_13);
|
|
var sum_13 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_13);
|
|
var sum14 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_14);
|
|
var sum_14 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_14);
|
|
var sum15 = personnelReport1.personnel_report_detail.Sum(d => d.value_15);
|
|
var sum16 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_16);
|
|
var sum_16 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_16);
|
|
var sum17 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 1).Sum(d => d.value_17);
|
|
var sum_17 = personnelReport1.personnel_report_detail.Where(f => f.topic_type == 4).Sum(d => d.value_17);
|
|
var sum18 = personnelReport1.personnel_report_detail.Sum(d => d.value_18);
|
|
|
|
personnelReport1.value_1 = sum1 + sum_1;
|
|
personnelReport1.value_2 = sum2 + sum_2;
|
|
personnelReport1.value_3 = personnelReport1.value_1 + personnelReport1.value_2;
|
|
personnelReport1.value_4 = sum4 + sum_4;
|
|
personnelReport1.value_5 = sum5 + sum_5;
|
|
personnelReport1.value_6 = personnelReport1.value_4 + personnelReport1.value_5;
|
|
personnelReport1.value_7 = sum7 + sum_7;
|
|
personnelReport1.value_8 = sum8 + sum_8;
|
|
personnelReport1.value_9 = personnelReport1.value_7 + personnelReport1.value_8;
|
|
personnelReport1.value_10 = sum10 + sum_10;
|
|
personnelReport1.value_11 = sum11 + sum_11;
|
|
personnelReport1.value_12 = personnelReport1.value_10 + personnelReport1.value_11;
|
|
personnelReport1.value_13 = sum13 + sum_13;
|
|
personnelReport1.value_14 = sum14 + sum_14;
|
|
personnelReport1.value_15 = personnelReport1.value_13 + personnelReport1.value_14;
|
|
personnelReport1.value_16 = sum16 + sum_16;
|
|
personnelReport1.value_17 = sum17 + sum_17;
|
|
personnelReport1.value_18 = personnelReport1.value_16 + personnelReport1.value_17;
|
|
|
|
foreach (var detail in personnelReport1.personnel_report_detail)
|
|
{
|
|
if (detail.topic_type == 3)
|
|
{
|
|
detail.topic = "- " + detail.topic;
|
|
}
|
|
}
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_2.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport2" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_3/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel3Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_1);
|
|
var sum1_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_1);
|
|
var sum1_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_2);
|
|
var sum2_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_2);
|
|
var sum2_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_2);
|
|
var sum5 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_5);
|
|
var sum5_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_5);
|
|
var sum5_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_5);
|
|
var sum4 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_4);
|
|
var sum4_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_4);
|
|
var sum4_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_4);
|
|
var sum7 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_7);
|
|
var sum7_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_7);
|
|
var sum7_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_7);
|
|
var sum8 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_8);
|
|
var sum8_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_8);
|
|
var sum8_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_8);
|
|
var sum10 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_10);
|
|
var sum10_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_10);
|
|
var sum10_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_11);
|
|
var sum11_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_11);
|
|
var sum11_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_11);
|
|
var sum13 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_13);
|
|
var sum13_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_13);
|
|
var sum13_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_13);
|
|
var sum14 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_14);
|
|
var sum14_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_14);
|
|
var sum14_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_14);
|
|
|
|
|
|
personnelReport1.value_1 = sum1 + sum1_1 + sum1_2;
|
|
personnelReport1.value_2 = sum2 + sum2_1 + sum2_2;
|
|
personnelReport1.value_3 = personnelReport1.value_1 + personnelReport1.value_2;
|
|
personnelReport1.value_4 = sum4 + sum4_1 + sum4_2;
|
|
personnelReport1.value_5 = sum5 + sum5_1 + sum5_2;
|
|
personnelReport1.value_6 = personnelReport1.value_4 + personnelReport1.value_5;
|
|
personnelReport1.value_7 = sum7 + sum7_1 + sum7_2;
|
|
personnelReport1.value_8 = sum8 + sum8_1 + sum8_2;
|
|
personnelReport1.value_9 = personnelReport1.value_7 + personnelReport1.value_8;
|
|
personnelReport1.value_10 = sum10 + sum10_1 + sum10_2;
|
|
personnelReport1.value_11 = sum11 + sum11_1 + sum11_2;
|
|
personnelReport1.value_12 = personnelReport1.value_10 + personnelReport1.value_11;
|
|
personnelReport1.value_13 = sum13 + sum13_1 + sum13_2;
|
|
personnelReport1.value_14 = sum14 + sum14_1 + sum14_2;
|
|
personnelReport1.value_15 = personnelReport1.value_13 + personnelReport1.value_14;
|
|
|
|
|
|
foreach (var detail in personnelReport1.personnel_report_detail)
|
|
{
|
|
if (detail.topic_type == 4)
|
|
{
|
|
detail.topic = "- " + detail.topic;
|
|
}
|
|
}
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_3.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport3" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_4/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel4Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 2).Sum(d => d.value_1);
|
|
var sum1_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 2).Sum(d => d.value_2);
|
|
var sum2_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_2);
|
|
var sum3 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 2).Sum(d => d.value_3);
|
|
var sum3_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_3);
|
|
|
|
|
|
personnelReport1.value_1 = sum1 + sum1_1;
|
|
personnelReport1.value_2 = sum2 + sum2_1;
|
|
personnelReport1.value_3 = sum3 + sum3_1;
|
|
personnelReport1.value_4 = personnelReport1.value_1 + personnelReport1.value_2 + personnelReport1.value_3;
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_4.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport4" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_5/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel5Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Sum(d => d.value_2);
|
|
var sum3 = personnelReport1.personnel_report_detail.Sum(d => d.value_3);
|
|
var sum4 = personnelReport1.personnel_report_detail.Sum(d => d.value_4);
|
|
var sum5 = personnelReport1.personnel_report_detail.Sum(d => d.value_5);
|
|
var sum6 = personnelReport1.personnel_report_detail.Sum(d => d.value_6);
|
|
var sum7 = personnelReport1.personnel_report_detail.Sum(d => d.value_7);
|
|
var sum8 = personnelReport1.personnel_report_detail.Sum(d => d.value_8);
|
|
var sum9 = personnelReport1.personnel_report_detail.Sum(d => d.value_9);
|
|
var sum10 = personnelReport1.personnel_report_detail.Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Sum(d => d.value_11);
|
|
personnelReport1.value_1 = sum1;
|
|
personnelReport1.value_2 = sum2;
|
|
personnelReport1.value_3 = sum3;
|
|
personnelReport1.value_4 = sum4;
|
|
personnelReport1.value_5 = sum5;
|
|
personnelReport1.value_6 = sum6;
|
|
personnelReport1.value_7 = sum7;
|
|
personnelReport1.value_8 = sum8;
|
|
personnelReport1.value_9 = sum9;
|
|
personnelReport1.value_10 = sum10;
|
|
personnelReport1.value_11 = sum11;
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_5.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport5" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_6/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel6Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_1);
|
|
var sum1_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_2);
|
|
var sum2_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_2);
|
|
var sum3 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_3);
|
|
var sum3_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_3);
|
|
var sum5 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_5);
|
|
var sum5_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_5);
|
|
var sum6 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_6);
|
|
var sum6_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_6);
|
|
var sum7 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_7);
|
|
var sum7_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_7);
|
|
var sum9 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_9);
|
|
var sum9_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_9);
|
|
var sum10 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_10);
|
|
var sum10_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_11);
|
|
var sum11_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_11);
|
|
var sum13 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_13);
|
|
var sum13_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_13);
|
|
var sum14 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_14);
|
|
var sum14_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_14);
|
|
var sum15 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_15);
|
|
var sum15_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_15);
|
|
|
|
|
|
personnelReport1.value_1 = sum1 + sum1_1;
|
|
personnelReport1.value_2 = sum2 + sum2_1;
|
|
personnelReport1.value_3 = sum3 + sum3_1;
|
|
personnelReport1.value_4 = personnelReport1.value_1 + personnelReport1.value_2 + personnelReport1.value_3;
|
|
personnelReport1.value_5 = sum5 + sum5_1;
|
|
personnelReport1.value_6 = sum6 + sum6_1;
|
|
personnelReport1.value_7 = sum7 + sum7_1;
|
|
personnelReport1.value_8 = personnelReport1.value_5 + personnelReport1.value_6 + personnelReport1.value_7;
|
|
personnelReport1.value_9 = sum9 + sum9_1;
|
|
personnelReport1.value_10 = sum10 + sum10_1;
|
|
personnelReport1.value_11 = sum11 + sum11_1;
|
|
personnelReport1.value_12 =
|
|
personnelReport1.value_9 + personnelReport1.value_10 + personnelReport1.value_11;
|
|
personnelReport1.value_13 = sum13 + sum13_1;
|
|
personnelReport1.value_14 = sum14 + sum14_1;
|
|
personnelReport1.value_15 = sum15 + sum15_1;
|
|
personnelReport1.value_16 =
|
|
personnelReport1.value_13 + personnelReport1.value_14 + personnelReport1.value_15;
|
|
foreach (var detail in personnelReport1.personnel_report_detail)
|
|
{
|
|
if (detail.topic_type == 2)
|
|
{
|
|
detail.topic = " " + detail.topic;
|
|
}
|
|
}
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_6.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport6" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_7/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel7Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_1);
|
|
var sum1_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_2);
|
|
var sum2_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_2);
|
|
|
|
var sum4 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_4);
|
|
var sum4_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_4);
|
|
var sum5 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_5);
|
|
var sum5_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_5);
|
|
var sum7 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_7);
|
|
var sum7_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_7);
|
|
var sum8 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_8);
|
|
var sum8_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_8);
|
|
var sum10 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_10);
|
|
var sum10_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_11);
|
|
var sum11_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 3).Sum(d => d.value_11);
|
|
|
|
personnelReport1.value_1 = sum1 + sum1_1;
|
|
personnelReport1.value_2 = sum2 + sum2_1;
|
|
personnelReport1.value_3 = personnelReport1.value_1 + personnelReport1.value_2;
|
|
personnelReport1.value_4 = sum4 + sum4_1;
|
|
personnelReport1.value_5 = sum5 + sum5_1;
|
|
personnelReport1.value_6 = personnelReport1.value_4 + personnelReport1.value_5;
|
|
personnelReport1.value_7 = sum7 + sum7_1;
|
|
personnelReport1.value_8 = sum8 + sum8_1;
|
|
personnelReport1.value_9 = personnelReport1.value_7 + personnelReport1.value_8;
|
|
personnelReport1.value_10 = sum10 + sum10_1;
|
|
personnelReport1.value_11 = sum11 + sum11_1;
|
|
personnelReport1.value_12 = personnelReport1.value_10 + personnelReport1.value_11;
|
|
|
|
foreach (var detail in personnelReport1.personnel_report_detail)
|
|
{
|
|
if (detail.topic_type == 2)
|
|
{
|
|
detail.topic = " " + detail.topic;
|
|
}
|
|
}
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_7.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport7" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_8/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel8Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_1);
|
|
var sum1_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_1);
|
|
var sum1_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_2);
|
|
var sum2_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_2);
|
|
var sum2_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_2);
|
|
var sum3 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_3);
|
|
var sum3_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_3);
|
|
var sum3_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_3);
|
|
var sum5 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_5);
|
|
var sum5_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_5);
|
|
var sum5_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_5);
|
|
var sum6 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_6);
|
|
var sum6_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_6);
|
|
var sum6_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_6);
|
|
var sum7 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_7);
|
|
var sum7_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_7);
|
|
var sum7_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_7);
|
|
|
|
var sum9 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_9);
|
|
var sum9_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_9);
|
|
var sum9_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_9);
|
|
var sum10 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_10);
|
|
var sum10_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_10);
|
|
var sum10_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_11);
|
|
var sum11_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_11);
|
|
var sum11_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_11);
|
|
var sum13 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_13);
|
|
var sum13_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_13);
|
|
var sum13_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_13);
|
|
var sum14 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_14);
|
|
var sum14_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_14);
|
|
var sum14_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_14);
|
|
|
|
var sum16 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_16);
|
|
var sum16_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_16);
|
|
var sum16_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_16);
|
|
var sum17 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_17);
|
|
var sum17_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_17);
|
|
var sum17_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_17);
|
|
var sum18 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_18);
|
|
var sum18_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_18);
|
|
var sum18_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_18);
|
|
|
|
var sum20 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_20);
|
|
var sum20_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_20);
|
|
var sum20_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_20);
|
|
var sum21 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_21);
|
|
var sum21_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_21);
|
|
var sum21_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_21);
|
|
var sum22 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_22);
|
|
var sum22_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_22);
|
|
var sum22_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_22);
|
|
var sum23 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_23);
|
|
var sum23_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_23);
|
|
var sum23_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_23);
|
|
|
|
personnelReport1.value_1 = sum1 + sum1_1 + sum1_2;
|
|
personnelReport1.value_2 = sum2 + sum2_1 + sum2_2;
|
|
personnelReport1.value_3 = sum3 + sum3_1 + sum3_2;
|
|
personnelReport1.value_4 = personnelReport1.value_1 + personnelReport1.value_2 + personnelReport1.value_3;
|
|
personnelReport1.value_5 = sum5 + sum5_1 + sum5_2;
|
|
personnelReport1.value_6 = sum6 + sum6_1 + sum6_2;
|
|
personnelReport1.value_7 = sum7 + sum7_1 + sum7_2;
|
|
personnelReport1.value_8 = personnelReport1.value_5 + personnelReport1.value_6 + personnelReport1.value_7;
|
|
personnelReport1.value_9 = sum9 + sum9_1 + sum9_2;
|
|
personnelReport1.value_10 = sum10 + sum10_1 + sum10_2;
|
|
personnelReport1.value_11 = sum11 + sum11_1 + sum11_2;
|
|
personnelReport1.value_12 =
|
|
personnelReport1.value_9 + personnelReport1.value_10 + personnelReport1.value_11;
|
|
personnelReport1.value_13 = sum13 + sum13_1 + sum13_2;
|
|
personnelReport1.value_14 = sum14 + sum14_1 + sum14_2;
|
|
personnelReport1.value_15 = personnelReport1.value_13 + personnelReport1.value_14;
|
|
personnelReport1.value_16 = sum16 + sum16_1 + sum16_2;
|
|
personnelReport1.value_17 = sum17 + sum17_1 + sum17_2;
|
|
personnelReport1.value_18 = sum18 + sum18_1 + sum18_2;
|
|
personnelReport1.value_19 =
|
|
personnelReport1.value_16 + personnelReport1.value_17 + personnelReport1.value_18;
|
|
personnelReport1.value_20 = sum20 + sum20_1 + sum20_2;
|
|
personnelReport1.value_21 = sum21 + sum21_1 + sum21_2;
|
|
personnelReport1.value_22 = sum22 + sum22_1 + sum22_2;
|
|
personnelReport1.value_23 = sum23 + sum23_1 + sum23_2;
|
|
personnelReport1.value_24 = personnelReport1.value_20 + personnelReport1.value_21 +
|
|
personnelReport1.value_22 + personnelReport1.value_23;
|
|
|
|
|
|
foreach (var detail in personnelReport1.personnel_report_detail)
|
|
{
|
|
if (detail.topic_type == 2)
|
|
{
|
|
detail.topic = " " + detail.topic;
|
|
}
|
|
|
|
if (detail.topic_type == 3)
|
|
{
|
|
detail.topic = " - " + detail.topic;
|
|
}
|
|
}
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_8.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport8" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_9/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel9Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_1);
|
|
var sum1_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_1);
|
|
var sum1_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_2);
|
|
var sum2_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_2);
|
|
var sum2_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_2);
|
|
var sum4 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_4);
|
|
var sum4_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_4);
|
|
var sum4_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_4);
|
|
var sum5 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_5);
|
|
var sum5_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_5);
|
|
var sum5_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_5);
|
|
var sum8 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_8);
|
|
var sum8_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_8);
|
|
var sum8_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_8);
|
|
var sum7 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_7);
|
|
var sum7_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_7);
|
|
var sum7_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_7);
|
|
|
|
|
|
var sum10 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_10);
|
|
var sum10_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_10);
|
|
var sum10_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_11);
|
|
var sum11_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_11);
|
|
var sum11_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_11);
|
|
|
|
var sum13 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_13);
|
|
var sum13_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_13);
|
|
var sum13_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_13);
|
|
var sum14 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_14);
|
|
var sum14_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_14);
|
|
var sum14_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_14);
|
|
|
|
var sum16 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_16);
|
|
var sum16_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_16);
|
|
var sum16_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_16);
|
|
var sum17 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_17);
|
|
var sum17_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_17);
|
|
var sum17_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_17);
|
|
|
|
var sum20 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_20);
|
|
var sum20_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_20);
|
|
var sum20_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_20);
|
|
var sum19 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_19);
|
|
var sum19_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_19);
|
|
var sum19_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_19);
|
|
|
|
var sum22 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_22);
|
|
var sum22_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_22);
|
|
var sum22_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_22);
|
|
var sum23 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_23);
|
|
var sum23_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_23);
|
|
var sum23_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_23);
|
|
|
|
var sum25 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_25);
|
|
var sum25_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_25);
|
|
var sum25_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_25);
|
|
var sum26 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_26);
|
|
var sum26_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_26);
|
|
var sum26_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_26);
|
|
var sum28 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_28);
|
|
var sum28_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_28);
|
|
var sum28_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_28);
|
|
var sum29 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_29);
|
|
var sum29_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_29);
|
|
var sum29_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_29);
|
|
var sum31 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_31);
|
|
var sum31_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_31);
|
|
var sum31_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_31);
|
|
var sum32 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_32);
|
|
var sum32_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_32);
|
|
var sum32_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_32);
|
|
|
|
|
|
personnelReport1.value_1 = sum1 + sum1_1 + sum1_2;
|
|
personnelReport1.value_2 = sum2 + sum2_1 + sum2_2;
|
|
personnelReport1.value_3 = personnelReport1.value_1 + personnelReport1.value_2;
|
|
personnelReport1.value_4 = sum4 + sum4_1 + sum4_2;
|
|
personnelReport1.value_5 = sum5 + sum5_1 + sum5_2;
|
|
personnelReport1.value_6 = personnelReport1.value_4 + personnelReport1.value_5;
|
|
personnelReport1.value_7 = sum7 + sum7_1 + sum7_2;
|
|
personnelReport1.value_8 = sum8 + sum8_1 + sum8_2;
|
|
personnelReport1.value_9 = personnelReport1.value_7 + personnelReport1.value_8;
|
|
personnelReport1.value_10 = sum10 + sum10_1 + sum10_2;
|
|
personnelReport1.value_11 = sum11 + sum11_1 + sum11_2;
|
|
personnelReport1.value_12 = personnelReport1.value_10 + personnelReport1.value_11;
|
|
personnelReport1.value_13 = sum13 + sum13_1 + sum13_2;
|
|
personnelReport1.value_14 = sum14 + sum14_1 + sum14_2;
|
|
personnelReport1.value_15 = personnelReport1.value_13 + personnelReport1.value_14;
|
|
personnelReport1.value_16 = sum16 + sum16_1 + sum16_2;
|
|
personnelReport1.value_17 = sum17 + sum17_1 + sum17_2;
|
|
personnelReport1.value_18 = personnelReport1.value_16 + personnelReport1.value_17;
|
|
personnelReport1.value_19 = sum19 + sum19_1 + sum19_2;
|
|
personnelReport1.value_20 = sum20 + sum20_1 + sum20_2;
|
|
personnelReport1.value_21 = personnelReport1.value_19 + personnelReport1.value_20;
|
|
personnelReport1.value_22 = sum22 + sum22_1 + sum22_2;
|
|
personnelReport1.value_23 = sum23 + sum23_1 + sum23_2;
|
|
personnelReport1.value_24 = personnelReport1.value_22 + personnelReport1.value_23;
|
|
personnelReport1.value_25 = sum25 + sum25_1 + sum25_2;
|
|
personnelReport1.value_26 = sum26 + sum26_1 + sum26_2;
|
|
personnelReport1.value_27 = personnelReport1.value_25 + personnelReport1.value_26;
|
|
personnelReport1.value_28 = sum28 + sum28_1 + sum28_2;
|
|
personnelReport1.value_29 = sum29 + sum29_1 + sum29_2;
|
|
personnelReport1.value_30 = personnelReport1.value_28 + personnelReport1.value_29;
|
|
personnelReport1.value_31 = sum31 + sum31_1 + sum31_2;
|
|
personnelReport1.value_32 = sum32 + sum32_1 + sum32_2;
|
|
personnelReport1.value_33 = personnelReport1.value_31 + personnelReport1.value_32;
|
|
|
|
|
|
foreach (var detail in personnelReport1.personnel_report_detail)
|
|
{
|
|
if (detail.topic_type == 2)
|
|
{
|
|
detail.topic = " " + detail.topic;
|
|
}
|
|
|
|
if (detail.topic_type == 3)
|
|
{
|
|
detail.topic = " - " + detail.topic;
|
|
}
|
|
}
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_9.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport9" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_10/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel10Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Sum(d => d.value_2);
|
|
var sum3 = personnelReport1.personnel_report_detail.Sum(d => d.value_3);
|
|
var sum4 = personnelReport1.personnel_report_detail.Sum(d => d.value_4);
|
|
var sum5 = personnelReport1.personnel_report_detail.Sum(d => d.value_5);
|
|
var sum6 = personnelReport1.personnel_report_detail.Sum(d => d.value_6);
|
|
var sum7 = personnelReport1.personnel_report_detail.Sum(d => d.value_7);
|
|
|
|
personnelReport1.value_1 = sum1;
|
|
personnelReport1.value_2 = sum2;
|
|
personnelReport1.value_3 = sum3;
|
|
personnelReport1.value_4 = sum4;
|
|
personnelReport1.value_5 = sum5;
|
|
personnelReport1.value_6 = sum6;
|
|
personnelReport1.value_7 = sum7;
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_10.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport10" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_11/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel11Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_1);
|
|
var sum1_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_1);
|
|
var sum1_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_2);
|
|
var sum2_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_2);
|
|
var sum2_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_2);
|
|
var sum3 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_3);
|
|
var sum3_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_3);
|
|
var sum3_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_3);
|
|
|
|
var sum5 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_5);
|
|
var sum5_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_5);
|
|
var sum5_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_5);
|
|
var sum6 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_6);
|
|
var sum6_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_6);
|
|
var sum6_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_6);
|
|
var sum7 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_7);
|
|
var sum7_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_7);
|
|
var sum7_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_7);
|
|
|
|
var sum9 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_9);
|
|
var sum9_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_9);
|
|
var sum9_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_9);
|
|
var sum10 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_10);
|
|
var sum10_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_10);
|
|
var sum10_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_11);
|
|
var sum11_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_11);
|
|
var sum11_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_11);
|
|
|
|
var sum13 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_13);
|
|
var sum13_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_13);
|
|
var sum13_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_13);
|
|
var sum14 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_14);
|
|
var sum14_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_14);
|
|
var sum14_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_14);
|
|
var sum15 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_15);
|
|
var sum15_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_15);
|
|
var sum15_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_15);
|
|
var sum17 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_17);
|
|
var sum17_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_17);
|
|
var sum17_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_17);
|
|
var sum18 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_18);
|
|
var sum18_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_18);
|
|
var sum18_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_18);
|
|
var sum19 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_19);
|
|
var sum19_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_19);
|
|
var sum19_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_19);
|
|
var sum21 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_21);
|
|
var sum21_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_21);
|
|
var sum21_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_21);
|
|
var sum22 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_22);
|
|
var sum22_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_22);
|
|
var sum22_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_22);
|
|
var sum23 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_23);
|
|
var sum23_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_23);
|
|
var sum23_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_23);
|
|
var sum25 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_25);
|
|
var sum25_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_25);
|
|
var sum25_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_25);
|
|
var sum26 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_26);
|
|
var sum26_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_26);
|
|
var sum26_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_26);
|
|
var sum27 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_27);
|
|
var sum27_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_27);
|
|
var sum27_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_27);
|
|
|
|
personnelReport1.value_1 = sum1 + sum1_1 + sum1_2;
|
|
personnelReport1.value_2 = sum2 + sum2_1 + sum2_2;
|
|
personnelReport1.value_3 = sum3 + sum3_1 + sum3_2;
|
|
personnelReport1.value_4 = personnelReport1.value_1 + personnelReport1.value_2 + personnelReport1.value_3;
|
|
personnelReport1.value_5 = sum5 + sum5_1 + sum5_2;
|
|
personnelReport1.value_6 = sum6 + sum6_1 + sum6_2;
|
|
personnelReport1.value_7 = sum7 + sum7_1 + sum7_2;
|
|
personnelReport1.value_8 = personnelReport1.value_5 + personnelReport1.value_6 + personnelReport1.value_7;
|
|
personnelReport1.value_9 = sum9 + sum9_1 + sum9_2;
|
|
personnelReport1.value_10 = sum10 + sum10_1 + sum10_2;
|
|
personnelReport1.value_11 = sum11 + sum11_1 + sum11_2;
|
|
personnelReport1.value_12 =
|
|
personnelReport1.value_9 + personnelReport1.value_10 + personnelReport1.value_11;
|
|
personnelReport1.value_13 = sum13 + sum13_1 + sum13_2;
|
|
personnelReport1.value_14 = sum14 + sum14_1 + sum14_2;
|
|
personnelReport1.value_15 = sum15 + sum15_1 + sum15_2;
|
|
personnelReport1.value_16 =
|
|
personnelReport1.value_13 + personnelReport1.value_14 + personnelReport1.value_15;
|
|
personnelReport1.value_17 = sum17 + sum17_1 + sum17_2;
|
|
personnelReport1.value_18 = sum18 + sum18_1 + sum18_2;
|
|
personnelReport1.value_19 = sum19 + sum19_1 + sum19_2;
|
|
personnelReport1.value_20 =
|
|
personnelReport1.value_17 + personnelReport1.value_18 + personnelReport1.value_19;
|
|
personnelReport1.value_21 = sum21 + sum21_1 + sum21_2;
|
|
personnelReport1.value_22 = sum22 + sum22_1 + sum22_2;
|
|
personnelReport1.value_23 = sum23 + sum23_1 + sum23_2;
|
|
personnelReport1.value_24 =
|
|
personnelReport1.value_21 + personnelReport1.value_22 + personnelReport1.value_23;
|
|
personnelReport1.value_25 = sum25 + sum25_1 + sum25_2;
|
|
personnelReport1.value_26 = sum26 + sum26_1 + sum26_2;
|
|
personnelReport1.value_27 = sum27 + sum27_1 + sum27_2;
|
|
personnelReport1.value_28 =
|
|
personnelReport1.value_25 + personnelReport1.value_26 + personnelReport1.value_27;
|
|
|
|
|
|
foreach (var detail in personnelReport1.personnel_report_detail)
|
|
{
|
|
if (detail.topic_type == 2)
|
|
{
|
|
detail.topic = " " + detail.topic;
|
|
}
|
|
|
|
if (detail.topic_type == 3)
|
|
{
|
|
detail.topic = " - " + detail.topic;
|
|
}
|
|
}
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_11.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport11" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
|
|
[HttpPost, Route("reports/personnel_12/{type}")]
|
|
[ApiExplorerSettings(GroupName = "reports")]
|
|
public IActionResult GetPersonnel12Report([FromRoute] string type, [FromBody] personnel_report personnelReport1)
|
|
{
|
|
var sum1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_1);
|
|
var sum1_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_1);
|
|
var sum1_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_1);
|
|
var sum2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_2);
|
|
var sum2_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_2);
|
|
var sum2_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_2);
|
|
var sum3 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_3);
|
|
var sum3_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_3);
|
|
var sum3_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_3);
|
|
var sum4 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_4);
|
|
var sum4_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_4);
|
|
var sum4_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_4);
|
|
|
|
var sum5 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_5);
|
|
var sum5_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_5);
|
|
var sum5_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_5);
|
|
var sum6 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_6);
|
|
var sum6_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_6);
|
|
var sum6_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_6);
|
|
var sum7 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_7);
|
|
var sum7_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_7);
|
|
var sum7_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_7);
|
|
var sum8 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_8);
|
|
var sum8_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_8);
|
|
var sum8_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_8);
|
|
|
|
var sum9 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_9);
|
|
var sum9_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_9);
|
|
var sum9_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_9);
|
|
var sum10 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_10);
|
|
var sum10_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_10);
|
|
var sum10_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_10);
|
|
var sum11 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_11);
|
|
var sum11_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_11);
|
|
var sum11_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_11);
|
|
var sum12 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_12);
|
|
var sum12_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_12);
|
|
var sum12_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_12);
|
|
|
|
var sum13 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_13);
|
|
var sum13_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_13);
|
|
var sum13_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_13);
|
|
var sum14 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_14);
|
|
var sum14_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_14);
|
|
var sum14_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_14);
|
|
var sum15 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_15);
|
|
var sum15_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_15);
|
|
var sum15_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_15);
|
|
var sum16 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_16);
|
|
var sum16_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_16);
|
|
var sum16_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_16);
|
|
|
|
var sum17 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_17);
|
|
var sum17_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_17);
|
|
var sum17_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_17);
|
|
var sum18 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_18);
|
|
var sum18_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_18);
|
|
var sum18_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_18);
|
|
var sum19 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_19);
|
|
var sum19_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_19);
|
|
var sum19_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_19);
|
|
var sum20 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_20);
|
|
var sum20_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_20);
|
|
var sum20_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_20);
|
|
|
|
var sum21 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_21);
|
|
var sum21_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_21);
|
|
var sum21_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_21);
|
|
var sum22 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_22);
|
|
var sum22_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_22);
|
|
var sum22_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_22);
|
|
var sum23 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_23);
|
|
var sum23_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_23);
|
|
var sum23_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_23);
|
|
var sum24 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_24);
|
|
var sum24_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_24);
|
|
var sum24_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_24);
|
|
|
|
var sum25 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_25);
|
|
var sum25_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_25);
|
|
var sum25_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_25);
|
|
var sum26 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_26);
|
|
var sum26_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_26);
|
|
var sum26_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_26);
|
|
var sum27 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 1).Sum(d => d.value_27);
|
|
var sum27_1 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 4).Sum(d => d.value_27);
|
|
var sum27_2 = personnelReport1.personnel_report_detail.Where(x => x.topic_type == 6).Sum(d => d.value_27);
|
|
|
|
personnelReport1.value_1 = sum1 + sum1_1 + sum1_2;
|
|
personnelReport1.value_2 = sum2 + sum2_1 + sum2_2;
|
|
personnelReport1.value_3 = sum3 + sum3_1 + sum3_2;
|
|
personnelReport1.value_4 = sum4 + sum4_1 + sum4_2;
|
|
personnelReport1.value_5 = sum5 + sum5_1 + sum5_2;
|
|
personnelReport1.value_6 = sum6 + sum6_1 + sum6_2;
|
|
personnelReport1.value_7 = sum7 + sum7_1 + sum7_2;
|
|
personnelReport1.value_8 = sum8 + sum8_1 + sum8_2;
|
|
personnelReport1.value_9 = sum9 + sum9_1 + sum9_2;
|
|
personnelReport1.value_10 = sum10 + sum10_1 + sum10_2;
|
|
personnelReport1.value_11 = sum11 + sum11_1 + sum11_2;
|
|
personnelReport1.value_12 = sum12 + sum12_1 + sum12_2;
|
|
personnelReport1.value_13 = sum13 + sum13_1 + sum13_2;
|
|
personnelReport1.value_14 = sum14 + sum14_1 + sum14_2;
|
|
personnelReport1.value_15 = sum15 + sum15_1 + sum15_2;
|
|
personnelReport1.value_16 = sum16 + sum16_1 + sum16_2;
|
|
personnelReport1.value_17 = sum17 + sum17_1 + sum17_2;
|
|
personnelReport1.value_18 = sum18 + sum18_1 + sum18_2;
|
|
personnelReport1.value_19 = sum19 + sum19_1 + sum19_2;
|
|
personnelReport1.value_20 = sum20 + sum20_1 + sum20_2;
|
|
personnelReport1.value_21 = sum21 + sum21_1 + sum21_2;
|
|
personnelReport1.value_22 = sum22 + sum22_1 + sum22_2;
|
|
personnelReport1.value_23 = sum23 + sum23_1 + sum23_2;
|
|
personnelReport1.value_24 = sum24 + sum24_1 + sum24_2;
|
|
personnelReport1.value_25 = sum25 + sum25_1 + sum25_2;
|
|
personnelReport1.value_26 = sum26 + sum26_1 + sum26_2;
|
|
personnelReport1.value_27 = sum27 + sum27_1 + sum27_2;
|
|
|
|
|
|
foreach (var detail in personnelReport1.personnel_report_detail)
|
|
{
|
|
if (detail.topic_type == 2)
|
|
{
|
|
detail.topic = " " + detail.topic;
|
|
}
|
|
|
|
if (detail.topic_type == 3)
|
|
{
|
|
detail.topic = " - " + detail.topic;
|
|
}
|
|
}
|
|
|
|
var report1 = new List<personnel_report>() { personnelReport1 };
|
|
|
|
Report report = new Report();
|
|
report.Load(_setting.report_path + "personnel_table_12.frx");
|
|
report.RegisterData(report1, "personnel_report");
|
|
report.Prepare();
|
|
|
|
MemoryStream stream = new MemoryStream();
|
|
switch (type)
|
|
{
|
|
case "pdf":
|
|
PDFExport pdf = new PDFExport();
|
|
report.Export(pdf, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/pdf");
|
|
case "xls":
|
|
Excel2007Export excels = new Excel2007Export();
|
|
report.Export(excels, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(stream, "application/vnd.ms-excel");
|
|
case "xlsx":
|
|
Excel2007Export excel = new Excel2007Export();
|
|
report.Export(excel, stream);
|
|
stream.Seek(0, SeekOrigin.Begin);
|
|
return File(
|
|
stream,
|
|
"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet",
|
|
"personnelReport12" + ".xlsx");
|
|
}
|
|
|
|
return Ok();
|
|
}
|
|
}
|
|
} |