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();
        }
    }
}