mongoDB

最新推荐文章于 2024-09-30 10:32:01 发布

MomiTang

最新推荐文章于 2024-09-30 10:32:01 发布

阅读量255

点赞数

分类专栏： mongoDB 文章标签： mongodb

本文链接：https://blog.csdn.net/m0_37146562/article/details/122838078

版权

mongoDB 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

1.自签客户数
db.customer.find({ComAdminType:"自签管理方"}).count()

2.当前雇员数
db.employee.find({"ComAdminType": {$ne:"受托管理方"}}).count()

3.净额法营收
【系统账单】锁定账单总金额减去公积金、社保、工资 ServiceType <> 项目外包 or 灵活用工；
//锁定账单总金额
db.runCommand({"group":{
"ns":"bill_customer_receivable",
"key":"_id",
"initial":{"total":0},
"$reduce" : function(doc,prev){
var b = /^(-?\d+)(\.\d+)?$/;
var a = doc.receivable;
if(b.test(a)){
prev.total += parseFloat(a);
}else{
prev.total += 0;
}
},
"condition":{ServiceType:{$nin:["项目外包","灵活用工"]},LockTime:{$nin:["null",null]}}
}});
//工资
db.runCommand({"group":{
"ns":"bill_customer_receivable",
"key":"_id",
"initial":{"total":0},
"$reduce" : function(doc,prev){
var b = /^(-?\d+)(\.\d+)?$/;
var a = doc.Salary;
if(b.test(a)){
prev.total += parseFloat(a);
}else{
prev.total += 0;
}
},
"condition":{ServiceType:{$nin:["项目外包","灵活用工"]},LockTime:{$nin:["null",null]}}
}});
//社保
db.runCommand({"group":{
"ns":"bill_customer_receivable",
"key":"_id",
"initial":{"total":0},
"$reduce" : function(doc,prev){
var b = /^(-?\d+)(\.\d+)?$/;
var a = doc.SocialSecurityTaxTotal;
if(b.test(a)){
prev.total += parseFloat(a);
}else{
prev.total += 0;
}
},
"condition":{ServiceType:{$nin:["项目外包","灵活用工"]},LockTime:{$nin:["null",null]}}
}});
//公积金
db.runCommand({"group":{
"ns":"bill_customer_receivable",
"key":"_id",
"initial":{"total":0},
"$reduce" : function(doc,prev){
var b = /^(-?\d+)(\.\d+)?$/;
var a = doc.HousingFundTotal;
if(b.test(a)){
prev.total += parseFloat(a);
}else{
prev.total += 0;
}
},
"condition":{ServiceType:{$nin:["项目外包","灵活用工"]},LockTime:{$nin:["null",null]}}
}});
【历史账单】应收账单已核销，账单月份2021年，计算总金额。
db.bill_customer_receivable.find({IsVerification:true,BillMonth:{ $regex:/2021/ }}).count()

4.自签客户数量变化
db.customer.find({ComAdminType:"自签管理方",CustomerStatus:"现有客户",CreatedTime:{$gte:ISODate("2021-06-01T00:00:00.000+08:00"),$lte:ISODate("2021-06-30T00:00:00.000+08:00")}}).count()
db.customer.find({ComAdminType:"自签管理方",CustomerStatus:"潜在客户",CreatedTime:{$gte:ISODate("2021-06-01T00:00:00.000+08:00"),$lte:ISODate("2021-06-30T00:00:00.000+08:00")}}).count()
5.各省雇员数量
db.employee.aggregate({"$group":{"_id":"$OrganizationUID","count":{"$sum":1}}})

6.自签客户数量排名
db.customer.aggregate([
{
$match:{
ComAdminType:"自签管理方"
}
},
{
$group: {
_id: '$OrganizationUID',
num: {$sum: 1}
}
}
])

7.产品营收占比
db.bill_employee_receivable.aggregate([
{
$match:{BillMonth:"2021.01" }},
{
$group:{
_id:null,
total:{
$sum: {
$toDouble:'$HealthTaxTotal'
}
}
}
}
])

8.产品雇员占比
db.EmpAgreement.find({HealthTaxTotal:{$nin:["null","0.0000",null]}}).count()

9.福利产品分析
db.EmpAgreement.aggregate([
{
$match:{BillMonth:"2021.01"},{LockTime:{&nin:[null]}
}},
{
$group:{
_id:null,
total:{
$sum: {
$toDouble:'$WelfareTaxTotal'
}
}
}
}
])