商品信息原先生成的不符合要求，重新生成，包括一个附表商品价格信息表
一、采用TAB主题一对多的模式
因为主键，在online表单配置是灰的，所以不能进行外键管理，只能通过下面数据库进行关联录入，否则online界面上不能录入。
效果如下：
二、生成代码使用页面风格tab风格
三、生成tab风格的代码还是需要进行修改
1、没有详情了，所以ErpGoodsList.vue需要增加
<a-menu-item> <a @click="handleDetail(record)">详情</a> </a-menu-item>
同时需要增加下面信息：
增加几个价格信息的列
{ title:'采购价格', align:"center", dataIndex: 'purchasePrice' }, { title:'销售价格', align:"center", dataIndex: 'salePrice' }, { title:'零售价格', align:"center", dataIndex: 'retailPrice' },
list修改成如下：
url: { list: "/goods/erpGoodsDto/list", 同时在ErpGoodsModal.vue文件把按钮要隐藏掉 :okButtonProps="{ class:{'jee-hidden': disableSubmit}
2、ErpGoodsForm.vue增加两个名称显示
<a-col :xs="24" :sm="12"> <a-form-model-item label="类别编号" :labelCol="labelCol" :wrapperCol="wrapperCol" prop="categoryId"> <j-popup v-model="model.categoryId" field="categoryId" org-fields="id,name" dest-fields="categoryId,categoryName" code="SelectorGoodsCategory" :multi="true" @input="popupCallback" /> <a-input v-model="model.categoryName"></a-input> </a-form-model-item> </a-col> <a-col :xs="24" :sm="12"> <a-form-model-item label="品牌编号" :labelCol="labelCol" :wrapperCol="wrapperCol" prop="brandId"> <j-popup v-model="model.brandId" field="brandId" org-fields="id,name" dest-fields="brandId,brandName" code="SelectorBrand" :multi="true" @input="popupCallback" /> <a-input v-model="model.brandName"></a-input> </a-form-model-item> </a-col>
3、后端增加相关文件
3.1 ErpGoodsDto.java文件
package com.nbcio.modules.erp.goods.dto; import java.io.Serializable; import org.jeecg.common.aspect.annotation.Dict; import io.swagger.annotations.ApiModelProperty; import lombok.Data; @Data public class ErpGoodsDto implements Serializable { private static final long serialVersionUID = 1L; /**ID*/ private java.lang.String id; /**编号*/ private java.lang.String code; /**名称*/ private java.lang.String name; /**SPU编号*/ //private java.lang.String spuId; /**类别编号*/ private java.lang.String categoryId; /**类别名称*/ private java.lang.String categoryName; /**品牌编号*/ private java.lang.String brandId; /**品牌名称*/ private java.lang.String brandName; /**规格*/ private java.lang.String spec; /**单位*/ private java.lang.String unit; /**采购价格*/ private java.math.BigDecimal purchasePrice; /**销售价格*/ private java.math.BigDecimal salePrice; /**零售价格*/ private java.math.BigDecimal retailPrice; /**税率（%）*/ private java.math.BigDecimal taxRate; /**销项税率（%）*/ private java.math.BigDecimal saleTaxRate; /**数量*/ private java.lang.Integer num; /**总价格*/ private java.math.BigDecimal totalPrice; /**库存数量*/ private java.lang.Integer stockNum; @Dict(dicCode = "erp_status") @ApiModelProperty(value = "状态") private java.lang.Integer status; }
3.2 ErpGoodsDtoController.java文件
package com.nbcio.modules.erp.goods.controller; import java.util.List; import javax.servlet.http.HttpServletRequest; import org.jeecg.common.api.vo.Result; import com.nbcio.modules.erp.goods.dto.ErpGoodsDto; import com.nbcio.modules.erp.goods.service.IErpGoodsDtoService; import com.nbcio.modules.erp.goods.vo.QueryGoodsVo; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import lombok.extern.slf4j.Slf4j; import org.jeecg.common.system.base.controller.JeecgController; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import io.swagger.annotations.Api; import io.swagger.annotations.ApiOperation; import org.jeecg.common.aspect.annotation.AutoLog; /** * @Description: erp_goods_dto * @Author: nbacheng * @Date: 2023-02-09 * @Version: V1.0 */ @Api(tags="erp_goods_dto") @RestController @RequestMapping("/goods/erpGoodsDto") @Slf4j public class ErpGoodsDtoController extends JeecgController<ErpGoodsDto, IErpGoodsDtoService> { @Autowired private IErpGoodsDtoService erpGoodsDtoService; /** * 分页列表查询 * * @param erpGoods * @param pageNo * @param pageSize * @param req * @return */ @AutoLog(value = "erp_goods-商品信息列表查询") @ApiOperation(value="erp_goods-商品信息列表查询", notes="erp_goods-商品信息列表查询") @GetMapping(value = "/list") public Result<?> queryGoodsList(QueryGoodsVo queryGoodsvo, @RequestParam(name="pageNo", defaultValue="1") Integer pageNo, @RequestParam(name="pageSize", defaultValue="10") Integer pageSize, HttpServletRequest req) { Page<ErpGoodsDto> page = new Page<ErpGoodsDto>(pageNo, pageSize); IPage<ErpGoodsDto> pageList = erpGoodsDtoService.queryGoodsList(page, queryGoodsvo); return Result.OK(pageList); } /** * 通过ids查询 * * @param ids * @return */ @AutoLog(value = "商品-通过ids查询") @ApiOperation(value="商品-通过ids查询", notes="商品-通过ids查询") @GetMapping(value = "/queryByIds") public Result<?> queryByIds(@RequestParam(name="ids",required=true) String ids) { List<ErpGoodsDto> listErpGoodsDto = erpGoodsDtoService.queryByIds(ids); if(listErpGoodsDto.size()==0) { return Result.error("未找到对应数据"); } return Result.OK(listErpGoodsDto); } }
3.3 ErpGoodsDtoMapper.java文件
package com.nbcio.modules.erp.goods.mapper; import com.nbcio.modules.erp.goods.dto.ErpGoodsDto; import com.nbcio.modules.erp.goods.vo.QueryGoodsVo; import java.util.List; import org.apache.ibatis.annotations.Param; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; /** * @Description: erp_goods_dto * @Author: nbacheng * @Date: 2023-02-09 * @Version: V1.0 */ public interface ErpGoodsDtoMapper extends BaseMapper<ErpGoodsDto> { List<ErpGoodsDto> queryGoodsList(Page<ErpGoodsDto> page, @Param("vo") QueryGoodsVo vo); public List<ErpGoodsDto> getByIds(@Param("idArray") String[] idArray); }
3.4 ErpGoodsDtoMapper.xml文件
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="com.nbcio.modules.erp.goods.mapper.ErpGoodsDtoMapper"> <resultMap id="ErpGoodsDtoMap" type="com.nbcio.modules.erp.goods.dto.ErpGoodsDto"> <id column="id" property="id"/> <result column="code" property="code"/> <result column="name" property="name"/> <result column="category_id" property="categoryId"/> <result column="category_name" property="categoryName"/> <result column="brand_id" property="brandId"/> <result column="brand_name" property="brandName"/> <result column="spec" property="spec"/> <result column="unit" property="unit"/> <result column="status" property="status"/> <result column="purchase_price" property="purchasePrice"/> <result column="sale_price" property="salePrice"/> <result column="retail_price" property="retailPrice"/> <result column="tax_rate" property="taxRate"/> <result column="sale_tax_rate" property="saleTaxRate"/> <result column="num" property="num"/> <result column="total_price" property="totalPrice"/> </resultMap> <sql id="ErpGoodsDto_sql"> SELECT a.id, a.code, a.name, c.id AS category_id, c.name AS category_name, b.id AS brand_id, b.name AS brand_name, a.spec, a.unit, a.status, price.purchase AS purchase_price, price.sale AS sale_price, price.retail AS retail_price, a.tax_rate, a.sale_tax_rate, 1 as num, price.sale*1 as total_price FROM erp_goods AS a LEFT JOIN erp_goods_price AS price ON price.id = a.id LEFT JOIN erp_goods_category AS c ON c.id = a.category_id LEFT JOIN erp_goods_brand AS b ON b.id = a.brand_id </sql> <select id="queryGoodsList" resultMap="ErpGoodsDtoMap"> <include refid="ErpGoodsDto_sql"/> <where> <if test="vo != null"> <if test="vo.condition != null and vo.condition != ''"> AND ( a.id LIKE CONCAT('%', #{vo.condition}, '%') OR a.code LIKE CONCAT('%', #{vo.condition}, '%') OR a.name LIKE CONCAT('%', #{vo.condition}, '%') ) </if> <if test="vo.brandId != null and vo.brandId != ''"> AND b.id = #{vo.brandId} </if> <if test="vo.categoryId != null and vo.categoryId != ''"> AND (c.id = #{vo.categoryId} </if> </if> AND a.status = '1' </where> ORDER BY a.code </select> <select id="getByIds" resultType="com.nbcio.modules.erp.goods.dto.ErpGoodsDto"> <include refid="ErpGoodsDto_sql"/> <where> a.id IN ( <foreach collection="idArray" item="id" separator=","> #{id} </foreach> ) </where> order by a.code desc </select> </mapper>
3.5 IErpGoodsDtoService.java文件
package com.nbcio.modules.erp.goods.service; import com.nbcio.modules.erp.goods.dto.ErpGoodsDto; import com.nbcio.modules.erp.goods.vo.QueryGoodsVo; import java.util.List; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.IService; /** * @Description: erp_goods_dto * @Author: nbacheng * @Date: 2023-02-09 * @Version: V1.0 */ public interface IErpGoodsDtoService extends IService<ErpGoodsDto> { IPage<ErpGoodsDto> queryGoodsList(Page<ErpGoodsDto> page, QueryGoodsVo queryGoodsVo); List<ErpGoodsDto> queryByIds(String ids); }
3.6 ErpGoodsDtoServiceImpl.java文件
package com.nbcio.modules.erp.goods.service.impl; import com.nbcio.modules.erp.goods.dto.ErpGoodsDto; import com.nbcio.modules.erp.goods.mapper.ErpGoodsDtoMapper; import com.nbcio.modules.erp.goods.service.IErpGoodsDtoService; import com.nbcio.modules.erp.goods.vo.QueryGoodsVo; import java.util.List; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; /** * @Description: erp_goods * @Author: nbacheng * @Date: 2023-02-09 * @Version: V1.0 */ @Service public class ErpGoodsDtoServiceImpl extends ServiceImpl<ErpGoodsDtoMapper, ErpGoodsDto> implements IErpGoodsDtoService { @Autowired private ErpGoodsDtoMapper erpGoodsDtoMapper; @Override public IPage<ErpGoodsDto> queryGoodsList(Page<ErpGoodsDto> page, QueryGoodsVo queryGoodsVo) { List<ErpGoodsDto> erpGoodsDtoLists = this.baseMapper.queryGoodsList(page, queryGoodsVo); return page.setRecords(erpGoodsDtoLists); } @Override public List<ErpGoodsDto> queryByIds(String ids) { // TODO Auto-generated method stub String [] idArray=ids.split(","); return erpGoodsDtoMapper.getByIds(idArray); } }
四、效果图
