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