<?php namespace App; use Illuminate\Database\Eloquent\Model; use DB; class StockTransferOrder extends Model { public function addedBy($user_id){ $is_user = DB::table('users')->where('id',$user_id)->count(); if($is_user > 0){ $user = DB::table('users')->select('users.name')->where('id',$user_id)->first(); return $user->name; }else{ return 'no user'; } } public function authorizedBy($user_id){ $is_user = DB::table('users')->where('loginId',$user_id)->count(); if($is_user > 0){ $user = DB::table('users')->select('users.name')->where('loginId',$user_id)->first(); return $user->name; }else{ return 'no user'; } } }