|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using AutoMapper;
|
using AngleSharp.Html.Parser;
|
using DTO;
|
using IServices;
|
using Microsoft.AspNetCore.Http;
|
using Microsoft.AspNetCore.Mvc;
|
using Microsoft.Bot.Builder.Integration.AspNet.Core;
|
using Microsoft.Extensions.Logging;
|
using Newtonsoft.Json;
|
using System.Net.Http;
|
using System.Threading.Tasks;
|
using zhengcaioa.Models;
|
using zhengcaioa.IService;
|
using CommonToolsCore;
|
using Services;
|
using System.IO;
|
using Microsoft.AspNetCore.Hosting;
|
using Grpc.Core;
|
using System;
|
using System.Transactions;
|
using Microsoft.Extensions.Configuration;
|
using Newtonsoft.Json.Linq;
|
using System.Net.Http.Headers;
|
|
namespace zhengcaioa.Controllers.Finance
|
{
|
[CheckLogin]
|
public class TongjiBaoBiaoController : Controller
|
{
|
private readonly ILogger<TongjiBaoBiaoController> _logger;
|
private readonly IAdmAttendanceRuleService _attendanceRuleService;
|
private readonly IUserService _userService;
|
private readonly IAdmSigninService _signinService;
|
private readonly IAdmAttendanceService _admAttendanceService;
|
private readonly IAdmAttendanceDtlService _admAttendanceDtlService;
|
private readonly IHrSalaryService _hrSalaryService;
|
private readonly IHrJibengongziService _JibengongziService;
|
private readonly ISimService _simService;
|
private readonly IDailyManagementService _DailyManageService;
|
private readonly IAdmBreakPrecedentService _admBreakPrecedentService;
|
private readonly IHrJixiaotichengService _hrJixiaotichengService;
|
private readonly IFiPiecerateService _fiPiecerateService;
|
private readonly IAdmPieceCheckService _admPieceCheckService;
|
private readonly ICooperOrderService _cooperOrderService;
|
private readonly ICooperatecustomCustomerService _cooperatecustomCustomerService;
|
private readonly IGroupTopicService _groupTopicService;
|
private readonly ICooperVisitService _cooperVisitService;
|
private readonly IIntentionCustomerService _intentionCustomerService;
|
private readonly IIntentionVisitService _intentionVisitService;
|
private readonly IDtChannelArticleNewsService _dtChannelArticleNewsService;
|
private readonly IProjectService _projectService;
|
private readonly ICusFangwenjiluService _cusFangwenjiluService;
|
private readonly ILiaotianService _liaotianService;
|
private readonly IConfiguration _configuration;
|
private readonly IHttpClientFactory _clientFactory;
|
private readonly IHrPositionService _hrPositionService;
|
private readonly IHrDeptService _hrDeptService;
|
private readonly IAdmSigninService _admSigninService;
|
private readonly IExpertService _expertService;
|
|
public TongjiBaoBiaoController(ILogger<TongjiBaoBiaoController> logger
|
, IAdmAttendanceRuleService attendanceRuleService
|
, IUserService userService
|
, IAdmSigninService signinService
|
, IAdmAttendanceService admAttendanceService
|
, IAdmAttendanceDtlService admAttendanceDtlService
|
, IHrSalaryService hrSalaryService
|
, IHrJibengongziService JibengongziService
|
, ISimService simService
|
, IDailyManagementService DailyManageService
|
, IAdmBreakPrecedentService admBreakPrecedentService
|
, IHrJixiaotichengService hrJixiaotichengService
|
, IFiPiecerateService fiPiecerateService
|
, IAdmPieceCheckService admPieceCheckService
|
, ICooperOrderService cooperOrderService
|
, ICooperatecustomCustomerService cooperatecustomCustomerService
|
, IGroupTopicService groupTopicService
|
, ICooperVisitService cooperVisitService
|
, IIntentionCustomerService intentionCustomerService
|
, IIntentionVisitService intentionVisitService
|
, IDtChannelArticleNewsService dtChannelArticleNewsService
|
, IProjectService projectService
|
, ICusFangwenjiluService cusFangwenjiluService
|
, ILiaotianService liaotianService
|
, IConfiguration configuration
|
, IHttpClientFactory clientFactory
|
, IHrPositionService hrPositionService
|
, IHrDeptService hrDeptService
|
, IAdmSigninService admSigninService
|
, IExpertService expertService
|
)
|
{
|
_logger = logger;
|
_attendanceRuleService = attendanceRuleService;
|
_userService = userService;
|
_signinService = signinService;
|
_admAttendanceService = admAttendanceService;
|
_admAttendanceDtlService = admAttendanceDtlService;
|
_hrSalaryService = hrSalaryService;
|
_JibengongziService = JibengongziService;
|
_simService = simService;
|
_DailyManageService = DailyManageService;
|
_admBreakPrecedentService = admBreakPrecedentService;
|
_hrJixiaotichengService = hrJixiaotichengService;
|
_fiPiecerateService = fiPiecerateService;
|
_admPieceCheckService = admPieceCheckService;
|
_cooperOrderService = cooperOrderService;
|
_cooperatecustomCustomerService = cooperatecustomCustomerService;
|
_groupTopicService = groupTopicService;
|
_cooperVisitService = cooperVisitService;
|
_intentionCustomerService = intentionCustomerService;
|
_intentionVisitService = intentionVisitService;
|
_dtChannelArticleNewsService = dtChannelArticleNewsService;
|
_projectService = projectService;
|
_cusFangwenjiluService = cusFangwenjiluService;
|
_liaotianService = liaotianService;
|
_configuration = configuration;
|
_clientFactory = clientFactory;
|
_hrPositionService = hrPositionService;
|
_hrDeptService = hrDeptService;
|
_admSigninService = admSigninService;
|
_expertService = expertService;
|
}
|
|
public async Task<IActionResult> IndexAsync(string Tongjitime="")
|
{
|
var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
|
ViewData["curentuser"] = curentuser;
|
|
DateTime chauxnshijian = DateTime.Now;
|
if (!string.IsNullOrEmpty(Tongjitime))
|
{
|
DateTime.TryParse(Tongjitime,out chauxnshijian);
|
}
|
|
|
|
|
|
DateTime dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1);
|
DateTime datemaxkaoqin = dateminkaoqin.AddMonths(1);
|
int Yingchuqin = 0;
|
int Offdays = 0;
|
//是否上班日期
|
AdmAttendanceRuleDTO admAttendanceRuleDTO = _attendanceRuleService.Get("");
|
var admAttendanceRulesDtlDTOs = _attendanceRuleService.GetDtlList("");
|
var jiejiari = admAttendanceRulesDtlDTOs.Where(x => x.Name == "jiejiari").ToList();
|
|
var tiaoxiuri = admAttendanceRulesDtlDTOs.Where(x => x.Name == "tiaoxiuri").ToList();
|
List<FiPiecerateDTO> fiPiecerateDTOs = _fiPiecerateService.GetList();
|
List<HrJixiaotichengDTO> hrJixiaotichengDTOs = _hrJixiaotichengService.GetList().Where(x => x.Effecttime < datemaxkaoqin).ToList();
|
var hrJixiaotichengThis = hrJixiaotichengDTOs.Where(x => x.PostId == curentuser.HrPosition).ToList();
|
|
|
//计算每月工作日
|
while (dateminkaoqin < datemaxkaoqin)
|
{
|
_logger.LogInformation("dateminkaoqin " + dateminkaoqin);
|
//bool iswork = false;
|
|
|
|
if ((int)dateminkaoqin.DayOfWeek >= admAttendanceRuleDTO.WeekStart && (int)dateminkaoqin.DayOfWeek <= admAttendanceRuleDTO.WeekEnd)
|
{
|
//是否节假日
|
if (jiejiari.Exists(x => x.ValueStart <= dateminkaoqin && x.ValueEnd >= dateminkaoqin))
|
{
|
Offdays += 1;
|
}
|
else
|
{
|
Yingchuqin += 1;
|
//iswork = true;
|
}
|
}
|
else
|
{
|
//是否调休日 调休日需要上班
|
if (tiaoxiuri.Exists(x => x.ValueStart <= dateminkaoqin.Date && x.ValueEnd >= dateminkaoqin.Date))
|
{
|
Yingchuqin += 1;
|
//iswork = true;
|
}
|
else
|
{
|
Offdays += 1;
|
}
|
}
|
dateminkaoqin = dateminkaoqin.AddDays(1);
|
}
|
dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1);
|
|
List<TongjiBaoBiaoDTO> tuiguangDTOs = new List<TongjiBaoBiaoDTO>();
|
|
#region 采购项目录入
|
TongjiBaoBiaoDTO xiangmuDTO = new TongjiBaoBiaoDTO();
|
xiangmuDTO.gongzuo = "采购项目录入";
|
//本月数量
|
var projectDTOsyue = _projectService.GetListsalary(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();
|
xiangmuDTO.benrishuliang = projectDTOsri.Count.ToString();
|
|
var jijianixiangmu = fiPiecerateDTOs.Where(x => x.Project == "采购项目录入").FirstOrDefault();
|
|
if (jijianixiangmu != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangmu.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
//本月规定
|
xiangmuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
//本日规定
|
xiangmuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = projectDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
xiangmuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
}
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
//本月规定
|
xiangmuDTO.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(projectDTOsyue.Count > 0 || projectDTOsri.Count > 0 )
|
tuiguangDTOs.Add(xiangmuDTO);
|
#endregion
|
|
|
#region 客户资料录入
|
TongjiBaoBiaoDTO kehuluruDTO = new TongjiBaoBiaoDTO();
|
kehuluruDTO.gongzuo = "客户资料录入";
|
//本月数量
|
var intentionCustomerDTOsyue = _intentionCustomerService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin);
|
kehuluruDTO.benyueshuliang = intentionCustomerDTOsyue.Count .ToString();
|
//本日数量
|
var intentionCustomerDTOsri = intentionCustomerDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
kehuluruDTO.benrishuliang = intentionCustomerDTOsri.Count.ToString();
|
|
var jijianikehuluru = fiPiecerateDTOs.Where(x => x.Project == "客户资料录入").FirstOrDefault();
|
|
if (jijianikehuluru != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianikehuluru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
kehuluruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
kehuluruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = intentionCustomerDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
kehuluruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
kehuluruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (intentionCustomerDTOsyue.Count > 0 || intentionCustomerDTOsri.Count > 0)
|
tuiguangDTOs.Add(kehuluruDTO);
|
#endregion
|
|
#region 新加群组
|
TongjiBaoBiaoDTO qunzuDTO = new TongjiBaoBiaoDTO();
|
qunzuDTO.gongzuo = "新加群组";
|
//本月数量
|
var groupTopicDTOsyue = _groupTopicService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin);
|
qunzuDTO.benyueshuliang = groupTopicDTOsyue.Count.ToString();
|
//本日数量
|
var groupTopicDTOsri = groupTopicDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
qunzuDTO.benrishuliang = groupTopicDTOsri.Count.ToString();
|
|
var jijianixianggroupTopic = fiPiecerateDTOs.Where(x => x.Project == "新加群组").FirstOrDefault();
|
|
if (jijianixianggroupTopic != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixianggroupTopic.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
//本月规定
|
qunzuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
//本日规定
|
qunzuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = groupTopicDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
qunzuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
}
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
//本月规定
|
qunzuDTO.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 (groupTopicDTOsyue.Count > 0 || groupTopicDTOsri.Count > 0)
|
tuiguangDTOs.Add(qunzuDTO);
|
#endregion
|
|
#region 电话推广
|
TongjiBaoBiaoDTO dianhuatuiguangDTO = new TongjiBaoBiaoDTO();
|
dianhuatuiguangDTO.gongzuo = "电话推广";
|
//本月数量
|
var intentionVisitDTOsyue = _intentionVisitService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "01").ToList();
|
dianhuatuiguangDTO.benyueshuliang = intentionVisitDTOsyue.Count.ToString();
|
//本日数量
|
var intentionVisitDTOsri = intentionVisitDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList();
|
dianhuatuiguangDTO.benrishuliang = intentionVisitDTOsri.Count.ToString();
|
|
var jijianixiangdianhuatuiguang = fiPiecerateDTOs.Where(x => x.Project == "电话推广").FirstOrDefault();
|
|
if (jijianixiangdianhuatuiguang != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangdianhuatuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
//本月规定
|
dianhuatuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
//本日规定
|
dianhuatuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = intentionVisitDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
dianhuatuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
}
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
//本月规定
|
dianhuatuiguangDTO.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 (intentionVisitDTOsyue.Count > 0 || intentionVisitDTOsri.Count > 0)
|
tuiguangDTOs.Add(dianhuatuiguangDTO);
|
#endregion
|
|
#region 添加微信客户
|
TongjiBaoBiaoDTO weixnDTO = new TongjiBaoBiaoDTO();
|
weixnDTO.gongzuo = "添加微信客户";
|
//本月数量
|
var cooperweixinDTOsyue = _cooperatecustomCustomerService.GetListsalaryweixin(curentuser.Id, dateminkaoqin, datemaxkaoqin);
|
var intentionweixinDTOsyue = _intentionCustomerService.GetListsalaryweixin(curentuser.Id, dateminkaoqin, datemaxkaoqin);
|
weixnDTO.benyueshuliang = (cooperweixinDTOsyue.Count + intentionweixinDTOsyue.Count).ToString();
|
//本日数量
|
var cooperweixinDTOsri = cooperweixinDTOsyue.Where(x => x.Weixintime >= chauxnshijian.Date && x.Weixintime < chauxnshijian.Date.AddDays(1)).ToList();
|
var intentionweixinDTOsri = intentionweixinDTOsyue.Where(x => x.Weixintime >= chauxnshijian.Date && x.Weixintime < chauxnshijian.Date.AddDays(1)).ToList();
|
weixnDTO.benrishuliang = (cooperweixinDTOsri.Count + intentionweixinDTOsri.Count).ToString();
|
|
var jijianiweixn = fiPiecerateDTOs.Where(x => x.Project == "添加微信客户").FirstOrDefault();
|
|
if (jijianiweixn != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiweixn.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
weixnDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
weixnDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = cooperweixinDTOsri.Count + intentionweixinDTOsyue.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
weixnDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
weixnDTO.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 ((cooperweixinDTOsyue.Count + intentionweixinDTOsyue.Count) > 0 || (cooperweixinDTOsri.Count + intentionweixinDTOsri.Count) > 0)
|
tuiguangDTOs.Add(weixnDTO);
|
#endregion
|
|
#region 群发短信
|
TongjiBaoBiaoDTO duanxinDTO = new TongjiBaoBiaoDTO();
|
duanxinDTO.gongzuo = "群发短信";
|
//本月数量
|
var duanxinsyue = _cusFangwenjiluService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "01").ToList();
|
duanxinDTO.benyueshuliang = duanxinsyue.Count.ToString();
|
//本日数量
|
var duanxinsri = duanxinsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
duanxinDTO.benrishuliang = duanxinsri.Count.ToString();
|
|
var jijianiduanxin = fiPiecerateDTOs.Where(x => x.Project == "群发短信").FirstOrDefault();
|
|
if (jijianiduanxin != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiduanxin.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
duanxinDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
duanxinDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = duanxinsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
duanxinDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
duanxinDTO.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 (duanxinsyue.Count > 0 || duanxinsri.Count > 0)
|
tuiguangDTOs.Add(duanxinDTO);
|
#endregion
|
|
|
#region 商业信函推广
|
TongjiBaoBiaoDTO xinhanDTO = new TongjiBaoBiaoDTO();
|
xinhanDTO.gongzuo = "商业信函推广";
|
var jijianixinhan = fiPiecerateDTOs.Where(x => x.Project == "商业信函推广").FirstOrDefault();
|
|
if (jijianixinhan != null)
|
{
|
//本月数量
|
var xinhansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianixinhan.Id).ToList();
|
|
xinhanDTO.benyueshuliang =(xinhansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var xinhansri = xinhansyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
xinhanDTO.benrishuliang = (xinhansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
xinhanDTO.dangrijixiao = (xinhansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinhan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
xinhanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
xinhanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (xinhansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// xinhanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
xinhanDTO.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 (decimal.Parse(xinhanDTO.benyueshuliang) > 0 || decimal.Parse(xinhanDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(xinhanDTO);
|
#endregion
|
|
#region 群发邮件
|
TongjiBaoBiaoDTO youjianDTO = new TongjiBaoBiaoDTO();
|
youjianDTO.gongzuo = "群发邮件";
|
//本月数量
|
var youjiansyue = _cusFangwenjiluService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "02").ToList();
|
youjianDTO.benyueshuliang = youjiansyue.Count.ToString();
|
//本日数量
|
var youjiansri = youjiansyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
youjianDTO.benrishuliang = youjiansri.Count.ToString();
|
|
var jijianiyoujian = fiPiecerateDTOs.Where(x => x.Project == "群发邮件").FirstOrDefault();
|
|
if (jijianiyoujian != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyoujian.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
youjianDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
youjianDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = youjiansri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
youjianDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
youjianDTO.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 (decimal.Parse(youjianDTO.benyueshuliang) > 0 || decimal.Parse(youjianDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(youjianDTO);
|
#endregion
|
|
#region 群组推广
|
TongjiBaoBiaoDTO qunzutuiguangDTO = new TongjiBaoBiaoDTO();
|
qunzutuiguangDTO.gongzuo = "群组推广";
|
var jijianiqunzutuiguang = fiPiecerateDTOs.Where(x => x.Project == "群组推广").FirstOrDefault();
|
|
if (jijianiqunzutuiguang != null)
|
{
|
//本月数量
|
var qunzutuiguangsyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiqunzutuiguang.Id).ToList();
|
|
qunzutuiguangDTO.benyueshuliang = (qunzutuiguangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var qunzutuiguangsri = qunzutuiguangsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
qunzutuiguangDTO.benrishuliang = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
qunzutuiguangDTO.dangrijixiao = (qunzutuiguangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqunzutuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
qunzutuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
qunzutuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// qunzutuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
qunzutuiguangDTO.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 (decimal.Parse(qunzutuiguangDTO.benyueshuliang) > 0 || decimal.Parse(qunzutuiguangDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(qunzutuiguangDTO);
|
#endregion
|
|
#region 朋友圈原创
|
TongjiBaoBiaoDTO pengyouquanDTO = new TongjiBaoBiaoDTO();
|
pengyouquanDTO.gongzuo = "朋友圈原创";
|
var jijianipengyouquan = fiPiecerateDTOs.Where(x => x.Project == "朋友圈原创").FirstOrDefault();
|
|
if (jijianipengyouquan != null)
|
{
|
//本月数量
|
var pengyouquansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianipengyouquan.Id).ToList();
|
|
pengyouquanDTO.benyueshuliang = (pengyouquansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var pengyouquansri = pengyouquansyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
pengyouquanDTO.benrishuliang = (pengyouquansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
pengyouquanDTO.dangrijixiao = (pengyouquansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianipengyouquan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
pengyouquanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
pengyouquanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (pengyouquansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// pengyouquanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
pengyouquanDTO.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 (decimal.Parse(pengyouquanDTO.benyueshuliang) > 0 || decimal.Parse(pengyouquanDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(pengyouquanDTO);
|
#endregion
|
|
#region 论坛发帖
|
TongjiBaoBiaoDTO luntanfatieDTO = new TongjiBaoBiaoDTO();
|
luntanfatieDTO.gongzuo = "论坛发帖";
|
var jijianiluntanfatie = fiPiecerateDTOs.Where(x => x.Project == "论坛发帖").FirstOrDefault();
|
|
if (jijianiluntanfatie != null)
|
{
|
//本月数量
|
var luntanfatiesyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiluntanfatie.Id).ToList();
|
|
luntanfatieDTO.benyueshuliang = (luntanfatiesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var luntanfatiesri = luntanfatiesyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
luntanfatieDTO.benrishuliang = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
luntanfatieDTO.dangrijixiao = (luntanfatiesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiluntanfatie.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
luntanfatieDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
luntanfatieDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// luntanfatieDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
luntanfatieDTO.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 (decimal.Parse(luntanfatieDTO.benyueshuliang) > 0 || decimal.Parse(luntanfatieDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(luntanfatieDTO);
|
#endregion
|
|
#region 跟帖评论
|
TongjiBaoBiaoDTO gentiepinglunDTO = new TongjiBaoBiaoDTO();
|
gentiepinglunDTO.gongzuo = "跟帖评论";
|
var jijianigentiepinglun = fiPiecerateDTOs.Where(x => x.Project == "跟帖评论").FirstOrDefault();
|
|
if (jijianigentiepinglun != null)
|
{
|
//本月数量
|
var gentiepinglunsyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigentiepinglun.Id).ToList();
|
|
gentiepinglunDTO.benyueshuliang = (gentiepinglunsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var gentiepinglunsri = gentiepinglunsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
gentiepinglunDTO.benrishuliang = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
gentiepinglunDTO.dangrijixiao = (gentiepinglunsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigentiepinglun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
gentiepinglunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
gentiepinglunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// gentiepinglunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
gentiepinglunDTO.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 (decimal.Parse(gentiepinglunDTO.benyueshuliang) > 0 || decimal.Parse(gentiepinglunDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(gentiepinglunDTO);
|
#endregion
|
|
#region 转发微信微博
|
TongjiBaoBiaoDTO zhuanfaDTO = new TongjiBaoBiaoDTO();
|
zhuanfaDTO.gongzuo = "转发微信微博";
|
var jijianizhuanfa = fiPiecerateDTOs.Where(x => x.Project == "转发微信微博").FirstOrDefault();
|
|
if (jijianizhuanfa != null)
|
{
|
//本月数量
|
var zhuanfasyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhuanfa.Id).ToList();
|
|
zhuanfaDTO.benyueshuliang = (zhuanfasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var zhuanfasri = zhuanfasyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhuanfaDTO.benrishuliang = (zhuanfasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
zhuanfaDTO.dangrijixiao = (zhuanfasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanfa.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhuanfaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhuanfaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (zhuanfasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// zhuanfaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhuanfaDTO.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 (decimal.Parse(zhuanfaDTO.benyueshuliang) > 0 || decimal.Parse(zhuanfaDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(zhuanfaDTO);
|
#endregion
|
|
#region 新增意向客户（订单）
|
TongjiBaoBiaoDTO yixiangDTO = new TongjiBaoBiaoDTO();
|
yixiangDTO.gongzuo = "新增意向客户（订单）";
|
//本月数量
|
var yixiangsyue = _intentionCustomerService.GetListsalaryyixiang(curentuser.Id, dateminkaoqin, datemaxkaoqin).ToList();
|
yixiangDTO.benyueshuliang = yixiangsyue.Count.ToString();
|
//本日数量
|
var yixiangsri = yixiangsyue.Where(x => x.Yixiangtime >= chauxnshijian.Date && x.Yixiangtime < chauxnshijian.Date.AddDays(1)).ToList();
|
yixiangDTO.benrishuliang = yixiangsri.Count.ToString();
|
|
var jijianiyixiang = fiPiecerateDTOs.Where(x => x.Project == "新增意向客户（订单）").FirstOrDefault();
|
|
if (jijianiyixiang != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyixiang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
yixiangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
yixiangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = yixiangsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
yixiangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
yixiangDTO.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 (decimal.Parse(yixiangDTO.benyueshuliang) > 0 || decimal.Parse(yixiangDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(yixiangDTO);
|
#endregion
|
|
#region 新增注册会员
|
TongjiBaoBiaoDTO zhucehuiyuanDTO = new TongjiBaoBiaoDTO();
|
zhucehuiyuanDTO.gongzuo = "新增注册会员";
|
var jijianizhucehuiyuan = fiPiecerateDTOs.Where(x => x.Project == "新增注册会员").FirstOrDefault();
|
|
if (jijianizhucehuiyuan != null)
|
{
|
//本月数量
|
List <YaoQingYongHuDTO> zhucehuiyuansyue = new List<YaoQingYongHuDTO>();
|
try
|
{
|
//var pltUserDTO = _userService.GetPltUserEntity(curentuser.Id);
|
string huiyuanurl = _configuration.GetSection("huiyuanurl").Value;
|
string GetYGYaoQingYonghu = _configuration.GetSection("GetYGYaoQingYonghu").Value;
|
Uri postUrl2 = new Uri(huiyuanurl + GetYGYaoQingYonghu);
|
|
JObject questions2 = new JObject();
|
questions2.Add("UserID", curentuser.Id);
|
questions2.Add("StartTime", dateminkaoqin.ToString("yyyy-MM-dd HH:mm:ss"));
|
questions2.Add("EndTime", datemaxkaoqin.ToString("yyyy-MM-dd HH:mm:ss"));
|
|
string requestJson2 = questions2.ToString();
|
string result2 = string.Empty;
|
|
using (HttpContent httpContent = new StringContent(requestJson2))
|
{
|
httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
|
|
var httpClient2 = _clientFactory.CreateClient();
|
httpClient2.Timeout = new TimeSpan(0, 0, 10);
|
var Result2 = await httpClient2.PostAsync(postUrl2, httpContent);
|
result2 = Result2.Content.ReadAsStringAsync().Result;
|
}
|
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
zhucehuiyuanDTO.benyueshuliang = jobjectresult["count"].ToString();
|
zhucehuiyuansyue = JsonConvert.DeserializeObject<List<YaoQingYongHuDTO>>(jobjectresult["data"].ToString());
|
|
}
|
else
|
{
|
zhucehuiyuanDTO.benyueshuliang = "0";
|
}
|
}
|
catch (Exception ex)
|
{
|
zhucehuiyuanDTO.benyueshuliang = "0";
|
}
|
//var zhucehuiyuansyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhucehuiyuan.Id).ToList();
|
|
//zhucehuiyuanDTO.benyueshuliang = (zhucehuiyuansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var zhucehuiyuansri = zhucehuiyuansyue.Where(x => x.CreatTime >= chauxnshijian.Date && x.CreatTime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhucehuiyuanDTO.benrishuliang = zhucehuiyuansri.Count.ToString();
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhucehuiyuan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhucehuiyuanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhucehuiyuanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
|
zhucehuiyuanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhucehuiyuanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = zhucehuiyuansri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
zhucehuiyuanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhucehuiyuanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = qianyueDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (decimal.Parse(zhucehuiyuanDTO.benyueshuliang) > 0 || decimal.Parse(zhucehuiyuanDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(zhucehuiyuanDTO);
|
#endregion
|
|
#region 新增签约客户
|
TongjiBaoBiaoDTO qianyueDTO = new TongjiBaoBiaoDTO();
|
qianyueDTO.gongzuo = "新增签约客户";
|
//本月数量
|
var qianyueDTOsyue = _cooperatecustomCustomerService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin);
|
qianyueDTO.benyueshuliang = qianyueDTOsyue.Count.ToString();
|
//本日数量
|
var qianyueDTOsri = qianyueDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
qianyueDTO.benrishuliang = qianyueDTOsri.Count .ToString();
|
|
var jijianiqianyue = fiPiecerateDTOs.Where(x => x.Project == "新增签约客户").FirstOrDefault();
|
|
if (jijianiqianyue != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqianyue.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
qianyueDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
qianyueDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = qianyueDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
qianyueDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
qianyueDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = qianyueDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (decimal.Parse(qianyueDTO.benyueshuliang) > 0 || decimal.Parse(qianyueDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(qianyueDTO);
|
#endregion
|
|
|
#region 专家录入
|
TongjiBaoBiaoDTO zhuanjialuruDTO = new TongjiBaoBiaoDTO();
|
zhuanjialuruDTO.gongzuo = "专家录入";
|
//本月数量
|
var zhuanjialuruDTOsyue = _expertService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin);
|
zhuanjialuruDTO.benyueshuliang = zhuanjialuruDTOsyue.Count.ToString();
|
//本日数量
|
var zhuanjialuruDTOsri = zhuanjialuruDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhuanjialuruDTO.benrishuliang = zhuanjialuruDTOsri.Count.ToString();
|
|
var jijianizhuanjialuru = fiPiecerateDTOs.Where(x => x.Project == "专家录入").FirstOrDefault();
|
|
if (jijianizhuanjialuru != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanjialuru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhuanjialuruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhuanjialuruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = zhuanjialuruDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
zhuanjialuruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhuanjialuruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (zhuanjialuruDTOsyue.Count > 0 || zhuanjialuruDTOsri.Count > 0)
|
tuiguangDTOs.Add(zhuanjialuruDTO);
|
#endregion
|
|
|
List<TongjiBaoBiaoDTO> baifangkehuDTOs = new List<TongjiBaoBiaoDTO>();
|
|
#region 上门拜访客户
|
TongjiBaoBiaoDTO shangmenbanfangDTO = new TongjiBaoBiaoDTO();
|
shangmenbanfangDTO.gongzuo = "上门拜访客户";
|
//本月数量
|
var shangmenbanfangDTOsyue = _intentionVisitService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList();
|
var shangmenbanfangcooperDTOsyue = _cooperVisitService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList();
|
shangmenbanfangDTO.benyueshuliang = (shangmenbanfangcooperDTOsyue.Count + shangmenbanfangDTOsyue.Count).ToString();
|
//本日数量
|
var shangmenbanfangDTOsri = shangmenbanfangDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList();
|
var shangmenbanfangcooperDTOsri = shangmenbanfangcooperDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList();
|
shangmenbanfangDTO.benrishuliang = (shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count).ToString();
|
|
var jijianixiangshangmenbanfang = fiPiecerateDTOs.Where(x => x.Project == "上门拜访客户").FirstOrDefault();
|
|
if (jijianixiangshangmenbanfang != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangshangmenbanfang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
//本月规定
|
shangmenbanfangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
//本日规定
|
shangmenbanfangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
shangmenbanfangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
}
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
//本月规定
|
shangmenbanfangDTO.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 (decimal.Parse(shangmenbanfangDTO.benyueshuliang) > 0 || decimal.Parse(shangmenbanfangDTO.benrishuliang) > 0)
|
baifangkehuDTOs.Add(shangmenbanfangDTO);
|
#endregion
|
|
#region 接待来访客户
|
TongjiBaoBiaoDTO jiedailaifangDTO = new TongjiBaoBiaoDTO();
|
jiedailaifangDTO.gongzuo = "接待来访客户";
|
var jijianijiedailaifang = fiPiecerateDTOs.Where(x => x.Project == "接待来访客户").FirstOrDefault();
|
|
if (jijianijiedailaifang != null)
|
{
|
//本月数量
|
var jiedailaifangsyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianijiedailaifang.Id).ToList();
|
|
jiedailaifangDTO.benyueshuliang = (jiedailaifangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var jiedailaifangsri = jiedailaifangsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
jiedailaifangDTO.benrishuliang = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
jiedailaifangDTO.dangrijixiao = (jiedailaifangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianijiedailaifang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
jiedailaifangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
jiedailaifangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// jiedailaifangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
jiedailaifangDTO.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 (decimal.Parse(jiedailaifangDTO.benyueshuliang) > 0 || decimal.Parse(jiedailaifangDTO.benrishuliang) > 0)
|
baifangkehuDTOs.Add(jiedailaifangDTO);
|
#endregion
|
|
List<TongjiDingDanDTO> dingdanDTOs = new List<TongjiDingDanDTO>();
|
|
#region 新增订单
|
|
|
//本月数量
|
var dingdanDTOsyue = _cooperOrderService.GetListtongji(curentuser.Id, dateminkaoqin, datemaxkaoqin);
|
var benyuezonge = dingdanDTOsyue.Sum(x => x.Money) ?? 0;
|
|
//本日数量
|
var dingdanDTOsri = dingdanDTOsyue.Where(x =>( x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)) || (x.Wangongtime >= chauxnshijian.Date && x.Wangongtime < chauxnshijian.Date.AddDays(1)) ).ToList();
|
foreach (var cooperOrderDTO in dingdanDTOsri)
|
{
|
TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO();
|
dingdanDTO.dingdanbianhao = cooperOrderDTO.OrderNo;
|
dingdanDTO.dingdanmingcheng = cooperOrderDTO.OrderTypeName+"-"+ cooperOrderDTO.OrderType1Name + (string.IsNullOrEmpty(cooperOrderDTO.OrderType2)?"":"-"+ cooperOrderDTO.OrderType2);
|
dingdanDTO.danjia = cooperOrderDTO.Price.Value.ToString("0.##");
|
dingdanDTO.shuliang = cooperOrderDTO.OrderNum.Value.ToString("0.##");
|
dingdanDTO.jine = cooperOrderDTO.Money.Value.ToString("0.##");
|
dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##");
|
|
dingdanDTOs.Add(dingdanDTO);
|
}
|
int dingdanDTOsCount = 1;
|
if (dingdanDTOs.Count == 0 && benyuezonge == 0)
|
{
|
dingdanDTOsCount = 0;
|
}
|
|
if (dingdanDTOs.Count == 0)
|
{
|
TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO();
|
dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##");
|
|
dingdanDTOs.Add(dingdanDTO);
|
}
|
|
#endregion
|
|
List<TongjiBaoBiaoDTO> ziliaoweihuDTOs = new List<TongjiBaoBiaoDTO>();
|
#region 新闻资讯
|
TongjiBaoBiaoDTO xinwenzixunDTO = new TongjiBaoBiaoDTO();
|
xinwenzixunDTO.gongzuo = "新闻资讯";
|
//本月数量
|
DtChannelArticleNewsDTOSearch searchEntity = new DtChannelArticleNewsDTOSearch();
|
searchEntity.EndTime = datemaxkaoqin;
|
searchEntity.AddTime = dateminkaoqin;
|
searchEntity.UserName = curentuser.UserSn;
|
searchEntity.CategoryId = 3;
|
var dtChannelArticleNewsDTOs = _dtChannelArticleNewsService.GetList(searchEntity);
|
xinwenzixunDTO.benyueshuliang = dtChannelArticleNewsDTOs.Count.ToString();
|
//本日数量
|
var xinwenzixunsri = dtChannelArticleNewsDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList();
|
xinwenzixunDTO.benrishuliang = xinwenzixunsri.Count.ToString();
|
|
var jijianixinwenzixun = fiPiecerateDTOs.Where(x => x.Project == "新闻资讯").FirstOrDefault();
|
|
if (jijianixinwenzixun != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinwenzixun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
xinwenzixunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
xinwenzixunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = xinwenzixunsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
xinwenzixunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
xinwenzixunDTO.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 (decimal.Parse(xinwenzixunDTO.benyueshuliang) > 0 || decimal.Parse(xinwenzixunDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(xinwenzixunDTO);
|
#endregion
|
|
#region 典型案例
|
TongjiBaoBiaoDTO dianxinanliDTO = new TongjiBaoBiaoDTO();
|
dianxinanliDTO.gongzuo = "典型案例";
|
//本月数量
|
searchEntity = new DtChannelArticleNewsDTOSearch();
|
searchEntity.EndTime = datemaxkaoqin;
|
searchEntity.AddTime = dateminkaoqin;
|
searchEntity.UserName = curentuser.UserSn;
|
searchEntity.CategoryId = 85;
|
var dianxinanDTOs = _dtChannelArticleNewsService.GetList(searchEntity);
|
dianxinanliDTO.benyueshuliang = dianxinanDTOs.Count.ToString();
|
//本日数量
|
var dianxinanlisri = dianxinanDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList();
|
dianxinanliDTO.benrishuliang = dianxinanlisri.Count.ToString();
|
|
var jijianidianxinanli = fiPiecerateDTOs.Where(x => x.Project == "典型案例").FirstOrDefault();
|
|
if (jijianidianxinanli != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidianxinanli.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
dianxinanliDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
dianxinanliDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = dianxinanlisri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
dianxinanliDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
dianxinanliDTO.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 (decimal.Parse(dianxinanliDTO.benyueshuliang) > 0 || decimal.Parse(dianxinanliDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(dianxinanliDTO);
|
#endregion
|
#region 政采知识
|
TongjiBaoBiaoDTO zhengcaizhishiDTO = new TongjiBaoBiaoDTO();
|
zhengcaizhishiDTO.gongzuo = "政采知识";
|
//本月数量
|
searchEntity = new DtChannelArticleNewsDTOSearch();
|
searchEntity.EndTime = datemaxkaoqin;
|
searchEntity.AddTime = dateminkaoqin;
|
searchEntity.UserName = curentuser.UserSn;
|
searchEntity.CategoryId = 73;
|
var zhengcaizhishiDTOs = _dtChannelArticleNewsService.GetList(searchEntity);
|
zhengcaizhishiDTO.benyueshuliang = zhengcaizhishiDTOs.Count.ToString();
|
//本日数量
|
var zhengcaizhishisri = zhengcaizhishiDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhengcaizhishiDTO.benrishuliang = zhengcaizhishisri.Count.ToString();
|
|
var jijianizhengcaizhishi = fiPiecerateDTOs.Where(x => x.Project == "政采知识").FirstOrDefault();
|
|
if (jijianizhengcaizhishi != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhengcaizhishi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhengcaizhishiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhengcaizhishiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = zhengcaizhishisri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
zhengcaizhishiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhengcaizhishiDTO.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 (decimal.Parse(zhengcaizhishiDTO.benyueshuliang) > 0 || decimal.Parse(zhengcaizhishiDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(zhengcaizhishiDTO);
|
#endregion
|
|
#region 新增公众号关注
|
TongjiBaoBiaoDTO gongzhonghaoDTO = new TongjiBaoBiaoDTO();
|
gongzhonghaoDTO.gongzuo = "新增公众号关注";
|
var jijianigongzhonghao = fiPiecerateDTOs.Where(x => x.Project == "新增公众号关注").FirstOrDefault();
|
|
if (jijianigongzhonghao != null)
|
{
|
//本月数量
|
var gongzhonghaosyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigongzhonghao.Id).ToList();
|
|
gongzhonghaoDTO.benyueshuliang = (gongzhonghaosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var gongzhonghaosri = gongzhonghaosyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
gongzhonghaoDTO.benrishuliang = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
gongzhonghaoDTO.dangrijixiao = (gongzhonghaosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigongzhonghao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
gongzhonghaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
gongzhonghaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// gongzhonghaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
gongzhonghaoDTO.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 (decimal.Parse(gongzhonghaoDTO.benyueshuliang) > 0 || decimal.Parse(gongzhonghaoDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(gongzhonghaoDTO);
|
#endregion
|
|
#region 网页制作
|
TongjiBaoBiaoDTO wangyeDTO = new TongjiBaoBiaoDTO();
|
wangyeDTO.gongzuo = "网页制作";
|
var jijianiwangye = fiPiecerateDTOs.Where(x => x.Project == "网页制作").FirstOrDefault();
|
|
if (jijianiwangye != null)
|
{
|
//本月数量
|
var wangyesyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiwangye.Id).ToList();
|
|
wangyeDTO.benyueshuliang = (wangyesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var wangyesri = wangyesyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
wangyeDTO.benrishuliang = (wangyesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
wangyeDTO.dangrijixiao = (wangyesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiwangye.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
wangyeDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
wangyeDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (wangyesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// wangyeDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
wangyeDTO.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 (decimal.Parse(wangyeDTO.benyueshuliang) > 0 || decimal.Parse(wangyeDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(wangyeDTO);
|
#endregion
|
|
#region 新增小采问题
|
TongjiBaoBiaoDTO xinzengwendaDTO = new TongjiBaoBiaoDTO();
|
xinzengwendaDTO.gongzuo = "新增小采问题";
|
//本月数量
|
var xinzengwendaDTOsyue = _liaotianService.GetListsalary(curentuser.Id, dateminkaoqin, datemaxkaoqin);
|
xinzengwendaDTO.benyueshuliang = xinzengwendaDTOsyue.Count.ToString();
|
//本日数量
|
var xinzengwendaDTOsri = xinzengwendaDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
xinzengwendaDTO.benrishuliang = xinzengwendaDTOsri.Count.ToString();
|
|
var jijianixinzengwenda = fiPiecerateDTOs.Where(x => x.Project == "新增小采问题").FirstOrDefault();
|
|
if (jijianixinzengwenda != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinzengwenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
xinzengwendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
xinzengwendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = xinzengwendaDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
xinzengwendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
xinzengwendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = xinzengwendaDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (decimal.Parse(xinzengwendaDTO.benyueshuliang) > 0 || decimal.Parse(xinzengwendaDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(xinzengwendaDTO);
|
#endregion
|
|
#region 审核小采答问
|
TongjiBaoBiaoDTO shenhewendaDTO = new TongjiBaoBiaoDTO();
|
shenhewendaDTO.gongzuo = "审核小采答问";
|
//本月数量
|
var shenhewendaDTOsyue = _liaotianService.GetListsalaryshenhe(curentuser.Id, dateminkaoqin, datemaxkaoqin);
|
shenhewendaDTO.benyueshuliang = shenhewendaDTOsyue.Count.ToString();
|
//本日数量
|
var shenhewendaDTOsri = shenhewendaDTOsyue.Where(x => x.Shenhetime >= chauxnshijian.Date && x.Shenhetime < chauxnshijian.Date.AddDays(1)).ToList();
|
shenhewendaDTO.benrishuliang = shenhewendaDTOsri.Count.ToString();
|
|
var jijianishenhewenda = fiPiecerateDTOs.Where(x => x.Project == "审核小采答问").FirstOrDefault();
|
|
if (jijianishenhewenda != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianishenhewenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
shenhewendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
shenhewendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = shenhewendaDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
shenhewendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
shenhewendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = shenhewendaDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (decimal.Parse(shenhewendaDTO.benyueshuliang) > 0 || decimal.Parse(shenhewendaDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(shenhewendaDTO);
|
#endregion
|
|
List<TongjiBaoBiaoDTO> xiangmushishiDTOs = new List<TongjiBaoBiaoDTO>();
|
#region 标书制作
|
TongjiBaoBiaoDTO biaoshuzhizuoDTO = new TongjiBaoBiaoDTO();
|
biaoshuzhizuoDTO.gongzuo = "标书制作";
|
var jijianibiaoshuzhizuo = fiPiecerateDTOs.Where(x => x.Project == "标书制作").FirstOrDefault();
|
|
if (jijianibiaoshuzhizuo != null)
|
{
|
//本月数量
|
var biaoshuzhizuosyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshuzhizuo.Id).ToList();
|
|
biaoshuzhizuoDTO.benyueshuliang = (biaoshuzhizuosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var biaoshuzhizuosri = biaoshuzhizuosyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
biaoshuzhizuoDTO.benrishuliang = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
biaoshuzhizuoDTO.dangrijixiao = (biaoshuzhizuosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshuzhizuo.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
biaoshuzhizuoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
biaoshuzhizuoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// biaoshuzhizuoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
biaoshuzhizuoDTO.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 (decimal.Parse(biaoshuzhizuoDTO.benyueshuliang) > 0 || decimal.Parse(biaoshuzhizuoDTO.benrishuliang) > 0)
|
xiangmushishiDTOs.Add(biaoshuzhizuoDTO);
|
#endregion
|
|
#region 标书检查
|
TongjiBaoBiaoDTO biaoshujianchaDTO = new TongjiBaoBiaoDTO();
|
biaoshujianchaDTO.gongzuo = "标书检查";
|
var jijianibiaoshujiancha = fiPiecerateDTOs.Where(x => x.Project == "标书检查").FirstOrDefault();
|
|
if (jijianibiaoshujiancha != null)
|
{
|
//本月数量
|
var biaoshujianchasyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshujiancha.Id).ToList();
|
|
biaoshujianchaDTO.benyueshuliang = (biaoshujianchasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var biaoshujianchasri = biaoshujianchasyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
biaoshujianchaDTO.benrishuliang = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
biaoshujianchaDTO.dangrijixiao = (biaoshujianchasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshujiancha.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
biaoshujianchaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
biaoshujianchaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// biaoshujianchaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
biaoshujianchaDTO.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 (decimal.Parse(biaoshujianchaDTO.benyueshuliang) > 0 || decimal.Parse(biaoshujianchaDTO.benrishuliang) > 0)
|
xiangmushishiDTOs.Add(biaoshujianchaDTO);
|
#endregion
|
|
#region 起草质疑投诉
|
TongjiBaoBiaoDTO zhiyiDTO = new TongjiBaoBiaoDTO();
|
zhiyiDTO.gongzuo = "起草质疑投诉书";
|
var jijianizhiyi = fiPiecerateDTOs.Where(x => x.Project == "起草质疑投诉书").FirstOrDefault();
|
|
if (jijianizhiyi != null)
|
{
|
//本月数量
|
var zhiyisyue = _admPieceCheckService.GetList(curentuser.Id, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhiyi.Id).ToList();
|
|
zhiyiDTO.benyueshuliang = (zhiyisyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var zhiyisri = zhiyisyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhiyiDTO.benrishuliang = (zhiyisri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
zhiyiDTO.dangrijixiao = (zhiyisri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhiyi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhiyiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhiyiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (zhiyisri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// zhiyiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhiyiDTO.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 (decimal.Parse(zhiyiDTO.benyueshuliang) > 0 || decimal.Parse(zhiyiDTO.benrishuliang) > 0)
|
xiangmushishiDTOs.Add(zhiyiDTO);
|
#endregion
|
|
ViewBag.tuiguangDTOs = tuiguangDTOs;
|
ViewBag.baifangkehuDTOs = baifangkehuDTOs;
|
ViewBag.dingdanDTOs = dingdanDTOs;
|
ViewBag.ziliaoweihuDTOs = ziliaoweihuDTOs;
|
ViewBag.xiangmushishiDTOs = xiangmushishiDTOs;
|
ViewBag.dingdanDTOsCount = dingdanDTOsCount;
|
ViewBag.UserName = curentuser.UserName;
|
|
|
|
ViewBag.Tongjitime = chauxnshijian.ToString("yyyy-MM-dd");
|
|
return View();
|
}
|
|
|
|
public async Task<IActionResult> IndexSuoyouAsync(string Tongjitime = "",string userid = "")
|
{
|
var curentuser = JsonConvert.DeserializeObject<PltUser>(HttpContext.Session.GetString("User"));
|
ViewData["curentuser"] = curentuser;
|
|
DateTime chauxnshijian = DateTime.Now.Date;
|
if (!string.IsNullOrEmpty(Tongjitime))
|
{
|
DateTime.TryParse(Tongjitime, out chauxnshijian);
|
}
|
var userDTOs = _userService.GetList();
|
|
string[] Userids = null;
|
if (!string.IsNullOrEmpty(userid) && userid!= "null")
|
{
|
Userids = userDTOs.Where(x=> userid.Split(',').Contains(x.Id)).OrderBy(x => x.DeptId).ThenBy(x => x.HrPosition).Select(x => x.Id).ToArray();
|
|
}
|
else
|
{
|
Userids = userDTOs.OrderBy(x => x.DeptId).ThenBy(x=>x.HrPosition).Select(x => x.Id).ToArray();
|
}
|
|
List<TongjibaobiaobaobiaoDTO> tongjibaobiaobaobiaoDTOs = new List<TongjibaobiaobaobiaoDTO>();
|
|
if (Userids!=null&& Userids.Length > 0)
|
{
|
DateTime dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1);
|
DateTime datemaxkaoqin = dateminkaoqin.AddMonths(1);
|
int Yingchuqin = 0;
|
int Offdays = 0;
|
//是否上班日期
|
AdmAttendanceRuleDTO admAttendanceRuleDTO = _attendanceRuleService.Get("");
|
var admAttendanceRulesDtlDTOs = _attendanceRuleService.GetDtlList("");
|
var jiejiari = admAttendanceRulesDtlDTOs.Where(x => x.Name == "jiejiari").ToList();
|
|
var tiaoxiuri = admAttendanceRulesDtlDTOs.Where(x => x.Name == "tiaoxiuri").ToList();
|
List<FiPiecerateDTO> fiPiecerateDTOs = _fiPiecerateService.GetList();
|
List<HrJixiaotichengDTO> hrJixiaotichengDTOs = _hrJixiaotichengService.GetList().Where(x => x.Effecttime < datemaxkaoqin).ToList();
|
|
|
|
//计算每月工作日
|
while (dateminkaoqin < datemaxkaoqin)
|
{
|
_logger.LogInformation("dateminkaoqin " + dateminkaoqin);
|
//bool iswork = false;
|
|
|
|
if ((int)dateminkaoqin.DayOfWeek >= admAttendanceRuleDTO.WeekStart && (int)dateminkaoqin.DayOfWeek <= admAttendanceRuleDTO.WeekEnd)
|
{
|
//是否节假日
|
if (jiejiari.Exists(x => x.ValueStart <= dateminkaoqin && x.ValueEnd >= dateminkaoqin))
|
{
|
Offdays += 1;
|
}
|
else
|
{
|
Yingchuqin += 1;
|
//iswork = true;
|
}
|
}
|
else
|
{
|
//是否调休日 调休日需要上班
|
if (tiaoxiuri.Exists(x => x.ValueStart <= dateminkaoqin.Date && x.ValueEnd >= dateminkaoqin.Date))
|
{
|
Yingchuqin += 1;
|
//iswork = true;
|
}
|
else
|
{
|
Offdays += 1;
|
}
|
}
|
dateminkaoqin = dateminkaoqin.AddDays(1);
|
}
|
dateminkaoqin = new DateTime(chauxnshijian.Year, chauxnshijian.Month, 1);
|
|
foreach (var Userid in Userids)
|
{
|
var userDTO = userDTOs.Where(x=>x.Id == Userid).FirstOrDefault();
|
string position = userDTO.HrPosition;
|
|
var hrPositionDTO = _hrPositionService.Get(userDTO.HrPosition);
|
|
var deptDTO = _hrDeptService.Get(userDTO.DeptId);
|
var admSignInDTO = _admSigninService.GetByUserAndDate(Userid, chauxnshijian);
|
|
var hrJixiaotichengThis = hrJixiaotichengDTOs.Where(x => x.PostId == position).ToList();
|
|
|
List<TongjiBaoBiaoDTO> tuiguangDTOs = new List<TongjiBaoBiaoDTO>();
|
|
#region 采购项目录入
|
TongjiBaoBiaoDTO xiangmuDTO = new TongjiBaoBiaoDTO();
|
xiangmuDTO.gongzuo = "采购项目录入";
|
//本月数量
|
var projectDTOsyue = _projectService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin);
|
xiangmuDTO.benyueshuliang = projectDTOsyue.Count.ToString();
|
//本日数量
|
var projectDTOsri = projectDTOsyue.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();
|
|
if (jijianixiangmu != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangmu.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
//本月规定
|
xiangmuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
//本日规定
|
xiangmuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = projectDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
xiangmuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
}
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
//本月规定
|
xiangmuDTO.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 (decimal.Parse(xiangmuDTO.benyueshuliang) > 0 || decimal.Parse(xiangmuDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(xiangmuDTO);
|
#endregion
|
|
|
#region 客户资料录入
|
TongjiBaoBiaoDTO kehuluruDTO = new TongjiBaoBiaoDTO();
|
kehuluruDTO.gongzuo = "客户资料录入";
|
//本月数量
|
var intentionCustomerDTOsyue = _intentionCustomerService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin);
|
kehuluruDTO.benyueshuliang = intentionCustomerDTOsyue.Count.ToString();
|
//本日数量
|
var intentionCustomerDTOsri = intentionCustomerDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
kehuluruDTO.benrishuliang = intentionCustomerDTOsri.Count.ToString();
|
|
var jijianikehuluru = fiPiecerateDTOs.Where(x => x.Project == "客户资料录入").FirstOrDefault();
|
|
if (jijianikehuluru != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianikehuluru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
kehuluruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
kehuluruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = intentionCustomerDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
kehuluruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
kehuluruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (decimal.Parse(kehuluruDTO.benyueshuliang) > 0 || decimal.Parse(kehuluruDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(kehuluruDTO);
|
#endregion
|
|
#region 新加群组
|
TongjiBaoBiaoDTO qunzuDTO = new TongjiBaoBiaoDTO();
|
qunzuDTO.gongzuo = "新加群组";
|
//本月数量
|
var groupTopicDTOsyue = _groupTopicService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin);
|
qunzuDTO.benyueshuliang = groupTopicDTOsyue.Count.ToString();
|
//本日数量
|
var groupTopicDTOsri = groupTopicDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
qunzuDTO.benrishuliang = groupTopicDTOsri.Count.ToString();
|
|
var jijianixianggroupTopic = fiPiecerateDTOs.Where(x => x.Project == "新加群组").FirstOrDefault();
|
|
if (jijianixianggroupTopic != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixianggroupTopic.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
//本月规定
|
qunzuDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
//本日规定
|
qunzuDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = groupTopicDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
qunzuDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
}
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
//本月规定
|
qunzuDTO.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 (decimal.Parse(qunzuDTO.benyueshuliang) > 0 || decimal.Parse(qunzuDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(qunzuDTO);
|
#endregion
|
|
#region 电话推广
|
TongjiBaoBiaoDTO dianhuatuiguangDTO = new TongjiBaoBiaoDTO();
|
dianhuatuiguangDTO.gongzuo = "电话推广";
|
//本月数量
|
var intentionVisitDTOsyue = _intentionVisitService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "01").ToList();
|
dianhuatuiguangDTO.benyueshuliang = intentionVisitDTOsyue.Count.ToString();
|
//本日数量
|
var intentionVisitDTOsri = intentionVisitDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList();
|
dianhuatuiguangDTO.benrishuliang = intentionVisitDTOsri.Count.ToString();
|
|
var jijianixiangdianhuatuiguang = fiPiecerateDTOs.Where(x => x.Project == "电话推广").FirstOrDefault();
|
|
if (jijianixiangdianhuatuiguang != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangdianhuatuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
//本月规定
|
dianhuatuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
//本日规定
|
dianhuatuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = intentionVisitDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
dianhuatuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
}
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
//本月规定
|
dianhuatuiguangDTO.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 (decimal.Parse(dianhuatuiguangDTO.benyueshuliang) > 0 || decimal.Parse(dianhuatuiguangDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(dianhuatuiguangDTO);
|
#endregion
|
|
#region 添加微信客户
|
TongjiBaoBiaoDTO weixnDTO = new TongjiBaoBiaoDTO();
|
weixnDTO.gongzuo = "添加微信客户";
|
//本月数量
|
var cooperweixinDTOsyue = _cooperatecustomCustomerService.GetListsalaryweixin(Userid, dateminkaoqin, datemaxkaoqin);
|
var intentionweixinDTOsyue = _intentionCustomerService.GetListsalaryweixin(Userid, dateminkaoqin, datemaxkaoqin);
|
weixnDTO.benyueshuliang = (cooperweixinDTOsyue.Count + intentionweixinDTOsyue.Count).ToString();
|
//本日数量
|
var cooperweixinDTOsri = cooperweixinDTOsyue.Where(x => x.Weixintime >= chauxnshijian.Date && x.Weixintime < chauxnshijian.Date.AddDays(1)).ToList();
|
var intentionweixinDTOsri = intentionweixinDTOsyue.Where(x => x.Weixintime >= chauxnshijian.Date && x.Weixintime < chauxnshijian.Date.AddDays(1)).ToList();
|
weixnDTO.benrishuliang = (cooperweixinDTOsri.Count + intentionweixinDTOsri.Count).ToString();
|
|
var jijianiweixn = fiPiecerateDTOs.Where(x => x.Project == "添加微信客户").FirstOrDefault();
|
|
if (jijianiweixn != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiweixn.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
weixnDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
weixnDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = cooperweixinDTOsri.Count + intentionweixinDTOsyue.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
weixnDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
weixnDTO.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 (decimal.Parse(weixnDTO.benyueshuliang) > 0 || decimal.Parse(weixnDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(weixnDTO);
|
#endregion
|
|
#region 群发短信
|
TongjiBaoBiaoDTO duanxinDTO = new TongjiBaoBiaoDTO();
|
duanxinDTO.gongzuo = "群发短信";
|
//本月数量
|
var duanxinsyue = _cusFangwenjiluService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "01").ToList();
|
duanxinDTO.benyueshuliang = duanxinsyue.Count.ToString();
|
//本日数量
|
var duanxinsri = duanxinsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
duanxinDTO.benrishuliang = duanxinsri.Count.ToString();
|
|
var jijianiduanxin = fiPiecerateDTOs.Where(x => x.Project == "群发短信").FirstOrDefault();
|
|
if (jijianiduanxin != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiduanxin.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
duanxinDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
duanxinDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = duanxinsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
duanxinDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
duanxinDTO.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 (decimal.Parse(duanxinDTO.benyueshuliang) > 0 || decimal.Parse(duanxinDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(duanxinDTO);
|
#endregion
|
|
|
#region 商业信函推广
|
TongjiBaoBiaoDTO xinhanDTO = new TongjiBaoBiaoDTO();
|
xinhanDTO.gongzuo = "商业信函推广";
|
var jijianixinhan = fiPiecerateDTOs.Where(x => x.Project == "商业信函推广").FirstOrDefault();
|
|
if (jijianixinhan != null)
|
{
|
//本月数量
|
var xinhansyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianixinhan.Id).ToList();
|
|
xinhanDTO.benyueshuliang = (xinhansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var xinhansri = xinhansyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
xinhanDTO.benrishuliang = (xinhansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
xinhanDTO.dangrijixiao = (xinhansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinhan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
xinhanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
xinhanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (xinhansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// xinhanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
xinhanDTO.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 (decimal.Parse(xinhanDTO.benyueshuliang) > 0 || decimal.Parse(xinhanDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(xinhanDTO);
|
#endregion
|
|
#region 群发邮件
|
TongjiBaoBiaoDTO youjianDTO = new TongjiBaoBiaoDTO();
|
youjianDTO.gongzuo = "群发邮件";
|
//本月数量
|
var youjiansyue = _cusFangwenjiluService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.Fasongfangshi == "02").ToList();
|
youjianDTO.benyueshuliang = youjiansyue.Count.ToString();
|
//本日数量
|
var youjiansri = youjiansyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
youjianDTO.benrishuliang = youjiansri.Count.ToString();
|
|
var jijianiyoujian = fiPiecerateDTOs.Where(x => x.Project == "群发邮件").FirstOrDefault();
|
|
if (jijianiyoujian != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyoujian.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
youjianDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
youjianDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = youjiansri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
youjianDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
youjianDTO.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 (decimal.Parse(youjianDTO.benyueshuliang) > 0 || decimal.Parse(youjianDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(youjianDTO);
|
#endregion
|
|
#region 群组推广
|
TongjiBaoBiaoDTO qunzutuiguangDTO = new TongjiBaoBiaoDTO();
|
qunzutuiguangDTO.gongzuo = "群组推广";
|
var jijianiqunzutuiguang = fiPiecerateDTOs.Where(x => x.Project == "群组推广").FirstOrDefault();
|
|
if (jijianiqunzutuiguang != null)
|
{
|
//本月数量
|
var qunzutuiguangsyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiqunzutuiguang.Id).ToList();
|
|
qunzutuiguangDTO.benyueshuliang = (qunzutuiguangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var qunzutuiguangsri = qunzutuiguangsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
qunzutuiguangDTO.benrishuliang = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
qunzutuiguangDTO.dangrijixiao = (qunzutuiguangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqunzutuiguang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
qunzutuiguangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
qunzutuiguangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (qunzutuiguangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// qunzutuiguangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
qunzutuiguangDTO.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 (decimal.Parse(qunzutuiguangDTO.benyueshuliang) > 0 || decimal.Parse(qunzutuiguangDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(qunzutuiguangDTO);
|
#endregion
|
|
#region 朋友圈原创
|
TongjiBaoBiaoDTO pengyouquanDTO = new TongjiBaoBiaoDTO();
|
pengyouquanDTO.gongzuo = "朋友圈原创";
|
var jijianipengyouquan = fiPiecerateDTOs.Where(x => x.Project == "朋友圈原创").FirstOrDefault();
|
|
if (jijianipengyouquan != null)
|
{
|
//本月数量
|
var pengyouquansyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianipengyouquan.Id).ToList();
|
|
pengyouquanDTO.benyueshuliang = (pengyouquansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var pengyouquansri = pengyouquansyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
pengyouquanDTO.benrishuliang = (pengyouquansri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
pengyouquanDTO.dangrijixiao = (pengyouquansri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianipengyouquan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
pengyouquanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
pengyouquanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (pengyouquansri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// pengyouquanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
pengyouquanDTO.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 (decimal.Parse(pengyouquanDTO.benyueshuliang) > 0 || decimal.Parse(pengyouquanDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(pengyouquanDTO);
|
#endregion
|
|
#region 论坛发帖
|
TongjiBaoBiaoDTO luntanfatieDTO = new TongjiBaoBiaoDTO();
|
luntanfatieDTO.gongzuo = "论坛发帖";
|
var jijianiluntanfatie = fiPiecerateDTOs.Where(x => x.Project == "论坛发帖").FirstOrDefault();
|
|
if (jijianiluntanfatie != null)
|
{
|
//本月数量
|
var luntanfatiesyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiluntanfatie.Id).ToList();
|
|
luntanfatieDTO.benyueshuliang = (luntanfatiesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var luntanfatiesri = luntanfatiesyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
luntanfatieDTO.benrishuliang = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
luntanfatieDTO.dangrijixiao = (luntanfatiesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiluntanfatie.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
luntanfatieDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
luntanfatieDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (luntanfatiesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// luntanfatieDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
luntanfatieDTO.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 (decimal.Parse(luntanfatieDTO.benyueshuliang) > 0 || decimal.Parse(luntanfatieDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(luntanfatieDTO);
|
#endregion
|
|
#region 跟帖评论
|
TongjiBaoBiaoDTO gentiepinglunDTO = new TongjiBaoBiaoDTO();
|
gentiepinglunDTO.gongzuo = "跟帖评论";
|
var jijianigentiepinglun = fiPiecerateDTOs.Where(x => x.Project == "跟帖评论").FirstOrDefault();
|
|
if (jijianigentiepinglun != null)
|
{
|
//本月数量
|
var gentiepinglunsyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigentiepinglun.Id).ToList();
|
|
gentiepinglunDTO.benyueshuliang = (gentiepinglunsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var gentiepinglunsri = gentiepinglunsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
gentiepinglunDTO.benrishuliang = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
gentiepinglunDTO.dangrijixiao = (gentiepinglunsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigentiepinglun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
gentiepinglunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
gentiepinglunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (gentiepinglunsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// gentiepinglunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
gentiepinglunDTO.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 (decimal.Parse(gentiepinglunDTO.benyueshuliang) > 0 || decimal.Parse(gentiepinglunDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(gentiepinglunDTO);
|
#endregion
|
|
#region 转发微信微博
|
TongjiBaoBiaoDTO zhuanfaDTO = new TongjiBaoBiaoDTO();
|
zhuanfaDTO.gongzuo = "转发微信微博";
|
var jijianizhuanfa = fiPiecerateDTOs.Where(x => x.Project == "转发微信微博").FirstOrDefault();
|
|
if (jijianizhuanfa != null)
|
{
|
//本月数量
|
var zhuanfasyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhuanfa.Id).ToList();
|
|
zhuanfaDTO.benyueshuliang = (zhuanfasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var zhuanfasri = zhuanfasyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhuanfaDTO.benrishuliang = (zhuanfasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
zhuanfaDTO.dangrijixiao = (zhuanfasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanfa.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhuanfaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhuanfaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (zhuanfasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// zhuanfaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhuanfaDTO.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 (decimal.Parse(zhuanfaDTO.benyueshuliang) > 0 || decimal.Parse(zhuanfaDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(zhuanfaDTO);
|
#endregion
|
|
#region 新增意向客户（订单）
|
TongjiBaoBiaoDTO yixiangDTO = new TongjiBaoBiaoDTO();
|
yixiangDTO.gongzuo = "新增意向客户（订单）";
|
//本月数量
|
var yixiangsyue = _intentionCustomerService.GetListsalaryyixiang(Userid, dateminkaoqin, datemaxkaoqin).ToList();
|
yixiangDTO.benyueshuliang = yixiangsyue.Count.ToString();
|
//本日数量
|
var yixiangsri = yixiangsyue.Where(x => x.Yixiangtime >= chauxnshijian.Date && x.Yixiangtime < chauxnshijian.Date.AddDays(1)).ToList();
|
yixiangDTO.benrishuliang = yixiangsri.Count.ToString();
|
|
var jijianiyixiang = fiPiecerateDTOs.Where(x => x.Project == "新增意向客户（订单）").FirstOrDefault();
|
|
if (jijianiyixiang != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiyixiang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
yixiangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
yixiangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = yixiangsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
yixiangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
yixiangDTO.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 (decimal.Parse(yixiangDTO.benyueshuliang) > 0 || decimal.Parse(yixiangDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(yixiangDTO);
|
#endregion
|
|
#region 新增注册会员
|
TongjiBaoBiaoDTO zhucehuiyuanDTO = new TongjiBaoBiaoDTO();
|
zhucehuiyuanDTO.gongzuo = "新增注册会员";
|
var jijianizhucehuiyuan = fiPiecerateDTOs.Where(x => x.Project == "新增注册会员").FirstOrDefault();
|
|
if (jijianizhucehuiyuan != null)
|
{
|
//本月数量
|
List<YaoQingYongHuDTO> zhucehuiyuansyue = new List<YaoQingYongHuDTO>();
|
try
|
{
|
//var pltUserDTO = _userService.GetPltUserEntity(Userid);
|
string huiyuanurl = _configuration.GetSection("huiyuanurl").Value;
|
string GetYGYaoQingYonghu = _configuration.GetSection("GetYGYaoQingYonghu").Value;
|
Uri postUrl2 = new Uri(huiyuanurl + GetYGYaoQingYonghu);
|
|
JObject questions2 = new JObject();
|
questions2.Add("UserID", Userid);
|
questions2.Add("StartTime", dateminkaoqin.ToString("yyyy-MM-dd HH:mm:ss"));
|
questions2.Add("EndTime", datemaxkaoqin.ToString("yyyy-MM-dd HH:mm:ss"));
|
|
string requestJson2 = questions2.ToString();
|
string result2 = string.Empty;
|
|
using (HttpContent httpContent = new StringContent(requestJson2))
|
{
|
httpContent.Headers.ContentType = new MediaTypeHeaderValue("application/json");
|
|
var httpClient2 = _clientFactory.CreateClient();
|
httpClient2.Timeout = new TimeSpan(0, 0, 10);
|
var Result2 = await httpClient2.PostAsync(postUrl2, httpContent);
|
result2 = Result2.Content.ReadAsStringAsync().Result;
|
}
|
|
_logger.LogInformation("result2:" + result2);
|
JObject jobjectresult = (JObject)JsonConvert.DeserializeObject(result2);
|
|
if (jobjectresult["code"] != null && jobjectresult["code"].ToString() == "1")
|
{
|
zhucehuiyuanDTO.benyueshuliang = jobjectresult["count"].ToString();
|
zhucehuiyuansyue = JsonConvert.DeserializeObject<List<YaoQingYongHuDTO>>(jobjectresult["data"].ToString());
|
|
}
|
else
|
{
|
zhucehuiyuanDTO.benyueshuliang = "0";
|
}
|
}
|
catch (Exception ex)
|
{
|
zhucehuiyuanDTO.benyueshuliang = "0";
|
}
|
|
|
//var zhucehuiyuansyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhucehuiyuan.Id).ToList();
|
|
//zhucehuiyuanDTO.benyueshuliang = (zhucehuiyuansyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var zhucehuiyuansri = zhucehuiyuansyue.Where(x => x.CreatTime >= chauxnshijian.Date && x.CreatTime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhucehuiyuanDTO.benrishuliang = zhucehuiyuansri.Count.ToString();
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhucehuiyuan.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhucehuiyuanDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhucehuiyuanDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = zhucehuiyuansri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
zhucehuiyuanDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhucehuiyuanDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = qianyueDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (decimal.Parse(zhucehuiyuanDTO.benyueshuliang) > 0 || decimal.Parse(zhucehuiyuanDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(zhucehuiyuanDTO);
|
#endregion
|
|
#region 新增签约客户
|
TongjiBaoBiaoDTO qianyueDTO = new TongjiBaoBiaoDTO();
|
qianyueDTO.gongzuo = "新增签约客户";
|
//本月数量
|
var qianyueDTOsyue = _cooperatecustomCustomerService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin);
|
qianyueDTO.benyueshuliang = qianyueDTOsyue.Count.ToString();
|
//本日数量
|
var qianyueDTOsri = qianyueDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
qianyueDTO.benrishuliang = qianyueDTOsri.Count.ToString();
|
|
var jijianiqianyue = fiPiecerateDTOs.Where(x => x.Project == "新增签约客户").FirstOrDefault();
|
|
if (jijianiqianyue != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiqianyue.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
qianyueDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
qianyueDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = qianyueDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
qianyueDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
qianyueDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = qianyueDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (decimal.Parse(qianyueDTO.benyueshuliang) > 0 || decimal.Parse(qianyueDTO.benrishuliang) > 0)
|
tuiguangDTOs.Add(qianyueDTO);
|
#endregion
|
|
|
#region 专家录入
|
TongjiBaoBiaoDTO zhuanjialuruDTO = new TongjiBaoBiaoDTO();
|
zhuanjialuruDTO.gongzuo = "专家录入";
|
//本月数量
|
var zhuanjialuruDTOsyue = _expertService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin);
|
zhuanjialuruDTO.benyueshuliang = zhuanjialuruDTOsyue.Count.ToString();
|
//本日数量
|
var zhuanjialuruDTOsri = zhuanjialuruDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhuanjialuruDTO.benrishuliang = zhuanjialuruDTOsri.Count.ToString();
|
|
var jijianizhuanjialuru = fiPiecerateDTOs.Where(x => x.Project == "专家录入").FirstOrDefault();
|
|
if (jijianizhuanjialuru != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhuanjialuru.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhuanjialuruDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhuanjialuruDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = zhuanjialuruDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
zhuanjialuruDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhuanjialuruDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = intentionCustomerDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (zhuanjialuruDTOsyue.Count > 0 || zhuanjialuruDTOsri.Count > 0)
|
tuiguangDTOs.Add(zhuanjialuruDTO);
|
#endregion
|
|
|
List<TongjiBaoBiaoDTO> baifangkehuDTOs = new List<TongjiBaoBiaoDTO>();
|
|
#region 上门拜访客户
|
TongjiBaoBiaoDTO shangmenbanfangDTO = new TongjiBaoBiaoDTO();
|
shangmenbanfangDTO.gongzuo = "上门拜访客户";
|
//本月数量
|
var shangmenbanfangDTOsyue = _intentionVisitService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList();
|
var shangmenbanfangcooperDTOsyue = _cooperVisitService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.VisType == "02").ToList();
|
shangmenbanfangDTO.benyueshuliang = (shangmenbanfangcooperDTOsyue.Count + shangmenbanfangDTOsyue.Count).ToString();
|
//本日数量
|
var shangmenbanfangDTOsri = shangmenbanfangDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList();
|
var shangmenbanfangcooperDTOsri = shangmenbanfangcooperDTOsyue.Where(x => x.Vistime >= chauxnshijian.Date && x.Vistime < chauxnshijian.Date.AddDays(1)).ToList();
|
shangmenbanfangDTO.benrishuliang = (shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count).ToString();
|
|
var jijianixiangshangmenbanfang = fiPiecerateDTOs.Where(x => x.Project == "上门拜访客户").FirstOrDefault();
|
|
if (jijianixiangshangmenbanfang != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixiangshangmenbanfang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
//本月规定
|
shangmenbanfangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
//本日规定
|
shangmenbanfangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = shangmenbanfangcooperDTOsri.Count + shangmenbanfangDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
shangmenbanfangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
}
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
//本月规定
|
shangmenbanfangDTO.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 (decimal.Parse(shangmenbanfangDTO.benyueshuliang) > 0 || decimal.Parse(shangmenbanfangDTO.benrishuliang) > 0)
|
baifangkehuDTOs.Add(shangmenbanfangDTO);
|
#endregion
|
|
#region 接待来访客户
|
TongjiBaoBiaoDTO jiedailaifangDTO = new TongjiBaoBiaoDTO();
|
jiedailaifangDTO.gongzuo = "接待来访客户";
|
var jijianijiedailaifang = fiPiecerateDTOs.Where(x => x.Project == "接待来访客户").FirstOrDefault();
|
|
if (jijianijiedailaifang != null)
|
{
|
//本月数量
|
var jiedailaifangsyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianijiedailaifang.Id).ToList();
|
|
jiedailaifangDTO.benyueshuliang = (jiedailaifangsyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var jiedailaifangsri = jiedailaifangsyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
jiedailaifangDTO.benrishuliang = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
jiedailaifangDTO.dangrijixiao = (jiedailaifangsri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianijiedailaifang.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
jiedailaifangDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
jiedailaifangDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (jiedailaifangsri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// jiedailaifangDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
jiedailaifangDTO.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 (decimal.Parse(jiedailaifangDTO.benyueshuliang) > 0 || decimal.Parse(jiedailaifangDTO.benrishuliang) > 0)
|
baifangkehuDTOs.Add(jiedailaifangDTO);
|
#endregion
|
|
List<TongjiDingDanDTO> dingdanDTOs = new List<TongjiDingDanDTO>();
|
|
#region 新增订单
|
|
|
//本月数量
|
var dingdanDTOsyue = _cooperOrderService.GetListtongji(Userid, dateminkaoqin, datemaxkaoqin);
|
var benyuezonge = dingdanDTOsyue.Sum(x => x.Money) ?? 0;
|
|
//本日数量
|
var dingdanDTOsri = dingdanDTOsyue.Where(x => (x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)) || (x.Wangongtime >= chauxnshijian.Date && x.Wangongtime < chauxnshijian.Date.AddDays(1))).ToList();
|
foreach (var cooperOrderDTO in dingdanDTOsri)
|
{
|
TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO();
|
dingdanDTO.dingdanbianhao = cooperOrderDTO.OrderNo;
|
dingdanDTO.dingdanmingcheng = cooperOrderDTO.OrderTypeName + "-" + cooperOrderDTO.OrderType1Name + (string.IsNullOrEmpty(cooperOrderDTO.OrderType2) ? "" : "-" + cooperOrderDTO.OrderType2);
|
dingdanDTO.danjia = cooperOrderDTO.Price.Value.ToString("0.##");
|
dingdanDTO.shuliang = cooperOrderDTO.OrderNum.Value.ToString("0.##");
|
dingdanDTO.jine = cooperOrderDTO.Money.Value.ToString("0.##");
|
dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##");
|
|
dingdanDTOs.Add(dingdanDTO);
|
}
|
int dingdanDTOsCount = 1;
|
if (dingdanDTOs.Count == 0 && benyuezonge == 0)
|
{
|
dingdanDTOsCount = 0;
|
}
|
|
if (dingdanDTOs.Count == 0)
|
{
|
TongjiDingDanDTO dingdanDTO = new TongjiDingDanDTO();
|
dingdanDTO.benyueleijijine = benyuezonge.ToString("0.##");
|
|
dingdanDTOs.Add(dingdanDTO);
|
}
|
|
#endregion
|
|
List<TongjiBaoBiaoDTO> ziliaoweihuDTOs = new List<TongjiBaoBiaoDTO>();
|
#region 新闻资讯
|
TongjiBaoBiaoDTO xinwenzixunDTO = new TongjiBaoBiaoDTO();
|
xinwenzixunDTO.gongzuo = "新闻资讯";
|
//本月数量
|
DtChannelArticleNewsDTOSearch searchEntity = new DtChannelArticleNewsDTOSearch();
|
searchEntity.EndTime = datemaxkaoqin;
|
searchEntity.AddTime = dateminkaoqin;
|
searchEntity.UserName = userDTO.UserSn;
|
searchEntity.CategoryId = 3;
|
var dtChannelArticleNewsDTOs = _dtChannelArticleNewsService.GetList(searchEntity);
|
xinwenzixunDTO.benyueshuliang = dtChannelArticleNewsDTOs.Count.ToString();
|
//本日数量
|
var xinwenzixunsri = dtChannelArticleNewsDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList();
|
xinwenzixunDTO.benrishuliang = xinwenzixunsri.Count.ToString();
|
|
var jijianixinwenzixun = fiPiecerateDTOs.Where(x => x.Project == "新闻资讯").FirstOrDefault();
|
|
if (jijianixinwenzixun != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinwenzixun.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
xinwenzixunDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
xinwenzixunDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = xinwenzixunsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
xinwenzixunDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
xinwenzixunDTO.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 (decimal.Parse(xinwenzixunDTO.benyueshuliang) > 0 || decimal.Parse(xinwenzixunDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(xinwenzixunDTO);
|
#endregion
|
|
#region 典型案例
|
TongjiBaoBiaoDTO dianxinanliDTO = new TongjiBaoBiaoDTO();
|
dianxinanliDTO.gongzuo = "典型案例";
|
//本月数量
|
searchEntity = new DtChannelArticleNewsDTOSearch();
|
searchEntity.EndTime = datemaxkaoqin;
|
searchEntity.AddTime = dateminkaoqin;
|
searchEntity.UserName = userDTO.UserSn;
|
searchEntity.CategoryId = 85;
|
var dianxinanDTOs = _dtChannelArticleNewsService.GetList(searchEntity);
|
dianxinanliDTO.benyueshuliang = dianxinanDTOs.Count.ToString();
|
//本日数量
|
var dianxinanlisri = dianxinanDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList();
|
dianxinanliDTO.benrishuliang = dianxinanlisri.Count.ToString();
|
|
var jijianidianxinanli = fiPiecerateDTOs.Where(x => x.Project == "典型案例").FirstOrDefault();
|
|
if (jijianidianxinanli != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianidianxinanli.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
dianxinanliDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
dianxinanliDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = dianxinanlisri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
dianxinanliDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
dianxinanliDTO.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 (decimal.Parse(dianxinanliDTO.benyueshuliang) > 0 || decimal.Parse(dianxinanliDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(dianxinanliDTO);
|
#endregion
|
#region 政采知识
|
TongjiBaoBiaoDTO zhengcaizhishiDTO = new TongjiBaoBiaoDTO();
|
zhengcaizhishiDTO.gongzuo = "政采知识";
|
//本月数量
|
searchEntity = new DtChannelArticleNewsDTOSearch();
|
searchEntity.EndTime = datemaxkaoqin;
|
searchEntity.AddTime = dateminkaoqin;
|
searchEntity.UserName = userDTO.UserSn;
|
searchEntity.CategoryId = 73;
|
var zhengcaizhishiDTOs = _dtChannelArticleNewsService.GetList(searchEntity);
|
zhengcaizhishiDTO.benyueshuliang = zhengcaizhishiDTOs.Count.ToString();
|
//本日数量
|
var zhengcaizhishisri = zhengcaizhishiDTOs.Where(x => x.AddTime >= chauxnshijian.Date && x.AddTime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhengcaizhishiDTO.benrishuliang = zhengcaizhishisri.Count.ToString();
|
|
var jijianizhengcaizhishi = fiPiecerateDTOs.Where(x => x.Project == "政采知识").FirstOrDefault();
|
|
if (jijianizhengcaizhishi != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhengcaizhishi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhengcaizhishiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhengcaizhishiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = zhengcaizhishisri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
zhengcaizhishiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhengcaizhishiDTO.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 (decimal.Parse(zhengcaizhishiDTO.benyueshuliang) > 0 || decimal.Parse(zhengcaizhishiDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(zhengcaizhishiDTO);
|
#endregion
|
|
#region 新增公众号关注
|
TongjiBaoBiaoDTO gongzhonghaoDTO = new TongjiBaoBiaoDTO();
|
gongzhonghaoDTO.gongzuo = "新增公众号关注";
|
var jijianigongzhonghao = fiPiecerateDTOs.Where(x => x.Project == "新增公众号关注").FirstOrDefault();
|
|
if (jijianigongzhonghao != null)
|
{
|
//本月数量
|
var gongzhonghaosyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianigongzhonghao.Id).ToList();
|
|
gongzhonghaoDTO.benyueshuliang = (gongzhonghaosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var gongzhonghaosri = gongzhonghaosyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
gongzhonghaoDTO.benrishuliang = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
gongzhonghaoDTO.dangrijixiao = (gongzhonghaosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianigongzhonghao.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
gongzhonghaoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
gongzhonghaoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (gongzhonghaosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// gongzhonghaoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
gongzhonghaoDTO.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 (decimal.Parse(gongzhonghaoDTO.benyueshuliang) > 0 || decimal.Parse(gongzhonghaoDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(gongzhonghaoDTO);
|
#endregion
|
|
#region 网页制作
|
TongjiBaoBiaoDTO wangyeDTO = new TongjiBaoBiaoDTO();
|
wangyeDTO.gongzuo = "网页制作";
|
var jijianiwangye = fiPiecerateDTOs.Where(x => x.Project == "网页制作").FirstOrDefault();
|
|
if (jijianiwangye != null)
|
{
|
//本月数量
|
var wangyesyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianiwangye.Id).ToList();
|
|
wangyeDTO.benyueshuliang = (wangyesyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var wangyesri = wangyesyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
wangyeDTO.benrishuliang = (wangyesri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
wangyeDTO.dangrijixiao = (wangyesri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianiwangye.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
wangyeDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
wangyeDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (wangyesri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// wangyeDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
wangyeDTO.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 (decimal.Parse(wangyeDTO.benyueshuliang) > 0 || decimal.Parse(wangyeDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(wangyeDTO);
|
#endregion
|
|
#region 新增小采问题
|
TongjiBaoBiaoDTO xinzengwendaDTO = new TongjiBaoBiaoDTO();
|
xinzengwendaDTO.gongzuo = "新增小采问题";
|
//本月数量
|
var xinzengwendaDTOsyue = _liaotianService.GetListsalary(Userid, dateminkaoqin, datemaxkaoqin);
|
xinzengwendaDTO.benyueshuliang = xinzengwendaDTOsyue.Count.ToString();
|
//本日数量
|
var xinzengwendaDTOsri = xinzengwendaDTOsyue.Where(x => x.Createtime >= chauxnshijian.Date && x.Createtime < chauxnshijian.Date.AddDays(1)).ToList();
|
xinzengwendaDTO.benrishuliang = xinzengwendaDTOsri.Count.ToString();
|
|
var jijianixinzengwenda = fiPiecerateDTOs.Where(x => x.Project == "新增小采问题").FirstOrDefault();
|
|
if (jijianixinzengwenda != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianixinzengwenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
xinzengwendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
xinzengwendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = xinzengwendaDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
xinzengwendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
xinzengwendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = xinzengwendaDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (decimal.Parse(xinzengwendaDTO.benyueshuliang) > 0 || decimal.Parse(xinzengwendaDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(xinzengwendaDTO);
|
#endregion
|
|
#region 审核小采答问
|
TongjiBaoBiaoDTO shenhewendaDTO = new TongjiBaoBiaoDTO();
|
shenhewendaDTO.gongzuo = "审核小采答问";
|
//本月数量
|
var shenhewendaDTOsyue = _liaotianService.GetListsalaryshenhe(Userid, dateminkaoqin, datemaxkaoqin);
|
shenhewendaDTO.benyueshuliang = shenhewendaDTOsyue.Count.ToString();
|
//本日数量
|
var shenhewendaDTOsri = shenhewendaDTOsyue.Where(x => x.Shenhetime >= chauxnshijian.Date && x.Shenhetime < chauxnshijian.Date.AddDays(1)).ToList();
|
shenhewendaDTO.benrishuliang = shenhewendaDTOsri.Count.ToString();
|
|
var jijianishenhewenda = fiPiecerateDTOs.Where(x => x.Project == "审核小采答问").FirstOrDefault();
|
|
if (jijianishenhewenda != null)
|
{
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianishenhewenda.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
shenhewendaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
shenhewendaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
if (jixiaotichengfangan.Tichengstandard == "01")
|
{
|
decimal youxiaojijian = shenhewendaDTOsri.Count - jixiaotichengfangan.Renwu.Value;
|
if (youxiaojijian > 0)
|
{
|
shenhewendaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString("0.##");
|
}
|
|
}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
shenhewendaDTO.benyueqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##"); ;
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = shenhewendaDTOs.Count - renwujishu;
|
// if (youxiaojijian > 0)
|
// {
|
// hrSalaryDTO.Jixiaoticheng += Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2);
|
// }
|
|
//}
|
}
|
}
|
}
|
if (decimal.Parse(shenhewendaDTO.benyueshuliang) > 0 || decimal.Parse(shenhewendaDTO.benrishuliang) > 0)
|
ziliaoweihuDTOs.Add(shenhewendaDTO);
|
#endregion
|
|
List<TongjiBaoBiaoDTO> xiangmushishiDTOs = new List<TongjiBaoBiaoDTO>();
|
#region 标书制作
|
TongjiBaoBiaoDTO biaoshuzhizuoDTO = new TongjiBaoBiaoDTO();
|
biaoshuzhizuoDTO.gongzuo = "标书制作";
|
var jijianibiaoshuzhizuo = fiPiecerateDTOs.Where(x => x.Project == "标书制作").FirstOrDefault();
|
|
if (jijianibiaoshuzhizuo != null)
|
{
|
//本月数量
|
var biaoshuzhizuosyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshuzhizuo.Id).ToList();
|
|
biaoshuzhizuoDTO.benyueshuliang = (biaoshuzhizuosyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var biaoshuzhizuosri = biaoshuzhizuosyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
biaoshuzhizuoDTO.benrishuliang = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
biaoshuzhizuoDTO.dangrijixiao = (biaoshuzhizuosri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshuzhizuo.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
biaoshuzhizuoDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
biaoshuzhizuoDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (biaoshuzhizuosri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// biaoshuzhizuoDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
biaoshuzhizuoDTO.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 (decimal.Parse(biaoshuzhizuoDTO.benyueshuliang) > 0 || decimal.Parse(biaoshuzhizuoDTO.benrishuliang) > 0)
|
xiangmushishiDTOs.Add(biaoshuzhizuoDTO);
|
#endregion
|
|
#region 标书检查
|
TongjiBaoBiaoDTO biaoshujianchaDTO = new TongjiBaoBiaoDTO();
|
biaoshujianchaDTO.gongzuo = "标书检查";
|
var jijianibiaoshujiancha = fiPiecerateDTOs.Where(x => x.Project == "标书检查").FirstOrDefault();
|
|
if (jijianibiaoshujiancha != null)
|
{
|
//本月数量
|
var biaoshujianchasyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianibiaoshujiancha.Id).ToList();
|
|
biaoshujianchaDTO.benyueshuliang = (biaoshujianchasyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var biaoshujianchasri = biaoshujianchasyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
biaoshujianchaDTO.benrishuliang = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
biaoshujianchaDTO.dangrijixiao = (biaoshujianchasri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianibiaoshujiancha.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
biaoshujianchaDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
biaoshujianchaDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (biaoshujianchasri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// biaoshujianchaDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
biaoshujianchaDTO.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 (decimal.Parse(biaoshujianchaDTO.benyueshuliang) > 0 || decimal.Parse(biaoshujianchaDTO.benrishuliang) > 0)
|
xiangmushishiDTOs.Add(biaoshujianchaDTO);
|
#endregion
|
|
#region 起草质疑投诉
|
TongjiBaoBiaoDTO zhiyiDTO = new TongjiBaoBiaoDTO();
|
zhiyiDTO.gongzuo = "起草质疑投诉书";
|
var jijianizhiyi = fiPiecerateDTOs.Where(x => x.Project == "起草质疑投诉书").FirstOrDefault();
|
|
if (jijianizhiyi != null)
|
{
|
//本月数量
|
var zhiyisyue = _admPieceCheckService.GetList(Userid, dateminkaoqin, datemaxkaoqin).Where(x => x.WorkPro == jijianizhiyi.Id).ToList();
|
|
zhiyiDTO.benyueshuliang = (zhiyisyue.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
//本日数量
|
var zhiyisri = zhiyisyue.Where(x => x.WorkTime >= chauxnshijian.Date && x.WorkTime < chauxnshijian.Date.AddDays(1)).ToList();
|
zhiyiDTO.benrishuliang = (zhiyisri.Sum(x => x.Shuliang) ?? 0).ToString("0.##");
|
zhiyiDTO.dangrijixiao = (zhiyisri.Sum(x => x.Gongzi) ?? 0).ToString("0.##");
|
|
var jixiaotichengfangan = hrJixiaotichengThis.Where(x => x.PiecerateId == jijianizhiyi.Id).OrderByDescending(x => x.Effecttime).FirstOrDefault();
|
if (jixiaotichengfangan != null && jixiaotichengfangan.Ticheng.HasValue && jixiaotichengfangan.Renwu.HasValue)
|
{
|
if (jixiaotichengfangan.Renwustandard == "01")
|
{
|
|
zhiyiDTO.benyueqingkuang = (Yingchuqin * jixiaotichengfangan.Renwu.Value).ToString("0.##");
|
zhiyiDTO.benriqingkuang = jixiaotichengfangan.Renwu.Value.ToString("0.##");
|
//if (jixiaotichengfangan.Tichengstandard == "01")
|
//{
|
// decimal youxiaojijian = (zhiyisri.Sum(x => x.Shuliang) ?? 0) - jixiaotichengfangan.Renwu.Value;
|
// if (youxiaojijian > 0)
|
// {
|
// zhiyiDTO.dangrijixiao = Math.Round(jixiaotichengfangan.Ticheng.Value * youxiaojijian, 2).ToString();
|
// }
|
|
//}
|
|
}
|
else if (jixiaotichengfangan.Renwustandard == "02")
|
{
|
zhiyiDTO.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 (decimal.Parse(zhiyiDTO.benyueshuliang) > 0 || decimal.Parse(zhiyiDTO.benrishuliang) > 0)
|
xiangmushishiDTOs.Add(zhiyiDTO);
|
#endregion
|
|
|
|
TongjibaobiaobaobiaoDTO tongjibaobiaobaobiaoDTO = new TongjibaobiaobaobiaoDTO();
|
|
tongjibaobiaobaobiaoDTO.tuiguangDTOs = tuiguangDTOs;
|
tongjibaobiaobaobiaoDTO.baifangkehuDTOs = baifangkehuDTOs;
|
tongjibaobiaobaobiaoDTO.dingdanDTOs = dingdanDTOs;
|
tongjibaobiaobaobiaoDTO.ziliaoweihuDTOs = ziliaoweihuDTOs;
|
tongjibaobiaobaobiaoDTO.xiangmushishiDTOs = xiangmushishiDTOs;
|
tongjibaobiaobaobiaoDTO.dingdanDTOsCount = dingdanDTOsCount;
|
tongjibaobiaobaobiaoDTO.UserName = "";
|
if (deptDTO != null)
|
{
|
tongjibaobiaobaobiaoDTO.UserName += "部门：" + deptDTO.DeptName + "    ";
|
}
|
tongjibaobiaobaobiaoDTO.UserName += "姓名：" + userDTO.UserName + "    ";
|
|
tongjibaobiaobaobiaoDTO.UserDaka = "";
|
if (hrPositionDTO != null)
|
{
|
tongjibaobiaobaobiaoDTO.UserDaka += "职务：" + hrPositionDTO.PostName + "    ";
|
}
|
if (admSignInDTO != null)
|
{
|
tongjibaobiaobaobiaoDTO.UserDaka += " 打卡时间：上午 " + (admSignInDTO.MorningIn.HasValue? admSignInDTO.MorningIn.Value.ToString("HH:mm:ss"):"") + "-" + (admSignInDTO.MorningOut.HasValue ? admSignInDTO.MorningOut.Value.ToString("HH:mm:ss") : "")
|
+ "    下午 " + (admSignInDTO.AfternoonIn.HasValue ? admSignInDTO.AfternoonIn.Value.ToString("HH:mm:ss") : "") + "-" + (admSignInDTO.AfternoonOut.HasValue ? admSignInDTO.AfternoonOut.Value.ToString("HH:mm:ss") : "")
|
+ (admSignInDTO.OvertimeIn.HasValue ? " 加班 " + admSignInDTO.OvertimeIn.Value.ToString("HH:mm:ss") + "-" : "") + (admSignInDTO.OvertimeOut.HasValue ? admSignInDTO.OvertimeOut.Value.ToString("HH:mm:ss") : "");
|
}
|
|
tongjibaobiaobaobiaoDTOs.Add(tongjibaobiaobaobiaoDTO);
|
|
}
|
|
|
|
}
|
|
|
|
|
|
ViewBag.tongjibaobiaobaobiaoDTOs = tongjibaobiaobaobiaoDTOs;
|
|
ViewBag.Userid = Userids;
|
ViewBag.Tongjitime = chauxnshijian.ToString("yyyy-MM-dd");
|
|
ViewData["UserIds"] = userDTOs;
|
|
return View();
|
}
|
}
|
}
|
