ContractManagementController.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311
  1. using System;
  2. using System.Linq;
  3. using System.Threading.Tasks;
  4. using FMSAdmin.Data;
  5. using FMSAdmin.Models;
  6. using FMSAdmin.Entities;
  7. using FMSAdmin.Services;
  8. using Microsoft.AspNetCore.Mvc;
  9. using Microsoft.Extensions.Logging;
  10. using Microsoft.AspNetCore.Authorization;
  11. using Microsoft.EntityFrameworkCore;
  12. using FMSAdmin.Helpers;
  13. using System.Data;
  14. using System.IO;
  15. using OfficeOpenXml;
  16. namespace FMSAdmin.Controllers {
  17. [Authorize]
  18. [ApiController]
  19. [ApiVersion("1")]
  20. [Route("api/[controller]")]
  21. public class ContractManagementController : Controller {
  22. private readonly ILogger<ContractManagementController> _logger;
  23. private readonly FMSContext _context;
  24. private readonly ContractManagementService _service;
  25. private readonly StorageHelper _storage;
  26. public ContractManagementController(
  27. ILogger<ContractManagementController> logger,
  28. FMSContext context,
  29. ContractManagementService service,
  30. StorageHelper storage
  31. ) {
  32. _logger = logger;
  33. _context = context;
  34. _service = service;
  35. _storage = storage;
  36. }
  37. /// <summary>
  38. /// 목록(List)
  39. /// </summary>
  40. [HttpGet]
  41. public IActionResult List([FromQuery] PagingRequest req, [FromQuery] string siteId) {
  42. var query = _FilterAndSort(req);
  43. var list = _ListSelect(query);
  44. var paging = PagingList.Pagination(list, req.page, req.limit);
  45. return Ok(paging);
  46. }
  47. /// <summary>
  48. /// 조회
  49. /// </summary>
  50. [HttpGet("{siteId}/{contractId}")]
  51. public IActionResult Get(int siteId, int contractId) {
  52. var data = _service.Get(siteId, contractId);
  53. if (data.Count() == 0) {
  54. return NotFound("계약 정보를 찾을 수 없습니다.");
  55. }
  56. var list = data.Select(x => new {
  57. x.ContractId,
  58. x.SiteId,
  59. CmSite = new {
  60. x.CmSite.Name,
  61. },
  62. x.Name,
  63. x.PartnerTypeId,
  64. CmPartnerType = new {
  65. x.PartnerType.Name
  66. },
  67. x.PartnerId,
  68. CmPartner = new {
  69. x.CmPartner.Name
  70. },
  71. // ContractDate = x.ContractDate == null ? "" : ((DateTime)x.ContractDate).ToString("yyyy-MM-dd"),
  72. // StartDate = x.StartDate == null ? "" : ((DateTime)x.StartDate).ToString("yyyy-MM-dd"),
  73. // EndDate = x.EndDate == null ? "" : ((DateTime)x.EndDate).ToString("yyyy-MM-dd"),
  74. // ContractDate = x.ContractDate != null ? x.ContractDate.Value.ToString("yyyy/MM/dd") : null,
  75. // StartDate = x.StartDate != null ? x.StartDate.Value.ToString("yyyy/MM/dd") : null,
  76. // EndDate = x.EndDate != null ? x.EndDate.Value.ToString("yyyy/MM/dd") : null,
  77. x.ContractDate,
  78. x.StartDate,
  79. x.EndDate,
  80. x.OwnerShipName,
  81. x.OwnerShipPhoneNo,
  82. x.CommitmentMan,
  83. x.Comment,
  84. x.ContractClassId,
  85. FmsContractClass = new {
  86. x.FmsContractClass.Name
  87. },
  88. x.ContractTypeId,
  89. FmsContractType = new {
  90. x.FmsContractType.Name
  91. },
  92. x.ContractMethodId,
  93. FmsContractMethod = new {
  94. x.FmsContractMethod.Name
  95. },
  96. x.PaymentTypeId,
  97. FmsPaymentType = new {
  98. x.FmsPaymentType.Name
  99. },
  100. //2020-04-13 컬럼 추가
  101. x.ContractAmountText,
  102. x.ContractExeGuaranteeRate,
  103. x.DefectGuaranteeRate,
  104. x.DefectGuaranteePeriodText,
  105. x.FileId,
  106. CmFile = _storage.ParseFile(x.CmFile),
  107. // CmFile = new {
  108. // x.CmFile.Name
  109. // x.CmFile.Name
  110. // },
  111. });
  112. return Ok(list.First());
  113. }
  114. /// <summary>
  115. /// 엑셀파일 익스포트
  116. /// </summary>
  117. /// <param name="req"></param>
  118. /// <returns></returns>
  119. [HttpGet("excel")]
  120. public IActionResult ExportExcel([FromQuery] PagingRequest req, string filename) {
  121. req.page = 1;
  122. req.limit = 0;
  123. var query = _FilterAndSort(req);
  124. var list = _ListSelect(query);
  125. var stream = new MemoryStream();
  126. using (var package = new ExcelPackage(stream)) {
  127. var workSheet = package.Workbook.Worksheets.Add("Sheet1");
  128. workSheet.Cells.LoadFromCollection(list, true);
  129. if (req.columns != null && req.columns.Length > 0) {
  130. workSheet.AddStyle(req.columns, req.sort?.order?.ToLower() == "asc", filename);
  131. }
  132. package.Save();
  133. }
  134. stream.Position = 0;
  135. string excelName = $"계약등록조회-{DateTime.Now.ToString("yyyyMMddHHmmssfff")}.xlsx";
  136. return File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", excelName);
  137. }
  138. /// <summary>
  139. /// 수정(Edit)
  140. /// </summary>
  141. /// <param name="data"></param>
  142. /// <returns></returns>
  143. [HttpPost("{siteId}/{contractId}")]
  144. public IActionResult Edit(int siteId, int contractId, [FromBody] FmsContract data) {
  145. if (contractId != data.ContractId) {
  146. return BadRequest("잘못된 접근입니다.");
  147. }
  148. ModelState.RemoveStartOf("CmFile");
  149. if (ModelState.IsValid) {
  150. _service.Edit(siteId, contractId, data);
  151. } else {
  152. return BadRequest(ModelState);
  153. }
  154. return Ok();
  155. }
  156. /// <summary>
  157. /// 신규(Creae)
  158. /// </summary>
  159. /// <param name="data"></param>
  160. /// <returns></returns>
  161. [HttpPost]
  162. public IActionResult Create([FromBody] FmsContract data) {
  163. _logger.LogInformation("Create");
  164. //_logger.LogInformation(data.Dump());
  165. if (ModelState.IsValid) {
  166. _service.Create(data);
  167. } else {
  168. return BadRequest(ModelState);
  169. }
  170. return Ok();
  171. }
  172. /// <summary>
  173. /// 삭제(Delete)
  174. /// </summary>
  175. [HttpDelete("{siteId}/{contractId}")]
  176. public IActionResult Delete(int siteId, int contractId) {
  177. _service.Delete(siteId, contractId);
  178. return Ok();
  179. }
  180. /// <summary>
  181. /// 셀렉트 공통(_ListSelect)
  182. /// </summary>
  183. /// <param name="query"></param>
  184. /// <returns></returns>
  185. private dynamic _ListSelect(IQueryable<FmsContract> query) {
  186. var list = query.Select(x => new {
  187. x.ContractId,
  188. x.SiteId,
  189. //컬럼 정렬 순서 변경 2020-05-27 수정
  190. StartDate = x.StartDate != null ? x.StartDate.Value.ToString("yyyy-MM-dd") : null,
  191. EndDate = x.EndDate != null ? x.EndDate.Value.ToString("yyyy-MM-dd") : null,
  192. SiteName = x.CmSite.Name,
  193. x.Name,
  194. x.PartnerTypeId,
  195. PartnerTypeName = x.PartnerType.Name,
  196. FilePath = _storage.getFilePath(x.CmFile),
  197. FileName = x.CmFile.Name,
  198. // ContractDate = x.ContractDate == null ? "" : ((DateTime)x.ContractDate).ToString("yyyy-MM-dd"),
  199. // StartDate = x.StartDate == null ? "" : ((DateTime)x.StartDate).ToString("yyyy-MM-dd"),
  200. // EndDate = x.EndDate == null ? "" : ((DateTime)x.EndDate).ToString("yyyy-MM-dd"),
  201. ContractDate = x.ContractDate != null ? x.ContractDate.Value.ToString("yyyy-MM-dd") : null,
  202. x.PartnerId,
  203. PartnerName = x.CmPartner.Name,
  204. // x.ContractDate,
  205. // x.StartDate,
  206. // x.EndDate,
  207. x.OwnerShipName,
  208. x.OwnerShipPhoneNo,
  209. x.CommitmentMan,
  210. x.Comment,
  211. x.ContractClassId,
  212. ContractClassName = x.FmsContractClass.Name,
  213. x.ContractTypeId,
  214. ContractTypeName = x.FmsContractType.Name,
  215. x.ContractMethodId,
  216. ContractMethodName = x.FmsContractMethod.Name,
  217. x.PaymentTypeId,
  218. PaymentTypeName = x.FmsPaymentType.Name,
  219. x.ContractAmountText,
  220. x.ContractExeGuaranteeRate,
  221. x.DefectGuaranteeRate,
  222. x.DefectGuaranteePeriodText,
  223. x.FileId,
  224. File = x.CmFile.Name,
  225. });
  226. return list;
  227. }
  228. /// <summary>
  229. /// 검색 & 정렬(_FilterAndSort)
  230. /// </summary>
  231. /// <param name="req"></param>
  232. /// <returns></returns>
  233. private IQueryable<FmsContract> _FilterAndSort(PagingRequest req) {
  234. var query = _service.GetAll();
  235. // 기본 Entity 검색
  236. query = query.Filter(req.conditions);
  237. if (req.siteId != null) {
  238. query = query.Where(x => x.SiteId == Util.ToInt(req.siteId));
  239. }
  240. if (req.siteIds != null && req.siteIds.Length > 0) {
  241. query = query.Where(x => req.siteIds.Contains(x.SiteId));
  242. }
  243. //정렬 (시작일)
  244. //query = query.OrderBy(x => x.StartDate);
  245. //고정정렬 (사옥 준공순)
  246. //var sortQuery = query.OrderBy(x => x.CmSite.SortOrderNo);
  247. // 추가 정렬
  248. // if (req.sort.field == "StoredAndAproval") { // 기본 커스텀 정렬 예제 (입고역순,승인일순)
  249. // sortQuery = sortQuery.ThenByDescending(x => x.StoredDate);
  250. // sortQuery = sortQuery.ThenBy(x => x.ApprovalDate);
  251. // } else {
  252. // sortQuery = sortQuery.ThenSort(req.sort);
  253. // }
  254. //정렬 (시작일)
  255. var sortQuery = query.OrderByDescending(x => x.StartDate);
  256. // 기본 Entity 정렬
  257. sortQuery = sortQuery.ThenSort(req.sort);
  258. // 추가 정렬
  259. // if (req.sort.field == "StoredAndAproval") { // 기본 커스텀 정렬 예제 (입고역순,승인일순)
  260. // sortQuery = sortQuery.ThenByDescending(x => x.StoredDate);
  261. // sortQuery = sortQuery.ThenBy(x => x.ApprovalDate);
  262. // } else {
  263. // sortQuery = sortQuery.ThenSort(req.sort);
  264. // }
  265. // 기본 Entity 정렬
  266. //query = query.Sort(req.sort);
  267. return sortQuery;
  268. }
  269. }
  270. }