public function approve($id) { $Request = FriendRequest::find($id); if (!$Request) { echo json_encode(['success' => false]); return; } $Friend = new Friend(); $Friend->friend_id = $Request->sender_id; $Friend->user_id = $Request->recipient_id; $Friend->save(); $Friend = new Friend(); $Friend->user_id = $Request->sender_id; $Friend->friend_id = $Request->recipient_id; $Friend->save(); $result = $Request->delete(); echo json_encode(['success' => (bool) $result]); }
function run() { Friend::truncate(); $Friend = new Friend(); $Friend->user_id = 1; $Friend->friend_id = 2; $Friend->save(); $Friend = new Friend(); $Friend->user_id = 2; $Friend->friend_id = 1; $Friend->save(); $Friend = new Friend(); $Friend->user_id = 1; $Friend->friend_id = 3; $Friend->save(); $Friend = new Friend(); $Friend->user_id = 3; $Friend->friend_id = 1; $Friend->save(); $Friend = new Friend(); $Friend->user_id = 1; $Friend->friend_id = 4; $Friend->save(); $Friend = new Friend(); $Friend->user_id = 4; $Friend->friend_id = 1; $Friend->save(); $Friend = new Friend(); $Friend->user_id = 2; $Friend->friend_id = 3; $Friend->save(); $Friend = new Friend(); $Friend->user_id = 3; $Friend->friend_id = 2; $Friend->save(); $Friend = new Friend(); $Friend->user_id = 3; $Friend->friend_id = 4; $Friend->save(); $Friend = new Friend(); $Friend->user_id = 4; $Friend->friend_id = 3; $Friend->save(); }
public function deploy(Request $request) { $ids = $request->input('ids'); if (empty($ids)) { $gathers = Gather::select('id', 'title', 'category', 'description', 'telephone', 'address', 'road_address', 'latitude', 'longitude', 'deploy')->where([['deploy', '<>', true], ['delete', '<>', true]])->orderby('created_at', 'desc')->get(); } else { $where = explode(',', $ids); $gathers = Gather::select('id', 'title', 'category', 'description', 'telephone', 'address', 'road_address', 'latitude', 'longitude', 'deploy')->where([['deploy', '<>', true], ['delete', '<>', true]])->whereIn('id', $where)->orderby('created_at', 'desc')->get(); } $success = 0; foreach ($gathers as $item) { $friend = Friend::where('gather_id', $item->id)->first(); if (empty($friend)) { $friend = new Friend(); } // 업장정보 저장 $friend->type = $item->category; $friend->gather_id = $item->id; $friend->name = $item->title; $friend->latitude = $item->latitude; $friend->longitude = $item->longitude; $friend->address = $item->address; $friend->road_address = $item->road_address; $friend->tel = $item->telephone; $friend->description = $item->description; $friend->save(); // 수집자료 배포 상태 업데이트 $item->deploy = true; $item->save(); $success++; } // 배포 히스토리 저장 $deployHistory = new GatherDeployHistory(); $deployHistory->deploy_count = $success; $deployHistory->save(); return response()->json(['result' => 'success', 'count' => $gathers->count(), 'success' => $success]); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('friends')->delete(); Friend::create(['user_id' => '1', 'friend_id' => '2', 'initiator_id' => '1', 'status' => 'subscription']); Friend::create(['user_id' => '2', 'friend_id' => '1', 'initiator_id' => '1', 'status' => 'proposal']); Friend::create(['user_id' => '1', 'friend_id' => '3', 'initiator_id' => '1', 'status' => 'approved']); Friend::create(['user_id' => '3', 'friend_id' => '1', 'initiator_id' => '1', 'status' => 'approved']); Friend::create(['user_id' => '4', 'friend_id' => '1', 'initiator_id' => '4', 'status' => 'approved']); Friend::create(['user_id' => '1', 'friend_id' => '4', 'initiator_id' => '4', 'status' => 'approved']); Friend::create(['user_id' => '2', 'friend_id' => '3', 'initiator_id' => '2', 'status' => 'subscription']); Friend::create(['user_id' => '3', 'friend_id' => '2', 'initiator_id' => '2', 'status' => 'proposal']); Friend::create(['user_id' => '2', 'friend_id' => '9', 'initiator_id' => '9', 'status' => 'approved']); Friend::create(['user_id' => '9', 'friend_id' => '2', 'initiator_id' => '9', 'status' => 'approved']); Friend::create(['user_id' => '3', 'friend_id' => '4', 'initiator_id' => '3', 'status' => 'subscription']); Friend::create(['user_id' => '4', 'friend_id' => '3', 'initiator_id' => '3', 'status' => 'proposal']); Friend::create(['user_id' => '3', 'friend_id' => '5', 'initiator_id' => '3', 'status' => 'approved']); Friend::create(['user_id' => '5', 'friend_id' => '3', 'initiator_id' => '3', 'status' => 'approved']); Friend::create(['user_id' => '5', 'friend_id' => '6', 'initiator_id' => '5', 'status' => 'approved']); Friend::create(['user_id' => '6', 'friend_id' => '5', 'initiator_id' => '5', 'status' => 'approved']); Friend::create(['user_id' => '5', 'friend_id' => '7', 'initiator_id' => '5', 'status' => 'subscription']); Friend::create(['user_id' => '7', 'friend_id' => '5', 'initiator_id' => '5', 'status' => 'proposal']); Friend::create(['user_id' => '6', 'friend_id' => '3', 'initiator_id' => '6', 'status' => 'subscription']); Friend::create(['user_id' => '3', 'friend_id' => '6', 'initiator_id' => '6', 'status' => 'proposal']); Friend::create(['user_id' => '6', 'friend_id' => '7', 'initiator_id' => '6', 'status' => 'approved']); Friend::create(['user_id' => '7', 'friend_id' => '6', 'initiator_id' => '6', 'status' => 'proposal']); Friend::create(['user_id' => '7', 'friend_id' => '4', 'initiator_id' => '7', 'status' => 'subscription']); Friend::create(['user_id' => '4', 'friend_id' => '7', 'initiator_id' => '7', 'status' => 'proposal']); Friend::create(['user_id' => '7', 'friend_id' => '1', 'initiator_id' => '7', 'status' => 'approved']); Friend::create(['user_id' => '1', 'friend_id' => '7', 'initiator_id' => '7', 'status' => 'approved']); Friend::create(['user_id' => '8', 'friend_id' => '7', 'initiator_id' => '8', 'status' => 'subscription']); Friend::create(['user_id' => '7', 'friend_id' => '8', 'initiator_id' => '8', 'status' => 'proposal']); Friend::create(['user_id' => '8', 'friend_id' => '9', 'initiator_id' => '8', 'status' => 'approved']); Friend::create(['user_id' => '9', 'friend_id' => '8', 'initiator_id' => '8', 'status' => 'approved']); Friend::create(['user_id' => '8', 'friend_id' => '10', 'initiator_id' => '8', 'status' => 'approved']); Friend::create(['user_id' => '10', 'friend_id' => '8', 'initiator_id' => '8', 'status' => 'approved']); Friend::create(['user_id' => '9', 'friend_id' => '4', 'initiator_id' => '9', 'status' => 'subscription']); Friend::create(['user_id' => '4', 'friend_id' => '9', 'initiator_id' => '9', 'status' => 'proposal']); Friend::create(['user_id' => '9', 'friend_id' => '6', 'initiator_id' => '9', 'status' => 'approved']); Friend::create(['user_id' => '6', 'friend_id' => '9', 'initiator_id' => '9', 'status' => 'approved']); Friend::create(['user_id' => '9', 'friend_id' => '3', 'initiator_id' => '9', 'status' => 'approved']); Friend::create(['user_id' => '3', 'friend_id' => '9', 'initiator_id' => '9', 'status' => 'approved']); Friend::create(['user_id' => '10', 'friend_id' => '2', 'initiator_id' => '10', 'status' => 'subscription']); Friend::create(['user_id' => '2', 'friend_id' => '10', 'initiator_id' => '10', 'status' => 'proposal']); Friend::create(['user_id' => '10', 'friend_id' => '7', 'initiator_id' => '10', 'status' => 'approved']); Friend::create(['user_id' => '7', 'friend_id' => '10', 'initiator_id' => '10', 'status' => 'approved']); }
public function actionInfo() { $userId = Yii::$app->request->post('userId'); echo json_encode(['user' => Friend::getInfo($userId)]); die; }
/** * A function that will accept a friend ID and removed them from user friend list * * @return json array */ public function delete() { $my_id = Auth::id(); $my_friend = Input::get('id'); $friend = Friend::where('user_id', $my_id)->where('my_friend', $my_friend)->delete(); $data['status'] = 1; $data['friend'] = $friend; return $data; }
public function showUserFriends($id) { if (Auth::check()) { $friends = DB::table('friend')->join('user', 'friend.related_user_id', '=', 'user.id')->leftjoin('media', 'user.media_id', '=', 'media.id')->select('user.id', 'first_name', 'last_name', 'media.name AS photo', 'email', 'friend.status AS status')->where('user_id', $id)->where('related_user_id', '!=', Auth::user()->id)->where('user.is_deleted', '0')->where('user.is_enable', '1')->where('friend.status', 'friend')->get(); if ($friends) { foreach ($friends as $key => $value) { $friend = Friend::where('user_id', Auth::user()->id)->where('related_user_id', $value->id)->where('status', 'friend')->first(); if (!$friend) { $friends[$key]->isMyFriend = 0; } else { $friends[$key]->isMyFriend = 1; } } } return response()->json(['result' => 'success', 'data' => $friends], 200); } return response()->json(['result' => 'error'], 200); }
/** * @param Friend $modelFriend * @param $id * @param $fid * @return \Illuminate\Http\RedirectResponse */ public function remove(Friend $modelFriend, $id, $fid) { try { if ($modelFriend->removeFriendship($id, $fid)) { return redirect()->back(); } throw new Exception('Problem with database'); } catch (Exception $e) { return redirect()->back()->withErrors([$e->getMessage()]); } }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { Friend::find($id)->delete(); return redirect()->route('admin.friend.index'); }
public function delete($friend_id) { $user_id = $this->request->get('user_id'); $result = Friend::whereIn('user_id', [$user_id, $friend_id])->whereIn('friend_id', [$user_id, $friend_id])->delete(); echo json_encode(['success' => (bool) $result]); }
public function showAll() { if (Auth::check()) { $users = DB::table('user')->join('role', 'user.role_id', '=', 'role.id')->leftjoin('media', 'user.media_id', '=', 'media.id')->select('user.id', 'first_name', 'last_name', 'role.name AS role', 'media.name AS photo', 'email')->where('user.is_deleted', '=', '0')->where('user.is_enable', '=', '1')->where('user.id', '!=', Auth::user()->id)->get(); if ($users) { foreach ($users as $key => $value) { $friend = Friend::whereRaw('user_id = ? AND related_user_id = ?', [Auth::user()->id, $value->id])->first(); if ($friend) { $users[$key]->category = $friend->category->name; $users[$key]->status = $friend->status; } else { $users[$key]->category = null; $users[$key]->status = null; } } return response()->json(["data" => $users, "result" => "success"], 200); } else { return response()->json(["result" => "error_no_any_users"], 200); } } else { return response()->json(["result" => "error_access_deny"], 200); } }
public function data(Request $request) { $update_date = $request->input('update_date'); if (empty($update_date)) { $friends = Friend::all(); } else { $friends = Friend::where([['created_at', '>', $update_date], ['updated_at', '>', $update_date]])->get(); } return response()->json(['date' => $update_date, 'total' => $friends->count(), 'friends' => $friends], 200); }