queryByCondition
===


    select 
    @pageTag(){
    t.*
    @}
    from xzx_order_complaint t
    where 1=1  
    @//数据权限，该sql语句功能点,如果不考虑数据权限，可以删除此行  
    and #function("xzxOrderComplaint.query")#
    
    
    

batchDelXzxOrderComplaintByIds
===

* 批量逻辑删除

    update xzx_order_complaint set del_flag = 1 where id  in( #join(ids)#)

queryComplaintApiList
===
    SELECT a.id as id, b.order_id as orderId,b.create_time as createTime,a.after_sale_flag as afterSaleFlag,
            xyz.nick_name as nickName,xyz.create_user_phone as userPhone,
            xyz.name as collectorName,xyz.mobile_phone as collectorPhone,a.complaint_reason as complaintReason,
            e.config_value_name as complaintValue,a.complaint_plan as complaintPlan ,b.town_id,xyz.town_id as xTownId
     FROM xzx_order_complaint a
        LEFT JOIN xzx_order_info b ON a.order_id = b.order_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,z.nick_name,c.name,c.mobile_phone,y.town_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
          LEFT JOIN xzx_user_other_info c ON y.receiver=c.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#
        @}
        @if(isNotEmpty(orderId)){
                AND b.order_id like #"%"+orderId+"%"#
        @}
        @if(isNotEmpty(userPhone)){
                AND xyz.create_user_phone like #"%"+userPhone+"%"#
        @}
        @if(isNotEmpty(collectorName)){
                AND xyz.name like #"%"+collectorName+"%"#
        @}
        @if(isNotEmpty(collectorPhone)){
                AND xyz.mobile_phone like #"%"+collectorPhone+"%"#
        @} 
        @if(isNotEmpty(partnerIds)){
                AND b.town_id in (select p.fence_id from xzx_partner_fence p where p.del_flag=0 and p.partner_id in ( #join(partnerIds)# ) ) 
         @} 
         order by  b.create_time desc       
        limit #page#, #limit#

queryComplaintApiCount
===
    SELECT count(a.id) 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,z.nick_name,c.name,c.mobile_phone 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 
                    LEFT JOIN xzx_user_other_info c ON y.receiver=c.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#
        @}
        @if(isNotEmpty(orderId)){
                        AND b.order_id like #"%"+orderId+"%"#
                @}
                @if(isNotEmpty(userPhone)){
                        AND xyz.create_user_phone like #"%"+userPhone+"%"#
                @}
                @if(isNotEmpty(collectorName)){
                        AND xyz.name like #"%"+collectorName+"%"#
                @}
                @if(isNotEmpty(collectorPhone)){
                        AND xyz.mobile_phone like #"%"+collectorPhone+"%"#
                @}            
            @if(isNotEmpty(partnerIds)){
                    AND b.town_id in (select p.fence_id from xzx_partner_fence p where del_flag=0 and p.partner_id in ( #join(partnerIds)# ) ) 
             @}  
updateComplaintFlagApi
===
    update xzx_order_complaint set
    after_sale_flag=#afterSaleFlag#,
    complaint_plan=#complaintPlan# where id=#id#
    
queryChildPids
===
    select  partner_id from xzx_partner_gaode where del_flag=0 and partner_id<>partner_key and city_id is null