queryComplaintList

    SELECT a.id as complain_id, a.complaint_reason, a.create_time as create_timex, a.del_flag as del_flagx,
    a.after_sale_flag, a.complain_img, a.complaint_plan, a.complaint_type, b.*, c.nick_name as nick_namex, c.mobile_phone as receiver_phone
    , d.money, xyz.create_user_phone, e.config_value_name FROM xzx_order_complaint a
    LEFT JOIN xzx_order_info b ON a.order_id = b.order_id
    LEFT JOIN xzx_user_other_info c ON b.receiver=c.user_id
    LEFT JOIN xzx_order_detail_info d ON a.order_id=d.order_id
    LEFT JOIN xzx_sys_config_info e ON e.config_value=a.complaint_type AND e.config_type_code='COMPLAINT_TYPE'
    LEFT JOIN (
        SELECT z.mobile_phone AS create_user_phone, x.order_id FROM xzx_order_complaint x
        LEFT JOIN xzx_order_info y ON x.order_id=y.order_id
        LEFT JOIN xzx_user_info z ON z.user_id = y.create_user_id
        GROUP BY x.order_id
    ) as xyz ON a.order_id  = xyz.order_id
    WHERE a.del_flag=0
    @if(isNotEmpty(afterSaleFlags)){
            AND after_sale_flag in (
                @for(id in afterSaleFlags){
                #id#  #text(idLP.last?"":"," )#
                @}
            )
    @}
    @if(isNotEmpty(startTime)){
            AND a.create_time BETWEEN #startTime# AND #endTime#
    @}
    limit #page#, #limit#

queryComplaintListCount

SELECT count(*) FROM xzx_order_complaint a
LEFT JOIN xzx_order_info b ON a.order_id = b.order_id
LEFT JOIN xzx_user_info c ON b.receiver=c.user_id
LEFT JOIN xzx_order_detail_info d ON a.order_id=d.order_id
LEFT JOIN xzx_sys_config_info e ON e.config_value=a.complaint_type AND e.config_type_code='COMPLAINT_TYPE'
LEFT JOIN (
    SELECT z.mobile_phone AS create_user_phone, x.order_id FROM xzx_order_complaint x
    LEFT JOIN xzx_order_info y ON x.order_id=y.order_id
    LEFT JOIN xzx_user_info z ON z.user_id = y.create_user_id
    GROUP BY x.order_id
) as xyz ON a.order_id  = xyz.order_id
WHERE a.del_flag=0
@if(isNotEmpty(afterSaleFlags)){
        AND after_sale_flag in(
            @for(id in afterSaleFlags){
                #id#  #text(idLP.last?"":"," )#
            @}
        )
@}
@if(isNotEmpty(startTime)){
        AND a.create_time BETWEEN #startTime# AND #endTime#
@}

updateComplaintFlag

update xzx_order_complaint set
after_sale_flag=#afterSaleFlag#,
complaint_plan=#complaintPlan# where id=#id#