public static function SendEmailToNonKarma($type, $connection_giverId, $receiverId, $meetingId, $giver_email) { $type = 14; $receiverDetail = User::find($receiverId); $giverDetail = Connection::find($connection_giverId); $ReceiverName = $receiverDetail->fname . ' ' . $receiverDetail->lname; $subject = "KarmaNote received from " . $receiverDetail->fname . " " . $receiverDetail->lname; $fullname = $giverDetail->fname . ' ' . $giverDetail->lname; $to = $giver_email; // fetch $karmaNoteDetail = Karmanote::where('req_id', '=', $meetingId)->first(); $url = KarmaHelper::generateURL($meetingId, $receiverDetail, $giverDetail, '0'); $message_email = array(); $message_email['karmanote'] = $karmaNoteDetail->details; $message_email['skills'] = KarmaHelper::getSkillsname($karmaNoteDetail->skills); Mail::send('emails.nonkcusernoterecieved', array('Content' => $message_email, 'giverDetail' => $giverDetail, 'receiverDetail' => $receiverDetail, 'subject' => $subject, 'url' => $url), function ($message) use($to, $subject, $fullname, $giverDetail, $receiverDetail) { $from = $receiverDetail->fname . ' ' . $receiverDetail->lname; $fromname = $from . " via karmacircles"; $message->to($to, $fullname)->replyTo($receiverDetail->email, $from)->subject($subject)->from('*****@*****.**', $fromname); }); }
/** * Function name: updateKarmaNoteStatus() * Created by : Evon * Created on : 04/10/2014 * Arguments : $noteId, $status **/ public function updateKarmaNoteStatus() { $CurrentUser = Auth::user(); $user_id = $noteId = $status = ''; $user_id = Input::get('user_id'); $noteId = Input::get('noteId'); $status = Input::get('status'); $publicPage = Input::get('publicPage'); if ($user_id && $noteId && $status) { if ($user_id == 'receiver') { $updateColumn = 'statusreceiver'; } else { $updateColumn = 'statusgiver'; } if ($status == 'Hide') { $updateStatus = 'hidden'; } elseif ($status == 'Show') { $updateStatus = 'visible'; } $KarmaNotes = Karmanote::find($noteId); $KarmaNotes->{$updateColumn} = $updateStatus; $KarmaNotes->save(); $KarmaNotes = $KarmaNotes->toArray(); $Meetingrequest = Meetingrequest::find($KarmaNotes['req_id']); $receiverDetail = User::find($Meetingrequest->user_id_receiver)->toArray(); //echo "<pre>";print_r($Meetingrequest);echo "</pre>";die; if (!empty($Meetingrequest->user_id_giver)) { $giverDetail = User::find($Meetingrequest->user_id_giver)->toArray(); } else { $giverDetail = Connection::find($Meetingrequest->connection_id_giver)->toArray(); } if ($publicPage == '1') { return Redirect::to('profile/' . strtolower($CurrentUser->fname . '-' . $CurrentUser->lname) . '/' . $CurrentUser->id); } else { return Redirect::to('KarmaNotes'); } } else { return Redirect::to('404'); } }
/** * Function to change the status to anystate to meeting happened. * * @return Response */ public static function meetingData($accessToken, $userId, $meetingId, $userRole) { $getUser = User::where('id', '=', $userId)->first(); $meetingData = array(); $meetingData = Meetingrequest::where('id', '=', $meetingId)->select('status', 'notes', 'meetingtype', 'user_id_receiver', 'user_id_giver')->first(); $meetingStatusText = KarmaHelper::getMykarmaMessageForReceiverGiver($meetingData->status, $userRole); if (!empty($meetingData)) { if ($userRole == 'Receiver') { $userProfileId = $meetingData->user_id_giver; $userProfilePic = User::where('id', '=', $userProfileId)->select('piclink')->first(); $userProfilePicLink = $userProfilePic->piclink; DB::table('users_mykarma')->where('entry_id', '=', $meetingId)->where('users_role', '=', 'Receiver')->update(array('unread_flag' => 'false', 'no_of_unread_items' => '0')); } if ($userRole == 'Giver') { $userProfileId = $meetingData->user_id_receiver; if ($userProfileId == '' || $userProfileId == 'null') { $userProfilePicLink = 'null'; } else { $userProfilePic = User::where('id', '=', $userProfileId)->select('piclink')->first(); $userProfilePicLink = $userProfilePic->piclink; } DB::table('users_mykarma')->where('entry_id', '=', $meetingId)->where('users_role', '=', 'Giver')->update(array('unread_flag' => 'false', 'no_of_unread_items' => '0')); } $meetingDetailData = new ArrayObject(); $karmaNoteDetailData = new ArrayObject(); $meetingTrailData = new ArrayObject(); $meetingTrailData = DB::table('requests_messages')->where('request_id', '=', $meetingId)->orderBy('created_at', 'ASC')->get(); $meetingNote = Meetingrequest::where('id', '=', $meetingId)->select('notes')->first(); $meetingMessageData = array(); if (!empty($meetingTrailData)) { foreach ($meetingTrailData as $key => $value) { if ($value->message_type == 'user') { if ($value->sender_id == $value->giver_id) { $meetingMessageData[$key]['messageUser'] = '******'; $meetingMessageData[$key]['userId'] = $value->giver_id; } else { if ($value->sender_id == $value->receiver_id) { $meetingMessageData[$key]['messageUser'] = '******'; $meetingMessageData[$key]['userId'] = $value->receiver_id; } } } else { $meetingMessageData[$key]['messageUser'] = '******'; $meetingMessageData[$key]['userId'] = '0'; } $meetingMessageData[$key]['messageText'] = $value->messageText; $meetingMessageData[$key]['MeetingMessage'] = $meetingNote->notes; $meetingMessageData[$key]['date'] = date('Y-m-d H:i:s', strtotime($value->created_at)); } } if ($meetingData->status == 'scheduled' || $meetingData->status == 'confirmed') { $noteData = Meetingrequest::where('id', '=', $meetingId)->first(); $meetingDetailData['payitforward'] = $noteData->payitforward; $meetingDetailData['sendKarmaNote'] = $noteData->sendKarmaNote; $meetingDetailData['buyyoucoffee'] = $noteData->buyyoucoffee; $meetingDetailData['reply'] = $noteData->reply; $meetingDetailData['status'] = $noteData->status; $meetingDetailData['meetingduration'] = $noteData->meetingduration; $meetingDetailData['meetingdatetime'] = $noteData->meetingdatetime; $meetingDetailData['meetingtimezone'] = $noteData->meetingtimezone; $meetingDetailData['meetingtimezonetext'] = $noteData->meetingtimezonetext; $meetingDetailData['weekday_call_time'] = $noteData->weekday_call_time; $meetingDetailData['meetinglocation'] = $noteData->meetinglocation; $meetingDetailData['meetingtype'] = $noteData->meetingtype; $dstValue = Adminoption::Where('option_name', '=', 'Set DST value')->select("option_value")->first(); $dstValueData = $dstValue->option_value; $meetingDetailData['dstValueData'] = $dstValueData; return array('meetingStatus' => $meetingData->status, 'meetingData' => $meetingDetailData, 'meetingTrailData' => $meetingMessageData, 'meetingUserId' => $userProfileId, 'userProfilePic' => $userProfilePicLink, 'meetingStatusText' => $meetingStatusText); } else { if ($meetingData->status == 'completed') { $noteData = Karmanote::where('karmanotes.req_id', '=', $meetingId)->first(); if ($noteData->sendKarmaNote == '' || $noteData->sendKarmaNote == 'null') { $noteData->skills = array(); } $receiverData = User::where('id', '=', $noteData->user_idreceiver)->first(); $giverData = User::where('id', '=', $noteData->user_idgiver)->first(); $karmaNoteDetailData['karmaNoteId'] = $noteData->id; $karmaNoteDetailData['status'] = $meetingData->status; $karmaNoteDetailData['skillTag'] = $noteData->skills; $karmaNoteDetailData['karmaNoteDetail'] = $noteData->details; $karmaNoteDetailData['receiver_id'] = $noteData->user_idreceiver; $karmaNoteDetailData['giver_id'] = $noteData->user_idgiver; $karmaNoteDetailData['description'] = $noteData->meetingduration; $karmaNoteDetailData['receiverFirstName'] = $receiverData->fname; $karmaNoteDetailData['receiverLastName'] = $receiverData->lname; $karmaNoteDetailData['receiverPic'] = $receiverData->piclink; $karmaNoteDetailData['giverFirstName'] = $giverData->fname; $karmaNoteDetailData['giverLastName'] = $giverData->lname; $karmaNoteDetailData['giverPic'] = $giverData->piclink; $karmaNoteDetailData['receiverHeadline'] = $receiverData->headline; $karmaNoteDetailData['giverHeadline'] = $giverData->headline; $site_url = URL::to('/'); $publicUrl = $site_url . '/meeting/' . $receiverData->fname . '-' . $receiverData->lname . '-' . $giverData->fname . '-' . $giverData->fname . '/' . $meetingId; $karmaNoteDetailData['publicUrl'] = $publicUrl; return array('meetingStatus' => $meetingData->status, 'karmaNoteData' => $karmaNoteDetailData, 'meetingTrailData' => $meetingMessageData, 'meetingUserId' => $userProfileId, 'userProfilePic' => $userProfilePicLink, 'meetingStatusText' => $meetingStatusText); } else { return array('meetingStatus' => $meetingData->status, 'meetingTrailData' => $meetingMessageData, 'meetingUserId' => $userProfileId, 'userProfilePic' => $userProfilePicLink, 'meetingStatusText' => $meetingStatusText); } } } return false; }
public static function otherProfileTrail() { $karmacircleFeed = Karmafeed::select('message_type As type', 'id_type', 'receiver_id', 'giver_id', 'updated_at')->get(); foreach ($karmacircleFeed as $karmaFeed) { $receiverId = $karmaFeed->receiver_id; $giverId = $karmaFeed->giver_id; $karmaFeedMessage = $karmaFeed->type; $karmaFeedId = $karmaFeed->id_type; $karmaFeedDate = $karmaFeed->updated_at; if (!empty($receiverId)) { $receiverData = User::where('id', '=', $receiverId)->select('fname As receiverFirstName', 'lname As receiverLastName', 'piclink As receiverPic')->first(); } if (!empty($giverId)) { $giverData = User::where('id', '=', $giverId)->select('fname As giverFirstName', 'lname As giverLastName', 'piclink As giverPic')->first(); } if ($karmaFeedMessage == 'KarmaNote') { $getKarmaNoteDetails = Karmanote::where('id', '=', $karmaFeedId)->select(array('karmanotes.details As description'))->first(); $karmaNoteFeed[] = array_merge($karmaFeed->toArray(), $getKarmaNoteDetails->toArray(), $giverData->toArray(), $receiverData->toArray()); } else { $karmacircleFeedCount = DB::table('users_karmafeeds')->where('message_type', '=', 'KarmaNote')->count(); if ($karmacircleFeedCount < 1) { $karmaNoteFeed = array(); } } if ($karmaFeedMessage == 'Group') { $getGroupDetails = Group::where('id', '=', $karmaFeedId)->select(array('groups.name As name', 'groups.description As description'))->first(); $groupFeed[] = array_merge($karmaFeed->toArray(), $getGroupDetails->toArray(), $receiverData->toArray()); } else { $karmacircleGroupCount = DB::table('users_karmafeeds')->where('message_type', '=', 'Group')->count(); if ($karmacircleGroupCount < 1) { $groupFeed = array(); } } if ($karmaFeedMessage == 'KarmaQuery') { $getQueryDetails = Question::where('id', '=', $karmaFeedId)->select(array('questions.queryStatus As queryStatus', 'questions.description As description'))->first(); $queryFeed[] = array_merge($karmaFeed->toArray(), $getQueryDetails->toArray(), $receiverData->toArray()); } else { $karmacircleQueryCount = DB::table('users_karmafeeds')->where('message_type', '=', 'Question')->count(); if ($karmacircleQueryCount < 1) { $queryFeed = array(); } } if ($karmaFeedMessage == 'OfferHelpTo') { $getOfferHelpDetails = Question::where('id', '=', $karmaFeedId)->select(array('questions.queryStatus As queryStatus', 'questions.description As description'))->first(); $getOfferHelpCount = Questionwillingtohelp::has('id')->where('user_id', '=', $receiverId)->where('question_id', '=', $karmaFeedId)->count(); $offerHelpToFeed[] = array_merge($karmaFeed->toArray(), $getOfferHelpDetails->toArray(), $receiverData->toArray(), $giverData->toArray()); } else { $offerHelpToFeedCount = DB::table('users_karmafeeds')->where('message_type', '=', 'OfferHelpTo')->count(); if ($offerHelpToFeedCount < 1) { $offerHelpToFeed = array(); } } } $feed = array_merge($karmaNoteFeed, $groupFeed, $queryFeed); $sort = array(); foreach ($feed as $k => $v) { $sort['updated_at'][$k] = $v['updated_at']; } array_multisort($sort['updated_at'], SORT_DESC, $feed); echo "<pre>"; print_r($arr); die; echo '<pre>'; print_r($feed); die; }
public static function commonConnection($userId, $otherUserId) { $usersFirstCommonConnectionGiver = Karmanote::where('user_idreceiver', '=', $userId)->where('user_idgiver', '<>', 'null')->select('user_idgiver')->distinct('user_idgiver')->get(); $usersFirstCommonConnectionReceiver = Karmanote::where('user_idgiver', '=', $userId)->where('user_idreceiver', '<>', 'null')->select('user_idreceiver')->distinct('user_idreceiver')->get(); $userFirstData = array_merge($usersFirstCommonConnectionGiver->toArray(), $usersFirstCommonConnectionReceiver->toArray()); foreach ($userFirstData as $key => $value) { if (isset($value['user_idreceiver'])) { $userFirstCommonId[] = $value['user_idreceiver']; } if (isset($value['user_idgiver'])) { $userFirstCommonId[] = $value['user_idgiver']; } } $userFirstCommonIdResult = array_unique($userFirstCommonId); $usersSecondCommonConnectionGiver = Karmanote::where('user_idreceiver', '=', $otherUserId)->where('user_idgiver', '<>', 'null')->select('user_idgiver')->distinct('user_idgiver')->get(); $usersSecondCommonConnectionReceiver = Karmanote::where('user_idgiver', '=', $otherUserId)->where('user_idreceiver', '<>', 'null')->select('user_idreceiver')->distinct('user_idreceiver')->get(); $userSecondData = array_merge($usersSecondCommonConnectionGiver->toArray(), $usersSecondCommonConnectionReceiver->toArray()); foreach ($userSecondData as $key => $value) { if (isset($value['user_idreceiver'])) { $userSecondCommonId[] = $value['user_idreceiver']; } if (isset($value['user_idgiver'])) { $userSecondCommonId[] = $value['user_idgiver']; } } $userSecondCommonIdResult = array_unique($userSecondCommonId); $commonUser = array_intersect($userFirstCommonIdResult, $userSecondCommonIdResult); $countCommonConnection = count($commonUser); return $countCommonConnection; }
public function deleteUser() { $id = Input::get('userId'); $test_user = DB::table('admin_option')->where('option_name', 'Test User Emails')->select('option_value')->get(); if (!empty($test_user)) { $count = 0; foreach ($test_user as $value) { foreach (explode(',', $value->option_value) as $test_user_id) { if ($id == $test_user_id) { $count = $count + 1; } } } } else { $count = 0; } if ($count > 0) { $connections = Connection::Where('user_id', '=', $id)->first(); if (!empty($connections)) { $connections->user_id = null; $connections->save(); } $deletekarmanote = Karmanote::where('user_idreceiver', '=', $id)->delete(); $deletekarmanote = Karmanote::where('user_idgiver', '=', $id)->delete(); $deleterequest = Meetingrequest::where('user_id_receiver', '=', $id)->delete(); $deletekarmanote = Meetingrequest::where('user_id_giver', '=', $id)->delete(); $deletekarmanote = Meetingrequest::where('user_id_introducer', '=', $id)->delete(); $deleteusergroups = Usersgroup::where('user_id', '=', $id)->delete(); $findquestion = Question::Where('user_id', '=', $id)->get(); if (!empty($findquestion)) { foreach ($findquestion as $val) { $question_id = $val->id; $findgroupquestion = Groupquestion::Where('question_id', '=', $question_id)->get(); if (!empty($findgroupquestion)) { $deletegroupquestion = Groupquestion::Where('question_id', '=', $question_id)->delete(); } $findQuestionwillingtohelp = Questionwillingtohelp::Where('question_id', '=', $question_id)->get(); if (!empty($findQuestionwillingtohelp)) { $deleteQuestionwillingtohelp = Questionwillingtohelp::Where('question_id', '=', $question_id)->delete(); } } } $deleteQuestionwillingtohelp = Questionwillingtohelp::Where('user_id', '=', $id)->delete(); if (!empty($findquestion)) { $deletequestion = Question::where('user_id', '=', $id)->delete(); } $deletekarmacircles = Karmacircle::where('user_id', '=', $id)->delete(); $deletekarmaFeed = Karmafeed::where('receiver_id', '=', $id)->orWhere('giver_id', '=', $id)->delete(); $userMykarmaDelete = Mykarma::where('user_id', '=', $id)->delete(); $userMessageDelete = Message::where('receiver_id', '=', $id)->orWhere('giver_id', '=', $id)->delete(); $getIntroDataDelete = KarmaIntro::where('intro_giver_id', '=', $id)->orWhere('intro_receiver_id', '=', $id)->orWhere('intro_introducer_id', '=', $id)->delete(); $getMyKarmaDataDelete = Mykarma::where('user_id', '=', $id)->delete(); $user = User::find($id); $user->delete(); echo "User " . $id . " deleted"; } else { echo "User " . $id . " cant be deleted.Its not a test user."; } }