OA2023/OASystem/OASystem.Api/Controllers/BusinessController.cs

using Microsoft.AspNetCore.Mvc;
using NPOI.SS.Formula.Functions;
using OASystem.API.OAMethodLib.ALiYun;
using OASystem.API.OAMethodLib.ExcelOutput;
using OASystem.Domain.Common;
using OASystem.Domain.Dtos.Business;
using OASystem.Domain.Dtos.Financial;
using OASystem.Domain.Dtos.Groups;
using OASystem.Domain.Entities.Business;
using OASystem.Domain.Entities.Financial;
using OASystem.Domain.Entities.Groups;
using OASystem.Domain.Entities.Resource;
using OASystem.Domain.ViewModels.Business;
using OASystem.Domain.ViewModels.Financial;
using OASystem.Domain.ViewModels.Groups;
using OASystem.Infrastructure.Repositories.Business;
using OASystem.Infrastructure.Repositories.Groups;
using OASystem.Infrastructure.Repositories.System;
using Org.BouncyCastle.Asn1.Mozilla;
using StackExchange.Redis;

namespace OASystem.API.Controllers
{
    /// <summary>
    /// 通用业务操作
    /// </summary>
    [Route("api/[controller]/[action]")]
    public class BusinessController : ControllerBase
    {
        private readonly IMapper _mapper;
        private readonly CommonBusRepository _busRep;
        private readonly SetDataRepository _setDataRep;
        private readonly DelegationInfoRepository _groupRep;
        private readonly TeamRateRepository _teamRateRep;

        public BusinessController( IMapper mapper, CommonBusRepository busRep, SetDataRepository setDataRep, DelegationInfoRepository groupRep, TeamRateRepository teamRateRep)
        {
            _mapper = mapper;
            _busRep = busRep;
            _setDataRep = setDataRep;
            _groupRep = groupRep;
            _teamRateRep = teamRateRep;
        }

        #region 团组信息 
        /// <summary>
        ///  团组信息 
        ///  团组简略详情 
        /// </summary>
        /// <param name="dto">团组info请求dto</param>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostShareGroupInfo(ShareGroupInfoDto dto)
        {
            try
            {
                var groupData = await _groupRep.PostShareGroupInfo(dto);
                if (groupData.Code != 0)
                {
                    return Ok(JsonView(false, groupData.Msg));
                }

                return Ok(JsonView(groupData.Data));
            }
            catch (Exception ex)
            {

                return Ok(JsonView(false, ex.Message));
            }
            
        }

        /// <summary>
        /// 团组信息 团组名称 List
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> GetGroupNameList(GroupNameDto dto)
        {
            var groupData = await _groupRep.GetGroupNameList(dto);
            if (groupData.Code != 0)
            {
                return Ok(JsonView(false, groupData.Msg));
            }

            return Ok(JsonView(groupData.Data, groupData.Data.Count));
        }

        /// <summary>
        /// 获取团组指向分类
        /// </summary>
        /// <param name="_dto">参数Json字符串</param>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostGroupDirectionalClassificationInit()
        {
            Result result = new Result();
            result = await _setDataRep.GetSetDataBySTId(_setDataRep, 16); //团组指向分类
            if (result.Code != 0)
            {
                return Ok(JsonView(false, "获取失败!"));
            }

            List<SetDataInfoView> _view1 = JsonConvert.DeserializeObject<List<SetDataInfoView>>(JsonConvert.SerializeObject(result.Data));

            SetDataInfoView xc_view = new SetDataInfoView();//77	行程 //移除行程
            xc_view = _view1.Where(it => it.Id == 77).FirstOrDefault();
            if (xc_view != null) {  _view1.Remove(xc_view); };


            List<SetDataInfoView> _view = new List<SetDataInfoView>();
            //_view.Insert(0, new SetDataInfoView { Id = -1, Name = "所有模块" });

            SetDataInfoView qz_view = new SetDataInfoView();//80	签证
            qz_view = _view1.Where(it => it.Id == 80).FirstOrDefault();
            if (qz_view != null) { _view.Insert(0, qz_view); _view1.Remove(qz_view); };

            SetDataInfoView jpyd_view = new SetDataInfoView();//85	机票预订
            jpyd_view = _view1.Where(it => it.Id == 85).FirstOrDefault();
            if (jpyd_view != null) { _view.Insert(1, jpyd_view); _view1.Remove(jpyd_view); };

            SetDataInfoView jdyd_view = new SetDataInfoView();//76	酒店预订
            jdyd_view = _view1.Where(it => it.Id == 76).FirstOrDefault();
            if (jdyd_view != null) { _view.Insert(2, jdyd_view); _view1.Remove(jdyd_view); };

            SetDataInfoView jdzc_view = new SetDataInfoView();//751	酒店早餐
            jdzc_view = _view1.Where(it => it.Id == 751).FirstOrDefault();
            if (jdzc_view != null) { _view.Insert(3, jdzc_view); _view1.Remove(jdzc_view); };

            SetDataInfoView cdy_view = new SetDataInfoView();//79	车/导游地接
            cdy_view = _view1.Where(it => it.Id == 79).FirstOrDefault();
            if (cdy_view != null) { _view.Insert(4, cdy_view); _view1.Remove(cdy_view); };

            SetDataInfoView yqgw_view = new SetDataInfoView();//81	邀请/公务活动
            yqgw_view = _view1.Where(it => it.Id == 81).FirstOrDefault();
            if (yqgw_view != null) { _view.Insert(5, yqgw_view); _view1.Remove(yqgw_view); };

            SetDataInfoView bx_view = new SetDataInfoView();//82	团组客户保险
            bx_view = _view1.Where(it => it.Id == 82).FirstOrDefault();
            if (bx_view != null) { _view.Insert(6, bx_view); _view1.Remove(bx_view); };

            SetDataInfoView qtkx_view = new SetDataInfoView();//98	其他款项
            qtkx_view = _view1.Where(it => it.Id == 98).FirstOrDefault();
            if (qtkx_view != null) { _view.Insert(7, qtkx_view); _view1.Remove(qtkx_view); };

            SetDataInfoView skth_view = new SetDataInfoView();//285	收款退还与其他款项
            skth_view = _view1.Where(it => it.Id == 285).FirstOrDefault();
            if (skth_view != null) { _view.Insert(8, skth_view); _view1.Remove(skth_view); };

            if (_view1.Count > 0)
            {
                _view.AddRange(_view1);
            }

            return Ok(JsonView(_view));
        }


        /// <summary>
        /// 查询团组简略详情列表
        /// Page 根据Ctable And User 返回可操作的团
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostGroupListByCTableAndUserId(GroupListByCTableAndUserIdDto dto)
        {
            if (dto.CTable < 1) Ok(JsonView(false, @"请输入正确的员工给Id!"));

            if (dto.CTable < 1) 
                return Ok(JsonView(false, @"请输入正确的CTable Id ！76 酒店预订  77 行程  79 车/导游地接<br/>80 签证    81 邀请/公务活动  82 团组客户保险<br\>85 机票预订   98 其他款项 751 酒店早餐"));

            if (dto.PortType == 1 || dto.PortType == 2 || dto.PortType == 3)
            {
                string sql = string.Format(@"Select row_number() over(order by di.VisitStartDate Desc) as Row_Number, 
									         di.Id,di.TeamName,di.TourCode,di.ClientName,di.VisitCountry,di.VisitStartDate,
									         di.VisitEndDate,di.VisitDays,di.VisitPNumber
									         From Grp_GroupsTaskAssignment gta
									         Inner Join Grp_DelegationInfo di On gta.DIId = di.Id
									         Where gta.IsDel = 0 And di.IsDel = 0 And gta.IsEnable = 1
									         And gta.CTId = {0} And gta.UId = {1}", dto.CTable,dto.UserId);

                RefAsync<int> total = 0;//REF和OUT不支持异步,想要真的异步这是最优解
                var data = await _groupRep._sqlSugar.SqlQueryable<GroupListByCTableAndUserIdView>(sql).ToPageListAsync(dto.PageIndex, dto.PageSize, total); //ToPageAsync

                return Ok(JsonView(true, "操作成功!",data,total));
            }
            else
            {
                return Ok(JsonView(false, @"请输入正确的PortType 1 Web 2 Android 3 IOS "));
            }
            




            return Ok(JsonView(true));

        }

        #endregion

        #region 币种 List
        /// <summary>
        /// 币种 List
        /// </summary>
        /// <returns></returns>
        [HttpGet,HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostCurrencyList()
        {
            try
            {
                Result setData = await _setDataRep.GetSetDataBySTId(_setDataRep, 66); //币种类型
                if (setData.Code == 0)
                {
                    return Ok(JsonView(true, "查询成功", setData.Data));
                }
                else
                {
                    return Ok(JsonView(false, setData.Msg));
                }
            }
            catch (Exception)
            {
                return Ok(JsonView(false, "程序错误！"));
                throw;
            }
        }

        /// <summary>
        /// 团组汇率 币种 Item (来源：团组汇率)
        /// 根据 团组Id And 业务类型(CTable)Id
        /// api处理CTable = 285,默认返回CNY
        /// </summary>
        /// <param name="dto"> 请求参数Dto </param>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostGroupTeamRateByDiIdAndCTableId(GeneralTeamRateInfoDto dto)
        {
            try
            {
                if (dto == null)
                {
                    return Ok(JsonView(false, "请输入参数!"));
                }

                if (dto.DiId == 0)
                {
                    return Ok(JsonView(false, "请输入正确的团组Id!"));
                }
                if (dto.CTable == 0)
                {
                    return Ok(JsonView(false, "请输入正确的业务类型(CTable)Id!"));
                }


                if (dto.PortType == 1 || dto.PortType == 2 || dto.PortType == 3 )
                {
                    string teamRateInfoSql = string.Format(@"Select sd.Name,tr.* From Grp_TeamRate tr 
                                                     Left Join Sys_SetData  sd On sd.IsDel=0 And sd.STid=16  And tr.CTable = sd.Id 
                                                     Where tr.IsDel = 0 And tr.DiId = {0} And tr.CTable = {1}", dto.DiId,dto.CTable);

                    var teamRateInfo = await _teamRateRep._sqlSugar.SqlQueryable<TeamRateInfoView>(teamRateInfoSql).ToListAsync();

                    #region 团组汇率

                    TeamRateModelGeneralView teamRateModels = new TeamRateModelGeneralView();


                    #region 单独处理Ctable 币种汇率 默认 为CNY
                    if (dto.CTable == 285)
                    {
                        teamRateModels = new TeamRateModelGeneralView()
                        {
                            Id = 0,
                            CTableId = 285,
                            CTableName = "其他款项与收款退还",
                            TeamRates = new List<TeamRateDescAddCurrencyIdView>() {
                                new TeamRateDescAddCurrencyIdView()
                                {
                                    CurrencyId = 836,
                                    CurrencyCode = "CNY",
                                    CurrencyName = "人民币",
                                    Rate = 1.0000M,
                                }
                            }
                        };
                        return Ok(JsonView(true, "操作成功!", teamRateModels));
                    }


                    #endregion


                    List<SetDataInfoView> currencyDatas = new List<SetDataInfoView>();    
                    #region 获取所有币种

                    string sql = string.Format(@"select * from Sys_SetData where STid = {0} and isdel = 0", 66);
                    var DBdata = await _setDataRep.GetListBySqlWithNolockAsync(sql);

                    if (DBdata == null || DBdata.Count == 0)
                    {
                        return Ok(JsonView(false, "所有币种获取失败!"));
                    }

                    currencyDatas = DBdata.Select(x => new SetDataInfoView
                    {
                        Name = x.Name,
                        Id = x.Id,
                        Remark = x.Remark,
                    }).ToList();

                    #endregion

                    foreach (TeamRateInfoView item in teamRateInfo)
                    {
                        TeamRateModelGeneralView teamRateModelInfo = new TeamRateModelGeneralView();

                        teamRateModelInfo.Id = item.Id;
                        teamRateModelInfo.CTableId = item.CTable;
                        teamRateModelInfo.CTableName = item.Name;
                        List<TeamRateDescAddCurrencyIdView> teamRateDescViews = new List<TeamRateDescAddCurrencyIdView>();

                        #region 拆分remark里的汇率

                        if (item.Remark.Contains("|"))
                        {
                            string[] currencyArr = item.Remark.Split("|");
                            foreach (string currency in currencyArr)
                            {
                                string[] currency1 = currency.Split(":");
                                string[] currency2 = currency1[0].Split("(");

                                string currencyCode = currency2[1].Replace(")", "").TrimEnd();
                                SetDataInfoView dataInfoView = new SetDataInfoView();
                                dataInfoView = currencyDatas.Where(it => it.Name == currencyCode).FirstOrDefault();
                                int currencyId = currencyDatas.Where(it => it.Name == currencyCode).FirstOrDefault().Id;
                                TeamRateDescAddCurrencyIdView rateDescView = new TeamRateDescAddCurrencyIdView()
                                {
                                    CurrencyId = dataInfoView.Id,
                                    CurrencyCode = currencyCode,
                                    CurrencyName = currency2[0],
                                    Rate = decimal.Parse(currency1[1]),
                                };
                                teamRateDescViews.Add(rateDescView);
                            }
                        }

                        #endregion

                        if (teamRateDescViews.Count > 0)
                        {
                            teamRateDescViews = teamRateDescViews.OrderBy(it => it.CurrencyId).ToList();
                        }

                        teamRateModelInfo.TeamRates = teamRateDescViews;
                        teamRateModels = teamRateModelInfo;
                    }

                    #endregion

                    return Ok(JsonView(true, "操作成功!", teamRateModels));

                }
                else
                {
                    return Ok(JsonView(false, "请输入正确的端口号! 1 Web 2 Android 3 Ios;"));
                }



            }
            catch (Exception ex)
            {
                return Ok(JsonView(false, ex.Message));
            }
        }


        /// <summary>
        /// 根据团组Id币种Id及类型Id查询团组汇率
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        [HttpGet, HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostCurrencyByDiid(int DiId,int CId,int CurrencyId)
        {
            try
            {
                Result setData = await _setDataRep.PostCurrencyByDiid( DiId, CId, CurrencyId); //币种类型
                if (setData.Code == 0)
                {
                    return Ok(JsonView(true, "查询成功", setData.Data));
                }
                else
                {
                    return Ok(JsonView(false, setData.Msg));
                }
            }
            catch (Exception)
            {
                return Ok(JsonView(false, "程序错误！"));
                throw;
            }

        }
        #endregion

        #region 查询页面关联Ctable


        /// <summary>
        /// 页面关联Ctable
        /// 根据PageId 返回 CTable Id
        /// </summary>
        /// <param name="dto"></param>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostPageLinkCTable(PageLinkCTableDto dto)
        {
            try
            {
                if (dto == null)
                {
                    return Ok(JsonView(false, "请求参数不能为空！"));
                }

                if (dto.PageId == 0)
                {
                    return Ok(JsonView(false, "页面Id不能为0！"));
                }

                List<CTableCorrelationPageDatas> data =  AppSettingsHelper.Get<CTableCorrelationPageDatas>("CTableCorrelationPageDatas");
                CTableCorrelationPageDatas correlationPageDatas = new CTableCorrelationPageDatas();

                foreach (var item in data)
                {
                    if (item.PageIdDatas != null)
                    {
                        var pageId = item.PageIdDatas.Where(it => it == dto.PageId).FirstOrDefault();
                        if (pageId != 0)
                        {
                            correlationPageDatas = item;
                            break;
                        }
                    }
                }

                if (correlationPageDatas.CTableId == 0)
                {
                    return Ok(JsonView(false, "您查询的页面Id，未配置AppSettings,请前往配置！"));
                }

                return Ok(JsonView(true, "操作成功",new { CTable = correlationPageDatas.CTableId }));
            }
            catch (Exception ex)
            {
                return Ok(JsonView(false, ex.Message));
            }
        }
        #endregion

        #region 会务物料单

        /// <summary>
        /// 获取会务活动列表
        /// </summary>
        /// <param name="paras"></param>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostConferenceList()
        {
            List<Grp_DelegationInfo> listSource = _busRep.Query<Grp_DelegationInfo>(s => s.TeamDid == 691 && s.IsDel == 0).ToList();
            List<GroupNameView> viewList = new List<GroupNameView>();
            foreach (var group in listSource)
            {
                GroupNameView _view = new GroupNameView();
                _view.Id = group.Id;
                _view.GroupName = group.TeamName;
            }

            return Ok(JsonView(viewList));
        }

        /// <summary>
        /// 获取会务的采购物品计划清单
        /// </summary>
        /// <param name="ConfId">会务活动Id</param>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostConfItemList(int ConfId)
        {
            Bus_ConfItemListView view = new Bus_ConfItemListView();

            Bus_ConfItemListInfo _confListInfo = await _busRep.Query<Bus_ConfItemListInfo>(s => s.Diid == ConfId).FirstAsync();
            if (_confListInfo != null)
            {
                view.TotalCost = _confListInfo.TotalCost;

                string sqlItem = string.Format(@" Select c.Id,c.ItemId,d.ItemName,c.[Count],c.CurrCost,c.OpRemark
From Bus_ConfItem as c With(Nolock) 
Inner Join Res_ItemDetail as d with(Nolock) On c.ItemId=d.Id
Where c.ConfListId = {0}", ConfId);
                List<Bus_ConfItemView> confItemList = await _busRep._sqlSugar.SqlQueryable<Bus_ConfItemView>(sqlItem).ToListAsync();
                view.ItemList = new List<Bus_ConfItemView>(confItemList);
            }
            else
            {
                view.ItemList = new List<Bus_ConfItemView>();
                view.TotalCost = 0;
            }

            return Ok(JsonView(view));
        }

        /// <summary>
        /// 获取会务可采购的物料集合
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostOptionalItemList()
        {
            List<OptionalBusRangeView> result = await _busRep.GetViewList_OptionalItem();

            return Ok(JsonView(result));
        }

        /// <summary>
        /// 编辑物料采购清单
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> PostEditOptionalItemList(JsonDtoBase jsonDto)
        {
            if (string.IsNullOrEmpty(jsonDto.Paras))
            {
                return Ok(JsonView(false, "参数为空"));
            }
            Edit_OptionalItemListDto _dto = JsonConvert.DeserializeObject<Edit_OptionalItemListDto>(jsonDto.Paras);
            //Edit_OptionalItemListDto _dto = System.Text.Json.JsonSerializer.Deserialize<Edit_OptionalItemListDto>(jsonDto.Paras);

            if (_dto.DiId < 1)
            {
                return Ok(JsonView(false, "团组Id为空"));
            }

            if (_dto.ConfItemListId < 1)
            {
                //新增
                int rstInsert = await _busRep.Insert_ConfItemList(_dto);
                return Ok(JsonView(rstInsert == 0));
            }
            else
            {
                //修改
                int rstUpdate = await _busRep.Edit_ConfItemList(_dto);
                return Ok(JsonView(rstUpdate == 0));
            }

            return Ok(JsonView(false));
        }

        /// <summary>
        /// 获取会务采购物料清单Excel
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> Excel_ConfItemList(JsonDtoBase jsonDto)
        {
            if (string.IsNullOrEmpty(jsonDto.Paras))
            {
                return Ok(JsonView(false, "参数为空"));
            }

            dynamic confList = JsonConvert.DeserializeObject<dynamic>(jsonDto.Paras);
            int confListId = confList.ConfListId;
            Bus_ConfItemListInfo _entityConfList = await _busRep.Query<Bus_ConfItemListInfo>(s => s.Id == confListId).FirstAsync();
            if (_entityConfList != null)
            {
                string result = new Excel_BusConfItemList().Excel(_entityConfList);


            }
            else
            {
                return Ok(JsonView(false, "请先保存数据"));
            }

            return Ok(JsonView(false));
        }

        #endregion

        #region 阿里云短信测试

        /// <summary>
        /// 编辑物料采购清单
        /// </summary>
        /// <returns></returns>
        [HttpPost]
        [ProducesResponseType(typeof(JsonView), StatusCodes.Status200OK)]
        public async Task<IActionResult> AliMessageTest(string mobile)
        {

            string add2dayZH = DateTime.Now.AddDays(2).ToString("yyyy年MM月dd日");
            string templateParam = JsonConvert.SerializeObject(new { teams = "测试团组", date = add2dayZH });
            AliMessagePost.PostMessage(mobile, "泛美国际团组", "SMS_461575447", templateParam);
            return Ok(JsonView(true));
        }

        #endregion
    }
}