修改字段类型

liujiandao

2024-04-18 5208dce1708d415b39f4caffa5f23c83a7070199

修改字段类型

 controllers/product_controller.go

@@ -510,7 +510,10 @@

    db := models.NewOperationSearch().Orm.
        Table("wms_operation").
        Select("wms_operation.id,wms_operation.number,wms_operation.source_number,wms_operation.status,wms_operation_details.from_location_id,wms_operation_details.to_location_id,wms_operation.operation_date,wms_operation.contacter_id,wms_operation.contacter_name,wms_operation.company_id,wms_operation.company_name,wms_operation.comment,wms_operation_details.product_id,material.name as product_name,material.unit,wms_operation_details.amount,wms_operation.base_operation_type").
        Select("wms_operation.id,wms_operation.number,wms_operation.source_number,wms_operation.status,wms_operation_details.from_location_id,"+
            "wms_operation_details.to_location_id,wms_operation.operation_date,wms_operation.contacter_id,wms_operation.contacter_name,"+
            "wms_operation.company_id,wms_operation.company_name,wms_operation.comment,wms_operation_details.product_id,"+
            "material.name as product_name,material.unit,wms_operation_details.amount,wms_operation.base_operation_type").
        InnerJoins("inner join wms_operation_details on wms_operation_details.operation_id=wms_operation.id").
        InnerJoins("inner join material on material.id=wms_operation_details.product_id").
        Where("wms_operation.base_operation_type=?", constvar.BaseOperationTypeDisuse)

 models/material.go

@@ -602,7 +602,7 @@
    OperationDate     string                     `json:"operationDate" gorm:"type:varchar(31);comment:安排日期"`
    ContacterID       int                        `json:"contacterID" gorm:"type:int;comment:联系人ID"`
    ContacterName     string                     `json:"contacterName" gorm:"type:varchar(63);comment:联系人姓名"`
    CompanyID         int                        `json:"companyID" gorm:"type:int;comment:公司ID-客户"`
    CompanyID         string                     `json:"companyID"` //公司ID-客户
    CompanyName       string                     `json:"companyName" gorm:"type:varchar(127);comment:公司名称-客户"`
    Comment           string                     `json:"comment" gorm:"type:text;comment:备注"`
    ProductId         string                     `json:"productId" gorm:"type:varchar(191);not null;comment:产品id"`   //产品id