<?php namespace App\Models;

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

class kasbonumum extends Sximo  {
	
	protected $table = 'aku_kasbon';
	protected $primaryKey = 'id';

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

	public static function querySelect(  ){
		
		return " SELECT
		aku_kasbon.*,
		SUM(if(aku_kasbon_detail.nominal>0,aku_kasbon_detail.nominal,0)) AS nominal
	  FROM
		aku_kasbon
		INNER JOIN aku_kasbon_detail
		  ON aku_kasbon.id = aku_kasbon_detail.kasbon_id";
	}	

	public static function queryWhere(  ){
		
		return " WHERE aku_kasbon.id IS NOT NULL ";
	}
	
	public static function queryGroup(){
		return " GROUP BY aku_kasbon.id ";
	}
	
	public static function getnokasbon($tgl,$plantcode){
		$sql = \DB::select("SELECT LPAD(IFNULL(MAX(RIGHT(doc_no,4)),0)+1,4,'0') AS maxnumber FROM aku_kasbon WHERE kode_plant = '$plantcode' AND MONTH(tgl) = MONTH('$tgl') AND YEAR(tgl)=YEAR('$tgl')")[0];

		return $sql->maxnumber;
	}

	public static function queryCoa($filter,$limit){
		$results = \DB::select(" SELECT a.* FROM ms_aku_coa a WHERE  (a.kode_coa LIKE '%$filter%' or a.nama_coa LIKE '%$filter%') LIMIT 10 ");
		return $results;
	}

	public  static function updateDataRowWithinsert( $table , $data )
	{
		$id = \DB::table( $table)->insertGetId($data);				             
        return $id;    
	}

	public static function detailkasbon($idkasbon){
		$sql = \DB::select("SELECT a.*,b.`nama_coa` FROM `aku_kasbon_detail` a INNER JOIN ms_aku_coa b ON a.`kode_coa`=b.`kode_coa` WHERE a.kasbon_id = '$idkasbon'");
		return $sql;
	}

	public static function queryPlant($plant){
		$pl = substr($plant, 0, 4);
		$results = \DB::table("ms_global_plant")->select('*')->where("kode_plant",$pl)->first();
		return $results;
	}

}