Merge branch 'score-shop' of http://120.27.238.55:7000/r/xzx into score-shop

Helius

2021-07-16 5e733773930587131c441ba545f70bf6d77c3051

Merge branch 'score-shop' of http://120.27.238.55:7000/r/xzx into score-shop

 gc-user/src/main/java/com/xzx/gc/user/controller/AdminDistribController.java

@@ -214,7 +214,7 @@
        return JsonResult.success(distribService.distribDataList(distribDataListDto));
    }

    @ApiOperation(value = "团长数据--列表导出")
    @ApiOperation(value = "团长数据--列表导出",produces = MediaType.APPLICATION_OCTET_STREAM_VALUE)
    @PostMapping(value = Constants.ADMIN_VIEW_PREFIX + "/distrib/distribDataExport.json")
    public void distribDataExport(@RequestBody ExportDistribDataListDto distribDataListDto, HttpServletRequest request, HttpServletResponse response) {
        List<List<String>> rows = new ArrayList<>();

 gc-user/src/main/java/com/xzx/gc/user/mapper/AccountMapper.java

@@ -65,12 +65,16 @@

    List<DistribDataListVo> distribDataList(@Param("record")DistribDataListDto distribDataListDto);

    String selectOrderByHeadUserId(@Param("accountId")String accountId);
    String selectOrderByHeadUserId(@Param("accountId")String accountId,@Param("record")DistribDataListDto distribDataListDto);

    String selectJDSLByHeadUserId(@Param("accountId")String id);
    String selectJDSLByHeadUserId(@Param("accountId")String id,@Param("record")DistribDataListDto distribDataListDto);

    DistribDataInfoVo selectDistribDataInfoVo();

    List<DistribDataListVo> distribDataExport(@Param("record")ExportDistribDataListDto distribDataListDto);

    String selectOrderExportByHeadUserId(@Param("accountId")String id, @Param("record")ExportDistribDataListDto distribDataListDto);

    String selectJDSLExportByHeadUserId(@Param("accountId")String id, @Param("record")ExportDistribDataListDto distribDataListDto);
}


 gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java

@@ -349,9 +349,9 @@
                    String decode = StringUtils.decode(nickname);
                    distribDataListVo.setNickname(decode);
                    String id = distribDataListVo.getId();
                    String kg = accountMapper.selectOrderByHeadUserId(id);
                    String kg = accountMapper.selectOrderByHeadUserId(id,distribDataListDto);
                    distribDataListVo.setKg(kg);
                    String jdsl = accountMapper.selectJDSLByHeadUserId(id);
                    String jdsl = accountMapper.selectJDSLByHeadUserId(id,distribDataListDto);
                    distribDataListVo.setJdsl(jdsl);
                }
            }
@@ -383,9 +383,9 @@
                    String decode = StringUtils.decode(nickname);
                    distribDataListVo.setNickname(decode);
                    String id = distribDataListVo.getId();
                    String kg = accountMapper.selectOrderByHeadUserId(id);
                    String kg = accountMapper.selectOrderExportByHeadUserId(id,distribDataListDto);
                    distribDataListVo.setKg(kg);
                    String jdsl = accountMapper.selectJDSLByHeadUserId(id);
                    String jdsl = accountMapper.selectJDSLExportByHeadUserId(id,distribDataListDto);
                    distribDataListVo.setJdsl(jdsl);
                }
            }

 gc-user/src/main/resources/mapper/user/AccountMapper.xml

@@ -262,6 +262,7 @@
                LEFT JOIN xzx_user_info c on a.user_id = c.user_id
        WHERE
            a.head_user_id = #{userId}
        order by b.CREATED_TIME desc
    </select>


@@ -282,9 +283,33 @@
        b.regist_time registTime,
        a.is_head isHead,
        (select IFNULL(count(1), 0) from xzx_user_head_relate where head_user_id = a.user_id) cnt,
        (select IFNULL(count(1), 0) from xzx_user_head_details where head_user_id = a.user_id) orderCnt,
        (select IFNULL(sum(amount), 0) from xzx_user_head_relate where head_user_id = a.user_id) amount,
        (select IFNULL(sum(score), 0) from xzx_user_head_relate where head_user_id = a.user_id ) score,
        (select IFNULL(count(1), 0) from xzx_user_head_details where head_user_id = a.user_id
            <if test="record.reserveTimeStart != null">
                and CREATED_TIME >= #{record.reserveTimeStart}
            </if>

            <if test="record.reserveTimeEnd != null">
                and CREATED_TIME &lt;= #{record.reserveTimeEnd}
            </if>
        ) orderCnt,
        (select IFNULL(sum(amount), 0) from xzx_user_head_relate where head_user_id = a.user_id
        <if test="record.reserveTimeStart != null">
            and CREATED_TIME >= #{record.reserveTimeStart}
        </if>

        <if test="record.reserveTimeEnd != null">
            and CREATED_TIME &lt;= #{record.reserveTimeEnd}
        </if>
        ) amount,
        (select IFNULL(sum(score), 0) from xzx_user_head_relate where head_user_id = a.user_id
        <if test="record.reserveTimeStart != null">
            and CREATED_TIME >= #{record.reserveTimeStart}
        </if>

        <if test="record.reserveTimeEnd != null">
            and CREATED_TIME &lt;= #{record.reserveTimeEnd}
        </if>
        ) score,
        a.is_prohibit isProhibit
        FROM
        xzx_account_info a
@@ -294,13 +319,6 @@
            and a.is_head = 1
            <if test="record.queryCol != null and record.queryCol != ''">
                and (b.nick_name like concat('%',#{record.name},'%') or b.mobile_phone like concat('%',#{record.phone},'%'))
            </if>
            <if test="record.reserveTimeStart != null">
                and b.regist_time >= #{record.reserveTimeStart}
            </if>

            <if test="record.reserveTimeEnd != null">
                and b.regist_time &lt;= #{record.reserveTimeEnd}
            </if>
        </where>
        order by id desc
@@ -313,7 +331,8 @@
            xzx_jhy_order_items a
                 left join xzx_sys_environmental_info b on a.item_type = b.id
        WHERE
            b.item_unit = 'kg' and a.order_id in (
            b.item_unit = 'kg'
        and a.order_id in (
                SELECT
                    id
                FROM
@@ -334,6 +353,15 @@
                                    account_id =  #{accountId}
                            )
                    )
        <if test="record!= null">
            <if test="record.reserveTimeStart != null">
                and CREATED_TIME >= #{record.reserveTimeStart}
            </if>

            <if test="record.reserveTimeEnd != null">
                and CREATED_TIME &lt;= #{record.reserveTimeEnd}
            </if>
        </if>
            )
    </select>

@@ -350,8 +378,7 @@
                    id
                FROM
                    xzx_jhy_order
                WHERE
                        order_no in (
                WHERE order_no in (
                        SELECT
                            order_no
                        FROM
@@ -366,6 +393,16 @@
                                    account_id = #{accountId}
                            )
                    )

        <if test="record!= null">
            <if test="record.reserveTimeStart != null">
                and CREATED_TIME >= #{record.reserveTimeStart}
            </if>

            <if test="record.reserveTimeEnd != null">
                and CREATED_TIME &lt;= #{record.reserveTimeEnd}
            </if>
        </if>
            )
    </select>

@@ -390,9 +427,30 @@
    b.regist_time registTime,
    a.is_head isHead,
    (select IFNULL(count(1), 0) from xzx_user_head_relate where head_user_id = a.user_id) cnt,
    (select IFNULL(count(1), 0) from xzx_user_head_details where head_user_id = a.user_id) orderCnt,
    (select IFNULL(sum(amount), 0) from xzx_user_head_relate where head_user_id = a.user_id) amount,
    (select IFNULL(sum(score), 0) from xzx_user_head_relate where head_user_id = a.user_id ) score,
    (select IFNULL(count(1), 0) from xzx_user_head_details where head_user_id = a.user_id
        <if test="record.reserveTimeStart != null">
            and CREATED_TIME >= #{record.reserveTimeStart}
        </if>

        <if test="record.reserveTimeEnd != null">
            and CREATED_TIME &lt;= #{record.reserveTimeEnd}
        </if>) orderCnt,
    (select IFNULL(sum(amount), 0) from xzx_user_head_relate where head_user_id = a.user_id
        <if test="record.reserveTimeStart != null">
            and CREATED_TIME >= #{record.reserveTimeStart}
        </if>

        <if test="record.reserveTimeEnd != null">
            and CREATED_TIME &lt;= #{record.reserveTimeEnd}
        </if>) amount,
    (select IFNULL(sum(score), 0) from xzx_user_head_relate where head_user_id = a.user_id
        <if test="record.reserveTimeStart != null">
            and CREATED_TIME >= #{record.reserveTimeStart}
        </if>

        <if test="record.reserveTimeEnd != null">
            and CREATED_TIME &lt;= #{record.reserveTimeEnd}
        </if>) score,
    a.is_prohibit isProhibit
    FROM
    xzx_account_info a
@@ -403,15 +461,90 @@
        <if test="record.queryCol != null and record.queryCol != ''">
            and (b.nick_name like concat('%',#{record.name},'%') or b.mobile_phone like concat('%',#{record.phone},'%'))
        </if>
    </where>
    order by id desc
</select>

    <select id="selectOrderExportByHeadUserId" resultType="java.lang.String">
    SELECT
    IFNULL(SUM(a.weight),0) as kg
    FROM
    xzx_jhy_order_items a
    left join xzx_sys_environmental_info b on a.item_type = b.id
    WHERE
    b.item_unit = 'kg'
    and a.order_id in (
    SELECT
    id
    FROM
    xzx_jhy_order
    WHERE
    order_no in (
    SELECT
    order_no
    FROM
    xzx_user_head_details
    WHERE
    head_user_id = (
    SELECT
    user_id
    FROM
    xzx_account_info
    WHERE
    account_id =  #{accountId}
    )
    )
    <if test="record!= null">
        <if test="record.reserveTimeStart != null">
            and b.regist_time >= #{record.reserveTimeStart}
            and CREATED_TIME >= #{record.reserveTimeStart}
        </if>

        <if test="record.reserveTimeEnd != null">
            and b.regist_time &lt;= #{record.reserveTimeEnd}
            and CREATED_TIME &lt;= #{record.reserveTimeEnd}
        </if>
    </where>
    order by id desc
    </if>
    )
</select>

    <select id="selectJDSLExportByHeadUserId" resultType="java.lang.String">
        SELECT
        IFNULL(SUM(a.weight),0) as jdsl
        FROM
        xzx_jhy_order_items a
        left join xzx_sys_environmental_info b on a.item_type = b.id
        WHERE
        b.item_unit = '台' and
        a.order_id in (
        SELECT
        id
        FROM
        xzx_jhy_order
        WHERE order_no in (
        SELECT
        order_no
        FROM
        xzx_user_head_details
        WHERE
        head_user_id = (
        SELECT
        user_id
        FROM
        xzx_account_info
        WHERE
        account_id = #{accountId}
        )
        )

        <if test="record!= null">
            <if test="record.reserveTimeStart != null">
                and CREATED_TIME >= #{record.reserveTimeStart}
            </if>

            <if test="record.reserveTimeEnd != null">
                and CREATED_TIME &lt;= #{record.reserveTimeEnd}
            </if>
        </if>
        )
</select>

</mapper>