<?php namespace App; use Illuminate\Database\Eloquent\Model; use DB; class IndentItem extends Model { public function spareParts($spare_code){ $is_spare_code = DB::table('spare_parts_masters')->where('code',$spare_code)->count(); if($is_spare_code > 0){ $spare = DB::table('spare_parts_masters')->where('code',$spare_code)->first(); return $spare; }else{ return "no spare code"; } } }