public static function storeKarmacirclesRecord() { $users = DB::table('users')->get(); if (!empty($users)) { foreach ($users as $user_info) { $UserskarmaCircle = Karmacircle::where('user_id', '=', $user_info->id)->delete(); $user_circle_giver = DB::table('karmanotes')->select('user_idgiver')->distinct()->where('karmanotes.user_idreceiver', '=', $user_info->id)->get(); $user_circle_receiver = DB::table('karmanotes')->select('user_idreceiver')->distinct()->where('karmanotes.user_idgiver', '=', $user_info->id)->get(); $karmaCircle = new Karmacircle(); if (!empty($user_info)) { $karmaCircle->user_id = $user_info->id; } //code to save givers id. if (!empty($user_circle_giver)) { $user_circle_giver_data = ''; foreach ($user_circle_giver as $key => $value) { $user_circle_giver_data[] = $value->user_idgiver; } if (!empty($user_circle_giver_data)) { $user_circle_giver_data = array_filter($user_circle_giver_data); $karmaCircle->givers = implode(',', $user_circle_giver_data); } } //code to save recivers id. if (!empty($user_circle_receiver)) { $user_circle_receiver_data = ''; foreach ($user_circle_receiver as $key => $value) { $user_circle_receiver_data[] = $value->user_idreceiver; } if (!empty($user_circle_receiver_data)) { $user_circle_receiver_data = array_filter($user_circle_receiver_data); $karmaCircle->receivers = implode(',', $user_circle_receiver_data); } } //code to save receiver's receiver id. if (!empty($user_circle_receiver_data)) { $users_receivers = DB::table('karmanotes')->select('user_idreceiver')->distinct()->whereIn('user_idgiver', $user_circle_receiver_data)->get(); $user_circle_receiver_receiver_data = ''; foreach ($users_receivers as $key => $value_receiver) { $user_circle_receiver_receiver_data[] = $value_receiver->user_idreceiver; } } if (!empty($user_circle_receiver_receiver_data)) { $user_circle_receiver_receiver_data = array_filter($user_circle_receiver_receiver_data); $karmaCircle->receivers_receivers = implode(',', $user_circle_receiver_receiver_data); } $karmaCircle->save(); } return Redirect::to('dashboard'); } }
public static function storeKarmacirclesRecord($giver, $receiver) { if (!empty($receiver)) { $UserskarmaCircle = Karmacircle::where('user_id', '=', $receiver)->delete(); $user_circle_giver = DB::table('karmanotes')->select('user_idgiver')->distinct()->where('karmanotes.user_idreceiver', '=', $receiver)->get(); $user_circle_receiver = DB::table('karmanotes')->select('user_idreceiver')->distinct()->where('karmanotes.user_idgiver', '=', $receiver)->get(); $karmaCircle = new Karmacircle(); if (!empty($receiver)) { $karmaCircle->user_id = $receiver; } //code to save givers id. if (!empty($user_circle_giver)) { $user_circle_giver_data = ''; foreach ($user_circle_giver as $key => $value) { $user_circle_giver_data[] = $value->user_idgiver; } if (!empty($user_circle_giver_data)) { $user_circle_giver_data = array_filter($user_circle_giver_data); $user_circle_giver_data = json_encode($user_circle_giver_data); $karmaCircle->givers = $user_circle_giver_data; } } //code to save recivers id. if (!empty($user_circle_receiver)) { $user_circle_receiver_data = ''; foreach ($user_circle_receiver as $key => $value) { $user_circle_receiver_data[] = $value->user_idreceiver; } if (!empty($user_circle_receiver_data)) { $user_circle_receiver_data = array_filter($user_circle_receiver_data); $user_circle_receiver_data = json_encode($user_circle_receiver_data); $karmaCircle->receivers = $user_circle_receiver_data; } } //code to save receiver's receiver id. if (!empty($user_circle_receiver_data)) { $user_circle_receiver_data = json_decode($user_circle_receiver_data); $users_givers_takers = DB::table('karmanotes')->select('user_idreceiver')->distinct()->whereIn('user_idgiver', $user_circle_receiver_data)->get(); $user_circle_giver_receiver_data = ''; foreach ($users_givers_takers as $key => $value_giver_taker) { $user_circle_giver_receiver_data[] = $value_giver_taker->user_idreceiver; } } if (!empty($user_circle_giver_receiver_data)) { $user_circle_giver_receiver_data = array_filter($user_circle_giver_receiver_data); $user_circle_giver_receiver_data = json_encode($user_circle_giver_receiver_data); $karmaCircle->receivers_receivers = $user_circle_giver_receiver_data; } //code to save giver's giver id. /* if(!empty($user_circle_giver_data)){ $user_circle_giver_data=array_filter($user_circle_giver_data); $users_givers_givers = DB::table('karmanotes')->select('user_idgiver')->distinct()->whereIn('user_idreceiver', $user_circle_giver_data)->get(); $user_circle_giver_giver_data=''; foreach ($users_givers_givers as $key => $value_giver_giver) { $user_circle_giver_giver_data[]=$value_giver_giver->user_idgiver; } } if(!empty($user_circle_giver_giver_data)){ $user_circle_giver_giver_data=array_filter($user_circle_giver_giver_data); $karmaCircle->givers_givers = implode(',', $user_circle_giver_giver_data); }*/ $karmaCircle->save(); } if (!empty($giver)) { $UserskarmaCircle = Karmacircle::where('user_id', '=', $giver)->delete(); $user_circle_giver = DB::table('karmanotes')->select('user_idgiver')->distinct()->where('karmanotes.user_idreceiver', '=', $giver)->get(); $user_circle_receiver = DB::table('karmanotes')->select('user_idreceiver')->distinct()->where('karmanotes.user_idgiver', '=', $giver)->get(); $karmaCircle = new Karmacircle(); if (!empty($giver)) { $karmaCircle->user_id = $giver; } //code to save givers id. if (!empty($user_circle_giver)) { $user_circle_giver_data = ''; foreach ($user_circle_giver as $key => $value) { $user_circle_giver_data[] = $value->user_idgiver; } if (!empty($user_circle_giver_data)) { $user_circle_giver_data = array_filter($user_circle_giver_data); $karmaCircle->givers = implode(',', $user_circle_giver_data); } } //code to save recivers id. if (!empty($user_circle_receiver)) { $user_circle_receiver_data = ''; foreach ($user_circle_receiver as $key => $value) { $user_circle_receiver_data[] = $value->user_idreceiver; } if (!empty($user_circle_receiver_data)) { $user_circle_receiver_data = array_filter($user_circle_receiver_data); $karmaCircle->receivers = implode(',', $user_circle_receiver_data); } } //code to save receiver's receiver id. if (!empty($user_circle_receiver_data)) { $user_circle_receiver_data = array_filter($user_circle_receiver_data); $users_givers_takers = DB::table('karmanotes')->select('user_idreceiver')->distinct()->whereIn('user_idgiver', $user_circle_receiver_data)->get(); $user_circle_giver_receiver_data = ''; foreach ($users_givers_takers as $key => $value_giver_taker) { $user_circle_giver_receiver_data[] = $value_giver_taker->user_idreceiver; } } if (!empty($user_circle_giver_receiver_data)) { $user_circle_giver_receiver_data = array_filter($user_circle_giver_receiver_data); $karmaCircle->receivers_receivers = implode(',', $user_circle_giver_receiver_data); } //code to save giver's giver id. // if(!empty($user_circle_giver_data)){ // $user_circle_giver_data=array_filter($user_circle_giver_data); // $users_givers_givers = DB::table('karmanotes')->select('user_idgiver')->distinct()->whereIn('user_idreceiver', $user_circle_giver_data)->get(); // $user_circle_giver_giver_data=''; // foreach ($users_givers_givers as $key => $value_giver_giver) { // $user_circle_giver_giver_data[]=$value_giver_giver->user_idgiver; // } // } // if(!empty($user_circle_giver_giver_data)){ // $user_circle_giver_giver_data=array_filter($user_circle_giver_giver_data); // $karmaCircle->givers_givers = implode(',', $user_circle_giver_giver_data); // } $karmaCircle->save(); } return true; }
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."; } }