package com.ruoyi.web.controller.pill; import com.ruoyi.common.annotation.Log; import…
- User
package com.ruoyi.web.controller.pill;
import com.ruoyi.common.annotation.Log; import com.ruoyi.common.core.controller.BaseController; import com.ruoyi.common.core.domain.AjaxResult; import com.ruoyi.common.core.page.TableDataInfo; import com.ruoyi.common.enums.BusinessType; import com.ruoyi.common.utils.poi.ExcelUtil; import com.ruoyi.pill.domain.PillExpiryWarning; import com.ruoyi.pill.service.IPillExpiryWarningService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*;
import javax.servlet.http.HttpServletResponse; import java.util.List;
/**
-
药品有效期预警,用于监控药品保质期Controller
-
@author wuweiqiang
-
@date 2025-05-20 */ @RestController @RequestMapping("/pill/warning") public class PillExpiryWarningController extends BaseController { @Autowired private IPillExpiryWarningService pillExpiryWarningService;
@PreAuthorize("@ss.hasPermi('pill:warning:list')") @GetMapping("/list") public TableDataInfo list(PillExpiryWarning pillExpiryWarning) { startPage(); // 确保onlyExpire会映射到实体,并传给service和mapper List list = pillExpiryWarningService.selectPillExpiryWarningList(pillExpiryWarning); return getDataTable(list); }
@PreAuthorize("@ss.hasPermi('pill:warning:export')") @Log(title = "药品有效期预警,用于监控药品保质期", businessType = BusinessType.EXPORT) @PostMapping("/export") public void export(HttpServletResponse response, PillExpiryWarning pillExpiryWarning) { List list = pillExpiryWarningService.selectPillExpiryWarningList(pillExpiryWarning); ExcelUtil util = new ExcelUtil(PillExpiryWarning.class); util.exportExcel(response, list, "药品有效期预警,用于监控药品保质期数据"); }
/**
- 获取药品有效期预警,用于监控药品保质期详细信息 */ @PreAuthorize("@ss.hasPermi('pill:warning:query')") @GetMapping(value = "/{warningId}") public AjaxResult getInfo(@PathVariable("warningId") Long warningId) { return success(pillExpiryWarningService.selectPillExpiryWarningByWarningId(warningId)); }
/**
- 新增药品有效期预警,用于监控药品保质期 */ @PreAuthorize("@ss.hasPermi('pill:warning:add')") @Log(title = "药品有效期预警,用于监控药品保质期", businessType = BusinessType.INSERT) @PostMapping public AjaxResult add(@RequestBody PillExpiryWarning pillExpiryWarning) { return toAjax(pillExpiryWarningService.insertPillExpiryWarning(pillExpiryWarning)); }
/**
- 修改药品有效期预警,用于监控药品保质期 */ @PreAuthorize("@ss.hasPermi('pill:warning:edit')") @Log(title = "药品有效期预警,用于监控药品保质期", businessType = BusinessType.UPDATE) @PutMapping public AjaxResult edit(@RequestBody PillExpiryWarning pillExpiryWarning) { return toAjax(pillExpiryWarningService.updatePillExpiryWarning(pillExpiryWarning)); }
/**
- 删除药品有效期预警,用于监控药品保质期 */ @PreAuthorize("@ss.hasPermi('pill:warning:remove')") @Log(title = "药品有效期预警,用于监控药品保质期", businessType = BusinessType.DELETE) @DeleteMapping("/{warningIds}") public AjaxResult remove(@PathVariable Long[] warningIds) { return toAjax(pillExpiryWarningService.deletePillExpiryWarningByWarningIds(warningIds)); } }
package com.ruoyi.pill.domain;
import java.util.Date; import com.fasterxml.jackson.annotation.JsonFormat; import org.apache.commons.lang3.builder.ToStringBuilder; import org.apache.commons.lang3.builder.ToStringStyle; import com.ruoyi.common.annotation.Excel; import com.ruoyi.common.core.domain.BaseEntity;
/**
-
药品有效期预警,用于监控药品保质期对象 pill_expiry_warning
-
@author wuweiqiang
-
@date 2025-05-20 */ public class PillExpiryWarning extends BaseEntity { private static final long serialVersionUID = 1L;
/** 是否只查询15天内过期 */ private Boolean onlyExpire;
public Boolean getOnlyExpire() { return onlyExpire; }
public void setOnlyExpire(Boolean onlyExpire) { this.onlyExpire = onlyExpire; }
/** 主键ID */ private Long warningId;
/** 药品ID(关联pill_drug.drug_id) */ @Excel(name = "药品ID", readConverterExp = "关=联pill_drug.drug_id") private Long drugId;
/** 厂家ID(关联pill_factory.factory_id) */ @Excel(name = "厂家ID", readConverterExp = "关=联pill_factory.factory_id") private Long factoryId;
/** 药品生产日期 */ @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "药品生产日期", width = 30, dateFormat = "yyyy-MM-dd") private Date productionDate;
/** 保质期(天) */ @Excel(name = "保质期", readConverterExp = "天=") private Long validityPeriod;
/** 进货单ID(关联pill_purchase.purchase_id) */ @Excel(name = "进货单ID", readConverterExp = "关=联pill_purchase.purchase_id") private Long purchaseId;
/** 库存数量 */ @Excel(name = "库存数量") private Long stock;
/** 药品名称(来自pill_drug) */ @Excel(name = "药品名称") private String drugName;
/** 厂家名称(来自pill_factory) */ @Excel(name = "生产厂家") private String factoryName;
/** 进货时间(来自pill_purchase) */ @JsonFormat(pattern = "yyyy-MM-dd") @Excel(name = "进货时间", width = 30, dateFormat = "yyyy-MM-dd") private Date purchaseTime;
/** 距离过期天数 */ @Excel(name = "距离过期天数") private Long daysToExpire;
public void setWarningId(Long warningId) { this.warningId = warningId; }
public Long getWarningId() { return warningId; }
public void setDrugId(Long drugId) { this.drugId = drugId; }
public Long getDrugId() { return drugId; }
public void setFactoryId(Long factoryId) { this.factoryId = factoryId; }
public Long getFactoryId() { return factoryId; }
public void setProductionDate(Date productionDate) { this.productionDate = productionDate; }
public Date getProductionDate() { return productionDate; }
public void setValidityPeriod(Long validityPeriod) { this.validityPeriod = validityPeriod; }
public Long getValidityPeriod() { return validityPeriod; }
public void setPurchaseId(Long purchaseId) { this.purchaseId = purchaseId; }
public Long getPurchaseId() { return purchaseId; }
public void setStock(Long stock) { this.stock = stock; }
public Long getStock() { return stock; }
public String getDrugName() { return drugName; }
public void setDrugName(String drugName) { this.drugName = drugName; }
public String getFactoryName() { return factoryName; }
public void setFactoryName(String factoryName) { this.factoryName = factoryName; }
public Date getPurchaseTime() { return purchaseTime; }
public void setPurchaseTime(Date purchaseTime) { this.purchaseTime = purchaseTime; }
public Long getDaysToExpire() { return daysToExpire; }
public void setDaysToExpire(Long daysToExpire) { this.daysToExpire = daysToExpire; }
@Override public String toString() { return new ToStringBuilder(this,ToStringStyle.MULTI_LINE_STYLE) .append("warningId", getWarningId()) .append("drugId", getDrugId()) .append("factoryId", getFactoryId()) .append("productionDate", getProductionDate()) .append("validityPeriod", getValidityPeriod()) .append("purchaseId", getPurchaseId()) .append("stock", getStock()) .append("drugName", getDrugName()) .append("factoryName", getFactoryName()) .append("purchaseTime", getPurchaseTime()) .append("daysToExpire", getDaysToExpire()) .append("createTime", getCreateTime()) .toString(); } }
package com.ruoyi.pill.mapper;
import java.util.List; import com.ruoyi.pill.domain.PillExpiryWarning;
/**
-
药品有效期预警,用于监控药品保质期Mapper接口
-
@author wuweiqiang
-
@date 2025-05-20 / public interface PillExpiryWarningMapper { /*
- 查询药品有效期预警,用于监控药品保质期
- @param warningId 药品有效期预警,用于监控药品保质期主键
- @return 药品有效期预警,用于监控药品保质期 */ public PillExpiryWarning selectPillExpiryWarningByWarningId(Long warningId);
/**
- 查询药品有效期预警,用于监控药品保质期列表
- @param pillExpiryWarning 药品有效期预警,用于监控药品保质期
- @return 药品有效期预警,用于监控药品保质期集合 */ public List selectPillExpiryWarningList(PillExpiryWarning pillExpiryWarning);
/**
- 新增药品有效期预警,用于监控药品保质期
- @param pillExpiryWarning 药品有效期预警,用于监控药品保质期
- @return 结果 */ public int insertPillExpiryWarning(PillExpiryWarning pillExpiryWarning);
/**
- 修改药品有效期预警,用于监控药品保质期
- @param pillExpiryWarning 药品有效期预警,用于监控药品保质期
- @return 结果 */ public int updatePillExpiryWarning(PillExpiryWarning pillExpiryWarning);
/**
- 删除药品有效期预警,用于监控药品保质期
- @param warningId 药品有效期预警,用于监控药品保质期主键
- @return 结果 */ public int deletePillExpiryWarningByWarningId(Long warningId);
/**
- 批量删除药品有效期预警,用于监控药品保质期
- @param warningIds 需要删除的数据主键集合
- @return 结果 */ public int deletePillExpiryWarningByWarningIds(Long[] warningIds); }
package com.ruoyi.pill.service.impl;
import java.util.List; import com.ruoyi.common.utils.DateUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.ruoyi.pill.mapper.PillExpiryWarningMapper; import com.ruoyi.pill.domain.PillExpiryWarning; import com.ruoyi.pill.service.IPillExpiryWarningService;
/**
-
药品有效期预警,用于监控药品保质期Service业务层处理
-
@author wuweiqiang
-
@date 2025-05-20 */ @Service public class PillExpiryWarningServiceImpl implements IPillExpiryWarningService { @Autowired private PillExpiryWarningMapper pillExpiryWarningMapper;
/**
- 查询药品有效期预警,用于监控药品保质期
- @param warningId 药品有效期预警,用于监控药品保质期主键
- @return 药品有效期预警,用于监控药品保质期 */ @Override public PillExpiryWarning selectPillExpiryWarningByWarningId(Long warningId) { return pillExpiryWarningMapper.selectPillExpiryWarningByWarningId(warningId); }
/**
- 查询药品有效期预警,用于监控药品保质期列表
- @param pillExpiryWarning 药品有效期预警,用于监控药品保质期
- @return 药品有效期预警,用于监控药品保质期 */ @Override public List selectPillExpiryWarningList(PillExpiryWarning pillExpiryWarning) { return pillExpiryWarningMapper.selectPillExpiryWarningList(pillExpiryWarning); }
/**
- 新增药品有效期预警,用于监控药品保质期
- @param pillExpiryWarning 药品有效期预警,用于监控药品保质期
- @return 结果 */ @Override public int insertPillExpiryWarning(PillExpiryWarning pillExpiryWarning) { pillExpiryWarning.setCreateTime(DateUtils.getNowDate()); return pillExpiryWarningMapper.insertPillExpiryWarning(pillExpiryWarning); }
/**
- 修改药品有效期预警,用于监控药品保质期
- @param pillExpiryWarning 药品有效期预警,用于监控药品保质期
- @return 结果 */ @Override public int updatePillExpiryWarning(PillExpiryWarning pillExpiryWarning) { return pillExpiryWarningMapper.updatePillExpiryWarning(pillExpiryWarning); }
/**
- 批量删除药品有效期预警,用于监控药品保质期
- @param warningIds 需要删除的药品有效期预警,用于监控药品保质期主键
- @return 结果 */ @Override public int deletePillExpiryWarningByWarningIds(Long[] warningIds) { return pillExpiryWarningMapper.deletePillExpiryWarningByWarningIds(warningIds); }
/**
- 删除药品有效期预警,用于监控药品保质期信息
- @param warningId 药品有效期预警,用于监控药品保质期主键
- @return 结果 */ @Override public int deletePillExpiryWarningByWarningId(Long warningId) { return pillExpiryWarningMapper.deletePillExpiryWarningByWarningId(warningId); } }
package com.ruoyi.pill.service;
import java.util.List; import com.ruoyi.pill.domain.PillExpiryWarning;
/**
-
药品有效期预警,用于监控药品保质期Service接口
-
@author wuweiqiang
-
@date 2025-05-20 / public interface IPillExpiryWarningService { /*
- 查询药品有效期预警,用于监控药品保质期
- @param warningId 药品有效期预警,用于监控药品保质期主键
- @return 药品有效期预警,用于监控药品保质期 */ public PillExpiryWarning selectPillExpiryWarningByWarningId(Long warningId);
/**
- 查询药品有效期预警,用于监控药品保质期列表
- @param pillExpiryWarning 药品有效期预警,用于监控药品保质期
- @return 药品有效期预警,用于监控药品保质期集合 */ public List selectPillExpiryWarningList(PillExpiryWarning pillExpiryWarning);
/**
- 新增药品有效期预警,用于监控药品保质期
- @param pillExpiryWarning 药品有效期预警,用于监控药品保质期
- @return 结果 */ public int insertPillExpiryWarning(PillExpiryWarning pillExpiryWarning);
/**
- 修改药品有效期预警,用于监控药品保质期
- @param pillExpiryWarning 药品有效期预警,用于监控药品保质期
- @return 结果 */ public int updatePillExpiryWarning(PillExpiryWarning pillExpiryWarning);
/**
- 批量删除药品有效期预警,用于监控药品保质期
- @param warningIds 需要删除的药品有效期预警,用于监控药品保质期主键集合
- @return 结果 */ public int deletePillExpiryWarningByWarningIds(Long[] warningIds);
/**
- 删除药品有效期预警,用于监控药品保质期信息
- @param warningId 药品有效期预警,用于监控药品保质期主键
- @return 结果 */ public int deletePillExpiryWarningByWarningId(Long warningId); }
<resultMap id="PillExpiryWarningResult" type="com.ruoyi.pill.domain.PillExpiryWarning"> <result property="warningId" column="warning_id" /> <result property="drugId" column="drug_id" /> <result property="factoryId" column="factory_id" /> <result property="productionDate" column="production_date" /> <result property="validityPeriod" column="validity_period" /> <result property="purchaseId" column="purchase_id" /> <result property="stock" column="stock" /> <result property="createTime" column="create_time" /> <result property="drugName" column="drug_name"/> <result property="factoryName" column="factory_name"/> <result property="purchaseTime" column="purchase_time"/> <result property="daysToExpire" column="days_to_expire"/> </resultMap> <sql id="BaseSelectSql"> select pe.warning_id, pe.drug_id, pe.factory_id, pe.production_date, pe.validity_period, pe.purchase_id, pd.num as stock, pe.create_time, pd.drug_name, pf.factory_name, pp.purchase_time, datediff(date_add(pe.production_date, interval pe.validity_period day), curdate()) as days_to_expire from pill_expiry_warning pe LEFT JOIN pill_drug pd ON pe.drug_id = pd.drug_id LEFT JOIN pill_factory pf ON pe.factory_id = pf.factory_id LEFT JOIN pill_purchase pp ON pe.purchase_id = pp.purchase_id </sql> <select id="selectPillExpiryWarningList" parameterType="com.ruoyi.pill.domain.PillExpiryWarning" resultMap="PillExpiryWarningResult"> <include refid="BaseSelectSql"/> <where> <if test="drugId != null"> and pe.drug_id = #{drugId}</if> <if test="factoryId != null"> and pe.factory_id = #{factoryId}</if> <if test="productionDate != null"> and pe.production_date = #{productionDate}</if> <if test="validityPeriod != null"> and pe.validity_period = #{validityPeriod}</if> <if test="purchaseId != null"> and pe.purchase_id = #{purchaseId}</if> <!-- 只有在onlyExpire为true时才增加过期数据过滤 --> <if test="onlyExpire != null and onlyExpire == true"> AND datediff(date_add(pe.production_date, interval pe.validity_period day), curdate()) <= 15 </if> </where> </select> <select id="selectPillExpiryWarningByWarningId" parameterType="Long" resultMap="PillExpiryWarningResult"> <include refid="BaseSelectSql"/> where pe.warning_id = #{warningId} </select> <insert id="insertPillExpiryWarning" parameterType="com.ruoyi.pill.domain.PillExpiryWarning" useGeneratedKeys="true" keyProperty="warningId"> insert into pill_expiry_warning <trim prefix="(" suffix=")" suffixOverrides=","> <if test="drugId != null">drug_id,</if> <if test="factoryId != null">factory_id,</if> <if test="productionDate != null">production_date,</if> <if test="validityPeriod != null">validity_period,</if> <if test="purchaseId != null">purchase_id,</if> <if test="stock != null">stock,</if> <if test="createTime != null">create_time,</if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="drugId != null">#{drugId},</if> <if test="factoryId != null">#{factoryId},</if> <if test="productionDate != null">#{productionDate},</if> <if test="validityPeriod != null">#{validityPeriod},</if> <if test="purchaseId != null">#{purchaseId},</if> <if test="stock != null">#{stock},</if> <if test="createTime != null">#{createTime},</if> </trim> </insert> <update id="updatePillExpiryWarning" parameterType="com.ruoyi.pill.domain.PillExpiryWarning"> update pill_expiry_warning <set> <if test="drugId != null">drug_id = #{drugId},</if> <if test="factoryId != null">factory_id = #{factoryId},</if> <if test="productionDate != null">production_date = #{productionDate},</if> <if test="validityPeriod != null">validity_period = #{validityPeriod},</if> <if test="purchaseId != null">purchase_id = #{purchaseId},</if> <if test="stock != null">stock = #{stock},</if> <if test="createTime != null">create_time = #{createTime},</if> </set> where warning_id = #{warningId} </update> <delete id="deletePillExpiryWarningByWarningId" parameterType="Long"> delete from pill_expiry_warning where warning_id = #{warningId} </delete> <delete id="deletePillExpiryWarningByWarningIds" parameterType="Long[]"> delete from pill_expiry_warning where warning_id in <foreach item="warningId" collection="array" open="(" separator="," close=")"> #{warningId} </foreach> </delete>现在要两独立业务模块写接口(pill/drug和pill/factory)。 分别单独做“药品列表”和“厂家列表”接口,前端调用以做下拉框数据绑定。
<el-form-item> <el-button type="primary" icon="el-icon-search" size="mini" @click="handleQuery">搜索</el-button> <el-button icon="el-icon-refresh" size="mini" @click="resetQuery">重置</el-button> <el-button type="warning" size="mini" :plain="!queryParams.onlyExpire" @click="toggleOnlyExpire"> {{ queryParams.onlyExpire ? '查看全部' : '查看过期' }} </el-button> </el-form-item> </el-form> <!-- 操作按钮 --> <el-row :gutter="10" class="mb8"> <el-col :span="1.5"> <el-button type="primary" plain icon="el-icon-plus" size="mini" @click="handleAdd" v-hasPermi="['pill:warning:add']">新增</el-button> </el-col> <el-col :span="1.5"> <el-button type="success" plain icon="el-icon-edit" size="mini" :disabled="single" @click="handleUpdate" v-hasPermi="['pill:warning:edit']">修改</el-button> </el-col> <el-col :span="1.5"> <el-button type="danger" plain icon="el-icon-delete" size="mini" :disabled="multiple" @click="handleDelete" v-hasPermi="['pill:warning:remove']">删除</el-button> </el-col> <el-col :span="1.5"> <el-button type="warning" plain icon="el-icon-download" size="mini" @click="handleExport" v-hasPermi="['pill:warning:export']">导出</el-button> </el-col> <right-toolbar :showSearch.sync="showSearch" @queryTable="getList"></right-toolbar> </el-row> <!-- 列表 --> <el-table v-loading="loading" :data="warningList" @selection-change="handleSelectionChange" stripe border> <el-table-column type="selection" width="55" align="center"/> <el-table-column label="主键ID" align="center" prop="warningId"/> <el-table-column label="药品ID" align="center" prop="drugId"/> <el-table-column label="药品名称" align="center" prop="drugName"/> <el-table-column label="厂家ID" align="center" prop="factoryId"/> <el-table-column label="厂家名称" align="center" prop="factoryName"/> <el-table-column label="生产日期" align="center" prop="productionDate" width="180"> <template slot-scope="scope"> <span>{{ parseTime(scope.row.productionDate, '{y}-{m}-{d}')}}</span> </template> </el-table-column> <el-table-column label="保质期" align="center" prop="validityPeriod"/> <el-table-column label="进货单ID" align="center" prop="purchaseId"/> <el-table-column label="库存数量" align="center" prop="stock"/> <el-table-column label="剩余天数" align="center" prop="daysToExpire" width="110"> <template slot-scope="scope"> <span :style="{ color: scope.row.daysToExpire <= 15 ? 'red' : 'inherit', fontWeight: scope.row.daysToExpire <= 15 ? 'bold' : 'normal' }"> {{ scope.row.daysToExpire }} </span> </template> </el-table-column> <el-table-column label="操作" align="center" class-name="small-padding fixed-width"> <template slot-scope="scope"> <el-button size="mini" type="text" icon="el-icon-edit" @click="handleUpdate(scope.row)" v-hasPermi="['pill:warning:edit']">修改</el-button> <el-button size="mini" type="text" icon="el-icon-delete" @click="handleDelete(scope.row)" v-hasPermi="['pill:warning:remove']">删除</el-button> </template> </el-table-column> </el-table> <!-- 分页 --> <pagination v-show="total>0" :total="total" :page.sync="queryParams.pageNum" :limit.sync="queryParams.pageSize" @pagination="getList" /> <!-- 弹窗 --> <el-dialog :title="title" :visible.sync="open" width="500px" append-to-body> <el-form ref="form" :model="form" :rules="rules" label-width="80px"> <el-form-item label="药品ID" prop="drugId"> <el-input v-model="form.drugId" placeholder="请输入药品ID"/> </el-form-item> <el-form-item label="厂家ID" prop="factoryId"> <el-input v-model="form.factoryId" placeholder="请输入厂家ID"/> </el-form-item> <el-form-item label="生产日期" prop="productionDate"> <el-date-picker clearable v-model="form.productionDate" type="date" value-format="yyyy-MM-dd" placeholder="请选择生产日期"/> </el-form-item> <el-form-item label="保质期" prop="validityPeriod"> <el-input v-model="form.validityPeriod" placeholder="请输入保质期"/> </el-form-item> <el-form-item label="进货单ID" prop="purchaseId"> <el-input v-model="form.purchaseId" placeholder="请输入进货单ID"/> </el-form-item> <!-- 不显示库存输入 --> </el-form> <div slot="footer" class="dialog-footer"> <el-button type="primary" @click="submitForm">确 定</el-button> <el-button @click="cancel">取 消</el-button> </div> </el-dialog>import request from '@/utils/request'
// 查询药品有效期预警,用于监控药品保质期列表 export function listWarning(query) { return request({ url: '/pill/warning/list', method: 'get', params: query }) }
// 查询药品有效期预警,用于监控药品保质期详细 export function getWarning(warningId) { return request({ url: '/pill/warning/' + warningId, method: 'get' }) }
// 新增药品有效期预警,用于监控药品保质期 export function addWarning(data) { return request({ url: '/pill/warning', method: 'post', data: data }) }
// 修改药品有效期预警,用于监控药品保质期 export function updateWarning(data) { return request({ url: '/pill/warning', method: 'put', data: data }) }
// 删除药品有效期预警,用于监控药品保质期 export function delWarning(warningId) { return request({ url: '/pill/warning/' + warningId, method: 'delete' }) }
-
- Assistant
你现有的
pill/warning模块功能已经完善,接下来基于你的业务,要求新增两个独立模块:pill/drug:提供药品列表接口,用于前端药品下拉框数据绑定。pill/factory:提供厂家列表接口,用于前端厂家下拉框数据绑定。
1. 设计接口规范
这两个接口都是简单的查询列表接口,通常查询所有有效数据或提供关键字搜索。
接口设计建议:
模块 请求方式 URL 参数 返回 备注 药品列表接口 GET /pill/drug/listname(可选,药品名模糊查询)药品列表数组,包含 drugId和drugName用于前端下拉框绑定 厂家列表接口 GET /pill/factory/listname(可选,厂家名模糊查询)厂家列表数组,包含 factoryId和factoryName用于前端下拉框绑定
2. 后端实现示例
假设你的
pill_drug和pill_factory相关实体、Mapper、Service尚未写,以下为示例代码:
2.1 药品模块
2.1.1 领域类
PillDrug.javapackage com.ruoyi.pill.domain; import com.ruoyi.common.annotation.Excel; import com.ruoyi.common.core.domain.BaseEntity; public class PillDrug extends BaseEntity { private static final long serialVersionUID = 1L; private Long drugId; @Excel(name = "药品名称") private String drugName; // getter & setter public Long getDrugId() { return drugId; } public void setDrugId(Long drugId) { this.drugId = drugId; } public String getDrugName() { return drugName; } public void setDrugName(String drugName) { this.drugName = drugName; } }2.1.2 Mapper接口
PillDrugMapper.javapackage com.ruoyi.pill.mapper; import java.util.List; import com.ruoyi.pill.domain.PillDrug; public interface PillDrugMapper { /** * 查询药品列表,支持根据名称模糊查询 */ List<PillDrug> selectPillDrugList(PillDrug pillDrug); }2.1.3 Mapper XML 示例
<mapper namespace="com.ruoyi.pill.mapper.PillDrugMapper"> <resultMap id="BaseResultMap" type="com.ruoyi.pill.domain.PillDrug"> <id column="drug_id" property="drugId" /> <result column="drug_name" property="drugName" /> </resultMap> <select id="selectPillDrugList" parameterType="com.ruoyi.pill.domain.PillDrug" resultMap="BaseResultMap"> SELECT drug_id, drug_name FROM pill_drug <where> <if test="drugName != null and drugName != ''"> AND drug_name LIKE CONCAT('%', #{drugName}, '%') </if> </where> ORDER BY drug_name ASC </select> </mapper>2.1.4 Service接口及实现
接口:
package com.ruoyi.pill.service; import java.util.List; import com.ruoyi.pill.domain.PillDrug; public interface IPillDrugService { List<PillDrug> selectPillDrugList(PillDrug pillDrug); }实现:
package com.ruoyi.pill.service.impl; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.ruoyi.pill.mapper.PillDrugMapper; import com.ruoyi.pill.domain.PillDrug; import com.ruoyi.pill.service.IPillDrugService; @Service public class PillDrugServiceImpl implements IPillDrugService { @Autowired private PillDrugMapper pillDrugMapper; @Override public List<PillDrug> selectPillDrugList(PillDrug pillDrug) { return pillDrugMapper.selectPillDrugList(pillDrug); } }2.1.5 Controller
package com.ruoyi.web.controller.pill; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import com.ruoyi.pill.domain.PillDrug; import com.ruoyi.pill.service.IPillDrugService; import com.ruoyi.common.core.controller.BaseController; import com.ruoyi.common.core.domain.AjaxResult; @RestController @RequestMapping("/pill/drug") public class PillDrugController extends BaseController { @Autowired private IPillDrugService pillDrugService; @PreAuthorize("@ss.hasPermi('pill:drug:list')") @GetMapping("/list") public AjaxResult list(PillDrug pillDrug) { List<PillDrug> list = pillDrugService.selectPillDrugList(pillDrug); return AjaxResult.success(list); } }
2.2 厂家模块
结构同药品模块类似,简单示范:
2.2.1 实体
PillFactory.javapackage com.ruoyi.pill.domain; import com.ruoyi.common.annotation.Excel; import com.ruoyi.common.core.domain.BaseEntity; public class PillFactory extends BaseEntity { private static final long serialVersionUID = 1L; private Long factoryId; @Excel(name = "厂家名称") private String factoryName; // getter & setter public Long getFactoryId() { return factoryId; } public void setFactoryId(Long factoryId) { this.factoryId = factoryId; } public String getFactoryName() { return factoryName; } public void setFactoryName(String factoryName) { this.factoryName = factoryName; } }2.2.2 Mapper接口
PillFactoryMapper.javapackage com.ruoyi.pill.mapper; import java.util.List; import com.ruoyi.pill.domain.PillFactory; public interface PillFactoryMapper { List<PillFactory> selectPillFactoryList(PillFactory pillFactory); }2.2.3 Mapper XML
<mapper namespace="com.ruoyi.pill.mapper.PillFactoryMapper"> <resultMap id="BaseResultMap" type="com.ruoyi.pill.domain.PillFactory"> <id column="factory_id" property="factoryId" /> <result column="factory_name" property="factoryName" /> </resultMap> <select id="selectPillFactoryList" parameterType="com.ruoyi.pill.domain.PillFactory" resultMap="BaseResultMap"> SELECT factory_id, factory_name FROM pill_factory <where> <if test="factoryName != null and factoryName != ''"> AND factory_name LIKE CONCAT('%', #{factoryName}, '%') </if> </where> ORDER BY factory_name ASC </select> </mapper>2.2.4 Service接口和实现,以及Controller
接口:
package com.ruoyi.pill.service; import java.util.List; import com.ruoyi.pill.domain.PillFactory; public interface IPillFactoryService { List<PillFactory> selectPillFactoryList(PillFactory pillFactory); }实现:
package com.ruoyi.pill.service.impl; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.ruoyi.pill.mapper.PillFactoryMapper; import com.ruoyi.pill.domain.PillFactory; import com.ruoyi.pill.service.IPillFactoryService; @Service public class PillFactoryServiceImpl implements IPillFactoryService { @Autowired private PillFactoryMapper pillFactoryMapper; @Override public List<PillFactory> selectPillFactoryList(PillFactory pillFactory) { return pillFactoryMapper.selectPillFactoryList(pillFactory); } }Controller:
package com.ruoyi.web.controller.pill; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.security.access.prepost.PreAuthorize; import org.springframework.web.bind.annotation.*; import com.ruoyi.pill.domain.PillFactory; import com.ruoyi.pill.service.IPillFactoryService; import com.ruoyi.common.core.controller.BaseController; import com.ruoyi.common.core.domain.AjaxResult; @RestController @RequestMapping("/pill/factory") public class PillFactoryController extends BaseController { @Autowired private IPillFactoryService pillFactoryService; @PreAuthorize("@ss.hasPermi('pill:factory:list')") @GetMapping("/list") public AjaxResult list(PillFactory pillFactory) { List<PillFactory> list = pillFactoryService.selectPillFactoryList(pillFactory); return AjaxResult.success(list); } }
3. 前端调用示例
你可以分别在下拉框组件中的
mounted钩子或响应式函数中调用:import request from '@/utils/request' // 获取药品列表 export function listDrug(query) { return request({ url: '/pill/drug/list', method: 'get', params: query }) } // 获取厂家列表 export function listFactory(query) { return request({ url: '/pill/factory/list', method: 'get', params: query }) }示例 Vue 中使用:
<template> <el-select v-model="selectedDrugId" placeholder="选择药品" filterable> <el-option v-for="item in drugList" :key="item.drugId" :label="item.drugName" :value="item.drugId"/> </el-select> <el-select v-model="selectedFactoryId" placeholder="选择厂家" filterable> <el-option v-for="item in factoryList" :key="item.factoryId" :label="item.factoryName" :value="item.factoryId"/> </el-select> </template> <script> import { listDrug, listFactory } from '@/api/pill/dropdown' export default { data() { return { drugList: [], factoryList: [], selectedDrugId: null, selectedFactoryId: null, } }, mounted() { this.fetchDrugList() this.fetchFactoryList() }, methods: { fetchDrugList() { listDrug({}).then(res => { this.drugList = res.data }) }, fetchFactoryList() { listFactory({}).then(res => { this.factoryList = res.data }) } } } </script>
4. 总结
- 新建
pill/drug和pill/factory模块的实体、Mapper、Service、Controller。 - 设计单纯的列表接口,支持按名称模糊查询。
- 前端通过调用这两个接口请求下拉框数据。
- 在权限控制上分配独立权限点(示例中为
pill:drug:list及pill:factory:list)。
如果你的数据库设计里
pill_drug和pill_factory表还有其他字段,也可以根据业务需要扩展。
如果你需要,我可以帮你生成完整的代码模板或者前端调用示例。