/** * Execute the console command. * * @return mixed */ public function fire() { Log::alert('Executed Cron Job'); $KarmaNotePending = Meetingrequest::where('status', '=', 'confirmed')->where('cronjobflag', '=', '0')->get(); if (!empty($KarmaNotePending)) { foreach ($KarmaNotePending as $key => $value) { $meetingtimezone = $value->meetingtimezone; $meetingdatetime = $value->meetingdatetime; $user_id_giver = $value->user_id_giver; $user_id_receiver = $value->user_id_receiver; $meetingId = $value->id; $CurrentTimeWithZone = KarmaHelper::calculateTime($meetingtimezone); //echo "<pre>";print_r($meetingdatetime);echo "</pre>"; //echo "<pre>";print_r($meetingdatetime);echo "</pre>";die(); if ($CurrentTimeWithZone > $meetingdatetime) { $diffDate = KarmaHelper::dateDiff($CurrentTimeWithZone, $meetingdatetime); $diffDate = $diffDate->days * 24 + $diffDate->h; $EmailTriggerTime = Adminoption::where('option_name', '=', 'KarmaNote Email Trigger Time')->first(); if (!empty($EmailTriggerTime)) { $EmailTriggerTime = $EmailTriggerTime->toArray(); $EmailTriggerTime = $EmailTriggerTime['option_value']; } else { $EmailTriggerTime = '24'; } if ($diffDate >= $EmailTriggerTime) { //$date = Carbon::now()->addMinutes(5); Queue::push('MessageSender', array('type' => '4', 'user_id_giver' => $user_id_giver, 'user_id_receiver' => $user_id_receiver, 'meetingId' => $meetingId)); $Meetingrequest = Meetingrequest::find($meetingId); $Meetingrequest->cronjobflag = '1'; $Meetingrequest->status = 'over'; $Meetingrequest->save(); DB::table('users_mykarma')->where('entry_id', '=', $meetingId)->update(array('status' => 'over', 'unread_flag' => 'true', 'entry_updated_on' => Carbon::now())); $messageData = new Message(); $messageData->request_id = $meetingId; $messageData->sender_id = $user_id_giver; $messageData->giver_id = $user_id_giver; $messageData->receiver_id = $user_id_receiver; $messageData->message_type = 'system'; $messageText = 'Meeting should be over now.'; $messageData->messageText = $messageText; $messageData->save(); //Queue::push('UpdateUser', array('id' => $user_id,'result' => $result)); } } } } }
public static function MeetingRequestMailNonKc($type, $connection_giverId, $receiverId, $meetingId, $giver_email) { $type = 16; $receiverDetail = User::find($receiverId); $giverDetail = Connection::find($connection_giverId); $ReceiverName = $receiverDetail->fname . ' ' . $receiverDetail->lname; $url = KarmaHelper::generateURL($meetingId, $receiverDetail, $giverDetail, '0'); $meetingDetail = Meetingrequest::find($meetingId); $to = $giver_email; $fullname = $giverDetail->fname . ' ' . $giverDetail->lname; $promises_email = ""; if ($meetingDetail->payitforward + $meetingDetail->sendKarmaNote + $meetingDetail->buyyoucoffee != 0) { $promises_email = "In gratitude, I shall do the following:<br>"; if ($meetingDetail->payitforward == '1') { $promises_email = $promises_email . "I'll pay it forward.<br>"; } if ($meetingDetail->sendKarmaNote == '1') { $promises_email = $promises_email . " I'll send you a Karma Note.<br>"; } if ($meetingDetail->buyyoucoffee == '1') { $promises_email = $promises_email . " I'll buy you coffee (in-person meetings only).<br>"; } } $besttime = $meetingDetail->weekday_call . ' ' . $meetingDetail->weekday_call_time; $subject = "KarmaMeeting request from " . $receiverDetail->fname . " " . $receiverDetail->lname; $meetingSubject = $meetingDetail->subject; Mail::send('emails.requestmeetingnonkc', array('Note' => $meetingDetail->notes, 'Besttime' => $besttime, 'Points' => $promises_email, 'giverDetail' => $giverDetail, 'receiverDetail' => $receiverDetail, 'subject' => $meetingSubject, '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 to request new time. * * @return Response */ public static function commonMeetingRequestNewTime($meetingId, $userId) { $getUser = User::find($userId); $meetingDetail = Meetingrequest::find($meetingId); $meetingDetail->meetingduration = 'null'; $meetingDetail->meetingtimezonetext = 'null'; $meetingDetail->meetingtimezone = 'null'; $meetingDateTime = 'null'; $meetingDetail->meetingdatetime = 'null'; $meetingDetail->meetinglocation = 'null'; $meetingDetail->meetingtimezone = 'null'; $meetingDetail->meetingtype = 'null'; $meetingDetail->req_updatedate = KarmaHelper::currentDate(); $meetingDetail->reply = 'null'; $meetingDetail->status = 'responded'; $meetingDetail->save(); $userRole = 'Receiver'; DB::table('users_mykarma')->where('entry_id', '=', $meetingId)->update(array('status' => 'responded', 'entry_updated_on' => Carbon::now())); $changeStatus = KarmaHelper::updateMeetingStatus($meetingId, $userRole); $getGiverData = DB::table('requests')->join('users', 'requests.user_id_giver', '=', 'users.id')->where('requests.id', '=', $meetingId)->select('users.fname', 'users.lname', 'requests.user_id_giver', 'requests.user_id_receiver', 'requests.status')->get(); //Add message in requests_messages table if (!empty($getGiverData)) { $messageData = new Message(); $messageData->request_id = $meetingId; $messageData->sender_id = $userId; $messageData->giver_id = $getGiverData[0]->user_id_giver; $messageData->receiver_id = $userId; $messageText = $getUser->fname . ' ' . $getUser->lname . ' has requested a new time for the meeting.'; $messageData->messageText = $messageText; $messageData->save(); } else { $getGiverData = array(); } return $getGiverData; }
/** * 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'); } }
public function loadmoreProfile() { //Karma notes block $karmaTrailUser = $karmaReceivedUser = $karmaSentUser = ''; $profileSelf = 0; $CurrentUserDetail = ""; $CurrentUserId = 0; if (!empty($_REQUEST)) { $start = $_REQUEST['hitcount'] + 1; $action = $_REQUEST['action']; $id = $_REQUEST['userProfile']; $perpage = 10; $profileUserDetail = User::find($id); if (Auth::check()) { $CurrentUserDetail = Auth::User(); $CurrentUserId = $CurrentUserDetail->id; if ($CurrentUserId == $profileUserDetail['id']) { $profileSelf = "1"; } else { $profileSelf = "0"; } } if ($action == 'KarmaTrail') { $karmaTrail = KarmaHelper::getKarmaTrail($id, $start, $perpage); if (count($karmaTrail) > 0) { foreach ($karmaTrail as $trail) { $userSkills = ""; $karma['user_id_receiver'] = User::find($trail->user_id_receiver)->toArray(); if (!empty($trail->user_id_giver)) { $karma['user_id_giver'] = User::find($trail->user_id_giver)->toArray(); } else { $karma['user_id_giver'] = Connection::find($trail->connection_id_giver)->toArray(); } if ($id == $trail->user_id_receiver) { $karma['status'] = $trail->statusreceiver; } else { $karma['status'] = $trail->statusgiver; } $karma['piclink'] = $trail->piclink; $karma['karmaNotes'] = $trail->details; if (!empty($trail->skills)) { $userSkills = KarmaHelper::getSkillsname($trail->skills); } $karma['skills'] = $userSkills; $karma['req_id'] = $trail->req_id; $karma['meetingdatetime'] = date('F d, Y', strtotime($trail->meetingdatetime)); $karma['created_at'] = date('F d, Y', strtotime($trail->created_at)); $karmaTrailUser[] = $karma; } } } //echo "<pre>";print_r($karmaTrailUser);echo "</pre>";die; if ($action == 'KarmaNotesReceived') { $karmaReceived = $profileUserDetail->KarmanoteReceiver()->orderBy('karmanotes.created_at', 'desc')->skip($start)->take($perpage)->get(); if (!empty($karmaReceived)) { foreach ($karmaReceived->toArray() as $received) { $userReceivedSkills = ""; $karmareceived['user_id_receiver'] = User::find($received['user_idreceiver'])->toArray(); if (!empty($received['user_id_giver'])) { $karmareceived['user_id_giver'] = User::find($received['user_idgiver'])->toArray(); } else { $karmareceived['user_id_giver'] = Connection::find($received['connection_idgiver'])->toArray(); } $karmareceived['karmaNotes'] = $received['details']; if (!empty($received['skills'])) { $userReceivedSkills = KarmaHelper::getSkillsname($received['skills']); } $karmareceived['skills'] = $userReceivedSkills; $karmareceived['status'] = $received['statusgiver']; $karmareceived['req_id'] = $received['req_id']; $karmareceived['req_detail'] = Meetingrequest::find($received['req_id']); $karmareceived['created_at'] = date('F d, Y', strtotime($received['created_at'])); $karmaReceivedUser[] = $karmareceived; } } } //echo "<pre>";print_r($karmaReceived->toArray());echo "</pre>";die; if ($action == 'KarmaNotesSent') { $karmaSent = $profileUserDetail->KarmanoteGiver()->orderBy('karmanotes.created_at', 'desc')->skip($start)->take($perpage)->get(); //echo "<pre>";print_r($karmaSent->toArray());echo "</pre>";die; if (!empty($karmaSent)) { foreach ($karmaSent->toArray() as $sent) { $userSentSkills = ""; $karmasent['user_id_receiver'] = User::find($sent['user_idreceiver'])->toArray(); if (!empty($sent['user_idgiver'])) { $karmasent['user_id_giver'] = User::find($sent['user_idgiver'])->toArray(); } else { $karmasent['user_id_giver'] = Connection::find($sent['connection_idgiver'])->toArray(); } $karmasent['karmaNotes'] = $sent['details']; if (!empty($sent['skills'])) { $userSentSkills = KarmaHelper::getSkillsname($sent['skills']); } $karmasent['skills'] = $userSentSkills; $karmasent['req_id'] = $sent['req_id']; $karmasent['req_detail'] = Meetingrequest::find($sent['req_id'])->toArray(); $karmasent['status'] = $sent['statusreceiver']; $karmasent['created_at'] = date('F d, Y', strtotime($sent['created_at'])); $karmaSentUser[] = $karmasent; } } } return View::make('ajax_loadmoreProfile', array('id' => $id, 'CurrentUserDetail' => $CurrentUserDetail, 'profileSelf' => $profileSelf, 'karmaTrail' => $karmaTrailUser, 'profileUserDetail' => $profileUserDetail, 'countTrail' => 0, 'countReceived' => 0, 'countSent' => 0, 'profielURL' => '', 'karmascore' => '', 'karmaReceived' => $karmaReceivedUser, 'karmaSent' => $karmaSentUser)); } }