<?php namespace App\Models;

use Illuminate\Auth\Authenticatable;
use Illuminate\Database\Eloquent\Model;

class gudangpupukarea extends Sximo  {
	
	protected $table = 't_gudang_pupuk_area';
	protected $primaryKey = 'id';

	public function __construct() {
		parent::__construct();
		
	}

	public static function querySelect(  ){
		
		return "  SELECT t_gudang_pupuk_area.* FROM t_gudang_pupuk_area  ";
	}	

	public static function queryWhere(  ){
		
		return "  WHERE t_gudang_pupuk_area.id IS NOT NULL ";
	}
	
	public static function queryGroup(){
		return "  ";
	}
	
	public function getPupukHerbisida($id)
    {
        return \DB::table('t_permintaan_pupuk_herbisida as a')
            ->leftJoin('m_pupuk_herbisida as b', 'b.id', '=', 'a.barang')
            ->select('a.*', 'b.nama as barang')
            ->where('a.kode_permintaan', $id)
            ->where('a.status', 3)
            ->whereNull('a.status_terima')
            ->where('a.unit', substr(\Session::get('fid'), 0, 6))
            ->get();
    }

	public function cekPermintaan($id)
    {
        return \DB::table('t_gudang_pupuk_area')
            ->select(\DB::raw('count(*) as hit'))
            ->where('kode_permintaan', $id)
            ->first();
    }

	public function dataPermintaan($id)
    {
        return \DB::table('t_permintaan_pupuk_herbisida as a')
            ->leftJoin('m_pupuk_herbisida as b', 'b.id', '=', 'a.barang')
            ->select('a.*')
            ->where('a.kode_permintaan', $id)
            ->where('a.status', 3)
            ->where('a.status_terima', null)
            ->where('a.unit', substr(\Session::get('fid'), 0, 6))
            ->get();
    }
	public function updatepermintaan($id)
    {
        $updated = \DB::table('t_permintaan_pupuk_herbisida')
                    ->where('kode_permintaan', $id)
                    ->update([
                        'status_terima' => 1,
                        'tgl_diterima' => now()
                    ]);

        if ($updated) {
            return "Update berhasil";
        } else {
            return "Update gagal atau tidak ada data yang diupdate";
        }
    }

	public function insertgudangarea($data)
	{
		$id = \DB::table('t_gudang_pupuk_area')->insertGetId($data);
		return $id;
	}

    
}