怎样建一个自己公司的网站,制作网站需要钱吗,页面紧急情况访问升级,中国中小企业网站建设现状商品信息原先生成的不符合要求#xff0c;重新生成#xff0c;包括一个附表商品价格信息表 一、采用TAB主题一对多的模式 因为主键#xff0c;在online表单配置是灰的#xff0c;所以不能进行外键管理#xff0c;只能通过下面数据库进行关联录入#xff0c;否则online界面… 商品信息原先生成的不符合要求重新生成包括一个附表商品价格信息表 一、采用TAB主题一对多的模式 因为主键在online表单配置是灰的所以不能进行外键管理只能通过下面数据库进行关联录入否则online界面上不能录入。 效果如下 二、生成代码使用页面风格tab风格 三、生成tab风格的代码还是需要进行修改
1、没有详情了所以ErpGoodsList.vue需要增加
a-menu-item a clickhandleDetail(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 :xs24 :sm12a-form-model-item label类别编号 :labelCollabelCol :wrapperColwrapperCol propcategoryIdj-popupv-modelmodel.categoryIdfieldcategoryIdorg-fieldsid,namedest-fieldscategoryId,categoryNamecodeSelectorGoodsCategory:multitrueinputpopupCallback/a-input v-modelmodel.categoryName/a-input/a-form-model-item/a-cola-col :xs24 :sm12a-form-model-item label品牌编号 :labelCollabelCol :wrapperColwrapperCol propbrandIdj-popupv-modelmodel.brandIdfieldbrandIdorg-fieldsid,namedest-fieldsbrandId,brandNamecodeSelectorBrand:multitrueinputpopupCallback/a-input v-modelmodel.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(tagserp_goods_dto)
RestController
RequestMapping(/goods/erpGoodsDto)
Slf4j
public class ErpGoodsDtoController extends JeecgControllerErpGoodsDto, IErpGoodsDtoService {Autowiredprivate IErpGoodsDtoService erpGoodsDtoService;/*** 分页列表查询** param erpGoods* param pageNo* param pageSize* param req* return*/AutoLog(value erp_goods-商品信息列表查询)ApiOperation(valueerp_goods-商品信息列表查询, noteserp_goods-商品信息列表查询)GetMapping(value /list)public Result? queryGoodsList(QueryGoodsVo queryGoodsvo,RequestParam(namepageNo, defaultValue1) Integer pageNo,RequestParam(namepageSize, defaultValue10) Integer pageSize,HttpServletRequest req) {PageErpGoodsDto page new PageErpGoodsDto(pageNo, pageSize);IPageErpGoodsDto 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(nameids,requiredtrue) String ids) {ListErpGoodsDto 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 BaseMapperErpGoodsDto {ListErpGoodsDto queryGoodsList(PageErpGoodsDto page, Param(vo) QueryGoodsVo vo);public ListErpGoodsDto getByIds(Param(idArray) String[] idArray);
}
3.4 ErpGoodsDtoMapper.xml文件
?xml version1.0 encodingUTF-8?
!DOCTYPE mapper PUBLIC -//mybatis.org//DTD Mapper 3.0//EN http://mybatis.org/dtd/mybatis-3-mapper.dtd
mapper namespacecom.nbcio.modules.erp.goods.mapper.ErpGoodsDtoMapperresultMap idErpGoodsDtoMap typecom.nbcio.modules.erp.goods.dto.ErpGoodsDtoid columnid propertyid/result columncode propertycode/result columnname propertyname/result columncategory_id propertycategoryId/result columncategory_name propertycategoryName/result columnbrand_id propertybrandId/result columnbrand_name propertybrandName/result columnspec propertyspec/result columnunit propertyunit/result columnstatus propertystatus/result columnpurchase_price propertypurchasePrice/result columnsale_price propertysalePrice/result columnretail_price propertyretailPrice/result columntax_rate propertytaxRate/result columnsale_tax_rate propertysaleTaxRate/result columnnum propertynum/result columntotal_price propertytotalPrice//resultMapsql idErpGoodsDto_sqlSELECTa.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_priceFROM erp_goods AS aLEFT JOIN erp_goods_price AS price ON price.id a.idLEFT JOIN erp_goods_category AS c ON c.id a.category_idLEFT JOIN erp_goods_brand AS b ON b.id a.brand_id/sqlselect idqueryGoodsList resultMapErpGoodsDtoMapinclude refidErpGoodsDto_sql/whereif testvo ! nullif testvo.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}, %))/ifif testvo.brandId ! null and vo.brandId ! AND b.id #{vo.brandId}/ifif testvo.categoryId ! null and vo.categoryId ! AND (c.id #{vo.categoryId} /if/ifAND a.status 1 /whereORDER BY a.code/selectselect idgetByIds resultTypecom.nbcio.modules.erp.goods.dto.ErpGoodsDtoinclude refidErpGoodsDto_sql/wherea.id IN (foreach collectionidArray itemid separator,#{id}/foreach)/whereorder 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 IServiceErpGoodsDto {IPageErpGoodsDto queryGoodsList(PageErpGoodsDto page, QueryGoodsVo queryGoodsVo);ListErpGoodsDto 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 ServiceImplErpGoodsDtoMapper, ErpGoodsDto implements IErpGoodsDtoService {Autowiredprivate ErpGoodsDtoMapper erpGoodsDtoMapper;Overridepublic IPageErpGoodsDto queryGoodsList(PageErpGoodsDto page, QueryGoodsVo queryGoodsVo) {ListErpGoodsDto erpGoodsDtoLists this.baseMapper.queryGoodsList(page, queryGoodsVo);return page.setRecords(erpGoodsDtoLists);}Overridepublic ListErpGoodsDto queryByIds(String ids) {// TODO Auto-generated method stubString [] idArrayids.split(,);return erpGoodsDtoMapper.getByIds(idArray);}}
四、效果图
