| | |
| | | and sr.product_sn like concat("%", #{productSn} ,"%") |
| | | </if> |
| | | UNION ALL |
| | | SELECT |
| | | (SELECT |
| | | sr.*, |
| | | ss.meta_value AS product_home_name, |
| | | ss.order_index, |
| | |
| | | supplier.NAME AS supplierName, |
| | | f.id favor, |
| | | f.create_time favortime, |
| | | supplier.valid_flag as supplierFlag |
| | | supplier.valid_flag as supplierFlag |
| | | FROM |
| | | sys_reagent AS sr |
| | | LEFT JOIN base_meta AS ss ON sr.product_home = ss.id |
| | |
| | | <if test="MaxSize != null"> |
| | | limit #{MaxSize} |
| | | </if> |
| | | ) |
| | | ) as reagent |
| | | ORDER BY reagent.favortime DESC,length(reagent.name),reagent.order_index,price asc |
| | | <if test="first != null and pageSize != null"> |