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