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.";
}
}
