/** * Execute the console command. * * @return mixed */ public function fire() { Log::alert('Executed Cron Job to send weekly mail for pending karma note and meeting requests.'); $KarmaNotePending = ""; $KarmaNotePending = Meetingrequest::whereIn('status', array('pending', 'accepted'))->get(); if (!empty($KarmaNotePending)) { $test_id = ""; $test_id = Adminoption::Where('option_name', '=', 'Test User Emails')->first(); $test_user_id = $getfintrorecords = array(); if (!empty($test_id)) { $test_user_id = explode(',', $test_id->option_value); } $introducer = $giver = $receiver = $connidgiver = ''; foreach ($KarmaNotePending as $key => $value) { $diffDate = KarmaHelper::dateDiff(date("Y-m-d H:i:s"), $value->created_at); if (isset($value->user_id_giver)) { $giver = in_array($value->user_id_giver, $test_user_id); } if (isset($value->user_id_receiver)) { $receiver = in_array($value->user_id_receiver, $test_user_id); } if (isset($value->connection_id_giver)) { $connidgiver = in_array($value->connection_id_giver, $test_user_id); } if (isset($value->user_id_introducer)) { $introducer = in_array($value->user_id_introducer, $test_user_id); } if ($giver != 1 && $receiver != 1 && $connidgiver != 1 && $introducer != 1) { if ($diffDate->days > 7) { $meetingtimezone = $value->meetingtimezone; $meetingdatetime = $value->meetingdatetime; $user_id_giver = $value->user_id_giver; $user_id_receiver = $value->user_id_receiver; $meetingId = $value->id; $status = $value->status; $CurrentTimeWithZone = KarmaHelper::calculateTime($meetingtimezone); if ($CurrentTimeWithZone > $meetingdatetime && $status == 'accepted') { Queue::push('MessageSender', array('type' => '4', 'user_id_giver' => $user_id_giver, 'user_id_receiver' => $user_id_receiver, 'meetingId' => $meetingId)); } if ($status == 'pending') { //echo"<pre>";print_r($value->id);echo"</pre>"; if (isset($value->user_id_giver)) { Queue::push('MessageSender', array('type' => '1', 'user_id_giver' => $user_id_giver, 'user_id_receiver' => $user_id_receiver, 'meetingId' => $meetingId)); } else { Queue::push('MessageSender', array('type' => '2', 'user_id_giver' => $value->connection_id_giver, 'user_id_receiver' => $user_id_receiver, 'meetingId' => $meetingId)); } } } } } } }