PHP app\models UserWorkspace::join Examples

Example #1

File: User.php Project: hunglmtb/eb

 public function workspace()
 {
     // 		\DB::enableQueryLog();
     $wp = UserWorkspace::join($this->table, $this->table . '.ID', '=', 'USER_WORKSPACE.USER_ID')->join('FACILITY', 'USER_WORKSPACE.W_FACILITY_ID', '=', 'FACILITY.ID')->join('LO_AREA', 'FACILITY.AREA_ID', '=', 'LO_AREA.ID')->join('LO_PRODUCTION_UNIT', 'LO_AREA.PRODUCTION_UNIT_ID', '=', 'LO_PRODUCTION_UNIT.ID')->where($this->table . '.ID', '=', $this->ID)->select('USER_WORKSPACE.*', 'FACILITY.AREA_ID', 'LO_AREA.PRODUCTION_UNIT_ID')->get()->first();
     // 		\Log::info(\DB::getQueryLog());
     return $wp;
 }