| | |
| | | OperationDate: time.Now().Format("2006-01-02 15:04:05"), |
| | | Details: []*models.OperationDetails{detail}, |
| | | BaseOperationType: constvar.BaseOperationTypeDisuse, |
| | | OperationTypeName: "库存报废", |
| | | } |
| | | if err := models.NewOperationSearch().Create(&operation); err != nil { |
| | | logx.Errorf("Operation create err: %v", err) |
| | |
| | | |
| | | 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) |