经排查,问题点1:
$$LIKE必须大写,小写会失效

<el-form-item label="请验单编号:" label-width="100px">
   <el-input v-model="searchForm.inspection_request_no$$LIKE" placeholder="请验单编号" />
</el-form-item>

问题点2:
include标签不能去掉
a:WhereSql
b:OrderSql

<select id="findPage" resultType="glory.mes.model.InspectionReport">
      SELECT * FROM (
      SELECT
      rank,
      a.id,
      a.inspection_request_no,
      a.inspection_report_no,
      a.inspection_lot_number,
      a.inspection_contents,
      a.inspection_type,
      a.inspection_person,
      a.is_qualified,
      a.inspection_state,
      a1.material_description_cn inspection_material_number,
      a.create_by,
      a.create_time,
      a.update_by,
      a.update_time
      FROM
      (
      SELECT
      @rownum := @rownum + 1 AS rank,
      inspection_report.*
      FROM
      ( SELECT @rownum := 0 ) id,
      inspection_report
      ORDER BY
      create_time
      ) a
      LEFT JOIN material a1 ON a.inspection_material_number = a1.id
      ) a
      <include refid="glory.mes.repository.RmdbRepository.findPageWhereSql"/>
      <include refid="glory.mes.repository.RmdbRepository.findPageOrderSql"/>
  </select>

问题点3:
inner join内连接不能和模糊查询公用,会导致失效,建议用left join