using HH.AutoBom.Core;
using HH.AutoBom.Entity.Func;
using HH.WMS.Common;
using HH.WMS.Entitys.Check;
using HH.WMS.WebUI.Controllers;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace HH.WMS.WebUI.Areas.Check.Controllers
{
    /// <summary>
    /// 盘点（南通桑德）
    /// </summary>
    public class CheckWxysController : BaseController
    {
        /// <summary>
        /// 盘点首页
        /// </summary>
        /// <returns></returns>
        public ActionResult Index()
        {
            return View();
        }

        public ActionResult Add()
        {
            return View();
        }

        public ActionResult Audit()
        {
            return View();
        }

        #region GET

        /// <summary>
        /// 获取盘点主表数据
        /// </summary>
        ///  <param name="CN_S_OP_NO">盘点单号</param>
        /// <param name="CN_S_STOCK_CODE">仓库编码</param>
        /// <param name="CN_S_STOCK_AREA">库区</param>
        /// <param name="CN_S_ITEM_CODE">物料编码</param>
        /// <param name="CN_T_OPERATE">盘点日期</param>
        /// <param name="CN_S_TYPE">类型</param>
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/7/4</history>
        public string GetCheckMst(int pageIndex, int pageSize, string CN_S_OP_NO, string CN_S_TYPE, string CN_S_STOCK_CODE, string CHECKTIME, string CN_S_STATE, string valueDate)
        {
            string sqlWhere = "WHERE 1=1";

            //仓库编码
            if (!string.IsNullOrEmpty(CN_S_OP_NO))
            {
                sqlWhere += " AND CN_S_OP_NO like '%" + CN_S_OP_NO.Trim() + "%'";
            }
            //仓库编码
            if (!string.IsNullOrEmpty(CN_S_STOCK_CODE))
            {
                sqlWhere += " AND CN_S_STOCK_CODE = '" + CN_S_STOCK_CODE + "'";
            }
            //类型
            if (!string.IsNullOrEmpty(CN_S_TYPE))
            {
                sqlWhere += " AND CN_S_TYPE = '" + CN_S_TYPE + "' ";
            }

            string[] date = new string[2];
            if (!string.IsNullOrEmpty(valueDate))
            {
                date = JsonConvert.DeserializeObject<string[]>(valueDate);

                ////开始时间
                if (!string.IsNullOrEmpty(date[0]))
                {
                    sqlWhere += " AND CN_T_CREATE >= '" + date[0] + "' ";
                }
                //结束时间
                if (!string.IsNullOrEmpty(date[1]))
                {
                    sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + date[1] + "')";
                }
            }
            ////开始时间
            //if (!string.IsNullOrEmpty(STARTTIME))
            //{
            //    sqlWhere += " AND CN_T_CREATE >= '" + STARTTIME + "' ";
            //}
            ////结束时间
            //if (!string.IsNullOrEmpty(ENDTIME))
            //{
            //    sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + ENDTIME + "')";
            //}

            //状态
            if (!string.IsNullOrEmpty(CN_S_STATE))
            {
                sqlWhere += " AND CN_S_STATE = '" + CN_S_STATE + "'";
            }
            string OrdeBy = " order by  CN_T_CREATE DESC";

            var loginer = FormsAuth.GetUserData<LoginerBase>();
            var checkAuditOrgDto = GetCheckAuditOrgDto();
            var entity = new
            {
                tokenId = loginer.Extend1,
                OrdeBy = OrdeBy,
                sqlWhere = sqlWhere,
                pageSize = pageSize,
                pageIndex = pageIndex,
                isFirstLevelOrg = checkAuditOrgDto.isFirstLevelOrg,
                currentOrgCode = checkAuditOrgDto.currentOrgCode
            };
            string stringjson = JsonConvert.SerializeObject(entity);
            string list = HttpWMS_Post("Api/CheckWxys/GetCheckMst", stringjson);
            return list;
        }

        /// <summary>
        /// 获取盘点明细数据
        /// </summary>
        /// <param name="CN_S_OP_NO">仓库编码</param>
        /// <returns></returns>
        /// <history>[HanHe(LT)] CREATED 2018/7/4</history>
        /// <history>[HanHe(dbs)] CREATED 2019/3/18</history>
        public string GetCheckDtl(string opNo)
        {
            string list = HttpWMS_Get("Api/CheckWxys/GetCheckDtl?opNo=" + opNo);
            return list;
        }

        public string GetCheckList(int pageIndex, int pageSize,string CN_S_STOCK_CODE, string stockArea, string locationCode, string opNo = "")
        {
            string sqlWhere = "WHERE 1=1";

            ////仓库编码
            //if (!string.IsNullOrEmpty(CN_S_OP_NO))
            //{
            //    sqlWhere += " AND CN_S_OP_NO like '%" + CN_S_OP_NO.Trim() + "%'";
            //}
            ////仓库编码
            //if (!string.IsNullOrEmpty(CN_S_STOCK_CODE))
            //{
            //    sqlWhere += " AND CN_S_STOCK_CODE = '" + CN_S_STOCK_CODE + "'";
            //}
            ////类型
            //if (!string.IsNullOrEmpty(CN_S_TYPE))
            //{
            //    sqlWhere += " AND CN_S_TYPE = '" + CN_S_TYPE + "' ";
            //}

            //string[] date = new string[2];
            //if (!string.IsNullOrEmpty(valueDate))
            //{
            //    date = JsonConvert.DeserializeObject<string[]>(valueDate);

            //    ////开始时间
            //    if (!string.IsNullOrEmpty(date[0]))
            //    {
            //        sqlWhere += " AND CN_T_CREATE >= '" + date[0] + "' ";
            //    }
            //    //结束时间
            //    if (!string.IsNullOrEmpty(date[1]))
            //    {
            //        sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + date[1] + "')";
            //    }
            //}
            ////开始时间
            //if (!string.IsNullOrEmpty(STARTTIME))
            //{
            //    sqlWhere += " AND CN_T_CREATE >= '" + STARTTIME + "' ";
            //}
            ////结束时间
            //if (!string.IsNullOrEmpty(ENDTIME))
            //{
            //    sqlWhere += " AND CN_T_CREATE <= DateAdd(dd, 1, '" + ENDTIME + "')";
            //}

            //状态
            //if (!string.IsNullOrEmpty(CN_S_STATE))
            //{
            //    sqlWhere += " AND CN_S_STATE = '" + CN_S_STATE + "'";
            //}
            string OrdeBy = " order by  CN_T_CREATE DESC";

            var loginer = FormsAuth.GetUserData<LoginerBase>();
            var entity = new
            {
                tokenId = loginer.Extend1,
                OrdeBy = OrdeBy,
                sqlWhere = sqlWhere,
                pageSize = pageSize,
                pageIndex = pageIndex,
                opNo,
                locationCode,
                stockArea
            };
            string stringjson = JsonConvert.SerializeObject(entity);
            string list = HttpWMS_Post("Api/CheckWxys/GetCheckList", stringjson);
            return list;
        }

        public string GetCheckListByOpNo(string opNo)
        {
            var result = HttpWMS_Get("Api/CheckWxys/GetCheckListByOpNo?opNo=" + opNo);
            return result;
        }

        public string GetMstAndDtl(string opNo)
        {
            var result = HttpWMS_Get("Api/CheckWxys/GetMstAndDtl?opNo=" + opNo);
            return result;
        }

        public string GetLoginOrg()
        {
            var checkAuditOrgDto = GetCheckAuditOrgDto();
            return JsonConvert.SerializeObject(checkAuditOrgDto);
        }

        public CheckAuditOrgDto GetCheckAuditOrgDto()
        {
            var loginer = FormsAuth.GetUserData<LoginerBase>();
            string postData = "{\"login\":\"" + loginer.UserCode + "\",\"NoOrgType\":\"\",\"isShowAll\":\"Y\" }";
            var data = HttpAutobom_Post("api/Account/GetLoginOrg", postData);
            var orgUserPower = JsonConvert.DeserializeObject<OrgUserPowerEntity>(data);
            var currentOrg = loginer.DepartCode;
            var orgTop = orgUserPower.childrenList.Find(e => e.pId.Equals("-1"));
            if (orgTop.id.Equals(loginer.DepartCode))
            {
                return new CheckAuditOrgDto
                {
                    currentOrgCode = orgTop.id,
                    currentOrgName = orgTop.name,
                    isFirstLevelOrg = false,
                    isTopLevelOrg = true,
                    nextOrgCode = "",
                    nextOrgName = ""
                };
            }

            var orgCurrent = orgUserPower.childrenList.Find(e => e.id.Equals(currentOrg));

            var checkAuditOrgDto = new CheckAuditOrgDto();
            checkAuditOrgDto.currentOrgCode = orgCurrent.id;
            checkAuditOrgDto.currentOrgName = orgCurrent.name;
            checkAuditOrgDto.isTopLevelOrg = false;
            checkAuditOrgDto.isFirstLevelOrg = orgUserPower.childrenList.Find(e => e.pId.Equals(currentOrg)) == null ? true : false;
            foreach (var org in orgUserPower.childrenList)
            {
                if (org.id.Equals(orgCurrent.pId))
                {
                    checkAuditOrgDto.nextOrgCode = org.id;
                    checkAuditOrgDto.nextOrgName = org.name;
                }
            }
            return checkAuditOrgDto;
        }

        #endregion

        #region ADD

        /// <summary>
        /// 添加盘点单
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string AddCheck(JObject obj)
        {
            var loginer = FormsAuth.GetUserData<LoginerBase>();
            var checkList = JsonConvert.DeserializeObject<List<TN_WM_CHECK_LISTEntity>>(obj["rows"].ToString());

            var data = new CheckAddDto{
                tokenId = loginer.Token,
                checkList = checkList,
            };
            string jsonentity = JsonConvert.SerializeObject(data);
            var str = HttpWMS_Post("Api/CheckWxys/Add", jsonentity);
            return str;
        }

        public string UpdateCheck(JObject obj)
        {
            var loginer = FormsAuth.GetUserData<LoginerBase>();
            var checkList = JsonConvert.DeserializeObject<List<TN_WM_CHECK_LISTEntity>>(obj["rows"].ToString());

            var data = new CheckAddDto
            {
                tokenId = loginer.Token,
                checkList = checkList,
                opNo = obj["opNo"].ToString()
            };
            string jsonentity = JsonConvert.SerializeObject(data);
            var str = HttpWMS_Post("Api/CheckWxys/Update", jsonentity);
            return str;
        }

        #endregion

        #region UPDATE

        public string SubmitCheck(string opNo, string note)
        {
            return HttpWMS_Post("Api/CheckWxys/Submit", JsonConvert.SerializeObject(new CheckAuditDto
            {
                opNo = opNo,
                note = note,
                checkAuditOrgDto = GetCheckAuditOrgDto()
            }));
        }

        public string AuditCheck(string opNo)
        {
            return HttpWMS_Post("Api/CheckWxys/Audit", JsonConvert.SerializeObject(new CheckAuditDto
            {
                opNo = opNo,
                checkAuditOrgDto = GetCheckAuditOrgDto()
            }));
        }

        public string ReAuditCheck(string opNo, string auditContent)
        {
            return HttpWMS_Post("Api/CheckWxys/ReAudit", JsonConvert.SerializeObject(new CheckAuditDto
            {
                opNo = opNo,
                auditContent = auditContent,
                checkAuditOrgDto = GetCheckAuditOrgDto()
            }));
        }

        #endregion

        #region DELETE

        /// <summary>
        /// 删除盘点单
        /// </summary>
        /// <param name="opNo"></param>
        /// <returns></returns>
        public string DeleteCheck(string opNo)
        {
            return HttpWMS_Get("Api/CheckWxys/Delete?opNo=" + opNo);
        }

        #endregion

    }
}