using System;
using System.Collections.Generic;
using System.Linq;
using System.Web.Mvc;
using WX.CRM.Common;
using WX.CRM.IBLL.Wx;
using WX.CRM.Model.Entity;
using WX.CRM.WebHelper;

namespace WX.CRM.WEB.Controllers.WeiXin
{
    public class AuditPerformanceByUserController : BaseController
    {
        private readonly IWX_BALANCESALEUSERAUDIT _balancesaleuseraudit;
        private readonly IWX_BALANCESALEUSER _balancesaleuser;

        public AuditPerformanceByUserController(IWX_BALANCESALEUSERAUDIT balancesaleuseraudit, IWX_BALANCESALEUSER balancesaleuser)
        {
            _balancesaleuseraudit = balancesaleuseraudit;
            _balancesaleuser = balancesaleuser;
        }

        [HttpGet]
        [AuthorizeRedirect(Roles = InitRights.CONST_员工业绩确认)]
        [AuthorizeSession(HasRight = false)]
        public ActionResult Index()
        {
            ToolBar tb = new ToolBar();
            string[] balance = new ToolButtonView().ToolButtonRight(InitRights.员工业绩批量确认, userRightId);
            tb.AllowButton(balance);
            tb.AddOtherButton("Other1", "导出", "icon-export", "BtnExportAll_Click", true);
            tb.AddOtherButton("Other3", "批量确认", "icon-check", "", true);
            ViewBag.ToolBar = tb;

            string tableId = "tablist";
            Table tab = new Table(tableId);
            tab.AddHiddenHeadCol("pkid", "ID");
            tab.AddHiddenHeadCol("balancebatchid", "batchid");
            tab.AddHeadCol("month", "", "结算年月");
            //tab.AddHeadCol("ctime", "", "结算时间");
            tab.AddHeadCol("eid", "", "工号");
            tab.AddHeadCol("uname", "", "姓名");
            tab.AddHeadCol("gname", "", "组别");
            tab.AddHeadCol("isdismiss", "", "在/离职");
            tab.AddHeadCol("tousu", "", "投诉");
            tab.AddHeadCol("chufa", "", "处罚");
            tab.AddHeadCol("chuqin", "", "出勤率");
            tab.AddHeadCol("workday", "", "出勤天数");
            tab.AddHeadCol("dixing", "", "底薪");
            tab.AddHeadCol("PerformanceAmount", "", "业绩额");
            tab.AddHeadCol("commissionratio", "", "业绩额提成比例");
            tab.AddHeadCol("OrderCount", "", "单量");
            tab.AddHeadCol("ordercountratio", "", "单量提成比例");
            tab.AddHeadCol("allratio", "", "总比例");
            tab.AddHeadCol("AllPerformanceAmount", "", "本月提成金额");
            tab.AddHeadCol("yingshou", "", "本月应发金额");
            tab.AddHeadCol("yuliu", "", "本月预留金额");
            tab.AddHeadCol("fanhuan", "", "预留返还金额");
            tab.AddHeadCol("tuikuan", "", "退款");
            tab.AddHeadCol("deductions", "", "扣款缺勤");
            tab.AddHeadCol("reward", "", "全勤");
            tab.AddHeadCol("shishou", "", "本月实发金额");
            tab.AddHeadCol("status", "", "确认状态");
            tab.AddHiddenHeadCol("audittime", "确认时间");
            tab.AddHiddenHeadCol("auditbyusername", "确认人");
            tab.AddHiddenHeadCol("remark", "确认说明");
            tab.AddHeadRow();
            ViewBag.RptList = tab.GetHead();

            //ViewBag.inneruserid = UserId;
            //ViewBag.userGroupId = userGroupId;
            //ViewBag.saleDeptId = saleDeptId;
            //ViewBag.roleCodes = DataCacheHelper.GetCache().Get_RoleCodes(userRoleId);

            return View();
        }

        [HttpPost]
        [AuthorizeRedirect(Roles = InitRights.CONST_员工业绩确认)]
        [AuthorizeSession(HasRight = false)]
        public JsonResult Index(string saleDeptId, string groupId, string userId, string balanceCode, string status, string columns)
        {
            try
            {
                var roleCodes = DataCacheHelper.GetCache().Get_RoleCodes(userRoleId);
                DateTime? mcode = null;
                decimal uId = UserId;
                if (!string.IsNullOrEmpty(userId))
                {
                    decimal.TryParse(userId, out uId);
                }
                if (!string.IsNullOrEmpty(balanceCode))
                {
                    balanceCode = balanceCode + "-01";
                    mcode = DateTime.Parse(balanceCode);
                }
                Table table = new Table(columns, true);
                IList<WX_BALANCESALEUSERAUDIT> list;
                if (roleCodes.Contains("[CW]") || roleCodes.Contains("[ZJZL]") || roleCodes.Contains("[ZJ]"))
                    list = _balancesaleuseraudit.GetAutitList(string.Empty, 0, mcode, status);
                else
                    list = _balancesaleuseraudit.GetAutitList(groupId, uId, mcode, status);
                decimal batchId = 0;
                if (list.Any())
                    batchId = (from p in list select p.BALANCEBATCHID).Max();
                list = list.Where(p => p.BALANCEBATCHID == batchId).ToList();
                var month = DateTime.Parse("2017-08-01");
                foreach (var item in list)
                {
                    decimal gangwei = 0;
                    decimal zhengshu = 0;
                    var dixing = item.DIXING;

                    //这两个人考证通过，过程里面直接在底薪+200，所以这里需要-200
                    //if (item.EID == 6039 || item.EID == 6063)
                    //{
                    //    dixing = dixing - 200;
                    //    zhengshu = 200;
                    //}
                    //if (dixing >= 2400 && dixing < 2600)
                    //    gangwei = 200;
                    //else if (dixing >= 2600 && dixing < 2800)
                    //    gangwei = 400;
                    //else if (dixing >= 2800)
                    //    gangwei = 600;
                    table.AddHiddenCol(item.PKID);
                    table.AddHiddenCol(item.BALANCEBATCHID);
                    table.AddCol(item.MONTH.ToString("yyyy-MM"));
                    //table.AddCol(item.CTIME);
                    table.AddCol(item.EID);
                    table.AddCol(item.UNAME);
                    table.AddCol(item.GNAME);
                    table.AddCol(item.ISDISMISS.HasValue ? string.Format("{0}", item.ISDISMISS.Value == 1 ? "<span style='color:red'>离职</span>" : "在职") : "未知");
                    table.AddCol(item.TOUSU);
                    table.AddCol(item.CHUFA);
                    table.AddCol(item.CHUQIN + "%");
                    table.AddCol(item.WORKDAY);
                    table.AddCol(item.DIXING);
                    //table.AddCol(string.Format("<a href='javascript:void(0)' onclick='ShowDiXing({0},{2})'>{1}</a>", gangwei, item.DIXING, zhengshu));
                    table.AddCol(item.PERFORMANCEAMOUNT);
                    table.AddCol(item.COMMISSIONRATIO + "%");
                    table.AddCol(item.ORDERCOUNT);
                    table.AddCol(item.ORDERCOUNTRATIO + "%");
                    table.AddCol(item.ALLRATIO + "%");
                    table.AddCol(item.ALLPERFORMANCEAMOUNT);
                    table.AddCol(item.YINGSHOU);
                    table.AddCol(item.YULIU);
                    table.AddCol(item.FANHUAN);
                    //table.AddCol(item.TUIKUAN);
                    if (item.TUIKUAN <= 0)
                        table.AddCol(item.TUIKUAN);
                    else
                        table.AddCol(string.Format("<a href='javascript:void(0)' onclick='GetRefundInfo({0},\"{2}\");'>{1}</a>", item.INNERUSERID, item.TUIKUAN, mcode));
                    table.AddCol(item.DEDUCTIONS);
                    table.AddCol(item.REWARD);
                    table.AddCol(item.SHISHOU);
                    table.AddCol(string.Format("<a href='javascript:void(0)' onclick='Show2(\"{1}\",\"{2}\",\"{3}\")'>{0}</a>", item.STATUS, item.AUDITTIME.HasValue ? item.AUDITTIME.Value.ToShortDateString() : "", item.AUDITBYUSERNAME, item.REMARK));
                    table.AddHiddenCol(item.AUDITTIME.HasValue ? item.AUDITTIME.Value.ToShortDateString() : "");
                    table.AddHiddenCol(item.AUDITBYUSERNAME);
                    table.AddHiddenCol(item.REMARK);

                    table.AddRow();
                }
                var json = new
                {
                    rowsList = table.GetRows()
                };
                return Json(json, JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            {
                LogHelper.Error("AuditPerformanceByUserController:Index" + ex.Message + ex.StackTrace);
                return JsonHandler.ManageMessage(ex.Message, false);
            }
        }

        [AuthorizeSession(HasRight = false)]
        public FileResult Export(string saleDeptId, string groupId, string userId, string balanceCode, string status)
        {
            var roleCodes = DataCacheHelper.GetCache().Get_RoleCodes(userRoleId);
            DateTime? mcode = null;
            decimal uId = UserId;
            if (!string.IsNullOrEmpty(userId))
            {
                decimal.TryParse(userId, out uId);
            }
            if (!string.IsNullOrEmpty(balanceCode))
            {
                balanceCode = balanceCode + "-01";
                mcode = DateTime.Parse(balanceCode);
            }
            string checkedFilds = PageRequest.GetQueryString("checkedFilds");
            string checkedTitle = PageRequest.GetQueryString("checkedTitles");
            IList<WX_BALANCESALEUSERAUDIT> list;
            if (roleCodes.Contains("CW") || roleCodes.Contains("ZJZL"))
                list = _balancesaleuseraudit.GetAutitList(string.Empty, 0, mcode, status);
            else
                list = _balancesaleuseraudit.GetAutitList(string.Empty, uId, mcode, status);
            var batchId = (from p in list select p.BALANCEBATCHID).Max();
            list = list.Where(p => p.BALANCEBATCHID == batchId).ToList();
            var export = new List<WX_BALANCESALEUSERAUDITEXPORT>();
            foreach (var item in list)
            {
                var info = new WX_BALANCESALEUSERAUDITEXPORT()
                {
                    month = item.MONTH,
                    eid = item.EID,
                    uname = item.UNAME,
                    gname = item.GNAME,
                    isdismiss = item.ISDISMISS.GetValueOrDefault(0) == 1 ? "离职" : "在职",
                    tousu = item.TOUSU.GetValueOrDefault(0),
                    chufa = item.CHUFA.GetValueOrDefault(0),
                    chuqin = item.CHUQIN.GetValueOrDefault(0) + "%",
                    workday = item.WORKDAY.GetValueOrDefault(0),
                    dixing = item.DIXING,
                    PerformanceAmount = item.PERFORMANCEAMOUNT,
                    commissionratio = item.COMMISSIONRATIO.ToString() + "%",
                    OrderCount = item.ORDERCOUNT,
                    ordercountratio = item.ORDERCOUNTRATIO.ToString() + "%",
                    allratio = item.ALLRATIO.ToString() + "%",
                    AllPerformanceAmount = item.ALLPERFORMANCEAMOUNT,
                    yingshou = item.YINGSHOU,
                    yuliu = item.YULIU,
                    fanhuan = item.FANHUAN,
                    tuikuan = item.TUIKUAN,
                    shishou = item.SHISHOU,
                    deductions = item.DEDUCTIONS.GetValueOrDefault(0),
                    reward = item.REWARD.GetValueOrDefault(0),
                    status = item.STATUS,
                    auditbyusername = item.AUDITBYUSERNAME,
                    audittime = item.AUDITTIME,
                    remark = item.REMARK
                };
                export.Add(info);
            }
            return File(ExcelHelper.ExportListModelToExcel<WX_BALANCESALEUSERAUDITEXPORT>(export, "员工工资确认", 60000, checkedFilds, checkedTitle, null), "application/ms-excel", PageRequest.GetDlownLoadName("员工工资确认.xls"));
        }

        [AuthorizeSession(HasRight = false)]
        public JsonResult GetAuditPerformance()
        {
            try
            {
                string pkid = Request["PKID"];
                string sta = Request["PSTATUS"];
                string remark = Request["REMARK"];
                string _eid = Request["EID"];
                decimal _pkid = 0;
                int _sta = 0;
                if (!string.IsNullOrEmpty(pkid))
                    _pkid = decimal.Parse(pkid);
                if (!string.IsNullOrEmpty(sta))
                    _sta = int.Parse(sta);
                if (_eid != InnerUserHelper.Instance.GetEid(UserId))
                    return Json(new { result = 1, remark = "只能确认自已的业绩！" }, JsonRequestBehavior.AllowGet);
                /*确认业绩*/
                _balancesaleuseraudit.AuditPerformanceUser(_pkid, _sta, remark, UserId, UserName);
                var lis = new { result = 1, remark = "确认成功！" };
                return Json(lis, JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            {
                var lis = new { result = 0, remark = ex.Message };
                return Json(lis, JsonRequestBehavior.AllowGet);
            }
        }
        [AuthorizeSession(HasRight = false)]
        public JsonResult BatchAuditPerformance()
        {
            try
            {
                string balanceCode = Request["balanceCode"];
                DateTime _balanceCode = DateTime.Now;
                if (!string.IsNullOrEmpty(balanceCode))
                {
                    _balanceCode = DateTime.Parse(balanceCode + "-01");
                }
                /*批量确认业绩*/
                _balancesaleuseraudit.AuditBatchPerformanceUser(_balanceCode, UserId, UserName);
                var lis = new { result = 1, remark = "批量确认成功！" };
                return Json(lis, JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            {
                var lis = new { result = 0, remark = ex.Message };
                return Json(lis, JsonRequestBehavior.AllowGet);
            }
        }

        private class WX_BALANCESALEUSERAUDITEXPORT
        {
            public DateTime month { get; set; }
            public decimal eid { get; set; }
            public string uname { get; set; }
            public string gname { get; set; }
            public decimal? tousu { get; set; }
            public decimal? chufa { get; set; }
            public string chuqin { get; set; }
            public decimal? workday { get; set; }
            public decimal? dixing { get; set; }
            public decimal? PerformanceAmount { get; set; }
            public string commissionratio { get; set; }
            public decimal? OrderCount { get; set; }
            public string ordercountratio { get; set; }
            public string allratio { get; set; }
            public decimal? AllPerformanceAmount { get; set; }
            public decimal? yingshou { get; set; }
            public decimal? yuliu { get; set; }
            public decimal? fanhuan { get; set; }
            public decimal? tuikuan { get; set; }
            public decimal? deductions { get; set; }
            public decimal? reward { get; set; }
            public decimal? shishou { get; set; }
            public string status { get; set; }
            public DateTime? audittime { get; set; }
            public string auditbyusername { get; set; }
            public string remark { get; set; }
            public string isdismiss { get; set; }
        }
    }
}