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