<?php namespace App\Models;

use Illuminate\Auth\Authenticatable;
use Illuminate\Database\Eloquent\Model;

class pipica extends Sximo  {
	
	protected $table = 'tx_pica_pi';
	protected $primaryKey = 'id';

	public function __construct() {
		parent::__construct();
		
	}

	public static function querySelect(  ){
		
		return "  SELECT tx_pica_pi.*, master_petak.nama_kebun as deskripsi, master_petak.afd_new as afdeling FROM tx_pica_pi  ";
	}	

	public static function queryWhere(  ){
		
		return "  left join master_petak on master_petak.lahan_id = tx_pica_pi.lahan_id  WHERE tx_pica_pi.id IS NOT NULL ";
	}
	
	public static function queryGroup(){
		return "  ";
	}
	

}