queryLatAndLong
===
    SELECT a.*,b.latitude,b.longitude,c.order_status FROM xzx_user_info a 
    RIGHT JOIN xzx_user_address_info b ON a.user_id = b.user_id AND b.flag = 1 AND b.del_flag=0
    LEFT JOIN xzx_order_info c ON c.create_user_id = b.user_id 
    WHERE a.del_flag = 0 GROUP BY a.mobile_phone;
    
queryPromoterStatis
===
    SELECT x.orderId, x.relaName,x.createTime,
    x.nickName, x.orderWeightCount, x.orderMoneyCount from (
        SELECT b.order_id as orderId, b.rela_name as relaName,b.create_time as createTime,
        e.receiver_name as nickName, SUM(c.weight) as orderWeightCount, 
        SUM(c.money) as orderMoneyCount FROM xzx_order_info b 
            LEFT JOIN xzx_order_item_info c ON b.order_id=c.order_id 
                LEFT JOIN xzx_order_detail_info e ON e.order_id=b.order_id 
            WHERE b.order_type=1 AND order_status=5 
            @if(!isEmpty(startTime)){
                AND b.create_time BETWEEN #startTime# AND #endTime#
            @}
            AND create_user_id in (
                SELECT user_id FROM xzx_user_info a WHERE a.mobile_phone IN (
                SELECT mobile FROM xzx_user_target_info x
                        WHERE del_flag=0
                        @if(!isEmpty(userId)){
                            AND x.real_user_id=#userId#
                        @}
                     AND regster_type=3 
                )
            ) GROUP BY b.order_id ORDER BY b.create_user_id 
    ) x 
    @if(!isEmpty(orderWeightCount)){
        where x.orderWeightCount >= #orderWeightCount#
    @}
        limit #page#, #limit#


queryPromoterStatisCount
===
    SELECT count(*) from (
        SELECT y.order_id from (
            SELECT b.order_id,SUM(c.weight) as orderWeightCount FROM xzx_order_info b 
            LEFT JOIN xzx_order_item_info c ON b.order_id=c.order_id 
            LEFT JOIN xzx_order_detail_info e ON e.order_id=b.order_id 
            WHERE b.order_type=1 AND order_status=5 
            @if(!isEmpty(startTime)){
                AND b.create_time BETWEEN #startTime# AND #endTime#
            @}
            AND create_user_id in (
                SELECT user_id FROM xzx_user_info a WHERE a.mobile_phone IN (
                SELECT mobile FROM xzx_user_target_info x
                        WHERE del_flag=0
                        @if(!isEmpty(userId)){
                            AND x.real_user_id=#userId#
                        @}
                     AND regster_type=3 
                )
            ) GROUP BY b.order_id ORDER BY b.create_user_id
        ) y 
        @if(!isEmpty(orderWeightCount)){
            where y.orderWeightCount >= #orderWeightCount#
        @}
    ) as x

queryQromoterOrder
===
    SELECT x.orderId, x.relaName,x.createTime,
    x.nickName, x.orderWeightCount, x.orderMoneyCount,x.completeTime from (
        SELECT b.order_id as orderId, b.rela_name as relaName,b.create_time as createTime,
        e.receiver_name as nickName, SUM(c.weight) as orderWeightCount, 
        SUM(c.money) as orderMoneyCount,e.complete_time as completeTime  FROM xzx_order_info b 
            LEFT JOIN xzx_order_item_info c ON b.order_id=c.order_id 
                LEFT JOIN xzx_order_detail_info e ON e.order_id=b.order_id 
            WHERE b.order_type=1 AND order_status in (4,5,7)
            @if(!isEmpty(startTime)){
                AND e.complete_time BETWEEN #startTime# AND #endTime#
            @}
            AND create_user_id in (
                SELECT user_id FROM xzx_user_info a WHERE a.mobile_phone IN (
                SELECT mobile FROM xzx_user_target_info x
                        WHERE del_flag=0
                        @if(!isEmpty(userId)){
                            AND x.real_user_id=#userId#
                        @}
                     AND regster_type=3 
                )
            ) GROUP BY b.order_id 
             @if(!isEmpty(sortType)){
                 ORDER BY b.create_time asc limit #orderNumSort#
             @}
    ) x 
    @if(!isEmpty(orderWeightCount)){
        where x.orderWeightCount >= #orderWeightCount#
    @}
        @if(!isEmpty(sortType)){
           ORDER BY x.createTime desc limit 1
        @} 
        @if(isEmpty(sortType)){
           limit #page#, #limit#    
        @} 
queryQromoterOrderCount
===
    SELECT count(*) from (
        SELECT y.order_id from (
            SELECT b.order_id,SUM(c.weight) as orderWeightCount FROM xzx_order_info b 
            LEFT JOIN xzx_order_item_info c ON b.order_id=c.order_id 
            LEFT JOIN xzx_order_detail_info e ON e.order_id=b.order_id 
            WHERE b.order_type=1 AND order_status in (4,5,7)
               @if(!isEmpty(startTime)){
                   AND e.complete_time BETWEEN #startTime# AND #endTime#
               @}
            AND create_user_id in (
                SELECT user_id FROM xzx_user_info a WHERE a.mobile_phone IN (
                SELECT mobile FROM xzx_user_target_info x
                        WHERE del_flag=0
                        @if(!isEmpty(userId)){
                            AND x.real_user_id=#userId#
                        @}
                     AND regster_type=3 
                )
            ) GROUP BY b.order_id 
                       @if(!isEmpty(sortType)){
                             ORDER BY b.create_time asc limit #orderNumSort#
                       @}
        ) y 
        @if(!isEmpty(orderWeightCount)){
            where y.orderWeightCount >= #orderWeightCount#
        @}
    ) as x

queryQromoterOrderOne
===
    SELECT x.orderId, x.relaName,x.createTime, x.nickName, x.orderWeightCount, x.orderMoneyCount,x.completeTime ,x.createUserId
    from
          ( SELECT b.order_id as orderId, b.rela_name as relaName,b.create_time as createTime, e.receiver_name as nickName, SUM(c.weight) as orderWeightCount,
              SUM(c.money) as orderMoneyCount,e.complete_time as completeTime,b.create_user_id as createUserId 
             FROM xzx_order_info b 
           LEFT JOIN xzx_order_item_info c ON b.order_id=c.order_id 
           LEFT JOIN xzx_order_detail_info e ON e.order_id=b.order_id 
           WHERE b.order_type=1 AND b.order_status in (4,5,7)
             @if(!isEmpty(startTime)){
                           AND b.create_time >= #startTime# AND #endTime#
             @}
             @if(!isEmpty(endTime)){
                                        AND b.create_time<= #endTime#
                          @}
             AND b.create_user_id in ( SELECT user_id FROM xzx_user_info a 
                                     WHERE a.mobile_phone IN 
                                      ( SELECT mobile FROM xzx_user_target_info x 
                                        WHERE del_flag=0
                                        @if(!isEmpty(userId)){
                                            AND x.real_user_id=#userId#
                                        @}
                                        AND regster_type=3 ) ) 
           GROUP BY b.create_user_id,b.order_id
           ORDER BY b.create_time asc limit 0, 10000) x  
           @if(!isEmpty(orderWeightCount)){
               where x.orderWeightCount >= #orderWeightCount#
           @}
           ORDER BY x.createUserId,x.createTime asc