public function load($innovator_id)
{
if (User::where('hash_id', '=', $innovator_id)->first() == null) {
return null;
} else {
return User::where('hash_id', '=', $innovator_id)->with('investor_request', 'prof_pic')->first();
}
}
/**
* Handles confirmation of the link
* @param $request_link
* @return int
*/
public function confirm($request_link)
{
if (Bongo_request::where('request_link', '=', $request_link)->first() == null) {
return 0;
} elseif (Bongo_request::where('request_link', '=', $request_link)->first()->request_status != 1) {
return 0;
} else {
$request = Bongo_request::where('request_link', '=', $request_link)->first();
$created = new Carbon($request->created_at);
$now = Carbon::now();
$difference = $created->diff($now)->days > 7 ? $request->update(['request_status' => 2]) : $request->update(['request_status' => 1]);
if ($request = Bongo_request::where('request_link', '=', $request_link)->first()) {
if (\Md\User::where('email', '=', $request->bongo_email)->first() != null) {
return 1;
} else {
return 2;
}
}
}
}
public function getModeratorWithLeast()
{
$leastModeration_count = User::where('userCategory', '=', 5)->min('moderation_count');
return User::where('userCategory', '=', 5)->where('moderation_count', '=', $leastModeration_count)->first()->id;
}
/**
* Retrieves a specific innovation with its related data
* @param $id
* @param ConversationRepository $conversationRepository
* @return \Illuminate\View\View
*/
public function show($id, ConversationRepository $conversationRepository)
{
$innovation = $this->repo->retrieve($id);
$check_chat = $conversationRepository->chatExists($id);
$currentUserId = Auth::user()->id;
$chatWithInnovator = $conversationRepository->checkChatWithInnovator($id);
$mother = User::where('id', '=', $innovation->moderator_id)->first();
$users = User::where('userCategory', '=', 3)->get();
$investors = User::where('userCategory', '=', 2)->get();
// All threads that user is participating in
$threads = Thread::forUser($currentUserId)->where('innovation_id', '=', $id)->get();
$threads_count = $threads->count();
if (\Auth::user()->isInvestor()) {
if (Thread::where('innovation_id', '=', $id)->where('user_id', '=', \Auth::user()->id)->exists() == true) {
$thread = Thread::where('innovation_id', '=', $id)->where('user_id', '=', \Auth::user()->id)->first();
}
}
if (\Auth::user()->isMother()) {
if (Thread::where('innovation_id', '=', $id)->where('user_id', '=', \Auth::user()->id)->exists() == true) {
$thread_mother = Thread::where('innovation_id', '=', $id)->where('user_id', '=', \Auth::user()->id)->first();
} else {
$thread_mother = null;
}
}
$funds = $this->repo->getPortfolio($id);
$totalNeeded = $this->repo->getInnovationFund($id);
return view('innovation.show', compact('totalNeeded', 'funds', 'thread_mother', 'thread', 'investors', 'mother', 'users', 'chatWithInnovator', 'innovation', 'id', 'check_chat', 'message', 'threads', 'threads_count', 'currentUserId'));
}
/**
* Creates a new message thread
*
* @return mixed
*/
public function create()
{
$users = User::where('id', '!=', Auth::id())->get();
return view('messenger.create', compact('users'));
}
/**
* Creates a conversation thread with mother
* @param $innovation_id
* @return \Illuminate\Contracts\View\Factory|\Illuminate\View\View
*/
public function createMother($innovation_id)
{
$users = User::where('id', '=', 1)->get();
return view('messenger.with_subject', compact('users', 'innovation_id'));
}
