public function grantversions($prop_id) { $a = new \App\Proposal(); //$arr=$a->where('id','=',$prop_id)->get(); $users = Auth::user()->user(); $arr = \App\Proposal::join('proposal_versions', 'proposals.id', '=', 'proposal_versions.proposal_id')->join('proposal_comments', 'proposal_versions.id', '=', 'proposal_comments.proposal_version_id')->where('proposals.userid', '=', $users->id)->whereNull('proposal_versions.deleted_at')->orderby('proposals.id', 'DESC')->get(); return view('frontend.researchgrant.grantversions', compact('arr')); }
public function makechanges($id) { $var = INPUT::all(); $obj = new \App\proposal_comment(); $obj1 = new \App\proposal_version(); $mod = \App\Proposal::join('proposal_versions', 'proposals.id', '=', 'proposal_versions.proposal_id')->where('proposals.id', '=', $id)->orderby('proposal_versions.id', 'DESC')->select('proposal_versions.id')->first(); $obj->comments = $var['comments']; $obj->type = 1; $obj->proposal_version_id = $mod->id; $obj->save(); $obj1 = $obj1::find($mod->id); $obj1->research_status = $var['status']; $obj1->save(); /*return $mod->id; if($var['status']) { if($var['status']==0) { $obj1->research_status=0; //$obj1->save(); } if($var['status']==1) { $obj1->research_status=1; // $obj1->save(); } /* if($var['status']==2) { $obj1->research_status=2; $obj1->save(); }*/ /*if($var['status']==3) { $obj1->research_status=3; $obj1->save(); }*/ // $obj1->save(); return $this->allgrants(); //return $var['status']; }