Merge branch 'local_20221104' into huacheng_test
| | |
| | | storeName,c.name,c.store_id,c.goods_pic,c.images,c.status,c.sale,c.original_price,c.price,c.unit,c.order,c.stock,c.details,c.remark,c.goods_describe,c.delivery_type,c.delete_status,c.create_at,c.update_at |
| | | from com_shop_flower_goods c |
| | | left join com_convenient_merchants ccm on c.store_id=ccm.id |
| | | where c.delete_status = 1 and ccm.id_del = 0 |
| | | where c.delete_status = 1 and ccm.is_del = 0 |
| | | <if test='pageComShopFlowerGoodsDTO.storeName != null and pageComShopFlowerGoodsDTO.storeName.trim() != ""'> |
| | | and ccm.name like concat('%',#{pageComShopFlowerGoodsDTO.storeName},'%') |
| | | </if> |