public static function average($param)
{
// average review of last month
$average = Review::where(['active' => 1, 'staff_id' => $param])->whereBetween('created_at', [Carbon::now()->subMonths(1)->startOfMonth(), Carbon::now()->subMonths(1)->endOfMonth()])->get();
$avg = collect($average);
return $avg->avg('point');
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$title = "View Review";
$review = Review::where('staff_id', $id)->orderBy('created_at')->first();
// var_dump($review->toArray());exit();
return view('html.review.view', compact('review', 'title'));
}
/**
* Responds to requests to GET /reviews, shows all of a user's reviews
*/
public function getIndex()
{
// Get all the reviews "owned" by the current logged in user
// Sort in descending order by id
$reviews = \App\Review::where('user_id', '=', \Auth::id())->orderBy('id', 'DESC')->get();
return view('reviews.index')->with('reviews', $reviews);
}
public static function findUniqueUrl($title)
{
$count = Review::where('title', $title)->count();
if ($count > 0) {
return self::titleToUrl($title . '-' . $count);
}
return self::titleToUrl($title);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
if (!Settings::item('page_review')) {
abort(404);
}
$review = Review::where('active', 1)->orderBy('id', 'DESC')->paginate(10);
return view('review.index', ['reviews' => $review]);
}
/**
* @param TravelCompany $travelCompany
* @param $slug
*
* @internal param $travel_companies
*
* @return \Illuminate\View\View
*/
public function single(TravelCompany $travelCompany, $slug)
{
$company = $travelCompany->where('slug', $slug)->first();
$stations = $company->stations;
$reviews = Review::where('travel_company_id', $company->id)->get();
$images = $company->travel_company_picture;
$bus_features = $company->bus_features;
// dd($images);
return view('companies.terminal', ['company' => $company, 'stations' => $stations, 'reviews' => $reviews, 'images' => $images, 'bus_features' => $bus_features]);
}
public function getViewproduct($id)
{
$product = Product::find($id);
if ($product == null) {
return redirect('dashboard')->with(['message' => 'Invalid Request.', 'type' => 'danger']);
}
$favourite = Preference::where('user_id', Auth::user()->id)->where('product_id', $id)->first();
$review = Review::where('user_id', Auth::user()->id)->where('product_id', $id)->first();
$allReviews = $this->orderReview($id);
$allComparisons = $this->userSkinComparison($id);
return view('product')->with('product', $product)->with(['favourite' => $favourite, 'review' => $review, 'allReviews' => $allReviews, 'allComparisons' => $allComparisons]);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
if ($customer = $this->getRentalHistory($id)) {
$reviews = Review::where('customer_id', $id)->with('movie')->get()->toArray();
$wishlist = Wishlist::where('customer_id', $id)->with('movies')->get()->toArray();
// dd($wishlist);
return view('customers.show')->with('customer', $customer)->with('reviews', $reviews)->with('wishlist', $wishlist);
}
// User doesn't exist for this account
$this->setMessage('Customer not found!', 'error');
return redirect('/customers');
}
/**
* @param $id
* @param int $skip
* @param int $take
*
* @return mixed
*/
public static function getReviewsById($id, $uid = false, $skip = 0, $take = 10)
{
$data = ['product_id' => $id];
if ($uid) {
$data['uid'] = $uid;
}
$result = Review::where($data)->skip($skip)->take($take)->get();
if ($uid) {
$result = !empty($result[0]) ? $result[0] : false;
}
return $result;
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index(Request $request)
{
$validator = Validator::make($request->all(), ['function' => 'required']);
if ($validator->fails()) {
if ($validator->errors()->has('function')) {
return response()->json($validator->errors()->first('function'), 400);
}
}
$function = $request->function;
$total_ratings = Review::where('function', $function)->sum('ratings');
$total_count = Review::where('function', $function)->count();
$ratings = $total_ratings / $total_count;
return response()->json(['total_ratings' => round($ratings, 1), 'total_users' => $total_count]);
}
public function __construct(User $user, Request $request, Review $review)
{
//ミドルウェアでゲストユーザをフィルタ
$this->middleware('auth');
if (!Auth::check()) {
//ログインチェック
return redirect()->to("/auth/login");
}
//他人のレビューを改竄しようとしたユーザーをフィルタ
$this->middleware("validReviewer", ["only" => ["getEdit", "postEditConfirm", "postEditComplete", "postDeleteConfirm", "postDeleteComplete"]]);
$user_id = $request->user()->user_id;
$this->user = $user->find($user_id);
$this->review = $review->where('user_id', '=', $user_id)->get();
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$author = User::where('name', '=', 'Jamie Shepherd')->first();
$node = Node::where('category', '=', 'films')->where('title', '=', 'Inception')->first();
$review = new Review();
$review->author = array('reference' => $author->_id, 'name' => $author->name, 'gravatar' => md5(strtolower(trim($author->email))));
$review->node = array('reference' => $node->_id, 'title' => $node->title);
$review->score = 7.9;
$review->review = 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.';
$review->thumbs = 0;
$review->save();
$node->avg = number_format(round(Review::where('node.reference', $node->_id)->avg('score'), 1), 1);
$node->increment('reviewCount');
$node->save();
}
public function postDelete(ReviewRequest $request, Review $review)
{
try {
$input = $request->all();
$id = $input['id'];
$deleteReview = $review->where('id', $id)->first();
$deleteReview->delete();
$message = 'Delete Success';
$msg_type = 'success';
} catch (Exception $e) {
$message = 'Delete Error';
$msg_type = 'danger';
// return response()->json((['error'=>$e->getMessage()]), 422);
}
return $message;
// return redirect('/product')->with([
// 'message' => $message,
// 'type' => $msg_type,
// ]);
}
public function getIndex()
{
$products = Product::all();
foreach ($products as $aProduct) {
$related_usr = array();
$favs = Preference::where('product_id', $aProduct->id)->where('flag', '1')->get();
foreach ($favs as $aFav) {
array_push($related_usr, $aFav->user);
}
$reviews = Review::where('product_id', $aProduct->id)->where('rating', '1')->get();
foreach ($reviews as $aReview) {
if (!in_array($aReview->user, $related_usr)) {
array_push($related_usr, $aReview->user);
}
}
if (count($related_usr) > 4) {
$aProduct->gettrained($related_usr);
}
}
}
/**
* Post the review form.
*
* @return Response
*/
public function postAddReview(Request $request)
{
//validation
$v = Validator::make($request->all(), ['star' => 'required|integer|in:1,2,3,4,5', 'review' => 'required|string']);
//Checking validation outcome
if ($v->fails()) {
/**
* Validation failed
* Redirecting back to the page with errors and inputs
*/
return back()->withErrors($v)->withInput();
} else {
/**
* Validation passed
* Checking if the learner has already submitted a review for the instructor
*/
$no_of_review = Review::where('learner_id', $request->user()->learner->learner_id)->where('Instructor_id', $request->instructor_id)->count();
if ($no_of_review == 0) {
//If no review has submitted for the selected instructor by the current user
//Create the review
$review = Review::create(['learner_id' => $request->user()->learner->learner_id, 'instructor_id' => $request->instructor_id, 'rating' => $request->star, 'review' => $request->review]);
if ($review) {
//If review is created successfully
//Send an e-mail to the instructor
/*Write an e-mail function here*/
//Redirect the user
return redirect()->route('home')->with('message', 'Review added')->with('alert-class', 'alert-success');
} else {
//If creating review was unsuccessfull
return redirect()->route('home')->with('message', 'Review could not be added')->with('alert-class', 'alert-danger');
}
//End of if statement
} else {
//If review has been submitted previously for the selected instructor by the current user
return redirect()->route('home')->with('message', 'You have already submitted a review for this instructor!')->with('alert-class', 'alert-danger');
}
//End of if statement
}
//End of if statement
}
/**
* @return \Illuminate\Http\JsonResponse
*/
public function review()
{
header("Access-Control-Allow-Origin: *");
$response = new YYResponse(FALSE, 'Something went wrong.');
$validator = Validator::make(Request::all(), ['product_id' => 'required|integer', 'uid' => 'required|integer', 'rating' => 'required|integer']);
if ($validator->fails()) {
$response->errors = $validator->errors();
return response()->json($response);
}
$review = Review::where(['uid' => Request::get('uid'), 'product_id' => Request::get('product_id')])->first();
if (!$review) {
$review = new Review();
}
$review->comment = Request::get('comment', null);
$review->uid = Request::get('uid');
$review->product_id = Request::get('product_id');
$review->rating = Request::get('rating');
if ($review->save()) {
$response->state = true;
$response->message = 'Review created.';
}
return response()->json(['state' => TRUE]);
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function showItemDetail($slug, $id)
{
$data['item'] = Items::findOrFail($id);
$item = Items::findOrFail($id);
if (is_dir(public_path() . '/uploads/photos/' . $id . '/')) {
$photos = scandir(public_path() . '/uploads/photos/' . $id . '/', 1);
$files = array_diff($photos, array('.', '..'));
} else {
$files = [];
}
$data['review'] = Review::where('item_id', $id)->get();
$data['item_id'] = $id;
$data['itemphotos'] = $files;
$data['colors'] = Items::find($id)->ItemColors()->get();
$data['sizes'] = Items::find($id)->ItemSize()->get();
$data['partner'] = Partner::orderBy('created_at', 'asc')->get();
$data['category'] = Category::with('SubCategory')->orderBy('created_at', 'asc')->get();
$data['topseller'] = Items::where('category_id', '1')->get();
$data['categorytop'] = Category::findOrFail($item->category_id);
$data['subcategorytop'] = SubCategory::findOrFail($item->subcategory_id);
$data['related'] = Items::where('category_id', $item->category_id)->get();
return view('site.item-detail', $data);
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function create($category, $slug)
{
$node = Node::where('category', $category)->where('slug', $slug)->first();
$score = 0.0;
if (Input::get('score') == 10) {
$score = 10;
} else {
$score = Input::get('score');
}
// If it's the first review, reward the user
if (Review::where('node.reference', $node->_id)->count() == 0) {
Auth::user()->points += 1000;
Auth::user()->save();
}
// Create the review
$review = new Review();
$review->node = array('reference' => $node->_id, 'title' => $node->title);
$review->author = array('reference' => Auth::user()->_id, 'name' => Auth::user()->name, 'gravatar' => md5(strtolower(trim(Auth::user()->email))));
$review->score = (double) $score;
$review->review = Input::get('review');
$review->thumbs = 0;
$review->spoilers = Input::has('spoilers');
$review->save();
if ($review->score < 4) {
$node->increment('overall_negative');
} else {
if ($review->score < 7) {
$node->increment('overall_mixed');
} else {
$node->increment('overall_positive');
}
}
$node->avg = number_format(round(Review::where('node.reference', $node->_id)->avg('score'), 1), 1);
$node->increment('reviewCount');
$node->save();
return back();
}
<div class="centered_text">
<div class="align_left">
Location: {{$landmark->location}} <br>
Description: {{$landmark->description}} <br>
Tags:
@if((count($landmark->tags))===0)
{{' None'}}
@else
@foreach($landmark->tags as $tag)
{{$tag->tag.' '}}
@endforeach
@endif
</div>
</div>
<?php
$reviews = \App\Review::where('landmark_id', '=', $landmark->id)->orderBy('id')->get();
?>
@if(empty($reviews->first()))
<h2>No Reviews (Yet!)...</h2>
@if(Auth::check())
<div class="centered_text">
<a href="/reviews/{{$landmark->id}}/create" class="centered_text">Add </a>a review?
</div>
@endif
@else
<h2>Reviews:</h2>
<div class="container">
@foreach($reviews as $review)
<?php
$users = \App\User::where('id', '=', $review->user_id)->get();
foreach ($users as $user) {
public function getViewCount($id)
{
return Review::where('fr_usr_id', $id)->sum('fr_views');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
if (Gate::allows('check-leader')) {
$staff = Staff::find($id)->level->role;
if ($staff->name != "Developer") {
return redirect()->route('admin.staff.index')->with('message', 'Access is denied');
}
}
if (Gate::allows('check-admin')) {
$staff = Staff::find($id)->level->role;
if ($staff->name == "Developer") {
return redirect()->route('admin.staff.index')->with('message', 'Access is denied');
}
}
if (Gate::allows('check-developer')) {
return redirect()->route('admin.department.index')->with('message', 'Access is denied');
}
// if staff belongsto one team
$findStaff = StaffTeam::where('staff_id', $id)->get()->toArray();
if (!empty($findStaff)) {
return redirect()->route('admin.staff.index')->with('message', 'The staff belongto team !');
}
$staff = Staff::find($id);
$staff->delete();
// delete staff in review
$staffReview = Review::where('reviewer_id', $id)->delete();
$staffReview = Review::where('staff_id', $id)->delete();
// delete staff in staff_team
$staffReview = StaffTeam::where('staff_id', $id)->delete();
return redirect()->route('admin.staff.index')->with('message', 'Delete staff complete !');
}
/**
* Display the review page
* @param int $id
* @return Response
*/
public function studioReviews($id, Request $request)
{
if (!$request->ajax()) {
dd("NO ASYNC REQUEST");
}
$studio = Studio::find($id);
$isStudioProfile = false;
$reviews = Review::where('user_id', $studio->user->id)->orderBy('created_at', 'desc')->get();
if (Auth::check()) {
if ($studio->user_id == Auth::User()->id) {
$isStudioProfile = true;
}
}
return view('ajax.reviews', ['profile' => $studio, 'isSelf' => $isStudioProfile, 'reviews' => $reviews]);
}
}
?>
<div class="image">
<img style='width:20%' src={{$filepath}}>
</div>
<div class="centered_text">
@if(Auth::check())
<a href='/reviews'>All your reviews</a> |
<a href='/landmarks/show/{{$landmark->id}}'>All reviews of {{$landmark->name}}</a> |
<a href='/reviews/{{$landmark->id}}/create'>Add a review</a> |
<a href='/photos/{{$landmark->id}}/create'>Add a photo</a>
@else
@endif
</div>
<?php
$reviews = \App\Review::where('landmark_id', '=', $landmark->id)->where('user_id', '=', \Auth::id())->get();
?>
@if(empty($reviews->first()))
<h2>No Reviews of {{$landmark->name}} (Yet!)...</h2>
<div class="centered_text">
<a href="/reviews/{{$landmark->id}}/create" class="centered_text">Add </a>a review?
</div>
@else
<h2>Your Reviews of {{$landmark->name}}</h2>
<div class="container">
@foreach($reviews as $review)
<div class="review_results_container">
{{$review->review}}
</div>
@endforeach
</div>
/**
* Show a single recipe.
*
* @param Recipe $recipe
* @return Response
*/
public function show(Recipe $recipe)
{
$comments = Comment::where('recipe_id', '=', $recipe->id)->where('review_id', '=', null)->get();
$reviews = Review::where('recipe_id', '=', $recipe->id)->get();
return view('recipes.show', compact('recipe', 'comments', 'reviews'));
}
public function show($requirementId)
{
$review = Review::where('requirement_id', $requirementId)->where('status', 'unexamined')->first();
return $review;
}
public function update2(Request $request, $episode_id)
{
$this->validate($request, ['content' => 'required_with:title', 'visible' => 'required_with:content', 'type' => 'required|in:0,2,4', 'rating' => 'in:0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5', 'title' => 'max:255']);
$favorite = Epfav::where('user_id', $request->user()->id)->where('episode_id', $episode_id)->first();
$oldType = $favorite->type;
$favorite->type = $request->input('type');
if ($favorite->type == 0) {
$favorite->rating = 0;
} else {
$favorite->rating = $request->input('rating');
}
//修改收藏
$result = DB::table('epfavs')->where('user_id', $favorite->user_id)->where('episode_id', $episode_id)->update(['type' => $favorite->type, 'rating' => $favorite->rating, 'updated_at' => date("Y-m-d H:i:s")]);
if ($result) {
DB::table('users')->where('id', $favorite->user_id)->decrement('epfav' . $oldType);
DB::table('users')->where('id', $favorite->user_id)->increment('epfav' . $favorite->type);
$review = Review::where('user_id', $favorite->user_id)->where('episode_id', $episode_id)->first();
if ($review) {
$review->title = $request->input('title');
$review->content = $request->input('content');
$review->visible = $request->input('visible');
if (!$review->save()) {
return redirect()->back()->withInput()->withErrors('收藏修改成功，评论修改失败');
}
} else {
if ($request->has('content')) {
$review = new Review();
$review->user_id = $favorite->user_id;
$review->drama_id = $request->input('drama_id');
$review->episode_id = $favorite->episode_id;
$review->title = $request->input('title');
$review->content = $request->input('content');
$review->visible = $request->input('visible');
if ($review->save()) {
DB::table('users')->where('id', $review->user_id)->increment('reviews');
DB::table('dramas')->where('id', $review->drama_id)->increment('reviews');
DB::table('episodes')->where('id', $review->episode_id)->increment('reviews');
} else {
return redirect()->back()->withInput()->withErrors('收藏修改成功，评论添加失败');
}
}
}
return redirect()->route('episode.show', [$episode_id]);
} else {
return redirect()->back()->withInput()->withErrors('修改失败');
}
}
/**
* Display a user profile
*
* @param string $id
* @return Response
*/
public function getProfile($id)
{
$user = User::where('_id', $id)->first();
$reviews = Review::where('author.reference', $user->_id)->get();
return view('users.profile')->with('user', $user)->with('reviews', $reviews);
}
public function pluslike($id, $opt)
{
$f = Review::where("id", "=", $id)->first();
if ($opt == '1') {
$f->likes = $f->likes + 1;
} else {
$f->unlikes = $f->unlikes + 1;
}
$f->save();
return;
}
/**
* Display the specified resource.
*
* @param string $category
* @param string $slug
* @return Response
*/
public function show($category, $slug)
{
$node = Node::where('category', $category)->where('slug', $slug)->first();
$userReview = null;
if ($node->reviewCount > 0 && Auth::user()) {
$userReview = Review::where('node.reference', $node->_id)->where('author.reference', Auth::user()->id)->first();
if ($userReview) {
$userReview = $userReview->review;
}
}
return view('nodes.show')->with('node', $node)->with('userReview', $userReview);
}
public function update2(Request $request, $episode_id)
{
$validator = Validator::make($request->all(), ['content' => 'required_with:title', 'visible' => 'required_with:content', 'type' => 'required|in:0,2,4', 'rating' => 'in:0,0.5,1,1.5,2,2.5,3,3.5,4,4.5,5', 'title' => 'max:255']);
if ($validator->fails()) {
return response($validator->messages(), 422);
}
$favorite = Epfav::where('user_id', $request->user()->id)->where('episode_id', $episode_id)->first();
$oldType = $favorite->type;
$favorite->type = $request->input('type');
if ($favorite->type == 0) {
$favorite->rating = 0;
} else {
$favorite->rating = $request->input('rating');
}
$result = DB::table('epfavs')->where('user_id', $favorite->user_id)->where('episode_id', $episode_id)->update(['type' => $favorite->type, 'rating' => $favorite->rating, 'updated_at' => date("Y-m-d H:i:s")]);
if ($result) {
DB::table('users')->where('id', $favorite->user_id)->decrement('epfav' . $oldType);
DB::table('users')->where('id', $favorite->user_id)->increment('epfav' . $favorite->type);
$review = Review::where('user_id', $favorite->user_id)->where('episode_id', $episode_id)->first();
if ($review) {
$review->title = $request->input('title');
$review->content = $request->input('content');
$review->visible = $request->input('visible');
if (!$review->save()) {
return response('收藏修改成功，评论修改失败> <', 422);
}
} else {
if ($request->has('content')) {
$review = new Review();
$review->user_id = $favorite->user_id;
$review->drama_id = $request->input('drama_id');
$review->episode_id = $favorite->episode_id;
$review->title = $request->input('title');
$review->content = $request->input('content');
$review->visible = $request->input('visible');
if ($review->save()) {
DB::table('users')->where('id', $review->user_id)->increment('reviews');
DB::table('dramas')->where('id', $review->drama_id)->increment('reviews');
DB::table('episodes')->where('id', $review->episode_id)->increment('reviews');
} else {
return response('收藏修改成功，评论添加失败> <', 422);
}
}
}
return ['result' => 'success'];
} else {
return response('修改失败> <', 422);
}
}
