erp_goods

package
v0.0.0-...-10721fb Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jan 4, 2020 License: Apache-2.0 Imports: 2 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func CheckArea 

func CheckArea(areaId int) (int, string, error)

判断地区是否合法

func CheckBrandId 

func CheckBrandId(brandId int) (int, string, error)

func CheckProvince 

func CheckProvince(provinceId int) (int, string, error)

判断是否是省

func CheckUnitId 

func CheckUnitId(unitId int) (int, string, error)

func DeleteErpGood 

func DeleteErpGood(id int, db orm.Ormer) (int64, error)

删除商品

func ExistBarCodeInAgent 

func ExistBarCodeInAgent(barcode string) (int, error)

判断公司端条码是否与加盟商的重复

func ExistBarcode 

func ExistBarcode(barcode string, goodId int) (int, error)

查询条码是否存在

func ExistCompanyId 

func ExistCompanyId(companyId int) (int, error)

func ExistGoodName 

func ExistGoodName(name string, goodId int) (int, error)

商品名称是否存在

func ExistGoodsId 

func ExistGoodsId(goodsId int) bool

func InsertMultiGoods 

func InsertMultiGoods(data []*JccCenterGoods) (int64, error)

批量增加商品(取消)

func QueryErpCompanyIdByCompanyId 

func QueryErpCompanyIdByCompanyId(companyId int) (int, error)

通过公司id查询上级公司id

func QueryErpGoodsCount 

func QueryErpGoodsCount(condition string) (int, error)

通过erpId查询erp商品总数

func QueryOnlineGoodsCount 

func QueryOnlineGoodsCount(id string) (count int, err error)

func UpdateErpGood 

func UpdateErpGood(data *JccCenterGoods, db orm.Ormer) (int64, error)

修改商品信息

Types

type ErpGoodsInfo 

type ErpGoodsInfo struct {
	Id                    int     `orm:"column(id);auto" description:"ID" json:"id"  `
	Name                  string  `orm:"column(name);size(150)" description:"名称" json:"name"  valid:"Required"`
	Spu                   string  `orm:"column(spu);size(150)" description:"SPU" json:"spu"  `
	Sku                   string  `orm:"column(sku);size(150)" description:"SKU" json:"sku"  `
	Barcode               string  `orm:"column(barcode);size(150)" description:"条码" json:"barcode"  valid:"Required"`
	Spec                  string  `orm:"column(spec);size(150)" description:"规格" json:"spec" "`
	BuyingPrice           float64 `orm:"column(buying_price);digits(11);decimals(2)" description:"进货价" json:"buying_price"  `
	RetailPrice           float64 `orm:"column(retail_price);digits(11);decimals(2)" description:"零售价" json:"retail_price"  `
	InventoryUpperLimit   string  `orm:"column(inventory_upper_limit);size(255);null" description:"库存上限" json:"inventory_upper_limit" `
	InventoryLowerLimit   string  `orm:"column(inventory_lower_limit)" description:"库存下限" json:"inventory_lower_limit"  `
	MnemonicWord          string  `orm:"column(mnemonic_word);size(255)" description:"助记词" json:"mnemonic_word"  `
	Remark                string  `orm:"column(remark);size(150)" description:"备注" json:"remark"  `
	Image                 string  `orm:"column(image);size(150)" description:"主图" json:"image"  `
	Images                string  `orm:"column(images)" description:"多图" json:"images"  `
	Content               string  `orm:"column(content)" description:"内容" json:"content"  `
	ProducingProvinceId   int     `orm:"column(producing_province_id)" description:"产地省ID" json:"producing_province_id"  valid:"Required"`
	ProducingProvinceName string  `orm:"column(producing_province_name)" description:"产地省名称" json:"producing_province_name"  `
	ProducingCityId       int     `orm:"column(producing_city_id)" description:"产地城市ID" json:"producing_city_id"  valid:"Required"`
	ProducingCityName     string  `orm:"column(producing_city_name)" description:"产地城市名称" json:"producing_city_name"  `
	ProducingAreaId       int     `orm:"column(producing_area_id)" description:"产地区域ID" json:"producing_area_id"  valid:"Required"`
	ProducingAreaName     string  `orm:"column(producing_area_name)" description:"产地区域ID" json:"producing_area_name"  `
	ProducingAreaDetail   string  `orm:"column(producing_area_detail);size(150)" description:"产地详情" json:"producing_area_detail"  `
	UnitId                int     `orm:"column(unit_id)" description:"单位ID" json:"unit_id"  valid:"Required"`
	UnitName              string  `orm:"column(unit_name)" description:"单位名称" json:"unit_name"  `
	BrandId               int     `orm:"column(brand_id)" description:"品牌ID" json:"brand_id"  valid:"Required"`
	BrandName             string  `orm:"column(brand_name)" description:"品牌名称" json:"brand_name" `
	CreatedAt             int64   `orm:"column(created_at)" description:"创建时间" json:"-"  `
	UpdatedAt             int64   `orm:"column(updated_at)" description:"修改时间" json:"-"  `
	DeletedAt             int64   `orm:"column(deleted_at)" description:"删除时间" json:"-"  `
	IsDel                 int8    `orm:"column(is_del)" description:"是否删除" json:"-"  `
	A8Code                int8    `orm:"column(a8_code)" description:"a8编码" json:"a8_code"  `
	IsCancelProcurement   int8    `orm:"column(is_cancel_procurement)" description:"是否取消采购" json:"is_cancel_procurement"  `
	CategoryId            int     `orm:"column(category_id)" description:"商品分类" json:"goods_category_ids"  `
	Option                int     `orm:"column(option)" description:"可定库存" json:"option"  `
	Uuid                  int     `orm:"column(uuid)" description:"前端判断唯一字段" json:"uuid"  `
}

func QueryErpGoodsByErpCompanyId 

func QueryErpGoodsByErpCompanyId(condition string, page, pageSize int) ([]ErpGoodsInfo, error)

通过erpId查询erp商品信息及库存

type JccCenterGoods 

type JccCenterGoods struct {
	Id                    int     `orm:"column(id);auto" description:"ID" json:"id"  `
	Name                  string  `orm:"column(name);size(150)" description:"名称" json:"name"  valid:"Required"`
	Spu                   string  `orm:"column(spu);size(150)" description:"SPU" json:"spu"  `
	Sku                   string  `orm:"column(sku);size(150)" description:"SKU" json:"sku"  `
	Barcode               string  `orm:"column(barcode);size(150)" description:"条码" json:"barcode"  valid:"Required" `
	Spec                  string  `orm:"column(spec);size(150)" description:"规格" json:"spec" `
	BuyingPrice           float64 `orm:"column(buying_price);digits(11);decimals(2)" description:"进货价" json:"agent_price"  `
	RetailPrice           float64 `orm:"column(retail_price);digits(11);decimals(2)" description:"零售价" json:"retail_price"  `
	InventoryUpperLimit   string  `orm:"column(inventory_upper_limit);size(255);null" description:"库存上限" json:"inventory_upper_limit" `
	InventoryLowerLimit   string  `orm:"column(inventory_lower_limit)" description:"库存下限" json:"inventory_lower_limit"  `
	MnemonicWord          string  `orm:"column(mnemonic_word);size(255)" description:"助记词" json:"mnemonic_word"  `
	Remark                string  `orm:"column(remark);size(150)" description:"备注" json:"remark"  `
	Image                 string  `orm:"column(image);size(150)" description:"主图" json:"image"  `
	Images                string  `orm:"column(images)" description:"多图" json:"images"  `
	Content               string  `orm:"column(content)" description:"内容" json:"content"  `
	ProducingProvinceId   int     `orm:"column(producing_province_id)" description:"产地省ID" json:"producing_province_id"  valid:"Required"`
	ProducingProvinceName string  `orm:"column(producing_province_name)" description:"产地省名称" json:"producing_province_name"  `
	ProducingCityId       int     `orm:"column(producing_city_id)" description:"产地城市ID" json:"producing_city_id"  valid:"Required"`
	ProducingCityName     string  `orm:"column(producing_city_name)" description:"产地城市名称" json:"producing_city_name"  `
	ProducingAreaId       int     `orm:"column(producing_area_id)" description:"产地区域ID" json:"producing_area_id"  valid:"Required"`
	ProducingAreaName     string  `orm:"column(producing_area_name)" description:"产地区域ID" json:"producing_area_name"  `
	ProducingAreaDetail   string  `orm:"column(producing_area_detail);size(150)" description:"产地详情" json:"producing_area_detail"  `
	UnitId                int     `orm:"column(unit_id)" description:"单位ID" json:"unit_id"  valid:"Required"`
	UnitName              string  `orm:"column(unit_name)" description:"单位名称" json:"unit_name"  `
	BrandId               int     `orm:"column(brand_id)" description:"品牌ID" json:"brand_id"  valid:"Required"`
	BrandName             string  `orm:"column(brand_name)" description:"品牌名称" json:"brand_name" `
	CreatedAt             int64   `orm:"column(created_at)" description:"创建时间" json:"-"  `
	UpdatedAt             int64   `orm:"column(updated_at)" description:"修改时间" json:"-"  `
	DeletedAt             int64   `orm:"column(deleted_at)" description:"删除时间" json:"-"  `
	IsDel                 int8    `orm:"column(is_del)" description:"是否删除" json:"-"  `
	A8Code                string  `orm:"column(a8_code)" description:"a8编码" json:"a8_code"  `
	IsCancelProcurement   int8    `orm:"column(is_cancel_procurement)" description:"是否取消采购" json:"is_cancel_procurement"  `
	CategoryId            int     `orm:"column(category_id)" description:"商品分类" json:"goods_category_ids"  `
}

func QueryErpGoodInfo 

func QueryErpGoodInfo(ids []int) ([]JccCenterGoods, error)

查询商品信息

func QueryOnlineGoodsInfo 

func QueryOnlineGoodsInfo(id string) (list JccCenterGoods, err error)

type SyncInfo 

type SyncInfo struct {
	Id        int    `orm:"column(id);auto" description:"ID" json:"id"  `
	Arrtibute string `orm:"column(arrtibute);auto" description:"ID" json:"arrtibute"  `
}

func QueryAllBarcode 

func QueryAllBarcode() ([]*SyncInfo, error)

查询所有商品条码

func QueryAllGoodName 

func QueryAllGoodName() ([]*SyncInfo, error)

查询所有的商品名称

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.