Warehouse support

[deantheiceman]

Would it be possible to add warehouse support? Maybe like an extra pivot model so like:

Book + Warehouse = the stock

[gizburdt]

I thought of this while building the first version, but I didn't need it in that version. Maybe going to look at it later. PR is always welcome :)

[deantheiceman]

@gizburdt thanks for your reply.

I'm thinking a simple concept may be to use a second "warehouse_id" column then count stock based on the two as a simple way of handling it, do you think that'd work and be acceptable?

[gizburdt]

Will think about it

[deantheiceman]

Have you also been using this in production? Wonder if it's worth while implementing a cache functionality so it doesn't need to sum through all the columns every time?

[ahmedgadit]

plus one for this feature :)

[gogl92]

I think this one can be achieved by using the ReferenceModel not sure what was the intention for this but we can store the warehouse class/name and then just query by the id of the warehouse.

    /**
     * Returns the stock at a given date and warehouse (optionals)
     *
     * @param null $date
     * @param null $warehouse
     * @return int
     */
    public function stock($date = null, $warehouse = null)
    {
        $date = $date ?: Carbon::now();

        if (! $date instanceof DateTimeInterface) {
            $date = Carbon::create($date);
        }

        $mutations = $this->stockMutations()->where('created_at', '<=', $date->format('Y-m-d H:i:s'));

        if ($warehouse !== null) {
            $mutations->where([
                'reference_type' => $warehouse::class,
                'reference_id' => $warehouse->id,
            ]);
        }

        return (int) $mutations->sum('amount');
    }