基于RuoYi实现多条件分组排序列表
基于RuoYi实现多条件分组排序列表
页面效果
可通过复选框不同条件实现不同列数据加载
页面代码
telemarketingdata.html
<!DOCTYPE html>
<html lang="zh" xmlns:th="http://www.thymeleaf.org" xmlns:shiro="http://www.pollix.at/thymeleaf/shiro">
<head>
<th:block th:include="include :: header('数据报告')" />
<th:block th:include="include :: ztree-css" />
<th:block th:include="include :: select2-css" />
<th:block th:include="include :: bootstrap-select-css"/>
<style>
.center{text-align: center;}
</style>
</head>
<body class="gray-bg">
<div class="wrapper animated fadeInRight">
<!-- 搜索条件-->
<div class="row">
<div class="col-sm-12 search-collapse">
<form id="formId">
<div class="select-list">
<ul>
<li>
部门：<input type="text" name="createUserName" id="createUserName" readonly="readonly" onclick="ztreeShow();"/>
<input type="text" name="createByIds" id="createByIds" style="display: none" onclick="ztreeShow();"/>
</li>
<li style="height: 30px;">
<div style="float: left; padding-top: 8px;">
线索类型：
</div>
<div style="float: left;">
<select name="actionClueType" id="actionClueType" class="form-control">
<option value="">请选择</option>
<option th:each="regular:${regulars}"
th:value="${regular.id}" th:text="${regular.clueTypeName}"></option>
</select>
</div>
</li>
<li>
<label>查询时间：</label>
<input type="text" readonly="readonly" placeholder="时间范围" name="recordDate" id="recordDate"/>
<input type="hidden" name="startTime" id="startTime"/>
<input type="hidden" name="endTime" id="endTime"/>
</li>
<li>
<a class="btn btn-primary btn-rounded btn-sm" onclick="$.table.search()"><i class="fa fa-search"></i> 搜索</a>
<a class="btn btn-warning btn-rounded btn-sm" onclick="resetSearch();"><i class="fa fa-refresh"></i> 重置</a>
</li>
</ul>
</div>
<div id="treeDiv" class="box1" style="display: none;width: 200px;box-sizing: border-box;box-shadow: 0 2px 4px rgba(0, 0, 0, .12); position: absolute;z-index: 999;background-color: #fff;border: 1px solid #d2d2d2;">
<ul class="tree_ul ztree" id="tree" ></ul>
</div>
</form>
</div>
</div>
<!-- title-->
<div class="row">
<div class="ibox-content" style="padding: 15px 0px;">
<div class="alert alert-info" style="margin-bottom: 0px;">
综合指标
</div>
</div>
</div>
<!-- 8个div-->
<div class="row ibox-content">
<div class="col-sm-3">
<div class="ibox">
<div class="ibox-title">
<h4 class="center">跟进线索数量</h4>
</div>
<div class="ibox-content">
<p class="center beginToEnd">2021/07/01-2021/07/07</p>
<h2 class="center" id="followClueNum">0</h2>
</div>
</div>
</div>
<div class="col-sm-3">
<div class="ibox">
<div class="ibox-title">
<h4 class="center">有效线索数量</h4>
</div>
<div class="ibox-content">
<p class="center beginToEnd">2021/07/01-2021/07/07</p>
<h2 class="center" id="validClueNum">0</h2>
</div>
</div>
</div>
<div class="col-sm-3">
<div class="ibox">
<div class="ibox-title">
<h4 class="center">商机数</h4>
</div>
<div class="ibox-content">
<p class="center beginToEnd">2021/07/01-2021/07/07</p>
<h2 class="center" id="intendNum">0</h2>
</div>
</div>
</div>
<div class="col-sm-3">
<div class="ibox">
<div class="ibox-title">
<h4 class="center">更新商机数</h4>
</div>
<div class="ibox-content">
<p class="center beginToEnd">2021/07/01-2021/07/07</p>
<h2 class="center" id="updateIntentNum">0</h2>
</div>
</div>
</div>
</div>
<div class="row ibox-content">
<div class="col-sm-3">
<div class="ibox">
<div class="ibox-title">
<h4 class="center">已报价线索数量</h4>
</div>
<div class="ibox-content">
<p class="center beginToEnd">2021/07/01-2021/07/07</p>
<h2 class="center" id="quotationNum">0</h2>
</div>
</div>
</div>
<div class="col-sm-3">
<div class="ibox">
<div class="ibox-title">
<h4 class="center">有疑义线索数量</h4>
</div>
<div class="ibox-content">
<p class="center beginToEnd">2021/07/01-2021/07/07</p>
<h2 class="center" id="doubtNum">0</h2>
</div>
</div>
</div>
<div class="col-sm-3">
<div class="ibox">
<div class="ibox-title">
<h4 class="center">成单数量</h4>
</div>
<div class="ibox-content">
<p class="center beginToEnd">2021/07/01-2021/07/07</p>
<h2 class="center" id="orderPayNum">0</h2>
</div>
</div>
</div>
<div class="col-sm-3">
<div class="ibox">
<div class="ibox-title">
<h4 class="center">成单金额</h4>
</div>
<div class="ibox-content">
<p class="center beginToEnd">2021/07/01-2021/07/07</p>
<h2 class="center" id="orderPayAmount">0</h2>
</div>
</div>
</div>
</div>
<!-- 曲线+漏斗-->
<div class="row ibox-content">
<div class="col-sm-6">
<div class="ibox float-e-margins">
<div class="ibox-title">
<h5>线索变化趋势</h5>
<p style="float: right;" class="beginToEnd">2020/07/01-2020/07/07</p>
</div>
<div class="ibox-content">
<div class="echarts" id="changeOne"></div>
</div>
</div>
</div>
<div class="col-sm-6">
<div class="ibox float-e-margins">
<div class="ibox-title">
<h5>线索转化漏斗</h5>
<p style="float: right;" class="beginToEnd">2020/07/01-2020/07/07</p>
</div>
<div class="ibox-content">
<div class="echarts" id="changeTwo"></div>
</div>
</div>
</div>
</div>
<!-- 列表-->
<div class="row">
<div class="col-sm-12 search-collapse">
<form id="form2">
<div class="select-list">
<ul>
<li>
维度:
<input type="checkbox" name="selectParam" value="1" style="width: 50px;height: 20px;"/>团队
<input type="checkbox" name="selectParam" value="2" style="width: 50px;height: 20px;"/>电销
<input type="checkbox" name="selectParam" value="3" style="width: 50px;height: 20px;"/>线索类型
</li>
<li>
<a class="btn btn-primary btn-rounded btn-sm" onclick="query();"><i class="fa fa-search"></i> 加载</a>
<a class="btn btn-warning btn-rounded btn-sm" onclick="reset();"><i class="fa fa-refresh"></i> 重置</a>
</li>
</ul>
</div>
</form>
</div>
</div>
<div class="row">
<div class="col-sm-12 select-table table-striped">
<table id="bootstrap-table" data-mobile-responsive="true"></table>
</div>
</div>
</div>
<th:block th:include="include :: footer"/>
<th:block th:include="include :: ztree-js" />
<th:block th:include="include :: echarts-js" />
<th:block th:include="include :: select2-js" />
<th:block th:include="include :: bootstrap-select-js"/>
<script th:inline="javascript">
var prefix = ctx + "project/telemarketingData";
var columus = [
{
field : 'followClueNum',
title : '跟进线索数量'
},
{
field : 'validClueNum',
title : '有效线索数量'
},
{
field : 'intendNum',
title : '商机数量'
},
{
field : 'updateIntentNum',
title : '更新商机数量'
},
{
field : 'quotationNum',
title : '已报价数量'
},
{
field : 'doubtNum',
title : '有疑义线索数量'
},
{
field : 'orderPayNum',
title : '成单量'
},
{
field : 'orderPayAmount',
title : '成单金额'
},
{
field : 'addWechatNum',
title : '已加微信数量'
}];
function query() {
$("#bootstrap-table").bootstrapTable('destroy');
//增加展示列
var columns2 = [];
var selectParam = "";
$("input[name='selectParam']:checked").each(function () {
selectParam = selectParam + $(this).val() + ",";
});
if (selectParam != "") {
var one = selectParam.indexOf("1");
var two = selectParam.indexOf("2");
var three = selectParam.indexOf("3");
if (one >= 0 && two < 0 && three < 0) {
// 1
columns2.push({
field : 'deptName',
title : '部门'
});
columns2 = columns2.concat(columus);
}else if (one >= 0 && two >= 0 && three < 0) {
// 1,2
columns2.push({
field : 'deptName',
title : '部门'
},
{
field : 'userName',
title : '电销'
});
columns2 = columns2.concat(columus);
}else if (one >= 0 && two < 0 && three >= 0) {
//1,3
columns2.push({
field : 'deptName',
title : '部门'
},
{
field : 'clueTypeName',
title : '线索类型'
});
columns2 = columns2.concat(columus);
}else if (one >= 0 && two >= 0 && three >= 0) {
//1,2,3
columns2.push({
field : 'deptName',
title : '部门'
},
{
field : 'userName',
title : '电销'
},
{
field : 'clueTypeName',
title : '线索类型'
});
columns2 = columns2.concat(columus);
}else if (one < 0 && two >= 0 && three < 0) {
//2
columns2.push(
{
field : 'userName',
title : '电销'
});
columns2 = columns2.concat(columus);
}else if (one < 0 && two >= 0 && three >= 0) {
//2,3
columns2.push(
{
field : 'userName',
title : '电销'
},
{
field : 'clueTypeName',
title : '线索类型'
});
columns2 = columns2.concat(columus);
}else {
//3
columns2.push(
{
field : 'clueTypeName',
title : '线索类型'
});
columns2 = columns2.concat(columus);
}
}else {
columns2 = columus;
}
var options = {
url: prefix + "/getTelemarketingDataGroup",
modalName: "统计报表",
showExport: false,
showSearch: false,
showRefresh: false,
showToggle: false,
showColumns: false,
pagination:false,
queryParams: queryParams,
columns: columns2
};
$.table.init(options);
}
function queryParams(params) {
//获取复选框选中的值
var selectParam = "";
$("input[name='selectParam']:checked").each(function () {
selectParam = selectParam + $(this).val() + ",";
});
var search = $.table.queryParams(params);
search.selectParam = selectParam.toString();
return search;
}
function reset() {
$("[name='selectParam']").removeAttrs("checked");
}
$(function() {
// 初始化时间范围插件，传入三个id的名称
initDaterangepickerWithoutInitTime("recordDate","startTime","endTime");
getZtree();
var options = {
url: prefix + "/list",
modalName: "统计报表",
showExport: false,
showSearch: false,
showRefresh: false,
showToggle: false,
showColumns: false,
pagination:false,
onLoadSuccess:onLoadSuccess,
columns: columus
};
$.table.init(options);
});
function onLoadSuccess(data) {
var rows = data.rows;
var beginToEnd = "";
var followClueNum = 0;
var validClueNum = 0;
var intendNum = 0;
var updateIntentNum = 0;
var quotationNum = 0;
var doubtNum = 0;
var orderPayNum = 0;
var orderPayAmount = 0;
var addWechatNum = 0;
var arrx = new Array();
var followClueNumArr = new Array();
var validClueNumArr = new Array();
var intendNumArr = new Array();
var updateIntentNumArr = new Array();
var quotationNumArr = new Array();
var doubtNumArr = new Array();
var orderPayNumArr = new Array();
var orderPayAmountArr = new Array();
rows.forEach(function (e,index) {
arrx[index] = e.recordDate;
//获取时间组合串
if (index == 0) {
beginToEnd += e.recordDate +"-";
}
if (index == rows.length-1) {
beginToEnd += e.recordDate;
}
followClueNumArr[index] = e.followClueNum;
followClueNum = parseInt(followClueNum) + parseInt(e.followClueNum);
validClueNumArr[index] = e.validClueNum;
validClueNum = parseInt(validClueNum) + parseInt(e.validClueNum);
intendNumArr[index] = e.intendNum;
intendNum = parseInt(intendNum) + parseInt(e.intendNum);
updateIntentNumArr[index] = e.updateIntentNum;
updateIntentNum = parseInt(updateIntentNum) + parseInt(e.updateIntentNum);
quotationNumArr[index] = e.quotationNum;
quotationNum = parseInt(quotationNum) + parseInt(e.quotationNum);
doubtNumArr[index] = e.doubtNum;
doubtNum = parseInt(doubtNum) + parseInt(e.doubtNum);
orderPayNumArr[index] = e.orderPayNum;
orderPayNum = parseInt(orderPayNum) + parseInt(e.orderPayNum);
orderPayAmountArr[index] = e.orderPayAmount;
orderPayAmount = parseInt(orderPayAmount) + parseInt(e.orderPayAmount);
addWechatNum = parseInt(addWechatNum) + parseInt(e.addWechatNum);
});
$(".beginToEnd").html(beginToEnd);
$("#followClueNum").html(followClueNum);
$("#validClueNum").html(validClueNum);
$("#intendNum").html(intendNum);
$("#updateIntentNum").html(updateIntentNum);
$("#quotationNum").html(quotationNum);
$("#doubtNum").html(doubtNum);
$("#orderPayNum").html(orderPayNum);
$("#orderPayAmount").html(orderPayAmount);
loadLine(arrx,followClueNumArr,validClueNumArr,intendNumArr,updateIntentNumArr,quotationNumArr,doubtNumArr,orderPayNumArr,orderPayAmountArr);
loadFunnel(validClueNum,intendNum,orderPayNum);
//重新加载合计后的数据 组合数据data
var newdata = [];
newdata.push({followClueNum:followClueNum,validClueNum:validClueNum,intendNum:intendNum,
updateIntentNum:updateIntentNum,quotationNum:quotationNum,doubtNum:doubtNum,
orderPayNum:orderPayNum,orderPayAmount:orderPayAmount,addWechatNum:addWechatNum});
//获取原始 columns
var params = $("#bootstrap-table").bootstrapTable('getOptions');
//销毁初始加载表格
$("#bootstrap-table").bootstrapTable('destroy');
//重新加载
$("#bootstrap-table").bootstrapTable({
modalName: "统计报表",
data:newdata,
showExport: false,
showSearch: false,
showRefresh: false,
showToggle: false,
showColumns: false,
pagination:false,
columns: params.columns
});
}
//加载折线
function loadLine(arrx,followClueNumArr,validClueNumArr,intendNumArr,updateIntentNumArr,quotationNumArr,doubtNumArr,orderPayNumArr,orderPayAmountArr) {
//加载曲线
var chartDom = document.getElementById('changeOne');
var myChart = echarts.init(chartDom);
var option;
option = {
title: {
text: ''
},
tooltip: {
trigger: 'axis'
},
legend: {
data: ['跟进线索数量','有效线索数量', '商机数','更新商机数', '已报价线索数量', '有疑义线索数量', '成单数量','成单金额']
},
grid: {
left: '3%',
right: '4%',
bottom: '3%',
containLabel: true
},
xAxis: {
type: 'category',
boundaryGap: false,
data: arrx
},
yAxis: {
type: 'value'
},
series: [
{
name: '跟进线索数量',
type: 'line',
stack: '总量',
data: followClueNumArr
},
{
name: '有效线索数量',
type: 'line',
stack: '总量',
data: validClueNumArr
},
{
name: '商机数',
type: 'line',
stack: '总量',
data: intendNumArr
},
{
name: '更新商机数',
type: 'line',
stack: '总量',
data: updateIntentNumArr
},
{
name: '已报价线索数量',
type: 'line',
stack: '总量',
data: quotationNumArr
},
{
name: '有疑义线索数量',
type: 'line',
stack: '总量',
data: doubtNumArr
},
{
name: '成单数量',
type: 'line',
stack: '总量',
data: orderPayNumArr
},
{
name: '成单金额',
type: 'line',
stack: '总量',
data: orderPayAmountArr
}
]
};
option && myChart.setOption(option);
}
//加载漏斗图
function loadFunnel(validClueNum,intendNum,orderPayNum) {
//新建数组存放数量
var dataNum = new Array();
var json0 = {name:"有效用户"};
var json1 = {name:"商机"};
var json2 = {name:"成单"};
json0["value"]=validClueNum;
json1["value"]=intendNum;
json2["value"]=orderPayNum;
dataNum[0] = json0;
dataNum[1] = json1;
dataNum[2] = json2;
//新建数组存放转化率
var dataPercent = new Array();
var json00 = {name:"有效用户"};
var json11 = {name:"商机"};
var json22 = {name:"成单"};
if (validClueNum != 0) {
//商机转化率
var validPercent = parseFloat(validClueNum*100/validClueNum).toFixed(2);
var intendPercent = parseFloat(intendNum*100/validClueNum).toFixed(2);
json00["value"]=validPercent;
json11["value"]=intendPercent;
}else {
json00["value"]=0;
json11["value"]=0;
}
if (intendNum != 0) {
var orderPercent = parseFloat(orderPayNum*100/intendNum).toFixed(2);
json22["value"]=orderPercent;
}else {
json22["value"]=0;
}
dataPercent[0] = json00;
dataPercent[1] = json11;
dataPercent[2] = json22;
var chartDom = document.getElementById('changeTwo');
var myChart = echarts.init(chartDom);
var option;
option = {
tooltip: {
trigger: 'item',
formatter: "{b} : {c}"
},
legend: {
data: ['有效用户','商机','成单']
},
series: [
{
name: '数量',
type: 'funnel',
left: '10%',
width: '80%',
label: {
formatter: '{b}数'
},
labelLine: {
show: false
},
itemStyle: {
opacity: 0.7
},
emphasis: {
label: {
position: 'inside',
formatter: '{b}数: {c}'
}
},
data: dataNum
},
{
name: '转化率',
type: 'funnel',
left: '10%',
width: '80%',
label: {
position: 'inside',
formatter: '{c}%',
color: '#fff'
},
itemStyle: {
opacity: 0.5,
borderColor: '#fff',
borderWidth: 2
},
emphasis: {
label: {
position: 'inside',
formatter: '{b}转化率: {c}%'
}
},
data: dataPercent,
z: 100
}
]
};
option && myChart.setOption(option);
}
// 重置
function resetSearch(){
$("#actionClueType option:first").prop("selected",'selected');
$('#actionClueType').trigger('change.select2');
$.form.reset();
$("#recordDate").val('');
$("#startTime").val('');
$("#endTime").val('');
}
function getZtree() {
var url = ctx + "sys/userTreeData?status=0";
var options = {
url: url,
expandLevel: 2,
onCheck: callback,//点击事件
check: {
enable: true//是否开启复选框
}
};
$.tree.init(options);
//树节点点击事件
function callback() {
var treeObj = $.fn.zTree.getZTreeObj("tree"),
nodes = treeObj.getCheckedNodes(true),
v = "";
var userNames="";
var userIds="";
for (var i = 0; i < nodes.length; i++) {
//获取以u结尾的用户信息
if (nodes[i].id.toString().indexOf("u")!=-1) {
userNames+=nodes[i].name+";";
userIds+=nodes[i].id.toString().split("u")[0]+",";
}
}
$("#createUserName").val(userNames);
$("#createByIds").val(userIds);
}
}
//部门
function ztreeShow() {
var nameObj = $("#createUserName");
var nameOffset = nameObj.offset();
$("#treeDiv").css({left:nameOffset.left-20 + "px", top:nameOffset.top-21 + nameObj.outerHeight() + "px"}).slideDown("fast");
$("body").bind("mousedown", onBodyDown);
}
//树折叠
function onBodyDown(event) {
if (!(event.target.id == "treeDiv" || $(event.target).parents("#treeDiv").length > 0)) {
hideMenu();
}
}
function hideMenu() {
$("#treeDiv").fadeOut("fast");
$("body").unbind("mousedown", onBodyDown);
}
</script>
</body>
</html>java代码
TelemarketingDataController.java
package com.dongao.project.telemarketingdata.controller;
import com.dongao.project.clueregular.domain.ClueRegular;
import com.dongao.project.clueregular.service.IClueRegularService;
import com.dongao.project.common.constants.Constants;
import com.dongao.project.sys.domain.MaxDataScope;
import com.dongao.project.sys.service.SysService;
import com.dongao.project.telemarketingdata.domain.TelemarketingData;
import com.dongao.project.telemarketingdata.service.ITelemarketingDataService;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.poi.ExcelUtil;
import com.ruoyi.common.utils.security.ShiroUtils;
import com.ruoyi.common.utils.text.Convert;
import com.ruoyi.framework.aspectj.DataScopeAspect;
import com.ruoyi.framework.aspectj.lang.annotation.Log;
import com.ruoyi.framework.aspectj.lang.enums.BusinessType;
import com.ruoyi.framework.web.controller.BaseController;
import com.ruoyi.framework.web.domain.AjaxResult;
import com.ruoyi.framework.web.page.TableDataInfo;
import com.ruoyi.project.system.role.domain.Role;
import com.ruoyi.project.system.user.domain.User;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.*;
import java.util.Arrays;
import java.util.List;
import java.util.Map;
/**
* 电销数据信息操作处理
*
* @author dongao
* @date 2021-08-16
*/
@Controller
@RequestMapping("/project/telemarketingData")
public class TelemarketingDataController extends BaseController
{
private String prefix = "project/telemarketingdata";
@Autowired
private ITelemarketingDataService telemarketingDataService;
@Autowired
private IClueRegularService clueRegularService;
@Autowired
private SysService sysService;
@RequiresPermissions("project:telemarketingData:view")
@GetMapping()
public String telemarketingData(ModelMap mmap)
{
//获取有效线索类型
ClueRegular cr = new ClueRegular();
cr.setDelFlag(Constants.DEL_FLAG.YES.getValue());
List<ClueRegular> clueRegulars = clueRegularService.selectClueRegularList(cr);
mmap.put("regulars",clueRegulars);
return prefix + "/telemarketingdata";
}
/**
* 查询电销数据列表
*/
@RequiresPermissions("project:telemarketingData:list")
@PostMapping("/list")
@ResponseBody
public TableDataInfo list(@RequestParam Map<String,Object> paramMap)
{
//电销数据列表 所属部门
String createByIds = (String) paramMap.get("createByIds");
if (StringUtils.isNotEmpty(createByIds)) {
paramMap.put("userList", Arrays.asList(Convert.toLongArray(createByIds)));
}else {
//部門數據權限
User currentUser = ShiroUtils.getSysUser();
List<Role> roles = currentUser.getRoles();
MaxDataScope maxDataScope = sysService.getMaxDataScope(roles, currentUser);
if (DataScopeAspect.DATA_SCOPE_ALL.equals(maxDataScope.getDataScope())) {
//当前用户角色是全数据权限
}else {
List<Long> userList = maxDataScope.getUserList();
paramMap.put("userList",userList);
}
}
List<Map> list = telemarketingDataService.getTelemarketingDataGroup(paramMap);
return getDataTable(list);
}
/**
* 获取有分组维度的统计数据
*/
@RequestMapping("/getTelemarketingDataGroup")
@ResponseBody
public TableDataInfo getTelemarketingDataGroup(@RequestParam Map<String,Object> paramMap)
{
String createByIds = (String) paramMap.get("createByIds");
//电销数据列表 所属部门
if (StringUtils.isNotEmpty(createByIds)) {
paramMap.put("userList", Arrays.asList(Convert.toLongArray(createByIds)));
}else {
//部門數據權限
User currentUser = ShiroUtils.getSysUser();
List<Role> roles = currentUser.getRoles();
MaxDataScope maxDataScope = sysService.getMaxDataScope(roles, currentUser);
if (DataScopeAspect.DATA_SCOPE_ALL.equals(maxDataScope.getDataScope())) {
//当前用户角色是全数据权限
}else {
List<Long> userList = maxDataScope.getUserList();
paramMap.put("userList",userList);
}
}
List<Map> list = telemarketingDataService.getTelemarketingDataGroup(paramMap);
return getDataTable(list);
}
}TelemarketingDataServiceImpl.java
package com.dongao.project.telemarketingdata.service;
import com.dongao.project.clueregular.domain.ClueRegular;
import com.dongao.project.clueregular.mapper.ClueRegularMapper;
import com.dongao.project.telemarketingdata.domain.TelemarketingData;
import com.dongao.project.telemarketingdata.mapper.TelemarketingDataMapper;
import com.ruoyi.common.utils.DateUtils;
import com.ruoyi.common.utils.StringUtils;
import com.ruoyi.common.utils.security.ShiroUtils;
import com.ruoyi.common.utils.text.Convert;
import com.ruoyi.project.system.dept.domain.Dept;
import com.ruoyi.project.system.dept.mapper.DeptMapper;
import com.ruoyi.project.system.user.domain.User;
import com.ruoyi.project.system.user.mapper.UserMapper;
import org.apache.commons.collections.CollectionUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.math.BigDecimal;
import java.util.*;
import java.util.stream.Collectors;
/**
* 电销数据 服务层实现
*
* @author dongao
* @date 2021-08-16
*/
@Service
public class TelemarketingDataServiceImpl implements ITelemarketingDataService
{
@Autowired
private TelemarketingDataMapper telemarketingDataMapper;
@Autowired
private DeptMapper deptMapper;
@Autowired
private UserMapper userMapper;
@Autowired
private ClueRegularMapper clueRegularMapper;
/**
* 查询电销数据列表
* @param paramMap
* @return
*/
@Override
public List<Map> selectTelemarketingDataListOther(Map<String, Object> paramMap) {
List<TelemarketingData> dataList = telemarketingDataMapper.selectTelemarketingDataListOther(paramMap);
List<Map> list = new ArrayList<>();
if (CollectionUtils.isNotEmpty(dataList)) {
//获取返回参数值
TreeMap<Date, List<TelemarketingData>> collect = dataList.stream().collect(Collectors.groupingBy(TelemarketingData::getRecordDate, TreeMap::new, Collectors.toList()));
for (Date date : collect.keySet()) {
Map map = new HashMap(16);
//key 为分组日期参数
map.put("recordDate",DateUtils.parseDateToStr("yyyy/MM/dd",date));
List<TelemarketingData> teleData = collect.get(date);
getResultList(list, map, teleData);
}
}
return list;
}
/**
* 获取有分组维度的统计数据
* @param paramMap
* @return
*/
@Override
public List<Map> getTelemarketingDataGroup(Map paramMap) {
List<TelemarketingData> dataList = telemarketingDataMapper.selectTelemarketingDataListOther(paramMap);
List<Map> list = new ArrayList<>();
if (CollectionUtils.isNotEmpty(dataList)) {
//判断按那种维度分组
String selectParam = (String) paramMap.get("selectParam");
if (StringUtils.isNotEmpty(selectParam)) {
//1 团队 2 电销 3 线索类型
boolean one = selectParam.contains("1");
boolean two = selectParam.contains("2");
boolean three = selectParam.contains("3");
if (one && !two && !three) {
//1 团队分组
TreeMap<Long, List<TelemarketingData>> collect = dataList.stream().collect(Collectors.groupingBy(TelemarketingData::getDeptId, TreeMap::new, Collectors.toList()));
for (Long deptId : collect.keySet()) {
Map map = new HashMap(16);
// key is deptId
Dept dept = deptMapper.selectDeptById(deptId);
if (dept != null) {
map.put("deptName",dept.getDeptName());
}
List<TelemarketingData> teleData = collect.get(deptId);
getResultList(list, map, teleData);
}
}else if (one && two && !three) {
//1,2 团队+电销分组
TreeMap<Long, TreeMap<Long, List<TelemarketingData>>> collect = dataList.stream().collect(Collectors.groupingBy(TelemarketingData::getDeptId, TreeMap::new, Collectors.groupingBy(TelemarketingData::getRecordBy, TreeMap::new, Collectors.toList())));
for (Long deptId : collect.keySet()) {
// key is deptId
Dept dept = deptMapper.selectDeptById(deptId);
TreeMap<Long, List<TelemarketingData>> collect2 = collect.get(deptId);
for (Long recordBy : collect2.keySet()) {
Map map = new HashMap(16);
if (dept != null) {
map.put("deptName",dept.getDeptName());
}
//key is recordBy
User user = userMapper.selectUserById(recordBy);
if (user != null) {
map.put("userName",user.getUserName());
}
List<TelemarketingData> teleData = collect2.get(recordBy);
getResultList(list, map, teleData);
}
}
}else if (one && !two && three) {
//1,3 团队+线索类型分组
TreeMap<Long, TreeMap<Long, List<TelemarketingData>>> collect = dataList.stream().collect(Collectors.groupingBy(TelemarketingData::getDeptId, TreeMap::new, Collectors.groupingBy(TelemarketingData::getActionClueType, TreeMap::new, Collectors.toList())));
for (Long deptId : collect.keySet()) {
// key is deptId
Dept dept = deptMapper.selectDeptById(deptId);
TreeMap<Long, List<TelemarketingData>> collect2 = collect.get(deptId);
for (Long actionClueType : collect2.keySet()) {
Map map = new HashMap(16);
if (dept != null) {
map.put("deptName",dept.getDeptName());
}
//key is actionClueType
ClueRegular clueRegular = clueRegularMapper.selectClueRegularById(actionClueType);
if (clueRegular != null) {
map.put("clueTypeName",clueRegular.getClueTypeName());
}
List<TelemarketingData> teleData = collect2.get(actionClueType);
getResultList(list, map, teleData);
}
}
}else if (one && two && three) {
//1,2,3 团队+电销+线索类型 分组
TreeMap<Long, TreeMap<Long, TreeMap<Long, List<TelemarketingData>>>> collect = dataList.stream().collect(Collectors.groupingBy(TelemarketingData::getDeptId, TreeMap::new, Collectors.groupingBy(TelemarketingData::getRecordBy, TreeMap::new, Collectors.groupingBy(TelemarketingData::getActionClueType, TreeMap::new, Collectors.toList()))));
for (Long deptId : collect.keySet()) {
// key is deptId
Dept dept = deptMapper.selectDeptById(deptId);
TreeMap<Long, TreeMap<Long, List<TelemarketingData>>> collect2 = collect.get(deptId);
for (Long recordBy : collect2.keySet()) {
// key is recordBy
User user = userMapper.selectUserById(recordBy);
TreeMap<Long, List<TelemarketingData>> collect3 = collect2.get(recordBy);
for (Long actionClueType : collect3.keySet()) {
Map map = new HashMap(16);
if (dept != null) {
map.put("deptName",dept.getDeptName());
}
if (user != null) {
map.put("userName",user.getUserName());
}
//key is actionClueType
ClueRegular clueRegular = clueRegularMapper.selectClueRegularById(actionClueType);
if (clueRegular != null) {
map.put("clueTypeName",clueRegular.getClueTypeName());
}
List<TelemarketingData> teleData = collect3.get(actionClueType);
getResultList(list, map, teleData);
}
}
}
}else if (!one && two && !three) {
//2 电销分组
TreeMap<Long, List<TelemarketingData>> collect = dataList.stream().collect(Collectors.groupingBy(TelemarketingData::getRecordBy, TreeMap::new, Collectors.toList()));
for (Long recordBy : collect.keySet()) {
Map map = new HashMap(16);
// key is recordBy
User user = userMapper.selectUserById(recordBy);
if (user != null) {
map.put("userName",user.getUserName());
}
List<TelemarketingData> teleData = collect.get(recordBy);
getResultList(list, map, teleData);
}
}else if (!one && two && three) {
//2,3 电销+线索类型 分组
TreeMap<Long, TreeMap<Long, List<TelemarketingData>>> collect = dataList.stream().collect(Collectors.groupingBy(TelemarketingData::getRecordBy, TreeMap::new, Collectors.groupingBy(TelemarketingData::getActionClueType, TreeMap::new, Collectors.toList())));
for (Long recordBy : collect.keySet()) {
// key is recordBy
User user = userMapper.selectUserById(recordBy);
TreeMap<Long, List<TelemarketingData>> collect2 = collect.get(recordBy);
for (Long actionClueType : collect2.keySet()) {
Map map = new HashMap(16);
if (user != null) {
map.put("userName",user.getUserName());
}
//key is actionClueType
ClueRegular clueRegular = clueRegularMapper.selectClueRegularById(actionClueType);
if (clueRegular != null) {
map.put("clueTypeName",clueRegular.getClueTypeName());
}
List<TelemarketingData> teleData = collect2.get(actionClueType);
getResultList(list, map, teleData);
}
}
}else {
// 最后一种分组方式 3 线索类型分组
TreeMap<Long, List<TelemarketingData>> collect = dataList.stream().collect(Collectors.groupingBy(TelemarketingData::getActionClueType, TreeMap::new, Collectors.toList()));
for (Long actionClueType : collect.keySet()) {
Map map = new HashMap(16);
// key is actionClueType
ClueRegular clueRegular = clueRegularMapper.selectClueRegularById(actionClueType);
if (clueRegular != null) {
map.put("clueTypeName",clueRegular.getClueTypeName());
}
List<TelemarketingData> teleData = collect.get(actionClueType);
getResultList(list, map, teleData);
}
}
}else {
//无维度参数 则默认 统计日期分组
TreeMap<Date, List<TelemarketingData>> collect = dataList.stream().collect(Collectors.groupingBy(TelemarketingData::getRecordDate, TreeMap::new, Collectors.toList()));
for (Date date : collect.keySet()) {
Map map = new HashMap(16);
map.put("recordDate",DateUtils.parseDateToStr("yyyy/MM/dd",date));
List<TelemarketingData> teleData = collect.get(date);
getResultList(list, map, teleData);
}
}
}
return list;
}
/**
* 组装返回参数值
* @param list
* @param map
* @param teleData
*/
private void getResultList(List<Map> list, Map map, List<TelemarketingData> teleData) {
/** 跟进线索数量 */
long followClueNum = 0;
/** 有效线索数量 */
long validClueNum = 0;
/** 商机数量 */
long intendNum = 0;
/** 更新商机数量 */
long updateIntentNum = 0;
/** 已报价数量 */
long quotationNum = 0;
/** 有疑义线索数量 */
long doubtNum = 0;
/** 成单量 */
long orderPayNum = 0;
/** 成单金额 */
BigDecimal orderPayAmount = new BigDecimal(0);
/** 已加微信数量 */
long addWechatNum = 0;
for (TelemarketingData td : teleData) {
followClueNum += td.getFollowClueNum();
validClueNum += td.getValidClueNum();
intendNum += td.getIntendNum();
updateIntentNum += td.getUpdateIntentNum();
quotationNum += td.getQuotationNum();
doubtNum += td.getDoubtNum();
orderPayNum += td.getOrderPayNum();
orderPayAmount = orderPayAmount.add(td.getOrderPayAmount());
addWechatNum += td.getAddWechatNum();
}
map.put("followClueNum",followClueNum);
map.put("validClueNum",validClueNum);
map.put("intendNum",intendNum);
map.put("updateIntentNum",updateIntentNum);
map.put("quotationNum",quotationNum);
map.put("doubtNum",doubtNum);
map.put("orderPayNum",orderPayNum);
map.put("orderPayAmount",orderPayAmount);
map.put("addWechatNum",addWechatNum);
list.add(map);
}
}TelemarketingDataMapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dongao.project.telemarketingdata.mapper.TelemarketingDataMapper">
<resultMap type="TelemarketingData" id="TelemarketingDataResult">
<result property="id" column="id" />
<result property="recordDate" column="record_date" />
<result property="recordBy" column="record_by" />
<result property="actionClueType" column="action_clue_type" />
<result property="followClueNum" column="follow_clue_num" />
<result property="validClueNum" column="valid_clue_num" />
<result property="intendNum" column="intend_num" />
<result property="updateIntentNum" column="update_intent_num" />
<result property="quotationNum" column="quotation_num" />
<result property="doubtNum" column="doubt_num" />
<result property="orderPayNum" column="order_pay_num" />
<result property="orderPayAmount" column="order_pay_amount" />
<result property="addWechatNum" column="add_wechat_num" />
<result property="delFlag" column="del_flag" />
<result property="createTime" column="create_time" />
<result property="createBy" column="create_by" />
<result property="updateTime" column="update_time" />
<result property="updateBy" column="update_by" />
<result property="remark" column="remark" />
</resultMap>
<sql id="selectTelemarketingDataVo">
select id, record_date, record_by, action_clue_type, follow_clue_num, valid_clue_num, intend_num,update_intent_num, quotation_num, doubt_num, order_pay_num, order_pay_amount, add_wechat_num, del_flag, create_time, create_by, update_time, update_by, remark from crm_account_telemarketing_data
</sql>
<select id="selectTelemarketingDataList" parameterType="TelemarketingData" resultMap="TelemarketingDataResult">
<include refid="selectTelemarketingDataVo"/>
<where>
and del_flag = 0
<if test="id != null "> and id = #{id}</if>
<if test="recordDate != null "> and record_date = #{recordDate}</if>
<if test="recordBy != null "> and record_by = #{recordBy}</if>
<if test="actionClueType != null "> and action_clue_type = #{actionClueType}</if>
<if test="followClueNum != null "> and follow_clue_num = #{followClueNum}</if>
<if test="validClueNum != null "> and valid_clue_num = #{validClueNum}</if>
<if test="intendNum != null "> and intend_num = #{intendNum}</if>
<if test="updateIntentNum != null "> and update_intent_num = #{updateIntentNum}</if>
<if test="quotationNum != null "> and quotation_num = #{quotationNum}</if>
<if test="doubtNum != null "> and doubt_num = #{doubtNum}</if>
<if test="orderPayNum != null "> and order_pay_num = #{orderPayNum}</if>
<if test="orderPayAmount != null "> and order_pay_amount = #{orderPayAmount}</if>
<if test="addWechatNum != null "> and add_wechat_num = #{addWechatNum}</if>
<if test="delFlag != null "> and del_flag = #{delFlag}</if>
<if test="createTime != null "> and create_time = #{createTime}</if>
<if test="createBy != null and createBy != '' "> and create_by = #{createBy}</if>
<if test="updateTime != null "> and update_time = #{updateTime}</if>
<if test="updateBy != null and updateBy != '' "> and update_by = #{updateBy}</if>
<if test="remark != null and remark != '' "> and remark = #{remark}</if>
</where>
</select>
<select id="selectTelemarketingData" parameterType="TelemarketingData" resultMap="TelemarketingDataResult">
<include refid="selectTelemarketingDataVo"/>
<where>
and del_flag = 0
<if test="id != null "> and id = #{id}</if>
<if test="recordDate != null "> and record_date = #{recordDate}</if>
<if test="recordBy != null "> and record_by = #{recordBy}</if>
<if test="actionClueType != null "> and action_clue_type = #{actionClueType}</if>
<if test="followClueNum != null "> and follow_clue_num = #{followClueNum}</if>
<if test="validClueNum != null "> and valid_clue_num = #{validClueNum}</if>
<if test="intendNum != null "> and intend_num = #{intendNum}</if>
<if test="updateIntentNum != null "> and update_intent_num = #{updateIntentNum}</if>
<if test="quotationNum != null "> and quotation_num = #{quotationNum}</if>
<if test="doubtNum != null "> and doubt_num = #{doubtNum}</if>
<if test="orderPayNum != null "> and order_pay_num = #{orderPayNum}</if>
<if test="orderPayAmount != null "> and order_pay_amount = #{orderPayAmount}</if>
<if test="addWechatNum != null "> and add_wechat_num = #{addWechatNum}</if>
<if test="delFlag != null "> and del_flag = #{delFlag}</if>
<if test="createTime != null "> and create_time = #{createTime}</if>
<if test="createBy != null and createBy != '' "> and create_by = #{createBy}</if>
<if test="updateTime != null "> and update_time = #{updateTime}</if>
<if test="updateBy != null and updateBy != '' "> and update_by = #{updateBy}</if>
<if test="remark != null and remark != '' "> and remark = #{remark}</if>
</where>
</select>
<select id="selectTelemarketingDataListOther" parameterType="Map" resultMap="TelemarketingDataResult">
SELECT t1.record_date, t1.record_by, t1.action_clue_type, t1.follow_clue_num, t1.valid_clue_num, t1.intend_num,t1.update_intent_num,
t1.quotation_num, t1.doubt_num, t1.order_pay_num, t1.order_pay_amount, t1.add_wechat_num,t2.dept_id deptId
FROM crm_account_telemarketing_data t1
LEFT JOIN sys_user t2 ON t1.record_by=t2.user_id
WHERE t1.del_flag=0 AND t2.del_flag=0
<if test="paramMap != null">
<if test="paramMap.userList != null">
AND record_by IN
<foreach collection="paramMap.userList" item="recordBy" open="(" close=")" separator=",">
#{recordBy}
</foreach>
</if>
<if test="paramMap.actionClueType != null and paramMap.actionClueType != ''">
AND action_clue_type = #{paramMap.actionClueType}
</if>
<choose>
<when test="paramMap.startTime != null or paramMap.startTime != ''">
<if test="paramMap.startTime != null and paramMap.startTime != ''" >
AND record_date >= #{paramMap.startTime}
</if>
<if test="paramMap.endTime != null and paramMap.endTime != '' " >
AND record_date <= #{paramMap.endTime}
</if>
</when>
<otherwise>
AND record_date <= now()
</otherwise>
</choose>
</if>
ORDER BY record_date
</select>
</mapper>【注】本文仅用于工作中日常记录，方便后续查阅，仅可用于学习用途，不可用于商业用途。
本文参与?腾讯云自媒体分享计划，分享自作者个人站点/博客。
原始发表：2024-03-28，如有侵权请联系 cloudcommunity@tencent.com 删除
评论
登录后参与评论
推荐阅读
目录
相关产品与服务
腾讯云 BI
腾讯云 BI（Business Intelligence，BI）提供从数据源接入、数据建模到数据可视化分析全流程的BI能力，帮助经营者快速获取决策数据依据。系统采用敏捷自助式设计，使用者仅需通过简单拖拽即可完成原本复杂的报表开发过程，并支持报表的分享、推送等企业协作场景。