云众医疗 商品页增加查询条件

KKSU

2024-09-04 5ceebb66f0111c067276578d62943f3b1b07be68

云众医疗 商品页增加查询条件

 src/main/resources/mapper/modules/MallGoodsMapper.xml

@@ -194,6 +194,9 @@
                <if test="record.goodsType != null and record.goodsType != ''">
                    and a.goods_type=#{record.goodsType}
                </if>
                <if test="record.categoryId != null and record.categoryId != ''">
                    and a.category_id=#{record.categoryId}
                </if>
            </if>
        </where>
        group by a.id

 src/main/resources/templates/febs/views/modules/goods/goodsList.html

@@ -13,6 +13,18 @@
                                            <input type="text" placeholder="商品名称" name="goodsName" autocomplete="off" class="layui-input">
                                        </div>
                                    </div>
                                    <div class="layui-inline">
                                        <label class="layui-form-label layui-form-label-sm">分类</label>
                                        <div class="layui-input-inline">
                                            <select name="goodsCategory">
                                                <option value="">请选择</option>
                                                <option value="21">诊所耗材</option>
                                                <option value="22">诊所器械</option>
                                                <option value="23">全部耗材</option>
                                                <option value="24">全部器械</option>
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                            <div class="layui-col-md2 layui-col-sm12 layui-col-xs12 table-action-area">
@@ -283,6 +295,7 @@
        function getQueryParams() {
            return {
                goodsName: $searchForm.find('input[name="goodsName"]').val().trim(),
                categoryId: $searchForm.find("select[name='categoryId']").val(),
            };
        }