queryByCondition

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

batchDelXzxOrderAppraiseInfoByIds

• 批量逻辑删除

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

queryAppraiseInfoList

select a.create_time as time,b.name as receiverName,b.mobile_phone as receiverPhone,
a.star,a.tag_codes,c.nick_name as userName,c.mobile_phone as userPhone, 
a.anonymous_flag,a.order_id,a.content,a.resource_ids,d.create_time as createTime,d.reserve_time as reserveTime,
e.receive_time as receiveTime,d.order_status as orderStatus,d.address_area as addressArea,d.address as address,e.remark
from xzx_order_appraise_info a
LEFT JOIN xzx_order_info d ON a.order_id=d.order_id
LEFT JOIN xzx_order_detail_info e ON a.order_id=e.order_id
LEFT JOIN xzx_user_other_info b on a.receiver_id=b.user_id and b.user_type=2
LEFT JOIN xzx_user_info c on a.create_user_id = c.user_id and (c.user_type=1 or c.user_type is null)   
where a.del_flag=0 and b.del_flag=0
@if(!isEmpty(name)){
        AND b.name like #"%"+name+"%"# or b.mobile_phone like #"%"+name+"%"# 
@} 
@if(!isEmpty(partnerIds)){
            AND b.partner_id in ( #join(partnerIds)# )
    @}      
limit #page#, #limit# 

queryAppraiseInfoCount

select count(k.id) from (
        select a.id as id
            from xzx_order_appraise_info a
            LEFT JOIN xzx_user_other_info b on a.receiver_id=b.user_id and b.user_type=2
            LEFT JOIN xzx_user_info c on a.create_user_id = c.user_id and (c.user_type=1 or c.user_type is null)   
            where a.del_flag=0 and b.del_flag=0
            @if(!isEmpty(name)){
                    AND b.name like #"%"+name+"%"# or b.mobile_phone like #"%"+name+"%"# 
            @} 
            @if(!isEmpty(partnerIds)){
                            AND b.partner_id in ( #join(partnerIds)# )
                    @}    
        )k

queryConfigByAppraseInfo

select config_type_name 
from xzx_sys_config_info 
where config_group=#value#
group by config_type_name

queryConfigByTagCode

select config_value 
from xzx_sys_config_info 
where config_type_code in (#join(codes)#)

queryConfigByTagCodeOne

select config_value 
from xzx_sys_config_info 
where config_type_code =#typeCode#

queryResourceUrls

select resource_url from xzx_sys_resource_info where id in (#join(resArr)#)   

queryReceiverTotalList

select count(id) as num,AVG(star) as star,b.name as name
from xzx_order_appraise_info a
left join xzx_user_other_info b on a.receiver_id=b.user_id and b.user_type=2 
where 1=1 and b.del_flag=0
@if(!isEmpty(name)){
    AND b.name like #"%"+name+"%"# or b.mobile_phone like #"%"+name+"%"# 
@} 
@if(!isEmpty(partnerIds)){
        AND b.partner_id in ( #join(partnerIds)# )
    @} 
group by receiver_id 

queryStarTotalNum

select count(a.id) as num,a.star as star 
from xzx_order_appraise_info a
left join(
       select m.partner_id,n.order_id from xzx_user_other_info m
       LEFT JOIN xzx_order_info n on n.receiver=m.user_id
    )j on a.order_id = j.order_id
where 1=1    
  @if(!isEmpty(partnerIds)){
             AND j.partner_id in ( #join(partnerIds)# )
         @}    
group by a.star

getModelCodeList

select tag_codes as codes from xzx_order_appraise_info where star=#star#