<?php namespace App\Models;

use Illuminate\Auth\Authenticatable;
use Illuminate\Database\Eloquent\Model;

class startupahtebang extends Sximo  {
	
	protected $table = 't_upah_tebang';
	protected $primaryKey = 'id';

	public function __construct() {
		parent::__construct();
		
	}

	public static function querySelect(  ){
		
		return "  SELECT t_upah_tebang.* FROM t_upah_tebang  ";
	}	

	public static function queryWhere(  ){
		
		return "  WHERE t_upah_tebang.id IS NOT NULL ";
	}
	
	public static function queryGroup(){
		return "  ";
	}

	public static function upahpokok() {
		return \DB::table('m_pekerjaan_tma')
			->select('nominal_default')
			->where('kodekolom', 'k1')
			->where('kode_plant', session('fid'))
			->first();
	}

	public static function premibersih() {
		return \DB::table('m_pekerjaan_tma')
			->select('nominal_default')
			->where('kodekolom', 'k2')
			->where('kode_plant', session('fid'))
			->first();
	}

	public static function upahmandor() {
		return \DB::table('m_pekerjaan_tma')
			->select('nominal_default')
			->where('kodekolom', 'k3')
			->where('kode_plant', session('fid'))
			->first();
	}

	public static function premimandor() {
		return \DB::table('m_pekerjaan_tma')
			->select('nominal_default')
			->where('kodekolom', 'k4')
			->where('kode_plant', session('fid'))
			->first();
	}

	public static function sapi() {
		return \DB::table('m_pekerjaan_tma')
			->select('nominal_default')
			->where('kodekolom', 'k5')
			->where('kode_plant', session('fid'))
			->first();
	}

	public static function premi($jenis) {
		return \DB::table('master_upah_potongan')
			->select('nominal as nominal_default','deskripsi as nama_pekerjaan_tma')
			->where('jenis', 'upah')
			->where('tebang', $jenis)
			->where('kode_kebun', session('fid'))->get();
	}
	public static function getSdmkaryawan($id) {
		return \DB::select("SELECT a.nama FROM master_mandor_tebang a WHERE a.nik = '".$id."'");
	}
	public static function queryDetail($kd_blok,$tgl1,$tgl2,$mandor, $jenis) {
	// 	return \DB::select("SELECT
	// 		b.tanggal as tebang,
	// 		'' as id_pta,
	// 		b.mandor_tebang as id_mandor,
	// 		'' as pta,
	// 		c.nama as mandor,
	// 		a.nomer_petak as no_petak_ptpn,
	// 		a.nomer_petak as no_petak_sgn,				
	// 		b.jenis_tebang as kategori,
	// 		d.nama_kebun as deskripsi_blok,
	// 		b.nomor_kendaraan as no_truk,
	// 		a.no_spta,
	// 		a.netto_final_kg as netto_final,
	// 		e.kualitas
	// 		FROM data_timbangan a
	// 		inner join tx_pos_keluar g on g.spta = a.no_spta
	// 		inner join tx_petak_tebang b on b.nomor_booking = g.kode_booking
	// 		inner join master_mandor_tebang c on c.nik = b.mandor_tebang
	// 		inner join master_petak d on d.lahan_id = a.nomer_petak 
	// 		left join data_meja_tebu e on e.no_spta = a.no_spta
	// 		left join tx_upah_tebang_tma_detail as f on f.no_spta = a.no_spta
	// 		WHERE a.nomer_petak = '".$kd_blok."'
	// 		AND a.tgl_timbang BETWEEN '".$tgl1."' AND '".$tgl2."'
	// 		AND b.mandor_tebang = '".$mandor."'
	// 		AND b.jenis_tebang = '".$jenis."'
	// 		AND f.no_dokumen IS NULL
	// 		group by a.no_spta
	// 		ORDER BY a.no_spta ASC");
	// }
	return \DB::select("SELECT
			b.tanggal as tebang,
			'' as id_pta,
			b.mandor_tebang as id_mandor,
			'' as pta,
			c.nama as mandor,
			a.nomer_petak as no_petak_ptpn,
			a.nomer_petak as no_petak_sgn,				
			b.jenis_tebang as kategori,
			d.nama_kebun as deskripsi_blok,
			b.nomor_kendaraan as no_truk,
			a.no_spta,
			a.netto_final_kg as netto_final,
			e.kualitas
			FROM data_timbangan a
			inner join tx_pos_keluar g on g.spta = a.no_spta
			inner join tx_petak_tebang b on b.nomor_booking = g.kode_booking
			inner join master_mandor_tebang c on c.nik = b.mandor_tebang
			inner join master_petak d on d.lahan_id = a.nomer_petak 
			left join data_meja_tebu e on e.no_spta = a.no_spta
			left join tx_upah_tebang_tma_detail as f on f.no_spta = a.no_spta
			WHERE a.nomer_petak = '".$kd_blok."'
			AND a.tgl_timbang BETWEEN '".$tgl1."' AND '".$tgl2."'
			AND b.mandor_tebang = '".$mandor."'
			AND b.jenis_tebang = '".$jenis."'
			group by a.no_spta
			ORDER BY a.no_spta ASC");
	}
	
	
}