Struct SqliteCostAccountingRepository 

pub struct SqliteCostAccountingRepository { /* private fields */ }

Available on crate feature sqlite only.

Implementations

impl SqliteCostAccountingRepository

pub const fn new(pool: Pool<SqliteConnectionManager>) -> Self

Trait Implementations

impl CostAccountingRepository for SqliteCostAccountingRepository

fn get_item_cost(&self, sku: &str) -> Result<Option<ItemCost>>

Get item cost by SKU

fn set_item_cost(&self, input: SetItemCost) -> Result<ItemCost>

Set/update item cost

fn list_item_costs(&self, filter: ItemCostFilter) -> Result<Vec<ItemCost>>

List item costs

fn update_average_cost( &self, sku: &str, quantity: Decimal, unit_cost: Decimal, ) -> Result<ItemCost>

Update average cost (called when receiving inventory)

fn update_last_cost(&self, sku: &str, unit_cost: Decimal) -> Result<ItemCost>

Update last cost

fn create_cost_layer(&self, input: CreateCostLayer) -> Result<CostLayer>

Create a cost layer

fn get_cost_layer(&self, id: Uuid) -> Result<Option<CostLayer>>

Get cost layer by ID

fn list_cost_layers(&self, filter: CostLayerFilter) -> Result<Vec<CostLayer>>

List cost layers

fn issue_fifo(&self, input: IssueCostLayers) -> Result<Vec<CostTransaction>>

Issue from cost layers (FIFO)

fn issue_lifo(&self, input: IssueCostLayers) -> Result<Vec<CostTransaction>>

Issue from cost layers (LIFO)

fn get_layers_remaining(&self, sku: &str) -> Result<Decimal>

Get remaining quantity in layers for SKU

fn record_cost_transaction( &self, sku: &str, transaction_type: CostTransactionType, quantity: Decimal, unit_cost: Decimal, layer_id: Option<Uuid>, reference_type: Option<&str>, reference_id: Option<Uuid>, notes: Option<&str>, ) -> Result<CostTransaction>

Record a cost transaction

fn list_cost_transactions( &self, filter: CostTransactionFilter, ) -> Result<Vec<CostTransaction>>

List cost transactions

fn record_variance(&self, input: RecordCostVariance) -> Result<CostVariance>

Record a cost variance

fn list_variances( &self, filter: CostVarianceFilter, ) -> Result<Vec<CostVariance>>

List cost variances

fn get_variance_summary( &self, from: DateTime<Utc>, to: DateTime<Utc>, ) -> Result<Decimal>

Get variance summary for period

fn create_adjustment( &self, input: CreateCostAdjustment, ) -> Result<CostAdjustment>

Create a cost adjustment

fn get_adjustment(&self, id: Uuid) -> Result<Option<CostAdjustment>>

Get adjustment by ID

fn list_adjustments( &self, filter: CostAdjustmentFilter, ) -> Result<Vec<CostAdjustment>>

List adjustments

fn approve_adjustment( &self, id: Uuid, approved_by: &str, ) -> Result<CostAdjustment>

Approve adjustment

fn apply_adjustment(&self, id: Uuid) -> Result<CostAdjustment>

Apply adjustment (update item cost)

fn reject_adjustment(&self, id: Uuid) -> Result<CostAdjustment>

Reject adjustment

fn calculate_rollup( &self, sku: &str, bom_id: Option<Uuid>, ) -> Result<CostRollup>

Calculate cost rollup for manufactured item

fn get_rollup(&self, sku: &str) -> Result<Option<CostRollup>>

Get latest rollup for SKU

fn get_inventory_valuation( &self, cost_method: CostMethod, ) -> Result<InventoryValuation>

Get inventory valuation

fn get_sku_cost_summary(&self, sku: &str) -> Result<Option<SkuCostSummary>>

Get SKU cost summary

fn get_total_inventory_value(&self) -> Result<Decimal>

Get total inventory value

impl Debug for SqliteCostAccountingRepository

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.