username@email.com
2023-07-10 050d8fde17d71d0e5d3353984a55838903abbe36
zhengcaioa/zhengcaioa/Controllers/admin/TongjiBaoBiaoController.cs
@@ -201,9 +201,12 @@
            xiangmuDTO.gongzuo = "采购项目录入";
            //本月数量
            var projectDTOsyue = _projectService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin);
           // var zhengfuprojectDTOsyue = _projectService.GetListsalaryzhengfu(curentuser.Id, dateminkaoqin, datemaxkaoqin);
            xiangmuDTO.benyueshuliang = projectDTOsyue.Count.ToString();
            //本日数量
            var projectDTOsri = projectDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
           // var zhengfuprojectDTOsri = zhengfuprojectDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
            xiangmuDTO.benrishuliang = projectDTOsri.Count.ToString();
            var jijianixiangmu = fiPiecerateDTOs.Where(x =>   x.Project == "采购项目录入").FirstOrDefault();
@@ -248,6 +251,59 @@
                tuiguangDTOs.Add(xiangmuDTO);
            #endregion
            #region 采购公告录入
            TongjiBaoBiaoDTO caigougonggaoDTO = new TongjiBaoBiaoDTO();
            caigougonggaoDTO.gongzuo = "采购公告录入";
            //本月数量
            var caigougonggaoDTOsyue = _projectService.GetcaigougonggaoListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin);
            caigougonggaoDTO.benyueshuliang = caigougonggaoDTOsyue.Count.ToString();
            //本日数量
            var caigougonggaoDTOsri = caigougonggaoDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
            caigougonggaoDTO.benrishuliang = caigougonggaoDTOsri.Count.ToString();
            var jijianicaigougonggao = fiPiecerateDTOs.Where(x => x.Project == "采购公告录入").FirstOrDefault();
            if (jijianicaigougonggao != null)
            {
                var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianicaigougonggao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
                if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
                {
                    if (jixiaotichengfangan.Renwustandard == "01")
                    {
                        //本月规定
                        caigougonggaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                        //本日规定
                        caigougonggaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
                        if (jixiaotichengfangan.Tichengstandard == "01")
                        {
                            decimal youxiaojijian = caigougonggaoDTOsri.Count - jixiaotichengfangan.Renwu.Value;
                            if (youxiaojijian > 0)
                            {
                                caigougonggaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
                            }
                        }
                    }
                    else if (jixiaotichengfangan.Renwustandard == "02")
                    {
                        //本月规定
                        caigougonggaoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
                        //if (jixiaotichengfangan.Tichengstandard == "01")
                        //{
                        //    decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu;
                        //    if (youxiaojijian > 0)
                        //    {
                        //        hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
                        //    }
                        //}
                    }
                }
            }
            if (caigougonggaoDTOsyue.Count > 0 || caigougonggaoDTOsri.Count > 0)
                tuiguangDTOs.Add(caigougonggaoDTO);
            #endregion
            #region 客户资料录入
            TongjiBaoBiaoDTO kehuluruDTO = new TongjiBaoBiaoDTO();
@@ -672,10 +728,10 @@
                tuiguangDTOs.Add(qunzutuiguangDTO);
            #endregion
            #region 朋友圈原创
            #region 朋友圈转发
            TongjiBaoBiaoDTO pengyouquanDTO = new TongjiBaoBiaoDTO();
            pengyouquanDTO.gongzuo = "朋友圈原创";
            var jijianipengyouquan = fiPiecerateDTOs.Where(x =>   x.Project == "朋友圈原创").FirstOrDefault();
            pengyouquanDTO.gongzuo = "朋友圈转发";
            var jijianipengyouquan = fiPiecerateDTOs.Where(x =>   x.Project == "朋友圈转发").FirstOrDefault();
            if (jijianipengyouquan != null)
            {
@@ -720,16 +776,22 @@
                        //}
                    }
                    else if (jixiaotichengfangan.Renwustandard == "05")
                    {
                        //本月规定
                        pengyouquanDTO.benyueqingkuang = (4 * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                    }
                }
            }
            if (decimal.Parse(pengyouquanDTO.benyueshuliang) > 0 || decimal.Parse(pengyouquanDTO.benrishuliang) > 0)
                tuiguangDTOs.Add(pengyouquanDTO);
            #endregion
            #region 论坛发帖
            #region 论坛推广
            TongjiBaoBiaoDTO luntanfatieDTO = new TongjiBaoBiaoDTO();
            luntanfatieDTO.gongzuo = "论坛发帖";
            var jijianiluntanfatie = fiPiecerateDTOs.Where(x =>   x.Project == "论坛发帖").FirstOrDefault();
            luntanfatieDTO.gongzuo = "论坛推广";
            var jijianiluntanfatie = fiPiecerateDTOs.Where(x =>   x.Project == "论坛推广").FirstOrDefault();
            if (jijianiluntanfatie != null)
            {
@@ -780,10 +842,10 @@
                tuiguangDTOs.Add(luntanfatieDTO);
            #endregion
            #region 跟帖评论
            #region 贴吧推广
            TongjiBaoBiaoDTO gentiepinglunDTO = new TongjiBaoBiaoDTO();
            gentiepinglunDTO.gongzuo = "跟帖评论";
            var jijianigentiepinglun = fiPiecerateDTOs.Where(x =>   x.Project == "跟帖评论").FirstOrDefault();
            gentiepinglunDTO.gongzuo = "贴吧推广";
            var jijianigentiepinglun = fiPiecerateDTOs.Where(x =>   x.Project == "贴吧推广").FirstOrDefault();
            if (jijianigentiepinglun != null)
            {
@@ -1200,16 +1262,22 @@
                        //}
                    }
                    else if (jixiaotichengfangan.Renwustandard == "05")
                    {
                        //本月规定
                        shangmenbanfangDTO.benyueqingkuang = (4 * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                    }
                }
            }
            if (decimal.Parse(shangmenbanfangDTO.benyueshuliang) > 0 || decimal.Parse(shangmenbanfangDTO.benrishuliang) > 0)
                baifangkehuDTOs.Add(shangmenbanfangDTO);
            #endregion
            #region 接待来访客户
            #region 录入客户咨询
            TongjiBaoBiaoDTO jiedailaifangDTO = new TongjiBaoBiaoDTO();
            jiedailaifangDTO.gongzuo = "接待来访客户";
            var jijianijiedailaifang = fiPiecerateDTOs.Where(x =>   x.Project == "接待来访客户").FirstOrDefault();
            jiedailaifangDTO.gongzuo = "录入客户咨询";
            var jijianijiedailaifang = fiPiecerateDTOs.Where(x =>   x.Project == "录入客户咨询").FirstOrDefault();
            if (jijianijiedailaifang != null)
            {
@@ -1470,10 +1538,10 @@
                ziliaoweihuDTOs.Add(zhengcaizhishiDTO);
            #endregion
            #region 新增公众号关注
            #region 微信微博公众号新增粉丝
            TongjiBaoBiaoDTO gongzhonghaoDTO = new TongjiBaoBiaoDTO();
            gongzhonghaoDTO.gongzuo = "新增公众号关注";
            var jijianigongzhonghao = fiPiecerateDTOs.Where(x =>  x.Project == "新增公众号关注").FirstOrDefault();
            gongzhonghaoDTO.gongzuo = "微信微博公众号新增粉丝";
            var jijianigongzhonghao = fiPiecerateDTOs.Where(x =>  x.Project == "微信微博公众号新增粉丝").FirstOrDefault();
            if (jijianigongzhonghao != null)
            {
@@ -1962,9 +2030,11 @@
                    xiangmuDTO.gongzuo = "采购项目录入";
                    //本月数量
                    var projectDTOsyue = _projectService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin);
                    //var zhengfuprojectDTOsyue = _projectService.GetListsalaryzhengfu(Userid, dateminkaoqin, datemaxkaoqin);
                    xiangmuDTO.benyueshuliang = projectDTOsyue.Count.ToString();
                    //本日数量
                    var projectDTOsri = projectDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
                    //var zhengfuprojectDTOsri = zhengfuprojectDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
                    xiangmuDTO.benrishuliang = projectDTOsri.Count.ToString();
                    var jijianixiangmu = fiPiecerateDTOs.Where(x => x.Project == "采购项目录入").FirstOrDefault();
@@ -1982,7 +2052,7 @@
                                xiangmuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
                                if (jixiaotichengfangan.Tichengstandard == "01")
                                {
                                    decimal youxiaojijian = projectDTOsri.Count - jixiaotichengfangan.Renwu.Value;
                                    decimal youxiaojijian = projectDTOsri.Count  - jixiaotichengfangan.Renwu.Value;
                                    if (youxiaojijian > 0)
                                    {
                                        xiangmuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
@@ -2009,6 +2079,58 @@
                        tuiguangDTOs.Add(xiangmuDTO);
                    #endregion
                    #region 采购公告录入
                    TongjiBaoBiaoDTO caigougonggaoDTO = new TongjiBaoBiaoDTO();
                    caigougonggaoDTO.gongzuo = "采购公告录入";
                    //本月数量
                    var caigougonggaoDTOsyue = _projectService.GetcaigougonggaoListsalary(Userid, dateminkaoqin, datemaxkaoqin);
                    caigougonggaoDTO.benyueshuliang = caigougonggaoDTOsyue.Count.ToString();
                    //本日数量
                    var caigougonggaoDTOsri = caigougonggaoDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
                    caigougonggaoDTO.benrishuliang = caigougonggaoDTOsri.Count.ToString();
                    var jijianicaigougonggao = fiPiecerateDTOs.Where(x => x.Project == "采购公告录入").FirstOrDefault();
                    if (jijianicaigougonggao != null)
                    {
                        var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianicaigougonggao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
                        if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
                        {
                            if (jixiaotichengfangan.Renwustandard == "01")
                            {
                                //本月规定
                                caigougonggaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                                //本日规定
                                caigougonggaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
                                if (jixiaotichengfangan.Tichengstandard == "01")
                                {
                                    decimal youxiaojijian = caigougonggaoDTOsri.Count - jixiaotichengfangan.Renwu.Value;
                                    if (youxiaojijian > 0)
                                    {
                                        caigougonggaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
                                    }
                                }
                            }
                            else if (jixiaotichengfangan.Renwustandard == "02")
                            {
                                //本月规定
                                caigougonggaoDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
                                //if (jixiaotichengfangan.Tichengstandard == "01")
                                //{
                                //    decimal youxiaojijian = _intentionCustomerDTOs.Count + cooperatecustomCustomerDTOs.Count - renwujishu;
                                //    if (youxiaojijian > 0)
                                //    {
                                //        hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
                                //    }
                                //}
                            }
                        }
                    }
                    if (caigougonggaoDTOsyue.Count > 0 || caigougonggaoDTOsri.Count > 0)
                        tuiguangDTOs.Add(caigougonggaoDTO);
                    #endregion
                    #region 客户资料录入
                    TongjiBaoBiaoDTO kehuluruDTO = new TongjiBaoBiaoDTO();
@@ -2192,7 +2314,7 @@
                                weixnDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
                                if (jixiaotichengfangan.Tichengstandard == "01")
                                {
                                    decimal youxiaojijian = cooperweixinDTOsri.Count + intentionweixinDTOsyue.Count - jixiaotichengfangan.Renwu.Value;
                                    decimal youxiaojijian = cooperweixinDTOsri.Count + intentionweixinDTOsri.Count - jixiaotichengfangan.Renwu.Value;
                                    if (youxiaojijian > 0)
                                    {
                                        weixnDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
@@ -2433,10 +2555,10 @@
                        tuiguangDTOs.Add(qunzutuiguangDTO);
                    #endregion
                    #region 朋友圈原创
                    #region 朋友圈转发
                    TongjiBaoBiaoDTO pengyouquanDTO = new TongjiBaoBiaoDTO();
                    pengyouquanDTO.gongzuo = "朋友圈原创";
                    var jijianipengyouquan = fiPiecerateDTOs.Where(x => x.Project == "朋友圈原创").FirstOrDefault();
                    pengyouquanDTO.gongzuo = "朋友圈转发";
                    var jijianipengyouquan = fiPiecerateDTOs.Where(x => x.Project == "朋友圈转发").FirstOrDefault();
                    if (jijianipengyouquan != null)
                    {
@@ -2481,16 +2603,22 @@
                                //}
                            }
                            else if (jixiaotichengfangan.Renwustandard == "05")
                            {
                                //本月规定
                                pengyouquanDTO.benyueqingkuang = (4 * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                            }
                        }
                    }
                    if (decimal.Parse(pengyouquanDTO.benyueshuliang) > 0 || decimal.Parse(pengyouquanDTO.benrishuliang) > 0)
                        tuiguangDTOs.Add(pengyouquanDTO);
                    #endregion
                    #region 论坛发帖
                    #region 论坛推广
                    TongjiBaoBiaoDTO luntanfatieDTO = new TongjiBaoBiaoDTO();
                    luntanfatieDTO.gongzuo = "论坛发帖";
                    var jijianiluntanfatie = fiPiecerateDTOs.Where(x => x.Project == "论坛发帖").FirstOrDefault();
                    luntanfatieDTO.gongzuo = "论坛推广";
                    var jijianiluntanfatie = fiPiecerateDTOs.Where(x => x.Project == "论坛推广").FirstOrDefault();
                    if (jijianiluntanfatie != null)
                    {
@@ -2541,10 +2669,10 @@
                        tuiguangDTOs.Add(luntanfatieDTO);
                    #endregion
                    #region 跟帖评论
                    #region 贴吧推广
                    TongjiBaoBiaoDTO gentiepinglunDTO = new TongjiBaoBiaoDTO();
                    gentiepinglunDTO.gongzuo = "跟帖评论";
                    var jijianigentiepinglun = fiPiecerateDTOs.Where(x => x.Project == "跟帖评论").FirstOrDefault();
                    gentiepinglunDTO.gongzuo = "贴吧推广";
                    var jijianigentiepinglun = fiPiecerateDTOs.Where(x => x.Project == "贴吧推广").FirstOrDefault();
                    if (jijianigentiepinglun != null)
                    {
@@ -2956,16 +3084,22 @@
                                //}
                            }
                            else if (jixiaotichengfangan.Renwustandard == "05")
                            {
                                //本月规定
                                shangmenbanfangDTO.benyueqingkuang = (4 * jixiaotichengfangan.Renwu.Value).ToString("0.##");
                            }
                        }
                    }
                    if (decimal.Parse(shangmenbanfangDTO.benyueshuliang) > 0 || decimal.Parse(shangmenbanfangDTO.benrishuliang) > 0)
                        baifangkehuDTOs.Add(shangmenbanfangDTO);
                    #endregion
                    #region 接待来访客户
                    #region 录入客户咨询
                    TongjiBaoBiaoDTO jiedailaifangDTO = new TongjiBaoBiaoDTO();
                    jiedailaifangDTO.gongzuo = "接待来访客户";
                    var jijianijiedailaifang = fiPiecerateDTOs.Where(x => x.Project == "接待来访客户").FirstOrDefault();
                    jiedailaifangDTO.gongzuo = "录入客户咨询";
                    var jijianijiedailaifang = fiPiecerateDTOs.Where(x => x.Project == "录入客户咨询").FirstOrDefault();
                    if (jijianijiedailaifang != null)
                    {
@@ -3226,10 +3360,10 @@
                        ziliaoweihuDTOs.Add(zhengcaizhishiDTO);
                    #endregion
                    #region 新增公众号关注
                    #region 微信微博公众号新增粉丝
                    TongjiBaoBiaoDTO gongzhonghaoDTO = new TongjiBaoBiaoDTO();
                    gongzhonghaoDTO.gongzuo = "新增公众号关注";
                    var jijianigongzhonghao = fiPiecerateDTOs.Where(x => x.Project == "新增公众号关注").FirstOrDefault();
                    gongzhonghaoDTO.gongzuo = "微信微博公众号新增粉丝";
                    var jijianigongzhonghao = fiPiecerateDTOs.Where(x => x.Project == "微信微博公众号新增粉丝").FirstOrDefault();
                    if (jijianigongzhonghao != null)
                    {