经验证筛选后的值是对的，初始界面值错的，但是不知道为什么会出现这种情况

代码

select net_weight

    ,updated_on,product_code,product_name,storage,pallet_id

from

   ( SELECT

        m.*,

        @row_number := IF(@current_pallet = pallet_id, @row_number + 1, 1) AS rn,

        @current_pallet := pallet_id

    FROM

        material_warehousing_record m,

        (SELECT @row_number := 0, @current_pallet := NULL) AS vars

    WHERE 1=1

       and  storage  in ("AccessoriesStorage","RubberStorage","SteelCord","CharcoalStorage","TextileStorage")

      ${if(len(结束日期) == 0,"","and m.updated_on BETWEEN '" + format(开始日期,'YYYY-MM-dd') + "' AND '"+format(DATEDELTA(结束日期,1),'YYYY-MM-dd')+"'")}

 ${if(len(库房) == 0,"","and m.storage in ('" + 库房 + "')")}

 ${if(len(物料名称) == 0,"","and m.product_name like '%" + 物料名称 + "%'")}

 ${if(len(物料规格) == 0,"","and m.product_spec like '%" + 物料规格 + "%'")}

 ${if(len(物料编码) == 0,"","and m.product_code like '%" + 物料编码 + "%'")}

    ORDER BY

        pallet_id, updated_on DESC) a

        where 1=1

        and rn=1

              ${if(len(结束日期) == 0,"","and a.updated_on BETWEEN '" + format(开始日期,'YYYY-MM-dd') + "' AND '"+format(DATEDELTA(结束日期,1),'YYYY-MM-dd')+"'")}

 ${if(len(库房) == 0,"","and a.storage in ('" + 库房 + "')")}

 ${if(len(物料名称) == 0,"","and a.product_name like '%" + 物料名称 + "%'")}

 ${if(len(物料规格) == 0,"","and a.product_spec like '%" + 物料规格 + "%'")}

 ${if(len(物料编码) == 0,"","and a.product_code like '%" + 物料编码 + "%'")}