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'];
}
