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#