using System;
using System.Collections.Generic;
using System.Linq;
using System.Data;
using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Http;
using Microsoft.Extensions.Logging;
using Microsoft.Extensions.Options;
using Microsoft.AspNetCore.Authorization;
using System.Web;
using MySystem.MainModels;
using LitJson;
using Library;

namespace MySystem.Areas.Api.Controllers.v2
{
    [Area("Api")]
    [Route("Api/v2/[controller]/[action]")]
    public class TradeDaySummaryController : BaseController
    {
        public TradeDaySummaryController(IHttpContextAccessor accessor, ILogger<BaseController> logger, IOptions<Setting> setting) : base(accessor, logger, setting)
        {
            OtherMySqlConn.connstr = Library.ConfigurationManager.AppSettings["SqlConnStr"].ToString();
        }

        //数据库链接
        public string StatConn = Library.ConfigurationManager.AppSettings["TSqlConnStr"].ToString();


        #region 创客-首页-交易分析-交易明细
        [Authorize]
        public JsonResult Detail(string value)
        {
            value = DesDecrypt(value);
            JsonData data = JsonMapper.ToObject(value);
            Dictionary<string, object> Obj = DetailDo(value);
            return Json(new AppResultJson() { Status = "1", Info = "", Data = Obj });
        }
        public Dictionary<string, object> DetailDo(string value)
        {
            JsonData data = JsonMapper.ToObject(value);
            int UserId = int.Parse(function.CheckInt(data["UserId"].ToString())); //创客
            int BrandId = int.Parse(function.CheckInt(data["BrandId"].ToString())); //品牌
            string TradeMonthOrDate = data["TradeMonthOrDate"].ToString(); //月份或日期
            string Kind = data["Kind"].ToString(); //类别
            Dictionary<string, object> Obj = new Dictionary<string, object>();

            List<TradeDaySummary> query = new List<TradeDaySummary>();
            DataTable dt = new DataTable();

            //扶持期
            decimal TotalAmtfc = 0;
            decimal DAmtfc = 0;
            decimal JAmtfc = 0;
            decimal JfAmtfc = 0;
            int JCountfc = 0;
            decimal YAmtfc = 0;

            //稳定期
            decimal TotalAmtwd = 0;
            decimal DAmtwd = 0;
            decimal JAmtwd = 0;
            decimal JfAmtwd = 0;
            int JCountwd = 0;
            decimal YAmtwd = 0;

            //盈利期
            decimal TotalAmtyl = 0;
            decimal DAmtyl = 0;
            decimal JAmtyl = 0;
            decimal JfAmtyl = 0;
            int JCountyl = 0;
            decimal YAmtyl = 0;

            if (Kind == "team")
            {
                dt = CustomerSqlConn.dtable("SELECT SUM(HelpTradeAmount) TotalAmtfc, SUM(HelpCreditTradeAmount) DAmtfc, SUM(HelpDebitNotCapTradeAmount) JAmtfc, SUM(HelpDebitCapTradeAmount) JfAmtfc, SUM(HelpDebitCapTradeCount) JCountfc, SUM(HelpQrTradeAmount) YAmtfc, SUM(NotHelpTradeAmount) TotalAmtwd, SUM(NotHelpCreditTradeAmount) DAmtwd, SUM(NotHelpDebitNotCapTradeAmount) JAmtwd, SUM(NotHelpDebitCapTradeAmount) JfAmtwd, SUM(NotHelpDebitCapTradeCount) JCountwd, SUM(NotHelpQrTradeAmount) YAmtwd, SUM(ProfitTradeAmount) TotalAmtyl, SUM(ProfitCreditTradeAmount) DAmtyl, SUM(ProfitDebitNotCapTradeAmount) JAmtyl, SUM(ProfitDebitCapTradeAmount) JfAmtyl, SUM(ProfitDebitCapTradeCount) JCountyl, SUM(ProfitQrTradeAmount) YAmtyl FROM TradeStat" + TradeMonthOrDate + " WHERE UserId=" + UserId + " AND DirectFlag=0 AND BrandId=" + BrandId + "", StatConn);
                if (dt.Rows.Count > 0)
                {
                    TotalAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["TotalAmtfc"].ToString()));
                    DAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["DAmtfc"].ToString()));
                    JAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["JAmtfc"].ToString()));
                    JfAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["JfAmtfc"].ToString()));
                    JCountfc = int.Parse(function.CheckInt(dt.Rows[0]["JCountfc"].ToString()));
                    YAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["YAmtfc"].ToString()));

                    TotalAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["TotalAmtwd"].ToString()));
                    DAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["DAmtwd"].ToString()));
                    JAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["JAmtwd"].ToString()));
                    JfAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["JfAmtwd"].ToString()));
                    JCountwd = int.Parse(function.CheckInt(dt.Rows[0]["JCountwd"].ToString()));
                    YAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["YAmtwd"].ToString()));

                    TotalAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["TotalAmtyl"].ToString()));
                    DAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["DAmtyl"].ToString()));
                    JAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["JAmtyl"].ToString()));
                    JfAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["JfAmtyl"].ToString()));
                    JCountyl = int.Parse(function.CheckInt(dt.Rows[0]["JCountyl"].ToString()));
                    YAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["YAmtyl"].ToString()));
                }
            }
            else
            {
                dt = CustomerSqlConn.dtable("SELECT SUM(HelpTradeAmount) TotalAmtfc, SUM(HelpCreditTradeAmount) DAmtfc, SUM(HelpDebitNotCapTradeAmount) JAmtfc, SUM(HelpDebitCapTradeAmount) JfAmtfc, SUM(HelpDebitCapTradeCount) JCountfc, SUM(HelpQrTradeAmount) YAmtfc, SUM(NotHelpTradeAmount) TotalAmtwd, SUM(NotHelpCreditTradeAmount) DAmtwd, SUM(NotHelpDebitNotCapTradeAmount) JAmtwd, SUM(NotHelpDebitCapTradeAmount) JfAmtwd, SUM(NotHelpDebitCapTradeCount) JCountwd, SUM(NotHelpQrTradeAmount) YAmtwd, SUM(ProfitTradeAmount) TotalAmtyl, SUM(ProfitCreditTradeAmount) DAmtyl, SUM(ProfitDebitNotCapTradeAmount) JAmtyl, SUM(ProfitDebitCapTradeAmount) JfAmtyl, SUM(ProfitDebitCapTradeCount) JCountyl, SUM(ProfitQrTradeAmount) YAmtyl FROM TradeStat" + TradeMonthOrDate + " WHERE UserId=" + UserId + " AND DirectFlag=1 AND BrandId=" + BrandId + "", StatConn);
                if (dt.Rows.Count > 0)
                {
                    TotalAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["TotalAmtfc"].ToString()));
                    DAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["DAmtfc"].ToString()));
                    JAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["JAmtfc"].ToString()));
                    JfAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["JfAmtfc"].ToString()));
                    JCountfc = int.Parse(function.CheckInt(dt.Rows[0]["JCountfc"].ToString()));
                    YAmtfc = decimal.Parse(function.CheckNum(dt.Rows[0]["YAmtfc"].ToString()));

                    TotalAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["TotalAmtwd"].ToString()));
                    DAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["DAmtwd"].ToString()));
                    JAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["JAmtwd"].ToString()));
                    JfAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["JfAmtwd"].ToString()));
                    JCountwd = int.Parse(function.CheckInt(dt.Rows[0]["JCountwd"].ToString()));
                    YAmtwd = decimal.Parse(function.CheckNum(dt.Rows[0]["YAmtwd"].ToString()));

                    TotalAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["TotalAmtyl"].ToString()));
                    DAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["DAmtyl"].ToString()));
                    JAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["JAmtyl"].ToString()));
                    JfAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["JfAmtyl"].ToString()));
                    JCountyl = int.Parse(function.CheckInt(dt.Rows[0]["JCountyl"].ToString()));
                    YAmtyl = decimal.Parse(function.CheckNum(dt.Rows[0]["YAmtyl"].ToString()));
                }
            }

            Obj.Add("TotalAmtfc", TotalAmtfc); //刷卡交易总额(扶持期)
            Obj.Add("DAmtfc", DAmtfc); //贷记卡交易额(扶持期)
            Obj.Add("JAmtfc", JAmtfc); //借记卡交易总额(扶持期) 
            Obj.Add("JfAmtfc", JfAmtfc); //借记卡封顶交易额(扶持期)
            Obj.Add("JCountfc", JCountfc); //借记卡封顶笔数(扶持期)
            Obj.Add("YAmtfc", YAmtfc); //云闪付小额交易额(扶持期)

            Obj.Add("TotalAmtwd", TotalAmtwd); //刷卡交易总额(稳定期)
            Obj.Add("DAmtwd", DAmtwd); //贷记卡交易额(稳定期)  
            Obj.Add("JAmtwd", JAmtwd); //借记卡交易总额(稳定期)
            Obj.Add("JfAmtwd", JfAmtwd); //借记卡封顶交易额(稳定期)
            Obj.Add("JCountwd", JCountwd); //借记卡封顶笔数(稳定期)
            Obj.Add("YAmtwd", YAmtwd); //云闪付小额交易额(稳定期) 

            Obj.Add("TotalAmtyl", TotalAmtyl); //刷卡交易总额(盈利期)
            Obj.Add("DAmtyl", DAmtyl); //贷记卡交易额(盈利期)  
            Obj.Add("JAmtyl", JAmtyl); //借记卡交易总额(盈利期)
            Obj.Add("JfAmtyl", JfAmtyl); //借记卡封顶交易额(盈利期)
            Obj.Add("JCountyl", JCountyl); //借记卡封顶笔数(盈利期)
            Obj.Add("YAmtyl", YAmtyl); //云闪付小额交易额(盈利期) 
            return Obj;
        }
        #endregion



        #region 检查签名是否合法，合法返回1，不合法返回提示信息

        /// <summary>
        /// 检查签名是否合法，合法返回1，不合法返回提示信息
        /// </summary>
        /// <param name="value">请求的参数(json字符串)</param>
        /// <param name="signField">要签名的字段</param>
        /// <returns></returns>
        private string CheckSign(string value, string[] signField)
        {
            JsonData json = JsonMapper.ToObject(value);
            Dictionary<string, string> dic = new Dictionary<string, string>();
            for (int i = 0; i < signField.Length; i++)
            {
                dic.Add(signField[i], json[signField[i]].ToString());
            }
            string sign = json["sign"].ToString(); //客户端签名字符串
            return new Sign().sign(dic, sign);
        }

        #endregion

    }
}