Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory :  /home/corals/inventory.corals.io/Corals/modules/Inventory/Classes/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?php

namespace Corals\Modules\Inventory\Classes;

use Corals\Modules\Inventory\Models\Inventory as InventoryModel;
use Corals\Modules\Inventory\Models\InventoryItem;
use Corals\Modules\Inventory\Models\Item;
use Corals\Modules\Inventory\Models\Supplier;
use Corals\Modules\Inventory\Models\Transaction;


class Inventory
{
    /**
     * @return \Illuminate\Support\Collection
     */
    public function getSuppliersList()
    {
        return Supplier::query()->pluck('name', 'id');
    }

    /**
     * @return \Illuminate\Support\Collection
     */
    public function getInventoriesList()
    {
        return InventoryModel::query()->pluck('name', 'id');
    }

    /**
     * @return \Illuminate\Support\Collection
     */
    public function getItemsList()
    {
        return Item::query()->pluck('name', 'id');
    }

    public function itemsCountInInventory($inventory_id)
    {
       return InventoryItem::query()->select('inv_inventory_has_items.*')
           ->join('inv_inventories','inv_inventories.id','=','inv_inventory_has_items.inventory_id')
           ->where('inv_inventories.id','=',$inventory_id)->count();
    }

    public function totalWholesaleItemsPriceInventory($inventory_id)
    {
        return InventoryItem::query()->select('inv_items.wholesale_price')
            ->join('inv_inventories','inv_inventories.id','=','inv_inventory_has_items.inventory_id')
            ->join('inv_items','inv_items.id','=','inv_inventory_has_items.item_id')
            ->where('inv_inventories.id','=',$inventory_id)->sum('wholesale_price');
    }

    public function inDirectionInventoryTransactionsCount($inventory_id)
    {
        return Transaction::query()->select('inv_transactions.*', 'inv_inventories.*')
            ->join('inv_inventories', 'inv_inventories.id', '=', 'inv_transactions.inventory_id')
            ->where('inv_transactions.direction','=','in')
            ->where('inv_inventories.id', '=', $inventory_id)->count();

    }

    public function outDirectionInventoryTransactionsCount($inventory_id)
    {
        return Transaction::query()->select('inv_transactions.*', 'inv_inventories.*')
            ->join('inv_inventories', 'inv_inventories.id', '=', 'inv_transactions.inventory_id')
            ->where('inv_transactions.direction','=','out')
            ->where('inv_inventories.id', '=', $inventory_id)->count();
    }
}