public static function boot()
 {
     parent::boot();
     static::creating(function ($model) {
         if ($model->carsubmodelid == 0) {
             CommissionFinaceCar::where('commissionfinaceid', $model->commissionfinaceid)->where('carmodelid', $model->carmodelid)->delete();
         }
         $model->createdby = Auth::user()->id;
         $model->createddate = date("Y-m-d H:i:s");
         $model->modifiedby = Auth::user()->id;
         $model->modifieddate = date("Y-m-d H:i:s");
     });
     static::created(function ($model) {
         Log::create(['employeeid' => Auth::user()->id, 'operation' => 'Add', 'date' => date("Y-m-d H:i:s"), 'model' => class_basename(get_class($model)), 'detail' => $model->toJson()]);
     });
     static::updating(function ($model) {
         if ($model->carsubmodelid == 0) {
             CommissionFinaceCar::where('id', '!=', $model->id)->where('commissionfinaceid', $model->commissionfinaceid)->where('carmodelid', $model->carmodelid)->delete();
         }
         $model->modifiedby = Auth::user()->id;
         $model->modifieddate = date("Y-m-d H:i:s");
     });
     static::updated(function ($model) {
         Log::create(['employeeid' => Auth::user()->id, 'operation' => 'Update', 'date' => date("Y-m-d H:i:s"), 'model' => class_basename(get_class($model)), 'detail' => $model->toJson()]);
     });
     static::deleted(function ($model) {
         Log::create(['employeeid' => Auth::user()->id, 'operation' => 'Delete', 'date' => date("Y-m-d H:i:s"), 'model' => class_basename(get_class($model)), 'detail' => $model->toJson()]);
     });
 }
 public function check_dup_carsubmodel(Request $request)
 {
     if (!$this->hasPermission($this->menuPermissionName)) {
         return view($this->viewPermissiondeniedName);
     }
     $input = $request->only('id', 'commissionfinaceid', 'carmodelid', 'carsubmodelid');
     $model = CommissionFinaceCar::where('id', '!=', $input['id'])->where('commissionfinaceid', $input['commissionfinaceid'])->where('carmodelid', $input['carmodelid'])->where('carsubmodelid', 0)->first();
     if ($model != null) {
         return "แบบรถนี้ ทุกรุ่น มีอยู่ในระบบแล้ว";
     }
     if ($input['carsubmodelid'] != 0) {
         $model = CommissionFinaceCar::where('id', '!=', $input['id'])->where('commissionfinaceid', $input['commissionfinaceid'])->where('carmodelid', $input['carmodelid'])->where('carsubmodelid', $input['carsubmodelid'])->first();
         if ($model != null) {
             return "แบบรถนี้ รุ่น " + $model->carsubmodel->name + " มีอยู่ในระบบแล้ว";
         }
     }
 }