<?php

namespace App;
use App\AuditTrail;
use Illuminate\Database\Eloquent\Model;

class UsersDb extends Model
{
    protected $table = 'users_db';

    public function annexure_1(){
      return $this->hasOne('App\Annexure_One','id','userid');
    }
    public function annexure_2(){
      return $this->hasOne('App\Annexure_Two','id','userid');
    }

    public function annexure_3(){
      return $this->hasOne('App\Annexure_Three','id','userid');
    }

    public function annexure_4(){
      return $this->hasOne('App\Annexure_Four','id','userid');
    }

    public function annexure_5(){
      return $this->hasOne('App\Annexure_Five','id','userid');
    }

    public function annexure_6(){
      return $this->hasOne('App\Annexure_Six','id','userid');
    }

    public function annexure_7(){
      return $this->hasOne('App\Annexure_Seven','id','userid');
    }

    public function annexure_8(){
      return $this->hasOne('App\Annexure_Eight','id','userid');
    }

    public function annexure_9(){
      return $this->hasOne('App\Annexure_Nine','id','userid');
    }

    public function annexure_10(){
      return $this->hasOne('App\Annexure_Ten','id','userid');
    }

    public function annexure_11(){
      return $this->hasOne('App\Annexure_Eleven','id','userid');
    }

    public function annexure_12(){
      return $this->hasOne('App\Annexure_Twelve','id','userid');
    }

    public function annexure_13(){
      return $this->hasOne('App\Annexure_Thirteen','id','userid');
    }

    public function annexure_14(){
      return $this->hasOne('App\Annexure_Fourteen','id','userid');
    }

    public function annexure_15(){
      return $this->hasOne('App\Annexure_Fifteen','id','userid');
    }

    public function annexure_16(){
      return $this->hasOne('App\Annexure_Sixteen','id','userid');
    }

    public function coi(){
      return $this->hasOne('App\ConflictOfInterest','id','userid');
    }

    public function annex_status(){
      return $this->hasOne('App\Annexure_Status','userid','id');
    }
    public function log($message) {
            $message = ucwords($message);
            AuditTrail::query()->create([
                'userid'   => $this->id,
                'name' => empty($this->name) ? $this->email : $this->name,
                'date'      => \Carbon\Carbon::now()->toDateTimeString(),
                'activity'  => $this->name. ": {$message}"
            ]);
        }

    // public function deleteRelation()
    //   {
    //       // delete all relationship
    //       $this->annexure_1()->delete();
    //       $this->annexure_2()->delete();
    //       $this->annexure_3()->delete();
    //       $this->annexure_4()->delete();
    //       $this->annexure_5()->delete();
    //       $this->annexure_6()->delete();
    //       $this->annexure_7()->delete();
    //       $this->annexure_8()->delete();
    //       $this->annexure_9()->delete();
    //       $this->annexure_10()->delete();
    //       $this->annexure_11()->delete();
    //       $this->annexure_12()->delete();
    //       $this->annexure_13()->delete();
    //       $this->annexure_14()->delete();
    //       $this->annexure_15()->delete();
    //       $this->annexure_16()->delete();
    //       $this->coi()->delete();
    //       $this->annex_status()->delete();
    //
    //
    //   }
}