1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43

<?php

use Illuminate\Database\Capsule\Manager as DB;
use Carbon\Carbon as Carbon;

class Warehouse extends BaseModel{
    protected $table = "warehouse";

    public function warehouseProductskus(){
        return $this->hasMany('WarehouseProductsku');
    }

    public function supplier(){
        return $this->belongsTo('Supplier');
    }

    public function warehouseType(){
        return $this->belongsTo('MasterTypeCode', 'warehouse_type', 'code')->where('typeid', 'WAREHOUSE_TYPE');
    }


    public static function supplier_warehouse($supplier_id){
        return self::whereDeleted(0)
                    ->where('supplier_id', $supplier_id)
                    ->where('is_transport_warehouse', 0)
                    ->orderBy('priority', 'asc')
                    ->orderBy('id', 'asc')
                    ->get();
    }

    public static function stockin_warehouse($supplier_id){
        return self::supplier_warehouse($supplier_id)->first();
    }

    /* --------------------test cases--------------------*/

    public static function test_stockinWarehouse(){
        var_dump(Warehouse::stockin_warehouse(1)->name_en);
        var_dump(Warehouse::stockin_warehouse(2)->name_en);
        var_dump(Warehouse::stockin_warehouse(3)->name_en);
    }
}