| | |
|---|
| | | } |
|---|
| | | |
|---|
| | | db := mysqlx.GetDB().Table("wms_operation"). |
|---|
| | | Select("wms_operation.id as operation_id,wms_operation.number,wms_operation.base_operation_type,material.id AS product_id,material.`name` AS product_name,wms_operation_details.amount,material.unit,wms_operation_details.from_location_id,from_location.`name` AS from_location,wms_operation_details.to_location_id,to_location.`name` AS to_location,wms_operation.operation_date as date,wms_operation.`status`"). |
|---|
| | | Select("wms_operation.id as operation_id,wms_operation.number,wms_operation.base_operation_type,material.id AS product_id," + |
|---|
| | | "material.`name` AS product_name,wms_operation_details.amount,material.unit,wms_operation_details.from_location_id," + |
|---|
| | | "from_location.`name` AS from_location,wms_operation_details.to_location_id,to_location.`name` AS to_location," + |
|---|
| | | "wms_operation.operation_date as date,wms_operation.`status`,material.weight"). |
|---|
| | | 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"). |
|---|
| | | InnerJoins("INNER JOIN wms_location AS from_location ON from_location.id = wms_operation_details.from_location_id"). |
|---|
