Struct SqliteLotRepository 

pub struct SqliteLotRepository { /* private fields */ }

Available on crate feature sqlite only.

Implementations

impl SqliteLotRepository

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

Trait Implementations

impl Debug for SqliteLotRepository

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

Formats the value using the given formatter.

impl LotRepository for SqliteLotRepository

fn create(&self, input: CreateLot) -> Result<Lot>

Create a new lot

fn get(&self, id: Uuid) -> Result<Option<Lot>>

Get lot by ID

fn get_by_number(&self, lot_number: &str) -> Result<Option<Lot>>

Get lot by lot number

fn update(&self, id: Uuid, input: UpdateLot) -> Result<Lot>

Update a lot

fn list(&self, filter: LotFilter) -> Result<Vec<Lot>>

List lots with filter

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

Delete a lot (only if no transactions)

fn adjust(&self, input: AdjustLot) -> Result<LotTransaction>

Adjust lot quantity

fn consume(&self, input: ConsumeLot) -> Result<LotTransaction>

Consume from a lot

fn reserve(&self, input: ReserveLot) -> Result<Uuid>

Reserve quantity from a lot

fn release_reservation(&self, reservation_id: Uuid) -> Result<()>

Release a reservation

fn confirm_reservation(&self, reservation_id: Uuid) -> Result<LotTransaction>

Confirm a reservation (convert to consumption)

fn transfer(&self, input: TransferLot) -> Result<LotTransaction>

Transfer lot between locations

fn split(&self, input: SplitLot) -> Result<Lot>

Split a lot into two

fn merge(&self, input: MergeLots) -> Result<Lot>

Merge multiple lots into one

fn quarantine(&self, id: Uuid, reason: &str) -> Result<Lot>

Quarantine a lot

fn release_quarantine(&self, id: Uuid) -> Result<Lot>

Release from quarantine

fn get_transactions( &self, lot_id: Uuid, limit: u32, ) -> Result<Vec<LotTransaction>>

Get lot transactions

fn get_quantity_at_location( &self, lot_id: Uuid, location_id: i32, ) -> Result<Option<Decimal>>

Get lot quantity at a location (None if no location record exists)

fn get_lot_locations(&self, lot_id: Uuid) -> Result<Vec<LotLocation>>

Get all locations for a lot

fn add_certificate(&self, input: AddLotCertificate) -> Result<LotCertificate>

Add certificate to lot

fn get_certificates(&self, lot_id: Uuid) -> Result<Vec<LotCertificate>>

Get certificates for lot

fn delete_certificate(&self, certificate_id: Uuid) -> Result<()>

Delete certificate

fn get_expiring_lots(&self, days: i32) -> Result<Vec<Lot>>

Get expiring lots

fn get_expired_lots(&self) -> Result<Vec<Lot>>

Get expired lots

fn get_available_lots_for_sku(&self, sku: &str) -> Result<Vec<Lot>>

Get lots with available quantity for SKU

fn trace(&self, lot_id: Uuid) -> Result<TraceabilityResult>

Trace lot (upstream and downstream)

fn count(&self, filter: LotFilter) -> Result<u64>

Count lots

fn create_batch(&self, inputs: Vec<CreateLot>) -> Result<BatchResult<Lot>>

Create multiple lots

fn get_batch(&self, ids: Vec<Uuid>) -> Result<Vec<Lot>>

Get multiple lots by ID