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 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'); } }