One Hat Cyber Team

Your IP : 18.216.188.48

Server IP : 104.21.112.1

Server : Linux agrigation-prod 5.15.0-67-generic #74-Ubuntu SMP Wed Feb 22 14:14:39 UTC 2023 x86_64

Server Software : nginx/1.24.0

PHP Version : 7.4.33

Buat File | Buat Folder

Dir : ~/home/forge/app.gftag.com/app/Models/

View File Name : PurchaseOrder.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\Relations\BelongsTo;
use Illuminate\Database\Eloquent\Relations\HasOne;
use Illuminate\Database\Eloquent\Relations\HasMany;
class PurchaseOrder extends Model
{
    use HasFactory;
    protected $fillable = [
        'po_id','organisation_id','supplier_id','po_date', 'status', 'amount', 'po_prefix'
    ];

    public function supplier(): BelongsTo
    {
        return $this->belongsTo(Supplier::class);
    }

    public function purchaseOrderItem(): HasOne
    {
        return $this->HasOne(PurchaseOrderItem::class);
    }

    public function organisation(): BelongsTo
    {
        return $this->belongsTo(Organisation::class);
    }

    // public function get_pos(){
    // 	$pos=DB::select("SELECT P.id,P.pono,P.podate,S.name As sname,P.status
    //             FROM purchaseorders P, suppliers S
    //             WHERE P.supplier = S.id
    //             ORDER BY P.pono DESC
    //             ");
    //      return $pos;
    // }

    // public function check_item_received($id){
    //     $item=DB::select("SELECT count(id) as count from stockin_transit st WHERE st.ref_no=$id AND st.status='Received' ");
    //     return $item;
    // }

    // public function check_item_pending($id){
    //     $item=DB::select("SELECT count(id) as count from stockin_transit st WHERE st.ref_no=$id AND st.status='Pending' ");
    //     return $item;
    // }

    // public function get_pos_id($id){
    // 	$pos=DB::select("SELECT P.id,P.pono,P.podate,S.id As sid,S.name As sname,P.status, 
    //             P.invno,P.invdate,P.filename
    //             FROM purchaseorders P, suppliers S
    //             WHERE P.supplier = S.id
    //             AND P.id = $id
    //             ");

    //      return $pos;
    // }
}