#

Junjie

2023-09-07 86dc7d83fd8672c804edac3c93f71d8adc754af3

#

 src/main/java/com/zy/crm/manager/controller/DashboardController.java

@@ -84,6 +84,14 @@
        map.put("successMoney", WordUtils.formatNumberForAccounting(successMoney));//全年交易成功金额
        map.put("progressMoney", WordUtils.formatNumberForAccounting(progressMoney));//全年未交易成功金额
        map.put("yearTransactionRate", String.format("%.2f", yearTransactionRate));//全年交易率

        //获取全年跟踪数量
        Integer progressCount = orderService.selectCountByUserYearAndStatus(user.getId(), year, 0);
        //获取全年成交数量
        Integer successCount = orderService.selectCountByUserYearAndStatus(user.getId(), year, 1);
        map.put("progressCount", progressCount);
        map.put("successCount", successCount);

        return R.ok().add(map);
    }


 src/main/java/com/zy/crm/manager/mapper/OrderMapper.java

@@ -24,6 +24,8 @@

    Double selectMoneyByUserAndYearAndStatus(Long userId, String year, Integer status);//获取指定用户、年份和订单状态总交易金额

    Integer selectCountByUserYearAndStatus(Long userId, String year, Integer status);//获取指定年份和订单状态总数量

    List<Order> selectTopMoney();//查询交易额前7名员工

    List<HashMap<String, Object>> selectCurrentYearMonthSuccess();//获取当前年度12个月的交易成功金额数据

 src/main/java/com/zy/crm/manager/service/OrderService.java

@@ -20,6 +20,8 @@

    Double selectMoneyByUserAndYearAndStatus(Long userId, String year, Integer status);//获取指定用户、年份和订单状态总交易金额

    Integer selectCountByUserYearAndStatus(Long userId, String year, Integer status);//获取指定年份和订单状态总数量

    List<Order> selectTopMoney();//查询交易额前7名员工

    List<Double> selectCurrentYearMonthSuccess();//获取当前年度12个月的交易成功金额数据

 src/main/java/com/zy/crm/manager/service/impl/OrderServiceImpl.java

@@ -81,6 +81,11 @@
    }

    @Override
    public Integer selectCountByUserYearAndStatus(Long userId, String year, Integer status) {
        return this.baseMapper.selectCountByUserYearAndStatus(userId, year, status);
    }

    @Override
    public List<Order> selectTopMoney() {
        return this.baseMapper.selectTopMoney();
    }

 src/main/resources/mapper/OrderMapper.xml

@@ -115,6 +115,13 @@
        and user_id = #{userId}
    </select>

    <select id="selectCountByUserYearAndStatus" resultType="java.lang.Integer">
        select count(*) num from man_order
        where year(create_time) = #{year}
        and status = #{status}
        and user_id = #{userId}
    </select>

    <select id="selectTopMoney" resultMap="BaseResultMap">
        select top 7 user_id,sum(money) money from man_order
        where status = 1

 src/main/webapp/views/home/dashboard.html

@@ -50,51 +50,77 @@
                    <div class="layui-row">
                        <div>团队数据</div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">全年目标</div>
                            <div class="numberInfoSubTitle">年度销售目标</div>
                            <div class="numberInfoValue">
                                <span id="companyYearTarget">124,543,233</span><em class="numberInfoSuffix">元</em>
                                <span id="companyYearTarget">124,543,233</span><em class="numberInfoSuffix">万元</em>
                            </div>
                        </div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">已完成交易</div>
                            <div class="numberInfoSubTitle">已完成销售任务</div>
                            <div class="numberInfoValue">
                                <span id="companySuccess">124,543,233</span><em class="numberInfoSuffix">元</em>
                                <span id="companySuccess">124,543,233</span><em class="numberInfoSuffix">万元</em>
                            </div>
                        </div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">未完成交易</div>
                            <div class="numberInfoSubTitle">未完成销售任务</div>
                            <div class="numberInfoValue">
                                <span id="companyProgress">124,543,233</span><em class="numberInfoSuffix">元</em>
                                <span id="companyProgress">124,543,233</span><em class="numberInfoSuffix">万元</em>
                            </div>
                        </div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">交易率</div>
                            <div class="numberInfoSubTitle">完成率</div>
                            <div class="numberInfoValue"><span id="companyRate">92</span>%</div>
                        </div>
                    </div>
                    <div class="layui-row" style="margin-top: 50px;">
                        <div>个人数据</div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">全年目标</div>
                            <div class="numberInfoSubTitle">年度销售目标</div>
                            <div class="numberInfoValue">
                                <span id="personYearTarget">124,543,233</span><em class="numberInfoSuffix">元</em>
                                <span id="personYearTarget">124,543,233</span><em class="numberInfoSuffix">万元</em>
                            </div>
                        </div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">已完成交易</div>
                            <div class="numberInfoSubTitle">已完成销售任务</div>
                            <div class="numberInfoValue">
                                <span id="personSuccess">124,543,233</span><em class="numberInfoSuffix">元</em>
                                <span id="personSuccess">124,543,233</span><em class="numberInfoSuffix">万元</em>
                            </div>
                        </div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">未完成交易</div>
                            <div class="numberInfoSubTitle">未完成销售任务</div>
                            <div class="numberInfoValue">
                                <span id="personProgress">124,543,233</span><em class="numberInfoSuffix">元</em>
                                <span id="personProgress">124,543,233</span><em class="numberInfoSuffix">万元</em>
                            </div>
                        </div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">交易率</div>
                            <div class="numberInfoSubTitle">完成率</div>
                            <div class="numberInfoValue"><span id="personRate">92</span>%</div>
                        </div>
                    </div>
                    <div class="layui-row" style="margin-top: 40px;">
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">跟踪项目数量</div>
                            <div class="numberInfoValue">
                                <span id="progressCount">124</span><em class="numberInfoSuffix">个</em>
                            </div>
                        </div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">金额</div>
                            <div class="numberInfoValue">
                                <span id="progressMoney">124,543,233</span><em class="numberInfoSuffix">万元</em>
                            </div>
                        </div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">成交项目数量</div>
                            <div class="numberInfoValue">
                                <span id="successCount">121</span><em class="numberInfoSuffix">个</em>
                            </div>
                        </div>
                        <div class="layui-col-xs12 layui-col-sm6 layui-col-lg3 text-center">
                            <div class="numberInfoSubTitle">金额</div>
                            <div class="numberInfoValue">
                                <span id="successMoney">124,543,233</span><em class="numberInfoSuffix">万元</em>
                            </div>
                        </div>
                    </div>
                </div>
@@ -102,7 +128,7 @@
        </div>

        <div class="layui-col-xs12 layui-col-md4">
            <div class="layui-card" style="height: 299px;overflow: hidden;">
            <div class="layui-card" style="height: 403px;overflow: hidden;">
                <div class="layui-card-header">公司公告</div>
                <div class="layui-card-body" id="companyPostId">
                </div>
@@ -252,6 +278,10 @@
                $("#personSuccess").text(res.data.successMoney)
                $("#personProgress").text(res.data.progressMoney)
                $("#personRate").text(res.data.yearTransactionRate)
                $("#progressCount").text(res.data.progressCount)
                $("#successCount").text(res.data.successCount)
                $("#progressMoney").text(res.data.progressMoney)
                $("#successMoney").text(res.data.successMoney)
            }
        });