package crc.logistics.openwes.wes.stock.infrastructure.persistence.po;
import jakarta.persistence.Column;
import jakarta.persistence.Entity;
import jakarta.persistence.Id;
import lombok.Getter;
import lombok.Setter;
import org.hibernate.annotations.Immutable;
import org.hibernate.annotations.Subselect;
/**
* 联表视图实体:库存余量-按商品
*/
@Entity
@Immutable
@Getter
@Setter
@Subselect("""
SELECT
cs.sku_id skuId,
sm.owner_code ownerCode,
sm.sku_code skuCode,
sm.sku_name skuName,
sm.barcode_rule_code barcode,
sm.unit unit,
sm.brand brand,
SUM(cs.total_qty) stockQuantity,
SUM(cs.available_qty) availableQuantity,
SUM(cs.outbound_locked_qty) outStockReserved,
0 outStockOccupied,
0 reportOccupied,
SUM(cs.no_outbound_locked_qty) warehouseOccupied,
0 lossOccupied
FROM
w_container_stock cs
JOIN
m_sku_main_data sm ON cs.sku_id = sm.id
GROUP BY
cs.sku_id, sm.owner_code, sm.sku_code, sm.sku_name, sm.barcode_rule_code, sm.unit, sm.brand
""")
public class InventoryBySkuCodePO {
@Id
@Column(name = "sku_id")
private Long skuId;
@Column(name = "owner_code")
private String ownerCode;
@Column(name = "sku_code")
private String skuCode;
@Column(name = "sku_name")
private String skuName;
@Column(name = "barcode_rule_code")
private String barcode;
@Column(name = "unit")
private String unit;
@Column(name = "brand")
private String brand;
@Column(name = "total_qty")
private Integer stockQuantity;
@Column(name = "available_qty")
private Integer availableQuantity;
@Column(name = "outbound_locked_qty")
private Integer outStockReserved;
@Column(name = "out_stock_occupied")
private Integer outStockOccupied;
@Column(name = "report_occupied")
private Integer reportOccupied;
@Column(name = "no_outbound_locked_qty")
private Integer warehouseOccupied;
@Column(name = "loss_occupied")
private Integer lossOccupied;
},,{"status":"CM010001","msg":"system error.","description":"JDBC exception executing SQL [/* <criteria> */ select ibscp1_0.sku_id,ibscp1_0.available_qty,ibscp1_0.barcode_rule_code,ibscp1_0.brand,ibscp1_0.loss_occupied,ibscp1_0.out_stock_occupied,ibscp1_0.outbound_locked_qty,ibscp1_0.owner_code,ibscp1_0.report_occupied,ibscp1_0.sku_code,ibscp1_0.sku_name,ibscp1_0.total_qty,ibscp1_0.unit,ibscp1_0.no_outbound_locked_qty from ( SELECT\n cs.sku_id skuId,\n sm.owner_code ownerCode,\n sm.sku_code skuCode,\n sm.sku_name skuName,\n sm.barcode_rule_code barcode,\n sm.unit unit,\n sm.brand brand,\n SUM(cs.total_qty) stockQuantity,\n SUM(cs.available_qty) availableQuantity,\n SUM(cs.outbound_locked_qty) outStockReserved,\n 0 outStockOccupied,\n 0 reportOccupied,\n SUM(cs.no_outbound_locked_qty) warehouseOccupied,\n 0 lossOccupied\n FROM\n w_container_stock cs\n JOIN\n m_sku_main_data sm ON cs.sku_id = sm.id\n GROUP BY\n cs.sku_id, sm.owner_code, sm.sku_code, sm.sku_name, sm.barcode_rule_code, sm.unit, sm.brand\n ) ibscp1_0] [Unknown column 'ibscp1_0.sku_id' in 'field list'] [n/a]; SQL [n/a]"},,帮我分析一下报错原因